ILC Airlines Small Planes Large Planes. Number to purchase 10 1 13 3933333 Total Profit Prolit pei plane 7000 000 4 22.000,090 Constars Budget Used Total Resources Budget 25,000,000 75.000,000 250 000 000 250,000,000 Upper bound on small plane 5 TLC Airlines: Revisited The answer for this problem is invalid Our recommendation would be to solve this problem as an integer Linear Program for a feasible solution, This will result in a lower total profit, but results in a Small Planes Large Planes feasible number of planes to purchase while matching all of the Number to purchase Total Profits constraints Profe per plane S 7,000,000 $ 22.000,000 The Image to the left shows the spreadsheet when using the ILP Constraints Budget Used Total Resources budget 25,000.000 75,000,000 250,000,000 250,000,000 The total profit lowers by over $300,000, but is now feasible This changed the decision variables, so the recommended action would he to purchase one small plane and three large planes. Upper bound on small planes Meal Issue Statement What is the optimal number of small versus large airplanes to buy, while staying with in the budget and other constraints, that will maximize profit? LET I'1 = number of small planes to buy 12 .= number of large planes to buy $7 million = profit per small airplane $23 million = profit per large airplane MAX - 7,800,000[21) + 23,000,000 P2) 35,000 000(#1] + 75,100,080(pa]