XS FILE Paste Clipboard A1 1234 5 67699E 10 T 1- HOME INSERT Calibri 24 BIUT 6 Production Department: 25 A Font 10 17 Marketing Department: 18 Marketing wages and salaries 19 Selling expenses 20 B C D 1 The following information relates to overhead costlat Chocolates by Jacki for the current year. 2 Total costs and distribution of resource consumption across activity cost pools: PAGE LAYOUT Indirect factory wages Factory equipment depreciation Factory utilities Factory property taxes and insurance 11 12 General Administrative Department: 13 Administrative wages and salaries 14 Office equipment depreciation 15 Administrative property taxes and insurance 16 First-Stage Allocation to Activity Cost Pools - Excel FORMULAS DATA REVIEW A A % # A Alignment Number Conditional Format as Cell Formatting Table Styles E G Total Cost $ 400,000 150,000 120,000 75,000 275,000 40,000 60,000 150,000 100,000 21 Use the data to complete a First-Stage Allocation to Activity Cost Pools 22 When completing the table, copy formulas as appropriate 23 Customer Orders 50% 55% 59% 57% Styles 20% 32% 0% 20% 32% The following information relates to overhead cost at Chocolates by Jacki for the VIEW Activity Cost Pools Activity Cost Pools 30% 30% 34% 33% 10% 16% 0% 10% 16% I+I Cells E Product Customer Development Relations ER 15% 0% 0% 0% 40% 15% 0% ? 40% 15% Editing W F Other - 30% 37% 100% 4 30% 37% Sign In G 5% 100% 15% 100% 7% 100% 10% 100% Total 100% 100% 100% X 100% 100%

Sheet1 Sheet1