Need help putting in excel with excel formulas.

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% Data set #2 Inputs: Revenues Operating Expenses Income before Service Charges Instructional Instructional Accounting Business $ 600,000 $ 1,000,000 250,000 $ 600,000 FORMULA 1 FORMULA 2 Investment $ 750,000 $ 900,000 ROI before service charges FORMULA 3 FORMULA 4 Number of professors Number of students in program 20 700 5 500 Payroll Advising (Driver is # of (Driver is # of professors) students) 100,000 $ 200,000 Service department expenses Check figure (ROI after service charges - Instructional Accounting): 20% Focus Data set #3 Inputs: Revenues Operating Expenses Income before Service Charges Instructional Instructional Accounting Business $ 600,000 $ 1,200,000 250,000 $ 800,000 FORMULA 1 FORMULA 2 Investment $ 750,000 $ 1,000,000 ROI before service charges FORMULA 3 FORMULA 4 Number of professors Number of students in program 20 700 20 300 Payroll Advising (Driver is # of (Driver is # of professors) students) 100,000 $ 400,000 Service department expenses Check figure (ROI after service charges - Instructional Accounting): 3% MacBook Air AB D E ROI & Service Cost Allocation Student Name: Section Number: 9 Instructional Instructional Accounting Business 500,000 $ 1,000,000 $ 250,000 $ 550.000 FORMULA 1 FORMULA 2 $ 300,000 $ 500,000 10 11 12 13 14 15 16 27 18 19 20 21 22 23 Revenues Operating Expenses Income before Service Charges Investment ROI before service charges Number of professors Number of students in program FORMULA 3 FORMULA 4 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 30 33 32 aa 34 35 36 37 38 39 40 Revenues Operating expenses Income before service charges Service charges Payroll Advising Income from operations FORMULA 7 FORMULA FORMULA 11 FORMULAB FORMULA 10 FORMULA 12 ROI after service charges FORMULA 13 FORMULA 14 42