Fiscal Year 2020 Street Finance Report Copyrighted
September 21, 2020
City of Dubuque Consent Items # 13.
City Council Meeting
ITEM TITLE: Fiscal Year 2020 Street Finance Report
SUM MARY: City Manager recommending approval of the City of Dubuque's Fiscal
Year 2020 City Street Financing Report and authorize filing with the lowa
Department of Transportation.
RESOLUTION Approving the City of Dubuque Fiscal Year 2020 City
Street Financing Report
SUGGESTED Suggested Disposition: Receive and File;Adopt Resolution(s)
DISPOSITION:
ATTACHMENTS:
Description Type
MVM Memo City Manager Memo
Staff Memo Staff Memo
Resolution Resolutions
Fiscal Year 2020 Street Finance Report Supporting Documentation
Dubuque
THE CITY OF �
All-America City
DuB E A,�k �,�,, ��.
� I �:�
� �
MRste iece on the Mississi i zoo�•zoiz•zoi3
�P pp zoi7*�o�9
TO: The Honorable Mayor and City Council Members
FROM: Michael C. Van Milligen, City Manager
SUBJECT: Fiscal Year 2020 City Street Financing Report.
DATE: September 8, 2020
Director of Finance and Budget Jennifer Larson recommends the City Council approve
the City of Dubuque's Fiscal Year 2020 City Street Financing Report and authorize filing
with the lowa Department of Transportation.
I concur with the recommendation and respectfully request Mayor and City Council
approval.
�J�/'+�'� �Gv�r
Michael C. Van Milligen
MCVM/jml
Attachment
cc: Crenna Brumwell, City Attorney
Cori Burbach, Assistant City Manager
Teri Goodmann, Assistant City Manager
Gus Psihoyos, City Engineer
Jennifer Larson, Director of Finance and Budget
Cassie Ross, Assistant Director of Finance
Dubuque
THE CITY OF �
AIFA�eriea City
DuB E µ,�k ��,, ��.
� I �:�
� �
Maste iece on the Mississi Z zDD7��o�z•zo�3
�"p pp zoi7*�o�9
TO: Mike Van Milligen, City Manager
FROM: Jennifer Larson, Director of Finance and Budget
SUBJECT: Fiscal Year 2020 City Street Financing Report.
DATE: September 8, 2020
INTRODUCTION
The purpose of this memorandum is to request that the City Council adopt a resolution
approving the City of Dubuque's Fiscal Year 2020 City Street Financing Report.
DISCUSSION
The Code of lowa, Chapter 312, Section 14, provides for the submission of an annual
City Street Finance Report to the lowa Department of Transportation by September 30,
2020. 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 lowa Department of Transportation.
cc: Gus Psihoyos, City Engineer
Cassie Ross, Assistant Director of Finance
RESOLUTION NO. 292-20
APPROVING . THE CITY OF DUBUQUE FISCAL YEAR 2020 CITY STREET
FINANCING REPORT
NOW THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF
DUBUQUE, IOWA THAT:
Section 1. The City Street Finance Report for the period of July 1, 2019, to June 30,
2020, is hereby approved and that the Director of Finance and Budget is hereby
authorized and directed to file said report with the Iowa Department of Transportation.
Passed, approved and adopted this 21 st day of September 202
Roy D. uol, Mayor
Attest:
Kevi,fi S. Firnstahl, City Clerk
Street Finance Report for Dubuque 2020
General SpecialRevenues
Fund Road Debt Capital Utilities Grand
Expenses Service Projects
Streets Use Other (200) (300) �600& Up) Total
(001) (110)
Salaries- Roads/Streets $324,557 $1,103,445 $402,340 $1,830,342
Benefits- Roads/Streets $103,779 $355,670 $135,548 $594,997
Training& Dues $14,556 $12,707 $27,263
Building&Grounds Maint. & Repair $84,378 $84,378
Road Beautification $786,460 $786,460
Vehicle & Office Equip Operation and Repair $7,330 $72,736 $80,066
Operational Equipment Repair $105 $243,781 $5,049 $248,935
Other Utilities $2,659 $5,991 $8,650
Other Maintenance and Repair $443 $24,326 $4,280 $29,049
Engineering $3,360 $73,611 $76,971
Insurance $5,341 $143,617 $148,958
Janitorial $6,181 $96 $6,277
Medical $1,516 $1,516
Printing $1,389 $3,003 $4,392
Rents& Leases $1,263 $19,983 $21,246
Other Professional Services $3,895 $78,273 $27,010 $109,178
Other Contract Services $9,257 $2,325 $11,582
Minor Equipment Purchases $18,453 $18,453
Office Supplies $2,476 $5 $2,481
Operating Supplies $1,292 $118,326 $6,668 $126,286
Postage &Safety $363 $692 $3,062 $4,117
Other Supplies $5,268 $5,268
Vehicles $59,765 $567,498 $627,263
Heavy Equipment $73,825 $73,825
Office Equipment $1,087 $159,148 $160,235
Other Capital Equipment $31,733 $52,798 $84,531
Land Purchase $44,326 $44,326
Right-of-Way $500 $546,004 $546,504
Bridges& Culverts $11,310 $11,310
Street- New Roadway $775,270 $775,270
Street Finance Report for Dubuque 2020
Street-Capacity Improvement $354,696 $354,696
Street- Preservation $1,228,701 $1,228,701
Street-Safety/Environment $268,392 $268,392
Other Capital Outlay $521,727 $126,230 $647,957
Principal Payment $502,904 $502,904
Interest Payment $157,821 $157,821
Transfer Out $462,469 $118,961 $475,614 $1,057,044
Street Lighting $814,873 $22,489 $837,362
Traffic Control/Safety $763,965 $116,820 $277,529 $1,158,314
Snow Removal $1,345,815 $1,345,815
Depreciation & Building Utilities $94,207 $94,207
Street Cleaning $653,080 $653,080
Total $1,237,860 $7,428,030 $118,961 $660,725 $5,410,846 $0 $14,856,422
Street Finance Report for Dubuque 2020
General SpecialRevenues
Fund Road Debt Capital Utilities Grand
Revenues Service Projects
Streets Use Other (200) (300) �600& Up) Total
(001) (110)
Levied on Property $1,065,020 $1,065,020
Other Taxes (Hotel, LOST) $2,880,386 $2,880,386
Interest $978 $30,676 $31,654
Rents & Leases $18,720 $18,720
Federal Grants $1,033,006 $1,033,006
State Revenues- Road Use Taxes $7,408,566 $7,408,566
Other State Grants- IDOT $142,803 $142,803
Local Contributions $175,112 $175,112
Assessments $108,462 $108,462
Contributions $20,057 $147,504 $167,561
Sale of Property& Merchandise $211,083 $211,083
Transfer In $152,783 $33,683 $348,614 $521,964 $1,057,044
Total $1,237,860 $7,653,332 $109,440 $348,614 $4,950,171 $0 $14,299,417
Street Finance Report for Dubuque 2020
Principal Total Total Principal
Bond/Loan Principal Interest
Balance Principal Interest Balance
Description Roads Roads
As of 7/1 Paid Paid As of 6/30
2012B $5,275,000 $375,000 $138,425 $277,500 $102,434 $4,900,000
2012E $2,410,000 $220,000 $59,700 $77,506 $21,032 $2,190,000
2017A $6,165,000 $1,240,000 $184,950 $95,682 $14,271 $4,925,000
2018A $4,635,000 $335,000 $128,850 $52,216 $20,084 $4,300,000
Street Finance Report for Dubuque 2020
Description Model Year Usage Type Cost Purchased Status
Ford F350 2017 Purchased $58,757 No Change
John Deere Lawn Tractor 2016 Purchased $27,100 No Change
John Deere 6247 Endloader 2007 Purchased $136,108 No Change
Chevrolet 4WD 12,000 GVW Dump 2013 Purchased $58,695 No Change
John Deere Wheel Loader 2000 Purchased $118,750 No Change
Cimline Crack Saw 1990 Purchased $2,381 No Change
Silverado 4WD 12,000 GVW Dump w/snow Equpment 2013 Purchased $58,695 No Change
Freightliner Dump Truck with Combo Box 2016 Purchased $136,215 No Change
John Deere Wheel Loader-644K 2012 Purchased $220,000 No Change
Atlas Copco Air Compressor 2009 Purchased $10,351 No Change
International Dump Truck w/Combo Box 2013 Purchased $106,699 No Change
Freightliner Single Axle Dump Truck 2016 Purchased $124,039 No Change
Target Pro 65 III Concrete Saw 1998 Purchased $8,927 No Change
Townmaster Trailer 1993 Purchased $5,481 No Change
Sullivan Air Compressor 2015 Purchased $14,097 No Change
Freightliner 213,500 GVW 2017 Purchased $90,634 No Change
John Deere Wheel Loader 624K 2015 Purchased $214,000 No Change
International Tandem Dump Truck 2012 Purchased $110,675 No Change
Ford F450 4WD 2002 Purchased $29,585 Traded
Ford F5504WD 2020 Purchased $59,765 New
Cimline Crack Sealer 2000 Purchased $18,931 No Change
Ford F550 Crew Cab 2019 Purchased $126,316 No Change
Trailer King Trailer 1985 Purchased $2,836 No Change
Ingersoll Rand Roller 1991 Purchased $3,210 No Change
JD Skid loader 2019 Purchased $63,650 No Change
John Deere Lawn Tractor X758 2017 Purchased $10,850 No Change
Elgin Whirlwind Sweeper 2010 Purchased $177,010 No Change
Elgin Pelican P Dual Sweeper 2013 Purchased $189,459 No Change
John Deere Tractor 2010 Purchased $79,360 No Change
Freightliner Tandem Dump Truck with Henderson Combo Dump Box 2017 Purchased $203,122 No Change
International Vac/Flusher Unit 1998 Purchased $124,756 No Change
M2106 Freightliner with Schwarze Sweeper 2015 Purchased $190,315 No Change
International 7400 w/loadal 2013 Purchased $131,251 No Change
Gorman Rupp 10"Trash Pump 2004 Purchased $35,720 No Change
B&B Trailer 2008 Purchased $5,585 No Change
Street Finance Report for Dubuque 2020
Catepiller 2008 Purchased $277,632 No Change
B&B Trailer 2017 Purchased $6,400 No Change
B&B Trailer 2017 Purchased $8,050 No Change
Ver-mac Sign Board 2019 Purchased $13,150 No Change
Morrison Speed Screed 2018 Purchased $8,991 No Change
Honda Generator 1993 Purchased $1,360 No Change
John Deere 323E Skid-Steer 2014 Purchased $63,327 No Change
Ingersoll Rand Roller 2002 Purchased $5,356 No Change
Huszvarna 30" Pavement Saw 2009 Purchased $21,970 No Change
John Deere Backhoe Loader 2008 Purchased $71,880 No Change
John Deere Motor Grader 2010 Purchased $194,335 No Change
Dynapac CC122 12 Series 2005 Purchased $25,842 No Change
Ford Pickup Truck 2017 Purchased $34,280 No Change
Chevrolet Pickup Truck 2012 Purchased $29,328 No Change
John Deere Gator 2019 Purchased $7,532 No Change
Sewer Easement Machine 2009 Purchased $38,783 No Change
John Deere 625i Gator 2014 Purchased $10,671 No Change
Portable Jet/Root Cutter 2000 Purchased $8,595 No Change
Honda 3"Trash Pump 2003 Purchased $1,197 No Change
Gorman Rupp 6"Trash Pump 1985 Purchased $11,595 No Change
Godwin 4"Trash Pump 2006 Purchased $18,782 No Change
Ford Hi-Cube Van 2/CCTV Equip 2007 Purchased $99,000 No Change
PECO Manhole Cutter 1998 Purchased $13,260 No Change
Tsrumi-6"trash pump 2014 Purchased $15,794 No Change
CH&S-6"Trash Pump 1999 Purchased $13,846 No Change
Chevrolet 3500 Sewer Rodder Silverado 2009 Purchased $76,593 No Change
International 7500 SFA 6X4 2007 Purchased $194,618 Traded
International HV607 SBA w/Vactor 2020 Purchased $344,080 New
Jet Flusher Truck/Pipe Cleaner 2014 Purchased $207,490 No Change
Ford F350 2008 Purchased $31,360 Traded
3500 HD Dodge Ram 2019 Purchased $28,500 New
Caterpillar Asphalt Roller 2010 Purchased $48,575 No Change
Freightliner Dump Truck 2017 Purchased $166,764 No Change
International HV607EX type Distributor 2020 Purchased $154,707 New
International W/Rosco Distributor 1998 Purchased $60,795 Traded
Atlas Copco Air Compressor 2003 Purchased $7,819 No Change
Street Finance Report for Dubuque 2020
Freightliner w/Henderson Combo Dump Box 2020 Purchased $115,909 No Change
Sullivan D185PJD Air Compressor 2014 Purchased $9,517 No Change
Freightliner Bucket Truck 2009 Purchased $137,049 No Change
John Deere Wheel Loader Forks Attachment 2010 Purchased $5,433 No Change
Freightliner Tandem Dump Truck w/combo Box 2016 Purchased $136,215 No Change
Dynapac Vibratory Asphalt Roller 2019 Purchased $23,390 No Change
John Deere Backhoe/Loader 2010 Purchased $82,318 No Change
John Deere Backhoe Loader 2007 Purchased $67,754 Sold
H&H Trailer GT20 2014 Purchased $6,175 No Change
John Deere 410L 2020 Purchased $72,500 New
Freightliner 108 SD 2020 Purchased $141,470 New
John Deere 85G Excavator 2018 Purchased $125,900 No Change
John Deere endloader 624K 2009 Purchased $129,292 No Change
Freightliner Single Axle Dump Truck 2016 Purchased $124,039 No Change
International Tandem Dump Truck 2012 Purchased $110,675 No Change
Freightliner Single Axle Dump Truck 2016 Purchased $124,039 No Change
International 7400 w/combo box 2013 Purchased $106,699 No Change
Freightliner Dump Truck 2017 Purchased $166,558 No Change
Freightliner Dump Truck 2017 Purchased $166,764 No Change
International Dump Truck 2010 Purchased $104,775 Traded
Reversible Plate Compactor 2016 Purchased $7,600 No Change
Street Finance Report for Dubuque 2020
Project Description Contract Price Final Price Contractor Name
22nd Street from White
Street
to Central Avenue &
Kaufmann
Avenue from Central
Avenue to
Francis Street. Length =
615
ft. $2,349,054 $2,524,027 Portzen Construction
Central Avenue from 9th
to
21st Streets Resurfacing.
Length = 3915 ft. $1,335,857 $1,225,558 River City Paving
Jackson Street from 11th
tol2th Street-
Reconstruction. Length =
300 ft $235,688 $260,849 Drew Cook and Sons Excavating
Right turn lane on
Pennsylvania Avenue at
the NW
Arterial (IA32). Length =
350
ft. $340,575 $367,787 Midwest Concrete
Street Finance Report for Dubuque 2020
General SpecialRevenues
Fund Road Debt Capital Utilities Grand
Summary Service Projects
Streets Use Other (200) (300) �600& Up) Total
(001) (110)
Begining Balance -$1,038,721 $4,476,613 -$9,286 -$304,404 -$449,299 $2,674,903
Expense $1,237,860 $7,428,030 $118,961 $660,725 $5,410,846 $14,856,422
Revenue $1,237,860 $7,653,332 $109,440 $348,614 $4,950,171 $14,299,417
Ending Balance -$1,038,721 $4,701,915 -$18,807 -$616,515 -$909,974 $2,117,898
Resolution Number:
Execution Date:
Signature: