1. Assign Overhead Costs to Activity Cost Pools K 5. . 3 First-Stage Allocation to Activity Cost Pools - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW FILE HOME INSERT Sign In Calculate Now Function Defined Library Names Formula Auditing Calculation Calculate Sheet Options Calculation A5 1 2 The following information relates to overhead cost at Chocolates by Jacki for the current year. Total costs and distribution of resource consumption across activity cost pools: = new NP Activity Cost Pools Total Cost Customer Orders Product Development Customer Relations Other Total 6Production Department: 7 Indirect factory wages 8 Factory equipment depreciation 9 Factory utilities 10 Factory property taxes and insurance 15% 400,000 150,000 120 000 75 000 50% 30% 55% 30% E 0 % 59934940% 57% 33% 0% 5% 15% 7% 10% 100% 100% 100% 100% 11 12 General Administrative Department: 13 Administrative waees and salaries 14 office equipment depreciation Administrative property taxes and insurance 275,000 40,000 60.000 20% 32% 0% 10% 16% 0% 10% 15% 0% 30% 37% 100% 100% 100% 100% 17 Marketing Department: Marketing wages and solaries Selling expenses 150,000 100,000 1096 16% 30% 37% 100% 100% 21 Use the data to complete a First-Stage Allocation to Activity Cost Pools. 22 When completing the table, copy formulas as appropriate .. Sheet1 READY 0 -- + 100% Prev 1 of 1 !!! search ON 1. Assign Overhead Costs to Activity Cost Pools First-Stage Allocation to Activity Cost Pools - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW FILE HOME INSERT for 2 Calculate Now Function Defined Formula Library Names Auditing Calculation U Calculate Sheet Options Calculation A5 C D B 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: General Administration Department: RE PARITERET 37 Marketing Department: 41 Total LA Sheet1 READY - 100