please enter excel formula for each answer

X All answers must be entered as a formula. Click OK to begin. OK 1 The following information relates to overhead costat Chocolates by Jacka for the current year, 2 Total costs and distribution of resource consumption across activity cost pools 3 4 Activity Cost Pools Customer Relations Other Total 15% OX 0% 0% 556 100% 15% 100% 796 100% 10% 100% 5 Customer Product Total Cost Orders Development 6 Production Department 7 Indirect factory wages $ 400,000 50% 30% 8 Factory equipment depreciation 150.000 55% 30% 9 Factory utilities 120,000 59% 34% 10 Factory property taxes and insurance 75,000 57% 33% 11 12 General Administrative Department 13 Administrative wages and salaries 275,000 20% 10% 14 Office equipment depreciation 40,000 32% 169 15 Administrative property taxes and insurance 60,000 0% OS 16 17 Marketing Department: 18 Marketing wages and salaries 150,000 20% 10% 19 Selling expenses 100,000 32% 16% 20 21 Use the data to complete a First Stage Allocation to Activity Cost Pools 22 When completing the table, copy formulas as appropriate 23 20 Activity Cost Pools 4094 159 09 30% 100% 37% 100% 100% 100% 40% 15% 30% 100% 37% 100% 25 Chat 23 24 Activity Cost Pools 25 Total 26 Production Department 27 28 29 30 31 32 General Administration Department: 33 34 35 36 37 Marketing Department 38 39 40 41 Total 42 43 44 Sheet1