Looking for a similar answer, essay, or assessment help services?

Simply fill out the order form with your paper’s instructions in a few easy steps. This quick process ensures you’ll be matched with an expert writer who
Can meet your papers' specific grading rubric needs. Find the best write my essay assistance for your assignments- Affordable, plagiarism-free, and on time!

Posted: March 14th, 2023

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.

What Citation Styles Can You Use for My Essay?

Students often ask, “Can you write my essay in APA or MLA?”—and the answer’s a big yes! Our writers are experts in every style imaginable: APA, MLA, Chicago, Harvard, you name it. Just tell us what you need, and we’ll deliver a perfectly formatted paper that matches your requirements, hassle-free.

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

Tags: 1500 Words Assessment Task, Ace Homework Tutors, Assignment Homework Help & Answers, Bishops Writing Bureau

Order|Paper Discounts

Why Choose Essay Bishops?

You Want The Best Grades and That’s What We Deliver

Top Essay Writers

Our top essay writers are handpicked for their degree qualification, talent and freelance know-how. Each one brings deep expertise in their chosen subjects and a solid track record in academic writing.

Affordable Prices

We offer the lowest possible pricing for each research paper while still providing the best writers;no compromise on quality. Our costs are fair and reasonable to college students compared to other custom writing services.

100% Plagiarism-Free

You’ll never get a paper from us with plagiarism or that robotic AI feel. We carefully research, write, cite and check every final draft before sending it your way.