$!$

Required information

$[$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:

Click here to download the Excel template, which you will use to answer the questions that follow.

Click here for a brief tutorial on PivotTables in Excel.

Click here for a brief tutorial on VLOOKUP in Excel.

Required:

Go to the tab titled "Job Profitability.":

a$.$ Using formulas that refer to your answers from requirements $1-4,$ calculate the direct materials, direct labor, and applied overhead

cost for each of the $12$ jobs. $($Hint: Use VLOOKUP to reference values from the pivot tables you created in requirements $1$ and $2.)$

b$.$ What is the amount of applied overhead for Jobs $4$ and $9?$