This section illustrates a sample model from the ROV Modeling Toolkit—another software tool developed by Real Options Valuation, Inc., that contains more than 300 models and 800 functions. Figure 17.12 shows a model with 20 projects with different risk-return characteristics as well as several qualitative measures such as strategic score, military readiness score, tactical score, comprehensive score, and so forth. These scores are obtained through subject-matter experts, for instance, decision makers, leaders, and managers of organizations, where their expert opinions are gathered through the double-blind Delphi method. After being scrubbed (e.g., extreme values are eliminated, large data variations are analyzed, multiple iterations of the Delphi method are performed, etc.), their respective scores can be entered into a Distributional Fitting routine to find the best-fitting distribution or used to develop a Custom Distribution for each project.
The central idea of this model is to find the best portfolio allocation such that the portfolio’s total comprehensive strategic score and profits are maximized. That is, it is used to find the best project mix in the portfolio that maximizes the total Profit*Score measure, where Profit points to the portfolio level net returns after considering the risks and costs of each project and the Score measures the total comprehensive score of the portfolio, all the while being subject to the constraints on the number of projects, budget constraint, full-time equivalent (FTE) resource restrictions, and strategic ranking constraints.
Figure 17.12: The Project Selection Optimization Model
To run this preset model, simply open the profile (Risk Simulator | Change Profile) and select Military Portfolio and Efficient Frontier. Then run the optimization (Risk Simulator | Optimization | Run Optimization) or, for practice, set up the model yourself by following these steps:
Note: Remember that if you want to run either a dynamic or stochastic optimization routine, make sure that first, you have assumptions defined in the model. That is, make sure that some of the cells in C5:C24 and E5:F24 are assumptions. The suggestion for this model is to run a Static Optimization.
Figure 17.13: Setting Up an Optimization Model
Clearly, running the optimization procedure will yield an optimal portfolio of projects where the constraints are satisfied. This result represents a single optimal portfolio point on the efficient frontier, for example, Portfolio B on the chart in Figure 17.14. Then, by subsequently changing some of the constraints, for instance, by increasing the budget and allowed projects, we can rerun the optimization to produce another optimal portfolio given these new constraints. Therefore, a series of optimal portfolio allocations can be determined and graphed. This graphical representation of all optimal portfolios is called the Portfolio Efficient Frontier. At this juncture, each point represents a portfolio allocation, for instance, Portfolio B might represent projects 1, 2, 5, 6, 7, 8, 10, 15, and so forth, while Portfolio C might represent projects 2, 6, 7, 9, 12, 15, and so forth, each resulting in different tactical, military, or comprehensive scores, and portfolio returns. It is up to the decision maker to decide which portfolio represents the best decision and if sufficient resources exist to execute these projects. Typically, in an efficient frontier analysis, you would select projects where the marginal increase in benefits is positive and the slope is steep. In addition, you would select Portfolio D rather than Portfolio E because the marginal increase is negative on the y-axis (e.g., Tactical Score). That is, spending too much money may actually reduce the overall tactical score, and, hence, this portfolio should not be selected. Also, in comparing portfolios A and B, you would be more inclined to choose B as the slope is steep and the same increase in budget requirements (x-axis) would return a much higher percentage Tactical Score (y-axis). The decision to choose between portfolios C and D would depend on available resources and the decision maker deciding if the added benefits warrant and justify the added budget and costs.
Figure 17.14: Portfolio Efficient Frontier
To further enhance the analysis, you can obtain the optimal portfolio allocations for C and D and then run a simulation on each optimal portfolio to decide what the probability that D will exceed C in value is, and whether this probability of occurrence justifies the added costs.