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

Back to sheets

STOCK INVENTORY 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 20000 0.5 10000 20000 0.5 10000
2014-01-04 00:00:00 10000 0.5 5000 10000 0.5 5000
2014-01-08 00:00:00 5000 0.59 2950 15000 0.53 7950
2014-01-09 00:00:00 6000 0.53 3180 9000 0.53 4770
2014-01-10 00:00:00 5000 0.67 3350 14000 0.58 8120
2014-01-11 00:00:00 6000 0.58 3479.9999999999995 8000 0.58 4640
2014-01-17 00:00:00 1000 0.67 670 7000 0.5671428571428572 3970