Microsoft Excel 14.

0 Answer Report
Worksheet: [Cargo.xlsx]Sheet1
Report Created: 11-May-18 1:58:49 AM
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.141 Seconds.
Iterations: 8 Subproblems: 0
Solver Options
Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling
Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative

Objective Cell (Max)

Cell Name Original Value Final Value
$C$21 Max Profit Function 0 13650

Variable Cells
Cell Name Original Value Final Value Integer
$B$10 Front Cargo1 0 0 Contin
$C$10 Front Cargo2 0 0 Contin
$D$10 Front Cargo3 0 9.4 Contin
$E$10 Front Cargo 4 0 3.4 Contin
$B$11 Centre Cargo1 0 13.2 Contin
$C$11 Centre Cargo2 0 0 Contin
$D$11 Centre Cargo3 0 0 Contin
$E$11 Centre Cargo 4 0 6 Contin
$B$12 Back Cargo1 0 6.8 Contin
$C$12 Back Cargo2 0 0 Contin
$D$12 Back Cargo3 0 0.266666667 Contin
$E$12 Back Cargo 4 0 3.6 Contin

Constraints
Cell Name Cell Value Formula Status Slack
$B$15 Individual compartment ratio 0 $B$15=0 Binding 0
$B$16 Individual compartment ratio 0 $B$16=0 Binding 0
$F$10 Front 7000 $F$10<=7000 Binding 0
$F$11 Centre 9000 $F$11<=9000 Binding 0
$F$12 Back 5000 $F$12<=5000 Binding 0
$J$10 <= Weight of cargo 20 $J$10<=20 Binding 0
$J$11 <= Weight of cargo 0 $J$11<=16 Not Binding 16
$J$12 <= Weight of cargo 9.6666666667 $J$12<=25 Not Binding 15.33333333
$J$13 Weight of cargo 13 $J$13<=13 Binding 0
$B$10 Front Cargo1 0 $B$10>=0 Binding 0
$C$10 Front Cargo2 0 $C$10>=0 Binding 0
$D$10 Front Cargo3 9.4 $D$10>=0 Not Binding 9.4
$E$10 Front Cargo 4 3.4 $E$10>=0 Not Binding 3.4
$B$11 Centre Cargo1 13.2 $B$11>=0 Not Binding 13.2
$C$11 Centre Cargo2 0 $C$11>=0 Binding 0
$D$11 Centre Cargo3 0 $D$11>=0 Binding 0
$E$11 Centre Cargo 4 6 $E$11>=0 Not Binding 6
$B$12 Back Cargo1 6.8 $B$12>=0 Not Binding 6.8
$C$12 Back Cargo2 0 $C$12>=0 Binding 0
$D$12 Back Cargo3 0.2666666667 $D$12>=0 Not Binding 0.266666667
$E$12 Back Cargo 4 3.6 $E$12>=0 Not Binding 3.6
onNegative
Microsoft Excel 14.0 Sensitivity Report
Worksheet: [Cargo.xlsx]Sheet1
Report Created: 11-May-18 1:58:49 AM

Variable Cells
Final Reduced Objective Allowable
Cell Name Value Cost Coefficient Increase
$B$10 Front Cargo1 0 0 320 0
$C$10 Front Cargo2 0 -20 400 20
$D$10 Front Cargo3 9.4 0 360 200
$E$10 Front Cargo 4 3.4 0 290 57.14285714
$B$11 Centre Cargo1 13.2 0 320 66.66666667
$C$11 Centre Cargo2 0 -20 400 20
$D$11 Centre Cargo3 0 0 360 0
$E$11 Centre Cargo 4 6 0 290 0
$B$12 Back Cargo1 6.8 0 320 0
$C$12 Back Cargo2 0 -20 400 20
$D$12 Back Cargo3 0.266666667 0 360 0
$E$12 Back Cargo 4 3.6 0 290 0

