Excel 2 - Due Sep 5, 2021 11:59 PM ACCT202-002-26993 Prin of Managerial Acct In this week's Excel assignment you will be calculating the job costs for 3 jobs performed during the year of a high-end custom furniture manufacturer and comparing the profitability with historical jobs of the company. On the "2021 Jobs" tab, calculate and sum the total job costs for each job with the information provided. Once the cost of each job is calculated, populate the job costs on the "Historical Jobs" tab for the respective Jobs. In separate columns, calculate the profit for each job and the profit margin % (profit divided by revenue). Once the profit and profit margin % columns are populated for each job complete the following steps in this order: 1) Highlight all jobs that produced a loss in red 2) Highlight the job with the highest profit margin % in green 3) Apply FILTER to the data and sort the Profit column by Largest to Smallest. Submit Excel workbook with highlights and FILTER applied as instructed. Please follow rubric and naming conventions outlined in Week 1 and in the rubric. Please let me know if you have any questions. Thank you! Manufacturing Overhead $ 7,500 Job 4001 Materials Requistions $ 4,000 Job 4002 Materials Requistions $ 10,200 Job 4003 Materials Requistions $ 7,100 Job 4001 Labor Hours 120 Job 4002 Labor Hours 275 Job 4003 Labor Hours 325 Manufacturing Overhead Allocated by Direct Labor Hours Hourly Wage $40 Job 4001 Job 4002 Job 4003 Direct Materials Direct Labor Indirect Costs