Excels Solver tool has been used in the spreadsheet below to

Excel\'s Solver tool has been used in the spreadsheet below to solve a linear programming problem with a maximization objective function and all

Solution

SOl)

Problem is

Entering =X2, Departing =S1, Key Element = 5

R1 (new) =R1 (old) ÷5=R1 (old) 1/5

R2 (new) =R2 (old) 2R1 (new)

R3 (new) =R3 (old) R1(new)

Entering =X1, Departing =S2, Key Element = 9/5

R2 (new) =R2 (old) ÷9/5=R2 (old) 5/9

R1 (new) =R1 (old) 3/5R2 (new)

R3 (new) =R3 (old) 2/5R2 (new)

Since all CjZj0,

Optimum Solution is arrived with value of variables as :
X1=40/3

X2=4

Maximise Z=232/3

MAX Z= 4 X1+ 6 X2

Subject to constraints

3 X1+ 5 X2 60 3 X1+ 2 X2 48 1 X1+ 1 X2 20

and X1,X20