Chapter 5, Problem 9BTN

1.

To determine

Compute the inventory turnover and days’ sales inventory 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 will be 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}$

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

$\begin{array}{c}\text{Inventory turnover = }\frac{\text{Cost of}\text{Goods sold }}{\text{Average Inventory}}\\ =\frac{\$137,696,309}{\left(\$19,134,868+\$17,747,413\right)÷2}\\ =7.47\text{Times}\end{array}$

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

$\begin{array}{c}\text{Inventory turnover = }\frac{\text{Cost of}\text{Goods sold }}{\text{Average Inventory}}\\ =\frac{\$126,651,931}{\left(\$17,747,413+\$15,716,715\right)÷2}\\ =7.57\text{Times}\end{array}$

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 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 S’s current year as follows:

$\begin{array}{c}\text{Days' sales inventory = }\frac{\text{Ending inventory}}{\text{Cost of goods sold}}\times 365\\ =\frac{\$17,747,413}{\$126,651,931}\times 365\\ =51.15\text{Days}\end{array}$

Calculate days’ sales inventory for the Company S’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{\$18,811,794}{\$123,482,118}\times 365\\ =55.61\text{Days}\end{array}$

Note: For the values of Company S and Company G refer the text book (Question 2BTN).

2.

To determine

Comment and interpret your findings from parts 1.

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.
• However Company S has the lowest inventory turnover ratio and highest days’ sales inventory for both years.
• From the above calculation it is clear that, the inventory turnover ratio of Company A and G is more efficient than Company S. This is because Company S exhibited a slightly decline in the inventory management for the current year from the prior year.