Question: ( Please help!! in excel format, i have attached template, need help with formulas, thanks : ) ) Problem 1 0 - 4 0 (

(Please help!! in excel format, i have attached template, need help with formulas, thanks :))Problem 10-40
(Calculations set to Manual. Press F9 to recalculate).
The Diego Street Convenience Store has a single checkout register, with customer arrival distribution shown in the following table:
TIME BETWEEN ARRIVALS (min.)/ Probability
1/0.18
2/0.20
3/0.22
4/0.25
5/0.15
Service time follows a discrete uniform distribution between 1 and 4 minutes. Simulate the arrival of 200 customers to compute the average time a customer waits for service and the probability that a customer waits 3 minutes or longer for service.
Replicate each measure N times to compute its average.
 (Please help!! in excel format, i have attached template, need help

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 General Management Questions!