Connection 91 Se BA Data Analysis Organization Sie Sort 4 Filter apply Adance Set Solver Parameters Column mections Data Types Sortie De Ses Objective Sass Objective funtion Ma OMO O value A C D E G X Changing Variabel 4 ST FM Objective funtion ISLAM 0 0 17 x Y Z Sy to the Contrat 6 1 g 9 Add Optimal values Change Sign 10 11 X 1 Y 4 1 3 Coufficients on Constraints Constraint 1 Constraint 2 Constraints Constraint 4 Constraints Constanti z 2 2 2 RHS 60 20 361 12 13 14 Grie s 3 2 1 1 o 0 1 2 15 16 0 1 0 2 0 Mented Vaata Select Suvi GASNE Me 18 RS on Method Cred the course the Sule engine istina Salome theater Botha 19 GD Conants as Excel formulas Constant 1 Constraint 2 Iconstant Iconstraint 4 21 22 90 C ol Maximize 1 O PI here lo search op AG 230 Fall 2020 7 6 2 3 Lab 10: Applications of Excel Solver In this in, you will solve two optimization problems using the Saver din in Excel. Please use the Excel werkbook nad Lab 10 to ove the problems Save the workbook as Lab10_Lastnameriratnama. 1. In the worksheet named Maximize, use the Solver add to maximum the following objective function F with X, wd wwe decisione variable and find optimal solutions Monize the objective function: F-2X + + Subject to constraints Constraint I: 3x + 47 22 500 constraint 2: 2x + y + 2 = 10 Constraint 3: x + 3y + 2x