Transactions									UNIT	FIFO	ENDING		UNIT	AVERAGE	ENDING
Jan 1 – Balance carry forward 100 units @ $10 each									100	1000	1000		100	1000
Jan 5 – Purchased 100 units @ $11 each									100	1100	1100		100	1100	2100 @10.50 EACH
Jan 10 – Sold 50 units									-50	-500	1600		-50	-525	1575
Jan 12 – Purchased 200 units @ $9									200	1800	3400		200	1800	3375@ 9.64 EACH
Jan 14 – Sold 150 units								JAN 1 + JAN 5	(50 + 100)	-1600	1800		-150	-1446	1929
Jan 20 – Sold 50 units								12-Jan	-50	-450	1350		-50	-482	1447
Jan 30 – Purchased 100 units @ $10									100	1000	2350		100	1000	2447	(2447/250= 9.79 EACH)
								ENDING BALANCE	250		2350	ENDING BALANCE	250		2447
AT WHAT COST IF WE APPLY FIFO SYSTEM										UNIT	LIFO	ENDING
JAN 5 –									30-Jan	100	1000	1000
JAN 10 –									12-Jan	200	1800	2800
JAN 14 –									05-Jan	100	1100	3900
JAN 20 –									01-Jan	100	1000	4900
								SOLD	10-Jan	-50	-500	4400
AT WHAT COST IF WE APPLY AVERAGE SYSTEM								SOLD	14-Jan	(50+100)	(500+900)	3000	JAN 30 + JAN 12
JAN 5 –								SOLD	20-Jan	-50	-450	2550
JAN 10 –								ENDING BALANCE		250		2550
JAN 14 –
JAN 20 –
AT WHAT COST IF WE APPLY LIFO SYSTEM
JAN 5 –
JAN 10 –
JAN 14 –
JAN 20 –

Answer rating: 100% (QA)

To calculate the cost of goods sold COGS and ending inventory under the FIFO average and LIFO system... View the full answer