*if you can show me how to setup in Excel, that would be great!*

Regional Airlines Case Regional Airlines is establishing a new telephone system for handling flight reservations. During the 10:00 AM to 2:00 PM time period, calls to the reservation agent occur randomly at an average rate of one call every 3.75 minutes. Historical service time data show that a reservation agent spends an average of 3 minutes with each customer. The waiting line model assumptions of Poisson arrivals and exponential service times appear reasonable for the telephone reservation system.

Regional Airlines management believes that offering an efficient telephone reservation system is important part of establishing an image as a service-oriented airline. If the system is properly implemented, Regional Airlines will establish good customer relations, which in the long run will increase business. However, if the telephone reservation system is frequently overloaded and customers have difficulty contacting an agent, a negative customer reaction may lead to an eventual loss of business. The cost of a ticket reservation agent is $20 per hour. Thus, management wants to provide good service, but it does not want to incur the cost of overstaffing the telephone reservation operation by using more agents than necessary.

At a planning meeting, Regional's management team agreed that an acceptable customer service goal is to answer at least 75% of the incoming calls immediately. During the planning meeting, Regional's vice president of administration pointed out that the data show that the average service rate for an agent is faster than the average arrival rate of the telephone calls. The vice president's conclusion was that personnel costs could be minimized by using one agent and that single agent must be able to handle the telephone reservations and still have some idle time. The vice president of marketing restated the importance of customer service and expressed support for at least two reservation agents. Answer to the following questions to help conduct a managerial report to analyze the telephone reservation system with one agent as proposed by the vice president of administration.

1. What is the average inter-arrival time? (i.e. the average time between every two consecutive callers) 2. What is the caller arrival rate per hour?

3. What is the average service time?

4. What is the average service rate per hour?

5. What is the probability of more than 3 customers call within a 6-minute period?

6. What percentage of the customers will take less than two minute to be served?

7. What percentage of the customers will take more than 4 minute to be served?

8. What percentage of time is our reservation agent busy with callers? (i.e. the percentage of time that a caller will have to wait to receive service)

9. What is the percentage of time that there is no caller in the system?

10. What percentage of time there are 4 callers in the system?

11. What is the average number of callers waiting to speak with an agent?

12. What is the average number of callers in the system?

13. How many minutes on average a caller must wait to speak with the agent?

14. How many minutes on average a caller spends in the system (including waiting to speak with the agent and talk duration with the agent)?

15. According to your analysis in the above questions, do you think one ticket agent is enough to respond to all callers for the quality level considered in Regional Airlines?