Here is a Lab that I need help with. There are 30 questions and I have provided all supporting documents. Thank you!!!

ueuin 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 questiontrequest 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 le. 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) BE AWARE THAT IF YOU DO NOT USE FORMULAS IN EXCEL THE LAB WILL TAKE YOU A VERY LONG TIME. STEP 2 Questions usin Data Provided in the Sto 1 Points each Use the data from your completed and accurate excel file to answer the following questions. Enter your answers on the course website. 1. What is the arrival rate? (Calls per minute) 2. What is the service rate? (Calls per minute) 3. What percentage of the time is the server busy in a one-server model? 4. What percentage of the time is the server busy in a two-server model? 5 . What percentage of the time is the server busy in a three-server model? . What is the probability the system is empty in a single-server model? . What is the probability of exactly 2 customers in the system in a single-server model? 8. What is the probability of exactly 5 customers in the system in a single-server model? \"40) 9. On average, how many customers are in the system in a single server model? 10. On average, how many customers are in the line in a single server model? 11. On average, how much time does a customer spend in the system in a single-server model? (minutes) 12. On average, how much time does a customer spend on hold in a single-server model? (minutes) As we learned in the lecture. it is recommended you draw a picture of the underlined section of each question. Then draw a number line that will help you represent the entire statement. Hopefully, that will help you more easily get the correct answer. 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? STEP 3 - Questions using New Givens [1 point each] Let's hope you developed your excel spreadsheet. If you did, this section will take about 2 minutes. If you refused to use your spreadsheet, this could take a while. The numbers for the 2 and 3 server models are not tied to formulas in the le you were given, but the numbers in the single server model are tied to the formulas you have input. It should now be easy for you to input new arrival and service rates and then nd the new outputs for the single server model. 21. Plug in these numbers into your spreadsheet: Arrival rate: 0.065 calls per minute Service rate: 0.085 calls per minute In a single-server model what is the time in line (Minutes)? 22. Plug in these numbers into your spreadsheet: Arrival rate: 4.5 calls per minute Service rate: 6.7 calls per minute In a singleserver model what is the time in line (Minutes)? 23. Plug in these numbers into your spreadsheet: Arrival rate: 0.083 calls per minute Service rate: 0.206 calls per minute In a single-server model what % of time is the server busy? 24. Plug in these numbers into y0ur spreadsheet: Arrival rate: 2.4 calls per minute Service rate: 2.5 calls per minute In a single-server model what is the time in the system (Minutes)? 25. Plug in these numbers into your spreadsheet: Arrival rate: 0.349 calls per minute Service rate: 0.411 calls per minute In a single-server model what is the average number of customers in the line? 26. Plug in these numbers into your spreadsheet: Arrival rate: 0.45 calls per minute Service rate: 0.98 calls per minute In a single-server model what is the average number of customers in the system? 2?. Plug in these numbers into your spreadsheet: Arrival rate: 5.2 calls per minute Service rate: 6.05 calls per minute In a single-server model what is the average number of customers in the line? 28. Plug in these numbers into your spreadsheet: Arrival rate: 1.2 calls per minute Service rate: 2.1 calls per minute In a single-server model what is the probability of 3 customers in the system? 29. Plug in these numbers into your spreadsheet: Arrival rate: 0-155 calls per minute Service rate: 0.211 calls per minute In a single-server model what 5 the probability of 0 customers in the system? 30. Plug in these numbers into your spreadsheet: Arrival rate: 4.0 calls per minute Service rate: 4.4 calls per minute In a single-server model what is the average number of customers in the system? A B C D Lambda - Arrival Rate (Calls per Minute) X 2 Mu - Service Rate (Calls per Minute) X 3 4 Servers 2 3 5 % Time Server Busy (rho) Y Y Y 6 Probability of 7 0.503 0.515 8 0.333 0.341 9 0.110 0.113 10 QUAWN- O 0.036 0.025 11 0.012 0.005 12 0.0003 0.001 13 0.00003 0.0003 14 In the system 15 CUSTOMERS CUSTOMERS CUSTOMERS 16 Number in System n(s) 0.74 0.67 17 Number in Line n(1) 0.08 0.01 18 TIME (Minutes) TIME (Minutes) TIME (Minutes) 19 Time in System t(s) Y 4.83 4.36 20 Time in Line t) Y 0.53 0.06 21 TIME (Seconds) TIME (Seconds) TIME (Seconds) 22 Time in System t(s) Y 289.7 261.5 23 Time in Line t(1) Y 31.7 3.5 24