VanillaPM
Sign in Get started free Dashboard
Free calculator

Contingency reserve calculator

A free contingency reserve calculator. List your threats with their chance and impact to get the total EMV, then see how much of it the contingency left covers, the gap, and whether management reserve could close it.

RiskTypeChance %ImpactEMV
Threat EMVwhat the open threats are worth
Contingency leftreserve − drawn
Coveredof the threat EMV
Gap
Threat EMV = Σ p × impact
Left = reserve − drawn
Covered = min(EMV, left) ÷ EMV
Gap = max(EMV − left, 0)
Gap after management reserve
Opportunity EMV
Download as Excel (.xlsx) The spreadsheet has live formulas: change the yellow cells and it recalculates.

Contingency and management reserve

A project's cost baseline usually includes a contingency reserve: money set aside for the risks you have identified. Above the baseline sits the management reserve, held by the sponsor for the things nobody saw coming. Spending contingency is part of the plan; spending management reserve needs the sponsor's approval and changes the baseline.

Sizing contingency from EMV

A common way to size contingency is the total expected monetary value of the open threats: for each one, chance × impact, added up. This calculator compares that figure with what is left of the reserve after the draws so far:

  • Covered is the share of the threat EMV the remaining contingency can pay for.
  • Gap is the shortfall, if any.
  • Gap after management reserve tells you whether the sponsor's reserve could close it, or whether the project needs a decision now.

Opportunities are listed apart and not netted off against threats. Counting on a lucky break to pay for a likely problem is how reserves run dry.

How VanillaPM uses it

Inside a project, the risk review does the same sum every day from the risk register, using the contingency in the budget and the draws already recorded, and flags the project when exposure is larger than the reserve left.

Common mistakes

  • Using the impact instead of the EMV: a reserve big enough for every threat at once is far too big.
  • Forgetting the draws: a reserve that was right at the start may not be right now.
  • Leaving closed risks in the list.

See it used on a real project: B5 · Plan and manage risk