City Street Financial Report FY 2007THE CTTY OF
DUB E MEMORANDUM
Masterpiece on the Mississippi
September 6, 2007
TO: The Honorable Mayor and City Council Members
FROM: Michael C. Van Mitligen, City Manager
SUBJECT: Fiscal Year 2007 City Street Finance Report
City Engineer Gus Psihoyos recommends City Council approval of the City of
Dubuque's Fiscal Year 2007 City Street Finance Report and authorize filing it with the
Iowa Department of Transportation.
I concur with the recommendation and respectfully request Mayor and City Council
approval.
J~ / , ~
~t,~ <~ ~
Michael 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 nn the Mississippi
MEMORANDUM
September 4, 2007
TO: Michael C. Van Milligen, City Manager
FROM: Gus Psihoyos, City Engineer
SUBJECT: Fiscal Year 2007 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 2007 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, 2007. 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 2007.
cc: Jenny Larson, Budget Director
Ken TeKippe, Finance Director
RESOLUTION NO. 466-07
APPROVING THE CITY OF DUBUQUE FISCAL YEAR 2007 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,
2006, to June 30, 2007, 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 17th day of September, 2007.
Roy D. Buol, Mayor
Attest:
eanne F. Schneider, CMC, City Clerk
~ bwa Department of Transportation City Street Financial Report
Form 517007 (4-OS) (pg. 1) (Cover Sheet)
Office of Local Systems
Ames, IA 50010
Office Use Only
City Name City Number City Population Fiscal Year
DUBUQUE 2100 57,686 2007
Now therefore let it be resolved that the city council of Dubuque, Iowa ,Iowa
(city name)
on did hereby approve and adopt the annual
(month/day/year)
City Street Financial Report from July 1, 2006 to June 30, 2007 .
Contact Information
Name E-mail Address Street Address City ZIP Code
Jeanne F. Schneider ~schneid@cityofdubuque.org 50 West 13th Street Dubuque, IA 52001-4864
Hours Phone Extension Phone (Home)
8:00 AM - 5:00 PM
Preparer Information
Name E-mail Address Phone Extension
Kenneth J. TeKippe ktekippe@cityofdubuque.org (563) 589-4133
Mayor Information
Name E-mail Address Street Address City ZIP Code
Roy D. Buol rbuol@cityofdubuque.org 50 West 13th Street Dubuque, [A 52001-4864
Phone Extension
Resolution Number
Signature
Mayor
Signature
City Clerk
~ bwaDepartmentofTransportation City Street Financial Report
Form 517007 (4-O5j (pg. 2) (Summary Statement Sheet)
Office of Local Systems
Ames, IA 50010
City Name City Number City Population Fiscal Year
DUBUQUE 2100 57,686 2007
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 1,810,593 0 0 1,810,593
2. Adjustments
(Note on Explanation Sheet)
3. Adjusted Balance 1,810,593 0 0 1,810,593
B. REVENUES
1. Road Use Tax 4,807,832 4,807,832
2. Transfer of
Jurisdictions Fund
2,159
2,159
3. Property Taxes 2,731,631 79,535 2,811,166
4. Special Assessments 608,905 608,905
5. Miscellaneous 4,934,137 4,934,137
6. Proceeds from Bonds,
Notes, and Loans
o
7. Interest Earned 46;127 46,127
8. Total Revenues
(Lines B1 thru B7)
4,809.991
8,320,800
79,535
13,210,326
C. Total Funds Available
(Line A3 + Line B8) 6,620,584 8,320,800 79,535 15,020,919
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,7s9,a1o 25,683 2,815,093
2. Snow and Ice Removal 892,661 892,661
E. Construction Reconstruction and Im rovements
1. Engineering 14,634 2,094,130 2.108,764
2. Right of Way Purchased 22,881 22,881
3. Street/Brid a Construction 151,213 4,460,1.52 4,611,365
4. Traffic Services 133,153 1,271,129 1,404,282
F. Administration 294,631 304,371 599,002
G. Equipment
(Purchased or Leased)
267,059
142,454
409,51.3
H. Miscellaneous
J. Street Debt
1. Bonds, Notes, and Loans -
Principal Paid 40,000 40.000
2. Bonds, Notes, and Loans -
Interest Paid
39,535
39,535
TOTALS
K. Total Expenses
(Lines D thru J) 4,542,761 8,320,800 79,535 12.943,096
L. Ending Balance
(Line C - K) 2,077823 0 0 2,077,823
M. Total Funds Accounted For
(K+L=C) 6,620,584 8,320,800 79,535 15,020,919
~" Iowa Department of Transportation City Street Financial Report
I Form 517007 (405) (pg. 3) (Miscellaneous Revenues and Expenses Sheen
Office of Local Systems
Ames, IA 50010
City Name City Number City Population Fiscal Year
DUBUQUE 2100 57,686 2007
Code Number and Itemization of Miscellaneous Revenues (Line B5 on the Summary Statement Sheet)
(See Instructions) o umn
Other Street
Monies Column 3
Street Debt
140 Federal Government (misc.) 2,502,61.7
170 Reimbursements (misc.) 46,775
173 Reimbursement For Damages 13,395
174 Sales Tax /Local Option 2,362,130
180 Receipts From Sales 1,287
181 Junk and Old 4,933
l82 Property or Buildings (Sale or Rent) 3,000
Line 85 Totals 4,934,137
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)
Column 2 I Column 3
Other Street Street Debt
Monies
Line H T
~ Iowa Department ofTransportatlon City Street Financial Report
Form 517007 (4-OS) (pg. 4) (Bonds, Notes, and Loans Sheet)
Office of Local Systems
Ames, IA 50010
City Name City Number City Population Fiscal Year
DUBUQUE 2100 57,686 2007
Is this a
new bond? Debt Type Debt Purpose DOT
Use Issue
Date Issue
Amount Year
Due Principal
Balance as Principal
Paid Interest
Paid Principal
Balance as
Yes No Only (MM/DD/YYYI~ of 7/1 or after of 6130
X General Obligation Paving & Construction 303 03/26/2002 1,000,000 2021 865,000 40,000 39,535 825,000
Paving & Construction
New Bond Totals 0 Totals 865,000 40,000 39,535 825,000
~ ~ . wwa Department ofTransportatlon City Street Financial Report (Project Final Costs Sheet)
Form 517007 (4-05) (pg. 5) For construction, reconstruction, and improvement projects with costs equal to or
once of focal systems rester than 90% of the bid threshold in effect as the be innin of the fiscal ear
Ames, IA soolo 9 9 9 Y
Check here if there are ^
no entries for this year
City Name City Number City Population Fiscal Year
DUBUQUE 2100 57,686 2007
Section A
Line
No. 1.
Project Number 2.
Estimated
Cost 3.
Project Type 4.
Public
Letting? 5.
Location/Project Description (limits, length, size of structure)
I Rosedale Avenue 1,588,116 Roadway Construction Yes Rosedale Ave reconstruction, Grandview toW.Locust. length 2852 LF
2 Nowata Avenue 363,921 Roadway Construction Yes Nowata St reconstruction, University to Loras, length 827 LF
3 W 5th Street 1,030,649 Roadway Construction Yes W 5th St reconstruction, Delhi to Alpine, length 1717 LF
4 Alta Vista Street 786,025 Roadway Construction Yes Alta Vista St reconstruction, W 5th to University, length 1498 LF
5 Bonson Road 515,180 Roadway Construction Yes Bonson Road reconstruction, Asbury to End, length 1325 LF
6 2006 Asphalt program 967,177 Surfaces Yes Asphalt resurfacing of I ith, 14th, Iowa Street & Penn Ave, length 6400 LF
7 Grandview Ave repairs 45,383 Surfaces Yes Misc concrete panel replacement on Grandview Ave, length 800 LF
8
9
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 Rosedale Avenue Portzen Construction 1,468,9 178 6~ 1 1,647,606
2 Nowata Avenue McDermott Excavating 337,082 15,838 352,920
3 W 5th Street Portzen Construction 1,024,E 2,155 1,026,674
4 Alta Vista Street Portzen Construction 774,981 27,268 802,249
5 Bonson Road Horsfield Construction 507,814 34,833 542,647
6 2006 Asphalt program River City Paving 1.010.6 44,922 1,055,618
7 Grandview Ave repairs Horsfield Construction 49,340 22,056 71,396
8
9
:~ . wwa Department of Transportation City Street Financial Report
Form 517007 (405) (pg.6) (Road/Street Equipment Inventory Sheet)
Office of Local Systems
Ames, IA 50010
Check here if there are ^
no reportable equipment
City Name City Number City Population Fiscal Year
DUBUQUE 2100 57,686 2007
1.
Local Class
I.D. # 2.
Model
Year 3.
Description 4.
Purchase
Cost 5,
Lease /Unit
Cost 6.
Rental JUnit
Cost 7.
Used
on Project
this FY? 8.
Status
41 13 1973 Sno-Go Loader Attachment 16450 No No Change
4103 1998 Sno-Go-Loader Attachment 75000 No No Change
4011 1999 John Deere Lawn Tractor 7300 No o Change
4008 2002 Freightliner Air Johnston Sweeper 115360 No o Change
4006 1988 John Deere Tractor 36000 No o Change
4004 2001 Interanational 56,000 GVW Dump 77500 No o Change
4003 1998 International Vac/Flusher Unit 124756 No o Change
4002 2004 Elgin Pelican Sweeper 93275 No No Change
4001 2004 Interanational 7300 w/ Lodal 76450 No No Change
3506 2004 Gorman Rupp 10" Trash Pump 35720 No No Change
3292 1998 Barber Green Asphalt Paver 164666 No o Change
3286 1985 Doolittle Utility Trailer l 150 No o Change
3282 1994 Berming Machine 4200 No No Change
3281 1993 Speed Screed 3327 No o Change
3280 1993 Honda Generator 1360 No o Change
3279 1996 Melroe Skid-Steer Loader 26108 No o Change
3278 2002 Ingersoll Rand Roller 5356 No No Change
3272 1991 Ingersoll Rand Roller 3210 No o Change
3270 1990 Target Pro 65 Concrete Saw 7740 No No Change
3267 1985 Trailer King Trailer 2836 No No Change
3262 2000 Cimline Crack Sealer 18931 No No Change
3258 1979 Massey Ferguson Tractor 1 1500 No No Change
3257 1997 Wacker Rammer 2296 No o Change
Iowa Department of Transportation City Street Financial Report
~~ Foam snoop ~a-osl tP9. sl (Road/Street Equipment Inventory Sheet)
Office of Local Systems
Ames, IA 50010
Check here if there are ^
no reportable equipment
City Name City Number City Population Fiscal Year
DUBUQUE 2100 57,686 2007
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
3256 2000 John Deere Lawn Tractor 13170 No o Change
3255 198 ] John Deere Motor Grader 34810 No No Change
3252 2005 Chevrolet 4WD 12,000 GVW Dump Truck 36914 No o Change
3251 1991 Caterpillar Paver-Finisher 24411 No o Change
3250 2000 John Deere Wheel Loader 118750 No o Change
3248 1.990 Cimline Crack Saw 3869 No No Change
3247 1990 Cimline Crack Saw 2381 No o Change
3246 2005 Silverado 4WD 12,000 GV W Dump 37814 No No Change
3245 1999 International Tandem Dump Truck 62683 No o Change
3244 1992 John Deere Wheel Loader 92000 No No Change
3243 1991 Sullair Air Compressor 9599 No o Change
3241 1998 International 31,000 GVW Dump 41503 No Traded
3240 1998 Target Pro 65 [II Concrete Saw 8927 No o Change
3238 1993 Townmaster Trailer 5481 No No Change
3237 2001 Atlas Copco Air Compressor 7282 No No Change
3236 1995 GMC Flatbed W/ Welder 24694 No Traded
3235 1996 John Deere Wheel Loader 95672 No o Change
3225 2005 Dynapac CC 122 I Z Series 25842 No No Change
3233 2003 International Tandem Dump Truck 84730 No No Change
3232 1976 Galion Roller 17866 No No Change
3231 2002 Ford F450 4WD 29585 No No Change
3230 1991 4 X 4 Flatbed F350 18304 No Traded
3229 1967 international Tractor 7280 No o Change
bwaDepartmentofTransportation City Street Financial Report
`~' Form 517007 (4-05) (pg. 6) (Road/Street Equipment Inventory Sheet)
Office of Local Systems
Ames, IA 50010
Check here if there are ^
no reportable equipment
City Name City Number City Population Fiscal Year
DUBUQUE 2100 57,686 2007
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 1994 John Deere Backhoe Loader 61825 No o Change
3226 1987 John Deere Motor Grader 27000 No No Change
3224 2003 Atlas Copco Air Compressor 7819 No No Change
3223-1 1997 Snow Equipment Anti-Icing Unit 8176 No No Change
3223 1998 Interanational 26,000 GVW Dump 40500 No No Change
3219 2001 Atlas Copco Air Compressor 7282 No o Change
3218 1996 Interanational Ladder Truck 81646 No o Change
3217 1989 Wacker Vibratory Plate Tamper 1260 No No Change
3216 1998 GMC Tandem Dump Truck 46043 No o Change
3215 200] Caterpillar Vibratory Asphalt Roller 23390 No No Change
3214 1999 John Deere Backhoe Loader 61950 No o Change
3213 1991 John Deere Backhoe Loader 54080 No Traded
3212 2002 Freightliner 31,00 GVW Dump 49510 No No Change
3210 2004 John Deere Backhoe Loader 58375 No No Change
3209 1979 John Deere Motor Grader 25060 No No Change
3208 1998 International 31,000 GVW Dump 40538 No Traded
3207 2003 International Tandem Dump Truck 84730 No o Change
3206 1997 International 31,000 GVW Dump 52034 No Traded
3205 2005 Freightlilner FL70 w/combo Box 73178 No No Change
3204 1991 GMC - 31,000 GVW Dump 33726 No Traded
3203 1998 International 26,00 GVW Dump 41700 No No Change
3252 1997 Chevrolet 4WD 12,000 GVW Dump 23500 No Traded
3202 1998 international W/Rosco Distributor 60795 No o Change
-- wwa~er~rtmentofrr~nspor~tlon City Street Financial Report
'~ •~' Form 517007 (405) (pg.6) (Road/Street Equipment Inventory Sheet)
Office of Local Systems
Ames, IA 50010
Check here if there are ^
rio reportable equipment
City Name City Number City Population Fiscal Year
DUBUQUE 2100 57,686 2007
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 FY7 8.
Status
3201 1999 International 26,000 GVW Dump 41200 No No Change
3101 1997 Chevrolet Pickup Truck 20869 No No Change
2728 1999 Pit Hog 950 - 4" Trash Pump 2302 No Junked
2727 2000 Kawasaki Mule 4 Wheeler 7011 No No Change
2726 2000 Portable Jet/Root Cutter 8595 No o Change
2721 2003 Honda 3" Trash Pump 1197 No o Change
2719 1985 Gorman Rupp 6" Trash Pump 11595 No o Change
2711 1984 GMC Van W/ TV Camera 65400 No o Change
2710 1998 PECO Manhole Cutter 13260 No No Change
2708 1966 Gorman Rupp - 6" Trash Pump 1973 No o Change
2706 1999 CH&S - 6" Trash Pump li846 No o Change
2705 1997 Chevrolet CK31403 Sewer Rodder 24654 No No Change
2704 1997 Internatioal W/Camel 200 Jet 151874 No Traded
2703 2005 Jet Flusher Truck/Pipe Cleaner 88000 No No Change
2702 1997 Ford F350 19324 No Traded
2701 2000 GMC Sierra 25122 No o Change
3242 2005 Freightliner Dump Truck w/ Henderseon Muni Body 75332 No o Change
2715 2006 Godwin 4" Trash Pump 18782 No No Change
4007 2005 Elgin Pelican P Dual Sweeper 128285 No o Change
3242 2005 Freightliner Dump Truck w/ Henderseon Muni Body 87332 No o Change
2702 2008 Ford F3~0 31360 No New
2704 2007 International 7500 SFA 6X4 194618 No New
3102 2007 Chevrolet Silverado 25666 No ew
wwaDepartmentofTransportation City Street Financial Report
`#' Form 517007 (4-05) (pg. 6) (RoadlStreet Equipment Inventory Sheet)
Office of Local Systems
Ames, IA 50010
Check here if there are ^
no reportable equipment
City Name City Number City Population Fiscal Year
DUBUQUE 2100 57,686 2007
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
3204 1999 International 4700 4X2 39450 No ew
3206 2006 International 7400 36411 No ew
3208 2006 International 7400 36411 No ew
3213 2007 John Deere Backhoe Loader 67754 No ew
3236 2007 International 4200 101728 No ew
3241 2006 international 36411 No ew
3230 2007 Ford F550 Crew Cab 91809 No ew
bwa Department of Transportation City Street Financial Report
Form 517007 (4-OS) (pg. 7) (Explanation Sheet)
Office of Local Systems
Ames, IA 50010
City Name City Number City Population Fiscal Year
DUBUQUE 2 t 00 57,686 2007
:quipment # 3204 for FY'06 was mistakenly reported as 1991 GMC - 31,000 GVW Dump, it has been corrected on the equipment sheet and is now a 1999
nternational 7500 SFA 6X4.
'~ (owacepartmentofrransportatlon City Street Financial Report
~ Form 517007 (405) (Monthly Payment Sheet)
Office of Local Systems
Ames, IA 50010
City Name City Number City Population Fiscal Year
DUBUQUE 2100 57,686 2007
Month Road Use
Tax Payments Transfer of
Jurisdictions Payments
July $376, ] 21.07 $170.81
August $413,137.05 $185.17
September $420,068.36 $188.26
October $393,957.24 $176.55
November $338,161.34 $151.53
December $387,390.93 $ ] 73.64
January $41 1,981.03 $184.93
February $443,151.35 $199.1 1
March $501,033.38 $224.72
April $345,831.55 $ 155. l 7
May $359,827.14 $161.52
June $417,171.07 $187.28
Totals $4,807,831.51 $2, ] 58.69