Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2023-0823 August 23, 2023 Regular Meeting Packet
ra TROPHY CLUB MUNICIPAL i UTILITY DISTRICT August 23, 2023 Regular Meeting Agenda Packet BOARD OF DIRECTORS REGULAR MEETING TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 100 MUNICIPAL DRIVE TROPHY CLUB, TEXAS 76262 Wednesday, August 23, 2023 6:30 P.M. Svore Municipal Boardroom REGULAR MEETING AGENDA PACKET CALL TO ORDER AND ANNOUNCE A QUORUM CITIZEN COMMENTS This is an opportunity for citizens to address the Board on any matter whether or not it is posted on the agenda. The Board is not permitted to take action on or discuss any comments made to the Board at this time concerning an item not listed on the agenda. The Board will hear comments on specific agenda items prior to the Board addressing those items. You may speak up to four (4) minutes or the time limit determined by the President or presiding officer. To speak during this item, you must complete the Speaker's form that includes the topic(s) of your statement. Citizen Comments should be limited to matters over which the Board has authority. REPORTS & UPDATES 1. Staff Reports a. Capital Improvement Projects b. Operations Reports c. Finance Reports d. Digital Platform Analytics Attachment: Staff Reports CONSENT AGENDA All matters listed as Consent Agenda are considered to be routine by the Board of Directors and will be enacted by one motion. There will not be a separate discussion of these items. If discussion is desired, that item will be removed from the consent agenda and will be considered separately. 2. Consider and act to approve the Consent Agenda. a. July 19, 2023, Regular Meeting Minutes b. August 2, 2023, Special Session Minutes c. August 16, 2023, Special Session Minutes d. Appointment of Wholesale Water Advisory Committee Attachments: July 19, 2023 Meeting Minutes August 2, 2023 Special Session Minutes August 16, 2023 Special Session Minutes Appointment of Wholesale Water Advisory Committee 1of65 August 23, 2023 Regular Meeting Agenda Packet REGULAR SESSION 3. Receive update from Strategic Committee. (Carr/Harper) 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. Attachment: Order No.2023-0823A 5. Consider and act to approve Resolution No. 2023-0823A Amending the Fiscal Year 2023 Budget. Attachment: Resolution No. 2023-0823A 6. Discussion and possible action regarding FY 2024 draft budget. Attachment: FY 2024 draft budget 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. Attachment: Proposed Tax Rate 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. 11. Items for future agendas: 12. Future Meeting date(s): September 20, 2023, at 6:30 p.m. Attachment: September 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 2 of 65 August 23, 2023 Regular Meeting Agenda Packet 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 65 Ft TROPHY C. u MUNICIPAL UTILITY DISTRICT August 23, 2023 Regular Meeting Agenda Packet Capital Improvement Projects • FY 2023 Water Line Project — Construction is substantially complete on Riviera Court awaiting new meter boxes and final adjustments to fire hydrants. The main on Sunset Drive has been installed; pressure testing and sampling is forthcoming. Preparation for the temporary water line is in progress on Berkshire Court and boring of the main between Sunset Drive and Straight Creek Court is scheduled to run concurrently. This project is scheduled to be completed by the end of November 2023. • Pump Station Improvement Project — A notice to proceed was issued to the contractor for the replacement of two (2) vertical turbine pumps, incorporation of variable frequency drives, and replacement of discharge header piping and valves within the high service pump station. The contractor is in the process of providing submittals and working to determine a schedule based on product deliveries. This project is tentatively scheduled to be completed by April 2024. • Lift Station Generators — The installation of the conduit is complete, and the contractor plans to begin constructing concrete pads within the next month. Delivery of the generators is scheduled for December 2023 with an anticipated completion date of April 2024. • FY 2023 Wastewater Improvements — Three additional point repairs were completed this month. Recoating and/or repairs to identified manholes has been completed. • Southlake emergency connection — An evaluation was performed to determine the feasibility of an emergency connection of the District water system to the City of Southlake water system. An emergency connection between the District and Southlake water systems is intended to allow the District to meet customer demands in emergency scenarios where the District requires supplemental water supply if the District's primary water supply being unavailable or the occurrence of significant pipe break(s). It is anticipated that the Southlake system can provide the service capacities to the District system at the emergency connection; however, Southlake plans to perform a Water Master Plan Update that will more accurately determine the impact of this emergency connection on their system, and further confirm that an emergency demand could be met. This is expected to be completed in the fall of 2023. 4 of 65 August 23, 2023 Regular Meeting Agenda Packet 160,000 140,000 120,000 Water - Billed -2023 / 100,000 80,000 60,000 40,000 20,000 0 `\ i 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 725,385 160,000 140,000 120,000 100,000 80,000 N'..-.4044.........._ 60,000 40,000 � \� Water - 2,11 - Pumped 22 -2023 / - 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 801,753 5 of 65 August 23, 2023 Regular Meeting Agenda Packet 7 6 c 5 0 To ▪ 4 0 3 2 0 Jul -22 Jul -22 ■ Min 3.915 ■ Max 7.100 Avg 5.748 Water Production Aug -22 Sep -22 Oct -22 Nov -22 Dec -22 Aug -22 Sep -22 Oct -22 2.348 7.325 4.704 1.889 5.277 3.948 1.842 5.00 3.662 Nov -22 1.401 2.57 1.834 Dec -22 1.115 Jan -23 Feb -23 Jan -23 Feb -23 1.225 0.878 2.72 2.51 2.35 1.657 1.759 1.479 Mar -23 Apr -23 Mar -23 Apr -23 0.920 4.60 2.780 0.999 2.52 1.731 May -23 Jun -23 Jul -23 May -23 1.730 5.73 Jun -23 2.628 5.95 3.125 4.079 Jul -23 3.277 7.08 5.266 1.950 1.750 1.550 1.350 1.150 0.950 0.750 Wastewater Treated Ju1-22 Aug -22 Sep -22 Oct -22 Nov -22 Dec -22 Jan -23 Feb -23 Daily Avg Flow Daily Max Flow -Daily Avg Max Mar -23 Apr -23 May -23 Jun -23 Jul -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 Jul -22 Aug -22 Sep -22 Oct -22 Nov -22 Dec -22 Jan -23 Feb -23 Mar -23 Apr -23 May -23 Jun -23 Jul -23 CBOD Avg CBOD Max -Daily Avg Max -Daily Max 6 of 65 August 23, 2023 Regular 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) Jul -22 Aug -22 Sep -22 Oct -22 Nov -22 Dec -22 TSS Avg Jan -23 Feb -23 TSS Max -Daily Avg Max -Daily Max Mar -23 Apr -23 May -23 Jun -23 Jul -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 Jul -22 Aug -22 Sep -22 Oct -22 Nov -22 Dec -22 Jan -23 Feb -23 Mar -23 Apr -23 May -23 Jun -23 Jul -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) Jul -22 Aug -22 Sep -22 Oct -22 Nov -22 Dec -22 Jan -23 Feb -23 Mar -23 Apr -23 May -23 Jun -23 Jul -23 NO3 Avg NO3 Max -Daily Avg Max -Daily Max 7 of 65 August 23, 2023 Regular Meeting Agenda Packet 8 of 65 Potential of Hydrogen (pH) 9 8.5 8 7.5 I 7 6.5 6 Jul -22 Aug -22 Sep -22 Oct -22 Nov -22 Dec -22 Jan -23 Feb -23 Mar -23 Apr -23 May -23 Jun -23 Jul -23 pH Min pH Max y pH Avg —Daily Avg Min —Daily Avg Max Dissolved Oxygen (DO) 9.0 8.5 8.0 7.5 7.0 6.5 6.0 J .1 Jul -22 Aug -22 Sep -22 Oct -22 Nov -22 Dec -22 Jan -23 Feb -23 Mar -23 Apr -23 May -23 Jun -23 Jul -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 1.0 6.3 2.0 1.0 1.0 2.0 1.0 1.0 1.0 2.0 3.0 1.0 0 Jul -22 Aug -22 Oct -22 Nov -22 Dec -22 Jan -23 Feb -23 Mar -23 Apr -23 May -23 Jun -23 Jul -23 *Sep -22 = E. Avg = E. Max Avg Max Max coli coli —Daily —Daily 8 of 65 August 23, 2023 Regular Meeting Agenda Packet Check Report Trophy Club Municipal Utility District No. 1 By Check Number Date Range: 07/01/2023 - 07/31/2023 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number Bank Code: Prosperity Bank -Prosperity Bank Payment Type: Regular 1500 American Water Works Assoc 07/19/2023 Regular 0.00 -900.00 9631 3197 BenefitMall 07/01/2023 Regular 0.00 52.00 9700 4033 Health Care Service Corporation 07/01/2023 Regular 0.00 22,147.36 9701 3216 M3 Networks 07/01/2023 Regular 0.00 1,091.00 9702 3115 Metlife Group Benefits 07/01/2023 Regular 0.00 2,301.06 9703 2631 Ace Pipe Cleaning, Inc. 07/19/2023 Regular 0.00 5,127.90 9704 2772 Allied Waste Industries 07/19/2023 Regular 0.00 18,405.72 9705 3127 Allied Welding Supply Inc. 07/19/2023 Regular 0.00 18.75 9706 1005 Atlas Utility Supply Co. 07/19/2023 Regular 0.00 66,500.00 9707 3299 Bickerstaff Heath Delgado Acosta LLP 07/19/2023 Regular 0.00 912.00 9708 2683 Charter Communications 07/19/2023 Regular 0.00 753.99 9709 1030 City of Fort Worth 07/19/2023 Regular 0.00 4,396.00 9710 2618 City of Fort Worth 07/19/2023 Regular 0.00 600.00 9711 3184 Dataprose LLC 07/19/2023 Regular 0.00 2,507.56 9712 2807 Denton Record -Chronicle 07/19/2023 Regular 0.00 69.70 9713 2497 DHS Automation Inc 07/19/2023 Regular 0.00 15,902.56 9714 1832 First Financial Bank 07/19/2023 Regular 0.00 22,840.70 9715 2606 Fisery Solutions LLC 07/19/2023 Regular 0.00 50.00 9716 3093 Four Man Furnace Inc. 07/19/2023 Regular 0.00 2,030.00 9717 2796 Garver 07/19/2023 Regular 0.00 19,657.90 9718 2635 Halff Associates Inc. 07/19/2023 Regular 0.00 332.76 9719 2783 JJ HVAC LLC 07/19/2023 Regular 0.00 3,510.00 9720 2785 Kleen Pipe, Inc 07/19/2023 Regular 0.00 15,473.00 9721 3278 Kyocera Document Solutions 07/19/2023 Regular 0.00 99.84 9722 3216 M3 Networks 07/19/2023 Regular 0.00 1,091.00 9723 4032 MAbelson LLC 07/19/2023 Regular 0.00 10,852.20 9724 3186 Member's Building Maintenance 07/19/2023 Regular 0.00 1,289.80 9725 1051 Millican Well Service, Llc 07/19/2023 Regular 0.00 31,999.05 9726 2983 NTTA 07/19/2023 Regular 0.00 16.21 9727 4019 Peterson Pump & Motor Service LLC 07/19/2023 Regular 0.00 640.00 9728 2752 R & D Electrical, Llc 07/19/2023 Regular 0.00 344.16 9729 3176 Rey -Mar Construction 07/19/2023 Regular 0.00 10,275.00 9730 3156 Southern Petroleum Lab Inc 07/19/2023 Regular 0.00 1,514.40 9731 3182 Strategic Government Resources 07/19/2023 Regular 0.00 135.00 9732 2440 Tarrant County Public Health Laboratory 07/19/2023 Regular 0.00 380.00 9733 2696 Texas Excavation Safety System 07/19/2023 Regular 0.00 148.20 9734 1001 Town of Trophy Club 07/19/2023 Regular 0.00 213,365.27 9735 1081 Tri County Electric 07/19/2023 Regular 0.00 614.05 9736 2798 Tyler Technologies Inc 07/19/2023 Regular 0.00 11,144.80 9737 2634 Valley Solvents & Chemicals 07/19/2023 Regular 0.00 2,669.78 9738 1058 Verizon Wireless 07/19/2023 Regular 0.00 570.87 9739 3280 Watts Ellison LLC 07/19/2023 Regular 0.00 2,969.67 9740 3271 Williams Heritage Investments Inc 07/19/2023 Regular 0.00 1,097.00 9741 3298 308 Construction LLC 07/31/2023 Regular 0.00 21,873.75 9742 2222 Aflac 07/31/2023 Regular 0.00 446.16 9743 2970 Air Mac 07/31/2023 Regular 0.00 3,155.00 9744 4030 Alpha Materials Handling Inc 07/31/2023 Regular 0.00 2,980.00 9745 1005 Atlas Utility Supply Co. 07/31/2023 Regular 0.00 20,500.00 9746 4018 BP Energy Holding Company LLC 07/31/2023 Regular 0.00 47,247.72 9747 1030 City of Fort Worth 07/31/2023 Regular 0.00 281,362.92 9748 2655 Core & Main LP 07/31/2023 Regular 0.00 3,577.08 9749 1737 DPC Industries Inc. 07/31/2023 Regular 0.00 1,946.35 9750 3258 Francotyp-Postalia, Inc. 07/31/2023 Regular 0.00 142.41 9751 8/16/2023 10:04:58 AM Page 1 of 4 9 of 65 Check Report Vendor Number 2796 1372 2635 1834 2943 2785 3132 3195 3186 2760 3179 1056 3156 3182 3283 3225 3280 Vendor Name Garver Hach Company Halff Associates Inc. Idexx Distribution, Inc JP Morgan Chase Bank NA Kleen Pipe, Inc Legal Shield Lou's Gloves Incorporated Member's Building Maintenance NDS Leasing NewGen Strategies & Solutions Office Depot Inc Southern Petroleum Lab Inc Strategic Government Resources TK Contractors Inc US Bank Voyager Fleet Systems Watts Ellison LLC Payment Date 07/31/2023 07/31/2023 07/31/2023 07/31/2023 07/31/2023 07/31/2023 07/31/2023 07/31/2023 07/31/2023 07/31/2023 07/31/2023 07/31/2023 07/31/2023 07/31/2023 07/31/2023 07/31/2023 07/31/2023 August 23, 2023 Regular Meeting Agenda Packet Date Range: 07/01/2023 - 07/31/2023 Discount Amount Payment Amount Number 0.00 22,889.20 9752 0.00 2,377.58 9753 0.00 300.00 9754 0.00 2,488.20 9755 0.00 8,600.54 9756 0.00 20,590.50 9757 0.00 15.95 9758 0.00 236.20 9759 0.00 1,289.80 9760 0.00 175.00 9761 0.00 2,082.50 9762 0.00 58.64 9763 0.00 2,042.40 9764 0.00 67.50 9765 0.00 14,560.00 9766 0.00 2,224.67 9767 0.00 2,969.67 9768 Payment Type Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Total Regular: 0.00 961,196.00 8/16/2023 10:04:58 AM Page 2 of 4 10 of 65 Check Report Vendor Number Payment Type: 3197 3113 3124 3197 3113 3124 Vendor Name Bank Draft BenefitMall TCDRS IRS Tax Payment BenefitMall TCDRS IRS Tax Payment Payment Type Regular Checks Manual Checks Voided Checks Bank Drafts EFT's August 23, 2023 Regular Meeting Agenda Packet Date Range: 07/01/2023 - 07/31/2023 Discount Amount Payment Amount Number Payment Date Payment Type 07/07/2023 07/31/2023 07/07/2023 07/21/2023 07/31/2023 07/21/2023 Bank Draft Bank Draft Bank Draft Bank Draft Bank Draft Bank Draft Total Bank Draft: Bank Code Prosperity Bank Summary Payable Payment Count Count 105 69 O 0 O 1 6 6 O 0 111 Discount Payment 0.00 962,096.00 0.00 0.00 0.00 -900.00 0.00 44,431.49 0.00 0.00 76 0.00 1,005,627.49 0.00 266.67 DFT0000085 0.00 9,269.45 DFT0000086 0.00 12,696.23 DFT0000087 0.00 266.67 DFT0000088 0.00 9,377.64 DFT0000089 0.00 12,554.83 DFT0000090 0.00 44,431.49 8/16/2023 10:04:58 AM Page 3 of 4 11 of 65 Check Report August 23, 2023 Regular Meeting Agenda Packet Date Range: 07/01/2023 - 07/31/2023 All Bank Codes Check Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 105 69 0.00 962,096.00 Manual Checks 0 0 0.00 0.00 Voided Checks 0 1 0.00 -900.00 Bank Drafts 6 6 0.00 44,431.49 EFT's 0 0 0.00 0.00 111 76 0.00 1,005,627.49 Fund Summary Fund Name Period Amount 996 MUD Consolidated Cash 7/2023 1,005,627.49 1,005,627.49 8/16/2023 10:04:58 AM Page 4 of 4 12 of 65 August 23, 2023 Regular Meeting Agenda Packet FY 2023 Combined Financials YTD as of 7/31/2023 YTD Revenues • YTD Expenses Adopted Budget vs YTD Actuals Revenues & Expenses $9,223,796 $9,320,643 $11,733,354 MIW $11,733,354 $2,510 $54,191 0% $1,284,739 14% $3,342,338 36% 0% $4,636,865 50% YTD Expenses By Departments YTD Expense- Water YTD Expense- WW YTD Expense- Admin YTD Expense- BOD • YTD Expense- Non Dept Water Budget vs Actual 140,000,000 120,000,000 100,000,000 80,000,000 60,000,000 88979,20 40,000,000 41,702,881 20,000,000 Water Consumption Budget vs Actual 101,683,000 52,466,000 49007000 49,082,000 134,083,000 108,707,084 79,654,000 70,083,700 104,510,967 46,119,000 34,501,000 54,266,627 41,572,326 36,351,669 Budget Consumption 33,732,116 34,390,563 —1—Actual Consumption 61,944,185 80,784,200 Oct Nov Dec Jan Feb Mar Apr May Jun Jul 1,000,000,000 900,000,000 800,000,000 700,000,000 600,000,000 500,000,000 400,000,000 300,000,000 200,000,000 100,000,000 0 Adopted Budget Water Consumption Vs Actual Water Consumption 808,128,121 955,279,167 Total Water Consumption • Budgeted Water Consumption • Projected Water Consumption Presented by: Finance Department $1,000,000 $900,000 $800,000 $700,000 703,717 Water Revenue Budget vs Actual $600,000 3664,453 8440,564 $438,585 $424,445 $404,42 $ $400,000 355,608 $395,319 $300,000 $395,329 $365,714 $500,000 $536,842 $200,000 $100,000 $0 $351,905 $335,705 $779,457 $597,742 $466,063 Budget Revenue --Actual Revenue $520,969 $952,641 $636,314 $792,444 Oct Nov Dec Jan Feb Mar Apr May Jun Jul $8,000,000 $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 $o Adopted Budget Water Revenue Vs Projected Water Revenue $6,710,979 $7,302,452 $4,070,848 Total Water Revenue $4,629,635 • Budgeted Water Revenue • Projected Water Revenue Net Budgeted Water Revenue Minus Budgeted Expenses • Net Projected Water Revenue Minus Projected Expenses 13 of 65 Trophy Club Municipal Utility District No. 1 Fund: 135 - MUD 1 General Fund CURRENT MONTH YEAR TO DATE August 23, 2023 Regular Meeting Agenda Packet Budget Variance Report As Of: 07/31/2023 ACTUAL BUDGETED VARIANCE ACTUAL BUDGETED VARIANCE ANNUAL BUDGET TOTAL REMAINING % REVENUE SUMMARY Revenue, Asset, Liability, & Equity 1,334,724.99 977,388.37 357,336.62 9,223,795.97 9,773,883.70 (550,087.73) 79 11,733,354.00 (2,509,558.03) 21 TOTAL REVENUE 1,334,724.99 977,388.37 357,336.62 9,223,795.97 9,773,883.70 (550,087.73) 79 11,733,354.00 (2,509,558.03) 21 EXPENSE SUMMARY Revenue, Asset, Liability, & Equity 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Water 582,944.08 547,941.66 (35,002.42) 4,636,864.66 5,479,416.60 842,551.94 70 6,577,932.00 (1,941,067.34) 30 Wastewater 255,211.18 290,877.74 35,666.56 3,342,338.10 2,908,777.40 (433,560.70) 96 3,491,931.00 (149,592.90) 4 Board of Directors 116.61 980.01 863.40 2,510.00 9,800.10 7,290.10 21 11,765.00 (9,255.00) 79 Administration 111,072.75 127,864.23 16,791.48 1,284,739.12 1,278,642.30 (6,096.82) 84 1,534,986.00 (250,246.88) 16 Non Departmental 0.00 9,724.44 9,724.44 54,191.25 97,244.40 43,053.15 46 116,740.00 (62,548.75) 54 TOTAL EXPENSE 949,344.62 977,388.08 28,043.46 9,320,643.13 9,773,880.80 453,237.67 79 11,733,354.00 2,412,710.87 21 REVENUE OVER/(UNDER) EXPENDITURE 385,380.37 0.29 385,380.08 (96,847.16) 2.90 (96,850.06) 0.00 (4,922,268.90) 8/17/2023 7:04:35 PM 14 of 65 Page 1 of 1 Trophy Club Municipal Utility District No. 1 Fund: 135 - MUD 1 General Fund Revenue Department: 000 - Revenue, 135-000-40000-000 135-000-40002-000 135-000-40015-000 135-000-40025-000 135-000-47000-000 135-000-47005-000 135-000-47025-000 135-000-47030-000 135-000-47035-000 135-000-47045-000 135-000-47070-000 135-000-49011-000 135-000-49016-000 135-000-49026-000 135-000-49035-000 135-000-49036-000 135-000-49075-000 135-000-49900-000 Total Departme Expense Department: 010 - Water 135-010-50005-000 135-010-50010-000 135-010-50016-000 135-010-50017-000 135-010-50020-000 135-010-50026-000 135-010-50027-000 135-010-50028-000 135-010-50029-000 135-010-50030-000 Asset, Liability, & Equity Property Taxes Property Taxes/Delinquent Property Taxes/P & I PID Surcharges Water Sewer Penalties Service Charges Plumbing Inspections Sewer Inspections TCCC Effluent Charges Interest Income Cell Tower Revenue Proceeds from Sale of Assets Prior Year Reserves GASB Reserves Oversize Meter Reimbursement Miscellaneous Income nt: 000 - Revenue, Asset, Liability, & Equity: Salaries & Wages Overtime Longevity Certification Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Social Security Taxes Total Revenue: July Budget 7,326.73 24.99 24.99 12,080.91 559,024.55 319,845.84 6,497.40 466.48 24.99 8.33 4,998.00 1,666.00 1,178.36 2,082.50 47,722.57 13,661.20 171.43 583.10 July Activity 464.76 90.76 57.07 0.00 952,641.07 311,697.28 9,392.35 700.00 0.00 0.00 18,440.72 36,975.48 4,000.00 265.50 0.00 0.00 0.00 0.00 Variance Favorable Percent (Unfavorable) Remaining -6,861.97 65.77 32.08 -12,080.91 393,616.52 -8,148.56 2,894.95 233.52 -24.99 -8.33 13,442.72 35,309.48 2,821.64 -1,817.00 -47,722.57 -13,661.20 -171.43 -583.10 -93.66% 263.19% 128.37% -100.00% 70.41% -2.55% 44.56% 50.06% -100.00% -100.00% 268.96% 2,119.42% 239.45% -87.25% -100.00% -100.00% -100.00% -100.00% August 23, 2023 Regular Meeting Agenda Packet YTD Budget 73,267.30 249.90 249.90 120,809.10 5,590,245.50 3,198,458.40 64,974.00 4,664.80 249.90 83.30 49,980.00 16,660.00 11,783.60 20,825.00 477,225.70 136,612.00 1,714.30 5,831.00 Monthly Budget Report Account Summary For Fiscal: Current Period Ending: 07/31/2023 YTD Activity 86,343.86 1,288.46 1,079.23 0.00 5,574,855.74 3,048,323.91 54,119.76 2,950.00 0.00 0.00 65,842.32 325,661.26 37,178.81 23,136.22 0.00 0.00 0.00 3,016.40 Variance Favorable Percent (Unfavorable) Remaining 13,076.56 1,038.56 829.33 -120,809.10 -15,389.76 -150,134.49 -10,854.24 -1,714.80 -249.90 -83.30 15,862.32 309,001.26 25,395.21 2,311.22 -477,225.70 -136,612.00 -1,714.30 -2,814.60 977,388.37 1,334,724.99 357,336.62 36.56% 17.85% 415.59% 331.86% -100.00% -0.28% -4.69% -16.71% -36.76% -100.00% -100.00% 31.74% 1,854.75% 215.51% 11.10% -100.00% -100.00% -100.00% -48.27% Total Budget 87,956.00 300.00 300.00 145,029.00 6,710,979.00 3,839,686.00 78,000.00 5,600.00 300.00 100.00 60,000.00 20,000.00 14,146.00 25,000.00 572,900.00 164,000.00 2,058.00 7,000.00 9,773,883.70 9,223,795.97 -550,087.73 -5.63% 11,733,354.00 977,388.37 1,334,724.99 33,914.67 31,426.49 1,416.10 1,022.27 498.38 0.00 299.88 200.00 4,264.96 3,917.87 6,890.74 8,444.05 406.17 350.34 62.05 71.29 199.92 290.69 2,240.02 1,978.56 8/17/2023 7:13:07 PM 15 of 65 357,336.62 36.56% 9,773,883.70 9,223,795.97 -550,087.73 -5.63% 11,733,354.00 2,488.18 393.83 498.38 99.88 347.09 -1,553.31 55.83 -9.24 -90.77 261.46 7.34% 27.81% 100.00% 33.31% 8.14% -22.54% 13.75% -14.89% -45.40% 11.67% 339,146.70 317,282.51 14,161.00 10,097.37 4,983.80 5,982.50 2,998.80 2,250.00 42,649.60 40,372.19 68,907.40 70,737.17 4,061.70 3,259.26 620.50 601.59 1,999.20 2,985.53 22,400.20 20,399.28 21,864.19 4,063.63 -998.70 748.80 2,277.41 -1,829.77 802.44 18.91 -986.33 2,000.92 6.45% 28.70% -20.04% 24.97% 5.34% -2.66% 19.76% 3.05% -49.34% 8.93% 407,139.00 17,000.00 5,983.00 3,600.00 51, 200.00 82,722.00 4,876.00 745.00 2,400.00 26,891.00 Page 1 of 7 August 23, 2023 Regular Meeting Agenda Packet Monthly Budget Report For Fiscal: Current Period Ending: 07/31/2023 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 135-020-50027-000 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 Dental Insurance Variance July July Favorable Percent YTD Budget Activity (Unfavorable) Remaining Budget 523.87 462.73 61.14 11.67% 5,238.70 104.95 1.83 103.12 98.26% 1,049.50 937.04 1,109.40 -172.36 -18.39% 9,370.40 33.32 0.00 33.32 100.00% 333.20 24.99 0.00 24.99 100.00% 249.90 19,142.34 61,611.86 -42,469.52 -221.86% 191,423.40 166.60 0.00 166.60 100.00% 1,666.00 416.50 805.59 -389.09 -93.42% 4,165.00 83.30 0.00 83.30 100.00% 833.00 208.25 161.23 47.02 22.58% 2,082.50 624.75 553.92 70.83 11.34% 6,247.50 166.60 680.00 -513.40 -308.16% 1,666.00 624.75 334.77 289.98 46.42% 6,247.50 19,013.22 23,242.44 -4,229.22 -22.24% 190,132.20 83.30 -900.00 983.30 1,180.43% 833.00 302.37 776.21 -473.84 -156.71% 3,023.70 78.13 0.00 78.13 100.00% 781.30 2,499.00 0.00 2,499.00 100.00% 24,990.00 0.00 0.00 0.00 0.00% 0.00 219,922.99 281,362.92 -61,439.93 -27.94% 2,199,229.90 1,041.25 1,200.00 -158.75 -15.25% 10,412.50 47,296.24 51,616.66 -4,320.42 -9.13% 472,962.40 208.25 0.00 208.25 100.00% 2,082.50 1,249.50 1,679.33 -429.83 -34.40% 12,495.00 362.77 0.00 362.77 100.00% 3,627.70 2,082.50 6,075.43 -3,992.93 -191.74% 20,825.00 1,666.00 0.00 1,666.00 100.00% 16, 660.00 7,247.10 87,000.00 -79,752.90 -1,100.48% 72,471.00 145,941.60 17,468.20 128,473.40 88.03% 1,459,416.00 2,655.77 0.00 2,655.77 100.00% 26,557.70 39.15 0.00 39.15 100.00% 391.50 13,547.82 0.00 13,547.82 100.00% 135,478.20 9,454.55 0.00 9,454.55 100.00% 94,545.50 YTD Activity 4,570.73 53.98 11,094.00 420.45 132.95 133,007.66 875.96 12,871.11 2,516.06 1,773.52 4,422.44 1,946.58 4,664.44 140,651.02 0.00 2,912.72 44.79 23,312.03 213.92 1,691,919.49 4,800.00 516,166.60 0.00 14,403.38 2,897.65 43,822.52 0.00 87,000.00 1,150,548.30 31,882.11 470.26 162,639.00 110,863.59 547,941.66 582,944.08 -35,002.42 -6.39% 5,479,416.60 25,794.26 17,192.16 8,602.10 33.35% 257,942.60 2,748.90 622.44 2,126.46 77.36% 27,489.00 336.11 0.00 336.11 100.00% 3,361.10 524.79 225.00 299.79 57.13% 5,247.90 3,471.19 2,164.75 1,306.44 37.64% 34,711.90 8,045.03 4,503.50 3,541.53 44.02% 80,450.30 452.06 166.52 285.54 63.16% 4,520.60 Variance Favorable (Unfavorable) 667.97 995.52 -1,723.60 -87.25 116.95 58,415.74 790.04 -8,706.11 -1,683.06 308.98 1,825.06 -280.58 1,583.06 49,481.18 833.00 110.98 736.51 1,677.97 -213.92 507,310.41 5,612.50 -43,204.20 2,082.50 -1,908.38 730.05 -22,997.52 16,660.00 -14,529.00 308,867.70 -5,324.41 -78.76 -27,160.80 -16,318.09 Percent Remaining Total Budget 12.75% 6,289.00 94.86% 1,260.00 -18.39% 11,249.00 -26.19% 400.00 46.80% 300.00 30.52% 229,800.00 47.42% 2,000.00 -209.03% 5,000.00 -202.05% 1,000.00 14.84% 2,500.00 29.21% 7,500.00 -16.84% 2,000.00 25.34% 7,500.00 26.02% 228,250.00 100.00% 1,000.00 3.67% 3,630.00 94.27% 938.00 6.71% 30,000.00 0.00% 0.00 23.07% 2,640,132.00 53.90% 12,500.00 -9.13% 567,782.00 100.00% 2,500.00 -15.27% 15,000.00 20.12% 4,355.00 -110.43% 25,000.00 100.00% 20,000.00 -20.05% 87,000.00 21.16% 1,752,000.00 -20.05% 31,882.00 -20.12% 470.00 -20.05% 162,639.00 -17.26% 113,500.00 4,636,864.66 842,551.94 15.38% 6,577,932.00 245,179.40 12,763.20 4.95% 309,655.00 12,585.66 14,903.34 54.22% 33,000.00 4,035.00 -673.90 -20.05% 4,035.00 3,900.00 1,347.90 25.68% 6,300.00 31,892.81 2,819.09 8.12% 41,671.00 54,841.44 25,608.86 31.83% 96,579.00 2,310.10 2,210.50 48.90% 5,427.00 8/17/2023 7:13:07 PM Page 2 of 7 16 of 65 August 23, 2023 Regular Meeting Agenda Packet Monthly Budget Report For Fiscal: Current Period Ending: 07/31/2023 Variance Variance July July Favorable Percent YTD YTD Favorable Percent Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget 135-020-50028-000 Vision Insurance 66.05 42.52 23.53 35.62% 660.50 478.46 182.04 27.56% 793.00 135-020-50029-000 Life Insurance & Other 199.92 188.36 11.56 5.78% 1,999.20 2,213.99 -214.79 -10.74% 2,400.00 135-020-50030-000 Social Security Taxes 1,823.02 1,080.81 742.21 40.71% 18,230.20 16,093.97 2,136.23 11.72% 21,885.00 135-020-50035-000 Medicare Taxes 426.32 252.78 173.54 40.71% 4,263.20 3,763.90 499.30 11.71% 5,118.00 135-020-50040-000 Unemployment Taxes 104.95 0.00 104.95 100.00% 1,049.50 43.66 1,005.84 95.84% 1,260.00 135-020-50045-000 Workman's Compensation 748.61 886.28 -137.67 -18.39% 7,486.10 8,862.80 -1,376.70 -18.39% 8,987.00 135-020-50060-000 Pre-emp Physicals/Testing 33.32 0.00 33.32 100.00% 333.20 150.00 183.20 54.98% 400.00 135-020-50070-000 Employee Relations 24.99 0.00 24.99 100.00% 249.90 1,167.97 -918.07 -367.37% 300.00 135-020-55080-000 Maintenance & Repairs 11,212.18 27,286.85 -16,074.67 -143.37% 112,121.80 186,097.03 -73,975.23 -65.98% 134,600.00 135-020-55081-000 Mainten & Repairs Collections 23,407.30 2,233.55 21,173.75 90.46% 234,073.00 222,416.45 11,656.55 4.98% 281,000.00 135-020-55085-000 Generator Maint. and Repair 749.70 0.00 749.70 100.00% 7,497.00 2,836.29 4,660.71 62.17% 9,000.00 135-020-55090-000 Vehicle Maintenance 383.18 0.00 383.18 100.00% 3,831.80 628.97 3,202.83 83.59% 4,600.00 135-020-55091-000 Veh Maintenance Collections 1,082.90 0.70 1,082.20 99.94% 10,829.00 4,821.91 6,007.09 55.47% 13,000.00 135-020-55105-000 Maintenance-Backhoe/SkidLoader 249.90 0.00 249.90 100.00% 2,499.00 2,435.44 63.56 2.54% 3,000.00 135-020-55120-000 Cleaning Services 166.60 161.22 5.38 3.23% 1,666.00 1,773.43 -107.43 -6.45% 2,000.00 135-020-55125-000 Dumpster Services 8,330.00 0.00 8,330.00 100.00% 83,300.00 74,350.57 8,949.43 10.74% 100,000.00 135-020-55135-000 Lab Analysis 3,332.00 4,399.20 -1,067.20 -32.03% 33,320.00 39,523.77 -6,203.77 -18.62% 40,000.00 135-020-60010-000 Communications/Mobiles 624.75 200.68 424.07 67.88% 6,247.50 3,577.04 2,670.46 42.74% 7,500.00 135-020-60020-000 Electricity 23,017.28 23,129.52 -112.24 -0.49% 230,172.80 199,978.82 30,193.98 13.12% 276,318.00 135-020-60080-000 Schools & Training 302.37 470.00 -167.63 -55.44% 3,023.70 2,560.75 462.95 15.31% 3,630.00 135-020-60100-000 Travel & per diem 86.46 0.00 86.46 100.00% 864.60 0.00 864.60 100.00% 1,038.00 135-020-60135-000 TCEQ Fees & Permits 999.60 0.00 999.60 100.00% 9,996.00 9,888.02 107.98 1.08% 12,000.00 135-020-60285-000 Lawn Equipment & Maintenance 1,332.80 1,300.00 32.80 2.46% 13,328.00 5,740.00 7,588.00 56.93% 16,000.00 135-020-60331-000 Interfund Transfer Out -Tax l&S 9,683.20 10,567.73 -884.53 -9.13% 96,832.00 105,677.30 -8,845.30 -9.13% 116,245.00 135-020-60332-000 Interfund Transfer Out -Rev l&S 57,637.85 62,902.88 -5,265.03 -9.13% 576,378.50 629,028.80 -52,650.30 -9.13% 691,931.00 135-020-60360-000 Furniture/Equipment < $5000 41.65 0.00 41.65 100.00% 416.50 0.00 416.50 100.00% 500.00 135-020-65005-000 Fuel & Lube 1,041.25 545.34 495.91 47.63% 10,412.50 8,772.70 1,639.80 15.75% 12,500.00 135-020-65010-000 Uniforms 367.76 411.93 -44.17 -12.01% 3,677.60 2,931.96 745.64 20.28% 4,415.00 135-020-65030-000 Chemicals 2,707.25 2,669.78 37.47 1.38% 27,072.50 22,109.42 4,963.08 18.33% 32,500.00 135-020-65031-000 Chemicals Collections 833.00 0.00 833.00 100.00% 8,330.00 6,002.80 2,327.20 27.94% 10,000.00 135-020-65045-000 Lab Supplies 2,748.90 5,177.83 -2,428.93 -88.36% 27,489.00 27,541.04 -52.04 -0.19% 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 74,553.50 63,588.15 10,965.35 14.71% 745,535.00 1,141,749.23 -396,214.23 -53.14% 895,000.00 135-020-69008-000 Short Term Debt -Principal 7,144.30 21,958.10 -14,813.80 -207.35% 71,443.00 85,762.59 -14,319.59 -20.04% 85,766.00 135-020-69009-000 Short Term Debt -Interest 233.32 882.60 -649.28 -278.28% 2,333.20 2,834.91 -501.71 -21.50% 2,801.00 135-020-69195-000 GASB Reserve for Replacement 13,809.22 0.00 13,809.22 100.00% 138,092.20 165,777.00 -27,684.80 -20.05% 165,777.00 Total Department: 020 - Wastewater: 290,877.74 255,211.18 35,666.56 12.26% 2,908,777.40 3,342,338.10 -433,560.70 -14.91% 3,491,931.00 Department: 026 - Board of Directors 135-026-50045-000 Workman's Compensation I= 1.24 0.62 50.00% li 12.4150.00% 135-026-60070-000 Dues & Memberships 62.47 0.00 62.47 100.00% 624.70 750.00 -125.30 -20.06% 750.00 135-026-60075-000 Meetings Ilr124.95 8.96 7.17% 1,249.50 1,218.80 2.46% ' 135-026-60080-000 Schools & Training 333.20 0.00 333.20 100.00% 3,332.00 535.00 2,797.00 83.94% 4,000.00 8/17/2023 7:13:07 PM Page 3 of 7 17 of 65 August 23, 2023 Regular Meeting Agenda Packet Monthly Budget Report For Fiscal: Current Period Ending: 07/31/2023 135-026-60100-000 135-026-60245-000 Travel & per diem Miscellaneous Expenses Total Department: 026 - Board of Directors: Variance Variance July July Favorable Percent YTD YTD Favorable Percent Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget 150 0.00 416.50 100.00% 4,165.00 0.00 4,165.00 100.004 5,000.04 41.65 0.00 41.65 100.00% 416.50 0.00 416.50 100.00% 500.00 980.01 116.61 863.40 88.10% 9,800.10 2,510.00 7,290.10 74.39% 11,765.00 Department: 030 - Administration 135-030-50005-000 Salaries & Wages 51,724.13 47,561.38 4,162.75 8.05% 517,241.30 485,751.81 31,489.49 Mfr. 620,938.00 135-030-50010-000 Overtime 166.60 117.81 48.79 29.29% 1,666.00 966.50 699.50 41.99% 2,000.00 135-030-50016-000 Longevity 201.83 0.00 201.83 100.00% 2,018.30 2,422.50 -404.20 -20.03% 2,423.00 135-030-50020-000 Retirement 6,149.53 5,694.51 455.02 7.40% 61,495.30 58,577.67 2,917.63 4.74% 73,824.00 135-030-50026-000 Medical Insurance 9,686.95 6,755.26 2,931.69 30.26% 96,869.50 64,153.06 32,716.44 33.77% 116,290.00 135-030-50027-000 Dental Insurance 504.04 241.51 262.53 52.09% 5,040.40 2,581.02 2,459.38 48.79% 6,051.00 135-030-50028-000 Vision Insurance 74.88 55.35 19.53 26.08% 748.80 518.16 230.64 30.80% 899.00 135-030-50029-000 Life Insurance & Other 199.92 512.54 -312.62 -156.37% 1,999.20 4,276.80 -2,277.60 -113.93% 2,400.00 135-030-50030-000 Social Security Taxes 3,229.70 2,843.83 385.87 11.95% 32,297.00 28,872.55 3,424.45 10.60% 38,772.00 135-030-50035-000 Medicare Taxes 755.36 665.09 90.27 11.95% 7,553.60 6,818.30 735.30 9.73% 9,068.00 135-030-50040-000 Unemployment Taxes 125.94 0.00 125.94 100.00% 1,259.40 58.55 1,200.85 95.35% 1,512.00 135-030-50045-000 Workman's Compensation 124.61 107.60 17.01 13.65% 1,246.10 1,076.00 170.10 13.65% 1,496.00 135-030-50060-000 Pre-emp Physicals/Testing 41.65 0.00 41.65 100.00% 416.50 198.45 218.05 52.35% 500.00 135-030-50070-000 Employee Relations 333.20 0.00 333.20 100.00% 3,332.00 2,563.57 768.43 23.06% 4,000.00 135-030-55030-000 Software & Support 10,970.61 4,126.76 6,843.85 62.38% 109,706.10 87,076.20 22,629.90 20.63% 131,700.00 135-030-55070-000 Independent Labor 1,249.50 67.50 1,182.00 94.60% 12,495.00 6,023.19 6,471.81 51.80% 15,000.00 135-030-55080-000 Maintenance & Repairs 3,332.00 4,951.16 -1,619.16 -48.59% 33,320.00 17,994.91 15,325.09 45.99% 40,000.00 135-030-55085-000 Generator Maint. and Repair 249.90 0.00 249.90 100.00% 2,499.00 0.00 2,499.00 100.00% 3,000.00 135-030-55120-000 Cleaning Services 999.60 967.35 32.25 3.23% 9,996.00 11,389.09 -1,393.09 -13.94% 12,000.00 135-030-55160-000 Professional Outside Services 6,250.83 2,082.50 4,168.33 66.68% 62,508.30 74,272.37 -11,764.07 -18.82% 75,040.00 135-030-55205-000 Utility Billing Contract 749.70 1,076.49 -326.79 -43.59% 7,497.00 6,874.91 622.09 8.30% 9,000.00 135-030-60005-000 Telephone 499.80 476.50 23.30 4.66% 4,998.00 4,745.90 252.10 5.04% 6,000.00 135-030-60010-000 Communications/Mobiles 249.90 73.11 176.79 70.74% 2,499.00 73.11 2,425.89 97.07% 3,000.00 135-030-60020-000 Electricity/Gas 2,029.93 1,508.92 521.01 25.67% 20,299.30 13,751.50 6,547.80 32.26% 24,369.00 135-030-60025-000 Water 416.50 438.33 -21.83 -5.24% 4,165.00 4,094.70 70.30 1.69% 5,000.00 135-030-60035-000 Postage 2,499.00 3,817.58 -1,318.58 -52.76% 24,990.00 21,839.81 3,150.19 12.61% 30,000.00 135-030-60040-000 Service Charges & Fees 7,913.50 16,246.28 -8,332.78 -105.30% 79,135.00 121,926.54 -42,791.54 -54.07% 95,000.00 135-030-60050-000 Bad Debt Expense 124.95 0.00 124.95 100.00% 1,249.50 48.65 1,200.85 96.11% 1,500.00 135-030-60055-000 Insurance 7,347.06 8,117.81 -770.75 -10.49% 73,470.60 81,178.10 -7,707.50 -10.49% 88,200.00 135-030-60070-000 Dues & Memberships 541.45 244.00 297.45 54.94% 5,414.50 6,804.55 -1,390.05 -25.67% 6,500.00 135-030-60079-000 Public Education 3,332.00 651.25 2,680.75 80.45% 33,320.00 25,132.58 8,187.42 24.57% 40,000.00 135-030-60080-000 Schools & Training 270.72 0.00 270.72 100.00% 2,707.20 277.17 2,430.03 89.76% 3,250.00 135-030-60100-000 Travel & per diem 132.28 0.00 132.28 100.00% 1,322.80 0.00 1,322.80 100.00% 1,588.00 135-030-60245-000 Miscellaneous Expenses 0.00 0.00 0.00 0.00% 0.00 88.00 -88.00 0.00% 0.00 135-030-60285-000 Lawn Equipment & Maintenance 416.50 469.67 -53.17 -12.77% 4,165.00 2,998.73 1,166.27 28.00% 5,000.00 135-030-60360-000 Furniture/Equipment < $5000 833.00 0.00 833.00 100.00% 8,330.00 13,052.82 -4,722.82 -56.70% 10,000.00 135-030-65010-000 Uniforms 44.14 0.00 44.14 100.00% 441.40 0.00 441.40 100.00% 530.00 135-030-65055-000 Hardware 699.72 0.00 699.72 100.00% 6,997.20 13,213.55 -6,216.35 -88.84% 8,400.00 8/17/2023 7:13:07 PM Page 4 of 7 18 of 65 August 23, 2023 Regular Meeting Agenda Packet Monthly Budget Report For Fiscal: Current Period Ending: 07/31/2023 135-030-65085-000 Office Supplies 135-030-65095-000 Maintenance Supplies 135-030-69005-000 Capital Outlays 135-030-69170-000 Copier Lease Installments 135-030-69195-000 GASB Reserve for Replacement Total Department: 030 - Administration: Department: 039 - Non Departmental 135-039-55045-000 Legal 135-039-55055-000 Auditing 135-039-55060-000 Appraisal 135-039-55065-000 Tax Admin Fees Total Department: 039 - Non Departmental: Total Expense: Total Revenues Total Fund: 135 - MUD 1 General Fund: Report Total: July Budget 499.80 333.20 0.00 333.20 2,227.10 127,864.23 5,414.50 2,815.54 1,077.90 416.50 9,724.44 July Activity 307.26 620.56 0.00 274.84 0.00 111,072.75 0.00 0.00 0.00 0.00 Variance Favorable (Unfavorable) 192.54 -287.36 0.00 58.36 2,227.10 0.00 16,791.48 5,414.50 2,815.54 1,077.90 416.50 9,724.44 Percent Remaining 38.52% -86.24% 0.00% 17.52% 100.00 % 13.13% 100.00% 100.00% 100.00% 100.00% 100.00% YTD Budget 4,998.00 3,332.00 0.00 3,332.00 22,271.00 1,278,642.30 54,145.00 28,155.40 10,779.00 4,165.00 97,244.40 YTD Activity 3,559.32 5,122.78 74,952.60 2,677.10 26,736.00 1,284,739.12 18,494.00 22,551.10 9,100.15 4,046.00 Variance Favorable (Unfavorable) 1,438.68 -1,790.78 -74,952.60 654.90 -4,465.00 -6,096.82 35,651.00 5,604.30 1,678.85 119.00 Percent Remaining 28.79% -53.74% 0.00% 19.65% -20.05% -0.48% 54,191.25 43,053.15 Total Budget 6,000.00 4,000.00 0.00 4,000.00 26,736.00 1,534,986.00 65.84% 65,000.00 19.90% 33,800.00 15.58% 12,940.00 2.86% 5,000.00 44.27% 116,740.00 977,388.08 949,344.62 28,043.46 2.87% 9,773,880.80 9,320,643.13 453,237.67 4.64% 11,733,354.00 977,388.37 1,334,724.99 357,336.62 36.56% 9,773,883.70 9,223,795.97 -550,087.73 -5.63% 11,733,354.00 0.29 385,380.37 385,380.08 2.90 -96,847.16 -96,850.06 0.00 0.29 385,380.37 385,380.08 2.90 -96,847.16 -96,850.06 0.00 8/17/2023 7:13:07 PM Page 5 of 7 19 of 65 August 23, 2023 Regular Meeting Agenda Packet Monthly Budget Report For Fiscal: Current Period Ending: 07/31/2023 Group Summary Variance Variance July July Favorable Percent YTD YTD Favorable Percent Departmen... Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget Fund: 135 - MUD 1 General Fund Revenue 000 - Revenue, Asset, Liability, & Equity 977,388.37 1,334,724.99 357,336.62 36.56% 9,773,883.70 9,223,795.97 -550,087.73 -5.63% 11,733,354.00 Total Revenue: 977,388.37 1,334,724.99 357,336.62 36.56% 9,773,883.70 9,223,795.97 -550,087.73 -5.63% 11,733,354.00 Expense 010 - Water 020 - Wastewater 026 - Board of Directors 030 - Administration 039 - Non Departmental Total Expense: Total Revenues Total Fund: 135 - MUD 1 General Fund: Report Total: 547,941.66 582,944.08 -35,002.42 -6.39% 5,479,416.60 4,636,864.66 842,551.94 15.38% 6,577,932.00 290,877.74 255,211.18 35,666.56 12.26% 2,908,777.40 3,342,338.10 -433,560.70 -14.91% 3,491,931.00 980.01 116.61 863.40 88.10% 9,800.10 2,510.00 7,290.10 74.39% 11,765.00 127,864.23 111,072.75 16,791.48 13.13% 1,278,642.30 1,284,739.12 -6,096.82 -0.48% 1,534,986.00 9,724.44 0.00 9,724.44 100.00% 97,244.40 54,191.25 43,053.15 44.27% 116,740.00 977,388.08 949,344.62 28,043.46 2.87% 9,773,880.80 9,320,643.13 453,237.67 4.64% 11,733,354.00 977,388.37 1,334,724.99 357,336.62 36.56% 9,773,883.70 9,223,795.97 -550,087.73 -5.63% 11,733,354.00 0.29 385,380.37 385,380.08 2.90 -96,847.16 -96,850.06 0.00 0.29 385,380.37 385,380.08 2.90 -96,847.16 -96,850.06 0.00 8/17/2023 7:13:07 PM Page 6 of 7 20 of 65 August 23, 2023 Regular Meeting Agenda Packet Monthly Budget Report For Fiscal: Current Period Ending: 07/31/2023 Fund Summary Variance Variance July July Favorable Percent YTD YTD Favorable Percent Fund Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget 135 - MUD 1 General Fund 0.29 385,380.37 385,380.08 2.90 -96,847.16 -96,850.06 0.00 Report Total: 0.29 385,380.37 385,380.08 2.90 -96,847.16 -96,850.06 0.00 8/17/2023 7:13:07 PM Page 7 of 7 21 of 65 Department Trophy Club Municipal Utility District No. 1 122 - Trophy Club MUD Fire Dept. Asset 000 - Revenue, Asset, Liability, & Equity 1,025,241.94 Liability 000 - Revenue, Asset, Liability, & Equity Equity 000 - Revenue, Asset, Liability, & Equity 135 - MUD 1 General Fund August 23, 2023 Regular Meeting Agenda Packet Balance Sheet Funds 122 - 528 Account Summary As Of 07/31/2023 137 - MUD 1 519 - 2016 Rev 520 - Revenue 528 - 2015 Consolidated Bond Const -SWIFT Bond 16" Revenue Bond GASB Waterline Reserve Fund 10,991,121.70 3,422,146.58 810, 625.28 1,168, 658.63 Total 934,030.46 18,351,824.59 Total Asset: 1,025,241.94 10,991,121.70 3,422,146.58 810,625.28 1,168,658.63 934,030.46 18,351,824.59 43,046.49 640,430.79 0.00 81,691.15 0.00 0.00 765,168.43 Total Liability: 43,046.49 640,430.79 0.00 81,691.15 0.00 0.00 765,168.43 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,452,937.21 9,223,795.97 436,572.00 23,403.93 45,749.91 33,426.05 11,215,885.07 1,152,545.33 9,320,643.13 0.00 0.00 216,188.21 0.00 10,689,376.67 300,391.88 982,195.45 1,025,241.94 -96,847.16 10,350,690.91 10,991,121.70 436,572.00 3,422,146.58 3,422,146.58 23,403.93 728,934.13 810,625.28 -170,438.30 1,168,658.63 1,168,658.63 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 33,426.05 934,030.46 934,030.46 526,508.40 17,586,656.16 18,351,824.59 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 8/17/2023 9:00:56 PM 22 of 65 Page 1 of 1 Department Asset Liabi Equi Trophy Club Municipal Utility District No. 1 533 - MUD 1 I&S 534 - 2015 Consolidated Revenue Bond I&S 000 - Revenue, Asset, Liability, & Equity 985,940.44 Total Asset: 985,940.44 lity 000 - Revenue, Asset, Liability, 8t Equity Total Liability: 30,652.23 ty 000 - Revenue, Asset, Liability, & Equity Total Total Beginning Equity: Total Revenue Total Expense Revenues Over/Under Expenses Total Equity and Current Surplus (Deficit): Total Liabilities, Equity and Current Surplus (Deficit): 30,652.23 4,145.11 535 - 2016 Rev Bond l&S-SWIFT 494, 549.21 233,554.30 536 - 2019 Rev Bond I&S- W&WW System August 23, 2023 Regular Meeting Agenda Packet Balance Sheet I&S Funds 533 - 536 Account Summary As Of 07/31/2023 Total 243,354.40 1,957,398.35 494, 549.21 233, 554.30 243,354.40 1,957,398.35 0.00 0.00 0.00 30,652.23 0.00 0.00 0.00 30,652.23 27,958.35 6,554.77 1,429.17 40,087.40 4,145.11 1,025,721.93 74,578.83 27,958.35 558,909.61 92,318.75 6,554.77 1,429.17 254,768.78 27,769.25 349,193.98 107,268.75 40,087.40 2,188,594.30 301,935.58 951,143.10 955,288.21 985,940.44 466,590.86 494,549.21 494,549.21 226,999.53 233,554.30 233,554.30 241,925.23 243,354.40 243,354.40 1,886,658.72 1,926,746.12 1,957,398.35 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 l&S Revenue Bond payment from Fund 533 3/1 & 9/1 Revenue Bond payments (Interest and Principal) Monthly bank interest 8/17/2023 9:02:04 PM 23 of 65 Page 1 of 1 August 23, 2023 Regular Meeting Agenda Packet CASH STATUS AS OF JULY 2023 TexPool 0 & M (XXXXX0002)-Fire Operating Cash Restricted - Unable to be spent Unrestricted- Available for spending Total in Accounts (Restricted & Unrestricted) 1 35-1 02 50 TexPool 0 & M (XXXXX0002)-General Fund Operating *** Prosperity Bank (XXX8701) Fire Operating $0 $2,531,256 $2,531,256 1 35-1 03 00 Prosperity Bank (XXX8701) General Fund Operating * $140,855 $4,831,809 $4,972,664 1 35-1 03 05 Prosperity Bank Reserve -Savings Acct (XXXXX7724) $1,923,327 $0 $1,923,327 135-11100 Petty Cash Administration $0 $150 $150 1 35-1 11 50 Petty Cash Utility Billing $0 $450 $450 1 37-1 02 50 TexPool 0 & M (XXXXX0002) GASB Replacement $3,422,147 $0 $3,422,147 51 9-1 02 50 Texpool Revenue Bond Construction (XXXXX015) SWIFT $0 $0 $0 51 9-111 55 Cash -Bond Escrow Bank of Texas (SWIFT) $810,625 $0 $810,625 520-1 02 50 Texpool Revenue Bond Water & Waste Water Systems 2019 (XXXXX018) $1,168,659 $0 $1,168,659 520-1 03 00 Prosperity Bank Construction Water & Waste Water Systems 2019 $0 $0 $0 528-1 02 50 TexPool Revenue Bond Reserve (XXXXX014) WWTP Improvements $934,030 $0 $934,030 533-1 02 50 TexPool Tax I & S (XXXXX0003) $1,003,104 $0 $1,003,104 533-1 03 00 Prosperity Bank (XXX8701) Tax I&S $0 $0 $0 534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements $494,549 $0 $494,549 535-10250 Texpool Revenue I & S (XXXXX017) SWIFT $233,554 $0 $233,554 536-10250 TexPool Revenue I & S (XXXXX020) Water & Waste Water Systems $243,354 $0 $243,354 $7,363,664 $17,737,869 Amount available in cash for spending (MUD Accounts) *7/31/2023 Customer Water Deposits $140,855 Fire Department Cash $7,363,664 1 22-1 02 50 TexPool 0 & M (XXXXX0002)-Fire Operating Cash $0 $911,454 $840,013 1 22-1 03 00 Prosperity Bank (XXX8701) Fire Operating $0 $191,028 $191,028 $0 $1,102,482 $1,031,041 Amount available in cash for spending (Fire Department Accounts) $1,102,482 General Fund 135 Available $ 4,831,809 Prosperity General Fund $ 2,531,256 Texpool General Fund $ 600 Petty Cash Total General Fund 135 Available for Spending $ 7,363,664 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 $ (96,847) Total Nonspendable, Assigned & Committed Fund Balances - General Fund 135 $10,350,691 24 of 65 ebills Bills Mailed Bank Draft Credit Card Draft Online Payments Late Notices Disconnects Connections MUD Connections PID August 23, 2023 Regular Meeting Agenda Packet July Utility Billing Report Fiscal Year 2022 - 2023 July 2022 August 2022 September 2022 October 2022 November 2022 December 2022 January 2023 February 2023 March 2023 April 2023 May 2023 June 2023 July 2023 1,592 1,629 1,654 1,667 1,710 1,746 1,765 1,777 1,773 1,767 1,794 1,766 1,750 3,872 3,850 3,832 3,822 3,801 3,768 3,741 3,751 3,744 3,743 3,734 3,755 3,749 697 704 703 706 711 630 606 599 599 590 588 589 585 1,471 1,484 1,481 1,501 1,494 2,251 2,540 2,719 3,016 2,998 2,754 3,134 3,101 1,220 1,170 1,203 1,159 1,049 387 310 326 337 0 0 0 547 413 289 290 327 327 7 5 2 0 4 0 0 0 0 8 9 9 13 3401 3398 3399 3399 3399 3399 3394 3394 3394 3394 3394 3395 3395 1443 1443 1444 1444 1444 1444 1444 1443 1443 1443 1443 1443 1443 July 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 65 August 23, 2023 Regular Meeting Agenda Packet tcmud.org Website Overview May 1 - July 31, 2023 Traffic: Website Users 3,900 + New Users 3,500 t Average Engagement Time Om 53s + Acquisition: Direct 2,938 Sessions/ 1,966 Users Organic Search 2,720 Sessions/ 1,828 Users Referral 185 Sessions/ 93 Users Organic Social 56 Sessions/ 30 Users Pages: Home 5,133 Views/ 2,974 Users Your Bill 757 views/ 535 Users Watering Schedule 339 views/ 241 Users Request Forms 306 Views/ 201 Users Start Stop Service 253 Views/ 158 Users Agendas/Meetings 174 views/ 77 users Water Service 170 Views/ 143 Users Service Area Map 148 Views/ 121 Users 26 of 65 August 23, 2023 Regular Meeting Agenda Packet Community Outreach Program Performance Overview May 1 - July 31, 2023 Facebook Page Reach Posts Engagements Page Visits Facebook reach 0 2,060 28.6% 600 400 200 0 2,060 Accounts (Down 28.6% compared to the prior 3 month period) 12 (Same as prior 3 month period) 53 (Down 79.1% compared to the prior 3 month period) 773 (Down 4.2% compared to the prior 3 month period) Daily Cumulative May 6 May 16 May 26 Jun 5 ■ Facebook reach May 1 — Jul 31 Jun 15 Jun 25 ■ Facebook reach Jan 29 — Apr 30 Jul 5 Screenshot from Meta Business Suite dashboard for the Trophy Club Municipal Utility District No.1 Facebook Page 27 of 65 Jul 15 Jul 25 N August 23, 2023 Regular Meeting Agenda Packet Posted: July 12, 2023 at 12:24 PM Performance Reach 0 Engagements 0 Negative interactions 0 Total Reactions Total 23 0 0 Organic 23 (100%) Comments 0 Unique Paid 0 (0%) Shares 0 View details Trophy Club Municipal Utility District No. 1 July 12 -Q B You may have seen mention of this in your last bill: The 2022 Annual Drinking Water Quality Report (CCR) is now available. This report is a summary of the quality of the water we provide to our customers. In it, you'll find detailed information from specific tests conducted to monitor for certain federally monitored contaminants. You'll find in this report that our drinking water meets or exceeds all federal (EPA) drinking water requirements. To view the report, click this link di. http:ffwww.tcmud.org/2022_ccr 2022 ANNUAL DRINKING WATER QUALITY REPORT THE 2022 ANNUAL ORINKING WATER QUALITY REPORT (CCR) IS NOW AVAILABLE. Screenshots from Meta Business Suite dashboard for the Trophy Club Municipal Utility District No.1 Facebook Page 28 of 65 0 August 23, 2023 Regular Meeting Agenda Packet Posted: July 13, 2023 at 7:00 PM Performance Reach 0 Engagements 0 Negative interactions O Total Reactions 33 0 0 Organic 33 (100%) Comments 0 Unique Paid 0 (0%) Shares 0 View details Trophy Club Municipal Utility District No. 1 July 13-Q iirr ACTIVITY ANNOUCEMENT In our efforts to conserve water and to save money by proactively maintaining our water system, we have scheduled a comprehensive leak detection survey. This survey will commence on July 17th and the area of activity is shown on this map. If you have any questions about the leak detection survey, or about your water service in general, you can always reach us by phone or email. ,f 602-831-4600 • info@tcmud.org ACTIVITY ANOUNCEMENT LEAK DETECTION SURVEY *wi *ritithih, It • tato LEAK DETECTION SURVEY AREA 13.11 TROPHY CLUB Lr 4, •jI.airgiVe via bilk% Screenshots from Meta Business Suite dashboard for the Trophy Club Municipal Utility District No.1 Facebook Page 29 of 65 0 Posted: July 19, 2023 at 7:00 PM Performance Reach 0 Engagements 0 Total Reactions 32 3 Organic 32 (100%) Comments Paid 0 (0%) Shares View details August 23, 2023 Regular Meeting Agenda Packet Negative interactions Total 0 0 Unique 0 Trophy Club Municipal Utility District No. 1 July19 at 7:00 PM •Q 2 CELEBRATE WITH US! Your Trophy Club Municipal Utility District No. 1 administrative team has eamed the GFDA Distinguished Budget Presentation Award (again). This award represents a significant achievement, and reflects the commitment of the governing body and staff to meeting the highest principles of governmental budgeting. What this means for you, is that you can rest assured knowing that our team is working hard to provide you with the best water service possible, with the highest level of fiscal responsibility. For more info about our budget, visit the Financial Transparency page of our website:Ohttps f)tcmud.orgifinancial-transparency And if you want to reach nut and give us a pat on the back, or ask any questions about your water service, you can call or email us at any time. 682-831-4600 infc@tcmud.org r GP) OOVFRJ umt O NAPCt Otncens AtsoCNnc I Distinguished Budget Presentation Award Trophy Club Muaieipit Utility District No. 1 Texas Pa' r Imal r.. ti9....x [Mafeeil. lsa .tg51apatmai Screenshots from Meta Business Suite dashboard for the Trophy Club Municipal Utility District No.1 Facebook Page 30 of 65 0 August 23, 2023 Regular Meeting Agenda Packet Posted: July 26, 2023 at 7:00 PM Performance Reach 0 Engagements 0 Negative interactions 42 Reactions 1 0 Organic 42 (100%) Comments 0 Unique Paid 0 (0%) Shares 0 View details Trophy Club Municipal Utility District No. 1 July 26 at 7:00 PM • Did you know that a leaking toilet can waste 200 gallons of water every day? That's not just bad for your wallet but also for our precious water resources! ♦: To help you conserve water and save money, we've put together a simple guide on how to check your toilet for leaks: Step 1: Toilet Tab or Food Coloring Test ®Open the toilet tank and add a toilet tab or few drops of food coloring into the water. Wait for about 10 minutes without flushing. If you see the colored water seeping into the bowl, you have a leak. If you would like a toilet lab, just stop by our office and ask for one!® Step 2: Check the Toilet Components *Examine the flapper, fill valve, and flush valve. Make sure they're functioning properly and not causing water to leak. If you notice any issues, consider replacing the faulty parts. Step Sr Seek Professional Help If you're unsure about performing these checks or replacing faulty parts, don't hesitate to contact a plumber. They can help identify and fix any leaks efficiently. By taking a few minutes to check your toilet far leaks, you can play a vital role in conserving water and protecting our environment. Remember, every drop counts! Thank you for being water -conscious and helping us build a sustainable future together. CONSERVATION TIP HOW TO CHECK YOUR TOILETS FOR WATER -WASTING LEAKS THE AVERAGE LEAKY TOILET CAN WASTE 200 GALLONS OF WATER PER DAY! TROPHY CLUB ' MUNICIPAL UTILITY DISTRICT sa- Screenshots from Meta Business Suite dashboard for the Trophy Club Municipal Utility District No.1 Facebook Page 31 of 65 0 August 23, 2023 Regular Meeting Agenda Packet REGULAR MEETING MINUTES TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 BOARD OF DIRECTORS July 19, 2023, at 6:30 p.m. Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in regular session on July 19, 2023, at 6:30 p.m., in the Boardroom of the Administration Building, 100 Municipal Drive, Trophy Club, Texas 76262. The meeting was held within the boundaries of the District and was open to the public. STATE OF TEXAS § COUNTIES OF DENTON AND TARRANT BOARD MEMBERS PRESENT: Kevin R. Carr President Ben Brewster Vice President Doug Harper Secretary/Treasurer William C. Rose Director BOARD MEMBERS ABSENT: Tracey Hunter Director STAFF PRESENT: Alan Fourmentin Laurie Slaght Mike McMahon Steven Krolczyk Emily Rodgers General Manager District Secretary Operations Manager Finance Manager General Legal Counsel § CALL TO ORDER AND ANNOUNCE A QUORUM President Carr announced the date of July 19, 2023, called the meeting to order and announced a quorum present at 6:31 p.m. CITIZEN COMMENTS There were no citizens wishing to speak. REPORTS & UPDATES 1. Staff Reports a. Capital Improvement Projects b. Operations Reports c. Finance Reports • Quarterly Tax Collections 3rd Quarter • Quarterly Investment Report 3rd Quarter d. GFOA's Distinguished Budget Presentation Award e. Digital Platform Analytics • Facebook Monthly • Website Quarterly f. Employee Recognition 32 of 65 August 23, 2023 Regular Meeting Agenda Packet General Manager Alan Fourmentin presented the monthly reports and answered questions related thereto. The Board recognized Operations Manager, Mike McMahon, for his 25 -years of service to the District and Finance Manager Steven Krolczyk for receiving GFOA's Distinguished Budget Presentation Award for the FY 2022 budget. REGULAR SESSION 2. Consider and act to approve the June 21, 2023, Regular Meeting Minutes. Motion made by Director Rose and seconded by Director Carr to approve the June 21, 2023, Regular Meeting Minutes. Motion carried unanimously. 3. Receive update from the Strategic Committee. (Carr/Harper) Director Carr provided the Board with an update regarding the Strategic Committee. 4. Receive update from the Budget Committee. (Brewster/Harper) Motion made by Director Carr and seconded by Director Brewster to table this item and bring it back for open discussion in a workshop session to be held before the regular meeting at the August regular meeting. For: Carr, Brewster, and Harper Opposed: Rose Absent: Hunter Item passes 3-1-0 5. Consider and act regarding approval of Contract No. 2023071901 for High Service Pump Station and Piping Improvements as part of FY 2023 Capital Improvement Projects and authorize the General Manager to execute the necessary documents to implement board action. Motion made by Director Rose and seconded by Director Harper to approve Contract No. 2023071901 for High Service Pump Station and Piping Improvements as part of FY 2023 Capital Improvement Projects to Rey -Mar Construction for an amount not to exceed $2,124,400 and authorize the General Manager to execute the necessary documents to implement board action. Motion carried unanimously. 6. Consider and act to terminate contract with Utility Services Co. Inc. for Water Tank Maintenance effective November 1, 2023. Motion made by Director Brewster and seconded by Director Harper to terminate the contract with Utility Services Co. Inc., for Water Tank Maintenance effective November 1, 2023. 33 of 65 August 23, 2023 Regular Meeting Agenda Packet Motion carried unanimously. 7. Consider and act to adopt Order No. 2023-0718A declaring the following operations equipment and vehicle to be surplus property of the District and authorize staff to sell such property. Motion made by Director Harper and seconded by Director Brewster to adopt Order No. 2023-0718A declaring the operations vehicles to be surplus property of the District and authorizes staff to sell such property. Motion carried unanimously 8. Discussion and possible action regarding Amended and Restated Interlocal Cooperation Agreement for Administration of Fire Protection Services with Town of Trophy Club. Director Carr requested to move agenda item 8. to Executive Session for discussion. With no objection, the item was so moved. The Board convened into Executive Session at 7:35 p.m. EXECUTIVE SESSION 9. Pursuant to Section 551.071 of the Texas Open Meetings Act, the Board may consult with its attorney in Executive Session on a matter in which the duty of the attorney to the Governmental Body under the Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflicts with the Open Meetings Act or to seek advice of counsel on legal matters involving pending or contemplated litigation or settlement offers: a. Consult with legal counsel to secure legal advice concerning joint strategic planning with the Town of Trophy Club. b. 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. The Board reconvened into Regular Session at 9:30 p.m. REGULAR SESSION 10. Consider and act regarding items discussed in Executive Session, including joint strategic planning with the Town of Trophy Club and Amended and Restated Interlocal Cooperation Agreement for Administration of Fire Protection Services between the District and the Town of Trophy Club. No action taken 11. Items for future agendas: 34 of 65 August 23, 2023 Regular Meeting Agenda Packet 12. Set future Meeting dates - August 2, 2023, Budget Workshop at 4:30 p.m. August 23, 2023, at 6:30 p.m. ADJOURN President Carr called the meeting adjourned at 9:30 p.m. Kevin R. Carr, President Doug Harper, Secretary/Treasurer Laurie Slaght, District Secretary 35 of 65 (SEAL) August 23, 2023 Regular Meeting Agenda Packet BUDGET WORKSHOP MEETING MINUTES TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 BOARD OF DIRECTORS August 2, 2023, at 4:30 p.m. Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in a special session on August 2, 2023, at 4:30 p.m., in the Boardroom of the Administration Building, 100 Municipal Drive, Trophy Club, Texas 76262. The meeting was held within the boundaries of the District and was open to the public. STATE OF TEXAS § COUNTIES OF DENTON AND TARRANT BOARD MEMBERS PRESENT: Kevin R. Carr President Ben Brewster Vice President Doug Harper Secretary/Treasurer William C. Rose Director BOARD MEMBERS ABSENT: Tracey Hunter Director STAFF PRESENT: Alan Fourmentin Laurie Slaght Mike McMahon Steven Krolczyk General Manager District Secretary Operations Manager Finance Manager GUESTS PRESENT: Jason Wise Fire Chief CALL TO ORDER AND ANNOUNCE A QUORUM President Carr announced the date of August 2, 2023, called the meeting to order and announced a quorum present at 4:37 p.m. REGULAR SESSION 1. Discussion and review of FY 2024 draft budget. Staff reviewed the FY2024 draft budget with the Board and answered questions related thereto. The Board provided input and direction to staff for adjustments to be included in the FY2024 budget. The Board recessed at 6:37 p.m. and reconvened into regular session at 6:49 p.m. ADJOURN President Carr called the meeting adjourned at 7:46 p.m. Kevin R. Carr, President 36 of 65 Doug Harper, Secretary/Treasurer Laurie Slaght, District Secretary 37 of 65 August 23, 2023 Regular Meeting Agenda Packet (SEAL) August 23, 2023 Regular Meeting Agenda Packet SPECIAL SESSION MEETING MINUTES TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 BOARD OF DIRECTORS August 16, 2023, at 6:00 p.m. Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in a special session meeting on August 16, 2023, at 6:00 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 Tracy Hunter Director - arrived at 6:19 William C. Rose Director STAFF PRESENT: Alan Fourmentin Laurie Slaght Steven Krolczyk Emily Rodgers General Manager District Secretary Finance Manager General Legal Counsel GUESTS PRESENT: Jason Wise Fire Chief CALL TO ORDER AND ANNOUNCE A QUORUM President Carr announced the date of Wednesday, August 16, 2023, called the meeting to order and announced a quorum present at 6:01 p.m. The Board of Directors convened into Executive Session at 6:02 p.m. EXECUTIVE SESSION 1. 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. The Board reconvened into Regular Session at 7:57 p.m. 38 of 65 August 23, 2023 Regular Meeting Agenda Packet REGULAR SESSION 2. Discussion and possible action regarding Amended and Restated Interlocal Cooperation Agreement for Administration of Fire Protection Services with Town of Trophy Club. No action taken. 3. Discussion and possible action regarding FY 2024 fire department draft budget. Motion made by Director Brewster and seconded by Director Hunter to approve the FY2024 fire department draft budget as presented. For: Brewster, Harper, Hunter Oppose: Carr, Rose Motion passed 3-2-0 ADJOURN President Carr called the meeting adjourned at 8:55 p.m. Kevin R. Carr, President Doug Harper, Secretary/Treasurer Laurie Slaght, District Secretary 39 of 65 (SEAL) August 23, 2023 Regular Meeting Agenda Packet FORTWORTH. APPOINTMENT FORM Wholesale Water and Wastewater Customer Advisory Committee DATE: August 23, 2023 WHOLESALE CUSTOMER: Trophy Club Municipal Utility District No. 1 Check all that apply: 0 Water ❑ Wastewater The following individuals have been officially appointed by the CUSTOMER's GOVERNING BODY, under the terms of the Wholesale Contract for Services as the VOTING MEMBER and ALTERNATE for the Water and/or Wastewater System Advisory Committee. The term is for the Fiscal Year beginning October 1, 2023 through September 30, 2024. Voting Member: Alternate Member Mike McMahon Alan Fourmentin Name Name Operations Manager General Manager Title Title 682-323-6600 682-323-6600 Office Phone Office Phone 682-323-6600 682-323-6600 Cell Phone Cell Phone Email Address Email Address Mailing Address: Mailing Address: 100 Municipal Drive 100 Municipal Drive Trophy Club, TX 76262 Trophy Club, TX 76262 Signature of Mayor/Board President Please complete and return as soon as possible, but no later than October 31, 2023 to: WaterWholesale@fortworthtexas. gov or City of Fort Worth Water Customer Service/Wholesale P. 0. Box 870 Fort Worth, Texas 76101 Official Seal cfs01\water\Groups\WholeSale\Wholesale Customer Advisory Committee\WCAC Appointees FY2024 40 of 65 15,1 TROPHY CLUB MUNICIPAL UTILITY DISTRICT August 23, 2023 Regular Meeting Agenda Packet STAFF REPORT August 23, 2023 AGENDA ITEM: Consider and act to adopt Order No. 2023-0823A declaring the 2011 Ford F550 Brush truck as surplus property of the District and authorize staff to sell such property. DESCRIPTION: This apparatus was originally purchased in 2011 for an amount of $88,000 with 90% of the cost funded through a Texas Forest Service grant. This unit has been used 175 times since January 1, 2013; however, 30 of these incidents were related to wildland firefighting, roughly three (3) per year. The remaining incidents included public service assistance, down power lines, lockouts, and medical response. The aging apparatus has primarily been used as a support vehicle and no longer a necessary apparatus. Selling the unit will free up space at the fire station, reduce annual vehicle maintenance costs, and reduce long-term capital replacement needs. Future wildland incidents can be managed utilizing the newest engine, utility task vehicle (UTV), and mutual aid assistance. The Fire Department has been in contact with multiple vendors to determine the estimated value. Wildfire Truck estimated the value of this unit to be approximately $50,000 at auction and began contacting local departments looking to purchase a similar vehicle. Brinlee Mountain Fire Apparatus, who purchased the recently replaced 2007 engine, has provided a purchase offer of $60,000. Through contact via Wildfire Truck, the Ponder Volunteer Fire Department is currently in need of another brush truck and has also provided an offer of $60,000. ATTACHMENTS: Resolution No. 2023-0823A RECOMMENDATION: Adopt Order No. 2023-0823A declaring Brush Truck surplus property and authorize staff to sell said vehicle to Ponder Volunteer Fire Department in an amount of $60,000. 41 of 65 August 23, 2023 Regular Meeting Agenda Packet ORDER NO. 2023-0823A ORDER DECLARING PROPERTY SURPLUS AND AUTHORIZING DISPOSITION THEREOF WHEREAS, Trophy Club Municipal Utility District No. 1 (the "District") is a conservation and reclamation district, a body corporate and politic and governmental agency of the State of Texas, created under Article XVI, Sec. 59 of the Texas Constitution by order of the Texas Water Commission, now the Texas Commission on Environmental Quality ("TCEQ"), and the District operates under Chapters 49 and 54 of the Texas Water Code, as amended; WHEREAS, Section 49.226 of the Texas Water Code provides that any personal property valued at more than $300 which is found by the board to be surplus and is not needed by the district may be sold under order of the board either by public or private sale; WHEREAS, the District owns that certain property more particularly described in Exhibit "A" attached hereto, which property is surplus and no longer used, useful or needed by the District for its operations (the "Property"); and WHEREAS, the Board of Directors desires to declare the Property to be surplus and not needed by the District and further desires to authorize the disposal thereof. NOW, THEREFORE, BE IT ORDERED BY THE BOARD OF DIRECTORS OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 THAT: Section 1. The facts and recitations 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. The Board of Directors of the District hereby finds and declares that the Property is surplus and not needed by the District. Section 3. The Board of Directors hereby orders and directs that the Property be disposed of by public sale. Section 4. The General Manager is hereby authorized to take any and all actions necessary to effectuate this Order. Section 5. Upon adoption of this Order, an original Order shall be filed in the permanent records of the District. 42 of 65 August 23, 2023 Regular Meeting Agenda Packet PASSED AND APPROVED this 23rd day of August 2023. Kevin R. Carr, President Doug Harper, Secretary/Treasurer (SEAL) Laurie Slaght, District Secretary 43 of 65 August 23, 2023 Regular Meeting Agenda Packet Exhibit "A" Surplus Property 1. 2011 Ford Brush Truck 44 of 65 August 23, 2023 Regular Meeting Agenda Packet RESOLUTION NO. 2023-0823A TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 RESOLUTION TO AMEND FISCAL YEAR 2023 BUDGET WHEREAS, Trophy Club Municipal Utility District No. 1 (the "District") is a conservation and reclamation district, and a political subdivision of the State of Texas, created under Article XVI, Sec. 59 of the Texas Constitution by order of the Texas Water Commission, now the Texas Commission on Environmental Quality ("TCEQ"), and the District operates under Chapters 49 and 54 of the Texas Water Code, as amended. WHEREAS, Title 30, Texas Administrative Code, Section 293.97(b), provides that prior to the start of a fiscal year, the governing board of each active district shall adopt an operating budget for the upcoming fiscal year. The rule further provides that the adopted budget and any subsequent amendments thereto shall be passed and approved by a resolution of the governing board and shall be made a part of the governing board minutes. WHEREAS, The Board of Directors previously approved a resolution adopting the 2023 fiscal year budget for the District on September 21, 2022; and WHEREAS, The Board of Directors now desires to amend its 2023 fiscal year budget. NOW, THEREFORE, BE IT RESOLVED BY THE BOARD OF DIRECTORS OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 THAT: Section 1. The Board of Directors hereby amends the fiscal year budget for the 2023 Fiscal Year. A copy of the budget amendment is attached to this Resolution as Exhibit "A". The budget amendment is hereby approved for all purposes. Section 2. A copy of this Resolution amending the fiscal year 2023 budget shall be attached to the meeting minutes of August 23, 2023. Section 3. The President and Secretary of the Board are hereby authorized and directed to execute this Resolution. After this Resolution is executed, an original Resolution shall be filed in the permanent records of the District. RESOLVED, PASSED AND APPROVED this 23rd day of August 2023. 45 of 65 August 23, 2023 Regular Meeting Agenda Packet Kevin R. Carr, President Board of Directors Doug Harper, Secretary/Treasurer Board of Directors ATTEST: (seal) Laurie Slaght, District Secretary 46 of 65 August 23, 2023 Regular Meeting Agenda Packet EXHIBIT "A" (Amended Budget) 47 of 65 August 23, 2023 Regular Meeting Agenda Packet Fiscal Year 2023 Budget Amendment Description FY 2023 Ad FY 2023 Amended Amended Change $ Amended Change Comments -nues Water 6,710,979 7,142,255 431,276 6.43% Increase Due to Change In Employee Election Increase in Water Consumption Sold Sewer 3,839,686 3,670,000 (169,686) -4.42% Reduced Winter Average Consumption TCCC Effluent Charges 60,000 100,000 40,000 66.67% Increase in Effluent Consumption Sold Interest Income 20,000 380,000 360,000 1800.00% Increase lnterest Rate Cell Tower Revenue 14,146 37,179 23,033 162.83% Increase Contract Rate Proceeds from Sale of Assets 25,000 50,000 25,000 100.00% Surplus (2) District Vehicles Subtotal Revenues 11,733,354 12442,977 709,623 6.05% Capital Outlays Water Expenses $ 11,733,354 $ 12,442,977 I 6.05% Total General Fund Expenses Medical Insurance 82,722 87,627 4,905 5.93% Increase Due to Change In Employee Election Maintenance & Repairs 229,800 204,800 (25,000) -10.88% Reduced Repairs Required Vehicle Maintenance 5,000 12,066 7,066 141.32% Increase Due to Unexpected Repairs to Fleet Electricity 228,250 194,810 (33,440) -14.65% Reduced Actual Rate From Budgeted Rate TCEQ Fees & Permits - PID - 214 214 0.00% Additional Testing Required Chemicals _ 25,000 45,500 20,500 82.00% Increased Cost Meter Expense 20,000 6,420 (13,580) -67.90% Reduced New Meter Accounts Capital Outlays 1,752,000 2,300,000 548,000 31.28% Increased Due to Completion of Prior Funded Projects Subtotal Water Expenses 6,577,931 7,086,596 508,665 7.73% Reduced Actual Rate From Budgeted Rate Wastewater Expenses $ 11,733,354 $ 12,442,977 I 6.05% Total General Fund Expenses Salaries & Wages 309,655 290,179 (19,476) -6.29% Removal of FTE Overtime 33,000 15,586 (17,414) -52.77% Reduced Overtime Requirement Medical Insurance 96,579 63,861 (32,718) -33.88% Reduced Actual Rate From Budgeted Rate and Removal of FTE Maintenance & Repairs- WWTP 134,600 211,000 76,400 56.76% Increase Due to Unexpected Repairs Maintenance & Repairs- Collections 281,000 333,600 52,600 18.72% Increase Due to Unexpected Repairs Generator Maintenance & Repairs 9,000 2,836 (6,164) -68.49% Reduced Repairs Required Dumpster Services 100,000 95,000 (5,000) -5.00% Reduced Loads Required Lab Analysis 40,000 45,000 5,000 12.50% Increased Testing Required Electricity 276,318 243,973 (32,345) -11.71% Reduced Actual Rate From Budgeted Rate Lawn Services 16,000 8,500 (7,500) -46.88% Reduced Service Schedule Chemicals- WWTP 32,500 22,500 (10,000) -30.77% Reduced Chemical Required Capital Outlays 895,000 1,578,000 683,000 76.31% Increased Due to Completion of Prior Funded Projects Subtotal Wastewater Expenses 3,491,931 4,178,315 686,383 19.66% Board of Directors Expenses $ 11,733,354 $ 12,442,977 I 6.05% Total General Fund Expenses Schools & Training 4,000 535 (3,465) -86.63% Reduced Training Required Travel & per diem 5,000 - (5,000) -100.00% Reduced Travel Required Miscellaneous Expenses 500 - (500) -100.00% Reduced Expense Required Subtotal Board of Directors Expenses 11,765 2,800 (8,965) -76.20% Reduced Actual Rate From Budgeted Rate Administration Expenses $ 11,733,354 $ 12,442,977 I 6.05% Total General Fund Expenses Medical Insurance 116,290 79,352 (36,938) -31.76% Reduced Actual Rate From Budgeted Rate Independent Labor 15,000 8,000 (7,000) -46.67% Reduced Services Required Maintenance & Repairs 40,000 20,000 (20,000) -50.00% Reduced Repairs Required Electricity 24,369 16,957 (7,412) -30.42% Reduced Actual Rate From Budgeted Rate Postage 30,000 24,000 (6,000) -20.00% Fewer Mailed Postage Bank Service Charges & Fees 95,000 141,000 46,000 48.42% Increased Online Payments and Increased District Absorbed Charged Fee Bad Debt Expense 1,500 13,000 11,500 766.67% Increased to Reflect Annual Account Write -Offs Insurance 88,200 97,400 9,200 10.43% Increase In Insurance Coverage Cost of District Assets Public Education 40,000 30,000 (10,000) -25.00% Reduced Published Information Cost Furniture/Equipment < $5000 10,000 13,053 3,053 30.53% Furniture Updated in Admin Offices Hardware IT 8,400 13,214 4,814 57.30% Unscheduled Additional Server and Station Replacement Capital Outlays - 56,346 56,346 0.00% Increased Due to Completion of Prior Funded Projects Subtotal Administration Expenses 1,534,986 1,578,548 43,562 2.84% Non Departmental Expenses $ 11,733,354 $ 12,442,977 $ 709,623 6.05% Total General Fund Expenses Legal 65,000 30,000 (35,000) -53.85% Reduced Legal Required Auditing 33,800 27,000 (6,800) -20.12% Reduced Auditing Required nses 116,740 i74,940 (41,800) -35.81% Total General Fund Revenues $ 11,733,354 $ 12,442,977 $ 709,623 6.05% Total General Fund Expenses $ 11,733,354 $ 12,921,199 $ 1,187,846 10.12% Net Budget Surplus (Deficit) $ 0 $ (478,222) $ 478,222 4.08% 48 of 65 Trophy Club MUD No. 1 August 23, 2023 Regular Meeting Agenda Packet FY 2024 DRAFT BUDGET PROPERTY VALUE SUMMARY COMPARISON TAX RATE SUMMARY COMPARISON Fiscal Years 2023 2024 % of Increase/Decrease M&O (General Fund) Tax 0.00393 0.00336 -14.70% M&O Fire Tax 0.05625 0.05186 -7.81% M&O Tax Rate 0.06019 0.05522 -8.26% Increase/Decrease: -0.01081 -0.00497 I & S (Debt Service) Tax 0.03115 0.00859 -72.42% Increase/Decrease: -0.00374 -0.02256 Total Tax Rate: 0.09134 0.06381 - Increase/Decrease: -0.01454 -0.02753 (74 PROPERTY VALUE SUMMARY COMPARISON Fiscal Years 2023 2024 of ase/Decrease MUD Tarrant Co. 590,349,578 677,155,61 14.70% MUD Denton Co. 1,645,315,777 7 14.12% PID 919,078,121 40',6 715 .,662 12.31% Out of District & PID 704,864 1647.38% Total Value: 3,155,448,340 3,599,368,018 14.07% r FY 2024 General Fund E UND SUMMARY Revenue 12 Tax Collections 85,734 PID Surcharges 143,223 Reserve Funds 1,983,264 Total Revenue 14,423,933 Water Expense 9,179,933 Wastewater Expense 3,506,324 Board of Directors E nse 11,765 Administra ' n 1,612,840 Non -De. xpe 113,071 tal Expense 14,423,933 Net Budget us/Deficit so Tax Debt Service Fund Revenue 200,771 Tax Collections 219,481 PID Surcharge 115,886 Total Revenue 536,138 Debt Service Expense 536,138 Total Expense 536,138 Net Budget Surplus/Deficit $0 49 of 65 Fire Fund Revenue 15,000 Tax Collections 1,324,945 PID Assessment 541,701 Reserve Funds 179,500 Total Revenue 2,061,146 Fire Expense Total Expense 2,061,146 2,061,146 Net Budget Surplus/Deficit $0 Revenue Debt Service Fund Revenue 1,264,340 Total Revenue 1,264,340 Debt Service Expense 1,264,340 Total Expense 1,264,340 Net Budget Surplus/Deficit $0 August 23, 2023 Regular 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 M&O TAX/SURCHARGE RATE TARRANT COUNTY: DENTON COUNTY: DENTON CO. PID: REQUIRED REVENUE M&O 113,071 95,000 *MUD (All of Dept. 39 Budget) **PID (Legal and Auditor only Dept 39 Budget) I&S TAX/SURCHARGE RATE NEW DEBT: CALCULATE AMOUNT DUE FROM PID 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 = NET TAX VALUE: $ 1,324,945 $ 541,701 Total: $ 1,866,646 $677,155,61 $1,877,675,027 $1,032,220,71 TAX/SURCHARGE RATE = REQUIRE Vals/100 = Certified 7/24/2023 7/24/2023 7/24/2023 tified 7/24/2023 24/2023 %24/2023 L VALS/100 870,514 TARRANT COUNTY: DENTON COUNTY: DENTON CO. PID: REQUIRED REVENUE TAX DEBT 2014 AND AFTER (I&S $402,713 FY 2023 MUD M&O T. -te --_ A 0.00336 FY 2023 PID Tax/S Revenue from M ate - 0.00265 Revenu- from PID Su X VALUE: MUD DEBT: CALC TARRANT $ 85,734 $ 27,337 Total: $ 113,071 $677,155,614 $1,877,675,027 $1,032,220,715 Certified 7/24/2023 7/24/2023 7/24/2023 X/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100 als/100 = 35,870,514 FY 2023 PID Surcharge Rate = 0.01123 * * *NOT FINAL TAX RATE: ONLY USED TO CALCULATE P1 D SHARE Revenue from MUD Tax = $ 286,827 Revenue from PID Surcharge = $ 115,886 Total: $ 402,713 NET TAX VALUE: $677,155,614 0 REQUIRED REVENUE I&S MUD DEBT $219,481 $1,877,675,027 Certified 7/24/2023 7/24/2023 TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100 Vals/100 = 25,548,306 FY 2023 Tax Rate = 0.00859 Revenue from MUD Tax = Revenue from PID = N/A 219,481 Total: $ 219,481 Tax Rate Requirements 3.5% Overall Tax Rate FY 2024 0.06381 Voter Approval Rate 0.06381 Contributions Required $0 TAX COMPARISON 50 of 65 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.0085908 Increase/Decrease Rate: -0.00374 -0.02256 Total Tax Rate: 0.09134 0.06381 Increase/Decrease Rate: -0.01454 -0.02753 50 of 65 August 23, 2023 Regular Meeting Agenda Packet FIRE DEPARTMENT FUND Description FY 2022 Actual FY 2023 Adopted FY 2023 Amended FY 2023 Projected FY 2024 Proposed Budget vs Amended Budget % Change FY 2025 Proposed Revenues -Town 693,010 716,522 745,7 867, 950,494 204,760 27.46% 969,503 Assessment - Emerg Svcs 528,546 517,385 517,385 517,385 541,701 24,316 4.70% 634,280 Emer Svcs Assessment/Delinquent -- 35,337 - - - - 0.00% - Property Taxes/Assessments P&I - - - - - - 0.00% - Fire Permits/Sprinkler & Plan Review 5,000 5,000 5,000 5,000 5,000 - 0.00% 5,000 Fire Inspections - - - - - - 0.00% - Denton/Tarrant County Pledge -Fire 17,000 17,000 17,000 10,000 10,000 (7,000) -41.18% 10,000 Grant Revenue - - - - - - 0.00% - Revenues -MUD 109,271 11 OP 115,753 136,667 130,884 15,131 13.07% 133,502 Property Taxes/MUD Fire 1,279,821 1,257,579 1,257,579 1,257,579 1,324,945 6 , 5.36% 1,548,886 Property Taxes/Fire-Delinquent 2,425 - - 6,068 - (2,072) 0.00% - Property Taxes/Fire P&I 4,639 1 631 11,636 594 (37) 0.00% - Capital Leases -Other Financial Sources 3 65 5,638 4,096 3,921 (1,717) 0.00%- 3,999 Proceeds from Sale of Assets - - - 60,000 - - 0.00% - PriorYearReserves - - - - 17• 00 9,500 0.00% - GASB Reserves 554,301 - - - 2,520 - 0.00% - Miscellaneous Income - - - 191,028 58,584 - 0.00% - Total Revenue 2,391,733 1,796,964 1,796,964 2,058,6_ 061 6 264,182 14.70% 2,198,166 r Expenses -Town 50%/MUD 50% Salaries- Regular 693,010 716,522 745,7 867, 950,494 204,760 27.46% 969,503 Salaries- Part Time 37,954 50,000 50, 79 50,000 - 0.00% 51,000 Salaries- Merits - 35,337 35,33 - - (35,337) -100.00% - Salaries- Overtime 128,564 83,580 83,580 ,736 40,303 (43,277) -51.78% 41,109 Salaries- Longevity 7,574 7,607 ,607 6,916 7,441 1 (166) -2.18% 7,590 Salaries -Stipend -- - - - - 0.00% - Certification Pay 8,277 10,838 10,s 10,546 11,250 413 3.81% 11,475 Salaries- Cell Phone Stipend 1,082 10 1,430 1,350 450 50.00% 1,350 Retirement 109,271 11 OP 115,753 136,667 130,884 15,131 13.07% 133,502 Medical lnsurance 64,881 1, 4 91,140 80,337 79,022 (12,118) -13.30% 80,602 Dental lnsurance 3,959 6,544 3,728 4,472 (2,072) -31.66% 4,561 Vision Insurance 498 1 631 592 594 (37) -5.86% 606 Life Insurance & Other 3 65 5,638 4,096 3,921 (1,717) -30.46% 3,999 Social Security Taxes 5 1111 51,444 53,339 38,956 61,194 7,856 14.73% 62,418 Medicare Taxes 12,031 12,474 9,874 14,311 1,837 14.72% 14,598 Unemployment Taxes '0 2,520 2,520 123 2,520 - 0.00% 2,570 Workman's Compensation 20 9 19,047 19,810 19,810 58,584 38,774 195.73% 59,756 Pre -Employment Physicals/Testing , 42 - - 5,785 - - 0.00% - Tuition Reimbursement 143 - - 2,315 7,000 7,000 0.00% 7,140 Professional Outside Services 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 14,564 17,164 17,164 17,164 11,085 (6,079) -35.42% 11,307 Tax Administration 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 266 300 300 249 1,100 800 266.67% 1,122 Schools & Training 11,449 19,900 19,900 19,900 19,900 - 0.00% 20,298 Electricity 5,853 8,400 8,400 8,400 8,400 - 0.00% 8,568 Water 3,318 4,000 4,000 4,000 4,000 - 0.00% 4,080 Communications/Mobiles 18,816 16,691 16,691 16,691 16,691 - 0.00% 17,025 Building Maintenance 55,628 22,200 22,200 42,512 37,200 15,000 67.57% 37,944 Vehicle Maintenance 24,128 40,800 40,800 40,800 49,029 8,229 20.17% 50,010 Equipment Maintenance 11,155 18,715 18,715 18,715 18,715 - 0.00% 19,089 Emergency Management - 1,000 1,000 1,000 1,000 - 0.00% 1,020 Dispatch- Denton County 4,021 5,061 5,061 5,061 5,622 561 11.08% 5,734 Dues & Memberships 19,154 20,337 20,337 20,337 27,242 6,905 33.95% 27,787 Flags & Repair- - - - - - 0.00% - Travel & per diem 17,410 14,510 14,510 14,921 14,510 - 0.00% 14,800 Office Supplies 267 500 500 500 500 - 0.00% 510 51 of 65 August 23, 2023 Regular Meeting Agenda Packet FIRE DEPARTMENT FUND Description FY 2022 Actual FY 2023 Adopted FY 2023 Amended FY 2023 Projected FY 2024 Proposed Budget vs Amended Budget % Change FY 2025 Proposed Printer Supplies 1,371 1,600 1,600 1,600 2,600 1,000 62.50% 2,652 Postage 65 100 100 100 100 - 0.00% 102 Publications/Books/Subscripts - 350 350 350 350 - 0.00% 357 Fuel 12,141 12,225 12,225 12,225 12,225 - 0.00% 12,470 Uniforms 9,129 9,645 9,645 9,645 9,645 - 0.00% 9,838 Safety Equipment/Protective Clothing 16,026 40,000 40,000 40,000 40,000 - 0.00% 40,800 Disposable Supplies 46 - - 35 - - 0.00% - Small Equipment 4,705 4,950 9,542 9,542 4,950 (4,592) -48.13% 5,049 Hardware 2,504 4,458 4,458 4,458 4,458 0.00% 4,547 Maintenance & Supplies 1,648 1,500 1,500 1,500 1,500 - 0.00% 1,530 Miscellaneous Expense 3,954 4,000 4,000 4,000 4,000 0.00% 4,080 Programs & Special Projects 16,402 16,931 16,931 16,931 16,931 - 0.00% 17,270 Capital Outlays - - - - 6,50 6,5 0.00% - Expenses -MUD 100% Maintenance & Repairs (GASB34) -- - - - - 0.00% - Rent And/or Usage 198,761 197,266 197,266 197,266 ' 4, ,505 1.78% 199,211 Insurance 19,958 23,100 23,100 22,623 2 3,712 16.07% 28,153 Capital Outlays 554,301 - - 191,0 - - 0.00% - Short Term Debt -Interest 3,102 - - - - - 0.00% - GASB34/Reserve for Replacement 81,420 81,420 81,420 20 81,420 - 0.00% 194,210 Capital Leases- Principal 124,047 - - - 0.00% - Total Expense 2,428,271 1,796,964 1,837, , 20 2,061,146 223,236 12.15% 2,201,963 Total Fire Revenues $ 2,391,733 $ 1,796,964 $ 96,964 697 $ 2,061,146 264,182 14.70% $ 2,198,166 Total Fire Expenses $ 2,428,271 $ 1,796,964 $ 910 $ ,167,420 $ 2,061,146 223,236 12.15% $ 2,201,963 Net Budget Surplus (Deficit) $ (36,538) $ - (4 6) $ (108,723) $ - 40,946 $ (3,797) Town/MUD Fire Contract Calculation FY 20 v FY 2024 Fire Budget 1,79: 2,061,146 Less: Rent/Debt Service 200,771 Less: TML Fire Insurance Cioi 26,812 Less: Capital Outlays 3 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 09 17,000 10,000 Less: Grant Proceeds - Annual transfer to Town f D Budget $ 955,793 $ 1,195,442 Monthly payment to T Oct - pt $ 79,649 $ 99,620 52 of 65 August 23, 2023 Regular Meeting Agenda Packet GENERAL FUND Description FY 2022 Actual FY 2023 Adopted FY 2023 Projected FY 2024 Proposed Budget vs Budget Net Budget % Change FY 2025 Proposed Revenues 4 407,139 431,575 24,436 6.00% 453,154 Overtime 32,273 Property Taxes 138,467 87,956 87,956 85,734 (2,223) -2.53% 88,306 Property Taxes/Delinquent (179) 300 1,288 300 - 0.00% 300 Property Taxes/P & I 541 300 1,079 300 - 0.00% 300 PID Surcharges 164,890 145,029 145,029 143,223 (1,806) -1.24% 147,520 Water 6,843,941 6,710,979 7,142,255 6,939,998 229,019 3.41% 6,831,639 Sewer 3,856,157 3,839,686 3,670,000 3,679,786 (159,900) -4.16% 3,679,786 Penalties 105,893 78,000 73,227 105,800 27,800 35.64% 108,974 Service Charges (Disconnect Fees) 4,695 5,600 4,500 3,350 (2,250) -40.18% 3,350 Plumbing Inspections 600 300 300 300 - 0.00% 300 Sewer Inspections 150 100 100 100 - 0.00% 100 TCCC Effluent Charges 109,207 60,000 100,000 70,000 10,00 6.67% 70,000 Utility Fees - - - - - 0.00% - Capital Lease- Other Fin Sources - - - - 0.00% 0.00% - Interest Income 66,251 20,000 380,000 150,000 4 650.00% 150,000 Cell Tower Revenue 14,146 14,146 37,179 49,3 qb 4 248.66% 50,800 Building Rent Income - - - Maintenance -Heavy Equipment 237 0.00% - Proceeds from Sale of Assets 21,001 25,000 50,000 25,e 2,500 2,500 0.00% 25,000 Prior Year Reserves 2,500 572,900 572,900 1,9 3,. 3.•, .4 237.45% 262,859 GASB Reserves - 164,000 164,000 s. (114,000) -69.51% 315,000 Loan Proceeds - - - - - 0.00% - Oversize Meter Reimbursement 2,654 2,058 - 2, - 0.00% 2,058 lnterfund Transfer In - - 0.00% ,1 , 00 1,178,400 0.00% - - Intergov Transfer In - - - - - 0.00% - Miscellaneous Income 7,899 7,000 5,0 7,000 - 0.00% 7,000 Records Management Revenue - - - - - 0.00% - Recovery of Prior Year Expense 85,000 - - - - 0.00% - Reimbursement/Revenue Bond - - - - - 0.00% - Subtotal Revenues 11,421,312 11,733 ,814 14,423,933 2,690,579 22.93% 11,743,292 Water Expenses Xli Salaries & Wages 362,451 4 407,139 431,575 24,436 6.00% 453,154 Overtime 32,273 00 13,100 17,000 - 0.00% 17,000 Longevity 5,7 83 5,983 6,253 270 4.51% 6,565 Certification 2, .0 3,600 2,600 3,600 - 0.00% 3,600 Retirement AA 51,201 51,201 56,730 5,530 10.80% 59,567 Medical Insurance 6 , 82,722 87,627 116,528 33,806 40.87% 128,180 Dental Insurance 3,9 4,876 3,962 4,835 (41) -0.85% 5,318 Vision Insurance 3 745 745 1,051 306 41.15% 1,156 Life Insurance & Other 3 0 2,400 3,600 4,000 1,600 66.67% 4,400 Social Security Taxes 24, 35 26,891 26,400 28,423 1,532 5.70% 29,844 Medicare Taxes 5,938 6,289 5,571 6,647 358 5.70% 6,980 Unemployment Taxes 143 1,260 65 1,260 - 0.00% 1,323 Workman's Compensati 10,909 11,249 13,313 11,899 649 5.77% 12,493 Pre-emp Physicals/Testing 55 400 420 400 - 0.00% 400 Employee Relations 182 300 300 300 - 0.00% 300 Engineering - - - - - 0.00% - Maintenance & Repairs 357,812 229,800 204,800 201,500 (28,300) -12.32% 206,000 Generator Maintenance & Repairs 952 2,000 876 2,000 - 0.00% 2,000 Vehicle Maintenance 9,738 5,000 12,066 5,000 - 0.00% 5,150 Maintenance -Heavy Equipment 237 1,000 2,516 1,000 - 0.00% 1,030 Cleaning Services 1,935 2,500 2,500 2,500 - 0.00% 2,500 Lab Analysis - MUD 5,285 7,500 4,500 7,500 - 0.00% 7,500 Lab Analysis - PID 1,583 2,000 1,500 2,000 - 0.00% 2,000 Communications/Mobiles 6,865 7,500 6,600 7,500 - 0.00% 7,500 Electricity 138,327 228,250 194,810 183,143 (45,107) -19.76% 192,301 Publications/Books/Subscripts 875 1,000 1,000 1,000 - 0.00% 1,000 Dues & Memberships 125 - - - - 0.00% - Schools & Training 2,649 3,630 2,400 2,630 (1,000) -27.55% 2,630 Safety Program - - - - - 0.00% - Travel & per diem 59 938 100 578 (360) -38.40% 578 53 of 65 August 23, 2023 Regular Meeting Agenda Packet GENERAL FUND Description FY 2022 Actual FY 2023 Adopted FY 2023 Projected FY 2024 Proposed Budget vs Budget Net Budget % Change FY 2025 Proposed Rent/Lease Equipment - - - - - 0.00% - TCEQ Fees & Permits - MUD 21,486 30,000 30,000 29,500 (500) -1.67% 29,500 TCEQ Fees & Permits - PID 437 - 214 500 500 0.00% 500 Wholesale Water 2,672,206 2,640,131 2,640,131 2,655,497 15,366 0.58% 2,788,272 Miscellaneous Expenses - - - - - 0.00% - Property Maintenance - - - - - 0.00% - Lawn Services 6,315 12,500 12,500 12,500 - 0.00% 12,500 Interfund Transfer Out- Revenue I&S 569,455 567,782 567,782 565,797 (1,986) -0.35% 565,797 Interfund Transfer Out- Bond Reserve - - - - - 0.00% - Interfund Transfer Out -Bank Reserve - - - - (1,377) 0.00% - Furniture/Equipment < $5000 1,923 2,500 1,355 - (2,500) -100.00% - Fuel & Lube 21,815 15,000 17,200 23,575 8,57 7.17% 24,282 Uniforms 2,474 4,355 2,900 4,355 (584) 0.00% 4,355 Chemicals 30,633 25,000 45,500 58,200 3 132.80% 59,946 Small Tools - - - - 0.00% - Safety Equipment - - - - ill 0.00% - Meter Expense - 20,000 6,420 20,00b - 0.00% 20,000 Meter Change Out Program 66,372 87,000 87,000 124, 51 43.10% 128,235 Capital Outlays 950,880 1,752,000 2,300,000 4,2 0,L 111 44.,.10 139.73% 1,765,000 Short Term Debt -Principal 31,418 31,882 31,882 11,000 (31,882) -100.00% - Short Term Debt -Interest 1,404 470 470 4,600 (470) -100.00% - Gasb34 Reserves 75,000 162,639 162 ' 8, 216,020 132.82% 378,659 Water Tank Inspection Contract 112,364 113,500 3,000 - (113,500) -100.00% - Bond Related Expenses - - 2,000 - - 0.00% - Subtotal Water Expenses 5,653,457 6,577,931 7,072,5 •,179,933 2,602,002 39.56% 6,937,514 Wastewater Expenses Salaries & Wages 382,301 309,655 79 290,305 (19,350) -6.25% 304,820 Overtime 31,627 33." ,586 20,000 (13,000) -39.39% 20,000 Longevity 7,955 7 4,035 2,368 (1,668) -41.33% 2,486 Certification 5,900 • 0 4,200 5,100 (1,200) -19.05% 5,100 Retirement 47,229 0 41,671 40,934 (737) -1.77% 42,981 Medical Insurance 71,491 79 63,861 93,222 (3,357) -3.48% 102,544 Dental Insurance3,9 27 3,961 3,385 (2,041) -37.62% 3,724 Vision Insurance 793 740 819 26 3.30% 901 Life Insurance & Other . ` 2,400 2,700 3,000 600 25.00% 3,300 Social Security Taxes 21,885 19,343 20,508 (1,377) -6.29% 21,533 Medicare Taxes i 5,118 4,623 4,796 (322) -6.29% 5,036 Unemployment Taxes 0 1,260 44 1,008 (252) -20.00% 1,008 Workman's Compensation0 1 4 8,987 10,635 8,404 (584) -6.50% 8,824 Pre-emp Physicals/Testing 292 400 400 400 - 0.00% 400 Employee Relations 445 300 1,168 300 0.00% 300 Engineering 0.00%- Independent Labor - - - - - 0.00% - Maintenance & Repairs- W 193,823 134,600 211,000 137,000 2,400 1.78% 110,000 Maintenance & Repairs- Coltec s 286,403 281,000 333,600 270,000 (11,000) -3.91% 270,000 Generator Maintenance & Repairs 4,604 9,000 2,836 11,000 2,000 22.22% 11,000 Vehicle Maintenance- WWTP 524 4,600 1,000 4,600 - 0.00% 4,600 Vehicle Maintenance- Collections 18,947 13,000 10,000 13,000 - 0.00% 13,000 Maintenance -Heavy Equipment 1,325 3,000 3,000 3,000 - 0.00% 3,000 Cleaning Services 1,935 2,000 2,000 2,000 - 0.00% 2,000 Dumpster Services 91,740 100,000 95,000 100,000 - 0.00% 103,000 Lab Analysis 44,380 40,000 45,000 55,000 15,000 37.50% 56,650 Communications/Mobiles 6,383 7,500 5,500 7,500 - 0.00% 7,500 Electricity 172,359 276,318 243,973 242,978 (33,340) -12.07% 255,127 Publications/Books/Subscripts - - - - - 0.00% - Dues & Memberships - - - - - 0.00% - Schools&Training 1,700 3,630 2,500 2,119 (1,511) -41.63% 2,119 Safety Program - - - - - 0.00% - Travel & per diem - 1,038 - 528 (510) -49.16% 528 Rent/Lease Equipment - - - - - 0.00% - 54 of 65 August 23, 2023 Regular Meeting Agenda Packet GENERAL FUND Description FY 2022 Actual FY 2023 Adopted FY 2023 Projected FY 2024 Proposed Budget vs Budget Net Budget % Change FY 2025 Proposed Advertising - - - - - 0.00% - TCEQ Fees & Permits 20,314 12,000 9,888 12,000 - 0.00% 12,000 Miscellaneous Expenses - - - - - 0.00% - Property Maintenance - - - - - 0.00% - Lawn Services 6,067 16,000 8,500 16,000 - 0.00% 16,000 Interfund Transfer Out -Tax I&S 115,924 116,245 116,245 115,886 (359) -0.31% 115,886 Interfund Transfer Out- Revenue I&S 690,085 691,931 691,931 698,543 6,612 0.96% 698,543 Interfund Transfer Out -Bond Reserve- 000 0 - - - - 0.00% - Interfund Transfer Out -Bank Reserve - - - - - 0.00% - Furniture/Equipment < $5000 - 500 500 - (500 -100.00% - Fuel & Lube 13,686 12,500 10,000 13,000 500 4.00% 13,000 Uniforms 3,299 4,415 3,000 3,520 (89 - 0.27% 3,520 Chemicals- WWTP 25,284 32,500 22,500 32,500 - 0.00% 33,475 Chemicals- Collections 5,776 10,000 6,003 10,000 - 0.00% 10,300 Small Tools - - - - - 0.00% - Safety Equipment - - - 130,311 - 0.00% - Lab Supplies 31,073 33,000 29,000 33,00b (15,000) 0.00% 33,000 Capital Outlays 381,214 895,000 1,578,000 1,050,E 0 17.32% 570,000 Short Term Debt -Principal 83,484 85,766 85,766 2, ill ( , 8) -73.88% - Short Term Debt -Interest 5,707 2,801 2,835 ' - (2,359) -84.21% - Gasb34 Reserves 130,000 165,777 165,777 155, (10,015) -6.04% 155,762 Capital Lease Issuance Cost -- 75,040 75,040 100,000 - 0.00% - Subtotal Wastewater Expenses 2,937,081 3,491,931 4,10111.1111W„ 24 14,393 0.41% 3,022,965 Board of Directors Expenses Salaries & Wages Salaries & Wages 019 620,938 620,938 0.00% 42,247 Social Security Taxes 696,345 Overtime 6•‘"- 2,000 0.00% - Medicare Taxes 0.00% 2,000 Longevity 2,973 0.00% 2,423 Unemployment Taxes - 4.54% - - 0.00% - Workman's Compensation 10 Or 15 15 - 0.00% 15 Publications/Books/Subscripts - 108,759 - - - 0.00% - Dues & Memberships 700 3,081 750 750 - 0.00% 750 Meetings 1,416 00 1,500 1,500 886 0.00% 1,500 Schools&Training 6 000 0 535 4,000 5,100 0.00% 4,000 Travel & per diem - 5,000 - 5,000 - 0.00% 5,000 Miscellaneous Expenses 6.77% 500 - 500 - 0.00% 500 Subtotal Board of Directors Expenses -elk 11,765 2,800 11,765 - 0.00% 11,765 Administration Expenses Salaries & Wages 019 620,938 620,938 663,185 42,247 6.80% 696,345 Overtime 49 2,000 1,500 2,000 0.00% 2,000 Longevity 2,973 2,423 2,423 2,533 110 4.54% 2,659 Retirement 59,277 73,825 73,825 82,631 8,806 11.93% 86,763 Medical Insurance 69,806 116,290 79,352 108,759 (7,531) -6.48% 119,635 Dental Insurance 3,762 6,051 3,081 3,817 (2,234) -36.92% 4,198 Vision Insurance 527 899 638 886 (13) -1.45% 975 Life Insurance & Other 4,507 2,400 5,100 4,800 2,400 100.00% 5,280 Social Security Taxes 31,981 38,772 37,404 41,399 2,626 6.77% 43,468 Medicare Taxes 7,479 9,068 8,813 9,682 614 6.77% 10,166 Unemployment Taxes 54 1,512 59 1,512 - 0.00% 1,512 Workman's Compensation 1,511 1,496 1,291 1,597 101 6.78% 1,677 Pre-emp Physicals/Testing 516 500 500 500 - 0.00% 500 Employee Relations 3,471 4,000 4,000 4,000 - 0.00% 4,000 Engineering - - - - - 0.00% - Software & Support 107,761 131,700 131,700 130,311 (1,389) -1.05% 134,220 Independent Labor 29,113 15,000 8,000 - (15,000) -100.00% - Maintenance & Repairs 66,308 40,000 20,000 23,000 (17,000) -42.50% 13,000 Generator Maintenance & Repairs 717 3,000 1,000 1,000 (2,000) -66.67% 1,000 Building Maintenance & Supplies - - - - - 0.00% - Cleaning Services 12,266 12,000 12,000 13,825 1,825 15.21% 13,825 Professional Outside Services 75,415 75,040 75,040 100,000 24,960 33.26% 103,000 55 of 65 August 23, 2023 Regular Meeting Agenda Packet GENERAL FUND Description FY 2022 Actual FY 2023 Adopted FY 2023 Projected FY 2024 Proposed Budget vs Budget Net Budget % Change FY 2025 Proposed Utility Billing Contract 7,346 9,000 9,000 9,000 - 0.00% 9,000 Telephone 5,909 6,000 6,000 6,000 - 0.00% 6,000 Communications/Mobiles 2,700 3,000 300 3,000 - 0.00% 3,000 Electricity 15,200 24,369 16,957 17,685 (6,685) -27.43% 17,685 Water 4,107 5,000 5,000 5,000 - 0.00% 5,000 Postage 22,408 30,000 24,000 30,000 - 0.00% 30,000 Bank Service Charges & Fees 92,832 95,000 141,000 140,000 45,000 47.37% 140,000 Bad Debt Expense 9,562 1,500 13,000 13,000 11,500 766.67% 13,000 Insurance 86,013 88,200 97,400 116,158 27,958 31.70% 121,966 Publications/Books/Subscripts - - - - - 0.00% - Dues & Memberships 6,522 6,500 6,900 6,800 300 4.62% 6,800 Meetings - - - - - 0.00% - Public Education 3,867 40,000 30,000 (40 �� 0.00% Schools & Training 913 3,250 1,000 3,900 20.00% 3,900 Travel & per diem 509 1,588 - 1,228 ( -22.68% 1,228 Physicals/Testing - - - - 0.00% - Elections 7,143 - - 10,00 1 -• 0.00% - Advertising 10,412 - - - 0.00% - Security - - - - - 0.00% - Miscellaneous Expenses 112 - 88 - 0.00% - General Manager Contingency - - - - 0.00% - Lawn Services 4,227 5,000 55 - 0.00% 5,000 Furniture/Equipment < $5000 3,284 10,000 1 , 00 (7,000) -70.00% 3,000 Uniforms 443 530. 530 - 0.00% 530 Hardware IT 12,206 8,400 13,2 8,200 (200) -2.38% 8,200 Office Supplies 4,217 6,000 5,000 5,000 (1,000) -16.67% 5,000 Printer Supplies & Maintenance - - - - - 0.00% - Maintenance Supplies 6,190 4,000 00 5,000 1,000 25.00% 5,000 Printing - - - - 0.00% Capital Outlays 113,654 74,953 - - 0.00% - Copier Lease 3,242 4,000 4,000 - 0.00% 4,000 Gasb34 Reserves - Ciiii86 26,736 24,903 (1,833) -6.86% 24,903 Subtotal Administration Expenses 1,435,755 1,584,793 1,612,840 77,854 5.07% 1,657,434 Non Departmental Expenses Legal So)65,000 30,000 65,000 - 0.00% 65,000 Auditing 2 , 33,800 27,000 30,000 (3,800) -11.24% 30,000 Appraisal 14,5 12,940 12,940 13,071 131 1.01% 13,463 Tax Admin Fees 4 5,000 4,046 5,000 - 0.00% 5,150 Subtotal Non Departmental Expenses • 1 116,740 73,986 113,071 (3,669) -3.14% 113,613 Total General Fund Revenu 11,421,312 $ 11,733,354 $ 12,434,814 $ 14,423,933 $ 2,690,579 22.93% $ 11,743,292 Total General Fund Expe s $ 10,128,766 $ 11,733,354 $ 12,882,632 $ 14,423,933 $ 2,690,579 22.93% $ 11,743,292 Net Budget Surplus (De $ 1,292,546 $ 0 $ (447,818) $ 0 $ 0 $ 0 56 of 65 Meeting genda Packet August 23, 2023 WATER AND WASTEWATER UTILITY RATE STUDY TROPHY CLUB MUNICIPAL UTILITY DISTRICT NewGen Strategies & Solutions 57 of 65 © 2022 NEWGEN STRATEGIES AND SOLUTIONS, LLC KEY DRIVERS 1- Budgeted Amounts 2 — Reserves include balances from Repair and Replacement Fund, Emergency Capital Reserves, and Rate Stabilization Fund August 23, 2023 Regular Meeting Agenda Packet FY 2020 FY 2021 FY 2022 FY 20231 FY 20241 Wholesale $1,865,024 $ 1,893,513 $ 2,672,206 $ 2,640,131 $ 2,655,497 Capital Projects FY 2024 FY 2025 FY 2026 FY 2027 FY 2028 Water $4,200,000 $1,765,000 $1,751,000 $1,853,530 $1,857,636 Wastewater 1,050,000 570,000 290,000 290,000 290,000 Total $5,250,000 $2,335,000 $2,041,000 $2,143,530 $2,147,636 Drawdown of Reserves2 FY 2024 FY 2025 FY 2026 FY 2027 FY 2028 Beginning Balance $3,518,136 $1,584,872 $1,146,671 $1,146,671 $1,146,671 Drawdown (1,933,264) (438,201) 0 0 0 Ending Balance $1,584,872 $1,146,671 $1,146,671 $1,146,671 $1,146,671 58 of 65 © 2022 NEWGEN STRATEGIES AND SOLUTIONS, LLC RECOVERY OF REVENUE REQUIREMENT UNDER CURRENT RATES August 23, 2023 Regular Meeting Agenda Packet Water FY 2024 FY 20 Y 20 Rate Revenue Total $ 6,939,998 $ 6,939,998 $ 6,939,998 $ 6,939,998 $ 6,939,998 Revenue Requirement 8,167,088 7,426,857 8,048,401 8,368,525 8,581,949 $ Over/(Under) Recovery ($ 1,227,091) ($ 486,859) ($ 1,108,403) ($ 1,428,528) ($ 1,641,952) Over/(Under) Recovery -17.7% -7.0% -16.0% -20.6% -23.7% Wastewater FY 2024 FY 2025 FY 2026 FY 2028 Rate Revenue Total $ 3,679,786 $ 3,679,786 $ 3,679,786 $ 3,679,786 $ 3,679,786 Revenue Requirement 3,630,389 3,301,505 3,089,094 3,173,676 3,273,024 $ Over/(Under) Recovery $ 49,397 $ 378,281 $ 590,692 $ 506,110 $ 406,762 Over/(Under) Recovery 1.3% 10.3% 16.1% 13.8% 11.1% © 2022 NEWGEN STRATEGIES AND SOLUTIONS, LLC 59 of 65 KEY FINANCIAL STATISTICS Water & Wastewater Under Current Rates 1- Decrease in revenue is due to use of reserves dropping off 2 — Days Cash on Hand is for the General Operating Fund Balance only August 23, 2023 Regular Meeting Agenda Packet FY 2024 FY 2025 FY 2026 FY 2027 FY 2028 Debt Service Coverage Total Revenues' $13,195,075 $11,700,012 $11,261,811 $11,261,811 $11,261,811 Less: O&M Expense 7,507,636 7,777,751 8,058,480 8,350,259 8,653,548 Available for Debt Service $5,687,739 $3,922,260 $3,203,331 $2,911,551 $2,608,262 Debt Service 1,263,632 1,272,119 1,269,314 1,274,826 1,274,388 Debt Service Coverage 4.50 3.08 2.52 2.28 2.05 DSC Target 1.10 1.10 1.10 1.10 1.10 Days Cash on Handl Total Expenses $14,372,768 $11,808,589 $11,779,523 $12,184,228 $12,497,001 Fund Balance Target (Days) 90 90 90 90 90 Fund Balance Requirement $3,543,970 $2,911,707 $2,904,540 $3,004,330 $3,081,452 Ending Fund Balance 5,922,307 5,813,729 5,296,018 4,373,600 3,138,410 Over/(Under) Requirement $2,378,337 $2,902,022 $2,391,478 $1,369,270 $59,958 60 of 65 © 2022 NEWGEN STRATEGIES AND SOLUTIONS, LLC 4 CURRENT RATES No changes are currently proposed CURRENT WATER RATES Inside District Outside Count of District Meters" Minimum Charge 3/4" or less 1" 1.5" 2" 3" 4" 6" Volumetric Charge 0-6,000 6,001-17,000 17,001-25,000 25,001-50,000 50,001 + $ 20.26 38.08 67.54 108.06 204.80 337.68 675.38 $ 4.60 5.35 6.19 7.19 8.36 $ 23.30 43.80 77.67 124.26 233.01 388.33 776.67 $ 5.28 6.15 7.12 8.27 9.62 2,517 2,155 31 198 22 11 2 EURRENT WASTEWATER RATES2 Residential Commercial Minimum Charge Base Rate Volumetric Charge 0-4,000 4,001-8,000 8,001-12,000 12,000+ $22.15 $3.57 5.09 7.18 10.22 $22.15 $8.57 © 2022 NEWGEN STRATEGIES AND SOLUTIONS, LLC August 23, 2023 Regular Meeting Agenda Packet 3 - These will be reevaluated in March with the new winter average. 5 August 23, 2023 Regular Meeting Agenda Packet WATER DISTRICT NOTICE OF PUBLIC HEARING ON TAX RATE The Trophy Club Municipal Utility District No. 1 will hold a public hearing on a proposed tax rate for the tax year 2023 on Wednesday, September 20, 2023 at 6:3o p.m. at the Svore Municipal Building, 100 Municipal Drive, Trophy Club, Texas. Your individual taxes may increase at a greater or lesser rate, or even decrease, depending on the tax rate that is adopted and on the change in the taxable value of your property in relation to the change in taxable value of all other property. The change in the taxable value of your property in relation to the change in taxable value of all other property determines the distribution of the tax burden among all property owners. Visit Texas.gov/PropertyTaxes to find a link to your local property tax database on which you can easily access information regarding your property taxes, including information about proposed tax rates and scheduled public hearings of each entity that taxes your property. FOR the proposal: AGAINST the proposal: PRESENT and not voting: ABSENT: The following table compares taxes on an average residence homestead in this taxing unit last year to taxes proposed on the average residence homestead this year. Last Year This year Total tax rate (per $100 of value) $0.09134/$loo $0.06381/$100 Adopted Proposed Difference in rates per $100 of value ($0.02753)/$loo Percentage increase/decrease in rates (+/-) (30.14%) Average appraised residence homestead value $588,526 $708,995 General homestead exemptions available $4o,756 $90,994 (excluding 65 years of age or older or disabled person's exemptions) Average residence homestead taxable value $547,770 $618,001 Tax on average residence homestead $500.33 $394.35 Annual increase/decrease in taxes if proposed ($105.98) tax rate is adopted (+/-) and percentage of ( 21.18%) increase (+/-) NOTICE OF VOTE ON TAX RATE If the district adopts a combined debt service, operation and maintenance and contract tax rate that would result in the taxes on the average residence homestead increasing by more than 3.5 percent, an election must be held to determine whether to approve the operation and maintenance tax rate under Section 49.23602, Water Code. The 86th Texas Legislature modified the manner in which the voter -approval tax rate is calculated to limit the rate of growth of property taxes in the state. 62 of 65 2023 Developed Water District Voter-Appeoraf3, 2023 Regular Meetin Tax Rate Worksheet Trophy Club Municipal Uility District No. 1 Water District Name 100 Municipal Drive, Trophy Club, TX., 76262 Water District's Address, City, State, ZIP Code Form 50-860 682-831-4600 Phone (area code and number) TCMUD.org Water District's Website Address GENERAL INFORMATION:The Comptroller's office provides this worksheet to assist water districts in determining their voter -approval tax rate. The information provided in this worksheet is offered as technical assistance and not legal advice. Water districts should consult legal counsel for interpretations of law regarding tax rate preparation and adoption. SECTION 1: Voter Approval Tax Rate The voter -approval tax rate for developed water districts is the current year's debt service, contract and unused increment tax rates plus the maintenance and operation (M&O) tax rate that would impose no more than 1.035 times the amount of M&O tax imposed by the water district in the preceding year on the average appraised value of a residence homestead in the water district. The average appraised value disregards any homestead exemption available only to people with disabilities or those age 65 or older. The calculation process starts after the chief appraiser delivers to the taxing unit the certified appraisal roll or certified estimate of value and the estimated values of properties under protest. The designated officer or employee shall certify that the officer or employee has accurately calculated the tax rates and used values shown for the certified appraisal roll or certified estimate. The officer or employee submits the rates to the governing body by Aug. 7 or as soon thereafter as practicable. If any part of the developed water district is located in an area declared a disaster area during the current tax year by the governor or by the president, the board of the district may calculate the voter -approval tax rate in the manner provided in Water Code Section 49.23601(a) and determine whether an election is required to approve the adopted tax rate in the manner provided in Water Code Section 49.23601(c). In such cases, the developed water district may use Comptroller Form 50-858 Water District Voter -Approval Tax Rate Worksheet for Low Tax Rate and Developing Districts to calculate its voter -approval tax rate. ' Tex. Water Code § 49.236(a)(2)(C) ' Tex. Water Code § 49.236(a)(2)(D) 3 Tex. Water Code § 49.23602(a)(2)(A) Tex. Water Code § 49.236(a)(2)(E) s Tex. Water Code § 49.236(a)(2)(F) Form developed by: Texas Comptroller of Public Accounts, Property Tax Assistance Div62.rOf 65 For additional copies, visit: comptroller.texas.gov/taxes/property-tax 50-860 • 7-23/5 1. 2022 average appraised value of residence homestead.' $ 588,526 2. 3. 2022 general exemptions available for the average homestead. Excluding age 65 or older or disabled persons exemptions. 2 $ 40'756 2022 average taxable value of residence homestead. Line 1 minus Line 2.$ 547,770 4. 5. 2022 adopted M&O tax rate.$ 0.0601 9 /$100 2022 M&O tax on average residence homestead. Multiply Line 3 by Line 4, divide by $100.$ 329.70 6. 7. Highest M&0 tax on average residence homestead with increase. Multiply Line 5 by 1.035.3 $ 341.24 2023 average appraised value of residence homestead. $ 708,995 8. 2023 general exemptions available for the average homestead. Excluding age 65 or older or disabled persons exemptions. ° $ 90,994 9. 2023 average taxable value of residence homestead. Line 7 minus Line 8.$ 61 8, 001 10. Highest 2023 M&O tax rate. Line 6 divided by Line 9, multiply by $100.50 $ .05522 /$100 11. 2023 debt tax rate.$ 0.00859 /5100 12. 2023 contract tax rate.$ 0.00000 /$100 13. 2022 unused increment rate. Subtract the 2022 actual tax rate and the 2022 unused increment rate from the 2022 voter -approval tax rate. $ 0.00524 /$100 14. 2021 unused increment rate. Subtract the 2021 actual tax rate and the 2021 unused increment rate from the 2021 voter -approval tax rate. $ 0.00000 /$100 ' Tex. Water Code § 49.236(a)(2)(C) ' Tex. Water Code § 49.236(a)(2)(D) 3 Tex. Water Code § 49.23602(a)(2)(A) Tex. Water Code § 49.236(a)(2)(E) s Tex. Water Code § 49.236(a)(2)(F) Form developed by: Texas Comptroller of Public Accounts, Property Tax Assistance Div62.rOf 65 For additional copies, visit: comptroller.texas.gov/taxes/property-tax 50-860 • 7-23/5 2023 Developed Water District Voter -Approval Tax Rate Worksheet 1 Form 50-860 August 23, 2023 Regular Meeting Agenda Packet 15. 2020 unused increment rate. Subtract the 2020 actual tax rate and the 2020 unused increment rate from the 2020 voter -approval tax rate. $ 0.00137 16. 2023 total unused increment rate. 6 Add Lines 13, 14 and 15. 17. 2023 voter -approval tax rate. Add lines 10,11, 12 and 16. $ 0.00661 $ 0.06381 /$100 /$100 /$100 SECTION 2: Mandatory Tax Election Rate The mandatory tax election rate is the highest total tax rate a developed water district may adopt without holding an election. The mandatory tax election rate is the rate that would impose 1.035 times the amount of tax imposed by the district in the preceding year on the average appraised value of a residence homestead in the water district plus the unused increment rate. The average appraised value disregards any homestead exemption available only to people with disabilities or those age 65 or older.' SECTION 3: Taxing Unit Representative Name and Signature Enter the name of the person preparing the voter -approval tax rate and mandatory tax election rate as authorized by the governing body of the water district. By signing below, you certify that you are the designated officer or employee of the taxing unit and have calculated the tax rates in accordance with requirements in Water Code. 8 print here Steven Krolczyk Printed Name of Water District Representative sign here 4. C ;j Water District Representative u Tex. Tax Code 426.013 Tex. Water Code § 49.23602(a)(2) e Tex. Water Code § 49.23602 8/9/2023 Date 64 of 65 For additional copies, visit: comptroller.texas.gov/taxes/property-tax Page 2 18. 2022 average taxable value of residence homestead. Enter the amount from Line 3.$ '5547, 770 19. 2022 adopted total tax rate. $ 0.091 34 /$100 20. 2022 total tax on average residence homestead. Multiply Line 18 by Line 19 divide by $100. $ 500.33 21. 2023 mandatory election amount of taxes per average residence homestead. Multiply Line 20 by 1.035. $ 517.84 22. 2023 mandatory election tax rate, before unused increment. Divide Line 21 by Line 9 and multiply by $100.$ 0.08379 /$100 23. 2022 mandatory tax election rate. Add Line 16 and Line 22.$ 0.09040 isioo SECTION 3: Taxing Unit Representative Name and Signature Enter the name of the person preparing the voter -approval tax rate and mandatory tax election rate as authorized by the governing body of the water district. By signing below, you certify that you are the designated officer or employee of the taxing unit and have calculated the tax rates in accordance with requirements in Water Code. 8 print here Steven Krolczyk Printed Name of Water District Representative sign here 4. C ;j Water District Representative u Tex. Tax Code 426.013 Tex. Water Code § 49.23602(a)(2) e Tex. Water Code § 49.23602 8/9/2023 Date 64 of 65 For additional copies, visit: comptroller.texas.gov/taxes/property-tax Page 2 Trophy Club Municipal Utility District No. 1 September 2023 35 36 Sun Aug 27, 2023 37 10 38 39 August 23, 2023 Regular Meeting AgendaLPcrk�# Slaght Mon Tue Wed Thu Fri Sat 28 29 30 1 Sep 1 Labor Day - Office Close 11 12 13 14 15 16 17 18 24 25 19 20 ) Board of Directors Reg 21 22 23 26 27 28 29 30 65 of 65 Printed on: 08/14/2023 11:39am OCentral Time US & Ca Powered by _ teamup