Northeast Airlines recently began services from LAX to LGA New York. Passenger demand for this flight has been high, but its overall travel time has been unreliable. The Director of Operations at Northeast Airlines is a particularly concerned about delays and would like your help analyzing flight delays on this route. After pushing back from the gate, the schedule time from LAX to LGA is 325 minutes. This includes 25 minutes budgeted for taxi and takeoff at the originating airport, and 300 minutes for actual flying time. However, due to congestion at LAX the actual time from pushback to takeoff is uniformly distributed between 20 minutes and 50 minutes. Further, the actual flying time varies die to weather conditions and is uniformly distributed between 280 and 345 minutes.

A. Create @Risk simulation that will allow you to analyze the total duration of this flight. Run the model 1,000 iterations and answer the following questions.

1. What is the mean duration of the flight
2. what is the standard deviation of the duration of the flight
3. DOT considers a flight to be on time if it arrives no later than 15 minutes after its scheduled arrival time. What is the probability that the flight will arrive on time?
4. The Director considers any delay over 60 minutes to be excessive. What is the probability that the flight will arrive on time?

B. Compounding the issue is the fact that 25 percent of the time the flight is delayed from pushing back because of a late arriving crew. When this occurs, the Director has found that the pushback delay created by the late arriving crew is exponentially distributed with a 25-minute mean. Update your @Risk simulation model from part a (question above) to account for these changes. Run this simulation model for 1,000 iterations and answer the following questions.

1. What is the mean duration of the flight
2. what is the standard deviation of the duration of the flight
3. What is the probability that the flight will arrive on time?
4. What is the probability of an excessive delay?

C. LAX is planning to open a new runway next year. This is anticipated to shorten the pushback to takeoff time, resulting in it being uniformly distributed between 15 and 35 minutes. Further, Northeast airlines has the option to purchase an Airbus 321-neo and employ it on this route. As this aircraft has more powerful engines it is capable of increasing speed in adverse weather or air traffic situations; resulting in the flying time being uniformly distributed between 270 and 325. Change the parameters in your @Risk Simulation model from part b to answer the following questions.

1. Solely based on the LAX runway addition what is the probability that the flight will arrive on time?
2. Northeast Airlines would like to achieve at least a 70 percent on time arrival statistic. Would purchasing the Airbus 321-neo help team achieve this goal (assuming the LAX runway addition has also been done)?

Please Show steps of building @Risk Model and screenshots of how it looks.