Skip to content
Find your tool
Risk Contingency Allocation Tool (RCAT)
Risk Contingency Allocation Tool · version 4.0

How much reserve,
and who holds which part?

Work out the risk reserve in three different ways, combine them into one recommendation you can explain, and split it between the project manager and the sponsor.

RCAT: Monte Carlo simulation with histogram and S-curve

See it in action.

Recorded live in Microsoft Excel, on a fictional project case.

Watch the step-by-step tutorial (15 min, YouTube)

RCAT: Monte Carlo simulation with histogram and S-curve
Monte Carlo simulation with histogram and S-curve
RCAT: Contingency dashboard: three methods, one recommendation
Contingency dashboard: three methods, one recommendation
RCAT: Executive summary for the board
Executive summary for the board

Three questions it answers.

To split the contingency fairly.

1

How big should the reserve be?

A Monte Carlo P80 and a weighted recommendation from three methods, as a share of the base estimate.

2

Why this number?

Each method is visible, so the recommendation can be explained to a sponsor line by line.

3

Who holds which part?

Split the reserve into project contingency for the project manager and management reserve for the sponsor, and allocate it by risk category and work package.

Is this the right tool?

Who it is for

Project controllers, PMO leads and sponsors who must agree how large the contingency is and who controls which part of it.

When to choose it

Choose it when the risks are known and you must defend the reserve to a sponsor: three methods side by side, then a split into project contingency and management reserve, by risk category and work package.

Another tool fits better

What’s inside.

Everything runs in Excel on your own machine.

  • Three weighted methodsBottom-up EMV, a factor-based estimate and the Monte Carlo P80, combined into one weighted recommendation.
  • Contingency and management reserveSplit the reserve between the project manager and the sponsor; the default 70/30 is adjustable.
  • Allocation by category and work packageSee which risk categories and which work packages the reserve is held for.
  • Business case report and board deckGenerated in Word and PowerPoint from the results.
  • Run from the dashboardOne button runs the Monte Carlo and refreshes the charts.
  • Any currencySet the currency once; every amount in the workbook is relabeled.

Numbers you can check.

Every package ships with a reference case and the exact values it should return.

52.96M
P80 in the reference case (EUR)
12.4%
weighted recommendation as share of base
18
tests against an independent Python engine
Local
runs offline, nothing is sent or collected

Check your installation: in the Full edition, the unchanged reference case (Harbor Crossing Rail Tunnel, fictional) returns a P80 of EUR 52,963,087 and a weighted recommendation of EUR 42,209,857 at seed 42. The free Demo uses 15 of the 30 risks and returns a P80 of EUR 26,487,060. How we validate ›

Editions.

One license gives you the paid editions in the package; the free Demo is for everyone.

Full

The tool with the reference case Harbor Crossing Rail Tunnel.

  • Monte Carlo and three methods
  • Contingency and management reserve split
  • Business case report and board deck

Start

The same tool with an empty register and default settings.

  • USD, 10,000 iterations, seed 42
  • Ready for your own project; currency changes in one click

Demo

For evaluation.

  • 15 of the 30 reference risks
  • 2,000 iterations
  • Free to share unchanged, for evaluation

System requirements.

SoftwareMicrosoft Excel 2016 or later for Windows (64-bit recommended), with macros enabled. A macOS installation guide is included.
ReportsWord and PowerPoint desktop for Windows for the business case report and board deck.
In the packageFull, Start and Demo workbooks, user guide, ten-minute briefing, quick reference card, intake form, use case, sample report and deck, white paper, quality and validation documents, license documents.
PrivacyThe tool runs entirely locally. Nothing is sent or collected; no internet connection is needed after download.
LicensePersonal license: one named user on at most two devices, for your own projects and the projects you analyze for clients. See the license summary.

Try it before you buy.

The free demo runs the same engine as the full tool, on a smaller case. Run it, look around the sheets and compare your result with the reference value on this page.

  • 15 of the 30 reference risks
  • 2,000 iterations
  • Free to share unchanged, for evaluation

Enter your name and email address; the download link arrives in your inbox right away.

RCAT: Contingency dashboard: three methods, one recommendation

Questions.

Which version of Excel do I need?

Microsoft Excel 2016 or later for Windows (64-bit recommended), with macros enabled. A macOS installation guide is included.

Does it work on a Mac?

Built and tested for Excel on Windows. A macOS installation guide is included, but the tool has not yet been field-tested on a Mac. The business case report and board deck need Word and PowerPoint for Windows.

Our IT department blocks macros. What now?

Windows often blocks macros in downloaded files. Right-click the file, choose Properties, tick Unblock, then reopen it and click Enable Content. The package includes the system requirements to share with your IT department. The tool runs entirely on your own computer and sends no data anywhere.

Can I use it for client projects?

Yes. The license covers your own projects and the projects you analyze for clients. You may share the reports and results you produce; the software itself stays with the licensed user. See the license summary.

How many computers can I install it on?

One named user on at most two devices, for example a desktop and a laptop. For a team, each user needs a license.

How do I receive the tool?

Right after payment you receive a download link by email. The package unzips to a folder with the workbooks, the user guide and the license documents.

Why do you ask for my email address for the free demo?

The download link is sent to your email address. If you tick the box to hear from us, we send a short message a few days later to ask how the demo went, with tips for a first run, and occasionally product news; you can unsubscribe in every message. We never share your address.

Are updates included?

Yes. Updates are free for 12 months from the date of purchase, and email support at [email protected] is included for the same period.

How are VAT and invoices handled?

Our sales platform, Payhip, handles the payment and VAT or sales tax, and sends you a receipt for your administration.

Can we pay by invoice or purchase order?

Yes. Email [email protected] with your company details, the tool and the number of users. We send a quote, and an invoice once you approve it. For three or more users we offer a team price.

Can I get a refund?

If the tool doesn’t run on your system, or doesn’t do what its page describes, email [email protected] within 14 days of purchase. We’ll fix it, or you get your money back. Not sure it fits your work? Try the free demo first: it runs the same engine.

Who can buy it?

Quantil tools are sold for business and professional use only, including independent consultants. They are not sold to consumers.

Does the tool decide for me?

No. It shows the consequences of your inputs, so you can decide with the numbers in front of you. The decision stays with your sponsor, project board or client.

Decision support, not a guarantee. The Risk Contingency Allocation Tool (RCAT) shows the consequences of your inputs. It does not guarantee any cost, schedule or tender outcome. The decision stays with your sponsor, project board or client.

Get the Risk Contingency Allocation Tool (RCAT).

$695
  • Full, Start and Demo workbooks, user guide, ten-minute briefing, quick reference card, intake form, use case, sample report and deck, white paper, quality and validation documents, license documents.
  • A personal license for one user on up to two devices. Read the license
  • Free updates and email support for 12 months.
  • Doesn’t the tool run on your system, or doesn’t it do what this page describes? Let us know within 14 days. We’ll fix it, or you get your money back.

Buying through your purchasing department? Ask for a quote and pay by invoice. Three or more users? Ask for a team price.

Need more than one tool? Decision Chain Bundle: all 5 tools for $2,795 instead of $3,775.

Launch offer: 20% off with code LAUNCH20 at checkout, until December 31, 2026.

Secure checkout through PayhipCard or PayPalVAT handled, receipt for your recordsInvoice on request14-day guarantee

Prices in USD, excluding VAT or sales tax. For business and professional use. Payment and tax are handled by our sales platform, Payhip.