First Stage Allocation to Activity Cost Pools Excel FILE Sign In HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Conditional Format as Cell Paste Alignment Number Cells Editing B I U Formatting Table Styles Clipboard Font Styles fe The following information relates to overhead cost at Chocolates by Jacki for the v A1 i he following information relates to overhead cost at Chocolates by Jacki for the current year 2 Totalcosts and distribution of resource consumption across activity cost pools: Activity Cost Pools Total cost orders 6 Production Department: 7 indirect factory wages 15% 400,000 10 Factory equipment depreciation 50,000 55% 30%. 15 100% 9 Factory utilities 100% 10 Factory property taxes and insurance 75,000 57% 33% 10% 100% 11 12 General Administrative Department: 30% 100% 13 Administrative wages and salaries Office equipment depreciation 40,000 32% 16% 15% 37% 1008 15 Administrative property taxes and insurance 60,000 0% 0% 100% 100% 16 17 Marketing Department 18 Marketing wages and salaries 150,000 20% 10% 40% 30% 100% 15% 37% 100% Selling expenses 100,000 32% 16%d 19 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 Activity Cost Pools 24 25 26 Production Department: 27 28 29 30 31 32 General Administration Department: 33 34 Sheet1
