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. (Hours worked per board = hours worked each week ÷ boards produced each week.)

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 theshifts.

Molding Department Week k 2 Week 3 Week 4 First shift Second shift 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