i. Briey describe the segments. Give some examples of the products or geographical territory. ii. Comment on the graph: What stands out to you? SECTION III B. Add a new table somewhere below the rst section. The second data table should have the following column headings: Division. ROI and Residual Income. For the rows "Copy" and "paste\" the division names into the new table. T. For the first company division listed, insert formula commands to calculate ROI and Residual income (assume the company has a 25% target rate of return). To insert formulas: highlight the cell where you want to place the answer. Then, for example, type in \"=EIZIEIS" to divide the gure in cell B? by the gure in cell B3. 8. Use the "Copy\" and \"Paste" commands to copy the same formulas into the appropriate cell for each division. 9. Use the \"tail.\" on the \"Number" section of the menu bar to format the ROI as a percentage. Format the residual income as a dollar amount. 1D.Add a column graph that compares the ROI of each division. Add a title and size the graph as needed. 1 1 .Add one textbox for EACH of the following: i. soc What does RDI tell management? Which divisions have the best and worst or are they roughly the same? How do they compare? How could a division of this company improve its RDI? Give an example of a specic action that could be taken to improve ROI. ii. Residual Income: What does Residual Income tell management? Do any of the divisions fall short of management's expectations? How can you tell? iii. Allocation decision: If you were upper management (GED of the whole corporation}: and had excess funds to allocate among divisions: based on the calculations above which division would you allocate those funds to and why? Division Evaluation Project Grading Rubric