Need Help entering in excel using excel formula!

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) Service department expenses 100,000 $ 200,000 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% 07 AB F G LM ROI & Service Cont Allocation Student Name: 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 10 11 12 13 14 15 16 17 18 19 20 21 22 23 ROI before service charges FORMULA FORMULA 4 Number of professors Number of students in program 5 200 10 500 Payroll Advising (Driver is of (Oriver 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 92 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 FORMULA 11 FORMULA FORMULA 10 FORMULA 12 ROI after service charges FORMULA 13 FORMULA 14 Sheet1 + Ready