Hazard Vulnerability Matrix Worksheet

Assignment Instructions

Hazard Vulnerability Matrix Worksheet

You completed the Hazard Vulnerability Matrix Worksheet to begin the process in developing your HVA. Over the next 2 weeks you will utilize the Matrix to complete the Hazard Vulnerability Assessment Worksheet (one worksheet for each type of hazard; manmade, technological, natural) (adapted from FEMA course IS559). This tool assists the Emergency Manager in determining the probability and severity of the hazard. The goal is to identify the hazards that pose the greatest risk to your community. Should you not have any information available regarding a hazard, make that known in the cell associated with the hazard and item of consideration.

Keep in mind that the more meticulous you are the less problems you will have when you develop your EOP in EDMG220.

Instructions

1. Download the EDMG101 HVA Vulnerability.xlsx.  This contains a cover sheet and 3 blank tabs to fill–Natural, Technological, and Human.
2. Fill out your name and date on the cover tab.
3. Copy the hazards you identified in all 3 tabs from the HVA Matrix.  Rate the hazard 1-5 in each of the column categories.  The vulnerability index will be calculated from your inputs.
4. Add your first initial and last name to the filename. ie: AJones HVA Vulnerability.xlsx
5. Submit here in the classroom.

Supporting Materials

•  EDMG101 HVA Vulnerability.xlsx (16 KB)
•  Hazard Vulnerability Assessment Worksheet-Instructions.pdf (16 KB)
•  Hazard Vulnerability Assessment Worksheet-example.pdf (62 KB)

  Toolkit IS-559 / G-556

  11

  Hazard Vulnerability Assessment Spreadsheet– Completed Example Location/Facility: Manatee County Date Completed: 01/05/11 Completed by: EM This table has been adapted from a Microsoft Excel spreadsheet for inclusion in this Toolkit as an example of a system your community could implement. Scoring instructions are included after the table.

  Type of Hazard Historical Occurrence

  Prob. of Occurrence

  Human Impact

  Property Impact

  Business Impact

  Mitigation Activities

  Internal Resources

  External Resources

  Total

  Civil Disturbance* 1 1 1 1 1 3 3 3 0.3 Communications Failure

  3 2 3 1 3 3 3 4 2.0

  Coastal Oil Spill* 1 1 1 2 2 2 1 3 1.1 Computer Crime/Virus/ Software Failure

  1 1 1 3 3 3 3 3 1.2

  Drought* 1 1 2 3 3 3 2 3 1.6 Epidemic 1 2 3 3 3 3 3 4 2.0 Fire: Brush & Forest*

  2 2 2 3 2 4 4 4 1.6

  Fire: Structural 1 1 3 3 3 4 4 4 1.3 Flooding: Short Duration *

  4 4 3 2 2 3 3 3 3.2

  Flooding: Freshwater*

  4 4 2 2 3 3 3 3 3.2

  Flooding: Drainage*

  3 3 2 2 2 4 3 3 2.2

  Flooding: Coastal Tidal*

  1 2 4 4 4 4 3 4 2.6

  Freeze* 1 1 1 2 2 2 2 3 1.0 Gas Leak 1 1 2 2 2 3 3 3 1.0 Hazardous Material Spills: *

  0.0

  a. Roadways * 2 3 1 2 1 3 2 4 1.7 b. Air* 1 1 3 1 3 3 2 4 1.2 d. Pipeline* 1 1 2 1 2 3 3 4 0.7 e. Rail Systems* 1 1 2 1 1 2 3 4 0.6

   

   

  Toolkit IS-559 / G-556

  12

  Type of Hazard Historical Occurrence

  Prob. of Occurrence

  Human Impact

  Property Impact

  Business Impact

  Mitigation Activities

  Internal Resources

  External Resources

  Total

  Hurricanes* 1 2 4 4 4 3 3 3 2.8 Lightning 4 4 3 1 1 3 3 4 2.7 Mass Immigration* 1 1 2 1 1 3 4 4 0.3 Military Conflict 1 1 1 1 1 1 3 5 0.3 Plane/Train/Auto Crash

  2 2 2 2 2 3 3 5 1.4

  Power Failure 2 2 2 1 2 4 3 5 1.1 Severe Weather/Storms *

  3 3 2 2 2 3 3 4 2.2

  Sinkholes/ Subsidence*

  1 1 1 1 1 1 1 1 1.0

  Terrorism 1 1 3 2 2 4 3 5 0.9 Theft/Vandalism 2 2 3 3 3 4 4 4 2.0 Thunderstorm 3 3 1 1 1 3 3 4 1.6 Tornado* 2 2 3 3 2 4 4 4 1.8 Tropical Storm * 2 3 3 3 3 3 4 4 2.6 Water Pipe Break 3 3 2 2 2 3 3 3 2.3 Weapons of Mass Destruction: Chemical/ Biological/Nuclear

  1 2 4 3 3 4 3 5 2.0

  Wildfires 2 2 3 3 2 4 4 4 1.8 Workplace Violence

  1 1 2 1 2 3 3 3 0.8

  Work Stoppage 1 1 2 1 3 1 1 1 1.7 Analysis Results: High Risk: Greater than 3.5 Medium Risk: 2.0 to 3.5 Low Risk: Less than 2 * Hazards of Concern as per HVA

   

   

   

   

   

  Adapted from Manatee County Florida’s Hazard Vulnerability Analysis