The airline industry using excel solver

Assignment Help Business Management

Reference no: EM1332154

During the month of July, Pittsburgh resident Bill Fly must make 4 round-trip flights between Pittsburgh and Chicago. These are the dates of the meetings Bill must attend:

Trip 1: Leave Pitt on Monday July. 1, Leave Chicago on Friday July 5

Trip 2: Leave Pitt on Tuesday July 9, Leave Chicago on Thursday July 11

Trip 3: Leave Pitt on Monday July 15, Leave Chicago on Friday July 19

Trip 4: Leave Pitt on Wednesday July 24, Leave Chicago on Thursday July 25

Bill must purchase 4 round trip tickets. Without a discounted fare, a round trip ticket between Pittsburgh and Chicago costs $500. If Bill's stay in a city includes a weekend, he gets a 20% discount on the round-trip fare. If his stay is more than 10 days, he receives a 30% discount, and if his stay in a city is at least 21 days, he receives a 35% discount. However, at most one discount can be applied toward the purchase of any ticket. Determine how to minimize the total cost of purchasing the 4 round-trip tickets. (hint: it might be beneficial to pair one half of one round-trip ticket number with half of another round-trip ticket).

This can be developed as an assignment problem where the supply nodes are the flights leaving Pittsburgh and the demand nodes are the flights leaving Chicago. Any assignment is feasible. For example, if he could purchase a roundtrip ticket to leave Pittsburgh 8/1 and leave Chicago 8/11. He could then purchase a roundtrip ticket to leave Chicago 8/5 and leave Pittsburgh 8/24. That would get him leaving Pittsburgh on 8/1 and leaving Chicago on 8/5 by using half of each roundtrip ticket. The key is that four round-trip tickets give him eight one-way tickets that he can use any way he wants.

Chi 7/5 Chi 7/11 Chi 7/19 Chi 7/25

Pitt 7/1 $500 $400 $350 $325

Pitt 7/9 $400 $500 $400 $350

Pitt 7/15 $400 $400 $500 $400

Pitt 7/24 $350 $350 $400 $500

Reference no: EM1332154

Questions Cloud

Build a code in preparation for creating a spell-checker : Write down a code in preparation for creating a spell-checker. For now don't worry about actually spell checking: Just write a program that can read in the dictionary word by word.

How to calculate federal and fica taxes withheld : how to calculate federal and fica taxes withheld.

Find productivity improvement by reducing materials cost : CD players are produced on an automated assembly line process. The standard cost of CD players is $150 per unit [labor $30, materials $70 and overhead $50] the sales price is USD 300 per unit.

Modify a single program using control structures : For your strength of materials course you will write down a single program using control structures(including nested loops)and file I/O to explore the deflection of the cantilever beam with a point load at the free end.

The airline industry using excel solver : During the month of July, Pittsburgh resident Bill Fly must make 4 round-trip flights between Pittsburgh and Chicago. These are the dates of the meetings Bill must attend:

How many units of the contract will the agent buy : Suppose a risk averse agent. Explain how many units of the contract will the agent buy if the price is q=k.

Organizational structure employed by the organization : Analyze the reason for the type of organizational structure employed by the organization

Simple textual table defining catalogues of retail store : make a function to read a series of catalogue records from a file into a vector of catalogue objects. You will need to use the class ifstream that is derived from istream, like so.

Buy or sell the commodity depending on its cost : This customer can buy or sell the commodity depending on its cost.

User Account

All Pages