[HC JUIIUVITY WITHOur awes e quesLIIS Uisplayeu wenu. Ozuna Company uses a job-order costing system with a plantwide predetermined over hours. For job costing purposes, it uses an average direct labor wage rate of $20 per hc struggling financially, accordingly, it has asked you to conduct a job profitability study be of its existing cost system. To keep the scope of your project manageable, you have chc many jobs completed by the company during the year. Your goal is to complete the table the insights that it provides: WN Job 1 2 3 4 5 6 7 8 9 10 11 12 Sales $2,400 $5,400 $9,000 $1,450 $2,200 $7,000 $1,700 $1,600 $8,000 $4,100 $3,200 $2,800 Direct Materials 2 ? ? ? 2 2 ? ? 2 ? ? 2 Direct Labor ? ? ? ? ? 2 Gross Margin ? ? ? ? ? Applied Overhead ? 2 2 2 ? ? 2 2 Total Job Cost ? 2 ? ? ? ? 2 ? ? 2 2 ? ? 2 ? ? ? ? 2 ? ? ? Excel Analytics 02-02 (Static) Part 2 2. Go to the tab titled "Direct Labor Summary: a. Using PivotTable, calculate the total direct labor cost and total direct labor-hours fo b. What is the total direct labor cost for Jobs 3 and 10? c. What are the total direct labor-hours for Jobs 3 and 10? Complete this question by entering your answers in the tabs below. Req 2B Req 2c What the total direct labor cost for Jobs 3 and 10? Job 3 Job 10 The total direct labor cost is Req 2C> Excel Analytics 02-02 (Static) Part 2 2. Go to the tab titled "Direct Labor Summary.": a. Using PivotTable, calculate the total direct labor cost and total direct labor-ho b. What is the total direct labor cost for Jobs 3 and 10? c. What are the total direct labor-hours for Jobs 3 and 10? Complete this question by entering your answers in the tabs below. Req 2B Req 2c What are the total direct labor-hours for Jobs 3 and 10? Job 3 Job 10 The total direct labor hours are