I need alot of help with putting answers in excel formula please!
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 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% Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you 04 fx AB FG H LM N ROI & Service Cont Allocation Student Name: Section Number: 9 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 32 13 14 15 16 17 18 -19 20 21 22 23 FORMULA FORMULA 4 ROI before service charges 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 24 25 26 22 35 Service department expenses Service department charge rate FORMULAS FORMULA 6 Instructional Instructional Accounting Business $ 500,000 $ 1,000,000 $ 250,000 $ 550,000 $ 250,000 $ 450.000 29 30 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 9 FORMULA 11 FORMULA FORMULA 10 FORMULA 12 FORMULA 14 ROI after service charges FORMULA 13 42 Sheet1 + Ready