Constraints
Final Shadow Constraint Allowable
Cell Name Value Price R.H. Side Increase
$B$15 Individual compartment ratio 0 -3.0127E-12 0 0.222222222
$B$16 Individual compartment ratio 0 6.394885E-13 0 0.114285714
$F$10 Front 7000 0.6 7000 114.2857143
$F$11 Centre 9000 0.6 9000 960
$F$12 Back 5000 0.6 5000 685.7142857
$J$10 <= Weight of cargo 20 20 20 0.363636364
$J$11 <= Weight of cargo 0 0 16 1E+030
$J$12 <= Weight of cargo 9.666666667 0 25 1E+030
$J$13 Weight of cargo 13 50 13 0.571428571
 Allowable
Decrease
1E+030
1E+030
0
0
0
1E+030
1E+030
53.33333333
0
1E+030
0
0

Allowable
Decrease
0.015873016
0.044444444
1600
100
100
5.230769231
16
15.33333333
8
Microsoft Excel 14.0 Limits Report
Worksheet: [Cargo.xlsx]Sheet1
Report Created: 11-May-18 1:58:49 AM

Objective
Cell Name Value
$C$21 Max Profit Function 13650

Variable Lower Objective Upper Objective

Cell Name Value Limit Result Limit Result
$B$10 Front Cargo1 0 0 13650 0 13650
$C$10 Front Cargo2 0 0 13650 0 13650
$D$10 Front Cargo3 9.4 9.4 13650 9.4 13650
$E$10 Front Cargo 4 3.4 3.4 13650 3.4 13650
$B$11 Centre Cargo1 13.2 13.2 13650 13.2 13650
$C$11 Centre Cargo2 0 0 13650 0 13650
$D$11 Centre Cargo3 0 0 13650 0 13650
$E$11 Centre Cargo 4 6 6 13650 6 13650
$B$12 Back Cargo1 6.8 6.8 13650 6.8 13650
$C$12 Back Cargo2 0 0 13650 0 13650
$D$12 Back Cargo3 0.266666667 0.266666667 13650 0.266666667 13650
$E$12 Back Cargo 4 3.6 3.6 13650 3.6 13650
Microsoft Excel 14.0 Answer Report
Worksheet: [Cargo.xlsx]Sheet1
Report Created: 11-May-18 2:32:29 AM
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.015 Seconds.
Iterations: 8 Subproblems: 0
Solver Options
Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling
Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Solve Without Integer Constraints, Assume N

Objective Cell (Max)

Cell Name Original Value Final Value
$E$19 Max Profit Cargo 4 13650 13650

Variable Cells
Cell Name Original Value Final Value Integer
$B$10 Front Cargo1 0 0 Contin
$C$10 Front Cargo2 0 0 Contin
$D$10 Front Cargo3 9.4 9.4 Contin
$E$10 Front Cargo 4 3.4 3.4 Contin
$B$11 Centre Cargo1 13.2 13.2 Contin
$C$11 Centre Cargo2 0 0 Contin
$D$11 Centre Cargo3 0 0 Contin
$E$11 Centre Cargo 4 6 6 Contin
$B$12 Back Cargo1 6.8 6.8 Contin
$C$12 Back Cargo2 0 0 Contin
$D$12 Back Cargo3 0.2666666667 0.266666667 Contin
$E$12 Back Cargo 4 3.6 3.6 Contin

Constraints
Cell Name Cell Value Formula Status Slack
$B$16 Individual compartment ratio 0 $B$16=0 Binding 0
$B$17 Individual compartment ratio 0 $B$17=0 Binding 0
$F$10 Front 7000 $F$10<=7000 Binding 0
$F$11 Centre 9000 $F$11<=9000 Binding 0
$F$12 Back 5000 $F$12<=5000 Binding 0
$J$10 <= Weight of cargo 20 $J$10<=20 Binding 0
$J$11 <= Weight of cargo 0 $J$11<=16 Not Binding 16
$J$12 <= Weight of cargo 9.6666666667 $J$12<=25 Not Binding 15.33333333
$J$13 Weight of cargo 13 $J$13<=13 Binding 0
$B$10 Front Cargo1 0 $B$10>=0 Binding 0
$C$10 Front Cargo2 0 $C$10>=0 Binding 0
$D$10 Front Cargo3 9.4 $D$10>=0 Not Binding 9.4
$E$10 Front Cargo 4 3.4 $E$10>=0 Not Binding 3.4
$B$11 Centre Cargo1 13.2 $B$11>=0 Not Binding 13.2
$C$11 Centre Cargo2 0 $C$11>=0 Binding 0
$D$11 Centre Cargo3 0 $D$11>=0 Binding 0
$E$11 Centre Cargo 4 6 $E$11>=0 Not Binding 6
$B$12 Back Cargo1 6.8 $B$12>=0 Not Binding 6.8
$C$12 Back Cargo2 0 $C$12>=0 Binding 0
$D$12 Back Cargo3 0.2666666667 $D$12>=0 Not Binding 0.266666667
$E$12 Back Cargo 4 3.6 $E$12>=0 Not Binding 3.6
hout Integer Constraints, Assume NonNegative
Microsoft Excel 14.0 Sensitivity Report
Worksheet: [Cargo.xlsx]Sheet1
Report Created: 11-May-18 2:32:30 AM

