Question

In: Accounting

The following is a portion of the condensed income statement for Rowan, Inc., a manufacturer of plastic containers:

The following is a portion of the condensed income statement for Rowan, Inc., a manufacturer of plastic containers:

The following is a portion of the condensed income statement

Required:
1. Determine Rowan's inventory turnover.
2. What information does this ratioprovide?

 

Solutions

Expert Solution

Requirement 1

Inventory turnover ratio  =   Cost of goods sold
                                                      Average inventory

                             =          $1,840,000      
                                                 [$690,000 + 630,000] ÷ 2

                             =   2.79 times

Requirement 2

By itself, this one ratio provides very little information. In general, the higher the inventory turnover, the lower the investment must be for a given level of sales. It indicates how well inventory levels are managed and the quality of inventory, including the existence of obsolete or overpriced inventory. 

 

However, to evaluate the adequacy of this ratio it should be compared with some norm such as the industry average. That indicates whether inventory management practices are in line with the competition.

 

It's just one piece in the puzzle, though. Other points of reference should be considered. For instance, a high turnover can be achieved by maintaining too low inventory levels and restocking only when absolutely necessary. This can be costly in terms of stock out costs. 

 

The ratio also can be useful when assessing the current ratio. The more liquid inventory is, the lower the norm should be against which the current ratio should be compared.


The ratio also can be useful when assessing the current ratio. The more liquid inventory is, the lower the norm should be against which the current ratio should be compared.

Related Solutions

Johnson & Johnson, Inc.                       Condensed Income Statement                  ...
Johnson & Johnson, Inc.                       Condensed Income Statement                       For the Year Ended December 3, 2019        Baby Oil       Dial Soap       Shampoo       Diapers Sales: $1,200,000   $3,500,000      $2,750,000    $6,200,000 Cost Of Goods Sold:    Variable Costs $480,000      $1,200,000 $850,000       $4,250,000 Fixed Costs $50,000        $50,000       $75,000        $100,000 Total Cost of Goods Sold $530,000       $1,250,000 $925,000       $4,350,000           ...
A comparative balance sheet and an income statement for Rowan Company are given below: Rowan Company...
A comparative balance sheet and an income statement for Rowan Company are given below: Rowan Company Comparative Balance Sheet (dollars in millions) Ending Balance Beginning Balance Assets Current assets: Cash and cash equivalents $ 70 $ 91 Accounts receivable 536 572 Inventory 620 580 Total current assets 1,226 1,243 Property, plant, and equipment 1,719 1,656 Less accumulated depreciation 640 480 Net property, plant, and equipment 1,079 1,176 Total assets $ 2,305 $ 2,419 Liabilities and Stockholders' Equity Current liabilities: Accounts...
A comparative balance sheet and an income statement for Rowan Company are given below: Rowan Company...
A comparative balance sheet and an income statement for Rowan Company are given below: Rowan Company Comparative Balance Sheet (dollars in millions) Ending Balance Beginning Balance Assets Current assets: Cash and cash equivalents $ 70 $ 91 Accounts receivable 536 572 Inventory 620 580 Total current assets 1,226 1,243 Property, plant, and equipment 1,719 1,656 Less accumulated depreciation 640 480 Net property, plant, and equipment 1,079 1,176 Total assets $ 2,305 $ 2,419 Liabilities and Stockholders' Equity Current liabilities: Accounts...
. A condensed income statement by product line for Crown Beverage Inc. indicated the following for...
. A condensed income statement by product line for Crown Beverage Inc. indicated the following for King Cola for the past year: Sales $234,800 Cost of goods sold 110,000 Gross profit $124,800 Operating expenses 143,000 Loss from operations $(18,200) It is estimated that 15% of the cost of goods sold represents fixed factory overhead costs and that 19% of the operating expenses are fixed. Since King Cola is only one of many products, the fixed costs will not be materially...
A condensed income statement by product line for Warrick Beverage Inc. indicated the following for Mango...
A condensed income statement by product line for Warrick Beverage Inc. indicated the following for Mango Cola for the past year: Sales $235,100 Cost of goods sold (111,000) Gross profit $124,100 Operating expenses (143,000) Operating loss $(18,900) It is estimated that 14% of the cost of goods sold represents fixed factory overhead costs and that 23% of the operating expenses are fixed. Because Mango Cola is only one of many products, the fixed costs will not be materially affected if...
8. A condensed income statement by product line for Warrick Beverage Inc. indicated the following for...
8. A condensed income statement by product line for Warrick Beverage Inc. indicated the following for Mango Cola for the past year: Sales $233,700 Cost of goods sold (108,000) Gross profit $125,700 Operating expenses (145,000) Operating loss $(19,300) It is estimated that 12% of the cost of goods sold represents fixed factory overhead costs and that 23% of the operating expenses are fixed. Because Mango Cola is only one of many products, the fixed costs will not be materially affected...
A condensed income statement by product line for British Beverage Inc. indicated the following for King...
A condensed income statement by product line for British Beverage Inc. indicated the following for King Cola for the past year: Sales $233,300 Cost of goods sold 110,000 Gross profit $123,300 Operating expenses 145,000 Loss from operations $(21,700) It is estimated that 12% of the cost of goods sold represents fixed factory overhead costs and that 22% of the operating expenses are fixed. Since King Cola is only one of many products, the fixed costs will not be materially affected...
A portion of the combined statement of income and retained earnings of Culver Inc. for the...
A portion of the combined statement of income and retained earnings of Culver Inc. for the current year follows. Income before extraordinary item $14,960,000 Loss from discontinued operations, net of applicable income tax (Note 1) 1,370,000 Net income 13,590,000 Retained earnings at the beginning of the year 82,330,000 95,920,000 Dividends declared: On preferred stock—$6.00 per share $282,000 On common stock—$1.75 per share 14,770,000 15,052,000 Retained earnings at the end of the year $80,868,000 Note 1. During the year, Culver Inc....
The condensed income statement for the Consumer Products Division of Fargo Industries Inc. is as follows...
The condensed income statement for the Consumer Products Division of Fargo Industries Inc. is as follows (assuming no service department charges): Sales $1,008,000 Cost of goods sold 453,600 Gross profit $554,400 Administrative expenses 201,600 Income from operations $352,800 The manager of the Consumer Products Division is considering ways to increase the return on investment. a. Using the DuPont formula for return on investment, determine the profit margin, investment turnover, and return on investment of the Consumer Products Division, assuming that...
A condensed income statement for the Commercial Division of Maxell Manufacturing Inc. for the year ended...
A condensed income statement for the Commercial Division of Maxell Manufacturing Inc. for the year ended December 31, 20Y9, is as follows: 1 Sales $3,900,000.00 2 Cost of goods sold 2,505,000.00 3 Gross profit $1,395,000.00 4 Operating expenses 888,000.00 5 Income from operations $507,000.00 6 Invested assets $3,250,000.00 Assume that the Commercial Division received no charges from service departments. The president of Maxell Manufacturing has indicated that the division’s return on a $3,250,000 investment must be increased to at least...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT