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

Line Item Description Amount

Sales $$944,000$

Cost of goods sold $(424,800)$

Gross profit $$519,200$

Administrative expenses $(236,000)$

Operating income $$283,200$

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.

Open spreadsheet

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 $$2,360,000$ of assets have been invested in the Consumer Products Division. Round the investment turnover to one decimal place.

Line Item Description Answer

Profit margin fill in the blank $2$

$\%$

Investment turnover fill in the blank $3$

Return on investment fill in the blank $4$

$\%$

b$.$ If expenses could be reduced by $$47,200$ without decreasing sales, what would be the impact on the profit margin, investment turnover, and return on investment for the Consumer Products Division? Round the investment turnover to one decimal place.

Line Item Description Answer

Profit margin fill in the blank $5$

$\%$

Investment turnover fill in the blank $6$

Return on investment fill in the blank $7$

$\%$