Loading...
HomeMy WebLinkAbout2023-0920 September 20, 2023 Regular Meeting Agenda PacketTROPHY CLUB l 1 MUNICIPAL UTILITY DISTRICT September 20, 2023 Meeting Agenda Packet BOARD OF DIRECTORS PUBLIC HEARING AND REGULAR MEETING TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 100 MUNICIPAL DRIVE TROPHY CLUB, TEXAS 76262 Wednesday, September 20, 2023 6:30 P.M. Svore Municipal Boardroom PUBLIC HEARING AND REGULAR MEETING AGENDA PACKET CALL TO ORDER AND ANNOUNCE A QUORUM PUBLIC HEARING 1. Trophy Club Municipal Utility District No. 1 will conduct a Public Hearing regarding adoption of proposed District Tax rate of $0.06381 for the 2023 Tax Year. 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 2. Staff Reports a. Capital Improvement Projects b. Operations Reports c. Finance Reports d. Digital Platform Analytics 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. 3. Consider and act to approve the Consent Agenda. a. August 23, 2023, Regular Meeting Minutes Attachment: Meeting minutes 1 of 113 September 20, 2023 Meeting Agenda Packet REGULAR SESSION 4. Discussion regarding master planning and matters related thereto. (Hunter/Brewster) 5. Discussion and possible action regarding the 14" water main break near Hogan's Glen and matters related thereto. (Hunter/Brewster) 6. Consider and act to adopt Resolution No. 2023-0920A approving Budget for Fiscal Year 2024. Attachment: Resolution No. 2023-0920A 7. Consider and act to adopt Order No. 2023-0920A Fixing and Levying Trophy Club Municipal Utility District No. 1 Debt Service Tax Rate and Operations and Maintenance Tax Rate for 2023 Tax Year. Attachment: Order No. 2023-0920A 8. Consider and act to adopt Resolution 2023-0920B approving 2023 Tax Roll for Trophy Club Municipal Utility District No. 1. Attachment: Resolution No. 2023-0920B 9. Consider and act to approve the Amendment to District Information Form, including Notice to Purchaser Form. Attachment: Amendment to District Information Form/Notice to Purchaser 10. Consider and act regarding annual review of District Investment Policy and Investment Strategies including: a. Adopt Order No. 2023-0920B approving Amended and Restated Investment Policy, including the District's Investment Strategies and Appointment of Investment Officer(s). Attachment: Order No. 2023-0920B 11. Discussion and possible action regarding Cash Reserve Policy. 12. Consider and act regarding approval of task order agreement with Halff Associates for professional engineering services for the replacement of the existing water lines at a total cost of $86,200 and authorize the General Manager to execute the necessary documents to implement Board action. Attachment: Halff Task Order Agreement 13. Consider and act regarding approval of work order with Garver for professional engineering services related to Wastewater Treatment Plant Improvements at a total cost of $75,498 and authorize the General Manager to execute the necessary documents to implement Board action. Attachment: Garver Work Order 2 of 113 September 20, 2023 Meeting Agenda Packet 14. Consider and act regarding approval of work order agreement with Pipeline Analysis, LLC for professional engineering services related to the District wastewater collection system at a total cost not to exceed $200,680.00 and authorize the General Manager execute the necessary documents to implement Board action. Attachment: Pipeline Analysis Work Order 15. Receive update from Strategic Committee. (Carr/Harper) 16. Discussion regarding Board Ethics training and legislative updates. (Carr) EXECUTIVE SESSION 17. 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. Deliberations pursuant to Section 551.074(a)(1) of the Texas Open Meetings Act regarding appointment, employment, evaluation, reassignment, duties, discipline, or dismissal of a public officer or employee: General Manager annual evaluation. b. Consult with legal counsel relating to Board Ethics Training and Legislative Update. REGULAR SESSION 18. Consider and act regarding items discussed in Executive Session. 19. Items for future agendas: 20. Discussion to set future Meeting date(s). Attachment: October 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 DISTRICT'S PRIOR PRACTICE OF SPECIFICALLY IDENTIFYING ALL AGENDA ITEMS TO BE DISCUSSED IN EXECUTIVE SESSION. ADJOURN 3 of 113 Ft TROPHY C. u MUNICIPAL UTILITY DISTRICT September 20, 2023 Meeting Agenda Packet Capital Improvement Projects • FY 2023 Water Line Project — The boring and installation of water lines between Sunset Drive and Straight Creek Court and between Berkshire Court and Wilshire have been completed. The boring on Lee Court and remaining water line on Berkshire Court is projected to be complete by the end of October. This project is scheduled to be completed by the end of November 2023. • Pump Station Improvement Project — The contractor is in the process of providing submittals. The demolition within the building is underway and the electrician is onsite verifying wiring runs to ensure nothing is disconnected inadvertently during demolition, and excavation of the manifold is started to verify measurements of pipe lengths prior to ordering materials. This project is tentatively scheduled to be completed in May 2024 due to the long lead time for VFDs. • Lift Station Generators — The contractor is awaiting the availability of concrete to finalize constructing the concrete pads. Delivery of the generators is scheduled for December 2023 with an anticipated completion date of April 2024. • FY 2023 Wastewater Improvements — Four additional point repairs were performed this month and this project is complete. • Southlake emergency connection — We are awaiting Southlake to complete a Water Master Plan Update, which is expected to be completed in May 2024. 4 of 113 September 20, 2023 Meeting Agenda Packet Water Billed -2023 180,000 160,000 140,000 120,000 100,000 80,000 60,000 40,000 20,000 0 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 49,082 34,501 46,119 70,083 79,654 108,707 134,083 169,549 894,934 Water Pumped 160,000 2u1 22 2023 140,000 120,000 1 100,000 / 80,000 N'..-.4044.........._ � 60,000 40,000 \� 20,000 0 - 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 39,309 50,124 77,261 84,019 120,932 145,657 184,972 986,725 5 of 113 September 20, 2023 Meeting Agenda Packet 7 6 C' 5 0 7 4 0 3 g 2 1 0 • Min • Max Avg 4.704 Aug -22 Aug -22 2.348 7.325 Sep -22 Sep -22 1.889 5.277 3.948 Oct -22 Oct -22 1.842 5.004 3.662 Nov -22 Nov -22 1.401 2.572 1.834 Water Production .11 .11 .V .11 Dec -22 Dec -22 1.115 2.716 1.657 Jan -23 Jan -23 1.225 2.508 1.759 Feb -23 Mar -23 Feb -23 0.878 2.354 1.479 Mar -23 0.999 2.516 1.731 1 Apr -23 May -23 Jun -23 Apr -23 0.920 4.597 2.780 May -23 1.730 5.729 3.125 Jun -23 2.628 5.950 4.079 Jul -23 III Aug -23 Jul -23 Aug -23 3.277 4.622 7.079 7.305 5.266 6.291 1.950 1.750 1.550 Tv 1.350 1.150 0.950 0.750 Aug -22 Wastewater Treated 1 1 1 1 1 1 1 1 1 1 I 1 1 1 • 1 Sep -22 Oct -22 Nov -22 Dec -22 Jan -23 Feb -23 Mar -23 Daily Avg Flow Daily Max Flow -Daily Avg Max Apr -23 May -23 Jun -23 Jul -23 Aug -23 20.0 18.0 16.0 14.0 12.0 10.0 8.0 6.0 4.0 2.0 0.0 Carbonaceous Biochemical Oxygen Demand (CBOD) J Aug -22 Sep -22 Oct -22 Nov -22 Dec -22 Jan -23 Feb -23 Mar -23 Apr -23 May -23 Jun -23 Jul -23 Aug -23 CBOD Avg CBOD Max -Daily Avg Max -Daily Max 6 of 113 September 20, 2023 Meeting Agenda Packet 40.0 35.0 30.0 25.0 20.0 15.0 10.0 5.0 0.0 Total Suspended Solids (TSS) Aug -22 Sep -22 Oct -22 Nov -22 Dec -22 Jan -23 TSS Avg Feb -23 Mar -23 TSS Max -Daily Avg Max -Daily Max Apr -23 May -23 Jun -23 Jul -23 Aug -23 10.00 9.00 8.00 7.00 6.00 5.00 4.00 3.00 2.00 1.00 0.00 Ammonia Nitrogen (NH3) r � r Aug -22 Sep -22 Oct -22 Nov -22 Dec -22 Jan -23 Feb -23 Mar -23 Apr -23 May -23 Jun -23 Jul -23 Aug -23 NH3 Avg NH3 Max Daily Avg Max -Daily Max 50.0 40.0 30.0 20.0 10.0 0.0 Nitrate -Nitrogen (NO3) Aug -22 Sep -22 Oct -22 Nov -22 Dec -22 Jan -23 Feb -23 Mar -23 NO3 Avg NO3 Max -Daily Avg Max -Daily Max Apr -23 May -23 Jun -23 Jul -23 Aug -23 7 of 113 September 20, 2023 Meeting Agenda Packet 8 of 113 Potential of Hydrogen (pH) 9 8.5 8 7.5 7 6.5 6 Aug -22 Sep -22 Oct -22 Nov -22 Dec -22 Jan -23 Feb -23 Mar -23 Apr -23 pH Min pH Max _. pH Avg —Daily Avg Min —Daily Avg Max May -23 Jun -23 Jul -23 Aug -23 Dissolved Oxygen (DO) 9.0 8.5 8.0 7.5 I7.0 i 6.5 6.0 .1 .1 Aug -22 Sep -22 Oct -22 Nov -22 Dec -22 Jan -23 Feb -23 Mar -23 Apr -23 May -23 Jun -23 Jul -23 Aug -23 DO DO Max DO Avg Min = Min = a —Daily Avg —Daily Avg Max Escherichia coli (E. coli) *Sep -22 is an outlier sample 400 350 — 307.0 300 250 200 150 100 50 3.0 1.0 6.3 2.0 1.0 1.0 2.0 1.0 1.0 1.0 2.0 1.0 0 Aug -22 *Sep -22 Oct -22 Nov -22 Dec -22 lan-23 Feb -23 Mar -23 Apr -23 May -23 Jun -23 Jul -23 Aug -23 = E. Avg = E. Max Avg Max Max coli coli —Daily —Daily 8 of 113 Trophy Club Municipal Utility District No. 1 Vendor Number Vendor Name Bank Code: Prosperity Bank -Prosperity Bank Payment Type: Regular September 20, 2023 Meeting Agenda Packet Check Report By Check Number Date Range: 08/01/2023 - 08/31/2023 Payment Date Payment Type Discount Amount Payment Amount Number 3127 Allied Welding Supply Inc. 08/02/2023 Regular 0.00 21.78 9780 3197 BenefitMall 08/02/2023 Regular 0.00 52.00 9781 2655 Core & Main LP 08/02/2023 Regular 0.00 460.00 9782 2606 Fisery Solutions LLC 08/02/2023 Regular 0.00 50.00 9783 1372 Hach Company 08/02/2023 Regular 0.00 512.10 9784 2759 Hardys Painting 08/02/2023 Regular 0.00 4,538.00 9785 4033 Health Care Service Corporation 08/02/2023 Regular 0.00 22,147.36 9786 3297 J&L Construction LLC 08/02/2023 Regular 0.00 251,133.30 9787 3115 Metlife Group Benefits 08/02/2023 Regular 0.00 2,301.06 9788 3176 Rey -Mar Construction 08/02/2023 Regular 0.00 17,484.00 9789 3156 Southern Petroleum Lab Inc 08/02/2023 Regular 0.00 706.80 9790 4000 UST General Contracting LLC 08/02/2023 Regular 0.00 58,492.53 9791 2772 Allied Waste Industries 08/16/2023 Regular 0.00 6,636.75 9792 2683 Charter Communications 08/16/2023 Regular 0.00 899.00 9793 3184 Dataprose LLC 08/16/2023 Regular 0.00 4,751.66 9794 2800 Ferguson Enterprises LLC 08/16/2023 Regular 0.00 480.00 9795 3093 Four Man Furnace Inc. 08/16/2023 Regular 0.00 1,097.50 9796 1372 Hach Company 08/16/2023 Regular 0.00 1,312.00 9797 2785 Kleen Pipe, Inc 08/16/2023 Regular 0.00 10,310.00 9798 2754 Lower Colorado River Authority 08/16/2023 Regular 0.00 213.92 9799 3216 M3 Networks 08/16/2023 Regular 0.00 373.58 9800 1056 Office Depot Inc 08/16/2023 Regular 0.00 109.53 9801 4019 Peterson Pump & Motor Service LLC 08/16/2023 Regular 0.00 960.00 9802 3176 Rey -Mar Construction 08/16/2023 Regular 0.00 17,915.00 9803 3156 Southern Petroleum Lab Inc 08/16/2023 Regular 0.00 1,335.60 9804 2440 Tarrant County Public Health Laboratory 08/16/2023 Regular 0.00 420.00 9805 2696 Texas Excavation Safety System 08/16/2023 Regular 0.00 165.30 9806 1001 Town of Trophy Club 08/16/2023 Regular 0.00 208,429.17 9807 1081 Tri County Electric 08/16/2023 Regular 0.00 633.16 9808 4029 Trojan Technolgoies Group ULC 08/16/2023 Regular 0.00 1,695.00 9809 1000 Trophy Club Mud (Water Bills) 08/16/2023 Regular 0.00 438.33 9810 1058 Verizon Wireless 08/16/2023 Regular 0.00 608.56 9811 3197 BenefitMall 08/23/2023 Regular 0.00 52.00 9812 3299 Bickerstaff Heath Delgado Acosta LLP 08/23/2023 Regular 0.00 2,291.00 9813 2796 Garver 08/23/2023 Regular 0.00 9,686.00 9814 2635 Halff Associates Inc. 08/23/2023 Regular 0.00 500.00 9815 4033 Health Care Service Corporation 08/23/2023 Regular 0.00 22,147.36 9816 3278 Kyocera Document Solutions 08/23/2023 Regular 0.00 102.14 9817 3216 M3 Networks 08/23/2023 Regular 0.00 1,091.00 9818 3186 Member's Building Maintenance 08/23/2023 Regular 0.00 1,289.80 9819 3115 Metlife Group Benefits 08/23/2023 Regular 0.00 2,301.06 9820 2760 NDS Leasing 08/23/2023 Regular 0.00 175.00 9821 3179 NewGen Strategies & Solutions 08/23/2023 Regular 0.00 497.50 9822 3111 North Texas Groundwater 08/23/2023 Regular 0.00 4,633.70 9823 3156 Southern Petroleum Lab Inc 08/23/2023 Regular 0.00 1,021.20 9824 3283 TK Contractors Inc 08/23/2023 Regular 0.00 4,200.00 9825 4000 UST General Contracting LLC 08/23/2023 Regular 0.00 121,380.76 9826 2222 Aflac 08/31/2023 Regular 0.00 446.16 9827 2772 Allied Waste Industries 08/31/2023 Regular 0.00 4,089.79 9828 4018 BP Energy Holding Company LLC 08/31/2023 Regular 0.00 49,551.08 9829 1030 City of Fort Worth 08/31/2023 Regular 0.00 403,632.12 9830 2655 Core & Main LP 08/31/2023 Regular 0.00 420.96 9831 1737 DPC Industries Inc. 08/31/2023 Regular 0.00 1,946.35 9832 9/14/2023 7:31:52 PM Page 1 of 4 9 of 113 September 20, 2023 Meeting Agenda Packet Check Report Date Range: 08/01/2023 - 08/31/2023 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number 2800 Ferguson Enterprises LLC 08/31/2023 Regular 0.00 5,082.96 9833 3093 Four Man Furnace Inc. 08/31/2023 Regular 0.00 1,841.25 9834 2635 Halff Associates Inc. 08/31/2023 Regular 0.00 600.00 9835 2943 JP Morgan Chase Bank NA 08/31/2023 Regular 0.00 6,185.56 9836 3132 Legal Shield 08/31/2023 Regular 0.00 15.95 9837 2801 Pipeline Analysis LLC 08/31/2023 Regular 0.00 19,505.10 9838 3134 Prime Controls LP 08/31/2023 Regular 0.00 9,280.00 9839 2809 Rod L Abbott CPA LLC 08/31/2023 Regular 0.00 612.85 9840 1907 Ron Montgomery & Assoc Inc 08/31/2023 Regular 0.00 306.50 9841 3156 Southern Petroleum Lab Inc 08/31/2023 Regular 0.00 2,042.40 9842 2440 Tarrant County Public Health Laboratory 08/31/2023 Regular 0.00 80.00 9843 1000 Trophy Club Mud (Water Bills) 08/31/2023 Regular 0.00 423.50 9844 1120 Trophy Club Mud Petty Cash 08/31/2023 Regular 0.00 257.00 9845 3225 US Bank Voyager Fleet Systems 08/31/2023 Regular 0.00 3,396.47 9846 4060 Xylem Dewatering Solutions, Inc. 08/31/2023 Regular 0.00 18,900.00 9847 Total Regular: 0.00 1,316,667.51 9/14/2023 7:31:52 PM Page 2 of 4 10 of 113 September 20, 2023 Meeting Agenda Packet Check Report Date Range: 08/01/2023 - 08/31/2023 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number Payment Type: Bank Draft 3197 BenefitMall 08/04/2023 Bank Draft 0.00 266.67 DFT0000091 3113 TCDRS 08/31/2023 Bank Draft 0.00 9,587.08 DFT0000092 3124 IRS Tax Payment 08/04/2023 Bank Draft 0.00 12,897.57 DFT0000093 3197 BenefitMall 08/18/2023 Bank Draft 0.00 266.67 DFT0000094 3113 TCDRS 08/31/2023 Bank Draft 0.00 9,615.95 DFT0000095 3124 IRS Tax Payment 08/18/2023 Bank Draft 0.00 13,035.55 DFT0000096 3294 Texas Workforce Commission 08/04/2023 Bank Draft 0.00 7.17 DFT0000097 3113 TCDRS 08/31/2023 Bank Draft 0.00 66.78 DFT0000098 3124 IRS Tax Payment 08/25/2023 Bank Draft 0.00 53.78 DFT0000099 Total Bank Draft: 0.00 45,797.22 Bank Code Prosperity Bank Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 92 68 0.00 1,316,667.51 Manual Checks 0 0 0.00 0.00 Voided Checks 0 0 0.00 0.00 Bank Drafts 9 9 0.00 45,797.22 EFT's 0 0 0.00 0.00 101 77 0.00 1,362,464.73 9/14/2023 7:31:52 PM Page 3 of 4 11 of 113 September 20, 2023 Meeting Agenda Packet Check Report Date Range: 08/01/2023 - 08/31/2023 All Bank Codes Check Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 92 68 0.00 1,316,667.51 Manual Checks 0 0 0.00 0.00 Voided Checks 0 0 0.00 0.00 Bank Drafts 9 9 0.00 45,797.22 EFT's 0 0 0.00 0.00 101 77 0.00 1,362,464.73 Fund Summary Fund Name Period Amount 996 MUD Consolidated Cash 8/2023 1,362,464.73 1,362,464.73 9/14/2023 7:31:52 PM Page 4 of 4 12 of 113 1 September 20, 2023 Meeting Agenda Packet FY 2023 Combined Financials YTD as of 8/31/2023 YTD Revenues YTD Expenses Amended Revenues ■ Amended Expenses Adopted Revenues Adopted Expenses Adopted Budget vs YTD Actuals Revenues & Expenses $10,840,182 $12,442,977 $12,921,200 $11,733,354 $11,733,354 $2,743 $64,184 0% $1,387,787 $3,557,799 33% 13% 1% $5,703,297 53% YTD Expenses By Departments YTD Expense- Water YTD Expense- WW YTD Expense- Admin YTD Expense- BOD ■ YTD Expense- Non Dept Water Budget vs Actual Water Consumption Budget vs Actual 140,000,000 134,083,000 120,000,000 108,707,084 126,270,812 100,000,000 101,683,000 79,654,000 104,510,967 80,000,000 70,083,7• r. 80,784,200 52,466,000 88979,203 49,007,000 49,082,000 46,119,000 61,944,185 , 60,000,000 40,000,000 41,702,881 41,572,326 36,351,669 20,000,000 34,501,000 0 —0—Budget Consumption 33,732,116 54,266,627 34,390,563 }Actual Consumption Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug 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 998,602,388 808,128,121 Total Water Consumption • Budgeted Water Consumption • Projected Water Consumption Presented by: Finance Department $1,000,000 $900,000 5800,000 5700,000 5600,000 $664,453 5500,000 5400,000 5300,000 5200,000 5100,000 50 Water Revenue Budget vs Actual $536,842 $440,564 8438,585 $424,445 $404,421 0355,608 $779,457 597,742 8 395,329 8365,714 $335,705 $351,905 $466,063 3520,969 —0—Budget Revenue —a—Actual Revenue $636,314 $940,104 $792,444 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug $8,000,000 57,000,000 $6,000,000 55,000,000 $4,000,000 53,000,000 $2,000,000 51,000,000 $0 Adopted Budget Water Revenue Vs Projected Water Revenue 714 070 $7,567,593 $4,070,848 1 Total Water Revenue 54,801,243 • Budgeted Water Revenue • Projected Water Revenue Net Budgeted Water Revenue Minus Budgeted Expenses • Net Projected Water Revenue Minus Projected Expenses 13 of 113 September 20, 2023 Meeting Agenda Packet Trophy Club Municipal Utility District No. 1 Fund: 135 - MUD 1 General Fund CURRENT MONTH YEAR TO DATE ACTUAL BUDGETED VARIANCE ACTUAL BUDGETED VARIANCE Budget Variance Report As Of: 08/31/2023 ANNUAL BUDGET TOTAL REMAINING % REVENUE SUMMARY Revenue, Asset, Liability, & Equity 1,616,385.74 1,687,011.37 (70,625.63) 10,840,181.71 11,460,895.07 (620,713.36) 87 12,442,977.00 (1,602,795.29) 13 TOTAL REVENUE 1,616,385.74 1,687,011.37 (70,625.63) 10,840,181.71 11,460,895.07 (620,713.36) 87 12,442,977.00 (1,602,795.29) 13 EXPENSE SUMMARY Revenue, Asset, Liability, & Equity 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Water 1,066,432.65 1,056,606.66 (9,825.99) 5,703,297.31 6,536,023.26 832,725.95 80 7,086,597.00 (1,383,299.69) 20 Wastewater 215,460.45 977,260.74 761,800.29 3,557,798.55 3,886,038.14 328,239.59 85 4,178,314.00 (620,515.45) 15 Board of Directors 232.60 (7,984.99) (8,217.59) 2,742.60 1,815.11 (927.49) 98 2,800.00 (57.40) 2 Administration 103,047.72 171,427.23 68,379.51 1,387,786.84 1,450,069.53 62,282.69 88 1,578,549.00 (190,762.16) 12 Non Departmental 9,993.10 (32,075.56) (42,068.66) 64,184.35 65,168.84 984.49 86 74,940.00 (10,755.65) 14 TOTAL EXPENSE 1,395,166.52 2,165,234.08 770,067.56 10,715,809.65 11,939,114.88 1,223,305.23 83 12,921,200.00 2,205,390.35 17 REVENUE OVER/(UNDER) EXPENDITURE 221,219.22 (478,222.71) 699,441.93 124, 372.06 (478,219.81) 602,591.87 (478,223.00) (3,808,185.64) 9/15/2023 12:06:27 AM 14 of 113 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 135-000-49903-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 August Budget August Activity Variance Favorable Percent (Unfavorable) Remaining YTD Budget September 20, 2023 Meeting Agenda Packet Monthly Budget Report Account Summary For Fiscal: Current Period Ending: 08/31/2023 YTD Activity Variance Favorable Percent (Unfavorable) Remaining Total Budget Asset, Liability, & Equity Property Taxes 7,326.73 159.74 -7,166.99 -97.82% 80,594.03 86,503.60 5,909.57 7.33% 87,956.00 Property Taxes/Delinquent 24.99 8.44 -16.55 -66.23% 274.89 1,296.90 1,022.01 371.79% 300.00 Property Taxes/P &I 24.99 19.82 -5.17 -20.69% 274.89 1,099.05 824.16 299.81% 300.00 PID Surcharges 12,080.91 0.00 -12,080.91 -100.00% 132,890.01 0.00 -132,890.01 -100.00% 145,029.00 Water 990,300.55 1,205,245.69 214,945.14 21.71% 6,580,546.05 6,780,101.43 199,555.38 3.03% 7,142,255.00 Sewer 150,159.84 317,464.24 167,304.40 111.42% 3,348,618.24 3,365,788.15 17,169.91 0.51% 3,670,000.00 Penalties 6,497.40 9,895.49 3,398.09 52.30% 71,471.40 64,015.25 -7,456.15 -10.43% 78,000.00 Service Charges 466.48 425.00 -41.48 -8.89% 5,131.28 3,375.00 -1,756.28 -34.23% 5,600.00 Plumbing Inspections 24.99 0.00 -24.99 -100.00% 274.89 0.00 -274.89 -100.00% 300.00 Sewer Inspections 8.33 0.00 -8.33 -100.00% 91.63 0.00 -91.63 -100.00% 100.00 TCCC Effluent Charges 44,998.00 19,554.40 -25,443.60 -56.54% 94,978.00 85,396.72 -9,581.28 -10.09% 100,000.00 Interest Income 361,666.00 36,787.34 -324,878.66 -89.83% 378,326.00 362,448.60 -15,877.40 -4.20% 380,000.00 Cell Tower Revenue 24,211.36 4,000.00 -20,211.36 -83.48% 35,994.96 41,178.81 5,183.85 14.40% 37,179.00 Proceeds from Sale of Assets 27,082.50 22,750.00 -4,332.50 -16.00% 47,907.50 45,886.22 -2,021.28 -4.22% 50,000.00 Prior Year Reserves 47,722.57 0.00 -47,722.57 -100.00% 524,948.27 0.00 -524,948.27 -100.00% 572,900.00 GASB Reserves 13,661.20 0.00 -13,661.20 -100.00% 150,273.20 0.00 -150,273.20 -100.00% 164,000.00 Oversize Meter Reimbursement ii 171.43 0.00 -171.43 -100.00% 1,885.73 0.00 -1,885.73 -100.00% 2,058.00 Miscellaneous Income 583.10 0.00 -583.10 -100.00% 6,414.10 3,016.40 -3,397.70 -52.97% 7,000.00 Recovery of Prior Year Expense =MI 0.00 75.58 A 75.58 0.00% i 0.00 Mi5.58 j 75.58 0.00% A. 0.00 nt: 000 - Revenue, Asset, Liability, & Equity: 1,687,011.37 1,616,385.74 -70,625.63 -4.19% 11,460,895.07 10,840,181.71 -620,713.36 -5.42% 12,442,977.00 Salaries & Wages Overtime Longevity Certification Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Total Revenue: 1,687,011.37 1,616,385.74 33,914.67 31,364.33 1,416.10 3,211.26 498.38 0.00 299.88 225.00 4,264.96 4,176.09 11,795.74 8,444.02 406.17 350.33 62.05 71.31 199.92 290.69 -70,625.63 -4.19% 11,460,895.07 10,840,181.71 -620,713.36 -5.42% 12,442,977.00 2,550.34 7.52% 373,061.37 348,646.84 24,414.53 6.54% 407,139.00 -1,795.16 -126.77% 15,577.10 13,308.63 2,268.47 14.56% 17,000.00 498.38 100.00% 5,482.18 5,982.50 -500.32 -9.13% 5,983.00 74.88 24.97% 3,298.68 2,475.00 823.68 24.97% 3,600.00 88.87 2.08% 46,914.56 44,548.28 2,366.28 5.04% 51,200.00 3,351.72 28.41% 80,703.14 79,181.19 1,521.95 1.89% 87,627.00 55.84 13.75% 4,467.87 3,609.59 858.28 19.21% 4,876.00 -9.26 -14.92% 682.55 672.90 9.65 1.41% 745.00 -90.77 -45.40% 2,199.12 3,276.22 -1,077.10 -48.98% 2,400.00 9/15/2023 12:13:20 AM 15 of 113 Page 1 of 7 September 20, 2023 Meeting Agenda Packet Monthly Budget Report For Fiscal: Current Period Ending: 08/31/2023 135-010-50030-000 135-010-50035-000 135-010-50040-000 135-010-50045-000 135-010-50060-000 135-010-50070-000 135-010-55080-000 135-010-55085-000 135-010-55090-000 135-010-55105-000 135-010-55120-000 135-010-55135-000 135-010-55135-001 135-010-60010-000 135-010-60020-000 135-010-60066-000 135-010-60080-000 135-010-60100-000 135-010-60135-000 135-010-60135-001 135-010-60150-000 135-010-60285-000 135-010-60332-000 135-010-60360-000 135-010-65005-000 135-010-65010-000 135-010-65030-000 135-010-65050-000 135-010-65053-000 135-010-69005-000 135-010-69008-000 135-010-69009-000 135-010-69195-000 135-010-69281-000 135-020-50010-000 135-020-50016-000 135-020-50017-000 135-020-50020-000 135-020-50026-000 Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Pre-emp Physicals/Testing Employee Relations Maintenance & Repairs Generator Maint. and Repair Vehicle Maintenance Maintenance-Backhoe/SkidLoader Cleaning Services Lab Analysis Lab Analysis for PID Communications/Mobiles Electricity Publications/Books/Subscripts Schools & Training Travel & per diem TCEQ Fees & Permits TCEQ Fees & Permits for PID Wholesale Water Lawn Equipment & Maintenance Interfund Transfer Out -Rev I&S Furniture/Equipment < $5000 Fuel & Lube Uniforms Chemicals Meter Expense Meter Change Out Program Capital Outlays Short Term Debt -Principal Short Term Debt -Interest GASB Reserve for Replacement Water Tank Inspection Contract Total Department: 010 - Water: Department: 020 - Wastewater 135-020-50005-000 Salaries & Wages Overtime Longevity Certification Retirement Medical Insurance August Budget 2, 240.02 523.87 104.95 937.04 33.32 24.99 -5,857.66 166.60 7,482.50 83.30 208.25 624.75 166.60 624.75 -14,426.78 83.30 302.37 78.13 2,499.00 214.00 219,922.99 1,041.25 47,296.24 208.25 1,249.50 362.77 22,582.50 -11,914.00 7,247.10 693,941.60 2,655.77 39.15 Uhl 13,547.82 9,454.55 August Activity 2,092.45 489.36 0.00 1,109.40 0.00 334.55 47, 707.02 0.00 0.00 0.00 161.23 790.00 80.00 486.64 25,507.09 0.00 211.00 0.00 4,633.70 0.00 403,632.12 0.00 51, 616.70 1,355.00 2,057.50 200.00 2,367.31 0.00 0.00 575,468.55 0.00 0.00 mama - 0.00 Variance Favorable (Unfavorable) 147.57 34.51 104.95 -172.36 33.32 -309.56 -53,564.68 166.60 7,482.50 83.30 47.02 -165.25 86.60 138.11 -39,933.87 83.30 91.37 78.13 -2,134.70 214.00 -183,709.13 1,041.25 -4,320.46 -1,146.75 -808.00 162.77 20,215.19 -11,914.00 7,247.10 118,473.05 2,655.77 39.15 115,547.82 9,454.55 Percent Remaining 6.59% 6.59% 100.00% -18.39% 100.00% -1,238.74% 914.44% 100.00% 100.00% 100.00% 22.58% -26.45% 51.98% 22.11% 276.80% 100.00% 30.22% 100.00% -85.42% 100.00% -83.53% 100.00% -9.13% -550.66% -64.67% 44.87% 89.52% 100.00% 100.00% 17.07% 100.00% 100.00% 852.89% 100.00% YTD Budget 24,640.22 5,762.57 1,154.45 10, 307.44 366.52 274.89 185,565.74 1,832.60 11,647.50 916.30 2,290.75 6,872.25 1,832.60 6,872.25 175, 705.42 916.30 3,326.07 859.43 27,489.00 214.00 2,419,152.89 11,453.75 520,258.64 2,290.75 13,744.50 3,990.47 43,407.50 4,746.00 79,718.10 2,153,357.60 29, 213.47 430.65 149,026.02 104,000.05 YTD Activity 22,491.73 5,060.09 53.98 12, 203.40 420.45 467.50 180, 714.68 875.96 12,871.11 2,516.06 1,934.75 5,212.44 2,026.58 5,151.08 166,158.11 0.00 3,123.72 44.79 27,945.73 213.92 2,095,551.61 4,800.00 567,783.30 1,355.00 16,460.88 3,097.65 46,189.83 0.00 87,000.00 1,726,016.85 31,882.11 470.26 60,639.00 110,863.59 Variance Favorable (Unfavorable) 2,148.49 702.48 1,100.47 -1,895.96 -53.93 -192.61 4,851.06 956.64 -1,223.61 -1,599.76 356.00 1,659.81 -193.98 1,721.17 9,547.31 916.30 202.35 814.64 -456.73 0.08 323,601.28 6,653.75 -47,524.66 935.75 -2,716.38 892.82 -2,782.33 4,746.00 -7,281.90 427,340.75 -2,668.64 -39.61 88,387.02 -6,863.54 Percent Remaining 8.72% 12.19% 95.32% -18.39% -14.71% -70.07% 2.61% 52.20% -10.51% -174.59% 15.54% 24.15% -10.58% 25.05% 5.43% 100.00% 6.08% 94.79% -1.66% 0.04% 13.38% 58.09% -9.13% 40.85% -19.76% 22.37% -6.41% 100.00% -9.13% 19.85% -9.13% -9.20% Total Budget 26,891.00 6,289.00 1,260.00 11,249.00 400.00 300.00 204,800.00 2,000.00 12,066.00 1,000.00 2,500.00 7,500.00 2,000.00 7,500.00 194,810.00 1,000.00 3,630.00 938.00 30,000.00 214.00 2,640,132.00 12, 500.00 567,782.00 2,500.00 15,000.00 4,355.00 45, 500.00 6,420.00 87,000.00 2,300,000.00 31,882.00 470.00 5111 162,639.00 -6.60% 113,500.00 1,056,606.66 1,066,432.65 6,318.26 -14,665.10 336.11 524.79 3,471.19 -24,672.97 17,146.69 1,767.85 0.00 225.00 2,296.75 4,503.48 -9,825.99 -0.93% 6,536,023.26 5,703,297.31 -10,828.43 -16,432.95 336.11 299.79 1,174.44 -29,176.45 -171.38% 264,260.86 262,326.09 112.05% 12,823.90 14,353.51 100.00% 3,697.21 4,035.00 57.13% 5,772.69 4,125.00 33.83% 38,183.09 34,189.56 118.25% 55,777.33 59,344.92 832,725.95 1,934.77 -1,529.61 -337.79 1,647.69 3,993.53 -3,567.59 12.74% 7,086,597.00 0.73% 290,179.00 -11.93% 15,586.00 -9.14% 4,035.00 28.54% 6,300.00 10.46% 41,671.00 -6.40% 63,861.00 9/15/2023 12:13:20 AM Page 2 of 7 16 of 113 September 20, 2023 Meeting Agenda Packet Monthly Budget Report For Fiscal: Current Period Ending: 08/31/2023 Variance Variance August August Favorable Percent YTD YTD Favorable Percent Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget 135-020-50027-000 Dental Insurance 452.06 166.51 285.55 63.17% 4,972.66 2,476.61 2,496.05 50.20% 5,427.00 135-020-50028-000 Vision Insurance 66.05 42.52 23.53 35.62% 726.55 520.98 205.57 28.29% 793.00 135-020-50029-000 Life Insurance & Other 199.92 144.16 55.76 27.89% 2,199.12 2,358.15 -159.03 -7.23% 2,400.00 135-020-50030-000 Social Security Taxes 1,823.02 1,138.78 684.24 37.53% 20,053.22 17,232.75 2,820.47 14.06% 21,885.00 135-020-50035-000 Medicare Taxes 426.32 266.33 159.99 37.53% 4,689.52 4,030.23 659.29 14.06% 5,118.00 135-020-50040-000 Unemployment Taxes 104.95 0.00 104.95 100.00% 1,154.45 43.66 1,110.79 96.22% 1,260.00 135-020-50045-000 Workman's Compensation 748.61 886.28 -137.67 -18.39% 8,234.71 9,749.08 -1,514.37 -18.39% 8,987.00 135-020-50060-000 Pre-emp Physicals/Testing 33.32 0.00 33.32 100.00% 366.52 150.00 216.52 59.07% 400.00 135-020-50070-000 Employee Relations 24.99 0.00 24.99 100.00% 274.89 1,167.97 -893.08 -324.89% 300.00 135-020-55080-000 Maintenance & Repairs 87,612.18 15,441.65 72,170.53 82.37% 199,733.98 201,538.68 -1,804.70 -0.90% 211,000.00 135-020-55081-000 Mainten & Repairs Collections 76,007.30 31,696.10 44,311.20 58.30% 310,080.30 254,112.55 55,967.75 18.05% 333,600.00 135-020-55085-000 Generator Maint. and Repair -5,414.30 0.00 -5,414.30 100.00% 2,082.70 2,836.29 -753.59 -36.18% 2,836.00 135-020-55090-000 Vehicle Maintenance 383.18 10.90 372.28 97.16% 4,214.98 639.87 3,575.11 84.82% 4,600.00 135-020-55091-000 Veh Maintenance Collections 1,082.90 0.00 1,082.90 100.00% 11,911.90 4,821.91 7,089.99 59.52% 13,000.00 135-020-55105-000 Maintenance-Backhoe/SkidLoader 249.90 0.00 249.90 100.00% 2,748.90 2,435.44 313.46 11.40% 3,000.00 135-020-55120-000 Cleaning Services 166.60 161.22 5.38 3.23% 1,832.60 1,934.65 -102.05 -5.57% 2,000.00 135-020-55125-000 Dumpster Services 3,330.00 10,726.54 -7,396.54 -222.12% 86,630.00 85,077.11 1,552.89 1.79% 95,000.00 135-020-55135-000 Lab Analysis 8,332.00 3,063.60 5,268.40 63.23% 41,652.00 42,587.37 -935.37 -2.25% 45,000.00 135-020-60010-000 Communications/Mobiles 624.75 200.72 424.03 67.87% 6,872.25 3,777.76 3,094.49 45.03% 7,500.00 135-020-60020-000 Electricity -9,327.72 23,176.41 -32,504.13 348.47% 220,845.08 223,155.23 -2,310.15 -1.05% 243,973.00 135-020-60080-000 Schools & Training 302.37 0.00 302.37 100.00% 3,326.07 2,560.75 765.32 23.01% 3,630.00 135-020-60100-000 Travel & per diem 86.46 0.00 86.46 100.00% 951.06 0.00 951.06 100.00% 1,038.00 135-020-60135-000 TCEQ Fees & Permits 999.60 0.00 999.60 100.00% 10,995.60 9,888.02 1,107.58 10.07% 12,000.00 135-020-60285-000 Lawn Equipment & Maintenance -6,167.20 0.00 -6,167.20 100.00% 7,160.80 5,740.00 1,420.80 19.84% 8,500.00 135-020-60331-000 Interfund Transfer Out -Tax I&S 9,683.20 10,567.70 -884.50 -9.13% 106,515.20 116,245.00 -9,729.80 -9.13% 116,245.00 135-020-60332-000 Interfund Transfer Out -Rev l&S 57,637.85 62,902.90 -5,265.05 -9.13% 634,016.35 691,931.70 -57,915.35 -9.13% 691,931.00 135-020-60360-000 Furniture/Equipment < $5000 41.65 346.60 -304.95 -732.17% 458.15 346.60 111.55 24.35% 500.00 135-020-65005-000 Fuel & Lube 1,041.25 1,338.97 -297.72 -28.59% 11,453.75 10,111.67 1,342.08 11.72% 12,500.00 135-020-65010-000 Uniforms 367.76 0.00 367.76 100.00% 4,045.36 2,931.96 1,113.40 27.52% 4,415.00 135-020-65030-000 Chemicals -7,292.75 0.00 -7,292.75 100.00% 19,779.75 22,109.42 -2,329.67 -11.78% 22,500.00 135-020-65031-000 Chemicals Collections 833.00 0.00 833.00 100.00% 9,163.00 6,002.80 3,160.20 34.49% 10,000.00 135-020-65045-000 Lab Supplies 2,748.90 213.79 2,535.11 92.22% 30,237.90 27,754.83 2,483.07 8.21% 33,000.00 135-020-65095-000 Maintenance Supplies 0.00 0.00 0.00 0.00% 0.00 2.70 -2.70 0.00% 0.00 135-020-69005-000 Capital Outlays 757,553.50 89,029.00 668,524.50 88.25% 1,503,088.50 1,230,778.23 272,310.27 18.12% 1,578,000.00 135-020-69008-000 Short Term Debt -Principal 7,144.30 0.00 7,144.30 100.00% 78,587.30 85,762.59 -7,175.29 -9.13% 85,766.00 135-020-69009-000 Short Term Debt -Interest 233.32 0.00 233.32 100.00% 2,566.52 2,834.91 -268.39 -10.46% 2,801.00 135-020-69195-000 GASB Reserve for Replacement 13,809.22 -62,000.00 75,809.22 548.98% 151,901.42 103,777.00 48,124.42 31.68% 165,777.00 Total Department: 020 - Wastewater: 977,260.74 215,460.45 761,800.29 77.95% 3,886,038.14 3,557,798.55 328,239.59 8.45% 4,178,314.00 Department: 026 - Board of Directors 135-026-50045-000 Workman's Compensation 1.24 0.62 0.62 50.00% 13.64 6.82 6.82 50.00% 15.00 135-026-60070-000 Dues & Memberships 62.47 0.00 62.47 100.00% 687.17 750.00 -62.83 -9.14% 750.00 135-026-60075-000 Meetings 124.95 231.98 -107.03 -85.66% 1,374.45 1,450.78 -76.33 -5.55% 1,500.00 9/15/2023 12:13:20 AM Page 3 of 7 17 of 113 September 20, 2023 Meeting Agenda Packet Monthly Budget Report For Fiscal: Current Period Ending: 08/31/2023 135-026-60080-000 135-026-60100-000 135-026-60245-000 Schools & Training Travel & per diem 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 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 Variance Variance August August Favorable Percent YTD YTD Favorable Percent Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget -3,131.80 0.00 -3,131.80 100.00% 200.20 535.00 -334.80 -167.23% 535.00 -4,583.50 0.00 -4,583.50 100.00% -418.50 0.00 -418.50 100.00% 0.00 -458.35 0.00 -458.35 100.00% -41.85 0.00 -41.85 100.00% 0.00 -7,984.99 232.60 -8,217.59 102.91% 1,815.11 2,742.60 -927.49 -51.10% 2,800.00 51,724.13 47,701.69 4,022.44 7.78% 568,965.43 533,453.50 35,511.93 6.24% 620,938.00 166.60 86.77 79.83 47.92% 1,832.60 1,053.27 779.33 42.53% 2,000.00 201.83 0.00 201.83 100.00% 2,220.13 2,422.50 -202.37 -9.12% 2,423.00 6,149.53 5,697.59 451.94 7.35% 67,644.83 64,275.26 3,369.57 4.98% 73,824.00 -27,251.05 6,755.22 -34,006.27 124.79% 69,618.45 70,908.28 -1,289.83 -1.85% 79,352.00 504.04 241.48 262.56 52.09% 5,544.44 2,822.50 2,721.94 49.09% 6,051.00 74.88 55.37 19.51 26.06% 823.68 573.53 250.15 30.37% 899.00 199.92 100.35 99.57 49.80% 2,199.12 4,377.15 -2,178.03 -99.04% 2,400.00 3,229.70 2,834.81 394.89 12.23% 35,526.70 31,707.36 3,819.34 10.75% 38,772.00 755.36 662.99 92.37 12.23% 8,308.96 7,481.29 827.67 9.96% 9,068.00 125.94 0.00 125.94 100.00% 1,385.34 58.55 1,326.79 95.77% 1,512.00 124.61 107.60 17.01 13.65% 1,370.71 1,183.60 187.11 13.65% 1,496.00 41.65 0.00 41.65 100.00% 458.15 198.45 259.70 56.68% 500.00 333.20 178.33 154.87 46.48% 3,665.20 2,741.90 923.30 25.19% 4,000.00 10,970.61 1,372.49 9,598.12 87.49% 120,676.71 88,448.69 32,228.02 26.71% 131,700.00 -5,750.50 450.00 -6,200.50 107.83% 6,744.50 6,473.19 271.31 4.02% 8,000.00 -16,668.00 4,538.00 -21,206.00 127.23% 16,652.00 22,532.91 -5,880.91 -35.32% 20,000.00 249.90 0.00 249.90 100.00% 2,748.90 0.00 2,748.90 100.00% 3,000.00 999.60 967.35 32.25 3.23% 10,995.60 12,356.44 -1,360.84 -12.38% 12,000.00 6,250.83 497.50 5,753.33 92.04% 68,759.13 74,769.87 -6,010.74 -8.74% 75,040.00 749.70 178.96 570.74 76.13% 8,246.70 7,053.87 1,192.83 14.46% 9,000.00 499.80 485.56 14.24 2.85% 5,497.80 5,231.46 266.34 4.84% 6,000.00 249.90 48.22 201.68 80.70% 2,748.90 121.33 2,627.57 95.59% 3,000.00 -5,382.07 1,577.04 -6,959.11 129.30% 14,917.23 15,328.54 -411.31 -2.76% 16,957.00 416.50 423.50 -7.00 -1.68% 4,581.50 4,518.20 63.30 1.38% 5,000.00 -3,501.00 167.11 -3,668.11 104.77% 21,489.00 22,006.92 -517.92 -2.41% 24,000.00 53,913.50 15,525.91 38,387.59 71.20% 133,048.50 137,452.45 -4,403.95 -3.31% 141,000.00 11,624.95 0.00 11,624.95 100.00% 12,874.45 48.65 12,825.80 99.62% 13,000.00 16,547.06 8,117.81 8,429.25 50.94% 90,017.66 89,295.91 721.75 0.80% 97,400.00 541.45 160.00 381.45 70.45% 5,955.95 6,964.55 -1,008.60 -16.93% 6,500.00 -6,668.00 1,731.25 -8,399.25 125.96% 26,652.00 26,863.83 -211.83 -0.79% 30,000.00 270.72 348.97 -78.25 -28.90% 2,977.92 626.14 2,351.78 78.97% 3,250.00 132.28 0.00 132.28 100.00% 1,455.08 0.00 1,455.08 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 0.00 416.50 100.00% 4,581.50 2,998.73 1,582.77 34.55% 5,000.00 3,886.00 0.00 3,886.00 100.00% 12,216.00 13,052.82 -836.82 -6.85% 13,053.00 44.14 306.50 -262.36 -594.38% 485.54 306.50 179.04 36.87% 530.00 9/15/2023 12:13:20 AM Page 4 of 7 18 of 113 September 20, 2023 Meeting Agenda Packet Monthly Budget Report For Fiscal: Current Period Ending: 08/31/2023 Variance Variance August August Favorable Percent YTD YTD Favorable Percent Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget 135-030-65055-000 Hardware 5,513.72 373.58 5,140.14 93.22% 12,510.92 13,587.13 -1,076.21 -8.60% 13,214.00 135-030-65085-000 Office Supplies 499.80 650.32 -150.52 -30.12% 5,497.80 4,209.64 1,288.16 23.43% 6,000.00 135-030-65095-000 Maintenance Supplies 333.20 428.31 -95.11 -28.54% 3,665.20 5,551.09 -1,885.89 -51.45% 4,000.00 135-030-69005-000 Capital Outlays 56,346.00 0.00 56,346.00 100.00% 56,346.00 74,952.60 -18,606.60 -33.02% 56,346.00 135-030-69170-000 Copier Lease Installments 333.20 *277.14 * 56.06 16.82% * 3,665.20 1 2,954.24 710.96 19.40% 4,000.00 135-030-69195-000 GASB Reserve for Replacement 2,227.10 0.00 2,227.10 100.00% 24,498.10 26,736.00 -2,237.90 -9.13% 26,736.00 Total Department: 030 -Administration: 171,427.23 103,047.72 68,379.51 39.89% 1,450,069.53 1,387,786.84 62,282.69 4.30% 1,578,549.00 Department: 039 - Non Departmental 135-039-55045-00L Legal -29,585.50 9,380.25 -38,965.75 131.71% 24,559.50 27,874.25 -3,314.75 -13.50% 30,000.00 135-039-55055-000 Auditing -3,984.46 612.85 -4,597.31 115.38% 24,170.94 23,163.95 1,006.99 4.17% 27,000.00 135-039-55060-000 Appraisal 1,077.90 ` 0.00 1,077.90 100.00% 11,856.90 _ 9,100.15 2,756.75 23.25% 12,940.00 135-039-55065-000 Tax Admin Fees 416.50 0.00 416.50 100.00% 4,581.50 4,046.00 535.50 11.69% 5,000.00 Total Department: 039 - Non Departmental: -32,075.56 9,993.10 -42,068.66 131.15% 65,168.84 64,184.35 984.49 1.51% 74,940.00 Total Expense: 2,165,234.08 1,395,166.52 770,067.56 35.57% 11,939,114.88 10,715,809.65 1,223,305.23 10.25% 12,921,200.00 Total Revenues 1,687,011.37 1,616,385.74 -70,625.63 -4.19% 11,460,895.07 10,840,181.71 -620,713.36 -5.42% 12,442,977.00 Total Fund: 135 - MUD 1 General Fund: -478,222.71 221,219.22 699,441.93 -478,219.81 124,372.06 602,591.87 -478,223.00 Report Total: -478,222.71 221,219.22 699,441.93 -478,219.81 124,372.06 602,591.87 -478,223.00 9/15/2023 12:13:20 AM Page 5 of 7 19 of 113 September 20, 2023 Meeting Agenda Packet Monthly Budget Report For Fiscal: Current Period Ending: 08/31/2023 Group Summary Variance Variance August August 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 1,687,011.37 1,616,385.74 -70,625.63 -4.19% 11,460,895.07 10,840,181.71 -620,713.36 -5.42% 12,442,977.00 Total Revenue: 1,687,011.37 1,616,385.74 -70,625.63 -4.19% 11,460,895.07 10,840,181.71 -620,713.36 -5.42% 12,442,977.00 Expense 010 - Water 020 - Wastewater 026 - Board of Directors 030 - Administration 039 - Non Departmental 1,056,606.66 1,066,432.65 -9,825.99 -0.93% 6,536,023.26 5,703,297.31 832,725.95 12.74% 7,086,597.00 977,260.74 215,460.45 761,800.29 77.95% 3,886,038.14 3,557,798.55 328,239.59 8.45% 4,178,314.00 -7,984.99 232.60 -8,217.59 102.91% 1,815.11 2,742.60 -927.49 -51.10% 2,800.00 171,427.23 103,047.72 68,379.51 39.89% 1,450,069.53 1,387,786.84 62,282.69 4.30% 1,578,549.00 -32,075.56 9,993.10 -42,068.66 131.15% 65,168.84 64,184.35 984.49 1.51% 74,940.00 Total Expense: 2,165,234.08 1,395,166.52 770,067.56 35.57% 11,939,114.88 10,715,809.65 1,223,305.23 10.25% 12,921,200.00 Total Revenues 1,687,011.37 1,616,385.74 -70,625.63 -4.19% 11,460,895.07 10,840,181.71 -620,713.36 -5.42% 12,442,977.00 Total Fund: 135 - MUD 1 General Fund: -478,222.71 221,- 219.22 699,441.93 -478,219.81 124,372.06 602,591.87 -478,223.00 Report Total: -478,222.71 221,- 219.22 699,441.93 -478,219.81 124,372.06 602,591.87 -478,223.00 9/15/2023 12:13:20 AM Page 6 of 7 20 of 113 September 20, 2023 Meeting Agenda Packet Monthly Budget Report For Fiscal: Current Period Ending: 08/31/2023 Fund Summary Variance Variance August August Favorable Percent YTD YTD Favorable Percent Fund Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget 135 - MUD 1 General Fund -478,222.71 221,219.22 699,441.93 -478,219.81 124,372.06 602,591.87 -478,223.00 Report Total: -478,222.71 221,219.22 699,441.93 -478,219.81 124,372.06 602,591.87 -478,223.00 9/15/2023 12:13:20 AM Page 7 of 7 21 of 113 Department Trophy Club Municipal Utility District No. 1 Asset 000 - Revenue, Asset, Liability, & Equity Liability 000 - Revenue, Asset, Liability, & Equity Equity 000 - Revenue, Asset, Liability, & Equity 122 - Trophy Club MUD Fire Dept. 135 - MUD 1 General Fund 824,015.05 11,586, 690.55 September 20, 2023 Meeting Agenda Packet Balance Sheet Funds 122 - 528 Account Summary As Of 08/31/2023 137 - MUD 1 519 - 2016 Rev 520 - Revenue 528 - 2015 Consolidated Bond Const -SWIFT Bond 16" Revenue Bond Total GASB Waterline Reserve Fund 3,258,146.58 813,745.15 1,173,923.91 938,238.63 18,594,759.87 Total Asset: 824,015.05 11,586,690.55 3,258,146.58 813,745.15 1,173,923.91 938,238.63 18,594,759.87 -17,884.96 1,014,780.42 0.00 81,691.15 0.00 0.00 1,078,586.61 Total Liability: -17,884.96 1,014,780.42 0.00 81,691.15 0.00 0.00 1,078,586.61 681,803.57 10,447,538.07 2,985,574.58 705,530.20 1,339,096.93 900,604.41 17,060,147.76 Total Total Beginning Equity: 681,803.57 10,447,538.07 2,985,574.58 705,530.20 1,339,096.93 900,604.41 17,060,147.76 Total Revenue Total Expense Revenues Over/Under Expenses Total Equity and Current Surplus (Deficit): Total Liabilities, Equity and Current Surplus (Deficit): 1,515,556.81 10,840,181.71 272,572.00 26,523.80 51,015.19 37,634.22 12,743,483.73 1,355,460.37 10,715,809.65 0.00 0.00 216,188.21 0.00 12,287,458.23 160,096.44 841,900.01 824,015.05 124,372.06 10,571,910.13 11,586,690.55 272,572.00 3,258,146.58 3,258,146.58 26,523.80 732,054.00 813,745.15 -165,173.02 1,173,923.91 1,173,923.91 37,634.22 938,238.63 938,238.63 456,025.50 17,516,173.26 18,594,759.87 Monthly Financial Activity Footnotes: Fund 122 Activity Daily property tax deposits Monthly transfer OUT to MUD General Fund to cover Town transfers and any other A/P expenses Fund 135 Activity • Daily property tax deposits All A/P checks are cut through the General Fund Monthly transfer IN to cover other fund A/P expenses Monthly transfer OUT for l&S Revenue Bond payments for Fund 534, 535, & 536 Monthly bank interest Fund 137 Activity Transfer IN at beginning of fiscal year based on yearly budget and transfer OUT at fiscal year-end based on reserves balances Fund 519 Activity Monthly bank interest Fund 520 Activity Transfer OUT to MUD General Fund to cover Interconnect Waterline construction project expenses Monthly bank interest Fund 528 Activity Monthly bank interest 9/15/2023 12:48:54 AM 22 of 113 Page 1 of 1 Department Asset Trophy Club Municipal Utility District No. 1 533 - MUD 1 I&S 534 - 2015 Consolidated Revenue Bond I&S 000 - Revenue, Asset, Liability, & Equity 66,075.90 Total Asset: 66,075.90 000 - Revenue, Asset, Liability, 8t Equity Total Liability: 29,302.23 000 - Revenue, Asset, Liability, & Equity Total Total Beginning Equity: 4,145.11 1,041,311.14 1,008,682.58 Liability Equity 29,302.23 535 - 2016 Rev Bond l&S-SWIFT 38,966.70 11,662.57 38,966.70 11,662.57 536 - 2019 Rev Bond I&S- W&WW System 6,447.81 6,447.81 0.00 0.00 0.00 0.00 0.00 0.00 4,145.11 27,958.35 Total Revenue Total Expense Revenues Over/Under Expenses Total Equity and Current Surplus (Deficit): Total Liabilities, Equity and Current Surplus (Deficit): 6,554.77 1,429.17 September 20, 2023 Meeting Agenda Packet Balance Sheet I&S Funds 533 - 536 Account Summary As Of 08/31/2023 Total 123,152.98 123,152.98 29,302.23 27,958.35 615,645.85 604,637.50 6,554.77 1,429.17 280,646.30 275,538.50 384,556.14 379,537.50 29,302.23 40,087.40 40,087.40 2,322,159.43 2,268,396.08 32,628.56 36,773.67 66,075.90 11,008.35 38,966.70 38,966.70 5,107.80 11,662.57 11,662.57 5,018.64 6,447.81 6,447.81 53,763.35 93,850.75 123,152.98 Monthly Financial Activity Footnotes: Fund 533 Activity Daily property tax deposits Monthly transfer IN from Fund 135 for PID portion of semi-annual GO Bond payments 3/1 & 9/1 GO Bond payments (Interest and Principal) Monthly bank interest Fund 534 Activity Monthly transfer IN for semi-annual I&S Revenue Bond payment from Fund 533 3/1 & 9/1 Revenue Bond payments (Interest and Principal) Monthly bank interest Fund 535 Activity Monthly transfer IN for semi-annual I&S Revenue Bond payment from Fund 533 3/1 & 9/1 Revenue Bond payments (Interest and Principal) Monthly bank interest Fund 536 Activity Monthly transfer IN for semi-annual MS Revenue Bond payment from Fund 533 3/1 & 9/1 Revenue Bond payments (Interest and Principal) Monthly bank interest 9/15/2023 12:52:11 AM 23 of 113 Page 1 of 1 September 20, 2023 Meeting Agenda Packet CASH STATUS AS OF AUGUST 2023 TexPool 0 & M (XXXXX0002)-Fire Operating Cash Restricted - Unable to be spent Unrestricted- Available for spending Total in Accounts (Restricted & Unrestricted) 135-10250 TexPool 0 & M (XXXXX0002)-General Fund Operating *** Prosperity Bank (XXX8701) Fire Operating $0 $2,600,731 $2,600,731 135-10300 Prosperity Bank (XXX8701) General Fund Operating * $142,305 $5,660,898 $5,803,203 135-10305 Prosperity Bank Reserve -Savings Acct (XXXXX7724) $1,355,177 $0 $1,355,177 135-11100 Petty Cash Administration $0 $150 $150 135-11150 Petty Cash Utility Billing $0 $450 $450 137-10250 TexPool 0 & M (XXXXX0002) GASB Replacement $3,258,147 $0 $3,258,147 519-10250 Texpool Revenue Bond Construction (XXXXX015) SWIFT $0 $0 $0 519-11155 Cash -Bond Escrow Bank of Texas (SWIFT) $813,745 $0 $813,745 520-10250 Texpool Revenue Bond Water & Waste Water Systems 2019 (XXXXX018) $1,173,924 $0 $1,173,924 520-10300 Prosperity Bank Construction Water & Waste Water Systems 2019 $0 $0 $0 528-10250 TexPool Revenue Bond Reserve (XXXXX014) WWTP Improvements $938,239 $0 $938,239 533-10250 TexPool Tax I & S (XXXXX0003) $84,590 $0 $84,590 533-10300 Prosperity Bank (XXX8701) Tax I&S $0 $0 $0 534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements $38,967 $0 $38,967 535-10250 Texpool Revenue I & S (XXXXX017) SWIFT $11,663 $0 $11,663 536-10250 TexPool Revenue I & S (XXXXX020) Water & Waste Water Systems $6,448 $0 $6,448 $8,262,229 $16,085,432 Amount available in cash for spending (MUD Accounts) *8/31/2023 Customer Water Deposits $142,305 Fire Department Cash $8,262,229 122-10250 TexPool 0 & M (XXXXX0002)-Fire Operating Cash $0 $762,984 $762,984 122-10300 Prosperity Bank (XXX8701) Fire Operating $0 $71,155 $71,155 $0 $834,139 $834,139 Amount available in cash for spending (Fire Department Accounts) $834,139 General Fund 135 Available $ 5,660,898 Prosperity General Fund $ 2,600,731 Texpool General Fund $ 600 Petty Cash Total General Fund 135 Available for Spending $ 8,262,229 General Fund 135 Fund Balances Nonspendable Fund Balance (Prepaids) $ 3,880 Assigned Fund Balance (FY2023 Capital Projects plus prior year carry forward) $ 4,770,878 Unassigned Fund Balance $ 5,672,780 Current Year Revenue/Expenses $ 124,372 Total Nonspendable, Assigned & Committed Fund Balances - General Fund 135 $10,571,910 24 of 113 ebills Bills Mailed Bank Draft Credit Card Draft Online Payments Late Notices Disconnects Connections MUD Connections PID September 20, 2023 Meeting Agenda Packet August Utility Billing Report Fiscal Year 2022 - 2023 August 2022 September 2022 October 2022 November 2022 December 2022 January 2023 February 2023 March 2023 April 2023 May 2023 June 2023 July 2023 July 2023 1,629 1,654 1,667 1,710 1,746 1,765 1,777 1,773 1,767 1,794 1,766 1,750 1,744 3,850 3,832 3,822 3,801 3,768 3,741 3,751 3,744 3,743 3,734 3,755 3,749 3,747 704 703 706 711 630 606 599 599 590 588 589 585 578 1,484 1,481 1,501 1,494 2,251 2,540 2,719 3,016 2,998 2,754 3,134 3,101 2,957 1,170 1,203 1,159 1,049 310 326 337 0 0 0 547 413 289 290 327 327 268 5 2 0 4 0 0 0 0 8 9 9 13 7 3398 3399 3399 3399 3399 3394 3394 3394 3394 3394 3395 3395 3395 1443 1444 1444 1444 1444 1444 1443 1443 1443 1443 1443 1443 1443 August Permits Fiscal Year 2023 Date of Permit Permit No. Customer Deposit Due to FW Water Oversize Meter Plumbing Inspections Sewer Inspections Fire Line Misc. Income Total $ Total $ - $ - $ - $ - $ - $ - $ - $ 25 of 113 September 20, 2023 Meeting Agenda Packet tcmud.org Website Overview August 2023 Traffic: Website Users 1,664 New Users 1,310 Average Engagement Time 1m 18s Acquisition: Direct 1,004 sessions/ 747 Users Organic Search 1,126 Sessions/ 814 Users Referral 63 Sessions/ 35 Users Organic Social 8 sessions/ 8 Users Pages: Home 4,363 Views/ 1,297 Users Your Bill 264 Views/ 212 Users Financial Transparency 137 Views/ 23 Users Request Forms 133 Views/ 86 Users Watering Schedule 110 Views/ 91 Users Agendas/Meetings 107 views/ 31 users Elections 99 views/ 53 users Water Service 92 Views/ 80 Users News 89 Views/ 70 users Service Area Map 86 Views/ 74 Users 26 of 113 September 20, 2023 Meeting Agenda Packet Community Outreach Program Performance Overview August 2023 Facebook Page Reach New Page Likes Posts Page Visits 3,572 Accounts (Up 596.3% compared to the prior month) 36 (Up 1,100% compared to the prior month) 8 (Up 60% compared to prior month) 1,997 (Up 307.6% compared to prior month) 0 Facebook reach e 3,572 596.3% 3,000 2,000 1,000 0 Aug 3 Aug 7 Aug 11 Aug 15 Aug 19 Daily Aug 23 Aug 27 Screenshot from Meta Business Suite dashboard for the Trophy Club Municipal Utility District No.1 Facebook Page 27 of 113 Cumulative Aug September 20, 2023 Meeting Agenda Packet Posted: August 14, 2023 at 1:00 PM Performance Reach 0 Engagements 0 Negative interactions 0 Total Reactions 593 0 0 Organic 593 (100%) Comments 0 0 Paid 0 (0%) Shares 1 View details Trophy Club Municipal Utility District No.1 August t4 - et C Dive into National Water Quality Month: Understanding Poor Water Quality C In a world where clean water is a lifeline, National Water Quality Month prompts us to explore the factors affecting our water's purity. • le Imagine a day without a cool drink, a refreshing swim, or water for life to thrive. This month, we're reminded of water's vital role, from ecosystems to our own lives. We should all reflect on daily habits that impact water quality— it's a step towards preserving this invaluable resource. r Today, we're taking a look at four common -factors that contribute to poor water quality. 1. Industrial Waste: Improper disposal pollutes waterways from manufacturing plants. 2. Agricultural Runoff: Fertilizers cause harmful algae blooms, harming aquatic fife. 3. Untreated Waste: Aging infrastructure leaks sewage into groundwater and surface water. 4. Home Chemicals: Even household pesticides can threaten water sources. You can help make a positive impact on water quality! 0 Start by being vigilant about proper disposal of household chemicals and pesticides, preventing them from seeping into the water supply. When tending to your yard, opt for environmentally friendly alternatives to harmful fertilizers to prevent agricultural runoff. Regularly maintain your plumbing systems to avoid untreated waste leakage, which can endanger both groundwater and surface water. Your conscious efforts can help reduce the industrial waste burden on our local waterways. By making these small yet significant changes, you're contributing to a cleaner, safer water future for us all. DIVE IN: NATIONAL WATER QUALITY MONTH UNDERSTANDING WATER QUALITY IT'S IMPORTANT FOR ALL OF US TO UNDERSTAND THE RIPPLE EFFECTS OF HUMAN IMPACT! Screenshots from Meta Business Suite dashboard for the Trophy Club Municipal Utility District No.1 Facebook Page 28 of 113 September 20, 2023 Meeting Agenda Packet Posted: August 18, 2023 at 4:28 PM Performance Reach 0 Engagements 0 Negative interactions 0 Total Reactions Total 139 0 0 Organic 139 (100%) Comments 0 Unique Paid 0 (0%) Shares 0 View details Trophy Club Municipal Utility District No.1 August 18 at 428 PM Welcome back to our National Water Quality Month series, where we're diving into the positive changes that come with cleaner, healthier water. 6 The Ripple Effect of Clean Water Clean water isn't just a luxury — it's a catalyst for change. When we invest in improving water quality, we're nurturing a host of tangible benefits that reach far beyond the surface. lei Healthier Communities: Access to safe drinking water reduces waterborne diseases, promoting the well-being of everyone. iO Thriving Ecosystems: Cleaner water supports diverse aquatic life, leading to more robust and balanced ecosystems. 0 Recreation Revived: Rivers, lakes, and beaches became inviting havens for swimming, boating, and fishing. 0 Economic Prosperity: Businesses flourish as improved water quality draws tourism and supports industries reliant on clean water. By championing water quality, we're fostering a brighter future for our environment, our communities, and ourselves. Join us in celebrating the positive transformations that clean water brings. ¥1IONALATER THE BENEFITS OF WATER QUALITY 11 WHEN WE WORK TOGETHER, THE RESULTS OF OUR COMMITMENT TO GLEAN WATER BENEFIT THE WHOLE COMMUNITY. Screenshots from Meta Business Suite dashboard for the Trophy Club Municipal Utility District No.1 Facebook Page 29 of 113 0 September 20, 2023 Meeting Agenda Packet Posted: August 22, 2023 at 3:45 PM Performance Reach 0 Engagements 0 Negative interactions 0 Total Reactions Tota I 232 1 0 Organi 232 (100%) Comments Paid 0 (0%) Shares View details 0 Unique 0 Trophy Club Municipal Utility District No. 1 August 22 at 3,45 PM (3 As stewards of our environment, each of us plays a vital role in safeguarding water quality right from our homes. r 6 Simple Steps, Powerful Impact Maintaining clean water starts with mindful choices. Here are practical tips you can incorporate into your daily routine to contribute to healthier water sources: Mindful Landscaping: Opt for native plants and natural fertilizers to minimize harmful runoff. Proper Waste Disposal• Dispose of chemicals, oils, and hazardous waste responsibly to prevent contamination. Sustainable Cleaning: Choose eco -friendly cleaning products to avoid harmful chemicals entering water systems. Limit Pesticide Use: Minimize pesticide application to protect aquatic life and groundwater quality. Conservative Water Use: Fix leaks promptly, install water -efficient appliances, and practice water -conscious habits. • By adopting these practices, you're becoming a vital part of the solution, ensuring that clean water remains abundant for generations to come. Let's unite as water guardians and embrace these small changes with significant impacts. WATER QUALITY TIPS TOGETHER WE MAKE A DIFFERENCE DISCOVER PRACTICAL HOME TIPS FOR VSAFEGUARDING WATER QUALITY Screenshots from Meta Business Suite dashboard for the Trophy Club Municipal Utility District No.1 Facebook Page 30 of 113 0 September 20, 2023 Meeting Agenda Packet Posted: August 27, 2023 at 11:28 AM Performance Reach 0 Engagements 0 Negative interactions 0 Total Reactions Total 1,865 9 0 Organic 1,865 (100%) Comments 4 Unique Paid 0 (0%) Shares 6 View details Trophy Club Municipal Utility District No. 1 August 27 at 11:2B AM•p Attention i Due to a 14 Inch water main break near the intersection of Trophy Club Drive and Indian Creek Drive, residents in this area may experience disruption of service. We apologize for any inconvenience and appreciate your patience while staff works diligently to make repairs. Screenshots from Meta Business Suite dashboard for the Trophy Club Municipal Utility District No.1 Facebook Page 31 of 113 0 September 20, 2023 Meeting Agenda Packet Posted: August 27, 2023 at 8:33 PM Performance Reach 0 Engagements 0 Negative interactions 0 Total Reactions Total 2,454 19 0 Organic 2454 (100%) Comments 20 Unique 0 Paid 0 (0%) Shares 4 ti View details Trophy Club Municipal Utility District No. 1 August 27 at 8'33 P 1 UPDATE 8:33pm - We currently do not have an ETA on repair completion. This is a very large break and our crew is working around the clock to get this fixed. If you need bottled water please reach out to us at 682-831-4600. We know this is a frustrating situation and are extremely sorry for the inconvenience this has caused. Screenshots from Meta Business Suite dashboard for the Trophy Club Municipal Utility District No.1 Facebook Page 32 of 113 September 20, 2023 Meeting Agenda Packet Posted: August 28, 2023 at 2:22 AM Performance Reach 0 Engagements 0 Negative interactions 0 Total Reactions 869 19 0 Organi 869 (100%) Comments 1 Unique Paid 0 (0%) Shares 1 View details Trophy Club Municipal Utility District No. 1 August 28 at 2:22 AM • Q Update - 2:20 am Main break has been repaired and water service has been restored. Thank you for your patience, we greatly appreciate it. Screenshots from Meta Business Suite dashboard for the Trophy Club Municipal Utility District No.1 Facebook Page 33 of 113 0 Posted: August 31, 2023 at 1:13 PM Performance Reach 0 40 September 20, 2023 Meeting Agenda Packet Engagements 0 Negative interactions 0 Reactions Total 0 0 Organic 40 (100%) Comments Paid 0 (0%) Shares 0 Unique 0 View details Trophy Club Municipal Utility District No. 1 August 31 at 1:13 PM •Q As we conclude our National Water Quality Month celebration, here are some creative and engaging ways to involve your children in the mission to conserve water: • Educational Play: Use water -themed games and puzzles to spark conversations about water's importance. 6 Drip Detective: Hunt for leaks together, fixing faucets and pipes to prevent wastage. • Bucket List Adventures: Collect rainwater for plants and explore rain as a valuable resource. Time Challenges: Encourage shorter showers by setting fun timers for them. „id Eco -Art Transform recycled materials into water -themed crafts and artwork. *, Mealtime Lessons: Discuss water's role in food and incorporate water -wise eating habits. C) Community Advocates: Join local clean-up efforts to foster a sense of collective responsibility. By cultivating these practices, you're not only instilling water -saving habits but also nurturing a generation that cherishes and protects our planet's most precious resource. Let's raise water - wise kids who'll make waves of positive change! ®• TEACHING THE VALUE NATIONAL WATER QUALITY MONTH ATER CONS 0 NURTURING A GENERATION OF ECO -CONSCIOUS MINDS STARTS AT HOME Screenshots from Meta Business Suite dashboard for the Trophy Club Municipal Utility District No.1 Facebook Page 34 of 113 0 September 20, 2023 Meeting Agenda Packet REGULAR MEETING MINUTES TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 BOARD OF DIRECTORS August 23, 2023, at 6:30 p.m. Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in a regular meeting on August 23, 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 Tracey Hunter Director BOARD MEMBERS ABSENT: William C. Rose Director STAFF PRESENT: Alan Fourmentin Laurie Slaght Mike McMahon Steven Krolczyk Emily Rogers General Manager District Secretary Operations Manager Finance Manager General Legal Counsel CALL TO ORDER AND ANNOUNCE A QUORUM President Carr announced the date of August 23, 2023, called the meeting to order and announced a quorum present at 6:31 p.m. CITIZEN COMMENTS There were no citizen comments REPORTS & UPDATES 1. Staff Reports a. Capital Improvement Projects b. Operations Reports c. Finance Reports d. Digital Platform Analytics General Manager Alan Fourmentin presented the monthly reports and answered questions related thereto. CONSENT AGENDA 2. Consider and act to approve the Consent Agenda. a. July 19, 2023, Regular Meeting Minutes b. August 2, 2023, Special Session Minutes 35 of 113 September 20, 2023 Meeting Agenda Packet c. August 16, 2023, Special Session Minutes d. Appointment of Wholesale Water Advisory Committee Director Carr removed item d. Appointment of Wholesale Water Advisory Committee for further discussion. Motion made by Director Harper and seconded by Director Brewster to approve Consent Agenda items a. b. c. as presented. Motion carried unanimously. Motion made by Director Harper and seconded by Director Brewster to approve consent agenda item d. Appointment of Wholesale Water Advisory Committee members with the primary being Mike McMahon, Operations manager and Alan Fourmentin, General Manager as the alternate. Motion carried unanimously REGULAR SESSION 3. Receive update from Strategic Committee. (Carr/Harper) Director Carr stated there was no update. 4. Consider and act to adopt Order No. 2023-0823A declaring the 2011 Brush truck to be surplus property of the District and authorize staff to sell such property. Motion made by Director Hunter and seconded by Director Brewster to adopt Order No. 2023-0823A declaring the 2011 Brush truck to be surplus property of the District and authorize staff to sell such property to the Ponder Volunteer Fire Department for $60,000. Motion carried unanimously. 5. Consider and act to approve Resolution No. 2023-0823A Amending the Fiscal Year 2023 Budget. Motion made by Director Harper and seconded by Director Brewster to approve Resolution No. 2023- 0823A Amending the Fiscal Year 2023 Budget. Motion carried unanimously. 6. Discussion and possible action regarding FY 2024 draft budget. Motion made by Director Brewster and seconded by Director Harper to approve the draft FY2024 budget. Motion carried unanimously. 7. Consider and act regarding tax rates for 2023 tax year: a. Approve proposed tax rate for 2023 tax year; and, b. Schedule date and authorize publication of notice for hearing regarding adoption of final tax rates for 2023 tax year. 36 of 113 September 20, 2023 Meeting Agenda Packet Motion made by Director Harper and seconded by Director Hunter to approve the proposed tax rate of $0.06381 per $100 dollars of assessed valuation for publication for the 2023 tax year and authorize staff to proceed with publication of public hearing to be conducted on September 20, 2023. Motion is amended by the first and second to add setting the date for the public hearing Amendment to the motion passes unanimously Main Motion as amended carried unanimously EXECUTIVE SESSION - THE BOARD DID NOT CONVENE INTO EXECUTIVE SESSION. 8. 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 regarding the Amended and Restated Interlocal Cooperation Agreement for Administration of Fire Protection Services between the District and the Town of Trophy Club, and seek legal advice regarding the potential renewal, termination, modification, or replacement thereof. REGULAR SESSION 10. Discussion and possible action regarding Amended and Restated Interlocal Cooperation Agreement for Administration of Fire Protection Services with Town of Trophy Club. Motion made by Director Brewster and seconded by Director Harper to approve Amended and Restated Interlocal Cooperation Agreement for Administration of Fire Protection Services with the Town of Trophy Club. Motion carried unanimously. 11. Items for future agendas: 12. Future Meeting date(s): September 20, 2023, at 6:30 p.m. ADJOURN President Carr called the meeting adjourned at 7:23 p.m. Kevin R. Carr, President Doug Harper, Secretary/Treasurer Laurie Slaght, District Secretary 37 of 113 (SEAL) September 20, 2023 Meeting Agenda Packet 38 of 113 September 20, 2023 Meeting Agenda Packet CERTIFICATE OF RESOLUTION 2023-0920A THE STATE OF TEXAS COUNTIES OF DENTON AND TARRANT I, the undersigned member of the Board of Directors of Trophy Club Municipal Utility District No. 1 of Denton and Tarrant Counties, Texas (the "District"), hereby certify as follows: 1. That I am the duly qualified Secretary of the Board of Directors of the District, and that, as such, I have custody of the minutes and records of the District. 2. That the Board of Directors of the District convened in Open Session at a Regular Meeting on September 20, 2023, at the regular meeting place thereof, and the roll was called of the duly constituted officers and members of the Board of Directors, to wit: Kevin R. Carr President Ben Brewster Vice President Doug Harper Secretary/Treasurer William C. Rose Director Tracey Hunter Director All members of the Board were present except , thus constituting a quorum. Whereupon, among other business, the following was transacted at such meeting: A RESOLUTION APPROVING THE 2024 FISCAL YEAR BUDGET OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 and duly introduced for the consideration of the Board of Directors of the District. It was then duly moved and seconded that such Resolution be adopted and, after due discussion, such motion, carrying with it the adoption of such Resolution, prevailed, and carried by the following vote: AYES: NAYS: ABSTENSIONS: 3. That a true, full and correct copy of such Resolution adopted at such meeting is attached to and follows this certificate; that such resolution has been duly recorded in the minutes of the Board of Directors for such meeting; that the persons named in the above and foregoing Paragraph 2 were the duly chosen, qualified and acting officers and members of the Board of Directors as indicated therein, that each was duly and sufficiently notified officially and personally, in advance, of the time, place and purpose of such meeting, and 39 of 113 September 20, 2023 Meeting Agenda Packet that such Resolution would be introduced and considered for adoption at such meeting, and that each consented, in advance, to the holding of such meeting for such purpose; that the canvassing of the officers and members of the Board of Directors present at and absent from such meeting and of the votes of each on such motion, as set forth in the above and foregoing Paragraph 2, is true and correct; and that sufficient and timely notice of the hour, date, place and subject of such meeting was given and posted as required by Chapter 551, Texas Government Code, as amended. SIGNED AND SEALED the 20th day of September 2023. Doug Harper, Secretary/Treasurer Board of Directors Laurie Slaght, District Secretary 40 of 113 (SEAL) September 20, 2023 Meeting Agenda Packet RESOLUTION NO. 2023-0920A A RESOLUTION APPROVING THE 2024 FISCAL YEAR BUDGET OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 WHEREAS, Trophy Club Municipal Utility District No. 1 (the "District") is a conservation and reclamation district of the State of Texas created under Article XVI, Sec. 59 of the Texas Constitution, and the District operates under Chapters 49 and 54 of the Texas Water Code, as amended; WHEREAS, Section 49.057(b) of the Texas Water Code requires the board of directors of a water district to adopt an annual budget; WHEREAS, Title 30, Section 293.97(b), Texas Administrative Code, provides that an operating budget shall be passed and approved by a resolution of the governing board of a water district and shall be made a part of the governing board minutes; and WHEREAS, the Board of Directors of the District desires to adopt a budget for the 2022 fiscal year in an open, public meeting, proper notice of which has been given as required by law. NOW THEREFORE BE IT RESOLVED BY THE BOARD OF DIRECTORS OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1: Section 1. That the facts and recitations found in the preamble of this Resolution are hereby found and declared to be true and correct and are incorporated by reference herein and expressly made a part hereof, as if copied verbatim. Section 2. That the annual budget of revenues and expenditures necessary for conducting the operations and affairs of the District for Fiscal Year 2024, attached hereto, and incorporated herein as Exhibit A, is hereby approved, and adopted. Said budget document shall be on file for public inspection in the office of the District. Section 3. The District's audited financial statements, bond transcripts; and engineer's reports required by Texas Water Code § 49.106, are hereby incorporated to the District's budget as an appendix as required by Texas Water Code § 49.057(b). 41 of 113 September 20, 2023 Meeting Agenda Packet Section 4. That the District's expenditures during the fiscal year shall be made in accordance with the approved budget and any amendments thereto approved by the Board of Directors. Section 5. A copy of this Resolution and the budget approved hereby shall be attached to the minutes of the Board's September 20, 2023, meeting. Section 6. passage. That this Resolution shall become effective immediately upon its RESOLVED, PASSED AND APPROVED by the Board of Directors of Trophy Club Municipal Utility District No. 1, this the 20th day of September 2023. Kevin R. Carr, President Board of Directors Doug Harper, Secretary/Treasurer Board of Directors Laurie Slaght, District Secretary 42 of 113 (SEAL) September 20, 2023 Meeting Agenda Packet EXHIBIT "A" (Approved FY 2024 Budget) 43 of 113 September 20, 2023 Meetin: A:enda Packet Trophy Club Municipal Utility District No. 1 100 Municipal Drive Trophy Club, Texas 76262 (682) 831-4600 44 of 113 15,000 1,324,945 541,701 179,500 2,061,146 2,061,146 2,061,146 1,264,340 Total Revenue 1,264,340 Debt Service Expense 1,264,340 Total Expense 1,264,340 Trophy Club MUD No. 1 September 20, 2023 Meeting Agenda Packet FY 2024 ADOPTED BUDGET TAX RATE SUMMARY COMPARISON Fiscal Years 2023 2024 % of lncrease/Decrease MUD Tarrant Co. Fiscal Years 2023 2024 % oflncrease/Decrease MUD Denton Co. M&O (General Fund) Tax 0.00393 0.00336 -14.70% 919,078,121 M&O Fire Tax 0.05625 0.05186 -7,81% 12,316,662 M&O Tax Rate 0.06019 0.05522 -8.26% Increase/Decrease: -0.01081 -0.00497 I & 5 (Debt Service) Tax 0.03115 0.00859 -72.42% Increase/Decrease: -0.00374 -0.02256 Total Tax Rate: 0.09134 0.06381 -30.14% J Increase/Decrease: -0.01454 -0.02753 PROPERTY VALUE SUMMARY COMPARISON Fiscal Years 2023 2024 % of lncrease/Decrease MUD Tarrant Co. 590,349,578 677,155,614 14.70% MUD Denton Co. 1,645,315,777 1,877,675,027 14.12% PID 919,078,121 1,032,220,715 12.31% Out of District & PID 704,864 12,316,662 1647.38% Total Value: • 3,155,448,340 3,599,368,018 14.07% FY 2024 BUDGET FUND SUMMARY General Fund Revenue Tax Collections PID Surcharges Reserve Funds Total Revenue 12,211,712 85,734 143,223 1,983,264 14,423,933 Water Expense Wastewater Expense Board of Directors Expense Administration Expense Non -Departmental Expense Total Expense 9,179,933 3,506,324 11,765 1,612,840 113,071 14,423,933 Net Budget Surplus/Deficit $0 Tax Debt Service Fund Revenue Tax Collections PID Surcharge 200,771 219,481 115,886 Total Revenue 536,138 Debt Service Expense 536,138 Total Expense 536,138 Net Budget Surplus/Deficit so Fire Fund Revenue Tax Collections PID Assessment Reserve Funds Total Revenue Fire Expense Total Expense Net Budget Surplus/Deficit so Revenue Debt Service Fund Revenue Net Budget Surplus/Deficit so 45 of 113 September 20, 2023 Meeting Agenda Packet FY 2024 Budget Calendar 4/1/2023 - 4/29/2023 Create Budget Calendar Create new fiscal year baseline budget in Excel and Clear Gov Operational Budget 5/2/2023- 5/27/2023 Departmental budget meeting for base budget needs and wants, review calendar and set expectations 5/31/2023 - 6/4/2023 First round of Departmental Proposals should be submitted for review Detail explanation on account increases and capital request with quotes and supporting documents 6/5/2023 Budget meeting with Town/Fire staff to review and update the Fire Budget, Budget Committee meeting to review draft Present a projected General Fund and Fire Fund budget summary at the June Board meeting 6/8/2023 - 6/11/2023 Update excel budget worksheets YTD thru May, Revenue and Tax Bond Debt, TexPool Transfers (I&S) employee cost projections, preliminary tax valuations, and consumption forecasting and demands 6/14/2023 Meeting with General Manager, Operations Manager, and Finance Manager to discuss 5 year CIP projection Impact to rates and Cash Reserves, and overall projected budget review 6/17/2023 - 6/24/2023 Meet with department supervisors to address budget demands and required reductions All departmental budget proposal submissions and documents are due to Finance Department 6/25/2023 - 6/28/2023 Review and approve resubmittal department proposals, reach out to Fire Department/Town for proposed Fire Budget, update the excel budget with preliminary tax evaluations, and calculate preliminary District tax rate 6/30/2023 Provide consumption numbers and draft budget numbers for rate calculations to NewGen for rate assessment calculations 7/6/2023 Budget Committee Meeting to review initial draft budget and discuss potential rate impacts 7/13/2023 Meet with General Manager to present proposed budget Review 5 year capital plan and preliminary tax valuations to put together for July Board Meeting 7/25/2023 Certified Tax Roll numbers released, update Tax Assessment worksheet, and update budget projections Calculate HS tax averages and Comptroller Developed Water District Voter -Approval Tax Rate Worksheet 7/27/2023 Final projected budget numbers to NewGen for rate assessment and updated Rate Model 8/2/2023 Special Board Budget Workshop to review General Fund and Fire Fund Details 8/7/2023 Notify Town of Trophy Club of proposed Fire Assessment Rate and get final updated projected and proposed numbers 8/16/2023 Special Board Budget Workshop to review Fire Budget details with Fire Chief 8/17/2023 - 8/18/2023 Update and finalize the fiscal year draft General Fund and Fire Fund budget for Boar Meeting in August 8/23/2023 Regular Board meeting to review any final budget questions and set proposed Budget and Tax Rates for legal publications 8/21/2023 - 9/3/2023 Update District's website and Denton/Tarrant County TNT websites with Proposed Tax Rate and Public Hearing Notice Notice of Public Hearing for Proposed Tax Rate published in Denton Chronicle (minimum 7 days prior) 9/20/2023 Public Hearing/Board meeting for adoption of District Property Tax Rate, Levy Tax Resolutions, and adopt District FY Budget 9/25/2023 - 9/30/2023 Update Denton County and Tarrant County TNT websites with Adopted Tax Rates Update District's website with Adopted Tax Rates, Adopted Rate Order, and Notice to Purchaser *Some of the following dates are estimated and maybe subject to change as needed 46 of 113 September 20, 2023 Meeting Agenda Packet TAX RATE ASSESSMENT PID ASSESSMENT & SURCHARGE CALCULATIONS FIRE TAX/ASSESSMENT RATE NET TAX VALUE: TARRANT COUNTY: $677,155,614 DENTON COUNTY: $1,877,675,027 DENTON CO. PID: $1,032,220,715 OUT OF DISTRICT & PID $12,316,662 REQUIRED REVENUE FIRE $1,866,646 TAX/ASSESS RATE = REQUIRED REVENUE/TOTAL VALS/100 Vals/100 = 35,993,680 FY 2023 Tax/Assess Rate = 0.05186 Revenue from MUD Tax = Revenue from PID Assess = $ $ Total: $ 1,324,945 541,701 1,866,646 Certified 7/24/2023 7/24/2023 7/24/2023 M&O TAX/SURCHARGE RATE NET TAX VALUE: TARRANT COUNTY: $677,155,614 DENTON COUNTY: $1,877,675,027 DENTON CO. PID: $1,032,220,715 REQUIRED REVENUE M&O 113,071 95,000 *MUD (All of Dept. 39 Budget) **PID (Legal and Auditor only Dept 39 Budget) * ** TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100 Vals/100 = 35,870,514 FY 2023 MUD M&O Tax Rate = 0.00336 FY 2023 PID Tax/Surcharge Rate = 0.00265 Revenue from MUD Tax = Revenue from PID Surcharge = $ 85,734 $ 27,337 Total: $ 113,071 Certified 7/24/2023 7/24/2023 7/24/2023 I&S TAX/SURCHARGE RATE NET TAX VALUE: NEW DEBT: CALCULATE AMOUNT DUE FROM PID TARRANT COUNTY: $677,155,614 DENTON COUNTY: DENTON CO. PID: REQUIRED REVENUE TAX DEBT 2014 AND AFTER (I&S) $402,713 $1,877,675,027 $1,032,220,715 TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100 Vals/100 = 35,870,514 FY 2023 PID Surcharge Rate = 0.01123 ...NOT FINAL TAX RATE: ONLY USED TO CALCULATE PID SHARE Revenue from MUD Tax = Revenue from PID Surcharge = $ $ Total: $ 286,827 115,886 402,713 * * * Certified 7/24/2023 7/24/2023 7/24/2023 MUD DEBT: CALCULATE MUD TAX NET TAX VALUE: TARRANT COUNTY: $677,155,614 DENTON COUNTY: $1,877,675,027 REQUIRED REVENUE I&S MUD DEBT $219,481 TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100 Vals/100 = 25,548,306 FY 2023 Tax Rate = Revenue from MUD Tax = Revenue from PID = N/A $ $ Total: $ 0.00859 219,481 219,481 Certified 7/24/2023 7/24/2023 Tax Rate Requirements 3.5% Overall Tax Rate FY 2024 0.06381 Voter Approval Rate 0.06381 Contributions Required $0 TAX COMPARISON 47 of 113 2023 2024 M&O (General Fund) Tax 0.00393 0.00336 M&O Fire Tax 0.05625 0.05186 M&O Tax Rate 0.06019 0.05522 Increase/Decrease Rate: -0.01081 -0.00497 1 & S (Debt Service) Tax 0.03115 0.00859 Increase/Decrease Rate: -0.00374 -0.02256 Total Tax Rate: 0.09134 0.06381 Increase/Decrease Rate: -0.01454 -0.02753 47 of 113 September 20, 2023 Meeting Agenda Packet FIRE DEPARTMENT FUND Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted FY 2023 Amended FY 2023 Projected FY 2024 Adopted Budget vs Amended Budget % Change FY 2025 Proposed Revenues - Town 671,577 697,488 693,010 716,522 745,734 867,427 950,494 204,760 27.46% 969,503 Assessment - Emergency Services 513,618 507,446 528,546 517,385 517,385 517,385 541,701 24,316 4.70% 626,787 Emergency Services Assessment/Delinquent - - - - -- - - - 0.00% - PropertyTaxes/AssessmentsP&I - - - - - - - - 0.00% - Fire Permits/Sprinkler & Plan Review 47,977 4,226 5,000 5,000 5,000 5,000 5,000 - 0.00% 5,000 Fire Inspections -- - - - - - - - 0.00% - Denton/Tarrant County Pledge - Fire 17,072 17,072 17,000 17,000 17,000 10,000 10,000 (7,000) -41.18% 10,000 Grant Revenue 17,009 - - - - - - - 0.00% - Revenues - MUD Er 100,538 113,794 109,271 111,785 115,753 136,667 130,884 15,131 13.07% 133,502 Property Taxes/MUD Fire 1,223,805 1,205,268 1,279,821 1,257,579 1,257,579 1,257,579 1,324,945 67,366 5.36% 1,447,386 Property Taxes/Fire - Delinquent 3,736 32,221 2,425 - - 6,970 - - 0.00% - PropertyTaxes/FireP&I 6,897 5,283 4,639 - - 12,633 - - 0.00% - Capital Leases - Other Financial Sources - - - - - - - - 0.00% - Proceeds from Sale of Assets - - - - - 60,000 - - 0.00% - Prior Year Reserves - 57,369 - - - - 179,500 179,500 0.00% - GASB Reserves - - 554,301 - - - - - 0.00% - Miscellaneous Income 24,423 - - - - 191,028 - - 0.00% - Total Revenue 1,854,538 1,828,885 2,391,733 1,796,964 1,796,964 2,060,595 2,061,146 264,182 14.70% 2,089,173 Expenses - Town 50%/MUD 50% Salaries -Regular 671,577 697,488 693,010 716,522 745,734 867,427 950,494 204,760 27.46% 969,503 Salaries - Part Time - 49,275 37,954 50,000 50,000 29,779 50,000 - 0.00% 51,000 Salaries - Merits - - - 35,337 35,337 - - (35,337) -100.00% - Salaries - Overtime 75,008 115,592 128,564 83,580 83,580 142,736 40,303 (43,277) -51.78% 41,109 Salaries - Longevity 6,838 7,343 7,574 7,607 7,607 6,916 7,441 (166) -2.18% 7,590 Salaries - Stipend - - - - - - - - 0.00% - Certification Pay 9,063 10,176 8,277 10,838 10,838 10,546 11,250 413 3.81% 11,475 Salaries - Cell Phone Stipend - 1,875 1,082 900 900 1,430 1,350 450 50.00% 1,350 Retirement 100,538 113,794 109,271 111,785 115,753 136,667 130,884 15,131 13.07% 133,502 Medical lnsurance 76,605 76,715 64,881 91,140 91,140 80,337 79,022 (12,118) -13.30% 80,602 Dental Insurance 5,514 5,559 3,959 6,544 6,544 3,728 4,472 (2,072) -31.66% 4,561 Vision Insurance 525 513 498 631 631 592 594 (37) -5.86% 606 Life Insurance & Other 4,087 4,633 3,195 5,565 5,638 4,096 3,921 (1,717) -30.46% 3,999 Social Security Taxes 44,880 52,773 51,451 51,444 53,339 38,956 61,194 7,856 14.73% 62,418 Medicare Taxes 10,496 12,338 12,057 12,031 12,474 9,874 14,311 1,837 14.72% 14,598 Unemployment Taxes 426 4,993 207 2,520 2,520 123 2,520 - 0.00% 2,570 Workman's Compensation 15,004 17,868 20,249 19,047 19,810 19,810 58,584 38,774 195.73% 59,756 Pre -Employment Physicals/Testing 3,867 4,078 4,342 - - 5,785 - - 0.00% - Tuition Reimbursement 1,497 5,074 4,043 - - 2,315 7,000 7,000 0.00% 7,140 Professional Outside Services - 1,567 40,504 1,750 1,750 1,750 1,750 - 0.00% 1,785 Physicals/Testing -- - - - - 7,000 7,000 0.00% 7,000 Software & Support 12,495 12,354 14,564 17,164 17,164 17,164 11,085 (6,079) -35.42% 11,307 Tax Administration - 1,521 1,542 1,600 1,600 1,579 1,600 - 0.00% 1,632 Advertising - - - 1,000 1,000 - 200 (800) -80.00% 204 Printing 141 280 266 300 300 249 1,100 800 266.67% 1,122 Schools & Training 14,427 9,478 11,449 19,900 19,900 19,900 19,900 - 0.00% 20,298 Electricity 4,970 5,530 5,853 8,400 8,400 8,400 8,400 - 0.00% 8,568 Water 3,935 3,734 3,318 4,000 4,000 4,000 4,000 - 0.00% 4,080 Communications/Mobiles 12,345 14,692 18,816 16,691 16,691 16,691 16,691 - 0.00% 17,025 Building Maintenance 22,727 25,176 55,628 22,200 22,200 42,512 37,200 15,000 67.57% 37,944 Vehicle Maintenance 31,865 17,136 24,128 40,800 40,800 40,800 49,029 8,229 20.17% 50,010 Equipment Maintenance 5,719 10,241 11,155 18,715 18,715 18,715 18,715 - 0.00% 19,089 Emergency Management 1,000 1,000 - 1,000 1,000 1,000 1,000 - 0.00% 1,020 Dispatch - Denton County 3,986 3,946 4,021 5,061 5,061 5,061 5,622 561 11.08% 5,734 Dues & Memberships 19,782 20,417 19,154 20,337 20,337 20,337 27,242 6,905 33.95% 27,787 Flags & Repair - 215 -- - - - - 0.00% - Travel & per diem 5,326 8,236 17,410 14,510 14,510 14,921 14,510 - 0.00% 14,800 Office Supplies 390 327 267 500 500 500 500 - 0.00% 510 Printer Supplies - 1,007 1,371 1,600 1,600 1,600 2,600 1,000 62.50% 2,652 Postage 31 73 65 100 100 100 100 - 0.00% 102 Publications/Books/Subscripts 334 297 - 350 350 350 350 - 0.00% 357 Fuel 6,959 8,997 12,141 12,225 12,225 12,225 12,225 - 0.00% 12,470 Uniforms 7,001 7,850 9,129 9,645 9,645 9,645 9,645 - 0.00% 9,838 Safety Equipment/Protective Clothing 24,353 8,970 16,026 40,000 40,000 40,000 40,000 - 0.00% 40,800 Disposable Supplies - - 46 - - 35 - - 0.00% - Small Equipment 3,591 161 4,705 4,950 9,542 9,542 4,950 (4,592) -48.13% 5,049 48 of 113 September 20, 2023 Meeting Agenda Packet FIRE DEPARTMENT FUND Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted FY 2023 Amended FY 2023 Projected FY 2024 Adopted Budget vs Amended Budget % Change FY 2025 Proposed Hardware 2,592 1,106 2,504 4,458 4,458 4,458 4,458 - 0.00% 4,547 Maintenance & Supplies 1,113 375 1,648 1,500 1,500 1,500 1,500 - 0.00% 1,530 Miscellaneous Expense 27,936 3,562 3,954 4,000 4,000 4,000 4,000 - 0.00% 4,080 Programs & Special Projects 18,023 9,649 16,402 16,931 16,931 16,931 16,931 - 0.00% 17,270 Capital Outlays - - - - - - 6,500 6,500 0.00% - Expenses - MUD 100% 5,900 - - - - - - - 0.00% - Maintenance & Repairs (GASB34) Rent And/or Usage 218,004 197,281 198,761 197,266 197,266 197,266 200,771 3,505 1.78% 199,211 Insurance 19,691 19,789 19,958 23,100 23,100 22,623 26,812 3,712 16.07% 28,153 Capital Outlays 39,743 - 554,301 - - 191,028 - - 0.00% - Short Term Debt - Interest 9,078 6,127 3,102 - - - - - 0.00% - GASB34/Reserve for Replacement 81,420 81,420 81,420 81,420 81,420 81,420 81,420 - 0.00% 81,420 Capital Leases - Principal 118,070 121,022 124,047 - - - - - 0.00% - Total Expense 1,748,871 1,783,622 2,428,271 1,796,964 1,837,910 2,167,420 2,061,146 223,236 12.15% 2,089,173 Total Fire Revenues $ 1,854,538 $ 1,828,885 $ 2,391,733 $ 1,796,964 $ 1,796,964 $ 2,060,595 $ 2,061,146 264,182 14.70% $ 2,089,173 Total Fire Expenses $ 1,748,871 $ 1,783,622 $ 2,428,271 $ 1,796,964 $ 1,837,910 $ 2,167,420 $ 2,061,146 223,236 12.15% $ 2,089,173 Net Budget Surplus (Deficit) $ 105,667 $ 45,262 $ (36,538) $ - $ (40,946) $ (106,825) $ - 40,946 - $ 0 Town/MUD Fire Contract Calculation FY 2023 FY 2024 Fire Budget 1,796,964 2,061,146 Less: Rent/Debt Service 197,266 200,771 Less: TML Fire Insurance 23,100 26,812 Less: Capital Outlays - - Less: Capital Leases Interest - - Less: Capital Leases Principal - - Less: GASB34/Reserve for Replacement 81,420 81,420 Less: ESD Assessment 517,385 541,701 Less: Fire Permits/Sprinkler 5,000 5,000 Less: Fire Inspections - - Less: Denton County Fire Pledge 17,000 10,000 Less: Grant Proceeds - - Annual transfer to Town from MUD/Fire Budget $ 955,793 $ 1,195,442 Monthly payment to Town October - September $ 79,649 $ 99,620 49 of 113 September 20, 2023 Meeting Agenda Packet GENERAL FUND •n FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted FY 2023 Amended FY 2023 Projected FY 2024 Adopted Budget vs Budget Net Budget % Change FY 2025 Proposed Salaries & Wages 358,683 353,851 362,451 407,139 407,139 407,139 431,575 24,436 6.00% 453,154 Property Taxes 135,857 134,965 138,467 87,956 87,956 87,956 85,734 (2,223) -2.53% 88,306 Property Taxes/Delinquent 402 527 (179) 300 300 1,297 300 - 0.00% 300 Property Taxes/P&I 769 581 541 300 300 1,099 300 - 0.00% 300 PID Surcharges 164,700 162,305 164,890 145,029 145,029 145,029 143,223 (1,806) -1.24% 147,520 Water 5,765,931 5,617,478 6,843,941 6,710,979 7,142,255 7,142,255 6,939,998 229,019 3.41% 6,831,639 Sewer 3,254,599 3,604,966 3,856,157 3,839,686 3,670,000 3,670,000 3,679,786 (159,900) -4.16% 3,679,786 Penalties 61,753 86,208 105,893 78,000 78,000 73,227 105,800 27,800 35.64% 108,974 Service Charges (Disconnect Fees) 9,950 12,100 4,695 5,600 5,600 4,500 3,350 (2,250) -40.18% 3,350 Plumbing Inspections 5,300 300 600 300 300 300 300 - 0.00% 300 Sewer lnspections 5,050 100 150 100 100 100 100 - 0.00% 100 TCCC Effluent Charges 89,037 72,210 109,207 60,000 100,000 100,000 70,000 10,000 16.67% 70,000 Utility Fees - - - - - - - - 0.00% - CapitalLease- Other Sources- 235 - - - - - - - 0.00% - Interest Income 81,518 18,386 66,251 20,000 380,000 380,000 150,000 130,000 650.00% 150,000 Cell Tower Revenue 12,967 14,146 14,146 14,146 37,179 41,179 49,320 35,174 248.66% 50,800 Building Rent Income 5,833 - - - - - - - 0.00% 206,000 Proceeds from Sale of Assets 12,520 23,975 21,001 25,000 50,000 50,000 25,000- - 0.00% 25,000 Prior Year Reserves - - - 572,900 572,900 572,900 1,933,264 1,360,364 237.45% 262,859 GASB Reserves- 1,828 - - 164,000 164,000 164,000 50,000 (114,000) -69.51% 315,000 Loan Proceeds - - - - - - - - 0.00% - Oversize Meter Reimbursement 19,732 4,407 2,654 2,058 2,058 - 2,058 - 0.00% 2,058 Interfund Transfer In - - - - - - 1,178,400 1,178,400 0.00% 2,000 IntergovTransfer In- 5,334 5,551 6,865 7,500 - - - - 0.00% - Miscellaneous Income 35,761 19,912 7,899 7,000 7,000 5,000 7,000 - 0.00% 7,000 Records Management Revenue - - - - - - - - 0.00% - Recovery of Prior Year Expense - - 85,000 - - 76 - - 0.00% - Reimbursement/Revenue Bond - - - - - - - - 0.00% - IbItotalRevenues 9,661,678 9,772,566 11,421,312 11,733,354 12,442,977 12,438,•• - - 0.00% - Water Expenses Salaries & Wages 358,683 353,851 362,451 407,139 407,139 407,139 431,575 24,436 6.00% 453,154 Overtime 20,986 22,293 32,273 17,000 17,000 13,100 17,000 - 0.00% 17,000 Longevity 5,083 5,435 5,713 5,983 5,983 5,983 6,253 270 4.51% 6,565 Certification 4,900 3,025 2,650 3,600 3,600 2,600 3,600 - 0.00% 3,600 Retirement 35,476 35,652 44,359 51,201 51,201 51,201 56,730 5,530 10.80% 59,567 Medical lnsurance 59,351 62,867 65,577 82,722 87,627 87,627 116,528 33,806 40.87% 128,180 Dental Insurance 3,641 3,835 3,923 4,876 4,876 3,962 4,835 (41) -0.85% 5,318 Vision Insurance 563 561 553 745 745 745 1,051 306 41.15% 1,156 Life Insurance & Other 3,752 3,787 3,573 2,400 2,400 3,600 4,000 1,600 66.67% 4,400 Social Security Taxes 23,871 23,532 24,535 26,891 26,891 26,400 28,423 1,532 5.70% 29,844 Medicare Taxes 5,583 5,503 5,938 6,289 6,289 5,571 6,647 358 5.70% 6,980 Unemployment Taxes 974 1,671 143 1,260 1,260 65 1,260 - 0.00% 1,323 Workman's Compensation 8,846 12,500 10,909 11,249 11,249 13,313 11,899 649 5.77% 12,493 Pre-employment Physicals/Testing 235 - 55 400 400 420 400 - 0.00% 400 Employee Relations 87 103 182 300 300 468 300 - 0.00% 300 Engineering- - - - - - - - 0.00% - Maintenance & Repairs 60,089 80,718 357,812 229,800 204,800 204,800 201,500 (28,300) -12.32% 206,000 Generator Maintenance & Repairs 847 889 952 2,000 2,000 876 2,000 - 0.00% 2,000 Vehicle Maintenance 6,003 7,879 9,738 5,000 12,066 12,066 5,000 - 0.00% 5,150 Maintenance - Heavy Equipment 1,828 1,114 237 1,000 1,000 2,516 1,000 - 0.00% 1,030 Cleaning Services 1,050 1,198 1,935 2,500 2,500 2,500 2,500 - 0.00% 2,500 Lab Analysis - MUD 4,561 3,641 5,285 7,500 7,500 4,500 7,500 - 0.00% 7,500 Lab Analysis - PID 2,216 2,047 1,583 2,000 2,000 1,500 2,000 - 0.00% 2,000 Communications/Mobiles 5,334 5,551 6,865 7,500 7,500 6,600 7,500 - 0.00% 7,500 Electricity 131,998 123,528 138,327 228,250 194,810 194,810 183,143 (45,107) -19.76% 192,301 Publications/Books/Subscripts 850 1,366 875 1,000 1,000 1,000 1,000 - 0.00% 1,000 Dues & Memberships 105 - 125 - - - - - 0.00% - Schools&Training 2,920 1,986 2,649 3,630 3,630 2,400 2,630 (1,000) -27.55% 2,630 Safety Program - 105 - - - - - - 0.00% - Travel & per diem- - 59 938 938 100 578 (360) -38.40% 578 Rent/Lease Equipment - - - - - - - - 0.00% - TCEQ Fees & Permits - MUD 25,706 34,779 21,486 30,000 30,000 30,000 29,500 (500) -1.67% 29,500 TCEQ Fees & Permits - PID - - 437 - 214 214 500 500 0.00% 500 Wholesale Water 1,865,024 1,893,513 2,672,206 2,640,131 2,640,131 2,640,131 2,655,497 15,366 0.58% 2,788,272 Miscellaneous Expenses - - - - - - - - 0.00% - Property Maintenance 1,392 245 - -- - - - 0.00% - Lawn Services 6,000 8,700 6,315 12,500 12,500 12,500 12,500 - 0.00% 12,500 Interfund Transfer Out - Revenue l&S 527,381 565,819 569,455 567,782 567,782 567,783 565,797 (1,986) -0.35% 565,797 Interfund Transfer Out - Bond Reserve 36,800 - - - - - - - 0.00% - Interfund Transfer Out - Bank Reserve - - - - - - - - 0.00% - Furniture/Equipment < $5000 562 382 1,923 2,500 2,500 1,355 - (2,500) -100.00% - Fuel & Lube 10,066 14,940 21,815 15,000 15,000 17,200 23,575 8,575 57.17% 24,282 Uniforms 3,425 2,966 2,474 4,355 4,355 2,900 4,355 - 0.00% 4,355 Chemicals 21,491 25,231 30,633 25,000 45,500 45,500 58,200 33,200 132.80% 59,946 Small Tools - 640 - - - - - - 0.00% - Safety Equipment - - - - - - - - 0.00% - Meter Expense 61,774 9,287 - 20,000 6,420 6,420 20,000 - 0.00% 20,000 50 of 113 September 20, 2023 Meeting Agenda Packet GENERAL FUND Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted FY 2023 Amended FY 2023 Projected FY Budget vs Budget Net Budget % Change FY 2025 Proposed Meter Change Out Program 36,900 86,625 66,372 87,000 87,000 87,000 124,500 37,500 43.10% 128,235 Capital Outlays 451,480 689,134 950,880 1,752,000 2,300,000 2,300,000 4,200,000 2,448,000 139.73% 1,765,000 Short Term Debt - Principal 30,512 30,962 31,418 31,882 31,882 31,882 - (31,882) -100.00% - ShortTermDebt- Interest 3,230 2,314 1,404 470 470 470 - (470) -100.00% - Gasb34 Reserves 475,899 697,986 75,000 162,639 162,639 162,639 378,659 216,020 132.82% 378,659 Water Tank Inspection Contract 102,077 107,607 112,364 113,500 113,500 110,864 - (113,500) -100.00% - Bond Related Expenses 1,220 - - - - - - - 0.00% - Subtotal Water Expenses 4,410,770 4,935,767 5,653,457 6,577,931 7,086,596 7,072,720 9,179,933 2,602,002 39.56% 6,937,514 Wastewater Expenses Salaries & Wages 425,068 458,805 382,301 309,655 290,179 290,179 290,305 (19,350) -6.25% 304,820 Overtime 22,679 32,324 31,627 33,000 15,586 15,586 20,000 (13,000) -39.39% 20,000 Longevity 6,873 7,420 7,955 4,035 4,035 4,035 2,368 (1,668) -41.33% 2,486 Certification 7,575 7,800 5,900 6,300 6,300 4,200 5,100 (1,200) -19.05% 5,100 Retirement 42,091 46,910 47,229 41,671 41,671 41,671 40,934 (737) -1.77% 42,981 Medical lnsurance 84,736 91,201 71,491 96,579 63,861 63,861 93,222 (3,357) -3.48% 102,544 Dental Insurance 4,900 5,036 3,957 5,427 5,427 3,961 3,385 (2,041) -37.62% 3,724 Vision Insurance 784 781 566 793 793 740 819 26 3.30% 901 Life Insurance & Other 4,563 4,810 3,400 2,400 2,400 2,700 3,000 600 25.00% 3,300 Social Security Taxes 27,142 30,252 26,257 21,885 21,885 19,343 20,508 (1,377) -6.29% 21,533 Medicare Taxes 6,348 7,075 6,141 5,118 5,118 4,623 4,796 (322) -6.29% 5,036 Unemployment Taxes 1,100 1,960 70 1,260 1,260 44 1,008 (252) -20.00% 1,008 Workman's Compensation 12,653 16,302 13,414 8,987 8,987 10,635 8,404 (584) -6.50% 8,824 Pre-employment Physicals/Testing 357 - 292 400 400 400 400 - 0.00% 400 Employee Relations 105 135 445 300 300 1,168 300 - 0.00% 300 Engineering 23,200 - - -- - - - 0.00% - Independent Labor 3,000 - - - - - - - 0.00% - Maintenance & Repairs - WWTP 87,020 99,418 193,823 134,600 211,000 211,000 137,000 2,400 1.78% 110,000 Maintenance & Repairs - Collections 27,259 187,743 286,403 281,000 333,600 333,600 270,000 (11,000) -3.91% 270,000 Generator Maintenance & Repairs 3,198 4,055 4,604 9,000 2,836 2,836 11,000 2,000 22.22% 11,000 Vehicle Maintenance - WWTP 1,203 2,831 524 4,600 4,600 1,000 4,600 - 0.00% 4,600 Vehicle Maintenance - Collections 2,173 7,905 18,947 13,000 13,000 10,000 13,000 - 0.00% 13,000 Maintenance -Heavy Equipment 1,471 1,390 1,325 3,000 3,000 3,000 3,000 - 0.00% 3,000 Cleaning Services 1,050 1,197 1,935 2,000 2,000 2,000 2,000 - 0.00% 2,000 Dumpster Services 91,387 92,408 91,740 100,000 95,000 95,000 100,000 - 0.00% 103,000 Lab Analysis 37,205 40,690 44,380 40,000 45,000 45,000 55,000 15,000 37.50% 56,650 Communications/Mobiles 5,716 5,997 6,383 7,500 7,500 5,500 7,500 - 0.00% 7,500 Electricity 132,686 146,660 172,359 276,318 243,973 243,973 242,978 (33,340) -12.07% 255,127 Publications/Books/Subscripts- - - - - - - - 0.00% - Dues & Memberships 216 - - -- - - - 0.00% - Schools &Training 4,349 2,827 1,700 3,630 3,630 2,500 2,119 (1,511) -41.63% 2,119 Safety Program 109 - - -- - - - 0.00% - Travel & per diem 411 - - 1,038 1,038 - 528 (510) -49.16% 528 Rent/Lease Equipment - 575 - - - - - - 0.00% - Advertising- - - - - - - - 0.00% - TCEQ Fees & Permits 10,088 28,791 20,314 12,000 12,000 9,888 12,000 - 0.00% 12,000 Miscellaneous Expenses - - - - - - - - 0.00% - Property Maintenance 2,618 - - -- - - - 0.00% - Lawn Services 6,525 10,430 6,067 16,000 8,500 8,500 16,000 - 0.00% 16,000 Interfund Transfer Out - Tax l&S 114,563 114,681 115,924 116,245 116,245 116,245 115,886 (359) -0.31% 115,886 Interfund Transfer Out - Revenue I&S 673,867 688,005 690,085 691,931 691,931 691,932 698,543 6,612 0.96% 698,543 Interfund Transfer Out - Bond Reserve 46,000 - - - - - - - 0.00% - Interfund Transfer Out - Bank Reserve - 38,802 - - - - -- 0.00% - Furniture/Equipment < $5000 1,055 228 - 500 500 500 - (500) -100.00% - Fuel & Lube 8,220 13,408 13,686 12,500 12,500 10,000 13,000 500 4.00% 13,000 Uniforms 3,732 4,168 3,299 4,415 4,415 3,000 3,520 (895) -20.27% 3,520 Chemicals - WWTP 23,055 23,442 25,284 32,500 22,500 22,500 32,500 - 0.00% 33,475 Chemicals - Collections 10,449 4,895 5,776 10,000 10,000 6,003 10,000 - 0.00% 10,300 Small Tools - 343 - - - - -- 0.00% - Safety Equipment 1,167 307 - - - - - - 0.00% - Lab Supplies 26,446 28,349 31,073 33,000 33,000 29,000 33,000 - 0.00% 33,000 Capital Outlays 324,270 222,147 381,214 895,000 1,578,000 1,578,000 1,050,000 155,000 17.32% 570,000 Short Term Debt -Principal 79,142 81,295 83,484 85,766 85,766 85,766 22,398 (63,368) -73.88% Short Term Debt -Interest 11,269 8,496 5,707 2,801 2,801 2,835 442 (2,359) -84.21% - Gasb34 Reserves 530,899 752,986 130,000 165,777 165,777 165,777 155,762 (10,015) -6.04% 155,762 Capital Lease Issuance Cost - - - - - - - - 0.00% - Subtotal Wastewater Expenses 2,941,991 3,325,280 2,937,081 3,491,931 4,178,315 4,148,502 3,506,324 14,393 0.41% 3,022,965 Board of Directors Expenses Salaries & Wages - - - - - - - - 0.00% - SocialSecurityTaxes - - - - - - - - 0.00% - Medicare Taxes - - - - - - - - 0.00% - UnemploymentTaxes- - - - - - - - 0.00% - Workman's Compensation 24 9 10 15 15 15 15 - 0.00% 15 Publications/Books/Subscriptions - - - - - - - - 0.00% - Dues & Memberships 675 1,195 700 750 750 750 750 - 0.00% 750 Meetings 1,034 1,418 1,416 1,500 1,500 1,500 1,500 - 0.00% 1,500 Schools &Training - - 625 4,000 535 535 4,000 - 0.00% 4,000 51 of 113 September 20, 2023 Meeting Agenda Packet GENERAL FUND Desai • FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted FY 2023 Amended - FY 2023 Projected FY 2024 Adopted Budget vs Budget Net Budget % Change FY 2025 Proposed Travel & per diem - - - 5,000 - - 5,000 - 0.00% 5,000 Miscellaneous Expenses - 58 - 500 - - 500 - 0.00% 500 Subtotal Board of Directors Expenses 1,733 2,680 2,751 11,765 2,800 2,800 11,765 - 0.00% 11,765 Administration Expenses Salaries & Wages 453,839 516,401 534,749 620,938 620,938 620,938 663,185 42,247 6.80% 696,345 Overtime 50 97 549 2,000 2,000 1,500 2,000 - 0.00% 2,000 Longevity 2,208 2,668 2,973 2,423 2,423 2,423 2,533 110 4.54% 2,659 Retirement 41,774 48,136 59,277 73,825 73,825 73,825 82,631 8,806 11.93% 86,763 Medical Insurance 80,099 75,830 69,806 116,290 79,352 79,352 108,759 (7,531) -6.48% 119,635 Dental lnsurance 4,436 4,204 3,762 6,051 6,051 3,081 3,817 (2,234) -36.92% 4,198 Vision Insurance 667 616 527 899 899 638 886 (13) -1.45% 975 Life lnsurance & Other 4,307 4,829 4,507 2,400 2,400 5,100 4,800 2,400 100.00% 5,280 Social Security Taxes 26,325 30,429 31,981 38,772 38,772 37,404 41,399 2,626 6.77% 43,468 Medicare Taxes 6,157 7,116 7,479 9,068 9,068 8,813 9,682 614 6.77% 10,166 Unemployment Taxes 1,008 1,512 54 1,512 1,512 59 1,512- 0.00% 1,512 Workman's Compensation 1,178 1,542 1,511 1,496 1,496 1,291 1,597 101 6.78% 1,677 Pre-employment Physicals/Testing - - 516 500 500 500 500 - 0.00% 500 Employee Relations 3,140 3,422 3,471 4,000 4,000 4,000 4,000 - 0.00% 4,000 Engineering - - - - - - - - 0.00% - Software & Support 124,037 96,552 107,761 131,700 131,700 131,700 130,311 (1,389) -1.05% 134,220 Independent Labor 90,481 16,573 29,113 15,000 8,000 8,000 - (15,000) -100.00% - Maintenance & Repairs 18,794 94,832 66,308 40,000 20,000 20,000 23,000 (17,000) -42.50% 13,000 Generator Maintenance & Repairs 1,169 670 717 3,000 3,000 1,000 1,000 (2,000) -66.67% 1,000 Building Maintenance & Supplies - - - - - - - - 0.00% Cleaning Services 17,143 17,315 12,266 12,000 12,000 12,356 13,825 1,825 15.21% 13,825 Professional Outside Services 57,100 103,120 75,415 75,040 75,040 75,040 100,000 24,960 33.26% 103,000 Utility Billing Contract 7,132 7,188 7,346 9,000 9,000 9,000 9,000 - 0.00% 9,000 Telephone 24,055 7,365 5,909 6,000 6,000 6,000 6,000 - 0.00% 6,000 Communications/Mobiles 2,784 2,700 2,700 3,000 3,000 300 3,000 - 0.00% 3,000 Electricity 6,315 13,873 15,200 24,369 16,957 16,957 17,685 (6,685) -27.43% 17,685 Water 1,945 3,828 4,107 5,000 5,000 5,000 5,000 - 0.00% 5,000 Postage 20,402 21,713 22,408 30,000 24,000 24,000 30,000 - 0.00% 30,000 Bank Service Charges & Fees 73,964 90,222 92,832 95,000 141,000 141,000 140,000 45,000 47.37% 140,000 Bad Debt Expense 16,874 10,998 9,562 1,500 13,000 13,000 13,000 11,500 766.67% 13,000 Insurance 79,988 80,698 86,013 88,200 97,400 97,400 116,158 27,958 31.70% 121,966 Publications/Books/Subscripts 125 183 -- - - - - 0.00% - Dues & Memberships 4,607 6,017 6,522 6,500 6,500 6,900 6,800 300 4.62% 6,800 Meetings 149 289 -- - - - - 0.00% - Public Education 1,875 3,063 3,867 40,000 30,000 30,000 - (40,000) -100.00% - Schools &Training 3,018 3,639 913 3,250 3,250 1,000 3,900 650 20.00% 3,900 Travel & per diem 1,205 304 509 1,588 1,588 - 1,228 (360) -22.68% 1,228 Physicals/Testing - - - - - - - - 0.00% - Elections 138 9,330 7,143 - - - 10,000 10,000 0.00% - Advertising 6,112 625 10,412 - - - - - 0.00% - Security 264 312 - - - - - - 0.00% - Miscellaneous Expenses 6,096 392 112 - - 88 - - 0.00% - General Manager Contingency- - - - - - - - 0.00% - Lawn Services- - 4,227 5,000 5,000 5,000 5,000 - 0.00% 5,000 Furniture/Equipment < $5000 2,027 4,012 3,284 10,000 13,053 13,053 3,000 (7,000) -70.00% 3,000 Uniforms- - 443 530 530 530 530 - 0.00% 530 Hardware IT 24,611 20,339 12,206 8,400 13,214 13,587 8,200 (200) -2.38% 8,200 Office Supplies 5,383 4,682 4,217 6,000 6,000 5,000 5,000 (1,000) -16.67% 5,000 Printer Supplies & Maintenance - - - - - - - 0.00% - Maintenance Supplies 4,596 4,553 6,190 4,000 4,000 5,000 5,000 1,000 25.00% 5,000 Printing - - - - - - - - 0.00% Capital Outlays 156,107 123,356 113,654 - 56,346 74,953 -- 0.00% Copier Lease 3,027 3,168 3,242 4,000 4,000 4,000 4,000 - 0.00% 4,000 Gasb34 Reserves- - - 26,736 26,736 26,736 24,903 (1,833) -6.86% 24,903 Subtotal Administration Expenses 1,386,708 1,448,713 1,435,755 1,534,986 1,578,548 1,585,523 1,612,840 77,854 5.07% 1,657,434 Non Departmental Expenses Legal 109,011 42,018 55,890 65,000 30,000 30,000 65,000- 0.00% 65,000 Auditing 31,908 21,000 25,375 33,800 27,000 27,000 30,000 (3,800) -11.24% 30,000 Appraisal 11,909 11,122 14,582 12,940 12,940 12,940 13,071 131 1.01% 13,463 Tax Admin Fees 3,756 3,821 3,874 5,000 5,000 4,046 5,000 - 0.00% 5,150 Subtotal Non Departmental Expenses 156,584 77,961 99,721 116,740 74,940 73,986 113,071 (3,669) -3.14% 113,613 Total General Fund Revenues $ 9,661,678 $ 9,772,566 $ 11,421,312 $ 11,733,354 $ 12,442,977 $ 12,438,917 $ 14,423,933 $ 2,690,579 22.93% $ 11,743,292 Total General Fund Expenses $ 8,897,786 $ 9,790,401 $ 10,128,766 $ 11,733,354 $ 12,921,199 $ 12,883,531 $ 14,423,933 $ 2,690,579 22.93% $ 11,743,292 Net Budget Surplus (Deficit) $ 763,892 $ (17,835) $ 1,292,546 $ 0 $ (478,222) $ (444,613) $ 0 $ 0 $ 0 52 of 113 TAX DEBT PAYMENTS LONG TERM TAX DEBT September 20, 2023 Meeting Agenda Packet REVENUE DEBT PAYMENTS LONG TERM REVENUE DEBT MUD/PID Reimburse Par Amount Principal FY 2024 Interest 3/01 Interest 9/01 Subtotal Interest Paying Agent Fee Total Maturity Date First Callable Date Project/Reason Series 2012 (Tax) MUD $2,355,000 50 50 50 50 50 $0 9/1/2023 9/1/2020 Refund MUD #2 Unlimited Tax Bonds Series 2002 and costs of issuance Series 2013 (Tax) MUD 51,905,000 $0 $0 $0 $0 $0 $0 9/1/2023 9/1/2023 Refund MUD #2 Unlimited Tax Bonds Series 2003 & Unlimited Tax Refunding Bonds Series 2005 and costs of issuance Series 2020 (Tax) MUD 51,220,000 $120,000 $6,338 $6,338 $12,675 $750 5133,425 9/1/2031 9/1/2031 Refund MUD #1 Unlimited Tax Bonds Series 2010 and costs of issuance of the Bonds, Trophy Club Fire Station SUBTOTAL MUD ONLY TAX BONDS: 55,480,000 5120,000 $6,338 56,338 $12,675 $750 $133,425 Series 2014 (Tax) MUD/PID $5,765,000 $290,000 556,156 556,156 $112,313 5400 5402,713 9/1/2034 9/1/2024 Tax Bonds for WWTP Expansion SUBTOTAL MUD/PID TAX BONDS: $5,765,000 5290,000 556,156 556,156 5112,313 5400 5402,713 TOTAL ALL TAX BONDS: $11,245,000 $410,000 $62,494 $62,494 $124,988 $1,150 $536,138 REVENUE DEBT PAYMENTS LONG TERM REVENUE DEBT CAPITAL LEASE PAYMENTS SHORT TERM REVENUE DEBT Revenue Rates Par Amount Principal FY 2024 Interest 3/01 Interest 9/01 Subtotal Interest Paying Agent Fee Total Maturity Date First Callable Date Project/Reason Series 2015 (Revenue) WWTP 59,230,000 $435,000 587,919 587,919 $175,838 $400 5611,238 9/1/2035 9/1/2025 Revenue Bonds for WWTP Expansion Series 2016 (Revenue) SWIFT $4,635,000 $220,000 $26,557 $26,557 553,115 $400 5273,515 9/1/2036 9/1/2027 Revenue Bonds for Fort Worth Line NSII Series 2019 (Revenue) WT & WW $7,080,000 5170,000 5104,594 5104,594 $209,188 5400 $379,588 9/1/2049 9/1/2028 Revenue Bonds for 16in Water Line (77%) Overrun for WWTP Expansion (23%) TOTAL ALL REVENUE BONDS: $20,945,000 $825,000 $219,070 $219,070 $438,140 $1,200 $1,264,340 CAPITAL LEASE PAYMENTS SHORT TERM REVENUE DEBT 53 of 113 Revenue Rates Par Amount Principal FY 2023 Interest 2/01 Interest 8/01 Subtotal Interest Paying Agent Fee Total Payoff Date Reason Department Vaccon Truck (Water usage 43%) 5154,843 $0 $0 $0 $0 $ - $0 2/1/2023 Replacement Water Vaccon Truck (WW usage 57%) $205,257 $0 $0 $0 $0 $ - $0 2/1/2023 Replacement Wastewater Camera Van 5205,504 $22,398 $442 $0 $442 $ - $22,841 2/1/2024 Replacement Wastewater Total: $565,604 $22,398 $442 $0 $442 $ - $22,841 53 of 113 September 20, 2023 Meeting Agenda Packet $2,000,000.00 - $1,800,000.00 - $1,600,000.00 - $1,400,000.00 - $1,200,000.00 $1,000,000.00 - $800,000.00 - $600,000.00 - $400,000.00 - $200,000.00 - M Annual Long -Term Debt Payments 1 URI WT & WW REV SERIES 2019 ($7,080,000) ■ WT REV SERIES 2016 ($4,635,000) ■ WW REV SERIES 2015 ($9,230,000) ■ UTR GO SERIES 2020 ($1,220,000) ■ UTR GO SERIES 2014 ($5,765,000) 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 2049 $25,000.00 $20,000.00 $15,000.00 $10,000.00 $5,000.00 $- Annual Capital Lease Payments 2024 CAMERA VAN LEASE 2019 ($210,000) 54 of 113 September 20, 2023 Meeting Agenda Packet CAPITAL OUTLAYS (5 Year ) Department FY 2024 FY 2025 FY 2026 FY 2027 FY 2028 Water Water Line Replacement $ 2,000,000 $ 1,700,000 $ 1,751,000 $ 1,803,530 $ 1,857,636 Pump Station Improvements $ 2,200,000 $ - $ - $ - $ - Fleet Replacement $ - $ 65,000 $ - $ 50,000 $ - MBR CIP Tanks $ - $ - $ - $ - $ Water Grand Totals $ 4,200,000 $ 1,765,000 $ 1,751,000 $ 1,853,530 $ 1,857,636 Wastewater Wastewater Line Improvements $ 400,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 Lift Station Improvements $ 225,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 Return Pump $ - $ - $ 40,000 $ 40,000 $ 40,000 MBR CIP Tanks $ 375,000 $ - $ - $ - $ - Crane Pulley $ - $ 35,000 $ - $ - $ - Concrete Repairs $ - $ 35,000 $ - $ - $ - Fleet Replacement $ 50,000 $ 250,000 $ - $ - $ - $ - $ - $ - $ - $ Wastewater Grand Totals $ 1,050,000 $ 570,000 $ 290,000 $ 290,000 $ 290,000 Administration $ - $ - $ - $ - $ $ - $ - $ - $ - $ - $ - $ - $ - $ - $ Admin Grand Totals $ - $ - $ - $ - $ - 55 of 113 September 20, 2023 Meeting Agenda Packet ANNUAL WATER CONSUMPTION AND REVENUE BY YEAR 1,200,000 1,000,000 800,000 600,000 400,000 200,000 Annual Consumption in (Thousand) Gallons 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 $- Annual Water Revenue 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 AVERAGE MONTHLY METERS AND AVERAGE GALLONS BY YEAR 5,000 4,900 4,800 4,700 4,600 4,500 4,400 4,300 4,200 4,100 4,000 3,900 Average Monthly Meters 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 24,000 22,000 20,000 18,000 16,000 14,000 12,000 10,000 8,000 6,000 4,000 2,000 Average Monthly Gallons per Meter 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 ANNUAL WASTEWATER FLOW AND REVENUE BY YEAR 500,000 400,000 300,000 200,000 100,000 0 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 Annual WWTP Flow in (Thousand) Gallons 56 of 113 $4,500,000 $4,000,000 $3,500,000 $3,000,000 $2,500,000 $2,000,000 $1,500,000 $1,000,000 $500,000 $- Annual Wastewater Revenue 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 September 20, 2023 Meeting Agenda Packet ORDER NO. 2023-0920A ORDER OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 LEVYING DEBT SERVICE AND MAINTENANCE TAXES FOR THE 2023 TAX YEAR WHEREAS, Trophy Club Municipal Utility District No. 1 (the "District") is a duly created and existing municipal utility district created and operating under Chapters 49 and 54 of the Texas Water Code, as amended. WHEREAS, Section 54.601 of the Texas Water Code provides that at the time bonds payable in whole or in part from taxes are issued, the board of a water district shall levy a continuing direct annual ad valorem tax for each year while all or part of the bonds are outstanding on all taxable property within the district in sufficient amounts to pay the interest on the bonds as it becomes due and to create a sinking fund for the payment of the principal of the bonds when due; WHEREAS, Section 49.107 of the Texas Water Code provides that a district may levy and collect a tax for maintenance and operation purposes. WHEREAS, at an election properly conducted in accordance with all applicable laws, the eligible residents of the District previously authorized the issuance of District tax bonds, and the levy and collection of District debt service and maintenance taxes. WHEREAS, the District has issued its unlimited tax bonds pursuant to the foregoing authorization. WHEREAS, the Board of Directors of the District approved a proposed ad valorem tax rate for the 2023 tax year at a meeting conducted on September 20, 2023. WHEREAS, in accordance with the requirements set forth at Section 49.236 of the Texas Water Code and other applicable laws, the District has given proper notice and conducted a public hearing regarding the adoption of ad valorem tax rates for the 2023 tax year. WHEREAS, after conducting the public hearing, the Board of Directors of the District desires to proceed with the levy and collection of a debt service tax and a maintenance tax for the 2023 tax year; and WHEREAS, the District has complied with the applicable requirements of the Texas Water Code and other statutes relating to the procedures for establishing ad valorem taxes by municipal utility districts. Now, therefore, BE IT ORDERED BY THE BOARD OF DIRECTORS OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 THAT: 57 of 113 September 20, 2023 Meeting Agenda Packet Section 1. The facts and recitations found in the preamble of this Order are hereby found and declared to be true and correct and are incorporated by reference herein and expressly made a part hereof, as if copied verbatim. Section 2. There is hereby levied for the 2023 tax year the following ad valorem taxes: (i) An ad valorem debt service tax rate of $0.00859 on each $100 of taxable value on all taxable property within the District; and (ii) An ad valorem maintenance tax rate of $0.05522 on each $100 of taxable value on all taxable property within the District. Section 3. The Board of Directors hereby finds and declares that the tax rates adopted and levied by this Order do not exceed the maximum tax rates authorized by the voters of the District. Section 4. All taxes collected pursuant to this Order, after paying reasonable costs of levying, assessing, and collecting same, shall be used for authorized purposes, as may be specified by the Board of Directors in accordance with applicable laws. ADOPTED, PASSED AND APPROVED this 20th day of September 2023. Kevin R. Carr President, Board of Directors ATTEST: Doug Harper (SEAL) Secretary, Board of Directors 58 of 113 September 20, 2023 Meeting Agenda Packet RESOLUTION NO. 2023-0920B A RESOLUTION TO APPROVE THE 2023 TAX ROLL FOR TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 RESOLVED: Pursuant to Section 26.09(e) of the Texas Tax Code, the Board of Directors of Trophy Club Municipal Utility District No. 1 hereby approves the 2023 certified appraisal rolls dated July 22nd, 2023, from Denton County Central Appraisal District and dated July 20th, 2023, from Tarrant Appraisal District, in which the certified appraised values were listed as $1,877,675,027 and $677,155,614 respectively, for a total certified appraised value of $2,554,830,641. The 2023 tax rate approved by the Board of Directors of Trophy Club Municipal Utility District No. 1 is $0.06381 per $100 assessed valuation. The amount of tax entered on the certified appraisal rolls and applied to all taxable property within the District results in a $1,630,159 tax levy. The Board hereby approves such appraisal rolls with amounts of tax entered and declares that such shall constitute the District's tax roll for the 2023 tax year. RESOLVED, ADOPTED AND APPROVED by the Board of Directors of Trophy Club Municipal Utility District No. 1, Trophy Club, Texas, this 20th day of September 2023. Kevin R. Carr, President Board of Directors Doug Harper, Secretary/Treasurer Board of Directors Laurie Slaght, District Secretary 59 of 113 (SEAL) September 20, 2023 Meeting Agenda Packet CERTIFICATE OF RESOLUTION 2023-0920B THE STATE OF TEXAS COUNTIES OF DENTON AND TARRANT I, the undersigned member of the Board of Directors of Trophy Club Municipal Utility District No. 1 of Denton and Tarrant Counties, Texas (the "District"), hereby certify as follows: 1. That I am the duly qualified Secretary of the Board of Directors of the District, and that as such, I have custody of the minutes and records of the District. 2. That the Board of Directors of the District convened in Open Session at a Regular Meeting on September 20, 2023, at the regular meeting place thereof, and the roll was called of the duly constituted officers and members of the Board of Directors, to wit: Kevin R. Carr President Ben Brewster Vice President Doug Harper Secretary/Treasurer William C. Rose Director Tracey Hunter Director All members of the Board were present except , thus constituting a quorum. Whereupon, among other business, the following was transacted at such meeting: RESOLUTION 2023-0920B APPROVING TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 TAX ROLL FOR FISCAL YEAR 2022 and duly introduced for the consideration of the Board of Directors. It was then duly moved and seconded that such Resolution be adopted and, after due discussion, such motion, carrying with it the adoption of such Resolution prevailed and carried by the following vote: AYES: NAYS: ABSTENTIONS: 3. That a true, full and correct copy of such Resolution adopted at such meeting is attached to and follows this certificate; that such Resolution has been duly recorded in the minutes of the Board of Directors for such meeting; that the persons named in the above 60 of 113 September 20, 2023 Meeting Agenda Packet and foregoing Paragraph 2 were the duly chosen, qualified and acting officers and members of the Board of Directors as indicated therein, that each was duly and sufficiently notified officially and personally, in advance, of the time, place and purpose of such meeting, and that such Resolution would be introduced and considered for adoption at such meeting, and that each consented, in advance, to the holding of such meeting for such purpose; that the canvassing of the officers and members of the Board of Directors present at and absent from such meeting and of the votes of each on such motion, as set forth in the above and foregoing Paragraph 2, is true and correct; and that sufficient and timely notice of the hour, date, place and subject of such meeting was given and posted as required by Chapter 551, Texas Gov. Code. RESOLVED, PASSED and APPROVED on this 20th day of September 2023. Doug Harper, Secretary/Treasurer Board of Directors Laurie Slaght District Secretary 61 of 113 (SEAL) September 20, 2023 Meeting Agenda Packet AMENDMENT AND RESTATED INFORMATION FORM TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 STATE OF TEXAS § § COUNTIES OF DENTON AND TARRANT § Pursuant to V.T.C.A., Texas Water Code, Sections 49.452, 49.4521, and 49.455, as amended, the Board of Directors of Trophy Club Municipal Utility District No. 1 (the "District") hereby gives the following amendment to information form and revised notice to purchaser form to all sellers and purchasers of real estate situated within the boundaries of said District. We do hereby certify that the only modifications to be made by this amendment are changes to items numbered as follows: • The most recent rate of District -wide taxes on property located in the District for maintenance and operation purposes is $0.05522 on each $100 of assessed valuation. The most recent rate of District -wide taxes on property located in the District for debt service is $0.00859 on each $100 of assessed valuation. • The particular form of Notice to Purchasers required by Sections 49.452 and 49.4521 of the Texas Water Code to be furnished by a seller to a purchaser of real property in the District, completed by the District with all information required to be furnished by the District, is attached hereto as Exhibit "A". WITNESS OUR HANDS THIS THE 20th DAY OF SEPTEMBER 2023. (SEAL) 62 of 113 Kevin R. Carr, President Ben Brewster, Vice President Doug Harper, Secretary/Treasurer William C. Rose, Director Tracey Hunter, Director THE STATE OF TEXAS COUNTY OF DENTON § § § September 20, 2023 Meeting Agenda Packet BEFORE ME, the undersigned, a Notary Public in and for said County and State, on this day personally appeared KEVIN R. CARR, BEN BREWSTER, DOUG HARPER, WILLIAM C. ROSE, and TRACEY HUNTER known to me to be the persons and officers whose names are subscribed to the foregoing instrument and affirmed and acknowledged that said instrument is correct and accurate to the best of their knowledge and belief, and that they executed the same for the purposes and in the capacities therein stated. GIVEN UNDER MY HAND AND SEAL OF OFFICE this 20th day of September 2023. (SEAL) Notary Public, State of Texas My Commission expires: 63 of 113 September 20, 2023 Meeting Agenda Packet EXHIBIT "A" 64 of 113 September 20, 2023 Meeting Agenda Packet NOTICE TO PURCHASER OF SPECIAL TAXING OR ASSESSMENT DISTRICT The real property that you are about to purchase is located in Trophy Club Municipal Utility District No. 1 and may be subject to District taxes or assessments. The District may, subject to voter approval, impose taxes and issue bonds. The District may impose an unlimited rate of tax in payment of such bonds. The current rate of the District property tax is $0.06381 on each $100 of assessed valuation, The District may impose assessments and issue bonds and impose an assessment in payment of such bonds. The total amounts of bonds payable wholly or partly from property taxes excluding refunding bonds that are separately approved by the voters, approved by the voters are $32,859,217 for water, sewer, and drainage facilities; and $2,000,000 for firefighting facilities. The aggregate initial principal amounts of all such bonds issued are $32,855,000 for water, sewer, and drainage facilities; and $2,000,000 for firefighting facilities. The District is located partially within the corporate boundaries of the Town of Trophy Club. The Town of Trophy Club and the District overlap but may not provide duplicate services or improvements. Property located in the Town of Trophy Club and the District is subject to taxation by the Town of Trophy Club and the District. The District is located partially within the corporate boundaries of the Town of Westlake. The Town of Westlake and the District overlap but may not provide duplicate services or improvements. Property located in the Town of Westlake and the District is subject to taxation by the Town of Westlake and the District. The purpose of this District is to provide water and sanitary sewer facilities and services and fire- fighting facilities and activities. The cost of district facilities is not included in the purchase price of your property. PURCHASER IS ADVISED THAT THE INFORMATION SHOWN ON THIS FORM IS SUBJECT TO CHANGE BY THE DISTRICT AT ANY TIME. THE DISTRICT ANNUALLY ESTABLISHES TAX RATES. PURCHASER IS ADVISED TO CONTACT THE DISTRICT TO DETERMINE THE STATUS OF ANY CURRENT OR PROPOSED CHANGES TO THE INFORMAITON SHOWN ON THIS FORM. The undersigned purchaser hereby acknowledges receipt of the foregoing notice at or before the execution of a binding contract for the purchase of the real property or at closing of purchase of the real property Date Signature of Purchaser 65 of 113 September 20, 2023 Meeting Agenda Packet CERTIFICATE OF ORDER NO. 2023-0920B ADOPTING AMENDED AND RESTATED INVESTMENT POLICY THE STATE OF TEXAS COUNTIES OF DENTON AND TARRANT § § I, the undersigned District Secretary of Trophy Club Municipal Utility District No. 1 (the "District"), hereby certify as follows: 1. The Board convened in regular session, open to the public, on the 20th day of September 2023, at the regular meeting place thereof, and the roll was called of the members of the Board, to -wit: Kevin R. Carr President Ben Brewster Vice President Doug Harper Secretary/Treasurer William C. Rose Director Tracey Hunter Director All members of the Board were present except the following, , thus constituting a quorum. Whereupon, among other business, the following was transacted at such meeting: ORDER NO. 2023-0920B ADOPTING AMENDED AND RESTATED INVESTMENT POLICY was duly introduced for the consideration of the Board. It was then duly moved and seconded that such Order be adopted; and, after due discussion, such motion, carrying with it the adoption of said Order, prevailed and carried by the following vote: AYES: NAYS: ABSTENTIONS 2. A true, full, and correct copy of the aforesaid Order adopted at the meeting described in the above and foregoing paragraph is attached to and follows this Certificate; such Order has been duly recorded in said Board's minutes of such meeting; the above and foregoing paragraph is a true, full, and correct excerpt from the Board's minutes of such meeting pertaining to the adoption of such Order; the persons named in the above and foregoing paragraph are the duly chosen, qualified, and acting officers and members of the Board as indicated therein; each of the officers and members of the Board was duly and sufficiently notified officially and personally, in advance of the time, place, and purpose of such meeting and that such Order would be introduced and considered for adoption at such meeting and each of such officers and members consented, in advance, to the holding of such meeting for such purpose; such meeting was open to the public, as required by law, and public notice of the time, place and purpose of such meeting was given as required by Chapter 551, Government Code and Section 49.063, Texas Water Code, as amended. SIGNED AND SEALED the 20th day of September 2023. Laurie Slaght, District Secretary 66 of 113 (SEAL) September 20, 2023 Meeting Agenda Packet ORDER NO. 2023-0920B TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 ADOPTING INVESTMENT POLICY THE STATE OF TEXAS COUNTIES OF DENTON AND TARRANT WHEREAS, V.T.C.A., Government Code, Chapter 2256, as amended (the "Public Funds Investment Act"), requires the governing body of political subdivisions to adopt a written investment policy concerning the investment of its funds and funds under its control; WHEREAS, Section 49.157(a) of the Texas Water Code, as amended, provides that all District deposits and investments shall be governed by Subchapter A, Chapter 2256, Government Code (Public Funds Investment Act); and, WHEREAS, Section 49.157(b) of the Texas Water Code, as amended, provides that an authorized representative of the District may invest and reinvest the funds of the District and provide for money to be withdrawn from the appropriate accounts of the District for the investment on such terms as the board considers advisable. WHEREAS, the Board of Directors (the "Board") of Trophy Club Municipal Utility District No. 1 (the "District") has previously designated one or more investment officers and adopted a policy relating to the investment of District funds in accordance with the Public Funds Investment Act; and, WHEREAS, the Public Funds Investment Act requires that the Board of Directors of the District review the Investment Policy and its investment strategies not less than annually and make any changes thereto as determined by the Board of Directors to be necessary and prudent, and to adopt an order or resolution stating that it has reviewed the Investment Policy and investment strategies and recording any changes made thereto. NOW, THEREFORE, BE IT ORDERED BY THE BOARD OF DIRECTORS OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1, THAT: Section 1. The matters and facts recited in the preamble to this Order are found to be true and correct and the same are incorporated herein as a part of this Order. Section 2. The Board has reviewed its Investment Policy and the investment strategies set forth therein in accordance with the requirements of Section 2256.005(e) of the Public Funds Investment Act. Based upon such review, the Board finds and declares that the Investment Policy in the form attached hereto, including the written investment strategies set forth therein, is hereby approved and adopted, and such Policy shall replace and supersede in its entirety the prior Investment Policy of the District, together with any and all other resolutions or orders relating to the investment of the District's funds. The Investment Policy has been revised to update the District's authorized investment firms set forth in Exhibit "C". 67 of 113 September 20, 2023 Meeting Agenda Packet Section 3. The General Manager is authorized to do all things necessary and proper to evidence the Board's adoption of this Order and to carry out the intent hereof. Upon execution, a permanent copy of this Order shall be filed in the permanent records of the District. ADOPTED, PASSED AND APPROVED by the Board of Directors of Trophy Club Municipal Utility District No. 1 on this 20stday of September 2023. Kevin R. Carr, President Board of Directors ATTEST: Doug Harper, Secretary/Treasurer Board of Directors Laurie Slaght, District Secretary 68 of 113 (SEAL) September 20, 2023 Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 INVESTMENT POLICY SEPTEMBER 20, 2023 I. STATUTORY AUTHORITY 1.01 Statutory Authority. This Policy has been adopted pursuant to, and in accordance with the requirements of, Chapter 2256 of the Texas Government Code (the Public Funds Investment Act) and Chapter 2257 of the Texas Government Code (the Public Funds Collateral Act). II. POLICY 2.01 Policy. It is the policy of Trophy Club Municipal Utility District No. 1 ("District") that after allowing for the anticipated cash flow requirements of the District and giving due consideration to the safety and risk of investment, all available funds shall be invested in conformance with these legal and administrative guidelines, seeking to optimize interest earnings to the maximum extent possible. 2.02 Cash Management. Effective cash management is recognized as essential to good fiscal management. Investment interest is a source of revenue to District funds. The District investment portfolio shall be designed and managed in a manner designed to be responsive to public trust, to be in compliance with legal requirements and limitations, and to maximize this revenue source. Investments shall be made with the primary objectives of: * Safety and preservation of principal * Maintenance of sufficient liquidity to meet operating needs * Public trust from prudent investment activities * Optimization of interest earnings on the portfolio III. PURPOSE 3.01 Purpose. The purpose of this investment policy is to comply with Chapter 2256 of the Government Code ("Public Funds Investment Act"), which requires the District to adopt a written investment policy regarding the investment of its funds and funds under its control. The Investment Policy addresses the methods, procedures and practices that must be exercised to ensure effective and judicious fiscal management of District funds. 69 of 113 September 20, 2023 Meeting Agenda Packet IV. SCOPE 4.01 Scope. This Policy applies to the investment of all funds of Trophy Club Municipal Utility District No. 1 (the "District") and funds under its control. The Board of the District shall review this Investment Policy and the investment strategies set forth herein not less than annually and shall make any changes thereto as determined by the Board of the District to be necessary and prudent for the management of District funds. Not less than annually, the Board shall adopt a written order or resolution stating that it has reviewed the Investment Policy and investment strategies and setting forth any changes made thereto. 4.02 This Policy shall govern the investment of all financial assets of the District. These funds are accounted for in the Basic Financial Statements and include: * General Fund * Capital Projects Funds * Debt Service Funds, including reserves and sinking funds, to the extent not required by law or existing contract to be kept segregated and managed separately * Any new fund created by the District, unless specifically exempted from this Policy by the District Board of Directors or by law. 4.03 The District consolidates fund cash balances to maximize investment earnings. Investment income will be allocated to the various funds based on their respective participation and in accordance with generally accepted accounting principles. 4.04 This Policy shall apply to all transactions involving the financial assets and related activity for all the foregoing funds. However, this policy does not apply to the assets administered for the benefit of the District by outside agencies under deferred compensation programs. V. OBJECTIVES 5.01 Investment Objectives. Investment of funds shall be governed by the following investment objectives, in order of priority: i. Preservation and safety of principal - The foremost objective of the District's Investment Policy is to assure safety of the invested funds. Investments shall be undertaken in a manner that seeks to ensure the preservation of capital while minimizing credit rate and interest rate risk. Investment for speculation is prohibited. ii. Liquidity - Funds will be invested with maturities necessary to maintain sufficient liquidity to provide adequate and timely working funds. iii. Yield - Return on investment is of least importance compared to the safety and liquidity objectives described above. 70 of 113 September 20, 2023 Meeting Agenda Packet VI. INVESTMENT PARAMETERS 6.01. Investment Strategies. The District's overall investment strategy shall be to purchase high credit quality investments that preserve the safety of capital, maximize liquidity, promote diversification, and provide reasonable market yield (in that order of priority), based on the District's anticipated cash flows and the maintenance of a liquidity buffer for unanticipated liabilities. Investments are to be chosen in a manner which promotes diversity by market sector, credit, and maturity. The choice of high credit quality investments and high-grade money market instruments are designed to assure the marketability of those investments should liquidity needs arise. Detailed strategies by fund type are set forth in Exhibit "A" of this Policy. The Board of the District shall review annually the investment strategies and shall make any changes thereto as determined by the Board to be necessary and prudent for the management of the District's funds. 6.02 Maximum Maturities. The District will match its investments with anticipated cash flow requirements. To match anticipated cash flow requirements, the maximum weighted average maturity of the overall portfolio shall not exceed 365 days and a benchmark of the six- month and one-year Treasury Bills shall be used to measure risk in the portfolio. Unless matched to a specific cash flow requirement, the District will not directly invest in securities maturing more than 24 months from the date of purchase. 6.03 Diversification. The District will diversify its portfolio to reduce risk. The following table sets forth the minimum diversification standards by security type: Type of Investment Maximum Percentage of District Portfolio US Agencies/Instrumentalities 50% Certificates of Deposit/Share Certificates 90% Local Government Investment Pools 90% Money Market Accounts 90% 6.04. Competitive Bidding Requirement. All securities, including certificates of deposit, will be purchased, or sold after three (3) offers/bids are taken to verify that the District is receiving fair market value/price for the investment. Bids for certificates of deposit may be solicited orally, in writing, electronically, or by any combination of these methods. 6.05. Delivery versus Payment. All security transactions entered into by the District shall be conducted on a delivery versus payment (DVP) basis. Securities will be held by a third - party custodian designated by the Investment Officer and evidenced by safekeeping receipts. 6.06 Rating Declines or Loss of Rating. The Investment Officer shall monitor the credit rating on all authorized investments in the District's portfolio based on independent information from a nationally recognized rating agency. Ratings monitoring will be performed on a monthly basis for all authorized investments except mutual funds and commercial paper. Ratings monitoring will be performed on a weekly basis for mutual funds and commercial paper. If any security falls below the minimum rating required by this Policy (i.e. Public Funds Investment Act), the Investment Officer shall immediately solicit bids for and sell the security if possible, regardless 71 of 113 September 20, 2023 Meeting Agenda Packet of a loss of principal. 6.07 Electronic Wire Transfers. The Investment Officer may use electronic means to transfer or invest funds collected or controlled by the District. Electronic transfers shall only be made with prior written approval by the General Manager. VII. DELEGATION OF INVESTMENT AUTHORITY 7.01 Appointment of Investment Officer. The person serving as General Manager is hereby appointed the Investment Officer of the District. The Investment Officer shall be responsible for the investment of District funds in accordance with this Investment Policy. If the Board has contracted with another investing entity to invest the District's funds, as authorized by the Public Funds Investment Act, the Investment Officer of the other investing entity is considered to be the Investment Officer of the District for such purposes. The authority hereby granted to the Investment Officer to invest the District's funds is effective until rescinded by the Board, until the expiration of the officer's term or the termination of the person's employment with the District, or if an investment management firm, until the expiration of the contract with the District. 7.02 Investment Training. The Board appointed Treasurer, General Manager/ Investment Officer, and Finance Manager shall attend at least one investment training session from an independent source and containing at least six (6) hours of instruction relating to investment responsibilities within 12 (twelve) months after taking office or assuming duties. The Treasurer, General Manager/Investment Officer, and Finance Manager shall also attend an investment training session within each two-year period that begins on the first day of the District's fiscal year and consists of the two consecutive fiscal years after that date after the first year and receive not less than four (4) hours of instruction relating to investment responsibilities from an independent source. Training must include education on investment controls, security risks, strategy risks, market risks, diversification of investment portfolio and compliance with the Public Funds Investment Act. Certificates and/or other documentation of completed training hours shall be maintained with this Policy as Exhibit "E". 7.03 Internal Controls. The Investment Officer is responsible for establishing and maintaining an internal control structure designed to ensure that the assets of the District are protected from loss, theft, or misuse. The internal control structure shall be designed to provide reasonable assurance that these objectives are met. The concept of reasonable assurance recognizes that: (1) the cost of a control should not exceed the benefits likely to be derived; and (2) the valuation of costs and benefits requires estimates and judgments by management. Accordingly, the Investment Officer shall establish a process for annual independent review by an external auditor to assure compliance with policies and procedures. The internal controls shall address the following points. • Control of collusion. • Separation of transactions authority from accounting and record keeping. • Custodial safekeeping. • Written confirmation for telephone (voice) transactions for investments and wire transfers. 72 of 113 September 20, 2023 Meeting Agenda Packet • Development of a wire transfer agreement with the depository bank or third -party custodian. 7.04 Prudence. The standard of care to be used by the Investment Officer shall be prudent person standard and shall be applied in the context of managing the overall portfolio. These standard states that the person designated as the Investment Officer shall exercise the judgment and care, under prevailing circumstances, that a prudent person would exercise in the management of the person's own affairs. In determining whether the Investment Officer has exercised prudence with respect to an investment decision, the determination shall take into consideration (i) the investment of all funds over which the Investment Officer has responsibility rather than consideration as to the prudence of a single investment, and (ii) whether the investment decision was consistent with this Investment Policy. 7.05 Ethics. Officers and employees involved in the investment of District funds shall refrain from personal activity that could conflict with the proper execution and management of the District's investment program. Employees and investment officials shall disclose, in writing, any material interests, including personal business relationships, with any financial institution with which it is proposed that the District conduct business. For purposes of District investments, employees or investment officials have a personal business relationship with a business organization if: i. the individual owns 10 (ten) percent or more of the voting stock or shares of the business organization or owns $5,000 or more of the fair market value of the business organization; or ii. funds received by the individual from the business organization exceed 10 percent of the individual's gross income for the previous year; or iii. the individual has acquired from the business organization during the previous year investments with a book value of $2,500 or more for the personal account of the individual. 7.06 Limitation of Personal Liability. Authorized representatives of the District who invest the District's funds in accordance with this Policy shall have no personal liability for any individual security's credit risk or market price changes provided deviations from expectations are reported in a timely manner and appropriate action is taken to control adverse developments. VIII. INVESTMENT REPORTS 8.01 Internal Management Reports. The Investment Officer shall prepare and submit not less than quarterly to the Board of Directors of the District written reports of investment transactions for all funds of the District for the preceding reporting period. The quarterly reports shall comply with the requirements of Section 2256.023 of the Public Funds Investment Act. Specifically, the quarterly report shall: i. Describe in detail the investment position of the District. 73 of 113 September 20, 2023 Meeting Agenda Packet ii. Be prepared jointly by all Investment Officers. iii. Be signed by each Investment Officer. iv. Contain a summary statement of each pooled fund group that states the: (A) beginning market value for the reporting period; and (B) ending market value for the period; and (C) fully accrued interest for the reporting period; and (D) state the book value and market value of each separately invested asset at the end of the reporting period by the type of asset and fund type invested; and (E) state the maturity date of each separately invested asset that has a maturity date; and (F) state the account or fund or pooled group fund in the state agency or local government for which each individual investment was acquired; and (G) state the compliance of the investment portfolio of the District as it relates to: (i) the investment strategy expressed in this Policy; and (ii) relevant provisions of the Public Funds Investment Act. IX. COLLATERAL, SAFEKEEPING, AND CUSTODY REQUIREMENTS 9.01 Collateral Policy. Consistent with the requirements of the Public Funds Collateral Act, it is the policy of the District to require full collateralization of all District funds on deposit with a depository bank and for repurchase agreements. In order to anticipate market changes and provide a level of security for all funds, the collateralization level will be 102% of market value of principal and accrued interest on the deposits or investments, less an amount insured by the FDIC. At its discretion, the District may require a higher level of collateralization for certain investment securities. Securities pledged as collateral shall be held by an independent third party with which the District has a current custodial agreement. The General Manager is responsible for entering into collateralization agreements with third party custodians in compliance with this Policy. The agreements are to specify the acceptable investment securities for collateral, including provisions relating to possession of the collateral, the substitution or release of investment securities, ownership of securities, and the method of valuation of securities. A clearly marked evidence of ownership (safekeeping receipt) must be supplied to the District and retained. Collateral shall be reviewed at least monthly to assure that the market value of the pledged securities is adequate. 9.02 Authorized Collateral for Time and Demand Deposits. The District shall accept only the following securities as collateral for time and demand deposits: 74 of 113 September 20, 2023 Meeting Agenda Packet i. FDIC insurance coverage. ii. Obligations of the United States, its agencies or instrumentalities, or other evidence of indebtedness of the United States guaranteed as to principal and interest. iii. Obligations of Texas or other states or of a county, city or other political subdivision of a state having been rated as not less than "A" or its equivalent by two nationally recognized rating agencies. iv. A letter of credit issued by a federal home loan bank. 9.03 Authorized Collateral for Repurchase Agreements. The District shall accept as collateral for repurchase agreements only obligations of the United States, its agencies, or instrumentalities. X. AUTHORIZED INVESTMENTS 10.01 Authorized Investments. The following are authorized investments for the District's funds, as further described and restricted by the Public Funds Investment Act: i. Obligations of, or guaranteed by, the United States. Obligations of the United States, its agencies, and instrumentalities, excluding mortgage-backed securities, and that are authorized investments under Section 2256.009 of the Public Funds Investment Act. ii. State Obligations. Obligations of the State of Texas or any state of the United States or their respective agencies and instrumentalities, agencies, counties, cities, and other political subdivisions rated as to investment quality by a nationally recognized investment rating firm not less than A or its equivalent, and that are authorized investments under Section 2256.009 of the Public Funds Investment Act. iii. Other Governmental Obligations. Obligations, the principal, and interest of which are unconditionally guaranteed or insured by, or backed by the full faith and credit of, the State of Texas or the United States or their respective agencies and instrumentalities, including obligations that are fully guaranteed or insured by the Federal Deposit Insurance Corporation or by the explicit full faith and credit of the United States. iv. Certificates of Deposit/Share Certificates. (a) Fully insured or collateralized certificates of deposit or share certificates that are approved investments under Section 2256.010 of the Public Funds Investment Act: (i) from a depository institution that has its main office or a branch office in the State of Texas; and (ii) that are guaranteed or insured by the Federal Deposit Insurance Corporation or its successor, or by the National Credit Union Share Insurance Fund or its successor, as applicable. Authorized certificates of deposit shall include such certificates purchased through the CDARS program with a Texas bank. 75 of 113 September 20, 2023 Meeting Agenda Packet (b) Fully insured certificates of deposit purchased from a broker or a bank that has its main office or a branch office in the State of Texas and is selected from the list of qualified brokers attached to this Investment Policy. All investments in such brokered certificates of deposit shall be made on a delivery versus payment basis to the District's safekeeping agent, and the Investment Officer shall verify that the bank is fully insured by the Federal Deposit Insurance Corporation prior to purchase. In the event any bank from which the District has purchased a brokered certificate of deposit merges with, or is acquired by, another bank in which brokered certificates of deposit are owned by the District, the Investment Officer shall immediately contact the banks and liquidate any brokered certificate that exceeds FDIC insurance levels. v. Repurchase Agreements. Fully collateralized repurchase agreements with a defined termination date executed with a primary dealer as defined by the Federal Reserve or a financial institution doing business in this state, and that are authorized investments under Section 2256.011 of the Public Funds Investment Act. vi. Mutual Funds. Money Market Mutual funds that: 1) are registered and regulated by the Securities and Exchange Commission, 2) have a dollar weighted average stated maturity of 90 days or less, 3) seek to maintain a net asset value of $1.00 per share, and 4) are rated AAA by at least one nationally recognized rating service. vii. Investment Pools. AAA -rated, constant -dollar local government investment pools that meet the requirements set forth in the Public Funds Investment Act for the investment of public funds, including Sections 2256.016, .017, .018, and .019, and provided further that such investments must be approved by the Board of Directors of the District by separate resolution. viii. Interest bearing accounts of any FDIC bank in Texas. XI. AUTHORIZED FINANCIAL DEALERS AND INSTITUTIONS 11.01 Authorized Financial Dealers and Institutions. The Board may contract with an investment management firm registered under the Investment Advisers Act of 1940 (15 U.S.C. Section 80b-1 et seq.) or with the State Securities Board to provide for the investment and management of public funds; provided, that a contract may not be for a term longer than two years, and any renewal or extension thereof must be made by the Board by order or resolution. XII. MISCELLANEOUS 12.01 Policy to be presented to Investment Officer. The Investment Officer shall be presented a copy of this Investment Policy and shall execute a written instrument substantially in the form attached hereto as Exhibit "B" to the effect that the Investment Officer has: 76 of 113 September 20, 2023 Meeting Agenda Packet i. received and thoroughly reviewed a copy of this Investment Policy; and ii. implemented procedures and controls to comply with the Investment Policy. 12.02 Policy to be presented to Investment Firms. A written copy of the Investment Policy shall be presented to any business organization offering to engage in an investment transaction with the District. For purposes of this Policy, a "business organization" is an investment pool or investment management firm under contract with the District to invest or manage the District's investment portfolio that has accepted authority granted by the District under the contract to exercise investment discretion in regard to the District's funds. The qualified representative of the business organization offering to engage in an investment transaction with the District shall execute a written instrument in a form acceptable to the District and the business organization substantially to the effect that the business organization has: i. Received and reviewed the Investment Policy of the District; and ii. Acknowledged that the business organization has implemented procedures and controls in an effort to preclude investment transactions conducted between the District and the organization that are not authorized by the District's Investment Policy, except to the extent that this authorization is dependent on an analysis of the makeup of the District's entire portfolio or requires an interpretation of subjective investment standards. The Investment Officer may not acquire or otherwise obtain any authorized investment described in the Investment Policy from a person who has not delivered to the District the written instrument set forth in Exhibit "B" hereof. The District shall maintain a copy of each of the executed written statements described in Sections 12.01 and 12.02 for the auditor and include them as Exhibit "D" of this policy. At any time that the District amends this Investment Policy, the Investment Officer shall present the amended Investment Policy to all persons and/or business organizations at which funds of the District are invested and shall obtain a new written instrument as described in Section 10.01(B) hereof. 12.03 Annual Financial Audit. The District, in conjunction with its annual financial audit, shall perform a compliance audit of management controls on investments and adherence to the District's established investment policies. 12.04 Selection of Authorized Brokers. The District shall annually review, revise and adopt a list of qualified brokers that are authorized to engage in investment transactions with the District. Approved Investment Brokers are those listed in Exhibit C of this Policy. 12.05 Repeal of Prior Orders. Any and all prior orders or resolutions relating to the investment of District funds are hereby repealed and this Policy shall supersede any such prior orders or resolutions as of the date of its adoption by the Board of Directors. 12.06 Effective Date. This Policy shall be effective as of September 20, 2023. 77 of 113 September 20, 2023 Meeting Agenda Packet EXHIBIT "A" INVESTMENT STRATEGY Operating Funds Suitability - All investments authorized in the Investment Policy are suitable for Operating Funds. Preservation and Safety of Principal - All investments shall be high quality securities with no perceived default risk. Liquidity - Investment strategies for the pooled operating funds have as their primary objective to assure that anticipated cash flows are matched with adequate investment liquidity. The dollar -weighted average maturity of operating funds, based on the stated final maturity date of each security, will be calculated, and limited to one year or less. Constant $1 net asset value investment pools and money market mutual funds shall be an integral component in maintaining daily liquidity. Investments for these funds shall not exceed an 18 -month period from date of purchase. Marketability - Securities with active and efficient secondary markets will be purchased in the event of an unanticipated cash requirement. Diversification - Maturities shall be staggered throughout the budget cycle to provide cash flows based on anticipated needs. Investment risks will be reduced through diversification among authorized investments. Yield - The District's objective is to attain a competitive market yield for comparable securities and portfolio constraints. The benchmark for Operating Funds shall be the 91 -day Treasury bill. Reserve and Deposit Funds Suitability - All investments authorized in the Investment Policy are suitable for Reserve and Deposit Funds. Preservation and Safety of Principal - All investments shall be high quality securities with no perceived default risk. Liquidity - Investment strategies for reserve and deposit funds shall have as the primary objective the ability to generate a dependable revenue stream to the appropriate reserve fund from investments with a low degree of volatility. Except as may be required by the bond ordinance specific to an individual issue, investments should be of high quality, with short -to - intermediate -term maturities. The dollar -weighted average maturity of reserve and deposit funds, based on the stated final maturity date of each security, will be calculated, and limited to two years or less. 78 of 113 September 20, 2023 Meeting Agenda Packet Marketability - Securities with active and efficient secondary markets will be purchased in the event of an unanticipated cash requirement. Diversification - Maturities shall be staggered throughout the budget cycle to provide cash flows based on anticipated needs. Investment risks will be reduced through diversification among authorized investments. Yield - The District's objective is to attain a competitive market yield for comparable securities and portfolio constraints. The benchmark for Reserve and Deposit Funds shall be the ninety- one (91) day Treasury bill. Bond and Certificate Capital Project Funds and Special Purpose Funds Suitability - All investments authorized in the Investment Policy are suitable for Bond and Certificate Capital Project Funds and Special Purpose Funds. Preservation and Safety of Principal - All investments shall be high quality securities with no perceived default risk. Liquidity - Investment strategies for bond and certificate capital project funds, special projects and special purpose funds' portfolios will have as their primary objective to assure that anticipated cash flows are matched with adequate investment liquidity. The stated final maturity dates of investments held should not exceed the estimated project completion date or a maturity of no greater than three years. The dollar -weighted average maturity of bond and certificate capital project funds and special purpose funds, based on the stated final maturity date of each security, will be calculated, and limited to two years or less. Marketability - Securities with active and efficient secondary markets will be purchased in the event of an unanticipated cash requirement. Diversification - Maturities shall be staggered throughout the budget cycle to provide cash flows based on anticipated needs. Investment risks will be reduced through diversification among authorized investments. Yield - The District's objective is to attain a competitive market yield for comparable securities and portfolio constraints. The benchmark for Bond and Certificate Capital Project Funds and Special Purpose Funds shall be the ninety-one (91) day Treasury bill. A secondary objective of these funds is to achieve a yield equal to or greater than the arbitrage yield of the applicable bond or certificate. Debt Service Funds Suitability - All investments authorized in the Investment Policy are suitable for Debt Service Funds. Preservation and Safety of Principal - All investments shall be high quality securities with no perceived default risk. 79 of 113 September 20, 2023 Meeting Agenda Packet Liquidity - Investment strategies for debt service funds shall have as the primary objective the assurance of investment liquidity adequate to cover the debt service obligation on the required payment date. Securities purchased shall not have a stated final maturity date which exceeds the debt service payment date. The dollar -weighted average maturity of debt service funds, based on the stated final maturity date of each security, will be calculated, and limited to one year or less. Marketability - Securities with active and efficient secondary markets will be purchased in the event of an unanticipated cash requirement. Diversification - Maturities shall be staggered throughout the budget cycle to provide cash flows based on anticipated needs. Investment risks will be reduced through diversification among authorized investments. Yield - The District's objective is to attain a competitive market yield for comparable securities and portfolio constraints. The benchmark for Debt Service Funds shall be the ninety-one (91) day Treasury bill. 80 of 113 September 20, 2023 Meeting Agenda Packet EXHIBIT "B" INVESTMENT OFFICER AND INVESTMENT FIRM CERTIFICATION OF RECEIPT AND REVIEW OF INVESTMENT POLICY THE STATE OF TEXAS COUNTY OF DENTON 1, Alan Fourmentin of Trophy Club Municipal Utility District No. 1 do hereby certify that I have been presented a copy of the Amended and Restated Investment Policy for Trophy Club Municipal Utility District No. 1 dated September 20, 2023. I have thoroughly reviewed the Investment Policy and acknowledge that Trophy Club MUD No. 1 has implemented procedures and controls to comply with the Investment Policy. WITNESS MY HAND THIS 20th day of September , 2023. Name: Alan Fourmentin Title: General Manager 81 of 113 September 20, 2023 Meeting Agenda Packet EXHIBIT "C" APPROVED INVESTMENT FIRMS Name of Bank Phone Number Address Town State Zip Prosperity Bank 817-378-2210 217 North Main Keller TX 76248 First Financial 817-329-8615 95 Trophy Club Dr Trophy Club TX 76262 TexPool 866-839-7665 1001 Texas Avenue Suite 1400 Houston TX 77002 82 of 113 September 20, 2023 Meeting Agenda Packet EXHIBIT "D" TRAINING CERTIFICATES FOR INVESTMENT OFFICER 83 of 113 eptember eeung agenaa rac University of North Texas Center for Public Management and Government Treasurers' Organization of Texas Co -Sponsored by El Paso County Certificate of Attendance presented to .Can Fourmentin For completion of training on the Texas Public Funds Investment Act and related investment issues June 21, 2022 4 hours 84 of 113 Patrick Shinkle Center for Public Management TSBPA CPE Sponsor 007716 15,1 TROPHY CLUB MUNICIPAL UTILITY DISTRICT September 20, 2023 Meeting Agenda Packet STAFF REPORT September 20, 2023 AGENDA ITEM: Consider and act regarding approval of task order agreement with Halff Associates for professional engineering services for the replacement of the existing water lines at a total cost of $86,200 and authorize the General Manager to execute the necessary documents to implement Board action. DESCRIPTION: Halff Associates will provide professional engineering services for the design, bidding, and construction phase services for the replacement of approximately 7,150 linear feet of water lines along and adjacent to Inverness Drive, Forest Hill Drive, Sonora Drive, Pagosa Court, Palo Duro Court, and Mesa Verde Court as a part of FY 2024 Capital Improvement Projects. ATTACHMENTS: Halff Task Order Proposal RECOMMENDATION: Approval of Task Order Agreement as stated above as part of FY 2024 Capital Improvement Projects. 85 of 113 September 20, 2023 Meeting Agenda Packet e halff August 3, 2023 P36681.005 Mr. Alan Fourmentin Trophy Club Municipal Utility District No.1 100 Municipal Drive Trophy Club, Texas 76262 RE: Proposal for FY 2024 8 -Inch Water Line Design Dear Mr. Fourmentin, We are pleased to present the following scope of services and fee schedule to provide professional engineering services for the Trophy Club Municipal Utility District No. 1 (District). Per our discussion, the District would like Halff Associates to prepare engineering design plans for the replacement of the existing water lines along Inverness Drive, Forest Hill Drive, Sonora Drive, Pagosa Court, Palo Duro Court, and Mesa Verde Court. This contract proposal includes the following items: Attachment 'A' — Scope of Services and Attachment 'B' — Fee Summary. Refer to Halff's Agreement for Professional Engineering Services on a Task Order Basis, executed by the District on October 18, 2018, for the terms and conditions of this proposal. The fees quoted in this proposal will be honored for up to 60 days from the date of this proposal. The signed Agreement by both parties will serve as Notice to Proceed (NTP). Engineering services will begin upon NTP and following the initial meeting with the District. See Attachment 'B' for signature page. We trust this proposal meets your requirements for this project. We appreciate the opportunity to be of service to you, and trust that our association on this project will be mutually beneficial. Please feel free to contact us if you have any questions or comments concerning this proposal. Sincerely, HALFF ASSOCIATES, INC. Leah M. Hodge, PE, CFM Project Manager C: Ron King, PE - Halff 2601 Meacham Blvd., Suite 600, Fort Worth, TX 76137 1 halff.com 86 of 113 e halff ATTACHMENT 'A' Scope of Services Overview September 20, 2023 Meeting Agenda Packet Mr. Alan Fourmentin TCMUD No. 1 August 3, 2023 Page 2 Halff will prepare design plans for 8 -inch water lines and services, an approximate total length of 7,150 linear feet. The existing asbestos cement (AC) lines will be replaced in-place by AWWA C-900 pipe. The District has provided record drawings of the existing water lines. The water lines will be replaced in the existing alignment. The Inverness Drive water line replacement will begin at Forest Hill Drive and end at Indian Creek Drive. The total length is approximately 2,5001£ The Forest Hill Drive replacement will begin at Indian Creek Drive and end at Fresh Meadow Court. The total length is approximately 1,260 if. The Sonora Drive replacement will begin at Monterey Drive and end at Village Trail. The total length is approximately 2,300 if. The Pagosa Court replacement will begin at Sonora Drive and end at the cul-de-sac for a total length of 490 lf. The Palo Duro Court replacement will begin at Sonora Drive and end at the cul-de-sac for a total length of 3201f. The Mesa Verde Court replacement will begin at Sonora Drive and end at the cul-de-sac for a total length of 2801f. Basemap Preparation No survey will be performed as part of this project. The basemap will be prepared using an aerial image, record drawings, and field verification. GIS property boundaries from the Denton County Appraisal District will be utilized. Final Design Phase (90% Submittal) Final plans will be prepared and submitted to the District for review. The plans will include the following sheets: 1. Cover Sheet with locator map and sheet index. 2. General notes/specifications sheet. 3. Project layout sheet. 4. Water line plan sheets; no profiles. 5. Construction detail sheets. 6. Contract Documents and Specifications (separate document). 87 of 113 • halif September 20, 2023 Meeting Agenda Packet Mr. Alan Fourmentin TCMUD No. 1 August 3, 2023 Page 3 Halff will deliver a PDF and two half size (11"x17") hard copies of the Construction Plans to the District for review. Halff will submit an estimate of probable construction cost with the 90% submittal. A review meeting with the District will be conducted at the end of the 90% Design Phase. Construction Plans (100% Submittal) District comments will be addressed, and the plans will be submitted for construction. Each plan sheet will be stamped, dated and signed by the Engineer. Contract Documents and Specifications will be prepared. Halff will submit an updated estimate of probable construction cost with the 100% submittal. Halff will deliver a PDF, and one full size (22"x34") and three half size (11"x17") hard copies of the Construction Plans to the District. Bidding and Construction Phase Services Halff will provide bidding and construction phase services, including the following tasks: 1. Provide Link to Bidding Documents and Maintain Plan holder List through Civcast 2. Attend Pre -Bid Meeting 3. Issue Addenda and Respond to Contractor Questions 4. Prepare Bid Tabulation and Letter of Recommendation 5. Prepare Conformed Contract Documents for Execution (4 Originals) 6. Provide Plans for Construction (1-22"x34" and 3-11"x17") 7. Attend Pre -Construction Meeting 8. Review Submittals and Answer RFIs 9. Review Pay Applications 10. Prepare Project Closeout Documents 11. Prepare Record Drawings 12. Update GIS Shapefiles and Asset Management Spreadsheet Schedule • Completion of final construction plans and contract documents and specifications (90%): 90 calendar days from notice to proceed. • Completion of construction plans (100%): 150 calendar days from notice to proceed, excluding District review time. • Bidding services: 30 calendar days from District's approval of construction plans. • Construction services: In accordance with construction schedule • Closure: 30 calendar days from the date of construction completion 88 of 113 e halff September 20, 2023 Meeting Agenda Packet Mr. Alan Fourmentin TCMUD No. 1 August 3, 2023 Page 4 Additional services not included in the Scope of Services: • Geotechnical investigation • Subsurface Utility Engineering (SUE) services • Traffic control services • ROW/Easement services, including temporary right -of -entries • Pavement replacement or rehabilitation outside of the trench width • Public meetings • Performance of materials testing or specialty testing services • Services related to submitting for permits (ie. Town, utilities, etc.) • Services related to survey construction staking • Construction site visits • Construction inspection services, including final walk through 89 of 113 e halff ATTACHMENT 'B' Fee Summary PROPOSED FEE SCHEDULE September 20, 2023 Meeting Agenda Packet Mr. Alan Fourmentin TCMUD No. 1 August 3, 2023 Page 5 I. Construction Plan Preparation $65,400 (Lump Sum) IL Bidding and Construction Phase Services $20,800 (Lump Sum) TOTAL FEE $86,200 This project will be a lump sum fee. The lump sum fee will not be exceeded without prior approval from the District. The lump sum fee will be invoiced monthly based on percent completed. Halff will coordinate with the District to establish the billing schedule. Direct costs, including printing, plotting, and reproduction, postage, messenger service, specialized equipment (such as GPS), long distance telephone calls and vehicle mileage will be considered reimbursable and will be billed at 1.10 times the direct cost incurred. Additional services may be requested by the District on a task order basis. Halff will develop a separate scope and fee for each additional service and obtain approval from the District prior to initiating work on the additional services. A summary of current hourly billing rates and current unit pricing schedule is in Halff's Agreement for Professional Engineering Services on a Task Order Basis with the District (dated October 18, 2018). Unless otherwise stated, fees quoted in this proposal exclude state and federal sales taxes on professional services. Current Texas law requires assessment of sales tax on certain kinds of surveying services but does not require sales taxes on other professional services. In the event that new or additional state or federal taxes are implemented on the professional services provided under this contract during the term of the work, such taxes will be added to the applicable billings and will be in addition to the quoted fees and budgets. The fees and budgets established above do not include revisions once the project is underway. If revisions are requested, a revision to the scope and budget will be required. Refer to Halff's Agreement for Professional Engineering Services on a Task Order Basis, executed by the District on October 18, 2018, for the terms and conditions of this proposal. We will proceed upon receiving the signed copy of this proposal. Signature blocks are on the following page. 90 of 113 By: e halff September 20, 2023 Meeting Agenda Packet Mr. Alan Fourmentin TCMUD No. 1 August 3, 2023 Page 6 Submitted: Approved: HALFF ASSOCIATES, INC. TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO.1 e, By: Signature Signature Ron King Printed Name Printed Name W/WW Team Leader Title Title 8/3/2023 Date Date 91 of 113 15,1 TROPHY CLUB MUNICIPAL UTILITY DISTRICT September 20, 2023 Meeting Agenda Packet STAFF REPORT September 20, 2023 AGENDA ITEM: Consider and act regarding approval of work order with Garver for professional engineering services related to Wastewater Treatment Plant Improvements at a total cost of $75,498 and authorize the General Manager to execute the necessary documents to implement Board action. DESCRIPTION: Garver will provide design, bidding, and construction services related to the installation of permanent Clean in Place (CIP) Systems to perform high pH and low pH cleaning of the MBR permeate membranes including associated tanks, pumps, electrical, and piping; installation of a fan and louver on a hatch on the south side of the MBR complex; and replacement of the vault for the backflow preventer. ATTACHMENT: Work Order #2301627 RECOMMENDATION: Approval of Work Order Agreement as stated above as part of FY2024 Capital Improvement Projects. 92 of 113 September 20, 2023 Meeting Agenda Packet Work Order 2301627 to the Master Agreement For Professional Services Trophy Club Municipal Utility District No. 1 Project No. 2301627 Version 1 Trophy Club MUD No. 1 WWTP MBR Garver Project No. 2301627 Improvements 93 of 113 September 20, 2023 Meeting Agenda Packet This WORK ORDER ("Work Order") is made by and between the Trophy Club Municipal Utility District No. 1 (hereinafter referred to as "Owner") and Garver, LLC, (hereinafter referred to as "Garver") in accordance with the provisions of the MASTER AGREEMENT FOR PROFESSIONAL SERVICES executed on July 27, 2021 (the"Agreement'). Under this Work Order, the Owner intends to perform WWTP CIP and Hatch Improvements to include the following: • Installation of permanent Clean In Place (CIP) Systems to perform high pH and low pH cleaning. The cleaning chemical will be manually added and batched in the new storage tank. Cleaning will be manually started and stopped using local controls. Two systems will be provided: one near PA Tank #1 and one located near PA Tank #2. Potable water routing will be evaluated during the preliminary design phase for feasibility and cost-effectiveness. • Installation of a fan and louver on a hatch on the south side of the MBR complex. • Replacement of the vault for the backflow preventer. Garver will provide professional services related to these improvements as described herein. Terms not defined herein shall have the meaning assigned to them in the Agreement. SECTION 1 - SCOPE OF SERVICES Garver shall provide the following Services: 1. TASK 1 - PROJECT MANAGEMENT 1.1. Garver will also perform the following: (a) Conduct a kick-off meeting with the Owner to discuss project scope, introduce teams, establish lines of communication, and present the project schedule. At that time, up to two (2) Garver members will visit the WWTP to observe the areas of improvements. (b) Garver will prepare and provide up to twelve (12) monthly progress/status reports, sufficient to support monthly billings. Monthly status reports shall be submitted with monthly invoices and project updates. (c) Garver will develop a Project Management Plan (PMP) for internal use. This will include the development of a detailed schedule to communicate key deadlines to the design teams. Garver will also develop a Quality Control/Assurance Plan and perform internal Quality Assurance/Quality Control (QA/QC) reviews of all major deliverables. 2. TASK 2 - PRELIMINARY DESIGN The Preliminary Design phase submittal will include preliminary drawings and an opinion of probable construction cost (OPCC). The preliminary design phase will represent approximately 50 percent of final construction contract plans. This submittal will not include technical specifications or "front end" contract documents. Garver will incorporate comments from the Owner on the Preliminary Design in the Final Design. Garver will complete the Preliminary Design within 45 days from receipt of the Notice to Proceed (NTP). 2 Version 1 Trophy Club MUD No. 1 WWTP CIP and Hatch Garver Project No. 2301627 Improvements 94 of 113 2.1. Design Submittal Workshops September 20, 2023 Meeting Agenda Packet GARVER will lead a 50% design workshop to solicit comments and feedback from the Owner. This workshop will be conducted at the Owner's office and will be attended by up to two (2) Garver members. 2.2. Deliverables This task will include the following deliverables: 1. Preliminary Design Drawings — one (1) electronic (pdf) copy to the Owner 3. TASK 3 - FINAL DESIGN During the final design phase of the project, Garver will conduct final designs to prepare construction plans and specifications for one (1) construction contract, including final construction details, special provisions, and OPCC. The final design phase is anticipated to have two major submittals: a 90% Design and a 100% Design/Issued for Bid. Garver will complete the 90% Design/TCEQ Deliverable within 60 days from receipt of Owner's approval of the Preliminary Design. 3.1. Drawings and Specifications Based upon the results of the approved preliminary design by the Owner, Garver will develop the detailed plans and specifications as a part of the Final Design for a single construction contract. Garver will utilize Engineers Joint Council Documents Committee (EJCDC) standard documents as a base for developing the project's front-end documents. EJCDC's standard General Conditions shall be utilized with edits being provided by the Supplementary Conditions. Multiple design scenarios or bid packages and/or pre -purchased equipment packages are not included as part of the level of effort provided with this agreement. The drawings will include: • General Drawings • Demolition Plans and Sections • Site Plan • Process Mechanical • Instrumentation • Electrical Plans and Schematics 3.2. Contract Documents The Contract Documents will consist of drawings and specifications that set forth requirements for construction of the improvements, and shall include proposal forms, notice to bidders, bid forms, bond forms, and other information as required by the Owner to competitively bid the work. Garver's standard contract forms including documents from the EJCDC will be used, along with Garver's standard drawing format and technical specifications. Standard forms required by the funding source will also be included as necessary. 3.3. TCEQ Construction Permit Garver will prepare and submit a TCEQ Construction Permit Application. 3.4. Design Submittal Workshops 3 Version 1 Trophy Club MUD No. 1 WWTP CIP and Hatch Garver Project No. 2301627 Improvements 95 of 113 September 20, 2023 Meeting Agenda Packet Garver will lead a 90% design workshop to solicit comments and feedback from the Owner. This workshop will be conducted at the Owner's office and will be attended by up to two (2) Garver members. 3.5. Deliverables This task will include the following deliverables: (a) 90% design documents (plans, specifications, and OPCC) — one (1) electronic (pdf) copy of each to the Owner (b) 100% design/Issue for Bid documents (plans, specifications, and OPCC) — one (1) electronic (pdf) copy of each to the Owner) 4. TASK 4 - BIDDING SERVICES This task will accomplish the following: • Advertise for bids • Conduct a pre-bid meeting • Prepare a letter of recommendation • Conducta pre -construction meeting Garver will complete the Bidding Services within 30 days from receipt of Owner's approval to advertise. 4.1. Bidding Assistance The scope of services assumes the bidding period for bidders is 45 calendar days. During the bidding period phase of the project, the following tasks will be accomplished: (a) Garver will prepare and submit Advertisement for Bids to an online plan room (such as Civcast). Other construction contract documents and any other necessary information will also be uploaded. Garver will also respond to questions submitted by potential bidders. (b) The Owner will submit the advertisement to newspaper(s) for publication and will pay for those advertising costs outside of this contract. (c) Garver will support the contract documents by preparing addenda as appropriate and posting on Garver's online plan room. (d) Garver will participate in a pre-bid meeting. (e) Garver will prepare pre-bid meeting minutes. Following Owner authorization, post the pre-bid meeting minutes with attendance record on GARVER's online plan room. (f) Garver will participate and chair a construction site tour by interested pre-bid meeting attendees and other interested parties. (g) Garver will prepare a bid tabulation. (h) Garver will evaluate bids and recommend award. 5. TASK 5 - CONSTRUCTION ADMINISTRATION SERVICES During the construction phase of work, Garver will accomplish the following: (a) Issue a Notice to Proceed letter to the Contractor and prepare and attend preconstruction meeting. (b) Attend regular progress/coordination meetings, up to a maximum of six (6), with the Owner/Contractor. 4 Version 1 Trophy Club MUD No. 1 WWTP CIP and Hatch Garver Project No. 2301627 Improvements 96 of 113 September 20, 2023 Meeting Agenda Packet (c) Evaluate and respond to construction material submittals and shop drawings. Corrections or comments made by Garver on the shop drawings during this review will not relieve Contractor from compliance with requirements of the drawings and specifications. The check will only be for review of general conformance with the design concept of the project and general compliance with the information given in the contract documents. The Contractor will be responsible for confirming and correlating all quantities and dimensions, selecting fabrication processes and techniques of construction, coordinating his work with that of all other trades, and performing his work in a safe and satisfactory manner. Garver's review shall not constitute approval of safety precautions or constitute approval of construction means, methods, techniques, sequences, procedures, or assembly of various components. When certification of performance characteristics of materials, systems or equipment is required by the Contract Documents, either directly or implied for a complete and workable system, Garver shall be entitled to rely upon such submittal or implied certification to establish that the materials, systems or equipment will meet the performance criteria required by the Contract Documents. The fee is based upon approximately 10 estimated submittals. (d) Issue instructions to the Contractor on behalf of the Owner and issue necessary clarifications (respond to RFIs) regarding the construction contract documents. The fee is based upon approximately five (5) estimated RFIs. (e) When authorized by the Owner, prepare change orders for changes in the work from that originally provided for in the construction contract documents. If redesign or substantial engineering or surveying is required in the preparation of these change order documents, the Owner will pay Garver an additional fee to be agreed upon by the Owner and Garver. The fee is based upon reviewing approximately two (2) contract modification requests and preparing up to one (1) change orders. (f) Participate in final project inspection, prepare punch list, review final project closing documents, and submit final pay request. Garver will also provide a project certification letter with final project cost to the Owner. 6. Extra Work The following items are not included under this agreement but will be considered as extra work: • Boundary, topographic, or any other survey • Realignment or modification of the electrical utility service to the sites • Realignment of the site boundary or fencing • Site lighting improvements • Design of a new building to house the new pumps • Arc flash or other power system studies • Design for generator systems • Submittals or deliverables in addition to those listed herein • Redesign for the Owner's convenience or due to changed conditions after previous alternate direction and/or approval SECTION 2 — PAYMENT For the Services set forth above, Owner will pay Garver as follows: The table below presents a summary of the fee amounts and fee types for this Work Order. 5 Version 1 Trophy Club MUD No. 1 WWTP CIP and Hatch Garver Project No. 2301627 Improvements 97 of 113 WORK DESCRIPTION September 20, 2023 Meeting Agenda Packet FEE AMOUNT FEE TYPE Task 1 - Project Management $4,738 LUMP SUM Task 2 - Preliminary Design (50%) $22,902 LUMP SUM Task 3 - Final Design (90% and 100%) $23,542 LUMP SUM Task 4 — Bidding Services $9,274 LUMP SUM Task 5 — Construction Admin Services $15,042 TIME & MATERIALS TOTAL FEE $75,498 The total amount to be paid under this Work Order is $75,498. Additional Services (Extra Work). For services not described or included in Section 2, but requested by the Owner in writing or otherwise, the Owner will pay Garver as expressly set forth in the applicable Amendment, or in the event the Amendment is silent, for the additional time spent on the Project, at the rates shown in this Appendix A for each classification of Garver's personnel (may include contract staff classified at Garver's discretion) plus reimbursable expenses including but not limited to printing, courier service, reproduction, and travel. The rates shown in Appendix A will be increased annually on or about June 30, 2024. SECTION 3 — APPENDICES 3.1 The following Appendices are attached to and made a part of this Work Order: Appendix A — Hourly Rate Schedule This Work Order may be executed in two (2) or more counterparts each of which shall be deemed an original, but all of which together shall constitute one and the same instrument. 6 Version 1 Trophy Club MUD No. 1 WWTP CIP and Hatch Garver Project No. 2301627 Improvements 98 of 113 September 20, 2023 Meeting Agenda Packet The effective date of this Work Order shall be the last date written below. Trophy Club Municipal Utility District No. 1 GARVER, LLC By: By: r -c '�'`-r" ,r Y Signature Signature Name: Alan Fourmentin Name* Lance Klement Printed Name Printed Name Title: General Manager Title. North Texas Water Team Leader 8/31/2023 Date: Date: 7 Version 1 Trophy Club MUD No. 1 WWTP CIP and Hatch Garver Project No. 2301627 Improvements 99 of 113 Classification September 20, 2023 Meeting Agenda Packet APPENDIX A HOURLY RATE SCHEDULE Rates ClassWIcatian Rates Engineers 1 Architects Resource Specialists E-1 $ 130.00 RS -1 $ 104.00 E-2 $ 144.00 RS•2 $ 137.00 E-3 $ 174.00 RS -3 $ 194.00 E-4 $ 203.00 RS -4 $ 258.00 E-5 $ 247.00 RS -5 $ 335.00 E-6 $ 304,00 RS -6 $ 411.00 E-7 $ 422.00 RS•7 $ 460.00 Planners EnvironrnentaI Specialists P-1 $ 157.00 ES -1 $ 104.00 P-2 $ 196.00 ES -2 $ 131.00 P-3 $ 244.00 ES -3 $ 168.00 P-4 $ 273.00 ES -4 $ 198.00 P-5 $ 308.00 ES -5 $ 248.00 ES -6 $ 318.00 Designers ES -7 $ 398.00 D•1 $ 118.00 ES -8 $ 450.00 D-2 $ 135.00 D-3 $ 151,00 Project Controls D-4 $ 193.00 PC -1 $ 106.00 PC -2 $ 14-0.00 Technicians PC•3 $ 178.00 T-1 $ 95.00 PC -4 $ 229.00 T-2 $ 114.00 PC -5 $ 280.00 T-3 $ 139.00 PC -6 $ 361.00 T-4 $ 160.00 PC -7 $ 454.00 Surveyors Administration 1 Management S-1 $ 58.00 AM -1 $ 75.00 5-2 $ 77.00 AM -2 $ 96.00 3-3 $ 103.00 AM -3 $ 134.00 5-4 $ 148.00 AM•4 $ 171.00 3-5 $ 167.00 AM -6 $ 209.00 3-6 $ 218.00 AM -5 $ 272.00 2 -Man Crew (Survey) $ 226.00 AM -7 $ 320.00 3 -Mari Crew (Survey) $ 2B2.00 M-1 $ 510.00 2.Man Crew (GPS Survey) $ 245.00 3 -Man Crew (GPS Surrey) $ 302.00 Construction Observation C-1 $ 112,00 C-2 $ 140.00 C-3 $ 171.00 C-4 $ 221.00 C-6 $ 259.00 8 Version 1 Trophy Club MUD No. 1 WWTP CIP and Hatch Garver Project No. 2301627 Improvements 100 of 113 151 TROPHY CLUB MUNICIPAL UTILITY DISTRICT September 20, 2023 Meeting Agenda Packet STAFF REPORT September 20, 2023 AGENDA ITEM: Consider and act regarding approval of work order agreement with Pipeline Analysis, LLC for professional engineering services related to the District wastewater collection system at a total cost not to exceed $200,680.00 and authorize the General Manager execute the necessary documents to implement Board action. DESCRIPTION: The District wastewater collection system has been divided into multiple study areas to be performed over an eleven -year period. This will be the fourth year of condition assessment efforts, which also coincide with the sanitary sewer overflow initiative (SSOI) executed with the Texas Commission on Environmental Quality (TCEQ) in September 2021 and expires September 2032. This work order includes smoke testing, cleaning, and CCTV of approximately 39,000 linear feet of pipe and inspection of approximately 150 manholes. Upon completion of this work order and subsequent years of studies, the results will assist in determining annual capital improvement funding, long-term asset management needs, implementation with our computerized maintenance management system (CMMS), further refinement of the geographic information system (GIS), and provide the necessary data needed for annual reporting to TCEQ. ATTACHMENT: Work Order No. 3 RECOMMENDATION: Approval of work order as stated above as part of FY 2024 budget. 101 of 113 September 20, 2023 Meeting Agenda Packet Sanitary Sewer Condition Assessment and Infiltration/Inflow Reduction Program Work Order No.3 Alan Four mentin General Manager afourinent in i of tc mu d .orq 1':682 ri00 F: E_7 1.01 0:312 June 5, 2023 PIPELINE ANALYSIS"` WASTEWATER COLLECTION ENGINEERS PIPELINE ANALYSIS LLC 1115 Main Street Garland, Texas 75040 800-637-0164 102 of 113 5511 TROPHY CLUB MUNICIPAL UTILITY UiSTRICT PURPOSE September 20, 2023 Meeting Agenda Packet WORK ORDER NO.3 SCOPE OF SERVICES The purpose of this project is to perform a phased systematic condition assessment of the District wastewater collection system to identity system defects that contribute to wet weather infiltration/inflow. Best management practice is to perform a condition assessment of the wastewater collection system assets followed by repairs and rehabilitation. Such inspections and testing will identify system defects that, if repaired early, will minimize rehabilitation costs, and extend the life of system assets. All work will follow the Pipeline Analysis LLC Master Service Agreement Contract No. 2021101801. This work will comply with sections of the TCEQ SSO Initiative agreement entered into on September 27, 2021. The District wastewater collection system consists of approximately 371,320 linear feet of mainline sewer and 1,600 manholes. Exhibit A presents the estimated cost for Work Order 3. The following summarizes the project tasks and approach to this phased project: Work Tasks TASK 100 MOBILIZATION Mobilize project team and coordinate startup. Establish personnel assignments and responsibilities. Inventory equipment needs and order expendable supplies. Review all relevant existing materials, previous reports, etc. developed for or by the District concerning this project, including, but not limited to, the following: 1. Previous studies for the service areas to be investigated 2. Sewer maps Deliverable: 1. Delivery of equipment and personnel 2. Work maps of Basin with delineated boundaries To Be Provided by the District: • Access for placement of equipment and personnel • Copies of all applicable reports, maps and historical data for the study area at no cost to ENGINEER • As -built drawings, sewer key maps, street plans, electronic aerial photographs if available and if requested at no cost to ENGINEER 103 of 113 2 TASK 200 MANHOLE/PIPE INSPECTION September 20, 2023 Meeting Agenda Packet The existing GIS maps will be used and updated during the course of field inspections. Field verification of the map will be necessary to resolve flow directions, "race track" connections, split flow locations, and identify assets not shown on the existing sewer maps. The updated maps will be used for subsequent field testing and inspections. Work Order 3 includes the inspection and map update of Basin 8 consisting of approximately 150 manholes and 39,000 linear feet of mainline sewer. Manholes can be a significant source of extraneous infiltration/inflow and thereby reduce system wet weather capacity. For this reason, each manhole within the District will be inspected and undergo a condition assessment. The data gathered during this phase of the project will be used to prioritize manholes for rehabilitation and establish the base data necessary to accurately determine mainline sewer rehabilitation alternatives and costs. Other important deliverables resulting from this work task are the updating of the collection system map, determination of debris levels in pipes and verification of pipe sizes. This information is critical in preparing subsequent rehabilitation plans, cleaning requirements to restore capacity and updating of the system maps. Inspection personnel will use digital cameras during the inspection of all manholes on this project. All photographs will be included in the field inspection computer database so that a permanent electronic record can be maintained. During inspection, each of the following types of information will be obtained to establish the condition and prioritize least cost repairs: 1. Manhole/Cleanout ID 2. Inspection Status — (including buried, could not locate, etc) 3. Address and GPS coordinates (sub -meter x,y) of manhole 4. Surface cover, grade, type of cover (paved, yard, etc.) 5. Material of construction — brick, concrete, etc. 6. Area and Internal photos of manhole 7. All incoming and outgoing pipe depths from rim to invert 8. All incoming and outgoing pipe digital photographs 9. Defects — Active, Evidence or No Infiltration/Inflow with digital photographs 10. Field corrections to collection system map Upon completion of the manhole inspection, a prioritized manhole rehabilitation report will be prepared that will include: • Documentation with summary of field observations • List of manholes/lines requiring immediate attention • Digital photos • Documentation for preparing manhole rehabilitation quantities • Field updated map(s) • Prioritized Manhole Repair Recommendations and Cost Estimates To Be Provided by the District: • Access (if requested) to manholes that are buried or could not be opened. 3 104 of 113 5511 TROPHY CLUB MUNICIPAL UTILITY UiSTRICT • Assistance in locating assets (if requested) Measurement of Payment: September 20, 2023 Meeting Agenda Packet Payment for this work task shall be a unit price for each manhole documented. Those manholes that are located, but buried or could not be opened will be noted and a list provided to the District. Manholes that could not be located using metal detectors or probes will be listed as Could Not Locate (CNL). CNL manholes will not be billed. Manholes located, but were buried or could not be opened will be billed. The District will provide replacement covers at no cost should a cover be broken while attempting opening. TASK 300 SMOKE TESTING OF STUDY AREA Smoke testing of Basin 8 will provide detailed information on wet weather inflow sources for the study area. In order to identify defects in the lines, non-toxic smoke will be forced into the sewer by high-capacity blowers. Data documentation includes measurements from two permanent points and will be sufficient to establish the location of each defect and determine the best repair method and priority. Color digital photographs will be taken to document each defect during the smoke test. The estimated total footage to be smoke tested is 39,000 linear feet. Forty-eight (48) hours prior to testing, door hangers will be used to notify residents. A telephone number will be provided for those individuals with questions or for anyone requiring special assistance. Each day the fire department will be notified of the crew location since smoke may enter homes through defective plumbing. To Be Provided by the District: • Review and approval of Notice to Residents • Letter of introduction to be carried by field crews • Previous smoke testing data, if any Final Report Deliverables: • Defects listing and database • Defect location sketch • Digital photographs • Smoke Notification Flyers and Notification of Residents • Priority ranking of defects (both private and public sector) • Repair methods and estimated costs 105 of 113 4 September 20, 2023 Meeting Agenda Packet TIZIOPli4 CLIPS F11;N1r1PAL L]iLLITY DISTRICT SMOKE TESTING NOTICE TO RESIDENT For the next few days, inspection crews will conduct a physical survey of the wastewater collection system. Pipeline Analysis will perform this study, which involves opening manholes in the streets and backyard utility easements. Information gained from this study will be used to repair and improve the wastewater collection system. One important task of the survey will be smoke testing of sewer lines to locate breaks and defects in the system. During this testing, white smoke will exit through vent pipes on the roofs of homes and through sewer line breaks. The smoke is non-toxic, leaves no residue, and creates no fire hazard. The smoke should not enter your home unless defective plumbing exists or drain traps are dry. If you have seldom -used drains, please pour a gallon of water in the drain to fill the drain trap. This procedure will help prevent the possibility of smoke entering your living areas through those drains. Field crews will perform testing of all sewers in the area. At no time will field crews have to enter your business or residence. Your cooperation is appreciated. Should you have any additional questions concerning this study or if you desire special assistance, please phone: 800-637-0164 PIPELINE ANALYSIS' WASTEWATER COLLECTION SYSTEM ENGINEERS 106 of 113 5 Task 400 Dye Flooding September 20, 2023 Meeting Agenda Packet Dye water testing can be anticipated to assist in locating specific defects during the evaluation. Non-toxic dye will be introduced as a powder or liquid. Cross -connections, roof drains and area drains, that are suspected of being connected to the sanitary sewer, may be positively identified using the dye tracer procedure. Field documentation and photographs will be used to record all findings. Internal inspection will determine the exact source of the `cross -connection' and establish the best repair option (i.e., point repair, direct connection, etc.). Five (5) dye flood locations are estimated. To Be Provided by the District: • Water for dye flooding at no cost to Engineer TASK 500 & 600 CLEANING AND CCTV Preparatory cleaning shall consist of hydraulic jet cleaning to facilitate the internal CCTV inspection. Preparatory cleaning will consist of not more than three passes of the jet hose (normal cleaning). Heavy cleaning to remove large deposits of debris is not included in this work task. Debris will be removed from the line and transported for disposal. CCTV investigation is found to be critical in establishing the mainline condition and best practical repair methods. The total footage in Basin 8 for cleaning and CCTV inspection is estimated to be 39,000 linear feet. The following information will be gathered: 1. Field forms, equipment, supplies and oversight QA/QC 2. Document findings. Data to include: a. Date inspected b. Line segment being inspected c. Project name d. Location (Address) e. Footage location from manhole f. Defect code and/or type and severity rating using the national Pipeline Assessment Certification Program (PACP) codes g. Pipeline surface cover 3. Review video and logs 4. Provide reports on of segments televised in electronic format 5. Summary of line segments cleaned and CCTV'd 6. Results of TV inspection provided on printed logs 7. Prepare prioritized mainline rehabilitation plan To Be Provided by the District: • Access to site of work for placement of equipment and personnel 6 107 of 113 TROPH4 CLUB MUNICIPAL UTILITY DISTRICT • Disposal site for any debris removed from the sewer system • Water for cleaning and dye testing at no cost to engineer Measurement of Payment: September 20, 2023 Meeting Agenda Packet Pipeline Analysis will invoice for the actual linear feet of sewer cleaned per the unit price specified in Exhibit A. In the case of CCTV, should the camera not be able to pass the entire length of the segment (due to protruding taps, roots, dropped joints, etc.), then an attempt will be made from the opposite direction (if possible). Where a reverse setup was attempted, then the entire segment length will be billed at the unit price specified. If a reverse setup cannot be performed, then the actual segment footage CCTV'd will be billed. TASK 700 ADMINISTRATION AND PROJECT MANAGEMENT This task includes internal project administration and oversight including scheduling, budget, quality assurance and control meetings and reporting. The project schedule will be reviewed and milestones for the completion of each task will be assigned. The project schedule will be reviewed and updated monthly to ensure that all tasks are completed in a timely and organized fashion. Management work items include: 1. Field crew supervision and project planning 2. Prepare monthly billings 3. Schedule equipment and order supplies Major system deficiencies that are identified during the field inspections that if corrected would result in significant reduction in 1/1 or is deemed to be of a safety concern will be recorded and forwarded as soon as possible to the District's designated project manager. Likewise, should the District undertake a major repair within the study area, they will notify ENGINEER to determine the impact on data analysis. Deliverables: 1. Monthly invoice 2. Status reports 3. Project schedule and updates To Be Provided by the District: • All reports or materials deemed necessary by ENGINEER and identified during the course of the project that is not specifically stated above will be provided at no additional cost to the ENGINEER 108 of 113 7 4 TROPH4 CLUB MUNICIPAL UTILITY DISTRICT TASK 800 DEFECT ANALYSIS/ REHABILITATION September 20, 2023 Meeting Agenda Packet This project will generate a considerable amount of data that will require proper entry and quality control. Data collection will include the following: 1. All collected data will be integrated into the project existing defect database and will be compatible with ArcGIS. 2. All collected defect data will be correlated between sources to address duplicate defects that were identified by different testing methods. Identify duplicate defects to ensure multiple rehabilitation methods are not recommended for the same defect. 3. Defect data will be presented graphically (data visualization). 4. Much of the baseline data required for rehabilitation decision is gathered during the normal course of field investigations. For example, "area photos" are taken of each manhole in the direction of the outgoing pipe. This photograph not only shows the location of the manhole but also provide data on the line cover and easement conditions. 5. Since private sector defects can contribute to excessive inflow, proper documentation for subsequent repair is important. Property owner address, photograph and sufficient information to document the defect will be recorded. Private sector defects will be prioritized and repair methods/costs established. 6. Rehabilitation recommendations will consider the best repair for the particular asset (manhole, pipeline, etc.) being rehabilitated. A long-term least -cost solution may have an initial higher cost, but provide a higher level of service and lower operating and maintenance cost. Supporting data will be provided on accompanying flash drive. To Be Provided by the District: • Complaint records and SSO database if requested TASK 900 FINAL SSES REPORT AND TCEQ ANNUAL PROGRESS REPORT Prepare and submit three (3) Final SSES Report and electronic data that includes the following: • Executive Summary • Description of all tasks • Manhole and pipe inspection summary/inventory • Manhole and pipeline defect summary • Service lateral defect summary • Smoke test data summary • CCTV data summary • Recommendations and Cost Estimates for Private and Public sector repairs Compile applicable information necessary to complete and submit the TCEQ SSOI Annual Progress Report (TCEQ Form 20595) on behalf of the District as stipulated in the SSOI Agreement Enforcement Case No. 59814. 109 of 113 8 TROPH4 CLUB MUNICIPAL UTILITY RiSTRIGT September 20, 2023 Meeting Agenda Packet Basin 8 Study Area Map Manhole Inspection, Smoke Testing and CCTV Inspection ■ ice■■■■■ ■ li LILLP TROPH4 CLUB MUNICIPAL UTILITY DISTRICT September 20, 2023 Meeting Agenda Packet Exhibit A Project Cost and Schedule Basin 8 Basin 8 Condition Assessment Task Description Estimated Quantity Unit Price Total 100 Mobilization L.S. L.S. $ 4,170.00 200 Manhole/Pipe Inspection -(100%) 150 $ 145.00 $ 21,750.00 300 Smoke Testing, Public Awareness, Data Entry & Analysis (100%) 39,000 $ 0.65 $ 25,350.00 400 Dye Flooding 5 $ 650.00 $ 3,250.00 500 Preparatory Cleaning 39,000 $ 1.80 $ 70,200.00 600 CCTV Inspection 39,000 $ 1.55 $ 60,450.00 700 Admin.,Project Mgt. L.S. L.S. $ 1,980.00 800 Defect Analysis/Rehab. L.S. L.S. $ 1,730.00 900 Database, Cost Estimates, Mapping, Final Reports L.S. L.S. $ 11,800.00 Total Not To Exceed $ 200,680.00 Task Description Month Est. Quantity 1 2 3 4 5 6 7 100 Mobilization 200 Manhole/Pipe Inspection -(100%) - 150 300 Smoke Testing, Public Awareness, Data Entry & Analysis (100%) 39,000 400 Dye Flooding 5 500 Preparatory Cleaning rr 39,000 600 CCTV Inspection 39,000 700 Admin.,Project Mgt. 800 Defect Analysis/Rehab. 900 Database, Cost Estimates, Mapping, Final Reports Anticipated notice to proceed February 2024 111 of 113 10 WORK ORDER MANAGER September 20, 2023 Meeting Agenda Packet The Work Order Manager will be the primary contact person during performance of this work and will provide the ENGINEER the basin study area(s) to be inspected. All correspondence or inquiries should be addressed to the Work Order Manager. This work task will be coordinated by: Alan Fourmentin General Manager 682-831-4600 afourmentintcmud.org APPROVAL The undersigned has reviewed and approved this Work Order and authorizes Pipeline Analysis LLC to perform the work as presented: Authorized by: Alan Fourmentin General Manager (Date) ACCEPTED BY The undersigned has reviewed and approved this Work Order. Pipeline Analysis is authorized to perform the scope of services in Work Order 3 as presented without exceeding contract not -to -exceed limits. Authorized by: Mattie A. Engels, P.E. Vice -President June 5, 2023 112 of 113 1.1 Trophy Club Municipal Utility District No. 1 October 2023 n 40 41 42 Sun Oct 1, 2023 8 15 43 22 44 29 Early voting 10-4 Mon 2 9 Tue Wed September 20, 2023 Meeting Agenda Paek�t rle Slaght Thu Fri 3 4 5 6 10 11 12 Sat 13 7 14 16 23 17 18 6:3Opm Board of Directors 19 24 25 26 Early Voting - November 7 General Election 8-5 Early voting 7-7 Printed on: 09/12/2023 10:31am 30 113 of 113 2 20 21 27 Early voting 7-7 28 4 OCentral Time US & Ca Powered by _ teamup