Question: Please answer problems 1 and 2 When look at the answer cell, I want to see a number, when I click on the cell I

 Please answer problems 1 and 2 When look at the answer

Please answer problems 1 and 2

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, \begin{tabular}{|l|l|l|} \hline if I asked you the sum of cells B5 through D5, this is what I want to see: & 7035.0 \\ \hline \end{tabular} 123423453456 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 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 arrival service rate in the rate in the cell below cell below this one 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? Per hour or Per minute Problem 2: Use the information below, to answer the questions that follow. Be sure to show 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 3 customers arrive each hour. One design consultant is available to answer customer questions and make product recommendations. The consultant averages 10, Enter the Enter the minutes with each customer. rate in the rate in the cell below cell below this one this one 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 Questions 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? Questions 2

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 Accounting Questions!