60.1K

Verified Solution

Link Copied!

The condensed income statement for the Consumer Products Division of Tri$-$State Industries Inc. is as follows $($assuming no support department charges$)$:

Sales $$230,000,000$

Cost of goods sold $106,800,000$

Gross profit $$123,200,000$

Administrative expenses $61,000,000$

Operating income $$62,200,000$

The manager of the Consumer Products Division is considering ways to increase the return on investment.

This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.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 $$124,970,000$ of assets have been invested in the Consumer

Products Division. Round your answers for the profit margin and the rate of return on investment to the nearest whole number,

round your answer for the investment turnover to two decimal places.

Profit margin

$\%$

Investment turnover

Rate of return on investment

$\%$

b$.$ If expenses could be reduced by $$3,970,000$ without decreasing sales, what would be the impact on the profit margin,

investment turnover, and return on investment for the Consumer Products Division? Round your answers for the profit margin

and the rate of return on investment to the nearest whole number, round your answer for the investment turnover to two

decimal places.

Profit margin

$\%$

Investment turnover

Rate of return on investment

Answer & Explanation Solved by verified expert

See Answer