Question: solve by excel I (10 marks) A freight plane has three large compartments to carry cargo. Weight and volume limitations of these compartments are: Compartment

solve by excel I (10 marks) A freight plane has

solve by excel

I (10 marks) A freight plane has three large compartments to carry cargo. Weight and volume limitations of these compartments are: Compartment Volume Front Center Rear Weight (Tons) 10 16 8 6800 8700 5300 There are four cargos waiting to be loaded in this plane. Properties of these cargos are shown on the table below: Total Volume Corgo Profit (TL/ton) Total Weight (Tons) 18 K2 8640 9750 13340 4680 310 380 350 285 24 Furthermore, the weight of the cargo in the respective compartments must be the same proportion of that compartment's weight capacity to maintain the balance of the plane. Any proportion of these cargoes can be accepted."Formulate a linear programming model to maximize the profit by choosing how many tons of which cargo to load on the plane under these circumstances

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!