Question: Mandy operates a coffee stand. Customers arrive randomly at a mean rate of 2 0 per hour. The time needed by Craig to serve a

Mandy operates a coffee stand. Customers arrive randomly at a mean rate of 20 per hour. The time needed by Craig to serve a customer has an exponential distribution with a mean of 90 seconds.
Create an Excel model of this situation to help you answer the following questions:
1) What is the utilization of the system?(1)
2) What are the value ofL, Lq, W, and Wq?(1)
3) What is the probability that exactly 5 people are waiting in the system?(1)
4) What is the probability that less than 2 people are waiting in the system?(1)
5) If each the cost of waiting is determined to be $200 per hour (since customers will just leave if they wait too long) and servers cost $18 each, what is the optimal number of servers based on economic analysis?(1)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!