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

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	300	12	3600				300	12	3600

2014-01-15 00:00:00	300	14	4200				600	13	7800

2014-01-20 00:00:00				240	13	3120	360	13	4680

2014-01-25 00:00:00				160	13	2080	200	13	2600

2014-02-02 00:00:00	100	16	1600				300	14	4200

2014-02-12 00:00:00	100	18	1800				400	15	6000

2014-02-16 00:00:00				300	14	4200	100	18	1800

2014-02-20 00:00:00	400	18.5	7400				500	18.4	9200

2014-02-22 00:00:00				200	18.4	3679.9999999999995	300	18.4	5520

2014-03-01 00:00:00	100	19	1900				400	18.55	7420

2014-03-03 00:00:00	200	19.2	3840				600	18.766666666666666	11260

2014-03-07 00:00:00				200	18.77	3754	400	18.765	7506

2014-03-15 00:00:00				100	18.77	1877	300	18.763333333333332	5629

2014-03-19 00:00:00	100	19.6	1960.0000000000002				400	18.9725	7589

2014-03-22 00:00:00	200	20.8	4160				600	19.581666666666667	11749

2014-03-30 00:00:00				240	19.58	4699.2	360	19.58277777777778	7049.8