Figure 19 Now, we will add the constraints to the model. start with the first constraint Let’s (XA≤400), go to the constraints section and click on the icon to browse for the left hand side of the constraint (Figure 20). Select the cell O10 (Figure 21), then go back to the dialogue menu. Select the symbol of equal or less than (Figure 22). Now click on the icon to select the right side of the “≤” inequality (Figure 23), cell Q10 (Figure 24) and go back the dialogue window. Click on “Add (Figure 25). The inequality Cell O10 Cell Q10 should have appeared in the left Constraint” ≤ side of the Constraints section of the dialogue window (Figure 26). We just have finished declaring the first constraint. Figure 20 Figure 21 Figure 22 Figure 23 Figure 24 Figure 25 Figure 26 To declare the second constraint (XA click on the icon to browse for the left hand side of ≥ 0), the constraint (Figure 20). Select the cell O13 (Figure 27), then go back to the dialogue menu. Select the symbol of equal or greater than (Figure 22). Now click on the icon to select “≥” part of the inequality (Figure 23), select cell Q13 (Figure 29) and go back the dialogue window. Click on The inequality Cell O13 Cell Q13 should have appeared “Add Constraint”. ≥ in the left side of the Constraints section of the dialogue window (Figure 30). Figure 27
Figure 19 Now, we will add the constraints to the model. Let’s start with the first constraint (XA≤400), go to the constraints section and click on the icon to browse for the left hand side of the constraint (Figure 20). Select the cell O10 (Figure 21), then go back to the dialogue menu. Select the symbol of equal or less than “≤” (Figure 22). Now click on the icon to select the right side of the inequality (Figure 23), cell Q10 (Figure 24) and go back the dialogue window. Click on “Add Constraint” (Figure 25). The inequality Cell O10 ≤ Cell Q10 should have appeared in the left side of the Constraints section of the dialogue window (Figure 26). We just have finished declaring the first constraint. Figure 20 Figure 21 Figure 22 Figure 23 Figure 24 Figure 25 Figure 26 To declare the second constraint (XA ≥ 0), click on the icon to browse for the left hand side of the constraint (Figure 20). Select the cell O13 (Figure 27), then go back to the dialogue menu. Select the symbol of equal or greater than “≥” (Figure 22). Now click on the icon to select part of the inequality (Figure 23), select cell Q13 (Figure 29) and go back the dialogue window. Click on “Add Constraint”. The inequality Cell O13 ≥ Cell Q13 should have appeared in the left side of the Constraints section of the dialogue window (Figure 30). Figure 27
Ex_5_Optimization.docx