Spreadsheet: 69361d1269899879-excel-2007-multiple-conditionals-risk-and-issue-register-example
Sheet: Risk Log

Risks - 24/03/2010
[NAME] |  |  |  |  | Probability Key |  |  |  | Impact Area Key
High (H) - Critical Path Risk. If realised the resulting issue would immediately impact cost / project delivery dates. |  |  |  |  | High (H) – 90% Probability of risk being realised. |  |  |  | ALL - All BTD Sections BS - Business Services PSO - Payment Systems Oversight A&F - Admin & Financial A&S - Architecture & Security SD - Systems Development QA - Quality Assurance IS - Infrastructure Services
Medium (M) – If realised the resulting issue would cause slippages in deliverable dates, but would not have an immediate effect on overall cost. |  |  |  |  | Medium (M) – 60% Probability of risk being realised.
Low (L) – If realised the resulting issue would not impact delivery dates but could impact the quality of deliverables. |  |  |  |  | Low (L) – 50% Probability of risk being realised.
 | CURRENT RAG STATUS | [NAME] | Description | Impact Area | Mitigation Strategy |  |  | Severity | Probability | Owner | Date Identified | Target Resolution Date | Date Risk Has Been Mitigated | Days Risk Has Been Active | Days Exceeded Target Resolution Date | STATUS
1 |  |  | If building completion date is beyond 31st December 2010. The project is wholly dependant on the building being completed on time. All planning and migration dates revolve around this date. | ALL | Confirm the date with the P&M dept ASAP. 14th March - Update provided by [NAME], and by official letter from P&M Dept. Building completion date will be "end of 2011". BTD will interpret this, for our RFP timelines, to be 30th December 2011. |  |  | H | M | AF | 2009-11-09 00:00:00 | 2010-01-20 00:00:00 | 2010-03-14 00:00:00 | 141 | 53 | CLOSED
5 |  |  | Management staff training is scheduled for July includes managers and deputies. There should be either the manager or deputy available at BTD. | ALL | This will need to be discussed internally to agree the best way forward. |  |  | M | M | AF | 2010-01-08 00:00:00 | 2010-03-01 00:00:00 |  | 81 | 29 | OPEN
6 |  |  | Staff commitments with other projects impacts availability and completion of this project. | ALL | Staff resource plans and availability must be closely managed/monitored by line managers. |  |  | M | L | AF | 2009-11-09 00:00:00 | 2010-04-01 00:00:00 |  | 141 | Not Exceeded | OPEN
7 |  |  | Final building plans are signed off without the BTD input being presented. | ALL | Requirements Gathering Phase must be completed as soon as possible via multiple workshop streams. 14th March - P&M Dept have advised that the building plans, desking and office layouts have already been defined and agreed. |  |  | M | H | AF | 2009-11-09 00:00:00 | 2010-04-20 00:00:00 |  | 141 | Not Exceeded | OPEN
8 |  |  | Holiday periods of key staff will impact the delivery and completion of the project. | ALL | Staff resource plans and availability must be closely managed/monitored by line managers. |  |  | M | L | AF | 2009-11-09 00:00:00 | 2010-07-01 00:00:00 |  | 141 | Not Exceeded | OPEN
9 |  |  | The budget that will be associated with the Response For Proposal (RFP) may be required to be managed through Head Office which could introduce delays to the project procurement activities. | ALL | It is understood that the budget will be managed by BTD through the BTD engagement process of the RFP & existing BTD budget controls, although clarification needs to be provided. |  |  | M | M | AF | 2010-03-09 00:00:00 | 2010-04-28 00:00:00 |  | 21 | Not Exceeded | OPEN