!!!ALL ANSWERS MUST BE GIVEN IN A FORMULA!!!!

XD First-Stage Allocation to Activity Cost Pools - Excel ? El X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 10 AA % i IN Paste BIU Cells Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles Clipboard Font A1 fac The following information relates to overhead cost at Chocolates by Jacki for the E F G B D 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: 3 Activity Cost Pools 4 5 Customer Orders Total Cost Product Development Customer Relations Other Total $ 400,000 150,000 120,000 75,000 50% 55% 59% 57% 30% 30% 34% 33% 15% 0% 0% 0% 5% 100% 15% 100% 7% 100% 10% 100% 6 Production Department: 7 Indirect factory wages 8 Factory equipment depreciation 9 Factory utilities 10 Factory property taxes and insurance 11 12 General Administrative Department: 13 Administrative wages and salaries 14 Office equipment depreciation 15 Administrative property taxes and insurance 16 17 Marketing Department: 275,000 40,000 60,000 20% 32% 0% 10% 16% 0% 40% 15% 0% 30% 100% 37% 100% 100% 100% 6 7 Marketing Department: 3 Marketing wages and salaries Selling expenses 150,000 100,000 20% 32% 10% 16% 40% 15% 30% 100% 37% 100% 1 Use the data to complete a First-Stage Allocation to Activity Cost Pools. 2 When completing the table, copy formulas as appropriate. 3 4 Activity Cost Pools 5 Total Production Department: 7 8 9 D 1 2 General Administration Department: 21 Use the data to complete a First-Stage Allocation to Activity Cost Pools. 22 When completing the table, copy formulas as appropriate. 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 45 Sheet1 +