Recording a Macro to Import a Plain Text File in Microsoft Excel 2016. This video introduces the idea of translating / converting a Value Driver Tree (VDT) into an Excel model. This video is part one.
  1. How To Create A Value Driver Tree Service

Introduction to Decision Tree Analysis in Project Risk Management

How to create company values

Business or project decisions vary with situations, which in-turn are fraught with threats and opportunities. Calculating the Expected Monetary Value of each possible decision path is a way to quantify each decision in monetary terms. Calculating Expected Monetary Value by using Decision Trees is a recommended Tool and Technique for Quantitative Risk Analysis. For the PMP exam, you need to know how to use Decision Tree Analysis to make decisions in Project Risk Management.

To understand how to calculate Expected Monetary Value for simple situations, read the Calculating the Expected Monetary Value (EMV) article.

In this article, we’ll look at a Decision Trees example that’ll illustrate the use of Decision Tree Analysis in Project Risk Management.

Steps to Use Decision Trees Analysis

To use Decision Tree Analysis in Project Risk Management, you need to:

  1. Document a decision in a decision tree.
  2. Assign a probability of occurrence for the risk pertaining to that decision.
  3. Assign monetary value of the impact of the risk when it occurs.
  4. Compute the Expected Monetary Value for each decision path.

The simplest way to understand decision trees is by looking at a Decision Trees example in Project Risk Management.

Decision Trees Example – Scenario

Suppose your organization is using a legacy software. Some influential stakeholders believe that by upgrading this software your organization can save millions, while others feel that staying with the legacy software is the safest option, even though it is not meeting the current company needs. The stakeholders supporting the upgrade of the software are further split into two factions: those that support buying the new software and those that support building the new software in-house. Confusion reigns in the meeting room with stakeholders pointing out negative risks for each option!!!

By exploring all possibilities and consequences, you can quantify the decisions and convince stakeholders. This is known as Decision Tree Analysis. The following Decision Trees example uses Decision Tree Analysis to help make an informed Project Risk Management decision. The computations involve calculating the Expected Monetary Value. Read on to learn more about Decision Trees and Decision Tree Analysis.

Decision Trees Example – Building the Decision Tree to Use in Decision Tree Analysis

In this scenario, you can either:

Looking at the options listed above, you can start building the decision trees as shown in the diagram. By looking at this information, the lobby for staying with the legacy software would have the strongest case. But, let’s see how it pans out. Read on.

The Buy the New Software and Build the New Software options will lead to either a successful deployment or an unsuccessful one. If the deployment is successful then the impact is zero, because the risk will not have materialized. However, if the deployment is unsuccessful, then the risk will materialize and the impact is $2 million. The Stay with the Legacy Software option will lead to only one impact, which is $2 million, because the legacy software is not currently meeting the needs of the company. Nor, will it meet the needs should there be growth. In this example, we have assumed that the company will have growth.

In this example, Decision Trees analysis will be used to make the project risk management decision. The next step is to compute the Expected Monetary Value for each path in the Decision Trees. Let’s see how this helps in this Decision Trees example.

Decision Trees Example – Calculating Expected Monetary Value for each Decision Tree Path

The diagram depicts the decision tree. Now, you can calculate the Expected Monetary Value for each decision. The Expected Monetary Value associated with each risk is calculated by multiplying the probability of the risk with the impact. By doing this, we get the following:

Now, add the setup costs to each Expected Monetary Value:

View the image above, to see how all the figures above look like in a Decision Tree after conducting a Decision Tree Analysis. Now let’s make the decision in this Decision Trees example. This will illustrate the role of Decision Trees in Project Risk Management.

Decision Trees Example – Making the Decision

Looking at the Expected Monetary Values computed in this Decision Trees example, you can see that buying the new software is actually the most cost efficient option, even though its initial setup cost is the highest. Staying with the legacy software is by far the most expensive option.

How To Create A Value Driver Tree Service

When youconduct a SWOT Analysis to determine whether a business idea is worth pursuing, there is no quantified data to support your decision. Decision Trees and Decision tree analysis help you quantify the data, which is then useful in convincing stakeholders. It is a critical part in Project Risk Management.