Question: Solve using excel and Ampl only 5. A small cargo plane has three compartments for storing cargo: front, center, and back. These compartments have capacity

Solve using excel and Ampl only

Solve using excel and Ampl only 5. A small cargo

5. A small cargo plane has three compartments for storing cargo: front, center, and back. These compartments have capacity limits on both weight and space, as summarized in the table below. Furthermore, the weight of the cargo in the respective compartments must be the same proportion of that compartment's weight to maintain the balance of the airplane. Weight Compartment Capacity (Tons) Front 12 Center 18 Back 10 Space Capacity (Cubic Feet) 7.000 9,000 5,000 The following cargoes have been offered for shipment on an upcoming flight as space is available. Any portion of these cargoes can be accepted. Cargo 1 2 3 4 Weight (Tons) 20 16 25 13 Volume (Cubic Feet/Ton) 500 700 600 400 Profit (S/Ton) 320 400 360 290 a). Formulate a linear programming model for this problem statement. b). What is the optimum solution for the flight? c). If Cargo #4 was unavailable, what would the new optimum mixture be

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!

Build an LP Model using AMPL from the word problem A small cargo plane has three compartments for storing cargo: front, center, and back. These compartments have capacity limits on both weight and...

build the LP Model from the word problem, using your desired solution method. using ample code 5. A small cargo plane has three compartments for storing cargo: front, center, and back. These...

Model this problem in Excel and find the optimal solutions. A cargo plane has three compartments for storing cargo: front, center and rear. These compartments have the following limits on both weight...

USING AMPL USING AMPL USING AMPL USING AMPL USING AMPL - Transportation Model DEVELOP AN (AMPLE CODING)from the word problem. 5. A small cargo plane has three compartments for storing cargo: front,...

Solve this operations research question using python jupitor notebook. Q # Question Statement Marks CLO PLO Learning Type Learning Level Problem 1: A cargo plane has three compartments for storing...

3.22.* A cargo plane has three compartments for storing cargo: front, center, and back. These compartments have capacity limits on both weight and space, as summarized below. Page 111 Compartment...

A cargo plane has three compartments for storing cargo: front, center, and rear. These compartments have the following limits on both weight and space: Furthermore, the weight of the cargo in the...

Use CPLEX with external data: MS Excel and MS Access. Solve this problem with CPLEX and make report. A cargo plane has three compartments for storing cargo: front, center, and rear. These...

LP Formulation Additional Examples Example 1: A cargo plane has three compartments for storing cargo: front, center, and back. These compartments have capacity limits on both weight and space, as...

a) Suppose that {xn) and {yn} converge to the same real number. Prove that xn - yn 0 as n . b) Prove that the sequence {n} does not converge. c) Show that there exist unbounded sequences xn yn...

Suppose that the economys production function is given by Y=4K 0.7 L 0.3 . The saving rate is 20%, depreciation rate is 30%, population growth rate is 4%. a) What is the capital per worker and output...

Question 3 : Should farm losses be claimed as hobby losses or on Schedule F ?

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...