Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price

# Constraints final shadow constraint allowable

• 8

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