Determing the mathematical ROI of a project management implementation

SUMMARY

The objective of this paper is to present, discuss and apply a mathematical model based on the use of Monte Carlo simulation in conjunction with researches on project success/failure rates of projects to develop a 10-step model to calculate the mathematical return on investment (ROI) for the project management office (PMO) implementation.

The paper aims to provide guidance on how intangible results resulting from the project planning and control can be linked to potential savings in time and cost comparing with projects poorly managed (Kwak & Ibbs, 2000). It is not the scope of this paper to demonstrate the positive impact of good project management practices. The main objective is to discuss possible ways of measuring results in order to have a more clear cost benefit analysis regarding the value of a PMO setup (Hubbard, 2010).

This paper also discusses the main challenges to quantify benefits considering cultural, social, and value perception dimensions in order to translate benefits into clear and measurable numbers.

THE IMPORTANCE OF CLEAR BENEFIT MEASUREMENT

Business improvement processes like the PMO implementation are, most of the time, linked to indirect benefits achievement. In the past, program, project, or process success was measured by activity: number of people involved, money spent, and days to complete. Little consideration was given to the benefits derived from these activities because they were considered impossible to be clearly measured (Philips & Philips, 2007).

The intention of clear measurement of benefits can be based in the following arguments:

  • Price/money is a proxy for value.
  • Measurable outcomes contribute to a better alignment and integration with financial systems performance.
  • More tangible results support the identification of critical sources of value.
  • Promotes communication and makes results quantitatively tangible.

Understand the clear impact on project results of the project management processes, tools and existing support and how this structure contributes to better project results became a key driver to understand the value of project management (EIU, 2009)

MODEL OVERVIEW

The proposed model is based on 10 processes that are organized into six groups (See Exhibit 1). Both the processes and the groups are interrelated in order to produce the needed steps to understand the real costs and benefits brought by the project management implementation.

10 Processes to calculate the Return on Investiment of a Project Management Office

Exhibit 1 – 10 Processes to calculate the Return on Investiment of a Project Management Office

The processes are defined following the structure proposed by the PMBOK® Guide (PMI, 2013) with Inputs, Tools and Techniques and Outputs.

PROJECT PORTFOLIO

The Project Portfolio group describes the process that should be in place to understand the scope of what should be managed by a potential PMO. The intend is to make sure that the potential projects that will be supported by the PMO are identified and the cost, timeframe and benefits (value) of these projects are calculated.

The Project Portfolio group is divided in the following processes:

  • Create the portfolio of projects
  • Calculate financial return of projects in the portfolio
  • Categorize projects

Create the Portfolio of Projects

This is process is responsible for the creation of the portfolio of projects. Based in working groups and the support of experts, it aims to create a list of the projects that will be managed by the PMO including some preliminary information like the project objectives, estimated duration and budget (Exhibit 2).

Create Portfolio of Projects

Exhibit 2 – Create Portfolio of Projects

The Project Portfolio can be presented in different ways but the most suitable to support the upcoming process is a list with the name of the project, estimated duration, and budget (Exhibit 3). If the Project Office will support all kinds of projects at the corporate level, the list of projects can include a very different set of initiatives.

Example of Basic Project List

Exhibit 3 – Example of Basic Project List

The preliminary project information can include all supporting information about the project, including main objectives, outputs, expected benefits, and basic scope (Exhibit 4). This preliminary information can be also called Project Brief or Outline Business Case (UK CABINET OFFICE, 2011).

Example of Project Preliminary Information

Exhibit 4 – Example of Project Preliminary Information

Calculate Financial Return of Projects in the Portfolio

After identifying the potential portfolio of projects to be managed, it becomes important to calculate the benefits in terms of financial results of each project. This is one of the most challenging steps towards the calculation of the ROI of a Project office. Using the preliminary information, all proposed benefits will be measured in order to find clear outcomes (Exhibit 5).

Calculate Financial Return of Projects in the Portfolio

Exhibit 5 – Calculate Financial Return of Projects in the Portfolio

