RecordWell Data

Cost Allocation & Enterprise Budgets Presentation(PDF, 6MB)

Richland County · Richland County · Budget documents

Open the original document More from Richland County

Text

Extracted automatically from the original. Tables and formatting may not survive; the original document is authoritative.

Richland County Government Cost Allocation & Enterprise Funds May 9, 2024 FY 2025 Richland County  Government • Cost Allocation Plan • Jim Hamilton –L B Owens Airport • Solid Waste • Utilities 2 Richland County Government Richland County  Government •What is a cost allocation plan? • A process to distribute County-wide administrative costs to enterprise and special revenue funds • Establishes an indirect cost rate, which can be charged to grants to recover administrative overhead costs • Standard practice among governmental organizations 4 Richland County  Government •Timeline of Cost Allocation Plan Implementation • County issued a request for proposals (RFP) for a third party to complete the cost allocation plan – Cherry Bekaert was selected • Cherry Bekaert worked with the County team to establish central vs receiving departments • Internal service departments were asked to provide allocation information based on personnel distribution, insurance claims, facilities metrics, financial transactions, technology support, etc. 5 Richland County  Government •Example: Allocation of Accounts Payable 6 Accounts Payable Countywide  payment of  invoices Total AP  Transactions  per  Department % of AP Costs Allocated  to Departments Richland County  Government ALLOCATING COSTS FROM CENTRAL SERVICES DEPARTMENTS TO RECEIVING DEPARTMENTS Internal Services Departments • County Administrator • Public Information • County Risk Management • County Ombudsman • Auditor • Budget • Finance • Procurement • Grants • Human Resources • Central Services • Information Te chn ology • Geographic Information System • Support Services • Facilities & Ground Maintenance Receiving Departments • Emergency Te le p hon e System • Fire Services • Stormwater • Conservation Commission • Neighborhood Redevelopment • Road Maintenance • Economic Development • Solid Waste • Utilities • Jim Hamilton –L B Owens Airport 7 Richland County  Government 8 Claimable To tals 12 0 5 - Emerg ency Telep ho ne System 1 206-Fi r e Ser vice 1 208- Stor m water Managem ent 1 209- Conservation Comm ission 12 10 - Nei gh bor h ood Redevelopm en t 12 16 - R o a d Maintenance 1 240- Eco no mic Development $ 1 , 1 2 0 , 6 1 9 $ 2 , 2 9 0 $ 5 , 7 2 5---- - $4 8 0,779 $7,779 $3 5,6 3 9 $3 ,6 56 $1 ,21 1 $1 ,3 77 $6 ,53 7 $1 ,79 9 $ 6, 5 84, 883 $ 3, 641 $ 48, 033 $ 8, 347 $ 426 $ 426 $ 93, 1 07 $ 9, 5 62 $ 891 , 939 $ 1 4, 431 $ 66, 1 1 8 $ 6, 7 83 $ 2, 247 $ 2, 5 5 4 $ 1 2, 1 28 $ 3, 338 $ 2, 072, 240 $33,5 28 $1 53,61 2 $ 1 5 ,7 58 $5 , 221 $ 5, 934 $ 28,1 77 $ 7, 7 54 $ 1 , 7 5 0, 1 67 $ 28, 31 7 $ 1 29, 7 37 $ 1 3, 309 $ 4, 409 $ 5 , 01 1 $ 23, 7 98 $ 6, 5 49 $ 1 , 363, 31 5 $ 22, 05 8 $ 1 01 , 060 $ 1 0, 367 $ 3, 435 $ 3, 904 $ 1 8, 5 37 $ 5 , 1 01 $ 928, 7 7 7 $ 1 5 , 027 $ 68, 849 $ 7 , 063 $ 2, 340 $ 2, 65 9 $ 1 2, 629 $ 3, 47 5 $ 1 , 7 62, 65 1 $ 1 1 , 946 $ 5 4, 283 $ 1 3, 5 46 $ 4, 01 8 $ 4, 5 37 $ 34, 848 $ 5 , 941 $ 7 40, 382 $ 428 $ 1 , 962 $ 9, 827 $ 4, 996 $ 1 , 85 4 $ 1 3, 45 5 $ 1 1 , 7 41 $ 4 0 3 , 0 3 0------ $ 3 2 , 4 2 8 $ 1 , 5 35 , 27 1 $ 5 , 240 $ 1 2, 226 $ 1 4, 846 $ 1 , 7 47 $ 1 , 7 47 $ 5 2, 398 $ 3, 493 $ 1 , 048, 1 07 $ 1 6, 95 8 $ 7 7 , 694 $ 7 , 97 0 $ 2, 641 $ 3, 001 $ 1 4, 25 1 $ 3, 922 $ 4, 45 4, 7 89 $ 4, 482 $ 1 0, 45 9 $ 1 2, 7 00 $ 2, 7 83 $ 1 , 494 $ 44, 825 $ 6, 85 4 $ 87 0, 892 $ 2, 5 43 $ 1 1 , 65 1 $ 7 3, 631 $ 396 $ 45 0 $ 2, 1 37 $ 1 9, 480 $ 247 , 1 7 7 $ 482 $ 1 , 7 42 $ 5 30 $ 242 $ 1 88 $ 1 , 809 $ 1 29 $ 5 , 446, 660 $ 5 , 924 $ 7 , 5 45 $ 1 3, 1 03 $ 1 0, 099 $ 5 , 95 7 $ 5 6, 327 $ 1 , 229 $ 31 , 7 01 , 67 8 $ 1 7 5 , 07 6 $ 7 86, 335 $ 21 1 , 436 $ 46, 209 $ 41 , 093 $ 41 4, 963 $ 1 22, 7 96 1 1 00-1 840-H u m an Resou rces 1 1 00-1 850-Central Services 1 1 00-1 870-I n form ati on Techn ol ogy 1 1 00-1 871 -Geographic I nformation Systems 1 1 00-3001 -Su pport Serv i ces 1 1 00-31 7 0-Fac& Gn d Mai n ten an ce Di v i si on Total Claimable Costs 1 1 00-1 61 5 -Cou n ty Ri sk Man agem en t 1 1 00-1 61 6-Cou n ty Om bu dsm an 1 1 00-1 635 -Cou n ty Attorn ey 1 1 00-1 7 20-Au di tor 1 1 00-1 7 30-T reasu rer 1 1 00-1 808-Bu dget Departm en t 1 1 00-1 809-Fi n an ce Departm en t 1 1 00-1 81 1 -Procurement Department 1 1 00-1 820-Gran ts Departm en t Departm ent 1 1 00-1 61 0-Cou n ty Adm i n i strator 110 0 - 16 11- P u b lic In f o r ma t io n Richland County  Government 9 Claimable To tals 21 01 -Sol i d Waste 21 1 0-Ri ch l a n d Cty Utilities 21 7 0-Ji m Ha mi l t o n- LB Owens Airpo rt $1,1 2 0 ,6 1 9 - $1 9 7,70 2 - $ 480, 7 7 9 $ 48, 349 $ 9, 390 $ 496 $ 6, 5 84, 883 $ 5 7 , 05 0 $ 235 , 602 $ 2, 5 7 6 $ 891 , 939 $ 89, 696 $ 1 7 , 420 $ 921 $2 ,0 72 ,2 4 0 $2 0 8 ,3 9 0 $4 0 ,4 72 $2 ,14 0 $1,750 ,16 7 $1 76 ,0 0 2 $3 4 ,18 2 $1 ,8 0 7 $ 1 , 363, 31 5 $ 1 37 , 099 $ 26, 626 $ 1 , 408 $9 2 8 ,777 $9 3 ,4 0 1 $1 8 ,14 0 $9 59 $1,76 2 ,6 51 $1 1 9 ,73 8 $4 1 4 ,6 6 4 $4 ,4 3 2 $ 740, 382 $1 08, 1 32 $83, 030 $ 8, 47 9 $ 403, 030 $ 1 3, 898 - $ 23, 1 63 $1,53 5,2 71 $4 0 ,172 $2 8 ,8 1 9 $8 73 $ 1 , 048, 1 07 $ 1 05 , 401 $ 20, 47 0 $ 1 , 082 $4,45 4, 789 $47, 680 $ 49, 565 $ 1 , 606 $8 70 ,8 9 2 $2 5,2 52 $9 1 ,3 1 1 $3 6 ,79 3 $2 4 7,1 77 $2 ,8 3 6 $7,9 6 8 $1 3 ,9 0 4 $5,4 4 6 ,6 6 0 $2 5,577 $2 8 8 ,6 3 1 - $ 31 , 7 01 , 67 8 $ 1 , 298, 67 1 $ 1 , 5 63, 991 $ 1 00, 639 1 1 00-1 840-H um an Resources 1 1 00-1 850-Cen tral Serv i ces 1 1 00-1 870-Information Technology 1 1 00-1 87 1 -Geograph i c I n form ati on Sy stem s 1 1 00-3001 -Support Servi ces 11 0 0 -3 1 70 -Fac& Gnd Maintenance Divisio n Total Claim able Costs 1 1 0 0-1 61 5-County Risk Manag ement 1 1 00-1 61 6-Cou n ty Om budsm an 11 0 0 -16 3 5-Co unty Atto rney 1 1 00-1 7 20-Audi tor 1 1 00-1 730-Treasurer 1 1 00-1 808-Budget Departm ent 1 1 00-1 809-Fi nance Departm ent 1 1 00-1 81 1 -Procu rem en t Departm en t 1 1 00-1 820-Gran ts Departm en t Department 11 0 0 -16 10 -Co unty Ad ministrato r 110 0 -16 11-Pub lic Info rmat io n Richland County  Government •Budgeted transfer from special revenue and enterprise funds to the general fund in FY2025 $4,761,209 10 Richland County  Government 11 Richland County  Government Lori Thomas, Assistant County Administrator (O) (803) 576‐2057 (M) (803) 331‐9100 Thomas.Lori@RichlandCountySC.Gov Maddison Wilkerson, Director of Budget (O) (803) 576‐2095 (M) (803) 977‐4365 Wilkerson.Maddison@RichlandCountySC.Gov 12 Richland County Government Richland County  Government  Facility Information  Airport Operations / Economic Impact  Airport Revenue  FY 25 Budget Highlights Richland County  Government • 182 Acres • 5,000 Ft. Asphalt Runway • 9 Acre Aircraft Apron • Up To 10 Small/ Medium Business Jets • Over 30 Parking Spots For Single Engine/Helicopters • 20,000 Gallon Aviation Fuel Storage Capacity • Automated Surface Observation System for “Realtime” weather reporting • 8,000 sq. ft. Terminal & Business Center • 11 Hangar Buildings, 200,000+ sq. ft. • Capable of basing over 100 aircraft Richland County  Government • Approx. 13,000 operations, to date • 108 Based Aircraft • 97 single engine • 6 multi-engine • 3 Jets • 2 helicopters • Annual economic impact -- $16,120,000 Richland County  Government • Fuel Sales stable • Ten year average = 186,670 gallons annual • Great potential for growth with new FBO • Current occupancy – 100 % full • Hangar lease revenue stable • Trending 91% lease revenue last 10 yrs. • FY25 Projected increase - >$80,000 Richland County  Government CATEGORY REMARKS AMOUNT REVENUE Potential Increase of 25 – 30% $474,078 PERSONNEL Includes Airport Mgr. full salary (previously split  with DPWA), Administrative Coordinator starting  Jan 2025  $212,871 OPERATIONS Costs kept within 3% increase cap $273,373  CAPITAL Includes 2 Capital Grant‐funded Projects $78,556 COST ALLOCATION Transfer to the general fund for internal services $100,639 TOTAL EXPENDITURES $665,439 Richland County Government Department of Public Works Division of Solid Waste and Recycling Richland County  Government •Collections • 8 Collections Contracts • 2 Commercial Contract • 1 Fleet System Contract • Customer Service Section •Construction & Demolition Materials Land Fill • 1 Grinding Contract • 1 Professional Services Contract •Landfill Closeout (Servicing 2 closed landfills) •Recycling Program/Drop-off Centers • 1 Hauling Contract • 5 Recycling Contracts • 2 Lease Agreements •Special Services • Roadside Litter Division • Refuse Control – Code Enforcement Division • Site Cleanup Division Richland County  Government •Management • 4 employees •Collections • 1 collections manager • 1 supervisor of collections • 4 customer service reps • 8 collections inspectors • 4 roll-cart technicians •Construction & Demolition Materials (C&D) Land Fill • 6 employees •Landfill Closeout (Servicing 2 closed landfills) • 1 employee •Recycling Program/Drop-off Centers • 1 coordinator • 3 lead drop-off center attendants • 4 drop-off center attendants, •Special Services • 19 employees Richland County  Government • Curbside Collections • $35,147,550/yr. (Curbside $22.68 - $29.00 per customer/month)(Backyard $40.82 - $52.20 per customer/month). Collections consist of 8 service areas distributed amongst 5 Contractors. • Landfill Millage • County C&D Landfill Operation - $3,461,939/yr. • County Recycling & Drop-off Centers Operation - $2,671,409/yr. • County C&D Landfill Closeout - $437,655/yr. • Management - $830,730/yr. • Special Services - $1,492,520/yr. Richland County  Government •All contracts use Consumer Price Index for rate adjustments • CY22 CPI was 7.0%, or a $2,500,000 increase in costs. • CY23 CPI was 6.4%, or a $2,300,000 increase in costs. • CY24 CPI was 3.4%, or a $1,200,000 increase in costs. Richland County  Government • Collection Area 1 (WM) 02/28/2025 • E-waste (PWR House) 06/30/2025 extendable • Hauling (Flash) 06/30/2025 extendable • Collection Area #5A (New South) 06/30/2025 • Collection Area #3 (CWS) 06/30/2025 • MSW Landfill (WM) 06/30/2025 • Collection Area 2 (GFL) 09/30/2025 • Collection Area 4 (GFL) 09/30/2025 • Collection Area 6 (New South) 09/30/2025 • MRF (Sonoco) 03/31/2026 • Collection Area #5B (Johnson) 12/31/2026 • Collection Area #7 (Johnson) 12/31/2026 • C&D Landfill (WM) 07/01/2027 • Liberty Tire 07/31/2027 • Indefinite Delivery • Nine Lives (Mattress Recycling) • EcoFlo (Household Liquids) Richland County  Government EXPENSES REVENUE Landfill Millage Curbside Collections $35,147,550 Exist. Mil/Rate Projected Mil County Program Management $830,730 Taxes $7,353,000 $7,565,600 Recycling Program $2,671,409 White Goods $378,000 $200,000 County Landfill $3,461,939 Tipping Fee $840,000 $850,000 Landfill Closure $437,655 Tire Revenue $273,000 $180,000 Special Services $1,492,520 Interest $100,000 130,000 Cost Allocation $1,570,881 Est  Revenue $8,944,000 $9,125,600 TOTAL Cost $45,612,681 ADJUSTMENT RATE/Mil Separate Curbside Program $36,401,191 Curbside  Revenue $34,756,995 $(1,644,196) 4.75 % Millage+FILO+Int Related Costs $9,211,492 Millage Revenue $9,125,600 $(85,892) Cap TOTAL $45,612,681 TOTAL $43,882,595 RESULT Balance Richland County  Government •Existing Collection Rates • Curbside Service = $368.10 • Backyard Service = $662.58 •Proposed Collection Rates • Curbside Service = $385.58 • Backyard Service = $694.05 •Existing Landfill Millage • 3.40 •Proposed Landfill Millage • Utilize the cap. Richland County  Government • Curbside Collection Fee- $ 368.10 (Current rate increased by 4.75%) $385.58 • Backyard Service-$ 694.05 (Proposed curbside rate x 1.8 as per ordinance) • Disability Backyard Service-$ 368.10 (Current rate increased by 4.75%) $385.58 • Commercial Curbside Service - $771.16 (Proposed curbside rate x 2.0 as per ordinance) • Rollcart Initial Setup Fee - $75.00 • C&D Disposal @ Richland County Landfill-$27.50 per ton (Waste must originate in RC) 4.75% increase • Yard/Land Clearing Debris/Dirt-$27.50 per ton • Brown Goods/Bulk Items-$27.50 per ton • Metal and Appliances-$27.50 per ton • Mattress/Box Spring – No Chargefor Richland County Residents (Limit 2 per day. Mattress + box spring are 1 ) Richland County  Government • Mattress/Box spring commercial - $352.00 per ton • Tires Commercial-$1.50 each or $150.00 per ton • Residential Tire with proper identification, No Charge (Limit 4 per day) • Residential Electronic Waste (Up to 5 electronic items per day) No Charge. • Commercial Electronic Waste, Landfill only - $1.10 per/lb. • Residential Mulch- County residents receive mulch at no charge. Resident self- load. Landfill only • Commercial Mulch-$14.00 per ton, Landfill only. • Residential Latex Paint, No Charge for Richland County residents. (Up to 5 cans of any size per day) • Commercial Latex Paint - $1.10 per/lb. Richland County  Government •Update on Automated collection trucks • Used by three contractors at this time •Drop Centers • Find Strategic Locations • Ability to take additional commodities • Enhance customer service with excellent facilities • Use state of the art compactors and roll-off containers • Plan for one new drop center for 2024 • Reduce Illegal Dumping Richland County  Government • Update the SWR Ordinance (completed) • Seek annual Council approval for the SWR Rates and Fees (underway) • New Contract Terms (completed) • New penalties based on the Hauler Report Card • Contract time from 5 year to 3 year with two one-year extensions • Eliminate rear load truck requirement • Eliminate fuel markup • Eliminated a poor performing contractor from a contract area. • Move contract area lines for poor performance (one occurred) Richland County Government 2024-2025 Budget Presentation May 9, 2024 Richland County  Government •General Information •Employee Awards and Recognition •Critical Objectives •Challenges for Sewer and Water •Organizational Changes •RCU Water System •RCU Water System History •RCU Sewer System •2024 Sewer Rate Study – Presented by Raftelis •Sewer and Water Financials Richland County  Government •Director: Bill Davis, PE (803) 771-1235 Cell davis.bill@richlandcountysc.gov •Deputy Director: Jani Hussain (803) 401-0045 hussain.tariq@richlandcountysc.gov •Manager of Administration (Business Services): Jessica Mancine (803) 401-0047 mancine.jessica@richlandcountysc.gov Richland County Government Utilities Richland County  Government •“An enterprise fund is a self-supporting government fund that sells goods and services to the public for a fee.” (www.accountingtools.com) •We periodically do a Rate Study to determine the appropriate rates for water and sewer services based on our expenses such as employee salaries, benefits, training and job related licensure, office space, supplies, vehicles, asset replacement/rehabilitation, operational costs, and maintenance costs. Richland County Government Confidential and Privileged Richland County  Government Northwest Southeast 2020 Hampton St. Eastover  WWTP Broad River  WWTP • Northwest Region Irmo - Sewer Chapin – Sewer Murray Point - Water • Southeast Region Town of Eastover – Sewer Lower Richland – Sewer Franklin Park – Sewer and Water Town of Hopkins – Water & Sewer Gadsden Elem/Hopkins MS/Hopkins Elem – Water and Sewer McEntire Joint National Guard Base – Sewer (entering agreement) Pond Drive - Water Richland County  Government Sahad Khilqa University of SC Professor Received Professional Engineer License Glemmie Haimes SC Environmental Conference & Operator Conference Speaker WEF Panel Speaker Bill Davis WEF House Speaker-Elect WEF Volunteer Service Award Texas Water Conference Board Speaker Selected as Midlands Workforce Pathway Planning Liaison Jani Hussain WEASC Safety Award WEASC Safety Committee Mike Teran WEASC Dennis Pittman Collection System Award District At-Large Committee Operators Conference Vice Chair of Program Committee District Arrangements Chair Richland County  Government • Provide Friendly Responsive Customer Service • Maintain a Culture of Inclusiveness and Diversity • Recruit and Retain High Performing Staff • Comply with Regulatory Agencies (SC DHEC) • Maintain our Delegated Review Program (DRP) • Follow our Code of Ordinances • Provide Competitive Wages for Our Staff • Provide Staff with Tools Needed for Success • Develop a Preventative Maintenance Program to Protect our Assets • Fully Assess Gravity Sewer System by 2030 • Maintain High Water Quality Standards • Strategic Planning with a 10 year Capital Improvement Program Richland County Government Utilities CRITICAL OBJECTIVES Richland County  Government • Complete Southeast Master Plan for Water • Get Approval of Completed Southeast Sewer Master Plan • Complete Northwest and North Master Plan • Enforce our FOG – Fat, Oil and Grease Ordinance • Limit new and find better solutions for Low Pressure Sewer Systems • Reduce Inflow and Infiltration (I&I) into our System • Prevent Sanitary Sewer Overflows (SSOs) • Maintain Robust Capacity Assurance Program (CAP) • Leverage our Industrial Pretreatment Program (IPP) • Continue to have a Strong Presence in Water Industry Associations and Organizations • Work with other Municipalities to require our review prior to approving new connections or change of use • Perform Cut-Offs for Non-Payment and Collect All Plan/Project Review Fees Richland County Government Utilities CRITICAL OBJECTIVES Richland County  Government • Construction Costs are 40% Higher than 2020 • Few Bidders on Construction Projects - Last Three Bids: One Bidder which was 175% Higher than Estimated Two Bidders Bidding - one within Budget & the other was Double One Bidder within Budget • Escalating Equipment and Chemical Costs • Short Life Expectancy for New Equipment • Aging Infrastructure • Workforce Compensation and Retention • New Indirect Cost Allocation • Balancing Rates and Affordability Richland County  Government Current Staffing Levels: Administration: 100% (5/5) Operations: 92% (11/12) Maintenance: 93% (13/14) Engineering: 100% (6/6) Overall: 95% (35/37) Richland County  Government • Add Engineering Technician • Consider adding a Part-Time (20hrs/wk) Wastewater Operator Richland County  Government Hopkins System  562+ Customers  Ground Water Source  300,000 Gallons Elevated Storage Tank Pond Drive  27 Customers  Ground Water Source  7,000 Gallon Hydropneumatic Storage Tank Murray Point  14 Customers  City of Columbia – Bulk Customer Richland County Government Utilities Richland County  Government •Ralph’s Mobile Home Park was in operation for 40 years and they filed for bankruptcy around 2003 •Richland County came to the aid of the citizens dependent on that well for drinking water •The System was in disrepair with no operation or maintenance •RCU engaged a local engineering firm, BP Barber, to design the new Pond Drive Water System •Cost for the System was $140,000 paid for by the State Budget and Control Board ($90,000) and Richland County Grants Administration Department ($40,000) Richland County  Government •Leaking fuel tanks from three former service station sites caused ground water contamination •Water system contamination dictated a need for new water supply system for the community •RCU again came to the aid of the community and worked with the School District to take over two wells and create the new Hopkins Water System •USDA Provided Funding for the System in conjunction with SCDHEC and EPA Richland County  Government •The Water System was deeded to the RCU in the 1980’s •In 2018 the well failed and we received assistance from the City of Columbia to provide water temporarily •We installed a metered connection and have been a bulk customer of the City of Columbia since then Richland County  Government •Initial Water Rate in 2009: $14 Base plus Usage ($3.80/1000 and up) •Increased Rates in 2014: $20 Base plus Usage by Tier (43% and 23%) •In-House Rate Study in 2023 Richland County  Government •Revenue has historically been less than actual expenses for the water system •Proposed Rate Increases for next two years as presented in 2023: 2024-2025 - 10% 2025-2026 - 10% •We anticipated reaching Breakeven by 2025- 2026 Richland County  Government •SEWER SYSTEMS*: Broad River Service Area  Regional WWTP - 6 MGD  13,233 Customer Equivalents  Blue Granite – Bulk Customer  46 Pump Stations  ~51000 liner feet of Gravity Pressure Lines  ~843,000 linear feet of Gravity Sewer Lines  ~324,000 linear feet of Forcemain  ~5000 Manholes Southeast Service Area  Regional WWTP – 1,200,000 GPD (upgrading to 2.5 MGD)  Lower Richland – 1,500+ Customers  ~ 84000 linear feet of Gravity Sewer Lines  ~ 242000 linear feet of Forcemain  16 Pump Stations  2,641 Customer Equivalents  Town of Eastover – Bulk Customer (~342 Customers/~11 Businesses)  KEMIRA Chemicals – Bulk Customer  McEntire and McCrady – Bulk Customers  Schneider Electric (Square D) – Bulk Customer Richland County Government Utilities Interesting Fact: We have about 292 total miles of  sewer lines. If you lay our pipe lines end to end  on the roadways, beginning in Irmo  South Carolina, you could almost  reach Birmingham Alabama *Updated in 2023 Richland County  Government •No Rate Increases from 2010 – 2018 •Increased Rates in 2019, 2021, and 2022 •No Rate Increase in 2023 •Our Current Sewer Rate: $72.03 Flat Rate per Residential Equivalent Unit (REU) Richland County  Government 51 Richland County Utilities Sewer Rate Study May 9th, 2024 Project Objectives • Financial Plan › Develop forecast of revenues and revenue requirements › Assess level of future increases › Build a financial planning model (Excel based) for use by staff • Rates › Evaluate effectiveness of existing rate structure 52 Key Assumptions – Revenue Requirements • Operating Expenses › FY 2024 Budget as baseline for forecast › 2.5% blended inflationary increases • Debt Service › 3 loans currently outstanding • Capital Improvement Plans (FY 25-29) › Total 5-year Spend: $75.2 Million ($15.0m per year) › $10M ARPA Grant › Major Projects: – Eastover WWTP Expansion – 24” Force Main › Includes 3% annual inflation factors 53 $28.9 $23.8 $12.6 $10.0 Capital Financing Sources ($M) PAYGO / Cash Bonds SRF Loans ARPA Grants Financial Forecast 54 FY 25 FY 26 FY 27 FY 28 FY 29 Annual Rate Increase 4.0% 4.0% 4.0% 4.0% 4.0% $0.0 $5.0 $10.0 $15.0 $20.0 $25.0 FY 2024 FY 2025 FY 2026 FY 2027 FY 2028 FY 2029 Millions Indirect Cost Allocation Rate Funded Capital (PAYGO) Proposed Debt Existing Debt O&M Expense Revenues @ Existing Rates Revenues @ Proposed Rates Key Financial Metrics 55 0.80x 1.00x 1.20x 1.40x 1.60x 1.80x 2.00x FY 2024 FY 2025 FY 2026 FY 2027 FY 2028 FY 2029 Total Debt Service Coverage Total DSC Minimum Target (1.50x) 0 200 400 600 800 1000 1200 1400 1600 1800 FY 2024 FY 2025 FY 2026 FY 2027 FY 2028 FY 2029 Days Cash on Hand Days Cash Minimum Target (365 Days) Debt Service Coverage measures ability to make required debt payments. Days Cash on Hand measures system liquidity (cash) available to meet obligations, represented in number of days. Sewer Bill Comparison (Residential - 5,000 gal/mo) 56 $83.99 $78.49 $74.91 $72.03 $72.01 $68.18 $66.37 $66.06 $51.06 $45.49 $43.47 $40.05 $37.58 $- $10 $20 $30 $40 $50 $60 $70 $80 $90 Charleston Chester County RCU - Proposed RCU - Existing Florence - Outside Columbia - Outside REWA + MetroConnects Camden - Outside Joint Municipal WSC Florence - Inside State Average Columbia - Inside Camden - Inside Contact: Will Kerr / 704 247 3231 / wkerr@raftelis.com 57 Thank you! Richland County  Government FY 2025 Admin FY  2025 Department Requested Expenditures Recommended  Total  Requested Total Increase Sewer Personnel $3,043,824.60 3,043,824.60                                   $0.00 Sewer Operating $4,795,893.00 4,795,893.00                                   $0.00 Debt Service* $3,682,963.00 3,682,963.00                                  $0.00 Sewer Capital $548,000.00 $1,569,207.00 $1,021,207.00 Sewer Indirect Cost Allocation $1,525,535.34 $1,525,535.34 $0.00 Add to Reserve $1,021,207.00 $0.00 ‐$1,021,207.00 From Reserve  for Pay as You Go Capital Projects 0 $10,000,000.00 $10,000,000.00 Water Personnel 147,889.00                                       147,889.00                                      $0.00 Water Operating 182,131.00                                       182,131.00                                      $0.00 Water Indirect Cost Allocation 38,455.66                                         38,455.66                                        $0.00 Water Capital $0.00 $25,000.00 $25,000.00 Total Expenditures $14,985,898.60 $25,010,898.60 $10,025,000.00 *This number will likely increase to cover the WWTP Expansion and 24" Forcemain FY 2025 Admin FY  2025 Department Projected Revenue Projected Projected Increase Sewer Rate Fees* $13,941,999.02 $13,941,999.02 $0.00 Sewer Tap Fees $809,761.14 $809,761.14 $0.00 Water Rate Fees** $234,138.36 $234,138.36 $0.00 Water Tap Fees $0.00 $30,000.00 $30,000.00 Transfer From Reserve  for Pay as You Go Capital Projects $0.00 $10,000,000.00 $10,000,000.00 Total Revenue $14,985,898.52 $25,015,898.52 $10,030,000.00 Surplus/Deficit ‐$0.08 $4,999.92 *4% Rate Increase **10% Rate Increase Richland County  Government

Source: Richland County website. First collected Oct 15, 2026.