SHRP2 Risk Management Template User Guide

SHRP2 RISK MANAGEMENT TEMPLATE

Risk Management and Analysis Software for Highway Construction Projects

User Guide

April 2018

TECHNICAL REPORT DOCUMENTATION PAGE

1. Report No. FHWA4. Title and Subtitle

2. Government Accession No.

USER GUIDE SHRP2 RISK MANAGEMENT TEMPLATE

3. Recipient's Catalog No.

5. Report Date April 2018

6. Performing Organization Code:

7. Author(s) Shrivatsa Ravikumar, Paul Dalbey and Jerry DiMaggio

8. Performing Organization Report No.

9. Performing Organization Name and Address Applied Research Associates, Inc. 100 Trade Center Champaign, IL 61820 12. Sponsoring Agency Name and Address Federal Highway Administration U.S. Department of Transportation 1200 New Jersey Avenue, SE Washington D.C. 20590 15. Supplementary Notes FHWA COTR: Carlos Figueroa

10. Work Unit No. 11. Contract or Grant No. DTFH61-12-D-00016

13. Type of Report and Period 14. Sponsoring Agency Code

16. Abstract

The User Guide for the SHRP2 Risk Management Template provides comprehensive

guidance for use and interpretation of results for the Risk Management Template. The User Guide

provides step by step procedures, definition of input and output variables and screen images of

template steps. The User Guide is also included within the Excel-based tool to provide convenient

and direct access to users.

The SHRP2 Risk Management Template, an Excel-based tool, was developed to aid

transportation agencies to conduct a risk management process. This tool is based on the

concepts presented in the SHRP2 Report S2-R09-RW-2: Guide for the Process of Managing Risk on

Rapid Renewal Projects. The SHRP2 R09 publication presents guidance on the application of risk

management methods during the project development, delivery and operation phases that are

consistent with transportation agency practices.

The SHRP2 Risk Management Template can assist risk management personnel from state

and local agencies to optimize project performance (at individual or network level) by

identifying, assessing, and mitigating potential risks, including threats and opportunities. These

threats and opportunities can result in a significant impact to construction cost, schedule, and

traffic disruption.

17. Key Words

18. Distribution Statement

User Guide, SHRP2, Risk Management,

No restrictions. This document is available to

Analysis Template

the public through the National Technical

Information Service, Springfield, VA 22161.



19. Security Classif. (of this

20. Security Classif. (of this

21. No. of

22. Price

report) Unclassified

page) Unclassified

Pages

78

Form DOT F 1700.7 (8-72)

Reproduction of completed page

Table of Contents

1.0. Preface.............................................................................................................. 5 1.1 Purpose and Objectives ......................................................................................... 5 1.2 Background and Limitations.................................................................................. 6 1.3 General Guidance.................................................................................................. 6 1.4 Template Organization........................................................................................... 7

2.0. Getting Started ............................................................................................... 10 2.1. System Requirements........................................................................................ 10 2.2. Accessing the SHRP2 Risk Management Template ..................................... 10

3.0. Project Home.................................................................................................. 17 3.1. Project Information............................................................................................... 18 3.2. Risk Management Template Steps .................................................................... 19 3.3. Project Reset ......................................................................................................... 20 3.4. Summary Report ................................................................................................... 21

4.0. Project Structuring .......................................................................................... 22 4.1. Create Project ...................................................................................................... 24 4.2. Analysis................................................................................................................... 24 4.3. Schedule................................................................................................................ 26 4.4. Lag .......................................................................................................................... 31 4.5. Cost......................................................................................................................... 34 4.6. Disruption ............................................................................................................... 36 4.7. Operations, Maintenance, and Replacement (OMR)................................... 38

5.0. Risk Identification ........................................................................................... 41 5.1. Risk Label ............................................................................................................... 41 5.2. Project Phase Inputs............................................................................................. 42 5.3. Retire Risk ............................................................................................................... 43 5.4. Data Entry Options ............................................................................................... 44 5.5. Clearing Data Entries ........................................................................................... 45

