Question: Please include calculations Problem 1: Use the information below, to answer the questions that follow. Enter the formulas into the yellow cells so that the

Please include calculations Problem 1: Use thePlease include calculations Problem 1: Use thePlease include calculations

Problem 1: Use the information below, to answer the questions that follow. Enter the formulas into the yellow cells so that the cells will show the information requested. 9 10 Prairie State Bank operates a drive-up teller window that allows customers to complete bank transactions without getting out of their cars. On weekday mornings, arrivals to the drive-up teller window occur at random and follow a poisson distribution. The arrival rate is 20 customers per hour or 0.3333 customers per minute. Service times at the drive-up teller follow an exponential probability distribution with a service rate of 36 customers per hour or 0.6 customers per minute. Enter the Enter the arrival rate service in the cell rate in the below this cell below one this one 11 12 13 Question 1 What is the probability that no customers are in the system? 14 Question 2 What is the probability that 3 or more customers are in the system? 15 Question 3 What is the average number of customers in line? 16 Question 4 What is the average number of customers in the system? 17 Question 5 How long should a customer expect to wait (on average) before being served? 18 Per hour Problem 2: Use the information below, to answer the questions that follow. Be sure to 19 show your work in the space below the questions. 20 GF Interior Design provides home and office decorating assistance to its customers. In normal operation, an average of 3 customers arrive each hour. One design consultant is available to answer customer questions and make product recommendations. The consultant averages 10 minutes with each customer Enter the Enter the arrival rate service in the cell rate in the below this cell below one this one 21 22 Service goals dictate that an arriving customer should not wait for service more than an average of five minutes. Is this goal being met? If not, what action do you 23 Questions 1 recommend? If the consultant can reduce the average time spent per customer to eight minutes, what is the mean service rate? Will the service goal be met? 24 Questions 2 25 waiting time=

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!