Queuing Exercise Lab Exercise #3 SCM 300 The purpose of this exercise is to discuss the situation facing a manager and help her determine how many servers to use and what the characteristics of the system will be. Endeavor Communications, a long distance provider, is reevaluating its account management department for handling customer service questions and requests. During the 2:00 pm to 10:00pm time period, past data show that calls to the account management department occur at an average rate of one call every 6.5 minutes. A study of past service times indicate that the average time to process a caller's question/request is 4.3 minutes. Like other phone systems, when a call comes in and all the servers are busy, the caller hears a message telling them to hold until the next server is available. Top management at Endeavor Communications understands that the staffing decision involves the analysis of trade-offs. Increasing the number of servers will reduce the waiting times and increase the probability of immediate service at a higher cost with more idle time for the servers. Management has decided that the GOAL of the account management department is to immediately answer and service at least 90% of the incoming calls during the busiest time period of 2:00pm to 10:00pm. They have asked you to determine the staffing level that will help them meet this goal. Also, they'd like you to provide your own recommendations.

QUESTIONS: 13. What is the probability there are exactly 1 customer in line in a three-server model? 14. What is the probability there are fewer than 3 customers in line in a single server model? 15. What is the probability there is more than one customer in the line in a two- server model? 16. What is the probability there is one or more customers in the line in a three-server model? 17. What is the probability of being served immediately in a one-server model? 18. What is the probability of being served immediately in a two-server model? 19. What is the probability of being served immediately in a three-server model? 20. How many employees are required to meet the account management department's goal of 90% of incoming calls being served immediately?

Use cells B2 and B3 to calculate Lambda and Mu. (Example: =7/45 ) Use cells B2 and B3 to calculate Lambda and Mu. (Example: =7/45 )