Chapter 6, Problem 2AA

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{\$141,048}{\left(\$4,855+\$2,132\right)÷2}\\ =40.37\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 goods sold}}{\text{Average Inventory}}\\ =\frac{\$131,376}{\left(\$2,132+\$2,349\right)÷2}\\ =58.6\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 goods sold}}{\text{Average Inventory}}\\ =\frac{\$45,583}{\left(\$749+\$268\right)÷2}\\ =89.6\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 goods sold}}{\text{Average Inventory}}\\ =\frac{\$35,138}{\left(\$268+\$491\right)÷2}\\ =92.6\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{\$4,855}{\$141,048}\times 365\\ =12.56\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{\$2,132}{\$131,376}\times 365\\ =5.92\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{\$2,349}{\$140,089}\times 365\\ =6.12\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{\$749}{\$45,583}\times 365\\ =6\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{\$268}{\$35,138}\times 365\\ =2.8\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{\$491}{\$28,164}\times 365\\ =6.36\text{Days}\end{array}$

3.

a)

To determine

Determine whether the inventory turnover of Company A would underperform or outperform.

Explanation of Solution

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. Hence, Company A is outperformed.

b)

To determine

Determine whether the inventory turnover of Company G would underperform or outperform.

Explanation of Solution

Company G’s inventory turnover ratio is more than the industry average of 15 for inventory turnover for both the current year and prior year. Hence, Company G is outperformed.