Share
Explore BrainMass

The average queue length;waiting time;percentage utilization

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
1 .20
2 .60
3 .10
4 .10

Service Time (min) Probability
1 .20
2 .60
3 .10
4 .10

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.

Attachments

Solution Summary

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.

$2.19