Assignment:
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
Provide complete and step by step solution for the question and show calculations and use formulas.