Use the data below to create Pivot Table(s) in Excel. You will use the pivot table(s) to fill out your answers in the requirements (worksheets) in Part 2. Submit your Excel File containing the Pivot Tables in Part 3. Decker Screw Manufacturing Company produces special screws made to customer specifications. During June, the following data pertained to these costs: Summary of Direct Materials Requisitions Department Job Requisition Number Cost per Number Number Quantity Unit 1 2906 B9766 4,950 $ 1.30 2 2907 B9767 190 22.00 1 2908 B9768 1,160 9.00 1 2906 B9769 4,830 1.31 2 2908 B9770 31 48.00 Summary of Direct Labor Time Tickets Department Job Ticket Cost per Number Number Number Hours Unit 1 2906 1056-1168 1,118 $ 6.50 2 2907 2121-2130 152 9.00 1 2908 1169-1189 167 6.50 2 2908 2131-1239 48 9.00 1 2906 1190-1239 826 6.50 Department Number 2 Summary of Factory Overhead Application Rates Basis of Application Rates $3 per direct labor hour 150% of direct labor cost Decker had no beginning Work-in-Process Inventory for June. Of the jobs begun in June, Job 2906 was completed and sold on account for $30,000, Job 2907 was completed but not sold, and Job 2908 was still in process. Required: 1. Calculate the direct materials, direct labor, factory overhead, and total costs for each job started in June. 2. Perform the same calculations as in requirement 1, but assume that the direct labor rate per hour increased by 10% in Department 1 and 25% in Department 2. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Calculate the direct materials, direct labor, factory overhead, and total costs for each job started in June. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Job 2906 Job 2907 Direct materials Direct labor Factory overhead Total job cost $ 0.00 $ 0.00 $ 0.00 $ Job 2908 Total $ 0.00 0.00 0.00 0.00 < Required 1 Required 2 > 2. Perform the same calculations as in requirement 1, but assume that the direct labor rate per hour increased by 10% in Department 1 and 25% in Department 2. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Perform the same calculations as in requirement 1, but assume that the direct labor rate per hour increased by 10% in Department 1 and 25% in Department 2. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Direct materials Direct labor Factory overhead Total job cost Job 2906 Job 2907 Job 2908 Total $ 0.00 0.00 0.00 $ 0.00 $ 0.00 $ 0.00 $ 0.00