D E F G H AB Excel formulas must be used. Please be sure to submit your file as an Excel file. Any submissions in .nu ROI & Servioe Cost Allooation Student Narne: Section Number: Revenues Operating Expenses Income before Service Charges Instructional Instructional Accounting Business 500,000 $ 1,000,000 250,000 $ 550,000 FORMULA 1 FORMULA 2 Investment $ 300,000 $ 500,000 ROI before service charges FORMULA 3 FORMULA 4 Number of professors Number of students in program 5 200 10 500 Payroll Advising (Driver is # of (Driver is # of professors) students) 100,000 $ 200,000 Service department expenses Service department charge rate FORMULA 5 FORMULA 6 Instructional Instructional Accounting Business $ 500,000 $ 1,000,000 Revenues Sheet1 + 07 A x fc F G AB C D LOVOU FORMULA 1 E www.uuu FORMULA 2 12 13 Income before Service Charges 14 15 o UAN 500,000 300,000 $ Investment FORMULA 3 ROI before service charges 16 17 18 FORMULA 4 19 Number of professors Number of students in program 5 200 10 500 20 21 22 23 Payroll Advising (Driver is # of (Driver is # of professors) students) 100,000 $ 200,000 Service department expenses 24 25 26 27 28 Service department charge rate FORMULA 5 FORMULA 6 Instructional Instructional Accounting Business $ 500,000 $ 1,000,000 $ 250,000 $ 550,000 250,000 $ 450,000 29 30 31 B2 33 34 B5 B6 37 38 59 Revenues Operating expenses Income before service charges Service charges: Payroll Advising Income from operations FORMULA 7 FORMULA 9 FORMULA 11 FORMULA 8 FORMULA 10 FORMULA 12 ROI after service charges FORMULA 13 FORMULA 14 ORN 12 Sheet1