Figure 17.7 shows the efficient frontier constraints for optimization. You can get to this interface by clicking on the Efficient Frontier button after you have set some constraints. You can now make these constraints changing. That is, each of the constraints can be created to step through between some minimum and maximum value. As an example, the constraint in cell J17 <= 6 can be set to run between 4 and 8 (Figure 17.7). That is, five optimizations will be run, each with the following constraints: J17 <= 4, J17 <= 5, J17 <= 6, J17 <= 7, and J17 <= 8. The optimal results will then be plotted as an efficient frontier and the report will be generated (Figure 17.8).
Specifically, the following are the steps required to create a changing constraint:
Figure 17.7: Generating Changing Constraints in an Efficient Frontier
Figure 17.8: Efficient Frontier Results