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...

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
Image of page 1
e
Image of page 2
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
Image of page 3
Image of page 4

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture