Fiscal Year 2023 City Street Financing ReportCopyrighted
December 4, 2023
City of Dubuque Consent Items # 06.
City Council Meeting
ITEM TITLE: Fiscal Year 2023 City Street Financing Report
SUMMARY: City Manager transmitting the annual City Street financing report that has
been filed with the Iowa Department of Transportation.
SUGGESTED Suggested Disposition: Receive and File
DISPOSITION:
ATTACHMENTS:
Description Type
MVM Memo City Manager Memo
Staff Memo Staff Memo
FY23 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 2023 City Street Financing Report.
DATE: November 21, 2023
Dubuque
All -America City
1IIII®r
2007-2012-2013
2017*2019
Chief Financial Officer Jennifer Larson is transmitting the annual City Street financing
report that has been filed with the Iowa Department of Transportation.
� 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, Chief Financial Officer
Brian DeMoss, Finance Manager
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, Chief Financial Officer
SUBJECT: Fiscal Year 2023 City Street Financing Report.
DATE: November 21, 2023
The annual City Street Financing Report has been filed with the Iowa Department of
transportation pursuant to the Code of Iowa, Chapter 312, Section 14. This report
includes all fiscal year 2023 activity related to the City's Street related expenses and
revenues.
Should you have questions on the attached report, please feel free to contact me.
Thank you.
JML
cc: Brian DeMoss, Finance Manager
Gus Psihoyos, City Engineer
Q010WADOT City Street Finance Report Fiscal Year 2023
Bureau of Local Systems
Ames, IA 50010
Expenses
Dubuque
11 /21 /2023 9:56:34 AM
General
Fund
Streets
(001)
Road
Use
(110)
Other
Special
Revenues
Debt
Service
(200)
Capitial
Projects
(300)
Utilities
(600 & UO)
Grand
Total
Salaries - Roads/Streets
$423,847
$1,179,225
$679,383
$2,282,455
Benefits - Roads/Streets
$135,202
$491,001
$243,298
$869,501
Training & Dues
$13,804
$15,019
$1,390
$30,213
Building & Grounds Maint.
& Repair
$80,769
$80,769
Road Beautification
$8,484
$8,484
Vehicle & Office Equip
Operation and Repair
$2,414
$227,464
$229,878
Other Utilities
$4,103
$17,748
$21,851
Other Maintenance and
Repair
$66
$66
Engineering
$4,575
$287,737
$292,312
Insurance
$4,875
$60,633
$65,508
Janitorial
$7,167
$7,167
Legal
$2,000
$2,148
$4,148
Printing
$1,777
$6,600
$8,377
Rents & Leases
$436
$436
Technology Expense
$5,322
$122,290
$50
$127,662
Other Professional
Services
$63,403
$63,403
Other Contract Services
$48,463
$41,430
$38,085
$127,978
Page 1 of 13
Q010WADOT City Street Finance Report Fiscal Year 2023
Bureau of Local Systems
Ames, IA 50010
Dubuque
11 /21 /2023 9:56:34 AM
General
Fund
Streets
(001)
Road
Use
(110)
Other
Special
Revenues
Debt
Service
(200)
Capitial
Projects
(300)
Utilities
(600 & UO)
Grand
Total
Minor Equipment
Purchases
$2,662
$19,092
$21,754
Other Equipment
$35,893
$176,100
$211,993
Office Supplies
$2,007
$269
$2,276
Operating Supplies
$5,184
$5,184
Postage & Safety
$3,797
$909
$4,706
Other Supplies
$47,489
$47,489
Vehicles
$513,036
$513,036
Furniture & Fixtures
$33,140
$33,140
Heavy Equipment
$374,488
$416,859
$791,347
Office Equipment
$350,561
$350,561
Other Capital Equipment
$155,397
$155,397
Land Purchase
$8,120
$8,120
Right -of -Way
$779
$779
Street - Preservation
$1,173,618
$8,195,454
$9,369,072
Other Capital Outlay
$804,496
$2,838,050
$3,642,546
Principal Payment
$248,227
$248,227
Interest Payment
$64,235
$64,235
Transfer Out
$65,475
$92,318
$246,987
$404,780
Street Lighting
$837,377
$837,377
Traffic Control/Safety
$1,790,769
$25,726
$1,816,495
Page 2 of 13
Q010WADOT City Street Finance Report Fiscal Year 2023
Bureau of Local Systems
Ames, IA 50010
Dubuque
11 /21 /2023 9:56:34 AM
General
Fund
Road
Other
Debt
Capitial
Utilities
Grand
Streets
Use
Special
Service
Projects
(600 & UO)
Total
(001)
(110)
Revenues
(200)
(300)
Snow Removal
$1,024,466
$1,024,466
Depreciation & Building
$101,334
$101,334
Utilities
Accounting/Recording
$25
$25
Street Cleaning
$615,362
$615,362
Snow Removal Salaries
$404,529
$404,529
Snow Removal Benefits
$181,751
$181,751
Total $2,473,026 $8,823,941 $92,318 $312,462 $13,374,442
Page 3 of 13
$25,076,189
6010WADOT City Street Finance Report Fiscal Year 2023
Bureau of Local Systems
Ames, IA 50010
Revenue
Dubuque
11 /21 /2023 9:56:34 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
$2,473,026
$0
$0
$2,473,026
Other Taxes (Hotel, LOST)
$3,660,118
$3,660,118
Interest
$98,472
$98,472
Rents & Leases
$25,359
$25,359
Federal Grants
$90,250
$1,675,523
$1,765,773
State Revenues - Road
Use Taxes
$8,210,851
$8,210,851
Other State Grants - IDOT
$5,612,803
$5,612,803
Local Contributions
$640,678
$640,678
Charges/fees
$0
$0
Assessments
$92,318
$92,318
Sale ofAssests
$39,305
$39,305
Transfer In
$312,462
$92,318
$404,780
Total $2,473,026 $8,340,406 $92,318 $312,462 $11,805,271
Page 4 of 13
$0 $23,023,483
GOIGWADOT City Street Finance Report Fiscal Year 2023
Bureau of Local Systems
Ames, IA 50010
Bonds/Loans
Dubuque
11 /21 /2023 9:56:34 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
2021A-Streets Only
$1,609,280
$130,455
$32,186
$130,455
$32,186
$1,478,825
2018A- Streets Only
$632,489
$64,872
$18,975
$64,872
$18,975
$567,617
2017A- Streets Only
$393,384
$52,900
$13,074
$52,900
$13,074
$340,484
Total
$2,635,153 $248,227 $64,235 $248,227
Page 5 of 13
$64,235 $2,386,926
Q010WADOT City Street Finance Report Fiscal Year 2023
Bureau of Local Systems
Ames, IA 50010
Equipment
Dubuque
11 /21 /2023 9:56:34 AM
Description
Model Year
Usage Type
Cost
Purchased Status
WACKER NEUSON VP1340 - VIBRATOR PLATE
2008
Purchased
$1,750
No Change
H&H Trailer GT20
2014
Purchased
$6,175
No Change
John Deere Backhoe /Loader
2010
Purchased
$82,318
No Change
Dynapac Vibratory Asphalt Roller
2019
Purchased
$23,390
No Change
Freightliner Tandem Dump Truck w/combo Box
2016
Purchased
$136,215
No Change
John Deere Wheel Loader Forks Attachment
2010
Purchased
$5,433
No Change
Freightliner Bucket Truck
2009
Purchased
$137,049
No Change
Ver-mac Sign Board
2019
Purchased
$13,150
No Change
Reversible Plate Compactor
2016
Purchased
$7,600
No Change
Freightliner Dump Truck
2017
Purchased
$166,764
No Change
John Deere 323E Skid -Steer
2014
Purchased
$63,327
No Change
Freightliner Dump Truck
2017
Purchased
$166,558
No Change
International 7400 w/combo box
2013
Purchased
$106,699
No Change
John Deere 410L
2020
Purchased
$72,500
No Change
Freightliner Single Axle Dump Truck
2016
Purchased
$124,039
No Change
John Deere Gator
2019
Purchased
$7,532
No Change
Chevrolet Pickup Truck
2012
Purchased
$29,328
No Change
Ford Pickup Truck
2017
Purchased
$34,280
No Change
Dynapac CC122 12 Series
2005
Purchased
$25,842
No Change
John Deere Motor Grader
2010
Purchased
$194,335
No Change
John Deere Backhoe Loader
2008
Purchased
$71,880
Sold
Page 6 of 13
QOJOWADOT City Street Finance Report Fiscal Year 2023
Bureau of Local Systems
Ames, IA 50010
Dubuque
11 /21 /2023 9:56:34 AM
Description
Model Year
Usage Type
Cost
Purchased Status
Huszvarna 30" Pavement Saw
2009
Purchased
$21,970
No Change
Ingersoll Rand Roller
2002
Purchased
$5,356
No Change
Sullivan D185PJD Air Compressor
2014
Purchased
$9,517
No Change
Freightliner w/Henderson Combo Dump Box
2020
Purchased
$115,909
No Change
Atlas Copco Air Compressor
2003
Purchased
$7,819
No Change
HOMEL HOMELITE - TRASH PUMP 3 IN
1996
Purchased
$1,179
No Change
John Deere endloader 624K
2009
Purchased
$129,292
No Change
Cimline Crack Saw
1990
Purchased
$2,381
No Change
Freightliner 108 SD
2020
Purchased
$141,470
No Change
Honda 3" Trash Pump
2003
Purchased
$1,197
No Change
Global 6" Trash Pump
2021
Purchased
$50,138
No Change
John Deere Lawn Tractor X758
2017
Purchased
$10,850
No Change
B&B Trailer
2017
Purchased
$8,050
No Change
John Deere 85G Excavator
2018
Purchased
$125,900
No Change
B&B Trailer
2017
Purchased
$6,400
No Change
B&B Trailer
2008
Purchased
$5,585
No Change
Gorman Rupp 10" Trash Pump
2004
Purchased
$35,720
No Change
International 7400 w/loadal
2013
Purchased
$131,251
No Change
M2106 Freightliner with Schwarze Sweeper
2015
Purchased
$190,315
No Change
International Vac/Flusher Unit
1998
Purchased
$124,756
No Change
Freightliner Tandem Dump Truck with Henderson Combo Dump Box
2017
Purchased
$203,122
No Change
John Deere Tractor
2010
Purchased
$79,360
No Change
Elgin Pelican P Dual Sweeper
2013
Purchased
$189,459
No Change
Page 7 of 13
QOJOWADOT City Street Finance Report Fiscal Year 2023
Bureau of Local Systems
Ames, IA 50010
Dubuque
11 /21 /2023 9:56:34 AM
Description
Model Year
Usage Type
Cost
Purchased Status
Sewer Easement Machine
2009
Purchased
$38,783
No Change
Morrison Speed Screed
2018
Purchased
$8,991
No Change
JD Skid loader
2019
Purchased
$63,650
No Change
John Deere 625i Gator
2014
Purchased
$10,671
No Change
Catepiller
2008
Purchased
$277,632
No Change
John Deere Wheel Loader
2000
Purchased
$118,750
No Change
Chevrolet 4WD 12,000 GVW Dump
2013
Purchased
$58,695
No Change
John Deere 6247 Endloader
2007
Purchased
$136,108
No Change
Chevrolet 3500 Sewer Rodder Silverado
2009
Purchased
$76,593
No Change
CH&S - 6" Trash Pump
1999
Purchased
$13,846
No Change
Tsrumi-6" trash pump
2014
Purchased
$15,794
No Change
PECO Manhole Cutter
1998
Purchased
$13,260
No Change
Ford Hi -Cube Van 2/ CCTV Equip
2007
Purchased
$99,000
No Change
Godwin 4" Trash Pump
2006
Purchased
$18,782
No Change
Gorman Rupp 6" Trash Pump
1985
Purchased
$11,595
No Change
Portable Jet/Root Cutter
2000
Purchased
$8,595
No Change
Ingersoll Rand Roller
1991
Purchased
$3,210
No Change
Trailer King Trailer
1985
Purchased
$2,836
No Change
Ford F550 Crew Cab
2019
Purchased
$126,316
No Change
Cimline Crack Sealer
2000
Purchased
$18,931
Traded
International HV607 SBA w/ Vactor
2020
Purchased
$344,080
No Change
Ford F550 4WD
2020
Purchased
$59,765
No Change
Freightliner 213,500 GVW
2017
Purchased
$90,634
No Change
Page 8 of 13
Q010WADOT City Street Finance Report Fiscal Year 2023
Bureau of Local Systems
Ames, IA 50010
Dubuque
11 /21 /2023 9:56:34 AM
Description
Model Year
Usage Type
Cost
Purchased Status
Townmaster Trailer
1993
Purchased
$5,481
No Change
Target Pro 65 III Concrete Saw
1998
Purchased
$8,927
No Change
Freightliner Single Axle Dump Truck
2016
Purchased
$124,039
No Change
International Dump Truck w/Combo Box
2013
Purchased
$106,699
No Change
STIHL TS400 - CONCRETTE SAW
2004
Purchased
$1,203
No Change
STIHL TS500i - CONCRETE SAW
2019
Purchased
$1,203
No Change
STIHL TS500i - CONCRETE SAW
2019
Purchased
$1,203
No Change
STIHL TS500i - SAW
2016
Purchased
$999
No Change
TSURUMI 2" 2/3 HP - PUMP
2016
Purchased
$328
No Change
VER-MAC PCMS-548/HYD - Message Board
2021
Purchased
$14,450
No Change
WACKER NEUSON VP 1340AW - VIBROPLATE
2016
Purchased
$1,750
No Change
John Deere Wheel Loader 624K
2015
Purchased
$214,000
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
John Deere Lawn Tractor
2016
Purchased
$27,100
No Change
Ford F350
2017
Purchased
$58,757
No Change
Silverado 4WD 12,000 GVW Dump w/snow Equpment
2013
Purchased
$58,695
No Change
B-B UTILITY TILT BED TRAILER F - TRAILER
2018
Purchased
$17,970
No Change
B-B UTILITY TILT BED TRAILER T - TRAILER B&B
2016
Purchased
$5,500
No Change
CYCLONE CY5000 - SWEEPER
2020
Purchased
$156,540
No Change
FIVE D INDUSTRIES HOT PATCH BE - HOT PATCH BOX
2020
Purchased
$20,005
No Change
H & H TRAILER UT20 - Trailer
2015
Purchased
$4,978
No Change
Page 9 of 13
Q010WADOT City Street Finance Report Fiscal Year 2023
Bureau of Local Systems
Ames, IA 50010
Dubuque
11 /21 /2023 9:56:34 AM
Description
Model Year
Usage Type
Cost
Purchased Status
Honda - TRASH PUMP 3 IN
2014
Purchased
$1,179
No Change
International HV607EX type Distributor
2020
Purchased
$154,707
No Change
Honda HND-WT-30 - 3 " PUMP
2017
Purchased
$1,220
No Change
Honda HND-WT-30 - TRASH PUMP 3 IN
2015
Purchased
$1,216
No Change
Honda TRASH PUMP - 2" PUMP
2016
Purchased
$998
No Change
INTERNATIONAL HV607 SBA
2020
Purchased
$164,773
No Change
INTERNATIONAL HV607 SBA
2020
Purchased
$190,773
No Change
INTERNATIONAL HV607 SBA
2020
Purchased
$164,773
No Change
MIKASA MVC-82VH - VIBRATOR PLATE
2012
Purchased
$1,750
No Change
MULTI -QUIP MTX60HD - RAMMER
2013
Purchased
$2,265
No Change
MULTI -QUIP MTX60HD - TAMPING RAMMER
2017
Purchased
$2,265
No Change
PALADIN X4575 - CUTTER
2018
Purchased
$23,500
No Change
STIHL MS170 - CHAIN SAW
2019
Purchased
$180
No Change
STIHL MVS-TS420-14 - SAW
2017
Purchased
$909
No Change
Freightliner Dump Truck with Combo Box
2016
Purchased
$136,215
No Change
Freightliner Single Axle Dump Truck
2016
Purchased
$124,039
No Change
John Deere Wheel Loader - 644K
2012
Purchased
$220,000
No Change
Atlas Copco Air Compressor
2009
Purchased
$10,351
No Change
Freightliner Dump Truck
2017
Purchased
$166,764
No Change
H10252 Plate Compactor
2023
Purchased
$10,592
New
cobra curber including dump bucket
2022
Purchased
$18,955
New
B&B Tilt Trailer
2023
Purchased
$11,090
New
3250 - Endloader Grapple Bucket
2023
Purchased
$24,300
New
Page 10 of 13
GOIGWADOT City Street Finance Report Fiscal Year 2023
Bureau of Local Systems
Ames, IA 50010
Dubuque
11 /21 /2023 9:56:34 AM
Description
Model Year
Usage Type
Cost
Purchased Status
Cimline Crack Sealer Unit
2022
Purchased
$48,095
New
Vacuum Sweeper
2023
Purchased
$302,093
New
John Deere 85G Backhoe Loader
2023
Purchased
$129,500
New
Page 11 of 13
GOIGWADOT City Street Finance Report Fiscal Year 2023
Bureau of Local Systems
Ames, IA 50010
Street Projects
Dubuque
11 /21 /2023 9:56:34 AM
Project Description
Contract Price
Final Price
Contractor Name
Stoneman Road Reconstruction from
$991,650
$1,182,104
McDermott Excavating
John F. Kennedy Road to end. Length
= 900 LF
Page 12 of 13
6010WADOT City Street Finance Report Fiscal Year 2023
Bureau of Local Systems
Ames, IA 50010
Summary
Dubuque
11 /21 /2023 9:56:34 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
$8,647,657
$0
$4,874
$6,893,063
$0
$15,545,594
SubTotal Expenses (-)
$2,473,026
$8,758,466
$312,462
$13,127,455
$24,671,409
Transfers Out (-)
$65,475
$92,318
$246,987
$404,780
Subtotal Revenues (+)
$2,473,026
$8,340,406
$92,318
$0
$11,712,953
$0
$22,618,703
Transfers In (+)
$312,462
$92,318
$404,780
Ending Balance
$0
$8,164,122
$0
$4,874
$5,323,892
$0
$13,492,888
Resolution Number:
Execution Date: Monday, December 4, 2023
Signature: Brian DeMoss
Page 13 of 13