The URL can be used to link to this page

Home My WebLink About2023-0215 February 15,2023 Regular Meeting Agenda PacketSPA TROPHY CLUB MUNICIPAL / UTILITY DISTRICT BOARD OF DIRECTORS REGULAR MEETING February 15, 2023 Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 100 MUNICIPAL DRIVE TROPHY CLUB, TEXAS 76262 Wednesday, February 15, 2023 6:30 P.M. Svore Municipal Boardroom REGULAR MEETING AGENDA CALL TO ORDER AND ANNOUNCE A QUORUM CITIZEN COMMENTS This is an opportunity for citizens to address the Board on any matter whether or not it is posted on the agenda. The Board is not permitted to take action on or discuss any comments made to the Board at this time concerning an item not listed on the agenda. The Board will hear comments on specific agenda items prior to the Board addressing those items. You may speak up to four (4) minutes or the time limit determined by the President or presiding officer. To speak during this item, you must complete the Speaker's form that includes the topic(s) of your statement. Citizen Comments should be limited to matters over which the Board has authority. REPORTS & UPDATES 1. Staff Reports a. Capital Improvement Projects b. Water Operations Report c. Wastewater System Reports d. Finance Reports Attachments: Staff Reports CONSENT AGENDA All matters listed as Consent Agenda are considered to be routine by the Board of Directors and will be enacted by one motion. There will not be a separate discussion of these items. If discussion is desired, that item will be removed from the consent agenda and will be considered separately. 2. Consider and act to approve the Consent Agenda. a. January 2023 Combined Financials b. January 18, 2023 Regular Meeting Minutes Attachments: January Financials January 18, 2023 Meeting Minutes REGULAR SESSION 3. Discussion and possible action regarding customer deposits. (Carr) 1of32 February 15, 2023 Agenda Packet Attachment: Staff Report 4. Discussion and possible action regarding District Reserve Policy (Rose) Attachment: Reserve Charts 5. Receive update from Strategic Committee. (Carr/Brewster) EXECUTIVE SESSION 6. Pursuant to Section 551.071 of the Texas Open Meetings Act, the Board may consult with its attorney in Executive Session on a matter in which the duty of the attorney to the Governmental Body under the Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflicts with the Open Meetings Act or to seek advice of counsel on legal matters involving pending or contemplated litigation or settlement offers: a. Consult with legal counsel to secure legal advice concerning joint strategic planning with the Town of Trophy Club. REGULAR SESSION 7. Consider and act regarding items discussed in Executive Session. 8. Discussion and possible action regarding approval of publication for Request for Qualifications (RFQ) for general legal counsel. (Brewster) 9. Items for future agendas: 10. Set future Meeting dates - March 22, 2023 at 6:30 p.m. Attachment: March Meeting Calendar *THE BOARD RESERVES THE RIGHT TO ADJOURN INTO EXECUTIVE SESSION AT ANY TIME DURING THE MEETING PURSUANT TO THE APPLICABLE SECTION OF SUBCHAPTER D, CHAPTER 551, TEXAS GOVERNMENT CODE, THE TEXAS OPEN MEETINGS ACT, WITH RESPECT TO ANY ITEM ON THE AGENDA. NO FINAL ACTION, DECISION OR VOTE WILL BE TAKEN ON ANY SUBJECT OR MATTER IN EXECUTIVE SESSION. THIS NOTICE MODIFIES THE DISTRICTS PRIOR PRACTICE OF SPECIFICALLY IDENTIFYING ALL AGENDA ITEMS TO BE DISCUSSED IN EXECUTIVE SESSION. ADJOURN 2 of 32 15,1 TROPHY CLUB MUNICIPAL UTILITY DISTRICT February 15, 2023 Agenda Packet Capital Improvement Projects • FY 2022 Water Line Project — Final punch list items have been completed along Creek Courts Drive and Wilshire Drive. Contingency allowances will be utilized to replace five service lines on Hilltop Court, two service lines on Oak Hill Drive, and one three-inch service line on Village Circle in Solana, which are expected to be completed within the next few weeks. • FY 2023 Water Line Project — Design is in progress for the replacement of approximately 6,000 linear feet of water lines along and adjacent to Sunset Drive, Berkshire Court, Lee Court, Riviera Court, and Skyline Drive as a part of FY 2023 Capital Improvement Projects. The design is 90% complete and bidding is scheduled for March 2023. • Pump Station Improvement Project — Design is in progress for the replacement of two (2) vertical turbine pumps, incorporation of variable frequency drives, and replacement of discharge header piping and valves within the high service pump station. The design is 60% complete and bidding is scheduled for July 2023. • Supervisory Control and Data Acquisition (SCADA) Upgrades — The new system is in full operation and hardware has been installed to provide redundancy between the water and wastewater facilities. • Membrane Bioreactor (MBR) Piping Improvements — Materials have been ordered and construction will commence at the wastewater treatment plant once received. The expected project completion is June 2023. • Lift Station #1 — The cleaning and sand blasting of the wet well is complete. Grouting and epoxy coating the wet well was delayed due to weather. Installation of pump rails, pumps, pipe, valves, instrumentation, and electrical panels will begin once the wet well is coated, and concrete is complete. Most of this work is expected to be performed in February. • Lift Station Generators — This project consists of installation of onsite diesel generators and automatic transfer switches at eight (8) lift station sites allowing for further resiliency within the wastewater collections system during power outages. Notice to Procure was provided to the contractor in November 2022. Delivery of the generators is scheduled for December 2023 with an anticipated completion date of April 2024. The schedule to begin underground and sitework will be dependent on the generator delivery dates. 3 of 32 15,1 TROPHY CLUB MUNICIPAL UTILITY DISTRICT February 15, 2023 Agenda Packet • FY 2023 Wastewater Improvements — Proposals are being obtained to complete recommended rehabilitation and repairs resulting from the annual wastewater system analysis performed in FY 2022. • FY 2023 Lift Station Improvements — Replacement of piping and valves at Lift Station #2 has been completed. Materials for Lift Station #3 have been received and the replacement schedule is in progress. • Southlake emergency connection — An evaluation was performed to determine the feasibility of an emergency connection of the District water system to the City of Southlake water system. An emergency connection between the District and Southlake water systems is intended to allow the District to meet customer demands in emergency scenarios where the District requires supplemental water supply if the District's primary water supply being unavailable or the occurrence of significant pipe break(s). It is anticipated that the Southlake system can provide the service capacities to the District system at the emergency connection; however, Southlake plans to perform a Water Master Plan Update that will more accurately determine the impact of this emergency connection on their system, and further confirm that an emergency demand could be met. This is expected to be completed in the fall of 2023. 4 of 32 160,000 140,000 120,000 100,000 80,000 60,000 40,000 20,000 0 IM Water Billed February 15, 2023 Agenda Packet -2019 -2020 -2021 -2022 -2023 FY October November December January February March April May June July August September Total Year 2014 82,660 48,813 34,482 39,767 37,085 54,794 66,337 84,384 99,240 92,913 113,135 110,873 864,483 2015 90,994 58,986 49,607 36,162 38,776 30,566 46,543 39,576 60,731 100,622 139,441 123,886 815,890 2016 108,951 41,936 39,028 39,622 44,551 49,498 55,181 50,827 65,390 115,687 119,611 98,945 829,227 2017 74,785 68,638 38,580 33,028 38,380 60,841 56,683 86,794 98,864 95,355 104,303 99,541 855,792 2018 83,228 69,099 48,144 34,592 40,658 43,411 60,079 89,802 118,899 126,588 125,531 73,735 913,766 2019 47,193 41,933 36,244 34,604 33,740 40,421 55,970 42,773 70,747 96,174 131,472 114,784 746,055 2020 102,150 40,988 43,946 36,418 31,000 34,047 53,755 67,030 96,195 123,309 118,522 83,570 830,930 2021 98,232 57,380 40,841 42,725 40,786 41,078 67,776 50,736 64,195 100,853 97,864 112,674 815,140 2022 78,390 54,635 48,488 49,322 40,021 44,588 72,448 85,474 119,711 141,177 143,845 108,377 986,476 2023 101,683 49,007 52,466 57,576 260,732 160,000 140,000 120,000 100,000 80,000 60,000 40,000 20,000 0 Water Pumped FY October November December January February March April May June July August September Total Year 2014 81,909 51,769 39,769 48,758 42,395 61,100 71,283 96,481 95,206 110,173 123,369 115,607 937,819 2015 106,251 67,825 58,659 45,691 39,675 35,752 56,704 48,637 72,934 117,302 143,413 142,394 935,237 2016 106,731 52,616 43,708 46,945 50,721 55,178 60,434 55,562 68,138 112,533 128,963 104,664 886,193 2017 82,677 77,937 43,792 43,207 43,024 69,549 65,723 94,452 103,867 101,184 114,872 109,769 950,053 2018 91,439 78,282 55,745 40,796 40,750 51,711 67,217 97,980 124,109 155,354 144,015 85,946 1,033,344 2019 60,576 53,119 45,651 45,552 39,014 43,048 61,238 48,787 79,167 102,887 144,299 130,752 854,090 2020 112,971 48,627 49,384 40,726 35,749 38,576 57,714 74,153 106,219 136,306 130,721 89,514 920,660 2021 106,660 66,304 46,962 50,538 47,733 44,191 75,866 56,985 73,907 113,015 109,492 123,206 914,859 2022 91,078 61,928 54,930 52,679 49,094 51,606 81,977 92,915 133,828 152,199 161,534 117,252 1,101,020 2023 114,089 54,777 57,827 57,758 284,451 5 of 32 7 6 5 0 7 4 0 2 2 0 • Min • Max • Avg 20.0 18.0 16.0 14.0 12.0 10.0 8.0 6.0 4.0 2.0 0.0 February 15, 2023 Agenda Packet Water Production Jan -22 1.750 1.650 1.550 1.450 1.350 1.250 1.150 1.050 0.950 0.850 0.750 Jan -22 1.300 3.260 1.659 Feb -22 Mar -22 Apr -22 Feb -22 1.422 1.873 1.554 Mar -22 Apr -22 1.407 1.686 2.942 3.593 1.926 2.603 May -22 May -22 1.660 4.685 3.325 Jun -22 Jun -22 3.173 5.767 4.183 Jul -22 Jul -22 3.915 7.100 5.748 Wastewater Treated Aug -22 Aug -22 2.348 7.325 4.704 Sep -22 Sep -22 1.889 5.277 3.948 I I .11 Ih Oct -22 Nov -22 Oct -22 1.842 5.00 3.662 Nov -22 1.401 2.57 1.834 Dec -22 Jan -23 Dec -22 Jan -23 1.115 1.225 2.72 2.51 1.657 1.759 ■ � �� ■� 1� 1� I� ■I II I I I Jan -22 Jan -22 Feb -22 Mar -22 Apr -22 May -22 Jun -22 Jul -22 Aug -22 Daily Avg Flow Daily Max Flow -Daily Avg Max Feb -22 Mar -22 Sep -22 Carbonaceous Biochemical Oxygen Demand (CBOD) Apr -22 May -22 Jun -22 Jul -22 Oct -22 Nov -22 Aug -22 Sep -22 Oct -22 Nov -22 CBOD Avg - CBOD Max Daily Avg Max -Daily Max 6 of 32 Dec -22 Jan -23 J Dec -22 Jan -23 40.0 35.0 30.0 25.0 20.0 15.0 10.0 5.0 0.0 10.00 9.00 8.00 7.00 6.00 5.00 4.00 3.00 2.00 1.00 0.00 Jan -22 Feb -22 Mar -22 Apr -22 Total Suspended Solids (TSS) May -22 Jun -22 Jul -22 Aug -22 TSS Avg .TSS Max -Daily Avg Max -Daily Max Ammonia Nitrogen (NH3) Jan -22 Feb -22 Mar -22 Apr -22 May -22 Jun -22 Jul -22 Aug -22 50.0 40.0 30.0 20.0 10.0 0.0 M Jan -22 NH3 Avg :NH3 Max Daily Avg Max -Daily Max Nitrate -Nitrogen (NO3) Sep -22 February 15, 2023 Agenda Packet Oct -22 Nov -22 Sep -22 Oct -22 Nov -22 Dec -22 Jan -23 Dec -22 Jan -23 Feb -22 Mar -22 Apr -22 May -22 Jun -22 Jul -22 Aug -22 Sep -22 Oct -22 Nov -22 Dec -22 Jan -23 NO3 Avg NO3 Max -Daily Avg Max -Daily Max 7 of 32 9 8.5 8 7.5 7 6.5 6 9.0 8.5 8.0 7.5 7.0 6.5 6.0 400 350 300 250 200 150 100 50 0 Potential of Hydrogen (pH) February 15, 2023 Agenda Packet 11111111111 Ilinilli Jan -22 Feb -22 Mar -22 Apr -22 May -22 Jun -22 Jul -22 Aug -22 Sep -22 Oct -22 Nov -22 Dec -22 Jan -23 pH Min pH Max pH Avg -Daily Avg Min -Daily Avg Max Dissolved Oxygen (DO) Jan -22 Feb -22 Mar -22 Apr -22 May -22 Jun -22 Jul -22 Aug -22 Sep -22 Oct -22 Nov -22 Dec -22 Jan -23 1.0 5.2 Jan -22 Feb -22 DO Min DO Max DO Avg -Daily Avg Min -Daily Avg Max Escherichia coli (E. coli) *Sep -22 is an outlier sample 1.0 1.0 1.0 1.0 1.0 2.0 Mar -22 Apr -22 May -22 Jun -22 307.0 3.0 1.0 6.3 2.0 Jul -22 Aug -22 *Sep -22 Oct -22 Nov -22 Dec -22 Jan -23 E. coli Avg E. coli Max -Daily Avg Max -Daily Max 8 of 32 February 15, 2023 Agenda Packet Check Report Trophy Club Municipal Utility District No. 1 By Check Number Date Range: 01/01/2023 - 01/31/2023 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number Bank Code: Prosperity Bank -Prosperity Bank Payment Type: Regular 2970 Air Mac 01/06/2023 Regular 0.00 552.00 9247 3197 BenefitMall 01/06/2023 Regular 0.00 52.00 9248 2497 DHS Automation Inc 01/06/2023 Regular 0.00 21,660.00 9249 3118 Exclusive Pest Control 01/06/2023 Regular 0.00 355.00 9250 3093 Four Man Furnace Inc. 01/06/2023 Regular 0.00 2,983.75 9251 4033 Health Care Service Corporation 01/06/2023 Regular 0.00 21,649.11 9252 2943 JP Morgan Chase Bank NA 01/06/2023 Regular 0.00 14,667.85 9253 3216 M3 Networks 01/06/2023 Regular 0.00 669.00 9257 3115 Metlife Group Benefits 01/06/2023 Regular 0.00 470.20 9258 2842 Omnisite 01/06/2023 Regular 0.00 290.00 9259 3110 Pump Solutions Inc 01/06/2023 Regular 0.00 4,680.00 9260 3156 Southern Petroleum Lab Inc 01/06/2023 Regular 0.00 988.80 9261 2696 Texas Excavation Safety System 01/06/2023 Regular 0.00 180.50 9262 1000 Trophy Club Mud (Water Bills) 01/06/2023 Regular 0.00 451.90 9263 2798 Tyler Technologies Inc 01/06/2023 Regular 0.00 5,591.30 9264 2634 Valley Solvents & Chemicals 01/06/2023 Regular 0.00 1,628.45 9265 2772 Allied Waste Industries 01/18/2023 Regular 0.00 7,920.53 9266 3127 Allied Welding Supply Inc. 01/18/2023 Regular 0.00 19.21 9267 1005 Atlas Utility Supply Co. 01/18/2023 Regular 0.00 3,676.54 9268 2738 Community National Title LLC 01/18/2023 Regular 0.00 1,126.47 9269 3184 Dataprose LLC 01/18/2023 Regular 0.00 2,402.00 9270 1179 Denton County Tax Office 01/18/2023 Regular 0.00 30.25 9271 1737 DPC Industries Inc. 01/18/2023 Regular 0.00 1,557.08 9272 2606 Fisery Solutions LLC 01/18/2023 Regular 0.00 50.00 9273 2796 Garver 01/18/2023 Regular 0.00 1,558.17 9274 1372 Hach Company 01/18/2023 Regular 0.00 1,768.04 9275 2635 Halff Associates Inc. 01/18/2023 Regular 0.00 3,515.66 9276 2775 Hudson Energy Services LLC 01/18/2023 Regular 0.00 23,370.55 9277 3278 Kyocera Document Solutions 01/18/2023 Regular 0.00 120.79 9278 2754 Lower Colorado River Authority 01/18/2023 Regular 0.00 213.92 9279 2643 Mclean & Howard LLP 01/18/2023 Regular 0.00 2,775.00 9280 2983 NTTA 01/18/2023 Regular 0.00 44.79 9281 1056 Office Depot Inc 01/18/2023 Regular 0.00 604.30 9282 1466 Polydyne, Inc 01/18/2023 Regular 0.00 4,046.85 9283 3176 Rey -Mar Construction 01/18/2023 Regular 0.00 252,606.40 9284 2698 Ritz Safety LLC 01/18/2023 Regular 0.00 123.55 9285 3156 Southern Petroleum Lab Inc 01/18/2023 Regular 0.00 1,455.60 9286 3182 Strategic Government Resources 01/18/2023 Regular 0.00 630.00 9287 2659 Tarrant Appraisal District 01/18/2023 Regular 0.00 2,609.26 9288 2440 Tarrant County Public Health Laboratory 01/18/2023 Regular 0.00 520.00 9289 1081 Tri County Electric 01/18/2023 Regular 0.00 800.34 9290 2798 Tyler Technologies Inc 01/18/2023 Regular 0.00 5,563.60 9291 2858 Utility Service Co, Inc. 01/18/2023 Regular 0.00 46,558.26 9292 2634 Valley Solvents & Chemicals 01/18/2023 Regular 0.00 846.05 9293 1058 Verizon Wireless 01/18/2023 Regular 0.00 857.12 9294 2222 Aflac 01/30/2023 Regular 0.00 405.80 9296 2970 Air Mac 01/30/2023 Regular 0.00 2,313.71 9297 3197 BenefitMall 01/30/2023 Regular 0.00 52.00 9298 1030 City of Fort Worth 01/30/2023 Regular 0.00 146,967.32 9299 1737 DPC Industries Inc. 01/30/2023 Regular 0.00 1,557.08 9300 1832 First Financial Bank 01/30/2023 Regular 0.00 98,078.79 9301 3258 Francotyp-Postalia, Inc. 01/30/2023 Regular 0.00 134.50 9302 2796 Garver 01/30/2023 Regular 0.00 30,021.77 9303 2/8/2023 6:04:21 PM Page 1 of 4 9 of 32 Check Report Vendor Number 1372 4033 3132 3195 2754 3216 3186 3115 2392 2760 3176 2698 2809 2805 2695 3156 2798 3225 2634 3280 Vendor Name Hach Company Health Care Service Corporation Legal Shield Lou's Gloves Incorporated Lower Colorado River Authority M3 Networks Member's Building Maintenance Metlife Group Benefits Mickey D Carson Dba/Nusco NDS Leasing Rey -Mar Construction Ritz Safety LLC Rod L Abbott CPA LLC Scott Tucker Construction LLC Southern Floors & Renovations Southern Petroleum Lab Inc Tyler Technologies Inc US Bank Voyager Fleet Systems Valley Solvents & Chemicals Watts Ellison LLC Payment Date 01/30/2023 01/30/2023 01/30/2023 01/30/2023 01/30/2023 01/30/2023 01/30/2023 01/30/2023 01/30/2023 01/30/2023 01/30/2023 01/30/2023 01/30/2023 01/30/2023 01/30/2023 01/30/2023 01/30/2023 01/30/2023 01/30/2023 01/30/2023 Payment Type Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Total Regular: February 15, 2023 Agenda Packet Date Range: 01/01/2023 - 01/31/2023 Discount Amount 0.00 472.74 9304 0.00 24,291.29 9305 0.00 34.90 9306 0.00 244.00 9307 0.00 213.92 9308 0.00 562.00 9309 0.00 1,289.80 9310 0.00 4,116.98 9311 0.00 5,709.00 9312 0.00 175.00 9313 0.00 13,205.00 9314 0.00 189.47 9315 0.00 11,451.39 9316 0.00 211,627.43 9317 0.00 7,421.30 9318 0.00 757.20 9319 0.00 2,928.00 9320 0.00 2,398.70 9321 0.00 2,658.40 9322 0.00 650.38 9323 0.00 1,014,168.06 Payment Amount Number 2/8/2023 6:04:21 PM Page 2 of 4 10of32 February 15, 2023 Agenda Packet Check Report Date Range: 01/01/2023 - 01/31/2023 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number Payment Type: Bank Draft 3197 BenefitMall 01/06/2023 Bank Draft 0.00 266.67 DFT0000029 3113 TCDRS 01/31/2023 Bank Draft 0.00 11,006.75 DFT0000030 3124 IRS Tax Payment 01/06/2023 Bank Draft 0.00 15,433.79 DFT0000031 3197 BenefitMall 01/20/2023 Bank Draft 0.00 266.67 DFT0000032 3113 TCDRS 01/31/2023 Bank Draft 0.00 9,868.93 DFT0000033 3124 IRS Tax Payment 01/20/2023 Bank Draft 0.00 13,575.20 DFT0000034 3113 TCDRS 01/31/2023 Bank Draft 0.00 526.65 DFT0000035 3124 IRS Tax Payment 01/20/2023 Bank Draft 0.00 754.93 DFT0000036 Total Bank Draft: 0.00 51,699.59 Bank Code Prosperity Bank Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 107 73 0.00 1,014,168.06 Manual Checks 0 0 0.00 0.00 Voided Checks 0 0 0.00 0.00 Bank Drafts 8 8 0.00 51,699.59 EFT's 0 0 0.00 0.00 115 81 0.00 1,065,867.65 2/8/2023 6:04:21 PM Page 3 of 4 11 of 32 Check Report February 15, 2023 Agenda Packet Date Range: 01/01/2023 - 01/31/2023 All Bank Codes Check Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 107 73 0.00 1,014,168.06 Manual Checks 0 0 0.00 0.00 Voided Checks 0 0 0.00 0.00 Bank Drafts 8 8 0.00 51,699.59 EFT's 0 0 0.00 0.00 115 81 0.00 1,065,867.65 Fund Summary Fund Name Period Amount 996 MUD Consolidated Cash 1/2023 1,065,867.65 1,065,867.65 2/8/2023 6:04:21 PM Page 4 of 4 12of32 CASH STATUS AS OF JANUARY 2023 135-10250 TexPool 0 & M (XXXXX0002)-General Fund Operating *** 135-10300 Prosperity Bank (XXX8701) General Fund Operating 135-10305 Prosperity Bank Reserve -Savings Acct (XXXXX7724) 135-11100 Petty Cash Administration 135-11150 Petty Cash Utility Billing 137-10250 TexPool 0 & M (XXXXX0002) GASB Replacement 519-10250 Texpool Revenue Bond Construction (XXXXX015) SWIFT 519-11155 Cash -Bond Escrow Bank of Texas (SWIFT) 520-10250 Texpool Revenue Bond Water & Waste Water Systems 2019 (XXXXX018) 520-10300 Prosperity Bank Construction Water & Waste Water Systems 2019 528-10250 TexPool Revenue Bond Reserve (XXXXX014) WWTP Improvements 533-10250 TexPool Tax I & S (XXXXX0003) 533-10300 Prosperity Bank (XXX8701) Tax I&S 534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements 535-10250 Texpool Revenue I & S (XXXXX017) SWIFT 536-10250 TexPool Revenue I & S (XXXXX020) Water & Waste Water Systems Amount available in cash for spending (MUD Accounts) *1/31/2023 Customer Water Deposits $328,185 Fire Department Cash 1122-10250 TexPool 0 & M (XXXXX0002)-Fire Operating Cash 122-10300 Prosperity Bank (XXX8701) Fire Operating Amount available in cash for spending (Fire Department Accounts) Total General Fund 135 Available for Spending General Fund 135 Fund Balances Nonspendable Fund Balance (Prepaids) Assigned Fund Balance (FY2023 Capital Projects plus prior year carry forward) Unassigned Fund Balance Current Year Revenue/Expenses Total Nonspendable, Assigned & Committed Fund Balances - General Fund 135 13 of 32 February 15, 2023 Agenda Packet Restricted - Unable to be spent $o $328,185 $1,895,730 $0 $0 $3,422,147 $0 $794,335 $1,289,991 $0 $911,864 $659,283 $0 $249,400 $107,388 $140,225 $o so Unrestricted - Available for spending $3,086,464 $4,652,519 $0 $150 $450 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $7,739,583 1 $0 1 $7,739,583 $1,349,157 $0 $1,349,157 $1,349,157 Total in Accounts (Restricted & Unrestricted) $3,086,464 $4,980,704 $1,895,730 $150 $450 $3,422,147 $0 $794,335 $1,289,991 $0 $911,864 $659,283 $0 $249,400 $107,388 $140,225 $17,538,131 General Fund 135 Available $ 4,652,519 Prosperity General Fund $ 3,086,464 Texpool General Fund $ 600 Petty Cash $ 7,739,583 $ 3,880 $ 4,770,878 $ 5,672,780 $ (200,938) $10,246,600 $1,349,157 $0 $1,349,157 February 15, 2023 Agenda Packet January Utility Billing Report Fiscal Year 2022 - 2023 January February March April May June July August September October November December January 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2023 e b i I I s 1,388 1,420 1,424 1,465 1,518 1,566 1,592 1,629 1,654 1,667 1,710 1,746 1,765 Bills Mailed 3,855 3,872 3,864 3,868 3,865 3,882 3,872 3,850 3,832 3,822 3,801 3,768 3,741 Bank Draft 668 670 671 676 692 700 697 704 703 706 711 630 606 Credit Card Draft 1,437 1,431 1,442 1,455 1,450 1,456 1,471 1,484 1,481 1,501 1,494 2,251 2,540 Online Payments 1,174 1,138 1,225 1,171 1,196 1,188 1,220 1,170 1,203 1,159 1,049 Late Notices 377 362 326 355 284 339 387 310 326 337 0 0 0 Disconnects 3 5 8 9 9 4 7 5 2 0 4 0 0 Connections MUD Connections PID 3398 3401 3402 3400 3400 3401 3401 3398 3399 3399 3399 3399 3394 1443 1443 1443 1443 1443 1443 1443 1443 1444 1444 1444 1444 1444 Date of Permit Permit No. January Permits Fiscal Year 2023 Customer Due to FW Oversize Plumbing Sewer Deposit Water Meter Inspections Inspections Fire Line Misc. Income Total $ Total $ - $ - $ - $ - $ - $ - $ - $ 14of32 February 15, 2023 Agenda Packet FY 2023 Combined Financials YTD as of 1/31/2023 YTD Revenues 1119 YTD Expenses Adopted Budget vs YTD Actuals Revenues & Expenses $3,383,474 $3,584,412 $11,733,354 $11,733,354 $1,212 538,952 0% 1% $596,056 17% $1,240,337 34% $1,707,854 48% YTD Expenses By Departments YTD Expense- Water YTD Expense- WW YTD Expense- Admin YTD Expense- BOD ■ YTD Expense- Non Dept Water Budget vs Actual 140,000,000 120,000,000 100,000,000 80,000,000 60,000,000 40,000,000 20,000,000 0 88,979,203 Water Consumption Budget vs Actual 101,683,000 41,702,881 49,007,000 52,466,000 41,572,326 —8—Budget Consumption —*-Actual Consumption Oct Nov Dec 57,576,000 36,351,669 Jan 1,000,000,000 900,000,000 800,000,000 700,000,000 600,000,000 500,000,000 400,000,000 300,000,000 200,000,000 100,000,000 0 Adopted Budget Water Consumption Vs Actual Water Consumption 808,128,121 Total Water Consumption • Budgeted Water Consumption • Projected Water Consumption Presented by: Finance Department 51,000,000 $900,000 5800,000 $700,000 $600,000 $500,000 $400,000 $300,000 $200,000 $100,000 50 Water Revenue Budget vs Actual 8365,714 —0—Budget Revenue --Actual Revenue Oct Nov Dec Jan $8,000,000 57,000,000 $6,000,000 55,000,000 $4,000,000 53,000,000 $2,000,000 $1,000,000 $0 Adopted Budget Water Revenue Vs Projected Water Revenue 56,710,979 $6,818,946 $4,070,848 $4,231,816 Total Water Revenue • Budgeted Water Revenue • Projected Water Revenue Net Budgeted Water Revenue Minus Budgeted Expenses • Net Projected Water Revenue Minus Projected Expenses 15of32 TGfPHV CLUB ME[NEG]AAL [lrILE7Y I][5711.I I:, Trophy Club Municipal Utility District No. 1 Fund: 135 - MUD 1 General Fund CURRENT MONTH ACTUAL BUDGETED VARIANCE REVENUE SUMMARY Revenue, Asset, Liability, & Equity 799,950.11 TOTAL REVENUE 799,950.11 EXPENSE SUMMARY Revenue, Asset, Liability, & Equity 0.00 Water 606,136.32 Wastewater 489,466.20 Board of Directors 115.61 Administration 130,815.61 Non Deparmental 16,835.65 TOTAL EXPENSE 1,243,369.39 REVENUE OVER/(UNDER) EXPENDITURE (443,419.28) 2/10/2023 12:52:55 AM 977,388.37 (177,438.26) 977,388.37 (177,438.26) 0.00 0.00 547,941.66 (58,194.66) 290,877.74 (198,588.46) 980.01 864.40 127,864.23 (2,951.38) 9,724.44 (7,111.21) 977,388.08 (265,981.31) 0.29 (443,419.57) YEAR TO DATE ACTUAL BUDGETED 3,383,474.08 3,909,553.48 3,383,474.08 3,909,553.48 0.00 0.00 1,707,854.17 2,191,766.64 1,240,336.76 1,163,510.96 1,212.44 3,920.04 596,055.84 511,456.92 38,952.49 38,897.76 3,584,411.70 3,909,552.32 February 15, 2023 Agenda Packet Budget Variance Report As Of: 01/31/2023 VARIANCE (526,079.40) 29 (526,079.40) 29 ANNUAL BUDGET TOTAL REMAINING % 11,733,354.00 (8,349,879.92) 71 11,733,354.00 (8,349,879.92) 71 0.00 0.00 483,912.47 26 6,577,932.00 (76,825.80) 36 3,491,931.00 2,707.60 10 11,765.00 (84,598.92) 39 1,534,986.00 (54.73) 33 116,740.00 325,140.62 31 11,733,354.00 (200,937.62) 1.16 (200,938.78) 16 of 32 0.00 (4,870,077.83) (2,251,594.24) (10,552.56) (938,930.16) (77,787.51) 74 64 90 61 67 8,148,942.30 69 0.00 (16,498,822.22) Page 1 of 1 Trophy Club Municipal Utility District No. 1 Fund: 135 - MUD 1 General Fund Revenue Department: 000 - Revenue, 135-000-40000-000 135-000-40002-000 135-000-40015-000 135-000-40025-000 135-000-47000-000 135-000-47005-000 135-000-47025-000 135-000-47030-000 135-000-47035-000 135-000-47045-000 135-000-47070-000 135-000-49011-000 135-000-49016-000 135-000-49026-000 135-000-49035-000 135-000-49036-000 135-000-49075-000 135-000-49900-000 Total Departme Expense Department: 010 - Water 135-010-50005-000 135-010-50010-000 135-010-50016-000 135-010-50017-000 135-010-50020-000 135-010-50026-000 135-010-50027-000 135-010-50028-000 135-010-50029-000 135-010-50030-000 2/10/2023 1:22:24 AM Asset, Liability, & Equity Property Taxes Property Taxes/Delinquent Property Taxes/P & I PID Surcharges Water Sewer Penalties Service Charges Plumbing Inspections Sewer Inspections TCCC Effluent Charges Interest Income Cell Tower Revenue Proceeds from Sale of Assets Prior Year Reserves GASB Reserves Oversize Meter Reimbursement Miscellaneous Income nt: 000 - Revenue, Asset, Liability, & Equity: Salaries & Wages Overtime Longevity Certification Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Social Security Taxes Total Revenue: January Budget January Activity Variance Favorable Percent (Unfavorable) Remaining YTD Budget February 15, 2023 Agenda Packet Monthly Budget Report Account Summary For Fiscal: Current Period Ending: 01/31/2023 YTD Activity Variance Favorable Percent (Unfavorable) Remaining Total Budget 7,326.73 30,181.59 22,854.86 311.94% 29,306.92 70,020.37 40,713.45 138.92% 87,956.00 24.99 52.81 27.82 111.32% 99.96 870.95 770.99 771.30% 300.00 24.99 49.79 24.80 99.24% 99.96 347.26 247.30 247.40% 300.00 12,080.91 0.00 -12,080.91 -100.00% 48,323.64 0.00 -48,323.64 -100.00% 145,029.00 559,024.55 424,444.64 -134,579.91 -24.07% 2,236,098.20 1,968,047.44 -268,050.76 -11.99% 6,710,979.00 319,845.84 624,201.21 304,355.37 95.16% 1,279,383.36 1,202,021.10 -77,362.26 -6.05% 3,839,686.00 6,497.40 0.00 -6,497.40 -100.00% 25,989.60 5,923.46 -20,066.14 -77.21% 78,000.00 466.48 0.00 -466.48 -100.00% 1,865.92 5,181.92 3,316.00 177.71% 5,600.00 24.99 0.00 -24.99 -100.00% 99.96 0.00 -99.96 -100.00% 300.00 8.33 0.00 -8.33 -100.00% 33.32 0.00 -33.32 -100.00% 100.00 4,998.00 -316,033.13 -321,031.13 -6,423.19% 19,992.00 11,810.40 -8,181.60 -40.92% 60,000.00 1,666.00 32,991.39 31,325.39 1,880.28% 6,664.00 111,128.24 104,464.24 1,567.59% 20,000.00 1,178.36 1,178.81 0.45 0.04% 4,713.44 4,715.24 1.80 0.04% 14,146.00 2,082.50 0.00 -2,082.50 -100.00% 8,330.00 391.30 -7,938.70 -95.30% 25,000.00 47,722.57 0.00 -47,722.57 -100.00% 190,890.28 0.00 -190,890.28 -100.00% 572,900.00 13,661.20 0.00 -13,661.20 -100.00% 54,644.80 0.00 -54,644.80 -100.00% 164,000.00 171.43 0.00 -171.43 -100.00% 685.72 0.00 -685.72 -100.00% 2,058.00 583.10 2,883.00 2,299.90 394.43% 2,332.40 3,016.40 684.00 29.33% 7,000.00 977,388.37 799,950.11 -177,438.26 -18.15% 3,909,553.48 3,383,474.08 -526,079.40 -13.46% 11,733,354.00 977,388.37 799,950.11 -177,438.26 -18.15% 3,909,553.48 3,383,474.08 -526,079.40 -13.46% 11,733,354.00 33,914.67 31,843.32 2,071.35 6.11% 135,658.68 125,682.66 9,976.02 7.35% 407,139.00 1,416.10 2,031.72 -615.62 -43.47% 5,664.40 4,845.52 818.88 14.46% 17,000.00 498.38 0.00 498.38 100.00% 1,993.52 0.00 1,993.52 100.00% 5,983.00 299.88 0.00 299.88 100.00% 1,199.52 0.00 1,199.52 100.00% 3,600.00 4,264.96 4,065.01 199.95 4.69% 17,059.84 15,716.99 1,342.85 7.87% 51,200.00 6,890.74 7,318.18 -427.44 -6.20% 27,562.96 24,551.92 3,011.04 10.92% 82,722.00 406.17 306.68 99.49 24.49% 1,624.68 1,322.56 302.12 18.60% 4,876.00 62.05 63.32 -1.27 -2.05% 248.20 206.42 41.78 16.83% 745.00 199.92 421.71 -221.79 -110.94% 799.68 1,544.59 -744.91 -93.15% 2,400.00 2,240.02 2,077.32 162.70 7.26% 8,960.08 7,948.70 1,011.38 11.29% 26,891.00 17 of 32 Page 1 of 7 February 15, 2023 Agenda Packet Monthly Budget Report For Fiscal: Current Period Ending: 01/31/2023 Variance Variance January January Favorable Percent YTD YTD Favorable Percent Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget 135-010-50035-000 Medicare Taxes 523.87 485.82 38.05 7.26% 2,095.48 1,658.96 436.52 20.83% 6,289.00 135-010-50040-000 Unemployment Taxes 104.95 32.04 72.91 69.47% 419.80 32.04 387.76 92.37% 1,260.00 135-010-50045-000 Workman's Compensation 937.04 1,109.40 -172.36 -18.39% 3,748.16 4,437.60 -689.44 -18.39% 11,249.00 135-010-50060-000 Pre-emp Physicals/Testing 33.32 0.00 33.32 100.00% 133.28 0.00 133.28 100.00% 400.00 135-010-50070-000 Employee Relations 24.99 0.00 24.99 100.00% 99.96 132.95 -32.99 -33.00% 300.00 135-010-55080-000 Maintenance & Repairs 19,142.34 13,620.40 5,521.94 28.85% 76,569.36 39,703.18 36,866.18 48.15% 229,800.00 135-010-55085-000 Generator Maint. and Repair 166.60 0.00 166.60 100.00% 666.40 875.96 -209.56 -31.45% 2,000.00 135-010-55090-000 Vehicle Maintenance 416.50 285.43 131.07 31.47% 1,666.00 1,255.73 410.27 24.63% 5,000.00 135-010-55105-000 Maintenance-Backhoe/SkidLoader 83.30 0.00 83.30 100.00% 333.20 0.00 333.20 100.00% 1,000.00 135-010-55120-000 Cleaning Services 208.25 161.23 47.02 22.58% 833.00 644.91 188.09 22.58% 2,500.00 135-010-55135-000 Lab Analysis 624.75 653.92 -29.17 -4.67% 2,499.00 1,253.92 1,245.08 49.82% 7,500.00 135-010-55135-001 Lab Analysis for PID 166.60 80.00 86.60 51.98% 666.40 240.00 426.40 63.99% 2,000.00 135-010-60010-000 Communications/Mobiles 624.75 479.79 144.96 23.20% 2,499.00 1,822.73 676.27 27.06% 7,500.00 135-010-60020-000 Electricity 19,013.22 8,720.19 10,293.03 54.14% 76,052.88 36,139.66 39,913.22 52.48% 228,250.00 135-010-60066-000 Publications/Books/Subscripts 83.30 0.00 83.30 100.00% 333.20 0.00 333.20 100.00% 1,000.00 135-010-60080-000 Schools & Training 302.37 0.00 302.37 100.00% 1,209.48 1,131.88 77.60 6.42% 3,630.00 135-010-60100-000 Travel & per diem 78.13 44.79 33.34 42.67% 312.52 44.79 267.73 85.67% 938.00 135-010-60135-000 TCEQ Fees & Permits 2,499.00 51.38 2,447.62 97.94% 9,996.00 15,883.03 -5,887.03 -58.89% 30,000.00 135-010-60135-001 TCEQ Fees & Permits for PID 0.00 213.92 -213.92 0.00% 0.00 213.92 -213.92 0.00% 0.00 135-010-60150-000 Wholesale Water 219,922.99 146,967.32 72,955.67 33.17% 879,691.96 534,851.98 344,839.98 39.20% 2,640,132.00 135-010-60285-000 Lawn Equipment & Maintenance 1,041.25 0.00 1,041.25 100.00% 4,165.00 600.00 3,565.00 85.59% 12,500.00 135-010-60332-000 Interfund Transfer Out -Rev I&S 47,296.24 51,616.66 -4,320.42 -9.13% 189,184.96 206,466.64 -17,281.68 -9.13% 567,782.00 135-010-60360-000 Furniture/Equipment < $5000 208.25 0.00 208.25 100.00% 833.00 0.00 833.00 100.00% 2,500.00 135-010-65005-000 Fuel & Lube 1,249.50 1,486.25 -236.75 -18.95% 4,998.00 5,977.82 -979.82 -19.60% 15,000.00 135-010-65010-000 Uniforms 362.77 382.50 -19.73 -5.44% 1,451.08 2,033.58 -582.50 -40.14% 4,355.00 135-010-65030-000 Chemicals 2,082.50 6,200.99 -4,118.49 -197.77% 8,330.00 15,629.77 -7,299.77 -87.63% 25,000.00 135-010-65050-000 Meter Expense 1,666.00 0.00 1,666.00 100.00% 6,664.00 0.00 6,664.00 100.00% 20,000.00 135-010-65053-000 Meter Change Out Program 7,247.10 0.00 7,247.10 100.00% 28,988.40 0.00 28,988.40 100.00% 87,000.00 135-010-69005-000 Capital Outlays 145,941.60 246,506.40 -100,564.80 -68.91% 583,766.40 349,148.80 234,617.60 40.19% 1,752,000.00 135-010-69008-000 Short Term Debt -Principal 2,655.77 31,882.11 -29,226.34 -1,100.48% 10,623.08 31,882.11 -21,259.03 -200.12% 31,882.00 135-010-69009-000 Short Term Debt -Interest 39.15 470.26 -431.11 -1,101.17% 156.60 470.26 -313.66 -200.29% 470.00 135-010-69195-000 GASB Reserve for Replacement 13,547.82 0.00 13,547.82 100.00% 54,191.28 162,639.00 -108,447.72 -200.12% 162,639.00 135-010-69281-000 Water Tank Inspection Contract 9,454.55 46,558.26 -37,103.71 -392.44% 37,818.20 110,863.59 -73,045.39 -193.15% 113,500.00 Total Department: 010 - Water: 547,941.66 606,136.32 -58,194.66 -10.62% 2,191,766.64 1,707,854.17 483,912.47 22.08% 6,577,932.00 Department: 020 - Wastewater 135-020-50005-000 Salaries & Wages 25,794.26 29,345.73 -3,551.47 -13.77% 103,177.04 116,770.44 -13,593.40 -13.17% 309,655.00 135-020-50010-000 Overtime 2,748.90 1,579.89 1,169.01 42.53% 10,995.60 5,885.10 5,110.50 46.48% 33,000.00 135-020-50016-000 Longevity 336.11 0.00 336.11 100.00% 1,344.44 0.00 1,344.44 100.00% 4,035.00 135-020-50017-000 Certification 524.79 0.00 524.79 100.00% 2,099.16 0.00 2,099.16 100.00% 6,300.00 135-020-50020-000 Retirement 3,471.19 3,711.07 -239.88 -6.91% 13,884.76 14,772.44 -887.68 -6.39% 41,671.00 135-020-50026-000 Medical lnsurance 8,045.03 6,755.26 1,289.77 16.03% 32,180.12 24,467.23 7,712.89 23.97% 96,579.00 135-020-50027-000 Dental Insurance 452.06 236.80 215.26 47.62% 1,808.24 1,206.34 601.90 33.29% 5,427.00 2/10/2023 1:22:24 AM Page 2 of 7 18 of 32 February 15, 2023 Agenda Packet Monthly Budget Report For Fiscal: Current Period Ending: 01/31/2023 Variance Variance January January Favorable Percent YTD YTD Favorable Percent Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget 135-020-50028-000 Vision Insurance 66.05 60.22 5.83 8.83% 264.20 197.00 67.20 25.44% 793.00 135-020-50029-000 Life Insurance & Other 199.92 392.71 -192.79 -96.43% 799.68 1,450.77 -651.09 -81.42% 2,400.00 135-020-50030-000 Social Security Taxes 1,823.02 1,884.41 -61.39 -3.37% 7,292.08 7,522.63 -230.55 -3.16% 21,885.00 135-020-50035-000 Medicare Taxes 426.32 440.70 -14.38 -3.37% 1,705.28 1,759.33 -54.05 -3.17% 5,118.00 135-020-50040-000 Unemployment Taxes 104.95 30.93 74.02 70.53% 419.80 32.72 387.08 92.21% 1,260.00 135-020-50045-000 Workman's Compensation 748.61 886.28 -137.67 -18.39% 2,994.44 3,545.12 -550.68 -18.39% 8,987.00 135-020-50060-000 Pre-emp Physicals/Testing 33.32 0.00 33.32 100.00% 133.28 0.00 133.28 100.00% 400.00 135-020-50070-000 Employee Relations 24.99 205.13 -180.14 -720.85% 99.96 663.09 -563.13 -563.36% 300.00 135-020-55080-000 Maintenance & Repairs 11,212.18 7,091.03 4,121.15 36.76% 44,848.72 63,687.27 -18,838.55 -42.00% 134,600.00 135-020-55081-000 Mainten & Repairs Collections 23,407.30 1,250.15 22,157.15 94.66% 93,629.20 25,102.03 68,527.17 73.19% 281,000.00 135-020-55085-000 Generator Maint. and Repair 749.70 0.00 749.70 100.00% 2,998.80 2,836.29 162.51 5.42% 9,000.00 135-020-55090-000 Vehicle Maintenance 383.18 204.74 178.44 46.57% 1,532.72 491.81 1,040.91 67.91% 4,600.00 135-020-55091-000 Veh Maintenance Collections 1,082.90 0.00 1,082.90 100.00% 4,331.60 3,795.56 536.04 12.38% 13,000.00 135-020-55105-000 Maintenance-Backhoe/SkidLoader 249.90 0.00 249.90 100.00% 999.60 1,408.94 -409.34 -40.95% 3,000.00 135-020-55120-000 Cleaning Services 166.60 161.22 5.38 3.23% 666.40 644.89 21.51 3.23% 2,000.00 135-020-55125-000 Dumpster Services 8,330.00 7,920.53 409.47 4.92% 33,320.00 23,294.85 10,025.15 30.09% 100,000.00 135-020-55135-000 Lab Analysis 3,332.00 2,212.80 1,119.20 33.59% 13,328.00 15,877.77 -2,549.77 -19.13% 40,000.00 135-020-60010-000 Communications/Mobiles 624.75 667.33 -42.58 -6.82% 2,499.00 1,809.04 689.96 27.61% 7,500.00 135-020-60020-000 Electricity 23,017.28 14,280.50 8,736.78 37.96% 92,069.12 43,080.15 48,988.97 53.21% 276,318.00 135-020-60080-000 Schools & Training 302.37 0.00 302.37 100.00% 1,209.48 576.00 633.48 52.38% 3,630.00 135-020-60100-000 Travel & per diem 86.46 0.00 86.46 100.00% 345.84 0.00 345.84 100.00% 1,038.00 135-020-60135-000 TCEQ Fees & Permits 999.60 0.00 999.60 100.00% 3,998.40 9,888.02 -5,889.62 -147.30% 12,000.00 135-020-60285-000 Lawn Equipment & Maintenance 1,332.80 0.00 1,332.80 100.00% 5,331.20 710.00 4,621.20 86.68% 16,000.00 135-020-60331-000 Interfund Transfer Out -Tax l&S 9,683.20 10,567.73 -884.53 -9.13% 38,732.80 42,270.92 -3,538.12 -9.13% 116,245.00 135-020-60332-000 Interfund Transfer Out -Rev l&S 57,637.85 62,902.88 -5,265.03 -9.13% 230,551.40 251,611.52 -21,060.12 -9.13% 691,931.00 135-020-60360-000 Furniture/Equipment < $5000 41.65 0.00 41.65 100.00% 166.60 0.00 166.60 100.00% 500.00 135-020-65005-000 Fuel & Lube 1,041.25 912.45 128.80 12.37% 4,165.00 4,631.28 -466.28 -11.20% 12,500.00 135-020-65010-000 Uniforms 367.76 968.67 -600.91 -163.40% 1,471.04 2,288.35 -817.31 -55.56% 4,415.00 135-020-65030-000 Chemicals 2,707.25 6,705.25 -3,998.00 -147.68% 10,829.00 9,962.15 866.85 8.00% 32,500.00 135-020-65031-000 Chemicals Collections 833.00 5,709.00 -4,876.00 -585.35% 3,332.00 6,002.80 -2,670.80 -80.16% 10,000.00 135-020-65045-000 Lab Supplies 2,748.90 244.00 2,504.90 91.12% 10,995.60 15,308.30 -4,312.70 -39.22% 33,000.00 135-020-69005-000 Capital Outlays 74,553.50 256,412.37 -181,858.87 -243.93% 298,214.00 305,283.19 -7,069.19 -2.37% 895,000.00 135-020-69008-000 Short Term Debt -Principal 7,144.30 63,804.49 -56,660.19 -793.08% 28,577.20 63,804.49 -35,227.29 -123.27% 85,766.00 135-020-69009-000 Short Term Debt -Interest 233.32 1,921.93 -1,688.61 -723.73% 933.28 1,921.93 -988.65 -105.93% 2,801.00 135-020-69195-000 GASB Reserve for Replacement 13,809.22 0.00 13,809.22 100.00% 55,236.88 165,777.00 -110,540.12 -200.12% 165,777.00 Total Department: 020 - Wastewater: 290,877.74 489,466.20 -198,588.46 -68.27% 1,163,510.96 1,240,336.76 -76,825.80 -6.60% 3,491,931.00 Department: 026 - Board of Directors 135-026-50045-000 Workman's Compensation 1.24 0.62 0.62 50.00% 4.96 2.48 2.48 50.00% 15.00 135-026-60070-000 Dues & Memberships 62.47 0.00 62.47 100.00% 249.88 750.00 -500.12 -200.14% 750.00 135-026-60075-000 Meetings 124.95 114.99 9.96 7.97% 499.80 459.96 39.84 7.97% 1,500.00 135-026-60080-000 Schools & Training 333.20 0.00 333.20 100.00% 1,332.80 0.00 1,332.80 100.00% 4,000.00 135-026-60100-000 Travel & per diem 416.50 0.00 416.50 100.00% 1,666.00 0.00 1,666.00 100.00% 5,000.00 2/10/2023 1:22:24 AM Page 3 of 7 19 of 32 Monthly Budget Report 135-026-60245-000 Miscellaneous Expenses Total Department: 026 - Board of Directors: Department: 030 - Administration 135-030-50005-000 135-030-50010-000 135-030-50016-000 135-030-50020-000 135-030-50026-000 135-030-50027-000 135-030-50028-000 135-030-50029-000 135-030-50030-000 135-030-50035-000 135-030-50040-000 135-030-50045-000 135-030-50060-000 135-030-50070-000 135-030-55030-000 135-030-55070-000 135-030-55080-000 135-030-55085-000 135-030-55120-000 135-030-55160-000 135-030-55205-000 135-030-60005-000 135-030-60010-000 135-030-60020-000 135-030-60025-000 135-030-60035-000 135-030-60040-000 135-030-60050-000 135-030-60055-000 135-030-60070-000 135-030-60079-000 135-030-60080-000 135-030-60100-000 135-030-60245-000 135-030-60285-000 135-030-60360-000 135-030-65010-000 135-030-65055-000 135-030-65085-000 Salaries & Wages Overtime Longevity Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Pre-emp Physicals/Testing Employee Relations Software & Support Independent Labor Maintenance & Repairs Generator Maint. and Repair Cleaning Services Professional Outside Services Utility Billing Contract Telephone Communications/Mobiles Electricity/Gas Water Postage Service Charges & Fees Bad Debt Expense Insurance Dues & Memberships Public Education Schools & Training Travel & per diem Miscellaneous Expenses Lawn Equipment & Maintenance Furniture/Equipment < $5000 Uniforms Hardware Office Supplies February 15, 2023 Agenda Packet For Fiscal: Current Period Ending: 01/31/2023 Variance Variance January January Favorable Percent YTD YTD Favorable Percent Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget 0.00 41.65 100.00% 166.60 100.00% 980.01 115.61 864.40 88.20% 3,920.04 1,212.44 2,707.60 69.07% 11,765.00 51,724.13 47,861.04 3,863.09 7.47% 206,896.52 178,684.19 28,212.33 13.64% 620,938.00 166.60 207.04 -40.44 -24.27% 666.40 509.18 157.22 23.59% 2,000.00 201.83 0.00 201.83 100.00% 807.32 0.00 807.32 100.00% 2,423.00 6,149.53 5,741.18 408.35 6.64% 24,598.12 21,559.55 3,038.57 12.35% 73,824.00 9,686.95 4,503.51 5,183.44 53.51% 38,747.80 22,496.07 16,251.73 41.94% 116,290.00 504.04 206.34 297.70 59.06% 2,016.16 1,132.52 883.64 43.83% 6,051.00 74.88 46.50 28.38 37.90% 299.52 185.90 113.62 37.93% 899.00 199.92 490.27 -290.35 -145.23% 799.68 1,927.01 -1,127.33 -140.97% 2,400.00 3,229.70 2,871.93 357.77 11.08% 12,918.80 10,382.75 2,536.05 19.63% 38,772.00 755.36 671.66 83.70 11.08% 3,021.44 2,494.06 527.38 17.45% 9,068.00 125.94 40.78 85.16 67.62% 503.76 42.57 461.19 91.55% 1,512.00 124.61 107.60 17.01 13.65% 498.44 430.40 68.04 13.65% 1,496.00 41.65 0.00 41.65 100.00% 166.60 0.00 166.60 100.00% 500.00 333.20 0.00 333.20 100.00% 1,332.80 2,563.57 -1,230.77 -92.34% 4,000.00 10,970.61 1,033.44 9,937.17 90.58% 43,882.44 65,585.41 -21,702.97 -49.46% 131,700.00 1,249.50 879.44 370.06 29.62% 4,998.00 3,323.19 1,674.81 33.51% 15,000.00 3,332.00 7,860.81 -4,528.81 -135.92% 13,328.00 8,815.69 4,512.31 33.86% 40,000.00 249.90 0.00 249.90 100.00% 999.60 0.00 999.60 100.00% 3,000.00 999.60 967.35 32.25 3.23% 3,998.40 4,167.64 -169.24 -4.23% 12,000.00 6,250.83 0.00 6,250.83 100.00% 25,003.32 66,777.26 -41,773.94 -167.07% 75,040.00 749.70 657.17 92.53 12.34% 2,998.80 1,951.62 1,047.18 34.92% 9,000.00 499.80 438.21 61.59 12.32% 1,999.20 1,801.33 197.87 9.90% 6,000.00 249.90 0.00 249.90 100.00% 999.60 0.00 999.60 100.00% 3,000.00 2,029.93 1,170.20 859.73 42.35% 8,119.72 2,826.31 5,293.41 65.19% 24,369.00 416.50 385.72 30.78 7.39% 1,666.00 1,582.98 83.02 4.98% 5,000.00 2,499.00 1,885.97 613.03 24.53% 9,996.00 6,089.42 3,906.58 39.08% 30,000.00 7,913.50 11,427.58 -3,514.08 -44.41% 31,654.00 28,040.08 3,613.92 11.42% 95,000.00 124.95 0.00 124.95 100.00% 499.80 48.65 451.15 90.27% 1,500.00 7,347.06 8,117.81 -770.75 -10.49% 29,388.24 32,471.24 -3,083.00 -10.49% 88,200.00 541.45 259.00 282.45 52.17% 2,165.80 1,968.00 197.80 9.13% 6,500.00 3,332.00 1,052.50 2,279.50 68.41% 13,328.00 11,532.60 1,795.40 13.47% 40,000.00 270.72 120.00 150.72 55.67% 1,082.88 120.00 962.88 88.92% 3,250.00 132.28 0.00 132.28 100.00% 529.12 0.00 529.12 100.00% 1,588.00 0.00 0.00 0.00 0.00% 0.00 88.00 -88.00 0.00% 0.00 416.50 650.38 -233.88 -56.15% 1,666.00 1,120.05 545.95 32.77% 5,000.00 833.00 8,724.00 -7,891.00 -947.30% 3,332.00 8,724.00 -5,392.00 -161.82% 10,000.00 44.14 0.00 44.14 100.00% 176.56 0.00 176.56 100.00% 530.00 699.72 0.00 699.72 100.00% 2,798.88 384.50 2,414.38 86.26% 8,400.00 499.80 1,098.61 -598.81 -119.81% 1,999.20 2,237.69 -238.49 -11.93% 6,000.00 2/10/2023 1:22:24 AM Page 4 of 7 20 of 32 February 15, 2023 Agenda Packet Monthly Budget Report For Fiscal: Current Period Ending: 01/31/2023 135-030-65095-000 135-030-69005-000 135-030-69170-000 135-030-69195-000 Maintenance Supplies Capital Outlays Copier Lease Installments GASB Reserve for Replacement Total Department: 030 - Administration: Department: 039 - Non Deparmental 135-039-55045-000 Legal 135-039-55055-000 Auditing 135-039-55060-000 Appraisal 135-039-55065-000 Tax Admin Fees Total Department: 039 - Non Deparmental: Total Expense: Total Revenues Total Fund: 135 - MUD 1 General Fund: Report Total: Variance Variance January January Favorable Percent YTD YTD Favorable Percent Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget 333.20 692.18 -358.98 -107.74% 1,332.80 2,261.02 -928.22 -69.64% 4,000.00 0.00 20,351.60 -20,351.60 0.00% 0.00 73,912.60 -73,912.60 0.00% 0.00 333.20 295.79 37.41 11.23% 1,332.80 1,082.79 250.01 18.76% 4,000.00 2,227.10 0.00 2,227.10 100.00% 8,908.40 26,736.00 -17,827.60 -200.12% 26,736.00 127,864.23 130,815.61 -2,951.38 -2.31% 511,456.92 596,055.84 -84,598.92 -16.54% 1,534,986.00 5,414.50 2,775.00 2,639.50 48.75% 21,658.00 7,582.50 14,075.50 64.99% 65,000.00 2,815.54 11,451.39 -8,635.85 -306.72% 11,262.16 22,551.10 -11,288.94 -100.24% 33,800.00 1,077.90 2,609.26 -1,531.36 -142.07% 4,311.60 4,772.89 -461.29 -10.70% 12,940.00 416.50 0.00 416.50 100.00% 1,666.00 4,046.00 -2,380.00 -142.86% 5,000.00 9,724.44 16,835.65 -7,111.21 -73.13% 38,897.76 38,952.49 -54.73 -0.14% 116,740.00 977,388.08 1,243,369.39 -265,981.31 -27.21% 3,909,552.32 3,584,411.70 325,140.62 8.32% 11,733,354.00 977,388.37 799,950.11 -177,438.26 -18.15% 3,909,553.48 3,383,474.08 -526,079.40 -13.46% 11,733,354.00 0.29 -443,419.28 -443,419.57 1.16 -200,937.62 -200,938.78 0.00 0.29 -443,419.28 -443,419.57 1.16 -200,937.62 -200,938.78 0.00 2/10/2023 1:22:24 AM Page 5 of 7 21 of 32 February 15, 2023 Agenda Packet Monthly Budget Report For Fiscal: Current Period Ending: 01/31/2023 Group Summary Variance Variance January January Favorable Percent YTD YTD Favorable Percent Departmen... Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget Fund: 135 - MUD 1 General Fund Revenue 000 - Revenue, Asset, Liability, & Equity 977,388.37 799,950.11 -177,438.26 -18.15% 3,909,553.48 3,383,474.08 -526,079.40 -13.46% 11,733,354.00 Total Revenue: 977,388.37 799,950.11 -177,438.26 -18.15% 3,909,553.48 3,383,474.08 -526,079.40 -13.46% 11,733,354.00 Expense 010 - Water 020 - Wastewater 026 - Board of Directors 030 - Administration 039 - Non Deparmental Total Expense: Total Revenues Total Fund: 135 - MUD 1 General Fund: Report Total: 547,941.66 606,136.32 -58,194.66 -10.62% 2,191,766.64 1,707,854.17 483,912.47 22.08% 6,577,932.00 290,877.74 489,466.20 -198,588.46 -68.27% 1,163,510.96 1,240,336.76 -76,825.80 -6.60% 3,491,931.00 980.01 115.61 864.40 88.20% 3,920.04 1,212.44 2,707.60 69.07% 11,765.00 127,864.23 130,815.61 -2,951.38 -2.31% 511,456.92 596,055.84 -84,598.92 -16.54% 1,534,986.00 9,724.44 16,835.65 -7,111.21 -73.13% 38,897.76 38,952.49 -54.73 -0.14% 116,740.00 977,388.08 1,243,369.39 -265,981.31 -27.21% 3,909,552.32 3,584,411.70 325,140.62 8.32% 11,733,354.00 977,388.37 799,950.11 -177,438.26 -18.15% 3,909,553.48 3,383,474.08 -526,079.40 -13.46% 11,733,354.00 0.29 -443,419.28 -443,419.57 1.16 -200,937.62 -200,938.78 0.00 0.29 -443,419.28 -443,419.57 1.16 -200,937.62 -200,938.78 0.00 2/10/2023 1:22:24 AM Page 6 of 7 22 of 32 February 15, 2023 Agenda Packet Monthly Budget Report For Fiscal: Current Period Ending: 01/31/2023 Fund Summary Variance Variance January January Favorable Percent YTD YTD Favorable Percent Fund Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget 135 - MUD 1 General Fund 0.29 -443,419.28 -443,419.57 1.16 -200,937.62 -200,938.78 0.00 Report Total: 0.29 -443,419.28 -443,419.57 1.16 -200,937.62 -200,938.78 0.00 2/10/2023 1:22:24 AM Page 7 of 7 23 of 32 TROPHY CLUB MUNEMPAL ur1LE7Y IIISTRI CT Department Trophy Club Municipal Utility District No. 1 Asset 000 - Revenue, Asset, Liability, & Equity Liability 000 - Revenue, Asset, Liability, & Equity Total Asset: Total Liability: Equity 000 - Revenue, Asset, Liability, & Equity Total Total Beginning Equity: Total Revenue Total Expense Revenues Over/Under Expenses Total Equity and Current Surplus (Deficit): Total Liabilities, Equity and Current Surplus (Deficit): 2/10/2023 12:46:56 AM 122 - Trophy Club MUD Fire Dept. February 15, 2023 Agenda Packet Balance Sheet Funds 122 - 528 Account Summary As Of 01/31/2023 135 - MUD 1 137 - MUD 1 519-2016 Rev 520 -Revenue 528-2015 General Fund Consolidated Bond Const -SWIFT Bond 16" Revenue Bond GASB Waterline Reserve Fund 1,612,572.86 11,135,421.41 3,422,146.58 794,334.82 1,289,991.49 911,863.95 1,612,572.86 11,135,421.41 3,422,146.58 794,334.82 1,289,991.49 911,863.95 242,457.11 888,820.96 0.00 81,691.15 158,280.07 0.00 242,457.11 888,820.96 0.00 81,691.15 158,280.07 0.00 681,803.57 10,447,538.07 2,985,574.58 705,530.20 1,339,096.93 900,604.41 681,803.57 10,447,538.07 2,985,574.58 705,530.20 1,339,096.93 900,604.41 1,016,220.30 3,383,474.08 436,572.00 7,113.47 16,950.57 11,259.54 327,908.12 3,584,411.70 0.00 0.00 224,336.08 0.00 688,312.18 -200,937.62 436,572.00 7,113.47 -207,385.51 11,259.54 1,370,115.75 10,246,600.45 3,422,146.58 712,643.67 1,131,711.42 911,863.95 1,612,572.86 11,135,421.41 3,422,146.58 794,334.82 1,289,991.49 911,863.95 24 of 32 Total 19,166, 331.11 19,166,331.11 1,371,249.29 1,371,249.29 17,060,147.76 17,060,147.76 4,871,589.96 4,136, 655.90 734,934.06 17,795,081.82 19,166,331.11 Page 1 of 1 TROPHY CLUB MUNEMPAL ur1LE7Y IIISTRI CT Department Trophy Club Municipal Utility District No. 1 Asset 000 - Revenue, Asset, Liability, & Equity Liability 000 - Revenue, Asset, Liability, & Equity Total Asset: Total Liability: Equity 000 - Revenue, Asset, Liability, & Equity Total Total Beginning Equity: Total Revenue Total Expense Revenues Over/Under Expenses Total Equity and Current Surplus (Deficit): Total Liabilities, Equity and Current Surplus (Deficit): 2/10/2023 12:47:44 AM 533- MUD 1I&S 534-2015 Consolidated Revenue Bond I&S 535 - 2016 Rev Bond I&S-SWIFT 536 - 2019 Rev Bond I&S- W&WW System 785, 3 69.91 249,399.96 107, 3 87.73 140, 225.28 785,369.91 249, 399.96 107, 387.73 140, 22 5.28 173,902.75 0.00 0.00 0.00 173,902.75 0.00 0.00 0.00 4,145.11 27,958.35 6,554.77 1,429.17 4,145.11 27,958.35 6,554.77 1,429.17 607,322.05 221,441.61 100,832.96 138,796.11 0.00 0.00 0.00 0.00 607,322.05 221,441.61 100,832.96 138,796.11 611,467.16 249,399.96 107,387.73 140,225.28 785,369.91 249, 399.96 107, 387.73 140, 22 5.28 25 of 32 February 15, 2023 Agenda Packet Balance Sheet I&S Funds 533 - 536 Account Summary As Of 01/31/2023 Total 1,282,382.88 1,282,382.88 173,902.75 173,902.75 40,087.40 40,087.40 1,068,392.73 0.00 1,068,392.73 1,108,480.13 1,282,382.88 Page 1 of 1 February 15, 2023 Agenda Packet REGULAR MEETING MINUTES TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 BOARD OF DIRECTORS January 18, 2023 at 6:30 p.m. Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in regular session on Wednesday, January 18, 2023 at 6:30 p.m., in the Boardroom of the Administration Building, 100 Municipal Drive, Trophy Club, Texas 76262. The meeting was held within the boundaries of the District and was open to the public. STATE OF TEXAS § COUNTIES OF DENTON AND TARRANT § BOARD MEMBERS PRESENT: Kevin R. Carr President Ben Brewster Vice President Doug Harper Secretary/Treasurer William C. Rose Director BOARD MEMBERS ABSENT: Tracy Hunter Director STAFF PRESENT: Alan Fourmentin Laurie Slaght Mike McMahon Steven Krolczyk Tony Corbett General Manager District Secretary Operations Manager Finance Manager Legal Counsel CALL TO ORDER AND ANNOUNCE A QUORUM President Carr announced the date of Wednesday, January 18, 2022, called the meeting to order and announced a quorum present at 6:32 p.m. CITIZEN COMMENTS There were no citizens wishing to speak. REPORTS & UPDATES 1. Staff Reports a. Capital Improvement Projects b. Water Operations Report c. Wastewater System Reports d. Finance Reports General Manager Alan Fourmentin presented the monthly staff reports to the Board and answered questions related thereto. CONSENT AGENDA 2. Consider and act to approve the Consent Agenda. 26 of 32 February 15, 2023 Agenda Packet a. December 2022 Combined Financials b. December 14, 2022 Regular Meeting Minutes c. Quarterly Investment Report — 1St Quarter FY2023 d. Tax Collections Report —1St Quarter FY2023 Director Rose removed item d. from the consent agenda for further discussion. Motion made by Director Brewster and seconded by Director Rose to approve consent agenda items a., b., and c. Motion carried unanimously. Motion made by Director Rose seconded by Director Brewster to approve consent agenda item d. as presented. Motion carried unanimously. REGULAR SESSION 3. Receive update from Audit Committee. (Rose, Hunter) Director Rose and Director Hunter were selected for the Audit Committee. Director Rose met with the auditor and staff. Director Rose was very pleased with the audit findings. 4. Consider and take appropriate action to approve the Fiscal Year 2022 Annual Financial Audit Report prepared by Rod Abbott PLLC. Rod Abbott CPA PLLC., presented the Board with the findings of the audit and answered questions related thereto. Mr. Abbott stated the District had no misstatements or material defects. Mr. Abbott stated the District had a clean audit. Motion made by Director Rose and seconded by Director Harper to approve the Fiscal Year 2022 Annual Financial Audit Report prepared by Rod Abbott PLLC. Motion carried unanimously. The Board convened into Executive Session at 7:29 p.m. EXECUTIVE SESSION 5. Pursuant to Section 551.071 of the Texas Open Meetings Act, the Board may consult with its attorney in Executive Session on a matter in which the duty of the attorney to the Governmental Body under the Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflicts with the Open Meetings Act or to seek advice of counsel on legal matters involving pending or contemplated litigation or settlement offers: 27 of 32 February 15, 2023 Agenda Packet a. Consult with legal counsel to secure legal advice concerning the adoption of rules restricting electioneering and installation of political signs on District property. b. Consult with legal counsel to secure legal advice regarding the annexation of, or provision of out -of - District service to, real property located outside the District's boundaries. The Board reconvened into Regular Session at 8:36 p.m. REGULAR SESSION 6. Consider and act regarding items discussed in Executive Session. Item a. No action taken. Item b. Discussion only. Direction was provided to the General Manager to continue to communicate with the Town Manager regarding service to out of District properties. 7. Items for future agendas: 8. Customer Deposits Strategic Committee meeting update (Carr/Brewster) Reserve Balance discussion (Rose) 9. Set future Meeting dates - February 15, 2023 at 6:30 p.m. ADJOURN President Carr called the meeting adjourned at 8:40 p.m. Kevin Carr, President Doug Harper, Secretary/Treasurer Laurie Slaght, District Secretary 28 of 32 (SEAL) 1511 TROPHY CLUB MUNICIPAL UTILITY DISTRICT STAFF REPORT February 15, 2023 February 15, 2023 Agenda Packet AGENDA ITEM: Discussion and possible action regarding customer deposits. DESCRIPTION: The District's staff has reached out to various municipalities to review the current customer deposit trends for the surrounding area. Out of over 40 responses received, the conclusion was that more than 80% of the entities apply the customer deposits to their final bill regardless of account start date. Name Keller Westlake NRH Grapevine Northlake Roanoke Southlake Deposit Taken At time of service Both At time of service Applied to first bill At time of service At time of service At time of service Deposit Applied Applied to final bill Applied to final bill Applied to final bill Applied to final bill Applied to final bill Applied to final bill 2 years of good history 29 of 32 Deposit Types Cash, Check, CC Check Cash, Check, CC Various Various Cash, Check, CC Cash, Check, CC Deposit Amount Residential- $80 Depends on meter size Residential- $100 Residential- $50 Residential- $150 Residential- $90 Residential- $75 Financial Institutions Cash Types i Cash Report Graphs 1/31/2023 February 15, 2023 Agenda Packet Prosperity- Depository Texpool- Investment Escrow- Investment Holding Customer Deposits • Committed Fire Funds • Committed Bond Reserves Committed Bond Funds Committed Bond Escrows Non -Spendable • Assigned Fund Capital Projects Unrestricted Fund Reserves $3,880 0% Cash in Funds $10,000,000 $9,000,000 $8,000,000 $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 $o $1,349,157 ■ $9,963,498 $3,422,147 $794,335 so 30 o • 122 -Fire 135 - Operating 137 - GASB Reserves 517 - WWTP Const. 519- Const. Swift • 520 -Const. WT & WW • 528 - Bond Reserve 1 • 533 -Tax I&S 534-I&S WWTP • 535 - l&S Swift • 536 - l&S WT & WW $1,289,991 $911,864 $659,283 ■-_ $249,400 $107,388 $140,22rL February 15, 2023 Agenda Packet $12,000,000 $10,000,000 ■ $8,000,000 1 $6,000,000 L $4,000,000 $2,000,000 $0 Min • Actuals • Max Operating Reserves $1,446,578 $1,330,031 $2,893,156 TCMUD Reserve Targets and Actuals Equipment Replacement Rehabilitation & Replacement Reserves (GASB) Reserves $1,653,325 $1,482,870 $3,422,147 $1,895,730 $3,306,651 $1,997,374 Emergency Capital Reserves $500,000 $500,000 $550,000 t Debt Service Reserves Rate Stabilization Reserves Undesignated Reserves Total Reserves Target $865,843 $1,221,254 $911,864 $1,110,000 $911,864 $1,424,797 $411,864 $7,169,871 $9,581,636 $11,083,841 Cash Reserve Standards 'Reserve Fund Categories 'Targets [Min Max Actuals Budgeted Expense $11,733,354 Operating Reserves 45-90 Days 31,446,578 $2,893,156 $1,330,031 District Assets $110,221,694 Equipment Replacement Reserves(GASB) 1.5% of Assets $1,653,325 $3,306,651 $3,422,147 Annual Net Water Revenue 54,070,848 Rehabilitation & Replacement Reserves TBD at Budget $1,482,870 $1,997,374 $1,895,730 Customer Deposits $328,185 Emergency Capital Reserves TBD $500,000 $550,000 $500,000 Assigned Fund Capital Projects $4,770,878 Debt Service Reserves Bond Covenants $865,843 $911,864 $911,864 Rate Stabilization Reserves 30-35% Net Water Rev $1,221,254 $1,424,797 $1,110,000 Undesignated Reserves 5411,864 (Total Reserves Target $7,169,871 $11,083,841 $9,581,636 31 of 32 Board of Directors Regul- Trophy Club Municipal Utility District No. 1 March 2023 9 10 11 Sun Feb 26, 2023 5 12 12 19 13 Mon Tue L 6 13 20 26 27 28 Wed Mar 1 February 15, 2023 Agenda PackCed�rie Slaght Thu Fri 10 Sat 11 14 15 16 17 21 22 23 24 18 25 _9 30 31 Apr 1 32 of 32 Printed on: 02/10/2023 7:47am 0 Central Time US & Ca Powered by _ teamup