Define the Feasible Region. Use the constraints (inequalities) to bound the feasible region. For constraints with the into equations by form “ax1+bx2≤C”, convert them dropping the or symbol and adding the as “≤” “≥” equal sign “=”, such “ax1+bx2=C”. Then solve the equation for x1=0 to obtain the point where the linear equation crosses the x1 axis. Similarly, solve for x2=0 to obtain the point where the linear equation cross the x2 axis. Obtain the vertices of the feasible region. Do this by identifying the points in the feasible region and, for the constraints with the into equations form “ax1+bx2≤C”, convert them and obtain the value of the unknown variable, either x1 or x2, by solving “ax1+bx2=C” the equation. Substitute vertices into the Objective Function. Substitute the values of the variables (x1 and x2) at the vertices into the objective function equation. Select the values of the variables that are the maximum or minimum for the objective function, depending on the definition of the objective function (Step 1). Installing Open Solver - Model Installing the Open Solver in excel. 1.- Copy the OpenSolver21.zip into your computer. 2.- Unzip this file 3.- Double click on the is the add-In file: “OpenSolver” which 4.- If a dialogue-window pops up, please select “enable macros” 5.- On the data menu of Excel you should see the Open Solver add-in in the right corner of the menu.
Define the Feasible Region. Use the constraints (inequalities) to bound the feasible region. For constraints with the form “ax1+bx2≤C”, convert them into equations by dropping the “≤” or “≥” symbol and adding the equal sign “=”, such as “ax1+bx2=C”. Then solve the equation for x1=0 to obtain the point where the linear equation crosses the x1 axis. Similarly, solve for x2=0 to obtain the point where the linear equation cross the x2 axis. Obtain the vertices of the feasible region. Do this by identifying the points in the feasible region and, for the constraints with the form “ax1+bx2≤C”, convert them into equations “ax1+bx2=C” and obtain the value of the unknown variable, either x1 or x2, by solving the equation. Substitute vertices into the Objective Function. Substitute the values of the variables (x1 and x2) at the vertices into the objective function equation. Select the values of the variables that are the maximum or minimum for the objective function, depending on the definition of the objective function (Step 1). Installing Open Solver - Model Installing the Open Solver in excel. 1.- Copy the OpenSolver21.zip into your computer. 2.- Unzip this file 3.- Double click on the file: “OpenSolver” which is the add-In 4.- If a dialogue-window pops up, please select “enable macros” 5.- On the data menu of Excel you should see the Open Solver add-in in the right corner of the menu.
Ex_5_Optimization.docx