this is all one question please help!

SACt): Use of the service departments is as follows Uwne the above dats, allocate all service deparment costs to the parks using each of the following methodk: 1. Drect Methad 2. step Method Gallocate maintenance first 3. Reciprocal Method Notei all work must be done in Excel, and all computations must he ilane in the spresdsheet. You may use the attached template or create your own. Allocation: Direct Method HR \% HRS $ Mice \% Mices Total Service costs Allocated Total costs Allocation: Step Method Mice % Mtce S HR% HR \$ Total Service Costs Allocated Total costs \begin{tabular}{|l|r|r|r|r|r|r|} \hline & \multicolumn{1}{|c|}{ Magic } & & Animal & Human & & \\ \hline & Kingdom & EPCOT & Kingdom & Resources & Maintenance & Total \\ \hline Human Resources & 32% & 38% & 18% & & 12% & 100% \\ \hline Maintenance & 42% & 19% & 26% & 13% & 100% \\ \hline Direct Costs (thousands) & & & & & \\ \hline \end{tabular} Allocation: Reciprocal Method Human Resources Maintenance Total Costs SACt): Use of the service departments is as follows Uwne the above dats, allocate all service deparment costs to the parks using each of the following methodk: 1. Drect Methad 2. step Method Gallocate maintenance first 3. Reciprocal Method Notei all work must be done in Excel, and all computations must he ilane in the spresdsheet. You may use the attached template or create your own. Allocation: Direct Method HR \% HRS $ Mice \% Mices Total Service costs Allocated Total costs Allocation: Step Method Mice % Mtce S HR% HR \$ Total Service Costs Allocated Total costs \begin{tabular}{|l|r|r|r|r|r|r|} \hline & \multicolumn{1}{|c|}{ Magic } & & Animal & Human & & \\ \hline & Kingdom & EPCOT & Kingdom & Resources & Maintenance & Total \\ \hline Human Resources & 32% & 38% & 18% & & 12% & 100% \\ \hline Maintenance & 42% & 19% & 26% & 13% & 100% \\ \hline Direct Costs (thousands) & & & & & \\ \hline \end{tabular} Allocation: Reciprocal Method Human Resources Maintenance Total Costs