Binding I17 LHS 300 I17K17 Not Binding 100 I18 LHS 600 I18K18 Binding I5 LHS

Binding i17 lhs 300 i17k17 not binding 100 i18 lhs

This preview shows page 1 - 5 out of 5 pages.

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

You've reached the end of your free preview.

Want to read all 5 pages?

• Fall '05
• EL
• LHS, BMW Sports Activity Series, BMW X5