The URL can be used to link to this page

Engineering Department Fiscal Year 2024 Budget PresentationCopyrighted March 22, 2023 City of Dubuque Special Meeting Public Hearings # 05. IT E M T I T L E:Engineering Department F iscal Year 2024 Budget P resentation S UM M ARY: S UG G E S T E D D I S P O S I T I O N: AT TAC H ME N TS: Description Type Policy Budget Book Supporting Documentation Presentation_Uploaded 3.22.23 Supporting Documentation Public I nput Supporting Documentation Utilities and A C P Program Flyer Supporting Documentation Engineering -87- This page intentionally left blank. -88- ENGINEERING DEPARTMENT Budget Highlights FY 2022 Actual FY 2023 Budget FY 2024 Requested % Change From FY 2023 Budget Expenses Employee Expense 3,352,040 4,013,408 4,302,866 7.2 % Supplies and Services 1,927,386 2,677,661 2,907,230 8.6 % Machinery and Equipment 431,860 931,590 854,234 (8.3) % Payment to Construction Fund 518,685 400,000 400,000 — % Less Recharges to Service Funds (1,257,039) (1,701,847) (1,900,867) 11.7 % Administrative Overhead Charges 625,258 659,648 1,192,164 80.7 % Total Expenses 5,598,190 6,980,460 7,755,627 11.1 % Resources Operating Revenue - General 397,353 113,207 241,033 112.9 % Federal Building Lease Revenue 321,394 334,225 338,564 1.3 % Lease Expense Reimbursement 117,574 126,798 177,742 40.2 % Administrative OH Recharges 409,811 448,101 736,468 64.4 % Road Use Tax Funds 334,841 649,096 708,557 9.2 % Utility Charges - Parking 98 3,086 3,243 5.1 % Utility Charges - Water 40,002 42,951 50,182 16.8 % Utility Charges - Stormwater 2,287,631 2,739,995 3,172,536 15.8 % Utility Charges - Sanitary 239,794 373,935 423,683 13.3 % Total Resources 4,148,498 4,831,394 5,852,008 21.1 % Debt Service Stormwater debt abated with Stormwater User Fees 2,728,685 2,852,880 2,838,842 (0.5) % Stormwater debt abated with Sales Tax Increment 2,554,296 4,681,919 5,640,609 20.5 % Street Projects Debt abated with Sales Tax Fund (30%)/RUT 351,956 357,588 359,886 0.6 % FEMA Land Buyout Abated with General 7,054 6,731 6,878 2.2 % Total Debt Service 5,641,991 7,899,118 8,846,215 12.0 % Property Tax Support 1,449,692 2,149,066 1,903,619 (245,447) Percent Increase/(Decrease) (11.4) % Personnel - Authorized FTE 38.94 41.21 40.92 -89- STORMWATER UTILITY Budget Highlights FY 2022 Actual FY 2023 Budget FY 2024 Requested % Change From FY 2023 Budget Expenses Employee Expense 241,422 628,307 643,286 2.4 % Supplies and Services 875,400 1,068,586 1,111,843 4.0 % Payment to Construction Fund 518,685 400,000 400,000 — % Less Recharges to Service Funds (17,647) (312,270) (301,629) (3.4) % Machinery and Equipment 35,658 235,469 79,483 (66.2) % Administrative Overhead Recharge 625,258 659,648 1,192,164 80.7 % Park Stormwater Maintenance Charges 104,298 158,908 155,103 (2.4) % Public Information Office 8,855 60,255 47,389 (21.4) % Public Works Stormwater Maintenance Charges 230,710 286,307 298,467 4.2 % Debt Service 5,282,981 7,534,799 8,479,451 12.5 % Total Expenses 7,905,620 10,720,009 12,105,557 12.9 % Resources Operating Revenue 6,038,228 6,068,062 6,402,520 5.5 % Sales Tax Increment 2,554,296 4,681,919 5,640,609 20.5 % Total Resources 8,592,524 10,749,981 12,043,129 12.0 % Net Operating Surplus (Deficit) 686,904 29,972 (62,428) (92,400) Personnel - Authorized FTE 6.64 6.29 6.36 Stormwater User Fee Rate Increase 6.76 % 1.69 % 11.11 % Stormwater User Fee (per SFU)$ 8.85 $ 9.00 $ 10.00 Revenue 1% Rate Increase Generates $ 53,415 -90- FACILITIES MANAGEMENT Budget Highlights FY 2022 Actual FY 2023 Budget FY 2024 Requested % Change From FY 2023 Budget Expenses Employee Expense 481,881 556,755 595,643 7.0 % Supplies and Services 525,489 772,890 759,710 (1.7) % Less Recharges/Service Fund Charges — — — — % Machinery and Equipment 27,859 48,130 82,200 70.8 % Debt Service 110,324 128,666 138,006 7.3 % Total Expenses 1,145,553 1,506,441 1,575,559 4.6 % Resources Operating Revenue — 126 — 0 — % Federal Building Lease Revenue 321,394 334,225 338,564 1.3 % Debt on Building Improvements Paid with Sales Tax 110,324 128,666 127,274 (1.1) % Total Resources 431,718 463,017 465,838 0.6 % Property Tax Support 713,835 1,043,424 1,109,721 66,297 Percent Increase/(Decrease) 6.4 % Personnel - Authorized FTE — 7.55 7.60 *Facilities Management includes Facilities Management Administration, City Hall Maintenance, City Hall Annex Maintenance, Federal Building Maintenance (Moved from Housing in FY23), Engine House #1 Maintenance, Multicultural Family Center Maintenance, Ice Arena Maintenance, 5th Street Restrooms Maintenance, and Shot Tower Maintenance. Improvement Package Summary 1 of 13 This improvement package would add education and training for one (1) Utility Locator position. In FY 23, a Utility Locator position was added to the Engineering Department. Education and training funds are necessary to keep employees current on skills for their position. This relates to City Council Goal - High Performance Government. Related Cost:$ 305 Tax Funds Recurring Recommend - Yes Related Cost:$ 305 Stormwater User Fees Recurring Related Cost:$ 305 Sanitary User Fees Recurring Related Cost:$ 305 Water User Fees Recurring Total Cost:$ 1,220 Property Tax Impact:$ 0.0001 —% Stormwater User Fee Impact: 0.01 % Sanitary User Fee Impact: — % Water Rate Impact: — % Activity: Project Engineering, Stormwater Operations -91- 2 of 13 This improvement package would provide education and training for an Engineering Technician. An Engineering Technician position was added to the department in FY 23. Training funds are necessary for building skills for this position going forward. This relates to City Council Goal - High Performance Government. Related Cost:$ 1,220 Tax Funds Recurring Recommend - Yes Property Tax Impact:$ 0.0005 —% Activity: Project Engineering 3 of 13 This improvement package is for one additional utility locator unit. Since 2010, the number of utility locate requests in the City has nearly doubled, growing from approximately 5,500 to 10,500 requests per year. Earlier this year, the department added a second full-time utility locator. We currently have two utility locator instruments for the two full-time utility locator staff members, but we have a need for a third backup unit. This backup unit would be used by other engineering staff who are covering an on-call/after-hours shift or when the other two units are being repaired or replaced. This relates to City Council Goal - High Performance Government. Related Cost:$ 3,000 Tax Funds Non-Recurring Recommend - Yes Related Cost:$ 3,000 Stormwater User Fees Non-Recurring Related Cost:$ 3,000 Sanitary User Fees Non-Recurring Related Cost:$ 3,000 Water User Fees Non-Recurring Total Cost:$ 12,000 Property Tax Impact:$ 0.0012 0.01% Stormwater User Fee Impact: 0.06 % Sanitary User Fee Impact: 0.03 % Water Rate Impact: 0.04 % Activity: Administration, Project Engineering, Stormwater Operations 4 of 13 This improvement funds the purchase of two laptops for department engineers & technicians to share which will measurably improve the productivity of department staff that handles data that must be transferred by USB drives. The recently enacted Information Services policy on eliminating access to universal serial bus (USB) drives for cyber security reasons has significantly impacted the workflow of department staff to efficiently access and download data from several important types of field equipment. Impacted field equipment include, but is not limited to: sanitary sewer flow meters, drone photography, high-resolution cameras for confined space entry and manhole inspections, survey data collectors, and infrared thermal cameras. This relates to City Council Goal - High Performance Government. Related Cost:$ 1,734 Tax Funds Non-Recurring Recommend - Yes Related Cost:$ 1,733 Stormwater User Fees Non-Recurring Related Cost:$ 1,733 Sanitary User Fees Non-Recurring Total Cost:$ 5,200 Property Tax Impact:$ 0.0007 0.01% Stormwater User Fee Impact: 0.04 % Sanitary User Fee Impact: 0.02 % Activity: Administration, Stormwater Operations -92- 5 of 13 This improvement funds the purchase of all-weather outerwear for department staff who are required to work outside at active construction sites and inspect city infrastructure during all types of weather conditions including extreme cold, snow, rain, and extreme heat. Actively working in these conditions for extended hours during a day on a regular basis can wear out outerwear in a relatively short time. Some of the items to be purchased would be winter coats, winter work bibs, work boots, cold weather head gear, work gloves and rain gear. Many work locations also have federal safety standards which require high visibility reflective work gear. The reflectivity of required work clothing can often lose its reflectivity during a single construction season. This budget request provides for $300 per year, per employee (18), that work all or most of the work year in the field, to purchase or replace worn out outerwear as needed and as approved by their supervisor. This requests also provides for $200 per year, per employee (12), that work periodically in the field, but not on a full-time basis, to purchase or replace worn out outerwear as needed and as approved by their supervisor. This relates to City Council Goal - High Performance Government. Related Cost:$ 2,600 Tax Funds Recurring Recommend - Yes Related Cost:$ 2,600 Stormwater User Fees Recurring Related Cost:$ 2,600 Sanitary User Fees Recurring Total Cost:$ 7,800 Property Tax Impact:$ 0.001 0.01% Stormwater User Fee Impact: 0.05 % Sanitary User Fee Impact: 0.03 % Activity: Project Engineering, Stormwater Operations 6 of 13 This improvement funds the outsourcing of required Occupational Safety and Health Administration (OSHA) training that was formally provided by the Fire Department. Funds will provide for 16 training slots to already-qualified personnel within our department. This relates to City Council Goal - High Performance Government. Related Cost:$ 2,400 Stormwater User Fees Recurring Recommend - Yes Related Cost:$ 2,400 Sanitary User Fees Recurring Total Cost:$ 4,800 Stormwater User Fee Impact: 0.05 % Sanitary User Fee Impact: 0.02 % Activity: Administration, Stormwater Operations 7 of 13 This improvement provides for the funding of a Youth AmeriCorps Program intern (+0.32 FTE) to administer the Engineering Department's planned classroom and summer job training program for high school students, along with the classroom and job shadowing program for junior high students related to working for the City's Engineering Department for those who would consider the architecture/engineering/ construction field as a career choice. This unique, hands-on learning and mentoring program allows students to see first-hand the skills, technology, and people that are working to ensure the public has access to safe public infrastructure including streets, buildings, stormwater and sanitary utilities, along with how sustainable and resilient infrastructure helps to protect our environment and those living in our community. The Youth AmeriCorps position will also provide direct mentoring to the kids participating in the program with a portion of the program targeted to working with disadvantaged youths. The concept for this program has been developed in conjunction with city staff from the Human Rights, Public Works, Water Resource -93- Recovery Center, Water, Multicultural Family Center, and Leisure Services Departments, along with the Dubuque Community Schools District, National Mississippi River Museum, and Dubuque Area Labor Management Council. The goal is to develop content for the Engineering Department to serve as a phase 1 pilot and then expand the program to other city infrastructure-based departments. The content for the program will be modeled off of the "Work in Water Experience" developed by Wichita State University through the EPA's Environmental Finance Center at the school. Not only will this program provide students with new and eye-opening possibilities for career choices, it will also teach them about future work opportunities related to their interest specifically at the City of Dubuque by promoting the Municipal Career Pathways employment pipeline. This multi-department program directly supports the City's vision for improved equity and inclusion and strategies for poverty reduction. This position was approved for one-time funding in FY22, and all those involved desired this position to continue for another year. This request supports the City Council goal of Partnership for a Better Dubuque: Building our Community that is Viable, Livable, and Equitable. Related Cost:$ 4,334 Tax Funds Non-Recurring Recommend - Yes Related Cost:$ 4,333 Stormwater User Fees Non-Recurring Related Cost:$ 4,333 Sanitary User Fees Non-Recurring Total Cost:$ 13,000 Property Tax Impact:$ 0.0017 0.01% Stormwater User Fee Impact: 0.09 % Sanitary User Fee Impact: 0.04 % Activity: Project Engineering, Stormwater Operations 8 of 13 This improvement request is for the addition of a 12-month engineering intern position (+0.32 FTE). Over the past four years, the Engineering and Legal Departments have made significant updates to the City’s construction contract specifications that are used by all city departments for capital improvement projects. During the review process, it was determined that a more comprehensive update to the City’s current policies and standards related to OSHA compliance and protection of the public during construction projects is needed. This improvement will allow the Engineering Department to update and customize our current Department Construction Safety Manual. The needed updates will address new changes in OSHA regulations, such as permit-required confined space entry and silica (concrete) dust exposure. Five years ago, the department was able to complete an approximate 70% update to the manual, but due to ongoing high workloads, some important updates have not been able to be completed. With an intern solely dedicated to this work, we will be able to complete the needed manual updates and subsequently train city staff on safe construction site work practices. This request supports the City Council goals of Financially Responsible, High Performance City Organization: Sustainable, Equitable Service Delivery. Related Cost:$ 3,279 Tax Funds Non-Recurring Recommend - Yes Related Cost:$ 3,278 Stormwater User Fees Non-Recurring Related Cost:$ 3,278 Sanitary User Fees Non-Recurring Total Cost:$ 9,835 Property Tax Impact:$ 0.0013 0.01% Stormwater User Fee Impact: 0.07 % Sanitary User Fee Impact: 0.03 % Activity: Project Engineering, Stormwater Operations -94- 9 of 13 This improvement funds an intern position (+0.32 FTE) to assist full-time department staff with sorting through volumes of department records that date back to being over 140 years old. These records have irreplaceable historical value, and in some cases, significant engineering, legal, or monetary values related to past signed agreements, railroad ROW, utility easements, boundary surveys, and completed construction project engineering plans and records. There is no current system of filing for these randomly-boxed records, and existing staff have no way of knowing what information we already have. After collaboration with the Carnegie Stout Public Library staff, it is recommended that a Master's level librarian student be hired to coordinate the scanning and archiving of all records so that they can be easily searched for and found by future city staff. This relates to City Council Goal - High Performance Government Related Cost:$ 5,640 Tax Funds Non-Recurring Recommend - Yes Related Cost:$ 5,639 Stormwater User Fees Non-Recurring Related Cost:$ 5,639 Sanitary User Fees Non-Recurring Total Cost:$ 16,918 Property Tax Impact:$ 0.0022 0.02% Stormwater User Fee Impact: 0.12 % Sanitary User Fee Impact: 0.05 % Activity: Project Engineering, Stormwater Operations 10 of 13 This improvement provides funding to supplement the landscape maintenance work that the Leisure Services Department provides for buildings that are managed by the Facilities Maintenance Team (FMT). The FMT maintains several buildings that are iconic, architecturally significant structures that provide a sense of civic pride. Those buildings include City Hall, the Historic Federal Building, and the Old Engine House. Due to limited resources, the FMT and Leisure Services do not always have staff available to maintain the outdoor landscape at these locations in a way that maintains the esprit de corps of all city residents and city employees. These funds will provide financial resources to outsource ground maintenance on an as-needed basis to the exterior grounds of these buildings to maintain a high standard. This relates to City Council Goal - High Performance Government. Related Cost:$ 7,000 Tax Funds Recurring Recommend - No Total Cost:$ 7,000 Property Tax Impact:$ 0.0028 0.03% Activity: Facilities Management 11 of 13 This improvement funds the purchase of a wet mop floor scrubber for City Hall. This clean equipment cleans up to 70% faster than conventional wet mopping. This wet mop has the ability to get right to the edge and under obstacles, which means it eliminates many manual operations that are required to supplement conventional mopping. For a building such as City Hall that is mostly hard surface flooring, this unit measurably improves the productivity of the custodial staff. This relates to City Council Goal - High Performance Government. Related Cost:$ 4,800 Tax Funds Non-Recurring Recommend - Yes Total Cost:$ 4,800 -95- Property Tax Impact:$ 0.0019 0.02% Activity: Facilities Management 12 of 13 This improvement request is for metal detectors that are used on a regular basis by sixteen department staff members. In the past the department has ordered this equipment on an as-needed basis and has never formalized a replacement schedule. The metal detectors are used daily by our survey crew, GIS technicians, and utility locator staff. Metal detectors are used regularly by our I and I staff, traffic staff, and engineering technician and inspection staff. This relates to City Council Goal - High Performance Government. Related Cost:$ 1,500 Tax Funds Non-Recurring Recommend - Yes Related Cost:$ 1,500 Stormwater User Fees Non-Recurring Related Cost:$ 1,500 Sanitary User Fees Non-Recurring Related Cost:$ 1,500 Road Use Tax Non-Recurring Total Cost:$ 6,000 Property Tax Impact:$ 0.0006 0.01% Stormwater User Fee Impact: 0.03 % Sanitary User Fee Impact: 0.01 % Activity: Administration, Project Engineering, Stormwater Operations, Traffic Engineering 13 of 13 This improvement funds exterior window cleaning for buildings managed by the Facility Management Team (FMT). FMT custodians don't possess the proper equipment to be in compliance with OSHA standards while cleaning exterior & interior that are above 15'-20' off of the ground or floor. These funds would be utilized to outsource window cleaning to qualified vendors to clean locations on an as needed basis among all managed buildings. This relates to City Council Goal - High Performance Government Related Cost:$ 10,000 Tax Funds Recurring Recommend - No Total Cost:$ 10,000 Property Tax Impact:$ 0.0039 0.04% Activity: Facilities Management Significant Line Items Employee Expense 1.FY 2024 employee expense reflects a 5.00% wage package increase. 2.The Iowa Public Employee Retirement System (IPERS) City contribution of 9.44% is unchanged, and the employee contribution of 6.29% is unchanged from FY 2023. 3.The City portion of health insurance expense is unchanged from $1,119 in FY 2023 to $1,119 in FY 2024 per month, per contract, which results in an annual cost unchanged of $13,141 or —%. 4.Overtime is unchanged from $72,640 in FY 2023 to $72,640 in FY 2024. FY 2022 actual was $92,318. 5.Five-Year Retiree Sick leave payout unchanged from $11,748 in FY 2023 to $11,748 in FY 2024. -96- 6.50% Sick Leave Payout increased from $16,080 in FY 2023 to $16,388 in FY 2024 based on FY 2022 actual. 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. 7.In preparation of the budget recommendation, the work of each Engineering staff member is projected for the coming fiscal year. For example, with completion of the Bee Branch Creek Railroad Culverts project in FY 2022, staff might shift to other non-stormwater-funded capital improvement projects. As a result, adjustments - usually minor - are made each year. The Fiscal Year 2024 budget includes the following changes in the funding allocation of positions: 1. a.Confidential Account Clerk i.-0.05 FTE from Stormwater (-$3,475) ii.+0.05 FTE to General Fund (+$3,475) b.Civil Engineer I i.-0.15 FTE from Stormwater Fund (-$20,440) ii.-0.05 FTE from Sanitary Sewer Internal Service Fund (-$3,043) iii.-0.05 FTE from Stormwater Internal Service Fund (-$6,065) iv.+0.10 FTE to Project Engineering Internal Service Fund (+$12,150) c.Civil Engineer II i.+0.05 FTE to Sanitary Sewer Fund (+$7,096) ii.+0.10 FTE to Stormwater Fund (+$14,194) iii.+0.05 FTE to Sanitary Sewer Internal Service Fund (+$7,096) iv.-0.05 FTE from Stormwater Internal Service Fund (-$7,096) d.Engineering Technician i.+0.30 FTE to General Fund (+$29,789) ii.+0.15 FTE to Stormwater Fund (+$14,895) iii.+0.45 FTE to Project Engineering Internal Service Fund (+$19,859) iv.+0.40 FTE to Traffic Internal Service Fund (+$39,718) v.-0.30 FTE from Sanitary Sewer Internal Service Fund (-$29,789) vi.-0.10 FTE from Stormwater Internal Service Fund (-$9,930) e.Engineering Assistant II i.+0.10 to General Fund (+$10,357) f.ROW Technician i.+0.05 FTE to General Fund (+$4,763) ii.-0.05 FTE from Project Engineering Internal Service Fund (-$4,763) g.Secretary i.-0.35 FTE from General Fund (-$35,238) ii.+0.05 FTE to Sanitary Sewer Internal Service Fund (+$5,034) iii.+0.05 FTE to Stormwater Internal Service Fund (+$5,034) iv.+0.20 FTE to Project Engineering Internal Service Fund (+$14,825) As a result of the proposed changes above, the net increase (+) or net decrease (-) for each fund is as follows: Sanitary Sewer Fund is +$7,096, Stormwater Fund is +$5,174, General Project Engineering ISF is +$66,895, General Sanitary Sewer ISF is -$20,702, General Stormwater ISF is -$18,057, General Traffic Engineering ISF is +$39,718, General Fund is +$13,146. -97- 8. The following limited term intern positions ended during Fiscal Year 2023: a.Business Administration Intern -0.50 FTE (-$18,760 General Fund) b.Engineering Intern -0.25 FTE (-$8,590 Project Engineering Internal Service Fund) c.Broadband Intern -0.25 FTE (-$8,590 General Fund) d.OSHA Intern -0.25 FTE (-$8,624 General Fund, Sanitary and Stormwater) Supplies & Services 1.Other Professional Services increased from $167,207 in FY 2023 to $173,282 in FY 2024. This line item represents Stormwater Maintenance ($35,000), NPDES Consultant Services ($84,302), Stormwater I&I Prevention ($8,500), Detention Basin Maintenance ($27,040), General Sanitary ($424), stormwater ditch remediation ($3,000), and Project Engineering ($15,016). The largest increase was Stormwater Ditch Remediation Consultant Services, which increased from $0 in FY 2023 to $3,000 in FY 2024. 2.Inspection Reimbursement is increased from $36,000 in FY 2023 to $66,000 in FY 2024. This line item represents the refund to developers for subdivision inspection fees paid that were more than actual cost. There is offsetting revenue of $219,077 in the Subdivision Inspection Fee revenue line item. 3.Pay to Other Agency increased from $147,500 in FY 2023 to $153,416 in FY 2024. This line item represents the contract with East Central Iowa Association for transportation planning ($30,650) which increased $0 from FY 2023. The $5,916 increase is from the Catfish Creek Watershed Partnership payment ($122,766) as part of the 28E agreement with Dubuque County and the Dubuque Soil & Water Conservation District for the Dubuque County Watershed Program. 4.Grant expense is increased from $461,505 in FY 2023 to $493,843 in FY 2024. The increase is due to the stormwater enterprise fund utility fee subsidies for low income households ($65,037), residential farms ($11,891), and property tax-exempt properties ($391,915), which are based on FY 2022 Actuals increased by 1.69% in FY 2023 and 5% in FY 2024. While the numbers fluctuate during the year, approximately 115 customers receive the property tax-exempt subsidy, of which the top ten include schools, universities, and hospitals, and also account for over 70% of the property tax-exempt subsidy paid. Approximately 20 customers receive the residential farm subsidy, and approximately 475 customers receive the low-income subsidy. The grant expense also includes $10,000 for private sanitary sewer lateral replacement assistance, $5,000 for streambank stabilization assistance, and $5,000 for rain garden/rain barrel assistance. Finally, the grant expense budget includes $5,000 for snow removal assistance, which is used to assist low/moderate income citizens with physical limitations. This also helps fund the administration of volunteers to help with snow removal and associated shovel and salt supplies. 5.Sales Tax is increased from $185,472 in FY 2023 to $194,745 in FY 2024. This expense is directly offset by sales tax revenue. 6.Electricity increased from $249,598 in FY 2023 to $261,151 in FY 2024. The increase is due to a combination of higher electricity rates charged at all properties ($6,988) and the City’s purchase of the Hendrick’s building ($4,565). 7.Natural Gas increased from $57,684 in FY 2023 to $76,623 in FY 2024. The increase is due to the Federal Building actuals from the last two quarters of FY 2022 and the first two quarters of FY 2023. 8.Building Maintenance increased from $179,416 in FY 2023 to $199,532 in FY 2024. City Hall increased from $40,000 in FY 2023 to $74,540 in FY 2024, and the Federal Building decreased from $43,761 in FY 2023 to $35,000 in FY 2024 based on FY 2022 Actuals. Other buildings in this line item -98- include City Hall Annex, Engine House #1, Multicultural Family Center, 5th Street Restrooms, Storm Ditch Remediation, and the Detention Basin Maintenance with no major changes. 9.Property Insurance decreased from $84,148 in FY 2023 to $72,413 in FY 2024. 10.Technology Services increased from $264,361 in FY 2023 to $288,611 in FY 2024. FY 2022 actual was $124,362. The $24,000 increase can be attributed to adding the mobile device data plans to this budget item ($15,600) and a general 3% increase for software licensing costs in FY 2024 ($8,584). In FY 2024, Engineering Admin totals $5,843, Facility Management totals $9,810, Project Engineering totals $181,418, Traffic Engineering totals $44,160, Traffic Admin totals $0, Sanitary Admin totals $25,619, and Stormwater Admin totals $21,761. 11.Technology Equipment Maintenance Contract increased from $73,687 in FY 2023 to $77,187 in FY 2024. FY 2022 actual was $37,551. This line item represents maintenance contracts associated with camera maintenance. Increase is due to project engineering increasing from $36,500 in FY 2023 to $40,000 in FY 2024. 12.Property Tax increased from $103,867 in FY 2023 to $146,023 in FY 2024. FY 2022 actual was $99,186. This line item represents the property taxes paid on property that the City leases to other entities and is offset by lease revenue. The increase is largely due to the purchase of the Hendricks Building ($21,622.20). 13.Equipment Maintenance Repair decreased from $93,302 in FY 2023 to $85,213 in FY 2024. FY 2022 actual was $47,898.The figure is based on scheduled maintenance for FY 2024. The decrease is largely due to a $22,000 decrease in traffic network virtual server maintenance costs. Machinery & Equipment 14.Equipment replacement items include ($854,234): Engineering Administration Chairs/Desks $ 1,000 Smart Phone $ 350 Typewriter $ 900 Project Engineering General Fund Security Cameras $ 15,200 Desks/Chairs $ 1,000 Smart Phones $ 2,100 Drone Accessories $ 1,000 Traffic Engineering Road Use Tax Fund PTZ Cameras (9)$ 32,000 Network Switch - City Hall Fiber 3 $ 12,000 Network Switch - City Hall Fiber 4 $ 12,000 Network Switch- 3rd St Fiber 3 $ 13,000 Battery Back-Ups $ 25,000 Milestone Video Server (4)$ 24,000 Hyperconvergence Servers (4) Pivot 3 Servers $ 60,000 Streets Servers $ 30,000 Wireless Point to Point (2)$ 10,000 Engineering Machinery and Equipment -99- Hardened Intersection Switches (19)$ 65,000 Nitek Extenders for cameras $ 5,000 Milestone WS CPU $ 5,000 Milestone SAN - 2 CHASSIS $ 5,000 Offsite Storage $ 5,000 Axis Cameras (614)$ 159,200 Batteries (60)$ 12,000 APC Battery Backups $ 3,000 LCD Monitor 70"$ 5,000 Traffic Counters (3)$ 4,500 Metal Detector Smart Phone $ 1,000 Tactics Laptop $ 3,000 MacBook Laptops $ 12,750 Matrix Switcher $ 10,000 Dust Filtration System Project Engineering Sanitary Sewer Fund E-One Pumps (3)$ 6,000 Gas Air Meter (4)$ 500 Ford F-150 $ 35,000 Gas Air Meters (2) & Field Safety Equipment $ 750 Smart Phone $ 350 Tripod- Confined Space $ 2,000 Project Engineering Stormwater Fund Rain Gauge $ 2,000 Level Transducers $ 7,500 Weather Station $ 1,100 Smart Phone $ 350 Flow Meters $ 1,800 Facilities Management Facilities Management Smartphone $ 700 5th St Restrooms Camera Equipment $ 4,500 Ford Ranger $ 35,000 City Hall Annex Security Camera $ 2,000 Annual Projects General Sanitary Sewer Repairs/Maintenance $ 110,484 General Stormwater Repairs/Maintenance $ 50,000 Stormwater Ditch Remediation $ 15,000 General Building Maintenance $ 40,000 Recommended Improvement Packages $ 4,200 Total Equipment $ 854,234 Engineering Machinery and Equipment -100- Debt Service 15.Annual Debt Service Payments for FY 2024 are as follows ($8,846,215): $ 26,633 2017A G.O.Sales Tax 30%Fiber Optic & Street Light 2029 2025 $ 199,950 2017A G.O.Stormwater Fees Stormwater Improvements 2029 2025 $ 487 2017A G.O.Sales Tax 30%Street Improvements 2030 2025 $ 55,018 2006 SRF Stormwater Fees North Catfish Creek 2030 $ 118,460 2009 SRF Stormwater Fees West 32nd Detention Basin 2030 $ 71,488 2018A G.O.Sales Tax 30%Southwest Arterial 2031 2026 $ 158,862 2018A G.O.Stormwater Fees Stormwater Improvements 2031 2026 $ 122,877 2021A G.O.Stormwater Fees Stormwater Improvements 2031 2028 $ 6,878 2019C G.O.Sales Tax 30%FEMA Flood Buyout 2027 2026 $ 30,937 2019C G.O.Stormwater Fees Stormwater Improvements 2033 2026 $ 79,145 2021A G.O.Sales Tax 30%Southwest Arterial 2032 2028 $ 7,818 2021A G.O.Stormwater Fees Stormwater Improvements 2032 2028 $ 414,025 2010 SRF Stormwater Fees Lower Bee Branch 2032 $ 1,393,500 2014A G.O.Sales Tax Increment Bee Branch Watershed 2029 2024 $ 44,614 2021A G.O.Sales Tax 30%Street Improvements 2034 2028 $ 20,700 2014 SRF Stormwater Fees Lower Bee Branch 2034 $ 1,476,109 2015B SRF Sales Tax Increment Upper Bee Branch 2035 $ 2,771,000 2015A Revenue Sales Tax Increment Bee Branch Watershed 2029 2026 $ 592,200 2016B G.O.Stormwater Fees Stormwater Refunding 2036 2024 $ 18,538 2016C G.O.Sales Tax 20%Federal Building Roof 2037 2024 $ 1,002,380 2019 SRF Stormwater Fees Bee Branch Watershed 2038 $ 115,615 2024 SRF Stormwater Fees Bee Branch Flood Gates 2044 $ 4,695 2017A G.O.Sales Tax 20%Smart Meters 2029 2025 $ 22,892 2021A G.O.Sales Tax 20%City Hall Improvements 2032 2028 $ 55,603 2018B G.O.Sales Tax 20%Engine House #1 Renovation 2031 2026 $ 10,732 2023 G.O.Sales Tax 20% Engine House #1 Second Floor 2043 $ 25,059 2019C G.O.Sales Tax 20%City Hall Improvements 2027 2026 $ 8,846,215 Total Engineering Annual Debt Service Amount Debt Series Source Purpose Final Payment Call Date -101- Revenue 16.Riverfront Leases increased from $3,817,262 in FY 2023 to $3,897,839 in FY 2024 based on the projected revenue which is as follows: Artco Fleeting Service $ 1,200 $ 800 Dubuque By Carriage $ 3,600 $ 3,600 DRA Parking Lot Lease $ 597,905 $ 624,379 Dubuque Marina $ 34,817 $ 37,832 Dubuque Terminals Dove Harbor $ 130,010 $ 136,511 Dubuque Yacht Basin $ 201,407 $ 201,407 Flint Hill Resources $ 731,581 $ 753,528 Hodge Transit Warehouse Co $ 410,285 $ 418,000 Gavilon - Purina Drive $ 241,282 $ 248,521 Gavilon - Land By City Salt Pile $ 290,323 $ 298,939 Gavilon Dove Harbor $ 591,083 $ 608,815 Gavilon - Commercial Street $ 391,425 $ 403,168 Scales Mount dba River Cruises $ 5,000 $ 5,000 Thompson Truck and Trailer LLC $ 7,615 $ — Port of Dubuque Brewery Development $ 99,049 $ 73,877 Platinum Holdings LLC $ 80,680 $ 83,462 Total $ 3,817,262 $ 3,897,839 Riverfront Lease FY23 Budget FY24 Budget 17.Wharfage Fees on Leased Property decreased from $182,000 in FY 2023 to $153,850 in FY 2024 based on FY 2022 actual and is dependent on how much business is being conducted at the Wharf. Wharfage Fees on Leased Property FY23 Budget FY24 Budget Gavilon - Commercial Street $ 60,000 $ 82,000 Gavilon Dove Harbor $ 62,000 $ 30,450 Gavilon - Salt Site $ 30,000 $ 17,400 Flint Hill Resources $ 30,000 $ 24,000 Total $ 182,000 $ 153,850 18.Non-Riverfront Lease decreased from $248,734 in FY 2023 to $188,832 in FY 2024. Dubuque Rescue Mission $ 1 $ 1 Hawkeye Area Community Action Plan $ 31,800 $ 31,800 HHH Enterprises $ 2,309 $ 2,532 Hartig Drug $ 2,016 $ 2,077 Hartig Drug Revocable License $ 2,016 $ — 16th St. Detention Basin - Rainbo Oil $ 142,982 $ 143,228 Hilton Hotel $ 58,684 $ — Interstate Power & Light Co (Graf Farm Solar)$ 8,926 $ 9,194 Total $ 248,734 $ 188,832 Non-Riverfront Lease FY23 Budget FY24 Budget -102- 19.Federal Building Lease increased from $334,225 in FY 2023 to $338,245 in FY 2024.The detail of the lease revenue is as follows: Tenant FY23 Budget FY24 Budget Juvenile Court $ 2,295 $ 69,921 Bellstar Media $ 4,879 $ 2,363 Dubuque Area Labor Management Council $ 20,668 $ 5,025 Dubuque County Task Force $ 67,907 $ 21,292 United States Post Office $ 238,476 $ 238,476 Hillcrest $ 1,168 Total 334,225 338,245 20.Fiber Leases is increased from $14,179 in FY 2023 to $18,201 in FY 2024. The increase is due to a rack addition for the West 3rd Street water tower. 21.Telecom Leases is unchanged from $9,600 in FY 2023 to $9,600 in FY 2024. 22.Subdivision Inspection Fees increased from $70,000 in FY 2023 to $219,077 in FY 2024 by estimating inspection fees for Mozena Farms/Switch Homes ($125,000), Fox Hills apartments ($72,000), and Silver Oaks ($20,000). 23.Stormwater Penalties decreased from $28,845 in FY 2023 to $22,043 in FY 2024 based on FY 2022 actual of $17,197. 24.The FY 2024 Stormwater User Fee increased from $9.00 per SFU to $10.00 per SFU, a 11.11% increase. There was no increase between FY 2022 and FY 2023 as part of the City's coronavirus relief response. When the City Council adopted Ordinance 21-12 (passed and approved on March 7, 2012), they established that the stormwater utility fee would increase to $9.00 per month on July 1, 2016 in order to fund the operational and capital costs of the public stormwater management system, including improvements such as the Bee Branch Creek Restoration Project. But later in 2012, the Iowa General Assembly created the Flood Mitigation Program which provides funding for flood mitigation projects undertaken by approved local governments such as the City of Dubuque. Managed by the Iowa Flood Mitigation Board, the funding source established involves taking a portion of the incremental growth of State sales tax revenue collected within a city and diverting from the State General Fund to the approved city. Having updated the Drainage Basin Master Plan in the fall of 2013, which outlined the improvements associated with the 12-phase Bee Branch Watershed Flood Mitigation Project, the City was successful in securing $98.5 million in State sales tax increment funding. With the infusion of funding, the City Council adopted Ordinance 16-14 (passed and approved on March 5, 2014) establishing that the stormwater utility fee did not reach $9.00 per month until July 1, 2021, five years later than later than previously scheduled. The City has been able to provide stormwater management services within the rate structure established by Ordinance 16-14. However, due to the uncertain economic impacts of the current COVID-19 pandemic, the rate structure was reconsidered for Fiscal Year 2021. With some minor adjustments to planned Capital Improvement Program projects, reducing some budgets and delaying a few others, the City was able to delay the planned increases for a year such that the rate would not reach $9.00 per month until FY23, six years later than previously scheduled. -103- Table below compares the rates adopted in 2012, 2014, 2020, 2021, and 2022 to the rate proposed with the FY 2024 budget. FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 Ordinance 21-12 $ 9.00 $ 9.00 $ 9.00 $ 9.00 $ 9.00 $ 9.00 $ 9.00 $ 9.00 Ordinance 16-14 $ 6.81 $ 7.27 $ 7.76 $ 8.29 $ 8.85 $ 9.00 $ 9.00 $ 9.00 Ordinance 21-20 $ 8.29 $ 8.29 $ 8.29 $ 8.29 Ordinance 10-21 $ 8.85 $ 8.85 $ 8.85 Ordinance 13-22 $ 9.00 $ 9.00 Proposed FY 2024 $ 10.00 % Change From Ordinance 21-12 -24.33 % -19.22 % -13.78 % -7.89 % -7.89 % -1.67 % — % 11.11 % * The recommended rates for FY16 through FY20 reflect the rates previously established by Ordinance 16-14 following the State’s approval of $98.5 million in State Flood Mitigation state sales tax increment funds for the Bee Branch Watershed Flood Mitigation Project. Ordinance 21-12 was the ordinance adopted prior to the City receiving the Flood Mitigation grant. No increase in FY21 due to the City's coronavirus relief response. -104- ENGINEERING DEPARTMENT The engineering department promotes the health, safety, and welfare of ALL thru sound engineering principles, practices, and partnerships applied to the planning, design, maintenance, and preservation of the City's infrastructure and property. SUCCESS IS ABOUT PLANNING, PARTNERSHIPS AND PEOPLE LEADING TO OUTCOMES -105- -106- ENGINEERING DEPARTMENT FY 2022 FY 2023 FY 2024 Full-Time Equivalent 38.94 41.21 40.92 Resources FY 2022 FY 2023 FY 2024 O p e r a t i n g R e v e n u e A d m in is t r a t iv e R e c h a r g e s R o a d U s e T a x S t o r m w a t e r S a n it a r y S e w e r $0 $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 $3,000,000 $3,500,000 The Engineering Department is supported by 40.92 full-time equivalent employees, which accounts for 55.48% of the department expense as seen below. Overall, the department's expenses are expected to increase by 11.10% in FY 2024 compared to FY 2023. $3,352,040 $1,927,386 $431,860 $518,685 $625,258 $4,013,408 $2,677,661 $931,590 $400,000 $659,648 $4,302,866 $2,907,230 $854,234 $400,000 $1,192,164 FY 2022 FY 2023 FY 2024 Employee Expense Supplies and Services Machinery and Equipment Construction Fund Administrative Overhead Charges $0 $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 -107- ENGINEERING DEPARTMENT Activity: Right-of-way Management and Streets Mission & Services The department strives to manage the right of way and the streets of the city in an equitable way. This is done so the citizens can realize the greatest benefit and involves working with multiple stakeholders, both public and private. This effort strives for streets, sidewalks and other public rights of way that are safe and fully accessible by all users. Services include monitoring right-of-way, excavations, sidewalk inspections (snow removal and defects), appeals, management of compliance, utility locate services, and street, alley, sidewalk, and trails planning, inspection, and reconstruction. Right-of-way and Streets Funding Summary 10055400 800 FY 2022 Actual FY 2023 Budget FY 2024 Recomm'd Expenditures $2,587,284 $2,486,102 $2,752,294 Resources $(2,206,529)$1,446,759 $(2,035,045) Assistant City Engineer 0.40 Assistant City Engineer- Service Fund 0.60 Camera Systems Technician 0.50 Camera Systems Technician - Service Fund 0.50 City Engineer 0.40 City Engineer - Service Fund 0.10 Civil Engineer I 0.15 Civil Engineer I - Service Fund 0.75 Civil Engineer II 0.85 Civil Engineer II - Service Fund 1.15 Confidential Account Clerk- Leases 0.20 Confidential Account Clerk 0.50 Confidential Account Clerk - Service Fund 0.05 Engineering Intern- Leases 0.25 Intern Engineering- Youth Americorp 0.32 Engineering Intern - Service Fund 0.75 Engineering Assistant II 0.10 Engineering Assistant II - Service Fund 0.85 Engineering Technician - Inspection 0.60 Engineering Technician 1.30 Engineering Technician - Service Fund 3.48 Project Manager 0.35 Project Manager- Leases 0.05 Project Manager - Service Fund 0.35 ROW Technician 0.95 ROW Technician - Service Fund 0.05 Secretary - Admin 0.15 Secretary - Engineering 0.20 Secretary- Service Fund 0.20 Right-of-way and Streets Position Summary FY 2024 -108- Survey Party Chief 0.15 Survey Party Chief - Service Fund 0.30 Survey Technician 0.15 Survey Technician - Service Fund 0.30 Surveyor 0.80 Surveyor - Service Fund 0.10 Traffic Engineer 0.50 Traffic Engineer - Service Fund 0.60 Total FT Equivalent Employees 19.00 Right-of-way and Streets Position Summary FY 2024 -109- ENGINEERING DEPARTMENT Right-of-Way Management and Streets Performance Measures City Council Goal: Connected Community Performance Measure (KPI)Target FY 2021 Actual FY22 Actual FY 23 Estimated Performance Indicator 1 Activity Objective: Provide safe walking pathways throughout the City, including pedestrian access ramps. % of property notices resolved within allotted time for un-shoveled sidewalks 80%94%80%80% # of ADA curb ramps installed 100 288 110 160 2 Activity Objective: Provide complete, safe, and efficient street systems. Avg. condition rating (out of 100) of all Dubuque streets 70 73 73 73 # of vehicle crashes in the City of Dubuque N/A 1,433 1,201 1,188 N/A City Council Goal: Livable Neighborhoods & Housing 3 Activity Objective: Manage the work in right-of-way permits. # of Right of Way excavation permits/ person N/A 306 561 600 N/A Cracked and heaving sidewalk - Tripping hazard New ADA Curb Ramps -110- ENGINEERING DEPARTMENT Stormwater Management Mission & Services The mission of the City’s Stormwater Management Utility is to help protect the health of citizens and both the natural and built environment by designing, implementing, and maintaining an effective, efficient municipal stormwater management system. The City of Dubuque has the responsibility as do private property owners: manage stormwater on its property. Services include construction of new detention basins, extension of storm sewer systems, maintenance of ditches, sewers, and basins, and limiting pollutants associated with stormwater runoff. Stormwater Funding Summary 62055620 80055620 FY 2022 Actual FY 2023 Budget FY 2024 Recomm'd Expenditures $4,802,222 $5,247,779 $5,672,313 Resources $4,802,222 $5,247,779 $5,672,313 Stormwater Position Summary FY 2024 Civil Engineer II 1.00 Civil Engineer II - Service Fund 0.35 Civil Engineer I 0.05 Civil Engineer I- Service Fund 0.05 City Engineer 0.15 City Engineer - Service Fund 0.05 Engineering Technician 0.28 Traffic Engineer - Residential Parking 0.03 Engineering Technician - Service Fund 0.80 Engineering Technician - Water 0.03 Engineering Assistant II - Service Fund 0.05 Secretary - Stormwater Fund 0.05 Secretary- Service Fund 0.10 Survey Party Chief - Service Fund 0.25 Survey Technician - Service Fund 0.25 Engineering Intern 0.32 Project Manager - Service Fund 0.05 Utility Locator - Stormwater 0.50 Utility Locator - Water 0.50 Confidential Account Clerk 0.20 I&I Inspector 1.46 Confidential Account Clerk - Service Fund 0.40 Total FT Equivalent Employees 6.92 -111- Performance Measures City Council Goal: Livable Neighborhoods and Housing Performance Measure (KPI)Target FY 2021 Actual FY22 Actual FY 23 Estimated Performance Indicator 1 Activity Objective: Engineer, construct, and maintain facilities to mitigate the effects of flooding. # of phases completed in Bee Branch Watershed Flood Mitigation Project 12 4 5 5 City Council Goal: Connected Community 2 Activity Objective: Design and oversee construction of street/public ROW drainage systems to mitigate flooding and make the street available to the public during a rain event. % of storm sewer construction occurring in conjunction with street replacement 80 95 95 85 -112- ENGINEERING DEPARTMENT Sanitary Sewer Collection Mission & Services The City of Dubuque’s Sanitary Sewer Collection system delivers wastewater to the Water and Resource Recovery Center (W&RRC) where it is treated in accordance with the federal Clean Water Act before being discharged in the Mississippi River. This activity defines and implements capital improvements to improve the City's existing sanitary sewer collection infrastructure and provides direction and standards for future expansion and connections to the system. Sanitary Sewer Collection Funding Summary 61055400 80055610 FY 2022 Actual FY 2023 Budget FY 2024 Recomm'd Expenditures $244,608 $741,741 $792,022 Resources $9,939 $378,749 $394,098 Sanitary Sewer Collection Position Summary FY 2024 City Engineer 0.20 City Engineer - Service Fund 0.10 Civil Engineer I- Service Fund 0.05 Civil Engineer II - Service Fund 0.45 Civil Engineer II 0.15 Engineering Intern 0.32 Project Manager 0.10 Project Manager - Service Fund 0.10 Engineering Technician 0.38 Engineering Technician - Service Fund 1.70 Survey Party Chief - Service Fund 0.30 Survey Technician - Service Fund 0.30 Secretary 0.05 Secretary - Service Fund 0.10 Confidential Account Clerk 0.25 Confidential Account Clerk - Service Fund 0.15 Utility Locator 0.50 Total FT Equivalent Employees 5.20 Performance Measures City Council Goal: Sustainable Environment Performance Measure (KPI)Target FY 2021 Actual FY22 Actual FY 23 Estimated Performance Indicator 1 Activity Objective: Reduce inflow and infiltration (I&I) into the sanitary sewer collection system and work to eliminate the source or secure the sanitary sewer from the source. # of feet pipe lined through I&I Program 1,000 6,239 0 0 2 Activity Objective: Reconstruct Sanitary Sewer Manholes and Pipe # of brick sanitary sewer manholes replaced 15 18 15 18 -113- ENGINEERING DEPARTMENT Traffic Engineering Mission & Services This activity is responsible for overseeing the planning, inspection and daily operation of active projects for the movement of pedestrians, vehicular traffic, fiber optic expansion, street lighting, traffic signals, traffic controls, fiber optic and communications infrastructure, traffic and security cameras, traffic signage and pavement markings throughout the City and provides guidance to the Public Works Department. Other activities involve the review and recommendations for parking meter districts, residential parking districts and accessible parking spaces according to local, state and federal guidelines. This activity is highly called upon during emergency events and crises. Traffic Engineering Funding Summary FY 2022 Actual FY 2023 Budget FY 2024 Recomm'd Expenditures $199,170 $262,748 $308,125 Resources $9,129 $14,449 $50,313 Traffic Engineering Position Summary FY 2024 Secretary 0.10 Confidential Account Clerk 0.20 Utility Locator 0.50 Engineering Technician 0.03 Surveyor 0.10 Traffic Engineer 0.77 Engineering Technician- Service Fund 0.40 Traffic Engineer - Service Fund 0.10 Total FT Equivalent Employees 2.20 Performance Measures City Council Goal: Financially Responsible, High Performance Organization Performance Measure (KPI)Target FY 2021 Actual FY22 Actual FY 23 Estimated Performance Indicator 1 Activity Objective: Reduce energy and maintenance costs as well as increase safety by replacing existing street lights with LED lighting. % of city-owned lights converted to LED 100%32%51%53% City Council Goal: Connected Community 2 Activity Objective: Provide a road network that ensures a high level of safety for vehicles, cyclists, and pedestrians. % of signalized Intersections with Microwave Detection 100%29%31%34% 2 Activity Objective: Continue growth of traffic operation cameras, security cameras, and fiber and conduit. % of signalized Intersections with security cameras (88 Intersections)100%N/A 74%80% # of miles annually of conduit installed N/A 4.75 4.29 N/A -114- ENGINEERING SERVICES Facility Management Overview Engineering Services Department provides custodial and building maintenance services for City Hall, City Hall Annex, Historic Federal Building, Ruby Sutton Building, 5th Street Restrooms, Bunker Hill, Allison Henderson Park and the Dubuque Shot Tower. In total staff cleans and maintains over 150,000 square feet of public and office space. Responsibilities include routine custodial services, maintenance, repairs, and monitoring or HVAC systems. Staff schedules routine maintenance on our generators, elevators, HVAC equipment, fire alarm and sprinkler systems, backflow valves, and security systems. Facility Management Funding Summary FY 2022 Actual FY 2023 Budget FY 2024 Recomm'd Expenditures $1,020,039 $1,358,351 $1,437,553 Resources $321,394 $334,351 $338,564 Facility Management Position Summary FY 2024 Facilities Manager 1.00 Maintenance Worker 1.00 Secretary 0.05 Confidential Account Clerk 0.05 Architectural Intern 0.50 Custodian - City Hall Annex/Housing 0.50 Custodian - Federal Building 2.50 Custodian - Multicultural Family Center 1.00 Custodian - City Hall 1.00 Total Full-Time Equivalent Employees 7.60 Performance Measures City Council Goal: Financially Responsible, High Performance Organization Performance Measure (KPI)Target FY 2021 Actual FY22 Actual FY 23 Estimated Performance Indicator 1 Activity Objective: Continue implementation of the ADA Transition Plan # of accessibility improvement projects in public facilities >8 0 4 5 -115- 100 - General 4A - Charges for Services 41230 - Electrical Permits 0 0 0 0 41280 - Mechanical Permits 0 0 0 0 41330 - Sidewalk Permits (13,504) (9,429) (12,500) (4,795) 41335 - Dumpster Permits (2,660) (3,100) (3,000) (1,180) 41340 - Street Excavation (16,409) (15,450) (18,000) (8,603) 41360 - Public Right-of-Way Permit 0 0 0 0 41725 - Subdivision Inspection (41,893) (202,365) (70,000) (219,077) 41900 - Miscellaneous Licenses (191) (5,104) (565) (2,259) 43100 - Leases - Building/Land (350,775) (321,075) (336,241) (340,322) 43208 - Lease - Sidewalk Cafe (600) (1,400) (1,600) (600) 45500 - Miscellaneous Chg for Svcs (250) (740) (400) (195) 47100 - Reimbursements (29,315) (8,541) (5,126) (2,566) 47150 - Refunds 0 (1,550) 0 0 47200 - Insurance Settlements 0 (550) 0 0 47700 - District Court Fines (85) 0 0 0 47820 - Specialized Services 0 0 0 0 4A - Charges for Services Total (455,681) (569,304) (447,432) (579,597) 4B - Grants/Contrib 47050 - Contrib - Private Sources 0 0 0 0 4B - Grants/Contrib Total 0 0 0 0 4M - Gain on Disposal 48000 - Sale of Real Property (32,197) (149,442) 0 0 4M - Gain on Disposal Total (32,197) (149,442) 0 0 4N - Transfers 49600 - Transfer in Water Op (43,750) (44,911) (49,107) (221,079) 49610 - Transfer In Sanitary Op (273,439) (280,692) (306,919) (328,840) 49620 - Transfer in Storm Op (82,032) (84,208) (92,075) (186,549) 4N - Transfers Total (399,221) (409,811) (448,101) (736,468) 810 - Engineering Service 4A - Charges for Services 47820 - Specialized Services (1,646,434)(1,700,641)(1,701,847)(1,877,496) 4A - Charges for Services Total (1,646,434)(1,700,641)(1,701,847)(1,877,496) 200 - Debt Service 4N - Transfers 49100 - Transfer In General Fund (543,375)(7,125)(6,731)(6,878) 49110 - Transfer in Road Use Tax (23,876)(25,348)(26,060)(26,633) 49126 - Transfer in GDTIF (339,900)0 0 0 49301 - Transfer in Street Const (201,915)(197,230)(202,862)(195,247) 49303 - Transfer in Sales Tax Inc (2,554,104)(2,554,296)(4,681,919)(5,640,609) 49304 - Transfer in Sales Tax 20%(126,890)(110,324)(128,666)(138,006) 4N - Transfers Total (3,790,060)(2,894,323)(5,046,238)(6,007,373) 4O - Eliminated for GW 48200 - Proceeds from GO Debt (1,438,998)0 0 0 48205 - Bond Discount/Premium (28,484)0 0 0 4O - Eliminated for GW Total (1,467,482)0 0 0 620 - Stormwater Operating 4A - Charges for Services 41400 - Misc Permits (16,647)(8,765)(16,647)(3,530) Recommended Operating Revenue Budget - Department Total 55 - ENGINEERING Fund/Account/Account Title FY21 Actual Revenue FY22 Actual Revenue FY23 Adopted Budget FY24 Recomm'd Budget -116- 45235 - Stormwater User Fee (4,902,685)(5,252,450)(5,318,412)(5,651,375) 45236 - Stormwater Half Rate (40,294)(42,022)(34,903)(43,026) 45237 - Stormwater Tax Exempt 0 0 0 0 45238 - Stormwater Farm 0 0 0 0 45300 - Forfeitures/Penalties (791)(17,197)(28,845)(22,043) 45500 - Miscellaneous Chg for Svcs 0 0 0 0 47100 - Reimbursements (1,947)(27)(1,948)(1,910) 4A - Charges for Services Total (4,962,365)(5,320,461)(5,400,755)(5,721,884) 4B - Grants/Contrib 44000 - Federal Grants (8,139)(83,088)(8,139)(8,139) 44400 - State Grants 0 0 0 0 4B - Grants/Contrib Total (8,139)(83,088)(8,139)(8,139) 4K - Unrest Invest Earn 43000 - Interest (37,191)(14,729)(37,191)(37,191) 4K - Unrest Invest Earn Total (37,191)(14,729)(37,191)(37,191) 4N - Transfers 49102 - Transfer in DRA Distribution (177,978)(178,000)(181,115)0 49179 - Transfer in Special Assessment (78)(84)0 0 49304 - Transfer in Sales Tax 20%(313,707)(261,096)(255,390)(442,290) 4N - Transfers Total (491,763)(439,180)(436,505)(442,290) 4O - Eliminated for GW 47115 - Sales Tax Collection (170,841)(180,770)(185,472)(193,016) 48200 - Proceeds from GO Debt (1,192,551)0 0 0 48205 - Bond Discount/Premium (29,405)0 0 0 4O - Eliminated for GW Total (1,392,797)(180,770)(185,472)(193,016) 600 - Water Operating 4A - Charges for Services 41725 - Subdivision Inspection 0 0 0 0 4A - Charges for Services Total 0 0 0 0 610 - Sanitary Sewer Operating 4A - Charges for Services 41725 - Subdivision Inspection 0 0 0 0 45400 - Connect Fees -38692 -16259 0 -31768 47100 - Reimbursements (10,943)(5,125)(10,943)(10,250) 4A - Charges for Services Total (49,635)(21,384)(10,943)(42,018) ENGINEERING- Total (14,732,964)(11,783,134)(13,722,623)(15,645,472) Recommended Operating Revenue Budget - Department Total 55 - ENGINEERING Fund/Account/Account Title FY21 Actual Revenue FY22 Actual Revenue FY23 Adopted Budget FY24 Recomm'd Budget -117- 6A - Salaries & Wages 100 - General 60100 - Salaries-Regular Full Time 851,172 1,045,799 1,163,203 1,248,595 60200 - Salaries - Regular Part Time 4,967 8,468 0 0 60300 - Hourly Wages - Temp/Seasonal 15,042 8,350 48,770 36,355 60400 - Overtime 10,885 22,334 18,390 18,390 60410 - Overtime - Holiday 98 0 0 0 60620 - Special Pay - Holiday 0 0 0 0 60630 - Special Pay Sick Lv Payout Ret 11,985 11,985 11,748 11,748 60635 - Special Pay Sick Lv Payout 50%12,169 11,636 12,169 12,169 60640 - Special Pay - Vacation Payout 1,627 0 0 0 60710 - Special Pay - Parental Leave 11,480 5,934 0 0 60720 - Spec Pay - Meals No Overnight 14 173 0 91 60730 - Spec Pay - Safety Equipment 219 736 500 3,100 60760 - Spec Pay - Moving Allowance 0 300 0 0 110 - Road Use Tax 60100 - Salaries-Regular Full Time 510 0 0 0 60400 - Overtime 765 0 0 0 600 - Water Operating 60100 - Salaries-Regular Full Time 18,990 18,256 30,386 33,237 60200 - Salaries - Regular Part Time 7,906 8,468 0 0 60300 - Hourly Wages - Temp/Seasonal 0 0 0 0 60400 - Overtime 4,625 4,174 0 0 60410 - Overtime - Holiday 20 0 0 0 610 - Sanitary Sewer Operating 60100 - Salaries-Regular Full Time 48,530 73,446 112,096 135,984 60200 - Salaries - Regular Part Time 7,905 8,468 0 0 60300 - Hourly Wages - Temp/Seasonal 3,632 1,745 2,593 11,949 60400 - Overtime 5,088 6,584 0 0 60410 - Overtime - Holiday 20 0 0 0 60630 - Special Pay Sick Lv Payout Ret 0 7,884 0 0 60640 - Special Pay - Vacation Payout 0 881 0 0 60730 - Spec Pay - Safety Equipment 0 0 0 2,600 60760 - Spec Pay - Moving Allowance 0 0 0 0 620 - Stormwater Operating 60100 - Salaries-Regular Full Time 148,733 127,917 202,547 203,804 60200 - Salaries - Regular Part Time 31,957 29,508 79,078 82,714 60300 - Hourly Wages - Temp/Seasonal 0 0 2,593 11,949 60400 - Overtime 4,984 5,849 0 0 60410 - Overtime - Holiday 20 0 0 0 60620 - Special Pay - Holiday 0 0 0 0 60630 - Special Pay Sick Lv Payout Ret 0 7,884 0 0 60635 - Special Pay Sick Lv Payout 50%3,911 3,188 3,911 4,219 60640 - Special Pay - Vacation Payout 0 881 0 0 60710 - Special Pay - Parental Leave 0 0 0 0 60720 - Spec Pay - Meals No Overnight 0 20 0 20 60730 - Spec Pay - Safety Equipment 0 0 0 2,600 650 - Parking Operating 60100 - Salaries-Regular Full Time 16 49 2,204 2,422 60400 - Overtime 0 0 0 0 810 - Engineering Service Recommended Operating Expenditure Budget - Department Total 55 - ENGINEERING Fund/Account/Account Title FY21 Actual Expense FY22 Actual Expense FY23 Adopted Budget FY 24 Recomm'd Budget -118- 60100 - Salaries-Regular Full Time 1,163,568 1,134,853 1,203,739 1,317,491 60200 - Salaries - Regular Part Time 0 0 0 0 60300 - Hourly Wages - Temp/Seasonal 31,006 23,030 32,354 25,055 60400 - Overtime 27,356 53,376 54,250 54,250 60410 - Overtime - Holiday 771 0 0 0 60630 - Special Pay Sick Lv Payout Ret 0 15,768 0 0 60640 - Special Pay - Vacation Payout 0 1,763 0 0 60710 - Special Pay - Parental Leave 0 10,088 0 0 6A - Salaries & Wages Total 2,429,973 2,659,799 2,980,531 3,218,742 6B - Employee Benefits 100 - General 61100 - FICA - City Contribution 67,000 81,703 95,955 101,201 61300 - IPERS - City Contribution 83,955 102,711 116,146 122,627 61510 - Health Insurance 145,949 355,540 221,045 223,155 61540 - Life Insurance 648 689 774 781 61600 - Workers' Compensation 43,176 34,929 39,370 21,640 61992 - Physicals 138 1,369 1,611 1,599 110 - Road Use Tax 61100 - FICA - City Contribution 92 0 0 0 61300 - IPERS - City Contribution 120 0 0 0 61510 - Health Insurance 332 0 0 0 61540 - Life Insurance 1 0 0 0 600 - Water Operating 61100 - FICA - City Contribution 2,235 2,219 2,324 2,542 61300 - IPERS - City Contribution 2,978 2,917 2,869 3,137 61510 - Health Insurance 3,074 3,258 6,816 6,914 61540 - Life Insurance 18 14 26 23 61600 - Workers' Compensation 460 351 530 679 610 - Sanitary Sewer Operating 61100 - FICA - City Contribution 4,710 7,211 8,392 10,825 61300 - IPERS - City Contribution 6,133 8,519 10,868 13,360 61510 - Health Insurance 7,553 6,946 17,419 20,202 61540 - Life Insurance 44 50 67 74 61600 - Workers' Compensation 4,949 8,223 8,214 2,563 620 - Stormwater Operating 61100 - FICA - City Contribution 13,497 12,464 22,040 22,802 61300 - IPERS - City Contribution 17,527 15,413 26,830 27,765 61510 - Health Insurance 9,357 14,522 25,272 24,027 61540 - Life Insurance 113 83 107 101 61600 - Workers' Compensation 8,196 12,291 12,196 6,216 61700 - Unemployment Compensation 1,972 2,465 986 2,465 61992 - Physicals 0 144 732 364 650 - Parking Operating 61100 - FICA - City Contribution 1 4 168 185 61300 - IPERS - City Contribution 2 5 208 228 61510 - Health Insurance 167 36 403 403 61540 - Life Insurance 0 0 1 1 61600 - Workers' Compensation 0 4 4 4 810 - Engineering Service 61100 - FICA - City Contribution 87,957 89,467 98,716 106,857 61300 - IPERS - City Contribution 114,649 115,296 118,753 129,492 Recommended Operating Expenditure Budget - Department Total 55 - ENGINEERING Fund/Account/Account Title FY21 Actual Expense FY22 Actual Expense FY23 Adopted Budget FY 24 Recomm'd Budget -119- 61510 - Health Insurance 49,444 (187,340)193,358 202,753 61540 - Life Insurance 826 737 677 707 61600 - Workers' Compensation 0 0 0 28,432 61992 - Physicals 0 0 0 0 6B - Employee Benefits Total 677,271 692,241 1,032,877 1,084,124 6C - Staff Development 100 - General 62100 - Association Dues 2,732 4,978 9,095 7,355 62200 - Subscriptions 3,742 4,140 9,673 8,864 62325 - Mileage 918 975 1,012 1,567 62400 - Meetings & Conferences 1,201 10,688 29,565 26,876 62500 - Education Reimbursement 5,304 6,022 45,867 39,140 110 - Road Use Tax 62100 - Association Dues 609 199 1,185 1,804 62200 - Subscriptions 0 17 510 600 62325 - Mileage 0 0 0 0 62400 - Meetings & Conferences 2,151 6,483 2,551 5,865 62500 - Education Reimbursement 79 2,400 4,794 11,784 600 - Water Operating 62100 - Association Dues 0 0 0 30 62200 - Subscriptions 0 0 0 25 62500 - Education Reimbursement 0 0 0 250 610 - Sanitary Sewer Operating 62100 - Association Dues 0 0 350 475 62200 - Subscriptions 0 0 300 375 62325 - Mileage 0 0 0 0 62400 - Meetings & Conferences 0 0 1,714 3,255 62500 - Education Reimbursement 120 0 1,745 4,800 620 - Stormwater Operating 62100 - Association Dues 557 755 884 1,144 62200 - Subscriptions 34 205 528 641 62325 - Mileage 0 0 80 80 62400 - Meetings & Conferences 0 1,413 4,035 6,796 62500 - Education Reimbursement 1,254 912 6,918 10,500 6C - Staff Development Total 18,701 39,188 120,806 132,226 6D - Repair/Maint/Util 100 - General 63100 - Building Maintenance 70,986 144,588 157,754 177,620 63312 - Vehicle Ops - Gasoline 11,361 17,192 9,834 29,307 63320 - Vehicle Repair - Internal 12,318 15,488 24,798 15,797 63321 - Vehicle Repair - Outsourced 232 0 1,386 0 63322 - Vehicle Repair - Accident 0 0 0 0 63400 - Equipment Maint/Repair 12,658 12,021 41,158 41,672 63710 - Electricity 127,286 148,510 206,097 238,950 63711 - Natural Gas 32,909 60,722 57,684 76,623 63730 - Telecommunications 23,700 20,186 32,092 28,132 63740 - Water 84 90 809 895 63742 - Stormwater 52,909 10,729 69,453 11,899 110 - Road Use Tax 63400 - Equipment Maint/Repair 255 2,500 24,000 2,000 63730 - Telecommunications 1,272 1,571 1,896 2,496 Recommended Operating Expenditure Budget - Department Total 55 - ENGINEERING Fund/Account/Account Title FY21 Actual Expense FY22 Actual Expense FY23 Adopted Budget FY 24 Recomm'd Budget -120- 600 - Water Operating 63312 - Vehicle Ops - Gasoline 0 0 0 0 63320 - Vehicle Repair - Internal 0 0 0 0 63321 - Vehicle Repair - Outsourced 0 0 0 0 63730 - Telecommunications 0 0 0 0 610 - Sanitary Sewer Operating 63312 - Vehicle Ops - Gasoline 0 0 623 623 63320 - Vehicle Repair - Internal 0 0 0 0 63400 - Equipment Maint/Repair 6,462 16,688 6,462 13,104 63730 - Telecommunications 1,705 1,250 2,160 3,120 620 - Stormwater Operating 63100 - Building Maintenance 11,447 348 21,662 21,912 63312 - Vehicle Ops - Gasoline 0 0 446 446 63320 - Vehicle Repair - Internal 0 0 22 0 63400 - Equipment Maint/Repair 0 0 15,220 15,333 63710 - Electricity 914 3,113 43,501 22,201 63730 - Telecommunications 2,023 1,714 2,023 1,248 63780 - Street Lights 1,984 1,860 2,032 2,032 810 - Engineering Service 63730 - Telecommunications 0 0 0 0 6D - Repair/Maint/Util Total 370,506 458,570 721,112 705,410 6E - Contractual Svcs 100 - General 64004 - Internal Service Charge 0 0 0 0 64010 - Accounting & Auditing 0 0 0 0 64020 - Advertising 2,953 1,009 2,176 1,009 64030 - Outsourced Labor 0 4,530 0 0 64040 - Collections 35 10 18 10 64050 - Recording Fees 739 905 872 905 64062 - Refunds 0 20 0 20 64063 - Inspection Reimbursement 3,293 0 36,000 66,000 64070 - Engineering - Outsourced 0 24,490 13,128 13,128 64075 - Engineering - Internal (21,142)0 21,000 21,000 64080 - Insurance - Property 59,399 61,982 74,221 62,070 64081 - Insurance - Liability 17,423 26,239 12,747 33,721 64083 - Insurance - Other 0 0 6,230 0 64110 - Legal 567 865 666 666 64130 - Payments to Other Agencies 20,000 20,000 30,650 30,650 64135 - Grants 0 1,367 5,000 5,000 64140 - Printing 681 1,327 994 1,416 64145 - Copying 1,686 3,372 3,874 3,913 64160 - Rental - Land/Bldgs/Parking 8,424 8,890 14,868 23,668 64175 - Landfill Fees 717 0 2,000 1,000 64182 - Property Tax 97,238 99,186 103,867 146,023 64185 - License/Permit/Fees 0 0 650 650 64190 - Technology Services 43,312 58,676 108,942 120,756 64191 - IT Recharges 0 0 0 31,550 64820 - One Call 0 157 0 157 64825 - Fire Suppression 11,694 8,628 16,424 13,518 64850 - Consulting Engineers 0 0 0 0 64860 - Speakers 120 0 1,500 1,500 Recommended Operating Expenditure Budget - Department Total 55 - ENGINEERING Fund/Account/Account Title FY21 Actual Expense FY22 Actual Expense FY23 Adopted Budget FY 24 Recomm'd Budget -121- 64865 - Elevator Service 3,060 11,860 13,889 23,800 64870 - HVAC Services 0 0 19,800 19,800 64880 - Custodial Services 0 0 0 0 64900 - Other Professional Service 19,778 22,552 15,016 15,016 64975 - Equip Maint Cont 3,661 25,646 31,848 32,938 64980 - Technology Equip Maint Cont 31,119 70,378 66,575 36,335 64987 - Lawn Care Contract 0 0 0 0 64990 - Other Contractual Service 1,335 0 1,335 1,335 110 - Road Use Tax 64080 - Insurance - Property 14,928 7,600 8,595 9,047 64185 - License/Permit/Fees 0 0 0 0 64190 - Technology Services 49,186 35,586 114,365 120,475 64980 - Technology Equip Maint Cont 24,750 1,781 36,500 40,000 200 - Debt Service 64110 - Legal 0 0 0 0 64900 - Other Professional Service 3,816 0 0 0 600 - Water Operating 64020 - Advertising 0 188 0 188 64160 - Rental - Land/Bldgs/Parking 0 0 0 0 64820 - One Call 0 157 0 157 610 - Sanitary Sewer Operating 64020 - Advertising 470 1,558 470 1,558 64030 - Outsourced Labor 0 1,184 0 0 64062 - Refunds 0 0 0 0 64081 - Insurance - Liability 3,686 1,907 2,231 0 64110 - Legal 332 667 666 666 64135 - Grants 9,949 6,544 10,000 10,000 64145 - Copying 0 260 0 260 64190 - Technology Services 6,007 19,334 18,124 25,619 64820 - One Call 3,879 3,879 5,000 500 64825 - Fire Suppression 0 0 30 30 64900 - Other Professional Service 200 300 424 424 620 - Stormwater Operating 64010 - Accounting & Auditing 0 0 0 0 64020 - Advertising 3,043 3,514 3,043 3,514 64040 - Collections 473 596 2,149 596 64045 - Bad Debt Expense 0 0 0 0 64062 - Refunds 1,228 1,170 1,228 1,170 64070 - Engineering - Outsourced 0 0 2,583 2,583 64080 - Insurance - Property 152 1,217 1,332 1,296 64081 - Insurance - Liability 0 0 0 0 64110 - Legal 4,923 22,606 995 666 64130 - Payments to Other Agencies 81,578 116,850 116,850 122,766 64135 - Grants 408,368 440,096 446,505 478,843 64140 - Printing 0 0 131 131 64145 - Copying 74 293 910 910 64150 - Rental - Equipment 560 100 571 571 64160 - Rental - Land/Bldgs/Parking 440 440 1,488 1,488 64180 - Sales Tax Expense 170,932 180,075 185,472 194,745 64185 - License/Permit/Fees 0 0 0 0 64190 - Technology Services 18,929 10,766 22,930 21,761 Recommended Operating Expenditure Budget - Department Total 55 - ENGINEERING Fund/Account/Account Title FY21 Actual Expense FY22 Actual Expense FY23 Adopted Budget FY 24 Recomm'd Budget -122- 64820 - One Call 3,879 3,879 5,000 5,000 64825 - Fire Suppression 0 0 20 20 64850 - Consulting Engineers 0 0 0 0 64860 - Speakers 0 500 0 7,000 64900 - Other Professional Service 29,225 69,825 151,842 157,842 64980 - Technology Equip Maint Cont 0 3,444 5,394 5,394 64987 - Lawn Care Contract 8,190 9,300 15,000 15,000 650 - Parking Operating 64020 - Advertising 0 0 98 0 810 - Engineering Service 64004 - Internal Service Charge 0 0 0 0 64075 - Engineering - Internal 324,814 0 0 0 64081 - Insurance - Liability 0 0 0 35,830 64190 - Technology Services 0 0 0 0 6E - Contractual Svcs Total 1,480,102 1,397,701 1,764,236 1,973,604 6F - Commodities 100 - General 65026 - Speciality Supplies 0 328 0 328 65040 - Small Tools & Equipment 4,340 4,563 28,520 41,986 65045 - Technology Equipment 1,269 24,938 32,480 27,584 65050 - Other Equipment 0 8,167 0 0 65054 - Safety Equipment 0 90 0 0 65055 - Traffic St Light Comp/Equip 28 0 235 0 65060 - Office Supplies 5,367 4,996 7,165 7,260 65070 - Operating Supplies 2,618 2,648 2,636 2,648 65080 - Postage/Shipping 1,815 1,038 2,794 2,794 65100 - Safety Supplies 0 397 195 397 65110 - Signage 0 0 0 0 65925 - Uniform Purchase 11 1,044 418 500 65930 - Flags 0 0 0 0 65935 - Employee Recognition 60 0 500 500 65940 - Gift Cards 320 0 0 0 65960 - Repair Parts 0 269 0 269 65965 - Janitorial 9,626 11,704 21,487 21,425 65980 - Construction Supplies 0 133 0 133 110 - Road Use Tax 65040 - Small Tools & Equipment 0 4,362 0 2,000 65045 - Technology Equipment 80,133 121,460 255,200 306,750 65054 - Safety Equipment 0 0 1,000 0 65055 - Traffic St Light Comp/Equip 97,928 106,793 22,300 9,500 65056 - Traffic Security Cameras 16,818 44,054 176,200 196,200 65060 - Office Supplies 0 0 0 0 65070 - Operating Supplies 0 36 0 36 65080 - Postage/Shipping 0 0 0 0 600 - Water Operating 65040 - Small Tools & Equipment 0 0 0 3,000 610 - Sanitary Sewer Operating 65040 - Small Tools & Equipment 3,001 0 0 4,500 65045 - Technology Equipment 134 4,274 2,150 2,083 65050 - Other Equipment 0 16,148 6,000 6,000 65054 - Safety Equipment 584 6,490 5,400 3,250 Recommended Operating Expenditure Budget - Department Total 55 - ENGINEERING Fund/Account/Account Title FY21 Actual Expense FY22 Actual Expense FY23 Adopted Budget FY 24 Recomm'd Budget -123- 65060 - Office Supplies 15 0 0 0 65080 - Postage/Shipping 0 0 0 0 620 - Stormwater Operating 65025 - Program Materials 0 0 2,200 2,200 65040 - Small Tools & Equipment 3,001 0 0 4,500 65045 - Technology Equipment 2,461 3,059 95,950 3,183 65050 - Other Equipment 631 595 1,800 3,800 65054 - Safety Equipment 445 633 7,500 7,500 65060 - Office Supplies 0 0 0 0 65070 - Operating Supplies 1,191 411 3,296 1,514 65080 - Postage/Shipping 0 0 0 0 6F - Commodities Total 231,796 368,626 675,426 661,840 6G - Capital Outlay 100 - General 67100 - Vehicles 33,098 176 0 35,000 67210 - Furniture/Fixtures 6,008 3,412 2,000 2,000 67250 - Office Equipment 811 223 2,719 900 67400 - Right-of-Way 0 250 0 0 67500 - Buildings 5,056 30,375 40,000 40,000 110 - Road Use Tax 67100 - Vehicles 0 0 0 0 67250 - Office Equipment 121 0 0 0 610 - Sanitary Sewer Operating 67100 - Vehicles 0 0 50,000 35,000 67250 - Office Equipment 0 0 0 0 67990 - Other Capital Outlay 9,430 29,352 100,437 110,484 620 - Stormwater Operating 67100 - Vehicles 0 0 50,000 0 67250 - Office Equipment 0 0 219 0 67990 - Other Capital Outlay 30,694 31,372 80,000 65,000 6G - Capital Outlay Total 85,218 95,160 325,375 288,384 6H - Debt Service 200 - Debt Service 68010 - Principal Payment 3,736,781 1,441,234 3,608,723 4,653,518 68020 - Interest Payments 1,511,705 1,453,090 1,437,515 1,353,855 68980 - Financial Consultant 2,595 0 0 0 68990 - Paying Agent Fees 481 0 0 0 620 - Stormwater Operating 68010 - Principal Payment 3,254,684 2,107,547 2,156,422 2,137,682 68020 - Interest Payments 625,429 621,137 696,458 701,160 68980 - Financial Consultant 2,151 0 2,151 0 68990 - Paying Agent Fees 145 0 145 0 6H - Debt Service Total 9,133,970 5,623,009 7,901,414 8,846,215 6I - Transfers 620 - Stormwater Operating 69100 - Transfers Out To General Fund 608,650 625,258 659,648 1,192,164 69621 - Transfers Out to Storm Cap 880,000 518,685 400,000 400,000 6I - Transfers Total 1,488,650 1,143,943 1,059,648 1,592,164 ENGINEERING - Total 15,916,185 12,478,237 16,581,425 18,502,709 Recommended Operating Expenditure Budget - Department Total 55 - ENGINEERING Fund/Account/Account Title FY21 Actual Expense FY22 Actual Expense FY23 Adopted Budget FY 24 Recomm'd Budget -124- 5501 - Administration 100 - General 6A - Salaries & Wages 195,672 222,167 207,256 6B - Employee Benefits 243,615 58,857 54,805 6C - Staff Development 11,552 22,856 24,425 6D - Repair/Maint/Util 5,010 8,368 5,131 6E - Contractual Svcs 72,378 76,452 88,375 6F - Commodities 6,373 4,527 6,079 6G - Capital Outlay 13,083 3,500 1,900 610 - Sanitary Sewer Operating 6A - Salaries & Wages 99,010 114,689 — 6B - Employee Benefits 30,949 44,960 45,723 6C - Staff Development —4,109 2,400 6D - Repair/Maint/Util 17,938 9,245 — 6E - Contractual Svcs 35,633 36,945 10,000 6F - Commodities 26,911 13,550 6,233 6G - Capital Outlay 29,352 150,437 0 810 - Engineering Service 6A - Salaries & Wages 1,238,872 135,216 141,349 6B - Employee Benefits 1,333 37,253 41,284 6E - Contractual Svcs 0 0 0 5501 - Administration Total 2,027,681 943,131 634,960 5502 - Project Engineering 100 - General 6A - Salaries & Wages 438,151 478,250 512,447 6B - Employee Benefits 129,507 182,223 171,603 6C - Staff Development 11,794 53,428 40,984 6D - Repair/Maint/Util 39,203 35,119 53,388 6E - Contractual Svcs 101,622 112,403 143,844 6F - Commodities 30,054 60,005 63,855 6G - Capital Outlay 1,796 1,219 1,000 110 - Road Use Tax 6C - Staff Development 9,099 9,040 20,053 6D - Repair/Maint/Util 1,103 23,272 1,872 6E - Contractual Svcs 44,966 158,944 169,042 6F - Commodities 258,179 448,550 508,486 6G - Capital Outlay 0 0 0 600 - Water Operating 6A - Salaries & Wages 30,898 30,386 33,237 6B - Employee Benefits 8,759 12,565 13,295 6C - Staff Development 0 0 305 6D - Repair/Maint/Util 0 0 0 6E - Contractual Svcs 344 0 345 6F - Commodities 0 0 3,000 610 - Sanitary Sewer Operating 6A - Salaries & Wages 0 0 150,533 6B - Employee Benefits 0 0 1,301 6C - Staff Development 0 0 6,505 Recommended Expenditure Budget Report by Activity & Funding Source 55 - ENGINEERING Fund/Activity FY22 Actual Expense FY23 Adopted Budget FY24 Recomm'd Budget -125- 6D - Repair/Maint/Util 0 0 16,847 6E - Contractual Svcs 0 0 29,057 6F - Commodities 0 0 9,600 6G - Capital Outlay 0 0 145,484 810 - Engineering Service 6A - Salaries & Wages 6 1,155,127 1,255,447 6B - Employee Benefits 16,828 374,251 426,957 6D - Repair/Maint/Util 0 0 0 6E - Contractual Svcs 0 0 35,830 5502 - Project Engineering Total 1,122,310 3,134,782 3,814,317 5503 - Subdivision Inspection 100 - General 6A - Salaries & Wages 19,081 27,076 44,445 6B - Employee Benefits 3,656 10,503 16,282 6C - Staff Development 0 9 0 6E - Contractual Svcs 22,998 57,063 87,000 5503 - Subdivision Inspection Total 45,735 94,651 147,727 5504 - Traffic Engineering 100 - General 6A - Salaries & Wages 117,507 121,862 123,028 6B - Employee Benefits 41,055 45,215 44,152 6C - Staff Development 3,061 8,063 8,673 6D - Repair/Maint/Util 1,147 721 2,610 6E - Contractual Svcs 34,342 76,653 80,817 6F - Commodities 32 285 32 6G - Capital Outlay 333 0 0 110 - Road Use Tax 6D - Repair/Maint/Util 2,968 2,624 2,624 6E - Contractual Svcs 0 516 480 6F - Commodities 18,526 6,150 6,000 6G - Capital Outlay 0 0 0 5504 - Traffic Engineering Total 218,970 262,089 268,416 5505 - Facilities Management 100 - General 6A - Salaries & Wages 325,900 384,017 418,172 6B - Employee Benefits 155,981 172,738 177,471 6C - Staff Development 397 10,856 9,720 6D - Repair/Maint/Util 371,244 539,642 537,093 6E - Contractual Svcs 138,629 198,909 184,239 6F - Commodities 23,854 31,613 35,858 6G - Capital Outlay 19,225 40,000 75,000 5505 - Facilities Management Total 1,035,229 1,377,775 1,437,553 5506 - Leases 100 - General 6A - Salaries & Wages 19,404 21,408 25,100 6B - Employee Benefits 3,128 5,365 6,690 6D - Repair/Maint/Util 12,923 17,215 22,673 6E - Contractual Svcs 82,119 82,810 123,279 6F - Commodities 0 0 0 Recommended Expenditure Budget Report by Activity & Funding Source 55 - ENGINEERING Fund/Activity FY22 Actual Expense FY23 Adopted Budget FY24 Recomm'd Budget -126- 5506 - Leases Total 117,574 126,798 177,742 5507 - Stormwater Operations 620 - Stormwater Operating 6A - Salaries & Wages 137,077 209,051 168,550 6B - Employee Benefits 43,319 71,470 49,454 6C - Staff Development 3,286 12,445 19,161 6D - Repair/Maint/Util 6,596 48,600 26,888 6E - Contractual Svcs 849,474 905,132 959,985 6F - Commodities 4,319 108,586 22,319 6G - Capital Outlay 30,497 100,219 50,000 6H - Debt Service 2,728,685 2,855,176 2,838,842 6I - Transfers 1,143,943 1,059,648 1,592,164 5507 - Stormwater Operations Total 4,947,195 5,370,327 5,727,363 5508 - Stormwater I&I Prevention 620 - Stormwater Operating 6A - Salaries & Wages 34,453 79,078 136,756 6B - Employee Benefits 12,725 16,693 34,286 6D - Repair/Maint/Util 341 1,680 1,658 6E - Contractual Svcs 440 9,988 9,988 6F - Commodities 378 110 378 6G - Capital Outlay 0 0 0 5508 - Stormwater I&I Prevention Total 48,337 107,549 183,066 5509 - Stormwater Ditch Remediation 620 - Stormwater Operating 6A - Salaries & Wages 400 0 0 6B - Employee Benefits 126 0 0 6D - Repair/Maint/Util 0 7,847 7,847 6E - Contractual Svcs 0 6,283 4,283 6G - Capital Outlay 0 15,000 15,000 5509 - Stormwater Ditch Remediation Total 525 29,130 27,130 5510 - Streambank Rehab Assistance 620 - Stormwater Operating 6E - Contractual Svcs 0 0 5,000 5510 - Streambank Rehab Assistance Total 0 0 5,000 5511 - Detention Basin Maintenance 620 - Stormwater Operating 6A - Salaries & Wages 3,319 0 0 6B - Employee Benefits 1,212 0 0 6D - Repair/Maint/Util 98 26,779 26,779 6E - Contractual Svcs 14,755 42,040 42,040 6F - Commodities 0 2,050 0 6G - Capital Outlay 875 15,000 0 5511 - Detention Basin Maintenance Total 20,258 85,869 68,819 5512 - Stormwater Inspection & Clean 620 - Stormwater Operating 6D - Repair/Maint/Util 0 0 0 5512 - Stormwater Inspection & Clean Total 0 0 0 5513 - Residential Parking 650 - Parking Operating Recommended Expenditure Budget Report by Activity & Funding Source 55 - ENGINEERING Fund/Activity FY22 Actual Expense FY23 Adopted Budget FY24 Recomm'd Budget -127- 6A - Salaries & Wages 49 2,204 2,422 6B - Employee Benefits 49 784 821 6E - Contractual Svcs 0 98 0 5513 - Residential Parking Total 98 3,086 3,243 5514 - Floodwall Operations 100 - General 6A - Salaries & Wages 0 0 0 6B - Employee Benefits 0 0 0 6E - Contractual Svcs 0 0 0 5514 - Floodwall Operations Total 0 0 0 5515 - Snow Plowing 110 - Road Use Tax 6A - Salaries & Wages 0 0 0 6B - Employee Benefits 0 0 0 6E - Contractual Svcs 0 0 0 5515 - Snow Plowing Total 0 0 0 5516 - Engineering Fats Oils Grease 610 - Sanitary Sewer Operating 6F - Commodities 0 0 0 5516 - Engineering Fats Oils Grease Total 0 0 0 5580 - Debt Service 200 - Debt Service 6E - Contractual Svcs 0 0 0 6H - Debt Service 2,894,324 5,046,238 6,007,373 5580 - Debt Service Total 2,894,324 5,046,238 6,007,373 5599 - Pcard Clearing 100 - General 6F - Commodities 0 0 0 5599 - Pcard Clearing Total 0 0 0 ENGINEERING TOTAL 12,478,237 16,581,425 18,502,709 Recommended Expenditure Budget Report by Activity & Funding Source 55 - ENGINEERING Fund/Activity FY22 Actual Expense FY23 Adopted Budget FY24 Recomm'd Budget -128- 61010 Full Time Employee Expense 100 5800 GE-34 FACILITIES MANAGER 1.00 $ 80,534 1.00 $ 67,806 1.00 $ 74,820 100 3420 OE-09 MAINT. WORKER - FEDERAL BLDG 1.00 $ 57,054 1.00 $ 57,077 1.00 $ 61,640 100 OE-06 CUSTODIAN I 5.00 $ 241,794 5.00 $ 239,782 5.00 $ 258,728 100 9425 GE-44 CITY ENGINEER 0.30 $ 43,364 0.40 $ 59,695 0.40 $ 62,439 610 9425 GE-44 CITY ENGINEER 0.15 $ 21,681 0.20 $ 29,847 0.20 $ 31,220 620 9425 GE-44 CITY ENGINEER 0.15 $ 21,681 0.15 $ 22,386 0.15 $ 23,415 800 9425 GE-44 CITY ENGINEER 0.40 $ 55,021 0.25 $ 35,868 0.25 $ 37,514 100 3125 GE-40 ASSISTANT CITY ENGINEER 0.30 $ 34,644 0.40 $ 47,695 0.40 $ 49,888 800 3125 GE-40 ASSISTANT CITY ENGINEER 0.70 $ 80,837 0.60 $ 71,543 0.60 $ 74,832 100 4060 GE-40 PROJECT MANAGER 0.40 $ 45,304 0.40 $ 46,779 0.40 $ 49,111 610 4060 GE-40 PROJECT MANAGER 0.10 $ 11,326 0.10 $ 11,694 0.10 $ 12,277 800 4060 GE-40 PROJECT MANAGER 0.50 $ 56,630 0.50 $ 58,473 0.50 $ 61,388 100 GE-35 CIVIL ENGINEER I 0.25 $ 21,437 0.15 $ 13,357 0.15 $ 13,918 620 GE-35 CIVIL ENGINEER I 0.30 $ 29,954 0.20 $ 20,617 0.05 $ 5,607 800 GE-35 CIVIL ENGINEER I 0.75 $ 64,311 0.85 $ 75,690 0.85 $ 79,454 100 5525 GE-38 CIVIL ENGINEER II 0.80 $ 81,486 0.90 $ 95,880 0.85 $ 94,705 610 5525 GE-38 CIVIL ENGINEER II 0.05 $ 5,155 0.10 $ 10,514 0.15 $ 16,352 620 5525 GE-38 CIVIL ENGINEER II 0.80 $ 82,176 0.85 $ 90,295 1.00 $ 109,799 800 5,525 GE-38 CIVIL ENGINEER II 2.05 $ 209,659 1.95 $ 207,528 1.95 $ 215,558 100 GE-28 CAMERA SYSTEMS TECHNICIAN 0.50 $ 23,584 0.50 $ 27,081 0.50 $ 28,326 800 GE-28 CAMERA SYSTEMS TECHNICIAN 0.50 $ 23,584 0.50 $ 27,081 0.50 $ 28,326 100 5700 GE-36 SURVEYOR 0.80 $ 55,422 0.90 $ 84,176 0.90 $ 88,046 800 5700 GE-36 SURVEYOR 0.20 $ 18,115 0.10 $ 9,353 0.10 $ 9,783 100 GE-35 TRAFFIC ENGINEER 1.37 $ 102,845 1.27 $ 102,369 1.27 $ 108,700 630 GE-35 TRAFFIC ENGINEER —$ — 0.03 $ 2,204 0.03 $ 2,422 800 GE-35 TRAFFIC ENGINEER 0.63 $ 52,088 0.70 $ 59,539 0.70 $ 62,487 100 5575 GE-33 SURVEY PARTY CHIEF 0.15 $ 11,915 0.15 $ 12,303 0.15 $ 12,972 800 5575 GE-33 SURVEY PARTY CHIEF 0.85 $ 67,521 0.85 $ 69,715 0.85 $ 73,124 100 GE-31 ROW TECHNICIAN 0.90 $ 47,206 0.90 $ 57,528 0.95 $ 67,039 800 GE-31 ROW TECHNICIAN 0.10 $ 5,840 0.10 $ 6,392 0.05 $ 3,528 100 2700 GE-31 ENGINEERING ASSISTANT II —$ — 0.10 $ — 0.10 $ 7,778 800 2700 GE-31 ENGINEERING ASSISTANT II 0.90 $ 64,819 0.90 $ 66,929 0.90 $ 70,006 100 2700 GE-31 ENGINEERING TECHNICIAN 1.70 $ 117,452 1.93 $ 115,376 1.93 $ 143,384 610 2,700 GE-31 ENGINEERING TECHNICIAN 0.10 $ 7,032 0.38 $ 15,456 0.38 $ 28,714 620 2,700 GE-31 ENGINEERING TECHNICIAN 0.15 $ 10,564 0.28 $ 19,033 0.28 $ 20,248 630 2,700 GE-31 ENGINEERING TECHNICIAN 0.03 $ 2,099 —$ — —$ — 640 2700 GE-31 ENGINEERING TECHNICIAN —$ — 0.03 $ 2,168 0.03 $ 2,266 800 2700 GE-31 ENGINEERING TECHNICIAN 6.12 $ 425,026 6.38 $ 418,165 6.38 $ 476,520 100 2725 GE-30 SURVEY TECHNICIAN 0.15 $ 10,140 0.15 $ 10,469 0.15 $ 11,081 800 2725 GE-30 SURVEY TECHNICIAN 0.85 $ 57,460 0.85 $ 59,322 0.85 $ 62,552 100 4870 GE-28 UTILITY LOCATOR 0.25 $ 14,892 0.50 $ 28,218 0.50 $ 30,737 610 4870 GE-28 UTILITY LOCATOR 0.25 $ 14,892 0.50 $ 28,218 0.50 $ 30,185 620 4870 GE-28 UTILITY LOCATOR 0.25 $ 14,892 0.50 $ 28,218 0.50 $ 30,185 640 4870 GE-28 UTILITY LOCATOR 0.25 $ 14,892 0.50 $ 28,218 0.50 $ 30,971 100 225 GE-31 SECRETARY 0.80 $ 52,041 0.80 $ 56,738 0.50 $ 34,002 610 225 GE-31 SECRETARY 0.05 $ 3,210 0.05 $ 3,500 0.05 $ 3,778 620 225 GE-31 SECRETARY 0.05 $ 3,252 0.05 $ 3,546 0.05 $ 3,778 800 225 GE-31 SECRETARY 0.10 $ 6,504 0.10 $ 7,092 0.40 $ 29,937 100 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK 0.90 $ 43,926 0.90 $ 46,459 0.95 $ 51,281 610 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK 0.25 $ 12,059 0.25 $ 12,867 0.25 $ 13,458 620 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK 0.25 $ 12,059 0.25 $ 12,867 0.20 $ 10,772 C I T Y O F D U B U Q U E , I O W A DEPARTMENT DETAIL - PERSONNEL COMPLEMENT 55 ENGINEERING DEPARTMENT FY 2022 FY 2023 FY 2024 FD JC WP- GR JOB CLASS FTE BUDGET FTE BUDGET FTE BUDGET -129- 800 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK 0.60 $ 29,570 0.60 $ 31,049 0.60 $ 32,477 TOTAL FULL TIME EMPLOYEES 35.00 $ 2,568,949 37.00 $ 2,714,175 37.00 $ 2,941,528 61020 Part-Time Employee Expense 620 GE-26 I&I INSPECTOR 1.46 $ 76,578 1.46 $ 79,078 1.46 $ 82,714 100 — GE-24 UTILITY LOCATOR 0.18 $ 7,332 —$ — 610 — GE-24 UTILITY LOCATOR 0.18 $ 7,332 —$ — 620 — GE-24 UTILITY LOCATOR 0.18 $ 7,332 —$ — 640 — GE-24 UTILITY LOCATOR 0.18 $ 7,332 —$ — TOTAL PART TIME EMPLOYEES 2.19 $ 105,906 1.46 $ 79,078 1.46 $ 82,714 61030 Seasonal Employee Expense 100 NA-34 ARCHITECTURAL INTERN 0.50 $ 15,065 0.50 $ 15,556 0.50 $ 16,270 100 NA-34 BUSINESS ADMIN INTERN —$ — 0.50 $ 15,065 100 NA-34 BROADBAND INTERN —$ — 0.25 $ 7,778 100 NA-34 INTERN ENGINEERING —$ — 0.08 $ 2,593 610 NA-34 INTERN ENGINEERING —$ — 0.08 $ 2,593 0.32 $ 12,091 620 NA-34 INTERN ENGINEERING —$ — 0.08 $ 2,593 0.32 $ 12,091 100 NA-34 ENGINEERING INTERN 0.25 $ 7,532 0.25 $ 7,778 0.57 $ 20,226 800 NA-34 ENGINEERING INTERN-SEASONAL 1.00 $ 31,330 1.00 $ 32,354 0.75 $ 25,055 TOTAL SEASONAL EMPLOYEES 1.75 $ 53,927 2.75 $ 86,310 2.46 $ 85,733 TOTAL ENGINEERING 38.94 $ 2,728,782 41.21 $ 2,879,563 40.92 $ 3,109,975 C I T Y O F D U B U Q U E , I O W A DEPARTMENT DETAIL - PERSONNEL COMPLEMENT 55 ENGINEERING DEPARTMENT FY 2022 FY 2023 FY 2024 FD JC WP- GR JOB CLASS FTE BUDGET FTE BUDGET FTE BUDGET -130- Engineering Administration-FT General Fund 10055100 61010 100 225 GE-31 SECRETARY 0.05 $ 3,252 0.20 $ 14,185 0.15 $ 11,334 10055100 61010 100 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK 0.65 $ 31,867 0.55 $ 28,404 0.50 $ 27,024 10055100 61010 100 3125 GE-40 ASSISTANT CITY ENGINEER 0.30 $ 34,644 0.40 $ 47,695 0.40 $ 49,888 10055100 61010 100 4060 GE-40 PROJECT MANAGER 0.40 $ 45,304 0.35 $ 40,931 0.35 $ 42,972 10055100 61010 100 9425 GE-44 CITY ENGINEER 0.30 $ 43,364 0.40 $ 59,695 0.40 $ 62,439 Total 1.70 $ 158,431 1.90 $ 190,910 1.80 $ 193,657 Engineering Administration-Seasonal General Fund 10055100 61030 100 NA-34 BUSINESS ADMIN INTERN —$ — 0.50 $ 15,065 10055100 61030 100 NA-34 INTERN ENGINEERING —$ — 0.08 $ 2,593 0.32 $ 12,091 Total —$ — 0.58 $ 17,658 0.32 $ 12,091 Engineering Administration-FT Service Fund 80055100 61010 800 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK 0.000 0 $0 0.050 0 $2,568 0.0500 $2,686 80055100 61010 800 3125 GE-40 ASSISTANT CITY ENGINEER 0.700 0 $80,837 0.600 0 $71,543 0.6000 $74,832 80055100 61010 800 4060 GE-40 PROJECT MANAGER 0.100 0 $11,326 0.350 0 $40,931 0.3500 $42,972 80055100 61010 800 225 GE-25 SECRETARY 0.000 0 $0 0.000 0 $0 80055100 61010 800 9425 GE-44 CITY ENGINEER 0.15 $ 21,681 0.10 $ 14,924 0.10 $ 15,609 Total 0.95 $ 113,844 1.10 $ 129,966 1.10 $ 136,099 Engineering Leases - FT General Fund 10055150 61010 800 4060 GE-40 PROJECT MANAGER —$ — 0.05 $ 5,848 0.05 $ 6,139 10055150 61010 100 GE-25 CONFIDENTIAL ACCOUNT CLERK 0.05 $ 2,488 0.15 $ 7,782 0.20 $ 10,826 Total 0.05 $ 2,488 0.20 $ 13,630 0.25 $ 16,965 Engineering Leases - Seasonal General Fund 10055150 61030 100 NA-34 ENGINEERING INTERN 0.25 $ 7,532 0.25 $ 7,778 0.25 $ 8,135 Total 0.25 $ 7,532 0.25 $ 7,778 0.25 $ 8,135 City Hall Annex/Housing Maintenance-Full Time 10055220 61010 100 2040 OE-06 CUSTODIAN I 0.40 $ 19,916 0.40 $ 19,916 0.50 $ 26,889 Total 0.40 $ 19,916 0.40 $ 19,916 0.50 $ 26,889 10055230 61010 100 3420 OE-09 MAINT. WORKER - FEDERAL BLDG 1.00 $ 57,054 1.00 $ 57,077 1.00 $ 61,640 10055230 61010 100 2040 OE-06 CUSTODIAN I 2.15 $ 102,214 2.15 $ 102,221 2.50 $ 130,244 Total 3.15 $ 159,268 3.15 $ 159,298 3.50 $ 191,884 Multicultural Family Center Maintenance-FT 10055250 61010 100 2040 OE-06 CUSTODIAN I 0.45 $ 20,882 0.45 $ 20,882 10055250 61010 100 2088 OE-06 CUSTODIAN I 1.00 $ 46,479 1.00 $ 46,479 1.00 $ 47,284 Total 1.45 $ 67,361 1.45 $ 67,361 1.00 $ 47,284 City Hall Maintenance-FT 10055210 61010 100 2040 OE-06 CUSTODIAN I 1.00 $ 52,303 1.00 $ 50,284 1.00 $ 54,311 Total 1.00 $ 52,303 1.00 $ 50,284 1.00 $ 54,311 Facilities Management-FT 10055200 61010 100 GE-31 SECRETARY —$ — 0.05 $ 3,546 0.05 $ 3,778 CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2022 FY 2023 FY 2024 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET -131- 10055200 61010 100 GE-25 CONFIDENTIAL ACCOUNT CLERK 0.05 $ 2,686 10055200 61010 100 5800 GE-34 FACILITIES MANAGER 1.00 $ 80,534 1.00 $ 67,806 1.00 $ 74,820 Total 1.00 $ 80,534 1.05 $ 71,352 1.10 $ 81,284 Facilities Management -Seasonal 10055200 61030 100 NA-34 ARCHITECTURAL INTERN 0.50 $ 15,065 0.50 $ 15,556 0.50 $ 16,270 Total 0.50 $ 15,065 0.50 $ 15,556 0.50 $ 16,270 Project Engineering-FT General Fund 10055400 61010 100 2700 GE-31 ENGINEERING ASSISTANT II —$ — 0.10 $ 7,436 0.10 $ 7,778 10055400 61010 100 GE-31 ROW TECHNICIAN 0.90 $ 47,206 0.90 $ 57,528 0.95 $ 67,039 10055400 61010 100 2220 GE-31 ENGINEERING TECHNICIAN 1.40 $ 96,940 1.10 $ 78,696 1.30 $ 96,673 10055400 61010 100 2725 GE-30 SURVEY TECHNICIAN 0.15 $ 10,140 0.15 $ 10,469 0.15 $ 11,081 10055400 61010 100 5575 GE-33 SURVEY PARTY CHIEF 0.15 $ 11,915 0.15 $ 12,303 0.15 $ 12,972 10055400 61010 100 4710 GE-35 TRAFFIC ENGINEER 0.50 $ 43,171 0.50 $ 44,704 0.50 $ 46,759 10055400 61010 100 GE-35 CIVIL ENGINEER I 0.25 $ 21,437 0.15 $ 13,357 0.15 $ 13,918 10055400 61010 100 GE-28 CAMERA SYSTEMS TECHNICIAN 0.50 $ 23,584 0.50 $ 27,081 0.50 $ 28,326 10055400 61010 100 GE-31 SECRETARY 0.45 $ 29,273 0.35 $ 24,822 0.20 $ 11,334 10055400 61010 100 5525 GE-38 CIVIL ENGINEER II 0.80 $ 82,176 0.85 $ 90,295 0.85 $ 94,705 10055400 61010 100 5700 GE-36 SURVEYOR 0.80 $ 55,422 0.80 $ 74,823 0.80 $ 78,263 Total 5.90 $ 421,264 5.55 $ 441,514 5.65 $ 468,848 Project Engineering-Seasonal General Fund 10055400 61030 100 NA-34 BROADBAND INTERN —$ — 0.25 $ 7,778 Total —$ — 0.25 $ 7,778 —$ — Project Engineering Subdivision Inspection-FT General Fund 10055405 61010 100 2220 GE-31 ENGINEERING TECHNICIAN 0.30 $ 20,512 0.40 $ 27,076 0.60 $ 44,445 Total 0.30 $ 20,512 0.40 $ 27,076 0.60 $ 44,445 Project Engineering-FT Service Fund 80055400 61010 800 4060 GE-40 PROJECT MANAGER 0.25 $ 28,315 —$ — 80055400 61010 800 GE-28 CAMERA SYSTEMS TECHNICIAN 0.50 $ 23,584 0.50 $ 27,081 0.50 $ 28,326 80055400 61010 800 GE-31 ROW TECHNICIAN 0.10 $ 5,840 0.10 $ 6,392 0.05 $ 3,528 80055400 61010 800 2700 GE-31 ENGINEERING ASSISTANT II 0.85 $ 61,217 0.85 $ 63,211 0.85 $ 66,117 80055400 61010 800 GE-25 CONFIDENTIAL ACCOUNT CLERK 0.05 $ 2,393 —$ — 80055400 61010 800 GE-31 SECRETARY 0.20 $ 14,825 80055400 61010 800 GE-35 CIVIL ENGINEER I 0.55 $ 47,161 0.65 $ 57,882 0.75 $ 70,138 80055400 61010 800 2220 GE-31 ENGINEERING TECHNICIAN 2.82 $ 194,778 3.03 $ 217,298 3.48 $ 260,138 80055400 61010 800 2725 GE-30 SURVEY TECHNICIAN 0.30 $ 20,280 0.30 $ 20,937 0.30 $ 22,077 80055400 61010 800 5575 GE-33 SURVEY PARTY CHIEF 0.30 $ 23,831 0.30 $ 24,605 0.30 $ 25,940 80055400 61010 800 5525 GE-38 CIVIL ENGINEER II 1.20 $ 122,513 1.15 $ 123,410 1.15 $ 127,717 80055400 61010 800 4710 GE-35 TRAFFIC ENGINEER 0.50 $ 43,171 0.60 $ 52,192 0.60 $ 54,834 80055400 61010 800 5700 GE-36 SURVEYOR 0.20 $ 18,115 0.10 $ 9,353 0.10 $ 9,783 Total 7.62 $ 591,198 7.58 $ 602,361 8.28 $ 683,423 Project Engineering-Seasonal Service Fund 80055400 61030 800 5325 NA-34 ENGINEERING INTERN- SEASONAL 1.00 $ 31,330 1.00 $ 32,354 0.75 $ 25,055 Total 1.00 $ 31,330 1.00 $ 32,354 0.75 $ 25,055 Traffic Engineering-FT General Fund CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2022 FY 2023 FY 2024 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET -132- 10055700 61010 100 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK 0.20 $ 9,571 0.20 $ 10,273 0.20 $ 10,745 10055700 61010 100 GE-31 SECRETARY 0.30 $ 19,516 0.20 $ 14,185 0.10 $ 7,556 10055700 61010 800 2220 GE-31 ENGINEERING TECHNICIAN —$ — 0.03 $ 2,168 0.03 $ 2,266 10055700 61010 100 5700 GE-36 SURVEYOR —$ — 0.10 $ 9,353 0.10 $ 9,783 10055700 61010 100 4870 GE-28 UTILITY LOCATOR 0.25 $ 14,892 0.50 $ 28,218 0.50 $ 30,737 10055700 61010 100 GE-35 TRAFFIC ENGINEER 0.87 $ 59,674 0.77 $ 57,665 0.77 $ 61,941 10055700 61010 100 5550 GE-33 TRAFFIC ENGINEERING ASSIST —$ — —$ — Total 1.62 $ 103,653 1.80 $ 121,862 1.70 $ 123,028 Traffic Engineering-PT General Fund 10055700 61020 100 GE-24 UTILITY LOCATOR 0.18 $ 7,332 —$ — $ — Total 0.18 $ 7,332 —$ — —$ — Traffic Engineering-FT Service Fund 80055700 61010 800 GE-31 ENGINEERING TECHNICIAN 0.40 $ 28,144 80055700 61010 800 GE-35 TRAFFIC ENGINEER 0.13 $ 8,917 0.10 $ 7,347 0.10 $ 7,653 Total 0.13 $ 8,917 0.10 $ 7,347 0.50 $ 35,797 Project Engineering-FT Sewer Fund 61055400 61010 610 4870 GE-28 UTILITY LOCATOR 0.25 $ 14,892 0.50 $ 28,218 0.50 $ 30,185 61055400 61010 610 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK 0.25 $ 12,059 0.25 $ 12,867 0.25 $ 13,458 61055400 61010 610 5525 GE-38 CIVIL ENGINEER II 0.05 $ 5,155 0.10 $ 10,514 0.15 $ 16,352 61055400 61010 610 4060 GE-40 PROJECT MANAGER 0.10 $ 11,326 0.10 $ 11,694 0.10 $ 12,277 61055400 61010 610 9425 GE-44 CITY ENGINEER 0.15 $ 21,681 0.20 $ 29,847 0.20 $ 31,220 61055400 61010 610 2710 GE-26 I&I INSPECTOR —$ — —$ — 61055400 61010 610 225 GE-31 SECRETARY 0.05 $ 3,210 0.05 $ 3,500 0.05 $ 3,778 61055400 61010 610 2220 GE-31 ENGINEERING TECHNICIAN 0.10 $ 7,032 0.23 $ 15,456 0.38 $ 28,714 Total 0.95 $ 75,355 1.43 $ 112,096 1.63 $ 135,984 Project Engineering-PT Sewer Fund 61055400 61020 610 GE-24 UTILITY LOCATOR 0.18 $ 7,332 —$ — Total 0.18 $ 7,332 —$ — —$ — Project Engineering-Seasonal Sewer Fund 61055400 61030 610 NA-34 INTERN ENGINEERING —$ — 0.08 $ 2,593 0.32 $ 12,091 Total —$ — 0.08 $ 2,593 0.32 $ 12,091 Sanitary Utility -FT Service Fund 80055610 61010 800 5525 GE-38 CIVIL ENGINEER II 0.05 $ 5,155 0.40 $ 42,059 0.45 $ 48,593 80055610 61010 800 GE-35 CIVIL ENGINEER I 0.10 $ 8,575 0.10 $ 8,904 0.05 $ 4,676 80055610 61010 800 9425 GE-44 CITY ENGINEER 0.15 $ 21,681 0.10 $ 14,924 0.10 $ 15,609 80055610 61010 800 2220 GE-31 ENGINEERING TECHNICIAN 2.30 $ 160,425 2.00 $ 140,584 1.70 $ 128,456 80055610 61010 800 2725 GE-30 SURVEY TECHNICIAN 0.30 $ 20,280 0.30 $ 20,937 0.30 $ 22,077 80055610 61010 800 5575 GE-33 SURVEY PARTY CHIEF 0.30 $ 23,831 0.30 $ 24,605 0.30 $ 25,737 80055610 61010 800 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK 0.15 $ 7,369 0.15 $ 7,755 0.15 $ 8,113 80055610 61010 800 225 GE-31 SECRETARY 0.05 $ 3,252 0.05 $ 3,546 0.10 $ 7,556 80055610 61010 800 4060 GE-40 PROJECT MANAGER 0.10 $ 11,326 0.10 $ 11,694 0.10 $ 12,277 Total 3.50 $ 261,894 3.50 $ 275,008 3.25 $ 273,094 Project Engineering-FT Stormwater Fund CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2022 FY 2023 FY 2024 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET -133- 62055620 61010 620 2220 GE-31 ENGINEERING TECHNICIAN 0.15 $ 10,564 0.28 $ 19,033 0.28 $ 20,248 62055620 61010 620 4870 GE-28 UTILITY LOCATOR 0.25 $ 14,892 0.50 $ 28,218 0.50 $ 30,185 62055620 61010 620 1000 GE-33 CONFIDENTIAL ACCOUNT CLERK 0.25 $ 12,059 0.25 $ 12,867 0.20 $ 10,772 62055620 61010 620 9425 GE-44 CITY ENGINEER 0.15 $ 21,681 0.15 $ 22,386 0.15 $ 23,415 62055620 61010 620 225 GE-31 SECRETARY 0.05 $ 3,252 0.05 $ 3,546 0.05 $ 3,778 62055620 61010 620 1900 GE-38 CIVIL ENGINEER I —$ — —$ — 0.05 $ 5,607 Total 0.85 $ 62,448 1.23 $ 86,050 1.23 $ 94,005 Project Engineering-Seasonal Stormwater Fund 62055620 61010 620 NA-34 INTERN ENGINEERING —$ — 0.08 $ 2,593 0.32 $ 12,091 Total —$ — 0.08 $ 2,593 0.32 $ 12,091 NPDES PERMIT-FT Stormwater Fund 62055750 61010 620 1900 GE-38 CIVIL ENGINEER II 0.06 $ 6,057 0.06 $ 6,310 0.03 $ 3,364 62055751 61010 620 2230 GE-38 CIVIL ENGINEER II 0.40 $ 39,939 0.40 $ 42,059 0.10 $ 11,213 62055752 61010 620 2230 GE-38 CIVIL ENGINEER II 0.02 $ 2,790 0.02 $ 2,938 0.01 $ 1,125 62055753 61010 620 1900 GE-38 CIVIL ENGINEER II 0.05 $ 5,090 0.04 $ 4,206 0.02 $ 2,242 62055754 61010 620 1900 GE-38 CIVIL ENGINEER II 0.10 $ 10,147 0.10 $ 10,514 0.05 $ 5,607 62055755 61010 620 GE-38 CIVIL ENGINEER II 0.07 $ 7,152 0.08 $ 8,411 0.04 $ 4,486 62055756 61010 620 GE-38 CIVIL ENGINEER I 0.30 $ 29,954 —$ — 62055756 61010 620 1900 GE-38 CIVIL ENGINEER II 0.10 $ 10,311 0.40 $ 42,059 0.25 $ 28,034 Total 1.10 $ 111,440 1.10 $ 116,497 0.50 $ 56,071 Stormwater Utility FT Stormwater 62055900 61010 620 2230 GE-38 CIVIL ENGINEER II —$ — —$ — 0.50 $ 53,728 Total —$ — —$ — 0.50 $ 53,728 Stormwater Utility -PT Stormwater 62055620 61020 620 GE-24 UTILITY LOCATOR 0.18 $ 7,332 —$ — 62055900 61020 620 2710 GE-26 I&I INSPECTOR 1.46 $ 76,578 1.46 $ 79,078 1.46 $ 82,714 Total 1.64 $ 83,910 1.46 $ 79,078 1.46 $ 82,714 Stormwater Utility -FT Service Fund 80055620 61010 800 5525 GE-38 CIVIL ENGINEER II 0.80 $ 81,991 0.40 $ 42,059 0.35 $ 39,248 80055620 61010 800 9425 GE-44 CITY ENGINEER 0.10 $ 11,659 0.05 $ 6,020 0.05 $ 6,296 80055620 61010 800 GE-35 CIVIL ENGINEER I 0.10 $ 8,575 0.10 $ 8,904 0.05 $ 4,640 80055620 61010 800 GE-31 SECRETARY 0.05 $ 3,252 0.05 $ 3,546 0.10 $ 7,556 80055620 61010 800 2220 GE-31 ENGINEERING TECHNICIAN 1.00 $ 69,823 0.90 $ 60,283 0.80 $ 59,782 80055620 61010 800 2700 GE-31 ENGINEERING ASSISTANT II 0.05 $ 3,602 0.05 $ 3,718 0.05 $ 3,889 80055620 61010 800 2725 GE-30 SURVEY TECHNICIAN 0.25 $ 16,900 0.25 $ 17,448 0.25 $ 18,398 80055620 61010 800 4060 GE-40 PROJECT MANAGER 0.05 $ 5,663 0.05 $ 5,848 0.05 $ 6,139 80055620 61010 800 5575 GE-33 SURVEY PARTY CHIEF 0.25 $ 19,859 0.25 $ 20,505 0.25 $ 21,447 80055620 61010 800 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK 0.40 $ 19,808 0.40 $ 20,726 0.40 $ 21,678 Total 3.05 $ 241,132 2.50 $ 189,057 2.35 $ 189,073 Residential Parking - FT 63055630 61010 630 GE-35 TRAFFIC ENGINEER 0.03 $ 2,099 0.03 $ 2,204 0.03 $ 2,422 Total 0.03 $ 2,099 0.03 $ 2,204 0.03 $ 2,422 Water Utility -FT CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2022 FY 2023 FY 2024 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET -134- 64055400 61010 630 GE-31 ENGINEERING TECHNICIAN —$ — 0.03 $ 2,168 0.03 $ 2,266 64055400 61010 640 4870 GE-28 UTILITY LOCATOR 0.25 $ 14,892 0.50 $ 28,218 0.50 $ 30,971 Total 0.25 $ 14,892 0.53 $ 30,386 0.53 $ 33,237 Water Utility -PT 64055400 61020 640 GE-24 UTILITY LOCATOR 0.18 $ 7,332 —$ — Total 0.18 $ 7,332 —$ — —$ — TOTAL ENGINEERING DEPARTMENT 38.93 $ 2,728,782 40.21 $ 2,879,563 40.92 $ 3,109,975 CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2022 FY 2023 FY 2024 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET -135- 5514000001 Water Plant Flood Protection System Engineering 621 64075 125,000 5521000001 East-West Corridor Capacity Engineering 301 64070 1,000,000 5521000001 East-West Corridor Capacity Engineering 301 64075 50,000 5521000001 East-West Corridor Capacity Engineering 301 67990 1,742,880 5521000002 Sidewalk curb/catch basin rep Engineering 301 64075 45,000 5521000002 Sidewalk curb/catch basin rep Engineering 301 67990 6,000 5521000006 Sidewalk Inspection Program Engineering 100 67990 40,000 5521000007 Crossroads Ind Park Impr Engineering 301 64075 10,000 5521000007 Crossroads Ind Park Impr Engineering 301 67990 940,000 5521000010 Sidewalk Program-City Prop Engineering 301 64075 170,000 5521000010 Sidewalk Program-City Prop Engineering 301 67990 20,000 5521000012 Street Construction Repairs Engineering 301 64075 20,000 5521000012 Street Construction Repairs Engineering 301 67990 80,000 5521000013 Pavement Marking Project Engineering 301 64075 20,000 5521000013 Pavement Marking Project Engineering 301 67990 150,000 5521000019 Brick Paver Maintenance Engineering 301 64075 5,000 5521000019 Brick Paver Maintenance Engineering 301 67990 50,000 5521000036 SOUTH PORT REDEVELOPMENT Engineering 305 64075 8,000 5521000036 SOUTH PORT REDEVELOPMENT Engineering 305 67990 160,000 5521000047 Kerper Blvd/Kerper Ct Roundabout Engineering 301 64070 50,000 5521000047 Kerper Blvd/Kerper Ct Roundabout Engineering 301 64075 50,000 5521000047 Kerper Blvd/Kerper Ct Roundabout Engineering 301 67990 1,400,000 5521000048 JFK & 32nd Intersection Recon Engineering 301 64075 32,000 5521000048 JFK & 32nd Intersection Recon Engineering 301 64900 30,000 5521000048 JFK & 32nd Intersection Recon Engineering 301 67990 550,000 5521000049 Hillcrest Rd Sidewalk Engineering 100 64075 10,000 5521000049 Hillcrest Rd Sidewalk Engineering 100 67990 65,000 5523000003 Street Light Replacement Engineering 305 64075 10,000 5523000003 Street Light Replacement Engineering 301 67990 15,000 5523000003 Street Light Replacement Engineering 305 67990 140,000 5524000001 Emergency Preemption expan Engineering 301 67270 10,000 5524000004 Traffic Signal Mastarm retro Engineering 301 64075 5,000 5524000004 Traffic Signal Mastarm retro Engineering 301 67990 20,000 5524000006 Traffic Signal Conduit Repl Engineering 301 64075 5,000 5524000006 Traffic Signal Conduit Repl Engineering 301 67990 15,000 5524000007 Traffic Signal Controller Rep Engineering 301 67270 22,500 5524000008 Traffic Signal Inter Reconst Engineering 301 67990 25,000 5524000009 Traffic Signal Vehicle Detect Engineering 301 67270 20,000 5524000010 LED Re-lamp Schedule Engineering 301 67270 10,000 5524000011 Fiber Optic Conduit Engineering 301 64075 2,500 5524000011 Fiber Optic Conduit Engineering 301 67990 10,000 5524000013 Street Light/Traffic Control Engineering 301 67990 20,000 5524000014 ITS Traffic Control Equipment Engineering 301 64075 2,000 5524000014 ITS Traffic Control Equipment Engineering 301 67990 15,000 5524000016 Street Camera Installation Engineering 305 64075 2,000 5524000016 Street Camera Installation Engineering 305 67270 28,000 5524000017 Fiber Infrastructure mgmt Engineering 301 64075 10,000 5524000018 Streets Traffic Control Proj Engineering 301 64075 50,000 5524000019 Broadband Acceleration/access Engineering 301 64075 10,000 5524000019 Broadband Acceleration/access Engineering 301 67990 40,000 5524000022 TRAFFIC SIG FIBER OPTIC NET Engineering 301 64075 5,000 5524000022 TRAFFIC SIG FIBER OPTIC NET Engineering 301 67990 45,000 5524000029 Signalization Program Engineering 301 64075 5,000 5524000029 Signalization Program Engineering 301 67990 20,000 Capital Improvement Projects by Department/Division ENGINEERING Project Number Capital Improvement Project Title Department Fund Account FY 24 Recomm'd Budget -136- 5529900001 Railroad Quiet Zone Study Engineering 110 64075 8,500 5529900001 Railroad Quiet Zone Study Engineering 110 64900 35,000 5529900002 RIVERFRONT LEASEHOLD IMPR Engineering 304 64075 10,000 5529900002 RIVERFRONT LEASEHOLD IMPR Engineering 304 67990 155,000 5529900009 Public Electric Vehicle Chargers Engineering 305 64075 8,600 5529900009 Public Electric Vehicle Chargers Engineering 305 64900 32,000 5529900009 Public Electric Vehicle Chargers Engineering 305 67990 170,000 5529900010 ADA Compliance and Facilities Manag Engineering 305 64900 50,000 5544000002 Trail Planning Engineering 304 64075 20,000 5544000003 16TH ST DET BASIN TRAIL Engineering 301 64075 128,400 5544000003 16TH ST DET BASIN TRAIL Engineering 301 67990 150,000 5549900001 MFC - HVAC roof access equip Engineering 304 67500 22,000 5565000001 City Annex Roof Replacement Engineering 304 64075 3,000 5565000001 City Annex Roof Replacement Engineering 304 67500 14,500 5565000003 Federal Building Renovation Engineering 305 64075 65,000 5565000003 Federal Building Renovation Engineering 305 64900 350,000 5565000003 Federal Building Renovation Engineering 305 67500 1,373,725 5565000005 MFC Building Stabilization Engineering 304 64075 2,500 5565000005 MFC Building Stabilization Engineering 304 64900 2,000 5565000005 MFC Building Stabilization Engineering 304 67500 15,000 5565000006 City Hall Maintenance Engineering 304 64075 5,000 5565000006 City Hall Maintenance Engineering 304 67500 70,000 5565000007 City Hall HVAC Control Exp Engineering 304 67500 65,000 5565000008 City Annex Window Replcmnt Engineering 304 67990 18,000 5565000015 Engineering Dept. Materials Testing Engineering 304 64075 6,500 5565000015 Engineering Dept. Materials Testing Engineering 304 64900 12,000 5565000015 Engineering Dept. Materials Testing Engineering 304 67500 45,000 5565000016 City Hall North Basement Wall Water Engineering 304 67500 50,000 5575000002 Inet Fiber Build Out Engineering 301 64075 5,000 5575000002 Inet Fiber Build Out Engineering 301 67270 10,000 5575000002 Inet Fiber Build Out Engineering 301 67990 50,000 5581500001 Sanitary Sewer Extensions-Pre-Annex Engineering 611 64075 3,000 5581500001 Sanitary Sewer Extensions-Pre-Annex Engineering 611 64900 12,000 5581500001 Sanitary Sewer Extensions-Pre-Annex Engineering 611 67990 389,200 5581500006 Old Mill Road Lift Station Engineering 611 64075 25,000 5581500006 Old Mill Road Lift Station Engineering 611 64900 350,000 5581500006 Old Mill Road Lift Station Engineering 611 67990 5,401,812 5581500009 Granger Creek Lift St Improv Engineering 611 67990 240,000 5581500017 GENERAL SANITARY SEWER REPAIR Engineering 611 64075 20,000 5581500017 GENERAL SANITARY SEWER REPAIR Engineering 611 67990 180,000 5581500020 SAN SEWER MANHOLE REPLACE Engineering 611 64075 7,500 5581500020 SAN SEWER MANHOLE REPLACE Engineering 611 67990 44,500 5581500024 TWIN RIDGE LIFT ST ABANDO Engineering 611 64075 15,500 5581500024 TWIN RIDGE LIFT ST ABANDO Engineering 611 67990 910,800 5581500031 Coates Sanitary Sewer Engineering 611 67990 60,000 5581500039 Abbott & Cottage Sanitary Sewer Engineering 611 64075 15,000 5581500040 Cooper Place & Maiden Lane Sanitary Engineering 611 64075 22,000 5581500041 Harvard Street San Sewer Recon Engineering 611 64075 18,000 5581500042 Hempstead San Sewer Recon Engineering 611 64075 18,000 5581500043 Knob Hill-Duggan Drive Recon Engineering 611 64075 18,500 5581500044 Perry St & Bradley St Lift Station Engineering 611 64075 12,000 5581500044 Perry St & Bradley St Lift Station Engineering 611 67990 255,000 5581500045 Brunskill Rd Collector Sewer Recon Engineering 611 64075 16,000 5581500045 Brunskill Rd Collector Sewer Recon Engineering 611 67990 284,000 Capital Improvement Projects by Department/Division ENGINEERING Project Number Capital Improvement Project Title Department Fund Account FY 24 Recomm'd Budget -137- 5581500046 Broadway Sanitary Sewer Improvement Engineering 611 64075 14,500 5581500046 Broadway Sanitary Sewer Improvement Engineering 611 67990 98,000 5586500001 Storm Sewer Replacements Engineering 621 64075 30,000 5586500001 Storm Sewer Replacements Engineering 621 67990 50,000 5586500002 Catch Basin Reconstruction Engineering 621 64070 5,000 5586500002 Catch Basin Reconstruction Engineering 621 67990 29,000 5586500004 Federal Building Drainage Imp Engineering 304 64075 7,500 5586500004 Federal Building Drainage Imp Engineering 304 67990 75,000 5586500007 Bee Branch Gate&pump replc Engineering 303 64070 185,420 5586500007 Bee Branch Gate&pump replc Engineering 303 64075 5,000 5586500007 Bee Branch Gate&pump replc Engineering 303 67990 3,720,000 5586500020 Storm sewer Imprv/Exten Engineering 621 64075 5,000 5586500020 Storm sewer Imprv/Exten Engineering 621 67990 33,000 5586500037 Bergfeld Pond Detention Basin Outle Engineering 621 64075 25,500 5586500037 Bergfeld Pond Detention Basin Outle Engineering 621 67990 117,500 ENGINEERING TOTAL 23,060,837 Capital Improvement Projects by Department/Division ENGINEERING Project Number Capital Improvement Project Title Department Fund Account FY 24 Recomm'd Budget -138- PUBLIC WORKS SANITARY SEWER Business Type General Sanitary Sewer Extensions to New Development $ — $ 182,000 $ — $ — $ 279,000 $ 461,000 150 Sanitary Sewer Extensions to Existing Developments $ — $ — $ — $ — $ 714,000 $ 714,000 151 Twin Ridge Lagoon Abandonment $ 926,300 $ — $ — $ — $ — $ 926,300 152 Sanitary Sewer Extensions - Existing Development, Pre- annexation and Annexation Agreements $ 404,200 $ — $ — $ — $ — $ 404,200 153 Dubuque Industrial Center Crossroads Sanitary Sewer Extension $ — $ — $ 65,000 $ — $ 230,000 $ 295,000 154 Dubuque Industrial Center Chavenelle, Sewer Extension through McFadden Farm to Pennsylvania $ — $ 1,733,000 $ — $ — $ — $ 1,733,000 155 Dubuque Industrial Center Chavenelle, Sewer Extension to Pennsylvania $ — $ 221,500 $ — $ — $ — $ 221,500 156 General Sanitary Sewer Replacement $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 1,000,000 157 Sanitary Sewer Lining Program $ — $ — $ — $ 20,000 $ 750,000 $ 770,000 158 Sanitary Sewer CCTV Inspection, Cleaning, & Assessment $ — $ 360,000 $ — $ 360,000 $ — $ 720,000 159 Manhole Replacement / Rehabilitation Program (Consent Decree)$ 52,000 $ 52,000 $ 52,000 $ 100,000 $ 100,000 $ 356,000 160 Force Main Air Release Replacement Project $ — $ 362,500 $ — $ — $ — $ 362,500 161 Reconstruction Knob Hill-Duggan Drive Sanitary Sewer Reconstruction $ 18,500 $ 162,000 $ — $ — $ — $ 180,500 162 Outfall Manhole Reconstruction $ — $ 430,000 $ 150,000 $ — $ — $ 580,000 163 Cedar and Terminal Street Lift Station and Force Main Assessment and Improvements $ — $ 300,000 $ 3,400,000 $ — $ — $ 3,700,000 164 Perry & Bradley Force Main and Lift Station Improvements $ 267,000 $ — $ — $ — $ — $ 267,000 166 Hempstead Sanitary Sewer Reconstruction $ 18,000 $ 357,000 $ — $ — $ — $ 375,000 167 Cooper Place and Maiden Lane Sanitary Sewer Reconstruction $ 22,000 $ 376,000 $ — $ — $ — $ 398,000 168 Abbott & Cottage Sanitary Sewer Reconstruction $ 15,000 $ 232,500 $ — $ — $ — $ 247,500 169 Harvard St Sanitary Sewer Reconstruction $ 18,000 $ 205,000 $ — $ — $ — $ 223,000 170 Brunswick Sanitary Sewer $ — $ — $ 10,000 $ 100,000 $ 110,000 171 King Street Sanitary Sewer Reconstruction $ — $ — $ — $ 10,000 $ 96,500 $ 106,500 172 Old Mill Road Lift Station & Force Main $ 5,776,812 $ 9,922,700 $ 6,544,400 $ — $ — $ 22,243,912 173 Granger Creek Lift Station Improvements $ 240,000 $ — $ — $ — $ — $ 240,000 174 PRGRM/ DEPT PROJECT DESCRIPTION FY 2024 FY 2025 FY 2026 FY 2027 FY 2028 TOTAL PAGE -139- Catfish Creek Sewershed Interceptor Sewer Improvements $ — $ — $ 422,130 $ 1,830,215 $ 4,941,100 $ 7,193,445 175 Coates Street Sanitary Sewer Relocation $ 60,000 $ — $ — $ — $ — $ 60,000 177 Brunskill Road Collector Sewer Reconstruction $ 300,000 $ — $ — $ — $ — $ 300,000 178 Broadway Sanitary Sewer Improvements $ 112,500 $ — $ — $ — $ — $ 112,500 179 STORMWATER Business Type General Storm Sewer Projects Stormwater Infiltration & Inflow Elimination Program $ — $ 52,500 $ 55,000 $ 57,700 $ 60,400 $ 225,600 180 Storm Sewer General Replacements $ 80,000 $ 100,000 $ 100,000 $ 100,000 $ 100,000 $ 480,000 181 Storm Sewer Improvements/ Extensions $ 38,000 $ 61,000 $ 62,000 $ 62,000 $ 63,000 $ 286,000 182 Catch Basin Reconstruction $ 34,000 $ 54,000 $ 55,000 $ 55,000 $ 56,000 $ 254,000 183 Drain Tile Program $ — $ 72,000 $ 122,530 $ 100,000 $ — $ 294,530 184 Bee Branch Watershed Projects Bee Branch Creek Gate & Pump Replacement $ 3,910,420 $ — $ — $ — $ — $ 3,910,420 185 Flood Control Maintenance Facility $ — $ 225,000 $ — $ — $ 3,556,000 $ 3,781,000 186 North End Storm Sewer Improvements $ — $ — $ — $ — $ 800,000 $ 800,000 187 Water Plant Flood Protection System $ 125,000 $ — $ — $ — $ — $ 125,000 188 Specific Storm Sewer Projects Pennsylvania Culvert Replacement $ — $ 25,000 $ 125,000 $ — $ — $ 150,000 189 Windsor Storm Extension (Buena Vista to Strauss)$ — $ — $ 111,000 $ — $ 111,000 190 University Ave Storm Sewer $ — $ 70,000 $ 80,000 $ — $ — $ 150,000 191 NW Arterial Detention Basin Improvements $ — $ 5,000 $ 229,000 $ — $ — $ 234,000 192 Bies Drive Storm Sewer (Street Program)$ — $ — $ — $ 98,000 $ — $ 98,000 193 Century Drive Storm Sewer Reconstruction $ — $ — $ — $ 242,500 $ — $ 242,500 194 Embassy West Storm Sewer Improvements $ — $ — $ 153,000 $ — $ — $ 153,000 195 Bergfeld Pond Detention Basin Outlet Structure Improvements $ 143,000 $ — $ — $ — $ — $ 143,000 196 STREETS Public Works Street Related Improvements Pavement Marking Project $ 170,000 $ 170,000 $ 170,000 $ 170,000 $ 175,000 $ 855,000 197 Street Construction General Repairs $ 100,000 $ 100,000 $ 120,000 $ 130,000 $ — $ 450,000 198 East - West Corridor Capacity Improvements $ 2,792,880 $ 688,926 $ 1,100,000 $ 800,000 $ 100,000 $ 5,481,806 199 Pavement Rehabilitation - Concrete Street Repair, Mill and Asphalt Resurfacing $ — $ 450,000 $ 400,000 $ — $ — $ 850,000 202 PRGRM/ DEPT PROJECT DESCRIPTION FY 2024 FY 2025 FY 2026 FY 2027 FY 2028 TOTAL PAGE -140- Pavement Preservation Joint Sealing $ — $ 55,000 $ — $ 55,000 $ — $ 110,000 203 7th Street Extension to Pine Street $ — $ — $ — $ 400,000 $ 700,000 $ 1,100,000 204 Cedar Cross Road Reconstruction $ — $ — $ — $ 1,240,000 $ 1,560,000 $ 2,800,000 205 Bies Drive Reconstruction $ — $ — $ 250,000 $ — $ — $ 250,000 206 Traffic and Pedestrian Crossing Warning Devices $ — $ 12,000 $ — $ 12,000 $ — $ 24,000 207 Green Alleys - Non Bee Branch $ — $ — $ 30,000 $ 30,000 $ 30,000 $ 90,000 208 Dubuque Industrial Center Crossroads - New Road Infrastructure Improvements $ 950,000 $ 160,000 $ — $ — $ 680,000 $ 1,790,000 209 Dubuque Industrial Center McFadden Farm - South Heacock Road Construction $ — $ 4,647,776 $ — $ — $ — $ 4,647,776 210 Roundabout Projects Development $ 1,500,000 $ — $ — $ — $ 500,000 $ 2,000,000 211 Pennsylvania Avenue and Radford Road Intersection Roundabout $ — $ — $ — $ — $ 25,000 $ 25,000 212 Sidewalk Related Sidewalk Inspection Program - Assessable $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 45,000 $ 205,000 213 Sidewalk Program - City-Owned Property $ 190,000 $ 117,223 $ 119,302 $ 138,869 $ 50,000 $ 615,394 214 Sidewalk Program Related Curb and Catch Basin Replacements $ 51,000 $ 77,000 $ 52,000 $ 92,000 $ 53,000 $ 325,000 215 Hillcrest Road Sidewalk $ 75,000 $ 20,000 $ 50,000 $ — $ — $ 145,000 216 Brick Paver Maintenance $ 55,000 $ — $ 60,000 $ 43,000 $ 43,000 $ 201,000 217 Trails/General Maintenance Stone Retaining Walls $ — $ 100,000 $ 100,000 $ 100,000 $ 100,000 $ 400,000 218 Bridge Repairs/Maintenance $ — $ 100,000 $ 100,000 $ 100,000 $ — $ 300,000 219 Complete Streets Elements $ — $ 22,000 $ 22,000 $ — $ 22,000 $ 66,000 220 Guardrail Replacement $ — $ 17,000 $ — $ — $ — $ 17,000 221 Trail Planning $ 20,000 $ — $ — $ — $ — $ 20,000 222 Bee Branch Creek Trail 16th to 9th $ 278,400 $ — $ — $ — $ 600,000 $ 878,400 223 MISCELLANEOUS General Government South Port Redevelopment $ 168,000 $ — $ — $ 84,500 $ — $ 252,500 225 Riverfront Leasehold Improvements $ 165,000 $ — $ — $ — $ — $ 165,000 226 Railroad Quiet Zone Study $ 43,500 $ — $ — $ — $ — $ 43,500 228 Public Electric Vehicle Chargers $ 210,600 $ — $ — $ — $ — $ 210,600 229 TRAFFIC Public Works Street Light Replacement and New Installation $ 165,000 $ 20,000 $ 45,000 $ 45,000 $ 25,000 $ 300,000 230 Signalization Program $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ — $ 100,000 231 Traffic Signal Mastarm Retrofit $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ — $ 100,000 232 PRGRM/ DEPT PROJECT DESCRIPTION FY 2024 FY 2025 FY 2026 FY 2027 FY 2028 TOTAL PAGE -141- Traffic Signal Interconnect Conduit Replacement $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 10,000 $ 90,000 233 Traffic Signal Controller Replacement $ 22,500 $ 35,000 $ 45,000 $ 45,000 $ 45,000 $ 192,500 235 Street Lighting and Traffic Signal Knockdown/Insurance $ 20,000 $ 25,000 $ — $ 30,000 $ 30,000 $ 105,000 236 Street Camera Installation $ 30,000 $ 110,000 $ 115,000 $ 115,000 $ 15,000 $ 385,000 237 LED Re-Lamp Schedule $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 50,000 238 Traffic Signal Battery Backup $ — $ 20,000 $ — $ 20,000 $ 20,000 $ 60,000 239 Traffic Signal Intersection Reconstruction $ 25,000 $ 65,000 $ 75,000 $ 50,000 $ 25,000 $ 240,000 240 Surge and Grounding Improvement at Signals $ — $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 80,000 241 STREETS Traffic Control Project $ 50,000 $ — $ — $ — $ — $ 50,000 242 Traffic Signal Fiber Optic Network Program $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 250,000 243 ITS Traffic Control Equipment $ 17,000 $ 25,000 $ 25,000 $ 25,000 $ — $ 92,000 244 Traffic Signal Vehicle Detection Conversion $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 10,000 $ 90,000 245 Grandview Street Light Replacement $ — $ 100,000 $ — $ — $ — $ 100,000 246 INET Fiber Replacement Build Out $ 65,000 $ 65,000 $ 65,000 $ — $ — $ 195,000 247 Emergency Preemption Expansion and Upgrades $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 50,000 248 Fiber Optic Conduit - Miscellaneous $ 12,500 $ 12,500 $ 12,500 $ 12,500 $ 12,500 $ 62,500 249 Fiber Infrastructure Management System $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 50,000 250 Broadband Acceleration and Universal Access $ 50,000 $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 150,000 251 JFK/32nd Intersection Traffic Signal Construction $ 612,000 $ — $ — $ — $ — $ 612,000 252 Facilities Management Federal Building Renovation $ 1,788,725 $ 1,788,725 $ 3,198,225 $ — $ — $ 6,775,675 253 Federal Building Parking Lot Replacement and Foundation Drainage Improvements $ 82,500 $ — $ — $ — $ — $ 82,500 254 Engineering Department Materials Testing Lab Renovation $ 63,500 $ — $ — $ — $ — $ 63,500 255 City Hall - HVAC Controls System Expansion Project $ 65,000 $ — $ — $ — $ — $ 65,000 256 City Hall Tuck Pointing Maintenance & Repairs $ 75,000 $ — $ — $ — $ — $ 75,000 257 City Hall Human Resources Office Renovations $ — $ 159,000 $ — $ — $ — $ 159,000 258 City Hall North Basement Wall Waterproofing $ 50,000 $ — $ — $ — $ — $ 50,000 259 Multicultural Family Center - HVAC Roof Access Equipment Code Improvements $ 22,000 $ — $ — $ — $ — $ 22,000 260 MFC Building Envelope Stabilization $ 19,500 $ 19,500 $ — $ — $ — $ 39,000 261 City Annex Roof Replacement Project $ 17,500 $ — $ — $ — $ — $ 17,500 262 PRGRM/ DEPT PROJECT DESCRIPTION FY 2024 FY 2025 FY 2026 FY 2027 FY 2028 TOTAL PAGE -142- City Annex Window Replacement $ 18,000 $ — $ — $ — $ — $ 18,000 263 ADA Compliance and Facilities Management Consulting $ 50,000 $ 50,000 $ 50,000 $ — $ — $ 150,000 264 TOTAL $ 23,060,837 $ 25,247,350 $ 18,274,087 $ 7,349,284 $ 17,046,500 $ 90,978,058 PRGRM/ DEPT PROJECT DESCRIPTION FY 2024 FY 2025 FY 2026 FY 2027 FY 2028 TOTAL PAGE -143- This page is intentionally left blank -144- ENGINEERING DEPARTMENT FISCAL YEAR 2024 BUDGET PRESENTATION Photo: Bee Branch Railroad Culverts Photo: Chaplain Schmitt Veterans Memorial MISSION STATEMENT Engineering Department The Engineering Department promotes the health, safety, and welfare of ALL thru sound engineering principles, practices, and partnerships applied to the planning, design, maintenance, and preservation of the City's infrastructure and property. Team Additions Engineering Department Luke Rupp –Engineering Technician Jeff Brandt –Engineering Technician Team Additions Engineering Department Max O’Brien –Civil Engineer II •Camera Technician -Advertised “Open until Filled” Vacant Positions Engineering Department Vacant Positions Engineering Department Camera Technician Position The goal was to hire someone with experience who could step in and provide immediate help managing and repairing cameras. IMPACTS TO THE CITIZENS OF DUBUQUE: ■Cameras are down longer than desired due to workload to fix Engineering Department Leadership (40.92 Full -Time Equivalents) Equity Plan Engineering Department Equity Plan Engineering Department Equity Plan Engineering Department CURRENT & FUTURE INITIATIVES •Auburn & Custer Sanitary and Water Project •St. Anne and Avalon Storm Sewer Project •Complete Preliminary Design of the East-West Corridor Improvements •Complete the STREETS Project Improvements •Old Mill Rd. Lift Station & Force Main Project •Sanitary Sewer Asset Master Plan •Granger Creek Sanitary Improvements CURRENT & FUTURE INITIATIVES •Green Alley Construction •Dubuque Industrial Center Crossroads Project •Kerper Court and Kerper Boulevard Roundabout •Catfish Creek Sanitary Sewer Interceptor Improvements •42-Inch Sanitary Sewer Force Main Stabilization •John F Kennedy Road Sidewalks Project •Bee Branch Trail –Phase 1 Project •Heeb Street Reconstruction Project CURRENT & FUTURE INITIATIVES •Fiber to the Home Expansion •Lead Water Service Replacement Coordination •Subdivision Projects ◦Mozena Farm Subdivision -103 residential lots ◦Fox Hills Apartments Development •Site Developments -15 site developments that include ◦Plan Reviews ◦Preparation of development agreements ◦Traffic Studies ◦Central Avenue Corridor ◦RAISE Planning Grant ◦East-West Corridor FY2024 RECOMMENDED IMPROVEMENT REQUESTS 1.Add Education and Training for One Utility Locator Position Recurring | $305 -Stormwater Utility Recurring | $305 -Sanitary Sewer Funds Recurring | $305 -Tax Funds Recurring | $305 -Water Use Funds 2.Add Education and Training for an Engineering Technician Recurring | $1,220 -Tax Funds 3.Add one Utility Locator Unit Non-Recurring | $3,000 -Tax Funds Non-Recurring | $3,000 -Stormwater Utility Non-Recurring | $3,000 –Sanitary Sewer Funds Non-Recurring | $3,000 –Water User Funds 4.Add Two Laptops Non-Recurring | $1,734 -Tax Funds Non-Recurring | $1,733 -Stormwater Utility Non-Recurring | $1,733 -Sanitary Sewer Funds FY2024 RECOMMENDED IMPROVEMENT REQUESTS 5.Add All-Weather Outerwear for Department Staff Recurring | $2,600 -Tax Funds Recurring | $2,600 –Stormwater Utility Recurring | $2,600 –Sanitary Sewer Funds 6.Add Occupational Safety and Health Administration Training Recurring | $2,400 –Stormwater Utility Recurring | $2,400 –Sanitary Sewer Funds 7.Add a Youth Americorp Program Intern (+0.32 FTE) Non-Recurring | $4,334 -Tax Funds Non-Recurring | $4,333 –Stormwater Utility Non-Recurring | $4,333 –Sanitary Sewer Funds 8.Add 12-Month Engineering Intern (+0.32 FTE) Non-Recurring | $3,279 -Tax Funds Non-Recurring | $3,278 –Stormwater Utility Non-Recurring | $3,278 –Sanitary Sewer Funds FY2024 RECOMMENDED IMPROVEMENT REQUESTS 9.Add Engineering Department Records Intern (+0.32 FTE) Non-Recurring | $5,640 -Tax Funds Non-Recurring | $5,639 –Stormwater Utility Non-Recurring | $5,639 –Sanitary Sewer Funds 10.Add Wet Mop Floor Scrubber Non-recurring | $4,800 –Tax Funds 11.Add Utility Metal Detectors For Field Staff Non-Recurring | $1,500 -Tax Funds Non-Recurring | $1,500 –Stormwater Utility Non-Recurring | $1,500 –Sanitary Sewer Funds Non-Recurring | $1,500 –Sanitary Sewer Funds Engineering Department FY2024 REQUESTED PROPERTY TAX SUPPORT $804,630 $11.64 Net Property Tax Support Average homeowner’s* property tax cost for City Engineering (*Avg. home value of $159,503) ENGINEERING DEPARTMENT SANITARY SEWER COLLECTION SYSTEM FISCAL YEAR 2024 BUDGET PRESENTATION CONSENT DECREE COMPLIANCE PROGRAM OUTCOME: Comply with the 2011 Consent Decree among the Iowa Department of Natural Resources and the US Environmental Protection Agency. The goal of the consent decree is to ensure that the City’s sanitary sewer collection system complies with the Federal Clean Water Act by eliminating all Sanitary Sewer Overflows. Photos are for illustrative purposes only, not from Dubuque CONSENT DECREE COMPLIANCE PROGRAM What causes sanitary sewer overflows (SSOs)? Infiltration & Inflow (I&I) INFILTRATION INFLOW Kaufmann Ave CONSENT DECREE COMPLIANCE PROGRAM FY12 thru FY16 Source Investigations -Sewer inspections -Flow metering -Smoke testing -Home inspections 5 “Sewersheds” FY13 thru FY25 Corrective Action Plan -Public System -Private Systems Project Project Cost Grove Terrace Sanitary Sewer Reconstruction $110,000 Auburn & Custer Sanitary Sewer Reconstruction $335,550 FY 23 CAPITAL IMPROVEMENT PROJECTS CONSENT DECREE COMPLIANCE PROGRAM Project Project Cost Fiscal Year(s) Hempstead Sanitary Sewer Reconstruction $375,000 24 & 25 Abbott & Cottage Sanitary Sewer Reconstruction $247,500 24 & 25 Harvard Street Sanitary Sewer Reconstruction $223,000 24 & 25 Cooper Place & Maiden Lane Sewer Reconstruction $398,000 24 & 25 FY 24 -FY 28 CAPITAL IMPROVEMENT PROJECTS CONSENT DECREE COMPLIANCE PROGRAM Terminal St. Lift Station -Renovations FY2023 Budget: $788,500 CURRENT INITIATIVES 42-inch Force Main Stabilization CURRENT INITIATIVES 42-inch Force Main Stabilization Design Under Construction (1977) Today CURRENT INITIATIVES 42-inch Force Main Stabilization SOURCE AMOUNT USACE $3,390,400 State Water Quality Funding Program Loan $1,825,600 Sanitary Sewer Construction Fund $77,000 TOTAL $5,293,000 Estimated Project Cost CURRENT INITIATIVES OLD MILL RD LIFT STATION & FORCE MAIN CURRENT INITIATIVES Lift Station Prior to FY24 FY24 FY25 FY26 TOTAL $5,481,400 $5,776,800 $9,922,700 $6,544,400 $22,593,900 Old Mill Rd LS & FM GRANGER CREEK LIFT STATION IMPROVEMENTS Originally constructed in 1999, the Granger Creek Lift Station was constructed to serve the Dubuque Technology Park and the Key West. Proposed improvements will increase the firm capacity from 0.5 MGD to 3 MGD. Lift Station Valve Vault Meter Vault 6-Inch Force Main Discharge Manhole Gravity Flow to Catfish Lift Station W&RRC Granger Creek Lift Station CURRENT INITIATIVES TWIN RIDGE LAGOON ABANDONMENT Twin Ridge Lagoon Abandonment (Under Design) Permit Expires in the spring of 2024 CURRENT INITIATIVES SEWER EXTENSION TO TAMARACK & DICC Extension to Tamarack Business Park & Dubuque Industrial Center Crossroads (Under Design) Extension Requirement of Agreement with Tamarack Business Park Phase I of Sanitary Sewer to Serve Properties within Dubuque Industrial Center Crossroads (Under Design)Tamarack Business Park CURRENT INITIATIVES DBQ Industrial Center Crossroads SEWER CCTV INSPECTION & CLEANING CURRENT INITIATIVES Pipe Size: Total LF Sewer in GIS: Total LF of Sewer Inspected In GIS (@ the end of 2022): Inspected 4"-6"45,743 26,584 1.57% 8"-12"1,404,168 595,230 35.18% 14"-18"149,953 31,878 1.89% 20"-27"49,028 7,978 0.46% 30"-42"25,275 5,199 0.30% 48"-54"3,394 -0.00% TOTAL:1,691,863 666,869 39.40% SEWER CCTV INSPECTION & CLEANING CURRENT INITIATIVES Average Repair Costs identified per year –Pipes: ~$250,000 –Manholes: ~$30,000 Cost Summary to Address Sewer Defects Identified during Inspections from 2008 to end of 2022 Pipe Replacements $ 965,883.00 Pipe Rehabilitations $ 2,634,114.86 Pipe Point Repair $ 458,972.00 Pipe Total:$ 4,058,969.86 MH Replacements $ 299,000.00 MH Rehabilitations $ 111,180.00 MH Total:$ 410,180.00 Already CIP in Place (not included in above rows)$ 1,060,163.00 Grand Total:$ 5,529,312.86 SANITARY SEWER UTILITY ASSET MANAGEMENT PLAN CURRENT INITIATIVES –EPA’s Best Practices Guide (EPA 816-F-08-014) –Risk Based Prioritization of Recommended Improvements SANITARY SEWER UTILITY ASSET MANAGEMENT PLAN CURRENT INITIATIVES Design lifespan of sewer per asset age and material based on industry standards. –Exceeds by 50 years or more –Exceeds by 25 to 50 years –Exceeds by 0 to 25 years –No age data available –assumed to exceed –Will exceed within 10 years (by 2033) –Will exceed between 10 to 25 years (2033 to 2058) –Will exceed between 25 to 50 years (2058 to 2073) –Will exceed after 50 years (beyond 2073) –City Limits Brunskill Rd Collector Sewer Reconstruction FY 2024 CIP PROJECT Project FY 24 Project Cost Total Cost FY24-28 Hempstead Sanitary Sewer Reconstruction (CD)$18,000 $375,000 Abbott & Cottage Sanitary Sewer Reconstruction (CD)$15,000 $247,500 Harvard Street Sanitary Sewer Reconstruction (CD)$18,000 $223,000 Cooper Place & Maiden Lane Sewer Reconstruction (CD)$22,000 $398,000 Old Mill Rd LS & FM $5,776,812 $22,243,912 Granger Creek Lift Station & Force Main $240,000 $240,000 Twin Ridge Lagoon Abandonment $926,300 $926,300 Sanitary Sewer Extensions -Existing Development, Pre- annexation/Annexation Agreements $404,200 $404,200 Knob Hill-Duggan Dr Sanitary Reconstruction $18,500 $180,500 Perry & Bradley Force Main $267,000 $267,000 Coates Street Sanitary Sewer Relocation $60,000 $60,000 Brunskill Rd Collector Sewer Reconstruction $300,000 $300,000 Broadway Sanitary Sewer Improvements $112,500 $112,500 General Sanitary Sewer Replacement $200,000 $1,000,000 Manhole Replacement/Rehab Program $52,000 $356,000 FY 2024 CIP PROJECTS ENGINEERING DEPARTMENT STORMWATER MANAGEMENT SYSTEM FISCAL YEAR 2024 BUDGET PRESENTATION DUBUQUE’S MUNICIPAL SEPARATE STORM SEWER SYSTEM (MS4) In Iowa, every property owner is responsible for managing stormwater, accepting runoff from upstream properties and discharging it to downstream properties. –Engineering Department helps design, construct, and maintain minor and major public drainage facilities to manage stormwater on public property (i.e. street right-of-way). DUBUQUE’S MUNICIPAL SEPARATE STORM SEWER SYSTEM (MS4) Since 2003, the City has been subject to a National Discharge Elimination System (NPDES) MS4 Permit as required by the federal Clean Water Act. –The Engineering Department oversees the NPDES MS4 Permit compliance program, the goal of which is to prevent stormwater from collecting and transporting urban pollutants and delivering them into waters of the United States. Petroleum byproducts in the street Sediment in the creek FEDERAL CLEAN WATER ACT COMPLIANCE PROGRAM (NPDES MS4 PERMIT) Development Plans Reviewed: 21 WATER QUALITY & QUANTITY COMPONENTS (January 1, 2022 to January 1, 2023) POST-CONSTRUCTION RUNOFF CONTROLS SITE PLANSSUBDIVISIONS FEDERAL CLEAN WATER ACT COMPLIANCE PROGRAM (NPDES MS4 PERMIT) Construction Site Inspections (January 1, 2022 to January 1, 2023) Inspections: 228 (87 active sites) Initial Compliance: 76.3% Verbal Warnings: 28 Notice of Violation Issued: 1 CONSTRUCTION SITE RUNOFF CONTROLS FEDERAL CLEAN WATER ACT COMPLIANCE PROGRAM (NPDES MS4 PERMIT) WATER QUALITY & QUANTITY COMPONENTS POST-CONSTRUCTION RUNOFF CONTROLS Post-Construction Inspections (January 1, 2022 to January 1, 2023) Inspections: 150 Required Maintenance: 9 Phase Description Status 1 Carter Road Detention Basin Complete 2 West 32nd Street Detention Basin Complete 3 Historic Millwork District Complete 4 Lower Bee Branch Creek Restoration Complete 5 Flood Mitigation Gate & Pump Replacement Under Design 6 Impervious Surface Reduction 1/3 alleys converted to “Green Alleys” 7 Upper Bee Branch Creek Restoration/Railroad Culverts Complete 8 22nd Street Storm Sewer Improvements Complete from Elm Street to N. Main 9 Flood Mitigation Maintenance Facility Site Cleanup/Preparation 10 North End Storm Sewer Improvements Initiate Design in 2028 11 Water Plant Flood Protection Initiate Design in 2024 12 17th Street Storm Sewer Improvements Complete from Elm St. to Heeb St. MAJOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS Phase Description Status 1 Carter Road Detention Basin Complete 2 West 32nd Street Detention Basin Complete 3 Historic Millwork District Complete 4 Lower Bee Branch Creek Restoration Complete 5 Flood Mitigation Gate & Pump Replacement Under Design 6 Impervious Surface Reduction 1/3 alleys converted to “Green Alleys” 7 Upper Bee Branch Creek Restoration/Railroad Culverts Complete 8 22nd Street Storm Sewer Improvements Complete from Elm Street to N. Main 9 Flood Mitigation Maintenance Facility Site Cleanup/Preparation 10 North End Storm Sewer Improvements Initiate Design in 2028 11 Water Plant Flood Protection Initiate Design in 2024 12 17th Street Storm Sewer Improvements Complete from Elm St. to Heeb St. MAJOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS Bee Branch Creek Railroad Culverts Project 2013 Bee Branch Creek Railroad Culverts Project 2013 2022 Bee Branch Creek Railroad Culverts Project 2013 2022 Tunneled Pipes Hike/Bike Trail Bee Branch Creek Railroad Culverts Project Increases flood protection from the 75-year to the 500-year flood MAJOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS Bee Branch Creek Railroad Culverts Project SOURCE AMOUNT1 SRF Loan2 $16,300,000 HUD CDBG National Disaster Resiliency Grant $11,703,000 State Flood Mitigation Program Sales Tax Increment $3,919,300 Stormwater Utility Fee Revenue $194,800 Land & Water Conservation Fund Grant $175,000 TOTAL $32,292,100 1Rounded 2Repaid using State Flood Mitigation Program Sales Tax Increment MAJOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS Bee Branch Creek Railroad Culverts Project SOURCE AMOUNT1 SRF Loan2 $16,300,000 HUD CDBG National Disaster Resiliency Grant $11,703,000 State Flood Mitigation Program Sales Tax Increment $3,919,300 Stormwater Utility Fee Revenue $194,800 Land & Water Conservation Fund Grant $175,000 TOTAL $32,292,100 1Rounded 2Repaid using State Flood Mitigation Program Sales Tax Increment State and Federal Funding: $15,797,300 MAJOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS Phase Description Status 1 Carter Road Detention Basin Complete 2 West 32nd Street Detention Basin Complete 3 Historic Millwork District Complete 4 Lower Bee Branch Creek Restoration Complete 5 Flood Mitigation Gate & Pump Replacement Under Design 6 Impervious Surface Reduction 1/3 alleys converted to “Green Alleys” 7 Upper Bee Branch Creek Restoration/Railroad Culverts Complete 8 22nd Street Storm Sewer Improvements Complete from Elm Street to N. Main 9 Flood Mitigation Maintenance Facility Site Cleanup/Preparation 10 North End Storm Sewer Improvements Initiate Design in 2028 11 Water Plant Flood Protection Initiate Design in 2024 12 17th Street Storm Sewer Improvements Complete from Elm St. to Heeb St. MAJOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS FUTURE INITIATIVES 22nd St./Kaufmann Ave. Storm Sewer Improvements $17.8 million in shovel ready infrastructure improvements July 20, 2016 1.7 inches of rain in 90 minutes 22nd St/Kaufmann Storm Sewer Capacity Improvements Improvements Realized [Looking west up 22nd St/Kaufmann Ave from Central Ave] ~ 5 Year Event July 20, 2016 1.7 inches of rain in 90 minutes July 15, 2022 2.0 inches of rain in 90 minutes 22nd St/Kaufmann Storm Sewer Capacity Improvements Improvements Realized [Looking west up 22nd St/Kaufmann Ave from Central Ave] Between 5 –10 Year Event~ 5 Year Event FUTURE INITIATIVES 17th Street Storm Sewer Improvements $27.6 million in shovel ready infrastructure improvements Completed in 2020 July 15, 2022 2.0 inches of rain in 90 minutes (3.9 inches in 3 ½ hours) 17th/W. Locust Street Storm Sewer Capacity Improvements Improvements Not Yet Fully Realized Phase Description Status 1 Carter Road Detention Basin Complete 2 West 32nd Street Detention Basin Complete 3 Historic Millwork District Complete 4 Lower Bee Branch Creek Restoration Complete 5 Flood Mitigation Gate & Pump Replacement Under Design 6 Impervious Surface Reduction 1/3 alleys converted to “Green Alleys” 7 Upper Bee Branch Creek Restoration/Railroad Culverts Complete 8 22nd Street Storm Sewer Improvements Complete from Elm Street to N. Main 9 Flood Mitigation Maintenance Facility Site Cleanup/Preparation 10 North End Storm Sewer Improvements Initiate Design in 2028 11 Water Plant Flood Protection Initiate Design in 2024 12 17th Street Storm Sewer Improvements Complete from Elm St. to Heeb St. MAJOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS WEST BLUM SITE -EPA CLEANUP GRANT BEE BRANCH FLOOD MITIGATION MAINTENANCE FACILITY Phase Description Status 1 Carter Road Detention Basin Complete 2 West 32nd Street Detention Basin Complete 3 Historic Millwork District Complete 4 Lower Bee Branch Creek Restoration Complete 5 Flood Mitigation Gate & Pump Replacement Pending 6 Impervious Surface Reduction 1/3 alleys converted to “Green Alleys” 7 Upper Bee Branch Creek Restoration/Railroad Culverts Complete 8 22nd Street Storm Sewer Improvements Complete from Elm Street to N. Main 9 Flood Mitigation Maintenance Facility Site Cleanup/Preparation 10 North End Storm Sewer Improvements Initiate Design in 2028 11 Water Plant Flood Protection Initiate Design in 2024 12 17th Street Storm Sewer Improvements Complete from Elm St. to Heeb St. MAJOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS Bee Branch Gate & Pump Replacement Project MAJOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS Bee Branch Gate & Pump Replacement Project MAJOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS Bee Branch Gate & Pump Replacement Project Increase Resiliency by: –Handling the floodwaters from the Bee Branch Creek which provides 500-year protection; –Doubling the pumping capacity; –Providing flexible gate operation to drain the basin under extreme flooding conditions; –Providing easy access to remove debris from the trash racks; and –Providing backup generators to ensure operations during storm events. MAJOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS MAJOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS Bee Branch Gate & Pump Replacement Project MAJOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS Bee Branch Gate & Pump Replacement Project SOURCE AMOUNT1 State Flood Mitigation Program Sales Tax Increment $9,600,000 Stormwater Utility Fee Revenue $2,800,000 SRF Loan $2,600,000 EDA Disaster Recovery Grant $2,500,000 DRA Distribution $1,400,000 TOTAL $18,900,000 1Rounded FUNDING State and Federal Funding: $12,100,000 MAJOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS Bee Branch Gate & Pump Replacement Project Construction Contract $15,790,000 Contingency 720,000 Engineering 2,400,000 Total Project Cost $18,910,000 ESTIMATE MAJOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS Bee Branch Gate & Pump Replacement Project BIDDING Construction Contract $15,790,000 Contingency 720,000 Engineering 2,400,000 Total Project Cost $18,910,000 Low bid was $24,650,000, 56.1% over the $15,790,000 Engineer’s Estimate ESTIMATE Project FY24 FY25 FY26 FY27 FY28 Stormwater Pumping Station $3,910,420 Water Plant Flood Protection System $125,000 Bee Branch Maintenance Facility $225,000 $3,556,000 North End Storm Sewers $800,000 FY 24 -FY 28 CAPITAL IMPROVEMENT PROJECTS BEE BRANCH WATERSHED PROJECTS Funded Flood Mitigation Improvements Cost Carter Road Detention Basin $1,080,000 * West 32nd Street Detention Basin $4,160,000 * Lower Bee Branch Creek Restoration $29,400,000 * Historic Millwork District Complete Streets $7,980,000 * Flood Mitigation Gate & Pump Replacement $18,930,000 ** Upper Bee Branch Creek Restoration $64,230,000 * 22nd Street/Kaufmann Storm Sewer Capacity Improvements $8,570,000 * Bee Branch Creek Railroad Culverts $32,300,000 17th Street/W. Locust Storm Sewer Capacity Improvements $7,500,000 * North End Storm Sewer Capacity Improvements $1,400,000 ** Flood Mitigation Maintenance Facility $5,550,000 ** Water Plant Flood Protection $4,400,000 ** Impervious Surface Reduction (Green Alleys)$57,420,000 ** Bee Branch Healthy Homes $8,430,000 * Total Cost:$250,270,000 ** Total Grant Funding:$167,502,146 Total City Share $82,767,854 *Rounded **Estimated Funded Flood Mitigation Improvements Cost Carter Road Detention Basin $1,080,000 * West 32nd Street Detention Basin $4,160,000 * Lower Bee Branch Creek Restoration $29,400,000 * Historic Millwork District Complete Streets $7,980,000 * Flood Mitigation Gate & Pump Replacement $18,930,000 ** Upper Bee Branch Creek Restoration $64,230,000 * 22nd Street/Kaufmann Storm Sewer Capacity Improvements $8,570,000 * Bee Branch Creek Railroad Culverts $32,300,000 17th Street/W. Locust Storm Sewer Capacity Improvements $7,500,000 * North End Storm Sewer Capacity Improvements $1,400,000 ** Flood Mitigation Maintenance Facility $5,550,000 ** Water Plant Flood Protection $4,400,000 ** Impervious Surface Reduction (Green Alleys)$57,420,000 ** Bee Branch Healthy Homes $8,430,000 * Total Cost:$250,270,000 ** Total Grant Funding:$167,502,146 Total City Share $82,767,854 *Rounded **Estimated Improvements will prevent an estimated $582 million in property damage. Project FY 24 Project Cost FY 24 –28 Project Cost Storm Sewer General Replacements $80,000 $480,000 Storm Sewer Improvements/Extensions $38,000 $286,000 Catch Basin Reconstruction $34,000 $254,000 Bergfeld Pond Outlet Structure $143,000 $143,000 Bee Branch Gate & Pump Replacement $3,910,420 $3,910,420 Water Plant Flood Protection System $125,000 $125,000 FY 24 CAPITAL IMPROVEMENT PROJECTS STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS FY 24 RATE INCREASE 11.11% Proposed Rate Increase over FY 23 $1.00 Monthly Bill Impact for Average Household* *Average Household = $10.00/Month STORMWATER MANAGEMENT UTILITY FEE RATES 1Oridinance 16-14 established following the award of $98.5 million in state sales tax increment funding. 2Ordinance 21-20 established in response to the COVID-19 pandemic. FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 Adopted Per Ordinance 21-12 $8.50 $9.00 $9.00 $9.00 $9.00 $9.00 $9.00 $9.00 $9.00 1Adopted Per Ordinance 16-14 $6.38 $6.81 $7.27 $7.76 $8.29 $8.85 $9.00 $9.00 $9.00 2Adopted Per Ordinance 21-20 $—$—$—$—$—$8.29 $8.29 $8.29 $8.29 Adopted Per Ordinance 10-21 $—$—$—$—$—$—$8.85 $8.85 $8.85 Adopted Per Ordinance 13-22 $—$—$—$—$—$—$—$9.00 $9.00 FY 2024 Recommended $—$—$—$—$—$—$—$—$10.00 % Change From Ordinance 21-12 -24.94%-24.33%-19.22%-13.78%-7.89%-7.89%-1.67%0.00%+11.11% FY 24 RATE COMPARISON (Proposed) Rank City FY24 Rate 10 Des Moines $16.35 9 Dubuque $10.00 8 Cedar Rapids $7.62 7 West Des Moines $7.15 6 Ankeny $6.50 5 Iowa City $5.50 4 Ames $5.20 3 Waterloo $5.00 2 Davenport $3.15 1 Sioux City $2.80 Average w/o Dubuque $6.59 STORMWATER UTILITY FEE -SUBSIDY Since the establishment of the City’s Stormwater Management Utility in 2003, the budget has included a general fund subsidy for property tax exempt organizations (50%), low-to-moderate income residents (50%), and residential farms (75%). FY 24 Subsidy Property Tax Exempt Customers (~120)$458,550 Low -to-Moderate Income Customers (~380)$23,885 Residential Farm Customers (~20)$12,775 Fiscal Year Total $495,210 ENGINEERING DEPARTMENT MAJOR STREET CONSTRUCTION FISCAL YEAR 2024 BUDGET PRESENTATION RIGHT OF WAY MANAGEMENT •Public Works ADA Ramp Replacements ◦160 ramps replaced •Stumps and Sidewalk Replacement (Emerald Ash Borer Related) ◦100 stumps removed •Right of Way permits processed ◦651 Permits -180% increase •Iowa One-Call Tickets ◦8477 -2nd highest total to date RIGHT OF WAY MANAGEMENT •Snow Removal Assistance ◦26 volunteers -4 were city staff ◦41 locations were addressed through volunteers •Snow Letters and Assessments ◦174 letters sent to property owners ◦60 addresses where a contractor cleared www.volunteerdbq.com or www.cityofdubuque.org/snowassistance PRIOR YEAR HIGHLIGHTS •Completion of Stoneman Road •Completion of Chavenelle Road Sidewalks PRIOR YEAR HIGHLIGHTS (Continued) •Awarded the JFK Sidewalks Project •Awarded the Bee Branch Trail Phase 1 •Design of the Chaplain Schmitt Island Connector Trail STREETS –Kerper Court and Kerper Boulevard Roundabout •$1,500,000 Intersection improvement •$750,000 in private funding •$750,000 in City Funding STREETS –Chaplain Schmitt Island Connector Trail •$890,000 Trail Project ◦$615,000 in Federal Community Project Funds ◦Includes a trail head area and ADA spaces STREETS –Bee Branch Trail –Phase 1 •$732,000 ◦10’ Wide PCC Trail ◦1st Phase Project. ◦Future Phases would make connections to Millwork District and Chaplain Schmitt Island STREETS –JFK Sidewalks Project •Project will begin in April 2023 •Total Project Cost: $633,226 STREETS -Heeb Street •$300,000 Street related costs ◦New Pavement, Curb and Gutter, Intakes, Sidewalk ◦Replace water main ◦Replace lead water services ◦Replace sanitary sewer PAVEMENT REHABILITATION & PRESERVATION Concrete Street Repair, Mill & Asphalt Resurface LORAS AUBURN North Grandview Pavement Rehabilitation FY23 BALANCE FY24 BUDGET $ 906,000 $ 0.0 •Significant Concrete Slab and Pavement Joint Deterioration •Major Rehabilitation to Extend the Service Life and Reduce Annual Maintenance Cost Concrete Joint Deterioration AVERAGE DAILY TRAFFIC 6500 VPD Plaza & Holiday Drive Intersection Reconstruction Project FY 24 Cost Total Project Cost East -West Corridor Capacity Improvements $2,792,880 $5,481,806 Dubuque Industrial Center Crossroads $950,000 $1,790,000 Street Construction General $100,000 $450,000 Kerper Court and Kerper Boulevard Roundabout $750,000 $1,500,000 Pavement Marking $170,000 $855,000 Brick Paver Maintenance $55,000 $201,000 Sidewalk Inspection Program -Assessable $40,000 $205,000 Sidewalk Program City Owned $190,000 $615,394 FY 2024 CAPITAL IMPROVEMENT PROJECTS Streets NW ARTERIAL -REHABILITATION & RECONSTRUCTION Project Development: TOJ -State of Good Repair STARTED 2022 COMPLETE 2023 •Component of Dbq County BUILD Grant Safety Improvements to John Deere Rd •$5,672,000 Iowa DOT Transfer of Jurisdiction State of Good Repair Payment to City •Major Rehabilitation of NW Arterial between US20 to JFK •Asbury & Penn Intersection Reconstruct COMPLETED COMPLETED PROJECT FUNDING DOT State of Good Repair Payment $ 5,672,000 DMATS STBG SWAP Funds $ 3,000,000 PROJECT BUDGET $ 8,672,000 2023 2023 2023 •August 2019 City received FHWA final closure acceptance for defederalization of funds •SWAP Funding Agreement with Iowa DOT in December 2019 EAST -WEST CORRIDOR CAPACITY IMPROVEMENTS Accomplishments •Preliminary Engineering & Environmental Clearance Consultant Selection is currently underway In an effort to advance this Council Top Priority, the City has already completed several capacity and safety improvements: EAST -WEST CORRIDOR CAPACITY IMPROVEMENTS Accomplishments Project Year Cost Property Acquisition 2016 $ 853,305 Grandview -Delhi Roundabout 2016 $ 827,000 Loras -Grandview Traffic Signals 2017 $ 370,300 University -Grandview Roundabout 2018 $ 1,200,000 Total Improvements To-Date $ 3,250,300 EAST -WEST CORRIDOR CAPACITY IMPROVEMENTS Project Development ASBURY UNIVERSITY OF DUBUQUE UNIVERSITY OVERLAP SECTION PRELIMINARY DESIGN “CONCEPT” EAST -WEST CORRIDOR CAPACITY IMPROVEMENTS Project Development PROJECT FUNDING FUNDING SOURCE 2023 2024 2025 2026 2027 2028 STBG SWAP Funds 100%$ 1,040,619 STBG Fed Funds 80%$ 4,390,427 $ 2,128,954 Local Funding 20%$ 401,994 $ 663,926 $ 688,926 $ 300,000 $ 300,000 $ 100,000 Future Grants $ 800,000 $ 500,000 $ 5,833,040 $ 2,792,880 $ 688,926 $ 1,100,000 $ 800,000 $ 100,000 FUNDING SOURCE TOTAL STBG SWAP Funds 100%$ 1,040,619 STBG Fed Funds 80%$ 6,519,381 Local Funding 20%$ 2,052,852 Future Grants $ 1,300,000 TOTAL FUNDING $ 11,314,846 IMPACTS •Effective FEBRUARY 2023, Funding Switch from SWAP Funds (100%) to Federal-Aid (80%/20%) •Required to Allocate an Additional $2 Million as City’s 20% local match EAST -WEST CORRIDOR CAPACITY IMPROVEMENTS Project Development Environmental Resource Phase 1 •Regulatory Agency Coordination •Threatened & Endangered Species •Regulated Materials •Water of the US •FAA Notice •Traffic Noise Study •Low -Income, Minority & Vulnerable Populations •Cultural Resources •Section 106 Historic Properties •Section 4(f) Evaluation FEDERAL NEPA ENVIRONMENTAL CLEARANCE IMPACTS •Environmental Study Phase Elevated to a Federal NEPA Level Clearance •Additional Level of Work, + 8 to 12 Months •Additional Level of Work, Cost + $150,000 Environmental Resource Phase 2 •Environmental Assessment with Individual Section 4(f) Evaluation & FHWA Regional Office ReviewT&E •FONSI with Individual Section 4(f) Evaluation •FONSI Concurrence EAST -WEST CORRIDOR CAPACITY IMPROVEMENTS Development Schedule Preliminary Design NEPA Environmental Property Acquisition Construction $1.04 Million $4 Million $5 Million UNIVERSITY OVERLAP SECTION 2023 2024 2025 2026 Final Design $1.0 Million BUILDING BRIDGES TO EMPLOYMENT AND EQUITY (B2E2) RAISE Planning Grant PLANNING AND DESIGN FOR MULTIMODAL TRANSPORTATION CORRIDOR •14TH STREET RAILROAD OVERPASS BRIDGE •16TH STREET CORRIDOR •ELM STREET CORRIDOR •KERPER BLVD. CORRIDOR Fund Description Percentage Fund Amount RAISE Infrastructure Planning Grant 52.1%$ 2,280,000 Local Funds -City 47.9%$ 1,350,000 Local Funds -DRA Contribution $ 750,000 Total Project Cost 100%$ 4,380,000 SAFE STREETS FOR ALL (SS4A) GRANT Comprehensive Safety Action Plan FUNDING SUPPORTS LOCAL INITIATIVES TO PREVENT DEATH AND SERIOUS INJURY ON ROADS AND STREETS, COMMONLY REFERRED TO AS “VISION ZERO” OR “TOWARD ZERO DEATHS” INITIATIVES •DEVELOPING A COMPREHENSIVE SAFETY ACTION PLAN (ACTION PLAN) •SUPPLEMENTAL PLANNING ACTIVITIES: CONDUCTING PLANNING, DESIGN AND DEVELOPMENT ACTIVITIES FOR PROJECTS AND STRATEGIES IDENTIFIED IN AN ACTION PLAN Fund Description Percentage Fund Amount Safe Streets For All (SS4A) Grant 80.0%$ 200,000 Local Funds -City 12.7%$ 32,000 Partner Funding -Other 7.2%$ 18,000 Total Project Cost 100%$ 250,000 ITS Corridor Development US52 / SOUTHWEST ARTERIAL •Approved Partnership Funding Agreement with Iowa DOT •Fiber Optic Network •Cameras •Sensors •Other Technology Iowa DOT / State of Iowa $ 1,900,000 City Funding FY21 / FY22 $ 100,000 Total Project Cost $ 2,000,000 ENGINEERING DEPARTMENT TRAFFIC OPERATIONS FISCAL YEAR 2024 BUDGET PRESENTATION Breakdown of Duties Traffic Operations Center •Fiber Network and Broadband Expansion •Video Management System •Signal Operations •Traffic Studies and Site Plan Review •Pavement Marking and Signage •Temporary Traffic Control •Street Lighting PRIOR YEAR HIGHLIGHTS •Gathering of City Communications Needs –Then categorized and mapped +300 locations to use during ImOn FTTH Deployment. •Coordination with multiple private partners to expand fiber conduit in the community •Asbury & JFK Signal Reconstruction •Grandview Ave private/public lighting/fiber/camera project – underground completed FUTURE INITIATIVES •STREETS PROGRAM •Southwest Arterial Fiber and Camera Project •Coordinating Fiber to the Home (FTTH)Builds •City Needs Public/Private Joint Communications Build •Intersection Improvements •Jackson & 32nd •Asbury & Carter •Asbury & Chaney •JFK & 32nd Signal Build •Kerper at Kerper Court •Seippel at Airborne FIBER EXPANSION FIBER HAS MANY USES •Transportation •Economic Development •Public Safety •Communications •Monitoring City Assets FIBER TO THE HOME Proposed ImOn 2023 Expansion (Stats from ImOn) •31 Cabinets •12,273 Addresses •395,887’ Aerial •360,531’ Underground FIBER EXPANSION AND PARTNERSHIPS City Communications Needs Water Dept Needs SCADA System connecting 1.Pump Stations 2.Wells 3.Water towers FIBER EXPANSION AND PARTNERSHIPS City Communications Needs Parks Department 1.Cameras 2.Buildings 3.Point of Sales FIBER EXPANSION AND PARTNERSHIPS City Communications Needs INET Needs Fiber Communications built to each site to replace expired INET agreement. FIBER EXPANSION AND PARTNERSHIPS City Communications Needs 1.Water Dept Needs 2.INET 3.Waste Water 4.Storm Sewer 5.Parks 6.Traffic 7.Public Safety Cameras Connecting all of this infrastructure with fiber routes is challenging FIBER EXPANSION AND PARTNERSHIPS Major Backbone Components East West Redundancy Backbone Loop Soo Green Fiber Duct FIBER TO THE HOME •Cost savings of partnering with Fiber To The Home Deployments •Typical Cost of $15- $50 a foot installation when building alone. •$5-$7 a foot when jointly installed. •Rock and Rubble charges are split. ◦Sidewalks & Curb Ramps ◦Street Signs ◦Pavement ◦Retaining Walls ◦Street Lighting ◦Electrical & Fiber ◦Storm Sewer ◦Sanitary Sewer ◦Drain Tile ◦Irrigation ◦Impervious Areas FIBER EXPANSION Right of Way (ROW) Preservation Space is limited FIBER EXPANSION –Broadband Group ◦Goal of this group: Accelerate broadband via public/private collaborations ◦Strategy: Reduce costs & time for investment, move Dubuque ahead of the line. ◦Action: Process streamlining, revision of regulations, establishing “Master” agreements and templates. ◦Innovations: Infrastructure sharing, capacity collaborations, “living lab” technologies. ◦This broadband expansion has increased competition which will bring the cost down and promote economic growth. * Outcome: Moved Broadband from a community and business Negative to a positive FIBER EXPANSION AND PARTNERSHIPS PUBLIC / PRIVATE PARTNERSHIPS This workflow has drawn in additional providers including: FY 24 CAPITAL IMPROVEMENT PROJECTS Traffic Operations Fiber and Broadband Projects FY 24 Cost ARPA (America Rescue Plan) Fiber Funding Phase 1 $1,600,000 Fiber Optic Conduit -Misc $12,500 INET Replacement Build Out $65,000 Broadband Acceleration and Universal Access $50,000 Fiber Infrastructure Management System $10,000 STREETS (SMART TRAFFIC ROUTING WITH EFFICIENT & EFFECTIVE TRAFFIC SYSTEMS) STREETS –Major Milestones Approx 30 Month Project Currently building model of entire city. Estimated completion is targeted for April 1, 24 VIDEO MANAGEMENT SYSTEM All city cameras are on one platform (Milestone) including County and School District. City owns /operates 1350 cameras in 255 locations 30 days recording retention. CRIMES CLEARANCE RATES *In criminal justice, clearance rate is calculated by dividing the number of crimes that are "cleared" (a charge being laid) by the total number of crimes recorded. Clearance rates are used by various groups as a measure of crimes solved by the police. To the left are 2019 figures This year we are at 94.75% Camera Projects FY 24 Cost Public Safety Camera Installation $30,000 FY 24 CAPITAL IMPROVEMENT PROJECTS Traffic Operations Signal Operations Operations and Maintenance of the following systems: •Communications network between 115 signals •Central management software •Battery backup systems •Emergency Vehicle Pre-Emption (EVP) system •Vehicle Detection Systems •Intelligent Transportation Systems (ITS) improvements •Road Side Units (RSU’s) Signal Operations Regular daily duties related to signal operations include: •Maintenance and replacement of communications systems •Central Management Software updates (TACTICS/CMS) •Signal knockdowns and reprogramming of equipment •Emergency Vehicle Pre-Emption (EVP) programming and Maintenance •Intersection Detection Maintenance •Travel time sensors and software •Intelligent Transportation Systems (ITS) improvements •Flashing beacons for speed control in school zones •Equipment purchasing for replacement schedules •Traffic impact study reviews •Traffic safety audits •Signal Warrants Traffic Signal Projects FY 24 Cost Signalization Program $25,000 Traffic Mastarm Retrofit $25,000 Traffic Signal Interconnect Conduit Replacement $20,000 Traffic Signal Controller Replacement Project $30,000 Street and Traffic Knockdown Fund $20,000 Traffic Signal Intersection Reconstruction $25,000 ITS Traffic Control Equipment $17,000 Traffic Signal Vehicle Detection Conversion $20,000 Emergency Preemption Expansion and Upgrades $10,000 Traffic Signal Network Equipment $50,000 Total $242,000 FY 24 CAPITAL IMPROVEMENT PROJECTS Traffic Operations Traffic Signal Intersection Projects FY 24 Cost East West Corridor Capacity $2,792,000 Kerper Blvd/Court Roundabout $1,500,000 JFK & 32nd Intersection Reconstruction $612,000 STREETS Traffic Control Project $50,000 Total $4,954,000 FY 24 CAPITAL IMPROVEMENT PROJECTS Traffic Operations Security Transportation Parking Street Lighting Health Communications Education Water Waste Management EnergySMART Image Sources: Choi_ Nikolai; Have a nice day; Smile Studio AP; WALL-E/stock.adobe.com Dubuque vitality and resiliency through a technology driven smart city approach Traffic Engineering: Traffic Studies & Warrants •DRT: Traffic Studies 2022 –9 total •Mozena Farms •JFK (near 32nd St) Retail Center •Plaza 20 –Full Buildout •Misc –Signage, Streetlighting & Fiber design review for subdivisions •46 completed ROW visibility requests •10 studies for Traffic Data Traffic Engineering: Temporary Traffic Control •Contractor TTC review and check –40+ •When is Traffic Control needed? •Water Dept •Public Works •Private Contractors •Engineering Projects •Special Events •Oversized Permits/Routes ENGINEERING DEPARTMENT FACILITIES MANAGEMENT FISCAL YEAR 2024 BUDGET PRESENTATION PRIOR YEAR HIGHLIGHTS Office of Shared Prosperity Old Engine House Construction Cost: $321,500 PRIOR YEAR HIGHLIGHTS Downtown City Facilities Study RESPONSIBILITIES FACILITIES MANAGEMENT BUILDINGS: •City Hall •City Hall Annex •Multicultural Family Center •Historic Federal Building •18th & Central Old Engine House •5th & Bluff Bathrooms + Vacant Lease Locations Other Department Assistance: •Fire Department •Sustainability Office •Information Services – Broadband/Telcom Structures FY 24 CAPITAL IMPROVEMENT PROJECTS FACILITIES MANAGEMENT Project FY 24 Cost Total Project Costs Federal Building Renovation $1,788,725 $4,695,000 Federal Building Parking Lot Reno $825,000 $312,500 Engr. Dept. Materials Testing Lab $63,500 $63,500 City Hall HVAC Systems Controls $65,000 $80,000 City Hall Tuck Pointing Maint.$75,000 $113,500 MFC HVAC Equip. Mods $22,000 $87,500 MFC Building Envelope Stabilization $19,500 $61,500 City Annex –Roof Replacement $17,500 $82,500 City Annex –Window Replacement $18,000 $75,000 ADA Compliance $50,000 $150,000 FEDERAL BUILDING RENOVATION •Energy Study & HVAC Equipment Upgrades •Penthouse Roof Replacement •Loading Dock Structural Repairs •Back Parking Lot Paving Scope of Work: ENGINEERING DEPARTMENT MISCELLANEOUS IMPROVEMENTS FISCAL YEAR 2024 BUDGET PRESENTATION Project Management Support to Other Departments: •Fire Station 6 –External Stairwell Addition •Comiskey Park Renovation •Iowa & Locust Parking Ramp Repairs •Lift Station SCADA Upgrades •W&RRC High-Strength Waste Receiving & Storage •CSPL Roof Restoration CURRENT INITIATIVES Smart Parking & Mobility Management Plan Schmitt Island Development Plan Railroad Quiet Zone Study Project Budget:$60,100 Electric Vehicle Charging EPA -Multipurpose Grant $800,000 grant funds $40,000 local match South Port Redevelopment RIVERFRONT LEASE REVENUE Estimated Riverfront Revenue Riverfront Rent = $3,898,000 Wharfage = $154,000 Land Rent = $189,000 PORT OF DUBUQUE -RIVERFRONT DOCK EXPANSION Project Development CONTINUE REGULATORY AGENCY COORDINATION •US ARMY CORPS OF ENGINEERS •US FISH & WILDLIFE SERVICE •IOWA DNR •US COAST GUARD REGULATORY AGENCY REQUIREMENTS •MUSSEL SURVEY •HYDRAULIC MODELING •PLACE BUOYS IN MAIN CHANNEL TO REPLICATE THE LOCATION OF THE DOCKED RIVERBOATS SO THAT COE CAN SOLICIT INPUT FROM THE BARGE FLEET INDUSTRY •GEOTECHNICAL RIVER BORINGS Support Tourism Growth Destination Port of Call PORT OF DUBUQUE -RIVERFRONT DOCK EXPANSION ARRIVAL SEPT 6, 2022 VIKING MISSISSIPPI 4 BOATS SEPT 14, 2022 DUBUQUE ICE ARENA SETTLEMENT REMEDIATION 473 DEEP FOUNDATION COMPACTION GROUT COLUMNS UNDER BLEACHERSLOCKER ROOMARENA DUBUQUE ICE ARENA SETTLEMENT REMEDIATION BUDGET (FY23)$ 4,600,000 FINAL COST $ 4,300,000 REFRIGERATED CONCRETE FLOOR ICE COOLANT PIPING 1ST ICE USE OCT 28, 2022 SPORT FLOOR REOPENED TO PUBLIC NOV 2, 2022 THANK YOU www.cityofdubuque.org/Engineering Discounted City Utilities Program The City offers income-qualified residential customers a reduction in monthly fees for all four City utilities (water, sanitary sewer, refuse collection, and storm water) of up to 50% of the base rate. Customers must submit an application for consideration and applications are renewed on an annual basis. Learn more and fill out a short application at: www.cityofdubuque.org/utilitiesdiscount or call 563.589.4144 You may be eligible for DISCOUNTED OR FREE INTERNET through the Affordable Connectivity Program (ACP). Struggling to afford internet? How It Works ACP gives a discount on your household’s monthly internet service. Participating internet service providers will apply this discount directly to your service plan. If eligible, your household can receive: • $30 per month discount on wireless internet plans and a free phone • OR $30 per month discount on wired internet service to your home • One-time discount of up to $100 for a laptop, tablet, or desktop computer. A small fee will be required. Your household may be eligible if someone in the household: • Receives SNAP, Medicaid, or other government benefits, or • Meets income guidelines, or • Goes to a school where they receive free or reduced-price lunch and breakfast. Find out if you qualify and how to participate at acp.cityofdubuque.org If you don’t have access to a computer or internet to apply, free access is available at Carnegie-Stout Public Library.