Yukon Air has been in the airline business for more than 15 years and it has an
ID: 3281733 • Letter: Y
Question
Yukon Air has been in the airline business for more than 15 years and it has an ageing fleet of Boeing 757 jet airplanes. In order to catch up in the competitive industry of air transport, it is considering a major purchase of up to 17 new Boeing models 787 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 787 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 Boeing 787; (4) the annual maintenance budget is to be no more than $ 8 million; (5) the annual maintenance cost per Being 787 is estimated to be $800,000, and it is $ 500,000 for each Boeing 767 purchased; and (6) each Boeing 787 can carry 125,000 passengers per year, whereas each Boeing 767 can fly 81,000 passengers annually. Using the integer programming model in MS Excel, find the maximum annual passenger capability of an optimum combination of purchases of Boeing 787 and Being 767 jets.
Explanation / Answer
constraints:
17 total
total available amnt: 1.6 bn
cost of 787 : 80 mn
cost of 767 :110 mn
boieng 787>=(total planes )/3
maintannance budget <=8 mn
787 mainatance cost: 0.8 mn
767 : 0.5 mn
boeing 787 capacity/yr: 0.125 mn
767 capacity:0.081 mn
maximum capacity : 1.273 mn/yr
comment ur mail id so that i can mail u the excell document
boing 767 boeing 787 cost(in mn) 110 80 maintance 0.5 0.8 capacity /yr 0.081 0.125 requird planes 8 5 total cost 1280 maintance budget 8 maximum capacity of both planes 1.273 total planes 13Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.