36PGB_3 - Horngren'S Financial And Managerial Accounting

Question

Question: Empire State Carpets’s books show the following data. In early 2020, auditors foundthat the ending merchandise inventory for 2017 was understated by \(8,000 and thatthe ending merchandise inventory for 2019 was overstated by \)9,000. The ending merchandiseinventory at December 31, 2018, was correct.

	2019	2018	2017
Net Sales Revenue	\(     220,000	\)    162,000	\(   176,000
Cost of Goods Sold:
Beginning Merchandise Inventory	\)22,000	\(29,000	\)46,000
Net cost of purchase	132,000	90,000	76,000
Cost of goods available for sale	154,000	119,000	122,000
Less: Ending Merchandise Inventory	32,000	22,000	29,000
Cost of goods sold	122,000	97,000	93,000
Gross Profit	98,000	65,000	83,000
Operating Expenses	72,000	38,000	48,000
Net Income	\( 26,000	\) 27,000	$ 35,000

Requirements

3. Compute the inventory turnover and days’ sales in inventory using the correctedincome statements for the three years. (Round all numbers to two decimals.)

Step-by-Step Solution

Answer

2019                 2018            2017

Inventory Turnover---------------      5.82          3.6                 2.05

Days’ sales in inventory--------      62.71              101.38           178.05

Step-by-Step-Solution Step1: Correct Income statement

	2019	2018	2017
Net Sales Revenue	$        220,000	$    162,000	$   176,000
Cost of Goods Sold:
Beginning Merchandise Inventory	$22,000	$37,000	$46,000
Net cost of purchase	132,000	90,000	76,000
Cost of goods available for sale	154,000	127,000	122,000
Less: Ending Merchandise Inventory	23,000	22,000	37,000
Cost of goods sold	131,000	105,000	85,000
Gross Profit	89,000	57,000	91,000
Operating Expenses	72,000	38,000	48,000
Net Income	$ 17,000	$ 19,000	$ 43,000

Step 2: Inventory turnover

$$\begin{gathered} For2019=\frac{Costofgoodssold}{AverageInventory} \\ =\frac{\$131,000}{\frac{\$22,000+\$23,000}{2}} \\ =\frac{\$131,000}{\$22,500} \\ =5.82 \end{gathered}$$

$$\begin{gathered} For2018=\frac{Costofgoodssold}{AverageInventory} \\ =\frac{\$105,000}{\frac{\$37,000+\$22,000}{2}} \\ =\frac{\$105,000}{\$29,500} \\ =3.6 \end{gathered}$$

$$\begin{gathered} For2017=\frac{Costofgoodssold}{AverageInventory} \\ =\frac{\$85,000}{\frac{\$46,000+\$37,000}{2}} \\ =\frac{\$85,000}{\$41,500} \\ =2.05 \end{gathered}$$

Step 3: Days’ sales in inventory

$$\begin{gathered} For2019=\frac{365}{Inventoryturnover} \\ =\frac{365}{5.82} \\ =62.71 \end{gathered}$$

$$\begin{gathered} For2018=\frac{365}{Inventoryturnover} \\ =\frac{365}{3.6} \\ =101.38 \end{gathered}$$

$$\begin{gathered} For2017=\frac{365}{Inventoryturnover} \\ =\frac{365}{2.05} \\ =178.05 \end{gathered}$$