Practice Assignment - SPC Mini-Case Response Allison Jon, the manager of an 800-number reservation service for a nationwide chain of luxury hotels, is concerned about the productivity of her operation. Analysis of past data shows that it should take an average of five minutes to properly process a reservation. To setup a control chart for reservation service time, Allison records the time it takes to complete the reservation. She randomly samples 5 reservations every day for 30 days. Set up the appropriate control charts for these 30 days of data. Data File in BbLearn. Plot the data for these 30 days in an xbar chart and an r chart Now monitor the process. Ten days of data have been collected since creating the control charts A second 10 days of data have been collected. Questions 1) Comment about the control limits. What are control limits? Are the control limits you set appropriate? Explain 2) Comment on the reservation process in the first 10 days of monitoring. Ifthe control chart is not in control, be specific - which days, the pattern, and whether it is the xbar or r chart 3) Comment on the reservation process in the second 10 days of monitoring. If the control chart is not in control, be specific - which days, the pattern, and whether it is the xba or r chart 4) If the monitoring results show that the average reservation time or range in reservation time requires investigation, suggest some potential causes to be investigated. Be specific and be sure to explain how the potential causes relate to the point or pattern on the control chart that requires investigation Turn in the following in Bb Learn by the due date: Typed responses to the four questions above. Your responses should fully answer each question. Your responses should be professionally written (i.e.: clear, concise, correct) Xbar and R charts for 30 days - setup control limits Xbar and R charts for 1st 10 days of monitoring. Xbar and R charts for 2nd 10 days of monitoring. Excel worksheets used to create charts. Be sure to use good graphing techniques for all of the required charts Remember the trick is to plot the UCL, LCL, and center line and to repeat the values. Mini case SPC Data file-2 (2) AutoSave OFF Review View Home Insert Draw Page Layout Formulas Data A^ A Wrap Text Arial 10 General IUV AV $ Paste 00 C Merge & Center 00 fx G37 P A B C E E H J K L N O 1 Day 1 2 3 4 5 2 1 5.6 4.8 4.9 5.5 5.0 1st 10 Days of Monitoring Reservation Processing Time 2 3 4.6 5.7 5.3 4.9 4.8 4 3 5.4 4.3 5.2 5.2 5.4 Day 1 2 3 4 5 5 4 4.6 4.6 5.5 4.4 1 6.2 5.4 5.1 5.6 5.2 5.5 5.7 5 5.5 5.7 4.8 5.4 5.4 5.1 5.4 5.3 5.2 6 4.3 5.0 7 4.4 5.4 5.4 4.3 3 5.4 5.5 5.2 5.1 7 5.6 5.4 5.1 5.6 4.3 4 4.6 4.5 5.8 4.2 4.8 4.5 4.6 8 4.5 5.4 4.7 5 5.4 5.2 5.3 5.3 5.2 5.2 5.7 5.4 5.2 0 9 5.5 5.4 4.6 4.3 4.5 6 5.2 5.4 5.5 4.3 1 10 5.4 5.1 4.7 7 5.3 4.8 5.0 6.1 5.2 5.1 4.4 5.0 5.2 5.0 4.6 8 2 11 5.2 4.9 5.4 5.3 5.4 12 5.6 5.3 4.4 4.8 5.2 5.2 5.8 5.1 5.0 4.7 13 5.3 4.3 5.5 4.5 10 5.5 5.2 5.5 5.3 14 4.9 4.7 5 5.3 5.2 5.1 6 15 5.7 5.7 4.3 4.4 4.6 7 16 5.7 5.5 5.7 4.7 5.4 2nd 10 Days of Monitoring Reservation Processing Time Day 8 17 5.3 4.4 5.5 4.3 4.7 4.3 9 18 5.5 4.5 4.8 5.4 1 3 4 5 :0 1 2 3 19 5.2 4.3 4.3 5.4 5.0 4.3 5.8 1 5.6 4.3 6.3 5.4 4.4 20 5.6 5.7 4.5 4.5 2 5.5 5.4 3.9 3.9 21 5.7 5.7 5.0 5.5 4.9 3 4.0 4.3 3.9 6.1 6.1 22 5.1 5.4 4.5 5.6 4.8 4 4.9 4.6 4.3 5.8 3.9 4 23 4.5 5.0 4.5 4.3 4.4 5 5.2 4.7 4.2 5.4 4.4 5.1 5.6 4.1 4.8 4.8 6 24 4.5 4.3 4.6 5.5 6.1 4.1 5.7 25 5.4 5.2 4.3 4.4 7 5.3 5.1 6.0 5.5 5.2 7 26 5.5 6.4 5.7 5.6 5.5 5.2 8 6.5 3.5 6.1 4.9 28 27 4.5 4.7 5.0 4.6 4.9 9 6.5 4.1 6.4 4.1 5.2 28 4.4 4.4 5.4 5.7 10 4.4 4.8 5.7 4.7 6.3 60 29 5.6 5.3 4.9 4.8 5.0 1 5.5 30 4.4 5.1 5.1 5.5 2 3 4 Practice Assignment - SPC Mini-Case Response Allison Jon, the manager of an 800-number reservation service for a nationwide chain of luxury hotels, is concerned about the productivity of her operation. Analysis of past data shows that it should take an average of five minutes to properly process a reservation. To setup a control chart for reservation service time, Allison records the time it takes to complete the reservation. She randomly samples 5 reservations every day for 30 days. Set up the appropriate control charts for these 30 days of data. Data File in BbLearn. Plot the data for these 30 days in an xbar chart and an r chart Now monitor the process. Ten days of data have been collected since creating the control charts A second 10 days of data have been collected. Questions 1) Comment about the control limits. What are control limits? Are the control limits you set appropriate? Explain 2) Comment on the reservation process in the first 10 days of monitoring. Ifthe control chart is not in control, be specific - which days, the pattern, and whether it is the xbar or r chart 3) Comment on the reservation process in the second 10 days of monitoring. If the control chart is not in control, be specific - which days, the pattern, and whether it is the xba or r chart 4) If the monitoring results show that the average reservation time or range in reservation time requires investigation, suggest some potential causes to be investigated. Be specific and be sure to explain how the potential causes relate to the point or pattern on the control chart that requires investigation Turn in the following in Bb Learn by the due date: Typed responses to the four questions above. Your responses should fully answer each question. Your responses should be professionally written (i.e.: clear, concise, correct) Xbar and R charts for 30 days - setup control limits Xbar and R charts for 1st 10 days of monitoring. Xbar and R charts for 2nd 10 days of monitoring. Excel worksheets used to create charts. Be sure to use good graphing techniques for all of the required charts Remember the trick is to plot the UCL, LCL, and center line and to repeat the values. Mini case SPC Data file-2 (2) AutoSave OFF Review View Home Insert Draw Page Layout Formulas Data A^ A Wrap Text Arial 10 General IUV AV $ Paste 00 C Merge & Center 00 fx G37 P A B C E E H J K L N O 1 Day 1 2 3 4 5 2 1 5.6 4.8 4.9 5.5 5.0 1st 10 Days of Monitoring Reservation Processing Time 2 3 4.6 5.7 5.3 4.9 4.8 4 3 5.4 4.3 5.2 5.2 5.4 Day 1 2 3 4 5 5 4 4.6 4.6 5.5 4.4 1 6.2 5.4 5.1 5.6 5.2 5.5 5.7 5 5.5 5.7 4.8 5.4 5.4 5.1 5.4 5.3 5.2 6 4.3 5.0 7 4.4 5.4 5.4 4.3 3 5.4 5.5 5.2 5.1 7 5.6 5.4 5.1 5.6 4.3 4 4.6 4.5 5.8 4.2 4.8 4.5 4.6 8 4.5 5.4 4.7 5 5.4 5.2 5.3 5.3 5.2 5.2 5.7 5.4 5.2 0 9 5.5 5.4 4.6 4.3 4.5 6 5.2 5.4 5.5 4.3 1 10 5.4 5.1 4.7 7 5.3 4.8 5.0 6.1 5.2 5.1 4.4 5.0 5.2 5.0 4.6 8 2 11 5.2 4.9 5.4 5.3 5.4 12 5.6 5.3 4.4 4.8 5.2 5.2 5.8 5.1 5.0 4.7 13 5.3 4.3 5.5 4.5 10 5.5 5.2 5.5 5.3 14 4.9 4.7 5 5.3 5.2 5.1 6 15 5.7 5.7 4.3 4.4 4.6 7 16 5.7 5.5 5.7 4.7 5.4 2nd 10 Days of Monitoring Reservation Processing Time Day 8 17 5.3 4.4 5.5 4.3 4.7 4.3 9 18 5.5 4.5 4.8 5.4 1 3 4 5 :0 1 2 3 19 5.2 4.3 4.3 5.4 5.0 4.3 5.8 1 5.6 4.3 6.3 5.4 4.4 20 5.6 5.7 4.5 4.5 2 5.5 5.4 3.9 3.9 21 5.7 5.7 5.0 5.5 4.9 3 4.0 4.3 3.9 6.1 6.1 22 5.1 5.4 4.5 5.6 4.8 4 4.9 4.6 4.3 5.8 3.9 4 23 4.5 5.0 4.5 4.3 4.4 5 5.2 4.7 4.2 5.4 4.4 5.1 5.6 4.1 4.8 4.8 6 24 4.5 4.3 4.6 5.5 6.1 4.1 5.7 25 5.4 5.2 4.3 4.4 7 5.3 5.1 6.0 5.5 5.2 7 26 5.5 6.4 5.7 5.6 5.5 5.2 8 6.5 3.5 6.1 4.9 28 27 4.5 4.7 5.0 4.6 4.9 9 6.5 4.1 6.4 4.1 5.2 28 4.4 4.4 5.4 5.7 10 4.4 4.8 5.7 4.7 6.3 60 29 5.6 5.3 4.9 4.8 5.0 1 5.5 30 4.4 5.1 5.1 5.5 2 3 4