For the given LP formulation, nd the optimal solution using excel solver. Max(Z) = 5X1 + 8X2 Constraints : 2X1 + 4X2 = 0 (a)

For the given LP formulation, nd the optimal solution using excel solver. Max(Z) = 5X1 + 8X2

Constraints :

2X1 + 4X2 <= 40

6X1 + 3X2 <= 42

X1 >= 3

X1,X2 >= 0 (a) Insert below a screenshot of the excel solver with nal answers in it.

(b) Write clearly which constraints are binding and which are non binding.

(c) How much change can we make in the rst constraint without changing the optimal solution for Z.

(d) (2 points) Can we increase the right hand side value of the constraint (X1 >= 3) to 5 to obtain the same optimal value of Z? Give reason for your answer?