Chapter 4 Tarmac Chemical Corporation Excel Answer With Sensitivity Report - Microsoft Excel 14.0 Sensitivity Report Worksheet[Chapter 3 Problem 17

Chapter 4 Tarmac Chemical Corporation Excel Answer With Sensitivity Report

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

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
Image of page 1
Allowable
Image of page 2
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 4 pages?

  • Fall '08
  • STAFF
  • Chemical element, AirTrain Newark, LHS)

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture