Risk Contingency Allocation Tool (RCAT)
Excel tool to estimate, justify and allocate a risk-based contingency reserve. RCAT works out the reserve in three independent ways, combines them into one weighted recommendation you can defend, and splits it between the project manager and the sponsor.
WHAT IT ANSWERS
- How big should the reserve be?
- Why this number, and at which confidence level?
- Who holds which part, and where will it be spent?
THREE METHODS, ONE RECOMMENDATION
- Bottom-up EMV: probability times expected impact per risk, with a correlation factor and an optional opportunity offset
- Factor-based estimate: from project phase, complexity score and contract type
- Monte Carlo simulation: seeded and reproducible, 1,000 to 100,000 iterations, with correlation between the twelve leading risks
- Weighted recommendation with adjustable weights (default 35 / 25 / 40), shown with its percentile on the S-curve
CONFIDENCE LEVELS
- P10, P50, P80, P85, P90 and P95 of the total risk cost
- Mean, standard deviation and coefficient of variation
- Histogram and S-curve
SPLIT AND ALLOCATION
- Project contingency and management reserve (default 70 / 30, adjustable)
- Allocation by risk category (RBS) and work package (WBS)
RISK REGISTER
- Up to 75 risks, threats and opportunities
- Per risk: probability, three-point cost impact (minimum, most likely, maximum), owner, response strategy, mitigation action and status
- Add and delete risks with a form that checks your input
- Choose per risk whether it is included in the simulation
ANALYSIS
- Tornado chart of the top risk drivers
- Four scenarios (Optimistic, Base Case, Pessimistic, Stress Test) and a what-if block
- Benchmark check against indicative ranges for 15 project types
- Mitigation plan: value and cost efficiency of each action
- 14 currencies; set once, every amount is relabeled
REPORTING AND GOVERNANCE
- Dashboard with KPIs, method comparison and top-5 drivers
- One-page executive summary and five-page board pack, ready to print
- Word business case report and PowerPoint board deck, generated from the results
- Assumption log, approvals and audit trail in the workbook
VALIDATED AND TRANSPARENT
- Open Excel formulas: every result traces back to your inputs
- Engine tested against an independent Python implementation (18 tests)
- Reference case with published check values: the same seed gives the same result on every run
- Aligned with AACE RP 40R-08, 42R-08 and 18R-97 and ISO 31000 (alignment, not certification)
IN THE PACKAGE
- Full workbook with the reference case, Start workbook for your own project, and Demo
- Complete user guide, ten-minute briefing, quick reference card and client intake form
- Use case, sample business case and board deck, white paper, validation and quality documents
- 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 Word and PowerPoint generators need Word and PowerPoint for Windows. Runs offline; nothing is sent or collected.
Mac: a macOS guide is included and the workbook is designed to run on Excel for Mac 2019 or Microsoft 365, but it has not been field-tested on a Mac and the Word and PowerPoint generators do not work there. 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. RCAT 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.