Question

Laker Company reported the following January purchases and sales data for its only product.

Date			Activities	Units Acquired at Cost								Units sold at Retail
Jan.	1		Beginning inventory	185	units	@	$	11.00	=	$	2,035
Jan.	10		Sales										145	units	@	$	20.00
Jan.	20		Purchase	100	units	@	$	10.00	=		1,000
Jan.	25		Sales										125	units	@	$	20.00
Jan.	30		Purchase	270	units	@	$	9.50	=		2,565
			Totals	555	units					$	5,600		270	units

The Company uses a perpetual inventory system. For specific identification, ending inventory consists of 285 units, where 270 are from the January 30 purchase, 5 are from the January 20 purchase, and 10 are from beginning inventory.

Required:
1. Complete the table to determine the cost assigned to ending inventory and cost of goods sold using specific identification.
2. Determine the cost assigned to ending inventory and to cost of goods sold using weighted average.
3. Determine the cost assigned to ending inventory and to cost of goods sold using FIFO.
4. Determine the cost assigned to ending inventory and to cost of goods sold using LIFO.

	Specific Identification, Weighted Average, FIFO, LIFO - Perpetual: Goods Purchased Cost of Goods Sold Inventory Balance Date # of units Cost per unit # of units sold Cost per unit Cost of Goods Sold # of units Cost per unit Inventory Balance January 1 185 @ $11.00 = $2,035.00 January 10 January 20 Average cost January 25 January 30 Totals

Answer 1

1		Cost of goods available for sale			Cost of goods sold			Ending Inventory
	Specific Identification	# of units    (A)	Cost per unit	Cost of goods available for sale	# of units sold               (B)	Cost per unit	Cost of goods sold	# of units in ending inventory	Cost per unit	Ending Inventory
	Jan-01	185	$       11.00	$        2,035	175	$       11.00	$       1,925	10	$    11.00	$              110
	Jan-20	100	$       10.00	$        1,000	95	$       10.00	$           950	5	$    10.00	$                50
	Jan-30	270	$         9.50	$        2,565	-	$         9.50	$              -	270	$       9.50	$          2,565
	Total	555		$        5,600	270		$       2,875	285		$          2,725
2		Cost of goods available for sale			Cost of goods sold			Ending Inventory
	Weighted - Average	# of units    (A)	Cost per unit	Cost of goods available for sale	# of units sold               (B)	Cost per unit	Cost of goods sold	# of units in ending inventory	Cost per unit	Ending Inventory
	Jan-01							185	$    11.00	$          2,035
	Jan-10				145	$       11.00	$       1,595	40	$    11.00	$              440
	Jan-20	100	$       10.00	$        1,000				40	$    11.00	$              440
								100	$    10.00	$          1,000
								140	$    10.29	1,440
	Jan-25				125	$       10.29	$       1,286	15	$    10.29	$              154
	Jan-30	270	$         9.50	$        2,565				15	$    10.29	$              154
								270	$       9.50	$          2,565
	Total	370		$        3,565	270		$       2,881	285	$       9.54	$          2,719
3		Cost of goods available for sale			Cost of goods sold			Ending Inventory
	FIFO	# of units    (A)	Cost per unit	Cost of goods available for sale	# of units sold               (B)	Cost per unit	Cost of goods sold	# of units in ending inventory	Cost per unit	Ending Inventory
	Jan-01							185	$    11.00	$          2,035
	Jan-10				145	$       11.00	$       1,595	40	$    11.00	$              440
	Jan-20	100	$       10.00	$        1,000				40	$    11.00	$              440
								100	$    10.00	$          1,000
	Jan-25				40	$       11.00	$           440	15	$    10.00	$              150
					85	$       10.00	$           850
	Jan-30	270	$         9.50	$        2,565				15	$    10.00	$              150
								270	$       9.50	$          2,565
	Total	370		$        3,565	270		$       2,885	285		$          2,715
4		Cost of goods available for sale			Cost of goods sold			Ending Inventory
	LIFO	# of units    (A)	Cost per unit	Cost of goods available for sale	# of units sold               (B)	Cost per unit	Cost of goods sold	# of units in ending inventory	Cost per unit	Ending Inventory
	Jan-01							185	$    11.00	$          2,035
	Jan-10				145	$       11.00	$       1,595	40	$    11.00	$              440
	Jan-20	100	$       10.00	$        1,000				40	$    11.00	$              440
								100	$    10.00	$          1,000
	Jan-25				100	$       10.00	$       1,000	15	$    11.00	$              165
					25	$       11.00	$           275
	Jan-30	270	$         9.50	$        2,565				15	$    11.00	$              165
								270	$       9.50	$          2,565
	Total	370		$        3,565	270		$       2,870	285		$          2,730