The Ozuna Company uses a job

$-$

order costing system, and the principal concern is in determining its direct materials, direct labor and applied overhead allocation for each of the

$1$

$2$

$$jobs$.$ Overhead in the company is applied on a per labor hour basis using an average of $

$2$

$0$

$/$

hour

$.$

$$Our objective is to determine the allocated overhead and finally cost out each job. In this case, we need to figure out the applied overhead for Jobs

$4$

$$and

$9$

$$using a predetermined overhead rate. Within the

$$

Estimated MOH

$$

$$tab$,$ create a formula in cell E

$4$

$0$

$$that calculates a plantwide predetermined overhead rate this year. Using formulas that refer to your answers from requirements $14,$ 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.)$

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