Your Cart
Loading

Cost & Schedule Risk Analyzer

On Sale
$695.00
$695.00
Added to cart

Excel tool to run a facilitated risk workshop and leave with a budget and a duration you can defend. The Risk Analyzer guides the team through a pre-mortem workshop, builds the risk register, and runs a Monte Carlo simulation for cost and schedule, so you get a budget and a duration at P50, P80, P85 and P90, a confidence target you choose from P50 to P95, and a report for the steering committee.


WHAT IT ANSWERS

  • What could go wrong on this project?
  • How much contingency do we need, and at which confidence level?
  • How many weeks could we finish late, and which risks carry most of it?


FROM WORKSHOP TO RISK REGISTER

  • Facilitated pre-mortem workshop: run sheet, stakeholder survey and participant canvas
  • Two tutorials in the user guide: a workshop in eighteen steps, or taking over an existing risk register
  • Read-only library of 150 common capital project risks, as a checklist against blind spots
  • Register of up to 100 risks, each with a probability and a three-point estimate (minimum, most likely, maximum) for cost and for schedule
  • Every risk written as IF, THEN and IMPACT, in seven risk perspectives
  • + ADD RISK opens a form and writes the next free row with the next ID; DELETE RISK removes a risk after you confirm
  • Negative cost values are allowed, to describe an opportunity


MONTE CARLO FOR COST AND SCHEDULE

  • Beta-PERT Monte Carlo simulation: 10,000 iterations by default, up to 50,000
  • Dependence between risks through up to eight shared drivers, or a full correlation matrix for up to 25 risks
  • Critical path flag per risk: delays on the critical path add up, of the other delays only the largest counts
  • Fixed seed: the same register gives exactly the same result on every computer
  • A run takes 15 to 45 seconds on a typical Windows computer


CONFIDENCE LEVELS

  • P50, P80, P85 and P90 for total cost and for total duration, on the dashboard
  • The contingency at each level, in money and as a percentage of the base estimate
  • Confidence target for the recommendation and the reports: P50, P70, P75, P80, P85, P90 or P95
  • Statistical summary with minimum, P10, mean, standard deviation and maximum
  • Histogram with S-curve for cost and for duration


TOP RISKS AND MITIGATION

  • Two top-10 rankings: the largest risks by expected cost and by expected delay in weeks, each with its own tornado chart
  • 5x5 risk matrix with automatic classification: Critical, High, Medium or Low
  • Mitigation tracker that shows the expected cost removed and the return on each measure
  • What-if chapter in the user guide: another confidence level, a mitigated top risk, stronger dependence, another critical path


REPORTING AND GOVERNANCE

  • Word management report of about thirteen pages, built from the last run
  • Eleven-slide steering committee deck in PowerPoint, built from the same run
  • Word workshop record: who took part, how the session ran, the risks per perspective and the owners
  • Report and presentation templates, plus fully worked example documents
  • One currency per project, nine currency codes; the tool relabels amounts, it does not convert them


VALIDATED AND TRANSPARENT

  • 19 tests of the engine against an independent Python reimplementation, all passed; the Validation Note is in the package
  • Random generator and exact inverse Beta function are built into the tool, without add-ins
  • No sheet protection: every formula is visible
  • Based on the RISMAN method and aligned with ISO 31000:2018, IEC 31010 and AACE RP 41R-08, 40R-08 and 57R-09
  • Installation check: the unchanged demo case returns a P80 cost of $18,906,479 and a P80 duration of 99.2 weeks


IN THE PACKAGE

  • Full workbook with the demo case (Cascade Valley 345 kV, fictional, 50 risks), a Blank workbook for your own project and a Demo (15 risks, 2,000 iterations)
  • Workshop Kit: facilitation deck, participant canvas, capture sheet and facilitator quick reference
  • Complete User Guide A to Z (51 pages), Ten-Minute Briefing, Quick Start & Reference Card and macOS Installation Guide
  • Facilitator Guide and two theory reports on probabilistic risk management
  • Validation Note, Verification Note, Quality & Benchmark Dossier and System Requirements
  • License agreement, disclaimer and privacy statement
  • A second zip with the step-by-step tutorial video and the overview video


REQUIREMENTS AND LICENCE

Built and tested for Microsoft Excel 2016 or later for Windows (64-bit recommended), with macros enabled. The management report, the workshop record and the deck need the desktop versions of Word and PowerPoint. Excel for the web and the mobile apps do not run the macros. Runs offline; nothing is sent or collected.


Mac: the workbooks are designed to run in Excel for Mac 2016 or later and a macOS Installation Guide is included, but the tool has not yet been field-tested on a Mac. On a Mac the Word report, the workshop record and the PowerPoint deck take two steps with the two supplied builder files instead of one click, and the simulation takes about 3 to 5 times longer. Try the free demo first.


Perpetual licence for one named user on up to two devices; twelve months of free updates.


For business and professional use only. The Risk Analyzer is a decision-support tool: results depend on the quality of your inputs. By buying you accept the Quantil License Agreement in the package. You may not modify, unlock, extract or reverse engineer the tool or its code, including with automated or AI tools.

You will get the following files:
  • ZIP (17MB)
  • ZIP (352MB)