Spreadsheet: 693335d1598929249-get-a-subset-of-large-table-with-only-top-values-book2
Sheet: Project risk register

Status | Risk Type | Risk Category (For Operational Risks) | Project Program Risk Category | Risk Library | Other Stakeholder | Risk title | Project Risk Phase | Product Code ID | Project ID | Program Name | Risk Description (optional - if additional information is required) | Risk Owner | Risk Owner not listed | Risk Owner (if not listed) | Date | Risk Review Date | Causes | Consequences | Other Causes | Other Consequences | Pre-Existing Control Risk Rating - Total Score | Pre-Existing Control Risk Rating - Rating | Pre-Existing Control Risk Rating - Likelihood | Pre-Existing Control Risk Rating - Consequence | Existing Controls | Other Controls | Current Rating - Total Score | Current Rating - Rating | Current Rating - Likelihood | Current Rating - Consequence | Is further treatment required? | Treatments | Treatments if not listed | Post Treatment Risk Rating - Total Score | Post Treatment Risk Rating - Rating | Post Treatment Risk Rating - Likelihood | Post Treatment Risk Rating - Consequence | Residual Risk Likelihood - Cost pc | Cost - Best Case | Cost - Most Likely | Cost - Worst Case | P50 cost | Basis of Valuation of P50 cost impact calculation | P90 cost | Basis of Valuation of P90 cost impact calculation | Residual Risk Likelihood - Schedule pc | Schedule - Best Case | Schedule - Most Likely | Schedule - Worst Case | P50 days | Basis of Valuation of P50 schedule impact calculation | P90 days | Basis of Valuation of P90 schedule impact calculation
1
 | Project |  |  |  |  | Telecom Infrastructure impacting the project program | Delivery | TPH034-UT Utility services - Delivery | P0019572 |  |  | [NAME] |  |  |  | 2020-07-20 00:00:00 |  |  | Inadequate investigations of existing utilities and drainage system and design methodology | -Asset Damage during construction works -Program delay and cost increase |  |  | 5 - Very Likely | 4 - Major |  | -Design validation/ Potholling to ensure no impact on existing utilities |  |  | 3 - Unlikely | 4 - Major | No |  |  |  |  |  |  | 0.6 |  |  |  |  | Base Estimate of Telcom risks $1,800,000 BC - Minor additional works and utility protection ML - Moderate protection works and/or redesigns and certification. Additional investigation and modfication to staging of works. Delays to program WC - Costs of investigation, protection and additional relocation scope not accounted for during design |  |  | 0.8 | 10
 | Project |  |  |  |  | Endeavour Energy Infrastructure impacting the project program | Delivery | TPH034-UT Utility services - Delivery | P0019572 |  |  | [NAME] |  |  |  | 2020-07-20 00:00:00 |  |  | Inadequate investigations of existing utilities and drainage system and design methodology | -Asset Damage during construction works -Program delay and cost increase |  |  | 5 - Very Likely | 4 - Major |  | -Additional potholes for reliability of the data and to ensure no impact due to drainage/pavement works on existing utilities -Coordinate with EE regarding agreed Specifications regarding working in close proximity of the 132kv feeders during construction works -Coordination with Jacobs for alternate pav designs with reduced box out depth and stabilised materials to limit the compaction effort. |  |  | 3 - Unlikely | 4 - Major | No |  |  |  |  |  |  | 0.6 |  |  | 1000000 |  | Base Estimate of EE Risks $1,000,000 BC - 20% of WC ML - Delay and slower production WC - Costs of investigation, protection and redesign due to 132Kv transmission line |  |  | 0.8 | 10
 | Project |  |  |  |  | Sydney Water Infrastructure impacting the project program | Delivery | TPH034-UT Utility services - Delivery | P0019572 |  |  | [NAME] |  |  |  | 2020-07-20 00:00:00 |  |  | Inadequate investigations of existing utilities and drainage system and design methodology | -Asset Damage during construction works -Program delay and cost increase |  |  | 4 - Likely | 4 - Major |  | -Design validation/ Potholling to ensure no impact on existing utilities |  |  | 3 - Unlikely | 4 - Major | No |  |  |  |  |  |  | 0.6 |  |  | 340000 |  | Base Estimate of SW risks $340,000 BC - Minor additional works and utility protection ML - Moderate protection works and/or redesigns and certification. Additional investigation and modfication to staging of works. Delays to program WC - Major relocation of DN300, Costs of investigation, protection and additional relocation scope not accounted for during design |  |  | 0.8 | 10
 | Project |  |  |  |  | There is currently no allowance for contamination or asbestos in the cost estimate | Delivery | TPH034-MP Project Management - Delivery | P0019572 |  |  | [NAME] |  |  |  | 2020-07-20 00:00:00 |  |  | Encounter contaminated material or asbestos in the excavated material. | Contaminated material needs to be removed and disposed off increasing the cost of the project |  |  | 3 - Unlikely | 4 - Major |  | -Conduct a waste classification report for the project -Undertake investigations to determine if there has been any found on the current RMS project - Showground Rd widending (east of Carrington Rd) - ask [NAME]. -Geotech report did not find any contaminated land. Potential for asbestos in pipes/conduits/pits. No old fill sites anywhere in this area, all old farming land. General allowance is made in the cost estimate for contamination. |  |  | 2 - Very Unlikely | 4 - Major | No |  |  |  |  |  |  | 0.5 |  |  | 300000 |  | Base Estimate of Contamination or asbestos removal $300,000 BC - Small Find of asbestos 100m3 ML - Substantial amount of asbestos 200m3 WC - Large amount found 500m3 |  |  | 0.6 | 10
 | Project |  |  |  |  | Site Compound & Laydown Areas not approved | Delivery | TPH031-AAP Acquired real estate Properties | P0019572 |  |  | [NAME] |  |  |  | 2020-07-20 00:00:00 |  |  | Ongoing negotiation with land owners | Contractor mobilisation delay |  |  | 4 - Likely | 5 - Severe |  | -Finalise negotiation with land owners to aggree on a lease arrangement |  |  | 3 - Unlikely | 4 - Major | No |  |  |  |  |  |  | 0.4 |  |  | 200000 |  | Base Estimate of site compound not approved $200,000 BC - Small delay in site possession 1 weeks ML - Substantial delay 2 weeks  WC - Long delay 1 month |  |  | 0.6
 | Project |  |  |  |  | During construction, the project will need to ensure that the Intersection is in place for morning peak | Delivery | TPH034-MP Project Management - Delivery | P0019572 |  |  | [NAME] |  |  |  | 2020-07-20 00:00:00 |  |  | Arising issues during out of hours construction results in delay in road opening | Traffic delays and disruption |  |  | 4 - Likely | 4 - Major |  | -Understand limitations of the ROL.  -Ensure constructability of the design is achievable within hours available for access - Consider alternate construction methods or materials that would support a faster construction - Provide clear informaton to the contractor during tender to advise of network access restrictions and ROLs expected so that this is considered in their tender program - Enable the contractor to establish an effective relationship with TMC to seek suitable and adequeate ROLs |  |  | 4 - Likely | 3 - Moderate | No |  |  |  |  |  |  | 0.5 | 30000 |  | 120000 |  | Base Estimate of night work risks $120,000 BC - Additional Management of works in line with TMC requirements  ML - Additioanal Nights shifts required to completed scope of work  WC - Additional Nights shifts required to completed scope of work |  |  | 0.8 | 10
 | Project |  |  |  |  | Property Adjustment  Works on Showground Rd | Delivery | TPH034-MP Project Management - Delivery | P0019572 |  |  | [NAME] |  |  |  | 2020-07-20 00:00:00 |  |  | Delays caused by property owners not giving approval for access to private property for adjustment [NAME]. | Delay to the overall program, potential costs to 'buy' access |  |  | 5 - Very Likely | 4 - Major |  | -Continued early community engagement negotiation of property adjustment to achieve early consent, -Ensure early engagement with property owner to have all approvals in place. |  |  | 4 - Likely | 3 - Moderate | No |  |  |  |  |  |  | 0.6 | 25000 |  | 90000 |  | Base Estimate of Property Access $90,000 BC - Slight diviation from design ML - Compensation to property owner to allow access WC - Major Dispute to access Property |  |  | 0.75 | 10
 | Project |  |  |  |  | Access is required to easements on private property 122 Showground Rd to build drainage | Delivery | TPH034-MP Project Management - Delivery | P0019572 |  |  | [NAME] |  |  |  | 2020-07-20 00:00:00 |  |  | Delays caused by property owners not giving approval for access to private property for adjustments & Drainage works around Utilities | Delay to the overall program, potential costs to 'buy' access |  |  | 5 - Very Likely | 4 - Major |  | -Continued early community engagement negotiation of property adjustment to achieve early consent, |  |  | 4 - Likely | 3 - Moderate | No |  |  |  |  |  |  | 0.6 | 20000 |  | 70000 |  | Base Estimate of easement access $70,000 BC - Slight diviation from design ML - Compensation to property owner to allow access WC - Major Dispute to access Property |  |  | 0.75 | 10
 | Project |  |  |  |  | Reputational damage caused by construction | Delivery | TPH031-ME Community engagement delivery readiness | P0019572 |  |  | [NAME] |  |  |  | 2020-07-20 00:00:00 |  |  | Community complaints and incidents/accidents during construction | -Delay to the overall program and cost increase  -Increase community engagement |  |  | 4 - Likely | 3 - Moderate |  | -Early community engagement with the project  -Provide clear information to the community through media or community consultation plan -Adequate staging for construction works |  |  | 4 - Likely | 2 - Minor | No |  |  |  |  |  |  | 0.5 | 20000 |  | 80000 |  | Base Estimate of Reputational damagel $80,000 BC - Additional management controls and implementation for community management (5hrs per week during heavy contruction period) ML - Additional management controls and implementation for community management. Some additional scope and/or delay added to contractor works. WC - Continuous controls/management required to facilitate works. Allowance for additional $5,000 per month for the contract duration |  |  | 0.8 | 5
 | Project |  |  |  |  | Traffic and Construction Staging | Delivery | TPH034-ICT InfraConstr traffic mgt & temporary work | P0019572 |  |  | [NAME] |  |  |  | 2020-07-20 00:00:00 |  |  | Working under live traffic during utility and drainage work at the Showground Rd/ Carrington Rd Intersection | Traffic Disruption and delayed completion |  |  | 4 - Likely | 4 - Major |  | -Complete modelling on traffic staging to ensure it is sufficient -Contractor responsible for Staging design which requires Roads and Maritime approval as part of their Construction Traffic Management Plan and Road Occupancy Licence approvals from TfNSW Transport Management Centre (TMC). |  |  | 4 - Likely | 3 - Moderate | No |  |  |  |  |  |  | 0.6 | 20000 |  |  |  | Base Estimate of risk in traffic staging $100,000 BC - Delay costs associated with disruption due to additional staging required. (4 nights @ $5,00 per night ) ML - (8 nights @ $5,00 per night ) WC -(20 nights @ $5,00 per night ) |  |  | 0.7 | 10
 | Project |  |  |  |  | Transverse Drainage through Showground Intersection | Delivery | TPH034-MP Project Management - Delivery | P0019572 |  |  | [NAME] |  |  |  | 2020-07-20 00:00:00 |  |  | Inadequate investigations of existing utilities and 132kv where the designed drainage line will be crossing. | -Potential asset Damage during excavation  Construction Delays, cost increase and safety issues |  |  | 4 - Likely | 4 - Major |  | -- Roads and Maritime has carried out significant utility pothole investigations, Jacobs interrogated data provided by [NAME] and Maritime in 100% detailed design stage - 3D digital engineering (federated) design model for utility diversion coordination was developed as part of the 100% design - Risk will be transferred to the contractor with 3D model provided as information -Coordinate with EE regarding agreed Specifications regarding working in close proximity of the 132kv feeders during construction works |  |  | 3 - Unlikely | 4 - Major | No |  |  |  |  |  |  | 0.6 |  |  | 100000 |  | Base Estimate of Road Crossing Drainage risks $100,000 BC - minor investigation and protection works  ML - Slow Production due to adjacent utilities, moderate protection works  WC - Major clashes with utilities and 132kv. Redesign of drainage, protection works certification. |  |  | 0.7 | 15
 | Project |  |  |  |  | Jemena Gas Infrastructure impacting the project program | Delivery | TPH034-UT Utility services - Delivery | P0019572 |  |  | [NAME] |  |  |  | 2020-07-20 00:00:00 |  |  | Inadequate investigations of existing utilities and drainage system and design methodology | -Trees apears to be impacted by utilities  -Asset Damage during work -Program delay and cost increase |  |  | 4 - Likely | 4 - Major |  | -Design validation/ Potholling to ensure no impact on existing utilities |  |  | 3 - Unlikely | 4 - Major | No |  |  |  |  |  |  | 0.4 |  |  | 65000 |  | Base Estimate of Gas risks $65,000 BC - Additional allowance for investigation and protection of utilities.  ML - Delay and slower production WC - Additional investidation and protection works, minor adjustment to adjacent utilities |  |  | 0.8 | 5
 | Project |  |  |  |  | Community become fatigued with the level of road / construction works and the associated disruption | Delivery | TPH031-ME Community engagement delivery readiness | P0019572 |  |  | [NAME] |  |  |  | 2020-07-20 00:00:00 |  |  | Local residents being exposed to numerous projects in quick succession. | Large volume of customer complaints / reputational damage |  |  | 4 - Likely | 3 - Moderate |  | - Aim to minimise construction timelines.  - Develop construction staging plan to maximise work done in the day (where possible) and minimise night work and associated noise impacts etc. - Use strategies that allow us to be proactive and upfront with the community to communicate with them what is happening and what the proposed outcomes. |  |  | 4 - Likely | 2 - Minor | No |  |  |  |  |  |  | 0.5 | 10000 |  | 40000 |  | Base Estimate of construction fatigue $40,000 BC - Delay cost and additional management of works (50Hrs additional works) ML - Delay cost and additional management of works (100Hrs additional works) WC - Delay cost and additional management of works (200Hrs additional works) |  |  | 0.8 | 2
 | Project |  |  |  |  | There are disruptions to bus services during construction works | Delivery | TPH034-MP Project Management - Delivery | P0019572 |  |  | [NAME] |  |  |  | 2020-07-20 00:00:00 |  |  | Impacts from the construction works cause disruption to buses | Reputational damage to Transport for NSW |  |  | 4 - Likely | 3 - Moderate |  | -Engage bus service providers to understand services. -Understand locations of current bus stops and temporary locations.  -Relocate bus stops to allow bus services to continue. |  |  | 3 - Unlikely | 3 - Moderate | No |  |  |  |  |  |  | 0.4 | 8000 |  | 45000 |  | Base Estimate of Bus disruptions  $45,000 BC - Additional Costs and managing of works (50Hrs additional works) ML -  Additional Costs and managing of works (50Hrs additional works plus $8,000 scope) WC -  Additional Costs and managing of works (100Hrs additional works plus $25,000 additioanl scope) |  |  | 0.8 | 2
 | Project |  |  |  |  | Additional Tree Removal | Delivery | TPH031-DE Environmt Assessmt - Delivery readiness | P0019572 |  |  | [NAME] |  |  |  | 2020-07-20 00:00:00 |  |  | Clash between Utilities  and tree Roots 29 Trees has been approved to be removed as part of the REF | [NAME] to REF or REF Review required |  |  | 4 - Likely | 3 - Moderate |  | -Scope review to identify any effected trees by construction works |  |  | 3 - Unlikely | 3 - Moderate | No |  |  |  |  |  |  | 0.5 | 5000 |  |  |  | Base Estimate of additional tree removal $25,000 BC - Small shrub and branch clearing, additional environmental approvals ML - Trees to be removed due to roots obstructing works  WC - Delay or dispute  for trees to be removed |  |  | 0.7 | 2