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? ACEFHJKArrival time of a customer isequal to arrival time of previouscustomer plus time betweenthese two arrivals.1Burger DomeIf a customer arrives after at least one of the twoservers has become available the customer can begin is the time she begins service minusservice upon arrival. Otherwise, the customer has towait until one of the two servers becomes available.The first available server is assigned the nextcustomer (with server 1 serving the customer if bothservers are idle upon a customer arrival). A serverbecomes available after the customer which he isThe amount of time a customer waitsThe time a customer completes service isequal to the time that she started serviceplus the service time.2her arrival time.3Parametersserving completes service.4 Hours to Simulate5 Minutes to Simulate148406The time a customer spends in thesystem is the time she completes serviceminus the time she arrived to the system.7 Interarrival Time (exponential)Service Time (exponential)8mean1.4minutesmean1.0minutes10 Model11CustomerInterarrival TimeArrival TimeBegin Service TimeWaiting TimeService TimeCompletion TimeTime in System Server 1 Available TimeServer 2 Available TimeCustomer

Mean = 1.35 minutes Time = 14 hoursday Inter Arrival Time Mean(λ)=1.35 Service Time Mean(μ)=1

Answered: The Burger Dome is a fast-food…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Concept explainers

Question

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?

A
C
E
F
H
J
K
Arrival time of a customer is
equal to arrival time of previous
customer plus time between
these two arrivals.
1
Burger Dome
If a customer arrives after at least one of the two
servers has become available the customer can begin is the time she begins service minus
service upon arrival. Otherwise, the customer has to
wait until one of the two servers becomes available.
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
The amount of time a customer waits
The time a customer completes service is
equal to the time that she started service
plus the service time.
2
her arrival time.
3
Parameters
serving completes service.
4 Hours to Simulate
5 Minutes to Simulate
14
840
6
The time a customer spends in the
system is the time she completes service
minus the time she arrived to the system.
7 Interarrival Time (exponential)
Service Time (exponential)
8
mean
1.4
minutes
mean
1.0
minutes
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

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.

Similar questions