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

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 1000 10 10000 1000 10 10000
2014-01-09 00:00:00 1000 12 12000 2000 11 22000
2014-01-12 00:00:00 1200 11 13200 800 11 8800
2014-01-15 00:00:00 1000 12.8 12800 1800 12 21600
2014-01-16 00:00:00 200 12.8 2560 1600 11.9 19040
2014-01-19 00:00:00 600 11.9 7140 1000 11.9 11900
2014-01-24 00:00:00 1000 13.1 13100 2000 12.5 25000
2014-01-25 00:00:00 800 12.5 10000 1200 12.5 15000
2014-01-27 00:00:00 600 12.5 7500 600 12.5 7500
2014-01-31 00:00:00 800 13.15 10520 1400 12.871428571428572 18020