RecordWell Data

FY 2022-23 Budget Summary

City of West Columbia · Lexington County · meeting of Aug 16, 2022 · Budget documents

Open the original document More from City of West Columbia

Text

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

MUNICIPAL BUDGET FISCAL YEAR 2022-2023 City of West Columbia South Carolina TABLE OF CONTENTS Section 1 ................................ T ransmittal Letter Section 2 ................................ Budget Summaries Section 3 ................................ Debt Service Schedule Section 4 ................................ Rate T ables and Fee Schedules Section 5 ................................ Capital Improvement Project Listings Section 6 ................................ State Health Plan Premiums Detail S E C T I O N 1 TRANSMITTAL LETTER June 7, 2022 To: Mayor and City Council From: Brian Carter, City Administrator Re: Budget Proposal for FY 20 22-2023 The operating budgets for Fiscal Year 2022-2023 are being submitted as you requested for the General Fund and Water/Sewer Fund. Highlights of the estimated revenues are as follows. These budgets include our general funding sources with funding from increases in revenue and lease purchase financing. The General Fund property tax revenue was estimated using 66.241 in operating mils and 6.6 in debt service mils. The proposed budget includes a projected 7.444 mil increase in operating millage. This is an estimated $650,000 increase in operating tax revenue that is directly related to expanding the availability of resources in police, sanitation, and other services. The 6.6 mils are collected and earmarked for the debt retirement of the 2020 General Obligation Bond. The overall increase in General Fund revenue over the prior year is $930,000. General Fund Revenue Source Amounts % of Total Property Taxes 7,500,000$ 35.7% Business License and Franchise Fees 5,750,000 27.4% State Rebates 615,000 2.9% Hydrant and Fire Protection Fees 1,017,600 4.8% Police Fines and Fees 129,000 0.6% Permits, Interest, Miscellaneous Revenue 670,500 3.2% Transfers from Other Funds (W/S & H-tax) 4,305,000 20.5% Anticipated Grant Funds / Program Income 126,500 0.6% Sale of Assets / Other Funding Sources 901,400 4.3% Total 21,015,000$ 100% Water / Sewer Fund Revenue Source Water and Sewer Service 20,300,000$ 93.7% Tap Fees and Penalties 800,000 3.7% Interest / Miscellaneous Revenue 162,000 0.7% Receivable - Joint Municipal Water and Sewer 388,000 1.8% Sale of Assets / Other Funding Sources 10,000 0.0% Total 21,660,000$ 100% Budget Transmittal Memorandum June 7, 2022 Page Two The Water/Sewer revenue was estimated using the rate ordinance approved in March 2018. The fee structures for water and sewer rates have been included. This budget also includes the continuation of the Quail Hollow Sewer System Surcharge. The recommended FY 2022-2023 transfer to the General Fund from the Water/Sewer Fund is $3,255,000 and is in accordance with the City’s financial policies. The City will borrow money to fund vehicle and equipment requests in the General Fund through lease purchase financing. The total of these requests is $745,000. The Water/Sewer Fund equipment requests included are funded without the need for additional debt service. Requested Budget Items: The requested budget plan includes funding for up to a 3% merit pay increase for employees to be awarded on employees’ employment anniversary dates, subject to a satisfactory performance evaluation. Also included in the budget plan is a 1% across the board cost-of-living increase for all employees to be awarded July 1, 2022, as well as a 1% across the board cost-of-living bonus for all employees to be paid in July 2022. The cost of these increases is $410,000 for General Fund and $205,000 for Water/Sewer Fund. In response to legislation impacting the state’s pension systems, we have budgeted a 1% increase for employer contributions to SCRS and PORS. This represents an overall increase of $130,000 for required employer contributions. Only the state legislature has the authority to set employee or employer contribution rates; therefore, the city does not have the ability to change the amount of the employer’s contribution. This increase impacts the general fund and the water/sewer fund. The City has been a part of the S.C. State Health Insurance Plan since July 1, 2011, which is in the Blue Cross/Blue Shield network. The summary below is for the projected coverages under the State’s standard plan. Annual Deductible: $490 Individual / $980 Family In-network Co-insurance: 80/20 Out of network Co-insurance: 60/40 Per Occurrence Deductible: $14 Office Visit Network Retail Pharmacy: $9 Generic / $42 Preferred / $70 Non-Preferred This calendar year’s premiums under the State Health Plan are projected with an increase of 18.1% in the employer’s portion, as well as a 19% increase due to the City’s experience rating. As it has done in the past, I recommend that the City continue to pay the employees’ part of the monthly premium for health insurance and that cost has been included in this budget. There is a slight increase in the amount employees pay towards the premium due to the experience rating. The City’s total cost for health insurance premiums for fiscal year 2022-2023 is estimated at $2,570,000. This represents a City-wide increase of $730,000 over the prior year. Budget Transmittal Memorandum June 7, 2022 Page Three Requested Budget Items (continued): The projected cost of fleet insurance, property, and tort liability insurance is provided through SCMIRF. The premium for this coverage is $424,700. The South Carolina Municipal Insurance Trust is the provider for the City’s workers compensation coverage. The premium for workers compensation coverage is based upon claims and safety experience and is indexed to salaries. The City’s projected premium for workers compensation coverage is approximately $287,500 for FY 2022-2023. In an exchange for a reduction in premium, we kept the same deductibles to be paid upon each claim filed. Deductibles are allocated to departments, which will assist with tracking losses and claims per department. Departmental line-item budget requests including equipment/debt service are attached for your review. These requests total $21,015,000 for the General Fund and $21,660,000 for the Water/Sewer Fund. The General Fund budget includes a new Code Compliance Inspector for Code Enforcement, two new Dispatchers for the Police Department, a new Truck Driver and Equipment Operator III for the Sanitation Department, two new Equipment Operators for the Parks Department, a new Mechanic position for the Maintenance Shop, and a new Permit/Plan Reviewer position for Planning and Zoning. All these positions are in line with Council’s Goals and Priorities and/or Efficiency Study recommendations. The Water/Sewer Fund budget includes two new Equipment Operators for the Water Department and a new Sewer Program Technician for the Sewer Department. The City’s 10-year Capital Improvement Plans for both the General Fund and Water/Sewer Fund are included in Section 5. The Special Revenue Fund budget includes Hospitality Tax funding and expenditures in the amount of $2,200,000. A table showing FY 2022-2023 amounts is included in Section 2. Other proposed expenditures included in the budget, which I have noted for your information are: Membership – The River Alliance $ 12,500 Dues to Central Midlands Council of Governments 11,500 Contribution to Boys State and Girls State 2,500 Contribution to the West Metro Visitors’ Center (A-Tax Funds) 35,000 Contribution to Midlands Housing Authority – Transitions Shelter 17,000 Contribution to Riverkeeper 10,000 Contribution to Pawmetto Lifeline for Animal Services 25,000 Debt Service – TIF Bond 629,500 Debt Service – GO Bond 432,000 Columbia Sewer Treatment Costs 945,000 Bonded Debt Service - Water and Sewer Fund 3,958,000 S E C T I O N 2 BUDGET SUMMARIES Revenue Type FY 2023 Amounts Property Taxes 7,500,000$ Business License and Franchise Fees 5,750,000 State Rebates 615,000 Hydrant and Fire Protection Fees 1,017,600 Police Fines and Fees 129,000 Permits, Interest, Miscellaneous Revenue 670,500 Transfers from Other Funds (W/S & H-tax) 4,305,000 Anticipated Grant Funds / Program Income 126,500 Sale of Assets / Other Funding Sources 901,400 Total 21,015,000$ Department FY 2023 Requests Mayor and Council 312,900$ Inspection Division 306,300 Codes Compliance 385,200 Administration 2,138,400 Court Administration 386,900 Information Technology 490,800 Community & Economic Development 203,200 Police Administration 5,059,300 Detective Division 1,428,900 Dispatch 487,900 Victims Advocate / Victims Services 113,000 Animal Control 89,500 School Resource Officers 216,300 Police Other 16,500 Fire Department 3,229,400 Street Department 631,600 Sanitation Department 2,398,700 Maintenance Shop 738,500 Parks Department 1,320,200 Transfer to Debt Retirement 1,061,500 Total 21,015,000$ City of West Columbia Summary of Budget FY 2022-2023 General Fund - Expenditures General Fund - Revenues City of West Columbia Summary of Budget FY 2022-2023 Revenue Type FY 2023 Amounts Water and Sewer Service 20,300,000$ Tap Fees and Penalties 800,000 Interest / Miscellaneous Revenue 162,000 Receivable - Joint Municipal Water and Sewer 388,000 Sale of Assets / Other Funding Sources 10,000 Total 21,660,000$ Department FY 2023 Requests Water / Sewer Administration 1,561,200$ Water Plant #1 1,738,400 Water Plant #2 5,203,600 Water Distribution 1,804,600 Sewer Collection 2,239,900 Water Billing and Collection 791,500 Information Technology 371,000 Water / Sewer Mayor and Council 167,900 Water / Sewer Maintenance Shop 369,500 Contribution to General Fund 3,255,000 Transfer to Reserve Fund 200,000 Transfer to Debt Retirement 3,957,400 Total 21,660,000$ Water and Sewer Fund - Expenditures Water and Sewer Fund - Revenues City of West Columbia Summary of Budget FY 2022-2023 Revenue Type FY 2023 Amounts Hospitality Tax Revenues 2,200,000$ Total 2,200,000$ Expenditure Category FY 2023 Requests Festivals and Events 220,000$ Other Professional Services and Promotion 50,000 Debt Service - New Bond Issue 460,000 Contribution to General Fund - Tourism Related Event Management 175,000 Parks Operations and Maintenance 875,000 Christmas and Production Improvements 105,000 Other Projects and Improvements 315,000 Total 2,200,000$ Special Revenue (HTax) Fund - Revenues Special Revenue (HTax) Fund - Expenditures S E C T I O N 3 DEBT SERVICE SCHEDULE CITY OF WEST COLUMBIA DEBT SERVICE SCHEDULE FISCAL YEAR 2022/2023 Payment Grand Date Principal Interest Total Principal Interest Total Total GENERAL FUND Lease-Purchase - CresCom ($1M) 9/1/2022 5 of 7 145,282 8,100 153,382 Police Department 25% 36,321 2,025 38,346 38,346 Fire Department 5% 7,264 405 7,669 7,669 Sanitation Department 20% 29,056 1,620 30,676 30,676 72,641 4,050 76,691 76,691 Lease-Purchase - BB&T ($870,000) 11/24/2022 6 of 7 128,791 4,757 133,548 Police Department 18% 23,182 856 24,039 24,039 Fire Department 7% 9,015 333 9,348 9,348 Street Department 4% 5,152 190 5,342 5,342 Sanitation Department 65% 83,714 3,092 86,806 86,806 Parks Department 6% 7,727 285 8,013 8,013 128,791 4,757 133,548 133,548 GO Bond 2020 9/1/2022 3 of 10 - 18,993 18,993 18,993 3/1/2023 3 of 10 394,000 18,993 412,993 412,993 394,000 37,986 431,986 431,986 TIF Bond 2016 9/1/2022 6 of 11 - 49,227 49,227 49,227 3/1/2023 7 of 12 531,000 49,227 580,227 580,227 531,000 98,454 629,454 629,454 Total:General Fund 1,126,432 145,247 1,271,679 1,271,679 City of West Columbia CITY OF WEST COLUMBIA DEBT SERVICE SCHEDULE FISCAL YEAR 2022/2023 Payment Grand Date Principal Interest Total Principal Interest Total Total City of West Columbia PROPRIETARY FUND Lease-Purchase - CresCom ($1M) 9/1/2022 4 of 7 145,282 8,100 153,382 Water Distribution 50% 72,641 4,050 76,691 76,691 72,641 4,050 76,691 76,691 2020 Bond Issue 12/1/2022 - 53,492 53,492 53,492 (2009A/B Refunding) 6/1/2023 1,022,000 53,492 1,075,492 1,075,492 Total - 2020 1,022,000 106,984 1,128,984 1,128,984 2018 Bond Issue 12/1/2022 - 296,494 296,494 296,494 W/S System Imprvs 6/1/2023 420,000 296,494 716,494 716,494 Total - 2018 420,000 592,988 1,012,988 1,012,988 2016 Bond Issue 12/1/2022 - 175,427 175,427 175,427 W/S System Imprvs 6/1/2023 685,000 175,427 860,427 860,427 Total - 2016 685,000 350,854 1,035,854 1,035,854 SRF 2005 Bond Issue 9/1/2022 96,243 8,448 104,691 82,920 7,279 90,199 194,890 JMWSC 53.718% 12/1/2022 96,784 7,907 104,690 83,386 6,812 90,199 194,889 3/1/2023 97,328 7,363 104,691 83,856 6,343 90,199 194,890 6/1/2023 97,876 6,815 104,690 84,327 5,871 90,199 194,889 388,231 30,532 418,763 334,489 26,306 360,795 779,558 Total:Proprietary Fund 388,231 30,532 418,763 2,534,130 1,081,182 3,615,312 4,034,075 JMW&SC Total - 2005 SRF CITY OF WEST COLUMBIA DEBT SERVICE SCHEDULE FISCAL YEAR 2022/2023 Payment Grand Date Principal Interest Total Principal Interest Total Total City of West Columbia SPECIAL REVENUE FUND HTAX Bond 2018 12/1/2022 5 of 10 - 31,360 31,360 31,360 6/1/2023 5 of 10 396,000 31,360 427,360 427,360 396,000 62,720 458,720 458,720 Total:Special Rev Fund 396,000 62,720 458,720 458,720 Total:All Funds 388,231 30,532 418,763 4,056,562 1,289,149 5,345,711 5,764,474 CITY OF WEST COLUMBIA DEBT SERVICE SCHEDULE FISCAL YEAR 2022/2023 Payment Grand Date Principal Interest Total Principal Interest Total Total City of West Columbia Budget - Account Numbers 10-30-3001-093 925,000 136,440 1,061,440 1,061,440 10-41-4101-100 59,503 2,881 62,384 62,384 10-46-4601-100 16,279 738 17,017 17,017 10-51-5101-100 5,152 190 5,342 5,342 10-52-5201-100 112,771 4,712 117,483 117,483 10-54-5401-100 7,727 285 8,013 8,013 30-92-9201-100 72,641 4,050 76,691 76,691 30-94-9401-031 2,849,720 1,107,664 3,957,384 3,957,384 70-71-7100-100 396,000 62,720 458,720 458,720 Total:All Funds 4,444,793 1,319,681 5,764,474 5,764,474 S E C T I O N 4 RATE TABLES AND FEE SCHEDULES These following rates are used to calculate bills for water consumption and sewer usage. Most residential customers are billed bi-monthly (every other month). Inside City Limits Outside City Limits Usage in Gallons Current Residential Current Residential Up to 6,000 gallons $33.70 $67.40 (minimum billing) + $2.00 Surcharge + $10.00 Hydrant Fee Uniform Rate 3.20 6.40 (per 1,000 gallons) Inside City Limits Outside City Limits Usage in Gallons Current Residential Current Residential Up to 6,000 gallons $33.70 $67.40 (minimum billing) Uniform Rate (per 1,000 gallons) 3.10 6.20 City of West Columbia Residential - Water and Sewer Service Bi-Monthly Rates FY 2022 - 2023 Residential Water ONLY Service Rates Residential Sewer ONLY Service Rates These following rates are used to calculate bills for water consumption and sewer usage. Most residential customers are billed bi-monthly (every other month). Inside City Limits Outside City Limits Usage in Gallons Current Residential Current Residential Up to 6,000 gallons $25.50 $51.00 (minimum billing) + $2.00 Surcharge + $10.00 Hydrant Fee Uniform Rate 3.20 6.40 (per 1,000 gallons) Inside City Limits Outside City Limits Usage in Gallons Current Residential Current Residential Up to 6,000 gallons $25.50 $51.00 (minimum billing) Uniform Rate 3.10 6.20 (per 1,000 gallons) Inside City Limits Outside City Limits Current Minimum Current Minimum Up to 6,000 gallons $51.00 $102.00 (minimum billing) + $2.00 Surcharge + $10.00 Hydrant Fee Uniform Rate 6.30 12.60 (per 1,000 gallons) Combined Residential Water and Sewer Service Rates City of West Columbia Combined Residential - Water and Sewer Service Bi-Monthly Rates FY 2022 - 2023 Combined Residential Water Service Rates Combined Residential Sewer Service Rates These following rates are used to calculate bills for water consumption and sewer usage. Most commercial customers are billed bi-monthly (every other month). Inside City Limits Outside City Limits Base Charge Current Commercial Current Commercial (no consumption) 3/4" Meter $17.00 $34.00 1" Meter $42.00 $84.00 1 1/2" Meter $85.00 $170.00 2" Meter $135.00 $270.00 3" Meter $270.00 $540.00 4" Meter $422.00 $844.00 6" Meter $843.00 $1,686.00 8" Meter $1,348.00 $2,696.00 + $2.00 Surcharge + $10.00 Hydrant Fee Uniform Rate 3.55 7.10 (per 1,000 gallons) Inside City Limits Outside City Limits Base Charge Current Commercial Current Commercial (no consumption) 3/4" Meter $17.00 $34.00 1" Meter $42.00 $84.00 1 1/2" Meter $85.00 $170.00 2" Meter $135.00 $270.00 3" Meter $270.00 $540.00 4" Meter $422.00 $844.00 6" Meter $843.00 $1,686.00 8" Meter $1,348.00 $2,696.00 Uniform Rate 4.00 8.00 (per 1,000 gallons) City of West Columbia Commercial - Water and Sewer Service Bi-Monthly Rates FY 2022 - 2023 Commercial Water Service Rates Commercial Sewer Service Rates These following rates are used to calculate bills for water consumption and sewer usage. Most commercial customers are billed bi-monthly (every other month). Inside City Limits Outside City Limits Base Charge Current Commercial Current Commercial (no consumption) 3/4" Meter $8.50 $17.00 1" Meter $21.00 $42.00 1 1/2" Meter $42.50 $85.00 2" Meter $67.50 $135.00 3" Meter $135.00 $270.00 4" Meter $211.00 $422.00 6" Meter $421.50 $843.00 8" Meter $674.00 $1,348.00 + $1.00 Surcharge + $5.00 Hydrant Fee Uniform Rate 3.55 7.10 (per 1,000 gallons) Inside City Limits Outside City Limits Base Charge Current Commercial Current Commercial (no consumption) 3/4" Meter $8.50 $17.00 1" Meter $21.00 $42.00 1 1/2" Meter $42.50 $85.00 2" Meter $67.50 $135.00 3" Meter $135.00 $270.00 4" Meter $211.00 $422.00 6" Meter $421.50 $843.00 8" Meter $674.00 $1,348.00 Uniform Rate 4.00 8.00 (per 1,000 gallons) City of West Columbia Commercial - Water and Sewer Service Monthly Rates FY 2022 - 2023 Commercial Water Service Rates Commercial Sewer Service Rates Tap Fees Inside City Limits Outside City Limits 3/4 - inch $400 $800 Residential only Capacity Fees Inside City Limits Outside City Limits 3/4 - inch $600 $1,200 1 - inch $1,500 $3,000 1 1/2 - inch $3,000 $6,000 2 - inch compound $4,800 $9,600 3 - inch compound $9,600 $19,200 4 - inch compound $15,000 $30,000 6 - inch compound $30,000 $60,000 8 - inch compound $48,000 $96,000 Tap Fees Inside City Limits Outside City Limits 3/4 - inch $250 $500 Residential only Capacity Fees Inside City Limits Outside City Limits Residential $1,250 $2,500 Commercial $1,500 $3,000 Tap Fees Inside City Limits Outside City Limits 6 - inch line $4,000 $8,000 8 - inch line $8,000 $16,000 10 - inch line $12,000 $24,000 12 - inch line $16,000 $32,000 Fire Line Service Fees City of West Columbia All other tap sizes are at cost to be determined by the City. Sewer Capacity Fees are measured per residential equivalency unit of 300 GPD All service fees are subject to change based on use, demand and residential equivalency unit measurement. (Meter Replacements should follow this same fee calculation.) Water and Sewer Service Fees FY 2022 - 2023 Water Service Fees Sewer Service Fees All other tap sizes are at cost to be determined by the City. Late Fee 10% of bill, with a minimum of $5 After Hours Fee $45 Disconnect Fee $40 Locked Meter Fee $50 Pulled Meter Fee $60 Charge to Replace Cut Meter Lock $25 Miscellaneous Account Fees Owner Renter Owner Renter 3/4" Residential Only 40.00$ 100.00$ 80.00$ 100.00$ Meter Size Inside Outside 3/4" 50.00$ 100.00$ 1" 125.00$ 250.00$ 1.5" 250.00$ 500.00$ 2" 400.00$ 800.00$ 3" (Compound) 800.00$ 1,600.00$ 4" (Compound) 1,250.00$ 2,500.00$ 6" (Compound) 2,500.00$ 5,000.00$ 8" (Compound) 4,000.00$ 8,000.00$ Commercial Deposit Fees Residential Deposit Fees Residential Deposit Fees Inside City Outside City Commercial Deposit Fees S E C T I O N 5 CAPITAL IMPROVEMENT PROJECT LISTINGS Information Technology (split) --- PD - MDTs w/mounting (18) 85,000$ --- Replacement PCs 7,200 --- HP Rack Mounted Server Core 5,000 --- IP Camera Replacements for existing analog cameras 11,200 --- Incode 10 Upgrade Software 32,000 Police Department --- Radio Replacements 48,000 --- CAT Team SUV Replacement 42,200 --- New SRO Vehicle 37,000 Sanitation --- Purchase 400 each of household and recycling roll carts 60,000 --- New One-Arm Bandit Truck 322,000 --- Purchase (2) two roll-off containers 15,000 --- Replace (810) w/ new f650 Switch-and-Go 75,000 Parks --- Replace (1025) SCAG 2014 11,000 --- New F550 Flat Bed Truck 75,000 --- Replace (704) F150 Truck 30,000 Maintenance Shop (split) --- RAM 1500 Quad Cab Truck 20,000 --- Replace Shop Welder 2,800 --- New A/C Machine 3,300 --- Crane for Shop Truck 10,500 --- Large Bay for large trucks 300,000 FY 2022-2023 (Year 1) Totals 1,192,200$ City of West Columbia General Fund New 10 - YEAR CIP - Updated 05.15.2022 FY 2022-2023 Budget Year - Year 1 Page 1 of 10 City of West Columbia General Fund New 10 - YEAR CIP - Updated 05.15.2022 Information Technology (split) --- Replacement PCs for PCs over 5 years old 4,600$ --- HP Switch Upgrade - City Hall/PD 6,100 --- IP Camera Replacements for existing analog cameras 11,200 Police Department --- 4 Patrol Vehicles 212,000 --- 1 Investigations Vehicles 40,000 --- 10 Radio Replacements 48,000 --- 8 SORT Team Vest Replacements 15,000 Fire Department --- 100' Tractor Drawn Aerial Truck (replace Tower 2 - 2006) w/ equipment 1,860,000 --- Renovation of bathroom/shower and front restrooms 50,000 --- Training Facility with concrete foundation (Connex boxes) 150,000 --- Pickup replace Marshal 2 (2012) with equipment 55,000 --- Class A Pumper replace Engine 5 (1995) with new pumper and equipment 800,000 --- Side by Side UTV with stokes basket for rescue and medical at events 40,000 Streets --- Upgrades to the Public Works facility – Sheds, Asphalt, & Drainage 280,000 Sanitation --- Purchase 300 each of household and recycling roll carts 46,000 Parks --- Replace (1024) w/ new Kubota 20,000 --- Replace (1037) w/ new SCAG 12,000 Maintenance Shop (split) --- Replace Vehicle (5301-905) 2009 Ford F350 (Service Truck) 45,000 --- Replace Roll-up Bay Doors 20,000 FY 2023-2024 (Year 2) Totals 3,714,900$ FY 2023-2024 Budget Year - Year 2 Page 2 of 10 City of West Columbia General Fund New 10 - YEAR CIP - Updated 05.15.2022 Information Technology (split) --- Replacement PCs for PCs over 5 years old 4,600$ --- Sonicwall Firewall - City Hall 2,800 --- IP Camera Replacements for existing analog cameras 11,200 Police Department --- 4 Patrol Vehicles 212,000 --- 1 Investigations Vehicles 40,000 --- 10 Radio Replacements 48,000 --- Narcotics Surveillance Equipment 9,000 Fire Department --- New Station 2 Construction located on property at Leaphart Rd 6,000,000 --- New Class A Fire Engine with equipment for Station 2 825,000 --- SUV replace Marshal 1 (2014) with equipment 55,000 Sanitation --- Sell and Replace (813) w/ a new 25 yard packer 195,000 --- Sell and Replace (719) w/ one Knuckle boom 285,000 --- Sell and Replace (716) Flatbed w/ a new Flatbed 80,000 --- Purchase 300 each of household and recycling roll carts 46,000 Parks --- Replace (1038) w/ new SCAG 12,000 --- Replace (1034) w/ new F-450 Switch and Go w/ Landscape body 65,000 --- Replace (1033) w/ new F-250 Crew Cab 40,000 --- Replace (1026) w/ new F-250 w/ utility boxes 40,000 Maintenance Shop (split) --- Replace metal siding and insulation on Maint Shop building 25,000 --- Replace Vehicle (5301-912) 2007 Chevrolet 2500 20,000 FY 2024-2025 (Year 3) Totals 8,015,600$ FY 2024-2025 Budget Year - Year 3 Page 3 of 10 City of West Columbia General Fund New 10 - YEAR CIP - Updated 05.15.2022 Information Technology (split) --- Replacement PCs for PCs over 5 years old 4,600$ --- Citywide InDesign - Website upgrade 4,000 --- Upgrade backup appliance at City Hall 21,000 --- IP Camera Replacements for existing analog cameras 11,200 Police Department --- 4 Patrol Vehicles 212,000 --- 1 Investigations Vehicles 40,000 --- 10 Radio Replacements 48,000 --- Speed Trailer 9,000 Sanitation --- Sell and Replace (818) pull behind leaf machine 50,000 --- Sell and Replace (817) w/ a new 8 yard packer 150,000 --- Purchase 300 each of household and recycling roll carts 46,000 Parks --- Replace (1020) Kubota for Riverwalk 20,000 --- Replace (1002) w/ a new F-550 Switch and Go 70,000 Maintenance Shop (split) --- Replace Lift for Heavy Duty Trucks 50,000 --- Replace Vehicle (5301-811) 2013 Ford F150 20,000 FY 2025-2026 (Year 4) Totals 755,800$ FY 2025-2026 Budget Year - Year 4 Page 4 of 10 City of West Columbia General Fund New 10 - YEAR CIP - Updated 05.15.2022 Information Technology (split) --- Replacement PCs for PCs over 5 years old 4,600$ --- IP Camera Replacements for existing analog cameras 11,200 Police Department --- 4 Patrol Vehicles 212,000 --- 1 Investigations Vehicles 40,000 Fire Department --- Class A Pumper replace Engine 4 (2000) with new pumper and equipment 850,000 --- SUV replace Fire 2 (2017) with equipment 60,000 Sanitation --- Sell and Replace (805) w/ a new 30 yard packer 200,000 --- Sell and Replace (703) w/ a new F-250 crew cab 40,000 --- Sell and Replace (801) w/ a new F-250 Scout 40,000 --- Purchase 300 each of household and recycling roll carts 46,000 Parks --- Replace (1029) w/ New F350 Dump Truck 45,000 --- Replace (1027) w/ New F250 Utility Truck 40,000 --- Replace (1005) w/ New F250 35,000 --- Replace (1006) w/ New F250 35,000 Maintenance Shop (split) --- Replace Vehicle Lifts 17,500 FY 2026-2027 (Year 5) Totals 1,676,300$ FY 2026-2027 Budget Year - Year 5 Page 5 of 10 City of West Columbia General Fund New 10 - YEAR CIP - Updated 05.15.2022 Information Technology (split) --- Replacement PCs for PCs over 5 years old 4,600$ --- IP Camera Replacements for existing analog cameras 11,200 Police Department --- 4 Patrol Vehicles 212,000 --- 1 Investigations Vehicles 40,000 Fire Department --- SUV replace Battalion (2018) with equipment 60,000 Sanitation --- Sell and Replace (803) w/ a new 25 yard packer 195,000 --- Purchase 300 each of household and recycling roll carts 46,000 Parks --- Replace (1044) w/ a new CAT Skid Steer 75,000 Maintenance Shop (split) --- Replace Shop Air Compressor 12,500 FY 2027-2028 (Year 6) Totals 656,300$ FY 2027-2028 Budget Year - Year 6 Page 6 of 10 City of West Columbia General Fund New 10 - YEAR CIP - Updated 05.15.2022 Information Technology (split) --- Replacement PCs for PCs over 5 years old 4,600$ --- Sonicwall Firewall - City Hall 2,800 --- IP Camera Replacements for existing analog cameras 11,200 Police Department --- 4 Patrol Vehicles 212,000 --- 1 Investigations Vehicles 40,000 --- 1 Polaris ATV 18,000 --- Dispatch equipment upgrade and possible software upgrade 175,000 Fire Department --- SUV replace Fire 1 (2019) with equipment 60,000 Sanitation --- Sell and Replace (816) w/ a new CAT Tink Claw loader 150,000 --- Purchase 300 each of household and recycling roll carts 46,000 Parks --- Replace bucket truck purchased in 2019-20 130,000 --- Replace SCAG purchased in 2019-20 12,000 Maintenance Shop (split) --- Replace HVAC Systems 22,500 FY 2028-2029 (Year 7) Totals 884,100$ FY 2028-2029 Budget Year - Year 7 Page 7 of 10 City of West Columbia General Fund New 10 - YEAR CIP - Updated 05.15.2022 Information Technology (split) --- HP Rack Mounted Server Core 3,000$ --- Replacement PCs for PCs over 5 years old 4,600 --- IP Camera Replacements for existing analog cameras 11,200 Police Department --- 4 Patrol Vehicles 212,000 --- 1 Investigations Vehicles 40,000 --- 8 SORT Team Vests 15,000 Sanitation --- Sell and Replace (804) one arm bandit w/ new 280,000 --- Purchase 300 each of household and recycling roll carts 46,000 Parks --- Replace SCAGs purchased in 2021 and 2022 24,000 --- Replace F550 Switch and Go purchased in 2021-22 80,000 Maintenance Shop (split) --- Replace roof on Maintenance Building 20,000 FY 2029-2030 (Year 8) Totals 735,800$ FY 2029-2030 Budget Year - Year 8 Page 8 of 10 City of West Columbia General Fund New 10 - YEAR CIP - Updated 05.15.2022 Information Technology (split) --- Replacement PCs for PCs over 5 years old 4,600$ Police Department --- 4 Patrol Vehicles 212,000 --- 1 Investigations Vehicles 40,000 Sanitation --- Sell and Replace CAT Tink Claw loader purchased in 2019-20 150,000 --- Sell and Replace F-550 Switch and Go purchased in 2019-20 65,000 --- Purchase 300 each of household and recycling roll carts 46,000 Parks --- Replace F150 purchased in 2022-23 30,000 --- Replace Landscape switch and go purchased in 2020-21 70,000 Maintenance Shop (split) --- New Tire Machine and Balancer 15,000 FY 2030-2031 (Year 9) Totals 632,600$ FY 2030-2031 Budget Year - Year 9 Page 9 of 10 City of West Columbia General Fund New 10 - YEAR CIP - Updated 05.15.2022 Information Technology (split) --- Replacement PCs for PCs over 5 years old 4,600$ Police Department --- 5 Patrol Vehicles 265,000 --- 1 Investigations Vehicles 40,000 Sanitation --- Sell and Replace 30 yard packer purchased in 2022-23 220,000 --- Sell and Replace Scout from 2020-21 purchase 30,000 --- Purchase 300 each of household and recycling roll carts 46,000 Parks --- Replace Sweeper puchased in 2022-23 315,000 --- Replace SCAG purchased in 2022-23 15,000 Maintenance Shop (split) --- Replace Brake Lathe 3,800 FY 2031-2032 (Year 10) Totals 939,400$ Projected Totals for next 10 years of CIP. 19,203,000$ FY 2031-2032 Budget Year - Year 10 Page 10 of 10 Plant 2 --- Improvements to the Lake Murray Water Treatment Plant (Engineering) 3,200,000$ --- High Service No. 1 VFD Conversion 85,000 Plant 1 --- Rehabilitate Filter No. 6 295,000 --- SCADA Server Upgrades 12,000 --- Bulk Alum Storage 50,000 Water --- Saluda Gardens Water System Improvements - Division II (Construction) 2,550,000 --- Westover Acres Water System Improvements (Design & Permitting) 120,000 --- Replace VaCON 525,000 Sewer --- Wastewater Collection System Assessment 55,000 Other Water/Sewer Replacement/Refurbishment Projects 500,000 Information Technology (split) --- Sonicwall TZ270 Firewalls 4,500 --- Replacement PCs 7,200 --- HP Rack Mounted Server Core 5,000 --- IP Camera Replacements for existing analog cameras 11,200 --- Incode 10 Upgrade Software 32,000 Maintenance Shop (split) --- RAM 1500 Quad Cab Truck 20,000 --- Replace Shop Welder 2,800 --- New A/C Machine 3,300 --- Crane for Shop Truck 10,500 City Of Columbia WWTP Capital Projects - CWC Share --- Sewer line projects 1,700,000 --- Metro Waste Water Treatment Plant projects 300,000 FY 2022-2023 (Year 1) Totals 9,488,500$ City of West Columbia Water and Sewer Fund New 10 - Year CIP - Updated 05.15.2022 FY 2022-2023 Budget Year - Year 1 Page 1 of 10 City of West Columbia Water and Sewer Fund New 10 - Year CIP - Updated 05.15.2022 Plant 2 --- Improvements to the Lake Murray Water Treatment Plant (Construction) 50,100,000$ Water --- Mill Village Water System Improvements (Design & Permitting) 145,000 --- Westover Acres Water System Improvements (Construction) 850,000 --- Replace Dump Truck 163,200 --- Small Mini-Excavator 50,000 Sewer --- 2021 Collection System Improvements (Construction) 450,000 --- Jackson Street Sewer Main Rehabilitation. 185,000 --- Inflow and Infiltration Study 40,000 --- Replace Chevy 1500 44,600 Other Water/Sewer Replacement/Refurbishment Projects 500,000 Information Technology (split) --- Replacement PCs for PCs over 5 years old 4,600 --- HP Switch Upgrade - City Hall/PD 6,100 --- IP Camera Replacements for existing analog cameras 11,200 Maintenance Shop (split) --- Replace Vehicle (5301-905) 2009 Ford F350 (Service Truck) 45,000 --- Replace Roll-up Bay Doors 20,000 City Of Columbia WWTP Capital Projects - CWC Share --- Sewer line projects - --- Metro Waste Water Treatment Plant projects - FY 2023-2024 (Year 2) Totals 52,614,700$ FY 2023-2024 Budget Year - Year 2 Page 2 of 10 City of West Columbia Water and Sewer Fund New 10 - Year CIP - Updated 05.15.2022 Plant 1 --- Powder Activated Carbon Improvements 1,200,000$ --- Caustic Feed System 1,000,000 Water --- Mill Village Water System Improvements (Construction) 4,400,000 --- Augusta Street Water Main Replacement 750,000 Sewer --- Augusta Street Sewer Main Rehabilitation (Design) 150,000 --- Center Street Wastewater Improvements (Design & Construction) 450,000 --- Klapman Blvd. Sewer Main Rehabilitation. 450,000 Other Water/Sewer Replacement/Refurbishment Projects 750,000 Information Technology (split) --- Replacement PCs for PCs over 5 years old 4,600 --- Sonicwall Firewall - City Hall 2,800 --- IP Camera Replacements for existing analog cameras 11,200 Maintenance Shop (split) --- Replace metal siding and insulation on Maint Shop building 25,000 --- Replace Vehicle (5301-912) 2007 Chevrolet 2500 20,000 City Of Columbia WWTP Capital Projects - CWC Share --- Sewer line projects - --- Metro Waste Water Treatment Plant projects - FY 2024-2025 (Year 3) Totals 9,213,600$ FY 2024-2025 Budget Year - Year 3 Page 3 of 10 City of West Columbia Water and Sewer Fund New 10 - Year CIP - Updated 05.15.2022 Plant 1 --- PLC & Control Equipment Evaluation 20,000$ --- Embankment Stabilization Project (Design & Construction) 1,750,000 Sewer --- Augusta Street Sewer Main Rehabilitation (Construction) 1,400,000 --- Replacement of 4" Trailer Mounted Bypass Pump & Hose 75,000 --- 2025 Collection System Improvements 425,000 Other Water/Sewer Replacement/Refurbishment Projects 750,000 Information Technology (split) --- Replacement PCs for PCs over 5 years old 4,600 --- Citywide InDesign - Website upgrade 4,000 --- Upgrade backup appliance at City Hall 21,000 --- IP Camera Replacements for existing analog cameras 11,200 Maintenance Shop (split) --- Replace Lift for Heavy Duty Trucks 50,000 --- Replace Vehicle (5301-811) 2013 Ford F150 20,000 City Of Columbia WWTP Capital Projects - CWC Share --- Sewer line projects - --- Metro Waste Water Treatment Plant projects - FY 2025-2026 (Year 4) Totals 4,530,800$ FY 2025-2026 Budget Year - Year 4 Page 4 of 10 City of West Columbia Water and Sewer Fund New 10 - Year CIP - Updated 05.15.2022 Plant 2 --- Upgrade Solids Handling Equipment 550,000$ Plant 1 --- Embankment Stabilization Project (Design) 75,000 --- Replace Phosphate system 75,000 Sewer --- Charleston Highway Sewer Main Rehabilitation (Construction) 450,000 --- Sewanee and Redwood Drive Sewer Main Rehabilitation (Construction) 250,000 --- Update Wastewater Master Plan 55,000 --- Replace Chevy 3500 80,040 Other Water/Sewer Replacement/Refurbishment Projects 500,000 Information Technology (split) --- Replacement PCs for PCs over 5 years old 4,600 --- Sonicwall Firewall 5,600 --- IP Camera Replacements for existing analog cameras 11,200 Maintenance Shop (split) --- Replace Vehicle Lifts 17,500 City Of Columbia WWTP Capital Projects - CWC Share --- Sewer line projects - --- Metro Waste Water Treatment Plant projects - FY 2026-2027 (Year 5) Totals 2,073,940$ FY 2026-2027 Budget Year - Year 5 Page 5 of 10 City of West Columbia Water and Sewer Fund New 10 - Year CIP - Updated 05.15.2022 Plant 2 --- Chemical Feed Improvements 750,000$ Plant 1 --- Replace Filter Media & Underdrains (Filters No. 1 - 4) 1,400,000 --- Embankment Stabilization Project (Construction) 2,000,000 Sewer --- Replace 6" Bypass Pump & Hose 89,600 --- Replace Chevy 3500 82,500 Other Water/Sewer Replacement/Refurbishment Projects 500,000 Information Technology (split) --- Replacement PCs for PCs over 5 years old 4,600 --- IP Camera Replacements for existing analog cameras 11,200 Maintenance Shop (split) --- Replace Shop Air Compressor 12,500 City Of Columbia WWTP Capital Projects - CWC Share --- Sewer line projects - --- Metro Waste Water Treatment Plant projects - FY 2027-2028 (Year 6) Totals 4,850,400$ FY 2027-2028 Budget Year - Year 6 Page 6 of 10 City of West Columbia Water and Sewer Fund New 10 - Year CIP - Updated 05.15.2022 Plant 2 --- Replace Chevy 1500 48,000$ Plant 1 --- Upgrade Onsite Generation Disinfection Equipment 650,000 Water --- Replace Chevy 1500 48,200 --- Repalce Chevy 3500 84,000 Update Distribution & Collection Condition Assessment 105,000 Other Water/Sewer Replacement/Refurbishment Projects 500,000 Information Technology (split) --- Replacement PCs for PCs over 5 years old 4,600 --- Sonicwall Firewall - City Hall 2,800 --- IP Camera Replacements for existing analog cameras 11,200 Maintenance Shop (split) --- Replace HVAC Systems 22,500 City Of Columbia WWTP Capital Projects - CWC Share --- Sewer line projects - --- Metro Waste Water Treatment Plant projects - FY 2028-2029 (Year 7) Totals 1,476,300$ FY 2028-2029 Budget Year - Year 7 Page 7 of 10 City of West Columbia Water and Sewer Fund New 10 - Year CIP - Updated 05.15.2022 Plant 1 --- Replace Chevy Equinox 38,000$ Water --- Fire Hydrant Replacement 140,000 --- Replace Chevy 1500 48,200 --- Repalce Chevy 3500 84,000 Other Water/Sewer Replacement/Refurbishment Projects 750,000 Information Technology (split) --- HP Rack Mounted Server Core 3,000 --- Replacement PCs for PCs over 5 years old 4,600 --- IP Camera Replacements for existing analog cameras 11,200 Maintenance Shop (split) --- Replace roof on Maintenance Building 20,000 City Of Columbia WWTP Capital Projects - CWC Share --- Sewer line projects - --- Metro Waste Water Treatment Plant projects - FY 2029-2030 (Year 8) Totals 1,099,000$ FY 2029-2030 Budget Year - Year 8 Page 8 of 10 City of West Columbia Water and Sewer Fund New 10 - Year CIP - Updated 05.15.2022 Plant 2 --- Replace Disinfection Bulk Storage Tanks 150,000$ Plant 1 --- Replace Raw Water Pumps 130,000 Water --- Storage Tank Coating Mainteance 150,000 Other Water/Sewer Replacement/Refurbishment Projects 750,000 Information Technology (split) --- Replacement PCs for PCs over 5 years old 4,600 Maintenance Shop (split) --- New Tire Machine and Balancer 15,000 City Of Columbia WWTP Capital Projects - CWC Share --- Sewer line projects - --- Metro Waste Water Treatment Plant projects - FY 2030-2031 (Year 9) Totals 1,199,600$ FY 2030-2031 Budget Year - Year 9 Page 9 of 10 City of West Columbia Water and Sewer Fund New 10 - Year CIP - Updated 05.15.2022 Plant 2 --- Update Facility Master Plan 250,000$ Plant 1 --- Upgrade PLCs Throughout 375,000 Water --- Replace F250 84,000 Other Water/Sewer Replacement/Refurbishment Projects 750,000 Information Technology (split) --- Replacement PCs for PCs over 5 years old 4,600 Maintenance Shop (split) --- Replace Brake Lathe 3,800 City Of Columbia WWTP Capital Projects - CWC Share --- Sewer line projects - --- Metro Waste Water Treatment Plant projects - FY 2031-2032 (Year 10) Totals 1,467,400$ Projected Totals for next 10 years of CIP. 88,014,240$ FY 2031-2032 Budget Year - Year 10 Page 10 of 10 S E C T I O N 6 STATE HEALTH CARE PREMIUMS DETAIL Employee City Type of Coverage Health Dental Life LTD Total Part Part Employee 500.38$ 13.48$ 0.32$ 3.22$ 517.40$ -$ 517.40$ Employee/spouse 1,051.04 21.12 0.32 3.22 1,075.70 155.68 920.02 Employee/children 761.92 27.20 0.32 3.22 792.66 46.18 746.48 Full Family 1,305.28 34.82 0.32 3.22 1,343.64 208.88 1,134.76 Employee City Type of Coverage Health Dental Life LTD Total Part Part Employee 682.19$ 13.48$ 0.32$ 3.22$ 699.21$ -$ 699.21$ Employee/spouse 1,422.55 21.12 0.32 3.22 1,447.21 185.26 1,261.95 Employee/children 1,039.81 27.20 0.32 3.22 1,070.55 54.95 1,015.59 Full Family 1,768.40 34.82 0.32 3.22 1,806.76 248.57 1,558.19 State Premiums & Costs - January 1, 2023 to June 30, 2023 (Projected) Total Premiums City of West Columbia Insurance Information State Health Plan Monthly Premiums & Costs (Estimated) State Premiums & Costs - July 1, 2022 to December 31, 2022 (Actual) Total Premiums

Source: City of West Columbia website. First collected Oct 14, 2026.