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

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-11 00:00:00 50 3.72 186 50 3.72 186
2014-01-23 00:00:00 20 4.35 87 70 3.9 273
2014-02-07 00:00:00 100 3.39 339 170 3.6 612
2014-02-09 00:00:00 40 3.6 144 130 3.6 468
2014-02-14 00:00:00 20 5.4 108 150 3.84 576
2014-02-18 00:00:00 40 3.84 153.6 110 3.84 422.4
2014-02-22 00:00:00 5 4.53 22.650000000000002 115 3.8699999999999997 445.04999999999995
2014-02-24 00:00:00 5 5.4 27 110 3.800454545454545 418.04999999999995