Please show your work in excel! Thank you!

7. Devos Inc. provides service between El Paso, San Antonio, Dallas, Austin, and Houston. There are 2 planes, each seat 110 passengers. The El Paso plane flies to Austin with a stopver in Dallas. The San Antonio plane flies to Houston with with a stopover in Dallas. We have two seat classes, a budget fare, B, and a full fare, F. You are given the following information on the fares and their forecasted demand: ODIF Fare Class Demand Fare 170 280 275 405 Origin El Paso El Paso El Paso El Paso El Paso El Paso San Antonio San Antonio San Antonio San Antonio San Antonio San Antonio Dallas Dallas Dallas Dallas 415 480 175 Destination Dallas Austin Houston Dallas Austin Houston Dallas Austin Houston Dallas Austin Houston Austin Houston Austin Houston ODIF Code EDB EAB EHB EDE EAF EHF SDB SAB SHB SDF SAF 325 300 380 515 SHF 496 190 DAB DHB DAF DHF 175 305 310 a. How many tickets of each fare should we sell? Put your work in Airplane tab 7. Devos Inc. provides service between El Paso, San Antonio, Dallas, Austin, and Houston. There are 2 planes, each seat 110 passengers. The El Paso plane flies to Austin with a stopver in Dallas. The San Antonio plane flies to Houston with with a stopover in Dallas. We have two seat classes, a budget fare, B, and a full fare, F. You are given the following information on the fares and their forecasted demand: ODIF Fare Class Demand Fare 170 280 275 405 Origin El Paso El Paso El Paso El Paso El Paso El Paso San Antonio San Antonio San Antonio San Antonio San Antonio San Antonio Dallas Dallas Dallas Dallas 415 480 175 Destination Dallas Austin Houston Dallas Austin Houston Dallas Austin Houston Dallas Austin Houston Austin Houston Austin Houston ODIF Code EDB EAB EHB EDE EAF EHF SDB SAB SHB SDF SAF 325 300 380 515 SHF 496 190 DAB DHB DAF DHF 175 305 310 a. How many tickets of each fare should we sell? Put your work in Airplane tab