Use Excel : SOLVER

An airline owns an aging fleet of Boeing 737 jet airplanes. It is considering a major purchase of up to 17 new Boeing models 757 and 767 jets. The decision must take into account several costs and capacity factors including the following i. The airline can finance up to Rs. 4000 millions in purchases ii. Each Boeing 757 will cost Rs. 350 million while each Boeing 767 will cost Rs. 220 million 10 iv. V. At least one third of the planes purchased should be longer ranged 757. The annual maintenance budget is to be no more than Rs. 80 million The annual maintenance cost per 757 is estimated to be Rs. 800000 and it is Rs. 500000 for each 767 purchased. Each 757 can carry 125000 passengers per year while each 767 can fly 81000 passengers annually. Formulate and solve this problem as linear programming problem to maximize the annual passenger carrying capacity vi