Question: please show in excel and formulas/steps Problem 1) (12 points) A call center has analyzed the calls received in the last month and found that,

please show in excel and formulas/steps

Problem 1) (12 points) A call center has analyzed the calls received in the last month and found that, on average, 24 calls were received per hour. Assume that call arrivals follow Poisson distribution and come from an infinite population. Service times follow an exponential distribution with an average of two minutes per call served. Assume the queue length can be infinite with FCFS discipline. a) What is the average number of people in line? ( 2.5 points) b) What is the average number of people in the system? (2.5 points) c) What is the average amount of time that a person can expect to spend in line? (2.5 points) d) On average, how much time will a person spend in the system? (2.5 points) e) During the weekends, the call arrival rate can be expected to increase to over 24 per hour. What effect will this have on the average number of people waiting in line? ( 2 points)

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 General Management Questions!

Problem 1: In this exercise, we look at how software techniques can extract instruction-level parallelism (ILP) in a common vector loop. The following loop is the so-called DAXPY loop...

answer in excel with formulas Problem 1) (12 points) A call center has analyzed the calls received in the last month and found that, on average, 24 calls were received per hour. Assume that call...

STATISTICS FOR DECISION MAKING Dr. Azar Abizada HOMEWORK 4 Due Date: Wednesday, March 11th class time Problem 1 (26 points): Be careful, each part of this question is independent of one another. a)...

Problem 1 ) ( 1 2 points ) Che 7 A call center has analyzed the calls received in the last month and found that, on average, 4 0 calls were received per hour. Assume that call arrivals follow Poisson...

can someone answer these asap? Contract Law Final Exam Vanessa Fayad Start: 2:02PM Question 1 (12 points) Saved On February 1, Lumber Store Owner offered to sell 2,500 board feet of 8 x 10 lumber to...

1. A call center has analyzed the calls received in the last month and found that, on average, 24 calls were received per hour. Assume that call arrivals follow Poisson distribution and come from an...

Q9.Use the information provided in table 6 to calculate the cost to issue a life insurance policy, including receiving and processing applications for each product. IMA EDUCATIONAL Case Journal Case...

A call center has analyzed the calls received in the last month and found that, on average, 4 0 calls were received per hour. Assume that call arrivals follow Poisson distribution and come from an...

A call center has analyzed the calls received in the last month and found that, on average, 24 calls were received per hour. Assume that call arrivals follow Poisson distribution and come from an...

Please Help with Deliverables a, b and c!! (Please Post Excel Answers/Explanations) Thank you! Scheduling a Call Center Century Bank has received many complaints from its customers about long waiting...

Suppose Nicoles yearly income is $5,000 when she is fifteen, $35,000 when she is twenty five, and $70,000 when she is fifty (these are all present value measures of future income). Assume that...

Over the past 10 years, the dividends of Party Time, Inc. have grown at an annual rate of 15 percent. The current (D0) dividend is $3 per share. This dividend is expected to grow to $3.40 next year,...

The Accounts Receivable Aging report provides information useful in tracking accounts receivable by providing information about the age of customer accounts. This report lists the age of accounts...

What is an example of constructive feedback? provide reference