City Street Financial Report FY 2008THE CITY OF ~„ Dubuque
~..
DUB E ~-"~
i 1
Masterpiece on the Mississippi
2007
TO: The Honorable Mayor and City Council Members
FROM: Michael C. Van Milligen, City Manager
SUBJECT: Fiscal Year 2008 City Street Finance Report
DATE: September 8, 2008
City Engineer Gus Psihoyos is recommending approval of the City of Dubuque's Fiscal
Year 2008 City Street Finance Report.
I concur with the recommendation and respectfully request Mayor and City Council
approval.
Micha I C. Van Milligen
MCVM/jh
Attachment
cc: Barry Lindahl, City Attorney
Cindy Steinhauser, Assistant City Manager
Gus Psihoyos, City Engineer
THE CITY OF ~~ ~~,,-
DUB ~ E
Masterpiece on tl~e Misstssrpp~
TO: Michael C. Van Milligen, City Manager ~
FROM: Gus Psihoyos, City Engineer ~, ' ~. ,
~ • ~ . ~.
DATE: September 5, 2008
SUBJECT: Fiscal Year 2008 City Street Finance Report
INTRODUCTION
Dubuque
a
~~~~~a,'
Zoos
The purpose of this memorandum is to request the City Council to adopt a resolution
approving the City of Dubuque's Fiscal Year 2008 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,
2008. 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
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 2008.
cc: Jenny Larson, Budget Director
Ken TeKippe, Finance Director
RESOLUTION NO. 309-08
APPROVING THE CITY OF DUBUQUE FISCAL YEAR 2008 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,
2007, to June 30, 2008, 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 15th day of September, 2008.
Kevin J. Lynch, Mayor Pro-Tem
Attest:
Jeanne F. Schneider, CMC, City Clerk
>.
c
O
d'
d
m
m
r
R
w
c
0
•+-,
~a
Q
O \p
0. co
~ ~
U vii
i
O
~^^,,
,p~ W
L
11,~, w+~w+
I.I. WW
o
~ V Z O
~ U c
.~
C~
c
0
+~
o.
~ ~~
4- N y
O ~'
n.~o
~ o o °o
~wQ
t' v~ ~ -
Q, E u a~'i
0 IiOQ
(C
O yCN
G V
._,r ~
0
0
0
N
~ ~
Q ~ ~
C
~ O
C7
~ .~ ~ C
v
Q ~ ~
O ~
c
~ ~
O
~ O N
.
c
~ ca
4 >+
U ~ ~
~ ~ "')
~U ~
~ L
O
~ ~_
}~ ~e
v .}-~
L
(0 O
~\ ~ Q
a.~rV~ ^
`
V
J
T~
V ~ \ ~
/
LL
^
`
W
_
N Z
L C
(
~ o
N '`!
\ LC• ~
L
..
'
'f'
a-' C N
~ o
a~
L
O
a.~'+
~ U
a~
0
z
C
++
O
C
V
C
O
U
~ ~
~ ~
~
a ~
~
V o U o
a ° a °
N
N ~ N v
i
e
0
d ~ ~ ! d
o +r
~ = w ~
~ ~
~ ~
L
~ ~
~
v Q n. c~ ' Q
M
ff1
ti
N d- ~
c ~ ~
N CQ ~~ to N ~
d... .4C-~ ~ D7
C M yl +~+
w a `_' a
~ ~' ~
a
.~ o .: ' o
to ~ n f/7 ' v'~
~u ~
c O
~ ~
v.
~ r~ J
^~ •J--
~
J O
~ ~ ~s ~' ~° ~' c
a, ~ Q, a~ a ~ o
~N
~ d ~ ~ e
' '
ti .te a w ,~ w ~ w
C
o
ti
~
~
6
~ =
~ cc
L Q+ ~
~'
~ o
~ ~
~
~
~ ~
~ L
O _
C
i L ~ ~
~ ~ L
+'~"~'
~,
~
a
m,,
~ L
O
~
Q
~:
c~ o ,
~
~'
~ ~
~
Z ti S' oo d Z ~ ~ Z ~ d
v
~~iowa Department ofTransportatlon City Street Financial Report
Form 517007 (7-200~g. 2)
' \+ (Summary Statement Sheet)
Office of Local Systems
Ames, IA 50010
City Name City Number City Population Fiscal Year
DUBUQUE 2100 57,686 2008
Column 1 Column 2 Column 3 Column 4 Column 1 Column 2 Column 3 Column 4
Road Use Other Street Street Debt Totals Road Use Other Street Street Debt Totals
Tax Fund Monies Tax Fund Monies
Round Figures to Nearest Dollar Round Figures to Nearest Dollar
~A. BEGINNINt3 BALANCE EXPENSES
1 1. July 1 Balance I 2,077,8231 0 0 .2,077,823 I D. Maintenance
2. Adjustments
(Note on Explanation Sheet)
~; 3. Adjusted Balance 1 2,077,8231
B. REVENUES.
~
1. Road Use Tax 1 4,942,114)
2. Transfer of
Jurisdictions Fund 2 222
3, Property Taxes 1 1
4. Special Assessments 1 1
5. Miscellaneous
6. Proceeds from Bonds,
Notes, and Loans
L 7. Interest Earned 1
8. Total Revenues 4
944,336
(Lines Bi thru 67) ,
0 0
1,796,861 82,935
260,288
4,413,222
68,530
6,538,901 82,935
C, Total Funds Available 7,022,159 6,53$,901 82,935
(Line A3 t Line B8)
1 1_Roadway Maintenance 1,860,712 9,120
2. Snow and Ice Removal 1,372,276
2,077,823
~E. Construction, Reconstruction and Improve
ments
1 1. Englneering 1 40,4561 453,8091
4,942,114 2. Right Of Way Purchased 1 1 1,9871
3. Street/Bridge Construction 1 227,0721 x,769,0201
2,222
4. Traffic Services 1 156,3321 1,229,8281
1,879,796
~ F. AdfI7lnlStratlOn 1
749,4741
21,5691 1
260,288
4,413,222 G. Equipment
931
433
53
568
(Purchased or Leased) , ,
0
~H. Miscellaneous _ 1 1 1 1
68,530
J. Street Debt
11,566,172 1. Bonds, Notes, and Loans-
Principal Paid 4s,ooo
2. Bonds, Notes, and Loans -
13,643,995 _ Interest Pald 37,935
TOTALS
K. Totel Expenses
(Lines D thru J)
L Ending Balance
(Line C - K)
M. Total Funds Accounted For
(K+~=C)
4,840,253 6,538,901
2,181,906 0
7,022,159 6,538,901
1,869,832
1,372,276
494,265
1,987
4,996,092
1,386,160
771,043
487,499
45,000
37,935
82,935 11,462,089
0 2,181,906
82,935 13,643,995
~~lowa Department ofTransportatlon City Street Financial Report
Form 517007 (7-200~g. 3) (Miscellaneous Revenues and Expenses Sheet)
~~ Office of Local Systems
Ames, IA 50010
City Name
DUBUQUE
1
121 State Reimbursement
140 Federal Government (misc.)
170 Reimbursements (misc.)
173 Reimbursement For Damages
174 Sales Tax /Local Option
180 Receipts From Sales
181 Junk and Old
182 Property or Buildings (Sale or Rent)
..Line B5 Totalsi
Fiscal Year
2008
Column 2
Other Street
Monies
10,684
1,748,623
257,745
54
2,394,353
852
900
4,413,222
Code Number and Itemization of Miscellaneous Expenses (Line H on the Summary Statement Sheet) Column 2
"On street" parking expenses, street maintenance, buildings, insurance, administrative costs for printing, legal feeds, bond fees, etc. Other Street
(See Instructions) Monies
Line H Totalsi
Gity Number City Population
2100 57,686
Code Number and Itemization of Miscellaneous Revenues (Line 85 on the Summary Statement Sheet)
_,(See Instructions) -
Column 3
Street Debt
Column 3
Street Debt
~~ Iowa Department of Transportation
Form 517007 (7-200~g. 4)
`~ Office of Local Systems
Ames, IA 50010
City-Name
DUBUQUE.
Is this a DebtType
new bond?
Yes I No
I X (General Obligation
I
I
I
I
I
I
I
I
I
I
l
City Street Financial Report
(Bonds, Notes, and Loans Sheet)
City Number City Population Fiscal Year
2100 57,686 2008
Debt Purpose
(Paving & Construction
I
I
I
I I
I
I
I
I ~
I
(Paving & Construction 1
I
DOT= Issue Issue Year Principal Principal Interest
Use Date Amount Due ..Balance as ..Paid Paid
Only ~~p~'1'1'h of 711 or after
303
I
I
I
I
i 1 03/26/2002 1
I I
I I
I I
i I
I I
I I
I
I
I
I
I 1,000,0001 2021
I
I
I
I
I
I
I
I
I
I
I 1 825,0001
I I
I I
I I
I I
I I
I I
I I
I I
I I
I I
I I 45,0001 37,935
I
I
v Bond Totals
I
01 Totals)
I
825,0001
45,0001
37,935
Principal
Balance as
of 6/30
780,000
780,000
~~ Iowa Department of Transportation
Form 517007 (7-200~g. 5)
' `~ Office of Local Systems
Ames, IA 50010
...._.._ ....._....__.
City Name
(DUBUQUE
Section A
1.
Line Project Number
No.
1 (West 5th Street
2 12007 Asphalt Paving Prog
3
4
5
6
7
8
9
Section B
1.
Line Project Number
No.
1 (West 5th Street
2 12007 Asphalt Paving Prog
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 City Population
2100 57,686
2. 3.
Estimated - Project Type
Cost
948,717IRoadside Construction
369,250ISurfaces
Check here if there are ^
no entries for this year
Fiscal Year.
2008
4. 5.
Publie Location/Project Description (limits, length, size of structure)
Letting?
Yes IW 5th Street reconstruction, Delhi to Hill, Length 2940 LB
Yes 12007 Asphalt Paving Program, Almond, Ellis, Alta Vista, Main St. Length 378
+I
I
I Contract Work _ _ I
6. T. 8. 9.
Contractor Name Contract Additions/ Labor
Price Deductions
IHorsfield Construction I 764,2051 -45,11 lI
IRIver City Paving ~ 372,3131 80,2521
City Labor
10. __ _ 11.
Equipment Materials
12, 13.
Overhead Total
719,094
452,565
/~~ -owa Department of 7ransportatlon
F°rm s17oo7 (7-zoo~g. s)Form 517007 (7-200~g. 6)
\+ Office of Local Systems
Ames, IA 50010
City Name
DUBUQUE
1.
Local Class
I.D. #
4113
4103
4011
4008
1
282
281
280
279
278
City Street Financial Report
(Road/Street Equipment Inventory Sheet)
City Number City. Population
2100 57,686
2. 3.
Model Description
Year
11973 ISno-Go Loader Attachment
1 1998 ISno-Go-Loader Attachment
1 1999 (John Deere Lawn Tractor
12002 (Freightliner Air Johnston Sweeper
11988 (John Deere Tractor
1 2001 lInteranational 56,000 GVW Dump
1 1998 lInternational Vac/Flusher Unit
1 2004 (Elgin Pelican Sweeper
12004 llnteranationa17300 w/ Lodal
1 2004 (Gorman Rupp ]0" Trash Pump
1 1998 1Barber Green Asphalt Paver
11985 (Doolittle Utility Trailer
1 1994 IBerming Machine
11993 1Speed Screed
11993 1Honda Generator
11996 IMelroe Skid-Steer Loader
12002 lingersoll Rand Roller
1991 lingersoll Rand Roller
1990 (Target Pro 65 Concrete Saw
1985 1Trailer King Trailer
2000 1Cimline Crack Sealer
1979 (Massey Ferguson Tractor
1997 1Wacker Rammer
4. 5.
Purchase Lease
Cost Cosf
I 164501
I 750001
I 73001
I 1153601
I 360001
77500)
1247561
932751
764501
357201
1646661
11501
42001
33271
13601
261081
53561
32101
77401
28361
1893]1
115001
22961
Check here i
no reportabl
6.
(Unit Rental
Cost
/Unit
Fthere are ^
equipment
Fiscal Year
2008
7, 8.
Used Status
on Project
this FY?
No No Change
No No Change
No No Change
No No Change
No No Change
No No Change
No No Change
No No Change
No No Change
No No Change
No No Change
No No Change
No No Change
No No Change
No No Change
No No Change
No No Change
No No Change
No No Change
No No Change
No No Change
No No Change
No No Change
/~~lowai7epartmentofrransportation City Street Financial Report
~~'
~~ Form 517007 (7-200~g. 6) (Road/Street Equipment Inventory Sheet)
Office of Local Systems Check here if there are ^
rimes, In sooto n0 re q p
portable a ui merit
City Name Gity Number - City Population Fiscal Year
DUBUQUE 2100 57,686 2008
1. 2. _ 3. 4. 5. _ _ 6. 7. 8.
Local Class Model Description Purchase Lease _: /Unit Rental /Unit Used Status
LD. # Year Cost Cost Cost on Project
this FY?
13256 12008 (John Deere Lawn Tractor ~ 191121 I No New
3256 12000 (John Deere Lawn Tractor I 131701 ~ No Traded
3255 1 2007 (John Deere 6247 Endloader I 1361081 ~ No New
3255 1 1981 (John Deere Motor Grader I 348101 I No Traded
3252 12005 (Chevrolet 4WD 12,000 GVW Dump Truck I 369141 I No No Change
3251 1 1991 (Caterpillar Paver-Finisher I 2441 l1 I No No Change
3250 1 2000 (John Deere Wheel Loader ( 1187501 1 No No Change
3248 1 1990 ICimline Crack Saw 1 38691 1 No No Change
3247 1 1990 ICimline Crack Saw I 23811 I No No Change
3246 12005 1Silverado 4WD 12,000 GVW Dump I 378141 I No No Change
3245 1 2008 (Freightliner Tandem Dump Truct I ]040521 I No New
3245 I 1999 lInternational Tandem Dump Truck I 626831 1 No Traded
3244 1 1992 (John Deere Wheel Loader I 920001 I No No Change
3243 1 1991 ISullair Air Compressor I 95991 I No No Change
3240 11998 1Target Pro 65 III Concrete Saw 1 89271 I No No Change
13238 11993 1Townmaster Trailer I 54811 1 No No Change
13237 1 2001 lAtlas Copco Air Compressor I 72821 I No No Change
3235 1 1996 1John Deere Wheel Loader I 956721 1 No No Change
3225 1 2005 1Dynapac CC122 12 Series 1 258421 1 No No Change
3233 12003 (International Tandem Dump Truck I 847301 1 No No Change
3232 11976 1Galion Ro]ler I 17866) I No No Change
3231 1 2002 1Ford F450 4WD I 295851 I No No Change
3229 1 1967 llnternational Tractor I 72801 1 No No Change
~~ Iowa Department of Transportation
Form 517007 (7-200~g. 6)
' ~~ Office of Local Systems
Ames, IA 50010
City Name
DUBUQUE
1.
Local Class
LD. #
13227
3226
3224
3223-1
219
218
217
216
216
215
214
212
210
101
City Street Financial Report
(Road/Street Equipment Inventory Sheet)
City Number - City Population
2100 57,686
2. 3.
Model Description
Year
1994 (John Deere Backhoe Loader
1987 (John Deere Motor Grader
2003 (Atlas Copco Air Compressor
1997 (Snow Equipment Anti-Icing Unit
1998 Ilnteranational 26,000 GVW Dump
2001 (Atlas Copco Air Compressor
1996 IInteranational Ladder Truck
1989 (Wacker Vibratory Plate Tamper
2008 IInternationa17400 Tamdem Dump Truck
1998 IGMC Tandem Dump Truck
2001 (Caterpillar Vibratory Asphalt Roller
1999 (John Deere Backhoe Loader
2002 (Freightliner 31,00 GVW Dump
2004 (John Deere Backhoe Loader
1979 (John Deere Motor Grader
2003 Ilnternational Tandem Dump Truck
2005 IFreightlilner FL70 w/combo Box
2008 Ilnternational 7400 Dumpt Truck
1998 International 26,00 GVW Dump
1998 lInternational W/Rosco Distributor
1999 Ilnternational 26,000 GVW Dump
1997 (Chevrolet Pickup Truck
2000 (Kawasaki Mule 4 Wheeler
4.
Purchase
Cost
I 618251
I 270001
78191
81761
405001
7282)
816461
I 12601
1084311
460431
Check here if there are ^
no reportable equipment
Fiscal Year
2008
5. 8.
Lease /Unit Rental /Unit
Cost Cost
233901
619501
495101
58375
250601
847301
731781
87000
417001
607951
412001
208691
70111
7. 8.
Used Status
on Project
this FY?
No No Change
No No Change
No No Change
No No Change
No No Change
No No Change
No No Change
No No Change
No New
No Traded
No No Change
No No Change
No No Change
No No Change
No No Change
No No Change
No No Change
No New
No Traded
No No Change
No No Change
No No Change
No No Change
/r~ towa Department of Transportation
r5 rForm 517007 (7-200~g. 6)
~~ Office of Local Systems
Ames, IA 50010
City Street Financial Report
(Road/Street Equipment Inventory Sheet)
City Name City Number
DUBUQUE 2100
1. 2. 3. 4.
Local Class Model- Description Purchase-
LD. # Year Cost
2726 1 2000 (Portable Jet/Root Cutter ~ 85951
2721 1 2003 (Honda 3" Trash Pump I 11971
2719 11985 (Gorman Rupp 6" Trash Pump I 115951
2711 1 1984 IGMC Van W/ TV Camera I 654001
2710 11998 IPECO Manhole Cutter ~ 13260(
2708 11966 (Gorman Rupp - 6" Trash Pump ~ 1973(
2706 1 1999 ICH&S - 6" Trash Pump I 138461
2705 12009 (Chevrolet 3500 Sewer Rodder I 76593)
2705 1 1997 (Chevrolet CK31403 Sewer Rodder ~ 24654(
2703 1 2005 IJetFlusher Truck/Pipe Cleaner I 880001
2701 12008 (Ford F350 I 318751
2701 12000 IGMC Sierra I 251221
3242 1 2005 (Freightliner Dump Truck w/ Henderseon Muni Body 1 753321
2715 1 2006 (Godwin 4" Trash Pump I 187821
4007 1 2005 (Elgin Pelican P Dual Sweeper I 1282851
3242 1 2005 (Freightliner Dump Truck w/Henderseon Muni Body I 873321
2702 12008 1Ford F350 I 313601
2704 12007 (international 7500 SFA 6X4 I 1946181
3102 1 2007 1Chevrolet Silverado I 256661
3204 12008 17400 4X2 Dump Truck I 943821
3204 1 1999 1lnternationa14700 4X2 1 394501
3206 12006 (International 7400 I 36411
3208 12006 lInternational 7400 I 3641 l1
City Population
57,686
Check here if there are ^
no reportable equipment
Fiscal Year
zoos
5. 6. 7.
Lease /Unit Rental /Unit Used
Gost Cost on Project
this FY?
1 No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
8.
Status
No Change
No Change
No Change
No Change
No Change
No Change
No Change
New
Traded
No Change
New
Traded
No Change
No Change
No Change
No Change
No Change
No Change
No Change
New
Traded
No Change
No Change
~~lowa Department ofTransportatlon 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
1. 2:. 3. 4. 5.
Local Class Model Description Purchase Lease /Unit
I.D. # Year Cost Cost
3213 12007 (John Deere Backhoe Loader I 677541
3236 12007 Ilnternationa14200 I 1017281
3241 ~ 2006 International ~ 36411
3230 12007 (Ford F550 Crew Cab ~ 918091
3242 12005 (Freightliner Dump Truck w/Henderseon Muni Body ~ 753321
12715 12006 (Godwin 4" Trash Pump I 187821
4007 12005 (Elgin Pelican P Dual Sweeper I 1282851
3242 1 2005 (Freightliner Dump Truck w/Henderseon Muni Body I 87332)
2008 IB&B Trailer I
I
I 55851
I
I
Check here if there are ^
no reportable equipment
Fiscal Year
2008
6. 7. 8.
Rental /Unit Used Status
Cost on Project
this FY?
No No Change
No No Change
I No No Change
I No No Change
I No No Change
No No Change
No No Change
No No Change
No New
~~iowaoepartmentofTransportatlon City Street Financial Report
Form 517007 (7-200~g.7) (Explanation Sheet)
° ~~ Office of Local Systems
Ames, IA 50010
City Name City Number City Population
DUBUQUE 2100 57,686
Fiscal Year
2008
Comments
~~iowaoepartmentofTransportation City Street Financial Report
~~ Office ofLOocalSystem~s (Monthly Payment Sheet)
Ames, IA 50010
City Name City Number City Population
DUBUQUE 2100 57,686
Month
July
August
September
October
November
December
January
February
March
April
May
June
Road Use
Tax Payments
$394,979.20
$422,347.76
$416,544.15
$438,766.72
$380,077.42
$419,306.94
$476, 874.82
$376,150.35
$491,507.23
$355,042.38
$355,297.33
$415,219.87
Transfer of
Jurisdictions Payments
$177.28
$189.59
$189.20
$196.95
$170.57
$188.23
$214.38
$169.03
:$220.99
$159.53
$159.71
$186.67
Fiscal Year
2008
Totals $4,942,114.17 $2,222.13