Variable Cells
Final Reduced Objective Allowable
Cell Name Value Cost Coefficient Increase
$B$10 Front Cargo1 0 0 320 0
$C$10 Front Cargo2 0 -20 400 20
$D$10 Front Cargo3 9.4 0 360 200
$E$10 Front Cargo 4 3.4 0 290 57.14285714
$B$11 Centre Cargo1 13.2 0 320 66.66666667
$C$11 Centre Cargo2 0 -20 400 20
$D$11 Centre Cargo3 0 0 360 0
$E$11 Centre Cargo 4 6 0 290 0
$B$12 Back Cargo1 6.8 0 320 0
$C$12 Back Cargo2 0 -20 400 20
$D$12 Back Cargo3 0.266666667 0 360 0
$E$12 Back Cargo 4 3.6 0 290 0

Constraints
Final Shadow Constraint Allowable
Cell Name Value Price R.H. Side Increase
$B$16 Individual compartment ratio 0 -3.0127E-12 0 0.222222222
$B$17 Individual compartment ratio 0 6.394885E-13 0 0.114285714
$F$10 Front 7000 0.6 7000 114.2857143
$F$11 Centre 9000 0.6 9000 960
$F$12 Back 5000 0.6 5000 685.7142857
$J$10 <= Weight of cargo 20 20 20 0.363636364
$J$11 <= Weight of cargo 0 0 16 1E+030
$J$12 <= Weight of cargo 9.666666667 0 25 1E+030
$J$13 Weight of cargo 13 50 13 0.571428571
 Allowable
Decrease
1E+030
1E+030
0
0
0
1E+030
1E+030
53.33333333
0
1E+030
0
0

Allowable
Decrease
0.015873016
0.044444444
1600
100
100
5.230769231
16
15.33333333
8
Microsoft Excel 14.0 Limits Report
Worksheet: [Cargo.xlsx]Sheet1
Report Created: 11-May-18 2:32:30 AM

Objective
Cell Name Value
$E$19 Max Profit Cargo 4 13650

Variable Lower Objective Upper Objective

Cell Name Value Limit Result Limit Result
$B$10 Front Cargo1 0 0 13650 0 13650
$C$10 Front Cargo2 0 0 13650 0 13650
$D$10 Front Cargo3 9.4 9.4 13650 9.4 13650
$E$10 Front Cargo 4 3.4 3.4 13650 3.4 13650
$B$11 Centre Cargo1 13.2 13.2 13650 13.2 13650
$C$11 Centre Cargo2 0 0 13650 0 13650
$D$11 Centre Cargo3 0 0 13650 0 13650
$E$11 Centre Cargo 4 6 6 13650 6 13650
$B$12 Back Cargo1 6.8 6.8 13650 6.8 13650
$C$12 Back Cargo2 0 0 13650 0 13650
$D$12 Back Cargo3 0.266666667 0.266666667 13650 0.266666667 13650
$E$12 Back Cargo 4 3.6 3.6 13650 3.6 13650
Microsoft Excel 14.0 Answer Report
Worksheet: [Cargo.xlsx]Sheet1
Report Created: 11-May-18 2:34:11 AM
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.031 Seconds.
Iterations: 8 Subproblems: 0
Solver Options
Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling
Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 0%

Objective Cell (Max)

