Question: Below is a summary of the sensitivity analysis report. Please answer the following questions from the table. Adjustable Cells Final Reduced Objective Allowable Allowable Cell

Below is a summary of the sensitivity analysis report. Please answer the following questions from the table.
Adjustable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$A$2
Fuel 13.880,0,4000,500
additive
$B$2
Solvent
base
25.710
3000
2000
333.3333333
Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
Raw
$B$9 material 20,1428,20,2.1,2.5
A LHS
Raw
$B$10 materialB 2.57,5,1E+30,2.42
LHS
Raw
$B $11 materialC 21,5555,21,2,3.25
LHS
$B$12 Fuel LHS17.85,0,25,1E+30,7.14
Suppose the market for Solvent Base drives the price down by $700 per ton later on in the month. Are the production quantities still optimal?
Yes
No
 Below is a summary of the sensitivity analysis report. Please answer

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!