The condensed income statement to the Consumer Products of Tintests as Sales $219,000,000 Cost of goods 136,200,000 Gross prot 2.400.000 Arrative 12.000.000 Operating income $17,000,000 The manager of the Consumer Products Division is toering ways to increase the wester This information has been collected in the Microsoft Excel Online Open the same day and out your wer in the con Open spreadsheet in the ouront form for return on investment in the stronger and of the Cardin been invested in the Consumer Products Division Round your answers for the rain and the art on the more doma aces Profit marga Investment tumer Kate of return on investment It expenses could be reduced by $3,400,000 without decreasing sales, what would be the impact on the poor and out your answers for the profit margin and the rate of return on investment to meet who berround your answer for the intent to come Profit margin Investment turnover Rate of return on investment Pro No Sales $210,000,000 Cost of goods sold 130,400,000 Gross profit $79,600,000 Administrative expenses 62,600,000 Operating income $17,000,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 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 $126,340,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 tumover to two decimal places Profit margin Investment turnover Rate of return on investment b. If expenses could be reduced by $3,400,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 Previous Next