Question: Can you please answer this with a spread sheet, thanks 16. The Burger Dome is a fast-food restaurant that is currently appraising its customer MODEL

Can you please answer this with a spread sheet,Can you please answer this with a spread sheet, thanks

16. The Burger Dome is a fast-food restaurant that is currently appraising its customer MODEL file service. In its current operation, an employee takes a customer's order, tabulates the Burger Dome 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: a. What is the average wait time experienced by a customer? b. What is the longest wait time experienced by a customer? c. What is the probability that a customer waits more than 2 minutes? d. Create a histogram depicting the wait time distribution e. By pressing the F9 key to generate a new set of simulation trials, one can observe the variability in the summary statistics from simulation to simulation. Typically, this variability can be reduced by increasing the number of trials. Why is this approach not appropriate for this

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!