Phosphoric
acid
Urea
Ammonium
phosphate
Ammonium
nitrate
Chlorine
Caustic
soda
Vinyl
chloride
Hydroflouric
acid
Max chlorine 1 480.00 <= 480
Max caustic soda 1 600.00 <= 600
Max vinyl chloride 1 300.00 <= 300
Max hydro acid 1 320.00 <= 320
Case: Coastal States Chemicals and Fertilizers (0%)
Max phos acid 1 320.00 <= 320
Max urea 1 200.00 <= 200
Max amm phos 1 270.00 <= 270
Max amm nitr 1 300.00 <= 300
Phosphoric
acid
Urea
Ammonium
phosphate
Ammonium
nitrate
Chlorine
Caustic
soda
Vinyl
chloride
Hydroflouric
acid
Max chlorine 1 480.00 <= 480
Max caustic soda 1 385.00 <= 600
Max vinyl chloride 1 300.00 <= 300
Max hydro acid 1 320.00 <= 320
Case: Coastal States Chemicals and Fertilizers (20%)
Max phos acid 1 320.00 <= 320
Max urea 1 200.00 <= 200
Max amm phos 1 270.00 <= 270
Max amm nitr 1 300.00 <= 300
Phosphoric
acid
Urea
Ammonium
phosphate
Ammonium
nitrate
Chlorine
Caustic
soda
Vinyl
chloride
Hydroflouric
acid
Max amm nitr 1 300.00 <= 300
Max chlorine 1 410.67 <= 480
Max caustic soda 1 0.00 <= 600
Max vinyl chloride 1 300.00 <= 300
Max hydro acid 1 320.00 <= 320
Case: Coastal States Chemicals and Fertilizers (40%)
Max phos acid 1 320.00 <= 320
Max urea 1 200.00 <= 200
Max amm phos 1 270.00 <= 270
Worksheet: [P4-Coastal States.xls]20%
Adjustable Cells
Final Reduced Objective Allowable Allowable Decr in New
Cell Name Value Cost Coefficient Increase Decrease OFC Ratio OFC
Constraints
Final Shadow Constraint Allowable Allowable Change New
Cell Name Value Price R.H. Side Increase Decrease in RHS Ratio RHS
$J$5 Max phos acid 320.000 42.813 320 1120.000 320.000 80.00 0.071 400
$J$6 Max urea 200.000 58.125 200 880.000 200.000 50.00 0.057 250
Microsoft Excel 10.0 Sensitivity Report
Worksheet: [P4-Coastal States.xls]40%
Adjustable Cells
Final Reduced Objective Allowable Allowable Decr in New
Cell Name Value Cost Coefficient Increase Decrease OFC Ratio OFC
$B$2 Number of tons Phosphoric acid 320.000 0.000 60 1E+30 41.667 2.10 0.050 57.90
Cell Name Value Price R.H. Side Increase Decrease in RHS Ratio RHS
$J$5 Max phos acid 320.000 41.667 320 1120.000 189.091 80.00 0.071 400
$J$6 Max urea 200.000 56.667 200 880.000 148.571 50.00 0.057 250
$J$7 Max amm phos 270.000 63.333 270 770.000 130.000 30.00 0.039 300
Microsoft Excel 10.0 Sensitivity Report