Question

For the given LP formulation, find the optimal solution using excel solver. Max(Z) = 2000X1 + 1700X2 + 1200X3 Constraints : X1 + X2 + X3 <= 12 25X1 + 20X2 + 19X3 <= 280 X1,X2,X3 >= 0

Answer 1

Answer:

Excel Solver gives the following solution:

$X_1=8,\,\,X_2=4\,\,X_3=0$

Step-by-step explanation:

The objetive function, that is intended to maximize is

$Z=2000X_1+1700X_2+1200X_3$

The constraints of the LP problem are:

$X_1 + X_2 + X_3 <= 12\\\\25X_1 + 20X_2 + 19X_3 <= 280\\\\ X_1,X_2,X_3 >= 0$

Excel Solver gives the following solution:

$X_1=8,\,\,X_2=4\,\,X_3=0$

The attached picture gives the configuration used for solver to solve this LP formulation.