Public Works Fiscal Year 2024 Budget PresentationCopyrighted
March 21, 2023
City of Dubuque
Special Meeting P UBLIC HE ARINGS # 04.
IT E M T I T L E:Public Works F iscal Year 2024 Budget P resentation
S UM M ARY:
S UG G E S T E D
D I S P O S I T I O N:
AT TAC H ME N TS:
Description Type
Policy Budget Book Updated Supporting Documentation
Presentation_Uploaded 3.21.23 Supporting Documentation
Utilities and A C P Program Flyer Supporting Documentation
Public Works
-67-
This page intentionally left blank.
-68-
PUBLIC WORKS DEPARTMENT
Budget Highlights
FY 2022
Actual
FY 2023
Budget
FY 2024
Requested % Change From FY
2023 Budget
Expenses
Employee Expense 7,649,666 8,752,327 9,161,407 4.7 %
Supplies and Services 8,209,984 8,489,534 8,796,385 3.6 %
Machinery and Equipment 601,081 1,024,381 810,236 (20.9) %
Subtotal 16,460,731 18,266,242 18,768,028 2.7 %
Public Works Administrative / Garage Stores 1,094,094 966,357 1,015,632 5.1 %
Administrative Overhead Recharge 1,659,457 1,783,326 2,358,186 32.2 %
Less Recharges/Service Fund Charges (2,384,428) (2,235,603) (2,506,355) 12.1 %
Total Expenses 16,829,854 18,780,322 19,635,491 4.6 %
Resources
Operating Revenue 66,604 48,123 49,922 3.7 %
Salt Operations Fund 101,627 113,562 105,308 (7.3) %
Road Use Tax Fund 6,118,260 7,126,098 6,959,022 (2.3) %
Sewer Utility Operating Fund 752,273 714,116 729,701 2.2 %
Stormwater User Fund 230,710 286,307 298,467 4.2 %
Refuse Collection Fund 4,427,951 5,140,013 5,653,019 10.0 %
Landfill Operating Fund 4,242,448 4,165,363 4,657,084 11.8 %
Total Resources 15,939,873 17,593,582 18,452,523 4.9 %
Debt Service abated with Sales Tax 30% 126,526 83,650 83,897 0.3 %
Debt Service abated with Landfill Fees 660,609 660,459 663,609 0.5 %
Debt Service abated with Solid Waste Fees 7,563 8,904 7,843 (11.9) %
Total Non-Property Tax Debt Service 794,698 753,013 755,349 0.3 %
Property Tax Support 889,981 1,186,740 1,182,968 (3,772)
Percent Increase (Decrease) (0.3) %
Personnel - Authorized FTE 93.28 93.43 95.73
-69-
Solid Waste Collection Fund Summary
FY 2022
Actual
FY 2023
Budget
FY 2024
Requested % Change From
FY 2023 Budget
Administrative Overhead Recharges/Utility Billing 1,219,202 1,305,346 1,508,564 15.6 %
Refuse Operations 3,208,749 3,834,667 3,819,455 (0.4) %
Debt Service - Refuse 7,563 8,904 7,843 (11.9) %
Payment to Depreciation 325,000 550,000 325,000 (40.9) %
Total Requirements 4,760,514 5,698,917 5,660,862 (0.7) %
Refuse Fees (Incl tipper carts/other) 4,228,165 4,581,085 4,805,152 4.9 %
UBP Single Use Refuse Sticker 118,831 122,875 236,279 92.3 %
Sales Tax Collection 7,256 7,220 7,833 8.5 %
Yard Waste Stickers & Ties 109,720 131,459 109,720 (16.5) %
Leaf Rake Out Fees 7,246 7,205 7,246 0.6 %
Food Scrap 9,532 9,131 9,532 4.4 %
Recyclable Sales 124,687 96,000 10,941 (88.6) %
Subscription Recycling 6,495 6,543 6,495 (0.7) %
Large Item Pickup 76,625 78,408 82,638 5.4 %
Miscellaneous Revenue 81,334 25,362 64,573 154.6 %
General Fund - Tipper Carts — 582,698 291,349 (50.0) %
General Fund - 50% Rate Reduction 43,333 43,000 45,000 4.7 %
Total Resources 4,813,224 5,690,986 5,676,758 (0.3) %
Annual Operating Surplus (Deficit) 52,710 (7,931) 15,896 23,827
Personnel - Authorized FTE 20.75 20.74 20.96
Solid Waste User Fee Rate Increase 2.60 % — % 2.90 %
Solid Waste User Fee $ 15.38 $ 15.38 $ 15.83
Revenue 1% Rate Increase Generates $ 30,150
Salt Operations Fund Summary
FY 2022
Actual
FY 2023
Budget
FY 2024
Requested % Change From
FY 2023 Budget
Salt Purchase 86,346 96,750 87,900 (9.1) %
Salt Handling Fees 7,893 9,240 8,313 (10.0) %
Miscellaneous Fees 1,756 1,634 1,756 7.5 %
Administrative Overhead 5,632 5,938 7,339 23.6 %
Property Maintenance — — — — %
Total Requirements 101,627 113,562 105,308 (7.3) %
Salt Sales 100,763 97,665 87,900 (10.0) %
Salt Storage Fees — 6,000 7,388 23.1 %
Salt Handling Fees — 9,240 8,313 (10.0) %
Total Resources 100,763 112,905 103,601 (8.2) %
Annual Operating Surplus (Deficit) (864) (657) (1,707) (1,050)
-70-
Improvement Package Summary
Public Works
1 of 9
This improvement level decision package provides funds for a 1.0 FTE Data Scientist at GE-37. As the
Public Works Department implements our strategic plan in accordance with the APWA Accreditation
process, the data scientist would pull comprehensive data necessary to show how Public Works is
performing in all areas and how that performance measures up to council goals and objectives, climate
action plan, and equity and poverty prevention plan.This position would assist Budget and Finance
Department to find trends in revenue and expenses for future potential savings.
Data Scientists are analytical data experts who take on many of the same responsibilities as analysts, but
they’re also responsible for building complex machine learning models and working with algorithms to
make accurate predictions based on collected data—ultimately making decision makers’ jobs a little
easier. Data scientists discover patterns and trends in datasets to get insight, create forecasting
algorithms and data models, and improve the quality of data or product offerings by utilizing machine
learning techniques. Contrasting data positions:
Data Engineer: Gathering data, compiling databases
Data Analyst: Utilizing existing data to pulling insights
Data Scientist: Gathers data, pulls insights, and utilizes predictive modeling and machine learning
To consider the impacts of year one in Public Works, we use a Monte Carlo Simulation for one specific
scenario to demonstrate recurring savings. Monte Carlo Simulations assess the impact of risk in various
scenarios that are very unclear. Which makes it the perfect tool in this case. For this demonstration, we
analyzed fleet maintenance inventory. Fleet Maintenance inventory is an area that effects almost every
department, and any savings, or indirect reallocation of funding, would be realized organization wide.
According to American Transportation Research Institute's report, year-over-year fuel cost per mile
increased by over 35% during 2022. The CPI of fleet maintenance and repair has increased 16.26% since
pre-covid, with 8.24% increase in 2022 over 2021. These increases in cost demonstrate a need to review
ways to show savings.
For our simulation, we will need to lay out the investment in the position, the forecasted return on
investment, standard deviations, and the number of simulations to run.
Forecast Revenue = garage stores savings1 (1,093,657*41%)
FR Standard Deviation = garage stores savings variation (1,093,657*30%)
Variable Expense = software & licensing needed (estimated 15,000)
VE Standard Deviation = software & licensing variation (estimated 10,000)
Fixed Expense = data scientist salary (estimated 120,000)
Number of Simulations = 1,000
1The savings of 41% in inventory/stores is derived from a Faber Infinite Consulting results after utilizing
data science to improve inventory management costs with a client whose baseline inventory is similar in
size to Public Works Fleet Division. We utilized FY2022 actual expense for baseline garage stores.
After running the Monte Carlo Simulation, we see a likelihood of profit equates to 83.4% and the likelihood
of losing money is 16.5%.
-71-
Once the position starts, this simulation is estimated to take 9 months to implement fully. The remaining 3
months would be utilized by the Chief Finance Officer to aid in organization wide data from the Enterprise
Resource Planning system, Tyler Technologies, to find patterns/trends in expense and revenue data.
These trends would identify areas for potential additional savings.
After year one, the Public Works Data Scientist would assist by addressing gaps in operations. The
following are just a few:
1.Sewer Maintenance related to consent decree compliance. All lines should be inspected within a 6-
year window.
2.Inventory Management for GAAP compliance. This would include utilizing and implementing a
machine learning model.
3.Building APIs from current softwares into PowerBI, or WDesk for sole data sourcing.
4.Researching RFIDs for cart management system capabilities and potentially moving to weight-
based fee structure to include a weight- vs volume-based structure.
5.Deep dive into organization wide fleet replacement vs repair costs.
6.Vehicle/Equipment pool feasibility/utilization research.
7.Professional development department wide – currently no capacity to undergo due to Assistant
Director trying to fill data needs.
8.Staff evaluations and on-going feedback does not currently exist. For a formal feedback system
even once a year, the Director and Assistant Director would need to schedule 2 individual reviews
a week. formally – currently no capacity to undergo due to Assistant Director trying to fill data
needs.
9.Official Service Feedback Program: Surveys or other means to have a resident measurement on
services provided.
10.Fully integrated work order system to measure performance within core areas.
11.Route Optimizations ($126,000 estimated per core area to outsource)
12.Salt Operations spoilage rate analysis (no current system to measure)
13.Asset Management utilization and improvements. Certain aspects cannot be created by
Cartegraph through consultant work (task, inspection, and activity level).
14.Climate Action Plan implementation. Energy utilization rates for buildings pump houses utilized by
Public Works. This would include analyzing EV setups, future analysis on EV expansion in fleet,
and battery for solar panels.
15.Diversion research analyzing and running predictive models prior to implementation to ensure the
best information is provided to make decisions.
16.Employee onboarding – currently no capacity to undergo due to Assistant Director trying to fill data
needs.
17.Assist with geospatial needs within Public Works for transparency with residents.
While Public Works has plenty of data, it is not clean, structured, complete, nor combined. This leaves us
with a lot of data that is unusable due to limitations in time.
This position would be budgeted to general fund but would be completely offset by being recharged
through the Administration Overhead Rate to various funds within Public Works and a reallocation of
funding from consultation services from Budget and Finance Department. In future years, the Data
Scientist may assist the Police Department and Housing & Community Development Department with
various projects and costs would be shared, as needed. This request supports the city council goal of
fiscally responsible and high performing organization.
-72-
Related Cost:$ 107,525 Tax Funds Recurring Recommend - Yes
Related Cost:$ 4,500 Tax Funds Non-Recurring
Related Recharge:$ 63,025 Garage Service Fund Recurring
Related Recharge:$ 14,500 Solid Waste Funds Recurring
Related Recharge:$ 7,500 Road Use Tax Recurring
Related Recharge:$ 12,500 Landfill Recurring
Related Recharge:$ 10,000 Tax Funds Recurring
Related Recharge:$ (107,525) Tax Funds Recurring
Related Savings:$ (78,025) Garage Service Fund Recurring
Related Savings:$ (14,500) Solid Waste Funds Recurring
Related Savings:$ (10,000) Tax Funds Recurring
Net Cost:$ (15,000) Garage Service Fund
Net Cost:$ 7,500 Road Use Tax
Net Cost:$ 12,500 Landfill
Net Cost:$ 4,500 Tax Funds
Net Cost:$ — Solid Waste Funds
Total:$ 9,500
Property Tax Impact:$ 0.0018 0.02%
Activity: Various
2 of 9
This decision package provides funds for a safe driving class including the use of driver simulation training
for Public Works staff assigned to the collection of solid waste materials. The training would be focused on
driving solid waste trucks and the hazards a driver may encounter on a regular basis. This training is for
both experienced and new employees and will improve driver safety and reduce risks associated with the
collection of solid waste. This type of training was first introduced to the Public Works staff assigned to
snow and ice control in 2022. This funding request would expand the use of this type of training to staff
assigned to the collection of solid waste. This project meets the council goal of Financially Responsible,
High-Performance City Organization: Sustainable, Equitable, and Effective Service Delivery
Related Cost:$ 30,000 Solid Waste Funds Recurring Recommend - No
Property Tax Impact:$ 0.0118 0.12%
Solid Waste User Fee Impact 1.00 %
Activity: Solid Waste
3 of 9
This improvement level decision package provides funds to complete a fleet maintenance staffing study
for the vehicle maintenance activity. The fleet maintenance activity is responsible for the maintenance of
all the city vehicles and equipment except for those assigned to the Airport and Park Division. Due to the
increased areas of responsibilities and new technology the vehicle and maintenance fleet has increased
over the years while the number of mechanics has stayed the same. This study would identify the correct
number of mechanics needed to maintain a fleet that includes cars, busses, fire trucks, police cars, light,
medium, and heavy-duty trucks, snowplow equipment and other various light and heavy-duty construction
equipment. It will also take into consideration what the addition of Electric Vehicles will have on the fleet
maintenance activity. The study would identify the size and type of the fleet being maintained and then
index the maintenance and repair needed for each type of class based on national averages. The age of
the fleet and the percentage of repairs done in-house also factor into the equation. Funding this
improvement request would provide data to properly identify the correct number of vehicle maintenance
technicians needed to maintain our growing and changing vehicle and equipment fleet. This project meets
-73-
the council goal of Financially Responsible, High-Performance City Organization: Sustainable, Equitable,
and Effective Service Delivery.
Related Cost:$ 30,000 Garage Fund Non-Recurring Recommend - Yes
Total Cost $ 30,000
Activity: Garage
4 of 9
This improvement level decision package provides funds to send two (2) administrative staff to one
national conference each year for training. The conference may include, but would not be limited to ESRI
Conference, Laserfiche Conference, Rubicon User Conference, Recollect User Conference, or Cartegraph
Conference. These types of conferences provide professional development related to best practices and
process improvements to maximize the utilization of current software’s within Public Works' current
operations. This request supports the city council goal of fiscally responsible and high performing
organization.
.
Related Cost:$ 9,000 Tax Funds Recurring Recommend - No
Net Cost:$ 9,000
Property Tax Impact:$ 0.0035 0.04%
Activity: Administration
5 of 9
This improvement level decision package request provides funds for the purchase of five (5) additional
tablets and cases which would allow field staff to enter their time on a device. This request is related to
the Tyler Implementation plan to have each employee enter their time directly into the Tyler system each
day. This will provide one shared tablet for each of the five(5) core areas in Public Works. This request
supports the city council goal of fiscally responsible and high performing organization.
Related Cost:$ 4,600 Tax Funds Non-Recurring Recommend - Yes
Total Cost $ 4,600
Property Tax Impact:$ 0.0018 0.02%
Activity: Street Maintenance
6 of 9
This improvement level decision package requests funds to add a part-time intern position in the Public
Works Department’s solid waste activity. If funded, the curbside collection intern would play a crucial role
in supporting the Resource Management Supervisor and the curbside collection crew in waste
minimization and keeping the City clean. This intern will play an essential role in reducing the City's
curbside collection program’s impact on the climate through daily community engagement with curbside
collection customers. The intern will help to ensure equitable community engagement and assist in the
City’s goal to reduce landfill waste by one percent per capita each year. While traditional forms of
education like flyers, social media posts, and collection notices can help inform customers, often there is a
need for personalized interaction to change behaviors. With the demands of the daily operation, often the
current curbside collection staff doesn't have the means to perform the necessary outreach that'll shape
best curbside collection practices. Funding this position will greatly enhance our curbside collection team
by providing another way to provide the necessary information to our customers to keep our city clean.
This project meets the council goal of Financially Responsible, High-Performance City Organization:
Sustainable, Equitable, and Effective Service Delivery
Related Cost:$ 13,568 Solid Waste Funds Recurring Recommend - Yes
Property Tax Impact:$ 0.0053 0.05%
-74-
Solid Waste User Fee Impact 0.45 %
Activity: Solid Waste
7 of 9
This improvement level decision package provides funds for the purchase of additional 96-gallon recycling
carts to meet the demand of customers who prefer a more convenient way to manage their recycling.
Since 2017 when the 96-gallon cart was first made available, the demand for these carts has increased
each year. This has resulted in many customers being placed on a waiting list for up to 6 months before
we are able to deliver their requested recycling cart due to low inventory. Having more carts in service will
also support the City's effort to reduce the need for staff to manually empty bins into their truck and
increase recycling tonnage as identified in a recent recycling material sort. In August of 2022, a recycling
material sort was completed by Public Works staff. Customers included in the sort using 96-gallon carts
recycled close to 300% more materials in weight than customers who use yellow recycling bins. This
project meets the council goal of Financially Responsible, High-Performance City Organization:
Sustainable, Equitable, and Effective Service Delivery.
Related Cost:$ 30,000 Solid Waste Fund Non-Recurring Recommend - Yes
Solid Waste User Fee Impact 1.00 %
Activity: Solid Waste
8 of 9
This improvement level decision package requests funds for the installation of an additional air
conditioning unit to serve the traffic signal maintenance shop. The Municipal Services Center was
designed to provide air conditioning to the sign and traffic signal shops. Over the past few years traffic
signal and camera servers have been installed in self-contained air-conditioned cabinets. During the
hottest days of the summer, the server cabinets have a hard time cooling the server units. An additional air
conditioning unit for the traffic signal shop would allow the current server cabinets to operate as designed
and also allow for future server expansion if needed. This project meets the council goal of Financially
Responsible, High-Performance City Organization: Sustainable, Equitable, and Effective Service Delivery
Related Cost:$ 9,000 Tax Funds Non-Recurring Recommend - Yes
Property Tax Impact:$ 0.0035 0.04%
Activity: Street Maintenance
9 of 9
This improvement level decision package request is for the purchase road pavement sensors and
software that would provide information on pavement conditions prior to a winter storm. Currently the only
Remote Weather Information System (RWIS) in our area is located on HWY 20 near the Catfish Bridge
and owned and maintained by the IDOT. Due to the Dubuque’s terrain, there are several areas where
pavement act differently then what is out on HWY 20. Until recently, building out an RWIS system was
very costly and limited to Department of Transportation roadways. New technology has been developed so
pavement sensors can be installed by Public Works staff which would help predict road surface freezing
and monitor the amount of residual treatment on the pavements. Data information would be made
available to all snow and ice control staff through a mobile app. This data will be used to determine when
operations should be started. This project would allow for the installation of 5 sensors which would be
located throughout the city to collect this data. The information collected from these sensors will allow us
to continue to improve our snow and ice control program. This project meets the council goal of
Financially Responsible, High-Performance City Organization: Sustainable, Equitable, and Effective
Service Delivery.
-75-
Related Cost:$ 7,000 Road Use Tax Recurring Recommend - Yes
Property Tax Impact:$ 0.0028 0.03%
Activity: Snow and Ice Control
Landfill
1 of 8
This improvement package is to replace portable litter fencing which has reached the end of it's service life
and provide additional portable units to be used near the open face area at the landfill. Containing litter
within the working are is the most effective way to manage litter caused by lightweight plastic materials,
such as bags and films, which often come in loose loads to the facility.
Related Cost:$ 85,000 Landfill Fund Recurring Recommend - Yes
Net Cost:$ 85,000
Activity: Landfill
2 of 8
This improvement package would provide a portable radio for use by the Solid Waste Agency
Administrator. The radio would allow for group communication during operational and emergency events,
such as a landfill fire. During these events, communication is critical.
Related Cost:$ 4,263 Landfill Fund Non-Recurring Recommend - Yes
Related Cost:$ 300 Landfill Fund Recurring
Total Cost:$ 4,563
Activity: Landfill
3 of 8
This improvement package would allow for the Landfill Facility Supervisor to attend one of the two Solid
Waste Association of North America (SWANA) National Conferences each year. The SWANA conferences
provide educational and networking opportunities, which benefit the operational aspects of the facility.
Related Cost:$ 3,100 Landfill Fund Recurring Recommend - Yes
Activity: Landfill
4 of 8
This improvement package would allow for the purchase of thirteen additional container metering devices
to be utilized in the Agency’s comingled and glass recycling containers. The Agency is currently utilizing
five of these devices in a pilot project to monitor container fullness and contamination and optimize the
collection schedule. The containers without metering devices are currently collected on a set schedule,
which can lead to unnecessary collection trips or containers which are filled before the scheduled
collection day. Utilizing the metering devices will help reduce the greenhouse gas emissions from the
unnecessary collections and increase recycling material capacity by emptying heavily used containers
more frequently.
Related Cost:$ 2,600 Landfill Fund Non-Recurring Recommend - Yes
Related Cost:$ 5,400 Landfill Fund Recurring
Total:$ 8,000
Activity: Landfill
5 of 8
This improvement package would provide funding to conduct a tabletop exercise for two scenarios related
to the landfill fire plan. The consultant would develop and conduct the sessions which would involve the
-76-
various entities which support the landfill in the event or a fire. An after-action report would be developed
based on the scenarios and included in Fire Plan records. These records along with other after-action
reports would be utilized during future fire plan revisions.
Related Cost:$ 17,000 Landfill Fund Non-Recurring Recommend - Yes
Activity: Landfill
6 of 8
This improvement package would provide funding to organize and gather data related to the assets
utilized by the gas system, leachate collection system and ground water monitoring wells. The data would
then be uploaded into Cartegraph.
Related Cost:$ 10,000 Landfill Fund Non-Recurring Recommend - Yes
Activity: Landfill
7 of 8
This improvement package would support the current Environmental Management System (EMS)
Objective & Target for the Education component. The goal is to decrease the percentage of materials
currently in the landfill waste stream which could be diverted for recycling/reuse, including but not limited
to tires, appliances, e-scrap, household and non-household hazardous waste, and organics. The
consultant would assist with the development of marketing and educational strategies to increase and
improve how diversion services are communicated to both residential and non-residential customers.
Related Cost:$ 25,000 Landfill Fund Non-Recurring Recommend - Yes
Activity: Landfill
8 of 8
This improvement package would provide funding to replace the current scale software utilized for landfill
and Regional Collection Center activities. The current software has limited capabilities for automation of
tasks and data generation. Staff is proposing to replace the software with a more robust program, which
integrates with the current Financial ERP system, and allows for automation of daily reporting for both
internal and external users.
Related Cost:$ 80,000 Landfill Fund Non-Recurring Recommend - Yes
Related Cost:$ 5,600 Landfill Fund Recurring
Total Cost:$ 85,600
Activity: Landfill
Significant Line Items
Employee Expense
1.FY 2024 employee expense reflects a 5.00% wage package increase.
2.The Iowa Public Employee Retirement System (IPERS) City contribution of 9.44% is unchanged
from FY 2023 The employee contribution of 6.29% is unchanged from FY 2023.
3.The City portion of health insurance expense is unchanged from $1,119 in FY 2023 to $1,119 in FY
2024 per month per contract which results in an annual cost unchanged of $25,463 or —%.
-77-
4.Workers’ Compensation decreased from $343,118 in FY 2023 to $322,766 in FY 2024. FY 2022
actual was $290,782.
5.Overtime is unchanged from $324,391 in FY 2023 to $324,391 in FY 2024. FY 2022 actual was
$290,472.
6.Five-Year Retiree Sick leave payout increased from $27,972 in FY 2023 to $38,123 in FY 2024.
7.50% Sick Leave Payout unchanged from $5,711 in FY 2023 to $5,711 in FY 2024. FY 2022 Actual
was $4,882. Effective July 1, 2019, employees over the sick leave cap can convert 50% of the sick
leave over the cap to vacation or be paid out.
8.The Fiscal Year 2024 budget includes the following adjustments in the funding allocation of
positions:
a.-0.15 FTE Equipment Operator II (GD-08) from General Fund (-$9,434)
b.+0.15 FTE Equipment Operator II (GD-08) to Road Use Tax Fund (+$9,434)
c.-0.73 FTE Utility Worker (GD-05) from Road Use Tax Fund (-$59,286)
d.+0.73 FTE FTE Utility Worker (GD-05) to General Fund (+$59,286)
9.During Fiscal Year 2023, the following personnel changes were approved:
a.1.00 FTE Administrative Assistant position (GE-25) was approved, which resulted in a cost
increase of $64,669.
10.During the Fiscal Year 2024 budget process, the following positions were corrected to the
approved full time equivalent:
a.Utility Worker was increased from 10.17 FTE to 11.00 FTE (+0.83 FTE);
b.Equipment Operator I was decreased from 12.73 FTE to 12.00 FTE (-0.73 FTE);
c.Equipment Operator II was decreased from 8.10 FTE to 8.00 FTE (-0.10 FTE).
Supplies & Services
11.General Liability Insurance increased from $170,483 in FY 2023 to $172,388 in FY 2024 based on
FY 2023 actual.
12.Street Lighting increased from $791,142 in FY 2023 to $814,154 in FY 2024 based on FY 2022
actual of $814,154. The street lighting budget is split $28,852 general fund and $785,302 Road
Use Tax fund in FY 2024. This line item represents electricity costs to operate street lights.
13.Building Maintenance increased from $174,284 in FY 2023 to $313,644 in FY 2024. The FY 2022
actual was $234,963. This overall increase relative to FY 2022 actual includes an increase in the
Street Maintenance activity for expenses related to the planned sealing of the parking lot ($50,260)
and replacement of ceiling tiles ($35,000) at the Municipal Services Center. The Refuse activity
increased from the FY 2022 actual also due to the ceiling tile replacement at the Municipal
Services Center ($17,500).
14.Vehicle Ops - Gasoline increased from $259,316 in FY 2023 to $259,458 in FY 2024 based on FY
2023 budget. The FY 2022 actual expense was $414,840. This line represents all gasoline
purchased from a city-owned gas pump that is used to fuel the Public Works Department's vehicles
and other equipment.
15.Vehicle Repairs - Internal decreased from $418,525 in FY 2023 to $412,709 in FY 2024 based on
FY 2022 actual of $404,615 plus 2%. This line item includes maintenance and repairs on Public
Works vehicles that is performed by city staff.
-78-
16.Vehicle Repairs - Outsourced is increased from $111,485 in FY 2023 to $137,016 in FY 2024
based on FY 2022 actual of $156,446 plus 2%. This line item includes more complex repairs to
Public Works vehicles that are not performed by city staff that require specialty work or cannot be
preformed in house due to staffing shortages.
17.Road Salt for Snow and Ice Control decreased from $384,750 in FY 2023 to $351,600 in FY 2024
based on the FY 2022 price plus an 8%. Road Salt decreased $33,150 based on the purchase of
5,000 tons of road salt at $70.32 per ton (the FY 2023 budget is based on the purchase of 5,700
tons at $64.50 per ton). The number of tons decreased in FY 2024 due to increased efficiency of
salt usage, as well as recent winter seasons producing less precipitation which requires less
frequent salting and road treatment.
18.Road Salt for Bid Partners decreased from $96,750 in FY 2023 to $87,900 in FY 2024 based on
FY 2023 budget plus anticipated price increases. Salt for bid partners decreased $8,850 based on
the purchase of 1,250 tons at $70.32 per ton (In FY 2023 the budget is based on the purchase of
1,500 tons at $64.50 per ton) which is off-set from the revenue of salt purchased by bid partners.
The number of tons decreased in FY 2024 due to increased efficiency of salt usage, as well as
recent winter seasons producing less precipitation which requires less frequent salting and road
treatment.
19.Engineering Outsourced increased from $292,650 in FY 2023 to $321,650 in FY 2024. FY 2022
actual was $243,950. The line item represents expenses associated with an engineering consulting
firm contracted by the Landfill to complete bi-annual Iowa Department of Natural Resources
engineer's reports, hydrological monitoring reports, and air permit reports and the management of
the landfill gas collection system. This line item also includes recurring expenses approved in FY
2023 for engineering consulting related to recurring waste diversion efforts and an evaluation of the
pay as you throw model.
20.Landfill Fees increased from $583,887 in FY 2023 to $592,306 in FY 2024. FY 2022 actual was
$590,393. This line item represents expenses for disposing waste that is collected through
curbside collection services. The refuse collection activity increased $7,525 based on a two-year
average of 12,379 tons at the estimated FY 2024 fee per ton of $37.11.
21.Pay to Other Agency is increased from $718,870 in FY 2023 to $777,458 in FY 2024. FY 2022
actual was $599,201. This line item includes Landfill leachate treatment and disposal costs of
$100,385 due to an agreement with the City to pay fees for leachate disposal into the sanitary
sewer system, the processing and marketing of recyclable materials for curbside collection in the
amount of $73,864 based on a three year average, Landfill quarterly tonnage payments to
Delaware county for $15,600, Landfill collection and disposal of household, farm and small
business chemicals, fluorescent light bulbs, paint and medical sharps for $80,737, contracted
disposal of E-waste for $56,137, Rural Recycling transportation and processing of 14 recyclables
drop off sites for $125,235, and payment to Iowa DNR of $325,500 for surtax paid by the Landfill
based on tonnage. The FY 2024 Iowa DNR surtax expense is based on 155,000 tons at $2.10 per
ton, and FY 2023 was based on 145,000 tons at $2.10 per ton.
22.Street Materials decreased from $1,396,671 in FY 2023 to $1,022,483 in FY 2024 based on doing
a five mile program in FY 2024, which is a decrease from the ten mile program in FY 2023. The FY
2022 actual was $977,000. This line item represents the purchase of Asphalt, Concrete, and
Stone. FY 2024 includes expenses for purchasing 13,000 tons of hot mix asphalt for $54.90 per
ton and purchasing 120 tons of cold mix asphalt for $67.03 per ton, which will be used for
completing five center line street miles. FY 2024 includes expense for buying 1,500 cubic yards of
concrete and k-crete for $92.19 per ton, which will be used for curbs, water breaks, catch basins,
-79-
curb ramps. FY 2024 includes expenses for the purchase of 3,500 tons of Stone for $13.00 per
ton, which is used for street maintenance, repairing sanitary sewer and storm sewer street
excavations, and resurfacing Landfill gravel roads and cell face access lanes.
23.Equipment Maintenance and Repair increased from $747,935 in FY 2023 to $888,532 in FY 2024
based on FY 2022 actual of $866,291 plus a 2% increase. This line item includes repairs to a wide
variety of equipment used by Public Works to deliver services such as excavators, backhoes,
wheel loaders, snowblowers, and zero turn mowers. Maintenance for the Riverfront Management
activity increased by an additional $4,869 relative to FY 2022 actual plus 2% due to anticipated
costs increases related to supply chain issues.
24.The administrative overhead recharge increased from $1,783,326 in FY 2023 to $2,033,186 in FY
2024.
Machinery & Equipment
25.Equipment replacement items ($810,236) includes:
Administration
Conference Room Chairs (15)$ 9,750
Riverfront Management
Zero-Turn Mower $ 10,000
Street and Traffic Lighting
Signal Controllers $ 12,000
Street Maintenance
Barricades/Signs $ 6,800
MSC Audio/Visual Equipment $ 1,000
Skid Steer $ 37,500
Vibratory Tamper $ 11,000
Water Tank Trailer $ 10,000
Roller Trailer $ 8,500
Pavement Saw $ 23,000
Street Cleaning
Power Mowers (4)$ 2,200
Tiller $ 500
Snow & Ice Control
Multi-Edge 10' Plows $ 46,000
Sanitary Sewer Maintenance
Gas Monitor $ 1,500
Confined Space Equipment $ 2,000
Stormwater Maintenance
Jet flusher hose (2)$ 3,500
Vibratory Tamper $ 11,000
Hand Concrete Saw $ 1,000
Refuse Collection
Refuse Collection Carts (6,250)$ 336,849
Smart Phone (1)$ 350
Recycling Collection Program
Public Works Machinery and Equipment
-80-
Recycling Bins/Lids (1,074)$ 19,800
Recycling Wheeled Carts (350)$ 61,320
Yard Waste Collection Program
Yard Waste Wheeled Carts $ 10,104
Public Works Garage
Portable Welding Ventilators $ 12,000
Landfill
Shop Equipment $ 1,050
Card Reader $ 1,400
Smartphones (3)$ 1,050
Ruggedized Cell Phones (2)$ 700
Bulky Collection
1 Ton Flatbed $ 70,000
Recommended Improvement Requests $ 98,363
Total Equipment $ 810,236
Public Works Machinery and Equipment
Debt Service
Debt service reflects annual repayment to ($755,349):
Amount Debt Series Source Purpose
Final
Payment
Call
Date
$ 40,367 G.O. Series 2017A Road Use Tax Equipment Replacement 2030 2025
$ 30,786 G.O. Series 2021A Sales Tax 30%Curb Ramp Program 2034 2028
$ 12,744 G.O Series 2018A Solid Waste Fees Solid Waste Trucks 2030 2025
$ 5,300 G.O. Series 2017A Solid Waste Fees Solid Waste Trucks 2031 2025
$ 2,543 G.O. Series 2018A Sales Tax 20%Radio Replacement 2028 2026
$ 309,834
Dubuque County -
G.O. Series 2014 Landfill Fees Landfill Improvements 2034 2022
$ 353,775
Dubuque County -
G.O. Series 2016 Landfill Fees Landfill Improvements 2036 2024
$ 755,349 Total Public Works Annual Debt Service
Revenue
26.Solid Waste monthly base fees decreased from FY23 Budget of $3,510,597 to $2,720,873 in FY
2024 which is a $789,724 decrease in revenue. FY 2022 actual was $2,982,213. This line item is
based on FY 2022 actual plus the FY 2024 rate increase of 2.90%.
27.Tipper Carts increased from $1,020,799 in FY 2023 to $2,084,279 in FY 2024. This line item
represents subscriptions to tipper carts. This increase is based on FY 2022 actual of $1,206,544
and the growth in customers associated with the discontinuation of oversized and additional cart
services ($39,407).
28.Refuse Single Use Stickers increased from $122,875 in FY 2023 to $236,279 in FY 2024 based on
FY 2023 actual annualized. The FY 2022 actual was $118,831.
-81-
29.Yard Waste Annual Sticker/Single Use/Brush Ties decreased from $131,459 in FY 2023 to
$109,720 in FY 2024 based on FY 2022 of $109,720.
30.Purina Drive Salt Operations represent revenue received from the sale of salt to the City’s bid
partners. The FY 2024 budget includes $87,900 in salt sales, $8,313 in salt handling fees, and
$7,388 in salt storage fees.
31.The Solid Waste Agency payment decreased from $6,170,419 in FY 2023 to $5,043,660 in FY
2024. This revenue was formerly housed in Public Works but has moved to the Dubuque
Metropolitan Area Solid Waste Agency (DMASWA). Departmental employees operate the landfill,
yard waste, e-waste, recycling drop-off and household hazardous regional collection center
facilities owned by the DMASWA. Department employees also provide education and
communication support services. The department is compensated for all operating expenses
incurred. Revenue estimates are based on anticipated tonnages and fee schedule for FY 2024.
32.Garage personnel maintain and repair vehicles and equipment of all city departments and divisions
except Airport. Labor costs are assessed using actual time charged out to each department at
projected FY 2024 overhead rate of $74.36 which is unchanged from the FY 2023 overhead rate of
$74.36. Revenue is also received from recharges to users for parts and fuel purchased from the
vehicle maintenance garage inventory.
The following is a summary of the operating expenses and revenues for the City Garage:
City Garage
FY 2022
Actual
FY 2023
Budget
FY 2024
Requested
% Change
From FY
2023
Budget
Expenses
Employee Expense 1,010,775 1,106,225 1,140,853 3.1 %
Supplies and Services 220,265 163,333 238,149 45.8 %
Garage Stores 1,121,816 966,045 1,115,353 15.5 %
Machinery and Equipment 31,282 — 12,000 — %
Total Expenses 2,384,138 2,235,603 2,506,355 12.1 %
Resources
Specialized Services 1,226,784 1,168,278 1,295,212 10.9 %
Fuel/Parts 1,171,967 736,442 1,171,967 59.1 %
County Fuel Sales 26,511 22,218 26,511 19.3 %
Reimbursements 35,449 30,329 32,804 8.2 %
Total Resources 2,460,711 1,957,267 2,526,494 29.1 %
Annual Operating Surplus (Deficit) 76,573 (278,336) 20,139 298,475
Garage Overhead Rate $ 74.36 $ 74.36 $ 74.36
-82-
-83-
PUBLIC WORKS
MISSION
Public Works takes pride in leveraging necessary resources to maintain the heart of Dubuque by
steadfast, equitable delivery of organization- and community-wide services while maintaining reliable
infrastructure to cultivate a vibrant, connected community. The beat of Dubuque is maintained through
preservation, construction, rehabilitation, daily operations, and the 24/7 emergency response Public
Works' staff provides.
VISION
Public Works will be recognized for its commitment to provide services that meet the needs of
Dubuque’s citizens and contribution to an equitable community through innovation, technological
advancements, accountable stewardship, responsiveness, and adaptability to our ever-changing
community.
SAFETY - COMMUNITY FOCUSED - INTEGRITY - COMMUNICATION - EQUITY
SUCCESS IS ABOUT PLANNING, PARTNERSHIPS AND PEOPLE
LEADING TO OUTCOMES
-84-
PUBLIC WORKS
FY 2022 FY 2023 FY 2024
Full-Time Equivalent 93.28 93.43 95.73
Resources
FY 2022 FY 2023 FY 2024
Operating
SaltRoad Use Tax
Sewer
Stormwater
Refuse
LandfillProperty Tax Support
$0 $1,500,000 $3,000,000 $4,500,000 $6,000,000 $7,500,000
The Public Works Department is supported by 95.73 full-time equivalent employees, which accounts for
47% of the department expense as seen below. Overall, the department's expenses are expected to
decrease by 5% in FY 2024 compared to FY 2023.
Expenditures by Category by Fiscal Year
$7,649,666
$8,209,984
$601,081
$1,094,094
$1,659,457
$794,698
$8,752,327
$8,489,534
$1,024,381
$966,357
$1,783,326
$753,013
$9,161,407
$8,796,385
$810,236
$1,015,632
$2,358,186
$755,349
FY 2022 FY 2023 FY 2024
Employee Expense
Supplies and Services
Machinery and Equipment
Garage/Stores
Administrative OH
Debt Service
$0 $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000
-85-
PUBLIC WORKS
Public Works Administration
Mission & Services
Public works administration provides support for citizens and supervisors of employees of the
department who are responsible for: maintaining and cleaning Dubuque’s streets, alleys, sanitary
sewers, storm sewers, retaining walls, sidewalks, steps and riverfront, street and traffic sign repairs,
traffic signal and street light maintenance, utility location support, refuse collection, floodwall operations,
landfill operations, yard waste collection, DMASWA administrative and education support, large item
collection, curbside recycling collection, curb side electronic recycling collection, e-scrap recycling, rural
recycling drop-off facilities, composting operations, household hazardous materials regional collection
center, landfill methane management, Port of Dubuque facility maintenance, and City-wide fleet
maintenance.
Administration Funding Summary
10054100 FY 2022 Actual FY 2023 Budget FY 2024 Recomm'd
Expenditures $9,098 $93,755 $11,927
Resources $14 $26 $14
Administration Position Summary
FY 2024
Public Works Director 1.00
Assistant Public Works Director 1.00
Lead Administrative Assistant 1.00
Secretary 3.67
Data Scientist 1.00
Total FT Equivalent Employees 6.67
Performance Measures
City Council Goal: Financially Responsible, High-Performance Organization
Performance Measure (KPI)Target CY 2020
Actual
CY 2021
Actual
CY 2022
Estimated
Performance
Indicator
1 Activity Objective: Provide effective and timely response to resident requests for information and
service to avoid disruption in residents' daily lives.
% of phone support answer rate > 90%66.3%70.0%72.5%
Avg. time service requests are resolved:
High Priority <10 days 13.58 11.64 7.17
Avg. time service requests are resolved:
Medium Priority <14 days 7.67 9.65 13.51
Avg. time service requests are resolved:
Low Priority <30 days 59.55 15.13 5.00
Citizens frequently assume that the many essential services provided by the Public Works Department
are supported by 24/7 staffing. Since that is not the case, responses to citizen inquiries and requests for
non-essential service can take longer than 96 hours to complete.
-86-
PUBLIC WORKS
Street Maintenance
Mission & Services
Provide for the safe and efficient movement of motor vehicles on City streets and alleys and the safe
movement of pedestrians on public sidewalks and steps maintained by the department. Also, safeguard
public health and provide for the general welfare of residents and visitors to the community through
street sweeping and weed-cutting on City-owned properties and along City right-of-way. Responsibilities
include street maintenance, street cleaning, snow and ice control, street light and traffic light
maintenance, and street signs and markings.
Street Maintenance Funding Summary
FY 2022 Actual FY 2023 Budget FY 2024 Recomm'd
Expenditures $5,866,453 $6,967,292 $6,838,797
Resources $3,362,691 $3,847,084 $3,538,816
Street Maintenance Position Summary
FY 2024
Foreman - Maintenance 3.20
Foreman - Snow and Ice 0.98
Field Supervisor - Maintenance 0.73
Field Supervisor - Snow and Ice 0.17
Utility Worker - Maintenance 6.46
Utility Worker - Snow and Ice 1.85
Equipment Operator I - Street Signs 0.82
Equipment Operator I - Maintenance 3.38
Equipment Operator I - Snow & Ice 1.98
Equipment Operator I - Street Clean 0.83
Equipment Operator II - Street Signs 0.15
Equipment Operator II - Maint.2.09
Equipment Operator II - Snow & Ice 1.17
Equipment Operator II - Street Clean 1.77
Assistant Horticulturist - Maint.0.25
Assistant Horticulturist - Snow and Ice 0.17
Custodian I 0.38
Snowfighter/Yard Waste San Driver 0.42
Utility Worker Apprentice 0.83
Laborer - Street Cleaning 0.12
Traffic Signal Technician II - Street Sign 0.01
Traffic Signal Technician II - Snow 0.12
Traffic Signal Technician II - Traffic 2.86
Total FT Equivalent Employees 30.74
-87-
PUBLIC WORKS
Performance Measures
City Council Goal: Connected Community
Performance Measure (KPI)Target CY 2020
Actual
CY 2021
Actual
CY 2022
Estimated
Performance
Indicator
1 Activity Objective: Provide an effective and efficient road transportation network
# of centerline miles of asphalt overlay
projects completed per year 5 4.72 10.01 10.25
City Council Goal: Sustainable Environment
3 Activity Objective: Replace City-owned high-pressure sodium street lights with more energy-
efficient, longer lifespan LED lights.
% of City-owned LED lights 1%
increase 50%52%59%
DID YOU KNOW?
Studies show that for every $1 spent on street pavement preventive maintenance projects, it would
cost $4 to $5 more if those preventive maintenance projects were delayed and more extensive
pavement rehabilitation is needed at a later time.
Winter Season 2016/2017 2017/2018 2018/2019 2019/2020 2020/2021 2021/2022
Number of Storms 12 25 26 22 17 17
Total Seasonal Snowfall
(inches)27.10 38.20 55.20 36.20 59.30 31.20
Type of Season Weak LN Weak LN Weak EN Neutral Moderate LN Weak LN
Salt Used for Deicing 3,474 5,749 5,401 5,135 3,990 4,003
-88-
PUBLIC WORKS
Sewer Maintenance
Mission & Services
Sewer Maintenance provides for a safe and clean municipal environment by inspecting, cleaning and
repairing Dubuque’s sanitary and storm water sewers. Dubuque’s sanitary sewer system 309 miles of
gravity-flow pipe and 7,642 manholes. Department workers also inspect, clean and repair Dubuque’s
stormwater sewer system, which consists of 152 miles of pipe, 6,301 catch basins, and 1,997 manholes.
Sewer Maintenance Funding Summary
61054300
62054310 FY 2022 Actual FY 2023 Budget FY 2024 Recomm'd
Expenditures $982,983 $1,000,423 $1,028,168
Resources $982,983 $1,000,423 $1,028,168
Sewer Maintenance Position Summary
FY 2024
Foreman - Sanitary 0.92
Foreman - Storm 0.82
Equipment Operator I - Sanitary 2.97
Equipment Operator I - Storm 1.12
Equipment Operator II - Sanitary 0.87
Equipment Operator II - Storm 0.10
Utility Worker - Sanitary 0.30
Total FT Equivalent Employees 7.10
Performance Measures
City Council Goal: Sustainable Environment
Performance Measure (KPI)Target CY 2020
Actual
CY 2021
Actual
CY 2022
Estimated
Performance
Indicator
1 Activity Objective: Reduce the number of sanitary sewer basement back-ups and non-basement
sanitary sewer overflows attributed to compromised City sewer lines.
# of miles of sanitary sewer pipe cleaned
or inspected 75.00 99.19 92.93 55.44
# of City sewer problems responded to (#
of private sewer problems responded to)0 (50)7 (53)8 (61)22 (52)
Total sanitary sewer pipe treated for
intrusive root control (feet)10,000 13,218 14,914 —
City Council Goal: Financially Responsible, High Performance Organization
2 Activity Objective: Ensure contractors’ and developers’ compliance with City specifications by
completing post-construction inspection of new or repaired sanitary and storm sewer infrastructure
using City Media Service technology
Total sewer pipe inspection footage using
CMS equipment 35,000 42,844 48,000 72,568
-89-
PUBLIC WORKS
Riverfront Maintenance and Operations
Mission & Services
Riverfront Maintenance and Operations provides for the Public Works Department’s maintenance of
riverfront shoreline, two public boat ramps, accessible and aesthetically-attractive municipal waterfront
areas, Dubuque's flood control system, and maintenance for American Trust River’s Edge Plaza, the
Alliant Energy Amphitheater, the Mississippi Riverwalk, the Port of Dubuque’s parking lots, the Riverwalk
boat-mooring quay, the Port’s shoreline, and other City-owned infrastructure in the Port of Dubuque.
Lighting, sweeping, watering, landscaping, mowing, snow clearing, and other maintenance along
Dubuque’s entire riverfront are also provided as needed and required.
Riverfront Maintenance and Operations Funding Summary
FY 2022 Actual FY 2023 Budget FY 2024 Recomm'd
Expenditures $362,339 $510,387 $520,259
Resources $15,183 $12,969 $8,313
Riverfront Maintenance and Operations Position Summary
FY 2024
Foreman - Floodwall 0.08
Field Supervisor - Floodwall 0.10
Equipment Operator I - Floodwall 0.10
Equipment Operator I - POD 0.73
Equipment Operator I - Riverfront 0.05
Equipment Operator II - Riverfront 0.10
Equipment Operator II - Floodwall 0.12
Equipment Operator II - POD 0.63
Laborer - Riverfront 0.08
Laborer - Floodwall 0.08
Laborer - POD 0.45
Traffic Signal Technician 0.01
Total FT Equivalent Employees 2.53
-90-
PUBLIC WORKS
Vehicle Maintenance
Mission & Services
Vehicle Maintenance maintains and repairs the City’s fleet of 584 trucks, buses, heavy equipment,
automobiles, and other machinery. Machinery, vehicles, and equipment maintained include the major
fleets belonging to the Public Works, Planning, Housing, Engineering, Police, Fire, and Water
departments, along with the buses of The Jule public transit system.
Vehicle Maintenance Funding Summary
81054600
82054400 FY 2022 Actual FY 2023 Budget FY 2024 Recomm'd
Expenditures $ 2,384,428 $ 2,235,603 $ 2,506,355
Resources $ 2,466,912 $ 1,957,267 $ 2,526,494
Vehicle Maintenance Position Summary
FY 2024
Equipment Maintenance Supervisor 1.00
Lead Mechanic 2.00
Mechanic 7.00
Stock Clerk 1.00
Inventory Accounting Clerk 1.00
Custodian I 0.15
Total FT Equivalent Employees 12.15
Performance Measures
City Council Goal: Financially Responsible, High-Performance Organization
Performance Measure (KPI)Target CY 2020
Actual
CY 2021
Actual
CY 2022
Estimated
Performance
Indicator
1 Activity Objective: Ensure City vehicles and heavy equipment are always ready to provide timely
service to the public in a cost-effective manner
# of City-owned vehicles with extended
life expectancy of at least one year due to
annual inspection
N/A 9 10 16 N/A
-91-
PUBLIC WORKS
Solid Waste Resource Management
Mission & Services
The Solid Waste Resource Management Activity provides City curbside collection services that reduce
public health risks and improve community livability, while seeking to optimize materials' diversion away
from the landfill. The Public Works Department provides equitable refuse collection and disposal service
to over 20,000 residential and small business customers through the City’s Pay-As-You Throw (PAYT)
program. Other responsibilities include: monitoring City compliance with all collection-related
environmental and safety regulations, facilitating community aesthetic improvements, providing for
efficient collection of recyclable materials, large item collection, curbside collection of yard debris
materials (grass, leaves and brush), food scraps, and compostable paper.
Resource Management Funding Summary
FY 2022 Actual FY 2023 Budget FY 2024 Recomm'd
Expenditures $4,435,514 $5,148,917 $5,660,862
Resources $4,813,223 $5,690,986 $5,676,758
Resource Management Position Summary
FY 2024
Resource Management Coordinator 1.00
Lead Sanitation Driver 1.00
Sanitation Driver 18.00
Custodial I 0.08
Resource Management Intern 0.30
Yard Waste San Driver/Snowfighter 0.58
Total FT Equivalent Employees 20.96
Performance Measures
City Council Goal: Sustainable Environment
Performance Measure (KPI)Target CY 2020
Actual
CY 2021
Actual
CY 2022
Estimated
Performance
Indicator
1 Activity Objective: Increase overall waste diversion rate of City collection materials by 1% per capita
per day.
% change in refuse as the total municipal
materials collected curbside per capita per
day
-1%
Annually 5.8%9.5%(3.1)%
% change in recycling as the total
municipal materials collected curbside per
capita per day
Maintain 0.5%(3.0)%(5.2)%
% change in yard waste and food scraps
as the total municipal materials collected
curbside per capita per day
+1%
Annually 33.9%(19.8)%(1.0)%
2 Activity Objective: Increase expanded use of City-owned wheeled collection carts.
% of service-provided households
subscribe to a refuse-wheeled cart >90%21.0%25.0%42.2%
Total municipal waste tonnages collected curbside increased 5.34% from FY2020 to FY2021.
-92-
100 - General
4A - Charges for Services
45035 - Pavilion Fees (4,038) (8,313) (5,969) (8,313)
45500 - Miscellaneous Chg for Svcs (630) 0 (630) 0
47100 - Reimbursements (32,738) (7,494) (12,412) (5,479)
47150 - Refunds (455) 0 0 0
47200 - Insurance Settlements (18,851) (16,352) (14,309) (16,786)
47450 - Sale of Salvage (348) (324) (355) (7,940)
47700 - District Court Fines 0 0 0 0
47820 - Specialized Services 0 0 0 0
4A - Charges for Services Total (57,060) (32,484) (33,675) (38,518)
4B - Grants/Contrib
44400 - State Grants 0 0 0 0
44645 - State Highway Maintenance (22,896) (33,995) (14,098) (11,098)
4B - Grants/Contrib Total (22,896) (33,995) (14,098) (11,098)
4M - Gain on Disposal
48100 - Sale of Personal Property (350) (125) (350) (306)
4M - Gain on Disposal Total (350) (125) (350) (306)
200 - Debt Service
4N - Transfers
49110 - Transfer in Road Use Tax (36,207) (38,406) (39,415) (40,367)
49301 - Transfer in Street Const (83,029) (75,161) (31,276) (30,786)
49304 - Transfer in Sales Tax 20% (12,829) (12,959) (12,959) (12,744)
4N - Transfers Total (132,065) (126,526) (83,650) (83,897)
4O - Eliminated for GW
48200 - Proceeds from GO Debt (406,346) 0 0 0
48205 - Bond Discount/Premium (16,765) 0 0 0
4O - Eliminated for GW Total (423,111) — — —
620 - Stormwater Operating
4A - Charges for Services
47100 - Reimbursements — — — —
47820 - Specialized Services — — — —
4A - Charges for Services Total 0 0 0 0
610 - Sanitary Sewer Operating
4A - Charges for Services
45123 - Sewer TV Service Fee (4,762)0 (4,762)(4,762)
47100 - Reimbursements (2,637)0 0 0
47150 - Refunds (3,803)0 0 0
47450 - Sale of Salvage (1,959)(2,700)(1,959)(1,984)
47820 - Specialized Services 0 0 0 0
4A - Charges for Services Total (13,161)(2,700)(6,721)(6,746)
110 - Road Use Tax
4A - Charges for Services
47100 - Reimbursements (61,858)(16,623)(16,504)(16,136)
47150 - Refunds (134)0 0 0
47200 - Insurance Settlements (395)0 0 0
Recommended Operating Revenue Budget - Department Total
54 - PUBLIC WORKS
Fund/Account/Account Title
FY21 Actual
Revenue
FY22 Actual
Revenue
FY23 Adopted
Budget
FY24 Recomm'd
Budget
-93-
47450 - Sale of Salvage 0 (180)0 0
47525 - Salt 0 0 0 0
47820 - Specialized Services 0 0 0 0
4A - Charges for Services Total (62,388)(16,803)(16,504)(16,136)
4M - Gain on Disposal
48100 - Sale of Personal Property (41,000)0 0 0
4M - Gain on Disposal Total (41,000)0 0 0
605 - Salt Operations
4A - Charges for Services
45075 - Salt Handling Fee 0 0 (9,240)(8,313)
45076 - Salt Storage Fee (4,773)0 (6,000)(7,388)
47525 - Salt (120,416)(100,763)(97,665)(87,900)
47820 - Specialized Services 0 0 0 0
4A - Charges for Services Total (125,189)(100,763)(112,905)(103,601)
670 - Refuse Collection Operating
4A - Charges for Services
45220 - Solid Waste Fee (3,067,771)(3,015,035)(3,551,154)(2,753,695)
45221 - Tipper Carts (875,245)(1,206,544)(1,020,799)(2,084,279)
45222 - Extra Oversized Cans (49,689)(39,408)(49,689)0
45223 - Refuse Single Use Sticker (122,875)(118,831)(122,875)(236,279)
45224 - ROW Violation (1,092)(2,755)(1,092)(2,755)
45225 - Yard Waste Sticker Annual (26,412)(24,484)(26,412)(24,484)
45226 - Yard Waste Sticker Single Use (102,916)(83,523)(102,916)(83,523)
45227 - Yard Waste Brush Ties (2,131)(1,713)(2,131)(1,713)
45228 - Food Scrap (9,131)(9,532)(9,131)(9,532)
45229 - Leaf Rake Out (7,205)(7,246)(7,205)(7,246)
45230 - Large Item Pickup (78,408)(76,625)(78,408)(82,638)
45231 - Recycling Subscription (6,543)(6,495)(6,543)(6,495)
45232 - Recyclable Sales (10,941)(124,687)(96,000)(10,941)
45233 - Solid Waste Vacant Credit 40,557 32,822 40,557 32,822
45300 - Forfeitures/Penalties (1,885)(28,981)(1,878)(28,981)
47100 - Reimbursements (8,097)(44,655)(8,097)(5,679)
47150 - Refunds 0 0 0 0
47200 - Insurance Settlements 0 0 0 0
47820 - Specialized Services 0 0 0 0
4A - Charges for Services Total (4,329,783)(4,757,691)(5,043,773)(5,305,418)
4B - Grants/Contrib
44000 - Federal Grants 0 0 (582,698)0
47050 - Contrib - Private Sources (87)0 0 0
4B - Grants/Contrib Total (87)0 (582,698)0
4K - Unrest Invest Earn
43000 - Interest (14,295)(4,943)(14,295)(27,158)
4K - Unrest Invest Earn Total (14,295)(4,943)(14,295)(27,158)
4N - Transfers
49100 - Transfer In General Fund (40,557)(43,333)(43,000)(336,349)
4N - Transfers Total (40,557)(43,333)(43,000)(336,349)
Recommended Operating Revenue Budget - Department Total
54 - PUBLIC WORKS
Fund/Account/Account Title
FY21 Actual
Revenue
FY22 Actual
Revenue
FY23 Adopted
Budget
FY24 Recomm'd
Budget
-94-
4O - Eliminated for GW
47115 - Sales Tax Collection (6,702)(7,256)(7,220)(7,833)
4O - Eliminated for GW Total (6,702)(7,256)(7,220)(7,833)
811 - Garage Service
4A - Charges for Services
47100 - Reimbursements (763)0 0 0
47350 - Fuel Tax Refunds (26,818)(28,387)(26,818)(28,387)
47450 - Sale of Salvage (3,511)(7,062)(3,511)(4,417)
47503 - Fuel Sales County (22,218)(26,511)(22,218)(26,511)
47820 - Specialized Services (1,168,278)(1,226,784)(1,168,278)(1,275,073)
47940 - Other Internal Services (736,442)(1,171,967)(736,442)(1,171,967)
4A - Charges for Services Total (1,958,030)(2,460,711)(1,957,267)(2,506,355)
4B - Grants/Contrib
44400 - State Grants 0 0 0 0
4B - Grants/Contrib Total 0 0 0 0
4M - Gain on Disposal
48100 - Sale of Personal Property 0 (6,201)0 0
4M - Gain on Disposal Total 0 (6,201)0 0
950 - DMASWA -General
4A - Charges for Services
45526 - Gas Sales 0 0 (70,000)0
45530 - Solid Waste Agency Payment 0 0 (6,170,419)(5,043,660)
47100 - Reimbursements (121)0 (121)0
47820 - Specialized Services 0 0 0 0
4A - Charges for Services Total (121)0 (6,240,540)(5,043,660)
4B - Grants/Contrib
44400 - State Grants (1,470)0 (1,470)0
4B - Grants/Contrib Total (1,470)0 (1,470)0
4M - Gain on Disposal
48100 - Sale of Personal Property 0 0 0 0
4M - Gain on Disposal Total 0 0 0 0
PUBLIC WORKS- Total (7,228,264)(7,593,532)(14,158,166)(13,487,075)
Recommended Operating Revenue Budget - Department Total
54 - PUBLIC WORKS
Fund/Account/Account Title
FY21 Actual
Revenue
FY22 Actual
Revenue
FY23 Adopted
Budget
FY24 Recomm'd
Budget
-95-
6A - Salaries & Wages
100 - General
60100 - Salaries-Regular Full Time 620,626 671,319 775,067 951,479
60200 - Salaries - Regular Part Time 0 0 26,314 32,295
60300 - Hourly Wages - Temp/Seasonal 974 11,039 20,922 21,198
60400 - Overtime 31,284 24,070 35,241 35,241
60410 - Overtime - Holiday 1,846 1,791 4,100 4,100
60620 - Special Pay - Holiday 0 0 3,056 0
60630 - Special Pay Sick Lv Payout Ret 14,262 5,229 4,362 4,362
60635 - Special Pay Sick Lv Payout 50%4,079 2,936 4,079 4,079
60640 - Special Pay - Vacation Payout 0 6,812 0 0
60730 - Spec Pay - Safety Equipment 697 1,286 1,097 1,097
60740 - Spec Pay - Meal Allowance 120 150 120 196
60760 - Spec Pay - Moving Allowance 900 0 0 0
110 - Road Use Tax
60100 - Salaries-Regular Full Time 1,310,200 1,403,277 1,678,291 1,720,835
60200 - Salaries - Regular Part Time 19,827 15,171 19,400 20,292
60300 - Hourly Wages - Temp/Seasonal 719 63 8,913 15,034
60400 - Overtime 181,547 140,954 156,000 156,000
60410 - Overtime - Holiday 37,288 19,979 22,362 13,050
60620 - Special Pay - Holiday 0 0 0 0
60630 - Special Pay Sick Lv Payout Ret 11,503 10,262 5,127 5,127
60635 - Special Pay Sick Lv Payout 50%1,632 1,946 1,632 1,632
60640 - Special Pay - Vacation Payout 2,387 4,496 0 0
60720 - Spec Pay - Meals No Overnight 0 0 0 0
60730 - Spec Pay - Safety Equipment 3,642 5,154 3,408 3,408
60740 - Spec Pay - Meal Allowance 4,116 3,612 4,116 3,654
600 - Water Operating
60100 - Salaries-Regular Full Time 5,225 340 0 0
60400 - Overtime 975 167 0 0
60410 - Overtime - Holiday 128 0 0 0
610 - Sanitary Sewer Operating
60100 - Salaries-Regular Full Time 276,409 302,954 300,195 307,232
60300 - Hourly Wages - Temp/Seasonal 0 0 0 0
60400 - Overtime 4,353 4,184 10,250 10,250
60410 - Overtime - Holiday 0 118 1,900 750
60620 - Special Pay - Holiday 0 0 0 0
60630 - Special Pay Sick Lv Payout Ret 0 2,184 0 5,157
60640 - Special Pay - Vacation Payout 0 1,589 0 0
60720 - Spec Pay - Meals No Overnight 0 0 0 0
60730 - Spec Pay - Safety Equipment 1,588 4,705 1,003 1,003
60740 - Spec Pay - Meal Allowance 30 66 30 74
620 - Stormwater Operating
60100 - Salaries-Regular Full Time 91,084 98,166 124,961 126,761
60300 - Hourly Wages - Temp/Seasonal 0 0 0 0
60400 - Overtime 1,223 1,630 2,050 2,050
Recommended Operating Expenditure Budget - Department Total
54 - PUBLIC WORKS
Fund/Account/Account Title
FY21 Actual
Expense
FY22 Actual
Expense
FY23 Adopted
Budget
FY 24 Recomm'd
Budget
-96-
60410 - Overtime - Holiday 35 188 479 0
60620 - Special Pay - Holiday 0 0 0 0
60630 - Special Pay Sick Lv Payout Ret 5,789 5,789 4,460 4,460
60640 - Special Pay - Vacation Payout 0 0 0 0
60720 - Spec Pay - Meals No Overnight 0 0 0 0
60730 - Spec Pay - Safety Equipment 341 513 334 334
60740 - Spec Pay - Meal Allowance 42 30 42 42
650 - Parking Operating
60100 - Salaries-Regular Full Time 2,091 0 0 0
60300 - Hourly Wages - Temp/Seasonal 0 0 0 0
60400 - Overtime 40 0 0 0
670 - Refuse Collection Operating
60100 - Salaries-Regular Full Time 1,109,320 1,084,508 1,213,316 1,258,565
60200 - Salaries - Regular Part Time 3,027 12,390 4,084 15,860
60300 - Hourly Wages - Temp/Seasonal 3,114 18,563 2,719 0
60400 - Overtime 28,418 25,428 21,400 21,400
60410 - Overtime - Holiday 28,418 39,724 33,034 19,700
60630 - Special Pay Sick Lv Payout Ret 11,653 14,341 12,327 17,321
60640 - Special Pay - Vacation Payout 9,514 0 0 0
60710 - Special Pay - Parental Leave 0 0 0 0
60730 - Spec Pay - Safety Equipment 3,338 3,811 3,018 3,018
60740 - Spec Pay - Meal Allowance 6 0 6 2
811 - Garage Service
60100 - Salaries-Regular Full Time 622,437 678,946 744,471 778,212
60200 - Salaries - Regular Part Time 6,679 5,208 7,658 8,010
60400 - Overtime 45,901 28,394 28,250 28,250
60410 - Overtime - Holiday 3,832 1,645 7,232 3,000
60630 - Special Pay Sick Lv Payout Ret 0 0 0 0
60640 - Special Pay - Vacation Payout 0 0 0 0
60730 - Spec Pay - Safety Equipment 2,131 2,769 1,604 1,604
60740 - Spec Pay - Meal Allowance 1,416 972 1,416 1,308
60750 - Spec Pay - Tool Allowance 1,600 1,800 1,800 1,800
950 - DMASWA -General
60100 - Salaries-Regular Full Time 604,003 553,659 701,888 777,169
60300 - Hourly Wages - Temp/Seasonal 0 0 25,494 0
60400 - Overtime 32,970 65,645 71,200 71,200
60410 - Overtime - Holiday 15,074 17,368 23,540 16,500
60620 - Special Pay - Holiday 0 0 0 0
60630 - Special Pay Sick Lv Payout Ret 4,107 2,182 1,696 1,696
60640 - Special Pay - Vacation Payout 0 1,541 0 0
60720 - Spec Pay - Meals No Overnight 0 0 0 0
60730 - Spec Pay - Safety Equipment 5,702 4,299 4,540 4,540
60740 - Spec Pay - Meal Allowance 408 900 408 778
60750 - Spec Pay - Tool Allowance 200 200 200 200
6A - Salaries & Wages Total 5,180,272 5,316,461 6,130,612 6,481,325
6B - Employee Benefits
Recommended Operating Expenditure Budget - Department Total
54 - PUBLIC WORKS
Fund/Account/Account Title
FY21 Actual
Expense
FY22 Actual
Expense
FY23 Adopted
Budget
FY 24 Recomm'd
Budget
-97-
100 - General
61100 - FICA - City Contribution 48,927 53,354 67,822 79,893
61300 - IPERS - City Contribution 61,714 65,888 82,883 98,582
61510 - Health Insurance 149,840 133,219 148,059 182,680
61540 - Life Insurance 493 442 561 625
61600 - Workers' Compensation 16,350 14,103 13,548 15,270
61700 - Unemployment Compensation 0 0 0 0
61992 - Physicals 0 421 0 421
110 - Road Use Tax
61100 - FICA - City Contribution 112,712 114,421 144,402 147,177
61300 - IPERS - City Contribution 146,213 149,020 176,665 181,740
61510 - Health Insurance 350,336 376,153 382,997 377,057
61540 - Life Insurance 948 972 1,318 1,286
61600 - Workers' Compensation 136,323 106,283 112,397 100,643
61992 - Physicals 0 1,286 0 1,286
600 - Water Operating
61100 - FICA - City Contribution 452 36 0 0
61300 - IPERS - City Contribution 597 48 0 0
61510 - Health Insurance 1,447 196 0 0
61540 - Life Insurance 4 0 0 0
610 - Sanitary Sewer Operating
61100 - FICA - City Contribution 20,059 22,230 23,807 24,344
61300 - IPERS - City Contribution 26,366 29,005 29,377 30,041
61510 - Health Insurance 63,345 65,745 67,919 67,920
61540 - Life Insurance 191 207 234 234
61600 - Workers' Compensation 8,206 5,822 7,594 7,164
61992 - Physicals 274 823 274 823
620 - Stormwater Operating
61100 - FICA - City Contribution 7,049 7,574 10,058 9,855
61300 - IPERS - City Contribution 8,717 9,438 11,991 12,160
61510 - Health Insurance 25,072 26,584 27,382 27,382
61540 - Life Insurance 71 69 96 96
61600 - Workers' Compensation 2,661 2,361 3,107 2,943
61992 - Physicals 0 306 0 306
650 - Parking Operating
61100 - FICA - City Contribution 152 0 0 0
61300 - IPERS - City Contribution 201 0 0 0
61510 - Health Insurance 633 0 0 0
61540 - Life Insurance 2 0 0 0
670 - Refuse Collection Operating
61100 - FICA - City Contribution 86,452 86,228 99,496 100,641
61300 - IPERS - City Contribution 110,358 110,809 120,411 124,185
61510 - Health Insurance 258,216 260,639 275,977 276,246
61540 - Life Insurance 802 785 951 946
61600 - Workers' Compensation 105,752 91,170 116,942 110,571
61700 - Unemployment Compensation 0 0 0 0
Recommended Operating Expenditure Budget - Department Total
54 - PUBLIC WORKS
Fund/Account/Account Title
FY21 Actual
Expense
FY22 Actual
Expense
FY23 Adopted
Budget
FY 24 Recomm'd
Budget
-98-
61992 - Physicals 167 443 167 443
811 - Garage Service
61100 - FICA - City Contribution 49,447 51,735 59,930 62,537
61300 - IPERS - City Contribution 64,083 67,420 73,952 77,168
61510 - Health Insurance 147,552 156,384 161,076 161,076
61540 - Life Insurance 470 472 552 552
61600 - Workers' Compensation 18,800 15,032 17,476 17,336
61992 - Physicals 808 0 808 0
950 - DMASWA -General
61100 - FICA - City Contribution 47,364 46,060 64,567 66,166
61300 - IPERS - City Contribution 61,553 60,092 79,282 81,644
61510 - Health Insurance 135,262 143,354 164,561 161,073
61540 - Life Insurance 444 386 610 550
61600 - Workers' Compensation 69,484 56,011 72,054 68,839
61992 - Physicals 412 181 412 181
6B - Employee Benefits Total 2,346,778 2,333,205 2,621,715 2,680,082
6C - Staff Development
100 - General
62100 - Association Dues 1,451 1,550 1,480 1,550
62200 - Subscriptions 1,293 1,257 1,319 1,319
62325 - Mileage 220 220 307 307
62400 - Meetings & Conferences 1,219 10,265 22,486 24,580
62500 - Education Reimbursement 1,910 2,413 5,952 5,952
110 - Road Use Tax
62100 - Association Dues 430 222 439 439
62400 - Meetings & Conferences 829 0 0 0
62500 - Education Reimbursement 2,211 3,208 41,327 41,327
610 - Sanitary Sewer Operating
62100 - Association Dues 0 30 0 30
62500 - Education Reimbursement 437 4,119 8,000 8,000
620 - Stormwater Operating
62100 - Association Dues 0 0 0 0
62325 - Mileage 0 0 0 0
62400 - Meetings & Conferences 0 0 0 0
62500 - Education Reimbursement 295 0 300 300
670 - Refuse Collection Operating
62100 - Association Dues 293 446 299 446
62200 - Subscriptions 0 0 0 0
62325 - Mileage 0 0 0 0
62400 - Meetings & Conferences 0 1,870 2,623 2,623
62500 - Education Reimbursement 595 290 1,200 1,200
811 - Garage Service
62100 - Association Dues 208 0 212 212
62400 - Meetings & Conferences 926 1,487 5,026 5,026
62500 - Education Reimbursement 1,835 375 7,500 7,500
950 - DMASWA -General
Recommended Operating Expenditure Budget - Department Total
54 - PUBLIC WORKS
Fund/Account/Account Title
FY21 Actual
Expense
FY22 Actual
Expense
FY23 Adopted
Budget
FY 24 Recomm'd
Budget
-99-
62100 - Association Dues 3,549 3,487 3,603 4,171
62200 - Subscriptions 0 0 0 158
62325 - Mileage 794 2,071 3,036 3,036
62400 - Meetings & Conferences (494)6,423 14,798 14,480
62500 - Education Reimbursement 35,429 19,226 35,110 24,840
6C - Staff Development Total 53,431 58,960 155,017 147,496
6D - Repair/Maint/Util
100 - General
63100 - Building Maintenance 1,524 4,725 3,595 4,725
63220 - Landscaping 1,267 12,322 10,655 10,655
63312 - Vehicle Ops - Gasoline 9,390 13,212 12,190 12,190
63313 - Vehicle Ops - Other 0 0 0 0
63320 - Vehicle Repair - Internal 18,075 16,834 15,710 17,171
63321 - Vehicle Repair - Outsourced 6,881 4,064 6,086 4,146
63400 - Equipment Maint/Repair 6,069 12,639 17,684 17,761
63710 - Electricity 20,889 40,939 57,558 40,939
63730 - Telecommunications 8,968 10,051 9,099 10,051
63742 - Stormwater 1,234 7,833 1,338 8,357
63780 - Street Lights 30,184 28,852 30,921 28,852
110 - Road Use Tax
63100 - Building Maintenance 38,654 63,724 38,653 124,851
63220 - Landscaping 0 0 0 0
63312 - Vehicle Ops - Gasoline 130,090 189,469 124,917 124,917
63320 - Vehicle Repair - Internal 123,545 124,830 126,016 127,327
63321 - Vehicle Repair - Outsourced 42,756 29,876 42,275 30,474
63322 - Vehicle Repair - Accident 4,031 0 1,949 0
63400 - Equipment Maint/Repair 513,049 599,940 513,049 611,939
63710 - Electricity 55,008 46,880 54,245 46,880
63711 - Natural Gas 18,435 29,629 27,287 29,629
63730 - Telecommunications 12,573 21,256 13,180 21,257
63740 - Water 0 540 0 594
63742 - Stormwater 1,543 4,849 1,674 5,173
63780 - Street Lights 743,646 785,302 760,221 785,302
605 - Salt Operations
63100 - Building Maintenance 0 0 0 0
610 - Sanitary Sewer Operating
63312 - Vehicle Ops - Gasoline 11,793 19,591 9,911 9,911
63320 - Vehicle Repair - Internal 21,959 20,446 22,399 20,855
63321 - Vehicle Repair - Outsourced 3,784 17,455 1,909 17,804
63400 - Equipment Maint/Repair 3,428 3,544 3,428 3,615
63710 - Electricity 0 0 0 0
63730 - Telecommunications 1,609 2,759 1,695 2,759
620 - Stormwater Operating
63312 - Vehicle Ops - Gasoline 3,167 5,879 16,443 16,443
63320 - Vehicle Repair - Internal 4,339 4,553 4,426 4,644
63321 - Vehicle Repair - Outsourced 1,164 0 922 0
Recommended Operating Expenditure Budget - Department Total
54 - PUBLIC WORKS
Fund/Account/Account Title
FY21 Actual
Expense
FY22 Actual
Expense
FY23 Adopted
Budget
FY 24 Recomm'd
Budget
-100-
63400 - Equipment Maint/Repair 1,104 1,842 1,104 1,879
63710 - Electricity 1,996 1,716 1,818 1,716
63730 - Telecommunications 725 1,320 768 1,320
670 - Refuse Collection Operating
63100 - Building Maintenance 6,459 10,608 6,459 28,108
63312 - Vehicle Ops - Gasoline 105,359 180,632 89,869 89,869
63320 - Vehicle Repair - Internal 237,069 225,561 241,811 230,073
63321 - Vehicle Repair - Outsourced 57,408 100,817 53,979 80,274
63322 - Vehicle Repair - Accident 17,054 750 5,688 0
63400 - Equipment Maint/Repair 0 0 0 0
63710 - Electricity 9,610 10,722 9,321 10,722
63711 - Natural Gas 1,633 3,100 2,605 3,100
63730 - Telecommunications 5,973 8,351 6,220 8,350
63742 - Stormwater 109 681 118 726
811 - Garage Service
63100 - Building Maintenance 25,597 43,796 25,597 43,796
63312 - Vehicle Ops - Gasoline 2,102 4,154 3,550 3,550
63313 - Vehicle Ops - Other 352 410 352 352
63320 - Vehicle Repair - Internal 5,408 6,297 5,516 6,423
63321 - Vehicle Repair - Outsourced 1,366 908 279 926
63400 - Equipment Maint/Repair 43,838 56,259 43,838 57,384
63440 - Uniform Maintenance 4,290 4,036 4,290 4,036
63710 - Electricity 18,259 20,371 17,711 20,371
63711 - Natural Gas 3,102 5,890 4,950 5,890
63730 - Telecommunications 3,008 3,231 3,052 3,231
63742 - Stormwater 207 1,294 224 1,380
950 - DMASWA -General
63100 - Building Maintenance 147,137 112,109 99,980 112,164
63311 - Vehicle Ops - Diesel 0 0 0 0
63312 - Vehicle Ops - Gasoline 2,438 1,903 2,436 2,578
63313 - Vehicle Ops - Other 106,587 208,045 106,587 208,045
63320 - Vehicle Repair - Internal 2,595 6,094 2,647 6,216
63321 - Vehicle Repair - Outsourced 7,127 3,325 6,035 3,392
63400 - Equipment Maint/Repair 168,832 192,068 168,832 195,954
63440 - Uniform Maintenance 312 586 312 586
63710 - Electricity 26,069 26,732 23,510 26,732
63711 - Natural Gas 10,873 8,783 14,304 8,783
63730 - Telecommunications 7,297 8,668 6,770 8,668
63742 - Stormwater 6,822 7,218 7,399 7,701
6D - Repair/Maint/Util Total 2,877,171 3,390,269 2,897,366 3,323,516
6E - Contractual Svcs
100 - General
64004 - Internal Service Charge (504,986)(500,789)(498,454)(750,720)
64005 - Services Other Depts 0 0 2,000 0
64020 - Advertising 281 801 172 801
64030 - Outsourced Labor 9,865 10,352 0 0
Recommended Operating Expenditure Budget - Department Total
54 - PUBLIC WORKS
Fund/Account/Account Title
FY21 Actual
Expense
FY22 Actual
Expense
FY23 Adopted
Budget
FY 24 Recomm'd
Budget
-101-
64040 - Collections 233 123 233 123
64062 - Refunds 75 0 75 0
64070 - Engineering - Outsourced 900 2,525 26,900 3,900
64075 - Engineering - Internal 0 0 32,548 32,548
64080 - Insurance - Property 2,169 5,366 5,872 7,140
64081 - Insurance - Liability 13,170 17,324 19,601 19,696
64140 - Printing 200 0 112 112
64145 - Copying 1,349 1,119 1,349 1,349
64150 - Rental - Equipment 3,079 426 1,762 1,762
64160 - Rental - Land/Bldgs/Parking 660 660 660 660
64190 - Technology Services 11,318 21,583 17,357 22,930
64191 - IT Recharges 0 0 0 17,464
64820 - One Call 7,758 7,406 7,758 7,758
64850 - Consulting Engineers 0 0 0 0
64975 - Equip Maint Cont 22,056 24,986 22,055 24,987
64980 - Technology Equip Maint Cont 10,241 5,003 9,568 0
64985 - Hauling Contract 0 0 0 0
64987 - Lawn Care Contract 22,407 20,755 19,679 19,679
64988 - Snow Removal Contract 33,837 8,288 26,894 21,000
64990 - Other Contractual Service 9,341 19,811 25,094 25,094
110 - Road Use Tax
64004 - Internal Service Charge 258,167 256,245 270,165 341,437
64020 - Advertising 471 1,150 366 1,150
64050 - Recording Fees 0 0 0 0
64080 - Insurance - Property 16,643 18,573 20,336 24,629
64081 - Insurance - Liability 32,946 43,336 49,031 49,270
64110 - Legal 0 0 0 0
64140 - Printing 956 2,578 2,491 2,491
64145 - Copying 0 3 0 0
64150 - Rental - Equipment 4,230 2,148 16,332 16,332
64160 - Rental - Land/Bldgs/Parking 0 0 0 0
64175 - Landfill Fees 51,071 48,041 51,071 48,041
64190 - Technology Services 31,379 32,186 31,029 31,029
64200 - Handling/Service Fee 26,878 24,859 35,112 33,250
64825 - Fire Suppression 1,634 3,541 1,634 3,541
64865 - Elevator Service 856 856 856 856
64870 - HVAC Services 9,505 12,323 9,505 18,505
64900 - Other Professional Service 5,340 5,496 5,340 5,712
64975 - Equip Maint Cont 67,224 37,897 40,778 46,920
64980 - Technology Equip Maint Cont 144 (146)144 11,910
64985 - Hauling Contract 0 0 50,000 50,000
64990 - Other Contractual Service 26,580 9,551 23,537 31,990
180 - Community Development
64990 - Other Contractual Service 0 38,976 0 0
200 - Debt Service
64900 - Other Professional Service 1,078 0 0 0
Recommended Operating Expenditure Budget - Department Total
54 - PUBLIC WORKS
Fund/Account/Account Title
FY21 Actual
Expense
FY22 Actual
Expense
FY23 Adopted
Budget
FY 24 Recomm'd
Budget
-102-
605 - Salt Operations
64004 - Internal Service Charge 5,674 5,632 5,938 7,339
64175 - Landfill Fees 0 0 0 0
64185 - License/Permit/Fees 0 0 0 0
64190 - Technology Services 0 0 0 0
64200 - Handling/Service Fee 9,305 7,893 9,240 8,313
64975 - Equip Maint Cont 1,634 1,756 1,634 1,756
610 - Sanitary Sewer Operating
64004 - Internal Service Charge 34,044 33,791 35,626 44,036
64020 - Advertising 252 800 252 800
64062 - Refunds 500 0 500 500
64070 - Engineering - Outsourced 0 0 0 0
64081 - Insurance - Liability 7,594 9,988 11,301 11,356
64140 - Printing 0 0 0 0
64145 - Copying 0 8 0 0
64150 - Rental - Equipment 0 0 0 0
64190 - Technology Services 25,367 25,290 25,367 25,367
64850 - Consulting Engineers 0 0 0 0
64975 - Equip Maint Cont 8,603 5,354 8,603 5,354
64985 - Hauling Contract 0 0 0 0
64990 - Other Contractual Service 0 0 0 0
620 - Stormwater Operating
64004 - Internal Service Charge 17,022 16,895 17,813 22,018
64020 - Advertising 46 0 0 0
64081 - Insurance - Liability 9,185 12,082 13,670 13,737
64088 - Housing Assistance Payment 74 0 0 0
64115 - Special Events 0 0 0 0
64140 - Printing 0 0 0 0
64145 - Copying 0 0 0 0
64150 - Rental - Equipment 0 0 0 0
64190 - Technology Services 163 294 163 163
64900 - Other Professional Service 0 0 0 0
64975 - Equip Maint Cont 626 525 626 525
670 - Refuse Collection Operating
64004 - Internal Service Charge 79,436 78,845 83,127 117,250
64020 - Advertising 7,469 5,418 15,723 7,773
64040 - Collections 383 483 383 483
64045 - Bad Debt Expense 0 0 0 0
64062 - Refunds 2,294 1,894 2,294 1,894
64070 - Engineering - Outsourced 0 0 25,000 25,000
64080 - Insurance - Property 1,563 1,696 1,856 2,250
64081 - Insurance - Liability 19,920 26,203 29,648 29,792
64130 - Payments to Other Agencies 36,909 0 36,908 73,864
64140 - Printing 20,991 24,129 20,927 20,927
64145 - Copying 37 106 37 37
64175 - Landfill Fees 541,025 542,352 532,816 544,265
Recommended Operating Expenditure Budget - Department Total
54 - PUBLIC WORKS
Fund/Account/Account Title
FY21 Actual
Expense
FY22 Actual
Expense
FY23 Adopted
Budget
FY 24 Recomm'd
Budget
-103-
64180 - Sales Tax Expense 6,771 7,069 7,220 7,416
64190 - Technology Services 9,429 15,993 19,210 68,528
64195 - Credit Card Charge 96 71 96 71
64810 - Applicance Recycling 0 0 1,500 0
64815 - Tire Recycling 568 216 610 610
64825 - Fire Suppression 241 601 241 601
64865 - Elevator Service 162 162 162 162
64870 - HVAC Services 1,519 1,983 1,519 1,519
64900 - Other Professional Service 0 0 0 0
64975 - Equip Maint Cont 3,745 3,022 3,745 5,084
64983 - Grind Compost Service 0 0 0 0
64990 - Other Contractual Service 368 464 368 368
811 - Garage Service
64004 - Internal Service Charge 28,370 28,159 29,688 99,721
64020 - Advertising 581 350 581 350
64030 - Outsourced Labor 0 21,389 0 0
64080 - Insurance - Property 3,168 3,436 3,761 4,946
64081 - Insurance - Liability 13,031 6,177 3,040 6,096
64130 - Payments to Other Agencies 0 0 0 0
64140 - Printing 288 0 0 0
64145 - Copying 162 295 162 162
64185 - License/Permit/Fees 675 435 675 435
64190 - Technology Services 11,300 12,986 11,300 9,453
64191 - IT Recharges 0 0 0 8,997
64825 - Fire Suppression 459 1,142 459 1,142
64865 - Elevator Service 307 307 307 307
64870 - HVAC Services 2,887 3,768 2,887 2,887
64900 - Other Professional Service 0 0 0 30,000
64975 - Equip Maint Cont 1,965 1,880 1,965 1,880
64980 - Technology Equip Maint Cont 5,276 5,276 4,929 0
64990 - Other Contractual Service 1,183 1,836 1,183 1,183
950 - DMASWA -General
64004 - Internal Service Charge 82,273 81,660 86,097 118,919
64005 - Services Other Depts 2,888 2,700 0 2,700
64010 - Accounting & Auditing 5,800 6,375 5,974 6,375
64015 - Financial Service Fees 959 1,106 959 1,106
64020 - Advertising 29,963 40,024 19,403 18,424
64030 - Outsourced Labor 28,351 78,318 15,000 15,000
64062 - Refunds 168 50,779 168 0
64070 - Engineering - Outsourced 416,133 241,425 240,750 292,750
64080 - Insurance - Property 49,097 48,379 87,817 44,021
64081 - Insurance - Liability 35,410 39,457 44,192 42,441
64110 - Legal 0 170 0 500
64130 - Payments to Other Agencies 547,437 599,201 681,962 703,594
64140 - Printing 170 202 262 262
64145 - Copying 833 1,077 833 833
Recommended Operating Expenditure Budget - Department Total
54 - PUBLIC WORKS
Fund/Account/Account Title
FY21 Actual
Expense
FY22 Actual
Expense
FY23 Adopted
Budget
FY 24 Recomm'd
Budget
-104-
64150 - Rental - Equipment 401 247 27,100 27,100
64160 - Rental - Land/Bldgs/Parking 3,877 0 3,877 3,877
64180 - Sales Tax Expense 92,379 123,777 92,379 123,777
64182 - Property Tax 0 0 0 2,309
64185 - License/Permit/Fees 34 84 284 734
64190 - Technology Services 27,589 19,660 11,284 109,897
64195 - Credit Card Charge 30,212 33,048 30,212 33,048
64805 - Shingle Recycling 0 0 0 0
64810 - Applicance Recycling 10,260 8,495 13,500 13,500
64815 - Tire Recycling 80,305 73,280 82,500 82,500
64850 - Consulting Engineers 0 0 0 0
64870 - HVAC Services 0 85 0 0
64900 - Other Professional Service 34,385 42,071 37,457 37,857
64975 - Equip Maint Cont 37,471 53,907 44,531 53,907
64980 - Technology Equip Maint Cont 0 (1,067)2,567 2,567
64983 - Grind Compost Service 90,140 169,790 91,000 96,250
64985 - Hauling Contract 38,471 2,340 3,027 3,027
64990 - Other Contractual Service 121,918 172,837 162,585 187,585
6E - Contractual Svcs Total 2,868,642 2,991,226 3,089,742 3,414,923
6F - Commodities
100 - General
65040 - Small Tools & Equipment 5,782 13,404 4,280 2,500
65045 - Technology Equipment 300 3,577 4,500 9,100
65050 - Other Equipment 0 0 0 0
65055 - Traffic St Light Comp/Equip 46,478 52,483 62,532 62,532
65060 - Office Supplies 2,598 2,733 2,598 3,003
65070 - Operating Supplies 0 0 0 0
65080 - Postage/Shipping 1,367 792 1,395 832
65110 - Signage 38,498 21,033 38,498 29,767
65925 - Uniform Purchase 1,440 998 1,441 1,441
65960 - Repair Parts 4,140 12,097 10,915 12,098
65981 - Street Materials 2,633 578 2,633 1,880
65990 - Other Supplies 1,201 1,631 1,225 1,631
110 - Road Use Tax
65012 - De-Icing Product 4,404 919 4,404 4,404
65038 - Salt 262,670 292,993 384,750 351,600
65040 - Small Tools & Equipment 5,859 4,658 49,731 4,850
65045 - Technology Equipment 0 1,670 1,000 1,000
65050 - Other Equipment 8,616 26,934 34,000 136,000
65054 - Safety Equipment 4,335 2,074 3,400 6,800
65055 - Traffic St Light Comp/Equip 0 0 0 0
65060 - Office Supplies 114 22 114 22
65080 - Postage/Shipping 0 545 0 573
65100 - Safety Supplies 3,145 0 0 0
65925 - Uniform Purchase 8,755 5,795 5,268 5,268
65960 - Repair Parts 13,870 23,264 40,445 15,595
Recommended Operating Expenditure Budget - Department Total
54 - PUBLIC WORKS
Fund/Account/Account Title
FY21 Actual
Expense
FY22 Actual
Expense
FY23 Adopted
Budget
FY 24 Recomm'd
Budget
-105-
65965 - Janitorial 5,632 6,115 5,745 6,115
65980 - Construction Supplies 58,867 51,565 60,044 60,044
65981 - Street Materials 968,672 922,871 1,311,589 948,658
65990 - Other Supplies 1,982 0 2,021 0
605 - Salt Operations
65038 - Salt 103,272 86,346 96,750 87,900
65045 - Technology Equipment 0 0 0 0
610 - Sanitary Sewer Operating
65040 - Small Tools & Equipment 1,390 474 1,418 1,000
65045 - Technology Equipment 0 6,372 250 0
65050 - Other Equipment 3,703 60,255 6,750 0
65054 - Safety Equipment 1,019 1,010 3,500 3,500
65060 - Office Supplies 44 0 44 0
65080 - Postage/Shipping 0 0 0 0
65925 - Uniform Purchase 1,185 1,108 1,185 1,185
65960 - Repair Parts 15,205 21,115 15,509 21,115
65981 - Street Materials 17,477 4,612 17,476 4,612
65982 - Manhole Components 72,910 74,521 92,910 92,910
620 - Stormwater Operating
65040 - Small Tools & Equipment 377 450 1,384 1,000
65050 - Other Equipment 0 0 11,000 15,500
65060 - Office Supplies 22 0 22 0
65080 - Postage/Shipping 0 0 0 0
65925 - Uniform Purchase 916 588 916 916
65960 - Repair Parts 12,553 12,361 12,804 12,361
65981 - Street Materials 17,169 19,556 17,168 19,556
670 - Refuse Collection Operating
65040 - Small Tools & Equipment 0 0 0 0
65045 - Technology Equipment 0 0 0 350
65050 - Other Equipment 0 3,570 0 0
65060 - Office Supplies 140 70 140 70
65080 - Postage/Shipping 230 554 236 581
65925 - Uniform Purchase 4,850 3,571 4,851 4,851
65941 - Food Scrap 0 0 0 0
65943 - Brush Ties 487 418 487 418
65944 - Carts 52,107 182,563 692,134 408,273
65945 - Recycling Containter 18,084 11,801 18,084 19,800
65960 - Repair Parts 796 1,676 812 1,675
65965 - Janitorial 1,063 1,154 1,084 1,154
65981 - Street Materials 28 0 28 0
65990 - Other Supplies 374 0 381 0
811 - Garage Service
65040 - Small Tools & Equipment 5,011 7,676 5,000 5,000
65045 - Technology Equipment 170 290 0 0
65050 - Other Equipment 0 0 0 12,000
65060 - Office Supplies 628 817 628 817
Recommended Operating Expenditure Budget - Department Total
54 - PUBLIC WORKS
Fund/Account/Account Title
FY21 Actual
Expense
FY22 Actual
Expense
FY23 Adopted
Budget
FY 24 Recomm'd
Budget
-106-
65080 - Postage/Shipping 9 0 10 0
65925 - Uniform Purchase 431 0 431 431
65960 - Repair Parts 1,111 1,794 1,134 1,794
65965 - Janitorial 2,019 2,192 2,059 2,192
65985 - Stores Internal Service 686,788 1,093,657 936,357 1,015,632
65990 - Other Supplies 710 0 725 0
950 - DMASWA -General
65012 - De-Icing Product 2,070 2,920 2,070 2,943
65030 - Merchandise for Resale 0 0 0 0
65036 - Beverage/Ice 632 623 632 632
65040 - Small Tools & Equipment 10,522 16,996 22,732 9,207
65045 - Technology Equipment 27,064 75,841 700 7,413
65050 - Other Equipment 5,491 0 59,547 86,050
65060 - Office Supplies 1,872 2,589 1,872 2,589
65080 - Postage/Shipping 1,044 923 1,065 1,769
65100 - Safety Supplies 290 0 296 0
65110 - Signage 0 0 0 2,400
65925 - Uniform Purchase 1,122 90 1,122 1,122
65960 - Repair Parts 19,320 57,489 23,567 57,489
65965 - Janitorial 643 421 656 421
65981 - Street Materials 47,776 29,383 47,777 47,777
65990 - Other Supplies 0 0 0 250
65999 - Cash Over and Short 192 87 0 0
6F - Commodities Total 2,591,672 3,236,680 4,138,231 3,622,368
6G - Capital Outlay
100 - General
67100 - Vehicles 7,000 0 0 12,000
67110 - Mowing Equipment 300 0 0 10,000
67210 - Furniture/Fixtures 0 2,525 0 9,750
67250 - Office Equipment 0 0 0 0
110 - Road Use Tax
67100 - Vehicles 20,990 27,425 19,000 0
67110 - Mowing Equipment 0 0 8,600 2,700
67230 - Heavy Equipment 0 0 126,000 0
67270 - Other Capital Equipment 0 0 0 0
600 - Water Operating
67990 - Other Capital Outlay 1,031 0 0 0
610 - Sanitary Sewer Operating
67100 - Vehicles 0 0 3,500 0
620 - Stormwater Operating
67100 - Vehicles 0 0 0 0
670 - Refuse Collection Operating
67100 - Vehicles 0 0 9,000 70,000
811 - Garage Service
67100 - Vehicles 0 31,282 0 0
950 - DMASWA -General
Recommended Operating Expenditure Budget - Department Total
54 - PUBLIC WORKS
Fund/Account/Account Title
FY21 Actual
Expense
FY22 Actual
Expense
FY23 Adopted
Budget
FY 24 Recomm'd
Budget
-107-
67100 - Vehicles 0 38,150 0 0
67210 - Furniture/Fixtures 587 0 0 0
67230 - Heavy Equipment 59,730 125,742 23,416 0
67270 - Other Capital Equipment 0 0 0 0
67500 - Buildings 0 0 0 0
6G - Capital Outlay Total 89,638 225,124 189,516 104,450
6H - Debt Service
200 - Debt Service
68010 - Principal Payment 525,196 107,557 66,830 68,730
68020 - Interest Payments 27,558 18,969 16,820 15,167
68980 - Financial Consultant 733 0 0 0
670 - Refuse Collection Operating
68010 - Principal Payment 5,351 5,780 6,038 6,396
68020 - Interest Payments 1,925 1,783 2,866 1,447
68980 - Financial Consultant 0 0 0 0
950 - DMASWA -General
68010 - Principal Payment 425,000 435,000 450,000 465,000
68020 - Interest Payments 238,359 225,609 210,459 198,609
68980 - Financial Consultant 15,450 900 7,950 7,500
68990 - Paying Agent Fees 2,450 2,000 2,450 2,000
6H - Debt Service Total 1,242,022 797,598 763,413 764,849
6I - Transfers
670 - Refuse Collection Operating
69100 - Transfers Out To General Fund 1,191,482 1,219,202 1,305,346 1,508,564
69671 - Transfers Out to Refuse Cap 0 0 0 325,000
950 - DMASWA -General
69100 - Transfers Out To General Fund 420,846 440,255 477,980 524,622
6I - Transfers Total 1,612,328 1,659,457 1,783,326 2,358,186
PUBLIC WORKS - Total 18,861,955 20,008,980 21,768,938 22,897,195
Recommended Operating Expenditure Budget - Department Total
54 - PUBLIC WORKS
Fund/Account/Account Title
FY21 Actual
Expense
FY22 Actual
Expense
FY23 Adopted
Budget
FY 24 Recomm'd
Budget
-108-
5401 - Administration
100 - General
6A - Salaries & Wages 382,600 429,089 570,949
6B - Employee Benefits 128,835 140,124 191,197
6C - Staff Development 13,293 26,244 28,408
6D - Repair/Maint/Util 7,183 6,629 6,586
6E - Contractual Svcs -528,386 -515,578 -802,370
6F - Commodities 3,049 7,247 7,407
6G - Capital Outlay 2,525 —9,750
5401 - Administration Total 9,098 93,755 11,927
5402 - Riverfront Management
100 - General
6A - Salaries & Wages 25,990 15,515 18,211
6B - Employee Benefits 5,882 4,871 5,540
6D - Repair/Maint/Util 26,339 22,156 31,338
6E - Contractual Svcs 7,445 8,203 11,211
6F - Commodities 5,140 5,012 5,908
6G - Capital Outlay 0 0 10,000
5402 - Riverfront Management Total 70,796 55,757 82,208
5403 - Floodwall Operations Maint
100 - General
6A - Salaries & Wages 10,223 40,353 40,602
6B - Employee Benefits 7,850 13,127 13,140
6D - Repair/Maint/Util 31,183 63,216 31,515
6E - Contractual Svcs 78,287 85,756 91,203
6F - Commodities 4,398 5,082 4,398
5403 - Floodwall Operations Maint Total 131,940 207,534 180,858
5404 - Street and Traffic Lighting
100 - General
6A - Salaries & Wages 171,722 211,876 208,003
6B - Employee Benefits 75,568 83,245 84,002
6C - Staff Development 2,413 5,300 5,300
6D - Repair/Maint/Util 34,186 20,013 33,329
6E - Contractual Svcs 21,022 23,137 27,242
6F - Commodities 67,168 68,148 66,282
6G - Capital Outlay 0 0 12,000
110 - Road Use Tax
6C - Staff Development 0 0 0
6D - Repair/Maint/Util 786,900 760,221 786,900
6F - Commodities 0 0 0
5404 - Street and Traffic Lighting Total 1,158,978 1,171,940 1,223,058
5405 - Street Signs and Markings
100 - General
6A - Salaries & Wages 84,570 74,592 110,818
Recommended Expenditure Budget Report by Activity & Funding Source
54 - PUBLIC WORKS
Fund/Activity FY22 Actual Expense FY23 Adopted Budget
FY24 Recomm'd
Budget
-109-
6B - Employee Benefits 31,996 34,127 44,872
6C - Staff Development 0 0 0
6D - Repair/Maint/Util 3,007 5,973 4,043
6E - Contractual Svcs 22,180 35,252 39,767
6F - Commodities 21,262 39,752 31,017
5405 - Street Signs and Markings Total 163,014 189,696 230,517
5406 - Street Maintenance
100 - General
6A - Salaries & Wages 0 0 0
6B - Employee Benefits 0 0 0
6E - Contractual Svcs 123 0 123
6F - Commodities 3,159 0 4,600
110 - Road Use Tax
6A - Salaries & Wages 1,151,287 1,098,172 1,129,983
6B - Employee Benefits 501,587 499,865 491,860
6C - Staff Development 3,399 9,066 9,066
6D - Repair/Maint/Util 421,776 349,920 444,111
6E - Contractual Svcs 232,541 248,922 306,111
6F - Commodities 1,016,004 1,482,103 1,133,704
6G - Capital Outlay 27,425 143,000 0
5406 - Street Maintenance Total 3,357,300 3,831,048 3,519,558
5407 - Street Cleaning
100 - General
6A - Salaries & Wages (505)0 0
6B - Employee Benefits 110 0 0
110 - Road Use Tax
6A - Salaries & Wages 214,582 255,405 271,129
6B - Employee Benefits 102,615 112,152 113,344
6D - Repair/Maint/Util 277,068 219,308 266,559
6E - Contractual Svcs 98,610 106,807 111,081
6F - Commodities 2,626 25,158 2,626
6G - Capital Outlay 0 10,600 2,700
5407 - Street Cleaning Total 695,105 729,430 767,439
5408 - Snow and Ice Control
110 - Road Use Tax
6A - Salaries & Wages 239,047 545,672 537,920
6B - Employee Benefits 143,932 205,762 203,985
6C - Staff Development 32 32,700 32,700
6D - Repair/Maint/Util 410,551 374,017 410,773
6E - Contractual Svcs 167,487 251,998 299,871
6F - Commodities 320,794 395,250 404,599
6G - Capital Outlay 0 0 0
5408 - Snow and Ice Control Total 1,281,842 1,805,399 1,889,848
5409 - One Call Location Service
100 - General
Recommended Expenditure Budget Report by Activity & Funding Source
54 - PUBLIC WORKS
Fund/Activity FY22 Actual Expense FY23 Adopted Budget
FY24 Recomm'd
Budget
-110-
6E - Contractual Svcs 7,406 29,306 29,306
5409 - One Call Location Service Total 7,406 29,306 29,306
5410 - Port of Dubuque Maintenance
100 - General
6A - Salaries & Wages 50,033 102,933 105,464
6B - Employee Benefits 17,187 37,379 38,720
6D - Repair/Maint/Util 49,573 46,849 48,036
6E - Contractual Svcs 37,661 55,159 59,801
6F - Commodities 5,149 4,776 5,172
5410 - Port of Dubuque Maintenance Total 159,603 247,096 257,193
5411 - Solid Waste Collection
670 - Refuse Collection Operating
6A - Salaries & Wages 665,279 701,802 723,087
6B - Employee Benefits 301,377 340,787 329,645
6C - Staff Development 2,606 3,468 3,615
6D - Repair/Maint/Util 259,786 220,440 240,450
6E - Contractual Svcs 556,701 565,789 636,868
6F - Commodities 143,101 656,974 341,479
6G - Capital Outlay 0 9,000 0
6I - Transfers 1,219,202 1,305,346 1,833,564
5411 - Solid Waste Collection Total 3,148,053 3,803,606 4,108,708
5412 - Yard Waste Collection
670 - Refuse Collection Operating
6A - Salaries & Wages 91,154 114,639 115,708
6B - Employee Benefits 40,789 44,973 55,133
6D - Repair/Maint/Util 27,931 18,889 20,944
6E - Contractual Svcs 53,701 71,328 65,683
6F - Commodities 6,831 10,563 11,356
5412 - Yard Waste Collection Total 220,406 260,392 268,824
5413 - Large Item Collection
180 - Community Development
6E - Contractual Svcs 38,976 0 0
670 - Refuse Collection Operating
6A - Salaries & Wages 7,867 11,321 20,481
6B - Employee Benefits 3,939 4,670 6,366
6D - Repair/Maint/Util 15,560 8,405 10,012
6E - Contractual Svcs 57,042 53,961 75,853
6G - Capital Outlay 0 0 70,000
5413 - Large Item Collection Total 123,383 78,357 182,712
5414 - Recycling Collection
670 - Refuse Collection Operating
6A - Salaries & Wages 434,465 462,142 476,590
6B - Employee Benefits 203,968 223,514 221,888
6C - Staff Development 0 654 654
6D - Repair/Maint/Util 237,944 168,336 179,816
Recommended Expenditure Budget Report by Activity & Funding Source
54 - PUBLIC WORKS
Fund/Activity FY22 Actual Expense FY23 Adopted Budget
FY24 Recomm'd
Budget
-111-
6E - Contractual Svcs 43,262 92,312 129,490
6F - Commodities 55,445 50,700 84,337
5414 - Recycling Collection Total 975,084 997,658 1,092,775
5415 - Garage Services
811 - Garage Service
6A - Salaries & Wages 719,733 792,431 822,184
6B - Employee Benefits 291,042 313,794 318,669
6C - Staff Development 1,862 12,738 12,738
6D - Repair/Maint/Util 146,646 109,359 147,339
6E - Contractual Svcs 87,437 60,937 167,559
6F - Commodities 1,106,426 946,344 1,037,866
6G - Capital Outlay 31,282 0 0
5415 - Garage Services Total 2,384,428 2,235,603 2,506,355
5416 - Sanitary Sewer Maintenance
610 - Sanitary Sewer Operating
6A - Salaries & Wages 315,799 313,378 324,466
6B - Employee Benefits 123,832 129,205 130,526
6C - Staff Development 4,149 8,000 8,030
6D - Repair/Maint/Util 63,796 39,342 54,944
6E - Contractual Svcs 75,230 81,649 87,413
6F - Commodities 169,466 139,042 124,322
6G - Capital Outlay 0 3,500 0
5416 - Sanitary Sewer Maintenance Total 752,273 714,116 729,701
5417 - Stormwater Maintenance
620 - Stormwater Operating
6A - Salaries & Wages 106,316 132,326 133,647
6B - Employee Benefits 46,332 52,634 52,742
6C - Staff Development 0 300 300
6D - Repair/Maint/Util 15,310 25,481 26,002
6E - Contractual Svcs 29,797 32,272 36,443
6F - Commodities 32,955 43,294 49,333
6G - Capital Outlay 0 0 0
5417 - Stormwater Maintenance Total 230,710 286,307 298,467
5418 - Salt Operations
605 - Salt Operations
6D - Repair/Maint/Util 0 0 0
6E - Contractual Svcs 15,280 16,812 17,408
6F - Commodities 86,346 96,750 87,900
5418 - Salt Operations Total 101,627 113,562 105,308
5419 - Landfill
950 - DMASWA -General
6A - Salaries & Wages 579,881 635,805 612,846
6B - Employee Benefits 245,061 268,170 267,159
6C - Staff Development 14,747 18,361 14,202
6D - Repair/Maint/Util 557,221 421,679 562,231
Recommended Expenditure Budget Report by Activity & Funding Source
54 - PUBLIC WORKS
Fund/Activity FY22 Actual Expense FY23 Adopted Budget
FY24 Recomm'd
Budget
-112-
6E - Contractual Svcs 1,175,027 1,100,147 1,289,757
6F - Commodities 155,093 137,732 184,905
6G - Capital Outlay 163,892 23,416 0
6H - Debt Service 663,509 670,859 673,109
6I - Transfers 440,255 477,980 524,622
5419 - Landfill Total 3,994,685 3,754,149 4,128,831
5420 - Composting
950 - DMASWA -General
6A - Salaries & Wages 4,648 32,720 33,888
6B - Employee Benefits 8,572 14,732 14,711
6C - Staff Development 850 13,670 7,035
6E - Contractual Svcs 177,790 103,557 113,145
6F - Commodities 0 110 800
5420 - Composting Total 191,860 164,789 169,579
5421 - Household Hazardous Waste
950 - DMASWA -General
6A - Salaries & Wages 27,930 60,740 94,340
6B - Employee Benefits 23,230 42,418 41,623
6C - Staff Development 3,475 6,393 7,200
6D - Repair/Maint/Util 3,356 2,935 2,333
6E - Contractual Svcs 51,859 102,623 100,341
6F - Commodities 8,585 11,767 8,075
6G - Capital Outlay 0 0 0
5421 - Household Hazardous Waste Total 118,433 226,876 253,912
5422 - Education and Outreach
950 - DMASWA -General
6A - Salaries & Wages 2,201 12,206 12,226
6B - Employee Benefits 2,341 4,129 4,133
6C - Staff Development 11,660 16,896 17,021
6E - Contractual Svcs 150,720 159,212 186,475
6F - Commodities 225 650 225
5422 - Education and Outreach Total 167,147 193,093 220,080
5423 - E-Waste
950 - DMASWA -General
6A - Salaries & Wages 17,751 43,849 74,898
6B - Employee Benefits 14,439 33,190 32,077
6D - Repair/Maint/Util 0 0 1,300
6E - Contractual Svcs 52,298 84,138 65,744
6F - Commodities 1,041 500 1,041
5423 - E-Waste Total 85,529 161,677 175,060
5425 - Gas System
950 - DMASWA -General
6A - Salaries & Wages 12,919 26,919 26,802
6B - Employee Benefits 8,611 11,788 11,673
6C - Staff Development 475 1,227 1,227
Recommended Expenditure Budget Report by Activity & Funding Source
54 - PUBLIC WORKS
Fund/Activity FY22 Actual Expense FY23 Adopted Budget
FY24 Recomm'd
Budget
-113-
6D - Repair/Maint/Util 14,955 14,198 14,955
6E - Contractual Svcs 75,583 33,534 37,369
6F - Commodities 7,016 3,924 7,016
5425 - Gas System Total 119,558 91,590 99,042
5426 - Rural Recycling
950 - DMASWA -General
6A - Salaries & Wages 463 16,727 17,083
6B - Employee Benefits 3,829 7,059 7,077
6E - Contractual Svcs 206,151 202,509 232,029
6F - Commodities 15,400 7,353 18,000
5426 - Rural Recycling Total 225,843 233,648 274,189
5427 - Street Parking Meters
650 - Parking Operating
6A - Salaries & Wages 0 0 0
6B - Employee Benefits 0 0 0
5427 - Street Parking Meters Total 0 0 0
5428 - Water Main Replacement
600 - Water Operating
6A - Salaries & Wages 508 0 0
6B - Employee Benefits 280 0 0
6G - Capital Outlay 0 0 0
5428 - Water Main Replacement Total 788 0 0
5429 - Parks Assistance
100 - General
6A - Salaries & Wages 0 0 0
6B - Employee Benefits 0 0 0
5429 - Parks Assistance Total 0 0 0
5480 - Debt Service
200 - Debt Service
6E - Contractual Svcs 0 0 0
6H - Debt Service 126,526 83,650 83,897
670 - Refuse Collection Operating
6H - Debt Service 7,563 8,904 7,843
5480 - Debt Service Total 134,089 92,554 91,740
5499 - Pcard Clearing
100 - General
6F - Commodities 0 0 0
5499 - Pcard Clearing Total 0 0 0
PUBLIC WORKS TOTAL 20,008,980 21,768,938 22,897,195
Recommended Expenditure Budget Report by Activity & Funding Source
54 - PUBLIC WORKS
Fund/Activity FY22 Actual Expense FY23 Adopted Budget
FY24 Recomm'd
Budget
-114-
61010 Full Time Employee Expense
100 3325 GE-41 PUBLIC WORKS DIRECTOR 1.00 $ 123,103 1.00 $ 127,093 1.00 $ 132,936
100 1490 GE-38 ASST PUBLIC WORKS DIRECTOR 1.00 $ 88,727 1.00 $ 97,669 1.00 $ 107,809
810 3225 GE-35 EQUIP MAINT. SUPERVISOR 1.00 $ 80,601 1.00 $ 87,654 1.00 $ 92,153
670 6100 GE-35 RESOURCE MGMT SUPERVISOR 1.00 $ 85,640 1.00 $ 70,824 1.00 $ 77,615
940 2625 GE-36 DMASWA ADMINISTRATOR 1.00 $ 78,456 1.00 $ 85,034 1.00 $ 95,140
940 2625 GE-35 LANDFILL SUPERVISOR 1.00 $ 86,101 1.00 $ 89,409 1.00 $ 74,081
100 2925 GD-12 TRAFFIC SIGNAL TECHNICIAN II 2.88 $ 193,444 2.88 $ 201,776 2.88 $ 197,894
250 2925 GD-12 TRAFFIC SIGNAL TECH II 0.12 $ 8,059 0.12 $ 8,408 0.12 $ 8,214
100 GE-28 LEAD ADMINISTRATIVE ASSISTANT —$ — 1.00 $ 60,904 1.00 $ 51,146
100 225 GE-25 SECRETARY 2.00 $ 94,112 2.00 $ 99,712 3.00 $ 152,094
100 2655 GD-11 FOREPERSON 0.08 $ 5,073 0.08 $ 5,224 0.08 $ 5,422
250 2655 GD-11 FOREPERSON 4.18 $ 262,992 4.18 $ 270,568 4.18 $ 283,250
610 2655 GD-11 FOREPERSON 0.92 $ 56,451 0.92 $ 60,208 0.92 $ 62,814
620 2655 GD-11 FOREPERSON 0.82 $ 52,156 0.82 $ 54,122 0.82 $ 55,175
940 2655 GD-11 FOREPERSON 1.00 $ 61,903 1.00 $ 64,176 1.00 $ 67,300
100 GE-35 FIELD SUPERVISOR 0.10 $ 7,202 0.10 $ 7,436 0.10 $ 7,778
250 GE-35 FIELD SUPERVISOR 0.90 $ 64,818 0.90 $ 82,833 0.90 $ 86,642
670 2655 GD-11 LEAD SANITATION DRIVER 1.00 $ 64,610 1.00 $ 66,716 1.00 $ 59,994
810 7250 GD-11 LEAD MECHANIC 2.00 $ 125,738 2.00 $ 130,103 2.00 $ 136,451
810 2525 GD-10 MECHANIC 7.00 $ 409,485 7.00 $ 428,559 7.00 $ 452,835
940 2525 GD-11 MECHANIC 1.00 $ 63,810 1.00 $ 66,070 1.00 $ 66,875
100 2300 GD-08 EQUIPMENT OPERATOR II 0.54 $ 31,389 1.25 $ 75,718 1.00 $ 63,758
250 2300 GD-08 EQUIPMENT OPERATOR II 5.61 $ 326,428 4.88 $ 288,482 5.03 $ 309,003
610 2300 GD-08 EQUIPMENT OPERATOR II 0.87 $ 48,044 0.87 $ 52,347 0.87 $ 54,811
620 2300 GD-08 EQUIPMENT OPERATOR II 0.10 $ 5,487 0.10 $ 6,047 0.10 $ 6,324
940 2300 GD-08 EQUIPMENT OPERATOR II 1.00 $ 60,291 1.00 $ 62,242 1.00 $ 55,190
940 GD-08 LANDFILL EQUIP OPERATOR 4.00 $ 231,402 4.00 $ 229,224 4.00 $ 248,977
810 GE-27 INVENTORY/ACCOUNT CLERK —$ — 1.00 $ 46,082 1.00 $ 48,201
250 GD-05 UTILITY WORKER 6.80 $ 360,827 9.87 $ 539,283 9.87 $ 570,978
610 GD-05 UTILITY WORKER 0.20 $ 11,029 0.30 $ 16,092 0.30 $ 17,506
250 NA-48 UTILITY WORKER APPRENTICE 1.00 $ 42,235 1.00 $ 41,196 1.00 $ 44,248
670 GD-04 SANITATION LABORER 1.00 $ 56,783 —$ — —$ —
670 GD-06 YARD WASTE & SNOWFIGHTER —$ — 0.58 $ 30,168 0.58 $ 32,124
250 GD-06 YARD WASTE & SNOWFIGHTER —$ — 0.42 $ 22,124 0.42 $ 23,263
810 835 GD-03 STOCK CLERK 2.00 $ 100,328 1.00 $ 52,073 1.00 $ 48,572
100 2375 GD-06 EQUIPMENT OPERATOR I 1.65 $ 92,956 1.72 $ 99,535 1.72 $ 104,027
250 2375 GD-06 EQUIPMENT OPERATOR I 6.14 $ 346,847 6.92 $ 401,934 6.19 $ 369,570
610 2375 GD-06 EQUIPMENT OPERATOR I 2.97 $ 169,427 2.97 $ 171,548 2.97 $ 172,101
620 2375 GD-06 EQUIPMENT OPERATOR I 1.12 $ 62,715 1.12 $ 64,792 1.12 $ 65,262
670 1300 GD-06 SANITATION DRIVER 17.00 $ 965,873 18.00 $ 1,045,608 18.00 $ 1,088,832
250 GD-06 ASSISTANT HORTICULTURALIST 0.42 $ 22,154 0.42 $ 23,463 0.42 $ 24,540
250 1475 GD-05 TRUCK DRIVER 3.90 $ 219,660 —$ — —$ —
610 1475 GD-05 TRUCK DRIVER 0.10 $ 5,710 —$ — —$ —
940 870 GD-04 SCALE HOUSE OPERATOR 2.00 $ 100,973 2.00 $ 105,733 2.00 $ 112,996
100 811 NA-50 ACCOUNT CLERK II 1.00 $ 59,261 —$ — —$ —
TOTAL FULL TIME EMPLOYEES 89.42 $ 5,332,300 90.42 $ 5,538,189 93.42 $ 5,923,358
C I T Y O F D U B U Q U E , I O W A
DEPARTMENT DETAIL - PERSONNEL COMPLEMENT
54 PUBLIC WORKS DEPARTMENT
FY 2022 FY 2023 FY 2024
FD JC WP-GR JOB CLASS FTE BUDGET FTE BUDGET FTE BUDGET
-115-
61020 Part Time Employee Expense
250 GD-03 CUSTODIAN I 0.38 $ 18,789 0.38 $ 19,400 0.38 $ 20,292
670 GD-03 CUSTODIAN I 0.08 $ 3,956 0.08 $ 4,084 0.08 $ 4,272
810 GD-03 CUSTODIAN I 0.15 $ 7,417 0.15 $ 7,658 0.15 $ 8,010
100 GE-25 SECRETARY —$ — 0.67 $ 26,314 0.67 $ 32,295
TOTAL PART TIME EMPLOYEES 0.61 $ 30,162 1.28 $ 57,456 1.28 $ 64,869
61030 Seasonal Employee Expense
670 1325 NA-26 SANITATION DRIVER 0.67 $ 22,061 0.08 $ 2,719 —$ —
670 NA-38 RESOURCE MGMT INTERN —$ — —$ — 0.30 $ 11,512
940 1325 GD-26 EQUIPMENT OPERATOR 0.75 $ 24,696 0.75 $ 25,494 —$ —
100 898 GD-21 LABORER-ST/W/WW-SEASONAL 1.47 $ 37,452 0.63 $ 20,922 0.61 $ 21,198
250 898 GD-21 LABORER-ST/W/WW-SEASONAL 0.36 $ 8,915 0.27 $ 8,913 0.12 $ 15,034
TOTAL SEASONAL EMPLOYEES 3.25 $ 93,124 1.73 $ 58,048 1.03 $ 47,744
TOTAL PUBLIC WORKS DEPARTMENT 93.28 $ 5,455,586 93.43 $ 5,653,693 95.73 $ 6,035,971
C I T Y O F D U B U Q U E , I O W A
DEPARTMENT DETAIL - PERSONNEL COMPLEMENT
54 PUBLIC WORKS DEPARTMENT
FY 2022 FY 2023 FY 2024
FD JC WP-GR JOB CLASS FTE BUDGET FTE BUDGET FTE BUDGET
-116-
Public Works Administration-FT
10054100 61010 100 3325 GE-41 PUBLIC WORKS DIRECTOR 1.00 $ 123,103 1.00 $ 127,093 1.00 $ 132,936
10054100 61010 100 1490 GE-38
ASST PUBLIC WORKS
DIRECTOR 1.00 $ 88,727 1.00 $ 97,669 1.00 $ 107,809
10054100 61010 100 GE-28
LEAD ADMINISTRATIVE
ASSISTANT —$ — 1.00 $ 60,904 1.00 $ 51,146
10054100 61010 100 GE-37 DATA SCIENTIST —$ — —$ — 1.00 $ 84,560
10054100 61010 100 225 GE-25
ADMINISTRATIVE
ASSISTANT 2.00 $ 94,112 2.00 $ 99,712 3.00 $ 152,094
10054100 61010 100 811 NA-50 ACCOUNT CLERK II 1.00 $ 59,261 —$ — —$ —
Total 5.00 $ 365,203 5.00 $ 385,378 7.00 $ 528,545
Public Works Administration-Part-Time
10054100 61030 100 225 GE-25 SECRETARY —$ — 0.67 $ 26,314 0.67 $ 32,295
Total —$ — 0.67 $ 26,314 0.67 $ 32,295
Riverfront Management-FT General Fund
10054330 61010 100 2375 GD-08 EQUIPMENT OPERATOR II —$ — 0.10 $ 6,106 0.10 $ 6,386
10054330 61010 100 GD-06 EQUIPMENT OPERATOR I 0.10 $ 5,776 0.05 $ 2,853 0.05 $ 3,028
Total 0.10 $ 5,776 0.15 $ 8,959 0.15 $ 9,414
Riverfront Management-Seasonal General Fund
10054330 61030 100 898 GD-21 LABORER-ST/W/WW-TEMP 0.10 $ 2,633 0.08 $ 2,766 0.08 $ 5,011
Total 0.10 $ 2,633 0.08 $ 2,766 0.08 $ 5,011
Floodwall Oper./Maintenance
10054340 61010 100 2300 GD-08 EQUIPMENT OPERATOR II 0.12 $ 7,005 0.12 $ 7,257 0.12 $ 7,651
10054340 61010 100 2655 GD-11 FOREPERSON 0.08 $ 5,073 0.08 $ 5,224 0.08 $ 5,422
10054340 61010 100 GE-31 FIELD SUPERVISOR 0.10 $ 7,202 0.10 $ 7,436 0.10 $ 7,778
10054340 61010 100 2375 GD-06 EQUIPMENT OPERATOR I 0.10 $ 5,674 0.10 $ 5,779 0.10 $ 5,810
Total 0.40 $ 24,954 0.40 $ 25,696 0.40 $ 26,661
Floodwall Oper./Maintenance-Seasonal
10054340 61030 100 898 GD-21 LABORER-ST/W/WW-TEMP 0.13 $ 3,219 0.10 $ 3,301 0.08 $ 2,585
Total 0.13 $ 3,219 0.10 $ 3,301 0.08 $ 2,585
Street & Traffic Lighting-FT General Fund
10054430 61010 100 2300 GD-08 EQUIPMENT OPERATOR II 0.02 $ 1,100 —$ — —$ —
10054430 61010 100 GD-06 EQUIPMENT OPERATOR I —$ — 0.02 $ 1,158 0.02 $ 1,215
10054430 61010 100 2925 GD-12
TRAFFIC SIGNAL
TECHNICIAN II 2.86 $ 192,010 2.86 $ 200,284 2.86 $ 196,330
Total 2.88 $ 193,110 2.88 $ 201,442 2.88 $ 197,545
Street Signs & Markings-FT General Fund
10054435 61010 100 2925 GD-12
TRAFFIC SIGNAL
TECHNICIAN II 0.01 $ 717 0.01 $ 746 0.01 $ 782
10054435 61010 100 2375 GD-06 EQUIPMENT OPERATOR I 0.82 $ 45,113 0.82 $ 47,478 0.82 $ 49,764
10054435 61010 100 2300 GD-08 EQUIPMENT OPERATOR II 0.40 $ 23,284 0.40 $ 23,890 0.15 $ 9,487
Total 1.23 $ 69,114 1.23 $ 72,114 1.81 $ 108,320
Street Signs & Markings-Seasonal General Fund
CITY OF DUBUQUE, IOWA
ACTIVITY PERSONNEL COMPLEMENT SUMMARY
FY 2022 FY 2023 FY 2024
ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET
-117-
10054435 61030 100 898 NA-01 LABORER-ST/W/WW-TEMP 0.67 $ 16,592 —$ — —$ —
Total 0.67 $ 16,592 —$ — —$ —
Port of Dubuque Maintenance-FT
10054450 61010 100 2925 GD-12
TRAFFIC SIGNAL
TECHNICIAN II 0.01 $ 717 0.01 $ 746 0.01 $ 782
10054450 61010 100 2300 GD-08 EQUIPMENT OPERATOR II —$ — 0.63 $ 38,465 0.63 $ 40,234
10054450 61010 100 1475 GD-06 EQUIPMENT OPERATOR I 0.63 $ 36,393 0.73 $ 42,267 0.73 $ 44,210
Total 0.64 $ 37,110 1.37 $ 81,478 1.37 $ 85,226
Port of Dubuque Maintenance-Seasonal
10054450 61030 100 898 GD-21 LABORER-ST/W/WW-TEMP 0.57 $ 15,008 0.45 $ 14,855 0.45 $ 13,602
Total 0.57 $ 15,008 0.45 $ 14,855 0.45 $ 13,602
Street Maintenance-FT Road Use Tax Fund
25054400 61010 250 GD-06
ASSISTANT
HORTICULTURALIST 0.25 $ 13,187 0.25 $ 13,966 0.25 $ 14,607
25054400 61010 250 GD-05 UTILITY WORKER 5.63 $ 298,518 6.46 $ 349,307 6.46 $ 370,973
25054400 61010 NA-48
UTILITY WORKER
APPRENTICE 0.83 $ 35,054 0.83 $ 34,193 0.83 $ 36,726
25054400 61010 250 2300 GD-08 EQUIPMENT OPERATOR II 2.68 $ 154,876 1.94 $ 116,180 2.09 $ 129,165
25054400 61010 250 2375 GD-06 EQUIPMENT OPERATOR I 3.32 $ 186,829 4.11 $ 239,973 3.38 $ 204,654
25054400 61010 250 2655 GD-11 FOREPERSON 3.20 $ 201,343 3.20 $ 206,847 3.20 $ 216,918
25054400 61010 250 GE-35 FIELD SUPERVISOR 0.73 $ 52,575 0.73 $ 67,187 0.73 $ 70,277
25054400 61010 250 1475 GD-05 TRUCK DRIVER 1.66 $ 93,437 —$ — —$ —
Total 18.30 $ 1,035,819 17.52 $ 1,027,653 17.19 $ 1,057,167
Street Maintenance-PT Road Use Tax Fund
25054400 61020 250 GD-03 CUSTODIAN I 0.38 $ 18,789 0.38 $ 19,400 0.38 $ 20,292
Total 0.38 $ 18,789 0.38 $ 19,400 0.38 $ 20,292
Street Cleaning-Full Time Road Use Tax Fund
25054410 61010 250 1475 GD-05 TRUCK DRIVER 1.56 $ 87,906 —$ — —$ —
25054410 61010 250 GD-05 UTILITY WORKER —$ — 1.56 $ 89,254 1.56 $ 93,549
25054410 61010 250 2375 GD-06 EQUIPMENT OPERATOR I 0.83 $ 47,480 0.83 $ 48,057 0.83 $ 48,529
25054410 61010 250 2300 GD-08 EQUIPMENT OPERATOR II 1.77 $ 104,149 1.77 $ 102,603 1.77 $ 107,319
Total 4.16 $ 239,535 4.16 $ 239,914 4.16 $ 249,397
Street Cleaning-Seasonal-Road Use Tax Fund
25054410 61030 250 898 GD-21 LABORER-ST/W/WW-TEMP 0.36 $ 8,915 0.27 $ 8,913 0.12 $ 15,034
Total 0.36 $ 8,915 0.27 $ 8,913 0.12 $ 15,034
Snow Removal-FT
25054420 61010 250 2925 GD-12 TRAFFIC SIGNAL TECH II 0.12 $ 8,059 0.12 $ 8,408 0.12 $ 8,214
25054420 61010 250 GD-05 UTILITY WORKER 1.17 $ 62,309 1.85 $ 100,722 1.85 $ 106,456
25054400 61010 NA-48
UTILITY WORKER
APPRENTICE 0.17 $ 7,181 0.17 $ 7,003 0.17 $ 7,522
CITY OF DUBUQUE, IOWA
ACTIVITY PERSONNEL COMPLEMENT SUMMARY
FY 2022 FY 2023 FY 2024
ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET
-118-
25054420 61010 250 GD-06
ASSISTANT
HORTICULTURALIST 0.17 $ 8,967 0.17 $ 9,497 0.17 $ 9,933
25054420 61010 250 2655 GD-11 FOREPERSON 0.98 $ 61,649 0.98 $ 63,721 0.98 $ 66,332
25054420 61010 250 GE-35 FIELD SUPERVISOR 0.17 $ 12,243 0.17 $ 15,646 0.17 $ 16,365
25054420 61010 250 2300 GD-08 EQUIPMENT OPERATOR II 1.16 $ 67,403 1.17 $ 69,699 1.17 $ 72,519
25054420 61010 250 2375 GD-06 EQUIPMENT OPERATOR I 1.99 $ 112,538 1.98 $ 113,904 1.98 $ 116,387
25054420 61010 250 GD-06
YARD WASTE &
SNOWFIGHTER —$ — 0.42 $ 22,124 0.17 $ 9,416
25054420 61010 250 1475 GD-05 TRUCK DRIVER 0.68 $ 38,317 —$ — —$ —
Total 6.61 $ 378,666 7.03 $ 410,724 6.78 $ 413,144
Sanitary Sewer Maintenance-FT Sewer Use Fund
61054300 61010 610 2375 GD-06 EQUIPMENT OPERATOR I 2.97 $ 169,427 2.97 $ 171,548 2.97 $ 172,101
61054300 61010 610 GD-05 UTILITY WORKER 0.20 $ 11,029 0.30 $ 16,092 0.30 $ 17,506
61054300 61010 610 2300 GD-08 EQUIPMENT OPERATOR II 0.87 $ 48,044 0.87 $ 52,347 0.87 $ 54,811
61054300 61010 610 1475 GD-05 TRUCK DRIVER 0.10 $ 5,710 —$ — —$ —
61054300 61010 610 2655 GD-11 FOREPERSON 0.92 $ 56,451 0.92 $ 60,208 0.92 $ 62,814
Total 5.06 $ 290,661 5.06 $ 300,195 5.06 $ 307,232
Storm Sewer Maintenance-FT Stormwater Fund
62054310 61010 620 2300 GD-08 EQUIPMENT OPERATOR II 0.10 $ 5,487 0.10 $ 6,047 0.10 $ 6,324
62054310 61010 620 2375 GD-06 EQUIPMENT OPERATOR I 1.12 $ 62,715 1.12 $ 64,792 1.12 $ 65,262
62054310 61010 620 2655 GD-11 FOREPERSON 0.82 $ 52,156 0.82 $ 54,122 0.82 $ 55,175
Total 2.04 $ 120,358 2.04 $ 124,961 2.04 $ 126,761
Refuse Collection-FT Refuse Fund
67054500 61010 670 6100 GE-35
RESOURCE MGMT
SUPERVISOR 0.40 $ 34,257 0.40 $ 28,330 0.40 $ 31,046
67054500 61010 670 2655 GD-11 LEAD SANITATION DRIVER 0.40 $ 25,844 0.40 $ 26,686 0.40 $ 23,998
67054500 61010 670 GD-04 SANITATION LABORER 1.00 $ 56,783 —$ — —$ —
67054500 61010 670 1300 GD-06 SANITATION DRIVER 9.15 $ 522,048 10.15 $ 595,359 10.15 $ 618,174
Total 10.95 $ 638,932 10.95 $ 650,375 10.95 $ 673,218
Refuse Collection-PT
67054500 61020 670 GD-03 CUSTODIAN I 0.08 $ 3,956 0.08 $ 4,084 0.08 $ 4,272
Total 0.08 $ 3,956 0.08 $ 4,084 0.08 $ 4,272
Refuse Collection-Seasonal Refuse Fund
67054500 61030 670 NA-38F RESOURCE MGMT INTERN —$ — —$ — 0.30 $ 11,512
67054500 61030 670 898 NA-01 LABORER-ST/W/WW-TEMP 0.09 $ 2,963 —$ — —$ —
Total 0.09 $ 2,963 —$ — 0.30 $ 11,512
Yard Waste Collection-FT Refuse Fund
67054510 61010 670 2655 GD-11 LEAD SANITATION DRIVER 0.10 $ 6,461 0.10 $ 6,672 0.10 $ 5,999
67054510 61010 670 1300 GD-06 SANITATION DRIVER 1.15 $ 65,359 1.15 $ 67,796 1.15 $ 71,338
67054510 61010 670 GD-06
YARD WASTE &
SNOWFIGHTER —$ — 0.58 $ 30,168 0.50 $ 27,693
67054510 61010 670 6100 GE-35
RESOURCE MGMT
SUPERVISOR 0.10 $ 8,563 0.10 $ 7,082 0.10 $ 7,761
CITY OF DUBUQUE, IOWA
ACTIVITY PERSONNEL COMPLEMENT SUMMARY
FY 2022 FY 2023 FY 2024
ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET
-119-
Total 1.35 $ 80,383 1.93 $ 111,718 1.85 $ 112,791
Yard Waste Collection-Seasonal Refuse Fund
67054510 61030 670 1325 NA-26 SANITATION DRIVER 0.50 $ 16,464 —$ — —$ —
Total 0.50 $ 16,464 —$ — —$ —
Large Item Collection-FT Refuse Fund
67054520 61010 670 2655 GD-11 LEAD SANITATION DRIVER 0.10 $ 6,461 0.10 $ 6,672 0.10 $ 5,999
67054520 61010 670 6100 GE-35
RESOURCE MGMT
SUPERVISOR 0.06 $ 5,139 0.06 $ 4,249 0.06 $ 4,657
Total 0.16 $ 11,600 0.16 $ 10,921 0.24 $ 15,087
Recycling Collection Program-FT Refuse Fund
67054530 61010 670 6100 GE-35
RESOURCE MGMT
SUPERVISOR 0.44 $ 37,681 0.44 $ 31,163 0.44 $ 34,151
67054530 61010 670 2655 GD-11 LEAD SANITATION DRIVER 0.40 $ 25,844 0.40 $ 26,686 0.40 $ 23,998
67054530 61010 670 1300 GD-06 SANITATION DRIVER 6.70 $ 378,466 6.70 $ 382,453 6.70 $ 399,320
Total 7.54 $ 441,991 7.54 $ 440,302 7.54 $ 457,469
Recycling Collection Program-Seasonal Refuse Fund
67054530 61030 670 898 GD-26 SANITATION DRIVER-TEMP 0.08 $ 2,634 0.08 $ 2,719 —$ —
Total 0.08 $ 2,634 0.08 $ 2,719 —$ —
City Garage-FT Service Fund
81054600 61010 810 3225 GE-35 EQUIP MAINT. SUPERVISOR 1.00 $ 80,601 1.00 $ 87,654 1.00 $ 92,153
81054600 61010 810 2525 GD-10 MECHANIC 7.00 $ 409,485 7.00 $ 428,559 7.00 $ 452,835
81054600 61010 810 GE-27
INVENTORY/ACCOUNT
CLERK —$ — 1.00 $ 46,082 1.00 $ 48,201
81054600 61010 810 835 GD-03 STOCK CLERK 2.00 $ 100,328 1.00 $ 52,073 1.00 $ 48,572
81054600 61010 810 7250 GD-11 LEAD MECHANIC 2.00 $ 125,738 2.00 $ 130,103 2.00 $ 136,451
Total 12.00 $ 716,152 12.00 $ 744,471 12.00 $ 778,212
City Garage-PT Service Fund
81054600 61020 810 3056 GD-03 CUSTODIAN I 0.15 $ 7,417 0.15 $ 7,658 0.15 $ 8,010
Total 0.15 $ 7,417 0.15 $ 7,658 0.15 $ 8,010
Landfill-FT
94054200 61010 940 2625 GE-36 DMASWA ADMINISTRATOR 0.45 $ 35,308 0.45 $ 38,469 0.45 $ 42,813
94054200 61010 940 2625 GE-35 LANDFILL SUPERVISOR 0.60 $ 51,661 0.60 $ 53,645 0.60 $ 44,449
94054200 61010 620 2655 GD-11 FOREPERSON 0.60 $ 37,289 0.60 $ 38,504 0.60 $ 40,380
94054200 61010 940 2525 GD-11 MECHANIC 1.00 $ 63,810 1.00 $ 66,070 1.00 $ 66,875
94054200 61010 940 2300 GD-08 EQUIPMENT OPERATOR II 1.00 $ 60,291 1.00 $ 62,242 1.00 $ 55,190
94054200 61010 940 2948 GD-08
LANDFILL EQUIP
OPERATOR 3.15 $ 182,480 3.15 $ 182,220 3.15 $ 197,884
94054200 61010 940 870 GD-04 SCALE HOUSE OPERATOR 1.40 $ 71,165 1.40 $ 75,127 1.40 $ 77,905
Total 8.20 $ 502,004 8.20 $ 516,277 8.20 $ 525,496
Landfill-Seasonal
94054200 61030 940 1325 GD-26 EQUIPMENT OPERATOR 0.75 $ 24,696 0.75 $ 25,494 —$ —
CITY OF DUBUQUE, IOWA
ACTIVITY PERSONNEL COMPLEMENT SUMMARY
FY 2022 FY 2023 FY 2024
ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET
-120-
Total 0.75 $ 24,696 0.75 $ 25,494 —$ —
Composting-Landfill Program-FT
94054210 61010 940 2625 GE-36 DMASWA ADMINISTRATOR 0.10 $ 7,845 0.10 $ 8,547 0.10 $ 9,514
94054210 61010 620 2655 GD-11 FOREPERSON 0.05 $ 3,077 0.05 $ 3,209 0.05 $ 3,365
94054210 61010 940 2948 GD-08
LANDFILL EQUIP
OPERATOR 0.20 $ 11,599 0.20 $ 10,824 0.20 $ 12,401
94054210 61010 940 2625 GE-35 LANDFILL SUPERVISOR 0.10 $ 8,610 0.10 $ 8,940 0.10 $ 7,408
Total 0.45 $ 31,131 0.45 $ 31,520 0.45 $ 32,688
HHMRCC-Landfill Program-FT
94054220 61010 940 2625 GE-36 DMASWA ADMINISTRATOR 0.10 $ 7,845 0.10 $ 8,547 0.10 $ 9,514
94054220 61010 940 2625 GE-35 LANDFILL SUPERVISOR 0.05 $ 4,305 0.05 $ 4,471 0.05 $ 3,704
94054220 61010 620 2655 GD-11 FOREPERSON 0.05 $ 3,077 0.05 $ 3,209 0.05 $ 3,365
94054220 61010 940 2948 GD-08
LANDFILL EQUIP
OPERATOR 0.30 $ 17,226 0.30 $ 16,608 0.30 $ 17,796
94054220 61010 940 870 GD-04 SCALE HOUSE OPERATOR 0.50 $ 24,840 0.50 $ 25,505 0.50 $ 29,242
Total 1.00 $ 57,293 1.00 $ 58,340 1.50 $ 91,926
Education & Communication-Landfill Program-FT
94054230 61010 940 2625 GE-36 DMASWA ADMINISTRATOR 0.05 $ 3,923 0.05 $ 4,126 0.05 $ 4,757
94054230 61010 940 2625 GE-35 LANDFILL SUPERVISOR 0.05 $ 4,305 0.05 $ 4,471 0.05 $ 3,704
94054230 61010 620 2655 GD-11 FOREPERSON 0.05 $ 3,077 0.05 $ 3,209 0.05 $ 3,365
Total 0.15 $ 11,305 0.15 $ 11,806 0.15 $ 11,826
E-Scrap Recycling-Landfill Program-FT
94054240 61010 940 2625 GE-36 DMASWA ADMINISTRATOR 0.10 $ 7,845 0.10 $ 8,251 0.10 $ 9,514
94054240 61010 940 2625 GE-35 LANDFILL SUPERVISOR 0.05 $ 4,305 0.05 $ 4,471 0.05 $ 3,704
94054240 61010 620 2655 GD-11 FOREPERSON 0.10 $ 6,153 0.10 $ 6,418 0.10 $ 6,730
94054240 61010 940 2948 GD-08
LANDFILL EQUIP
OPERATOR 0.30 $ 17,226 0.30 $ 16,608 0.30 $ 17,796
94054240 61010 940 870 GD-04 SCALE HOUSE OPERATOR 0.10 $ 4,968 0.10 $ 5,101 0.10 $ 5,849
Total 0.65 $ 40,497 0.65 $ 40,849 1.15 $ 71,898
DMASWA Rural Recycling Program - FT
94054250 61010 940 2625 GE-36 DMASWA ADMINISTRATOR 0.10 $ 7,845 0.10 $ 8,547 0.10 $ 9,514
94054250 61010 620 2655 GD-11 FOREPERSON 0.05 $ 3,077 0.05 $ 3,209 0.05 $ 3,365
94054250 61010 940 2625 GE-35 LANDFILL SUPERVISOR 0.05 $ 4,305 0.05 $ 4,471 0.05 $ 3,704
DMASWA Gas Collection - FT
94054260 61010 940 2625 GE-36 DMASWA ADMINISTRATOR 0.10 $ 7,845 0.10 $ 8,547 0.10 $ 9,514
94054260 61010 940 2625 GE-35 LANDFILL SUPERVISOR 0.10 $ 8,610 0.10 $ 8,940 0.10 $ 7,408
94054260 61010 620 2655 GD-11 FOREPERSON 0.10 $ 6,153 0.10 $ 6,418 0.10 $ 6,730
94054240 61010 940 2948 GD-08
LANDFILL EQUIP
OPERATOR 0.05 $ 2,871 0.05 $ 2,964 0.05 $ 3,100
Total 0.35 $ 25,479 0.35 $ 26,869 0.35 $ 26,752
TOTAL PUBLIC WORKS DEPT.93.28 $ 5,455,586 93.43 $ 5,653,693 95.73 $ 6,035,971
CITY OF DUBUQUE, IOWA
ACTIVITY PERSONNEL COMPLEMENT SUMMARY
FY 2022 FY 2023 FY 2024
ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET
-121-
5421000001 Curb Replacement Program Public Works 301 64075 8,000
5421000001 Curb Replacement Program Public Works 301 67990 42,000
5421000002 Curb Ramp Program Public Works 110 64075 65,000
5421000002 Curb Ramp Program Public Works 110 67990 584,104
5421000003 Asphalt Milling Program Public Works 301 67990 90,345
5429900003 Solid Waste Vehicles Public Works 671 67270 462,454
5429900005 Ice Harbor Gates Fender Repl Public Works 304 67990 220,000
5429900006 Vehicle access door replcmnt Public Works 301 67500 38,058
5429900008 Garage Electric Vehicle Chrg Public Works 811 67990 20,139
5429900010 58000 GWV Dump Truck Replacement Public Works 110 67230 19,173
5429900010 58000 GWV Dump Truck Replacement Public Works 301 67230 487,759
5429900011 MSC HVAC Replacement Public Works 301 67500 20,000
5429900012 MSC Sign Room Exhaust System Public Works 301 64070 5,000
5429900012 MSC Sign Room Exhaust System Public Works 301 67500 12,200
5429900013 MSC Caulk and Sealant Replacement Public Works 301 67500 15,000
5429900014 Purina Drive Load Scanner System Public Works 605 67270 79,471
5481500002 Main Line CCTV Inspection Unit Repl Public Works 611 67270 300,000
5481500002 Main Line CCTV Inspection Unit Repl Public Works 621 67270 95,000
5481500003 SANITARY SEWER ROOT FOAM Public Works 611 64900 35,000
5484000004 LF Service Building Design Public Works 950 67500 5,000,000
5484000009 Gas Field Well Leachate Pump Proje Public Works 950 67990 25,000
5484000010 Excavator Replacement Project Public Works 950 67230 497,071
PUBLIC WORKS TOTAL 8,120,774
Capital Improvement Projects by Department/Division
PUBLIC WORKS
Project
Number Capital Improvement Project Title Department Fund Account
FY 24 Recomm'd
Budget
-122-
Public Works
Asphalt Milling Program $ 90,345 $ 89,907 $ 91,705 $ 93,539 $ 95,000 $ 460,496 113
Curb Ramp Program $ 649,104 $ 481,720 $ 522,908 $ 533,366 $ 544,000 $ 2,731,098 114
Curb Replacement Program $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 250,000 115
Concrete Street Section
Repair Program $ — $ 25,000 $ 50,000 $ 50,000 $ 50,000 $ 175,000 116
Street Sign and Post
Replacement $ — $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 40,000 117
Floodwall Post-Flood Repair
Program $ — $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 100,000 118
Steps, Hand Railings and
Wall-Top Fencing $ — $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 40,000 119
Ice Harbor Gates Fender
Replacement Project $ 220,000 $ — $ — $ — $ — $ 220,000 120
58,000 Gross Vehicle Weight
(GVW) Dump Truck
Replacement $ 506,932 $ — $ 268,902 $ — $ 564,556 $ 1,340,390 121
44,000 GVW Dump Truck
Replacement $ — $ 199,664 $ 407,315 $ 415,461 $ 205,656 $ 1,228,096 122
Sprinkler System - Central
Storage $ — $ 18,500 $ — $ — $ — $ 18,500 123
Mechanical Sweeper
Replacement Project $ — $ — $ — $ 230,000 $ — $ 230,000 124
Hawthorne Street Boat Ramp
Repair $ — $ — $ — $ 49,662 $ 325,100 $ 374,762 125
Municipal Services Center
Roof Mounted HVAC
Replacement Unit $ 20,000 $ — $ 20,000 $ 95,652 $ — $ 135,652 126
Municipal Service Center
Vehicle Access Doors
Replacement Project $ 38,058 $ 38,819 $ — $ — $ — $ 76,877 127
Wheel Loader Purchase $ — $ — $ — $ 255,582 $ 254,693 $ 510,275 128
Sign Room Exhaust Project
$ 17,200 $ — $ — $ — $ — $ 17,200 129
Caulk and Sealant
Replacement Project $ 15,000 $ 100,000 $ — $ — $ — $ 115,000 130
PUBLIC WORKS
Business Type
Smart Lid Manhole Project $ — $ 40,000 $ 40,000 131
Sanitary Sewer Root
Foaming $ 35,000 $ 35,000 $ 35,000 $ 35,000 $ 35,000 $ 175,000 132
Replacement of Main Line
CCTV Inspection Unit $ 395,000 $ — $ — $ — $ — $ 395,000 133
High Pressure Sewer Jet
Cleaner Replacement $ — $ 288,000 $ — $ — $ — $ 288,000 134
Cab-Over Solid Waste
Vehicles $ 462,454 $ 463,004 $ 502,264 $ 481,709 $ 491,343 $ 2,400,774 135
PRGRM/
DEPT PROJECT DESCRIPTION FY 2024 FY 2025 FY 2026 FY 2027 FY 2028 TOTAL PAGE
PUBLIC WORKS
-123-
Electric Vehicle Charging
Infrastructure Located at the
Municipal Services Center $ 20,139 $ 114,120 $ — $ — $ — $ 134,259 136
Municipal Service Center
Vehicle Maintenance Area
Wall Cleaning and Painting
Project $ — $ 5,000 $ 57,500 $ — $ — $ 62,500 137
Heavy Vehicle Maintenance
Lift Replacement Project $ — $ 156,279 $ — $ — $ — $ 156,279 138
Purina Drive Load Scanner
System $ 79,471 $ — $ — $ — $ — $ 79,471 139
Landfill Service Building
Design
$ 5,000,000 $ — $ — $ — $ — $ 5,000,000 140
Landfill Gas Field Well
Leachate Pump $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 125,000 141
Landfill Cell 9 Abutment
Phase 2 $ — $ 100,000 $ 1,000,000 $ — $ — $ 1,100,000 142
Landfill Cell 10 $ — $ — $ — $ 250,000 $ 3,605,000 $ 3,855,000 143
Landfill Excavator
Replacement 3476 $ 497,071 $ — $ — $ — $ — $ 497,071 144
Landfill Weed Tractor
Replacement 3457 $ — $ — $ — $ — $ 119,928 $ 119,928 145
Landfill Wheel Loader
Replacement $ — $ — $ — $ — $ 434,637 $ 434,637 146
Landfill Dozer Rebuild $ — $ — $ 200,000 $ 200,000 $ — $ 400,000 147
Landfill Compactor Rebuild
3471 $ — $ — $ — $ 450,000 $ — $ 450,000 148
Landfill Gas System Air
Compressor $ — $ — $ 25,394 $ — $ — $ 25,394 149
TOTAL $ 8,120,774 $ 2,235,013 $ 3,300,988 $ 3,259,971 $ 6,884,913 $ 23,801,659
PRGRM/
DEPT PROJECT DESCRIPTION FY 2024 FY 2025 FY 2026 FY 2027 FY 2028 TOTAL PAGE
PUBLIC WORKS
-124-
FISCAL YEAR 2024
BUDGET PRESENTATION
PUBLIC WORKS
DEPARTMENT
MISSION STATEMENT
Public Works Department
Public Works takes pride in leveraging necessary resources to
maintain the heart of Dubuque by steadfast, equitable delivery of
organization-and community-wide services while maintaining
reliable infrastructure to cultivate a vibrant, connected
community. The beat of Dubuque is maintained through
preservation, construction, rehabilitation, daily operations, and
the 24/7 emergency response the Public Works Department
provides.
VISION
Public Works Department
Public Works will be recognized for its
commitment to provide services that meet the
needs of Dubuque’s citizens and contribution to
an equitable community through innovation,
technological advancements, accountable
stewardship, responsiveness, and adaptability to
our ever-changing community.
AGENCY SUPPORT
Public Works Department
The Department provides staff support to the Dubuque
Metropolitan Solid Waste Agency Board of Directors and
Landfill Operations
DMASWA Administrator -SHOUT OUT
CONGRATS!
Congratulations to Ken
Miller on being elected to
President of North
American Hazardous
Material Management
Association Board of
Directors!
Public Works Department Leadership
Public Works
Director
John
Klostermann
Assistant Public
Works Director
Arielle Swift
Field Operations
Supervisor
Paul Davis
Solid Waste Agency
Supervisor
Vacant
Resource Management
Supervisor
Jacob Jansen
Fleet Maintenance
Supervisor
Tom Kuhle
DMASWA
Administrator
Ken Miller
FY24 Public Works Team
Public Works Department
FY2024 REQUESTED PROPERTY TAX SUPPORT
$1,182,968 $17.11
Net Property
Tax Support
Average homeowner’s* property
tax cost for Public Works
(*Avg. home value of $159,503)
Public Works Department
FY2024 NON-PROPERTY TAX REVENUE
Only 6.02% of the Public Works
Department is supported through
Property Tax.
93.98% of revenue comes from:
•User/Service Fees
•State Road Use Tax
•Garage Recharges
CREATING AN
EQUITABLE
COMMUNITY
OF CHOICE
PROGRAMS
Community CompassionCY2022 -29,453 Phone calls
Internal Compassion
COMMUNITY RESILIENCEFloodwall
2020-2022 Technician Hours per DepartmentFleet Resiliency
16.6K
Hours
Avg Annual Technician Hours by Dept
Avg Age by VEUs
Fleet Resiliency
Equity in Street Maintenance
Overlay Program Impacts
17.9%
12.5%
#
CY2022 Gas Operations
based on collecting 133,934 MMBTUs
Cart Audit
Cart Utilization by Tract @ 50% Audited
Equity in Carts
City-Wide
Carts Delivered vs Collected Tonnage
City-Wide
Recycling Carts vs Recycling Tonnage
Recycling Mix
FY2024 REFUSE PROPOSED RATE INCREASE
2.90%
Proposed Rate
Increase over FY 23
$0.45
Monthly Bill Impact for
Average Household
SOLID WASTE COLLECTION RATE COMPARISON
(8 largest Iowa cities providing weekly collection)
FY24 BASE RATES
FY2024 Recommended RatesOrganic Collection
FY2023 FY2024 Difference
Annual Yard Waste Decal $35.00 $40.00 $5.00
64 gallon cart $11.00 $10.00 $(1.00)
48 gallon K-12 Schools $8.00 $—$(8.00)
Commercial 13 gallon food scrap $4.00 $4.00 $—
Commercial 48 gallon food scrap $15.00 $—$(15.00)
Commercial 64 gallon food scrap $20.00 $20.00 $—
13 gallon food scrap $1.00 $1.00 $—
Leaf Rake-Out $20.00 $20.00 $—
Yard waste brush ties $1.30 $1.50 $0.20
single-use yard waste stickers $1.30 $1.50 $0.20
FY2024 Recommended RatesBulky Collection
FY2023 FY2024 Difference
1 Hopper -Minimum Fee $10.00 $13.00 $3.00
Additional Hoppers $12.50 $13.00 $0.50
Electronics without a screen $10.00 $—$(10.00)
Electronics with a screen $20.00 $20.00 $—
Additional Electronics with a screen $15.00 $—$(15.00)
Appliances $10.00 $20.00 $10.00
Tires $6.00 $6.00 $—
Small Electronics $—$5.00 $5.00
Off Route/Non Customer Charge $10.00 $15.00 $5.00
NON-RECURRING
Tablets for Time Entry (5) | $4,600
Fleet Maintenance Staffing Study | $30,000
Pavement Sensors (5)| $7,000
Server AC Unit Traffic Signal Shop | $9,000
RECURRING
Recycling Tipper Carts | $30,000
FY2024
RECOMMENDED
IMPROVEMENT
REQUESTS
Personnel RecommendationsImprovement Packages
Part-Time Waste Minimization Intern | $13,568
Recurring:
Wages = $11,588
Benefits = $ 1,980
Personnel RecommendationsImprovement Packages
Full-Time Data Scientist | $9,500
Recurring:
Wages = $80,328
Benefits = $27,197
Non-Recurring:
Comp/License: $4,500
Activity Recharge
Savings/
Reallocation Net Impact
Property Tax 10,000 10,000 —
Garage Service Fund 63,025 78,025 (15,000)
Landfill 12,500 —12,500
Solid Waste Funds 14,500 14,500 —
Road Use Tax 7,500 —7,500
Property Tax (comp)——4,500
TOTAL $9,500
Recharged = $107,525
Project FY 24 Cost Total Project Cost
Asphalt Milling Program (5M)$90,345 $1,683,991
Curb Ramp Program $649,104 $4,319,172
Curb Replacement Program $50,000 $332,638
Ice Harbor Gates Rehab Project $220,000 $365,000
Dump Truck Replacement (2 -58K GVW)$506,932 $1,340,390
MSC HVAC Replacement $20,000 $135,652
MSC Garage Access Door Replacements $38,058 $113,827
FY 24 CAPITAL IMPROVEMENT PROJECTS
Public Works Department
Project FY 24 Cost Total Project Cost
MSC Sign Room Exhaust Project $17,200 $17,200
MSC Caulk & Sealant Project $15,000 $115,000
Sewer Root Foaming $35,000 $264,999
Sewer CCTV Truck Replacement $395,000 $395,000
Solid Waste Vehicle Replacement (2)$462,454 $3,039,045
Electrical Vehicle Infrastructure $20,139 $238,266
Purina Drive Load Scanner $79,471 $79,471
FY 24 CAPITAL IMPROVEMENT PROJECTS
Public Works Department
FUTURE INITIATIVES
FUTURE INITIATIVES
FUTURE INITIATIVES
THANK YOU
www.cityofdubuque.org/publicworks
One Team, One Goal
Data ScientistImprovement Packages
Data ScientistImprovement Packages
Forecast Revenue = garage stores savings1 (1,093,657*41%)
FR Standard Deviation = garage stores savings variation (1,093,657*30%)
Variable Expense = software & licensing needed (estimated 15,000)
VE Standard Deviation = software & licensing variation (estimated 10,000)
Fixed Expense = data scientist salary (estimated 120,000)
Number of Simulations = 1,000
1The savings of 41%in inventory/stores is derived from a Faber Infinite Consulting results after utilizing data science to improve
inventory management costs with a client whose baseline inventory is similar in size to Public Works Fleet Division.We utilized
FY2022 actual expense for baseline garage stores.
17%
83%
Data ScientistImprovement Packages
YEAR 2+
1.Sewer Maintenance related to consent decree compliance. All lines should be inspected within a 6-year window.
2.Inventory Management for GAAP compliance. This would include utilizing and implementing a machine learning model.
3.Building APIs from current softwares into PowerBI, or WDesk for sole data sourcing.
4.Researching RFIDs for cart management system capabilities and potentially moving to weight -based fee structure to include a weight-
vs volume-based structure.
5.Deep dive into organization wide fleet replacement vs repair costs.
6.Vehicle/Equipment pool feasibility/utilization research.
7.Professional development department wide –currently no capacity to undergo due to Assistant Director trying to fill data needs.
8.Staff evaluations and on-going feedback does not currently exist. For a formal feedback system even once a year, the Director an d
Assistant Director would need to schedule 2 individual reviews a week. formally –currently no capacity to undergo due to Assistant
Director trying to fill data needs.
9.Official Service Feedback Program: Surveys or other means to have a resident measurement on services provided.
10.Fully integrated work order system to measure performance within core areas.
11.Route Optimizations ($126,000 estimated per core area to outsource)
12.Salt Operations spoilage rate analysis (no current system to measure)
13.Asset Management utilization and improvements. Certain aspects cannot be created by Cartegraph through consultant work (task,
inspection, and activity level).
14.Climate Action Plan implementation. Energy utilization rates for buildings pump houses utilized by Public Works. This would i nclude
analyzing EV setups, future analysis on EV expansion in fleet, and battery for solar panels.
15.Diversion research analyzing and running predictive models prior to implementation to ensure the best information is provided to make
decisions.
16.Employee onboarding –currently no capacity to undergo due to Assistant Director trying to fill data needs.
17.Assist with geospatial needs within Public Works for transparency with residents.
18.Continual assistance with in organization wide data from the Enterprise Resource Planning system, Tyler Technologies, to find
patterns/trends in expense and revenue data. These trends would identify areas for potential additional savings.
Discounted City Utilities Program
The City offers income-qualified residential customers
a reduction in monthly fees for all four City utilities
(water, sanitary sewer, refuse collection, and storm
water) of up to 50% of the base rate. Customers
must submit an application for consideration and
applications are renewed on an annual basis.
Learn more and fill out a short application at:
www.cityofdubuque.org/utilitiesdiscount
or call 563.589.4144
You may be eligible for
DISCOUNTED OR FREE
INTERNET through the
Affordable Connectivity
Program (ACP).
Struggling to
afford internet?
How It Works
ACP gives a discount on your household’s monthly internet service. Participating
internet service providers will apply this discount directly to your service plan.
If eligible, your household can receive:
• $30 per month discount on wireless internet plans and a free phone
• OR $30 per month discount on wired internet service to your home
• One-time discount of up to $100 for a laptop, tablet, or desktop computer.
A small fee will be required.
Your household may be eligible if someone in the household:
• Receives SNAP, Medicaid, or other government benefits, or
• Meets income guidelines, or
• Goes to a school where they receive free or reduced-price lunch and breakfast.
Find out if you qualify and how to
participate at acp.cityofdubuque.org
If you don’t have access to a computer or internet to apply, free access is available at Carnegie-Stout Public Library.