In some cases, this is easily measurable in terms of increase in the production, market place, etc. In other projects, the intangible results must be converted into an estimated final outcome. As an example, one main outcome of the “University Tiger Screws” project is to develop new capabilities in the current staff in order to reduce the investments with additional hiring of personnel. A range of potential savings is defined and through the pairwise comparison using the Analytic Hierarchy Process (Saaty, 1980; Saaty, 2009; Vargas, 2010), the Expected Value of the benefit could be estimated (Exhibit 6).

Example of the Use of AHP to Estimate the Expected Value of the Benefit of a Project

Exhibit 6 – Example of the Use of AHP to Estimate the Expected Value of the Benefit of a Project

The main output of this project is an updated list of projects including the estimated financial benefits.

Categorize Projects (Optional)

For organizations with a wide range of projects, the categorization of projects could add value in the analysis and stratification of efforts (Exhibit 7).

This optional process group the projects into different categories (Exhibit 8):

  • Departments
  • Risk
  • Value
  • Sponsoring group
  • Geographic location
Categorize Projects

Exhibit 7 – Categorize Projects

Example of a Categorized List of Projects with the Calculated Benefits Highlighted

Exhibit 8 – Example of a Categorized List of Projects with the Calculated Benefits Highlighted

DATA DISTRIBUTION PROFILE

The Data Distribution Profile aims to determine the best “risk profile” of the portfolio to archive the benefits and it contains the process Determine Optimistic, Most Likely and Pessimistic Profile for Schedule, Investments and Results.

Using market research, historical information from previous projects and benchmarking, the objective of this process is to define the optimistic, pessimistic and most likely scenarios for the duration, costs and financial results of each project (Exhibit 9).

Determine Optimistic, Most Likely and Pessimistic Profile for Schedule, Investment and Results

Exhibit 9 – Determine Optimistic, Most Likely and Pessimistic Profile for Schedule, Investment and Results

Different external sources can be used to support the decision as follows:

• Standish Group Chaos Manifesto (STG, 2013)

• The IPA Institute Database of Capital Projects (IPA, 2013)

• PMI Pulse Report (PMI, 2013)

• Reports and researches from management consulting companies

This process requires a lot of negotiation to set the right thresholds for the project without being biased by individuals with over optimistic or over pessimistic behaviors.

The determination of the profiles can be done considering that the project duration, costs and financial results follow the same distribution (Exhibit 10) or a different set of distributions for each element.

Example of Probabilistic Forecasting Based on Project Complexity Level. In this case, a high complexity project with a value of $1,000,000 will cost between $1,250,000 and 1,750,000 without project management support and $1,000,00 and 1,150,000 with proper project management support

Exhibit 10 – Example of Probabilistic Forecasting Based on Project Complexity Level. In this case, a high complexity project with a value of $1,000,000 will cost between $1,250,000 and 1,750,000 without project management support and $1,000,00 and 1,150,000 with proper project management support.

SIMULATION

The Simulation group describes the process associated with the Monte Carlo simulation of the duration of the projects in the portfolio, associated costs, and financial results.

“Monte Carlo” was a nickname of a top-secret project related to the drawing and to the project of atomic weapons developed by the mathematician John von Neumann (Poundstone, 1993). He discovered that a simple model of random samples could solve certain mathematical problems that couldn't be solved up to that moment.

The simulation refers, however, to a method by which the distribution of possible results is produced from successive recalculations of project data, allowing the development of multiple scenarios. In each one of the calculations, new random data is used to represent a repetitive and interactive process. The combination of all these results creates a probabilistic distribution of the results (Exhibit 11).

Construction of Model of Distribution of Costs and Activities or Work Packages Making up a Final Distribution from Random Data of the Project (Pritchard, 2001)

Exhibit 11 – Construction of Model of Distribution of Costs and Activities or Work Packages Making up a Final Distribution from Random Data of the Project (Pritchard, 2001).

The feasibility of outcoming distribution relies on the fact that, for a high number of repetitions, the model produced reflects the characteristics of the original distribution, transforming the distribution into a plausible result for analysis. The simulation can be applied in schedules, costs, and other project indexes.

The Simulation group is divided in the following processes:

  • Simulate Portfolio of Projects
  • Identify Gains in Schedule, Investment and Results with the Implementation of the PMO

Simulate Portfolio of Projects

This is process is responsible for the simulation of the schedule gains, investment savings and improvements of financial results (Exhibit 12).

