Research for the AASHTO Standing Committee on Planning. Task 126. Development of a Risk Register Spreadsheet Tool

Since the American Association of State Highway and Transportation Officials (AASHTO) published the AASHTO Transportation Asset Management Guide: A Focus on Implementation in 2011, AASHTO and the Federal Highway Administration (FHWA) have been funding additional research projects that will add depth the different areas of the guide that need it. The Guide provides important information and guidance on a number of areas -- from developing a Transportation Asset Management Plan (TAMP) to addressing risk to developing a data governance plan. More tools and resources are needed, however, for to aid Departments of Transportation (DOTs) in fully implementing asset management. One of the areas where more tools and guidance are needed is risk. Risk management is a process for identifying sources of risk, evaluating them, and integrating mitigation actions and strategies into the routine business functions of the agency. Risk is associated with uncertainty. Risk management should be viewed as a core business tool that influences all activity and not as an isolated, add-on process. Integration of risk management into transportation asset management is relatively new, and has focused thus far on bridges and tunnels. However, all types of transportation assets have uncertainty and risk factors associated with them. An individual agency's approach to risk management will depend on the agency's goals and objectives and therefore the risks associated with individual assets should translate immediately into risks for the agency; the consequences and effects of all risk events must therefore be considered at the agency level too. Moving Ahead for Progress in the 21st Century Act (MAP-21) requires state DOTs to develop risk-based asset management plans. Developing a risk register spreadsheet tool will help states address risk within their transportation asset management plans. The results of a 2011 international scan conducted on this topic are summarize in the report, Transportation Risk Management: International Practices for Program Development and Project Delivery; the report is available at: The purpose of this research is to develop a risk register spreadsheet tool that State DOTs can use to assist them in assessing and addressing risk within their transportation asset management plans (TAMP) at the program level. It should be noted that this information should be developed before any IT solutions can be considered. The objectives of this research are to develop a risk register spreadsheet tool(s) that allows the user to (1) define risk categories, and (2) assess the likelihood and consequence of an event occurring, that is applicable at the enterprise and program level. The tool should enable an agency to identify risk types, assess the consequences and probability of risk, and provide guidance on preparing risk statements. Different agencies should be able to modify the tool for their particular needs. The spreadsheet tool(s) should also allow an agency to generate heat maps showing the results of risk responses on other risks within the same category of risk to support decision making relative to selecting risk responses.


  • English


  • Status: Completed
  • Funding: $115000
  • Contract Numbers:

    Project 08-36, Task 126

  • Sponsor Organizations:

    National Cooperative Highway Research Program

    Transportation Research Board
    500 Fifth Street, NW
    Washington, DC  United States  20001

    American Association of State Highway and Transportation Officials (AASHTO)

    444 North Capitol Street, NW
    Washington, DC  United States  20001

    Federal Highway Administration

    1200 New Jersey Avenue, SE
    Washington, DC  United States  20590
  • Project Managers:

    Goldstein, Lawrence

  • Performing Organizations:

    Parsons Brinckerhoff, Incorporated

    New York, NY  United States 
  • Principal Investigators:

    O'Har, J

  • Start Date: 20150428
  • Expected Completion Date: 20160731
  • Actual Completion Date: 0
  • Source Data: RiP Project 40783

Subject/Index Terms

Filing Info

  • Accession Number: 01598839
  • Record Type: Research project
  • Source Agency: Transportation Research Board
  • Contract Numbers: Project 08-36, Task 126
  • Files: TRB, RiP
  • Created Date: May 4 2016 1:00AM