A linear programming model is given as follows:

Minimize = 5.21 + 2.52 + 6.03

Subject to 31 + 22 + 23 200

1/ 1 + 2 + 3 0.4

2 + 3 /21 0.2

1 2 + 3

1, 2, 3 0

(a) Solve the problem by using the computer (MS excel). What are the minimum Z and the optimal point?

(b) Obtain the values of the slack/surplus variables at the optimal solution in (a)

(b) Identify the sensitivity range of the objective function coefficient of 2.

(c) Identify the sensitivity range of the value of the 1st resource constraint (right-hand side).

(d) Identify the sensitivity range of the value of the 3 rd resource constraint (right-hand side).

(e) which of the following makes the model infeasible?

(Choose one)

i. Increase of the coefficient of 1 on the objective function to 2000

ii. Decrease of the coefficient of 1 on the 1 st constraint to -5

iii. Addition of a new constraint, 1 + 22 + 33 100

iv. Removal of the non-negativity constraints for 1, 2, 3

v. None