Loading...
FY25 Policy Book 7.1FISCAL YEAR 2025 Recommended Policy And Narrative Budget TABLE OF CONTENTS April 9, 2024 Virtual Meeting - GoToMeeting - Access Code: 337-661-181 or by calling 1.877.568.4106 (toll free) DEPARTMENT/DIVISION OPERATING BUDGET PAGE CIP PAGE Five Flags Civic Center 1 37 Grand River Center 21 45 ImOn Arena 33 52 Transportation Services 43 265 Engineering 84 164 -i- This page intentionally left blank. -ii- HOW TO USE THIS POLICY BUDGET DOCUMENT PURPOSE The Policy Budget defines goals and objectives for all City departments and activities, relates them to cost and resource requirements and attempts to establish measures for evaluating accomplishment. Specific improvement packages are developed and included in the Policy Budget for alternative funding and service levels. The Policy Budget document shows the budget by line item for each Department and provides a basis for fiscal control once the budget is adopted. The Policy Budget emphasizes objectives, accomplishments, and alternative funding and service levels and is intended to keep the attention of the City Council and public on the major policy decisions involving what services the City government will provide, who will pay for them, and the implications of such decisions. FORMAT The Policy Budget is organized by Department/Division and provides detail for all activities that make up each Department/Division. Each Department/Division tab includes the following information: 1)Department/Division Financial Summary: The budget highlights portion of the Department Summary reflects total expenses for the maintenance level budget (cost to continue at the same level of service) and approved improvement packages for all activities within the Department by expenditure category (employee expense, supplies and services, machinery and equipment, and debt service), and the funding sources that pay those expenses. The property tax portion of the funding is reflected, noting the increase or decrease from the prior years adopted budget. For Departments which are self supporting (i.e. Water, Water Resources & Recovery Center, Refuse and Salt Operations (part of Public Works), Media Service, Transit, Parking, Stormwater (part of Engineering)), the net operating surplus/deficit is reflected, noting the increase or decrease in the fund from the prior years adopted budget. This summary displays all Improvement Packages submitted by Department/Division Managers, with a notation of whether they were recommended by the City Manager, and then approved by the City Council. Those noted with a ‘YES’ were added to the maintenance level budget and are reflected in the Department Funding Summary and those noted with a ‘NO’ were not approved. And finally, this summary explains significant line item detail by expenditure category, notable revenue changes, and miscellaneous information regarding the maintenance level budget. These are the review notes prior to adding any improvement packages. 2)Memo Addressing Budget Issue (optional): If there is an important budget issue that needs further explanation, a memo will be provided. 3)Department’s Organizational Chart (optional): Shows how a Department is structured. Usually included for larger more complex Departments. -iii- 4)Department/Division’s Highlights of Prior Year’s Accomplishments and Future Initiatives: This is a written narrative that highlights the Department’s prior year accomplishments and what Departments plan on accomplishing in the near future. 5)Department/Division’s Goals and Performance Measures by Activity: This is a written activity statement and a matrix for each activity which includes activity objectives, relationship to City Council Goals & Priorities, and key performance indicators (KPIs).. Performance measures are included for each activity to evaluate activities and ensure that the approved levels of funding yield the expected results. Icons for each KPI visually indicate how well an objective is doing and represent the following: Goal Met Goal in Progress Goal Not Met This goal has been met. The goal has not been met but is showing signs of improvement. This goal has not been met and is not currently showing signs of progress. 6)Recommended Operating Revenue Budget by Department/Division: This report reflects line item revenue detail at the Department/Division level (combines all activities for each line by fund). Two years actual revenues, prior year adopted revenues and the recommended revenue for the new budget year are reflected. 7)Recommended Operating Expenditure Budget by Department/Division: This report reflects line item expenditure detail at the Department/Division level (combines all activities for each line by fund). Expenses are grouped by category (employee expense, supplies and services, machinery and equipment, debt service, and transfers) and displays two years actual expenses, prior year adopted expenses and the recommended expense for the new budget year. 8)Recommended Operating Expenditure Budget by Activity and Funding Source: This report reflects expenses grouped by category (employee expense, supplies and services, machinery and equipment, debt service, and transfers) for each activity within the Department/ Division, and displays two years actual expenses, prior year adopted expenses and the recommended expense for the new budget year. 9)Personnel Complement at Department/Division and Activity Level: These reports reflect positions budgeted at the Department/Division level and the Activity level, by funding source. Total Full Time Equivalents (FTE) and wages with longevity expense are shown for each position for two years prior year adopted FTE and expenses, and the recommended FTE and related expense for the new budget year. 10)Capital Improvement Projects by Department/Division: This report lists all Capital Improvement Project totals for two years actual expenses, prior year adopted expenses and the recommended expense for the new budget year. 11)Five Year Capital Improvement Program Summary by Department/Division: This report lists all Capital Improvement Projects budgeted in the new budget year and planned for the next four years. Reference:Key Terms for Understanding Dubuque’s Budget, Budget Glossary Budget Overview and Budget and Fiscal Policy Guidelines located in Citizen’s Guide -iv- Five Flags -1- This page intentionally left blank. -2- FIVE FLAGS CIVIC CENTER DIVISION Budget Highlights FY 2023 Actual FY 2024 Budget FY 2025 Requested % Change From FY 2024 Budget Expenses Employee Expense 27,695 28,694 30,359 5.8 % Supplies and Services 1,248,189 1,100,772 1,136,325 3.2 % Machinery and Equipment 202,895 192,775 320,070 66.0 % Total Expenses 1,478,779 1,322,241 1,486,754 12.4 % Debt on Projects paid with Sales Tax Fund (20%) 41,887 42,748 41,688 -2.5 % Property Tax Support 1,478,779 1,322,241 1,486,754 164,513 Percent Increase (Decrease) 12.4 % Personnel - Authorized FTE 0.15 0.15 0.15 *Actual Benchmark for FY 2024 is $1,145,634. Significant Line Items Background 1.History: The City has contracted the firm, ASM Global (formerly SMG), after Council approval in April 2004, to privately manage Five Flags Civic Center. ASM Global’s original five year private management agreement began on July 1, 2004 and ended June 30, 2009. The current agreement expired June 30, 2014 and was extended for another five-year period ending June 30, 2019. It was then again extended for a five-year period ending June 30, 2024. The City will be issuing an RFP for management services, similar to the process used regarding a management contract for Grand River Center. Five Flags Civic Center has been managed by the same vendor for 20 years. Continued on next page -3- Property Tax Support ($) Five Flags Property Tax Support $1,486,754 $1,322,241 $1,478,799 $1,007,640 $1,053,937 $1,336,354 $1,045,113 $828,944 $869,086 $892,848 $853,128 $836,510 $825,314 $824,243 $783,331 $792,493 $782,198 $758,136 $763,782 $594,899 $793,899 $645,162 $705,858 Recurring Costs Nonrecurring Costs FY 202 5 B u d g et R e q u e st FY 202 4 B u d g et FY 202 3 FY 202 2 FY 202 1 FY 202 0 FY 201 9 FY 201 8 FY 201 7 FY 201 6 FY 201 5 FY 201 4 FY 201 3 FY 201 2 FY 201 1 FY 201 0 FY 200 9 FY 200 8 FY 200 7 FY 200 6 FY 200 5 FY 200 4 FY 200 3 $600,000$675,000$750,000$825,000$900,000$975,000$1,050,000$1,125,000$1,200,000$1,275,000$1,350,000$1,425,000$1,500,000$1,575,000*ASM Global (formerly SMG) took over managing Five Flags on July 1, 2004. –FY 2020 included Five Flags Assessment and Study in amount of $82,800, a one-time cost. It also included a $17,565 expense for the shortfall to the benchmark in FY 2019 as well as $200,000 shortfall to benchmark payment during FY 2020 due to the full closure of Five Flags in March of 2020 due to the COVID-19 pandemic. This also includes $50,949 for equipment replacement items. –FY 2021 included the soils study to help inform the Phase 2A Study for $20,000 and $14,890 replacement of speakers damaged by water not covered by insurance. -4- –FY 2022 budget initially included $79,700 in replacement equipment purchases. This year also included improvement packages approved including AED's and backflow preventer, as well as a $58,000 carryover from FY 2021 for expenditures for Arts Council COVID relief grant. FY 2022 actuals included $58,074 for equipment replacements. ASM Global's performance was under benchmark in FY 2022, accounting for lower recurring expenses. –FY 2023 included $202,895 in replacement equipment purchases and $142,000 in shuttered venue grant expenditures. –FY 2024 budget includes $192,775 in replacement equipment purchases. –FY 2025 budget includes $320,070 in replacement equipment purchases. Employee Expense 2.FY 2025 employee expense reflects a 5.00% wage package increase. 3.The Iowa Public Employee Retirement System (IPERS) City contribution of 9.44% is unchanged from FY 2024. The employee contribution of 6.29% is unchanged from FY 2024. Supplies & Services 4.Benchmark Calculation: The benchmark is the amount of property tax needed to operate the Five Flags Civic Center (this amount is set by the City for ASM Global). The original benchmark and formula for adjustment was established in the 2004 agreement with ASM Global. ASM Global is challenged to spend less than the Benchmark, thereby reducing the amount of property tax support needed. The benchmark is calculated by taking total expense, less earned revenue for the Civic Center, to get the property tax support. This calculation was completed in the beginning by taking the average actual property tax support spent in FY 2002, 2003, and 2004 ($682,091) and then increased annually by an inflation factor. This amount includes ASM Global’s projected management fee of $123,255 in FY 2025. The Benchmark fee is set for the purpose of the budget with an estimated Consumer Price Index (CPI) and then adjusted by the actual May CPI after the budget is adopted to arrive at the actual Benchmark and management fee. 5.ASM Global's goal is to come in under the benchmark, but if the benchmark is not met, the City of Dubuque must pay any amount over the benchmark. ASM Global's incentive to meet the benchmark gives them $.50 of every dollar under the benchmark. Annual Benchmark Set for ASM Global: In FY 2014 the benchmark was $852,040 (prior year plus the May CPI of 1.4%), in FY 2015 the benchmark was $869,933 (prior year plus the May CPI of 2.1%), in FY 2016 the benchmark was $869,933 (prior year plus the May CPI of 0%), in FY 2017 the benchmark was $878,632 (prior year based on May CPI of 1%), in FY 2018 the benchmark was $895,326 (prior year based on May CPI of 1.9%), in FY 2019 the benchmark was $920,395 (prior year based on May CPI of 2.80%), in FY 2020 the benchmark was $936,962 (prior year based on May CPI of 1.80%), in FY 2021 the benchmark was $937,899 (prior year based on May CPI of 0.10%), in FY 2022 the benchmark was $984,794 (prior year plus May CPI of 5.00%), in FY 2023 the benchmark was $1,069,486 (prior year based on May CPI of 8.60%), in FY 2024 the benchmark was $1,112,266 (prior year based on May CPI of 4.00%), in FY 2024 the benchmark was $1,112,961 (prior year based on May CPI of 4.00%) and -5- the FY 2025 benchmark is anticipated to be $1,145,634 (prior year and anticipated May CPI of 3.00%). Actual Benchmark: It should be noted that the first year (FY 2005) of management, actual expenses were higher due to the transitioning of the employees. There were additional costs relating to unemployment insurance, vacation payoffs and prior year expenses that did not count against the benchmark. The Five Flags Civic Center was also under renovation soon after SMG (ASM Global) started. It was expected that the first year of management would cost more. Also, the budget was initially set with the management fee ($75,000) added on top of the set benchmark. It was determined that the benchmark should already include ASM Global's management fee, and the actual benchmark was adjusted accordingly with the additional budget going back into General Fund. Fiscal Year$ DollarsASM Global (formerly SMG) Benchmark Payout 88,074 65,446 66,496 (133,689) (17,565) 25,292 3 110 8,937 11,468 10,169 11,220 6,973 6,845 8,238 4,594 50% Benchmark Paid 23 22 21 20 19 18 17 16 15 14 13 12 11 10 09 08 $-150,000 $-125,000 $-100,000 $-75,000 $-50,000 $-25,000 $0 $25,000 $50,000 $75,000 $100,000 This summary of annual results of the benchmark to date reflects ASM Global has met the benchmark since 2006 with the exception of FY 2019 and FY 2020. FY 2019 included a polar vortex weather event affecting utility costs and event financial performance as well as repairs to the facility due to the age and status of the Five Flags building. FY 2020 included the closure of the Five Flags Civic Center due to the COVID-19 pandemic, the Governor's Proclamations in addition to event cancellations and rescheduling into FY 2021. This affected the Five Flags budget from March 2020 to the end of the fiscal year. FY 2020 was on track to be at benchmark prior to the beginning of the pandemic. -6- Fiscal YearProperty Tax Support Compared to Benchmark for Five Flags ASM Global/SMG Benchmark Property Tax Support 25 24 23 22 21 20 19 18 17 16 15 14 13 12 11 10 09 08 07 06 05 $600,000$675,000$750,000$825,000$900,000$975,000$1,050,000$1,125,000$1,200,000$1,275,000$1,350,000$1,425,000$1,500,000When comparing the annual property tax support spent to the benchmark each year the following should be noted. Property tax support includes items not included in the benchmark such as •Replacement equipment such as items like lifts, commercial floor machines, sound systems, chairs. The list is extensive and replaced on a replacement schedule. •Improvement packages that are added to the Five Flags such as the addition of security cameras. •Shortfall payments for not meeting the benchmark in FY 19 and FY20. -7- •Studies or specific operating expenses for example the studies and assessments in FY20 and FY21. •Initial cost of transitioning city employees to SMG in FY05. Machinery and Equipment 6.The total equipment requested for FY 2025 is $320,070: Civic Center Machinery and Equipment Administration Vacuum cleaners $ 1,200 Super Trouper Spotlights $ 67,500 Bike Rack $ 3,000 Bike Rack Barricade 4'$ 2,400 Bike Rack Barricade 6'$ 8,000 Feeder Cable $ 8,000 Tables - Round (mity-lite)$ 19,000 Arena folding chairs (black)$ 70,000 Air Compressor - boiler room $ 3,350 Skid Loader Brush Implement $ 7,200 Dry sprinkler compressor (2000)$ 1,000 Eyewash unit 1 wall mount $ 1,000 Ice machine-Upper Concessions $ 8,000 Pizza warmer 1 $ 2,720 Hobart popcorn popper $ 8,000 Power Distribution box $ 28,200 Roller grill 1 $ 1,500 Wireless Microphones $ 15,000 Arena Lighting Control Board $ 65,000 Total Equipment $ 320,070 Debt Service 1.FY 2025 Annual debt service is as follows ($41,688): Amount Debt Series Payment Source Purpose Final Payment Call Date $ 33,415 2019C G.O.Sales Tax 20%Civic Center Improvements 2030 2026 $ 8,273 2019B G.O.Sales Tax 20%Chair Platform Section 3 2039 2039 $ 41,688 Total Civic Center Annual Debt Service -8- LEISURE SERVICES FACILITY DIVISION The Facility Division provides for the effective and efficient maintenance of buildings and equipment and administration of management contracts for Five Flags Civic Center, Grand River Center, and ImOn Arena, ensuring facilities and programs that provide an increased QUALITY OF LIFE and creates opportunities for both citizens and visitors. SUCCESS IS ABOUT PLANNING, PARTNERSHIPS AND PEOPLE LEADING TO OUTCOMES -9- LEISURE SERVICES FACILITY DIVISION FY 2023 FY 2024 FY 2025 Full-Time Equivalent 0.15 0.15 0.15 Property Tax Support $2,033,028.02 $2,436,287 $2,765,921 FY 2023 FY 2024 FY 2025 Property Tax Support $0 $1,000,000 $2,000,000 $3,000,000 The Leisure Services Facilities Division is supported by 0.15 full-time equivalent employees. Supplies and services accounts for 76.47% of the department expense as seen below. Overall, the department's expenses are expected to increase by 13.62% in FY 2025 compared to FY 2024. Expenditure by Category by Fiscal Year $27,695 $1,779,152 $203,976 $28,694 $2,051,124 $327,775 $30,359 $2,114,983 $590,220 FY 2023 FY 2024 FY 2025 Employee Expense Supplies and Services Machinery and Equipment $0$500,000$1,000,000$1,500,000$2,000,000-10- LEISURE SERVICES FACILITY DIVISION Mission & Services The Facility Management Division of the Leisure Services Department strives to provide venues for community and civic activities, entertainment, recreational, and cultural events and activities. The division promotes events and activities that bring tourists and generate spending in the community and ensure the centers are well-maintained and professionally managed to ensure attendees have a positive experience. Five Flags Civic Center is a City owned building managed day-to-day by ASM Global located in the heart of downtown. It is a multipurpose facility which hosts sporting events, theatrical performances, concerts, meetings and conventions, sporting events and much more. Five Flags Civic Center features an arena, historic theater, meeting rooms and intimate performance stage called the Bijou Room. The Grand River Center is a City owned building managed by OVG360. Dubuque’s iconic convention and education center is located in the Port of Dubuque overlooking the Mississippi River and Riverwalk. The conference center has meeting rooms, a ballroom and exhibit hall allowing a variety of uses of the space for large and small events. The ImOn Arena is a city owned building managed by Schmitt Island Development Corporation. The facility has one United States Hockey League size sheet of ice with seating for 3,200. The arena hosts ice sports events tournament and games. Leisure Services initiates capital improvement projects and equipment purchases for these facilities ensuring the long-term viability and functionality of these buildings. Five Flags Civic Center Funding Summary FY 2023 Actual FY 2024 Budget FY 2025 Recomm'd Expenditures $1,478,779 $1,322,241 $1,486,754 Resources $5,426 $0 $0 Five Flags Civic Center Position Summary FY 2025 Leisure Services Director 0.15 Total FT Equivalent Employees 0.15 Grand River Center Funding Summary FY 2023 Actual FY 2024 Budget FY 2025 Recomm'd Expenditures $554,249 $1,114,046 $1,279,167 Resources $—$—$— -11- Grand River Center Position Summary FY 2025 Leisure Services Director 0.15 Total FT Equivalent Employees 0.15 ImOn Arena Funding Summary FY 2023 Actual FY 2024 Budget FY 2025 Recomm'd Expenditures $422,526 $373,255 $428,029 Resources $52,252 $—$— Performance Measures City Council Goal: Partnerships for a Better Dubuque Performance Measure (KPI)Target FY 2022 Actual FY 2023 Actual FY 2024 Estimated Performance Indicator 1 Activity Objective: Become a regional hub for arts and culture by partnering with arts & culture organizations and providing Arts and Culture events and programming. % change from prior year in performing arts programming held at Five Flags +.5%+2%+8.2%+.5 Goal Met 2 Activity Objective: Host community events and activities that support families and children. GRC, FF and ImOn Arena Combined # of unique performances and events 80 78 49 80 Goal Met # of events that supported fundraisers benefiting families & children 15 13 24 20 Goal Met 3 Activity Objective: Maintain infrastructure and amenities to support economic development and growth. # of attendees at Annual Growing Sustainable Communities Conference (number of states represented) 400/20 0/0 (actual) * 380/18 + Canada (Actual) 380/18 Goal In Progress *Note - In October of 2020 (FY21) and 2021 (FY22) the Growing Sustainable Communities Conference was cancelled due to the ongoing pandemic and health concerns. The Sustainability Conference was moved from October 2022 in FY23 to April 2024. FY19 had 425 attendees from 28 states and Canada, FY20 had 482 attendees from 27 states. -12- Recommended Operating Revenue Budget - Department Total 32 - CIVIC CENTER Fund/Account/Account Title FY22 Actual Revenue FY23 Actual Revenue FY24 Adopted Budget FY25 Recomm'd Budget 100 - General 4A - Charges for Services 47150 - Refunds 0 (5,426) 0 0 4A - Charges for Services Total 0 (5,426) 0 0 4B - Grants/Contrib 44000 - Federal Grants (362,080) 0 0 0 44400 - State Grants 0 0 0 0 4B - Grants/Contrib Total (362,080) 0 0 0 200 - Debt Service 4N - Transfers 49304 - Transfer in Sales Tax 20%(44,065)(41,887)(42,748)(41,688) 4N - Transfers Total (44,065)(41,887)(42,748)(41,688) 4O - Eliminated for GW 48200 - Proceeds from GO Debt 0 0 0 0 48205 - Bond Discount/Premium 0 0 0 0 4O - Eliminated for GW Total 0 0 0 0 CIVIC CENTER - Total (406,145)(47,313)(42,748)(41,688) -13- 6A - Salaries & Wages 100 - General 60100 - Salaries-Regular Full Time 20,892 21,750 22,746 23,974 60635 - Special Pay Sick Lv Payout 50% 0 196 0 206 6A - Salaries & Wages Total 20,892 21,946 22,746 24,180 6B - Employee Benefits 100 - General 61100 - FICA - City Contribution 1,549 1,633 1,740 1,850 61300 - IPERS - City Contribution 1,972 2,053 2,147 2,263 61510 - Health Insurance 1,955 2,014 2,013 2,013 61540 - Life Insurance 8 7 7 7 61600 - Workers' Compensation 37 42 41 46 6B - Employee Benefits Total 5,522 5,749 5,948 6,179 6D - Repair/Maint/Util 100 - General 63730 - Telecommunications 41 42 42 42 6D - Repair/Maint/Util Total 41 42 42 42 6E - Contractual Svcs 100 - General 64070 - Engineering - Outsourced 932 0 0 0 64080 - Insurance - Property 30,460 36,091 40,293 58,667 64081 - Insurance - Liability 81 97 72 114 64110 - Legal 0 2,083 0 0 64130 - Payments to Other Agencies 880,913 1,200,787 1,047,967 1,065,309 64140 - Printing 0 0 348 348 64145 - Copying 2,954 2,725 2,950 2,725 64190 - Technology Services 0 0 0 0 64850 - Consulting Engineers 0 0 0 0 64900 - Other Professional Service 0 0 0 0 64975 - Equip Maint Cont 6,365 6,365 7,300 7,296 64980 - Technology Equip Maint Cont 1,407 0 1,800 1,824 200 - Debt Service 64110 - Legal 0 0 0 0 64900 - Other Professional Service 0 0 0 0 6E - Contractual Svcs Total 923,111 1,248,147 1,100,730 1,136,283 6F - Commodities 100 - General 65045 - Technology Equipment 0 85,238 32,900 80,000 65050 - Other Equipment 0 6,500 125,375 240,070 65054 - Safety Equipment 0 4,844 4,500 0 65060 - Office Supplies 0 0 0 0 65110 - Signage 0 0 0 0 6F - Commodities Total 0 96,582 162,775 320,070 6G - Capital Outlay 100 - General 67100 - Vehicles 0 0 0 0 Recommended Operating Expenditure Budget - Department Total 32 - CIVIC CENTER Fund/Account/Account Title FY22 Actual Expense FY23 Actual Expense FY24 Adopted Budget FY 25 Recomm'd Budget -14- 67210 - Furniture/Fixtures 0 0 30,000 0 67270 - Other Capital Equipment 58,074 106,313 0 0 6G - Capital Outlay Total 58,074 106,313 30,000 0 6H - Debt Service 200 - Debt Service 68010 - Principal Payment 34,603 33,463 35,328 35,328 68020 - Interest Payments 9,462 8,424 7,420 6,360 68990 - Paying Agent Fees 0 0 0 0 6H - Debt Service Total 44,065 41,887 42,748 41,688 CIVIC CENTER - TOTAL 1,051,705 1,520,667 1,364,989 1,528,442 Recommended Operating Expenditure Budget - Department Total 32 - CIVIC CENTER Fund/Account/Account Title FY22 Actual Expense FY23 Actual Expense FY24 Adopted Budget FY 25 Recomm'd Budget -15- Recommended Expenditure Budget Report by Activity & Funding Source 32 - CIVIC CENTER Fund/Activity FY23 Actual Expense FY24 Adopted Budget FY25 Recomm'd Budget 3201 - Administration 100 - General 6A - Salaries & Wages 21,946 22,746 24,180 6B - Employee Benefits 5,749 5,948 6,179 6D - Repair/Maint/Util 42 42 42 6E - Contractual Svcs 1,248,147 1,100,730 1,136,283 6F - Commodities 96,582 162,775 320,070 6G - Capital Outlay 106,313 30,000 — 3201 - Administration Total 1,478,779 1,322,241 1,486,754 3280 - Debt Service 200 - Debt Service 6E - Contractual Svcs ——— 6H - Debt Service 41,887 42,748 41,688 3280 - Debt Service Total 41,887 42,748 41,688 CIVIC CENTER TOTAL 1,520,667 1,364,989 1,528,442 -16- C I T Y O F D U B U Q U E , I O W A DEPARTMENT DETAIL - PERSONNEL COMPLEMENT 32 CIVIC CENTER DIVISION FY 2023 FY 2024 FY 2025 FD JC WP-GR JOB CLASS FTE BUDGET FTE BUDGET FTE BUDGET 61010 Full Time Employee Expense 100 3375 GE-44 LEISURE SERVICES DIRECTOR 0.15 $ 21,746 0.15 $ 22,746 0.15 $ 23,974 TOTAL FULL TIME EMPLOYEES 0.15 $ 21,746 0.15 $ 22,746 0.15 $ 23,974 TOTAL CIVIC CENTER DIVISION 0.15 $ 21,746 0.15 $ 22,746 0.15 $ 23,974 -17- Civic Center Administration 10032100 61010 100 3375 GE-41 LEISURE SERVICES DIRECTOR 0.15 $ 21,746 0.15 $ 22,746 0.15 $ 23,974 Total 0.15 $ 21,746 0.15 $ 22,746 0.15 $ 23,974 TOTAL CIVIC CENTER DIVISION 0.15 $ 21,746 0.15 $ 22,746 0.15 $ 23,974 CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2023 FY 2024 FY 2025 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET -18- Capital Improvement Projects by Department/Division CIVIC CENTER DIVISION Project Number Capital Improvement Project Title Department Fund Account FY 24 Recomm'd Budget 3249900001 Five Flags Building Impr Civic Center 305 64004 50,000 3249900001 Five Flags Building Impr Civic Center 305 67500 2,750,000 CIVIC CENTER DIVISION TOTAL 2,800,000 PROGRAM /DEPT PROJECT DESCRIPTION FY 2025 FY 2026 FY 2027 FY 2028 FY 2029 TOTAL PAGE CIVIC CENTER DIVISION Culture and Recreation Five Flags Building Improvements $ — $ 2,800,000 $ 3,094,678 $ 8,587,322 $ 8,972,000 $ 23,454,000 37 Boiler Replacement $ — $ — $ — $ — $ 410,000 $ 410,000 38 TOTAL $ — $ — $ — $ — $ 410,000 $ 410,000 -19- This page intentionally left blank. -20- Grand River Center -21- This page intentionally left blank. -22- GRAND RIVER CONFERENCE CENTER Budget Highlights FY 2023 Actual FY 2024 Budget FY 2025 Requested % Change From FY 2024 Budget Expenses Employee Expense 22,205 28,694 30,359 5.8 % Supplies and Services 530,963 950,352 978,658 3.0 % Machinery and Equipment 1,081 135,000 270,150 100.1 % Total Expenses 554,249 1,114,046 1,279,167 14.8 % Debt on Projects paid with Sales Tax Fund (20%) 29,010 29,469 28,686 -2.7 % Property Tax Support 554,249 1,114,046 1,279,167 165,121 Percent Increase (Decrease) 14.8 % Improvement Package Summary 1 of 1 This improvement package request provides for the addition of 10 cameras in the public areas of GRC. No security cameras are in the public space, entrances or exits. This project includes cameras, cabling and installation. The total cost in FY 2025 ($30,000) will go towards the purchase a server and cameras. The cost starting in fiscal year FY 2026 ($2,700) will be for the license and maintenance contract. The first year license is included in the purchase price. This improvement supports the City Council goals of Vibrant Community: Healthy and Safe and Financially Responsible, High-Performance City Organization: Sustainable, Equitable, and Effective Service Delivery. Related Cost:$ 27,300 Tax Funds Non-Recurring Recommend - No Related Cost:$ 2,700 Tax Funds Recurring Total Cost:$ 30,000 Property Tax Impact:$ 0.0107 0.12% Activity: Conference Center Significant Line Items Background 1.The City has contracted with the firm Global Spectrum L.P., doing business as OVG360, to privately manage the Grand River Center. OVG360's management agreement began on March 31, 2023 and ends June 30, 2028 with an option for renewal to June 30, 2033. Employee Expense 2.FY 2025 employee expense reflects a 5.00% wage package increase. 3.The Iowa Public Employee Retirement System (IPERS) City contribution of 9.44% is unchanged from FY 2024. The employee contribution of 6.29% is unchanged from FY 2024. -23- Supplies & Services OVG360 privately manages the Grand River Center. The following expenses are the responsibility of the City based on the Facility Management Agreement: 4.Building Maintenance decreased from $140,000 in FY 2024 to $25,000 in FY 2025 due to having a new management agreement with different terms. This line item represents building additions, alterations, repairs, or improvements where the cost for the expenditure is greater than $5,000 and the depreciable life of the applicable item is in excess of one year. In consultation with OVG360, a figure of $25,000 is proposed in this budget request, however, if those dollars are not needed, they will remain unspent. 5.Insurance costs (property and general liability) increased from $71,101 in FY 2024 to $103,658 in FY 2025 based on FY 2024 actual. 6.Pay to Other Agency increased from $458,310 in FY 2024 to $850,000 in FY 2025 due to having a new management agreement with different terms. In the new agreement, this line item includes the fixed annual management fee ($150,000), as well as the amount that is provided to the contracted management company, OVG360, to cover the operating loss of the Grand River Center ($700,000). OVG360 maintains a city operating account that all revenues and expenses outlined in the Management Agreement flow into on a fiscal year basis. Bookings for FY 2025 occurred mostly in FY2023 and FY 2024 during the tenure of the prior management company. The majority of conference, convention, and major events book that far ahead. The loss of air service has affected some conferences. Beginning in FY 2026, OVG360 expects a trend of increased bookings resulting in a better revenue and expense profile. This expectation is due to current and planned aggressive marketing efforts, partnership with Travel Dubuque, improved guest and customer experiences, improved cleanliness, and greatly improved food and beverage offerings. Equipment 7.The following equipment will be replaced in FY 2025 ($270,150): Conference Center Machinery and Equipment Administration Multi-function machine $ 11,000 Ice cuber 1 (service hall)$ 8,700 Convection ovens $ 52,000 Slicer $ 5,000 Scissors Lift $ 25,000 Tables and Carts - 175 Round $ 96,150 36" Gas Griddle $ 9,500 Gas Floor Fryer $ 6,300 Hot Dog Grill $ 2,500 Under Counter Refrigerator $ 5,500 Reach in Refrigerator $ 6,000 Back Bar Cabinet $ 4,000 Heated Food/Plate Cabinets $ 33,000 36" Gas Range Open Burners $ 5,500 Total Equipment $ 270,150 -24- Capital and Equipment Investment 9. Recognizing the need for capital and equipment investment due to a possible management company change, the City Council approved in the FY 2024 budget a $500,000 capital and equipment replacement fund to invest in needed upgrades to the Grand River Center facility. To date, $357,700 has been spent on six new boilers which heat the facility, $88,350 on the renewal of chiller 2 adaptive frequency drive (AFD), and $15,800 for replacing ABB drive on air handler 2 with other planned investments. Prior approved budgets for equipment replacements and repairs have been completed, such as the purchase of a new combination oven, repairs to a walk in cooler, boiler supply and return piping replacement, serving tables and table covers, replacement pipe, drape and skirting, with more replacements and capital improvements in the works currently. These investments were critical to the operations of the facility. Debt Service 10. .FY 2025 Annual Debt Service is as follows ($28,686): Amount Debt Series Payment Source Purpose Final Payment Call Date $ 2,596 2019C G.O.Sales Tax 20%Conference Center Improvements 2027 2026 $ 26,090 2019B G.O.Sales Tax 20%Energy Improvements 2039 2039 $ 28,686 Total Conference Center Annual Debt Service For Conference Center Performance Measures see Five Flags Civic Center Outline -25- Recommended Operating Revenue Budget - Department Total 33 - CONFERENCE CENTER Fund/Account/Account Title FY22 Actual Revenue FY23 Actual Revenue FY24 Adopted Budget FY25 Recomm'd Budget 100 - General 4A - Charges for Services 47100 - Reimbursements 0 0 0 0 4A - Charges for Services Total 0 0 0 0 4N - Transfers 49102 - Transfer in DRA Distribution 0 0 0 0 4N - Transfers Total 0 0 0 0 200 - Debt Service 4N - Transfers 49304 - Transfer in Sales Tax 20%(29,847)(33,063)(29,469)(28,686) 4N - Transfers Total (29,847)(33,063)(29,469)(28,686) 4O - Eliminated for GW 48200 - Proceeds from GO Debt 0 0 0 0 48205 - Bond Discount/Premium 0 0 0 0 4O - Eliminated for GW Total 0 0 0 0 CONFERENCE CENTER - Total (29,847)(33,063)(29,469)(28,686) -26- 100 - General 60100 - Salaries-Regular Full Time 0 17,091 22,746 23,974 60635 - Special Pay Sick Lv Payout 50% 0 196 0 206 6A - Salaries & Wages Total 0 17,287 22,746 24,180 6B - Employee Benefits 100 - General 61100 - FICA - City Contribution 0 1,286 1,740 1,850 61300 - IPERS - City Contribution 0 1,613 2,147 2,263 61510 - Health Insurance 0 2,014 2,013 2,013 61540 - Life Insurance 0 5 7 7 61600 - Workers' Compensation 0 0 41 46 6B - Employee Benefits Total 0 4,918 5,948 6,179 6D - Repair/Maint/Util 100 - General 63100 - Building Maintenance 65,178 39,687 140,000 25,000 63321 - Vehicle Repair - Outsourced 0 0 0 0 63400 - Equipment Maint/Repair 0 1,993 0 0 63710 - Electricity 124,623 0 136,500 0 63711 - Natural Gas 31,351 0 34,800 0 6D - Repair/Maint/Util Total 221,153 41,679 311,300 25,000 6E - Contractual Svcs 100 - General 64080 - Insurance - Property 52,937 62,723 69,989 101,958 64081 - Insurance - Liability 511 637 1,112 1,700 64130 - Payments to Other Agencies 86,928 425,031 458,310 850,000 64185 - License/Permit/Fees 0 0 400 0 64190 - Technology Services 0 493 0 0 64975 - Equip Maint Cont 399 399 2,400 0 64980 - Technology Equip Maint Cont 437 0 450 0 64990 - Other Contractual Service 0 0 106,391 0 200 - Debt Service 64110 - Legal 0 0 0 0 64900 - Other Professional Service 0 0 0 0 6E - Contractual Svcs Total 141,211 489,283 639,052 953,658 6F - Commodities 100 - General 65045 - Technology Equipment 0 1,081 41,500 11,000 65050 - Other Equipment 2,598 0 93,500 259,150 6F - Commodities Total 2,598 1,081 135,000 270,150 6G - Capital Outlay 100 - General 67100 - Vehicles 0 0 0 0 67270 - Other Capital Equipment 0 0 0 0 6G - Capital Outlay Total 0 0 0 0 6H - Debt Service Recommended Operating Expenditure Budget - Department Total 33 - CONFERENCE CENTER Fund/Account/Account Title FY22 Actual Expense FY23 Actual Expense FY24 Adopted Budget FY 25 Recomm'd Budget 6A - Salaries & Wages -27- 200 - Debt Service 68010 - Principal Payment 24,973 24,885 26,091 26,091 68020 - Interest Payments 4,874 4,125 3,378 2,595 68990 - Paying Agent Fees 0 0 0 0 6H - Debt Service Total 29,847 29,010 29,469 28,686 CONFERENCE CENTER - TOTAL 394,809 583,258 1,143,515 1,307,853 Recommended Operating Expenditure Budget - Department Total 33 - CONFERENCE CENTER Fund/Account/Account Title FY22 Actual Expense FY23 Actual Expense FY24 Adopted Budget FY 25 Recomm'd Budget 6A - Salaries & Wages -28- Recommended Expenditure Budget Report by Activity & Funding Source 32 - CIVIC CENTER Fund/Activity FY23 Actual Expense FY24 Adopted Budget FY25 Recomm'd Budget 3201 - Administration 100 - General 6A - Salaries & Wages 21,946 22,746 24,180 6B - Employee Benefits 5,749 5,948 6,179 6D - Repair/Maint/Util 42 42 42 6E - Contractual Svcs 1,248,147 1,100,730 1,136,283 6F - Commodities 96,582 162,775 320,070 6G - Capital Outlay 106,313 30,000 — 3201 - Administration Total 1,478,779 1,322,241 1,486,754 3280 - Debt Service 200 - Debt Service 6E - Contractual Svcs ——— 6H - Debt Service 41,887 42,748 41,688 3280 - Debt Service Total 41,887 42,748 41,688 CONFERENCE CENTER TOTAL 1,520,667 1,364,989 1,528,442 -29- Capital Improvement Projects by Department/Division CONF CENTER OPERATION Project Number Capital Improvement Project Title Department Fund Account FY 25 Recomm'd Budget 3346000013 Roof Restoration Conference Center 305 67500 70,000 3346000013 Roof Restoration Conference Center 305 64004 7,000 3346000014 Public Restroom Remodels Conference Center 305 67500 358,000 3346000014 Public Restroom Remodels Conference Center 305 64070 7,500 3346000014 Public Restroom Remodels Conference Center 305 64004 19,500 CONF CENTER OPERATION TOTAL 462,000 PROGRAM/ DEPT PROJECT DESCRIPTION FY 2025 FY 2026 FY 2027 FY 2028 FY 2029 TOTAL PAGE CONFERENCE CENTER General Government Replace Carpet $ — $ — $ — $ — $ 65,000 $ 65,000 45 Roof Restoration $ 77,000 $ — $ — $ — $ 1,350,000 $ 1,427,000 46 Parking Island and Venue Landscape Renovations $ — $ 39,500 $ 9,000 $ — $ — $ 48,500 47 Replace Clouds $ — $ — $ — $ — $ 98,000 $ 98,000 48 Dishwasher and Water Softener Replacement $ — $ — $ 181,000 $ — $ — $ 181,000 49 Public Restroom Remodels $ 385,000 $ 385,000 $ — $ — $ — $ 770,000 50 Replace Fabric Wall Covering $ — $ — $ — $ — $ 77,000 $ 77,000 51 TOTAL $ 462,000 $ 424,500 $ 190,000 $ — $ 1,590,000 $ 2,666,500 -30- C I T Y O F D U B U Q U E , I O W A DEPARTMENT DETAIL - PERSONNEL COMPLEMENT 33 Conference Center Operation FY 2023 FY 2024 FY 2025 FD JC WP-GR JOB CLASS FTE BUDGET FTE BUDGET FTE BUDGET 61010 Full Time Employee Expense 100 3375 GE-44 LEISURE SERVICES DIRECTOR 0.15 $ 21,746 0.15 $ 22,746 0.15 $ 23,974 TOTAL FULL TIME EMPLOYEES 0.15 $ 21,746 0.15 $ 22,746 0.15 $ 23,974 TOTAL CONFERENCE CENTER DIVISION 0.15 $ 21,746 0.15 $ 22,746 0.15 $ 23,974 -31- CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2021 FY 2022 FY 2023 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET Conference Center Operation 10033100 61010 100 3375 GE-41 LEISURE SERVICES DIRECTOR 0.15 $ 21,746 0.15 $ 22,746 0.15 $ 23,974 Total 0.15 $ 21,746 0.15 $ 22,746 0.15 $ 23,974 TOTAL CONFERENCE CENTER DIVISION 0.15 $ 21,746 0.15 $ 22,746 0.15 $ 23,974 -32- ImOn Arena -33- This page intentionally left blank. -34- IMON ARENA Budget Highlights FY 2023 Actual FY 2024 Budget FY 2025 Requested % Change From FY 2024 Budget Expenses Employee Expense 6,865 — — 0.0 % Supplies and Services 415,660 373,255 411,929 10.4 % Machinery and Equipment 0 0 16,100 0.0 % Total Expenses 422,525 373,255 428,029 14.7 % Debt on Projects paid with Sales Tax Fund (20%)0 350,341 372,587 6.3 % Resources Operating Revenue 52,252 — — — % Total 52,252 — — — % Property Tax Support 370,273 373,255 428,029 14.7 % Percent Increase (Decrease) 14.7 % Significant Line Items Background 1.The Dubuque Community Ice Center (now known as ImOn Arena), was designed, developed, and built under a Development Agreement between the Dubuque Community Ice & Recreation, Inc. (DICE), the City, the Dubuque Racing Association (DRA), and Battlefield Dubuque, LLC commencing October 30, 2009. Opened September 18, 2010, the building is owned by the City and was leased in a 25-year lease agreement to DICE. DICE, a 501(c)(3) non-profit organization, raised all funds to build the Ice Center. DICE managed and operated the Ice Center on a day-to- day basis. The City of Dubuque received notice from DICE on June 17, 2021, of its intent to relinquish its leaseholder rights. DICE agreed to continue operating the Ice Center through September 5, 2021. The Development Agreement outlined the steps to be taken in the event the lease was terminated. These steps ended with the City taking ownership of all assets and commencing with full Ice Center operations on September 6, 2021. This was to continue ice operations to avoid disruption of ice usage for all user groups involved. As the City took over the operations and focused on the short-term needs of running the facility, they continued to consider what would be the best management model for the ice center in the long term. The City and the DRA discussed the opportunity to move the day-to-day operations of the Ice Center to the DRA. This led to an interim staffing agreement between the City of Dubuque and the DRA executed on January 1, 2022, in which the DRA would provide interim staffing to operate the facility. All operating expenses were charged to the City. Only the direct employee expenses were included in the monthly expenses. Indirect employee costs incurred during the term of the interim staffing agreement was provided by the DRA and not billed to the City. All other costs and operations continued to be the responsibility of the City during the term of that agreement. The facility was renamed Dubuque Ice Arena in October of 2022. A Management Agreement was adopted between Schmitt Island Development Corporation (SID) and the City on October 20, -35- 2022. The agreement provides for a $100,000 management fee to SID similar to the fee to the management firm for Five Flags and Grand River Center as well as the City’s reimbursement of operating loss. A long-term management agreement is being developed at this writing for approval in late FY 2024. The facility was renamed ImOn Arena on August 21, 2023 as part of a naming rights agreement, which provides $100,000 in revenue to go towards SIDs Ice Arena operating budget with the goal of reducing the City's property tax support. Supplies and Services 2.Pay to other Agency increased from $350,000 in FY 2024 to $382,673 in FY 2025. This line item represents the $100,000 management fee per the approved agreement with Schmitt Island Development Corporation (SID) and $282,673 operating loss coverage to SID. This number is projected per a budget provided by SID. The operational loss for FY2024 budget was estimated in December of 2022 with financial information from DICE and a partial operational year of the City. Operational methods needed to change, thus increasing expenses. Based on this, a truer actual expense for a 12-month period has been established through the operation by the Dubuque Racing Association (DRA) and now SID. Machinery & Equipment 3.Equipment replacement items include ($16,100): Ice Center Machinery and Equipment Administration Door Crash Bars (8)$ 4,800 Microwave $ 300 Network Switch $ 11,000 Total Equipment $ 16,100 Capital and Equipment Investment 4. The City Council approved in the FY 2023 capital improvement budget just over $6.5 million to address the issue of settlement of the building, dehumidification, HVAC, concessions, and safety improvements, as well as a generator. The settlement project has been completed. This closure had a negative impact in the operating budget over two fiscal years. Currently the HVAC, dehumidification, and generator project are in design. One of the benefits of this project will be the summer use of the arena which will provide an opportunity for increased revenue in this off season timeframe. It is anticipated that as this project is completed by FY 2026, the operating subsidy/property tax support will be lowered. Dubuque prides itself in partnerships and those partnerships in capital and equipment investment have been a highlight in building the business at the arena. The naming of the arena to ImOn Arena nets both yearly revenue funding that affects the bottom line as well as has resulted in all new signage on the exterior of the building in addition to parking lot banners and upgraded signage throughout the facility. The Dubuque Racing Association (DRA) through the Schmitt Island Development (SID) fund invested $500,000 in a new audio/speaker system for the arena, food and beverage equipment, new paint and other improvements upon completion of the settlement project in the fall of 2022 and 2023. The Saints 4 Life Foundation was awarded a $50,000 DRA grant for control room equipment and video boards now in the arena near the flags. The University of Dubuque (UD) established a new men's and women's hockey program which -36- led to locker room and other improvements funded by UD and the rental of open ice time in the facility. Debt Service 5. FY 2025 Annual debt service is as follows ($372,587): Amount Debt Series Payment Source Purpose Final Payment Call Date $ 372,587 2023 Planned G.O.Sales Tax 20%Ice Settling Remediation 2043 $ 372,587 Total ImOn Arena Annual Debt Service ImOn Arena Performance Measures are included in the Five Flags Civic Center Outline. -37- Recommended Operating Revenue Budget - Department Total 28 - ICE CENTER Fund/Account/Account Title FY21 Actual Revenue FY22 Actual Revenue FY23 Adopted Budget FY24 Recomm'd Budget 100 - General 4A - Charges for Services 45021 - Credit Card Tips (16,704) 0 0 0 45032 - Public Skate (25,052) 0 0 0 45033 - Hockey Ice Rent (4,761)0 0 0 45034 - Ice Rental 0 (25,000)0 0 45037 - Ice Rental (238,853)(10,693)0 0 45038 - Free Style Ice Rent (3,421)0 0 0 45039 - Skate Rental (9,508)0 0 0 45440 - Events (350)0 0 0 45443 - Gift Certificates 2,692 0 0 0 45450 - Meeting Room Fee (958)0 0 0 45455 - Program Fee (3,817)0 0 0 45500 - Miscellaneous Chg for Svcs (1,689)0 0 0 47100 - Reimbursements (9,223)(15,911)0 0 47500 - Merchandise Sales (1,003)0 0 0 47510 - Beer (119,062)0 0 0 47511 - Food (107,537)0 0 0 47512 - Liquor (43,282)0 0 0 47513 - Beverage/Ice (78,280)(647)0 0 47514 - Gift Cards (4,507)0 0 0 4A - Charges for Services Total (665,315)(52,252)0 0 4O - Eliminated for GW 47115 - Sales Tax Collection (2,586)0 0 0 4O - Eliminated for GW Total (2,586)0 0 0 200 - Debt Service 4N - Transfers 49304 - Transfer in Sales Tax 20%0 0 (350,341)(372,587) 4N - Transfers Total 0 0 (350,341)(372,587) ICE CENTER - Total (667,901)(52,252)(350,341)(372,587) -38- 6A - Salaries & Wages 100 - General 60100 - Salaries-Regular Full Time 435 0 0 0 60200 - Salaries - Regular Part Time 0 0 0 0 60300 - Hourly Wages - Temp/Seasonal 69,196 5,115 0 0 60400 - Overtime 9,491 0 0 0 6A - Salaries & Wages Total 79,121 5,115 0 0 6B - Employee Benefits 100 - General 61100 - FICA - City Contribution 6,053 391 0 0 61300 - IPERS - City Contribution 841 0 0 0 61510 - Health Insurance 406 0 0 0 61540 - Life Insurance 1 0 0 0 61700 - Unemployment Compensation 0 912 0 0 61992 - Physicals 1,562 447 0 0 6B - Employee Benefits Total 8,863 1,750 0 0 6C - Staff Development 100 - General 62325 - Mileage 77 0 0 0 62500 - Education Reimbursement 986 0 0 0 6C - Staff Development Total 1,063 0 0 0 6D - Repair/Maint/Util 100 - General 63100 - Building Maintenance 21,172 4,683 0 0 63400 - Equipment Maint/Repair 6,878 3,108 0 0 63710 - Electricity 96,043 45,732 0 0 63711 - Natural Gas 11,881 2,929 0 0 63720 - Refuse 3,564 1,632 0 0 63730 - Telecommunications 730 410 0 0 63742 - Stormwater 1,996 2,349 0 0 6D - Repair/Maint/Util Total 142,264 60,842 0 0 6E - Contractual Svcs 100 - General 64020 - Advertising 225 149 0 0 64062 - Refunds 0 81 0 0 64080 - Insurance - Property 2,317 0 20,213 29,256 64083 - Insurance - Other 2,600 0 3,042 0 64130 - Payments to Other Agencies 502,299 334,693 350,000 382,673 64150 - Rental - Equipment 4,560 387 0 0 64180 - Sales Tax Expense 20,556 (1,611) 0 0 64185 - License/Permit/Fees 2,479 0 0 0 64190 - Technology Services 9,644 2,835 0 0 64195 - Credit Card Charge (43) 0 0 0 64900 - Other Professional Service 750 0 0 0 64975 - Equip Maint Cont 468 4,099 0 0 6E - Contractual Svcs Total 545,855 340,633 373,255 411,929 Recommended Operating Expenditure Budget - Department Total 28 - ICE CENTER Fund/Account/Account Title FY22 Actual Expense FY23 Actual Expense FY24 Adopted Budget FY 25 Recomm'd Budget -39- 6F - Commodities 100 - General 65025 - Program Materials 3,484 20 0 0 65033 - Food Products 39,710 4 0 0 65034 - Beer Products 38,024 13,395 0 0 65035 - Liquor Products 5,293 0 0 0 65036 - Beverage/Ice 26,322 65 0 0 65037 - Pro Shop Mechandise 500 0 0 0 65045 - Technology Equipment 0 0 0 11,000 65050 - Other Equipment 12,253 0 0 5,100 65056 - Traffic Security Cameras 3,361 0 0 0 65060 - Office Supplies 3,070 701 0 0 65965 - Janitorial 19,559 0 0 0 65999 - Cash Over and Short (114)0 0 0 6F - Commodities Total 151,463 14,185 0 16,100 6G - Capital Outlay 100 - General 67230 - Heavy Equipment 17,500 0 0 0 67250 - Office Equipment 11,697 0 0 0 6G - Capital Outlay Total 29,197 0 0 0 6H - Debt Service 200 - Debt Service 68010 - Principal Payment 0 0 118,203 151,968 68020 - Interest Payments 0 0 232,138 220,619 6H - Debt Service Total 0 0 350,341 372,587 ICE CENTER - TOTAL 957,826 422,526 723,596 800,616 Recommended Operating Expenditure Budget - Department Total 28 - ICE CENTER Fund/Account/Account Title FY22 Actual Expense FY23 Actual Expense FY24 Adopted Budget FY 25 Recomm'd Budget -40- Recommended Expenditure Budget Report by Activity & Funding Source 28 - ICE CENTER Fund/Activity FY23 Actual Expense FY24 Adopted Budget FY25 Recomm'd Budget 2801 - Ice Center Admin 100 - General 6A - Salaries & Wages 5,115 —— 6B - Employee Benefits 1,750 —— 6C - Staff Development ——— 6D - Repair/Maint/Util 60,842 —— 6E - Contractual Svcs 340,633 373,255 411,929 6F - Commodities 14,185 —16,100 6G - Capital Outlay ——— 2801 - Ice Center Admin Total 422,526 373,255 428,029 2880 - Ice Center Debt Service 200 - Debt Service 6H - Debt Service 0 350,341 372,587 2880 - Ice Center Debt Service Total 0 350,341 372,587 ICE CENTER TOTAL 422,526 723,596 800,616 -41- Capital Improvement Projects by Department/Division DUBUQUE ICE ARENA Project Number Capital Improvement Project Title Department Fund Account FY 24 Recomm'd Budget 2849900001 Ice Arena - Emergency Light and Ven Ice Center 304 64004 5,000 2849900001 Ice Arena - Emergency Light and Ven Ice Center 304 67500 69,000 ICE ARENA TOTAL 74,000 PROGRAM/ DEPT PROJECT DESCRIPTION FY 2025 FY 2026 FY 2027 FY 2028 FY 2029 TOTAL PAGE DUBUQUE ICE ARENA Culture and Recreation Ice Center Locker Room Ventilation Replacement $ — $ 396,375 $ — $ — $ — $ 396,375 52 TPO Roof Replacement $ — $ — $ — $ — $ 181,125 $ 181,125 53 New Northwest Corner Service Bar $ — $ — $ — $ 241,500 $ — $ 241,500 54 TOTAL $ — $ 396,375 $ — $ 241,500 $ 181,125 $ 819,000 -42- Transportation Services -43- This page intentionally left blank. -44- TRANSPORTATION SERVICES Budget Highlights FY 2023 Actual FY 2024 Budget FY 2025 Requested % Change From FY 2024 Budget Expenses Employee Expense 3,152,228 3,717,889 3,893,763 4.7 % Supplies and Services 2,415,771 2,550,285 2,819,402 10.6 % Machinery and Equipment 92,145 181,957 285,600 57.0 % Engineering Parking Charges 1,270 3,243 5,934 83.0 % Debt Service 3,165,379 3,123,091 3,107,298 -0.5 % Administrative Overhead Recharge 223,618 254,963 348,163 36.6 % Total Expenses 9,050,411 9,831,428 10,460,160 6.4 % Resources FTA Operating 935,175 570,300 558,000 -2.2 % FTA Capital 2,081,517 1,349,193 1,322,000 -2.0 % State Operating Assistance 424,282 343,428 352,876 2.8 % Medicaid Reimbursement 73,311 86,786 68,050 -21.6 % Advertising Fees 9,890 19,055 9,890 -48.1 % Mini Bus Passenger Fares 126,344 131,255 111,956 -14.7 % Fixed Route Passenger Fares 151,016 146,195 142,980 -2.2 % Iowa DMV/Burlington Trailways Rent 29,184 34,415 28,990 -15.8 % Greater Downtown TIF - Debt Service 2,573,400 2,782,225 2,891,930 3.9 % Sales Tax 20% - Debt Service 69,903 69,008 68,300 -1.0 % Downtown Shuttle Service - GDTIF 134,704 134,704 134,704 0.0 % Miscellaneous 14,069 130 3,655 2,711.5 % Operating Revenue-Parking System 2,498,507 2,635,653 2,805,976 6.5 % Total Resources 9,121,302 8,302,347 8,499,307 2.4 % Transit Levy 1,571,981 1,548,127 1,961,488 26.7 % Increase (Decrease) in Transit Fund Balance 1,695,606 209 — 0.0 % Increase (Decrease) in Parking Fund Balance (52,734) 18,837 635 -96.6 % Property Tax Support 1,571,981 1,548,127 1,961,488 413,361 Percent Increase (Decrease) 26.70 % Personnel - Authorized FTE 53.21 54.01 55.20 *Includes the Transit Division and Parking Division. -45- TRANSIT Budget Highlights FY 2023 Actual FY 2024 Budget FY 2025 Requested % Change From FY 2024 Budget Expenses Employee Expense 2,517,028 2,920,130 3,024,228 3.6 % Supplies and Services 1,331,425 1,422,388 1,600,029 12.5 % Machinery and Equipment 7,267 21,070 70,332 233.8 % Debt Service 351,512 350,709 345,200 -1.6 % Total 4,207,232 4,714,297 5,039,789 6.9 % Resources FTA Operating 935,175 570,300 558,000 -2.2 % FTA Capital 2,081,517 1,349,193 1,322,000 -2.0 % State Operating Assistance 424,282 343,428 352,876 2.8 % Medicaid Reimbursement 73,311 86,786 68,050 -21.6 % Advertising Fees 9,890 19,055 9,890 -48.1 % Mini Bus Passenger Fares 126,344 131,255 111,956 -14.7 % Fixed Route Passenger Fares 151,016 146,195 142,980 -2.2 % Downtown Shuttle Service - GDTIF 134,704 134,704 134,704 0.0 % Greater Downtown TIF - Debt Service 281,400 281,700 276,900 -1.7 % Sales Tax 20% - Debt Service 69,903 69,008 68,300 -1.0 % Iowa DMV/Burlington Trailways Rent 29,184 34,415 28,990 -15.8 % Miscellaneous 14,069 130 3,655 2,711.5 % Total Resources 4,330,795 3,166,169 3,078,301 -2.8 % Transit Levy 1,571,981 1,548,127 1,961,488 26.7 % Increase (Decrease) in Transit Fund Balance 1,695,544 (1) — 0.0 % Property Tax Support 1,571,981 1,548,127 1,961,488 413,361 Percent Increase (Decrease) 26.7 % Personnel - Authorized FTE 43.31 43.76 44.08 -46- PARKING Budget Highlights FY 2023 Actual FY 2024 Budget FY 2025 Requested % Change From FY 2024 Budget Expenses Employee Expense 635,200 797,759 869,535 9.0 % Supplies and Services 1,084,346 1,127,897 1,219,373 8.1 % Machinery and Equipment 84,878 161,097 215,268 33.6 % Administrative Overhead Recharge 223,618 254,963 348,163 36.6 % Engineering Parking Charges 1,270 3,243 5,934 83.0 % Debt Service 2,813,867 2,772,382 2,762,098 -0.4 % Total Expenses 4,843,241 5,117,341 5,420,371 5.9 % Resources Operating Revenue-Parking System 2,498,507 2,635,653 2,805,976 6.5 % TIF Revenue for Debt Abatement 2,292,000 2,500,525 2,615,030 4.6 % Total Resources 4,790,507 5,136,178 5,421,006 5.5 % Net Operating Surplus(Deficit) (52,734) 18,837 635 (18,202) Personnel - Authorized FTE 9.90 10.25 11.12 INTERMODAL RAMP Budget Highlights FY 2023 Actual FY 2024 Budget FY 2025 Requested % Change From FY 2024 Budget Expenses Employee Expense — — 48,444 0.0 % Supplies and Services 90,065 87,538 110,651 26.4 % Administrative Overhead Recharge - Parking/Transit — 6,337 — 0.0 % Debt Service 281,400 281,700 276,900 -1.7 % Total Expenses 377,090 375,575 435,995 16.1 % Resources Operating Revenue-Parking System 251,942 301,355 306,319 1.6 % Greater Downtown TIF - Debt Service 281,400 281,700 276,900 -1.7 % Total Resources 533,342 583,055 583,219 0.0 % Net Operating Surplus(Deficit) 156,252 207,480 147,224 (60,256) Intermodal Ramp is split 67% Parking and 33% Transit. -47- Improvement Package Summary 1 of 2 This improvement package request would increase the FY25 budget for parking permit revenue. The City of Dubuque Parking Division is committed to providing efficient and reliable parking services to the residents of Dubuque, and rate increases are made with great consideration. There have been no increases in monthly parking rates at these ramps since July 2015, despite rising costs associated with maintenance, materials, and labor. The decision to adjust monthly parking rates was made in response to the need to cover these increased costs. The revenue generated from the rate increase will be reinvested back into our parking facilities, allowing us to implement necessary technology and equipment upgrades- enhancements that will improve the user experience for customers and benefit the entire community. This improvement package aligns with the City Council goal: Financially Responsible, High-Performance City Organization. Related Revenues:$ (190,816) Parking Recurring Recommend - Yes Property Tax Impact:$ (0.0751) (0.74)% Activity: Ramps, Lots, Intermodal 2 of 2 This improvement package request would increase the FY25 budget for parking violation fee revenue. This budget increase would help to improve parking access, efficiency, and overall experience. The changes are designed to promote turnover of parking spaces for the benefit of businesses and visitors, maintain traffic flow, and alleviate congestion by encouraging drivers to adhere to time limits and find alternative parking options when necessary. The adjusted fines are also designed to optimize parking management and encourage efficient use of parking resources. This improvement package aligns with the City Council goal: Connected Community. Related Revenue:$ (66,300) Parking Recurring Recommend - Yes Property Tax Impact:$ (0.0261) (0.26)% Activity: Meter Enforcement Transit Significant Line Items Transit Employee Expense 1.FY 2025 employee expense reflects a 5.00% wage package increase for non-bargaining unit employees and 3.00% wage package increase for employees represented by the Teamsters Local Union 120 Bus Operator bargaining unit from July 1, 2024- June 30, 2025. -48- 2.The Iowa Public Employee Retirement System (IPERS) City contribution of 9.44% is unchanged from FY 2024. The employee contribution of 6.29% is unchanged from FY 2024. 3.The City portion of health insurance expense is unchanged from $1,119 in FY 2024 to $1,119 in FY 2025 per month, per contract, but there is an annual cost increase of $8,054. 4.Overtime is unchanged from $19,773 in FY 2024 to $19,773 in FY 2025. The FY 2023 actual was $20,330. 5.Holiday Overtime is unchanged from $11,867 in FY 2024 to $11,867 in FY 2025. The FY 2023 actual was $32,904. 6.Unemployment Insurance is unchanged from $0 in FY 2024 to $0 in FY 2025. The FY 2023 actual was $0. 7.During Fiscal Year 2024, there was one personnel change were approved by council. A 0.28 FTE part-time laborer was combined with a 0.27 FTE part-time laborer and increased to 1.0 FTE full-time laborer, which results in an approximate annual increase of $50,476. This position is split between Transit and Parking divisions. Transit Supplies & Services 8.General Liability Insurance increased from $84,151 in FY 2024 to $129,202 in FY 2025 based on FY 2024 actual plus 12%. 9.Vehicle Ops - Diesel increased from $224,464 in FY 2024 to $297,658 in FY 2025. The FY 2025 budget is based on calendar year 2023 actual plus the estimated fuel projections from Public Works/rising fuel costs. This line item represents diesel fuel purchased for the operation of bus services. 10.Vehicle Ops - Gasoline decreased from $71,213 in FY 2024 to $69,966 in FY 2025 based on FY 2024 budget. FY 2023 actual was $73,326. This line item represents gasoline purchased for the operation of bus services. 11.Vehicle Repair - Internal increased from $469,704 in FY 2024 to $496,052 in FY 2025. This amount includes multiple lines for multiple divisions and the changes to each line are either FY 2023 actual + 2% or FY 2024 budget + 2%, as well as the extended time it takes to receive new buses. The decision on whether to use FY 2023 actual or FY 2024 budget is based on a deep analysis of prior year data and trends, while factoring in projected changes. FY 2023 actual expense was $429,620. This line item includes maintenance and repairs on Transit vehicles that is preformed by city staff. 12.Vehicle Repair Outsourced increased from $161,490 in FY 2024 to $184,501 in FY 2025 based on either FY 2023 actual + 2% or FY 2024 budget + 2%, as well as the extended time it takes to receive new buses. The decision on whether to use FY 2023 actual or FY 2024 budget is based on a deep analysis of prior year data and trends, while factoring in projected changes. FY 2023 actual was $85,187. This line item includes more complex and specialized repairs to Transit vehicles that are not performed by city staff. -49- 13.Technology Services decreased from $90,616 in FY 2024 to $84,474 in FY 2025. This line item includes expenses associated with route planning software, camera and security software for the Jule Operations and Training Center, door lock/security and camera software for the Intermodal Center, route scheduling and dispatch software for fixed route service, fare collection software, Minibus scheduling and routing software, cloud storage software, bus camera software, and camera maintenance. 14.Electricity increased from $32,095 in FY 2024 to $54,708 in FY 2025 based on FY 2023 actual of $49,824. Transit Machinery & Equipment 15.Equipment replacement items include ($70,332): Transit Administration JFK Circle Transfer Security Cameras (5)$ 11,330 Intermodal Security Cameras (29)$ 40,426 Bus Maintenance Riding Lawnmower/Snow Sweeper $ 18,576 Total Equipment $ 70,332 Transit Debt Service 16.FY 2025 annual debt service includes the following ($345,200): Amount Debt Series Source Purpose Final Payment Call Date $ 276,900 2021A G.O.GDTIF Intermodal Facility 2041 2028 $ 2,952 2021A G.O.Sales Tax 20%Roof Improvements 2041 2028 $ 11,006 2018A G.O.Sales Tax 20%Radio Replacements 2038 2026 $ 6,484 2019A G.O.Sales Tax 20%Midtown Transfer 2039 2026 $ 47,858 2021A G.O.Sales Tax 20%Vehicle Replacements 2041 2028 $ 345,200 Total Transit Annual Debt Service Transit Revenue 17.Federal Transit Administration assistance is based on a comparison of larger cities. Previously the allocation was based on population and population density. Federal Transit Administration assistance is allocated on the federal fiscal year of October through September. Final FTA allocations for FY 2025 should be received by March 2024. FY 2025 estimated Federal Transit Administration assistance is budgeted at $1,880,000, and FY 2024's allocation is $1,876,739. The FY 2023 actual was $3,016,692, which is higher than normal due to reimbursement of bus purchases and FTA CARE funds. FTA operating funds require a 50% local match. -50- 18.State operating assistance increased from $343,428 in FY 2024 to $352,876 in FY 2025. The FY 2023 actual was $424,282. 19.The following revenue line items make-up MiniBus passenger-related revenues, which are based off FY 2024 actual annualized. The decrease is due to a decrease in the volume of passengers. Revenue Type FY 2022 FY 2023 FY 2024 Budget FY 2025 % Change From FY 2024 Budget MiniBus Fares $ 108,804 $ 123,867 $ 131,255 $ 111,990 -14.68 % MiniBus Contract $ — $ 2,567 $ — $ (34) #DIV/0! MiniBus Medicaid Fares $ 34,020 $ 56,156 $ 56,328 $ 54,580 -3.10 % Total Mini-Bus Revenues $ 142,824 $ 182,590 $ 187,583 $ 166,536 -11.22 % 20.The following revenue line items make-up Fixed-Route passenger-related revenues, which are based off FY 2024 actual annualized: Revenue Type FY 2022 FY 2023 FY 2024 Budget FY 2025 % Change From FY 2024 Budget Passenger Fares $ 114,133 $ 151,016 $ 146,195 $ 142,980 -2.20 % Fixed Route Medicaid $ 2,430 $ 17,155 $ 30,458 $ 13,470 -55.78 % Total Fixed Route Revenues $ 116,563 $ 168,171 $ 176,653 $ 156,450 -11.44 % 21.Reimbursements from the Greater Downtown TIF for the downtown service routes are unchanged from $134,704 in FY 2024 to $134,704 in FY 2025. Parking Significant Line Items Parking Employee Expense 1.FY 2025 employee expense reflects a 5.00% wage package increase. 2.The Iowa Public Employee Retirement System (IPERS) City contribution of 9.44% is unchanged from FY 2024. The employee contribution of 6.29% is unchanged from FY 2024. 3.The City portion of health insurance expense is unchanged from $1,119 in FY 2024 to $1,119 in FY 2025 per month, per contract, but there is an annual cost increase of $0. 4.Overtime is unchanged from $4,000 in FY 2024 to $4,000 in FY 2025. FY 2023 actual was $1,013. 5.Workers Compensation increased from $4,346 in FY 2024 to $5,340 in FY 2025, based on FY 2024 actual insurance quote. FY 2023 actual was $4,444. -51- 6.During Fiscal Year 2024, there was one personnel change were approved by council. A 0.28 FTE part-time laborer was combined with a 0.27 FTE part-time laborer and increased to 1.0 FTE full-time laborer, which results in an approximate annual increase of $50,476. This position is split between Transit and Parking divisions. Parking Supplies & Services 7.Electrical Utility Expense increased from $253,309 in FY 2024 to $267,548 in FY 2025 based on FY 2023 actual of $234,132 plus increased cost of kilowatt hours. Parking is charged 21% of the electricity cost for the Jule Operations and Training Center which is shared between Transit and Parking funds. 8.Credit Card Charge decreased from $45,925 in FY 2024 to $42,157 in FY 2025 based on FY 2023 actual of $42,156. This line item represents credit card service charges from the Passport Parking app associated with street meters. 9.Elevator Maintenance increased from $35,669 in FY 2024 to $35,893 in FY 2025. The FY 2023 actual was $45,894. This line item represents a maintenance contract for elevator services. The large decrease between recent budgets and FY 2023 actual stems from the cost of a counterweight being rebuilt in FY 2023. 10.Building Maintenance increased from $50,680 in FY 2024 to $66,235 in FY 2025 based on FY 2023 actual of $58,677. The variance between FY 2023 actual and FY 2025 budget is due to a coding error. 11.Technology Equipment Maintenance increased from $71,018 in FY 2024 to $84,822 in FY 2025. FY 2023 actual was $39,218. The increase stems from an increase in the service contract for camera support as well as the addition of 8 ramp security cameras. This line item represents support of camera software through RACOM and a service contract with RACOM to perform yearly preventive maintenance on all contracted equipment. 12.Technology Services increased from $40,121 in FY 2024 to $42,087 in FY 2025. The increase is due to the addition of 8 body cameras. This line item also represents an annual service contract for administrative software, gate software subscription, and internet service bills. 13.Water utility expense increased from $25,082 in FY 2024 to $36,691 based on FY 2023 actual of $32,470 plus 13% (a FY 2024 rate increase of 8% and a 5% projected rate increase in FY 2025). This line item includes water utility expenses for parking ramps. 14.Property Insurance increased from $138,727 in FY 2024 to $215,728. FY 2023 actual was $132,710. 15.Snow Removal Contract decreased from $225,508 in FY 2024 to $189,771 in FY 2025 based on prior 2 years' actual. FY 2023 actual was $209,974. -52- Parking Machinery & Equipment 16.Equipment replacement items include ($215,268): Parking Maintenance Technician Truck (1)$ 42,500 Meter Enforcement Parking Enforcement Vehicles (2)$ 46,500 Handheld Radio & Microphone $ 38,149 Five Flags Ramp Security Cameras (36)$ 41,400 Locust Parking Ramp Security Cameras (29)$ 46,719 Total Equipment $ 215,268 Parking Debt Service 17.Debt issues and their debt service payments for the Parking Division include ($2,762,098): Amount Debt Series Source Purpose Final Payment Call Date $ 2,011,250 Revenue 2007 GDTIF Port of Dubuque Ramp 2037 2019 $ — Revenue 2008 Parking Fees Lot 9 2023 $ 649,700 G.O. 2017A Parking Fees Central Ramp 2029 2025 $ 53,407 G.O. 2018A Parking Fees POD Ramp Repairs 2026 2026 $ 4,261 G.O. 2018A Parking Fees Re-Lamp Iowa Street Ramp 2031 2026 $ 13,080 G.O. 2019C Parking Fees Locust Security Cameras 2033 2026 $ 18,500 G.O. 2021B Parking Fees Parking Improvements 2034 2028 $ 11,900 G.O. 2021B Parking Fees Parking Improvements 2034 2028 $ 2,762,098 Total Parking Annual Debt Service Greater Downtown TIF will contribute $2,011,250 in FY 2025 towards parking debt service for the Port of Dubuque Ramp which is covered by a minimum assessment agreement paid by Boyd gaming and a supplemental payment. Greater Downtown TIF will also contribute $603,780 towards downtown parking ramp debt service unrelated to the Port of Dubuque Ramp. -53- Parking Revenue 18.Significant changes in operating budget revenue projections based on actual trends include: Locust Street Ramp $ 271,616 $ 339,194 $ 67,578 (a)$ 311,156 Iowa Street Ramp $ 418,712 $ 488,904 $ 70,192 (b)$ 459,594 5th St. Ramp $ 187,580 $ 250,794 $ 63,214 (c)$ 191,455 Five Flags Ramp $ 99,191 $ 110,306 $ 11,115 (d)$ 113,904 Port of Dubuque Ramp $ 135,436 $ 122,776 $ (12,660) (e)$ 122,776 Central Ramp $ 196,763 $ 138,852 $ (57,911) (f)$ 164,967 Intermodal Ramp $ 226,399 $ 163,783 $ (62,616) (g)$ 141,442 Parking Lots $ 192,387 $ 233,571 $ 41,184 (h)$ 174,148 Street Parking Meters $ 628,432 $ 682,468 $ 54,036 (i)$ 623,078 Residential Parking District $ 16,450 $ 19,760 $ 3,310 (j)$ 13,160 Parking Ticket Fines $ 234,113 $ 240,000 $ 5,887 (k)$ 160,058 Total $ 2,607,079 $ 2,790,408 $ 183,329 $ 2,475,738 Area FY 2024 FY 2025 Change FY 2023 Actual a.Locust Street Ramp Daily Fees increased $67,578 due to a kiosk being added for transient daily parking. The Locust Street parking ramp is now full, resulting in an increase in revenue. Prior years saw a decrease in revenue due to gate equipment being down. FY 2023 actual was higher due to FY 2022 revenues being deposited in FY 2023. b.Iowa Street Ramp increased $70,192. FY22 actual was $459,594. This increase in revenue is due to emergency repairs that are now complete, resulting in an increase in revenue. FY 2023 actual was higher due to FY 2022 revenues being deposited in FY 2023. c.5th St. Ramp Permits increased $63,214 based on current permit numbers. FY23 actual was $191,455. The increase stems from additional businesses using the ramp. d.Five Flags Ramp daily parking fees decreased $1,507, and daily permits increased $5,576 based on FY 2024 annualized. Overall, revenues received from events at the Five Flags Center are expected to increase. e.Port of Dubuque Ramp decreased $12,660 based on FY 2023 actual. f.Central Ramp permit decreased $57,911 due to daily parking fees being eliminated. FY 2022 actual was $164,967. g.Intermodal Ramp permit decreased $(62,616) based on current number of permits issued. All available permits have been sold. The decrease in revenue comes from a change in how the Intermodal revenue is split between the Transit and Parking divisions as well as the FY 2024 budget being overestimated. On the Transit side, the revenue is expected to increase from $74,956 to $113,286. h.Parking Lots increased $41,184 based on FY 2024 annualized. i.Street Parking Meter Collections increased $54,036 based on FY 2024 annualized. j.Residential Parking District Ticket Fines increased $3,310 based on an increase in enforcement coverage. k.Parking Ticket Fines increased $5,887 due to more compliance with additional enforcement officers and offsets the revenue increase to meters. -54- TRANSPORTATION SERVICES DEPARTMENT TRANSIT DIVISION SUCCESS IS ABOUT PLANNING, PARTNERSHIPS AND PEOPLE LEADING TO OUTCOMES -55- TRANSPORTATION SERVICES DEPARTMENT TRANSIT DIVISION FY 2023 FY 2024 FY 2025 Full-Time Equivalent 43.31 43.76 44.08 Resources $126,344 $151,016 $134,704 $73,311 $131,255 $146,195 $134,704 $86,786$111,956 $142,980 $134,704 $68,050 FY 2023 FY 2024 FY 2025 Mini Bus Passenger Fees Fixed Route Fares GDTIF Medicaid 0 50,000 100,000 150,000 200,000 250,000 Resources and Property Tax Support $935,175 $424,282 $9,890 $1,571,981 $570,300 $343,428 $19,055 $1,548,127 $558,000 $352,876 $9,890 $1,961,488 FY 2023 FY 2024 FY 2025 FTA Operating State Operating Advertising Fees Property Tax Support $0 $250,000 $500,000 $750,000 $1,000,000 $1,250,000 $1,500,000 $1,750,000 $2,000,000 The Transit Division is supported by 44.08 full-time equivalent employees, which accounts for 60.01% of the department expense as seen below. Overall, the departments' expenses are expected to increase by 6.90% in FY 2025 compared to FY 2024. -56- TRANSPORTATION SERVICES DEPARTMENT TRANSIT DIVISION Expenditures by Category by Fiscal Year $2,517,028 $1,331,425 $7,267 $351,512 $2,920,130 $1,422,388 $21,070 $350,709 $3,024,228 $1,600,029 $70,332 $345,200 FY 2023 FY 2024 FY 2025 Employee Expense Supplies and Services Machinery and Equipment Debt Service $0 $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 $3,000,000 -57- TRANSPORTATION SERVICES DEPARTMENT TRANSIT DIVISION Administration and Operations Mission & Services Management functions of The Jule include property, vehicle, the management, maintenance and selection of equipment, evaluation of routes, safety, security, and funding sources, employee hiring, training, payroll and discipline, public relations, marketing, accounting, and submission of grant applications for continued funding as well as compliance with state and federal transportation rules and regulations. The Transit Advisory Board advises the City Council on executing agreements and grants relating to the transit system operation, the purchase of new equipment, and establishing rates and fares. Administration and Operations Funding Summary 60053100 FY 2023 Actual FY 2024 Budget FY 2025 Recomm'd Expenditures $907,028 $939,359 $1,061,251 Resources $982,205 $644,219 $626,535 Administration and Operations Position Summary FY 2025 CONFIDENTIAL ACCOUNT CLERK 0.70 TRANSPORTATION ANALYST 0.50 OPERATIONS SUPERVISOR 1.00 TRANSPORTATION SERVICES MGR 0.50 DISPATCHER FT 2.00 DISPATCHER PT 0.98 CASHIER 0.45 Total FT Equivalent Employees 6.13 Performance Measures City Council Goal: Financially Responsible, High-Performance Organization Performance Measure (KPI)Target CY 2021 CY 2022 CY 2023 Performance Indicator 1 Activity Objective: Provide consistent and clear communication of passenger information and expectations. # Facebook Followers 1,100 846 1,081 1,193 Goal Met # Notify-Me Subscribers 300 271 268 302 Goal Met -58- TRANSPORTATION SERVICES DEPARTMENT TRANSIT DIVISION Bus Operations Mission & Services Bus Operations includes daytime fixed-route services as well as the door-to-door MiniBus services that operate from 4:45 a.m. – 6:45 p.m. on weekdays. A reduced, off-peak schedule is offered from 6:00pm-9:00pm on weeknights and from 8:00am-9:00pm on Saturdays. Bus operations also includes Weekday Park + Ride Service and Nightrider weekend evening service during the school year. Bus Operations Funding Summary FY 2023 Actual FY 2024 Budget FY 2025 Recomm'd Expenditures $2,755,094 $3,234,154 $3,425,781 Resources $2,724,942 $1,949,286 $1,887,986 Bus Operations Position Summary FY 2025 Driver Trainer 1.00 Bus Operator FT 9.00 Bus Operator PT 13.16 Mini-Bus Operator FT 6.00 Mini-Bus Operator PT 6.16 Bus Operator-Trolley Route 0.03 Total FT Equivalent Employees 35.35 Performance Measures Performance Measure (KPI)Target CY 2021 CY 2022 CY 2023 Performance Indicator City Council Goal: Connected Community 1 Activity Objective: Connect people to opportunity by providing access to transit services so people can get to work, school, and recreational activities. % of residents who live within a 5 minute walk from a bus stop 92%93%92%92%Goal Met % of schools within a 5 minute walk from a bus stop 88.2%88.9%88.2%88.2%Goal Met # annual ridership (fixed route and minibus)378,000 319,712 333,311 355,159 Goal in Progress 2 Activity Objective: Improve transit travel time so individuals can spend less time on the bus and more time doing what they choose. -59- TRANSPORTATION SERVICES DEPARTMENT TRANSIT DIVISION Bus Operations Performance Measures (continued) Performance Measure (KPI)Target CY 2021 CY 2022 CY 2023 Performance Indicator City Council Goal: Partnerships for a Better Dubuque 3 Activity Objective: Partner with non-profits, colleges, and other City departments to make accessing transit passes and services simple and affordable. # of partner organizations that purchase bulk passes at non-profit discounted rate and provide them to clients in need 10 9 9 11 Goal Met City Council Goal: Vibrant Community 4 Activity Objective: Promote equity by providing the same opportunity for use of public transit services to those with disabilities as those without. # of routes per year evaluated for ADA compliant stops and amenities 10 10 10 10 Goal Met % of buses with drive-on ramps instead of mechanical lifts 100%50%61%61%Goal in Progress # of Medicaid fares (minibus)3,000 1,165 2,996 2,436 Goal in Progress -60- TRANSPORTATION SERVICES DEPARTMENT TRANSIT DIVISION Bus Maintenance Mission & Services The Public Works mechanics and service workers, led by the Vehicle Maintenance Supervisor, conduct all maintenance of Transit vehicles. Primary responsibilities are preventative maintenance inspections and major and minor repairs to various vehicle systems, including purchasing and stocking parts and supplies in accordance with Federal Transit Administration (FTA) and City of Dubuque policies. Service workers also conduct cleaning of fixed-route vehicles and facilities, which include benches, shelters, the bus storage facility and The Jule’s three transfer locations at JFK Circle, Delhi, and the Intermodal Center. Bus Maintenance Funding Summary FY 2023 Actual FY 2024 Budget FY 2025 Recomm'd Expenditures $185,902 $190,075 $207,557 Resources $137,640 $87,252 $83,876 Bus Maintenance Position Summary FY 2025 Service Worker 2.00 Total FT Equivalent Employees 2.00 Performance Measures Performance Measure (KPI)Target CY 2021 CY 2022 CY 2023 Performance Indicator City Council Goal: Financially Responsible, High-Performance Organization 1 Activity Objective: Reduce accidents and associated costs through ongoing driver training and regular vehicle cleaning and maintenance to extend the service life of the fleet. # at-fault accidents 0 7 4 3 Goal in Progress # hours annual driver training 25 +25+25+25+Goal Met -61- TRANSPORTATION SERVICES DEPARTMENT PARKING DIVISION The Parking Division provides for the parking needs of the public and residents of the City of Dubuque, long term planning to meet future parking needs to support and encourage economic growth and stability in concert with residential parking needs in the downtown area. SUCCESS IS ABOUT PLANNING, PARTNERSHIPS AND PEOPLE LEADING TO OUTCOMES -62- TRANSPORTATION SERVICES DEPARTMENT PARKING DIVISION FY 2023 FY 2024 FY 2025 Full-Time Equivalent 9.90 10.25 11.12 Resources $2,498,507 $2,292,000 $2,635,653 $2,500,525 $2,805,976 $2,615,030 FY 2023 FY 2024 FY 2025 Operating Revenue TIF Revenue for Debt Abatement $0 $500000 $1000000 $1500000 $2000000 $2500000 $3000000 $3500000 The Parking Division is supported by 11.12 full-time equivalent employees, which accounts for 16.04% of the department expense as seen below. Overall, the departments' expenses are expected to increase by 5.92% in FY 2025 compared to FY 2024. Expenditures by Category by Fiscal Year $635,200 $1,084,346 $84,878 $223,618 $2,813,867 $797,759 $1,127,897 $161,097 $254,963 $2,772,382 $869,535 $1,219,373 $215,268 $348,163 $2,762,098 FY 2023 FY 2024 FY 2025 Employee Expense Supplies and Services Machinery and Equipment Administrative Overhead Debt Service $0 $1,000,000 $2,000,000 $3,000,000 -63- TRANSPORTATION SERVICES DEPARTMENT PARKING DIVISION Central Business District Parking Mission & Services The Central Business District is composed of the downtown area, the Port of Dubuque and the Historic Millwork District. Parking issues include variable on-street paid parking in the commercial district, residential permit parking, parking validation programs, parking requirements for new development, a parking information campaign, increasing the parking inventory, shared parking arrangements and additional enforcement of existing regulations. The Parking Division manages six parking ramps, sixteen parking lots in the downtown area and one ramp and three lots in the Port of Dubuque. Off- street parking (ramps and lots) provide monthly, daily, hourly and event parking services to downtown area residents, workers, and visitors so they can park their vehicles in secure, customer-friendly and well-maintained parking facilities. Central Business District Parking Funding Summary FY 2023 Actual FY 2024 Budget FY 2025 Recomm'd Expenditures $1,185,945 $1,153,612 $1,309,442 Resources $1,474,107 $1,709,532 $1,847,863 Central Business District Parking Position Summary FY 2025 TRANSPORTATION SERVICES MGR 0.50 OPERATIONS SUPERVISOR 1.00 TRANSPORTATION ANALYST 0.50 CONFIDENTIAL ACCOUNT CLERK FT 1.30 DISPATCHER 0.50 PARKING SYSTEM TECHNICIAN 2.00 LABORER 0.40 CASHIER 0.20 Total FT Equivalent Employees 6.40 -64- TRANSPORTATION SERVICES DEPARTMENT PARKING DIVISION Metered Parking Mission & Services The Parking Division manages just under 2,000 street and lot parking meters. These consist of time increments of 20 minute, 40 minute, 1 hour, 2 hour, 4 hour and 10 hour. The parking division provides enforcement in the downtown area and in residential and business areas outside the downtown area. The Parking Division offers Passport Parking, allowing motorists to conduct parking transactions by mobile phone. Metered Parking Funding Summary FY 2023 Actual FY 2024 Budget FY 2025 Recomm'd Expenditures $234,826 $355,633 $426,262 Resources $783,137 $862,545 $922,468 Metered Parking Position Summary FY 2025 Parking Meter Checker 3.49 Parking Revenue Collector 0.73 Total FT Equivalent Employees 4.22 Performance Measures City Council Goal: Robust Local Economy Performance Measure (KPI)Target CY 2021 CY 2022 CY 2023 Performance Indicator 1 Activity Objective: Manage parking to maximize the available space. # of expired meter citations 7,250 8,049 7,784 7,093 Goal Met # of courtesy meter citations (no fine for first citation)5,250 5,916 5,452 5,014 Goal Met # of alternate side parking citations issued 2,000 2,115 1,640 2,397 Goal Met # of improper use of disabled parking spaces citations 350 311 312 323 Goal Met -65- Recommended Operating Revenue Budget - Department Total 53 - TRANSIT Fund/Account/Account Title FY22 Actual Revenue FY23 Actual Revenue FY24 Adopted Budget FY25 Recomm'd Budget 690 - Transit Operating 4A - Charges for Services 43300 - Concessions Rent (34,415) (29,184) (34,415) (28,990) 45070 - Advertising Fee (19,055) (9,890) (19,055) (9,890) 45435 - Minibus Passenger Fares (110,783)(123,777)(131,255)(111,990) 45436 - Passenger Fares (114,133)(151,016)(146,195)(142,980) 45437 - Medicaid Fares (36,450)(73,311)(86,786)(68,050) 45438 - Contract Reveue 0 (2,567)0 34 47100 - Reimbursements (3,283)(3,655)(130)(3,655) 47150 - Refunds (94)0 0 0 47200 - Insurance Settlements 0 (10,413)0 0 47450 - Sale of Salvage (5,221)0 0 0 47550 - Concessions Other 0 0 0 0 47562 - Vending Machine Commissions 0 0 0 0 47820 - Specialized Services 0 0 0 0 4A - Charges for Services Total (323,433)(403,813)(417,836)(365,521) 4B - Grants/Contrib 44000 - Federal Grants (1,993,497)(3,016,692)(1,919,493)(1,880,000) 44400 - State Grants (343,428)(424,282)(343,428)(352,876) 47050 - Contrib - Private Sources 0 0 0 0 4B - Grants/Contrib Total (2,336,925)(3,440,974)(2,262,921)(2,232,876) 4N - Transfers 49100 - Transfer In General Fund (1,735,994)(1,706,685)(1,682,830)(2,096,192) 49126 - Transfer in GDTIF (269,572)(281,400)(281,700)(276,900) 49304 - Transfer in Sales Tax 20%(64,138)(69,903)(69,008)(68,300) 4N - Transfers Total (2,069,704)(2,057,988)(2,033,538)(2,441,392) 4O - Eliminated for GW 48200 - Proceeds from GO Debt 0 0 0 0 48205 - Bond Discount/Premium 0 0 0 0 4O - Eliminated for GW Total 0 0 0 0 692 - Intermodal Operating 4A - Charges for Services 41370 - Parking Permits (53,666)(99,893)(53,666)(133,560) 45430 - Daily Parking Fees (8,993)0 (8,993)(8,976) 45432 - Parking Validations (266)0 (266)0 4A - Charges for Services Total (62,925)(99,893)(62,925)(142,536) TRANSIT - Total (4,792,987)(6,002,668)(4,777,220)(5,182,325) -66- Recommended Operating Revenue Budget - Department Total 46 - PARKING Fund/Account/Account Title FY22 Actual Revenue FY23 Actual Revenue FY24 Adopted Budget FY25 Recomm'd Budget 650 - Parking Operating 4A - Charges for Services 41370 - Parking Permits (1,515,180) (1,463,376) (1,459,068) (1,636,667) 43100 - Leases - Building/Land 0 0 0 0 45300 - Forfeitures/Penalties (21,830)(33,539)(21,705)(33,539) 45425 - Parking Lot Rental (9,395)(5,645)(9,395)(3,848) 45428 - Parking Meters (545,129)(509,007)(562,337)(574,842) 45430 - Daily Parking Fees (92,999)(94,660)(92,958)(88,491) 45431 - Parking Rental (61,374)(48,433)(47,236)(51,661) 45432 - Parking Validations (33,109)(34,950)(39,096)(25,388) 47100 - Reimbursements (135,436)(122,776)(135,436)(122,776) 47150 - Refunds 0 0 0 0 47200 - Insurance Settlements (3,408)(9,762)(3,516)0 47450 - Sale of Salvage 0 0 0 0 47700 - District Court Fines (1,235)(1,805)(1,235)(1,805) 47750 - Parking Violation Fees (196,022)(164,333)(240,348)(250,300) 47800 - Miscellaneous Fines (1,895)(1,320)(1,895)(1,895) 4A - Charges for Services Total (2,617,013)(2,489,606)(2,614,225)(2,791,212) 4K - Unrest Invest Earn 43000 - Interest (1,623)(8,902)(21,428)(14,764) 4K - Unrest Invest Earn Total (1,623)(8,902)(21,428)(14,764) 4M - Gain on Disposal 48100 - Sale of Personal Property 0 0 0 0 4M - Gain on Disposal Total 0 0 0 0 4N - Transfers 49126 - Transfer in GDTIF (2,294,625)(2,292,000)(2,500,525)(2,615,030) 4N - Transfers Total (2,294,625)(2,292,000)(2,500,525)(2,615,030) 4O - Eliminated for GW 48200 - Proceeds from GO Debt 0 0 0 0 48205 - Bond Discount/Premium 0 0 0 0 4O - Eliminated for GW Total 0 0 0 0 PARKING - Total (4,913,261)(4,790,507)(5,136,178)(5,421,006) -67- 6A - Salaries & Wages 690 - Transit Operating 60100 - Salaries-Regular Full Time 811,463 1,038,746 1,182,801 1,241,400 60200 - Salaries - Regular Part Time 850,543 743,931 935,044 951,429 60400 - Overtime 11,784 20,330 19,773 19,773 60410 - Overtime - Holiday 23,070 32,904 11,867 11,867 60640 - Special Pay - Vacation Payout 0 11,750 0 0 60740 - Spec Pay - Meal Allowance 0 0 2 0 6A - Salaries & Wages Total 1,696,860 1,847,661 2,149,487 2,224,469 6B - Employee Benefits 690 - Transit Operating 61100 - FICA - City Contribution 124,833 129,397 164,441 169,663 61300 - IPERS - City Contribution 159,887 171,148 202,917 209,986 61510 - Health Insurance 228,060 277,887 304,703 312,757 61540 - Life Insurance 698 966 1,044 1,071 61600 - Workers' Compensation 71,574 88,428 91,885 103,282 61700 - Unemployment Compensation 0 0 0 0 61810 - Uniform Allowance 77 0 0 0 61990 - Other Benefits & Costs 0 0 0 0 61992 - Physicals 5,653 1,541 5,653 3,000 692 - Intermodal Operating 61600 - Workers' Compensation 0 0 0 0 6B - Employee Benefits Total 590,783 669,367 770,643 799,759 6C - Staff Development 690 - Transit Operating 62100 - Association Dues 3,611 3,137 3,683 3,533 62325 - Mileage 0 0 75 0 62400 - Meetings & Conferences 680 3,362 12,000 12,000 62500 - Education Reimbursement 1,877 2,624 3,500 3,500 6C - Staff Development Total 6,169 9,122 19,258 19,033 6D - Repair/Maint/Util 690 - Transit Operating 63100 - Building Maintenance 15,333 18,453 15,333 15,292 63311 - Vehicle Ops - Diesel 274,312 306,513 224,464 297,658 63312 - Vehicle Ops - Gasoline 70,802 73,326 71,213 69,966 63320 - Vehicle Repair - Internal 460,551 429,620 469,704 496,052 63321 - Vehicle Repair - Outsourced 158,323 85,187 161,490 184,501 63322 - Vehicle Repair - Accident 8,317 17,464 4,773 9,073 63323 - Vehicle Repair - Warranty 0 0 0 0 63325 - Tires/Tubes 39,743 57,338 40,538 42,872 63400 - Equipment Maint/Repair 231 1,374 235 8,011 63440 - Uniform Maintenance 0 0 0 0 63710 - Electricity 26,398 27,386 26,398 30,070 63711 - Natural Gas 17,361 22,232 17,360 22,232 63730 - Telecommunications 24,043 26,963 24,043 24,218 Recommended Operating Expenditure Budget - Department Total 53 - TRANSIT Fund/Account/Account Title FY22 Actual Expense FY23 Actual Expense FY24 Adopted Budget FY 25 Recomm'd Budget -68- 63740 - Water 7,156 7,705 7,871 8,707 63741 - Sanitary Sewer 646 841 763 959 63742 - Stormwater 3,490 3,351 3,724 3,890 692 - Intermodal Operating 63100 - Building Maintenance 4,229 5,322 4,229 5,322 63400 - Equipment Maint/Repair 0 77 0 679 63710 - Electricity 5,697 22,439 5,697 24,638 63730 - Telecommunications 149 0 149 149 63740 - Water 1,150 0 1,264 0 63742 - Stormwater 128 0 137 0 6D - Repair/Maint/Util Total 1,118,058 1,105,590 1,079,385 1,244,289 6E - Contractual Svcs 690 - Transit Operating 64004 - Internal Service Charge 0 0 0 0 64010 - Accounting & Auditing 3,500 6,000 3,500 6,000 64020 - Advertising 2,910 1,147 2,910 7,000 64030 - Outsourced Labor 0 0 0 0 64062 - Refunds 0 0 0 0 64080 - Insurance - Property 10,783 13,773 15,426 22,330 64081 - Insurance - Liability 51,084 66,320 80,784 124,032 64100 - Labor Relations 0 0 500 500 64110 - Legal 987 150 0 0 64130 - Payments to Other Agencies 30,000 16,250 65,000 30,000 64140 - Printing 15,773 924 4,941 9,940 64145 - Copying 1,102 1,169 1,102 1,169 64175 - Landfill Fees 216 0 216 0 64190 - Technology Services 69,670 78,933 89,066 82,924 64191 - IT Recharges 0 12,288 13,012 20,534 64195 - Credit Card Charge 3,134 3,234 3,134 3,234 64800 - Courier Fee 0 0 0 0 64825 - Fire Suppression 2,102 2,772 2,102 2,772 64865 - Elevator Service 1,944 2,705 2,400 2,705 64880 - Custodial Services 1,037 1,547 3,753 6,096 64890 - Background Check 0 0 0 0 64900 - Other Professional Service 0 0 3,500 3,500 64975 - Equip Maint Cont 1,197 1,197 1,197 1,197 64980 - Technology Equip Maint Cont 18,558 5,694 5,513 9,260 64987 - Lawn Care Contract 0 0 280 280 64988 - Snow Removal Contract 465 0 1,620 5,097 692 - Intermodal Operating 64030 - Outsourced Labor 0 0 0 0 64062 - Refunds 60 418 60 0 64080 - Insurance - Property 2,760 0 0 0 64081 - Insurance - Liability 2,129 0 3,367 5,170 64190 - Technology Services 0 0 1,550 1,550 64195 - Credit Card Charge 1,099 0 1,099 1,099 Recommended Operating Expenditure Budget - Department Total 53 - TRANSIT Fund/Account/Account Title FY22 Actual Expense FY23 Actual Expense FY24 Adopted Budget FY 25 Recomm'd Budget -69- 64825 - Fire Suppression 1,149 20 1,149 20 64865 - Elevator Service 863 1,275 1,273 2,520 64880 - Custodial Services 0 0 0 0 64975 - Equip Maint Cont 0 0 0 0 64980 - Technology Equip Maint Cont 9,628 2,517 3,510 11,661 64987 - Lawn Care Contract 0 162 167 167 64988 - Snow Removal Contract 9,687 12,107 4,046 10,897 6E - Contractual Svcs Total 241,836 230,601 316,177 371,654 6F - Commodities 690 - Transit Operating 65040 - Small Tools & Equipment 128 702 2,000 2,000 65045 - Technology Equipment 13,778 3,583 21,070 51,756 65054 - Safety Equipment 390 0 0 0 65056 - Traffic Security Cameras 0 2,975 0 0 65060 - Office Supplies 1,518 8,510 1,518 1,400 65080 - Postage/Shipping 399 501 419 526 65100 - Safety Supplies 2,047 3,641 2,046 1,836 65110 - Signage 0 710 0 0 65925 - Uniform Purchase 11,490 11,400 22,135 15,135 65930 - Flags 2,222 0 600 1,800 65960 - Repair Parts 919 259 919 259 65965 - Janitorial 5,628 5,436 5,628 5,969 692 - Intermodal Operating 65012 - De-Icing Product 0 0 0 0 65045 - Technology Equipment 0 0 0 0 65056 - Traffic Security Cameras 0 5,625 0 0 65060 - Office Supplies 6 0 6 0 65965 - Janitorial 117 34 117 34 6F - Commodities Total 38,642 43,375 56,458 80,715 6G - Capital Outlay 690 - Transit Operating 67100 - Vehicles 0 0 0 0 67230 - Heavy Equipment 0 0 0 18,576 67270 - Other Capital Equipment 0 0 0 0 6G - Capital Outlay Total 0 0 0 18,576 6H - Debt Service 690 - Transit Operating 68010 - Principal Payment 258,679 281,469 286,166 286,194 68020 - Interest Payments 75,031 70,043 64,543 59,006 68980 - Financial Consultant 0 0 0 0 68990 - Paying Agent Fees 0 0 0 0 6H - Debt Service Total 333,710 351,512 350,709 345,200 TRANSIT - TOTAL 4,026,057 4,257,228 4,742,117 5,103,695 Recommended Operating Expenditure Budget - Department Total 53 - TRANSIT Fund/Account/Account Title FY22 Actual Expense FY23 Actual Expense FY24 Adopted Budget FY 25 Recomm'd Budget -70- 6A - Salaries & Wages 650 - Parking Operating 60100 - Salaries-Regular Full Time 321,103 358,151 462,914 482,888 60200 - Salaries - Regular Part Time 145,108 117,990 126,244 166,707 60300 - Hourly Wages - Temp/Seasonal 0 0 0 0 60400 - Overtime 7,337 1,013 4,000 4,000 60410 - Overtime - Holiday 1,872 237 0 0 60630 - Special Pay Sick Lv Payout Ret 0 0 0 0 60640 - Special Pay - Vacation Payout 0 1,331 0 0 6A - Salaries & Wages Total 475,419 478,723 593,158 653,595 6B - Employee Benefits 650 - Parking Operating 61100 - FICA - City Contribution 34,668 35,003 45,378 50,000 61300 - IPERS - City Contribution 44,816 45,066 55,994 61,699 61510 - Health Insurance 71,676 71,143 97,989 97,989 61540 - Life Insurance 216 246 336 336 61600 - Workers' Compensation 3,523 4,444 4,346 5,340 61700 - Unemployment Compensation 0 0 0 0 61810 - Uniform Allowance 0 0 0 0 61992 - Physicals 142 576 558 576 6B - Employee Benefits Total 155,041 156,477 204,601 215,940 6C - Staff Development 650 - Parking Operating 62100 - Association Dues 0 0 695 0 62325 - Mileage 0 0 75 0 62400 - Meetings & Conferences 0 1,134 3,690 3,690 62500 - Education Reimbursement 0 1,181 2,000 2,000 6C - Staff Development Total 0 2,315 6,460 5,690 6D - Repair/Maint/Util 650 - Parking Operating 63100 - Building Maintenance 29,552 58,677 50,680 66,235 63312 - Vehicle Ops - Gasoline 6,522 5,774 10,840 10,415 63320 - Vehicle Repair - Internal 17,698 11,629 18,052 11,861 63321 - Vehicle Repair - Outsourced 1,405 358 1,433 365 63322 - Vehicle Repair - Accident 0 18 0 0 63400 - Equipment Maint/Repair 8,602 17,784 12,043 19,721 63710 - Electricity 239,071 234,132 253,309 267,548 63711 - Natural Gas 19,654 17,321 19,654 17,321 63720 - Refuse 500 631 513 689 63730 - Telecommunications 25,395 31,334 25,394 31,013 63740 - Water 22,801 32,470 25,082 36,691 63742 - Stormwater 3,543 4,146 4,180 5,213 6D - Repair/Maint/Util Total 374,745 414,273 421,180 467,072 6E - Contractual Svcs 650 - Parking Operating 64010 - Accounting & Auditing 2,800 5,750 2,800 5,750 Recommended Operating Expenditure Budget - Department Total 46 - PARKING Fund/Account/Account Title FY22 Actual Expense FY23 Actual Expense FY24 Adopted Budget FY 25 Recomm'd Budget -71- 64020 - Advertising 975 900 975 900 64040 - Collections 20 0 20 0 64050 - Recording Fees 285 190 285 190 64062 - Refunds 181 3,113 181 746 64080 - Insurance - Property 110,088 132,710 138,727 215,728 64081 - Insurance - Liability 5,525 6,782 7,701 11,985 64110 - Legal 0 0 0 0 64130 - Payments to Other Agencies 20,000 26,000 23,000 26,000 64140 - Printing 863 6,308 4,539 6,799 64145 - Copying 730 242 755 744 64150 - Rental - Equipment 0 0 0 0 64160 - Rental - Land/Bldgs/Parking 5,454 6,520 5,454 6,520 64180 - Sales Tax Expense 0 0 0 0 64190 - Technology Services 57,281 57,737 40,121 42,087 64191 - IT Recharges 0 17,488 17,613 3,101 64195 - Credit Card Charge 36,943 42,156 45,925 42,157 64200 - Handling/Service Fee 14,934 19,094 19,368 19,094 64825 - Fire Suppression 6,584 4,116 7,692 6,362 64865 - Elevator Service 31,706 45,894 35,669 35,893 64880 - Custodial Services 0 901 1,925 1,925 64900 - Other Professional Service 0 0 100 0 64975 - Equip Maint Cont 7,743 11,147 8,823 11,147 64980 - Technology Equip Maint Cont 68,199 39,218 71,018 84,822 64987 - Lawn Care Contract 6,495 22,566 18,425 18,921 64988 - Snow Removal Contract 143,956 209,974 225,508 189,771 692 - Intermodal Operating 64988 - Snow Removal Contract 0 0 0 0 6E - Contractual Svcs Total 520,763 658,807 676,624 730,642 6F - Commodities 650 - Parking Operating 65012 - De-Icing Product 0 0 0 0 65045 - Technology Equipment 1,858 4,689 94,957 126,268 65056 - Traffic Security Cameras 0 25,900 0 0 65060 - Office Supplies 199 596 1,010 1,092 65080 - Postage/Shipping 11,973 5,795 14,586 6,885 65100 - Safety Supplies 0 0 0 0 65110 - Signage 0 0 0 0 65925 - Uniform Purchase 64 1,437 5,669 5,669 65930 - Flags 0 100 1,300 1,300 65965 - Janitorial 550 1,023 1,068 1,023 65999 - Cash Over and Short (15)0 0 0 6F - Commodities Total 14,628 39,541 118,590 142,237 6G - Capital Outlay 650 - Parking Operating 67100 - Vehicles 0 54,289 66,140 89,000 67230 - Heavy Equipment 0 0 0 0 Recommended Operating Expenditure Budget - Department Total 46 - PARKING Fund/Account/Account Title FY22 Actual Expense FY23 Actual Expense FY24 Adopted Budget FY 25 Recomm'd Budget -72- 6G - Capital Outlay Total 0 54,289 66,140 89,000 6H - Debt Service 650 - Parking Operating 68010 - Principal Payment 1,259,493 1,341,378 1,371,132 1,434,490 68020 - Interest Payments 1,538,788 1,472,489 1,401,250 1,327,608 68980 - Financial Consultant 0 0 0 0 68990 - Paying Agent Fees 0 0 0 0 6H - Debt Service Total 2,798,281 2,813,867 2,772,382 2,762,098 6I - Transfers 650 - Parking Operating 69100 - Transfers Out To General Fund 211,318 223,618 254,963 348,163 69651 - Transfers Out to Parking Cap 0 0 0 0 6I - Transfers Total 211,318 223,618 254,963 348,163 PARKING - TOTAL 4,550,195 4,841,909 5,114,098 5,414,437 Recommended Operating Expenditure Budget - Department Total 46 - PARKING Fund/Account/Account Title FY22 Actual Expense FY23 Actual Expense FY24 Adopted Budget FY 25 Recomm'd Budget -73- 5301 - Administration 690 - Transit Operating 6A - Salaries & Wages 427,370 405,204 412,207 6B - Employee Benefits 148,997 155,798 156,765 6C - Staff Development 9,122 19,258 19,033 6D - Repair/Maint/Util 98,189 84,674 97,116 6E - Contractual Svcs 125,410 167,028 199,733 6F - Commodities 16,900 50,001 34,813 6G - Capital Outlay ——— 5301 - Administration Total 825,988 881,963 919,667 5302 - Intermodal 690 - Transit Operating 6A - Salaries & Wages 32,392 15,358 33,821 6B - Employee Benefits 6,194 3,292 14,623 6D - Repair/Maint/Util 16,450 13,010 13,707 6E - Contractual Svcs 22,256 24,675 37,935 6F - Commodities 3,747 1,061 41,498 692 - Intermodal Operating 6B - Employee Benefits 0 0 0 6D - Repair/Maint/Util 27,838 11,476 30,788 6E - Contractual Svcs 16,499 16,221 33,084 6F - Commodities 5,659 123 34 5302 - Intermodal Total 131,036 85,216 205,490 5303 - Bus Operations 690 - Transit Operating 6A - Salaries & Wages 746,375 1,062,448 1,093,494 6B - Employee Benefits 278,291 361,383 373,457 6D - Repair/Maint/Util 672,250 715,233 802,799 6E - Contractual Svcs 41,160 45,599 45,604 6F - Commodities 4,292 0 0 5303 - Bus Operations Total 1,742,368 2,184,663 2,315,354 5304 - MiniBus Operations 690 - Transit Operating 6A - Salaries & Wages 515,278 545,217 564,461 6B - Employee Benefits 187,365 199,679 204,229 6D - Repair/Maint/Util 284,932 241,333 286,042 6E - Contractual Svcs 25,152 62,508 55,152 6F - Commodities 0 754 543 5304 - MiniBus Operations Total 1,012,727 1,049,491 1,110,427 Recommended Expenditure Budget Report by Activity & Funding Source 53 - TRANSIT Fund/Activity FY23 Actual Expense FY24 Adopted Budget FY25 Recomm'd Budget -74- 5305 - Bus Maintenance 690 - Transit Operating 6A - Salaries & Wages 126,246 121,260 120,486 6B - Employee Benefits 48,520 50,491 50,685 6D - Repair/Maint/Util 5,933 13,659 13,837 6E - Contractual Svcs 124 146 146 6F - Commodities 5,080 4,519 3,827 6G - Capital Outlay 0 0 18,576 5305 - Bus Maintenance Total 185,902 190,075 207,557 5380 - Debt Service 690 - Transit Operating 6E - Contractual Svcs 0 0 0 6H - Debt Service 351,512 350,709 345,200 5380 - Debt Service Total 351,512 350,709 345,200 5399 - Pcard Clearing 690 - Transit Operating 6F - Commodities 7,697 0 0 5399 - Pcard Clearing Total 7,697 0 0 TRANSIT TOTAL 4,257,228 4,742,117 5,103,695 Recommended Expenditure Budget Report by Activity & Funding Source 53 - TRANSIT Fund/Activity FY23 Actual Expense FY24 Adopted Budget FY25 Recomm'd Budget -75- 0000 - No Sub-Activity 650 - Parking Operating 6E - Contractual Svcs —100 — 6H - Debt Service ——— 6I - Transfers 223,618 254,963 348,163 0000 - No Sub-Activity Total 223,618 255,063 348,163 4601 - Administration 650 - Parking Operating 6A - Salaries & Wages 245,816 274,661 305,114 6B - Employee Benefits 84,217 91,876 97,143 6C - Staff Development 2,315 6,460 5,690 6D - Repair/Maint/Util 38,789 41,004 40,659 6E - Contractual Svcs 89,397 89,222 93,663 6F - Commodities 12,039 18,700 13,042 6I - Transfers ——— 4601 - Administration Total 472,572 521,923 555,311 4602 - Ramps 650 - Parking Operating 6B - Employee Benefits 0 0 0 6C - Staff Development 0 0 0 6D - Repair/Maint/Util 301,248 319,287 348,371 6E - Contractual Svcs 385,124 400,923 462,976 6F - Commodities 26,837 91,798 89,616 6G - Capital Outlay 0 0 0 6H - Debt Service 0 0 0 4602 - Ramps Total 713,209 812,008 900,963 4603 - Lots 650 - Parking Operating 6B - Employee Benefits 0 0 0 6D - Repair/Maint/Util 37,571 22,273 39,950 6E - Contractual Svcs 109,506 106,685 97,177 6F - Commodities 0 0 0 4603 - Lots Total 147,077 128,958 137,127 4604 - Street Meters 650 - Parking Operating 6A - Salaries & Wages 13,547 23,315 23,639 6B - Employee Benefits 2,878 4,697 4,753 6D - Repair/Maint/Util 7,119 5,043 7,167 6E - Contractual Svcs 41,463 42,671 41,449 6F - Commodities 0 0 0 4604 - Street Meters Total 65,007 75,726 77,008 4605 - Meter Enforcement 650 - Parking Operating Recommended Expenditure Budget Report by Activity & Funding Source 46 - PARKING Fund/Activity FY22 Actual Expense FY23 Adopted Budget FY24 Recomm'd Budget -76- 6A - Salaries & Wages 98,448 138,191 154,209 6B - Employee Benefits 21,518 53,551 57,018 6D - Repair/Maint/Util 18,952 20,915 20,403 6E - Contractual Svcs 30,157 33,938 32,201 6F - Commodities 600 6,172 38,779 6G - Capital Outlay 0 27,140 46,500 4605 - Meter Enforcement Total 169,675 279,907 349,110 4606 - Parking Maintenance 650 - Parking Operating 6A - Salaries & Wages 120,095 135,544 148,830 6B - Employee Benefits 47,260 50,355 52,789 6D - Repair/Maint/Util 10,595 12,658 10,522 6E - Contractual Svcs 1,850 1,841 1,841 6F - Commodities 0 1,120 0 6G - Capital Outlay 54,289 39,000 42,500 4606 - Parking Maintenance Total 234,089 240,518 256,482 4607 - Residential Parking District 650 - Parking Operating 6A - Salaries & Wages 816 21,447 21,803 6B - Employee Benefits 605 4,122 4,237 6E - Contractual Svcs 1,309 1,244 1,335 6F - Commodities 0 800 800 4607 - Residential Parking District Total 2,730 27,613 28,175 4680 - Debt Service 650 - Parking Operating 6H - Debt Service 2,813,867 2,772,382 2,762,098 4680 - Debt Service Total 2,813,867 2,772,382 2,762,098 4699 - Pcard Clearing 650 - Parking Operating 6F - Commodities 65 0 0 4699 - Pcard Clearing Total 65 0 0 5302 - Intermodal 692 - Intermodal Operating 6E - Contractual Svcs 0 0 0 5302 - Intermodal Total 0 0 0 PARKING TOTAL 4,841,909 5,114,098 5,414,437 Recommended Expenditure Budget Report by Activity & Funding Source 46 - PARKING Fund/Activity FY22 Actual Expense FY23 Adopted Budget FY24 Recomm'd Budget -77- 61010 Full Time Employee Expense 630 GE-41 TRANSPORTATION SERVICES MGR 0.50 $ 48,849 0.50 $ 59,100 0.50 $ 65,728 600 GE-41 TRANSPORTATION SERVICES MGR 0.50 $ 48,849 0.50 $ 59,100 0.50 $ 65,728 630 3000 GE-35 OPERATIONS SUPERVISOR 1.00 $ 92,037 1.00 $ 91,315 1.00 $ 96,247 600 3000 GE-35 OPERATIONS SUPERVISOR 1.00 $ 87,654 1.00 $ 86,967 1.00 $ 91,664 630 GE-31 TRANSPORTATION ANALYST 0.50 $ 35,412 0.50 $ 37,041 0.50 $ 31,290 600 GE-31 TRANSPORTATION ANALYST 0.50 $ 35,412 0.50 $ 37,041 0.50 $ 31,297 630 760 GE-25 CONFIDENTIAL ACCOUNT CLERK 1.30 $ 66,774 1.30 $ 69,844 1.30 $ 73,619 600 760 GE-25 CONFIDENTIAL ACCOUNT CLERK 0.70 $ 35,955 0.70 $ 37,608 0.70 $ 39,641 630 2205 GD-08 PARKING SYSTEM TECHNICIAN 2.00 $ 119,451 2.00 $ 119,826 2.00 $ 127,715 600 637 GD-04 TRANSIT SERVICE WORKER 2.00 $ 112,782 2.00 $ 117,968 2.00 $ 119,473 630 870 GD-04 LABORER-G.D.—$ — —$ — 1.00 $ 57,463 600 GD-03 DISPATCHER 2.00 $ 103,125 2.00 $ 108,028 2.00 $ 109,138 600 7200 AT-02 BUS OPERATOR 15.00 $ 653,658 15.00 $ 670,737 15.00 $ 706,485 630 6170 OE-03 PARKING METER CHECKER —$ — 2.00 $ 85,788 2.00 $ 90,714 600 GE-30 DRIVER TRAINER —$ — 1.00 $ 65,352 1.00 $ 61,968 TOTAL FULL TIME EMPLOYEES 27.00 $ 1,439,958 30.00 $ 1,645,715 31.00 $ 1,768,170 61020 Part Time Employee Expense 630 6170 OE-03 PARKING METER CHECKER 3.30 $ 135,794 1.65 $ 73,850 1.99 $ 85,298 630 OE-05 CASHIER 0.20 $ 8,202 0.20 $ 9,395 0.20 $ 9,500 600 OE-05 CASHIER 0.45 $ 18,454 0.45 $ 21,139 0.45 $ 21,375 600 NA-48 DRIVER TRAINER 0.55 $ 25,483 —$ — —$ — 630 NA-27 PARKING REVENUE COLLECTOR 0.73 $ 20,013 0.73 $ 23,315 0.73 $ 23,639 630 GD-03 DISPATCHER 0.10 $ 4,655 0.10 $ 4,966 0.50 $ 26,223 600 GD-04 LABORER 0.28 $ 14,365 0.28 $ 15,358 —$ — 630 GD-04 LABORER 0.27 $ 13,773 0.27 $ 14,718 —$ — 600 GD-03 DISPATCHER 0.98 $ 45,640 0.98 $ 48,821 0.98 $ 51,357 600 7210 AT-02 BUS OPERATOR 19.35 $ 828,718 19.35 $ 849,726 19.35 $ 896,763 TOTAL PART TIME EMPLOYEES 26.21 $ 1,115,097 24.01 $ 1,061,288 24.20 $ 1,114,155 61030 Seasonal Employee Expense 600 NA-38 MARKETING INTERN —$ — —$ — —$ — TOTAL SEASONAL EMPLOYEES —$ — —$ — —$ — TOTAL TRANSPORTATION SERVICES 53.21 $ 2,555,055 54.01 $ 2,707,003 55.20 $ 2,882,325 C I T Y O F D U B U Q U E , I O W A DEPARTMENT DETAIL - PERSONNEL COMPLEMENT 53 TRANSPORTATION SERVICES DEPARTMENT FY 2023 FY 2024 FY 2025 FD JC WP-GR JOB CLASS FTE BUDGET FTE BUDGET FTE BUDGET -78- Transit Admin and Operations-FT Transit Fund 60053100 61010 600 GE-25 CONFIDENTIAL ACCOUNT CLERK 0.70 $ 35,955 0.70 $ 37,608 0.70 $ 39,641 60053100 61010 600 GE-31 TRANSPORTATION ANALYST 0.50 $ 35,412 0.50 $ 37,041 0.50 $ 31,290 60053100 61010 600 GE-31 FIELD SUPERVISOR —$ — —$ — —$ — 60053100 61010 600 GE-35 OPERATIONS SUPERVISOR 1.00 $ 87,654 1.00 $ 86,967 1.00 $ 91,664 60053100 61010 600 GE-41 TRANSPORTATION SERVICES MGR 0.50 $ 48,849 0.50 $ 59,100 0.50 $ 65,728 60053100 61010 600 GD-03 DISPATCHER 2.00 $ 103,125 2.00 $ 108,028 2.00 $ 109,138 Total 4.70 $ 310,995 4.70 $ 328,744 4.70 $ 337,461 Transit Admin and Operations-PT Transit Fund 60053100 61020 600 4740 GD-03 DISPATCHER 0.98 $ 45,640 0.98 $ 48,821 0.98 $ 51,357 60053100 61020 600 OE-05 CASHIER 0.45 $ 18,454 0.45 $ 21,139 0.45 $ 21,375 Total 1.43 $ 64,094 1.43 $ 69,960 1.43 $ 72,732 Intermodal Facility-FT Transit Fund 60053370 61010 600 GD-04 LABORER —$ — —$ — 0.60 $ 34,478 Total —$ — —$ — 0.60 $ 34,478 Intermodal Facility-PT Transit Fund 60053370 61020 600 GD-04 LABORER 0.28 $ 14,365 0.28 $ 15,358 —$ — Total 0.28 $ 14,365 0.28 $ 15,358 —$ — Bus Operations-FT Transit Fund 60053400 61010 600 7200 AT-02 BUS OPERATOR 8.00 $ 342,046 9.00 $ 401,919 9.00 $ 423,515 60053400 61020 600 4765 NA-48 DRIVER TRAINER —$ — —$ — 1.00 $ 61,968 Total 8.00 $ 342,046 10.00 $ 467,271 10.00 $ 485,483 Bus Operations-PT Transit Fund 60053400 61020 600 4765 NA-48 DRIVER TRAINER 0.55 $ 25,483 —$ — —$ — 60053400 61020 600 7210 AT-02 BUS OPERATOR 14.01 $ 589,921 13.16 $ 577,276 13.16 $ 609,794 Total 14.56 $ 615,404 13.16 $ 577,276 13.16 $ 609,794 Mini-Bus Operations-FT Transit Fund 60053500 61010 600 AT-02 BUS OPERATOR 7.00 $ 311,612 6.00 $ 268,818 6.00 $ 282,970 Total 7.00 $ 311,612 6.00 $ 268,818 6.00 $ 282,970 Mini-Bus Operations-PT Transit fund 60053500 61020 600 7210 AT-02 BUS OPERATOR 5.31 $ 237,432 6.16 $ 271,022 6.16 $ 285,463 Total 5.31 $ 237,432 6.16 $ 271,022 6.16 $ 285,463 Trolley Operations-PT Transit fund 60053600 61020 600 7210 AT-02 BUS OPERATOR 0.03 $ 1,365 0.03 $ 1,428 0.03 $ 1,506 Total 0.03 $ 1,365 0.03 $ 1,428 0.03 $ 1,506 Bus Maintenance-FT Transit Fund 60053700 61010 600 GD-04 TRANSIT SERVICE WORKER 2.00 $ 112,782 2.00 $ 117,968 2.00 $ 119,473 Total 2.00 $ 112,782 2.00 $ 117,968 2.00 $ 119,473 Parking Administration-FT Parking Fund 63046100 61010 630 GE-41 TRANSPORTATION SERVICES MGR 0.50 $ 48,849 0.50 $ 59,100 0.50 $ 65,728 63046100 61010 630 GE-35 OPERATIONS SUPERVISOR 1.00 $ 92,037 1.00 $ 91,315 1.00 $ 96,247 CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2023 FY 2024 FY 2025 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET -79- 63046100 61010 630 GE-31 TRANSPORTATION ANALYST 0.50 $ 35,412 0.50 $ 37,041 0.50 $ 31,297 63046100 61010 630 GE-31 FIELD SUPERVISOR —$ — —$ — —$ — 63046100 61010 630 760 GE-25 CONFIDENTIAL ACCOUNT CLERK 1.30 $ 66,774 1.00 $ 53,726 1.00 $ 56,630 63046100 61010 630 GD-03 DISPATCHER —$ — —$ — 0.50 $ 26,223 Total 3.30 $ 243,072 3.00 $ 241,182 3.50 $ 276,125 Parking Administration -PT Parking Fund 63046100 61020 630 760 GE-25 CONFIDENTIAL ACCOUNT CLERK —$ — 0.30 $ 16,118 0.30 $ 16,989 63046100 61020 630 OE-05 CASHIER 0.20 $ 8,202 0.20 $ 9,395 0.20 $ 9,500 63046100 61020 630 GD-03 DISPATCHER 0.10 $ 4,655 0.10 $ 4,966 —$ — Total 0.30 $ 12,857 0.60 $ 30,479 0.50 $ 26,489 Parking Lots-FT Parking Fund 63046400 61010 630 2,205 GD-08 PARKING SYSTEM TECHNICIAN —$ — —$ — —$ — Total —$ — —$ — —$ — Parking Meters-PT Parking Fund 63046420 61020 630 NA-27 PARKING REVENUE COLLECTOR 0.73 $ 20,013 0.73 $ 23,315 0.73 $ 23,639 Total 0.73 $ 20,013 0.73 $ 23,315 0.73 $ 23,639 Meter Enforcement-FT Parking Fund 63046430 61020 630 6170 OE-03 PARKING METER CHECKER —$—2.00 $85,788 2.00 $ 90,714 Total —$—2.00 $85,788 2.00 $ 90,714 Meter Enforcement-PT Parking Fund 63046430 61020 630 6170 OE-03 PARKING METER CHECKER 2.80 $ 115,410 1.15 $ 52,403 1.49 $ 63,495 Total 2.80 $ 115,410 1.15 $ 52,403 1.49 $ 63,495 Parking Maintenance-FT Parking Fund 63046700 61010 630 2205 GD-08 PARKING SYSTEM TECHNICIAN 2.00 $ 119,451 2.00 $ 119,826 2.00 $ 127,715 63046700 61010 630 GD-04 LABORER —$ — —$ — 0.40 $ 22,985 Total 2.00 $ 119,451 2.00 $ 119,826 2.40 $ 150,700 Parking Maintenance-PT Parking Fund 63046400 61020 630 GD-04 LABORER 0.27 $ 13,773 0.27 $ 14,718 —$ — Total 0.27 $ 13,773 0.27 $ 14,718 —$ — Residential District-PT Parking Fund 63046800 61020 630 6170 OE-03 PARKING METER CHECKER 0.50 $ 20,384 0.50 $ 21,447 0.50 $ 21,803 Total 0.50 $ 20,384 0.50 $ 21,447 0.50 $ 21,803 TOTAL TRANSPORTATION SERVICES DEPARTMENT 53.21 $ 2,555,055 53.51 $ 2,674,327 55.20 $ 2,882,325 CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2023 FY 2024 FY 2025 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET -80- Capital Improvement Projects by Department/Division TRANSIT DIVISION Project Number Capital Improvement Project Title Department Fund Account FY 25 Recomm'd Budget 5385000002 Bus Replacements Transit 691 67100 510,000 5385000003 Bus Stop Improvements Transit 691 67990 11,487 5385000003 Bus Stop Improvements Transit 691 67270 3,000 5385000003 Bus Stop Improvements Transit 691 64075 3,446 5385000004 REPLACE FIXED ROUTE BUSES Transit 691 67100 439,000 TRANSIT DIVISION TOTAL 966,933 PARKING DIVISION Project Number Capital Improvement Project Title Department Fund Account FY 25 Recomm'd Budget 4683000001 Municipal Parking Lot Maint Parking 305 67,990 47,000 4683000001 Municipal Parking Lot Maint Parking 305 64,075 6,000 4683000002 Parking Ramp Maintenance Parking 305 64,075 70,000 4683000002 Parking Ramp Maintenance Parking 305 67,500 5,333,000 4683000002 Parking Ramp Maintenance Parking 305 64,900 650,000 4683000005 Smart Parking System Parking 305 67,990 1,815,000 4683000005 Smart Parking System Parking 305 64,900 100,000 4683000005 Smart Parking System Parking 305 64,075 42,000 4683000007 Port of Dubuque Parking Lot Resurfa Parking 305 67,990 200,000 4683000007 Port of Dubuque Parking Lot Resurfa Parking 305 64,075 25,000 4683000008 Port of Dubuque Ramp Maint Parking 651 67,990 86,282 PARKING DIVISION TOTAL 8,374,282 TRANSPORTATION SERVICES TOTAL 9,341,215 -81- PRGRM/ DEPT PROJECT DESCRIPTION FY 2025 FY 2026 FY 2027 FY 2028 FY 2029 TOTAL PAGE TRANSPORTATION SERVICES DEPARTMENT Transit Division Business Type Bus Stop Improvements $ 17,933 $ 18,232 $ 39,665 $ — $ — $ 75,830 266 Transit Vehicle Replacement $ 949,000 $ 1,417,596 $ 915,343 $ 364,400 $ 367,608 $ 4,013,947 267 Parking Division Business Type Port of Dubuque Parking Lot Resurfacing $ 225,000 $ — $ — $ — $ — $ 225,000 268 Smart Parking System $ 1,957,000 $ 780,000 $ — $ — $ — $ 2,737,000 269 Municipal Parking Lot Maintenance $ 53,000 $ 55,500 $ 57,500 $ 59,500 $ — $ 225,500 270 Port of Dubuque Ramp - Major Maintenance $ 86,282 $ 88,007 $ 89,768 $ 91,563 $ 93,395 $ 449,015 271 Parking Ramp Major Maintenance Repairs $ 6,053,000 $ 1,240,000 $ 1,317,000 $ 960,000 $ 1,032,000 $ 10,602,000 272 TOTAL $ 9,341,215 $ 3,599,335 $ 2,419,276 $ 1,475,463 $ 1,493,003 $ 18,328,292 -82- This page intentionally left blank. -83- Engineering -84- This page intentionally left blank. -85- ENGINEERING DEPARTMENT Budget Highlights FY 2023 Actual FY 2024 Budget FY 2025 Requested % Change From FY 2024 Budget Expenses Employee Expense 2,338,517 4,302,866 4,569,994 6.2 % Supplies and Services 2,197,941 2,907,230 3,152,975 8.5 % Machinery and Equipment 711,617 854,234 865,520 1.3 % Payment to Construction Fund — 400,000 700,000 75.0 % Less Recharges to Service Funds (1,440) (1,900,867) (1,893,464) (0.4) % Administrative Overhead Charges 659,648 1,192,164 1,982,609 66.3 % Total Expenses 5,906,283 7,755,627 9,377,634 20.9 % Resources Operating Revenue - General 130,652 241,033 134,600 (44.2) % Federal Building Lease Revenue 376,664 338,564 339,687 0.3 % Lease Expense Reimbursement 126,720 177,742 205,709 15.7 % Administrative OH Recharges 448,101 736,468 1,093,746 48.5 % Road Use Tax Funds 500,764 708,557 816,068 15.2 % Utility Charges - Parking 1,270 3,243 5,934 83.0 % Utility Charges - Water 56,268 50,182 64,109 27.8 % Utility Charges - Stormwater 1,873,477 3,172,536 4,340,674 36.8 % Utility Charges - Sanitary 414,504 423,683 460,926 8.8 % Total Resources 3,928,420 5,852,008 7,461,453 27.5 % Debt Service Stormwater debt abated with Stormwater User Fees 2,760,840 2,838,842 2,603,779 (8.3) % Stormwater debt abated with Sales Tax Increment 4,675,827 5,640,609 5,645,274 0.1 % Street Projects Debt abated with Sales Tax Fund (30%)/RUT 152,049 359,886 369,442 2.7 % FEMA Land Buyout Abated with General 7,054 6,878 6,711 (2.4) % Total Debt Service 7,595,770 8,846,215 8,625,206 (2.5) % Property Tax Support 1,977,863 1,903,619 1,916,181 12,562 Percent Increase/(Decrease) 0.7 % Personnel - Authorized FTE 40.21 40.92 41.71 -86- STORMWATER UTILITY Budget Highlights FY 2023 Actual FY 2024 Budget FY 2025 Requested % Change From FY 2024 Budget Expenses Employee Expense 233,833 643,286 679,028 5.6 % Supplies and Services 904,779 1,111,843 1,189,671 7.0 % Payment to Construction Fund — 400,000 700,000 75.0 % Less Recharges to Service Funds (1,111) (301,629) (349,504) 15.9 % Machinery and Equipment 75,217 79,483 89,005 12.0 % Administrative Overhead Recharge 659,648 1,192,164 1,982,609 66.3 % Park Stormwater Maintenance Charges 134,163 155,103 165,670 6.8 % Public Information Office 1,111 47,389 49,865 5.2 % Public Works Stormwater Maintenance Charges 272,623 298,467 314,200 5.3 % Debt Service 7,436,667 8,479,451 8,249,053 (2.7) % Total Expenses 9,716,930 12,105,557 13,069,597 8.0 % Resources Operating Revenue 6,267,882 6,402,520 7,482,494 16.9 % Sales Tax Increment 4,675,827 5,640,609 5,645,274 0.1 % Total Resources 10,943,709 12,043,129 13,127,768 9.0 % Net Operating Surplus (Deficit) 1,226,779 (62,428) 58,171 120,599 Personnel - Authorized FTE 6.29 5.54 6.58 Stormwater User Fee Rate Increase 1.69 % 11.11 % 15.00 % Stormwater User Fee (per SFU)$ 9.00 $ 10.00 $ 11.50 Revenue 1% Rate Increase Generates $ 59,888 -87- FACILITIES MANAGEMENT Budget Highlights FY 2023 Actual FY 2024 Budget FY 2025 Requested % Change From FY 2024 Budget Expenses Employee Expense 560,325 595,643 654,671 9.9 % Supplies and Services 610,056 759,710 809,998 6.6 % Machinery and Equipment 15,205 82,200 41,900 (49.0) % Debt Service 125,989 138,006 143,301 3.8 % Total Expenses 1,311,575 1,575,559 1,649,870 4.7 % Resources Federal Building Lease Revenue 376,664 338,564 339,687 0.3 % Debt on Building Improvements Paid with Sales Tax 125,989 138,006 143,301 3.8 % Total Resources 502,653 476,570 482,988 1.3 % Property Tax Support 808,922 1,098,989 1,166,882 67,893 Percent Increase/(Decrease) 6.2 % Personnel - Authorized FTE — 7.60 7.70 *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, 5th Street Restrooms Maintenance, Shot Tower Maintenance, and the former Hendrick's Warehouse. Improvement Package Summary 1 of 6 This improvement package request is to upgrade an existing small car to a pickup truck (Engineering Vehicle #905, which is used by the Right of Way Management Technician). The existing small car has been approved for replacement in the FY 2025 by the City Fleet Supervisor based on an inspection of the vehicle. Replacing this vehicle another small car is not possible, as neither small or midsize cars are available through the governmental vehicle fleet procurement programs. Thus, it is required to purchase either a midsize SUV or pickup truck. For the functional use of vehicles in the Engineering Department, a pickup truck will provide the most versatility. Pickup trucks allow Engineering Staff to transport more equipment. This request is related to City Council goal: Connected Community: Equitable Transportation, Technology Infrastructure, and Mobility. Related Cost:$ 17,000 Tax Funds Non-Recurring Recommend - Yes Total Cost:$ 17,000 Property Tax Impact:$ 0.0067 0.08% Activity: Streets -88- 2 of 6 This improvement package request is for Engineering and Housing to hold a joint annual meeting intended for area contractors for the purpose of educating attendees on updates to building codes and specifications. The State-wide Urban Design and Specifications (SUDAS) and the City of Dubuque supplemental specifications are updated every year. The Housing department follows the International Building Code, which also has periodic updates. This annual meeting would allow Engineering and Housing staff to provide area contractors with updates about the ever-changing specifications on an annual basis. This meeting would also serve as an opportunity for City Staff to answer questions and address concerns with area contracts. The meeting would be held at the Grand River Center. This request request is for $5,000 in total to cover the cost of the room rental at the Grand River Center ($1,000), food and refreshments for meeting attendees ($2,500), as well as a stipend for guest speakers to come in to present ($1,500). This improvement package request related to the City Council Goal Livable Neighborhoods and Housing: Great Place to Live. This improvement package educates contractors to ensure specifications are followed, thus improving safety and providing safe housing conditions in the City. Related Cost:$ 1,666 Tax Funds Recurring Recommend - No Related Cost:$ 1,667 Stormwater User Fees Recurring Related Cost:$ 1,667 Sanitary User Fees Recurring Total Cost:$ 5,000 Property Tax Impact:$ 0.0007 0.01% Activity: Facilities Management 3 of 6 This improvement package request is to upgrade the scheduled FY 2025 replacement of a current Engineering Staff computer from a desktop to an engineering laptop. The anticipated increase in budget is approximately $1,200 every four years. The City does not allow the use of personal computers and personal mobile phones to remotely access resources directly on the City’s network. In addition, section 9.12 of the Employee Handbook notes that approved telecommuters will be provided the tools and applications for access to city technology resources. There are several times through out a year when a laptop would be needed in a remote access situation (such as illness, conference attendance, Board/ Commission presentations, etc.). The laptop will be only used by the assigned Engineering staff member who will work remotely for the previously indicated reasons. This request helps meet the City Council Goal of being a Financially Responsible, High-Performance City Organization: Sustainable, Equitable, and Effective Service Delivery. Equipping staff with effective and modern technology that creates flexibility allows the organization to be high performance through a variety of situations. Related Cost:$ 1,200 Stormwater User Fees Non-Recurring Recommend - No Related Cost:$ — Tax Funds Non-Recurring Total Cost:$ 1,200 Stormwater User Fee Impact: 0.02 % Activity: Stormwater Operations 4 of 6 This improvement package request would allocate funding to establish a program to vacate two to three parcels of City property each year. The intent of this package is to reduce the City's liability with all vacant parcels. Vacant parcels pose a liability risk for the City. Under this new program, property owners that are adjacent to vacant City parcels would be contacted by the City to discuss the property owner's interest in acquiring all or part of the vacant parcel that is owned by City. This package will cover the costs related to vacating the existing excess right of way to adjacent property owners, thus reducing long term liability to the City. This improvement package request relates to the City Council Goal: Vibrant Community: Health and Safe. Reducing the holding of excess property reduces liability and risk to the City and taxpayers. -89- Related Cost:$ 15,000 Tax Funds Recurring Recommend - No Related Revenue:$ 10,000 Tax Funds Recurring Total Cost:$ 5,000 Property Tax Impact:$ 0.0059 0.07% Activity: Streets 5 of 6 This improvement package request is for the addition of one full-time HVAC Technician position (1.00 FTE, OE-16) to the Engineering Department. This position will provide various services to all city departments in an effort to reduce dependency on outside contractors. Working in coordination with Project and Facilities Management, the HVAC Technician would be responsible for HVAC asset management, preventative maintenance, servicing and life cycle analysis of all city HVAC systems. In addition, this position will be responsible for servicing boiler systems and conducting backflow testing at City facilities, which are also services that are frequently contracted out. Hiring contractors for these services is a major expense across the City. If this position is funded, there will be offsetting costs savings from hiring contracts less frequently, though the total cost savings is unclear at this time and would be fully realized in future years. This packages budgets for expenses related to wages and benefits ($88,816), safety equipment ($250), employee physicals ($142, one time), small tools and equipment ($1,500 one time), training and education ($2,000), meetings and conferences ($1,000), subscriptions ($500), association dues ($600), technology equipment including a cell phone and tablet ($1,270, one time), and data plans ($700), and data plans for those devices ($744). This package meets the City Council goals of Financially Responsible, High Performance City Organization. Related Cost:$ 93,910 Tax Funds Recurring Recommend - No Related Cost:$ 2,912 Tax Funds Non-Recurring Total Cost:$ 96,822 Property Tax Impact:$ 0.0369 0.41% Activity: Facilities Management 6 of 6 This improvement package request provides funding to allow complex or expedited development site plan review work to be outsourced to outside engineering consultants. For certain large or technically complex projects, the Engineering Department sometimes lacks enough available technical staff to complete reviews within a specifically requested timeframe. This funding will allow the Engineering Department to better balance workloads by outsourcing work so that reviews of private developer plans can be processed within requested deadlines. This request supports the City Council Goal Financially Responsible, High Performance City Organization: Sustainable, Equitable, and Effective Service Delivery. Additional consultant services that empower the Engineering Department to stay in line with deadlines and time frame allows the organization to remain high performance and effectively deliver services. Related Cost:$ 50,000 Tax Funds Recurring Recommend - No Total Cost:$ 50,000 Property Tax Impact:$ 0.0197 0.22% Activity: Project Engineering -90- Significant Line Items Employee Expense 1.FY 2025 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 2024. 3.The City portion of health insurance expense is unchanged from $1,119 in FY 2024 to $1,119 in FY 2025 per month, per contract, which results in an annual cost unchanged of $2,347 or 0.0%. 4.Overtime is unchanged from $72,640 in FY 2024 to $72,640 in FY 2025. FY 2023 actual was $51,596. 5.Five-Year Retiree Sick leave payout decreased from $11,748 in FY 2024 to $0 in FY 2025. 6.50% Sick Leave Payout decreased from $16,388 in FY 2024 to $15,765 in FY 2025 based on FY 2023 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.During Fiscal Year 2024, the following personnel changes were approved: a.The addition of a full-time Engineering Technician (GE-31, 1.00 FTE), resulting in a cost increase of $84,860 in FY 2024. b.The elimination of a temporary Lease Management Intern (NA-34, 0.25 FTE), which created a cost savings of $9,525, and the addition of a full-time Confidential Account Clerk (GE-25, 1.00 FTE), which created a cost increase of $61,246. This resulted in a net cost increase of $51,721 in FY 2024. 8.In preparation of the budget recommendation, the work of each Engineering staff member is projected for the coming fiscal year. For example, with the completion of the Bee Branch Creek Railroad Culverts project in FY 2022, staff may have shifted to other non-stormwater-funded capital improvement projects. As a result, adjustments--usually minor--are made each year. The FY 2025 budget includes the following changes in the funding allocation of positions: 1. a.Confidential Account Clerk i.-0.25 FTE from General Fund (-$18,432) ii.+0.10 FTE to Project Engineering Internal Service Fund (+$7,373) iii.+0.10 FTE to Stormwater Internal Service Fund (+$7,373) iv.+0.05 FTE to Sanitary Sewer Internal Service Fund (+$3,686) b.Civil Engineer II i.+0.10 FTE to General Fund (+12,662) ii.+0.15 FTE to Sanitary Sewer Fund (+$18,993) iii.-0.12 FTE from Stormwater Fund (-$15,195) iv.-0.10 FTE from Project Engineering Internal Service Fund (-$12,662) v.-0.03 FTE from Stormwater Internal Service Fund (-$3,799) vi.+0.05 FTE was previously incorrectly listed as Civil Engineer I Stormwater Fund, it was changed and corrected to Civil Engineer II Stormwater Fund to align with the approved full time equivalent (+$6,331). c.Civil Engineer I -91- i.-0.05 FTE was previously incorrectly listed as Civil Engineer I Stormwater Fund, it was changed and corrected to Civil Engineer II Stormwater Fund to align with the approved full time equivalent (-$6,331). d.Engineering Technician i.-0.90 FTE from Project Engineering Internal Service Fund (-$82,173) ii.+0.15 FTE to General Fund (+$13,695) iii.+0.05 FTE to Sanitary Sewer Fund (+$4,565) iv.+0.13 FTE to Stormwater Fund (+11,870) v.+0.20 FTE to Sanitary Sewer Internal Service Fund (+$18,261) vi.+0.37 FTE to Stormwater Internal Service Fund (+33,782) e.Project Support Specialist (formerly known as Secretary) i.+0.10 FTE to General Fund (+$9,762) ii.-0.05 FTE from Sanitary Sewer Internal Service Fund (-$4,881) iii.-0.05 FTE from Stormwater Internal Service Fund (-$4,881) f.Traffic Engineer i.-0.02 FTE from General Fund (-$1,089) ii.+0.02 FTE to Parking Fund (+$1,089) g.Survey Technician i.-0.10 FTE from Project Engineering Internal Service Fund (-$8,729) ii.+0.10 FTE to General Fund (+$8,729) As a result of the proposed changes above, the net increase (+) or net decrease (-) for each fund is as follows: Sanitary Sewer Fund is +$23,558, Stormwater Fund is -$3,325, General Project Engineering Internal Service Fund (ISF) is -$96,191, General Sanitary Sewer ISF is +$17,066, General Stormwater ISF is +$1,307, General Fund is +$25,327, Parking Fund is +$1,089. 9.The following limited term intern positions ended during Fiscal Year FY 2024: a.Youth AmeriCorps Program Intern -0.32 FTE (-$4,333 Sanitary Sewer Fund, -$4,333 Stormwater Fund, -$4,334 General Fund) b.Engineering Intern (Records) -0.32 FTE (-$5,639 Sanitary Sewer Fund, -$5,639 Stormwater Fund, -$5,640 General Fund) c.Engineering Intern (Construction/Safety) -0.32 FTE (-$3,278, Sanitary Sewer Fund, -$3,278 Stormwater Fund, -$3,279 General Fund) Supplies & Services 10.Other Professional Services increased from $173,207 in FY 2024 to $175,858 in FY 2025. This line item represents hiring consultants and third parties for assistance with Engineering tasks. In FY 2025, this includes general Stormwater consultants ($35,000), National Pollutant Discharge Elimination System (NPDES) consultant services for permit requirements ($87,302), Stormwater Inflow and Infiltration (I&I) prevention ($8,500), detention basin maintenance ($27,040), stormwater ditch remediation ($3,000), and project engineering consultants ($15,016). 11.Subdivision Inspection Reimbursement expense is unchanged from $66,000 in FY 2024 to $66,000 in FY 2025 based on estimated development activity. This line item represents refunds issued to developers for subdivision inspection fees. These fees are paid by developers in advance. In some -92- instances, the actual cost of the inspection is less than what the developer paid in advance, resulting in the developer receiving a refund for the difference. In FY 2025, there is an estimated offsetting revenue of $100,000 in the Subdivision Inspection Fee revenue line item. 12.Pay to Other Agency decreased from $153,416 in FY 2024 to $150,845 in FY 2025. This line item includes the contract with East Central Iowa Association (ECIA) for transportation planning ($25,000) which decreased $5,650 from FY 2024 due to adjusting the budget to reflect the terms of the agreement. The the FY 2024 budget for ECIA transportation planning was a based on the best information available at the time, but the FY 2024 budget turned out to be higher than the actual expense of the agreement. This line items also includes the Catfish Creek Watershed Partnership payment ($125,845) as part of the 28E agreement with Dubuque County and the Dubuque Soil & Water Conservation District for the Dubuque County Watershed Program, which increased $3,079 in FY 2025 per the terms of the agreement. 13.Grant expense is increased from $493,843 in FY 2024 to $544,484 in FY 2025. This line item includes various subsidies and financial assistance programs that are available through the Engineering department. This includes the stormwater enterprise fund utility fee subsidies for low income households ($25,491), residential farms ($13,510), and property tax-exempt properties ($480,483), which are are all based on FY 2023 actuals plus a 11.11% rate increase for FY 2024 as well as an estimated 15.00% rate increase for FY 2025, thus causing an increase from the FY 2024 budget. 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. This line item also includes $10,000 for private sanitary sewer lateral replacement assistance, $5,000 for stream bank stabilization assistance, and $5,000 for rain garden/rain barrel assistance. Finally, this line item includes $5,000 for snow removal assistance, which is used to assist low/moderate income citizens with physical limitations. The snow removal funds also help cover the administration of volunteers to help with snow removal and associated shovel and salt supplies. The subsidies and financial assistance programs are funded through their respective utility funds. The only exception to this is the snow removal program, which is funded by the general fund. 14.Sales Tax expense increased from $194,745 in FY 2024 to $208,902 in FY 2025 based on the FY 2023 actual of 179,061 plus a 11.11% rate increase for FY 2024 as well as an estimated 15.00% rate increase for FY 2025. This line item represents sales tax collected from monthly stormwater utility fees (including both state sales tax and local options sales tax), which is then paid to the State of Iowa. This expense is directly offset by sales tax revenue. 15.Electricity decreased from $261,151 in FY 2024 to $234,561 in FY 2025 based on the FY 2023 actual of $187,750 and expected rate increases. Alliant Energy has give notice of a 9.8% rate increase that will begin in October of 2024. The overall decrease can be attributed in part to a correction for the Multicultural Family Center. The actual utilization is less than the estimated utilization that was budgeted for the FY 2024 budget. The FY 2024 budget was estimated based on FY 2022 actuals and addition of new facilities. FY 2025 reflects the budget adjustment for the actual costs of those facilities based on their FY 2023 actual. 16.Natural Gas increased from $76,623 in FY 2024 to $86,490 in FY 2025. The FY 2023 actual was $80,253. The overall increase from FY 2023 actual can be attributed Engine House #1 being non- operational during a renovation in FY 2023. 17.Building Maintenance decreased from $199,532 in FY 2024 to $196,889 in FY 2025. This line item represents money set aside for unexpected repairs and maintenance at City buildings and facilities. Though using past actuals to budget for this account is challenging due to some areas seeing no emergency repairs during a year, the overall decrease in this account is due to an effort to better align the FY 2025 budget levels with past year actual maintenance for each building. Each building has a -93- set maintenance budget that is allocated each year. The buildings with notable changes in FY 2025 maintenance budgets include: a.City Hall maintenance decreased from $74,540 in FY 2024 to $60,000 in FY 2025. The FY 2024 budget was above normal levels and was based on the FY 2022 actual of $74,540. The FY 2023 actual was $25,820. b.Federal Building maintenance increased from $35,000 in FY 2024 to $42,540 in FY 2025 based on the FY 2023 actual. Maintenance at the Federal Building continues to increase in an effort to do preventative maintenance rather than reactive maintenance. The Federal Building has recently seen the need for many repairs. Other buildings and facilities in this line item include the City Hall Annex, Engine House No. 1, the 5th Street Restrooms, Storm Ditch Remediation, the Multicultural Family Center (MFC), and the Detention Basin Maintenance. These areas saw no major changes. 18.Property Insurance increased from $72,413 in FY 2024 to $146,746 in FY 2025 based on information received from Iowa Communities Assurance Pool (ICAP). 19.Technology Services increased from $288,611 in FY 2024 to $394,337 in FY 2025. The FY 2023 actual was $218,873. This line item represents various pieces of software used by the Engineering department, as well as data plans for iPads. This line item is variable each year due to some software renewals not being due every year. Software prices generally increase each year. The FY 2025 budget includes the following amounts a.Engineering Admin totals $10,688 b.Facility Management totals $14,869 c.Project Engineering totals $269,738 d.Traffic Engineering totals $41,655 e.Sanitary Admin totals $35,452 f.Stormwater Admin totals $21,935 In FY 2025, the activity that saw major change was Project Engineering, which increased from $181,418 in FY 2024 to $269,738 in FY 2025. This increase is due to FY 2025 having major software renewals, which are based on a schedule and do not occur every year. Parsons support software ($37,000) was added in FY 2025 due to the need of the software for the STREETS project. The other activities saw no major changes and reflect general price increases and renewal schedules. 20.Technology Equipment Maintenance Contract is unchanged from $81,729 in FY 2024 to $81,729 in FY 2025. This line item represents maintenance contracts for security cameras and traffic cameras. 21.Property Tax expense increased from $146,023 in FY 2024 to $149,631 in FY 2025. The FY 2023 actual was $91,998. This line item represents the property taxes paid on property that the City leases to other entities and is offset by lease revenue. Property tax expenses continue to rise due to property valuation increases based on estimated market values. Actual property tax expenses thus far in FY 2024 are $126,420. All FY 2024 property taxes have been paid, no further property tax expense are anticipated in FY 2024. 22.Equipment Maintenance Repair decreased from $72,109 in FY 2024 to $61,430 in FY 2025. The FY 2023 actual was $22,649. This line item represents money set aside for repairs and maintenance for machinery at City buildings and facilities. Each City building/facility has a set budget for emergency machinery repairs that is allocated each year. Using past actuals to budget for this account is challenging due to some buildings/facilities seeing no emergency repairs to machinery during a year. The overall decrease from FY 2024 is due to a decrease in the Multicultural Family Center (MFC) machinery repair budget. The MFC budget decreased $13,000 in FY 2025 due to the need to better -94- align the budget with actual expenses. The FY 2024 budget for the MFC was an estimated based on the best information available at the time. Actual expenses have been much lower than those estimations, therefore, the budget is being reduced in FY 2025. 23.Education Reimbursement increased from $66,474 in FY 2024 to $74,610 in FY 2025. This line item represents various training and professional development opportunities for Engineering staff. This line item also includes Continuing Education Units (CEUs) for Professional Engineering certifications. The cost of trainings increases each year due to increases in registration fees. The cost of CEUs for Professional Engineers increased $2,700 per certification in FY 2025. The FY 2025 budget includes the cost of Iowa Department of Transportation (IDOT) recertification courses. The IDOT recertification courses are required for some Engineering staff and is an expense that occurs approximately every three years. Machinery & Equipment 24.Equipment replacement items include ($865,520): Engineering Administration Label Makers (2)$ 600 Chairs/Desks $ 1,200 Smart phone with case and accessories $ 405 Facilities Management Smart phones (5) with case and accessories $ 1,900 Project Engineering General Fund Desks/Chairs $ 1,200 Drone Accessories $ 1,000 Network Switches (2)$ 3,200 Transition Switches (2)$ 2,600 Wireless Link (8)$ 14,400 Cameras (3)$ 5,400 Full-size Truck $ 36,000 Traffic Engineering General Fund Smart phones (10) with cases and accessories $ 4,240 Traffic Engineering Road Use Tax Fund Label Maker $ 300 Pan-Tilt-Zoom Cameras (11)$ 35,200 Battery Back-Ups $ 30,000 Hyperconvergence Server $ 60,000 Streets Servers $ 30,000 Video Mgmt Work Station CPU $ 10,000 Offsite Storage $ 5,000 Network Switch-3rd St Fiber 3 $ 13,000 Wireless Point to Point (2)$ 10,000 Hardened Intersection Switches (19)$ 65,000 Engineering Machinery and Equipment -95- Extenders for Camera $ 5,000 Cameras $ 180,000 Batteries (60)$ 12,000 Battery Backups $ 3,000 Array Network CHASSIS $ 2,000 LCD Monitor 70"$ 5,000 LCD Monitor 65" Sony $ 2,500 Traffic Counters (3)$ 5,250 Firewall $ 10,000 Virtual Servers $ 15,000 Video Monitor CPU $ 10,000 Project Engineering Sanitary Sewer Fund Sanitary Sewer Grinder Pumps (3)$ 10,000 Gas Air Meters (2) & Field Safety Equipment $ 750 Smart Phone with case and accessories $ 750 Emergency Self Contained Breathing Apparatus Respirators $ 4,000 Project Engineering Stormwater Fund Weather Station $ 1,100 Level Transducers $ 7,500 Smart phones (5) with cases and accessories $ 2,025 Flow Meters $ 15,000 Annual Maintenance General Building Maintenance $ 40,000 General Stormwater Repairs/Maintenance $ 50,000 General Sanitary Sewer Repairs/Maintenance $ 122,000 Stormwater Ditch Remediation $ 15,000 Recommended Improvement Packages $ 17,000 Total Equipment $ 865,520 Engineering Machinery and Equipment •Two sewer grinder pumps are replaced on an annual basis. In FY 2025, the annual budget for replacement increased by $2,000 due to industry-wide price increases. There are approximately 100 units in existence. •Two flow meters are replaced on an annual basis. In FY 2025, the annual budget for replacement increased by $13,000 due to industry-wide price increases. There are approximately 20 units in existence. Debt Service 25.Annual Debt Service Payments for FY 2025 are as follows ($8,625,205): -96- $ 26,670 2017A G.O.Sales Tax 30%Fiber Optic & Street Light 2029 2025 $ 195,000 2017A G.O.Stormwater Fees Stormwater Improvements 2029 2025 $ 475 2017A G.O.Sales Tax 30%Street Improvements 2030 2025 $ 54,587 2006 SRF Stormwater Fees North Catfish Creek 2030 $ 120,320 2009 SRF Stormwater Fees West 32nd Detention Basin 2030 $ 72,245 2018A G.O.Sales Tax 30%Southwest Arterial 2031 2026 $ 160,541 2018A G.O.Stormwater Fees Stormwater Improvements 2031 2026 $ 123,368 2021A G.O.Stormwater Fees Stormwater Improvements 2031 2028 $ 6,711 2019C G.O.Sales Tax 30%FEMA Flood Buyout 2027 2026 $ 30,185 2019C G.O.Stormwater Fees Stormwater Improvements 2033 2026 $ 80,363 2021A G.O.Sales Tax 30%Southwest Arterial 2032 2028 $ 7,906 2021A G.O.Stormwater Fees Stormwater Improvements 2032 2028 $ 413,452 2010 SRF Stormwater Fees Lower Bee Branch 2032 $ 1,400,500 2014A G.O.Sales Tax Increment Bee Branch Watershed 2029 2024 $ 46,863 2021A G.O.Sales Tax 30%Street Improvements 2034 2028 $ 20,360 2014 SRF Stormwater Fees Lower Bee Branch 2034 $ 1,475,806 2015B SRF Sales Tax Increment Upper Bee Branch 2035 $ 2,768,968 2015A Revenue Sales Tax Increment Bee Branch Watershed 2029 2026 $ 476,000 2016B G.O.Stormwater Fees Stormwater Refunding 2036 2024 $ 18,271 2016C G.O.Sales Tax 20%Federal Building Roof 2037 2024 $ 1,002,060 2019 SRF Stormwater Fees Bee Branch Watershed 2038 $ 16,723 2023 G.O.Sales Tax 20% Engine House #1 Second Floor 2044 $ 4,678 2017A G.O.Sales Tax 20%Smart Meters 2029 2025 $ 22,672 2021A G.O.Sales Tax 20%City Hall Improvements 2032 2028 $ 56,031 2018B G.O.Sales Tax 20%Engine House #1 Renovation 2031 2026 $ 24,450 2019C G.O.Sales Tax 20%City Hall Improvements 2027 2026 $ 8,625,205 Total Engineering Annual Debt Service Amount Debt Series Source Purpose Final Payment Call Date Revenue 26.Riverfront Leases increased from $3,897,839 in FY 2024 to $4,110,287 in FY 2025 based on the projected revenue which is as follows: Artco Fleeting Service $ 800 $ 1,000 Owen Lindstrom dba Dubuque by Carriage $ 3,600 $ 3,600 DRA Parking Lot Lease $ 624,379 $ 662,401 Dubuque Historical Society $ — $ 1 Pier Pressure Marine formerly Dubuque Marina $ 37,832 $ 80,000 Dubuque Terminals Dove Harbor $ 136,511 $ 147,079 Dubuque Yacht Basin $ 201,407 $ 201,407 Flint Hill Resources $ 753,528 $ 776,134 MacHom Windows LLC $ 418,000 $ 431,045 Scales Mound dba River Cruises $ 5,000 $ 5,000 Riverfront Lease FY24 Budget FY25 Budget -97- Viterra USA Grain - Purina Drive $ 248,521 $ 255,977 Viterra USA Grain - Commercial Street $ 403,168 $ 415,263 Viterra USA Grain - Land By City Salt Pile $ 298,939 $ 307,908 Viterra USA Grain - Dove Harbor $ 608,815 $ 627,080 Port of Dubuque Brewery Development LLC $ 73,877 $ 105,730 Platinum Holdings LLC $ 83,462 $ 90,662 $ — $ — Total $ 3,897,839 $ 4,110,287 Riverfront Lease FY24 Budget FY25 Budget 27.Wharfage Fees on Leased Property increased from $153,850 in FY 2024 to $166,623 in FY 2025. This revenue is dependent on how much business is being conducted at the Wharf. The detail of the revenue is as follows: Wharfage Fees on Leased Property FY24 Budget FY25 Budget Gavilon - Commercial Street $ 82,000 $ 84,460 Gavilon Dove Harbor $ 30,450 $ 31,363 Gavilon - Salt Site $ 17,400 $ 17,922 Flint Hill Resources $ 24,000 $ 32,878 Total $ 153,850 $ 166,623 28.Non-Riverfront Lease increased from $188,832 in FY 2024 to $196,011 in FY 2025. The detail of the lease revenue is as follows: Dubuque Rescue Mission $ 1 $ 1 HHH Enterprises $ 2,532 $ 2,739 Hartig Drug $ 2,077 $ 2,275 Hawkeye Area Community Action Plan $ 31,800 $ 30,144 Interstate Power & Light Co (Graf Farm Solar)$ 9,194 $ 9,470 16th St. Detention Basin - Rainbo Oil $ 143,228 $ 151,382 Total $ 188,832 $ 196,011 Non-Riverfront Lease FY24 Budget FY25 Budget 29.Federal Building Lease increased from $338,245 in FY 2024 to $339,514 in FY 2025.The detail of the lease revenue is as follows: Tenant FY24 Budget FY25 Budget Bellstar Media $ 2,363 $ 2,434 Dubuque Area Labor Management Council $ 5,025 $ 3,491 a Dubuque County Task Force $ 21,292 $ 21,927 Juvenile Court Services $ 69,921 $ 71,984 United States Post Office $ 238,476 $ 238,476 Hillcrest $ 1,168 $ 1,202 Total 338,245 339,514 -98- 30.Fiber Leases increased from $18,201 in FY 2024 to $18,340 in FY 2025. This line item represents leases with ImOn ($7,090), US Cellular ($4,500), Southwest Co. ($1,950), and Wisconsin Independent Network ($4,800). 31.Telecom Leases are unchanged from $9,600 in FY 2024 to $9,600 in FY 2025. This line item represents a lease with Aureon. 32.Subdivision Inspection Fees decreased from $219,077 in FY 2024 to $100,000 in FY 2025 based on the estimated development activity in the community. The FY 2025 budget includes inspection fees for the following anticipated developments: Mozena Farms/Switch Homes ($45,000); South Point Subdivision Phase 2 ($35,000); Gantz Apartment Development ($10,000); and Callahan Apartment Development ($10,000). Subdivision inspection fees in FY 2024 were estimated at $219,077, and actual fees collected to-date are $125,752. Subdivision inspection fees in FY 2023 were estimated at $70,000, and actual fees collected were $24,600. Subdivision inspection fees in FY 2022 were estimated at $75,000, and actual fees collected were $202,365. 33.Stormwater Penalties increased from $22,043 in FY 2024 to $48,557 in FY 2025 based on the FY 2023 actual of $41,621 plus a 11.11% rate increase for FY 2024 as well as an estimated 15.00% rate increase for FY 2025. This line item represents late fees related to the stormwater utility. 34.The FY 2025 Stormwater User Fee increased from $10.00 per SFU to $11.50 per SFU, a 15.00% increase. 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 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 cities approved for the funding. 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. Due to the uncertain economic impacts of the COVID-19 pandemic, there was no increase in FY2021 as part of the City's Coronavirus relief response. 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 did not reach $9.00 per month until FY 2023, six years later than previously scheduled. The table below compares the rates adopted in FY 2023 and FY 2024 to the rate proposed with the FY 2025 budget. -99- Stormwater Utility User Fee Rates Rate Per Single Family Unit (SFU) Fiscal Year 2021 - Adopted Per Ordinance 21-20 $ 8.29 Fiscal Year 2022 - Adopted Per Ordinance 10-21 $ 8.85 Fiscal Year 2023 - Adopted Per Ordinance 13-22 $ 9.00 Fiscal Year 2024 - Adopted Per Ordinance 14-23 $ 10.00 Fiscal Year 2025 - Recommended $ 11.50 FY25 Recommended Increase 15.00 % -100- ENGINEERING DEPARTMENT The engineering department promotes the health, safety, and welfare of ALL through 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 -101- -102- ENGINEERING DEPARTMENT FY 2023 FY 2024 FY 2025 Full-Time Equivalent 40.21 40.92 41.71 Resources FY 2023 FY 2024 FY 2025 Operating R e v e n u e Administra t i v e R e c h a r g e s Road Use T a x Stormwat e r Sanitary 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 $4,000,000 $4,500,000 $5,000,000 The Engineering Department is supported by 41.71 full-time equivalent employees, which accounts for 48.73% of the department expense as seen below. Overall, the department's expenses are expected to increase by 20.91% in FY 2025 compared to FY 2024. $2,338,517 $2,197,941 $711,617 $— $659,648 $4,302,866 $2,907,230 $854,234 $400,000 $1,192,164 $4,569,994 $3,152,975 $865,520 $700,000 $1,982,609 FY 2023 FY 2024 FY 2025 Employee Expense Supplies and Services Machinery and Equipment Construction Fund Administrative Overhead Charges $0 $775,000 $1,550,000 $2,325,000 $3,100,000 $3,875,000 $4,650,000 -103- 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 2023 Actual FY 2024 Budget FY 2025 Recomm'd Expenditures $1,513,859 $2,752,294 $2,855,997 Resources $(3,665,428)$2,205,476 $(2,089,273) 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.95 Civil Engineer II - Service Fund 1.05 Confidential Account Clerk- Leases 0.55 Confidential Account Clerk 0.35 Confidential Account Clerk - Service Fund 0.55 Engineering Intern - Service Fund 0.75 Engineering Assistant II 0.10 Engineering Assistant II - Service Fund 0.85 Engineering Technician - Inspection 0.70 Engineering Technician 1.60 Engineering Technician - Service Fund 2.58 Project Manager 0.25 Project Manager- Leases 0.10 Project Manager - Service Fund 0.35 ROW Technician 0.95 ROW Technician - Service Fund 0.05 Secretary - Admin 0.20 Secretary - Engineering 0.50 Secretary- Service Fund 0.00 Survey Party Chief 0.15 Survey Party Chief - Service Fund 0.30 Right-of-way and Streets Position Summary FY 2025 -104- Survey Technician 0.25 Survey Technician - Service Fund 0.20 Surveyor 0.80 Surveyor - Service Fund 0.10 Traffic Engineer 0.50 Traffic Engineer - Service Fund 0.60 Total FT Equivalent Employees 18.83 Right-of-way and Streets Position Summary FY 2025 -105- ENGINEERING DEPARTMENT Right-of-Way Management and Streets Performance Measures City Council Goal: Connected Community Performance Measure (KPI)Target FY 2022 Actual FY 2023 Actual FY 2024 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%Goal Met # of ADA curb ramps installed 100 288 110 139 Goal Met 2 Activity Objective: Provide complete, safe, and efficient street systems. Avg. condition rating (out of 100) of all Dubuque streets 70 73 73 73 Goal Met # of vehicle crashes in the City of Dubuque N/A 1,433 1,397 1,400 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 624 830 N/A Cracked and heaving sidewalk - Tripping hazard New ADA Curb Ramps -106- 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 2023 Actual FY 2024 Budget FY 2025 Recomm'd Expenditures $4,417,161 $5,672,313 $6,657,067 Resources $4,417,161 $5,672,313 $6,657,067 Stormwater Position Summary FY 2025 Civil Engineer II 0.90 Civil Engineer II - Service Fund 0.32 Civil Engineer I 0.00 Civil Engineer I- Service Fund 0.05 City Engineer 0.15 City Engineer - Service Fund 0.05 Engineering Technician 0.40 Traffic Engineer - Residential Parking 0.05 Engineering Technician - Service Fund 1.30 Engineering Technician - Water 0.15 Engineering Assistant II - Service Fund 0.05 Secretary - Stormwater Fund 0.05 Secretary- Service Fund 0.05 Survey Party Chief - Service Fund 0.25 Survey Technician - Service Fund 0.25 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.50 Total FT Equivalent Employees 7.28 -107- Performance Measures City Council Goal: Livable Neighborhoods and Housing Performance Measure (KPI)Target FY 2022 Actual FY 2023 Actual FY 2024 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 Goal In Progress 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%100%Goal Met -108- 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 2023 Actual FY 2024 Budget FY 2025 Recomm'd Expenditures $414,504 $792,022 $842,774 Resources $4,500 $394,098 $390,848 Sanitary Sewer Collection Position Summary FY 2025 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.35 Project Manager 0.10 Project Manager - Service Fund 0.10 Engineering Technician 0.55 Engineering Technician - Service Fund 2.03 Survey Party Chief - Service Fund 0.30 Survey Technician - Service Fund 0.30 Secretary 0.05 Secretary - Service Fund 0.05 Confidential Account Clerk 0.25 Confidential Account Clerk - Service Fund 0.20 Utility Locator 0.50 Total FT Equivalent Employees 5.58 Performance Measures City Council Goal: Sustainable Environment Performance Measure (KPI)Target FY 2022 Actual FY 2023 Actual FY 2024 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 344 Goal In Progress 2 Activity Objective: Reconstruct Sanitary Sewer Manholes and Pipe # of brick sanitary sewer manholes replaced 15 18 6 4 Goal Not Met -109- 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 2023 Actual FY 2024 Budget FY 2025 Recomm'd Expenditures $232,558 $308,125 $333,625 Resources $5,100 $50,313 $56,675 Traffic Engineering Position Summary FY 2025 Secretary 0.05 Confidential Account Clerk 0.20 Utility Locator 0.50 Engineering Technician 0.16 Surveyor 0.10 Traffic Engineer 0.75 Engineering Technician- Service Fund 0.40 Traffic Engineer - Service Fund 0.10 Total FT Equivalent Employees 2.26 Performance Measures City Council Goal: Financially Responsible, High Performance Organization Performance Measure (KPI)Target FY 2022 Actual FY 2023 Actual FY 2024 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%58%61%Goal In Progress 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%33%35%Goal In Progress 3 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%Goal In Progress # of miles annually of conduit installed N/A 4.75 4.29 3.92 N/A -110- 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 2023 Actual FY 2024 Budget FY 2025 Recomm'd Expenditures $1,167,587 $1,437,553 $1,479,431 Resources $376,664 $338,564 $339,687 Facility Management Position Summary FY 2025 Facilities Manager 1.00 Maintenance Worker 1.00 Secretary 0.05 Confidential Account Clerk 0.10 Architectural Intern 0.50 Custodian - Federal Building 1.00 Custodian - Multicultural Family Center 1.00 Total Full-Time Equivalent Employees 4.65 Performance Measures City Council Goal: Financially Responsible, High Performance Organization Performance Measure (KPI)Target FY 2022 Actual FY 2023 Actual FY 2024 Estimated Performance Indicator 1 Activity Objective: Continue implementation of the ADA Transition Plan # of accessibility improvement projects in public facilities >8 0 4 5 Goal In Progress -111- 100 - General 4A - Charges for Services 41230 - Electrical Permits 0 0 0 0 41280 - Mechanical Permits 0 0 0 0 41330 - Sidewalk Permits (9,429) (12,176) (4,795) (5,000) 41335 - Dumpster Permits (3,100) (2,440) (1,180) (2,000) 41340 - Street Excavation (15,450) (33,363) (8,603) (20,000) 41360 - Public Right-of-Way Permit 0 0 0 0 41725 - Subdivision Inspection (202,365) (24,600) (219,077) (100,000) 41900 - Miscellaneous Licenses (5,104) (2,478) (2,259) (2,000) 43100 - Leases - Building/Land (321,075) (376,492) (340,322) (339,514) 43208 - Lease - Sidewalk Cafe (1,400) (1,000) (600) (500) 45500 - Miscellaneous Chg for Svcs (740) (22,795) (195) (273) 47100 - Reimbursements (8,541) (9,639) (2,566) (5,000) 47150 - Refunds (1,550) 0 0 0 47200 - Insurance Settlements (550) 0 0 0 47700 - District Court Fines 0 0 0 0 47820 - Specialized Services 0 0 0 0 4A - Charges for Services Total (569,304) (484,983) (579,597) (474,287) 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 (149,442) (22,333) 0 0 4M - Gain on Disposal Total (149,442) (22,333) 0 0 4N - Transfers 49600 - Transfer in Water Op (44,911) (49,107) (221,079) (362,993) 49610 - Transfer In Sanitary Op (280,692) (306,919) (328,840) (372,487) 49620 - Transfer in Storm Op (84,208) (92,075) (186,549) (358,266) 4N - Transfers Total (409,811) (448,101) (736,468) (1,093,746) 810 - Capital Project Internal Svc 4A - Charges for Services 47820 - Specialized Services (1,700,641)0 (1,900,867)(1,893,464) 4A - Charges for Services Total (1,700,641)0 (1,900,867)(1,893,464) 200 - Debt Service 4N - Transfers 49100 - Transfer In General Fund (7,125)(209,593)(6,878)(6,711) 49110 - Transfer in Road Use Tax (25,348)(26,060)(26,633)(26,670) 49126 - Transfer in GDTIF 0 0 0 0 49301 - Transfer in Street Const (197,230)0 (195,247)(199,471) 49303 - Transfer in Sales Tax Inc (2,554,296)(4,675,827)(5,640,609)(5,645,274) 49304 - Transfer in Sales Tax 20%(110,324)(125,989)(138,006)(143,301) 4N - Transfers Total (2,894,323)(5,037,469)(6,007,373)(6,021,427) 4O - Eliminated for GW 48200 - Proceeds from GO Debt 0 0 0 0 48205 - Bond Discount/Premium 0 0 0 0 4O - Eliminated for GW Total 0 0 0 0 620 - Stormwater Operating 4A - Charges for Services 41400 - Misc Permits (8,765)(34,223)(3,530)(5,000) Recommended Operating Revenue Budget - Department Total 55 - ENGINEERING Fund/Account/Account Title FY22 Actual Revenue FY23 Actual Revenue FY24 Adopted Budget FY25 Recomm'd Budget -112- 45235 - Stormwater User Fee (5,252,450)(5,389,954)(5,651,375)(6,572,749) 45236 - Stormwater Half Rate (42,022)(36,006)(43,026)(42,007) 45237 - Stormwater Tax Exempt 0 0 0 0 45238 - Stormwater Farm 0 0 0 0 45300 - Forfeitures/Penalties (17,197)(41,621)(22,043)(48,557) 45500 - Miscellaneous Chg for Svcs 0 0 0 0 47100 - Reimbursements (27)0 (1,910)(27) 4A - Charges for Services Total (5,320,461)(5,501,804)(5,721,884)(6,668,340) 4B - Grants/Contrib 44000 - Federal Grants (83,088)(61,499)(8,139)(8,139) 44400 - State Grants 0 0 0 0 4B - Grants/Contrib Total (83,088)(61,499)(8,139)(8,139) 4K - Unrest Invest Earn 43000 - Interest (14,729)(77,529)(37,191)(77,529) 4K - Unrest Invest Earn Total (14,729)(77,529)(37,191)(77,529) 4N - Transfers 49100 - Transfer In General Fund 0 0 0 (519,584) 49102 - Transfer in DRA Distribution (178,000)(181,115)0 0 49179 - Transfer in Special Assessment (84)0 0 0 49304 - Transfer in Sales Tax 20%(261,096)(259,398)(442,290)0 4N - Transfers Total (439,180)(440,513)(442,290)(519,584) 4O - Eliminated for GW 47115 - Sales Tax Collection (180,770)(186,536)(193,016)(208,902) 48200 - Proceeds from GO Debt 0 0 0 0 48205 - Bond Discount/Premium 0 0 0 0 4O - Eliminated for GW Total (180,770)(186,536)(193,016)(208,902) 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 (16,259)(70,521)(31,768)(70,521) 47100 - Reimbursements (5,125)(4,500)(10,250)(9,000) 4A - Charges for Services Total (21,384)(75,021)(42,018)(79,521) 301 - Street Construction 4B - Grants/Contrib 47050 - Contrib - Private Sources 0 0 0 0 4B - Grants/Contrib Total 0 0 0 0 ENGINEERING- Total (11,783,134)(12,335,788)(15,668,843)(17,044,939) Recommended Operating Revenue Budget - Department Total 55 - ENGINEERING Fund/Account/Account Title FY22 Actual Revenue FY23 Actual Revenue FY24 Adopted Budget FY25 Recomm'd Budget -113- 6A - Salaries & Wages 100 - General 60100 - Salaries-Regular Full Time 1,045,799 1,303,436 1,248,595 1,419,900 60200 - Salaries - Regular Part Time 8,468 4,096 0 0 60300 - Hourly Wages - Temp/Seasonal 8,350 21,007 36,355 24,368 60400 - Overtime 22,334 32,808 18,390 18,390 60410 - Overtime - Holiday 0 0 0 0 60620 - Special Pay - Holiday 0 0 0 0 60630 - Special Pay Sick Lv Payout Ret 11,985 11,967 11,748 0 60635 - Special Pay Sick Lv Payout 50%11,636 11,379 12,169 11,948 60640 - Special Pay - Vacation Payout 0 84 0 0 60710 - Special Pay - Parental Leave 5,934 5,741 0 0 60720 - Spec Pay - Meals No Overnight 173 92 91 92 60730 - Spec Pay - Safety Equipment 736 1,360 3,100 3,100 60760 - Spec Pay - Moving Allowance 300 0 0 0 110 - Road Use Tax 60100 - Salaries-Regular Full Time 0 0 0 0 60400 - Overtime 0 0 0 0 600 - Water Operating 60100 - Salaries-Regular Full Time 18,256 33,109 33,237 43,480 60200 - Salaries - Regular Part Time 8,468 4,096 0 0 60300 - Hourly Wages - Temp/Seasonal 0 0 0 0 60400 - Overtime 4,174 4,722 0 0 60410 - Overtime - Holiday 0 0 0 0 610 - Sanitary Sewer Operating 60100 - Salaries-Regular Full Time 73,446 135,566 135,984 176,308 60200 - Salaries - Regular Part Time 8,468 4,096 0 0 60300 - Hourly Wages - Temp/Seasonal 1,745 11,373 11,949 0 60400 - Overtime 6,584 6,105 0 0 60410 - Overtime - Holiday 0 0 0 0 60630 - Special Pay Sick Lv Payout Ret 7,884 0 0 0 60640 - Special Pay - Vacation Payout 881 0 0 0 60730 - Spec Pay - Safety Equipment 0 370 2,600 2,600 60760 - Spec Pay - Moving Allowance 0 4,725 0 0 620 - Stormwater Operating 60100 - Salaries-Regular Full Time 127,917 127,285 203,804 203,027 60200 - Salaries - Regular Part Time 29,508 25,389 82,714 87,192 60300 - Hourly Wages - Temp/Seasonal 0 1,840 11,949 0 60400 - Overtime 5,849 7,962 0 0 60410 - Overtime - Holiday 0 0 0 0 60620 - Special Pay - Holiday 0 33 0 0 60630 - Special Pay Sick Lv Payout Ret 7,884 0 0 0 60635 - Special Pay Sick Lv Payout 50%3,188 3,636 4,219 3,817 60640 - Special Pay - Vacation Payout 881 0 0 0 60710 - Special Pay - Parental Leave 0 0 0 0 60720 - Spec Pay - Meals No Overnight 20 0 20 0 60730 - Spec Pay - Safety Equipment 0 370 2,600 2,600 650 - Parking Operating 60100 - Salaries-Regular Full Time 49 1,161 2,422 4,488 60400 - Overtime 0 0 0 0 810 - Capital Project Internal Svc Recommended Operating Expenditure Budget - Department Total 55 - ENGINEERING Fund/Account/Account Title FY22 Actual Expense FY23 Actual Expense FY24 Adopted Budget FY 25 Recomm'd Budget -114- 60100 - Salaries-Regular Full Time 1,134,853 1,202 1,317,491 1,348,742 60200 - Salaries - Regular Part Time 0 0 0 0 60300 - Hourly Wages - Temp/Seasonal 23,030 0 25,055 36,552 60400 - Overtime 53,376 0 54,250 54,250 60410 - Overtime - Holiday 0 0 0 0 60630 - Special Pay Sick Lv Payout Ret 15,768 0 0 0 60640 - Special Pay - Vacation Payout 1,763 84 0 0 60710 - Special Pay - Parental Leave 10,088 0 0 0 6A - Salaries & Wages Total 2,659,799 1,765,089 3,218,742 3,440,854 6B - Employee Benefits 100 - General 61100 - FICA - City Contribution 81,703 101,843 101,201 112,803 61300 - IPERS - City Contribution 102,711 127,088 122,627 133,973 61510 - Health Insurance 355,540 159,294 223,155 242,419 61540 - Life Insurance 689 861 781 839 61600 - Workers' Compensation 34,929 39,371 21,640 25,202 61992 - Physicals 1,369 1,032 1,599 1,330 110 - Road Use Tax 61100 - FICA - City Contribution 0 0 0 0 61300 - IPERS - City Contribution 0 0 0 0 61510 - Health Insurance 0 0 0 0 61540 - Life Insurance 0 0 0 0 600 - Water Operating 61100 - FICA - City Contribution 2,219 3,013 2,542 3,327 61300 - IPERS - City Contribution 2,917 3,958 3,137 4,105 61510 - Health Insurance 3,258 6,816 6,914 8,726 61540 - Life Insurance 14 25 23 28 61600 - Workers' Compensation 351 530 679 793 610 - Sanitary Sewer Operating 61100 - FICA - City Contribution 7,211 11,924 10,825 13,488 61300 - IPERS - City Contribution 8,519 14,802 13,360 16,630 61510 - Health Insurance 6,946 26,992 20,202 23,557 61540 - Life Insurance 50 82 74 91 61600 - Workers' Compensation 8,223 8,214 2,563 3,528 61992 - Physicals 0 0 0 182 620 - Stormwater Operating 61100 - FICA - City Contribution 12,464 11,930 22,802 22,495 61300 - IPERS - City Contribution 15,413 15,127 27,765 27,386 61510 - Health Insurance 14,522 27,844 24,027 24,295 61540 - Life Insurance 83 78 101 105 61600 - Workers' Compensation 12,291 12,197 6,216 7,095 61700 - Unemployment Compensation 2,465 0 2,465 1,233 61992 - Physicals 144 144 364 144 650 - Parking Operating 61100 - FICA - City Contribution 4 86 185 344 61300 - IPERS - City Contribution 5 110 228 424 61510 - Health Insurance 36 (92)403 671 61540 - Life Insurance 0 1 1 2 61600 - Workers' Compensation 4 4 4 5 810 - Capital Project Internal Svc 61100 - FICA - City Contribution 89,467 92 106,857 110,129 Recommended Operating Expenditure Budget - Department Total 55 - ENGINEERING Fund/Account/Account Title FY22 Actual Expense FY23 Actual Expense FY24 Adopted Budget FY 25 Recomm'd Budget -115- 61300 - IPERS - City Contribution 115,296 62 129,492 130,083 61510 - Health Insurance (187,340)0 202,753 180,133 61540 - Life Insurance 737 0 707 695 61600 - Workers' Compensation 0 0 28,432 32,880 61992 - Physicals 0 0 0 0 6B - Employee Benefits Total 692,241 573,428 1,084,124 1,129,140 6C - Staff Development 100 - General 62100 - Association Dues 4,978 3,451 7,355 7,360 62200 - Subscriptions 4,140 2,946 8,864 8,520 62325 - Mileage 975 2,204 1,567 4,025 62400 - Meetings & Conferences 10,688 29,547 26,876 30,314 62500 - Education Reimbursement 6,022 8,544 39,140 40,345 110 - Road Use Tax 62100 - Association Dues 199 1,585 1,804 1,601 62200 - Subscriptions 17 0 600 600 62325 - Mileage 0 5 0 0 62400 - Meetings & Conferences 6,483 4,499 5,865 5,755 62500 - Education Reimbursement 2,400 4,328 11,784 12,215 600 - Water Operating 62100 - Association Dues 0 0 30 30 62200 - Subscriptions 0 0 25 25 62500 - Education Reimbursement 0 0 250 250 610 - Sanitary Sewer Operating 62100 - Association Dues 0 342 475 445 62200 - Subscriptions 0 0 375 350 62325 - Mileage 0 0 0 0 62400 - Meetings & Conferences 0 8,454 3,255 6,255 62500 - Education Reimbursement 0 849 4,800 7,450 620 - Stormwater Operating 62100 - Association Dues 755 1,039 1,144 1,114 62200 - Subscriptions 205 328 641 606 62325 - Mileage 0 0 80 80 62400 - Meetings & Conferences 1,413 6,620 6,796 5,430 62500 - Education Reimbursement 912 920 10,500 14,350 6C - Staff Development Total 39,188 75,661 132,226 147,120 6D - Repair/Maint/Util 100 - General 63100 - Building Maintenance 144,588 88,064 177,620 175,227 63312 - Vehicle Ops - Gasoline 17,192 22,134 29,307 29,307 63320 - Vehicle Repair - Internal 15,488 25,861 15,797 25,271 63321 - Vehicle Repair - Outsourced 0 5,842 0 5,959 63322 - Vehicle Repair - Accident 0 0 0 0 63400 - Equipment Maint/Repair 12,021 20,680 41,672 30,505 63710 - Electricity 148,510 175,336 238,950 213,461 63711 - Natural Gas 60,722 80,253 76,623 86,490 63730 - Telecommunications 20,186 31,184 28,132 28,677 63740 - Water 90 257 895 1,006 63742 - Stormwater 10,729 11,133 11,899 13,254 110 - Road Use Tax 63400 - Equipment Maint/Repair 2,500 221 2,000 2,226 Recommended Operating Expenditure Budget - Department Total 55 - ENGINEERING Fund/Account/Account Title FY22 Actual Expense FY23 Actual Expense FY24 Adopted Budget FY 25 Recomm'd Budget -116- 63730 - Telecommunications 1,571 2,461 2,496 2,496 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 16,688 1,747 13,104 13,366 63730 - Telecommunications 1,250 2,703 3,120 3,120 620 - Stormwater Operating 63100 - Building Maintenance 348 0 21,912 21,662 63312 - Vehicle Ops - Gasoline 0 0 446 446 63320 - Vehicle Repair - Internal 0 0 0 0 63400 - Equipment Maint/Repair 0 0 15,333 15,333 63710 - Electricity 3,113 12,415 22,201 21,100 63730 - Telecommunications 1,714 2,362 1,248 1,248 63780 - Street Lights 1,860 1,205 2,032 2,032 810 - Capital Project Internal Svc 63730 - Telecommunications 0 0 0 0 6D - Repair/Maint/Util Total 458,570 483,857 705,410 692,809 6E - Contractual Svcs 100 - General 64004 - Internal Service Charge 0 0 0 0 64010 - Accounting & Auditing 0 0 0 0 64020 - Advertising 1,009 234 1,009 478 64030 - Outsourced Labor 4,530 0 0 0 64040 - Collections 10 79 10 0 64050 - Recording Fees 905 437 905 900 64062 - Refunds 20 0 20 0 64063 - Inspection Reimbursement 0 0 66,000 66,000 64070 - Engineering - Outsourced 24,490 61,523 13,128 13,128 64075 - Engineering - Internal 0 0 21,000 21,000 64080 - Insurance - Property 61,982 73,440 62,070 117,262 64081 - Insurance - Liability 26,239 32,959 33,721 50,798 64083 - Insurance - Other 0 3,125 0 0 64110 - Legal 865 2,215 666 666 64130 - Payments to Other Agencies 20,000 25,000 30,650 25,000 64135 - Grants 1,367 360 5,000 5,000 64140 - Printing 1,327 1,387 1,416 1,099 64145 - Copying 3,372 3,151 3,913 3,150 64160 - Rental - Land/Bldgs/Parking 8,890 9,302 23,668 22,372 64175 - Landfill Fees 0 290 1,000 290 64182 - Property Tax 99,186 91,998 146,023 149,631 64185 - License/Permit/Fees 0 0 650 650 64190 - Technology Services 58,676 102,416 120,756 136,903 64191 - IT Recharges 0 30,240 31,550 35,904 64820 - One Call 157 0 157 0 64825 - Fire Suppression 8,628 15,988 13,518 19,943 64850 - Consulting Engineers 0 0 0 0 Recommended Operating Expenditure Budget - Department Total 55 - ENGINEERING Fund/Account/Account Title FY22 Actual Expense FY23 Actual Expense FY24 Adopted Budget FY 25 Recomm'd Budget -117- 64860 - Speakers 0 0 1,500 1,500 64865 - Elevator Service 11,860 29,769 23,800 24,800 64870 - HVAC Services 0 29,050 19,800 35,400 64880 - Custodial Services 0 158 0 220 64900 - Other Professional Service 22,552 6,274 15,016 15,016 64975 - Equip Maint Cont 25,646 28,724 32,938 30,647 64980 - Technology Equip Maint Cont 70,378 14 36,335 36,335 64987 - Lawn Care Contract 0 0 0 0 64990 - Other Contractual Service 0 2,350 1,335 0 110 - Road Use Tax 64080 - Insurance - Property 7,600 7,600 9,047 27,141 64185 - License/Permit/Fees 0 14,286 0 14,286 64190 - Technology Services 35,586 77,200 120,475 200,047 64980 - Technology Equip Maint Cont 1,781 12,750 40,000 40,000 200 - Debt Service 64110 - Legal 0 0 0 0 64900 - Other Professional Service 0 0 0 0 600 - Water Operating 64020 - Advertising 188 0 188 188 64160 - Rental - Land/Bldgs/Parking 0 0 0 0 64820 - One Call 157 0 157 157 610 - Sanitary Sewer Operating 64020 - Advertising 1,558 0 1,558 0 64030 - Outsourced Labor 1,184 0 0 0 64062 - Refunds 0 0 0 0 64081 - Insurance - Liability 1,907 4,431 0 0 64110 - Legal 667 0 666 666 64135 - Grants 6,544 0 10,000 10,000 64145 - Copying 260 389 260 389 64190 - Technology Services 19,334 18,292 25,619 35,452 64820 - One Call 3,879 4,910 500 5,000 64825 - Fire Suppression 0 56 30 56 64900 - Other Professional Service 300 0 424 0 620 - Stormwater Operating 64010 - Accounting & Auditing 0 5,750 0 5,750 64020 - Advertising 3,514 5,019 3,514 3,514 64040 - Collections 596 1,171 596 1,171 64045 - Bad Debt Expense 0 0 0 0 64062 - Refunds 1,170 1,519 1,170 1,519 64070 - Engineering - Outsourced 0 0 2,583 2,583 64080 - Insurance - Property 1,217 1,442 1,296 2,343 64081 - Insurance - Liability 0 0 0 0 64110 - Legal 22,606 0 666 666 64130 - Payments to Other Agencies 116,850 119,771 122,766 125,845 64135 - Grants 440,096 440,513 478,843 529,484 64140 - Printing 0 0 131 0 64145 - Copying 293 0 910 910 64150 - Rental - Equipment 100 1,150 571 1,150 64160 - Rental - Land/Bldgs/Parking 440 440 1,488 480 64180 - Sales Tax Expense 180,075 179,061 194,745 208,902 64185 - License/Permit/Fees 0 0 0 0 Recommended Operating Expenditure Budget - Department Total 55 - ENGINEERING Fund/Account/Account Title FY22 Actual Expense FY23 Actual Expense FY24 Adopted Budget FY 25 Recomm'd Budget -118- 64190 - Technology Services 10,766 20,965 21,761 21,935 64820 - One Call 3,879 4,768 5,000 5,000 64825 - Fire Suppression 0 46 20 47 64850 - Consulting Engineers 0 0 0 0 64860 - Speakers 500 0 7,000 7,000 64900 - Other Professional Service 69,825 81,655 157,842 160,842 64980 - Technology Equip Maint Cont 3,444 0 5,394 5,394 64987 - Lawn Care Contract 9,300 16,058 15,000 16,060 650 - Parking Operating 64020 - Advertising 0 0 0 0 810 - Capital Project Internal Svc 64004 - Internal Service Charge 0 0 0 0 64075 - Engineering - Internal 0 0 0 0 64081 - Insurance - Liability 0 0 35,830 0 64190 - Technology Services 0 0 0 0 6E - Contractual Svcs Total 1,397,701 1,569,725 1,973,604 2,248,069 6F - Commodities 100 - General 65026 - Speciality Supplies 328 624 328 0 65040 - Small Tools & Equipment 4,563 30,502 41,986 14,981 65045 - Technology Equipment 24,938 16,017 27,584 32,495 65050 - Other Equipment 8,167 9,863 0 0 65054 - Safety Equipment 90 668 0 0 65055 - Traffic St Light Comp/Equip 0 140 0 0 65060 - Office Supplies 4,996 9,480 7,260 6,762 65070 - Operating Supplies 2,648 7,724 2,648 6,314 65080 - Postage/Shipping 1,038 978 2,794 2,866 65100 - Safety Supplies 397 516 397 516 65110 - Signage 0 0 0 0 65925 - Uniform Purchase 1,044 75 500 500 65930 - Flags 0 0 0 0 65935 - Employee Recognition 0 175 500 500 65940 - Gift Cards 0 0 0 0 65960 - Repair Parts 269 (42)269 269 65965 - Janitorial 11,704 18,051 21,425 20,410 65980 - Construction Supplies 133 0 133 133 110 - Road Use Tax 65040 - Small Tools & Equipment 4,362 0 2,000 0 65045 - Technology Equipment 121,460 186,779 306,750 280,100 65054 - Safety Equipment 0 1,661 0 0 65055 - Traffic St Light Comp/Equip 106,793 117,798 9,500 7,250 65056 - Traffic Security Cameras 44,054 50,655 196,200 222,000 65060 - Office Supplies 0 51 0 51 65070 - Operating Supplies 36 0 36 0 65080 - Postage/Shipping 0 0 0 0 600 - Water Operating 65040 - Small Tools & Equipment 0 0 3,000 3,000 610 - Sanitary Sewer Operating 65040 - Small Tools & Equipment 0 0 4,500 3,000 65045 - Technology Equipment 4,274 5,168 2,083 1,620 65050 - Other Equipment 16,148 2,063 6,000 10,000 Recommended Operating Expenditure Budget - Department Total 55 - ENGINEERING Fund/Account/Account Title FY22 Actual Expense FY23 Actual Expense FY24 Adopted Budget FY 25 Recomm'd Budget -119- 65054 - Safety Equipment 6,490 2,095 3,250 4,750 65060 - Office Supplies 0 0 0 0 65080 - Postage/Shipping 0 0 0 0 620 - Stormwater Operating 65025 - Program Materials 0 48 2,200 2,200 65040 - Small Tools & Equipment 0 40 4,500 3,000 65045 - Technology Equipment 3,059 1,952 3,183 1,505 65050 - Other Equipment 595 4,272 3,800 15,000 65054 - Safety Equipment 633 490 7,500 7,500 65060 - Office Supplies 0 11 0 11 65070 - Operating Supplies 411 464 1,514 464 65080 - Postage/Shipping 0 0 0 0 6F - Commodities Total 368,626 468,317 661,840 647,197 6G - Capital Outlay 100 - General 67100 - Vehicles 176 80,371 35,000 53,000 67210 - Furniture/Fixtures 3,412 775 2,000 2,400 67250 - Office Equipment 223 1,492 900 600 67400 - Right-of-Way 250 0 0 0 67500 - Buildings 30,375 3,215 40,000 40,000 110 - Road Use Tax 67100 - Vehicles 0 18,884 0 0 67250 - Office Equipment 0 0 0 300 610 - Sanitary Sewer Operating 67100 - Vehicles 0 46,788 35,000 0 67250 - Office Equipment 0 1,392 0 0 67990 - Other Capital Outlay 29,352 90,578 110,484 122,000 620 - Stormwater Operating 67100 - Vehicles 0 40,831 0 0 67250 - Office Equipment 0 1,392 0 0 67990 - Other Capital Outlay 31,372 26,280 65,000 65,000 6G - Capital Outlay Total 95,160 311,997 288,384 283,300 6H - Debt Service 200 - Debt Service 68010 - Principal Payment 1,441,234 3,608,723 4,653,518 4,814,604 68020 - Interest Payments 1,453,090 1,431,422 1,353,855 1,206,822 68980 - Financial Consultant 0 0 0 0 68990 - Paying Agent Fees 0 0 0 0 620 - Stormwater Operating 68010 - Principal Payment 2,107,547 2,156,422 2,137,682 2,017,065 68020 - Interest Payments 621,137 604,418 701,160 586,714 68980 - Financial Consultant 0 0 0 0 68990 - Paying Agent Fees 0 0 0 0 6H - Debt Service Total 5,623,009 7,800,985 8,846,215 8,625,205 6I - Transfers 620 - Stormwater Operating 69100 - Transfers Out To General Fund 625,258 659,648 1,192,164 1,982,609 69621 - Transfers Out to Storm Cap 518,685 0 400,000 700,000 6I - Transfers Total 1,143,943 659,648 1,592,164 2,682,609 ENGINEERING - Total 12,478,237 13,708,708 18,502,709 19,896,303 Recommended Operating Expenditure Budget - Department Total 55 - ENGINEERING Fund/Account/Account Title FY22 Actual Expense FY23 Actual Expense FY24 Adopted Budget FY 25 Recomm'd Budget -120- 5501 - Administration 100 - General 6A - Salaries & Wages 222,772 207,256 200,623 6B - Employee Benefits 44,860 54,805 51,837 6C - Staff Development 14,260 24,425 24,900 6D - Repair/Maint/Util 10,487 5,131 6,571 6E - Contractual Svcs 70,399 88,375 96,669 6F - Commodities 1,616 6,079 3,331 6G - Capital Outlay 2,267 1,900 1,800 610 - Sanitary Sewer Operating 6A - Salaries & Wages 46,080 —— 6B - Employee Benefits 13,422 45,723 — 6C - Staff Development 7,903 2,400 — 6D - Repair/Maint/Util 3,238 —— 6E - Contractual Svcs 18,820 10,000 — 6F - Commodities 7,061 6,233 — 6G - Capital Outlay 91,551 0 0 810 - Capital Project Internal Svc 6A - Salaries & Wages 0 141,349 172,683 6B - Employee Benefits 0 41,284 54,365 6E - Contractual Svcs 0 0 0 5501 - Administration Total 554,735 634,960 612,779 5502 - Project Engineering 100 - General 6A - Salaries & Wages 583,346 512,447 579,225 6B - Employee Benefits 154,338 171,603 197,893 6C - Staff Development 20,551 40,984 44,012 6D - Repair/Maint/Util 61,039 53,388 67,890 6E - Contractual Svcs 107,498 143,844 159,802 6F - Commodities 48,544 63,855 50,795 6G - Capital Outlay 72,871 1,000 54,200 110 - Road Use Tax 6C - Staff Development 10,418 20,053 20,171 6D - Repair/Maint/Util 2,172 1,872 2,098 6E - Contractual Svcs 111,836 169,042 280,994 6F - Commodities 350,612 508,486 504,151 6G - Capital Outlay 0 0 300 600 - Water Operating 6A - Salaries & Wages 41,926 33,237 43,480 6B - Employee Benefits 14,341 13,295 16,979 6C - Staff Development 0 305 305 6D - Repair/Maint/Util 0 0 0 6E - Contractual Svcs 0 345 345 6F - Commodities 0 3,000 3,000 610 - Sanitary Sewer Operating 6A - Salaries & Wages 116,154 150,533 178,908 6B - Employee Benefits 48,592 1,301 57,476 6C - Staff Development 1,742 6,505 14,500 Recommended Expenditure Budget Report by Activity & Funding Source 55 - ENGINEERING Fund/Activity FY22 Actual Expense FY23 Adopted Budget FY24 Recomm'd Budget -121- 6D - Repair/Maint/Util 1,212 16,847 17,109 6E - Contractual Svcs 9,257 29,057 51,563 6F - Commodities 2,264 9,600 19,370 6G - Capital Outlay 47,207 145,484 122,000 810 - Capital Project Internal Svc 6A - Salaries & Wages 1,286 1,255,447 1,266,861 6B - Employee Benefits 154 426,957 399,555 6D - Repair/Maint/Util 0 0 0 6E - Contractual Svcs 0 35,830 0 5502 - Project Engineering Total 1,807,361 3,814,317 4,152,982 5503 - Subdivision Inspection 100 - General 6A - Salaries & Wages 35,865 44,445 52,661 6B - Employee Benefits 7,977 16,282 19,486 6C - Staff Development 0 0 0 6E - Contractual Svcs 53,731 87,000 87,000 5503 - Subdivision Inspection Total 97,573 147,727 159,147 5504 - Traffic Engineering 100 - General 6A - Salaries & Wages 130,104 123,028 136,402 6B - Employee Benefits 44,429 44,152 47,252 6C - Staff Development 7,178 8,673 10,701 6D - Repair/Maint/Util 3,050 2,610 2,190 6E - Contractual Svcs 40,094 80,817 79,383 6F - Commodities 204 32 3,022 6G - Capital Outlay 7,500 0 0 110 - Road Use Tax 6D - Repair/Maint/Util 510 2,624 2,624 6E - Contractual Svcs 0 480 480 6F - Commodities 6,332 6,000 5,250 6G - Capital Outlay 18,884 0 0 5504 - Traffic Engineering Total 258,283 268,416 287,304 5505 - Facilities Management 100 - General 6A - Salaries & Wages 388,085 418,172 469,714 6B - Employee Benefits 172,239 177,471 184,957 6C - Staff Development 4,704 9,720 10,951 6D - Repair/Maint/Util 370,546 537,093 508,121 6E - Contractual Svcs 205,141 184,239 264,262 6F - Commodities 41,654 35,858 28,564 6G - Capital Outlay 3,215 75,000 40,000 5505 - Facilities Management Total 1,185,585 1,437,553 1,506,569 5506 - Leases 100 - General 6A - Salaries & Wages 31,797 25,100 39,173 6B - Employee Benefits 5,646 6,690 15,141 6D - Repair/Maint/Util 15,622 22,673 24,385 6E - Contractual Svcs 73,622 123,279 126,976 6F - Commodities 33 0 34 Recommended Expenditure Budget Report by Activity & Funding Source 55 - ENGINEERING Fund/Activity FY22 Actual Expense FY23 Adopted Budget FY24 Recomm'd Budget -122- 5506 - Leases Total 126,720 177,742 205,709 5507 - Stormwater Operations 620 - Stormwater Operating 6A - Salaries & Wages 135,079 168,550 168,608 6B - Employee Benefits 58,370 49,454 51,674 6C - Staff Development 8,906 19,161 21,580 6D - Repair/Maint/Util 15,640 26,888 26,638 6E - Contractual Svcs 862,812 959,985 1,039,232 6F - Commodities 7,149 22,319 29,551 6G - Capital Outlay 68,503 50,000 50,000 6H - Debt Service 2,760,840 2,838,842 2,603,779 6I - Transfers 659,648 1,592,164 2,682,609 5507 - Stormwater Operations Total 4,576,947 5,727,363 6,673,671 5508 - Stormwater I&I Prevention 620 - Stormwater Operating 6A - Salaries & Wages 27,200 136,756 122,739 6B - Employee Benefits 7,314 34,286 29,366 6D - Repair/Maint/Util 341 1,658 557 6E - Contractual Svcs 440 9,988 8,980 6F - Commodities 129 378 129 6G - Capital Outlay 0 0 0 5508 - Stormwater I&I Prevention Total 35,424 183,066 161,771 5509 - Stormwater Ditch Remediation 620 - Stormwater Operating 6A - Salaries & Wages 0 0 0 6B - Employee Benefits 0 0 0 6D - Repair/Maint/Util 0 7,847 7,847 6E - Contractual Svcs 0 4,283 4,283 6G - Capital Outlay 0 15,000 15,000 5509 - Stormwater Ditch Remediation Total 0 27,130 27,130 5510 - Streambank Rehab Assistance 620 - Stormwater Operating 6E - Contractual Svcs 0 5,000 5,000 5510 - Streambank Rehab Assistance Total 0 5,000 5,000 5511 - Detention Basin Maintenance 620 - Stormwater Operating 6A - Salaries & Wages 4,234 0 5,289 6B - Employee Benefits 1,636 0 1,713 6D - Repair/Maint/Util 0 26,779 26,779 6E - Contractual Svcs 16,076 42,040 43,100 6F - Commodities 0 0 0 6G - Capital Outlay 0 0 0 5511 - Detention Basin Maintenance Total 21,946 68,819 76,881 5512 - Stormwater Inspection & Clean 620 - Stormwater Operating 6D - Repair/Maint/Util 0 0 0 6E - Contractual Svcs 0 0 0 6F - Commodities 0 0 0 6G - Capital Outlay 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 -123- 5512 - Stormwater Inspection & Clean Total 0 0 0 5513 - Residential Parking 650 - Parking Operating 6A - Salaries & Wages 1,161 2,422 4,488 6B - Employee Benefits 109 821 1,446 6E - Contractual Svcs 0 0 0 5513 - Residential Parking Total 1,270 3,243 5,934 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 5,040,145 6,007,373 6,021,426 5580 - Debt Service Total 5,040,145 6,007,373 6,021,426 5599 - Pcard Clearing 100 - General 6F - Commodities 2,719 0 0 5599 - Pcard Clearing Total 2,719 0 0 ENGINEERING TOTAL 13,708,708 18,502,709 19,896,303 Recommended Expenditure Budget Report by Activity & Funding Source 55 - ENGINEERING Fund/Activity FY22 Actual Expense FY23 Adopted Budget FY24 Recomm'd Budget -124- 61010 Full Time Employee Expense 100 5800 GE-34 FACILITIES MANAGER 1.00 $ 67,806 1.00 $ 74,820 1.00 $ 83,212 100 3420 OE-09 MAINT. WORKER - FEDERAL BLDG 1.00 $ 57,077 1.00 $ 61,640 1.00 $ 64,963 100 OE-06 CUSTODIAN I 5.00 $ 239,782 5.00 $ 258,728 5.00 $ 278,542 100 9425 GE-44 CITY ENGINEER 0.40 $ 59,695 0.40 $ 62,439 0.40 $ 65,810 610 9425 GE-44 CITY ENGINEER 0.20 $ 29,847 0.20 $ 31,220 0.20 $ 32,905 620 9425 GE-44 CITY ENGINEER 0.15 $ 22,386 0.15 $ 23,415 0.15 $ 24,679 800 9425 GE-44 CITY ENGINEER 0.25 $ 35,868 0.25 $ 37,514 0.25 $ 41,131 100 3125 GE-40 ASSISTANT CITY ENGINEER 0.40 $ 47,695 0.40 $ 49,888 0.40 $ 52,834 800 3125 GE-40 ASSISTANT CITY ENGINEER 0.60 $ 71,543 0.60 $ 74,832 0.60 $ 79,251 100 4060 GE-40 PROJECT MANAGER 0.40 $ 46,779 0.40 $ 49,111 0.40 $ 32,551 610 4060 GE-40 PROJECT MANAGER 0.10 $ 11,694 0.10 $ 12,277 0.10 $ 13,020 800 4060 GE-40 PROJECT MANAGER 0.50 $ 58,473 0.50 $ 61,388 0.50 $ 84,570 100 GE-35 CIVIL ENGINEER I 0.15 $ 13,357 0.15 $ 13,918 0.15 $ 14,786 620 GE-35 CIVIL ENGINEER I 0.20 $ 20,617 0.05 $ 5,607 —$ — 800 GE-35 CIVIL ENGINEER I 0.85 $ 75,690 0.85 $ 79,454 0.85 $ 83,789 100 5525 GE-38 CIVIL ENGINEER II 0.90 $ 95,880 0.85 $ 94,705 0.95 $ 112,006 610 5525 GE-38 CIVIL ENGINEER II 0.10 $ 10,514 0.15 $ 16,352 0.35 $ 38,928 620 5525 GE-38 CIVIL ENGINEER II 0.85 $ 90,295 1.00 $ 109,799 0.88 $ 87,249 800 5,525 GE-38 CIVIL ENGINEER II 1.95 $ 207,528 1.95 $ 215,558 1.79 $ 204,136 100 GE-28 CAMERA SYSTEMS TECHNICIAN 0.50 $ 27,081 0.50 $ 28,326 0.50 $ 29,860 800 GE-28 CAMERA SYSTEMS TECHNICIAN 0.50 $ 27,081 0.50 $ 28,326 0.50 $ 29,860 100 5700 GE-36 SURVEYOR 0.90 $ 84,176 0.90 $ 88,046 0.90 $ 92,931 800 5700 GE-36 SURVEYOR 0.10 $ 9,353 0.10 $ 9,783 0.10 $ 10,325 100 GE-35 TRAFFIC ENGINEER 1.27 $ 102,369 1.27 $ 108,700 1.25 $ 116,612 630 GE-35 TRAFFIC ENGINEER 0.03 $ 2,204 0.03 $ 2,422 0.05 $ 4,488 800 GE-35 TRAFFIC ENGINEER 0.70 $ 59,539 0.70 $ 62,487 0.70 $ 67,240 100 5575 GE-33 SURVEY PARTY CHIEF 0.15 $ 12,303 0.15 $ 12,972 0.15 $ 13,695 800 5575 GE-33 SURVEY PARTY CHIEF 0.85 $ 69,715 0.85 $ 73,124 0.85 $ 77,125 100 GE-31 ROW TECHNICIAN 0.90 $ 57,528 0.95 $ 67,039 0.95 $ 74,189 800 GE-31 ROW TECHNICIAN 0.10 $ 6,392 0.05 $ 3,528 0.05 $ 3,905 100 2700 GE-31 ENGINEERING ASSISTANT II —$ — 0.10 $ 7,778 0.10 $ 8,199 800 2700 GE-31 ENGINEERING ASSISTANT II 0.90 $ 66,929 0.90 $ 70,006 0.90 $ 73,798 100 2700 GE-31 ENGINEERING TECHNICIAN 1.63 $ 115,376 1.93 $ 143,384 2.46 $ 176,954 610 2,700 GE-31 ENGINEERING TECHNICIAN 0.23 $ 15,456 0.38 $ 28,714 0.55 $ 40,881 620 2,700 GE-31 ENGINEERING TECHNICIAN 0.28 $ 19,033 0.28 $ 20,248 0.50 $ 38,099 640 2700 GE-31 ENGINEERING TECHNICIAN 0.03 $ 2,168 0.03 $ 2,266 0.15 $ — 800 2700 GE-31 ENGINEERING TECHNICIAN 5.93 $ 418,165 6.38 $ 476,520 6.31 $ 497,728 100 2725 GE-30 SURVEY TECHNICIAN 0.15 $ 10,469 0.15 $ 11,081 0.25 $ 15,763 800 2725 GE-30 SURVEY TECHNICIAN 0.85 $ 59,322 0.85 $ 62,552 0.75 $ 47,290 100 4870 GE-28 UTILITY LOCATOR 0.50 $ 28,218 0.50 $ 30,737 0.50 $ 32,640 610 4870 GE-28 UTILITY LOCATOR 0.50 $ 28,218 0.50 $ 30,185 0.50 $ 32,640 620 4870 GE-28 UTILITY LOCATOR 0.50 $ 28,218 0.50 $ 30,185 0.50 $ 32,640 640 4870 GE-28 UTILITY LOCATOR 0.50 $ 28,218 0.50 $ 30,971 0.50 $ 32,953 100 225 GE-31 SECRETARY 0.80 $ 56,738 0.50 $ 34,002 0.80 $ 57,490 610 225 GE-31 SECRETARY 0.05 $ 3,500 0.05 $ 3,778 0.05 $ 3,594 620 225 GE-31 SECRETARY 0.05 $ 3,546 0.05 $ 3,778 0.05 $ 3,594 800 225 GE-31 SECRETARY 0.10 $ 7,092 0.40 $ 29,937 0.10 $ 7,188 100 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK 0.90 $ 46,459 0.95 $ 51,281 1.20 $ 62,868 610 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK 0.25 $ 12,867 0.25 $ 13,458 0.25 $ 14,214 620 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK 0.25 $ 12,867 0.20 $ 10,772 0.20 $ 11,376 800 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK 0.60 $ 31,049 0.60 $ 32,477 1.35 $ 71,596 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 2023 FY 2024 FY 2025 FD JC WP-GR JOB CLASS FTE BUDGET FTE BUDGET FTE BUDGET -125- TOTAL FULL TIME EMPLOYEES 36.00 $ 2,714,175 37.00 $ 2,941,528 39.00 $ 3,191,913 61020 Part-Time Employee Expense 620 GE-26 I&I INSPECTOR 1.46 $ 79,078 1.46 $ 82,714 1.46 $ 87,192 TOTAL PART TIME EMPLOYEES 1.46 $ 79,078 1.46 $ 82,714 1.46 $ 87,192 61030 Seasonal Employee Expense 100 NA-34 ARCHITECTURAL INTERN 0.50 $ 15,556 0.50 $ 16,270 0.50 $ 24,368 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,778 0.57 $ 20,226 —$ — 800 NA-34 ENGINEERING INTERN-SEASONAL 1.00 $ 32,354 0.75 $ 25,055 0.75 $ 36,552 TOTAL SEASONAL EMPLOYEES 2.75 $ 86,310 2.46 $ 85,733 1.25 $ 60,920 TOTAL ENGINEERING 40.21 $ 2,879,563 40.92 $ 3,109,975 41.68 $ 3,337,381 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 2023 FY 2024 FY 2025 FD JC WP-GR JOB CLASS FTE BUDGET FTE BUDGET FTE BUDGET -126- Engineering Administration-FT General Fund 10055100 61010 100 225 GE-31 SECRETARY 0.20 $ 14,185 0.15 $ 11,334 0.20 $ 14,372 10055100 61010 100 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK 0.55 $ 28,404 0.50 $ 27,024 0.35 $ 19,934 10055100 61010 100 3125 GE-40 ASSISTANT CITY ENGINEER 0.40 $ 47,695 0.40 $ 49,888 0.40 $ 52,834 10055100 61010 100 4060 GE-40 PROJECT MANAGER 0.35 $ 40,931 0.35 $ 42,972 0.25 $ 32,551 10055100 61010 100 9425 GE-44 CITY ENGINEER 0.40 $ 59,695 0.40 $ 62,439 0.40 $ 65,810 Total 1.90 $ 190,910 1.80 $ 193,657 1.60 $ 185,501 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.05 $2,568 0.05 $2,686 0.5500 $25,881 80055100 61010 800 3125 GE-40 ASSISTANT CITY ENGINEER 0.60 $71,543 0.60 $74,832 0.6000 $79,251 80055100 61010 800 4060 GE-40 PROJECT MANAGER 0.35 $40,931 0.35 $42,972 0.3500 $45,572 80055100 61010 800 225 GE-25 SECRETARY 0.00 $0 80055100 61010 800 9425 GE-44 CITY ENGINEER 0.10 $ 14,924 0.10 $ 15,609 0.10 $ 16,452 Total 1.10 $ 129,966 1.10 $ 136,099 1.60 $ 167,156 Engineering Leases - FT General Fund 10055150 61010 800 4060 GE-40 PROJECT MANAGER 0.05 $ 5,848 0.05 $ 6,139 0.10 $ 13,020 10055150 61010 100 GE-25 CONFIDENTIAL ACCOUNT CLERK 0.15 $ 7,782 0.20 $ 10,826 0.55 $ 25,901 Total 0.20 $ 13,630 0.25 $ 16,965 0.65 $ 38,921 Engineering Leases - Seasonal General Fund 10055150 61030 100 NA-34 ENGINEERING INTERN 0.25 $ 7,778 0.25 $ 8,135 —$ — Total 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.50 $ 26,889 —$ — Total 0.40 $ 19,916 0.50 $ 26,889 —$ — 10055230 61010 100 3420 OE-09 MAINT. WORKER - FEDERAL BLDG 1.00 $ 57,077 1.00 $ 61,640 1.00 $ 64,963 10055230 61010 100 2040 OE-06 CUSTODIAN I 2.15 $ 102,221 2.50 $ 130,244 1.00 $ 54,881 Total 3.15 $ 159,298 3.50 $ 191,884 2.00 $ 119,844 Multicultural Family Center Maintenance-FT 10055250 61010 100 2040 OE-06 CUSTODIAN I 0.45 $ 20,882 10055250 61010 100 2088 OE-06 CUSTODIAN I 1.00 $ 46,479 1.00 $ 47,284 1.00 $ 53,041 Total 1.45 $ 67,361 1.00 $ 47,284 1.00 $ 53,041 City Hall Maintenance-FT 10055210 61010 100 2040 OE-06 CUSTODIAN I 1.00 $ 50,284 1.00 $ 54,311 —$ — Total 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 0.05 $ 3,594 CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2023 FY 2024 FY 2025 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET -127- 10055200 61010 100 GE-25 CONFIDENTIAL ACCOUNT CLERK 0.05 $ 2,686 0.10 $ 5,678 10055200 61010 100 2040 OE-06 CUSTODIAN I —$ — —$ — 3.00 $ 170,620 10055200 61010 800 4060 GE-40 PROJECT MANAGER —$ — —$ — 0.05 $ 6,511 10055200 61010 100 5800 GE-34 FACILITIES MANAGER 1.00 $ 67,806 1.00 $ 74,820 1.00 $ 83,212 Total 1.05 $ 71,352 1.10 $ 81,284 4.20 $ 269,615 Facilities Management -Seasonal 10055200 61030 100 NA-34 ARCHITECTURAL INTERN 0.50 $ 15,556 0.50 $ 16,270 0.50 $ 24,368 Total 0.50 $ 15,556 0.50 $ 16,270 0.50 $ 24,368 Project Engineering-FT General Fund 10055400 61010 100 2700 GE-31 ENGINEERING ASSISTANT II 0.10 $ 7,436 0.10 $ 7,778 0.10 $ 8,199 10055400 61010 100 GE-31 ROW TECHNICIAN 0.90 $ 57,528 0.95 $ 67,039 0.95 $ 74,189 10055400 61010 100 2220 GE-31 ENGINEERING TECHNICIAN 1.10 $ 78,696 1.30 $ 96,673 1.60 $ 124,293 10055400 61010 100 2725 GE-30 SURVEY TECHNICIAN 0.15 $ 10,469 0.15 $ 11,081 0.25 $ 15,763 10055400 61010 100 5575 GE-33 SURVEY PARTY CHIEF 0.15 $ 12,303 0.15 $ 12,972 0.15 $ 13,695 10055400 61010 100 4710 GE-35 TRAFFIC ENGINEER 0.50 $ 44,704 0.50 $ 46,759 0.50 $ 49,286 10055400 61010 100 GE-35 CIVIL ENGINEER I 0.15 $ 13,357 0.15 $ 13,918 0.15 $ 14,786 10055400 61010 100 GE-28 CAMERA SYSTEMS TECHNICIAN 0.50 $ 27,081 0.50 $ 28,326 0.50 $ 29,860 10055400 61010 100 GE-31 SECRETARY 0.35 $ 24,822 0.20 $ 11,334 0.50 $ 35,930 10055400 61010 100 5525 GE-38 CIVIL ENGINEER II 0.85 $ 90,295 0.85 $ 94,705 0.95 $ 112,006 10055400 61010 100 5700 GE-36 SURVEYOR 0.80 $ 74,823 0.80 $ 78,263 0.80 $ 82,606 Total 5.55 $ 441,514 5.65 $ 468,848 6.45 $ 560,613 Project Engineering-Seasonal General Fund 10055400 61030 100 NA-34 ENGINEERING INTERN —$ — —$ — 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.40 $ 27,076 0.60 $ 44,445 0.70 $ 52,661 Total 0.40 $ 27,076 0.60 $ 44,445 0.70 $ 52,661 Project Engineering-FT Service Fund 80055400 61010 800 GE-28 CAMERA SYSTEMS TECHNICIAN 0.50 $ 27,081 0.50 $ 28,326 0.50 $ 29,860 80055400 61010 800 GE-31 ROW TECHNICIAN 0.10 $ 6,392 0.05 $ 3,528 0.05 $ 3,905 80055400 61010 800 2700 GE-31 ENGINEERING ASSISTANT II 0.85 $ 63,211 0.85 $ 66,117 0.85 $ 69,698 80055400 61010 800 GE-25 CONFIDENTIAL ACCOUNT CLERK —$ — 0.10 $ 5,720 80055400 61010 800 GE-31 SECRETARY 0.20 $ 14,825 —$ — 80055400 61010 800 GE-35 CIVIL ENGINEER I 0.65 $ 57,882 0.75 $ 70,138 0.75 $ 73,931 80055400 61010 800 2220 GE-31 ENGINEERING TECHNICIAN 3.03 $ 217,298 3.48 $ 260,138 2.58 $ 202,701 80055400 61010 800 2725 GE-30 SURVEY TECHNICIAN 0.30 $ 20,937 0.30 $ 22,077 0.20 $ 12,611 80055400 61010 800 5575 GE-33 SURVEY PARTY CHIEF 0.30 $ 24,605 0.30 $ 25,940 0.30 $ 27,389 80055400 61010 800 5525 GE-38 CIVIL ENGINEER II 1.15 $ 123,410 1.15 $ 127,717 1.05 $ 122,917 80055400 61010 800 4710 GE-35 TRAFFIC ENGINEER 0.60 $ 52,192 0.60 $ 54,834 0.60 $ 58,263 80055400 61010 800 5700 GE-36 SURVEYOR 0.10 $ 9,353 0.10 $ 9,783 0.10 $ 10,325 Total 7.58 $ 602,361 8.28 $ 683,423 7.08 $ 617,320 CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2023 FY 2024 FY 2025 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET -128- Project Engineering-Seasonal Service Fund 80055400 61030 800 5325 NA-34 ENGINEERING INTERN- SEASONAL 1.00 $ 32,354 0.75 $ 25,055 0.75 $ 36,552 Total 1.00 $ 32,354 0.75 $ 25,055 0.75 $ 36,552 Traffic Engineering-FT General Fund 10055700 61010 100 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK 0.20 $ 10,273 0.20 $ 10,745 0.20 $ 11,355 10055700 61010 100 GE-31 SECRETARY 0.20 $ 14,185 0.10 $ 7,556 0.05 $ 3,594 10055700 61010 800 2220 GE-31 ENGINEERING TECHNICIAN 0.03 $ 2,168 0.03 $ 2,266 0.16 $ 11,036 10055700 61010 100 5700 GE-36 SURVEYOR 0.10 $ 9,353 0.10 $ 9,783 0.10 $ 10,325 10055700 61010 100 4870 GE-28 UTILITY LOCATOR 0.50 $ 28,218 0.50 $ 30,737 0.50 $ 32,640 10055700 61010 100 GE-35 TRAFFIC ENGINEER 0.77 $ 57,665 0.77 $ 61,941 0.75 $ 67,326 Total 1.80 $ 121,862 1.70 $ 123,028 1.76 $ 136,276 Traffic Engineering-FT Service Fund 80055700 61010 800 GE-31 ENGINEERING TECHNICIAN 0.40 $ 28,144 0.40 $ 31,237 80055700 61010 800 GE-35 TRAFFIC ENGINEER 0.10 $ 7,347 0.10 $ 7,653 0.10 $ 8,977 Total 0.10 $ 7,347 0.50 $ 35,797 0.50 $ 40,214 Project Engineering-FT Sewer Fund 61055400 61010 610 4870 GE-28 UTILITY LOCATOR 0.50 $ 28,218 0.50 $ 30,185 0.50 $ 32,640 61055400 61010 610 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK 0.25 $ 12,867 0.25 $ 13,458 0.25 $ 14,214 61055400 61010 610 5525 GE-38 CIVIL ENGINEER II 0.10 $ 10,514 0.15 $ 16,352 0.35 $ 38,928 61055400 61010 610 4060 GE-40 PROJECT MANAGER 0.10 $ 11,694 0.10 $ 12,277 0.10 $ 13,020 61055400 61010 610 9425 GE-44 CITY ENGINEER 0.20 $ 29,847 0.20 $ 31,220 0.20 $ 32,905 61055400 61010 610 2710 GE-26 I&I INSPECTOR —$ — 61055400 61010 610 225 GE-31 SECRETARY 0.05 $ 3,500 0.05 $ 3,778 0.05 $ 3,594 61055400 61010 610 2220 GE-31 ENGINEERING TECHNICIAN 0.23 $ 15,456 0.38 $ 28,714 0.55 $ 40,881 Total 1.43 $ 112,096 1.63 $ 135,984 2.00 $ 176,182 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.40 $ 42,059 0.45 $ 48,593 0.45 $ 50,294 80055610 61010 800 GE-35 CIVIL ENGINEER I 0.10 $ 8,904 0.05 $ 4,676 0.05 $ 4,929 80055610 61010 800 9425 GE-44 CITY ENGINEER 0.10 $ 14,924 0.10 $ 15,609 0.10 $ 16,452 80055610 61010 800 2220 GE-31 ENGINEERING TECHNICIAN 2.00 $ 140,584 1.70 $ 128,456 2.03 $ 154,096 80055610 61010 800 2725 GE-30 SURVEY TECHNICIAN 0.30 $ 20,937 0.30 $ 22,077 0.30 $ 18,916 80055610 61010 800 5575 GE-33 SURVEY PARTY CHIEF 0.30 $ 24,605 0.30 $ 25,737 0.30 $ 27,128 80055610 61010 800 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK 0.15 $ 7,755 0.15 $ 8,113 0.20 $ 11,418 80055610 61010 800 225 GE-31 SECRETARY 0.05 $ 3,546 0.10 $ 7,556 0.05 $ 3,594 80055610 61010 800 4060 GE-40 PROJECT MANAGER 0.10 $ 11,694 0.10 $ 12,277 0.10 $ 13,020 Total 3.50 $ 275,008 3.25 $ 273,094 3.58 $ 299,847 Project Engineering-FT Stormwater Fund 62055620 61010 620 2220 GE-31 ENGINEERING TECHNICIAN 0.28 $ 19,033 0.28 $ 20,248 0.40 $ 30,134 62055620 61010 620 4870 GE-28 UTILITY LOCATOR 0.50 $ 28,218 0.50 $ 30,185 0.50 $ 32,640 CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2023 FY 2024 FY 2025 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET -129- 62055620 61010 620 1000 GE-33 CONFIDENTIAL ACCOUNT CLERK 0.25 $ 12,867 0.20 $ 10,772 0.20 $ 11,376 62055620 61010 620 9425 GE-44 CITY ENGINEER 0.15 $ 22,386 0.15 $ 23,415 0.15 $ 24,679 62055620 61010 620 CIVIL ENGINEER II —$ — 0.05 $ 4,832 62055620 61010 620 225 GE-31 SECRETARY 0.05 $ 3,546 0.05 $ 3,778 0.05 $ 3,594 62055620 61010 620 1900 GE-38 CIVIL ENGINEER I —$ — 0.05 $ 5,607 —$ — Total 1.23 $ 86,050 1.23 $ 94,005 1.35 $ 107,255 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,310 0.03 $ 3,364 0.03 $ 2,899 62055751 61010 620 2220 GE-31 ENGINEERING TECHNICIAN —$ — 0.10 $ 7,965 62055751 61010 620 2230 GE-38 CIVIL ENGINEER II 0.40 $ 42,059 0.10 $ 11,213 0.10 $ 9,664 62055752 61010 620 2230 GE-38 CIVIL ENGINEER II 0.02 $ 2,938 0.01 $ 1,125 0.02 $ 1,933 62055753 61010 620 1900 GE-38 CIVIL ENGINEER II 0.04 $ 4,206 0.02 $ 2,242 0.02 $ 1,933 62055754 61010 620 1900 GE-38 CIVIL ENGINEER II 0.10 $ 10,514 0.05 $ 5,607 0.04 $ 3,866 62055755 61010 620 GE-38 CIVIL ENGINEER II 0.08 $ 8,411 0.04 $ 4,486 0.04 $ 3,866 62055756 61010 620 1900 GE-38 CIVIL ENGINEER II 0.40 $ 42,059 0.25 $ 28,034 0.25 $ 24,160 Total 1.10 $ 116,497 0.50 $ 56,071 0.60 $ 56,286 Stormwater Utility FT Stormwater 62055900 61010 620 2230 GE-38 CIVIL ENGINEER II —$ — 0.50 $ 53,728 0.30 $ 34,096 Total —$ — 0.50 $ 53,728 0.30 $ 34,096 Stormwater Utility -PT Stormwater 62055620 61020 620 GE-24 UTILITY LOCATOR —$ — 62055900 61020 620 2710 GE-26 I&I INSPECTOR 1.46 $ 79,078 1.46 $ 82,714 1.46 $ 87,192 Total 1.46 $ 79,078 1.46 $ 82,714 1.46 $ 87,192 Stormwater Utility -FT Service Fund 80055620 61010 800 5525 GE-38 CIVIL ENGINEER II 0.40 $ 42,059 0.35 $ 39,248 0.32 $ 30,925 80055620 61010 800 9425 GE-44 CITY ENGINEER 0.05 $ 6,020 0.05 $ 6,296 0.05 $ 8,227 80055620 61010 800 GE-35 CIVIL ENGINEER I 0.10 $ 8,904 0.05 $ 4,640 0.05 $ 4,929 80055620 61010 800 GE-31 SECRETARY 0.05 $ 3,546 0.10 $ 7,556 0.05 $ 3,594 80055620 61010 800 2220 GE-31 ENGINEERING TECHNICIAN 0.90 $ 60,283 0.80 $ 59,782 1.30 $ 98,658 80055620 61010 800 2700 GE-31 ENGINEERING ASSISTANT II 0.05 $ 3,718 0.05 $ 3,889 0.05 $ 4,100 80055620 61010 800 2725 GE-30 SURVEY TECHNICIAN 0.25 $ 17,448 0.25 $ 18,398 0.25 $ 15,763 80055620 61010 800 4060 GE-40 PROJECT MANAGER 0.05 $ 5,848 0.05 $ 6,139 0.05 $ 6,447 80055620 61010 800 5575 GE-33 SURVEY PARTY CHIEF 0.25 $ 20,505 0.25 $ 21,447 0.25 $ 22,608 80055620 61010 800 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK 0.40 $ 20,726 0.40 $ 21,678 0.50 $ 28,577 Total 2.50 $ 189,057 2.35 $ 189,073 2.87 $ 223,828 Detention Basin Maintenance 62055920 61010 920 GE-31 ENGINEERING TECHNICIAN —$ — —$ — 0.03 $ 2,390 62055920 61010 920 5525 GE-38 CIVIL ENGINEER II —$ — —$ — 0.03 $ 2,899 Total —$ — —$ — 0.06 $ 5,289 Residential Parking - FT CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2023 FY 2024 FY 2025 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET -130- 63055630 61010 630 GE-35 TRAFFIC ENGINEER 0.03 $ 2,204 0.03 $ 2,422 0.05 $ 4,488 Total 0.03 $ 2,204 0.03 $ 2,422 0.05 $ 4,488 Water Utility -FT 64055400 61010 630 GE-31 ENGINEERING TECHNICIAN 0.03 $ 2,168 0.03 $ 2,266 0.15 $ 10,527 64055400 61010 640 4870 GE-28 UTILITY LOCATOR 0.50 $ 28,218 0.50 $ 30,971 0.50 $ 32,953 Total 0.53 $ 30,386 0.53 $ 33,237 0.65 $ 43,480 TOTAL ENGINEERING DEPARTMENT 40.20 $ 2,879,563 40.92 $ 3,109,975 41.71 $ 3,340,025 CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2023 FY 2024 FY 2025 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET -131- 5521000002 Sidewalk curb/catch basin rep Engineering 301 67990 7,000 5521000002 Sidewalk curb/catch basin rep Engineering 301 64075 70,000 5521000004 South Heacock Road Const Engineering 305 67990 4,041,544 5521000004 South Heacock Road Const Engineering 305 64075 606,232 5521000006 Sidewalk Inspection Program Engineering 100 67990 40,000 5521000009 14th Street Overpass Engineering 301 64070 100,000 5521000010 Sidewalk Program-City Prop Engineering 110 67990 89,543 5521000010 Sidewalk Program-City Prop Engineering 301 64075 5,000 5521000010 Sidewalk Program-City Prop Engineering 301 67990 5,457 5521000012 Street Construction Repairs Engineering 301 64075 120,000 5521000012 Street Construction Repairs Engineering 301 67990 10,000 5521000013 Pavement Marking Project Engineering 301 67990 225,000 5521000013 Pavement Marking Project Engineering 301 64075 25,000 5521000018 Pavement Rehabilitation Engineering 301 67990 650,000 5521000018 Pavement Rehabilitation Engineering 301 64075 50,000 5521000019 Brick Paver Maintenance Engineering 301 67990 20,000 5521000019 Brick Paver Maintenance Engineering 301 64075 5,000 5521000034 PAVE PRES JOINT SEALING Engineering 301 64075 5,000 5521000034 PAVE PRES JOINT SEALING Engineering 301 67990 20,000 5521000036 SOUTH PORT REDEVELOPMENT Engineering 305 67990 420,000 5521000036 SOUTH PORT REDEVELOPMENT Engineering 305 64075 57,000 5521000049 Hillcrest Rd Sidewalk Engineering 301 64075 5,000 5521000049 Hillcrest Rd Sidewalk Engineering 301 67990 15,000 5521000054 Wildwood Drive Bridge Replacement Engineering 301 64075 25,000 5521000054 Wildwood Drive Bridge Replacement Engineering 301 67990 50,000 5521000055 3rd St Overpass Sidewalk Replacemen Engineering 301 67990 125,000 5521000055 3rd St Overpass Sidewalk Replacemen Engineering 301 64075 25,000 5521000056 Development Dubuque Industrial Cent Engineering 305 64075 25,000 5521000056 Development Dubuque Industrial Cent Engineering 305 64900 370,000 5521000057 Auburn and Custer Pavement Engineering 301 67990 450,000 5521000057 Auburn and Custer Pavement Engineering 301 64075 50,000 5521000058 Dev McFadden Properties - Grading Engineering 305 67990 1,320,000 5523000002 Grandview Street Light Repl Engineering 301 64075 5,000 5523000002 Grandview Street Light Repl Engineering 301 67990 45,000 5523000003 Street Light Replacement Engineering 305 64075 5,000 5524000001 Emergency Preemption expan Engineering 301 67270 10,000 5524000003 Stone Retaining Walls Repair Engineering 301 67990 90,000 5524000003 Stone Retaining Walls Repair Engineering 301 64070 10,000 5524000007 Traffic Signal Controller Rep Engineering 301 67270 25,000 5524000008 Traffic Signal Inter Reconst Engineering 301 64075 5,000 5524000008 Traffic Signal Inter Reconst Engineering 301 67990 60,000 5524000011 Fiber Optic Conduit Engineering 301 67990 10,000 5524000011 Fiber Optic Conduit Engineering 301 64075 2,500 5524000013 Street Light/Traffic Control Engineering 301 67990 30,000 5524000014 ITS Traffic Control Equipment Engineering 301 64075 2,000 5524000014 ITS Traffic Control Equipment Engineering 301 67990 23,000 5524000016 Street Camera Installation Engineering 305 64075 5,000 5524000016 Street Camera Installation Engineering 305 67270 70,000 5524000017 Fiber Infrastructure mgmt Engineering 301 64075 30,000 5524000018 Streets Traffic Control Proj Engineering 301 64075 50,000 5524000029 Signalization Program Engineering 301 67990 45,000 5524000029 Signalization Program Engineering 301 64075 5,000 5524000051 STREETS Traffic Control Project Pha Engineering 301 64900 2,091,150 5524000051 STREETS Traffic Control Project Pha Engineering 301 64075 50,000 Capital Improvement Projects by Department/Division ENGINEERING Project Number Capital Improvement Project Title Department Fund Account FY 25 Recomm'd Budget -132- 5529900010 ADA Compliance and Facilities Manag Engineering 305 64900 50,000 5529900011 Downtown Bike Lockers Engineering 305 67270 15,000 5544000003 16TH ST DET BASIN TRAIL Engineering 301 67990 75,000 5544000003 16TH ST DET BASIN TRAIL Engineering 301 64075 25,000 5559900002 Inc Dev and Small Business Storefro Engineering 305 64075 150,000 5565000001 City Annex Roof Replacement Engineering 305 67500 22,000 5565000001 City Annex Roof Replacement Engineering 305 64075 4,500 5565000003 Federal Building Renovation Engineering 305 64075 98,700 5565000003 Federal Building Renovation Engineering 305 64900 100,000 5565000003 Federal Building Renovation Engineering 305 67500 1,590,025 5565000005 MFC Building Stabilization Engineering 304 64075 2,000 5565000005 MFC Building Stabilization Engineering 304 67500 28,500 5565000005 MFC Building Stabilization Engineering 304 64900 2,500 5565000006 City Hall Maintenance Engineering 305 64075 5,000 5565000006 City Hall Maintenance Engineering 305 67500 70,000 5565000018 MFC - Basement Rehabilitation Engineering 305 67500 30,000 5565000019 MFC - HVAC Replacement Engineering 305 67500 40,000 5565000020 Old Engine House Building Envelope Engineering 304 64075 3,200 5565000020 Old Engine House Building Envelope Engineering 304 64900 6,000 5565000020 Old Engine House Building Envelope Engineering 304 67500 31,500 5575000022 Iowa Amphitheater on Schmitt Island Engineering 305 64075 185,000 5575000022 Iowa Amphitheater on Schmitt Island Engineering 305 67990 2,000,000 5575000022 Iowa Amphitheater on Schmitt Island Engineering 305 64900 1,100,000 5581500006 Old Mill Road Lift Station Engineering 611 67990 8,637,800 5581500006 Old Mill Road Lift Station Engineering 611 64075 25,000 5581500006 Old Mill Road Lift Station Engineering 611 64070 1,140,000 5581500006 Old Mill Road Lift Station Engineering 611 67300 300,000 5581500008 Auburn&Custer Sewer Reconst Engineering 611 67990 85,000 5581500008 Auburn&Custer Sewer Reconst Engineering 611 64075 15,000 5581500013 Sewer CCTV Inspect/Assess Engineering 611 64075 20,000 5581500013 Sewer CCTV Inspect/Assess Engineering 611 64070 180,000 5581500017 GENERAL SANITARY SEWER REPAIR Engineering 611 64075 30,000 5581500017 GENERAL SANITARY SEWER REPAIR Engineering 611 67990 220,000 5581500020 SAN SEWER MANHOLE REPLACE Engineering 611 64075 15,000 5581500020 SAN SEWER MANHOLE REPLACE Engineering 611 67990 85,000 5581500023 CEDAR/TERM ASSESSMENTS Engineering 611 64070 237,000 5581500023 CEDAR/TERM ASSESSMENTS Engineering 611 67990 1,833,000 5581500023 CEDAR/TERM ASSESSMENTS Engineering 611 64075 30,000 5581500048 Southgate Sanitary Sewer Reconstruc Engineering 611 64075 10,000 5581500048 Southgate Sanitary Sewer Reconstruc Engineering 611 67990 195,000 5581500049 Schmitt Island Sanitary Improvement Engineering 611 67990 2,400,000 5581500049 Schmitt Island Sanitary Improvement Engineering 611 64075 240,000 5586500001 Storm Sewer Replacements Engineering 621 67990 60,000 5586500001 Storm Sewer Replacements Engineering 621 64075 40,000 5586500002 Catch Basin Reconstruction Engineering 621 64070 10,500 5586500002 Catch Basin Reconstruction Engineering 621 67990 43,500 5586500006 SW Infiltration&Info Elim Pro Engineering 621 67990 46,200 5586500006 SW Infiltration&Info Elim Pro Engineering 621 64075 6,300 5586500007 Bee Branch Gate&pump replc Engineering 303 67990 4,145,948 5586500013 FLOOD CONTROL MAINT FACILITY Engineering 303 64070 215,000 5586500013 FLOOD CONTROL MAINT FACILITY Engineering 303 64075 10,000 5586500020 Storm sewer Imprv/Exten Engineering 621 67990 50,500 5586500020 Storm sewer Imprv/Exten Engineering 621 64075 10,500 5586500038 Storm Sewer Outlet Repairs Engineering 621 67300 2,000 Capital Improvement Projects by Department/Division ENGINEERING Project Number Capital Improvement Project Title Department Fund Account FY 25 Recomm'd Budget -133- 5586500038 Storm Sewer Outlet Repairs Engineering 621 64075 4,000 5586500038 Storm Sewer Outlet Repairs Engineering 621 67990 40,000 5586500039 24th St Pervious Paver Stabilizatio Engineering 621 64070 5,000 5586500039 24th St Pervious Paver Stabilizatio Engineering 621 64075 10,000 5586500039 24th St Pervious Paver Stabilizatio Engineering 621 67990 75,000 5586500040 Auburn & Custer Storm Sewer Reconst Engineering 621 67990 250,000 5586500040 Auburn & Custer Storm Sewer Reconst Engineering 621 64070 37,500 ENGINEERING TOTAL 38,094,099 Capital Improvement Projects by Department/Division ENGINEERING Project Number Capital Improvement Project Title Department Fund Account FY 25 Recomm'd Budget -134- ENGINEERING SANITARY SEWER Business Type General Sanitary Sewer Extensions to Existing Developments $ — $ — $ — $ — $ 925,000 $ 925,000 165 Sanitary Sewer Extensions - Existing Development, Pre- annexation and Annexation Agreements $ — $ — $ — $ — $ 1,000,000 $ 1,000,000 166 Dubuque Industrial Center Crossroads Sanitary Sewer Extension $ — $ 230,000 $ — $ — $ — $ 230,000 167 Dubuque Industrial Center Chavenelle, Sewer Extension to Pennsylvania $ — $ — $ — $ 234,989 $ — $ 234,989 168 General Sanitary Sewer Replacement $ 250,000 $ 260,000 $ 270,000 $ 350,000 $ 445,800 $ 1,575,800 169 Sanitary Sewer Lining Program $ — $ — $ — $ 195,234 $ 436,791 $ 632,025 170 Sanitary Sewer CCTV Inspection, Cleaning, & Assessment $ 200,000 $ 100,000 $ — $ 280,000 $ 401,250 $ 981,250 171 Manhole Replacement / Rehabilitation Program (Consent Decree)$ 100,000 $ 105,000 $ 105,000 $ 150,000 $ 168,590 $ 628,590 172 Reconstruction Knob Hill-Duggan Drive Sanitary Sewer Reconstruction $ — $ — $ — $ 22,279 $ 165,500 $ 187,779 173 Outfall Manhole Reconstruction $ — $ 635,000 $ — $ — $ — $ 635,000 174 Cedar and Terminal Street Lift Station and Force Main Assessment and Improvements $ 2,100,000 $ 2,750,000 $ — $ — $ — $ 4,850,000 175 Hempstead Sanitary Sewer Reconstruction $ — $ 17,000 $ 441,803 $ — $ — $ 458,803 175 Cooper Place and Maiden Lane Sanitary Sewer Reconstruction $ — $ — $ 481,115 $ — $ — $ 481,115 178 Abbott & Cottage Sanitary Sewer Reconstruction $ — $ — $ — $ 23,340 $ 299,024 $ 322,364 179 Harvard St Sanitary Sewer Reconstruction $ — $ 20,000 $ 244,310 $ — $ — $ 264,310 180 Brunswick Sanitary Sewer $ — $ — $ 10,000 $ 119,000 $ — $ 129,000 181 King Street Sanitary Sewer Reconstruction $ — $ — $ 10,000 $ 167,571 $ — $ 177,571 182 Old Mill Road Lift Station & Force Main $ 10,102,800 $ 11,176,900 $ 2,019,469 $ — $ — $ 23,299,169 183 Catfish Creek Sewershed Interceptor Sewer Improvements $ — $ 700,000 $ 4,937,212 $ 8,240,000 $ — $ 13,877,212 184 Auburn & Custer Sanitary Sewer Reconstruction $ 100,000 $ — $ — $ — $ — $ 100,000 186 Southgate Sanitary Sewer Reconstruction $ 205,000 $ — $ — $ — $ — $ 205,000 187 South West Arterial Interchange Sewer Extension $ — $ — $ 200,000 $ 2,363,076 $ 2,266,762 $ 4,829,838 188 Schmitt Island Sanitary Improvements $ 2,640,000 $ — $ — $ — $ — $ 2,640,000 189 STORMWATER PRGR M/ DEPT PROJECT DESCRIPTION FY 2025 FY 2026 FY 2027 FY 2028 FY 2029 TOTAL PAGE -135- Business Type General Storm Sewer Projects Storm Sewer General Replacements $ 100,000 $ 100,000 $ 100,000 $ 100,000 $ 105,000 $ 505,000 141 Storm Sewer Improvements/ Extensions $ 61,000 $ 62,000 $ 62,000 $ 63,000 $ 63,000 $ 311,000 142 Stormwater Infiltration & Inflow Elimination Program $ 52,500 $ 55,000 $ 57,700 $ 60,400 $ 64,100 $ 289,700 143 Storm Sewer Outlet Repairs $ 46,000 $ 47,700 $ 49,400 $ 51,100 $ 52,800 $ 247,000 144 Catch Basin Reconstruction $ 54,000 $ 55,000 $ 55,000 $ 56,000 $ 56,000 $ 276,000 145 Drain Tile Program $ — $ — $ 100,000 $ 104,000 $ 116,000 $ 320,000 146 Bee Branch Watershed Projects Bee Branch Creek Gate & Pump Replacement $ 4,145,948 $ 9,081,932 $ 3,611,111 $ — $ — $ 16,838,991 147 Flood Control Maintenance Facility $ 225,000 $ — $ — $ 3,556,000 $ — $ 3,781,000 148 North End Storm Sewer Improvements $ — $ — $ — $ 180,000 $ 470,000 $ 650,000 149 Specific Storm Sewer Projects Windsor Storm Extension (Buena Vista to Strauss)$ — $ — $ 136,000 $ — $ — $ 136,000 150 University Ave Storm Sewer $ — $ — $ 175,000 $ — $ — $ 175,000 151 NW Arterial Detention Basin Improvements $ — $ — $ 5,000 $ 247,000 $ — $ 252,000 152 Bies Drive Storm Sewer (Street Program)$ — $ — $ 98,000 $ — $ — $ 98,000 153 Cedar Cross Road Storm Sewer Construction $ — $ — $ 292,000 $ — $ — $ 292,000 154 Century Drive Storm Sewer Reconstruction $ — $ — $ 242,500 $ — $ — $ 242,500 155 Embassy West Storm Sewer Improvements $ — $ 153,000 $ — $ — $ — 153,000 156 24th St Pervious Paver Stabilization $ 90,000 $ — $ — $ — $ — 90,000 157 Auburn & Custer Storm Sewer Reconstruction $ 287,500 $ — $ — $ — $ — 287,500 158 Rockdale Road Storm Sewer Extension (Street Program)$ — $ 10,000 $ 80,000 $ — $ — 90,000 159 Sylvan Dr Storm Sewer Extension $ — $ — $ 6,000 $ 56,800 $ — 62,800 160 Bennett Street Storm Sewer Improvements (Street Program)$ — $ — $ 62,500 $ — $ — 62,500 161 Trygg Storm Sewer Extension Project $ — $ — $ — $ 312,500 $ — 312,500 162 Cater Road and Westmore Storm Sewer Extension $ — $ — $ — $ 159,000 $ — 159,000 163 Loras & Locust Intersection Reconstruction (Storm Sewer)$ — $ 84,000 $ — $ — $ — 84,000 164 STREETS Public Works Street Related Improvements Pavement Marking Project $ 250,000 $ 250,000 $ 250,000 $ 250,000 $ 250,000 $ 1,250,000 190 Pavement Management Program $ — $ — $ — $ — $ 55,000 $ 55,000 191 PRGR M/ DEPT PROJECT DESCRIPTION FY 2025 FY 2026 FY 2027 FY 2028 FY 2029 TOTAL PAGE -136- Street Construction General Repairs $ 130,000 $ 120,000 $ 130,000 $ 135,000 $ 140,000 $ 655,000 192 East - West Corridor Capacity Improvements $ — $ — $ — $ — $ 250,000 $ 250,000 193 Pavement Rehabilitation - Concrete Street Repair, Mill and Asphalt Resurfacing $ 700,000 $ — $ — $ — $ — $ 700,000 195 Pavement Preservation Joint Sealing $ 25,000 $ — $ — $ — $ — $ 25,000 196 7th Street Extension to Pine Street $ — $ — $ 400,000 $ 700,000 $ — $ 1,100,000 197 Traffic and Pedestrian Crossing Warning Devices $ — $ — $ 31,000 $ — $ 36,000 $ 67,000 198 Dubuque Industrial Center McFadden Farm - South Heacock Road Construction $ 4,647,776 $ — $ — $ — $ — $ 4,647,776 199 14th St Overpass $ 100,000 $ 33,153,635 $ 4,952,462 $ 913,903 $ 100,000 $ 39,220,000 200 Auburn and Custer Pavement $ 500,000 $ — $ — $ — $ — $ 500,000 201 Wildwood Drive Bridge Replacement $ 75,000 $ 400,000 $ — $ — $ — $ 475,000 203 US 20 - Northwest Arterial Intersection Operational and Capacity Improvements $ — $ — $ — $ 2,097,000 $ 3,400,000 $ 5,497,000 204 Central Avenue Corridor Streetscape Master Plan Implementation Improvements 11th - 22nd Street $ — $ — $ 211,736 $ — $ 250,000 $ 461,736 205 Development Dubuque Industrial Center: Crossroads $ 395,000 $ — $ 228,803 $ 253,184 $ — $ 876,987 207 Development of McFadden Properties - Grading $ 1,320,000 $ 5,460,000 $ 2,163,178 $ — $ — $ 8,943,178 208 Development of Graft Properties $ — $ 217,000 $ 2,000,000 $ — $ — $ 2,217,000 209 Sidewalk Related Sidewalk Inspection Program - Assessable $ 40,000 $ 40,000 $ 40,000 $ 45,000 $ 45,000 $ 210,000 210 Sidewalk Program - City-Owned Property $ 100,000 $ 100,000 $ 100,000 $ 50,000 $ 100,000 $ 450,000 211 Sidewalk Program Related Curb and Catch Basin Replacements $ 77,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 277,000 212 Hillcrest Road Sidewalk $ 20,000 $ 50,000 $ — $ — $ — $ 70,000 213 Brick Paver Maintenance $ 25,000 $ — $ — $ — $ — $ 25,000 214 3rd St Overpass Sidewalk Replacement Project $ 150,000 $ — $ — $ — $ — $ 150,000 215 Decorative Concrete Maintenance Program $ — $ 250,000 $ — $ — $ — $ 250,000 216 Trails/General Maintenance Stone Retaining Walls $ 100,000 $ 100,000 $ 100,000 $ 100,000 $ 130,000 $ 530,000 217 Bridge Repairs/Maintenance $ — $ 100,000 $ 100,000 $ 100,000 $ 100,000 $ 400,000 218 Trail Planning $ — $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 80,000 219 Bee Branch Creek Trail: 16th to 9th $ 100,000 $ 250,000 $ 425,000 $ — $ — $ 775,000 220 MISCELLANEOUS General Government South Port Redevelopment $ 20,000 $ 40,000 $ — $ — $ — $ 60,000 221 Port of Dubuque - Security Cameras $ — $ — $ 20,000 $ — $ — $ 20,000 222 PRGR M/ DEPT PROJECT DESCRIPTION FY 2025 FY 2026 FY 2027 FY 2028 FY 2029 TOTAL PAGE -137- Speed Shields $ — $ — $ — $ — $ 49,000 $ 49,000 223 ABC Supply Building Deconstruction $ 457,000 $ — $ — $ — $ — $ 457,000 224 Iowa Amphitheater on Schmitt Island $ 3,285,000 $ 5,499,961 $ — $ — $ — $ 8,784,961 225 Incremental Development and Small Business Storefront Establishment Coaching $ 150,000 $ — $ — $ — $ — $ 150,000 226 TRAFFIC Public Works Street Light Replacement and New Installation $ 5,000 $ 45,000 $ 45,000 $ 45,000 $ 45,000 $ 185,000 228 Signalization Program $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 250,000 229 Traffic Signal Mastarm Retrofit $ — $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 200,000 230 Traffic Signal Interconnect Conduit Replacement $ — $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 160,000 231 Traffic Signal Controller Replacement $ 25,000 $ 35,000 $ 40,000 $ 45,000 $ 45,000 $ 190,000 232 Street Lighting and Traffic Signal Knockdown/Insurance $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 150,000 233 Street Camera Installation $ 75,000 $ 60,000 $ 60,000 $ 110,000 $ 110,000 $ 415,000 234 LED Re-Lamp Schedule $ — $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 40,000 235 Traffic Signal Battery Backup $ — $ 25,000 $ 25,000 $ 30,000 $ 30,000 $ 110,000 236 Traffic Signal Intersection Reconstruction $ 65,000 $ 70,000 $ 75,000 $ 80,000 $ 100,000 $ 390,000 237 Surge and Grounding Improvement at Signals $ — $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 80,000 238 STREETS Traffic Control Project Phase 1 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 250,000 239 STREETS Traffic Control Project Phase 2 $ 2,141,150 $ 282,350 $ — $ — $ — $ 2,423,500 240 Traffic Signal Fiber Optic Network Program $ — $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 200,000 241 ITS Traffic Control Equipment $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 125,000 242 Traffic Signal Vehicle Detection Conversion $ — $ 50,000 $ 60,000 $ 60,000 $ 60,000 $ 230,000 243 Grandview Street Light Replacement $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 250,000 244 INET Fiber Replacement Build Out $ — $ 60,000 $ — $ — $ — $ 60,000 245 Emergency Preemption Expansion and Upgrades $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 20,000 $ 60,000 246 Fiber Optic Conduit - Miscellaneous $ 12,500 $ 12,500 $ 12,500 $ 12,000 $ 50,000 $ 99,500 247 Fiber Infrastructure Management System $ 30,000 $ 40,000 $ 50,000 $ 65,000 $ — $ 185,000 248 Broadband Acceleration and Universal Access $ — $ 25,000 $ 50,000 $ 75,000 $ 80,000 $ 230,000 249 Facilities Management Federal Building Renovation $ 1,788,725 $ 3,198,225 $ — $ — $ 4,695,000 $ 9,681,950 250 City Hall Tuck Pointing Maintenance & Repairs $ 75,000 $ — $ — $ — $ — $ 75,000 251 MFC Building Envelope Stabilization $ 33,000 $ — $ — $ — $ — $ 33,000 252 PRGR M/ DEPT PROJECT DESCRIPTION FY 2025 FY 2026 FY 2027 FY 2028 FY 2029 TOTAL PAGE -138- City Annex Roof Replacement Project $ 26,500 $ — $ — $ — $ — $ 26,500 253 Multicultural Family Center - Ruby Sutton Building HVAC Replacement $ 40,000 $ — $ — $ — $ — $ 40,000 254 Multicultural Family Center - Basement Rehabilitation $ 30,000 $ — $ — $ — $ — $ 30,000 255 ADA Compliance and Facilities Management Consulting $ 50,000 $ 50,000 $ — $ — $ — $ 100,000 256 Old Engine House Building Envelope Stabilization $ 40,700 $ — $ — $ — $ — $ 40,700 257 Downtown Bike Lockers $ 15,000 $ 15,000 $ 15,000 $ — $ — $ 45,000 258 TOTAL $ 38,094,099 $ 76,096,203 $ 25,890,799 $ 22,712,376 $ 17,620,617 $ 180,414,094 PRGR M/ DEPT PROJECT DESCRIPTION FY 2025 FY 2026 FY 2027 FY 2028 FY 2029 TOTAL PAGE -139- This page is intentionally left blank -140-