Assignment: Spreadsheet Modeling
Queuing Theory
Company ABC wants to hire seasonal workers to answer phone calls. Suppose that calls to the phone center occur at a rate of 60 per hour and follow a Poisson distribution and each staff can answer an average of 5 calls per hour that follows exponential distribution. Right now, 10 workers are working at the phone center and when all the lines are busy, the phone system can keep 5 additional calls on hold.
a) What is the queuing model of this company?
b) What is the probability that a caller receives a busy signal?
c) What is the probability that a caller is put on hold before receiving service?
d) On average, how long must a caller wait before speaking with the staff?
e) How many additional staff would be required if the Company ABC wants no more than a 5% chance of a caller receiving a busy signal?
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.