show work and cell referencing please! asap
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. 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, if I asked you the sum of cells BS through D5, this is what I want to see: 7035.0 or 7035.0 1234 2345 3456 For full credit, please insert proper calculations/formulas in the answer cells 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 telor window that allows customers to complete bank transactions wethout getting out of their cars. On weekday mornings, arrivals to the dive-up teler 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 telor folow an exponential probabily distribution we a service rate of 36 customers per hour or 0.6 customers per minute. Enter the arrival rate in the cell below this ono ono Question 1 What is the probabilty that no customers are in the system? Question 2 What is the probabiliy that 3 or more customers are in the system? Question 3 What is the averape 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 wall (on average) before being served? Problem 2: Use the information below, to answer the questions that follow. Be sure to show your work in the space below the questions. OF Interior Design provides home and office docorating assistance to its customors. in normal operation, an average of 3 customers arrive each hour. One design consutant is avalable to answer customer questions and make product recommendations. The consultant averages 10 minutes with each customer. 2 Questions 1 Service goals dictate that an arriving customer should not waif for service more than an average of five minutes. Is this goal being met? If not, what action do you rocommend? 1. If the consultant can reduce the average time spent per customer to eight minutes, what is the mean service rate? Wir the service goal be met? Enter the service rate in the cell below this one Per hour or Per minute Enter the arrival rate in the cell below this one waiting time= Enter the service rate in the cell below this one Questions 2
