please fill out the blank spaces on the excel sheet

A E Problem 11-21 2 3 NORTH 5 5 6 WEST GRENIER EAST 7 8 9 SOUTH Overall ROI = 18% 10 11 12 13 Part 1 14 New project 15 Sales 16 Variable expenses (65%) 17 Fixed expenses 18 Operating income 19 Current New Project Total 19 20 21 22 23 Margin 24 25 26 27 Turnover 28 20 PROBLEM 11-21 Return on investment and Residual Income 103, 104 Faced with headquarters' desire to add a new product line, Stefan Grenier, manager of Bilti Products' East Division, felt that he had to see the numbers before he made a move. His division's ROI has led the company for three years, and he doesn't want any letdown Bill Products is a decentralized wholesale with four autonomous divisions. The divisions are evaluated on the basis of ROL, with yearend bonuses given to divisional managers who have the highest ROL Operating results for the company's East Division for last year are given below: Sales Variable expenses Contribution margin Fixed expenses Operating income Divisional operating assets $21,000,000 13.400,000 7,600,000 5,920,000 S 1,680,000 $ 5.250,000 2.UUU Page 3 The company had an overall ROI of 18% last year (considering all divisions). The new product line that headquarters wants Grenier's East Division to add would require an investment of $3,000,000. The cost and revenue characteristics of the new product line per year would be as follows Sales Variable expenses Fixed expenses $9,000,000 65% of sales $2,520,000 Required: 1. Compute the East Division's ROI for last year, also compute the Rol as it would appear if the new product line were added. 2. If you were in Grenier's position, would you accept or reject the new product line? Explain. 3. Why do you suppose headquarters is anxious for the East Division to add the new product line? 4 Suppose that the company's minimum required rate of return on operating assets is 18% and that performance is evaluated using residual income Compute East Division's residual income for last year, also compute the residual income as it would appear if the new product line were added Under these circumstances, if you were in Grenier's position, would you accept or reject the new product line? Explain