The URL can be used to link to this page

Home My WebLink About2022-09-07 Public Works Budget Hearing1200N COUNTY-CITY BUILDING PHONE 574.235.9216 227 W. JEFFERSON BLVD. FAX 574.235.9928 SOUTH BEND, INDIANA 46601-1830 CITY OF SOUTH BEND, IN JAMES MUELLER, MAYOR DEPARTMENT OF ADMINISTRATION AND FINANCE 2023 PROPOSED BUDGET Budget Hearing #4: Public Works September 7, 2022 1 CITY OF SOUTH BEND, IN Common Council 2023 Budget Hearing #4 Department of Public Works September 7, 2022 2 CITY OF SOUTH BEND, IN PUBLIC WORKS MISSION WE BUILD THE FOUNDATION FOR A THRIVING CITY •Providing essential household services •Developing sustainable assets and infrastructure •Enhancing the community’s quality of life 3 CITY OF SOUTH BEND, IN Presentation Overview •Introduction of Staff •Public Works Overview •Council Priorities •Engineering •Water •Wastewater •Streets •Solid Waste *APWA 2019 Poster4 CITY OF SOUTH BEND, IN OFFICE ADMINISTRATOR THERESA HEFFNER STREETS & SEWERS DIRECTOR SEAN WARD ENGINEERING CITY ENGINEER KARA BOYLES UTILITY DIRECTOR VACANT SOLID WASTE DIRECTOR KELLY SMITH DIRECTOR ERIC HORVATH TEAM ORGANIZATION MARKETING DIRECTOR CARA GRABOWSKI- BROWNDEPUTY DIRECTOR JITIN KAIN 5 CITY OF SOUTH BEND, IN •1,262 lane miles of street •700 miles of sewers •580 miles of water main •160 signalized intersections and 3,000 streetlights •10,000 catch basins, inlets and drains •4,800 fire hydrants •398 miles of alleys •60 million pounds of trash collected annually •11 million pounds of leaves, brush and yard waste collected WHAT WE MAINTAIN 6 CITY OF SOUTH BEND, IN Public Works Budget Overview Public Works Overview 2022 Structural 2023 Proposed YOY Variance Engineering 3,285,466 3,670,415 11.7% Water 25,828,039 38,760,349 50.1% Wastewater 34,706,896 58,286,539 67.9% Streets 29,768,749 34,541,157 16.0% Solid Waste 7,255,963 7,322,256 .9% Total 100,845,113 142,580,716 41.4% Interfund Transfers 41,245,071 35,209,909 -14.6% Total 142,090,184 177,790,625 25.1% $35.7M Increase7 CITY OF SOUTH BEND, IN Public Works Strategic Initiatives Public Works Strategic 2022 Structural 2023 Proposed YOY Variance Storm Sewer Capital 1,024,000 1,450,000 41.6% Water 8,500,000 19,838,000 133.4% Wastewater 10,337,500 33,955,413 228.5% Streets 5,370,000 6,739,223 25.5% Curb & Sidewalk 1,176,776 1,833,253 4.1% Light Up South Bend 261,800 260,000 -0.7% Traffic Calming 300,000 800,000 166.7% Alley Stabilization 50,000 50,000 0.0% Leaf Pickup 103,246 103,246 0.0% Total 27,708,322 65,029,135 134.7% $37.5M Increase8 CITY OF SOUTH BEND, IN 2023 Council Priorities •Street Paving & Maintenance •Alley Stabilization •Lighting & Signal Enhancements •Curb &Sidewalk Replacement •Neighborhood Traffic Calming 9 CITY OF SOUTH BEND, IN ENGINEERING 10 CITY OF SOUTH BEND, IN ENGINEERING Kara Boyles City Engineer Leslie Biek Assistant City Engineer TRAFFIC Jacob Klosinski Assistant City Engineer WASTEWATER Vacant Assistant City Engineer Vacant Assistant City Engineer REDEVELOPMENT Kieran Fahey Director, LTCP Toy Villa Construction Manager 11 CITY OF SOUTH BEND, IN Engineering Overview 2022 Structural 2023 Proposed YOY Variance Salaries & Wages 1,952,122 2,208,936 13.2% Fringe Benefits 741,859 831,137 12.0% Debt Service -- Professional Services 150,000 187,450 25.0% Education & Training 21,000 21,000 0.0% Travel 15,250 15,250 0.0% Printing & Advertising 8,535 8,535 0.0% Repairs & Maintenance 27,700 27,700 0.0% Other Services & Charges 34,500 35,000 1.4% Supplies 20,450 21,733 6.3% Fuel 2,250 3,674 63.3% Light Up South Bend 261,800 260,000 -0.7% Alley Stabilization Project 50,000 50,000 0.0% Total 3,285,466 3,670,415 11.7%ENGINEERING12 CITY OF SOUTH BEND, IN Engineering Personnel Changes Type of Request Position Title # of employees 2022 Salary 2023 Proposed Percent Change New FTE Project Engineer 2 -74,462 100% HTS Increase City Engineer 1 111,599 121,643 9% HTS Increase Asst. City Engineer 4 89,730 95,114 6% HTS Increase Deputy Director 1 104,199 110,451 6% 13 CITY OF SOUTH BEND, IN Engineering Goals Neighborhoods: •Implement pilot alley maintenance program •Complete city-wide streetlight gap analysis and develop comprehensive plan for implementation •Establish a trip-hazard quick response procedure for sidewalk repairs •Execute third year of the Street Improvement Plan Public Works Projects: •Use knowledge gained from 2022 bidding environment –contractor availability, cost, delays,supplies •Set realistic timeframes for project initiation and completion •Consider alternative procurement methods Engineering Operations: •Implement Projectmates for a full-scale project management information system •Focus on factors that impact successful projects 14 CITY OF SOUTH BEND, IN Rebuilding Our Streets •Description: •Multi-year plan to improve the condition of local streets. •Includes street paving, reconstruction, crack sealing, micro-surfacing, and brick street repair. •Public Works Duties: •Managing Design, Procurement and Inspection •Budget: $6.7M •Funding: MVH, LRS, Major Moves 15 CITY OF SOUTH BEND, IN Traffic Calming •Description: •2022 Funding developed comprehensive plan to be shared with Stakeholders •Plan implementation scheduled in 2023 •Public Works Duties: •Managing Design, Procurement and Inspection •Budget: $800,000 •Funding: LRSA 16 CITY OF SOUTH BEND, IN Light Up South Bend •Description: •Annual partnering program with I&M Power Co. to install additional streetlights in neighborhoods throughout South Bend •Lamppost Program to install residential lamppost lights (solar) •Public Works Duties: •Selecting Locations, Coordinating Installation with I&M Power •Administering Lamppost Program –procuring and distributing lampposts to residents •Budget: $260,000 •Funding: COIT 17 CITY OF SOUTH BEND, IN City-wide Lighting Plan •Street Light Gap Analysis to determine locations of need •Engineering and GIS team effort in Fall 2022 •I&T developing survey & request map for residents to give input on lighting •Developing lighting infill plan to address gaps and requests from residents •Coordinate with AEP on new light installations in 2023 (Light Up South Bend) 18 CITY OF SOUTH BEND, IN Curb and Sidewalk •Description: •Annual program to replace sidewalks, curbs, and curb ramps in poor condition at residential properties throughout the City. •City Council members select the locations and they are reviewed by Engineering for bidding as a public works project. •Public Works Duties: •Managing Design, Procurement, and Inspection •Budget: $700,000 •Funding: MVH 19 CITY OF SOUTH BEND, IN Comprehensive Water Master Plan •Description: •The evaluation all water supply, treatment, and distribution system needs based on asset risk, demands, and current and future regulatory requirements. •Public Works Duties: •Managing Design, Procurement and Inspection •Budget: $250,000 •Funding: Water Capital 20 CITY OF SOUTH BEND, IN Lead Service Line Replacement Plan •Description: •Develop a lead service line (LSL) replacement plan and improve the LSL inventory to meet the requirements of the EPA Lead and Copper Rule Revisions. •Public Works Duties: •Managing Design, Procurement and Inspection •Budget: $100,000 •Funding: Water Capital 21 CITY OF SOUTH BEND, IN Water Main Extensions/Replacements •Description: •Replacement distribution mains to ensure adequate service pressures, provide increased flow and redundancy. •Public Works Duties: •Managing Design, Procurement and Inspection •Budget: $300,000 •Funding: Water Capital S. Greenlawn Ave.22 CITY OF SOUTH BEND, IN Fellows Booster Pumping Station •Description: •Construct a new booster pumping station along with distribution pipe improvements, 3-phase 480V electrical transformer (AEP) and improved electrical feed to the facility, and generator back-up power. •Public Works Duties: •Managing Design, Procurement and Inspection •Budget: $8.1M •Funding: Water Capital 23 CITY OF SOUTH BEND, IN Equalization Basin •Description: •A new 2 MG equalization tank will be constructed south of the Wastewater Treatment Plant. Work includes relocation of sanitary sewers, reconstruction of CSO 45 outfall structure, SCADA communication, generator back-up power, and improved access from Riverside Drive. (LTCP Project) •Public Works Duties: •Managing Design, Procurement and Inspection.Ensuring compliance with CSO Consent Decree •Budget: $18.1M •Funding: Wastewater Capital 24 CITY OF SOUTH BEND, IN Dissolved Air Floatation •Description: •Replace dissolved air flotation units with new system. Update pump units and controls. •Public Works Duties: •Managing Design, Procurement and Inspection •Budget: $2 M •Funding: Wastewater Capital 25 CITY OF SOUTH BEND, IN Lift Station Upgrades/Replacements •Description: •Pumping Replacements, Telemetry and Communication Upgrades, Bypass Pumping, and Generator Upgrades •Public Works Duties: •Managing Design, Procurement and Inspection •Budget: $1 M •Funding: Wastewater Capital 26 CITY OF SOUTH BEND, IN CNG Compressor •Description: •Replace existing CNG Fuel Station feed compressor with higher capacity compressor unit, 3-phase electrical feed, instrumentation and controls upgrades. •Public Works Duties: •Managing Design, Procurement and Inspection •Budget: $2.3 M •Funding: Wastewater Capital 27 CITY OF SOUTH BEND, IN WWTP Primary & Secondary Treatment Hydraulic Improvements •Description: •Replace sludge, primary effluent and secondary treatment piping with larger size pipes to improve hydraulics required for future 100 MGD peak flow operation (LTCP Project). •Public Works Duties: •Managing Design, Procurement and Inspection •Budget: $3.5 M •Funding: Wastewater Capital 28 CITY OF SOUTH BEND, IN Sewer and Manhole Rehabilitation •Description: •Line sewers and manholes identified for targeted repairs to extend the life of existing sewer assets. •Public Works Duties: •Managing Design, Procurement and Inspection •Budget: $2M •Funding: Wastewater Capital 29 CITY OF SOUTH BEND, IN Traffic Signal Maintenance •Description: •Replacement of outdated controllers and components for optimal performance of signalized intersections. •For example, Bendix/Prast and Bendix Bonds are two intersections that require new traffic signal controllers. •Public Works Duties: •Managing Design, Procurement and Inspection •Budget: $400,000 •Funding: LRSA 30 CITY OF SOUTH BEND, IN School Zone Safety •Description: •The City, in partnership with the SBCSC, strives to provide safe passage for children to travel to and from schools. •Review and recommend improvements for traffic and pedestrian movements around schools •Public Works Duties: Gathering Data, Field Observation, Project Management •Budget: ~$120,000 •Funding: LRSA (shared with SBCSC) 31 CITY OF SOUTH BEND, IN Stormwater •Description: •Stormwater focused projects for studies and improvements of stormwater infrastructure. •South Bend Dam DSSMR •Johnson & Fellows •Beale St & Chapin St •Royal Oaks Basin •Bercliff Estates •Garland Circle •Public Works Duties: •Managing Study, Design, Procurement and Inspection •Budget: $1.45M •Funding:667 Stormwater 32 CITY OF SOUTH BEND, IN Coal Line Trail •Phase I (Lincoln Way W to Riverside) •Construction complete, closeout underway in Sept 2022 •Phase II (Riverside to SR 933) •Two sub-projects both letting in Sept 2022 •IIA (Trail) est. $1.8M ($350k by City) •IIB (Bridge) ets. $3.6M ($730k by City) •Phase III (MLK Center to Lincoln Way W) •PE estimated for $250k in 2023 (FY 24) -80% reimbursed •CN estimated for $1.9M ($380k by City) in 2025 (FY 26) 33 CITY OF SOUTH BEND, IN Safe Routes to School •SRTS Muessel Primary & Holy Cross •PE committed in 2022 •Bid in 2023/24, FY 24 (est $325k by City) •SRTS Our Lady of Hungary •PE committed in 2022 •Bid in 2023/24, FY 24 (est $184k by City) •SRTS Kennedy •PE est. $240k in 2022/23 (FY 23) •Construction in FY 25 34 CITY OF SOUTH BEND, IN Alley Maintenance •Description: •City will utilize funds to maintain alleys •Inventory, condition assessment, ratings, drainage, etc. •Public Works Duties: •Create Alley Policy, Manage Design, Procurement and Inspection •Budget: $189,000 •Funding: LOIT 35 CITY OF SOUTH BEND, IN RAISE GRANT •Description: •Federal grant to fund preliminary engineering activities for the removal of freeway ramps and creation of interconnected streets. •Public Works Duties: •Consultant procurement, manage engineering & design process. •Budget: $3,000,000 •City Share: $600,000 (TIF) •Funding: USDOT 36 CITY OF SOUTH BEND, INUTILITY REORGANIZATION 37 CITY OF SOUTH BEND, IN OFFICE ADMINISTRATOR THERESA HEFFNER STREETS & SEWERS DIRECTOR SEAN WARD ENGINEERING CITY ENGINEER KARA BOYLES WASTEWATER UTILITY DIRECTOR KIM THOMPSON SOLID WASTE DIRECTOR KELLY SMITH DIRECTOR ERIC HORVATH PROPOSED REORGANIZATION MARKETING DIRECTOR CARA GRABOWSKI- BROWNDEPUTY DIRECTOR JITIN KAIN WATER UTILITY DIRECTOR VACANT 38 CITY OF SOUTH BEND, IN 39 CITY OF SOUTH BEND, IN WATER UTILITY 40 CITY OF SOUTH BEND, IN Water Overview 2022 Structural 2023 Proposed YOY Variance Salaries & Wages 3,894,196 4,191,488 7.6% Fringe Benefits 1,764,581 1,862,665 5.6% Debt Service 2,866,610 2,753,661 -3.9% Professional Services 656,560 1,003,555 52.9% Education & Training 32,675 35,675 9.2% Travel 18,750 23,250 24.0% Printing & Advertising 10,359 7,033 -32.1% Repairs & Maintenance 446,700 483,486 8.2% Other Services & Charges 3,179,422 3,537,075 11.2% Utilities 825,700 894,234 8.3% Supplies 1,439,692 1,885,823 31.0% Fuel 92,155 137,936 49.7% PILOT 1,613,639 1,606,468 -0.4% Water Capital 8,987,000 20,338,000 126.3% Total 25,828,039 38,760,349 50.1%WATER41 CITY OF SOUTH BEND, IN Water Personnel Changes Type of Request Position Title # of employees 2022 Salary 2023 Proposed Percent Change New FTE Project Manager 1 -59,582 100% HTS Increase Water Asset Specialist 1 45,192 54,800 21.3% HTS Increase Manager Water Distribution S&R 1 53,460 65,000 21.6% HTS Increase Director Water Utility 1 90,696 98,671 8.8% HTS Increase Director Customer Service & Billing 1 79,320 82,126 3.5% HTS Increase Director Operations 1 74,866 82,126 9.7% HTS Increase Director Distribution 1 82,246 85,444 3.9% 42 CITY OF SOUTH BEND, IN Operating & Capital Budget –Highlights & Changes •New FTE •Project Manager to support various water programs and initiatives including meter exchange and new EPA lead rule •Professional Services •New SCADA communication improvements •Addition of a 3rd well cleaning and evaluation per year •Evaluation of rehab of 1 high service pump per year •Increased budget for legal fees related to water •Other Contractual Services •Increase in costs related to Service Line Repair Program negotiated rates (first since 2014) •Supplies •>200% Increase in treatment chemical costs •50% increase in fuel costs 43 CITY OF SOUTH BEND, IN Operating & Capital Budget –Highlights & Changes •CDL Certification Pay •CDL-A: $1 •CDL-A Unrestricted: $1.25 •CDL-B: $0.75 •Capital •Increase to support 5-year Water Capital Plan •Training Budget Increase •Support more staff training 44 CITY OF SOUTH BEND, IN WASTEWATER UTILITY 45 CITY OF SOUTH BEND, IN Wastewater Overview 2022 Structural 2023 Proposed YOY Variance Salaries & Wages 3,087,222 3,238,476 4.9% Fringe Benefits 1,336,329 1,399,649 4.7% Debt Service 11,270,508 9,773,347 -13.3% Professional Services 210,000 214,980 2.4% Education & Training 26,500 26,500 0.0% Travel 33,000 33,000 0.0% Printing & Advertising 4,499 4,607 2.4% Repairs & Maintenance 1,456,000 1,576,642 8.3% Other Services & Charges 398,700 423,841 6.3% Utilities 1,270,700 1,376,168 8.3% Supplies 1,204,585 1,670,538 38.7% Fuel 103,667 169,252 63.3% PILOT 4,465,686 4,489,126 0.5% Wastewater/Storm Capital 9,839,500 33,890,413 244.4% Total 34,706,896 58,286,539 67.9%WASTEWATER46 CITY OF SOUTH BEND, IN Wastewater Personnel Changes Type of Request Position Title # of employees 2022 Salary 2023 Proposed Percent Change New FTE General Laborer OR 1 -36,447 100% HTS Increase Director Operations 1 74,866 85,444 14.1% HTS Increase Director Maintenance 1 77,898 82,126 5.4% HTS Increase Director Water Quality 1 77,898 82,126 5.4% HTS Increase Director Environmental Compliance 1 75,268 82,126 9.1% Decrease Director Wastewater Utility 1 102,157 98,671 -3.4% 47 CITY OF SOUTH BEND, IN Operating & Capital Budget –Highlights & Changes •New FTE •General Laborer for Organic Resources (yard waste) •Supplies •>200% Increase in treatment chemical costs •CDL Certification Pay •CDL-A: $1 •CDL-A Unrestricted: $1.25 •CDL-B: $0.75 •Capital Increase •Capital to support LTCP and Strategic Plan 48 CITY OF SOUTH BEND, IN STREETS 49 CITY OF SOUTH BEND, IN Streets Organizational Chart Sean Ward Director Tom Whitaker Manager, Streets Larry Parker Manager, Sewers Coby Deal Manager, Traffic & Lighting 50 CITY OF SOUTH BEND, IN Streets Overview 2022 Structural 2023 Proposed YOY Variance Salaries & Wages 5,730,322 6,351,933 10.8% Fringe Benefits 2,449,873 2,666,144 8.8% Debt Service 1,204,363 1,583,506 31.5% Education & Training 20,000 35,000 75.0% Travel 10,000 30,000 200.0% Printing & Advertising 5,350 5,200 -2.8% Repairs & Maintenance 2,172,700 2,137,300 -1.6% Other Services & Charges 980,715 1,160,715 18.4% Utilities 1,571,248 1,590,426 1.2% Supplies 3,324,563 3,817,442 14.8% Fuel 249,593 327,769 31.3% Leaf Pickup 103,246 103,246 0.0% Curb & Sidewalk 1,761,776 1,833,253 4.1% Additional Road Funding 5,370,000 6,739,223 25.5% Traffic Calming 300,000 800,000 166.7% Street Capital 4,515,000 5,360,000 32.4% Total 29,768,749 34,541,157 16.0%STREETS51 CITY OF SOUTH BEND, IN Streets & Sewers Personnel Changes Type of Request Position Title # of employees 2022 Salary 2023 Proposed Percent Change New FTE Heavy Equipment Operator I 2 42,022 42,862 100% New FTE Electrician 1 -47,715 100% New FTE Signal Tech II 1 -43,623 100% 52 CITY OF SOUTH BEND, IN Operating & Capital Budget –Highlights & Changes •CDL Certification Pay •CDL-A: $1 •CDL-A Unrestricted: $1.25 •CDL-B: $0.75 •Training Budget Increase •Support more staff training & certifications after not being able to offer opportunities over last 2 years. 53 CITY OF SOUTH BEND, IN SOLID WASTE 54 CITY OF SOUTH BEND, IN Solid Waste Organizational Chart Kelly Smith Director Ernest Taylor Superintendent V Terry Malone Superintendent V 55 CITY OF SOUTH BEND, IN Solid Waste Overview 2022 Structural 2023 Proposed YOY Variance Salaries & Wages 1,294,255 1,360,314 5.1% Fringe Benefits 625,177 646,901 3.5% Debt Service 1,124,161 1,106,005 -1.6% Education & Training 20,000 20,000 0.0% Travel 9,900 9,900 0.0% Printing & Advertising 5,193 5,603 7.9% Repairs & Maintenance 1,030,000 1,113,830 8.1% Other Services & Charges 1,269,157 1,293,470 1.9% Supplies 230,650 249,700 8.3% Fuel 217,470 291,533 34.1% Capital 1,430,000 1,225,000 -14.3% TOTAL 7,255,963 7,322,256 0.9%SOLID WASTE56 CITY OF SOUTH BEND, IN Operating & Capital Budget –Highlights & Changes •Printing Advertising •Yard Waste Pilot Program, flyers, stickers mailings •Repairs & Maintenance •Increase in Labor cost and parts cost •Major Repairs 2013 -2016 vehicles •Supplies •Trash and yard waste containers increased 26% from 2021 to 2022. •Fuel •Fuel Increased 25% •Capital •Decreased due to purchasing 3 vehicles instead of 4 in 2023. 57 CITY OF SOUTH BEND, IN Strategic Initiative: Yard Waste Pilot Program •Funded through Indiana Department of Environmental Management Community Recycling Grant. •Educate City Residents in yard waste regulations: acceptable and nonacceptable material to place in yard waste container. 58 CITY OF SOUTH BEND, IN 59 CITY OF SOUTH BEND, IN •Funding to be announced next year •Funded through Drive Clean Indiana, Federal or State •Drive Clean Indiana predicts that EV grant will cover 75% of refuse vehicles and a minimum of 50% for charging stations •Vehicles not available until 2024 Strategic Initiative: Electric Trucks 60 CITY OF SOUTH BEND, IN Questions? 61 Expenditure Summary Row Labels 2020 Adopted 2021 Adopted 2022 (Structural)2023 Proposed YOY Variance Baseline Spending 65,787,982 64,595,563 73,136,791 77,551,581 6.0% Debt Service 12,519,616 11,628,544 16,465,642 15,216,519 -7.6% Essential Operations 45,395,838 44,956,318 46,646,849 51,446,464 10.3% Administration 2,694,071 2,697,842 2,944,766 3,331,415 13.1% Engineering 2,694,071 2,697,842 2,944,766 3,331,415 13.1% Salaries & Wages 1,841,018 1,816,881 1,952,122 2,208,936 13.2% Fringe Benefits 617,268 645,176 741,859 831,137 12.0% Education & Training 21,000 21,000 21,000 21,000 0.0% Professional Services 150,000 150,000 150,000 187,450 25.0% Travel 15,250 15,250 15,250 15,250 0.0% Other Services & Charges 19,500 19,500 34,500 35,000 1.4% Printing & Advertising 8,535 8,535 8,535 8,535 0.0% Supplies 19,250 19,250 19,250 20,433 6.1% Fuel 2,250 2,250 2,250 3,674 63.3% Solid Waste 3,146,387 3,290,449 3,671,802 3,877,421 5.6% Solid Waste 3,146,387 3,290,449 3,671,802 3,877,421 5.6% Salaries & Wages 1,132,274 1,146,617 1,294,255 1,360,314 5.1% Fringe Benefits 518,320 521,476 625,177 646,901 3.5% Education & Training 20,000 20,000 20,000 20,000 0.0% Travel 9,900 9,900 9,900 9,900 0.0% Other Services & Charges 1,036,700 1,114,933 1,269,157 1,293,470 1.9% Printing & Advertising 5,193 5,193 5,193 5,603 7.9% Supplies 194,000 194,780 230,650 249,700 8.3% Fuel 230,000 277,550 217,470 291,533 34.1% Streets 8,161,137 8,392,652 8,904,634 9,858,218 10.7% Streets 6,606,412 6,806,832 7,437,098 8,390,682 12.8% Salaries & Wages 2,820,620 2,889,267 3,220,130 3,619,116 12.4% Fringe Benefits 1,189,808 1,194,368 1,363,598 1,520,267 11.5% Education & Training 15,000 15,000 10,000 20,000 100.0% Professional Services - - - - Travel 15,000 5,000 5,000 17,500 250.0% Other Services & Charges 7,984 12,770 5,760 5,760 0.0% Printing & Advertising 5,240 2,750 2,750 2,750 0.0% Supplies 2,169,806 2,415,446 2,530,411 2,818,742 11.4% Fuel 333,754 224,000 247,593 325,102 31.3% Utilities 49,200 48,231 51,856 61,445 18.5% Street Signals & Lighting 1,554,725 1,585,820 1,467,536 1,467,536 0.0% Utilities 1,554,725 1,585,820 1,467,536 1,467,536 0.0% Wastewater 17,724,823 17,184,277 17,577,918 19,172,548 9.1% Organic Resources 754,722 746,636 793,585 933,819 17.7% Salaries & Wages 320,662 322,988 329,742 375,955 14.0% Fringe Benefits 108,682 109,209 152,985 179,272 17.2% Education & Training 2,500 2,500 2,500 2,500 0.0% Travel 3,000 3,000 3,000 3,000 0.0% Other Services & Charges 203,500 204,800 205,500 222,441 8.2% Printing & Advertising 300 300 300 308 2.7% 62 Expenditure Summary Row Labels 2020 Adopted 2021 Adopted 2022 (Structural)2023 Proposed YOY Variance Supplies 9,500 9,500 9,500 10,289 8.3% Fuel 94,278 82,039 77,358 126,300 63.3% Utilities 12,300 12,300 12,700 13,754 8.3% Sewers 5,561,327 5,164,465 5,437,030 6,126,411 12.7% Salaries & Wages 2,285,087 2,366,286 2,510,192 2,732,817 8.9% Fringe Benefits 957,635 974,821 1,086,275 1,145,877 5.5% Education & Training 15,000 15,000 10,000 15,000 50.0% Travel 15,000 15,000 5,000 12,500 150.0% Other Services & Charges 1,282,727 991,705 974,955 1,154,955 18.5% Printing & Advertising 5,912 5,912 2,600 2,450 -5.8% Supplies 948,158 750,381 794,152 998,700 25.8% Fuel 9,248 2,500 2,000 2,667 33.4% Utilities 42,560 42,860 51,856 61,445 18.5% Wastewater 11,408,774 11,273,176 11,347,303 12,112,318 6.7% Salaries & Wages 2,672,027 2,686,244 2,757,480 2,862,521 3.8% Fringe Benefits 1,024,007 1,027,344 1,183,344 1,220,377 3.1% Education & Training 24,000 24,000 24,000 24,000 0.0% Professional Services 450,000 350,000 210,000 214,980 2.4% Travel 30,000 30,000 30,000 30,000 0.0% Other Services & Charges 182,400 181,200 193,200 201,400 4.2% Printing & Advertising 4,199 4,199 4,199 4,299 2.4% Supplies 1,141,625 1,145,313 1,195,085 1,660,249 38.9% Fuel 28,167 23,756 26,309 42,952 63.3% PILOT 4,592,349 4,543,120 4,465,686 4,489,126 0.5% Utilities 1,260,000 1,258,000 1,258,000 1,362,414 8.3% Water 13,669,420 13,391,098 13,547,729 15,206,862 12.2% Water Works 13,669,420 13,391,098 13,547,729 15,206,862 12.2% Salaries & Wages 3,665,888 3,694,444 3,894,196 4,191,488 7.6% Fringe Benefits 1,526,296 1,532,758 1,764,581 1,862,665 5.6% Education & Training 30,175 32,675 32,675 35,675 9.2% Professional Services 774,500 676,560 656,560 1,003,555 52.9% Travel 18,750 18,750 18,750 23,250 24.0% Other Services & Charges 3,383,350 3,539,879 3,179,422 3,537,075 11.2% Printing & Advertising 10,359 10,359 10,359 7,033 -32.1% Supplies 1,571,022 1,340,772 1,439,692 1,885,823 31.0% Fuel 110,938 90,000 92,155 137,936 49.7% PILOT 1,629,442 1,611,201 1,613,639 1,606,468 -0.4% Repairs & Maintenance 115,000 20,000 20,000 21,660 8.3% Utilities 833,700 823,700 825,700 894,234 8.3% Maintenance of Current Capital 7,872,528 8,010,701 10,024,300 10,888,598 8.6% Strategic Spending 18,457,706 14,528,358 27,708,322 65,029,135 134.7% Strategic Initiatives 18,457,706 14,528,358 27,708,322 65,029,135 134.7% Strong Neighborhoods 2,392,206 2,067,657 2,476,822 3,046,499 23.0% Neighborhood Infrastructure 2,301,131 1,971,106 2,373,576 2,943,253 24.0% Curb & Sidewalk 1,589,331 1,359,306 1,761,776 1,833,253 4.1% Light Up South Bend 261,800 261,800 261,800 260,000 -0.7% 63 Expenditure Summary Row Labels 2020 Adopted 2021 Adopted 2022 (Structural)2023 Proposed YOY Variance Traffic Calming 400,000 300,000 300,000 800,000 166.7% Alley Stabilization Project 50,000 50,000 50,000 50,000 0.0% Neighborhood Revitalization 91,075 96,551 103,246 103,246 0.0% Leaf Pickup 91,075 96,551 103,246 103,246 0.0% Robust, Sustainable Infrastructure 16,065,500 12,460,701 25,231,500 61,982,636 145.7% Storm Sewer Capital 825,000 1,024,000 1,024,000 1,450,000 41.6% Streets 4,245,000 2,924,201 5,370,000 6,739,223 25.5% Additional funding for road projects 4,245,000 2,924,201 5,370,000 6,739,223 25.5% Wastewater/Sewer 8,615,500 6,412,500 10,337,500 33,955,413 228.5% Wastewater Capital 8,615,500 6,412,500 10,337,500 33,955,413 228.5% Water Works 2,380,000 2,100,000 8,500,000 19,838,000 133.4% Water Works Capital 2,380,000 2,100,000 8,500,000 19,838,000 133.4% Grand Total 84,245,688 79,123,921 100,845,113 142,580,716 41.4% 64 Personnel Change Summary Department Type of Request Subdivision Current Position Title Requested Position Title # of affected employees 2022 Salary Ordinance Proposed 2023 Salary Ordinance Total Increased Cost Percent Change Engineering NB-FT-Project Engineer-Engineering 2 74,462 148,924 100.0% Organic Resources TOR-General Laborer-OR 1 36,447 36,447 100.0% Streets TST-Hvy Equipment Operator I- Streets No change 2 42,022 42,862 1,680 100.0% TST-Electrician-Streets 1 47,715 47,715 100.0% TST-Signal Technician II-Streets 1 43,623 43,623 100.0% Water Works NB-FT-Project Manager-Water Works 1 59,582 59,582 100.0% NB-FT-Asst City Engineer- Engineering No change 4 89,730 95,114 21,536 6.0% NB-FT-City Engineer-Engineering No change 1 111,599 121,643 10,044 9.0% NB-FT-Dep Dir of Public Works L- PW/G-ENG No change 1 104,199 110,451 6,252 6.0% Organic Resources NB-FT-Admin Asst I-OR No change 1 43,346 45,742 2,396 5.5% Sewers NB-FT-Superintendent III-Sewer Ops NB-FT-Superintendent V-Sewer Ops 1 56,092 63,111 7,019 12.5% NB-FT-Manager-Ops-Wastewater NB-FT-Director-Wastewater Operations 1 74,866 85,444 10,578 14.1% NB-FT-Director of Wastewater Mtce No change 1 77,898 82,126 4,228 5.4% NB-FT-Director of Water Quality & Lab No change 1 77,898 82,126 4,228 5.4% NB-FT-Manager-Environmental Compliance NB-FT-Director-Environmental Compliance 1 75,268 82,126 6,858 9.1% NB-FT-Manager-Ops-North NB-FT-Director-Water Operations 1 74,866 82,126 7,260 9.7% NB-FT-Director of Distribution-Water Oli NB-FT-Director-Water Distribution 1 82,246 85,444 3,198 3.9% NB-FT-Engineer Aide IV-Water Works NB-FT-Water Asset Specialist-Water Works 1 45,192 54,800 9,608 21.3% NB-FT-Manager-Distribution Services & Records NB-FT-Manager-Water Distribution Services & Records 1 53,460 65,000 11,540 21.6% NB-FT-Asst Director of Util-Water Works NB-FT-Director-Water Utility 1 90,696 98,671 7,975 8.8% NB-FT-Director of Cust Service & Billing No change 1 79,320 82,126 2,806 3.5% Title Change Only Wastewater NB-FT-Director of Utility Safety NB-FT-Utility Safety Officer 1 59,535 61,023 1,488 2.5% Engineering NB-FT-Engineer I-Engineering NB-FT-Senior Engineer-Engineering 3 72,646 81,089 25,329 11.6% NB-FT-Superintendent III-Streets NB-FT-Superintendent IV-Streets 2 56,092 60,522 8,860 7.9% NB-FT-Superintendent IV-Streets NB-FT-Superintendent V-Streets 1 59,046 63,111 4,065 6.9% TST-Equipment Operator II-Streets TST-Equipment Operator III-Streets 1 38,994 41,318 2,324 6.0% Wastewater NB-FT-Director of Utilities NB-FT-Director-Wastewater Utility 1 102,157 98,671 (3,486)-3.4% 35 71,716 73,481 492,077 29.2% NA NA Change in Position (no salary ord. impact) Traffic & Lighting Engineering Wastewater Water Works Streets Public Works Grand Total New FTE Higher-than-standard increase 65 Capital Expenditure Summary Dept Subdivision Type Description 2023 Cost Guardrail Installation 300,000 Match for CCG from INDOT 1,000,000 Traffic Calming 800,000 Machinery & Equipment (1) Mower 60,000 (1) Front End Loader 310,000 (1) 3/4 Ton Pickup 4WD w/ plow 40,000 Utilities & Infrastructure 2023 Sewage Works Bonds: Sewer Lining Projects 2,000,000 (1) Backhoe 200,000 (2) 3/4 Ton Pick Up Truck - Standard cab, 4 WD, CNG 150,000 (2) Tandem Axle Dump Truck w/Leaf Boxes 760,000 (1) ASL Dedicated CNG Unit-Mini Mac 275,000 (2) ASL Dedicated CNG Unit ($475k each)950,000 2023 Storm Sewer Project: Johnson & Fellows Drainage, Royal Oaks Drainage, Bercliff Estates Storm Sewer, and Garland Circle Drainage Swale 1,150,000 Professional services (design) for Storm Sewer Project: Johnson & Fellows Drainage, Royal Oaks Drainage, Bercliff Estates Storm Sewer, and Garland Circle Drainage Swale 300,000 (1) Alley Maintainer w/Broom Attachment - Replace 289 225,000 (1) Skid Loader w/Trailer & Attachments w/Remote Control - Replace 292 150,000 (1) Spray Trailer - New to Fleet 120,000 (1) Alley Maintainer w/Broom Attachment 225,000 (1) Concrete Grinder 15,000 (1) F-550 4x4 x/Custom Flat Bed - Replace 234 110,000 (2) 4WD SUV - Hybrid - New to Fleet 120,000 (2) Single Axle Dump Truck w/Leaf Boxes- Replace 248, 256 480,000 (2) Tandem Axle Dump Truck w/Leaf Boxes- Replace 230, 265 680,000 (1) Street Sweeper 125,000 (1) Arrow Board Traffic Controller 15,000 (1) Utility Cart 15,000 WWTP Secondary Treatment Plant Improvement - Design services 1,500,000 2023 Sewage Works Bonds: EQ Basin $18.1M, and WWTP Improvements $11M 29,100,000 Vehicles (1) Transit Connect Van 45,000 Hydrant and Valve Replacement 200,000 Water Mains 300,000 Water Meter Replacement 500,000 Comprehensive Water Master Plan $250K, and Lead Service Line Replacement (LSLR) Plan $100K 350,000 2023 Water Works Revenue Bonds: Costs of Issuance $150K, and Other Design Services $500K 650,000 2023 Water Works Revenue Bonds: 2024 Edison, North, Pinhook Filtration, Olive GAC Plant (see Capital Plan for 2025 and 2026) 2024 spending = $4,739,000 2025 spending = $4,914,000 9,653,000 2023 Water Works Revenue Bonds: Fellows: Inspection & Cleaning of Clearwell $48K, and Pump Station Improvements $8.137M 8,185,000 (1) Mid Size Car w/CNG 30,000 (1) Mini Cargo Van w/CNG 70,000 (1) Vactor 400,000 61,558,000 Utilities & Infrastructure Vehicles Public Works Grand Total Local Roads & Streets Organic Resources Sewers Solid Waste Storm Sewer Streets Wastewater Water Works Utilities & Infrastructure Vehicles Vehicles Utilities & Infrastructure Machinery & Equipment Vehicles Machinery & Equipment Utilities & Infrastructure 66 Personnel Detail Fd-Dp-Dv-Sub Subdivision Position Status 2022 FTE 2023 FTE Incr/ (Decr) FTE 2022 Salary Cap Estimated % Increase 2023 Salary Cap 101-06-600-500 Engineering NB-FT-Admin Asst I L-PW/G-ENG NB 1 1 -43,346$ 3.00%44,646$ 101-06-600-500 Engineering NB-FT-Admin Asst II L-PW/G-ENG NB 1 1 -44,627$ 3.00%45,966$ 101-06-600-500 Engineering NB-FT-Asst City Engineer-Engineering NB 4 4 -89,730$ 6.00%95,114$ 101-06-600-500 Engineering NB-FT-City Engineer-Engineering NB 1 1 -111,599$ 9.00%121,643$ 101-06-600-500 Engineering NB-FT-Dep Dir of Public Works L-PW/G-ENG NB 1 1 -104,199$ 6.00%110,451$ 101-06-600-500 Engineering NB-FT-Dir of CSO Project Mgmt L-ENG/G-WW NB 1 1 -89,314$ 3.00%91,993$ 101-06-600-500 Engineering NB-FT-Dir of Marketing L-PW/G-ENG NB 1 1 -70,277$ 3.00%72,385$ 101-06-600-500 Engineering NB-FT-Director of Public Wrk L-PW/G-ENG NB 1 1 -127,833$ 3.00%131,668$ 101-06-600-500 Engineering NB-FT-Engineer I-Engineering NB 5 4 (1)72,646$ 3.00%74,825$ 101-06-600-500 Engineering NB-FT-Engineer II-Engineering NB 2 5 3 79,111$ 3.00%81,484$ 101-06-600-500 Engineering NB-FT-Executive Asst L-PW/G-ENG NB 1 1 -57,938$ 3.00%59,676$ 101-06-600-500 Engineering NB-FT-Manager-Permits-Engineering NB 1 1 -52,865$ 3.00%54,451$ 101-06-600-500 Engineering NB-FT-Manager-Pub Cnstrctn-Engineering NB 1 1 -72,440$ 3.00%74,613$ 101-06-600-500 Engineering NB-FT-Project Inspector-Engineering NB 4 4 -57,968$ 3.00%59,707$ 202-06-602-503 Streets NB-FT-Director of Fin Svcs (Streets)NB 1 1 -77,012$ 3.00%79,322$ 202-06-602-503 Streets NB-FT-Director of Streets & Sewers NB 1 1 -90,696$ 3.00%93,417$ 202-06-602-503 Streets NB-FT-Manager-Streets NB 1 1 -71,351$ 3.00%73,492$ 202-06-602-503 Streets NB-FT-Manager-Traffic & Lighting NB 1 1 -71,351$ 3.00%73,492$ 202-06-602-503 Streets NB-FT-Superintendent III-Streets NB 2 -(2)56,092$ 3.00%57,775$ 202-06-602-503 Streets NB-FT-Superintendent IV-Streets NB 1 2 1 59,046$ 3.00%60,817$ 202-06-602-503 Streets NB-FT-Superintendent V-Streets NB 1 2 1 61,572$ 3.00%63,419$ 202-06-602-503 Streets NB-FT-Superintendent V-Traffic & Lightin NB 1 1 -61,572$ 3.00%63,419$ 202-06-602-503 Streets TST-Equipment Operator II-Streets TM 15 14 (1)38,994$ 2.00%39,774$ 202-06-602-503 Streets TST-Equipment Operator III-Streets TM 1 2 1 40,508$ 2.00%41,318$ 202-06-602-503 Streets TST-General Laborer-Streets TM 1 1 -35,732$ 2.00%36,447$ 202-06-602-503 Streets TST-Hvy Equipment Operator I-Streets TM 1 3 2 42,022$ 2.00%42,862$ 202-06-602-503 Streets TST-Hvy Equipment Operator II-Streets TM 11 11 -43,045$ 2.00%43,906$ 202-06-602-503 Streets TST-Job Leader-Streets TM 4 4 -44,324$ 2.00%45,211$ 202-06-602-503 Streets TST-Ops Technician-Streets TM 3 3 -39,527$ 2.00%40,318$ 202-06-602-503 Streets TST-Sign Artist-Job Leader-Streets TM 1 1 -44,324$ 2.00%45,211$ 202-06-602-503 Streets TST-Signal Tech II-Job Leader-Streets TM 1 1 -45,305$ 2.00%46,211$ 202-06-602-503 Streets TST-Signal Technician II-Streets TM 4 5 1 42,768$ 2.00%43,623$ 202-06-602-503 Streets TST-Electrician-Streets TM -1 1 -$ 100.00%47,715$ 202-06-602-505 Curb & Sidewalk NB-FT-Superintendent V-Curb/Sidewalk NB 1 1 -61,572$ 3.00%63,419$ 202-06-602-505 Curb & Sidewalk TSR-Concrete Finisher-Curb/Sidewalk TM 6 6 -43,791$ 2.00%44,667$ 202-06-602-505 Curb & Sidewalk TSR-Job Leader-Curb/Sidewalk TM 1 1 -45,305$ 2.00%46,211$ 610-06-603-512 Solid Waste NB-FT-Admin Asst I-Solid Waste NB 1 1 -43,346$ 3.00%44,646$ 610-06-603-512 Solid Waste NB-FT-Director of Solid Waste Ops NB 1 1 -76,698$ 3.00%78,999$ 610-06-603-512 Solid Waste NB-FT-Secretary V-Solid Waste NB 1 1 -36,454$ 3.00%37,548$ 610-06-603-512 Solid Waste NB-FT-Superintendent V-Solid Waste NB 2 2 -61,572$ 3.00%63,419$ 610-06-603-512 Solid Waste TSW-Driver TM 20 20 -44,239$ 2.00%45,124$ 620-06-604-608 Water Works NB-FT-Admin Asst II-Water Works NB ----$ 0.00%45,743$ 620-06-604-608 Water Works NB-FT-Director-Water Utility NB 1 1 -90,696$ 8.79%98,671$ 620-06-604-608 Water Works NB-FT-Asst Manager-Cust Svc-Water Works NB 1 1 -50,732$ 3.00%52,254$ 620-06-604-608 Water Works NB-FT-Director of Cust Service & Billing NB 1 1 -79,320$ 3.54%82,126$ 620-06-604-608 Water Works NB-FT-Director-Water Distribution NB 1 1 -82,246$ 3.89%85,444$ 620-06-604-608 Water Works NB-FT-Engineer Aide IV-Water Works NB 1 -(1)45,192$ 3.00%46,548$ 620-06-604-608 Water Works NB-FT-Financial Spec III-Water Works NB 1 1 -46,664$ 3.00%48,064$ 620-06-604-608 Water Works NB-FT-Financial Spec IV-Water Works NB 3 3 -51,674$ 3.00%53,224$ 620-06-604-608 Water Works NB-FT-Locator-Water Works NB 1 1 -46,038$ 3.00%47,419$ 620-06-604-608 Water Works NB-FT-Manager-Billing & Customer Account NB 1 1 -61,414$ 3.00%63,256$ 620-06-604-608 Water Works NB-FT-Manager-Cross Connection Water Los NB 1 1 -69,765$ 3.00%71,858$ 620-06-604-608 Water Works NB-FT-Manager-Customer Svc-Water Works NB 1 1 -59,248$ 3.00%61,025$ 620-06-604-608 Water Works NB-FT-Manager-Distribution Services & Re NB 1 -(1)53,460$ 3.00%55,064$ 620-06-604-608 Water Works NB-FT-Manager-Water Distribution Services & Records NB -1 1 53,460$ 21.59%65,000$ 67 Personnel Detail Fd-Dp-Dv-Sub Subdivision Position Status 2022 FTE 2023 FTE Incr/ (Decr) FTE 2022 Salary Cap Estimated % Increase 2023 Salary Cap 620-06-604-608 Water Works NB-FT-Manager-Mtce-North Station NB 1 1 -70,108$ 3.00%72,211$ 620-06-604-608 Water Works NB-FT-Manager-Mtce-Water Olive NB 1 1 -70,108$ 3.00%72,211$ 620-06-604-608 Water Works NB-FT-Manager-Meter Service-Water Works NB 1 1 -70,107$ 3.00%72,210$ 620-06-604-608 Water Works NB-FT-Director-Water Operations NB 1 1 -74,866$ 9.70%82,126$ 620-06-604-608 Water Works NB-FT-Manager-Svc Ln Repair-Water Works NB 1 1 -70,107$ 3.00%72,210$ 620-06-604-608 Water Works NB-FT-Project Manager-Water Works NB 1 2 1 58,129$ 3.00%59,873$ 620-06-604-608 Water Works NB-FT-Supervisor-Ops-Water Olive NB 1 1 -64,171$ 3.00%66,096$ 620-06-604-608 Water Works NB-FT-Supervisor-Ops-Water Works NB 1 1 -64,171$ 3.00%66,096$ 620-06-604-608 Water Works NB-FT-System Specialist IV-Water Works NB 1 1 -72,284$ 3.00%74,453$ 620-06-604-608 Water Works NB-FT-Utilities System Sp-Water Works NB 1 1 -60,258$ 3.00%62,066$ 620-06-604-608 Water Works NB-FT-Water Asset Specialist-Water Works NB -1 1 -$ 100.00%54,800$ 620-06-604-608 Water Works NB-FT-Water Quality Sp-Water Works NB 2 2 -62,669$ 3.00%64,549$ 620-06-604-608 Water Works TWR-Customer Service & Billing I TM 5 5 -40,082$ 2.00%40,883$ 620-06-604-608 Water Works TWR-Customer Service & Billing II TM 2 2 -41,084$ 2.00%41,905$ 620-06-604-608 Water Works TWR-Customer Service & Billing III TM 2 2 -44,388$ 2.00%45,276$ 620-06-604-608 Water Works TWR-Data Processor TM 3 1 (2)41,084$ 2.00%41,905$ 620-06-604-608 Water Works TWR-Field Repairman/Insp I TM 2 2 -38,312$ 2.00%39,078$ 620-06-604-608 Water Works TWR-Field Repairman/Insp II TM 1 1 -39,783$ 2.00%40,579$ 620-06-604-608 Water Works TWR-Field Repairman/Insp III TM 1 1 -42,064$ 2.00%42,906$ 620-06-604-608 Water Works TWR-Field Repairman/Insp IV TM 7 7 -42,640$ 2.00%43,493$ 620-06-604-608 Water Works TWR-Field Repairman/Insp V TM 1 1 -43,173$ 2.00%44,036$ 620-06-604-608 Water Works TWR-Hvy Equipment Operator II TM 7 7 -43,578$ 2.00%44,450$ 620-06-604-608 Water Works TWR-Job Leader-Cont/Maint-Water Works TM 5 5 -45,305$ 2.00%46,211$ 620-06-604-608 Water Works TWR-Machinist TM 1 1 -42,640$ 2.00%43,493$ 620-06-604-608 Water Works TWR-Maintenance Tech I TM 3 3 -41,233$ 2.00%42,058$ 620-06-604-608 Water Works TWR-Maintenance Tech II TM 4 4 -43,045$ 2.00%43,906$ 640-06-602-510 Sewer Repair NB-FT-Superintendent V-Sewer Repair NB 1 1 -61,572$ 3.00%63,419$ 640-06-602-510 Sewer Repair TSR-Job Leader-Sewer Repair TM 1 1 -45,305$ 2.00%46,211$ 641-06-602-509 Sewers NB-FT-Admin Asst I-Streets NB 1 1 -43,346$ 3.00%44,646$ 641-06-602-509 Sewers NB-FT-Admin Asst II-Streets NB 1 1 -44,627$ 3.00%45,966$ 641-06-602-509 Sewers NB-FT-Manager-Sewer Ops NB 1 1 -72,284$ 3.00%74,453$ 641-06-602-509 Sewers NB-FT-Superintendent III-Sewer Ops NB 1 -(1)56,092$ 3.00%57,775$ 641-06-602-509 Sewers NB-FT-Superintendent V-Sewer Ops NB 2 3 1 61,572$ 3.00%63,419$ 641-06-602-509 Sewers TSR-Operator II-Sewer Ops TM 5 5 -38,994$ 2.00%39,774$ 641-06-602-509 Sewers TST-Equipment Operator III-Sewer Ops TM 9 9 -40,508$ 2.00%41,318$ 641-06-602-509 Sewers TSR-Hvy Equipment Operator I-Sewer Ops TM 10 10 -42,022$ 2.00%42,862$ 641-06-602-509 Sewers TSR-Job Leader-Sewer Ops TM 5 5 -45,305$ 2.00%46,211$ 641-06-602-511 Concrete Crew TSR-Concrete Finisher-Sewer Ops TM 3 3 -43,791$ 2.00%44,667$ 641-06-602-511 Concrete Crew TSR-Job Leader-Concrete-Sewer Ops TM 1 1 -45,305$ 2.00%46,211$ 641-06-605-514 Wastewater NB-FT-Admin Asst I-Wastewater NB 1 1 -43,346$ 3.00%44,646$ 641-06-605-514 Wastewater NB-FT-Asst Director of SCADA Info Sys NB 1 1 -72,284$ 3.00%74,453$ 641-06-605-514 Wastewater NB-FT-Chemist-Wastewater NB 3 3 -54,056$ 3.00%55,678$ 641-06-605-514 Wastewater NB-FT-Chemist Lead-Wastewater NB 1 1 -57,500$ 3.00%59,225$ 641-06-605-514 Wastewater NB-FT-Director of SCADA Info Sys NB 1 1 -83,360$ 3.00%85,861$ 641-06-605-514 Wastewater NB-FT-Director-Wastewater Utility NB 1 1 -102,157$ -3.41%98,671$ 641-06-605-514 Wastewater NB-FT-Utility Safety Officer NB 1 1 -59,535$ 3.00%61,321$ 641-06-605-514 Wastewater NB-FT-Director of Wastewater Mtce NB 1 1 -77,898$ 5.43%82,126$ 641-06-605-514 Wastewater NB-FT-Director of Water Quality & Lab NB 1 1 -77,898$ 5.43%82,126$ 641-06-605-514 Wastewater NB-FT-Industrial Pretreatment Sp I NB 1 1 -57,532$ 3.00%59,258$ 641-06-605-514 Wastewater NB-FT-Director-Environmental Compliance NB 1 1 -75,268$ 9.11%82,126$ 641-06-605-514 Wastewater NB-FT-Manager-Ind Prtrtmnt-Wastewater NB 1 1 -65,657$ 3.00%67,627$ 641-06-605-514 Wastewater NB-FT-Manager-Mtce-Wastewater NB 1 1 -70,108$ 3.00%72,211$ 641-06-605-514 Wastewater NB-FT-Manager-Ops-Wastewater NB 2 1 (1)74,866$ 3.00%77,112$ 641-06-605-514 Wastewater NB-FT-Director-Wastewater Operations NB -1 1 74,866$ 14.13%85,444$ 641-06-605-514 Wastewater NB-FT-Manager-Utility Prch & Storeroom NB 1 1 -56,753$ 3.00%58,456$ 641-06-605-514 Wastewater NB-FT-SCADA Instrument Sp-Wastewater NB 1 1 -60,977$ 3.00%62,806$ 641-06-605-514 Wastewater NB-FT-Superintendent V-Wastewater NB 1 1 -61,572$ 3.00%63,419$ 641-06-605-514 Wastewater TWW-CSO Rep II TM 2 2 -43,045$ 2.00%43,906$ 641-06-605-514 Wastewater TWW-General Laborer TM 1 1 -35,732$ 2.00%36,447$ 68 Personnel Detail Fd-Dp-Dv-Sub Subdivision Position Status 2022 FTE 2023 FTE Incr/ (Decr) FTE 2022 Salary Cap Estimated % Increase 2023 Salary Cap 641-06-605-514 Wastewater TWW-Lift Station-Rep II TM 2 2 -44,879$ 2.00%45,776$ 641-06-605-514 Wastewater TWW-Maintenance Electrician V TM 1 1 -49,526$ 2.00%50,517$ 641-06-605-514 Wastewater TWW-Maintenance Lead TM 1 1 -50,209$ 2.00%51,213$ 641-06-605-514 Wastewater TWW-Maintenance Repair IV TM 4 4 -46,669$ 2.00%47,603$ 641-06-605-514 Wastewater TWW-Operator-General TM 5 5 -43,045$ 2.00%43,906$ 641-06-605-514 Wastewater TWW-Operator-Lead TM 2 2 -50,209$ 2.00%51,213$ 641-06-605-514 Wastewater TWW-Operator-Senior TM 4 4 -44,879$ 2.00%45,776$ 641-06-605-514 Wastewater TWW-Sanitation Operator TM 2 2 -37,566$ 2.00%38,317$ 641-06-605-515 Organic Resources NB-FT-Admin Asst I-OR NB 1 -(1)43,346$ 3.00%44,646$ 641-06-605-515 Organic Resources NB-FT-Admin Asst II-OR NB -1 1 -$ 100.00%45,743$ 641-06-605-515 Organic Resources NB-FT-Supervisor-Ops-OR NB 1 1 -64,171$ 3.00%66,096$ 641-06-605-515 Organic Resources TOR-General Laborer-OR TM -1 1 35,732$ 2.00%36,447$ 641-06-605-515 Organic Resources TOR-Hvy Equipment Operator II TM 4 4 -43,045$ 2.00%43,906$ 270 276 69 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 101-06-600-500-410001 Personnel-Salaries & Wages-Salaried Wages 1,697,169 1,779,441 1,548,855 1,618,862 1,695,728 1,896,682 1,896,682 2,153,496 101-06-600-500-410003 Personnel-Salaries & Wages- Permanent Part Time 106,409 - 58,442 38,309 15,378 18,000 18,000 18,000 101-06-600-500-410005 Personnel-Salaries & Wages-Seasonal & Interns 37,440 37,440 23,499 23,050 20,592 37,440 37,440 37,440 101-06-600-500-411001 Personnel-Employee Benefits-FICA Regular 142,688 140,726 124,762 128,106 130,403 151,072 151,072 170,769 101-06-600-500-411004 Personnel-Employee Benefits-PERF Regular 192,791 201,838 175,917 183,875 188,477 214,969 214,969 243,806 101-06-600-500-411007 Personnel-Employee Benefits- Unemployment Comp 170 534 - 162 506 3,035 3,035 2,584 101-06-600-500-411008 Personnel-Employee Benefits-Health Insurance 247,159 268,710 184,367 243,105 240,785 338,885 338,885 378,281 101-06-600-500-411009 Personnel-Employee Benefits-Life Insurance 2,760 2,880 2,665 2,775 2,795 3,000 3,000 3,240 101-06-600-500-411014 Personnel-Employee Benefits-Parental Leave 5,940 6,228 3,653 5,666 5,947 6,638 6,638 7,537 101-06-600-500-411202 Personnel-Employee Benefits-Shoe Allowance 320 320 195 - 63 320 320 320 101-06-600-500-411204 Personnel-Employee Benefits-Auto Allowance 12,300 10,800 11,100 10,800 10,800 10,800 10,800 10,800 101-06-600-500-411205 Personnel-Employee Benefits-Parking Allowance 1,260 1,260 1,050 1,365 1,260 1,260 1,260 1,260 101-06-600-500-411206 Personnel-Employee Benefits-Cell Phone Allowance 11,880 11,880 12,155 12,210 11,440 11,880 11,880 12,540 101-06-600-500-421000 Supplies-Office-General Office Supplies - - - - - 9,000 9,000 9,747 101-06-600-500-421001 Supplies-Office-Official Records 750 750 - 491 1,600 1,250 1,250 1,354 101-06-600-500-421002 Supplies-Office-Stationary & Printing 9,600 9,600 4,905 2,480 807 - - - 101-06-600-500-422000 Supplies-Operating-Other Operating Supplies 3,600 3,600 5,454 1,024 2,660 4,000 4,711 4,332 101-06-600-500-422001 Supplies-Operating-C.S. Gasoline 2,250 2,250 1,638 1,149 1,963 2,250 2,250 3,674 101-06-600-500-422018 Supplies-Operating-Signals/Lights - - - - - - - 200,000 101-06-600-500-423000 Supplies-Repair & Maint-Other R&M Supplies 1,200 1,200 - - - 1,200 1,200 1,300 101-06-600-500-423006 Supplies-Repair & Maint-Small Tools & Equipment 5,300 5,300 668 - 98 5,000 5,000 5,000 70 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 101-06-600-500-431000 Services & Charges-Professional-Other Professional Svcs 150,000 150,000 139,573 151,673 192,618 150,000 286,543 187,450 101-06-600-500-432002 Services & Charges-Communication & Transp-Mailing 2,000 2,000 2,124 947 710 2,000 2,000 2,000 101-06-600-500-432003 Services & Charges-Communication & Transp-Travel 15,250 15,250 9,682 3,762 3,986 15,250 15,250 15,250 101-06-600-500-433001 Services & Charges-Printing & Ad- Outside Printing Services 6,535 6,535 1,715 1,316 395 6,535 6,535 6,535 101-06-600-500-433002 Services & Charges-Printing & Ad- Publication of Legal Notice 2,000 2,000 1,805 556 5,502 2,000 4,000 2,000 101-06-600-500-436001 Services & Charges-Repairs & Maint- Building R&M 21,000 21,000 1,249 840 1,701 20,000 18,000 20,000 101-06-600-500-436002 Services & Charges-Repairs & Maint- Office Equip R&M 1,500 1,500 - - - 1,500 1,500 1,500 101-06-600-500-436003 Services & Charges-Repairs & Maint- Auto Equip R&M 4,000 4,000 3,483 4,014 4,020 5,000 5,000 5,000 101-06-600-500-436006 Services & Charges-Repairs & Maint- Radio Equip R&M - - 108 865 210 1,200 1,200 1,200 101-06-600-500-438100 Services & Charges-Debt Service- Principal 10,755 8,259 14,637 10,755 4,493 - - - 101-06-600-500-438200 Services & Charges-Debt Service- Interest 194 624 407 194 51 - - - 101-06-600-500-439000 Services & Charges-Other-Misc Charges & Svcs 12,000 12,000 8,513 9,111 5,619 27,000 25,500 27,000 101-06-600-500-439003 Services & Charges-Other- Subscriptions 1,000 1,000 187 - 271 1,000 1,000 1,000 101-06-600-500-439004 Services & Charges-Other-Dues & Memberships 4,000 4,000 3,571 2,106 2,831 4,000 4,000 4,000 101-06-600-500-439005 Services & Charges-Other-Bank & Credit Card Fees 500 500 775 916 1,319 500 2,000 1,000 101-06-600-500-439006 Services & Charges-Other-Education & Training 21,000 21,000 7,953 1,500 1,157 21,000 21,000 21,000 101-06-600-500-439099 Services & Charges-Other-Cashier Over/Short - - - (1,150) - - - - 101-06-600-500-439100 Services & Charges-Other- Refunds/Awards/Indemnities 1,800 1,800 3,748 300 275 1,800 1,800 60,000 101-06-600-500-439999 Services & Charges-Other-Bad Debt Expense - - - 84 - - - - 101-06-600-500-452002 Other Uses-Interfund Transfer Out- Allocations-Admin Cost 117,035 153,802 55,204 117,035 153,802 174,609 174,609 167,441 71 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 101-06-600-500-452003 Other Uses-Interfund Transfer Out- Allocations-IT 276,638 375,441 276,287 276,638 375,441 280,483 280,483 272,841 101-06-600-500-452004 Other Uses-Interfund Transfer Out- Allocations-Liability Ins 24,767 37,789 28,225 24,767 37,789 4,804 4,804 262 101-06-600-500-452006 Other Uses-Interfund Transfer Out- Allocations-Print Shop - - 3,459 - - - - - 101-06-600-500-452007 Other Uses-Interfund Transfer Out- Allocations-Central Stores - - 2,191 - - - - - 101-06-602-503-452000 Other Uses-Interfund Transfer Out- Transfers Out - - - - - - - 3,750,000 101-06-602-505-452000 Other Uses-Interfund Transfer Out- Transfers Out - - - - - - - 1,500,000 101-06-602-507-435001 Services & Charges-Utility Services- Electric - - - - - - - 1,467,536 202-06-602-503-410001 Personnel-Salaries & Wages-Salaried Wages 531,296 543,704 496,487 544,726 531,841 582,454 582,454 617,687 202-06-602-503-410002 Personnel-Salaries & Wages-Teamster Wages 904,044 1,480,706 1,349,071 1,403,664 1,406,074 1,559,834 1,559,834 1,892,913 202-06-602-503-410003 Personnel-Salaries & Wages- Permanent Part Time 106,613 92,192 72,371 38,541 56,143 91,852 91,852 100,086 202-06-602-503-410004 Personnel-Salaries & Wages-Extra & Overtime 200,239 264,913 236,548 216,675 251,849 289,468 289,468 317,936 202-06-602-503-410005 Personnel-Salaries & Wages-Seasonal & Interns 18,720 53,913 24,437 42,846 60,608 26,624 26,624 26,624 202-06-602-503-410007 Personnel-Salaries & Wages-Longevity Pay 6,100 6,100 5,400 5,708 5,500 6,500 6,500 5,550 202-06-602-503-410014 Personnel-Salaries & Wages-Contract Add Pays 80,075 94,644 54,273 70,983 96,629 234,334 - - 202-06-602-503-410017 Personnel-Salaries & Wages-Stand By Pay - - - - - - 234,334 160,104 202-06-602-503-411001 Personnel-Employee Benefits-FICA Regular 144,451 195,581 166,487 172,936 180,359 215,444 215,444 254,600 202-06-602-503-411004 Personnel-Employee Benefits-PERF Regular 197,447 269,976 241,244 247,261 252,872 302,151 302,151 344,065 202-06-602-503-411005 Personnel-Employee Benefits-PERF Union 18,405 27,924 15,973 15,932 14,600 31,652 31,652 37,126 202-06-602-503-411007 Personnel-Employee Benefits- Unemployment Comp 174 607 - 198 684 4,273 4,273 3,659 202-06-602-503-411008 Personnel-Employee Benefits-Health Insurance 348,312 519,333 374,987 489,210 511,709 603,620 603,620 702,311 72 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 202-06-602-503-411009 Personnel-Employee Benefits-Life Insurance 3,600 5,368 5,257 5,248 5,263 5,371 5,371 6,028 202-06-602-503-411014 Personnel-Employee Benefits-Parental Leave 6,088 8,365 4,864 7,781 8,035 9,346 9,346 10,674 202-06-602-503-411015 Personnel-Employee Benefits-Other Fringe Benefits 6,500 6,500 2,600 (400) 2,627 6,600 6,600 6,600 202-06-602-503-411203 Personnel-Employee Benefits-Job Readiness Allow. 18,275 15,259 15,971 14,546 15,244 19,908 19,908 17,867 202-06-602-503-411206 Personnel-Employee Benefits-Cell Phone Allowance 5,280 5,178 4,950 4,400 3,795 5,280 5,280 5,280 202-06-602-503-421000 Supplies-Office-General Office Supplies - - - - 89 2,550 2,550 2,550 202-06-602-503-421002 Supplies-Office-Stationary & Printing 5,600 5,600 4,771 2,473 4,022 - - - 202-06-602-503-422000 Supplies-Operating-Other Operating Supplies 35,000 45,000 16,413 21,653 38,668 70,000 127,249 120,000 202-06-602-503-422001 Supplies-Operating-C.S. Gasoline 222,630 149,000 155,666 95,627 123,503 48,619 98,619 299,773 202-06-602-503-422002 Supplies-Operating-Diesel/CNG 750 7,400 2,939 2,055 4,802 2,600 2,600 8,000 202-06-602-503-422005 Supplies-Operating-Uniforms 15,000 15,000 13,209 12,596 14,503 19,500 24,500 27,500 202-06-602-503-422007 Supplies-Operating-Cleaning Supplies 2,500 5,000 2,391 2,068 3,584 2,500 2,500 2,550 202-06-602-503-422008 Supplies-Operating-Medical/Safety Supplies 2,600 7,500 2,510 2,574 4,297 2,600 2,600 4,000 202-06-602-503-422017 Supplies-Operating-Traffic/Sign/Other 17,500 - 36,257 32,919 2,255 - - 50,000 202-06-602-503-422018 Supplies-Operating-Signals/Lights 17,500 - 124,249 122,083 55,958 - - 150,000 202-06-602-503-423000 Supplies-Repair & Maint-Other R&M Supplies - - - - - - - - 202-06-602-503-423002 Supplies-Repair & Maint-Street Material 174,830 - 215,448 196,179 15,850 - - 100,000 202-06-602-503-423003 Supplies-Repair & Maint-Concrete Repair Supplies 5,000 3,500 - - 3,270 1,000 1,500 1,000 202-06-602-503-423006 Supplies-Repair & Maint-Small Tools & Equipment 56,250 69,750 58,359 54,297 11,052 62,500 88,478 79,881 202-06-602-503-423008 Supplies-Repair & Maint-Salt & Winter Materials 540,760 341,928 329,464 390,892 490,916 350,000 350,000 378,000 202-06-602-503-431000 Services & Charges-Professional-Other Professional Svcs - - 33,000 - - - - - 202-06-602-503-432002 Services & Charges-Communication & Transp-Mailing - - - 20 2 - - - 73 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 202-06-602-503-432003 Services & Charges-Communication & Transp-Travel 15,000 5,000 3,391 2,210 - 5,000 8,000 17,500 202-06-602-503-432004 Services & Charges-Communication & Transp-Telecommunications 720 720 1,015 588 879 960 960 960 202-06-602-503-433001 Services & Charges-Printing & Ad- Outside Printing Services 4,490 2,000 - - 588 2,000 2,000 2,000 202-06-602-503-433002 Services & Charges-Printing & Ad- Publication of Legal Notice 750 750 155 194 105 750 942 750 202-06-602-503-435001 Services & Charges-Utility Services- Electric 23,148 23,148 22,385 19,625 16,505 23,148 23,148 25,465 202-06-602-503-435002 Services & Charges-Utility Services- Natural Gas 17,583 17,583 18,206 14,405 12,985 17,583 17,583 21,980 202-06-602-503-435004 Services & Charges-Utility Services- Water 8,469 7,500 8,446 10,335 11,809 11,125 11,125 14,000 202-06-602-503-436001 Services & Charges-Repairs & Maint- Building R&M 71,334 59,350 118,209 93,080 38,539 84,350 26,350 12,525 202-06-602-503-436003 Services & Charges-Repairs & Maint- Auto Equip R&M 550,754 466,091 269,557 575,674 579,425 575,675 575,675 889,650 202-06-602-503-436005 Services & Charges-Repairs & Maint- Other Equip R&M 3,500 5,000 2,620 4,894 172 5,000 5,507 5,000 202-06-602-503-436006 Services & Charges-Repairs & Maint- Radio Equip R&M 7,000 8,000 13,385 15,517 8,858 10,000 10,000 13,050 202-06-602-503-436008 Services & Charges-Repairs & Maint- Street Maint 400,000 - - - - - - - 202-06-602-503-438100 Services & Charges-Debt Service- Principal 869,006 920,461 734,901 590,097 874,648 953,898 954,165 1,304,781 202-06-602-503-438200 Services & Charges-Debt Service- Interest 69,940 47,245 45,227 28,674 39,036 52,508 52,241 91,195 202-06-602-503-439000 Services & Charges-Other-Misc Charges & Svcs 5,800 10,000 5,369 3,333 1,390 4,500 2,489 4,500 202-06-602-503-439004 Services & Charges-Other-Dues & Memberships - - - - - - 720 - 202-06-602-503-439005 Services & Charges-Other-Bank & Credit Card Fees - 300 270 249 284 300 300 300 202-06-602-503-439006 Services & Charges-Other-Education & Training 15,000 15,000 9,540 13,900 2,845 10,000 8,291 20,000 202-06-602-503-439009 Services & Charges-Other-Trash Removal 1,464 1,750 1,737 1,483 - - - - 202-06-602-503-439999 Services & Charges-Other-Bad Debt Expense - - - 4,042 - - - - 74 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 202-06-602-503-445000 Capital Outlay-Machinery & Equip- Motor Equipment - - 64,316 102,840 1,379,408 - - - 202-06-602-503-445005 Capital Outlay-Machinery & Equip- Street Equipment - - - - 191,672 - - - 202-06-602-503-445100 Capital Outlay-Machinery & Equip- Lease Purch/Motor Equip - - - - - 525,000 1,812,528 1,515,000 202-06-602-503-445105 Capital Outlay-Machinery & Equip- Lease Purch/Street Equip - - - - - 250,000 - 615,000 202-06-602-503-445108 Capital Outlay-Machinery & Equip- Lease Purch/Other Equip - - - - - - - 120,000 202-06-602-503-452000 Other Uses-Interfund Transfer Out- Transfers Out - - 2,500,000 - - - - - 202-06-602-503-452002 Other Uses-Interfund Transfer Out- Allocations-Admin Cost 501,545 351,590 365,280 501,545 351,590 377,741 377,741 405,390 202-06-602-503-452003 Other Uses-Interfund Transfer Out- Allocations-IT 384,384 296,793 431,471 384,384 296,793 304,789 304,789 341,299 202-06-602-503-452004 Other Uses-Interfund Transfer Out- Allocations-Liability Ins 288,023 347,406 471,559 288,023 347,406 212,775 212,775 190,023 202-06-602-503-452006 Other Uses-Interfund Transfer Out- Allocations-Print Shop - - 2,866 - - - - - 202-06-602-503-452007 Other Uses-Interfund Transfer Out- Allocations-Central Stores - - 12,208 - - - - - 202-06-602-503-452008 Other Uses-Interfund Transfer Out- Allocations-Payroll Cost 282,036 319,026 273,309 282,036 319,026 332,030 332,030 346,324 202-06-602-503-452009 Other Uses-Interfund Transfer Out- Allocations-Facilities Mgt 1,398 1,457 - 1,398 1,457 1,624 1,624 1,330 202-06-602-505-410001 Personnel-Salaries & Wages-Salaried Wages 59,890 60,070 58,716 59,890 60,070 61,572 61,572 63,419 202-06-602-505-410002 Personnel-Salaries & Wages-Teamster Wages 297,606 300,596 259,463 286,213 287,298 308,051 308,051 332,413 202-06-602-505-410003 Personnel-Salaries & Wages- Permanent Part Time - - - - - 24,128 24,128 24,731 202-06-602-505-410004 Personnel-Salaries & Wages-Extra & Overtime 10,863 10,968 10,758 7,346 24,388 67,388 67,388 73,390 202-06-602-505-410005 Personnel-Salaries & Wages-Seasonal & Interns 49,920 49,920 26,946 27,351 30,660 33,280 33,280 33,280 202-06-602-505-410007 Personnel-Salaries & Wages-Longevity Pay 650 600 600 450 600 1,000 1,000 1,000 202-06-602-505-410014 Personnel-Salaries & Wages-Contract Add Pays 11,488 36,554 7,883 10,950 15,174 44,035 - - 75 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 202-06-602-505-410017 Personnel-Salaries & Wages-Stand By Pay - - - - - - 44,035 47,957 202-06-602-505-411001 Personnel-Employee Benefits-FICA Regular 33,187 35,351 26,517 29,040 31,658 41,581 41,581 44,338 202-06-602-505-411004 Personnel-Employee Benefits-PERF Regular 42,996 46,164 37,236 42,180 44,314 54,448 54,448 58,416 202-06-602-505-411005 Personnel-Employee Benefits-PERF Union 4,854 5,275 2,967 2,824 3,058 6,362 6,362 6,866 202-06-602-505-411007 Personnel-Employee Benefits- Unemployment Comp 38 108 - 37 116 771 771 622 202-06-602-505-411008 Personnel-Employee Benefits-Health Insurance 92,883 92,883 67,390 101,982 87,772 108,443 108,443 112,083 202-06-602-505-411009 Personnel-Employee Benefits-Life Insurance 960 960 840 925 920 960 960 960 202-06-602-505-411014 Personnel-Employee Benefits-Parental Leave 1,332 1,431 713 1,311 1,359 1,687 1,687 1,814 202-06-602-505-411015 Personnel-Employee Benefits-Other Fringe Benefits 600 600 600 - 600 1,400 1,400 1,400 202-06-602-505-411203 Personnel-Employee Benefits-Job Readiness Allow. 2,975 2,975 1,700 2,550 2,763 3,675 3,675 2,975 202-06-602-505-411206 Personnel-Employee Benefits-Cell Phone Allowance 420 420 420 420 420 420 420 420 202-06-602-505-422000 Supplies-Operating-Other Operating Supplies 1,750 1,750 1,683 635 - 1,750 - 1,750 202-06-602-505-422001 Supplies-Operating-C.S. Gasoline 5,200 6,500 8,037 5,482 11,900 6,500 6,500 14,919 202-06-602-505-422005 Supplies-Operating-Uniforms 1,905 1,905 1,364 1,487 2,469 1,905 3,655 3,700 202-06-602-505-423003 Supplies-Repair & Maint-Concrete Repair Supplies 100,000 100,000 106,459 118,643 109,902 143,770 143,770 158,150 202-06-602-505-423006 Supplies-Repair & Maint-Small Tools & Equipment 5,000 5,000 1,117 3,587 1,674 5,000 5,000 5,000 202-06-602-505-431000 Services & Charges-Professional-Other Professional Svcs 749,014 483,476 612,007 255,097 389,410 700,000 1,239,963 700,000 202-06-602-505-432002 Services & Charges-Communication & Transp-Mailing 300 300 - - 2 100 100 100 202-06-602-505-433002 Services & Charges-Printing & Ad- Publication of Legal Notice 500 500 67 - 79 200 200 200 202-06-602-505-436003 Services & Charges-Repairs & Maint- Auto Equip R&M 15,000 17,500 21,000 10,581 10,364 17,500 17,500 17,500 202-06-602-505-436006 Services & Charges-Repairs & Maint- Radio Equip R&M - - - - - - 1,350 2,000 76 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 202-06-602-505-439020 Services & Charges-Other-Curb & Sidewalk Reimburse 115,000 115,000 168,641 156,190 99,811 143,350 142,000 143,350 202-06-602-505-452002 Other Uses-Interfund Transfer Out- Allocations-Admin Cost 56,055 81,786 52,063 56,055 81,786 78,248 78,248 91,627 202-06-602-505-452008 Other Uses-Interfund Transfer Out- Allocations-Payroll Cost 21,546 21,698 19,523 21,546 21,698 22,375 22,375 23,553 217-06-600-500-431000 Services & Charges-Professional-Other Professional Svcs - - 53,988 56,258 33,500 - - - 227-06-604-601-439014 Services & Charges-Other-Recycling - - - 130,370 69,630 - - - 251-06-600-506-423002 Supplies-Repair & Maint-Street Material 250,000 350,000 63,646 4,468 367,364 350,000 133,184 350,000 251-06-600-506-431000 Services & Charges-Professional-Other Professional Svcs 80,000 80,000 175,032 200,078 459,207 1,170,000 1,742,455 250,000 251-06-600-506-436008 Services & Charges-Repairs & Maint- Street Maint 850,000 - 20,317 522,171 283,251 250,000 86,965 3,100,000 251-06-600-506-436009 Services & Charges-Repairs & Maint- Lane Marking - - - - - - - - 251-06-600-506-436010 Services & Charges-Repairs & Maint- Traffic Signal Maint 400,000 - 355,972 273,796 251,726 - 81,528 400,000 251-06-600-506-439000 Services & Charges-Other-Misc Charges & Svcs 15,000 15,000 5,000 2,094 8,202 - - - 251-06-600-506-442001 Capital Outlay-Infrastructure-Streets & Alleys 400,000 300,000 2,095,286 1,552,078 543,198 300,000 612,767 800,000 251-06-600-506-452000 Other Uses-Interfund Transfer Out- Transfers Out 1,000,000 2,000,000 617,569 1,000,000 2,000,000 1,000,000 1,000,000 220,000 257-06-600-506-431000 Services & Charges-Professional-Other Professional Svcs - - 257,469 17,856 3,762 - - 189,223 257-06-600-506-442001 Capital Outlay-Infrastructure-Streets & Alleys - - 434,025 31,938 20,166 - 56,950 - 257-06-600-506-452000 Other Uses-Interfund Transfer Out- Transfers Out - - - - - - - - 264-06-600-500-421000 Supplies-Office-General Office Supplies - - - 641 - - - - 264-06-600-500-422000 Supplies-Operating-Other Operating Supplies - - - 1,613 - - - - 264-06-600-500-422008 Supplies-Operating-Medical/Safety Supplies - - - 1,825 - - - - 264-06-602-503-422000 Supplies-Operating-Other Operating Supplies - - - 31 - - - - 77 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 264-06-602-503-422008 Supplies-Operating-Medical/Safety Supplies - - - 445 - - - - 264-06-602-503-423006 Supplies-Repair & Maint-Small Tools & Equipment - - - 2,504 - - - - 264-06-602-509-422008 Supplies-Operating-Medical/Safety Supplies - - - 1,080 - - - - 264-06-602-509-423006 Supplies-Repair & Maint-Small Tools & Equipment - - - 2,498 - - - - 264-06-603-512-422008 Supplies-Operating-Medical/Safety Supplies - - - 1,120 - - - - 264-06-604-603-422008 Supplies-Operating-Medical/Safety Supplies - - - 522 - - - - 264-06-604-603-423013 Supplies-Repair & Maint-Materials & Supplies - - - 220 - - - - 264-06-604-605-423006 Supplies-Repair & Maint-Small Tools & Equipment - - - 3,999 - - - - 264-06-604-605-423013 Supplies-Repair & Maint-Materials & Supplies - - - 6,819 - - - - 264-06-604-608-422008 Supplies-Operating-Medical/Safety Supplies - - - 9,699 (96) - - - 264-06-605-514-422004 Supplies-Operating-Oil - - - 816 - - - - 264-06-605-514-422008 Supplies-Operating-Medical/Safety Supplies - - - 2,913 - - - - 264-06-605-514-422022 Supplies-Operating-Laboratory Supplies - - - 421 - - - - 264-06-605-514-423013 Supplies-Repair & Maint-Materials & Supplies - - - 1,835 - - - - 264-06-605-515-422008 Supplies-Operating-Medical/Safety Supplies - - - 10 - - - - 264-06-605-515-423013 Supplies-Repair & Maint-Materials & Supplies - - - 140 - - - - 265-06-600-506-436008 Services & Charges-Repairs & Maint- Street Maint 2,000,000 2,000,000 996,856 1,691,081 2,482,521 2,000,000 2,923,443 1,000,000 266-06-602-503-410001 Personnel-Salaries & Wages-Salaried Wages - 19,328 17,716 19,673 26,148 20,505 20,505 31,927 266-06-602-503-410002 Personnel-Salaries & Wages-Teamster Wages 849,217 243,953 251,245 187,785 198,543 222,850 222,850 264,059 266-06-602-503-410003 Personnel-Salaries & Wages- Permanent Part Time 18,096 4,984 - - 4,184 47,050 47,050 48,226 266-06-602-503-410004 Personnel-Salaries & Wages-Extra & Overtime 50,060 13,943 - - 1,215 32,163 32,163 47,508 78 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 266-06-602-503-410005 Personnel-Salaries & Wages-Seasonal & Interns 56,160 70,887 21,600 13,686 17,664 106,496 106,496 106,496 266-06-602-503-411001 Personnel-Employee Benefits-FICA Regular 75,590 27,250 22,228 16,869 18,964 32,987 32,987 24,162 266-06-602-503-411004 Personnel-Employee Benefits-PERF Regular 102,351 31,398 30,124 23,165 25,301 31,098 31,098 32,537 266-06-602-503-411005 Personnel-Employee Benefits-PERF Union 13,708 3,914 3,769 2,817 2,996 3,856 3,856 3,488 266-06-602-503-411007 Personnel-Employee Benefits- Unemployment Comp 91 79 - 43 68 444 444 346 266-06-602-503-411008 Personnel-Employee Benefits-Health Insurance 243,818 72,797 89,776 57,472 60,137 87,705 87,705 68,261 266-06-602-503-411009 Personnel-Employee Benefits-Life Insurance 2,520 752 588 517 647 749 749 572 266-06-602-503-411014 Personnel-Employee Benefits-Parental Leave 3,198 970 672 724 791 972 972 1,008 266-06-602-503-411203 Personnel-Employee Benefits-Job Readiness Allow. - 3,015 1,029 1,923 1,969 2,142 2,142 1,683 266-06-602-503-411206 Personnel-Employee Benefits-Cell Phone Allowance - 102 - - - - - - 266-06-602-503-422000 Supplies-Operating-Other Operating Supplies - - - - 6,182 - - 1,000 266-06-602-503-422001 Supplies-Operating-C.S. Gasoline 111,124 75,000 69,845 75,549 104,435 198,974 148,974 25,329 266-06-602-503-422002 Supplies-Operating-Diesel/CNG 6,750 2,600 2,560 493 408 2,400 2,400 2,000 266-06-602-503-422017 Supplies-Operating-Traffic/Sign/Other 157,500 180,000 165,779 117,266 157,411 190,000 219,348 150,000 266-06-602-503-422018 Supplies-Operating-Signals/Lights 157,500 236,209 17,705 46,654 112,446 190,000 263,523 150,000 266-06-602-503-423002 Supplies-Repair & Maint-Street Material 706,016 690,709 1,096,203 905,529 713,324 922,261 922,261 872,261 266-06-602-503-423006 Supplies-Repair & Maint-Small Tools & Equipment 18,750 5,250 3,749 19,799 4,888 12,500 22,500 20,000 266-06-602-503-431000 Services & Charges-Professional-Other Professional Svcs - - - - 249,700 - - - 266-06-602-503-436003 Services & Charges-Repairs & Maint- Auto Equip R&M 439,246 528,909 367,921 420,195 388,331 419,325 409,325 129,350 266-06-602-503-436006 Services & Charges-Repairs & Maint- Radio Equip R&M - - - - - - 10,000 1,950 266-06-602-503-436008 Services & Charges-Repairs & Maint- Street Maint - 829,201 406,708 622,267 180,114 1,000,000 1,397,000 1,250,000 79 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 266-06-602-503-438100 Services & Charges-Debt Service- Principal - - - - - 175,924 176,214 169,814 266-06-602-503-438200 Services & Charges-Debt Service- Interest - - - - - 22,033 21,743 17,716 266-06-602-503-445005 Capital Outlay-Machinery & Equip- Street Equipment - - - - 15,800 - - - 266-06-602-503-445100 Capital Outlay-Machinery & Equip- Lease Purch/Motor Equip - - - - - 250,000 184,116 - 266-06-602-503-445105 Capital Outlay-Machinery & Equip- Lease Purch/Street Equip - - - - - 675,000 703,891 - 404-06-600-500-422018 Supplies-Operating-Signals/Lights 200,000 200,000 207,469 88,137 145,595 200,000 334,924 - 404-06-600-500-431000 Services & Charges-Professional-Other Professional Svcs - 60,000 - - 995 60,000 60,000 - 404-06-602-503-431000 Services & Charges-Professional-Other Professional Svcs 60,000 - 40,392 11,906 - - 5,179 - 404-06-602-503-452000 Other Uses-Interfund Transfer Out- Transfers Out 2,387,750 - 1,937,750 2,887,750 - 3,750,000 3,750,000 - 404-06-602-505-452000 Other Uses-Interfund Transfer Out- Transfers Out 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 - 404-06-602-507-435001 Services & Charges-Utility Services- Electric 1,554,725 1,585,820 1,729,535 1,501,835 1,401,657 1,467,536 1,467,536 - 407-06-602-503-452000 Other Uses-Interfund Transfer Out- Transfers Out 250,000 - - 250,000 - - - - 408-06-600-500-436000 Services & Charges-Repairs & Maint- Other R&M - - - - - 50,000 408-06-600-506-452000 Other Uses-Interfund Transfer Out- Transfers Out - - - - 253,000 606,000 606,000 2,644,500 408-06-602-503-436003 Services & Charges-Repairs & Maint- Auto Equip R&M - - 445,439 - - - - - 408-06-602-503-436008 Services & Charges-Repairs & Maint- Street Maint - - - 35,749 - - 3,018,812 - 408-06-602-503-452000 Other Uses-Interfund Transfer Out- Transfers Out - - - - - - - - 408-10-101-128-443001 Capital Outlay-Buildings-Building Improvements - - - - - - - - 408-10-101-130-443001 Capital Outlay-Buildings-Building Improvements - - - - - 50,000 50,000 - 408-10-101-130-443001 Capital Outlay-Buildings-Building Improvements 50,000 50,000 - 80 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 412-06-600-506-423002 Supplies-Repair & Maint-Street Material - 450,000 - - - 350,000 350,000 350,000 412-06-600-506-431000 Services & Charges-Professional-Other Professional Svcs 500,000 - 1,502 108,890 57,027 - 489,238 250,000 412-06-600-506-436001 Services & Charges-Repairs & Maint- Building R&M - - 710,820 44,201 - - - - 412-06-600-506-436008 Services & Charges-Repairs & Maint- Street Maint - - - - - 450,000 450,000 - 412-06-600-506-442001 Capital Outlay-Infrastructure-Streets & Alleys - - 513,712 649,253 27,855 500,000 500,000 300,000 412-06-600-506-452000 Other Uses-Interfund Transfer Out- Transfers Out - - - 522,365 - - - - 455-06-600-506-442001 Capital Outlay-Infrastructure-Streets & Alleys - - - - 3,785,766 - 3,815,260 - 455-06-600-506-452000 Other Uses-Interfund Transfer Out- Transfers Out - - - - 1,000,000 - - - 610-06-603-512-410001 Personnel-Salaries & Wages-Salaried Wages 272,005 272,821 243,792 266,097 260,663 257,652 257,652 290,031 610-06-603-512-410002 Personnel-Salaries & Wages-Teamster Wages 756,588 768,583 685,813 677,761 681,283 915,790 915,790 943,470 610-06-603-512-410003 Personnel-Salaries & Wages- Permanent Part Time - - - - - 15,600 15,600 15,600 610-06-603-512-410004 Personnel-Salaries & Wages-Extra & Overtime 101,781 102,813 99,213 206,617 152,576 102,813 102,813 108,813 610-06-603-512-410005 Personnel-Salaries & Wages-Seasonal & Interns - - - - 20,690 - - - 610-06-603-512-410007 Personnel-Salaries & Wages-Longevity Pay 1,900 2,400 1,250 1,300 1,050 2,400 2,400 2,400 610-06-603-512-411001 Personnel-Employee Benefits-FICA Regular 87,564 88,661 77,556 86,612 84,749 100,141 100,141 105,042 610-06-603-512-411004 Personnel-Employee Benefits-PERF Regular 128,198 129,805 115,758 126,920 121,342 144,865 144,865 152,039 610-06-603-512-411005 Personnel-Employee Benefits-PERF Union 13,037 13,240 5,496 5,976 5,189 15,485 15,485 15,960 610-06-603-512-411007 Personnel-Employee Benefits- Unemployment Comp 113 312 - 114 330 2,046 2,046 1,614 610-06-603-512-411008 Personnel-Employee Benefits-Health Insurance 268,710 268,710 208,439 254,265 223,532 338,885 338,885 350,260 610-06-603-512-411009 Personnel-Employee Benefits-Life Insurance 2,880 2,880 2,368 2,545 2,360 3,000 3,000 3,000 81 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 610-06-603-512-411014 Personnel-Employee Benefits-Parental Leave 3,963 4,013 1,945 4,029 3,827 4,475 4,475 4,706 610-06-603-512-411015 Personnel-Employee Benefits-Other Fringe Benefits 1,500 1,500 200 - 200 1,500 1,500 1,500 610-06-603-512-411200 Personnel-Employee Benefits-Clothing Allowance 800 800 - 757 800 800 800 800 610-06-603-512-411203 Personnel-Employee Benefits-Job Readiness Allow. 8,075 8,075 7,119 7,225 4,994 10,500 10,500 8,500 610-06-603-512-411204 Personnel-Employee Benefits-Auto Allowance 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 610-06-603-512-411206 Personnel-Employee Benefits-Cell Phone Allowance 1,980 1,980 1,485 1,980 1,980 1,980 1,980 1,980 610-06-603-512-421000 Supplies-Office-General Office Supplies - - - - - 4,200 4,200 4,549 610-06-603-512-421002 Supplies-Office-Stationary & Printing 4,200 4,200 3,022 1,192 2,011 - - - 610-06-603-512-422000 Supplies-Operating-Other Operating Supplies 175,500 175,500 77,900 165,897 123,728 210,600 211,530 228,080 610-06-603-512-422001 Supplies-Operating-C.S. Gasoline 50,000 52,500 15,304 11,964 16,579 16,170 16,170 26,400 610-06-603-512-422002 Supplies-Operating-Diesel/CNG 180,000 225,050 153,859 142,835 164,505 201,300 201,300 265,133 610-06-603-512-422005 Supplies-Operating-Uniforms 7,800 8,580 4,250 5,485 4,277 9,350 9,350 10,126 610-06-603-512-422007 Supplies-Operating-Cleaning Supplies 1,500 1,500 - - - 1,500 1,500 1,530 610-06-603-512-422008 Supplies-Operating-Medical/Safety Supplies 5,000 5,000 77 1,013 2,936 5,000 5,000 5,415 610-06-603-512-432002 Services & Charges-Communication & Transp-Mailing 2,500 2,500 162 - - 2,500 2,500 2,708 610-06-603-512-432003 Services & Charges-Communication & Transp-Travel 9,900 9,900 1,137 - - 9,900 9,900 9,900 610-06-603-512-432004 Services & Charges-Communication & Transp-Telecommunications 15,000 15,000 3,739 - - 15,000 15,000 15,000 610-06-603-512-433001 Services & Charges-Printing & Ad- Outside Printing Services 4,943 4,943 - 463 4,106 4,943 4,943 5,353 610-06-603-512-433002 Services & Charges-Printing & Ad- Publication of Legal Notice 250 250 - 42 - 250 250 250 610-06-603-512-436000 Services & Charges-Repairs & Maint- Other R&M - - - - 600 - - - 610-06-603-512-436001 Services & Charges-Repairs & Maint- Building R&M 20,000 20,000 1,234 - 2,066 20,000 9,900 20,000 82 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 610-06-603-512-436003 Services & Charges-Repairs & Maint- Auto Equip R&M 675,000 960,000 799,509 1,150,251 1,234,754 995,000 994,400 1,077,585 610-06-603-512-436006 Services & Charges-Repairs & Maint- Radio Equip R&M 25,000 15,000 9,546 5,959 12,110 15,000 25,700 16,245 610-06-603-512-437002 Services & Charges-Rentals-Equipment Rental - - - - 44,100 - - - 610-06-603-512-438100 Services & Charges-Debt Service- Principal - - - - 250,000 - - - 610-06-603-512-439000 Services & Charges-Other-Misc Charges & Svcs 5,000 5,500 14,481 4,279 2,195 5,500 5,500 5,957 610-06-603-512-439001 Services & Charges-Other-Other Contractual Services - - - 27,366 - - - - 610-06-603-512-439004 Services & Charges-Other-Dues & Memberships 1,500 1,500 194 200 223 1,500 1,500 1,500 610-06-603-512-439006 Services & Charges-Other-Education & Training 20,000 20,000 975 - 17,160 20,000 20,000 20,000 610-06-603-512-439010 Services & Charges-Other-Landfill 935,700 1,028,160 932,906 1,131,774 1,080,262 1,182,384 1,274,753 1,206,032 610-06-603-512-439999 Services & Charges-Other-Bad Debt Expense 77,000 62,273 47,543 36,318 24,658 62,273 - - 610-06-603-512-452000 Other Uses-Interfund Transfer Out- Transfers Out 1,231,349 1,065,255 1,053,026 979,213 867,967 1,124,161 1,124,161 1,106,005 610-06-603-512-452002 Other Uses-Interfund Transfer Out- Allocations-Admin Cost 214,315 294,514 189,287 214,315 294,514 345,482 345,482 341,839 610-06-603-512-452003 Other Uses-Interfund Transfer Out- Allocations-IT 352,832 433,127 439,517 352,832 433,127 443,541 443,541 505,135 610-06-603-512-452004 Other Uses-Interfund Transfer Out- Allocations-Liability Ins 161,439 220,155 131,839 161,439 220,155 178,115 178,115 248,482 610-06-603-512-452005 Other Uses-Interfund Transfer Out- Allocations-Utility Mgmt 195,305 202,282 190,788 195,305 202,282 183,237 183,237 224,346 610-06-603-512-452006 Other Uses-Interfund Transfer Out- Allocations-Print Shop - - 5,797 - - - - - 610-06-603-512-452007 Other Uses-Interfund Transfer Out- Allocations-Central Stores - - 7,056 - - - - - 610-06-603-512-452008 Other Uses-Interfund Transfer Out- Allocations-Payroll Cost 35,087 35,051 34,122 35,087 35,051 37,126 37,126 38,534 610-06-603-512-490000 Bad Debt Expense - - - - - - 62,273 62,273 610-06-603-513-439999 Services & Charges-Other-Bad Debt Expense - - (441) (851) (74) - - - 611-06-603-512-438100 Services & Charges-Debt Service- Principal 1,159,236 1,002,558 970,891 927,626 843,122 1,061,327 1,061,836 1,031,721 83 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 611-06-603-512-438200 Services & Charges-Debt Service- Interest 72,113 62,697 67,113 51,027 37,977 62,834 62,325 74,284 611-06-603-512-445000 Capital Outlay-Machinery & Equip- Motor Equipment - - - - 354,135 - - - 611-06-603-512-445006 Capital Outlay-Machinery & Equip- Computer Equip/Network - - - 53,416 - - - - 611-06-603-512-445100 Capital Outlay-Machinery & Equip- Lease Purch/Motor Equip - - - - - 1,430,000 2,328,861 1,225,000 611-06-603-512-445108 Capital Outlay-Machinery & Equip- Lease Purch/Other Equip - - - - - - 10,000 - 620-06-604-601-421000 Supplies-Office-General Office Supplies - - - - - - - - 620-06-604-601-422001 Supplies-Operating-C.S. Gasoline 5,000 5,000 4,512 1,077 2,573 10,000 10,000 16,000 620-06-604-601-423001 Supplies-Repair & Maint-Building Materials 3,000 3,000 881 1,414 - 3,000 3,000 3,249 620-06-604-601-423006 Supplies-Repair & Maint-Small Tools & Equipment - - - - - - - - 620-06-604-601-423009 Supplies-Repair & Maint-Repair Parts 72,500 15,000 49,317 392 11,266 15,000 15,000 16,245 620-06-604-601-423013 Supplies-Repair & Maint-Materials & Supplies 5,000 5,000 2,138 1,907 218 5,000 5,000 5,415 620-06-604-601-435001 Services & Charges-Utility Services- Electric 750,000 750,000 711,623 698,186 703,778 750,000 750,000 812,250 620-06-604-602-431000 Services & Charges-Professional-Other Professional Svcs 150,000 207,000 172,196 179,436 93,140 207,000 287,642 270,031 620-06-604-602-436002 Services & Charges-Repairs & Maint- Office Equip R&M - - - - - - - - 620-06-604-602-436005 Services & Charges-Repairs & Maint- Other Equip R&M 150,000 150,000 134,692 193,587 261,448 150,000 171,086 162,450 620-06-604-602-439001 Services & Charges-Other-Other Contractual Services 285,000 285,000 23,600 30,634 13,135 35,775 35,775 38,744 620-06-604-603-421000 Supplies-Office-General Office Supplies - - - - - 4,960 6,332 5,372 620-06-604-603-421002 Supplies-Office-Stationary & Printing 4,960 4,960 20,956 2,156 2,943 - - - 620-06-604-603-422007 Supplies-Operating-Cleaning Supplies - - 212 - - - - - 620-06-604-603-422008 Supplies-Operating-Medical/Safety Supplies 15,000 15,000 15,269 7,015 14,180 16,920 16,920 18,324 620-06-604-603-422010 Supplies-Operating-Plants Chemicals Seed & Fertilizer 3,000 3,000 2,504 3,192 2,115 3,000 3,064 3,249 84 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 620-06-604-603-422012 Supplies-Operating-Water Treatment Chemicals 152,657 152,657 130,778 137,061 122,040 172,657 181,303 517,971 620-06-604-603-422022 Supplies-Operating-Laboratory Supplies 43,000 43,000 41,215 40,442 27,294 43,000 45,550 46,569 620-06-604-603-423006 Supplies-Repair & Maint-Small Tools & Equipment 8,600 8,600 10,215 2,967 10,922 8,600 9,123 9,314 620-06-604-603-423013 Supplies-Repair & Maint-Materials & Supplies 16,000 16,000 18,954 14,332 14,647 16,000 16,000 17,328 620-06-604-603-431000 Services & Charges-Professional-Other Professional Svcs 268,000 33,060 50,587 162,538 34,550 83,060 156,255 182,954 620-06-604-603-431015 Services & Charges-Professional- Laboratory Water Testing 30,000 30,000 26,836 16,184 22,641 30,000 36,023 32,490 620-06-604-603-432004 Services & Charges-Communication & Transp-Telecommunications 40,000 40,000 30,834 31,185 31,460 40,000 56,800 73,320 620-06-604-603-433001 Services & Charges-Printing & Ad- Outside Printing Services 100 100 - - 32 100 100 100 620-06-604-603-435002 Services & Charges-Utility Services- Natural Gas 55,000 45,000 31,109 24,316 37,046 45,000 45,000 48,735 620-06-604-603-439006 Services & Charges-Other-Education & Training 15,000 15,000 8,095 8,664 2,460 15,000 15,000 15,000 620-06-604-603-439012 Services & Charges-Other-Uniform Services 7,500 7,500 6,658 7,950 5,898 8,500 8,500 9,206 620-06-604-604-423009 Supplies-Repair & Maint-Repair Parts 300,000 250,000 267,588 291,278 217,217 275,000 322,236 297,825 620-06-604-604-436001 Services & Charges-Repairs & Maint- Building R&M 5,000 5,000 4,400 2,670 2,370 5,000 5,000 5,415 620-06-604-604-436005 Services & Charges-Repairs & Maint- Other Equip R&M 7,000 57,000 6,874 6,902 13,516 32,000 71,207 34,656 620-06-604-604-437002 Services & Charges-Rentals-Equipment Rental 1,000 1,000 1,103 607 - 1,000 1,000 1,083 620-06-604-605-421000 Supplies-Office-General Office Supplies - - - - - 12,000 12,759 12,000 620-06-604-605-421002 Supplies-Office-Stationary & Printing 12,000 12,000 3,878 14,343 5,823 - - - 620-06-604-605-422000 Supplies-Operating-Other Operating Supplies - - 369 - - - - - 620-06-604-605-422007 Supplies-Operating-Cleaning Supplies 1,000 1,000 93 - - 1,000 1,000 1,000 620-06-604-605-422008 Supplies-Operating-Medical/Safety Supplies - - - - - - - - 85 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 620-06-604-605-422010 Supplies-Operating-Plants Chemicals Seed & Fertilizer 500 500 - - - 500 500 542 620-06-604-605-423001 Supplies-Repair & Maint-Building Materials 2,500 2,500 14 - - 2,500 2,500 2,708 620-06-604-605-423006 Supplies-Repair & Maint-Small Tools & Equipment 14,000 14,000 14,095 7,494 6,258 14,000 25,490 14,000 620-06-604-605-423013 Supplies-Repair & Maint-Materials & Supplies 178,500 98,500 92,991 48,605 122,372 148,500 215,221 160,826 620-06-604-605-431000 Services & Charges-Professional-Other Professional Svcs 80,000 160,000 134,743 54,603 134,471 160,000 174,520 248,280 620-06-604-605-433001 Services & Charges-Printing & Ad- Outside Printing Services 1,350 1,350 598 603 363 1,350 1,350 1,350 620-06-604-605-435001 Services & Charges-Utility Services- Electric 10,000 10,000 9,398 14,972 16,540 12,000 12,000 12,996 620-06-604-605-435002 Services & Charges-Utility Services- Natural Gas 12,000 12,000 11,307 9,609 10,866 12,000 12,000 12,996 620-06-604-605-436005 Services & Charges-Repairs & Maint- Other Equip R&M 1,200 1,200 - - - 1,200 1,200 1,300 620-06-604-605-439001 Services & Charges-Other-Other Contractual Services 20,000 20,000 16,088 18,915 14,761 19,560 19,560 21,183 620-06-604-605-439006 Services & Charges-Other-Education & Training 4,000 4,000 1,257 1,368 - 4,000 5,200 4,000 620-06-604-605-439012 Services & Charges-Other-Uniform Services 11,000 11,000 7,813 6,313 7,339 11,000 11,000 11,913 620-06-604-606-422000 Supplies-Operating-Other Operating Supplies - - 115 - - - - - 620-06-604-606-422001 Supplies-Operating-C.S. Gasoline 105,938 85,000 73,909 50,829 70,631 82,155 82,155 121,936 620-06-604-606-423006 Supplies-Repair & Maint-Small Tools & Equipment 20,000 25,000 18,472 19,383 24,533 25,000 25,805 25,000 620-06-604-606-423007 Supplies-Repair & Maint-Concrete & Asphalt 100,000 170,000 96,444 88,268 99,666 170,000 182,864 184,110 620-06-604-606-423009 Supplies-Repair & Maint-Repair Parts 120,000 2,500 139,632 76,349 2,397 2,500 2,500 2,700 620-06-604-606-423013 Supplies-Repair & Maint-Materials & Supplies 482,255 15,255 473,657 439,377 29,780 15,255 17,907 16,521 620-06-604-606-423014 Supplies-Repair & Maint-Inventory Supplies - 467,000 - - 242,820 467,000 691,132 505,761 620-06-604-606-436001 Services & Charges-Repairs & Maint- Building R&M 15,000 15,000 3,234 90,560 3,873 15,000 19,750 16,245 620-06-604-606-436003 Services & Charges-Repairs & Maint- Auto Equip R&M 85,000 215,000 83,119 83,659 160,654 215,000 214,800 232,845 86 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 620-06-604-606-436005 Services & Charges-Repairs & Maint- Other Equip R&M 3,500 3,500 900 1,216 - 3,500 3,000 3,500 620-06-604-606-436006 Services & Charges-Repairs & Maint- Radio Equip R&M - - - - 19,783 - 3,700 - 620-06-604-606-436014 Services & Charges-Repairs & Maint- Stop Box Repairs 75,000 - 68,118 - - - - - 620-06-604-606-436015 Services & Charges-Repairs & Maint- Water System Repairs 40,000 20,000 3,169 3,726 1,249 20,000 20,000 21,660 620-06-604-606-438100 Services & Charges-Debt Service- Principal 8,963 - 8,843 8,963 - - - - 620-06-604-606-438200 Services & Charges-Debt Service- Interest 93 - 216 93 - - - - 620-06-604-606-439001 Services & Charges-Other-Other Contractual Services 500,000 450,000 151,678 202,662 28,630 350,000 350,251 379,050 620-06-604-606-439006 Services & Charges-Other-Education & Training 5,000 7,500 - 90 567 7,500 7,500 7,500 620-06-604-606-439015 Services & Charges-Other-Plumbing Contractors 1,030,000 1,041,115 1,030,000 1,273,527 1,165,006 1,141,115 1,275,185 1,333,115 620-06-604-607-421000 Supplies-Office-General Office Supplies - - 4,702 - - 10,000 10,000 10,830 620-06-604-607-421002 Supplies-Office-Stationary & Printing 8,000 8,000 15,499 11,833 6,059 - - - 620-06-604-607-422008 Supplies-Operating-Medical/Safety Supplies 1,250 1,000 8 174 440 1,000 1,000 1,083 620-06-604-607-423001 Supplies-Repair & Maint-Building Materials 300 300 36 88 170 300 300 300 620-06-604-607-431000 Services & Charges-Professional-Other Professional Svcs 1,500 1,500 394,239 47,238 67,252 1,500 7,925 1,500 620-06-604-607-431009 Services & Charges-Professional- Computer & Technology - - - 81,657 12,771 - - - 620-06-604-607-431014 Services & Charges-Professional- Collection Costs 30,000 30,000 20,193 26,937 1,666 30,000 39,036 30,000 620-06-604-607-432002 Services & Charges-Communication & Transp-Mailing 6,000 6,000 5,154 3,291 3,069 6,000 6,000 6,498 620-06-604-607-433001 Services & Charges-Printing & Ad- Outside Printing Services 1,000 1,000 - 758 395 1,000 1,000 1,083 620-06-604-607-435001 Services & Charges-Utility Services- Electric 4,500 4,500 4,436 4,344 5,109 4,500 4,500 4,874 620-06-604-607-435002 Services & Charges-Utility Services- Natural Gas 2,200 2,200 1,835 1,498 1,552 2,200 2,200 2,383 87 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 620-06-604-607-436001 Services & Charges-Repairs & Maint- Building R&M 5,000 5,000 17,234 6,521 2,271 5,000 5,000 5,415 620-06-604-607-439001 Services & Charges-Other-Other Contractual Services 981,930 1,132,915 893,979 871,710 859,464 1,083,465 513,962 1,173,393 620-06-604-607-439003 Services & Charges-Other- Subscriptions - - 384,448 168,564 399,867 - 60,636 - 620-06-604-607-439005 Services & Charges-Other-Bank & Credit Card Fees - - - - - - 375,000 - 620-06-604-607-439006 Services & Charges-Other-Education & Training 3,000 3,000 990 - 14,000 3,000 3,000 6,000 620-06-604-607-439012 Services & Charges-Other-Uniform Services 2,100 2,100 1,441 789 758 2,100 2,100 2,274 620-06-604-607-439099 Services & Charges-Other-Cashier Over/Short 200 200 (72) 55 104 - - - 620-06-604-607-439100 Services & Charges-Other- Refunds/Awards/Indemnities - - - - 2,427 - - - 620-06-604-607-439999 Services & Charges-Other-Bad Debt Expense 104,000 150,000 77,370 99,420 51,503 100,000 - - 620-06-604-607-490000 Bad Debt Expense - - - - - - 100,000 100,000 620-06-604-608-410001 Personnel-Salaries & Wages-Salaried Wages 1,466,296 1,470,636 1,294,395 1,382,603 1,300,509 1,666,444 1,666,444 1,820,112 620-06-604-608-410002 Personnel-Salaries & Wages-Teamster Wages 1,734,372 1,776,088 1,597,630 1,632,748 1,513,160 1,780,032 1,780,032 1,916,156 620-06-604-608-410003 Personnel-Salaries & Wages- Permanent Part Time 33,946 33,946 43,624 40,884 17,007 33,946 33,946 33,946 620-06-604-608-410004 Personnel-Salaries & Wages-Extra & Overtime 255,000 255,000 212,597 202,418 207,611 255,000 255,000 262,500 620-06-604-608-410005 Personnel-Salaries & Wages-Seasonal & Interns 52,224 52,224 28,604 13,772 38,372 52,224 52,224 52,224 620-06-604-608-410007 Personnel-Salaries & Wages-Longevity Pay 6,550 6,550 5,950 5,100 4,900 6,550 6,550 6,550 620-06-604-608-410016 Personnel-Salaries & Wages- Supplemental Pay 117,500 100,000 104,729 109,732 111,338 100,000 - - 620-06-604-608-410017 Personnel-Salaries & Wages-Stand By Pay - - - - - - 100,000 100,000 620-06-604-608-411001 Personnel-Employee Benefits-FICA Regular 282,607 284,791 243,961 252,657 238,185 300,361 300,361 322,782 620-06-604-608-411004 Personnel-Employee Benefits-PERF Regular 404,100 407,298 356,320 369,711 347,385 430,093 430,093 462,919 620-06-604-608-411005 Personnel-Employee Benefits-PERF Union 32,050 32,414 19,796 17,761 15,933 32,529 32,529 34,621 88 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 620-06-604-608-411007 Personnel-Employee Benefits- Unemployment Comp 358 974 - 333 941 6,093 6,093 4,926 620-06-604-608-411008 Personnel-Employee Benefits-Health Insurance 738,137 738,137 610,311 752,934 697,226 921,767 921,767 966,718 620-06-604-608-411009 Personnel-Employee Benefits-Life Insurance 8,040 8,040 7,370 7,670 7,100 8,160 8,160 8,280 620-06-604-608-411014 Personnel-Employee Benefits-Parental Leave 12,529 12,629 7,306 11,695 11,000 13,328 13,328 14,369 620-06-604-608-411015 Personnel-Employee Benefits-Other Fringe Benefits 3,000 3,000 1,600 (200) 1,800 3,000 3,000 3,000 620-06-604-608-411200 Personnel-Employee Benefits-Clothing Allowance 5,000 5,000 1,843 2,503 1,593 5,000 5,000 5,000 620-06-604-608-411203 Personnel-Employee Benefits-Job Readiness Allow. 18,275 18,275 18,169 17,000 17,425 22,050 22,050 17,850 620-06-604-608-411205 Personnel-Employee Benefits-Parking Allowance 17,160 17,160 15,912 5,885 10,945 17,160 17,160 17,160 620-06-604-608-411206 Personnel-Employee Benefits-Cell Phone Allowance 5,040 5,040 4,425 5,035 3,720 5,040 5,040 5,040 620-06-604-608-421000 Supplies-Office-General Office Supplies - - - - - 7,000 7,534 7,581 620-06-604-608-421002 Supplies-Office-Stationary & Printing 7,000 7,000 790 6,648 3,339 - - - 620-06-604-608-431000 Services & Charges-Professional-Other Professional Svcs 100,000 100,000 3,410 21,908 112,987 100,000 122,251 108,300 620-06-604-608-431001 Services & Charges-Professional-Legal Services 10,000 10,000 3,464 28,686 246,639 40,000 223,845 125,000 620-06-604-608-431002 Services & Charges-Professional- Engineering & Architectural 100,000 100,000 85,357 231,661 23,851 - 92,126 - 620-06-604-608-431004 Services & Charges-Professional- Accounting & Auditing 5,000 5,000 - - - 5,000 17,944 5,000 620-06-604-608-432002 Services & Charges-Communication & Transp-Mailing 800 800 281 136 271 800 800 866 620-06-604-608-432003 Services & Charges-Communication & Transp-Travel 18,750 18,750 2,386 2,754 - 18,750 18,750 23,250 620-06-604-608-432004 Services & Charges-Communication & Transp-Telecommunications 14,000 14,000 11,323 11,581 11,578 14,000 14,000 14,280 620-06-604-608-433001 Services & Charges-Printing & Ad- Outside Printing Services 6,909 6,909 - 419 1,133 6,909 5,909 3,500 620-06-604-608-433002 Services & Charges-Printing & Ad- Publication of Legal Notice 1,000 1,000 567 430 107 1,000 2,000 1,000 89 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 620-06-604-608-436006 Services & Charges-Repairs & Maint- Radio Equip R&M 3,500 3,500 - - - - - - 620-06-604-608-437004 Services & Charges-Rentals-Building Rental 58,000 54,929 53,796 54,362 54,928 56,287 56,287 56,287 620-06-604-608-438100 Services & Charges-Debt Service- Principal 393,054 296,672 388,048 392,919 296,671 201,048 201,048 - 620-06-604-608-438200 Services & Charges-Debt Service- Interest 15,432 8,065 22,798 15,432 8,064 3,132 3,132 - 620-06-604-608-439000 Services & Charges-Other-Misc Charges & Svcs 45,000 45,000 43,700 43,700 43,700 45,000 45,000 48,735 620-06-604-608-439001 Services & Charges-Other-Other Contractual Services 27,500 27,500 25,617 22,947 21,138 27,500 102,500 29,783 620-06-604-608-439003 Services & Charges-Other- Subscriptions - - 11,250 - - - - - 620-06-604-608-439004 Services & Charges-Other-Dues & Memberships 12,000 12,000 7,626 7,459 8,563 12,000 12,000 12,000 620-06-604-608-439006 Services & Charges-Other-Education & Training 3,175 3,175 285 200 3,115 3,175 3,175 3,175 620-06-604-608-439012 Services & Charges-Other-Uniform Services 300 300 142 160 101 300 300 325 620-06-604-608-439022 Services & Charges-Other-Other Taxes & Licenses 20 20 5 - - 20 20 20 620-06-604-608-439025 Services & Charges-Other-State Gross Income Tax 225,000 225,000 213,500 224,000 224,000 225,000 225,000 225,000 620-06-604-608-439100 Services & Charges-Other- Refunds/Awards/Indemnities - - - 1,000 - - - - 620-06-604-608-451000 Other Uses-State Board of Accounts 12,000 13,500 11,193 16,587 - - - - 620-06-604-608-452000 Other Uses-Interfund Transfer Out- Transfers Out 5,953,486 4,954,548 5,539,552 5,166,931 4,951,702 6,649,430 6,649,430 3,603,661 620-06-604-608-452001 Other Uses-Interfund Transfer Out- PILOT 1,629,442 1,611,201 1,662,624 1,629,442 1,611,201 1,613,639 1,613,639 1,606,468 620-06-604-608-452002 Other Uses-Interfund Transfer Out- Allocations-Admin Cost 848,561 778,888 597,803 848,561 778,888 793,629 793,629 1,129,352 620-06-604-608-452003 Other Uses-Interfund Transfer Out- Allocations-IT 639,405 773,734 687,065 639,405 773,734 813,010 813,010 922,752 620-06-604-608-452004 Other Uses-Interfund Transfer Out- Allocations-Liability Ins 172,436 189,743 193,032 172,436 189,743 178,414 178,414 235,784 620-06-604-608-452006 Other Uses-Interfund Transfer Out- Allocations-Print Shop - - 7,538 - - - - - 90 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 620-06-604-608-452007 Other Uses-Interfund Transfer Out- Allocations-Central Stores - - 19,630 - - - - - 620-06-604-608-452008 Other Uses-Interfund Transfer Out- Allocations-Payroll Cost 494,691 497,796 474,284 494,691 497,796 521,731 521,731 525,221 620-06-604-608-452009 Other Uses-Interfund Transfer Out- Allocations-Facilities Mgt 29,241 27,632 - 29,241 27,632 35,930 35,930 34,952 622-06-604-620-431002 Services & Charges-Professional- Engineering & Architectural - - 65,611 31,704 22,740 100,000 309,347 1,000,000 622-06-604-620-439999 Services & Charges-Other-Bad Debt Expense - - - - (428) - - - 622-06-604-620-442005 Capital Outlay-Infrastructure- Treatment/Disposal Equipment 1,521,000 903,000 - - 797,154 - 5,072,289 9,653,000 622-06-604-620-442006 Capital Outlay-Infrastructure-Wells 179,000 - 491,086 56,473 103,174 - 320,751 - 622-06-604-620-442007 Capital Outlay-Infrastructure-Mains 680,000 867,000 - - - 4,400,000 1,695,910 300,000 622-06-604-620-442008 Capital Outlay-Infrastructure-Water Meters - - - - - 4,000,000 380,590 500,000 622-06-604-620-442009 Capital Outlay-Infrastructure-Hydrants - - - - - - - 200,000 622-06-604-620-442010 Capital Outlay-Infrastructure- Distribution Reservoirs - 330,000 - - - - 4,469,400 8,185,000 622-06-604-620-443001 Capital Outlay-Buildings-Building Improvements 235,000 - 18,000 565,155 128,880 - - - 622-06-604-620-445000 Capital Outlay-Machinery & Equip- Motor Equipment 507,000 429,000 627,383 28,104 477,582 462,000 462,000 500,000 622-06-604-620-445008 Capital Outlay-Machinery & Equip- Other Equipment 20,000 44,000 10,574 77,052 4,800 25,000 25,000 - 624-06-604-608-452000 Other Uses-Interfund Transfer Out- Transfers Out 20,000 17,381 34,076 16,448 7,493 - - - 625-06-604-608-452000 Other Uses-Interfund Transfer Out- Transfers Out 20,000 24,269 25,229 10,069 2,818 - - - 625-06-604-621-438100 Services & Charges-Debt Service- Principal 1,338,099 1,093,877 2,653,962 1,058,099 1,093,877 1,939,273 1,939,273 1,663,800 625-06-604-621-438200 Services & Charges-Debt Service- Interest 482,387 416,171 802,857 442,037 416,148 721,657 721,657 1,088,361 625-06-604-621-438300 Services & Charges-Debt Service- Paying Agent Fees 1,000 1,500 1,000 1,000 1,000 1,500 1,500 1,500 626-06-604-608-452000 Other Uses-Interfund Transfer Out- Transfers Out 20,000 20,000 34,582 20,000 8,188 - - - 91 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 629-06-604-608-452000 Other Uses-Interfund Transfer Out- Transfers Out 40,000 41,884 65,938 37,210 17,168 - - - 640-06-602-510-410001 Personnel-Salaries & Wages-Salaried Wages 59,890 60,070 58,716 59,890 60,070 61,572 61,572 63,419 640-06-602-510-410002 Personnel-Salaries & Wages-Teamster Wages 44,491 44,926 44,161 44,688 45,136 46,657 46,657 50,163 640-06-602-510-410004 Personnel-Salaries & Wages-Extra & Overtime 2,652 2,677 1,632 3,699 5,572 9,987 9,987 10,906 640-06-602-510-410007 Personnel-Salaries & Wages-Longevity Pay 200 200 150 200 200 200 200 200 640-06-602-510-410014 Personnel-Salaries & Wages-Contract Add Pays 8,080 8,080 3,682 7,650 8,463 9,811 - - 640-06-602-510-410017 Personnel-Salaries & Wages-Stand By Pay - - - - - - 9,811 10,714 640-06-602-510-411001 Personnel-Employee Benefits-FICA Regular 8,937 8,986 8,103 8,671 9,153 9,932 9,932 10,473 640-06-602-510-411004 Personnel-Employee Benefits-PERF Regular 13,084 13,155 12,312 13,175 13,835 14,541 14,541 15,334 640-06-602-510-411005 Personnel-Employee Benefits-PERF Union 844 851 758 856 942 1,014 1,014 1,092 640-06-602-510-411007 Personnel-Employee Benefits- Unemployment Comp 12 31 - 12 35 205 205 162 640-06-602-510-411008 Personnel-Employee Benefits-Health Insurance 23,221 23,221 20,875 26,237 26,237 27,111 27,111 28,021 640-06-602-510-411009 Personnel-Employee Benefits-Life Insurance 240 240 240 240 240 240 240 240 640-06-602-510-411014 Personnel-Employee Benefits-Parental Leave 404 406 274 410 419 449 449 474 640-06-602-510-411015 Personnel-Employee Benefits-Other Fringe Benefits - - 200 - 200 200 200 200 640-06-602-510-411203 Personnel-Employee Benefits-Job Readiness Allow. 425 425 425 425 425 525 525 425 640-06-602-510-411206 Personnel-Employee Benefits-Cell Phone Allowance 1,080 1,080 1,080 1,080 1,080 1,080 1,080 1,080 640-06-602-510-422000 Supplies-Operating-Other Operating Supplies 4,217 5,750 180 704 - 3,000 3,000 3,030 640-06-602-510-422001 Supplies-Operating-C.S. Gasoline 9,248 2,500 1,638 - 517 2,000 2,000 2,667 640-06-602-510-422005 Supplies-Operating-Uniforms 300 325 289 327 363 500 500 750 640-06-602-510-423005 Supplies-Repair & Maint-Sewer Maint Materials 2,500 29,900 27,226 25,514 33,779 60,000 60,000 60,000 92 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 640-06-602-510-433001 Services & Charges-Printing & Ad- Outside Printing Services 700 700 - - - 350 350 200 640-06-602-510-436003 Services & Charges-Repairs & Maint- Auto Equip R&M 1,000 1,000 1,244 1,056 1,112 1,000 1,000 1,050 640-06-602-510-436007 Services & Charges-Repairs & Maint- Sewer R&M 385,000 347,601 290,303 506,171 421,744 400,000 400,000 450,000 640-06-602-510-439100 Services & Charges-Other- Refunds/Awards/Indemnities - - - 6,875 - - - - 640-06-602-510-439999 Services & Charges-Other-Bad Debt Expense 6,500 6,500 3,828 3,705 1,891 6,500 - - 640-06-602-510-452002 Other Uses-Interfund Transfer Out- Allocations-Admin Cost 24,608 31,973 20,457 24,608 31,973 34,387 34,387 36,705 640-06-602-510-452004 Other Uses-Interfund Transfer Out- Allocations-Liability Ins 394 - 477 394 - - - - 640-06-602-510-452008 Other Uses-Interfund Transfer Out- Allocations-Payroll Cost 59,509 59,928 54,561 59,509 59,928 61,808 61,808 63,801 640-06-602-510-490000 Bad Debt Expense - - - - - - 6,500 6,500 641-06-602-509-410001 Personnel-Salaries & Wages-Salaried Wages 331,778 328,530 287,042 322,441 315,651 343,493 343,493 365,322 641-06-602-509-410002 Personnel-Salaries & Wages-Teamster Wages 1,200,348 1,214,076 1,110,298 1,094,597 1,114,586 1,239,490 1,239,290 1,373,359 641-06-602-509-410003 Personnel-Salaries & Wages- Permanent Part Time 94,100 94,100 76,186 65,814 73,728 123,053 123,053 123,656 641-06-602-509-410004 Personnel-Salaries & Wages-Extra & Overtime 171,776 175,526 145,631 98,567 145,890 169,064 169,064 185,198 641-06-602-509-410005 Personnel-Salaries & Wages-Seasonal & Interns 76,378 76,378 41,211 32,533 53,399 99,840 99,840 99,840 641-06-602-509-410007 Personnel-Salaries & Wages-Longevity Pay 2,300 2,100 2,800 2,350 2,550 2,700 2,700 3,200 641-06-602-509-410017 Personnel-Salaries & Wages-Stand By Pay 100,987 147,499 91,069 96,294 108,274 162,032 162,032 186,050 641-06-602-509-411001 Personnel-Employee Benefits-FICA Regular 152,689 157,320 132,224 129,101 135,228 165,304 165,304 180,149 641-06-602-509-411004 Personnel-Employee Benefits-PERF Regular 204,451 211,232 185,845 184,551 187,267 217,050 217,050 238,716 641-06-602-509-411005 Personnel-Employee Benefits-PERF Union 22,366 23,322 14,543 11,939 12,242 23,877 23,877 26,491 641-06-602-509-411007 Personnel-Employee Benefits- Unemployment Comp 181 463 - 161 517 3,067 2,867 2,536 641-06-602-509-411008 Personnel-Employee Benefits-Health Insurance 406,364 406,364 317,136 418,007 412,895 474,439 474,439 490,364 93 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 641-06-602-509-411009 Personnel-Employee Benefits-Life Insurance 4,200 4,200 3,824 4,075 3,965 4,200 4,200 4,200 641-06-602-509-411014 Personnel-Employee Benefits-Parental Leave 6,325 6,537 3,825 5,647 5,920 6,709 6,709 7,396 641-06-602-509-411015 Personnel-Employee Benefits-Other Fringe Benefits 4,000 4,000 4,000 - 3,400 5,800 5,800 5,800 641-06-602-509-411203 Personnel-Employee Benefits-Job Readiness Allow. 12,325 12,325 11,900 12,325 12,325 15,225 15,225 12,325 641-06-602-509-411206 Personnel-Employee Benefits-Cell Phone Allowance 5,940 5,940 2,915 2,640 2,640 5,940 5,940 5,940 641-06-602-509-421000 Supplies-Office-General Office Supplies - - - - - 2,500 2,800 2,500 641-06-602-509-421002 Supplies-Office-Stationary & Printing 5,100 5,100 3,092 2,739 33,938 - - - 641-06-602-509-422000 Supplies-Operating-Other Operating Supplies 43,000 45,000 8,389 21,148 24,351 60,000 134,049 132,500 641-06-602-509-422002 Supplies-Operating-Diesel/CNG 166,460 130,000 122,779 102,002 145,240 136,827 136,827 214,557 641-06-602-509-422005 Supplies-Operating-Uniforms 9,375 9,375 7,334 7,629 11,257 13,475 15,975 21,975 641-06-602-509-422007 Supplies-Operating-Cleaning Supplies 2,200 5,000 1,482 1,456 2,836 5,000 5,000 5,050 641-06-602-509-422008 Supplies-Operating-Medical/Safety Supplies 5,475 7,500 2,814 4,803 7,132 7,500 7,500 7,575 641-06-602-509-423002 Supplies-Repair & Maint-Street Material 200,000 175,000 129,669 87,107 158,850 175,000 175,000 210,000 641-06-602-509-423004 Supplies-Repair & Maint-Sewer Construction Materials 110,000 110,000 50,996 78,792 41,826 110,000 115,321 111,100 641-06-602-509-423005 Supplies-Repair & Maint-Sewer Maint Materials 141,733 110,000 40,909 86,451 33,834 110,000 114,064 111,100 641-06-602-509-423006 Supplies-Repair & Maint-Small Tools & Equipment 35,000 45,000 17,447 10,358 28,915 45,000 50,897 50,843 641-06-602-509-423008 Supplies-Repair & Maint-Salt & Winter Materials 109,200 - 90,593 77,720 - - - - 641-06-602-509-432003 Services & Charges-Communication & Transp-Travel 15,000 15,000 4,615 4,295 356 5,000 6,500 12,500 641-06-602-509-432004 Services & Charges-Communication & Transp-Telecommunications 1,200 1,440 1,400 1,113 1,248 1,440 1,440 1,440 641-06-602-509-433001 Services & Charges-Printing & Ad- Outside Printing Services 4,462 4,462 - - 833 2,000 2,000 2,000 641-06-602-509-433002 Services & Charges-Printing & Ad- Publication of Legal Notice 750 750 69 23 54 250 250 250 94 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 641-06-602-509-435001 Services & Charges-Utility Services- Electric 19,685 19,685 17,588 15,419 16,118 23,148 23,148 25,465 641-06-602-509-435002 Services & Charges-Utility Services- Natural Gas 15,675 15,675 14,305 11,318 12,277 17,583 17,583 21,980 641-06-602-509-435004 Services & Charges-Utility Services- Water 7,200 7,500 6,400 8,187 11,809 11,125 11,125 14,000 641-06-602-509-436001 Services & Charges-Repairs & Maint- Building R&M 61,334 71,350 34,841 19,270 38,279 84,350 19,350 12,525 641-06-602-509-436003 Services & Charges-Repairs & Maint- Auto Equip R&M 497,000 500,000 536,124 532,278 468,543 525,000 525,000 551,775 641-06-602-509-436005 Services & Charges-Repairs & Maint- Other Equip R&M 3,500 4,000 - - - 4,000 4,507 4,000 641-06-602-509-436006 Services & Charges-Repairs & Maint- Radio Equip R&M 6,000 6,500 8,621 10,299 8,575 8,000 8,000 8,000 641-06-602-509-436007 Services & Charges-Repairs & Maint- Sewer R&M 30,000 30,000 14,841 14,580 13,346 30,000 30,000 30,000 641-06-602-509-437002 Services & Charges-Rentals-Equipment Rental 30,000 30,000 - 11,030 - 30,000 30,000 30,000 641-06-602-509-438100 Services & Charges-Debt Service- Principal 6,984 - 55,379 6,984 - - - - 641-06-602-509-438200 Services & Charges-Debt Service- Interest 73 - 733 73 - - - - 641-06-602-509-439000 Services & Charges-Other-Misc Charges & Svcs 11,104 11,615 4,938 52 153 11,615 11,615 11,615 641-06-602-509-439001 Services & Charges-Other-Other Contractual Services 847,357 627,900 657,332 824,554 1,778,519 627,900 1,685,790 627,900 641-06-602-509-439003 Services & Charges-Other- Subscriptions - - - - 109 - - - 641-06-602-509-439006 Services & Charges-Other-Education & Training 15,000 15,000 9,940 6,075 5,025 10,000 8,500 15,000 641-06-602-509-439009 Services & Charges-Other-Trash Removal 1,464 1,750 1,179 1,685 - - - - 641-06-602-509-439011 Services & Charges-Other-Waste Removal/Disposal 145,102 72,500 59,659 56,299 50,619 72,500 81,881 72,500 641-06-602-509-439016 Services & Charges-Other-Lateral Sewer Connection Reimb - - - - - - 180,000 180,000 641-06-602-509-439999 Services & Charges-Other-Bad Debt Expense 240,000 240,000 135,912 112,255 77,772 225,000 - - 641-06-602-509-445008 Capital Outlay-Machinery & Equip- Other Equipment - - - - - - 26,610 - 95 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 641-06-602-509-452002 Other Uses-Interfund Transfer Out- Allocations-Admin Cost 262,807 330,835 290,055 262,807 330,835 339,843 339,843 325,953 641-06-602-509-452003 Other Uses-Interfund Transfer Out- Allocations-IT 401,956 391,580 500,231 401,956 391,580 363,663 363,663 384,572 641-06-602-509-452004 Other Uses-Interfund Transfer Out- Allocations-Liability Ins 165,649 91,555 140,185 165,649 91,555 91,744 91,744 113,938 641-06-602-509-452006 Other Uses-Interfund Transfer Out- Allocations-Print Shop - - 3,750 - - - - - 641-06-602-509-452007 Other Uses-Interfund Transfer Out- Allocations-Central Stores - - 11,133 - - - - - 641-06-602-509-452008 Other Uses-Interfund Transfer Out- Allocations-Payroll Cost 388,205 426,031 375,501 388,205 426,031 475,507 475,507 461,406 641-06-602-509-452009 Other Uses-Interfund Transfer Out- Allocations-Facilities Mgt 1,099 1,145 - 1,099 1,145 1,276 1,276 1,281 641-06-602-509-490000 Bad Debt Expense - - - - - - 225,000 225,000 641-06-602-511-410001 Personnel-Salaries & Wages-Salaried Wages - - - - - - - - 641-06-602-511-410002 Personnel-Salaries & Wages-Teamster Wages 172,770 174,477 156,739 157,425 173,650 178,758 178,758 190,612 641-06-602-511-410003 Personnel-Salaries & Wages- Permanent Part Time - - - - - - - - 641-06-602-511-410004 Personnel-Salaries & Wages-Extra & Overtime 15,987 16,006 10,177 3,995 11,465 38,122 38,122 42,142 641-06-602-511-410005 Personnel-Salaries & Wages-Seasonal & Interns - - - - - - - - 641-06-602-511-410007 Personnel-Salaries & Wages-Longevity Pay 350 500 450 450 450 500 700 500 641-06-602-511-410017 Personnel-Salaries & Wages-Stand By Pay 3,000 21,141 3,000 6,749 9,626 24,913 24,913 27,536 641-06-602-511-411001 Personnel-Employee Benefits-FICA Regular 14,877 16,408 12,697 12,679 14,760 18,747 18,747 20,131 641-06-602-511-411004 Personnel-Employee Benefits-PERF Regular 21,780 24,022 19,294 18,869 21,475 27,446 27,446 29,473 641-06-602-511-411005 Personnel-Employee Benefits-PERF Union 2,917 3,217 2,062 2,061 2,232 3,676 3,676 3,947 641-06-602-511-411007 Personnel-Employee Benefits- Unemployment Comp 19 52 - 17 59 388 588 313 641-06-602-511-411008 Personnel-Employee Benefits-Health Insurance 46,442 46,442 36,805 47,772 51,466 54,222 54,222 56,042 641-06-602-511-411009 Personnel-Employee Benefits-Life Insurance 480 480 435 440 480 480 480 480 96 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 641-06-602-511-411014 Personnel-Employee Benefits-Parental Leave 672 742 430 593 685 848 848 913 641-06-602-511-411015 Personnel-Employee Benefits-Other Fringe Benefits 1,000 1,000 200 - 200 800 800 800 641-06-602-511-411203 Personnel-Employee Benefits-Job Readiness Allow. 1,700 1,700 1,275 1,275 1,700 2,100 2,100 1,700 641-06-602-511-411206 Personnel-Employee Benefits-Cell Phone Allowance 660 660 385 - - 660 660 660 641-06-602-511-422000 Supplies-Operating-Other Operating Supplies 20,000 20,000 11,446 4,026 5,661 15,000 14,000 15,150 641-06-602-511-422002 Supplies-Operating-Diesel/CNG 9,248 7,500 5,229 4,564 6,593 7,500 7,500 7,975 641-06-602-511-422005 Supplies-Operating-Uniforms 1,350 1,350 860 1,102 1,253 1,350 2,350 2,350 641-06-602-511-423005 Supplies-Repair & Maint-Sewer Maint Materials 73,000 33,000 49,358 28,882 24,367 33,000 33,000 33,660 641-06-602-511-423006 Supplies-Repair & Maint-Small Tools & Equipment 10,000 10,581 1,655 3,221 3,798 8,500 9,940 8,585 641-06-602-511-436003 Services & Charges-Repairs & Maint- Auto Equip R&M 8,000 8,500 6,092 8,231 9,677 8,500 8,500 8,925 641-06-602-511-436006 Services & Charges-Repairs & Maint- Radio Equip R&M - - - 800 108 - - - 641-06-602-511-452002 Other Uses-Interfund Transfer Out- Allocations-Admin Cost 19,617 25,169 16,484 19,617 25,169 27,177 27,177 27,126 641-06-602-511-452004 Other Uses-Interfund Transfer Out- Allocations-Liability Ins 6,946 5,419 715 6,946 5,419 3,970 3,970 2,030 641-06-602-511-452008 Other Uses-Interfund Transfer Out- Allocations-Payroll Cost 86,796 95,772 82,529 86,796 95,772 99,888 99,888 109,234 641-06-605-514-410001 Personnel-Salaries & Wages-Salaried Wages 1,297,324 1,301,217 1,244,169 1,266,790 1,211,096 1,339,745 1,339,745 1,397,922 641-06-605-514-410002 Personnel-Salaries & Wages-Teamster Wages 1,075,971 1,086,295 956,776 997,738 993,642 1,112,155 1,112,155 1,151,519 641-06-605-514-410003 Personnel-Salaries & Wages- Permanent Part Time - - - - - - - - 641-06-605-514-410004 Personnel-Salaries & Wages-Extra & Overtime 159,900 159,900 172,632 179,063 165,059 159,900 159,900 167,400 641-06-605-514-410005 Personnel-Salaries & Wages-Seasonal & Interns 20,480 20,480 3,090 - 4,492 20,480 20,480 20,480 641-06-605-514-410007 Personnel-Salaries & Wages-Longevity Pay 5,200 5,200 4,367 3,258 2,563 5,200 5,200 5,200 641-06-605-514-410017 Personnel-Salaries & Wages-Stand By Pay 113,152 113,152 94,644 96,029 96,030 120,000 120,000 120,000 97 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 641-06-605-514-411001 Personnel-Employee Benefits-FICA Regular 205,934 207,022 185,328 188,831 185,727 212,655 212,655 220,507 641-06-605-514-411004 Personnel-Employee Benefits-PERF Regular 299,204 300,797 279,757 284,446 275,016 309,044 309,044 320,540 641-06-605-514-411005 Personnel-Employee Benefits-PERF Union 20,466 20,621 14,179 12,043 10,131 21,148 21,148 21,815 641-06-605-514-411007 Personnel-Employee Benefits- Unemployment Comp 265 716 - 252 741 4,379 4,379 3,410 641-06-605-514-411008 Personnel-Employee Benefits-Health Insurance 461,158 461,158 385,850 488,310 466,282 596,438 596,438 616,458 641-06-605-514-411009 Personnel-Employee Benefits-Life Insurance 5,280 5,280 4,980 5,075 4,910 5,280 5,280 5,280 641-06-605-514-411014 Personnel-Employee Benefits-Parental Leave 9,280 9,330 5,935 8,892 8,606 9,580 9,580 9,947 641-06-605-514-411015 Personnel-Employee Benefits-Other Fringe Benefits 2,500 2,500 1,340 - 1,263 2,500 2,500 2,500 641-06-605-514-411203 Personnel-Employee Benefits-Job Readiness Allow. 10,200 10,200 9,350 8,606 9,563 12,600 12,600 10,200 641-06-605-514-411204 Personnel-Employee Benefits-Auto Allowance 1,800 1,800 1,800 1,800 1,800 1,800 1,800 1,800 641-06-605-514-411206 Personnel-Employee Benefits-Cell Phone Allowance 7,920 7,920 7,350 7,060 5,940 7,920 7,920 7,920 641-06-605-514-421000 Supplies-Office-General Office Supplies - - - - - 10,000 15,066 10,000 641-06-605-514-421002 Supplies-Office-Stationary & Printing 10,000 10,000 9,221 6,902 6,106 - - - 641-06-605-514-422000 Supplies-Operating-Other Operating Supplies - - - 15 - - - - 641-06-605-514-422001 Supplies-Operating-C.S. Gasoline 28,167 23,756 25,332 18,042 26,046 26,309 26,309 42,952 641-06-605-514-422002 Supplies-Operating-Diesel/CNG 5,000 5,000 - 2,804 65 10,000 15,500 13,173 641-06-605-514-422004 Supplies-Operating-Oil 14,000 14,000 8,198 13,838 21,265 18,000 18,000 19,494 641-06-605-514-422005 Supplies-Operating-Uniforms 23,000 23,000 20,866 20,571 21,337 23,000 23,000 24,909 641-06-605-514-422007 Supplies-Operating-Cleaning Supplies 5,000 5,000 5,214 6,261 4,792 5,000 5,000 5,415 641-06-605-514-422008 Supplies-Operating-Medical/Safety Supplies 6,275 6,275 2,593 4,370 7,880 6,275 6,437 6,796 641-06-605-514-422012 Supplies-Operating-Water Treatment Chemicals 401,350 405,038 355,704 337,442 374,012 445,810 504,360 829,512 641-06-605-514-422022 Supplies-Operating-Laboratory Supplies 40,000 40,000 49,720 40,110 35,573 40,000 45,169 43,320 98 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 641-06-605-514-423006 Supplies-Repair & Maint-Small Tools & Equipment 27,000 27,000 13,939 24,394 32,660 27,000 24,578 27,000 641-06-605-514-423009 Supplies-Repair & Maint-Repair Parts 400,000 400,000 424,066 370,756 253,109 400,000 508,882 453,200 641-06-605-514-423013 Supplies-Repair & Maint-Materials & Supplies 210,000 210,000 197,463 226,845 163,191 210,000 227,567 227,430 641-06-605-514-431000 Services & Charges-Professional-Other Professional Svcs - - 3,500 - - - - - 641-06-605-514-431001 Services & Charges-Professional-Legal Services 350,000 250,000 78,159 35,958 19,445 100,000 100,000 100,000 641-06-605-514-431002 Services & Charges-Professional- Engineering & Architectural 1,150,000 1,950,000 1,494,383 757,890 349,437 - 1,577,920 - 641-06-605-514-431004 Services & Charges-Professional- Accounting & Auditing 40,000 40,000 31,081 23,405 - 50,000 71,264 50,000 641-06-605-514-431013 Services & Charges-Professional- Contract Lab Analysis 60,000 60,000 27,849 32,439 30,428 60,000 66,582 64,980 641-06-605-514-432002 Services & Charges-Communication & Transp-Mailing 5,000 5,000 3,034 2,881 1,947 5,000 5,000 5,000 641-06-605-514-432003 Services & Charges-Communication & Transp-Travel 30,000 30,000 5,218 772 - 30,000 30,000 30,000 641-06-605-514-432004 Services & Charges-Communication & Transp-Telecommunications 6,000 6,600 7,729 9,885 5,082 6,600 6,600 6,600 641-06-605-514-433001 Services & Charges-Printing & Ad- Outside Printing Services 1,199 1,199 - 284 424 1,199 1,199 1,299 641-06-605-514-433002 Services & Charges-Printing & Ad- Publication of Legal Notice 3,000 3,000 228 542 196 3,000 3,000 3,000 641-06-605-514-435001 Services & Charges-Utility Services- Electric 900,000 935,000 932,277 902,439 913,318 935,000 935,000 1,012,605 641-06-605-514-435002 Services & Charges-Utility Services- Natural Gas 340,000 300,000 203,377 134,309 169,195 300,000 300,000 324,900 641-06-605-514-435004 Services & Charges-Utility Services- Water 20,000 23,000 21,758 20,981 28,737 23,000 23,000 24,909 641-06-605-514-436001 Services & Charges-Repairs & Maint- Building R&M 643,500 643,500 547,108 221,425 628,078 648,500 1,129,017 702,326 641-06-605-514-436003 Services & Charges-Repairs & Maint- Auto Equip R&M 55,000 55,000 50,784 55,899 66,398 55,000 55,000 59,565 641-06-605-514-436005 Services & Charges-Repairs & Maint- Other Equip R&M 395,000 398,000 772,519 369,421 207,720 398,000 595,285 431,034 641-06-605-514-436006 Services & Charges-Repairs & Maint- Radio Equip R&M 2,500 2,500 3,416 13,929 3,848 2,500 2,500 2,500 99 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 641-06-605-514-438100 Services & Charges-Debt Service- Principal 7,233 4,370 7,653 7,233 4,370 - - - 641-06-605-514-438200 Services & Charges-Debt Service- Interest 331 91 644 331 90 - - - 641-06-605-514-439000 Services & Charges-Other-Misc Charges & Svcs 100 100 - - - 100 450 - 641-06-605-514-439001 Services & Charges-Other-Other Contractual Services 1,215,500 1,212,500 1,071,816 901,600 1,041,932 937,500 1,379,542 1,355,413 641-06-605-514-439003 Services & Charges-Other- Subscriptions - - 625,630 283,956 21,705 - - - 641-06-605-514-439004 Services & Charges-Other-Dues & Memberships 28,500 28,500 19,825 19,352 18,909 28,500 28,500 28,500 641-06-605-514-439005 Services & Charges-Other-Bank & Credit Card Fees 1,300 - 1,561 249 - - - - 641-06-605-514-439006 Services & Charges-Other-Education & Training 24,000 24,000 7,945 5,439 10,151 24,000 25,374 24,000 641-06-605-514-439011 Services & Charges-Other-Waste Removal/Disposal 72,500 72,000 113,770 107,836 83,562 100,000 123,803 108,300 641-06-605-514-439021 Services & Charges-Other-Basement Valve Program 50,000 50,000 9,648 7,695 23,732 50,000 50,000 50,000 641-06-605-514-439023 Services & Charges-Other- Penalties/Fees 3,000 3,000 - - - 3,000 3,000 3,000 641-06-605-514-439100 Services & Charges-Other- Refunds/Awards/Indemnities - - - - 1,000 - - - 641-06-605-514-439999 Services & Charges-Other-Bad Debt Expense - - 7,212 46,106 6,059 - - - 641-06-605-514-451000 Other Uses-State Board of Accounts 16,000 16,000 10,859 14,877 - - 13,153 - 641-06-605-514-452000 Other Uses-Interfund Transfer Out- Transfers Out 15,782,102 13,591,468 13,075,295 15,782,102 11,991,816 14,772,089 14,772,089 9,773,347 641-06-605-514-452001 Other Uses-Interfund Transfer Out- PILOT 4,592,349 4,543,120 4,678,366 4,592,349 4,543,120 4,465,686 4,465,686 4,489,126 641-06-605-514-452002 Other Uses-Interfund Transfer Out- Allocations-Admin Cost 1,254,547 1,692,103 1,250,680 1,254,547 1,692,103 1,793,227 1,793,227 1,592,245 641-06-605-514-452003 Other Uses-Interfund Transfer Out- Allocations-IT 459,284 506,602 562,970 459,284 506,602 504,497 504,497 459,202 641-06-605-514-452004 Other Uses-Interfund Transfer Out- Allocations-Liability Ins 253,826 432,085 253,364 253,826 432,085 439,243 439,243 535,004 641-06-605-514-452005 Other Uses-Interfund Transfer Out- Allocations-Utility Mgmt 1,485,327 1,545,290 1,438,428 1,485,327 1,545,290 1,123,555 1,123,555 1,297,423 100 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 641-06-605-514-452006 Other Uses-Interfund Transfer Out- Allocations-Print Shop - - 1,177 - - - - - 641-06-605-514-452007 Other Uses-Interfund Transfer Out- Allocations-Central Stores - - 22,631 - - - - - 641-06-605-514-452008 Other Uses-Interfund Transfer Out- Allocations-Payroll Cost 648,149 576,817 629,653 648,149 576,817 596,972 596,972 604,266 641-06-605-514-452009 Other Uses-Interfund Transfer Out- Allocations-Facilities Mgt 37,212 40,769 - 37,212 40,769 49,475 49,475 48,828 641-06-605-514-453000 Other Uses-Interfund Loan - - - 250,000 - - - - 641-06-605-515-410001 Personnel-Salaries & Wages-Salaried Wages 104,582 104,895 101,059 104,541 104,855 107,517 107,517 113,839 641-06-605-515-410002 Personnel-Salaries & Wages-Teamster Wages 166,384 168,048 151,758 166,285 166,925 172,180 172,180 212,071 641-06-605-515-410004 Personnel-Salaries & Wages-Extra & Overtime 38,301 38,592 10,383 11,067 13,000 38,592 36,092 38,592 641-06-605-515-410007 Personnel-Salaries & Wages-Longevity Pay 900 900 800 800 900 900 900 900 641-06-605-515-410017 Personnel-Salaries & Wages-Stand By Pay 10,495 10,553 9,940 10,035 9,368 10,553 13,053 10,553 641-06-605-515-411001 Personnel-Employee Benefits-FICA Regular 24,711 24,889 21,226 22,171 22,394 25,436 25,436 28,974 641-06-605-515-411004 Personnel-Employee Benefits-PERF Regular 36,178 36,439 30,946 33,089 33,324 37,240 37,240 42,419 641-06-605-515-411005 Personnel-Employee Benefits-PERF Union 3,267 3,297 1,919 2,149 2,181 3,365 3,365 3,964 641-06-605-515-411007 Personnel-Employee Benefits- Unemployment Comp 32 82 - 30 97 528 528 451 641-06-605-515-411008 Personnel-Employee Benefits-Health Insurance 39,842 39,842 35,898 54,806 54,806 81,332 81,332 98,073 641-06-605-515-411009 Personnel-Employee Benefits-Life Insurance 720 720 710 720 720 720 720 840 641-06-605-515-411014 Personnel-Employee Benefits-Parental Leave 1,122 1,130 699 1,029 1,037 1,154 1,154 1,316 641-06-605-515-411015 Personnel-Employee Benefits-Other Fringe Benefits 450 450 200 - 200 450 450 450 641-06-605-515-411203 Personnel-Employee Benefits-Job Readiness Allow. 1,700 1,700 1,700 1,700 1,700 2,100 2,100 2,125 641-06-605-515-411206 Personnel-Employee Benefits-Cell Phone Allowance 660 660 660 660 660 660 660 660 641-06-605-515-421000 Supplies-Office-General Office Supplies - - - - - 1,000 1,000 1,083 101 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 641-06-605-515-421002 Supplies-Office-Stationary & Printing 1,000 1,000 966 1,413 332 - - - 641-06-605-515-422000 Supplies-Operating-Other Operating Supplies - - - 143 - - - - 641-06-605-515-422001 Supplies-Operating-C.S. Gasoline 94,278 82,039 77,859 65,000 88,805 77,358 77,358 126,300 641-06-605-515-422005 Supplies-Operating-Uniforms 3,000 3,000 2,322 2,173 1,879 3,000 3,000 3,249 641-06-605-515-422007 Supplies-Operating-Cleaning Supplies 300 300 - - - 300 300 325 641-06-605-515-422008 Supplies-Operating-Medical/Safety Supplies 200 200 - - - 200 200 217 641-06-605-515-423006 Supplies-Repair & Maint-Small Tools & Equipment - - 318 79 - - - - 641-06-605-515-423009 Supplies-Repair & Maint-Repair Parts 2,000 2,000 521 1,173 149 2,000 2,000 2,166 641-06-605-515-423013 Supplies-Repair & Maint-Materials & Supplies 3,000 3,000 736 2,535 2,754 3,000 3,000 3,249 641-06-605-515-432000 Services & Charges-Communication & Transp-Other 1,500 1,500 780 730 - 2,000 2,000 2,166 641-06-605-515-432002 Services & Charges-Communication & Transp-Mailing 300 300 172 119 15 300 300 325 641-06-605-515-432003 Services & Charges-Communication & Transp-Travel 3,000 3,000 307 1,135 - 3,000 3,000 3,000 641-06-605-515-433001 Services & Charges-Printing & Ad- Outside Printing Services 100 100 - - - 100 100 108 641-06-605-515-433002 Services & Charges-Printing & Ad- Publication of Legal Notice 200 200 - - 116 200 200 200 641-06-605-515-435001 Services & Charges-Utility Services- Electric 3,600 3,600 3,026 3,806 2,995 4,000 4,000 4,332 641-06-605-515-435002 Services & Charges-Utility Services- Natural Gas 7,000 7,000 7,113 3,694 4,715 7,000 7,000 7,581 641-06-605-515-435004 Services & Charges-Utility Services- Water 1,700 1,700 1,017 1,267 1,489 1,700 1,700 1,841 641-06-605-515-436001 Services & Charges-Repairs & Maint- Building R&M 20,000 50,000 7,408 3,904 2,198 75,000 69,475 81,225 641-06-605-515-436003 Services & Charges-Repairs & Maint- Auto Equip R&M 180,000 250,000 285,097 202,910 227,923 275,000 275,000 297,825 641-06-605-515-436005 Services & Charges-Repairs & Maint- Other Equip R&M 500 500 - 800 - 500 6,025 542 641-06-605-515-436006 Services & Charges-Repairs & Maint- Radio Equip R&M 1,500 1,500 442 2,054 2,819 1,500 1,500 1,625 102 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 641-06-605-515-438100 Services & Charges-Debt Service- Principal 509,521 290,045 500,993 500,044 290,044 188,483 188,483 - 641-06-605-515-438200 Services & Charges-Debt Service- Interest 15,874 7,725 24,408 15,874 7,725 2,936 2,936 - 641-06-605-515-439001 Services & Charges-Other-Other Contractual Services 132,950 132,950 165,487 149,258 114,921 132,950 130,069 143,985 641-06-605-515-439004 Services & Charges-Other-Dues & Memberships 1,400 1,400 - 1,100 465 1,400 1,400 1,400 641-06-605-515-439005 Services & Charges-Other-Bank & Credit Card Fees - 1,300 - 1,564 2,570 1,500 2,100 1,625 641-06-605-515-439006 Services & Charges-Other-Education & Training 2,500 2,500 - 608 - 2,500 2,500 2,500 641-06-605-515-439011 Services & Charges-Other-Waste Removal/Disposal 40,000 40,000 9,009 10,261 4,731 40,000 40,000 43,320 641-06-605-515-439013 Services & Charges-Other-Closed Landfill Monitoring 27,350 27,350 2,350 32,957 5,875 27,350 70,463 29,620 641-06-605-515-439099 Services & Charges-Other-Cashier Over/Short - - - - 0 - - - 641-06-605-515-439999 Services & Charges-Other-Bad Debt Expense - - - 58 - - - - 641-06-605-515-452002 Other Uses-Interfund Transfer Out- Allocations-Admin Cost 63,701 80,526 56,806 63,701 80,526 79,193 79,193 73,501 641-06-605-515-452003 Other Uses-Interfund Transfer Out- Allocations-IT 43,523 35,594 63,403 43,523 35,594 54,990 54,990 51,897 641-06-605-515-452004 Other Uses-Interfund Transfer Out- Allocations-Liability Ins 37,141 6,080 1,430 37,141 6,080 5,524 5,524 8,799 641-06-605-515-452007 Other Uses-Interfund Transfer Out- Allocations-Central Stores - - 1,297 - - - - - 641-06-605-515-452008 Other Uses-Interfund Transfer Out- Allocations-Payroll Cost 29,239 29,209 28,434 29,239 29,209 30,939 30,939 32,111 641-06-605-515-452009 Other Uses-Interfund Transfer Out- Allocations-Facilities Mgt 308 364 - 308 364 358 358 348 642-06-602-509-442003 Capital Outlay-Infrastructure-Sewer Rehabilitation 6,250,000 2,000,000 852,921 1,568,388 777,100 2,000,000 2,576,961 2,000,000 642-06-602-509-443001 Capital Outlay-Buildings-Building Improvements - 250,000 - - - - - - 642-06-602-509-445000 Capital Outlay-Machinery & Equip- Motor Equipment 1,010,000 1,137,000 1,031,306 641,762 1,123,517 785,000 1,507,049 1,110,000 642-06-602-509-445008 Capital Outlay-Machinery & Equip- Other Equipment - - - - - 30,000 30,000 - 103 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 642-06-605-514-431002 Services & Charges-Professional- Engineering & Architectural - - - - - 2,400,000 2,400,000 1,500,000 642-06-605-514-439999 Services & Charges-Other-Bad Debt Expense - - - - (1,031) - - - 642-06-605-514-442005 Capital Outlay-Infrastructure- Treatment/Disposal Equipment - 1,250,000 3,246,778 1,539,405 3,368,097 5,000,000 7,142,353 29,100,000 642-06-605-514-445000 Capital Outlay-Machinery & Equip- Motor Equipment 386,000 1,208,000 275,566 391,895 74,198 - 48,042 45,000 642-06-605-514-445006 Capital Outlay-Machinery & Equip- Computer Equip/Network - - 15,200 - - - - - 642-06-605-514-445008 Capital Outlay-Machinery & Equip- Other Equipment 15,000 10,000 - 106,684 - - 211,065 30,000 642-06-605-515-445000 Capital Outlay-Machinery & Equip- Motor Equipment - - - - 696,500 340,000 690,878 350,000 642-06-605-515-445008 Capital Outlay-Machinery & Equip- Other Equipment - - - - 9,317 138,000 8,000 60,000 643-06-605-514-452000 Other Uses-Interfund Transfer Out- Transfers Out 120,000 75,112 127,330 71,004 32,719 - - - 649-06-605-514-438100 Services & Charges-Debt Service- Principal 5,900,000 5,995,000 5,931,732 11,716,557 20,236,844 8,699,185 8,699,185 7,460,066 649-06-605-514-438200 Services & Charges-Debt Service- Interest 1,654,328 1,468,184 1,841,612 1,751,393 1,616,812 2,374,904 2,374,904 2,308,281 649-06-605-514-438300 Services & Charges-Debt Service- Paying Agent Fees 5,000 5,000 2,950 3,325 2,400 5,000 5,000 5,000 649-06-605-514-438400 Services & Charges-Debt Service-Bond Issuance Costs - - - 193,896 160,537 - 28,000 - 649-06-605-514-452000 Other Uses-Interfund Transfer Out- Transfers Out - - - - 1,509,210 - - - 653-06-605-514-452000 Other Uses-Interfund Transfer Out- Transfers Out - - - 322,566 1,749,971 - - - 654-06-605-514-452000 Other Uses-Interfund Transfer Out- Transfers Out 25,000 5,578 - 6,318 4,446 - - - 655-06-602-508-410004 Personnel-Salaries & Wages-Extra & Overtime 20,160 20,160 792 - - 29,376 29,376 29,376 655-06-602-508-410005 Personnel-Salaries & Wages-Seasonal & Interns 53,760 53,760 60,606 56,338 40,726 53,760 53,760 53,760 655-06-602-508-411001 Personnel-Employee Benefits-FICA Regular 5,655 5,655 4,659 4,376 3,115 6,360 6,360 6,360 655-06-602-508-422000 Supplies-Operating-Other Operating Supplies 5,000 10,476 - 4,764 3,980 7,250 7,250 7,250 104 Account Main Account Description 2020 ADOPTED BUDGET 2021 ADOPTED BUDGET 2019 ACTUAL 2020 ACTUAL 2021 ACTUAL 2022 ORIGINAL BUDGET 2022 AMENDED BUDGET 2023 BUDGET 655-06-602-508-439999 Services & Charges-Other-Bad Debt Expense 6,500 6,500 3,419 2,634 1,793 6,500 - - 655-06-602-508-452000 Other Uses-Interfund Transfer Out- Transfers Out 300,000 500,000 550,000 300,000 500,000 300,000 300,000 300,000 655-06-602-508-452002 Other Uses-Interfund Transfer Out- Allocations-Admin Cost 26,235 21,077 24,367 26,235 21,077 33,528 33,528 21,919 655-06-602-508-452005 Other Uses-Interfund Transfer Out- Allocations-Utility Mgmt 16,150 16,659 15,876 16,150 16,659 12,934 12,934 14,320 655-06-602-508-490000 Bad Debt Expense - - - - - - 6,500 6,500 667-06-605-517-431000 Services & Charges-Professional-Other Professional Svcs - 200,000 54,500 11,045 8,958 200,000 390,657 300,000 667-06-605-517-431002 Services & Charges-Professional- Engineering & Architectural - - - 40 65,614 - 66,556 - 667-06-605-517-439999 Services & Charges-Other-Bad Debt Expense - - - 3,186 175 - - - 667-06-605-517-442002 Capital Outlay-Infrastructure-Sewers 825,000 824,000 275,886 90,050 436,855 824,000 1,814,243 1,150,000 750-06-602-503-445000 Capital Outlay-Machinery & Equip- Motor Equipment 754,960 - 587,884 95,914 - - - - 750-06-602-509-445000 Capital Outlay-Machinery & Equip- Motor Equipment - - - 57,680 - - - - 750-06-603-512-445000 Capital Outlay-Machinery & Equip- Motor Equipment 545,000 - 719,498 - - - - - 750-06-605-514-445000 Capital Outlay-Machinery & Equip- Motor Equipment - - - 101,400 - - - - 105