risk register

@RISK for Cost and Schedule Risk Using Risk Registers (with Example Model)

@RISK can be used in conjunction with MS Project and Excel to model the schedule and cost risks inherent in large, complex projects. This example demonstrates the use of @RISK to build a complete model of the construction of a new commercial venue. The model includes uncertainty in task times, a Risk Register for calculating contingencies, and a link to real-time cash flows in an NPV calculation model.

@RISK probability distributions have been assigned to the durations of several tasks in the schedule, some with a distribution and others using Risk Categories. The uncertain task times are assumed to be uncorrelated.

A Risk Register lists three possible risk events that could impact the project schedule and costs. By using the RiskProjectAddDelay function, these risks introduce schedule delays and associated costs. Specifically, this function allows the model to generate new tasks dynamically, depending on whether the risks occur or not. Changes are reflected at run time only, so it is necessary to run a simulation to see the impact and results of the Risk Register.

The example also contains a model of cash flows that leads to the NPV of the project. In particular, the project costs create a Timescaled Data report. This collects the total cumulative costs during a simulation. After a simulation, you can see the total cumulative costs for the project as they grow over time.

The other reports generated are the NPV and the Contingency for the Risk Register, at different confidence levels. Finally, the cash flow also includes a Revenue Adjustment calculation that takes the portion of the year in which Sales are initiated and applies a discount to the predicted annual revenue.

» Download the model (Requires @RISK 6.x Professional or higher, Microsoft Project must be installed.): XLSX fileMPP file
» Download a trial of @RISK Industrial

VIDEO: Cost Estimation and Risk Registers using @RISK

Palisade expert trainer Rafael Hartke discusses how to use @RISK  for cost estimation–more specifically,  how to transform your deterministic models into probabilistic ones.  This recorded webcast shows you how to add uncertainty as well as a risk register to your model.



About the trainer: Rafael Hartke is an Oil and Energy Industry Consultant at Palisade Corporation, where he works in the development and strategy of quantitative risk analysis methods. He has particular experience in the energy industry, having served as a Financial Engineer in Risk Management at Brazilian-based energy corporation, Petrobras in the Financial Planning and Risk Management department.  There, he created risk models for complex investments and assessed project risks for medium and large projects, including Brazilian Pre-Salt giant fields, projects in the Gulf of Mexico, and offshore infrastructure projects.

Rafael has an MSc degree in Mechanical Engineering and is also a Global Association of Risk Professionals-certified Energy Risk Professional.