Abstracts

  Intro to Palisade and the World of Probabilistic Analysis

We will open the conference with a brief overview of Palisade, and then address the question you’ve undoubtedly been faced with: “What is risk analysis, and why do I need it?” After all, risk management appears to have failed in many examples, and even now companies are trying to figure out how to grapple with risk and unlock the power of probabilistic analysis. How do we avoid missteps, and how do we make the most of the tools we have for managing the future?

  Building a Project Cost Estimate with @RISK

In this session attendees will learn how to put together a simple cost model using @RISK, learning about a number of important features along the way.

Take outs will include:

• Understanding how to get the same results each time a simulation is run
• How to use Excel cell references in a model, and why it is best practice to do so
• Generating a histogram/ S-Curve and customising it for reports
• Interpreting tornado graphs to understand key drivers in models
• Using scatter plots as a sanity check on a model
• Using confidence levels (percentiles) to quantify the likelihood of an outcome
• Automatically generating meaningful information using the @RISK statistics functions
• Calculating how much contingency needs to be added to a base estimate

  Making Risk Registers with @RISK

Quantitative risk registers are something which can be added to any model, but are fundamentally about modelling likelihood (or frequency) and severity, and then combining them. This session will give attendees the opportunity to build one themselves from scratch.

Take outs will include:

• Understanding why the average is a risky way to model risk
• How to choose a distribution to model event risk
• Why building a conditional risk register is the only theoretically sound way of modeling event risk
• How to combine likelihood and severity using RiskMakeInput and RiskCompound

  @RISK and Monte Carlo Simulation for Non-Financial Models

@RISK and Monte Carlo simulation is not only for financial models. Demand forecasting for power and water requirements, understanding how much oil might be in a particular reservior, climate change modelling, and reliability analysis are just a few of the other applications for the tool and techniques. This session will explore how @RISK can be applied for models where the results do not come out directly in Rials or Dollars. Depending on the makeup of attendees, this might be looking at an oil and gas reserves estimation model, a water demand forecast, or something else entirely. The model used will be a simple example which all attendees will be able to follow along with, regardless of the industry they come from.

  Senstitivity Analysis with TopRank, decision analysis with PrecisionTree, and optimisation with RISKOptimizer

This session will look at some of the companion tools that are available alongside @RISK within the DecisionTools Suite. First of all we’ll take a look at TopRank, a very quick, yet powerful, tool which allows you to find key drivers in any model. It’s also a very popular tool for auditing models to make sure they’re behaving as expected. This will be followed by a look at PrecisionTree, a tool which allows you to quickly build up decision trees to guide strategy choices in the face of different options. Finally, the session will give an overview of RISKOptimizer, the software which utilises the power of @RISK to optimise under uncertain conditions – stochastic optimisation.

  Selecting the Right Distribution

This session will look at the most popular distributions in @RISK. A variety of techniques for choosing the right distribution for your needs will be discussed and compared, including pragmatic, theoretical and data-driven methods. We will discuss the use of different distributions; discrete, continuous and a combination of both, to address a wide range of risk modelling situations.