Risk Management Plan Excel Template

Risk Management Plan Excel Template

Risk Management Plan Excel Template

A risk management plan is a document that a project manager prepares to foresee risks, estimate impacts, and define responses to issues. It also contains a risk assessment matrix. A risk is "an uncertain event or condition that, if it occurs, has a positive or negative effect on a project's objectives."

This Template includes 5 sheets:

1-Risk Management Plan:
Provide basic information about the project including: Project Title – The proper name used to identify this project; Project Working Title – The working name or acronym that will be used for the project; Proponent Secretary – The Secretary to whom the proponent agency is assigned or the Secretary that is sponsoring an enterprise project; Proponent Agency – The agency that will be responsible for the management of the project; Prepared by – The person(s) preparing this document; Date/Control Number – The date the plan is finalized and the change or configuration item control number assigned.

2-Risk Analysis Summary:
Using the table provided, list all of each risk identified, the probability of occurrence, the expected impact level, a description of the impact, and when the risk event is likely to occur.

3-Risk Mitigation Cost:
Detail the estimated cost for responding to each identified risk. Based on the Risk Response Summary in Section D, identify the cost of responding to a particular risk using the most likely mitigation strategy. The total costs are used to derive the fiscal year contingency budget.
4-Contingency Risk Budget:
Calculate the Contingency Budget for each fiscal year based on the Probability of Occurrence (from Section C) and the Total Cost for mitigation (from Section E) for each risk.
Use one table for each fiscal year and list all risks anticipated for that fiscal year (see Section C). Calculate the Planned Contingency Cost for each risk in the last column, by multiplying the Probability of Occurrence by the Mitigation Cost. Sum the Planned Contingency Cost for all risks anticipated in the fiscal year at the bottom of each table

Post a Comment

Previous Post Next Post