Transcript Reporting Requirements - The American Recovery and

The American Recovery and Reinvestment
Act of 2009
Reporting Overview
Federal Highway Administration
August, 2009
Accountability and Transparency
“Every American will be able to hold
Washington accountable for these decisions
by going online to see how and where their
tax dollars are being spent.”
- President Barack Obama
2
Reports Produced by FHWA









Weekly report on projects with notice to proceed
Weekly report on obligated projects
Monthly report on jobs
Quarterly NEPA report to President’s Council on
Environmental Quality (CEQ) – 1609
Quarterly report for States – 1512
Quarterly performance reports
Periodic reports to Congress – 1201(c)
Periodic reports to GAO
Miscellaneous – EDA, DBE, “Green Projects”, SBA etc
3
Reporting Challenges

Implementation
–
–
–


Tight schedule
Changing requirements
Non-sequential development
Data quality and consistency
Approach has changed
–
–
–
Initially Excel forms submitted via e-mail to FHWA
Evolved into web based application
Second generation currently being developed
4
New Reporting Requirements





Added additional OMB required data
Reorganized to minimize redundant data
Monthly data down to 10 data items (5 are
reference data i.e. State, month, project
numbers etc)
Comma delimited format, no Excel option
New screens in RADS will allow for mass
editing, similar to Excel or Access
5
RADS - Recovery Act Data System

Used for ARRA related:
–
–
–
–



Data submittal
Reports
Analysis
Reviews
Independent system that interfaces with other data
systems
Developed as a secure web application with a robust
SQL Server database
Integrated GIS interface for spatial analysis and
mapping
6
Data Model
Conceptual Overview
Jobs, Awards
& Project
Information
- State reported data
- Existing FHWA data
- New FHWA database
Finance Data –
FMIS
DELPHI
RADS Data Integration,
Analysis, &
Reporting
- FHWA generated reports
7
Other Data Bid Tab
DUNS
EDA
Reports, Maps,
and Charts
Information Flow Diagram
1201(c)
1609
Congress
Collect, Compile, & Report
Compliance
Review
Filing employment data
Recovery.gov
FHWA HQ
Virginia Division
Review, Report, & Summarize
OST
1512
Texas Division
RADS
Virginia DOT
Contractor A
State DOT
Texas DOT
Local B
Contractor C
Contractor B
8
Local D
Contractor D
Reports Produced by FHWA









Weekly report on projects with notice to proceed
Weekly report on obligated projects
Monthly report on jobs
Quarterly NEPA report to President’s Council on
Environmental Quality (CEQ) – 1609
Quarterly report for States – 1512
Quarterly performance reports
Periodic reports to Congress – 1201(c)
Periodic reports to GAO
Miscellaneous – EDA, DBE, “Green Projects”, SBA etc
9
Latest Data

Obligations
–
–
–

50 States, Federal Lands, District of Columbia, Puerto
Rico, Guam, Northern Marianas and the Virgin Islands
6,144 projects
$17.331 Billion
Notice to proceed
–
–
–
50 States, Federal Lands, District of Columbia, and
Puerto Rico
2,534 projects
$7.941 Billion
10
Obligations
Improvement Type
Bridge Improvement
Bridge Replacement
New Bridge Construction
New Construction
Other
Pavement Improvement
Pavement Widening
Safety/Traffic Management
Transportation Enhancements
Grand Total
Number of
Projects
361
404
36
88
569
3,677
200
410
399
6,144
11
Total ARRA Funds Percent of Percent of
Obligated
Projects
Funds
$908,757,115
5.9%
5.2%
$822,011,142
6.6%
4.7%
$331,130,346
0.6%
1.9%
$1,250,843,047
1.4%
7.2%
$391,773,246
9.3%
2.3%
$8,957,338,457
59.8%
51.7%
$3,270,558,960
3.3%
18.9%
$999,580,023
6.7%
5.8%
$399,331,701
6.5%
2.3%
$17,331,324,037
100.0%
100.0%
Notice to Proceed
Improvement Type
Bridge Improvement
Bridge Replacement
New Bridge Construction
New Construction
Other
Pavement Improvement
Pavement Widening
Safety/Traffic Management
Transportation Enhancements
Grand Total
Number of Total ARRA Funds Percent of Percent
Projects
Obligated
Projects of Funds
156
$371,664,576
6.2%
4.7%
246
$437,176,831
9.7%
5.5%
22
$70,370,906
0.9%
0.9%
35
$522,442,265
1.4%
6.6%
114
$100,955,396
4.5%
1.3%
1,700
$4,640,936,400
67.1%
58.4%
85
$1,374,115,089
3.4%
17.3%
133
$379,032,627
5.2%
4.8%
43
$44,639,273
1.7%
0.6%
2,534
$7,941,333,362
100.0%
100.0%
12
Preliminary Jobs
Total
Monthly
Month
Employees Total Hours
FTE
Total Payroll
March
344
11,661
67
$345,115
April
4,662
152,994
883
$4,407,168
May
18,581
733,093
4,229
$18,313,172
June
22,332
831,105
4,795
Total
45,919
1,728,853
9,974
$23,340,411
Total payroll for June not available.
13
Current Activities

Adjusting RADS to comply with June 22nd OMB
guidance
–
–
–
–


Redesigning database
Developing new data input/editing screens
Revising Reporting Requirements document
Conducting 6 webinars over 4 weeks for States and Divisions
Recently submitted 3 year OMB Paperwork Reduction
Act (PRA) review and waiver request
Gearing up for next round of reports
–
CEQ, Performance Measures, and 1201(c)
14
Questions?
15