City Street Financial Report FY 2012
TO: The Honorable Mayor and City Council Members
FROM: Michael C. Van Milligen, City Manager
SUBJECT: Fiscal Year 2012 City Street Financing Report
DATE: August 27, 2012
Finance Director Ken TeKippe is recommending approval of the City Street Financing
Report for Fiscal Year 2012.
I concur with the recommendation and respectfully request Mayor and City Council
approval.
/ AAh kt1&1
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
THECIFYOF
Dubuque
DUB E
fiiiii
Masterpiece on the Mississippi
1 I I
I I r
2007
TO: Mike Van Singed Cry Manager
FROM: Ken TeKippe, Finance Director
DATE: August 21, 2012
SUBJECT: Fiscal Year 2012 Cry Street Financing Report
INTRODUCTION
The purpose of memorandum ism request that be City Council adopt a resolution approving the Cry or Dubuque a
Fiscal Year 2012 Cry Street Financing Report
DISCUSSION
The Cade ofIowa, Chapter 312, Second 14 provides for the submission or an annual City Street Finance Report to the Iowa
Department or Transportation by September 30 , 2011. Failure of the City to submit this report on atiimeiy bass results In the
Stare withholding Road Use Tax Funds allocated to the Cry unto compliance is achieved.
RECOMMENDATION
recommend adoption of the enclosed resolution approving the attached annual report and authorise riling with the Iowa
Department of Tansportatiion.
ACTION TO BE TAKEN
The City Council is requested to adopt the attached resolution approving the City Street Finance Report for Fiscal Year 2012.
Prepared by
ASK
Gus Psihoyos, City Engineer
Jenny Larson Budget Director
RESOLUTION NO. 230 -12
APPROVING THE CITY OF DUBUQUE FISCAL YEAR 2012 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, 2011, to June
30, 2012, 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 4th day of September, 2012
Attest:
Kevin Firnstahl, CMC,'` y Clerk
Roy D. Buol, Mayor
Iowa Department of Transportation Form 517007 {5 -2012}
City Street Financial Report
Office of Local Systems
Ames, IA 50010
City ,Name
City Number
ICity , Population
Fiscal Year
IJUI3U�UE
2100
57,637
201?
T
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 Name
City Number
ICity Population
Fiscal Year
�U�UQUE
2100
57,637
2012
Contact Information
Cover Sheet
Now therefore let it be resolved that the city council of DUBUQUE , Iowa
city name
on
09/04/2012
(month /day /year)
did hereby approve and adopt the annual
City Street Financial Report from July 1, 2011 to June 30, 2012 _
(year) year
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
Name
E -mail Address
Phone
Extension
Kenneth J. TeKippe
ktekippe @cityofdubuque.org
(563) 589 -4133
50 West 13th Street
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
Kevin Firnstahl
Signature City Clerk
� } Iowa Department of Transportation
Form 517007 {5 -2012}
Office of Local Systems
Ames, IA 50010
City Name JCity
Number i
City Population
Fiscal Year
IDUEUQUE
2100
57,637
2012
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
173,486
0
0
173,486
2. Adjustments
2. Snow and Ice Removal
1,378,776
(Note on Explanation Sheet)
E. Construction, Reconstruction
and Improvements
1. Engineering
0
3. Adjusted Balance
173,486
0
0
173,486
B. REVENUES
1. Road Use Tax
5,466,933
3..Street/Bridge Construction
123,393
5,466,933
2. Transfer of
11,132,373
4. Traffic; Services;
517
926,848
Jurisdictions Fund
2,323
IF. Administration
114
2,323
3. Property Taxes
15,747
G. Equipment
(Purchased or Leased) ;
23,601
312,236
4. Special Assessments
335,837
413,400
413,400
5. Miscellaneous
14,208,683
1. Bonds, Notes, and Loans -'
Principal' Paid
14,208,683
6. Proceeds from Bonds,
24,600
2. Bonds, Notes and Loans -
Interest Paid
16,737
(Votes, and Loans
6,559,100
6,559;100
7. Interest Earned
31,748
TOTALS
31,748
8. Total Revenues
17,263,759
21,924,113
L. Ending Balance
(Line C -K)
(Lines B1 thru',137)
; 5,469,256
21,212,931
4,931,560
26,682,187
C. Total Funds Available'
21,212,931
0
26,855,673
(Line A3' + Line "!B8)
5,642,742
21,212,931
0
26,855,673
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,095,6031
4001
1 3,096,003
2. Snow and Ice Removal
1,378,776
1,378,776
E. Construction, Reconstruction
and Improvements
1. Engineering
0
2,267,903
2,267,903
2., Right of Way Purchased --
2,705,290
2;705,290
3..Street/Bridge Construction
123,393
11,008,980
11,132,373
4. Traffic; Services;
517
926,848
927,365
IF. Administration
114
15,633
15,747
G. Equipment
(Purchased or Leased) ;
23,601
312,236
335,837
1H. Miscellaneous
J. Street Debt
1. Bonds, Notes, and Loans -'
Principal' Paid
21,613
2,987
24,600
2. Bonds, Notes and Loans -
Interest Paid
16,737
23,482
40,219
TOTALS
K. Total Expenses
(Lines D thru J)
4,660,354
17,263,759
21,924,113
L. Ending Balance
(Line C -K)
982,388
3,949,172
0
4,931,560
M. Total Funds Accounted
For (K + L =' C)
5,642,742
21,212,931
0
26,855,673
q Iowa Department of Transportation W W Form 517007 {5 -2012} City Street Financial Report
Office of Local Systems
Ames, IA 50010
City Name
City ',Number
City Population
IFiscal Year
I9UEUQUE
12100
157,637
2012
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
121 State Reimbursement
23,538
123 Various State Grants
664,417
140 Federal Government (misc.)
10,859,592
170 Reimbursements (misc.)
253
173 Reimbursement For Damages
146,502
174 Sales Tax / Local Option
2,410,255
180 Receipts From Sales
6,737
181 Junk and Old
6,321
182 Property or Buildings (Sale or Rent)
14,703
190 Other Miscellaneous
53,603
191 Licenses and Permits
12,795
192 Donations
9,967
Line B5 Totals
14,208,683
= Iowa Department of Transportation treet Financial Report
Form 517007 {5 -2012} y nanc p
Office of Local Systems
Ames, IA 50010
City Name
City Number
Debt Purpose
I Fiscal Year
I3UBUQUE
2100
57,637
12012
Bonds, Notes and Loans Sheet
New
Bond
ond
Debt Type:
Debt Purpose
DOT
Use
Issue
o
/o Related
Year
Principal
Balance as
Total
Principal
Total
Principal
Interest'
Principal
Balance as
?
Only
Date
Amount
to Street
Due
of 7/1 or after
Paid
Interest Paid
Roads
Roads
of 6/30
2]
General Obligation
Paving & Construction
09/01/2011
6,330,000
16%
2031
6,330,000
152,461
24,393
6,330,000
®
General Obligation
Paving & Construction
03/15/2012
7,495,000
74%
2031
7,495,000
7,495,000
General Obligation
Paving & Construction
08/30/2010
4,470,000
12%
2030
41415,000
205,000
131,888
24,600
15,826
4,210,000
New Bond Totals
13,825,000
6,559,100
Totals
18,240,000
205,000
284,349
24,600
40,219
18,035,000
Iowa Department of Transportation
Form 517007 {5 -20121
Office of Local Systems
Ames, IA 50010
r '-a•
City Name
1.
Project Number
ICity , Population
I Fiscal Year
IaUBUQUE`
2100
57,637
12012
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.
Section A Check here if there are no entries for this year n
Line
No.
1.
Project Number
2.
Estimated Cost
3.
Project Type
4.
Public'! Letting?
5,
Location /Project Description (limits, length, size of structure)
1.
1
Green Alley
107,082
Roadside Construction
Yes
Pervious resurface alley between Jackson & White 9th to 10th St 300; feet
12.
Section B
Contract Work
City; Labor
1.
6.
7.
8.
9.
10.
11.
12.
13.
Line
Project Number
Contractor Name
Contract
Additions/
Labor
Equipment
Materials
Overhead
Total'
No.
Price
Deductions
1
Green Alley
Portzen Construction
107,0821
20,074
127,156
Iowa Department of Transportation City treet Financial Report
Form 517007 {5 -20121 y p
Office of Local Systems
Ames, IA 50010
City Name
JCity Number
Icity Population
Fiscal Year
DUBUQUE
2100
157,637
2012
Road/Street Equipment Inventory Sheet
Check here if there are no reportable equipment®
I.
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
No Change
2715
2006
Godwin 4" Trash Pump
18,782
No
No Change
3242
2005
Freightliner Dump Truck w/ Henderseon Mun'
75,332
No
No Change
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
No Change
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
88,000
No
No Change
2705
2009
Chevrolet 3500 Sewer Rodder Silverado
76,593
No
No Change
A- �, Iowa Department of Transportation Form 517007 {5 -2012} p City Street Financial Report
Office of Local Systems
Ames, IA 50010
City Name ICity
Number
City Population
Fiscal Year
I3�JBUQUE
2100
57,637
2012
�.'
Local Class
LD.
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/ ECTV 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
3101
1997
Chevrolet Pickup Truck
20,869
No
Traded
3201
2009
Freightliner 35,000 GVW
85,633
No
No Change
g
3202
1998
International W /Rosso 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
INO
No Change
3207
2003
International Tandem Dump Truck
84,730
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
3217
1989
Wacker Vibratory Plate Tamper
1,260
No
Junked
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
-�, Iowa Department of Transportation City treet Financial Report
Form 517007 {5 -20121 Y p
Office of Local Systems
Ames, IA 50010
City _Name
ICity Number !
City,Population
Fiscal Year
IDUBUQUE
12100
157,637 12012
1.
Local Class
LD. #
2.
Model
Year
3.
Description
4.
Purchase
Cost
5.
Lease /Unit
Cost
6.
Rental /Unit
Cost
7.
Used on Project
this FY?
8.
Status
3232
1976
Galion Roller
17,866
No
Junked
3233
2003
International Tandem Dump Truck
84,730
No
Traded
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
3244
1992
John Deere Wheel Loader
92,000
No
No Change
3245
2008
Freightliner Tandem Dump Truct
104,052
No
No Change
3246
2005
Silverado 4WD 12,000 GVW Dump
37,814
No
No Change
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
No Change
3255
2007
John Deere 6247 Endloader
136,108
No
No Change
3256
2008
John Deere Lawn Tractor
19,112
No
No Change
3257
1997
Wacker Rammer
2,296
No
Junked
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
Iowa Department of Transportation City treet Financial Report
Form 517007 {5 -2012} l�
Office of Local Systems
Ames, IA 50010
City Name
City Number
City Population
Fiscal Year
DUBUQUE
2100
157,6337 12012
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
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
4001
2004
Interanational 7300 w/ Lodal
76,450
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
Intemational 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
New
3101
2012
Chevrolet Pickup Truck
29,328
No
New
3207
2012
International Tandem Dump Truck
110,675
No
New
3217
2010
John Deere Wheel Loader Forks Attachment
5,433
No
New
z Iowa Department of Transportation City Street Financial Report
Form 517007 {5 -2012}
Office of Local Systems
Ames, IA 50010
City Name
City Number
City Population
Fiscal Year
I)UBUQUE
2100
57,637
12012
Explanation Sheet
GOBond 2010A should have been listed on the 2011 SFR. A portion of this bond debt repayment is funded with road use tax dollars.
Iowa Department of Transportation City Street Financial Report
Form 517007 {5 -20121
Office of Local Systems
Ames, IA 50010
City Name
umber
City; Population
Fiscal Year
1�U�U�UE'
2100
2100
57,637
20.12
Monthly Payment Sheet
Month
Road Use
Tax Payments
Transfer of
Jurisdictions Payments
JULY
$447,892.95
$101.07
AUGUST
$576,554.24
$186.82
SEPTEMBER
$536,862.70
$244.87
OCTOBER
$422,726.91
$193.85
NOVEMBER
$472,985.75
$217.03
DECEMBER
$423,060.11
$193.90
JANUARY
$428,973.66
$197.06
FEBRUARY
$509,359.70
$234.04
MARCH
$518,351.62
$237.22
APRIL
$447,359.90
$203.72
MAY
$425,876.31
$194.95
JUNE
$256,929.12
$118.27
Totals
$5,466,932.97
$2,322.80