Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price

Constraints final shadow constraint allowable

This preview shows page 3 - 8 out of 8 pages.

Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $C$17 LHS 900 125 900 1E+030 800 $C$18 LHS 100 -25 100 800 100 $C$19 LHS 800 0 0 800 1E+030
X1 X2 Z 100 800 110000 LHS RHS 900 900 100 100 800 0
Microsoft Excel 16.0 Answer Report Worksheet: [Sensitivity.xlsx]Sheet4 Report Created: 10/22/2019 7:49:16 PM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.125 Seconds. Iterations: 2 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 NonNegativ Objective Cell (Min) Cell Name Original Value Final Value $F$8 Z 82000 81000 Variable Cells Cell Name Original Value Final Value Integer $D$8 X1 100 0 Contin $E$8 X2 800 900 Contin Constraints Cell Name Cell Value Formula Status Slack $D$17 LHS 900 $D$17>=$E$17 Binding 0 $D$18 LHS 0 $D$18<=$E$18 Not Binding 100 $D$19 LHS 900 $D$19>=$E$19 Not Binding 900
ve
Microsoft Excel 16.0 Sensitivity Report Worksheet: [Sensitivity.xlsx]Sheet4 Report Created: 10/22/2019 7:49:51 PM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $D$8 X1 0 10 100 1E+030 10 $E$8 X2 900 0 90 10 90 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $D$17 LHS 900 90 900 1E+030 900 $D$18 LHS 0 0 100 1E+030 100 $D$19 LHS 900 0 0 900 1E+030
X1 X2 Z 0 900 81000 LHS RHS 900 900 0 100 900 0

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture