Question: Can someone please breakdown this problem for me in EXCEL if possible? Thanks in advance. I greatly appreciate the help! eBook Problem 15-31 (Algorithmic) Mid-West
Can someone please breakdown this problem for me in EXCEL if possible? Thanks in advance. I greatly appreciate the help!
eBook Problem 15-31 (Algorithmic) Mid-West Publishing Company publishes college textbooks. The company operates an 800 telephone number whereby potential adopters can ask questions about forthcoming texts, request examination copies of texts, and place orders. Currently, two extension lines are used, with two representatives handling the telephone inquiries. Calls occurring when both extension lines are being used receive a busy signal; no waiting is allowed. Each representative can accommodate an average of 9 calls per hour. The arrival rate is 17 calls per hour. a. How many extension lines should be used if the company wants to handle 80% of the calls immediately? b. What is the probability that a call will receive a busy signal if your recommendation in part (a) is used? If required, round your answer to four decimal places. c. What number of calls, in decimal form, receive a busy signal for the current telephone system with two extension lines? If required, round your answer to four decimal places. eBook Problem 15-31 (Algorithmic) Mid-West Publishing Company publishes college textbooks. The company operates an 800 telephone number whereby potential adopters can ask questions about forthcoming texts, request examination copies of texts, and place orders. Currently, two extension lines are used, with two representatives handling the telephone inquiries. Calls occurring when both extension lines are being used receive a busy signal; no waiting is allowed. Each representative can accommodate an average of 9 calls per hour. The arrival rate is 17 calls per hour. a. How many extension lines should be used if the company wants to handle 80% of the calls immediately? b. What is the probability that a call will receive a busy signal if your recommendation in part (a) is used? If required, round your answer to four decimal places. c. What number of calls, in decimal form, receive a busy signal for the current telephone system with two extension lines? If required, round your answer to four decimal places
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
