Loading...
22-R-68 - SSLGC FY2022-23 BudgetRESOLUTION NO. 22 -R -68 A RESOLUTION BY THE CITY COUNCIL OF THE CITY OF SCHERTZ, TEXAS APPROVING THE SCHERTZ SEGUIN LOCAL GOVERNMENT CORPORATION FISCAL YEAR 2022 -2023 ANNUAL BUDGET, AND OTHER MATTERS IN CONNECTION THEREWITH WHEREAS, the Schertz Seguin Local Government Corporation (SSLGC) is a corporation for the provision of and transportation of water wholly owned by both the City of Schertz and the City of Seguin; and WHEREAS, SSLGC by -laws require that the corporation establish an annual budget and said annual budget must be approved by the SSLGC Board of Directors and both the City of Schertz and the City of Seguin; and WHEREAS the proposed FY 2022 -23 Fiscal Year Budget has been approved by the SSLGC Board of Directors at their regularly scheduled June Board Meeting; and WHEREAS, the City staff of the City of Schertz (the "City') recommends that the City approve the Schertz Seguin Local Government Corporation Fiscal Year 2022 -23 Annual Budget; and WHEREAS, the City Council has determined that it is in the best interest of the City to approve the budget to ensure that the citizens and businesses of Schertz continue to receive excellent and vital water service. BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF SCHERTZ, TEXAS THAT: Section 1. The City Council hereby authorizes the approval of the Schertz Seguin Local Government Corporation Fiscal Year 2022 -23 Annual Budget. Section 2. The recitals contained in the preamble hereof are hereby found to be true, and such recitals are hereby made a part of this Resolution for all purposes and are adopted as a part of the judgment and findings of the City Council. Section 3. All resolutions, or parts thereof, which are in conflict or inconsistent with any provision of this Resolution are hereby repealed to the extent of such conflict, and the provisions of this Resolution shall be and remain controlling as to the matters resolved herein. Section 4. This Resolution shall be construed and enforced in accordance with the laws of the State of Texas and the United States of America. Section 5. If any provision of this Resolution or the application thereof to any person or circumstance shall be held to be invalid, the remainder of this Resolution and the application of such provision to other persons and circumstances shall nevertheless be valid, and the City Council hereby declares that this Resolution would have been enacted without such invalid provision. Resolution # SSLGC R22-07 SCHERTZ /SEGUIN LOCAL GOVERNMENT CORPORATION STATE OF TEXAS COUNTY OF GUADALUPE A RESOLUTION ADOPTING THE SCHERTZ /SEGUIN LOCAL GOVERNMENT CORPORATION FISCAL YEAR 2022 -2023 BUDGET AND MAKING APPROPRIATION IN ACCORDANCE WITH SAID BUDGET WHEREAS, in accordance with the Schertz /Seguin Local Government Corporation Bylaws, it is necessary to adopt a budget for the fiscal year 2022 -2023; and WHEREAS, a proposed annual budget for the period commencing October 1, 2022 and ending September 30, 2023 has been prepared by the Schertz /Seguin Local Government Corporation Financial Officer and the City of Seguin Director of Finance, and the Board of Directors has considered the proposed budget; and WHEREAS, the budget for the fiscal year 2022 -2023 for the Schertz /Seguin Local Government Corporation is attached. NOW THEREFORE, BE IT RESOLVED BY THE BOARD OF DIRECTORS OF THE SCHERTZ /SEGUIN LOCAL GOVERNMENT CORPORATION: The budget for the fiscal year commencing October 1, 2022 and ending September 30, 2023 is hereby approved and adopted. Passed and approved this the 16' day of J une, 2022. Attest: Richard Dziewit, Assistant Secretary D Wait, P sident 1of1 SIGNED ORIGINAL(S): 1 Section 6. It is officially found, determined, and declared that the meeting at which this Resolution is adopted was open to the public and public notice of the time, place, and subject matter of the public business to be considered at such meeting, including this Resolution, was given, all as required by Chapter 551, Texas Government Code, as amended. Section 7. This Resolution shall be in force and effect from and after its final passage, and it is so resolved. PASSED AND ADOPTED, this 28th day of June 2022. CITY OF TZ, TEXAS Ra h utie .., Mayor ATTL�T Brenda Dennis, City Secretary c Fe. Al�e Y L t. Y. * I L O C A L G O V E R N M E N T C O R P O R A T 1 O N FY2022 -2023 BUDGET c.FcA�ey�Lt�x�� 4 caf"uLL4L L O C A L G O V E R N M E N T C O R P O R A T I O N FY2022 -2023 BUDGET TABLE OF CONTENTS General Manager /Assistant General Manager's letter .................................................... ..............................1 BudgetSummary ............................................................................................................. ..............................5 OperatingFund ............................................................................................................... ............................... 6 ConstructionFund .......................................................................................................... .............................10 I &S Fund ........................................................................................................................ .............................13 Repair/Replacement Fund .............................................................................................. .............................16 Future Development Fund .............................................................................................. .............................19 ImpactFee Fund ........................................................................................................... ............................... 22 ReserveFund .................................................................................................................. .............................25 RateStabilization ......................................................................................................... ............................... 27 SAWSI &S Fund ............................................................................................................ .............................30 Capital Improvement Projects/Equipment 5 -Year Plan ................................................. .............................33 s c,* s • L O C A L G O V E R N M E N T TO: Board of Directors FROM: Amber Beard, General Manager SUBJECT: FY2022 -23 Budget DATE: June 10, 2022 CO R P O R A T I O N On behalf of SSLGC staff, I present the FY2022 -23 Budget for the Schertz/Seguin Local Government Corporation. The annual budget is presented to provide a comprehensive review of SSLGC's operations and services during the new fiscal year beginning on October 1, 2022. In presenting the FY2022 -23 Budget, I would like to recognize Susan Caddell, Finance Director of the City of Seguin; Clarissa Barrientes, Office Administrator; Daniel Myers, Operations Manager, and Derrik Wesch, Superintendent for their contributions to the development of the FY2022 -23 Budget. Each year's budget process offers unique challenges in presenting a balanced budget which maintains SSLGC's successful delivery of quality potable water with the least impact possible on our customers through utility rates. During FY2022 -23, the Guadalupe Water Treatment Plant anticipated to come online which is reflected in the in presented budget. The specific budgets are presented in detail for your review. Review of FY2022 -23 Budget Overall, the FY2021 -22 expenditures are estimated to be lower than budget appropriations. The projected Operating Fund expenditures are $9,606,897 which is $61,902 below budgeted expenditures. The projected FY2021 -22 Operating Fund revenues are projected to be $9,606,897 which is $289,311 below the budgeted revenues. FY2022 -23 Operating Fund Revenues When compared to FY2021 -22, the projected FY2022 -23 Operating Fund Revenues show an increase of $509,127 which represents an increase of 5.1 %. FY 2022 -23 Operating Fund Expenditures The FY2022 -23 expenditures increased $36,961, or 0.38% when compared to FY2021- 22. Costs for personnel and benefits represent 19% of the total Operating Fund expenditures. Significant increases in expenditures include: Item Increase Amount (1) Water Leases — Guadalupe County (30.8 %) $159,000 This amount is due to an increase in the annual production cap approved by the Guadalupe County Groundwater Conservation District which increases SSLGC water lease payments for water rights held within Guadalupe County. (2) Water Leases — Gonzales County (5.9 %) $128,500 This amount is due to projected increases in water lease payments for water rights held within Gonzales County. (3) Chemicals (69% increase) $316,500 This amount is due to substantial increases in the price of chemicals used in the water treatment process. Personnel The proposed budget includes a 3.0% cost of living increase and up to a 2.5% merit increase for SSLGC's City of Seguin employees. The proposed budget includes up to a 4% merit increase for SSLGC's City of Schertz employees. The merit increases are based on annual employee performance ratings. Capital Improvement Projects The proposed SSLGC Capital Improvement projects include the following projects that are recommended to be funded through: Issuance of Revenue Bonds: Emergency Preparedness Plan Implementation $2,000,000 These funds will be used for the purchase and installation of emergency generators for the water system and/or for radial/looped GVEC electric feeds per the Emergency Preparedness Plan. Cowey (42 ") & Elm Creek (36 ") Pipeline Projects $4,500,000 These funds will be used for the engineering & easement acquisition for the projects. (Impact Fees may also be used) Repair and Replacement Fund: Pressure Tank Painting (Hal Baldwin Pump Station) $87,790 These funds will be used to sandblast and paint the pressure tank -Page 2- Well Lowering Project These funds will be used for the lowering of two wells including the upsizing of the pumps and motors as well as the replacement of SCADA components. The project schedule includes lowering two wells each year for the next four years (Well #1- Well #8). Pressure Filter Rehab Project These funds will be used for the painting of SSLGCs pressure filters and the replacement offilter media and valves. Light Fixture Repair and Replacement — Gonzales Water Treatment Plant These funds will be used to repair and replace indoor and outdoor light fixtures at the Gonzales Water Treatment Plant. Water Transmission Lines These funds will be used for repairs on water transmission pipelines in addition to the replacement of valves as needed. High Service Pumps and Motors These funds will be used for the repair and replacement of the high services pumps throughout the water system as needed. Wells Repair and Replacement These funds will be used for the repair and replacement of well pumps, motors, and other well components. Impact Fee Fund Gonzales High Service Pump Room #1 Expansion Project These funds will be used for the installation of additional pumps at the Gonzales Water Treatment Plant per the 2021 Water Model recommendations. Gonzales Surge Analysis and Surge Tank Installation These funds will be used for a surge study and surge tank installation at the Gonzales Water Treatment Plant per the 2021 Water Model recommendations. Guadalupe Project Additional Funds These funds will be used as estimated additional funds required for the completion of the Guadalupe Project after TWDB SWIFT bond funding is fully utilized. -Page 3- $594,984 $633,745 $25,000 $25,000 $300,000 $500,000 $2,034,000 $900,000 $2,650,000 Future Development Fund: Guadalupe Project Additional Funds $2,000,000 These funds will be used as estimated additional funds required for the completion of the Guadalupe Project after TWDB SWIFT bond funding is fully utilized. Solar Project (land surveys) $50,000 These funds will be used for additional land surveying as required for the solar project. Capital Equipment The FY2022 -23 Operating Fund includes $10,000 for the replacement of a rail side utility trailer with a flatbed trailer. Conclusion The presented proposed FY2022 -23 Budget represents a balanced budget which will enable the Schertz/Seguin Local Government Corporation to continue to provide quality potable water to its valued customers. -Page 4- SCHERTZSEGUIN LOCAL GOVERNMENT CORPORATION 2022 -23 BUDGET SUMMARY - ALL FUNDS -Page 5- Estimated Estimated Working Capital Estimated Transfers Proposed Transfers Working Capital Fund 10/1/2022 Revenues In Expenditures Out 9/30/2023 Operating Fund 4,350,514 10,405,335 - 9,105,760 600,000 5,050,089 Construction Fund 18,613,330 26,000 - 18,639,330 - 0 I &S Fund 1,669,600 7,395,133 - 7,393,033 - 1,671,700 Repair /Replacement Fund 7,430,007 3,100 600,000 3,393,934 - 4,639,173 Future Development Fund 2,835,302 424,106 - 2,382,825 - 876,583 Impact Fund 5,824,507 602,750 - 5,600,289 - 826,968 Reserve Fund 1,363,484 900 - - - 1,364,384 Rate Stabilization Fund 1,828,531 2,010 - - - 1,830,541 SAWS I &S Fund 836,256 1,391,438 - 1,391,188 - 836,506 -Page 5- SSLGC SSLGC OPERATING FUND - 058 2022 /23 ANNUAL BUDGET SCHERTZ/SEGUIN LOCAL GOVT. CORP. - 5500 The City of Seguin is utilized for services for the Schertz/Seguin Local Government Corporation ( SSLGC) in accordance with a management services agreement between the City of Seguin, the City of Schertz and SSLGC. The City of Seguin is the employer of record for all positions listed below with the exception of the General manager and Assistant General Manager. The Schertz/Seguin Local Government Corporation reimburses the City of Schertz for all costs for the Schertz positions. Since the City of Seguin is utilized for both financial and human resources administration services through the management services agreement, costs for Seguin positions are transferred directly from SSLGC accounts. POSITION TITLE: PERSONNEL SCHEDULE 20/21 21/22 22/23 General Manager 1 1 1 Assistant General Manager 1 1 1 Office Administrator 1 1 1 Operations Manager 1 1 1 Water System Superintendent 1 1 1 Part-Time Administrative Technician 0 1 1 Operator I 8 9 6 Operator II 3 4 4 Operator III 1 1 3 Operator IV 0 0 1 Service Worker 1 1 1 18 21 21 BUDGET SUMMARY The FY2023 budget includes the following increases: 1. An increase of $159,000 in Water Leases- Guadalupe County for increased water lease payments to landowners due to an increase in the annual production cap by the Guadalupe County Groundwater Conservation District. 2. An increase of $128,500 in Water Leases - Gonzales County for increased water lease payments to landowners. 3. An increase of $345,000 in Chemicals due to significant water treatment chemical price increases. -Page 6- seAfx * cragubt L O C A L O 0 V 9 A N N E N T C 0 R P C A A T 1 0 N Account: Number Account Name 058 - SCHERTZ- SEGUIN GOVT CORP OPERATING FUND Revenue Charges for Services 058 - 341005 SAWS Well Field Operation Charges for Services Total: Utility 058-343007 Water Sales Utility Totals: Interest Revenues 058 - 361002 Investment Pools Interest Earnings 058361004 Texas CLASS Interest Earnings 058- 361020 Restricted Cash Interest Revenues Totals: Miscellaneous Revenues 058- 362030 Miscellaneous Revenues Miscellaneous Revenues Totals: Lease Revenues 058 - 363040 Lease Payments 058- 363060 Grazing Leases Lease Revenues Totals: Sale of Fixed Assets 058 - 392020 Sale of Equipment Sale of Fixed Assets Totals: 2022 -23 Budget - SSLGC Operating Revenues FY 2021 FY 2022 FY 2022 FY 2022 FY2023 Actual Budget 03/31/22 Estimates Budget 87,771 90,379 45,190 90,379 93,316 87,771 90,379 45,190 90,379 93,316 9,533,800 9,673,367 4,561,778 9,398,716 10,174,065 9,533,800 9,673,367 4,561,778 9,398,716 10,174,065 139 300 888 11500 11000 4,074 3,000 763 1,500 11000 190 (200) 514 600 200 4,403 3,100 2,165 3AW 2,200 73,789 2,000 5,492 10,000 6,000 73,789 2,000 SA92 10,000 6,000 9,900 23,160 0 0 0 153,237 104,202 37,284 104,202 129,754 163,137 127,362 37,284 104,202 129,754 14,895 0 0 0 0 14,895 - - - - SCHERTZ- SEGUIN GOVT CORP OPERATING FUND Totals: 9,877,795 9,896,208 4,651,909 9,606,897 10A05,335 -Page 7- crahmAix (0 cr rwi ft L O C A L G O V E R N M E N T C O R P O R A T I O N 2022 -23 Budget -SSLGC Operating Expenditures Account Number Account Name FY 2021 FY 2022 FY 2022 FY 2022 FYZ023 0S8 - SCHERTZ- SEGUIN GOVT CORP OPERATING FUND Actual Budget 03/31/22 Estimates Budget 55 - SSLGC 11- Salaries 058 - 5500 - 110100 Regular5alaries 837,618 1,145,649 469,465 810,000 1,160,000 058 - 5500 - 112000 Overtime /On Call 75,947 90,035 46,530 85,000 102,000 058 - 5500 - 112100 Holiday Pay 13,665 18,000 10,360 18,000 19,000 11- Salaries Totals: 927,230 1,253,684 526,355 913,000 1,281,000 12 - Benefits 058 - 5500 - 121000 Payroll Taxes 68,710 86,525 39,543 68,500 96,360 058 - 5500 - 122000 Retirement 196,009 254,485 110,506 195,000 272,760 058 - 5500.123000 Health Insurance 102,389 162,234 63,703 106,500 180,480 058 - 5500 - 123100 Life Insurance 801 1,258 479 11000 1,260 058 - 5500-124000 Workers' Compensation 7,496 10,113 4,569 7,500 10,670 12 - Benefits Totals: 375,405 514,615 218,800 378,500 561,530 32 - Professional Services 058 - 5500.320500 Professional Services 97,729 322,000 53,900 125,000 296,000 058 -5500- 321000 Annual Audit 12,500 13,000 12,900 12,900 13,300 058 -5500- 321200 Consultant Services 101,380 120,000 41,260 110,000 120,000 058 -55GD- 321500 Attorney Fees 32,925 50,000 10,785 30,000 50,000 058 -5500- 321600 Landfill Opposition 990 5,000 2,730 4,200 51000 058 -5500- 323500 Solid Waste Contract 4,601 4,600 2,228 4,100 5,550 32 - Professional Services Totals: 250,125 514,600 123,803 286,200 489,850 34 - Technical Services 058 -5500- 342100 Gonzales Underground Water Distric 97,608 100,000 36,127 100,000 100,000 058- 5500 - 342200 City Distribution Fee 32,182 45,000 25,241 50,400 51,000 058 - 5500 - 342400 GCGCD Permit Fee 229,467 173,500 86,736 173,500 173,500 058 -5500- 342500 GCUWCD Mitigation Fund Pymt 65,953 69,500 69,436 69,500 69,500 058 -5500- 343000 Testing/inspection Fees 12,596 20,000 17,849 20,000 23,000 34- Technical Services Totals: 437,806 408,000 235,389 413,400 417,000 41- Utilities Services 058 -5500- 411000 Electric 2,320,888 2,100,000 955,932 11850,000 2,000,000 058 -5500- 412000 Water 641 800 324 600 800 058 -5500- 413000 Sewer 729 800 377 700 800 058 - 5500 - 414000 Gas- Centerpoint 931 900 715 980 980 058 -5500- 415200 Telephone - Mobile Phone 5,763 5,000 2,546 4,500 51000 058 - 5500 - 415300 Internet Access 0 0 0 0 5,400 41- Utilities Services Totals: 2,328,952 2,107,500 959,894 1,856,780 2,012,980 43 - Repair and Maintenance 058 - 5500 - 431200 Office Maintenance- Computer 3,503 81500 0 5,000 3,500 058 -5500- 432100 V &E Maint: Motor Vehicles 15,821 14,000 6,897 14,600 15,000 058 -5500- 432200 V &E Maint: Machine & Tool 9,696 20,000 84 10,000 15,000 058 -5500. 432300 V &E Maint: Heavy Equipment 4,915 91000 64 3,000 9,000 058 - 5500 - 432400 V &E Maint: Communications 33,847 27,400 4,367 20,000 25,000 058 -5500- 432500 V &E Maint: Pumps & Motors 161,547 150,000 45,826 173,000 50,000 058 -5500- 433000 Buildings Maintenance 12,346 30,000 6,475 21,000 25,000 058 - 5500 - 434601 L&I Maint: WATER System 25,454 100,000 7,892 60,000 100,000 058- 5500 - 436000 Property Maintenance 24,696 45,000 1,996 20,000 10,000 43 - Repair and Maintenance Totals: 291,825 403,900 73,601 326,600 252,500 44 - Rental 058 -5500- 441000 Equipment Rental 3,642 7,000 1,386 4,000 4,500 058 -5500- 443500 Water leases 0 0 0 0 0 058- 5500 - 443501 Water Leases - Guadalupe County 516,095 516,200 258,052 516,014 675,200 058 -5500- 443502 Water Leases - Gonzales County 2,169,441 2,176,900 1.087,654 _ 2,119,800 2,305,400 44- Rental Totals: 2,689,178 2,700,100 1,347,092 2,639,814 2,985,100 -Page 8- 96 - Use of Retained Earnings 058 -9800- 960000 Use of Retained Earnings 96 - Use of Retained Earnings Totals: 0 0 0 r 121,2241 0 0 0 0 (121,224) 0 SCHERTZ - SEGUIN GOVT CORP OPERATING FUND Totals: 9,920,345 9,668,799 4,407,040 9,606,897 9,705,760 -Page 9- FY 2021 FY 2022 FY 2022 FY 2022 FY2023 Actual Budget 03/31/22 Estimates Budget S2- Insurance 058 -5500- 521000 Building/Auto Liability 125,689 140,000 134,942 135,000 150,000 058 - 5500 - 524000 Unemployment Insurance 1,726 2,OOD 0 0 2,000 52 - Insurance Totals: 127,415 142,000 134,942 135,000 152,000 54 - Advertising 058 - 5500 - 541000 Publication of Notices 3,629 5,000 1,154 2,130 5,000 54- Advertising Totals: 3,629 5,000 1,154 2,130 5,000 61- General Supplies 058 - 5500 - 611000 Office Supplies 7,268 6,000 2,515 5,000 6,000 058 - 5500. 612000 Postage 1,463 1,200 482 900 1,200 058 -5500- 613000 Operating Supplies 3,898 6,000 611 1,400 6,000 058 -55OD- 613300 Chemicals 483,460 500,000 308,657 830,000 845,000 058 - 5500 - 613500 Laboratory Supplies 8,922 18,400 3,413 12,000 15,000 058 -5500- 614300 Safety Supplies 5,039 4,000 98 4,000 5,000 058 - 5500 - 616000 Uniforms 5,227 7,000 2,971 6,000 6,500 058- 5500 - 618000 Minor Tools and Equipment 1,425 51000 719 5,000 5,000 61- General Supplies Totals: 516,702 547,600 319,466 864,300 889,700 62 - Energy and Fuel 058 -5500- 621000 Gasoline 14,175 15,000 11,680 18,000 21,000 62 - Energy and Fuel Totals: 14,175 15,000 11,680 18,000 21,000 65 - Miscellaneous 058 -5500- 655100 Employee Recognition 0 2,000 440 1,700 2,000 058 -5500- 655200 Recruitment 2,501 0 0 0 4,000 65 - Miscellaneous Totals: 2,501 2,000 440 1,700 6,000 66 - Education 058 -5500- 661000 Seminar Tuition 4,608 10,000 3,854 7,500 6,000 058- 5500 - 662000 Certification Fees 1,065 2,000 144 1,000 2,000 058- 5500 - 665000 Travel and Lodging 1,983 7,500 1,763 6,000 6,000 058- 5500- 665500 Meals 1,011 1,200 148 900 1,200 058 -5500- 666000 Dues 0 2,900 2,250 3,400 3,600 058 -5500- 667000 Subscriptions 1,359 200 171 300 300 66- Education Totals: 10,026 23,800 8,330 19,100 19,100 67 - Public Relations 058 - 5500 - 671000 Public Relations 5,151 4,000 2,864 3,500 3,000 67 - Public Relations Totals: 5,151 4,000 2,864 3,500 3,000 70 - Capital Outlay 058 -5500- 703000 Improvements other than Buildings 0 0 0 50,000 0 058 -5500- 704200 Transmission Lines 0 25,000 0 0 0 058 - 5500 - 706100 Mach. & Equip.-Office 538 7,000 3,517 7,000 0 058 -5500- 706200 Mach. & Equip.-Heavy Equipment 0 0 0 0 0 058 -5500- 706500 Machine & Equipment -Small Equipm 27,817 0 0 0 10,000 058 -5500- 706600 Machine & Equipment -Pumps & Mo+ 0 100,000 14,713 22,503 0 058 -5500- 707100 Transportation- Vehicles 43,871 45,000 0 43,925 0 , 70 - Capital Outlay Totals: 72,225 177,000 18,230 123,428 10,000 82 - Intragvrmmntl. Transfers 058 -5500- 825700 Rate Stabilization Fund 0 0 0 300,000 0 058 -5500- 826100 Repair & Replacement Fund 1,618,000 600,000 300,000 1,196,669 600,000 058 - 5500 - 826200 Future Development Fund 250,000 250,000 125,000 250.000 0 82 - Intragvmmntl. Transfers Totals: 1,868,000 850,000 425,000 1,746,669 600,000 96 - Use of Retained Earnings 058 -9800- 960000 Use of Retained Earnings 96 - Use of Retained Earnings Totals: 0 0 0 r 121,2241 0 0 0 0 (121,224) 0 SCHERTZ - SEGUIN GOVT CORP OPERATING FUND Totals: 9,920,345 9,668,799 4,407,040 9,606,897 9,705,760 -Page 9- SSLGC SSLGC CONSTRUCTION FUND - 059 2022/23 ANNUAL BUDGET SCHERTZ /SEGUIN LOCAL GOVT. CORP. The SSLGC Construction Fund accounts for all the proceeds from the TWDB SWIRFT Revenue Bonds as well as the expenditures for the Guadalupe County Wellfield Project and the Parallel Pipeline Project. -Page 10- crr_��� 4 cyev. L O C A L G O V E R N M E N T C O R P O R A T I O N Account Number Account Name 059- SCIIERTZ/SEGUIN UGC- CONSTRUCTION FUND Revenue FY2023 Interest Revenues Budget 059- 361002 Investment Pools Interest Earnings 059- 361004 Texas CLASS Interest Earnings 059- 361020 Restricted Cash Interest Revenues Totals 0 SSLGC - CONSTRUCTION FUND TOTALS 2022 -23 Budget -SSLGC Construction Fund Revenues FY 2021 FY 2022 FY 2022 FY 2022 FY2023 Actual Budget 03/31/22 Estimates Budget 366 0 0 0 0 5,700 2,500 17,838 30,000 25,000 5,202 11000 1,505 2,000 1,000 11,268 3,500 191343 92,000 26,000 11,268 3,500 19,343 32,000 26,000 -Page 11- L O C A L crakaxtx (0 crMF"I'M O O V E R N M E N T C O R P O R A T I O N Account Number Account Name OS9 - SCHERTZ/SEGUIN LGC- CONSTRUCTION FUND 90 - Non Departmental 70 - Capital Outlay 059 - 9000- 7030DD Impr. Other Than Building 70 - Capital Outlay Totals: 98 - Use of Fund Balance/Retained Earnings 96 - Use of Retained Earnings 059 - 9800 - 960000 Use of Retained Earnings 96 - Use of Retained Earnings Totals: SCHERTZ/SEGUIN LGC- CONSTRUCTION FUND TOTALS 2022 -23 Budget - SSLGC Construction Fund Expenditures FY 2021 FY 2022 FY 2022 FY 2022 FY2023 Actual Budget 03/31/22 Estimates Budget 10,707,353 36,309,153 14,315,361 35,380,092 18,639,330 10,707,353 36,109,151 14,315,361 35,380,092 18,639,330 0 (36,105,651) 0 (35,348,092) (18,613,330) 0 (36,105,651) 0 (35,346,092) (18,613,330) 10,707,353 31500 14,315,361 32,000 26,000 -Page 12- SSLGC SSLGC I &S FUND - 060 2022/23 ANNUAL BUDGET SCHERTZ/SEGUIN LOCAL GOVT. CORP. The SSLGC I &S Fund accounts for all water sale proceeds from the debt service rates charged along with the payment of principal and interest of corporation debt other than the SAWS Revenue Bonds. -Page 13 -, cf "=bL L O C A L G O V E R N M E N T C O R P O R A T I O N 2022 -23 Budget - SSLGC I &S Revenues AWunt Number Account Name FY 2021 FY 2022 FY 2022 FY 2022 FY2023 060- SCHERTZ/SEGUIN WC -I&S Actual Budget 03/31/22 Estimates Budget Revenue Utility 060 - 343007 Water Sales 7,356,255 7,450,460 4,838,502 7,450,460 7,393,033 Utility Totals: 7,356,255 7,450,460 4,838,502 7,450,460 7,393,033 Interest Revenues 060 - 361004 Texas CLASS Interest Earnings -29 0 42 75 50 060- 361002 Investment Pools Interest Earnings 1,285 1,200 41 75 50 060 - 361020 Restricted Cash 685 0 1,883 3,000 2,000 Interest Revenues Totals: 1,941 11200 1,966 3,150 2,100 Long Term Debt Proceeds 060 - 393000 Bond Proceeds 0 0 7,343 7,343 0 Utility Totals: 0 0 7,343 7,343 0 SCHERTZ/SEGUIN L6C -165 TOTALS 7,358,196 7,451,660 4,847,811 7,460,953 7,395,133 -Page 14- V M&Mft 4 cr i L O C A L G O V E R N M E N T C O R P O R A T I O N Account Number Account Name 060- SCNERTZ/SEGUIN LGC -I8S 92 - Debt Service 060 - 9200 - 915500 90 - Principal Payments 060.9200- 918000 060 - 9200905100 2022 Revenue Refunding 060 -9200- 908000 2014 Revenue Refunding 060- 9200 - 908100 2015 Revenue Impr & Refunding 060- 9200 - 908800 2016 Revenue Bds- SWIRFT Funding OW9200- 909200 2018 Revenue Refunding 90 - Principal Payments Totals: 91- Interest Payments FY 2022 060 -92OD- 915100 2022 Revenue Refunding 060 - 9200 - 915500 2001 Revenue Bonds 060.9200- 918000 2014 Revenue Refunding 060 - 9200 - 918100 2015 Revenue Impr. & Refunding 060. 9200 - 918800 2016 Revenue Bds- SWIRFT Funding 060- 9200 - 919200 2018 Revenue Refunding 060.9200919400 20165WIRFT -Board Participation 91- Interest Payments Totals: 92 - Fiscal Agent Fees 0609200920000 Fiscal Agent Fees 92 - Fiscal Agent Fees Totals: SCHERTZ/SEGUIN LGC -I8S TOTALS 2022 -23 Budget - SSLGC l &S Expenditures FY 2021 FY 2022 FY 2022 FY 2022 FY2023 Actual Budget 03/31/22 Estimates Budget 0 0 0 0 995000 570,000 590,000 0 590,000 0 785,000 825,000 0 825,000 860,000 1,250,000 1,260,000 0 1,260,000 1,270,000 540,000 565,000 0 565,000 590,000 3,145,000 3,240,000 - 3,240,000 3,715,000 0 0 0 486,444 1,108,588 520,000 520,000 260,000 520,000 520,000 92,575 75,175 75,175 75,175 0 1,641,850 1,609,650 1,10606 1,106,006 17,200 980,867 969,242 484,621 969,242 956,390 783,800 761,825 385,150 761,825 738,600 165,627 248,441 124,221 248,441 331,255 4,184,719 4,184,333 2,435,173 4,167,133 3,672,033 4,199 6,000 5,811 6,000 6,000 4,199 6,000 51811 64100 600 7,333,918 7x430,333 2,440,984 7,413,133 7,393,033 -Page 15- SSLGC SSLGC REPAIR AND REPLACEMENT FUND - 061 2022/23 ANNUAL BUDGET SCHERTZ /SEGUIN LOCAL GOVT. CORP. The SSLGC Repair and Replacement Fund is utilized for the repair and replacement of SSLGC's water system infrastructure. Funds are transferred annually to this fund from O &M water rate revenues and retained earnings. -Page 16- c"ah.a Cr L 0 C A L 0 0 V E R N N E N T COO P 0 A A T I O N 2022 -23 Budget- Repair /Replacment Fund Revenues Amount Number Account Name FY 2021 FY 2022 FY 2022 FY 2022 FY2023 061- SSWC- REPAIR/REPLACEMENTFUND Actual Budget 03/31/22 Estimates Budget Revenue Interest Revenues 061- 361002 Investment Pools Interest Earnings 1,261 1,000 1,780 3,000 2,500 061- 361004 Texas CLASS Interest Earnings 4,761 51000 650 800 500 061- 361020 Restricted Cash 186 -50 251 300 100 Interest Revenues Totals 6,208 S,950 2,681 4,100 3,100 Intregovemmental Transfers 061 - 391063 Transfers from SSLGC Operating Dep 1,600,000 600,000 300,000 1,196,669 600,000 Intragovemmental Transfers Totals 1,600,000 600,000 300,000 1,196,669 600,000 SSLGC REPAIR/REPLACEMENT FUND TOTALS 1,606,208 6051950 302,681 1,200,769 603,100 -Page 17- c r a k es iz ( 0 Cf z 2022 -23 Budget - L G C A L G O V E R N M E N T C O R P O R A T I O N Repair /Replacement Fund Expenditures Account Number Account Name FY 2021 FY 2022 FY 2022 FY 2022 FY2023 061- SSLGC- REPAIR/REPLACEMENT FUND Actual Budget 03/31/22 Estimates Budget 90 - Non Departmental 43 - Repair and Maintenance 061 - 9000 - 434600 L&I Maint: Dist. System 219,891 400,000 107,930 438,521 800,000 43 - Repair and Maintenance Totals: 219,891 400,000 107,930 438,521 8001000 70 - Capital Outlay 061 -9000- 703000 Improvements Other Than Buildings 709,617 2,241,584 185,184 986,553 2,593,934 70 - Capital Outlay Totals: 709,611 2,241,584 185,184 966,553 2,593,934 96 - Use of Retained Earnings 058.9800.960000 Use of Retained Earnings 96 - Use of Retained Earnings Totals: SSLGC- REPAIR/REPLACEMENT FUND TOTALS 0 0 0 (224,305) (2,790,834) 0 0 0 (224,305) (2,790,834) 929,508 2,641,584 -Page 18- 293,114 1,200,769 603,100 SSLGC SSLGC FUTURE DEVELOPMENT FUND - 062 2022/23 ANNUAL BUDGET SCHERTZ/SEGUIN LOCAL GOVT. CORP. The SSLGC Future Development Fund was a fund created prior to SSLGC collecting Impact Fees. The Future Development Fund is now utilized for items contributing to the development and improvement of the SSLGC water system that do not qualify for Repair and Replacement Fund use or Impact Fee Fund use. -Page 19- (0 crag";#L 6 0 C A L G O V E R N M E N T C 0 A P 0 R A 7 1 0 N Account Number Account Name 062 - SSLGC FUTURE DEVELOPMENT FUND Revenue FY2023 Interest Revenues Budget 062 - 361002 Investment Pools Interest Earnings 062 - 361004 Texas CLASS Interest Earnings 062 - 361020 Restricted Cash Interest Revenues Totals: 50 Miscellaneous Revenues 062 - 362078 Solar Power Project Miscellaneous Revenues Totals: 2022 -23 Budget - SSLGC Future Development Fund Revenues FY 2021 FY 2022 FY 2022 FY 2022 FY2023 Actual Budget 03/31/22 Estimates Budget 46 50 25 50 50 2,512 2,500 428 600 500 26 0 1,371 1,700 1,500 2,584 2,550 1,824 2,350 2,050 227,700 0 0 224,590 424,106 227,700 0 0 224,590 424,106 Intragovernmental Transfers 062 - 391063 Transfers from SSLGC Operating Furo 250,000 250,000 125,000 250,000 0 Intragoveremental Transfers Totals: 250000 250,000 125,000 250,000 0 062 - SSLGC FUTURE DEVELOPMENT FUND TOTALS 480,284 252,550 126,824 476,940 426,156 -Page 20- cr"Mftim * cravuzft L O C A L G O V E R N M E N T C O R P O R A T I O N 2022 -23 Budget -SSLGC Future Development Fund Expenditures Account Number Account Name FY 2021 FY 2022 FY 2022 FY 2022 FY2023 062 - SSLGC FUTURE DEVELOPMENT FUND Actual Budget 03/31/22 Estimates Budget 90 - Non Departmental 32 - Professional Services 062- 9000 - 320500 Professional Services 154,588 386,000 175,520 333,491 362,746 32 - Professional Services Totals: 154,588 386,000 175,520 333,491 362,746 70 - Capital Outlay 062 - 9000. 702000 Buildings 8,184 0 0 0 0 062 - 9000 - 703000 Improvements Other Than Building 241,293 0 4,453 13,993 2,020,079 70 - Capital Outlay Totals: 249,477 0 4,453 13,993 2,020,079 96 - Use of Retained Earnings 058-9800- 960000 Use of Retained Earnings 96 - Use of Retained Earnings Totals: 0 0 0 0 (1,956,669) 0 0 0 0 (1,956,669) SSLGC FUTURE DEVELOPMENT FUND TOTALS 404,065 386,000 179,973 347,4B4 426,156 -Page 21- SSLGC SSLGC IMPACT FEE FUND - 065 2022/23 ANNUAL BUDGET SCHERTZ/SEGUIN LOCAL GOVT. CORP. The SSLGC Impact Fee fund is utilized to help pay for the expansion and additional capacity required of water supply, treatment facilities, pump stations and storage tanks. Impact fees are collected through a one -time charge imposed on new development in the City of Schertz and the City of Seguin to help recover capital costs associated with SSLGC providing the infrastructure and other required improvements to provide service to that new development. Land use assumptions and capital improvements to be included in the impact fee calculations are updated and reviewed every five years with the last update being in 2018. -Page 22- cr"wtix (' CrMflaft L O C A L G O V E R N M E N T C O R P O R A T I O N Account Number Account Name 065 - SSLGC IMPACT FUND FY 2022 Revenue Actual Utility 03/31/22 065 - 343013 Water Impact Fee Utility Totals: _ 600,000 _ Interest Revenues 650,000 065- 361002 Investment Pools Interest Earnings 065 - 361004 Texas CLASS Interest Earnings 065- 361020 Restricted Cash Interest Revenues Totals: 1,000 SSLGC IMPACT FUND TOTALS 2022 -23 Budget -SSLGC Impact Fee Fund Revenues FY 2021 FY 2022 FY 2022 FY 2022 FY2023 Actual Budget 03/31/22 Estimates Budget 659,802 _ 600,000 _ 295,592 650,000 600,000 659,802 600,000 295,592 6501000 6001000 1,221 1,000 724 1,000 750 3,893 4,000 1,563 2,200 1,500 83 0 1,236 1,250 500 5,197 5,000 31523 4,450 2,750 664,999 605,000 299,115 654,450 602,750 -Page 23- ��� (A CFaWL&L L O C A L G O V E R N M E N T C O R P O R A T I O N 2022 -23 Budget -SSLGC Impact Fee Fund Expenditures Account Number Account Name FY 2021 FY 2022 FY 2022 FY 2022 FY2023 06S - SSLGC IMPACT FUND Actual Budget 03131 /22 Estimates Budget 90 - Non Departmental 32 - Professional Services 065 - 9000 - 320500 Professional Services 0 0 1,965 0 0 32 - Professional Services Totals: 0 0 1,965 0 0 70 - Capital Outlay 065 - 9000 - 703000 Impr. Other Than Building 979,117 2,150,000 100,538 104,393 5,600,289 70 - Capital Outlay Totals: 979,117 2,150,000 100,538 104,393 5,600,289 96 - Use of Retained Earnings 058- 9800 - 960000 Use of Retained Earnings 0 0 0 0 (4,997,539) 96 - Use of Retained Earnings Totals: 0 0 0 0 K997,S39) SSLGC IMPACT FUND TOTALS 979,117 2,150,000 102,503 104,393 602,750 -Page 24- SSLGC SSLGC RESERVE FUND - 066 2022/23 ANNUAL BUDGET SCHERTZ/SEGUIN LOCAL GOVT. CORP. The SSLGC Reserve Fund was established to maintain according to bond covenants. The covenants require a balance of the annual average debt service payment of the earlier bonds issued. -Page 25- cirrr (A cr 2022 -23 Budget -SSLGC Reserve LOCAL GOVERNMENT CORPORATION Fund Revenues Account Number Account Name FY 2021 FY 2022 FY 2022 FY 2022 FY2023 066 - SSLGC RESERVE FUND Actual Budget 03/31/22 Estimates Budget Revenue Interest Revenues 066.361002 Investment Pools Interest Earnings 334 250 177 300 200 066 - 361004 Texas CLASS Interest Earnings 778 800 769 925 700 066 - 361020 Restricted Cash 0 0 0 0 0 Interest Revenues Totals: 1,112 1,050 946 1,225 900 066 - SSLGC RESERVE FUND TOTALS 1,112 1,050 946 11225 900 -Page 26- SSLGC SSLGC RATE STABILIZATION FUND - 057 2022 /23 ANNUAL BUDGET SCHERTZ/SEGUIN LOCAL GOVT. CORP. The SSLGC Rate Stabilization Fund was created in 2017 by the SSLGC Board of Directors to be used in order to prepare for volatile periods which can greatly impact the rates of SSLGC water customers are charged and can be used to avoid passing along pricing peaks to these customers. These funds can only be used based upon staff recommendation and Board of Directors approval. The fund balance for the rate stabilization fund will be evaluated annually and any adjustments due to anticipated needs may be made by the Board of Directors. -Page 27- L O C A L C.FMkIchiX (0 crmwLlot G O V E R N M E N T C O R P O R A T I O N Account Number Account Name 057 - SSLGC Rabe Stabilization Fund Revenue Interest Revenues 057 - 361004 Texas CLASS Interest Earnings 057 - 361020 Restricted Cash Interest Revenues Totals: Intragovernmental Transfers 057- 391058 Transfers from SSLGC Operating Intragovemmental Transfers Totals: SSLGC Rabe Stabilisation Fund Totals: 1,633 1,500 1,574 2,510 2,010 0 0 0 300,000 0 0 0 0 300,000 0 1,633 11500 1,574 302,510 21010 -Page 28- 2022 -23 Budget -SSLGC Rate Stabilization Fund Reveues FY 2021 FY 2022 FY 2022 FY 2022 FY2023 Actual Budget 03/31/22 Estimates Budget 1,626 1,500 1,569 2,500 2,000 7 0 5 10 10 1,633 1,500 1,574 2,510 2,010 0 0 0 300,000 0 0 0 0 300,000 0 1,633 11500 1,574 302,510 21010 -Page 28- cr Acr L 0 C A l 0 0 V E A N M E N T C 0 R P 0 a A T 1 0 N 2022 -23 Budget -SSLGC Rate Stabilization Fund Expenditures Account Number Account Name FY 2021 FY 2022 FY 2022 FY 2022 FY2023 057 - SSLGC Rate Stabilization Fund Actual Budget 03/31/22 Estimates Budget 90 - Non Departmental 81- Contributions 057 - 9000 - 818000 Winter Weather Relief Credit 36,025 0 0 0 0_ 81- Contributions Totals: 36,025 0 0 0 0 SSLGC Rate Stabilization Fund Totals: 36,025 0 0 0 0 -Page 29- SSLGC SAWS I &S FUND - 069 2022/23 ANNUAL BUDGET SCHERTZ/SEGUIN LOCAL GOVT. CORP. The SAWS I &S Fund accounts for contributions from San Antonio Water Systems toward the payment of principal and interest of the SSLGC Contract Revenue Refunding Bonds, Series 2019. -Page 30- C_f C_r • L O C A L G O V E R N M E N T C O R P O R A T I O N 2022 -23 Budget -SAWS I &S Fund Revenues Account Number Amount Name FY 2021 FY 2022 FY 2022 FY 2022 FY2023 069 - SSL6C 18S - SAWS Actual Budget 03/31/22 Estimates Budget Revenue Interlocal Agreement 069 - 331690 Interlocal Agreement / San Antonio 1,512,787 1,390,974 435,432 1,390,974 1,391,188 Interlocal Agreement Totals: 1,512,787 1,390,974 435,432 1,390,974 11391,188 Interest Revenues 069- 361004 Texas CLASS Interest Earnings 489 500 165 200 150 069 - 361020 Restricted Cash (28) (40) 135 150 100 Interest Revenues Totals: 461 460 300 350 250 SSLGCI&S- SAWS Totals 1,513,248 1,391,434 435,732 1,391,324 1,391,438 -Page 31- crakehiz (A Cr"=Z#L L O C A L G O V E R N M E N T C O R P O R A T I O N 2022 -23 Budget SAWS I &S Fund Expenditures Account Number Account Name FY 2021 FY 2022 FY 2022 FY 2022 FY2023 069 - SSLGC 1&S - SAWS Actual Budget 03/31/22 Estimates Budget 92 - Debt Service 90 - Principal Payments 069 - 9200 - 909500 2019 SSLGC Refunding Bonds -SAWS 635,000 655,000 0 655,000 675,000 90 - Principal Payments Totals: 635,000 655,000 0 655,000 675,000 91- Interest Payments 069 - 9200 - 919500 2019 SSLGC Refunding Bonds -SAWS 755,975 733,450 371,638 733,450 715,188 91- Interest Payments Totals: 755,975 733,450 371,638 733ASO 715,188 92 - Fiscal Agent Fees 069 - 9200 - 920000 Fiscal Agent Fees 92 - Fiscal Agent Fees Totals: 415 11000 400 1,000 11000 415 11000 400 11000 11000 SSLGC I&S - SAWS Totals: 1,391,390 1,389,450 372,038 1,389,450 1,391,188 -Page 32- FY2023 -2027 Capital Improvement Projects /Equipment 5 -Year Plan -Page 33- Funding F'Y Project Projected Cost Approved Funding Source 2023 1 Pressure Tank Painting (Hal Baldwin Pump Station) $87,790 $87,790 RR 2 Well Lowering Project $1,071,384 $594,984 RR 3 Pressure Filter Rehab Project $1,370,065 $633,745 RR 4 Light Fixture Repair and Replacement - Gonzales Water Treatment Plant $25,000 $25,000 RR 5 Water Transmission Lines $25,000 $25,000 RR 6 High Service Pumps and Motors $300,000 $300,000 RR 7 Wells Repair and Replacement $500,000 $500,000 RR 8 Gonzales High Service Pump Room #1 Expansion Project - 2 Additional Pumps and Starters (2021 Water Model) $2,034,000 $2,034,000 IF 9 Gonzales Surge Analysis and Surge Tank Installation (2021 Water Model) $900,000 $900,000 IF 10 Guadalupe Project Additional Funds $4,650,000 $2,650,000 IF $2,000,000 FD 11 Solar Project (land surveys) $50,000 $50,000 FD 12 Emergency Preparedness Plan Implementation - Emergency Generators /GVEC Electric Feeds $2,000,000 $2,000,000 Bonds 13 Cowey (42" Guadalupe WTP to Surge Tank) & Elm Creek (36" FM 467 Vault to Hal Baldwin Pump Station) Pipeline Projects (Engineering & Easement Acquisition) $4,500,000 $4,500,000 Bonds /IF 14 Mach. & Equip. - Small Equipment (trailer replacement) $10,000 $10,000 FY23 TOTAL $17,523,239 $16,310,519 2024 1 Well Lowering Project $1,103,209 $1,103,209 RR 2 Pressure Filter Rehab Project $758,409 $758,409 RR 3 Emergency Preparedness Plan Implementation - Emergency Generators /GVEC Electric Feeds $2,000,000 $2,000,000 Bonds 4 Water Transmission Lines $25,750 $25,750 RR 5 High Service Pumps and Motors $309,000 $309,000 RR 6 Wells Repair and Replacement $515,000 $515,000 RR 7 Mach. & Equip. - Office (video surveillance at Gonzales WTP and Hal Baldwin Pump Station) $48,300 $48,300 FY24 8 Automatic Gate Installation at Gonzales WTP $58,800 $58,800 FY24 9 Pipeline Condition Assessment Phase 1- 42" Gonzales WTP to Surge Tank $1,035,000 $1,035,000 FY24 TOTAL $5,853,468 $5,853,468 2025 1 Well Lowering Project $1,136,305 $1,136,305 RR 2 Pressure Filter Rehab Project $781,161 $781,161 RR 3 Emergency Preparedness Plan Implementation - Emergency Generators /GVEC Electric Feeds $2,000,0001 $2,000,0001 Bonds -Page 33- FY2023 -2027 Capital Improvement Projects /Equipment 5 -Year Plan SSLGC = Schert: /Seguin Local Government Corporation Bonds - New Utility Revenue Bond Issue SWIFT Bonds - TWDB Existing Bond Funding FY23 - Current Year Funding IF - Water Impact Fund RR- Repair & Replacement Fund FD- Future Development Fund -Page 34- Funding _ FY Project Projected Cost Approved Funding Source 4 Cowey (42" Guadalupe WTP to Surge Tank) & Elm Creek (36" 467 Vault to Hal Baldwin Pump Station) Parallel Pipeline Projects (Construction) $24,500,000 $24,500,000 Bonds/IF' 5 Water Transmission Lines $26,523 $26,523 RR 6 High Service Pumps and Motors $318,270 $318,270 RR 7 Wells Repair and Replacement $530,450 $530,450 RR 8 Pipeline Condition Assessment Phase 2 - 42" and 36" Surge Tank to Hal Badwin Pump Station $749,000 $749,000 FY25 TOTAL $30,041,709 $30,041,709 2026 1 Well Lowering Project $1,170,394 $1,170,394 RR 2 Road Seal Coat (Gonzales WTP) $76,800 $76,800 RR 3 Gonzales Water Treatment Plant Clearwell 1 Painting $326,848 $326,848 RR 4 BPS Tank 2 Painting $515,933 $515,933 RR 5 Emergency Preparedness Plan Implementation - Emergency Generators /GVEC Electric Feeds $2,000,000 $2,000,000 Bonds 6 Water Transmission Lines $27,318 $27,318 RR 7 Pumps and Motors $327,818 $327,818 RR 8 Wells Repair and Replacement $546,364 $546,364 RR' 9 Pipeline Condition Assessment Phase 3 - 30" FM 467 Vault to Seguin $480,675 $480,675 FY26 TOTAL $5,472,150 $5,472,150 2027 1 Additional Surge/Storage Tank $756,000 $756,000 IF 2 Emergency Preparedness Plan Implementation - Emergency Generators /GVEC Electric Feeds $2,000,000 $2,000,000 Bonds 3 Water Transmission Lines $28,138 $28,138 RR 4 Pumps and Motors $337,653 $337,653 RR 5 Wells Repair and Replacement $562,754 $562,754 RR 6 Pipeline Condition Assessment Phase 4 - 36" Hal Baldwin Pump Station to Marion $855,000 $855,000 FY27 TOTALI $4,539,545 $4„539,545 FY2023 -2027 Total $63,430,110 $63,430,110 SSLGC = Schert: /Seguin Local Government Corporation Bonds - New Utility Revenue Bond Issue SWIFT Bonds - TWDB Existing Bond Funding FY23 - Current Year Funding IF - Water Impact Fund RR- Repair & Replacement Fund FD- Future Development Fund -Page 34-