Cell Name Original Value Final Value
$E$19 Max Profit Cargo 4 13650 13650

Variable Cells
Cell Name Original Value Final Value Integer
$B$10 Front Cargo1 0 0 Contin
$C$10 Front Cargo2 0 0 Contin
$D$10 Front Cargo3 9.4 9.4 Contin
$E$10 Front Cargo 4 3.4 3.4 Contin
$B$11 Centre Cargo1 13.2 13.2 Contin
$C$11 Centre Cargo2 0 0 Contin
$D$11 Centre Cargo3 0 0 Contin
$E$11 Centre Cargo 4 6 6 Contin
$B$12 Back Cargo1 6.8 6.8 Contin
$C$12 Back Cargo2 0 0 Contin
$D$12 Back Cargo3 0.2666666667 0.266666667 Contin
$E$12 Back Cargo 4 3.6 3.6 Contin

Constraints
Cell Name Cell Value Formula Status Slack
$B$16 Individual compartment ratio 0 $B$16=0 Binding 0
$B$17 Individual compartment ratio 0 $B$17=0 Binding 0
$F$10 Front 7000 $F$10<=7000 Binding 0
$F$11 Centre 9000 $F$11<=9000 Binding 0
$F$12 Back 5000 $F$12<=5000 Binding 0
$J$10 <= Weight of cargo 20 $J$10<=20 Binding 0
$J$11 <= Weight of cargo 0 $J$11<=16 Not Binding 16
$J$12 <= Weight of cargo 9.6666666667 $J$12<=25 Not Binding 15.33333333
$J$13 Weight of cargo 13 $J$13<=13 Binding 0
$B$10 Front Cargo1 0 $B$10>=0 Binding 0
$C$10 Front Cargo2 0 $C$10>=0 Binding 0
$D$10 Front Cargo3 9.4 $D$10>=0 Not Binding 9.4
$E$10 Front Cargo 4 3.4 $E$10>=0 Not Binding 3.4
$B$11 Centre Cargo1 13.2 $B$11>=0 Not Binding 13.2
$C$11 Centre Cargo2 0 $C$11>=0 Binding 0
$D$11 Centre Cargo3 0 $D$11>=0 Binding 0
$E$11 Centre Cargo 4 6 $E$11>=0 Not Binding 6
$B$12 Back Cargo1 6.8 $B$12>=0 Not Binding 6.8
$C$12 Back Cargo2 0 $C$12>=0 Binding 0
$D$12 Back Cargo3 0.2666666667 $D$12>=0 Not Binding 0.266666667
$E$12 Back Cargo 4 3.6 $E$12>=0 Not Binding 3.6
Microsoft Excel 14.0 Sensitivity Report
Worksheet: [Cargo.xlsx]Sheet1
Report Created: 11-May-18 2:34:11 AM

Variable Cells
Final Reduced Objective Allowable
Cell Name Value Cost Coefficient Increase
$B$10 Front Cargo1 0 0 320 0
$C$10 Front Cargo2 0 -20 400 20
$D$10 Front Cargo3 9.4 0 360 200
$E$10 Front Cargo 4 3.4 0 290 57.14285714
$B$11 Centre Cargo1 13.2 0 320 66.66666667
$C$11 Centre Cargo2 0 -20 400 20
$D$11 Centre Cargo3 0 0 360 0
$E$11 Centre Cargo 4 6 0 290 0
$B$12 Back Cargo1 6.8 0 320 0
$C$12 Back Cargo2 0 -20 400 20
$D$12 Back Cargo3 0.266666667 0 360 0
$E$12 Back Cargo 4 3.6 0 290 0

Constraints
Final Shadow Constraint Allowable
Cell Name Value Price R.H. Side Increase
$B$16 Individual compartment ratio 0 -3.0127E-12 0 0.222222222
$B$17 Individual compartment ratio 0 6.394885E-13 0 0.114285714
$F$10 Front 7000 0.6 7000 114.2857143
$F$11 Centre 9000 0.6 9000 960
$F$12 Back 5000 0.6 5000 685.7142857
$J$10 <= Weight of cargo 20 20 20 0.363636364
$J$11 <= Weight of cargo 0 0 16 1E+030
$J$12 <= Weight of cargo 9.666666667 0 25 1E+030
$J$13 Weight of cargo 13 50 13 0.571428571
 Allowable
