Loading...
Public Works Fiscal Year 2023 Budget Presentation Copyrighted March 23, 2022 City of Dubuque Public Hearings # 5. Special Meeting ITEM TITLE: Public Works Fiscal Year 2023 Budget Presentation SUMMARY: SUGGESTED DISPOSITION: ATTACHMENTS: Description Type Public Works Policy Budget Book Supporting Documentation Public Input Supporting Documentation Presentation_Uploaded 3.24.22 Supporting Documentation Public Works -73- This page intentionally left blank. -74- PUBLIC WORKS DEPARTMENT FY 2021 FY 2022 FY 2023 %Change From FY Budget Highlights Actual Budget Requested 2022 Budget Expenses Employee Expense 7,518,829 8,382,724 8,752,327 4.4 % Supplies and Services 7,590,773 7,843,583 8,417,134 7.3 % Machinery and Equipment 220,596 681,079 1,096,781 61.0 % Subtotal 15,330,198 16,907,386 18,266,242 8.0 % Public Works Administrative/Garage Stores 686,788 803,700 966,357 20.2 % Administrative Overhead Recharge 1,612,328 1,659,457 1,783,326 7.5 % Less Recharges/Service Fund Charges (1,842,182) (2,080,475) (2,235,603) 7.5 % Total Expenses 15,787,132 17,290,068 18,780,322 8.6 % Resources Operating Revenue 80,306 39,815 48,123 20.9 % Salt Operations Fund 119,885 104,387 113,562 8.8 % Road Use Tax Fund 5,908,126 6,569,965 7,126,098 8.5 % Sewer Utility Operating Fund 633,125 782,527 714,116 (8.7)% Stormwater User Fund 213,027 270,180 286,307 6.0 % Refuse Collection Fund 4,202,682 4,344,208 5,140,013 18.3 % Landfill Operating Fund 3,886,377 4,130,909 4,165,363 0.8 % Total Resources 15,043,528 16,241,991 17,593,582 8.3 % Debt Service abated with Sales Tax 30% 552,754 134,625 83,650 (37.9)% Debt Service abated with Landfill Fees 663,359 660,609 660,459 — % Debt Service abated with Solid Waste Fees 7,276 8,484 8,904 5.0 % Total Non-Property Tax Debt Service 1,223,389 803,718 753,013 (6.3)% Property Tax Support 743,604 1,048,077 1,186,740 138,663 Percent Increase (Decrease) 13.2 % Personnel -Authorized FTE 93.28 93.28 93.43 -75- FY 2021 FY 2022 FY 2023 a/o Change From Solid Waste Collection Fund Summary Actual Budget Requested FY 2022 Budget Administrative Overhead Recharges/Utility Billing 1,191,482 1,219,202 1,305,346 7.1 % Refuse Operations 3,011,200 3,125,006 3,834,667 22.7 % Debt Service- Refuse 7,276 8,484 8,904 5.0 % Payment to Depreciation 510,000 325,000 550,000 69.2 % Total Requirements 4,719,958 4,677,692 5,698,917 21.8 % Refuse Fees (Incl tipper carts/other) 3,952,148 4,223,391 4,581,085 8.5 % UBP Single Use Refuse Sticker 122,875 109,486 122,875 12.2 °/a Sales Tax Collection 6,702 7,207 7,220 0.2 % Yard Waste Stickers &Ties 131,459 125,601 131,459 4.7 °/o Leaf Rake Out Fees 7,205 5,915 7,205 21.8 % Food Scrap 9,131 10,647 9,131 (14.2)°/o Recyclable Sales 10,941 762 96,000 12,498.4 % Subscription Recycling 6,543 6,196 6,543 5.6 % Large Item Pickup 78,408 58,982 78,408 32.9 % Miscellaneous Revenue 66,013 98,480 651,060 561.1 % General Fund - 50% Rate Reduction 40,557 43,860 43,000 (2.0)% Total Resources 4,431,982 4,690,527 5,733,986 22.2 °/o Annual Operating Surplus (Deficit) (287,976) 12,835 35,069 22,234 Personnel -Authorized FTE 20.75 20.75 20.74 Solid Waste User Fee Rate Increase (4.03)°/a 2.60 % - % Solid Waste User Fee $ 14.99 $ 15.38 $ 15.38 Revenue 1°/a Rate Increase Generates $ 31,475 FY 2021 FY 2022 FY 2023 %Change From Salt Operations Fund Summary Actual Budget Requested FY 2022 Budget Salt Purchase 103,272 88,755 96,750 9.0 °/o Salt Handling Fees 9,305 9,060 9,240 2.0 % Miscellaneous Fees 1,634 940 1,634 73.8 °/o Administrative Overhead 5,674 5,632 5,938 5.4 % Property Maintenance - - - - °/o Total Requirements 119,885 104,387 113,562 8.8 % Salt Sales 120,416 88,755 97,665 10.0 °/o Salt Storage Fees 4,773 6,637 6,000 (9.6)°/o Salt Handling Fees - 9,060 9,240 2.0 °/o Total Resources 125,189 104,452 112,905 8.1 % Annual Operating Surplus (Deficit) 5,304 65 (657) (722) -76- Improvement Package Summary Public Works 1 of 17 This improvement request would provide funds for creation of one full time Geospatial Data Analyst position (GE-34A) in the Public Works Department. In order to keep up with the needs of a growing municipality, infrastructure maintenance, fleet maintenance, annexation, and the ever-looming natural disasters, the Data Analyst will focus on analysis and problem solving as it relates to data, types of data, and relationships among data elements within a business system or IT system. The backbone of their work includes the ability to work within Graphic Information Systems to allow for efficiencies in tracking costs related to daily operations. The goal is to lessen or mitigate reactionary maintenance that depletes emergency funds and previously allocated monies. Cedar Rapids has shown us the true impact of Public Works Analysts. With the recent derecho that tore through Cedar Rapids, the Public Works department was able to track and coordinate amongst themselves, city partners, private companies, and community members. Their data analyst was able to log all hours and costs related to their declared national emergency proclamation. Being able to track crews through various stages of clean up, they were able to get 150 of 191 signal lights and all stop signs up within one week. Their ability to accomplish this task was credited to their Public Works Analyst. Tracking Solid Waste inventory in Cartegraph and GIS, we can deduce how fee structures are impacting Low-to-Moderate Income and non-white populations in Dubuque. This position will leverage geospatial data to identify service gaps and hotspots for infractions. This will lead to compliance increase by better targeting inspections and maintenance on underground infrastructure. Honing sanitary sewer variables in to Cartegraph, Public Works Geospatial Data Analyst can create an algorithm to hone on the lines that need immediate replacement or maintenance. Collecting this data will ensure DOJ Compliance is met and overflows or basement backups are minimized. Currently, staff are not tracking the data needed to make efficiencies in service and fee structure due to lack of expertise and dedicated man-hours. This data analyst would be able to assist GIS department and Information Services Department when necessary but would be dedicated to Public Works Data Infrastructure & Operational Routes. Taking the return on investment Cincinnati recorded and making the assumption The City of Dubuque sees twenty percent (20°/o) of that return within the first two years, we can expect $224,291 money saved or reallocated to improvements in outcomes for the citizens of our community within the first two years in excess of the recurring costs of this position. This request is related to the council goal of financially responsible, high performance city organization, sustainable, equitable and effective service delivery. The Connected Communities goal is reached by devoting a full-time position to tracking, maintaining, and inputting clean data into GIS. This will allow Public Works to be transparent within the community regarding operations and maintenance of assets that affect their daily lives. FUND NAME FUND %ALLOC $ALLOC Landfill 940 14.50 % 12,249 Sanitary Sewer 610 6.00 % 5,069 Storm Sewer 620 3.00 % 2,534 General 100 11.00 % 9,292 Road Use Tax 250 45.50 % 38,437 Salt Operations 680 1.00 % 845 Solid Waste 670 14.00 % 11,827 Garage Fund 600 5.00 % 4,224 -77- Related Cost: $ 8,125 Tax Funds Non-Recurring Recommend - No Related Cost: $ 76,352 Tax Funds Recurring Net Cost: $ 84,477 Property Tax Impact: $ 0.0332 0.21% Activity:Administration 2of17 This improvement request would provide funds for the purchase of one grapple bucket which would be mounted on one existing Public Works wheel loader. This bucket would allow Public Works to respond better to an event which causes widespread yard debris generation (i.e. storm damage). This bucket may also be used to enable staff to assist Housing in citation removals and Solid Waste activity for large-item- pick-ups when needed. This request supports the City Council goal of Financially Responsible, High Performance City Organization, Equitable and Effective Service Delivery. Related Cost: $ 23,100 Road Use Tax Funds Non-Recurring Recommend -Yes Net Cost: $ 23,100 Property Tax Impact: $ 0.0091 0.09% Activity: Street Cleaning 3of17 This improvement request is for the purchase of a mowing attachment for the current skid steer unit. With the transfer of the Northwest Arterial from State to City maintenance responsibility, there are several areas of vegetation in the right-of-way that are not accessible with the current weed tractor or mowing equipment. These areas would be cut once or twice a year to keep trees and other types of vegetation under control for both visibility and aesthetics reasons. Related Cost: $ 7,500 Road Use Tax Funds Non-Recurring Recommend -Yes Total Cost $ 7,500 Property Tax Impact: $ 0.003 0.03% Activity: Street Cleaning 4of17 This improvement request would provide funds for the purchase of one Bright Signs module for use in the Municipal Services Center. In Public Works,there are over 90 FTEs, over four separate designated areas of work to disperse high priority information daily. 20% of adults experience information overload according to Pew Research Center. This can create a mental fog which leads to impaired decision making, willpower, productivity, focus, critical thinking, and assessment. Bright Signs offer an easy solution to disperse filtered information to a mass group. Employees within Public Works do not all have designated computers, tablets, phone, or email. With the increased use of electronic information only, it is important to have a new way to communicate with all staff and not just staff with email or a computer. Bright Signs are currently used within Transportation Services and Information Services Departments. This request supports the City Council goal of Financially Responsible, High Performance City Organization, Equitable and Effective Service Delivery. Related Cost: $ 1,500 Tax Funds Recurring Recommend -Yes Net Cost: $ 1,500 Property Tax Impact: $ 0.0006 0.01% Activity: Street Maintenance -78- 5of17 This improvement request is for the purchase of one mini excavator. These funds would supplement funds requested in the Fiscal Year Capital Improvement Program for the replacement of unit# 3214, a 2010 John Deere backhoe loader. Replacing the existing backhoe unit with the requested mini excavator unit would provide the operator with improved maneuverability in congested work zones. The rotating, short-radius house gives the mini excavator a much broader range of reach for loading trucks and can fit in places a wheel loader backhoe cannot go. The department current has one mini excavator and operators have found it very useful on various projects including curb repair, concrete section repair, and asphalt base repair. Operators have found they have improved production when using the mini excavator. Funding this improvement request would provide our staff with tools they need to provide cost effect repairs. This request supports the City Council goal of Financially Responsible, High Performance City Organization, Equitable and Effective Service Delivery. . Related Cost: $ 30,000 Road Use Tax Non-Recurring Recommend -Yes Total Cost $ 30,000 Property Tax Impact: $ 0.0118 0.12% Activity: Street Maintenance 6of17 This improvement request provides funds for the use of goats for weed control along the riverside of the Peosta Channel section of the flood control levee. The Corps of engineers requires a weed control program for all of the flood control system. On this section of levee, the land side is mowed, and the river side of the levee is sprayed with a herbicide to kill unwanted vegetation. Once sprayed any remaining weeds must be manually cut by staff. Due to the rip rap which armors the riverside of the levee this is very hazardous work for our staff to accomplish. Although weed control is very important to the success of the flood control system, spraying herbicide is unpopular with some of the trail users. If funding for this project is approved, it will eliminate the hazards of manual week cutting and eliminates an unpopular practice on this heavily used section of levee trail. This project cost would be off set by $5,000 in annual spraying costs. This request supports the City Council goal of Financially Responsible, High Performance City Organization, Equitable and Effective Service Delivery. Related Cost: $ 35,000 Tax Funds Recurring Recommend - No Property Tax Impact: $ 0.0138 0.14% Activity: Floodwall Operation 7of17 This improvement request would provide funds for a full-time Sanitation Driver (1.0 FTE) to be shared between yard waste and snow and ice control and eliminates seasonal laborers (1.17 FTE total) in the Street Signs and Markings (0.5 FTE), Refuse Collection (0.09 FTE), Yard Waste Collection (0.50 FTE), and Recycling Collection (0.08 FTE) activities. The net impact to full-time equivalents would be a reduction of 0.34 FTE. , a seasonal position has not proven to be a value-added expense. Related Cost: $ 31,441 Road Use Recurring Recommend -Yes Related Cost: $ 42,874 Refuse Funds Recurring Related Cost Savings: $ (20,139) Tax Funds Recurring Related Cost Savings: $ (26,779) Refuse Funds Recurring Net Cost $ 27,397 Property Tax Impact: $ 0.0044 0.05°/o Solid Waste User Fee Impact 0.50 °/o Activity: Snow and Ice Control/Yard Waste 8of17 -79- This improvement request would provide funds for a part-time secretary (GE-25A) (0.67 FTE) to assist with front office data entry and phone calls. There has been a dramatic increase in customer service phone calls resulting in data entry and the call volume is not anticipated to decline. This position will help with coverage issues during lunch, vacation, and sick periods of time. To maintain our service levels, we should expect our secretaries to handle 4 calls an hour. This includes all data entry and communication relay to crews. At this rate, our current 2.0 FTEs can cover 64 calls a day. The increase in phone calls average 125 calls a day, and including 15% for citizens who call multiple times, leaving an average of 50 distinct calls unanswered per day. This estimation does not include vacation, sick, or casual days used. This request supports the City Council goal of Financially Responsible, High Performance City Organization, Equitable and Effective Service Delivery. Month Work Days Inbound Missed Answer Rate Jan-21 21 1,120 243 78.30% Feb-21 20 1,190 237 80.08% Mar-21 23 2,039 723 64.54% Apr-21 22 2,515 983 60.91% May-21 21 2,001 763 61.87% Jun-21 22 2,564 1,078 57.96% Jul-21 22 2,645 984 62.80% Related Cost: $ 4,500 Tax Funds Non-Recurring Recommend -Yes Related Cost: $ 30,713 Tax Funds Recurring Net Cost: $ 35,213 Property Tax Impact: $ 0.0139 0.14% Activity:Administration 9of17 This improvement request provides funds for a safety training simulator for all snow and ice control employees and solid waste employees prior to winter operations.The simulation would be setup similarly to the trucks the operators currently utilize during the winter season and is immersive. It allows many variables to be thrown at drivers such as ice, wind, heavy snow, white-out conditions, civilians, various terrains, and street widths. Snowplow drivers must operate $200,000 units of equipment in blinding snowstorms and demanding traffic conditions. Yet traditional training for new drivers, with limited funding and staff, may be only two or three storm shifts with a partner-trainer. For this level of responsibility, training needs to be enhanced, to improve driver safety and reduce risk.This request supports the City Council goal of Financially Responsible, High Performance City Organization, Equitable and Effective Service Delivery Related Cost: $ 30,600 Road Use Tax Recurring Recommend -Yes Property Tax Impact: $ 0.012 0.12% Activity: Snow and Ice Control 10 of 17 This improvement request is for funds to support the efforts of the Public Works Department to achieve the level of accredited agency by the American Public Works Association. Working under the guidelines established by the American Public Works Association self-assessment process, the department would identify written process for growth and improvement, while developing written standard operating procedures identified as crucial elements for Public Works Departments. This information is being developed as part of the succession planning process for the department. Public Works Department -80- anticipates submitting an application to begin the accreditation process in November 2022. Payment is due with the application submission. There is some pre-processing work that Public Works is currently undergoing to prepare for accreditation to include some pre-application meetings with American Public Works Association (APWA) accreditation office for the best approach. The purpose of the accreditation program is to provide a means of formally verifying and recognizing public works agencies for compliance with APWA recommended practices. With the employee turnover rate we have seen in the last two years, it is imperative we take necessary steps to ensure a smooth succession plan at all levels within Public Works. By documenting current practices, best practices, and building documentation updates into our operations ensures optimal procedures and safety related to operations. While it is a voluntary, self- motivated approach to objectively evaluate, verify and recognize compliance with the recommended management practices, it is necessary to the future of Public Works in Dubuque. This request supports the City Council goal of Financially Responsible, High Performance City Organization, Equitable and Effective Service Delivery. Related Cost: $ 23,000 Tax Funds Non-Recurring Recommend -Yes Property Tax Impact: $ 0.009 0.09% Activity:Administration 11 of 17 This improvement request would provide funds to hire a solid waste consultant to assist with the development of a path to a zero waste plan for the solid waste activities. Since then, the State of lowa is leading the way for a Sustainable Materials Management system which has a perspective of using and reusing materials more productively over their entire life cycle. By looking at materials in the perspective of material management, the hope is to find new opportunities to reduce environmental impacts, conserve resources and reduce cost. The Imagine Dubuque 2017 Comprehensive Plan and the Foth Engineering 2019 Performance Analysis of Solid Waste Operations Study identified citizen interest in a "Path Towards Zero Waste' plan with measurable targets, timeline, and annual reporting. Funding this request would provide the department with additional resources to blend these processes into one. This request supports the City Council goal of Financially Responsible, High Performance City Organization, Equitable and Effective Service Delivery. Related Cost: $ 25,000 Solid Waste Funds Recurring Recommend -Yes Solid Waste User Fee Impact 0.77 % Activity: Recycling Collection 12 of 17 This improvement request would provide funds for the purchase of additional trash tipper carts to meet the growing request of customers. An increased focus are customers who subscribed to a basic 34/35-gallon container plus an extra 34/35-gallon can or a 50-gallon can and/or an extra 50-gallon container to discard their waste. Currently there are over seven hundred (700) customers who set out a larger container and/or multiple containers weekly to manage their waste. Customers will generally pay more for the waste they throw away. Our City crews are responsible for manually lifting and managing the waste that are set out weekly. In FY2021. In FY2022 Public Works purchased a total of one thousand, four hundred and four (1,404) trash tipper carts. Starting October of 2021, a waitlist for 34-gallon carts began for the remainder of FY2022. By November of 2021, a waitlist for 48-gallon and 94-gallon carts had begun, as well. In response to the need, a truck replacement was delayed and bought an additional one thousand, one hundred twenty-five (1,125) trash carts. FY2023 Public Works is requesting additional funds to start buying two thousand, seven hundred (2,700) trash carts to keep up with demand. -81- This request IS NOT an effort to give all citizens a tipper cart but to have an adequate supply of carts available to all customers who wish to use city provided carts, improving employee safety, and enhancing collection efficiency. The Corrective Action Plan: The goal would be to eliminate the extra "trash" services that the City offers and move customers towards a tipper cart of their choice. This decision package will reduce the need for repetitive manual lifting of solid waste containers and/or heavy bags. Instead, with there being more tipper carts, containers will be collected either semi-automated or fully automated. Tipper carts improve neighborhood aesthetics through reduced litter typically associated with torn garbage bags. Customers who use multiple containers will have the option to subscribe to their cart of choice. Currently the City has four (4) tipper cart options to choose from a 34-gallon tipper cart, a 48-gallon tipper cart, a 64-gallon tipper cart and a 94-gallon tipper cart. The tipper carts are owned and maintained by the City. Estimated life of the carts is fifteen (15) years. Funding this request will support the City Council's goals of Financially Responsible, High Performance Government City Organization: Customer-focused City service delivery. Related Cost: $ 80,000 Refuse Funds Recurring Recommend - No Solid Waste User Fee Impact 2.48 % Activity: Refuse Collection 13 of 17 This decision package is requesting funds to begin to phase-in the use of mandatory use of trash carts over a two-year period. this package would approve the purchase of 15,000 trash carts. This proposal also supports the use of Automated Side Loaders for the emptying of these trash carts where possible. Carts would be purchased in FY 23 (10,000) and FY 24 (5,000) and distributed throughout the community. In the first year we would also eliminate service to customers who subscribed to a basic 34/35-gallon container plus an extra 34/35-gallon can or a 50-gallon can and/or an extra 50-gallon container to discard their waste by providing them carts of their choice. Currently there are over seven hundred (700) customers who set out a larger container and/or multiple containers weekly to manage their waste. This request is an effort to improving employee safety and to enhance collection efficiency. Under this proposal the City will continue to offer four (4) tipper cart options. The 34-gallon option will be the base fee option with the 48-gallon, 64, and 96-gallon options as other customer choices. Additional fee subscriptions will be placed on the larger carts to support the "pay as you throw" principle. Current rules related to mandatory alley carts will remain the same. All carts will be owned and maintained by the City. Extra trash sticker will still be available for customers to put out additional trash when the need arises. If this proposal is chosen, Improvement Request number fourteen (14) is not necessary and would be withdrawn. Funding this request will support the City Council's goals of Financially Responsible, High Performance Government City Organization: Customer-focused City service delivery. Related Cost: $ 291,349 ARPA Funds Recurring Recommend -Yes Related Cost: $ 291,349 ARPA Funds Non-Recurring Net Cost: $ 582,698 Activity: Refuse Collection 14of17 This improvement request would increase funding to purchase additional recycling tipper carts to meet the demand of customers who prefer a more convenient way to manage their recycling. Prior fiscal year 2017, customers only option to manage their recycling was to manually lift an 18-galllon bin (s) from their home to the curbside and/or alley line. To make recycling more convenient for customers, City Council approved a recycling tipper cart on wheels program. Since the program has been in place, a total of 2,285 recycling tipper carts are in use by customers to better manage their recycling. With additional recycling carts going -82- out to customers each year, there has been an increase in request from other customers who too want a larger container to manage their recycling. This has resulted in many customers being placed on a waiting list because of low inventory. To reduce the number of customers who have to be on a waiting list staff would like to purchase additional carts to have on stock. Having more carts will also support the City efforts to reduce staff need to manually lift items into their trucks. The estimated life of the carts is fifteen (15) years. Funding this request will support the City Council's goals of Financially Responsible, High Performance Government City Organization: Customer-focused City service delivery. Related Cost: $ 11,000 Refuse Funds Recurring Recommend - No Solid Waste User Fee Impact 0.34 % Activity: Recycling Collection 15of17 This improvement request would provide funds for the purchase of additional traffic control signs to meet the requirement of the Federal Manual of Uniform Traffic Control Devices (MUTCD). The MUTCD requires different sized advanced warning signs based on speed limits in the work zone. The purchase of these required signs would lessen the need to rely on a private traffic control company to set up these work zones. Purchase of these signs would provide the Public Work staff with the legal sized signs to set up traffic control in higher speed work zones throughout the City. Related Cost: $ 4,125 Road Use Recurring Recommend -Yes Property Tax Impact: $ 0.0016 0.02% Activity: Street Maintenance 16 of 17 This improvement request would provide for 4 sets of portable vehicle barriers at a length of 16 ft each to be utilized primarily for the annual July 3rd event. Each year, Dubuque holds several large events that draw many people, such as the Annual Fireworks, Farmer's Market, and Main St. events.Attendees' safety has been a priority at these events. One of the issues and trends that the police department has been watching is where a vehicle drives through a crowd causing many casualties. There are several options for attempting to mitigate or minimize this from happening: The use of large dump truck type vehicles to block roadways, etc. The trucks are moveable, thus allowing in and out access as needed, however this option requires someone to stay with the vehicle. The use of concrete, "Jersey barriers" which are very effective at stopping vehicles, however, they are not portable and require special equipment to move. Another option is the use of portable vehicle barriers. Portable vehicle barriers, require only one person to install or dismantle. They are easy to carry and are modular, meaning we can attach as many together as possible. While it is not feasible to cover all roads with barriers, a common scenario would be shutting four lanes. The cost of enough portable vehicle barriers to cover this scenario is approximately $120,000. This request supports the City Council goal of Vibrant Community: Healthy and Safe. Related Cost: $ 120,000 Tax Funds Non-Recurring Recommend -Yes Property Tax Impact: $ 0.0472 0.50% Activity: Staff Services 17of17 This improvement package provides additional funds to increase the annual 5-mile asphalt program to 10 miles in FY 2023. Due to the age of our streets system, we have a need to continually invest in our pavements before they fall into "poor" condition category. Once that happens major rehabilitation or reconstruction is needed, and maintenance projects are no longer cost effective. Since 1993 the Public Works department has completed over 331 miles of asphalt overlays on asphalt paved streets. These -83- maintenance projects last an average of 10 years depending on various factors including the sub-base design and traffic loads. This maintenance program, along with other maintenance techniques has brought our overall condition index (OCI) rating, for asphalt pavements, to 67.30 which is considered good when evaluating pavements. The funds requested would purchase an additional 7,000 tons of asphalt and 50 manhole ring and lids over what is already requested for in the maintenance level budget. this request supports the Council goal of Financially Responsible, High Performance City Organization, Equitable and Effective Service Delivery. Related Cost: $ 392,980 Road Use Tax Non-Recurring Recommend -Yes Related Cost: $ 20,000 Sanitary Sewer Fund Non-Recurring Net Cost: $ 412,980 Property Tax Impact: $ 0.1625 1.73% Activity: Street Maintenance/Sanitary Sewer Maintenance Landfill 1 of 6 This improvement request eliminates one seasonal Equipment Operator (GD-29F) (-0.75 FTE) and provides funds to create one additional full-time Landfill Equipment Operator (GD-8A) (+1.0 FTE) to support operations in the Agency's Regional Collection Center (RCC). In FY2021, the Agency commissioned Foth Environmental to conduct an staffing study for the Agency's operations. The study recommended that to support operations of the Agency's RCC, where electronics recycling and household hazardous materials are processed for shipping, an additional staff member was needed to provide coverage for operating hours and volumes. This staff person would split their time between HHM and Electronics, activities 50/50 for the equivalent of 1.0 FTE. For multiple years the landfill has struggled to find qualified candidate to fill the seasonal position. Related Cost: $ 78,337 Landfill Fund Recurring Recommend -Yes Related Savings: $ (29,841) Landfill Fund Recurring Net Cost: $ 48,496 Activity: Landfill 2 of 6 This improvement request is for the DMASWAAgency Administrator, Landfill Supervisor and Foreperson to attend training to become certified in compost operations. This request supports the Agency's Compost Operations Plan, which includes having the Agency Administrator, Landfill Supervisor and Landfill Foreperson be certified in compost operations. The United State Composting Council offers trainings throughout the year at various locations in the United States. Related Cost: $ 9,300 Landfill Fund Non-Recurring Recommend -Yes Related Cost: $ 300 Landfill Fund Recurring Total Cost: $ 9,600 Activity: Landfill 3of6 This improvement request is for additional funding for the purchase of a sweeper attachment for the current landfill wheel loader. The sweeper attachment for the wheel loader will allow landfill staff to properly maintain both internal hard surface roads and Airborne Road by removing mud, nails and other material which tracks out form the cell site. Removing this debris in a timely manner improves the safety of the road, reduces the possibility of debris entering the storm sewer system along Airborne Road and enhances the appearance of the landfill entryway and adjoining properties. -84- Related Cost: $ 17,200 Landfill Fund Non-Recurring Recommend -Yes Activity: Landfill 4 of 6 This improvement request is for the replacement of the existing plow blade for the wheel loader which is used of snow removal operations. The current unit was provided by Public Works department and has reached the end of its service life. The replacement unit is necessary to properly maintain internal roads and the entrance area during snow events. Related Cost: $ 22,450 Landfill Fund Non-Recurring Recommend -Yes Activity: Landfill 5of6 This improvement request is for the purchase of a pallet wrapper. The Regional Collection Center (RCC) ships both electronics and hazardous materials. Most outbound shipments require the items to be palletized and shrink wrapped to ensure safe transportation. Currently staff must hand wrap all pallets and the quality of the wrapping varies from pallet to pallet.A pallet wrapper would ensure a consistent wrap quality while improving safety for staff when loading the pallets onto shipping vehicles. Related Cost: $ 10,000 Landfill Fund Non-Recurring Recommend -Yes Activity: Landfill 6 of 6 This improvement request is for the purchase of a hydro-seeder to be used to reduce erosion and reduce leachate production at the landfill by seeding bare soil areas in the active cell more frequently. Reducing run off, reduces side slope erosion in the active landfill cells, which in turn reduces side slope repair costs. Seeding areas of the cell which will not be used during the current season will help reduce leachate infiltration, reducing leachate volumes and treatment costs. Related Cost: $ 19,897 Landfill Fund Non-Recurring Recommend -Yes Activity: Landfill Significant Line Items Employee Expense 1. FY 2023 employee expense reflects a 3.25°/o wage package increase. 2. The lowa Public Employee Retirement System (IPERS) City contribution of 9.44% is unchanged from FY 2022 The employee contribution of 6.29°/o is unchanged from FY 2022. 3. The City portion of health insurance expense is increased from $1,086 in FY 2022 to $1,119 in FY 2023 per month per contract which results in an annual cost increase of$64,799 or 3.00%. 4. Workers' Compensation increased from $314,921 in FY 2022 to $343,118 in FY 2023. FY 2021 actual was $357,575. 5. Overtime is unchanged from $324,391 in FY 2022 to $324,391 in FY 2023. FY 2021 actual was $325,737. 6. Five-Year Retiree Sick leave payout increased from $25,741 in FY 2022 to $27,972 in FY 2023. -85- 7. 50% Sick Leave Payout increased from $5,441 in FY 2022 to $5,711 in FY 2023. FY 2021 Actual was $5,710. 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 2023 budget includes the following change in the funding allocation of positions: a. -0.73 FTE Equipment Operator I I (GD-08)from Road Use Tax Fund (-$61,735) b. +0.73 FTE Equipment Operator II (GD-08) to General Fund (+$61,735) c. -0.78 FTE Utility Worker (GD-05)from General Fund (-$62,455) d. +0.78 FTE Equipment Operator I (GD-06) to Road Use Tax (+$63,610) e. -0.05 FTE Utility Worker(GD-05)from Road Use Tax (-$4,003) f. +0.05 FTE Equipment Operator I (GD-06) to General Fund (+$4,078) 9. During Fiscal Year 2022, the following personnel changes were approved: a. 1 FTE Account Clerk I I position (NA-50) was changed to Lead Administrative Assistant (GE-28) which resulted in a cost increase of$2,394. b. 1 FTE Stock Clerk position (GD-03) was changed to Fleet Maintenance Inventory/ Accounting Clerk (GE-27) which resulted in no cost increase. c. 4 FTE Truck Driver positions (GD-05)were changed to Utility Worker (GD-05)which resulted in no cost increase. d. 1 FTE Sanitation Laborer position (GD-04) was changed to Sanitation Driver(GD-06)which resulted in a cost increase of$2,479. e. Seasonal Laborer (GD-21 F) hourly rate was increased from $12.24 to $15.81 and the increased cost was offset by reducing Seasonal Laborer FTEs by 0.43 as follows: i. General Fund Seasonal Laborer-0.34FTE (-$13,765) ii. Road Use Tax Seasonal Laborer-0.09 FTE (-$3,644) Supplies & Services 10. General Liability Insurance increased from $138,235 in FY 2022 to $170,483 in FY 2023 based on FY 2022 actual plus 12%. 11. Property Insurance increased from $91,712 in FY 2022 to $119,642 in FY 2023 based on FY 2022 actual plus 9.5°/o and the Landfill pollution policy renewal occurring every three years (FY23). Floodwall Operations increased $4,218, Street Maintenance decreased $12,464 and Landfill increased $35,628. 12. Repair Parts and Supplies decreased from $169,542 in FY 2022 to $105,186 in FY 2023 based on FY 2021 actual of$66,995. Street Maintenance decreased $3,439 based on FY 2021 actual. Sanitary Sewer Maintenance decreased $11,077 based on FY 2021 actual. Landfill decreased $29,484 based on FY 2021 actual. Rural Recycling decreased $46,700. 13. Electric Utility Expense decreased from $186,865 in FY 2022 to $164,163 in FY 2023. FY 2021 actual was $131,831.FIoodwall increased from $51,800 in FY 2022 to $57,446 in FY 2023 based on a three year average plus 5°/o. Street Maintenance decreased from $71,017 in FY 2022 to $54,245 in FY 2023 based on FY 2020 actual plus 5%. 14. Street Lighting decreased from $869,300 in FY 2022 to $791,142 in FY 2023 based on FY 2020 actual of$773,829 plus 2.24%. The street lighting budget is split$30,921 general fund and $760,221 Road Use Tax fund in FY 2023. -86- 15. Property Maintenance decreased from $201,851 in FY 2022 to $174,284 in FY 2023 based on FY 2021 actual of$219,371. Street Maintenance decreased $31,696 based on FY 2021 actual. Landfill increased $25,332 based on FY 2021 actual. 16. Motor Vehicle Fuel increased from $239,633 in FY 2022 to $259,316 in FY 2023 based on FY 2022 budget plus 10%. FY 2021 actual was $264,338. 17. Motor Vehicle Maintenance increased from $389,481 in FY 2022 to $418,525 in FY 2023 based on FY 2021 actual of$412,991 plus 1°/o. Street Maintenance increased $21,817 based on FY 2021 actual plus 1%. Refuse increased $18,587 based on FY 2021 actual plus 1°/o. Recycling increased $19,230 based on FY 2021 actual plus 1%. Sanitary Sewer Maintenance decreased $12,031 based on FY 2021 actual plus 1%. 18. Motor Vehicle Maintenance Outsourced is unchanged from $111,485 in FY 2022 to $111,485 in FY 2023 based on FY 2022 budget .FY 2021 actual was $120,486. 19. Machinery and Equipment Maintenance increased from $649,625 in FY 2022 to $747,935 in FY 2023 based on FY 2021 actual of$736,320. Snow and Ice Control increased $92,950 based on FY 2021 actual. Garage increased $22,959 based on FY 2021 actual. Landfill decreased $28,657 based on FY 2021 actual. 20. Machinery and Equipment Maintenance Outsourced decreased from $103,378 in FY 2022 to $88,787 in FY 2023. FY 2021 actual was $108,176. Landfill decreased $7,270 based on FY 2021 actual. Snow and Ice Control decreased $4,415 based on FY 2021 actual. Stormwater Maintenance decreased $3,698 based on FY 2021 actual. 21. Asphalt increased from $721,232 in FY 2022 to $1,121,726 in FY 2023 based on purchasing 13,000 tons of hot mix asphalt, purchasing 100 tons of cold mix asphalt, completing ten center line street miles, and a 6% increase over FY 2022 current bid rate. FY 2021 actual was $791,267. 22. Concrete decreased from $160,624 in FY 2022 to $153,578 in FY 2023 based on buying 1,500 cubic yards of concrete and k-crete and based on three year average of historical prices. FY 2021 actual was $141,120. 23. Stone decreased from $108,533 in FY 2022 to $80,735 in FY 2023 based on FY 2021 actual $80,736. This line item represents the purchase of 2,700 tons of stone for street maintenance ($34,557), stone for repairing sanitary sewer and storm sewer street excavations ($703), and stone for resurfacing Landfill gravel roads and cell face access lanes ($45,447). 24. Road Salt for Snow and Ice Control increased from $339,103 in FY 2022 to $384,750 in FY 2023. Road Salt increased $45,647 based on the purchase of 5,700 tons of road salt at $64.50 per ton (In FY 2022 budget is based on the purchase of 5,731 tons at $59.17 per ton). In FY 2022, the tons of road salt purchased was increased 4% due to the increase in lane miles for the addition of the Northwest Arterial, Central Avenue -Aquin and the new Dubuque County agreement. 25. Road Salt for Bid Partners increased from $88,755 in FY 2022 to $96,750 in FY 2023. Bid partner salt increased $7,995 based on the purchase of 1,500 tons at$64.50 per ton (In FY 2022 the budget is based on the purchase of 1,500 tons at $59.17 per ton) which is off-set from the revenue of salt purchased by bid partners. 26. Consulting Engineers increased from $217,808 in FY 2022 to $292,650 in FY 2023. FY 2021 actual was $417,033. The majority of this line item is for the engineering consulting firm contracted -87- by the Landfill to complete bi-annual IDNR engineer's reports, hydrological monitoring reports, and air permit reports and the management of the landfill gas collection system. 27. Landfill Fees increased from $577,106 in FY 2022 to $583,887 in FY 2023. FY 2021 actual was $592,096. Solid Waste Collection increased $9,429 based on FY 2021 actual tons collected of 12,912 at the estimated FY 2023 fee per ton of 36.03 (no change). 28. Payment to lowa DNR is unchanged from $304,500 in FY 2022 to $304,500 in FY 2023. FY 2021 actual was $315,982. This line item represents the amount paid by the Landfill based on tonnage. FY 2023 is based on 145,000 tons at $2.10 per ton and FY 2022 was based on 145,000 tons at $2.10 per ton. 29. Pay to OtherAgency is decreased from $470,717 in FY 2022 to $414,370 in FY 2023. FY 2021 actual was $268,363. This line item includes Landfill leachate treatment and disposal costs of $100,000 due to an agreement with the City to pay fees for leachate disposal into the sanitary sewer system. This line item also includes the processing and marketing of recyclable materials of $36,908 based on FY 2021 actual, Landfill quarterly tonnage payments to Delaware county $15,985, Landfill collection and disposal of household, farm and small business chemicals, fluorescent light bulbs, paint and medical sharps $80,737, E-waste contractor for$77,200 based on FY 2022 budget, Rural Recycling transportation and processing of 14 recyclables drop off sites $103,540. 30. The administrative overhead recharge increased from $1,659,457 in FY 2022 to $1,783,326 in FY 2023. 31. Software increased from $83,024 in FY 2022 to $110,969 in FY 2023. FY 2021 actual was $111,453. Street Maintenance increased $8,863 based on the current agreement with Cartegraph for the asset management software. Large Item Collection increased $9,781 due to the addition of the scheduling module to the ReCollect software in FY 2022. DMASWA Education increased $5,068 due to the addition of CivicPlus website host and maintenance fees. 32. Hauling Services is unchanged from $53,027 in FY 2022 to $53,027 in FY 2023. FY 2021 actual was $38,471. This line item represents snow removal in downtown streets and alleys ($50,000) and a private contractor to haul stone from area quarries for the Landfill ($3,027). Machinery 8� Equipment 33. Equipment replacement items ($1,096,781) includes: Public Works Equipment Replacements Riverfront Management Shop Equipment $ 750 Weed Whips $ 250 Street and Traffic Lighting Signal Controllers $ 16,100 Shop Equipment $ 2,500 Street Signs and Markings � Shop Equipment $ 750 Street Maintenance Barricades/Signs $ 3,400 -88- Public Works Equipment Replacements Audio/Visual Equipment $ 1,000 Cracksealer � $ 56,000 Vibratory Tamper $ 12,500 AVL/GPS $ 17,000 Asphalt Roller $ 40,000 Pavement Breaker $ 2,000 Curb Forms $ 2,000 Pavement Saw $ 23,000 Air Compressor $ 17,000 Berming Machine $ 18,000 Generator $ 1,500 Street Cleaninq Leaf Blower $ 600 AVL/GPS $ 2,000 Self-Propelled Lawn Mower = $ 8,600 Weedwhip $ 250 Snow & Ice Control 20" Snow Blower $ 1,200 Sanitary Sewer Maintenance Root Cutter $ 1,500 AVL/GPS $ 3,500 Manhole Blower $ 2,000 Gas monitor (1) $ 1,500 Jet flusher hose (3) $ 5,250 CCTV Printer (1) $ 250 Stormwater Maintenance Hand Concrete Saw $ 1,000 Earth Compactor � $ 11,000 Refuse Collection Refuse Collection Carts $ 652,698 AVL/GIS Equipment $ 9,000 Recycling Collection Program Recycling Bins/Lids (1,074) $ 18,084 Recycling Wheeled Carts (337) � $ 30,160 Yard Waste Collection Program Yard Waste Wheeled Carts $ 9,276 Public Works Garaae Shop Equipment $ 5,000 -89- Public Works Equipment Replacements Landfill Shop Equipment $ 2,000 Card Reader $ 700 Gator Utility Vehicle $ 23,416 Replacement Tarp Assembly $ 59,547 Recommended Improvement Requests $ 34,500 Total Equipment $1,096,781 Debt Service Debt service reflects annual repayment to ($753,013): Final Call Amount Debt Series Source Purpose Payment Date $ 39,415 G.O. Series 2017A Road Use Tax Equipment Replacement 2030 2025 $ 31,276 G.O. Series 2021A Sales Tax 30°/o Curb Ramp Program 2034 2028 $ 12,959 G.O Series 2018A Solid Waste Fees Solid Waste Trucks 2030 2025 $ 5,123 G.O. Series 2017A Solid Waste Fees Solid Waste Trucks 2031 2025 $ 1,237 Planned G.O. 2022 Solid Waste Fees Solid Waste Trucks $ 2,544 G.O. Series 2018A Sales Tax 20°/o Radio Replacement 2028 2026 Dubuque County - $309,784 G.O. Series 2014 Landfill Fees Landfill Improvements 2034 2022 Dubuque County - $350,675 G.O. Series 2016 Landfill Fees Landfill Improvements 2036 2024 $753,013 Total Public Works Annual Debt Service Revenue 34. Solid Waste monthly base fees increased from FY22 Budget of$3,397,934 to $3,510,597 in FY 2023 which is a $112,663 increase in revenue. This line item is based on FY 2019 actual of $3,433,154 plus the FY 20 rate increase of 1.63%, less the FY21 rate decrease of 4.03°/o, plus the FY 22 rate increase of 2.60% and the FY 2023 recommended rate increase of 0%. 35. Tipper Carts and extra/oversize can subscriptions increased from $825,457 in FY 2022 to $1,070,488 in FY 2023 based on FY 2021 actual of$924,934 and the addition of 2,000 additional cart services added by FY 2023. 36. Refuse Single Use Stickers increased from $109,486 in FY 2022 to $122,875 in FY 2023 based on FY 2021 actual of$122,875. 37. Yard Waste Annual Sticker/Single Use/Brush Ties increased from $125,601 in FY 2022 to $131,459 in FY 2023 based on FY 2021 of$131,459. 38. Purina Drive Salt Operations represent the purchase and sale of salt for the City's bid partners. The FY 2023 budget includes $97,665 in salt sales, $9,240 in salt handling fees, and $6,000 in salt storage. 39. The Solid Waste Agency payment increased from $4,700,138 in FY 2022 to $6,170,419 in FY 2023. Departmental employees operate the landfill, yard waste, e-waste, recycling drop-off and -90- household hazardous regional collection center facilities owned by the Dubuque Metropolitan Area Solid Waste Agency (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 2023. 40. 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 2023 overhead rate of$74.36 which is unchanged from the FY 2022 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: % Change From FY FY 2021 FY 2022 FY 2023 2022 City Garage Actual Budget Requested Budget Expenses Employee Expense 965,156 1,062,123 1,106,225 4.2 % Supplies and Services 156,687 155,993 158,333 1.5 % Garage Stores 715,158 831,859 966,045 16.1 % Machinery and Equipment 5,181 30,500 5,000 (83.6)% Total Expenses 1,842,182 2,080,475 2,235,603 7.5 % Resources Specialized Services 1,168,278 1,224,924 1,168,278 (4.6)°/o Fuel/Parts 736,442 741,491 736,442 (0.7)% County Fuel Sales 22,218 57,788 22,218 (61.6)°/o Reimbursements 31,092 58,172 30,329 (47.9)% Total Resources 1,958,030 2,082,375 1,957,267 (6.0)°/o Annual Operating Surplus (Deficit) 115,848 1,900 (278,336) (280,236) Garage Overhead Rate $ 74.36 $ 74.36 $ 74.36 -91- �uquque TI iE C1TY QF � AIFIMIk9 R1� DUB E ;I��I' 2 CC 7•2612-2013 �fr�L�('.Y��1f'f�c c>rr ���e �1i��r��t���ti za7�tzo�s TD: Michael C_Van Milligen, City Manager FRDM: Jahn Klastermann, Public 1Narks Direetar JFC Arielle Swift,Assis#an#Public Works Direc#or SUBJECT: Autamated 5ide Laader and City-Vlfide Mandatary Cart Use FY23 Budget Prapasal —Twa-Year Plan DATE: January 28,2022 In#roduc#ion The purpase af this memarandum is ta pravide infarmatian related ta the PublicVlfarks Department Fiseal Year 2023 Budget Impra�+ement Paekage and Capital Impravement Budget prapasals far the implementatian af autamated side laader callectian where passible and city-wide mandatary use af trash earts. This request is far trash earts anly and daes not include any change ta the current recycling callection program_ Discussion Caprtal lrrr�roverxrent Prciects The FY 2023 Public Vlfarks budget currently has three prajects related ta the callectian af salid waste trash pra�+iding far aptianal levels af service_ ane praject is in the Capital Impravement Budge#far the replacemen#of salid waste callec#ion vehicles �CIP#6�0- 1533}_Twa �+ersians ha�+e been develaped far the replacement af current salid waste vehicles. ane CIP has the project title of Solid Waste Callectian Vehicles which pravides far the annual replacement af salid waste�+ehicles with ane autamated side laader added ta the fleet in FY 2025. The secand aptianal salid waste fleet replacement is titled Salid 1Naste Callectian Vehicles —wilh City-Pravided Carts Cammunily 1Nide. This CIP pravides far the purchase af iwa autamated side laaders in FY 23 and ane in FY 25. This prapasal adds the extra cast af adding the arm ta iwa sidelaadertrucks already scheduled far replacement in FY 2023_ The added cast af an autamated sidelaader scheduled ta replace a current sidelaader in FY 2025 was already built inta the fi�+e year replacement sehedule and appra�+ed in the FY 2020 Capital Impravement Budgel. lm,�ravemerat Packaaes The PubliclNarks Dperating Budget alsa has iwa Impravement Paekage Requests related ta the purchase af additianal city pravided trash carts_ �ne requests funds �$80,000}far lhe purehase af additianal trash earts ta meet current eustamer demands. 1Nith this propasal the departmentwill alsa be requesting an update ta City�rdinance 13 Chapter 6 ta require all new subdivisians, with City-pra�+ided utility services,ta use city-awned trash carts if the city wide praposal is nat funded. -92- The second request wauld require #he city wide use of city provided trash carts, and pravide funds �$291,349}ta issue 5,000 carts in FY 2023 and $582,698 in FY 2024 far the purchase af an additianal 10,OQ0 carts. Rpproval af#he improvement package ta purchase 5,000 carts in FY 23 and FY 24 wauld eliminate the need far the ather funding reques# of$80,000. In FY 2023, persannel full time equivalent �FTE}will remain the same at 20_�5_ lm�rovir�a the Customer Ex�errence The mandatary cart pragram will use a 34-gallan cart as the base cart affered ta all eustamers. Custamers dty-wide will alsa have the aptian ta subseribe at an inereased manthly cast, a 48-gallan, 64-gallan, ar 96-gallan carl ta meet their individual need. This syslem streng#hens the current "pay as you throw concep#° while maximi�ing the weight limits allawed. The chart belaw is based on no rate increase in Fiscal Year 2023: 5ervice Fee Additional Comments Base Fee(35-gal� $��.3g �fl cart provided.SuCject to 6ase fee�`o increase 34-Gallon $15.38 Gity-awned cart provided.5u�ject ta base fee�`o increase d8-Gallan $17.22 No fee increase � 64-Gallon $20.&5 No fee increase 94-Gallon $29.U6 Nofeeincrease 48-Gallon (alley� $15.38 5u�ject ta base fee�`o increase 64-Gallan [alley� $16.65 Subject ta base fee�`a increase 9d-Gallon (alley� $24.78 5u�ject ta base fee% increase In the first year af the aty-wide mandatary cart pragram,the current aptian far additianal 35 gallan containers and oversized cantainers would end. Cus#omers will ins#ead be pra�+ided carts af their chaice at the subseriptian cart fee rate assaciated.This recommendation is made#a pro#ec#aur warkforce fram having ta reach in and remove bags fram a�+er-si�ed eans and eliminates the need far repetitive lifling af multiple cantainers at one stap. This change will effec##he fallawing custamers; • Additional 35 gallan cantainer option - 133 cus#amers * Oversize cantainer aptian — 386 custamers � Additianal D�+ersize cantainer aptian —18 custamers 2 -93- The new aty-wide cart system will pravide a new special callectian service far the frail and disabled residents wha may na#be able ta handle the 34-gallan cart. Exceptions will alsa be made far residents where the use af a cart creates a hardship due ta terrain_ It is alsa imparkan##a remember#hat far every 10 Ibs. picked up�loase#rash bag}pu#s 1,250 Ibs_ af pressure an the lawer backwhich is alleviated bywheeled trash carts_ Custamers will still be able ta buy stiekers far $1.�0 trofiich pravides them the ability ta put aut extra trash when that need arises, and the large item callectian service will still be a�+ailable at an extra east an an indi�+idual request. Ca�rna far Ern,�lovee 5afetv The ealleetian af refuse and reeyeling materials is eansistenlly ranked in the tap ten af mast dangerausjabs in the cauntry based an Bureau af Labar stalistics.This is due in part ta the time the warkers spend each day driving ar riding an the truek, in all weather candilians,which increases the risk af transpartatian related accidents. PJsa, the emplayees musl naw exit and enter the�+ehiele just under 600 times a day, almast 3,000 times a week, and over 150,000 times a year. This creates signif cant wear and lear an their legs, ankles and feet and creates severe slip and fall appartunities in icy and snawy weather_ �essor�s�earr�ed frorr� the Panderr�ie 1Ne learned during the pandemic that aur lifestyle ehanges ineluding warking fram hame, schaal clasings and sacial distancing alsa influenced aur salid waste callectian system_ 1Nhile there were always cancerns by staff abaut the manual callectian af trash due ta bed bugs and flees, cavid-19 braught that cancern ta a new level. Hawever, ane thing that put the mast pressure an aur antiquated callectian system is the increase af trash that needed ta be callected by aur staff due ta our lifeslyle changes_ Solid waste callectian tannage increased 14_70°I4 when campared 2019 tannage �11,622_19}and 2021 #onnage �13,331.39}. While the increased tannage is starting #o#rend dawn,there is na better time ta prepare far the next natural disaster by impraving aur callectian system_ The Public Warks Department statistics shaw that averthree years �201�-19}46_3°la af the farly-ane �41)deparlment wi de City af Qubuque OSHA repartable inj uries were related ta the callectian af salid waste_ During that same time periad, the tatal last warkdays related ta injuries ta salid waste crew members far the Cily af Dubuque were 43 and the related medical castwas $36,542_ While mast injuries require a shart recovery#ime other injuries are considered permanent and worker's compensation settlements are made far an injury aeeurring an the jab. Be#ween 2046 and 20'1 P,the top ten department employee claims related ta the callectian af salid waste were settled at a#o#al cast of$1,28P,F'14. Mare importantly,these emplayees los# '1,72a workdays away from wark.This nat anly caused hardship and stress far these emplayees but placed additianal warklaads an lhe remaining city staff. 3 -94- The fallawing reasans are being pravided ta suppart the revised praject_ - Reduce 1Narker Campensatian Claims-The lap 10 Cily af Dubuque injuries far salid waste callectian emplayees beiween 2D06 and 2017 equaled$1,257,710_ • Reduce Lost 1Norkdey+5 -The top 1 d worker's compensation claims for solid waste callectian emplayees beiween 2006 and 2017 had 1,�25 lostworkdays fram injuries_ - Reduce Emplayee Caneerns-1Nhile the pandemie has highlighted emplayee cancerns abaut tauching the trash, there has always been emplayee cancerns abaut being expased ta bed bugs and fleas. � aiscaunted Rate - Law-incame residents will cantinue ta qualify far a 50°/a discaunt an their manthly rate_ Discaunts are naw being subsidized by the General Fund in the same way eurrently being dane with starmwaterfees. � Dptian Dut -There will be custamer exceptians made in the cammunity where this will nat be implemented because af terrain. PJsa, exceptians will be made far the frail and disabled wha wauld struggle with a cart_ • Enviranmental�Aes#hetics—Since 2008 trash carts have been used in targeted areas with suceess ta reduee litter, impra�+e aesthetics an callectian day and help ta keep neighborhaads clean. - Custamer Canvenienee -The eily will awn and maintain the earls. � Future Grawth —The autamated side laaders will create the ability ta absarb same future grawth withaut adding emplayees and equipment. � Existing Vllark Farce -This recammendatian will preserve existing cityjabs and will nat privatize the system_ Ctrrrent Cart Praaram Since 2008 the publicwarks depar#men#has implemen#ed#rash carts into i#s collection pragram. At the start af the pragram the size af the carts a�+ailable were limited ta 48 gallon �in alleys only}, 64 and 96 gallan ci#ywide. In July of 2021, 34 gallon and 48 gallan cart services became available citywide_ Carts were being serviced by using a semi-autamated lifting system maunted an each truck_ In the fall af 2021 the department recei�+ed its firsl autamated side laader and plaeed it inla serviee an rautes that have the greatest number af carts_ The truck is being used sucessfully thraughaut the eity in all weather candilians and calleetian lacalians ineluding alleys. The chart belaw pravides an a�+erview af the current breakdawn af the cart sizes being used in aur�+aluntarypragram. 4 -95- Cart S¢e Total Carts in Service 34 C�AL(base} 4fifi 48 GAL 128-0 84 GAL 2770 94 GAL 710 96 C�AL�retycling} 74 Tota I 5,284 Due ta eart shartages there is currently 151 eustamers waiting far 34 gallan and 3S cus#omers waiting far48 gallon carts. Car#s are an arder and expected #a be delivered bythe spring af 2022. 1Nhen camparing aur eallectian system ta the tap ten mast papulated eities in lawa, we are one af the few that don't exclusively use carts in their program.The lasttime this prapasal was presented ta lhe Cily Cauncil there were eaneerns expressed that the prapased system had nat been pilated in Dubuque_ Since then we have implemented additianal carts and autamated callectian that has praven this type af system will wark in Dubuque_ Dur currenl experience with carts and autamated side laader callectian pravides us the data ta implement aperatianal effciencies and mave this prajectfanvard alywide_ lr�vestmer�ts fVavv Creates�ar�q Term Savir�qs The city has averaged abaut 1 DD new residenti al units each year aver an extended timeline_This budget assumes that will cantinue aver the next se�+eral years_ The implementalian af autamated side laaders where passible thraughaut the citywill pravide a safe wark enviranment far aur emplayees and allaw the department ta plan far future grawth related ta the Sauthwest Arterial and ather areas delaying the need ta add staff_ Rever�ue 1Nhile rate increases have no#ye# been de#ermined and any ra#e increase is related ta the tatality af the system and nat just lhe impact af carts,the belaw chart assumes na ra#e increase in FY 23 and then a 3°!o rate increase in FY 24 and beyand. Es#imates are based an ��°!o af the carts distributed are 34 gallan, 24°/o are 4S gallan, 16°l�are 64 gallon and 4°la are 94 gallan carts. Of the new carts being dis#ribu#ed, 44°la of#he new earls are anticipated ta bring in an additianal $36�,747 a�+er a �year periad. 5 -96- Twa year plan far cart delivery—re�+enue estimate by year. FY23 FY24 FY25 FY26 FY27 Tatal $125,905 $209,889 $12,888 $12,738 $12,809 $37A,00A E�IJEf75ES Carts wauld be distributed aver two years, 5,000 carts distributed in FY 2023 and 10,000 carts distribuled in FY 24. FY 202� -27 pra�+ides aperating funds ta meet additional demand for new accaunts and maintenance af existing carts. FY23 FY24 FY25 FY26 FY27 Tatal $291,349 $582,898 $30,400 $30,000 $30,000 $964,047 Additianal truck-r�lated expenses by Fiscal Year related ta the purchase af Autamated Side Laaders �ASL) �see CIP far additianal infarmatian} FY23 FY24 FY25 FY26 FY27 Tatal Total Fleet $�q2,A5A $-0fi2,A5A $4fi3,OdA $3A3,703 $355,732 $2,767,3A7 Replacement Cnst Addi[ional Cost $95,339{'� $50,731{� $746,070 [1J Additioanlwstrelatedtathepurchaseaf2A5L [2J lidditianal�st related ta the purchase af 1 AS Financing Implemen#ation The $1,020,11� implementatian casts af this new pragram will be funded with American Reseue Plan �ARPA}funds. Ac#ion Step This has been pravided as infarmatianal anly,far the r�view af the aptianal Public 1Narks Department FY23 Salid 1Naste fleet replacement Capital Impra�+ement Praject and Impra�+ement Package requests wt�ich suppart autamated callectian and mandatory city-wide trash cart use_ 6 -97- I�� �� � J ���} ������ �. ]RGAI�II�A'I'IDIV CHART PTCustodian[0.61] Foreman[1] Landfill Equipment Operator[5] Lead Administratfve Seasanal Equipment Operator[1] Assistant[9] � � Mechanic[1] Secretary(2� 5cale Operator[2� Director �ead nnecnanic�z� Assistant airector Lead Sanitatian Driver[1] Methanit[7] Fleet Accounti ng - Sanitatian�rfver[20] Clerk[1] 5taek Clerk[1] 5easanal 5anitatian Driver[7] Street Foreman[4] Sewer Foreman [2] Street EquipmentOperatnr II [6] - Sewer Equipment dperatar II[1] 5treet Equipment Uperatar I[�] Sewer Equipment Dperator I[5] Street Utilfty Warker[11] Seasonal Lalsorers(1.4� Traffic 5ignal Tech[3] Maint.Tech Appren#iceship[1] -98- This page intentionally left blank. -99- PU BLIC WORKS 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. SUCCESS IS ABOUT PLANNING, PARTNERSHIPS AND PEOPLE LEADING TO OUTCOMES PLANNIN� Dep�rtment plannint� is focused on greater effectiveness and efficrerrcies ir�the maintenance of Dub�ique's street; riverfrant; and sewer PE�PLE infrastructure; t�e maintenar�c� of tt�e �ity's Pu�lic 1J�ork� staff are pravided ve�icles and h�avy equipment, the management af professional development apportunities tF�e municipal solid �rast� and reeyclables to improve their knowledg� and gen�rated by our citi�e�s, and th�e management ex�ertise in order to �rovid� for tk�e and operation of tha Df��A�bVA-s facilities. develo{�m�nt and promotion af public � �ducation and customer outreach .� programs to sch�als. civic .k; S,�`'. �"�� - organi�ation�. cit�r councils, county ��'� +: � „�---�~__� -�t ��,-� su�ervisar�, and citi�ens #hroughout �„■,��_ �`� � Dubuq ue and Delaware countie�. 'Y� ._� _.-�_�_�,� �` ,���. . _�,� ��- . :�:-°��;�-: PARTiVER�HIPS In addit�on #o its �trong �artn�r�h��s with the En�ineerin�, V�later; Leisur� ��rvices; Fire, anc� Palice departmer�t�; the Public VVork� Department �artner�with num�rous s#ate and fed�ral agencie�. I# also ha� contractual partnerships with #he City of A�bury; �ubuque �aunty; �cott �ounty, Delaware �aur�ty, Loras Callege, the Univer�ity af Dubuque, the lawa Narthland Re�ional �ouncil of �avernments, Keep lowa Beautiful, and the Dubuque County �onservatian Baard. -100- PU BLIC WORKS FY 2021 FY 2022 FY 2023 Full-Time Equivalent 93.28 93.28 93.43 Resources �p�rating Salt Road V S� Tax S��'er storrh�,ater RepUs� � �andfill Pr�p��Y TaX SU � ppor� $0 $1,000,000$2,000,000$3,000,000$4,000,000$5,000,000$6,000,00( � FY 2021 FY 2022 FY 2023 The Public Works Department is supported by 93.43 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 9% in FY 2023 compared to FY 2022. Expenditures by Category by Fiscal Year $7,518,829 Employee Expense $8 382,72 $8,75 $7,590,773 Supplies and Services $7,843,583 � $8,417,13 $220,596 Machinery and Equipment $681,079 $1,096,781 $686,788 Garage/Stores 803,700 $966,357 $1,612,328 Administrative OH $1,659,457 $1,783,326 $1,223,389 Debt Service $803,718 $753,013 $0 $2,000,000 $4,000,000 $6,000,000 $8,000,000 FY 2021 FY 2022 � FY 2023 -101- PU BLIC WORKS 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 FY 2021 Actual FY 2022 Budget FY 2023 Requested Expenditures $(11,326) $3,185 $93,755 Resources $1,809 $63 $26 Administration Position Summary FY 2023 Public Works Director 1.00 Assistant Public Works Director 1.00 Lead Administrative Assistant 1.00 Secretary 2.00 Total FT Equivalent Employees 5.67 Performance Measures City Council Goal: Financially Responsible, High-Performance Organization Performance Measure (KPI) Target FY 2019 FY 2020 FY 2021 Performance Actual Actual Estimated Indicator � 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 > 95% N/A 66.3% 70% � Avg. time service requests are resolved: <10 days 19.00 13.58 11.64 ��� High Priority Avg. time service requests are resolved: <14 days 6.51 7.67 9.65 � Medium Priority Avg. time service requests are resolved: <30 days 1.96 59.55 15.13 ��� Low Priority 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. -102- PU BLIC 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 2021 Actual FY 2022 Budget FY 2023 Requested Expenditures $5,658,573 $6,343,478 $6,967,292 Resources $3,140,404 $3,459,392 $3,847,084 Street Maintenance Position Summary FY 2023 Foreman- Maintenance 3.20 Foreman-Snow and Ice 0.98 Field Supervisor- Maintenance 0.73 Field Supervisor-Snow and Ice 0.17 Truck Driver-Maintenance — Truck Driver-Snow and Ice — Truck Driver-Street Cleaning — Utility Worker-Maintenance 6.46 Utility Worker-Snow and Ice 1.85 Equipment Operator I -Street Signs 0.82 Equipment Operator I -Maintenance 4.11 Equipment Operator I -Snow& Ice 1.98 Equipment Operator I -Street Clean 0.83 Equipment Operator II -Traffic — Equipment Operator II -Street Signs 0.40 Equipment Operator II - Maint. 1.94 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 Laborer-Street Signs — Utility WorkerApprentice 0.83 Laborer-Street Cleaning 0.27 Maintenance Worker-Maintenance — Maintenance Worker-Snow — 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 31.30 -103- PU BLIC WORKS Performance Measures • FY 2019 FY 2020 FY 2021 Performance Performance Measure (KPI) Target Actual Actual Estimated Indicator 1 Activity Objective: Provide an effective and efficient road transportation network #of centerline miles of asphalt overlay 5 5.17 4.72 10.01 � projects completed per year City Council Goal: Sustainable Environment 3 Activity Objective: Replace City-owned high-pressure sodium street lights with more energy- efficient, longer lifespan LED lights. o r��% of City-owned LED lights increase 50% 50% 52% L � � , ,�,- 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 2015/2016 2016/2017 2017/2018 2018/2019 2019/2020 2020/2021 Number of Storms 15 12 25 26 22 17 Total Seasonal Snowfall 34.18 27.10 38.20 55.20 36.20 59.30 (inches) Type of Season Strong EN Weak LN Weak LN Weak EN Neutral Moderate LN Salt Used for Deicing 3,242 3,474 5,749 5,401 5,135 3,990 -104- PU BLIC WORKS 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 FY 2021 Actual FY 2022 Budget FY 2023 Requested Expenditures $846,151 $1,052,707 $1,000,423 Resources $846,151 $1,052,707 $1,000,423 Sewer Maintenance Position Summary FY 2023 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 FY 2019 FY 2020 FY 2021 Performance Actual Actual Estimated Indicator � 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 �5 42.2 99.19 92.93 � or inspected #of City sewer problems responded to (# 0 (50) 15 (76) 7 (53) 8 (61) � of private sewer problems responded to) total sanitary sewer pipe treated for 10,000 12,643 13,218 14,914 � intrusive root control (feet) City Council Goal: Financially Responsible, High Performance Organization Activity Objective: Ensure contractors' and developers' compliance with City specifications by 2 completing post-construction inspection of new or repaired sanitary and storm sewer infrastructure using City Media Service technology Total sewer pipe inspection footage using 35,000 22,067 42,844 48,000 � CMS equipment -105- PU BLIC 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 forAmerican 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 PorYs 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 2021 Actual FY 2022 Budget FY 2023 Requested Expenditures $327,233 $447,717 $510,387 Resources $4,038 $15,605 $12,969 Riverfront Maintenance and Operations Position Summary FY 2023 Foreman 0.08 Field Supervisor- Floodwall 0.10 Equipment Operator I 0.10 Equipment Operator I 0.73 Equipment Operator II - Riverfront 0.10 Equipment Operator II - Floodwall 0.12 Laborer- Riverfront 0.08 Laborer- Floodwall 0.10 Laborer- POD 0.45 Traffic Signal Technician 0.01 Total FT Equivalent Employees 1.87 -106- PU BLIC 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, Police, Fire, and Water departments, along with the buses of The Jule public transit system. Vehicle Maintenance Funding Summary FY 2021 Actual FY 2022 Budget FY 2023 Requested Expenditures $ 1,842,182 $ 2,080,475 $ 2,235,603 Resources $ 1,958,030 $ 2,082,375 $ 1,957,267 Vehicle Maintenance Position Summary FY 2023 Equipment Maintenance Supervisor 1.00 Lead Mechanic 2.00 Mechanic 7.00 Stock Clerk 1.00 InventoryAccounting 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 FY 2019 FY 2020 FY 2021 Performance Actual Actual Estimated Indicator � 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 N/A 9 9 10 N/A annual inspection -107- PU BLIC 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 2021 Actual FY 2022 Budget FY 2023 Requested Expenditures $4,209,958 $4,352,692 $5,148,917 Resources $4,391,424 $4,646,667 $5,690,986 Resource Management Position Summary FY 2023 Resource Management Coordinator 1.00 Lead Sanitation Driver 1.00 Sanitation Driver 18.00 Custodial I 0.08 Seasonal Sanitation Driver 0.08 Total FT Equivalent Employees 20.16 Performance Measures City Council Goal: Sustainable Environment Performance Measure(KPI) Target FY 2019 FY 2020 FY 2021 Performance Actual Actual Estimated Indicator � Activity Objective: Increase overall waste diversion rate of City collection materials by 1% per capita per day. % change in refuse as the total municipal o � materials collected curbside per capita per Annually N/A 9.9°/o (4.1)°/o � � day % change in recycling as the total � municipal materials collected curbside per Maintain N/A (3.0)% 0.9% � � capita per day % change in yard waste and food scraps o � as the total municipal materials collected Annua�lly N/A (13.5)% 3.7% � � curbside per capita per day 2 Activity Objective: Increase expanded use of City-owned wheeled collection carts. % of service-provided households >g0% 17.0% 21.0% 25.0% ��� subscribe to a refuse-wheeled cart Total municipal waste tonnages collected curbside increased 5.34% from FY2020 to FY2021. -108- Recommended Operating Revenue Budget - Department Total 54 - PUBLIC WORKS FY20 Actual FY21 Actual FY22 Adopted FY23 Recomm'd Fund Account Account Title Revenue Revenue Budget Budget 670 43110 INVF.STMENT 6ARNiNGS 27,158 14,295 10,000 14,295 43 USE OF MONEY AND PROPERTY-Total 27,158 14,295 10,000 14,295 670 44175 FEDERAL STIMULUS GRANTS 0 0 0 582,698 44 INTERGOVERMENTAL -Total � 0 0 i 0 582,698 940 45701 STATEGRANTS 0 1,470 0 1,470 45 STATE GRANTS -Total � 0 1,470 0 1,470 810 46105 FUEL SALES,COLTNTY 57,788 22,218 57,788 22,218 46 LOCAL GRANT AND REIMBURSE-Total 57,788 22,218 57,788 22,218 670 51215 LATF,PAYMF,NT PF.NALTY 41,138 1,885 41,162 1,878 610 51250 SEWER TV SERVICE CHARGES 0 4,762 1,500 4,762 670 51605 SOLID WASTE MONTHLY FEE 3,363,425 3,067,771 3,444,696 3,551,154 670 51606 SOLID WASTE VACANT CREDIT (46,762) (40,557) (46,762) (40,557) 670 51610 TIPPER CARTS 683,959 875,245 766,615 1,020,799 670 51615 EXTRA/OVERSIZE CAN SUBSCR 58,842 49,689 58,842 49,689 670 51620 REFUSE SINGLE USE REFUSE 109,486 122,875 109,486 122,875 670 51630 YARD WASTE STICKER ANNUAL 23,954 26,412 23,954 26,412 670 51635 YARD WASTE SINGLE USE STI 99,442 102,916 99,442 102,916 670 51640 YARD WASTE BRUSH T1E SALE 2,205 2,131 2,205 2,131 670 51641 SUBSCRIPTION RECYCLING 6,196 6,543 6,196 6,543 670 51642 FOOD SCRAP 10,647 9,131 10,647 9,131 940 51644 GAS SALES 0 0 0 70,000 670 51645 LEAF RAKE OUT FEES 5,915 7,205 5,915 7,205 670 51650 LARGE ITEM PiCKUP FEES 58,982 78,408 58,982 78,408 940 51660 SOLID WASTE AGENCY PMT 0 0 4,700,138 6,170,419 670 51665 RECYCABLE SALES 762 10,941 762 96,000 100 51910 STATE HIGHWAY MAINT 27,972 22,896 3,748 14,098 100 51956 PAVILION FEES 5,263 4,038 6,860 5,969 250 51975 SALE OF SALT 211,083 0 0 0 680 51975 SALE OF SALT 266,914 120,416 88,755 97,665 680 51976 SALT HANDLING FEE 44,693 0 9,060 9,240 680 51977 SALT STORAGE FEE 35,146 4,773 6,637 6,000 670 54647 ROW VIOLATION-COLLECT. 646 1,092 646 1,092 51 CHARGES FOR SERVICES -Total 5,009,907 4,478,571 9,399,486 ll,413,829 670 53102 PRIVATE PARTICIPANT 0 87 0 0 100 53201 REFUNDS 0 455 0 0 250 53201 REFLTNDS 0 134 0 0 610 53201 REFLTNDS 0 3,803 0 0 670 53201 REFLTNDS 2,287 0 2,287 0 810 53204 IOWA FUEL TAX REFLTND 55,493 26,818 55,493 26,818 810 53530 SPECIALIZED SERVICES 1,091,041 1,168,278 1,224,924 1,168,278 810 53570 FUEL/PARTS INTERNAL SVC 793,181 736,442 741,491 736,442 100 53605 MISCELLANEOUS REVENUE 591 630 591 630 250 53610 INSURANCE CLAIMS 0 395 0 0 100 53615 DAMAGE CLAIMS 15,152 18,851 18,400 14,309 100 53620 REIMBURSEMENTS-GENERAL 9,382 32,738 9,410 12,412 -109- Recommended Operating Revenue Budget - Department Total 54 - PUBLIC WORKS FY20 Actual FY21 Actual FY22 Adopted FY23 Recomm'd Fund Account Account Title Revenue Revenue Budget Budget 250 53620 REIMBURSEMENTS-GENERAL 5,686 61,858 13,848 16,504 610 53620 REIMBURSEMENTS-GENERAL 768 2,637 768 0 620 53620 REIMBURSEMENTS-GENERAL 60 0 60 0 670 53620 REIMBURSEMENTS-GENERAL 525 8,097 525 8,097 810 53620 REIMBURSEMENTS-GENERAL 50 763 0 0 940 53620 REIMBURSEMENTS-GENERAL 1,000 121 0 121 670 53630 SALES TAX COLLECTION 7,206 6,702 7,207 7,220 53 MISCELLANEOUS -Total 1,982,424 2,068,808 2,075,004 1,990,831 250 54106 EQUIPMF,NT SALF,S 0 41,000 0 0 100 54109 SALVAGE SALES 584 348 444 355 610 54109 SALVAGE SALES 1,293 1,959 1,293 1,959 810 54109 SALVAGE SALES 2,679 3,511 2,679 3,511 100 54110 SALE OF SIGNS AND MARKING 443 350 362 350 400 54210 GO BOND PROCEEDS 0 406,346 0 0 400 54220 BOND DiSCOLJNT 0 16,765 0 0 54 OTHER FINANCING SOURCES -Total 4,998 470,279 4,778 6,175 670 59100 FR G6NRRAL 0 40,557 43,860 43,000 400 59250 FR ROAD USE TAX 35,474 36,207 38,406 39,415 400 59300 FR STREET CONSTRUCTION 85,052 83,029 83,046 31,276 400 59350 FR SALES TAX CONSTRUCTION 13,890 12,829 13,173 12,959 59 TRANSFER IN AND INTERNAL -Total 134,416 172,622 178,485 126,650 PUBLIC WORKS -Total 7,216,692 7,228,264 11,725,541 14,158,166 -110- Recommended Operating Expenditure Budget - Department Total 54 - PUBLIC WORKS FY20 Actual FY21 Actual FY22 Adopted FY 23 Recomm'd Fund Account Account Title Expense Expense Budget Budget 100 61010 FULL-TIME EMPLOYEF.S 597,022 620,788 695,267 775,067 250 61010 FULL-TIME EMPLOYEES 1,290,635 1,302,012 1,657,401 1,678,291 610 61010 FULL-TIME EMPLOYEES 304,762 274,537 290,661 300,195 620 61010 FULL-TIME EMPLOYEES 108,891 91,084 120,358 124,961 630 61010 FULL-TIME EMPLOYEES 5,002 2,091 670 61010 FULL-TIME EMPLOYEES 1,110,119 1,096,672 1,172,906 1,213,316 810 61010 FULL-TiME EMPLOYEES 606,787 616,239 716,152 744,471 940 61010 FULL-TIME EMPLOYEES 569,973 601,720 682,936 701,888 100 61020 PART-TIME EMPLOYEES 6,487 26,314 250 61020 PART-T1ME EMPLOYEES 17,545 19,827 18,789 19,400 670 61020 PART-TIME EMPLOYEES 2,619 3,027 3,956 4,084 810 61020 PART-TIME EMPLOYEES 6,023 6,679 7,417 7,658 100 61030 SEASONAL EMPLOYEES 19,047 974 37,452 20,922 250 61030 SEASONAL EMPLOYEES 2,040 719 8,915 8,913 610 61030 SEASONAL EMPLOYEES 79 620 61030 SEASONAL EMPLOYEES 56 630 61030 SEASONAL EMPLOYEES 821 670 61030 SEASONAL EMPLOYEES 9,309 3,114 22,061 2,719 940 61030 SEASONAL EMPLOYEES 1,146 - 24,696 25,494 100 61050 OVERTIME PAY 53,310 31,284 35,241 35,241 250 61050 OVERTIME PAY 134,739 181,547 156,000 156,000 610 61050 OVERTIME PAY 10,529 4,353 10,250 L0,250 620 61050 OVERTIME PAY 2,347 1,223 2,050 2,050 630 61050 OVERTIME PAY 40 670 61050 OVERTIME PAY 24,207 28,418 21,400 21,400 810 61050 OVERTIME PAY 45,235 45,901 28,250 28,250 940 61050 OVERTIME PAY 74,793 32,970 71,200 71,200 100 61070 HOLIDAY PAY 114 3,056 100 61071 HOLIDAY PAY-OVERTIME 3,831 1,846 4,100 4,100 250 61071 HOLIDAY PAY-OVERTIME 23,354 37,288 13,050 22,362 610 61071 HOLIDAY PAY-OVERTIME 334 750 1,900 620 61071 HOLIDAY PAY-OVERTIME 349 35 479 670 61071 HOLIDAY PAY-OVERTIME 23,806 28,418 19,700 33,034 810 61071 HOLIDAY PAY-OVERTIME 3,2ll 3,832 3,000 7,232 940 61071 HOLIDAY PAY-OVERTIME 13,731 15,074 16,500 23,540 100 61081 COVIDI9 SCHOOL/DAYCARE CL 1,438 250 61081 COVIDI9 SCHOOL/DAYCARE CL 736 940 61081 COVIDI9 SCHOOL/DAYCARE CL 228 250 61083 COVIDI9 EMP NON-WORK 14,550 610 61083 COVIDI9 EMP NON-WORK 849 620 61083 COVIDI9 EMP NON-WORK 228 670 61083 COV1D19 EMP NON-WORK 1,868 810 61083 COVIDI9 EMP NON-WORK 684 940 61083 COVIDI9 EMP NON-WORK 3,860 250 61085 SELF QUARANTINE HEALTH 2,081 8,189 -111- Recommended Operating Expenditure Budget - Department Total 54 - PUBLIC WORKS FY20 Actual FY21 Actual FY22 Adopted FY 23 Recomm'd Fund Account Account Title Expense Expense Budget Budget 610 61085 SELF QUARANTINE HEALTH 1,873 670 61085 SELF QUARANTINE HEALTH 12,648 810 61085 SELF QUARANTINE HEALTH - 6,198 - - 940 61085 SELF QUARANTINE HEALTH - 2,283 - - 100 61091 SICK LEAVE PAYOFF 15,793 14,262 435 4,362 250 61091 SICK LEAVE PAYOFF 12,611 11,503 3,309 5,127 610 61091 SICK LEAVE PAYOFF 686 620 61091 SICK LEAVE PAYOFF 5,789 5,789 5,784 4,460 670 61091 SICK LEAVE PAYOFF 8,767 11,653 14,332 12,327 810 61091 S1CK LEAVE PAYOFF 716 940 61091 SICK LEAVE PAYOFF 2,945 4,107 1,881 1,696 250 61092 VACATION PAYOFF 1,271 2,387 610 61092 VACATION PAYOFF 8,298 670 61092 VACATION PAYOFF 3,414 9,514 810 61092 VACATION PAYOFF 326 940 61092 VACATION PAYOFF 683 670 61095 PARENTAL LEAVE 2,359 100 61096 50%SICK LEAVE PAYOUT 3,294 4,079 4,140 4,079 250 61096 50%SICK LEAVE PAYOUT 1,301 1,632 1,301 1,632 100 61310 IPERS 63,127 61,730 72,885 82,883 250 61310 IPERS 140,107 146,213 175,027 176,665 610 61310 IPERS 29,968 26,366 28,476 29,377 620 61310 IPERS 10,555 8,717 11,557 11,991 630 61310 IPERS 472 201 670 61310 IPERS ll0,097 110,358 117,058 120,411 810 61310 IPERS 62,487 64,083 71,255 73,952 940 61310 IPERS 62,539 61,553 75,075 79,282 100 61320 SOCIAL SECURITY 51,511 48,938 60,041 67,822 250 61320 SOCIAL SECURITY 107,568 112,712 142,098 144,402 610 61320 SOCIAL SECURITY 23,192 20,059 23,076 23,807 620 61320 SOCIAL SECURITY 8,398 7,049 9,808 10,058 630 61320 SOCIAL SECURITY 419 152 670 61320 SOCIAL SECURITY 86,172 86,452 95,572 99,496 810 61320 SOCIAL SECURITY 48,490 49,447 57,743 59,930 940 61320 SOCIAL SECURITY 48,646 47,364 60,984 64,567 100 61410 HEALTH INSURANCE 96,248 150,258 133,581 148,059 250 61410 HEALTH INSURANCE 295,894 350,336 376,689 382,997 610 61410 HEALTH INSURANCE 65,106 63,345 65,941 67,919 620 61410 HEALTH INSURANCE 21,110 25,072 26,584 27,382 630 61410 HEALTH INSURANCE 1,587 633 670 61410 HEALTH INSURANCE 216,719 258,216 260,639 275,977 810 61410 HEALTH 1NSURANCE 130,032 147,552 156,384 161,076 940 61410 HEALTH INSURANCE 119,189 135,262 143,354 164,561 100 61415 WORKMENS'COMPENSATION 16,031 16,350 15,273 13,548 250 61415 WORKMENS'COMPENSATION 126,541 136,323 115,111 112,397 -112- Recommended Operating Expenditure Budget - Department Total 54 - PUBLIC WORKS FY20 Actual FY21 Actual FY22 Adopted FY 23 Recomm'd Fund Account Account Title Expense Expense Budget Budget 610 61415 WORKMENS'COMPENSATION 7,924 8,206 6,306 7,594 620 61415 WORKMENS'COMPENSATION 2,597 2,661 2,557 3,107 670 61415 WORKMENS'COMPENSATION 102,426 105,752 98,732 116,942 810 61415 WORKMENS'COMPENSATION 17,953 18,800 16,280 17,476 940 61415 WORKMENS'COMPENSATION 64,574 69,484 60,662 72,054 100 61416 LIFE INSURANCE 488 493 602 561 250 61416 LIFEiNSURANCE 920 948 1,597 1,318 610 61416 LIFE INSURANCE 209 191 284 234 620 61416 LIFE INSURANCE 81 71 ll 6 96 630 61416 L1FE 1NSURANCE 4 2 670 61416 LIFEINSURANCE 802 802 1,105 951 810 61416 LIFE INSURANCE 454 470 660 552 940 61416 LIFE INSURANCE 408 444 614 610 670 61417 LTNEMPLOYMENT INSURANCE 647 100 61640 SAFETY EQUiPMENT 1,143 697 1,097 1,097 250 61640 SAFETY EQUIPMENT 7,486 3,642 3,408 3,408 610 61640 SAFETY EQUIPMENT 2,713 1,588 1,003 1,003 620 61640 SAFETY EQUIPMENT 492 341 334 334 670 61640 SAFETY EQUIPMENT 4,ll2 3,338 3,018 3,018 810 61640 SAFETY EQUIPMENT 2,212 2,131 1,604 1,604 940 61640 SAFETY EQUIPMENT 4,395 5,702 4,540 4,540 810 61645 TOOL ALLOWANCE 1,800 1,600 1,800 1,800 940 61645 TOOL ALLOWANCE 200 200 200 200 100 61650 MEAL ALLOWANCE 846 120 846 120 250 61650 MEAL ALLOWANCE 3,234 4,116 3,234 4,ll6 610 61650 MEAL ALLOWANCE 126 30 126 30 620 61650 MEAL ALLOWANCE 54 42 54 42 670 61650 MEAL ALLOWANCE - 6 - 6 810 61650 MEAL ALLOWANCE 1,536 1,416 1,536 1,416 940 61650 MEAL ALLOWANCE 1,026 408 1,026 408 250 61651 MEALS NO OVERNIGHT 50 610 61651 MEALS NO OVERNIGHT 12 620 61651 MEALS NO OVERNIGHT 8 940 61651 MEALS NO OVERNIGHT 24 250 61660 EMPLOYEE PHYSICALS 1,516 - 1,516 - 610 61660 EMPLOYEE PHYSICALS 604 274 604 274 620 61660 EMPLOYEE PHYSICALS 252 - 252 - 670 61660 EMPLOYEE PHYSICALS 105 167 105 167 810 61660 EMPLOYEE PHYSICALS 42 808 42 808 940 61660 EMPLOYEE PHYSICALS 366 412 366 412 100 61680 EMPLOYEE MOVING EXPENSE 6,600 900 61-WAGES AND BENEFITS 7,349,030 7,518,829 8,382,724 8,752,327 100 62010 OFFICE SUPPLIES 2,476 2,598 2,476 2,598 250 62010 OFFICE SUPPLIES 5 114 - 114 610 62010 OFFICE SUPPLIES 130 44 133 44 -113- Recommended Operating Expenditure Budget - Department Total 54 - PUBLIC WORKS FY20 Actual FY21 Actual FY22 Adopted FY 23 Recomm'd Fund Account Account Title Expense Expense Budget Budget 620 62010 OFFICE SUPPLIES 22 22 670 62010 OFFICE SUPPLIES 50 140 50 140 810 62010 OFFICE SUPPLIES 473 628 473 628 940 62010 OFFICE SUPPLIES 2,191 1,872 2,304 1,872 100 62011 LTNIFORM PURCHASES 912 1,440 912 1,441 250 62011 LTNIFORM PURCHASES 5,268 8,755 5,268 5,268 610 62011 LTNIFORM PURCHASES 776 1,185 776 1,185 620 620ll LTNIFORM PURCHASES 321 916 321 916 670 620ll iJNIFORM PURCHASES 2,334 4,850 2,351 4,851 810 62011 UNIFORM PURCHASES 517 431 431 940 62011 UNIFORMPURCHASES 1,068 1,122 1,068 1,122 810 62013 UNIFORM MAINTENANCE 1,634 4,290 3,580 4,290 940 62013 LTNIFORM MAINTENANCE 734 312 734 312 100 62030 POSTAGE AND SHIPPING 832 1,367 865 1,395 250 62030 POSTAGE AND SHIPPING 245 255 670 62030 POSTAGE AND SHIPPING 36 230 36 236 810 62030 POSTAGE AND SHIPPING 1 9 10 940 62030 POSTAGE AND SHIPPING 693 1,044 707 1,065 100 62033 HAND TOOLS/EQUIPMENT 30 29 30 30 250 62033 HAND TOOLS/EQUIPMENT 4,208 5,569 4,371 5,681 610 62033 HAND TOOLS/EQUIPMENT 1,931 1,390 1,200 1,418 620 62033 HAND TOOLS/EQUIPMENT 641 377 666 384 670 62033 HAND TOOLS/EQUTPMENT 37 38 810 62033 HAND TOOLS/EQUIPMENT 2,534 3,500 940 62033 HAND TOOLS/EQUIPMENT 3,445 10,522 3,514 20,732 100 62034 REPAIRPARTS/SUPPLIES 14,086 4,140 14,655 10,915 250 62034 REPAIR PARTS/SUPPLIES 18,291 13,870 20,132 40,445 610 62034 REPAIR PARTS/SUPPLIES 32,551 15,205 26,586 15,509 620 62034 REPAIR PARTS/SUPPLIES 7,577 12,553 7,884 12,804 670 62034 REPAIR PARTS/SUPPLIES 845 796 861 812 810 62034 REPAIRPARTS/SUPPLIES 718 l,lll 868 1,134 940 62034 REPAIR PARTS/SUPPLIES 34,365 19,320 98,556 23,567 250 62036 CONSTRUCTION SUPPLIES 46,322 58,867 48,193 60,044 810 62050 OFFICE EQUIPMENT MA1NT 522 532 100 62061 DP EQUIP.MAINT CONTRACTS 6,558 10,241 10,241 9,568 810 62061 DP EQUIP.MAINT CONTRACTS 3,378 5,276 5,276 4,929 250 62062 JANITORIAL SUPPLIES 6,181 5,632 6,430 5,745 670 62062 JANITORIAL SUPPLIES 1,166 1,063 1,190 1,084 810 62062 JANITORIAL SUPPLIES 2,216 2,019 2,880 2,059 940 62062 JANITORIAL SUPPLIES 953 643 972 656 250 62063 SAFETY RELATED SUPPLIES 3,145 940 62063 SAFETY RELATED SUPPLIES 290 296 100 62064 ELECTRICAL SUPPLIES 1,668 1,201 1,735 1,225 250 62064 ELECTRICAL SUPPLIES 164 1,982 171 2,021 670 62064 ELECTRICAL SUPPLIES 31 374 32 381 -114- Recommended Operating Expenditure Budget - Department Total 54 - PUBLIC WORKS FY20 Actual FY21 Actual FY22 Adopted FY 23 Recomm'd Fund Account Account Title Expense Expense Budget Budget 810 62064 ELECTRICAL SUPPLIES 59 710 60 725 940 62064 ELECTRICAL SUPPLIES 218 222 100 62090 PRINTING&BINDING 18 200 19 ll2 250 62090 PRINTING&BINDING 2,442 956 2,541 2,491 670 62090 PRINTING&BINDING 20,517 20,991 20,927 20,927 810 62090 PRINTING&BINDING 288 940 62090 PRINTING&BINDING 257 170 312 262 100 62110 COPYING/REPRODUCTION 1,370 1,349 1,370 1,349 250 62110 COPYING/REPRODUCTION 610 62110 COPYING/REPRODUCTION 670 62110 COPYING/REPRODUCTION 153 37 153 37 810 62110 COPYING/REPRODUCTION 149 162 149 162 940 62]LO COPYING/REPRODUCTION 1,455 833 1,455 833 100 62130 LEGAL NOTICES&ADS 281 172 250 62130 LEGAL NOTICES&ADS 2,419 471 2,419 366 610 62130 LEGAL NOTICES&ADS 252 252 620 62130 LEGAL NOTICES&ADS 46 670 62130 LEGAL NOTICES&ADS 3,284 1,896 3,284 1,271 810 62130 LEGAL NOTICES&ADS 1,135 581 5,300 581 940 62130 LEGAL NOTICES&ADS 1,767 823 1,767 823 670 62140 PROMOTION 10,126 5,573 14,452 14,452 940 62140 PROMOTION 5,566 29,140 66,580 18,580 100 62170 SUBSCRIPTIONS-BOOKS-MAPS 2,146 1,293 2,232 1,319 670 62170 SUBSCRIPTIONS-BOOKS-MAPS 14 14 940 62170 SUBSCRIPTIONS-BOOKS-MAPS 32 33 100 62190 DUES&MEMBERSHIPS 1,893 1,451 1,969 1,480 250 62190 DUES&MEMBERSHIPS 416 430 1,061 439 670 62190 DUES&MEMBERSHIPS 223 293 227 299 810 62190 DUES&MEMBERSHIPS 202 208 206 212 940 62190 DUES&MEMBERSHIPS 4,754 3,549 4,535 3,603 100 62204 REFLTNDS 75 75 75 610 62204 REFLTNDS 500 1,000 500 670 62204 REFiJNDS 2,676 2,294 2,676 2,294 940 62204 REFUNDS 66 168 66 168 100 62206 PROPERTYINSURANCE 6,659 2,169 1,596 5,872 250 62206 PROPERTY INSURANCE 19,201 16,643 32,800 20,336 670 62206 PROPERTY INSURANCE 1,423 1,563 1,694 1,856 810 62206 PROPERTY INSURANCE 3,578 3,168 3,433 3,761 940 62206 PROPERTY iNSURANCE 75,801 49,097 52,189 87,817 100 62208 GENERAL LIABILITY INSURAN 13,432 13,170 13,887 19,601 250 62208 GENERAL LIABILITY INSURAN 33,580 32,946 34,739 49,031 610 62208 GENERAL LIABILITY INSURAN 7,743 7,594 8,007 ll,301 620 62208 GENERAL LIABILITY INSURAN 9,380 9,185 9,685 13,670 670 62208 GENERAL LIABILITY INSURAN 20,322 19,920 21,005 29,648 810 62208 GENERAL LIABILITY INSURAN 13,026 13,031 13,728 3,040 -115- Recommended Operating Expenditure Budget - Department Total 54 - PUBLIC WORKS FY20 Actual FY21 Actual FY22 Adopted FY 23 Recomm'd Fund Account Account Title Expense Expense Budget Budget 940 62208 GENERALLIABILITYINSURAN 34,214 35,410 37,184 44,192 670 62210 SALES TAX 7,219 6,771 7,219 7,220 940 62210 SALES TAX 65,004 92,379 65,004 92,379 940 62211 PROPERTY TAX 2,264 - 2,309 - 100 62310 TRAVEL-CONFERENCES 8,417 1,219 22,200 22,200 250 62310 TRAVEL-CONFERENCES 829 670 62310 TRAVEL-CONFERENCES 870 6,900 2,250 810 62310 TRAVEL-CONFERENCES 367 926 3,840 3,840 940 62310 TRAVF,L-CONFERENCES 2,613 (504) 9,470 10,970 100 62320 TRAVEL-CITY BUSINESS 198 286 286 250 62320 TRAVEL-CITY BUSINESS 145 670 62320 TRAVEL-CITY BUSINESS 256 - 373 373 810 62320 TRAVEL-CITY BUSINESS 1,186 1,186 940 62320 TRAVEL-CITY BUSINESS 4,162 11 3,828 3,828 100 62340 MTLEAGE/LOCAL TRANSP 245 220 307 307 940 62340 MILEAGE/LOCAL TRANSP 1,024 794 3,036 3,036 100 62360 EDUCATION&TRAINING 3,928 1,910 5,952 5,952 250 62360 EDUCATION&TRAINING 7,409 2,2ll 10,727 41,327 610 62360 EDUCATION&TRAINING 4,507 437 8,000 8,000 620 62360 EDUCATION&TRAINING 190 295 300 300 670 62360 EDUCATION&TRAINING 21 595 1,200 1,200 810 62360 EDUCATION&TRAINING 628 1,835 7,500 7,500 940 62360 EDUCATION&TRAiNING 5,473 2,200 13,810 23,110 940 62363 GREEN VISION-EDUC/TRAIN 46,810 33,229 12,000 12,000 100 624ll UTILITY EXP-ELECTRICITY 57,350 20,889 52,057 57,558 250 62411 UTILITY EXP-ELECTRICITY 64,414 55,008 71,017 54,245 620 62411 UTILITY EXP-ELECTRICITY 2,853 1,996 3,146 1,818 670 62411 UTILITY EXP-ELECTRICITY 11,153 9,610 11,711 9,321 810 62411 UTILITY EXP-ELECTRICITY 21,191 18,259 23,363 17,711 940 62411 UTILITY EXP-ELECTRICITY 24,354 26,069 25,571 23,510 250 62412 UTILITY EXP-GAS 28,593 18,435 28,593 27,287 670 62412 UTILITY EXP-GAS 3,442 1,633 3,442 2,605 810 62412 UTILITY EXP-GAS 6,540 3,102 6,540 4,950 940 62412 UTILITY EXP-GAS 8,ll2 10,873 8,ll2 14,304 100 62415 UTILITY EXPENSE STORMWATR - 1,234 - 1,338 250 62415 UTILITY EXPENSE STORMWATR 963 1,543 1,050 1,674 670 62415 UTILITY EXPENSE STORMWATR - 109 - 118 810 62415 UTILITY EXPENSE STORMWATR 207 224 940 62415 UTILITY EXPENSE STORMWATR 6,800 6,822 7,264 7,399 100 62419 UTILITY EXP-ELEC ST LTNG 32,674 30,184 34,280 30,921 250 62419 UTILITY EXP-ELEC ST LTNG 815,124 743,646 835,020 760,221 100 62421 TELEPHONE 5,933 6,794 6,804 6,795 250 62421 TELEPHONE 2,468 2,453 2,467 2,453 610 62421 TELEPHONE 172 159 172 159 670 62421 TELEPHONE 1,783 1,867 1,783 1,867 -116- Recommended Operating Expenditure Budget - Department Total 54 - PUBLIC WORKS FY20 Actual FY21 Actual FY22 Adopted FY 23 Recomm'd Fund Account Account Title Expense Expense Budget Budget 810 62421 TELEPHONE 1,648 2,284 1,648 2,284 940 62421 TELEPHONE 2,519 4,184 2,519 3,470 100 62424 RADIO/PAGERFEE 2,842 2,174 3,172 2,304 250 62424 RADIO/PAGERFEE 12,816 10,120 14,360 10,727 610 62424 RADIO/PAGER FEE 1,895 1,449 2,128 1,536 620 62424 RADIO/PAGER FEE 947 725 1,064 768 670 62424 RADIO/PAGER FEE 5,368 4,107 5,691 4,353 810 62424 RADIO/PAGER FEE 947 725 1,064 768 940 62424 RADIO/PAGER FEE 4,132 3,114 4,643 3,300 100 62431 PROPERTY MAINTENANCE 11,497 1,524 5,000 3,595 250 62431 PROPERTY MAINTENANCE 31,595 38,654 74,405 38,653 670 62431 PROPERTY MAINTENANCE 5,428 6,459 13,266 6,459 810 62431 PROPERTY MAINTENANCE 18,650 25,597 25,206 25,597 940 62431 PROPERTY MAINTENANCE 74,747 147,137 83,974 99,980 250 62434 HVAC MAINTENANCE 11,608 9,505 11,608 9,505 670 62434 HVAC MAINTENANCE 1,449 1,519 1,449 1,519 810 62434 HVAC MAINTENANCE 2,079 2,887 2,079 2,887 940 62434 HVAC MAINTENANCE 508 508 250 62435 ELEVATOR MAINTENANCE 856 856 856 856 670 62435 ELEVATOR MAINTENANCE 162 162 162 162 810 62435 ELEVATOR MAINTENANCE 238 307 238 307 100 62436 RENTAL OF SPACE 660 660 660 660 940 62436 RENTAL OF SPACE 3,877 1,950 3,877 100 62437 BARRICADE RENTAL 505 450 250 62437 BARRICADE RENTAL 6,332 6,332 6,332 610 62437 BARRICADE RENTAL 520 520 250 62438 FIRE SUPPRESSION 2,892 1,634 2,892 1,634 670 62438 FIRE SUPPRESSION 546 241 546 241 810 62438 FIRE SUPPRESSION 1,037 459 1,037 459 100 62511 FUEL,MOTOR VEHICLE 12,079 9,390 11,082 12,190 250 62511 FUEL,MOTOR VEHICLE 118,303 130,090 113,561 124,917 610 625ll FUEL,MOTOR VEHICLE 13,564 11,793 9,010 9,911 620 625ll FUEL,MOTOR VEHICLE 3,938 3,167 14,948 16,443 670 625ll FUEL,MOTOR VEHICLE 107,998 105,359 85,590 89,869 810 625ll FUEL,MOTOR VEHICLE 2,865 2,102 3,227 3,550 940 62511 FUEL,MOTOR VEHICLE 2,239 2,438 2,215 2,436 100 62512 FUEL,OFF ROAD VEHICLE 601 - 60 L - 810 62512 FUEL,OFF ROAD VEHICLE 371 352 371 352 940 62512 FUEL,OFF ROAD VEHICLE 116,738 106,587 116,738 106,587 100 62521 MOTOR VEHICLE MAINT. 16,008 18,075 16,605 15,710 250 62521 MOTOR VEHICLE MAINT. 106,222 123,545 110,008 126,016 610 62521 MOTOR VEHICLE MA1NT. 33,094 21,959 34,430 22,399 620 62521 MOTOR VEHICLE MAINT. 7,497 4,339 7,800 4,426 670 62521 MOTOR VEHICLE MAINT. 205,855 237,069 209,972 241,811 810 62521 MOTOR VEHICLE MAINT. 4,387 5,408 4,565 5,516 -117- Recommended Operating Expenditure Budget - Department Total 54 - PUBLIC WORKS FY20 Actual FY21 Actual FY22 Adopted FY 23 Recomm'd Fund Account Account Title Expense Expense Budget Budget 940 62521 MOTOR VEHICLE MAINT. 5,981 2,595 6,101 2,647 250 62522 VEHICLE MA1NT.,ACCIDENT 1,816 4,031 1,949 670 62522 VEHICLE MAINT.,ACCIDENT - 17,054 - 5,688 100 62528 MOTOR VEH.MAINT.OUTSOUR 10,773 6,881 6,086 6,086 250 62528 MOTOR VEH.MAINT.OUTSOUR 52,237 42,756 42,275 42,275 610 62528 MOTOR VEH.MAINT.OUTSOUR 11,717 3,784 1,909 1,909 620 62528 MOTOR VEH.MAINT.OUTSOUR 2,073 1,164 922 922 670 62528 MOTOR VEH.MAINT.OUTSOUR 110,199 57,408 53,979 53,979 810 62528 MOTOR VEH.MAINT.OUTSOUR 380 1,366 279 279 940 62528 MOTOR VEH.MA1NT.OUTSOUR 9,107 7,127 6,035 6,035 620 62608 MAINSTREAM VOUCHERS HAP - 74 - - 100 62611 MACH/EQUIP MAINTENANCE 35,269 6,069 25,756 17,684 250 62611 MACH/EQUIP MAINTENANCE 399,252 513,049 399,252 513,049 610 62611 MACH/EQUIP MAINTENANCE 2,696 3,428 2,696 3,428 620 62611 MACH/EQUTP MAINTENANCE 3,905 1,104 3,905 1,104 810 626ll MACH/EQUIP MAINTENANCE 20,879 43,838 20,879 43,838 940 626ll MACH/EQUIP MAINTENANCE 197,137 168,832 197,137 168,832 100 62614 EQU1P MAINT CONTRACT 3,343 4,168 3,343 4,168 250 62614 EQUIP MAINT CONTRACT 10,956 13,287 10,956 13,288 610 62614 EQUIP MAINT CONTRACT 590 1,172 590 1,172 620 62614 EQUIP MAINT CONTRACT 295 586 295 586 670 62614 EQUIP MAINT CONTRACT 1,888 3,745 1,887 3,745 680 62614 EQUIP MAINT CONTRACT 940 1,634 940 1,634 810 62614 EQUIP MAINT CONTRACT 403 1,279 403 1,279 940 62614 EQUIP MAINT CONTRACT 7,674 9,278 7,674 9,278 100 62615 MACH/EQUIP MA1NT.OUTSOUR 17,053 17,887 17,053 17,887 250 62615 MACH/EQUIP MAINT.OUTSOUR 30,679 53,938 30,679 27,490 610 62615 MACH/EQUIP MAINT.OUTSOUR 8,784 7,431 8,784 7,431 620 62615 MACH/EQUIP MAINT.OUTSOUR 4,096 40 3,738 40 810 62615 MACH/EQUIP MAINT.OUTSOUR 601 686 601 686 940 62615 MACH/EQUTP MAINT.OUTSOUR 42,523 28,194 42,523 35,253 100 62616 TRAFFIC&ST LT COMPONENT 43,251 46,075 43,251 46,075 250 62616 TRAFFIC&ST LT COMPONENT 14 14 100 62617 TRAFFIC CONTROLLER REPAIR 357 1,128 357 250 62618 ASPHALT 667,543 780,225 706,307 1,110,685 610 62618 ASPHALT 6,301 8,917 6,301 8,917 620 62618 ASPHALT 6,400 2,124 6,400 2,124 940 62618 ASPHALT 2,224 2,224 100 62619 CONCRETE 2,633 1,108 2,633 250 62619 CONCRETE 152,187 113,258 125,774 125,715 610 62619 CONCRETE 15,070 8,463 15,070 8,463 620 62619 CONCRETE 11,662 14,437 ll,662 14,437 940 62619 CONCRETE - 2,330 7,010 2,330 100 62620 STONE 1,091 - 1,238 - 250 62620 STONE 21,912 34,557 23,664 34,557 -118- Recommended Operating Expenditure Budget - Department Total 54 - PUBLIC WORKS FY20 Actual FY21 Actual FY22 Adopted FY 23 Recomm'd Fund Account Account Title Expense Expense Budget Budget 610 62620 STONE 1,471 96 1,471 96 620 62620 STONE 933 607 933 607 670 62620 STONE - 28 - 28 940 62620 STONE 81,227 45,447 81,227 45,447 100 62627 CAMERA MAINTENANCE 960 - 912 - 250 62627 CAMERA MAINTENANCE 144 144 144 144 940 62627 CAMERA MAiNTENANCE 2,567 2,567 2,567 250 62636 D&ICING PRODUCTS 3,508 4,404 ll,164 4,404 940 62636 D&ICING PRODUCTS 2,967 2,070 2,967 2,070 100 62637 LANDSCAPE/FERT/PLANTS 10,294 1,267 10,294 10,655 250 62640 SALT 470,947 262,670 339,103 384,750 680 62640 SALT 248,305 103,272 88,755 96,750 940 62649 BEVERAGE/ICE 781 632 781 632 100 62663 SOFTWARELICENSEEXP 13,764 10,135 13,763 16,175 250 62663 SOFTWARELICENSEEXP 22,166 31,029 22,166 31,029 610 62663 SOFTWARE LICENSE EXP 24,090 24,898 24,170 24,898 670 62663 SOFTWARE LICENSE EXP 9,054 9,137 9,180 18,918 810 62663 SOFTWARE LICENSE EXP 11,468 9,307 8,335 9,307 940 62663 SOFTWARE LICENSE EXP 19,284 26,946 5,410 10,642 810 62664 LICENSE/PERMIT FEES 435 675 435 675 940 62664 LICENSE/PERMIT FEES 670 34 700 284 670 62666 CREDIT CARD CHARGE 96 96 940 62666 CREDIT CARD CHARGE 24,123 30,212 24,123 30,212 100 62667 DATA SERVICES 755 1,182 995 1,182 250 62667 DATA SERVICES 365 350 365 610 62667 DATA SERVICES 486 469 486 469 620 62667 DATA SERVICES 162 163 162 163 670 62667 DATA SERVICES 285 293 285 292 810 62667 DATA SERVICES 162 146 175 146 940 62667 DATA SERVICES 690 642 1,380 642 810 62669 PROGRAMMING 1,847 1,847 1,847 1,847 670 62674 BRUSH TIES 17 487 17 487 610 62680 MANHOLE COMPONENTS 57,301 72,910 57,301 92,910 100 62685 S1GN SUPPLIES 39,927 38,498 39,927 38,498 940 62685 SIGN SUPPLIES 2,393 - 2,393 - 250 62686 CRACKSEAL MATERIALS 29,957 33,861 29,957 33,861 250 62687 TAC OIL 7,158 6,771 5,129 6,771 250 62692 LANDFILL FEES 65,043 51,071 63,747 51,071 670 62692 LANDFILL FEES 486,249 541,025 513,359 532,816 100 62696 OUTSIDE COLLECTOR EXPENSE 47 233 47 233 670 62696 OUTSIDE COLLECTOR EXPENSE 1,741 383 892 383 940 62699 CASH SHORT AND OVER (1,018) 192 100 62706 SNOW-PLOWING 19,950 33,837 18,408 26,894 100 62710 CONTRACTOR SERVICES 33,073 9,341 33,073 25,094 250 62710 CONTRACTOR SERVICES 10,685 26,580 9,448 23,537 -119- Recommended Operating Expenditure Budget - Department Total 54 - PUBLIC WORKS FY20 Actual FY21 Actual FY22 Adopted FY 23 Recomm'd Fund Account Account Title Expense Expense Budget Budget 610 62710 CONTRACTOR SERVICES 12,059 12,059 670 62710 CONTRACTOR SERVICES 368 368 810 62710 CONTRACTOR SERVICES 1,190 1,183 1,190 1,183 940 62710 CONTRACTOR SERVICES 6,770 22,473 6,770 22,474 100 62712 CONSULTING ENGINEERS 3,360 900 3,360 26,900 610 62712 CONSULTING ENGINEERS 900 900 670 62712 CONSULTiNG ENGiNEERS 25,000 940 62712 CONSULTING ENGINEERS 213,548 416,133 213,548 240,750 940 62713 LEGAL SERVICES 2,340 250 62715 FORECASTING SERVICE 6,890 5,340 6,890 5,340 940 62716 CONSULTANT SERVICES 10,120 9,326 10,120 9,326 400 62721 FINANCIAL CONSULTANT - 733 - - 940 62721 FINANCIAL CONSULTANT 450 15,450 7,500 7,950 940 62726 AUDIT SERVICES 5,200 5,800 4,180 5,974 940 62727 FINANCIAL SERVICE FEES 1,139 959 3,139 959 400 62731 MISCELLANEOUS SERVICES 1,078 940 62731 MISCELLANEOUS SERVICES 2,000 100 62732 TEMP HELPCONTRACT SERV. 9,865 940 62732 TEMP HELPCONTRACT SERV. 27,190 28,351 5,000 15,000 940 62737 CONTRACT ADM SERVICE 86,393 99,445 126,808 140,111 100 62746 ONE CALL OPERATION 6,722 7,758 5,028 7,758 100 62747 MACH/EQUIPMENT RENTAL 3,092 3,079 1,762 1,762 250 62747 MACH/EQUTPMENT RENTAL 6,204 4,230 10,000 10,000 610 62747 MACH/EQUIPMENT RENTAL 1,710 940 62747 MACH/EQUIPMENT RENTAL 790 401 27,100 27,100 670 62748 APPLIANCE RECYCLING 1,500 1,500 940 62748 APPLIANCE RECYCLING 12,537 10,260 13,500 13,500 670 62750 TIRE RECYCLING 571 568 610 610 940 62750 TIRE RECYCLING 53,353 80,305 82,500 82,500 670 62761 PAY TO OTHER AGENCY 91,427 36,909 93,255 36,908 940 62761 PAY TO OTHER AGENCY 204,711 231,455 377,462 377,462 940 62763 PAYMENT TO IOWA DNR 343,685 315,982 304,500 304,500 940 62767 ENVIRON.TESTING/MON. 29,827 25,059 26,631 28,131 940 62770 GRIND/COMPOST SERVICE 64,757 90,140 92,605 91,000 940 62778 SERVICES-OTHER DEPTS 1,695 2,888 250 62780 HAULING SERVICES 50,000 50,000 940 62780 HAULING SERVICES 24,668 38,471 3,027 3,027 100 62781 LAWN CARE SERVICES 18,968 22,407 19,679 19,679 250 62782 HANDLiNG FEES 20,236 26,878 34,615 35,112 680 62782 HANDLING FEES 50,653 9,305 9,060 9,240 940 62784 ASPHALT SHINGLE RECYCLING 13,129 100 628ll ENG.D1VISION SERVICES 32,548 32,548 100 62833 SERVICE FROM WPC 2,000 2,000 62-SUPPLIES AND SERVICES 7,667,239 7,588,323 7,843,583 8,414,684 940 62724 BOND PAYING AGENT FEE - 2,450 - 2,450 -120- Recommended Operating Expenditure Budget - Department Total 54 - PUBLIC WORKS FY20 Actual FY21 Actual FY22 Adopted FY 23 Recomm'd Fund Account Account Title Expense Expense Budget Budget 627-CONTRACTUAL SERVICES - 2,450 - 2,450 810 63210 STORES-GARAGE 776,350 686,788 803,700 936,357 100 633ll ADMIN.OVERHEAD 54,098 62,414 61,950 65,314 250 63311 ADMIN.OVERHEAD 223,771 258,167 256,245 270,165 610 63311 ADMIN.OVERHEAD 29,508 34,044 33,791 35,626 620 63311 ADMIN.OVERHEAD 14,754 17,022 16,895 17,813 670 63311 ADMIN.OVERHEAD 68,852 79,436 78,845 83,127 680 633ll ADMIN.OVERHEAD 4,918 5,674 5,632 5,938 810 633ll ADMIN.OVERHEAD 24,590 28,370 28,159 29,688 940 633ll ADMIN.OVERHEAD 71,313 82,273 81,658 86,097 100 63312 LESS ADMIN.RECHARGES (491,804) (567,400) (563,175) (563,768) 63-ADMIN/OVERHEAD/STORES GAR 776,350 686,788 803,700 966,357 100 71117 TIME CLOCK - 200 - - 100 71120 PERIPHERALS,COMPUTER 10 1,820 670 71120 PERIPHERALS,COMPUTER 878 610 7ll22 PRINTER 250 940 7ll22 PRINTER 342 600 940 7ll23 SOFTWARE 3,250 100 7ll24 COMPUTER 4,500 940 71125 SERVERS - 26,344 - - 100 71211 DESKS/CHAIRS 928 940 71211 DESKS/CHAIRS 211 587 670 71221 CARTS 67,841 52,107 96,240 692,134 100 71226 ACCOUSTICAL COVER 3,185 250 71314 TRUCK-REPLACEMENT 59,765 175,000 610 71314 TRUCK-REPLACEMENT 57,760 620 71314 TRUCK-REPLACEMENT 45,498 670 71314 TRUCK-REPLACEMENT 80,487 810 71314 TRUCK-REPLACEMENT - - 25,500 - 940 71314 TRUCK-REPLACEMENT 40,000 250 71318 HEAVY EQUIP-REPLACEMENT 73,825 56,000 56,000 940 71318 HEAVY EQUIP-REPLACEMENT 59,730 77,842 23,416 250 71320 HEAVY EQUIP-ADDITIONAL 30,000 250 71323 ASPHALT ROLLER 40,000 100 71328 TRAILERS - 7,000 - - 250 71328 TRAILERS - 20,990 27,000 - 250 71329 VEHICLE ACCESSORIES 19,000 610 71329 VEHICLE ACCESSORIES 3,500 670 71329 VEHICLE ACCESSORIES 9,000 100 71410 SHOP EQUIPMENT 1,856 1,419 2,000 4,000 810 71410 SHOP EQUIPMENT 6,678 S,011 5,000 5,000 940 71410 SHOP EQUiPMENT 686 2,000 2,000 100 714ll TRAFFIC CONTROL EQUIPMENT 17,352 47 12,000 16,100 100 71414 AIR HAMMER/DRILL - 3,834 - - 250 71414 AIR HAMMER/DRILL 2,000 -121- Recommended Operating Expenditure Budget - Department Total 54 - PUBLIC WORKS FY20 Actual FY21 Actual FY22 Adopted FY 23 Recomm'd Fund Account Account Title Expense Expense Budget Budget 100 71415 SAWS 180 250 71415 SAWS 1,203 23,000 620 71415 SAWS 1,000 250 71416 PLOWS - - 10,000 - 250 71420 EARTH COMPACTOR 12,500 620 71420 EARTHCOMPACTOR L1,000 250 71425 CURB FORMS 2,000 610 715ll PUMPS 20,000 250 71512 COMPRESSORS 17,000 940 71520 HVAC 374 940 71530 SCALE 3,465 100 71550 MISCELLANEOUS EQUIPMENT 6,616 250 71550 MISCELLANEOUS EQUIPMENT 19,500 940 71550 MISCELLANEOUS EQUIPMENT 5,491 100 71611 MOWING EQUIPMENT 300 550 250 716ll MOWING EQUIPMENT 120 8,600 100 71612 WEED WHIPS/SICKLE BAR 250 250 71612 WEED WHIPS/SICKLE BAR 290 600 250 100 71615 LEAF BLOWER - 500 - - 250 71615 LEAF BLOWER 350 600 250 71616 SNOW BLOWER 1,200 100 71619 OTHER MAINT.EQUIPMENT 4,000 250 71619 OTHER MAINT.EQUiPMENT 174,712 8,616 610 71619 OTHER MAINT.EQUIPMENT 3,095 5,000 1,500 670 71619 OTHER MAINT.EQUIPMENT 5,000 940 71619 OTHER MAINT.EQUIPMENT 59,547 610 72111 GAS SAFETY MONITOR 859 1,019 1,500 1,500 610 72114 CONFINED SPACE EQUIMENT 2,000 2,000 940 72217 CARD READERS 700 700 250 72414 TELEVISION 1,000 1,000 670 72415 ELECTRONIC DATA COLLECTOR 8,268 680 72417 CAMERA RELATED EQUIPMENT 1,101 940 72417 CAMERA RELATED EQUIPMENT 1,099 500 100 72418 TELEPHONE RELATED 149 100 610 72418 TELEPHONE RELATED - - 5,300 - 670 72418 TELEPHONE RELATED 13 - 350 - 810 72418 TELEPHONE RELATED - 170 - - 940 72418 TELEPHONE RELATED 225 220 900 100 72515 TEST EQUIPMENT,OTHER 12,400 610 72816 JET FLUSHER HOSE 3,500 3,703 6,000 5,250 670 72818 RECYCLING CONTAINER 11,435 18,084 ll,814 18,084 71-EQUIPMENT 567,752 216,261 677,679 1,093,381 250 72115 BARRICADES/WARN SIGNALS 4,335 3,400 3,400 72-EQUIPMENT - 4,335 3,400 3,400 400 74111 PRINCIPAL PAYMENT 103,957 525,196 109,930 66,830 -122- Recommended Operating Expenditure Budget - Department Total 54 - PUBLIC WORKS FY20 Actual FY21 Actual FY22 Adopted FY 23 Recomm'd Fund Account Account Title Expense Expense Budget Budget 670 741ll PRINCIPAL PAYMENT 5,222 5,351 5,780 6,038 940 741ll PRINCIPAL PAYMENT 410,000 425,000 435,000 450,000 400 74112 INTEREST PAYMENT 30,459 27,558 24,695 16,820 670 74112 INTEREST PAYMENT 2,064 1,925 2,704 2,866 940 74112 INTEREST PAYMENT 251,109 238,359 225,609 210,459 74-DEBT SERVICE 802,8ll 1,223,389 803,718 753,013 670 91100 TO GENERAL 1,055,920 1,191,482 1,219,202 1,305,346 940 9ll00 TO GENERAL 387,593 420,846 440,255 477,980 91-TRANSFER TO 1,443,513 1,612,328 1,659,457 1,783,326 54-PUBLIC WORKS TOTAL 18,606,695 18,852,703 20,174,261 21,768,938 -123- Recommended Expenditure Budget Report by Activity & Funding Source 54 - PUBLIC WORKS ADMINISTRATION -54100 FUNDING SOURCE:GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget ADM1N/O V ERHEAD/STORES Gax �s6�,4o0� �s63,i�s> �s63,�6s� DEBT SERVICE 7,276 8,484 8,904 EQUIPMENT 260 3,185 4,500 SUPPLIES AND SERVICES 42,844 57,374 83,810 TRANSFER TO 1,191,482 1,219,202 1,305,346 WAGES AND BENEFITS 512,970 505,801 569,213 ADMINISTRATION 1,187,432 1,230,871 1,408,005 PARKS ASSISTANCE -54150 FUNDING SOURCE:GENERAL Account FY21 Actual Expensc FY22 Adoptcd Budget FY23 Recomm'd Budget WAGES AND BENEFITS 474 0 PARKS ASSISTANCE 474 - 0 LANDFILL -54200 FUNDING SOURCE: DMASWA-GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget ADMIN/O VERHEAD/STORES GAR 45,392 45,054 47,501 CONTRACTUAL SERVICES 2,450 2,450 DEBT SERVICE 663,359 660,609 660,459 EQUIPMENT 92,872 122,042 85,663 SUPPLIES AND SERVICES 1,642,827 1,548,641 1,576,121 TRANSFER TO 420,846 440,255 477,980 WAGES AND BENEFITS 859,417 872,028 903,975 LANDFILL 3,727,163 3,688,629 3,754,149 COMPOSTING LANDFILL -54210 FUNDING SOURCE:DMASWA-GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget ADMIN/O VERHEAD/STORES GAR 5,674 5,631 5,938 SUPPLIES AND SERVICES 95,517 100,388 111,399 WAGES AND BENEFITS 15,035 45,836 47,452 COMPOSTING LANDFILL 116,226 151,855 164,789 HOUSEHOLD HAZ.MAT.R.C.G 54220 -124- Recommended Expenditure Budget Report by Activity & Funding Source 54 - PUBLIC WORKS FUNDING SOURCE:DMASWA-GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget ADMiN/O VERHEAD/STORES GAR 5,674 5,631 5,938 EQUIPMENT 0 SUPPLIES AND SERVICES 95,760 113,629 117,780 WAGES AND BENEFITS 53,955 88,995 103,L58 HOUSEHOLD HAZ.MAT.R.C.0 155,389 208,255 226,876 DMASWA EDUCATION& COMM.-54230 FUNDING SOURCE:DMASWA-GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget ADMIN/O VERHEAD/STORES GAR 5,674 5,631 5,938 EQUIPMENT 0 SUPPLIES AND SERVICES 169,725 201,241 170,820 WAGES AND BENEFITS 1,904 15,693 16,335 DMASWA EDUCATION& COMM. 177,303 222,565 193,093 E-WASTE -54240 FUNDING SOURCE:DMASWA-GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget ADMIN/OVERH EAD/STORES GAR 5,674 5,631 5,938 SUPPLIES AND SERVICES 56,172 77,919 78,700 WAGES AND BENEFITS 21,770 62,685 77,039 E-WASTE 83,616 146,235 161,677 RURAL RECYCLING -54250 FUNDING SOURCE: DMASWA-GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget ADMIN/O V ERHEAD/STORES GAR 2,837 2,816 2,969 SUPPLIES AND SERVICES 208,665 262,729 206,893 WAGES AND BENEFITS 3,557 22,272 23,786 RURAL RECYCLING 215,059 287,817 233,648 LANDFILL GAS SYSTEM -54260 FUNDING SOURCE: DMASWA-GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget -125- Recommended Expenditure Budget Report by Activity & Funding Source 54 - PUBLIC WORKS ADMiN/O VERHEAD/STORES GAR ll,348 ll,264 11,875 SUPPLIES AND SERVICES 42,288 38,373 41,008 WAGES AND BENEFITS 21,345 36,525 38,707 LANDFILL GAS SYSTEM 74,980 86,162 91,590 SAN-SEWER MNTNCE -54300 FUNDING SOURCE:SEWAGE FACILITY OPERATION Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget ADMIN/O VERHEAD/STORES GAR 34,044 33,791 35,626 EQUIPMENT 4,722 97,560 14,000 SUPPLIES AND SERVICES 193,538 223,699 221,907 WAGES AND BENEFITS 400,821 427,477 442,583 SAN-SEWER MNTNCE 633,125 782,527 714,116 STORM SEWER MAINT -54310 FUNDING SOURCE:STORM WATER OPERATION Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget ADMIN/O V ERHEAD/STORES GAR 17,022 16,895 17,813 EQUIPMENT 12,000 SUPPLIES AND SERVICES 53,920 73,831 7L,534 WAGES AND BENEFITS 142,084 179,454 184,960 STORM SEWER MAINT 213,027 270,180 286,307 RIVERFRONT MANAGEMNT. -54330 FUNDING SOURCE:GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget ADMiN/O VERHEAD/STORES GAR 5,674 5,632 5,938 EQUIPMENT 800 1,050 1,000 SUPPLIES AND SERVICES 19,446 32,424 28,433 WAGES AND BENEFITS 27,182 I 5,949 20,386 RIVERFRONT MANAGEMNT. 53,102 55,055 55,757 FLOODWALL OPER./MAINT. -54340 FUNDING SOURCE:GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget ADMIN/O VERHEAD/STORES GAR 17,022 16,895 17,813 SUPPLIES AND SERVICES 68,813 139,511 136,241 -126- Recommended Expenditure Budget Report by Activity & Funding Source 54 - PUBLIC WORKS WAGES AND BENEFITS 12,763 52,687 53,480 FLOODWALL OPER./MAINT. 98,598 209,093 207,534 STREET MAINTENANCE -54400 FUNDING SOURCE:GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget ADMIN/O V ERHEAD/STORES GAR 113,480 ll 2,635 118,754 EQUIPMENT 33,981 255,220 223,400 SUPPLIES AND SERVICES 1,528,688 1,461,773 1,890,857 WAGES AND BENEFITS 1,421,331 1,614,776 1,598,037 STREET MAINTENANCE 3,097,479 3,444,404 3,831,048 SUBDIVISION INSPECTION -54406 FUNDING SOURCE:GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget WAGES AND BENEFITS 607 0 SUBDIVISION INSPECTION 607 - 0 STREET CLEANING -54410 FUNDING SOURCE:ROAD USE TAX Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget ADMIN/OVERH EAD/STORES GAR 34,044 33,791 35,626 EQUIPMENT 290 9,950 11,450 SUPPLIES AND SERVICES 277,972 307,803 314,797 WAGES AND BENEFITS 273,225 367,518 367,557 STREET CLEANING 585,530 719,062 729,430 SNOW&ICE CONTROL -54420 FUNDING SOURCE:ROAD USE TAX Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget ADMiN/O VERHEAD/STORES GAR ll 0,643 109,819 115,785 EQUIPMENT - 10,000 1,200 SUPPLIES AND SERVICES 745,927 758,748 936,980 WAGES AND BENEFITS 624,837 695,151 75 L,433 SNOW&10E CONTROL 1,481,407 1,573,718 1,805,398 SALT OPS-PURINA DRIVE -54425 FUNDING SOURCE:SALT OPERATIONS -127- Recommended Expenditure Budget Report by Activity & Funding Source 54 - PUBLIC WORKS Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget ADMIN/O VERHEAD/STORES GAR 5,674 5,632 5,938 �QUIPM�NT 0 SUPPLIF,S AND SERVICF,S 114,211 98,755 107,624 SALT OPS-PURINA DRIVE 119,885 104,387 ll3,562 ST.&TRAFFIC LTNG -54430 FUNDING SOURCE:GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget ADM1N/O V ERHEAD/STORES GAR 11,348 11,264 11,875 EQUIPMENT 8,217 25,400 18,600 SUPPLiES AND SERVICES 824,053 916,266 846,344 WAGES AND BENEFiTS 225,952 286,180 295,121 ST.&TRAFFIC LTNG 1,069,570 1,239,110 1,171,940 ST.PARHING METERS -54433 FUNDING SOURCE:PARHING OPERATION Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget WAGF,S AND BENF.FTTS 3,119 0 ST.PARKING METERS 3,119 - 0 ST.SIGNS&MARHINGS -54435 FUNDING SOURCE:GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget ADM1N/O V ERHEAD/STORES GAR 11,348 11,264 11,875 EQUIPMENT 4,083 4,500 750 SUPPLiES AND SERViCES 56,892 66,648 68,352 WAGES AND BENEFITS 96,054 121,673 108,719 ST.SIGNS&MARKINGS 168,376 204,085 189,696 ONE CALL LOCATION SERVICE-54440 FUNDING SOURCE:GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget SUPPLIES AND SERV[CES 7,758 26,576 29,306 ONE CALL LOCATION SERVICE 7,758 26,576 29,306 -128- Recommended Expenditure Budget Report by Activity & Funding Source 54 - PUBLIC WORKS PORT OF DUB.MAINTENANCE-54450 FUNDING SOURCE:GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget ADM1N/O V ERHEAD/STORES GAR 17,022 16,895 17,813 SUPPLIES AND SERVICES 81,794 88,004 88,971 WAGES AND BENEFITS 76,717 78,670 140,312 PORT OF DUB.MAINTENANCE 175,533 183,569 247,096 DEBT SERVICE -54490 FUNDING SOURCE:DEBT SERVICE Account FY2l Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget DEBT SERVICE 552,754 134,625 83,650 SUPPLIES AND SERVICES 1,810 - 0 DEBT SERVICE 554,565 134,625 83,650 REFUSE COLLECTION -54500 FUNDING SOURCE: REFUSE COLGECTION Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget ADMIN/O V ERHEAD/STORES GAR 28,370 28,159 29,688 EQUIPMENT 33,997 83,618 661,698 SUPPLIES AND SERVICES 738,207 720,590 764,285 WAGES AND BENEFITS 924,950 993,275 1,042,589 REFUSE COLLECTION 1,725,524 1,825,642 2,498,260 YARD WASTE COLLECTION -54510 FUNDING SOURCE:REFUSE COLLECTION Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget ADMIN/O V ERHEAD/STORES GAR 11,348 11,264 11,875 EQUIPMENT 2,107 3,240 9,276 SUPPLIES AND SERVICES 71,488 76,780 79,629 WAGES AND BENEFITS 147,652 143,802 159,612 YARD WASTE COLLECTION 232,595 235,086 260,392 LARGE ITEM COLLECTION -54520 FUNDING SOURCE:REFUSE COLLECTION Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget -129- Recommended Expenditure Budget Report by Activity & Funding Source 54 - PUBLIC WORKS ADMiN/O VERHEAD/STORES GAR 17,022 16,895 17,813 SUPPLIES AND SERVICES 47,484 24,463 44,553 WAGES AND BENEFITS 10,466 16,716 15,991 LARGE ITEM COLLECTION 74,972 58,074 78,357 RECYCLING COLL.PROG. -54530 FUNDING SOURCE: REFUSE COLLECTION Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget ADMIN/O VERHEAD/STORES GAR 22,696 22,527 23,751 EQUIPMENT 34,087 34,814 48,244 SUPPLIES AND SERVICES 245,840 271,425 240,007 WAGES AND BENEFITS 675,487 677,438 685,656 RECYCLING COLL.PROG. 978,ll0 1,006,204 997,658 PUBLIC WORKS GARAGE -54600 FUNDING SOURCE:GARAGE SERVICE Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget ADMIN/O VERHEAD/STORES GAR 715,158 831,859 966,045 EQUIPMENT 5,181 30,500 5,000 SUPPLIF,S AND SERVICF,S 156,687 155,993 158,333 WAGES AND BENEFITS 965,156 1,062,123 1,106,225 PUBLIC WORKS GARAGE $1,842,182 $2,080,475 $2,235,603 PUBLIC WORKS TOTAL $18,852,703 $20,174,261 $21,768,938 -130- CITY OF DUBUQUE, IOWA DEPARTMENT DETAIL-PERSONNEL COMPLEMENT 54 PUBLIC WORKS DEPARTMENT FY 2021 FY 2022 FY 2023 FD JC WP-GR JOB CLASS FTE BUDGET FTE BUDGET FTE BUDGET 61010 Full Time Employee Expense 100 3325 GE-41 PUBLIC WORKS DIRECTOR 1.00 $ 121,305 1.00 $ 123,103 1.00 $ 127,093 100 1490 GE-38 ASST PUBLIC WORKS DIRECTOR 1.00 $ 82,809 1.00 $ 88,727 1.00 $ 97,669 STREET MAINTENANCE 100 3100 GE-37 SUPERVISOR - $ - - $ - - $ - 810 3225 GE-35 EQUIP MAINT. SUPERVISOR 1.00 $ 75,299 1.00 $ 80,601 1.00 $ 87,654 670 6100 GE-35 RESOURCE MANAGEMENT COORD. 1.00 $ 83,666 1.00 $ 85,640 1.00 $ 70,824 940 2625 GE-36 DMASWAADMINISTRATOR 1.00 $ 73,269 1.00 $ 78,456 1.00 $ 85,034 940 2625 GE-35 LANDFILL SUPERVISOR 1.00 $ 84,504 1.00 $ 86,101 1.00 $ 89,409 100 2925 GD-12 TRAFFIC SIGNALTECHNICIAN II 2.88 $ 187,211 2.88 $ 193,444 2.88 $ 201,776 250 2925 GD-12 TRAFFIC SIGNAL TECH II 0.12 $ 8,085 0.12 $ 8,059 0.12 $ 8,408 100 GE-28 LEAD ADMINISTRATIVE ASSISTANT - $ - - $ - 1.00 $ 60,904 100 225 GE-25 SECRETARY 2.00 $ 90,279 2.00 $ 94,112 2.00 $ 99,712 100 2655 GD-11 FOREMAN 0.08 $ 4,887 0.08 $ 5,073 0.08 $ 5,224 250 2655 GD-11 FOREMAN 4.18 $ 257,796 4.18 $ 262,992 4.18 $ 270,568 610 2655 GD-11 FOREMAN 0.92 $ 54,841 0.92 $ 56,451 0.92 $ 60,208 620 2655 GD-11 FOREMAN 0.82 $ 49,473 0.82 $ 52,156 0.82 $ 54,122 820 2655 GD-11 FOREMAN - $ - - $ - - $ - 940 2655 GD-11 FOREMAN 1.00 $ 60,488 1.00 $ 61,903 1.00 $ 64,176 100 GE-35 FIELD SUPERVISOR 0.10 $ 7,097 0.10 $ 7,202 0.10 $ 7,436 250 GE-35 FIELD SUPERVISOR 0.90 $ 63,872 0.90 $ 64,818 0.90 $ 82,833 620 GE-35 FIELD SUPERVISOR - $ - - $ - - $ - 670 2655 GD-11 LEAD SANITATION DRIVER 1.00 $ 63,514 1.00 $ 64,610 1.00 $ 66,716 810 7250 GD-11 LEAD MECHANIC 2.00 $ 123,268 2.00 $ 125,738 2.00 $ 130,103 810 2525 GD-10 MECHANIC 7.00 $ 414,299 7.00 $ 409,485 7.00 $ 428,559 940 2525 GD-11 MECHANIC 1.00 $ 59,299 1.00 $ 63,810 1.00 $ 66,070 100 2300 GD-08 EQUIPMENT OPERATOR II 0.57 $ 32,663 0.54 $ 31,389 125 $ 75,718 250 2300 GD-08 EQUIPMENT OPERATOR II 5.56 $ 319,934 5.61 $ 326,428 4.88 $ 288,482 610 2300 GD-08 EQUIPMENT OPERATOR II 0.87 $ 46,825 0.87 $ 48,044 0.87 $ 52,347 620 2300 GD-08 EQUIPMENT OPERATOR II 0.10 $ 5,757 0.10 $ 5,487 0.10 $ 6,047 820 2300 GD-08 EQUIPMENT OPERATOR II - $ - - $ - - $ - 940 2300 GD-08 EQUIPMENT OPERATOR II 2.00 $ 117,393 1.00 $ 60,291 1.00 $ 62,242 940 GD-08 LANDFILL EQUIP OPERATOR 3.00 $ 170,877 4.00 $ 231,402 4.00 $ 229,224 810 GE-27 INVENTORY/ACCOUNT CLERK - $ - - $ - 1.00 $ 46,082 250 GD-05 UTILITY WORKER 6.80 $ 344,839 6.80 $ 360,827 9.87 $ 539,283 610 GD-05 UTILITY WORKER 0.20 $ 10,558 0.20 $ 11,029 0.30 $ 16,092 250 NA-48 UTILITY WORKERAPPRENTICE 1.00 $ 40,051 1.00 $ 42,235 1.00 $ 41,196 670 GD-04 SANITATION LABORER 1.00 $ 55,818 1.00 $ 56,783 - $ - 670 GD-06 YARD WASTE&SNOWFIGHTER - $ - - $ - 0.67 $ 34,861 250 GD-06 YARD WASTE&SNOWFIGHTER - $ - - $ - 0.33 $ 17,430 810 835 GD-03 STOCK CLERK 2.00 $ 98,148 2.00 $ 100,328 1.00 $ 52,073 100 2375 GD-06 EQUIPMENT OPERATOR I 1.67 $ 91,650 1.65 $ 92,956 1.72 $ 99,535 250 2375 GD-06 EQUIPMENT OPERATOR I 5.14 $ 284,721 6.14 $ 346,847 6.92 $ 401,934 610 2375 GD-06 EQUIPMENT OPERATOR I 2.97 $ 167,251 2.97 $ 169,427 2.97 $ 171,548 620 2375 GD-06 EQUIPMENT OPERATOR I 1.12 $ 61,814 1.12 $ 62,715 1.12 $ 64,792 670 1300 GD-06 SANITATION DRIVER 17.00 $ 949,696 17.00 $ 965,873 18.00 $1,045,608 100 2205 GD-06 MAINTENANCE WORKER 0.02 $ 1,157 - $ - - $ - 250 2205 GD-06 MAINTENANCE WORKER 0.98 $ 56,721 - $ - - $ - -131- CITY OF DUBUQUE, IOWA DEPARTMENT DETAIL-PERSONNEL COMPLEMENT 54 PUBLIC WORKS DEPARTMENT FY 2021 FY 2022 FY 2023 FD JC WP-GR JOB CLASS FTE BUDGET FTE BUDGET FTE BUDGET 250 GD-06 ASSISTANT HORTICULTURALIST 0.42 $ 20,652 0.42 $ 22,154 0.42 $ 23,463 100 1475 GD-05 TRUCK DRIVER 0.05 $ 2,711 - $ - - $ - 250 1475 GD-05 TRUCK DRIVER 0.10 $ 5,609 3.90 $ 219,660 - $ - 610 1475 GD-05 TRUCK DRIVER 3.85 $ 212,633 0.10 $ 5,710 - $ - 620 1475 GD-05 TRUCK DRIVER - $ - - $ - - $ - 940 870 GD-04 SCALE HOUSE OPERATOR 2.00 $ 102,363 2.00 $ 100,973 2.00 $ 105,733 100 811 NA-50 ACCOUNT CLERK II 1.00 $ 58,383 1.00 $ 59,261 - $ - TOTAL FULL TIME EMPLOYEES 89.42 $5,223,485 89.42 $5,332,300 90.42 $5,538,188 61020 Part Time Employee Expense 250 GD-03 CUSTODIAN I 0.38 $ 18,463 0.38 $ 18,789 0.38 $ 19,400 670 GD-03 CUSTODIAN I 0.08 $ 3,887 0.08 $ 3,956 0.08 $ 4,084 810 GD-03 CUSTODIAN I 0.15 $ 7,288 0.15 $ 7,417 0.15 $ 7,658 100 GE-25 SECRETARY - $ - - $ - 0.67 $ 26,314 TOTAL PART TIME EMPLOYEES 0.61 $ 29,638 0.61 $ 30,162 1.28 $ 57,456 61030 Seasonal Employee Expense 670 1325 NA-26 SANITATION DRIVER 0.67 $ 21,684 0.67 $ 22,061 0.08 $ 2,719 940 1325 GD-26 EQUIPMENT OPERATOR 0.75 $ 24,273 0.75 $ 24,696 0.75 $ 25,494 100 898 GD-21 LABORER-ST/W/WW-SEASONAL 1.47 $ 36,838 1.47 $ 37,452 0.63 $ 20,922 250 898 GD-21 LABORER-ST/W/WW-SEASONAL 0.36 $ 8,765 0.36 $ 8,915 0.27 $ 8,913 TOTAL SEASONAL EMPLOYEES 3.25 $ 91,560 3.25 $ 93,124 1.73 $ 58,048 TOTAL PUBLIC WORKS DEPARTMENT 93.28 $ 5,344,683 93.28 $ 5,455,586 93.43 $ 5,653,692 -132- CITY OF DUBUQUE,IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2021 FY 2022 FY 2023 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET Public Works Administration-FT 10054100 61010 100 3325 GE-41 PUBLIC WORKS DIRECTOR 1.00 $ 121,305 1.00 $ 123,103 1.00 $ 127,093 ASST PUBLIC WORKS 10054100 61010 100 1490 GE-38 DIRECTOR 1.00 $ 82,809 1.00 $ 88,727 1.00 $ 97,669 LEAD ADMINISTRATIVE 10054100 61010 100 GE-28 ASSISTANT - $ - - $ - 1.00 $ 60,904 10054100 61010 100 225 GE-25 SECRETARY 2.00 $ 90,279 2.00 $ 94,112 2.00 $ 99,712 10054100 61010 100 811 NA-50 ACCOUNT CLERK II 1.00 $ 58,383 1.00 $ 59,261 - $ - Total 5.00 $ 352,776 5.00 $ 365,203 5.00 $ 385,378 Public Works Administration-Part-Time 10054100 61030 100 225 GE-25 SECRETARY - $ - - $ - 0.67 $ 26,314 Total - $ - - $ - 0.67 $ 26,314 Riverfront Management-FT General Fund 10054330 61010 100 1475 GD-05 TRUCK DRIVER 0.05 $ 2,711 - $ - - $ - 10054330 61010 100 2375 GD-08 EQUIPMENT OPERATOR II 0.05 $ 2,878 - $ - 0.10 $ 6,106 10054330 61010 100 GD-06 EQUIPMENT OPERATOR I 0.10 $ 5,670 0.10 $ 5,776 0.05 $ 2,853 Total 0.20 $ 11,259 0.10 $ 5,776 0.15 $ 8,959 Riverfront Management-Seasonal General Fund LABORER-ST/W/WW- 10054330 61030 100 898 GD-21 SEASONAL 0.10 $ 2,591 0.10 $ 2,633 0.08 $ 2,766 Total 0.10 $ 2,591 0.10 $ 2,633 0.08 $ 2,766 Floodwall Oper./Maintenance 10054340 61010 100 2205 GD-06 MAINTENANCE WORKER 0.02 $ 1,157 - $ - - $ - 10054340 61010 100 2300 GD-08 EQUIPMENT OPERATOR II 0.17 $ 9,781 0.12 $ 7,005 0.12 $ 7,257 10054340 61010 100 2655 GD-11 FOREMAN 0.08 $ 4,887 0.08 $ 5,073 0.08 $ 5,224 10054340 61010 100 GE-31 FIELD SUPERVISOR 0.10 $ 7,097 0.10 $ 7,202 0.10 $ 7,436 10054340 61010 100 2375 GD-06 EQUIPMENT OPERATOR I 0.10 $ 5,525 0.10 $ 5,674 0.10 $ 5,779 Total 0.47 $ 28,447 0.40 $ 24,954 0.40 $ 25,696 Floodwall Oper./Maintenance-Seasonal 10054340 61030 100 898 GD-21 LABORER SEASONAL 0.13 $ 3,165 0.13 $ 3,219 0.10 $ 3,301 Total 0.13 $ 3,165 0.13 $ 3,219 0.10 $ 3,301 Street&Traffic Lighting-FT General Fund 10054430 61010 100 2300 GD-08 EQUIPMENT OPERATOR II 0.02 $ 1,065 0.02 $ 1,100 - $ - 10054430 61010 100 GD-06 EQUIPMENT OPERATOR I - $ - - $ - 0.02 $ 1,158 TRAFFIC SIGNAL 10054430 61010 100 2925 GD-12 TECHNICIAN II 2.86 $ 185,851 2.86 $ 192,010 2.86 $ 200,284 Total 2.88 $ 186,916 2.88 $ 193,110 2.88 $ 201,442 Street Signs&Markings-FT General Fund TRAFFIC SIGNAL 10054435 61010 100 2925 GD-12 TECHNICIAN II 0.01 $ 680 0.01 $ 717 0.01 $ 746 10054435 61010 100 2375 GD-06 EQUIPMENT OPERATOR I 0.82 $ 43,667 0.82 $ 45,113 0.82 $ 47,478 10054435 61010 100 2300 GD-08 EQUIPMENT OPERATOR II 0.35 $ 20,004 0.40 $ 23,284 0.40 $ 23,890 Total 1.18 $ 64,351 1.23 $ 69,114 1.23 $ 72,114 -133- CITY OF DUBUQUE,IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2021 FY 2022 FY 2023 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET Street Signs&Markings-Seasonal General Fund LABORER-ST/W/WW- 10054435 61030 100 898 NA-01 SEASONAL 0.67 $ 16,312 0.67 $ 16,592 - $ - Total 0.67 $ 16,312 0.67 $ 16,592 - $ - Port of Dubuque Maintenance-FT TRAFFIC SIGNAL 10054450 61010 100 2925 GD-12 TECHNICIAN II 0.01 $ 680 0.01 $ 717 0.01 $ 746 10054450 61010 100 2300 GD-08 EQUIPMENT OPERATOR II - $ - - $ - 0.63 $ 38,465 10054450 61010 100 1475 GD-06 EQUIPMENT OPERATOR I 0.63 $ 35,723 0.63 $ 36,393 0.73 $ 42,267 Total 0.64 $ 36,403 0.64 $ 37,110 1.37 $ 81,478 Port of Dubuque Maintenance-Seasonal 10054450 61030 100 898 GD-21 LABORER-SEASONAL 0.57 $ 14,770 0.57 $ 15,008 0.45 $ 14,855 Total 0.57 $ 14,770 0.57 $ 15,008 0.45 $ 14,855 Street Maintenance-FT Road Use Tax Fund ASSISTANT 25054400 61010 250 GD-06 HORTICULTURALIST 0.25 $ 12,293 0.25 $ 13,187 0.25 $ 13,966 25054400 61010 100 2205 GD-06 MAINTENANCE WORKER 0.10 $ 5,788 - $ - - $ - 25054400 61010 250 GD-05 UTILITY WORKER 5.63 $ 285,427 5.63 $ 298,518 6.46 $ 349,307 UTILITY WORKER 25054400 61010 NA-48 APPRENTICE 0.83 $ 33,243 0.83 $ 35,054 0.83 $ 34,193 25054400 61010 250 2300 GD-08 EQUIPMENT OPERATOR II 1.89 $ 107,311 2.68 $ 154,876 1.94 $ 116,180 25054400 61010 250 2375 GD-06 EQUIPMENT OPERATOR I 3.32 $ 184,081 3.32 $ 186,829 4.11 $ 239,973 25054400 61010 250 2655 GD-11 FOREMAN 3.20 $ 197,926 3.20 $ 201,343 3.20 $ 206,847 25054400 61010 250 GE-35 FIELD SUPERVISOR 0.73 $ 51,807 0.73 $ 52,575 0.73 $ 67,187 25054400 61010 250 1475 GD-05 TRUCK DRIVER 1.61 $ 88,869 1.66 $ 93,437 - $ - Total 17.56 $ 966,745 18.30 $1,035,819 17.52 $1,027,653 Street Maintenance-PT Road Use Tax Fund 25054400 61020 250 GD-03 CUSTODIAN I 0.38 $ 18,463 0.38 $ 18,789 0.38 $ 19,400 Total 0.38 $ 18,463 0.38 $ 18,789 0.38 $ 19,400 Street Cleaning-Full Time Road Use Tax Fund 25054410 61010 250 1475 GD-05 TRUCK DRIVER 1.56 $ 86,125 1.56 $ 87,906 - $ - 25054410 61010 250 GD-05 UTILITY WORKER - $ - - $ - 1.56 $ 89,254 25054410 61010 250 2205 GD-06 MAINTENANCE WORKER 0.73 $ 42,252 - $ - - $ - 25054410 61010 250 2375 GD-06 EQUIPMENT OPERATOR I - $ - 0.83 $ 47,480 0.83 $ 48,057 25054410 61010 250 2300 GD-O8 EQUIPMENT OPERATOR II 2.51 $ 145,911 1.77 $ 104,149 1.77 $ 102,603 Total 4.80 $ 274,288 4.16 $ 239,535 4.16 $ 239,914 Street Cleaning-Seasonal-Road Use Tax Fund LABORER-ST/W/WW- 25054410 61030 250 898 GD-21 SEASONAL 0.36 $ 8,765 0.36 $ 8,915 0.27 $ 8,913 Total 0.36 $ 8,765 0.36 $ 8,915 0.27 $ 8,913 Snow Removal-FT 25054420 61010 250 2925 GD-12 TRAFFIC SIGNAL TECH II 0.12 $ 8,085 0.12 $ 8,059 0.12 $ 8,408 -134- CITY OF DUBUQUE,IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2021 FY 2022 FY 2023 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET 25054420 61010 250 GD-05 UTILITY WORKER 1.17 $ 59,412 1.17 $ 62,309 1.85 $ 100,722 UTILITY WORKER 25054400 61010 NA-48 APPRENTICE 0.17 $ 6,808 0.17 $ 7,181 0.17 $ 7,003 ASSISTANT 25054420 61010 250 GD-06 HORTICULTURALIST 0.17 $ 8,359 0.17 $ 8,967 0.17 $ 9,497 25054420 61010 250 2205 GD-06 MAINTENANCE WORKER 0.15 $ 8,681 - $ - - $ - 25054420 61010 250 2655 GD-11 FOREMAN 0.98 $ 59,870 0.98 $ 61,649 0.98 $ 63,721 25054420 61010 250 GE-35 FIELD SUPERVISOR 0.17 $ 12,065 0.17 $ 12,243 0.17 $ 15,646 25054420 61010 250 2300 GD-O8 EQUIPMENT OPERATOR II 1.16 $ 66,712 1.16 $ 67,403 1.17 $ 69,699 25054420 61010 250 2375 GD-06 EQUIPMENT OPERATOR I 1.82 $ 100,640 1.99 $ 112,538 1.98 $ 113,904 YARD WASTE& 25054420 61010 250 GD-06 SNOWFIGHTER - $ - - $ - 0.42 $ 22,124 25054420 61010 250 1475 GD-05 TRUCK DRIVER 0.68 $ 37,639 0.68 $ 38,317 - $ - Total 6.59 $ 368,271 6.61 $ 378,666 7.03 $ 410,724 Sanitary Sewer Maintenance-FT Sewer Use Fund 61054300 61010 610 2375 GD-06 EQUIPMENT OPERATOR I 2.97 $ 167,251 2.97 $ 169,427 2.97 $ 171,548 61054300 61010 610 GD-05 UTILITY WORKER 0.20 $ 10,558 0.20 $ 11,029 0.30 $ 16,092 61054300 61010 610 2300 GD-O8 EQUIPMENT OPERATOR II 0.87 $ 46,825 0.87 $ 48,044 0.87 $ 52,347 61054300 61010 610 1475 GD-05 TRUCK DRIVER 0.10 $ 5,609 0.10 $ 5,710 - $ - 61054300 61010 610 2655 GD-11 FOREMAN 0.92 $ 54,841 0.92 $ 56,451 0.92 $ 60,208 Total 5.06 $ 285,084 5.06 $ 290,661 5.06 $ 300,195 Storm Sewer Maintenance-FT Stormwater Fund 62054310 61010 620 2300 GD-O8 EQUIPMENT OPERATOR II 0.10 $ 5,757 0.10 $ 5,487 0.10 $ 6,047 62054310 61010 620 2375 GD-06 EQUIPMENT OPERATOR I 1.12 $ 61,814 1.12 $ 62,715 1.12 $ 64,792 62054310 61010 620 2655 GD-11 FOREMAN 0.82 $ 49,473 0.82 $ 52,156 0.82 $ 54,122 Total 2.04 $ 117,044 2.04 $ 120,358 2.04 $ 124,961 Refuse Collection-FT Refuse Fund RESOURCE MGMT 67054500 61010 670 6100 GE-35 COORDINATOR 0.40 $ 33,466 0.40 $ 34,257 0.40 $ 28,330 67054500 61010 670 2655 GD-11 LEAD SANITATION DRIVER 0.40 $ 25,406 0.40 $ 25,844 0.40 $ 26,686 67054500 61010 670 GD-04 SANITATION LABORER 1.00 $ 55,818 1.00 $ 56,783 - $ - 67054500 61010 670 1300 GD-06 SANITATION DRIVER 8.95 $ 504,444 9.15 $ 522,048 10.15 $ 595,359 Total 10.75 $ 619,134 10.95 $ 638,932 10.95 $ 650,375 Refuse Collection-PT 67054500 61020 670 GD-03 CUSTODIAN I 0.08 $ 3,887 0.08 $ 3,956 0.08 $ 4,084 Total 0.08 $ 3,887 0.08 $ 3,956 0.08 $ 4,084 Refuse Collection-Seasonal Refuse Fund LABORER-ST/W/WW- 67054500 61030 670 898 NA-01 SEASONAL 0.09 $ 2,913 0.09 $ 2,963 - $ - Total 0.09 $ 2,913 0.09 $ 2,963 - $ - Yard Waste Collection-FT Refuse Fund 67054510 61010 670 2655 GD-11 LEAD SANITATION DRIVER 0.10 $ 6,351 0.10 $ 6,461 0.10 $ 6,672 67054510 61010 670 1300 GD-06 SANITATION DRIVER 1.30 $ 72,812 1.15 $ 65,359 1.15 $ 67,796 -135- CITY OF DUBUQUE,IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2021 FY 2022 FY 2023 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET YARD WASTE& 67054510 61010 670 GD-06 SNOWFIGHTER - $ - - $ - 0.58 $ 30,168 RESOURCE MGMT 67054510 61010 670 6100 GE-35 COORDINATOR 0.10 $ 8,367 0.10 $ 8,563 0.10 $ 7,082 Total 1.50 $ 87,530 1.35 $ 80,383 1.93 $ 111,718 Yard Waste Collection-Seasonal Refuse Fund 67054510 61030 670 1325 NA-26 SANITATION DRIVER 0.50 $ 16,182 0.50 $ 16,464 - $ - Total 0.50 $ 16,182 0.50 $ 16,464 - $ - Large Item Collection-FT Refuse Fund 67054520 61010 670 2655 GD-11 LEAD SANITATION DRIVER 0.10 $ 6,351 0.10 $ 6,461 0.10 $ 6,672 RESOURCE MGMT 67054520 61010 670 6100 GE-35 COORDINATOR 0.06 $ 5,020 0.06 $ 5,139 0.06 $ 4,249 Total 0.16 $ 11,371 0.16 $ 11,600 0.16 $ 10,921 Recycling Collection Program-FT Refuse Fund RESOURCE MGMT 67054530 61010 670 6100 GE-35 COORDINATOR 0.44 $ 36,813 0.44 $ 37,681 0.44 $ 31,163 67054530 61010 670 2655 GD-11 LEAD SANITATION DRIVER 0.40 $ 25,406 0.40 $ 25,844 0.40 $ 26,686 67054530 61010 670 1300 GD-06 SANITATION DRIVER 6.75 $ 372,440 6.70 $ 378,466 6.70 $ 382,453 Total 7.59 $ 434,659 7.54 $ 441,991 7.54 $ 440,302 Recycling Collection Program-Seasonal Refuse Fund SANITATION DRIVER- 67054530 61030 670 898 GD-26 SEASONAL 0.08 $ 2,589 0.08 $ 2,634 0.08 $ 2,719 Total 0.08 $ 2,589 0.08 $ 2,634 0.08 $ 2,719 City Garage-FT Service Fund 81054600 61010 810 3225 GE-35 EQUIP MAINT.SUPERVISOR 1.00 $ 75,299 1.00 $ 80,601 1.00 $ 87,654 81054600 61010 810 2525 GD-10 MECHANIC 7.00 $ 414,299 7.00 $ 409,485 7.00 $ 428,559 INVENTORY/ACCOUNT 81054600 61010 810 GE-27 CLERK - $ - - $ - 1.00 $ 46,082 81054600 61010 810 835 GD-03 STOCK CLERK 2.00 $ 98,148 2.00 $ 100,328 1.00 $ 52,073 81054600 61010 810 7250 GD-11 LEAD MECHANIC 2.00 $ 123,268 2.00 $ 125,738 2.00 $ 130,103 Total 12.00 $ 711,014 12.00 $ 716,152 12.00 $ 744,471 City Garage-PT Service Fund 81054600 61020 810 3056 GD-03 CUSTODIAN I 0.15 $ 7,288 0.15 $ 7,417 0.15 $ 7,658 Total 0.15 $ 7,288 0.15 $ 7,417 0.15 $ 7,658 Landfill-FT 94054200 61010 940 2625 GE-36 DMASWAADMINISTRATOR 0.40 $ 29,309 0.45 $ 35,308 0.45 $ 38,469 94054200 61010 940 2625 GE-35 LANDFILL SUPERVISOR 0.60 $ 50,702 0.60 $ 51,661 0.60 $ 53,645 94054200 61010 620 2655 GD-11 FOREMAN 0.60 $ 36,294 0.60 $ 37,289 0.60 $ 38,504 94054200 61010 940 2525 GD-11 MECHANIC 1.00 $ 59,299 1.00 $ 63,810 1.00 $ 66,070 94054200 61010 940 2300 GD-08 EQUIPMENT OPERATOR II 1.40 $ 82,513 1.00 $ 60,291 1.00 $ 62,242 LANDFILL EQUIP 94054200 61010 940 2948 GD-O8 OPERATOR 2.75 $ 156,788 3.15 $ 182,480 3.15 $ 182,220 94054200 61010 940 870 GD-04 SCALE HOUSE OPERATOR 1.40 $ 70,467 1.40 $ 71,165 1.40 $ 75,127 -136- CITY OF DUBUQUE,IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2021 FY 2022 FY 2023 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET Total 8.15 $ 485,372 8.20 $ 502,004 8.20 $ 516,277 Landfill-Seasonal 94054200 61030 940 1325 GD-26 EQUIPMENT OPERATOR 0.75 $ 24,273 0.75 $ 24,696 0.75 $ 25,494 Total 0.75 $ 24,273 0.75 $ 24,696 0.75 $ 25,494 Composting-Landfill Program-FT 94054210 61010 940 2625 GE-36 DMASWAADMINISTRATOR 0.10 $ 7,327 0.10 $ 7,845 0.10 $ 8,547 94054210 61010 620 2655 GD-11 FOREMAN 0.05 $ 3,024 0.05 $ 3,077 0.05 $ 3,209 LANDFILL EQUIP 94054210 61010 940 2948 GD-08 OPERATOR 0.10 $ 5,700 0.20 $ 11,599 0.20 $ 10,824 94054210 61010 940 2625 GE-35 LANDFILL SUPERVISOR 0.10 $ 8,451 0.10 $ 8,610 0.10 $ 8,940 Total 0.35 $ 24,502 0.45 $ 31,131 0.45 $ 31,520 HHMRCC-Landfill Program-FT 94054220 61010 940 2625 GE-36 DMASWAADMINISTRATOR 0.15 $ 10,989 0.10 $ 7,845 0.10 $ 8,547 94054220 61010 940 2625 GE-35 LANDFILL SUPERVISOR 0.05 $ 4,225 0.05 $ 4,305 0.05 $ 4,471 94054220 61010 620 2655 GD-11 FOREMAN 0.05 $ 3,024 0.05 $ 3,077 0.05 $ 3,209 94054220 61010 940 2300 GD-O8 EQUIPMENT OPERATOR II 0.30 $ 17,440 - $ - - $ - LANDFILL EQUIP 94054220 61010 940 2948 GD-08 OPERATOR 0.10 $ 5,567 0.30 $ 17,226 0.30 $ 16,608 94054220 61010 940 870 GD-04 SCALE HOUSE OPERATOR 0.55 $ 29,238 0.50 $ 24,840 0.50 $ 25,505 Total 1.20 $ 70,483 1.00 $ 57,293 1.00 $ 58,340 Education&Communication-Landfill Program-FT 94054230 61010 940 2625 GE-36 DMASWAADMINISTRATOR 0.05 $ 3,663 0.05 $ 3,923 0.05 $ 4,126 94054230 61010 940 2625 GE-35 LANDFILL SUPERVISOR 0.05 $ 4,225 0.05 $ 4,305 0.05 $ 4,471 94054230 61010 620 2655 GD-11 FOREMAN 0.05 $ 3,024 0.05 $ 3,077 0.05 $ 3,209 Total 0.15 $ 10,912 0.15 $ 11,305 0.15 $ 11,806 E-Scrap Recycling-Landfill Program-FT 94054240 61010 940 2625 GE-36 DMASWAADMINISTRATOR 0.10 $ 7,327 0.10 $ 7,845 0.10 $ 8,251 94054240 61010 940 2625 GE-35 LANDFILL SUPERVISOR 0.05 $ 4,225 0.05 $ 4,305 0.05 $ 4,471 94054240 61010 620 2655 GD-11 FOREMAN 0.10 $ 6,049 0.10 $ 6,153 0.10 $ 6,418 LANDFILL EQUIP 94054240 61010 940 2948 GD-O8 OPERATOR - $ - 0.30 $ 17,226 0.30 $ 16,608 94054240 61010 940 870 GD-04 SCALE HOUSE OPERATOR 0.05 $ 2,658 0.10 $ 4,968 0.10 $ 5,101 94054240 61010 940 2300 GD-08 EQUIPMENT OPERATOR II 0.30 $ 17,440 - $ - - $ - Total 0.60 $ 37,699 0.65 $ 40,497 0.65 $ 40,849 DMASWA Rural Recycling Program-FT 94054250 61010 940 2625 GE-36 DMASWAADMINISTRATOR 0.10 $ 7,327 0.10 $ 7,845 0.10 $ 8,547 94054250 61010 620 2655 GD-11 FOREMAN 0.05 $ 3,024 0.05 $ 3,077 0.05 $ 3,209 94054250 61010 940 2625 GE-35 LANDFILL SUPERVISOR 0.05 $ 4,225 0.05 $ 4,305 0.05 $ 4,471 Total 0.20 $ 14,576 0.20 $ 15,227 0.20 $ 16,227 DMASWA Gas Collection-FT 94054260 61010 940 2625 GE-36 DMASWAADMINISTRATOR 0.10 $ 7,327 0.10 $ 7,845 0.10 $ 8,547 -137- CITY OF DUBUQUE,IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2021 FY 2022 FY 2023 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET 94054260 61010 940 2625 GE-35 LANDFILL SUPERVISOR 0.10 $ 8,451 0.10 $ 8,610 0.10 $ 8,940 94054260 61010 620 2655 GD-11 FOREMAN 0.10 $ 6,049 0.10 $ 6,153 0.10 $ 6,418 LANDFILL EQUIP 94054240 61010 940 2948 GD-08 OPERATOR 0.05 $ 2,822 0.05 $ 2,871 0.05 $ 2,964 94054260 61010 940 2300 GD-08 EQUIPMENT OPERATOR II — $ — — $ — — $ — Total 0.35 $ 24,649 0.35 $ 25,479 0.35 $ 26,869 TOTAL PUBLIC WORKS DEPT. 93.28 $5,344,683 93.28 $5,455,586 93.43 $5,653,693 -138- Capital Improvement Projects by Department/Division PUBLIC WORKS CIP FY 20 Actual FY 21 Actual FY 22 Adopted FY 23 Recomm'd Number Capital Improvement Project Title Expense Expense Budget Budget 1012477 MSC AIR QUALITY 32,750 1022938 ROOF-CENTRAL STORAGE 29,600 28,000 2501209 ST SWEEPER REPL PROJECT 2501227 CURB RAMP PROGRAM 547,761 9,142 799,492 2501230 ASPHALT MILLING PROGRAM 687 403 2501839 AERIAL BUCKET TRUCK 325,000 2501936 ENDLOADER PURCHASES 103,000 2502039 DUMP TRUCK REPLACEMENT 214,234 2602775 STREET OVERLAYS 3001006 CONCRETE SECTION REPAIR 32,000 25,000 25,000 3001209 ST SWEEPER REPL PROJECT 269,067 3001226 CURB REPLACEMENT PROGRAM 8,100 11,909 20,000 50,000 3001227 CURB RAMP PROGRAM 1,205 199,189 342,265 38,595 3001230 ASPHALT MILLING PROGRAM 75,461 88,475 83,092 172,832 3001432 STEPS,RAILINGS,FENCING 10,000 3001445 FLOODWALL POST FLOOD REPA 4,471 17,163 25,000 25,000 3001839 AERIAL BUCKET TRUCK 125,876 3001936 ENDLOADER PURCHASES 3001938 DT SIGN POST REPLAC PROJ 46,938 10,000 15,000 3002038 PORT AMENITIES MAINT 5,157 3002039 DUMP TRUCK REPLACEMENT 285,409 182,930 3002151 WAYFINDING SIGN REPLACE 22,432 3002221 TRUCK-MOLTNTED NEW CONCEPT 19,254 3002539 DUMP TRK REPLC 136,959 504,800 3002541 MSC LED LIGHTING 36,950 3002789 HAWTHORNE BOAT RAMP 1,600 3002815 BEE BRANCH TRANSFORMER ll 5,575 3002908 EV CHARGING MLTNIC SERVICE 15,602 3502222 ICE HARBOR GATES TIMBER 145,000 3502480 PURINA DRIVE FLOODWALL 64054755 WATER MAIN REPLACEMENTS 6,600 8,700 6701533 DUAL PACKER RECYCLE VEH 452,275 542,154 7101341 SANITARY SEWER ROOT FOAM 29,530 30,000 7102405 ffiGH PRESSURE SEWER JET 274,642 7102909 SMART COVERS 30,000 7201209 ST SWEEPER REPL PROJECT 185,000 7202155 FLOOD CONTROL LEVEE CERT ll,382 8,258 7202335 HESCO FLOOD CONTROL LTNITS 366,667 7202405 HIGH PRESSURE JETVAC 69,438 7202480 PURINA DRIVE FLOODWALL 742 7202790 SURFACE DEEP CLEAN LTNIT 7202792 ICE HARBOR ABUTMENT REP 13,896 80,493 7202845 SANDBAG EQUIPMENT 8102907 VEHICLE MAINT LUBE SYSTEM 40,000 60,000 8102908 EV CHARGING MLTNIC SERVICE 88,405 9402685 SHORT-TERM FACILITIES 9402770 SWISS VALLEY LAND ACQUIS 18,499 9402820 CELL 9 PHASE 4 2,833,020 862,760 9402868 LANDFILL FLARE RELOCATE 130,000 -139- Capital Improvement Projects by Department/Division PUBLIC WORKS CIP FY 20 Actual FY 21 Actual FY 22 Adopted FY 23 Recomm'd Number Capital Improvement Project Title Expense Expense Budget Budget 9402956 LANDFILL HAUL TRUCK REPL 601,000 9402957 LANDFILL SEWER LINE EXT 250,000 9402958 LANDFILL LiTTER FENCING 300,000 9402959 LANDFILL SVC BUILD DESIGN 225,000 PUBLIC WORKS TOTAL 4,603,066 1,929,973 2,299,301 3,969,495 -140- PRGRM/ PAG DEPT PROJECT DESCRIPTION FY 2023 FY 2024 FY 2025 FY 2026 FY 2027 TOTAL E PUBLIC WORKS Public Works Asphalt Milling Program $ 172,832 $ 88,144 $ 89,907 $ 91,705 $ 93,539 $ 536,127 195 Curb Ramp Program $ 838,087 $ 443,778 $ 481,720 $ 522,908 $ 533,366 $2,819,859 196 Curb Replacement Program $ 50,000 $ - $ 75,000 $ 50,000 $ 50,000 $ 225,000 197 Concrete Street Section Repair Program $ 25,000 $ - $ 50,000 $ 50,000 $ 50,000 $ 175,000 198 Street Sign and Post Replacement $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 75,000 199 Floodwall Post-Flood Repair Program $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 125,000 200 Steps, Hand Railings and Wall-Top Fencing $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 50,000 201 Ice Harbor Gates Fender Replacement Project $ 145,000 $ - $ - $ - $ - $ 145,000 202 Central Storage Building Roof Repair Project $ 28,000 $ - $ - $ - $ - $ 28,000 203 Vacuum Street Sweeper Replacement Project $ 269,067 $ - $ - $ - $ - $ 269,067 204 58,000 Gross Vehicle Weight (GVW) Dump Truck Replacement $ - $ 506,932 $ - $ 268,902 $ - $ 775,834 205 44,000 GVW Dump Truck Replacement $ - $0 $191,176 $ 390,000 $ 397,798 $ 978,974 206 Sprinkler System-Central Storage $ - $ - $ 18,500 $ - $ - $ 18,500 207 Mechanical Sweeper Replacement Project $ - $ - $ - $ - $ 230,000 $ 230,000 208 Hawthorne Street Boat Ramp Repair $ - $ - $ - $ - $ 41,410 $ 41,410 209 Backhoe Loader Purchase $ 103,000 $ - $ - $ - $ - $ 103,000 210 Municipal Services Center Roof Mounted HVAC Replacement Unit $ - $ - $ - $ 20,000 $ 75,000 $ 95,000 211 Municipal Service Center Vehicle Access Doors Replacement Project $ 36,950 $ 38,058 $ - $ - $ - $ 75,008 212 PUBLIC WORKS Business Type Smart Lid Manhole Project $ - $ - $ 35,000 $ 35,000 $ 35,000 $ 105,000 213 Sanitary Sewer Root Foaming $ - $ 30,000 $ 35,000 $ 35,000 $ 35,000 $ 135,000 214 Replacement of Main Line CCTV Inspection Unit $ - $ - $ 295,000 $ - $ - $ 295,000 215 High Pressure Sewer Jet Cleaner Replacement $ - $ 210,000 $ - $ - $ - $ 210,000 216 Street Vacuum/Flush Unit Replacement Project $ 185,000 $ - $ - $ - $ - $ 185,000 217 Bee Branch Flood Control Pumping Station Camera Project $ - $ 55,000 $ - $ - $ - $ 55,000 218 -141- PRGRM/ PAG DEPT PROJECT DESCRIPTION FY 2023 FY 2024 FY 2025 FY 2026 FY 2027 TOTAL E PUBLIC WORKS Cab-Over Solid Waste Vehicles $ 542,154 $ 462,454 $ 463,004 $ 343,703 $ 355,732 $2,167,047 219 Electric Vehicle Charging Infrastructure Located at the Municipal Services Center $ 88,405 $ 20,139 $ 114,120 $ — $ — $ 222,664 220 Municipal Service Center Vehicle Maintenance Area Oil Lubrication System $ 60,000 $ — $ — $ — $ — $ 60,000 221 Municipal Service Center Vehicle Maintenance Area Wall Cleaning and Painting Project $ — $ — $ 5,000 $ 57,500 $ — $ 62,500 222 Heavy Vehicle Maintenance Lift Replacement Project $ — $ — $ 156,279 $ — $ — $ 156,279 223 Purina Drive Load Scanner System $ — $ 69,471 $ — $ — $ — $ 69,471 224 Landfill Service Building Design $ 225,000 $ — $ — $ — $ — $ 225,000 225 Landfill Litter Fencing $ 300,000 $ — $ — $ — $ — $ 300,000 226 Landfill Sewer Line Extension $ 250,000 $ — $ — $ — $ — $ 250,000 227 Landfill Haul Truck Replacement $ 601,000 $ — $ — $ — $ — $ 601,000 228 TOTAL $3,969,495 $1,973,976 $2,059,706 $1,914,718 $1,946,845 $11,864,740 -142- From: Candace Eudaley-Loebach <ceudalev@gmail.com> Sent: Wednesday, March 23, 2022 10:02 Subject: Public Works Budget Item Comment- Please provide an additional, smaller cart size options for residents Caution! This message was sent from outside your organization. Allow sender I Block sender The following comments are related to the Public Works Budget Items 12 and 13. For context, I served on the Resilient Community Advisory Commission when this item was originally proposed and I also served on the committee that developed the Climate Action Plan. I also take a lot of morning walks through many neighborhoods and this gives me unique insight into the refuse habits of the community. :) I do not oppose automated collection, nor do I oppose the consistency of tipper carts. I do oppose 35 gallons as the smallest mandated option. I ask that you request an additional, smaller cart size options for residents. My concern is the sizes that are offered are geared toward large waste producers and do not provide choice to residents who produce less waste than the 35 gallon cart. In the details of item 12 in the budget proposal it states that there was highest demand for the smallest carts (35 gallon). Specific populations who are negatively impacted by the requirement of the 35 gallon as the smallest cart option include the following: 1.Seniors who are aging in place and have a reduced trash volume. I have multiple neighbors in this category(75-85 yrs old) who put out a single small bag or the older style 20 gallon metal cans every- other-week because they do not produce much waste.A smaller option will also be easier for them to move on their own. Under this plan,there is no option for them except to take the much larger 35 gallon cart. 2. People living in homes with a single car or no garage-Older and Lower-Income Neighborhoods. A large percentage of Dubuque homes, specifically those built pre-1980's and lower income neighborhoods have only a single car or no garage. Many of these households also utilize the smaller cans or put out bags of trash because they do not have space to store a cart.The requirement of the 35 gallon cart means that their carts will have to be stored somewhere in their yard/outside and visible at all times or in their already limited garage space. 3. People who produce less waste and would like a smaller option.This one is about me. I would prefer a smaller option than 35 gallons. We are a family of four and even while our kids were in diapers,we didn't fill our 35 gallon container every week. We have a single car garage and do not have the space indoors to store the container. It will sit outside, detracting from the appearance of either the front of our house or our backyard space. Thank you, in advance,for your consideration. Candace Eudaley-Loebach 1715 Glen Oak St 563-580-7212 _�.�-_� . -��= �. ■!�� ^ . � t� �� � � � � 1 1 � ' ' �:� + I���'� � � ;. � , • � • a � '� ""� � � - .:,a, � ., � . �� • � _ s � . k- f5 Y� y �. ;� ,y y � �� `V .F ��v;w _ -. � �� _ �,�•�r"C if,,� }?;� � ' �'/-/// Jr"'.C' � � �. Public Works Department MISSION STATEMENT 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 prese►vation, construction, rehabilitation, daily operations, and the 24/7 emergency response the Public Works Department provides. Public Works Department VALU ES & 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. � - O i � SAFETY COMMUNITY-FOCUSED INTEGRITY COMMUNICATION EQUITY Public Works Department AGENCY SU PPORT The Department provides staff support to the Dubuque Metropolitan Solid Waste Agency Board of Directors and Landfill Operations DUBUQUE METROPOLITAN AREA SOLID WASTE AGENCY FY22 Public Works Team PT Custodian [0.69] � �, Foreman[1] Landfill Equiprnent Operator[5] Lead _� Adrrtinistrative Seasonal Equipment Operator[0.75] Assistant[1] � . • • Mechanic[1] � 3, Secretary[2] Scale Operator[2] FU� , �8 EQU�����N� S Director � Lead Mechanic[2] Assistant Director Lead Sanitation Driver[3] Mechanic[7] Fleet Accounting Sanitation Driver[20] Clerk[1] PG-�\v\���5 Stock Clerk[1] 5easonal Sanitation Dri�er[0.67] � Street Foreman[4] Sewer Foreman [2] Street Equipment Operator 11 [6] Sewer Equipment Operator II [1] Street Equipment Operator I[7] Sewer Equipment Operator l [5] qR� qS Street Utility Worker[11] Seasonal La�orers[1.4] Traffic 5i�nal Tech [3] Maint.Tech Apprenticeship[1] FY23 Public Works Team PT Custodidrl(0.61] . Foremdn[1] .��� . . ii ii ii . . ,Landfill Equipment Ope►ator[5] Lead Administrative . . . �� �� �� . Regional Collcction Ccntcr Assistant(1] �� +� �� � ` • • , Tcchnician [1] �� �i n �r, �:, • ' Mechanic [1] 93 � � � F •43 Sccr ctar y �2•67� �' Scale Operator(2] (/��, �; i �y EQU��q��N S � � �� � Lead hleclianic [2] , Director � Assistant Director Mechanic[7] . . . . Lead Sanitation Driver I1] �leet Atcounting. . , � Sanitation Driver(20] PG��v\�\�S Cferk[1J — Stock Clerk [1] ' �•Yard Wastc/Snowfightcr [1] • . . � � � � � . Street Foreman[4]. � . St�eet Equipment Operator II[6]. . , , . • Sewe�Foremdn[2] ' ° • • • Sewer Equipm�nt Operator 11 (t� Street Equipment Operator 1 j7] • • � • � � � • ' • ' • - • ' 'Sewer Equipment Operator! [5J � Street Utility Worker[11] •� • ' � $���sonal Lcsbor crs �0.90� . . ,: : Tra�c Signal Tech[3] �Maint.Tech Apprenticeship[1] Public Works Department Leadership � Public Works Assistant Public � � e Field Supervisor � Works Director !� ' �. � � �'T Paul Davis � Arielle Swift � � � -�' - ¢ � � �...� _ ' �f, - �� � . � ..� � Public Works Director ,�� _ John ;� � Klostermann "� -- ,� ,�. ��� � '.� �" � - !'� /� �-�� ° � � * ! _.. � ! � � '9 � F . � ,� ,�, � i f `�- `�, �` , `< ,.� - `r - ��� � -� ,; - , . �� Y � �'�.�� . �P,� � � Fleet Maintenance Resource Management ir , � SuNervis�r Supervis�r DMASWA Tom Kuhle Jacob Jansen DMASWA Facility Administrator Supervisor Ken Miller poug Hughes C REATI N G AN A Hi h-Performance Or anizat�vn tand Cammuni } that is g B �Y EQU ITABLE Data-Driven and Outcome-Focused built on the four pillars of: F -� COMMUNITY � � OF CHOICE . _ _ , . . � . . . . ■ ■ , r�, � , ■ � r a'�� • � - . � �: � , . ,.� , . � � r p � �ea � � _3_:�� ...__ .n _� _ �.e_��_,, an n i n Q aso3 Twa��qnF or,a�c�q�� IF C4�oase date 5dec:a da:a �Wednestlay,February9,2022) �Wetlnesdey,Feh�uary 16,2022) ��! � �Wednesday.February23.2022 T � . �` " �� � � � � 1 �Wednesday,March 2,2022> � ► ' � F �� � �. � � ��. � � �. ' } • . • 1 � # +��, � ' � • � � - � . .•,t#J ' 1 ' • ' . _ '� �" ' • - ' - • • ..M.. iii � • �� ' ' - . • • ' • • ��■ � ��ii�� ,� Z � -, - . �a• ��Fi��� - � ��.- ~ -... �:r- '�: � • . • � • ..�I,. . .. � M �-� � 1 .-__ _ �z=� -.-y . .:; 9 - - :.:T: �y�°�.�� :� }����. =K � "'7' I�IIdlR �'E•"�`�b�:�"��"�T'����y .-- Supervisor's Accident Investigation Report r�rie' e 5�•:;ft 24 responses � -- _ �- P rn r hi _ � at es s �� . ,,. � ; . ; � � , ��1�,�`i �� �. _ �� � , , ,� ���., �� '��=r _ :� ..�_ . -�:, �.�-. � - .�_, a�*`= � — �- � � ' � � `"• r - ' ���:�$ „ �r �.��� - ! � �'�1' �` - � � , �,�°'�'�' � ' r4 'r��� S��i' �x.j f"8�yu� �Z .�z � �. F� 5 x _''� - -�- �, � _' :f�,`�-����p,�p��� T . � IRff..r...:�1�1�`nKx. - . . r� � . 4 I / � _ \ - _ . J I I � � � . _. .. • , � � � � I / ti.. � � �.w / / / / � • • � I � � � , , - - �. � � � � � � � � � � � � � � � � �.;.:rnt O Jy �"'_� � '�tr�: �---""- ��1 R �. 1i �_ 17 �wirp■ _ , �� � n�5 - : aFr �3 .. — . �S _ -- i - � � ��� I - � � � � ``� � I � ' � I • Electronic Drop-off Glass CDBG Program HHM Mobile s, monitors, lapto ass Dro - r M � 1 � 1 : 1 ' • � . DIVERSION _ _ - '��� ; � � , _ - - ti � � � _ ���� �ar�;�;' �� i �� � �.,:- --:C� �� — � ; i I ;�1�'� .iE � � � ',.r ,� m-- __ = _��- . - - FISCAL YEAR 2022 _ , ,��.� .�� HIGHLIGHTS ��,., • 1 ,383 CDBG Large Item Pickups �,�. . [LIPUs] • 7,634 Fleet Work Orders � • 1 278 Overla Addresses a � y = • 17,000+ Phone Calls - � � - �� � • 2 006 Cart Deliveries/Swa s � � p r :� � !. _ ��� -. _ , w . . ,,..1 � � � • • � ' • . � � , � � • � � � � � • � 0 0 1 186 740 17 . 60 � � Net Property Average homeowner's* property Tax Support tax cost for Public Works (*Avg. home value of $159,503) � • • � ' • . � � � � � 1 Only 6.32% of the Public Works Other, o.s�io � Ga agelVehicle . epartment is supporte t rough Landfifl � Maintenance, Property Tax. Operations, 10.0% 21.4% 93.68% of revenue comes from : • useri�ervice rees Refuse & � Streets, Salt, • State Road Use Tax Recycling and Snow & Ice Collection, Control, 36.5% Zs,a�io J � Storm Sewer Sanitary Sewer • Garage Recharges Maintenance, Maintenance, 1.5°/a 3.7% , � � � � , � � 1 � � � � • •�• � p � � � 000 oao � � 46 . 6% 44. 8% 5 . 8% 2 . 7% Employee Supplies & Equipment Recharges & Expense Services Replacements Overhead t _ ` 3�" S '!�.1..;a�' ■ � ...� � _ . �:; r� . j . . � t � J _ ' -- ��—�-rs � •� . �� Try y _ ." , _ � � �' 1^� I ��:-�� 'c_� � � ,_ . . � ��,' � . - _ � — '+". � � � � � �� I f � .r. ; r�A .. V � .S �' � `_'� -_ ' -•.� 4 -. . . . _ i. _l • ..4C. ?"�` - . �' �` •', � '_ - -._�.,..�' , ,-�i� Snow & Ice Control OT Cost Breakdown zso,00a �5 • a4o,00a �o � . . 200,000 A5 ,.�.h � � — � � � � 160,000 40 � �C � c � � �g �zo,000 s� � — � = � � � so,000 so � �D ,� V� .� 40,000 25 : : 1 1 a zo 2016-2Q17 2017-2018 2Q18-2019 2019-2020 2U20-2021 2021-2022 � Regular OT Holiday OT — Snowfall {inches) 0 Weekend Events �� ��`s �,.� � �_ + .� -i .. r. � �F. . . .--I�Sa � P'd°' '.'��!'. - � :;.. -�.. i . _.�_L . Z�. _z z �� � �:ti. .. . . , .. .�iJ . / -�� � - �:��•w � ���, _ — ✓� a��� _ .—�, :� L . Y ~ � � + � �''�'�'3'; _�, 'a�Y�: � � �, . :,.4 �� ���:, 4� ,.�Y��5.�; t_�r y=�-�h� ��� R'�'`•'• . tJ �r 1��• �l�• �.ti, '1 ��� �9- �`�.�� ��' �` ..� �y-� • a a ��•'�eti.�' � . �i '� . r : . �o �+�k �a,..', � , �.i' �o`� ' .� � � �- ' - "-" +�. f �_ . :y� �i�'% ,,,�.,,"s�`+� ` `;/ .. . . �,{�� � , ��. :r? - !. ,t_ " • k"ti '�r� .:�st•ir ....,.� .i.�.�_ :�ii`-...:� �� .,.�.Y-.'�Yll Street Mai ntenance Overlay Program Miles Completed per Calendar Year 1 . - - - - - - - - - - - - - - - - - - - - - - - - - - - - 7.11 � - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 7.fi4 1 : - - - - - - - - - - - - - - - - - - - - - 5.51 � • - - - - - - - - - - - - - - - - - - - � 5.17 1 1 - - - - - - - - - - - - - - - - - - 4.92 � - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 10.01 � - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 1�.77 Y�;�r , �`!��� �-`, � � ;.:�,i:, �, :� � �� - - - - � ; ��.: �► �, �i � � _ ' • � . • � • � . • � • � . � ►�� x �. �� �, P � �. 'E Overla Pro ram Im acts � - � �� - Y 9' p - � .'4 �� � � � ��. � :T iF f ` . . . ci/ F �. .� '�..i$ 2Q,U% 17,5% � � � � � � � � � � � 17.9% 15.0% 12.5% 12.5% 1 U.0% 7,5% 5.0% 2.5% -% _ � CY2017 CY2018 CY2019 CY2020 CY2021 CY2022 � Low [ncome Minority City-Wide Minority •■■ City-Wide Low lncome � Visual Inspection - 33.3% . �� � � TV - 8.9% � � Root Cut - 2.5% � • Vacuum - 14.2% � Jet with Soap - 0.5% JetlFlush - 39.4% �� Acousfic Testing - 1.2% 11 - 11 - - • - • ' �������Illli� � �� �� '��' ,� `. � � � ,,�, w� I'� � { � � �_•-- �� � r�! �� ' �;, � L � � - � - � � - �`� + _ \ !S � ! , � . � "`''��!! � . . �� �_ _ a. �,'a .� . ` • • � • � • • • . • ' 20��00 17,500 so�o 15 000 a�io s�io s�io s�io 11% •� , , �� �� �� 12,500 ssQia 10,000 71% 72% 74% 74% 74'% # Refuse �# Recycling 7,500 �# Yard WastelFood Scrap 5,000 2,504 FY2416 FY2017 FY2418 FY2019 FY2024 FY2421 � � � � � PET Plastic 5.50 � � � Beverage Containers 1.29 i Plastics # 3-5 2.s4 � HDPE Natural Plastic 3.so � Tin cans 3.69 % Corrugated Cardboard 1�.1s � Newspaper/Mixed 61.1� � \A/LI AT�, IN THERE? � � � � � � � � � . . • • . . 1 ' ' � I 1 � . ' I � � . 5000 4376 4000 1038 3000 ' . Z000 � � �000 0 CY2Q18 CY2019 CY2020 CY202'I � Large I#em Collection CDBG Financed � . � . � � � . . $15.38 �17. 22 $ 20 . b5 $ 29. � 0 �� ��� �� ��►� �� ��` �� ��� CART CART CART CART �7. 69 $ 9. 53 $12 .9b $ 21 .31 ��iF �r�+►` ��'i ��,� i�� '+��;►.� �� ��M'►�L CART CART CART CART '� • • • • • - ' - - � � � � � � � � � � � . . FY23 BASE RATES $35.00 $30.00 $29•0� $25.00 $21 .99 $22.00 $22.53 $20.00 �18.61 $'19.00 $19,50 $19.65 $15.00 ��4•�� �14.56 ���•�5 $15.38 $14.0� $5.00 $— Oa�Q��ot'� e��o`�es e��o`�es O�`p�o►�e S`o��.G�ti�1 �a�e,��o° `o�aG�'��! O��JaJe P��et�`1 �G`\g��'F�� a��a��d5 P,�eS p �,�p �y�o Go� Ged �e P�eiage � � � � ' � • • • • � I � � �oo°io 89%Q 80°/a � 71% 60% 40% 2800� — Dubuque 0 FY22 2�0�0 0 FY23 17% —% � � � � � � � - � � � � � � � � � � � � � � � � � � � (8)% �2��% �����% {40)°10 Low Avg Without High � � � • � • , � 1 � 1 r 0 ■ O ■ Proposed Rate Monthly Bill Impact for Increase over FY 22 Average Household � Communication Casting Module � $1 ,500 ' • � � ' ' • Part-Time Secretary . � Recurring � $30,713 Non-Recurring � $4,500 Accreditation Application � $23,000 Portable Barriers � $120,000 Grapple Attachment � $23,100 Mowing Attachment � $7,500 � Backhoe Upgrade � $30,000 ' • � � ' ' • Safety Training � $30,600 . � Legal Safety Sign � $4,125 Additional 5-mile Overlay � $392,980 + $20,000 Yard Waste/Snowfighter � $31 ,441 Sustainable Materials Mgmt Consultant � $25,000 Tipper Carts � $582,698 � Z � � � O � Z� N ��� � -�P O � g6 � O � O � O Q35 GA���N � •, , � O � � � � �g_GP�LpN Q � , ARPA Funding (FY23) $ 582,698 ARPA Funding (FY24) 291 ,349 ' Recurring Improv Pkg (FY22) 70,000 $ 944,047 (� Recipients may use State & Local Fiscal Recovery Funds to Z Replace lost public sector revenue using this funding to provide — J government services up to the amount of revenue loss due to the � pandemic. �C ' a Recipients may determine their revenue loss by choosing � � between two options: . Q 1 .A of up to $10 million in aggregate, not to exceed their award amount, during the program; � 2.Calculating their jurisdiction's �� � ��ss each year using Treasury's formula, which compares actual • revenue to a counterfactual trend. Recipients may use funds up to the amount of revenue loss for ' government services; generally, services traditionally provided by recipient governments are government services, unless Treasury has stated otherwise. � • , 4 • ; � _ � . 0 � _ � � � � O �.��;�' �- � , . ' � � � ��� � ' ''�� - , :� , � . V � ' � � � � �� � � .�, '�`��-, ` .,��' ` . � ., � -•. � ' �, � ' ;.� ��y ,� +� . , � `�~�� r., �' � ��� A �• � , ''� � • '� � . � ' '' \� ` . i � . t. �, �" '- � �`� �� �. i' I � � ' . , . �1 .___ _"� ..+��•�� � r .� r'� � � ` ` _ __ . -�". �r , - �r �� .� �wor.r��• - — -`� � �- ��� � . .: ;�C3.�.. . . � . -- ' 1��Y- _' I___ __ �.__ '�___ _ �` �r . _fr� �,� . ��i�V�r��y� __. -_ ! __ �'1��_... . ... . ..� ��� .- . . • � �_. -� __ �. � � _ _ . ��_-.-,. ._... �� . 's�' . ._�/ `I.. . � ' _ �y i , . .� ' I . � � ' .-- ' ' -� r_ . \ _ .'T .1 � \ • � • • � . � � � � • 3145 2678 2537 - 2353 1964 1734 1595 1500 1321 1272 967 99fi 100a 861 979 709 709 672 565 635 4$3 697 50a 265 333 3fi3 482 394 0 �Y16 FY17 �Y18 �Y19 F'Y2Q FY21 F'Y22(�'eb) �35-Galfon �48-Gallon 64-Gallon � 96-Gallan � Recycling Cart . MCr.�, ` i _ � • s �'�' • . • 1 � ,I. � . � . . - ,,,_� +r• ` �r t�,�" ,� r � ; �'�'.,f�;;.�:_.,. . . •,f,�.'r �'�2/1 7 7 r�n r �+� �c f�rr�n r � . � . � �:.. �;� _ , . �� �`�� `��. ' r f � �� . � �.. � i � .,,, 1' -'�► ' • . ' '� i � P�`'`C._ � ' � � .��\;�:?`�<.'.��:-. �. � • . . � - `,+; - ; '�:�'t'"� r� f �' . .,,� • {�,; �s ...,.. _ .� - . • . �► i � ��. �'�F ,�.:..,,Q" ��� � - , � � , ..^� _ ._ . _ ' � r `- - : . ' ,s - � ._T � .. • �•J f�va' a�► .. ` . �r.' .� . � • ' �� • I � � I . - _ ,�,k� „4;.;�, . � . :y..-..i. � £y'i!rw�!S�`_�:��� , � � �1 • y , '. � �: 537 Customers , ,,: . . � y . . z . . :��"�`�m�.�T Public Works Department FY 23 CAPITAL IMPROVEMENT PROJECTS - . . . - . . Asphalt Milling Program $172,832 $536,127 Curb Ramp Program $838,087 $2,819,859 Floodwall Post-Flood Repair Program $25,000 $125,000 Curb Replacement Program $50,000 $225,000 Street Sign and Post Replacement $15,000 $75,000 Concrete Street Section Repair Program $25,000 $175,000 Steps, Handrailings, & Fencing $10,000 $50,000 Ice Harbor Gates Fender Replacement $145,000 $145,000 Public Works Department FY 23 CAPITAL IMPROVEMENT PROJECTS - . . . - . . Central Storage Roof Repair $28,000 $28,000 Vacuum Street Sweeper - Replacement $269,067 $269,067 Backhoe Loader + [mini IP] $103,000 $133,000 Vehicle Access Doors - Replacement $36,950 $75,008 Vacuum Street Flusher - Replacement $185,000 $185,000 Electrical Vehicle Infrastructure $88,405 $222,664 Fleet Maintenance Oil Lubrication System $60,000 $60,000 Public Works Department FY 23 CAPITAL IMPROVEMENT PROJECTS - . . . - . . Solid Waste Vehicle(s) - Replacement $542,154 $2,167,047 � �,;� ��jj�A I�i� � � t�� ;�l ., �. c � �� ' � - �� . ..���. �! •� :� t>�. � �, i „�.l� ;�',' `�r -- '�� + r� /:, ' �, �< �;�- � � �- , - � • � _ � . . � r: ��'� , _�.. . � ' - �_- - , �} � �, � _�` R � �:� �� � � � � � � Q � �( • � �, '"��,'� rV ' r ,,�""�'-� , - � � � ;�. • � .� _ � . � � - � � f-, � � V) �" � � :.4 a.�� ;� � — �: � �� � ��� � ,�� �: .� ��� y� iSe ' � . �� .�- `" _,.�r 7.fLs � �+ j. ` � =�i ��� � � w.' �� �` ,.�,��� � y� � _ . � �� �. —� d � ��y �i�wr� � ��`l�' - � . i � �-. i• ' �1 t . '' I' /! � } -'4�_ , .�� • /T / ' f + � !� v `^ . . '+ c 1 � -� _ _'_�'i� = _ ' . .. , '� � � f � u � ������ '���.�� . ��--'�„�`�r. ,�' - ��. ` � � �.� � � � �� .��,�,.�_ « t. . •' -�' � . ► �- i� � g � � � � -'''' � � ' � �` � 1� �' � '�_ � 1� �`' • r� \ � � � ��, ,, s - .� �► .� � _ � • -� � S ♦� ' � 1_ 1 r �s �h�• � » ` � � � . ,+►� A � . � � � � � � ^ �� � � � �_ ., I� �:: -�: �'�a�► � �� ,,��. �. � _ � _ � — :�c'�` �� :. .-��. a � y ' l "��� � i._ �I� � ` 7 ♦ ��' ` + . `��• ,'�. . � * � '` ' ' '-F• •t/ �'1► � � � �� � : ., . .� �. . - _ '�� g { i� .� � �y e � - � . �� ��� �_' .✓ , ��.' . r... • i �-, aE' !e� 'r- •� . ., �', . - i . � �� � � � � . �;��. � ' " � /' � � : ,� f ��i� .�' �r:t �-�r .� � . 1� 1 � ��' � � ( a� '' ''� �`�` �✓ , �,J 1 � �� � � ��1+r'` _ . . � ' !•�.:� �.� t � ��� � r, � ,,� • . � ! _ •�r �� ��. � • : � "' *�w �� 1 - a`. �4'� � �� .� - A`� �. �T 1 f , • • , �: . :_ • � � � ���`- -4 � ' � ` � • • � • ` • ;� 7� _• �i� l•�• . �� �`+ ` � �- � .. � � ^.s•` •� 4. �_ . ,l }, , ' ,�' J 0 ' - _ - � H � Z O . _ :,� _ � - _ - V '' " 0 • � � O ; " +sl.. . *`: .. O ' • , .. �w i .��-'� . J • . . "-�. • �-!� � ..4,u'�,► � ; �t i • � � �. � si... � I ; .��' ` . ... . � :. , , - . - - . - _ . r� -.� w " � ti�. •. •����. - ti �� ��f' � � � � � �� ��.--� � .-.�__ ., .� .� ` � �� � �)� ES� . _ • . . , „��i��.� ► � � � . �/'� � �y � r y t ♦ . �r,,. _ ! � � ` ` , -`� � _ ` � i , .�,� . �:� _ . % � - � . . �. � . `� � � r �� �r . I , - . .. . � , � � ;_. � , .:I � -. ._. . �"�' , -- _ � I � _ j . . � �-�� � � �� � � � � �,. �' ` r! � • � ,���� � � ... . a� _ . � - � �{� � �'� � , � � .!`,: :I � j, � . - � ��y.�� ~ �� 4 �' ^�� -� ' � � Z J W Q � 0 W ��, (' � �� � • � Q Z Q � W SAF ETY V � � EFFICIENCY � � PRESERVES W � PAYT AESTHETICS & GROWTH I � } ���� i�i � .r`-�' _ � • • i �_.} `` � ' . i�.� ') �f� - -- � �� .� l, � � i ��� � ��q�r � _�-1� � ,� i ` �� � • � ` ' _ �� � s • � � h�•y, ; � ; � \ .� � � . , W • ;� �`' ; �� . ,� .. _ � � - � � �' `� t I, ;,�� �;- Q ` � ,. � � „r-::.a-.�_ . 'i ,* [ . =c� � � � � � � - � � �� 'i �f � - � �,;�5:'",� .=�'� - �+`` � � ���'l17 � �' � � '�( ■' `'' , I+V . _ — �\ � 1 ��V..� �.�.,y� ! 1 � - ;��1 �Il � yjP.E ' '•� _"r� '�1- . ` ' .M�S' Y . O Q ' :�/ '� �,• ' , �r{�.'r'p -�~�� - -�� �� � . _ ����-_� ' - —„s�::� � 4.�'X �I � _ '�,'�y: ' 'T:JY - ..' +' f f` � .I Z +`+ .� _ � L � i� � ,. � - ..;�> _ - , R,, l` _ - '� -- - r _,��-,, . ,_..� � . . > .��R�� �� .'�" � � f , ,r - ` _,.,�, , . �,y.���•..�?-y,�.�,� - { - � ti- ' � ��{ _'�' 1 -��'� -'� ��'���� '` FS''���" �`i �'�'�'�4`i�• , _ � � . � � � � � ` t.r� ` •' �` .� �, _�� � � � ►�. �'!���.Y ,�- �a • �, '�_ � ' ` i � � p � . . � ,+ ` � �:) �._ > y�y `I wT"� 4��� ■ `�, �;� � •��� t�� ,.y` f � T,�'' li y- , � - �- � � , -- ' '� � � . ��� ,. _ - �� � r . ., '� ..�� �� ��v' � - � , �� "1. _ _ ���; '- .�. _ . � ti `� ` ��' d;.e.<...� .� -�- i" � y,Wa-, y �+,.�. . , ._ .. . . . . _.... .:,c5..o-t;`u-.`:r3rfF " � � � � . � � � . Route/Day Stops/Route � � • � . Days/Week THOUSAN D Sto ps/Yea r • ' • • • • 1 • ' - , - • • / ' • ' • Last Payment Pay Out Days Out 2006 $ 72,302.19 364 2019 115,877.07 351 2016 254,572.37 230 2014 274,686.46 168 2017 62,337.51 156 2012 48,311 .55 147 2006 97,813.73 129 2017 50,132.97 105 2009 168,620.15 49 2011 265,014.91 26 �tal � �i ,4uy,ri6u.y�i �i , r�� 1 1 � 1 • . . � • . • . � � . Chart 4.Fatal nork injurr�rates per IOD,ODO full-time equivalent workers b� selected occupations,2019-2fl ■2019 2020 Fishing and hunting workers' Logging workers Roofers Helpers,construction trade Aircraft pilots and flight engineers Refuse and recyclable material collectors Structural iron and steel workers - i i i i I pri�er/sales workers and truck drivers - 0 20 40 60 80 100 120 140 160 "Fatal work injury rates incorporate revisions to the Current Population Survey's(tPS)occupation classification codes,implemented in 2020. CPS data are used to determine total working hours for each accupation.Comparison of data far 2020 to year 2019 and prior should be done with caution due to these changes. ' • � � 1 � 1 1 � � �+ �. ' ~. � �� �1.� I'' r s� � � I � J� � �--� �,� r`. ; ;� y � ,�;�ijllf�lj h`. .p_ -� '� �• � +�, .'� � .r ".' ��*,..' `""'� � ,-- i -�- ;' - � �� r` � � ��� � . Y+�`�'� � �� -�. � �. =�^`�.: �3 ��t�+���i � \ � -- ,:,�,,:. - �_ �: �� �R: � ��� � ,� _ '�,,, ��`� '�� � � Z y.1'.�;� �,����-�?'o _j �� y����1�- �_ ,_ ..� �',�' .�. i :~ ,- _ . \ „r �� �� . . . _ •�.' �-�s � �, � � �' I ��� . ' � � ` ` �'�j^�,ys�,A t '�- �. ' „`' _��I-. .+,� � "7F3.��� y ti `7 . . , �-���� . �=�r"`.-.;�,�"`",j._ 'y;~ - •�^ ,. . - . � �� �, ._ � . . � <_" _ - - _ � � .4¢-. .. .r � _ -< 1 ` `'� . -_ �1. - •-�' ��' — �' i � � ^ ��'� _ ;�: r,. �,� -- .F �� r �r ,..,,� � -, ���� '�� �• . � �.`��.` . - - �� � � ""-:• ��. '=, �.;,�.°� �.: '`;;� .� ;�„"" ,�j!�..-!.-` y?"!i" �= !; t `` ��,r.r•� � � k } i ., �.� ��.y„ �'j1"`^�_ t,; -� f ��� 1 , _ �F �.�_ - �� /'�f `i. �' ��'1 �}' ..:.�1 � M t�`r,v .� :��1. '� '�!b „ � r.:�; �+�'_. � �rs3 • �,,� � ' •�� .�, � ���r��,, ' �'�'a:�"'` � =r' � �`�'''�, - =�y ��� ., ;' .,��� '� �r,;. ` • 1 _ �- ��i'i�. _ r ! �.f��,�. .- � �' I , ' + Z, � •� ��' - ; � � `��r,,�� '� , , _ `�-.�.� ��:;a����� u � r..4 '�. . l• ,. � �� . �. A f. �fay � ��jj.. ���,`� � ff�� y�Q��;��, ��1• � ..� ��I�����L . .3- , . . ��. ,+a.(A+�_ � � � � � � • � , � � , � • ' ' + f - )� __ �, _ �,�� ; r � �i � � t��=�. , =z. �� � " j �.wti� � � , � � � f' � �: •� � .� - � ^� .,� ,� • , , �, � / _ t• , . �r, _ '/ �" -; � - �� s �, -- _ � �� ?- V �� � � # . � � � f/r J - � ' ! L 1 .f, , �� , b . � •� + �— � - �• , f `� , r t-�i� �+ �� � �� �� � , y� ' � � ,�" f•� , �. �•1 '_ � �'�l � • ` • - � . � �. +� '`+ � ��� � � - - . , . t t � � .� � � - • ' ?� ~ ' . � r � ;- �V�' t � � � ' . r - '�� � i� ' � �7�7 ,; ���r�_ k �, r.i . I � 1� I � • � � ��.�- . � .; � �C �� '� : _ - .,� � � -`� . `4� .. . � . � �� �_ - ; ��� _'' '�`� � � . � • • � � � • • ' ' � . ' Incremental Rates Over Basic Rates $�6.00 20% $16.00 80% $12.00 15°/a $12.00 60% $8.00 10°/a $8,00 40% $4.00 5% $4.00 20% $Q.13 $0.21 $0.28 $p.�!3 $�.1 S $0.23 �— —°�a �i— —% lk��Ga�l lx�6 Ga�l `k�o Ga�l `x�a Ga�l `x�o Ga,�l `x 6o Ga�l ��C'a� 6a Ga� 9�Ga� �$C�a� 6�Ga� 9�Ga� � Incrementa� Increase RatelGallon � Increase over Basic RatelGallon — Incremental Increase $ — Increase over Basic $ Incremental Increase % Increase over Basic % � � Rev i ew of C u rre n t O erations p . . Conduct a Communit y _ En a ement Cam ai n g J p g � � Review Fee Stru ctu re - Rev i ew of C u rre n t O erations p . Recommends cart purchase & automated collection � and identified benefits of an automated program : — a. Worker Health & Safety b. Limited Need for Two-Person Routes c. Higher Job Satisfaction - Conduct a Communit y En a ement Cam ai n g g p g . 785 Responses to Community Survey and Social � Media Polls : 80% of customers would support changing to trash carts and automated collection � ■ o Review Fee � � Stru ctu re � _ � 0 � � 785 Responses to Community Survey and Social � Media Polls : N a. 60° - would not a more for more ca acit /o p Y p Y b. Curbside Diversion efforts are all subsidized by the base rate: - Recycling - Ya rd Waste - Food Scraps � • � TH E IS � �> > ,� 2 3 8 4 7 6 5 � . �-. � � �f-�_ _ . , � n � � �.r.� ,�-� �.r � ` .i' - _ �`.�; '' ,� ���- - . �; _ �. �� ,�,y4 •_ ;r� , �'� - s i,r •�,.�" .�. i �`�� � -5 ?� ` � ��-. .s= - ._�"" f ��! . ��_ - r /;��¢� ��_ '� _,. l! � „t .��'� ,� .; , .: ',, �'� ;.�++�►�: �. � �4 ,`�t. � il y � -=� -. � : - �..: _ � � � ,�� , � l +,• � �a � ���,: �,,r:•` -� • ���� ,�� , � ,� __ Y,,��,�°'` - . " . ,,. _- ,.: : .. � �� + J' �� `�� l,l''^ �� '���� ��� .;� `r �.� '���� � � ��. �-�� �y. � ' , , ����' j .�� -,!�/` p-r . .�y. _� rft1 �` ! �' " ti- `�i�� � f'1 +�r%i ��� �.�i+ i i: � V �U►..�w __ •� _ �.y ll ..ay„�� l'��` S •'w� � � _�M -.�,� � '� " �- - `"~�� { _ � � � y .• . �� '• + ' � S � � -_ �� � 't`r t �� _ �i .� � �— .� _ ,_ � 'y C �_ �<-. �� � .y�Y.�t . � ,�; , '�'. i : � ��.'; � � !�-�.,��s,'y�'" � ' , , e -- -'��-f} �'`.. .,""��! ��� � �� - ,� - ,a,� — - � , � --a��- • ^ __ . '� .. �= ;� � f' � �, �`• _ � -,�� #...�.�� '� _ _ ' ,� 'r`r � '; , � L�� _ * ' _ ; .-.,�. � � , � -� - - � . .�� ,,��„ , . ..r.. �.-�- � ,� �► ;, �-P�. ' ��:�°�`� �� � � � �- � �,� .� � � � � �, � � - � , I ! - ''� ' , � . � � .. ' � � A- � 1 �/ l ��` lc'� / �-�M-��tyotau ��� u�.�r�, {�w4rKs + • . • . �`1 , f f� :�����:::. From: "David T. Resnick" <dresnick@cityofdubuque.org> Date: March 23, 2022 at 4:51:43 PM CDT To: Mike Van Milligen <ctymgr@cityofdubuque.org> Subject: 20 gallon example Mike, South King County uses automated pickup and uses 20 gallon containers? Why can’t we do that? See link: https://us-west- 2.protection.sophos.com/?d=wmnorthwest.com&u=aHR0cHM6Ly93d3cud21ub3J0aHdlc3QuY29tL3NraW5nY291bn R5L3NlcnZpY2UuaHRtbA==&i=NWY2MjY3MTkwYTc2YjQwZWM0NWY0NWZj&t=cXpNWVUwTWJGeDZuMnNtaG1 yZFNnVVJIK1JMLzRzUWJvM0dscDVqQ3owND0=&h=a568e3ead5a54373b419fd0720587468 David Resnick Sent from my iPad