Question: 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

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 and space:

Compartment Weight capacity (tonnes) Space capacity (cubic metres)

Front 10 6800

Centre 16 8700

Rear 8 5300

The following four cargoes are available for shipment on the next flight:

Cargo Weight (tonnes) Volume (cubic metres/tonne) Profit (/tonne)

C1 18 480 310

C2 15 650 380

C3 23 580 350

C4 12 390 285

Any proportion of these cargoes can be accepted. The objective is to determine how much (if any) of each cargo C1, C2, C3 and C4 should be accepted and how to distribute each among the compartments so that the total profit for the flight is maximized.

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!

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 limits on both weight and space, as...

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: Furthermore, the weight of the...

5. (4pts) Using Python and whichever modeling library you prefer, formulate the following problem as a linear program and report the optimal solution. A cargo plane has three compartments for storing...

The Weigelt Corporation has three branch plants with excess production capacity. Fortunately, the corporation has a new product ready to begin production, and all three plants have this capability,...

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. CALCULATE MAXIMUM PROFIT THAT COULD BE MADE!! USING CPLEX!! A cargo plane has three compartments...

Formulate algebraically the Linear Programming (LP) model for this problem. Define the decision variables, objective function, and constraints. (18 points) Formulate this same linear programming...

An Airways cargo plane has three compartments for storing cargo, namely the front, middle and rear compartments. Each of these compartments has capacity limits for weight and space, as summarized in...

Please provide step by step solution An Airways cargo plane has three compartments for storing cargo, namely the front, middle and rear compartments. Each of these compartments has capacity limits...

Should states or the federal government be given more responsibility for poverty programs? What are the implications of placing greater responsibility for these programs on the states? Think about...

When treasury stock is bought and sold, the transactions do not result in gains or losses reported on the income statement. What account or accounts are used instead? Why are no income statement...

an underwriter who is physically located in and underwrites from a home or branch office of an insurance company is known as

Create a C# application named SalesTransactionDemo that declares several SalesTransaction objects and displays their values and their sum. The SalesTransaction class contains the following fields:...