1- Assign Overhead Costs to Activity Cost Pools

The following information relates to overhead cost at Chocolates by Jacki for the current year.

Total costs and distrubtion of resource consumption across activity cost pools:

How do i fill the cells.

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