Loading...
Ordinance 45-23RECORD OF ORDINANCES Dayton Legal Blank, Inc. Form No. 30043 Ordinance No. 45-23 Passed __,20 ADOPTING THE ANNUAL OPERATING BUDGET FOR THE FISCAL YEAR ENDING DECEMBER 31, 2024 WHEREAS, Section 8.02(a) of the Dublin City Charter requires the City Manager to prepare and submit the Annual Operating Budget to City Council; and WHEREAS, City Council has received and reviewed the Annual Operating Budget for 2024; and WHEREAS, the Administration has incorporated in the 2024 Operating Budget document any necessary modifications as requested by City Council as a result of the budget review sessions. NOW, THEREFORE, BE IT ORDAINED by the Council of the City of Dublin, State of Ohio, f of its elected members concurring, that: Section 1. The 2024 Annual Operating Budget hereby is approved. Section 2. This ordinance shall take effect and be in force in accordance with Section 4.04(b) of the Revised Charter. Passed this LT day of NAW , 2023. Place. Diy) Mayor - Presiding Officer / ATTEST: (Lesa, () fo og of Gélincil d To: Members of Dublin City Council From: Megan O’Callaghan, City Manager Date: October 17, 2023 Initiated By: Matthew L. Stiffler, Chief Financial Officer/Director of Finance Jaime Hoffman, Director of Finance Operations Meghan Murray, Budget Manager Doug Urbancsik, Financial Analyst Re: Proposed 2024 Operating Budget Background This memorandum provides background information and context for the attached Proposed 2024 Operating Budget. Preparation of the 2024 Operating Budget provides the opportunity to continue to review the City’s operations and determine how the City use its resources most effectively. It also provides an opportunity to ensure the budget is aligned with City Council’s goals and the Strategic Framework adopted by City Council in mid-2022. As set forth in the Strategic Framework, Dublin aspires to be the most sustainable, connected and resilient global city of choice. This proposed operating budget continues to uphold the City’s commitment to responsible fiscal stewardship and the continuation of best-in-class services. Digital Budget Book Software For the 2024 Operating Budget, the City continued utilizing Cleargov software. This is the same software the City used to create the 2024-2028 Capital Improvements Program. As part of the software package, the City is utilizing a Digital Budget Book component to provide the Operating Budget to Council for review, similar to the 2023 Operating Budget. This software allows us to produce a more consistent and professional looking document published digitally on our website. This digital document allows residents to find the information they may be looking for in a more accessible, searchable and web-friendly format. Additionally, the digital budget can be read aloud for visually impaired residents or translated in numerous languages for non- English speaking residents. These efforts continue to increase the transparency and accountability of our finances, are more sustainable, and further the City’s diversity, equity and inclusion goals. Revenue Estimates The City’s largest revenue source for operations is income tax revenue. This source comprises over 90% of the City’s General Fund operating revenues. The 2023 Operating Budget budgeted $94.0 million in revenue from local income tax. Per City policy, 25% of that amount, or $23.5 million is allocated to fund capital projects, and debt issued for capital projects. The remaining 75%, or $70.5 million, is posted to the General Fund to be used for general operations. Last year’s budgeted revenue remained very conservative due to the high level of uncertainty in the economy and the unknown effects of the relatively unsettled work-from-home environment. Since Office of the City Manager 5555 Perimeter Drive • Dublin, OH 43017-1090 Phone: 614.410.4400 • Fax: 614.410.4490 Memo Memo re. Proposed 2024 Operating Budget October 17, 2023 Page 2 of 3 then, revenues have continued to increase at a steady rate, with an average increase of 3% over the past several years. As a result, the City is projecting ~$107 million in income tax revenue for 2023 and has revised the income tax budget to $104.0 million. Per Council’s request, staff have taken into consideration realistic conservative revenues to better represent the City’s expectations regarding the variance between budgeted and actual annual revenues. Based on these factors, the income tax estimate for 2024 is $106.0 million or ~1.9% more than the revised 2023 income tax budget and ~1.9% less than currently projected 2023 actuals. General Fund Balance The General Fund balance is a key component to the financial health and stability of the City. The City’s policy is to maintain a year-end balance equal to or greater than 50% of the General Fund expenditures, including operating transfers. As of the end of September 2023, the General Fund balance was $68.4 million which represented 62.6% of the City’s 2023 revised budget General Fund expenditures. Maintaining a strong General Fund balance is necessary for a variety of reasons. The most important is as a backstop against significant reductions in City services. Additionally, the City continues to invest in our future success by enhancing our economic vitality through funding major capital improvements throughout the City. Dublin will continue to make transfers and advances from the General Fund to various TIF funds and the Capital Improvement Fund for infrastructure improvements. This allows the City to take advantage of opportunities as they arise and fund infrastructure improvements before TIF revenues are generated. The expectation is that these advances will be repaid to the General Fund over the 30-year life of each TIF. Budget Utilization The City of Dublin has historically passed budgets where budgeted expenditures exceed budgeted revenues. This has been a reflection of a conservative budgeting philosophy where revenues are estimated below expectations and expenditures are budgeted high. From 2006 to 2023 budgeted variances for the operating budget have been negative while actual variances have been positive. Per Council’s direction, staff have been working to create revenue estimates that better reflect actuals while remaining conservative in nature and reducing the amount of unused appropriations by increasing budget utilization. During the 2023 Budget process, staff closely examined budget utilization over the prior five years to make adjustments to better align budgeted expenditures with prior year’s actuals and estimated revenues. These modifications were intended to reduce excess budget capacity without having a negative impact on service delivery. The expectation communicated to Directors the past couple of years has been future budgets would move toward a budget utilization of about 90%, with 5% encumbered and 5% lapsed. In order to further reduce this budgeted variance and create a balanced budget, the Administration continued the strategies of including the use of vacancy credits and evaluating budget utilization to develop the Proposed 2024 Operating Budget, intending to move the City even closer to that utilization target. For the Proposed 2024 Operating Budget, revenues are budgeted realistically conservative and expenditures more closely mirror the expectation for utilization as discussed above. Resources are Memo re. Proposed 2024 Operating Budget October 17, 2023 Page 3 of 3 included in the proposal for directors to take action for unbudgeted or unforeseen situations when needed. As in prior years, the City Manager’s office has $150,000 budgeted for citywide contingencies. Historically, this funding has been underutilized, but it is anticipated that in 2024 this funding may see increased usage. It is important to note that in this budget environment, the Administration will likely be bringing forward additional items (as compared to prior years) in the supplemental appropriation process for Council’s consideration particularly with regard to Operating Budget items. Supplemental appropriations are approved by Council on a quarterly basis and as the year progresses if a Division needs additional funds for unbudgeted or under-budgeted activities the Administration will be bringing these items forward for Council’s consideration. Recommendation Staff looks forward to the Operating Budget Work Session discussion on November 6, 2023 and recommends that Council adopt the Proposed 2024 Operating Budget at the second reading/public hearing on November 27, 2023. To: Members of Dublin City Council From: Megan O’Callaghan, City Manager Date: October 17, 2023 Initiated By: Matthew L. Stiffler, Chief Financial Officer/Director of Finance Jaime Hoffman, Director of Finance Operations Meghan Murray, Budget Manager Doug Urbancsik, Financial Analyst Re: 2024 Annual Operating Budget Additional Reports and Information Background This memo will identify and explain several budget reports that are being distributed for Council’s consideration with regard to the 2024 Proposed Operating Budget. Each report will be identified and briefly explained in this memo. These reports are similar to reports that have been provided to members of Council in previous years. Fund Summary This table shows the budgeted and estimated revenues and expenditures for 2023 and 2024. This table validates that the appropriations proposed in the 2024 Operating Budget comply with the requirement that sufficient resources be available in every Fund to support the appropriations proposed as part of the operating budget. Budget Utilization Reports These reports show the historical spending from 2018 to 2023 (as of October 16, 2023) comparing the revised budget to actual spending for each budgetary segment. The report displays the percentage of actual spending as a function of the revised budget and is color coded moving from green to yellow to orange to red as budget utilization increases. Utilization Report 1: Utilization by Fund and Division This report shows the budget utilization by showing actual spending as compared to the revised budget by division since 2018. Utilization Report 2: Utilization by Fund and Division and Category This report contains information relative to the actual spending as compared to the revised budget in each category by each division in the city since 2018. Budget utilization may vary across categories over time as directors will have more discretion over categories such as contractual services than they will with regard to personal services. Detailed Budget Reports The following reports all relate to each other. Each report is a slightly more detailed version of the prior report. Each report contains the revised budget and actual expenditures from prior years and a comparison of the 2023 original budget and 2024 original budget. Each report summaries Office of the City Manager 5555 Perimeter Center • Dublin, OH 43017-1090 Phone: 614-410-4400 • Fax: 614-410-4490 Memo Memo re. 2024 Annual Operating Budget Additional Reports and Information October 12, 2023 Page 2 of 2 identical information at more detailed levels of analysis, but each report sums to the same $104.7 million figure. Basically, as you proceed through these reports you continue to move into deeper levels of analysis until you reach the lowest possible level which is the sub-account level detail expenditures report. This is the lowest and most detailed level of budget analysis and is the level at which budget requests are submitted by each division. Detailed Budget Report 1: Operating Budget by Fund This report displays the $104.7 million in operating expenditures in the proposed 2024 operating budget and allows for comparison of this amount to prior years. Detailed Budget Report 2: Operating Budget by Fund and Division This report displays operating expenditures by organization number in Munis sometimes referred to as a division. These comparisons over time allow you to see the rate of change at the division/department level. Detailed Budget Report 3: Expenditures by Fund and Division and Category This report displays operating expenditures by the character code in Munis sometimes referred to as a category. These comparisons over time allow you to see the rate of change in the type of expenditure at the division/department level. Detailed Budget Report 4: Expenditures by Fund and Division and Account This report displays operating expenditures by each account. These comparisons over time allow you to see the rate of change at the account level for every division/department. Detailed Budget Report 5: Sub-Account Level Detailed Expenditures This report displays the lowest level of budget analysis. It details the specific items that were requested and then summarized to the account level in the previous report (#4). Top Employers Report This report displays the City’s top 15 employers in 2022. It is reported annually as part of the City’s Annual Comprehensive Financial Report. Recommendation Information only. City of Dublin, Ohio 2024 Operating and Capital Improvements Budget Adopted Version City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 1 TABLE OF CONTENTS 2024 Budget Detail 4 City Council 5 Office of the City Manager 8 Office of the City Manager | General Fund 9 Office of the City Manager Miscellaneous Accounts | General Fund 12 Court Services | General Fund 14 Records Management | General Fund 17 Mayor's Court Computer | Special Revenue Fund 20 Legal Services | General Fund 22 Human Resources 24 Communications & Marketing | General Fund 28 Economic Development | General Fund 32 Innovation & Analytics | General Fund 35 Information Technology | General Fund 38 Police Services 41 Enforcement and Education | Special Revenue Fund 46 Finance 48 Finance | General Fund 49 Taxation | General Fund 52 Finance Miscellaneous Accounts | General Fund 55 Community Planning & Development | General Fund 58 Building Standards | General Fund 62 Transportation & Mobility 65 Transportation & Mobility | General Fund 66 Transportation & Mobility – Traffic Signals and Street Lights | Special Revenue Fund 69 Transportation & Mobility – Highway Operations | Special Revenue Fund 72 Engineering 74 Engineering | General Fund 75 Engineering | Enterprise Fund 78 Water System Maintenance | Enterprise Fund 79 Water System Construction | Enterprise Fund 83 Sewer System Maintenance | Enterprise Fund 85 Sewer System Construction | Enterprise Fund 89 Parks and Recreation 91 Office of the Parks & Recreation Director | General Fund 92 Public Art | Special Revenue Fund 95 Recreation Services | Special Revenue Fund 98 Community Recreation Center | Special Revenue Fund 102 Municipal Outdoor Swimming Pools | Special Revenue Fund 106 Community Events | Special Revenue Fund 109 Recreation Services – Community Events | Special Revenue Fund 113 Community Events – Other Work Units and Grants | Special Revenue Fund 116 Outreach & Engagement | General Fund 119 City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 2 Public Service 122 Parks and Grounds Maintenance | General Fund 123 Solid Waste Management | General Fund 127 Forestry | General Fund 130 Horticulture | General Fund 133 Cemetery Maintenance | Special Revenue Fund 136 Street Maintenance and Repairs | Special Revenue Fund 139 Asset Management & Quality Assurance | General Fund 142 Facilities Management | General Fund 145 Dublin Community Recreation Center – Facilities Maintenance | Special Revenue Fund 148 Fleet Management | General Fund 151 Capital Projects Funds 154 Debt | Debt Service Funds 167 Enterprise Funds 169 Enterprise Fund | Water System Maintenance - Debt Service 170 Enterprise Fund | Sewer System Maintenance - Debt Service 172 Fiduciary Funds 174 Fiduciary Funds | Unclaimed Monies 175 Fiduciary Funds | Agency 176 Fiduciary Funds | COIRS 178 Fiduciary Funds | PACE 180 Finance Transfers & Advances 181 Internal Service Funds 184 Internal Service Fund | Employee Benefits Self-Insurance 185 Internal Service Fund | Workers' Compensation 188 Special Revenue Funds 190 Special Revenue Fund | Accrued Leave Reserve 191 Special Revenue Fund | Opioid Relief Fund 192 Special Revenue Fund | Law Enforcement Trust 193 Special Revenue Fund | Wireless 911 195 Special Revenue Fund | Permissive Tax 197 City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 3 2024 BUDGET DETAIL City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 4 City Council Jenny Delgado Clerk of Council All powers of the City permitted by the Revised Charter, the Constitution and the laws of the State of Ohio are vested in City Council. Through the adoption of legislation, City Council provides for the exercise of all City powers and for the performance of all duties and obligations imposed on the City by law. City Council's responsibilities include reviewing, deliberating and approving legislation as prescribed by the Revised Charter and the laws of the State of Ohio applicable to municipalities. City Council establishes goals and long-range policies for the City. The council comprises seven members who serve four-year terms. Three are nominated and elected by the electors of the City at large and four are nominated and elected by the electors of each of the four City Council wards. All candidates for City Council must be residents of Dublin for one year prior to filing a petition of candidacy. Council members must be residents of the City of Dublin throughout their term of office. Ward Council members must be residents of the ward which they represent at the time they file for office and during their entire term of office. City Council elects a Mayor and Vice Mayor to serve two-year terms. The Mayor presides over all City Council meetings. The Vice Mayor performs these duties in the absence of the Mayor. The Clerk of Council is appointed by the City Council and serves at its pleasure. The Clerk of Council is an officer of the City and provides notice of Council meetings to its members and the public, keeps the minutes of Council’s proceedings and performs other duties as provided by the Revised Charter or by Council. Personnel Data Position Title 2023 | Adopted 2024 | Adopted Mayor 1 1 Vice Mayor 1 1 Council Member 5 5 Clerk of Council 1 1 Deputy Clerk of Council 1 1 Assistant Clerk of Council 1 1 Total 10 10 City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 5 Budgeted Expenditures by Function - City Council and Boards & Commissions | General Fund Budgeted and Historical Expenditures by Function MillionsBoards and Commissions Legislative Affairs FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $0.2 $0.4 $0.6 $0.8 $1 Expenditures General Government Legislative Affairs Full Time Salaries/Wages 10110510-701101 $341,974 $326,870 $326,870 $340,135 Overtime Wages 10110510-701103 $10,557 $25,000 $25,000 $12,500 Other Wages 10110510-701104 $1,127 $17,500 $17,500 $0 Employee Benefits 10110510-701201 $298,123 $301,500 $301,500 $294,195 Training/Travel 10110510-702000 $14,327 $24,500 $27,207 $0 Meeting Expenses 10110510-703100 $9,532 $7,500 $13,143 $0 Ceremonial Functions Expense 10110510-703101 $20,046 $12,000 $14,395 $12,000 Long Term Strategic Plan 10110510-703201 $777 $15,000 $11,723 $15,000 Other Professional Services 10110510-713004 $40,803 $74,800 $103,254 $25,000 Training/Travel 10110510-713010 $0 $0 $0 $35,000 Advertising 10110510-715002 $894 $2,000 $4,604 $2,500 Memberships/Subscriptions 10110510-716000 $1,927 $2,500 $2,500 $2,500 Office Supplies 10110510-721001 $6,532 $5,000 $16,267 $10,000 Meeting Expenses 10110510-721006 $0 $0 $0 $12,000 Total Legislative Affairs:$746,619 $814,170 $863,962 $760,830 Boards and Commissions Full Time Salaries/Wages 10110520-701101 $8,225 $12,155 $12,155 $13,190 Employee Benefits 10110520-701201 $1,251 $2,015 $2,015 $2,015 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 6 Training/Travel 10110520-702000 $1,060 $30,000 $30,082 $0 Meeting Expenses 10110520-703100 $0 $1,000 $1,000 $0 Training/Travel 10110520-713010 $0 $0 $0 $30,000 Memberships/Subscriptions 10110520-716000 $0 $750 $750 $2,500 Total Boards and Commissions:$10,536 $45,920 $46,002 $47,705 Total General Government:$757,155 $860,090 $909,964 $808,535 Total Expenditures:$757,155 $860,090 $909,964 $808,535 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 10110510 (City Council) Account 701101 provides funding for the salaries/wages of City Council members and staff reflected under Personnel Data. Account 701103 provides overtime for eligible staff working at night meetings. Account 701201 includes funding for benefits, including health insurance contributions for City Council members, the Clerk of Council and Legislative Services staff. Account 703101 includes funding for citywide ceremonial functions, which are reviewed and approved by the Mayor and the City Manager. These include events hosted by City Council, flowers, memorial donations and special occasion recognition. Account 703201 provides funding for long-term strategic planning workshops and City Council retreat(s). Account 713004 provides funding for codification services and City Council communications consulting. Account 713010 (previously 702000) includes funding for travel and training for City Council members and certification-related training for the Clerk of Council and Legislative Services staff. Account 715002 provides funding for advertising expenses related to publication in local newspapers of the annual meeting schedule and various required legal notices. 10110520 (Boards & Commissions) Account 701101 provides funding for the salaries/wages of seven Planning and Zoning Commission members. Account 713010 (previously 702000) provides funding, as authorized by City Council, for travel and training for Planning and Zoning Commission members and funding for orientation and training for all City board and commission members. Funding is provided for Architectural Review Board members to attend the Annual National Forum through the National Alliance for Preservation Commissions (NAPC). Account 716000 provides funding for American Planning Association (APA) memberships. Account 721006 (previously 703100) provides funding for expenses related to meetings sponsored by various City advisory boards, commissions, committees and task forces. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 7 Office of the City Manager Megan O'Callaghan City Manager The City Manager is the chief administrative and law enforcement officer of the City and is charged with the responsibility for the administration of all municipal affairs as empowered by the Revised Charter of the City of Dublin, City ordinances and resolutions and state laws. Some of the City Manager’s primary responsibilities include directing and supervising the administration of all departments and functions of the City; attending all Council meetings; ensuring that all laws, Revised Charter provisions, ordinances and resolutions of City Council are faithfully executed; preparing the annual budget and capital improvements program; publishing an annual report of the financial and administrative activities of the City; and executing, on behalf of the City, all contracts and agreements. Departmental budget information can be found on the individual fund pages. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 8 Office of the City Manager | General Fund Megan O'Callaghan City Manager The City Manager is the chief administrative and law enforcement officer of the City and is charged with the responsibility for the administration of all municipal affairs as empowered by the Revised Charter of the City of Dublin, City ordinances and resolutions and state laws. Some of the City Manager’s primary responsibilities include directing and supervising the administration of all departments and functions of the City; attending all Council meetings; ensuring that all laws, Revised Charter provisions, ordinances and resolutions of City Council are faithfully executed; preparing the annual budget and capital improvements program; publishing an annual report of the financial and administrative activities of the City; and executing, on behalf of the City, all contracts and agreements. Personnel Data Position Title 2023 | Adopted 2024 | Adopted City Manager 1 1 Deputy City Manager 1 1 Director of Administrative Services (2)1 0 Assistant to the City Manager (1)0 1 Management Analyst (1)3 2 Executive Assistant to the City Manager 1 1 Administrative Support I 3 3 Total 11 10 Part-Time/Seasonal Staff Intern 2 2 Total 2 2 Notes and Adjustments: 1. A Management Analyst position is reclassified to the Assistant to the City Manager. 2. The Director of Administrative Services position was reclassified to the Director of Innovation and Technology and budgeted 50% to the Division of Information Technology and 50% to the Division of Innovation and Analytics. Budget Summary 10110110 Account 701101 provides funding for the full-time staffing reflected under Personnel Data. Account 701104 provides funding for part-time (intern) staff. Account 703202 provides funding for leadership team retreats and goal setting. Account 713004 provides funding for other professional services and consultants. For 2024, this includes funding for the Chief Information Officer (CIO) contract and related projects, and consultants for special projects. Account 713010 (previously 702000) provides funding for training and travel for Office of the City Manager staff. Account 716000 provides funding for staff memberships to organizations such as International City/County Management Association (ICMA) and Ohio City/County Management Association (OCMA). Account 721001 provides funding for office supplies, printing and courier services. Account 721006 (previously 703100) provides funding for external and internal meetings sponsored by the City. This may include food, beverages and any necessary supplies for meetings with staff retreats, forums, etc. Account 751003 provides funding for projects such as the Intelligent Community Forum (ICF) Institute, ASN Support and Friendship Association – Cultural and Diversity Engagement and broadband research and licensing. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 9 General Fund | Office of the City Manager Expenditures by Expense Type Budgeted and Historical Expenditures by Expense Type MillionsSupplies Other Charges and Expenditures Contractual Services Personal Services FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $0.5 $1 $1.5 $2 $2.5 Expense Objects Personal Services Full Time Salaries/Wages 10110110- 701101 $669,462 $867,435 $867,435 $827,660 Overtime Wages 10110110- 701103 $14,174 $15,000 $15,000 $10,000 Other Wages 10110110- 701104 $30,839 $32,125 $32,125 $42,125 Employee Benefits 10110110- 701201 $247,454 $366,910 $366,910 $293,065 Training/Travel 10110110- 702000 $5,525 $20,500 $20,850 $0 Meeting Expenses 10110110- 703100 $4,468 $10,000 $10,028 $0 Staff Goal Setting 10110110- 703202 $6,749 $8,000 $10,035 $5,000 Total Personal Services:$978,672 $1,319,970 $1,322,382 $1,177,850 Contractual Services Other Professional Services 10110110- 713004 $438,216 $406,500 $563,354 $196,500 Training/Travel 10110110- 713010 $0 $0 $0 $18,380 Memberships/Subscriptions 10110110- 716000 $4,105 $9,730 $9,730 $14,400 Total Contractual Services:$442,321 $416,230 $573,084 $229,280 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 10 Supplies Office Supplies 10110110- 721001 $393 $3,000 $4,600 $4,000 Meeting Expenses 10110110- 721006 $0 $0 $0 $7,500 Total Supplies:$393 $3,000 $4,600 $11,500 Other Charges and Expenditures Special Projects/Programs 10110110- 751003 $89,504 $245,000 $257,493 $105,000 Total Other Charges and Expenditures:$89,504 $245,000 $257,493 $105,000 Total Expense Objects:$1,510,890 $1,984,200 $2,157,559 $1,523,630 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 11 Office of the City Manager Miscellaneous Accounts | General Fund Megan O'Callaghan City Manager These are miscellaneous accounts within the General Fund which are not directly related to the operational costs of a specific function. The functional supervision of these accounts is provided by the Office of the City Manager. Funds are appropriated to the contingency account to be held for any unforeseen expenses during the current fiscal year. Expenditures are required to be approved by the City Manager. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 12 City Manager Miscellaneous Expenditures by Expense Type | General Fund Budgeted and Historical 2024 Expenditures by Expense Type MillionsGeneral Fund FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $2.5 $5 $7.5 $10 $12.5 $15 $17.5 General Fund General Fund Full Time Salaries/Wages 10110190-701101 $0 $2,600,000 $2,600,000 $2,195,000 Employee Benefits 10110190-701201 $0 $1,100,000 $1,100,000 $1,125,000 Other Professional Services 10110190-713004 $110,426 $112,400 $371,774 $212,400 Workers Compensation 10110190-714006 $600,000 $200,000 $200,000 $0 Memberships/Subscriptions 10110190-716000 $60,354 $75,000 $75,000 $98,586 County Wide Disaster Serv 10110190-719001 $65,455 $71,580 $71,580 $61,745 Land and Land Improvements 10180190-735001 $7,687,473 $0 $912,527 $0 Grants/Community Org 10110190-754002 $1,522,950 $379,750 $389,265 $347,750 Contingencies 10110190-756002 $180,529 $150,000 $550,564 $150,000 Total General Fund:$10,227,187 $4,688,730 $6,270,710 $4,190,481 Total General Fund:$10,227,187 $4,688,730 $6,270,710 $4,190,481 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 10110190 Account 713004 provides funding for federal and state lobbying efforts. Account 714006 provides funding for the City’s self-insured workers’ compensation program. This amount reflects the City’s program costs, including claims, third-party administration and excess loss coverage. The increase is due to higher claims and a need to bolster the fund balance in the Worker’s Compensation Fund. Account 716000 includes funds for memberships and subscriptions to the Ohio Municipal League and the National League of Cities and dues to the Mid-Ohio Regional Planning Commission, as well as any other citywide memberships or subscriptions. Account 719001 provides funding to the Franklin County Emergency Management Agency (FEMA) for the countywide disaster services program. Account 754002 provides funding for the Dublin Counseling Center (Syntero) and Aging-in-Place (AIP) (Syntero). Account 756002 provides funding for unanticipated expenditures that may occur throughout the year. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 13 Court Services | General Fund Lisa Wilson-Schoning Director of Court Services Court Services serves as the judicial branch of the City. Court Services is responsible for monitoring all court operations, including the collection of fines, preparing the court docket and processing all parking, traffic and criminal citations. As a sentencing alternative, adult probation, adult and juvenile diversion, adult and juvenile traffic diversion and Provide No Convictions programs are offered. Court Services is also responsible for implementing and operating the City's records management program, which includes both on-site and off-site central storage, destruction of records in accordance with the City of Dublin’s retention schedule and document imaging services. Personnel Data Position Title 2023 | Adopted 2024 | Adopted Director of Court Services (1)0.5 0.5 Diversion Officer 1 1 Court Clerk 1 1 Administrative Support II (2)0.75 0.75 Total 3.25 3.25 Notes and Adjustments: Court Services also performs the additional duties of Records Management to comply with conditions set forth in the Ohio Revised Code. Salaries, wages and benefits have been allocated to Court Services and Records Management for each position as follows: 1. Allocates 50% to the Court Services budget and 50% to the Records Management budget. 2. Allocates 75% to the Court Services budget and 25% to the Records Management budget. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 14 Court Services Expenditures by Expense Type | General Fund Budgeted and Historical Expenditures by Expense Type MillionsSupplies Contractual Services Personal Services FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $0.1 $0.2 $0.3 $0.4 $0.5 Expense Objects Personal Services Full Time Salaries/Wages 10110150-701101 $223,772 $213,835 $213,835 $221,230 Overtime Wages 10110150-701103 $742 $2,000 $1,200 $2,000 Employee Benefits 10110150-701201 $77,134 $103,280 $103,280 $72,080 Training/Travel 10110150-702000 $1,407 $2,000 $2,800 $0 Total Personal Services:$303,055 $321,115 $321,115 $295,310 Contractual Services Legal Services 10110150-713002 $8,229 $13,900 $23,379 $13,900 Other Professional Services 10110150-713004 $71,523 $91,500 $104,421 $90,000 Misc. Contract. Serv.10110150-713005 $5,840 $10,500 $10,500 $10,500 Training/Travel 10110150-713010 $0 $0 $0 $2,900 Communications 10110150-715001 $1,500 $3,000 $3,000 $0 Memberships/Subscriptions 10110150-716000 $710 $860 $895 $895 Total Contractual Services:$87,801 $119,760 $142,195 $118,195 Supplies Office Supplies 10110150-721001 $419 $1,600 $2,493 $1,600 Operating Supplies 10110150-721002 $0 $7,500 $12,500 $7,500 Total Supplies:$419 $9,100 $14,993 $9,100 Total Expense Objects:$391,275 $449,975 $478,303 $422,605 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 15 Budget Summary 10110150 Account 701101 provides funding for the staffing reflected under Personnel Data. Account 701103 provides funding for overtime due to court sessions held on Tuesday afternoons/evenings and special events. Account 713002 provides funding for services provided by the Delaware and Marysville prosecutor’s offices (new for 2022) and the Franklin County and Union County public defender’s offices. Account 713004 includes funding for prisoner boarding and medical services at the Franklin County Jail, the City’s share of the Franklin County Municipal Court’s operational costs, interpreter’s fees, domestic violence advocate fees and fees for use of a full-time magistrate. Account 713005 provides funding for witness fees and bank fees, including credit card processing fees. Account 713010 (previously 702000) provides funding for staff travel and training. Account 721002 provides funding for specific supplies that are necessary for court operations, such as court files, labels, citations (traffic/parking) and criminal complaint forms. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 16 Records Management | General Fund Lisa Wilson-Schoning Director of Court Services Records Management was established to maintain efficient methods for storage and retrieval of documents and to eliminate the unnecessary retention of obsolete records. As part of Records Management, a central storage facility was created to reduce the amount of prime office space being utilized for storage of active and inactive records. Operated by Court Services, the central storage facility allows for active and inactive records to be examined, archived and/or scheduled for destruction in accordance with the procedures established in the Ohio Revised Code and standards accepted by the City of Dublin Records Commission. Records Management also supervises document- imaging services. Personnel Data Position Title 2023 | Adopted 2024 | Adopted Director of Court Services (1)0.5 0.5 Administrative Support II (2)0.25 0.25 Total 0.75 0.75 Permanent Part-Time/Seasonal Staff Records Retention Technician 1 1 Total 1 1 Notes and Adjustments: Court Services also performs the additional duties of Records Management to comply with conditions set forth in the Ohio Revised Code. Salaries, wages and benefits have been allocated to Court Services and Records Management for each position as follows: 1. Allocates 50% to the Court Services budget and 50% to the Records Management budget. 2. Allocates 75% to the Court Services budget and 25% to the Records Management budget. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 17 Records Management Expenditures by Expense Type | General Fund Budgeted and Historical Expenditures by Expense Type MillionsSupplies Contractual Services Personal Services FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $0.05 $0.1 $0.15 $0.2 $0.25 Expense Objects Personal Services Full Time Salaries/Wages 10110160-701101 $108,903 $105,310 $105,310 $111,750 Overtime Wages 10110160-701103 $609 $500 $500 $500 Employee Benefits 10110160-701201 $34,773 $29,880 $29,880 $43,560 Total Personal Services:$144,285 $135,690 $135,690 $155,810 Contractual Services Other Professional Services 10110160-713004 $5,233 $25,000 $34,767 $25,000 Misc. Contract. Serv.10110160-713005 $8,053 $6,500 $10,102 $6,500 Memberships/Subscriptions 10110160-716000 $284 $300 $300 $300 Total Contractual Services:$13,571 $31,800 $45,169 $31,800 Supplies Office Supplies 10110160-721001 $1,211 $1,300 $1,366 $1,300 Equipment Maintenance 10110160-724003 $2,949 $3,500 $3,500 $3,500 Total Supplies:$4,160 $4,800 $4,866 $4,800 Total Expense Objects:$162,015 $172,290 $185,725 $192,410 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 18 Budget Summary 10110160 Account 701101 provides funding for staffing allocations as provided in the Notes and Adjustments section under Personnel Data. Account 713004 provides funding for the digital scanning of permanent records and frequently accessed records. Account 724003 provides funding for maintenance contracts for the records management software OPUS and two microfilm readers/printers. Account 713005 provides funding for off-site records storage of microfilm originals, historical paper documents and on-site records destruction. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 19 Mayor's Court Computer | Special Revenue Fund Lisa Wilson-Schoning Director of Court Services Ordinance 41-93 authorized the establishment of the Mayor's Court Computer Fund. Revenues in this fund are received from fees assessed in each case in accordance with Substitute Senate Bill 246. This fund is used by Court Services to pay for any operational costs and/or any subsequent updates for the computerization of the Court office. The City currently assesses a fee of eight dollars ($8.00) per case; however, Substitute Senate Bill 246 allows the fee to be set as high as ten dollars ($10.00). The fee will increased to $10 per case in 2024. Personnel Data There are no staff positions directly allocated to this budget. Oversight of the fund is by the Director of Court Services. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 20 Mayor's Court Computer Expenditures by Expense Type | Special Revenue Fund Budgeted and Historical Expenditures by Expense Type MillionsCapital Outlay Supplies FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $0.01 $0.02 $0.03 $0.04 Expense Objects Supplies Office Supplies 25210150-721001 $229 $0 $71 $0 Equipment Maintenance 25210150-724003 $3,600 $30,545 $30,945 $33,000 Total Supplies:$3,829 $30,545 $31,016 $33,000 Total Expense Objects:$3,829 $30,545 $31,016 $33,000 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 25210150 Account 724003 provides funding for LEADS (Law Enforcement Automated Data System) user fees. The Central Square computer maintenance has been moved to this account from the Inforamtion Technology budget. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 21 Legal Services | General Fund Frost Brown Todd, LLC Director of Law (Contractual) The Law Director provides legal representation to City Council, the City Manager, the administrative departments and various boards and commissions. The Law Director is appointed by the City Manager with the approval of City Council. Currently, this position is filled on a contractual basis. Periodically, other legal counsel is retained for specialized problems or legal work. The Law Director and the Law Director’s staff provide many services, including attending all designated public meetings and staff meetings; drafting ordinances, resolutions and legal memoranda; handling planning/zoning/land use matters, including attendance at all Planning and Zoning Commission meetings; leading the right-of-way acquisition process, including representing the City in any eminent domain litigation; representing the City in all administrative hearings and general litigation; drafting and negotiating contracts, including contracts for special events, such as St. Patrick’s Day, Fourth of July and the Dublin Irish Festival; prosecuting code enforcement violations; handling annexation matters; assisting staff in responding to public records requests; representing the City in labor and employment matters; representing the City in construction matters; drafting policies and assisting in drafting administrative orders; and advising City officials and employees on day-to-day matters. Prosecutorial services include prosecuting all cases in Dublin Mayor’s Court and Franklin County Municipal Court. The Law Department also works closely with various governmental entities, including the Franklin County Prosecutor’s Office, the State Auditor, the State Attorney General’s Office, the Ohio Department of Transportation and Franklin County Public Health. Personnel Data Position Title 2023 | Adopted 2024 | Adopted Director of Law (1)1 1 Assistant Director of Law (1)2 2 Total 3 3 Notes and Adjustments: 1. These positions are contracted and not considered employees of the City. Numerous associates within the firm of Frost Brown Todd, LLC, work under the direction of the Director of Law to provide legal counsel for the City. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 22 Legal Services Expenditures by Expense Type | General Fund Budgeted and Historical Expenditures by Expense Type MillionsContractual Services FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $0.5 $1 $1.5 $2 $2.5 Expense Objects Contractual Services Legal Services 10110140-713002 $1,011,574 $1,000,000 $1,087,063 $1,200,000 Other Legal Services 10110140-713003 $374,467 $575,000 $796,524 $785,000 Other Professional Services 10110140-713004 $236,046 $375,000 $530,477 $175,000 Total Contractual Services:$1,622,087 $1,950,000 $2,414,063 $2,160,000 Total Expense Objects:$1,622,087 $1,950,000 $2,414,063 $2,160,000 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 10110140 Account 713002 is used to pay for general services provided by the Director of Law, including Dublin Mayor’s Court. The budget is based on the contract authorized by City Council. Account 713003 provides funding for special legal services provided by the Director of Law (i.e. labor negotiations and telecommunications, roadway projects and litigation). Account 713004 includes funds for services related to economic development and other outside legal services as needed. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 23 Human Resources Jennifer Miglietti Director of Human Resources Human Resources is an engaged team of professionals who work in partnership with managers, their teams and individual employees to sustain a talented, diverse workforce, foster a culture of health, safety and productivity and provide innovative, collaborative business solutions that contribute to the strategic goals of the City. The Division of Human Resources provides leadership and direction to the organization in all functional areas of human resources management, including recruitment and selection; classification and compensation; performance management; wage and salary administration; benefits administration; labor/employee relations; policy analysis/development; talent development and training management; and organizational analysis/development. The Division of Human Resources also provides leadership and direction to the organization in risk management and occupational safety and health. Personnel Data Position Title 2023 | Adopted 2024 | Adopted Director of Human Resources 1 1 Human Resource Manager 1 1 Talent Development and Training Manager (2)1 0 Talent and Culture Programs Manager (2) 0 1 Human Resource Business Partner 3 3 Human Resources Coordinator 2 2 Safety Administrator/Risk Manager 1 1 Administrative Support II 1 1 Total 10 10 Part-Time/Seasonal Staff Intern/Seasonal (1)0.5 0.5 Total 0.5 0.5 Notes and Adjustments: 1. The Intern/Seasonal position is a part-year (six-month) position to assist with entry-level clerical work. 2. The Talent Development and Training Manager is retitled to Talent and Culture Programs Manager. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 24 Human Resources Expenditures by Expense Type | General Fund Budgeted and Historical Expenditures by Expense Type MillionsSupplies Other Charges and Expenditures Contractual Services Personal Services FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $0.5 $1 $1.5 $2 $2.5 Expense Objects Personal Services Full Time Salaries/Wages 10110120- 701101 $823,279 $782,705 $782,705 $814,050 Overtime Wages 10110120- 701103 $54 $500 $500 $500 Other Wages 10110120- 701104 $4,512 $6,000 $6,000 $6,000 Employee Benefits 10110120- 701201 $294,448 $285,500 $285,500 $287,355 Uniforms and Clothing 10110120- 701204 $3,975 $2,000 $2,229 $2,000 Employee Training and Developm 10110120- 701206 $129,902 $190,000 $238,527 $0 Tuition Reimbursement 10110120- 701207 $17,410 $25,000 $40,637 $25,000 Training/Travel 10110120- 702000 $11,650 $20,000 $26,430 $0 Meeting Expenses 10110120- 703100 $317 $1,200 $1,200 $0 Total Personal Services:$1,285,547 $1,312,905 $1,383,727 $1,134,905 Contractual Services Other Professional Services 10110120- 713004 $115,511 $139,740 $182,720 $239,739 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 25 Misc. Contract. Serv.10110120- 713005 $33,623 $48,870 $50,584 $32,000 Training/Travel 10110120- 713010 $0 $0 $0 $22,500 Employee Training and Developm 10110120- 713011 $0 $0 $0 $50,500 Insurance and Bonding 10110120- 714001 $587,743 $633,690 $647,093 $715,533 Insurance Claims Paid 10110120- 714009 $5,700 $8,000 $10,100 $10,000 Advertising 10110120- 715002 $11,654 $24,000 $30,000 $34,000 Printing and Reproductions 10110120- 715003 $348 $500 $3,152 $500 Memberships/Subscriptions 10110120- 716000 $5,325 $6,000 $7,391 $5,645 Total Contractual Services:$759,905 $860,800 $931,040 $1,110,417 Supplies Office Supplies 10110120- 721001 $5,451 $5,500 $9,515 $5,500 Meeting Expenses 10110120- 721006 $0 $0 $0 $1,200 Equipment Maintenance 10110120- 724003 $0 $180 $180 $0 Total Supplies:$5,451 $5,680 $9,695 $6,700 Other Charges and Expenditures Risk Mgt. /Safety Programs 10110120- 751005 $25,730 $32,325 $38,185 $16,475 Employee Awards Program 10110120- 751017 $46,377 $62,820 $121,533 $51,000 Total Other Charges and Expenditures:$72,106 $95,145 $159,718 $67,475 Total Expense Objects:$2,123,009 $2,274,530 $2,484,181 $2,319,497 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 26 Budget Summary 10110120 Account 701101 provides salary/wage funding for the staffing reflected under Personnel Data. Account 701103 provides overtime funding for the non-exempt staff reflected under Personnel Data. Account 701104 provides funding for the Intern/Seasonal position. Account 701201 provides funding for the benefits provided to the staff reflected under Personnel Data. Account 701204 provides funding for official City of Dublin apparel used for ceremonial observances and other City representational duties. In addition to the Human Resources staff identified under Personnel Data, each new City employee is provided an official City of Dublin shirt during onboarding with the exception of those who are provided City-funded uniforms (e.g., Maintenance Workers, Police Officers, Custodians, Recreation staff, etc.), which those employees are required to wear during work hours. The divisions responsible for providing employee uniforms budget those separately. Account 701207 provides funding for the organization-wide tuition reimbursement program. Account 713004 provides funding for various employment screening and assessment services (i.e., criminal record checks, driving record checks, sexual offender checks, drug tests, medical examinations and polygraphs and psychological evaluations for Police Officer candidates) and also provides funding to conduct periodic classification and/or compensation plan studies as required. Account 713005 includes funding for the City’s Employee Assistance Program (EAP) and the maintenance fees for the City’s online employment application program, Neogov. Account 713010 (previously 702000) provides funding for training seminars and conferences for Human Resources and Risk Management staff. Account 713011 (previously 701206) provides funding for City training and development. This training includes but is not limited to drug- free workplace training, staff technology development on administrative software programs, leader development training for supervisors and directors, executive leadership training and mentoring for the City Manager and directors, and specialized software training used to execute specific duties. Account 714001 provides funding for the City’s contribution to the Central Ohio Risk Management Association (CORMA) self-insured loss fund for stop-loss premiums, as well as for cyber coverage. Account 714009 provides funding for the payment of insurance claims. Account 715002 provides funding for recruitment announcements on various social media websites, in newspapers and in professional/trade journals and publications. Account 715003 provides funding for the various professional printing needs of the Human Resources division related to open enrollment and the various other Human Resources events conducted throughout the year. Account 716000 provides funding for Human Resources staff memberships to various professional organizations that provide ongoing human resources, risk management and safety related education and updates. Account 721001 provides funding for office supplies for the Human Resources division. Account 721006 (previously 703100) provides funding to provide logistical support for significant hiring, such as panel interviews, promotional and bargaining events. Account 751005 provides funding for employee safety programs, some of which are mandated by state safety regulations. Account 751017 funds the Employee Recognition and Appreciation Program to include longevity awards presented on milestone anniversaries, retirement awards and recognition events, as well as various employee appreciation breakfasts and luncheons. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 27 Communications & Marketing | General Fund Lindsay Weisenauer Director of Communications & Marketing Communications and Marketing serves as the full-service communications, marketing and creative agency for Dublin’s 25+ departments/divisions. Communications and Marketing provides communication counsel and strategies for citywide initiatives and events; promotes and enhances Dublin’s image through marketing, communications and community engagement; serves as the voice of Dublin by developing and delivering unified key messages; and manages overall brand alignment. Key stakeholders and target audiences include City Council, fellow employees, residents, corporate citizens, visitors, investors, influencers and the media. Communications and Marketing primary functions are communications, media relations, social/digital media, brand alignment, multi-media productions and public affairs and engagement with employees, residents, key stakeholders and other priority audiences. Personnel Data Position Title 2023 | Adopted 2024 | Adopted Director of Communications & Marketing (1)0 1 Director of Communications & Public Information (1)1 0 Deputy Director of Communications & Marketing (2)0 1 Public Affairs Officer (2)1 0 Public Information Officer 2 2 Multimedia Communications Strategist 1 1 Digital & Brand Manager 1 1 Digital & Graphic Designer 1 1 Administrative Support III 1 1 Total 8 8 Part-Time/Seasonal Staff Intern 2 2 Total 2 2 Notes & Adjustments: 1. The Director of Communications & Public Information is retitled to the Director of Communications & Marketing. 2. The Public Affairs Officer is reclassified to Deputy Director of Communications & Marketing. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 28 Communications & Marketing Expenditures by Expense Type | General Fund Budgeted and Historical Expenditures by Expense Type MillionsCapital Outlay Supplies Other Charges and Expenditures Contractual Services Personal Services FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $0.5 $1 $1.5 $2 $2.5 Expense Objects Personal Services Full Time Salaries/Wages 10110130- 701101 $670,548 $632,120 $632,120 $683,310 Overtime Wages 10110130- 701103 $3,416 $4,500 $3,065 $4,500 Other Wages 10110130- 701104 $22,501 $30,000 $32,365 $30,000 Employee Benefits 10110130- 701201 $320,296 $334,275 $334,275 $294,445 Uniforms and Clothing 10110130- 701204 $335 $800 $0 $0 Training/Travel 10110130- 702000 $9,533 $10,000 $16,875 $0 Meeting Expenses 10110130- 703100 $3,226 $2,000 $1,195 $0 Total Personal Services:$1,029,856 $1,013,695 $1,019,895 $1,012,255 Contractual Services Other Professional Services 10110130- 713004 $446,365 $521,850 $624,611 $578,840 Misc. Contract. Serv.10110130- 713005 $38,157 $19,300 $31,500 $29,260 Training/Travel 10110130- 713010 $0 $0 $0 $15,000 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 29 Communications 10110130- 715001 $99 $500 $500 $0 Advertising 10110130- 715002 $86,244 $85,000 $118,040 $85,000 Printing and Reproductions 10110130- 715003 $6,661 $10,000 $27,933 $0 Memberships/Subscriptions 10110130- 716000 $4,637 $6,000 $6,000 $6,235 Total Contractual Services:$582,163 $642,650 $808,584 $714,335 Supplies Office Supplies 10110130- 721001 $2,814 $1,950 $2,020 $1,950 Operating Supplies 10110130- 721002 $549 $1,000 $1,000 $1,000 Meeting Expenses 10110130- 721006 $0 $0 $0 $2,000 Equipment Maintenance 10110130- 724003 $2,030 $500 $500 $500 Total Supplies:$5,393 $3,450 $3,520 $5,450 Capital Outlay Tools 10110130- 734002 $1,644 $2,500 $2,500 $1,000 Total Capital Outlay:$1,644 $2,500 $2,500 $1,000 Other Charges and Expenditures Special Projects/Programs 10110130- 751003 $360,597 $375,120 $354,541 $367,800 Promotional Programs 10110130- 751012 $7,880 $9,500 $9,500 $10,500 Total Other Charges and Expenditures:$368,477 $384,620 $364,041 $378,300 Total Expense Objects:$1,987,535 $2,046,915 $2,198,540 $2,111,340 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 30 Budget Summary 10110130 Account 701101 provides funding for staffing reflected under Personnel Data. Account 701103 provides funding for overtime for events, meetings and special projects. Account 701104 provides funding for intern wages. Account 701201 provides funding for employee benefits. Account 713004 includes funding for digital content management, photography, videography, digital design, Dublin Life magazine pages and special inserts and other professional services support. Account 713005 includes funding for video/photo/web hosting, eNews hosting, webpage enhancements, web security, licensing, media analytics and measurements. Account 713010 (previously 702000) provides funding for staff professional development. Account 715001 provides funding for courier services. Account 715002 provides funding for citywide, local and national marketing and advertising through traditional, digital and social media. Account 715003 provides funding for printing, marketing materials, postcards and brochures. Account 716000 provides funding for professional association memberships, newspapers, AP Stylebook and award entries. Account 721001 provides funding for office supplies. Account 721002 provides funding for operating supplies. Account 721006 (previously 703100) provides funding for professional association meetings, business engagement meetings and City employee engagement communication meetings. Account 724003 provides funding for equipment maintenance. Account 734002 provides funding for video and camera equipment and accessories. Account 751003 includes funding for the State of the City address and reception, team building, Legends Championship Luncheon, Memorial Tournament activities including hospitality villa, catering, badge package, media promotions and Memorial Tournament banners. Account 751012 includes funding for promotional items, City of Dublin merchandise and Safe Ride Programs. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 31 Economic Development | General Fund Jeremiah Gracia Director of Economic Development The Division of Economic Development is responsible for developing and administering the City's Economic Development Strategic Plan and key components of the City’s economic development program in support of Council’s goals. They include business retention, expansion, attraction and creation; workforce development; entrepreneurship; and marketing and advocacy. Key project areas include the West Innovation District, Dublin Corporate Area, Bridge Street District, 100-gig Dublink Broadband deployment and the Beta District/U.S. 33 Smart Mobility Corridor. Additionally, economic development efforts will continue to include active engagement with Dublin-based businesses and various private and public organizations/agencies involved in local, regional and statewide economic development; the integration of local economic development objectives with broader community planning policies and goals; proactively engaging the development/real estate community; maintaining involvement with community organizations and partners, such as Dublin City Schools and Ohio University; administering the City's incentive programs; and serving as a local business liaison to assist with development issues. Personnel Data Position Title 2023 | Adopted 2024 | Adopted Director of Economic Development 1 1 Economic Development Administrator 3 3 Total 4 4 Part-Time/Seasonal Staff Intern 1 1 Total 1 1 City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 32 Economic Development Expenditures by Expense Type | General Fund Budgeted and Historical Expenditures by Expense Type MillionsCapital Outlay Supplies Personal Services Contractual Services Other Charges and Expenditures FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $1 $2 $3 $4 Expense Objects Personal Services Full Time Salaries/Wages 10110740- 701101 $253,980 $314,445 $314,445 $337,280 Overtime Wages 10110740- 701103 $0 $1,000 $1,000 $0 Other Wages 10110740- 701104 $1,174 $10,000 $10,000 $28,392 Employee Benefits 10110740- 701201 $115,108 $176,530 $176,530 $178,425 Training/Travel 10110740- 702000 $10,031 $28,500 $29,099 $0 Meeting Expenses 10110740- 703100 $341 $5,000 $5,000 $0 Total Personal Services:$380,633 $535,475 $536,074 $544,097 Contractual Services Other Professional Services 10110740- 713004 $442,558 $398,000 $595,610 $437,000 Training/Travel 10110740- 713010 $0 $0 $0 $34,800 Advertising 10110740- 715002 $108,133 $200,500 $216,054 $205,500 Printing and Reproductions 10110740- 715003 $0 $1,500 $6,500 $6,000 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 33 Memberships/Subscriptions 10110740- 716000 $40,377 $52,820 $56,320 $59,820 Total Contractual Services:$591,067 $652,820 $874,484 $743,120 Supplies Office Supplies 10110740- 721001 $999 $2,000 $2,299 $2,000 Meeting Expenses 10110740- 721006 $0 $0 $0 $10,000 Total Supplies:$999 $2,000 $2,299 $12,000 Other Charges and Expenditures Economic Development 10110740- 751009 $200,807 $300,000 $408,445 $302,000 Economic Dev Incentives 10110740- 751010 $1,777,663 $1,402,800 $1,602,800 $900,000 Grants/Community Org 10110740- 754002 $0 $100,000 $100,000 $100,000 Total Other Charges and Expenditures:$1,978,470 $1,802,800 $2,111,245 $1,302,000 Total Expense Objects:$2,951,169 $2,993,095 $3,524,102 $2,601,217 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 10110740 Account 701101 provides funding for staffing reflected in the Personnel Data. Account 713004 includes funding for consultation related to economic development, including workforce programs, real estate reports and Dublin Entrepreneurial Center (DEC) sponsorship. Funding has also been provided for data analytic work. Account 713010 (previously 702000) includes travel/training and certification courses for staff. Account 715002 includes funds for marketing and advertising focused on targeted industry attraction efforts, including print and digital web advertising. Account 715003 funds printed projects, site selection and program materials, business retention packets and event invitations for economic development. Account 716000 provides funding for such memberships as the Mid-Ohio Development Exchange (MODE)/OneColumbus partnership, IEDC, OEDA, CDFA, Catylist real estate database, international business groups, etc. Account 721006 provides funding for group meetings sponsored by the City, such as Japan America Society of Central Ohio (JASCO) and the Asian Indian American Business Group (AIABG). Account 751009 includes funds to support economic development programs, including business appreciation, business attraction, retention and expansion; as well as regional and joint partnerships, including Rev1 Ventures, Dublin 100-gig Transport program and a Downtown Dublin parking agreement with Dublin Community Church. Account 751010 reflects funding for active economic development incentives in accordance with executed Economic Development Agreements (EDA). City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 34 Innovation & Analytics | General Fund Brandon Brown Director of Innovation & Analytics The Division of Innovation & Analytics was created to bring emphasis to the importance of aligning the organization's activities and services with Dublin's Strategic Framework and organizational goals; measuring the success of those activities and services; and continually improving those activities and services. The division supports all other City divisions, thus having a direct and indirect effect on outcomes. The division houses the Data Analytics, GIS, PIEworks (internal process improvement and innovation team) and Performance Management functions. This unique combination of disciplines allows the division to bring the City new capabilities in terms of solution implementation and support; analysis; data connectivity, discovery and usage; process improvement; facilitation; research and development; citizen and employee engagement; decision support; and storytelling. The division is not only future-looking and project-oriented but is also the core technical support team for GIS software, data visualization software, Cityworks work order software, GoDublin, strategy and performance management software and other solutions. Personnel Data Position Title 2023 | Adopted 2024 | Adopted Director of Innovation & Technology (1)0 0.5 Director of Innovation & Analytics 1 1 Data and Analytics Manager 1 1 Senior Data Analyst 2 2 Project Leader (2)0 1 Total 4 5.5 Part-Time/Seasonal Staff Intern 1 1 Total 1 1 Notes and Adjustments: 1. The Director of Administrative Services position was reclassified to the Director of Innovation and Technology and budgeted 50% to the Division of Information Technology and 50% to the Division of Innovation and Analytics. 2. The Project Leader position was moved from Information Technology to Innovation and Analytics. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 35 Innovation & Analytics Expenditures by Expense Type | General Fund Budgeted and Historical Expenditures by Expense Type MillionsOther Charges and Expenditures Supplies Contractual Services Personal Services FY2021FY2022FY2023FY2024$0 $0.25 $0.5 $0.75 $1 $1.25 $1.5 Expense Objects Personal Services Full Time Salaries/Wages 10110170- 701101 $403,073 $383,840 $383,840 $574,510 Other Wages 10110170- 701104 $15 $15,000 $15,731 $28,860 Employee Benefits 10110170- 701201 $169,635 $168,040 $168,040 $226,700 Uniforms and Clothing 10110170- 701204 $219 $500 $0 $0 Training/Travel 10110170- 702000 $21,342 $20,000 $20,295 $0 Meeting Expenses 10110170- 703100 $159 $200 $0 $0 Total Personal Services:$594,442 $587,580 $587,906 $830,070 Contractual Services Other Professional Services 10110170- 713004 $118,692 $179,600 $206,001 $220,200 Misc. Contract. Serv.10110170- 713005 $16,338 $0 $50,000 $0 Training/Travel 10110170- 713010 $0 $0 $0 $28,000 Memberships/Subscriptions 10110170- 716000 $1,309 $1,500 $1,500 $1,500 Total Contractual Services:$136,338 $181,100 $257,501 $249,700 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 36 Supplies Office Supplies 10110170- 721001 $1,350 $350 $350 $350 Operating Supplies 10110170- 721002 $451 $4,000 $4,000 $4,000 Meeting Expenses 10110170- 721006 $0 $0 $0 $200 Equipment Maintenance 10110170- 724003 $139,827 $191,025 $191,025 $210,700 Total Supplies:$141,627 $195,375 $195,375 $215,250 Other Charges and Expenditures Special Projects/Programs 10110170- 751003 $2,677 $9,500 $9,500 $4,000 Total Other Charges and Expenditures:$2,677 $9,500 $9,500 $4,000 Total Expense Objects:$875,085 $973,555 $1,050,282 $1,299,020 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 10110170 Account 701101 provides funding for the staffing reflected in the Personnel Data. Account 701103 provides funding for overtime wages for non-exempt staff. Account 701104 provides funding for part-time/seasonal staff. Account 713004 provides funding for professional consulting services for operational and project delivery-based activities. This can include specific expertise or knowledge, which may be necessary to ensure success and/or to augment the staffing assignments due to workload. Account 713005 provides funding for contractual services, which include cloud-based (hosted) or managed solutions for the City, such as the City’s data platform, GoDublin, facilitation tools and project management tools. Account 713010 (previously 702000) provides funding for trade conferences, training and development, travel and professional certifications. Account 716000 provides funding for Lean Six Sigma, GISP and other memberships and certifications. Account 721001 provides funding for office supplies. Account 721002 provides funding for general operating supplies, such as plotter paper and printing consumables. Account 721006 (previously 703100) provides funding for meeting and facilitation expenses. Account 724003 provides funding for City hardware and software maintenance costs and applications supporting business operations, such as Esri GIS software and platform, Data visualization software, performance/strategic management software, and the Cityworks work order system. Account 751003 provides funding for special projects, programs, research and development, such as PIEworks and other technology experiments. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 37 Information Technology | General Fund Brandon Brown Interim Director of Information Technology The management of the City's information technology operations is the responsibility of the Division of Information Technology. This involves planning, maintaining, developing, overseeing and managing the City's information security program, the City-owned DubLink fiber optic network (in partnership with the Department of Community Development), local area and wide area networks, wireless access, all computers, multi-function printers, servers, data storage, the City telephone system, mobile devices and any other technology infrastructure-related issues. The Division of Information Technology also delivers program and project management services for the organization, which includes but is not limited to DubLink fiber operations and the Enterprise Resource Planning (ERP) systems. The Division of Information Technology also provides client endpoint services and strives to enhance and promote the utilization of technology so that City operations realize the benefits of using technology as a tool. Technology is analyzed to determine how it could affect improvements in productivity and decision-making and improve staff and citizen safety and enhancements to City services. Personnel Data Position Title 2023 | Adopted 2024 | Adopted Director of Innovation & Technology (3)0 0.5 Director of Information Technology 1 1 Information Security Administrator 1 1 IT Business Relationship Manager 1 1 Solutions Analyst (2)0 1 Information Security Analyst (2)1 0 Systems and Applications Administrator 1 1 Senior Support Services Analyst 1 1 Support Services Analyst 2 2 Network Operations Manager 1 1 Information Technology Project Leader (1)2 0 Project Leader (1)0 1 Network Engineer 2 2 Administrative Support III 1 1 Total 14 13.5 Part-Time/Seasonal Staff Intern (Support Services)2 2 Total 2 2 Notes and Adjustments: 1. The Information Technology Project Leader positions were retitled to Project Leader in Information Technology and the second position was moved to Innovation and Analytics. 2. Information Security Analyst retitled to Solutions Analyst. 3. The Director of Administrative Services position was reclassified to the Director of Innovation and Technology and budgeted 50% to the Division of Information Technology and 50% to the Division of Innovation and Analytics. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 38 Information Technology Expenditures by Expense Type | General Fund Budgeted and Historical Expenditures by Expense Type MillionsContractual Services Personal Services Supplies FY2021FY2022FY2023FY2024$0 $1 $2 $3 $4 $5 $6 $7 Expense Objects Personal Services Full Time Salaries/Wages 10110180-701101 $1,092,709 $1,162,795 $1,162,795 $1,163,630 Overtime Wages 10110180-701103 $23,730 $30,000 $30,000 $30,000 Other Wages 10110180-701104 $10,710 $17,000 $17,000 $28,860 Employee Benefits 10110180-701201 $472,614 $539,235 $539,235 $584,005 Training/Travel 10110180-702000 $64,388 $20,000 $20,553 $0 Meeting Expenses 10110180-703100 $0 $300 $0 $0 Total Personal Services:$1,664,151 $1,769,330 $1,769,583 $1,806,495 Contractual Services Other Professional Services 10110180-713004 $119,186 $250,500 $409,898 $255,000 Misc. Contract. Serv.10110180-713005 $1,319,751 $1,529,885 $1,560,170 $0 Training/Travel 10110180-713010 $0 $0 $0 $40,200 Communications 10110180-715001 $480,597 $556,200 $637,723 $556,200 Memberships/Subscriptions 10110180-716000 $400 $1,500 $1,500 $1,420 Rents and Leases 10110180-717001 $14,930 $57,000 $57,000 $57,000 Total Contractual Services:$1,934,863 $2,395,085 $2,666,291 $909,820 Supplies Office Supplies 10110180-721001 $911 $1,950 $2,339 $1,950 Operating Supplies 10110180-721002 $89,719 $62,000 $84,461 $62,000 Meeting Expenses 10110180-721006 $0 $0 $0 $300 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 39 Equipment Maintenance 10110180-724003 $1,070,907 $1,100,000 $1,170,377 $3,323,363 Total Supplies:$1,161,537 $1,163,950 $1,257,177 $3,387,613 Total Expense Objects:$4,760,550 $5,328,365 $5,693,051 $6,103,928 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 10110180 Account 701101 provides funding for the staffing reflected under Personnel Data. Account 701104 provides funding for part-time/seasonal staff. Account 713004 provides funding for professional consulting services for operational and project delivery-based activities. This can include specific expertise or knowledge, which may be necessary to ensure success and/or to augment the staffing assignments due to workload. Account 713010 (previously 702000) provides funding for trade conferences, training and development, travel and professional certifications for Information Technology staff. Account 715001 provides funding for City telecommunications. This includes office and mobile phone usage, internet service providers, GPS/AVL, pay phones and eFax solutions. Account 716000 provides funding for professional memberships and access to technical manuals, subscriptions and other miscellaneous organization fees. Account 717001 provides funding for the rent and leasing of office space at Metro Data Center and for the dark fiber lease and City copier lease. Account 721001 provides funding for office supplies. Account 721002 provides funding for general operating supplies, such as DEX Imagining, plotter paper and repair services, printing consumables, ID badges and other peripheral hardware. Account 721006 (previously 703100) provides funding for meeting expenses. Account 724003 provides funding for City hardware and software maintenance costs for network infrastructure and applications supporting business operations, as well as funding for contractual services, which include cloud-based (hosted) or managed solutions for the City. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 40 Police Services Justin Páez Chief of Police The Dublin Police Department, under the direction of the Chief of Police, comprises three work units: Operations, Support Services and Community and Professional Services (previously Technical Services). Long-term priorities for the Police Department: 1. Maintain low levels of crime and disorder in the community 2. Maintain overall public safety in the community 3. Maintain a strong focus on recruiting, retaining and properly deploying personnel 4. Continue to be responsive to the needs, wants and expectations of the community 5. Continue to provide high-level and high-quality service 6. Maintain a strong focus on building partnerships and managing service consolidation to maintain and maximize high levels of service to the community 7. Prepare to respond and successfully resolve critical incidents, major crimes and other issues of community concern Operations consist of the following sections: Patrol, accident investigation, court liaison, Field Training Officer (FTO) program and bicycle patrols. Support Services includes the Detective Section, internal affairs, the Community Education Unit, Community Impact Unit and special event security planning. Community and Professional Services includes the Northwest Regional Emergency Communications Center (NRECC), the consolidated communications center; records section; property room operations; accreditation and training; technology support; accounting/budgeting and clerical support. The responsibility of all three bureaus is to support, either directly or indirectly, the department’s mission, goals and long-term priorities. Dublin Police Department Mission Statement: Dublin Police Department employees are committed to protecting life, liberty and property. We will provide the highest level of service and work in partnership with our community to ensure public safety by focusing on the following core principles: Vigilant, ethical and impartial enforcement of law Critical incident preparedness and response Crime prevention, reduction and deterrence Improvement of traffic safety We will remain dedicated to service and committed to excellence, focusing on the following core values: Professionalism: We are members of an exceptional and highly trained law enforcement organization. Our conduct and demeanor adhere to the highest standards of personal and organizational excellence. Integrity: We hold ourselves accountable to the highest level of honesty, truthfulness and ethical conduct. Respect: We ensure that all people are treated with equality, dignity and courtesy. Commitment: We are dedicated to our profession, our community, our agency and our mission. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 41 Personnel Data Position Title 2023 | Adopted 2024 | Adopted Chief of Police 1 1 Deputy Chief of Police (3)2 3 Technical Services Bureau Commander (3)1 0 Police Sergeant 6 6 Police Corporal 9 9 Police Officer (1)56 58 Emergency Mgmt Coordinator/Law Enforcement Planner 1 1 Public Safety Intelligence Analyst 1 1 Civilian Accreditation Manager (4)1 0 Professional Standards Manager (4)0 1 Administrative Support III 1 1 Records Supervisor 1 1 Records Technician II 3 3 Records Technician I 1 1 Police Property Technician 1 1 Communications Technician (2)29 29 Communications Supervisor 6 6 Communications Manager 3 3 Operations Manager 1 1 CAD Manager 1 1 Communications Systems Specialist 1 1 Total 126 128 Notes and Adjustments: 1. For 2024, police request authorization for two (2) additional sworn officer positions (above authorized staffing) temporarily to allow for future anticipated retirements. Due to the amount of time required (typically 18 months) to replace a retiring officer with a newly hired, certified, and field trained officer, this practice of hiring ahead has proven crucial to us maintaining staffing levels. Hiring will be contingent on available funding. 2. For 2024, police request authorization for two (2) additional communication technician positions (above authorized staffing) temporarily to allow for future anticipated retirements. Due to the amount of time required (typically 6 months) to replace a technician with a newly hired, certified, and trained technician, this practice of hiring ahead has proven crucial to us maintaining staffing levels. Hiring will be contingent on available funding. 3. The Technical Services Bureau Commander is retitled to a Deputy Chief of Police position. 4. The Civilian Accreditation Manager is now retitled to the Professional Standards Manager. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 42 Budgeted Expenditures by Function - Police Services | Special Revenue Fund Budgeted and Historical Expenditures by Function MillionsCommunications Finance Miscellaneous Operations Communications Operations FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $5 $10 $15 $20 Expenditures General Government Finance Miscellaneous County Auditor Deductions 24110290-711001 $8,695 $10,000 $10,000 $10,000 Total Finance Miscellaneous:$8,695 $10,000 $10,000 $10,000 Total General Government:$8,695 $10,000 $10,000 $10,000 Security of Persons/Property Operations Full Time Salaries/Wages 24150820-701101 $3,350,069 $8,063,345 $8,063,345 $8,580,360 Overtime Wages 24150820-701103 $513,605 $492,000 $492,000 $474,000 Employee Benefits 24150820-701201 $4,036,057 $3,953,825 $3,953,825 $4,021,360 Uniforms and Clothing 24150820-701204 $178,750 $155,000 $187,670 $159,500 Training/Travel 24150820-702000 $70,440 $98,500 $122,560 $0 Meeting Expenses 24150820-703100 $11,084 $11,000 $12,067 $0 Personnel Planning 24150820-703200 $0 $15,000 $15,000 $15,000 Other Professional Services 24150820-713004 $5,104 $9,500 $115,843 $9,500 Misc. Contract. Serv.24150820-713005 $132,650 $162,650 $177,568 $202,450 Training/Travel 24150820-713010 $0 $0 $0 $129,000 Communications 24150820-715001 $4,901 $15,000 $17,129 $3,000 Memberships/Subscriptions 24150820-716000 $31,564 $41,020 $46,390 $41,020 Rents and Leases 24150820-717001 $4,634 $5,500 $7,022 $0 Office Supplies 24150820-721001 $15,517 $17,500 $18,123 $17,500 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 43 Operating Supplies 24150820-721002 $69,932 $92,900 $134,776 $99,400 Meeting Expenses 24150820-721006 $0 $0 $0 $15,500 Equipment Maintenance 24150820-724003 $48,315 $78,500 $80,852 $77,000 DARE Program 24150820-751006 $3,958 $5,000 $5,000 $5,000 Refunds 24150820-755000 $0 $500 $500 $500 Total Operations:$8,476,582 $13,216,740 $13,449,672 $13,850,090 Communications Full Time Salaries/Wages 24150841-701101 $2,801,576 $2,974,275 $2,864,275 $2,990,360 Overtime Wages 24150841-701103 $273,779 $150,000 $345,000 $200,000 Employee Benefits 24150841-701201 $1,173,702 $1,361,610 $1,276,610 $1,379,895 Uniforms and Clothing 24150841-701204 $5,782 $10,000 $11,632 $15,000 Training/Travel 24150841-702000 $23,624 $36,000 $38,829 $0 Training/Travel 24150841-713010 $0 $0 $0 $36,000 Communications 24150841-715001 $4,250 $4,000 $4,000 $4,000 Memberships/Subscriptions 24150841-716000 $51,245 $43,000 $43,294 $50,500 Office Supplies 24150841-721001 $2,155 $5,000 $6,319 $11,000 Operating Supplies 24150841-721002 $113 $2,000 $2,000 $2,000 Equipment Maintenance 24150841-724003 $97,137 $104,000 $110,560 $129,006 Total Communications:$4,433,361 $4,689,885 $4,702,518 $4,817,761 Total Security of Persons/Property:$12,909,944 $17,906,625 $18,152,189 $18,667,851 Capital Outlay Operations Furniture/Equipment 24180820-731000 $2,404 $19,125 $31,923 $14,800 Total Operations:$2,404 $19,125 $31,923 $14,800 Communications Furniture/Equipment 24180841-731000 $572 $2,000 $2,000 $2,000 Total Communications:$572 $2,000 $2,000 $2,000 Total Capital Outlay:$2,976 $21,125 $33,923 $16,800 Total Expenditures:$12,921,615 $17,937,750 $18,196,112 $18,694,651 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 44 Budget Summary Police: 24150820 Account 701101 provides funding for the staffing reflected in the Personnel Data and the Notes and Adjustments (excluding Communications Technicians, Communication Supervisors and a Communications Manager). Account 701103 provides funding for overtime for authorized sworn personnel and for support services for City special events. Account 701204 provides funding for uniform allowances and dry cleaning as provided for in the negotiated FOP contract; it also includes funds for uniform replacements, uniforms for new personnel, replacement ballistic vests/helmets and first responder kits, and uniform needed for the detectives. Reductions for 2020 include a decrease in First Responder’s Kits, dry cleaning, and uniform replacement. Account 713004 provides funding for hospitalization/medical expenses for arrestees; lab fees/physicals/handwriting analysis and medication drop off disposals. Account 713005 provides funding for services pertaining to the K-9 and other miscellaneous contractual services (car washes, towing, LEADS online, magnetometer costs for Court and City Council meetings). Account 713010 (previously 702000) includes funding for career development, mandatory and optional training, and advanced training opportunities for police personnel. Account 715001 provides funding for walkie/mobile parts and accessories and COIRS annual fees. Account 716000 includes funds for various professional memberships/subscriptions for law enforcement personnel. Account 721001 includes funding for equipment, ammunition, jail supplies, range supplies, canine food and supplies, and other miscellaneous operating supplies that are needed. Account 721006 (previously 703100) includes funds for awards presentation expenses, team meetings, CALEA meeting expenses, recruitment, as well as funds for a citizen police academy. Account 724003 provides funding for maintenance agreements for all departmental equipment, including but not limited to the radio system radios and consoles in the Communication Center, radar and laser repair, and cruiser video system maintenance and repair. Account 751006 includes funding for all Drug Abuse Prevention Programs (previously known as DARE) related supplies and activities. 24180820 Account 731000 includes funding for replacement gas masks and canisters. This account also provides funding for crash data upgrades/cables and GPS updates. Finance: 24110290 Account 711001 provides for fees paid to the County Auditors for real estate tax apportionment to the Safety Fund. Communications (Dispatch): 24150841 Account 701101 provides funding for the staffing reflected in the Personnel Data and the Notes and Adjustments for Communications Technicians, Communication Supervisors and a Communications Manager only. Account 701103 provides funding for overtime for communications staff. Account 701204 provides funding for uniforms as provided for in the negotiated contract and also includes funds for uniform replacements and uniforms for new personnel. Account 713010 (previously 702000) includes funding for career development and training. Account 724003 provides for funding for CAD multi-jurisdictional maintenance, LEADS service agreement, E911 PSAP equipment maintenance, PulsePoint, FATPOT, WestNet and console raised floor cleaning. Account 716000 provides funding for professional memberships, language line subscription, MTUG Membership and Smart911/RapidSOS subscription. Account 721001 includes funding for miscellaneous office supplies and public education supplies. Account 721002 includes funding for miscellaneous operating supplies that are needed. 24180841 Account 731000 includes funding for IDT Response Equipment. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 45 Enforcement and Education | Special Revenue Fund Justin Páez Chief of Police Ordinance 96-90 authorized the establishment of the Enforcement and Education Fund. Revenues in this fund are derived from fines received in accordance with §4511.99 of the Ohio Revised Code. This fund is to be used by the Dublin Police Department to pay those costs it incurs in enforcing §4511.19 of the Ohio Revised Code in educating the public of laws governing the operation of a motor vehicle while under the influence of alcohol, the dangers of operating a motor vehicle while under the influence of alcohol and other information relating to the operating of a motor vehicle and the consumption of alcoholic beverages. Personnel Data There are no personnel directly allocated to Enforcement and Education. Oversight of this Fund is by the Chief of Police. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 46 Enforcement and Education Expenditures by Expense Type | Special Revenue Fund Budgeted and Historical Expenditures by Expense Type MillionsCapital Outlay Personal Services FY2018FY2019FY2023FY2024$0 $0.0025 $0.005 $0.0075 $0.01 $0.0125 $0.015 Expense Objects Personal Services Overtime Wages 25150800-701103 $0 $2,000 $2,000 $2,000 Employee Benefits 25150800-701201 $0 $280 $280 $0 Total Personal Services:$0 $2,280 $2,280 $2,000 Total Expense Objects:$0 $2,280 $2,280 $2,000 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 25150800 Accounts 701103 and 701201 provide funds for overtime for personnel to conduct "operating vehicle impaired" (OVI) enforcement. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 47 Finance Matthew Stiffler Chief Financial Officer/Director of Finance The Chief Financial Officer (CFO)/Director of Finance assists the City Manager in the preparation and administration of the operating budget, the capital improvements program, and is responsible for the administration of the City’s debt and the various economic development and tax increment financing agreements. Responsibilities also include maintaining the financial records of the City, such as recording all receipts and expenditures, processing the City's payroll, maintaining capital asset records, internally examining and auditing accounts of the various departments and preparation of the City's Annual Comprehensive Financial Report. The CFO/Director of Finance also has administrative authority over finance and taxation operations. Departmental budget information can be found on the individual fund pages. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 48 Finance | General Fund Matthew Stiffler Chief Financial Officer/Director of Finance The Chief Financial Officer (CFO)/Director of Finance assists the City Manager in the preparation and administration of the operating budget, the capital improvements program, and is responsible for the administration of the City’s debt and the various economic development and tax increment financing agreements. Responsibilities also include maintaining the financial records of the City, such as recording all receipts and expenditures, processing the City's payroll, maintaining capital asset records, internally examining and auditing accounts of the various departments and preparation of the City's Annual Comprehensive Financial Report. The CFO/Director of Finance also has administrative authority over finance and taxation operations. Personnel Data Position Title 2023 | Adopted 2024 | Adopted Chief Financial Officer/Director of Finance 1 1 Director of Finance Operations 1 1 Chief Accountant (1)1 0 Accounting Manager (1)0 1 Budget Manager 1 1 Financial Analyst 1 1 Payroll Specialist 2 2 Accountant 1 1 Senior Accounting Specialist 2 2 Procurement and Contract Coordinator 1 1 Accounting Specialist 2 2 Total 13 13 Notes and Adjustments: 1. The Chief Accountant is retitled to the Accounting Manager. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 49 Finance Expenditures by Expense Type | General Fund Budgeted and Historical Expenditures by Expense Type MillionsSupplies Contractual Services Personal Services FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $0.5 $1 $1.5 $2 $2.5 Expense Objects Personal Services Full Time Salaries/Wages 10110210-701101 $1,044,205 $1,034,750 $1,034,050 $1,056,375 Overtime Wages 10110210-701103 $5,050 $4,500 $5,200 $6,000 Employee Benefits 10110210-701201 $417,356 $468,715 $468,715 $491,465 Training/Travel 10110210-702000 $9,665 $15,000 $22,278 $0 Total Personal Services:$1,476,276 $1,522,965 $1,530,243 $1,553,840 Contractual Services Accounting/Auditing Services 10110210-713001 $1,435 $16,500 $28,250 $600 Other Professional Services 10110210-713004 $22,903 $5,550 $35,147 $6,300 Misc. Contract. Serv.10110210-713005 $136,560 $158,000 $198,875 $175,000 Training/Travel 10110210-713010 $0 $0 $0 $24,750 Communications 10110210-715001 $17,703 $33,200 $37,816 $60,200 Advertising 10110210-715002 $7,484 $5,000 $5,434 $5,000 Printing and Reproductions 10110210-715003 $5,147 $7,500 $4,811 $1,000 Memberships/Subscriptions 10110210-716000 $3,076 $3,600 $6,589 $7,130 Rents and Leases 10110210-717001 $12,738 $19,555 $21,503 $33,000 Total Contractual Services:$207,045 $248,905 $338,425 $312,980 Supplies Office Supplies 10110210-721001 $14,316 $16,250 $17,212 $16,000 Operating Supplies 10110210-721002 $2,782 $3,000 $4,957 $5,450 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 50 Coffee/Misc. Supplies 10110210-721003 $20,962 $22,000 $22,398 $23,000 Equipment Maintenance 10110210-724003 $1,377 $1,000 $1,000 $100 Total Supplies:$39,437 $42,250 $45,567 $44,550 Total Expense Objects:$1,722,757 $1,814,120 $1,914,234 $1,911,370 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 10110210 Account 701101 provides funding for the staffing reflected under Personnel Data. Account 713001 provides funding for the Government Finance Officers Association (GFOA) budget award application and Comprehensive Annual Financial Report filing fees. Account 713004 provides funding for legal fees and cost disclosure filing fees. Account 713005 funds continuing consultation for the annual update of the Cost of Services Study and upgrades to the software used to complete the study. It also provides funding for custodial fees related to investment accounts, other banking fees, fees associated with the City’s purchasing card program, contractual service related to assistance in preparation of the City’s financial statements, as well as funding for the fees related to fixed assets sold on GovDeals, an online auction provider. Account 713010 (previously 702000) provides funding for online training for staff as well as conferences and other technical education courses that may be required to hold accounting certifications. Account 715001 provides funding for postage expenses for City Hall. Account 715002 provides funding for bid notices/legal advertisements for public improvement and construction projects; greater use of the City’s website as well as use of alternative advertising venues have reduced this cost. Account 715003 provides funding for the printing of the City’s Annual Operating Budget, Five-Year Capital Improvement Program, the Cost of Services Study document and the Comprehensive Annual Financial Report. The number of hard copy documents produced continues to be reduced due to an increase in requests for electronic versions and digital budget books, as well as the availability of posting documents on the City’s website. Account 716000 provides funding for memberships in professional associations, including the Municipal Finance Officers Association (MFOA), the Government Finance Officers Association (GFOA), the Association of Government Accountants (AGA) and the Ohio Society of CPAs. Account 717001 includes funding for rental of the City Hall postage machine and water coolers. Account 721001 provides funding for copy paper for City Hall, blank check stock and W-2 forms, payroll direct deposit paper, funding for letterhead stationery/envelopes, business cards, note cards and folders for City usage. Account 721002 provides funding for postage supplies, courier services and other miscellaneous office supplies. Account 721003 provides funding for City purchase of tea, coffee and related supplies in order to make those beverages available to staff and visitors during meetings held in City buildings. Account 724003 funds the maintenance of the postage machine and taxation letter opener. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 51 Taxation | General Fund Tammy Lehnert Director of Taxation The Division of Taxation is responsible for the collection of all tax revenues, performing audits, delinquency collections, compliance projects, refunds and other duties as assigned. The City of Dublin continues to grow and, as a mandatory filing community, the City strives to continually reduce the number of paper forms and use more innovative means for tax filings to achieve a higher level of distinction in Central Ohio. Preliminary and final audits are conducted to ensure that all tax obligations have been fulfilled. The Director of Taxation works closely with businesses to guarantee proper and timely filing, paying and processing of all tax forms. Personnel Data Position Title 2023 | Adopted 2024 | Adopted Director of Taxation 1 1 Tax Manager 1 1 Corporate Tax Auditor 3 3 Auditor 1 1 Accounting Specialist 1 1 Total 7 7 City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 52 Taxation Expenditures by Expense Type | General Fund Budgeted and Historical Expenditures by Expense Type MillionsCapital Outlay Supplies Contractual Services Personal Services Other Charges and Expenditures FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $2 $4 $6 $8 $10 Expense Objects Personal Services Full Time Salaries/Wages 10110220- 701101 $519,940 $510,200 $510,200 $503,215 Overtime Wages 10110220- 701103 $1,835 $3,000 $3,000 $5,000 Employee Benefits 10110220- 701201 $221,922 $217,455 $217,455 $262,280 Training/Travel 10110220- 702000 $1,765 $2,250 $2,605 $0 Total Personal Services:$745,462 $732,905 $733,260 $770,495 Contractual Services Other Professional Services 10110220- 713004 $26,496 $900 $17,900 $21,000 Misc. Contract. Serv.10110220- 713005 $14,137 $35,000 $37,443 $22,500 Training/Travel 10110220- 713010 $0 $0 $0 $1,800 Communications 10110220- 715001 $436 $3,000 $5,564 $2,400 Memberships/Subscriptions 10110220- 716000 $644 $1,000 $1,000 $300 Total Contractual Services:$41,713 $39,900 $61,907 $48,000 Supplies Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 53 Office Supplies 10110220- 721001 $3,597 $1,950 $3,982 $3,500 Dublin Forms 10110220- 721004 $0 $500 $500 $0 Equipment Maintenance 10110220- 724003 $0 $400 $400 $400 Total Supplies:$3,597 $2,850 $4,882 $3,900 Other Charges and Expenditures Refunds 10110220- 755000 $7,303,180 $4,500,000 $4,500,000 $4,200,000 Total Other Charges and Expenditures:$7,303,180 $4,500,000 $4,500,000 $4,200,000 Total Expense Objects:$8,093,952 $5,275,655 $5,300,050 $5,022,395 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 10110220 Account 701101 provides funding for the staffing reflected in the Personnel Data. Account 713004 provides funding for the cost for the State of Ohio tape which is used to ensure compliance. Account 713005 includes funding to utilize a third party for collection of delinquent accounts and research database costs. Account 715001 provides funding for postage and Post Office boxes. Account 721004 funds letters with personal URLs that are sent to filers in order to direct them to their own site via the online tax tool to reduce the number of paper returns received, thus reducing the manpower necessary to ensure the returns are truly “Dublin” returns. Non-payroll service provider withholding accounts will receive a letter with a personal URL instead of a booklet that will allow them to print forms with their Dublin identification as needed and will identify them as “active” accounts. This reduces the City’s accepting dollars for accounts with Dublin mailing addresses that are not physically located in Dublin. Account 755000 provides funding for income tax refunds. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 54 Finance Miscellaneous Accounts | General Fund Matthew Stiffler Chief Financial Officer/Director of Finance These are miscellaneous accounts within the General Fund which are not directly related to the operational costs of a specific function. The functional supervision of these accounts is provided by the Department of Finance. The cost of the City’s annual audit has been reflected in the Miscellaneous Accounts due to its citywide nature. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 55 Finance Miscellaneous Expenditures by Expense Type | General Fund Budgeted and Historical Expenditures by Expense Type MillionsOther Charges and Expenditures Contractual Services FY2018FY2019FY2020FY2021FY2022FY2023FY2024$-0.25 $0 $0.25 $0.5 $0.75 $1 $1.25 $1.5 Expense Objects Contractual Services County Auditor Deductions 10110290- 711001 $307 $2,500 $2,500 $2,500 Real Estate Taxes 10110290- 711003 $141,623 $139,000 $123,611 $125,000 Accounting/Auditing Services 10110290- 713001 $56,853 $70,000 $96,567 $190,860 Workers Compensation 10110290- 714006 $0 $0 $0 $300,000 Misc. Contract. Serv.10160290- 713005 $0 $42,500 $42,500 $100,000 Health Services 10160290- 714002 $508,835 $495,000 $523,234 $550,000 Total Contractual Services:$707,617 $749,000 $788,412 $1,268,360 Other Charges and Expenditures Refunds 10110290- 755000 $1 $1,000 $1,000 $1,000 Total Other Charges and Expenditures:$1 $1,000 $1,000 $1,000 Total Expense Objects:$707,618 $750,000 $789,412 $1,269,360 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 56 Budget Summary 10110290 Account 711001 provides funding for County Auditor deductions, election expenses and expenses related to advertising and collecting delinquencies. These fees are deducted from the City's real estate apportionment. Account 711003 funds real estate taxes for properties and rights-of-way owned by the City that are not tax-exempt based on usage or for which property tax exemption is pending. The amount budgeted varies widely each year based on properties acquired. Funding is also provided for payment of reparations per Ohio Revised Code. Account 713001 provides funding for the City’s annual audit. Account 755000 provides funding for unanticipated refunds. 10160290 Account 714002 provides funding for health services under contract with the Franklin County Board of Health and funding for contracted mosquito spraying. Franklin County Board of Health fee increases are based on increases in the City’s population as well as inflationary costs. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 57 Community Planning & Development | General Fund Jennifer Rauch Director of Community Planning & Development Planning is responsible for managing the City’s development process, undertaking plan updates and special studies, and enforcing the City’s codes relative to the built environment. This includes land use planning, zoning reviews, code enforcement, public engagement, and support of several boards and commissions. The division is responsible for analyzing the changing needs of the City, identifying, and implementing long range planning objectives that address these needs. This includes identifying trends that need to be addressed (changes in demographics, shifting market conditions, current thinking in land planning and urban design, housing needs, etc.) and undertaking the relevant studies or plan updates. All of these activities relate to the following functional areas: development proposals review; Community Plan maintenance and implementation; project analysis; area studies; code enforcement; zoning compliance; land use modeling; code amendments; and customer service operations. Mission Statement The mission of Planning is to provide professional and technical expertise to guide the land use decisions of public officials, residents and the development community. We engage our citizens to establish and realize a long-range vision for Dublin’s land use and development character. We facilitate the zoning process through the implementation of the Community Plan and the administration and enforcement of the City’s land use codes. Personnel Data Position Title 2023 | Adopted 2024 | Adopted Director of Community Planning & Development (1)0 1 Director of Planning (1)1 0 Deputy Director of Planning 1 1 Senior Planner (2)2 3 Planner II (2)2 1 Planner I 2 2 Planning Technician 2 2 Code Enforcement Supervisor 1 1 Code Enforcement Officer 3 3 Zoning Inspector 2 2 Administrative Support II 1 1 Administrative Support III (3)0 1 Total 17 18 Part-Time/Seasonal Staff Planning Assistant/Intern 3 3 Total 3 3 Notes and Adjustments: 1. The Director of Planning is reclassified to the Director of Community Planning & Development. 2. A Planner II position is reclassified to a Senior Planner position (focus of Urban Designer). 3. The Administrative Support III previously in the Division for the Director of Community Development Director is moved to the Division of Community Planning & Development, as that Division has been removed. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 58 Community Planning Expenditures by Expense Type | General Fund Budgeted and Historical Expenditures by Expense Type MillionsCapital Outlay Other Charges and Expenditures Supplies Contractual Services Personal Services FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $0.5 $1 $1.5 $2 $2.5 $3 Expense Objects Personal Services Full Time Salaries/Wages 10120720- 701101 $1,078,543 $1,191,485 $1,191,485 $1,285,960 Overtime Wages 10120720- 701103 $5,996 $15,000 $15,000 $15,500 Other Wages 10120720- 701104 $43,054 $70,020 $70,020 $87,000 Employee Benefits 10120720- 701201 $392,727 $479,770 $479,770 $525,470 Uniforms and Clothing 10120720- 701204 $1,404 $2,810 $2,831 $2,810 Training/Travel 10120720- 702000 $28,566 $40,000 $40,036 $0 Meeting Expenses 10120720- 703100 $1,636 $750 $750 $0 Total Personal Services:$1,551,927 $1,799,835 $1,799,892 $1,916,740 Contractual Services Planning Services 10120720- 712008 $135,742 $420,000 $1,099,679 $370,000 Other Professional Services 10120720- 713004 $53,448 $102,000 $252,004 $153,270 Misc. Contract. Serv.10120720- 713005 $4,319 $4,300 $4,300 $4,300 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 59 Training/Travel 10120720- 713010 $0 $0 $0 $50,000 Communications 10120720- 715001 $1,005 $5,000 $5,000 $4,500 Printing and Reproductions 10120720- 715003 $109 $1,500 $1,500 $11,500 Memberships/Subscriptions 10120720- 716000 $7,505 $7,500 $9,570 $13,150 Rents and Leases 10120720- 717001 $1,797 $5,320 $6,082 $5,320 Total Contractual Services:$203,925 $545,620 $1,378,135 $612,040 Supplies Office Supplies 10120720- 721001 $4,220 $5,200 $5,338 $5,500 Operating Supplies 10120720- 721002 $256 $4,000 $4,000 $4,500 Meeting Expenses 10120720- 721006 $0 $0 $0 $3,000 Equipment Maintenance 10120720- 724003 $0 $500 $500 $500 Total Supplies:$4,476 $9,700 $9,838 $13,500 Other Charges and Expenditures Dublin 2035 Framework 10120720- 751011 $7,850 $0 $0 $0 Code Enforcement 10120720- 753001 $5,199 $10,000 $10,000 $10,000 Refunds 10120720- 755000 $1,005 $1,500 $1,500 $1,500 Total Other Charges and Expenditures:$14,054 $11,500 $11,500 $11,500 Total Expense Objects:$1,774,382 $2,366,655 $3,199,365 $2,553,780 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 60 Budget Summary 10120720 Account 701101 provides funding for the staffing reflected in the Personnel Data. One of the two existing Zoning Inspector positions is being reallocated to a Senior Planner position focused on Urban Design. Account 701104 provides wages for the Planning Assistants. Account 712008 provides funding for general planning services and area studies including the completion of the Community Plan update, Phase II of the Metro Center Implementation, and site development studies. Account 713004 provides funding for consultants that support the City’s boards and commissions through the development review process, including architectural consulting services, historic preservation consulting services, and graphic design consulting services. Increased budget is due to 3D modeling support. Account 713010 (previously 702000) provides funding for training and travel. Increase in budget includes the opportunity to conduct benchmarking trips. Account 715001 provides funding for postage for all work units located within the Development Building. Account 716000 provides funding for professional membership and certification fees such as the APA (state and national), ASLA, ULI, and landscape and enforcement certifications. Increase in budget to account for additional staff certification needs. Account 721002 includes funding for office supplies and supplies for specialized presentations. Account 721006 (previously 703100) provides funding for meetings expenses. Account 753001 provides funding for mowing services and landscape projects under the supervision of the City’s Zoning Inspectors and Code Enforcement Officers. The majority of these costs are recovered through assessments. 10180720 Account 731000 provides funding for equipment and furniture. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 61 Building Standards | General Fund Bradley Fagrell Director of Building Standards The primary responsibility of Building Standards is to ensure that all new construction, both commercial and residential, complies with all applicable state, local and national building codes. Personnel Data Position Title 2023 | Adopted 2024 | Adopted Director of Building Standards 1 1 Commercial Plans Examiner 1 1 Senior Building Inspector 1 1 Building Inspector 4 4 Electrical Inspector 1 1 Residential Plans Examiner 1 1 Development Review Specialist 1 1 Review Services Coordinator 1 1 Permit Technician 2 2 Total 13 13 Part-Time/Seasonal Staff Electrical Inspector 1 1 Total 1 1 City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 62 Building Standards Expenditures by Expense Type | General Fund Budgeted and Historical Expenditures by Expense Type MillionsOther Charges and Expenditures Supplies Contractual Services Personal Services FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $0.5 $1 $1.5 $2 Expense Objects Personal Services Full Time Salaries/Wages 10120730- 701101 $955,783 $968,210 $968,210 $969,525 Overtime Wages 10120730- 701103 $8,716 $10,000 $10,000 $10,000 Other Wages 10120730- 701104 $10,074 $39,000 $39,000 $25,000 Employee Benefits 10120730- 701201 $434,530 $448,395 $448,395 $452,385 Uniforms and Clothing 10120730- 701204 $770 $3,000 $1,140 $2,000 Training/Travel 10120730- 702000 $2,588 $4,000 $6,280 $0 Meeting Expenses 10120730- 703100 $232 $500 $80 $0 Total Personal Services:$1,412,693 $1,473,105 $1,473,105 $1,458,910 Contractual Services Plan Review 10120730- 712003 $161,551 $150,000 $249,707 $175,000 Building Inspection Services 10120730- 712004 $89,733 $150,000 $177,079 $150,000 Misc. Contract. Serv.10120730- 713005 $50,951 $70,000 $70,000 $70,000 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 63 Training/Travel 10120730- 713010 $0 $0 $0 $5,000 Printing and Reproductions 10120730- 715003 $6,000 $3,000 $3,100 $3,000 Memberships/Subscriptions 10120730- 716000 $1,612 $2,500 $2,500 $2,500 Total Contractual Services:$309,847 $375,500 $502,386 $405,500 Supplies Office Supplies 10120730- 721001 $2,707 $2,600 $3,754 $2,600 Operating Supplies 10120730- 721002 $6,503 $6,000 $6,000 $6,000 Meeting Expenses 10120730- 721006 $0 $0 $0 $500 Total Supplies:$9,211 $8,600 $9,754 $9,100 Other Charges and Expenditures Refunds 10120730- 755000 $2,130 $2,500 $2,500 $2,500 Total Other Charges and Expenditures:$2,130 $2,500 $2,500 $2,500 Total Expense Objects:$1,733,881 $1,859,705 $1,987,745 $1,876,010 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 10120730 Account 701101 provides funding for staffing reflected in the Personnel Data. Account 701104 provides funding for the part-time Electrical Inspector position. Account 701204 provides funding for uniforms, including shirts, boots and cold weather wear for Inspectors. Account 712003 funds contract services needed to complement the plan review which is completed in-house. The budget for this account fluctuates with the level of building activity; however, fees collected directly offset this expense. Account 712004 includes funding for plumbing inspection services from Franklin County Public Health. The budget for this account fluctuates with the level of building activity; however, fees collected directly offset this expense. Account 713005 provides funding for credit card machine transaction fees. Account 713010 (previously 702000) provides funding for training, attendance at regional conferences and required state certifications. Account 721002 provides funding for supplies, such as technical equipment and code reference materials for Inspectors and Plan Review staff. Account 755000 provides funding for unanticipated fee refunds. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 64 Transportation & Mobility Jeannie Willis Director of Transportation & Mobility The Division of Transportation & Mobility is responsible for comprehensive transportation planning and operations, including traffic engineering and safety. This work unit explores ways to make transportation more efficient and accessible by developing and evaluating innovative approaches to all modes of transportation and mobility. This work unit is tasked with understanding transportation and mobility needs, coordinating options to meet needs and integrating transportation into planning and programs. The Division of Transportation & Mobility explores ways to enhance safety and mobility options through emerging technologies, including the Speed Management Program, and is responsible for leading Connected Dublin’s Smart Mobility initiatives within the Beta District and other areas of the City. This work unit is responsible for parking management and also provides services, such as operation and maintenance of traffic signals, street lights, the outdoor warning system, school zone flashers, traffic control and regulatory signs, and pavement marking maintenance, standards and design. Departmental budget information can be found on the individual fund pages. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 65 Transportation & Mobility | General Fund Jeannie Willis Director of Transportation & Mobility The Division of Transportation & Mobility is responsible for comprehensive transportation planning and operations, including traffic engineering and safety. This work unit explores ways to make transportation more efficient and accessible by developing and evaluating innovative approaches to all modes of transportation and mobility. This work unit is tasked with understanding transportation and mobility needs, coordinating options to meet needs and integrating transportation into planning and programs. The Division of Transportation & Mobility explores ways to enhance safety and mobility options through emerging technologies, including the Speed Management Program, and is responsible for leading Connected Dublin’s Smart Mobility initiatives within the Beta District and other areas of the City. This work unit is responsible for parking management and also provides services, such as operation and maintenance of traffic signals, street lights, the outdoor warning system, school zone flashers, traffic control and regulatory signs, and pavement marking maintenance, standards and design. Personnel Data Position Title 2023 | Adopted 2024 | Adopted Director of Transportation & Mobility 1 1 Deputy Director of Transportation & Mobility 1 1 Transportation Program Manager (1) 0 1 Civil Engineer II (1)2 1 Planner II 1 1 Maintenance Crew Supervisor 1 1 Electrical Worker 4 4 Maintenance Worker 2 2 Administrative Support II 1 1 Total 13 13 Part-Time/Seasonal Staff Seasonal Maintenance Worker 1 1 Intern 1 1 Total 2 2 Notes and Adjustments: 1. A Civil Engineer II position is reclassified to the Transportation Program Manager. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 66 Transportation and Mobility Expenditures by Expense Type | General Fund Budgeted and Historical Expenditures by Expense Type MillionsSupplies Personal Services Contractual Services FY2021FY2022FY2023FY2024$0 $1 $2 $3 $4 Expense Objects Personal Services Full Time Salaries/Wages 10170750-701101 $902,259 $956,840 $956,840 $982,995 Overtime Wages 10170750-701103 $7,735 $10,000 $10,000 $10,000 Other Wages 10170750-701104 $0 $17,000 $16,700 $17,000 Employee Benefits 10170750-701201 $418,596 $502,735 $502,735 $486,045 Uniforms and Clothing 10170750-701204 $6,306 $7,760 $8,973 $8,000 Training/Travel 10170750-702000 $29,648 $29,450 $29,850 $0 Meeting Expenses 10170750-703100 $356 $500 $800 $0 Total Personal Services:$1,364,901 $1,524,285 $1,525,898 $1,504,040 Contractual Services Utilities- Other Fuel Types 10150750-717005 $144,264 $228,500 $349,368 $225,000 Other Professional Services 10170750-713004 $644,416 $1,060,000 $1,805,437 $1,485,000 Training/Travel 10170750-713010 $0 $0 $0 $27,750 Communications 10170750-715001 $0 $1,000 $1,000 $500 Memberships/Subscriptions 10170750-716000 $1,377 $2,700 $2,700 $3,875 Total Contractual Services:$790,057 $1,292,200 $2,158,506 $1,742,125 Supplies General Maintenance 10150750-724001 $126,396 $150,000 $188,107 $150,000 Office Supplies 10170750-721001 $2,122 $1,950 $1,950 $2,000 Operating Supplies 10170750-721002 $1,082 $4,750 $4,750 $3,000 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 67 Meeting Expenses 10170750-721006 $0 $0 $0 $1,000 Equipment Maintenance 10170750-724003 $0 $2,000 $2,000 $2,000 Signs 10170750-725002 $112,458 $150,000 $237,364 $150,000 Total Supplies:$242,058 $308,700 $434,172 $308,000 Total Expense Objects:$2,397,016 $3,125,185 $4,118,575 $3,554,165 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 10170750 Account 701101 provides funding for staffing reflected in the Personnel Data and Notes and Adjustments section. Account 713004 provides funding for professional services, including general engineering transportation tasks, wayfinding plans, travel demand models and land use updates and traffic calming programs. Account 713010 (previously 702000) provides for training and certifications. Account 725002 provides funding for sign shop materials. The increase in budget provides for secondary wayfinding signs and pavement markings. 10150750 Account 717005 provides funding for electrical service to the City’s streetlights and outdoor early warning siren system. Account 724001 provides funding to purchase parts and supplies for the City’s streetlights and outdoor early warning siren system, as well as a tester for 480V LED street lights. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 68 Transportation & Mobility – Traffic Signals and Street Lights | Special Revenue Fund Jeannie Willis Director of Transportation & Mobility This program is responsible for installing, repairing and maintaining all traffic signals, enhanced crosswalk systems, driver feedback signs, flashing signs and intersection systems within the public right-of-way. Also included within this budget is maintenance of school zones, flashers and pedestrian crossings. Personnel Data There are no personnel assigned to this budget. Expenses reflected in this account are for work completed by the Electrical Crew. The Electrical Crew positions are reflected in the Transportation and Mobility Work Unit. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 69 Transportation and Mobility - Traffic Signals and Street Lights | Special Revenue Fund Budgeted and Historical Expenditures by Expense Type MillionsCapital Outlay Contractual Services Supplies FY2021FY2022FY2023FY2024$0 $0.05 $0.1 $0.15 $0.2 $0.25 $0.3 $0.35 Expense Objects Contractual Services Utilities- Other Fuel Types 20170750-717005 $28,471 $32,000 $41,007 $45,000 Total Contractual Services:$28,471 $32,000 $41,007 $45,000 Supplies Operating Supplies 20170750-721002 $1,772 $2,500 $2,500 $2,500 General Maintenance 20170750-724001 $232,486 $235,500 $402,373 $235,500 Equipment Maintenance 20170750-724003 $7,810 $3,000 $3,000 $3,000 Total Supplies:$242,067 $241,000 $407,873 $241,000 Capital Outlay Furniture/Equipment 20180750-731000 $7,662 $10,000 $12,046 $10,000 Total Capital Outlay:$7,662 $10,000 $12,046 $10,000 Total Expense Objects:$278,200 $283,000 $460,926 $296,000 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 70 Budget Summary 20170750 Account 717005 provides utility funding for the operation of traffic signals. Account 724001 provides funding for signal head replacements, routers for remote communications with traffic signals, and other traffic signals and illuminated street sign repair and maintenance. This increased for pedestrian crossing systems and driver feedback signs. 20180750 Account 731000 provides funding to setup a new cage area with shelving, a work bench, bins and miscellaneous small equipment. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 71 Transportation & Mobility – Highway Operations | Special Revenue Fund Jeannie Willis Director of Transportation & Mobility This program is responsible for maintaining all traffic signals, traffic control signs, and street lights within the public right-of-way on the various state highways located within Dublin. The monies utilized for this section are from the State Highway Maintenance Improvements Fund, which is generated by motor vehicle registration fees and gasoline tax revenues and can only be spent for this limited purpose. Personnel Data Although the Division of Transportation & Mobility is responsible for this work, there are no personnel directly assigned to the Highway Maintenance budget. There are no personnel assigned to this budget. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 72 Transportation and Mobility - Highway Operations | Special Revenue Fund Budgeted and Historical Expenditures by Expense Type MillionsContractual Services Transfers/Advances FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $0.05 $0.1 $0.15 $0.2 $0.25 $0.3 $0.35 Expense Objects Contractual Services Utilities- Other Fuel Types 20270750-717005 $21,347 $25,000 $32,878 $29,000 Total Contractual Services:$21,347 $25,000 $32,878 $29,000 Transfers/Advances Transfers Expense 20296290-741000 $25,000 $25,000 $25,000 $25,000 Advances Expense 20297290-742000 $200,000 $200,000 $200,000 $200,000 Total Transfers/Advances:$225,000 $225,000 $225,000 $225,000 Total Expense Objects:$246,347 $250,000 $257,878 $254,000 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 20296290 Accounts 741000 and 742000 provide funding for necessary transfers to general obligation bond retirement, the Capital Improvements Tax Fund for additional gas tax collections, and advances as necessary. 20270750 Account 717005 provides funding for the cost of utilities related to the operation of traffic signals that are located on state highways. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 73 Engineering Paul Hammersmith Director of Engineering The Department of Engineering provides services, such as design review; street and bridge design and construction; surveying; construction inspection, design, operation and maintenance of City waterways, water distribution system, storm and sanitary sewers, floodplain, pervious and roadway pavers, retention and detention basins; management of capital improvement projects; and consultation on proposed projects to various City departments. The City Engineer is responsible for ensuring engineering standards and guidelines are followed for all work in public rights-of-way and easements. This function reviews the engineering aspects of all development projects. The City Engineer provides advice and information to City Council, the Planning & Zoning Commission, Board of Zoning Appeals, Architectural Review Board, Administrative Review Team and task forces when convened for special initiatives or projects. Departmental budget information can be found on the individual fund pages. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 74 Engineering | General Fund Paul Hammersmith Director of Engineering The Department of Engineering provides services, such as design review; street and bridge design and construction; surveying; construction inspection, design, operation and maintenance of City waterways, water distribution system, storm and sanitary sewers, floodplain, pervious and roadway pavers, retention and detention basins; management of capital improvement projects; and consultation on proposed projects to various City departments. The City Engineer is responsible for ensuring engineering standards and guidelines are followed for all work in public rights-of-way and easements. This function reviews the engineering aspects of all development projects. The City Engineer provides advice and information to City Council, the Planning & Zoning Commission, Board of Zoning Appeals, Architectural Review Board, Administrative Review Team and task forces when convened for special initiatives or projects. Personnel Data Position Title 2023 | Adopted 2024 | Adopted Director of Engineering (7)0 1 Director of Engineering (1)0.6 0.6 Deputy Director of Engineering (2)(3)1.3 0 Director of Capital Projects (2)0 1 Director of Utilities and Stormwater (3)0 0.3 Senior Civil Engineer 3 3 Civil Engineer I (4)0.5 0.5 Civil Engineer II 3 3 Engineering Technician I (6)2 1.7 Engineering Technician II 2 2 Operations Administrator (5)0.3 0.3 Engineering Project Inspector 5 5 Total 17.7 18.4 Part-Time/Seasonal Staff Interns 2 2 Total 2 2 Notes and Adjustments: 1. The Director of Engineering position is allocated 60% to this budget in the General Fund, 20% to the Water Fund and 20% to the Sewer Fund. 2. The Deputy Director is retitled to the Director of Capital Projects which is allocated 100% to this budget in the General Fund. 3. The Deputy Director is retitled to the Director of Utilities and Stormwater and allocated 50% to the Sewer Fund, 30% to the budget in the General Fund and 20% to the Water Fund. 4. The Civil Engineer I is allocated 75% to this budget in the General Fund and 25% to the Sewer Fund. 5. The Operations Administrator is allocated 30% to this budget in the General Fund, 20% to the Water Fund and 50% to the Sewer Fund. 6. The Engineering Technician I is allocated 70% General Fund, 15% Water Fund, and 15% Sewer Fund. 7. The Director of Engineering is a reclassification of the Director of Community Development. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 75 Engineering Expenditures by Expense Type | General Fund Budgeted and Historical Expenditures by Expense Type MillionsSupplies Contractual Services Personal Services FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $1 $2 $3 $4 Expense Objects Personal Services Full Time Salaries/Wages 10120320-701101 $1,382,698 $1,345,695 $1,345,695 $1,536,735 Overtime Wages 10120320-701103 $32,445 $58,000 $58,000 $45,000 Other Wages 10120320-701104 $13,087 $17,000 $16,800 $8,500 Employee Benefits 10120320-701201 $674,709 $677,405 $677,405 $677,315 Uniforms and Clothing 10120320-701204 $3,025 $3,500 $4,080 $1,500 Training/Travel 10120320-702000 $8,273 $30,000 $30,000 $0 Meeting Expenses 10120320-703100 $980 $500 $700 $0 Total Personal Services:$2,115,216 $2,132,100 $2,132,680 $2,269,050 Contractual Services Eng. Inspection Services 10120320-712002 $113,576 $175,000 $329,234 $295,000 Plan Review 10120320-712003 $14,771 $140,000 $140,229 $140,000 Other Professional Services 10120320-713004 $371,815 $494,860 $736,704 $475,000 Training/Travel 10120320-713010 $0 $0 $0 $40,600 Communications 10120320-715001 $209 $1,000 $1,200 $0 Printing and Reproductions 10120320-715003 $1,045 $2,500 $4,553 $2,000 Memberships/Subscriptions 10120320-716000 $2,974 $4,000 $4,000 $4,290 Total Contractual Services:$504,391 $817,360 $1,215,920 $956,890 Supplies Office Supplies 10120320-721001 $2,313 $1,900 $2,285 $1,900 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 76 Operating Supplies 10120320-721002 $3,328 $4,500 $5,218 $4,500 Meeting Expenses 10120320-721006 $0 $0 $0 $800 Total Supplies:$5,641 $6,400 $7,503 $7,200 Total Expense Objects:$2,625,248 $2,955,860 $3,356,103 $3,233,140 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 10120320 Account 701101 provides funding for staffing reflected in the Personnel Data. Account 701104 provides funding for part-time (Intern) staff. Account 701204 provides funding for safety vests, fire retardant pants and shirts, boots, rain gear and safety glasses for field staff. Account 712002 provides funding for inspection of construction materials by the City of Columbus and contract inspection services. Account 712003 provides funding for consulting and specialized plan review. Account 713004 provides funding for consulting services, including surveying, the National Pollution Discharge Elimination System (NPDES) permit fee and required public education and outreach, and professional services associated with floodplain permit review as well as stormwater inspection services and stormwater GIS enhancements and EBuilder training and integration with MUNIS and long- line pavement marking. Funding is also provided for construction engineering support – U.S. 33/S.R. 161/Post Road Interchange. Account 713010 (previously 702000) provides funding for staff development training, webinars and local conferences. Account 715001 provides funding for FedEx and courier services. Account 715003 provides funding for printing contract documents and plans related to the City’s capital improvement projects and toner for various printers. Account 716000 provides funding for memberships including American Public Works Association (APWA) and engineering license renewals. Account 721001 provides funding for office supplies. Account 721002 provides funding for operating supplies for the Inspectors, including spray paint, soil probes, tapes, lathes, etc. This account also provides funding for the rain barrel and compost bin programs. Account 721006 (previously 703100) includes funding for group meetings sponsored by the City. Funding is included for food, beverages and associated supplies. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 77 Engineering | Enterprise Fund Paul Hammersmith Director of Engineering Enterprise funds are used to account for operations that are financed and operated in a manner similar to private businesses, where the costs of providing goods or services to the general public on a continuing basis are financed or recovered primarily through user charges. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 78 Water System Maintenance | Enterprise Fund Paul Hammersmith Director of Engineering Engineering is responsible for managing the water system for the City of Dublin, including planning and design of all new construction and improvements of the water distribution system, which is tied to the City of Columbus system under a service contract. City staff members work in cooperation with homeowners, business owners, engineers, consultants, builders, developers, the Ohio Environmental Protection Agency and the City of Columbus in planning improvements to the Dublin portion of the system. Engineering is also responsible for the hydrant maintenance program. Personnel Data Position Title 2023 | Adopted 2024 | Adopted Director of Engineering (1)0.2 0.2 Director of Utilities and Stormwater (2)(3)0 0.2 Deputy Director of Engineering (2)(3)0.2 0 Operations Administrator (4)0.2 0.2 Engineering Technician I (5)0 0.15 Civil Engineer I 0.5 0.5 Maintenance Worker 1 1 Total 2.1 2.25 Part-Time/Seasonal Staff Seasonal Maintenance Worker 1 1 Total 1 1 Notes and Adjustments: 1. The Director of Engineering position is allocated 20% to the Sewer Fund, 60% to Engineering in the General Fund and 20% to this budget in the Water Fund. 2. The Deputy Director of Engineering position is retitled to the Director of Utilities and Stormwater. 3. The Director of Utilities and Stormwater position is allocated 50% to the Sewer Fund, 30% to Engineering in the General Fund and 20% to this budget in the Water Fund. 4. An Operations Administrator position is allocated 50% to the Sewer Fund, 30% to Engineering in the General Fund and 20% to this budget in the Water Fund. 5. The Engineering Technician I is allocated 70% General Fund, 15% Water Fund, and 15% Sewer Fund. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 79 City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 80 Water System Maintenance Expenditures by Expense Type | Enterprise Fund Budgeted and Historical Expenditures by Expense Type MillionsCapital Outlay Other Charges and Expenditures Supplies Personal Services Contractual Services FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $0.5 $1 $1.5 $2 Expense Objects Personal Services Full Time Salaries/Wages 61030320- 701101 $188,051 $176,970 $176,970 $162,475 Overtime Wages 61030320- 701103 $1,941 $2,000 $2,000 $2,000 Other Wages 61030320- 701104 $8,596 $15,000 $15,000 $30,000 Employee Benefits 61030320- 701201 $83,531 $89,960 $89,960 $99,095 Uniforms and Clothing 61030320- 701204 $450 $450 $450 $450 Training/Travel 61030320- 702000 $2,374 $4,500 $4,890 $0 Total Personal Services:$284,943 $288,880 $289,270 $294,020 Contractual Services Other Professional Services 61030320- 713004 $22,392 $60,000 $120,232 $55,000 Misc. Contract. Serv.61030320- 713005 $150,603 $254,000 $361,402 $304,500 Training/Travel 61030320- 713010 $0 $0 $0 $6,000 Communications 61030320- 715001 $0 $4,100 $4,100 $4,100 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 81 Memberships/Subscriptions 61030320- 716000 $0 $350 $350 $300 Utilities- Other Fuel Types 61030320- 717005 $164,930 $155,000 $203,162 $199,000 Hydrant Maint and Repair 61030320- 718002 $71,352 $58,500 $64,440 $64,500 Total Contractual Services:$409,278 $531,950 $753,686 $633,400 Supplies Operating Supplies 61030320- 721002 $36,370 $6,200 $9,050 $6,900 Equipment Maintenance 61030320- 724003 $1,510 $8,500 $10,990 $8,500 Total Supplies:$37,880 $14,700 $20,040 $15,400 Capital Outlay Tools 61080320- 734002 $0 $500 $500 $0 Water System Imp.61080320- 735009 $244,274 $80,000 $567,458 $0 Total Capital Outlay:$244,274 $80,500 $567,958 $0 Other Charges and Expenditures Refunds 61030320- 755000 $4,980 $5,000 $5,000 $0 Total Other Charges and Expenditures:$4,980 $5,000 $5,000 $0 Total Expense Objects:$981,354 $921,030 $1,635,954 $942,820 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 61030320 Account 701101 provides funding for full-time staffing reflected in the Personnel Data as related to the Engineering staff. Account 701104 provides funding for part-time/seasonal staff. Account 713004 provides funding to update water modeling citywide, critical infrastructure study/vulnerability assessments, booster station evaluations, water asset management and GIS enhancements. Account 713005 provides funding for distribution system repairs and water line located by USIC Locating Services. Funding is also provided for flushing and pumping of hydrants completed by the Washington Township Fire Department and contracted emergency repairs. Account 713010 (previously 702000) provides funding for training sessions. Account 717005 provides funding for utility costs related to the operation of the water system. Account 718002 provides funding for replacement fire hydrants, nozzles and other miscellaneous parts. 61080320 Account 735009 provides funding for capital improvements projects as approved in the 2024-2028 Capital Improvements Program. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 82 Water System Construction | Enterprise Fund Matthew Stiffler Chief Financial Officer/Director of Finance A fund is provided to account for the bond issuance proceeds received and to be expended on related public water infrastructure projects. For financial reporting purposes (in the City’s Annual Comprehensive Annual Report), the Water Construction Fund is part of the Water Fund. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 83 Water System Construction Expenditures by Expense Type | Enterprise Fund Budgeted and Historical Expenditures by Expense Type MillionsContractual Services Capital Outlay FY2023FY2024$0 $0.2 $0.4 $0.6 $0.8 $1 Expense Objects Contractual Services Other Professional Services 61280320-713004 $0 $452,000 $0 $0 Total Contractual Services:$0 $452,000 $0 $0 Capital Outlay Water System Imp.61280320-735009 $0 $0 $3,203,911 $860,000 Total Capital Outlay:$0 $0 $3,203,911 $860,000 Total Expense Objects:$0 $452,000 $3,203,911 $860,000 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 84 Sewer System Maintenance | Enterprise Fund Paul Hammersmith Director of Engineering Engineering is responsible for managing the sanitary sewer system, including planning and design of all new construction, improvements and removal of infiltration and inflow sources. Engineering is also responsible for the inspection, condition assessment and execution of maintenance of the sanitary sewer system. Engineering analyzes system data to estimate amounts of extraneous flow to be eliminated, recommends repair and maintenance, and recommends the work program and new construction to be performed. City staff works in cooperation with homeowners, business owners, engineers, consultants, builders, developers, the Ohio Environmental Protection Agency and the City of Columbus, which provides wastewater treatment under a service contract. Personnel Data Position Title 2023 | Adopted 2024 | Adopted Director of Engineering (1)0.2 0.2 Director of Utilities and Stormwater (2)(3)0 0.5 Deputy Director of Engineering (2)(3)0.5 0 Engineering Technician I (5)0 0.15 Operations Administrator (4)0.5 0.5 Maintenance Worker 6 6 Total 7.2 7.35 Part-Time/Seasonal Staff Seasonal Maintenance Worker 1 1 Total 1 1 Notes and Adjustments: 1. The Director of Engineering position is allocated 20% to this budget in the Sewer Fund, 60% to Engineering in the General Fund and 20% to the Water Fund. 2. The Deputy Director of Engineering position is retitled to the Director of Utilities and Stormwater. 3. The Director of Utilties and Stormwater position is allocated 50% to this budget in the Sewer Fund, 30% to Engineering in the General Fund and 20% to the Water Fund. 4. An Operations Administrator position is allocated 50% to this budget in the Sewer Fund, 30% to Engineering in the General Fund and 20% to the Water Fund. 5. The Engineering Technician I is allocated 70% General Fund, 15% Water Fund, and 15% Sewer Fund. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 85 Sewer System Maintenance Expenditures by Expense Type | Enterprise Fund Budgeted and Historical Expenditures by Expense Type MillionsOther Charges and Expenditures Supplies Capital Outlay Personal Services Contractual Services FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $0.5 $1 $1.5 $2 $2.5 Expense Objects Personal Services Full Time Salaries/Wages 62030320- 701101 $488,008 $591,555 $591,555 $477,640 Overtime Wages 62030320- 701103 $26,175 $30,500 $30,500 $30,500 Other Wages 62030320- 701104 $12,003 $15,000 $15,000 $30,000 Employee Benefits 62030320- 701201 $253,456 $333,300 $333,300 $252,815 Uniforms and Clothing 62030320- 701204 $3,970 $6,715 $7,277 $3,800 Training/Travel 62030320- 702000 $2,583 $5,000 $7,150 $0 Total Personal Services:$786,195 $982,070 $984,782 $794,755 Contractual Services Other Professional Services 62030320- 713004 $324,855 $290,500 $517,364 $455,500 Misc. Contract. Serv.62030320- 713005 $254,383 $439,000 $564,000 $480,000 Training/Travel 62030320- 713010 $0 $0 $0 $5,000 Communications 62030320- 715001 $0 $2,600 $2,600 $100 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 86 Memberships/Subscriptions 62030320- 716000 $200 $550 $550 $590 Rents and Leases 62030320- 717001 $0 $1,500 $1,500 $1,500 Total Contractual Services:$579,439 $734,150 $1,086,014 $942,690 Supplies Office Supplies 62030320- 721001 $21 $450 $450 $450 Operating Supplies 62030320- 721002 $6,263 $6,750 $12,711 $6,750 General Maintenance 62030320- 724001 $11,328 $8,500 $10,550 $8,500 Equipment Maintenance 62030320- 724003 $1,097 $9,000 $9,000 $9,000 Total Supplies:$18,709 $24,700 $32,711 $24,700 Capital Outlay Tools 62080320- 734002 $0 $24,570 $24,570 $0 Sanitary Sewer Imp.62080320- 735008 $95,593 $500,000 $1,498,192 $100,000 Total Capital Outlay:$95,593 $524,570 $1,522,762 $100,000 Other Charges and Expenditures Refunds 62030320- 755000 $5,790 $2,000 $2,000 $5,500 Total Other Charges and Expenditures:$5,790 $2,000 $2,000 $5,500 Total Expense Objects:$1,485,726 $2,267,490 $3,628,269 $1,867,645 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 87 Budget Summary 62030320 Account 701101 provides funding for staffing reflected under Personnel Data and in the Notes and Adjustments section as related to Engineering staff. Account 713004 provides funding for the flow monitoring program, manhole inspections and utility extension data gathering with Franklin County. Account 713005 provides funding for sewer line located by USIC Locating Services, pump station inspection and maintenance contract, Delaware County Engineering Fund and contracted sanitary sewer repairs. Increased budget is due to a cost increase in locating fees. Account 713010 (previously 702000) provides funding for the training of personnel in accordance with Occupational Safety and Health Administration (OSHA) requirements and other necessary training including but not limited to confined space entry, respirator, PACP certifications, flow meters, advanced pipe cleaning, software and GIS training and continuing educational requirements. Account 715001 provides funding for the cost of phone lines to pump stations. Account 721002 provides for supplies necessary for doing in-house sewer cleaning and repairs and miscellaneous supplies for Engineering staff. Account 724001 provides funding for the repair and maintenance of the sewer system, including grade rings and ground rims/covers. Account 724003 includes funding to maintain and repair sanitary sewer equipment. 62080320 Account 731000 provides funding for miscellaneous furniture and equipment needs. Account 734002 provides funding for replacement of miscellaneous tools. Account 735008 provides for capital improvement projects approved in the Capital Improvements Program (CIP). City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 88 Sewer System Construction | Enterprise Fund Matthew Stiffler Chief Financial Officer/Director of Finance A fund is provided to account for the bond issuance proceeds received and to be expended on related public sanitary sewer infrastructure projects. For financial reporting purposes (in the City’s Annual Comprehensive Annual Report), the Sewer Construction Fund is part of the Sewer Fund. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 89 Sewer System Construction Expenditures by Expense Type | Enterprise Fund Budgeted and Historical Expenditures by Expense Type MillionsDebt Service Contractual Services Capital Outlay FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $1 $2 $3 $4 Expense Objects Contractual Services Misc. Contract. Serv.62310210-713005 $5,991 $5,000 $5,000 $5,000 Total Contractual Services:$5,991 $5,000 $5,000 $5,000 Capital Outlay Sanitary Sewer Imp.62380320-735008 $3,777,392 $3,365,200 $7,319,663 $2,675,000 Total Capital Outlay:$3,777,392 $3,365,200 $7,319,663 $2,675,000 Debt Service Debt Issuance Costs 62390290-761001 $0 $10,000 $10,000 $0 Total Debt Service:$0 $10,000 $10,000 $0 Total Expense Objects:$3,783,382 $3,380,200 $7,334,663 $2,680,000 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 62310210 Account 713005 provides funding for bank fees. Note: Needed funds are unknown at this time. If/when funds are needed, a supplemental appropriation will be requested. 62380320 Account 735008 provides funding for sanitary sewer projects funded through debt proceeds. These projects include sewer lining and repair and sanitary sewer extensions as provided in the 2024-2028 Capital Improvements Program (CIP). 62390290 Account 761001 provides funding for debt issuance costs. Needed funds are unknown at this time. If/when funds are needed, a supplemental appropriation will be requested. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 90 Parks and Recreation Matthew Earman Director of Parks and Recreation The Department of Parks & Recreation provides direction and oversight of the divisions of Recreation Services, Community Events and Outreach & Engagement. The Director of Parks & Recreation oversees park development, the management and maintenance of public art and the City’s landscape maintenance contracts. Departmental budget information can be found on the individual fund pages. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 91 Office of the Parks & Recreation Director | General Fund Matthew Earman Director of Parks and Recreation The Department of Parks & Recreation provides direction and oversight of the divisions of Recreation Services, Community Events, and Outreach and Engagement. The Director of Parks & Recreation oversees park development, the management and maintenance of public art and the City’s landscape maintenance contracts. Personnel Data Position Title 2023 | Adopted 2024 | Adopted Director of Parks & Recreation 1 1 Landscape Architect Manager 1 1 Landscape Architect (1) 0.5 0.5 Quality Control Manager 1 1 Administrative Support III 1 1 Total 4.5 4.5 Notes and Adjustments: 1. This position is allocated to public art in the Hotel/Motel Tax Fund (50%) and to this budget in the General Fund (50%). City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 92 Office of the Parks & Recreation Director | General Fund Budgeted and Historical Expenditures by Expense Type MillionsSupplies Other Charges and Expenditures Personal Services Contractual Services FY2018FY2019FY2020FY2021FY2023FY2024$0 $0.5 $1 $1.5 $2 $2.5 $3 Expense Objects Personal Services Full Time Salaries/Wages 10140410- 701101 $0 $402,915 $402,915 $407,180 Overtime Wages 10140410- 701103 $0 $2,000 $2,000 $1,500 Employee Benefits 10140410- 701201 $0 $141,010 $141,010 $171,105 Uniforms and Clothing 10140410- 701204 $0 $200 $450 $950 Training/Travel 10140410- 702000 $0 $13,000 $12,750 $0 Meeting Expenses 10140410- 703100 $0 $200 $200 $0 Total Personal Services:$0 $559,325 $559,325 $580,735 Contractual Services Misc. Contract. Serv.10140410- 713005 $0 $1,942,800 $1,942,800 $1,924,800 Training/Travel 10140410- 713010 $0 $0 $0 $15,740 Communications 10140410- 715001 $0 $100 $100 $100 Memberships/Subscriptions 10140410- 716000 $0 $5,855 $5,855 $5,855 Total Contractual Services:$0 $1,948,755 $1,948,755 $1,946,495 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 93 Supplies Office Supplies 10140410- 721001 $0 $975 $975 $975 Operating Supplies 10140410- 721002 $0 $500 $500 $500 Meeting Expenses 10140410- 721006 $0 $0 $0 $200 Total Supplies:$0 $1,475 $1,475 $1,675 Other Charges and Expenditures Special Projects/Programs 10140410- 751003 $0 $12,000 $12,000 $12,000 Total Other Charges and Expenditures:$0 $12,000 $12,000 $12,000 Total Expense Objects:$0 $2,521,555 $2,521,555 $2,540,905 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 10140410 (previously included in 10110111) Account 701101 provides funding for the staffing reflected in the Personnel Data. Account 701103 provides funding of overtime for Administrative Support staff for meetings, special events and other unexpected circumstances. Account 701204 supports minimal funding for the Landscape Architect Manager and Landscape Architect for PPE Replacements and supplies. Account 713005 provides funding for right-of-way landscape improvements/enhancements. Landscape maintenance contracts moved to this account from Parks and Ground Maintenance. Account 713010 (previously 702000) includes funding for staff training and development, as well as recertification credits for professional certifications. Account 715001 provides minimal funding for courier service and FedEx. Account 716000 provides funding for such memberships and renewals as NRPA and OPRA corporate and individual memberships, Landscape Architect Manager license, Landscape Architect license/memberships and Administrative Support membership/notary renewals. Account 721001 provides funding for office supplies, including printer supplies for landscape architects. Account 721002 includes funding for miscellaneous operational supplies as needed for park development and landscaping projects. Account 721006 (previously 703100) includes funding for miscellaneous public meetings. Account 751003 includes funding for park dedications and Parks & Recreation events, along with bikepath map updates and printing. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 94 Public Art | Special Revenue Fund Matthew Earman Director of Parks and Recreation City Council has directed that tax receipts from overnight hotel visits be utilized for beautification, tourism and community cultural opportunities. Allocations provide for the maintenance, management, programming and purchase of public art; grants to nonprofit organizations that enhance visitor appeal, encourage overnight stays and visitor spending in the City; and grants for public space beautification. The fund also provides revenue to the Dublin Convention and Visitor Bureau (Visit Dublin Ohio) and the Dublin Arts Council. Personnel Data Position Title 2023 | Adopted 2024 | Adopted Landscape Architect (1)0.5 0.5 Total 0.5 0.5 Notes and Adjustments: 1. This position is allocated to the budget of the Office of the Parks and Recreation Director (50%) and this budget (50%). City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 95 Public Art | Special Revenue Fund Budgeted and Historical Expenditures by Expense Type MillionsSupplies Other Charges and Expenditures Personal Services Contractual Services FY2018FY2019FY2020FY2023FY2024$0 $0.025 $0.05 $0.075 $0.1 $0.125 $0.15 $0.175 Expense Objects Personal Services Full Time Salaries/Wages 23240410- 701101 $0 $32,990 $32,990 $34,655 Employee Benefits 23240410- 701201 $0 $20,745 $20,745 $20,695 Uniforms and Clothing 23240410- 701204 $0 $200 $200 $100 Training/Travel 23240410- 702000 $0 $1,000 $1,000 $0 Total Personal Services:$0 $54,935 $54,935 $55,450 Contractual Services Other Professional Services 23240410- 713004 $0 $55,000 $55,000 $55,000 Training/Travel 23240410- 713010 $0 $0 $0 $1,000 Memberships/Subscriptions 23240410- 716000 $0 $200 $200 $200 Total Contractual Services:$0 $55,200 $55,200 $56,200 Supplies Operating Supplies 23240410- 721002 $0 $200 $200 $200 Total Supplies:$0 $200 $200 $200 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 96 Other Charges and Expenditures Special Projects/Programs 23240410- 751003 $0 $40,000 $40,000 $25,000 Total Other Charges and Expenditures:$0 $40,000 $40,000 $25,000 Total Expense Objects:$0 $150,335 $150,335 $136,850 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 232401410 (Previously 23240111) Account 701101 provides funding for staffing under Personnel Data. Account 701204 includes funding for uniform/PPE articles for staffing. Account 713004 provides funding for a consultant to advise the City on restoration and maintenance of the numerous public art pieces currently owned by the City and unscheduled repairs and installation services. The increase is for contract maintenance needs. Account 713010 (previously 702000) provides funding for professional development in public art administration. Account 751003 provides funding for multiple public art projects, including site selection, miscellaneous repairs and scheduled maintenance, and Art in Public Places site selection payment to the Dublin Arts Council. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 97 Recreation Services | Special Revenue Fund Tracey Gee Director of Recreation Services The Division of Recreation Services is responsible for delivering diverse, high-quality recreation programs and services that promote active lifestyles, learning and the arts with a focus on enhancing the quality of life throughout the community. Personnel Data Position Title 2023 | Adopted 2024 | Adopted Director of Recreation Services 0.45 0.45 Recreation Services Administrator 1.8 1.8 Recreation Program Supervisor 2 2 Recreation Operations Supervisor 0.25 0.25 Theater Supervisor 0.5 0.5 Adaptive Recreation Coordinator 0.75 0.75 Membership Services Coordinator 0.4 0.4 Recreation Program Coordinator 3.25 3.25 Recreation Operations Specialist 0.25 0.25 Administrative Support III 0.6 0.6 Total (1)10.25 10.25 Part-Time/Seasonal Staff Intern 1.07 1.07 Open Gym and Sports Programs 0 0 Pre-School / Youth Camps 17.66 17.66 Pre-School / Youth Programs 0.55 0.55 Teen Camps 3.75 3.75 Teen Programs 0.85 0.85 Adult Programs 0.32 0.32 Senior Programs / Program Assistants 1.44 1.44 Adaptive 0.3 0.3 Park Programming / Corporate 0.31 0.31 Total FTE (2)26.25 26.25 Notes and Adjustments: 1. The full-time positions are allocated between this budget, the Dublin Community Recreation Center (DCRC) budget and the Swimming Pool budget. 2. The need for an additional Recreation Program Coordinator split between Recreation, DCRC and pool remains under review. As the 2024 summer recreation and pool season approaches, the need for this position will be determined, and, if necessary, a request will be brought forward for City Council's consideration. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 98 Recreation Services Expenditures by Expense Type | Special Revenue Fund Budgeted and Historical Expenditures by Expense Type MillionsCapital Outlay Other Charges and Expenditures Supplies Contractual Services Personal Services FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $0.5 $1 $1.5 $2 $2.5 $3 $3.5 Expense Objects Personal Services Full Time Salaries/Wages 22540440- 701101 $647,824 $547,770 $547,770 $694,320 Overtime Wages 22540440- 701103 $1,518 $5,000 $5,000 $5,000 Other Wages 22540440- 701104 $482,158 $700,000 $770,000 $809,261 Employee Benefits 22540440- 701201 $364,264 $374,725 $374,725 $450,100 Uniforms and Clothing 22540440- 701204 $1,503 $11,445 $11,445 $11,708 Training/Travel 22540440- 702000 $7,421 $9,000 $11,086 $0 Total Personal Services:$1,504,688 $1,647,940 $1,720,026 $1,970,389 Contractual Services Other Professional Services 22540440- 713004 $254,157 $394,000 $416,204 $483,750 Misc. Contract. Serv.22540440- 713005 $45,474 $50,400 $50,400 $50,400 Training/Travel 22540440- 713010 $0 $0 $0 $9,000 Communications 22540440- 715001 $0 $3,000 $3,000 $1,500 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 99 Advertising 22540440- 715002 $2,937 $5,000 $5,000 $5,000 Printing and Reproductions 22540440- 715003 $7,846 $30,000 $37,479 $20,000 Memberships/Subscriptions 22540440- 716000 $2,217 $3,755 $3,755 $3,926 Rents and Leases 22540440- 717001 $39,788 $109,890 $112,451 $137,945 Total Contractual Services:$352,419 $596,045 $628,289 $711,521 Supplies Office Supplies 22540440- 721001 $5,265 $12,000 $12,250 $12,000 Operating Supplies 22540440- 721002 $42,649 $103,240 $123,040 $108,429 Equipment Maintenance 22540440- 724003 $210 $1,000 $1,790 $3,500 Total Supplies:$48,124 $116,240 $137,080 $123,929 Capital Outlay Furniture/Equipment 22580440- 731000 $3,975 $0 $49,677 $3,500 Sports and Recreation Equipmen 22580440- 734003 $2,507 $0 $0 $0 Total Capital Outlay:$6,482 $0 $49,677 $3,500 Other Charges and Expenditures Special Events 22540440- 751002 $2,910 $29,480 $150,730 $35,000 Sr. Citizen Activities 22540440- 751014 $23,074 $29,500 $32,770 $29,909 Refunds 22540440- 755000 $2,766 $25,000 $25,000 $25,000 Total Other Charges and Expenditures:$28,751 $83,980 $208,500 $89,909 Total Expense Objects:$1,940,464 $2,444,205 $2,743,572 $2,899,248 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 100 Budget Summary 22540440 Account 701101 provides funding for full-time staff allocated to this budget under Personnel Data and in the Notes and Adjustments section. Account 701103 provides funding for overtime. Account 701104 provides funding for part-time and seasonal staff wages. The increase in FTE is due to re-structuring of Part-Time wage structures to ensure competitive pay. Overall, FTE is lower due to the movement of Open Gym Supervisor funding to the Dublin Community Recreation Center (DCRC) budget. Account 713004 provides for other professional services. Increases are due to new offerings for golf, badminton, pickleball and senior trips, and increased costs for camps and field trips will be recovered through program fees. Account 713005 provides funding for fees to accept credit cards (50/50 allocated between this budget and the DCRC budget). Account 713010 (previously 702000) provides funding for conferences and mileage. Account 715001 provides funding for paper and ink for plotters. Account 715002 includes funding for new program promotions. Account 715003 includes funding for the Healthy Brochure (split between this budget and the Dublin Community Recreation Center budget) and will include pages for the Dublin City Schools community education programs as part of the partnership between the City and Dublin City Schools. Account 716000 provides funding for memberships and subscriptions. Account 717001 provides funding for school custodial, A/C and buses from Dublin City Schools for summer camps, passenger bus rentals for senior programs, and mail and copy machine rentals. Account 721002 provides funding for supplies for summer camp programs, special needs programs, teen programs and adult programs and youth programs. Funds were moved for gym and teen lounge supplies to DCRC budget. Increases are due to movement of funds from the DCRC budget for arts and craft supplies to the REC budget. Account 724003 provides funding for kiln and pottery wheel repair. Account 751002 provides funding for community wellness programs. For an increase for funding for consultants for community wellness initiatives, funds were adjusted throughout the rest of the budget for an overall zero-net increase. Account 751013 provides funding for sports leagues, including league officials, and for the revenue split with Dublin City Schools for the use of tennis courts for a tennis league. Account 751014 provides funding for senior citizen activities and programming, such as dance events, monthly meetings, event supplies and holiday parties. Account 755000 provides funding for refunds. 22580440 Account 731000 provides funding for senior lounge equipment and furniture. Teen lounge costs have moved to the DCRC account. Account 734003 provides funding for softball, basketball and volleyball leagues, which has been moved to the DCRC account. 22596290 Account 741000 provides funding for the transfer of debt to Recreation Capital. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 101 Community Recreation Center | Special Revenue Fund Tracey Gee Director of Recreation Services The Dublin Community Recreation Center (DCRC) is a well-managed, efficiently operated, state-of-the-art facility providing the highest standards of organized and open leisure activities to the residents of Dublin and Dublin City School District residents. Through well-planned facility management and programming, the DCRC is committed to the highest level of service for internal and external customers. Personnel Data Position Title 2023 | Adopted 2024 | Adopted Director of Recreation Services 0.5 0.5 Recreation Services Administrator 1.9 1.9 Recreation Program Supervisor 1.65 1.65 Recreation Operations Supervisor 0.75 0.75 Theater Supervisor 0.50 0.50 Adaptive Recreation Coordinator 0.25 0.25 Membership Services Coordinator 0.6 0.6 Recreation Program Coordinator 3.4 3.4 Recreation Operations Specialist 0.75 0.75 Administrative Support III 0.4 0.4 Total 10.7 10.7 Part-Time/Seasonal Staff Reservation Facility Workers 2.1 2.1 Fitness / Wellness 7.13 7.13 Aquatics 21.22 21.22 Babysitters 5.9 5.9 Wee Folk Room Front Desk 1.59 1.59 Front Desk 9.3 9.3 Theater Staff 2.24 2.24 Manager on Duty 1.62 1.62 Interns 0.48 0.48 Teen Lounge 0.9 0.9 Open Gym / Sports Programs 2.18 2.18 Total FTE 54.23 54.23 City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 102 Community Recreation Center Expenditures by Expense Type | Special Revenue Fund Budgeted and Historical Expenditures by Expense Type MillionsOther Charges and Expenditures Capital Outlay Supplies Contractual Services Personal Services FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $1 $2 $3 $4 $5 Expense Objects Personal Services Full Time Salaries/Wages 22540441- 701101 $687,066 $772,880 $772,880 $642,185 Overtime Wages 22540441- 701103 $5,124 $9,000 $9,000 $8,700 Other Wages 22540441- 701104 $1,313,645 $1,415,450 $1,540,450 $1,732,459 Employee Benefits 22540441- 701201 $506,303 $544,900 $544,900 $554,475 Uniforms and Clothing 22540441- 701204 $9,307 $11,000 $11,000 $14,148 Training/Travel 22540441- 702000 $10,783 $22,445 $31,657 $0 Total Personal Services:$2,532,227 $2,775,675 $2,909,887 $2,951,967 Contractual Services Other Professional Services 22540441- 713004 $142,211 $199,790 $258,908 $221,498 Misc. Contract. Serv.22540441- 713005 $33,821 $56,400 $57,954 $56,400 Training/Travel 22540441- 713010 $0 $0 $0 $29,850 Communications 22540441- 715001 $305 $2,000 $2,000 $0 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 103 Advertising 22540441- 715002 $3,852 $8,400 $8,400 $9,500 Printing and Reproductions 22540441- 715003 $7,873 $27,000 $26,479 $17,000 Memberships/Subscriptions 22540441- 716000 $2,739 $3,460 $3,460 $533 Rents and Leases 22540441- 717001 $2,317 $3,400 $4,161 $500 Utilities- Other Fuel Types 22540441- 717005 $581,434 $510,000 $605,829 $600,000 Total Contractual Services:$774,552 $810,450 $967,192 $935,281 Supplies Office Supplies 22540441- 721001 $13,791 $19,150 $21,294 $19,150 Operating Supplies 22540441- 721002 $43,658 $60,605 $66,704 $74,675 Merchandise for Resale 22540441- 723004 $2,541 $5,950 $5,950 $6,120 Other Program Supplies 22540441- 723005 $26,301 $37,845 $38,494 $44,571 General Maintenance 22540441- 724001 $34,590 $85,030 $96,690 $52,956 Equipment Maintenance 22540441- 724003 $3,342 $5,500 $5,500 $8,300 Total Supplies:$124,223 $214,080 $234,631 $205,772 Capital Outlay Tools 22540441- 734002 $265 $2,250 $2,250 $2,250 Sports and Recreation Equipmen 22540441- 734003 $154,879 $89,150 $22,077 $91,100 Furniture/Equipment 22580441- 731000 $25,189 $53,750 $63,939 $53,750 Total Capital Outlay:$180,332 $145,150 $88,266 $147,100 Other Charges and Expenditures Refunds 22540441- 755000 $2,483 $40,000 $40,000 $40,000 Total Other Charges and Expenditures:$2,483 $40,000 $40,000 $40,000 Total Expense Objects:$3,613,817 $3,985,355 $4,239,975 $4,280,120 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 104 Budget Summary 22540441 Account 701101 provides funding for full-time staff allocated to this budget as reflected in the Personnel Data and Notes and Adjustments. Account 701104 provides funding for part-time and seasonal staff wages. The increase is due to re-structuring of part-time wage structure to ensure competitive pay and increased hours due to movement of Open Gym Supervisor to DCRC budget from REC budget. Additional hours for re-certification year for staff resulting in more required training. Increased offerings include lifeguard classes, water fitness, theater productions and programs. Account 713004 includes funding for other professional services. Increases are due to services tied to production, with off-setting donated funding. Account 713005 provides funding for cable for the DCRC and fees to accept credit cards (50/50 allocated between this budget and the REC budget). Account 713010 (previously 702000) includes funding for staff continuing education/conferences and American Red Cross certifications. Account 715001 provides funding for paper and ink for plotters, senior newsletter and postage. Account 715002 provides funding; advertising decreased due to targeted social media advertising for theatre initiatives. Account 715003 includes funding for the Healthy Brochure (split between this budget and the Recreation budget) and will include additional pages for the Dublin City Schools community education programs as part of the partnership between the City and Dublin City Schools. Account 716000 provides funding for fitness floor magazines, newspapers and subscriptions. Account 717001 includes funding for rental of a postage machine. Account 721001 provides funding for membership supplies and general office supplies for staff. Account 721002 provides funding for pool chlorine, CO2 and reagents, advanced water quality testing and theater supplies. Account 723005 provides funding for program supplies, such as arts and crafts supplies, aquatic participant certificates, birthday party package supplies and various training manuals. Account 724001 provides funding for repairs and preventive maintenance for pool mechanicals, fitness equipment and maintenance for fitness studios. Increase is due to replacement of cardio room carpet and TV units for the fitness floor. Account 724003 provides funding for community hall and theater equipment repair. Account 734003 provides funding to replace heavily used fitness equipment per the rotation schedule of equipment and the equipment replacement plan. Also, it includes replacement of the oldest elliptical trainers, treadmills and steppers. Also, it includes MyZone supplies. All equipment being replaced will be placed into service at other employee fitness rooms and/or posted online for resale through GovDeals. Funds moved for league operations from REC budget to DCRC budget. 22580441 Account 731000 includes funding for community hall tables and chairs, lobby furniture, lap pool lane lines and lighting board replacement for the theater. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 105 Special Revenue Fund | Municipal Outdoor Swimming Pools Tracey Gee Director of Recreation Services The Dublin North and South Community Pools are seasonal operations that provide the community with diverse, aquatic-related recreation opportunities. Pool facilities include a lap pool, a leisure playing pool, tot pool, waterslides, diving boards, a concession stand and a water play/spray area. The operation of the Ballantrae Spray Park was added to the Dublin Municipal Pool Budget in 2012. Personnel Data Position Title 2023 | Adopted 2024 | Adopted Director of Recreation Services 0.05 0.05 Recreation Services Administrator 0.3 0.3 Recreation Supervisor 0.35 0.35 Recreation Program Coordinator 0.35 0.35 Total 1.05 1.05 Part-Time/Seasonal Staff Pool Manager 1.41 1.41 Service Manager 0.48 0.48 Assistant Concession Manager 0.85 0.85 Lifeguard 12.89 12.89 Desk Staff / Concession Staff 4.74 4.74 Swim / Fitness Instructors 0.35 0.35 Total FTE 20.72 20.72 City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 106 Special Revenue Fund | Municipal Outdoor Swimming Pools Budgeted and Historical Expenditures by Expense Type MillionsOther Charges and Expenditures Capital Outlay Supplies Contractual Services Personal Services FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $0.25 $0.5 $0.75 $1 $1.25 $1.5 Expense Objects Personal Services Full Time Salaries/Wages 22640440- 701101 $60,839 $40,020 $40,020 $66,830 Overtime Wages 22640440- 701103 $3,323 $3,000 $3,000 $4,000 Other Wages 22640440- 701104 $420,979 $500,000 $561,900 $608,312 Employee Benefits 22640440- 701201 $83,487 $93,615 $93,615 $121,105 Uniforms and Clothing 22640440- 701204 $11,783 $13,000 $18,100 $18,500 Training/Travel 22640440- 702000 $192 $765 $765 $0 Total Personal Services:$580,603 $650,400 $717,400 $818,747 Contractual Services Other Professional Services 22640440- 713004 $1,678 $1,685 $2,807 $2,583 Misc. Contract. Serv.22640440- 713005 $5,369 $5,500 $4,378 $5,500 Training/Travel 22640440- 713010 $0 $0 $0 $578 Communications 22640440- 715001 $0 $500 $500 $500 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 107 Utilities- Other Fuel Types 22640440- 717005 $205,478 $200,000 $236,345 $225,000 Concessions Vendor Services 22640440- 719004 $64,624 $80,500 $80,500 $70,000 Total Contractual Services:$277,149 $288,185 $324,530 $304,161 Supplies Operating Supplies 22640440- 721002 $14,157 $16,380 $16,380 $17,115 Pool Supplies/Chemicals 22640440- 723002 $31,935 $35,000 $37,672 $35,000 Other Program Supplies 22640440- 723005 $1,320 $1,560 $1,560 $1,718 General Maintenance 22640440- 724001 $41,578 $50,000 $55,365 $112,500 Total Supplies:$88,990 $102,940 $110,977 $166,333 Capital Outlay Furniture/Equipment 22680440- 731000 $130,152 $141,150 $74,150 $66,454 Total Capital Outlay:$130,152 $141,150 $74,150 $66,454 Other Charges and Expenditures Refunds 22640440- 755000 $0 $1,600 $1,600 $1,600 Total Other Charges and Expenditures:$0 $1,600 $1,600 $1,600 Total Expense Objects:$1,076,894 $1,184,275 $1,228,657 $1,357,296 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 22640440 Account 701101 provides funding for full-time staff allocated to this budget in the Notes and Adjustments section. Account 701104 provides funding for seasonal staff wages based on pool operating schedules. The increase is due to changes in wage structure to ensure competitive pay. Increased hours are attributed to pre-season training. Account 713004 provides funding for pool and food licenses. Account 713005 provides funding for credit card charges and family programs. Account 715001 provides funding for replacement radios. Account 717005 provides funding for utilities for the outdoor municipal pool facilities. Account 719004 provides funding for supplies to stock the concession stands at the pool facilities. Expenses for supplies are offset by revenues generated. Account 721002 provides funding for dumpster rentals and advanced water quality testing. Account 723002 provides funding for pool chemicals, such as chlorine and CO2. Account 724001 provides funding for general maintenance and repairs. 22680440 Account 731000 includes funding for safety equipment and miscellaneous supplies. The increase is due to replacement of gutters and slide tower tread replacement at South Pool. Storage in concessions and the lifeguard office at the North Pool were not included in the build. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 108 Community Events | Special Revenue Fund Alison LeRoy Director of Community Events The Division of Community Events is responsible for the management and execution of Dublin's signature events, including St. Patrick’s Day, Independence Day, Dublin Irish Festival, Spooktacular and the Tree Lighting. Dublin's signature events enhance the City’s international image, enrich quality of life in the community, provide fundraising opportunities for community organizations, and support the mission of Visit Dublin Ohio (Dublin's destination marketing organization) by attracting overnight visitors to Dublin. Personnel Data Position Title 2023 | Adopted 2024 | Adopted Director of Community Events 1 1 Events Administrator (1)2.5 2.5 Events Coordinator (1)3.5 3.5 Total 7 7 Part-Time/Seasonal Staff Events Specialist 0.25 0.25 Administrative Assistant - Seasonal (2)1 1 Summer Events Worker 1 1 Total FTE 2.25 2.25 Notes and Adjustments: 1. One half of the Events Administrator position and one Events Coordinator position are shown in this budget. Their salaries are split 50% toward recreation and 50% toward this fund. 2. The seasonal Administrative Assistant position accounts for a total of 1.75 FTE. One FTE is included in this Community Events budget and 0.75 FTE is included in the Recreation Services Community Events budget. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 109 Special Revenue Fund | Community Events Budgeted and Historical Expenditures by Expense Type MillionsOther Charges and Expenditures Supplies Personal Services Contractual Services FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $1 $2 $3 $4 $5 Expense Objects Personal Services Full Time Salaries/Wages 23240450- 701101 $453,144 $491,410 $491,410 $518,870 Overtime Wages 23240450- 701103 $5,672 $13,000 $13,000 $5,000 Other Wages 23240450- 701104 $39,523 $75,000 $75,000 $75,000 Employee Benefits 23240450- 701201 $238,512 $279,875 $279,875 $260,680 Uniforms and Clothing 23240450- 701204 $24,128 $23,850 $23,526 $21,400 Training/Travel 23240450- 702000 $7,759 $11,000 $11,009 $0 Meeting Expenses 23240450- 703100 $995 $1,500 $2,250 $0 Total Personal Services:$769,734 $895,635 $896,070 $880,950 Contractual Services Other Professional Services 23240450- 713004 $2,559,664 $2,300,000 $2,300,705 $2,310,100 Misc. Contract. Serv.23240450- 713005 $150,955 $225,000 $280,000 $272,500 Training/Travel 23240450- 713010 $0 $0 $0 $18,050 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 110 Insurance and Bonding 23240450- 714001 $2,011 $4,000 $4,000 $4,000 Communications 23240450- 715001 $4,198 $5,200 $5,200 $5,000 Advertising 23240450- 715002 $67,468 $65,000 $65,000 $73,000 Printing and Reproductions 23240450- 715003 $9,503 $9,850 $9,850 $10,150 Memberships/Subscriptions 23240450- 716000 $2,435 $3,625 $3,625 $2,725 Total Contractual Services:$2,796,233 $2,612,675 $2,668,380 $2,695,525 Supplies Office Supplies 23240450- 721001 $12,770 $12,500 $12,550 $12,500 Operating Supplies 23240450- 721002 $344,785 $425,000 $377,869 $376,800 Events Merchandise for Resale 23240450- 721005 $23,416 $50,250 $50,250 $52,000 Meeting Expenses 23240450- 721006 $0 $0 $0 $1,750 Total Supplies:$380,971 $487,750 $440,669 $443,050 Other Charges and Expenditures Special Projects/Programs 23240450- 751003 $6,043 $41,250 $41,250 $70,250 Promotional Programs 23240450- 751012 $7,346 $11,900 $11,900 $8,100 Volunteer Programs 23240450- 751016 $9,752 $15,000 $15,000 $18,800 Total Other Charges and Expenditures:$23,141 $68,150 $68,150 $97,150 Total Expense Objects:$3,970,079 $4,064,210 $4,073,269 $4,116,675 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 111 Budget Summary 23240450 Account 701101 provides funding for staffing under Personnel Data and in the Notes and Adjustments section. Account 701103 provides funding for overtime, of which approximately 95% occurs in July and August to support the City’s two largest events. Account 701104 includes funding for part-time/seasonal staff. Account 701204 provides funding for uniforms for staff and all volunteers and participants. Account 713004 includes professional services for City-sponsored events, including photography, marketing and marketing services and graphic design; ASCAP and BMI and SEASAC music licensing; entertainment and activities, including fireworks, children’s games, parade floats, exhibitors, musicians and dancers. Operational services include sound and electrical professionals, cleaning services, hotels for entertainers, patron shuttle service, rentals including tents, generators, ice trucks, lights, port-a-johns, stages, tables, chairs and golf carts. Some specific lines have been moved from this account to contractual services. Account 713005 includes funding for credit card fees used at events as well as rental of an off-site storage facility, rental of beverage payment system equipment and Wi-Fi services for Coffman Park for the Dublin Irish Festival (DIF). In addition, significant increase is shown due to moving some lines from professional services to this account, including revenue sharing with nonprofit beverage server groups. Account 713010 (previously 702000) provides funding for staff training and conferences. Figures represent a return to normal travel funding post-pandemic. Account 714001 provides funding for an alcohol liability policy to cover all DIF fundraising groups. Account 715001 is used for rental radios and courier services. Account 715002 includes funds for DIF advertising. Account 715003 includes funds for DIF print materials including brochures, tickets and onsite guides. Account 721001 includes general office supplies and paper for signage for events. Plotter paper and ink is also used by Parks, GIS and other divisions in buildings. Account 721002 includes funding for float supplies, prizes, crafts, helium, table coverings, signage, wristbands and beverages to sell at DIF (which accounts for the majority of the funding in this account). Beverage sales generate significant offsetting revenue. Beverage purchases are budgeted based on the averages of costs in previous years. Account 721005 was added in 2022 and provides funding to purchase merchandise to resell at the Dublin Irish Festival. Account 721006 (previously 703100) provides funding for committee and sponsorship meetings. Account 751003 provides funding for committee ceremonial needs, funding for the DIF scholarship and sustainability efforts and additional accessibility services at events. Additions this year are due to funding for an economic impact study which is done every five years and for a one-time artist fee to create a piece of artwork using old tokens. Account 751012 provides funding for DIF promotional activities. Account 751005 includes funding for DIF volunteer programs, including recognition awards and events. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 112 Recreation Services – Community Events | Special Revenue Fund Alison LeRoy Director of Community Events In addition to executing the City's signature events, Community Events is responsible for permitting tournaments, external community events and sports leagues that use the sports fields and block party packages. Division staff ensures external event organizers follow guidelines and City ordinances and coordinate City staff support for external events when necessary. The division is also responsible for the reservation of outdoor shelter houses, sports fields, the Kaltenbach Community Center and other various park spaces. Personnel Data Position Title 2023 | Adopted 2024 | Adopted Events Administrator (1)0.5 0.5 Events Coordinator (1)0.5 0.5 Total 1 1 Part-Time/Seasonal Staff Administrative Assistant - Seasonal 0.75 0.75 Facilities Reservation Manager 0.75 0.75 Total FTE 1.5 1.5 Notes and Adjustments: 1. The Events Administrator position, Events Coordinator position and Administrative Assistant position are split 50% into the Hotel/Motel Fund and 50% into this fund due to the nature of their duties. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 113 Recreation Services - Community Events Expenditures by Expense Type | Special Revenue Fund Budgeted and Historical Expenditures by Expense Type MillionsCapital Outlay Supplies Contractual Services Other Charges and Expenditures Personal Services FY2019FY2020FY2021FY2022FY2023FY2024$0 $0.025 $0.05 $0.075 $0.1 $0.125 $0.15 $0.175 Expense Objects Personal Services Full Time Salaries/Wages 22540450- 701101 $67,148 $68,510 $68,510 $70,230 Overtime Wages 22540450- 701103 $13 $400 $400 $500 Other Wages 22540450- 701104 $27,458 $30,750 $30,750 $35,000 Employee Benefits 22540450- 701201 $36,970 $36,955 $36,955 $37,325 Uniforms and Clothing 22540450- 701204 $295 $300 $305 $300 Total Personal Services:$131,885 $136,915 $136,920 $143,355 Contractual Services Other Professional Services 22540450- 713004 $960 $1,200 $7,200 $4,700 Total Contractual Services:$960 $1,200 $7,200 $4,700 Supplies Operating Supplies 22540450- 721002 $589 $900 $900 $900 General Maintenance 22540450- 724001 $0 $1,000 $1,000 $1,000 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 114 Total Supplies:$589 $1,900 $1,900 $1,900 Capital Outlay Tools 22540450- 734002 $0 $0 $0 $1,000 Furniture/Equipment 22580450- 731000 $47 $0 $0 $0 Tools 22580450- 734002 $2,493 $1,000 $1,000 $0 Total Capital Outlay:$2,541 $1,000 $1,000 $1,000 Other Charges and Expenditures Refunds 22540450- 755000 $0 $5,000 $5,000 $5,000 Total Other Charges and Expenditures:$0 $5,000 $5,000 $5,000 Total Expense Objects:$135,974 $146,015 $152,020 $155,955 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 22540450 Account 701101 provides funding for staffing under Personnel Data and in the Notes and Adjustments section. Account 701104 includes funding for part-time/seasonal staff. This staff monitors the usage of parks and the staff at the Kaltenbach facility. Account 701204 provides funding for uniforms for all staff. Account 713004 provides funding for software to coordinate rentals and park usage and Showmobile appearance upgrades. Account 721002 includes funding for supplies for field usage and rental facilities. Account 724001 includes funding for repairs and improvements to rental facilities. Account 755000 provides funds for a refund of deposits on rental facilities. 22580450 Account 734002 provides funding for block party replacements. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 115 Community Events – Other Work Units and Grants | Special Revenue Fund Alison LeRoy Director of Community Events The following accounts include budget items from City divisions which are supported by hotel/motel tax fees either as grants, assistance for the Community Events Division or capital costs. These activities are focused on the support of Dublin's special events. Personnel Data There are no direct personnel assigned to these funds. Oversight is provided by the Director of Community Events. Special Revenue Funds | Community Events - Other Work Units and Grants Budgeted and Historical Expenditures by Function MillionsFacilities Management Park Operations Streets and Utility Operations Park Operations Security of Persons/Property Finance Administration FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $0.5 $1 $1.5 $2 Expenditures Leisure Activities Finance Administration Accounting/Auditing Services 23240210- 713001 $0 $5,000 $5,000 $5,000 Misc. Contract. Serv.23240210- 713005 $45,000 $0 $105,000 $0 Grants/Community Org 23240210- 754002 $229,571 $225,000 $285,451 $225,000 Grants/DAC 23240210- 754003 $879,558 $770,000 $770,000 $900,000 Grants/DCVB 23240210- 754004 $319,333 $0 $0 $360,000 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 116 Grant/Bridge Park NCA 23240210- 754005 $128,702 $200,000 $200,000 $300,000 Total Finance Administration:$1,602,163 $1,200,000 $1,365,451 $1,790,000 Streets and Utility Operations Operating Supplies 23240330- 721002 $10,000 $20,000 $20,000 $20,000 Total Streets and Utility Operations:$10,000 $20,000 $20,000 $20,000 Park Operations Operating Supplies 23240430- 721002 $34,747 $37,250 $39,696 $37,250 Total Park Operations:$34,747 $37,250 $39,696 $37,250 Total Leisure Activities:$1,646,910 $1,257,250 $1,425,147 $1,847,250 Security of Persons/Property Operations Misc. Contract. Serv.23250820- 713005 $38,328 $45,000 $45,000 $45,000 Total Operations:$38,328 $45,000 $45,000 $45,000 Total Security of Persons/Property:$38,328 $45,000 $45,000 $45,000 Capital Outlay Park Operations Park and Bikeway Improvements 23280430- 735005 $26,020 $0 $16,760 $0 Total Park Operations:$26,020 $0 $16,760 $0 Total Capital Outlay:$26,020 $0 $16,760 $0 Total Expenditures:$1,711,257 $1,302,250 $1,486,907 $1,892,250 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 117 Budget Summary The following four accounts include budget items from other divisions that have been allocated to Community Events. This allocation provides a more complete reflection of the direct costs associated with events. 23240210 – Finance Account 701201 provides uniforms for special events. (Removed for 2024) Account 713001 provides funding for accounting/auditing services. Account 713005 provides funding for an armored car pickup of cash during the Dublin Irish Festival (DIF) weekend and other miscellaneous needs. (Removed for 2024) Account 751001 provides an allocation for City-sponsored art projects in the event that a study or design is initiated by City Council. In most cases, a supplemental appropriation would be needed to complete the art project. Account 754002 provides an allocation for grants to community organizations in accordance with the Hotel/Motel Grant Application Guidelines. Account 754003 provides funding for distribution with the Dublin Arts Council (DAC) in accordance with the lease agreement executed for 7125 Riverside Drive. Account 754005 provides funding for the Bridge Park New Community Authority (NCA) in accordance with the Bridge Park Development Agreement. 23240330 – Public Service - Street Operations Account 721002 includes funding for Streets Operations for special event materials, such as gravel, barrier walls, cones and freestanding fencing. 23240430 – Park Operations Account 721002 includes funding for Park Operations for mulch, trash bags and materials needed for events, and grass seed to repair event turf area after the events. 23250820 - Police Account 713005 includes funding for police for private security hired for Independence Day and DIF events. The increases are due to additional private security to cover more areas of the events. The following accounts include budget amounts from the Five-Year Capital Improvements Program (CIP) for projects to be paid from Hotel/Motel Tax Funds. 23280410 – Park & Recreation Operations - Capital Account 735005 includes funding for public art maintenance. 23280430 – Park Operations - Capital Account 735005 includes funding for capital projects as programmed in the Five-Year Capital Improvements Program (CIP). City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 118 Outreach & Engagement | General Fund Christine Nardecchia Director of Outreach & Engagement The Division of Outreach and Engagement supports the achievement of meaningful, inclusive community engagement through innovative service, learning and support opportunities that enhance Dublin's services and quality of life for residents and visitors. Personnel Data Position Title 2023 | Adopted 2024 | Adopted Director of Outreach & Engagement 1 1 Nature Education Coordinator 1 1 Outreach and Engagement Coordinator 2 2 Total 4 4 Part-Time/Seasonal Staff Intern 1 1 Total 1 1 City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 119 Outreach and Engagement Expenditures by Expense Type | General Fund Budgeted and Historical Expenditures by Expense Type MillionsSupplies Other Charges and Expenditures Contractual Services Personal Services FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $0.1 $0.2 $0.3 $0.4 $0.5 $0.6 $0.7 Expense Objects Personal Services Full Time Salaries/Wages 10110420- 701101 $287,090 $291,025 $291,025 $294,735 Overtime Wages 10110420- 701103 $1,335 $3,000 $3,000 $1,500 Other Wages 10110420- 701104 $19,303 $12,720 $10,220 $10,000 Employee Benefits 10110420- 701201 $105,090 $104,390 $104,390 $103,170 Uniforms and Clothing 10110420- 701204 $491 $1,200 $1,200 $1,200 Training/Travel 10110420- 702000 $512 $3,000 $5,500 $0 Meeting Expenses 10110420- 703100 $1,214 $500 $500 $0 Total Personal Services:$415,036 $415,835 $415,835 $410,605 Contractual Services Other Professional Services 10110420- 713004 $10,444 $74,600 $74,600 $95,000 Training/Travel 10110420- 713010 $0 $0 $0 $6,000 Printing and Reproductions 10110420- 715003 $2,893 $4,000 $4,772 $3,000 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 120 Memberships/Subscriptions 10110420- 716000 $65 $400 $700 $800 Rents and Leases 10110420- 717001 $925 $1,500 $1,200 $1,500 Total Contractual Services:$14,327 $80,500 $81,272 $106,300 Supplies Office Supplies 10110420- 721001 $1,588 $1,625 $2,054 $2,500 Operating Supplies 10110420- 721002 $8,459 $9,500 $9,500 $5,000 Meeting Expenses 10110420- 721006 $0 $0 $0 $1,000 Total Supplies:$10,047 $11,125 $11,554 $8,500 Other Charges and Expenditures Special Projects/Programs 10110420- 751003 $41,758 $75,500 $76,342 $85,500 Total Other Charges and Expenditures:$41,758 $75,500 $76,342 $85,500 Total Expense Objects:$481,168 $582,960 $585,003 $610,905 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 10110420 Account 701101 provides funding for full-time staffing reflected in the Personnel Data. Account 701103 provides overtime funding to supervise service projects, many of which take place on weekends and during the evening hours. Account 701104 provides funding for seasonal staff and/or interns. Account 701204 provides an increase to fund web-based portal services for citywide volunteers. Account 713004 provides funding for necessary background checks for all volunteer positions, specialty training, language translation services, and the SCRAM wildlife services agreement, which was previously budgeted in the Park Operations budget. Account 715003 provides funding for printing needs, such as training manuals; signage and posters; identification badges, cards and specialty papers; photography and miscellaneous printing/copying needs. Account 717001 provides for any needed rental items (such as portable restrooms) for outdoor projects. Account 721002 provides funding for operating supplies, such as safety lights, protective gloves/goggles, identification badge materials, first aid supplies, nature education materials and other necessary supplies for volunteer projects. Account 751003 provides funding for Citizen University, Citizen University Jumpstart, citywide volunteer and corporate volunteer recognition, programs and award items, and citywide Aging in Place (Forever Dublin) initiatives. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 121 Public Service Jason Anderson Director of Public Service Providing essential services to the community through the sustainable maintenance and enhancement of resources and infrastructure. Departmental budget information can be found on the individual fund pages. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 122 Parks and Grounds Maintenance | General Fund Jay Anderson Director of Public Service The City of Dublin takes pride in providing its residents and visitors the highest quality public parks to pursue their active and passive outdoor needs. Parks and Grounds Maintenance strives to be both environmentally and economically sound in its management of public areas, including parks, gateways and open space. Personnel Data Position Title 2023 | Adopted 2024 | Adopted Director of Public Service (1)0.35 0.35 Operations Administrator 2 2 Maintenance Crew Supervisor 4 4 Maintenance Worker 20 20 Administrative Support II 1 1 Total 27.35 27.35 Part-Time/Seasonal Staff Seasonal Maintenance Worker 24 24 Total 24 24 Notes and Adjustments: 1. The Director of Public Service is allocated 35% to this budget, 30% to the Solid Waste budget and 35% to the Streets Fund. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 123 Parks and Grounds Maintenance Expenditures by Expense Type | General Fund Budgeted and Historical Expenditures by Expense Type MillionsOther Charges and Expenditures Capital Outlay Supplies Contractual Services Personal Services FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $1 $2 $3 $4 $5 $6 $7 Expense Objects Personal Services Full Time Salaries/Wages 10140430- 701101 $1,977,709 $1,800,555 $1,800,555 $1,928,340 Overtime Wages 10140430- 701103 $151,369 $115,000 $145,000 $115,000 Other Wages 10140430- 701104 $313,165 $375,000 $220,000 $375,000 Employee Benefits 10140430- 701201 $1,082,358 $1,061,415 $1,061,415 $1,066,060 Uniforms and Clothing 10140430- 701204 $25,015 $45,360 $59,639 $44,460 Training/Travel 10140430- 702000 $3,775 $10,375 $10,375 $0 Total Personal Services:$3,553,391 $3,407,705 $3,296,984 $3,528,860 Contractual Services Misc. Contract. Serv.10140430- 713005 $1,659,536 $128,695 $252,042 $133,995 Training/Travel 10140430- 713010 $0 $0 $0 $7,500 Communications 10140430- 715001 $47 $200 $200 $200 Memberships/Subscriptions 10140430- 716000 $1,221 $2,885 $2,885 $1,475 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 124 Utilities- Other Fuel Types 10140430- 717005 $414,444 $376,750 $466,884 $505,000 Total Contractual Services:$2,075,249 $508,530 $722,011 $648,170 Supplies Office Supplies 10140430- 721001 $4,477 $5,000 $6,624 $5,000 Operating Supplies 10140430- 721002 $33,349 $48,800 $51,687 $47,300 Reforestation 10140430- 722001 $0 $25,000 $125,000 $25,000 Park Maintenance 10140430- 724002 $192,238 $217,000 $239,576 $217,000 Equipment Maintenance 10140430- 724003 $90,402 $95,000 $105,100 $95,000 Total Supplies:$320,466 $390,800 $527,987 $389,300 Capital Outlay Tools 10140430- 734002 $4,203 $7,000 $7,000 $8,000 Furniture/Equipment 10180430- 731000 $20,951 $0 $20,475 $42,000 Land and Land Improvements 10180430- 735001 $19,991 $20,000 $20,000 $25,000 Total Capital Outlay:$45,145 $27,000 $47,475 $75,000 Other Charges and Expenditures Special Projects/Programs 10140430- 751003 $205 $3,400 $3,400 $4,000 Total Other Charges and Expenditures:$205 $3,400 $3,400 $4,000 Total Expense Objects:$5,994,456 $4,337,435 $4,597,857 $4,645,330 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 125 Budget Summary 10140430 Account 701101 provides funding for staffing reflected in the Personnel Data. Account 701104 includes funding for seasonal staffing reflected in the Personnel Data and Notes and Adjustments section. Account 701204 provides funding for uniforms for full-time and seasonal staff. Account 713005 provides funding for contractual services for all supplemental contract mulching, winter work, various HOA contracts, lightening prediction service, pond maintenance, masonry repairs and SCRAM wildlife agreements/services. Landscape maintenance contracts were moved to the Office of the Parks and Recreation Director. Account 713010 (previously 702000) includes funding for training for full-time staff to support parks operations. Included is education to provide recertification credits for professional certifications, as well as pesticide applicator credits and staff training and development. Account 716000 provides funding for such memberships and renewals as commercial drivers’ license, pesticide license renewal, trapping license renewal and reference materials. Account 717005 provides funding for electricity, natural gas and water and sewer charges for services provided in the City’s parks. Account 721002 provides funding for supplies, such as lumber, hardware, electric and plumbing supplies and trash bags. Account 724002 provides funding for ball diamond infield materials, sod, grass seed, mulch, fertilizer and snow and ice chemicals. Account 724003 provides funding for equipment maintenance and repair, including contingency work associated with Ballantrae water play area, pond aerators and irrigation systems. Account 734002 provides funding for power tool replacement and crew specific tool replacement. Account 751003 provides funding for dedication pavers/engraving for the Grounds of Remembrance (recovered through fee collection). 10180430 Account 731000 includes funding for replacement/additional picnic tables, benches and trash cans. This includes funds for new/replacement park signs as needed and replacement of weed trimmers and blowers. Account 735001 includes funding for continued updates and improvements of in-ground irrigation systems on athletic fields. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 126 Solid Waste Management | General Fund Jay Anderson Director of Public Service The City of Dublin is a regional leader in its focus on environmental sustainability. In line with its commitment to environmental sustainability, Dublin provides a comprehensive solid waste management program. This program provides services for Dublin residents with an emphasis on reduction, reuse, recycling, beautification and providing the highest level of customer service. The solid waste management program also ensures Dublin's compliance with all solid waste management rules and regulations. Personnel Data Position Title 2023 | Adopted 2024 | Adopted Director of Public Service (1)0.3 0.3 Operations Administrator 1 1 Maintenance Crew Supervisor (2)0.8 0.8 Maintenance Worker 4 4 Administrative Support II (3)0.5 0.5 Total 6.6 6.6 Part-Time/Seasonal Staff Seasonal Maintenance Worker 1 1 Total 1 1 Notes and Adjustments: 1. The Director of Public Service position is allocated 30% to this budget, 35% to the Street Maintenance Fund and 35% and 35% to Parks and Grounds Maintenance. 2. One Maintenance Crew Supervisor position is allocated 80% to this budget and 20% to the Street Fund. 3. Administrative Support II is shared between the Solid Waste Management and Street Maintenance functions. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 127 Solid Waste Management Expenditures by Expense Type | General Fund Budgeted and Historical Expenditures by Expense Type MillionsCapital Outlay Supplies Contractual Services Personal Services Other Charges and Expenditures FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $1 $2 $3 $4 $5 $6 Expense Objects Personal Services Full Time Salaries/Wages 10130340- 701101 $470,612 $456,140 $456,140 $455,150 Overtime Wages 10130340- 701103 $37,619 $40,000 $40,000 $30,000 Other Wages 10130340- 701104 $26,492 $29,100 $29,100 $29,100 Employee Benefits 10130340- 701201 $280,011 $287,180 $287,180 $246,315 Uniforms and Clothing 10130340- 701204 $3,352 $4,395 $5,468 $4,396 Training/Travel 10130340- 702000 $1,327 $3,000 $3,000 $0 Total Personal Services:$819,414 $819,815 $820,888 $764,961 Contractual Services Misc. Contract. Serv.10130340- 713005 $12,591 $212,190 $367,572 $209,900 Training/Travel 10130340- 713010 $0 $0 $0 $8,800 Printing and Reproductions 10130340- 715003 $0 $200 $200 $200 Memberships/Subscriptions 10130340- 716000 $200 $1,030 $1,030 $868 Total Contractual Services:$12,791 $213,420 $368,802 $219,768 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 128 Supplies Office Supplies 10130340- 721001 $228 $200 $200 $200 Operating Supplies 10130340- 721002 $21,434 $31,740 $39,748 $25,000 Total Supplies:$21,663 $31,940 $39,948 $25,200 Capital Outlay Tools 10130340- 734002 $438 $0 $0 $0 Total Capital Outlay:$438 $0 $0 $0 Other Charges and Expenditures Refuse Collection/Recycling 10130340- 751004 $3,877,557 $4,223,825 $4,665,008 $4,256,138 Promotional Programs 10130340- 751012 $335 $500 $500 $500 Total Other Charges and Expenditures:$3,877,892 $4,224,325 $4,665,508 $4,256,638 Total Expense Objects:$4,732,197 $5,289,500 $5,895,147 $5,266,567 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 10130340 Account 701101 provides funding for the staffing reflected in the Personnel Data and the Notes and Adjustments section. Account 701104 provides funding for wages of part-time or seasonal staff. Account 713005 provides funding for professional services, including GoZero Food Waste Recovery, Rumpke Dublin Glass Recycling Program, Document Destruction Day, household hazardous waste (HHW) collection event miscellaneous operating funds, citywide contract sweeping, mosquito control agreement and miscellaneous Solid Waste Authority of Central Ohio (SWACO) landfill disposal costs. Account 713010 provides funding for travel and training. Account 721002 provides funding for operating supplies and recycling carts. Account 751004 provides funding for the City’s refuse/recycling contract with Rumpke. In addition, this account provides funds for dumpsters for special events, recycling containers for events and funds to repair or replace existing residential program containers. The increase in budget for 2023 is due to an increase in the number of households serviced and a fuel adjustment rate increase. Account 751012 provides funding for Promotional Items related to the HHW event City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 129 Forestry | General Fund Jay Anderson Director of Public Service The City of Dublin takes pride in providing its residents and visitors the highest quality urban forestry program. Dublin's street tree program totals more than 33,000 trees. These trees increase property values, enhance Dublin's economic vitality and beautify the community as a whole. Personnel Data Position Title 2023 | Adopted 2024 | Adopted City Forester 1 1 Assistant Forester 5 5 Total 6 6 Part-Time/Seasonal Staff Seasonal Maintenance Worker 10 10 Total 10 10 City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 130 Forestry Expenditures by Expense Type | General Fund Budgeted and Historical Expenditures by Expense Type MillionsOther Charges and Expenditures Supplies Capital Outlay Contractual Services Personal Services FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $0.5 $1 $1.5 $2 Expense Objects Personal Services Full Time Salaries/Wages 10140434- 701101 $377,545 $357,610 $357,610 $367,125 Overtime Wages 10140434- 701103 $25,096 $25,000 $25,000 $25,000 Other Wages 10140434- 701104 $188,501 $198,425 $198,425 $198,425 Employee Benefits 10140434- 701201 $229,170 $224,335 $224,335 $222,985 Uniforms and Clothing 10140434- 701204 $8,083 $10,440 $12,736 $10,440 Training/Travel 10140434- 702000 $4,470 $6,405 $6,405 $0 Total Personal Services:$832,865 $822,215 $824,511 $823,975 Contractual Services Misc. Contract. Serv.10140434- 713005 $157,713 $200,000 $233,519 $650,000 Training/Travel 10140434- 713010 $0 $0 $0 $6,955 Memberships/Subscriptions 10140434- 716000 $3,024 $3,030 $3,030 $2,815 Total Contractual Services:$160,736 $203,030 $236,549 $659,770 Supplies Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 131 Operating Supplies 10140434- 721002 $3,538 $3,600 $3,600 $5,400 Park Maintenance 10140434- 724002 $40,276 $54,500 $57,625 $57,000 Equipment Maintenance 10140434- 724003 $1,095 $1,500 $1,500 $1,500 Total Supplies:$44,909 $59,600 $62,725 $63,900 Capital Outlay Tools 10140434- 734002 $3,482 $5,000 $5,000 $5,000 Furniture/Equipment 10180434- 731000 $46,057 $0 $0 $21,500 Cap Impr Land and Land Impr 10180434- 735001 $75,960 $75,000 $76,877 $77,400 Total Capital Outlay:$125,500 $80,000 $81,877 $103,900 Other Charges and Expenditures Special Projects/Programs 10140434- 751003 $927 $1,700 $1,700 $1,700 Total Other Charges and Expenditures:$927 $1,700 $1,700 $1,700 Total Expense Objects:$1,164,937 $1,166,545 $1,207,363 $1,653,245 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 10140434 Account 701101 provides funding for staffing reflected in the Personnel Data. Account 701104 provides funding for seasonal maintenance workers. Account 701204 provides funding for uniforms for full-time staff. Account 713005 provides funding for contractual services for arborist work and large tree pruning and removal. Costs increased for large tree pruning and arborist work outside of contract services. Account 713010 (previously 702000) includes funding for training for full-time staff to support Forestry operations, including education to provide recertification credits for professional certifications, pesticide applicator credits and staff training and development. Account 716000 provides funding for such memberships and pesticide license renewal, arborist license renewal and reference materials. Account 721002 provides funding for supplies needed for irrigation, staking and Emerald Ash Borer (EAB) injection parts. Account 724002 provides funding for soil, mulch, tree injections and grass seed. Account 724003 provides funding for equipment maintenance and repair. Account 734002 provides funding for small tools, such as ladders, blades, pruners, wheelbarrows, pole saws, watering supplies, etc. Account 751003 provides funding for Arbor Day trees. 10180434 Account 735001 includes funding for continued replacement trees, perennials and annuals. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 132 Horticulture | General Fund Jay Anderson Director of Public Service The City of Dublin takes pride in providing its residents and visitors the highest quality public parks to pursue their active and passive outdoor needs. The Horticulture work unit strives to be both environmentally and economically sound in its management of public areas, including parks, gateways and open space, focused specifically on the enhancement and beautification of the natural environment. Personnel Data Position Title 2023 | Adopted 2024 | Proposed City Horticulturist 1 1 Assistant Horticulturist 7 7 Total 8 8 Part-Time/Seasonal Staff Seasonal Maintenance Worker 19 19 Total 19 19 City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 133 Horticulture Expenditures by Expense Type | General Fund Budgeted and Historical Expenditures by Expense Type MillionsOther Charges and Expenditures Supplies Capital Outlay Contractual Services Personal Services FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $0.25 $0.5 $0.75 $1 $1.25 $1.5 $1.75 Expense Objects Personal Services Full Time Salaries/Wages 10140433- 701101 $451,881 $435,860 $435,860 $453,345 Overtime Wages 10140433- 701103 $17,145 $45,000 $45,000 $25,000 Other Wages 10140433- 701104 $215,826 $224,600 $199,900 $224,600 Employee Benefits 10140433- 701201 $290,816 $286,805 $286,805 $313,705 Uniforms and Clothing 10140433- 701204 $8,316 $14,760 $21,104 $14,760 Training/Travel 10140433- 702000 $9,346 $9,500 $10,200 $0 Total Personal Services:$993,331 $1,016,525 $998,869 $1,031,410 Contractual Services Misc. Contract. Serv.10140433- 713005 $201,598 $335,000 $360,850 $335,000 Training/Travel 10140433- 713010 $0 $0 $0 $12,500 Memberships/Subscriptions 10140433- 716000 $1,969 $2,560 $2,560 $2,560 Total Contractual Services:$203,567 $337,560 $363,410 $350,060 Supplies Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 134 Operating Supplies 10140433- 721002 $6,623 $6,500 $6,500 $8,000 Park Maintenance 10140433- 724002 $58,572 $67,500 $72,804 $67,500 Equipment Maintenance 10140433- 724003 $1,547 $2,500 $3,189 $2,500 Total Supplies:$66,742 $76,500 $82,493 $78,000 Capital Outlay Tools 10140433- 734002 $7,139 $7,500 $8,140 $7,500 Furniture/Equipment 10180433- 731000 $5,543 $0 $0 $5,000 Cap Impr Land and Land Impr 10180433- 735001 $100,050 $115,000 $117,430 $115,000 Total Capital Outlay:$112,732 $122,500 $125,570 $127,500 Other Charges and Expenditures Special Projects/Programs 10140433- 751003 $36,588 $33,500 $43,050 $33,500 Total Other Charges and Expenditures:$36,588 $33,500 $43,050 $33,500 Total Expense Objects:$1,412,960 $1,586,585 $1,613,392 $1,620,470 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 10140433 Account 701101 provides funding for staffing reflected in the Personnel Data. Account 701104 provides funding for seasonal maintenance workers. Account 701204 provides funding for uniforms for full-time and seasonal staff. Account 713005 provides funding for contractual services for arborist work and ecological assessments and contracted bed maintenance in the parks (mulching and weeding). Account 713010 (previously 702000) provides funding for training for full-time staff to support Horticulture operations. This includes education to provide recertification credits for professional certifications, pesticide applicator credits and staff training and development. Account 716000 provides funding for such memberships and renewals as pesticide license renewal, arborist license renewal, American Horticulture Society membership and reference materials. Account 721002 provides funding for irrigation system supplies and greenhouse supplies. Account 724002 provides funding for topsoil, grass seed, stump grinding, chemicals, plugs, traps, lab testing, soil injections and micronutrients. Account 724003 provides funding for equipment maintenance and repair of chainsaws, trimmers, etc. Account 734002 provides funding for small tools, such as blades, pruners, drills, wheelbarrows, pole saws, etc. Account 751003 provides funding for Earth Day activities, the Legacy Tree Program, the Legacy Bench Program, a Christmas tree for Bri- Hi and seasonal decorations for the Dublin Historic District. 10180433 Account 735001 includes funding for additional trees and shrubs, Historic Dublin and Riverside Crossing Park planters and prairie seed. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 135 Cemetery Maintenance | Special Revenue Fund Jay Anderson Director of Public Service The City of Dublin recognizes its responsibility to provide the proper grounds for its permanent residents and cemetery visitors by striving to protect and enhance its active and historical cemeteries. Cemetery maintenance facilitates the burial process with the greatest respect and ensures proper care of these sacred grounds by adherence to the highest maintenance standards. Personnel Data Position Title 2023 | Adopted 2024 | Adopted Maintenance Worker 1 1 Total 1 1 Part-Time/Seasonal Staff Seasonal Maintenance Worker 2 2 Total 2 2 City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 136 Cemetery Maintenance Expenditures by Expense Type | Special Revenue Fund Budgeted and Historical Expenditures by Expense Type MillionsCapital Outlay Supplies Contractual Services Personal Services FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $0.05 $0.1 $0.15 $0.2 $0.25 Expense Objects Personal Services Full Time Salaries/Wages 26160432-701101 $72,542 $66,675 $66,675 $69,970 Overtime Wages 26160432-701103 $12,698 $10,000 $10,000 $10,000 Other Wages 26160432-701104 $11,116 $27,000 $51,000 $27,000 Employee Benefits 26160432-701201 $45,207 $46,560 $46,560 $46,560 Uniforms and Clothing 26160432-701204 $678 $2,020 $2,362 $2,020 Total Personal Services:$142,242 $152,255 $176,597 $155,550 Contractual Services Misc. Contract. Serv.26160432-713005 $3,855 $35,750 $37,600 $48,750 Memberships/Subscriptions 26160432-716000 $95 $200 $200 $125 Utilities- Other Fuel Types 26160432-717005 $229 $450 $744 $300 Total Contractual Services:$4,179 $36,400 $38,544 $49,175 Supplies General Maintenance 26160432-724001 $17,590 $8,400 $10,182 $8,400 Equipment Maintenance 26160432-724003 $2,359 $1,000 $1,000 $2,000 Total Supplies:$19,949 $9,400 $11,182 $10,400 Capital Outlay Furniture/Equipment 26180432-731000 $1,990 $1,000 $1,000 $2,000 Land and Land Improvements 26180432-735001 $9,995 $0 $0 $0 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 137 Total Capital Outlay:$11,985 $1,000 $1,000 $2,000 Total Expense Objects:$178,355 $199,055 $227,323 $217,125 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 26160432 Account 701101 provides funding for full-time staff allocated to this budget under Personnel Data. Account 701104 provides funding for seasonal staff wages. Account 713005 provides funding for the transaction expenses related to the acceptance of credit card and vault company services. It also includes funds for cemetery arborist work. Fees for niche engraving will be recovered through fee collection. Account 713010 (previously 702000) provides funding for equipment safety training as needed. Account 717005 provides funding for electricity and water. Account 724001 includes funding for footers for monuments (recovered through fee collection), grass seed, concrete, topsoil, fertilizers, chemicals, for fence and stone wall work, headstone cleaning and refurbishing, annuals/perennials, tree planting replacements and mulch. Account 724003 provides funding for the repair and maintenance of mowers, trimmers and other miscellaneous equipment used for cemetery maintenance. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 138 Street Maintenance and Repairs | Special Revenue Fund Jason Anderson Director of Public Service The Street Maintenance work unit in the Division of Public Service is responsible for maintenance and minor repairs to Dublin's streets, paths, curbs, gutters and sidewalks. The work unit handles a vast array of other maintenance responsibilities, including berming, guardrail repairs and replacements, mowing, litter removal, leaf collection and snow and ice removal operations. Additionally, special event coordination and support are managed within the work unit. Personnel Data Position Title 2023 | Adopted 2024 | Adopted Director of Public Service (1)0.35 0.35 Operations Administrator 1 1 Maintenance Crew Supervisor 2.2 2.2 Maintenance Worker 14 14 Administrative Support II (2)0.5 0.5 Total 18.05 18.05 Part-Time/Seasonal Staff Seasonal Maintenance Worker 3 3 Total 3 3 Notes and Adjustments: 1. The Director of Public Service position is allocated 35% to this budget, 30% to the Solid Waste Fund and 35% to the Parks and Grounds Maintenance Fund. 2. Administrative Support II is shared between the Solid Waste Management and Street Maintenance functions. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 139 Street Maintenance and Repairs Expenditures by Expense Type | Special Revenue Fund Budgeted and Historical Expenditures by Expense Type MillionsTransfers/Advances Capital Outlay Contractual Services Supplies Personal Services FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $1 $2 $3 $4 $5 Expense Objects Personal Services Full Time Salaries/Wages 20170330-701101 $1,273,289 $1,144,805 $1,144,805 $1,145,435 Overtime Wages 20170330-701103 $198,598 $160,000 $160,000 $160,000 Other Wages 20170330-701104 $98,451 $87,120 $87,120 $87,120 Employee Benefits 20170330-701201 $702,290 $623,240 $623,240 $583,365 Uniforms and Clothing 20170330-701204 $14,418 $20,830 $26,670 $20,264 Training/Travel 20170330-702000 $9,837 $10,000 $10,576 $0 Total Personal Services:$2,296,885 $2,045,995 $2,052,412 $1,996,184 Contractual Services Misc. Contract. Serv.20170330-713005 $70,575 $31,005 $78,853 $22,500 Training/Travel 20170330-713010 $0 $0 $0 $19,740 Communications 20170330-715001 $0 $0 $0 $100 Memberships/Subscriptions 20170330-716000 $600 $1,400 $1,400 $1,400 Rents and Leases 20170330-717001 $5,100 $6,000 $6,000 $13,250 Total Contractual Services:$76,275 $38,405 $86,253 $56,990 Supplies Office Supplies 20170330-721001 $2,718 $3,500 $4,409 $3,500 Operating Supplies 20170330-721002 $85,542 $117,000 $164,734 $117,000 Street Salt 20170330-723001 $238,938 $500,000 $709,517 $550,000 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 140 Special Events 20170330-723006 $4,064 $3,000 $3,156 $3,000 Equipment Maintenance 20170330-724003 $0 $2,000 $2,000 $2,000 Total Supplies:$331,262 $625,500 $883,816 $675,500 Capital Outlay Tools 20170330-734002 $14,702 $10,000 $11,022 $10,000 Total Capital Outlay:$14,702 $10,000 $11,022 $10,000 Transfers/Advances Transfers Expense 20196290-741000 $0 $1,000,000 $1,000,000 $0 Total Transfers/Advances:$0 $1,000,000 $1,000,000 $0 Total Expense Objects:$2,719,124 $3,719,900 $4,033,503 $2,738,674 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 20170330 Account 701101 provides funding for the staffing under Personnel Data and in the Notes and Adjustments section. Account 701104 includes funding for seasonal staff. Account 701204 provides funding for necessary uniforms and clothing, including boots, gloves, rain gear and rental uniforms. Account 713005 provides funding for concrete and road paver repairs, mailbox repairs, asphalt repairs and the repairs of guardrails due to accidents. Account 713010 (previously 702000) includes funding for training. Account 716000 includes funding for memberships in the American Public Works Association, the Ohio Certified Public Manager’s Association and other miscellaneous memberships. Account 721002 includes funding for operating supplies, such as cold mix, hot mix, gravel, crack sealing materials, curb and catch basin repair supplies and construction materials. Account 723001 provides funding for the City’s annual purchase of street salt and de-icing liquids. 20180330 Account 731000 provides funding for contingency equipment replacement. 20196290 Account 741000 provides funding for the transfer of additional gas tax collections to the Capital Improvements Tax Fund. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 141 Asset Management & Quality Assurance | General Fund Bob Taylor Director of Asset Management & Quality Assurance The Director of Asset Management & Quality Assurance oversees the operations of the division. The Director’s budget supports the execution of strategic initiatives and projects to proactively maintain Dublin's infrastructure. This is accomplished through regular field inspection of Dublin's infrastructure, utilizing innovative technology to obtain and analyze both the current condition of Dublin's infrastructure, and developing five-year plans for the necessary infrastructure maintenance. Additionally, the Division of Asset Management & Quality Assurance develops and executes process improvement measures to ensure the Department of Public Works is competent, responsive and customer-service oriented. Personnel Data Position Title 2023 | Adopted 2024 | Adopted Director of Asset Management & Quality Assurance 1 1 Maintenance Crew Supervisor 1 1 Maintenance Worker 3 3 Infrastructure Asset Technician 1 1 Administrative Support II 1 1 Total 7 7 Part-Time/Seasonal Staff Intern 1 1 Total 1 1 City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 142 Asset Management & Quality Assurance Expenditures by Expense Type | General Fund Budgeted and Historical Expenditures by Expense Type MillionsSupplies Contractual Services Personal Services FY2022FY2023FY2024$0 $0.2 $0.4 $0.6 $0.8 $1 $1.2 Expense Objects Personal Services Full Time Salaries/Wages 10120311-701101 $583,147 $492,345 $492,345 $513,620 Overtime Wages 10120311-701103 $6,754 $15,000 $15,000 $20,000 Other Wages 10120311-701104 $3,575 $15,000 $10,500 $15,000 Employee Benefits 10120311-701201 $305,061 $299,610 $299,610 $299,215 Uniforms and Clothing 10120311-701204 $2,162 $2,850 $3,487 $4,100 Training/Travel 10120311-702000 $7,790 $9,000 $13,039 $0 Total Personal Services:$908,489 $833,805 $833,981 $851,935 Contractual Services Other Professional Services 10120311-713004 $0 $65,000 $65,000 $0 Misc. Contract. Serv.10120311-713005 $52,269 $60,000 $68,800 $60,000 Training/Travel 10120311-713010 $0 $0 $0 $11,900 Memberships/Subscriptions 10120311-716000 $933 $900 $900 $900 Total Contractual Services:$53,202 $125,900 $134,700 $72,800 Supplies Office Supplies 10120311-721001 $1,298 $950 $1,058 $950 Operating Supplies 10120311-721002 $4,645 $5,000 $5,709 $5,500 Total Supplies:$5,943 $5,950 $6,767 $6,450 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 143 Total Expense Objects:$967,634 $965,655 $975,447 $931,185 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 10120311 Account 701101 provides funding for staffing reflected in the Personnel Data. Account 701103 provides for overtime funding of Administrative Support staff for meetings, special events and other unexpected circumstances, as well as the GoDublin team members for unexpected circumstances. Account 701104 provides funding for one intern position to support the Infrastructure Asset Management program. Account 701204 supports funding for uniform rentals and replacements for the GoDublin team and Crew Supervisor and PPE replacements and supplies. Account 713004 provides funding for Pavement Inspection Management (Roadbotics) and an in-depth inspection of the Dublin Link Pedestrian Bridge, which is anticipated to occur every three to five years. Account 713005 provides funding for miscellaneous contract services for pavement deflection testing and cores and other inspection services. The City of Dublin is participating in the Ohio Department of Transportation's (ODOT) municipal bridge Inspection program that currently extends through 2023. Funding is provided for structural inspections of decks, docks and stairs by a professional engineer. Account 713010 (previously 702000) provides funding for travel, training and certification courses for staff, as well as recertification credits for professional certifications and staff training and development. Funding has been moved from Public Service into this line item for GoDublin staff training. Account 716000 provides funding for professional memberships and renewals, such as the American Public Works Association (AWPA) and ASQ, and other staff membership and recertification. Also included is funding for a pesticide applicators license fee for the GoDublin Crew Supervisor. Account 721001 provides funding for general office supplies. Account 721002 provides funding for operating supplies and tools for the Inspector and GoDublin crew, including spray paint, tapes, and miscellaneous tools and other office needs. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 144 Facilities Management | General Fund Brian Ashford Director of Facilities & Fleet Management The Division of Facilities and Fleet Management is charged with managing Dublin's investment in public buildings by ensuring that both the appearance and functions are preserved. This is accomplished by adhering to proper preventive maintenance programs, performing repairs in a professional and timely manner, maintaining a safe and clean environment for building occupants and visitors and by seeking the most efficient utilization of space and energy resources. Personnel Data Position Title 2023 | Adopted 2024 | Adopted Director of Facilities & Fleet Management (1)0.6 0.6 Operations Administrator 2 2 Maintenance Crew Supervisor 1 1 Facilities Crew Supervisor 1 1 Maintenance Crew Worker 3 3 Custodial Worker 8 8 Administrative Support II 1 1 Total 16.6 16.6 Notes and Adjustments: 1. The Director position is split 40% to the Fleet Management work unit and 60% to the Facilities work unit in the General Fund. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 145 Facilities Management Expenditures by Expense Type | General Fund Budgeted and Historical Expenditures by Expense Type MillionsCapital Outlay Supplies Contractual Services Personal Services FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $0.5 $1 $1.5 $2 $2.5 $3 $3.5 Expense Objects Personal Services Full Time Salaries/Wages 10110350-701101 $1,016,186 $965,290 $965,290 $986,270 Overtime Wages 10110350-701103 $24,260 $20,000 $20,000 $20,000 Other Wages 10110350-701104 $27,736 $10,000 $10,000 $0 Employee Benefits 10110350-701201 $482,197 $476,850 $476,850 $496,800 Uniforms and Clothing 10110350-701204 $10,144 $9,800 $12,900 $9,800 Training/Travel 10110350-702000 $448 $6,000 $4,000 $0 Meeting Expenses 10110350-703100 $0 $250 $250 $0 Total Personal Services:$1,560,972 $1,488,190 $1,489,290 $1,512,870 Contractual Services Misc. Contract. Serv.10110350-713005 $300,644 $393,000 $475,127 $315,274 Training/Travel 10110350-713010 $0 $0 $0 $6,000 Communications 10110350-715001 $4,998 $3,500 $5,000 $500 Memberships/Subscriptions 10110350-716000 $622 $500 $575 $500 Rents and Leases 10110350-717001 $4,634 $7,100 $11,110 $6,500 Utilities- Other Fuel Types 10110350-717005 $568,979 $515,000 $682,987 $690,000 Total Contractual Services:$879,876 $919,100 $1,174,799 $1,018,774 Supplies Office Supplies 10110350-721001 $487 $1,300 $1,382 $1,300 Operating Supplies 10110350-721002 $135,806 $127,500 $140,548 $140,000 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 146 Meeting Expenses 10110350-721006 $0 $0 $0 $250 Equipment Maintenance 10110350-724003 $269,988 $230,000 $255,591 $242,265 Total Supplies:$406,280 $358,800 $397,522 $383,815 Capital Outlay Tools 10110350-734002 $628 $1,500 $1,500 $1,500 Furniture/Equipment 10180350-731000 $13,053 $30,000 $30,000 $30,000 Total Capital Outlay:$13,680 $31,500 $31,500 $31,500 Total Expense Objects:$2,860,808 $2,797,590 $3,093,111 $2,946,959 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 10110350 Account 701101 provides funding for full-time staffing reflected in the Personnel Data. Account 701103 includes funding for overtime wages to provide staff coverage for maintenance projects, emergency call-ins and special events. Account 701204 provides funding for uniforms and clothing for maintenance and custodial staff. Account 713005 includes funding for preventive maintenance contracts for mechanical systems throughout City-owned facilities, contract cleaning at one building and parks restrooms, and scheduled cleaning services for carpet and windows in multiple buildings. Also, this provides funding for rental of floor mats, pest control services and fire and security alarm monitoring. Account 713010 (previously 702000) provides funding for staff training and professional development. Account 715001 provides funding for postage for the Service Center mail meter and for express mail and courier services. Account 716000 provides funding for professional memberships. Account 717001 provides funding for rents and leases. Account 717005 provides funding for electricity, natural gas and water and sewer charges for City facilities with the exception of the Dublin Community Recreation Center (charged to the DCRC facility account). Account 721001 provides funding for miscellaneous office supplies. Account 721002 includes funding for custodial, maintenance and operating supplies. Account 724003 includes funding for ongoing general maintenance of City-owned facilities except for the Dublin Community Recreation Center and outdoor pools, which have their own funding source. 10180350 Account 731000 includes funding for items, such as replacement furniture and flooring repairs in various City buildings. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 147 Dublin Community Recreation Center – Facilities Maintenance | Special Revenue Fund Brian Ashford Director of Facilities and Fleet Management The Facilities work Unit in the Division of Facilities and Fleet Management is charged with protecting Dublin's investment in the Dublin Community Recreation Center (DCRC) by ensuring both the appearance and functions of the center are preserved. This is accomplished by adhering to proper preventive maintenance programs, performing repairs in a professional and timely manner, maintaining a safe and clean environment for building occupants and visitors and by seeking the most efficient utilization of space and energy resources. Personnel Data Position Title 2023 | Adopted 2024 | Adopted Maintenance Crew Supervisor 1 1 Quality Control Manager 1 1 Maintenance Worker 3 3 Custodial Worker 2 2 Total 7 7 City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 148 Community Recreation Center - Facilities Maintenance Expenditures by Expense Type | Special Revenue Fund Budgeted and Historical Expenditures by Expense Type MillionsCapital Outlay Supplies Contractual Services Personal Services FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $0.25 $0.5 $0.75 $1 $1.25 $1.5 Expense Objects Personal Services Full Time Salaries/Wages 22540350-701101 $447,148 $425,060 $425,060 $447,150 Overtime Wages 22540350-701103 $16,218 $14,600 $14,600 $14,600 Employee Benefits 22540350-701201 $231,504 $250,655 $250,655 $232,380 Uniforms and Clothing 22540350-701204 $2,700 $3,900 $3,900 $3,900 Training/Travel 22540350-702000 $0 $1,300 $1,300 $0 Meeting Expenses 22540350-703100 $140 $350 $350 $0 Total Personal Services:$697,710 $695,865 $695,865 $698,030 Contractual Services Misc. Contract. Serv.22540350-713005 $280,133 $384,300 $481,768 $388,818 Training/Travel 22540350-713010 $0 $0 $0 $1,300 Memberships/Subscriptions 22540350-716000 $0 $200 $200 $200 Rents and Leases 22540350-717001 $0 $1,000 $1,000 $500 Total Contractual Services:$280,133 $385,500 $482,968 $390,818 Supplies Operating Supplies 22540350-721002 $112,385 $103,295 $81,840 $108,075 Meeting Expenses 22540350-721006 $0 $0 $0 $350 Equipment Maintenance 22540350-724003 $97,455 $84,660 $150,530 $89,100 Total Supplies:$209,840 $187,955 $232,371 $197,525 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 149 Capital Outlay Tools 22540350-734002 $0 $1,000 $1,000 $1,000 Cap Impr Build & Other Struct 22580350-735002 $0 $0 $1,184 $0 Total Capital Outlay:$0 $1,000 $2,184 $1,000 Total Expense Objects:$1,187,683 $1,270,320 $1,413,387 $1,287,373 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 22540350 Account 701101 provides funding for full-time staffing as reflected under Personnel Data. Account 701103 provides funding for overtime wages to provide staff coverage for maintenance projects, emergency call-ins and special events. Account 713005 includes funding for preventive maintenance services, technical maintenance services, duct work cleaning, drain cleaning, pest control, window cleaning and contract custodial cleaning services. Account 721002 provides funding for custodial supplies, light bulbs, filters, paints and other miscellaneous supplies to maintain the facility. Account 724003 includes funding for ongoing general maintenance and repair of the Dublin Community Recreation Center (DCRC) as well as HVAC and related equipment repairs. Account 734002 provides for small tools. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 150 Fleet Management Brian Ashford Director of Facilities & Fleet Management The Division of Facilities & Fleet Management provides Dublin staff with safe, well-maintained vehicles and equipment, enabling them to perform their work with high-performing vehicles that reflect a positive image for the City. The division continues to pursue alternative fuel and other options in an effort to reduce emissions from Dublin's fleet and equipment. Additionally, the division oversees the City's fueling station, providing the City’s fleet, Dublin City Schools and Washington Township Fire Department with fuel. Personnel Data Position Title 2023 | Adopted 2024 | Adopted Director of Facilities & Fleet Management (1)0.4 0.4 Fleet Manager 1 1 Fleet Technician II 1 1 Fleet Technician I 5 5 Total 7.4 7.4 Part-Time/Seasonal Staff Intern 1 1 Total 1 1 Notes and Adjustments: 1. The Director position is split 40% to the Fleet Management work unit and 60% to the Facilities work unit in the General Fund. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 151 Fleet Management Expenditures by Expense Type | General Fund Budgeted and Historical Expenditures by Expense Type MillionsCapital Outlay Contractual Services Personal Services Supplies FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $0.5 $1 $1.5 $2 $2.5 $3 $3.5 Expense Objects Personal Services Full Time Salaries/Wages 10110370-701101 $554,713 $557,135 $557,135 $570,890 Overtime Wages 10110370-701103 $37,411 $40,000 $40,000 $40,000 Other Wages 10110370-701104 $0 $0 $0 $15,000 Employee Benefits 10110370-701201 $196,629 $217,265 $217,265 $231,315 Uniforms and Clothing 10110370-701204 $8,081 $9,275 $10,228 $9,321 Training/Travel 10110370-702000 $10,369 $16,000 $16,000 $0 Total Personal Services:$807,203 $839,675 $840,628 $866,526 Contractual Services Other Professional Services 10110370-713004 $3,789 $9,000 $9,000 $11,780 Misc. Contract. Serv.10110370-713005 $116,168 $130,000 $141,772 $130,000 Training/Travel 10110370-713010 $0 $0 $0 $16,000 Memberships/Subscriptions 10110370-716000 $1,198 $3,500 $6,000 $3,500 Rents and Leases 10110370-717001 $46,345 $48,000 $50,527 $48,000 Total Contractual Services:$167,500 $190,500 $207,299 $209,280 Supplies Office Supplies 10110370-721001 $412 $1,500 $1,500 $1,500 Operating Supplies 10110370-721002 $22,262 $25,000 $27,491 $25,500 Equipment Maintenance 10110370-724003 $9,356 $17,000 $35,736 $19,000 Vehicle Maintenance 10110370-726001 $407,581 $460,000 $587,893 $480,000 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 152 Fuel 10110370-726002 $1,593,100 $1,510,665 $1,736,091 $1,525,000 Total Supplies:$2,032,711 $2,014,165 $2,388,711 $2,051,000 Capital Outlay Tools 10180370-734002 $14,562 $18,100 $22,122 $18,100 Total Capital Outlay:$14,562 $18,100 $22,122 $18,100 Total Expense Objects:$3,021,975 $3,062,440 $3,458,760 $3,144,906 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 10110370 Account 701101 provides funding for the staffing reflected in the Personnel Data. Account 701103 provides funding for overtime. Account 701104 provides funding for an intern from a vocational school or college who is interested in becoming a Fleet Technician. Account 701204 provides funding for rental uniforms, boots, gloves and safety glasses. Account 713004 includes funding for required fuel tank registrations and fuel tank cleaning; service on the parts cleaner; and vehicle registration, titles, plates and towing of vehicles. Account 713005 provides funding for miscellaneous contractual services, such as detailing of vehicles and bucket truck inspections. This account also provides funding for Integrated Business Solutions (IBS - NAPA), which is the City’s parts provider that also handles inventory and warranties. It is a contract that provides for a NAPA employee to be on-site during regular business hours. The budget reflects a cost increase from 2023. Account 713010 (previously 702000) provides funding for ASE certifications, welding certifications and other specialized training, as well as American Public Works Association (APWA) and Government Fleet Expo & Conference (GFX) conferences. Account 716000 provides funding for memberships and subscriptions, such as the National Association of Fleet Administrators (NAFA) and American Public Works Association (APWA). Account 717001 provides funding for rental of welding tanks, vehicle and equipment rental. Account 721002 provides funding for operating supplies, such as soaps for the car wash, hand cleaners and welding torch supplies. Account 724003 provides funding for maintenance and various equipment inspections. This includes maintenance on lift inspections, fuel system maintenance and repairs, bucket truck inspections (OSHA required) and bulk oil delivery system. Account 726001 provides funding for the repair and maintenance of all City-owned vehicles and equipment (tires, parts, curb shoes, blades, plows, cutting edges, etc). Account 726002 provides funding for fuel (unleaded, diesel, CNG) and other petroleum products. Over 50% of the fuel purchased by the City is consumed by the Dublin City School District and Washington Township Fire Department. Those costs are recovered through reimbursement to the City based on actual usage plus a surcharge. 10180370 Account 731000 provides funding for miscellaneous office furniture. Account 734002 provides funding for tool allowance for technicians as well as special tools due to model year changes. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 153 Capital Projects Funds Matthew Stiffler Chief Financial Officer/Director of Finance This group of funds is used to account for the financial resources to be provided for the acquisition or construction of major capital facilities and other infrastructure projects with the exclusion of those financed by Proprietary Funds. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 154 Five-Year Capital Project Planning The Five-Year Capital Improvements Program (CIP) establishes the City of Dublin’s blueprint for investments in its capital infrastructure. The CIP is used as a tool to help ensure the City’s long-term and short-term capital investments are made in the context of careful consideration of the City’s needs as well as the resources available to fund all projects. A complete copy of the document is available on the City’s website at dublinohiousa.gov/economic-development/capital-improvements-program. The financial guidelines used in the preparation of the CIP provide assurances that the City can meet, in a full and timely manner, both its debt service obligations and all other obligations competing for the available resources. It is the City’s objective to complete as many needed capital improvement projects as financially possible while maintaining flexibility and the ability to adapt to changes as they occur. The Five-Year CIP and the Annual Operating Budget are two critical documents prepared annually. The relationship between these two documents is summarized by the following points: Five-Year CIP Represents a long-term financial plan, including funding sources Establishes priorities and serves as a planning document or blueprint for the City’s investment in capital infrastructure Provides a breakdown of major project costs and phasing, including design costs Does not appropriate money; the Operating Budget is the document which authorizes the actual funding authority for capital projects Annual Operating Budget – CIP Budget Appropriates money to implement the first year of the Five-Year CIP Appropriates money to implement a “phase of a major, multi-year project” Appropriates money for capital maintenance expenditures, including those of a continuing nature (i.e., fleet and equipment replacement, computers, etc.) Project Prioritization In developing the prioritization of projects, several elements are taken into consideration: City Council’s goals, both past and present Economic Development Strategy findings Commitments that were made by the City in agreements Biannual Community Survey results Input from citizen committees and economic development opportunities Using these guidelines resulted in a list of projects to be funded that are focused on needed infrastructure improvements, such as road and utility needs. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 155 Impact of Capital Investments on the Operating Budget The City’s Operating Budget covers a one-year time period, whereas the City’s Capital Improvements Program (CIP) covers a five-year period. While the CIP is prepared and approved separately from the Operating Budget, staff take into consideration the impact of the upcoming year’s capital projects on departmental operations, including the maintenance and upkeep of the assets. When debt financing is used to fund capital projects, the principal and interest payments are included as expenditures in the Operating Budget. The City has taken further steps to evaluate the effect of capital assets on the Operating Budget by adding an Asset Management & Quality Assurance work unit to its organizational chart. This work unit is responsible for implementing and managing strategies for sustaining public infrastructure assets, with the fundamental goal of preserving and extending the service life of long-term infrastructure assets. In the course of inventorying and inspecting these assets, routine maintenance schedules will be established that will help the City better understand the annual operating costs or additional savings related to the City’s infrastructure assets, both existing and new additions. This will assist the City in better quantifying the impact of capital expenditures on the Operating Budget in future years. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 156 The safety of our citizens is the City's number one priority. National Bridge Inspection Standards are followed to ensure this, as The Link is visually checked annually and incorporated into the Capital Improvement Program. Summary of CIP Financial Guidelines There are several key guidelines the City utilizes in determining the fiscal capacity to complete capital projects over the next five years. These are summarized: The five-year plan will be updated annually. Twenty-five percent of the City’s 2% income tax revenue should be made available to fund capital improvements. This allocation is in accordance with Ordinance No. 17-87 and the ballot language approved by the voters in November 1987. Of the 25% of total income tax revenues which are utilized for capital improvements, 60% of that amount will be allocated to fund long-term debt, and 40% to fund projects and capital expenses on a cash basis. This allocation is in accordance with Ordinance No. 31-16. The reasons for these guidelines are: a. It is important to stress that funding projects with long-term debt obligates the use of public funds for the next 20 years in most cases. The more long-term debt which is incurred now significantly reduces the options available to future City Councils to fund needed projects. b. The City has determined that paying cash for projects where financially possible (pay-as-you-go financing) will increase flexibility in the future. In utilizing pay-as-you-go financing, revenue projections and estimated fund balances will be reviewed and evaluated to assure that sufficient reserves are maintained. c. It is not economical to issue debt for some projects. d. The estimated life of some projects does not meet the criteria to issue long-term debt. The City’s largest revenue source for operations is income tax revenue. This source comprises more than 90% of the City’s General Fund operating revenues. Therefore, it is one of the City’s key economic indicators that is reviewed when determining the level of growth for the upcoming year. To the degree that the income tax revenue rate of growth exceeds projections in any given year, the excess revenue should be utilized to fund projects on a cash basis the following year or to reduce the amount of debt on projects identified to be financed with debt proceeds. The availability of adequate financial reserves or balances that can be used to address unforeseen contingencies or take advantage of opportunities is a critical element in evaluating financial strength. Another key financial indicator for the City is its General Fund balance. The City’s policy is to maintain a year-end balance equal to or greater than 50% of the General Fund expenditures, including operating transfers. This balance is in accordance with Ordinance No. 32-16. This level of fund balance is necessary as the City continues funding major improvements throughout Dublin. The City will continue to make significant advances from the General Fund to various Tax Increment Financing (TIF) funds for infrastructure improvements throughout the City. This allows the City to take advantage of opportunities as they arise and fund infrastructure improvements before TIF revenues are generated. The expectation is that these advances will be repaid to the General Fund over the 30-year life of each TIF. Since a portion of the debt outstanding and future capital improvements are utility related (water and sewer), the systems' user fees and capacity charges (tap permits) will continue to be evaluated. Water-related improvements will be programmed based on the Water Fund's available cash reserves and estimated annual revenues. Every effort will be made City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 157 to structure the debt service obligations for utility infrastructure improvements in such a manner as to utilize the Sewer Fund and the Water Fund's available cash reserves and estimated annual revenues to the fullest and thereby reducing or eliminating the dependency on income tax revenues. The goal in the Water and Sewer funds has been to maintain fund balances equal to approximately 25% of the total value of each system. In 2024, approximately 80% of the property tax revenue from the City’s “inside millage” will be allocated to the Capital Improvements Tax Fund. The property tax revenue from the City’s “inside millage” (1.75 mills) was allocated 100% to the Parkland Acquisition Fund from 2001 to 2006. From 2007 to 2009, the City began allocating .95 mills of the total 1.75 mills to the Parkland Acquisition Fund with the remaining 0.80 mills allocated to the Capital Improvements Tax Fund. As part of the 2010-2014 CIP process, the Council approved allocating 1.40 mills to the Capital Improvements Tax Fund and 0.35 mills to the Parkland Acquisition Fund. Recognizing the benefits and flexibility of allocating more of the City’s “inside millage” to the Capital Improvements Tax Fund, the Council has continued to approve, with each year’s CIP, the same allocation. This allocation is reviewed during the CIP process each year and can be reallocated if the City Council deems it appropriate. Pursuant to the City’s Debt Policy (Ordinance No. 37-19), the maximum amount of debt service (including existing TIF supported and proposed new debt) shall not exceed 90% of the allocation of income tax revenue allocated to pay for debt service. As a matter of general policy, the City will do the following in order to be able to fund additional projects needed to serve the citizens of Dublin: 1. Pursue federal, state and local assistance in the form of grants, low interest loans, cost-sharing, etc. 2. Utilize assessment procedures for projects which have a reasonably well-defined group of beneficiaries and which legally lend themselves to this type of financing. 3. Look increasingly at ways to obtain revenue through user fees as a means to fund capital projects or as a way to free- up other income tax dollars so that they can be used to fund capital projects. 4. Utilize, where appropriate, economic development incentives, such as tax increment financing. As projects are proposed for funding, the statutory debt limitations will be reviewed to ensure compliance. The five-year program provides for significant capital programming. The programming of projects needs to be distributed over the five-year period so that as the City updates the capital program each year, it can evaluate current conditions, including the capital needs, revenue growth and respond to new priorities. Transfers and Advances The majority of the funding programmed for transfers is for debt service obligations on capital projects financed by long-term debt. The advances programmed are based on projects programmed in the 2024-2028 CIP that have been identified as infrastructure projects benefiting the reflected Tax Increment Financing funds (TIFs). Debt Debt proceeds for construction projects (with the exception of sewer and water projects) are posted to the Capital Construction Fund (404) and tracked through that fund. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 158 Capital Improvement Funds (All Funds) Capital Improvements Tax Fund (Fund 401) This fund was created by the City Council for the express purpose of the purchase of equipment, apparatus, property, construction of buildings, structures, roads and other public infrastructure improvements as needed. City income tax collections are directly credited to this fund each year in accordance with Ordinance No. 17-87. Additional revenue is provided by real estate taxes, transfers from the General Fund and interest income. Parkland Acquisition Fund (Fund 402) Chapter 152 of the Codified Ordinances of Dublin provides for the payment of fees in lieu of parkland dedication. These fees are credited to the Parkland Acquisition Fund for the purpose of acquiring recreational facility sites, open space and/or parkland. Capital Construction Fund (Fund 404) This fund is provided to account for the bond issuance proceeds received and to be expended on related infrastructure projects other than those financed by the Proprietary Funds and Trust Funds. Tax Increment Financing (TIF) Funds (Fund 412 through Fund 475) Tax Increment Financing (TIF) is an economic development mechanism available to local governments in Ohio to finance public infrastructure improvements and, in certain circumstances, residential rehabilitation. TIF districts are implemented at the local level and may be created by a township, municipality or county. Payments derived from the increased assessed value of any improvement to real property beyond the original value are directed toward a separate fund to finance the construction of public infrastructure defined within the TIF legislation. Budgeted and Historical 2024 Expenditures by Fund MillionsTIF Rings Road TIF Emerald Parkway Phase 8 COIC Improvement TIF Shier Rings Road TIF Kroger Centre TIF Delta Energy TIF Bridge Street TIF Innovation TIF Riviera TIF Irelan Place TIF Perimeter Loop TIF Historic Dublin Parking TIF River Ridge TIF Shamrock Blvd. TIF Dublin Methodist Hospital TIF Woerner-Temple TIF Bridge and High Street TIF Penzone TIF Pizzuti TIF Tartan West TIF The Corners TIF Thomas/Kohler TIF Shamrock Crossing TIF Upper Metro Place TIF H2 Hotel 1/2 FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $20 $40 $60 $80 $100 $120 Capital Improvements Tax Information Technology 40180170-732000 $104,819 $200,000 $274,603 $200,000 Information Technology 40180180-732000 $1,281,661 $1,900,000 $3,080,270 $2,046,000 Information Technology 40180190-732000 $315,336 $1,000,000 $1,199,375 $0 Cap Impr Other Projects 40180290-736000 $59,755 $0 $32,917 $0 Cap Impr Contingencies 40180290-737000 $101,837 $250,000 $328,657 $250,000 Cap Impr Str Maint Proj 40180311-735006 $0 $7,685,000 $8,285,000 $0 Cap Impr New Str Const/Eng Ser 40180320-735004 $513,429 $1,249,900 $5,764,992 $1,210,000 Cap Impr Str Maint Proj 40180320-735006 $20,997,173 $5,300,000 $21,450,463 $13,984,000 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 159 Cap Impr Storm Sewer Imp 40180320-735010 $632,131 $790,000 $1,580,641 $1,960,000 Cap Impr Other Projects 40180320-736000 $0 $0 $7,100,000 $0 Cap Impr Build & Other Struct 40180350-735002 $1,114,831 $1,400,000 $5,140,451 $2,680,000 Other Equipment 40180370-734004 $1,193,530 $1,950,000 $3,140,352 $1,673,000 Cap Impr Park & Bikewy Impr 40180430-735005 $1,704,991 $3,880,000 $6,548,107 $2,190,000 Cap Impr New Str Const/Eng Ser 40180750-735004 $0 $11,395,000 $9,125,000 $11,015,000 Cap Impr Other Projects 40180750-736000 $378,442 $810,000 $2,018,383 $2,466,000 Police Capital Equipment 40180890-734001 $161,099 $820,000 $930,300 $885,000 Transfers Expense 40196290-741000 $6,495,552 $7,134,445 $7,134,445 $7,760,141 Advances Expense 40197290-742000 $5,500,000 $2,600,000 $2,600,000 $550,000 Total Capital Improvements Tax:$40,554,586 $48,364,345 $85,733,957 $48,869,141 Parkland Acquisition Land and Land Improvements 40280290-735001 $0 $750,000 $750,000 $800,000 Total Parkland Acquisition:$0 $750,000 $750,000 $800,000 Capital Improvement Constructi Cap Impr New Str Const/Eng Ser 40480320-735004 $86,243 $0 $74,982 $0 Cap Impr Build & Other Struct 40480350-735002 $0 $0 $0 $4,494,000 Cap Impr Park & Bikewy Impr 40480430-735005 $701,632 $0 $1,106,003 $0 Cap Impr New Str Const/Eng Ser 40480750-735004 $0 $10,100,000 $11,000,000 $2,100,000 Advances Expense 40497290-742000 $5,700,000 $0 $11,000,000 $0 Total Capital Improvement Constructi:$6,487,875 $10,100,000 $23,180,985 $6,594,000 TIF Woerner-Temple Advances Expense 41297290-742000 $170,000 $300,000 $300,000 $140,000 Total TIF Woerner-Temple:$170,000 $300,000 $300,000 $140,000 TIF Ruscilli Transfers Expense 41596290-741000 $1,102,715 $624,460 $624,460 $437,545 Total TIF Ruscilli:$1,102,715 $624,460 $624,460 $437,545 TIF Pizzuti Transfers Expense 41696290-741000 $465,000 $835,000 $835,000 $200,000 Total TIF Pizzuti:$465,000 $835,000 $835,000 $200,000 TIF Thomas/Kohler Other Professional Services 41980320-713004 $0 $235,000 $235,000 $160,000 Other Professional Services 41980750-713004 $0 $0 $0 $80,000 Cap Impr New Str Const/Eng Ser 41980320-735004 $0 $3,000,000 $3,000,000 $0 Transfers Expense 41996290-741000 $800,000 $615,000 $615,000 $0 Total TIF Thomas/Kohler:$800,000 $3,850,000 $3,850,000 $240,000 TIF McKitrick Project Transfers Expense 42196290-741000 $1,145,225 $1,145,225 $1,145,225 $1,144,540 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 160 Total TIF McKitrick Project:$1,145,225 $1,145,225 $1,145,225 $1,144,540 TIF Perimeter Center Cap Impr New Str Const/Eng Ser 42580320-735004 $4,580,711 $3,334,000 $3,551,708 $0 Advances Expense 42597290-742000 $0 $0 $0 $1,000,000 Total TIF Perimeter Center:$4,580,711 $3,334,000 $3,551,708 $1,000,000 TIF Rings Road Advances Expense 42697290-742000 $98,800 $98,800 $98,800 $0 Total TIF Rings Road:$98,800 $98,800 $98,800 $0 TIF Perimeter West Other Professional Services 43180320-713004 $111,401 $0 $442,301 $0 Cap Impr New Str Const/Eng Ser 43180320-735004 $0 $1,000,100 $1,000,100 $0 Cap Impr New Str Const/Eng Ser 43180750-735004 $0 $0 $0 $75,000 Transfers Expense 43196290-741000 $653,745 $637,845 $637,845 $578,268 Total TIF Perimeter West:$765,146 $1,637,945 $2,080,246 $653,268 TIF Upper Metro Place Transfers Expense 43296290-741000 $396,200 $495,500 $495,500 $225,000 Advances Expense 43297290-742000 $0 $150,000 $150,000 $150,000 Total TIF Upper Metro Place:$396,200 $645,500 $645,500 $375,000 TIF Rings/Frantz Other Professional Services 43380320-713004 $0 $0 $20,159 $0 Cap Impr New Str Const/Eng Ser 43380320-735004 $97,400 $0 $104,916 $0 Cap Impr New Str Const/Eng Ser 43380750-735004 $0 $295,000 $295,000 $0 Transfers Expense 43396290-741000 $250,000 $250,000 $250,000 $200,000 Advances Expense 43397290-742000 $500,000 $500,000 $500,000 $500,000 Total TIF Rings/Frantz:$847,400 $1,045,000 $1,170,075 $700,000 TIF Historic Dublin Parking Transfers Expense 43696290-741000 $75,000 $75,000 $75,000 $75,000 Total TIF Historic Dublin Parking:$75,000 $75,000 $75,000 $75,000 TIF Emerald Parkway Phase 8 Cap Impr New Str Const/Eng Ser 44180320-735004 $0 $0 $5,109 $0 Transfers Expense 44196290-741000 $481,825 $54,500 $54,500 $0 Total TIF Emerald Parkway Phase 8:$481,825 $54,500 $59,609 $0 TIF Perimeter Loop Advances Expense 44297290-742000 $30,000 $45,000 $45,000 $45,000 Total TIF Perimeter Loop:$30,000 $45,000 $45,000 $45,000 TIF Tartan West Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 161 Advances Expense 44397290-742000 $700,000 $800,000 $800,000 $200,000 Total TIF Tartan West:$700,000 $800,000 $800,000 $200,000 TIF Shamrock Blvd. Advances Expense 44497290-742000 $75,000 $100,000 $100,000 $100,000 Total TIF Shamrock Blvd.:$75,000 $100,000 $100,000 $100,000 TIF River Ridge Transfers Expense 44696290-741000 $137,430 $86,100 $86,100 $86,502 Advances Expense 44697290-742000 $0 $100,000 $100,000 $0 Total TIF River Ridge:$137,430 $186,100 $186,100 $86,502 TIF Lifetime Fitness Transfers Expense 44796290-741000 $0 $365,135 $365,135 $419,709 Total TIF Lifetime Fitness:$0 $365,135 $365,135 $419,709 COIC Improvement Cap Impr Land and Land Impr 44880290-735001 $0 $115,490 $115,487 $0 Total COIC Improvement:$0 $115,490 $115,487 $0 TIF Irelan Place Advances Expense 44997290-742000 $3,000 $3,000 $3,000 $3,000 Total TIF Irelan Place:$3,000 $3,000 $3,000 $3,000 TIF Shamrock Crossing Cap Impr New Str Const/Eng Ser 45180320-735004 $0 $45,000 $45,000 $0 Transfers Expense 45196290-741000 $275,000 $275,000 $275,000 $275,000 Advances Expense 45197290-742000 $50,000 $0 $0 $0 Total TIF Shamrock Crossing:$325,000 $320,000 $320,000 $275,000 TIF Bridge and High Street Transfers Expense 45296290-741000 $150,000 $150,000 $150,000 $150,000 Total TIF Bridge and High Street:$150,000 $150,000 $150,000 $150,000 TIF Dublin Methodist Hospital Transfers Expense 45396290-741000 $0 $0 $0 $115,000 Total TIF Dublin Methodist Hospital:$0 $0 $0 $115,000 TIF Kroger Centre Cap Impr Land and Land Impr 45480430-735001 $0 $20,000 $20,000 $0 Total TIF Kroger Centre:$0 $20,000 $20,000 $0 TIF Bridge Street Advances Expense 45797290-742000 $5,700,000 $0 $0 $0 Total TIF Bridge Street:$5,700,000 $0 $0 $0 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 162 TIF Vrable Cap Impr Park & Bikewy Impr 45880430-735005 $0 $150,000 $150,000 $0 Transfers Expense 45896290-741000 $745,100 $496,000 $496,000 $440,331 Total TIF Vrable:$745,100 $646,000 $646,000 $440,331 TIF West Innovation Cap Impr Str Maint Proj 45980320-735006 $3,589,920 $0 $205,000 $0 Cap Impr New Str Const/Eng Ser 45980750-735004 $0 $2,625,000 $2,625,000 $7,050,000 Total TIF West Innovation:$3,589,920 $2,625,000 $2,830,000 $7,050,000 TIF Tuller Other Professional Services 46180320-713004 $36,347 $0 $0 $0 Cap Impr Land and Land Impr 46180430-735001 $0 $600,000 $600,000 $0 Cap Impr Land and Land Impr 46180750-735001 $0 $0 $0 $250,000 Transfers Expense 46196290-741000 $750,875 $906,900 $906,900 $1,292,644 Total TIF Tuller:$787,222 $1,506,900 $1,506,900 $1,542,644 TIF Nestle Cap Impr New Str Const/Eng Ser 46280750-735004 $0 $0 $0 $750,000 Total TIF Nestle:$0 $0 $0 $750,000 TIF Bridge Park Blocks B & C Transfers Expense 46396290-741000 $2,419,800 $2,416,920 $2,416,920 $2,415,915 Total TIF Bridge Park Blocks B & C:$2,419,800 $2,416,920 $2,416,920 $2,415,915 TIF Riviera Advances Expense 46597290-742000 $0 $700,000 $700,000 $0 Total TIF Riviera:$0 $700,000 $700,000 $0 TIF Penzone Cap Impr Park & Bikewy Impr 46680430-735005 $0 $150,000 $150,000 $0 Transfers Expense 46696290-741000 $30,000 $80,875 $80,875 $176,875 Total TIF Penzone:$30,000 $230,875 $230,875 $176,875 TIF H2 Hotel Cap Impr Park & Bikewy Impr 46780430-735005 $0 $150,000 $150,000 $0 Transfers Expense 46796290-741000 $325,000 $325,000 $325,000 $375,000 Total TIF H2 Hotel:$325,000 $475,000 $475,000 $375,000 TIF The Corners Contractual Obligations 47580290-719006 $2,401,420 $235,000 $705,963 $235,000 Total TIF The Corners:$2,401,420 $235,000 $705,963 $235,000 Total:$75,389,374 $83,800,195 $135,716,946 $75,608,470 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 163 Recap of Projects and Funding Allocations - 2024 The attached worksheet reflects the approved capital projects funded in 2024 and their MUNIS project numbers, along with the budget amount as approved by City Council. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 164 Tax Increment Financing (TIF) - Additional Information City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 165 City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 166 Debt | Debt Service Matthew Stiffler Chief Financial Officer/Director of Finance These funds reflect the cost of paying the principal and interest on various outstanding bond and note issues. Sources of funding include transfers from the Capital Improvements Tax Fund and various Tax Increment Financing Funds. Budget requests for debt service payments reflect debt service obligations for both long-term and short-term debt issued by the City as well as special assessment debt. The City maintains unvoted general obligation bonds, un-voted special assessment bonds which rolled off in 2021, and voted general obligation bonds which rolled off in 2020. The debt service payments for Water and Sewer Fund obligations are budgeted as debt service payments directly to the Water and Sewer Funds instead of transferring the money to the General Obligation Debt Service Fund and reflecting the debt payments in that fund. Financial Information In 2022, the City of Dublin implemented the use of DebtBook, a debt management tool software. This program will consolidate all the City's debt in one easy-to-use platform for financial reporting, payment processing and automated journaling. Budgeted and Historical 2024 Expenditures by Fund MillionsS.A. Debt Service 2001 S.A. Debt Service Econ Development Bond Retirmnt General Debt Service FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $5 $10 $15 $20 $25 $30 $35 General Debt Service Debt Issuance Costs 31090290- 761001 $117,113 $120,000 $120,000 $200,000 Principal- Parks Programs 31090290- 762002 $1,008,000 $1,230,000 $1,230,000 $1,663,000 Principal- Transportation 31090290- 762003 $5,333,393 $5,385,335 $5,401,379 $5,625,993 Principal- Land and Buildings 31090290- 762004 $1,300,000 $1,335,000 $1,335,000 $1,903,700 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 167 Interest- Parks Program 31090290- 763003 $820,305 $999,500 $999,500 $855,385 Interest- Transportation 31090290- 763004 $3,639,620 $3,359,395 $3,365,013 $3,089,526 Interest- Land and Buildings 31090290- 763005 $1,245,987 $1,203,295 $1,203,295 $1,500,488 Total General Debt Service:$13,464,418 $13,632,525 $13,654,188 $14,838,092 Econ Development Bond Retirmnt Principal- Land and Buildings 31190290- 762004 $780,000 $820,000 $820,000 $860,000 Interest- Land and Buildings 31190290- 763005 $1,285,914 $1,246,920 $1,246,920 $1,205,914 Total Econ Development Bond Retirmnt:$2,065,914 $2,066,920 $2,066,920 $2,065,914 S.A. Debt Service County Auditor Deductions 32090290- 711001 $0 $1,000 $1,000 $0 Total S.A. Debt Service:$0 $1,000 $1,000 $0 Total:$15,530,332 $15,700,445 $15,722,108 $16,904,006 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary Debt Service Funds: 310 provides for general debt service. 311 provides for economic bond retirement. 320 provides for any county auditor fees on special assessments. 322 provides for 2001 special assessment debt service (rolled-off in 2021). City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 168 Enterprise Funds Enterprise funds are used to account for operations that are financed and operated in a manner similar to private businesses, where the costs of providing goods or services to the general public on a continuing basis are financed or recovered primarily through user charges. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 169 Enterprise Fund | Water System Maintenance - Debt Service Matthew Stiffler Chief Financial Officer/Director of Finance This fund provides for debt service obligations for water system maintenance. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 170 Enterprise Fund | Water System Maintenance - Debt Service Expenditures by Expense Type Budgeted and Historical Expenditures by Expense Type MillionsDebt Service FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $0.25 $0.5 $0.75 $1 $1.25 $1.5 Expense Objects Debt Service Debt Issuance Costs 61090290-761001 $70,052 $75,000 $75,000 $4,000 Principal- Water 61090290-762001 $206,291 $304,885 $304,885 $307,742 Interest- Water 61090290-763002 $155,567 $220,740 $220,740 $192,194 Total Debt Service:$431,910 $600,625 $600,625 $503,936 Total Expense Objects:$431,910 $600,625 $600,625 $503,936 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 61090290 Accounts 762001 and 763002 provide funding for debt service obligations for water towers and water improvement projects. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 171 Enterprise Fund | Sewer System Maintenance - Debt Service Matthew Stiffler Chief Financial Officer/Director of Finance This fund provides for debt service obligations for sewer system maintenance. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 172 Enterprise Fund | Sewer System Maintenance - Debt Service Expenditures by Expense Type Budgeted and Historical Expenditures by Expense Type MillionsDebt Service FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $0.5 $1 $1.5 $2 $2.5 Expense Objects Debt Service Debt Issuance Costs 62090290-761001 $54,619 $50,000 $50,000 $20,000 Principal- Sewer 62090290-762005 $699,985 $848,970 $848,970 $905,806 Interest- Sewer 62090290-763006 $595,117 $749,645 $749,645 $609,259 Total Debt Service:$1,349,720 $1,648,615 $1,648,615 $1,535,065 Total Expense Objects:$1,349,720 $1,648,615 $1,648,615 $1,535,065 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 62090290 Accounts 762005 and 763006 provide funding for debt service obligations related to sanitary sewer relining and repairs and extensions. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 173 Fiduciary Funds These funds are used for assets held by the City in a trustee capacity or as an agent for individuals, private organizations, other governmental units,and/or other funds. These funds are not required to be budgeted. However, the City prefers to monitor the accounts and, to the extent possible, eliminate deficit balances. All expenditures appropriated are covered by corresponding revenues. Agency funds include deposits and unclaimed monies held in trust for individuals and private organizations, hotel/motel taxes collected on behalf of the Dublin Convention and Visitors Bureau (Visit Dublin Ohio), building surcharges, sewer capacity charges, Central Ohio Interoperable Radio System (COIRS) and Property Assessed Clean Energy (PACE). City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 174 Fiduciary Funds | Unclaimed Monies Matthew Stiffler Chief Financial Officer/Director of Finance The budget for unclaimed funds provides for tracking of unclaimed payroll checks, tax refund checks, Mayor's Court checks and general accounts payable checks received or collected by the City under color of office and not otherwise paid-out in accordance to the Ohio Revised Code. The funds remain in the City's treasury until claimed by the rightful owner. If not claimed within a period of five years, the funds revert to the City's General Fund. Fund transactions follow guidance from the Auditor of State and the City of Dublin's Unclaimed Monies Policy. Fiduciary Fund | Unclaimed Monies Expenditures by Expense Type Budgeted and Historical Expenditures by Expense Type MillionsOther Charges and Expenditures FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $0.025 $0.05 $0.075 $0.1 $0.125 $0.15 Expense Objects Other Charges and Expenditures Refunds- Gen. Unclaim. Chk 80310210- 755002 $1,345 $250 $250 $0 Refunds- Unclaim. Payroll 80310210- 755003 $16 $0 $0 $0 Refunds- Unclaim. Inc. Tax 80310210- 755004 $18,430 $20,000 $20,000 $30,000 Total Other Charges and Expenditures:$19,791 $20,250 $20,250 $30,000 Total Expense Objects:$19,791 $20,250 $20,250 $30,000 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 175 Fiduciary Funds | Agency Matthew Stiffler Chief Financial Officer/Director of Finance This budget provides for the tracking and monitoring of collections made on behalf of other individuals, private organizations or other governments with the City of Dublin as the custodial funds agent. All expenditures are covered by funds collected. There is no financial net impact to the City's treasury. Fiduciary Fund | Agency Expenditures by Expense Type Budgeted and Historical Expenditures by Expense Type MillionsOther Charges and Expenditures Contractual Services FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $1 $2 $3 $4 Expense Objects Contractual Services County Auditor Deduct NCA Char 80510210- 711001 $0 $12,500 $0 $0 Sewer Capacity Charges - Colum 80510210- 711004 $0 $600,000 $0 $0 DIF Food Pantry Donations 80510210- 715004 $1,085 $0 $0 $0 Contractual Obligations 80510210- 719006 $0 $2,107,050 $0 $0 Sewer Capacity Charges - Colum 82210290- 711004 $294,259 $0 $600,000 $650,000 County Auditor Deductions 82310290- 711001 $7,485 $0 $12,500 $20,000 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 176 Contractual Obligations 82310290- 719006 $2,406,371 $0 $2,107,050 $2,380,000 Total Contractual Services:$2,709,200 $2,719,550 $2,719,550 $3,050,000 Other Charges and Expenditures DCRC Refunds 80510210- 755000 $0 $800 $800 $0 Refunds- Conditional Occup 80510210- 755005 $0 $500,000 $0 $0 Residential 1% Surcharge - OH 80510210- 755006 $0 $5,000 $0 $0 Commercial 3% Surcharge - Ohio 80510210- 755007 $0 $25,000 $0 $0 DCRC/ Shelter Deposits 80510210- 755008 $0 $10,000 $0 $0 DCRC/Theater Refundable Adm 80510210- 755010 $23,695 $2,000 $2,000 $30,000 Washington Twp After Hrs Insp 80510210- 755012 $12,555 $12,000 $12,000 $15,000 Refunds- Hydrant Permit 80510210- 755013 $0 $300 $300 $0 DCRC/Dublin City School Prog 80510210- 755014 $0 $25,000 $25,000 $25,000 Refunds- Vendor Bonds 80510210- 755015 $0 $500 $500 $0 Washington Twp Temp Struct Ins 80510210- 755025 $1,250 $1,500 $1,500 $1,500 Bridge Park NCA Charges 80510210- 755026 $0 $150,000 $0 $0 Residential 1% Surcharge - OH 82110290- 755006 $3,738 $0 $5,000 $5,000 Commercial 3% Surcharge - Ohio 82110290- 755007 $23,401 $0 $25,000 $30,000 Bridge Park NCA Charges 82310290- 755026 $143,496 $0 $150,000 $175,000 Total Other Charges and Expenditures:$208,135 $732,100 $222,100 $281,500 Total Expense Objects:$2,917,335 $3,451,650 $2,941,650 $3,331,500 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 177 Fiduciary Funds | Central Ohio Interoperable Radio System (COIRS) Matthew Stiffler Chief Financial Officer/Director of Finance This budget provides tracking and monitoring of custodial funds held by the City as an agent for the Central Ohio Interoperable Radio System (COIRS). COIRS was established to build and operate a shared (multi-jurisdictional) emergency radio dispatching network for emergency responders and police service crews (within its member agencies), with the City of Dublin acting as its fiscal agent. Fiduciary Fund | COIRS Expenditures by Expense Type Budgeted and Historical Expenditures by Expense Type MillionsCapital Outlay Contractual Services Supplies FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $0.25 $0.5 $0.75 $1 $1.25 $1.5 Expense Objects Contractual Services Accounting/Auditing Services 80710210-713001 $2,536 $5,000 $5,000 $5,000 Legal Services 80710210-713002 $3,152 $4,500 $4,500 $4,500 Other Professional Services 80710210-713004 $12,587 $41,500 $54,687 $42,500 Insurance and Bonding 80710210-714001 $12,552 $14,000 $14,000 $17,000 Utilities- Other Fuel Types 80710210-717005 $9,607 $14,000 $20,604 $14,000 Total Contractual Services:$40,433 $79,000 $98,791 $83,000 Supplies Equipment Maintenance 80710210-724003 $1,302,705 $1,289,535 $1,292,331 $1,120,711 Total Supplies:$1,302,705 $1,289,535 $1,292,331 $1,120,711 Capital Outlay Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 178 Furniture/Equipment 80710210-731000 $22,627 $0 $0 $0 Total Capital Outlay:$22,627 $0 $0 $0 Total Expense Objects:$1,365,765 $1,368,535 $1,391,122 $1,203,711 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary Note: This budget will be approved by the COIRS Board in October 2023. Depending on the timing, the COIRS budget will be updated prior to final approval of the City's budget. If the timing of the COIRS budget approval by the board is later than expected, the budget will be amended in the first quarter of 2024 to reconcile with the operating budget approved by the COIRS Board. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 179 Fiduciary Fund | Property Assessed Clean Energy (PACE) Jeremiah Gracia Director of Economic Development The budget for Property Assessed Clean Energy (PACE) provides for accounting for the assessments collected on behalf of financing organizations. The City of Dublin acts as a pass-through agent. There is no net financial impact on the City. Fiduciary Fund | PACE Expenditures by Expense Type Budgeted and Historical Expenditures by Expense Type MillionsContractual Services FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $0.25 $0.5 $0.75 $1 $1.25 $1.5 $1.75 Expense Objects Contractual Services County Auditor Deductions 81720740-711001 $11,193 $0 $0 $0 Misc. Contract. Serv.81720740-713005 $1,440,584 $796,790 $796,790 $743,980 Total Contractual Services:$1,451,777 $796,790 $796,790 $743,980 Total Expense Objects:$1,451,777 $796,790 $796,790 $743,980 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 180 Finance Transfers & Advances Matthew Stiffler Chief Financial Officer/Director of Finance The General Fund is the general operating fund of the City; money can be transferred from the General Fund to any other fund with approval of the City Council. A transfer is the permanent movement of money from one fund to another. Operating transfers are made to the Recreation Fund, the Safety Fund, the Hotel Motel Fund, the Cemetery Fund and the Swimming Pool Fund to supplement revenues directly credited to those funds. Funds are transferred when their fund balance drops below the average monthly expenditures anticipated. Transfers to the Capital Improvements Tax Fund and other capital project funds are based on projects identified in the City's Five-Year Capital Improvements Program (CIP). To the extent that cash reserves become available in the General Fund, additional capital projects are programmed in the CIP. An advance is a temporary movement of money from one fund to another. The City has utilized advances, for the most part, to provide initial funding for capital projects associated with the tax increment financing (TIF) districts. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 181 General Fund | Finance Transfers & Advances Expenditures by Expense Type Budgeted and Historical Expenditures by Expense Type MillionsTransfers/Advances FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $10 $20 $30 $40 $50 Expense Objects Transfers/Advances Trans Exp Street Maint Repair 10196290-741201 $0 $0 $0 $500,000 Trans Exp Recreation 10196290-741225 $3,000,000 $4,000,000 $4,000,000 $4,500,000 Trans Exp Pool 10196290-741226 $400,000 $500,000 $500,000 $550,000 Trans Exp Hotel/Motel Tax 10196290-741232 $1,225,000 $1,000,000 $1,000,000 $0 Trans Exp Safety 10196290-741241 $8,250,000 $14,000,000 $14,000,000 $16,500,000 Trans Exp Cemetery 10196290-741261 $105,000 $150,000 $150,000 $200,000 Trans Exp Capital Improv Tax 10196290-741401 $3,180,000 $6,250,000 $13,350,000 $7,820,000 Adv Exp Capital Improv Const 10197290-742404 $0 $0 $11,000,000 $0 Adv Exp Bridge Street 10197290-742457 $1,536,965 $1,536,965 $1,536,965 $1,536,965 Total Transfers/Advances:$17,696,965 $27,436,965 $45,536,965 $31,606,965 Total Expense Objects:$17,696,965 $27,436,965 $45,536,965 $31,606,965 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 182 Budget Summary 10196290 (Transfers) Account 741201 provides operating transfers for the Street Maintenance Fund. For 2024, transfers were not budgeted. Gas tax funds will be utilized to sustain the fund. Transfers for 2024 will be reassessed in the next budget cycle. Accounts 741225-741261 provide operating transfers to support the funds as listed. Account 741262 provides transfers for the Accrued Leave Reserve Account. At this time, amounts have been budgeted in personal services in order to support the Accrued Leave Reserve Account. Account 741401 provides transfers as approved in the Capital Improvements Program (CIP). For 2024, no transfers were programmed. Account 741620 provides transfers for the Sewer Fund. For 2024, no transfers were programmed from the General Fund to the Sewer Fund. 10197290 (Advances) Account 742457 provides an advance to the Bridge Street Fund to cover the City’s agreement with Dublin City Schools and Tolles Career and Technical Center for the Bridge Street District Cooperative Agreement (2014). City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 183 Internal Service Funds Internal service funds are used to account for the financing of goods or services provided by one department or agency to other departments or agencies of the City, or to other governmental units, on a cost-reimbursement basis. The City maintains two internal service funds to account for the City’s employee benefits self-insurance plan and workers’ compensation self-insurance plan activities. City program expenditures are incurred in the funds, and the City’s various departments reimburse the internal service funds for those costs. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 184 Employee Benefits Self-Insurance | Internal Service Fund Jennifer Miglietti Director of Human Resources The Employee Benefits Self-Insurance Fund has been established to account for monies received from other funds as payment for providing medical, pharmaceutical, dental and vision benefits. This fund makes payments for services provided to employees (claims), the third-party administrator(s) and for stop-loss coverage. The budgeted amounts are based on the expected dollar value of claims that would be paid under the plan, third-party administrator fees and the premium for stop-loss insurance. Premiums are charged to benefit accounts based on the estimated cost of coverage. In 2024, funds have been programmed for all non- union personnel and all union personnel, including the United Steelworkers of America, the Fraternal Order of Police – Capital City Lodge No. 9 and the Fraternal Order of Police – Ohio Labor Council to participate in the City's Consumer Driven Health Plan with Health Savings Accounts and the Healthy By Choice (HBC) program. The Employee Benefits Self-Insurance Fund will continue the wellness benefit and the childcare Flexible Spending Account benefit for all full- time employees who participate in HBC. The City's health plan includes a Health Savings Account (HSA) or Health Reimbursement Account (HRA) and will include two funding levels to match the two HSA employer contribution levels for a single employee or an employee who has a family. Personnel Data Position Title 2023 | Adopted 2024 | Adopted Human Resources Coordinator 1 1 Total 1 1 Notes and Adjustments: The annual funding level for 2024 for all employee groups is as follows: Single $13,833 Family $34,143 In order to ensure the proper level of reserves, the funding level was decreased for 2024 to approximately $13,833 for single coverage and $34,143 for family coverage. These decreases were based on projections from United Health Care and Oswald Consulting for the upcoming benefit year, an assessment of the previous year’s fund balances, and they represent a 3.1% decrease for single coverage and a 2.0% decrease for family coverage. The fund balance of the Employee Benefits Self-Insurance Fund is monitored continuously during the year. If additional contributions should become necessary, the annual funding rate will be adjusted accordingly with the approval of the City Council. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 185 Employee Benefits Self-Insurance Expenditures by Expense Type | Internal Service Fund Budgeted and Historical Expenditures by Expense Type MillionsPersonal Services Contractual Services FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $2.5 $5 $7.5 $10 $12.5 Expense Objects Personal Services Full Time Salaries/Wages 70110120-701101 $67,121 $62,955 $62,955 $64,875 Employee Benefits 70110120-701201 $41,700 $41,005 $41,005 $40,690 Total Personal Services:$108,821 $103,960 $103,960 $105,565 Contractual Services Misc. Contract. Serv.70110120-713005 $56,973 $132,805 $210,616 $129,924 Third Party Administrator 70110120-714003 $299,145 $344,525 $360,281 $362,320 Medical Dental Rx Vision 70110120-714005 $6,458,482 $7,786,450 $7,800,422 $7,450,419 Stop Loss Coverage 70110120-714008 $1,580,946 $1,725,215 $1,725,215 $1,993,780 Employer HSA Contribution 70110120-714010 $1,159,401 $1,218,750 $1,218,750 $1,194,375 Total Contractual Services:$9,554,947 $11,207,745 $11,315,285 $11,130,818 Total Expense Objects:$9,663,768 $11,311,705 $11,419,245 $11,236,383 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 186 Budget Summary 70110120 Account 701101 provides funding for staffing reflected under Personnel Data and in the Notes and Adjustments section. Account 701201 provides funding for employee benefits for staff as reflected in Personnel Data. Account 713005 provides funding for miscellaneous contracted services and includes funding for the City’s comprehensive Healthy By Choice (HBC) wellness programs. Funding is included for continuation of the onsite screenings, various educational classes, fitness programs and other wellness-related counselling sessions. Also funded is the continuation of professional benefits consultation, continuation of return on investment analysis and further review of plan design. Account 713010 (previously 702000) provides funding for attendance of annual professional development conferences. Account 714003 reflects funding for third-party administration fees from UnitedHealthCare (UHC) for medical and dental; Guardian; and Vision Services Plan (VSP), the administrator of the City’s flexible spending programs and vision services benefits. Also included is third- party administration for the short-term disability program. Account 714005 includes funding for all medical, dental, pharmacy and vision claims. Claims are expected to increase in 2024 based on projections made by Oswald Consulting. Account 714008 provides funding for a stop-loss insurance policy to protect the City against catastrophic or extraordinarily high-cost claims. The City has had a history of experiencing continuous high cost claims that are not projected to cease in the foreseeable future. Because of this trend, the City’s stop-loss is projected to increase by 2024. Account 714010 provides funding for employer contributions (funded at 100%) for Health Spending Account (HSA) contributions. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 187 Workers' Compensation | Internal Service Fund Jennifer Miglietti Director of Human Resources The Workers' Compensation Fund has been established to cover the costs associated with the City's Workers' Compensation coverage under a self-insurance plan. Funds are transferred from the General Fund to cover premiums, claims and third-party administration fees associated with the City's Workers' Compensation coverage. This budget reflects estimated costs for the City’s Self-Insurance Workers’ Compensation coverage, which includes expected medical expenses and compensation associated with work-related injuries and illnesses from Jan. 1, 2024, to Dec. 31, 2024. This budget also reflects estimated fees for excess workers’ compensation insurance coverage and volunteer insurance coverage. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 188 Workers' Compensation Expenditures by Expense Type | Internal Service Fund Budgeted and Historical Expenditures by Expense Type MillionsContractual Services FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $0.1 $0.2 $0.3 $0.4 $0.5 Expense Objects Contractual Services Misc. Contract. Serv.70310120-713005 $0 $6,000 $6,000 $6,000 Third Party Administrator 70310120-714003 $13,152 $46,650 $92,109 $48,650 Other Claims 70310120-714007 $240,293 $289,290 $273,290 $276,873 Stop Loss Coverage 70310120-714008 $81,097 $97,200 $126,703 $109,200 Total Contractual Services:$334,542 $439,140 $498,102 $440,723 Total Expense Objects:$334,542 $439,140 $498,102 $440,723 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 70310120 Account 713005 provides funds for investigation of fraudulent claims. Account 714003 includes the administrative fee for the self-funded program, independent medical evaluations of injured employees and administrative fees for the state fund. Account 714007 funds medical and indemnity reserves for prior year claims and estimated 2024 claims. Account 714008 includes the required payment to the state guarantee fund and the state fee for a self-insured plan. Also included are the excess coverage premium and volunteer coverage premium, which are projected to increase in 2024. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 189 Finance | Special Revenue Fund Matthew Stiffler Chief Financial Officer/Director of Finance City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 190 Accrued Leave Reserve | Special Revenue Fund Matthew Stiffler Chief Financial Officer/Director of Finance The Ohio Revised Code Section 5705.13 provides for the establishment of reserve funds for certain purposes, one of which is for the payment of accumulated sick, vacation and compensatory leave upon termination of employment or retirement. Because the City of Dublin will have a significant number of long-term employees either reach retirement age or the point of eligibility within either the Ohio Public Employees Retirement System or the Police/Fire Pension Fund System, the City’s liability for payments for accrued leave balances is estimated to be substantial beginning in the next few years. These costs represent a liability accrued over a number of years. In order to prevent a disproportionate impact of these payments on any one budget year, the 2005 budget established a reserve fund and began depositing into it in anticipation of this liability. In 2008, the City implemented changes to its leave policies for non-bargaining employees which will add to the City’s potential liability for conversion of accrued leaves. Beginning in 2009, non-bargaining employees were eligible for conversion of a portion of accrued sick leave to cash at the time of any separation in good standing from City employment. This includes all types of leave accruals and both pensionable and non-pensionable leave amounts. Personnel Data There are no staff positions directly allocated to this fund. Notes and Adjustments: Contributions to this fund represent a percentage of full-time wages. Beginning in 2009, the expenditures budgeted in this fund also included an estimate for sick leave conversions for non-bargaining employees at separation from employment in good standing at any time. Because sick leave accruals were substantially reduced in 2009 (per the Compensation Plan), this liability has declined over time. Sick leave balances accrued under the previous, more generous accruals are either used or converted to payment at separation. For all City bargaining units, conditions for conversion of accrued sick leave remain contingent on eligibility for retirement, minimum years of service and any minimum sick leave balance requirements. Budget Summary 26210210 Account 701201 provides for Medicare on employee payouts. Account 701205 reflects the estimated payments that will be made for accrued leaves in 2024 based on anticipated retirements. The amount also includes an estimate of conversions at nonretirement separations based on the revised leave policies for non-bargaining employees approved in 2008. Un-used appropriations lapse at year-end. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 191 Opioid Relief Fund | Special Revenue Fund Matthew Stiffler Chief Financial Officer/Director of Finance The OneOhio Opioid Relief Fund was created to accept deposits related to the State of Ohio, Local Governments and the Plaintiff's Executive Committee of the National Prescription Opiate Multidistrict Litigation that negotiated the OneOhio Memorandum of Understanding (MOU). Local governments encompassing more than two-thirds of the state's population signed on to the OneOhio MOU, a plan to jointly approach settlement of the litigation with the drug manufacturers and distributors of opioids. The MOU provides a mechanism for the distribution of any opioid settlement funds and outlines how the funds can be used. The City expects to receive payments over the next 18 years totaling approximately $200,000. These funds will be used in accordance with the MOU discussed above and appropriated as part of the operating budget process. Funds are not currently appropriated in 2024. A supplemental appropriation will be brought forward to City Council at the time the use of funds is determined. Expenditures by Expense Type There are no budgeted expenditures in 2024 for Fund 267. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 192 Law Enforcement Trust | Special Revenue Fund Justin Páez Chief of Police Ordinance 94-90 authorized the establishment of the Law Enforcement Trust Fund. Revenues in the fund are derived from contraband property seizures in accordance with §2981.13 of the Ohio Revised Code. This fund is to be used to pay the costs of prolonged or complex investigations or prosecutions, to provide reasonable technical training or expertise, to provide matching funds to obtain federal grants to aid law enforcement or for other law enforcement purposes that City Council determines to be appropriate. Personnel Data There are no personnel directly allocated to Enforcement and Education. Oversight of this Fund is by the Chief of Police. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 193 Law Enforcement Trust Expenditures by Expense Type | Special Revenue Fund Budgeted and Historical Expenditures by Expense Type MillionsContractual Services Capital Outlay FY2018FY2019FY2020FY2021FY2022FY2023$0 $0.005 $0.01 $0.015 $0.02 $0.025 $0.03 Expense Objects Contractual Services Misc. Contract. Serv.24250820-713005 $206 $0 $0 $0 Total Contractual Services:$206 $0 $0 $0 Capital Outlay Furniture/Equipment 24280820-731000 $3,921 $5,000 $43,700 $0 Total Capital Outlay:$3,921 $5,000 $43,700 $0 Total Expense Objects:$4,127 $5,000 $43,700 $0 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 24250820 Account 731005 provides fees to the county courts and prosecutor’s offices; funds are not appropriated until needed. 24280820 Account 731000 provides funding for training and equipment for forensic investigation of computers. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 194 Wireless 911 | Special Revenue Fund Justin Páez Chief of Police Ohio Revised Code (ORC) §128.42 establishes a $0.50 per month user fee on every wireless phone bill to reimburse local public safety answering points for costs associated with receiving 911 calls placed from wireless telephones. As directed by ORC §128.55, the Wireless 911 Governmental Assistance Fund is administered by the Franklin County Commissioners, with funds disbursed in accordance with the formula set by the local 911 Planning Committee. To facilitate disbursement, local agencies are required to enter into intergovernmental agreements. In February 2017, the City of Dublin entered into an agreement with the Franklin County Commissioners for the disbursement of these funds. Disbursements received from the Wireless 911 Governmental Assistance Fund must be used in accordance with ORC §128.57, which includes those costs incurred in designing, upgrading, purchasing and maintaining equipment as well as training staff who answer wireless 911 calls. Disbursements received may be used for personnel costs once all equipment purchases are completed. Personnel Data There are no personnel directly allocated to Enforcement and Education. Oversight of this Fund is by the Chief of Police. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 195 Wireless 911 Expenditures by Expense Type | Special Revenue Fund Budgeted and Historical Expenditures by Expense Type MillionsSupplies Transfers/Advances Capital Outlay FY2018FY2019FY2020FY2021FY2023$0 $0.1 $0.2 $0.3 $0.4 $0.5 Expense Objects Capital Outlay Police Capital Equipment 24480841-734001 $0 $425,000 $425,000 $0 Total Capital Outlay:$0 $425,000 $425,000 $0 Total Expense Objects:$0 $425,000 $425,000 $0 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 24410820 Account 724001 provides funding for communications system updates. 24496820 Account 741000 is utilized to transfer funds to reimburse the Safety Fund for allowable expenses, including eligible personnel expenditures. This is removed for 2023. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 196 Special Revenue Fund | Permissive Tax Paul Hammersmith Director of Engineering Funds are received from a $5 tax on motor vehicle licenses approved by Franklin County under Ohio Revised Code (ORC) Section 4504.02. Under ORC Section 4504.04, Dublin may request funding from Franklin County for individual projects approved by the Franklin County Engineer’s Office and Franklin County Commissioners. Eligible projects must be for roadway construction or improvements. Additional funds are also received directly into Dublin's Treasury under ORC Section 4504.15 per legislation approved by Franklin and Delaware counties to increase motor vehicle license tax by $5 in each respective county. Dublin receives 50% of the revenue generated by this additional tax, which is also restricted to roadway construction and improvements. Personnel Data There are no staff positions allocated to this budget. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 197 Special Revenue Fund | Permissive Tax Expenditures by Expense Type Budgeted and Historical Expenditures by Expense Type MillionsCapital Outlay Transfers/Advances FY2018FY2019FY2020FY2021FY2022FY2023FY2024$0 $0.2 $0.4 $0.6 $0.8 $1 Expense Objects Transfers/Advances Advances Expense 23197320-742000 $200,000 $150,000 $150,000 $150,000 Total Transfers/Advances:$200,000 $150,000 $150,000 $150,000 Total Expense Objects:$200,000 $150,000 $150,000 $150,000 Name Account ID FY2022 Actual FY2023 Original Budget FY2023 Revised Budget FY2024 Original Budget Budget Summary 23180320 Account 735006 provides funding for Capital Improvements Program (CIP) projects. (None for 2024) 23197320 Account 742000 provides funding for the repayment of advances as planned. City of Dublin, Ohio | 2024 Operating and Capital Improvements Budget Page 198