Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Establish a ticket allocation methodology, given a set of ticket prices for a given day, for basic coach and economy plus tickets for all routes

Establish a ticket allocation methodology, given a set of ticket prices for a given day, for basic coach and economy plus tickets for all routes within the hubs region.

This local network is serviced by two planes:

1. Airbus A220 -100 with a total seating capacity of 135 passengers

2. Airbus A320 with total seating capacity of 150 passengers

every destination must be served non-stop to and from Kansas. Like this:

image text in transcribed

The two planes are parked overnight at Saltlake City and Atlanta. Here are all future flight days in a 6-month time window, for each fare class and destination.

image text in transcribed

1. Determine how many seats to allocate to each route (you can check that total demand exceeds capacity) with the goal to maximize revenue. Model output should contain

metrics used by agents or travel site engines that assist in guiding whether tickets should still be allocated if full allocated capacity is reached for a given route and class

2. Advise the board at which location to station the A220 and A320 (one in Saltlake, the other in Atlanta)

Saltlake City Chicago Kansas City (Hub) Dallas Atlanta Route Ticket Price Forecasted Seats 1 185 35 2 3 277 235 47 43 4 390 16 462 5 5 6 565 12 7 24 8 9 Departure Salt Lake City SaltLake City SaltLake City Salt Lake City Salt Lake City Salt Lake City Atlanta Atlanta Atlanta Atlanta Atlanta Atlanta Kansas City Kansas City Kansas City Kansas City Destination Kansas City Dallas Chicago Kansas City Dallas Chicago Kansas City Dallas Chicago Kansas City Dallas Chicago Dallas Dallas Chicago Chicago Class Basic Coach Basic Coach Basic Coach Regular Coach Regular Coach Regular Coach Basic Coach Basic Coach Basic Coach Regular Coach Regular Coach Regular Coach Basic Coach Regular Coach Basic Coach Regular Coach 206 249 350 56 38 10 388 15 11 8 454 585 12 12 13 187 61 14 387 6 15 232 46 16 590 11 Saltlake City Chicago Kansas City (Hub) Dallas Atlanta Route Ticket Price Forecasted Seats 1 185 35 2 3 277 235 47 43 4 390 16 462 5 5 6 565 12 7 24 8 9 Departure Salt Lake City SaltLake City SaltLake City Salt Lake City Salt Lake City Salt Lake City Atlanta Atlanta Atlanta Atlanta Atlanta Atlanta Kansas City Kansas City Kansas City Kansas City Destination Kansas City Dallas Chicago Kansas City Dallas Chicago Kansas City Dallas Chicago Kansas City Dallas Chicago Dallas Dallas Chicago Chicago Class Basic Coach Basic Coach Basic Coach Regular Coach Regular Coach Regular Coach Basic Coach Basic Coach Basic Coach Regular Coach Regular Coach Regular Coach Basic Coach Regular Coach Basic Coach Regular Coach 206 249 350 56 38 10 388 15 11 8 454 585 12 12 13 187 61 14 387 6 15 232 46 16 590 11

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Entrepreneurial Finance

Authors: Philip J. Adelman; Alan M. Marks

6th edition

9780133099096, 133140512, 133099091, 978-0133140514

More Books

Students also viewed these Finance questions

Question

LO2.6 Explain how the market system deals with risk.

Answered: 1 week ago