HW DUE FE 21.xlsx - Microsoft Excel 15.16 Sensitivity Report Worksheet[Workbook5]Sheet1 Report Created 10:38:22 PM Variable Cells Final Reduced

HW DUE FE 21.xlsx - Microsoft Excel 15.16 Sensitivity...

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

Microsoft Excel 15.16 Sensitivity Report Worksheet: [Workbook5.xlsx]Sheet1 Report Created: 2/20/2019 10:38:22 PM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$2 X1 200 0 2 2 2 $D$2 X2 300 0 3 2 1.00E+030 $E$2 X3 0 2 5 1.00E+030 2 $F$2 Y1 100 0 9 2 2 $G$2 Y2 0 2 12 1.00E+030 2 $H$2 Y3 300 0 10 2 1.00E+030 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $D$12 LHS 500 -7 500 100 0 $D$13 LHS 400 0 400 1.00E+030 0 $D$14 LHS 300 9 300 0 100 $D$15 LHS 300 10 300 0 100 $D$16 LHS 300 10 300 0 300
Image of page 1
Microsoft Excel 15.16 Answer Report Worksheet: [Workbook5.xlsx]Sheet1 Report Created: 2/20/2019 10:38:38 PM Result: Solver found a solution. All constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.367974 Seconds. Iterations: 6 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 NonNegative Objective Cell (Min) Cell Name
Image of page 2
Image of page 3
Image of page 4
Image of page 5

You've reached the end of your free preview.

Want to read all 5 pages?

  • Spring '14
  • Management, Variable Cells, Max Integer Sols Unlimited, Iterations Unlimited

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture