Question

Laker Company reported the following January purchases and sales data for its only product Units Required at Cost 240 unitat $16.50 - $3.960 Units sold at Retail Date Activities Jan. 1 Beginning inventory Jan. 10 Sales Jan. 20 Parehase Jan. 25 Sales Jan. 30 Purchase Totale 170 unital $15.50 - 2,635 190 units $25.50 190 units e $25.50 $15.00 - 380 units 790 units 5,700 $12,295 380 units The Company uses a perpetual Inventory system. For specific identification, ending Inventory consists of 410 units, where 380 are from the January 30 purchase, 5 are from the January 20 purchase, and 25[ 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. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Complete the table to determine the cost assigned to ending inventory and cost of goods sold using specific identification. (Round cost per unit to 2 decimal places.) Specific Identification Available for Sale Cost of Goods Sold Ending Inventory Ending Ending Unit Units Cost Per Purchase Date Activity Units Unit Cost COGS Inventory Cost Inventory Units Sold Cost

Answer 1

1.

	Sp. ID	Cost of goods available for sale			Cost of Goods Sold			Ending Balance
Date	Activity	Units	Unit Price	Amount	Units	Unit Price	Amount	Units	Unit Price	Amount
Jan-01	Beginning Inventory	240	$        16.50	$      3,960.00				240	$     16.50	$ 3,960.00
Jan-10	Sales				190	$      16.50	$ 3,135.00	50	$     16.50	$     825.00
Jan-20	Purchase	170	$        15.50	$      2,635.00				50	$     16.50	$     825.00
								170	$     15.50	$ 2,635.00
Jan-25	Sales				25	$      16.50	$    412.50	25	$     16.50	$     412.50
					165	$      15.50	$ 2,557.50	5	$     15.50	$        77.50
Jan-30	Purchase	380	$        15.00	$      5,700.00				25	$     16.50	$     412.50
								5	$     15.50	$        77.50
								380	$     15.00	$ 5,700.00
	Total	790		$    12,295.00	380		$6,105.00	410		$ 6,190.00

2

	W.Avg	Cost of goods available for sale			Cost of Goods Sold			Ending Balance
Date	Activity	Units	Unit Price	Amount	Units	Unit Price	Amount	Units	Unit Price	Amount
Jan-01	Beginning Inventory	240	$        16.50	$      3,960.00				240	$     16.50	$        3,960
Jan-10	Sales				190	$      16.50	$      3,135	50	$     16.50	$           825
Jan-20	Purchase	170	$        15.50	$      2,635.00				50	$     16.50	$           825
								170	$     15.50	$        2,635
								220	$     15.73	$        3,460
Jan-25	Sales				190	$      15.73	$      2,988	30	$     15.73	$           472
Jan-30	Purchase	380	$        15.00	$      5,700.00				30	$     15.73	$           472
								380	$     15.00	$        5,700
	Total	790		$    12,295.00	380		$      6,123	410	$     15.05	$        6,172

3

	FIFO	Cost of goods available for sale			Cost of Goods Sold			Ending Balance
Date	Activity	Units	Unit Price	Amount	Units	Unit Price	Amount	Units	Unit Price	Amount
Jan-01	Beginning Inventory	240	$        16.50	$      3,960.00				240	$     16.50	$ 3,960.00
Jan-10	Sales				190	$      16.50	$ 3,135.00	50	$     16.50	$     825.00
Jan-20	Purchase	170	$        15.50	$      2,635.00				50	$     16.50	$     825.00
								170	$     15.50	$ 2,635.00
Jan-25	Sales				50	$      16.50	$    825.00
					140	$      15.50	$ 2,170.00	30	$     15.50	$     465.00
Jan-30	Purchase	380	$        15.00	$      5,700.00				30	$     15.50	$     465.00
								380	$     15.00	$ 5,700.00
	Total	790		$    12,295.00	380		$6,130.00	410		$ 6,165.00

.

4

	LIFO	Cost of goods available for sale			Cost of Goods Sold			Ending Balance
Date	Activity	Units	Unit Price	Amount	Units	Unit Price	Amount	Units	Unit Price	Amount
Jan-01	Beginning Inventory	240	$        16.50	$      3,960.00				240	$     16.50	$ 3,960.00
Jan-10	Sales				190	$      16.50	$ 3,135.00	50	$     16.50	$     825.00
Jan-20	Purchase	170	$        15.50	$      2,635.00				50	$     16.50	$     825.00
								170	$     15.50	$ 2,635.00
Jan-25	Sales				170	$      15.50	$ 2,635.00	30	$     16.50	$     495.00
					20	$      16.50	$    330.00
Jan-30	Purchase	380	$        15.00	$      5,700.00				30	$     16.50	$     495.00
								380	$     15.00	$ 5,700.00
	Total	790		$    12,295.00	380		$6,100.00	410		$ 6,195.00