To declare the fifth constraint (3XA+2XB 1800), click on the icon to browse for the left hand ≤ side of the constraint (Figure 20). Select the cell O22 (Figure 39), then go back to the dialogue menu. Select the symbol of equal or greater than (Figure 40). Now click on the icon to select “≤” right-side part of the inequality (Figure 23), select cell Q22 (Figure 41) and go back the dialogue window. Click on The inequality of cell O22 Cell Q22 should have “Add Constraint”. ≥ appeared in the left side of the Constraints section of the dialogue window (Figure 42). Figure 39 Figure 40 Figure 41 Figure 42 Check the box that constraints and shadow prices in a table with top left and says “List cell:” select the cell (Figure 43) “AC8” Figure 43 Click on (Figure 44). A Series of colorful rectangles should have appeared in your “Save Model” Spreadsheet (Figure 45). Notice that the Objective Function (cell Q5) has a on top “Max” label of it. Also, notice that the variables have a pink rectangle on top. In addition, for each constraint the right and left side of the equations/inequality are related with a line and a symbol or (“≥”, “≤” Double check that these symbols are correct. “=”), Figure 44 Figure 45 Running the Linear Programming Model It is time to run the model!!! Click on the Solve icon (Figure 46) of the Open Solver. After the screen blinks you will notice that numbers have changed. The maximum profit that can be obtained are $360,000 (Cell Q5)!!! The values for the variable have changed, and XA=200 as we calculated in the presentation at class!!! XB=600,
To declare the fifth constraint (3XA+2XB ≤ 1800), click on the icon to browse for the left hand side of the constraint (Figure 20). Select the cell O22 (Figure 39), then go back to the dialogue menu. Select the symbol of equal or greater than “≤” (Figure 40). Now click on the icon to select right-side part of the inequality (Figure 23), select cell Q22 (Figure 41) and go back the dialogue window. Click on “Add Constraint”. The inequality of cell O22 ≥ Cell Q22 should have appeared in the left side of the Constraints section of the dialogue window (Figure 42). Figure 39 Figure 40 Figure 41 Figure 42 Check the box that says “List constraints and shadow prices in a table with top left cell:” and select the cell “AC8” (Figure 43) Figure 43 Click on “Save Model” (Figure 44). A Series of colorful rectangles should have appeared in your Spreadsheet (Figure 45). Notice that the Objective Function (cell Q5) has a “Max” label on top of it. Also, notice that the variables have a pink rectangle on top. In addition, for each constraint the right and left side of the equations/inequality are related with a line and a symbol (“≥”, “≤” or “=”), Double check that these symbols are correct. Figure 44 Figure 45 Running the Linear Programming Model It is time to run the model!!! Click on the Solve icon (Figure 46) of the Open Solver. After the screen blinks you will notice that numbers have changed. The maximum profit that can be obtained are $360,000 (Cell Q5)!!! The values for the variable have changed, XA=200 and XB=600, as we calculated in the presentation at class!!!
Ex_5_Optimization.docx