X AutoSave @ Off 20211_ACG2071_Module 6 Decentralized... Search Falenda Bureau FB X File Home Insert Page Layout Formulas Data Review View Automate Help Comments Share Arial Rounded MT B * 11 A A ab Custom Conditional Formatting Insert Ex AY O $ ~ % Format as Table Delete V v Paste BIU~ E Sort & Find & Analyze Sensitivity Add-ins 308 Cell Styles Format Filter * Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity Add-ins E27 vi X fx =(E20*E25) A B C D E F G H I J K LM N O P Q R S y Instructional Instructional 10 Accounting Business 11 Revenues $ 500,000 $ 1,000,000 12 Operating Expenses 250,000 $ 550,000 13 Income before Service Charges 250,000 $ 450,000 14 15 Investment $ 300,000 $ 500,000 16 17 ROI before service charges 83% 90% 18 19 Number of professors 5 10 20 Number of students in program 200 500 21 22 23 Payroll Advising (Driver is # of (Driver is # of 24 professors) students) 25 Service department expenses $ 100,000 $ 200,000 26 > Sheet + Ready Accessibility: Investigate + 100% 76. F 12:56 PM Q Search W Sunny 10/18/2023 2X AutoSave @ Off 20211_ACG2071_Module 6 Decentralized... Search Falenda Bureau FB X File Home Insert Page Layout Formulas Data Review View Automate Help Comments Share A A ab Custom Conditional Formatting Insert Arial Rounded MT B * 11 Ex AY O $ ~ % Format as Table Delete V v Sort & Find & Add-ins Paste Analyze Sensitivity BIU~ E 308 Cell Styles Format Filter * Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity Add-ins E27 =(E20*E25) AB C D E F G H I J K LM N O P Q R S 23 Payroll Advising Driver is # of (Driver is # of 24 professors) students) 25 Service department expenses $ 100,000 $ 200,000 26 27 Service department charge rate $ 500,000 28 Instructional Instructional 29 Accounting Business 30 Revenues 500,000 $ 1,000,000 31 Operating expenses 250,000 550,000 32 Income before service charges 250,000 450,000 33 Service charges: 34 Payroll FORMULA 7 FORMULA 8 35 Advising FORMULA 9 FORMULA 10 36 Income from operations FORMULA 11 FORMULA 12 37 38 ROI after service charges FORMULA 13 FORMULA 14 39 Sheet1 + Ready Accessibility: Investigate + 100% 76. F 12:56 PM Q Search W Sunny 10/18/2023 2