City Street Financial Report FY 2013Masterpiece on the Mississippi
TO: The Honorable Mayor and City Council Members
FROM: Michael C. Van Milligen, City Manager
SUBJECT: Fiscal Year 2013 City Street Financing Report
DATE: September 9, 2013
Dubuque
band
AI- America City
1
2007 • 2012 • 2013
Finance Director Ken TeKippe recommends City Council approval of the City of
Dubuque's Fiscal Year 2013 City Street Financing Report.
I concur with the recommendation and respectfully request Mayor and City Council
approval.
htiter4 /'',4„taill,„
Michael C. Van Milligen
MCVM:jh
Attachment
cc: Barry Lindahl, City Attorney
Cindy Steinhauser, Assistant City Manager
Teri Goodmann, Assistant City Manager
Ken TeKippe, Finance Director
Masterpiece on the Mississippi
TO: Mike Van Milligen, City Manager
FROM: Ken TeKippe, Finance Director
DATE: September 9, 2013
SUBJECT: Fiscal Year2013 City Street Financing Report
INTRODUCTION
The purpose of this memorandum is to request that the City Council adopt a resolution approving the City of Dubuque's
Fiscal Year2013 City Street Financing Report.
X
DISCUSSION
The Code of Iowa, Chapter 312, Section 14, provides for the submission of an annual City Street Finance Report to the Iowa
Department of Transportation by September 30, 2013. Failure of the City to submit this report on a timely basis results in the
State withholding Road Use Tax Funds allocated to the City until compliance is achieved.
RECOMMENDATION
I recommend adoption of the enclosed resolution approving the attached annual report and authorize filing with the Iowa
Department of Transportation.
ACTION TO BE TAKEN
The City Council is requested to adopt the attached resolution approving the City Street Finance Report for Fiscal Year 2013.
cc:
Gus Psihoyos, City Engineer
Jenny Larson, Budget Director
RESOLUTION NO. 285 -13
APPROVING THE CITY OF DUBUQUE FISCAL YEAR 2013 CITY STREET
FINANCING REPORT
NOW THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF
DUBQUE, IOWA:
Section 1. That the City Street Finance Report for the period of July 1, 2012, to June
30, 2013, is hereby approved and that the City Clerk is hereby authorized and directed
to file said report with the Iowa Department of Transportation.
Passed, approved and adopted this 16th day of September, 2
Attest:
Kevin irnstahl, ity erk
Roy ' Buol, Mayor
Alowa Department of Transportation
Form 517007 {5 -2012}
Office of Local Systems
Ames, IA 50010
City Street Financial Report
City Name
City Number
City Population
Fiscal Year
DUBUQUE
2100
57,637
2013
Welcome Page!
Welcome to the Iowa Department of Transportation, Office of Local Systems, City Street Financial Report (SFR)
Complete the City SFR according to the instructions that are available on the Iowa DOT SFR website located here.
Please direct all questions, comments, and feedback about the City SFR and the on -line process, to: Tammi Bell at tammi.bell @dot.iowa.gov, 515 - 239 -1529.
Thank you for using the City SFR on -line process.
Iowa Department of Transportation
\— Form 517007 {5 -2012}
Office of Local Systems
Ames, IA 50010
City Street Financial Report
City Name
City Number
City Population
Fiscal Year
DUBUQUE
2100.
57,637
2013
Cover Sheet
Now therefore let it be resolved that the city council' of - DUBUQUE r Iowa
(city name)
on 09/16/2013 did hereby .approve and adopt the annual
(month /day /year)
City Street Financial Report from July 1, 2012 to June 30, 2013
(year)
Contact Information
(year)
Name
E-mail Address
Street Address
City
ZIP Code
Kevin Firnstahl
1firnsta @cityofdu!buque.org
50 West 13th Street
Dubuque, IA
52001 -4864
Hours
Phone
Extension
Alternate Phone
8 :00 AM - 5:00 PM
(563) 589 -4121
(563)'556 -0418
Preparer Information
Name
E -mail Address
Phone
.Extension
Jean M. Nachtman
jnachtma @cityofdubuque.org
(563) 589 -4141
50 West 13th Street
Mayor Information
Name
E- mail Address
Street Address
City
ZIP Code
Roy D. Buo1
rbuol @cityofdubuque.org
50 West 13th Street
Dubuque, Lk
52001 -4864
Phone
Extension
(563) 5 :89 =4121
Resolution Number 2 8 5 –13
L.,
Signature: Mayor
ignature Cit Clerk
Iowa Department of Transportation
■iip Form 517007 {5-2012}
Office of Local Systems
Ames, IA 50010
City Street Financial Report
City Name
City Number
City Population
Fiscal Year
DUBUQUE
2100
57,637
2013
Summary Statement Sheet
Column 1 Column 2 Column 3 Column 4
Road Use Other Street Street Debt Totals
Tax Fund Monies
Round Figures to Nearest Dollar
A. BEGINNING BALANCE
1. July 1 Balance
982,388
3,949,172
0
4,931,560
2. Adjustments
(Note on Explanation Sheet)
2. Snow and Ice Removal
1,546,697
0
3,891,773
3. Adjusted Balance
982,388
3,949,172
0
4,931,560
B. REVENUES
1. Road Use Tax
5,519,658
5,519,658
2. Transfer of
Jurisdictions Fund
2,085
56,574
1,693,797
2,085
3. Property Taxes
4. Traffic Services
19,833
309,027
4. Special Assessments
F. Administration
446,462
6,583
446,462
5. Miscellaneous
G. Equipment
(Purchased or Leased)
2,600,149
2,472,034
2,600,149
6. Proceeds from Bonds,
Notes, and Loans
H. Miscellaneous
1,274,000
1,274,000
7. Interest Earned
J. Street Debt
50,675
25,800
50,675
8. Total Revenues
(Lines B1 thru B7)
5,521,743
4,371,286
15,334
9,893,029
C. Total Funds Available
(Line A3 + Line B8)
6,504,131
8,320,458
0
14,824,589
Column 1 Column 2 Column 3 Column 4
Road Use Other Street Street Debt Totals
Tax Fund Monies
Round Figures to Nearest Dollar
EXPENSES
D. Maintenance
1. Roadway Maintenance
3,589,407
447
10,932,816
3,589,854
2. Snow and Ice Removal
1,546,697
0
3,891,773
1,546,697
E. Construction, Reconstruction and Improvements
1. Engineering
45,877
196,121
241,998
2. Right of Way Purchased
3. Street/Bridge Construction
56,574
1,693,797
1,750,371
4. Traffic Services
19,833
309,027
328,860
F. Administration
195,720
6,583
202,303
G. Equipment
(Purchased or Leased)
466,090
2,472,034
2,938,124
H. Miscellaneous
J. Street Debt
1. Bonds, Notes, and Loans -
Principal Paid
25,800
97,100
122,900
2. Bonds, Notes and Loans
Interest Paid
15,334
196,375
1
211,709
TOTALS
K. Total Expenses
(Lines D thru J)
5,961,332
4,971,484
10,932,816
L. Ending Balance
(Line C -K)
542,799
3,348,974
0
3,891,773
M. Total Funds Accounted
For (K + L = C)
6,504,131
8,320,458
0
14,824,589
( Iowa Department of Transportation
Nap Form 517007 (5-2012)
Office of Local Systems
Ames, IA 50010
City Street Financial Report
City Name
City Number
City Population
Fiscal Year
DUBUQUE
2100
57,637
2013
Miscellaneous Revenues and Expenses Sheet
Code Number and Itemization of Miscellaneous Revenues (Line B5 on the Summary Statement Sheet)
(See Instructions)
Column 2
Other Street Monies
Column 3
Street Debt
Column 3
Street Debt
123 Various State Grants
2,441,718
173 Reimbursement For Damages
46,149
182 Property or Buildings (Sale or Rent)
100,044
190 Other Miscellaneous
12,238
Line B5 Totals
2,600,149
Code Number and Itemization of Miscellaneous Expenses (Line H on the Summary Statement Sheet)
"On street" parking expenses, street maintenance, buildings, insurance, administrative costs for printing, legal fees,
bond fees etc. (See instructions)
Column 2
Other Street Monies
Column 3
Street Debt
Line H Totals
(+ Iowa Department of Transportation
\_ Form 517007 {5 -2012}
Office of Local Systems
Ames, IA 50010
City Street Financial Report
City Name
City Number
City Population
Fiscal Year
DUBUQUE
2100
57,637
2013
Bonds, Notes and Loans Sheet
New
Bond
?
Debt Type
Debt Purpose
DOT
Use
Only
Issue
Date
Issue
Amount
% Related
elated
to Street
Year
Due
Principal
Balance as
of 7/1 or after
Total
Principal
Paid
Total
Interest Paid
Principal
Roads
Interest
Roads
Principal
Balance as
of 6/30
General Obligation
Paving & Construction
304
09/01/2011
6,330,000
16%
2031
6,330,000
260,000
203,281
41,600
32,524
6,070,000
General Obligation
Paving & Construction
305
03/15/2012
7,495,000
74%
2031
7,495,000
75,000
221,421
55,500
163,851
7,420,000
General Obligation
Paving & Construction
306
08/30/2010
4,470,000
12%
2030
4,265,000
215,000
127,788
25,800
15,334
4,050,000
General Obligation
Paving & Construction
12/19/2012
3,640,000
35%
2032
3,640,000
3,640,000
New Bond Totals
3,640,000
1,274,000
Totals
21,730,000
550,000
552,490
122,900
211,709
21,180,000
IAiowa Department of Transportation
Form 517007 {5-2012}
Office of Local Systems
Ames, IA 50010
City Street Financial Report
City Name
City Number
City Population
Fiscal Year
DUBUQUE
2100
57,637
2013
Section A
Project Final Costs Sheet
For construction, reconstruction, and improvement projects with costs equal to or greater than 90% of the bid threshold in effect as the beginning of the fiscal year.
Check here if there are no entries for this year ❑
Line
No.
1.
Project Number
2.
Estimated Cost
3.
Project Type
4.
Public Letting?
5.
Location /Project Description (limits, length, size of structure)
1.
Project Number
1
Complete Street
5,600,000
Roadside Construction
Yes
5439 Feet - Historic Millwork District, Jackson St. between 6th & 1 lth, Washington
12.
Overhead
2
7th St. Retaining Alts
350,000
Roadside Construction
Yes
400 Feet - Wall reconstruction 7th St between Hill and Nedham
3
Green Alley
146,436
Roadside Construction
Yes
17th to 18th Streets
4
Central Ave
1,379,819
Roadside Construction
Yes
6905 Feet. HMA Resurfacting
5
Kaufmann Ave
521,995
Roadside Construction
Yes
Resurfacing Kaufmann between Kennedy Rd and Carter Rd
Section B
Contract Work
City Labor
Line
No.
1.
Project Number
6.
Contractor Name
7.
Contract
Price
8.
Additions/
Deductions
9.
Labor
10.
Equipment
11.
Materials
12.
Overhead
13.
Total
1
Complete Street
Portzen Construction
5,575,006
1,235,167
6,810,173
2
7th St. Retaining Wa
Portzen Construction
351,336
75,241
426,577
3
Green Alley
McDermott Construction
148,847
13,695
162,542
4
Central Ave
River City Paving
1,361,772
- 159,725
1,202,047
5
Kaufmann Ave
Top Grade Excavating
517,601
43,141
560,742
(Iowa Department of Transportation
Ns. Form 517007(5 -2012)
Office of Local Systems
Ames, IA 50010
City Street Financial Report
City Name
City Number
City Population
Fiscal Year
DUBUQUE
2100
57,637
2013
Road /Street Equipment Inventory Sheet
Check here if there are no reportable equipment❑
1.
Local Class
I.D. #
2.
Model
Year
3.
Description
4.
Purchase
Cost
5.
Lease /Unit
Cost
6.
Rental /Unit
Cost
7.
Used on Project
this FY?
8.
Status
4034
2009
JD Skid loader
32,058
No
No Change
2730
2009
Sewer Easement Machine
38,783
No
No Change
3298
2008
B &B Trailer
5,585
No
No Change
3230
2007
Ford F550 Crew Cab
91,809
No
No Change
3241
2006
International
36,411
No
No Change
3236
2007
International 4200
101,728
No
No Change
3213
2007
John Deere Backhoe Loader
67,754
No
No Change
3208
2006
International 7400
36,411
No
No Change
3206
2006
International 7400
36,411
No
No Change
3203
2008
7400 4X2 Dump Truck
94,382
No
No Change
3102
2007
Chevrolet Silverado
25,666
No
No Change
2704
2007
International 7500 SFA 6X4
194,618
No
No Change
2702
2008
Ford F350
31,360
No
No Change
4007
2005
Elgin Pelican P Dual Sweeper
128,285
No
Traded
2715
2006
Godwin 4" Trash Pump
18,782
No
No Change
3242
2005
Freightliner Dump Truck w/ Henderseon Mund
75,332
No
Traded
2701
2008
Ford F350
31,875
No
No Change
4006
2010
John Deere Tractor
79,360
No
No Change
4011
2008
John Deere Lawn Tractor
13,662
No
Traded
4008
2010
Elgin Whirlwind Sweeper
177,010
No
No Change
3290
2006
John Deere Gator
7,980
No
No Change
2703
2005
Jet Flusher Truck/Pipe Cleaner
880,000
No
Sold
2705
2009
Chevrolet 3500 Sewer Rodder Silverado
76,593
No
No Change
OIowa Department of Transportation
_ Form 517007 (5-2012)
Office of Local Systems
Ames, IA 50010
City Street Financial Report
City Name
City Number
City Population
Fiscal Year
DUBUQUE
2100
57,637
2013
1.
Local Class
I.D. #
2.
Model
Year
3.
Description
4.
Purchase
Cost
5.
Lease /Unit
Cost
6.
Rental /Unit
Cost
7.
Used on Project
this FY?
8.
Status
2706
1999
CH &S - 6" Trash Pump
13,846
No
No Change
2708
1966
Gorman Rupp - 6" Trash Pump
1,973
No
No Change
2710
1998
PECO Manhole Cutter
13,260
No
No Change
2719
1985
Gorman Rupp 6" Trash Pump
11,595
No
No Change
2721
2003
Honda 3" Trash Pump
1,197
No
No Change
2711
2007
Ford Hi -Cube Van 2/ CCTV Equip
99,000
No
No Change
2726
2000
Portable Jet /Root Cutter
8,595
No
No Change
2727
2000
Kawasaki Mule 4 Wheeler
7,011
No
No Change
3201
2009
Freightliner 35,000 GVW
85,633
No
No Change
3202
1998
International W /Rosco Distributor
60,795
No
No Change
3204
2008
International 7400 Dump Truck
87,000
No
No Change
3205
2005
Freightlilner FL70 w /combo Box
73,178
No
Traded
3209
2009
John Deere endloader 624K
129,292
No
No Change
3210
2004
John Deere Backhoe Loader
58,375
No
No Change
3215
2001
Caterpillar Vibratory Asphalt Roller
23,390
No
No Change
3216
2008
International 7400 Tamdem Dump Truck
108,431
No
No Change
3218
2009
Freightliner Bucket Truck
137,049
No
No Change
3219
2001
Atlas Copco Air Compressor
7,282
No
No Change
3223 -1
1997
Snow Equipment Anti -Icing Unit
8,176
No
No Change
3224
2003
Atlas Copco Air Compressor
7,819
No
No Change
3227
2008
John Deere Backhoe Loader
71,880
No
No Change
3229
1967
International Tractor
7,280
No
No Change
3231
2002
Ford F450 4WD
29,585
No
No Change
3225
2005
Dynapac CC122 12 Series
25,842
No
No Change
3235
1996
John Deere Wheel Loader
95,672
No
No Change
3237
2001
Atlas Copco Air Compressor
7,282
No
No Change
`AIowa Department of Transportation
'v. Fomi 517007 {5 -2012}
Office of Local Systems
Ames, IA 50010
City Street Financial Report
City Name
City Number
City Population
Fiscal Year
DUBUQUE
2100
57,637
2013
1.
Local Class
I.D. #
2.
Model
Year
3.
Description
4.
Purchase
Cost
5.
Lease /Unit
Cost
6.
Rental /Unit
Cost
7.
Used on Project
this FY?
8.
Status
3238
1993
Townmaster Trailer
5,481
No
No Change
3240
1998
Target Pro 65 III Concrete Saw
8,927
No
No Change
3244
1992
John Deere Wheel Loader
92,000
No
Traded
3245
2008
Freightliner Tandem Dump Truct
104,052
No
No Change
3246
2005
Silverado 4WD 12,000 GVW Dump
37,814
No
Traded
3247
1990
Cimline Crack Saw
2,381
No
No Change
3248
1990
Cimline Crack Saw
3,869
No
No Change
3250
2000
John Deere Wheel Loader
118,750
No
No Change
3251
1991
Caterpillar Paver - Finisher
24,411
No
No Change
3252
2005
Chevrolet 4WD 12,000 GVW Dump Truck
36,914
No
Traded
3255
2007
John Deere 6247 Endloader
136,108
No
No Change
3256
2008
John Deere Lawn Tractor
19,112
No
No Change
3258
1979
Massey Ferguson Tractor
11,500
No
No Change
3262
2000
Cimline Crack Sealer
18,931
No
No Change
3267
1985
Trailer King Trailer
2,836
No
No Change
3272
1991
Ingersoll Rand Roller
3,210
No
No Change
3212
2010
International Dump Truck
104,775
No
No Change
3270
2009
Huszvarna 30" Pavement Saw
21,970
No
No Change
3243
2009
Atlas Copco Air Compressor
10,351
No
No Change
3104
2010
Caterpillar Roller
48,575
No
No Change
3278
2002
Ingersoll Rand Roller
5,356
No
No Change
3279
1996
Melroe Skid -Steer Loader
26,108
No
No Change
3280
1993
Honda Generator
1,360
No
No Change
3281
1993
Speed Screed
3,327
No
No Change
3282
1994
Berming Machine
4,200
No
No Change
3292
2008
Catepiller
277,632
No
No Change
AIN Iowa Department of Transportation
Form 517007 {5-2012}
Office of Local Systems
Ames, IA 50010
City Street Financial Report
City Name
City Number
City Population
Fiscal Year
DUBUQUE
2100
57,637
2013
1.
Local Class
I.D. #
2.
Model
Year
3.
Description
4.
Purchase
Cost
5.
Lease /Unit
Cost
6.
Rental /Unit
Cost
7.
Used on Project
this FY?
8.
Status
3506
2004
Gorman Rupp 10" Trash Pump
35,720
No
No Change
4001
2004
Interanational 7400 w/ Lodal
76,450
No
Traded
4002
2004
Elgin Pelican Sweeper
93,275
No
No Change
4003
1998
International Vac /Flusher Unit
124,756
No
No Change
4004
2009
International 56,000 GVW
105,310
No
No Change
4103
1998
Sno -Go- Loader Attachment
75,000
No
No Change
2731
2009
John Deere Gator
9,550
No
No Change
3223
2011
Freightliner w /Henderson Combo Dump Box
119,427
No
No Change
3226
2010
John Deere Motor Grader
194,335
No
No Change
3214
2010
John Deere Backhoe /Loader
82,318
No
No Change
3104
2010
Caterpillar
48,575
No
No Change
4113
2011
SNOGO unit - loader mounted
204,000
No
No Change
3233
2012
International Tandem Dump Truck
110,675
No
No Change
3101
2012
Chevrolet Pickup Truck
29,328
No
No Change
3207
2012
International Tandem Dump Truck
110,675
No
No Change
3217
2010
John Deere Wheel Loader Forks Attachment
5,433
No
No Change
4007
2013
Elgin Pelican P Dual Sweeper
189,459
No
New
3242
2013
International Dump Truck w /Combo Box
106,699
No
New
4011
2013
John Deere Lawn Tractor w /snow equipment
14,516
No
New
2703
2014
Jet Flusher Truck / Pipe Cleaner
207,490
No
New
3205
2013
International 7400 w /combo box
106,699
No
New
3244
2012
John Deere Wheel Loader - 644K
220,000
No
New
3246
2013
Silverado 4WD 12,000 GVW Dump w /snow lj
58,695
No
New
3252
2013
Chevrolet 4WD 12,000 GVW Dump w /snow ti
58,695
No
New
4001
2013
International 7400 w /loadal
131,251
No
New
0Iowa Department of Transportation
�40. Form 517007 {5-2012}
Office of Local Systems
Ames, IA 50010
City Street Financial Report
City Name
City Number
City Population
Fiscal Year
DUBUQUE
2100
57,637
2013
1
Explanation Sheet
Comments
IA Iowa Department of Transportation
Nap Form 517007 {5-2012}
Office of Local Systems
Ames, IA 50010
City Street Financial Report
City Name
City Number
City Population
Fiscal Year
DUBUQUE
2100
57,637
2013
Monthly Payment Sheet
Month
Road Use
Tax Payments
Transfer of
Jurisdictions Payments
JULY
$403,222.40
$106.60
AUGUST
$605,647.39
$129.19
SEPTEMBER
$551,016.91
$252.09
OCTOBER
$445,254.16
$204.17
NOVEMBER
$424,556.81
$194.67
DECEMBER
$448,832.88
$206.29
JANUARY
$447,317.24
$205.34
FEBRUARY
$480,621.93
$220.72
MARCH
$605,098.20
$277.95
APRIL
$403,871.32
$183.10
MAY
$260,933.70
$105.24
JUNE
$443,285.52
$0.00
Totals
$5,519,658.46
$2,085.36