Queuing Exercise Lab Exercise (25 Points) 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 7.1 minutes. A study of past service times indicate that the average time to process a caller's question/request is 5.1 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, theyd like you to provide your own recommendations. STEP 1 EXCEL FILE Complete the excel file and submit. Be sure to enter the appropriate number in the cells that contain a Y (3 decimal places) Be sure to enter the appropriate FORMULA in the cells that contain an X

PLEASE SHOW YOUR WORK

1.) What is the probability there are exactly 2 customers in line in a two-server model?

What is the probability there are fewer than 2 customers in the system in a two-server model? What is the probability there are fewer than 1 single customer in the line in a three-server model? What is the probability there are more than three customers in the system in a two-server model? What is the probability there is more than one in line in a one-server model?