Chapter 4 Tarmac Chemical Corporation Excel Answer With Sensitivity Report

Microsoft Excel 14.0 Sensitivity Report
Worksheet: [Chapter 3 Problem 17 Excel Answer With Sensitivity Report.xlsx]Sheet1
Report Created: 10/27/2011 10:55:40 AM
Engine: Gurobi Solver
Objective Cell (Min)
Cell Name Final Value
$B$20 Min total cost: P1 5.1785714286
Decision Variable Cells
Final Reduced Objective Allowable
Cell Name Value Cost Coefficient Increase
$B$18 Proportion each comp.: P1 57.14% 0.00% 5 0.125
$C$18 Proportion each comp.: P2 14.29% 0.00% 5.25 1.0000E+100
$D$18 Proportion each comp.: P3 28.57% 0.00% 5.5 0.25
Constraints
Final Shadow Constraint Allowable
Cell Name Value Price R.H. Side Increase
$B$23 > 20% sulfur Amount Used (LHS) .20 .36 0.2 0.2
$B$24 > 30% iron oxide Amount Used (LHS) .50 .00 0.3 0.2
$B$25 > 30% potassium Amount Used (LHS) .30 1.79 0.3 0.1333333333
$B$26 < 30% potassium Amount Used (LHS) .30 .00 0.45 1.0000E+100
$B$27 SProportion = 1 Amount Used (LHS) 1 4.5714285714 1 0.125

Allowable