Module 6 Excel Spreadsheet Instructions Below you will seen theen sels of inouts. Afer inpalting al of ycar formulas. you shoulf be abie to use any of these sets of data and heve the arnwers auternaticaly lepdate For this sosegnment, plsase choose one of the data sets above and input all of the necessary formulas to find the answers. Once you are done, choses a different data set. enter it into your spreadsheet, and check the updated answe's ip ensure that owerything is fowing theuph fhe formulas appropriately. A check answer for each one has been providad. Doh Check foure (HO) after eervice charges - instructional Acoountrng): Check figure (ROR afler servise charges - Insthuctional Aocounting). 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. ROI&ServiceCostAllocation Student Name: Section Number: Revenues Operating Expenses Income before Service Charges Investment RO1 before serviee charges Number of professors Number of students in program Service department expenses Service department charge rate Revenues Operating expenses - Income before service charges Service charges: Payroll Advising Income from operations ROI after service charges \begin{tabular}{|c|c|} \hline \begin{tabular}{l} Instructional \\ Accounting \end{tabular} & \begin{tabular}{c} Instructional \\ Business \end{tabular} \\ \hline 500,000 & 1,000,000 \\ \hline 250,000 & 550,000 \\ \hline FORMUL & FORMULA \\ \hline \end{tabular} 300,0u0 500,000 FORMULA 3 FORMULA 4 520010500 FORMULA 5 FORMULA 6 \begin{tabular}{rr} \begin{tabular}{c} Instructioal \\ Accounting \end{tabular} & \begin{tabular}{c} Instructional \\ Business \end{tabular} \\ 500,000 & 1,000,000 \\ 250,000 & 550,000 \\ \hline 250,000 & 450,000 \end{tabular} FORMULA FORMULAs FORMULA? FORMULA 10 FORMULAII FORMULA12 PORMULA 13 FORMULA 14