All needs to be in excel functions. Thanks!

X All answers must be entered as a formula. Click OK to begin. OK Al fx The following information relates to overhead cost at Chocolates by Jacki for the A B F G D E 1 The following information relates to overhead costat Chocolates by Jack for the current year. 2 Total costs and distribution of resource consumption across activity cost pools 3 Activity Cost Pools 4 5 Customer Orders Total Cost Product Development Customer Relations Other Total 6 Production Department. 7 Indirect factory wages 8 Factory equipment depreciation 9 Factory utilities 10 Factory property taxes and insurance $ 400,000 150,000 120,000 75,000 50% 55% 59% 579 30% 30% 34% 3396 2596 096 098 016 5% 100% 15% 100% 7% 100% 10% 100% 205 52% 0% 10% 16% ON 40% 155 09 30% 100% 3796 100% 100% 100N 12 General Administrative Department 13 Administrative wages and salaries 275,000 14 Office equipment depreciation 40,000 15 Administrative property taxes and insurance 60,000 16 17 Maricing Department 18 Marketing was and salaries 150.000 19 Selling beses 200.000 20 21 Use the data to complete a First Star Allocation to Activity Cout Pools 22 when completing the table cooy formulsss appropriate 20% 32N ION 169 40% 15% 30N 100N 379100N D E F 3296 16% 15% B e Selling expenses 100,000 D 1 Use the data to complete a First-Stage Allocation to Activity Cost Pools -2 When completing the table, copy formulas as appropriate. 3 37% Activity Cost Pools 25 Total 26 Production Department: 27 28 29 30 31 32 General Administration Department 35 35 37 Marketing Department: + 40 mulation 6 Saved Total 5 Production Department: 7 8 9 0 51 32 General Administration Department: 33 34 35 36 37 Marketing Department: 38 39 40 41 Total 42 49 45 Sheet READY Attempts) 100%