Telephone calls come into an airline reservations office randomly at the mean rate of 15 calls per

Question:

Telephone calls come into an airline reservations office randomly at the mean rate of 15 calls per hour. The time between calls follows an exponential distribution with a mean of 4 minutes. When the two reservation agents are busy, a telephone message tells the caller that the call is important and to please wait on the line until the next reservation agent becomes available. The service time for each reservation agent is normally distributed with a mean of 4 minutes and a standard deviation of 1 minute. Use a two-channel waiting line simulation model to evaluate this waiting line system. Use the worksheet design shown in Figure. The cell formula= - 4*LN(RAND()) can be used to generate the interarrival times. Simulate the operation of the telephone reservation system for 600 customers. Discard the first 100 customers, and collect data over the next 500 customers.
FIGURE
EXCEL WORKSHEET FOR THE HAMMONDSPORT SAVINGS BANK
WITH TWO ATMs

Telephone calls come into an airline reservations office randoml

a. Compute the mean interarrival time and the mean service time. If your simulation model is operating correctly, both of these should have means of approximately 4 minutes.
b. What is the mean customer waiting time for this system?
c. Use the = COUNTIF function to determine the number of customers who have to wait for a reservation agent. What percentage of the customers have towait?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Quantitative Methods For Business

ISBN: 148

11th Edition

Authors: David Anderson, Dennis Sweeney, Thomas Williams, Jeffrey Cam

Question Posted: