Question

Business Management 2321-Practical Exercise #3 DO NOT SUBMIT THIS PAGE WITH YOUR EXERCISE our friend has started working for a discount airline startup that has attained considerable financing from venture capital firms and government in that occurs when planes are not flying. After speaking with the CEO and COO your friend has been put in touch with an aircraft broker who tells you that he Name this worksheet "Aircraft LP vestments. They specialize in transcontinental flights to avoid several of the fees and lost revenue can get you many of the planes listed below, each having their own specifications. 300-300 300-400 350-400 400 450-200 450-400 X1 X3 X4 X5 x6 27 $282 $32 Cost per plane (SMM) Required # crew people 14 2 31 7520 7 27 76 29 range (miles) 43,000 610 31 39 Monthly operating costs ($ Gate fee per plane ($ Typical maintenance time (bours Typical maintenance costS) Cost per seat mile (S)V 40 5490 s0.140 S0.150 $0.148 $0.138 $0.135$0.130 $0.126 52504840 320032 as The CEO and COO have the desired features from their fleet of re should be between 8 and 14 aircraft purchased1B max purchasing budget for the aircraft is $5.3BN The number of hired crew members is currently at 240, and management does not want to hire additional crew number of hired pilots is currently at 45, and management does not want to hire additional pilots 5They fleet of aircraft should to be able to carry at least 5400 people G· vThe average flying range of the fleet should be at least 7780 miles Monthly operating costs should be at or below $420,000 VAverage gate fee per aircraft should be at or below $480 Average maintenance time per aircraft should be at or below 18 hours Average maintenance cost per aircraft should be less than or equal to $4,900 .At least two of the model 300-300 and two of the 450-400 should be purchased Help your friend to formulate a linear program with the decision variables constrained to integers to find the lowest cost that can meet the specifications of the CEO and CoO. Run the program. There may or may not be a mnimize Cost What is objethe nchon&what ar censtraints Linear Programming-PT 2

What is objective fucntion to minimize cost? What are the constraints?

Answer 1

Objective function

Minimize 246X1 + 275X2 + 282X3 + 320X4 + 393X5 + 525X6 + 505X7

Constraints

8 <= X1 + X2 + X3 + X4 + X5 + X6 + X7 <= 14

246X1 + 275X2 + 282X3 + 320X4 + 393X5 + 525X6 + 505X7 <= 5300

10X1 + 14X2 + 14X3 + 20X4 + 18X5 + 35X6 + 32X7 <= 240

2X1 + 2X2 + 2X3 + 3X4 + 3X5 + 5X6 + 5X7 <= 45

250X1 + 310X2 + 340X3 + 370X4 + 480X5 + 720X6 + 730X7 >= 5400

7520X1 + 7650X2 + 7670X3 + 7820X4 + 7850X5 + 8030X6 + 8140X7 >= 7780*7

22000X1 + 27000X2 + 29000X3 + 31000X4 + 38000X5 + 39000X6 + 43000X7 <= 420000

420X1 + 420X2 + 430X3 + 490X4 + 500X5 + 550X6 + 610X7 <= 480*7

21X1 + 22X2 + 11X3 + 13X4 + 15X5 + 8X6 + 14X7 <= 18*7

4080X1 + 5250X2 + 4840X3 + 3200X4 + 3250X5 + 3030X6 + 5490X7 <= 4900*7

X1 >= 2

X7 >= 2

X1,X2,X3,X4,X5,X6,X7 >= 0