Formulate this as integer programming problem

Assignment Help Operation Management

Reference no: EM132201674

An airline owns an aging fleet of Boeing 737 jet airplanes. It is considering a major purchase of up to 17 new Boeing model 757 and 767 jets. The decision must take into account numerous cost and capability factors, including the following: (1) the airline can finance up to $1.6 billion in purchases; (2) each Boeing 757 will cost $80 million, and each Boeing 767 will cost $110 million; (3) at least one-third of the planes purchased should be the longer-range 757; (4) the annual maintenance budget is to be no more than $8 million; (5) the annual maintenance cost per 757 is estimated to be $800,000, and it is $500,000 for each 767 purchased; and (6) each 757 can carry 125,000 passengers per year, whereas each 767 can fly 81,000 passengers annually. Formulate this as an integer programming problem to maximize the annual passenger-carrying capability. What category of integer programming problem is this?

Solve this problem.

I need step by step instructions how to solve this problem with excel solver.

Reference no: EM132201674

Questions Cloud

Explain for your investors the purpose of the presentation : Explain for your investors the purpose of the presentation. What do you plan to communicate, and why should your investors pay attention?

Successful execution of strategic objectives : Successful execution of strategic objectives is key in healthcare and provides leaders the direction to handle complexity,

A christian ethic for business : Just Business, “A Christian Ethic for Business,” describes a dilemma faced by Maria. What do you think that Maria should do?

Measured by the balanced scorecard : What four broad areas of organizational performance are measured by the Balanced Scorecard?

Formulate this as integer programming problem : Formulate this as an integer programming problem to maximize the annual passenger-carrying capability. What category of integer programming problem is this?

Investigate the possibility of cloning human organs : In a departure from its normal business operations, Apple has recently teamed up with a bio-tech company to investigate the possibility of cloning human organs.

Course project brainstorming : Each course requires you to complete a Course Project. In most cases, that project will be a paper that deals with a topic related to the course content.

Describe the organization you are evaluating : Identify and describe the organization you are evaluating. Provide an overview of the industry within which the organization operates.

Use the application of goal linear programming : If I were the president of UNOH, one managerial decision I might use the application of goal Linear Programming,

User Account

All Pages