Chapter 4 Sensitivity Handout Homework Problem 1 Answer With Sensitivty report - Microsoft Excel 14.0 Sensitivity Report Worksheet[Chapter 4 Sensitivity

Chapter 4 Sensitivity Handout Homework Problem 1 Answer With Sensitivty report

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

Microsoft Excel 14.0 Sensitivity Report Worksheet: [Chapter 4 Sensitivity Handout Homework problem 1 - Excel.xls]Sheet1 Report Created: 10/31/2011 10:30:24 PM Engine: Gurobi Solver Objective Cell (Max) Cell Name Final Value $B$19 Max Obj Value: X1 1900 Decision Variable Cells Final Reduced Objective Allowable Cell Name Value Cost Coefficient Increase $B$17 Units produced X1 100 0 3 1 $C$17 Units produced X2 200 0 8 1.00000E+100 Constraints Final Shadow Constraint Allowable Cell Name Value Price R.H. Side Increase $B$22 Resource 1 Amount Used (LHS) 1000 1.5 1000 66.666666667 $B$23 Resource 2 Amount Used (LHS)
Image of page 1
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 3 pages?

  • Fall '08
  • STAFF
  • Constraint satisfaction, R.H. Side, Max Obj Value

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture