Question 3 The Fly-High Airplane Company builds small jet airplanes to sell to corporations for use by their executives. To meet the needs of these executives, the company's customers sometimes order a custom design of the airplanes being purchased. When this occurs, a substantial start-up cost is incurred to initiate the production of these airplanes. Fly-High has recently received purchase requests from three customers with short deadlines. However, because the company's production facilities already are almost completely tied up filling previous orders, it will not be able to accept all three orders. Therefore, a decision now needs to be made on the number of airplanes the company will agree to produce (if any) for each of the three customers. The relevant data are given in the table below. The first row gives the start-up cost required to initiate the production of the airplanes for each customer. Once production is under way, the marginal net revenue from each airplane produced is shown in the second row. The marginal net revenue is the purchase price minus the marginal production cost. The third row gives the percentage of the available production capacity that would be used for each plane produced. The last row indicates the maximum number of airplanes requested by each customer (but less will be accepted). Customer 1 Customer 2 Customer 3 Start-up cost $5 millions $3 millions 0 Marginal net revenue 53.5 millions $2 millions $1.2 millions Capacity used per plane 30% 20% Maximum order 2 planes 5 planes 4 planes 15% Fly-High now wants to determine how many airplanes to produce for each customer (if any) to maximize the company's total profit (total net revenue minus start-up costs). Formulate the mixed integer programming model and solve it using Excel solver for this problem. Question 3 The Fly-High Airplane Company builds small jet airplanes to sell to corporations for use by their executives. To meet the needs of these executives, the company's customers sometimes order a custom design of the airplanes being purchased. When this occurs, a substantial start-up cost is incurred to initiate the production of these airplanes. Fly-High has recently received purchase requests from three customers with short deadlines. However, because the company's production facilities already are almost completely tied up filling previous orders, it will not be able to accept all three orders. Therefore, a decision now needs to be made on the number of airplanes the company will agree to produce (if any) for each of the three customers. The relevant data are given in the table below. The first row gives the start-up cost required to initiate the production of the airplanes for each customer. Once production is under way, the marginal net revenue from each airplane produced is shown in the second row. The marginal net revenue is the purchase price minus the marginal production cost. The third row gives the percentage of the available production capacity that would be used for each plane produced. The last row indicates the maximum number of airplanes requested by each customer (but less will be accepted). Customer 1 Customer 2 Customer 3 Start-up cost $5 millions $3 millions 0 Marginal net revenue 53.5 millions $2 millions $1.2 millions Capacity used per plane 30% 20% Maximum order 2 planes 5 planes 4 planes 15% Fly-High now wants to determine how many airplanes to produce for each customer (if any) to maximize the company's total profit (total net revenue minus start-up costs). Formulate the mixed integer programming model and solve it using Excel solver for this
