Please do not copy from other question, you will be downvoted

Tankers arrive at an oil port with a discrete empirical distribution of interarrival times:

Interarrival Times (in days)	1	2	3	4
Probability	.33	.17	.25	.25

There are three sizes of tanker: Super, Midsize, and Small. The size of tankers is distributed as follows:

Size of Tanker	Supertanker	Midsize tanker	Small tanker
Probability	.25	.35	.40

The port has two terminals, A and B. Terminal A is more efficient than terminal B, and it is used first when both terminals are empty. The time it takes to unload a tanker is deterministic, and depends on its size as follows:

Type of Tanker	Unload Time at Terminal (in days)
	Terminal A	Terminal B
Supertanker	4	7
Midsize tanker	3	5
Small tanker	2	3

Arriving tankers form a single waiting line (first-come, first-serve) in the port area until either terminal becomes available. Terminal assignments are not made until the terminal is available.

Complete the given spreadsheet templateby simulating all arrival and departure events through day 15. Two random number streams have been provided on the spreadsheet: one for determining tanker sizes and the other for determining interarrival times. Outcomes from the distribution tables should be assigned in the order that they are shown in the table. For example, a random number of zero maps to the first outcome on a table, and a random number of one maps to the last outcome. Make sure that you enter Time in System (column O) of an entity in case of a departure event.

NOTE: If two events occur at the same time, introduce the DEPARTURE EVENT first!

For Arrivals: Arriving Next Schedule Tanker interarrival Arrival at Size time time For beginning Service: Unloadin Number Terminals Assign to Aseigne Unload 9 Tanker In queue free Terminal d Entity time of size Event Calendar Entity number Time Event Schedule Departure at time Time in System 0.00 initialize -- 0 A5 [Entf. EventType. Time] 11. ARR, 0.001 -END, 15.00] 0.00 Arrival Smal 1.00 1.00 0 5 1 Smal 2.00 2.00 12. ARR, 1.00] 1, CER, 2.00] - END, 15.00 1.00 Arrival 2 Unload Time at Terminal Type of Tanker Terminal A Terminal 5 Supertanker 4 Midsize tanker 3 Small tanker 2 5 3 Fill these values in, 200!! Random number Associated stream: Tanker Size Tanker Size 0.82 Small 0.28 0.12 0.12 0.44 0.70 0.32 0.15 0.77 0.91 Size of Tanker Probability Supertanker 0.25 Midsize tanker 0.35 Small tanker 0.4 Note that these values are already niled in TANKER SIZES RANDOM NUMBER MAPPING FROM TO TANKER SIZE 0.00 Supertanker Midsize tarker 1.00 Small tanker Notice mar the cumulauve probabiles are calculated for FROM and To columns. Do the same for the interarrival Time mapping zable below Interarrival Times in days) Probability 0.33 0.17 FIN these values in, zool! INTERARRIVAL RANDOM NUMBER MAPPING FROM TO INTERARRIVAL TIME 0.00 1.00 Fill these values in, 2001/ Random number Associated Interarrival stream: Time Interarrivals 0.02 0.27 0.80 0.80 0.42 0.45 0.89 0.50 0.91 0.57 For beginning Service: For Arrivals: Arriving Next Schedule Number Terminals Assign to Tanker interarrival Arrival at In queuel free Size time time Terminal Time Entity number Event Assigne d Entity Unloadin 9 Tanker of size Unload time Schedule Event Calendar Departure Time in at time [Ent EventType.Time System , ) 11. ARR, 0.001 END, 15.00 Fill these values in, zoolf Random number Associated stream: Tanker Size Tanker Size 0.82 Small 0.28 0.12 0.12 0.44 0.70 0.32 Unload Time at Terminal Type of Tanke Terminal A Terminal B Supertanker 4 Midsize tanker 3 Small tanker 2 0.00 initialize 0 A.E Size of Tanker Probability Supertanker 0.25 Midsize tanker 0.35 Smail tanker 0.4 0.00 Arrival 1 Sma 1.00 1.00 o 5 1 1 Smal 2.00 2.00 12. ARR, 1.00] I, CEF, 2.00] - END, 15.00] 0.15 Nore mar these values are already filed in TANKER SIZES RANDOM NUMBER MAPPING FROM TO TANKER SIZE 0.00 Supertanker Midsize tarke 1.00 Small tanker Notice mar the cumulauve probabilives are calculated for FROM and to columns. Do the same for the interarrival Time mapping table below 1.00 Arrival 2 0.77 0.91 Internival Times (in days) Probability 0.33 0.17 0.25 0.25 FIN these values in, zool! INTERARRIVAL RANDOM NUMBER MAPPING FROM TO INTERARRIVAL TIME 0.00 1.00 Fill these values in, 100/1 Random Associated number Interarrival stream: Time Interarrivals 0.02 0.27 0.80 0.80 0.42 0.45 0.89 0.50 0.91 0.57