Question

1. The time between arrivals of oil tankers at a loading dock at Prudhoe Bay is given by the following probability distribution:

Time between Ship Arrivals (days)       Probability

1                                                                      0.05

2                                                                      0.10

3                                                                      0.15

4                                                                      0.25

5                                                                      0.25

6                                                                      0.15

7                                                                      0.05

1.00

The time required to fill a tanker with oil and prepare it for sea is given by the following probability distribution:

Time to Fill and prepare (days)              Probability

2                                                                      0.10

3                                                                      0.30

4                                                                      0.40

5                                                                      0.20

1.00

1. Simulate the movement of tankers to and from the single loading dock for the first 100 arrivals. Compute the average time between arrivals, average waiting time to load, and average number of tankers waiting to be loaded. (hint: The COUNTIF function to count # of tankers in the system upon the arrival of the 11th tanker, =COUNTIF(A1:A10,">"&B11) // count cells A1:A10 greater than value in B11

A1:A10 = the departure times of tankers 1:10

B11 = the arrival time of tanker 11

2. Discuss any hesitation you might have about using your results for decision making.

Answer 1

Answer:--- Date:--17/05/2019