Question

In: Finance

I just need to understand Question 1 and 2. I just wanted to make sure I...

I just need to understand Question 1 and 2. I just wanted to make sure I did the revenue management right.

Freedom Airlines recently started operations in the Southwest. The airline owns two airplanes, one based in Phoenix and the other in Denver. Each airplane has a coach section with 140 seats available. Each afternoon, the Phoenix based airplane flies to San Francisco with stopovers in Las Vegas and in San Diego. The Denver-based airplane also flies to San Francisco with stopovers in Las Vegas and in San Diego. Each airplane returns to its home-base with no stopovers.

Freedom Airlines uses two coach-fare classes: A discount fare (A) and a full fare (B). Discount fares are available with a 21-day advance purchase. Full fares applied at any time, up to the time of the flight.

Below is the daily fare and demand data for 16 selected Freedom Airline itineraries. Itineraries 1 through 6 apply to the Phoenix based airplane (leg 1); itineraries 7 through 12 apply to the Denver based airplane (leg 2); itineraries 13 and 14 apply to the Phoenix based airplane (leg 3); itineraries 15 and 16 apply to the Denver based airplane (leg 4):

1

Phoenix

Las Vegas

A

$ 180.00

50

2

Phoenix

San Diego

A

$ 270.00

40

3

Phoenix

San Francisco

A

$ 230.00

35

4

Phoenix

Las Vegas

B

$ 380.00

15

5

Phoenix

San Diego

B

$ 460.00

10

6

Phoenix

San Francisco

B

$ 560.00

15

7

Denver

Las Vegas

A

$ 200.00

50

8

Denver

San Diego

A

$ 250.00

45

9

Denver

San Francisco

A

$ 350.00

40

10

Denver

Las Vegas

B

$ 385.00

15

11

Denver

San Diego

B

$ 445.00

10

12

Denver

San Francisco

B

$ 580.00

10

13

San Francisco

Phoenix

A

$ 250.00

70

14

San Francisco

Phoenix

B

$ 600.00

10

15

San Francisco

Denver

A

$ 325.00

50

16

San Francisco

Denver

B

$ 585.00

10

  1. Develop a revenue management (maximizing) model based on the information given in the scenario.
  2. How many seats should be allocated to each of the 16 itineraries to maximize revenue?

Solutions

Expert Solution

Revenue Model based on the information provided

Rate per seat Demand Revenue
1 Phoenix Las Vegas A 180 50 9000
2 Phoenix San Diego A 270 40 10800
3 Phoenix San Francisco A 230 35 8050
4 Phoenix Las Vegas B 380 15 5700
5 Phoenix San Diego B 460 10 4600
6 Phoenix San Francisco B 560 15 8400
7 Denver Las Vegas A 200 50 10000
8 Denver San Diego A 250 45 11250
9 Denver San Francisco A 350 40 14000
10 Denver Las Vegas B 385 15 5775
11 Denver San Diego B 445 10 4450
12 Denver San Francisco B 580 10 5800
13 San Francisco Phoenix A 250 70 17500
14 San Francisco Phoenix B 600 10 6000
15 San Francisco Denver A 325 50 16250
16 San Francisco Denver B 585 10 5850
Total 475 143425

# In order to maximize the revenues the only available option to the airline (with the provided information) is to increase its demands to the maximum.

# The max seats in an aircraft = 140

The Revenue maximization model is as follows:-

From To Average Rate per seat Current Demand Max Demand Revenue
Phoenix San Francisco 226.67 125 140 31733.33
Phoenix San Francisco 466.67 40 140 65333.33
Denver San Francisco 266.67 135 140 37333.33
Denver San Francisco 470 35 140 65800
San Francisco Phoenix 250 70 140 35000
San Francisco Phoenix 600 10 140 84000
San Francisco Denver 325 50 140 45500
San Francisco Denver 585 10 140 81900
446600

Conclusion: the max revenue that could be achieved by Freedom Airlines = $446,600 on daily basis which more than $303,175 from current daily revenue of $143,425


Related Solutions

