A First-Stage Allocation to Activity Cost Pools - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW ? VIEW Sign In Calibri 10 AA % Paste BIU- Alignment Number Conditional Format as Cell Formatting Table Styles Cells Editing Clipboard Font Styles Al The following information relates to overhead cost at Chocolates by Jacki for the A B C 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 4 S 6 Production Department: 7 Indirect factory wages 8 Factory equipment depreciation 9 Factory utilities 10 Factory property taxes and insurance 11 E F G Activity Cost Pools Customer Product Total Cost Orders Development Customer Relations Other Total $ 400,000 50% 30% 15% 5% 100% 150,000 55% 30% 0% 15% 100% 120,000 59% 34% 0% 7% 100% 75,000 57% 33% 0% 10% 100% 12 General Administrative Department: 13 Administrative wages and salaries 275,000 20% 10% 40% 30% 100% 14 Office equipment depreciation 40,000 32% 16% 15% 37% 100% 15 Administrative property taxes and insurance 60,000 0% 0% 0% 100% 100% 16 17 Marketing Department: 18 Marketing wages and salaries 150,000 20% 10% 40% 30% 100% 19 Selling expenses 100,000 32% 16% 15% 37% 100% 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 Activity Cost Pools 25 < Prev 8 of 8 Next > MacBook Air