6.0. Rating Scale ................................................................................................... 46 6.1. Risk Scale Entries ................................................................................................... 46

7.0. Unmitigated Risk Assessment ....................................................................... 49 7.1. Conducting Unmitigated Risk Assessment ....................................................... 49

i

SHRP2 Risk Management Template | User Guide

7.2. Unmitigated Risk Assessment Data Entries........................................................ 50 7.3. Unmitigated Mean Severity Calculations......................................................... 52 8.0. Unmitigated Risk Register .............................................................................. 53 9.0. Unmitigated Project Performance................................................................ 56 9.1. Schedule Duration Assumption .......................................................................... 56 9.2. Unmitigated Project Performance and Schedule .......................................... 57 10.0. Unmitigated Risk Ranking Plots..................................................................... 59 11.0. Risk Mitigation ................................................................................................ 60 11.1. Risk Mitigation Parameters ................................................................................ 60 11.2. Risk Mitigation Strategies ................................................................................... 61 11.3. Create Registers ................................................................................................. 63 12.0. Mitigation Strategies Register ....................................................................... 64 13.0. Mitigated Risk Register .................................................................................. 66 14.0. Mitigated Project Performance .................................................................... 69 14.1. Schedule Duration Assumption ........................................................................ 69 14.2. Mitigated Project Performance and Schedule ............................................. 69 15.0. Mitigated Risk Ranking Plots ......................................................................... 72 16.0. Summary Report ............................................................................................ 73 References................................................................................................................... 75

ii

SHRP2 Risk Management Template | User Guide

List of Figures

Figure 1. Organization of SHRP2 Risk Management Template .................................. 9 Figure 2. SHRP2 Risk Management Template Home Screen.................................... 17 Figure 3. Project Information ......................................................................................... 18 Figure 4. Risk Management Template steps ............................................................... 19 Figure 5. Project Reset Button ....................................................................................... 20 Figure 6. Project reset warning screen......................................................................... 21 Figure 7. Summary Report Button ................................................................................ 21 Figure 8: GUI for user input............................................................................................. 22 Figure 9. Project Structuring ........................................................................................... 23 Figure 10. Project Structuring Navigation .................................................................... 23 Figure 11. Project Analysis .............................................................................................. 24 Figure 12. Project Analysis GUI input Form .................................................................. 25 Figure 13. Schedule example in Project Structuring step ......................................... 28 Figure 14. Schedule GUI input Form ............................................................................. 30 Figure 15. Schedule Lag................................................................................................. 31 Figure 16. Example of Schedule Lag for D-B-B Project.............................................. 32 Figure 17. Example Schedule Lag for D-B Project...................................................... 33 Figure 18. Project costs per phase in $million ............................................................. 34 Figure 19. Project Cost GUI input form ......................................................................... 35 Figure 20. Project Disruption GUI input form ............................................................... 36 Figure 21. Disruption table per project phase ............................................................ 37 Figure 22. OMR summary Information.......................................................................... 39 Figure 23. OMR GUI input form...................................................................................... 39 Figure 24. Project Information Summary...................................................................... 40 Figure 25. Risk Identification input form ....................................................................... 41 Figure 26. Risk Labels....................................................................................................... 42 Figure 27. Risk Descriptions............................................................................................. 42 Figure 28. Project Phase Selection ............................................................................... 43 Figure 29. Risk Retirement Selection ............................................................................. 43 Figure 30. User Warning .................................................................................................. 45 Figure 31. Rating scale base information .................................................................... 46 Figure 32. Percent Cost Change GUI input form ....................................................... 47 Figure 33. Percent Cost Change (Form)...................................................................... 47 Figure 34. Absolute Cost Change GUI input form...................................................... 48 Figure 35. Absolute Cost Change (Form).................................................................... 48 Figure 36. Unmitigated Risk Assessment Form............................................................. 49 Figure 37. Conducting Unmitigated Risk Assessment ................................................ 49

iii

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download