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
13.88
0
4000
500
1600
$B$2
Solvent base
25.71
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 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

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!