Please include cell formulas

First-Stage Allocation to Activity Cost Pools 1. Assign Overhead Costs to Activity Cost Pools 1 The following information relates to overhead cost at Chocolates by Jacki for the current year 2 Total costs and distribution of resource consumption across activity cost pools Activity Cost Pools 4 Customer Product Customer Total Cost Other Total Orders DevelopmentRelations 6 Production Department: 7 Indirect factory wages 8 Factory equipment depreciation 9Factory utilities 10 Factory property taxes and insurance $ 400,000 150,000 50% 30% 5% 100% 0% 55% 30% 15% 100% 0% 120,000 59% 34% 7% 100% 57% 0% 75,000 33% 10% 100% 12 General Administrative Department: 13 Administrative wages and salaries 275,000 20% 10% 40% 30% 100% 40,000 32% 16% 37% 100% 14 Office equipment depreciation 0% 0% 0% Administrative property taxes and insurance 60,000 100% 100% 15 17 Marketing Department: 18 Marketing wages and salaries 19 Selling expenses 150,000 20% 10% 40% 30% 100% 1 5% 100,000 32% 16% 37% 100% 20 21 Use the data to complete a First-Stage Allocation to Activity Cost Pools 22 When completing the table, copy formulas as appropriate 3 Activity Cost Pools 24 5 Total uction Department: 7 8 0 2 General Administration Department 3 4 5 6 7 Marketing Department: 39 1 Total 14 15