Revenue Management (Maximizing) Model Assignment

I need help creating an excel solver for the listed question.

  1. Develop a revenue management (maximizing) model based on the information given in the scenario.
  1. How many seats should be allocated to each of the 16 itineraries to maximize revenue?
  2. Assume operating costs for each of the legs is as follows:
    1. Leg 1 = $20,250
    2. Leg 2 = $19,750
    3. Leg 3 = $20,500
    4. Leg 4 = $19,500

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

Get Finance homework help today

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Australia Assessments
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
English 101
Good job.
Customer 462899, April 26th, 2022
History
looks great
Customer 463501, October 16th, 2022
Leadership Studies
Writer was very patient and completed on time
Customer 452707, October 4th, 2022
Education
Impeccable, fast, and professional!
Customer 453707, January 22nd, 2020
GOVT 200
Plagiarism issue noted.
Customer 454799, July 11th, 2022
Environmental studies and Forestry
Excellent work.
Customer 458115, May 2nd, 2022
Political science
Great Job Bless your heart and soul
Customer 453983, February 7th, 2020
Retail
This submission was excellently done. Looking foward to your future contribution.
Customer 463463, December 12th, 2022
Environmental studies and Forestry
Good work.
Customer 458115, June 6th, 2022
Psychology
Good journal.
Customer 459947, May 10th, 2022
Art (Fine arts, Performing arts)
Good job.
Customer 462997, May 18th, 2022
Nursing
nice work
Customer 453939, June 8th, 2020
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat