Please answer required A and B with an excel$/$chart response ty

Mack Precision Tool and Die has two production departments, Fabricating and Finishing, and two service departments, Repair and Quality Control. Direct costs for each department and the proportion of service costs used by the various departments for the month of March follow:

$$Proportion of Services Used byDepartmentDirect CostsRepairQuality ControlFabricatingFinishingFabricating$ $149,600$Finishing$112,200$Repair$48,30000\mathrm{.}20\mathrm{.}60\mathrm{.}2$Quality Control$90,3000\mathrm{.}800\mathrm{.}10\mathrm{.}1$

Required:

a: Use the step method to allocate the service costs, using the following:

b: The order of allocation starts with Repair.

The allocations are made in the reverse order $($starting with Quality Control$).$ Exercise $11-28($Algo$)$ Cost Allocation: Step Method $($LO $11-1)$

Mack Precision Tool and Die has two production departments, Fabricating and Finishing, and two service departments, Repair and Quality Control. Direct costs for each department and the proportion of service costs used by the various departments for the month of March follow:

Required:

Use the step method to allocate the service costs, using the following:

a$.$ The order of allocation starts with Repair.

b$.$ The allocations are made in the reverse order $($starting with Quality Control$).$

Complete this question by entering your answers in the tabs below.

Required $\backslash ($ B $\backslash )$

Use the step method to allocate the service costs, using the following:

The order of allocation starts with Repair.

Note: Amounts to be deducted should be indicated by a minus sign. Do not round intermediate calculations. Exercise $11-28($Algo$)$ Cost Allocation: Step Method $($LO $11-1)$

Mack Precision Tool and Die has two production departments, Fabricating and Finishing, and two service departments, Repair and Quality Control. Direct costs for each department and the proportion of service costs used by the various departments for the month of March follow:

Required:

Use the step method to allocate the service costs, using the following:

a$.$ The order of allocation starts with Repair.

b$.$ The allocations are made in the reverse order $($starting with Quality Control$).$

Complete this question by entering your answers in the tabs below.

Required $\backslash ($ A $\backslash )$

Required B

Use the step method to allocate the service costs, using the following:

The allocations are made in the reverse order $($starting with Quality Control$).$

Note: Amounts to be deducted should be indicated by a minus sign. Do not round intermediate calculations.