Excel solver-maximize annual passenger-carrying capability

Reference no: EM13124351

Excel Solver-maximize annual passenger-carrying capability

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.

Reference no: EM13124351

Questions Cloud

The arc price elasticity implied by the initial response : Calculate the arc price elasticity implied by the initial response to Z-Best's price increase and calculate the effective price reduction resulting from the coupon promotion.

Exploration of "race and ethnicity in the melting pot : The essay question is here: Write an essay in which you discuss a central theme to our exploration of "Race and Ethnicity in the Melting Pot". Use works by two of the following writers to support your ideas, as well as deepen your discussion: Baldwin..

Linear equations in business : Why is it important to understand linear equations in business? In particular can you provide examples where the relationship between items that can be affected by management and 'items' that management wished to achieve or attain may be 'linear'?

Calculate the quantity demanded at prices : Calculate the quantity demanded at prices of $5, $4, and $3 and calculate the prices necessary to sell 1,250, 1,500 and 1,750 thousand s of five gallon containers.

Excel solver-maximize annual passenger-carrying capability : Excel Solver-maximize annual passenger-carrying capability, 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 capabilit..

Net income from the proprietorship : Olgas proprietorship earned a net profit of $95,000 during the year and she withdrew $70,000 of this profit. Olga must report $70,000 net income from the proprietorship on her individual income tax return.

Communicate more effectively : How will being able to How will being able to communicate more effectively help you in your everyday life? Provide at least one specific example. help you in your everyday life? Provide at least one specific example.

Determine values at the profit-maximizing activity level : Calculate output, marginal cost, averagecost, price and profit at the average cost-minimizing activity level and calculate these values at the profit-maximizing activity level.

Applicable corner points-maximize profit : A company makes two soft drinks A and B. Each liter of A requires 4 hours processing and 4 hours distillation while each liter of B requires 5 hours processing and 3 hours distillation.

User Account

All Pages