Simulate Portfolio of Projects

Exhibit 12 – Simulate Portfolio of Projects

The simulation is produced using simulation software and the results are a range of improvements in duration, budget, and financial results with their respective confidence level (Exhibits 13, 14, and 15).

Example of Simulation Output for the Savings in the Total Time of the Projects for Using the PMO. In this case there is a 90% confidence that the savings will be above 59.87 months

Exhibit 13 – Example of Simulation Output for the Savings in the Total Time of the Projects for Using the PMO. In this case there is a 90% confidence that the savings will be above 59.87 months.

Example of Simulation Output for the Savings in the Budget of the Projects for Using the PMO. In this case there is a 90% confidence that the savings will be at least 7,079,051.85 months

Exhibit 14 – Example of Simulation Output for the Savings in the Budget of the Projects for Using the PMO. In this case there is a 90% confidence that the savings will be at least 7,079,051.85 months.

Example of Simulation Output for the Gains in Financial Results of the Projects for using the PMO. In this case there is a 90% confidence that the savings will be at least 3,040,938.53 months

Exhibit 15 – Example of Simulation Output for the Gains in Financial Results of the Projects for using the PMO. In this case there is a 90% confidence that the savings will be at least 3,040,938.53 months.

Identify Gains in Schedule, Investment and Results with the Implementation of the PMO

After the simulation is concluded, the results are collected for a predefined confidence level in order to identify the measurable improvements (Exhibits 16 and 17).

Identify Gains in Schedule, Investment and Results with the Implementation of the PMO

Exhibit 16 – Identify Gains in Schedule, Investment and Results with the Implementation of the PMO

Example of gains based on the simulation results (Exhibits 13, 15 and 16)

Exhibit 17 – Example of gains based on the simulation results (Exhibits 13, 15 and 16)

INVESTMENTS IN THE PMO

The other aspect that must be considered when evaluating the ROI of a project implementation is to calculate the amount of costs the organization will incur to create and maintain the Project Office.

Different costs can be associated with the PMO (Aubry, Hobbs, Müler & Blomquist, 2010). The most common elements are:

• Personal cost

• Software and hardware

• Advisory services

• Training

• Others

Calculate Investment and Operational Costs of the PMO/Project Structure

Exhibit 18 – Calculate Investment and Operational Costs of the PMO/Project Structure

The main output of this process is the total cost of the PMO setup and operation for a predefined timeframe (Exhibit 19).

Example of a PMO Setup and Operation cost in a Five-year Timeframe. All values should be Adjusted to Present Value

Exhibit 19 – Example of a PMO Setup and Operation cost in a Five-year Timeframe. All values should be Adjusted to Present Value.

INFLUENCE OF THE PMO IN THE RESULTS

Based on the studies discussed in the step 4 of the process, it is important to highlight that not all benefits and positive results exclusively stem from the very existence and operation of the PMO. Many other external factors can benefit from those results and are beyond the control of the project manager and his or her team.

Some examples of benefit/dis-benefit drivers not related to project management implementations are (UK Cabinet Office, 2011):

  • External economic factors like currency exchange rate, interest rates
  • Market changes
  • Changes in the legislation
  • Changes in the senior leadership
  • Others

In this process (Exhibit 20), it is proposed the use of the Analytical Hierarchy Process (AHP) to compare the likelihood of benefits coming from the PMO, in comparison with other sources of benefits (Saaty, 1980; Vargas, 2010).

Determine the Influence of the PMO on Results

Exhibit 20 – Determine the Influence of the PMO on Results

The output of this process is the weight of the PMO in relationship with other sources of benefits (Exhibit 21).

Example of AHP Comparing Different Sources of Benefits with Project Management Implementation. In this case, it is suggested that 52.2% of the benefits could be justified by the setup and operations of a PMO

Exhibit 21 – Example of AHP Comparing Different Sources of Benefits with Project Management Implementation. In this case, it is suggested that 52.2% of the benefits could be justified by the setup and operations of a PMO.

RESULTS

The final group of process intends to calculate the return on investment and also analyze and discuss the final results.

The Results group is divided in the following processes:

  • Calculate the Return on Investment (ROI) of the PMO
  • Analyze Final Results

