(Solved): WPS 300 (Tony s Pizza) Updated June 4 : Homework Assignment | Dr. Asish Satpathy...

WPS 300 (Tony s Pizza)

Updated June 4 :

Homework Assignment

Dr. Asish Satpathy

Tonys Pizza October 2020 UPDATE is ready. Click here to view it

Deliverable: [Max page limit – 5]
One word documents with all necessary screen shots from JMP analysis and your answers to all questions.
You must write your name and student ID on the first page of the document.
All answers should be in double space, 11-point font.

Tony’s Pizza is a family owned pizza restaurant in Tempe downtown. Antonio Scapelli started the business 30 years ago as Antonio’s Restaurant with just a few thousand dollars. Antonio, his wife, and their children, most of who are now grown, operate the business. Several years ago, one of Antonio’s sons, Tony, Jr, graduated from Arizona State University with an undergraduate degree in business administration. After graduation, he came back to manage family business. Tony’s pizza was one the earliest pizza restaurants to offer pizza delivery to homes. Fortunately, Tony had foresight to make this business decision a few years ago. At the same time, he changed the restaurant’s name from Antonio’s to Tony’s Pizza to emphasize the pizza delivery service. The restaurant has thrived since then, and has become one of the leading businesses in the area. While many of their customers still dine-in at the restaurant, nearly 91% of Tony’s current business is delivered from the pizza delivery service.
Recently, one of the national chain fast food pizza delivery services found its way to Tempe. In order to attract business, this new competitor has guaranteed delivery of its pizza within 30 minutes after order is placed. If the delivery is not made within 30 minutes, the customer receives the order without charge. Before long, there were signs that this new pizza restaurant was taking business away from Tony’s pizza. Tony realized that Tony’s pizza would have to offer a similar guarantee in order to remain competitive.

After a careful cost analysis, Tony determined that to offer a guarantee of 29 minutes or less, Tony’s average delivery time would have to be 25 minutes or less. Tony thought that this would limit the percentage of ‘free pizza’ under the guarantee to about 5% of all deliveries, which he had ability to deliver on a promise of 29 minutes or less. Tony knew that he needed to collect data on Tony’s pizza deliveries.
Tony’s Pizza’s delivery service operates from 4.00 pm to midnight every day of the week. After an order for a pizza is phoned in, one of the two chefs is given the order for preparation. When the crust is prepared and the ingredients have been added, the pizza is placed on the belt of the conveyor oven. The speed of the conveyor is set so that pizzas come out perfectly, time after time. Once the pizza is ready and one of the Tony’s drivers is available to make the delivery, the pizza is taken in a heat-insulated bag to the customer. Tony’s uses approximately five to six drivers each night for deliveries. Most of the drivers hired by Tony’s pizza are either seniors at the local high school or freshman/sophomore at the Arizona State University.

Given the large number of deliveries made each evening, Tony knew that he could not possibly monitor every single delivery. He had thought of the possibility of having someone else collect the data, but given the importance of data accuracy, he decided to make all the measurements himself. This, of course, meant taking a random sample of, rather than all, deliveries over some period of time. Tony decided to monitor deliveries over the course of a full month. During each hour of delivery service operation, he randomly selected a phone-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 have been addressed. He was committed to going with the 29-minutes 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 delivery time.
 

Assignment
Tony has asked you for some assistance in interpreting the data he has collected. In particular, he needs to know if the true average delivery time for Tony’s Pizza is greater than 25 minutes. Use the data in the file pizza.jmp to answer his questions. 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 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 recommendation.
 

Data Description
The pizza.jmp 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 depicted below.
Homework Assignment WPC 300

The variables are defined as follows:
Day: Day of the week (1=Monday, 7=Sunday)
Hour: Hours of the day (4-11 pm)
Prep. Time: Time required (in minutes) to prepare the order
Wait Time: Time (in minutes) from completing preparation of the order until a delivery
Person was available to deliver the order.
Travel Time: Time (in minutes) it took the car to reach the delivery location
Distance: Distance (in miles) from Tony’s pizza to the delivery location.

Case Questions

1. Is there sufficient evidence to conclude that the average time to deliver a pizza, once the order placed, is greater than 25 minutes? Perform an appropriate statistical test to support your conclusion (infer for the population) and attach all necessary output from JMP analysis to support your answer. [5 points]
2. Does the day of the week have an effect on delivery time? How? Perform an appropriate statistical test to support your conclusion. Attach all necessary output from JMP to support your answer. [5 points]
3. Does the time of day have an effect on delivery time? Perform an appropriate statistical test to support your conclusion. Attach necessary JMP output to support your answer. [5 points]
4. 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. [5 points]
5. Based on your analysis of the data, what action (or actions) would you recommend to the owners of Tony’s Pizza to improve their operations? Attach any supporting JMP output that led to your conclusion. [5 points]