The Burger Dome is a fast-food restaurant that is currently appraising its customer service. In its current operation, an employee takes a customer’s order, tabulates the cost, receives payment from the customer, and then fills the order. Once the customer’s order is filled, the employee takes the order of the next customer waiting for service. Assume that time between each customer’s arrival is an exponential random variable with a mean of 1.35 minutes. Assume also that the time for the employee to complete the customer’s service is an exponential random variable with mean of 1 minute. Use the BurgerDome.xlsx template to complete a simulation model for the waiting line at Burger Dome for a 14-hour work day. Using the summary statistics gathered at the bottom of the spreadsheet model, answer the following questions. What is the average wait time experienced by a customer? What is the longest wait time experienced by a customer? What is the probability that a customer waits more than 2 minutes?
Please show in excel. The template is provided in the image. This is for a two-server system, not one.
The Burger Dome is a fast-food restaurant that is currently appraising its customer service. In its current operation, an employee takes a customer’s order, tabulates the cost, receives payment from the customer, and then fills the order. Once the customer’s order is filled, the employee takes the order of the next customer waiting for service. Assume that time between each customer’s arrival is an exponential random variable with a mean of 1.35 minutes. Assume also that the time for the employee to complete the customer’s service is an exponential random variable with mean of 1 minute. Use the BurgerDome.xlsx template to complete a simulation model for the waiting line at Burger Dome for a 14-hour work day. Using the summary statistics gathered at the bottom of the spreadsheet model, answer the following questions.
-
What is the average wait time experienced by a customer?
-
What is the longest wait time experienced by a customer?
-
What is the probability that a customer waits more than 2 minutes?
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
