Question: ( EXCEL FORMAT, PLEASE USE TEMPLATE PROVIDED ) A local bank has a single drive - through window with arrival times and service times that

(EXCEL FORMAT, PLEASE USE TEMPLATE PROVIDED) A local bank has a single drive-through window with arrival times and service times that follow the distributions from the following table:
TIME BETWEEN ARRIVALS /// PROBABILITY
10.15
20.24
3-0.27
40.22
50.12
SERVICE TIME(MIN)/ PROBABILITY
1-0.15
20.35
3-0.22
4-0.28
Simulate the arrival of 200 customers to compute each of the following measures: (a) average time a customer waits for service, (b) average time a customer is in the system (wait plus service time), and (c) percentage of time the server is busy with customers. Replicate each measure N times to compute the average.
 (EXCEL FORMAT, PLEASE USE TEMPLATE PROVIDED) A local bank has a

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!