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.
Step 1:
Sheet 1:
Time |
Pi |
1 |
0.05 |
2 |
0.1 |
3 |
0.15 |
4 |
0.25 |
5 |
0.25 |
6 |
0.15 |
7 |
0.05 |
Time |
Pj |
2 |
0.1 |
3 |
0.3 |
4 |
0.4 |
5 |
0.2 |
Result:
Step2:
Time Dept. |
Time Arr. |
|
1 |
2 |
3 |
2 |
3 |
|
3 |
4 |
|
4 |
5 |
|
5 |
5 |
|
6 |
3 |
|
7 |
3 |
|
7 |
3 |
|
3 |
2 |
|
5 |
5 |
|
6 |
4 |
|
4 |
3 |
|
2 |
4 |
|
2 |
4 |
|
4 |
2 |
|
5 |
4 |
|
1 |
5 |
|
7 |
5 |
|
4 |
4 |
|
3 |
3 |
|
4 |
4 |
|
4 |
4 |
|
3 |
5 |
|
5 |
3 |
|
6 |
5 |
|
2 |
5 |
|
7 |
4 |
|
6 |
5 |
|
2 |
3 |
|
1 |
3 |
|
4 |
5 |
|
4 |
4 |
|
3 |
4 |
|
5 |
4 |
|
6 |
5 |
|
4 |
2 |
|
7 |
3 |
|
3 |
3 |
|
5 |
4 |
|
4 |
2 |
|
4 |
5 |
|
4 |
4 |
|
1 |
3 |
|
5 |
4 |
|
4 |
3 |
|
2 |
5 |
|
4 |
5 |
|
5 |
3 |
|
6 |
5 |
|
5 |
3 |
|
6 |
3 |
|
3 |
5 |
|
4 |
5 |
|
4 |
4 |
|
4 |
4 |
|
5 |
2 |
|
4 |
5 |
|
3 |
4 |
|
3 |
5 |
|
5 |
2 |
|
3 |
5 |
|
5 |
3 |
|
4 |
4 |
|
2 |
5 |
|
4 |
4 |
|
3 |
5 |
|
5 |
2 |
|
6 |
4 |
|
2 |
5 |
|
6 |
4 |
|
3 |
5 |
|
3 |
3 |
|
5 |
4 |
|
1 |
5 |
|
3 |
2 |
|
3 |
3 |
|
7 |
4 |
|
2 |
2 |
|
6 |
3 |
|
5 |
5 |
|
5 |
4 |
|
5 |
3 |
|
5 |
4 |
|
2 |
4 |
|
4 |
3 |
|
3 |
4 |
|
2 |
5 |
|
3 |
4 |
|
6 |
4 |
|
2 |
5 |
|
3 |
3 |
|
3 |
3 |
|
6 |
3 |
|
4 |
3 |
|
3 |
4 |
|
4 |
5 |
|
6 |
3 |
|
4 |
5 |
|
4 |
5 |
|
4 |
3 |
|
2 |
3 |
|
7 |
3 |
|
5 |
3 |
|
5 |
4 |
|
6 |
||
4 |
||
6 |
Reference:
The time between arrivals of oil tankers at a loading dock at Prudhoe Bay is given by the following probability distribution:
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 ...
1) Consider the following distribution and random numbers: Demand Frequency 0.15 0.30 0.25 0.15 0.15 Random Numbers; 62 13 25 40 0 4 What four demand values would be developed from the random numbers listed? 2) Given the following random number ranges and the following random number sequence: 62, 13, 40, 86, 93, determine the expected average demand for the following distribution of demand. Random Demand Number Ranges 00-14 15-44 45-69 70-84 85-99 Answer:_ The number of cars arriving at...