Risk Management Plan Template in Excel

Risk Management Plan Template in Excel

 A risk management plan is a document that a project manager prepares to foresee risks, estimate impacts, and define responses to risks. 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.

Risk Management Plan Template Divide to 5 sheets

A-Risk Management Plan sheet:
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.
Risk Management Plan sheet
Risk Management Plan sheet

B-Risk Analysis Summary Sheet:
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.
Risk Analysis Summary Sheet
Risk Analysis Summary Sheet

C-Risk Response Summary Sheet:
Prioritize and describe the plans for responding to each risk identified and evaluated in Section C
Risk Response Summary Sheet
Risk Response Summary Sheet

D-Risk Mitigation Cost Sheet:
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. 
Risk Mitigation Cost Sheet
Risk Mitigation Cost Sheet

E-Contingency (Risk) Budget Sheet:
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.
Contingency (Risk) Budget Sheet
Contingency (Risk) Budget Sheet

Download also:

Post a Comment

Previous Post Next Post