Please provide me the answear in EXCEL

Philco Pets operates a petstore and a pet gooming salon. Philco also has 2 support departments as shown. Information about Philco Pets is shown in the table to the left. Reporting costs are allocated based on the # of employees Custodial costs are allocated based on the square meters used Required: Using Excel 1. Allocate SOH costs using the direct method 2. Allocate SOH costs using the step down method with Reporting allocated first 3. Allocate SOH costs using the step down method with Custodial allocated first Your Excel file should include a data section with hard coded numbers only. The solution section must use only formulae based on the data figures so that new correct solutions are generated in a dynamic manner. If your Excel sheet is not dynamic you will receive a grade of zero for this assignment