Walke, Victor MMSU Canvas Chapter 24 Homework (Application) book Show Me How Office 365 Pritom 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 118,000,000 Gross profit $112,000,000 Administrative expenses 69,100,000 Operating income 142,900,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 e Open the spreadsheet, perform the required analysis, and input your answers in the questions below Open spreadsheet a. Using the Dont formula for return on investment, determine the prorit margin, investment tumover, and return on investment of the Consumer Products Division, assuming that $135.810,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 turaverts two decimal places -Profit margin Investment turnover Rate of return on investment 6. 11 expenses could be reduced by $3,670,000 wthout 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 Prof margin Investment tumover Rate of return on investment Check My Work Previous