Please provide all formulas used for each cell!!!!

K13 A B C D E F G H J K 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 24 customers per hour or Enter the Enter the 10.4 customers per minute. Service times at the drive-up teller follow an exponential probability arrival rate service distribution with a service rate of 36 customers per hour or 0.6 customers per minute. in the cell rate in the below this cell below one this one 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 Problem 2: Use the information below, to answer the questions that follow. Be sure to show 19 your work in the space below the questions. GF Interior Design provides home and office decorating assistance to its customers. In normal operation, an average of 2.5 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 this waiting time= 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 recommend? 23 Questions 1 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