Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Allocate Route and Fare-Class Tickets Let's say that FOPA advises the board to make Kansas City a hub that forms a local network covering: Saltlake

image text in transcribed

Allocate Route and Fare-Class Tickets

Let's say that FOPA advises the board to make Kansas City a hub that forms a local network covering: Saltlake City, Chicago, Dallas, and Atlanta. 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

Since Kansas City is the hub for this network, every destination must be served non-stop to and from Kansas. In order to achieve this goal in an efficient manner the two planes are parked overnight at Saltlake City and Atlanta (which might serve as hubs for other regions). Therefore each morning the Saltlake City based plane flies to Dallas with a stopover at Kansas City and the Atlanta based plane flies towards Chicago also stopping over at Kansas City. The diagram below illustrates the logistics of this arrangement. BAL sells two ticket types: basic and regular coach. The basic fare restricts carry on, does not allow passengers to select their seat in advance, and does not allow for any changes to be made to the itinerary. Regular coach ticket holders can select their seats in advance, can bring one carry on item onboard, can change their ticket free of charge once (and pay the ticket price difference if larger than zero), and receive a complimentary beverage upon boarding the plane. Every day, the pricing engine (that you do not have to develop as part of this use case) spits out a set of prices and expected demand for all future flight days in a 6 month time window, for each fare class and destination.

FOPA is tasked with developing an algorithm that returns the allocated number of seats for each class and itinerary. The algorithm output is used by ticket agents and queried by various online vendors that sell tickets on BAL's behalf.

To summarize, FOPA must:

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)

image text in transcribedimage text in transcribed
Route Departure Destination Class Ticket Price Forecasted Seats 1 SaltLake City Kansas City Basic Coach 185 35 2 SaltLake City Dallas Basic Coach 277 47 3 SaltLake City Chicago Basic Coach 235 43 4 SaltLake City Kansas City Regular Coach 390 16 5 SaltLake City Dallas Regular Coach 462 5 6 SaltLake City Chicago Regular Coach 565 12 7 Atlanta Kansas City Basic Coach 206 24 8 Atlanta Dallas Basic Coach 249 56 9 Atlanta Chicago Basic Coach 350 38 10 Atlanta Kansas City Regular Coach 388 15 11 Atlanta Dallas Regular Coach 454 8 12 Atlanta Chicago Regular Coach 585 12 13 KansasCity Dallas Basic Coach 187 61 14 KansasCity Dallas Regular Coach 387 6 15 KansasCity Chicago Basic Coach 232 46 16 KansasCity Chicago Regular Coach 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

Step: 3

blur-text-image

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

Intermediate Accounting

Authors: J. David Spiceland, James Sepe, Mark Nelson, Wayne Thomas

10th edition

1260481956, 1260310175, 978-1260481952

More Books

Students also viewed these Accounting questions