Decrease
1E+030
1E+030
0
0
0
1E+030
1E+030
53.33333333
0
1E+030
0
0

Allowable
Decrease
0.015873016
0.044444444
1600
100
100
5.230769231
16
15.33333333
8
Microsoft Excel 14.0 Limits Report
Worksheet: [Cargo.xlsx]Sheet1
Report Created: 11-May-18 2:34:11 AM

Objective
Cell Name Value
$E$19 Max Profit Cargo 4 13650

Variable Lower Objective Upper Objective

Cell Name Value Limit Result Limit Result
$B$10 Front Cargo1 0 0 13650 0 13650
$C$10 Front Cargo2 0 0 13650 0 13650
$D$10 Front Cargo3 9.4 9.4 13650 9.4 13650
$E$10 Front Cargo 4 3.4 3.4 13650 3.4 13650
$B$11 Centre Cargo1 13.2 13.2 13650 13.2 13650
$C$11 Centre Cargo2 0 0 13650 0 13650
$D$11 Centre Cargo3 0 0 13650 0 13650
$E$11 Centre Cargo 4 6 6 13650 6 13650
$B$12 Back Cargo1 6.8 6.8 13650 6.8 13650
$C$12 Back Cargo2 0 0 13650 0 13650
$D$12 Back Cargo3 0.266666667 0.266666667 13650 0.266666667 13650
$E$12 Back Cargo 4 3.6 3.6 13650 3.6 13650
Microsoft Excel 14.0 Answer Report
Worksheet: [Cargo.xlsx]Sheet1
Report Created: 11-May-18 2:34:53 AM
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.032 Seconds.
Iterations: 8 Subproblems: 0
Solver Options
Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling
Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%

Objective Cell (Max)

Cell Name Original Value Final Value
$E$19 Max Profit Cargo 4 13650 13650

Variable Cells
Cell Name Original Value Final Value Integer
$B$10 Front Cargo1 0 0 Contin
$C$10 Front Cargo2 0 0 Contin
$D$10 Front Cargo3 9.4 9.4 Contin
$E$10 Front Cargo 4 3.4 3.4 Contin
$B$11 Centre Cargo1 13.2 13.2 Contin
$C$11 Centre Cargo2 0 0 Contin
$D$11 Centre Cargo3 0 0 Contin
$E$11 Centre Cargo 4 6 6 Contin
$B$12 Back Cargo1 6.8 6.8 Contin
$C$12 Back Cargo2 0 0 Contin
$D$12 Back Cargo3 0.2666666667 0.266666667 Contin
$E$12 Back Cargo 4 3.6 3.6 Contin

Constraints
Cell Name Cell Value Formula Status Slack
$B$16 Individual compartment ratio 0 $B$16=0 Binding 0
$B$17 Individual compartment ratio 0 $B$17=0 Binding 0
$F$10 Front 7000 $F$10<=7000 Binding 0
$F$11 Centre 9000 $F$11<=9000 Binding 0
$F$12 Back 5000 $F$12<=5000 Binding 0
$J$10 <= Weight of cargo 20 $J$10<=20 Binding 0
$J$11 <= Weight of cargo 0 $J$11<=16 Not Binding 16
$J$12 <= Weight of cargo 9.6666666667 $J$12<=25 Not Binding 15.33333333
$J$13 Weight of cargo 13 $J$13<=13 Binding 0
$B$10 Front Cargo1 0 $B$10>=0 Binding 0
$C$10 Front Cargo2 0 $C$10>=0 Binding 0
$D$10 Front Cargo3 9.4 $D$10>=0 Not Binding 9.4
$E$10 Front Cargo 4 3.4 $E$10>=0 Not Binding 3.4
$B$11 Centre Cargo1 13.2 $B$11>=0 Not Binding 13.2
$C$11 Centre Cargo2 0 $C$11>=0 Binding 0
$D$11 Centre Cargo3 0 $D$11>=0 Binding 0
$E$11 Centre Cargo 4 6 $E$11>=0 Not Binding 6
$B$12 Back Cargo1 6.8 $B$12>=0 Not Binding 6.8
$C$12 Back Cargo2 0 $C$12>=0 Binding 0
$D$12 Back Cargo3 0.2666666667 $D$12>=0 Not Binding 0.266666667
$E$12 Back Cargo 4 3.6 $E$12>=0 Not Binding 3.6
Microsoft Excel 14.0 Sensitivity Report
Worksheet: [Cargo.xlsx]Sheet1
Report Created: 11-May-18 2:34:53 AM

