Find an optimal solution using spreadsheet

Assignment Help Engineering Mathematics

Reference no: EM131439996

Question: An airlines corporation is considering the purchase of jet passenger planes so as to increase their passenger service. The type A plane costs $450 million each, the type B costs $400 million each, and the type C costs $250 million each. The corporation has budgeted $50 billion for the purchase of these planes in the forthcoming financial year. The three types of planes, if purchased, would be utilized at essentially maximum capacity. It is estimated that the net annual profit resulting from utilization of these planes would be $15 million for type A, $10.5 million for type B, and $7.5 million for type C. It is estimated that 25 trained pilots will be available, and if only C type planes were purchased, the maintenance facilities would be able to handle 30 new planes. However, each type B plane is equivalent to 4/3 type C plane and each type A plane is equivalent to 5/3 type C planes in terms of their use of maintenance facilities.

a. Develop a linear optimization model to determine how many of each type of plane should be purchased.

b. Implement your model on a spreadsheet and find an optimal solution.

Reference no: EM131439996

Questions Cloud

What value does program and interventions bring to agency : What value does the program and interventions bring to the agency? What ethical concerns might materialize in the implementation of the program, and how will you address them appropriately

What types of networks have you used : What types of networks have you used? What are some experiences you have had concerning the common threats listed above? How does a network topology affect data communication? Your discussion(s) should be addressed from a managers perspective as w..

Calculate inflation using the gdp deflator index : Calculate inflation using the GDP deflator index and explain why consumer price index (CPI) overstates inflation when compared to inflation rate determined by using GDP deflator.

Which of the following is not an accrual criteria : Which of the following is a mandatory collective bargaining subject? (Labor Unions and Employee Benefits: The National Labor Relations Act of 1935).Workers are classified as key employees if they meet one of which three criteria? (The Internal Reve..

Find an optimal solution using spreadsheet : An airlines corporation is considering the purchase of jet passenger planes so as to increase their passenger service. The type A plane costs $450 million each, the type B costs $400 million each, and the type C costs $250 million each.

Management and mdm application management : Discuss MDM over-the-air management and MDM application management. Be able to explain how push notification servers are used to manage mobile devices across the Internet. Explain how an MDM can manage mobile device applications.

Restrictions and mobile device configurations : Explain how MDM profiles and MDM agents are used within an MDM solution. Describe how MDM profiles can be used for restrictions and mobile device configurations. Describe the role of MDM agents and which mobile devices require MDM agent software.

Reviewing the adventures of an it leader : For this assignment, complete a 3-5 page summary based on your readings in The Adventures of an IT Leader. As you read the chapters, think about pertinent issues and the relationship of these factors to situation outcomes. As you prepare your paper..

Identify any environmental stressors : Identify any environmental stressors that are related to the environmental risk. Conclude with a discussion of your own risk perception of the issue

User Account

All Pages