11 1 S MySeneca homepage x Courses x Bb 36802966 x C HRM732 - Introduction to Fix x C | Chegg.com AutoSave Off Homework #3 v Search (Alt+Q) File Home Insert Draw Page Layout Formulas Data Review View Automate Help General Calibri 12 ' ' $ % 9 Paste BIU v v Undo Clipboard W19 X fx A B C D Font E F 2 For its three investment centres, National Inc. accumulates the following data: per light are as follows: 3 4 5 6 7 8 9 Required: Centre | Centre II Centre III Sales Operating income ####### $4,000,000 ###### 1,300,000 2,000,000 ###### Average Operating A 5,000,000 8,000,000 15% Minimum required re 20% 25% Alignment > Number + Sabita Chhengutala Comments Share Conditional Formatting Insert 48 Format as Table Delete Cell Styles Format Sort & Find & Filter Select Analyze Sensitivity Data v Styles Cells Editing Analysis Sensitivity H | J K L M N 0 P Q R S T U V W Y Z AA AB AC 12 (1) Calculate the return on investment (ROI) for each centre. (6 marks) 13 15 16 17 19 20 21 22 23 25 26 (2) Calculate the residual income (RI) for each centre. (6 marks) 27 Cover page Q1 Q2 Q4 Q5 Q6 Q7 Q8 Ready Accessibility: Good to go -1C Mostly clear ENG Search US + 66% 8:51 PM 2022-11-14 28