Day 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 1 5.6 4.6 5.4 4.6 5.5 4.4 5.6 4.3 5.5 5.4 4.6 5.6 5.3 5.3 4.6 5.7 5.3 5.5 5.2 5.4 5.7 5.1 4.5 5.1 5.4 5.5 4.5 4.4 5.6 5.5 2 4.8 5.7 4.3 4.6 5.7 4.3 5.4 4.5 4.3 5.4 4.4 4.4 5.3 5.2 5.7 5.5 4.4 4.3 4.3 5.6 5.7 5.4 5.0 5.6 5.2 5.7 4.7 4.4 5.3 4.4 3 4.9 5.3 5.2 5.5 4.8 5.4 5.1 5.4 5.7 5.1 5.2 4.8 4.3 4.9 5.7 5.7 5.5 4.5 4.8 5.7 5.0 4.5 4.5 4.5 4.3 5.6 5.0 5.4 4.9 5.1 4 5.5 4.9 5.2 5.5 5.7 5.4 5.6 4.6 4.5 4.3 4.6 5.2 5.5 4.7 4.3 4.7 4.3 4.8 5.4 4.5 5.5 5.6 4.3 4.8 4.8 5.5 4.6 5.2 4.8 5.1 5 5.0 4.8 5.4 4.4 5.4 4.3 4.3 4.7 5.2 4.7 4.9 5.2 4.5 5.1 4.4 5.4 4.7 5.4 5.0 4.5 4.9 4.8 4.4 4.3 4.4 5.2 4.9 5.7 5.0 5.5 1st 10 Days of Monitoring Reservatio Day 1 2 3 4 5 6 7 8 9 10 1 4.3 5.5 6.1 4.9 5.2 4.1 5.3 6.4 6.5 4.4 2nd 10 Days of Monitoring Reservatio Day 1 2 3 4 5 6 7 8 9 10 1 6.2 5.4 5.4 4.6 5.4 5.2 5.3 5.0 5.2 5.0 Days of Monitoring Reservation Processing Time 2 5.6 4.4 4.0 4.6 4.7 4.6 5.7 6.5 4.1 4.8 3 4.3 5.4 4.3 4.3 4.2 5.5 5.1 3.5 4.9 5.7 4 5.8 3.9 3.9 5.8 5.4 6.1 6.0 6.1 6.4 4.7 5 6.3 3.9 6.1 3.9 4.4 4.1 5.5 5.2 4.1 6.3 Days of Monitoring Reservation Processing Time 2 5.4 5.1 5.5 4.5 5.2 5.4 4.8 5.4 5.8 5.5 3 5.1 5.4 5.2 5.8 5.3 5.2 5.0 5.3 5.1 5.2 4 5.6 5.3 5.1 4.2 5.3 5.4 6.1 5.1 5.0 5.5 5 5.2 5.2 5.0 4.8 5.2 5.5 5.2 5.4 4.7 5.3 Day 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 1 5.6 4.6 5.4 4.6 5.5 4.4 5.6 4.3 5.5 5.4 4.6 5.6 5.3 5.3 4.6 5.7 5.3 5.5 5.2 5.4 5.7 5.1 4.5 5.1 5.4 5.5 4.5 4.4 5.6 5.5 2 4.8 5.7 4.3 4.6 5.7 4.3 5.4 4.5 4.3 5.4 4.4 4.4 5.3 5.2 5.7 5.5 4.4 4.3 4.3 5.6 5.7 5.4 5.0 5.6 5.2 5.7 4.7 4.4 5.3 4.4 3 4.9 5.3 5.2 5.5 4.8 5.4 5.1 5.4 5.7 5.1 5.2 4.8 4.3 4.9 5.7 5.7 5.5 4.5 4.8 5.7 5.0 4.5 4.5 4.5 4.3 5.6 5.0 5.4 4.9 5.1 4 5.5 4.9 5.2 5.5 5.7 5.4 5.6 4.6 4.5 4.3 4.6 5.2 5.5 4.7 4.3 4.7 4.3 4.8 5.4 4.5 5.5 5.6 4.3 4.8 4.8 5.5 4.6 5.2 4.8 5.1 5 5.0 4.8 5.4 4.4 5.4 4.3 4.3 4.7 5.2 4.7 4.9 5.2 4.5 5.1 4.4 5.4 4.7 5.4 5.0 4.5 4.9 4.8 4.4 4.3 4.4 5.2 4.9 5.7 5.0 5.5 1st 10 Days of Monitoring Reservatio Day 1 2 3 4 5 6 7 8 9 10 1 4.3 5.5 6.1 4.9 5.2 4.1 5.3 6.4 6.5 4.4 2nd 10 Days of Monitoring Reservatio Day 1 2 3 4 5 6 7 8 9 10 1 6.2 5.4 5.4 4.6 5.4 5.2 5.3 5.0 5.2 5.0 Days of Monitoring Reservation Processing Time 2 5.6 4.4 4.0 4.6 4.7 4.6 5.7 6.5 4.1 4.8 3 4.3 5.4 4.3 4.3 4.2 5.5 5.1 3.5 4.9 5.7 4 5.8 3.9 3.9 5.8 5.4 6.1 6.0 6.1 6.4 4.7 5 6.3 3.9 6.1 3.9 4.4 4.1 5.5 5.2 4.1 6.3 Days of Monitoring Reservation Processing Time 2 5.4 5.1 5.5 4.5 5.2 5.4 4.8 5.4 5.8 5.5 3 5.1 5.4 5.2 5.8 5.3 5.2 5.0 5.3 5.1 5.2 4 5.6 5.3 5.1 4.2 5.3 5.4 6.1 5.1 5.0 5.5 5 5.2 5.2 5.0 4.8 5.2 5.5 5.2 5.4 4.7 5.3 MGT 301 Prep 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) Are you comfortable with the control limits? Explain. 2) Comment on the reservation process in the first 10 days of monitoring. If the control chart indicates out-of-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 indicates out-of-control, be specific - which days, the pattern, and whether it is the xbar 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 patter 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 or ExcelOM 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. DATA: Data is available in the BbLearn file 'Mini-case SPC Data File\" Additional Instructions: This is an individual assignment. You may consult with your peers, but must complete and turn in your own assignment