| |
|
|
|
Reduced |
Objective |
Allowable |
Allowable |
| |
Cell |
Name |
Value |
Cost |
Coefficient |
Increase |
Decrease |
| |
$B$20 |
SOLUTION X1:Maize |
31.27 |
0.00 |
58 |
169.6297923 |
21.16223288 |
| |
$C$20 |
SOLUTION X2:Soya beans |
30.52 |
0.00 |
150 |
202.4343262 |
75.0904473 |
| |
$D$20 |
SOLUTION X3:Wheat bran |
29.03 |
0.00 |
60 |
16.8971673 |
116.1742835 |
| |
$E$20 |
SOLUTION X4:Oyster shell |
8.36 |
0.00 |
15 |
31.73785688 |
3832.568681 |
| |
$F$20 |
SOLUTION X5:Bone meal |
0.00 |
57.34 |
50 |
1E+30 |
57.34035672 |
| |
$G$20 |
SOLUTION X6:Salt |
0.30 |
0.00 |
90 |
1E+30 |
1E+30 |
| |
$H$20 |
SOLUTION X7:Lysine |
0.16 |
0.00 |
700 |
3650.304956 |
448.1822994 |
| |
$I$20 |
SOLUTION X8:Methionine |
0.06 |
0.00 |
1300 |
120829.4719 |
1067.903732 |
| |
$J$20 |
SOLUTION X9:Premix |
0.30 |
0.00 |
550 |
1E+30 |
1E+30 |
| Constraints |
|
|
|
|
|
| |
|
|
Final |
Shadow |
Constraint |
Allowable |
Allowable |
| |
Cell |
Name |
Value |
Price |
R.H. Side |
Increase |
Decrease |
| |
$K$8 |
DEMAND LHS |
100 |
42.59691125 |
100 |
22.04010174 |
20.13307524 |
| |
$K$9 |
SALT LHS |
0.3 |
47.40308875 |
0.3 |
20.13307524 |
0.3 |
| |
$K$10 |
PREMIX LHS |
0.3 |
507.4030888 |
0.3 |
20.13307524 |
0.3 |
| |
$K$11 |
CALCIUM LHS |
1.86 |
-131.4138631 |
1.86 |
4.227945799 |
1.554450857 |
| |
$K$12 |
FATS LHS |
2.319015507 |
0 |
3.55 |
1E+30 |
1.230984493 |
| |
$K$13 |
CRUDE FIBRE LHS |
4.09 |
-760.5812226 |
4.09 |
0.856886702 |
0.645018371 |
| |
$K$14 |
PHOSPHATE LHS |
1.969306265 |
0 |
0.58 |
1.389306265 |
1E+30 |
| |
$K$15 |
LYSINE LHS |
1.26 |
469.7115319 |
1.26 |
11.2924083 |
0.148780339 |
| |
$K$16 |
METHIONINE LHS |
0.42 |
1069.711532 |
0.42 |
11.2924083 |
0.06159284 |
| |
$K$17 |
MET. ENERGY LHS |
213122.3821 |
0 |
2826.39 |
210295.9921 |
1E+30 |
| |
$K$18 |
CRUDE PROT. LHS |
20.87 |
312.8192614 |
20.87 |
1.81952375 |
7.326496438 |
|
