Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please show work and use cell referencing! thank you Analysis of Waiting Lines Assignment You must do the necessary calculations in the answer cells. Simply

please show work and use cell referencing! thank you
image text in transcribed
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 B5 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. 10 Prarie State Bank operates a drive-up telor window that alows customers to complete bank transactions whout getting out of their cars. On weekday mornings, arrivats 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 teler folow an exponential probabily distribution wh a service rate of 36 customers per hour or 0.6 customers per minute. 4 Question 1 What is the probabily 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 ine? Question 4 . What is the average number of customers in the system? Question 5 . How long should a customer expect to wall (on averago) before being served? Enter the arrival rate h the coll below this ono 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 decorating 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. Enter the arrival rate in the cell below this one one 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 recommend? Questions 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 Enter the service rate in the cel below this one Questions 2 waiting time=

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Manufacturing Planning And Control For Supply Chain Management

Authors: F. Robert Jacobs, William Berry, David Clay Whybark, Thomas Vollmann

6th Edition

0073377821, 9780073377827

More Books

Students also viewed these General Management questions