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

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-01-01 00:00:00 600 1 600 600 1 600
2014-02-03 00:00:00 200 1.2 240 800 1.05 840
2014-02-15 00:00:00 200 1.05 210 600 1.05 630
2014-03-14 00:00:00 250 1.22 305 850 1.1 935
2014-03-28 00:00:00 75 1.22 91.5 775 1.0883870967741935 843.5
2014-04-09 00:00:00 300 1.24 372 1075 1.1306976744186046 1215.5
2014-04-15 00:00:00 400 1.13 451.99999999999994 675 1.1311111111111112 763.5
2014-06-06 00:00:00 300 1.29 387 975 1.18 1150.5
2014-06-17 00:00:00 350 1.18 413 625 1.18 737.5