Below is a summary of the sensitivity analysis report. Pleas…
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 additive 17.85714286 0 4000 500 1600 $B$2 Solvent base 25.71428571 0 3000 2000 333.3333333 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $B$9 Raw material A LHS 20 1428 20 2.1 2.5 $B$10 Raw materialB LHS 2.57 5 1E+30 2.42 $B$11 Raw materialC LHS 21 5555 21 2 3.25 $B$12 Fuel LHS 17.85 0 25 1E+30 7.14 $B$13 Solvent LHS 25.71 0 35 1E+30 9.28 Suppose there are two tons of Raw Material C available for purchase at the price of $4,000 per ton. What will be the net change in the profit for the model (including the new cost) if all two tons are purchased?
Read Details