Question

Inventory by Three Methods; Cost of Merchandise Sold The units of an item available for sale during the year were as follows: Jan. 1 Inventory 40 units @ $130 per unit Mar. 10 Purchase 50 units @ $138 per unit Aug. 30 Purchase 30 units @ $144 per unit Dec. 12 Purchase 80 units @ $146 per unit There are 40 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost and the cost of merchandise sold by three methods, presenting your answers in the form below. Round the average cost per unit to the nearest cent and round your final answers to the nearest whole dollar. Hide Schedule of Cost of Merchandise Inventory and cost of Merchandise Sold Inventory Method Merchandise Inventory Merchandise Sold a. FIFO b. LIFO c. Average cost 5620 22480

Answer 1

• Requirements

	Merchandise Inventory	Merchandise Sold
FIFO	$                   5,840	$                22,260
LIFO	$                   5,200	$                22,900
Weighted Average	$                   5,620	$                22,480

• Workings

FIFO	Cost of Goods available for sale			Cost of Goods Sold			Ending Inventory
	Units	Cost/unit	COG for sale	Units sold	Cost/unit	COGS	Units	Cost/unit	Ending inventory
Beginning Inventory	40	$              130.00	$                        5,200.00	40	$             130.00	$                 5,200.00	0	$              130.00	$                         -
Purchases:
10-Mar	50	$              138.00	$                        6,900.00	50	$             138.00	$                 6,900.00	0	$              138.00	$                         -
30-Aug	30	$              144.00	$                        4,320.00	30	$             144.00	$                 4,320.00	0	$              144.00	$                         -
12-Dec	80	$              146.00	$                      11,680.00	40	$             146.00	$                 5,840.00	40	$              146.00	$            5,840.00
TOTAL	200		$                      28,100.00	160		$               22,260.00	40		$            5,840.00
LIFO	Cost of Goods available for sale			Cost of Goods Sold			Ending Inventory
	Units	Cost/unit	COG for sale	Units sold	Cost/unit	COGS	Units	Cost/unit	Ending inventory
Beginning Inventory	40	$              130.00	$                        5,200.00	0	$             130.00	$                              -	40	$              130.00	$            5,200.00
Purchases:
10-Mar	50	$              138.00	$                        6,900.00	50	$             138.00	$                 6,900.00	0	$              138.00	$                         -
30-Aug	30	$              144.00	$                        4,320.00	30	$             144.00	$                 4,320.00	0	$              144.00	$                         -
12-Dec	80	$              146.00	$                      11,680.00	80	$             146.00	$               11,680.00	0	$              146.00	$                         -
TOTAL	200		$                      28,100.00	160		$               22,900.00	40		$            5,200.00
Average Method	Cost of Goods available for sale			Cost of Goods Sold			Ending Inventory
	Units	Cost/unit	COG for sale	Units sold	Cost/unit	COGS	Units	Cost/unit	Ending inventory
Beginning Inventory	40	$              130.00	$                        5,200.00
Purchases:
10-Mar	50	$              138.00	$                        6,900.00
30-Aug	30	$              144.00	$                        4,320.00
12-Dec	80	$              146.00	$                      11,680.00
TOTAL	200	$         140.5000	$                      28,100.00	160	$        140.5000	$               22,480.00	40	$          140.5000	$            5,620.00