ALL ANSWERS MUST BE ENTERED AS A FORMULA

1. Assign Overhead Costs to Activity Cost Pools XU First-Stage Allocation to Activity Cost Pools - Excel ? x FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In i Calibri - 10 Paste BIU A % Cell Alignment Number Conditional Format as Cells Editing Formatting* Table Styles Styles fc The following information relates to overhead cost at Chocolates by Jacki for the Clipboard Font A1 F G B D E 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 Product Development Customer Relations Total Cost Other Total $ 8 400,000 150,000 120,000 75,000 6 Production Department: 7 Indirect factory wages Factory equipment depreciation Factory utilities 10 Factory property taxes and insurance 11 12 General Administrative Department: 13 Administrative wages and salaries 14 Office equipment depreciation 50 55% 59% 57% 30% 30% 34% 33% 159 0% 0% 100% 15% 100% 7% 100% 10% 100% 9 0% 275,000 40,000 20% 32% 10% 16% 40% 15% 30% 100% 37% 100% 32% 0% 16% 0% 15% 0% 37% 100% 100% 100% 14 Office equipment depreciation 40,000 15 Administrative property taxes and insurance 60,000 16 17 Marketing Department: 18 Marketing wages and salaries 150,000 19 Selling expenses 100,000 20 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 20% 32% 10% 16% 40% 15% 30% 100% 37% 100% 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 20 36 37 Marketing Department: 38 39 40 41 Total 42 43 44 45