can you get me the formula to excel First-Stage Allocation to Activity Cost Pools - ExcelFILEHOMEINSERTPAGE LAYOUTFORMULASDATAREVIEWVIEWSign InF10 FA aCalibriAlignment Number Conditional Format as CellFormatting-PasteBIUCellsEditingTable StylesClipboardFontStylesC27fe---ABDEG21 Use the data to complete a First-Stage Allocation to Activity Cost Pools.22 When completing the table, copy formulas as appropriate.2324Activity Cost Pools25CustomerProductCustomerOrdersDevelopmentRelationsOtherTotal26 Production Department:27 Indirect factory wages$200,00028 Factory equipment depreciation29 Factory utilities30 Factory property taxes and insurance3132 General Administration Department:33 Administrative wages and salaries34 office equipment depreciation35 Administrative property taxes and insurance3637 Marketing Department:38 Marketing wages and salaries39 selling expenses4041 Total42434445Sheet1READY100 %Attem pt(s)4/5HintStep: Use Auto Fill to copy Cell B27 to C27 through E27. 国日。First-Stage Allocation to Activity Cost Pools - ExcelFILEHOMEINSERTPAGE LAYOUTFORMULASDATAREVIEWVIEWSignCalibri10%Alignment Number Conditional Format as CellFormatting-PasteBIUACellsEd itingTable StylesClipboardFontStylesC27frABDEFG34Activity Cost PoolsCustomerProductCustomerTotal CostOrdersDevelopmentRelationsOtherTotal6 Production Department:$ 400,00050%7Indirect factory wagesFactory equipment depreciation30%15%5% 100%8150,00055%30%0%15% 100%Factory utilities120,00059%34%0%7% 100%10 Factory property taxes and insurance75,00057%33%0%10% 100%1112 General Administrative Department13 Administrative wages and salaries275,00020%10%40%30% 100%14 Office equipment depreciation15 Administrative property taxes and insurance40,00032%16%15%37% 100%60,0000%0%100% 100%1617 Marketing Department:18 Marketing wages and salaries19 Selling expenses150,00020%10%40%30% 100%100,00032%16%15%37% 100%2021 Use the data to complete a First-Stage Allocation to Activity Cost Pools.22 When completing the table, copy formulas as appropriate.23>

Activity-based costing is a costing approach in which a company's activities are identified and the…

3 Activity Cost Pools Customer Product Customer Total Cost Orders Development Relations Other Total 6 Production Department 7 Indirect factory wages 8 Factory equipment depreciation 9 Factory utilities $ 400,000 50% 30% 15% 5% 100% 150,000 55% 30% 0% 15% 100% 120,000 59% 34% 0% 7% 100% 10 Factory property taxes and insurance 75,000 57% 33% 0% 10% 100% 11 12 General Administrative Department 13 Administrative wages and salaries |14 Office equipment depreciation 275,000 20% 10% 40% 30% 100% 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 19 Selling expenses 150,000 20% 10% 40% 30% 100% 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.