Booklet 5 Inventory Costing Solutions Booklet M5.xlsx - Ex 2.82 F

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-14 00:00:00 400 15 6000 400 15 6000
2014-02-09 00:00:00 100 15.75 1575 500 15.15 7575
2014-03-11 00:00:00 200 17.6 3520.0000000000005 700 15.85 11095
2014-03-14 00:00:00 320 15.85 5072 380 15.85 6023
2014-04-27 00:00:00 200 16.43 3286 580 16.05 9309
2014-05-14 00:00:00 320 16.05 5136 260 16.05 4173
2014-05-15 00:00:00 100 16.43 1643 160 15.8125 2530