Committee of the Whole

AGENDA CITY OF WAUPUN COMMITTEE OF THE WHOLE Waupun City Hall – 201 E. Main Street, Waupun WI Tuesday, February 28, 2023 at 5:30 PM The Waupun Committee of the Whole will meet In-person, virtual, and teleconference. Instructions to join the meeting are provided below: Virtual: https://us02web.zoom.us/j/89746634417?pwd=WVZqeDNQeStURmVtRGNwRFlqSkhTZz09 Dial by your location: 1 312 626 6799 Meeting ID: 897 4663 4417 Passcode: 995651 CALL TO ORDER ROLL CALL PUBLIC APPEARANCE - ENVISION GREATER FOND DU LAC 1. 2020 Census Data and Trends Impacting Our Community CONSENT AGENDA 2. Future Meetings & Gatherings, License and Permit Applications, Expenses ORDINANCES-RESOLUTIONS 3. Ordinance to amend Ch.16.01(10) entitled Zoning Map - Rezoning Request to PCD Planned Community Development District (2, 4, 6, 8 E.Franklin St., and 17 and 23 Jackson St.) 4. Resolution Approving Assignment of General Fund Balances in Accordance with Governmental Accounting Standards 5. Resolution Urging Legislature and Governor to Fix Broken System of Funding Critical Local Services CONSIDERATION - ACTION 6. Payoff of 2009 Business Park Sewer Utility Promissory Note 7. Monthly Financial Report- January 2023 8. Request to Expand Police Training Position as part of Workforce Planning Efforts 9. Homan Semi Annual Benefit Event - REACH Donation ADJOURNMENT Upon reasonable notice, efforts will be made to accommodate disabled individuals through appropriate aids and services. For additional information, contact the City Clerk at 920-324-7915.  AGENDA SUMMARY SHEET MEETING DATE: 2/28/23 TITLE: 2020 Census Data and Trends Impacting Our Community AGENDA SECTION: PUBLIC APPEARANCE PRESENTER: Kathy Schlieve, Administrator DEPARMTENT GOAL(S) SUPPORTED (if applicable) FISCAL IMPACT High Performance Government N/A ISSUE SUMMARY: Sarah Van Buren, Director of Business Intelligence for Envision Greater Fond du Lac, will provide an overview of 2020 Census data and trends that will impact the future of our community. STAFF RECOMENDATION: ATTACHMENTS: None RECOMENDED MOTION:  AGENDA SUMMARY SHEET MEETING DATE: 02/28/2023 TITLE: Future Meetings & Gatherings, License and Permit Applications, Expenses AGENDA SECTION: CONSENT AGENDA PRESENTER: Angela Hull, Clerk ISSUE SUMMARY: Future meetings/gatherings of the Common Council, consideration of licenses/permits, payment of expenses. Future Meetings/Gatherings of the Body of the Common Council (All meetings begin at 6:00pm unless otherwise noticed) Tuesday, March 14, 2023 Common Council 6:00PM Tuesday, March 28, 2023 Committee of the Whole 6:00PM Tuesday, April 11, 2023 Common Council 6:00PM Tuesday, April 18, 2023 Re-Organizational Meeting 5:30PM Tuesday, April 25, 2023 Committee of the Whole TBD License and Permit Applications OPERATOR LICENSE: Lore Bossenbroek TEMPORARY CLASS B: ATTACHMENTS: Expense Report(s) RECOMENDED MOTION: Motion to approve the Consent Agenda (Roll Call)  ORDINANCE # 23 - ___ AN ORDINANCE TO AMEND CHAPTER SIXTEEN OF THE MUNICIPAL CODE OF THE CITY OF WAUPUN ENTITLED "ZONING ORDINANCE." THE COMMON COUNCIL OF THE CITY OF WAUPUN ORDAINS: SECTION 1: Section 16.01 (10) of the Municipal Code of the City of Waupun entitled “Zoning Map” is amended so that real estate currently owned by Mr. Storage LLC with the following addresses 2 E. Franklin St, 4 E. Franklin St., 6 E Franklin St., 8 E. Franklin St., 17 Jackson St., and 23 Jackson St. presently zoned in the M-1 Closed Storage/Light Manufacturing District is rezoned to the PCD Planned Community Development District. The real estate to be rezoned is described as follows: Parcel #: WPN-14-15-99-OV-076-03 S32 T14N R15E NORTH WARD OUTLOTS O.L. 79 80 81 & 82 EXC N 20' OF E 66' OF O.L. 81 & EXC V1136-496 & EXC V1305-712 SECTION 2: This Ordinance shall be in full force and effect upon its passage and publication as provided by law. Enacted this__ __ day of ____________, 2023. ______________________ Rohn W. Bishop, Mayor ATTEST: ____________________ Angela J. Hull, City Clerk  AGENDA SUMMARY SHEET MEETING DATE: 2-28-23 TITLE: Resolution Approving Assignment of General Fund Balances in Accordance with AGENDA SECTION: RESOLUTIONS AND ORDINANCES Governmental Accounting Standards PRESENTER: Casey Langenfeld, Finance Director DEPARTMENT GOAL(S) SUPPORTED (if applicable) FISCAL IMPACT Assignment of general fund balances will support future costs, while helping to stay within fund balance policy limits SUMMARY: The 12/31/2022 unassigned general fund balance is projected to fall above the City’s financial policy of 30-40% of general fund revenues. This resolution will allow for a portion of the fund balance to be set aside (“assigned”) for the payoff of the Utility Sewer debt due March 1, 2023, cost associated with the purchase of an ambulance, and capital projects. This method of reserving funds will and help the City stay within fund balance policy limits, while providing support for future debt payments, the costs for the EMR program and future capital project costs. ATTACHMENTS: Resolution Approving Assignment of General Fund Balances in Accordance with Governmental Accounting Standards RECOMMENDED MOTION: Approve Resolution #02-28-23-__ Authorizing Assignment of General Fund Balance in Accordance with Governmental Accounting Standards  Resolution No. 02-28-23-____ RESOLUTION APPROVING ASSIGNMENT OF GENERAL FUND BALANCES IN ACCORDANCE WITH GOVERNMENTAL ACCOUNTING STANDARDS WHEREAS, the Governmental Accounting Standards Board issued its Statement No. 54, Fund Balance Reporting and Governmental Fund Type Definitions (“GASB 54”), and the City of Waupun was first required to adopt the provisions of GASB 54 for its financial statements for the year ending December 31, 2011; and WHEREAS, GASB 54 requires legislative action by the governing body to recognize constraints for specific purposes of certain portions of the City’s general fund balance in order to classify such amounts as assigned, as defined in the accounting standard. NOW, THEREFORE, BE IT RESOLVED by the Common Council of the City of Waupun, that the general fund balance reported in the City’s financial statements include amounts assigned for (a) land acquisition and (b) park improvements, computed as of the end of the fiscal year. Passed and adopted by the Common Council this 28th day of February, 2023. _____________________________ Rohn W. Bishop Mayor ATTEST: ____________________________ Angela J. Hull City Clerk  AGENDA SUMMARY SHEET MEETING DATE: 2/28/2023 TITLE: Resolution Urging Legislature and Governor to Fix Broken System of Funding Critical Local AGENDA SECTION: ORDINANCES-RESOLUTIONS Services PRESENTER: Kathy Schlieve, Administrator Casey Langenfeld, Finance Director DEPARTMENT GOAL(S) SUPPORTED (if applicable) FISCAL IMPACT Advocacy SUMMARY: The resolution as drafted requests legislative action to fix a broken funding model that limits local government’s ability to deliver local services. ATTACHMENTS: Resolution Urging Legislature and Governor to Fix Broken System of Funding Critical Local Services. RECOMMENDED MOTIONS: Approve the Resolution 2023-02-28-__ Urging Legislature and Governor to Fix Broken System of Funding Critical Local Services  Resolution No. 02-28-23-____ RESOLUTION URGING LEGISLATURE AND GOVERNOR TO FIX BROKEN SYSTEM OF FUNDING CRITICAL LOCAL SERVICES WHEREAS, Wisconsin’s system for funding vital local services like police, fire protection, EMS, well maintained streets, parks and libraries is broken, unsustainable, and needs to be reformed; and WHEREAS, communities are forced to rely on property taxes and flat or declining state aid to pay for critical local services that residents and businesses need; and WHEREAS, state sales and income tax revenues have tripled in the last 30 years, but the share of those taxes going to support police, fire, EMS, and other local services has gone down; and WHEREAS, over the last 20 years, state aid for police, fire, and other critical services has steadily declined in real dollars, while inflation has caused average prices to increase by 51 percent. (The funding level for County and Municipal Aid in 2003 was $938,529,507. Today, it is $753,032,613); and WHEREAS, Municipal Aid payments to the City of Waupun have dropped from $3,257,048 in 2003 to $2,647,504 in 2022. WHEREAS, the steady decline in the state’s contribution to the cost of critical local services has forced communities to rely more heavily on property taxes to maintain police, fire, and EMS service levels; and WHEREAS, the over reliance on property taxes to pay for critical local services must end; and WHEREAS, to compete globally, Wisconsin needs to develop and maintain quality communities that can attract and retain talent and enterprise and spur job creation; and WHEREAS, for local communities to flourish and the state’s economy to grow, state and local leaders must work collaboratively; and WHEREAS, Local governments need reliable, growing, sustainable, and diverse sources of revenue to continue to deliver police, fire protection, ambulance services and safe streets now and into the future. NOW, THEREFORE, BE IT RESOLVED, that the City of Waupun urges the Legislature and the Governor to work collaboratively with the League of Wisconsin Municipalities, Wisconsin Counties Association, Wisconsin Towns Association, other local government leaders, and business leaders to create a better way of funding local governments that includes revenue options other than property taxes to continue delivering police, fire, EMS, and other critical services. Passed and adopted by the Common Council this 28th day of February, 2023. _____________________________ Rohn W. Bishop, Mayor ATTEST: ____________________________ Angela J. Hull, City Clerk FINANCIAL UPDATE MUNICIPAL REVENUE TRENDS 2/28/23 WAUPUN GENERAL FUND REVENUE SOURCES Wisconsin municipalities currently receive most funding from two sources: property taxes and state aid. Other Fees 4% 1% STATE AID $3,349,956 - Municipal Service Payment - Shared Revenue - Transportation Aids Taxes State Aid TAXES $2,235,122 38% 57% FEES $286,766 OTHER $104,296 HISTORY OF SHARED REVENUE • Shared Revenue was established to ensure that local residents do not bear the entire burden of providing services. • Since 2002 payments have been distributed strictly on a historic basis. • In the absence of any cuts in funding, communities receive roughly the same amount each year. Municipality Magazine 1/1/2011 chrome-extension://efaidnbmnnnibpcajpcglclefindmkaj/https://www.lwm- info.org/DocumentCenter/View/162/Municipality-Magazine-Article-PDF?bidId= WAUPUN SHARED REVENUE HISTORY 2005-2022 Shared Revenues Have Trended Downward But Costs Have Not Source: WI Dept of Administration https://www.revenue.wi.gov/Pages/RA/Shared-Revenue.aspx Time Value of Money (CPI 2005 – 2022) CPI increased 45% over time period; Shared Revenues not indexed to inflation and costs are rising Source: Midwest Urban CPI https://data.bls.gov/pdq/SurveyOutputServlet?data_tool=dropmap&series_id=CUUR0200SA0,CUUS0200SA0 WHAT WOULD WAUPUN’S SHARED REVENUE BE IF THE STATE HAD INCREASED THE ANNUAL PAYMENT WITH INFLATION? To keep pace with LEVY LIMITS ENACTED inflation, Shared Revenues would have needed to increase an additional $1,328,391 since 2005 levy limits were enacted Source: Midwest Urban CPIhttps://data.bls.gov/pdq/SurveyOutputServlet?data_tool=dropmap&series_id=CUUR0200SA0,CUUS0200SA0 Source: WI Dept of Administration https://www.revenue.wi.gov/Pages/RA/Shared-Revenue.aspx WAUPUN TAX LEVY HISTORY 2005-2023 As state aides shrink, more burden shifts to the local property tax payer. Over same time period, the City’s Tax Levy increased 67%. Budget Solutions:  Positions Reduced (DPW & Police)  Periodic – No Wage Adjustments  Changes to Health Insurance  Reduction in Services  Municipal Court Introduction  Full Cost Recovery PSLO  User Fees  Creation of OPEB Fund  Increased Debt Source: City of Waupun Annual Budget Documents EXPENDITURE RESTRAINT PAYMENT (ERP) • To qualify, the city is required to increase their general expenses within a certain margin each year. • At some point, a municipality may have to forgo the ERP payment in order to increase their base to allow for more expenses. • Allowable increase is usually tied to a communities net new construction adjustment, however for the 2022-2023 budget the percentage was adjusted for CPI allowing communities to increase their expenses. WEB Handbook for Wisconsin Municipal Officials 2019 EXPENDITURE RESTRAINT PAYMENT 2012-2023 $80,000 $74,434 $72,118 $70,000 $70,436 $69,162 $60,000 $51,014 $51,485 $50,000 $40,000 $37,061 $42,927 $43,705 $30,000 $32,352 $29,671 $20,000 $10,000 0 $0 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 WHAT DO MUNICIPALITIES DO WHEN THEY DON’T HAVE ENOUGH AID FROM THE STATE? • Incorporate new revenue streams into their community: Wheel Tax, Increase Fees, Charge Fees that weren’t charged previously • Reduce expenses • Referendum to increase levy limits • Incur more debt WEB Handbook for Wisconsin Municipal Officials 2019 CURRENT DEBT SNAPSHOT 2023 DEBT PAYMENTS: $1,613,935 (2.9% increase) TOTAL DEBT: $12.14M (53% of limit per city policy) 2023 DEBT LEVY: $788,080 (.62% increase over prior year) MUNICIPAL SERVICES PAYMENTS (MSP) PROGRAM • Payment to a municipality in recognition of critical services directly provided to State Agencies located within a community. • Intent is to aid in the reduction of local real property taxes by making a State contribution toward the cost of certain municipality-provided services financed out of the local property tax revenue. • The services include: Fire, Police and Solid Waste pick-up / disposal costs. • Many legislators believe that communities derive benefits from state facilities that justify the current level of funding (i.e., housing, jobs, economic stability, etc.) https://doa.wi.gov/Pages/LocalGovtsGrants/Municipal_Services_Payments.aspx TOTAL STATEWIDE MSP PAYMENTS CAPPED SINCE 2011 AS COSTS RISE • Established in 1973. • 1.5% of State Aid payments for Waupun • State-wide MSP payments have been capped at $18.6M since 2011 while costs have continued to rise. • Governed by WI Stat. 70.119 allows for proration of payments when state funds are inadequate (increasing since 1983). • In 2022, the state reimbursed 38.2% of costs statewide, leaving a gap of $30.2M of unreimbursed costs in that year. Source: WI Policy Forum Serving State Facilities, September 2020  CITY OF WAUPUN MSP HISTORY (2013 – 2022) Between 2013 and 2022: • Estimated Adj Entitlements: $1.3M • Prorated Entitlements: $501K • Costs continue to rise, resulting in a drop in MSP funding coverage (44.6% in 2013; 38.12% in 2022) • Average Annual Allocation: $50,081 Source: City of Waupun Municipal Budgets; DOA MSP Database  SNAPSHOT OF 2023 MSP FOR OTHER COMMUNITIES W/ DOC FACILITIES State Facility Prorated Total County Name Municipality Name Value Adjusted Police Adjusted Fire Adjusted Total Paid Unpaid Total Columbia C Portage $118,189,100 $68,485.54 $131,186.16 $199,671.70 $76,119.24 $123,552.46 Dodge T Fox Lake $100,492,000 $2,090.30 $47,919.42 $50,009.72 $19,064.80 $30,944.92 Dodge C Waupun $241,808,500 $51,727.48 $89,774.76 $141,502.24 $53,943.76 $87,558.48 Fond du Lac C Fond du Lac $114,707,100 $158,425.39 $275,168.33 $433,593.72 $165,295.45 $268,298.27 Sheboygan T Greenbush $79,862,800 $0.00 $10,591.89 $10,591.89 $4,037.86 $6,554.03 Waushara V Redgranite $90,240,900 $24,947.39 $42,045.49 $66,992.88 $25,539.16 $41,453.72 Winnebago C Oshkosh $869,286,900 $1,040,731.98 $1,727,707.60 $2,768,439.58 $1,055,389.96 $1,713,049.62 TOTAL $1,614,587,300 $1,346,408.08 $2,324,393.65 $3,670,801.73 $1,399,390.23 $2,271,411.50 COVERAGE 38.12% • CY 2023 MSP funds 38.12% of Adjusted Total for each community (based on CY 2021 expenditures) Source: Dept of Administration CY 2023 Payment Schedule for Services Provided During CY 2021 2023 SERVICE REDUCTIONS RESULTING FROM FUNDING CHALLENGES  Reduce a .5 economic development position within the City ($35K).  Reduce sealcoating budget for streets by 50% ($15k).  Reduce mill & overlay capital budget by 11% ($30k).  Postpone capital expenditures needed to maintain our museum ($62K).  Slower implementation of sidewalk replacement and ADA upgrades to sidewalk plan due to escalating costs.  Delay street reconstruction (from an every-other-year capital project plan to one project every third year.)  Delay numerous outdoor recreation improvements needed to enhance quality of life indefinitely.  Maintain a flat library levy for the third year in a row.  Delay purchase of a fire ladder truck (Estimated at $1.7M) and construction of post-incident showers ($400K) to mitigate health risks for our volunteer fire department.  Street-line painting moved from an every year to an every-other-year expenditure ($1,100).  Cut $19K from police/capital budget that delays Lexipole software implementation needed to mitigate risk and improve public safety within your communities.  Delay payroll and licensing software ($17K) needed to increase efficiency of administrative services.  ADVOCACY TO REFORM MUNICIPAL FUNDING MODELS Current Funding Model Implications: Funding Reform Should Consider: • Increases overreliance on property taxes • Reduce overreliance on property taxes • Contributes to regional inequities • Produce a sustainable, growing sources of revenue for local governments • Incentivizes short-term budget fixes (borrowing and/or differed maintenance) • Increased state support for public safety • Incentivizes utilization of special fees • Address investment in local transportation needs • Forces service cuts and staff reductions • Diversify of local revenue sources and eliminations of core services  AGENDA SUMMARY SHEET MEETING DATE: 2/28/2023 TITLE: Payoff of 2009 Business Park Sewer Utility Promissory Note AGENDA SECTION: CONSIDERATION-ACTION PRESENTER: Casey Langenfeld DEPARTMENT GOAL(S) SUPPORTED (if applicable) FISCAL IMPACT SUMMARY: As agreed with Waupun Utilities, the City will pay off the outstanding 2009 Business Park Sewer Utility Promissory Note. The amount of the payoff was included in the 2023 Business Park Budget. City of Waupun Advance From Sewer Utility Date of Loan: 12/21/2019 Loan Amount: $ 428,440.00 Interest rate: 2% per annum Principal Principal Total Year Interest Rate Payments Balance Interest P&I 12/21/2019 2.00% - 428,440 8,568.80 8,568.80 7/1/2020 2.00% 100,000 328,440 4,522.42 104,522.42 7/1/2021 2.00% 36,494 291,946 6,568.80 43,062.80 7/1/2022 2.00% 36,494 255,452 5,838.92 42,332.92 7/1/2023 2.00% 36,494 218,958 5,109.04 41,603.04 7/1/2024 2.00% 36,493 182,465 4,379.16 40,872.16 7/1/2025 2.00% 36,493 145,972 3,649.30 40,142.30 7/1/2026 2.00% 36,493 109,479 2,919.44 39,412.44 7/1/2027 2.00% 36,493 72,986 2,189.58 38,682.58 7/1/2028 2.00% 36,493 36,493 1,459.72 37,952.72 7/1/2029 2.00% 36,493 - 729.86 37,222.86 TOTAL 45,935.04 474,375.04 Debt pa yment of $45,000 ma de 11/22 to Util i ties . Thi s i s the s econd pa yment for the yea r 2022 a nd wa s a uthori zed by the Counci l . $ 255,452 payment 11/22/22 $ (45,000) Pay of f amount 1st Qtr 2023 $ 210,452 ATTACHMENTS: None RECOMMENDED MOTIONS: Approve the final payment to Waupun Utilities for the payoff of the 2009 Business Park Sewer Utility Promissory Note in the amount of $210,452.  AGENDA SUMMARY SHEET MEETING DATE: 2/28/2023 TITLE: Monthly Financial Report- January 2023 AGENDA SECTION: CONSIDERATION-ACTION PRESENTER: Casey Langenfeld, Finance Director DEPARTMENT GOAL(S) SUPPORTED (if applicable) FISCAL IMPACT SUMMARY: Providing a monthly financial report review, along with a summary of any revenues or expenditures that should be brought to the Council’s attention. ATTACHMENTS: January 2023 Monthly Financial Report RECOMMENDED MOTIONS: Motion to accept and recommend to the Common Council the approval of the January 2023 monthly financial report.  MONTHLY FINANCIAL REPORT 2023 January Revenues Expenses $22,215 - Library Board approved to move 2022 surplus from Library Fund to the Capital Project fund in 2023.  MONTHLY FINANCIAL REPORT JANUARY 31, 2023 A B C D E % of Year Past 1 8% 2 FUND 100 3 General Operations Fund 1/31/2023 1/31/2023 1/31/2023 1/31/2023 4 Month Activity YTD Actual Budget Amount Unearned Percent 5 REVENUE 6 TAXES 1,207 1,207 2,405,770 2,404,563 0.05 7 SPECIAL ASSESSMENTS - - 100 100 0.00 8 INTERGOVERNMENTAL AIDS 2,867 2,867 3,340,523 3,337,656 0.09 9 LICENSES & PERMITS 286 286 58,160 57,874 0.49 10 PENALTIES, FOREFEITURES 1,275 1,275 45,500 44,225 2.80 11 PUBLIC CHARGES FOR SERVICE 34,256 34,256 266,368 232,112 12.86 12 INTERGOVERNMENTAL CHARGES - - - - 0.00 13 MISCELLANEOUS REVENUE 213 213 50,000 49,787 0.43 14 SPECIAL FUNDS ACTIVITY - - 710,046 710,046 0.00 15 TOTAL REVENUE 40,105 40,105 6,876,467 6,836,362 16 17 18 EXPENDITURES 19 GENERAL GOVERNMENT 193,486 193,486 1,880,661 1,687,175 10.29 20 ECO DVLP/ADMIN 18,209 18,209 37,161 18,952 49.00 21 RECREATION 10,811 10,811 385,944 375,133 2.80 22 ASSESSOR/INSPECTOR 3,186 3,186 39,875 36,689 7.99 23 POLICE 169,405 169,405 2,288,462 2,119,057 7.40 24 FIRE 28,567 28,567 522,597 494,030 5.47 25 PUBLIC WORKS 101,701 101,701 1,721,767 1,620,066 5.91 26 TOTAL EXPENDITURES 525,364 525,364 6,876,467 6,351,103 27 28 NET REVENUE OVER EXPENDITURES (485,260) (485,260) 0 485,260 29 30 31 32 33 34 35 36 37 38 39 JANUARY 31, 2023 BUDGET SUMMARY 2 41 FUND 200 42 Trust Fund A B C D E 43 Month Activity YTD Actual Budget Amount Unearned Percent 44 REVENUE 45 ST AID-WINNEFOX/MID-WISC - - - - 0.00 46 INTEREST/DIVIDEND/GRANT - - 75 75 0.00 47 UNREALIZED GAINS - - - - 0.00 48 TOTAL REVENUE - - 75 75 49 50 51 EXPENDITURES 52 OPERATING TRANSFER OUT - - - - 0.00 53 LIBRARY EXPENSES - - - - 0.00 54 TOTAL EXPENDITURES - - - - 55 56 NET REVENUE OVER EXPENDITURES - - 75 75 57 58 59 60 62 FUND 210 63 Library Fund 64 Month Activity YTD Actual Budget Amount Unearned Percent 65 REVENUE 66 GENERAL PROPERTY TAXES - - 516,792 516,792 0.00 67 INTEREST/DIVIDEND/GRANT - - 213,938 213,938 0.00 68 FEES 213 213 1,200 987 0.00 69 DIVIDEND/REVENUE/DONATIONS - - 11,000 11,000 0.00 70 TOTAL REVENUE 213 213 742,930 742,717 71 72 73 EXPENDITURES 74 LIBRARY EXPENSES 42,895 42,895 742,930 700,035 0.00 75 TRANSFER OUT - CAPITAL FUND - - - - 0.00 76 TOTAL EXPENDITURES 42,895 42,895 742,930 700,035 77 78 NET REVENUE OVER EXPENDITURES (42,683) (42,683) - 42,683 79 JANUARY 31, 2023 BUDGET SUMMARY 3 80 81 FUND 220 A B C D E 82 Grants and Donations Fund 83 Month Activity YTD Actual Budget Amount Unearned Percent 84 REVENUE 85 PSC/FEDERAL GRANT - - - - 0.00 86 GRANTS 553 553 6,010 5,457 9.20 87 TOTAL REVENUE 553 553 6,010 5,457 88 89 90 EXPENDITURES 91 GEN GOVERNMENT - - - - 0.00 92 GRANT EXPENSES - RECREATION - - - - 0.00 93 GRANT EXPENSES - POLICE 310 310 5,000 4,690 0.00 94 GRANT EXPENSES - FIRE/EMR - - - - 0.00 95 GRANT EXPENSES - DPW - - - - 0.00 96 ECONOMIC DEVELOPMENT EXPENSES - - 1,000 1,000 0.00 97 TOTAL EXPENDITURES 310 310 6,000 5,690 98 99 NET REVENUE OVER EXPENDITURES 243 243 10 (233) 100 101 102 103 FUND 230 104 Building Inspection Fund 105 Month Activity YTD Actual Budget Amount Unearned Percent 106 REVENUE 107 GENERAL PROPERTY TAXES-BLDG IN - - - - 0.00 108 PERMITS-BUILDING 3,577 3,577 75,000 71,423 4.77 109 FEES 835 835 9,150 8,315 9.13 110 TOTAL REVENUE 4,412 4,412 84,150 79,738 111 112 113 EXPENDITURES 114 OPERATING SUPPLIES/WAGES 1,129 1,129 86,816 85,687 1.30 115 TOTAL EXPENDITURES 1,129 1,129 86,816 85,687 116 117 NET REVENUE OVER EXPENDITURES 3,283 3,283 (2,666) (5,948) 118 119 JANUARY 31, 2023 BUDGET SUMMARY 4 120 121 FUND 240 A B C D E 122 ARPA Fund Month Activity YTD Actual Budget Amount Unearned Percent 123 124 REVENUE 125 FED GRANT (PD BY STATE)-ARPA - - - - 0.00 126 INTEREST INCOME-ARPA - - 7,500 7,500 0.00 127 TOTAL REVENUE - - 7,500 7,500 128 129 130 EXPENDITURES 131 ARPA POLICE OPERATING EXP - - - - 0.00 132 ARPA EXPENSES - - - - 0.00 133 TOTAL EXPENDITURES - - - - 134 135 NET REVENUE OVER EXPENDITURES - - 7,500 7,500 136 137 138 139 FUND 300 140 Debt Fund Month Activity YTD Actual Budget Amount Unearned Percent 141 142 REVENUE 143 PAID TO ESCROW AGENT - - - - 0.00 144 GENERAL PROPERTY TAXES - - 788,080 788,080 0.00 145 FUNDS APPLIED - - 375 375 0.00 146 DEBT SERVICE SURPLUS APPLIED 59,785 59,785 827,080 767,295 7.23 147 TOTAL REVENUE 59,785 59,785 1,615,535 1,555,750 3.70 148 149 150 EXPENDITURES 151 ROCK NEWTON 2021 P&I 11,175 11,175 137,350 126,175 8.14 152 PRINCIPAL AND INTEREST PAYMENTS 72,350 72,350 1,478,185 1,405,835 4.89 153 TOTAL EXPENDITURES 83,525 83,525 1,615,535 1,532,010 154 155 NET REVENUE OVER EXPENDITURES (23,740) (23,740) - 23,740 156 JANUARY 31, 2023 BUDGET SUMMARY 5 157 158 FUND 400 A B C D E 159 Capital Fund Month Activity YTD Actual Budget Amount Unearned Percent 160 161 REVENUE 162 GENERAL PROPERTY TAXES-CIF - - 340,000 340,000 0.00 163 SIDEWALKS - - 100,000 100,000 0.00 164 STATE SHARED REVENUES-EXP REST - - 2,574,434 2,574,434 0.00 165 FEES-REC FACILITY MAINTENANCE 500 500 15,000 14,500 3.33 166 CO & MUNIC-STREET & HIGHWAYS - - - - 0.00 167 INTEREST AND MISC 220 220 8,000 7,780 2.75 168 TRANSFERS IN FROM OTHER FUNDS - - 680,000 680,000 0.00 169 TOTAL REVENUE 720 720 3,717,434 3,716,714 170 171 172 EXPENDITURES 173 CITY HALL - - - - 174 RECREATION 12,931 12,931 2,530,000 2,517,069 0.51 175 PUBLIC SAFETY - - 255,095 255,095 0.00 176 LIBRARY AND DPW - - - - 0.00 177 STREETS 1,610 1,610 450,000 448,390 0.36 178 TRANSFER OUT - - - - 0.00 179 TOTAL EXPENDITURES 14,541 14,541 3,235,095 3,220,554 180 181 NET REVENUE OVER EXPENDITURES (13,821) (13,821) 482,339 496,160 182 183 184 185 FUND 401 186 TID 5 Fund Month Activity YTD Actual Budget Amount Unearned Percent 187 188 REVENUE 189 TAXES-TAX INCREMENTAL DISTRICT 7,153 7,153 408,345 401,192 1.75 190 DEVELOPER GUARANTEES - - - - 0.00 191 FEES-MISCELLANEOUS - - - - 0.00 192 TIF 5 INTEREST REVENUE - - - - 0.00 193 PROCEEDS OF LONG-TERM DEBT - - - - 0.00 194 TOTAL REVENUE 7,153 7,153 408,345 401,192 195 196 EXPENDITURES 197 TID 5 OPERATING EXPENSES 52,025 52,025 381,050 329,025 13.65 198 TOTAL EXPENDITURES 52,025 52,025 381,050 329,025 199 200 NET REVENUE OVER EXPENDITURES (44,872) (44,872) 27,295 72,167 201 JANUARY 31, 2023 BUDGET SUMMARY 6 202 203 FUND 404 A B C D E 204 Business Park Fund Month Activity YTD Actual Budget Amount Unearned Percent 205 206 REVENUE 207 TAX INCREMENT - - - - 0.00 208 INTEREST INCOME - - - - 0.00 209 LEASES/FUND BALANCE - - 224,103 224,103 0.00 210 TOTAL REVENUE - - 224,103 224,103 211 212 213 EXPENDITURES 214 OPERATING EXPENSES - - 15,109 15,109 0.00 215 TOTAL EXPENDITURES - - 15,109 15,109 216 217 NET REVENUE OVER EXPENDITURES - - 208,994 208,994 218 219 220 221 FUND 405 222 TID 3 Fund Month Activity YTD Actual Budget Amount Unearned Percent 223 224 REVENUE 225 TAXES-TAX INCREMENTAL DISTRICT - - 150,598 150,598 0.00 226 PAYMENT IN LIEU OF TAX - - 9,000 9,000 0.00 227 STATE GRANT - - - - 0.00 228 PERMITS - - - - 0.00 229 DONATIONS - - - - 0.00 230 PROCEEDS LONG TERM DEBT - - - - 0.00 231 TOTAL REVENUE - - 159,598 159,598 232 233 234 EXPENDITURES 235 TID 3 OPERATING EXPENSES 1,623 1,623 159,083 157,460 1.02 236 TRANSFER TO A DIF FUND - - - - 0.00 237 TOTAL EXPENDITURES 1,623 1,623 159,083 157,460 238 239 NET REVENUE OVER EXPENDITURES (1,623) (1,623) 515 2,138 240 241 JANUARY 31, 2023 BUDGET SUMMARY 7 242 243 FUND 407 A B C D E 244 TID 7 Fund Month Activity YTD Actual Budget Amount Unearned Percent 245 246 REVENUE 247 TAXES-TAX INCREMENTAL DISTRICT - - 45,000 45,000 0.00 248 PERMITS-BUILDING-TIF 7 - - - - 0.00 249 STATE GRANT - - - - 0.00 250 PERMITS - - - - 0.00 251 DONATIONS - - - - 0.00 252 TOTAL REVENUE - - 45,000 45,000 253 254 255 EXPENDITURES 256 INTEREST ON ADVANCES OTHER FUNDS - - 131,138 131,138 0.00 257 TID 7 OPERATING EXPENSES - - 6,500 6,500 0.00 258 TOTAL EXPENDITURES - - 137,638 137,638 259 260 NET REVENUE OVER EXPENDITURES - - (92,638) (92,638) 261 262 263 264 FUND 408 265 TID 6 Fund Month Activity YTD Actual Budget Amount Unearned Percent 266 267 REVENUE 268 TAXES-TAX INCREMENTAL DISTRICT - - 98,488 98,488 0.00 269 STATE/FEDERAL GRANT-TIF 6 - - - - 0.00 270 PERMITS - - - - 0.00 271 DONATIONS/TRANSFERS - - - - 0.00 272 TOTAL REVENUE - - 98,488 98,488 273 274 275 EXPENDITURES 276 INTEREST ON ADVANCES OTHER FUNDS - - 65,630 65,630 0.00 277 TID 6 OPERATING EXPENSES 355 355 30,266 29,911 1.17 278 TOTAL EXPENDITURES 355 355 95,896 95,541 279 280 NET REVENUE OVER EXPENDITURES (355) (355) 2,592 2,947 281 JANUARY 31, 2023 BUDGET SUMMARY 8 282 283 FUND 410 A B C D E 284 Equipment Fund Month Activity YTD Actual Budget Amount Unearned Percent 285 286 REVENUE 287 GENERAL PROPERTY TAXES-ERF - - 225,000 225,000 0.00 288 GRANT REVENUE-ERF - - - - 0.00 289 MISCELLANEOUS - - 5,000 5,000 0.00 290 TRANSFERS - - - - 0.00 291 TOTAL REVENUE - - 230,000 230,000 292 293 294 EXPENDITURES 295 EQUIPMENT ADMINISTRATION - - 7,000 7,000 0.00 296 EQUIPMENT RECREATION - - 5,000 5,000 0.00 297 EQUIPMENT POLICE 76,793 76,793 130,187 53,394 58.99 298 EQUIPMENT FIRE - - 30,500 30,500 0.00 299 EQUIPMENT LIBRARY - - - - 0.00 300 EQUIPMENT DPW - - 141,500 141,500 0.00 301 TOTAL EXPENDITURES 76,793 76,793 314,187 237,394 302 303 NET REVENUE OVER EXPENDITURES (76,793) (76,793) (84,187) (7,394) 304 305 306 307 FUND 418 308 TID 8 Fund Month Activity YTD Actual Budget Amount Unearned Percent 309 310 REVENUE 311 TAXES-TAX INCREMENTAL DISTRICT - - 125,000 125,000 0.00 312 PERMITS-BUILDING-TIF 8 - - - - 0.00 313 FEES-MISCELLANEOUS - - - - 0.00 314 TIF 8 INTEREST REVENUE - - - - 0.00 315 PROCEEDS OF LONG-TERM DEBT - - - - 0.00 316 TOTAL REVENUE - - 125,000 125,000 317 318 319 EXPENDITURES 320 TRANSFER OUT - - 15,405 15,405 0.00 321 TID 8 OPERATING EXPENSES 130,000 130,000 131,150 1,150 0.00 322 TOTAL EXPENDITURES 130,000 130,000 146,555 16,555 323 324 NET REVENUE OVER EXPENDITURES (130,000) (130,000) (21,555) 108,445 325 326 JANUARY 31, 2023 BUDGET SUMMARY 9 327 FUND 419 A B C D E 328 TID 9 Fund Month Activity YTD Actual Budget Amount Unearned Percent 329 330 REVENUE 331 TAXES-TAX INCREMENTAL DISTRICT - - - - 0.00 332 TIF 9 INTEREST REVENUE - - - - 0.00 333 TOTAL REVENUE - - - - 334 335 336 EXPENDITURES 337 TRANSFER OUT - - - - 0.00 338 TID 9 OPERATING EXPENSES 822 822 115,116 114,294 0.00 339 TOTAL EXPENDITURES 822 822 115,116 114,294 340 341 NET REVENUE OVER EXPENDITURES (822) (822) (115,116) (114,294) 342 343 344 345 FUND 420 346 Recycling Fund Month Activity YTD Actual Budget Amount Unearned Percent 347 348 REVENUE 349 STATE GRANT-RECYCLING - - 50,000 50,000 0.00 350 FEES-RECYCLING - - 99,561 99,561 0.00 351 INTEREST REVENUE - - 750 750 0.00 352 TOTAL REVENUE - - 150,311 150,311 353 354 355 EXPENDITURES 356 TRANSFER OUT 15,568 15,568 148,828 133,260 10.46 357 TOTAL EXPENDITURES 15,568 15,568 148,828 133,260 358 359 NET REVENUE OVER EXPENDITURES (15,568) (15,568) 1,483 17,051 360 361 JANUARY 31, 2023 BUDGET SUMMARY 10 362 363 FUND 425 A B C D E 364 Solid Waste Fund Month Activity YTD Actual Budget Amount Unearned Percent 365 366 REVENUE 367 FEES-SOLID WASTE - - 441,689 441,689 0.00 368 TOTAL REVENUE - - 441,689 441,689 369 370 371 EXPENDITURES 372 TRANSFER OUT 33,881 33,881 436,846 402,965 7.76 373 TOTAL EXPENDITURES 33,881 33,881 436,846 402,965 374 375 NET REVENUE OVER EXPENDITURES (33,881) (33,881) 4,843 38,724 376 377 378 379 FUND 430 380 Tourism Fund Month Activity YTD Actual Budget Amount Unearned Percent 381 382 REVENUE 383 LOCAL ROOM TAX-TOURISM FUND - - 60,000 60,000 0.00 384 MISCELLANEOUS REVENUE-TOURISM - - 10,000 10,000 0.00 385 TOTAL REVENUE - - 70,000 70,000 386 387 388 EXPENDITURES 389 OPERATING EXPENSES - - 70,000 70,000 0.00 390 TOTAL EXPENDITURES - - 70,000 70,000 391 392 NET REVENUE OVER EXPENDITURES - - - - 393 394 395 JANUARY 31, 2023 BUDGET SUMMARY 11 396 397 FUND 501 A B C D E 398 Taxi Fund Month Activity YTD Actual Budget Amount Unearned Percent 399 400 REVENUE 401 GENERAL PROPERTY TAXES - - 45,000 45,000 0.00 402 FED GRANT (PD BY ST)-TRANSPORT - - 109,930 109,930 0.00 403 SALE OF CITY PROPERTY-TAXI - - - - 0.00 404 OPERATING TRANSFER IN-GF - - - - 0.00 405 TOTAL REVENUE - - 154,930 154,930 406 407 408 EXPENDITURES 409 OPERATING EXPENSES 233 233 163,303 163,070 0.14 410 TOTAL EXPENDITURES 233 233 163,303 163,070 411 412 NET REVENUE OVER EXPENDITURES (233) (233) (8,373) (8,140) 413 414 415 416 FUND 509 417 CDBG Fund Month Activity YTD Actual Budget Amount Unearned Percent 418 419 REVENUE 420 INTEREST REVENUE - - 20 20 0.00 421 TOTAL REVENUE - - 20 20 422 423 424 EXPENDITURES 425 OPERATING EXPENSES - - 73,000 73,000 0.00 426 TOTAL EXPENDITURES - - 73,000 73,000 427 428 NET REVENUE OVER EXPENDITURES - - (72,980) (72,980) 429 430 JANUARY 31, 2023 BUDGET SUMMARY 12 431 432 FUND 700 A B C D E 433 StormWater Fund Month Activity YTD Actual Budget Amount Unearned Percent 434 435 REVENUE 436 GRANT REVENUE-STORMWATER - - - - 0.00 437 FEES-MISCELLANEOUS - - - - 0.00 438 STORMWATER REVENUES 534 534 588,800 588,266 0.09 439 PROCEEDS FROM LONG-TERM NOTES - - - - 0.00 440 TOTAL REVENUE 534 534 588,800 588,266 441 442 443 EXPENDITURES 444 ADMIN WAGES/BENEFITS 3,458 3,458 42,815 39,358 8.08 445 STREET WAGES/BENEFITS 33 33 27,493 27,459 0.12 446 STREET OPERATING EXPENSES - - 3,200 3,200 0.00 447 REPAIR AND MAIN WAGES/BENEFITS 905 905 79,906 79,001 1.13 448 UTILITIES 1,556 1,556 141,900 140,344 1.10 449 LEAF PICK UP WAGES/BENEFITS - - 45,626 45,626 0.00 450 OPERATING EXPENSES 7,875 7,875 196,020 188,145 4.02 451 TOTAL EXPENDITURES 13,826 13,826 536,960 523,134 452 453 NET REVENUE OVER EXPENDITURES (13,292) (13,292) 51,840 65,132 JANUARY 31, 2023 BUDGET SUMMARY 13  AGENDA SUMMARY SHEET MEETING DATE: 2/28/2023 TITLE: Request to Expand Police Training Position as part of Workforce Planning Efforts AGENDA SECTION: CONSIDERATION-ACTION PRESENTER: Kathy Schlieve, Administrator Scott Louden, Police Chief DEPARTMENT GOAL(S) SUPPORTED (if applicable) FISCAL IMPACT High Performance Government Contain within 2023 Budget SUMMARY: Staff will provide an overview of the attached Policy Analysis on Police Staffing and Training Program recommendations. Challenges around police staffing are not unique to our community. Challenges filling open positions have impacted morale and retention. Using data, we will explore the idea of increasing a paid training position to address future gaps in the workforce pipeline that will occur through retirements and possible turnover. Considerations: 1. Training lead time and implications to workforce planning efforts 2. Training wage structure 3. Current and Future budget implications ATTACHMENTS: Policy Analysis Document on Police Staff Training Expansion RECOMMENDED MOTIONS: Motion to request additional information and return discussion to Common Council Meeting on March 14, 2023. OR Motion to approve request to hire additional training position at an adjusted was of 80% of entry level wage for patrol officers as outlined in the policy document. Waupun Police Department Staffing Recommendation CALL VOLUME TRENDS FOR POLICE: Chart 1 shows call volume over time compared to the average annual staffing level of sworn officers on schedule. Trends indicate increasing call volume with fewer sworn officers available to support demand for the service. In 2020, staffing levels dropped to their lowest level since 2016 with the onset of COVID- 19. At that time, call volume dipped slightly and then began to rebound. CHART 1 SOURCE: City of Waupun Dispatch data Chart 2 reflects call volume per sworn officer, showing an increase of calls per officer in accordance with increasing demand for service. CHART 2 SOURCE: City of Waupun Dispatch data 1 Waupun Police Department Staffing Recommendation HIRING TRENDS FOR POLICE OFFICERS: Since 2020, the Police Department has run 12 recruitment processes and attracted 153 applicants. One out of every three hiring processes completed during this time period produced no qualified applicants. Nine (9) officers were hired with two-thirds of those individuals sponsored by the City to attend the Police Academy. The following statistics reflect our current hiring trends over this three-year period.  Average Days to Hire & Train: 281 (9.4 months)  Minimum Days to Hire & Train: 209 days (7 months) with No Academy Sponsorship  Maximum Days to Hire & Train: 420 days (14 months) with Academy Sponsorship As you would expect, Academy sponsorship extends the time to hire and train an officer. Research shows a majority of candidates currently graduating from the Academy are sponsored by agencies. The length of time to hire and train a sworn police officer is extends this period by 9.4 months on average but can take much longer dependent on the length of time required to find a qualified candidate. Workforce planning strategies should address time to recruitment and train new officers within 12 month of a possible retirement. Also of significance, since 2020, the city experienced a 53% turnover in sworn police officers. Some turnover is due to retirement but voluntary separation is a leading factor with officers choosing to leave city employment for other agencies closer to home or for more pay during this time. A minority of officers chose to leave the field all together. Of the officers sponsored in the Academy during this time, the city has retained 67% of those hires. Additional planning effort should be placed on retention of existing staff. The City did address wage scale issues with the most recent union contract, ratified in 2022. STAFFING LEVELS: In 2017, the city completed a police staffing analysis to examine headcount and spending for communities with populations of 10,000 to 14,000 as well as those with populations from 7,000 to 10,000 residents. That study concluded that there were efficiencies to the Waupun staffing model at that time and no recommended changes were brought forward. While time did not permit a full update of that study, as part of this analysis, staff did evaluate numbers of sworn full-time officers for the two groups of communities to check status. With 17 FTE, Waupun is slightly below average for communities within the 7,000 to 10,000 range and far below average for communities in the 10,000 to 14,000 range. There are variabilities such as difference in shift structures, dependence of part-time officers not considered here, etc. and those factors would need to be studied further to understand how they impact overall staffing levels. CHART 3 FTE of Sworn Officers for Similar Sized Communities (excluding Waupun) Count of Population Size Communities Average FTE Mean FTE Max FTE Min FTE 7,000 - 10,000 18 17.1 17.5 21 14 10,000 - 14,000 21 24.1 21 31 20 Heavy reliance of part-time officers in populations of 7,000 to 10,000 Shift variability would need to be examined (i.e., 12, 10 or 8 hour shifts impact staffing) 2 Waupun Police Department Staffing Recommendation RETIREMENT ELIGIBILITY: Chart 4 reflects current staffing levels by position and shows retirement eligibility of our current workforce. While eligibility does not predict behavior, it is an indication as to where turnover could be anticipated. Workforce planning utilizes this data to assess gaps and determine strategies to build a talent pipeline. CHART 4 Eligible for Category Years of Service Retirement % of Workforce Less than 1 Year to Retirement Eligibility 18.8% Supervisor 26.25 2023 Supervisor 22.50 2024 Supervisor 19.67 2024 5 or Fewer Years to Retirement Eligiblity 12.5% Supervisor 22.83 2028 Patrol 19.08 2029 8 or Fewer Years to Retirement Eligiblity 12.5% Supervisor 21.08 2030 Patrol 20.25 2031 12 or Fewer Years to Retirement Eligibility 6.3% Supervisor 8.08 2035 18 or More Years to Retirement Eligiblity 50% Patrol 6.25 2041 Patrol 5.25 2045 Patrol 4.08 2040 Patrol 2.08 2043 Patrol 1.08 2049 Patrol 0.67 2042 Patrol 0.33 2042 Patrol 0.17 2047 SOURCE: City of Waupun  19% of sworn officers are eligible for retirement within the next twelve months.  67% of department leadership is eligible for retirement within 5 or fewer years.  43.8% of the sworn officer roster is eligible for retirement within 8 or fewer years.  Average Years of Service for Leaders/Supervisors: 20.1 years.  Average Years of Service for Patrol: 5.9 years (60% of patrol staff have 5 or fewer years of experience). Since 2000, as staffing levels declined, opportunities for training and development within the team also decreased. Workforce planning strategies should focus on ensuring development opportunities are in place to prepare the department for leadership transitions. OVERTIME: Chart 5 shows actual to budget for overtime patrol expenditures over the last three years. While not a perfect indicator of true overtime worked because of comp time and the use of Administrative time to cover open patrol shifts, it is clear that actual expenditures have exceeded budgeted expenditures for 3 Waupun Police Department Staffing Recommendation overtime in each of the last three years. Reducing actual overtime to budgeted allocations would save the City $50,000 or more annually. This savings could be applied to offset increased training wages. CHART 5 SOURCE: City of Waupun Budget to Actual Reporting TRAINING WAGE: Currently the training wage for officers sponsored at the Academy is $16 with no benefits. Since beginning the paid training program in 2018, a number of communities have followed suit with sponsorships similar to what we are doing. Currently the Cities of Beaver Dam, Ripon, Horicon and Mayville, as well as Fond du Lac County, are paying trainees entry-level officer wage plus benefits. WPPA indicates that is it increasingly common to have training wages set at 80% of the entry-level wage for a sworn officer. The City should consider increasing their rate of pay from $16 to 80% of base rate ($22.17 per hour as of 1/1/23) for training positions. RECOMMENDATIONS: The City recently completed a hiring process to fill one vacant position. Within that process, one conditional offer was extended and two training candidates were identified. One of those candidates has since accepted an offer from another department and the second is in a search process with another department but is still available. Given the length of time to hire and train, staff is recommending that you consider expanding a training position now with the goal of sponsoring a candidate in the June 2023 Academy. A candidate starting now would complete Academy by the end of October 2023. Field training would then begin with completion anticipated on or around February 1, 2024. Identify training opportunities for existing staff to promote retention and to identify and develop future leaders who will be needed to support supervisory transitions over the next five years. Identify additional steps needed to expand the pool of available qualified applicants. BUDGET IMPLICATIONS: How can we pay for training position within existing budget? At the end of 2022, the City’s PSLO retired. The current search process works to fill that vacant position. 2023 budgeted to actual expenditures with this transition affords some opportunity to absorb a training position within the 2023 budget as follows:  PSLO Retirement replaced with a .8 FTE for cost savings of ~ $50,000. 4 Waupun Police Department Staffing Recommendation  Hold filling code enforcement position (absorb within existing staffing) cost savings $5,000. The estimated cost to train an officer through the balance of 2023 is $45,000. Based on wage differentials, we could absorb the training position @ $22.17 per hour within existing 2023 budget. However, in Year 2, if a retirement did not occur, the budget would not be able to absorb this ongoing cost without additional expense allocations. To address this, we would recommend the following considerations:  2024 costing to retain an 18th sworn officer would be an additional $92,976 in year 2.  However, by reducing overtime by an estimated $50,000, total impact would be $43,000 annually.  Fully absorb Code Enforcement into police responsibilities at an ongoing cost savings of $5K.  ARPA Funds under public safety have been requested to reinstate an 18th officer and could be applied here.  Consider including 18th officer in possible future public safety referendum discussions.  Pending Biennium budget approval for 2023-2025, additional funds for public safety may be received that could support this request. We would recommend a formal study of the department’s organizational structure be completed that evaluates a variety of factors this analysis cannot account for and that that be done in advance of leadership transitions we would expect over the next five to seven years as a result of retirements. 5