Question 2 (23 marks)

The sensitivity report of a particular liner programming problem. (profit maximization) is given as follows:

Adjustable cells

Cell Name Final Reduced Objective Allowable Allowable

Value Cost Coefficient Increase Decrease

$C$13 PaintA 3 0 5 1 3

$D$13 PaintB 1.5 0 4 6 0.6666667

Constraints

Cell Name Final Shadow Constraint Allowable Allowable

Value Price R.H. Side Increase Decrease

$E$7 Raw Material X 24 0.75 24 12 4

$E$8 Raw Material Y 6 0.5 6 0.6666667 2

$E$9 Demand S -1.5 0 1 1E+30 2.5

$E$10 Demand T 1.5 0 2 1E+30 0.5

A) Regarding the liner programming problem, what is the optimal solution? (6 marks)

B) Suppose that the right-hand-side value of "Raw Material X" changes to 32, what can be said about the effect on the effect on the total profit? (7 marks)

C) Suppose that the unit profit of "Paint A " and "Paint B" both decrease by 0.6, would the optimal solution change? If not, what is the revised optimal profit that can be earned? (10 marks)