Solve Using Excel

Problems: Queuing Problems Bank of Ohio in Zanesville has a single drive-in teller window. Customers arrive at the window about every 10 minutes on average with an exponential distribution or the hourly arrival rate is 1 = 6. It take an average of five minutes (exponentially distributed) to complete each customer order or the hourly service rate is p = 12. You are asked following tasks: Determine Expected number of customers in the system, including those being served. Expected number of customers in the queue, excluding those being served. Expected waiting time in the system, including service time, for an individual customer. Expected waiting time in the queue, excluding service time, for an individual customer. Utilization factor The probability that waiting time in the system exceeds 0.25 hours (15 minutes) The probability that waiting time in the queue exceeds 0.25 hours (15 minutes) The probability that the system has 5 customers in the system