Variable Cells
Final Reduced Objective Allowable
Cell Name Value Cost Coefficient Increase
$B$10 Front Cargo1 0 0 320 0
$C$10 Front Cargo2 0 -20 400 20
$D$10 Front Cargo3 9.4 0 360 200
$E$10 Front Cargo 4 3.4 0 290 57.14285714
$B$11 Centre Cargo1 13.2 0 320 66.66666667
$C$11 Centre Cargo2 0 -20 400 20
$D$11 Centre Cargo3 0 0 360 0
$E$11 Centre Cargo 4 6 0 290 0
$B$12 Back Cargo1 6.8 0 320 0
$C$12 Back Cargo2 0 -20 400 20
$D$12 Back Cargo3 0.266666667 0 360 0
$E$12 Back Cargo 4 3.6 0 290 0

Constraints
Final Shadow Constraint Allowable
Cell Name Value Price R.H. Side Increase
$B$16 Individual compartment ratio 0 -3.0127E-12 0 0.222222222
$B$17 Individual compartment ratio 0 6.394885E-13 0 0.114285714
$F$10 Front 7000 0.6 7000 114.2857143
$F$11 Centre 9000 0.6 9000 960
$F$12 Back 5000 0.6 5000 685.7142857
$J$10 <= Weight of cargo 20 20 20 0.363636364
$J$11 <= Weight of cargo 0 0 16 1E+030
$J$12 <= Weight of cargo 9.666666667 0 25 1E+030
$J$13 Weight of cargo 13 50 13 0.571428571
 Allowable
Decrease
1E+030
1E+030
0
0
0
1E+030
1E+030
53.33333333
0
1E+030
0
0

Allowable
Decrease
0.015873016
0.044444444
1600
100
100
5.230769231
16
15.33333333
8
Microsoft Excel 14.0 Limits Report
Worksheet: [Cargo.xlsx]Sheet1
Report Created: 11-May-18 2:34:53 AM

Objective
Cell Name Value
$E$19 Max Profit Cargo 4 13650

Variable Lower Objective Upper Objective

Cell Name Value Limit Result Limit Result
$B$10 Front Cargo1 0 0 13650 0 13650
$C$10 Front Cargo2 0 0 13650 0 13650
$D$10 Front Cargo3 9.4 9.4 13650 9.4 13650
$E$10 Front Cargo 4 3.4 3.4 13650 3.4 13650
$B$11 Centre Cargo1 13.2 13.2 13650 13.2 13650
$C$11 Centre Cargo2 0 0 13650 0 13650
$D$11 Centre Cargo3 0 0 13650 0 13650
$E$11 Centre Cargo 4 6 6 13650 6 13650
$B$12 Back Cargo1 6.8 6.8 13650 6.8 13650
$C$12 Back Cargo2 0 0 13650 0 13650
$D$12 Back Cargo3 0.266666667 0.266666667 13650 0.266666667 13650
$E$12 Back Cargo 4 3.6 3.6 13650 3.6 13650
 Cargo Weight Volume Profit Compartment Weight Space
1 20 500 320 Front 12 7000
2 16 700 400 Centre 18 9000
3 25 600 360 Back 10 5000
4 13 400 290

Volume of compartment
Cargo1 Cargo2 Cargo3 Cargo 4
Front 0 0 9.4 3.4 7000 <= 7000
Centre 13.2 0 0 6 9000 <= 9000
Back 6.8 0 0.26666667 3.6 5000 <= 5000

Individual compartment ratio

0 = 0
0 = 0

Objective Function Max Profit 13650

 Weight of cargo
20 <= 20
0 <= 16
9.666667 <= 25
13 <= 13
42.66667