Acct3360 - 5% SOH Assignment Due Oct 24 @ 11:59 Drop your Excel file into the Dropbox provided 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 Philco Pets: Dept Direct Costs # Employees Sq Meters Reporting 60,000 1,000 Custodial 40,000 1,000 Pet Store 72,000 3,000 Grooming 90,000 5,000 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. Your Excel spreadsheet must be your own (authored by you) starting with a new blank worksheet. Do Not attempt to use an existing spreadsheet or copy your solution from another student as this may be detected and may result in a zero grade and an academic dishonesty note in your permanent academic record. When you are done drop your completed Excel file into the Dropbox Provided