Booklet 5 Inventory Costing Solutions Booklet M5.xlsx - Ex 2.88

Back to sheets

INVENTORY RECORD CARD Unnamed: 1 Unnamed: 2 Unnamed: 3 Unnamed: 4 Unnamed: 5 Unnamed: 6 Unnamed: 7 Unnamed: 8 Unnamed: 9
Method of Inventory Valuation - AVCO
RECEIPTS ISSUES BALANCE
Date Quantity Unit Price Value Quantity Unit Price Value Quantity Unit Price Value
£ £ £ £ £ £
2014-04-01 00:00:00 400 1 400 400 1 400
2014-04-02 00:00:00 150 1 150 250 1 250
2014-04-03 00:00:00 50 1 50 200 1 200
2014-04-08 00:00:00 200 1.3 260 400 1.15 460
2014-04-20 00:00:00 200 1.15 229.99999999999997 200 1.1500000000000001 230.00000000000003
2014-05-06 00:00:00 20 1.1500000000000001 23.000000000000004 180 1.1500000000000001 207.00000000000003
2014-05-09 00:00:00 300 1.23 369 480 1.2 576
2014-05-27 00:00:00 500 1.3 650 980 1.2510204081632652 1226
2014-05-28 00:00:00 300 1.25 375 680 1.2514705882352941 851
2014-05-31 00:00:00 100 1.3 130 580 1.243103448275862 721