Question: please help with this problem and please show the excel formulas. thank you for the help. Problem 1: Use the information below, to answer the

please help with this problem and please show the excel formulas. thank you for the help. please help with this problem and please show the excel formulas. thank

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. 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 service rate in the rate in the cell below this one cell below this one Question 1 What is the probability that no customers are in the system? Question 2 What is the probability that 3 or more customers are in the system? Question 3 What is the average number of customers in line? Question 4 What is the average number of customers in the system? Question 5 How long should a customer expect to wait (on average) before being served? Perhour or Per minute

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!