Tony decided to monitor deliveries over the course of a full month. During each hour of delivery service operation, he randomly selected a phoned-in order. He then carefully measured the time required to prepare the order and the amount of time that the order had to wait for a delivery person to become available. Tony would then go with the delivery person to accurately measure the delivery time. After returning, Tony randomly selected an order placed during the next hour and repeated the process. At the end of the month. Tony had collected data on 240 deliveries. Once the data were available. Tony knew there were several issues that should be addressed. He was committed to going with the 29-minute delivery guarantee unless the data strongly indicated that the true average delivery time was greater than 25 minutes. How would he make this decision? Tony also realized that there were three components that could affect pizza delivery times: the preparation time, the waiting time for an available driver, and the travel time to deliver the pizza to the customer. Tony hoped that he had collected sufficient data to allow him to determine how he might improve the delivery operation by reducing the overall delivery time. Assignment Tony has asked you for some assistance in interpreting the data that he has collected. In particular, he needs to know if the true average delivery time for Pronto Pizza is greater than 25 minutes. Use the data in the attached file to answer his question. A description of this data set is given in the Data Description section. Also, examine the data for further information that might help Tony in making his decision about the 29- minute delivery guarantee and in improving his pizza delivery service. The Case Questions will assist you in your analysis of the data. Use important details from your analysis to support your recommendations. Data Description The attached file contains the data collected by Tony Scapelli over the past month on Pizza deliveries. Data are recorded for each delivery order placed in the manner described below. ] The variables are defined as follows: Day: Day of the week (1=Monday, 7=Sunday). Hour: Hour of the day (4-11 pm). Prep Time: Time Required (in minutes) to prepare the order. Wait Time: Time (in minutes) to prepare the order. Travel Time: Time (in minutes) it took the car to reach the delivery location. Distance: Distance (in miles) from Pronto Pizza to the delivery location.

Day Hour Prep Time Wait Time Travel Time Distance 4 14.86 3.08 6.02 2.5 5.47 5 14.84 13.81 3.3 15.41 9.91 8.99 4.9 16.34 2.08

Case Questions: Pronto Pizza

1. Is there sufficient evidence in the data to conclude that the average time to deliver a pizza, once the order is placed, is greater than 25 minutes? Perform an appropriate statistical analysis and attach any supporting output.

2. What percentage of the time will Pronto fail to meets its guaranteed time of 29 minutes or less? Explain how you arrived at your answer and discuss any assumptions that you are making. Will they meet their requirement of failing to meet the guarantee 5% of the time or less?

3. Does the day of the week have an effect on delivery time? Attach any supporting output for your answer.

4. Does the time of day have an effect on delivery time? Attach any supporting output for your answer.

5.Discuss Tony Scapelli's data design and collection. Comment on any potential problems resulting from the way in which the data were collected. Would you recommend that he collect additional data in order to better evaluate the pizza delivery service? Explain