Click here for a brief tutorial on VLOOKUP in Excel. 5. Refer to the workbook titled "ExcelAnalytics_JobOrderCosting_PlantwidePredeterminedOverheadRates_Template" Navigate to the "Job Profitability" tab of this workbook. 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 ? Save your work in Excel, then enter your answer to requirement 5b below. Click here for a brief tutorial on VLOOKUP in Excel. 5. Refer to the workbook titled "ExcelAnalytics_JobOrderCosting_PlantwidePredeterminedOverheadRates_Template" Navigate to the "Job Profitability" tab of this workbook. 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 ? Save your work in Excel, then enter your answer to requirement 5b below