Please show in Excel. The template is shown in the image.

The Burger Dome is a fast-food restaurant that is currently appraising its customer service. In its current operation, an employee takes a customers order, tabulates the cost, receives payment from the customer, and then fills the order. Once the customers order is filled, the employee takes the order of the next customer waiting for service. Assume that time between each customers arrival is an exponential random variable with a mean of 1.35 minutes. Assume also that the time for the employee to complete the customers 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.

1. What is the average wait time experienced by a customer?

2. What is the longest wait time experienced by a customer?

   What is the probability that a customer waits more than 2 minutes?

3. Create a histogram depicting the wait time distribution.

4. 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 problem?

A B C D E F. H J K N Arrival time of a customer is equal to arrival time of previous customer plus time between these two arrivals. If a customer arrives after at least one of the two The amount of time a customer waits servers has become available the customer can begin is the time she begins service minus service upon arrival. Otherwise, the customer has to her arrival time. wait until one of the two servers becomes available. The time a customer completes service is equal to the time that she started service plus the service time. The first available server is assigned the next customer (with server 1 serving the customer if both servers are idle upon a customer arrival). A server becomes available after the customer which he is serving completes service. 1 Burger Dome 2 3 Parameters 4 Hours to Simulate 5 Minutes to Simulate 6 7 Interarrival Time (exponential) 8 mean 14 840 Service Time (exponential) The time a customer spends in the system is the time she completes service minus the time she arrived to the system. 1.4 minutes mean 1.0 minutes 0 0 10 Model 11 Customer Interarrival Time Arrival Time Begin Service Time Waiting Time Service Time Completion Time Time in System Server 1 Available Time Server 2 Available Time Customer