To complete this activity, you will need to have Excel installed on your computer. This activity requires you to work in Excel and answer questions in Connect. You will read a brief scenario and then download an Excel file that you will need to answer the required questions.

Some of the requirements will require you to view brief video tutorials. You will then use what you learned to work directly in Excel to answer required questions.

$[$The following information applies to the questions displayed below.$]$

Ozuna Company uses a job$-$order costing system with a plantwide predetermined overhead rate based on direct labor$-$hours. For job costing purposes, it uses an average direct labor wage rate of $$20$ per hour. The company has been struggling financially; accordingly, it has asked you to conduct a job profitability study beginning with a thorough critique of its existing cost system. To keep the scope of your project manageable, you have chosen a subset of $12$ jobs from the many jobs completed by the company during the year. Your goal is to complete the table shown below and comment on the insights that it provides:

Job Sales Direct Materials Direct Labor Applied Overhead Total Job Cost Gross Margin

$1$ $$2,400?$question mark $?$question mark $?$question mark $?$question mark $?$question mark

$2$ $$5,400?$question mark $?$question mark $?$question mark $?$question mark $?$question mark

$3$ $$9,000?$question mark $?$question mark $?$question mark $?$question mark $?$question mark

$4$ $$1,450?$question mark $?$question mark $?$question mark $?$question mark $?$question mark

$5$ $$2,200?$question mark $?$question mark $?$question mark $?$question mark $?$question mark

$6$ $$7,000?$question mark $?$question mark $?$question mark $?$question mark $?$question mark

$7$ $$1,700?$question mark $?$question mark $?$question mark $?$question mark $?$question mark

$8$ $$1,600?$question mark $?$question mark $?$question mark $?$question mark $?$question mark

$9$ $$8,000?$question mark $?$question mark $?$question mark $?$question mark $?$question mark

$10$ $$4,100?$question mark $?$question mark $?$question mark $?$question mark $?$question mark

$11$ $$3,200?$question mark $?$question mark $?$question mark $?$question mark $?$question mark

$12$ $$2,800?$question mark $?$question mark $?$question mark $?$question mark $?$question mark

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)?$

Save your work in Excel, then enter your answers to requirements $3$b and $3$c in the tabs below.