Question
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:
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.
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started