Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help with this problem and please show the excel formulas. thank you for the help. Problem 1: Use the information below, to answer the

please help with this problem and please show the excel formulas. thank you for the help. image text in transcribed
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. Enter the Enter the arrival service rate in the rate in the cell below this one cell below 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? Perhour or Per minute

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Fundamentals Of Management

Authors: Ricky Griffin

10th Edition

9780357517345

Students also viewed these General Management questions