The URL can be used to link to this page

Home My WebLink About2023-0719 July 19 2023 Regular Meeting PacketSPA TROPHY CLUB ` MUNICIPAL / UTILITY DISTRICT July 19, 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, July 19, 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 • 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 Attachment: Staff Reports REGULAR SESSION 2. Consider and act to approve the June 21, 2023, Regular Meeting Minutes. Attachment: Meeting minutes 3. Receive update from the Strategic Committee. (Carr/Harper) 1 of 69 July 19, 2023 Regular Meeting Agenda Packet 4. Receive update from the Budget Committee. (Brewster/Harper) Attachment: FY2024 Draft Budget 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. Attachment: Staff Report 6. Consider and act to terminate contract with Utility Services Co. Inc. for Water Tank Maintenance effective November 1, 2023. Attachment: Staff Report 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. Attachment: Order No. 2023-0719A 8. Discussion and possible action regarding Amended and Restated Interlocal Cooperation Agreement for Administration of Fire Protection Services with Town of Trophy Club. 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. 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. 11. Items for future agendas: 2 of 69 July 19, 2023 Regular Meeting Agenda Packet 12. Set future Meeting dates - August 16, 2023, at 6:30 p.m. Attachment: Calendar *THE BOARD RESERVES THE RIGHT TO ADJOURN INTO EXECUTIVE SESSION AT ANY TIME DURING THE MEETING PURSUANT TO THE APPLICABLE SECTION OF SUBCHAPTER D, CHAPTER 551, TEXAS GOVERNMENT CODE, THE TEXAS OPEN MEETINGS ACT, WITH RESPECT TO ANY ITEM ON THE AGENDA. NO FINAL ACTION, DECISION OR VOTE WILL BE TAKEN ON ANY SUBJECT OR MATTER IN EXECUTIVE SESSION. THIS NOTICE MODIFIES THE DISTRICT'S PRIOR PRACTICE OF SPECIFICALLY IDENTIFYING ALL AGENDA ITEMS TO BE DISCUSSED IN EXECUTIVE SESSION. ADJOURN 3 of 69 July 19, 2023 Regular Meeting Agenda Packet TROPHY tI UB MUNICIPAL UTILITY DISTRICT Capital Improvement Projects • FY 2023 Water Line Project — Construction is substantially complete on Riviera Court with re—establishment of sod and general cleanup remaining. The contractor has begun installing temporary water lines on Sunset Drive and Berkshire Court. This project is scheduled to be completed by the end of November 2023. • Pump Station Improvement Project — Bidding is complete, and a contract is being requested for approval 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. • Lift Station Generators — The installation of conduit is complete at Lift Stations #8 and #9. The contractor will continue installing conduit at the remaining locations in preparation of constructing concrete pads. Delivery of the generators is scheduled for December 2023 with an anticipated completion date of April 2024. • FY 2023 Wastewater Improvements — Two additional point repairs were completed this month and the contractor has begun manhole repairs. • 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. 4of69 July 19, 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 591,302 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 656,096 5 of 69 July 19, 2023 Regular Meeting Agenda Packet 7 6 0 5 0 v 4 0 3 3 2 0 • Min 3.173 • Max Avg 4.183 Water Production Jun -22 Jun -22 Jul -22 Jul -22 3.915 5.767 7.100 5.748 Aug -22 Aug -22 2.348 7.325 4.704 Sep -22 Sep -22 1.889 5.277 3.948 Oct -22 Oct -22 1.842 5.00 3.662 Nov -22 Dec -22 Nov -22 1.401 2.57 1.834 Dec -22 Jan -23 Feb -23 Jan -23 1.115 1.225 Mar -23 Apr -23 Feb -23 May -23 Jun -23 Mar -23 Apr -23 0.878 0.999 0.920 2.72 2.51 2.35 2.52 4.60 1.657 1.759 1.479 1.731 2.780 May -23 1.730 5.73 3.125 Jun -23 2.628 5.95 4.079 1.950 1.750 • 1.550 • 1.350 0 1.150 0.950 0.750 11 .1 11 11 1 Wastewater Treated Jun -22 Jul -22 Aug -22 Sep -22 Oct -22 Nov -22 Dec -22 Jan -23 Daily Avg Flow Daily Max Flow - Daily Avg Max Feb -23 II II mi NI Mar -23 Apr -23 May -23 Jun -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) Jun -22 Jul -22 Aug -22 Sep -22 Oct -22 Nov -22 Dec -22 Jan -23 CBOD Avg CBOD Max -Daily Avg Max -Daily Max Feb -23 Mar -23 Apr -23 May -23 Jun -23 6 of 69 July 19, 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) Jun -22 Jul -22 Aug -22 Sep -22 Oct -22 Nov -22 TSS Avg Dec -22 Jan -23 TSS Max -Daily Avg Max -Daily Max Feb -23 Mar -23 Apr -23 May -23 Jun -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) Jun -22 Jul -22 r � r Aug -22 Sep -22 Oct -22 Nov -22 Dec -22 Jan -23 Feb -23 Mar -23 Apr -23 May -23 Jun -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) Jun -22 Jul -22 Aug -22 Sep -22 Oct -22 Nov -22 Dec -22 Jan -23 Feb -23 Mar -23 Apr -23 NO3 Avg NO3 Max -Daily Avg Max -Daily Max May -23 Jun -23 7 of 69 July 19, 2023 Regular Meeting Agenda Packet 8 of 69 Potential of Hydrogen (pH) 9 8.5 8 7.5 7 6.5 6 Jun -22 Jul -22 Aug -22 Sep -22 Oct -22 Nov -22 Dec -22 Jan -23 Feb -23 Mar -23 Apr -23 May -23 Jun -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 al L A J 6.0 Jun -22 Jul -22 Aug -22 Sep -22 Oct -22 Nov -22 Dec -22 Jan -23 Feb -23 Mar -23 Apr -23 May -23 Jun -23 DO Min DO Max DO Avg Min ME -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 2.0 1.0 1.0 1.0 1.0 2.0 3.0 1.0 6.3 2.0 1.0 1.0 0 Jun -22 Jul -22 Aug -22 *Sep -22 Nov -22 Dec -22 Jan -23 Feb -23 Mar -23 Apr -23 May -23 Jun -23 Oct -22 E. Avg E. Max Avg Max Max coli coli -Daily -Daily 8 of 69 July 19, 2023 Regular Meeting Agenda Packet Check Report Trophy Club Municipal Utility District No. 1 By Check Number Date Range: 06/01/2023 - 06/30/2023 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number Bank Code: Prosperity Bank -Prosperity Bank Payment Type: Regular 3197 BenefitMall 06/01/2023 Regular 0.00 52.00 9622 2796 Garver 06/01/2023 Regular 0.00 50,119.71 9623 4033 Health Care Service Corporation 06/01/2023 Regular 0.00 24,702.13 9624 2673 Jack Henry & Assoc, Inc 06/01/2023 Regular 0.00 2,161.64 9625 2783 JJ HVAC LLC 06/01/2023 Regular 0.00 1,105.00 9626 2785 Kleen Pipe, Inc 06/01/2023 Regular 0.00 25,555.50 9627 3216 M3 Networks 06/01/2023 Regular 0.00 1,091.00 9628 3115 Metlife Group Benefits 06/01/2023 Regular 0.00 2,502.65 9629 3127 Allied Welding Supply Inc. 06/08/2023 Regular 0.00 19.21 9630 1500 American Water Works Assoc 06/08/2023 Regular 0.00 900.00 9631 3299 Bickerstaff Heath Delgado Acosta LLP 06/08/2023 Regular 0.00 3,226.00 9632 3184 Dataprose LLC 06/08/2023 Regular 0.00 2,479.95 9633 1018 Denton Central Appraisal District 06/08/2023 Regular 0.00 2,163.63 9634 3118 Exclusive Pest Control 06/08/2023 Regular 0.00 365.00 9635 2800 Ferguson Enterprises LLC 06/08/2023 Regular 0.00 2,701.09 9636 2606 Fisery Solutions LLC 06/08/2023 Regular 0.00 50.00 9637 3093 Four Man Furnace Inc. 06/08/2023 Regular 0.00 2,483.75 9638 2796 Garver 06/08/2023 Regular 0.00 610.00 9639 3292 Grapevine Dodge Chrysler Jeep 06/08/2023 Regular 0.00 1,757.82 9640 1834 Idexx Distribution, Inc 06/08/2023 Regular 0.00 2,191.90 9641 2754 Lower Colorado River Authority 06/08/2023 Regular 0.00 890.68 9642 3216 M3 Networks 06/08/2023 Regular 0.00 1,047.15 9643 3186 Member's Building Maintenance 06/08/2023 Regular 0.00 1,364.80 9644 1056 Office Depot Inc 06/08/2023 Regular 0.00 181.25 9645 3176 Rey -Mar Construction 06/08/2023 Regular 0.00 27,075.00 9646 3156 Southern Petroleum Lab Inc 06/08/2023 Regular 0.00 757.20 9647 3182 Strategic Government Resources 06/08/2023 Regular 0.00 270.00 9648 2440 Tarrant County Public Health Laboratory 06/08/2023 Regular 0.00 610.00 9649 2696 Texas Excavation Safety System 06/08/2023 Regular 0.00 195.70 9650 1001 Town of Trophy Club 06/08/2023 Regular 0.00 200,758.58 9651 1081 Tri County Electric 06/08/2023 Regular 0.00 528.60 9652 1000 Trophy Club Mud (Water Bills) 06/08/2023 Regular 0.00 422.50 9653 3280 Watts Ellison LLC 06/08/2023 Regular 0.00 3,089.67 9654 1250 Bio -Aquatic Testing Inc. 06/21/2023 Regular 0.00 1,170.00 9655 4018 BP Energy Holding Company LLC 06/21/2023 Regular 0.00 39,238.67 9656 2683 Charter Communications 06/21/2023 Regular 0.00 899.00 9657 2800 Ferguson Enterprises LLC 06/21/2023 Regular 0.00 1,633.19 9658 1372 Hach Company 06/21/2023 Regular 0.00 213.02 9659 2635 Halff Associates Inc. 06/21/2023 Regular 0.00 2,480.67 9660 3278 Kyocera Document Solutions 06/21/2023 Regular 0.00 93.42 9661 2754 Lower Colorado River Authority 06/21/2023 Regular 0.00 222.66 9662 2739 Municipal Valve & Equipment Co 06/21/2023 Regular 0.00 1,275.00 9663 3156 Southern Petroleum Lab Inc 06/21/2023 Regular 0.00 1,071.60 9664 1058 Verizon Wireless 06/21/2023 Regular 0.00 535.61 9665 2222 Aflac 06/30/2023 Regular 0.00 446.16 9667 1030 City of Fort Worth 06/30/2023 Regular 0.00 242,607.58 9668 2655 Core & Main LP 06/30/2023 Regular 0.00 2,835.91 9669 1737 DPC Industries Inc. 06/30/2023 Regular 0.00 1,946.35 9670 2800 Ferguson Enterprises LLC 06/30/2023 Regular 0.00 5,016.22 9671 1372 Hach Company 06/30/2023 Regular 0.00 5,784.44 9672 3297 J&L Construction LLC 06/30/2023 Regular 0.00 85,096.82 9673 2943 JP Morgan Chase Bank NA 06/30/2023 Regular 0.00 9,745.44 9674 3132 Legal Shield 06/30/2023 Regular 0.00 15.95 9675 7/12/2023 5:13:54 PM Page 1 of 4 9 of 69 Check Report Vendor Number 3216 2760 1056 2801 3176 2805 3156 1000 3225 Vendor Name M3 Networks NDS Leasing Office Depot Inc Pipeline Analysis LLC Rey -Mar Construction Scott Tucker Construction LLC Southern Petroleum Lab Inc Trophy Club Mud (Water Bills) US Bank Voyager Fleet Systems Payment Date 06/30/2023 06/30/2023 06/30/2023 06/30/2023 06/30/2023 06/30/2023 06/30/2023 06/30/2023 06/30/2023 July 19, 2023 Regular Meeting Agenda Packet Date Range: 06/01/2023 - 06/30/2023 Discount Amount Payment Amount Number 0.00 8,583.56 9676 0.00 175.00 9677 0.00 86.24 9678 0.00 82,017.70 9679 0.00 15,276.00 9680 0.00 29,039.26 9681 0.00 1,200.00 9682 0.00 453.16 9683 0.00 2,057.43 9684 0.00 904,645.17 Payment Type Regular Regular Regular Regular Regular Regular Regular Regular Regular Total Regular: 7/12/2023 5:13:54 PM Page 2 of 4 10 of 69 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 July 19, 2023 Regular Meeting Agenda Packet Date Range: 06/01/2023 - 06/30/2023 Discount Amount Payment Amount Number Payment Date Payment Type 06/09/2023 06/30/2023 06/09/2023 06/23/2023 06/30/2023 06/23/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 92 62 0 0 6 0 0 0 6 0 Discount Payment 0.00 904,645.17 0.00 0.00 0.00 0.00 0.00 43,866.06 0.00 0.00 98 68 0.00 948,511.23 0.00 266.67 DFT0000079 0.00 9,156.19 DFT0000080 0.00 12,309.71 DFT0000081 0.00 266.67 DFT0000082 0.00 9,336.50 DFT0000083 0.00 12,530.32 DFT0000084 0.00 43,866.06 7/12/2023 5:13:54 PM Page 3 of 4 11 of 69 Check Report July 19, 2023 Regular Meeting Agenda Packet Date Range: 06/01/2023 - 06/30/2023 All Bank Codes Check Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 92 62 0.00 904,645.17 Manual Checks 0 0 0.00 0.00 Voided Checks 0 0 0.00 0.00 Bank Drafts 6 6 0.00 43,866.06 EFT's 0 0 0.00 0.00 98 68 0.00 948,511.23 Fund Summary Fund Name Period Amount 996 MUD Consolidated Cash 6/2023 948,511.23 948,511.23 7/12/2023 5:13:54 PM Page 4 of 4 12 of 69 MIW $11,733,354 Adopted Budget vs YTD Actuals Revenues & Expenses $7,889,071 $8,371,299 $11,733,354 July 19, 2023 Regular Meeting Agenda Packet FY 2023 Combined Financials YTD as of 6/30/2023 YTD Revenues • YTD Expenses $2,393 $54,191 0% $1,173,666 14% 33,087,127 37% 1% $4,053,921 4816 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 88,979,203 60,000,000 Water Consumption Budget vs Actual 101,683,000 40,000,000 20,000,000 0 49,007,000 52,466,000 49,082,000 108,707,084— 79,654,000 70,083,700 46,119,000 80,784,200 61,944,185 34,501,000 41,702,881 Oct Nov 41,572,326 36,351,669 -4—Budget Consumption Dec 54,266,627 4,390,563 33,732,116 —1—Actual Consumption Jan Feb Mar Apr May Jun 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 925.707.134 Total Water Consumption • Budgeted Water Consumption • Projected Water Consumption Presented by: Finance Department $1,000,000 $900,000 $800,000 $700,000 $600,000 $664,453 3500,000 $400,000 $300,000 $200,000 $100,000 Water Revenue Budget vs Actual $0 $365,714 335,705 $351,905 Budget Revenue --Actual Revenue Oct Nov Dec Jan Feb Mar Apr May Jun $8,000,000 37,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 30 Adopted Budget Water Revenue Vs Projected Water Revenue $6,710,979 $7,142,255 $4,070,848 Total Water Revenue $4,498,213 • Budgeted Water Revenue • Projected Water Revenue Net Budgeted Water Revenue Minus Budgeted Expenses • Net Projected Water Revenue Minus Projected Expenses 13 of 69 Trophy Club Municipal Utility District No. 1 Fund: 135 - MUD 1 General Fund CURRENT MONTH YEAR TO DATE July 19, 2023 Regular Meeting Agenda Packet Budget Variance Report As Of: 06/30/2023 ACTUAL BUDGETED VARIANCE ACTUAL BUDGETED VARIANCE ANNUAL BUDGET TOTAL REMAINING % REVENUE SUMMARY Revenue, Asset, Liability, & Equity 1,176,493.03 977,388.37 199,104.66 7,889,070.98 8,796,495.33 (907,424.35) 67 11,733,354.00 (3,844,283.02) 33 TOTAL REVENUE 1,176,493.03 977,388.37 199,104.66 7,889,070.98 8,796,495.33 (907,424.35) 67 11,733,354.00 (3,844,283.02) 33 EXPENSE SUMMARY Revenue, Asset, Liability, & Equity 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Water 529,788.69 547,941.66 18,152.97 4,053,920.58 4,931,474.94 877,554.36 62 6,577,932.00 (2,524,011.42) 38 Wastewater 362,510.59 290,877.74 (71,632.85) 3,087,126.92 2,617,899.66 (469,227.26) 88 3,491,931.00 (404,804.08) 12 Board of Directors 116.61 980.01 863.40 2,393.39 8,820.09 6,426.70 20 11,765.00 (9,371.61) 80 Administration 119,580.94 127,864.23 8,283.29 1,173,666.37 1,150,778.07 (22,888.30) 76 1,534,986.00 (361,319.63) 24 Non Departmental 3,075.63 9,724.44 6,648.81 54,191.25 87,519.96 33,328.71 46 116,740.00 (62,548.75) 54 TOTAL EXPENSE 1,015,072.46 977,388.08 (37,684.38) 8,371,298.51 8,796,492.72 425,194.21 71 11,733,354.00 3,362,055.49 29 REVENUE OVER/(UNDER) EXPENDITURE 161,420.57 0.29 161,420.28 (482,227.53) 2.61 (482,230.14) 0.00 (7,206,338.51) 7/13/2023 1:42:54 PM 14 of 69 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: June 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 June Activity 232.07 -8.10 17.04 0.00 779,457.44 312,048.42 8,902.92 525.00 0.00 0.00 19,182.40 36,005.84 0.00 20,130.00 0.00 0.00 0.00 0.00 Variance Favorable Percent (Unfavorable) Remaining -7,094.66 -96.83% -33.09 -132.41% -7.95 -31.81% -12,080.91 -100.00% 220,432.89 39.43% -7,797.42 -2.44% 2,405.52 37.02% 58.52 12.55% -24.99 -100.00% -8.33 -100.00% 14,184.40 283.80% 34,339.84 2,061.21% -1,178.36 -100.00% 18,047.50 866.63% -47,722.57 -100.00% -13,661.20 -100.00% -171.43 -100.00% -583.10 -100.00% July 19, 2023 Regular Meeting Agenda Packet Monthly Budget Report Account Summary For Fiscal: Current Period Ending: 06/30/2023 YTD Budget 65,940.57 224.91 224.91 108,728.19 5,031,220.95 2,878,612.56 58,476.60 4,198.32 224.91 74.97 44,982.00 14,994.00 10, 605.24 18,742.50 429,503.13 122,950.80 1,542.87 5,247.90 YTD Activity 85,879.10 1,197.70 1,022.16 0.00 4,622,214.67 2,736,626.63 44,727.41 2,250.00 0.00 0.00 47,401.60 288,685.78 33,178.81 22,870.72 0.00 0.00 -0.00 3,016.40 Variance Favorable Percent (Unfavorable) Remaining Total Budget 19,938.53 30.24% 87,956.00 972.79 432.52% 300.00 797.25 354.48% 300.00 -108,728.19 -100.00% 145,029.00 -409,006.28 -8.13% 6,710,979.00 -141,985.93 -4.93% 3,839,686.00 -13,749.19 -23.51% 78,000.00 -1,948.32 -46.41% 5,600.00 -224.91 -100.00% 300.00 -74.97 -100.00% 100.00 2,419.60 5.38% 60,000.00 273,691.78 1,825.34% 20,000.00 22,573.57 212.85% 14,146.00 4,128.22 22.03% 25,000.00 -429,503.13 -100.00% 572,900.00 -122,950.80 -100.00% 164,000.00 +-1,542.87 -100.009' 2,058.00 -2,231.50 -42.52% 7,000.00 977, 388.37 1,176,493.03 199,104.66 20.37% 8,796,495.33 7,889,070.98 -907,424.35 -10.32% 11,733,354.00 977, 388.37 1,176,493.03 199,104.66 20.37% 8,796,495.33 7,889,070.98 -907,424.35 -10.32% 11,733,354.00 33,914.67 22,954.67 10,960.00 32.32% 1,416.10 233.46 1,182.64 83.51% 498.38 5,982.50 -5,484.12 -1,100.39% 299.88 2,050.00 -1,750.12 -583.61% 4,264.96 3,791.48 473.48 11.10% 6,890.74 8,458.97 -1,568.23 -22.76% 406.17 350.81 55.36 13.63% 62.05 71.41 -9.36 -15.08% 199.92 -321.63 521.55 260.88% 2,240.02 1,893.72 346.30 15.46% 7/13/2023 1:52:36 PM 15 of 69 305,232.03 12,744.90 4,485.42 2,698.92 38,384.64 62,016.66 3,655.53 558.45 1,799.28 20,160.18 285,856.02 9,075.10 5,982.50 2,050.00 36,454.32 62,293.12 2,908.92 530.30 2,694.84 18,420.72 19,376.01 3,669.80 -1,497.08 648.92 1,930.32 -276.46 746.61 28.15 -895.56 1,739.46 6.35% 28.79% -33.38% 24.04% 5.03% -0.45% 20.42% 5.04% -49.77% 8.63% 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 Monthly Budget Report 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 July 19, 2023 Regular Meeting Agenda Packet For Fiscal: Current Period Ending: 06/30/2023 Variance June June Favorable Percent YTD Budget Activity (Unfavorable) Remaining Budget 523.87 442.87 81.00 15.46% 4,714.83 104.95 3.63 101.32 96.54% 944.55 937.04 1,109.40 -172.36 -18.39% 8,433.36 33.32 0.00 33.32 100.00% 299.88 24.99 0.00 24.99 100.00% 224.91 19,142.34 2,451.17 16,691.17 87.20% 172,281.06 166.60 0.00 166.60 100.00% 1,499.40 416.50 1,188.80 -772.30 -185.43% 3,748.50 83.30 0.00 83.30 100.00% 749.70 208.25 161.23 47.02 22.58% 1,874.25 624.75 300.00 324.75 51.98% 5,622.75 166.60 302.66 -136.06 -81.67% 1,499.40 624.75 731.06 -106.31 -17.02% 5,622.75 19,013.22 17,514.46 1,498.76 7.88% 171,118.98 83.30 900.00 -816.70 -980.43% 749.70 302.37 735.99 -433.62 -143.41% 2,721.33 78.13 0.00 78.13 100.00% 703.17 2,499.00 0.00 2,499.00 100.00% 22,491.00 0.00 0.00 0.00 0.00% 0.00 219,922.99 242,607.58 -22,684.59 -10.31% 1,979,306.91 1,041.25 1,200.00 -158.75 -15.25% 9,371.25 47,296.24 51,616.66 -4,320.42 -9.13% 425,666.16 208.25 0.00 208.25 100.00% 1,874.25 1,249.50 1,390.49 -140.99 -11.28% 11,245.50 362.77 279.91 82.86 22.84% 3,264.93 2,082.50 4,782.26 -2,699.76 -129.64% 18,742.50 1,666.00 0.00 1,666.00 100.00% 14,994.00 7,247.10 0.00 7,247.10 100.00% 65,223.90 145,941.60 156,605.13 -10,663.53 -7.31% 1,313,474.40 2,655.77 0.00 2,655.77 100.00% 23,901.93 39.15 0.00 39.15 100.00% 352.35 13,547.82 0.00 13,547.82 100.00% 121,930.38 9,454.55 0.00 9,454.55 100.00% 85,090.95 547,941.66 529,788.69 18,152.97 3.31% 4,931,474.94 25,794.26 10,393.09 15,401.17 59.71% 232,148.34 2,748.90 420.31 2,328.59 84.71% 24,740.10 336.11 4,035.00 -3,698.89 -1,100.50% 3,024.99 524.79 3,675.00 -3,150.21 -600.28% 4,723.11 3,471.19 2,177.81 1,293.38 37.26% 31,240.71 8,045.03 4,488.58 3,556.45 44.21% 72,405.27 452.06 166.05 286.01 63.27% 4,068.54 YTD Activity 4,108.00 52.15 9,984.60 420.45 132.95 71,395.80 875.96 12,065.52 2,516.06 1,612.29 3,868.52 1,266.58 4,329.67 117,408.58 900.00 2,136.51 44.79 23,312.03 213.92 1,410,556.57 3,600.00 464,549.94 0.00 12,724.05 2,897.65 37,747.09 0.00 0.00 1,133,080.10 31,882.11 470.26 162,639.00 110,863.59 4,053,920.58 Variance Favorable (Unfavorable) 606.83 892.40 -1,551.24 -120.57 91.96 100,885.26 623.44 -8,317.02 -1,766.36 261.96 1,754.23 232.82 1,293.08 53,710.40 -150.30 584.82 658.38 -821.03 -213.92 568,750.34 5,771.25 -38,883.78 1,874.25 -1,478.55 367.28 -19,004.59 14,994.00 65,223.90 180,394.30 -7,980.18 -117.91 -40,708.62 -25,772.64 Percent Remaining 12.87% 94.48% -18.39% -40.21% 40.89% 58.56% 41.58% -221.88% -235.61% 13.98% 31.20% 15.53% 23.00% 31.39% -20.05% 21.49% 93.63% -3.65% 0.00% 28.73% 61.58% -9.13% 100.00% -13.15% 11.25% -101.40% 100.00% 100.00% 13.73% -33.39% -33.46% -33.39% -30.29% Total Budget 6,289.00 1,260.00 11, 249.00 400.00 300.00 229,800.00 2,000.00 5,000.00 1,000.00 2,500.00 7,500.00 2,000.00 7,500.00 228,250.00 1,000.00 3,630.00 938.00 30,000.00 0.00 2,640,132.00 12,500.00 567,782.00 2,500.00 15,000.00 4,355.00 25,000.00 20,000.00 87,000.00 1,752,000.00 31,882.00 470.00 162,639.00 113,500.00 877,554.36 17.79% 6,577,932.00 227,987.24 4,161.10 1.79% 309,655.00 11,963.22 12,776.88 51.64% 33,000.00 4,035.00 -1,010.01 -33.39% 4,035.00 3,675.00 1,048.11 22.19% 6,300.00 29,728.06 1,512.65 4.84% 41,671.00 50,337.94 22,067.33 30.48% 96,579.00 2,143.58 1,924.96 47.31% 5,427.00 7/13/2023 1:52:36 PM Page 2 of 7 16 of 69 Monthly Budget Report July 19, 2023 Regular Meeting Agenda Packet For Fiscal: Current Period Ending: 06/30/2023 Variance Variance June June 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.40 23.65 35.81% 594.45 435.94 158.51 26.66% 793.00 135-020-50029-000 Life Insurance & Other 199.92 -386.24 586.16 293.20% 1,799.28 2,025.63 -226.35 -12.58% 2,400.00 135-020-50030-000 Social Security Taxes 1,823.02 1,077.33 745.69 40.90% 16,407.18 15,013.16 1,394.02 8.50% 21,885.00 135-020-50035-000 Medicare Taxes 426.32 251.95 174.37 40.90% 3,836.88 3,511.12 325.76 8.49% 5,118.00 135-020-50040-000 Unemployment Taxes 104.95 0.00 104.95 100.00% 944.55 43.66 900.89 95.38% 1,260.00 135-020-50045-000 Workman's Compensation 748.61 886.28 -137.67 -18.39% 6,737.49 7,976.52 -1,239.03 -18.39% 8,987.00 135-020-50060-000 Pre-emp Physicals/Testing 33.32 0.00 33.32 100.00% 299.88 150.00 149.88 49.98% 400.00 135-020-50070-000 Employee Relations 24.99 0.00 24.99 100.00% 224.91 1,167.97 -943.06 -419.31% 300.00 135-020-55080-000 Maintenance & Repairs 11,212.18 8,511.82 2,700.36 24.08% 100,909.62 158,810.18 -57,900.56 -57.38% 134,600.00 135-020-55081-000 Mainten & Repairs Collections 23,407.30 56,602.61 -33,195.31 -141.82% 210,665.70 220,182.90 -9,517.20 -4.52% 281,000.00 135-020-55085-000 Generator Maint. and Repair 749.70 0.00 749.70 100.00% 6,747.30 2,836.29 3,911.01 57.96% 9,000.00 135-020-55090-000 Vehicle Maintenance 383.18 131.71 251.47 65.63% 3,448.62 628.97 2,819.65 81.76% 4,600.00 135-020-55091-000 Veh Maintenance Collections 1,082.90 0.00 1,082.90 100.00% 9,746.10 4,821.21 4,924.89 50.53% 13,000.00 135-020-55105-000 Maintenance-Backhoe/SkidLoader 249.90 0.00 249.90 100.00% 2,249.10 2,435.44 -186.34 -8.29% 3,000.00 135-020-55120-000 Cleaning Services 166.60 161.22 5.38 3.23% 1,499.40 1,612.21 -112.81 -7.52% 2,000.00 135-020-55125-000 Dumpster Services 8,330.00 18,405.72 -10,075.72 -120.96% 74,970.00 74,350.57 619.43 0.83% 100,000.00 135-020-55135-000 Lab Analysis 3,332.00 4,641.60 -1,309.60 -39.30% 29,988.00 35,124.57 -5,136.57 -17.13% 40,000.00 135-020-60010-000 Communications/Mobiles 624.75 375.42 249.33 39.91% 5,622.75 3,376.36 2,246.39 39.95% 7,500.00 135-020-60020-000 Electricity 23,017.28 21,435.25 1,582.03 6.87% 207,155.52 176,849.30 30,306.22 14.63% 276,318.00 135-020-60080-000 Schools & Training 302.37 113.75 188.62 62.38% 2,721.33 2,090.75 630.58 23.17% 3,630.00 135-020-60100-000 Travel & per diem 86.46 0.00 86.46 100.00% 778.14 0.00 778.14 100.00% 1,038.00 135-020-60135-000 TCEQ Fees & Permits 999.60 0.00 999.60 100.00% 8,996.40 9,888.02 -891.62 -9.91% 12,000.00 135-020-60285-000 Lawn Equipment & Maintenance 1,332.80 1,300.00 32.80 2.46% 11,995.20 4,440.00 7,555.20 62.99% 16,000.00 135-020-60331-000 Interfund Transfer Out -Tax l&S 9,683.20 10,567.73 -884.53 -9.13% 87,148.80 95,109.57 -7,960.77 -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% 518,740.65 566,125.92 -47,385.27 -9.13% 691,931.00 135-020-60360-000 Furniture/Equipment < $5000 41.65 0.00 41.65 100.00% 374.85 0.00 374.85 100.00% 500.00 135-020-65005-000 Fuel & Lube 1,041.25 666.94 374.31 35.95% 9,371.25 8,227.36 1,143.89 12.21% 12,500.00 135-020-65010-000 Uniforms 367.76 0.00 367.76 100.00% 3,309.84 2,520.03 789.81 23.86% 4,415.00 135-020-65030-000 Chemicals 2,707.25 0.00 2,707.25 100.00% 24,365.25 19,439.64 4,925.61 20.22% 32,500.00 135-020-65031-000 Chemicals Collections 833.00 0.00 833.00 100.00% 7,497.00 6,002.80 1,494.20 19.93% 10,000.00 135-020-65045-000 Lab Supplies 2,748.90 2,404.92 343.98 12.51% 24,740.10 22,363.21 2,376.89 9.61% 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 147,061.46 -72,507.96 -97.26% 670,981.50 1,078,161.08 -407,179.58 -60.68% 895,000.00 135-020-69008-000 Short Term Debt -Principal 7,144.30 0.00 7,144.30 100.00% 64,298.70 63,804.49 494.21 0.77% 85,766.00 135-020-69009-000 Short Term Debt -Interest 233.32 0.00 233.32 100.00% 2,099.88 1,952.31 147.57 7.03% 2,801.00 135-020-69195-000 GASB Reserve for Replacement 13,809.22 0.00 13,809.22 100.00% 124,282.98 165,777.00 -41,494.02 -33.39% 165,777.00 Total Department: 020 - Wastewater: 290,877.74 362,510.59 -71,632.85 -24.63% 2,617,899.66 3,087,126.92 -469,227.26 -17.92% 3,491,931.00 Department: 026 - Board of Directors 135-026-50045-000 Workman's Compensation I= 1.24 = 0.62 0.62 50.00% II 11.16 50.00% 135-026-60070-000 Dues & Memberships 62.47 0.00 62.47 100.00% 562.23 750.00 -187.77 -33.40% 750.00 135-026-60075-000 Meetings Ilr124.95 - 115.99 8.96 7.17% 1,124.55 1,102.81 21.74 1.93% 135-026-60080-000 Schools & Training 333.20 0.00 333.20 100.00% 2,998.80 535.00 2,463.80 82.16% 4,000.00 7/13/2023 1:52:36 PM Page 3 of 7 17 of 69 Monthly Budget Report 135-026-60100-000 135-026-60245-000 Travel & per diem Miscellaneous Expenses Total Department: 026 - Board of Directors: Department: 030 - Administration 135-030-50005-000 135-030-50010-000 135-030-50016-000 135-030-50020-000 135-030-50026-000 135-030-50027-000 135-030-50028-000 135-030-50029-000 135-030-50030-000 135-030-50035-000 135-030-50040-000 135-030-50045-000 135-030-50060-000 135-030-50070-000 135-030-55030-000 135-030-55070-000 135-030-55080-000 135-030-55085-000 135-030-55120-000 135-030-55160-000 135-030-55205-000 135-030-60005-000 135-030-60010-000 135-030-60020-000 135-030-60025-000 135-030-60035-000 135-030-60040-000 135-030-60050-000 135-030-60055-000 135-030-60070-000 135-030-60079-000 135-030-60080-000 135-030-60100-000 135-030-60245-000 135-030-60285-000 135-030-60360-000 135-030-65010-000 135-030-65055-000 Salaries & Wages Overtime Longevity Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Pre-emp Physicals/Testing Employee Relations Software & Support Independent Labor Maintenance & Repairs Generator Maint. and Repair Cleaning Services Professional Outside Services Utility Billing Contract Telephone Communications/Mobiles Electricity/Gas Water Postage Service Charges & Fees Bad Debt Expense Insurance Dues & Memberships Public Education Schools & Training Travel & per diem Miscellaneous Expenses Lawn Equipment & Maintenance Furniture/Equipment < $5000 Uniforms Hardware June Budget 150 41.65 July 19, 2023 Regular Meeting Agenda Packet For Fiscal: Current Period Ending: 06/30/2023 Variance Variance June Favorable Percent YTD YTD Favorable Percent Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget 0.00 416.50 100.00% 3,748.50 0.00 3,748.50 100.001 5,000.04 0.00 41.65 100.00% 374.85 0.00 374.85 100.00% 500.00 980.01 116.61 863.40 88.10% 8,820.09 2,393.39 6,426.70 72.86% 11,765.00 51,724.13 limisr6,386.29 12.35%7 438,190.43ii 5.87% 620,938.00 166.60 164.44 2.16 1.30% 1,499.40 848.69 650.71 43.40% 2,000.00 201.83 2,422.50 -2,220.67 -1,100.27% 1,816.47 2,422.50 -606.03 -33.36% 2,423.00 6,149.53 5,710.32 439.21 7.14% 55,345.77 52,883.16 2,462.61 4.45% 73,824.00 9,686.95 8,443.63 1,243.32 12.83% 87,182.55 57,397.80 29,784.75 34.16% 116,290.00 504.04 258.61 245.43 48.69% 4,536.36 2,339.51 2,196.85 48.43% 6,051.00 74.88 59.92 14.96 19.98% 673.92 462.81 211.11 31.33% 899.00 199.92 -0.45 200.37 100.23% 1,799.28 3,764.26 -1,964.98 -109.21% 2,400.00 3,229.70 2,841.40 388.30 12.02% 29,067.30 26,028.72 3,038.58 10.45% 38,772.00 755.36 664.53 90.83 12.02% 6,798.24 6,153.21 645.03 9.49% 9,068.00 125.94 0.00 125.94 100.00% 1,133.46 58.55 1,074.91 94.83% 1,512.00 124.61 107.60 17.01 13.65% 1,121.49 968.40 153.09 13.65% 1,496.00 41.65 0.00 41.65 100.00% 374.85 198.45 176.40 47.06% 500.00 333.20 0.00 333.20 100.00% 2,998.80 2,563.57 435.23 14.51% 4,000.00 10,970.61 5,436.99 5,533.62 50.44% 98,735.49 82,949.44 15,786.05 15.99% 131,700.00 1,249.50 135.00 1,114.50 89.20% 11,245.50 5,955.69 5,289.81 47.04% 15,000.00 3,332.00 583.79 2,748.21 82.48% 29,988.00 13,043.75 16,944.25 56.50% 40,000.00 249.90 0.00 249.90 100.00% 2,249.10 0.00 2,249.10 100.00% 3,000.00 999.60 967.35 32.25 3.23% 8,996.40 10,421.74 -1,425.34 -15.84% 12,000.00 6,250.83 55.34 6,195.49 99.11% 56,257.47 72,189.87 -15,932.40 -28.32% 75,040.00 749.70 634.36 115.34 15.38% 6,747.30 5,798.42 948.88 14.06% 9,000.00 499.80 556.62 -56.82 -11.37% 4,498.20 4,269.40 228.80 5.09% 6,000.00 249.90 0.00 249.90 100.00% 2,249.10 0.00 2,249.10 100.00% 3,000.00 2,029.93 903.01 1,126.92 55.52% 18,269.37 12,242.58 6,026.79 32.99% 24,369.00 416.50 453.16 -36.66 -8.80% 3,748.50 3,656.37 92.13 2.46% 5,000.00 2,499.00 1,873.20 625.80 25.04% 22,491.00 18,022.23 4,468.77 19.87% 30,000.00 7,913.50 21,339.07 -13,425.57 -169.65% 71,221.50 105,680.26 -34,458.76 -48.38% 95,000.00 124.95 0.00 124.95 100.00% 1,124.55 48.65 1,075.90 95.67% 1,500.00 7,347.06 8,117.81 -770.75 -10.49% 66,123.54 73,060.29 -6,936.75 -10.49% 88,200.00 541.45 0.00 541.45 100.00% 4,873.05 6,560.55 -1,687.50 -34.63% 6,500.00 3,332.00 1,547.50 1,784.50 53.56% 29,988.00 24,481.33 5,506.67 18.36% 40,000.00 270.72 0.00 270.72 100.00% 2,436.48 277.17 2,159.31 88.62% 3,250.00 132.28 0.00 132.28 100.00% 1,190.52 0.00 1,190.52 100.00% 1,588.00 0.00 0.00 0.00 0.00% 0.00 88.00 -88.00 0.00% 0.00 416.50 469.67 -53.17 -12.77% 3,748.50 2,529.06 1,219.44 32.53% 5,000.00 833.00 0.00 833.00 100.00% 7,497.00 13,052.82 -5,555.82 -74.11% 10,000.00 44.14 0.00 44.14 100.00% 397.26 0.00 397.26 100.00% 530.00 699.72 9,630.71 -8,930.99 -1,276.37% 6,297.48 13,213.55 -6,916.07 -109.82% 8,400.00 7/13/2023 1:52:36 PM Page 4 of 7 18 of 69 Monthly Budget Report 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: June June Budget Activity 499.80 146.67 333.20 451.93 0.00 0.00 333.20 268.42 2,227.10 0.00 127, 864.23 119, 580.94 5,414.50 912.00 2,815.54 0.00 1,077.90 2,163.63 416.50 0.00 Variance Favorable (Unfavorable) 353.13 -118.73 0.00 64.78 2,227.10 8,283.29 4,502.50 2,815.54 -1,085.73 i 416.50 9,724.44 3,075.63 Percent Remaining 70.65% -35.63% 0.00% 19.44% 100.00% 6.48% 83.16% 100.00% -100.73% 100.00% July 19, 2023 Regular Meeting Agenda Packet For Fiscal: Current Period Ending: 06/30/2023 YTD Budget 4,498.20 2,998.80 0.00 2,998.80 20,043.90 1,150,778.07 48,730.50 25,339.86 9,701.10 3,748.50 YTD Activity 3,252.06 4,502.22 74,952.60 2,402.26 26,736.00 1,173,666.37 18,494.00 22,551.10 9,100.15 4,046.00 6,648.81 68.37% 87,519.96 Variance Favorable (Unfavorable) 1,246.14 -1,503.42 -74,952.60 596.54 -6,692.10 -22,888.30 54,191.25 30,236.50 2,788.76 600.95 -297.50 33,328.71 Percent Remaining 27.70% -50.13% 0.00% 19.89% -33.39% -1.99% 62.05% 11.01% 6.19% -7.94% 38.08% Total Budget 6,000.00 4,000.00 0.00 4,000.00 26,736.00 1,534,986.00 65,000.00 33,800.00 12,940.00 5,000.00 116,740.00 977,388.08 1,015,072.46 -37,684.38 -3.86% 8,796,492.72 8,371,298.51 425,194.21 4.83% 11,733,354.00 977, 388.37 1,176,493.03 199,104.66 20.37% 8,796,495.33 7,889,070.98 -907,424.35 -10.32% 11,733,354.00 0.29 161,420.57 161,420.28 2.61 -482,227.53 -482,230.14 0.00 0.29 161,420.57 161,420.28 2.61 -482,227.53 -482,230.14 0.00 7/13/2023 1:52:36 PM Page 5 of 7 19 of 69 Monthly Budget Report July 19, 2023 Regular Meeting Agenda Packet For Fiscal: Current Period Ending: 06/30/2023 Group Summary Variance Variance June June 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,176,493.03 199,104.66 20.37% 8,796,495.33 7,889,070.98 -907,424.35 -10.32% 11,733,354.00 Total Revenue: 977,388.37 1,176,493.03 199,104.66 20.37% 8,796,495.33 7,889,070.98 -907,424.35 -10.32% 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 529,788.69 18,152.97 3.31% 4,931,474.94 4,053,920.58 877,554.36 17.79% 6,577,932.00 290,877.74 362,510.59 -71,632.85 -24.63% 2,617,899.66 3,087,126.92 -469,227.26 -17.92% 3,491,931.00 980.01 116.61 863.40 88.10% 8,820.09 2,393.39 6,426.70 72.86% 11,765.00 127,864.23 119,580.94 8,283.29 6.48% 1,150,778.07 1,173,666.37 -22,888.30 -1.99% 1,534,986.00 9,724.44 3,075.63 6,648.81 68.37% 87,519.96 54,191.25 33,328.71 38.08% 116,740.00 977,388.08 1,015,072.46 -37,684.38 -3.86% 8,796,492.72 8,371,298.51 425,194.21 4.83% 11,733,354.00 977,388.37 1,176,493.03 199,104.66 20.37% 8,796,495.33 7,889,070.98 -907,424.35 -10.32% 11,733,354.00 0.29 161,420.57 161,420.28 2.61 -482,227.53 -482,230.14 0.00 0.29 161,420.57 161,420.28 2.61 -482,227.53 -482,230.14 0.00 7/13/2023 1:52:36 PM 20 of 69 Page 6 of 7 Monthly Budget Report July 19, 2023 Regular Meeting Agenda Packet For Fiscal: Current Period Ending: 06/30/2023 Fund Summary Variance Variance June June Favorable Percent YTD YTD Favorable Percent Fund Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget 135 - MUD 1 General Fund 0.29 161,420.57 161,420.28 2.61 -482,227.53 -482,230.14 0.00 Report Total: 0.29 161,420.57 161,420.28 2.61 -482,227.53 -482,230.14 0.00 7/13/2023 1:52:36 PM 21 of 69 Page 7 of 7 Department Trophy Club Municipal Utility District No. 1 122 - Trophy Club MUD Fire Dept. Asset 000 - Revenue, Asset, Liability, & Equity 1,106,133.57 Liability 000 - Revenue, Asset, Liability, & Equity Equity 000 - Revenue, Asset, Liability, & Equity 135 - MUD 1 General Fund July 19, 2023 Regular Meeting Agenda Packet Balance Sheet Funds 122 - 528 Account Summary As Of 06/30/2023 137 - MUD 1 519 - 2016 Rev 520 - Revenue 528 - 2015 Consolidated Bond Const -SWIFT Bond 16" Revenue Bond GASB Waterline Reserve Fund 10,656,857.80 3,422,146.58 807, 675.11 1,163, 594.99 Total 929,983.46 18,086,391.51 Total Asset: 1,106,133.57 10,656,857.80 3,422,146.58 807,675.11 1,163,594.99 929,983.46 18,086,391.51 -7,880.68 691,547.26 0.00 81,691.15 0.00 0.00 765,357.73 Total Liability: -7,880.68 691,547.26 0.00 81,691.15 0.00 0.00 765,357.73 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,444,729.20 7,889,070.98 436,572.00 20,453.76 40,686.27 29,379.05 9,860,891.26 1,012,518.52 8,371,298.51 0.00 0.00 216,188.21 0.00 9,600,005.24 432,210.68 1,114,014.25 1,106,133.57 -482,227.53 9,965,310.54 10,656,857.80 436,572.00 3,422,146.58 3,422,146.58 20,453.76 725,983.96 807,675.11 -175,501.94 1,163,594.99 1,163,594.99 29,379.05 929,983.46 929,983.46 260,886.02 17,321,033.78 18,086,391.51 Monthly Financial Activity Footnotes: Fund 122 Activity • Daily property tax deposits • Monthly transfer OUT to MUD General Fund to cover Town transfers and any other A/P expenses Fund 135 Activity • Daily property tax deposits • All A/P checks are cut through the General Fund • Monthly transfer IN to cover other fund A/P expenses • Monthly transfer OUT for l&S Revenue Bond payments for Fund 534, 535, & 536 • Monthly bank interest Fund 137 Activity • Transfer IN at beginning of fiscal year based on yearly budget and transfer OUT at fiscal year-end based on reserves balances Fund 519 Activity • Monthly bank interest Fund 520 Activity • Transfer OUT to MUD General Fund to cover Interconnect Waterline construction project expenses • Monthly bank interest Fund 528 Activity • Monthly bank interest 7/13/2023 2:12:12 PM 22 of 69 Page 1 of 1 TROPHY CLUB WONEMPAL UTILETY 1 r T 1.Frr Department Trophy Club Municipal Utility District No. 1 533- MUD 1I&S 534-2015 Consolidated Revenue Bond I&S Asset 000 - Revenue, Asset, Liability, & Equity 970,739.99 535 - 2016 Rev Bond I&S-SWIFT 437,669.51 207, 5 98.23 536 - 2019 Rev Bond I&S- W&WW System July 19, 2023 Regular Meeting Agenda Packet Balance Sheet I&S Funds 533 - 536 Account Summary As Of 06/30/2023 Total 207,941.02 1,823,948.75 Total Asset: 970,739.99 437,669.51 207, 5 98.23 207,941.02 1,823,948.75 Liability 000 - Revenue, Asset, Liability, & Equity 34,852.36 0.00 0.00 0.00 34,852.36 Total Liability: 34,852.36 Equity 000 - Revenue, Asset, Liability, & Equity Total Total Beginning Equity: Total Revenue Total Expense Revenues Over/Under Expenses Total Equity and Current Surplus (Deficit): Total Liabilities, Equity and Current Surplus (Deficit): 4,145.11 0.00 0.00 27,958.35 6,554.77 0.00 34,852.36 1,429.17 40,087.40 4,145.11 1,006,321.35 74,578.83 27,958.35 502,029.91 92,318.75 6,554.77 1,429.17 228,812.71 27,769.25 313,780.60 107,268.75 40,087.40 2,050,944.57 301,935.58 931,742.52 935,887.63 970,739.99 409,711.16 437,669.51 437,669.51 201,043.46 207,598.23 207,598.23 206,511.85 207,941.02 207,941.02 1,749,008.99 1,789,096.39 1,823,948.75 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 7/13/2023 2:20:38 PM 23 of 69 Page 1 of 1 July 19, 2023 Regular Meeting Agenda Packet CASH STATUS AS OF JUNE 2023 TexPool 0 & M (XXXXX0002)-Fire Operating Cash Restricted - Unable to be spent Unrestricted- Available for spending Total in Accounts (Restricted & Unrestricted) 135-10250 TexPool 0 & M (XXXXX0002)-General Fund Operating *** Prosperity Bank (XXX8701) Fire Operating $0 $2,625,469 $2,625,469 135-10300 Prosperity Bank (XXX8701) General Fund Operating * $141,630 $4,562,556 $4,704,186 135-10305 Prosperity Bank Reserve -Savings Acct (XXXXX7724) $1,918,195 $0 $1,918,195 135-11100 Petty Cash Administration $0 $150 $150 135-11150 Petty Cash Utility Billing $0 $450 $450 137-10250 TexPool 0 & M (XXXXX0002) GASB Replacement $3,422,147 $0 $3,422,147 519-10250 Texpool Revenue Bond Construction (XXXXX015) SWIFT $0 $0 $0 51 9-1 11 55 Cash -Bond Escrow Bank of Texas (SWIFT) $807,675 $0 $807,675 520-10250 Texpool Revenue Bond Water & Waste Water Systems 2019 (XXXXX018) $1,163,595 $0 $1,163,595 520-10300 Prosperity Bank Construction Water & Waste Water Systems 2019 $0 $0 $0 528-10250 TexPool Revenue Bond Reserve (XXXXX014) WWTP Improvements $929,983 $0 $929,983 533-10250 TexPool Tax I & S (XXXXX0003) $983,704 $0 $983,704 533-10300 Prosperity Bank (XXX8701) Tax I&S $0 $0 $0 534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements $437,670 $0 $437,670 535-10250 Texpool Revenue I & S (XXXXX017) SWIFT $207,598 $0 $207,598 536-10250 TexPool Revenue I & S (XXXXX020) Water & Waste Water Systems $207,941 $0 $207,941 $7,188,625 $17,408,763 Amount available in cash for spending (MUD Accounts) *6/30/2023 Customer Water Deposits $141,630 Fire Department Cash $7,188,625 122-10250 TexPool 0 & M (XXXXX0002)-Fire Operating Cash $0 $911,454 $911,454 122-10300 Prosperity Bank (XXX8701) Fire Operating $0 $191,028 $191,028 $0 $1,102,482 $1,102,482 Amount available in cash for spending (Fire Department Accounts) Total General Fund 135 Available for Spending $1,102,482 General Fund 135 Available $ 4,562,556 Prosperity General Fund $ 2,625,469 Texpool General Fund $ 600 Petty Cash $ 7,188,625 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 $ (482,228) Total Nonspendable, Assigned & Committed Fund Balances - General Fund 135 $9,965,311 24 of 69 ebills Bills Mailed Bank Draft Credit Card Draft Online Payments Late Notices Disconnects Connections MUD Connections PID July 19, 2023 Regular Meeting Agenda Packet June Utility Billing Report Fiscal Year 2022 - 2023 June 2022 July 2022 August 2022 September 2022 October 2022 November 2022 December 2022 January 2023 February 2023 March 2023 April 2023 May 2023 June 2023 1,566 1,592 1,629 1,654 1,667 1,710 1,746 1,765 1,777 1,773 1,767 1,794 1,766 3,882 3,872 3,850 3,832 3,822 3,801 3,768 3,741 3,751 3,744 3,743 3,734 3,755 700 697 704 703 706 711 630 606 599 599 590 588 589 1,456 1,471 1,484 1,481 1,501 1,494 2,251 2,540 2,719 3,016 2,998 2,754 3,134 1,188 1,220 1,170 1,203 1,159 1,049 339 387 310 326 337 0 0 0 547 413 289 290 327 4 7 5 2 0 4 0 0 0 0 8 9 9 3401 3401 3398 3399 3399 3399 3399 3394 3394 3394 3394 3394 3395 1443 1443 1443 1444 1444 1444 1444 1444 1443 1443 1443 1443 1443 June 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 69 FOR IMMEDIATE RELEASE June 30, 2023 July 19, 2023 Regular Meeting Agenda Packet For more information, contact: Technical Services Center Phone: (312) 977-9700 Fax: (312) 977-4806 E-mail: budgetawardsAgfoa.org (Chicago, Illinois) --Government Finance Officers Association is pleased to announce that Trophy Club Municipal Utility District No. 1, Texas, has received GFOA's Distinguished Budget Presentation Award for its budget. The award represents a significant achievement by the entity. It reflects the commitment of the governing body and staff to meeting the highest principles of governmental budgeting. In order to receive the budget award, the entity had to satisfy nationally recognized guidelines for effective budget presentation. These guidelines are designed to assess how well an entity's budget serves as: • a policy document • a financial plan • an operations guide • a communications device Budget documents must be rated "proficient" in all four categories, and in the fourteen mandatory criteria within those categories, to receive the award. When a Distinguished Budget Presentation Award is granted to an entity, a Certificate of Recognition for Budget Presentation is also presented to the individual(s) or department designated as being primarily responsible for having achieved the award. This has been presented to Finance Department. There are over 1,700 participants in the Budget Awards Program. The most recent Budget Award recipients, along with their corresponding budget documents, are posted quarterly on GFOA's website. Award recipients have pioneered efforts to improve the quality of budgeting and provide an excellent example for other governments throughout North America. Government Finance Officers Association (GFOA) advances excellence in government finance by providing best practices, professional development, resources and practical research for more than 22,500 members and the communities they serve. 26 of 69 July 19, 2023 Regular Meeting Agenda Packet 0 GOVERNMENT FINANCE OFFICERS ASSOCIATION Distinguished Budget Presentation Award PRESENTED TO Trophy Club Municipal Utility District No. 1 Texas For the Fiscal Year Beginning October 01, 2022 GA ' "41 4 ' p 2)1 6. v f A 11 Executive Director 27 of 69 IWHEN EXPERIENCE, REPUTATION AND PERFORMANCE MATTER 1?3 PERDUE BRANDON FIELDERCOLLINS&MOTT LLP ATTORNEYS AT LAW July 19, 2023 Regular Meeting Agenda Packet COLLECTION REPORT TO THE TROPHY CLUB MUNICIPAL UTILITY DISTRICT No. 1 Submitted by: Alison Callison /Andrew Brink 500 East Border Street, Suite 640 Arlington, Texas 76010 www.pbfcm.com July 2023 28 of 69 2021 TAX YEAR ANALYSIS Delinquent Turnover Original Tax Levy Adj. Delinquent July 1, 2022 Turnover • $2,039,976 • $18,247 • 0.89 July 19, 2023 Regular Meeting Agenda Packet 0 • Collected • Delinquent 99.11 % 0.89% Source: Denton County Tax O0f Year -To -Date Summary Reports. 2 Perdue Brandon Fielder Collins & Mott, LLP July 19, 2023 Regular Meeting Agenda Packet r 2021 TAX YEAR — DELINQUENT COLLECTIONS N July 1, 2022 - June 30, 2023 Adj. July 1 Turnover Base Tax Collected Base Tax Remaining • $18,247 • $15,435 • 84.59% • $2,812 Base Tax Only - No Penalties or Interest Added $2,812 Collected $15,435 Source: Denton County Tax Office, Year -To -Date Summary Reeotrs6 urnover Accounts for Adjustments and Refunds. Base Taxes Only - No Penalties or Interest Added. Perdue Brandon Fielder Collins & Mott, LLP 2022 TAX YEAR ANALYSIS Delinquent Turnover Original Tax Levy Adj. Delinquent July 1, 2023 Turnover • $1,959,930 • $20,923 • 1.07% July 19, 2023 Regular Meeting Agenda Packet o ■ Collected ■ Delinquent 98.93% 1.07% Source: Denton County Tax Of iF8f Year -To -Date Summary Reports. 4 Perdue Brandon Fielder Collins & Mott, LLP July 19, 2023 Regular Meeting Agenda Packet P13 ACCOUNT BREAKDOWN CHART In Trust, $0.90, 0.0% In Bankruptcy, $236.41, 0.8% In Deferral, $11,132.58, 38.9% Action Pending, $13,253.71, 46.3% In Litigation, $2,387.87, 1,00o 8.3% In Uncollectable, $1,621.02, 5.7% As of 7/6/2023 - Total Base Tax: $28,632 (2022 Tax Year & Prior) Action Pending Accounts: Notification Letters, Telephone GAIBptigns, Lienholder Notification, Title Research, Property Inspection and Payment Agreements. Source: Perdue Brandon tape download on 4/5/23 from the Denton County Tax Office. July 19, 2023 Regular Meeting Agenda Packet rtIPERDUE BRANDON FIELdERCOLLINS&M07T LLP ATTORNEYS AT LAW AT LAW AUTHORITY ACTIVITY ANALYSIS TROPHY CLUB MUNICIPAL UTILITY DISTRICT #1 As Of 7/6/2023, Tax Years Between 1997 And 2022 Description # Properties Pct Of Total Base Tax Amount Pct Of Total In Bankruptcy In Trust In Deferral In Litigation In Uncollectable Action Pending 1 2 7 5 19 68 0.98% 1.96% 6.86% 4.90% 18.63% 66.67% $236.41 $0.90 $11,132.58 $2,387.87 $1,621.02 $13,253.71 0.83% 0.00% 38.88% 8.34% 5.66% 46.29% Totals 102 100.00% $28,632.49 100.00% Dollar Range # Properties Pct Of Total Base Tax Amount Pct Of Total $0.01 - $100.00 $100.01 - $250.00 $250.01 - $500.00 $ 500.01 - $1000.00 $1000.01 - $2500.00 $2500.01 - $5000.00 Totals 60 10 15 3 7 2 97 61.86% 10.31% 15.46% 3.09% 7.22% 2.06% 100.00% $1,404.92 $1,753.38 $4,772.52 $1,947.17 $11,229.17 $7,525.33 $28,632.49 4.91% 6.12% 16.67% 6.80% 39.22% 26.28% 100.00% Year # Transaction Pct Of Total Base Tax Amount Pct Of Total 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2 2 6 8 10 10 7 9 11 13 17 23 57 1.14% 1.14% 3.43% 4.57% 5.71% 5.71% 4.00% 5.14% 6.29% 7.43% 9.71% 13.14% 32.57% $763.40 $691.68 $597.90 $786.42 $858.30 $502.72 $485.79 $979.73 $1,954.33 $2,109.84 $2,524.12 $2,887.95 $13,490.31 2.67% 2.42% 2.09% 2.75% 3.00% 1.76% 1.70% 3.42% 6.83% 7.37% 8.82% 10.09% 47.12% Totals 175 100.00% $28,632.49 100.00% **Number of properties may differ in the first two sections because a property may reside in more than one category in the first section. 33 of 69 Top Tax Due Report July 19, 2023 Regular Meeting Agenda Packet Top 100 Percent Properties - TROPHY CLUB MUNICIPAL UTILITY DISTRICT #1 GEO Code Legal Description 71012DEN TROPHY CLUB #10 LOT 1219 ACRES: 0.235000 D Taxpayer # Taxpayer Name Years Tax Due Total Due 968 BOREN BENJAMIN C & BEVERLY C 2010-2021 $4,447.01 $6,230.74 71779DEN TROPHY CLUB # 2 LOT 77 ACRES: 0.253600 D Taxpayer # Taxpayer Name Years Tax Due Total Due 91176 PARROW JAMES J & ELENA 2017-2021 $2,040.02 $2,385.28 72277DEN TROPHY CLUB # 3 LOT 174 ACRES: 0.256100 D Taxpayer # Taxpayer Name Years Tax Due Total Due 914 MORTON DENVER & JANIE 2018-2021 $1,526.13 $2,045.39 650109DEN PERSONAL PROPERTY - DENTIST LOCATION: 925 TROPHY CLUB DR L Taxpayer # Taxpayer Name Years Tax Due Total Due 90829 MEMBERS ONLY DENTAL PA 2018-2021 $1,476.01 $2,613.89 11514221TAR DIEGO'S TEX MEX KITCHEN PERSONAL PROPERTY TANGIBLE L Taxpayer # Taxpayer Name Years Tax Due Total Due 59 SUMMERS, JAMES M 2010-2014 $1,355.94 $3,918.14 70173DEN TROPHY CLUB OAK HILL LOT 15 ACRES: 0.164400 D Taxpayer # Taxpayer Name Years Tax Due Total Due 91396 RYAN BRUCE E & SHELIA A 2018-2021 $1,221.82 $1,403.04 526096DEN CHURCHILL DOWNS BLK A LOT 1 ACRES: 0.258300 Taxpayer # Taxpayer Name Years Tax Due Total Due 895 SEAY MARK SR & TERRI 2020 $408.72 $696.46 620602DEN PERSONAL PROPERTY - DENTIST OFFICE LOCAITON : 301 TROPHY LAKE L Taxpayer # Taxpayer Name Years Tax Due Total Due 1560 BURGAR BRANDON 2013-2014 $310.41 $817.45 926478DEN PERSONAL PROPERTY - CHIROPRACTOR LOCATION : 100 TROPHY CLUB L Taxpayer # Taxpayer Name Years Tax Due Total Due 1242 FORD LESLIE 2012-2017 $304.07 $731.85 11514205TAR WEINBERGERS DELICATESSEN PERSONAL PROPERTY TANGIBLE Taxpayer # Taxpayer Name Years Tax Due Total Due 58 WEINBERGER DELI TWO LLC 2016-2019 $297.12 $597.62 339971DEN PERSONAL PROPERTY - AIRCRAFT CESSNA 150L 1972-N5428Q L Taxpayer # Taxpayer Name Years Tax Due Total Due 759 - MORRISON AVIATION LLC 2012-2021 $279.26 $624.63 71082DEN TROPHY CLUB #10 LOT 1249 ACRES: 0.286000 Taxpayer # Taxpayer Name 93518 - CULPEPPER LEE & ADRIANNE BEHR Years Tax Due Total Due 2021 $255.08 $397.92 72034DEN TROPHY CLUB # 4 LOT 333 ACRES: 0.361600 B Taxpayer # Taxpayer Name Years Tax Due Total Due 1219 BINGHAM GENE C 2021 $236.41 $368.80 676474DEN PERSONAL PROPERTY - DRY CLEANERS LOCATION: 2003 SH 114 STE 390 Taxpayer # Taxpayer Name Years Tax Due Total Due 90856 J.A.E.H.K. INC 2018-2021 $139.49 $247.52 776375DEN PERSONAL PROPERTY - ACCOUNTING AUDITING & BOOKKEEPING Taxpayer # Taxpayer Name Years Tax Due Total Due 92697 KENNETH ARMSTRONG 2020-2021 $119.85 $195.67 42641576TAR KNOLLS AT SOLANA BLOCK B LOT 23 ACRES: 0.247900 Taxpayer # Taxpayer Name 93256 MAYA WALDEMAR Years Tax Due Total Due 2021 $91.87 $143.32 14690069TAR THE CELL SPA/MCKENNA ORTHOPEDI PERSONAL PROPERTY TANGIBLE Taxpayer # Taxpayer Name Years Tax Due Total Due 92192 MCKENNA OTHOPAEDIC AND SPORT MEDICINE PA 2021 $87.95 $137.20 42616725TAR WESTLAKE ENTRADA BLOCK C LOT 1B SCHOOL BOUNDARY SPLIT Taxpayer # Taxpayer Name 92381 AMR WESTLAKE STORAGE LLC Years Tax Due Total Due 2021 $72.68 $113.38 34 of 69 Page 1 336365DEN PERSONAL PROPERTY - LEASED VEHICLES Taxpayer # Taxpayer Name 92366 MOTORLEASE CORPORATION July 19, 202aRegular MeetingAgenda IeakDGe 2020 $58.53 S99.74 469054DEN PERSONAL PROPERTY - RETAIL STORE LOCATION: 301 TROPHY LAKE Taxpayer # Taxpayer Name Years Tax Due Total Due 1184 VERIZON 2012-2013 $55.46 $153.96 336817DEN PERSONAL PROPERTY - DRY CLEANERS DROP OFF LOCATION : 2003 SH Taxpayer # Taxpayer Name Years Tax Due Total Due 1164 WALJI SHANIF M 2014-2015 $45.93 $114.36 568122DEN PERSONAL PROPERTY - LEASED VEHICLES Taxpayer # Taxpayer Name Years Tax Due Total Due 92441 VCFS AUTO LEASING COMPANY 2020 $40.41 $55.28 14318755TAR DYNAMIC ACTION PERSONAL PROPERTY TANGIBLE COMMERCIAL Taxpayer # Taxpayer Name 92920 DYNAMIC ACTION INC Years Tax Due Total Due 2021 $36.66 $57.19 633172DEN PERSONAL PROPERTY - AUDIOLOGISTS LOCATION: 501 TROPHY LAKE Taxpayer # Taxpayer Name Years Tax Due Total Due 1730 EARCARE HEARING AIDS 2014-2015 $35.18 $87.60 14834401TAR SIP STIR COFFEE HOUSE PERSONAL PROPERTY TANGIBLE Taxpayer # Taxpayer Name Years Tax Due Total Due 93859 HARIKRUSHNA CAFE LLC 2021 $29.22 $41.38 14265180TAR FUSE ENERGY LLC PERSONAL PROPERTY TANGIBLE COMMERCIAL Taxpayer # Taxpayer Name 91517 FUSE ENERGY LLC Years Tax Due Total Due 2021 $26.93 $42.01 563646DEN PERSONAL PROPERTY - MISC PERSONAL SERVICE LOCATION: 2003 SH Taxpayer # Taxpayer Name Years Tax Due Total Due 1711 STYLES OF INDIA 2015-2016 $20.23 $47.47 499622DEN PERSONAL PROPERTY - HAIR SALON LOCATION: 2001 W SH 114, STE Taxpayer # Taxpayer Name Years Tax Due Total Due 1530 DESIRE SALON & SPA 2013 $16.51 $44.78 723199DEN PERSONAL PROPERTY - INSURANCE AGENT LOCATION: 2101 SH 114 STE Taxpayer # Taxpayer Name Years Tax Due Total Due 91433 MILLER CRAIG 2019-2021 $14.45 $24.67 682747DEN PERSONAL PROPERTY - RESTAURANT LOCATION: 301 TROPHY LAKE Taxpayer # Taxpayer Name 91619 7 MILES TASTE GROUP INC Years Tax Due Total Due 2019 $14.43 $26.67 676479DEN PERSONAL PROPERTY - DANCE & MUSIC LESSONS LOCATION: 905 Taxpayer # Taxpayer Name Years Tax Due Total Due 90858 FULLER CHRISTINA 2020-2021 $14.38 $23.47 13442112TAR HEART TEST LABORATORIES PERSONAL PROPERTY TANGIBLE Taxpayer # Taxpayer Name Years Tax Due Total Due 91068 HEART TEST LABORATORIES INC 2017-2019 $12.32 $23.68 72303DEN TROPHY CLUB # 6 LOT 528 ACRES: 0.266100 Taxpayer # Taxpayer Name 91664 TABER JOHN K Years Tax Due Total Due 2020 $9.15 $14.93 676473DEN PERSONAL PROPERTY - PERSONAL TRAINER SERVICES LOCATION: 2003 Taxpayer # Taxpayer Name Years Tax Due Total Due 90855 THE FORCE BY LUKE 2021 $5.96 $9.30 72060DEN TROPHY CLUB # 6 LOT 499 ACRES: 0.384000 D Taxpayer # Taxpayer Name Years Tax Due Total Due 76 MCDONALD JAMES E & HUESTIS LAURA LEA TR 2016-2018 $5.76 $7.31 659388DEN PERSONAL PROPERTY - BUSINESS SERVICES LOCATION: 99 TROPHY Taxpayer # Taxpayer Name 91141 CHIP MUNDY INC Years Tax Due Total Due 2017 $4.85 $10.36 566115DEN PERSONAL PROPERTY - BUSINESS SERVICES LOCATION: 99 TROPHY Taxpayer # Taxpayer Name Years Tax Due Total Due 1555 DONNA & ASSOCIATES 2013 $4.40 $11.93 679913DEN PERSONAL PROPERTY - OFFICE LOCATION: 99 TROPHY CLUB DR Taxpayer # Taxpayer Name Years Tax Due Total Due 91389 SMITH CLINICAL SERVICES PLLC 2019 $4.31 $7.96 35 of 69 Page 2 659398DEN PERSONAL PROPERTY - BUSINESS SERVICES LOCATION: 99 TROPHY Taxpayer # Taxpayer Name July 19, 202aRegular MeetingoAgenda tP tak tie 90372 RAY DERSTEIN 2015 S3.61 58.75 701746DEN PERSONAL PROPERTY - OFFICE LOCATION: 99 TROPHY CLUB DR Taxpayer # Taxpayer Name 93483 GRAY CAROL Years Tax Due Total Due 2021 $3.50 $5.46 13730967TAR RANDSTAD RANDSTAD US LP PERSONAL PROPERTY TANGIBLE Taxpayer # Taxpayer Name Years Tax Due Total Due 90303 RANDSTAD US LP 2014-2015 $2.76 $6.76 727270DEN PERSONAL PROPERTY - INSURANCE OFFICE LOCATION: 100 INDIAN Taxpayer # Taxpayer Name Years Tax Due Total Due 92609 FOLEY BEVERLY 2020-2021 $1.98 $3.23 943642DEN PERSONAL PROPERTY - BUSINESS SVCS LOCATION: 100 INDIAN CREEK Taxpayer # Taxpayer Name 91198 ERIC RANSLEBEN Years Tax Due Total Due 2021 $1.86 $2.90 335713DEN PERSONAL PROPERTY - OFFICE LOCATION: 99 TROPHY CLUB DR, Taxpayer # Taxpayer Name 1329 HELM INSURANCE AGENCY Years Tax Due Total Due 2012 $0.87 $2.48 314763DEN PERSONAL PROPERTY - LEASED EQUIPMENT Taxpayer # Taxpayer Name Years Tax Due Total Due 298 NORTHERN LEASING SYSTEMS INC 2020 $0.68 $1.16 14461451 TAR DELL MARKETING LP VARX COMMERCIAL Taxpayer # Taxpayer Name 91207 DELL MARKETING LP Years Tax Due Total Due 2016 $0.61 $1.30 624324DEN A0821A J.R. MICHAEL TR 1A(2) .09 ACRES ACRES: 0.090000 Taxpayer # Taxpayer Name 1628 TROPHY CLUB TOWN OF Years Tax Due Total Due 2014 $0.48 $1.23 624325DEN A0821A J.R. MICHAEL TR 1A(3) .081 ACRES ACRES: 0.081000 Taxpayer # Taxpayer Name Years Tax Due Total Due 1628 TROPHY CLUB TOWN OF 2014 $0.42 $1.08 42345560TAR WESTLAKE ENTRADA BLOCK I LOT 13 REF PLAT D218192054 Taxpayer # Taxpayer Name 91351 JJP TREVI LLC Years Tax Due Total Due 2018 $0.19 $0.38 14381350TAR SONIFI SOLUTIONS INC VARX COMMERCIAL Taxpayer # Taxpayer Name 1290 SONIFI SOLUTIONS INC Years Tax Due Total Due 2015 $0.15 $0.33 13661787TAR NATIONAL DEFAULT TITLE PERSONAL PROPERTY TANGIBLE Taxpayer # Taxpayer Name Years Tax Due Total Due 1638 NATIONAL DEFAULT TITLE SERVICE 2017 $0.07 $0.15 14448870TAR NEOPOST USA INC VARX COMMERCIAL Taxpayer # Taxpayer Name 91049 NEOPOST USA INC Years Tax Due Total Due 2015 $0.04 $0.09 71098DEN TROPHY CLUB # 8 LOT 644 ACRES: 0.202400 Taxpayer # Taxpayer Name 90923 KIRKPATRICK GINGER G Years Tax Due Total Due 2021 $0.03 $0.04 198454DEN LAKES OF TROPHY CLUB PH 1 BLK 5 LOT 11 ACRES: 0.160300 Taxpayer # Taxpayer Name Years Tax Due Total Due 91092 VILORIA PHILIP A & JOANNE 2019 $0.01 $0.02 308380DEN EAGLES RIDGE PH II BLK B LOT 5 ACRES: 0.305700 Taxpayer # Taxpayer Name 91720 HAFIZ ARIF & FATIMA LIVING TRUST Years Tax Due Total Due 2020 $0.01 $0.02 36 of 69 Page 3 July 19, 2023 Regular Meeting Agenda Packet Top Tax Due Report Top 100 Percent Properties - TROPHY CLUB MUNICIPAL UTILITY DISTRICT #1 GEO Code Legal Description 42110660TAR GRANADA BLOCK A LOT 79 ACRES: 0.562500 Taxpayer # Taxpayer Name Years Tax Due Total Due 92378 LOVELACE DILLON DON 2022 $2,661.31 $3,768.42 631100DEN THE HIGHLANDS AT TROPHY CLUB NHD 4 -THE ISLE OF TURNBERRY Taxpayer # Taxpayer Name Years Tax Due Total Due 90822 BARBARIN REGINALD ANTHONY & LASHARNDR 2022 $1,231.83 $1,744.27 42424591TAR WESTLAKE ENTRADA BLOCK I LOT 4R ACRES: 0.025200 Taxpayer # Taxpayer Name Years Tax Due Total Due 94192 HART JUSTIN W AND HART JENNY -RAE 2022 $1,009.13 $1,428.93 661454DEN CANTERBURY HILLS PHASE 3 BLK F LOT 20 ACRES: 0.278900 Taxpayer # Taxpayer Name Years Tax Due Total Due 94052 HARRISON CARL O & KATRINA A 2022 $931.33 $1,318.76 187337DEN EAGLES RIDGE PH I LOT 9 ACRES: 0.350400 Taxpayer # Taxpayer Name Years Tax Due Total Due 92229 DICKSON HOLLY & DAVID 2022 $511.41 $724.16 72262DEN TROPHY CLUB # 7 LOT 465 ACRES: 0.588300 Taxpayer # Taxpayer Name 91660 THOMAS WILLIAM V & DEBORAH A TRS WILLIAM Years Tax Due Total Due 2022 $504.43 $714.27 726634DEN TROPHY CLUB TOWN CENTER ADDITION BLK A LOT 31 ACRES: 0.154900 Taxpayer # Taxpayer Name Years Tax Due Total Due 93804 ATWOOD JON & MICHELLE LYNN 2022 $437.05 $618.86 71012DEN TROPHY CLUB #10 LOT 1219 ACRES: 0.235000 Taxpayer # Taxpayer Name 968 BOREN BENJAMIN C & BEVERLY C Years 2022 D Tax Due $417.01 Total Due $425.68 71779DEN TROPHY CLUB # 2 LOT 77 ACRES: 0.253600 Taxpayer # Taxpayer Name 91176 PARROW JAMES J & ELENA Years 2022 D Tax Due $401.91 Total Due $410.27 72277DEN TROPHY CLUB # 3 LOT 174 ACRES: 0.256100 D Taxpayer # Taxpayer Name Years Tax Due Total Due 914 MORTON DENVER & JANIE 2022 $367.29 $374.93 72317DEN TROPHY CLUB # 6 LOT 554 ACRES: 0.232600 Taxpayer # Taxpayer Name 94084 DEVELOPMENT BY S&W LLC Years Tax Due Total Due 2022 $349.83 $495.36 72595DEN TROPHY CLUB # 3 LOT 222 ACRES: 0.252600 Taxpayer # Taxpayer Name Years Tax Due Total Due 1588 BOICE SHON 2022 $337.13 $477.38 40758281TAR TROPHY CLUB # 9 LOT 723 ACRES: 0.236200 D Taxpayer # Taxpayer Name Years Tax Due Total Due 93245 PARKER CHARLES J AND PARKER SYLVIA A 2022 $337.04 $344.05 20446248DEN LINES & APP TROPHY CLUB MUD #1 Taxpayer # Taxpayer Name 92971 - ONCOR ELECTRIC DELIVERY CO Years Tax Due Total Due 2022 $325.88 $461.45 650109DEN PERSONAL PROPERTY - DENTIST LOCATION: 925 TROPHY CLUB DR L Taxpayer # Taxpayer Name Years Tax Due Total Due 90829 MEMBERS ONLY DENTAL PA 2022 $320.50 $453.83 40757978TAR TROPHY CLUB # 3 LOT 245 ACRES: 0.340700 Taxpayer # Taxpayer Name 92372 - CABALLERO JUAN CARLOS Years Tax Due Total Due 2022 $314.69 $445.60 71140DEN Taxpayer # 94075 TROPHY CLUB # 8 LOT 655 ACRES: 0.196700 Taxpayer Name PAGE DAVID HOGAN & PAGE AARON COOPER Years Tax Due Total Due 2022 $280.41 $397.06 70173DEN TROPHY CLUB OAK HILL LOT 15 ACRES: 0.164400 D Taxpayer # Taxpayer Name Years Tax Due Total Due 91396 RYAN BRUCE E & SHELIA A 2022 $278.59 $284.38 37 of 69 Page 1 189787DEN Taxpayer # 90619 LAKESIDE AT TROPHY CLUB BLK B LOT 1 ACRES: 0.229400 July 19, 2023 Regular Meeting Agenda Packet Taxpayer Name WILLIAMS JEFFREY 0 & LARISSA Years 2022 Tax Due Total Due $270.58 $383.14 991059DEN Taxpayer # 94161 PERSONAL PROPERTY - RESTAURANT/BAR LOCATION: 2230 SH 114 STE Taxpayer Name Years BLUE 22 SPORTS GRILL 2022 Tax Due Total Due $265.25 $375.59 929539DEN Taxpayer # 277 PERSONAL PROPERTY - DRY CLEANERS LOCATION: 301 TROPHY LAKE Taxpayer Name Years TROPHY CLUB CLEANERS 2022 Tax Due Total Due $231.32 $327.55 330332DEN PERSONAL PROPERTY - LEASED VEHICLES Taxpayer # Taxpayer Name 92860 ENTERPRISE FM TRUST Years 2022 Tax Due Total Due $219.49 $297.63 72180DEN Taxpayer # 1585 TROPHY CLUB # 3 LOT 154 ACRES: 0.520600 Taxpayer Name HALL TERRY & TAEKO Years 2022 Tax Due Total Due $172.04 $235.35 42641584TAR KNOLLS AT SOLANA BLOCK B LOT 24 ACRES: 0.247900 Taxpayer # Taxpayer Name 93257 LULLA SONIA AND LULLA RAJIV NAND Years 2022 Tax Due Total Due $113.22 $160.32 42641690TAR KNOLLS AT SOLANA BLOCK C LOT 5 ACRES: 0.216900 Taxpayer # 93995 Taxpayer Name KAUSER RICKY Years 2022 Tax Due Total Due $99.06 $140.27 71905DEN Taxpayer # 94204 TROPHY CLUB # 2 LOT Taxpayer Name FLANIGAN WILLIAM D 97 ACRES: 0.352400 Years TRUSTEE OF THE WILLIA 2022 Tax Due Total Due $92.44 $126.46 72496DEN Taxpayer # 91487 TROPHY CLUB # 6 LOT Taxpayer Name HICKS JAMES 0 545 ACRES: 0.284400 Years 2022 D Tax Due Total Due $90.00 $90.38 991060DEN Taxpayer # 94162 PERSONAL PROPERTY - BAGEL SHOP LOCATION: 301 TROPHY LAKE DR Taxpayer Name Years DAN'S BAGELS 2022 Tax Due Total Due $88.42 $125.20 991023DEN Taxpayer # 94160 PERSONAL PROPERTY - RESTAURANT LOCATION: 2550 BOBCAT BLVD Taxpayer Name Years MARCO'S PIZZA 2022 Tax Due Total Due $85.58 $121.18 42641576TAR KNOLLS AT SOLANA BLOCK B LOT 23 ACRES: 0.247900 Taxpayer # Taxpayer Name 93256 MAYA WALDEMAR Years 2022 Tax Due Total Due $79.25 $112.22 14690069TAR Taxpayer # 92192 THE CELL SPA/MCKENNA ORTHOPEDI PERSONAL PROPERTY Taxpayer Name MCKENNA OTHOPAEDIC AND SPORT MEDICINE PA Years 2022 Tax Due Total Due $75.87 $107.43 12705160TAR Taxpayer # 91514 CAVOK SOLUTIONS PERSONAL PROPERTY TANGIBLE COMMERCIAL Taxpayer Name MERCER MANAGEMENT CONSULTING Years 2022 Tax Due Total Due $73.26 $103.74 42641746TAR Taxpayer # 94191 KNOLLS AT SOLANA BLOCK C LOT 10 ACRES: 0.216900 Taxpayer Name CHERUKURI VIJAY Years 2022 Tax Due Total Due $69.34 $98.19 42616725TAR Taxpayer # 92381 WESTLAKE ENTRADA BLOCK C LOT 1B SCHOOL BOUNDARY SPLIT Taxpayer Name AMR WESTLAKE STORAGE LLC Years 2022 Tax Due Total Due $62.70 $88.78 42447052TAR Taxpayer # 93987 WESTLAKE ENTRADA BLOCK A LOT 1R ACRES: 0.163600 Taxpayer Name POLARIS LLC Years Tax Due Total Due 2022 $52.08 $73.75 776375DEN Taxpayer # 92697 PERSONAL PROPERTY - ACCOUNTING AUDITING & BOOKKEEPING Taxpayer Name KENNETH ARMSTRONG Years 2022 Tax Due Total Due $51.24 $72.56 14836446TAR Taxpayer # 93910 COASTAL BROKERS INSURANCE INC PERSONAL PROPERTY TANGIBLE Taxpayer Name Years COASTAL BROKERS INSURANCE INC 2022 Tax Due Total Due $45.19 $63.99 14795472TAR ONCOR ELECTRIC DELIVERY CO L VARX UTILITY ELECTRIC Taxpayer # Taxpayer Name 92947 ONCOR ELECTRIC DELIVERY CO LLC Years Tax Due Total Due 2022 $37.70 $53.38 38 of 69 Page 2 338668DEN Taxpayer # 90713 PERSONAL PROPERTY - LEASED EQUIPMENT Taxpayer Name ROYAL CUP INC July 19, 2023 Regular Meeting Agenda Packet Years Tax Due Total Due 2022 $26.20 $37.10 14834401 TAR Taxpayer # 93859 SIP STIR COFFEE HOUSE PERSONAL PROPERTY TANGIBLE Taxpayer Name HARIKRUSHNA CAFE LLC Years Tax Due Total Due 2022 $24.75 $35.05 722632DEN Taxpayer # 91431 PERSONAL PROPERTY - MORTGAGE COMPANY LOCATION: 2550 Taxpayer Name IMAX MORTGAGE LLC Years Tax Due Total Due 2022 $23.34 $33.05 929538DEN Taxpayer # 112 PERSONAL PROPERTY - DONUT SHOP LOCATION: 301 TROPHY LAKE Taxpayer Name HOT & CREAMY DONUTS Years Tax Due Total Due 2022 $23.11 $32.72 14689532TAR Taxpayer # 92190 CROSSFIT SPT PERSONAL PROPERTY TANGIBLE COMMERCIAL Taxpayer Name RUTLEDGE SHANNON AND GARNER KASIE Years Tax Due Total Due 2022 $20.41 $28.90 13714066TAR Taxpayer # 91070 XXII BRANDS PERSONAL PROPERTY TANGIBLE COMMERCIAL Taxpayer Name SOCIAL180 LLC Years Tax Due Total Due 2022 $19.76 $27.98 776374DEN Taxpayer # 92696 PERSONAL PROPERTY - BUSINESS SERVICES LOCATION : 99 TROPHY Taxpayer Name STEVE SCHERMERHORN Years Tax Due Total Due 2022 $12.06 $17.08 14345060TAR Taxpayer # 93904 BROKER ONLINE EXCHANGE LLC PERSONAL PROPERTY TANGIBLE Taxpayer Name BROKER ONLINE EXCHANGE LLC Years Tax Due Total Due 2022 $10.85 $15.36 14265180TAR Taxpayer # 91517 FUSE ENERGY LLC PERSONAL PROPERTY TANGIBLE COMMERCIAL Taxpayer Name FUSE ENERGY LLC Years Tax Due Total Due 2022 $10.43 $14.77 676479DEN Taxpayer # 90858 PERSONAL PROPERTY - DANCE & MUSIC LESSONS LOCATION: 905 Taxpayer Name FULLER CHRISTINA Years Tax Due Total Due 2022 $6.15 $8.71 676477DEN Taxpayer # 91387 PERSONAL PROPERTY - MEDICAL OFFICE LOCATION: 300 TROPHY Taxpayer Name TRUE MEDICINE PA Years Tax Due Total Due 2022 $5.48 $7.76 676473DEN Taxpayer # 90855 PERSONAL PROPERTY - PERSONAL TRAINER SERVICES LOCATION: Taxpayer Name THE FORCE BY LUKE Years Tax Due Total Due 2022 $5.16 $7.31 723199DEN Taxpayer # 91433 PERSONAL PROPERTY - INSURANCE AGENT LOCATION: 2101 SH 114 Taxpayer Name MILLER CRAIG Years Tax Due Total Due 2022 $4.05 $5.73 976238DEN Taxpayer # 93739 PERSONAL PROPERTY - LEASED EQUIPMENT Taxpayer Name NUCO2 SUPPLY LLC Years Tax Due Total Due 2022 $3.21 $4.55 701746DEN PERSONAL PROPERTY - OFFICE LOCATION: 99 TROPHY CLUB DR Taxpayer # Taxpayer Name 93483 GRAY CAROL Years Tax Due Total Due 2022 $3.01 $4.26 14881042TAR Taxpayer # 93915 CARDTRONICS USA INC VARX COMMERCIAL Taxpayer Name CARDTRONICS USA INC Years Tax Due Total Due 2022 $1.49 $2.11 71301DEN Taxpayer # 91417 TROPHY CLUB # 9 LOT 764R (PT) (DENTON CO PART) ACRES: 0.006800 Taxpayer Name WHITE VICTORIA Years Tax Due Total Due 2022 $0.02 $0.03 72533DEN Taxpayer # 1256 TROPHY CLUB # 3 LOT 270 ACRES: 0.439000 Taxpayer Name YOMINE DANIEL F & JULIA A Years Tax Due Total Due 2022 $0.02 $0.03 70992DEN Taxpayer # 91637 TROPHY CLUB #10 LOT 1212 ACRES: 0.258200 Taxpayer Name ARAMBURU RANDALL Years Tax Due Total Due 2022 $0.01 $0.01 39 of 69 Page 3 July 19, 2023 Regular Meeting Agenda Packet Deferral Detail Report Locator: Denton Tax Clients: Trophy Club MUD 1 TP # Taxpayer Name Base Due 93245 PARKER CHARLES J AND PARKER SYLVIA A GEO Code 40758281TAR Client Name Trophy Club MUD 1 Tax Year Status Tran Type Start Date End Date Condition Base Tax 2022 DEFE TAX 12/06/2021 12/01/2099 Defer $337.04 Property Base Due $337.04 Taxpayer Base Due $337.04 91396 RYAN BRUCE E & SHELIA A GEO Code Client Name Tax Year Status Tran Type Start Date End Date Condition Base Tax 70173DEN Trophy Club MUD 1 2018 DEFE TAX 10/23/2018 12/01/2099 Defer $329.43 70173DEN Trophy Club MUD 1 2019 DEFE TAX 10/23/2018 12/01/2099 Defer $304.93 70173DEN Trophy Club MUD 1 2020 DEFE TAX 10/23/2018 12/01/2099 Defer $296.29 70173DEN Trophy Club MUD 1 2021 DEFE TAX 10/23/2018 12/01/2099 Defer $291.17 70173DEN Trophy Club MUD 1 2022 DEFE TAX 10/23/2018 12/01/2099 Defer $278.59 Property Base Due $1,500.41 Taxpayer Base Due $1,500.41 968 BOREN BENJAMIN C & BEVERLY C GEO Code Client Name Tax Year Status Tran Type Start Date End Date Condition Base Tax 71012DEN Trophy Club MUD 1 2010 DEFE TAX 06/30/2010 12/01/2099 Defer $414.60 71012DEN Trophy Club MUD 1 2011 DEFE TAX 71012DEN Trophy Club MUD 1 06/30/2010 12/01/2099 Defer $378.65 2012 DEFE TAX 06/30/2010 12/01/2099 Defer $295.79 71012DEN Trophy Club MUD 1 2013 DEFE TAX 06/30/2010 12/01/2099 Defer $300.56 71012DEN Trophy Club MUD 1 2014 DEFE TAX 71012DEN Trophy Club MUD 1 06/30/2010 12/01/2099 Defer $325.30 2015 DEFE TAX 71012DEN Trophy Club MUD 1 06/30/2010 12/01/2099 Defer $355.07 2016 DEFE TAX 06/30/2010 12/01/2099 Defer $367.89 71012DEN Trophy Club MUD 1 2017 DEFE TAX 06/30/2010 12/01/2099 Defer $385.38 71012DEN Trophy Club MUD 1 2018 DEFE TAX 06/30/2010 12/01/2099 Defer $380.30 71012DEN Trophy Club MUD 1 2019 DEFE TAX 06/30/2010 12/01/2099 Defer $404.59 71012DEN Trophy Club MUD 1 2020 DEFE TAX 06/30/2010 12/01/2099 Defer $401.84 71012DEN Trophy Club MUD 1 2021 DEFE TAX 71012DEN Trophy Club MUD 1 06/30/2010 12/01/2099 Defer $437.04 2022 DEFE TAX 06/30/2010 12/01/2099 Defer $417.01 Property Base Due $4,864.02 Taxpayer Base Due $4,864.02 91176 PARROW JAMES J & ELENA GEO Code Client Name Tax Year Status Tran Type Start Date End Date Condition Base Tax 71779DEN Trophy Club MUD 1 2017 DEFE TAX 11/03/2017 12/01/2099 Defer $385.31 71779DEN Trophy Club MUD 1 2018 DEFE TAX 11/03/2017 12/01/2099 Defer $412.53 71779DEN Trophy Club MUD 1 2019 DEFE TAX 11/03/2017 12/01/2099 Defer $416.50 71779DEN Trophy Club MUD 1 2020 DEFE TAX 11/03/2017 12/01/2099 Defer $404.55 71779DEN Trophy Club MUD 1 2021 DEFE TAX 11/03/2017 12/01/2099 Defer $421.13 71779DEN Trophy Club MUD 1 2022 DEFE TAX 11/03/2017 12/01/2099 Defer $401.91 Property Base Due $2,441.93 Taxpayer Base Due $2,441.93 76 MCDONALD JAMES E & HUESTIS LAURA LEA TR GEO Code Client Name Tax Year Status Tran Type Start Date End Date Condition Base Tax 72060DEN Trophy Club MUD 1 2016 DEFE TAX 01/25/2007 12/01/2099 Defer $0.09 72060DEN Trophy Club MUD 1 2017 DEFE TAX 01/25/2007 12/01/2099 Defer $5.37 72060DEN Trophy Club MUD 1 2018 DEFE TAX 01/25/2007 12/01/2099 Defer $0.30 Property Base Due $5.76 Taxpayer Base Due $5.76 914 MORTON DENVER & JANIE GEO Code Client Name Tax Year Status Tran Type Start Date End Date Condition Base Tax 72277DEN Trophy Club MUD 1 2018 DEFE TAX 03/24/2020 12/01/2099 pre $340.65 72277DEN Trophy Club MUD 1 2019 DEFE TAX 03/24/2020 12/01/2099 pre $404.44 72277DEN Trophy Club MUD 1 2020 DEFE TAX 03/24/2020 12/01/2099 Defer $393.99 72277DEN Trophy Club MUD 1 2021 DEFE TAX 03/24/2020 12/01/2099 Defer $387.05 72277DEN Trophy Club MUD 1 2022 DEFE TAX 03/24/2020 12/01/2099 Defer $367.29 Property Base Due $1,893.42 Taxpayer Base Due $1,893.42 91487 HICKS JAMES 0 GEO Code 72496DEN Client Name Trophy Club MUD 1 Tax Year Status Tran Type Start Date End Date Condition 2022 DEFE TAX 12/03/2020 12/01/2099 Defer Base Tax $90.00 Property Base Due $90.00 Taxpayer Base Due $90.00 Total Base Due $11,132.58 40 of 69 Trophy Club Municipal Utility District No. 1 Quarterly Investment Report For Ending Period 06/30/2023 (April, May, and June) July 19, 2023 Regular Meeting Agenda Packet I certify that this Investment Report complies with requirements of TCMUD's Investment Policy and the Public Funds Act. Prepared By Investment Officer Steven Krolczyk DATE Alan Fourmentin DATE Restricted/ Unrestricted Unrestricted- 135 Unrestricted- 122 Restricted- 533 Unrestricted- 135 Restricted- 122 Restricted- 137 Restricted- 533 Restricted- 534 Restricted- 528 Restricted- 519 Restricted- 535 Restricted- 520 Restricted- 536 Restricted Restricted- 519 EARNINGS SUMMARY Account or CUSIP Checking & Money Market Accounts XXX8701 XXX8701 XXX8701 Pools & Funds XXXXX0002 XXXXX0003 XXXXX00013 XXXXX00014 XXXXX00015 XXXXX00017 XXXXX00018 XXXXX00020 Savings Accounts XXXXX7724 Escrow/ Treasuries 82-1747-01-1 CD'S US Agencies NONE NONE Sec Rate / T pe Par Coulon Prosperity Bank Consolidated Cash -General Fund Prosperity Bank Consolidated Cash -Fire Dept Prosperity Bank Consolidated Cash -Tax I&S TexPool Municipal Fund -Operating TexPool Municipal Fund -Fire Dept TexPool Municipal Fund -GASB Replacement TexPool Tax Debt Service Texpool Revenue Bond I&S Texpool Revenue Bond Reserve Texpool Revenue Bond Construction -SWIFT Texpool Revenue Bond I&S-SWIFT Texpool Revenue Bond Construction Series 2019 Texpool Revenue Bond I&S Series 2019 Prosperity Bank Cash Reserve- Money Mkt Revenue Bond Series 2016 Escrow- BOK $ 4,704,186 0.000% $ 191,028 0.000% $ 0.000% $ 2,625,469 0.000% $ 911,454 0.000% $ 3,422,147 0.000% $ 983,704 0.000% $ 437,670 0.000% $ 929,983 0.000% $ 0.000% $ 207,598 0.000% $ 1,163,595 0.000% $ 207,941 0.000% $ 1,918,195 0.000% $ 807,675 $ 18,510,645 Call Maturi Date N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A Purchase Price Yield % Beginning Book 3/31/2023 Beginning Market 3/31/2023 Ending Book 6/30/2023 Ending Market 6/30/2023 Gain/Loss End MV -End BV 100.000 0.35% $ 4,606,847 $ 4,606,847 $ 4,704,186 $ 4,704,186 0.00 100.000 0.35% $ $ $ 191,028 $ 191,028 0.00 100.000 0.35% $ $ $ - $ - 0.00 100.000 5.00% $ 2,908,395 $ 2,908,395 $ 2,625,469 $ 2,625,469 0.00 100.000 5.00% $ 1,117,295 $ 1,117,295 $ 911,454 $ 911,454 0.00 100.000 5.00% $ 3,422,147 $ 3,422,147 $ 3,422,147 $ 3,422,147 0.00 100.000 5.00% $ 921,368 $ 921,368 $ 983,704 $ 983,704 0.00 100.000 5.00% $ 268,701 $ 268,701 $ 437,670 $ 437,670 0.00 100.000 5.00% $ 918,594 $ 918,594 $ 929,983 $ 929,983 0.00 100.000 5.00% $ - $ - $ - $ - 0.00 100.000 5.00% $ 130,498 $ 130,498 $ 207,598 $ 207,598 0.00 100.000 5.00% $ 1,149,345 $ 1,149,345 $ 1,163,595 $ 1,163,595 0.00 100.000 5.00% $ 102,696 $ 102,696 $ 207,941 $ 207,941 0.00 100.000 3.20% $ 1,903,209 $ 1,903,209 $ 1,918,195 $ 1,918,195 0.00 4.46% $ 799,196 $ 799,196 $ 807,675 $ 807,675 0.00 $ 18,248,291 $ 18,248,291 $ 18,510,645 $ 18,510,645 $ Restricted/ Settle Date Sec Type Account Number Par Coupon Maturity Qtr. Accrued Qtr. Amort. Total Qtr. Earnings Unrestricted Unrestricted- 135 Unrestricted- 122 Restricted- 533 Unrestricted- 135 Restricted- 533 Restricted- 534 Restricted- 528 Restricted- 519 Restricted- 535 Restricted- 520 Restricted- 536 Restricted Restricted- 519 Checking & Money Market Accounts Pools & Funds Savings Accounts Escrows/ Treasuries CD'S NONE US Agencies NONE Prosperity Bank Consolidated Cash -General Fund Prosperity Bank Consolidated Cash -Fire Dept Prosperity Bank Consolidated Cash -Tax I&S TexPool Municipal Fund TexPool Tax Debt Service Texpool Revenue Bond I&S Texpool Revenue Bond Reserve Texpool Revenue Bond Construction -SWIFT Texpool Revenue Bond I&S-SWIFT Texpool Revenue Bond Construction Series 2019 Texpool Revenue Bond I&S Series 2019 Prosperity Bank Cash Reserve- Money Mkt Revenue Bond Series 2016 Escrow- BOK PAR for this report is the statement balance on the last day of the quarter XXX8701 $ XXX8701 $ XXX8701 $ XXXXX0002 $ XXXXX0003 $ XXXXX00013 $ XXXXX00014 $ XXXXX00015 $ XXXXX00017 $ XXXXX00018 $ XXXXX00020 $ 4,704,186 N/A N/A 191,028 N/A N/A N/A N/A 6,959,070 983,704 437,670 929,983 207,598 1,163,595 207,941 N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A XXXXX7724 $ 1,918,195 N/A N/A 82-1747-01-1 $ 807,675 N/A N/A 41 of 69 $ 4,487 $ 89,777 $ 11,657 $ 4,067 $ 11,389 $ 1,953 $ 14,250 $ 1,735 $ 14,986 $ 8,479 N/A N/A N/A N/A N/A N/A N/A NA NA NA NA 4,487 89,777 11,657 4,067 11,389 1,953 14,250 1,735 N/A $ 14,986 N/A $ 8,479 $ 162,781 N/A $ 162,781 July 19, 2023 Regular Meeting Agenda Packet tcmud.org Website Overview April 1 - June 3u, 'CUL,: Traffic: Website Users 3,800 New Users 3,300 Average Engagement Time Om 45s Acquisition: Direct 2,902 Sessions/ 1,900 Users Organic Search 2,687 Sessions/ 1,788 Users Referral 181 Sessions/ 95 Users Organic Social 131 Sessions/ 86 Users Pages: Home 5,139 Views/ 2,941 Users Your Bill 736 Views/ 506 Users Watering Schedule 394 views/ 286 Users Request Forms 302 views/ 205 Users Start Stop Service 244 Views/ 148 Users Water Service 170 Views/ 149 Users Agendas/Meetings 163 views/ 69 users Elections 150 Views/ 121 Users Service Area Map 141 views/ 116 Users Administration 127 Views/ 99 users 42 of 69 July 19, 2023 Regular Meeting Agenda Packet Community Outreach Program Performance Overview April 1 - June 30, 2023 Facebook Page Reach 3,140 Accounts (Increase of 34% compared to the prior 3 month period) Posts 12 Engagements 200 (Increase of 29% compared to the prior 3 month period) Page Visits 710 (Increase of 21.4% compared to the prior 3 month period) Facebook reach a 3,140 T 34% 600 400 200 Apr 6 Apr 16 Apr 26 May 6 May 16 a Facebook reach Apr 1 — Jun 30 May 26 Jun 5 ■ Facebook reach Dec 31, 2022 — Mar 31, 2023 Daily Screenshot from Meta Business Suite dashboard for the Trophy Club Municipal Utility District No.1 Facebook Page 43 of 69 Cumulative Jun 15 Jun 25 Posted: June 1, 2023 at 2:45 PM Performance Reach 6 Total 850 July 19, 2023 Regular Meeting Agenda Packet Engagements 0 Negative interactions 0 Reactions Total 7 0 Organic 850 (100%) Comments Paid 0 (0%) Shares View details Trophy Club Municipal Utility District No. 1 J.Ira' 0 Unique 4 We will be starting our yearly water line replacement project in the first week of June. Work will start on Riviera Ct. first and then moving to the other sites shown on this map. This project will run for about 150 days...Fire hydrants will be down in these areas while construction is being performed and access to nearby residence driveways will be temporarily limited at times. If this does happen to you, you will not receive stickers on your vehicles while work is under way in your area. If you have any questions or concerns, we are always available by phone or email Just call 882) 831-46DD or email info@tcmud.org CONSTRUCTION ANNOUNCEMENT WATER LINE REPLACEMENT PROJECT LOCATION * ,Q i S roavaw 001 CONSTRUCTION WILL BEGIN THE FIRST WEEK OF JUNE. TROPHY CLUB MUNICIPAL UTILITY DISTRICT Screenshots from Meta Business Suite dashboard for the Trophy Club Municipal Utility District No.1 Facebook Page 44 of 69 0 Posted: June 5, 2023 at 11:29 AM Performance Reach 0 Total 60 July 19, 2023 Regular Meeting Agenda Packet Engagements 0 Negative interactions 0 Reactions Total 5 0 Organic 60 (100%) Comments Paid 0 (0%) Shares View details Trophy Club Municipal Utility District No. 1 Junes -0 0 Unique 0 Early this spring it was our pleasure to partner with Tarrant Regional Water District in a presentation to Medlin Middle School students. The interactive presentation included videos, graphics, and games that educated 350 middle schoolers about how the water and wastewater system works, while keeping them entertained and thinking about how they can develop habits that promote water conservation. Screenshots from Meta Business Suite dashboard for the Trophy Club Municipal Utility District No.1 Facebook Page 45 of 69 0 July 19, 2023 Regular Meeting Agenda Packet Posted: June 16, 2023 at 4:52 PM Viewer Activity e Lifetime • 0 How the post has performed since being published. e ,iews 40 20 0 0:09 Average minutes viewed 2 Engagement 7 Minutes viewed Jun 16 Jun 18 Jun 20 Jun 23 Jun 25 Jun 28 Jun 30 Jul 2 Jul 5 Jul 7 Jul 10 15 -second video views 6 3 -Second Viewers People reached 42 Trophy Club Municipal Utility District No. 1 Published by Steve Durman 0 - June 15 at 4:52 PM - Are you an irrigation expert? Do you have a degree in landscape architecture or a certification in irrigation? e If you're like most Trophy Club residents, and the answer to those questions is "no", how can you be certain you're giving your yard the precise amount of water it needs? That's where www.watermyyard.org comes in. The WaterMyYard program is a free service that uses local weather data to answer the question, "How much should I water my yard?" It's a science -based tool that helps take the guesswork out of determining when and exactly how much to water. Create an account, answer a few questions about your irrigation system, and WaterMyYard will send you weekly watering advice on how long to run your irrigation system. Maintain a healthy lawn and lower your water bill with free, customized, weekly watering recommendations. Visit www.watermyyard.org right now and get started! What are you landscaping? Native plants. All they need 18 Screenshots from Meta Business Suite dashboard for the Trophy Club Municipal Utility District No.1 Facebook Page 46 of 69 July 19, 2023 Regular Meeting Agenda Packet Posted: June 30, 2023 at 2:00 PM Performance Reach 0 Engagements 0 Negative interactions 0 Total Reactions Total 40 1 0 Organic 40 (100%) Comments 0 Unique Paid 0 (0%) Shares 0 View details Trophy Club Municipal Utility District No. 1 Published by Steve Durman ®• June 30 at 2,00 PM • Q HOLIDAY HOURS so We will be closed on Tuesday, July 4th to allow our team to celebrate with loved ones. We hope that you enjoy this special day with family and friends. We'll still be providing 24-7 emergency services even while our offices are closed. Call us anytime at 682-831-4600 for a water or wastewater emergency. We'll be back on Wednesday, July 5th, ready to serve you with renewed energy! ' HOLIDAY HOURS WE WILL BEH' CLOSED Screenshots from Meta Business Suite dashboard for the Trophy Club Municipal Utility District No.1 Facebook Page 47 of 69 0 July 19, 2023 Regular Meeting Agenda Packet REGULAR MEETING MINUTES TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 BOARD OF DIRECTORS June 21, 2023, at 6:30 p.m. Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in a regular session meeting on June 21, 2023, at 6:30 p.m., in the Boardroom of the Administration Building located at 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 Ben Brewster Doug Harper William C. Rose President Vice President Secretary/Treasurer Director BOARD MEMBERS ABSENT: Tracy Hunter STAFF PRESENT: Alan Fourmentin Laurie Slaght Steven Krolczyk Emily Rodgers Director General Manager District Secretary Finance Manager General Legal Counsel CALL TO ORDER AND ANNOUNCE A QUORUM President Carr announced the date of Wednesday, June 21, 2023, called the meeting to order and announced a quorum present at 6:30 p.m. CITIZEN COMMENTS There were no comments REPORTS & UPDATES 1. Staff Reports a. Capital Improvement Projects b. Operations Reports c. Finance Reports d. Digital Platform Analytics e. 2022 Annual Drinking Water Quality Report 48 of 69 July 19, 2023 Regular Meeting Agenda Packet General Manager Alan Fourmentin presented the monthly staff reports and answered questions related thereto. REGULAR SESSION 2. Consider and act to approve May 17, 2023, Meeting Minutes. Motion made by Director Harper and seconded by Director Brewster to approve the May 17, 2023, meeting minutes as presented. Motion carried unanimously. 3. Receive update from Strategic Committee. (Carr/Harper) Director Carr provided an update from the Strategic Committee meetings. 4. Receive update from Budget Committee and provide input regarding fiscal year 2024 annual budget. (Brewster/Harper) Director Brewster provided an update from the Budget Committee and Finance Manager Steven Krolczyk presented an overview of the FY2024 draft budget and answered questions related thereto. By consensus, the Board agreed to continue the past practice of including the full annual DFW regional CPI for all employees, and 3% annual step increases for all employees with 15 or less years of service. THE BOARD OF DIRECTORS DID NOT CONVENE INTO EXECUTIVE SESSION EXECUTIVE SESSION 5. Pursuant to Section 551.071 of the Texas Open Meetings Act, the Board may consult with its attorney in Executive Session on a matter in which the duty of the attorney to the Governmental Body under the Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflicts with the Open Meetings Act or to seek advice of counsel on legal matters involving pending or contemplated litigation or settlement offers: a. Consult with legal counsel to secure legal advice concerning joint strategic planning with the Town of Trophy Club. REGULAR SESSION 6. Consider and act regarding items discussed in Executive Session, including joint strategic planning with the Town of Trophy Club. The Board did not convene into Executive Session. 7. Items for future agendas: ■ Budget Committee updates (Brewster/Harper) 49 of 69 July 19, 2023 Regular Meeting Agenda Packet ■ Fire ILA (Staff) • Strategic Committee Update (Carr/Harper) ■ Reserve Policy (Brewster/Harper) 8. Set future Meeting date - July 19, 2023, at 6:30 p.m. ADJOURN President Carr called the meeting adjourned at 7:38 p.m. Kevin R. Carr, President Doug Harper, Secretary/Treasurer (SEAL) Laurie Slaght, District Secretary 50 of 69 Trophy Club MUD No. 1 July 19, 2023 Regular Meeting Agenda Packet FY 2024 DRAFT BUDGET PROPERTY VALUE SUMMARY COMPARIS Nr TAX RATE SUMMARY COMPARISON Fiscal Years 2023 2024 % of Increase/Decrease M&O (General Fund) Tax 0.00393 0.00344 -12.49% M&O Fire Tax 0.05625 0.06332 12.57% M&O Tax Rate 0.06019 0.06676 10.93% Increase/Decrease: -0.01081 0.00658 I & S (Debt Service) Tax 0.03115 0.00886 -71 % Increase/Decrease: -0.00374 -0.02229 Total Tax Rate: 0.09134 0.07562 -17.21 Increase/Decrease: -0.01454 -0.01572 PROPERTY VALUE SUMMARY COMPARIS Nr Fiscal Years 2023 20 , 51 Increase/Decrease MUD Tarrant Co. 590,349,578 6 31,546 7.69% MUD Denton Co. 1,645,315,777 8 •4,344 11.84% PID 919,078,121 1, 41 , 9.07% Out of District & PID 704,864 11„342 1592.72% Total Value: 3,155,448,340 , 0,139,962 10.61% 1 F 24 BUDGET PQND SUMMARY Revenue Tax Collections PID Surcharges Reserve Funds General Fund Total Revenue Water Expense Wastewater Exp Board of Direc Administration E Non -De Net Tax Debt Service Fund 12,211, 12 85,234 143,440 1,983,264 14,423,650 9,173,858 3,524,499 11,765 1,600,915 112,613 14,423,650 so Revenue 200,771 Tax Collections 219,306 PID Surcharge 116,061 Total Revenue 536,138 Debt Service Expense 536,138 Total Expense 536,138 Net Budget Surplus/Deficit $0 Fire Fund Revenue 15,000 Tax Collections 1,567,643 PID Assessment 635,162 Reserve Funds 0 Total Revenue 2,217,805 Fire Expense 2,217,805 Total Expense 2,217,805 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 51 of 69 July 19, 2023 Regular Meeting Agenda Packet TAX RATE ASSESSMENT PID ASSESSMENT & SURCHARGE CALCULATIONS FIRE TAX/ASSESSMENT RATE NET TAX VALUE: TARRANT COUNTY: $635,731,546 DENTON COUNTY: $1,840,064,344 DENTON CO. PID: $1,002,412,730 OUT OF DISTRICT & PID $704,864 REQUIRED REVENUE FIRE $2,202,805 M&O TAX/SURCHARGE RATE TARRANT COUNTY: DENTON COUNTY: TAX/ASSESS RATE = REQUIRED REVENUE/TOTAL VALS/100 Vals/100 = 34,789,135 FY 2023 Tax/Assess Rate = 0.06332 Revenue from MUD Tax = Revenue from PID Assess = NET TAX VALUE: $ 1,567,643 $ 635,16 Total: $ 2,202 $635,731,54 $1,840,064,3 DENTON CO. PID: $1,002,412,7 REQUIRED REVENUE M&O 112,613 95,000 *MUD (All of Dept. 39 Budget) **ND (Legal and Auditor only Dept 39 Budget) I&S TAX/SURCHARGE RATE NEW DEBT: CALCULATE AMOUNT DUE FROM PID TARRANT COUNTY: DENTON COUNTY: DENTON CO. PID: REQUIRED REVENUE TAX DEBT 2014 AND AF $402,713 TAX/SURCHARGE RATE = RE Va Is/100 = FY 2023 MUD M&O Tax FY 2023 PID Tax/Su Revenue fro Revenue fr Preliminary 6/30/2023 6/30/2023 6/30/2023 LS/100 ,782,086 0.00344 0.00273 $ 85,234 $ 27,379 Total: $ 112,613 $635,731,546 $1,840,064,344 $1,002,412,730 %2023 %30/2023 6/30/2023 Preliminary 6/30/2023 6/30/2023 6/30/2023 TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100 Va Is/100 = 34,782,086 FY 2023 PID Surcharge Rate = 0.01158 ***NOT FINAL TAX RATE: ONLY USED TO CALCULATE PO SHARE Revenue from MUD Tax = Revenue from PID Surcharge = $ 286,652 $ 116,061 Total: $ 402,713 MUD D' .R�i�_ LATE D TAX NET TAX VALUE: TAR ENTO dNTY: $635,731,546 $1,840,064,344 RRED REVENUE I&S MUD DEBT $219,306 Preliminary 6/30/2023 6/30/2023 TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100 Va Is/100 = 24,757,959 FY 2023 Tax Rate = 0.00886 Revenue from MUD Tax = Revenue from PID = N/A 219,306 Total: $ 219,306 Tax Rate Requirements 3.5% Overall Tax Rate FY 2024 0.07562 Voter Approval Rate 0.06396 Contributions Required $o TAX COMPARISON 52 of 69 2023 2024 M&O (General Fund) Tax 0.00393 0.00344 M&O Fire Tax 0.05625 0.06332 M&O Tax Rate 0.06019 0.06676 Increase/Decrease Rate: -0.01081 0.00658 1 & 5 (Debt Service) Tax 0.03115 0.00886 Increase/Decrease Rate: -0.00374 -0.02229 Total Tax Rate: 0.09134 0.07562 Increase/Decrease Rate: -0.01454 -0.01572 52 of 69 July 19, 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,73 734 941,550 195,816 26.26% 960,381 Assessment - Emerg Svcs 528,546 517,385 517,385 517,385 635,162 117,777 22.76% 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, -41.18% 10,000 Grant Revenue 1,082 900 d0 900 1,350 450 0.00% 1,350 Revenues -MUD 109,271 111,785 ,753 115,753 123,779 8,026 6.93% 124,152 Property Taxes/MUD Fire 1,279,821 1,257,579 1,257,579 1,257,579 1,567,643 310,06 24.66% 1,548,086 Property Taxes/Fire-Delinquent 2,425 - - - 6,987 - 0.00% - Property Taxes/Fire P&I 4,639 - - - - - 0.00% - Capital Leases -Other Financial Sources - - - - 5,814 - 0.00% - Proceeds from Sale of Assets - - - - - 7,856 0.00% - Prior Year Reserves - - 12,474 12,474 14,312 - 0.00% - GASB Reserves 554,301 - - - - - 0.00% - Miscellaneous Income - - - - 58,696 - 0.00% - Total Revenue 2,391,733 1,796,964 1,796,964 141.1 - 420,841 23.42% 2,197,366 Expenses -Town Salaries- Regular 693,010 716,522 745,73 734 941,550 195,816 26.26% 960,381 Salaries- Part Time 37,954 50,000 50,000 5 50,000 - 0.00% 51,000 Salaries- Merits - 35,337 337 5,3 7 - (35,337) -100.00% - Salaries- Overtime 128,564 83,580 8 3,580 40,296 (43,284) -51.79% 41,102 Salaries- Longevity 7,574 7,607 7,6 7,607 7,442 I (165) -2.17% 7,590 Salaries -Stipend 8,277 -- - - 0.00% - Certification Pay 1,082 10,83. 10,: : 10,838 11,250 413 3.81% 11,475 Salaries- Cell Phone Stipend 1,082 900 d0 900 1,350 450 50.00% 1,350 Retirement 109,271 111,785 ,753 115,753 123,779 8,026 6.93% 124,152 Medical lnsurance 64,88 91,140 91,140 91,140 97,577 6,437 7.06% 99,528 Dental lnsurance 3 6,544 6,544 6,544 6,987 443 6.77% 7,127 Vision Insurance 498 31 631 631 671 40 6.26% 684 Life Insurance & Other 3,19 5, 65 5,638 5,638 5,814 175 3.11% 5,930 Social Security Taxes 51,444 53,339 53,339 61,195 7,856 14.73% 62,419 Medicare Taxes 57 12,031 12,474 12,474 14,312 1,837 14.73% 14,598 Unemployment Taxes 2,520 2,520 2,520 2,520 - 0.00% 2,570 Workman's Compensation 19,047 19,810 19,810 58,696 38,886 196.29% 59,870 Physicals/Testing 4, 42 - - - - - 0.00% - Tuition Reimbursement 4,043 - - - 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 Software & Support - 17,164 - - 7,000 7,000 0.00% 7,000 Tax Administration 14,564 1,600 17,164 17,164 11,085 (6,079) -35.42% 11,307 Advertising 1,542 1,000 1,600 1,600 1,600 - 0.00% 1,632 Printing- 300 1,000 1,000 200 (800) -80.00% 204 Schools & Training 266 19,900 300 300 1,100 800 266.67% 1,122 Electricity 11,449 8,400 19,900 19,900 19,900 - 0.00% 20,298 Water 5,853 4,000 8,400 8,400 8,400 - 0.00% 8,568 Telephone 3,318 - 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 22,200 37,200 15,000 67.57% 37,944 Vehicle Maintenance 24,128 40,800 40,800 40,800 40,800 - 0.00% 41,616 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,510 14,510 - 0.00% 14,800 Office Supplies 267 500 500 500 500 - 0.00% 510 53 of 69 July 19, 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 - - - - - 0.00% - Small Equipment 4,705 4,950 9,542 9,542 4,950 2) -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,0 - 0.00% 4,080 Capital Outlays - - - - 51 1,500 0.00% - Programs & Special Projects 16,402 16,931 16,931 16,931 16,9 - 0.00% 17,270 Expenses -MUD Maintenance & Repairs (GASB34) -- - - - 0.00% - Rent And/or Usage 198,761 197,266 197,266 197,266 2 , 71 3,505 1.78% 199,211 Insurance 19,958 23,100 23,100 23 100 26,8 3,712 16.07% 28,153 Capital Outlays 554,301 - - - - 0.00% - Short Term Debt -Interest 3,102 - - - - - 0.00% - GASB34/Reserve for Replacement 81,420 81,420 81,420 81,420 194,210 112,790 138.53% 194,210 Capital Leases Principal 124,047 0.00% - Total Expense 2,429,353 1,796,964 1,837,910 83 2,217,805 379,895 20.67% 2,198,707 Total Fire Revenues $ 2,391,733 $ 1,796,964 Fire Budget 79 , 2,217,805 $ 1 9,964 $ 2,217,805 420,841 23.42% $ 2,197,366 Total Fire Expenses $ 2,429,353 $ 1,796,96 Less: Capital Leases Interest- 7,9 , 37,910 $ 2,217,805 379,895 20.67% $ 2,198,707 Net Budget Surplus (Deficit) $ (37,620) $ $ 5,000 6) Less: Fire Inspections (47,946) $ - 40,946 17,000 $ - Town/MUD Fire Contract Calculation 2023 FY 2024 Fire Budget ,796,964 2,217,805 Less: Rent/Debt Service 197,266 200,771 Less: TML Fire Insurance ,100 26,812 Less: Capital Outlays - Less: Capital Leases Interest- Less: Capital Leases Principal - - Less: GASB34/Reserve for Replacement 81,420 194,210 Less: ESD Assessment 517,385 635,162 Less: Fire Permits/Sprinkler 5,000 5,000 Less: Fire Inspections - - Less: Denton County Fire Pledg 17,000 10,000 Less: Grant Proceeds - - Annual transfer to Town from re Bu $ 955,793 $ 1,145,850 Monthly payment to TAllinekSe $ 79,649 $ 95,487 54 of 69 July 19, 2023 Regular Meeting Agenda Packet GENERAL FUND Revenues Property Taxes Description EY2022 Actual FY 2023 Adopted FY 2023 Projected FY 2024 Proposed Budget vs Budget Net Budget % Change FY 2025 Proposed Comments 138,467 87,956 87,956 85,234 (2,722) -3.09% 87,791 Decrease Tax Revenue (Non -Departmental) Requirements Property Taxes/Delinquent (179) 300 1,198 300 0.00% 300 Property Taxes/P & I 541 300 1,022 300 0.00% 300 PID Surcharges 164,890 145,029 145,029 143,440 (1,589) -1.10% 147,743 Water 6,843,941 6,710,979 7,142,255 6,939,998 229,019 3.41% 6,831,639 Increase in Projected Water Consumption Sewer 3,856,157 3,839,686 3,670,000 3,679,786 (159,900) -4.16% 3,679,786 Decrease in Projected Winter Average Penalties 105,893 78,000 78,000 105,800 27,800 35.64% 108,974 Increase in Percentage of Past Due Balances Service Charges (Disconnect Fees) 4,695 5,600 5,600 3,350 (2,250) -40.18% 3,350 Decrease in Monthly Disconnects Plumbing Inspections 600 300 300 300 0.00% 300 Sewer Inspections 150 100 100 100 0.0096 100 TCCC Effluent Charges 109,207 60,000 60,000 70,000 10,000 16.67% 70,000 Utility Fees 0.0096 Capital Lease- Other Fin Sources 0.00% Interest Income 66,251 20,000 280,000 150,000 130,000 650.0096 150,000 Increase in Bank Interest Rates Cell Tower Revenue 14,146 14,146 33,179 49,320 35,174 248.66% 50,800 Building Rent Income 0.0096 Proceeds from Sale of Assets 21,001 25,000 25,000 25,000 0.00% 25,000 Prior Year Reserves 572,900 572,900 1,933,264 1,360,364 237.4596 277,339 Rehab and Replaceme t erves Tr Balance GASB Reserves 164,000 164,000 50,000 (114,000) -69.51% 315,000 GASB Contributions ewater $50,0 Loan Proceeds 0.0096 Oversize Meter Reimbursement 2,654 2,058 2,058 2,058 0.00% 2,058 Interfund Transfer In 1,178,400 1,178,400 0.0096 Transfer Ba - Interco- Construction Fund Underrun Intergov Transfer In 0.0096 Miscellaneous Income 7,899 7,000 7,000 7,000 0.0096 7,000 Records Management Revenue 0.0096 Recovery of Prior Year Expense 85,000 0.0096 Reimbursement/Revenue Bond 0.00% Subtotal Revenues 11,421,312 11,733,354 12,275,597 14,423,650 2,690,296 22.93% 11,757,48 Water Expenses Salaries & Wages 362,451 407,139 407,139 431,575 24,436 6.00% 4 , 4.7 tep Increase for Qualifying Employees Overtime 32,273 17,000 17,000 17,000 - O.O. 17,00 Longevity 5,713 5,983 5,983 6,253 2704.' -41.3394 6,565 Certification 2,650 3,600 3,600 3,600 - 0.00 3,600 Retirement 44,359 51,201 51,201 56,730 5,530 096 59,567 Medical Insurance 65,577 82,722 82,722 116,528 33,806 4 102,544 • rojected Rates and Employee Elections Dental Insurance 3,923 4,876 4,876 4,835 (4 -0.8 Projected Rates and Employee Elections Vision Insurance 553 745 745 1,051 3 41.15% 1,156 Projected Rates and Employee Elections Life Insurance & Other 3,573 2,400 4,000 4,000 1,600 66.67% 4,400 Projected Rates and Employee Elections Social Security Taxes 24,535 26,891 26,891 28,423 32 5.70% 29,844 Medicare Taxes 5,938 6,289 6,289 6,647 6,980 Unemployment Taxes 143 1,260 1,260 1,260 a 1,323 Workman's Compensation 10,909 11,249 11,249 11,89 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 229,800 201,500 (2 , -12.32% 206,000 Generator Maintenance & Repairs 952 2,000 2,00 2,000 - 0.00% 2,000 Vehicle Maintenance 9,738 5,000 10 5,000 - 0.00% 5,150 Maintenance -Heavy Equipment 237 1,000 , 6 000 - 0.00% 1,030 Cleaning Services 1,935 2,500 500 0 - 0.00% 2,500 Lab Analysis - MUD 5,285 7,500 7,500 7, - 0.00% 7,500 Lab Analysis- PID 1,583 2,000 2, 2,00 - 0.00% 2,000 Communications/Mobiles 6,865 7,500 7,500 - 0.00% 7,500 Electricity 138,327 228,250 ,250 183,143 (45,107) -19.7696 192,301 Publications/Books/Subscripts 875 1,000 000 1,000 - 0.00% 1,000 Dues & Memberships 125 - - - 0.00% - Schools&Training 2,649 3, 2,630 (1,000) -27.5596 2,630 Safety Program - - - - 0.00% - Travel & per diem - 938 578 (360) -38.4096 578 Rent/Lease Equipment - - - - 0.00% - TCEQ Fees & Permits - MUD 1,486 30, ' 30,000 30,000 - 0.00% 30,000 TCEQ Fees & Permits - PID 437 214 - - 0.00% - Wholesale Water .72, 2,640,131 2,655,497 15,366 0.58% 2,788,272 Increase in Projected Consumption of Wholesale Water Miscellaneous Expenses - - - - - 0.00% - Property Maintenance - - - - - 0.00% - Lawn Services 6, 12,500 12,500 12,500 - 0.00% 12,500 Interfund Transfer Out- Reven .9,45 567,782 567,782 565,797 (1,986) -0.3596 565,797 Interfund Transfer Out- Bond ` - - - - - 0.00% - Interfund Transfer Out -Bank Rese - - - - - 0.00% - Furniture/Equipment < $5000 1,923 2,500 2,500 2,500 - 0.00% 2,500 Fuel & Lube 21,815 15,000 15,000 15,000 - 0.00% 15,450 Uniforms 2,474 4,355 4,355 4,355 - 0.00% 4,355 Chemicals 30,633 25,000 45,000 58,200 33,200 132.80% 59,946 Increase in Chemical Cost Small Tools - - - - - 0.00% - Safety Equipment - - - - - 0.00% Meter Expense - 20,000 20,000 20,000 - 0.00% 20,000 Meter Change Out Program 66,372 87,000 87,000 124,500 37,500 43.10% 128,235 Increase to Meter Change Out Schedule Capital Outlays 950,880 1,752,000 1,752,000 4,200,000 2,448,000 139.73% 1,765,000 Schedule Capital Replacement Short Term Debt -Principal 31,418 31,882 31,882 - (31,882) -100.0096 - Short Term Debt -Interest 1,404 470 470 - (470) -100.0096 - Gasb34/Reserve for Replacement 75,000 162,639 162,639 378,659 216,020 132.82% 378,659 Schedule GASB Replacement added 1 EST and 2 GST Water Tank Inspection Contract 112,364 113,500 113,500 - (113,500) -100.00% - Moved to GASB Bond Related Expenses - - - - - 0.00% - Subtotal Water Expenses 5,653,457 6,577,931 6,606,282 9,173,858 2,595,927 39.46% 6,931,182 Wastewater Expenses Salaries & Wages 382,301 309,655 309,655 290,305 (19,350) -6.25% 304,820 4.7% COLA and Step Increase for Qualifying Employees Overtime 31,627 33,000 33,000 33,000 - 0.00% 33,000 Longevity 7,955 4,035 4,035 2,368 (1,668) -41.3394 2,486 Certification 5,900 6,300 6,300 5,100 (1,200) -19.05% 5,100 Retirement 47,229 41,671 41,671 40,934 (737) -1.77% 42,981 Medical Insurance 71,491 96,579 96,579 93,222 (3,357) -3.48% 102,544 Projected Rates and Employee Elections 55 of 69 July 19, 2023 Regular Meeting Agenda Packet GENERAL FUND Description FV 2022 Actual FY 2023 Adopted FV 2023 Projected FY 2024 Proposed Budget vs Budget Net Budget % Change FY 2025 ProposedMI Comments Dental Insurance 3,957 5,427 5,427 3,385 (2,041) -37.62% 3,724 Projected Rates and Employee Elections Vision Insurance 566 793 793 819 26 3.30% 901 Projected Rates and Employee Elections Life Insurance & Other 3,400 2,400 3,200 3,000 600 25.00% 3,300 Projected Rates and Employee Elections Social Security Taxes 26,257 21,885 21,885 20,508 (1,377) -6.29% 21,533 Medicare Taxes 6,141 5,118 5,118 4,796 (322) -6.29% 5,036 Projected Rates and Employee Elections Unemployment Taxes 70 1,260 1,260 1,008 (252) -20.00% 1,008 Projected Rates and Employee Elections Workman's Compensation 13,414 8,987 8,987 8,404 (584) -6.50% 8,824 Projected Rates and Employee Elections Pre-emp Physicals/Testing 292 400 400 400 - 0.00% 400 Projected Rates and Employee Elections Employee Relations 445 300 1,168 300 - 0.00% 300 Travel & per diem- Engineering - - - - - 0.00% - - Independent Labor - - - - - 0.00% - 11,765 Maintenance & Repairs- WWTP 193,823 134,600 158,810 132,000 (2,600) -1.93% 110,000 Maintenance & Repairs- Collections 286,403 281,000 281,000 270,000 (11,000) -3.91% 270,000 Generator Maintenance & Repairs 4,604 9,000 9,000 21,000 12,000 133.33% 21,000 Addition of 8 Generators Vehicle Maintenance- WWTP 524 4,600 4,600 4,600 - 0.00% 4,600 Vehicle Maintenance -Collections 18,947 13,000 13,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 100,000 100,000 - 0.00% 103,000 Lab Analysis 44,380 40,000 45,000 55,000 15,000 37.50% 56,650 Increase due to TCE wired TDS, Chl and Sulfate Sampling Communications/Mobiles 6,383 7,500 7,500 7,500 - 0.00% 7,500 Addition of Election Cleaning Services Electricity 172,359 276,318 276,318 242,978 (33,340) -12.0790 255,127 Rate Fee Increase Publications/Books/Subscripts - - - - - 0.00% - Dues & Memberships - - - - - 0.00% - Schools&Training 1,700 3,630 3,630 2,119 (1,511) -41.63% 2,119 Safety Program - - - - - 0.00% 17,685 Travel & per diem - 1,038 1,038 528 (510) -49.16% 528 Rent/Lease Equipment - - - - - 0.00% Advertising - - - - - 0.00% TCEQ Fees & Permits 20,314 12,000 12,000 12,000 - 0.00% 12,000 Miscellaneous Expenses - - - - - 0.00% - Property Maintenance - - - - - 0.00% Lawn Services 6,067 16,000 16,000 16,000 - 0.0. 16,00. Interfund Transfer Out -Tax I&S 115,924 116,245 116,245 116,061 (184) -0. 116,061 Interfund Transfer Out- Revenue l&S 690,085 691,931 691,931 698,543 6,612 0.96': 698,543 Interfund Transfer Out -Bond Reserve - - - - - 0% Interfund Transfer Out -Bank Reserve - - - - Furniture/Equipment < $5000 - 500 500 500 - 0.0 . r Fuel & Lube 13,686 12,500 12,500 12,500 0.00% 1 500 Uniforms 3,299 4,415 4,415 3,520 (895 -20.27% 3,520 Chemicals- WWTP 25,284 32,500 32,500 32,500 - 0.00% 33,475 Chemicals- Collections 5,776 10,000 10,000 10,000 10,300 Small Tools - - - - r, Safety Equipment - - - - 0.00% - Lab Supplies 31,073 33,000 33,000 33,000 - 0.00% 33,000 Capital Outlays 381,214 895,000 1,078,161 1,050,000 5,000 17.32% 570,000 Schedule Capital Replacement Short Term Debt -Principal 83,484 85,766 85,766 22,398 6: -73.88% - ShortTermDebt-Interest 5,707 2,801 2,801 442 ( -84.21% - Gasb34/Reserve for Replacement 130,000 165,777 165,77 155,762 (10,0 5) -6.04% 155,762 Schedule GASB Replacement Capital Lease Issuance Cost - - - - 0.00% - Subtotal Wastewater Expenses 2,937,081 3,491,931 3,75, 1 499 32,568 0.93% 3,046,141 Board of Directors Expenses Salaries & Wages - 620,938 620,935 - - 0.00% - 4.7% COLA and Step Increase for Qualifying Employees SocialSecurityTaxes - - - - - 0.00% 2,000 Medicare Taxes - - - - - 0.00% 2,659 Unemployment Taxes - - - - - 0.00% 86,763 Workman's Compensation 10 116,290 116,290 15 - 0.00% 15 Projected Rates and Employee Elections Publications/Books/Subscripts - 6,051 6,051 - - 0.00% - Projected Rates and Employee Elections Dues & Memberships 700 750 50 750 - 0.00% 750 Projected Rates and Employee Elections Meetings1 4,507 2,400 500 1,500 - 0.00% 1,500 Projected Rates and Employee Elections Schools & Training - .r 4,000 4,000 - 0.00% 4,000 43,468 Travel & per diem- 5, 1 5,000 5,000 - 0.00% 5,000 6.77% Miscellaneous Expenses - 500 500 - 0.00% 500 - Subtotal Board of Directors Expenses 2, 11,765 11,765 - 0.00% 11,765 1,597 Administration Expenses Salaries & Wages 534, 620,938 620,935 663,185 42,247 6.80% 696,345 4.7% COLA and Step Increase for Qualifying Employees Overtime 54 2,000 2,000 2,000 - 0.00% 2,000 Longevity ,973 2,423 2,423 2,533 110 4.54% 2,659 Retirement ,277 73,825 73,825 82,631 8,806 11.93% 86,763 Medical Insurance 9,806 116,290 116,290 108,759 (7,531) -6.48% 119,635 Projected Rates and Employee Elections Dental Insurance 3,762 6,051 6,051 3,817 (2,234) -36.92% 4,198 Projected Rates and Employee Elections Vision Insurance 527 899 899 886 (13) -1.45% 975 Projected Rates and Employee Elections Life Insurance & Other 4,507 2,400 4,000 4,800 2,400 100.00% 5,280 Projected Rates and Employee Elections Social Security Taxes 31,981 38,772 38,772 41,399 2,626 6.77% 43,468 Medicare Taxes 7,479 9,068 9,068 9,682 614 6.77% 10,166 Unemployment Taxes 54 1,512 1,512 1,512 - 0.00% 1,512 Workman's Compensation 1,511 1,496 1,496 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 15,000 15,000 - 0.00% 15,450 Maintenance & Repairs 66,308 40,000 40,000 13,000 (27,000) -67.50% 13,000 Generator Maintenance & Repairs 717 3,000 3,000 3,000 - 0.00% 3,000 Building Maintenance & Supplies - - - - - 0.00% - Cleaning Services 12,266 12,000 12,000 13,000 1,000 8.33% 13,000 Addition of Election Cleaning Services Professional Outside Services 75,415 75,040 75,040 76,400 1,360 1.81% 78,692 Rate Fee Increase 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 3,000 3,000 - 0.00% 3,000 Electricity 15,200 24,369 24,369 17,685 (6,685) -27.43% 17,685 Water 4,107 5,000 5,000 5,000 - 0.00% 5,000 56 of 69 July 19, 2023 Regular Meeting Agenda Packet GENERAL FUND Description FY 2022 Actual FY 2023 Adopted FV 2023 Projected FY 2024 Proposed Budget vs Budget Net Budget % Change FV 2025 Proposed Comments Postage 22,408 30,000 30,000 30,000 - 0.00% 30,000 Bank Service Charges & Fees 92,832 95,000 130,000 130,000 35,000 36.84% 130,000 Increase in Online Payment Fees Bad Debt Expense 9,562 1,500 1,500 1,500 - 0.00% 1,500 Tax Admin Fees Insurance 86,013 88,200 88,200 116,158 27,958 31.70% 121,966 TML Rate Increase Publications/Books/Subscripts - - - - - 0.0096 - Dues & Memberships 6,522 6,500 6,800 6,800 300 4.62% 6,800 TX Comp, TML, NCTCOG, TRWA, GFOA, GFOAT, ICMA, TCMA, ASPA, APWA Meetings - - - - - 0.0096 - Public Education 3,867 40,000 40,000 20,000 (20,000) -50.00% 20,000 Schools & Training 913 3,250 3,250 3,900 650 20.0096 3,900 Travel & per diem 509 1,588 1,588 1,228 (360) -22.68% 1,228 Physicals/Testing - - - - - 0.0096 - Elections 7,143 - - 10,000 10,000 0.00% - Board Election Advertising 10,412 - - - - 0.0096 - Security - - - - - 0.00% - Miscellaneous Expenses 112 - 88 - - 0.0096 - General Manager Contingency - - - - - 0.00% - Lawn Services 4,227 5,000 5,000 5,000 - 0.0096 5,000 Furniture/Equipment < $5000 3,284 10,000 13,053 10,000 - 0.00% 10,000 diC Uniforms 443 530 530 530 - 0.0096 530 Hardware IT 12,206 8,400 13,214 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 5,000 5,000 1,000 25.0096 5,000 Printing - - - - - 0.0096 Capital Outlays 113,654 - 74,953 - - 0.0096 - Copier Lease Installments 3,242 4,000 4,000 4,000 - 0.00% 4,000 Gasb34/Reserve for Replacement - 26,736 26,736 24,903 (1,833) -6.86% 24,903 edule GAS lace Subtotal Administration Expenses 1,435,755 1,534,966 1,654,793 1,600,915 65,929 4.30% 1,655,25 Non Departmental Expenses Legal 55,890 65,000 50,000 65,000 - 0.0096 0 Auditing 25,375 33,800 27,000 30,000 (3,800) -11.24% Appraisal 14,582 12,940 12,940 12,613 (327) -2.5 12,99 Tax Admin Fees 3,874 5,000 5,000 5,000 - 0. 5,150 Subtotal Non Departmental Expenses 99,721 116,740 94,940 112,613 (4,127) A,3.54 113,141 Total General Fund Revenues Total General Fund Expenses $ 11,421,312 $ 10,128,766 $ 11,733,354 $ 11,733,354 $ 12,275,597 $ 12,073,750 9 0 $ 2,690,296 2 $ 1, 0 $ 0 $ 14,423,65 $ 14,423,650 Net Budget Surplus (Deficit) $ 1,292,546 $ 0 $ 201,846 $ 57 of 69 July 19, 2023 Regular Meeting Agenda Packet TAX DEBT PAYMENTS LONG TERM TAX DEBT REVENUE DEBT P LONG TERM REVENUE DEBT MUD/PID Reimburse Par Amount Principal FY 2024 Interest 3/01 Interest 9/01 Subtotal Interest Paying Agent Fee Total Maturity Date First Callable Date Project/Reason Series 2012 (Tax) MUD $2,355,000 50 $0 50 50 50 50 9/1/2023 9/1/2020 Refund MUD 92 Unlimited Tax Bonds Series 2002 and c f issuance Series 2013 (Tax) MUD 51,905,000 $0 $0 $0 $0 $0 $0 9/1/2023 9/1/2023 Re UD 92 Unlimited Tax Bonds Series 2003 ited Tax Refunding Bonds Series 2005 and osts ance Series 2020 (Tax) MUD 51,220,000 5120,000 $6,338 $6,338 $12,675 $750 $133,425 9/1/2031 031 Refund 1 Unlimited Tax Bonds Series 2010 and costs o nce of the Bonds, Trophy Club ' e Station SUBTOTAL MUD -ONLY TAX BONDS: 55,480,000 5120,000 56,338 56,338 512,675 $750 5133,425 Series 2014 (Tax) MUD/PID $5,765,000 $290,000 556,156 556,156 5112,313 $400 $402,713 9/ 4 9_ onds for WWTP Expansion SUBTOTAL MUD/PID TAX BONDS: 55,765,000 5290,000 556,156 556,156 5112,313 5400 $402,713 TOTAL ALL TAX BONDS: $11,245,000 5410,000 $62,494 562,494 5124,988 51,150 $536,138 REVENUE DEBT P LONG TERM REVENUE DEBT CITAL'LEASE PAYMENTS SHORT TERM REVENUE DEBT Revenue Rates Par Amount Principal FY 2024 Interest 3/01 Interest 9/01 Subtotal ing Ag e tal Maturity Date First Callable Date Project/Reason Series 2015 (Revenue) WWTP $154, $0 $9,230,000 $435,000 $87,919 $87,9 $175,: 2/1/2023 $611,238 9/1/2035 9/1/2025 Revenue Bonds for WWTP Expansion Series 2016 (Revenue) SWIFT $0 $4,635,000 $220,000 $26,557 $26, 55 $400 5273,515 9/1/2036 9/1/2027 Revenue Bonds for Fort Worth Line NSII Series 2019 (Revenue) WT & WW $0 $7,080,000 5170,000 5104,594 5104,594 Replacement $400 $379,588 9/1/2049 9/1/2028 Revenue Bonds for 16in Water Line (77%) Overrun for WWTP Expansion (23%) TOTAL ALL REVENUE BONDS: 520,945,000 $825,000 $219,1$219,070 $4 51,200 51,264,340 CITAL'LEASE PAYMENTS SHORT TERM REVENUE DEBT o' 58 of 69 Revenue Rates ' al Par Amo 1,trest 2/01 Interest 8/01 Subtotal Interest Paying Agent Fee Total Payoff Date Reason Department Vaccon Truck (Water usage 43%) $154, $0 $0 $0 $0 $ - $0 2/1/2023 Replacement Water Vaccon Truck (WW usage 57%) 205,2 $0 $0 $0 $0 $ - $0 2/1/2023 Replacement Wastewater Camera Van 205,50 $22,398 $442 $0 $442 $ - $22,841 2/1/2024 Replacement Wastewater Total: 4 $22,398 $442 $0 $442 $ - $22,841 o' 58 of 69 July 19, 2023 Regular Meeting Agenda Packet CAPITAL OUTLAYS (5 Year Projection) Department FY 2024 FY 2025 FY 2026 FY 2027 FY 2028 Water Water Line Replacement $ 2,000,000 $ 1,700,000 $ 1,751,000 $ 1,8 3,530 $ 1,857,636 Pump Station Improvements $ 2,200,000 $ - $ - $ - $ - Fleet Replacement $ - $ 65,000 $ - ,000 $ - MBR CIP Tanks $ - $ - $ $ - $ - Water Grand Totals $ 4,200,000 $ 1,765,000 $ 1,750 '1,853,5 0 $ 1,857,636 Wastewater Wastewater Line Improvements $ 400,000 $ 200,000 ' 20' .0, 200,000 $ 200,000 Lift Station Improvements $ 225,000 $ 50,088 $ 50,8' , $ 50,000 $ 50,000 Return Pump $ - $ -.,100 $ 40,000 $ 40,000 MBR CIP Tanks $ 375,000 $ - $ - $ - Crane Pulley $ - $ ' ,,. - $ - $ - Concrete Repairs $ - 3' '00 - $ - $ - Fleet Replacement $ 50,0 250, J0 $ - $ - $ - $ - - $ - $ - $ Wastewater Grand Totals $ 1,0 $ 570,000 $ 290,000 $ 290,000 $ 290,000 Administration $ $ - $ - $ - $ - $ - $ - $ <ed$$\ $ $ $ $ Admin Grand Totals - $ - $ - $ - 59 of 69 July 19, 2023 Regular Meeting Agenda Packet ANNUAL WATER CONSUMPTION AND REVENUE BY YEAR Annual Consumption in (Thousand) Gallons 1,200,000 1,000,000 800,000 600,000 400,000 200,000 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 5,000 4,900 4,800 4,700 4,600 4,500 4,400 4,300 4,200 4,100 4,000 $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 $- Annual Water Revenue 2014 2015 2016 20 ele 2019 20 2021 2022 2023 2024 AVERAGE MONTHLY METERS AND AVERAGE AL S BY YEAR Average Monthly Meters 3,900 2014 2015 2016 2017 2018 2019 2020 2 2022 2023 2024 AN L S WATER FLOW AND REVENUE BY YEAR 14,000 12,000 10,000 8,000 6,000 4,000 2,000 rage Monthly Gallons per Meter • 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 500,000 400,000 300,000 200,000 100,000 0 Annual TP' ' (Thousand) Gallons 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 60 of 69 $4,500,000 $4,000,000 $3,500,000 $3,000,000 $2,500,000 $2,000,000 $1,500,000 $1,000,000 $500,000 $- Annual Wastewater Revenue 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 15,1 TROPHY CLUB MUNICIPAL UTILITY DISTRICT July 19, 2023 Regular Meeting Agenda Packet STAFF REPORT July 19, 2023 AGENDA ITEM: Consider and act to award bid and approve 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. DESCRIPTION: This project consists of replacement of two (2) vertical turbine pumps, incorporation of variable frequency drives, replacement of discharge header piping, and replacement of pump control and isolation valves within the high service pump station. This project was advertised, and a public bid opening was held on July 7, 2023. Four (4) bids were received and are outlined in the attached letter of recommendation. RECOMMENDATION: Staff recommends awarding 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.00 and authorize the General Manager to execute the necessary documents to implement Board action. 61 of 69 July 19, 2023 Regular Meeting Agenda Packet 3000 Internet Boulevard Suite 400 Frisco, TX 75034 TEL 972.377.7480 FAX 972.377.8380 www.GarverUSA.com Trophy Club MUD No. 1 Attn: Alan Fourmentin 100 Municipal Drive Trophy Club, TX 76262 Re: Trophy Club MUD No.1 High Service Pump Station and Piping Improvements Recommendation of Award Dear Mr. Fourmentin: On July 7, 2022 at 11:OOAM, 4 bids were received on the High Service Pump Station (HSPS) and Piping Improvements project. Rey -Mar Construction, LLC submitted the low responsible bid for the project in the amount of $2,124,400.00. We believe that the bid submitted by Rey -Mar Construction, LLC represents a good value for the Trophy Club MUD No.1. Contingent upon successful negotiation of terms with Rey -Mar Construction, LLC, we recommend that the construction contract for HSPS and Piping Improvements be awarded to Rey -Mar Construction, LLC. Please call me if you have any questions. Sincerely, Justin Rackley, P.E. Senior Project Manager Project No. 22W05320 Recommendation of Award Trophy Club MUD No.1 HSPS and Piping Improvements 11 July 2023 62 of 69 July 19, 2023 Regular Meeting Agenda Packet Trophy Club MUD No.1 High Service Pump Station and Piping Improvements Bid Tabulations Crescent Felix BASE BID Constructors, Dake Construction Rey -Mar ITEM No. INC. Construction Company Construction 1 $ 2,241,000.00 $ 2,117,300.00 $ 2,161,000.00 $ 2,055,000.00 4 $ 50,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00 8 $ 2,000.00 $ 4,400.00 $ 22,500.00 $ 17,000.00 9 $ 2,000.00 $ 4,700.00 $ 3,200.00 $ 2,400.00 TOTAL BASE BID PRICE $ 2,295,000.00 $ 2,176,400.00 $ 2,236,700.00 $ 2,124,400.00 COMPANY NAME TOTAL BASE BID PRICE Crescent Constructors, INC. $2,295,000.00 Dake Construction $2,176,400.00 Felix Construction Company $2,236,700.00 Rey -Mar Construction, LLC. $2,124,400.00 TOTAL BASE BIDS AS READ ALOUD FROM THE WRITTEN TOTALS ON 7/7/2023 WHEN BIDS WERE OPENED. Project No. 22W05320 Trophy Club MUD No.1 HSPS and Piping Improvement 63 of 69 Bid Tabulation Page 1 of 1 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT July 19, 2023 Regular Meeting Agenda Packet STAFF REPORT July 18, 2023 AGENDA ITEM: Consider and act to terminate contract with Utility Services Co. Inc. for Water Tank Maintenance effective on November 1, 2023. DESCRIPTION: The District contracted with Utility Services on January 17, 2006, for water tank maintenance. The contract includes tank painting, inspections, and washouts. The District makes annual payments to Utility Services even if no services are rendered. Over last year, the inside of the T.W. King tank and the East GST were painted, and all storage tanks are up to date with scheduled painting and maintenance. We would like to terminate the current contract and start using GASB funds for water tank maintenance to ensure that we are only paying for services received. Cancellation of this contract provides long-term flexibility and control regarding maintenance and repair methods for District elevated and ground storage takes. ATTACHMENTS: Notice of Termination RECOMMENDATION: Staff recommends approval of terminating contract Utility Services Co. Inc., with an effective date of November 1, 2023. 64 of 69 July 19, 2023 Regular Meeting Agenda Packet 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT No. 1 Utility Services Co., Inc. Jimmy Asher 16002 Kitzman Road Cypress, TX 77429 Re: Notice of Termination - Water Tank Maintenance Contract Dear Mr. Asher 682-831-4600 817-491-9312 July 19, 2023 On January 17, 2006, Trophy Club Municipal Utility District No. 1, (the "District") entered into a contract with Utility Services Co., Inc. for water tank maintenance. The contract includes the following language regarding cancellation/termination: "This Contract is subject to cancellation by the owner only if tenant to cancel is received by the Company ninety [90] days prior to the anniversary date. Notice of cancellation is to be delivered by registered mail and signed by three [3] authorized voting officials of the Owner's management and/or Commissioners. Unless intent to cancel is received from the owner, this contract shall automatically renew each year." This letter shall serve as the ninety [90] ninety -day notice that the District is terminating the contract effective November 1, 2023. Should you have any questions, please call our office at (682) 831-4600. Kevin R. Carr, President Board of Directors Ben Brewster, Vice President Board of Directors Doug Harper, Sec/Treasurer Board of Directors 100 Municipal Drive Trophy Club, TX 76262 tcmud.org 65 of 69 July 19, 2023 Regular Meeting Agenda Packet ORDER NO. 2023-0719A 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. 66 of 69 July 19, 2023 Regular Meeting Agenda Packet PASSED AND APPROVED this 19th day of July, 2023. Kevin R. Carr, President Doug Harper, Secretary/Treasurer (SEAL) Laurie Slaght, District Secretary 67of69 July 19, 2023 Regular Meeting Agenda Packet Exhibit "A" Surplus Property 1. 2018 Chevrolet Silverado Truck Crew Cab 2. 2015 Chevrolet 3500 Utility Bed Truck 68 of 69 Trophy Club Municipal Utility District No. 1 August 2023 Sun Mon 31 32 33 Jul 30, 2023 6 13 34 20 31 7 14 21 Tue Wed July 19, 2023 Regular Meeting Agenda Pac�kt rie Slaght Thu Aug 1 2 3 8 9 10 Fri Sat 4 11 5 12 15 16 ) Board of Directors Reg 17 22 23 24 35 27 28 29 18 25 19 26 30 31 Sep 1 2 69 of 69 Printed on: 06/22/2023 11:40am OCentral Time US & Ca Powered by _ teamup