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

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!