In: Statistics and Probability
The time between arrivals of oil tankers at a loading dock at
Prudhoe Bay is given...
- 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
- 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
- Discuss any hesitation you might have about using your results
for decision making.