? X First-Stage Allocation to Activity Cost Pools - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW - Sign In FILE HOME INSERT Calibri - 10 -A A - A Paste B I U - - Cells Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles Clipboard Font A1 X for The following information relates to overhead cost at Chocolates by Jacki for the E F C D 1 The following information relates to overhead costlat 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 $ 15% 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% 57% 30% 30% 34% 33% 5% 15% 7% 10% 100% 100% 100% 100% 11 275,000 40,000 60,000 20% 32% 10% 16% 0% 40% 15% 0% 30% 37% 100% 12 General Administrative Department: 13 Administrative wages and salaries 14 Office equipment depreciation 15 Administrative property taxes and insurance 16 17 Marketing Department: 18 Marketing wages and salaries 19 Selling expenses 100% 100% 100% 0% 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 ... Sheet1 ... + READY 8 0 -- + 100% Attempt(s) Hint X 5 ? X - Sign In FILE INSERT . HOME Calibri B I First-Stage Allocation to Activity Cost Pools - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW 10 AA = % D D - A Alignment Number Conditional Format as Cell Formatting Table Styles Styles Paste U Cells Editing - Font Clipboard X f x The following information relates to overhead cost at Chocolates by Jacki for the 19 Selling expenses 100,000 32% 16% 15% 37% 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: Marketing Department: Total Sheet1 ... + READY @ 0 -- + 100% Hint Attempt(s)