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

Chapter 4 Sensitivity Handout Homework Problem 3 Answer With Sensitivity report

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

Microsoft Excel 14.0 Sensitivity Report Worksheet: [Chapter 4 Sensitivity Handout Homework problem 3 - Excel.xls]Sheet1 Report Created: 10/31/2011 10:48:14 PM Engine: Gurobi Solver Objective Cell (Max) Cell Name Final Value $B$21 Max Obj Value: Mixed fruit 176 Decision Variable Cells Final Reduced Objective Allowable Cell Name Value Cost Coefficient Increase $B$19 Lots produced Mixed fruit 8 0 10 2 $C$19 Lots produced Fruit cocktail 16 0 6 14 $D$19 Lots produced Fruit delight 0 -0.5333333333 8 0.5333333333 Constraints Final Shadow Constraint Allowable Cell Name Value Price R.H. Side Increase $B$24 Pears, lb Amount Used (LHS) 320 0.4666666667 320 80 $B$25 Peaches, lb Amount Used (LHS) 400 0.0666666667 400 30 $B$26 Mixing, hr Amount Used (LHS) 40 0 43 1.00000E+100 $B$27 Canning, hr Amount Used (LHS) 24 0 60 1.00000E+100
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
  • Harshad number, Constraint satisfaction, Peaches, LHS), Max Obj Value

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture