City Street Financial Report FY 2011Masterpiece on the Mississippi
TO: The Honorable Mayor and City Council Members
FROM: Michael C. Van Milligen, City Manager
SUBJECT: Fiscal Year 2011 City Street Financing Report
DATE: September 13, 2011
Dubuque
kittil
1111- AmeticaCity
f
2007
Finance Director Ken TeKippe recommends City Council approval of the City of
Dubuque's Fiscal Year 2011 City Street Financing Report.
I concur with the recommendation and respectfully request Mayor and City Council
approval.
Michael C. Van Milligen
MCVM:jh
Attachment
cc: Barry Lindahl, City Attorney
Cindy Steinhauser, Assistant City Manager
Ken TeKippe, Finance Director
Masterpiece on the Mississippi
Dubuque
bikd
AN- Amedcaclty
2007
TO: Mike Van Milligen, City Manager
FROM: Ken TeKippe, Finance Director `,,L ,4.
SUBJECT: Fiscal Year 2011 City Street Financing Report.
DATE: September 7, 2011
INTRODUCTION
The purpose of this memorandum is to request that the City Council adopt a resolution
approving the City of Dubuque's Fiscal Year 2011 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,
2011. 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 2011.
cc: Gus Psihoyos, City Engineer
Jenny Larson, Budget Director
RESOLUTION NO. 313 -11
APPROVING THE CITY OF DUBUQUE FISCAL YEAR 2011 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, 2010, to June
30, 2011, 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 19th day of September
Attest:
Kevin S. Firn ahl, City Clerk
, 2011
V. Sutton, Mayor Pro -Tem
` Iowa Department of Transportation
Form 517007 {7 -2008}
Office of Local Systems
Ames, IA 50010
City Street Financial Report
City Name
City Number
City Population
Fiscal Year
DUBUQUE
2100
57,637
2011
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.
1)Iowa Department of Transportation
Now Form 517007 {7-2008}
Office of Local Systems
Ames, IA 50010
City Street Financial Report
(Cover Sheet)
City Name
City Number
City Population
Fiscal Year
DUBUQUE
2100
57,637
2011
Now therefore let it be resolved that the city council of DUBUQUE , Iowa
(city name)
on did hereby approve and adopt the annual
(month /day /year)
City Street Financial Report from July 1, 2010 to June 30, 2011
Contact Information
(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
Preparer Inforrttation
Name
E -mail Address
Phone
Extension
Kenneth J. TeKippe
ktekippe @cityofdubuque.org
(563) 589 -4133
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
Signature Mayor
Signature City Clerk
Iowa Department of Transportation
Form 517007 {7 -2008}
Office of Local Systems
Ames, IA 50010
City Street Financial Report
(Summary Statement Sheet)
City Name
City Number
City Population
Fiscal Year
DUBUQUE
2100
57,637
2011
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
526,597
0
0
526,597
2. Adjustments
(Note on Explanation Sheet)
2,229
1,267,497
2. Bonds, Notes and Loans -
Interest Paid
2,229
3. Adjusted Balance
526,597
0
0
526,597
B. REVENUES
1. Road Use Tax
5,51,421
698,213
16,833,510
5,251,421
2. Transfer of
Jurisdictions Fund
2,229
1,267,497
2. Bonds, Notes and Loans -
Interest Paid
2,229
3. Property Taxes
8 213'"
824,617
1. Engineering
824,617
4. Special Assessments
306,311
2. Right of Way Purchased
306,311
5. Miscellaneous
9,194,961
698,213
9,893,174
6. Proceeds from Bonds,
Notes, and Loans
7,211,776
4. Traffic Services
0
7. Interest Earned
29,161
29,161
8. Total Revenues
(Lines B1 thru B7)
5,253,650
10,355,050
698,213
16,306,913
C, Total Funds Available
(Line A3 + Line B8)
5,780,247
10,355,050
698,213
16,833,510
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
2,177,409
295,860
16,660,024
2,473,269
2. Snow and Ice Removal
1,267,497
2. Bonds, Notes and Loans -
Interest Paid
173,486
1,267,497
8 213'"
E. Construction, Reconstruction and Improvements
1. Engineering
250,838
2,767,710
3,018,548
2. Right of Way Purchased
78,787
78,787
3. Street/Bridge Construction
1,250,287
5,961,489
7,211,776
4. Traffic Services
2,827
990,814
993,641
F. Administration
256,535
10,032
266,567
G. Equipment
(Purchased or Leased)
401,368
250,358
651,726
H. Miscellaneous
J. Street Debt
1. Bonds, Notes, and Loans -
Principal Paid
5,606,761
10,355,050
690 000
16,660,024
L. Ending Balance
(Line C -K)
173,486
0
2. Bonds, Notes and Loans -
Interest Paid
173,486
M. Total Funds Accounted
For (K + L = C)
8 213'"
10,355,050
' CI
TOTALS
K. Total Expenses
(Lines D thru J)
5,606,761
10,355,050
698,213
16,660,024
L. Ending Balance
(Line C -K)
173,486
0
0
173,486
M. Total Funds Accounted
For (K + L = C)
5,780,247
10,355,050
698,213
,16,833,510
` Iowa Department of Transportation
Form 517007 {7-2008}
Office of Local Systems
Ames, IA 50010
City Street Financial Report
(Miscellaneous Revenues and Expenses Sheet)
City Name
City Number
City Population
Fiscal Year
DUBUQUE
2100
57,637
2011
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
130,961
X
144 FHWA Participation (Fed. Hwy. Admin.)
2,214,621.
X
170 Reimbursements (misc.)
201,823
X
173 Reimbursement For Damages
27,656
X
174 Sales Tax / Local Option
2,367,316
X
190 Other Miscellaneous
123,065
X
194 General Fund Transfers
881,295
140 Federal Government (misc.)
3,209,945
X
192 Donations
22,376
X
■
X
195 Tax Increment Financing (TIF)
698,213
182 Property or Buildings (Sale or Rent)
15,903
X
Line B5 Totals
9,194,961
698,213
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
X
Line H Totals
Iowa Department of Transportation
Nuip7 Form 517007 {7-2008}
Office of Local Systems
Ames, IA 50010
City Street Financial Report
(Bonds, Notes, and Loans Sheet)
City Name
City Number
City Population
Fiscal Year
DUBUQUE
2100
57,637
2011
New
Bond
?
Debt Type
Debt Purpose
DOT
Use
Only
Issue
Date
Issue
Amount
% Related
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
303
03/26/2002
1,000,000
2021
690,000
690,000
8,213
0
X
New Bond Totals
0
0
Totals
690,000
690,000
8,213
0
grcA'mop Form 517007 {7 -2008}
Office of Local Systems
Ames, IA 50010
Iowa Department of Transportation
City Street Financial Report
(Project Final Costs Sheet)
City Name
City Number
City Population
Fiscal Year
DUBUQUE
2100
57,637
2011
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 ❑
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
Locust St
564,901
Roadway Construction
Yes
Resurfacing Locust from 9th - 17th streets, 2631 feet
X
2
Green Alley
136,440
Roadway Construction
Yes
Alley between Washington & Elm - 15th - 16th Streets, 300 feet
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
Locust St
Tschiggfrie Excavating
540,420
71,319
611,739
2
Green Alley
Connelly Construction
154,047
10,260
164,307
Iowa Department of Transportation
Nglip Form 517007 {7 -2008}
Office of Local Systems
Ames, IA 50010
City Street Financial Report
(Road /Street Equipment Inventory Sheet)
City Name -
City Number
City Population
Fiscal Year
DUBUQUE
2100
57,637
2011
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
X
2730
2009
Sewer Easement Machine
38,783
No
No Change
X
3298
2008
B &B Trailer
5,585
No
No Change
.X
3230
2007
Ford F550 Crew Cab
91,809
No
No Change
X
3241
2006
International
36,411
No
No Change
X
3236
2007
International 4200
101,728
No
No Change
X
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
X
3203
2008
7400 4X2 Dump Truck
94,382
No
No Change
X
3102
2007
Chevrolet Silverado
25,666
No
No Change
X
2704
2007
International 7500 SFA 6X4
194,618
No
No Change
X
2702
2008
Ford F350
31,360
No
No Change
4007
2005
Elgin Pelican P Dual Sweeper
128,285
No
No Change
X-
2715
2006
Godwin 4" Trash Pump
18,782
No
No Change
X
3242
2005
Freightliner Dump Truck w/ Henderseon Munid
75,332
No
No Change
_X
2701
2008
Ford F350
31,875
No
No Change
X
4006
2010
John Deere Tractor
79,360
No
No Change
X.
4011
2008
John Deere Lawn Tractor
13,662
No
No Change
X
4008
2010
Elgin Whirlwind Sweeper
177,010
No
No Change
- X
3290
2006
John Deere Gator
7,980
No
No Change
X
2703
2005
Jet Flusher Truck/Pipe Cleaner
88,000
No
No Change
X
2705
2009
Chevrolet 3500 Sewer Rodder Silverado
76,593
No
No Change
X
2706
1999
CH &S - 6" Trash Pump
13,846
No
No Change
X
MIowa Department of Transportation
+ Form 517007 {7 -2008}
Office of Local Systems
Ames, IA 50010
City Street Financial Report
(Road /Street Equipment Inventory Sheet)
City Name
City Number
City Population
Fiscal Year
DUBUQUE
2100
57,637
2011
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
2708
1966
Gorman Rupp - 6" Trash Pump
1,973
No
No Change
2710
1998
PECO Manhole Cutter
13,260
No
No Change
X
2719
1985
Gorman Rupp 6" Trash Pump
11,595
No
No Change
X
2721
2003
Honda 3" Trash Pump
1,197
No
No Change
X.
2711
2007
Ford Hi -Cube Van 2/ ECTV Equip
99,000
No
No Change
X
2726
2000
Portable Jet /Root Cutter
8,595
No
No Change
X
2727
2000
Kawasaki Mule 4 Wheeler
7,011
No
No Change
X .
3101
1997
Chevrolet Pickup Truck
20,869
No
No Change
X_
3201
2009
Freightliner 35,000 GVW
85,633
No
No Change
X_
3202
1998
International W /Rosco Distributor
60,795
No
No Change
X-
3204
2008
International 7400 Dump Truck
87,000
No
No Change
X
3205
2005
Freightlilner FL70 w /combo Box
73,178
No
No Change
X
3207
2003
International Tandem Dump Truck
84,730
No
No Change
X
3209
2009
John Deere endloader 6247
129,292
No
No Change
X
3210
2004
John Deere Backhoe Loader
58,375
No
No Change
X
3214
1999
John Deere Backhoe Loader
61,950
No
Traded
3215
2001
Caterpillar Vibratory Asphalt Roller
23,390
No
No Change
-X
3216
2008
International 7400 Tamdem Dump Truck
108,431
No
No Change
X.
3217
1989
Wacker Vibratory Plate Tamper
1,260
No
No Change
X
3218
2009
Freightliner Bucket Truck
137,049
No
No Change
X
3219
2001
Atlas Copco Air Compressor
7,282
No
No Change
X
3223
1998
Interanational 26,000 GVW Dump
40,500
No
Traded
. X
3223 -1
1997
Snow Equipment Anti -Icing Unit
8,176
No
No Change
X
3224
2003
Atlas Copco Air Compressor
7,819
No
No Change
X
3226
1987
John Deere Motor Grader
27,000
No
Traded
X
`4 lows Department of Transportation
Ng. Form 517007 {7 -2008}
Office of Local Systems
Ames, IA 50010
City Street Financial Report
(Road /Street Equipment Inventory Sheet)
City Name
City Number
City Population
Fiscal Year
DUBUQUE
2100
57,637
2011
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
3227
2008
John Deere Backhoe Loader
71,880
No
No Change
X
3229
1967
International Tractor
7,280
No
No Change
X
3231
2002
Ford F450 4WD
29,585
No
No Change
X-
3232
1976
Galion Roller
17,866
No
No Change
X
3233
2003
International Tandem Dump Truck
84,730
No
No Change
X
3225
2005
Dynapac CC122 12 Series
25,842
No
No Change
3235
1996
John Deere Wheel Loader
95,672
No
No Change
X
3237
2001
Atlas Copco Air Compressor
7,282
No
No Change
3238
1993
Townmaster Trailer
5,481
No
No Change
X
3240
1998
Target Pro 65 11I Concrete Saw
8,927
No
No Change
_X
3244
1992
John Deere Wheel Loader
92,000
No
No Change
X.
3245
2008
Freightliner Tandem Dump Truct
104,052
No
No Change
. X
3246
2005
Silverado 4WD 12,000 GVW Dump
37,814
No
No Change
X-
3247
1990
Cimline Crack Saw
2,381
No
No Change
X
3248
1990
Cimline Crack Saw
3,869
No
No Change
X
3250
2000
John Deere Wheel Loader
118,750
No
No Change
X
3251
1991
Caterpillar Paver - Finisher
24,411
No
No Change
X
3252
2005
Chevrolet 4WD 12,000 GVW Dump Truck
36,914
No
No Change
X
3255
2007
John Deere 6247 Endloader
136,108
No
No Change
X
3256
2008
John Deere Lawn Tractor
19,112
No
No Change
X .
3257
1997
Wacker Rammer
2,296
No
No Change
X
3258
1979
Massey Ferguson Tractor
11,500
No
No Change
X
3262
2000
Cimline Crack Sealer
18,931
No
No Change
X
3267
1985
Trailer King Trailer
2,836
No
No Change
X
3272
1991
Ingersoll Rand Roller
3,210
No
No Change
X
(Iowa Department of Transportation
Nov Form 517007 {7 -2008}
Office of Local Systems
Ames, IA 50010
City Street Financial Report
(Road /Street Equipment Inventory Sheet)
City Name
City Number
City Population
Fiscal Year
DUBUQUE
2100
57,637
2011
1.
Local Class
I.Q. #
2.
Model
Year
3.
Description
4.
Purchase
Cost
5.
Lease /Unit
Cost
6.
Rental /Unit
Cost
7.
Used on Project
this FY?
8.
Status
3212
2010
International Dump Truck
104,775
No
No Change
X
3270
2009
Huszvarna 30" Pavement Saw
21,970
No
No Change
X
3243
2009
Atlas Copco Air Compressor
10,351
No
No Change
X
3104
2010
Caterpillar Roller
48,575
No
No Change
X
3278
2002
Ingersoll Rand Roller
5,356
No
No Change
X
3279
1996
Melroe Skid -Steer Loader
26,108
No
No Change
X
3280
1993
Honda Generator
1,360
No
No Change
X
3281
1993
Speed Screed
3,327
No
No Change
X
3282
1994
Berming Machine
4,200
No
No Change
X=
3292
2008
Catepiller
277,632
No
No Change
3506
2004
Gorman Rupp 10" Trash Pump
35,720
No
No Change
X
4001
2004
Interanational 7300 w/ Lodal
76,450
No
No Change
X
4002
2004
Elgin Pelican Sweeper
93,275
No
No Change
X�
4003
1998
International Vac /Flusher Unit
124,756
No
No Change
X
4004
2009
International 56,000 GVW
105,310
No
No Change
X_
4103
1998
Sno- Go- Loader Attachment
75,000
No
No Change
X
4113
1973
Sno -Go Loader Attachment
16,450
No
Traded
X
2731
2009
John Deere Gator
9,550
No
No Change
X-
3223
2011
Freightliner w /Henderson Mono Dump Box
119,427
No
New
X
3226
2010
John Deere Motor Grader
194,335
No
New
X
3214
2010
John Deere Backhoe /Loader
82,318
No
New
X
3104
2010
Caterpillar
48,575
No
New
X
4113
2011
SNOGO unit - loader mounted
204,000
No
New
X
Add Row
r +Iowa Department of Transportation
N+ Form 517007 {7 -2008}
Office of Local Systems
Ames, IA 50010
City Street Financial Report
(Explanation Sheet)
City Name
City Number
City Population
Fiscal Year
DUBUQUE
2100
57,637
2011
Comments
In September 2010 the remaining $690,000 of 2002 CO Bond was refinanced as part of a larger bond issue ($4,470,000) covering storm water and sanitary sewer improvements,
equipment for sanitation and roads department, airport projects, improvements to street lighting, improvements for fiber optic conduit and refinancing. The refinanced portion of the
2010B bond will be funded with TIF receipts through the City's downtown TIF district. I spoke with Tammi Bell and we agreed not to include 2010B issue on the SFR report going
forward as the refunding was not directly related to a street project, and to show the offsetting revenue for the 2002 bond debt service as T1F funding.
/ Iowa Department of Transportation
Ngs. Form 517007 {7 -2008}
Office of Local Systems
Ames, IA 50010
City Street Financial Report
(Monthly Payment Sheet)
City Name
City Number
City Population
Fiscal Year
DUBUQUE
2100
57,637
2011
Month
Road Use
Tax Payments
Transfer of
Jurisdictions Payments
JULY
$319,641.97
$93.97
AUGUST
$588,773.52
$194.88
SEPTEMBER
$555,100.91
$245.95
OCTOBER
$409,219.26
$180.49
NOVEMBER
$482,727.29
$213.54
DECEMBER
$422,313.53
$186.35
JANUARY
$434,847.17
$192.44
FEBRUARY
$505,319.24
$223.47
MARCH
$527,314.78
$241.24
APRIL
$374,595.97
$169.84
MAY
$444,593.49
$203.62
JUNE
$186,973.67
$83.21
Totals
$5,251,420.80
$2,229.00