South Central Airlines (SCA) operates a commuter flight between Atlanta and Charlotte. The regional jet holds 50 passengers, and currently SCA books only up to 50 reservations. Past data shows that SCA always sells all 50 reservations but that, on average, two passengers do not show up. As a result, with 50 reservations, the flight is often being flown with empty seats. To capture additional profit, SCA is considering an overbooking strategy in which they would accept 52 reservations even though the airplane holds only 50 passengers. SCA believes that it will be able to always book all 52 reservations. The probability distribution for the number of passengers showing up when 52 reservations are accepted is estimated as follows: Passengers Showing UpProbability480.05490.25500.50510.15520.05 SCA receives a marginal profit of $100 for each passenger who books a reservation (regardless of whether or not they show up). The airline will also incur a cost for any passenger denied seating on the flight. This cost, which covers the added expenses of rescheduling the passenger as well as loss of goodwill, is estimated to be $150 per passenger. Develop a spreadsheet simulation model for this overbooking system. Simulate the number of passengers showing up for a flight. b. What is the probability that the net profit with the overbooking strategy will be less than the net profit without overbooking (50∗$100=$5,000)?