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.

Transcribed Image Text:

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