City Street Financial Report FY 2003MEMORANDUM
September 9, 2003
TO:
FROM:
SUBJECT:
The Honorable Mayor and City Council Members
Michael C. Van Milligen, City Manager
Fiscal Year 2003 Street Finance Report
Public Works Director Mike Koch recommends City Council approval of the City of
Dubuque's Fiscal Year 2003 Street Finance Report.
I concur with the recommendation and respectfully request Mayor and City Council
approval.
Michael C. Van Milligen
MCVM/jh
Attachment
cc: Barry Lindahl, Corporation Counsel
Cindy Steinhauser, Assistant City Manager
Michael A. Koch, Public Works Director
CITY OF DUBUQUE, IOWA
MEMORANDUM
September 8, 2003
TO: Michael C. Van Milligen, City Manager
FROM= Michael A. Koch, Public Works Director
SUBJECT: Fiscal Year 2003 Street Finance Report
INTRODUCTION
The purpose of this memorandum is to request City Council to adopt a resolution
approving the City of Dubuque's Fiscal Year 2003 Street Finance Report.
DISCUSSION
The Code of Iowa, Chapter 312, Section 14, provides for the submission of an
annual Street Finance Report to the Iowa Department of Transportation. Failure
of the City to submit this report would result in the State Withholding Road Use
Tax Funds allocated to the City to be withheld until compliance is achieved.
The report summarizes the City's revenue and expenditures for street
maintenance and construction for Fiscal Year 2003.
RECOMMENDATION
I would recommend adoption of the enclosed resolution approving the report and
authorizing the filing with the Iowa Department of Transportation.
ACTION TO BE TAKEN
The City Council is requested to adopt the attached resolution approving the
Street Finance Report for Fiscal Year 2003.
MAK/vjd
cc: Ken TeKippe, Finance Director
RESOLUTION NO. 322-03
RESOLUTION APPROVING THE CITY OF DUBUQUE FISCAL YEAR
2003 STREET FINANCE REPORT
NOW THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE
CITY OF DUBUQUE, IOWA:
Section 1. That the Street Finance Report for the period of July 1,2002
to June 30, 2003, be and the same 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,
2003.
Terrance M. Duggan, Mayor
Attest:
Jeanne F. Schneider, CMC, City Clerk
15th day of September
~lowa Department of Transportation
OFFICIAL FINANCIAL REPORT
for
CITY STREETS
SFR-2
City Dubuque
County Dubuque
From July 1, 2002
to
June 30, 2003
I, ~eanne F. Schneider , city clerk for the City of Dubuque, Iowa
(ptease
do hereby certify that the city council has by resolution approved this report as its official 2003 FisCal Year Street
Finance Report this //~'~-~ day of
Clerk's City E-mail Address jschnei d@cityof,dubuque .org
Clerk's City Mailing Address 50 W. 13th Street, Dubuque, IA 52001-4864
Clerk's Hours 8AM - 5 PM Central Phone 563-589-4120
(worn) {Home)
Preparer's Name Ken TeKippe Phone 563-589-4398
Mayor Terrance M. Dug,gan
Mayor's City Mailing Address 50 W. 13th Street, Dubuque, IA 52001-4864
John H. Markham
~oyce E. Connors
Daniel E. Nicholson
Membemofthe Coundl
Roy D. Buol
Patricia A. Cline
Ann E. Michalski
On or before September 30, 2003, this repot[ shall be fi~d with the Iowa Department of Transportation,
Office of Transportation Data, 800 Lincoln Way, Ames, Iowa, 50010 Attn: Karen Magie-Crouse
07-03 SFR-2A
lowa Department of Transportation
STREET FINANCE REPORT
FROM ALL SOURCES FOR STREET PURPOSES
Dubuque
City Name
2100
City#
COLUMN 1 COLUMN 2 COLUMN 3 COLUMN 4
ROAD USE OTHER STREET
TAX FUND ROAD MONIES DEBT TOTALS
A. 1. Ending Balance on 2002 SFR (Line O) .... 2. Adjustment (Explain on SFR-2B) .........
3. Actual Balance, July 1, 2002 .............
ACTUAL RECEIPTS
B. 1. Road Use Tax .......................
2. Property Taxes .......................
3. Special Assessments
4. Misc. (Itemize on Form SFR-2B) ........
5. Proceeds From Bonds Sold, Notes, and Loans
6. Interest Earned .......................
C. Total Receipts (Lines B1 thru B6) ..........
D. TOTAL FUNDS AVAILABLE (Line A3 + Line C).
ACTUAL EXPENDITURES
E. Maintenance
1. Roadway Maintenance .................
2. Snow and Ice Removal ................
3. Storm Sewers
4. Traffic Services
5. Street Cleaning ......................
F. Construction or Reconstruction 1. Engineering .........................
2. Right of Way Purchased ...............
3. Roadway Construction ................
4. Storm Sewers
5. Traffic Services
6. Sidewalks ...........................
G. Administration .........................
H. Street Lighting .........................
I. Trees .................................
J. Equipment (Purchased or Repaired) ........
K. Misc. (Itemize on Form SFR-2B) ...........
L. Bonds, Notes and Loans
1. Principal Paid .......................
2. Interest Paid
M Non-Street Purposes ....................
N. Total Expenditures (Lines E thru M) ........
BALANCE, June 30, 2003 (Line D minus Line N)
P. TOTAL FUNDS ACCOUNTED FOR .........
(Line N + Line O = Line D)
4,661,148
4,661,148
(ROUND FIGURES TO NEAREST DOLLAR)
4,661,148
0
0 0 4,661,148
4,696,399
4,696,399
9,357,547
4,696,399
3,792,373 1,154,901 4,947,274
610,509 610,509
4,755,479 0 4,755,479
229,978 229,978
86,051 86,051
9,474,390 1,154,901 15,325,690
9,474,390 1,154,901 19,986,838
849,684
373,218
186,335
849,684
373,218
65,638 65,638
0
186,335
377,833
1,116,585 1,116,585
0
6,052,119 6,429,952
1,468,383 1,468,383
1,344,137
236,943
144,817 144,817
1,344,137
487,501 487,501
0
500 237,443
0 0 0
1,083,037 1,083,037
71,864 71,864
138,847 XXXXXXXXXX 138,847
9,474,390 1,154,901 13,997,441
3,368,150
5,989,397
0 0 6,989,396
9,357,547 9,474,390 1,154,901 19,986,838
For assistance, call 515-239-'1004
Send directly to: Iowa Depar[ment of Transportation, Office of Transportation Data,
$00 Lincoln Way, Ames, Iowa, 50010 Attn: Karen Magie-Crouse
Ci~ Dubuque#2100
~lowa Department of Transportation
STREET FINANCE REPORT
Itemization of Misc. Receipts (Line B4 on Form SFR-2A)
(See instructions.)
COLUMN 2
SFR-2B
COLUMN 3
Federal Aid to Urban Systems (SW Arterial Analysis)
Private Participation
Sales Tax Refund
Transfers from Sanitary Sewer Const.
FEMA Public Assistance
Sales Tax
Transfers In
Damage Claim
297,780
62,752
65,290
416,879
194,118
2,325,129
1,392,441
1,090
Itemization of Misc. Expenditures (Line K on Form SFR-2A)
"on street" parking expenses, street maint, bldg., insurance,
administrative costs for printing, legal fees, bond fees, etc.
(See instructions)
Line B4 Totals
4,755,479
COLUMN 2
COLUMN 3
Comments:
Line K Totals 0 0
Send directly to: iowa Department of Transportation, Office of Transportation Data,
800 Lincoln Way, Ames, iowa, 50010 Attn: Karen Magie-Crouse
/~lowa Department of Transportation
Form 220029 07-03 Page1
STREET DEBT SUPPLEMENT FOR STREET FINANCE REPORT Form SFR-2D
2100 DUBUQUE 2003
CITY # MUNICIPALITY YEAR
DEBT STATUS-RECEIPTS AND EXPENDITURES FOR DEBT DURING YEAR
DEBT DEBT STATE ID. YEAR AMOUNT YEAR PRIN. AMOUNT PRINCIPAL INTEREST PRIN. AMOUNT
TYPE PURPQSE # OBTAINED OBTAINED MATURITY OUTSTANDING PAID ON DEBT PAID ON DEBT OUTSTANDING
FOR STREETS 7/1 QR NEWER 6~30
General Obligation Const 302 1995 1,840,000 2005 874,000 276,000 41,768 598,000
General Obligation Const 303 2001 981,328 2003 981,328 122,52t 2,881 858,807
General Obligation Const 309 1993 4,473,781 2003 411,995 411,995 18,540 0
i Oonst 310 1994 1,300,000 2004 150,000 150,000 5,794 0
3eneral Obligation Const 2002 152,251 2004 152,521 122,521 2,881 30,000
0
0
0
0
0
0
0
0
0
¥OTAL 2,569,844 1,083,037 71,864 1,486,807
RETURN THIS COPY WITH STREET FINANCE REPORT
04.03 STATEMENT OF FINAL COSTS
Fiscal Year: 2003
Contract Work Day Labor
Estimated Public Location I Project Description Additions I
Project Number Cost ProjectType Letting? (limits, length, sizeofstructure} Contractor Contract Price Deductions Labor Equipment Materials Overhead TOTAL
(1) (2) (3) (4} (5) (6) (7) (8) {9) (t0) (11) (t2) (13)
Dubuque, la - Construction of new
Chavenelle Road Extension $587,063.65 Construction Yes Street, Len=l 1 tSfeet Portzen Const. $538,208.43 $44,939.54 $583,148.07
Dubuque, la - Construction of new
Parking Lot and Fifth Slreet $1,584,700.23 Construction Yes Street, Len=564feet Podzen Const. $1,097,207.48 $51,866.3~ $1,149,073 84
Dubuque, la - Construction of new
Main Street 51htogth $2,341,105.87 Construction Yes Street, Len=t258feet Portzen Const, $1,864,870.3! $245,243,94 $2,110,114,~;!
Dubuque, la - Resufacing of 2",
2001 Paving $1,620,840.49 Resurface Yes Kaufman (Elm to Quarry), Podzen Const. St ,578,073.8( $173,809.21 $1,751,883
Elm (12th to 26Ih), Jackson (30th-
32rd) $0.00
$0.00
$0.00
$0.00
$0.00
$0.0(
$0.0(
$0.0(
$O.OC
$0.0C
$0.06
Sheet I of I
Form 517005
04-03
City or County: Ci~ofDubuque
Local
Class I,D.~
(1)
#2701
#2702
#2703
#2704
¢Y2705
#2706
~2708
#2709
#2710
#2713
#2714
#.2715
~2717
#2718
#2719
#2722
#2723
#2725
#2727
#2728
#3201
#3202
#3203
#3203-1
~,204
#3205
~3206
#3208
~3209
¢3210
#3212
¢k3214
#3215
#3216
#3216-1
#3217
~3218
#3219
#3223
#3223-1
#3224
#3225
#3226
#3227
Description
(3)
3500 - 2WD
International W/Sreea Pipe Cleaner
International W/Camel 200 Jet
3hevrolet CK31403 Sewer Rodder
3H & S - 6" Trash Pump
3orman Rupp - 6" Trash Pump
-Iomelite - 3" Trash Pump
PECO Manhole CurLer
3MC Van W/TV Camera
Homelite - 3" Trash Pump
Homelite - 3" Trash Pump
M-B-W Ground Pounder
Gorman Rupp - 4" Trash Pump
Homelite Ventilating Blower
Homelite Ventilating Blower
Gorman Rupp 6" Trash Pump
Mopeea Ventilating Blower
Stihl Cutoff Saw
Homelite - 3" Trash Pump
Portable Jet/Root Cutter
Kawasaki Mule 4 Wheeler
Pit Hog 950 - 4" Trash Pump
Chevodet Pickup Truck
Intematioeal 26,000 GVW Dump
Intematinal W/Rosco Distributor
Intematina126,000 GWN Dump
Monroe Materials Spreader
GMC - 31,000 GVW Dump
international 31,000 GWN Dump
International 31,000 GVW Dump
international Tandem Dump Truck
international 31,000 GVW Dump
John Deere Motor Grader
Loader
John Deere Backhoe Loader
John Deere Backhoe Loader
Caterpillar Vibratory Asphalt Roller
GMC Tandem Dump Truck
Fox Brady Materials Spreader
t Plate Tamper
international Ladder Truck
Atlas Cogea Air Compressor
International 26,000 GVVV Dump
Snow Equipment Anti-icing Unit
Atlas Copco Air Compressor
Deare Motor Grader
John Deera Backhoe Loader
~/l~11~lowa Department of Transportation
Road / Street Equipment Inventory
Price
Purchase J Lease (5)
(4) I Cost I Ur
25,122-00I
43,247.00I
151,874.00'
24,654.0£
13,846.0(
1,973.0(
750.0(
13,260.0(
65,400.0(
899.0(
750.0(
1,490.0(
4,761.00
649.16
649.16
11,595.00
450.00
630.00
1,054.00
8,595.00
7,011.00
2,302.00
20,869.00
41,200.00
60,795.06
41,700.00
6,203.00
33,726.00
45,530.00
52,034.00
84,730.0C
40,538.06
25,060.0£
56,090.0C
49,510.0£
54,080.0(
61,950.0(
23,390.0(
46,043.00
5,242.00
1,260.00
81,646.00
7,282.00
40,500.00
8,176.00
7,819.00
19,978.00
27,000.00
61,825.00
Rental (6)
Cost Unit
Form SFR-2F
Fiscal Year: 2003
Equipment
Type Used on
Project this Status
FY? (7) (8)
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
NO
No
No
No
No
No
No
No
No
No
No
No
No
No
No new
No
No
No
No
No
No
No
No
No
Ne
No
No
Ne
No
No
No
Sheetlof2
Form SFR.2F
04-03F°rm 517005 ~ Iowa Department of Transportation
Road / Street Equipment Invento~
City of Dubuque Fiscal Year: 2003
Local Model Price Equipment
Type Used on
Class I.D.# Year Description Purchase Lease (5) Rental (6) Project this Status
(1) (2) (3) (4) Cost I Unit Cost / Unit FY? (7) (8)
#3229 1967 nternational Tractor 7,280.0£ No
¢k3230 1991 ~. x 4 Flatbed F350 18,304.00 No
#3231 2002 Ford F450 4WD 29,585.0{ No
#3232 1976 Salion Roller 17,866.0£ No
#3233 2003 International Tandem Dump Truck 84,730.0{ No new
#3233-1 1992 Fox Brady Materials Spreader 5,242.7.~ No
#3235 1996 John Deem Wheel Loader 95,672.0( No
#3236 1995 GMC Flatbed W/Welder 24,694.00 No
#3237 2001 Arias Copco Air Compressor 7,282.00 No
#3238 1993 Townmaster Trailer 5,481.00 No
#3240 1998 Target Pm 65 ill Concrete Saw 8,927.00 No
#3241 1998 Intemational 31,000 GVW Dump 41,503.00 NO
¢r3242 1997 ~ternational 31,000 GVW Dump 52,034.00 Ne
#3243 1991 ~ullair Air Compressor 9,599.00 No
#3244 1992 John Deem Wheel Loader 92,000.00 No
#8245 1999 International Tandem Dump Truck 62,683.00 No
#3246 1997 Chevrolet 4WD 12,000 GVW Dump 23,500.00 No
#3246-1 1997 Henderson Materials Spreader 3,868.40 No
#3247 1990 CimLine Crack Saw 2,381.00 No
~3248 1990 CimLine Crack Saw 3,868.75 No
#3250 2000 John Deem Wheel Leader 118,750.00 No
#3251 1991 Caterpillar Paver-Finisher 24,411.00 No
#3252 1997 Chevrolet 4WD 12,000 GVW Dump 23,500.00 No
¢~3252~1 1997 Henderson Materials Spreader 3,868.40 No
~r3255 1981 John Deem Motor Grader 34,810.00 No
#3256 2000 John Deem Lawn Tractor 13,170.00 No
#3257 1997 Wacker Rammer 2,296.00 No
#3258 1979 Massey Ferguson Tractor 11,500.00 No
#3262 2000 CimLine Crack Sealer 18,931.11 No
#3267 1985 Trailer King Trailer 2,836.00 No
#3270 1990 Target Pro 65 Concrete Saw 7,740.0C No
#3272 1991 Ingersoll Rand Roller 3,210.06 No
#3278 2002 ngersolI-Rand Roller 5,356.06 No
#3279 1996 t4elroe Skid-Steer Loader 26,108.06 No
#3280 1993 -{onda Generator 1,359.9~' No
#3281 1993 Speed Scmed 3,326.7." No
#3282 1994 8erming Machine 4,200.0£ No
#3286 1985 Deeli~tie Utility Trailer 1,150.0( No
#3292 1998 Barber Green Asphalt Paver 164,666.0( No
#4001 1996 Intemational W/Lodal Unit 56,650.00 No
#4002 1995 Elgin Pelican Premier Sweeper 81,417.00 No
#4003 1998 Internarional Vac/Fluoher Unit 124,756.00 No
#4004 2001 International 56,000 GWV Dump 77,500.00 No
#4006 1988 Iohn Deere Tractor 36,000.00 No
#4007 1998 Elgin Pelican P Dual Sweeper 67,881.00 No
#4008 2002 Freightlieer Air Johnston Sweeper 115,360.00 . No
#4011 1999 John Deere Lawn Tractor 7,300.00 No
#4103 1998 Sno-Go-Loader Attachment 75,000.00 No
#4113 1973 Sno-Go Loader Attachment 16,450.00 No
Sheet2of2