Fiscal Year 2021 City Street Financing ReportCity of Dubuque
City Council Meeting
Consent Items # 5.
Copyrighted
October 4, 2021
ITEM TITLE: Fiscal Year 2021 City Street Financing Report
SUMMARY: City Manager recommending approval of the City of Dubuque's Fiscal
Year 2021 City Street Financing Report and authorize filing with the Iowa
Department of Transportation.
RESOLUTION Approving the City of Dubuque Fiscal Year 2021 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
FY21 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 2021 City Street Financing Report.
DATE: September 27, 2021
Dubuque
All -America City
WL%hl atik: t -K)y
1III�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 2021 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.
/ 4� kit
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
DUB E
All -America Cily
µ x LL,k ,
II
iece on the Mississippi
Masterpiece pp
20°'`Z°l 2-2013
zoi7*2019oi9
TO: Mike Van Milligen, City Manager
FROM: Jennifer Larson, Director of Finance and Budget
SUBJECT: Fiscal Year 2021 City Street Financing Report.
DATE: September 27, 2021
INTRODUCTION
The purpose of this memorandum is to request that the City Council adopt a resolution
approving the City of Dubuque's Fiscal Year 2021 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,
2021. 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
Cassie Ross, Assistant Director of Finance
Prepared by Jennifer Larson Director of Finance and Budget 50 W. 1311 St Dubuque IA 52001 (563) 589-4322
Return to Adrienne N. Breitfelder, City Clerk, 50 W. 1311 St., Dubuque, IA 52001, (563) 589-4100
RESOLUTION NO. 330-21
APPROVING THE CITY OF DUBUQUE FISCAL YEAR 2021 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, 2020, to June
30, 2021, 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 4th day of October 2021.
R D. Buol, Mayor
Attest:
Adrienne N. Breitfelder, City Clerk
6010WADOT City Street Finance Report Fiscal Year 2021
Bureau of Local Systems
Ames, IA 50010
Expenses
Dubuque
9/8/2021 9:27:16 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
$364,850
$1,081,415
$329,708
$1,775,973
Benefits - Roads/Streets
$147,253
$374,025
$115,611
$636,889
Training & Dues
$4,549
$6,008
$10,557
Building & Grounds Maint.
& Repair
$91,078
$91,078
Road Beautification
$859,719
$103,529
$963,248
Vehicle & Office Equip
Operation and Repair
$12,115
$90,339
$102,454
Operational Equipment
Repair
$445
$114,949
$5,616
$121,010
Other Utilities
$3,758
$4,527
$8,285
Other Maintenance and
Repair
$220
$25,318
$1,951
$27,489
Engineering
$900
$65,597
$66,497
Insurance
$4,085
$145,483
$149,568
Janitorial
$5,632
$5,632
Legal
$27
$27
Printing
$1,549
$956
$2,505
Rents & Leases
$966
$10,135
$11,101
Street Maintenance
Expense
$40
$40
Page 1 of 13
GOIGWADOT City Street Finance Report Fiscal Year 2021
Bureau of Local Systems
Ames, IA 50010
Dubuque
9/8/2021 9:27:16 AM
7Soervices
General
Fund
Streets
(001)
Road
Use
(110)
Other
Special
Revenues
Debt
Service
(200)
Capitial
Projects
(300)
Utilities
(600 & UO)
Grand
Total
fessional
$11,423
$79,806
$8,855
$100,084
Other Contract Services
$18,115
$9,951
$28,066
Minor Equipment
Purchases
$15,628
$5,729
$21,357
Other Equipment
$66,297
$66,297
Office Supplies
$2,328
$114
$2,442
Operating Supplies
$964
$158,259
$1,433
$160,656
Postage & Safety
$410
$10,630
$398
$11,438
New Posts & Signs
$4,335
$4,335
Other Supplies
$8,755
$8,755
Vehicles
$214,234
$182,930
$397,164
Office Equipment
$260
$260
Other Capital Equipment
$27,815
$102,267
$130,082
Right -of -Way
$16,371
$16,371
Bridges & Culverts
$4,559
$4,559
Street - New Roadway
$231,780
$231,780
Street - Capacity
Improvement
$2,835
$2,835
Street - Preservation
$1,924,816
$1,924,816
Street - Safety/
Environment
$243,752
$243,752
Other Capital Outlay
$6,218
$145,737
$151,955
Page 2 of 13
6010WADOT City Street Finance Report Fiscal Year 2021
Bureau of Local Systems
Ames, IA 50010
Dubuque
9/8/2021 9:27:16 AM
General
Fund
Road
Other
Debt
Capitial
Utilities
Grand
r7!
Streets
Use
Special
Service
Projects
(600 & UO)
Total
(001)
(110)
Revenues
(200)
(300)
Principal Payment
$4,548,916
$4,548,916
Interest Payment
$147,716
$147,716
Transfer Out
$112,367
$44,173
$284,944
$441,484
Street Lighting
$743,514
$17,061
$760,575
Traffic Control/Safety
$1,002,878
$128,294
$176,052
$1,307,224
Snow Removal
$1,471,432
$1,471,432
Depreciation & Building
$74,882
$74,882
Utilities
Street Cleaning
$535,307
$535,307
Total $1,558,993 $6,485,613 $44,173 $4,696,632 $3,981,482
Page 3 of 13
$16,766,893
6010WADOT City Street Finance Report Fiscal Year 2021
Bureau of Local Systems
Ames, IA 50010
Revenue
Dubuque
9/8/2021 9:27:16 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
$1,184,969
$0
$4,351,605
$5,536,574
Other Taxes (Hotel, LOST)
$3,375,087
$3,375,087
Interest
$496
$41,892
$42,388
Rents & Leases
$19,440
$19,440
Federal Grants
$196,141
$196,141
State Revenues - Road
Use Taxes
$8,626,083
$8,626,083
Other State Grants - IDOT
$1,727,628
$1,727,628
Charges/fees
$0
$0
Assessments
$109,025
$109,025
Contributions
$321,740
$6,049,843
$6,371,583
Sale of Assests
$41,000
$41,000
Proceeds from Debt
$1,314,468
$1,314,468
Transfer In
$52,284
$345,027
$44,173
$441,484
Total $1,558,993 $8,667,083 $109,521 $4,696,632 $12,768,672
Page 4 of 13
$0 $27,800,901
GOIGWADOT City Street Finance Report Fiscal Year 2021
Bureau of Local Systems
Ames, IA 50010
Bonds/Loans
Dubuque
9/8/2021 9:27:16 AM
Bond/Loan
Principal
Total
Total
Principal
Interest
Principal
Description
Balance
Principal
Interest
Roads
Roads
Balance
As of 7/1
Paid
Paid
As of 6/30
2018A
$4,300,000
$340,000
$122,150
$52,996
$19,040
$3,960,000
2017A
$4,925,000
$1,275,000
$147,750
$98,383
$11,401
$3,650,000
2012E
$2,190,000
$2,190,000
$55,723
$771,537
$19,631
$0
2012B
$4,900,000
$4,900,000
$131,952
$3,626,000
$97,644
$0
2021A
$27,995,000
$0
$0
$0
$0
$27,995,000
Page 5 of 13
QOJUWADOT City Street Finance Report Fiscal Year 2021
Bureau of Local Systems
Ames, IA 50010
Equipment
Dubuque
9/8/2021 9:27:16 AM
n
Model Year
Usage Type
Cost
Reversible Plate Compactor
2016
Purchased
$7,600
No Change
Freightliner Dump Truck
2017
Purchased
$166,764
No Change
Freightliner Dump Truck
2017
Purchased
$166,558
No Change
International 7400 w/combo box
2013
Purchased
$106,699
No Change
Freightliner Single Axle Dump Truck
2016
Purchased
$124,039
No Change
International Tandem Dump Truck
2012
Purchased
$110,675
Traded
John Deere endloader 624K
2009
Purchased
$129,292
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
No Change
Huszvarna 30" Pavement Saw
2009
Purchased
$21,970
No Change
Ingersoll Rand Roller
2002
Purchased
$5,356
No Change
John Deere 323E Skid -Steer
2014
Purchased
$63,327
No Change
Honda Generator
1993
Purchased
$1,360
No Change
Morrison Speed Screed
2018
Purchased
$8,991
No Change
Ver-mac Sign Board
2019
Purchased
$13,150
No Change
B&B Trailer
2017
Purchased
$8,050
No Change
B&B Trailer
2017
Purchased
$6,400
No Change
Page 6 of 13
QOJOWADOT City Street Finance Report Fiscal Year 2021
Bureau of Local Systems
Ames, IA 50010
Dubuque
9/8/2021 9:27:16 AM
rr
Model Year
Cost
Catepiller
2008
Purchased
$277,632
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
Elgin Whirlwind Sweeper
2010
Purchased
$177,010
No Change
John Deere Lawn Tractor X758
2017
Purchased
$10,850
No Change
Sewer Easement Machine
2009
Purchased
$38,783
No Change
JD Skid loader
2019
Purchased
$63,650
No Change
John Deere 625i Gator
2014
Purchased
$10,671
No Change
Honda 3" Trash Pump
2003
Purchased
$1,197
No Change
John Deere 85G Excavator
2018
Purchased
$125,900
No Change
Freightliner 108 SD
2020
Purchased
$141,470
No Change
John Deere 410L
2020
Purchased
$72,500
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
Page 7 of 13
QOJOWADOT City Street Finance Report Fiscal Year 2021
Bureau of Local Systems
Ames, IA 50010
Dubuque
9/8/2021 9:27:16 AM
Description
Model Year
Usage Type
Cost
Purchased Status
Freightliner Bucket Truck
2009
Purchased
$137,049
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
International HV607EX type Distributor
2020
Purchased
$154,707
No Change
Freightliner Dump Truck
2017
Purchased
$166,764
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
International HV607 SBA w/ Vactor
2020
Purchased
$344,080
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,9311
No Change
Ford F550 4WD
2020
Purchased
$59,765
No Change
Page 8 of 13
Q010WADOT City Street Finance Report Fiscal Year 2021
Bureau of Local Systems
Ames, IA 50010
Dubuque
9/8/2021 9:27:16 AM
International Tandem Dump Truck
Model Year
2012
Purchased
Cost
$110,675
Traded
John Deere Wheel Loader 624K
2015
Purchased
$214,000
No Change
Freightliner 213,500 GVW
2017
Purchased
$90,634
No Change
Sullivan Air Compressor
2015
Purchased
$14,097
No Change
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
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
Cimline Crack Saw
1990
Purchased
$2,381
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
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
New
FIVE D INDUSTRIES HOT PATCH BE - HOT PATCH BOX
2020
Purchased
$200,005
New
Page 9 of 13
Q010WADOT City Street Finance Report Fiscal Year 2021
Bureau of Local Systems
Ames, IA 50010
Dubuque
9/8/2021 9:27:16 AM
Description
Model Year
Usage Type
Cost
Purchased Status
H & H TRAILER UT20 - Trailer
2015
Purchased
$4,978
No Change
HOMEL HOMELITE - TRASH PUMP 3 IN
1996
Purchased
$1,179
No Change
Honda - TRASH PUMP 3 IN
2014
Purchased
$1,179
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
New
INTERNATIONAL HV607 SBA
2020
Purchased
$190,773
New
INTERNATIONAL HV607 SBA
2020
Purchased
$164,773
New
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
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
New
WACKER NEUSON VP 1340AW - VIBROPLATE
2016
Purchased
$1,750
No Change
Page 10 of 13
GOIGWADOT City Street Finance Report Fiscal Year 2021
Bureau of Local Systems
Ames, IA 50010
Dubuque
9/8/2021 9:27:16 AM
Description
Model Year
Usage Type
Cost
Purchased Status
WACKER NEUSON VP1340 - VIBRATOR PLATE
2008
Purchased
$1,750
No Change
Page 11 of 13
GOIGWADOT
Bureau of Local Systems
Ames, IA 50010
City Street Finance Report
Street Projects
Page 12 of 13
Fiscal Year 2021
Dubuque
9/8/2021 9:27:16 AM
6010WADOT City Street Finance Report Fiscal Year 2021
Bureau of Local Systems
Ames, IA 50010
Summary
Dubuque
9/8/2021 9:27:16 AM
General
Fund
Road
Other
Debt
Capitial
Utilities
Grand
Streets
Use
Special
Service
Projects
(600 & UO)
Total
(001)
(110)
Revenues
(200)
(300)
Begining Balance
($1,038,721)
$4,701,915
($18,807)
$0
($909,974)
$0
$2,734,413
SubTotal Expenses (-)
$1,558,993
$6,373,246
$4,696,632
$3,696,538
$16,325,409
Transfers Out (-)
$112,367
$44,173
$284,944
$441,484
Subtotal Revenues (+)
$1,506,709
$8,667,083
$109,521
$4,351,605
$12,724,499
$0
$27,359,417
Transfers In (+)
$52,284
$345,027
$44,173
$441,484
Ending Balance
($1,038,721)
$6,883,385
$46,541
$0
$7,877,216
$0
$13,768,421
Resolution Number:
Execution Date: Monday, September 20, 2021
Signature: Cassie Ross
Page 13 of 13