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!Can someone please breakdown this problem for me in EXCEL if possible?

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

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 Accounting Questions!