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 3xı+8x32150 11x25 1000 3x1+4x2+5x35290 X 1 X 2,X320, and integer

Answer 1

N 1245 Max x1 X2 x3 5 0 55 400 1155 455 0 450 1000 s.t 1 s.t 2 s.t 3 s.t 4 s.t 5 s.t 6 s.t_7 290 290 5 0 0 0 55 0

Solver Parameters X Set Objective: $B$11 MA To: Max Min O Value of: 0 er 2 By Changing Variable Cells: SAS3:$C$3 Add Subject to the Constraints: SA$3:$C$3 = integer $B$4 >= $D$4 SBS5 >= SD$5 SBS6 <= SD$6 SBS7 <= $D$7 SB$8:$B$10 >= SD$8 Change Delete Reset All Load/Save Make Unconstrained variables Non-Negative Select a Solving Method: GRG Nonlinear 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

PS: If your excel does not have solver, you will have to install Add in for getting solver.

Upvote the answer.