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

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-02-01 00:00:00 150 12 1800 150 12 1800
2014-02-04 00:00:00 200 12.7 2540 350 12.4 4340
2014-02-05 00:00:00 160 12.4 1984 190 12.4 2356
2014-02-09 00:00:00 90 12.4 1116 100 12.4 1240
2014-02-12 00:00:00 250 13.1 3275 350 12.9 4515
2014-02-14 00:00:00 110 12.9 1419 240 12.9 3096
2014-02-20 00:00:00 300 12.36 3708 540 12.6 6804
2014-02-21 00:00:00 60 12.36 741.5999999999999 480 12.629999999999999 6062.4
2014-02-23 00:00:00 180 12.629999999999999 2273.3999999999996 300 12.63 3789
2014-02-27 00:00:00 100 12.63 1263 200 12.63 2526