Benefit-Cost Analysis Input Worksheet for TRLF Applicants
Instructions
For an electronic (Excel) copy of this worksheet that's easier to complete—with drop-down menus and
dynamic default values— contact John Wilson (e-mail and phone below).
To enable basic benefit-cost calculations by the review team, enter information in the highlighted areas
within Project Definition, Traffic Profile, and Cost Estimates tabs. (Cells will change color from yellow to
For an evaluation of expected growth over the 20-year planning horizon, traffic analysis should be
performed for two time periods: one historical and one a future projection.
Where available, default values are shown. These may be overridden with project-specific data, or the
defaults can be accepted by typing "D" in the highlight box. Because some defaults depend on Project
Any free-form supporting notes can be included next to the data input.
Questions? Please contact John Wilson, Office of Capital Programs and Performance Measures
john.wilson@state.mn.us
(651) 366-3732
inst Page 1 of 4 11/24/2011
Benefit-Cost Analysis Input Worksheet for TRLF Applicants
Project Definition
Geographic Area
Roadway Facility
Baseline
"Build" Alternative
First Year of Construction
Duration of Construction (years)
First Year of Traffic Analysis
Final Year of Traffic Analysis
Roadway Length (mi)
Baseline
"Build" Alternative
Number of Lanes
Baseline
"Build" Alternative
Days of Week Analyzed
Average Daily Traffic
Baseline
"Build" Alternative
Average Speed (MPH)
Baseline
"Build" Alternative
def Page 2 of 4 11/24/2011
Benefit-Cost Analysis Input Worksheet for TRLF Applicants
Traffic Profile
Project Value or Default
"D"efault Value
Hours of Congested Operation (Length of Daily Peak Period)
Existing 2
Future 2
Truck Percentage
Baseline 8%
"Build" Alternative 8%
Average Vehicle Occupancy Ratios
Non-Peak
Baseline Geog. Area?
"Build" Alternative Geog. Area?
Peak
Baseline Geog. Area?
"Build" Alternative Geog. Area?
Crash Statistics for Future Year (0000)
Annual Count or Rate per 100 Million VMT?
Fatal
Baseline Roadway?
"Build" Alternative Roadway?
Personal Injury
Baseline Roadway?
"Build" Alternative Roadway?
Property Damage
Baseline Roadway?
"Build" Alternative Roadway?
prof Page 3 of 4 11/24/2011
Benefit-Cost Analysis Input Worksheet for TRLF Applicants
Cost Estimates
Project Value Default
or "D"efault Value
Estimate Year (to adjust for inflation) 2010
Initial Capital Costs
Preliminary Engineering
Right of Way
Major Structures
Roadway
Annual Maintenance per Lane-Mile
Baseline $9,000
"Build" Alternative $9,000
Cost Type
Other Capital or Maintenance Costs Year (C or M) Amount
example 2018 M $230,000
cost Page 4 of 4 11/24/2011