City Street Financial Report FY 2014THE CITY OF
Dui
Masterpiece on the Mississippi
TO: The Honorable Mayor and City Council Members
FROM: Michael C. Van Milligen, City Manager
SUBJECT: Fiscal Year 2014 City Street Financing Report
DATE: August 25, 2014
Dubuque
band
AI -America City
r
2007 • 2012 • 2013
Finance Director Ken TeKippe recommends City Council approval of the Fiscal Year
2014 City Street Financing Report.
I concur with the recommendation and respectfully request Mayor and City Council
approval.
Mic ael 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
Dubuque
*~***
AII•AmerlcaCity
2007 + 2012 •2013
TO: Mike Van Milligen, City Manager
FROM: Ken TeKippe, Finance Director i Q
SUBJECT: Fiscal Year 2014 City Street Financing Report.
DATE: August 18, 2014
INTRODUCTION
The purpose of this memorandum is to request that the City Council adopt a resolution
approving the City of Dubuque's Fiscal Year 2014 City Street Financing Report.
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,
2014. 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.
RECOMMONDATION
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 2014.
cc: Gus Psihoyos, City Engineer
Jenny Larson, Budget Director
RESOLUTION NO. 274-14
APPROVING THE CITY OF DUBUQUE FISCAL YEAR 2014 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, 2013, to
June 30, 2014, 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 2nd day of September, 2014
Attest:
Trish Gleason, Assistant City Clerk
Roy D. Buol, Mayor
D T
Form 517007 {5-2014}
Office of Local Systems
Ames, IA 50010
City Name
C}f
Number
DUBUQUE
210
City Street Financial Report
Fiscal Year
2014
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.
&IOWADOT
Form 517007 {5-2014}
Office of Local Systems
Ames, IA 50010
City Name
City i i ur `h
DUBUQUE
'_ 100
Contact Information
City Street Financial Report
Cover Sheet
Now therefore let it be resolved that the city council of DUBUQUE , Iowa
(city name)
on 09/02/2014 did hereby approve and adopt the annual
(month/day/year)
City Street Financial Report from July 1, 2013 to June 30, 2014
(year) (year)
Fiscal Year
2014
Name
E-mail Address
Street Address
City
ZIP Code
Kevin Firnstahl
kfirnsta@cityofdubuque.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
jnachtina@cityofdubuque.org
(563) 589-4141
50.West 13th Street
Mayor Information
Name
E-mail Address
Street Address
City
ZIP Code
Roy D. Buol
rbuol@cityofdubuque.org
50.West 13th Street
Dubuque, IA
52001-4864
Phone
Extension
(563) 589-4121
Resolution Number
Roy D. Buol
Signature Mayor
Trish Gleason - Assistant City Clerk
Signature City Clerk
Ga1OWADOT
Form 517007 (5-2014)
Office of Local Systems
Ames, IA 50010
City Name
Number
DUBUQUE
Column 1
Road Use
Tax Fund
City Street Financial Report
Summary Statement Sheet
Column 2 Column 3 Column 4
Other Street Street Debt Totals
Monies
Round Figures to Nearest Dollar
A. BEGINNING BALANCE
1. July 1 Balance
542,799
3,348,974
0
3,891,773
2. Adjustments
(Note on Explanation Sheet)
122
3. Adjusted Balance
542,921
3,348,974
0
3,891',895.
B. REVENUES
1. Road Use Tax
5,755,270
5,755'.270
2. Transfer of
Jurisdictions Fund
3. Property Taxes
125
26,918
26,918
4. Special Assessments
182,765
182,765
5. Miscellaneous
2,699,930
2,699,930
6. Proceeds from Bonds,
Notes, and Loans
7. Interest Earned
31,915
31,915
8. Total Revenues
(Lines B1 thru B7)
C. Total Funds Available
(Line A3 + Line B8)
5,755,395
6,298,316
2,941,528
6,290,502
8,696,923;
12,588,818
Fiscal Year
2014
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
Roadway Maintenan"ce
1,715,669
0
15,669
now;an�
ce,Reimov
447,828
0
47,828
E. Construction;? Reconstruct on and Improvements
Engineering'
2,419,058
787,847
06,905
Right of Way Purchased
102,228
02,228
3. Street/Bridge Construction
79,327
2,919,151
„998,478
4. Traffic Services
45,959
1,196,698
242,657
F.` Administration':
196,598
573,413
70,011
G. Equipment'
'(Purchased or, Leased
316,542
149,969
6,511
H. Miscellaneous
J.'Street. Debt,A,
30,630
16,726
367,720
193,476
TOTALS
68,337
ti
,290,502.
nding"Balance
M. Total Funds'Accounte
For (K + L = C)`
!6;290,502
839
29' 979
588,818
C3IowAooT
Form 517007 {5-2014}
Office of Local Systems
Ames, IA 50010
City Name
✓}z:y i a
t air
DUBUQUE
100
City Street Financial Report
Miscellaneous Revenues and Expenses Sheet
Code. Number and Itemization of Miscellaneous Revenues (Line B5 on the SummayStatement Sheet)!
(See Instructions)
117 Counties
Column 2
therStreet ; Monies
1,190,390
Fiscal Year
2014
123 Various State Grants
1,031,370
140 Federal Government (misc.)
145,097
170 Reimbursements (misc.)
154,983
172 Labor & Services
46,803
182 Property or Buildings (Sale or Rent)
18,453
190 Other Miscellaneous
41
194 General Fund Transfers
112,793
e!
5Totals
2,699,930
Code Number and Itemization of MiscellaneousExpenses (Line H on the Summary Statement Sheet,
"On street" parking expenses, street maintenance, buildings, insurance, administrative costs for printing,lega
bond fees etc. (See nstructions)
lump'
er'Street Monies'
ine H Totals?'
IOWADOT
Form 517007 {5-2014)
Office of Local Systems
Ames, IA 50010
City Name
City Num
DUBUQUE
New
Bond
7
General Obligation
Debt Purpose
Paving & Construction
DOT
Use
Only
304
City Street Financial Report
Bonds, Notes and
Issue
Date
09/01/2011
issue, `.
Amount
6,330,000
% Related
to Street
16%
Loans Sheet
2031
Principal
Balance as
of 7/1 or after
6,070,000
265,000
Total
Interest'Paid
198,081
Principal
Roads
42,400
Fiscal Year
2014
31,692
Principal
Balance'as`
,805;000
General Obligation
Paving & Construction
305
03/15/2012
7,495,000
74%
2031
7,420,000
345,000
181,335
255,300
4 187
75,000
General Obligation
Paving & Construction
306
08/30/2010
4,470,000
12%
2030
4,050,000
270,000
123,488
32,400
818
80,000
General Obligation
Paving & Construction
307?
12/19/2012
3,640,000
35%
2032
3,640,000
195,000
84,300
8,250
,505:
45,000
New Bond Totals
0
Totals
1,180,000
75;00,0
7,204
98;350
0,202
105;000
&IOWADOT
Form 517007 {5-2014}
Office of Local Systems
Ames, IA 50010
City Name
City Number
DUBUQUE
Section A
City Street Financial Report
Fiscal Year
2014
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 a^
Public Letting?
5 ," ,\
Location/Project Description'w(Iimits,,length, size of structure) °\\,\
.,.
Labors �\ .
1
SEP Green Alley
178,702
Roadway Construction
Yes
Between Arlington and Loras from Dell to Prairie - 715 feet
Addition
u o e
2
SEP Green Alleys
273,099
Roadway Construction
Yes
Between Jackson and White Streets from 17th to 18th, and between Jackson and Wu
Section B
Contract
Work
\ \
r < \
\ Cit
.,.
Labors �\ .
\, \
\\�
�\�\ ,, „
Line
No.
Project‘Number
Contractor Name :,
.
Contract
Price.,. �.:De
Addition
u o e
abor: v va,.
���
E ul merit° \,
MaterialsOverhea
v,
v vTotal
1
SEP Green Alley
Portzen Construction
174,840
6,052180
,892
2
SEP Green Alleys
Drew Cook and Sons Excavating
247,488
-17,3680;120
&IOWADOT
Form 517007 {5-2014}
Office of Local Systems
Ames, IA 50010
City Name
City Number
DUBUQUE
4
Purchase \; a \\;
Cost
City Street Financial Report
Fiscal Year
2014
1.
Local Class
I.D. # `
2.
Model
Year
3'.
Description
4
Purchase \; a \\;
Cost
5y\\ \
Lease:, ; \ \
Cost �
/Unit ` ° ;
�
6 :;
Rental \\\\; /Unit \ `\
Costvv
7
Use on Project
this FY.
o„
Status
W
`
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
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
Traded
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
3238
1993
Townmaster Trailer
5,481
No
No Change
3240
1998
Target Pro 65 III Concrete Saw
8,927
No
No Change
3245
2008
Freightliner Tandem Dump Truct
104,052
No
No Change
3247
1990
Cimline Crack Saw
2,381
No
No Change
3235
1990
Cimline Crack Saw
3,869
No
No Change
IOWA DOT
Form 517007 (5-2014}
Office of Local Systems
Ames, IA 50010
City Name
DUBUQUE
City Street Financial Report
Road/Street Equipment Inventory Sheet
Check here if there are no reportable equipment
1,
Local Class
LD. #
Model
Year
3.
Description
4
Purchase
Cost
Fiscal Year
2014
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
2715
2006
Godwin 4" Trash Pump
18,782
No
No Change
2701
2008
Ford F350
31,875
No
No Change
4006
2010
John Deere Tractor
79,360
No
No Change
4008
2010
Elgin Whirlwind Sweeper
177,010
No
No Change
3290
2006
John Deere Gator
7,980
No
No Change
2705
2009
Chevrolet 3500 Sewer Rodder Silverado
76,593
No
No Change
2706
1999
CH&S - 6" Trash Pump
13,846
No
No Change
2708
1966
Gorman Rupp - 6" Trash Pump
1,973
No
Traded
2710
1998
PECO Manhole Cutter
13,260
No
No Change
2719
1985
Gorman Rupp 6" Trash Pump
11,595
No
No Change
&IOwADOT
Form 517007 {5-2014}
Office of Local Systems
Ames, IA 50010
City Name
City Number
DUBUQUE
2 f 00
City Street Financial Report
Fiscal Year
2014
Local Class
I.D. #
Model
Year
Description
Purchase
Cost
Lease
Cost
/Unit
6
Rental
Cost
/Unit
Used on Project
this FY
Status
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
No Change
3242
2013
International Dump Truck w/Combo Box
106,699
No
No Change
4011
2013
John Deere Lawn Tractor w/snow equipment
14,516
No
No Change
3236
2014
Jet Flusher Truck / Pipe Cleaner
207,490
No
No Change
3205
2013
International 7400 w/combo box
106,699
No
No Change
3244
2012
John Deere Wheel Loader - 644K
220,000
No
No Change
3246
2013
Silverado 4WD 12,000 GVW Dump w/snow k:
58,695
No
No Change
3252
2013
Chevrolet 4WD 12,000 GVW Dump w/snow im
58,695
No
No Change
4001
2013
International 7400 w/loadal
131,251
No
No Change
2708
2014
Tsrumi-6" trash pump.
15,794
No
New
3219
2014
Sullivan D185PJD Air Compressor
9,517
No
New
4047
2014
H&H Trailer GT20
6,175
No
New
lOWADOT
Form 517007 (5-2014)
Office of Local Systems
Ames, IA 50010
City Name
Number
DUBUQUE
City Street Financial Report
Fiscal Year
2014
Local Class
I.D. #
Model
Year '
Description
4. \
Purchase
Cost „., ��.,,�
5�
Lease
Cost
nit
\
6 \ �
Renta
7 ���
e.\ u.
Used on Project
this FY?
8. �.
\'
Status
�
3250
2000
John Deere Wheel Loader
118,750
No
No Change
3251
1991
Caterpillar Paver -Finisher
24,411
No
No Change
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
3506
2004
Gorman Rupp 10" Trash Pump
35,720
No
No Change
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
IOWA T
Form 517007 {5-2014}
Office of Local Systems
Ames, IA 50010
City Name
DUBUQUE
City Street Financial Report
Explanation Sheet
Fiscal Year
2014
Comments
T
Form 517007 {5-2014)
Office of Local Systems
Ames, IA 50010
City Name
City Number
DUBUQUE
2100
City Street Financial Report
Monthly Payment Sheet
Month
Road Use
Tax Payments
Transfer of
Jurisdictions Payments
JULY
$472,008.15
$125.25
AUGUST
$558,877.69
SEPTEMBER
$518,864.54
OCTOBER
$610,025.78
NOVEMBER
$435,825.37
DECEMBER
$454,189.22
JANUARY
$449,995.63
FEBRUARY
$547,184.14
MARCH
$540,793.21
APRIL
$366,708.68
MAY
$270,337.72
JUNE
$530,460.21
Totals
$5,755,270.34
$125.25
Fiscal Year
2014