Refer to assignment P 4 in this chapter. Linda Raymond needs to analyze the work performed by each shift in each department during Weeks 1 through 4.
1. For each department, calculate the average labor hours worked per board for each shift during Weeks 1 through 4. Carry your solution to two decimal places.
2. Using Excel's ChartWizard and the information from 1, prepare a line graph for each department that compares the hours per board worked by the first and second shifts and the estimate for that department during Weeks 1 through 4. The following is the suggested format to use for the information table needed to complete the line graph for the Molding Department:

3. Examine the four graphs that you prepared in 2. Which shift is more efficient in all four departments? List some reasons for the differences between the shifts.

Molding Department Week 1Week 2 Week 3Week 4 First shift Second shift 3 Estimated 3.50 3.60 3.40 3.20 3.40 3.40 3.40 3.80 3.40 3.80 4.20 3.40