City Street Financial Report FY 2010Masterpiece on the Mississippi
TO: The Honorable Mayor and City Council Members
FROM: Michael C. Van Milligen, City Manager
SUBJECT: Fiscal Year 2010 City Street Financing Report
DATE: August 31, 2010
Finance Director Ken TeKippe recommends City Council approval of the City of
Dubuque's Fiscal Year 2010 City Street Financing Report.
MCVM:jh
Attachment
cc: Barry Lindahl, City Attorney
Cindy Steinhauser, Assistant City Manager
Ken TeKippe, Finance Director
MicI1 eI C. Van Milligen
Dubuque
All-America City
i r
2007
I concur with the recommendation and respectfully request Mayor and City Council
approval.
Masterpiece on the Mississippi
TO: Mike Van Milligen, City Manager
FROM: Ken TeKippe, Finance Director C-le -
SUBJECT: Fiscal Year 2010 City Street Financing Report.
DATE: August 30, 2010
INTRODUCTION
The purpose of this memorandum is to request that the City Council adobt a resolution
approving the City of Dubuque's Fiscal Year 2010 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,
2010. 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 2010.
cc: Gus Psihoyos, City Engineer
Jenny Larson, Budget Director
Dubuque
AI- America Cay
1 1 11 '
2007
RESOLUTION NO. 341-10
APPROVING THE CITY OF DUBUQUE FISCAL YEAR 2010 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, 2009, to June
30 ,2010, 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 7th day of September
Attest:
Jeanne F. Schneider, CMC, City Clerk
Roy D. Buol, Mayor
Name
E -mail Address
Street Address
City
ZIP Code
Jeanne F. Schneider
jschneid @cityofdubuque.org
50 West 13th Street
Dubuque, IA
52001 -4864
Hours
Phone
Extension
Phone (Home)
8:00 AM - 5:00 PM
(563) 589 -4121
(563) 589 -4121
City Name
City Number
City Population
Fiscal Year
DUBUQUE
2100
57,686
2010
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
OrA Iowa Department of Transportation
Form 517007 {7 -2008}
Office of Local Systems
Ames, IA 50010
Contact Information
Preparer Information
Mayor Information
City Street Financial Report
(Cover Sheet)
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, 2009 to June 30, 2010
(year) (year)
Signature Mayor
Resolution Number
Signature City Clerk
Submit
B. REVENUES
1. Road Use Tax
5,103,077
3,140,580
422
5,103,077
2. Transfer of
Jurisdictions Fund
2,251
1,488,933
0
2,251
3. Property Taxes
7,002,171
391,227
79,335
470,562
4. Special Assessments
496,768
2. Right of Way Purchased
496,768
5. Miscellaneous
8,315,028
3. Street/Bridge Construction
8,315,028
6. Proceeds from Bonds,
Notes, and Loans
2,290,707
4. Traffic Services
0
7. Interest Earned
13,690
13,690
8. Total Revenues
(Lines B1 thru B7)
5,105,328
9,216,713
79,335
14,401,376
EXPENSES
D. Maintenance
1. Roadway Maintenance
3,140,580
422
15,771,622
3,141,002
2. Snow and Ice Removal
1,488,933
0
526,597
1,488,933
7,002,171
E. Construction, Reconstruction and Improvements
1. Engineering
200,042
3,117,967
3,318,009
2. Right of Way Purchased
3,097,826
3,097,826
3. Street/Bridge Construction
813,548
1,477,159
2,290,707
4. Traffic Services
1,359,786
1,359,786
TOTALS
K. Total Expenses
(Lines D thru J)
6,475,574
9,216,713
79,335
15,771,622
L. Ending Balance
(Line C -K)
526,597
0
0
526,597
M. Total Funds Accounted
For (K +L =C)
7,002,171
9,216,713
79,335
16,298,219
A. BEGINNING BALANCE
1. July 1 Balance
1,896,843
0
0
1,896,843
2. Adjustments
(Note on Explanation Sheet)
.. -
2. Bonds, Notes and Loans -
Interest Paid
--
3. Adjusted Balance
1,896,843
0
0
1,896,843
J. Street Debt
1. Bonds, Notes, and Loans -
Principal Paid
City Population
Fiscal Year
45,000
2100
57,686
.. -
2. Bonds, Notes and Loans -
Interest Paid
--
34,335
- `r
r
City Name
City Number
City Population
Fiscal Year
DUBUQUE
2100
57,686
2010
Mlowa Department of Transportation
N— Form 517007 {7 -2008}
Office of Local Systems
Ames, IA 50010
Column 1 Column 2 Column 3 Column 4
Road Use Other Street Street Debt Totals
Tax Fund Monies
Round Figures to Nearest Dollar
C. Total Funds Available
(Line A3 + Line B8)
7,002,171
9,216,713
79,335
16,298,219
City Street Financial Report
(Summary Statement Sheet)
Submit
Column 1 Column 2 Column 3 Column 4
Road Use Other Street Street Debt Totals
Tax Fund Monies
Round Figures to Nearest Dollar
F. Administration
216,284
10,530
226,814
G. Equipment
(Purchased or Leased)
616,187
153,023
769,210
H. Miscellaneous
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
729,060
57,686
X`
140 Federal Government (misc.)
3,151,120
X_
144 FHWA Participation (Fed. Hwy. Admin.)
1,584,709
190 Other Miscellaneous
41,343
-X
194 General Fund Transfers
364,812
' X
174 Sales Tax / Local Option
2,443,984
X=
Line B5 Totals
8,315,028
City Name
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
DUBUQUE
2100
57,686
2010
Line H Totals
City Name
City Number
City Population
Fiscal Year
DUBUQUE
2100
57,686
2010
A lowa Department of Transportation
*+ Form 517007 {7 -2008}
Office of Local Systems
Ames, IA 50010
City Street Financial Report
(Miscellaneous Revenues and Expenses Sheet)
Submit
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
100%
2021
735,000
45,000
34,335
45,000
34,335
690,000
_X
New Bond Totals
0
Totals
735,000
45,000
34,335
45,000
34,335
690,000
City Name
City Number
City Population
Fiscal Year
DUBUQUE
2100
57,686
2010
A Iowa Department of Transportation
+ Form 517007 {7 -2008}
Office of Local Systems
Ames, IA 50010
City Street Financial Report
(Bonds, Notes, and Loans Sheet)
." Submit
Line
No.
Contract Work
2.
Estimated Cost
City Labor
4.
Public Letting?
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
Cleveland Ave
Horsfield Construction
1,684,371
- 14,788
3
Green Alley
256,259
1,669,583
2
US 52 Resurface
River City Paving
931,240
197,274
1,128,514
3
Green Alley
Portzen Construction
215,274
- 15,307
199,967
Line
No.
1.
Project Number
2.
Estimated Cost
3.
Project Type
4.
Public Letting?
5.
Location /Project Description (limits, length, size of structure)
57,686
1
Cleveland Ave
1,795,266
Roadside Construction
Yes
Cleveland Ave Reconstruction, Bryant to Villa - 3123 11
2
US 52 Resurface
846,678
Roadside Construction
Yes
US 52 Resurfacing, 32nd St to IA 32 - 5200 ft.
3
Green Alley
256,259
Roadside Construction
Yes
Green Alley between White & Jackson from 11th to 13th St.
City Name
City Number
City Population
Fiscal Year
DUBUQUE
2100
57,686
2010
( Iowa Department of Transportation
Form 517007 {7 -2008}
Office of Local Systems
Ames, IA 50010
City Street Financial Report
(Project Final Costs Sheet)
Submit
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 ❑
Section B
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
3217
1989
Wacker Vibratory Plate Tamper
1,260
No
No Change
rte=
3216
2008
International 7400 Tamdem Dump Truck
108,431
No
No Change
3215
2001
Caterpillar Vibratory Asphalt Roller
23,390
No
No Change
X_
3214
1999
John Deere Backhoe Loader
61,950
No
No Change
=X
3212
2002
Freightliner 31,00 GVW Dump
49,510
No
Traded
X_
3210
2004
John Deere Backhoe Loader
58,375
No
No Change
�X
3209
2009
John Deere endloader 6247
129,292
No
No Change
3207
2003
International Tandem Dump Truck
84,730
No
No Change
-X=
3205
2005
Freightlilner FL70 w /combo Box
73,178
No
No Change
X=
3204
2008
International 7400 Dump Truck
87,000
No
No Change
-X
3202
1998
International W /Rosco Distributor
60,795
No
No Change
3201
2009
Freightliner 35,000 GVW
85,633
No
No Change
X i
3101
1997
Chevrolet Pickup Truck
20,869
No
No Change
2727
2000
Kawasaki Mule 4 Wheeler
7,011
No
No Change
X1
2726
2000
Portable Jet/Root Cutter
8,595
No
No Change
rX'.
2711
2007
Ford Hi -Cube Van 2/ ECTV Equip
99,000
No
No Change
X
2721
2003
Honda 3" Trash Pump
1,197
No
No Change
X=
2719
1985
Gorman Rupp 6" Trash Pump
11,595
No
No Change
X
2710
1998
PECO Manhole Cutter
13,260
No
No Change
C;
2708
1966
Gorman Rupp - 6" Trash Pump
1,973
No
No Change
_=X_:
2706
1999
CH &S - 6" Trash Pump
13,846
No
No Change
-XT
2705
2009
Chevrolet 3500 Sewer Rodder Silverado
76,593
No
No Change
_-
2703
2005
Jet Flusher Truck/Pipe Cleaner
88,000
No
No Change
= -X-
2701
2008
Ford F350
31,875
No
No Change
4008
2010
Elgin Whirlwind Sweeper
177,010
No
New
X=-
City Name
City Number
City Population
Fiscal Year
DUBUQUE
2100
57,686
2010
( Iowa Department of Transportation
'Nip Form 517007 {7 -2008}
Office of Local Systems
Ames, IA 50010
City Street Financial Report
(Road /Street Equ'pment Inventory Sheet)
Submit
City Name
City Number
City Population =
Fiscal Year
DUBUQUE
2100
57,686
2010
1.
Local Class
I.D. #
2.
Model
Year
3.
D escription
4.
Purchase
Cost
5.
Lease /Unit
Cost
6.
Rental /Unit
Cost
7.
Used on Project
this FY?
8.
Status
3290
2006
John Deere Gator
7,980
No
New
3243
2009
Atlas Copco Air Compressor
10,351
No
New
3104
2010
Caterpillar Roller
48,575
No
New
3242
2005
Freightliner Dump Truck w/ Henderseon Munid
75,332
No
No Change
2715
2006
Godwin 4" Trash Pump
18,782
No
No Change
?4
4007
2005
Elgin Pelican P Dual Sweeper
128,285
No
No Change
r=
2702
2008
Ford F350
31,360
No
No Change
2704
2007
International 7500 SFA 6X4
194,618
No
No Change
3102
2007
Chevrolet Silverado
25,666
No
No Change
_
3203
2008
7400 4X2 Dump Truck
94,382
No
No Change
3206
2006
International 7400
36,411
No
No Change
3208
2006
International 7400
36,411
No
No Change
3213
2007
John Deere Backhoe Loader
67,754
No
No Change
3236
2007
International 4200
101,728
No
No Change
3241
2006
International
36,411
No
No Change
3230
2007
Ford F550 Crew Cab
91,809
No
No Change
3298
2008
B &B Trailer
5,585
No
No Change
2730
2009
Sewer Easement Machine
38,783
No
No Change
4034
2009
JD Skid loader
32,058
No
No Change
4011
2010
John Deere Lawn Tractor
13,662
No
New
4006
2010
John Deere Tractor
79,360
No
New
3270
2009
Huszvarna 30" Pavement Saw
21,970
No
New
3212
2010
International Dump Truck
104,775
No
New
2731
2009
John Deere Gator
9,550
No
New
-X
`AIowa Department of Transportation
Nu. Form 517007 {7 -2008}
Office of Local Systems
Ames, IA 50010
City Street Financial Report
(Road /Street Equipment Inventory Sheet)
Submit
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
3252
2005
Chevrolet 4WD 12,000 GVW Dump Truck
36,914
No
No Change
_ = °X
3251
1991
Caterpillar Paver - Finisher
24,411
No
No Change
3250
2000
John Deere Wheel Loader
118,750
No
No Change
3248
1990
Cimline Crack Saw
3,869
No
No Change
= X=
3247
1990
Cimline Crack Saw
2,381
No
No Change
3246
2005
Silverado 4WD 12,000 GVW Dump
37,814
No
No Change
3245
2008
Freightliner Tandem Dump Truct
104,052
No
No Change
3244
1992
John Deere Wheel Loader
92,000
No
No Change
3243
1991
Sullair Air Compressor
9,599
No
Traded
3240
1998
Target Pro 65 III Concrete Saw
8,927
No
No Change
3238
1993
Townmaster Trailer
5,481
No
No Change
X=
3237
2001
Atlas Copco Air Compressor
7,282
No
No Change
=:X
3235
1996
John Deere Wheel Loader
95,672
No
No Change
-X-
3225
2005
Dynapac CC122 12 Series
25,842
No
No Change
=X=
3233
2003
International Tandem Dump Truck
84,730
No
No Change
3232
1976
Galion Roller
17,866
No
No Change
3231
2002
Ford F450 4WD
29,585
No
No Change
3229
1967
International Tractor
7,280
No
No Change
3227
2008
John Deere Backhoe Loader
71,880
No
No Change
=X
3226
1987
John Deere Motor Grader
27,000
No
No Change
3224
2003
Atlas Copco Air Compressor
7,819
No
No Change
C-
3223 -1
1997
Snow Equipment Anti -icing Unit
8,176
No
No Change
3223
1998
Interanational 26,000 GVW Dump
40,500
No
No Change
=X =-
3219
2001
Atlas Copco Air Compressor
7,282
No
No Change
3218
2009
Freightliner Bucket Truck
137,049
No
No Change
C
City Name
City Number
City Population
Fiscal Year
DUBUQUE
2100
57,686
2010
Form 517007 {7 -2008}
Office of Local Systems
Ames, IA 50010
Iowa Department of Transportation
City Street Financial Report
(Road /Street Equipment Inventory Sheet)
Submit
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
_..
4113
1973
Sno -Go Loader Attachment
16,450
No
No Change
4103
1998
Sno -Go- Loader Attachment
75,000
No
No Change
4011
1999
John Deere Lawn Tractor
7,300
No
Traded
477
ft4;11
4008
2002
Freightliner Air Johnston Sweeper
115,360
No
Traded
4006
1988
John Deere Tractor
36,000
No
Traded
4004
2009
International 56,000 GVW
105,310
No
No Change
4003
1998
International Vac /Flusher Unit
124,756
No
No Change
4002
2004
Elgin Pelican Sweeper
93,275
No
No Change
4001
2004
Interanational 7300 w/ Lodal
76,450
No
No Change
3506
2004
Gorman Rupp 10" Trash Pump
35,720
No
No Change
3292
2008
Catepiller
277,632
No
No Change
dti
3282
1994
Berming Machine
4,200
No
No Change
3281
1993
Speed Screed
3,327
No
No Change
3280
1993
Honda Generator
1,360
No
No Change
3279
1996
Melroe Skid -Steer Loader
26,108
No
No Change
3278
2002
Ingersoll Rand Roller
5,356
No
No Change
3272
1991
Ingersoll Rand Roller
3,210
No
No Change
J'
3270
1990
Target Pro 65 Concrete Saw
7,740
No
Traded
3267
1985
Trailer King Trailer
2,836
No
No Change
Ci)4
3262
2000
Cimline Crack Sealer
18,931
No
No Change
3258
1979
Massey Ferguson Tractor
11,500
No
No Change
3257
1997
Wacker Rammer
2,296
No
No Change
_
3256
2008
John Deere Lawn Tractor
19,112
No
No Change
3255
2007
John Deere 6247 Endloader
136,108
No
No Change
--
City Name
City Number
City Population
Fiscal Year
DUBUQUE
2100
57,686
2010
Nip A lowa Department of Transportation
Form 517007 {7 -2008}
Office of Local Systems
Ames, IA 50010
City Street Financial Report
(Road /Street Equipment Inventory Sheet)
Check here if there are no reportable equipment
Submit
City Name
City Number
City Population
Fiscal Year
DUBUQUE
2100
57,686
2010
Iowa Department of Transportation
Imp Form 517007 {7 -2008}
Office of Local Systems
Ames, IA 50010
City Street Financial Report
(Explanation Sheet)
rf Submit
Comments
Month
Road Use
Tax Payments
Transfer of
Jurisdictions Payments
JULY
$390,816.52
$172.35
AUGUST
$431,284.16
$190.68
SEPTEMBER
$415,517.66
$183.18
OCTOBER
$555,522.60
$239.35
NOVEMBER
$456,103.28
$212.38
DECEMBER
$372,933.14
$153.42
JANUARY
$402,885.64
$178.14
FEBRUARY
$467,414.28
$209.12
MARCH
$473,823.56
$210.61
APRIL
$400,554.16
$178.06
MAY
$412,226.02
$181.76
JUNE
$323,995.58
$141.91
Totals
$5,103,076.60
$2,250.96
City Name
City Number
City Population
Fiscal Year
DUBUQUE
2100
57,686
2010
( Iowa Department of Transportation
N_ Form 517007 {7 -2008}
Office of Local Systems
Ames, IA 50010
City Street Financial Report
(Monthly Payment Sheet)
to Submit