Quantitative Risk & Cost Integration Model (QRCIM)
Excel model that turns a cost estimate into a budget you can substantiate. QRCIM runs your cost items, your risk events and the cost of schedule delay in one correlated Monte Carlo simulation, shows the budget at every confidence level, and checks the model before the result goes to the board.
WHAT IT ANSWERS
- What will the project really cost, with estimate uncertainty and risks taken together?
- Which budget do we request, and at which confidence level?
- How large is the management reserve, and can we trust the model behind it?
COST AND RISK IN ONE MODEL
- Cost breakdown of up to 50 cost items, each with a three-point estimate (minimum, most likely, maximum)
- 50 by 50 correlation matrix, so cost items that share a cause move together
- Up to 30 discrete risk events, as probability times impact
- + ADD RISK opens a form that checks the input and writes the first empty row; DELETE RISK removes a risk after you confirm
- Up to 20 duration-sensitive activities: schedule delay counts as delay times daily rate
- Correlated Beta-PERT Monte Carlo simulation: 10,000 iterations by default, 100 to 100,000 per run
- Assumptions log for up to 50 assumptions and 15 exclusions
CONFIDENCE LEVELS
- Eight confidence levels: P10, P25, P50, P75, P80, P85, P90 and P95
- The price of each step up in confidence, with P85 as the recommended budget level
- S-curve of the total cost with reference lines
- Time-phased cash flow with P50, P85 and P90 bands
CONTINGENCY AND MANAGEMENT RESERVE
- Build-up from base estimate via deterministic contingency to probabilistic contingency and management reserve
- Drawdown plan over 24 periods
- Tornado that ranks cost items, risk events and the schedule overlay side by side by their contribution to the variance
- Net benefit and return per mitigation measure
- Scenarios that scale the last run with factors on the ranges, the risk probabilities, the schedule delay and market escalation
- 5 by 5 risk matrix and a sheet for your own reference projects
REPORTING AND GOVERNANCE
- Word management report, The Risk Profile: nine chapters plus seven appendices, from one keyboard shortcut
- Sixteen-slide steering committee deck in PowerPoint, from the same simulation data
- Input quality score on six dimensions: BOARD-GRADE, WORKSHOP-GRADE or DEVELOPMENT-GRADE, with advice on what to improve
- Audit gate of fifteen checks across all sheets; the gate stays closed as long as one check fails
- Version log and run log in the workbook; every run is recorded with its seed
- One currency per project, nine currency codes; amounts are not converted
VALIDATED AND TRANSPARENT
- Built-in verification suite: seven checks on the calculation engine
- Fourteen component and chain tests against an independent Python reimplementation, all passed
- On the full demo register the reference reproduces every percentile from P10 to P95 within 0.22%
- Fixed seed: the reference case returns exactly P50 USD 476,114,593 and P85 USD 515,256,546 on every machine
- No sheet protection and no hidden sheets: every formula can be traced
- Aligned with AACE RP 17R-97, 18R-97, 40R-08, 41R-08, 42R-08, 44R-08 and 65R-11 and the ISO 31000 risk matrix (alignment, not certification)
IN THE PACKAGE
- Model workbook with the reference case (Cascade Highway Tunnel, fictional), an empty START workbook and a Demo (up to 8 cost items, 5 risk events, 4 schedule rows and 5,000 iterations)
- User Guide, Quick Start & Reference Card, Ten-Minute Briefing and macOS Installation Guide
- Sample management report, presentation and mitigation tracker from the demo case, plus the Cascade use case
- Validation Note, Verification Note, Quality Benchmark Dossier and System Requirements
- White paper on setting the right budget
- 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 live report and deck need Word and PowerPoint for Windows. Excel for the web and the mobile apps do not run the macros. Runs offline; nothing is sent or collected.
Mac: a Mac route and a macOS Installation Guide are included, but the tool has not yet been field-tested on a Mac. On a Mac the management report is written as a formatted file that you open in Word, and the deck becomes a ten-page landscape handout: there is no PowerPoint file. The simulation runs about 3 to 5 times slower than on Windows. 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. QRCIM 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.