Question: I attached the spreadsheet with the sequences needed in this problem as well The time between arrivals of oil tankers at a loading clock at

I attached the spreadsheet with the sequences needed in this problem as well

I attached the spreadsheet with the sequences

I attached the spreadsheet with the sequences I attached the spreadsheet with the sequences

The time between arrivals of oil tankers at a loading clock at Prudhoe Bay is given by the following probability distribution: Time Between Ship Arrivals (days) Probability .05 .10 .20 .30 .20 .10 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 .10 20 .30 1.00 Simulate the movement of tankers to and from the single loading dock for the first 33 ships and choose the option that represents the average time between arrivals (lease consider ON IMPORTANT read the instructions below. For the random numbers, please use the excel the named as " 100 - it is available on Blackboard. Please consider the same starting condition that was applied in the original pre Use the first 3 random b ers of the sequence 20" for the time between the arrivals, and the whole sequence 21" for the time to fill and prepare Trial sequence 20 sequence 21 sequence 22 sequence 23 sequence 24 sequence 2 0.117008014 0.700693973 0.9679926 0.240566142 0.914402574 0.68426774 2 0.250125854 0.439948201 0.260294722 0.271267972 0.025549516 0.22199791 3 0.624733246 0.916545719 0.955874083 0.616282104 0.642739565 0.35044474 4 0.12864063 0.348851777 0.823887357 0.471950378 0.620943771 0.75737293 5 0.835874225 0.236848548 0.869498172 0.480335406 0.986165916 0.22014149 6 0.840296428 0.504132767 0.922683969 0.937917583 0.810366135 0.70875248 7 0.60146977 0.55363963 0.977283175 0.496767475 0.651268775 0.56612197 8 0.417953073 0.983735655 0.090540395 0.157679087 0.492133184 0.2795228 9 0.563898765 0.76669001 0.617156392 0.501140156 0.708378777 0.9252615 10 0.846196596 0.364446712 0.904388965 0.359251761 0.077127608 0.82134172 11 0.985511812 0.271677852 0.788977655 0.402542051 0.278505617 0.06672269 12 0.797730432 0.386658104 0.89963858 0.574883125 0.666759178 0.59734087 13 0.398615897 0.495771828 0.92557168 0.902671369 0.348285443 0.21220231 14 0.330831816 0.41579531 0.340998056 0.52748932 0.801153293 0.42270038 15 0.598348474 0.123142471 0.198969709 0.683098139 0.411109879 0.87006553 16 0.230683875 0.502537065 0.806961196 0.961993183 0.701583471 0.64532059 17 0.95065442 0.291802382 0.264323854 0.204468637 0.940825937 0.15352174 18 0.456039021 0.494943861 0.001431751 0.571615666 0.723970558 0.88823997. 19 0.742707808 0.626031576 0.806577753 0.998451173 0.155855057 0.41963045 20 0.610999746 0.485702805 0.562046736 0.868143905 0.925039197 0.98953221 21 0.22590777 0.876234558 0.487392079 0.147340945 0.66639709 0.15958158 22 0.091792406 0.197939215 0.739606133 0.774310419 0.811510878 0.74640895 23 0.494427601 0.066686405 0.17046408 0.993340577 0.289455052 0.67668710 24 0.70098469 0.428319729 0.940639527 0.012499793 0.435638968 0.48893766 25 0.335650866 0.431488584 0.565254466 0.10145239 0.430444314 0.34461889 26 0.629322828 0.366725989 0.522237944 0.253786464 0.242780263 0.56365974 27 0.654920724 0.05699474 0.501779364 0.81493138 0.458436261 0.47652482 28 0.693716038 0.896101541 0.850947939 0.997584887 0.63700699 0.93119900 29 0.640245597 0.221383296 0.66352797 0.284091195 0.434820624 0.36383807 30 0.063965058 0.835651276 0.849483875 0.485853317 0.449452661 0.70940166 31 0.519852158 0.669057695 0.497558151 0.118992591 0.298596477 0.45304545 32 0.573257315 0.351390257 0.804099596 0.944169395 0.713744491 0.35411430 33 0.447577997 0.5258299830.918257821 0.499594864 0.941186658 0.3788814

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!