Binding i17 lhs 300 i17k17 not binding 100 i18 lhs

Binding 0
$I$17 LHS 300 $I$17>=$K$17 Not Binding 100
$I$18 LHS 600 $I$18>=$K$18 Binding 0
$I$5 LHS 500 $I$5=$K$5 Binding 0
$I$6 LHS 400 $I$6<=$K$6 Binding 0
$I$7 LHS 0 $I$7<=$K$7 Not Binding 300
$I$8 LHS 39.7763019923 $I$8<=$K$8 Not Binding 560.22369801
$I$9 LHS 0 $I$9<=$K$9 Not Binding 500

onNegative

Microsoft Excel 14.5 Sensitivity Report
Worksheet: [Mineral Question.xlsx]Sheet1
Report Created: -09-29 11:56:12 AM
Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$3 Weight x1 400 0 200 4.494931842 1.00000E+030
$C$3 Weight x2 0 66.3718979378 250 1.00000E+030 66.371897938
$D$3 Weight x3 39.776301992 0 150 15.130117974 1.00000E+030
$E$3 Weight x4 0 42.111149948 220 1.00000E+030 142.11114995
$F$3 Weight x5 2.7612722824 0 240 76.666666667 17262.727273
$G$3 Weight x6 57.462425725 0 200 97.680041152 4.0952153491
$H$3 Weight x7 0 15.2411744145 165 1.00000E+030 15.241174415
Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$I$10 LHS 2.7612722824 0 200 1.00000E+030 197.23872772
$I$11 LHS 57.462425725 0 300 1.00000E+030 242.53757427
$I$12 LHS 0 0 250 1.00000E+030 250
$I$13 LHS 1000 0 1500 1.00000E+030 500
$I$14 LHS 300 -0.8039147151 300 1644 100
$I$15 LHS 600 0 825 1.00000E+030 225
$I$16 LHS 1000 0 1000 7.10543E-014 1.00000E+030
$I$17 LHS 300 0 200 100 1.00000E+030
$I$18 LHS 600 41.7336595596 600 47.615062762 68.714733542
$I$5 LHS 500 50.241174415 500 564.36619718 40.070422535
$I$6 LHS 400 -4.494931842 400 52.352519704 2.84217E-014
$I$7 LHS 0 0 300 1.00000E+030 300
$I$8 LHS 39.776301992 0 600 1.00000E+030 560.22369801
$I$9 LHS 0 0 500 1.00000E+030 500

x1 x2 x3 x4 x5 x6
Unit Cost 200 250 150 220 240 200
Weight 400 0 39.776302 0 2.76127228 57.4624257
1 1 1 1 1 1
1
1
1
1
1
1
2.5 3
0.3 90 96 0.4
1.3 0.8 4 1.2
2.5 3
0.3 90 96 0.4
1.3 0.8 4 1.2

x7
165 Total
0 98121.6358
LHS RHS
1 500 = 500
400 <= 400
0 <= 300
39.776302 <= 600
0 <= 500
2.76127228 <= 200
57.4624257 <= 300
1 0 <= 250
1000 <= 1500 3 500
0.6 300 <= 300 0.6 500
600 <= 825 1.65 500
1000 >= 1000 2 500
0.6 300 >= 200 0.4 500
600 >= 600 1.2 500