Spreadsheet Question (4 Points) VDOT is looking to install a safety co at an intersection that has been experiencing too many severe crashes. The following countermeasures have been proposed to VDOT. Assume a discount rate of 4% throughout this problem. Project Counter measure Initial Cost Duration Single-lane $1,500,000 roundabout Protected Left $120,000 15 Turn Signal Red-Light $100,000 10 Camera Interchange $15,000,000 Construction It is estimated that for every Fatal/Injury (FI) Crash Reduced an average of $158,000 is saved in the form of a societal cost, while for every Property Damage Crash (PDO), an average of $7,400 is saved. Expected Expected Number of Number of FI Countermeasure PDO Crashes Crashes Saved Saved Annually Annually 1.01 Single-lane roundabout Protected Left Turn Signal Red-Light Camera Interchange Construction Negative Crashes saved implies that this countermeasure will increase expected crashes of this type Spreadsheet Question (4 Points) VDOT is looking to install a safety co at an intersection that has been experiencing too many severe crashes. The following countermeasures have been proposed to VDOT. Assume a discount rate of 4% throughout this problem. Project Counter measure Initial Cost Duration Single-lane $1,500,000 roundabout Protected Left $120,000 15 Turn Signal Red-Light $100,000 10 Camera Interchange $15,000,000 Construction It is estimated that for every Fatal/Injury (FI) Crash Reduced an average of $158,000 is saved in the form of a societal cost, while for every Property Damage Crash (PDO), an average of $7,400 is saved. Expected Expected Number of Number of FI Countermeasure PDO Crashes Crashes Saved Saved Annually Annually 1.01 Single-lane roundabout Protected Left Turn Signal Red-Light Camera Interchange Construction Negative Crashes saved implies that this countermeasure will increase expected crashes of this type