Required:

$3.$ Refer to the workbook titled "ExcelAnalytics$\_$JobOrderCosting$\_$PlantwidePredeterminedOverheadRates$\_$Template"

Navigate to the $$Estimated MOH$$ tab of this workbook.

a$.$ For each of the seven variable manufacturing overhead expenses $($highlighted in yellow in the workbook$),$ 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 B$39]$ as the basis for this year$$s estimates.$)$

$3$b$.$ and $3$c$.$ What is the estimated indirect materials cost in the Molding Department $($cell E$17)$ and the estimated utilities cost in the Fabrication Department $($cell E$21)?$

Also, what would the plantwide predetermined overhead rate be$?$