Chapter 5, Problem 2BTN

1.

To determine

Compute inventory turnover for each company for the most recent years shown.

Explanation of Solution

Inventory turnover:

This is the ratio which analyzes the number of times inventory is sold during the period. This ratio gauges the efficacy of inventory management. Larger the ratio, more efficient the inventory management.

Calculate inventory ratio for Company A’s current year as follows:

$\begin{array}{c}\text{Inventory turnover = }\frac{\text{Cost of}\text{Goods sold }}{\text{Average Inventory}}\\ =\frac{\$106,606}{\left(\$1,764+\$791\right)÷2}\\ =83.4\text{Times}\end{array}$

Calculate inventory ratio for Company A’s one year prior as follows:

$\begin{array}{c}\text{Inventory turnover = }\frac{\text{Cost of}\text{Goods sold }}{\text{Average Inventory}}\\ =\frac{\$87,846}{\left(\$791+\$776\right)÷2}\\ =112.1\text{Times}\end{array}$

Calculate inventory turnover ratio for Company G’s current year as follows:

$\begin{array}{c}\text{Inventory turnover = }\frac{\text{Cost of}\text{Goods sold }}{\text{Average Inventory}}\\ =\frac{\$25,858}{\left(\$426+\$505\right)÷2}\\ =55.5\text{Times}\end{array}$

Calculate inventory turnover ratio for Company G’s one year prior as follows:

$\begin{array}{c}\text{Inventory turnover = }\frac{\text{Cost of}\text{Goods sold }}{\text{Average Inventory}}\\ =\frac{\$20,634}{\left(\$505+\$35\right)÷2}\\ =76.4\text{Times}\end{array}$

2.

To determine

Compute days’ sales inventory for each company for three years shown.

Explanation of Solution

Days’ sales Inventory:

Days’ sales in inventory are used to determine number of days a particular company takes to make sales of the inventory available with them.

Calculate days’ sales inventory for the Company A’s current year as follows:

$\begin{array}{c}\text{Days' sales inventory = }\frac{\text{Ending inventory}}{\text{Cost of goods sold}}\times 365\\ =\frac{\$1,764}{\$106,606}\times 365\\ =6.04\text{Days}\end{array}$

Calculate days’ sales inventory for the company A’s one year prior as follows:

$\begin{array}{c}\text{Days' sales inventory = }\frac{\text{Ending inventory}}{\text{Cost of goods sold}}\times 365\\ =\frac{\$791}{\$87,846}\times 365\\ =3.29\text{Days}\end{array}$

Calculate days’ sales inventory for the Company A’s two year prior as follows:

$\begin{array}{c}\text{Days' sales inventory = }\frac{\text{Ending inventory}}{\text{Cost of goods sold}}\times 365\\ =\frac{\$776}{\$64,431}\times 365\\ =4.40\text{Days}\end{array}$

Calculate days’ sales inventory for the Company G’s current year as follows:

$\begin{array}{c}\text{Days' sales inventory = }\frac{\text{Ending inventory}}{\text{Cost of goods sold}}\times 365\\ =\frac{\$426}{\$25,858}\times 365\\ =6.01\text{Days}\end{array}$

Calculate days’ sales inventory for the Company G’s one year prior as follows:

$\begin{array}{c}\text{Days' sales inventory = }\frac{\text{Ending inventory}}{\text{Cost of goods sold}}\times 365\\ =\frac{\$505}{\$20,634}\times 365\\ =8.93\text{Days}\end{array}$

Calculate days’ sales inventory for the Company G’s two year prior as follows:

$\begin{array}{c}\text{Days' sales inventory = }\frac{\text{Ending inventory}}{\text{Cost of goods sold}}\times 365\\ =\frac{\$35}{\$13,188}\times 365\\ =0.97\text{Days}\end{array}$

3.

To determine

Comment and interpret your findings from parts 1 and 2. Assume an industry average for inventory turnover of 15.

Explanation of Solution

Interpret and Comment:

• Company A’s inventory turnover ratio is more efficient than Company G.
• Company A’s days’ sales inventory is fewer than company G.
• Company A’s  inventory turnover ratio is more than the industry average of 15 for inventory turnover for both the current year and prior year, but Company G is slightly below the industry average in both the current year and prior years.
• Company G’s days’ sales inventory seems a bit too high comparing with the Company A.