Can you please answer with formulas?

M N 0 2 1 Analysis of Waiting Lines Assignment You must do the necessary calculations in the answer cells. Simply providing a number in the answer cell will not receive any credit. 3 When look at the answer cell, I want to see a number, when I click on the cell I want to see the excel formula, for example, 7035.0 or 7035.0 if I asked you the sum of cells B5 through D5, this is what I want to see: 4 5 1234 2345 3456 6 7 For full credit, please insert proper calculations/formulas in the answer cells 8 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 Enter the Enter the or 0.3333 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. below this cell below in the cell rate in the 11 one this one 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? Per hour or per minute 18 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 waiting 23 Questions 1 recommend? time= 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 26