I need help with any formulas.

1. Assign Overhead Costs to Activity Cost Pools 3 ? - X XD FILE . HOME First-Stage Allocation to Activity Cost Pools - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW INSERT Sign In Calibri B I U - 10 AA . A G Cells Paste Clipboard Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles Font A27 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: Activity Cost Pools Uw Customer Orders Product Development Customer Relations Total Cost Other Total $ 6 Production Department: 7 Indirect factory wages 8 Factory equipment depreciation 9 Factory utilities 10 Factory property taxes and insurance 15% 0% 400,000 150,000 120,000 75,000 50% 55% 5996 5796 30% 30% 34% 33% 5% 15% 7% 10% 100% 100% 100% 100% 12 General Administrative Department: 13 Administrative wages and salaries 14 Office equipment depreciation 15 Administrative property taxes and insurance 10% 275,000 40,000 60,000 20% 32% 0% 40% 15% 0% 30% 37% 100% 100% 100% 100% 0% 17 Marketing Department: 18 Marketing wages and salaries 19 Selling expenses 150,000 100,000 20% 3296 10% 16% 40% 1596 30% 37% 100% 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. Activity Cost Pools Total 26 Production Department: 32 General Administration Department: 37 Marketing Department: 41 Total