Chapter 3 Problem 33 in 7th ed, Problem 32 in 6th ed - Excel - answer - Microsoft Excel 14.0 Sensitivity Report Worksheet[Chapter 3 homework problem 32

Chapter 3 Problem 33 in 7th ed, Problem 32 in 6th ed - Excel - answer

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

Microsoft Excel 14.0 Sensitivity Report Worksheet: [Chapter 3 homework problem 32 - Excel - answer.xlsx]Sheet1 Report Created: 11/7/2011 4:32:49 PM Engine: Gurobi Solver Objective Cell (Min) Cell Name Final Value $B$25 Min total cost: X13 702 Decision Variable Cells Final Reduced Objective Allowable Cell Name Value Cost Coefficient Increase $B$23 Units produced: X13 0 31 54 1.00E+100 $C$23 Units produced: X14 10 0 17 5 $D$23 Units produced: X15 0 5 23 1.00E+100 $E$23 Units produced: X16 5 0 30 0 $F$23 Units produced: X23 8 0 24 7 $G$23 Units produced: X24 0 0 18 0 $H$23 Units produced: X25 10 0 19 5 $I$23 Units produced: X26 0 0 31 1.00E+100 Constraints Final Shadow Constraint Allowable Cell Name Value Price R.H. Side Increase $B$28 Surplus location 1 Amount Used (LHS) 15 23 15 0 $B$29 Surplus location 2 Amount Used (LHS) 18 24 18 2 $B$30 Min needed location 3 Amount Used (LHS) 8 0 5 3 $B$31 Min needed location 4 Amount Used (LHS) 10 0 5 5 $B$32 Min needed location 5 Amount Used (LHS) 10 0 5 5 $B$33 Min needed location 6 Amount Used (LHS) 5 7 5 3 $B$34 Max needed location 3 Amount Used (LHS) 8 0 10 1.00E+100 $B$35
Image of page 1
Image of page 2

You've reached the end of your free preview.

Want to read all 5 pages?

  • Fall '08
  • STAFF
  • LHS)

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture