Sensitivity.xlsx - Microsoft Excel 16.0 Answer Report Worksheet[Sensitivity]Sheet1 Report Created 7:45:00 PM Result Solver found a solution All

# Sensitivity.xlsx - Microsoft Excel 16.0 Answer Report...

• 8

This preview shows page 1 - 4 out of 8 pages.

Microsoft Excel 16.0 Answer Report Worksheet: [Sensitivity.xlsx]Sheet1 Report Created: 10/22/2019 7:45:00 PM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.125 Seconds. Iterations: 3 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.001, Use Automatic Scaling Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative Objective Cell (Min) Cell Name Original Value Final Value \$E\$8 Z 225 110000 Variable Cells Cell Name Original Value Final Value Integer \$C\$8 X1 1 100 Contin \$D\$8 X2 1 800 Contin Constraints Cell Name Cell Value Formula Status Slack \$C\$17 LHS 900 \$C\$17>=\$D\$17 Binding 0 \$C\$18 LHS 100 \$C\$18<=\$D\$18 Binding 0 \$C\$19 LHS 800 \$C\$19>=0 Not Binding 800
e
Microsoft Excel 16.0 Sensitivity Report Worksheet: [Sensitivity.xlsx]Sheet1 Report Created: 10/22/2019 7:46:28 PM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease \$C\$8 X1 100 0 100 25 1E+030 \$D\$8 X2 800 0 125 1E+030 25