8 Compare ROI & Residual income (16 marks) Barkle Barks Pet Food Company is a diversified company, operates four (4) departments. The comba collected the following departmental information for 2020: Time left 0:58:06 Required: PART 1: 17 26 Fini a. Calculate ROI (to 2 decimals) and rank the four departments based on their return on investment (ROI) (4 marks) 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 $ 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 %