Microsoft Excel Sensitivity Report

Adjustable Cells

Final

Reduced

Objective

Allowable

Allowable

Cell

Name

Value

Cost

Coefficient

Increase

Decrease

$C$4

Value: X1

12

0

2

1.00E+30

0

$D$4

Value: X2

0

0

4

0

1.00E+30

Constraints

Final

Shadow

Constraint

Allowable

Allowable

Cell

Name

Value

Price

R.H. Side

Increase

Decrease

$E$10

Used:

12

0

2

10

1.00E+30

$E$8

Used:

-12

0

8

1.00E+30

20

$E$9

Used:

12

2

12

1.00E+30

10

Is the optimal solution to this problem unique?

[Without resolving the model] can you tell what will be the optimal solution to this problem if the vaue of the objective function coefficient for variable X1 is zero?

How much can the objective function coefficient for variable X2 decrease before changing the optimal solution?

Given that this is a maximization problem, if management could increase the RHS value for any of the constraints for identical costs, which would you choose to increase and why?