Share
Explore BrainMass

Probability Computations for SImulation Tables

The time between arrivals of customers to a gas station pump is given by the following probability distribution

time between arivals (min) probability
1 0.1
2 0.2
3 0.5
4 0.2

The time required by a customer is given by the following probability distribution

time required (min) probability
3 0.1
4 0.3
5 0.4
6 0.2

An excel simulation is performed in order to estimate the average customer waiting time.

a. Construct the lookup table for customer arrivals

b. Construct the lookup table for service duration

c. complete the computation of the following simulation table. Note thet the random numbers have been generated for you

random arrival arrival start waiting random service complete
customer number interval time filling time number duration time
1 0.9824 0.8113
2 0.9124 0.4704
3 0.4705 0.8284

Attachments

Solution Preview

Please see the attached file

The time between arrivals of customers to a gas station pump is given by the following probability distribution

time between arivals (min) probability
1 0.1
2 0.2
3 0.5
4 0.2

The time required by a customer is given by the following ...

Solution Summary

The expert examines probability computations for simulation tables.

$2.19