Instructions
Risk and Issues Template
Use this template to track the project's risks and issues. The risk log provides a calculation based on the identified Risk's probability and impact. Probability is a drop down list of: Certain, Expected, Likely, Possible, Unlikely. Impact is a drop down list: Very High, High, Medium, Low and Very Low. - The template also controls issue log items by using the log to update the issue "n" sheet.
General
On the first time to use the template: a) Update the headers on all worksheets to reflect the PROJECT NAME List Identifed Risks and Calculate Risk Rating with suggested meanings Enter or Update the following: a) Risk Number b) Risk description c) Probability (use dropdown list) d) Impact (use dropdown list) e) Risk Rate color will change based on formula If Sorting is desired Sort all lines using the Header Row by Rating (descending) Number (ascending) For additional risks, Insert new rows, and then copy the Complete "template line" (At least cells A-R) and insert it after the last identified risk For Tracking all Issue Items - Log is used to provide information to the specific issue sheet (Issue summary, Responsible Person, Issue Date and Status)
Risk Log 1
2 3 Issue Log
file:///opt/scribd/conversion/tmp/scratch6234/81668630.xls
Instructions
Enter the following on the Issue Log worksheet: a) Next sequential issue number b) Issue description c) Name of person assigned/responsible for the issue d) Date the issue is being added e) Status (use the dropdown list) For tracking details of each identified Issue Make a copy of the Issue Template worksheet by right clicking on its label - choose "Move or Copy". Choose both (move to end) and create a copy. Rename the copy of the Issue Template worksheet to "Issue "n" where n = the issue number Link the fields (Issue Description, Name of person Assigned, and Date of Issue) from the Issue Log to the appropriate fields on the Issue worksheet: On the Issue "n" sheet for each field type in "=", then go to the issue log sheet and click on the field there. Hit "enter" and you will come back to the Issue "n" sheet with the value filled in. Enter the following on the Issue worksheet: a) Level - High, Medium or Low b) Class - Impact Area c) Originator d) A brief description of the consequences Update the Resolution with the steps completed to resolve the issue. At a minimum, this should include the date, action taken, who took the action. This should reflect a historical sequence of events Make any changes to Issue Description, Person responsible or status in the issue log and they will be updated in the Issues Worksheet
Issues worksheet 1 2 3
file:///opt/scribd/conversion/tmp/scratch6234/81668630.xls
<Insert Project Name>
Risk Log
Number 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 Legend:
Risk Example
Probability Certain
Impact High
Rating 0.7125 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
Contingency Plan
Mitigation Plan
Minimum risk - Acceptable Some risks - Monitor at PM/Team Level High risks - Active monitoring with ongoing Contingency/Mitigation activity Show stoppers - Active participation with steering committee to mitigate
file:///opt/scribd/conversion/tmp/scratch6234/81668630.xls
<Insert Project Name>
Issue Log
Issue No. 1
Issue Example
Person Responsible Project Manager
Date Opened Month/Day/year 03/15/07
Status Open
file:///opt/scribd/conversion/tmp/scratch6234/81668630.xls
<Insert Project Name>
Issue Template
Issue No. (From Issue Log) 1
Responsible Party (From Issue Log) Project Manager
Level (High, Medium, Low)
Class (Impact Area)
Date Opened (From Issue Log) 03/15/07
Date Closed
Originator
Status (From issue Log) Open
Issue (From Issue Log) Example
Consequence(s) If not resolved this issue could delay the project by 30 days, resulting in a fine for non-compliance
Resolution
Hiring a contractor could resolve this delay at a cost less than the fine for non-compliance
file:///opt/scribd/conversion/tmp/scratch6234/81668630.xls
