Excel Solver-maximize annual passenger-carrying capability
Not what you're looking for?
An airline owns an aging fleet of jet airplanes. It is considering a major purchase of up to 17 new model 7a7 and 7b7 jets. The decision must take into account numerous cost and capability factors, including the following: (1) The airline can finance up to $400 million in purchases; (2) each 7a7 jet will cost $35 million and each 7b7 jet will cost $22 million; (3) at least one third of the planes purchased should be the longer range 7a7; (4) the annual maintenance budget is to be no more than $8 million; (5)the annual maintenance cost per 7a7 is estimated to be $800,000, and it is $500,000 for each 7b7 purchased; and (6) each 7a7 can carry 125,000 passengers per year, and each 7b7 can fly 81,000 passengers annually. Formulate this as an IP problem to maximize the annual passenger-carrying capability. Solve using Excel.
Purchase this Solution
Solution Summary
This posting contains formulation and solution to following problem on LPP using excel solver.
Purchase this Solution
Free BrainMass Quizzes
Exponential Expressions
In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.
Multiplying Complex Numbers
This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.
Solving quadratic inequalities
This quiz test you on how well you are familiar with solving quadratic inequalities.
Geometry - Real Life Application Problems
Understanding of how geometry applies to in real-world contexts
Know Your Linear Equations
Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.