Question: 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

Please show your work in excel! Thank you! 7. Devos Inc.

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Smith 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...

please do in excel 7. JoeInc. 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...

please read and answer the below questions, and each response should be 400-450 words. for a like and good rating!! THANKS :) Please answer questions 1 and 2 (400-450 words) each response for a like...

CASE 25 Southwest Airlines in 2014: Culture, Values, and Operating Practices Arthur A. Thompson John E. Gamble The University of Alabama Texas A&M University-Corpus Christi n 2014, Southwest Airlines...

HI GOOD AFTERNOON, IS IT POSSIBLE THAT I MAY GET SOME ASSISTANCE WITH THIS ASSIGNMENT. SEE ATTACHMENT INSTRUCTIONS ARE AS FOLLOWS: ONLY THE RELEVANT HISTORY IS IMPORTANT, IN TERMS OF A PROBLEM...

pid ... ... DOMUS who GIGA WA IP- CASE STUDY I ... IN: Regression-Based Site Selection at La Quinta Hotels The old adage that says the three most important aspects of real estate are "location,...

PLEASE SHOW ALL WORK INCLUDING FUNTIONS AND OR/ FORMULAS, THANK YOU! A D H . 2 3 Which city had the largest total sales? Which city had the smallest total sales? Question 4: The following table...

IDEO Case Study Assignment What are features of IDEO's "Exploratory Phase"? (select all that apply) Team members share different insights they have gained in downloading sessions Extended interviews...

As if dealing with economic cycles, fuel price volatility, organized labor, changing customer demographics, and increased competition was not enough... Delta CEO Ed Bastian assumed the role of Deltas...

Using the U.S. Securities and Exchange Commission?s EDGAR database, select a public company that has consolidated subsidiaries. To minimize the chances of classmates selecting the same company,...

In Fig. 19-53, suppose C1 = C2 = C3 = 16.0 F. If the charge on C2 is Q2 = 24.0C, determine the charge on each of the other capacitors, the voltage across each capacitor, and the voltage V across the...

What is the primary use of U.S. Treasury securities? Why are the interest rates on Treasury securities so low? If people worried about the United States defaulting on the national debt, what would...

Which of the following is not a theory of the term structure of interest rates? Inflation Expectations Liquidity Preference M rket Segmentation Preferred Habitat

5. Develop a scenario comparing two PH programs and involving the use of a CBA.

3. Comment on how diversity and equality should be managed.

describe the legislation that addresses workplace equality

explain the concept of workforce diversity and how to manage it successfully