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