Columbia Pizza Has One Oven That Can Make A Whole Pie In About 10 Minutes. 

Their Late-night Business Among Hungry College Students Is Booming, And From 9 Pm - 11 Pm, They Average 5 Pie Orders Per Hour. However, From 5 Pm - 9 Pm, They Average Only 3 istribution. The ...

Pie Orders Per Hour. Both Order Rates Can Be Assumed Arrive According To A Poisson D

Columbia Pizza has one oven that can make a whole pie in about 10 minutes. Their late-night business among hungry college students is booming, and from 9 pm - 11 pm, they average 5 pie orders per hour. However, from 5 pm - 9 pm, they average only 3 pie orders per hour. Both order rates can be assumed arrive according to a Poisson distribution.

The owner of Columbia Pizza has discovered that if people have to wait for more than 20 minutes from when they get in the door to when they receive their pie, they are likely to simply go next door to University Falafel, meaning that Columbia Pizza would lose out on their $20 sale.

The owner is thinking of buying a second pizza oven and register (e.g. a second channel) that he thinks would cost $75 per night to operate (for the sake of our example, that is both the amortized cost of the oven and the pay of the person who is taking orders for the six hours that the pizza shop is open).

1. Calculate the following for the 5-9 shift and the 9-11 shift
2. Average # of orders in the system
3. Average time order spends in the system (minutes)
4. Average # of orders in the queue
5. Average waiting time in the queue (minutes)
6. Utilization
7. Assuming all customers are able to be served, what is the total maximum revenue opportunity for Columbia Pizza?
8. In order to achieve the 20 minute total time from door to when they receive their pie, assuming one oven is available, what is the total revenue opportunity?
9. Calculate the average daily loss of sales to University Falafel.
10. If Columbia Pizza buys a second oven, calculate the following for the 5-9 shift and the 9-11 shift
11. Average # of orders in the system
12. Average time order spends in the system (minutes)
13. Average # of orders in the queue
14. Average waiting time in the queue (minutes)
15. Assuming all customers are able to be served, what is the total maximum revenue opportunity for Columbia Pizza?
16. In order to achieve the 20 minute total time from door to when they receive their pie, assuming two ovens are available, what is the total revenue opportunity?
17. Calculate the average daily loss of sales to University Falafel.
18. Based on your calculations, should Columbia Pizza buy the second oven? Why? What is the net financial impact?
19. Assume now that an improvement in the pizza making process results in the time to make pizzas being reduced to 8 minutes/pizza. How does this change your recommendation? Please describe.

Answer rating: 100% (QA)

Average of orders in the system First we need to calculate the average arrival rate and service rate 59 pm shift 3 pie orders per hour 6 pie orders per hour since the oven can make a pie in 10 minutes ... View the full answer