Question: Need help completing this chart on this excel file The purpose of this exercise is to discuss the situation facing a manager and help her

Need help completing this chart on this excel file
Need help completing this chart on this excel
Need help completing this chart on this excel
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. STEP 1 - EXCEL FILE Complete the excel file. YOU DO NOT SUBMIT THIS FILE USE THIS FILE TO ANSWER THE QUESTIONS Be sure to enter the appropriate lambda and mu in the cells that contain an X (3 decimal places) Be sure to enter the appropriate FORMULA in the cells that contain Y's (3 decimal places) Use cells B2 and B3 to calculate Lambda and Mu. (Example: = 7/45) Lambda - Arrival Rate (Calls per Minute) Mu - Service Rate(Calls per Minute) - 3 Servers % Time Server Busy (rho) Probability of Y Y 1 3 0.503 0.333 0.110 0.036 0.012 0.0003 0.00003 0.515 0.341 0.113 0.025 0.005 0.001 0.0003 4 Y 5 6 Y In the system Number in System n(s) Number in Line n() CUSTOMERS Y Y TIME (Minutes) Y : Time in System t(s) Time in Line tu) CUSTOMERS 0.74 0.08 TIME (Minutes) 4.83 0.53 TIME (Seconds) 289.7 31.7 CUSTOMERS 0.67 0.01 TIME (Minutes) 4.36 0.06 TIME (Seconds) 261.5 3.5 Time in System t(s) Time in Line tu) TIME (Seconds) Y Y

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!