Go to the tab titled "Estimated MOH.": ***Excel shown below in picture***

a.For each of the seven variable manufacturing overhead expenses (highlighted in yellow), create a formula that calculates the estimated amount of the expense for this year. (Hint: Use last year's actual amount of each expense and the actual total labor hours [cell B39] as the basis for this year's estimates.)

3b.and3c.What is the estimated indirect materials cost in the Molding Department (cell E17)and the estimated utilities cost in the Fabrication Department (cell E21)?

nbers File Edit Insert Table Organize Format Arrange View Share Window Help MOLOF Q Sun Sep 1 O ExcelAnalytics_JobOrderCosting_PlantwidePredeterminedOverheadRates_Template 91% +! EB A View Zoom Add Category Insert Table Chart Text Shape Media Comment Collaborate Format Organize + PivotTable VLOOKUP Direct Materials Requisitions Direct Labor Summary Estimated MOH Job Profitability Waterfall Chart Last Year This Year Estimated Account Actual Amount Cost Behavior Amount Cost Behavior Equipment depreciation: Molding 400,000 Fixed 400,000 Fixed Equipment depreciation: Fabrication 300,000 Fixed 300,00 Fixed Equipment depreciation: Assembly 50,00 Fixed 50,000 Fixed Equipment depreciation: Materials Handling 15,000 Fixed 15,000 Fixed Equipment depreciation: Other 10,000 Fixed 10,000 Fixed Production suprvision: Molding 60,000 Fixed 63,000 Fixed Production supervision: Fabrication 65,000 Fixed 8,250 Fixed Production supervision: Assembly 58,00 Fixed 60,900 Fixed Indirect labor: Maintenance & Repairs 72,000 Fixed 5,600 Fixed Indirect labor: Materials Handling 68,000 Fixed 71,400 Fixed ndirect labor: Engineering 70,00 Fixed 178,500 Fixed Indirect labor: Raw Materials Purchasing 93,00 Fixed 97,650 Fixed Indirect labor: Quality Control 38,000 Fixed 39,900 Fixed Indirect labor: Packaging & Shipping 99,00 Fixed 103,950 Fixed Indirect materials: Molding 18,00 Variable Variable ndirect materials: Fabrication 13,00 Variable Variable Indirect materials: Assembly 8,000 Variable Variable Utilities: Molding 24,000 Variable Variable Utilities: Fabrication 20,000 Variable Variable Utilities: Assembly 6,000 Variable Variable Utilties: Plant lighting and other equipment 12,000 Fixed 12,240 Fixed Utilities: Heating and cooling 24,000 Fixed 24,480 Fixed Property insurance 26,00 Fixed 26,520 Fixed Liability insurance 18,00 Fixe 8,360 Fixed Medical insurance 45,000 Fixed 1,750 Fixed Workers' compensation insurance 13,000 Fixed 14,300 Fixed Other salaries: Plant manager 165,00 Fixed 173,250 Fixed Other salaries: Accounting 89,00 Fixed 93,450 Fixed Other salaries: Administrative support 56,00 Fixed 58,80 Fixed Other salaries: Janitorial 48,000 Fixed 50,400 Fixed Other salaries: Security and grounds maintenance 44,000 Fixed 46,200 Fixed Property taxes 18,00 Fixed 18,540 Fixed Payroll taxes: Direct labor 79,000 Variable Variable Payroll taxes: Other S 165,000 Fixed $ 173,250 Fixed Total Manufacturing Overhead $ 2,389,000 $ 2,295,690 Total direct labor hours 41,400 42,500 Plantwide predetermined overhead rateRequired: 3. Go to the tab titled \"Estimated MOH.": a. For each ofthe seven variable manufacturing overhead expenses (highlighted in yellow), create a formula that calculates the estimated amount of the expense for this year. (Hint: Use last year's actual amount of each expense and the actual total labor hours [cell 339] as the basis for this year's estimates.) 3b. and 3c. What is the estimated indirect materials cost in the Molding Department (cell E17) and the estimated utilities cost in the Fabrication Department (cell E21)? 3b. The estimated indirect materials cost in Molding is 3-c. The estimated utilities cost in Fabrication is