Will you please help me answer this question

1. Assign Overhead Costs to Activity Cost Pools ? x First-Stage Allocation to Activity Cost Pools - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW - 6 Sign In FILE HOME INSERT Paste B I -10 AA U- - - A - Alignment Number - Font Cells Editing Conditional Format as Cell Formatting Table Styles Styles Clipboard A1 X x The following information relates to overhead cost at Chocolates by Jacki for the EF A 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 Customer Orders Product Development Customer Relations Total Cost Other Total $ 6 7 8 9 10 Production Department: Indirect factory wages Factory equipment depreciation Factory utilities Factory property taxes and insurance 400,000 150,000 120.000 75,000 50% 55% 59% 57% 30% 30% 34% 33% 15% 0% 0% 5% 15% 7% 10% 100% 100% 100% 100% 12 General Administrative Department: 13 Administrative wages and salaries 14 Office equipment depreciation 15 Administrative property taxes and insurance 275,000 40.000 60,000 20% 32% 0% 10% 16% 0% 40% 15% 0% 30% 37% 100% 100% 100% 100% 17 Marketing Department: 18 Marketing wages and salaries 19 Selling expenses 150,000 100,000 20% 32% 10% 16% 40% 15% 30% 37% 100% 100% 21 Use the data to complete a First-Stage Allocation to Activity Cost Pools. 22 When completing the table, copy formulas as appropriate. Activity Cost Pools Paste B I U , I. - A - Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles Styles Clipboard Font A1 x fc The following information relates to overhead cost at Chocolates by Jacki for the C D E 18 Marketing wages and salaries 19 Selling expenses 150,000 100,000 20% 32% 10% 16% 40% 15% 30% 37% 100% 100% 21 Use the data to complete a First-Stage Allocation to Activity Cost Pools. 22 When completing the table, copy formulas as appropriate. Activity Cost Pools Total 26 Production Department: 32 General Administration Department: 37 Marketing Department: 41 Total 44 ... Sheet1 ... + @ -- READY Attempt(s) + 100% Show Me Hint