8 Compare ROI & Residual income (16 marks) Barbie Barks Pet Food Company is a diversified company operates four (4) departments. The Time len 0:53:13 collected the following departmental information for 2020: Required: PART 1: 3. Calculate ROI (to 2 decimals) and rank the four departments based on their return on investment (RON) (4 marks) 17 26 Finish b. Calculate residual income (input dollars number only no cents or decimals) and rank the four departments based on their residual income. (4 marks) The highest ranking should be scored as 1 and the lowest ranking should be 4. Assume that the company requires a minimum return on the current investment of 16% (DO NOT ENTER ANY Dollar signs "$" or commas"." PLEASE ENTER NUMBERS AS 123456 and where 2 decimals indicated enter number like 123456.78) Part A Department Sales Cost of Goods Sold Average Operating Operating Operating Expenses Income Assets ROI Ranking (XX.XX%) based on ROI Part B Residual Income Ranking based in dollars/ no on Residual decimals) Income S Choose Edmonton $2,100,000 1,325,000 300.000 475,000 1,750,000 Choose . % Calgary 1,200.000 500.000 300.000 400.000 2,000,000 $ Choose Choose % Red Deer 320.000 150.000 $ 60,000 110,000 600,000 Choose Choose % Lethbridge 312,000 150.000 70.000 $ 92,000 400,000 Choose Choose % Required: PART 2: Time ler 0:52:41 Each department manager has been presented with a new investment opportunity that promises a zz% return on investment (ROI). Which department(s) are likely to accept or reject the opportunity if their performance is measured by (4 marks): 1. ROI? 2. Residual income? Department 1. Evaluated based on ROI 2. Evaluated based on Residual Income Edmonton Choose Choose Calgary Choose Choose... Red Deer Choose Choose... - Lethbridge Choose Choose (DO NOT ENTER ANY Dollar signs "$" or commas "PLEASE ENTER NUMBERS AS 123456 and where 2 decimals indicated enter number like 123456.78)