Please solve using Excel

Q3. (10 points) Southeastern Airlines's daily flight from Atlanta to Charlotte uses a Boeing 737, with all-coach seating for 120 people. In the past, the airline has priced every seat at $150 for the one-way flight. An average of 80 passengers are on each flight. The variable cost of a filled seat is $35. Aysajan Eziz, the new operations manager, has decided to try a price differentiation approach, with seats priced at $99 for early bookings and at $190 for bookings within 1 week of the flight. He estimates that the airline will sell 70 seats at the lower price and 35 at the higher price. Variable cost will not change. Which approach is preferable to Mr. Eziz? Hint: Please see Example 7 (including figures 13.5 & 13.6) on p. 549 in the Revenue Management section of Chapter 13 in the textbook