City Street Financial Report FY 2009THE CITY OF J,,,, ~ Dubuque
A~-M~ricBCity
DuB E
~ r
Masterpiece an the Mississippi
2007
TO: The Honorable Mayor and City Council Members
FROM: Michael C. Van Milligen, City Manager
SUBJECT: Fiscal Year 2009 City Street Finance Report
DATE: September 15, 2009
Assistant City Engineer Bob Schiesl recommends City Council approval of the City of
Dubuque's Fiscal Year 2009 City Street Finance Report to be submitted to the Iowa
Department of Transportation.
I concur with the recommendation and respectfully request Mayor and City Council
approval.
chael C. Van Milligen
MCVM:jh
Attachment
cc: Barry Lindahl, City Attorney
Cindy Steinhauser, Assistant City Manager
Robert Schiesl, Assistant City Engineer
Gus Psihoyos, City Engineer
THE CITY OF ~ Dubuque
.~'~JB _ ~
~~ I~-
~a
sterpiece an the 1V1ZSSissrppr Zoos
TO: Michael C. Van Milligen, City Manager
FROM: Robert Schiesl, Assistant City Engineer ~ ~~
DATE: September 15, 2009
SUBJECT: Fiscal Year 2009 City Street Finance Report
INTRODUCTION
The purpose of this memorandum is to request the City Council to adopt a resolution
approving the City of Dubuque's Fiscal Year 2009 City Street Finance 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,
2009. 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 2009.
cc: Gus Psihoyos, City Engineer
Jenny Larson, Budget Director
Ken TeKippe, Finance Director
RESOLUTION NO. 347-09
APPROVING THE CITY OF DUBUQUE FISCAL YEAR 2009 CITY STREET
FINANCE REPORT
NOW THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE
CITY OF DUBUQUE, IOWA:
Section 1. That the City Street Finance Report for the period of July 1,
2008, to June 30, 2009, 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 21St day of September, 2009.
Attest:
eanne F. Schneider, CMC, City Clerk
Jo c E. onnors, Mayor Pro-Tem
~~awaoeva . . ,of ,,....w,,,,,,bW,,., City Street Financial Report once use only
~`~ Form 517007 (7-200~g. 1) (Cover Sheet)
Office of Local Systems
Ames, IA 50010
City Name City Number City Population Fiscal Year
DUBUQUE 2100 57,686 2009
Now therefore let it be resolved that the city council of Dubuque, Iowa Iowa
Contact Information
Name
Jeanne F. Schneider
Hours
8:00 AM - 5:00 PM
Preparer Information
Name
Kenneth J. TeKippe
Mayor Information
Name
Roy D. Buol
Phone
(city name)
on did hereby approve and adopt the annual
(month/day/year)
City Street Financial Report from July 1, 2008 to June 30, 2009 .
E-mail Address Street Address City ZIP Code
jschneid@cityofdubuque.org 50 West 13th Street Dubuque, IA 52001-4864 _
Phone Extension Phone (Home)
E-mail Address Phone Extension
ktekippe@cityofdubuque.org (563) 589-4133
E-mail Address Street Address City ZIP Code
rbuol@cityofdubuque.org 50 West 13th Street Dubuque, IA 52001-4864
Extension '
Resolution Number
Roy D. Buol
Signature
Mayor
Jeanne F. Schneider
Signature
City Clerk
~~lowaoeaa ~ .ofTra..~,..,.,d,:~.~ City Street Financial Report
Form 517007 (7-200~g. 2) (Summary Statement Sheet)
~~ Office of Local Systems
Ames, IA 50010
City Name City Number
DUBUQUE z too
Column 1 Column 2 Column 3 Column 4
Road Use Other Street Street Debt Totals
Tax Fund Monies
Round Figures to Nearest Dollar
~. BEGINNING BALANCE
1. July 1 Balance
2. Adjustments
(Note on Explanation Sheet)
3. Adjusted Balance 1
~B. REVENUES
1. Road Use Tax 1
2. Transfer of
Jurisdictions Fund
3. Property Taxes 1
I` 4. Special Assessments 1
5. Miscellaneous 1
6. Proceeds from Bonds,
Notes, and Loans
7. Interest Earned 1
~~~~ ~-8-Total Revenues-~
(Lines B1 thru B7)
C. Total Funds Available
(Line A3 + Line 68)
City Population Fiscal Year
57,686 2009
Column 7 Column 2 Column 3 Column 4
Road Use Other Street Street Debt Totals
Tax Fund Monies
Round Figures to Nearest Dollar
EXPENSES
2;181,906 0 0 2,181,906 D. Maintenance
1. Roadway Maintenance 1 2,947,8021 789,260 3,737,062
2. Snow and Ice Removal 1 1,234,2411 1,234,241
2,181,406 0 0 2,181,906
IE. Construction, Reconstruction
and Improvements
1. Engineering 1
~ 58,4441 691,4231 749,867
4,786,4901 4,786,490 2. Right of Way Purchased 13,191
I 13,191
2,143 2,143 ~ 3. Street/Bridge Construction 1 232,6001 3,386,0361 3,618,636
4. Traffic Services I 8111 61,5421 62,353
1 2,645,487 81,135 2,726,622
1 148
696 I F. Administration 1 101,6541 220,9661 1 322
620)
, 148,696 ,
( 3,073,164 3,073,164 G. Equipment
(Purchased or Leased) 484,953 765,859 1,250,812
o ~ H. Miscellaneous 1 1 1 1
1
~~~. 47,739 47,739
~ J. Street Debt
4,788,633 5,915,086 81,135 10,784,854 1. Bonds, Notes, and Loans -
_ Principal Paid 45,000 45,000
6,970,539
5,915,086
81,135 12,966,760 2. Bonds, Notes, and Loans -
Interest Paid
36,135
36,135
TOTALS
K. Total Expenses
(Lines D thru J)
5,073,696
5,915,086
81,135
11,069,917
L. Ending Balance
(Line C - K) 1,896,843 p 0 1,896,843
M. Total Funds Accounted For
(K+L=C) 6,970,539 5,915,086 81,135 12,966,760
Form 517007 (7-200~g. 3)
\r Office of Local Systems
Ames, IA 50010
City Name
DUBUQUE
City Street Financial Report
(Miscellaneous Revenues and Expenses Sheet)
City Number
2100
City Population
57,686
Code Number and Itemization of Miscellaneous Revenues (Line B5 on the Summary Statement Sheet)
(See Instructions)
140 Federal Government (misc.)
170 Reimbursements (misc.)
173 Reimbursement For Damages
1174 Sales Tax /Local Option
180 Receipts From Sales
181 Junk and Old
121 State Reimbursement
1
Line 65 Totals
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 feeds, bond fees, etc.
(See Instructions)
1
Line H Totals
Fiscal Year
2009
column 2 Column 3
Other Street Street Debt
Monies
OI
648,0421
104,1351
19,3491
2,288,0921
2281
4,2831
9,0351
1
3,073,164
Column 2 Column 3
Other Street Street Debt
Monies
/_~ Iowa G .,. ~ ~ . of r. ~..,~,,,.,, :a w,., t
~qp Form 517007 (7-200~g. 4)
~~ Office of Local Systems
Ames, IA 50010
City Name
DUBUQUE
Is this a
new bond?
Yes I No
X
I
I
I
I
Debt Type
(General Obligation
I
I
I
Debt Purpose
City Number
2100
(Paving & Construction
II
JI
I
II
I
I~
I
II
I
Paving & Construction
City Street Financial Report
(Bonds, Notes, and Loans Sheet)
DOT
Use
Only
303
City Population
57,686
Issue Issue Year
Date Amount Due
(MM/DD/YYYYJ
03/26/2002
I
New Bond Totals+
1,000,000(
I
I
II
I
I~
II
I
II
I
II
I
II
I
0~
2021
Totals
Principal
Balance as
of 7/1 or after
780,000(
I
I
I~
I
I~
I
II
I
I~
II
I
780,000
Fiscal Year
2009
Principal Interest Principal
Paid Paid Balance as
of 6130
45,000+I
I
II
I
I~
I
I~
I
I~
II
I
II
I
I~
I
I~
I
45,000
36,1351 735,000
I
I~
II
II
I
II
I
36,135
735,000
~~ iowa Depa. ~.,,,~,~,t of Tra.,,,,.,~ ,.motion
Form 517007 (7-200~g. 5)
~~ Office of Local Systems
Ames, IA 50010
City Name
DUBUQUE
Section A
1.
Line Project Number
No.
1 (Quince Steet
2
3
4
5
6
7
8
9
City Street Financial Report (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
City Number
2100
2. 3.
Estimated Project Type
Cost
106,257IRoadway Construction
City Population
57,686
Fiscal Year
2009
4. 5.
Public Location/Project Description (limits, length, size of structure)
Letting?
Yes +(Quince Street econstruction, Rush to Cleveland, length
I
II
II
I
Section B
Contract Work I
1• s• 7. 8. 9.
Line Project Number Contractor Name Contract Additions/ Labor
No. Price Deductions
I1 (Quince Steet (Top Grade Excavating I 107,4531 -4,8801
~2 ~ ~ ~ I ~
3 I I I II
4 I I I i
5 I
6 I
`7 I
18 I ~ ~ i 1
19
City Labor
10. 11.
Equipment Materials
Check here if there are ^
no entries for this year
12.
Overhead
I
I
13.
Total
102,573
~~awaoea~.~„~„~oP,ra.,,,,,,,~,au„„ City Street Financial Report
~- off a of Local Systems 6) (Road/Street Equipment Inventory Sheet)
Ames, IA 50010
164501 I I No ~No Change
750001 I I No IIVo Change
73001 I I No INo Change
1153601 ~ I No INo Change
36000 I ~ No ~No Change
105310 ~ + No (New
775001 + ~ No (Traded
124756 ~ ~ No ~No Change
93275 ~ ~ No ~No Change
76450 I ~ No lNo Change
35720 I I No INo Change
City Name City Number City Population Fiscal Year
DUBUQUE 2100 57,686 2009
1. 2. 3. 4. -5. 6. 7. 8.
Local Class Model Description Purchase Lease /Unit Rental /Unit Used Status
I.D. # Year Cost Cost Cost on Project
this FY?
113
103
11
4001
3506
3292
3292
3286
3282
3281
3280
3279
13278
3272
3270
3267
3262
11973 ISno-Go Loader Attachment
11998 ISno-Go-Loader Attachment
11999 (John Deere Lawn Tractor
12002 (Freightliner Air Johnston Sweeper
11988 (John Deere Tractor
2009 ~Internationa156,000 GVW
2001 IInteranationa156,000 GVW Dump
1998 +International Vac/Flusher Unit
12004 (Elgin Pelican Sweeper
12004 IInteranational 7300 w/ Lodal
12004 (Gorman Rupp 10" Trash Pump
12008 ICatepiller
11998 (Barber Green Asphalt Paver
1984 (Doolittle Utility Trailer
1994 IBerming Machine
11993 (Speed Screed
11993 (Honda Generator
1996 IMelroe Skid-Steer Loader
2002 (Ingersoll Rand Roller
11991 (Ingersoll Rand Roller
11990 (Target Pro 65 Concrete Saw
11985 (Trailer King Trailer
2000 ICimline Crack Sealer
Check here if there are
no reportable equipment ^
No
164666 ~ ~ No Traded
1150 ~ ~ No ~N/A
42001 I ~ No INo Change
I 3327 I + No INo Change
1360 ~ ~ No INo Change
26108 ~
5356 + I No
~ No INo Change
~No Change
3210 ~ ~ No ~No Change
7740 I + No I1Vo Change
I 2836 I ~ No INo Change
18931+ ~ ~ No ~No Change
~~rowaoepa ~ ... of „m„,,,,,,,,a~,an City Street Financial Report
Form 517007 (7-200~1g. 6) (Road/Street Equipment Inventory Sheet)
~~ Office of Local Systems
Ames, IA 50010
City Name City Number City Population
DUBUQUE 2100 57,686
Check here if there are ^
no reportable equipment
Fiscal Year
2009
1.
Local Class
I
D
# 2.
Model
Year 3. 4. 5.
Description Purchase Lease /Unit 6. 7.
Rental /Unit Used 8.
Status
.
. Cost Cost Cost on Project
this FYI
3258 11979 (Massey Ferguson Tractor I 115001 I I No INo Change
3257 11997 (Wacker Rammer I 2296+ I ! No INo Change
3256 12008 (John Deere Lawn Tractor ~ 19112( , ~ No INo Change
3255 12007 (John Deere 6247 Endloader 136108 No o Change
3252 12005 Chevrolet 4WD 12,000 GVW Dump Truck 36914 No o Change
3251 11991 Caterpillar Paver-Finisher J 24411+ ~ ~ No 'No Change
3250 ~ 2000 John Deere Wheel Loader ~ 118750 ~ ~ No ~1Vo Change
3248 ~ 1990 ~Cimline Crack Saw I 3869 ~ ~ No ~No Change
3247 ~ 1990 ICimline Crack Saw ~ 2381 + ~ No INo Change
3246 J 2005 ~Silverado 4WD 12,000 GVW Dump ~ 37814+ ~ ~ No ~No Change
3245 12008 (Freightliner Tandem Dump Truct ~ 104052 ~ ~ No ~No Change
13244 11992 (John Deere Wheel Loader I 92000 ~ + No ~No Change
3243 11991 ~Sullair Air Compressor I 9599 ~ ~ No ~1o Change
3240 11998 Target Pro 65 III Concrete Saw ~ 8927 ~ ~ No ~No Change
3238 ~ 1993 ITownmaster Trailer ~ 5481+ ! ~ No ~No Change
13237 ~ 2001 (Atlas Copco Air Compressor ~ 7282 ~ + No INo Change
3235 11996 (John Deere Wheel Loader I 95672 ~ ~ No ~No Change
3225 12005 IDynapac CC122 12 Series I 25842 ~ ~ No ~No Change
3233 12003 (International Tandem Dump Truck ~ 84730 ~ ~ No INo Change
3232 11976 (Galion Roller ~ 17866+ ~ + No INo Change
3231 ~ 2002 (Ford F450 4WD ~ 29585 ~ ~ No ~No Change
3229 11967 (International Tractor I 7280 + ~ No ~No Change
3227 ~ 2008 (John Deere Backhoe Loader I 71880
No
New
~~bwaoeva : ~..ofLw.~~.,.~n City Street Financial Report
\~ Form 517007 (7-200~g. 6) (Road/Street Equipment Inventory Sheet)
Office of Local Systems Check here if there are ^
Ames, IA 50010 no reportable equipment
City Name City Number City Population Fiscal Year
DUBUQUE 2100 57,686 2049
1.
Local Class
I
D
# 2.
Model
Year 3. 4. 5. 6.
Description Purchase Lease /Unit Rental 7.
/Unit Used 8.
Status
.
. Cost Cost Cost on Project
this FY?
3227 11994 (John Deere Backhoe Loader I 618251 I I No (Traded
3226 11987 (John Deere Motor Grader ~ 270001 + ~ No INo Change
3224 12003 (Atlas Copco Air Compressor I 7819+ I + No INo Change
3223-1 11997 (Snow Equipment Anti-Icing Unit I 8176, I , No INo Change
3223 11998 ~Interanationa126,000 GVW Dump ~ 405001 ~ ~ No ~No Change
3219 12001 Atlas Copco Air Compressor ~ 7282 ~ ~ No ~No Change
3218 12009 ,Freightliner Bucket Truck I 137049 ~ ~ No New
3218 ~ 1996 (International Ladder Truck I 81646+ ~ ~ No (Traded
3217 11989 (Wacker Vibratory Plate Tamper ~ 1260 ~ ~ No ~No Change
3216 ~ 2008 IInternationa17400 Tamdem Dump Truck I 108431 ~ ~ No ~No Change
13215 , 2001 (Caterpillar Vibratory Asphalt Roller I 23390 + ~ No lNo Change
3214 11999 (John Deere Backhoe Loader I 61950 , ~ No ~No Change
3212 12002 (Freightliner 31,00 GVW Dump I 49510 ~ ~ No ~No Change
3210 12004 (John Deere Backhoe Loader ~ 58375+ ~ ~ No ~No Change
3209 12009 (John Deere endloader 6247 ~ 129292 ~ ~ No New
3209 11979 (John Deere Motor Grader l 25060 + ~ No Traded
3207 12003 (International Tandem Dump Truck I 84730 ~ + No INo Change
3205 12005 IFreightlilner FL70 w/combo Box I 73178 ~ ~ No ~No Change
3204 ~ 2008 (International 7400 Dump Truck I 87000+ ~ ~ No ~No Change
3202 ~ 1998 (International W/Rosco Distributor ~ 60795 ~ ~ No ~No Change
3201 ~ 1999 (International 26,000 GVW Dump ~ 41200 ~ + No (Traded
3201 J 2009 (Freightliner 35,000 GVW J 85633 ~ ~ No (New
3101 11997 (Chevrolet Pickup Truck ~ 20869 ~ ~ No ~No Change
~~rowaoer~aartr„entof,,~„,.~,,,,;~w„n City Street Financial Report
Form 517007 (7-200~g. 6) (Road/Street Equipment Inventory Sheet)
\~ Office of Local Systems
Ames, IA 50010
City Name City Number City Population
DUBUQUE 2100 57,686
Check here if there are ^
no reportable equipment
Fiscal Year
2009
1.
Local Class
I
D
# 2. 3. 4. 5. 6.
Model Description Purchase Lease /Unit Rental
Year 7.
/Unit Used 8.
Status
.
. Cost Cost Cost on Project
this FY?
2727 12000 (Kawasaki Mule 4 Wheeler I 70111 I I No INo Change
2726 12000 (Portable Jet/Root Cutter I 8595 ~ + No INo Change
2711 12007 (Ford Hi-Cube Van 2/ ECTV Equip I 99000 I + No (New
2721 12003 (Honda 3" Trash Pump I l 1971 ~ + No INo Change
2719 11985 (Gorman Rupp 6" Trash Pump I 11595 ~ + No INo Change
2711 11984 IGMC Van W/ TV Camera I 65400 ~ ~ No (Traded
2710 ~ 1998 IPECO Manhole Cutter I 13260 ~ ~ No INo Change
2708 ~ 1966 (Gorman Rupp - 6" Trash Pump I 1973 ~ ~ No INo Change
2706 11999 ICH&S - 6" Trash Pump I 13846 ~ I No INo Change
12705 ~ 2009 (Chevrolet 3500 Sewer Rodder Silverado I 76593 ~ ~ No INo Chan
e
2703 ~ 2005 (Jet Flusher Truck/Pipe Cleaner I 88000 + I No g
INo Chan
e
2701 1 2008 (Ford F350 I 31875 + I No g
INo Chan
e
13242 ~ 2005 (Freightliner Dump Truck w/ Henderseon Muni Body I 75332 ~ 1 No g
INo Chan
e
2715 ~ 2006 (Godwin 4" Trash Pump I 18782 + I No g
INo Change
4007 1 2005 (Elgin Pelican P Dual Sweeper I 1282851 + ~ No INo Change
3242 2005 Freightliner Dump Truck w/ Henderseon Muni Body 87332 ~ No ~No Change
2702 2008 Ford F350 31360 1 No INo Change
2704 12007 (International 7500 SFA 6X4 I 1946181 1 1 No 1No Change
13102 ~ 2007 1Chevrolet Silverado I 256661 ~ + No 1No Change
3203 12008 17400 4X2 Dump Truck I 943821 I + No INo Change
3206 12006 (International 7400 I 364111 I + No INo Change
13208 1 2006 (International 7400 I 364111 ~ + No INo Change
3213 12007 (John Deere Backhoe Loader I 67754+ I ~ No 1N
Ch
o
ange
/~~awa Dope, ~.,,:...~ oP rra~,.~,~ .anon
~~~~'' Form 517007 (7-200~g. 6)
`~ Office of Local Systems
Ames, IA 50010
City Name
DUBUQUE
1. 2. 3. 4. 5. 6. 7.
Local Class Model Description Purchase Lease /Unit Rental /Unit Used
I.D. # Year Cost Cost Cost on Project
this FY?
3236 12007 IInternationa14200 I 1017281
3241 12006 (International , 36411,
3230 , 2007 (Ford F550 Crew Cab i 91809,
3298 ~ 2008 IB&B Trailer ~ 55851
2730 12009 (Sewer Easement Machine 38783
4034 12009
II
I
J
II I~
I JI
I
I IJD Skid loader
~ 32058,
I
I I~
~ 1
City Street Financial Report
(Road/Street Equipment Inventory Sheet)
City Number
2100
City Population
57,686
Check here if there are ^
no reportable equipment
Fiscal Year
2009
No
No
No
No
No
No
8.
Status
INo Change
INo Change
,No Change
~No Change
JNew
(New
II
II
II
I
II
I
/~~ IOWa Depa.:.., ~.. ~ of 1, a. uFnn motion
~~p Form 517007 (7-200~g. 7)
~~ Office of Local Systems
Ames, IA 50010
City Name
DUBUQUE
City Street Financial Report
(Explanation Sheet)
City Number
2100
City Population
57,686
Fiscal Year
2009
Comments
~~ IOWa DEpa ~ .. , Of T. u...k.~. wtfOn
Form 517007 (7-2008)
\~ Office of Local Systems
Ames, IA 50010
City Name
DUBUQUE
City Street Financial Report
(Monthly Payment Sheet)
City Number
2100
Month
July
August
September
October
November
December
January
February
March
April
May
June
Road Use
Tax Payments
$395,682.311
$395,303.581
$420,074.081
$319,796.43
$464,990.08
$392,222.531
$332,075.651
$482,844.09
$454,865.04
$365,493.431
$384,124.461
$379,018.50
Totals
$4,786,490.18
City Population
57,686
Transfer of
Jurisdictions Payments
$177.85
$177.69
$188.84
$143.70
$209.09
$176.27
$149.24
$217.11
$204.45
$161.89
$169.72
$166.86
$2,142.71
Fiscal Year
2009