Can you please show me how you did this problem in excel? i need to type out the formula in each yell box.

Total costs and distribution of resource consumption across activity cost pools: Braded Worksheet B Chant of Accounts + fx. Accessibility tab summary: The, table for total costs and distribution of resource consumption across activity cost pools A B C D E (Use cells A5 to G20, as well as the "Chart of Accounts" tab for cell referencing and/or formulas needed to complete this question.) Production Depariment: Indirect factory wages Factory equipment depreciation Factory utilities Factory property taxes and insurance General Administration Department: Administrative wages and salaries Office equipment depreciation Adminstrative property taxes and insurance Marketing Department: 42 Marketing wages and salaries 43 Selling expenses 44 Total 45 A Graded Worksheet B Chart of Accounts +