Formulating and Solving Linear Programming Models 3. An airline company has decided to place orders for Airbus A321 planes that will service the Orange County-San Francisco route. The company must share the desired cabin seat composition to Airbus to customize its flights. The total floor area available for seating in the cabin is 240,000 square inches. An Economy Class seat takes up an area of 500 square inches. A Business Class seat takes up an area of 1250 square inches and a First-Class seat occupies a floor area of 2400 square inches. The airline has forecasted that there would be at most 80 passengers choosing the premium category of seats (Business Class and First Class) for each trip. The airline also estimates to earn an average profit of $50,$150, and $300 respectively for each Economy, Business and First-Class seat in the plane. In addition, the airline is required by regulators to offer at least 100 Economy Class seats as a part of affordable travel program. Formulate a linear program that will help the airline plan its desired cabin seat composition to maximize its profit. Identify at least 2 feasible seat configurations that meet the constraints listed above. Solve the linear program using Microsoft Excel. Please include screenshots of the Excel Solver window AND the Excel spreadsheet with decision variables, parameters, constraints, and objective function cells