Question

Specific Identification, FIFO, LIFO, and Weighted-Average

Swing Company's beginning inventory and purchases during the fiscal year ended September 30, 20-2, were as follows:

		Units	Unit Price	Total Cost
October 1, 20-1	Beginning inventory	400	$20		$8,000
October 18	1st purchase	510	20.5		10,455
November 25	2nd purchase	200	21.5		4,300
January 12, 20-2	3rd purchase	350	23		8,050
March 17	4th purchase	880	24		21,120
June 2	5th purchase	850	24.5		20,825
August 21	6th purchase	200	25.5		5,100
September 27	7th purchase	730	26.5		19,345
		4,120			$97,195

Use the following information for the specific identification method.

There are 1,300 units of inventory on hand on September 30, 20-2. Of these 1,300 units:

100 are from October 18, 20-1	1st purchase
200 are from January 12, 20-2	3rd purchase
100 are from March 17	4th purchase
400 are from June 2	5th purchase
200 are from August 21	6th purchase
300 are from September 27	7th purchase

Required:

Calculate the total amount to be assigned to cost of goods sold for the fiscal year ended September 30, 20-2, and ending inventory on September 30, 20-2, under each of the following periodic inventory methods. For the weighted-average method, round the average unit cost to two decimal places. Round all final answers to the nearest dollar.

	Cost of Goods Sold	Cost of Ending Inventory
1. FIFO
2. LIFO
3. Weighted-average
4. Specific identification

Answer 1

Solution:

		Cost of goods sold	Cost of ending inventory
1	FIFO	42,565	33,510
2	LIFO	70,070	27,125
3	Weighted average	66524	30,667
4	Specific identification	65295	31,900

Explanation:

Beginning inventory + purchases = 400 + 510 + 200 + 350 + 880 + 850 + 200 + 730 = 4,120 units

Ending inventory = 1300 units

Sales = 4120 - 1300 = 2820 units

FIFO:

Cost of goods sold = (400 x 20) + (510 x 20.5) + (200 x 21.5) + (350 x 23) + (880 x 24) + (480 x 24.5)

= 8000 + 10455 + 4300 + 8050 + 11760

Cost of goods sold = 42,565

Cost of ending inventory = (850 - 480) x 24.5 + (200 x 25.5) + (730 x 26.5) = 9065 + 5100 + 19345 = 33,510

LIFO:

Cost of goods sold = (730 x 26.5) + (200 x 25.5) + (850 x 24.5) + (880 x 24) + (160 x 23)

= 19345 + 5100 + 20825 + 21120 + 3680

Cost of goods sold = 70,070

Ending inventory = (350 - 160) x 23 + (200 x 21.5) + (510 x 20.5) + (400 x 20)

= 4370 + 4300 + 10455 + 8000

Ending inventory = 27,125

Weighted average:

Average price = Total cost / Total units = 97195 / 4120 = 23.59

Cost of goods sold = 2820 x 23.59 = 66524

Ending inventory = 1300 x 23.59 = 30,667

Specific identification:

Cost of goods sold = (200 x 21.5) + (400 x 20) + (410 x 20.5) + (150 x 23) + (780 x 24) + (450 x 24.5) + (430 x 26.5)

= 4300 + 8000 + 8405 + 3450 + 18720 + 11025 + 11395

Cost of goods sold  = 65295

Ending inventory = (100 x 20.5) + (200 x 23) + (100 x 24) + (400 x 24.5) + (200 x 25.5) + (300 x 26.5)

= 2050 + 4600 + 2400 + 9800 + 5100 + 7950

Ending inventory = 31,900