Spreadsheet: 09ae7a7e-fc8e-4eba-b5c4-1e2036a9c697
Sheet: 1 - BCA 20-year (Recent)

 | ATTACHMENT 1: BENEFIT-COST ANALYSIS
 | Vasco Road Safety Improvements Project - Phase 2
 | TIGER V Grant Application
 |  | Beneift/Cost Ratio = | Total Benefits | = |  | = |  | (3% Discount)
 |  |  | Total Costs
 |  |  |  |  |  | = |  | (7% Discount)
 | Benefits
 | Calendar Year | Project Year | Affected drivers4 | Average Travel Time saved (veh-hrs)5 | Value of Travel Time Benefits (Surface modes)2,3 | Value of Travel Time Benefits (Truck Drivers)2,3 | Total Value of Travel Time Benefits | Total Present Value of Travel Time Benefits - 3% Discount             (2013 dollars)1 | Total Present Value of Travel Time Benefits - 7% Discount             (2013 dollars)1
 | 2014 | 0 | 23740 | - | 0 | 0 | 0 | 0 | 0
 | 2015 | 1 |  | 0.3
 | 2016 | 2 |  | 0.3
 | 2017 | 3 |  | 0.3
 | 2018 | 4 |  | 0.3
 | 2019 | 5 |  | 0.3
 | 2020 | 6 |  | 0.3
 | 2021 | 7 |  | 0.3
 | 2022 | 8 |  | 0.3
 | 2023 | 9 |  | 0.3
 | 2024 | 10 |  | 0.3
 | 2025 | 11 |  | 0.3
 | 2026 | 12 |  | 0.3
 | 2027 | 13 |  | 0.3
 | 2028 | 14 |  | 0.3
 | 2029 | 15 |  | 0.3
 | 2030 | 16 |  | 0.3
 | 2031 | 17 |  | 0.3
 | 2032 | 18 |  | 0.3
 | 2033 | 19 |  | 0.3
 | 2034 | 20 |  | 0.3
 | Calendar Year | Project Year | Average Annual Injuries Prevented6 | Average Annual Fatalities Prevented6 | Value of Injury Benefits7 | Value of Fatality Benefits7 | Total Value of Collision Benefits | Total Present Value of Collision Benefits - 3% Discount    (2013 dollars)1 | Total Present Value of Collision Benefits - 7% Discount    (2013 dollars)1
 | 2014 | 0 | - | - | 0 | 0 | 0 | 0 | 0
 | 2015 | 1
 | 2016 | 2
 | 2017 | 3
 | 2018 | 4
 | 2019 | 5
 | 2020 | 6
 | 2021 | 7
 | 2022 | 8
 | 2023 | 9
 | 2024 | 10
 | 2025 | 11
 | 2026 | 12
 | 2027 | 13
 | 2028 | 14
 | 2029 | 15
 | 2030 | 16
 | 2031 | 17
 | 2032 | 18
 | 2033 | 19
 | 2034 | 20
 |  |  |  |  |  |  | Total Benefits
 | Costs
 | Calendar Year | Project Year | Project Costs | Operations and [NAME] Costs8 | Total Project Costs | Total Present Value of Collision Costs - 3% Discount    (2013 dollars)1 | Total Present Value of Collision Costs - 7% Discount    (2013 dollars)1
 | 2014 | 0 | 2711750 | 0
 | 2015 | 1 | 5000000 | 0
 | 2016 | 2 | 7288250 | 0
 | 2017 | 3 | 0
 | 2018 | 4 | 0
 | 2019 | 5 | 0
 | 2020 | 6 | 0
 | 2021 | 7 | 0
 | 2022 | 8 | 0
 | 2023 | 9 | 0
 | 2024 | 10 | 0
 | 2025 | 11 | 0
 | 2026 | 12 | 0
 | 2027 | 13 | 0
 | 2028 | 14 | 0
 | 2029 | 15 | 0
 | 2030 | 16 | 0
 | 2031 | 17 | 0
 | 2032 | 18 | 0
 | 2033 | 19 | 0
 | 2034 | 20 | 0
 |  |  |  |  | Total Costs
 | Assumptions:
1 | Discount rate assumed for public expenditures per Federal Office of Management and Budget (OMB) [NAME] and A-94.
 |  | Discount rate |  | 0.03
 |  | Discount rate |  | 0.07
2 | See Attachment 3: Truck Traffic. Percent truck traffic includes buses and is based on Truck Traffic Turning Movement Counts taken by the Contra Costa County
 | Public Works Department from May 12-15, 2008.
 |  | Percent Truck Traffic
3 | Recommended hourly values of travel time savings taken from the US DOT memorandum "Revised Departmental Guidance on Valuation of
 | Travel Time in Economic Analysis (Revision 2 - corrected)".
 |  | Recommended Hourly Value of Travel Time Savings (Table 4, Intercity Personal) |  |  |  |  | 16.7 | per person-hour
 |  | Recommended Hourly Value of Travel Time Savings (Table 4, Intercity Business) |  |  |  |  | 22.9 | per person-hour
4 | See Attachment 2: Traffic Volumes. Affected drivers assuming straight-line approximation (1.5% annual increase) of future traffic volumes from the Contra Costa
 | Transportation Authority Travel Demand Model, 2012.
5 | See Attachment 4: Travel Time Savings. Average travel time saved calculated for peak 15-minute period per Chapter 20 - Two lane Highways, HCM 2000.
 | Assuming a base free flow speed of 65 miles per hour and using vehicular traffic counts taken by the Contra Costa County Public Works Department on Vasco
 | Road - 1 mile South of Camino Diablo on August 5, 2009.
6 | See Attachment 5: Collision History and Attachment 6: 5-year Collision Data. Average annual collisions prevented based on analysis of 2008-2012 collisions data.
7 | See Attachment 7: Collisions Benefits. Collisions Benefits calculated using AIS calculation.
8 | See Attachment 8: Operations & Maintenance Costs for calculations of marginal costs.