The URL can be used to link to this page

Home My WebLink About2023-0419 April 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, April 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. Water Operations Report c. Wastewater System Reports d. Finance Reports e. Digital Platform Analytics Attachments: Staff Reports CONSENT AGENDA All matters listed as Consent Agenda are considered to be routine by the Board of Directors and will be enacted by one motion. There will not be a separate discussion of these items. If discussion is desired, that item will be removed from the consent agenda and will be considered separately. 2. Consider and act to approve the Consent Agenda. a. March 2023 Combined Financials b. March 22, 2023, Regular Meeting Minutes c. Quarterly Investment Report – 2nd Quarter FY2023 d. Tax Collections Report – 2nd Quarter FY2023 Attachments: March Financials March 22, 2023, Meeting Minutes Quarterly Investment Report Tax Collection Report April 19, 2023 Regular Meeting Agenda Packet 1 of 71 REGULAR SESSION 3. Discussion and possible action regarding financial reports. 4. Discussion and possible action regarding emergency fire station repairs. Attachment: Staff Report 5. Consider and act regarding approval of Contract No. 2023041901 for replacement of water lines as part of FY 2023 Capital Improvement Projects. Attachments: Staff Report 6. Consider and act regarding approval of Well #3 Rehabilitation and Pump Replacement. Attachment: Staff Report 7. Discussion and possible action regarding Amended and Restated Interlocal Cooperation Agreement for Administration of Fire Protection Services and the possible transfer of District assets to the Town of Trophy Club. EXECUTIVE SESSION 8. Pursuant to Section 551.071 of the Texas Open Meetings Act, the Board may consult with its attorney in Executive Session on a matter in which the duty of the attorney to the Governmental Body under the Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflicts with the Open Meetings Act or to seek advice of counsel on legal matters involving pending or contemplated litigation or settlement offers: a. Consult with legal counsel to secure legal advice concerning joint strategic planning with the Town of Trophy Club. b. Consult with legal counsel relating to the respective roles, responsibilities, and duties of the Board, including potential legal Issues associated with email communications by Board Members. REGULAR SESSION 9. Consider and act regarding items discussed in Executive Session. 10. Items for future agendas: 11. Set future Meeting dates May 17, 2023, at 6:30 p.m. Attachment: May 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, April 19, 2023 Regular Meeting Agenda Packet 2 of 71 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 April 19, 2023 Regular Meeting Agenda Packet 3 of 71 Capital Improvement Projects  FY 2023 Water Line Project – Bidding is complete, and a contract is being requested for approval for the replacement of approximately 5,893 linear feet of water lines along and adjacent to Sunset Drive, Berkshire Court, Lee Court, Riviera Court, and Skyline Drive.  Pump Station Improvement Project – Design is 90% complete 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. Bidding is scheduled for July 2023.  Membrane Bioreactor (MBR) Piping Improvements – This project is complete.  Lift Station #1 – This project is complete.  Lift Station Generators – This project consists of installation of onsite diesel generators and automatic transfer switches at eight (8) lift station sites allowing for further resiliency within the wastewater collections system during power outages. Notice to Procure was provided to the contractor in November 2022. Delivery of the generators is scheduled for December 2023 with an anticipated completion date of April 2024. The schedule to begin underground and sitework will be dependent on the generator delivery dates.  FY 2023 Wastewater Improvements – Heavy cleaning and CCTV of 3,582 feet of pipe has been completed, which is ahead of schedule and includes savings of approximately $9,000. Point repairs identified at 25 locations will begin next week and tentatively scheduled to be completed by the end of May.  FY 2023 Lift Station Improvements – Materials for Lift Station #3 valve vault have been received and materials for the installation of a permanent bypass have been ordered. The coordination of the contractor and dewatering will be determined once the remaining parts are received.  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 April 19, 2023 Regular Meeting Agenda Packet 4 of 71 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. April 19, 2023 Regular Meeting Agenda Packet 5 of 71 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 332,858 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 373,884 0 20,000 40,000 60,000 80,000 100,000 120,000 140,000 160,000 Water Billed 2019 2020 2021 2022 2023 0 20,000 40,000 60,000 80,000 100,000 120,000 140,000 160,000 Water Pumped 2019 2020 2021 2022 2023 April 19, 2023 Regular Meeting Agenda Packet 6 of 71 0.750 0.850 0.950 1.050 1.150 1.250 1.350 1.450 1.550 1.650 1.750 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Million Gallons Wastewater Treated Daily Avg Flow Daily Max Flow Daily Avg Max 0.0 2.0 4.0 6.0 8.0 10.0 12.0 14.0 16.0 18.0 20.0 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Carbonaceous Biochemical Oxygen Demand (CBOD) CBOD Avg CBOD Max Daily Avg Max Daily Max 01234567 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Million Gallons Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Min 1.407 1.686 1.660 3.173 3.915 2.348 1.889 1.842 1.401 1.115 1.225 0.878 0.999 Max 2.942 3.593 4.685 5.767 7.100 7.325 5.277 5.00 2.57 2.72 2.51 2.35 2.52 Avg 1.926 2.603 3.325 4.183 5.748 4.704 3.948 3.662 1.834 1.657 1.759 1.479 1.731 Water Production April 19, 2023 Regular Meeting Agenda Packet 7 of 71 0.0 5.0 10.0 15.0 20.0 25.0 30.0 35.0 40.0 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Total Suspended Solids (TSS) TSS Avg TSS Max Daily Avg Max Daily Max 0.00 1.00 2.00 3.00 4.00 5.00 6.00 7.00 8.00 9.00 10.00 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Ammonia Nitrogen (NH3) NH3 Avg NH3 Max Daily Avg Max Daily Max 0.0 10.0 20.0 30.0 40.0 50.0 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Nitrate-Nitrogen (NO3) NO3 Avg NO3 Max Daily Avg Max Daily Max April 19, 2023 Regular Meeting Agenda Packet 8 of 71 6 6.57 7.58 8.59 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Potential of Hydrogen (pH) pH Min pH Max pH Avg Daily Avg Min Daily Avg Max 6.0 6.5 7.0 7.5 8.0 8.5 9.0 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Dissolved Oxygen (DO) DO Min DO Max DO Avg Daily Avg Min Daily Avg Max 1.0 1.0 1.0 1.0 1.0 2.0 307.0 3.0 1.0 6.3 2.0 1.0 1.0 0 50 100 150 200 250 300 350 400 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 *Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Escherichia coli (E. coli) *Sep-22 is an outlier sample E. coli Avg E. coli Max Daily Avg Max Daily Max April 19, 2023 Regular Meeting Agenda Packet 9 of 71 4/13/2023 8:58:32 AM Page 1 of 4 Check Report Trophy Club Municipal Utility District No. 1 By Check Number Date Range: 03/01/2023 -03/31/2023 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number Bank Code: Prosperity Bank-Prosperity Bank Payment Type: Regular 2222 Aflac 03/02/2023 Regular 0.00 441.46 9387 3197 BenefitMall 03/02/2023 Regular 0.00 52.00 9388 4018 BP Energy Holding Company LLC 03/02/2023 Regular 0.00 75,673.62 9389 1030 City of Fort Worth 03/02/2023 Regular 0.00 141,548.58 9390 3184 Dataprose LLC 03/02/2023 Regular 0.00 582.50 9391 1737 DPC Industries Inc. 03/02/2023 Regular 0.00 2,140.99 9392 4033 Health Care Service Corporation 03/02/2023 Regular 0.00 19,592.59 9393 2943 JP Morgan Chase Bank NA 03/02/2023 Regular 0.00 5,116.97 9394 3216 M3 Networks 03/02/2023 Regular 0.00 669.00 9395 3186 Member's Building Maintenance 03/02/2023 Regular 0.00 1,289.80 9396 3115 Metlife Group Benefits 03/02/2023 Regular 0.00 2,350.46 9397 2760 NDS Leasing 03/02/2023 Regular 0.00 175.00 9398 1056 Office Depot Inc 03/02/2023 Regular 0.00 466.51 9399 2789 Relevant Solutions 03/02/2023 Regular 0.00 740.70 9400 3156 Southern Petroleum Lab Inc 03/02/2023 Regular 0.00 1,870.80 9401 1973 Texas Commission on Environmental Quality 03/02/2023 Regular 0.00 33,040.51 9402 2696 Texas Excavation Safety System 03/02/2023 Regular 0.00 149.15 9403 1000 Trophy Club Mud (Water Bills) 03/02/2023 Regular 0.00 357.65 9404 3293 Two Wilsons Industries, Inc 03/02/2023 Regular 0.00 121.46 9405 3127 Allied Welding Supply Inc. 03/09/2023 Regular 0.00 17.83 9417 4020 Becks Plumbing Inc. 03/09/2023 Regular 0.00 423.00 9418 3187 CLS Sewer Equipment Co.Inc 03/09/2023 Regular 0.00 743.55 9419 3184 Dataprose LLC 03/09/2023 Regular 0.00 2,622.97 9420 1018 Denton Central Appraisal District 03/09/2023 Regular 0.00 2,163.63 9421 3118 Exclusive Pest Control 03/09/2023 Regular 0.00 245.00 9422 2606 Fiserv Solutions LLC 03/09/2023 Regular 0.00 50.00 9423 3093 Four Man Furnace Inc. 03/09/2023 Regular 0.00 1,527.50 9424 1372 Hach Company 03/09/2023 Regular 0.00 3,914.49 9425 2754 Lower Colorado River Authority 03/09/2023 Regular 0.00 213.92 9426 3216 M3 Networks 03/09/2023 Regular 0.00 2,943.80 9427 2801 Pipeline Analysis LLC 03/09/2023 Regular 0.00 26,332.80 9428 3156 Southern Petroleum Lab Inc 03/09/2023 Regular 0.00 400.80 9429 3182 Strategic Government Resources 03/09/2023 Regular 0.00 652.50 9430 2440 Tarrant County Public Health Laboratory 03/09/2023 Regular 0.00 330.00 9431 1001 Town of Trophy Club 03/09/2023 Regular 0.00 218,882.74 9432 1081 Tri County Electric 03/09/2023 Regular 0.00 710.75 9433 2798 Tyler Technologies Inc 03/09/2023 Regular 0.00 32.50 9434 2691 All Test Fire Protection LLC 03/22/2023 Regular 0.00 757.50 9435 2772 Allied Waste Industries 03/22/2023 Regular 0.00 8,516.34 9436 2683 Charter Communications 03/22/2023 Regular 0.00 899.00 9437 2655 Core & Main LP 03/22/2023 Regular 0.00 2,085.00 9438 2796 Garver 03/22/2023 Regular 0.00 13,913.10 9439 2635 Halff Associates Inc. 03/22/2023 Regular 0.00 7,316.44 9440 3076 HD Supply Facilities Maint LTD 03/22/2023 Regular 0.00 338.20 9441 1834 Idexx Distribution, Inc 03/22/2023 Regular 0.00 1,593.73 9442 3278 Kyocera Document Solutions 03/22/2023 Regular 0.00 75.51 9443 2754 Lower Colorado River Authority 03/22/2023 Regular 0.00 213.92 9444 2643 Mclean & Howard LLP 03/22/2023 Regular 0.00 825.00 9445 3179 NewGen Strategies & Solutions 03/22/2023 Regular 0.00 2,477.50 9446 4019 Peterson Pump & Motor Service LLC 03/22/2023 Regular 0.00 2,530.00 9447 3134 Prime Controls LP 03/22/2023 Regular 0.00 23,113.19 9448 3176 Rey-Mar Construction 03/22/2023 Regular 0.00 140,665.11 9449 3156 Southern Petroleum Lab Inc 03/22/2023 Regular 0.00 1,514.40 9450 April 19, 2023 Regular Meeting Agenda Packet 10 of 71 Check Report Date Range: 03/01/2023 -03/31/2023 4/13/2023 8:58:32 AM Page 2 of 4 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number 2798 Tyler Technologies Inc 03/22/2023 Regular 0.00 7,313.00 9451 1058 Verizon Wireless 03/22/2023 Regular 0.00 857.24 9452 3196 Axis Construction LP 03/31/2023 Regular 0.00 4,130.00 9453 4018 BP Energy Holding Company LLC 03/31/2023 Regular 0.00 33,161.29 9454 1030 City of Fort Worth 03/31/2023 Regular 0.00 121,763.35 9455 1026 Federal Express Corp 03/31/2023 Regular 0.00 4.89 9456 2800 Ferguson Enterprises LLC 03/31/2023 Regular 0.00 2,852.30 9457 1372 Hach Company 03/31/2023 Regular 0.00 583.75 9458 2943 JP Morgan Chase Bank NA 03/31/2023 Regular 0.00 6,175.74 9459 3132 Legal Shield 03/31/2023 Regular 0.00 34.90 9460 2760 NDS Leasing 03/31/2023 Regular 0.00 175.00 9461 1056 Office Depot Inc 03/31/2023 Regular 0.00 198.29 9462 3176 Rey-Mar Construction 03/31/2023 Regular 0.00 145,646.94 9463 3156 Southern Petroleum Lab Inc 03/31/2023 Regular 0.00 757.20 9464 1001 Town of Trophy Club 03/31/2023 Regular 0.00 201,028.31 9465 3225 US Bank Voyager Fleet Systems 03/31/2023 Regular 0.00 1,866.09 9466 2634 Valley Solvents & Chemicals 03/31/2023 Regular 0.00 862.91 9467 Total Regular: 0.00 1,282,832.67 April 19, 2023 Regular Meeting Agenda Packet 11 of 71 Check Report Date Range: 03/01/2023 -03/31/2023 4/13/2023 8:58:32 AM Page 3 of 4 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number Payment Type: Bank Draft 3197 BenefitMall 03/03/2023 Bank Draft 0.00 266.67 DFT0000043 3113 TCDRS 03/31/2023 Bank Draft 0.00 9,420.43 DFT0000044 3124 IRS Tax Payment 03/03/2023 Bank Draft 0.00 12,780.44 DFT0000045 3197 BenefitMall 03/17/2023 Bank Draft 0.00 266.67 DFT0000046 3113 TCDRS 03/31/2023 Bank Draft 0.00 9,526.53 DFT0000047 3124 IRS Tax Payment 03/17/2023 Bank Draft 0.00 12,847.50 DFT0000048 3113 TCDRS 03/31/2023 Bank Draft 0.00 9,496.40 DFT0000049 3124 IRS Tax Payment 03/31/2023 Bank Draft 0.00 13,430.55 DFT0000050 Total Bank Draft: 0.00 68,035.19 Regular Checks Manual Checks Voided Checks Discount Payment Payment Type Count Bank Code Prosperity Bank Summary Bank Drafts EFT's 700080 0.00 0.00 0.00 0.00 0.00 78 0.00 Payment 1,282,832.67 0.00 0.00 68,035.19 0.00 1,350,867.86 Payable Count 1170080 125 April 19, 2023 Regular Meeting Agenda Packet 12 of 71 Check Report Date Range: 03/01/2023 -03/31/2023 4/13/2023 8:58:32 AM Page 4 of 4 All Bank Codes Check Summary Payment Type Discount Payment Count Payment Payable Count Regular Checks Manual Checks Voided Checks Bank Drafts EFT's 700080 0.00 0.00 0.00 0.00 0.00 78 0.00 1,282,832.67 0.00 0.00 68,035.19 0.00 1,350,867.86 1170080 125 Fund Name Period Amount Fund Summary 996 MUD Consolidated Cash 3/2023 1,350,867.86 1,350,867.86 April 19, 2023 Regular Meeting Agenda Packet 13 of 71 135-10250 TexPool O & M (XXXXX0002)-General Fund Operating *** $0 $2,908,395 $2,908,395 135-10300 Prosperity Bank (XXX8701) General Fund Operating * $331,805 $4,275,042 $4,606,847 135-10305 Prosperity Bank Reserve-Savings Acct (XXXXX7724) $1,903,209 $0 $1,903,209 135-11100 Petty Cash Administration $0 $150 $150 135-11150 Petty Cash Utility Billing $0 $450 $450 137-10250 TexPool O & M (XXXXX0002) GASB Replacement $3,422,147 $0 $3,422,147 519-10250 Texpool Revenue Bond Construction (XXXXX015) SWIFT $0 $0 $0 519-11155 Cash-Bond Escrow Bank of Texas (SWIFT) $799,196 $0 $799,196 520-10250 Texpool Revenue Bond Water & Waste Water Systems 2019 (XXXXX018) $1,149,345 $0 $1,149,345 520-10300 Prosperity Bank Construction Water & Waste Water Systems 2019 $0 $0 $0 528-10250 TexPool Revenue Bond Reserve (XXXXX014) WWTP Improvements $918,594 $0 $918,594 533-10250 TexPool Tax I & S (XXXXX0003) $921,368 $0 $921,368 533-10300 Prosperity Bank (XXX8701) Tax I&S $0 $0 $0 534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements $268,701 $0 $268,701 535-10250 Texpool Revenue I & S (XXXXX017) SWIFT $130,498 $0 $130,498 536-10250 TexPool Revenue I & S (XXXXX020) Water & Waste Water Systems $102,696 $0 $102,696 $7,184,037 $17,131,596 Amount available in cash for spending (MUD Accounts) $7,184,037 *3/31/2023 Customer Water Deposits $331,805 122-10250 TexPool O & M (XXXXX0002)-Fire Operating Cash $0 $1,117,295 $1,117,295 122-10300 Prosperity Bank (XXX8701) Fire Operating $0 $0 $0 $0 $1,117,295 $1,117,295 Amount available in cash for spending (Fire Department Accounts) $1,117,295 $ 4,275,042 Prosperity General Fund $ 2,908,395 Texpool General Fund $ 600 Petty Cash Total General Fund 135 Available for Spending $ 7,184,037 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 $ (804,522) Total Nonspendable, Assigned & Committed Fund Balances -General Fund 135 $9,643,016 General Fund 135 Available General Fund 135 Fund Balances Fire Department Cash CASH STATUS AS OF MARCH 2023 Restricted -Unable to be spent Unrestricted-Available for spending Total in Accounts (Restricted & Unrestricted) April 19, 2023 Regular Meeting Agenda Packet 14 of 71 March April May June July August September October November December January February March 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2023 2023 2023 ebills 1,424 1,465 1,518 1,566 1,592 1,629 1,654 1,667 1,710 1,746 1,765 1,777 1,773 Bills Mailed 3,864 3,868 3,865 3,882 3,872 3,850 3,832 3,822 3,801 3,768 3,741 3,751 3,744 Bank Draft 671 676 692 700 697 704 703 706 711 630 606 599 599 Credit Card Draft 1,442 1,455 1,450 1,456 1,471 1,484 1,481 1,501 1,494 Online Payments 1,225 1,171 1,196 1,188 1,220 1,170 1,203 1,159 1,049 Late Notices 326 355 284 339 387 310 326 337 0 0 0 547 413 Disconnects 8 9 9 4 7 5 2 0 4 0 0 0 0 Connections MUD 3402 3400 3400 3401 3401 3398 3399 3399 3399 3399 3394 3394 3394 Connections PID 1443 1443 1443 1443 1443 1443 1444 1444 1444 1444 1444 1443 1443 Date of Permit Permit No. Customer Deposit Due to FW Water Oversize Meter Plumbing Inspections Sewer Inspections Fire Line Misc. Income Total $ -Total $ -$ -$ -$ -$ -$ -$ -$ -March Utility Billing Report Fiscal Year 2022 -2023 March Permits Fiscal Year 2023 2,251 2,540 2,719 3,016 April 19, 2023 Regular Meeting Agenda Packet 15 of 71 tcmud.org Website Overview January 1 -March 31, 2023 Traffic: Website Users...................................................................................... 4,500 New Users...................... ........................................................................ 4,000 Average Engagement Time........................................................0m 52s Acquisition: Direct............... ....................................................3,577 Sessions /2,432 Users Organic Search.............................................. 3,074 Sessions /2,025 Users Referral...................... .................................................465 Sessions /133 Users Organic Social...............................................................55 Sessions /17 Users Pages: Home................ ....................................................... 6,568 Views /3,550 Users Your Bill........................................................................... 919 Views /652 Users Request Forms............................................................. 319 Views /159 Users Job Opportunities..................................................... 259 Views /139 Users Agendas & Meetings..................................................244 Views /88 Users Administration............................................................ 206 Views /153 Users Water Service............................................................... 203 Views /151 Users Start or Stop Service............................................... 202 Views /129 Users Elections.......................................................................... 187 Views /127 Users April 19, 2023 Regular Meeting Agenda Packet 16 of 71 Community Outreach Program Performance Overview January 1 -March31, 2023 Facebook Page Reach.......................... 2,328 Accounts # of Posts................................................... 9 Median Post Engagement.................. 17 (Increase of 70% compared to Q4 2022) Note: Overall reach is down in Q1 2023 compared to Q2 2022 because at the end of December, 2022 we decided to stop cross-posting our content on some of the Trophy Club community Facebook groups. Screenshot from Meta Business Suite dashboard for the Trophy Club Municipal Utility District No. 1 Facebook Page April 19, 2023 Regular Meeting Agenda Packet 17 of 71 Screenshots from Meta Business Suite dashboard for the Trophy Club Municipal Utility District No. 1 Facebook Page Posted: January 19, 2023 at 4:01 PM April 19, 2023 Regular Meeting Agenda Packet 18 of 71 Screenshots from Meta Business Suite dashboard for the Trophy Club Municipal Utility District No. 1 Facebook Page Posted: January 30, 2023 at 3:20 PM April 19, 2023 Regular Meeting Agenda Packet 19 of 71 Screenshots from Meta Business Suite dashboard for the Trophy Club Municipal Utility District No. 1 Facebook Page Posted: January 30, 2023 at 6:02 PM April 19, 2023 Regular Meeting Agenda Packet 20 of 71 Screenshots from Meta Business Suite dashboard for the Trophy Club Municipal Utility District No. 1 Facebook Page Posted: February 2, 2023 at 6:00 PM April 19, 2023 Regular Meeting Agenda Packet 21 of 71 Screenshots from Meta Business Suite dashboard for the Trophy Club Municipal Utility District No. 1 Facebook Page Posted: February 17, 2023 at 5:42 PM April 19, 2023 Regular Meeting Agenda Packet 22 of 71 Screenshots from Meta Business Suite dashboard for the Trophy Club Municipal Utility District No. 1 Facebook Page Posted: February 23, 2023 at 7:00 PM April 19, 2023 Regular Meeting Agenda Packet 23 of 71 Screenshots from Meta Business Suite dashboard for the Trophy Club Municipal Utility District No. 1 Facebook Page Posted: February 27, 2023 at 7:00 PM April 19, 2023 Regular Meeting Agenda Packet 24 of 71 Screenshots from Meta Business Suite dashboard for the Trophy Club Municipal Utility District No. 1 Facebook Page Posted: March 23, 2023 at 6:38 PM April 19, 2023 Regular Meeting Agenda Packet 25 of 71 Screenshots from Meta Business Suite dashboard for the Trophy Club Municipal Utility District No. 1 Facebook Page Posted: March 29, 2023 at 7:00 PM April 19, 2023 Regular Meeting Agenda Packet 26 of 71 FY 2023 Combined Financials YTD as of 3/31/2023 Water Budget vs Actual 88,979,203 41,702,881 41,572,326 36,351,669 33,732,116 34,390,563 101,683,000 49,007,000 52,466,000 49,082,000 34,501,000 46,119,000 0 20,000,000 40,000,000 60,000,000 80,000,000 100,000,000 120,000,000 140,000,000 Oct Nov Dec Jan Feb Mar Water Consumption Budget vs Actual Budget Consumption Actual Consumption $703,717 $395,319 $395,329 $365,714 $355,608 $351,905 $664,453 $438,585 $440,564 $424,445 $335,705 $404,421 $0 $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 $700,000 $800,000 $900,000 $1,000,000 Oct Nov Dec Jan Feb Mar Water Revenue Budget vs Actual Budget Revenue Actual Revenue $6,710,979 $6,851,560 $4,070,848 $4,284,543 $0 $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 $7,000,000 $8,000,000 Total Water Revenue Adopted Budget Water Revenue Vs Projected Water Revenue Budgeted Water Revenue Projected Water Revenue Net Budgeted Water Revenue Minus Budgeted Expenses Net Projected Water Revenue Minus Projected Expenses $11,733,354 $11,733,354 $5,650,877 $4,846,354 Adopted Budget vs YTD Actuals Revenues & Expenses YTD Revenues YTD Expenses Adopted Revenues Adopted Expenses 808,128,121 864,257,362 0 100,000,000 200,000,000 300,000,000 400,000,000 500,000,000 600,000,000 700,000,000 800,000,000 900,000,000 1,000,000,000 Total Water Consumption Adopted Budget Water Consumption Vs Actual Water Consumption Budgeted Water Consumption Projected Water Consumption $2,825,779 50% $1,936,248 34%$843,652 15% $1,494 0% $43,704 1% YTD Expense-Water YTD Expense-WW YTD Expense-Admin YTD Expense-BOD YTD Expense-Non Dept Presented by: Finance Department April 19, 2023 Regular Meeting Agenda Packet 27 of 71 4/13/2023 9:58:06 AM Page 1 of 1 Budget Variance Report Trophy Club Municipal Utility District No. 1 As Of: 03/31/2023 ACTUAL BUDGETED VARIANCE TOTAL REMAINING % Fund: 135 -MUD 1 General Fund CURRENT MONTH YEAR TO DATE ANNUAL BUDGET ACTUAL BUDGETED VARIANCE % REVENUE SUMMARY Revenue, Asset, Liability, & Equity 769,363.05 977,388.37 (208,025.32) 4,846,354.45 5,864,330.22 (1,017,975.77) 41 11,733,354.00 (6,886,999.55) 59 TOTAL REVENUE 769,363.05 977,388.37 (208,025.32) 4,846,354.45 5,864,330.22 (1,017,975.77) 41 11,733,354.00 (6,886,999.55) 59 EXPENSE SUMMARY Revenue, Asset, Liability, & Equity 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Water 637,427.05 547,941.66 (89,485.39) 2,825,779.49 3,287,649.96 461,870.47 43 6,577,932.00 (3,752,152.51) 57 Wastewater 268,694.75 290,877.74 22,182.99 1,936,247.62 1,745,266.44 (190,981.18) 55 3,491,931.00 (1,555,683.38) 45 Board of Directors 115.61 980.01 864.40 1,493.66 5,880.06 4,386.40 13 11,765.00 (10,271.34) 87 Administration 141,354.06 127,864.23 (13,489.83) 843,652.32 767,185.38 (76,466.94) 55 1,534,986.00 (691,333.68) 45 Non Deparmental 2,988.63 9,724.44 6,735.81 43,703.62 58,346.64 14,643.02 37 116,740.00 (73,036.38) 63 TOTAL EXPENSE 1,050,580.10 977,388.08 (73,192.02) 5,650,876.71 5,864,328.48 213,451.77 48 11,733,354.00 6,082,477.29 52 REVENUE OVER/(UNDER) EXPENDITURE (281,217.05) 0.29 (281,217.34) (804,522.26) 1.74 (804,524.00) 0.00 (12,969,476.84) April 19, 2023 Regular Meeting Agenda Packet 28 of 71 4/13/2023 9:58:57 AM Page 1 of 7 Monthly Budget Report Trophy Club Municipal Utility District No. 1 Account Summary For Fiscal: Current Period Ending: 03/31/2023 YTD Activity Variance Favorable (Unfavorable) Percent Remaining Total Budget March Activity March Budget Variance Favorable (Unfavorable) YTD Budget Percent Remaining Fund: 135 -MUD 1 General Fund Revenue Department: 000 -Revenue, Asset, Liability, & Equity 135-000-40000-000 Property Taxes 7,326.73 2,556.11 -4,770.62 -65.11% 43,960.38 84,068.49 40,108.11 91.24% 87,956.00 135-000-40002-000 Property Taxes/Delinquent 24.99 23.38 -1.61 -6.44% 149.94 890.72 740.78 494.05% 300.00 135-000-40015-000 Property Taxes/P & I 24.99 186.45 161.46 646.10% 149.94 580.88 430.94 287.41% 300.00 135-000-40025-000 PID Surcharges 12,080.91 0.00 -12,080.91 -100.00% 72,485.46 0.00 -72,485.46 -100.00% 145,029.00 135-000-47000-000 Water 559,024.55 404,421.09 -154,603.46 -27.66% 3,354,147.30 2,708,173.70 -645,973.60 -19.26% 6,710,979.00 135-000-47005-000 Sewer 319,845.84 306,256.68 -13,589.16 -4.25% 1,919,075.04 1,814,327.10 -104,747.94 -5.46% 3,839,686.00 135-000-47025-000 Penalties 6,497.40 15,792.56 9,295.16 143.06% 38,984.40 21,716.02 -17,268.38 -44.30% 78,000.00 135-000-47030-000 Service Charges 466.48 125.00 -341.48 -73.20% 2,798.88 700.00 -2,098.88 -74.99% 5,600.00 135-000-47035-000 Plumbing Inspections 24.99 0.00 -24.99 -100.00% 149.94 0.00 -149.94 -100.00% 300.00 135-000-47045-000 Sewer Inspections 8.33 0.00 -8.33 -100.00% 49.98 0.00 -49.98 -100.00% 100.00 135-000-47070-000 TCCC Effluent Charges 4,998.00 32.00 -4,966.00 -99.36% 29,988.00 11,875.20 -18,112.80 -60.40% 60,000.00 135-000-49011-000 Interest Income 1,666.00 35,969.78 34,303.78 2,059.05% 9,996.00 179,435.83 169,439.83 1,695.08% 20,000.00 135-000-49016-000 Cell Tower Revenue 1,178.36 4,000.00 2,821.64 239.45% 7,070.16 21,178.81 14,108.65 199.55% 14,146.00 135-000-49026-000 Proceeds from Sale of Assets 2,082.50 0.00 -2,082.50 -100.00% 12,495.00 391.30 -12,103.70 -96.87% 25,000.00 135-000-49035-000 Prior Year Reserves 47,722.57 0.00 -47,722.57 -100.00% 286,335.42 0.00 -286,335.42 -100.00% 572,900.00 135-000-49036-000 GASB Reserves 13,661.20 0.00 -13,661.20 -100.00% 81,967.20 0.00 -81,967.20 -100.00% 164,000.00 135-000-49075-000 Oversize Meter Reimbursement 171.43 0.00 -171.43 -100.00% 1,028.58 0.00 -1,028.58 -100.00% 2,058.00 135-000-49900-000 Miscellaneous Income 583.10 0.00 -583.10 -100.00% 3,498.60 3,016.40 -482.20 -13.78% 7,000.00 Total Department: 000 -Revenue, Asset, Liability, & Equity: 977,388.37 769,363.05 -208,025.32 -21.28% 5,864,330.22 4,846,354.45 -1,017,975.77 -17.36% 11,733,354.00 Total Revenue: 977,388.37 769,363.05 -208,025.32 -21.28% 5,864,330.22 4,846,354.45 -1,017,975.77 -17.36% 11,733,354.00 Expense Department: 010 -Water 135-010-50005-000 Salaries & Wages 33,914.67 45,788.32 -11,873.65 -35.01% 203,488.02 203,574.84 -86.82 -0.04% 407,139.00 135-010-50010-000 Overtime 1,416.10 1,897.86 -481.76 -34.02% 8,496.60 7,678.06 818.54 9.63% 17,000.00 135-010-50016-000 Longevity 498.38 0.00 498.38 100.00% 2,990.28 0.00 2,990.28 100.00% 5,983.00 135-010-50017-000 Certification 299.88 0.00 299.88 100.00% 1,799.28 0.00 1,799.28 100.00% 3,600.00 135-010-50020-000 Retirement 4,264.96 5,722.37 -1,457.41 -34.17% 25,589.76 25,403.99 185.77 0.73% 51,200.00 135-010-50026-000 Medical Insurance 6,890.74 7,282.28 -391.54 -5.68% 41,344.44 39,152.38 2,192.06 5.30% 82,722.00 135-010-50027-000 Dental Insurance 406.17 305.56 100.61 24.77% 2,437.02 1,934.80 502.22 20.61% 4,876.00 135-010-50028-000 Vision Insurance 62.05 63.04 -0.99 -1.60% 372.30 332.78 39.52 10.62% 745.00 135-010-50029-000 Life Insurance & Other 199.92 404.71 -204.79 -102.44% 1,199.52 2,337.01 -1,137.49 -94.83% 2,400.00 135-010-50030-000 Social Security Taxes 2,240.02 2,913.36 -673.34 -30.06% 13,440.12 12,867.26 572.86 4.26% 26,891.00 April 19, 2023 Regular Meeting Agenda Packet 29 of 71 Monthly Budget Report For Fiscal: Current Period Ending: 03/31/2023 4/13/2023 9:58:57 AM Page 2 of 7 YTD Activity Variance Favorable (Unfavorable) Percent Remaining Total Budget March Activity March Budget Variance Favorable (Unfavorable) YTD Budget Percent Remaining 135-010-50035-000 Medicare Taxes 523.87 681.34 -157.47 -30.06% 3,143.22 2,809.26 333.96 10.62% 6,289.00 135-010-50040-000 Unemployment Taxes 104.95 0.00 104.95 100.00% 629.70 44.98 584.72 92.86% 1,260.00 135-010-50045-000 Workman's Compensation 937.04 1,109.40 -172.36 -18.39% 5,622.24 6,656.40 -1,034.16 -18.39% 11,249.00 135-010-50060-000 Pre-emp Physicals/Testing 33.32 162.45 -129.13 -387.55% 199.92 312.45 -112.53 -56.29% 400.00 135-010-50070-000 Employee Relations 24.99 0.00 24.99 100.00% 149.94 132.95 16.99 11.33% 300.00 135-010-55080-000 Maintenance & Repairs 19,142.34 8,779.15 10,363.19 54.14% 114,854.04 57,508.28 57,345.76 49.93% 229,800.00 135-010-55085-000 Generator Maint. and Repair 166.60 0.00 166.60 100.00% 999.60 875.96 123.64 12.37% 2,000.00 135-010-55090-000 Vehicle Maintenance 416.50 1,544.97 -1,128.47 -270.94% 2,499.00 3,221.34 -722.34 -28.91% 5,000.00 135-010-55105-000 Maintenance-Backhoe/SkidLoader 83.30 0.00 83.30 100.00% 499.80 0.00 499.80 100.00% 1,000.00 135-010-55120-000 Cleaning Services 208.25 161.23 47.02 22.58% 1,249.50 1,128.60 120.90 9.68% 2,500.00 135-010-55135-000 Lab Analysis 624.75 260.00 364.75 58.38% 3,748.50 2,217.84 1,530.66 40.83% 7,500.00 135-010-55135-001 Lab Analysis for PID 166.60 293.92 -127.32 -76.42% 999.60 693.92 305.68 30.58% 2,000.00 135-010-60010-000 Communications/Mobiles 624.75 960.18 -335.43 -53.69% 3,748.50 3,262.82 485.68 12.96% 7,500.00 135-010-60020-000 Electricity 19,013.22 10,441.80 8,571.42 45.08% 114,079.32 72,483.36 41,595.96 36.46% 228,250.00 135-010-60066-000 Publications/Books/Subscripts 83.30 0.00 83.30 100.00% 499.80 0.00 499.80 100.00% 1,000.00 135-010-60080-000 Schools & Training 302.37 243.64 58.73 19.42% 1,814.22 1,375.52 438.70 24.18% 3,630.00 135-010-60100-000 Travel & per diem 78.13 0.00 78.13 100.00% 468.78 44.79 423.99 90.45% 938.00 135-010-60135-000 TCEQ Fees & Permits 2,499.00 0.00 2,499.00 100.00% 14,994.00 20,280.63 -5,286.63 -35.26% 30,000.00 135-010-60135-001 TCEQ Fees & Permits for PID 0.00 0.00 0.00 0.00% 0.00 213.92 -213.92 0.00% 0.00 135-010-60150-000 Wholesale Water 219,922.99 263,311.93 -43,388.94 -19.73% 1,319,537.94 798,163.91 521,374.03 39.51% 2,640,132.00 135-010-60285-000 Lawn Equipment & Maintenance 1,041.25 600.00 441.25 42.38% 6,247.50 1,200.00 5,047.50 80.79% 12,500.00 135-010-60332-000 Interfund Transfer Out-Rev I&S 47,296.24 51,616.66 -4,320.42 -9.13% 283,777.44 309,699.96 -25,922.52 -9.13% 567,782.00 135-010-60360-000 Furniture/Equipment < $5000 208.25 0.00 208.25 100.00% 1,249.50 0.00 1,249.50 100.00% 2,500.00 135-010-65005-000 Fuel & Lube 1,249.50 1,217.30 32.20 2.58% 7,497.00 8,413.72 -916.72 -12.23% 15,000.00 135-010-65010-000 Uniforms 362.77 171.98 190.79 52.59% 2,176.62 2,205.56 -28.94 -1.33% 4,355.00 135-010-65030-000 Chemicals 2,082.50 6,334.48 -4,251.98 -204.18% 12,495.00 24,181.87 -11,686.87 -93.53% 25,000.00 135-010-65050-000 Meter Expense 1,666.00 0.00 1,666.00 100.00% 9,996.00 0.00 9,996.00 100.00% 20,000.00 135-010-65053-000 Meter Change Out Program 7,247.10 0.00 7,247.10 100.00% 43,482.60 0.00 43,482.60 100.00% 87,000.00 135-010-69005-000 Capital Outlays 145,941.60 225,159.12 -79,217.52 -54.28% 875,649.60 909,515.37 -33,865.77 -3.87% 1,752,000.00 135-010-69008-000 Short Term Debt-Principal 2,655.77 0.00 2,655.77 100.00% 15,934.62 31,882.11 -15,947.49 -100.08% 31,882.00 135-010-69009-000 Short Term Debt-Interest 39.15 0.00 39.15 100.00% 234.90 470.26 -235.36 -100.20% 470.00 135-010-69195-000 GASB Reserve for Replacement 13,547.82 0.00 13,547.82 100.00% 81,286.92 162,639.00 -81,352.08 -100.08% 162,639.00 135-010-69281-000 Water Tank Inspection Contract 9,454.55 0.00 9,454.55 100.00% 56,727.30 110,863.59 -54,136.29 -95.43% 113,500.00 Total Department: 010 -Water: 547,941.66 637,427.05 -89,485.39 -16.33% 3,287,649.96 2,825,779.49 461,870.47 14.05% 6,577,932.00 Department: 020 -Wastewater 135-020-50005-000 Salaries & Wages 25,794.26 28,874.36 -3,080.10 -11.94% 154,765.56 168,474.29 -13,708.73 -8.86% 309,655.00 135-020-50010-000 Overtime 2,748.90 2,038.40 710.50 25.85% 16,493.40 8,783.95 7,709.45 46.74% 33,000.00 135-020-50016-000 Longevity 336.11 0.00 336.11 100.00% 2,016.66 0.00 2,016.66 100.00% 4,035.00 135-020-50017-000 Certification 524.79 0.00 524.79 100.00% 3,148.74 0.00 3,148.74 100.00% 6,300.00 135-020-50020-000 Retirement 3,471.19 3,709.54 -238.35 -6.87% 20,827.14 21,324.78 -497.64 -2.39% 41,671.00 135-020-50026-000 Medical Insurance 8,045.03 4,539.40 3,505.63 43.58% 48,270.18 34,636.01 13,634.17 28.25% 96,579.00 135-020-50027-000 Dental Insurance 452.06 167.64 284.42 62.92% 2,712.36 1,575.64 1,136.72 41.91% 5,427.00 April 19, 2023 Regular Meeting Agenda Packet 30 of 71 Monthly Budget Report For Fiscal: Current Period Ending: 03/31/2023 4/13/2023 9:58:57 AM Page 3 of 7 YTD Activity Variance Favorable (Unfavorable) Percent Remaining Total Budget March Activity March Budget Variance Favorable (Unfavorable) YTD Budget Percent Remaining 135-020-50028-000 Vision Insurance 66.05 42.78 23.27 35.23% 396.30 291.14 105.16 26.54% 793.00 135-020-50029-000 Life Insurance & Other 199.92 236.32 -36.40 -18.21% 1,199.52 1,984.73 -785.21 -65.46% 2,400.00 135-020-50030-000 Social Security Taxes 1,823.02 1,868.64 -45.62 -2.50% 10,938.12 10,812.34 125.78 1.15% 21,885.00 135-020-50035-000 Medicare Taxes 426.32 437.00 -10.68 -2.51% 2,557.92 2,528.67 29.25 1.14% 5,118.00 135-020-50040-000 Unemployment Taxes 104.95 0.00 104.95 100.00% 629.70 43.66 586.04 93.07% 1,260.00 135-020-50045-000 Workman's Compensation 748.61 886.28 -137.67 -18.39% 4,491.66 5,317.68 -826.02 -18.39% 8,987.00 135-020-50060-000 Pre-emp Physicals/Testing 33.32 0.00 33.32 100.00% 199.92 150.00 49.92 24.97% 400.00 135-020-50070-000 Employee Relations 24.99 0.00 24.99 100.00% 149.94 663.09 -513.15 -342.24% 300.00 135-020-55080-000 Maintenance & Repairs 11,212.18 6,228.48 4,983.70 44.45% 67,273.08 101,636.79 -34,363.71 -51.08% 134,600.00 135-020-55081-000 Mainten & Repairs Collections 23,407.30 7,107.12 16,300.18 69.64% 140,443.80 107,585.45 32,858.35 23.40% 281,000.00 135-020-55085-000 Generator Maint. and Repair 749.70 0.00 749.70 100.00% 4,498.20 2,836.29 1,661.91 36.95% 9,000.00 135-020-55090-000 Vehicle Maintenance 383.18 0.00 383.18 100.00% 2,299.08 491.81 1,807.27 78.61% 4,600.00 135-020-55091-000 Veh Maintenance Collections 1,082.90 870.46 212.44 19.62% 6,497.40 4,666.02 1,831.38 28.19% 13,000.00 135-020-55105-000 Maintenance-Backhoe/SkidLoader 249.90 0.00 249.90 100.00% 1,499.40 1,408.94 90.46 6.03% 3,000.00 135-020-55120-000 Cleaning Services 166.60 161.22 5.38 3.23% 999.60 1,128.55 -128.95 -12.90% 2,000.00 135-020-55125-000 Dumpster Services 8,330.00 8,516.34 -186.34 -2.24% 49,980.00 40,704.23 9,275.77 18.56% 100,000.00 135-020-55135-000 Lab Analysis 3,332.00 3,471.60 -139.60 -4.19% 19,992.00 22,378.17 -2,386.17 -11.94% 40,000.00 135-020-60010-000 Communications/Mobiles 624.75 754.48 -129.73 -20.77% 3,748.50 2,940.85 807.65 21.55% 7,500.00 135-020-60020-000 Electricity 23,017.28 21,938.42 1,078.86 4.69% 138,103.68 111,469.48 26,634.20 19.29% 276,318.00 135-020-60080-000 Schools & Training 302.37 1,165.00 -862.63 -285.29% 1,814.22 1,741.00 73.22 4.04% 3,630.00 135-020-60100-000 Travel & per diem 86.46 0.00 86.46 100.00% 518.76 0.00 518.76 100.00% 1,038.00 135-020-60135-000 TCEQ Fees & Permits 999.60 0.00 999.60 100.00% 5,997.60 9,888.02 -3,890.42 -64.87% 12,000.00 135-020-60285-000 Lawn Equipment & Maintenance 1,332.80 1,010.00 322.80 24.22% 7,996.80 1,720.00 6,276.80 78.49% 16,000.00 135-020-60331-000 Interfund Transfer Out-Tax I&S 9,683.20 10,567.73 -884.53 -9.13% 58,099.20 63,406.38 -5,307.18 -9.13% 116,245.00 135-020-60332-000 Interfund Transfer Out-Rev I&S 57,637.85 62,902.88 -5,265.03 -9.13% 345,827.10 377,417.28 -31,590.18 -9.13% 691,931.00 135-020-60360-000 Furniture/Equipment < $5000 41.65 0.00 41.65 100.00% 249.90 0.00 249.90 100.00% 500.00 135-020-65005-000 Fuel & Lube 1,041.25 648.79 392.46 37.69% 6,247.50 5,725.15 522.35 8.36% 12,500.00 135-020-65010-000 Uniforms 367.76 0.00 367.76 100.00% 2,206.56 2,288.35 -81.79 -3.71% 4,415.00 135-020-65030-000 Chemicals 2,707.25 0.00 2,707.25 100.00% 16,243.50 12,677.47 3,566.03 21.95% 32,500.00 135-020-65031-000 Chemicals Collections 833.00 0.00 833.00 100.00% 4,998.00 6,002.80 -1,004.80 -20.10% 10,000.00 135-020-65045-000 Lab Supplies 2,748.90 2,515.68 233.22 8.48% 16,493.40 18,678.49 -2,185.09 -13.25% 33,000.00 135-020-69005-000 Capital Outlays 74,553.50 98,036.19 -23,482.69 -31.50% 447,321.00 551,336.32 -104,015.32 -23.25% 895,000.00 135-020-69008-000 Short Term Debt-Principal 7,144.30 0.00 7,144.30 100.00% 42,865.80 63,804.49 -20,938.69 -48.85% 85,766.00 135-020-69009-000 Short Term Debt-Interest 233.32 0.00 233.32 100.00% 1,399.92 1,952.31 -552.39 -39.46% 2,801.00 135-020-69195-000 GASB Reserve for Replacement 13,809.22 0.00 13,809.22 100.00% 82,855.32 165,777.00 -82,921.68 -100.08% 165,777.00 Total Department: 020 -Wastewater: 290,877.74 268,694.75 22,182.99 7.63% 1,745,266.44 1,936,247.62 -190,981.18 -10.94% 3,491,931.00 Department: 026 -Board of Directors 135-026-50045-000 Workman's Compensation 1.24 0.62 0.62 50.00% 7.44 3.72 3.72 50.00% 15.00 135-026-60070-000 Dues & Memberships 62.47 0.00 62.47 100.00% 374.82 750.00 -375.18 -100.10% 750.00 135-026-60075-000 Meetings 124.95 114.99 9.96 7.97% 749.70 689.94 59.76 7.97% 1,500.00 135-026-60080-000 Schools & Training 333.20 0.00 333.20 100.00% 1,999.20 50.00 1,949.20 97.50% 4,000.00 135-026-60100-000 Travel & per diem 416.50 0.00 416.50 100.00% 2,499.00 0.00 2,499.00 100.00% 5,000.00 April 19, 2023 Regular Meeting Agenda Packet 31 of 71 Monthly Budget Report For Fiscal: Current Period Ending: 03/31/2023 4/13/2023 9:58:57 AM Page 4 of 7 YTD Activity Variance Favorable (Unfavorable) Percent Remaining Total Budget March Activity March Budget Variance Favorable (Unfavorable) YTD Budget Percent Remaining 135-026-60245-000 Miscellaneous Expenses 41.65 0.00 41.65 100.00% 249.90 0.00 249.90 100.00% 500.00 Total Department: 026 -Board of Directors: 980.01 115.61 864.40 88.20% 5,880.06 1,493.66 4,386.40 74.60% 11,765.00 Department: 030 -Administration 135-030-50005-000 Salaries & Wages 51,724.13 71,314.47 -19,590.34 -37.87% 310,344.78 297,616.64 12,728.14 4.10% 620,938.00 135-030-50010-000 Overtime 166.60 13.16 153.44 92.10% 999.60 574.42 425.18 42.54% 2,000.00 135-030-50016-000 Longevity 201.83 0.00 201.83 100.00% 1,210.98 0.00 1,210.98 100.00% 2,423.00 135-030-50020-000 Retirement 6,149.53 8,532.35 -2,382.82 -38.75% 36,897.18 35,785.32 1,111.86 3.01% 73,824.00 135-030-50026-000 Medical Insurance 9,686.95 5,629.38 4,057.57 41.89% 58,121.70 33,754.83 24,366.87 41.92% 116,290.00 135-030-50027-000 Dental Insurance 504.04 206.34 297.70 59.06% 3,024.24 1,545.20 1,479.04 48.91% 6,051.00 135-030-50028-000 Vision Insurance 74.88 46.50 28.38 37.90% 449.28 278.90 170.38 37.92% 899.00 135-030-50029-000 Life Insurance & Other 199.92 534.97 -335.05 -167.59% 1,199.52 2,889.77 -1,690.25 -140.91% 2,400.00 135-030-50030-000 Social Security Taxes 3,229.70 4,297.95 -1,068.25 -33.08% 19,378.20 17,515.19 1,863.01 9.61% 38,772.00 135-030-50035-000 Medicare Taxes 755.36 1,005.16 -249.80 -33.07% 4,532.16 4,162.12 370.04 8.16% 9,068.00 135-030-50040-000 Unemployment Taxes 125.94 4.86 121.08 96.14% 755.64 58.54 697.10 92.25% 1,512.00 135-030-50045-000 Workman's Compensation 124.61 107.60 17.01 13.65% 747.66 645.60 102.06 13.65% 1,496.00 135-030-50060-000 Pre-emp Physicals/Testing 41.65 0.00 41.65 100.00% 249.90 198.45 51.45 20.59% 500.00 135-030-50070-000 Employee Relations 333.20 0.00 333.20 100.00% 1,999.20 2,563.57 -564.37 -28.23% 4,000.00 135-030-55030-000 Software & Support 10,970.61 1,837.89 9,132.72 83.25% 65,823.66 67,088.65 -1,264.99 -1.92% 131,700.00 135-030-55070-000 Independent Labor 1,249.50 1,395.00 -145.50 -11.64% 7,497.00 5,235.69 2,261.31 30.16% 15,000.00 135-030-55080-000 Maintenance & Repairs 3,332.00 1,425.50 1,906.50 57.22% 19,992.00 10,241.19 9,750.81 48.77% 40,000.00 135-030-55085-000 Generator Maint. and Repair 249.90 0.00 249.90 100.00% 1,499.40 0.00 1,499.40 100.00% 3,000.00 135-030-55120-000 Cleaning Services 999.60 967.35 32.25 3.23% 5,997.60 7,069.69 -1,072.09 -17.88% 12,000.00 135-030-55160-000 Professional Outside Services 6,250.83 2,899.25 3,351.58 53.62% 37,504.98 69,676.51 -32,171.53 -85.78% 75,040.00 135-030-55205-000 Utility Billing Contract 749.70 643.15 106.55 14.21% 4,498.20 3,902.93 595.27 13.23% 9,000.00 135-030-60005-000 Telephone 499.80 492.52 7.28 1.46% 2,998.80 2,840.80 158.00 5.27% 6,000.00 135-030-60010-000 Communications/Mobiles 249.90 0.00 249.90 100.00% 1,499.40 0.00 1,499.40 100.00% 3,000.00 135-030-60020-000 Electricity/Gas 2,029.93 1,393.11 636.82 31.37% 12,179.58 9,020.78 3,158.80 25.94% 24,369.00 135-030-60025-000 Water 416.50 399.75 16.75 4.02% 2,499.00 2,341.38 157.62 6.31% 5,000.00 135-030-60035-000 Postage 2,499.00 1,915.08 583.92 23.37% 14,994.00 11,736.31 3,257.69 21.73% 30,000.00 135-030-60040-000 Service Charges & Fees 7,913.50 21,761.86 -13,848.36 -175.00% 47,481.00 60,771.09 -13,290.09 -27.99% 95,000.00 135-030-60050-000 Bad Debt Expense 124.95 0.00 124.95 100.00% 749.70 48.65 701.05 93.51% 1,500.00 135-030-60055-000 Insurance 7,347.06 8,117.81 -770.75 -10.49% 44,082.36 48,706.86 -4,624.50 -10.49% 88,200.00 135-030-60070-000 Dues & Memberships 541.45 0.00 541.45 100.00% 3,248.70 2,289.00 959.70 29.54% 6,500.00 135-030-60079-000 Public Education 3,332.00 1,727.50 1,604.50 48.15% 19,992.00 18,097.48 1,894.52 9.48% 40,000.00 135-030-60080-000 Schools & Training 270.72 0.00 270.72 100.00% 1,624.32 120.00 1,504.32 92.61% 3,250.00 135-030-60100-000 Travel & per diem 132.28 0.00 132.28 100.00% 793.68 0.00 793.68 100.00% 1,588.00 135-030-60245-000 Miscellaneous Expenses 0.00 0.00 0.00 0.00% 0.00 88.00 -88.00 0.00% 0.00 135-030-60285-000 Lawn Equipment & Maintenance 416.50 469.67 -53.17 -12.77% 2,499.00 1,589.72 909.28 36.39% 5,000.00 135-030-60360-000 Furniture/Equipment < $5000 833.00 0.00 833.00 100.00% 4,998.00 13,052.82 -8,054.82 -161.16% 10,000.00 135-030-65010-000 Uniforms 44.14 0.00 44.14 100.00% 264.84 0.00 264.84 100.00% 530.00 135-030-65055-000 Hardware 699.72 2,943.80 -2,244.08 -320.71% 4,198.32 3,447.10 751.22 17.89% 8,400.00 135-030-65085-000 Office Supplies 499.80 53.31 446.49 89.33% 2,998.80 2,757.68 241.12 8.04% 6,000.00 April 19, 2023 Regular Meeting Agenda Packet 32 of 71 Monthly Budget Report For Fiscal: Current Period Ending: 03/31/2023 4/13/2023 9:58:57 AM Page 5 of 7 YTD Activity Variance Favorable (Unfavorable) Percent Remaining Total Budget March Activity March Budget Variance Favorable (Unfavorable) YTD Budget Percent Remaining 135-030-65095-000 Maintenance Supplies 333.20 708.26 -375.06 -112.56% 1,999.20 3,133.96 -1,134.76 -56.76% 4,000.00 135-030-69005-000 Capital Outlays 0.00 260.00 -260.00 0.00% 0.00 74,465.10 -74,465.10 0.00% 0.00 135-030-69170-000 Copier Lease Installments 333.20 250.51 82.69 24.82% 1,999.20 1,606.38 392.82 19.65% 4,000.00 135-030-69195-000 GASB Reserve for Replacement 2,227.10 0.00 2,227.10 100.00% 13,362.60 26,736.00 -13,373.40 -100.08% 26,736.00 Total Department: 030 -Administration: 127,864.23 141,354.06 -13,489.83 -10.55% 767,185.38 843,652.32 -76,466.94 -9.97% 1,534,986.00 Department: 039 -Non Deparmental 135-039-55045-000 Legal 5,414.50 825.00 4,589.50 84.76% 32,487.00 10,170.00 22,317.00 68.70% 65,000.00 135-039-55055-000 Auditing 2,815.54 0.00 2,815.54 100.00% 16,893.24 22,551.10 -5,657.86 -33.49% 33,800.00 135-039-55060-000 Appraisal 1,077.90 2,163.63 -1,085.73 -100.73% 6,467.40 6,936.52 -469.12 -7.25% 12,940.00 135-039-55065-000 Tax Admin Fees 416.50 0.00 416.50 100.00% 2,499.00 4,046.00 -1,547.00 -61.90% 5,000.00 Total Department: 039 -Non Deparmental: 9,724.44 2,988.63 6,735.81 69.27% 58,346.64 43,703.62 14,643.02 25.10% 116,740.00 Total Expense: 977,388.08 1,050,580.10 -73,192.02 -7.49% 5,864,328.48 5,650,876.71 213,451.77 3.64% 11,733,354.00 Total Revenues 977,388.37 769,363.05 -208,025.32 -21.28% 5,864,330.22 4,846,354.45 -1,017,975.77 -17.36% 11,733,354.00 Total Fund: 135 -MUD 1 General Fund: 0.29 -281,217.05 -281,217.34 1.74 -804,522.26 -804,524.00 0.00 Report Total: 0.29 -281,217.05 -281,217.34 1.74 -804,522.26 -804,524.00 0.00 April 19, 2023 Regular Meeting Agenda Packet 33 of 71 Monthly Budget Report For Fiscal: Current Period Ending: 03/31/2023 4/13/2023 9:58:57 AM Page 6 of 7 Group Summary Departmen… YTD Activity Variance Favorable (Unfavorable) Percent Remaining Total Budget March Activity March Budget Variance Favorable (Unfavorable) YTD Budget Percent Remaining Fund: 135 -MUD 1 General Fund Revenue 000 -Revenue, Asset, Liability, & Equity 977,388.37 769,363.05 -208,025.32 -21.28% 5,864,330.22 4,846,354.45 -1,017,975.77 -17.36% 11,733,354.00 Total Revenue: 977,388.37 769,363.05 -208,025.32 -21.28% 5,864,330.22 4,846,354.45 -1,017,975.77 -17.36% 11,733,354.00 Expense 010 -Water 547,941.66 637,427.05 -89,485.39 -16.33% 3,287,649.96 2,825,779.49 461,870.47 14.05% 6,577,932.00 020 -Wastewater 290,877.74 268,694.75 22,182.99 7.63% 1,745,266.44 1,936,247.62 -190,981.18 -10.94% 3,491,931.00 026 -Board of Directors 980.01 115.61 864.40 88.20% 5,880.06 1,493.66 4,386.40 74.60% 11,765.00 030 -Administration 127,864.23 141,354.06 -13,489.83 -10.55% 767,185.38 843,652.32 -76,466.94 -9.97% 1,534,986.00 039 -Non Deparmental 9,724.44 2,988.63 6,735.81 69.27% 58,346.64 43,703.62 14,643.02 25.10% 116,740.00 Total Expense: 977,388.08 1,050,580.10 -73,192.02 -7.49% 5,864,328.48 5,650,876.71 213,451.77 3.64% 11,733,354.00 Total Revenues 977,388.37 769,363.05 -208,025.32 -21.28% 5,864,330.22 4,846,354.45 -1,017,975.77 -17.36% 11,733,354.00 Total Fund: 135 -MUD 1 General Fund: 0.29 -281,217.05 -281,217.34 1.74 -804,522.26 -804,524.00 0.00 Report Total: 0.29 -281,217.05 -281,217.34 1.74 -804,522.26 -804,524.00 0.00 April 19, 2023 Regular Meeting Agenda Packet 34 of 71 Monthly Budget Report For Fiscal: Current Period Ending: 03/31/2023 4/13/2023 9:58:57 AM Page 7 of 7 Fund Summary Fund YTD Activity Variance Favorable (Unfavorable) Percent Remaining Total Budget March Activity March Budget Variance Favorable (Unfavorable) YTD Budget Percent Remaining 135 -MUD 1 General Fund 0.29 -281,217.05 -281,217.34 1.74 -804,522.26 -804,524.00 0.00 Report Total: 0.29 -281,217.05 -281,217.34 1.74 -804,522.26 -804,524.00 0.00 April 19, 2023 Regular Meeting Agenda Packet 35 of 71 4/13/2023 11:24:01 AM Page 1 of 1 Balance Sheet Funds 122 -528 Trophy Club Municipal Utility District No. 1 Account Summary As Of 03/31/2023 Department Total 122 -Trophy Club MUD Fire Dept. 135 -MUD 1 General Fund 137 -MUD 1 Consolidated GASB 519 -2016 Rev Bond Const-SWIFT 520 -Revenue Bond 16" Waterline 528 -2015 Revenue Bond Reserve Fund Asset000 -Revenue, Asset, Liability, & Equity 1,156,680.67 10,418,056.56 3,422,146.58 799,196.16 1,149,344.83 918,594.28 17,864,019.08 Total Asset: 1,156,680.67 10,418,056.56 3,422,146.58 799,196.16 1,149,344.83 918,594.28 17,864,019.08 Liability 000 -Revenue, Asset, Liability, & Equity 22,198.00 775,040.75 0.00 81,691.15 158,280.07 0.00 1,037,209.97 Total Liability: 22,198.00 775,040.75 0.00 81,691.15 158,280.07 0.00 1,037,209.97 Equity 000 -Revenue, Asset, Liability, & 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 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 1,220,594.78 4,846,354.45 436,572.00 11,974.81 26,436.11 17,989.87 6,559,922.02 Total Expense 767,915.68 5,650,876.71 0.00 0.00 374,468.28 0.00 6,793,260.67 Revenues Over/Under Expenses 452,679.10 -804,522.26 436,572.00 11,974.81 -348,032.17 17,989.87 -233,338.65 Total Equity and Current Surplus (Deficit): 1,134,482.67 Total Liabilities, Equity and Current Surplus (Deficit): 1,156,680.67 9,643,015.81 3,422,146.58 717,505.01 991,064.76 918,594.28 16,826,809.11 10,418,056.56 3,422,146.58 799,196.16 1,149,344.83 918,594.28 17,864,019.08 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 • March Fire Station transfer OUT to cover GO Bond payment allocation into Fund 533 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 I&S Revenue Bond payments for Fund 534, 535, & 535 • 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 April 19, 2023 Regular Meeting Agenda Packet 36 of 71 4/13/2023 11:24:49 AM Page 1 of 1 Balance Sheet I&S Funds 533 -536 Trophy Club Municipal Utility District No. 1 Account Summary As Of 03/31/2023 Department Total 533 -MUD 1 I&S Consolidated 534 -2015 Revenue Bond I&S 535 -2016 Rev Bond I&S-SWIFT 536 -2019 Rev Bond I&SW&WW System Asset000 -Revenue, Asset, Liability, & Equity 925,372.02 268,700.95 130,497.97 102,695.56 1,427,266.50 Total Asset: 925,372.02 268,700.95 130,497.97 102,695.56 1,427,266.50 Liability 000 -Revenue, Asset, Liability, & Equity 51,819.75 0.00 0.00 0.00 51,819.75 Total Liability: 51,819.75 0.00 0.00 0.00 51,819.75 Equity 000 -Revenue, Asset, Liability, & Equity 4,145.11 27,958.35 6,554.77 1,429.17 40,087.40 Total Total Beginning Equity: 4,145.11 27,958.35 6,554.77 1,429.17 40,087.40 Total Revenue 943,985.99 333,061.35 151,712.45 208,535.14 1,637,294.93 Total Expense 74,578.83 92,318.75 27,769.25 107,268.75 301,935.58 Revenues Over/Under Expenses 869,407.16 240,742.60 123,943.20 101,266.39 1,335,359.35 Total Equity and Current Surplus (Deficit): 873,552.27 Total Liabilities, Equity and Current Surplus (Deficit): 925,372.02 268,700.95 130,497.97 102,695.56 1,375,446.75 268,700.95 130,497.97 102,695.56 1,427,266.50 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 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 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 Revenue Bond payment from Fund 533 • 3/1 & 9/1 Revenue Bond payments (Interest and Principal) • Monthly bank interest April 19, 2023 Regular Meeting Agenda Packet 37 of 71 REGULAR MEETING MINUTES TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 BOARD OF DIRECTORS March 22, 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 Wednesday, March 22, 2023, at 6:30 p.m., in the Boardroom of the Administration Building, 100 Municipal Drive, Trophy Club, Texas 76262. The meeting was held within the boundaries of the District and was open to the public. STATE OF TEXAS § COUNTIES OF DENTON AND TARRANT § BOARD MEMBERS PRESENT: Kevin R. Carr President Ben Brewster Vice President Doug Harper Secretary/Treasurer William C. Rose Director Tracey Hunter Director STAFF PRESENT: Alan Fourmentin General Manager Laurie Slaght District Secretary Mike McMahon Operations Manager Steven Krolczyk Finance Manager Emily Rodgers General Legal Counsel (Executive Session) GUESTS PRESENT: Steve Durman 4ManFurnace Chris Ekrut NewGen Strategies and Solutions, LLC. CALL TO ORDER AND ANNOUNCE A QUORUM President Carr announced the date of March 22, 2023, called the meeting to order and announced a quorum present at 6:32 p.m. CITIZEN COMMENTS Steve Flynn 417 Ramsey Trail Jeff Beach 2809 Sherwood Drive REPORTS & UPDATES 1. Staff Reports a. Capital Improvement Projects b. Water Operations Report c. Wastewater System Reports d. Finance Reports General Manager Fourmentin provided the monthly staff reports and answered questions related thereto. April 19, 2023 Regular Meeting Agenda Packet 38 of 71 CONSENT AGENDA 2. Consider and act to approve the Consent Agenda. a. February 2023 Combined Financials b. February 15, 2023, Regular Meeting Minutes c. March 10, 2023, Special Meeting Minutes Motion made by Director Rose and seconded by Director Brewster to approve the consent agenda as presented. Motion carried unanimously. REGULAR SESSION 3. Community Education Initiative Update. Steve Durman presented the Board with an overview and schedule of the community initiatives, schedule and answered questions related thereto. 4. Discussion and possible action regarding annual Winter Average analysis. Chris Ekrut with NewGen Strategies and Solutions, LLC., provided the Board with a presentation of the winter averaging analysis and made recommendations for an increase in the commercial sewer volumetric rate from $6.78 to $8.57. 5. Consider and act to adopt Rate Order No. 2023‐0322A Establishing Policies, Procedures and Rates, Fees and Charges for Water and Sewer Services. Motion made by Director Rose and seconded by Director Brewster to adopt Rate Order No. 2023‐0322A Establishing Policies, Procedures and Rates, Fees and Charges for Water and Sewer Services, increasing the cost of commercial wastewater from $6.57 to $8.57/and setting an effective date of April 1, 2023. Motion carried unanimously. 6. Consider and act regarding approval of Contract No. 2023032201 with Kleen Pipe for wastewater collection system repairs. Motion made by Director Rose and seconded by Director Harper to award Contract No. 2023032201 for wastewater collection system repairs to Kleen Pipe for an amount not to exceed $190,000.00 and authorize the General Manager to execute the necessary documents. Motion carried unanimously. 7. Discussion and possible action regarding First Amendment to Amended and Restated Contract for Wholesale Water and Wastewater to Town of Trophy Club. April 19, 2023 Regular Meeting Agenda Packet 39 of 71 Motion made by Director Rose and seconded by Director Harper to approve the First Amendment to Amended and Restated Contract for Wholesale Water and Wastewater to Town of Trophy Club with the addition in item 2 in the next to last sentence of September 20, 2016 “as amended and/or restated”. Motion carried unanimously. 8. Discussion and possible action regarding the number of political signs per issue and per candidate allowed on District property. (Hunter) Motion made by Director Hunter and seconded by Director Brewster to adopt a policy regarding political signs that anyone running for political office must obtain written permission from the District to plant a political sign on the fire department property, whereas, such document is provided to the District staff and or the General Manager at least one day prior to placement of the sign on the fire department property in addition, sign walkers with political signs shall be prohibited; and, allow only one sign to follow the direction of the Town sign policy. For: Brewster, Hunter Opposed: Carr, Harper, and Rose Motion failed 3‐2 9. Discussion and possible action regarding the Town of Trophy Club/Westlake Financial Feasibility Study concerning dissolution of District. This item is moved to Executive Session to seek legal advice. The Board convened into Executive Session at 8:12 p.m. EXECUTIVE SESSION 10. 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: Consult with legal counsel to secure legal advice concerning joint strategic planning with the Town of Trophy Club. Agenda item 9 is moved to Executive Session to seek legal advice. The Board reconvened into Regular Session at 9:32 p.m. REGULAR SESSION 11. Consider and act regarding items discussed in Executive Session. April 19, 2023 Regular Meeting Agenda Packet 40 of 71 Cost Participation Motion made by Director Brewster and seconded by Director Hunter to approve the District participation in cost sharing the feasible study with the Town of Westlake and the Town of Trophy Club in the financial dissolution of the district for an amount not to exceed 1/3rd of the total cost of the study. For: Brewster, Hunter Oppose: Rose, Harper, and Carr Motion Failed 3‐2 NewGen Participation Motion made by Director Brewster and seconded by Director Carr to allow NewGen Strategies and Solutions, LLC., to participate in the feasibility study for dissolution of the District. For: Brewster, Carr, Harper, and Hunter Oppose: Rose Motion passed 4‐1 Representatives to attend committee meetings. Motion made by Director Brewster and seconded by Director Hunter to have the General Manager, Board President, and Secretary/Treasurer participate in the feasibility study meetings. For: Carr, Brewster, Hunter, and Rose Abstain: Harper Motion passed 3‐0‐1 12. Items for future agendas: Brewster/Rose – Add an item to discuss the Fire ILA. 13. Set future Meeting dates ‐April 19, 2023, at 6:30 p.m. ADJOURN President Carr called the meeting adjourned at 9:52 p.m. ___________________________ Kevin Carr, President ____________________________ Doug Harper, Secretary/Treasurer (SEAL) ____________________________ Laurie Slaght, District Secretary April 19, 2023 Regular Meeting Agenda Packet 41 of 71 Prepared By Investment Officer Restricted/Account or Sec Rate /Call Purchase Beginning Book Beginning Market Ending Book Ending Market Gain/Loss Unrestricted CUSIP Type Par Coupon Maturity Date Price Yield % 12/31/2022 12/31/2022 3/31/2023 3/31/2023 End MV-End BV Checking & Money Market Accounts Unrestricted-135 XXX8701 Prosperity Bank Consolidated Cash-General Fund $ 4,606,847 0.000% N/A N/A 100.000 0.35% $ 5,260,854 $ 5,260,854 $ 4,606,847 $ 4,606,847 0.00 Unrestricted-122 XXX8701 Prosperity Bank Consolidated Cash-Fire Dept $ -0.000% N/A N/A 100.000 0.35% $ -$ -$ -$ -0.00 Restricted-533 XXX8701 Prosperity Bank Consolidated Cash-Tax I&S $ -0.000% N/A N/A 100.000 0.35% $ -$ -$ -$ -0.00 Pools & Funds Unrestricted-135 XXXXX0002 TexPool Municipal Fund-Operating $ 2,908,395 0.000% N/A N/A 100.000 4.78% $ 3,153,780 $ 3,153,780 $ 2,908,395 $ 2,908,395 0.00 Restricted-122 TexPool Municipal Fund-Fire Dept $ 1,117,295 0.000% N/A N/A 100.000 4.78% $ 916,567 $ 916,567 $ 1,117,295 $ 1,117,295 0.00 Restricted-137 TexPool Municipal Fund-GASB Replacement $ 3,422,147 0.000% N/A N/A 100.000 4.78% $ 3,422,147 $ 3,422,147 $ 3,422,147 $ 3,422,147 0.00 Restricted-533 XXXXX0003 TexPool Tax Debt Service $ 921,368 0.000% N/A N/A 100.000 4.78% $ 407,648 $ 407,648 $ 921,368 $ 921,368 0.00 Restricted-534 XXXXX00013 Texpool Revenue Bond I&S $ 268,701 0.000% N/A N/A 100.000 4.78% $ 193,722 $ 193,722 $ 268,701 $ 268,701 0.00 Restricted-528 XXXXX00014 Texpool Revenue Bond Reserve $ 918,594 0.000% N/A N/A 100.000 4.78% $ 908,589 $ 908,589 $ 918,594 $ 918,594 0.00 Restricted-519 XXXXX00015 Texpool Revenue Bond Construction-SWIFT $ -0.000% N/A N/A 100.000 4.78% $ -$ -$ -$ -0.00 Restricted-535 XXXXX00017 Texpool Revenue Bond I&S-SWIFT $ 130,498 0.000% N/A N/A 100.000 4.78% $ 82,037 $ 82,037 $ 130,498 $ 130,498 0.00 Restricted-520 XXXXX00018 Texpool Revenue Bond Construction Series 2019 $ 1,149,345 0.000% N/A N/A 100.000 4.78% $ 1,286,795 $ 1,286,795 $ 1,149,345 $ 1,149,345 0.00 Restricted-536 XXXXX00020 Texpool Revenue Bond I&S Series 2019 $ 102,696 0.000% N/A N/A 100.000 4.78% $ 105,334 $ 105,334 $ 102,696 $ 102,696 0.00 Savings Accounts Restricted XXXXX7724 Prosperity Bank Cash Reserve-Money Mkt $ 1,903,209 0.000% N/A N/A 100.000 2.50% $ 1,891,874 $ 1,891,874 $ 1,903,209 $ 1,903,209 0.00 Escrow/Treasuries Restricted-519 82-1747-01-1 Revenue Bond Series 2016 Escrow-BOK $ 799,196 4.17% $ 792,026 $ 792,026 $ 799,196 $ 799,196 0.00 CD'S NONE US Agencies NONE $ 18,248,291 $ 18,421,373 $ 18,421,373 $ 18,248,291 $ 18,248,291 $ -EARNINGS SUMMARY Restricted/Settle Date Sec Type Account Number Par Coupon Maturity Qtr. Accrued Qtr. Amort. Total Qtr. Earnings Unrestricted Checking & Money Market Accounts Unrestricted-135 Prosperity Bank Consolidated Cash-General Fund XXX8701 $ 4,606,847 N/A N/A $ 4,673 N/A $ 4,673 Unrestricted-122 Prosperity Bank Consolidated Cash-Fire Dept XXX8701 $ -N/A N/A $ -N/A $ -Restricted-533 Prosperity Bank Consolidated Cash-Tax I&S XXX8701 $ -N/A N/A $ -N/A $ -Pools & Funds Unrestricted-135 TexPool Municipal Fund XXXXX0002 $ 7,447,837 N/A N/A $ 85,291 N/A $ 85,291 Restricted-533 TexPool Tax Debt Service XXXXX0003 $ 921,368 N/A N/A $ 6,904 N/A $ 6,904 Restricted-534 Texpool Revenue Bond I&S XXXXX00013 $ 268,701 N/A N/A $ 2,397 N/A $ 2,397 Restricted-528 Texpool Revenue Bond Reserve XXXXX00014 $ 918,594 N/A N/A $ 10,006 N/A $ 10,006 Restricted-519 Texpool Revenue Bond Construction-SWIFT XXXXX00015 $ -N/A N/A $ -NA $ -Restricted-535 Texpool Revenue Bond I&S-SWIFT XXXXX00017 $ 130,498 N/A N/A $ 1,083 NA $ 1,083 Restricted-520 Texpool Revenue Bond Construction Series 2019 XXXXX00018 $ 1,149,345 N/A N/A $ 14,124 NA $ 14,124 Restricted-536 Texpool Revenue Bond I&S Series 2019 XXXXX00020 $ 102,696 N/A N/A $ 1,120 NA $ 1,120 Savings Accounts Restricted Prosperity Bank Cash Reserve-Money Mkt XXXXX7724 $ 1,903,209 N/A N/A $ 11,335 N/A $ 11,335 Escrows/Treasuries Restricted-519 Revenue Bond Series 2016 Escrow-BOK 82-1747-01-1 $ 799,196 N/A N/A $ 7,170 N/A $ 7,170 CD'S NONE US Agencies NONE $ 144,102 N/A $ 144,102 PAR for this report is the statement balance on the last day of the quarter DATE DATE I certify that this Investment Report complies with requirements of TCMUD's Investment Policy and the Public Funds Act. For Ending Period 03/31/2023 (January, February, and March) Quarterly Investment Report Trophy Club Municipal Utility District No. 1 Steven Krolczyk Alan Fourmentin April 19, 2023 Regular Meeting Agenda Packet 42 of 71 WHEN EXPERIENCE, REPUTATION AND PERFORMANCE MATTER 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 April 2023 April 19, 2023 Regular Meeting Agenda Packet 43 of 71 • $2,039,976 Original Tax Levy • $18,289 • 0.90% Adj. Delinquent July 1, 2022 Turnover Collected Delinquent 99.10% 0.90% 2021 TAX YEAR ANALYSIS Delinquent Turnover Source: Denton County Tax Office, Year-To-Date Summary Reports. Perdue Brandon Fielder Collins & Mott, LLP 2 April 19, 2023 Regular Meeting Agenda Packet 44 of 71 Base Tax Only – No Penalties or Interest Added • $18,289 Adj. July 1 Turnover • $15,206 • 83.14% Base Tax Collected • $3,083 Base Tax Remaining 2021 TAX YEAR – DELINQUENT COLLECTIONS July 1, 2022 – March 31, 2023 Source: Denton County Tax Office, Year-To-Date Summary Reports. Turnover Accounts for Adjustments and Refunds. Base Taxes Only -No Penalties or Interest Added. Perdue Brandon Fielder Collins & Mott, LLP 3 Collected $15,206 $3,083 April 19, 2023 Regular Meeting Agenda Packet 45 of 71 ACCOUNT BREAKDOWN CHART Action Pending Accounts: Notification Letters, Telephone Collections, Lienholder Notification, Title Research, Property Inspection 4 and Payment Agreements. Source: Perdue Brandon tape download on 4/5/23 from the Denton County Tax Office. As of 4/5/2023 -Total Base Tax: $19,863 (2021 Tax Year & Prior) In Bankruptcy, $323.78, 1.6% In Trust, $0.90, 0.0% In Deferral, $13,820.00, 69.6% In Litigation, $2,387.87, 12.0% In Uncollectable, $1,621.02, 8.2% Action Pending, $1,710.31, 8.6% April 19, 2023 Regular Meeting Agenda Packet 46 of 71 Description # Properties Pct Of Total Base Tax Amount Pct Of Total In Bankruptcy 1 1.67% $323.78 1.63% In Trust 2 3.33% $0.90 0.00% In Deferral 6 10.00% $13,820.00 69.57% In Litigation 5 8.33% $2,387.87 12.02% In Uncollectable 19 31.67% $1,621.02 8.16% Action Pending 27 45.00% $1,710.31 8.61% Totals 60 100.00% $19,863.88 100.00% Dollar Range # Properties Pct Of Total Base Tax Amount Pct Of Total $0.01 -$100.00 40 71.43% $797.36 4.01% $100.01 -$250.00 2 3.57% $259.34 1.31% $250.01 -$500.00 7 12.50% $2,232.23 11.24% $1000.01 -$2500.00 5 8.93% $7,619.92 38.36% $2500.01 -$5000.00 2 3.57% $8,955.03 45.08% Totals 56 100.00% $19,863.88 100.00% Year # Transaction Pct Of Total Base Tax Amount Pct Of Total 2006 1 0.78% $306.84 1.54% 2007 1 0.78% $517.32 2.60% 2008 1 0.78% $530.21 2.67% 2009 1 0.78% $495.08 2.49% 2010 3 2.33% $1,224.20 6.16% 2011 3 2.33% $1,097.18 5.52% 2012 7 5.43% $927.49 4.67% 2013 9 6.98% $1,117.54 5.63% 2014 11 8.53% $1,205.11 6.07% 2015 11 8.53% $881.06 4.44% 2016 7 5.43% $886.44 4.46% 2017 9 6.98% $979.73 4.93% 2018 11 8.53% $1,954.33 9.84% 2019 13 10.08% $2,109.84 10.62% 2020 16 12.40% $2,505.39 12.61% 2021 25 19.38% $3,126.12 15.74% Totals 129 100.00% $19,863.88 100.00% AUTHORITY ACTIVITY ANALYSIS TROPHY CLUB MUNICIPAL UTILITY DISTRICT #1 As Of 4/6/2023, Tax Years Between 1997 And 2021 **Number of properties may differ in the first two sections because a property may reside in more than one category in the first section. April 19, 2023 Regular Meeting Agenda Packet 47 of 71 GEO Code Taxpayer Name Years Tax Due Total Due MCDONALD JAMES E & HUESTIS LAURA LEA TR 2006-2018 $4,508.02 $7,909.94 Taxpayer Name Years Tax Due Total Due BOREN BENJAMIN C & BEVERLY C 2010-2020 $4,009.97 $5,712.64 Taxpayer Name Years Tax Due Total Due PARROW JAMES J & ELENA 2017-2020 $1,618.89 $1,914.09 Taxpayer Name Years Tax Due Total Due SUMMERS, JAMES M 2010-2014 $1,355.94 $3,869.33 Taxpayer Name Years Tax Due Total Due MORTON DENVER & JANIE 2018-2020 $1,139.08 $1,614.85 Taxpayer Name Years Tax Due Total Due MEMBERS ONLY DENTAL PA 2018-2020 $1,104.51 $1,994.59 Taxpayer Name Years Tax Due Total Due RYAN BRUCE E & SHELIA A 2018-2020 $930.65 $1,079.63 Taxpayer Name Years Tax Due Total Due SEAY MARK SR & TERRI 2020 $430.40 $717.91 Taxpayer Name Years Tax Due Total Due BURGAR BRANDON 2013-2014 $310.41 $806.27 Taxpayer Name Years Tax Due Total Due FORD LESLIE 2012-2017 $304.07 $720.93 Taxpayer Name Years Tax Due Total Due WEINBERGER DELI TWO LLC 2016-2019 $297.12 $586.94 Taxpayer Name Years Tax Due Total Due MORRISON AVIATION LLC 2012-2020 $254.10 $576.25 Taxpayer Name Years Tax Due Total Due J.A.E.H.K. INC 2018-2020 $104.94 $189.83 Taxpayer Name Years Tax Due Total Due KENNETH ARMSTRONG 2020 $60.45 $100.83 Taxpayer Name Years Tax Due Total Due MOTORLEASE CORPORATION 2020 $58.53 $97.63 92697 336365DEN PERSONAL PROPERTY -LEASED VEHICLES Taxpayer # 92366 Taxpayer # 90856 776375DEN PERSONAL PROPERTY -ACCOUNTING AUDITING & BOOKKEEPING LOCATION : 99 TROPHY Taxpayer # CLUB STE DR TROPHY CLUB 339971DEN PERSONAL PROPERTY -AIRCRAFT CESSNA 150L 1972-N5428Q LOCATION : NORTHWEST Taxpayer # REGIONAL AIRPORT L-52F 759 676474DEN PERSONAL PROPERTY -DRY CLEANERS LOCATION: 2003 SH 114 STE 390 TROPHY CLUB 1242 11514205TAR WEINBERGERS DELICATESSEN PERSONAL PROPERTY TANGIBLE COMMERCIAL Taxpayer # 58 Taxpayer # 1560 926478DEN PERSONAL PROPERTY -CHIROPRACTOR LOCATION : 100 TROPHY CLUB DR. STE 108 TROPHY Taxpayer # CLUB 526096DEN CHURCHILL DOWNS BLK A LOT 1 ACRES: 0.258300 Taxpayer # 895 620602DEN PERSONAL PROPERTY -DENTIST OFFICE LOCAITON : 301 TROPHY LAKE DR STE 120, TROPHY CLUB 90829 70173DEN TROPHY CLUB OAK HILL LOT 15 ACRES: 0.164400 Taxpayer # 91396 Taxpayer # 914 650109DEN PERSONAL PROPERTY -DENTIST LOCATION: 925 TROPHY CLUB DR TROPHY CLUB Taxpayer # 11514221TAR DIEGO'S TEX MEX KITCHEN PERSONAL PROPERTY TANGIBLE COMMERCIAL Taxpayer # 59 72277DEN TROPHY CLUB # 3 LOT 174 ACRES: 0.256100 968 71779DEN TROPHY CLUB # 2 LOT 77 ACRES: 0.253600 Taxpayer # 91176 Taxpayer # 76 71012DEN TROPHY CLUB #10 LOT 1219 ACRES: 0.235000 Taxpayer # Top Tax Due Report Top 100 Percent Properties -TROPHY CLUB MUNICIPAL UTILITY DISTRICT #1 Legal Description 72060DEN TROPHY CLUB # 6 LOT 499 ACRES: 0.384000 Page 1 of 3 April 19, 2023 Regular Meeting Agenda Packet 48 of 71 Taxpayer Name Years Tax Due Total Due VERIZON 2012-2013 $55.46 $151.96 Taxpayer Name Years Tax Due Total Due WALJI SHANIF M 2014-2015 $45.93 $112.70 Taxpayer Name Years Tax Due Total Due EARCARE HEARING AIDS 2014-2015 $35.18 $86.34 Taxpayer Name Years Tax Due Total Due STYLES OF INDIA 2015-2016 $20.23 $46.74 Taxpayer Name Years Tax Due Total Due DESIRE SALON & SPA 2013 $16.51 $44.18 Taxpayer Name Years Tax Due Total Due 7 MILES TASTE GROUP INC 2019 $14.43 $26.15 Taxpayer Name Years Tax Due Total Due HEART TEST LABORATORIES INC 2017-2019 $12.32 $23.23 Taxpayer Name Years Tax Due Total Due MILLER CRAIG 2019-2020 $9.76 $17.00 Taxpayer Name Years Tax Due Total Due TABER JOHN K 2020 $9.15 $14.60 Taxpayer Name Years Tax Due Total Due FULLER CHRISTINA 2020 $7.25 $12.09 Taxpayer Name Years Tax Due Total Due CHIP MUNDY INC 2017 $4.85 $10.19 Taxpayer Name Years Tax Due Total Due DONNA & ASSOCIATES 2013 $4.40 $11.77 Taxpayer Name Years Tax Due Total Due SMITH CLINICAL SERVICES PLLC 2019 $4.31 $7.81 Taxpayer Name Years Tax Due Total Due RAY DERSTEIN 2015 $3.61 $8.62 Taxpayer Name Years Tax Due Total Due RANDSTAD US LP 2014-2015 $2.76 $6.66 Taxpayer Name Years Tax Due Total Due FOLEY BEVERLY 2020 $1.00 $1.67 Taxpayer Name Years Tax Due Total Due HELM INSURANCE AGENCY 2012 $0.87 $2.45 335713DEN PERSONAL PROPERTY -OFFICE LOCATION: 99 TROPHY CLUB DR, TROPHY CLUB Taxpayer # 1329 90303 727270DEN PERSONAL PROPERTY -INSURANCE OFFICE LOCATION: 100 INDIAN CREEK DR STE 110 Taxpayer # TROPHY CLUB 92609 Taxpayer # 90372 13730967TAR RANDSTAD RANDSTAD US LP PERSONAL PROPERTY TANGIBLE COMMERCIAL Taxpayer # 679913DEN PERSONAL PROPERTY -OFFICE LOCATION: 99 TROPHY CLUB DR TROPHY CLUB Taxpayer # 91389 659398DEN PERSONAL PROPERTY -BUSINESS SERVICES LOCATION: 99 TROPHY CLUB DR, TROPHY CLUB 91141 566115DEN PERSONAL PROPERTY -BUSINESS SERVICES LOCATION: 99 TROPHY CLUB DR, TROPHY Taxpayer # CLUB 1555 Taxpayer # 90858 659388DEN PERSONAL PROPERTY -BUSINESS SERVICES LOCATION: 99 TROPHY CLUB DR TROPHY CLUB Taxpayer # 72303DEN TROPHY CLUB # 6 LOT 528 ACRES: 0.266100 Taxpayer # 91664 676479DEN PERSONAL PROPERTY -DANCE & MUSIC LESSONS LOCATION: 905 TROPHY CLUB DR STE 204A TROPHY CLUB 91068 723199DEN PERSONAL PROPERTY -INSURANCE AGENT LOCATION: 2101 SH 114 STE B TROPHY CLUB Taxpayer # 91433 Taxpayer # 91619 13442112TAR HEART TEST LABORATORIES PERSONAL PROPERTY TANGIBLE COMMERCIAL Taxpayer # 499622DEN PERSONAL PROPERTY -HAIR SALON LOCATION: 2001 W SH 114, STE 150, TROPHY CLUB Taxpayer # 1530 682747DEN PERSONAL PROPERTY -RESTAURANT LOCATION: 301 TROPHY LAKE DR STE 116 TROPHY CLUB 1730 563646DEN PERSONAL PROPERTY -MISC PERSONAL SERVICE LOCATION: 2003 SH 114 STE 340 TROPHY Taxpayer # CLUB 1711 Taxpayer # 1164 633172DEN PERSONAL PROPERTY -AUDIOLOGISTS LOCATION: 501 TROPHY LAKE DR, STE 318, TROPHY Taxpayer # CLUB 469054DEN PERSONAL PROPERTY -RETAIL STORE LOCATION: 301 TROPHY LAKE DR STE 124, TROPHY Taxpayer # CLUB 1184 336817DEN PERSONAL PROPERTY -DRY CLEANERS DROP OFF LOCATION : 2003 SH 114 STE 390, TROPHY CLUB Page 2 of 3 April 19, 2023 Regular Meeting Agenda Packet 49 of 71 Taxpayer Name Years Tax Due Total Due NORTHERN LEASING SYSTEMS INC 2020 $0.68 $1.13 Taxpayer Name Years Tax Due Total Due DELL MARKETING LP 2016 $0.61 $1.27 Taxpayer Name Years Tax Due Total Due TROPHY CLUB TOWN OF 2014 $0.48 $1.22 Taxpayer Name Years Tax Due Total Due TROPHY CLUB TOWN OF 2014 $0.42 $1.06 Taxpayer Name Years Tax Due Total Due JJP TREVI LLC 2018 $0.19 $0.37 Taxpayer Name Years Tax Due Total Due SONIFI SOLUTIONS INC 2015 $0.15 $0.32 Taxpayer Name Years Tax Due Total Due NATIONAL DEFAULT TITLE SERVICE 2017 $0.07 $0.15 Taxpayer Name Years Tax Due Total Due NEOPOST USA INC 2015 $0.04 $0.09 Taxpayer Name Years Tax Due Total Due VILORIA PHILIP A & JOANNE 2019 $0.01 $0.02 Taxpayer Name Years Tax Due Total Due HAFIZ ARIF & FATIMA 91720 LIVING TRUST 2020 $0.01 $0.02 Total Tax Due $16,737.76 Taxpayer # 91092 308380DEN EAGLES RIDGE PH II BLK B LOT 5 ACRES: 0.305700 Taxpayer # 14448870TAR NEOPOST USA INC VARX COMMERCIAL Taxpayer # 91049 198454DEN LAKES OF TROPHY CLUB PH 1 BLK 5 LOT 11 ACRES: 0.160300 1290 13661787TAR NATIONAL DEFAULT TITLE PERSONAL PROPERTY TANGIBLE COMMERCIAL Taxpayer # 1638 Taxpayer # 91351 14381350TAR SONIFI SOLUTIONS INC VARX COMMERCIAL Taxpayer # 624325DEN A0821A J.R. MICHAEL TR 1A(3) .081 ACRES ACRES: 0.081000 Taxpayer # 1628 42345560TAR WESTLAKE ENTRADA BLOCK I LOT 13 REF PLAT D218192054 91207 624324DEN A0821A J.R. MICHAEL TR 1A(2) .09 ACRES ACRES: 0.090000 Taxpayer # 1628 Taxpayer # 298 14461451TAR DELL MARKETING LP VARX COMMERCIAL Taxpayer # 314763DEN PERSONAL PROPERTY -LEASED EQUIPMENT Page 3 of 3 April 19, 2023 Regular Meeting Agenda Packet 50 of 71 GEO Code Taxpayer Name Years Tax Due Total Due BOREN BENJAMIN C & BEVERLY C 2021 $437.04 $462.52 Taxpayer Name Years Tax Due Total Due PARROW JAMES J & ELENA 2021 $421.13 $445.68 Taxpayer Name Years Tax Due Total Due MORTON DENVER & JANIE 2021 $387.05 $409.62 Taxpayer Name Years Tax Due Total Due MEMBERS ONLY DENTAL PA 2021 $371.50 $566.17 Taxpayer Name Years Tax Due Total Due BINGHAM GENE C 2021 $323.78 $493.44 Taxpayer Name Years Tax Due Total Due RYAN BRUCE E & SHELIA A 2021 $291.17 $308.15 Taxpayer Name Years Tax Due Total Due CULPEPPER LEE & ADRIANNE BEHR 2021 $287.19 $437.68 Taxpayer Name Years Tax Due Total Due MAYA WALDEMAR 2021 $91.87 $140.01 Taxpayer Name Years Tax Due Total Due MCKENNA OTHOPAEDIC AND SPORT MEDICINE PA 2021 $87.95 $134.04 Taxpayer Name Years Tax Due Total Due SHIRES BRENDA 2021 $77.00 $78.60 Taxpayer Name Years Tax Due Total Due AMR WESTLAKE STORAGE LLC 2021 $72.68 $110.76 Taxpayer Name Years Tax Due Total Due KENNETH ARMSTRONG 2021 $59.40 $90.53 Taxpayer Name Years Tax Due Total Due ADT LLC 2021 $41.69 $63.54 Taxpayer Name Years Tax Due Total Due DYNAMIC ACTION INC 2021 $36.66 $55.87 Taxpayer Name Years Tax Due Total Due J.A.E.H.K. INC 2021 $34.55 $52.65 92920 676474DEN PERSONAL PROPERTY -DRY CLEANERS LOCATION: 2003 SH 114 STE 390 TROPHY CLUB Taxpayer # 90856 Taxpayer # 93734 14318755TAR DYNAMIC ACTION PERSONAL PROPERTY TANGIBLE COMMERCIAL Taxpayer # 776375DEN PERSONAL PROPERTY -ACCOUNTING AUDITING & BOOKKEEPING LOCATION : 99 TROPHY Taxpayer # CLUB STE DR TROPHY CLUB 92697 975792DEN PERSONAL PROPERTY -LEASED EQUIPMENT 1205 42616725TAR WESTLAKE ENTRADA BLOCK C LOT 1B SCHOOL BOUNDARY SPLIT ACRES: 0.197000 Taxpayer # 92381 Taxpayer # 92192 70643DEN LAKE FOREST VILLAGE PH 3 LOT 96 ACRES: 0.304400 Taxpayer # 42641576TAR KNOLLS AT SOLANA BLOCK B LOT 23 ACRES: 0.247900 Taxpayer # 93256 14690069TAR THE CELL SPA/MCKENNA ORTHOPEDI PERSONAL PROPERTY TANGIBLE COMMERCIAL 91396 71082DEN TROPHY CLUB #10 LOT 1249 ACRES: 0.286000 Taxpayer # 93518 Taxpayer # 1219 70173DEN TROPHY CLUB OAK HILL LOT 15 ACRES: 0.164400 Taxpayer # 650109DEN PERSONAL PROPERTY -DENTIST LOCATION: 925 TROPHY CLUB DR TROPHY CLUB Taxpayer # 90829 72034DEN TROPHY CLUB # 4 LOT 333 ACRES: 0.361600 91176 72277DEN TROPHY CLUB # 3 LOT 174 ACRES: 0.256100 Taxpayer # 914 Taxpayer # 968 71779DEN TROPHY CLUB # 2 LOT 77 ACRES: 0.253600 Taxpayer # Top Tax Due Report Top 100 Percent Properties -TROPHY CLUB MUNICIPAL UTILITY DISTRICT #1 Legal Description 71012DEN TROPHY CLUB #10 LOT 1219 ACRES: 0.235000 Page 1 of 2 April 19, 2023 Regular Meeting Agenda Packet 51 of 71 Taxpayer Name Years Tax Due Total Due HARIKRUSHNA CAFE LLC 2021 $29.22 $38.92 Taxpayer Name Years Tax Due Total Due FUSE ENERGY LLC 2021 $26.93 $41.04 Taxpayer Name Years Tax Due Total Due MORRISON AVIATION LLC 2021 $25.16 $38.34 Taxpayer Name Years Tax Due Total Due FULLER CHRISTINA 2021 $7.13 $10.87 Taxpayer Name Years Tax Due Total Due THE FORCE BY LUKE 2021 $5.96 $9.08 Taxpayer Name Years Tax Due Total Due MILLER CRAIG 2021 $4.69 $7.15 Taxpayer Name Years Tax Due Total Due GRAY CAROL 2021 $3.50 $5.33 Taxpayer Name Years Tax Due Total Due ERIC RANSLEBEN 2021 $1.86 $2.83 Taxpayer Name Years Tax Due Total Due FOLEY BEVERLY 2021 $0.98 $1.49 Taxpayer Name Years Tax Due Total Due KIRKPATRICK GINGER G 2021 $0.03 $0.04 Taxpayer # 90923 Total Tax Due $3,126.12 727270DEN PERSONAL PROPERTY -INSURANCE OFFICE LOCATION: 100 INDIAN CREEK DR STE 110 Taxpayer # TROPHY CLUB 92609 71098DEN TROPHY CLUB # 8 LOT 644 ACRES: 0.202400 93483 943642DEN PERSONAL PROPERTY -BUSINESS SVCS LOCATION: 100 INDIAN CREEK TROPHY CLUB Taxpayer # 91198 Taxpayer # 91433 701746DEN PERSONAL PROPERTY -OFFICE LOCATION: 99 TROPHY CLUB DR TROPHY CLUB Taxpayer # 676473DEN PERSONAL PROPERTY -PERSONAL TRAINER SERVICES LOCATION: 2003 SH 114 STE 90 Taxpayer # TROPHY CLUB 90855 723199DEN PERSONAL PROPERTY -INSURANCE AGENT LOCATION: 2101 SH 114 STE B TROPHY CLUB 759 676479DEN PERSONAL PROPERTY -DANCE & MUSIC LESSONS LOCATION: 905 TROPHY CLUB DR STE Taxpayer # 204A TROPHY CLUB 90858 Taxpayer # 91517 339971DEN PERSONAL PROPERTY -AIRCRAFT CESSNA 150L 1972-N5428Q LOCATION : NORTHWEST Taxpayer # REGIONAL AIRPORT L-52F 14834401TAR SIP STIR COFFEE HOUSE PERSONAL PROPERTY TANGIBLE COMMERCIAL Taxpayer # 93859 14265180TAR FUSE ENERGY LLC PERSONAL PROPERTY TANGIBLE COMMERCIAL Page 2 of 2 April 19, 2023 Regular Meeting Agenda Packet 52 of 71 TP # Taxpayer Name Base Due 93245 GEO Code Client Name Tax Year Tran Type Start Date Condition Base Tax 40758281TAR 2022 TAX 12/06/2021 Defer $337.04 $337.04 $337.04 91396 GEO Code Client Name Tax Year Tran Type Start Date Condition Base Tax 70173DEN 2018 TAX 10/23/2018 Defer $329.43 70173DEN 2019 TAX 10/23/2018 Defer $304.93 70173DEN 2020 TAX 10/23/2018 Defer $296.29 70173DEN 2021 TAX 10/23/2018 Defer $291.17 70173DEN 2022 TAX 10/23/2018 Defer $278.59 $1,500.41 $1,500.41 1205 GEO Code Client Name Tax Year Tran Type Start Date Condition Base Tax 70643DEN 2021 TAX 02/03/2012 Defer $77.00 $77.00 $77.00 968 GEO Code Client Name Tax Year Tran Type Start Date Condition Base Tax 71012DEN 2010 TAX 06/30/2010 Defer $414.60 71012DEN 2011 TAX 06/30/2010 Defer $378.65 71012DEN 2012 TAX 06/30/2010 Defer $295.79 71012DEN 2013 TAX 06/30/2010 Defer $300.56 71012DEN 2014 TAX 06/30/2010 Defer $325.30 71012DEN 2015 TAX 06/30/2010 Defer $355.07 71012DEN 2016 TAX 06/30/2010 Defer $367.89 71012DEN 2017 TAX 06/30/2010 Defer $385.38 71012DEN 2018 TAX 06/30/2010 Defer $380.30 71012DEN 2019 TAX 06/30/2010 Defer $404.59 71012DEN 2020 TAX 06/30/2010 Defer $401.84 71012DEN 2021 TAX 06/30/2010 Defer $437.04 71012DEN 2022 TAX 06/30/2010 Defer $417.01 $4,864.02 $4,864.02 91176 GEO Code Client Name Tax Year Tran Type Start Date Condition Base Tax 71779DEN 2017 TAX 11/03/2017 Defer $385.31 71779DEN 2018 TAX 11/03/2017 Defer $412.53 71779DEN 2019 TAX 11/03/2017 Defer $416.50 71779DEN 2020 TAX 11/03/2017 Defer $404.55 71779DEN 2021 TAX 11/03/2017 Defer $421.13 71779DEN 2022 TAX 11/03/2017 Defer $401.91 $2,441.93 $2,441.93 76 GEO Code Client Name Tax Year Tran Type Start Date Condition Base Tax 72060DEN 2006 TAX 01/25/2007 pre $306.84 72060DEN 2007 TAX 01/25/2007 Defer $517.32 72060DEN 2008 TAX 01/25/2007 Defer $530.21 72060DEN 2009 TAX 01/25/2007 Defer $495.08 72060DEN 2010 TAX 01/25/2007 Defer $460.80 72060DEN 2011 TAX 01/25/2007 Defer $405.50 72060DEN 2012 TAX 01/25/2007 Defer $329.59 72060DEN 2013 TAX 01/25/2007 Defer $331.12 72060DEN 2014 TAX 01/25/2007 Defer $346.81 72060DEN 2015 TAX 01/25/2007 Defer $378.34 72060DEN 2016 TAX 01/25/2007 Defer $400.74 72060DEN 2017 TAX 01/25/2007 Defer $5.37 72060DEN 2018 TAX 01/25/2007 Defer $0.30 $4,508.02 $4,508.02 914 GEO Code Client Name Tax Year Tran Type Start Date Condition Base Tax 72277DEN 2018 TAX 03/24/2020 pre $340.65 72277DEN 2019 TAX 03/24/2020 pre $404.44 72277DEN 2020 TAX 03/24/2020 Defer $393.99 72277DEN 2021 TAX 03/24/2020 Defer $387.05 72277DEN 2022 TAX 03/24/2020 Defer $367.29 $1,893.42 Taxpayer Base Due $1,893.42 Total Base Due $15,621.84 Trophy Club MUD 1 DEFE 12/01/2099 Property Base Due Trophy Club MUD 1 DEFE 12/01/2099 Trophy Club MUD 1 DEFE 12/01/2099 Trophy Club MUD 1 DEFE 12/01/2099 Trophy Club MUD 1 DEFE 12/01/2099 Taxpayer Base Due MORTON DENVER & JANIE Status End Date Trophy Club MUD 1 DEFE 12/01/2099 Property Base Due Trophy Club MUD 1 DEFE 12/01/2099 Trophy Club MUD 1 DEFE 12/01/2099 Trophy Club MUD 1 DEFE 12/01/2099 Trophy Club MUD 1 DEFE 12/01/2099 Trophy Club MUD 1 DEFE 12/01/2099 Trophy Club MUD 1 DEFE 12/01/2099 Trophy Club MUD 1 DEFE 12/01/2099 Trophy Club MUD 1 DEFE 12/01/2099 Trophy Club MUD 1 DEFE 12/01/2099 Trophy Club MUD 1 DEFE 12/01/2099 Trophy Club MUD 1 DEFE 12/01/2099 Trophy Club MUD 1 DEFE 12/01/2099 MCDONALD JAMES E & HUESTIS LAURA LEA TR Status End Date Property Base Due Taxpayer Base Due Trophy Club MUD 1 DEFE 12/01/2099 Trophy Club MUD 1 DEFE 12/01/2099 Trophy Club MUD 1 DEFE 12/01/2099 Trophy Club MUD 1 DEFE 12/01/2099 Trophy Club MUD 1 DEFE 12/01/2099 Trophy Club MUD 1 DEFE 12/01/2099 Taxpayer Base Due PARROW JAMES J & ELENA Status End Date Trophy Club MUD 1 DEFE 12/01/2099 Property Base Due Trophy Club MUD 1 DEFE 12/01/2099 Trophy Club MUD 1 DEFE 12/01/2099 Trophy Club MUD 1 DEFE 12/01/2099 Trophy Club MUD 1 DEFE 12/01/2099 Trophy Club MUD 1 DEFE 12/01/2099 Trophy Club MUD 1 DEFE 12/01/2099 Trophy Club MUD 1 DEFE 12/01/2099 Trophy Club MUD 1 DEFE 12/01/2099 Trophy Club MUD 1 DEFE 12/01/2099 Trophy Club MUD 1 DEFE 12/01/2099 Trophy Club MUD 1 DEFE 12/01/2099 Trophy Club MUD 1 DEFE 12/01/2099 Taxpayer Base Due BOREN BENJAMIN C & BEVERLY C Status End Date Trophy Club MUD 1 <none> 12/01/2099 Property Base Due Taxpayer Base Due SHIRES BRENDA Status End Date Trophy Club MUD 1 DEFE 12/01/2099 Property Base Due Trophy Club MUD 1 DEFE 12/01/2099 Trophy Club MUD 1 DEFE 12/01/2099 Trophy Club MUD 1 DEFE 12/01/2099 Trophy Club MUD 1 DEFE 12/01/2099 Taxpayer Base Due RYAN BRUCE E & SHELIA A Status End Date Trophy Club MUD 1 DEFE 12/01/2099 Property Base Due PARKER CHARLES J AND PARKER SYLVIA A Status End Date Deferral Detail Report Locator: Denton Tax Clients: Trophy Club MUD 1 Page 1 of 1 April 19, 2023 Regular Meeting Agenda Packet 53 of 71 STAFF REPORT April 19, 2023 AGENDA ITEM: Consider and act to approve emergency fire station repairs. DESCRIPTION: Below is a timeline describing efforts to remediate fire station damages. To date, one bay door remains inoperable and has hindered intended operations of the building. Efforts were made to utilize funding from the trucking company; however, delays in response led to the requested approval.  Date of Accident was December 30, 2022.  Town and District staff collectively agreed on coordination of repairs and the District would assist in ensuring payment was provided via Mojave Transportation Insurance Company (Mojave) or Texas Municipal League (TML).  Contractor removed the damaged bay door from service on December 31st.  Mohave was contacted and received acknowledgement of claim on January 3rd.  Contractor removed drywall and a structural engineer performed an initial assessment of damage on January 4th.  Mojave assigned a representative to the claim and requested damage photos and claim estimate on January 6th.  A property claim was filed with TML on January 18th.  The structural engineer performed an additional assessment of damage on January 25th.  Structural engineer delivered report on February 13th.  TML assigned appraiser assessed damages on February 15th.  UST GC provided a repair estimate on February 23rd.  Mohave assigned an appraiser to verify UST GC estimate on March 2nd.  Mohave acknowledged awaiting a report from their appraiser and have received no further updates from Mohave since March 23rd.  Received TML adjustor report and estimate on March 23rd.  Due to lack of response from Mojave, payment was requested from TML based on Contractor’s estimate and payment was mailed to the District on March 24th.  Payment was sent to Town on April 3rd.  Received notification on April 12th that Town legal counsel advised that these repairs should be managed by the District because the building is their asset and they do not have the authority to authorize or approve repairs of this magnitude. April 19, 2023 Regular Meeting Agenda Packet 54 of 71 RECOMMENDATION: Staff requests approval of emergency fire station repairs to UST GC, LLC for an amount not to exceed $188,954.00 and authorize the General Manager to execute any necessary documents to implement board action. This request is due to the bay door being inoperable, hindering the intended operational functionality of the building, and the potential for further delays of necessary repairs. A pre‐construction meeting is tentatively scheduled immediately following approval and the contractor is prepared to begin repairs upon notice. Furthermore, TML has initiated subrogation efforts to collect payment from Mojave. April 19, 2023 Regular Meeting Agenda Packet 55 of 71 PO Box 2195 Decatur, TX 76234 Town of Trophy Club February 23, 2023 Attn: Paul Brandon 1 Trophy Club Drive Trophy Club, TX 76262 Project Name: Trophy Club Fire Station Repair Greetings, We are pleased to submit our proposal to complete the repairs for the above referenced project. The below base bid includes the furnishment of all labor, materials, tools, equipment, and supervision necessary to complete said project. Base Bid ……………………………………………………………………………………..…. $ 188,954.00 Work to be performed includes the following: A. Div. 2 a. Demolition and removal of impacted/damaged materials which includes, but is not limited to; masonry, wood framing, soffit, drywall, thermal protection, and metals B. Div. 3 a. Concrete patching C. Div. 4 a. The complete refacing of brick veneer of the north side of apparatus bay with like color materials b. CMU instillation of select areas on interior of apparatus bay D. Div. 5 a. Removal and replacement of steel lintel on bay door #2 E. Div. 6 a. Removal and replacement of framing above bay door #2 b. Removal and replacement of damaged trim on the interior side of bay door #2 c. Removal and replacement of damaged blocking d. Truss repairs F. Div. 7 a. Removal and replacement of damaged soffit on underside of awning b. Joint sealants G. Div. 8 a. Repairs to bay door #1 and 2 H. Div. 9 a. Gypsum board ceiling repair(Tape, texture, paint) b. Painting of interior around bay door #1, 2, and 3 I. Div. 10 April 19, 2023 Regular Meeting Agenda Packet 56 of 71 PO Box 2195 Decatur, TX 76234 a. Replacement bracket located between bay door #1 and 2 J. Div. 22 a. Repair and replacement of damaged wall hydrant located between bay door #1 and 2 Below you will find UST General Contracting’s Construction Cost Estimate for the above referenced bid. Please note that due to the current market volatility of building martial costs, it is advised that if this bid is accepted, procurement of material be made as soon as feasible to ensure accuracy of bid costs. Current lead times for Division 4 materials is roughly nine weeks. It is our intention to commence mobilization upon confirmation that these materials have been shipped. Once mobilized, we estimate that the completion of the project should take 35 working days (Mon. – Fri.). Lastly, due to the nature of the project a percentage of the overall project cost would be required as a down payment. That percentage is no less than 25%. Please feel free to reach out to us with any questions. Regards, Josh Schmidt Project Manager UST GC LLC. (817)301-7109 jschmidt@ustgc.com April 19, 2023 Regular Meeting Agenda Packet 57 of 71 UNIT MATERIAL COST LABOR COSTS OTHER Line ITEM OF QUANTITY MANHOURS AVERAGE DIRECT LINE NO. MEASURE UNIT TOTAL MANDAYS RATE TOTAL COSTS TOTAL (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) 1.0 DIVISION 01 GENERAL REQUIREMENTS Project Management HR $0.00 56.00 $45.00 $2,520.00 $2,520.00 Project Superintendent HR $0.00 280.00 $37.00 $10,360.00 $10,360.00 Laborer(2) HR $0.00 288.00 $25.00 $7,200.00 $7,200.00 Burden EA $0.00 1.00 $4,016.00 $4,016.00 $4,016.00 Fuel DA 78.00 $22.00 $1,716.00 $0.00 $1,716.00 Vehicel(s) DA 78.00 $25.00 $1,950.00 $0.00 $1,950.00 Mobilization EA 1.00 $5,000.00 $5,000.00 $0.00 $5,000.00 Demobilization EA 1.00 $3,500.00 $3,500.00 $0.00 $3,500.00 Dumpsters MO 1.00 $800.00 $800.00 $0.00 $800.00 Storage Rental MO 1.00 $1,200.00 $1,200.00 $0.00 $1,200.00 Equipment Rental MO 1.00 $5,000.00 $5,000.00 $0.00 $5,000.00 DIVISION 01 SUBTOTAL $19,166.00 $24,096.00 $0.00 $43,262.00 3.0 DIVISION 03 CONCRETE Concrete clean/patch work EA 1.00 $87.90 $87.90 $0.00 $87.90 DIVISION 02 SUBTOTAL $87.90 $0.00 $0.00 $87.90 4.0 DIVISION 04 MASONRY Masonry demo, exterior masonry wall refacing, interior CMU repair EA 1 $50,100.00 $50,100.00 $0.00 $50,100.00 DIVISION 05 SUBTOTAL $50,100.00 $0.00 $0.00 $50,100.00 5.0 DIVISION 05 METALS W 14x38 EA 1 1,616.32 $1,616.32 $0.00 $1,616.32 L 3-1/2 x 3-1/2 x 1/4 EA 1 749.50 $749.50 $0.00 $749.50 PL 1/4 x 27” -Rolled EA 1 3,222.75 $3,222.75 $0.00 $3,222.75 Labor & Equipment EA $0.00 1.00 $8,988.00 $8,988.00 $8,988.00 CONTRACTOR UST GC LLC. ADDRESS PO Box 2195, Decatur, TX 76234 CONTRACT FOR (Work to be performed ) Town of Trophy Club PROPOSED TOTAL CONTRACT PRICE $188,954.00 CONSTRUCTION COST ESTIMATE BREAKDOWN April 19, 2023 Regular Meeting Agenda Packet 58 of 71 UNIT MATERIAL COST LABOR COSTS OTHER Line ITEM OF QUANTITY MANHOURS AVERAGE DIRECT LINE NO. MEASURE UNIT TOTAL MANDAYS RATE TOTAL COSTS TOTAL (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) CONTRACTOR UST GC LLC. ADDRESS PO Box 2195, Decatur, TX 76234 CONTRACT FOR (Work to be performed ) Town of Trophy Club PROPOSED TOTAL CONTRACT PRICE $188,954.00 CONSTRUCTION COST ESTIMATE BREAKDOWN DIVISION 05 SUBTOTAL $5,588.57 $8,988.00 $0.00 $14,576.57 6.0 DIVISION 06 WOOD, PLASTICS AND COMPOSITES 2x4 Stud @16" OC EA 75 7.75 $581.25 $0.00 $581.25 1/2" Exterior Grade Plywood EA 10 47.37 $473.70 $0.00 $473.70 1x6 Wood Trim EA 10 19.98 $199.80 $0.00 $199.80 1x Wood Furring Strips 12" OC EA 6 2.55 $15.30 $0.00 $15.30 Simpson Strong-Tie 7-in 20-Gauge Galvanized Steel Tie Plate Wood To Wood EA 20 4.38 $87.60 $0.00 $87.60 #8 x 2-1/2 in. Philips Bugle-Head Coarse Thread Sharp Point Polymer Coated Exterior Screws EA 2 99.97 $199.94 $0.00 $199.94 DIVISION 06 SUBTOTAL $1,557.59 $0.00 $0.00 $0.00 $0.00 $1,557.59 7.0 DIVISION 07 THERMAL AND MOISTURE PROTECTION Tyvek Wrap EA 6 215.00 $1,290.00 $0.00 $1,290.00 Vented Hardie Soffit Panel EA 3 65.43 $196.29 $0.00 $196.29 Soffit Retention Strip EA 3 44.65 $133.95 $0.00 $133.95 1x6 Hardie Trim EA 6 29.22 $175.32 $0.00 $175.32 #9 x 1-5/8 in. Serrated Flat Head Star Drive Cement Board Screws (140-Pack) EA 2 13.97 $27.94 $0.00 $27.94 T50 3/8 in. Leg x 3/8 in. Crown Galvanized Steel Staples (5,000-Pack) EA 1 13.97 $13.97 $0.00 $13.97 Joints & Sealants EA 1 2,500.00 $2,500.00 $0.00 $2,500.00 15 LB Felt EA 10 33.00 $330.00 $0.00 $330.00 DIVISION 07 SUBTOTAL $4,667.47 $0.00 $0.00 $4,667.47 8.0 DIVISION 08 OPENINGS Baydoor(s) repair EA $0.00 1.00 $25,441.20 $25,441.20 $25,441.20 DIVISION 08 SUBTOTAL $0.00 $25,441.20 $0.00 $25,441.20 9.0 DIVISION 09 FINISHES Paint -P1(5 Gal) EA 2 577.45 $1,154.90 $0.00 $1,154.90 April 19, 2023 Regular Meeting Agenda Packet 59 of 71 UNIT MATERIAL COST LABOR COSTS OTHER Line ITEM OF QUANTITY MANHOURS AVERAGE DIRECT LINE NO. MEASURE UNIT TOTAL MANDAYS RATE TOTAL COSTS TOTAL (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) CONTRACTOR UST GC LLC. ADDRESS PO Box 2195, Decatur, TX 76234 CONTRACT FOR (Work to be performed ) Town of Trophy Club PROPOSED TOTAL CONTRACT PRICE $188,954.00 CONSTRUCTION COST ESTIMATE BREAKDOWN Paint -P2(1 Gal) EA 2 69.99 $139.98 $0.00 $139.98 Gyp. Board(Repair, Tape, Bed, Texture) EA 1 120.00 $120.00 $0.00 $120.00 Trim Caulking EA 7 7.28 $50.96 $0.00 $50.96 DIVISION 09 SUBTOTAL $1,465.84 $0.00 $0.00 $1,465.84 10.0 DIVISION 10 SPECIALTIES Mounted Chrome Speciality Replacement EA 1.00 $225.00 $225.00 $0.00 $225.00 DIVISION 10 SUBTOTAL $225.00 $0.00 $0.00 $225.00 22.0 DIVISION 22 PLUMBING Enclosed Wall Hydrant Repair/Replacement EA 1.00 $580.37 $580.37 0.00 $0.00 $0.00 $580.37 DIVISION 22 SUBTOTAL $580.37 $0.00 $0.00 $580.37 DIVISION 1-22 SUBTOTAL $141,963.94 10% $14,196.39 $156,160.33 10% $15,616.03 $171,776.37 10% $17,177.64 GRAND TOTAL $188,954.00 PROFIT SUBTOTAL UNFORESEEN COND. OVERHEAD SUBTOTAL April 19, 2023 Regular Meeting Agenda Packet 60 of 71 STAFF REPORT April 19, 2023 AGENDA ITEM: Consider and act to award bid and approve Contract 2023041901 for replacement of water lines as part of FY 2023 Capital Improvement Projects. DESCRIPTION: This project consists of replacement and installation of 5,893 linear feet of 8‐ inch, 6‐inch, and 2‐inch water lines, valves, and service lines along and adjacent to Sunset Drive, Berkshire Court, Lee Court, Riviera Court, and Skyline Drive. This project was advertised, and a public bid opening was held on April 10, 2023. Seven (7) bids were received and are outlined in the attached letter of recommendation. RECOMMENDATION: Staff recommends awarding Contract No. 2023041901 for replacement of water lines as part of FY 2023 Capital Improvement Projects to J&L Construction for an amount not to exceed $1,543,178.00 and authorize the General Manager to execute any necessary documents to implement board action. April 19, 2023 Regular Meeting Agenda Packet 61 of 71 Halff Phone: 817.847.1422 4000 Fossil Creek Blvd. | Fort Worth, Texas | 76137 Fax: 817.232.9784 Alan Fourmentin Trophy Club MUD No. 1 April 13, 2023 Page 1 April 13, 2023 AVO 36681.004 Mr. Alan Fourmentin Trophy Club MUD No. 1 100 Municipal Drive Trophy Club, Texas 76262 RE: Trophy Club MUD No. 1 -FY 2023 Water Line Replacement Letter of Recommendation Dear Mr. Fourmentin, Bids were opened for the above referenced project on Monday, April 10, 2023 at 10:00 a.m. at the Trophy Club MUD No. 1. Seven (7) bids were received for the project. Halff Associates has verified the bid tabulations and the overall low bidder is J&L Construction. Please see a summary of the FY 2023 Water Line Replacement bids below. The low bidder and bid amount are highlighted. FY 2023 Water Line Replacement Contractor Bid J&L Construction $1,543,178.00 Atkins Bros. Equip. Comp., Inc. $1,592,306.00 Quality Excavation LLC $1,621,621.35 Rey-Mar Construction $1,656,836.00 308 Construction, LLC $1,735,386.98 Canary Construction, Inc. $2,551,092.00 Dickerson Construction Co, Inc. $2,747,880.00 J&L bonds, qualifications, and experience are attached to this letter. Halff Associates, Inc. (Halff) contacted the provided references and we received the following responses: 1. City of Red Oak Jared Binford: Good recommendation. Mr. Binford said they did a fantastic job on their sanitary sewer and drainage work, including concrete work around inlet boxes. He said that J&L worked very well with the city inspector and reseeded areas that got washed out by rain the day after installation. He emphasized they were eager to help and stayed on top of deadlines. He recommends working with them and would work with them again himself. 2. City of Seagoville Kory Wilkinson, Garver: Good recommendation. Mr. Wilkinson worked with them on behalf of the City of Seagoville on a small diameter water line project with minor pavement repairs. He said that the project has been fully installed for about a year and when asked periodically the City has no complaints about the workmanship. Mr. Wilkinson said the City was overall pleased with the experience but that the contractor could use a little guidance on the cleanup side of things. April 19, 2023 Regular Meeting Agenda Packet 62 of 71 Halff Phone: 817.847.1422 4000 Fossil Creek Blvd. | Fort Worth, Texas | 76137 Fax: 817.232.9784 Alan Fourmentin Trophy Club MUD No. 1 April 13, 2023 Page 2 3. City of Gainesville Chris Vela, Kimley Horn: Good recommendation. Mr. Vela worked with J&L on behalf of the City of Gainesville on a sanitary sewer rehab project. He said they were excellent to work with and the primary contact was particularly great to work with in the field. When he accidentally hit some mailboxes he immediately came to the city accepting responsibility and taking action to replace them. Mr. Vela said they were aggressive with their days to complete the project on schedule. He said they worked great with residents, coordinating about a week in advance when services and sod work would be done. He recommends J&L for sewer and water installation projects. Halff recommends awarding the Fiscal Year 2023 Water Line Replacement project to J&L Construction in the amount of $1,543,178. If you have any questions, please contact me at (817) 764-7513. Sincerely, HALFF ASSOCIATES, INC. Lauren M. McCarley, PE Project Manager April 19, 2023 Regular Meeting Agenda Packet 63 of 71 April 19, 2023 Regular Meeting Agenda Packet 64 of 71 STAFF REPORT April 19, 2023 AGENDA ITEM: Consider and act to approve Well #3 rehabilitation and pump replacement. DESCRIPTION: This project will include pulling and replacing the pump and motor, a pre‐down hole inspection of the well, setting Sonar‐Jet charges on the well screen, sand pumping of the well, and post‐down hole inspection of the well. Lowest Bid ‐Texas Well & Pump, $30,297.49 Second Lowest ‐Millican Well Service, $31,110.00 Third Lowest ‐Barker's Pump & Water Well Service, $36,558.00 RECOMMENDATION: Staff recommends approving Well #3 rehabilitation with Millican Well Service in the amount of $31,110.00 due to additional post‐down hole inspection included in the quote; and authorize the General Manager to execute any necessary documents to implement board action. Also, Millican has been working on District Wells for many years now and we are pleased with the quality of services provided. April 19, 2023 Regular Meeting Agenda Packet 65 of 71 Texas Well and Pump, LLC 218 Elm Kerens, TX 75144 US +1 4693830644 adretel@gmail.com www.texaswellandpump.com Estimate ADDRESS Bert Cooper Trophy Club Municipal Utility District 100 Municipal Drive Throphy Club, TX 76262 SHIP TO Bert Cooper Trophy Club Municipal Utility District 100 Municipal Drive Throphy Club, TX 76262 ESTIMATE # 1366 DATE 03/08/2023 EXPIRATION DATE 04/07/2023 DATE SERVICE DESCRIPTION QTY RATE AMOUNT Service Call -F-650 Hoist 8T travel charge 1 375.00 375.00 Labor remove insulation, disconnect electrical, and prepare for pump removal 1 175.00 175.00 8T-Hoist 8 Ton pulling rig To remove estimated 680' 3" steel pipe pump set 680 5.50 3,740.00 DHVInspection Down Hole Video Inspection 1 1,800.00 1,800.00 Labor TWP on site for video Inspection and Sonar-Jet Service 5 175.00 875.00 Sonar-Jet Sonar-Jet works mild harmonic frequency shock wave service to disintegrate mineral and bacterial deposits 1 2,800.00 2,800.00 Service Call -F-550 Hoist F-550 P10 7.5 ton workover rig travel charge. 1 250.00 250.00 P10HD3L 7.5 Ton Hoist Truck running sand line and bailer to sand pump well post Sonar-Jet 6 250.00 1,500.00 Service Call -F-650 Hoist 8T travel charge 1 375.00 375.00 6M25460 Franklin Electric 6" standard Submersible motor, 25 HP, 460V 1 4,845.30 4,845.30 100SR25F66 Franklin 100SR25F66, 100GPM 304 Stainless Steel Submersible Turbine Pump 25HP 6" 1 7,725.00 7,725.00 April 19, 2023 Regular Meeting Agenda Packet 66 of 71 DATE SERVICE DESCRIPTION QTY RATE AMOUNT 80 3 E BO Flowmatic 3" check valve W/SS Break off 2 531.00 1,062.00 HS-4 4 Wire Clear Heat Shrink Kit 3M Brand W/33+ Scotch Wrap Hydraulic crimped splice 1 66.75 66.75 8T-Hoist 8 Ton pulling To set back existing well pump set on 3" Steel 680 6.00 4,080.00 Band-It 1/2" S.S. Band for deep set wire retaining. sold per joint Includes S.S. Clip 22 3.50 77.00 2Tape 2" Pipe Wrap Tape 6 18.24 109.44 AL-1/8 1/8" DOT Airline ( Sold by the Ft) 680 0.65 442.00 Pull exsisting well pump from the estimated 680' Depth, Video inspect well with recording, and inspect well screen depth's and well condition. Remove the camera and set Sonar-Jet charges into the screen section. After the Sonar Jet service well will be Bailed until clean estimated 6 hours of flat bottom bailer service included. hydraulic splice new motor and pump to existing wire and set back on existing pipe. Included Band-It stainless straps and clips every 20' section with 10 Mil tape every 10 ft section. Includes new Airline Capulary and 3" check valves. Master Lic 60577 to be on site 100% of the project Regulated BY: Texas Department of Licensing and Regulation (TDLR) 920 Colorado St, Austin, TX 78701 (512) 463-6599 SUBTOTAL 30,297.49 TAX 0.00 TOTAL $30,297.49 Accepted By Accepted Date April 19, 2023 Regular Meeting Agenda Packet 67 of 71 Estimate Date 2/24/2023 Name /Address Trophy Club MUD 100 Municipal Dr. Trophy Club, Texas 76262 Well Name Well #3 Total Subtotal Sales Tax (6.25%) Texas Department of Licensing and Regulation P.O. Box 12157 Austin, Texas 78711 512-462-7880 Jerry Browning 2176 Jaythan Browning 59998 MILLICAN WELL SERVICE LLC 372 HAMM ROAD BOYD, TEXAS 76023 817-232-0077 Qty Description Cost Total 1 Labor and equipment to pull the pump and motor 1,500.00 1,500.00 1 Labor and equipment to be onsite for camera survey 500.00 500.00 1 Well Survey 2,500.00 2,500.00 Labor and equipment to install a new pump and motor back in the well. 1 2,500.00 2,500.00 1 1/2" SS band-it buckles 95.00 95.00 1 1/2" SS band-it materials 188.00 188.00 2 3" DI Check Valve w/Break out plug 531.00 1,062.00 1 Tape and splicing materials 165.00 165.00 1 Franklin 25hp 460v 3ph motor (6") 5,845.00 5,845.00 1 Franklin 100SR25F66 Pump end 8,395.00 8,395.00 Additional work needed after viewing the well survey 1 Sonar jet 4,000.00 4,000.00 1 Labor and equipment to be onsite for survey 500.00 500.00 30 Labor and equipment to sand pump the well. 200.00 6,000.00 680 Airline 0.55 374.00 $33,624.00 $33,624.00 $0.00 April 19, 2023 Regular Meeting Agenda Packet 68 of 71 Regulated by: The Texas Department of Licensing and Regulation P.O. BOX 12157 Austin, TX 78711 1-800-803-9202 John Barker-3171WI Barker's Pump & Water Well Service, Inc. PO BOX 764 JUSTIN, TX 76247 ADDRESS TROPHY CLUB MUD 100 MUNICIPAL DR TROPHY CLUB, TX 76262-5420 Estimate 1176 DATE 03/20/2023 DESCRIPTION QTY RATE AMOUNT LABOR & EQUIPMENT TO PULL THE PUMP & MOTOR 1 2,000.00 2,000.00T LABOR & EQUIPMENT TO BE ONSITE FOR CAMERA SURVEY 1 1,000.00 1,000.00T WELL SURVEY 1 3,000.00 3,000.00T LABOR & EQUIPMENT TO INSTALL A NEW PUMP AND MOTOR BACK IN THE WELL 1 2,750.00 2,750.00T 1/2" SS BAND-IT BUCKLES 1 100.00 100.00T 1/2" SS BAND-IT MATERIALS 1 200.00 200.00T 3" DI CHECK VALVE W/BREAK OUT PLUG 2 550.00 1,100.00T TAPE & SPLICING MATERIALS 1 150.00 150.00T FRANKLIN 25 HP 460V 3PH MOTOR (6") 1 5,900.00 5,900.00T FRANKLIN 100SR25F66 PUMP END 1 8,500.00 8,500.00T ADDITIONAL WORK NEEDED AFTER VIEWING THE WELL SURVEY SONAR JET 1 4,200.00 4,200.00T LABOR & EQUIPMENT TO BE ONSITE FOR SURVEY 1 500.00 500.00T LABOR & EQUIPMENT TO SAND PUMP THE WELL 30 225.00 6,750.00T April 19, 2023 Regular Meeting Agenda Packet 69 of 71 Regulated by: The Texas Department of Licensing and Regulation P.O. BOX 12157 Austin, TX 78711 1-800-803-9202 John Barker-3171WI DESCRIPTION QTY RATE AMOUNT AIRLINE 680 0.60 408.00T SUBTOTAL 36,558.00 TAX (0%) 0.00 TOTAL $36,558.00 Accepted By Accepted Date April 19, 2023 Regular Meeting Agenda Packet 70 of 71 Trophy Club Municipal Utility District No. 1 Laurie Slaght May 2023 Printed on: 04/13/2023 8:08am Central Time US & Ca Powered by Calendars Board Room Committee Meetings Elections MUD Audits Office Closed Holiday Staff Events Sun Mon Tue Wed Thu Fri Sat 18 19 20 21 22 Apr 30, 2023 May 1 2 3 4 5 6 7am Early Voting -May 6, 2023 General Election 7am Election Day -M 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Board of Directors 21 22 23 24 25 26 27 28 29 30 31 Jun 1 2 3 Memorial Day -Offic April 19, 2023 Regular Meeting Agenda Packet 71 of 71