Question

Solve the following optimization model using Excel Solver. Upload the final excel file. max z=18x1+25x2+21x3 Sot 16x2+21x32400 3xı +8x32 150 11x25 1000 3x1+4x2+5x35290 X1,x2,X320, and integer

Answer 1

so se a E E É A E question - Excel Sign in Review View StatFi Help Power Pivot Tell me what you want to do 2. Share Flash Fill - Consolidate Group Data Analysis NM File Home Insert Page Layout Formulas Data Show Queries O Connections Get External From Table E Properties New Refresh Data Query- Do Recent Sources All Edit Links Get & Transform Connections -= 21 A2 Sort Clear Reapply Advanced 2 Solver Filter Text to Solver Parameters х Colum Sort & Filter Analyze Set Objective: SGST 1 G7 To: B с 0 D A E F G H O Max O Min O Value of: J - T U 1 X_1 2 3 x2 50 X3 35 By Changing Variable Cells: $D$3:$F$3 Variables 0 4 5 Add X_1 X_2 X_3 6 7 8 Objective functions TOTAL/MAXIMUM -------------- 211 1775 Subject to the Constraints: $D$3 > 0 SES3 > 0 SF$3 >= 0 SG$10 >= 400 SGS11 >= 150 SGS12 <= 1000 SG$13 <= 290 18 25 Change 9 Used Delete 0 16 21 10 11 0 8 Constraint 1 Constraint 2 Constraint 3 Constraint 4 Reset All 3 0 Available 400 150 1000 290 560 150 385 290 11 0 12 13 3 4 5 Load/Save Make Unconstrained variables Non-Negative 14 15 16 Select a Solving Method: Simplex LP Options Lower bounds for x 0 0 0 17 18 19 20 21 22 23 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 Sheet1 Point + 10

S. question - Excel Drawing Tools Sign in x File Home Insert Page Layout Formulas Data Review View StatFi Help Power Pivot Format Tell me what you want to do AutoSum X Cut LE Copy 4 Share A O VI A ab Wrap Text General aste BIU A E Merge & Center 6. % Insert Delete Format Format Painter Clear Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Editing Clipboard Font Alignment Number Cells bject 1 X fox =EMBED("Equation.DSMT4","") A B C D E F Н. 1 K L M N O P a R S T Ս X_1 X_3 O X_2 50 Variables 35 0 X_1 X_2 X_3 Objective functions TOTAL/MAXIMUM 21 1775 18 25 Used Max z = 18x, + 25x2 +21xz s.t. 16x2 +21xz 2 400 3x, +8.xz 2150 11x2 < 1000 03.xz + 4x2 + 5xz 3 290 X3, X2, X3 20 Maximum value is 1775 x2 = 50 , x2 = 35 , xz = 0 0 Constraint 1 Constraint 2 Constraint 3 Constraint 4 3 16 0 11 Available 400 150 1000 21 8 0 560 150 385 290 0 3 4 5 290 Lower bounds for x 0 0 0
pplease it is not possible to upload a file here, but I tried showing my Solutions how I did it in the first picture, then the second picture show the complete Solutions, please feel free to ask questions, thank you.