Risk register (template) – get surprises under control
As promised when I recorded the risk management podcast episodes with Cornelius Fichtner, here is the documentation on my risk register template. Risk management always involves several steps:
risk/opportunity identification
qualitative analysis
quantitative analysis (optional)
response planning
risk/opportunity monitoring & controlling
This template supports the first two and the last two steps, serious quantitative analysis requires specialized tools (click to enlarge):
A crucial aspect of the template is priorization of risks and opportunities based on their probability and impact:
Risks and opportunities are classified as small, middle, high and fatal. This scheme has to be adapted for each organization.
Usage
Goal
Identification, analysis, monitoring and controlling of risks and opportunities
Approach
Identify your risks and opportunities based on documents, interviews and workshops and add short descriptions in the column risk/opportunity.
Add the impact description of the risk or opportunity in the column impact.
Estimate the probability and choose a suitable %-category in the column % (column group Assessment before).
Choose an impact category in the column Impact (column group Assessment before) next. You will get a traffic light in column P (= priority) in the colum group Assessment before. It will be copied into the first column of the sheet.
Add the estimated costs or benefit (negative sign) in the column Cost in the column group Assessment before.
Next are the entries Strategy and Status.
Afterwards you should plan responses to manage risks and opportunities. Describe them in the column Response(s) and add estimated costs for them in the column Action costs.
If you like, you can assess the risks and opportunities based on the planned responses in the column group Assessment after. If there is a traffic light in this column group, it will be copied into the first column of the sheet, overwriting all other values.
The next four columns inform about aspects of changes to the project management plan (time, budget, ressources and quality) based on the risks and opportunities.
There should be a risk owner defined for every risk and opportunity, defining a risk action owner is optional.
Calculation
The values of the choosers are defined in the hidden rows 22 to 29. They are based on best practices in the PMBOK® Guide of the PMI. The matrix of priorities is defined on an extra sheet named priorities. If you add or remove rows or colums in that matrix you need to update the formulas on the first sheet.
You can find the lastest download link for the template on pm-templates.de.
This entry was posted on Donnerstag, 06. Mai 2010 at 10:53 and is filed under Templates, Vorlagen. You can follow any responses to this entry through the RSS 2.0 feed.
Both comments and pings are currently closed.
2 Responses to Risk register (template) – get surprises under control
[…] Erfolgsfaktoren im Risikomanagement empfohlen. Jetzt hat Andreas noch einmal nachgelegt und ein Template für ein englischsprachiges Risk-Register bereitgestellt. Zum Thema Risikomanagement auch gleich noch ein weiterer passender Link zu Lynda […]
[…] This post was mentioned on Twitter by Andreas Heilwagen. Andreas Heilwagen said: Risk register (template) – get surprises under control: http://wp.me/ph8DD-1qs #pmot #pmde […]
Spruch des Tages
»A reasonable probability is the only certainty.« E. H. Howe
Ich habe mich der Weiterentwicklung des Projekt-managements und agilen Vorgehens-weisen (Scrum u.a.) verschrieben. Hier biete ich Ihnen spannendes Wissen und Neuigkeiten, im real life Beratung und die Inspiration zu und Begleitung bei Changes.
Mehr über mich & die Gastautoren...Buchen Sie mich
[…] Erfolgsfaktoren im Risikomanagement empfohlen. Jetzt hat Andreas noch einmal nachgelegt und ein Template für ein englischsprachiges Risk-Register bereitgestellt. Zum Thema Risikomanagement auch gleich noch ein weiterer passender Link zu Lynda […]
[…] This post was mentioned on Twitter by Andreas Heilwagen. Andreas Heilwagen said: Risk register (template) – get surprises under control: http://wp.me/ph8DD-1qs #pmot #pmde […]