I just need to understand Question 1 and 2. I just wanted to make sure I...
I just need to understand Question 1 and 2. I just wanted to make sure I did the revenue management right. Freedom Airlines recently started operations in the Southwest. The airline owns two airplanes, one based in Phoenix and the other in Denver. Each airplane has a coach section with 140 seats available. Each afternoon, the Phoenix based airplane flies to San Francisco with stopovers in Las Vegas and in San Diego. The Denver-based airplane also flies to San Francisco...
I need a NPV calculation. I just want to make sure I got it correct. Initial...
I need a NPV calculation. I just want to make sure I got it correct. Initial Cost at t=0 is $150 rate = 16% growth rate in perpetuity after year 5 at 1.5% Year 1 2 3 4 5 Cash Flow 5 11.4 14 21 28
I have placed my answers in bold I just need to make sure these are right...
I have placed my answers in bold I just need to make sure these are right I have some with two answers because I'm just not sure which is correct. I just really want to do well on this last assignment any help is apperciated. Thank you! Abby is a 20-year-old female college student. For at least the last 3 months, Abby has experienced ongoing anxiety and worry without a specific cause for these feelings. She has been restless and...
(i just need an answer for question 4) (i just need an answer for just question...
(i just need an answer for question 4) (i just need an answer for just question 4) you have two facilities, one in Malaysia and one in Indonesia. The variable cost curve in the Malaysian plant is described as follows: VCM = q­ + .0005*q2 , where q is quantity produced in that plant per month. The variable cost curve in the Indonesian plant is described by VCI = .5q + .00075q2, where q is the quantity produced in that...
I need a short and clear opinion so I can understand the question and make my...
I need a short and clear opinion so I can understand the question and make my own opinion Writing in the 19th century, the British economist Thomas Malthus argued that the law of diminishing marginal returns implied eventual misery for humanity because, in the case of agriculture, there is a fixed amount of available land and additional labor would only yield ever smaller increases in food production. The inevitable result, as Malthus saw it, was that population growth would eventually...
I just need question three answered. Here is the answer to question 2 and 1 if...
I just need question three answered. Here is the answer to question 2 and 1 if you need it. https://www.chegg.com/homework-help/questions-and-answers/need-question-2-answered-paste-link-answer-number-one-answered-another-chegg-tutor-https-w-q46591079?trackid=UL8zNe1z Suppose that two teams (for fun, let’s call them the Domestic Shorthairs and Cache Cows) play a series of games to determine a winner. In a best-of-three series, the games end as soon as one team has won two games. In a best-of-five series, the games end as soon as one team has won three games, and so on. Assume...
I'm working on setting up a final project for Statistics and I wanted to make sure...
I'm working on setting up a final project for Statistics and I wanted to make sure I am choosing the right test for my hypotheses. Are my test choices correct? Hypotheses I hypothesize that the difference in the respondent’s physical effort at work, and how difficult it is for the respondent to take time off, has an impact on the respondent’s general health. Statistical Test Used: ANOVA I hypothesize that black men with less than college education are less likely...
1. Read the article to make sure you understand what it is talking about.   2. Write...
1. Read the article to make sure you understand what it is talking about.   2. Write a paragraph (200 words) summarizing the article. Be sure you have factual information included in your summary. Make sure you state where you found your article (which newspaper / online source), the author and the date of the article.   3. Write a paragraph (300 words) with your opinion on the article.   What did you think about the article? If the article made you feel...
THIS IS A VERY IMPORTANT QUESTION. PLEASE MAKE SURE YOU DO IT COMPLETELY AND UNDERSTAND THE...
THIS IS A VERY IMPORTANT QUESTION. PLEASE MAKE SURE YOU DO IT COMPLETELY AND UNDERSTAND THE CONCEPTS. VNA Enterprises, Inc. manufactures and sells a single product. A schedule of units sold for 3 months and related expenses are as follows: January February March Production in units 18900 22680 13230 Cost A $47327 $56512 $33549 Cost B $61425 $61425 $61425 Cost C $39123 $46948 $27386 Inspect the data in the table above. 1. Which cost is a variable cost? (Type A,...
*****NOTE: I DO NOT NEED A DRIVER FILE. I NEED mixed.h AND mixed.cpp********* *****PLEASE MAKE SURE...
*****NOTE: I DO NOT NEED A DRIVER FILE. I NEED mixed.h AND mixed.cpp********* *****PLEASE MAKE SURE THAT mixed.h AND mixed.cpp WORK WITH THE DRIVER FILE PROVIDED******************* Objective: Upon completion of this program, you should gain experience with overloading basic operators for use with a C++ class. The code for this assignment should be portable -- make sure you test with g++ on linprog.cs.fsu.edu before you submit. Task Create a class called Mixed. Objects of type Mixed will store and manage...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT