1. Assign Overhead Costs to Activity Cost Pools

(fill in the excel blanks with formulas only)

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 Activity Cost Pools Product Customer Orders Customer Development Relations Total Cost Other Total Production Department Indirect factory wages Factory equipment depreciation Factory utilities Factory property taxes and insurance $400,000 150,000 120,000 75,000 50% 55% 59% 57% 30% 30% 34% 33% 15% 0% 0% 0% 5% 15% 7% 10% 100% 100% 100% 100% General Administrative Department: Administrative wages and salaries Office equipment depreciation Administrative property taxes and insurance 275,000 40,000 60,000 20% 32% 096 10% 16% 096 40% 15% 0% 30% 37% 100% 100% 100% 100% Marketing Department: Marketing wages and salaries Selling expenses 150,000 100,000 20% 32% 10% 16% 40% 15% 30% 37% 100% 100% Use the data to complete a First-Stage Allocation to Activity Cost Pools When completing the table,copy formulas as appropriate