Fiscal Year 2022 City Street Financing ReportCopyrighted
November 7, 2022
City of Dubuque Consent Items # 06.
City Council Meeting
ITEM TITLE: Fiscal Year 2022 City Street Financing Report
SUMMARY: City Manager recommending City Council approve the City of Dubuque's
Fiscal Year 2022 City Street Financing Report and authorize filing with
the Iowa Department of Transportation.
RESOLUTION Approving the City of Dubuque Fiscal Year 2022 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
FY22 Iowa Street Financing Report Supporting Documentation
THE CITY OF
DUB E
Masterpiece on the Mississippi
TO: The Honorable Mayor and City Council Members
FROM: Michael C. Van Milligen, City Manager
SUBJECT: Fiscal Year 2022 City Street Financing Report.
DATE: October 18, 2022
Dubuque
All -America City
1IIII®r
2007-2012-2013
2017*2019
Director of Finance and Budget Jennifer Larson recommends the City Council approve
the City of Dubuque's Fiscal Year 2022 City Street Financing Report and authorize filing
with the Iowa Department of Transportation.
I concur with the recommendation and respectfully request Mayor and City Council
approval.
� k�4 sAi:�
Michael C. Van Milligen
MCVM/jml
Attachment
cc- Crenna Brumwell, City Attorney
Cori Burbach, Assistant City Manager
Gus Psihoyos, City Engineer
Jennifer Larson, Director of Finance and Budget
THE CITY OF
Dubuque
DUB E
All -America City
µ x, ,TK ,.4 .
Masterpiece on the Mississippi
� pp
zoo�•zoi 2-2013
2017+2019019
TO: Mike Van Milligen, City Manager
FROM: Jennifer Larson, Director of Finance and Budget
SUBJECT: Fiscal Year 2022 City Street Financing Report.
DATE: October 18, 2022
INTRODUCTION
The purpose of this memorandum is to request that the City Council adopt a resolution
approving the City of Dubuque's Fiscal Year 2022 City Street Financing 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 December 1,
2022. 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.
cc: Gus Psihoyos, City Engineer
Prepared by Jennifer Larson Director of Finance and Budget 50 W. 130 St Dubuque IA 52001 (563) 589 4322
Return to Adrienne N. Breitfelder, City Clerk, 50 W. 13°i St., Dubuque, IA 52001, (563) 589-4100
RESOLUTION NO. 343-22
APPROVING THE CITY OF DUBUQUE FISCAL YEAR 2022 CITY STREET
FINANCING 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, 2021, to June
30, 2022, 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 7th day of November 2022.
Attest:
aAc e� k4&
Adrienne N. Breitfelder, City Clerk
Q010WADOT City Street Finance Report Fiscal Year 2022
Bureau of Local Systems
Ames, IA 50010
Expenses
Dubuque
10/18/2022 11:55:04 AM
General
Fund
Road
Other
Debt
Capitial
Utilities
Grand
Streets
Use
Special
Service
Projects
(600 & UO)
Total
(001)
(110)
Revenues
(200)
(300)
Salaries - Roads/Streets
$382,600
$1,084,065
$501,696
$1,968,361
Benefits - Roads/Streets
$128,170
$431,695
$184,908
$744,773
Training & Dues
$13,073
$12,480
$25,553
Building & Grounds Maint.
$125,543
$125,543
& Repair
Road Beautification
$834,289
$179,432
$1,013,721
Vehicle & Office Equip
$11,104
$80,683
$91,787
Operation and Repair
Operational Equipment
$450
$111,285
$5,139
$116,874
Repair
Other Utilities
$3,217
$7,998
$11,215
Other Maintenance and
$220
$3,226
$1,195
$4,641
Repair
Engineering
$2,525
$323,084
$325,609
Insurance
$3,981
$132,825
$136,806
Janitorial
$6,115
$6,115
Printing
$1,119
$2,581
$299
$3,999
Rents & Leases
$1,760
$11,003
$12,763
Street Maintenance
$2,887
$2,887
Expense
Other Professional
$21,062
$68,272
$40,419
$129,753
Services
Page 1 of 12
Q010WADOT City Street Finance Report Fiscal Year 2022
Bureau of Local Systems
Ames, IA 50010
Dubuque
10/18/2022 11:55:04 AM
General
Fund
Streets
(001)
Road
Use
(110)
Other
Special
Revenues
Debt
Service
(200)
Capitial
Projects
(300)
Utilities
(600 & UO)
Grand
Total
Other Contract Services
$8,466
$8,466
Minor Equipment
Purchases
$28,849
$6,405
$35,254
Office Supplies
$2,733
$22
$2,755
Operating Supplies
$4,164
$274,637
$12,471
$291,272
Postage & Safety
$166
$519
$685
New Posts & Signs
$2,074
$2,074
Other Supplies
$5,795
$5,795
Office Equipment
$150
$54,591
$54,741
Other Capital Equipment
$190,145
$924,706
$1,114,851
Right -of -Way
$7,581
$7,581
Street - New Roadway
$44,509
$44,509
Street - Capacity
Improvement
$36,053
$36,053
Street - Preservation
$850,085
$2,741,722
$3,591,807
Street - Safety/
Environment
$239,583
$239,583
Other Capital Outlay
$43,225
$468,434
$511,659
Principal Payment
$261,414
$261,414
Interest Payment
$69,857
$69,857
Transfer Out
$148,765
$821,913
$358,673
$1,329,351
Street Lighting
$786,867
$12,049
$798,916
Page 2 of 12
GOIGWADOT City Street Finance Report Fiscal Year 2022
Bureau of Local Systems
Ames, IA 50010
Dubuque
10/18/2022 11:55:04 AM
General
Fund
Road
Other
Debt
Capitial
Utilities
Grand
Streets
Use
Special
Service
Projects
(600 & UO)
Total
(001)
(110)
Revenues
(200)
(300)
Traffic Control/Safety
$1,903,736
$484,050
$2,387,786
Depreciation & Building
$80,299
$80,299
Utilities
Street Cleaning
$726,896
$726,896
Snow Removal Salaries
$1,264,810
$1,264,810
Total $3,333,202 $6,528,020 $821,913 $331,271 $6,572,408
Page 3 of 12
$17,586,814
6010WADOT City Street Finance Report Fiscal Year 2022
Bureau of Local Systems
Ames, IA 50010
Revenue
Dubuque
10/18/2022 11:55:04 AM
General
Fund
Streets
(001)
Road
Use
(110)
Other
Special
Revenues
Debt
Service
(200)
Capitial
Projects
(300)
Utilities
(600 & UO)
Grand
Total
Levied on Property
$3,113,269
$0
$0
$3,113,269
TIF Revenues
$682,849
$682,849
Other Taxes (Hotel, LOST)
$3,788,391
$3,788,391
Interest
$152
$32,512
$32,664
Rents & Leases
$35,438
$35,438
Federal Grants
$662,895
$662,895
State Revenues - Road
Use Taxes
$8,197,374
$8,197,374
Other State Grants - IDOT
$25,084
$25,084
Charges/fees
$0
$0
Assessments
$92,371
$92,371
Contributions
$111,332
$159,330
$270,662
Sale of Property &
Merchandise
$180
$180
Transfer In
1 $108,601
1
1 $336,145
$884,605
$1,329,351
Total $3,333,202 $8,197,554 $775,372 $336,145 $5,588,255
Page 4 of 12
$0 $18,230,528
GOIGWADOT City Street Finance Report Fiscal Year 2022
Bureau of Local Systems
Ames, IA 50010
Bonds/Loans
Dubuque
10/18/2022 11:55:04 AM
Bond/Loan
Description
Principal
Balance
As of 7/1
Total
Principal
Paid
Total
Interest
Paid
Principal
Roads
Interest
Roads
Principal
Balance
As of 6/30
2017A- Streets Only
$443,084
$49,700
$14,565
$49,700
$14,565
$393,384
2018A - Streets Only
$695,735
$63,246
$20,240
$63,246
$20,240
$632,489
2021A-Streets Only
$1,757,748
$148,468
$35,052
$148,468
$35,052
$1,609,280
Page 5 of 12
QIGWADOT City Street Finance Report Fiscal Year 2022
Bureau of Local Systems
Ames, IA 50010
Equipment
Dubuque
10/18/2022 11:55:04 AM
Description
Model Year
Usage Type
Cost
Purchased Status
WACKER NEUSON VP1340 - VIBRATOR PLATE
2008
Purchased
$1,750
No Change
WACKER NEUSON VP 1340AW - VIBROPLATE
2016
Purchased
$1,750
No Change
VER-MAC PCMS-548/HYD - Message Board
2021
Purchased
$14,450
No Change
TSURUMI 2" 2/3 HP - PUMP
2016
Purchased
$328
No Change
STIHL TS500i - SAW
2016
Purchased
$999
No Change
STIHL TS500i - CONCRETE SAW
2019
Purchased
$1,203
No Change
STIHL TS500i - CONCRETE SAW
2019
Purchased
$1,203
No Change
STIHL TS400 - CONCRETTE SAW
2004
Purchased
$1,203
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
Traded
Freightliner 213,500 GVW
2017
Purchased
$90,634
No Change
John Deere Wheel Loader 624K
2015
Purchased
$214,000
No Change
Ford F550 4WD
2020
Purchased
$59,765
No Change
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
Portable Jet/Root Cutter
2000
Purchased
$8,595
No Change
Page 6 of 12
Q010WADOT City Street Finance Report Fiscal Year 2022
Bureau of Local Systems
Ames, IA 50010
Dubuque
10/18/2022 11:55:04 AM
Description
Model Year
Usage Type
Cost
Purchased Status
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 HV607 SBA w/ Vactor
2020
Purchased
$344,080
No Change
Jet Flusher Truck / Pipe Cleaner
2014
Purchased
$207,490
No Change
3500 HD Dodge Ram
2019
Purchased
$28,500
No Change
Caterpillar Asphalt Roller
2010
Purchased
$48,575
No Change
Freightliner Dump Truck
2017
Purchased
$166,764
No Change
Atlas Copco Air Compressor
2009
Purchased
$10,351
No Change
John Deere Wheel Loader - 644K
2012
Purchased
$220,000
No Change
Freightliner Single Axle Dump Truck
2016
Purchased
$124,039
No Change
Freightliner Dump Truck with Combo Box
2016
Purchased
$136,215
No Change
STIHL MVS-TS420-14 - SAW
2017
Purchased
$909
No Change
STIHL MS170 - CHAIN SAW
2019
Purchased
$180
No Change
PALADIN X4575 - CUTTER
2018
Purchased
$23,500
No Change
MULTI -QUIP MTX60HD - TAMPING RAMMER
2017
Purchased
$2,265
No Change
MULTI -QUIP MTX60HD - RAMMER
2013
Purchased
$2,265
No Change
MIKASA MVC-82VH - VIBRATOR PLATE
2012
Purchased
$1,750
No Change
INTERNATIONAL HV607 SBA
2020
Purchased
$164,773
No Change
Page 7 of 12
Q010WADOT City Street Finance Report Fiscal Year 2022
Bureau of Local Systems
Ames, IA 50010
Dubuque
10/18/2022 11:55:04 AM
Description
Model Year
Usage Type
Cost
Purchased Status
INTERNATIONAL HV607 SBA
2020
Purchased
$190,773
No Change
INTERNATIONAL HV607 SBA
2020
Purchased
$164,773
No Change
Honda TRASH PUMP - 2" PUMP
2016
Purchased
$998
No Change
Honda HND-WT-30 - TRASH PUMP 3 IN
2015
Purchased
$1,216
No Change
Honda HND-WT-30 - 3 " PUMP
2017
Purchased
$1,220
No Change
International HV607EX type Distributor
2020
Purchased
$154,707
No Change
Honda -TRASH PUMP 3 IN
2014
Purchased
$1,179
No Change
H & H TRAILER UT20 - Trailer
2015
Purchased
$4,978
No Change
FIVE D INDUSTRIES HOT PATCH BE - HOT PATCH BOX
2020
Purchased
$20,005
No Change
CYCLONE CY5000 - SWEEPER
2020
Purchased
$156,540
No Change
B-B UTILITY TILT BED TRAILER T - TRAILER B&B
2016
Purchased
$5,500
No Change
B-B UTILITY TILT BED TRAILER F - TRAILER
2018
Purchased
$17,970
No Change
Silverado 4WD 12,000 GVW Dump w/snow Equpment
2013
Purchased
$58,695
No Change
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
HOMEL HOMELITE - TRASH PUMP 3 IN
1996
Purchased
$1,179
No Change
Atlas Copco Air Compressor
2003
Purchased
$7,819
No Change
Freightliner w/Henderson Combo Dump Box
2020
Purchased
$115,909
No Change
Sullivan D185PJD Air Compressor
2014
Purchased
$9,517
No Change
Page 8 of 12
QOJOWADOT City Street Finance Report Fiscal Year 2022
Bureau of Local Systems
Ames, IA 50010
Dubuque
10/18/2022 11:55:04 AM
Description
Model Year
Usage Type
Cost
Purchased Status
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
John Deere endloader 624K
2009
Purchased
$129,292
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
John Deere 323E Skid -Steer
2014
Purchased
$63,327
No Change
Freightliner Dump Truck
2017
Purchased
$166,764
No Change
Reversible Plate Compactor
2016
Purchased
$7,600
No Change
Honda Generator
1993
Purchased
$1,360
Traded
Ver-mac Sign Board
2019
Purchased
$13,150
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
H&H Trailer GT20
2014
Purchased
$6,175
No Change
Page 9 of 12
QOJOWADOT City Street Finance Report Fiscal Year 2022
Bureau of Local Systems
Ames, IA 50010
Dubuque
10/18/2022 11:55:04 AM
Description
Model Year
Usage Type
Cost
Purchased Status
John Deere 410L
2020
Purchased
$72,500
No Change
Freightliner 108 SD
2020
Purchased
$141,470
No Change
John Deere 85G Excavator
2018
Purchased
$125,900
No Change
Honda 3" Trash Pump
2003
Purchased
$1,197
No Change
John Deere 625i Gator
2014
Purchased
$10,671
No Change
JD Skid loader
2019
Purchased
$63,650
No Change
Morrison Speed Screed
2018
Purchased
$8,991
No Change
Sewer Easement Machine
2009
Purchased
$38,783
No Change
Elgin Whirlwind Sweeper
2010
Purchased
$177,010
Traded
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
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
John Deere Lawn Tractor X758
2017
Purchased
$10,850
No Change
Global 6" Trash Pump
2021
Purchased
$50,138
New
Page 10 of 12
GOIGWADOT City Street Finance Report Fiscal Year 2022
Bureau of Local Systems
Ames, IA 50010
Street Projects
Dubuque
10/18/2022 11:55:04 AM
Project Description
Contract Price
Final Price
Contractor Name
Chavenelle Road Reconstruction
$1,864,874
$2,332,141
Horsfeld Contruction
Central Avenue Resurfacing
$1,335,857
$1,192,150
River City Paving
17th Street Reconstruction
$378,313
$316,596
Portzen Construction
Page 11 of 12
6010WADOT City Street Finance Report Fiscal Year 2022
Bureau of Local Systems
Ames, IA 50010
Summary
Dubuque
10/18/2022 11:55:04 AM
General
Fund
Road
Other
Debt
Capitial
Utilities
Grand
Streets
Use
Special
Service
Projects
(600 & UO)
Total
(001)
(110)
Revenues
(200)
(300)
Begining Balance
$0
$6,883,385
$46,541
$0
$7,877,216
$0
$14,807,142
SubTotal Expenses (-)
$3,333,202
$6,379,255
$331,271
$6,213,735
$16,257,463
Transfers Out (-)
$148,765
$821,913
$358,673
$1,329,351
Subtotal Revenues (+)
$3,224,601
$8,197,554
$775,372
$0
$4,703,650
$0
$16,901,177
Transfers In (+)
$108,601
$336,145
$884,605
$1,329,351
Ending Balance
$0
$8,552,919
$0
$4,874
$6,893,063
$0
$15,450,856
Resolution Number:
Execution Date: Tuesday, October 18, 2022
Signature: Joshua Larsen
Page 12 of 12