Case Study - Local Bank
A local bank has a single drive-through window with arrival times and service times that follow the distributions from the following tables:
|
Time between arrivals (min)
|
(%)
|
|
1
|
15
|
|
2
|
24
|
|
3
|
27
|
|
4
|
22
|
|
5
|
12
|
|
Service Time (min)
|
Unloading Frequency (%)
|
|
1
|
15
|
|
2
|
35
|
|
3
|
22
|
|
4
|
28
|
Use Excel (RAND, LOOKUP, Data Tables) to 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)
c) Percentage of time the server busy with customers (utilization factor)
Replicate each measure 20 times to compute the average.