The condensed Income statement for the Consumer Products Division of state Industries Inc. is as follows (assuming no support department charpes): Sales $220,000,000 Cost of goods told 123,000,000 Greenprofit 097,000,000 Administrative sense 67,430,000 Operating income $29.600.000 The manager of the Commuter Products Division is considering ways to increase the return on investment. This information not been collected in the Micro Excel Online film. Open the spreadsheet, perform the requests and input your mer , the questo teow Open predest 3. Using the DuPont formula for return on investment in the protagonisme tumore, and return on ment of the Consumer Products Domingo 102,210,000 of share ben invested in the consumer Products Dive Round your answers to the profit margin and the rate of return to the rest wokombe round your answer for the westment turnover to two despace 13.5 X Investment turver 2.15 Rate of return on investment Des could be reduced by 3.400,000 withoudering what would be that the promovement and return on ment for the Consumer Production Round vur annars for the profit margin and the returnement to the Wound your awer for the intentavertown decimal places Teht mange Investment Rate of cum on investe Divisional Income Statements with Support Department Allocations Horton Technology has two divisions. Consumer and Commercial, and two corporate support departments, Tech Services and Purchasing. The corporate experies for the year ended December 31, 2017, are as follows: Tech Services Department $1,170,000 Purchasing Department 447,000 Other corporate administrative expenses 695,000 $2,312,000 Total expense The other corporate administrative expenses include officers' salaries and other expenses recuired by the corporation. The Tech Services Department allocates costs to the divisions based on the number of computers in the department, and the Purchasing Department allocated costs to the divisions based on the number of purchase order for each department. The services used by the two divisions are as follows: Tech Services Purchasing Consumer Division 450 computers 5,200 purchase orders Commercial Division 290 9,700 Total 750 computers 14,900 purchase orders The support department allocations of the Tech Services Department and the Purchasing Department are considered controllable by the divisions Corporate administrative expenses are not considered controllable by the division. The revenues, cost of goods sold, and operating expenses for the two divisions are as follows: Consumer Commercial Sevenues $10,273,700 $8,614,900 Cost of goods sold 5,707.000 4,350,100 Onerating wenses 2.015,200 2.153,500 Commercial Division -2,164.500 X -4.350,100 -1814.00 X Horton Technology Divisional Income Statements For the Year Ended December 31, 2017 Consumer Division Revenues 16.273.700 Cost of goods sold -3.707.000 Gross profit 4.566.100 Operating expenses 2015200 Operating income before support department allocati ocations 2,550,000 Support department allocations: Tech service department Purchasing department Total support department allocations Operating Income 2.500 -1.661,300 X After the pic is another