Use cells B2 and B3 to calculate Lambda and Mu. (Example: = 7/45) B4 Lambda - Arrival Rate (Calls per Minute) X Mu - Service Rate(Calls per Minute) X Servers 2 3 % Time Server Busy (rho) Y Y Y Probability of 0.503 0.515 0.333 0.341 0.110 0.113 GUAUN-O 0.036 0.025 0.012 0.005 0.0003 0.001 0.00003 0.0003 In the system CUSTOMERS CUSTOMERS CUSTOMERS Number in System n(s) Y 0.74 0.67 Number in Line n(0) Y 0.08 0.01 TIME (Minutes) TIME (Minutes) TIME (Minutes) Time in System t(s) Y 4.83 4.36 Time in Line t(1) Y 0.53 0.06 TIME (Seconds)| TIME (Seconds) | TIME (Seconds) Time in System t(s) 289.7 261.5 Time in Line t() Y 31.7 3.5STEP 2 - Questions using Data Provided in the Story (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? 6. What is the probability the system is empty in a single-server model? 7. 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? 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?SIEF GuestOns USInly NEW GIVERS I BOIL Vac!! 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 file 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 find 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 single-server 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 your 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? 27. 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's 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