• Home
  • Blog
  • Solve the problem and I need a Excel for this question.

Solve the problem and I need a Excel for this question.

0 comments

On a popular route, an airline offers two classes of service: business class (B) and economy
class (E). The respective demands are given by:

B =540− .5 B and E =380− .25 E

Because of ticketing restrictions, business travelers cannot take advantage of economy’s low
fares. The airline operates two flights daily. Each flight has a capacity of 200 passengers. The
cost to the airline per flight is $20,000. The airline seeks to maximize total revenue.

Create a spreadsheet that can solve for the optimal number of each type of ticket the airline
should sell. Your spreadsheet should include revenue and marginal revenue for each type of
ticket, total revenue, marginal cost, total cost, and profit. Your only choice variables should
be the number of business class tickets and the number of economy class tickets. All other
values (aside from the seats per plane and total cost per trip) should be computed based on
your choice variable.

  1. By hand, solve for the fares the airline charge should charge to maximize revenue. How
    many passengers will buy tickets of each type? Check your answer with your spreadsheet
    solver. (Hint: remember that the optimal occurs where marginal cost = marginal benefit,
    MC=MB, and in this case the cost of selling one more economy class ticket is having to
    give up a business class ticket, and vice versa). Also report the total revenue and profit.
  2. Suppose the airline is considering promoting a single “value fare” to all passengers on the
    plane. Find the optimal single fare using the spreadsheet solver. (Hint: you can think of
    the ‘single fare’ as an additional constraint.) Also report the total revenue and profit.

Now suppose the airline can vary the number of daily flights, but due to their contract with
the airport they face the cost curve = 20000 + 5000 2 where F is the number of flights per
day. Assume the airline uses the optimal fares from part a.

c. By hand, solve for the profit maximizing number of flights. Check your answer with your
solver. Also report the total revenue and profit.

About the Author

Follow me


{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}