Calculate the Return on Investment (ROI) of the PMO

This process compare the results obtained in the simulation and compare them with the investments related to the PMO and the percentage of results attributable to the PMO (Exhibit 22).

Calculate the Return on Investment (ROI) of the PMO

Exhibit 22 – Calculate the Return on Investment (ROI) of the PMO

The output of this process is the calculated ROI with complementary information (Exhibit 23).

Example of Financial Calculation Based on the Simulation Results and the Cost/Relevance of the PMO in the Results

Exhibit 23 – Example of Financial Calculation Based on the Simulation Results and the Cost/Relevance of the PMO in the Results

Analyze Final Results

After receiving the final ROI report, working groups and the PMO sponsoring group need to meet in order to analyze and discuss the results to make the final decision (Exhibit 24).

Analyze Final Results

Exhibit 24 – Analyze Final Results

CONCLUSIONS

The proposed model is a “master line” of the value calculation and can thus be customized and adapted to different scenarios. It is important to highlight that this model is a simplification of very complex environment, where different perceived values can provide different directions to different stakeholders.

In order to avoid resistance and criticism during the simulation of intangible results, it is important to do this work in teams to avoid personal biases in the process.

Finally, it important to understand the challenge of determining ROI without knowing which projects are selected and the strategy that supports them. A project office that takes care of several different multi million projects is a very different effort from a project office that has simple work packages to be controlled.

Aubry, M., Hobbs, B., Müller, R. & Blomquist, T. (2010). Identifying forces driving PMO changes. Project Management Journal, 41(4), 30-45.

EIU. (2009). Closing the gap - The link between project management excellence & long-term success. London: Economist Intelligence Unit.

Hubbard, D. (2010). How to measure anything: Second edition. Hoboken: John Wiley & Sons.

IPA. (2013). Research as a foundation. Ashburn: Independent Project Analysts. Available at http://ipainstitute.com/Home/About/Research

Kwak, Y. H., & Ibbs, C. W. (2000). Calculating project management's return on investment. Project Management Journal, 31(2).

Philips, J. J., & Philips, P. P. (2007). Show me the money: How to determine the ROI in people, projects and programs. San Francisco: Berrett-Koehler Publishers.

PMI. (2013). Pulse report of the profession. Newtown Square: Project Management Institute. Available at http://www.pmi.org/Knowledge-Center/Pulse.aspx

PMI. (2013). A guide to the project management body of knowledge (PMBOK® guide) - fifth edition. Newtown Square: Project Management Institute.

Poundstone, W. (1993). Prisoner's dilemma. Flushing: Anchor Publishing Group.

Pritchard, C. L. (2001). Risk management: Concepts and guidance, 2nd ed. Arlington: ESI International.

Saaty, T. L (1980). The Analytic Hierarchy Process. New York: McGraw-Hill International.

Saaty, T. L. (2009). Extending the measurement of tangibles to intangibles. International Journal of Information Technology & Decision Making, 8(1), 7-27. Available at SSRN: http://ssrn.com/abstract=1483438.

STG. (2013). The chaos manifesto. Boston: The Standish Group. Available at https://secure.standishgroup.com/reports/reports.php

UK Cabinet Office. (2011). Managing successful programmes, fourth edition. London: The Stationery Office.

Vargas, R. (2004). Earned value probabilistic forecasting using Monte Carlo simulation. Washington: AACE -Association for Advancement of Cost Engineering 48th Annual Meeting.

Vargas, R. V. (2010). Using analytical hierarchy process to select and prioritize projects in portfolio management. Dallas: PMI Global Congress North America. Available at http://www.ricardo-vargas.com/articles/analytic-hierarchy-process/

This material has been reproduced with the permission of the copyright owner. Unauthorized reproduction of this material is strictly prohibited. For permission to reproduce this material, please contact PMI or any listed author.

© 2013, Ricardo Viana Vargas
Originally published as a part of 2013 PMI Global Congress Proceedings – New Orleans – Louisiana - USA

Advertisement

Advertisement

Related Content

Advertisement

Publishing or acceptance of an advertisement is neither a guarantee nor endorsement of the advertiser's product or service. View advertising policy.