Question

QUESTION 2 Solve the following optimization model using Excel Solver. Upload the final excel file. max z=18x1+25x2+21x3 S.t 16x2+21x32400 3x1 +8x32 150 11x25 1000 3x1+4x2+5x35 290 X1,x2,X320, and integer

Answer 1

First Type as below in the Excel, all the formulae:

D B B С D 1 x1 x2 x3 2 3 Max Z= 4 =18*B2+25*C2+21*D 5 S.t 6 7 >= 400 150 =16*C2+21*D2 =3*B2+8*D2 =11*C2 =3*B2+4*C2+5*D2 <%3D 8 9 1000 290 <=

Now, go to the Data tab, under the data tab select Solver, and make all the constraints and other values exactly same as below:

Solver Parameters х Set Objective: SBS31 To: Min Max 0 O Value of: By Changing Variable Cells: $B$2:$D$2 Subject to the Constraints: SBS6 >= $D$6 SBS7 >= SD$7 $B$8 <= $D$8 $B$9 <= $D$9 Add Change Delete Reset All Load/Save Make Unconstrained Variables Non-Negative Select a Solving Method: Simplex LP Options Solving Method Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are non-smooth. Help Solve Close

After clicking Solve, you'll get the following results:

A B с D x1 x2 x3 1 2 2 50 35 0 1775 3 Max Z = 4 5 S.t 6 560 >= 400 7 150 >= 150 8 385 <= 1000 9 290 <%3D 290

	x1	x2	x3
	50	35	0
Max Z =	1775
S.t
	560	>=	400
	150	>=	150
	385	<=	1000
	290	<=	290

PLEASE HELP ME BY LIKING THIS ANSWER. THANK YOU VERY MUCH FOR THE LIKE!