Show excel formulas!

1. Assign Overhead Costs to Activity Cost Pools First-Stage Allocation to Activity Cost Pools-Excel Sign in HOME INSERT PAGE LAYOUT TI FORMULAS DATA REVIEW VIEw 10A A A Alignment Number Condisional Format as Cell Formatting , Table Styles Paste B IU The following information relates to overhead cost at Chocolates by Jacki for the Al to overhend cost Chocolates by lacks for the cumes year 1 The following information relates Total costs and dstribution of resource consumption across activity cost pools Adit Customer Prodact Customer Total Cost Orders Development Relations Total Other 6 Production Department 7 Indizect factory wages 8 Factory equipment depreciation 9 Factory utilitics 10 Factory property tases and insurance $ 400,000 1S0 000 120 000 75,000 30% 30% 34 33% 15% 0% 0% 5% 15% 7% 10% 100% 100% 100% 100% 55% 57% 12 General Administrative Department 13 Adsinistrative wages and salaries 14 Office equipment depreciation 15 Administrative property taxes and insurance 16 10% 16% 0% 275 000 40,000 60 000 30% 37% 100% 100% 100% 100% 32% 15% oter 17 Excel Assignment 17 18 Marketing wages and salaries 19 Selling expenses 30%, 37% | 10% 15% 150,000 100 ,000 20% 40% 15% 100% 100% 21 Use the data to complete &First-Stage Allocation to Activity Cost Pools 22 When completing the table, copy formulas as appropriate 23 24 Activity Cost Paols 25 Total 26 Production Departmest 27 28 Book 30 31 2 General Administration Department 34 35 36 7 Marketing Department 39 41 Total Sheeti 100% Attemptis) 17 Excel Assignment 21 Use the data to complete a First-Stage Allocation to Activity Cost Pools 22 When completing the table, copy formolas as appropriate 23 Activity Cost Pools 25 26 28 Total 30 31 32 General Administration Department 34 35 36 7 Marketing Department 19 1 Total 43 45 Sheeti