Fiscal Year 2024 City Street Financing Report Copyrighted
December 2, 2024
City of Dubuque CONSENT ITEMS # 6.
City Council
ITEM TITLE: Fiscal Year 2024 City Street Financing Report
SUMMARY: City Manager transmitting the annual City Street financing
report that has been filed with the lowa Department of
Transportation.
SUGGUESTED Receive and File
DISPOSITION:
ATTACHMENTS:
1. MVM Memo FY24 State of lowa Street Financing Report_MVM Memo
2. FY24 State of lowa Street Financing Report_Staff Memo (1)
3. FY24 lowa Street Financing Report
Page 128 of 645
Dubuque
THE CITY OF �
All•A�eriea City
DuB E ;�iu . ,
II �
Maste 12Ce OYl t�le MZS51S51 1 zoo��zoiz•zois
rP PP �oi�*zoi9
TO: The Honorable Mayor and City Council Members
FROM: Michael C. Van Milligen, City Manager
SUBJECT: Fiscal Year 2024 City Street Financing Report.
DATE: November 22, 2024
Chief Financial Officer Jennifer Larson is transmitting the annual City Street financing
report that has been filed with the lowa Department of Transportation.
��2�� v GV►t
Michael C. Van Milligen
MCVM/bd
Attachment
cc: Crenna Brumwell, City Attorney
Cori Burbach, Assistant City Manager
Gus Psihoyos, City Engineer
Jennifer Larson, Chief Financial Officer
Brian DeMoss, Finance Manager
Page 129 of 645
Dubuque
THE CITY OF �
All•Anerica City
DuB E ;�iu . ,
II �
Maste 12Ce OYl t�le MZSS1S51 1 zoo��zoiz•zois
rP pp zoi��zoi9
TO: Mike Van Milligen, City Manager
FROM: Jennifer Larson, Chief Financial Officer, Brian DeMoss, Finance Manger
SUBJECT: Fiscal Year 2024 City Street Financing Report.
DATE: November 22, 2024
The annual City Street Financing Report has been filed with the lowa Department of
transportation pursuant to the Code of lowa, Chapter 312, Section 14. This report
includes all fiscal year 2024 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.
BD
cc: Brian DeMoss, Finance Manager
Gus Psihoyos, City Engineer
Page 130 of 645
�JI\J1INMDOT City Street Finance Report FiscalYear2024
�
Bureau of Local Systems Dubuque
11/22/2024 8:17:43 AM
Ames, IA 50010
Expenses
General Road Other Debt Capitial
Fund Use Special Service Projects Utilities Grand
Streets (110) Revenues (200) (300) (600 & UO) Total
(001)
Salaries - Roads/Streets $450,823 $1,332,787 $561,673 $2,345,283
Benefits - Roads/Streets $165,302 $506,984 $192,572 $864,858
Training & Dues $20,447 $16,550 $3,413 $40,410
Building & Grounds Maint. $118,574 $118,574
& Repair
Road Beautification $7,330 $7,330
Vehicle & Office Equip $2,894 $32,365 $35,259
Operation and Repair
Other Utilities $35,800 $18,278 $54,078
Engineering $2,400 $412,358 $414,758
Insurance $5,157 $38,245 $43,402
Janitorial $554 $554
Legal $32,585 $32,585
Printing $1,088 $1,088
Rents & Leases $1,630 $1,630
Street Maintenance $4,898 $4,898
Expense
Technology Expense $5,155 $154,583 $159,738
Other Professional $77,472 $48,738 $126,210
Services
Other Contract Services $20,787 $211,082 $164,800 $396,669
Page 1 of 13
Page 131 of 645
�JILJIINMDOT City Street Finance Report FiscalYear2024
�
Bureau of Local Systems Dubuque
11/22/2024 8:17:43 AM
Ames, IA 50010
General Road Other Debt Capitial
Fund Use Special Service Projects Utilities Grand
Streets (110) Revenues (200) (300) (600 & UO) Total
(001)
Minor Equipment $2,464 $27,613 $30,077
Purchases
Other Equipment $49,732 $112,468 $162,200
Office Supplies $2,822 $56,202 $59,024
Operating Supplies $1,494 $1,494
Postage & Safety $1,127 $150 $1,277
Other Supplies $16,257 $16,257
Vehicles $175,945 $175,945
Furniture & Fixtures $12,449 $12,449
Heavy Equipment $162,953 $589,073 $752,026
Other Capital Equipment $544,664 $39,018 $583,682
Land Purchase $450 $450
Right-of-Way $16,922 $16,922
Street- Preservation $1,348,506 $1,348,506
OtherCapitalOutlay $7,380 $291,568 $5,034,399 $76,160 $5,409,507
Principal Payment $247,467 $247,467
Interest Payment $67,205 $67,205
Transfer Out $631,841 $21,639 $229,421 $15,903 $898,804
Street Lighting $790,140 $790,140
Traffic Control/Safety $1,162,691 $891 $1,163,582
Snow Removal $1,262,899 $1,262,899
Page 2 of 13
Page 132 of 645
�JI\J1INMDOT City Street Finance Report FiscalYear2024
�
Bureau of Local Systems Dubuque
11/22/2024 8:17:43 AM
Ames, IA 50010
General Road Other Debt Capitial
Fund Use Special Service Projects Utilities Grand
Streets (110) Revenues (200) (300) (600 & UO) Total
(001)
Depreciation & Building $119,402 $119,402
Utilities
Street Cleaning $581,058 $581,058
Snow Removal Salaries $274,645 $274,645
Snow Removal Benefits $161,463 $161,463
Total $1,981,156 $8,960,146 $21,639 $314,672 $7,414,129 $92,063 $18,783,805
Page 3 of 13
Page 133 of 645
�JILJIINMDOT City Street Finance Report FiscalYear2024
�
Bureau of Local Systems Dubuque
11/22/2024 8:17:43 AM
Ames, IA 50010
Revenue
General Road Other Debt Capitial
Fund Use Special Service Projects Utilities Grand
Streets (110) Revenues (200) (300) (600 & UO) Total
(001)
Levied on Property $1,981,156 $0 $0 $1,981,156
Other Taxes (Hotel, LOST) $3,658,701 $3,658,701
Interest $324,529 $324,529
Rents & Leases $27,571 $27,571
Federal Grants $426,964 $426,964
State Revenues - Road $8,428,119 $8,428,119
Use Taxes
Other State Grants - IDOT $907,137 $907,137
Charges/fees $92,063 $92,063
Assessments $21,639 $21,639
Contributions $207,567 $207,567
Sale of Property& $12,656 $12,656
Merchandise
Transfer In $19,291 $314,672 $472,748 $92,093 $898,804
Total $1,981,156 $8,667,633 $21,639 $314,672 $5,817,650 $184,156 $16,986,906
Page 4 of 13
Page 134 of 645
,JI\J1INMDOT City Street Finance Report FiscalYear2024
�
Bureau of Local Systems Dubuque
11/22/2024 8:17:43 AM
Ames, IA 50010
Bonds/Loans
Bond/Loan Principal Total Total Principal Interest Principal
Balance Principal Interest Balance
Description As of 7/1 Paid Paid Roads Roads As of 6/30
2017A-Streets Only $340,484 $56,000 $11,487 $56,000 $11,487 $284,484
2018A-Streets Only $567,617 $66,499 $17,029 $66,499 $17,029 $501,118
2021A-Streets Only $1,478,825 $124,968 $38,689 $124,968 $38,689 $1,353,857
Total $2,386,926 $247,467 $67,205 $247,467 $67,205 $2,139,459
Page 5 of 13
Page 135 of 645
�JILJIINMDOT City Street Finance Report FiscalYear2024
�
Bureau of Local Systems Dubuque
11/22/2024 8:17:43 AM
Ames, IA 50010
Equipment
Description Model Year Usage Type Cost Purchased Status
Chevrolet Pickup Truck 2012 Purchased $29,328 Sold
John Deere Gator 2019 Purchased $7,532 No Change
Freightliner Single Axle Dump Truck 2016 Purchased $124,039 No Change
John Deere 410L 2020 Purchased $72,500 No Change
International 7400 w/combo box 2013 Purchased $106,699 Traded
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
Ver-mac Sign Board 2019 Purchased $13,150 No Change
Freightliner Bucket Truck 2009 Purchased $137,049 Traded
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
John Deere Backhoe/Loader 2010 Purchased $82,318 No Change
H&H Trailer GT20 2014 Purchased $6,175 No Change
WACKER NEUSON VP1340 -VIBRATOR PLATE 2008 Purchased $1,750 No Change
Dynapac Vibratory Asphalt Roller 2019 Purchased $23,390 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
Huszvarna 30" Pavement Saw 2009 Purchased $21,970 No Change
Page 6 of 13
Page 136 of 645
�JILJIINMDOT City Street Finance Report FiscalYear2024
�
Bureau of Local Systems Dubuque
11/22/2024 8:17:43 AM
Ames, IA 50010
Description Model Year Usage Type Cost Purchased Status
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
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
Page 7 of 13
Page 137 of 645
�JILJIINMDOT City Street Finance Report FiscalYear2024
�
Bureau of Local Systems Dubuque
11/22/2024 8:17:43 AM
Ames, IA 50010
Description Model Year Usage Type Cost Purchased Status
Silverado 4WD 12,000 GVW Dump w/snow Equpment 2013 Purchased $58,695 No Change
Ford F350 2017 Purchased $58,757 No Change
Freightliner Dump Truck 2017 Purchased $166,764 No Change
H10252 Plate Compactor 2023 Purchased $10,592 No Change
cobra curber including dump bucket 2022 Purchased $18,955 No Change
B&B Tilt Trailer 2023 Purchased $11,090 No Change
John Deere Lawn Tractor 2016 Purchased $27,100 No Change
John Deere 85G Backhoe Loader 2023 Purchased $129,500 No Change
Vacuum Sweeper 2023 Purchased $302,093 No Change
Cimline Crack Sealer Unit 2022 Purchased $48,095 No Change
3250 - Endloader Grapple Bucket 2023 Purchased $24,300 No Change
Caterpillar Asphalt Roller 2010 Purchased $48,575 No Change
3500 HD Dodge Ram 2019 Purchased $28,500 No Change
Jet Flusher Truck/ Pipe Cleaner 2014 Purchased $207,490 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 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
Page 8 of 13
Page 138 of 645
'JI�J Y NM DOT City Street Finance Report Fiscal Year 2024
�
Bureau of Local Systems Dubuque
11/22/2024 8:17:43 AM
Ames, IA 50010
Description Model Year Usage Type Cost Purchased Status
International 7400 w/loadal 2013 Purchased $131,251 Traded
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 No Change
Honda 3"Trash Pump 2003 Purchased $1,197 No Change
Freightliner 108 SD 2020 Purchased $141,470 No Change
Cimline Crack Saw 1990 Purchased $2,381 No Change
John Deere endloader 624K 2009 Purchased $129,292 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
Ingersoll Rand Roller 2002 Purchased $5,356 No Change
John Deere 85G Excavator 2018 Purchased $125,900 No Change
John Deere Wheel Loader 2000 Purchased $118,750 No Change
John Deere 6247 Endloader 2007 Purchased $136,108 No Change
John Deere Wheel Loader 624K 2015 Purchased $214,000 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
Page 9 of 13
Page 139 of 645
�JILJIINMDOT City Street Finance Report FiscalYear2024
�
Bureau of Local Systems Dubuque
11/22/2024 8:17:43 AM
Ames, IA 50010
Description Model Year Usage Type Cost Purchased Status
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 Traded
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
Chevrolet 4WD 12,000 GVW Dump 2013 Purchased $58,695 No Change
Freightliner 213,500 GVW 2017 Purchased $90,634 No Change
International HV607 SBA w/Vactor 2020 Purchased $344,080 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
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
Page 10 of 13
Page 140 of 645
'JI�J Y NM DOT City Street Finance Report Fiscal Year 2024
�
Bureau of Local Systems Dubuque
11/22/2024 8:17:43 AM
Ames, IA 50010
Description Model Year Usage Type Cost Purchased Status
Ford F550 4WD 2020 Purchased $59,765 No Change
Street Sweeper 2023 Purchased $569,217 New
DumpTruck 2023 Purchased $199,654 New
DumpTruck 2023 Purchased $199,654 New
Utility Compactor 2023 Purchased $62,062 New
Page 11 of 13
Page 141 of 645
�JILJIINMDOT City Street Finance Report FiscalYear2024
�
Bureau of Local Systems Dubuque
11/22/2024 8:17:43 AM
Ames, IA 50010
Street Projects
Project Description Contract Price Final Price Contractor Name
US 20 to JFK $8,541,862 $8,595,420 Pirc-Tobin
Page 12 of 13
Page 142 of 645
�JILJIINMDOT City Street Finance Report FiscalYear2024
�
Bureau of Local Systems Dubuque
11/22/2024 8:17:43 AM
Ames, IA 50010
Summary
General Road Other Debt Capitial
Fund Use Special Service Projects Utilities Grand
Streets (110) Revenues (200) (300) (600 & UO) Total
(001)
Begining Balance $0 $8,167,586 $0 $4,874 $5,323,892 $0 $13,496,352
SubTotal Expenses (-) $1,981,156 $8,328,305 $314,672 $7,184,708 $76,160 $17,885,001
Transfers Out (-) $631,841 $21,639 $229,421 $15,903 $898,804
Subtotal Revenues (+) $1,981,156 $8,648,342 $21,639 $0 $5,344,902 $92,063 $16,088,102
Transfers In (+) $19,291 $314,672 $472,748 $92,093 $898,804
Ending Balance $0 $7,875,073 $0 $4,874 $3,727,413 $92,093 $11,699,453
Resolution Number:
Execution Date: Monday, December 2, 2024
Signature: Brian DeMoss
Page 13 of 13
Page 143 of 645