Question

Wildhorse Co. markets CDs of numerous performing artists. At the beginning of March, Wildhorse had in beginning inventory 2,500 CDs with a unit cost of $8. During March, Wildhorse made the following purchases of CDs.

March 5		2,000		@		$9		March 21		4,900		@		$11
March 13		3,800		@		$10		March 26		2,000		@		$12

During March 11,600 units were sold. Wildhorse uses a periodic inventory system.

Determine the cost of goods available for sale.

The cost of goods available for sale

$enter the cost of goods available for sale in dollars

Calculate Average Cost. (Round answer to 3 decimal places, e.g. 5.125.)

Average Cost

$enter an average cost in dollars

eTextbook and Media

List of Accounts

Determine (1) the ending inventory and (2) the cost of goods sold under each of the assumed cost flow methods (FIFO, LIFO, and average-cost). (Round answers to 0 decimal places, e.g. 125.)

		FIFO		LIFO		AVERAGE-COST
The ending inventory		$enter a dollar amount		$enter a dollar amount		$enter a dollar amount
The cost of goods sold		$enter a dollar amount		$enter a dollar amount		$enter a dollar amount

eTextbook and Media

List of Accounts

Which cost flow method results in (1) the highest inventory amount for the balance sheet and (2) the highest cost of goods sold for the income statement?

(1)		select a method which                                                                      Average-costFIFOLIFO produces the highest inventory amount.
(2)		select a method which                                                                      Average-costFIFOLIFO produces the highest cost of goods sold.

Answer 1

• Working

Cost of Goods available for sale
Units	Cost/unit	COG for sale
2500	$                   8.00	$                      20,000.00
2000	$                   9.00	$                      18,000.00
3800	$                10.00	$                      38,000.00
4900	$                11.00	$                      53,900.00
2000	$                12.00	$                      24,000.00
15200		$                    153,900.00

• Cost of Goods available for Sale = $ 153,900
• Average Cost = $ 153900 / 15200 = $ 10.125
• Ending Inventory & Cost of Goods Sold

	FIFO	LIFO	Weighted Average
Ending Inventory	$    41,600.00	$            29,900.00	$               36,450.00
Cost of Goods Sold	$ 112,300.00	$          124,000.00	$             117,450.00

>Highest Inventory account = FIFO
>Highest Cost of Goods Sold = LIFO

--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	2500	$                   8.00	$                      20,000.00	2500	$                 8.00	$               20,000.00	0	$                   8.00	$                         -
Purchases:
05-Mar	2000	$                   9.00	$                      18,000.00	2000	$                 9.00	$               18,000.00	0	$                   9.00	$                         -
13-Mar	3800	$                10.00	$                      38,000.00	3800	$               10.00	$               38,000.00	0	$                 10.00	$                         -
21-Mar	4900	$                11.00	$                      53,900.00	3300	$               11.00	$               36,300.00	1600	$                 11.00	$          17,600.00
26-Mar	2000	$                12.00	$                      24,000.00	0	$               12.00	$                              -	2000	$                 12.00	$          24,000.00
TOTAL	15200		$                    153,900.00	11600		$            112,300.00	3600		$          41,600.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	2500	$                   8.00	$                      20,000.00	0	$                 8.00	$                              -	2500	$                   8.00	$          20,000.00
Purchases:
05-Mar	2000	$                   9.00	$                      18,000.00	900	$                 9.00	$                 8,100.00	1100	$                   9.00	$            9,900.00
13-Mar	3800	$                10.00	$                      38,000.00	3800	$               10.00	$               38,000.00	0	$                 10.00	$                         -
21-Mar	4900	$                11.00	$                      53,900.00	4900	$               11.00	$               53,900.00	0	$                 11.00	$                         -
26-Mar	2000	$                12.00	$                      24,000.00	2000	$               12.00	$               24,000.00	0	$                 12.00	$                         -
TOTAL	15200		$                    153,900.00	11600		$            124,000.00	3600		$          29,900.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	2500	$                   8.00	$                      20,000.00
Purchases:	0	$                       -	$                                     -
05-Mar	2000	$                   9.00	$                      18,000.00
13-Mar	3800	$                10.00	$                     38,000.00
21-Mar	4900	$                11.00	$                      53,900.00
26-Mar	2000	$                12.00	$                      24,000.00
TOTAL	15200	$              10.125	$                    153,900.00	11600	$          10.1250	$            117,450.00	3600	$            10.1250	$          36,450.00