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

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