PLEASE DO ENTIRE REQUIREMENT $1$ AND $2$ AND ATTACH THE PIVOT TABLE AS WELL

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:

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:

Calculate the direct materials, direct labor, factory overhead, and total costs for each job started in June.

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$

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.$)$

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 $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.$)$