Which risks actually deserve the money?
A worry list becomes a register when every risk carries a probability and an impact. Then the useful question appears: which mitigations actually pay for themselves, and which just feel responsible?
Operations Intermediate Risk Register Pro engine
After you install, this is the model to open.
Project Risk Register, Priced
- In your spreadsheet, click the Sortia icon in the strip of icons down the right-hand edge. No strip? Click the arrow at the bottom-right to open it. You can also use Extensions, then Sortia, then Open Sortia.
- Click Start from a template and put that name in the search box.
- Pick the card with that name and click Load this template. It arrives on a new tab with real numbers already in it.
This one runs on a Pro engine, and every free install includes five full-quality runs on your own numbers, shared across all five Pro engines rather than five for each. After that, Pro is $199/year.
The answer
Exposure, and what mitigating buys:
- Total exposure
- $112K expected
- After mitigations
- $41K
- Best mitigation
- +$12K vendor clause
- Worst
- −$5K migration insurance
Total expected exposure is $112,000, and the listed mitigations cut it to $41,000. The net-value column is the honest part: the vendor penalty clause is worth +$12,000 in expectation, while the $20,000 migration insurance removes only $15,000 of exposure. It costs more than the disease. Swap in your own risks; the register accepts probabilities as 0.4 or 40.
The model
Four risks, each with a probability, an impact, and a priced mitigation.
| Key engineer leaves | 20% × $150K |
| Vendor slips a month | 40% × $80K |
| Scope grows mid-build | 50% × $60K |
| Data migration fails | 10% × $200K |
| Mitigations | priced against exposure |
Once it is in your sheet
- The model arrives with real numbers in it and runs as it stands, so you can press the button first and understand it second.
- Change the numbers to yours. The sheet marks which cells are inputs and which hold formulas, and most labels carry a note explaining the row.
- Press the run button at the bottom of the panel. It is labeled for the tool you are in, and the result lands on its own tab, with a written reading of it beside the figures.
Never used Google Sheets? Start here goes the whole way, in seven steps, and assumes nothing.
Next question
- Which office wins once you price the commute?Where Should the Office Be?
- Should you announce your format before they do?Standards War: Which Format to Back?
- Which task should you actually chase?Office Move: What Sets the Date?
- How much of the schedule is hidden padding?Certification: Buffer the Chain, Not the Tasks
- How few nurses can cover every hour of your unit?How Many Nurses Does Each Shift Need?
- Is this security control worth the budget line?Is This Security Control Worth It?
Every model like this one, and the method behind them: Schedule risk analysis.