Excel Analytics $05-02($Static$)$ Part $5$

Required:

$5.$ 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?$