See attached excel spreadsheet (example) for queing simulation.
I need help to put the info from problem #1 into Excel.
1.) First American Bank is trying to determine whether it should install one or two drive-thru teller windows. The following probability distribution for arrival intervals and service times have been developed from historical data.
Time between auto arrivals (min) Probability
Service Time (min) Probability
Assume that in the two-server system, an arriving car will join the shorter queue. When the queues are equal length, there is a 50-50 chance the driver will enter the queue for either window.
a. Simulate both the one and two teller systems. Compute the average queue length, waiting time, and percentage utilization for each system.
b. Suggest a decision about which system to employ.
This post shows how to calculate the average queue length, waiting time, and percentage utilization for each system.
Suggests a decision about which system to employ.