Booklet 5 Inventory Costing Solutions Booklet M5.xlsx - Ex 2.87 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-02-01 00:00:00 10000 1 10000 10000 1 10000
2014-02-02 00:00:00 5000 1 5000 5000 1 5000
2014-02-03 00:00:00 1000 1 1000 4000 1 4000
2014-02-08 00:00:00 5000 1.18 5900 9000 1.1 9900
2014-02-20 00:00:00 4000 1.1 4400 5000 1.1 5500
2014-03-06 00:00:00 2000 1.1 2200 3000 1.1 3300
2014-03-09 00:00:00 3000 1.2 3600 6000 1.15 6900
2014-03-27 00:00:00 5000 1.26 6300 11000 1.2 13200
2014-03-28 00:00:00 3000 1.2 3600 8000 1.2 9600
2014-03-29 00:00:00 1000 1.26 1260 7000 1.1914285714285715 8340