Please show how you got each asnwer!

Module 6 Excel Spreadsheet Instructions Below you will see three sets of inputs. After inputting all of your formulas, you should be able to use any of these sets of data and have the answers automatically update. For this assignment, please choose one of the data sets above and input all of the necessary formulas to find the answers. Once you are done, choose a different data set, enter it into your spreadsheet, and check the updated answers to ensure that everything is flowing through the formulas appropriately. A check answer for each one has been provided. Data set #1 Inputs: 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) Service department expenses $ 100,000 $ 200,000 Check figure (ROI after service charges - Instructional Accounting): 53% 1 Excel formulas must be used. Please be sure to submit your file as an Excel file. Any submissions in numbers format will receive a 0. 2 4 5 6 ROI & Service Cost Allocation Student Name: Section Number: 7 8 9 10 11 Instructional Instructional Accounting Business $ 500,000 $ 1,000,000 $ 250.000 $ 550,000 FORMULA 1 FORMULA 2 Revenues Operating Expenses Income before Service Charges 12 13 14 Investment $ 300,000 $ 500,000 15 16 17 18 19 ROI before service charges FORMULA 3 FORMULA 4 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 24 Service department expenses 25 26 27 28 Service department charge rate FORMULA 5 FORMULA 6 29 30 31 32 33 Instructional Instructional Accounting Business $ 500,000 $ 1,000,000 $ 250,000 $ 550,000 $ 250,000 $ 450,000 Revenues Operating expenses Income before service charges Service charges: Payroll Advising Income from operations 34 35 36 FORMULA 7 FORMULA 8 FORMULA 9 FORMULA 10 FORMULA 11 FORMULA 12 AB F G H Instructional Instructional Accounting Business 500,000 $ 1,000,000 250,000 $ 550,000 FORMULA 1 FORMULA 2 Revenues Operating Expenses Income before Service Charges ON C N UI - QJ TM - 6 Investment 300,000 $ 500,000 ROI before service charges 13 14 15 16 17 18 19 20 21 22 23 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 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 B0 31 32 33 34 35 36 37 38 39 40 Revenues Operating expenses Income before service charges Service charges: Payroll Advising Income from operations FORMULA 7 FORMULA 8 FORMULA 9 FORMULA 10 FORMULA 11 FORMULA 12 ROI after service charges FORMULA 13 FORMULA 14 +1