Order For This Paper, Written Essays or Similar Assignment Help Services.

Fill the details/instructions form and checkout for your essay - pro writers; top college graduates only in less than 5 mins, NO AI—Plagiarism-free!.

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.

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

Order | Check Discount

Tags: , , , , , , , ,

Find The Best Writers, Tutors & Assignment Experts!

2025 Special Offer! Get 20-25% Off On ALL Your Orders!

Why trust us?

Every student wants the best grades and that’s our Focus

Graduate Level Writers

Our team consists of outstanding writers who have specialized knowledge in specific subject areas and professionals experienced in academic research writing. They hold at least a graduate degree—230 with Masters and MSN qualifications, experts carefully selected and trained to ensure the best quality of our work. .

College Students Prices

We’re dedicated to bringing on board top-notch writers who can provide excellent work at prices that make sense for college students; affordable papers. Our goal? To give you the best bang for your buck without ever compromising on the quality of our essay writing services—or the content of your paper. #Don’t forget to use the DISCOUNT code in the COUPONS section of the order form before you pay!.

100% Human Written

The service guarantees that our final work is 100% original, rearched and human written expertly. We are committed to delivering plagiarism-free and AI-free work to each university/college student's 'write my paper' request. To uphold this promise, we check every draft for any possible instances of duplication, wrong citation, grammar errors and artificiality before we send it to you. Thus, you can always rely on us to write genuine and high-standard content for your essay assignments.

How it works

When you trust to place an order with Homework Ace Tutors, here is what happens:

Complete the Order Form

Please fill out our order form completely, providing as much detail as possible in all the required fields.

Assignment of Writer

We carefully review your order and assign it to a skilled writer with the specific expertise needed to handle it. The writer then creates your content entirely from scratch.

Order in Progress and Submission

You, along with the support team and your assigned writer, communicate directly throughout the process. Once the final draft is delivered, you can either approve it or request edits, paraphrasing, or a complete revision.

Giving us Feedback(review our essay service)

Ultimately, we value your feedback on how your experience went. You can also explore testimonials from other clients. Additionally, you have the option to recommend or select your preferred writer for any future orders.

Write My Essay For Me