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 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?
Group of answer choices
3110
3000
3100
3005
2)
Suppose the market for Fuel Additive drives the price down by $ 500 per ton later on in the month.
If the price change occurs before any sales are completed what will the difference in profit be
Group of answer choices
6940
7000
6531
7685
3)
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?
Group of answer choices
Yes
No
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
