The URL can be used to link to this page

Home My WebLink About2022-1010 October 19, 2022 Complete Agenda PacketQ TROPHY CLUB MUNICIPAL UTILITY DISTRICT BOARD OF DIRECTORS REGULAR MEETING October 19, 2022 Complete Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 100 MUNICIPAL DRIVE TROPHY CLUB, TEXAS 76262 Wednesday, October 19, 2022 6:30 P.M. Svore Municipal Boardroom REGULAR MEETING AGENDA PACKET VIA VIDEOCONFERENCE THE PRESIDING OFFICER AND A QUORUM OF THE BOARD OF DIRECTORS WILL BE PHYSICALLY PRESENT AT, AND MEMBERS OF THE PUBLIC MAY ATTEND, THE MEETING AT THE LOCATION SPECIFIED ABOVE. CALL TO ORDER AND ANNOUNCE A QUORUM CITIZEN COMMENTS This is an opportunity for citizens to address the Board on any matter whether or not it is posted on the agenda. The Board is not permitted to take action on or discuss any comments made to the Board at this time concerning an item not listed on the agenda. The Board will hear comments on specific agenda items prior to the Board addressing those items. You may speak up to four (4) minutes or the time limit determined by the President or presiding officer. To speak during this item, you must complete the Speaker's form that includes the topic(s) of your statement. Citizen Comments should be limited to matters over which the Board has authority. REPORTS & UPDATES 1. Staff Reports a. Capital Improvement Projects b. Water Operations Report c. Wastewater System Reports d. Finance Reports Attachments: Staff Reports CONSENT AGENDA All matters listed as Consent Agenda are considered to be routine by the Board of Directors and will be enacted by one motion. There will not be a separate discussion of these items. If discussion is desired, that item will be removed from the consent agenda and will be considered separately. 2. Consider and act to approve the Consent Agenda. a. September 2022 Combined Financials b. September 21, 2022 Regular Meeting Minutes c. Tax Collection Reports - 4th Quarter FY 2022 d. Investment Report - 4th Quarter FY 2022 1 of 91 October 19, 2022 Complete Agenda Packet Attachments: September 2022 Combined Financials September 21, 2022 Regular Meeting Minutes Tax Collection Reports - 4th Quarter FY 2022 Investment Report - 4th Quarter FY 2022 REGULAR SESSION 3. Discussion and possible action regarding stormwater drainage and run off in Hogan's Glen. 4. Consider and act to approve Work Order No. 2 with Pipeline Analysis, LLC for professional engineering services related to the District wastewater collection system and authorize the General Manager to execute the necessary documents. Attachment: Staff report 5. Consider and act to approve Task Order with Halff Associates, Inc. for professional engineering services relating to FY2023 Waterline Improvements and authorize the General Manager to execute the necessary documents. Attachment: Staff report 6. Consider and act to approve Work Order #4 with Garver, LLC. for professional engineering services relating to Pump Station Improvements and authorize the General Manager to execute the necessary documents. Attachment: Staff report 7. Consider and act to award contract for Lift Station generators and improvements and authorize the General Manager to execute the necessary contract documents to implement Board action. Attachment: Staff report 8. Consider and act to award contract for Membrane Bioreactor Improvements (MBR) Project and authorize the General Manager to execute the necessary contract documents to implement Board action. Attachment: Staff report 9. Discussion and possible action regarding customer service deposits.(Carr) 10. Items for future agendas: 11. Future Meeting dates — November 16, 2022 at 6:30 p.m. Attachment: Calendar 2 of 91 October 19, 2022 Complete Agenda Packet *THE BOARD RESERVES THE RIGHT TO ADJOURN INTO EXECUTIVE SESSION AT ANY TIME DURING THE MEETING PURSUANT TO THE APPLICABLE SECTION OF SUBCHAPTER D, CHAPTER 551, TEXAS GOVERNMENT CODE, THE TEXAS OPEN MEETINGS ACT, WITH RESPECT TO ANY ITEM ON THE AGENDA. NO FINAL ACTION, DECISION OR VOTE WILL BE TAKEN ON ANY SUBJECT OR MATTER IN EXECUTIVE SESSION. THIS NOTICE MODIFIES THE DISTRICT'S PRIOR PRACTICE OF SPECIFICALLY IDENTIFYING ALL AGENDA ITEMS TO BE DISCUSSED IN EXECUTIVE SESSION. ADJOURN 3 of 91 FY 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 October 85,488 82,660 90,994 108,951 74,785 83,228 47,193 102,150 98,232 78,390 November 75,251 48,813 58,986 41,936 68,638 69,099 41,933 40,988 57,380 54,635 December 48,527 34,482 49,607 39,028 38,580 48,144 36,244 43,946 40,841 48,488 October 19, 2022 Complete Agenda Packet Monthly Water Operations Report January 39,601 39,767 36,162 39,622 33,028 34,592 34,604 36,418 42,725 49,322 February 34,450 37,085 38,776 44,551 38,380 40,658 33,740 31,000 40,786 40,021 Water Billed March April 43,137 56,947 54,794 66,337 30,566 46,543 49,498 55,181 60,841 56,683 43,411 60,079 40,421 55,970 34,047 53,755 41,078 67,776 44,588 1 72,448 May 76,542 84,384 39,576 50,827 86,794 89,802 42,773 67,030 50,736 85,474 June 85,312 99,240 60,731 65,390 98,864 118,899 70,747 96,195 64,195 119,711 July 110,072 92,913 100,622 115,687 95,355 126,588 96,174 123,309 100,853 141,177 August 130,945 113,135 139,441 119,611 104,303 125,531 131,472 118,522 97,864 143,845 September 114,497 110,873 123,886 98,945 99,541 73,735 114,784 83,570 112,674 108,377 Total Year 900,769 864,483 815,890 829,227 855,792 913,766 746,055 830,930 815,140 986,476 160, . 140,000 120,000 100,000 80,000 60,000 40,000 20,000 WATER BILLED IN THOUSANDS OF GALLONS 1 October November Dein January February July August September 62018 2019 2020 -2021 F -2022 Water Pumped FY October November December January February March April May June July August September Total Year 2013 85,966 77,758 55,110 39,283 37,867 56,743 60,969 87,168 96,602 119,414 145,988 120,342 983,210 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 1 91,078 1 61,928 1 54,930 1 52,679 1 49,094 1 51,606 1 81,977 1 92,915 1 133,828 1 152,199 1 161,534 1 117,252 1 1,101,020 1 160,000 140,000 120,000 100,000 N 80,000 60,000 40,000 20,000 WATER PUMPED IN THOUSANDS GALLONS 2018 - 2019 - 2020 - 2021 - 2022 Active Connections FY October November December January February March April May June July August September 2017 Total 4644 4647 4661 4657 4663 4666 4670 4676 4685 4690 4696 4700 2018 Total 4701 4706 4712 4716 4720 4724 4724 4728 4732 4735 4736 4738 2019 Total 4741 4743 4745 4753 4753 4758 4761 4762 4768 4770 4773 4782 2020 Total 4795 4796 4797 4797 4807 4807 4816 4817 4830 4836 4836 4837 2021 Total 4837 4837 4837 4837 4837 4837 4837 4837 4839 4841 4841 4840 2021 MUD 3393 3393 3393 3393 3393 3393 3393 3393 3395 3397 3397 3396 2021 PID 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 2022 Tota( 4841 4841 4841 484D 3397 3398 3398 ,11) 4844 4845 4841 3401 3402 340'1 4811 48443401 4844 48413401 ) 48431 22223399 2022 PID 1444 1443 1443 14431 1443 1443 14431 14431 14431 144 I 14431 1444 4of91 3.50 3.00 2.50 2.00 1.50 1.00 0.50 0.00 6.0 5.0 4.0 3.0 2.0 1.0 0.0 October 19, 2022 Complete Agenda Packet MONTHLY WASTEWATER OPERATIONS REPORT Ammonia Nitrogen 0.20 Permit Limit 3 (Jan - March) Permit Limit 3 (Sept. - Dec.) Permit Limit - 1 from April - August 0.20 0.20 0.20 0.20 0.21 0.22 0.20 0.20 0.20 0.20 0.20 0.21 Sep 21 Oct 21 Nov 21 Dec 21 Jan 22 Feb 22 Mar 22 Apr 22 May 22 June 22 July 22 Aug 22 Sept. 22 99.6% 99.7% 99.7% 99.7% 99.6% 99.6% 99.6% 99.5% 99.6% Carbonaceous Biochemical Demand (CBOD5) 99.6% 99.6% 99.6% 99.6% 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 Permit Limit 5 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 1� 111111 11 11 11 IHS 11 Sep 21 Oct 21 Nov 21 Dec 21 Jan 22 Feb 22 Mar 22 Apr 22 May 22 June 22 July 22 Aug 22 Sept. 22 99.3% 99.3% 99.3% 99.3% 99.3% 99.3% 99.3% 99.3% 5 of 91 99.3% 99.3% 99.3% 99.2% 99.2% Nh3Ave - Permit Limit - %Removal Bod Bod Aver Permit Limit % Removal 14.0 12.0 10.0 8.0 6.0 4.0 2.0 0.0 30.0 25.0 20.0 15.0 10.0 5.0 0.0 October 19, 2022 Complete Agenda Packet Total Suspended Solids (TSS) 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Permit Limit 12 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Sep 21 Oct 21 Nov 21 Dec 21 Jan 22 Feb 22 Mar 22 April 22 May 22 June 22 July 22 Aug 22 Sep 22 99.6% 99.6% 99.7% 99.6% 99.6% 99.6 99.6% 99.6% 99.6% 99.6% 99.6% 99.6% 99.6% Nitrate - Nitrogen Permit Limit 24 7.3 7.0 6.8 5.35 5.7 5.42 6.2 5.49 5.9 5.48 16.6 5.51 5.64 5.65 6'S 5.7 6.3 5.7 5.5 5.8 5.9 5.8 5 6 6.0 6.2 6.1 1 11111111 1 11 1 1 1 11 111111 Sep -21 Oct -21 Nov -21 Dec -21 Jan -22 Feb -22 Mar -22 6of91 Apr -22 May -22 Jun -22 Jul -22 Aug -22 Sep -22 �T55 T55 Ave Permit Limit %Removal N -N N -N Aver Permit Limit 10 9 8 7 6 5 4 3 2 1 0 October 19, 2022 Complete Agenda Packet E. Coli Permit Limit 126 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 5.2 1.4 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 307.6 Sep -21 Oct -21 Nov -21 Dec -21 Jan -22 Permit Limit High 9 Feb -22 Mar -22 Apr -22 May -22 Potential for Hydrogen (pH) Jun -22 Jul -22 Permit Limit Low 6 Aug -22 Sep -22 7.79 .79 7.75 7.77 '.71 11 111�M 7 727.717.69 764 7627 63766 63 766 7597.51757 7.55757 7.52 7.527.50 7.39 7.35 7.62 7.56 7.44 7.42 7.42 7.22 7.63 7.52 7.37 Sep -21 Oct -21 Nov -21 Dec -21 Jan -22 Feb -22 Mar -22 Apr -22 May -22 7 of 91 Jun -22 Jul -22 Aug -22 Sep -22 350.0 300.0 ■Permit 250.0 Limit 200.0 •E Coll 150.0 •E Coll Ave 100.0 50.0 0.0 7.9 7.8 7.7 7.6 MPH Min 7.5 7.4 7.3 ■ pH Max 7.2 7.1 7 ■pH Aver 6.9 9 8 7 6 Permit Limit Max 9 October 19, 2022 Complete Agenda Packet Dissolved Oxygen (DO) Permit Limit Min 6 7.1 1 7.8 7.9 8.0 8.4 8.69 8.4 7.99 6.85 6.73 6.43 7.27 1 7.58 1 Sep -21 Oct -21 Nov -21 Dec -21 Jan -22 Feb -22 Mar -22 8of91 Apr -22 May -22 Jun -22 Jul -22 Aug -22 Sep -22 apackant2 skrolczyk Begin Date: 09/01/2022 End Date: 09/30/2022 3193 COMPUPAY, INC. • :-:Ttrt01.5:for•chock;•:•:-13903:-:-:•:-:-:::- ::::: 3184.:::bk.fAPROSE LLC 3184 DATAPROSE LLC Totals for Check: 8904 ...2807 Denton Record -Chronicle for.cbkii:H:090$: Totals for Check: 8906 Fran Ant: Trophy Club MJD No.1 AP Checks For DateAknount Range .00 To Amt: 99,999,999.99 • : -:4111VJJ.J.141:11.11411.1.10 • ..IAJ11‘1141.X. • .J.J.T.V.:444.41,111111..::: ••••••••••••••••••••••••••••••••••••:::•:•:•batex'Stet:::NO Ntanbei- : :•:•:•:•:•:•:•:••:. • :•:• ::66160iiiii.24676 08/31/22 • • P 20 135-55125-020-000 " " DtapsteiA Services P900765 996 09/02/22 P DP2203209 " 08/31/22 P 2497 DHS AUTOMATION; INC 2497 DHS AUTOMATION, INC 06-2160 Totals for Check: 8907 •.. 08/31/22 P 3.35-21313- 000 000 30 135-60035-030- 000 Cafe 125 -Medical Rebnb UtUlty BilItrig:Cnidida:::•:•:•:-:•:•:-:•:- .•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.• Postage 20 135-60135-020-000 TCEQ Fees & Permits 000 66/61/22"Ii"".1013655060-0394 10,Cla22be 0.811% 2022 Complete Agenda PapAget 1 : ..Nurber Date " 7,420:32 8901 09/13/22" 7,420.32 287.50 8903 09/13/22 • ' ' : : : :•: :•:•: • ; ; ; ; ; ; : : : : : :•:•: ; ; ; ; ; ; ; ::::::606:79 8904 09/13/22 .1.,880:92 8904 09/13/22 " 2,487.71 46350 463.50 2,270.95 8905 09/13/22 .•.•.•.•.•.•.•.•.•.• • • - • 08/26/22 • - • • '20 • 0 0 0 • • • • • Agtifero Repatit •••••••2,4i..5.6 • • ••••• • • • • • • • • • • • • • • • 09/08/22 P 20 135-55081-020-000 Mainten & Repairs Collections 1,112.34 8907 09/13/22 15,692.46 •-•:•:•:-.•:•:-.•:•:-.•: • • • • • • • • ' • " • '.•.• ••".'. •••••••.•.•.•.•.•.•.•. .•.•.•.'.•.•.•.•.•. 09/07/22 P 30 135-55080-030- • • • 000 • • • • •.•.•.•.•.•.• • • • • • • • Maintenance & Repairs •.•.•.• • • • .. ... . • • • •.•.•.•.•.•.•.•. . . .•.•.•.•. . . . . .•.•.•.•. .•.•.•.•.•.•.•. .•.•. . . . . . 235.00 8909 09/13/22 235.00 • • 460035.0304 ' •:••.• ••••• •••:•:••••••••••:•:.:••••••••:•:•:•:•:•:•:•:•:. • . • ".• ".•••••• 25:91' ' : : : ; ; ; 0 030 000 Service Charges & Fees 98079854 08/31/22 P 30 135- 0 0.:. 0 0 . . . .•. . . . 08/31/22 P 30 135-55030-030- .•.•.•.•.•.•.•.•.•.•.•.•.•. • •••••••••••••••••••••••"•• • 000 icals/Test: •• 0: Software & Support 50.00 8911 09/13/22 . . .'.•.'.•. •.•. . .•.•.•. • • • • •.•. 50.00 : : :•:•:::•:•::::::.:::.; . • : : : : : :...... . . . 1,617.04 8913 09/13/22 1,617.04 .•.•.•.•.•............. ....... ;10 . . .•.•.•.•.•.•.'.'. . .'.'.•.'.".'.'.'. . . .•.•.•.•.•.•.•. . . .•.•.•.•. apackamt2 skrolczyk Begin Date: 09/01/2022 End Date: 09/30/2022 1372 HACH COMPANY Totals for Check: 8914 Date• : • • 13206491 * " 08/22/22" Fran Ant: •: . .• • • • • • • " • 10 "135-650304110-00o " Chemicals Trophy Club MUD No.1 AP Checks For Date/Amount Range .00 To Amt: 99,999,999.99 13223755 08/31/22 P 20 135-65045-020- 3216 N3 Networks 8277 000 Lab Supplies 36,la22ber3.61126 2022 Complete Agenda Pa*et 2 *Or • : : Date 652.22.: 8914 09/13/22 37.96 8914 09/13/22 1,131.42 :•135233.0.20.00000.-: ••:11.1f.rar!es_:-••:-:-:•::.•-:::-• • • 423:30.1•7 0 0 0 :0001 ..• .• :5 • 8.63: 24. : • : • : • tom . • : 69/13/22 : • : • : • •••:•::::3;;37;::::::::8916:::09.. ............... . . . . . 09/09/22 P 30 135-65055-030-000 Hardware 9,798.44 8917 09/13/22 •:. 09109/22: : • : • P • : • . • : 30 : 135-65055-030-000 Hardware Hardware : : : • • • • • • •787.82 8917 09/13/22 08/15/22 P 30 ° Softre 4 Support 575.00 8917 09/13/22 08/15/22::::P::::::30::13545055430400::: • ••••Hard4ire::::::••••••••:::•:: • • • • • • • • • • • • • ••.•1,390.41 8917 09/13/22 32;551.67 998 IVES, JAMES REISSUE -1042207 09/09/22 P 135- 00.0 000 000 A/P Vendors 133.90 8918 09/13/22 000 : • : • : e6/31/22:::: • : • 20. :13591350.20000 • • •• • • • • • P 20 135-5135020.-000 WW2? P 20 1357551357020- 000 000 08/31/22 P 10 135-55135-010-001 :•.•:•:•:•:•:•:•:•:•:•:•:••••••••:::•:•:•:.•.::::::::•:•.• • '.1000-.• • Uniforms 119.60 8920 09/13/22 •• 55•.?.•••••:f.i(42.0.- • •-• • :•: 290.40 : UU : : : • •••• •• • • :••• Lib Anatysts' • • • • " 290.40 8923 09/13/22 8922:::091:13.1"22:: . • .•.• . • • • : . Lab Ad.31•YiA • • • • ••• ••••••: • Cab Analysts Lab Analysis for PID 290.40 •:•:•:•:•:•:•:•: • : 80.00 8925 09/13/22 570.00 -:•:-:•:-:-:•:- . . • .• . • .• .•.• . . .'.•.'.•. . . . .•.•.•.•. apackant2 skrolczyk Begin Date: 09/01/2022 End Date: 09/30/2022 to:tat:5.'6r' 8026•'• Fran Ant: ................. 2696 Texas Excavation Safety System 22-15278 .....: ......: ..... : .............................::.:::::.: : ::::: .. ::: : Tc49lF... for: -Check:: : :: :: ;$927 08/31/22 P 30 335- 1O� ........." ..-.-...-.-...-.-:,.-:•:•:•Y..x.'.-:-:,:'•,:":'•-":".,:":'•/,:'•/,fr: ....2/.. E 08/31/22 P ::::::135 -25040 -boo ..... . . ,. rum OF TROPHY CLUB .•::::•:•:•:•: : . Addisf iiinj§ • • • " • 1001 TOM OF TROPHY CLUB '' AUGUST REFUSE 08/31/22 P ' 135-25 1001 TOWN OF TROPHY CLUB AUGUST REFUSE 08/31/22 P 135 -25010 - Trophy Club MUD No.1 AP Checks For Date/Anount Range .00 To Amt: 99,999,999.99 10110,t72beatt20 2022 Complete Agenda PaRiget 3 :::::INAL:FAPP1411::•:•:•:::• • • • • • • • •:•:::::•:• 1,..1410:4404111: . : . : :IA:Nten . : 1- • • • • • . .•.•.•.•.•. :•:•: : r•::: :•:•.•'•:•:•:•:•:• :•:•:•:•:•:•:•:•:•:•:•:•:• '8,854.75 Service Charges & Fees 289.75 8927 09/13/22 '''''''.'•%%:•:.:•••••%'..:•:•:•:•:•:•:•:•:•:•%'"..:•:•:•:•:•:•'..:•:•'..:•:•209-,7:• • • ••:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: • ••••:••••••••::*:••••••••••••:•••:•:•••: . • :•:•:•:•:•:•:•:•:•:•:•:•.....-:•.•:•: . .•.•.•.•.•.•.•.•.•.•.•.•.•..•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•. 4. •••:*:•-„,••:„••••••••:,,,••.•:••••••••—••••••.%.••:. ••••••:•:•:•:•••''••••••••••••:•,,'•'•:•:••• • • • • • • • • • • •••••:••••••:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:::::::::: -s:IOWelgirm:14.......'..../0**0020:::.00213/22::::*...........................*.::::::::::::::::::::::.:.:.:.:. Refuse Tax 6,666.27 8928 09/13/22 1001 TOWN OF TROPHY CLUB 090722 09/09/22 P 45 122-60337-045- 000 Transfer to Tahn/Fire Budget 74,891.66 8928 09/13/22 8928 ••••••••• • • • • •.• —• •••• :•••••••••••:•:•: :•:• • • • ••••• :-:•: : •.•.•.•.•.•.. .•.•. .......... .•.• • • • • • • . • • • •••••••••••• ••• • • :•* •-••-•.. • teitsat Chack: 8929 '••• ••• •' •• ............593.06• 1000 TROPHY CLUB MUD (WATER BILLS) 08312022 08/31/22 P 30 135-60025-030- 30 135-69615-0.30-0° 388.85 8930 09/13/22 388.85 5,395-M 8931 09/13/22 2634 Valley Solvent Company, INC 90619 09/01/22 P 20 135-65030-020-000 Chemicals 2.38085 8932 09/13/22 1058 V1Z0N WIRELESS 9914692069 09/01/22 P .:.:.:.:10..:13576001070107000:=.:•Comnunxcattons/Mohltes 403 83 8933 09/13/22 1058 VERIZ�•J WIRELESS • • • * • • • 9914692069' • • • 00161/22' • • 000 '' ' -...••••COniiiiiithitiitiOtobileS • t§jj Totals for Check: 8933 743.49 . 1926 .WGER :•". :•:-: : igj " Totals for Check: 8935 : : 33.93. • it:•for•:• • 2635 Halff Associates, INC 2635 Halff Associates, INC 10080484 09/14/22 P 10 135 -69005 -010 - 2635 Halff Associates, INC 10080490 09/14/22 P 10 135 -69005 -010 - ..Totals for Check: 8937 . •:•:•:•:•:•:•:•:•: 20606t • • • • •ko' • 33555030-030-000 899.00 -09/21/22- 8936.:19/21/22-• ••••••••••••••••••••••••••••••••••••••••••••••••••••••••• • •.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.• •••• • : : • •-• • •-• • : : : : • • • • : • • •••• • • • • • ••••-: • •-• • • • : : : : : • : • •••• • • • • : : •••••••••• •-• 000 000 000 Capital Outlays Capital. Outlays 000 iitinana Inc :135-21308- .000 : '••••••••• 155516924 -SEP 09/13/22 • 000 000 2676 Humana Inc 2676 Humana Inc -....7.0.als.for Check: 8938. 155516924 -SEP 09/13/22 P 20 135 -50029 -020- 155516924 -SEP 09/13/22 P 30 135-50029-030- 000 000 Life Insurance & Other Life Insurance & Other ---.--------- ; ; ••••••••••••••:•:•:••••••••••••••••••••••••••••••• ...•.•.•.•.•.•.•.•.. 210.00 8937 09/21/22 400.00 8937 09/21/22 09/21/22 8938 09/21/22 33.00 8938 09/21/22 33.00 8938 09/21/22 .•.•.•.•.•.•.•.. • • • • '•'•:•:•:•:•:•:•:•:•:•:•:•:•:•:•. . . ......•.•.•.•.•.•.•.. .....•.•.•.•.•.•.•.. ....•.•.•.•. apackant2 skrolczyk Begin Date: 09/01/2022 End Date: 09/30/2022 From Ant: • • 2775 1-1.IDSON ENERGY SERVICES,LLC 522092000010018 09/20/22 •• 10 135-60020-010000 2775 HUDSON ENERGY SERVICES, LLC S22092000010018 09/20/22 P 20 135-60020-020- 2775 HUDSON ENERGY SERVICES, LLC 522092000010018 09/20/22 P 30 135-60020-030- . TOtals fOr.check:. 8939 :•:•:•:•:•:•:•:•: :•:•:•:•: . ....... : :•:•:•:•:•:•:•:•:•: : 996 .09/i6/22::42(::::::135-21302400-000 " • 3124 IRS Tax Payment ' • •••••••• • "Fito0166 996 09/16/22 ' ••••• '•' 135-21303- 3124 IRS Tax Payment PR00766 996 09/16/22 P 135-21304- Tcrtals for Check: 8940 8 KBA D0QmrF SOLW1�5• : •55R1991035• : :09/12/22 I 3) 135-69170 .,s for heck 8941. :•:•:: :::•:•:•:•:•:•:•:•• 3216 M3 Networks 8254 08/29/22 Totals for Check: 8942 :•:•: Totais for heck l3 2650 McClatchy Canpany 312510 Totals for Check: 8944 • ::::::••••-'2043•••• • • •-;$.1: . • • • • • • • • ..••• • • • • • 2763 Novotx Totals for Check: 8946 toa1s for heck 841 .•. • • . • . • . • . • .• .•.• ...• ...• • ••• 000 000 P 30 135-65055-030- • 08/30/22 : :•:-: : P 30 135-60125-030- 000 000 000 000 000 000 Trophy Club MUD No.1 AP Checks For Date/Amount Range .00 To Amt: 99,999,999.99 Electricity Electricity/Gas iollernsbenillp 2022 Complete Agenda PaRiget 4 Date ......... '• 1.4,318.37 8939 09/21/22 15,173.63 8939 09/21/22 1,006.43 8939 09/21/22 5,620.88 SeCuraj(tai6s"'""'"'". 6,134.12 Medicare Taxes 1,434.60 13,189.E0 : • • : : : : • ' •••••" " 78.92 • • • • • •—• • • Hardware 60.98 8942 09/21/22 60.98 • 8940 8940 09/21/22 8940 09/21/22 • • • • Advertising :•: 8943 09/21/22 675.00 8944 675.00 Ma4::::-:P.••••••39•••• • :::::::::: • • • .• •• • •• •• • •• •• • •• • • • •••:......••••::::1,715.. • • • • • • • • • • • • • • • .• .• .• • . • • .• •• • •• •• • •• •• • •• • • • 2315 --REISSUE 09/16/22 .•.•••••••••••••••••••••• 1056 OFFICE DEPOT, INC 26451738001 1056 OFFICE DEPOT, INC 26451738001 ••:•:•: ••••. • Totals for Check: P 30 135-55030-030- 000 software & Support :•:• : 46.i«i4ti.,. 000 tavo!i*i?ot:... .%%--%...%'.% • ---.--•-• . . . . .................. . . .............................. 09/21/22 4,275.00 8946 09/21/22 4,275.00 • .•. . .•.•.•.•.•.•.• .•.• 72.::09/Z1/22:•• •••••••••••••••••• . . 09/09/22 P 30 135-65095-030-000 Maintenance Supplies 100.42 8948 09/21/22 09/09/22 P 30 135-65085-030-000 Office Supplies 99.31 8948 09/21/22 -:-:-:-:-:-:-:-:-:-:•••• . . ........................... . . . . . . . . . . . . . . . . . . . . . . . • . • . . • . • • . • . • • . • . . . . • . . . . . • . • . . • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • : : • : : • : • : • : • : • : • : • : : : : : • : • : • : • : • : • : • : • : • : • : : :•:•:• • • 29.97 8950 09/21/22 . 29.97 .•.•.•.•.•.'. . . . . .•.•.•.•. apackant2 skrolczyk Begin Date: 09/01/2022 End Date: 09/30/2022 Fran Ant: :::...._vAliPP! • •veliti•.'Pr:•!!!;!::::: ... ............ . :•:•:•,Amberi.:::::::::•:::•:•:•:•:•:•:•::::::::... . Statet No :::::::................:::::::::::::::::::::::::::::•:::::::•:•:•........... ... : . :•:•:.::::: ......-:-......-:-: .-. ..//".:.:3156 isiaibrn Petroleum Laboratory 22090077 09/07/22—P 20 135-55135-020-::. • • Lab Analysts • Totals for Check: 8953 Trophy Club MUD No.1 AP Checks For Date/Amount Range .00 To Amt: 99,999,999.99 '•'•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•: :•:•:•:•:•:•:•:•:•:•:•:•:• 3356 :•Southern Petrolami.aboratory : 22090292•:•:•: 09/14/22•:•:-P•: 20 :•:3;35755135-.0.20-000:•:•:•:•: Lab : 000 000 10118,12bea.8128 2022 Complete Agenda PaRiget 5 A08:00 8953 09/21/22 408.00 Totals for Check: 8955 9,304.91 2798 Tyler Technologies, Inc : 025-394803 09/14/22/. :-.-30 3.35-69005-030-000 •• -• Capital fArtl.ays- ••••••••• •••••••••••• -1 950 00 8956 09/21/22 • • •: :Total.s for Check: 8956 • • • : • ••••••••• ••••• '•' 1,950.00 ••••••••••••••••••• • • • • • • • • • • • • ••••• • 2977 VIDEOTEX SYSTEMS INC. 00000•0 54 09/13/22 P 30 135-55030-030-000 Software & Support 925.00 8957 09/21/22 ..:..•:.:• Totals for Check: 8957 925.00 2222 WI -AC • Totals for Check; 8958 1030 CITY OF FORT WORTH Totals for Check: 8959 PR00765 -:986.09/02/22-• P 135-21332- PR00766 135 -21312 - 09012022 09/16/22 P 10 •.•:•:•:::::•7•0700W!... 2796 Garver Totals for Check: 8961 .. • • . ........ ...•.•.•.•.•.•.•.• ..•.•.•.•.•.•.•.•.•.•......... ........... 00,0Aflac 202:90 .....Aflac • • • .:....202;90 8958 09/30/22 • • • • • 8958 99/))1.22 ••• • 135-60150-010- Wholesale Water 318,424.43 8959 09/30/22 318,424.43 22O6 83 .65030;.0.1.0.4900::':::•:•:!-PeTW-44:••••••• 000 ..•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.• 2E05182-2 09/28/22 P 10 135-69005-010- ,440W:- 1249 FIRMER PIM ASSOCIATES,INC 11281 Totals for Check: 8963 Totals for Chetk:8964 3124 IRS Tax Payment ••••••••:•.312 _. 124 IRS Tax Fmient 3124 IRS Tax Payment 3124 IRS Tax Payment .......... Totals for Check: 8965 000 5. 010-00 ••••••••:•7:•:•:•:•:•. Capital Outlays • ••••••:•:•:•:••••••.-:-.'•:•:•:•.••:•:•:•:•-:- .••••• :-:-:-:-•:•:•:•:•.••:•:•:•.• • 09/22/22 P 20 135-55135-020 000 Lab Analysis 49,026.94 8961 49,026.94 :-:•:•:-:•:•:::•:•:•: • ' 09/30/22 1,290.00 8963 09/30/22 1,290.00 :67$32022:•:•:•:•: .•..•.•. !.; . 135 000 :::Lab:84101..iegx.x.:(341-119):.x8964 09/30 61.95 PR00767 996 09/21/22 P 135-21303-000-00o Social Security Taxes PR00767:::::::•996: 09/21/22:::::.:::::::::::::14t439470007000•:::::::::P*41-qre:qs•:•:•:•:•:-:-:•:::•:•::::::::::-• PRI:10768:::::::: 996 :09/30/22:::::3'.::::::::::::::135-21302000000...:::::::::FV11:1-0*0::::::::::::::::::::::::::::::::::::::::::.• Pt100168:::::::996 09/30/22:i::::.0:.:::.:::.: .. : .. 3;3523.1010:0Soi:008:.: .. ::;H:53Cial:•SecOOty..:TaXOs.::.:::::••••••••:••••••••• .•.•.•.•.•.•.•.•. PRO0768'' • : 996 09/30/22 '' li• • • • • • • 3j523.i54*-000 000 • • • * 'Medical -a' Takes' ' • • ' " " * " " • " • .•.•.•.•.•.•.•.•.•.• . • • . • • • •.. •.•.•.•............ ......•.•.•.•.•.•.•.•.•.•.• ...".". •••:•:•:•:•:•:•.•: ....•.•.•.•. apackant2 skrolczyk Begin Date: 09/01/2022 End Date: 09/30/2022 FR00765 996 09/02/22 PR00766:::::: 996.00/16/22: Fran Put: r•:•:•:•:•:•:• :•:• • :-:•:•:-:•:•:-: . 10 520-69005-010 Trophy Club MUD No.1 AP Checks For DateANnount Range .00 To Amt: 99,999,999.99 . .•.'.•.•.'.•. • . . . . . . . . . . . . . . clearti14.-.- • • 10110,t22be ma% 2022 Complete Agenda PaRiget 6 :4404111. : • : • : •: • : VieciS • .............. .1;868:08 8967 09/30/22'' 3,568.08 • : • Legal- Kan: • :•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•17;46•:•:• :0968:•i09/30/22:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:. Legal. Plat 17 44 8968 09/3)/22 Capital Outlays 53,568.62 8969 09/30/22 53,568.62 08/31,22: ]O::13555120-010-000::CLetThg:5eflht.�s 08/31/22%::::p 20 23555120020000 - -:•:cuaiithy:senitces 08/31/22 P 30 135-55120-030-000 Cleaning Services 07/31/22 P 10 135-55120-010-000 Cleaning Services 07/31/22 P 20 135-55120-020-0 o o Cleaning Set -vices 07/31/22 P 30 135-!-55120 -030 -000 Cleaning Services 09/39/22.::::f' 1.0:-.1.15;!$51:120011! 09/30/22:::.:p:...:.20:•13555120-020.,000 09/30/22"'P'%%'30 435-55120-030- C1.eani.ng Services 05/31/22 P 10 135-55120-010- Cleaning Services 161.23 8970 09/30/22 05/31/22 P 20 135-55120-020- Cleaning Services 161.22 8970 09/30/22 05/31/22 P ..::::::::::::::::::::::::::::::::5,159.20:::::::: 000 0 0 0 0 0 0 • 16i 22 8910 09/30/22 967:35" 8970•••09/36/22•.*••• 161.23 8970 09/30/22 161.22 8970 09/30/22 : ::967:35 • • 8970: :09/30/22:: : : : : : .6Z 22 8970 09/30/22 • 3970 09/30/22 ' 09/15/22 P 09152022 09/15/22 P 3179 PEW Gal STRATEGIES & SOLUTIONS 14367 . :•:•:-:• .•.•.•...•.•...•.•...•.•. GSA043-001 PS.AW-993, ::•:•:•:•:•:::•:::... 0 Or/ 0 0'0 20 135-50029-020- 30 135-50029-030- 70-030- 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ...•.•...•.•.'.•.•.'.•.•.•.•.• 09/16/22 P 30 135-55160-030- 0 0 0 08/18/22 P 10 135 -69005 -010 - 08/18/22-•••P•:•-:21).:• :43.7€009.50207 0. 00. 64/061iZ"'ii•%%16"3:35550864ii‘ 0 0 0 0 0 0 Life Insurance & Other Life Insurance & Other Professional Outside Services Capital Outlays 14 ot 91 ce '& •••••••••••••• • • : : : : :•:•:•:•:•:•:• 25.28 8971 09/30/22 28.81 8971 09/30/22 : : : . : : : : : : : . : : : : :•: 175.00 663.75 8973 09/30/22 • :06.69:::8974::09/. 06.69 92,560.40 8975 09/30/22 6;622.41 :•:•:•:•:•:•:•:•: 8.976 09/30/22 6,622.41 . . .'.•.'.•. " •••••••••••••••• • •.•.•.•.•. '•'• • • • • •.•.•.•.•. '• • • • •.•.•.•. . . . . . . . .•.•. . . . . . .•.•.•. . .•.•.•.•.•.•.•. . . . . . .•.•.•.•.•.•.•. . • • ••'•'• • • •.•.•. • • • • . . . .•.•.•.•. apackant2 skrolczyk Begin Date: 09/01/2022 End Date: 09/30/2022 : ••• . • • .:•::::•:•:•:•:...:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•: • 2440 TARRANT CTY PUBLIC HEALTH LAB 37341 ---09/30/22"P 2440 TARRANT CTY PUBLIC HEALTH LAB 37342 09/30/22 P Totals for Check: 8978 • Totals for Check: 8979 • .'.'.'. . ... • 2798 Tyler Technologies, Inc 025-395371 09/21/22 P ••• 3225 US Bank Voyager Fleet systeii•-.6024,tozz. . 09/24/22 P Totals for Check: 8981 Fran Ant: :•:. ••.• ••:•:•:•:• •:•: :•: 1.0-135-55135010- 000 10 135-55135-010-001 0 0 0 Trophy Club MUD No.1 AP Checks For DateANnount Range .00 To Amt: 99,999,999.99 10116A22ben.8126 2022 Complete Agenda PaRiget 7 :.:.:Pe4L:FAPPMAPX.X.:. Line ilein Lab Analysis for PID Value 550:00 80.00 630.00 LneLli Number::: Date 8978 09/30/22 .•%%. 8978 09/30/22 .................. 213,17-000-°°° !MRS • •:.:.:•:•••:•:.:•:.:.:••:•:•••:•:•••:•:•••:•••:•:•••• •••• .....::.: :.:.::.::............................ 30 135-69005-030- 000 ••• 10::::13545005410.400:: 20 135-65005-020- 000 ... • . Capital Outlays Fuel. &Lube Fuel & Lube ." 2,405.00 8980 09/30/22 1,80:46 8981 09/30/22 1,585.00 8981 09/30/22 3,482.40 • 998 ALDAPE, GRACE •U0010040331102A 09/30/22 P 135-20050.70007000 A/P Vendors 57.27 • 57.27 39.97 39.97 Totals for Check: 8982 010.. 0 0 1 Totals for Check: 8983 0 0'. 0 0 0 0 000 --.1357200507000t000-•••••••••A/P-VendorS.,•-••••••• " "•••••• • " • " " " • 998 CASPM)VA. JEFFREY 716105A 09/30/22 P ""'1.35-20050000 (n).:A/P Vendors Totals for Check: 8985 fl.d4C.*:* • Totals for Check: 8987 00. 00 • 0 • • • • • • • • • • • • • • • • • • • • • 0 0 0 1 .•.'.•.'. 99.3: 110010130108103A 09/30/:?2:•:•:•P:•:•••:•:...:•13520050000000 :••••••• A/P VaxIors • • • • • • • • • • • • • • • • • • • • • • • •••••••••••••••••••••••••••• ......... 998 HALL; MICHAEL Totals for Check: 8989 998. HARRISON, J01-11 DAVID :TOtai:fOr:Cpck: 8990 000 Totals for Check: 8991 8982 09/30/22 • • •••••:-: :•:•:::::•:•:•...-.. .•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.• : : :•:•:•:•:•:•:•: :40.00 8D84:09/30. /2?-:::::::-:-::-•-••••••••••• • • • • • •••••• • •••••••• • • ••••• • • •••• 5L41 8985 09/30/22 • • • • _ 51.41 63.88 . • • . . • •.... -•-•-•-•-•-•:::::::::::::::::: • •••••8987...09130122 • • • . • ""' "' " "' 034 09/30/22 rs V —5434 8989 09/30/22 54.34 10*. W.W22 • P.•••• • • iotki6/36/ii%%F. x•-..x...998.-.MAINSTREET:FEHENAL.:.::::::x.:.:. 110010080591101A ......•.•.•.•.•.•.. -2 000 000 • A/P • • • ••••••••••••••:•:•::::::::::::: . • •%4/01iii6int • • • • • •136-.6.1:•:•. 8990 09/30/22 • "••58.90" "8991 • 09/30/22 58.90 • ••••••••••••••••••:•:•:•:•:•:::::::::::::.::.::....... . . .'.•.'.•. . .•.•.•.•. apackamt2 skrolczyk Trophy Club MUD No.1 AP Checks For Date/Amount Range .00 To Amt: 99,999,999.99 Begin Date: 09/01/2022 End Date: 09/30/2022 • . • •••••.• •• 0 0 0 0 134103A 09/30/22 00 Fran Ant: iollerAnbenillp 2022 Complete Agenda Part 8 . .•.•.•.•.•.•.• ::::1F,J.:9!P19111';':':':::' • • • • •.• • • r :•:•:•:•:•:• :•:• •:• ••••:•:•:•:•:::•:::::::::::::::•:•: Value Nunber :•:.: Date :. ' • •:•:•:•: •:•: :•: • • :•:•.•:•:•:::::::::::•:•:• . .. ... 135- 00.0 000 000" A/PVendors 11.45 8993 09/30/22 :•::•j 00. 0 11.45 •000-000::•:• A/P VelldOrS •••;•:•;•;•:•;•;•:•:•:•:•:•:•:•:•:•:•:•:•::::::::126;47,94::: 8994 09/30/22 -:•: :-:• 0 0 0 0 0 0 Totals for Check: 8995 54.34 Vendors • • • •-:-: 103.97: • •••••••••• • • :::::::: • ••:•:•:•:•:•:•:•: : : : : : : : : : : • :::::::::: 1,361,591.77 . . : : : •-• : :•: : : : : : • • • :•:•:•:•:- • • • • *•••• :•:•: : • ••• • •••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••.....•••••••••••••••••••••••••••••••••••••••••••.........••••••••••••••••••••••••••• • ••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••• . . . . . . . . . . •:•:•:•:•:•:•:•:•:•:•:•:• • . . . . . . . .'.•.'.•. ••••:•:•:•:•:•:•:•:•:•:•:•:•:•:•: :•:•:•:•:•:•:•:•:•:•:•:• • • - — • — • — • — • — - — • . . • • •• . . .•.•.•.•.•.•.•.•.•. . . . .•.•.•.•.•.•.•. . . ..•.•.•.•.•.•.•.. . . . . .•.•.•.•.•.•.•. . .•.•.•.•.•.•.•.•.•.. . .•.•.•.•. • . . . .•.•.•.•.•.•. . . . .•.•.•.•.•.•.•.•. . . . . . .•.•.•.•.•.•.•.. . . .•.•.•.•.•.•.•. . . . . .•.•.•.•.•.•.•. . . . .•.•.•.•.•.•.•. . • • • • '• • • • • • • • •.•.•.•.. •.•.•.•.•.•.•. .•.•.•.•.•.•.•.•.•. . . . . . . • • • • • •••••••••••••••••••... CASH STATUS AS OF SEPTEMBER 2022 1 35-1 02 50 TexPool 0 & M (XXXXX0002)-General Fund Operating *** 1 35-1 03 00 Prosperity Bank (XXX8701) General Fund Operating 1 35-1 03 05 Prosperity Bank Reserve -Savings Acct (XXXXX7724) 1 35-1 11 00 Petty Cash Administration 1 35-1 11 50 Petty Cash Utility Billing 1 37-1 02 50 TexPool 0 & M (XXXXX0002) GASB Replacement 51 9-1 02 50 Texpool Revenue Bond Construction (XXXXX015) SWIFT 51 9-111 55 Cash -Bond Escrow Bank of Texas (SWIFT) 520-1 02 50 Texpool Revenue Bond Water & Waste Water Systems 2019 (XXXXX018) 520-1 03 00 Prosperity Bank Construction Water & Waste Water Systems 2019 528-1 02 50 TexPool Revenue Bond Reserve (XXXXX014) WWTP Improvements 533-1 02 50 TexPool Tax I & S (XXXXX0003) 533-1 03 00 Prosperity Bank (XXX8701) Tax I&S 534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements 535-10250 Texpool Revenue I & S (XXXXX017) SWIFT 536-10250 TexPool Revenue I & S (XXXXX020) Water & Waste Water Systems Amount available in cash (MUD Accounts) Amount available for spending (MUD Accounts) *09/30/2022 Customer Water Deposits $328,600 Fire Department Cash 11 22-1 02 50 ITexPool 0 & M (XXXXX0002)-Fire Operating Cash 1122-10300 Prosperity Bank (XXX8701) Fire Operating Amount available in cash (Fire Department Accounts) Amount available for spending (Fire Department Accounts) Total General Fund 135 Available for Spending General Fund 135 Fund Balances Nonspendable Fund Balance (Prepaids) Assigned Fund Balance (FY2022 Capital Projects plus prior year carry forward) Unassigned Fund Balance Current Year Revenue/Expenses Total Nonspendable, Assigned & Committed Fund Balances - General Fund 135 17 of 91 October 19, 2022 Complete Agenda Packet Restricted - Unable to be spent $o $328,600 $1,882,637 $0 $0 $2,985,575 $0 $787,221 $1,497,693 $0 $900,604 $51,961 $0 $27,958 $6,555 $1,429 Unrestricted - Available for spending $3,782,898 $4,187,799 $0 $150 $450 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $7,971,297 1 $0 I $7,971,297 $7,971,297 $675,927 $0 $675,927 I $675,927 $675,927 Total in Accounts (Restricted & Unrestricted) $3,782,898 $4,516,399 $1,882,637 $150 $450 $2,985,575 $0 $787,221 $1,497,693 $0 $900,604 $51,961 $0 $27,958 $6,555 $1,429 $16,441,530 General Fund 135 Available 4,187,799 Prosperity General Fund 3,782,898 Texpool General Fund 600 Petty Cash 7,971,297 3,880 3,370,500 5,780,613 1,687,828 $10,842,821 $675,927 $0 $675,927 October 19, 2022 Complete Agenda Packet September Utility Billing Report Fiscal Year 2021 - 2022 Sept. Oct. Nov. Dec. Jan Feb Mar Apr May June July Aug Sept. 2021 2021 2021 2021 2022 2022 2022 2022 2022 2022 2022 2022 2022 ebills 1,267 1,338 1,360 1,370 1,388 1,420 1,424 1,465 1,518 1,566 1,592 1,629 1,654 Bills Mailed 3,878 3,868 3,863 3,855 3,855 3,872 3,864 3,868 3,865 3,882 3,872 3,850 3,832 Bank Draft 659 675 655 663 668 670 671 676 692 700 697 704 703 Credit Card Draft 1,400 1,414 1,415 1,415 1,437 1,431 1,442 1,455 1,450 1,456 1,471 1,484 1,481 Online Payments 1,191 1,185 1,166 1,175 1,174 1,138 1,225 1,171 1,196 1,188 1,220 1,170 1,203 Late Notices 336 390 293 362 377 362 326 355 284 339 387 310 326 Disconnects 23 18 12 1 3 5 8 9 9 4 7 5 2 September Permits Fiscal Year 2022 Date of Customer Due to FW Oversize Plumbing Sewer Permit No. Permit Deposit Water Meter Inspections Inspections Fire Line Misc. Income Total $ Total $ $ $ $ - $ - $ - $ - $ 18 of 91 October 19, 2022 Complete Agenda Packet FY 2022 General Fund YTD Budget Variance Account Description FY 2022 Adopted Amended Budget September Totals YTD Total 9/30/2022 YTD % Budget (100% Target) Remaining Budget General Fund Revenues 135-40000-000-000 Property Taxes 136,092 136,092 177 138,467 101.74% (2,375) 135-40002-000-000 135-40015-000-000 135-40025-000-000 135-47000-000-000 135-47005-000-000 135-47025-000-000 135-47030-000-000 135-47035-000-000 135-47045-000-000 135-47070-000-000 135-48010-000-000 135-49000-000-000 135-49011-000-000 135-49016-000-000 135-49018-000-000 135-49026-000-000 135-49035-000-000 135-49036-000-000 135-49005-000-000 135-49075-000-000 135-49141-000-000 135-49145-000-000 135-49900-000-000 135-49901-000-000 135-49903-000-000 135-00000-000-000 Property Taxes/Delinquent Property Taxes/P & I PID Surcharges Water Sewer Penalties Service Charges (Disconnect Fees) Plumbing Inspections Sewer Inspections TCCC Effluent Charges Utility Fees Capital Lease- Other Fin Sources Interest Income Cell Tower Revenue Building Rent Income Proceeds from Sale of Assets Prior Year Reserves GASB Reserves Loan Proceeds Oversize Meter Reimbursement Interfund Transfer In Intergov Transfer In Miscellaneous Income Records Management Revenue Recovery of Prior Year Expense Reimbursement ITotal 300 300 165,537 6,033,776 3,824,473 94,826 14,000 750 2,500 50,000 15,000 14,146 10,000 300 300 165,537 6,033,776 3,824,473 94,826 14,000 750 2,500 50,000 15,000 14,146 25,000 524,000 2,058 2,058 7,000 7,000 4 31 164,890 719,195 325,132 10,155 100 (179) 541 164,890 6,746,417 3,812,703 105,893 4,670 450 100 12,132 109,207 15,332 66,251 1,179 14,146 21,001 65 -59.81% 180.49% 99.61% 111.81% 99.69% 111.67% 33.35% 60.00% 4.00% 218.41% 0.00% 0.00% 441.67% 100.00% 0.00% 84.00% 0.00% 0.00% 0.00% 2,261 109.88% 0.00% 0.00% 7,899 112.84% 0.00% 85,000 0.00% 0.00% 479 (241) 647 (712,641) 11,770 (11,067) 9,331 300 2,400 (59,207) (51,251) 0 3,999 524,000 (203) (899) (85,000) 10,370,758 1 10,909,758 1,248,392 I 11,279,716 I 103.39% (369,958) Water 135-50005-010-000 135-50010-010-000 135-50016-010-000 135-50017-010-000 135-50020-010-000 135-50026-010-000 135-50027-010-000 135-50028-010-000 135-50029-010-000 135-50030-010-000 135-50035-010-000 135-50040-010-000 135-50045-010-000 135-50060-010-000 135-50070-010-000 135-55080-010-000 135-55085-010-000 135-55090-010-000 135-55105-010-000 135-55120-010-000 135-55135-010-000 135-55135-010-001 135-60010-010-000 135-60020-010-000 135-60066-010-000 135-60070-010-000 135-60080-010-000 135-60090-010-000 135-60100-010-000 135-60105-010-000 135-60135-010-000 135-60135-010-001 135-60150-010-000 135-60245-010-000 135-60280-010-000 135-60285-010-000 135-60332-010-000 135-60333-010-000 135-60334-010-000 135-60360-010-000 135-65005-010-000 135-65010-010-000 IGeneral Fund Expenses Salaries & Wages Overtime Longevity Certification Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Pre-emp Physicals/Testing Employee Relations Maintenance & Repairs Generator Maintenance & Repairs Vehicle Maintenance Maintenance -Heavy Equipment Cleaning Services Lab Analysis - MUD Lab Analysis - PID Communications/Mobiles Electricity Publications/Books/Subscripts Dues & Memberships Schools & Training Safety Program Travel & per diem Rent/Lease Equipment TCEQ Fees & Permits - MUD TCEQ Fees & Permits - PID Wholesale Water Miscellaneous Expenses Property Maintenance Lawn Services Interfund Transfer Out- Revenue I&S Interfund Transfer Out- Bond Reserve Interfund Transfer Out -Bank Reserve Furniture/Equipment < $5000 Fuel & Lube Uniforms I � 402,468 17,000 5,829 4,500 46,074 97,671 5,594 719 4,620 26,647 6,232 1,512 11,604 400 300 110,000 2,000 5,000 1,000 2,000 7,500 2,000 7,500 131,689 1,000 372,468 22,000 5,829 4,500 46,074 67,671 5,594 719 4,620 26,647 6,232 1,512 11,604 400 300 200,000 2,000 10,000 1,000 2,000 7,500 2,000 7,500 131,689 1,000 4,141 4,141 988 988 30,000 30,000 2,508,611 2,508,611 12,500 12,500 569,454 569,454 2,500 2,500 15,000 15,000 19 8f.91 5,250 41,998 2,370 225 4,994 5,745 339 48 285 2,714 635 355,483 31,858 5,713 2,650 44,359 65,577 3,923 553 3,573 24,091 5,634 143 909 10,909 55 182 9,203 345,322 952 104 9,738 237 1,935 5,285 1,369 6,865 138,327 875 125 114 2,649 645 764 255 404 14,318 59 59 21,486 437 318,424 2,387,455 1,200 6,315 569,455 1,923 1,897 21,376 2,474 95.44% 144.81% 98.00% 58.89% 96.28% 96.91% 70.13% 76.90% 77.34% 90.41% 90.41% 9.45% 94.01% 13.86% 60.63% 172.66% 47.58% 97.38% 23.66% 96.74% 70.47% 68.45% 91.54% 105.04% 87.50% 0.00% 63.97% 0.00% 6.00% 0.00% 71.62% 0.00% 95.17% 0.00% 0.00% 50.52% 100.00% 0.00% 0.00% 76.92% 142.50% 47.13% 16,985 (9,858) 117 1,850 1,715 2,094 1,671 166 1,047 2,556 598 1,369 695 345 118 (145,322) 1,048 262 763 65 2,215 631 635 (6,638) 125 (125) 1,492 929 8,514 (437) 121,156 6,185 (1) 577 (6,376) 2,776 Account 135-65030-010-000 135-65035-010-000 135-65040-010-000 135-65050-010-000 135-65053-010-000 135-69005-010-000 135-69008-010-000 135-69009-010-000 135-69195-010-000 135-69281-010-000 135-70040-010-000 Wastewater 135-50005-020-000 135-50010-020-000 135-50016-020-000 135-50017-020-000 135-50020-020-000 135-50026-020-000 135-50027-020-000 135-50028-020-000 135-50029-020-000 135-50030-020-000 135-50035-020-000 135-50040-020-000 135-50045-020-000 135-50060-020-000 135-50070-020-000 135-55005-020-000 135-55070-020-000 135-55080-020-000 135-55081-020-000 135-55085-020-000 135-55090-020-000 135-55091-020-000 135-55105-020-000 135-55120-020-000 135-55125-020-000 135-55135-020-000 135-60010-020-000 135-60020-020-000 135-60066-020-000 135-60070-020-000 135-60080-020-000 135-60090-020-000 135-60100-020-000 135-60105-020-000 135-60125-020-000 135-60135-020-000 135-60245-020-000 135-60280-020-000 135-60285-020-000 135-60331-020-000 135-60332-020-000 135-60333-020-000 135-60334-020-000 135-60360-020-000 135-65005-020-000 135-65010-020-000 135-65030-020-000 135-65031-020-000 135-65035-020-000 135-65040-020-000 135-65045-020-000 135-69005-020-000 135-69008-020-000 135-69009-020-000 135-69195-020-000 135-70020-020 Board of Directors 135-50005-026-000 135-50030-026-000 135-50035-026-000 135-55040-026-000 Chemicals Small Tools Safety Equipment Meter Expense Meter Change Out Program Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Water Tank Inspection Contract Bond Related Expenses (Subtotal Water Salaries & Wages Overtime Longevity Certification Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Pre-emp Physicals/Testing Employee Relations Engineering Independent Labor Maintenance & Repairs- WWTP Maintenance & Repairs- Collections Generator Maintenance & Repairs Vehicle Maintenance- WWTP Vehicle Maintenance- Collections Maintenance -Heavy Equipment Cleaning Services Dumpster Services Lab Analysis Communications/Mobiles Electricity Publications/Books/Subscripts Dues & Memberships Schools & Training Safety Program Travel & per diem Rent/Lease Equipment Advertising TCEQ Fees & Permits Miscellaneous Expenses Property Maintenance Lawn Equipment & Maintenance Interfund Transfer Out -Tax I&S Interfund Transfer Out- Revenue I&S Interfund Transfer Out -Bond Reserve Interfund Transfer Out -Bank Reserve Account Furniture/Equipment < $5000 Fuel & Lube Uniforms Chemicals- WWTP Chemicals- Collections Small Tools Safety Equipment Lab Supplies Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Capital Lease Issuance Cost 1Subtotal Wastewater Salaries & Wages Social Security Taxes Medicare Taxes Unemployment Taxes October 19, 2022 Complete Agenda Packet FY 2022 Adopted Amended Budget September Totals YTD Total 9/30/2022 YTD % Budget (100% Target) Remaining Budget 1 25,000 20,000 87,000 905,000 31,419 1,404 75,000 113,500 25,000 20,000 87,000 1,429,000 31,419 1,404 75,000 113,500 5,307,626 1 5,871,626 1 478,934 33,000 7,956 8,400 56,634 112,190 7,175 1,013 4,800 32,754 7,660 1,764 14,153 400 300 125,000 222,500 9,000 4,600 13,000 3,000 2,000 100,000 40,000 7,500 150,732 4,652 1,138 418,934 33,000 7,956 8,400 56,634 72,190 7,175 1,013 4,800 32,754 7,660 1,764 14,153 400 300 160,000 222,500 9,000 4,600 13,000 3,000 2,000 100,000 40,000 7,500 150,732 4,652 1,138 12,000 22,000 16,000 115,924 690,085 500 12,500 6,205 32,500 10,000 33,000 700,000 81,878 7,312 130,000 3,298,159 1 20of9 16,000 115,924 690,085 500 12,500 6,205 32,500 10,000 33,000 685,000 81,878 7,312 130,000 3,228,159 3,741 30,633 66,372 161,493 828,448 31,418 1,404 75,000 1,500 112,364 574,382 1 5,225,002 1 122.53% 0.00% 0.00% 0.00% 76.29% 57.97% 100.00% 100.02% 100.00% 99.00% 0.00% 88.99% 46,906 375,640 89.67% 2,939 31,256 94.72% 7,955 99.99% 425 5,900 70.24% 5,630 47,229 83.39% 6,227 71,491 99.03% 338 3,957 55.15% 48 566 55.92% 266 3,400 70.82% 3,105 25,817 78.82% 726 6,038 78.82% 15 70 3.98% 1,118 13,414 94.78% 292 72.94% 445 148.22% 0.00% 0.00% 71 193,703 121.06% 1,112 285,863 128.48% 4,604 51.16% 218 524 11.39% 18,947 145.74% 1,325 44.18% 645 1,935 96.73% 83,424 83.42% 4,374 43,682 109.20% 340 6,383 85.10% 15,964 172,359 114.35% 0.00% 0.00% 114 1,700 36.55% 0.00% 0.00% 0.00% 0.00% 19,974 90.79% 0.00% 0.00% 1,420 6,067 37.92% 115,924 100.00% 690,086 100.00% 0.00% 0.00% 0.00% 1,585 13,040 104.32% 175 3,299 53.17% 2,381 25,284 77.80% 5,776 57.76% 0.00% 0.00% 62 31,073 94.16% 116,210 316,338 46.18% 83,496 101.98% 5,695 77.88% 130,000 100.00% 0.00% 212,413 1 2,853,970 1 88.41% 0.00% 0.00% 0.00% 0.00% (5,633) 20,000 20,629 600,552 1 (0) 1,136 646,624 43,294 1,744 1 2,500 9,405 699 3,218 447 1,400 6,937 1,622 1,694 739 108 (145) (33,703) (63,363) 4,396 4,076 (5,947) 1,675 65 16,576 (3,682) 1,117 (21,627) 2,952 1,138 2,026 9,933 (0) (1) 500 (540) 2,906 7,216 4,224 1,927 368,662 (1,618) 1,617 374,189 October 19, 2022 Complete Agenda Packet Account Description FY 2022 Adopted Amended Budget September Totals YTD Total 9/30/2022 YTD % Budget (100% Target) Remaining Budget 135-50045-026-000 135-60066-026-000 135-60070-026-000 135-60075-026-000 135-60080-026-000 135-60100-026-000 135-60245-026-000 Administration 135-50005-030-000 135-50010-030-000 135-50016-030-000 135-50020-030-000 135-50026-030-000 135-50027-030-000 135-50028-030-000 135-50029-030-000 135-50030-030-000 135-50035-030-000 135-50040-030-000 135-50045-030-000 135-50060-030-000 135-50070-030-000 135-55005-030-000 135-55030-030-000 135-55070-030-000 135-55080-030-000 135-55085-030-000 135-55100-030-000 135-55120-030-000 135-55160-030-000 135-55205-030-000 135-60005-030-000 135-60010-030-000 135-60020-030-000 135-60025-030-000 135-60035-030-000 135-60040-030-000 135-60050-030-000 135-60055-030-000 135-60066-030-000 135-60070-030-000 135-60075-030-000 135-60079-030-000 135-60080-030-000 135-60100-030-000 135-60110-030-000 135-60115-030-000 135-60125-030-000 135-60235-030-000 135-60245-030-000 135-60246-030-000 135-60285-030-000 135-60360-030-000 135-65010-030-000 135-65055-030-000 135-65085-030-000 135-65090-030-000 135-65095-030-000 135-65105-030-000 135-69005-030-000 135-69170-030-000 Non Departmental 135-55045-039-000 135-55055-039-000 135-55060-039-000 135-55065-039-000 Workman's Compensation Publications/Books/Subscripts Dues & Memberships Meetings Schools & Training Travel & per diem Miscellaneous Expenses 'Subtotal Board of Directors Salaries & Wages Overtime Longevity Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Pre-emp Physicals/Testing Employee Relations Engineering Software & Support Independent Labor Maintenance & Repairs Generator Maintenance & Repairs Building Maintenance & Supplies Cleaning Services Professional Outside Services Utility Billing Contract Telephone Communications/Mobiles Electricity Water Postage Bank Service Charges & Fees Bad Debt Expense Insurance Publications/Books/Subscripts Dues & Memberships Meetings Public Education Schools & Training Travel & per diem Physicals/Testing Elections Advertising Security Miscellaneous Expenses General Manager Contingency Lawn Equipment & Maintenance Furniture/Equipment < $5000 Uniforms Hardware IT Office Supplies Printer Supplies & Maintenance Maintenance Supplies Printing Capital Outlays Copier Lease Installments 1Subtotal Administration Legal Auditing Appraisal Tax Admin Fees 'Subtotal Non Departmental 1 30 750 1,500 4,000 5,000 500 11,780 1 1 1 567,338 2,000 2,972 61,353 103,384 6,533 819 4,800 35,483 8,298 1,512 1,425 500 4,000 122,310 15,000 40,000 3,000 12,000 70,281 9,000 8,500 3,000 15,213 5,000 30,000 85,000 1,500 84,000 6,000 30 750 1,500 4,000 5,000 500 11,780 1 1 567,338 2,000 2,972 61,353 83,384 6,533 819 4,800 35,483 8,298 1,512 1,425 500 4,000 122,310 25,000 40,000 3,000 12,000 70,281 9,000 8,500 3,000 15,213 5,000 30,000 85,000 1,500 84,000 6,500 2,000 4,000 5,250 5,250 1,587 1,587 5,000 12,500 2,500 2,500 5,000 10,000 530 21,400 6,000 4,000 190,000 4,000 1 1,567,488 1 135,000 33,800 12,055 4,850 I 185,705 1 5,000 10,000 530 21,400 6,000 4,000 190,000 4,000 1,567,488 1 115 116 1 10 700 1,416 625 2,751 1 34.33% 0.00% 93.33% 94.37% 15.63% 0.00% 0.00% 23.35% 1 1 1 56,116 523,964 92.35% 68 549 27.44% 2,973 100.02% 6,293 59,277 96.62% 5,200 69,806 83.72% 273 3,762 57.58% 40 527 64.38% 371 4,507 93.89% 3,372 31,338 88.32% 789 7,329 88.32% 54 3.57% 126 1,511 106.03% 516 103.13% 3,471 86.77% 0.00% 6,711 107,190 87.64% 824 29,023 116.09% 8,684 47,789 119.47% 717 23.89% 0.00% 3,869 12,266 102.22% 664 75,415 107.30% 651 7,346 81.62% 585 5,909 69.52% 225 2,700 90.00% 1,006 15,200 99.91% 352 4,107 82.14% 1,875 22,408 74.69% 9,506 92,832 109.21% 9,562 9,562 637.44% 7,307 86,013 102.40% 0.00% 160 6,522 100.33% 0.00% 3,867 96.67% 32 913 17.39% 509 32.10% 0.00% 3,765 30.12% 675 10,412 416.47% 0.00% 112 0.00% 0.00% 470 4,227 84.54% 3,284 32.84% 443 443 83.49% 10,647 12,206 57.04% 272 4,217 70.28% 0.00% 675 6,190 154.74% 0.00% 125,948 66.29% 3,242 81.04% 1,413,914 1 90.20% 5,590 254 143,685 1 1 1 1 1,715 52,420 25,375 2,271 14,582 3,874 3,986 I 96,251 100,000 33,800 12,055 4,850 150,705 I 52.42% 75.08% 120.96% 79.88% 63.87% 20 50 84 3,375 5,000 500 9,029 43,374 1,451 (1) 2,076 13,578 2,771 292 293 4,145 969 1,458 (86) (16) 529 15,120 (4,023) (7,789) 2,283 (266) (5,134) 1,654 2,591 300 13 893 7,592 (7,832) (8,062) (2,013) (22) 133 4,337 1,078 8,735 (7,912) (112) 773 6,716 88 9,194 1,783 (2,190) 64,052 758 153,574 47,580 1 8,425 (2,527)1 976 54,454 1 Total General Fund Revenues Total General Fund Expenses Net Budget Surplus (Deficit) 10,370,758 10,370,758 10,909,758 10,829,758 80,000 1,248,392 934,582 313,810 11,279,716 9,591,888 1,687,829 103.39% 88.57% 14.82% (369,958) 1,237,870 1,607,828 21 of 91 October 19, 2022 Complete Agenda Packet FY 2022 Combined Financials YTD as of 9/30/2022 YTD Revenues • YTD Expenses Amended Revenues • Amended Expenses Adopted Revenues Adopted Expenses 111. Adopted Budget vs YTD Actuals Revenues & Expenses $9,591,888 $10,909,758 $10,829,758 $10,370,758 $2,751 $96,251 0% -. 1% $1,413,914 15% YTD Expenses By Departments YTD Expense- Water 52,853,970 55,225,002 54% 30% YTD Expense- WW YTD Expense- Admin YTD Expense- BOD • YTD Expense- Non Dept Water Budget vs Actual 140,000,000 120,000,000 100,000,000 80,000,000 Water Consumption Budget vs Actual 80,639,404 72,448,000 119,711,0001 85,474,000 78,390,000 60,000,000 54,635,000 49,322,000 44,588,000 48,488,000 40,021,000 40,000,000 51 338 613 / 56,888,452 44,024,449 B 04,839 36,662,055 36,449,799 20,000,000 Budget Consumption 143,845,000 08,377,000 41,177,000 124,313,693 114,781,327 90,391,285 96,534,832 63,970,589 -*-Actual Consumption 0 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep 1,000,000,000 900,000,000 800,000,000 700,000,000 600,000,000 500,000,000 400,000,000 300,000,000 200,000,000 100,000,000 0 Adopted Budget Water Consumption Vs Actual Water Consumption 986.476.000 834,099,338 Total Water Consumption • Budgeted Water Consumption • Proiected Water Consumption Presented by: Finance Department $1,000,000 $900,000 $800,000 $700,000 $600,000 5500,000 5400,000 8455,836 $300,000 ;359,936 Water Revenue Budget vs Actual $569,186 $402,228 $373,428 8370,639 $398,851 J $320,532$322,394 8326,817 $200,000 5328,46 5510,419 5360,890 5918,465 $786,615 / 8580,431 $100,000 $0 8423,949 $466,196 Budget Revenue --Actual Revenue 8817,889 $759,395 $651,814 5939,810 8719,195 8616,814 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep $8,000,000 $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 51,000,000 $o Adopted Budget Water Revenue Vs Projected Water Revenue $6,033,776 $3,525,165 Total Water Revenue $4,008,962 • Budgeted Water Revenue • Projected Water Revenue Net Budgeted Water Revenue Minus Budgeted Expenses • Net Projected Water Revenue Minus Projected Expenses 22 of 91 October 19, 2022 Complete Agenda Packet TROPHY CLUB MUD NO. 1 - FIRE DEPARTMENT BALANCE SHEET SEPTEMBER 2022 ASSETS CASH IN BANK INVESTMENTS PREPAID EXPENSES ADVALOREM PROPERTY TAXES RECEIVABLE EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 FIRE DEPT. 675,927 12,891 TOTAL ASSETS 688,819 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 7,015 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 7,015 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON -SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 720,907 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES (39,103) TOTAL FUND BALANCE 681,804 TOTAL LIABILITIES AND FUND BALANCE 688,819 23 of 91 TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET SEPTEMBER 2022 October 19, 2022 Complete Agenda Packet 135 137 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 4,516,399 4,516,399 CASH IN BANK -SAVINGS -CASH RESERVE 1,882,637 1,882,637 INVESTMENTS-TEXPOOL 3,782,898 2,985,575 6,768,472 PREPAID EXPENSES 3,880 3,880 ADVALOREM PROPERTY TAXES RECEIVABLE 1,288 1,288 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,291,615 1,291,615 TOTAL ASSETS 11,479,318 2,985,575 14,464,893 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES (164) (164) ACCOUNTS AND OTHER PAYABLES 308,061 308,061 CUSTOMER DEPOSITS 328,600 328,600 TOTAL LIABILITIES 636,497 636,497 FUND BALANCE NON -SPENDABLE FUND BALANCE 3,880 3,880 ASSIGNED FUND BALANCE 3,370,500 3,370,500 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 360,000 360,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT 1,113,885 1,113,885 ASSIGNED FUND BALANCE/SEWER REPLACEMENT 1,211,690 1,211,690 ASSIGNED FUND BALANCE/FIRE DEPARTMENT - - ASSIGNED FUND BALANCE/WWTP MBR REPLACEMENT 300,000 300,000 UNASSIGNED FUND BALANCE 5,780,613 5,780,613 COMMITTED FUND BALANCE - - NET REVENUES / EXPENDITURES 1,687,828 1,687,828 TOTAL FUND BALANCE 10,842,821 2,985,575 13,828,396 TOTAL LIABILITIES AND FUND BALANCE 11,479,318 2,985,575 14,464,893 24 of 91 October 19, 2022 Complete Agenda Packet TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET SEPTEMBER 2022 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 519 REVENUE BOND CONSTRUCTION 787,221 TOTAL ASSETS 787,221 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 25 of 91 81,691 81,691 703,345 2,185 705,530 787,221 October 19, 2022 Complete Agenda Packet TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET SEPTEMBER 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 REVENUE BOND 1,497,693 TOTAL ASSETS 1,497,693 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 158,596 TOTAL LIABILITIES 158,596 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES 4,032,009 (2,692,912) TOTAL FUND BALANCE 1,339,097 TOTAL LIABILITIES AND FUND BALANCE 1,497,693 26 of 91 October 19, 2022 Complete Agenda Packet TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET SEPTEMBER 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 900,604 TOTAL ASSETS 900,604 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 27 of 91 894,311 6,293 900,604 900,604 October 19, 2022 Complete Agenda Packet TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET SEPTEMBER 2022 ASSETS CASH IN BANK INVESTMENTS PREPAID EXPENSES ADVALOREM PROPERTY TAXES RECEIVABLE ACCOUNTS RECEIVABLE -OTHER 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 533 INTEREST & SINKING DEBT 51,961 7,294 TOTAL ASSETS 59,255 LIABILITIES AND FUND BALANCE LIABILITIES 57,355 DEFERRED REVENUE - AD VALOREM PROPERTY TAXES (2,244) ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES 55,111 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES (16,307) 20,453 TOTAL FUND BALANCE 4,144 TOTAL LIABILITIES AND FUND BALANCE 59,255 28 of 91 October 19, 2022 Complete Agenda Packet TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET SEPTEMBER 2022 CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB 1 / MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND ASSETS I&S WWTP 27,958 TOTAL ASSETS 27,958 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 26,061 1,898 27,958 TOTAL LIABILITIES AND FUND BALANCE 27,958 29 of 91 October 19, 2022 Complete Agenda Packet TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET SEPTEMBER 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 6,555 TOTAL ASSETS 6,555 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 5,656 NET REVENUES / EXPENDITURES 899 TOTAL FUND BALANCE 6,555 TOTAL LIABILITIES AND FUND BALANCE 6,555 30 of 91 October 19, 2022 Complete Agenda Packet TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET SEPTEMBER 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 1,429 TOTAL ASSETS 1,429 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 565 NET REVENUES / EXPENDITURES 864 TOTAL FUND BALANCE 1,429 TOTAL LIABILITIES AND FUND BALANCE 1,429 31 of 91 October 19, 2022 Complete Agenda Packet REGULAR MEETING MINUTES TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 BOARD OF DIRECTORS September 21, 2022 at 6:30 p.m. Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in regular session on September 21, 2022 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 (via Zoom) joined the meeting at 6:42 pm Ben Brewster Vice President Doug Harper Secretary/Treasurer William C. Rose Director Tracey Hunter Director STAFF PRESENT: Alan Fourmentin Laurie Slaght Mike McMahon Steven Krolczyk Tony Corbett General Manager District Secretary Operations Manager Finance Manager Legal Counsel CALL TO ORDER AND ANNOUNCE A QUORUM Vice President Brewster announced the date of September 21, 2022, called the meeting to order and announced a quorum present at 6:39 p.m. Brewster stated that Board President Kevin Carr would be attending via Zoom PUBLIC HEARING 1. Public Hearing regarding adoption of the final District Tax Rates for Tax Year 2022. Vice President Brewster stated Trophy Club Municipal Utility District No. 1 will conduct a Public hearing regarding adoption of the final District Tax Rates for the tax year 2022 at $0.09134 per $100 of assessed valuation; a decrease of $0.0154 from tax year 2021. Vice President Brewster opened the Public Hearing at 6:40 p.m. Vice President Brewster closed the Public Hearing at 6:40 p.m. CITIZEN COMMENTS Gina French 30 Cypress Court -Waterline construction run off. REPORTS & UPDATES 2. Staff Reports a. Capital Improvement Projects 32 of 91 October 19, 2022 Complete Agenda Packet b. Water Operations Report c. Wastewater System Reports d. Finance Reports General Manager Alan Fourmentin presented the monthly staff reports and answered questions related thereto. CONSENT AGENDA 3. Consider and act to approve the Consent Agenda. a. August 2022 Combined Financials b. August 17, 2022 Regular Meeting Minutes c. Appointments to Fort Worth Wholesale Advisory Committee for FY2023. Motion made by Director Rose and seconded by Director Carr to approve Consent Agenda items a. through c., as presented. Motion carried unanimously REGULAR SESSION 4. Consider and act regarding adoption of Resolution No. 2022-0921A approving Budget for Fiscal Year 2023. Motion made by Director Rose and seconded by Director Carr to approve Resolution No. 2022-0921A of Trophy Club Municipal Utility District No. 1 of Denton and Tarrant Counties adopting a budget for FY2023 for the fiscal year beginning October 1, 2022 and ending September 30, 2023. For: Rose, Brewster, Harper, and Carr Apposed: Hunter Motion passed 4-1 5. Consider and act regarding adoption of Rate Order No. 2022-0921A amending water rates and setting an effective date of October 1, 2022. Motion made by Director Rose and seconded by Director Carr to adopt Rate Order No. 2022-0921A amending water rates and setting an effective date of October 1, 2022. Motion carried unanimously 6. Consider and act regarding Order No. 2022-0921B, fixing and levying Trophy Club Municipal Utility District No. 1 Debt Service Tax Rate and Operations and Maintenance Tax Rate for 2022 Tax Year. Motion made by Director Rose and seconded by Director Harper to adopt Order No. 2022-0921B fixing and levying Trophy Club Municipal Utility District No. 1 Debt Service tax rate at $0.03115 per $100 of taxable value and Maintenance tax rate at $0.06019 per $100 of taxable value for the 2022 tax year. 33 of 91 October 19, 2022 Complete Agenda Packet Motion by Director Rose and seconded by Director Harper to amend the debt service tax rate to .03115 per $100 of taxable value. Amendment to the motion passed unanimously Main motion as amended Motion carried unanimously 7. Consider and act to regarding adoption of Resolution 2022-0921B approving 2022 Tax Roll for Trophy Club Municipal Utility District No. 1. Motion made by Director Rose and seconded by Director Hunter to approve Resolution 2022-0921B as amended at the dais, approving 2022 tax roll for Trophy Club Municipal Utility District No. 1. The Board of Directors approved a tax rate of $0.09134/$100 assessed value, being imposed on each property included on the certified appraisal rolls for the District for the 2022 tax year, totals $2,041,982 tax levy. The Board hereby declares that the appraisal rolls with amounts of tax entered shall constitute the District's tax roll for the 2022 tax year. Motion carried unanimously 8. Consider and act regarding approval of Amendment to District Information Form, including Notice to Purchaser Form. Motion made by Director Rose and seconded by Director Hunter to approve of Amendment to District Information Form, including Notice to Purchaser Form showing the total Trophy Club Municipal Utility District No. 1 tax levy of $0.09134 per $100 of taxable value. Motion carried unanimously 9. Consider and act regarding annual review of District Investment Policy and Investment Strategies including: a. Adopt Order No. 2022-0921C approving Amended and Restated Investment Policy, including the District's Investment Strategies and Appointment of Investment Officer(s). Motion made by Director Rose and seconded by Director Harper to adopt Order No. 2022-0921C approving Amended and Restated Investment Policy, including the District's Investment Strategies and Appointment of Alan Fourmentin and Steven Krolczyk as Investment Officers. Motion carried unanimously 10. Consider and act to adopt Resolution No. 2022-0921C Approving Cash Reserve Policy. 34 of 91 October 19, 2022 Complete Agenda Packet Motion made by Director Rose and seconded by Director Brewster to adopt Resolution No. 2022-0921C and to transfer $398,822.00 in undesignated reserves to the rehabilitation and replacement reserve fund. Motion carried unanimously 11. Consider and act to approve contract with Four Man Furnace, Inc. for development of a community awareness and communications strategy and to assist the District with respect to preparation of public communications relating to the District and its operations and authorize the General Manager to execute the necessary documents to implement Board action. Motion made by Director Rose and seconded by Director Harper to approve Contract No. 2022-092101 with Four Man Furnace for development of a communications strategy relating to the District's operations and authorize the General Manager to execute the necessary documents to implement Board action. Motion by Director Carr and seconded by Director Rose to amend with a not to exceed amount of $40,000 as shown in the budget. Amendment to the motion For: Carr, Rose, Harper and Brewster Opposed: Hunter Motion to amend passed 4-1 Main Motion as amended For: Carr, Rose, Harper and Brewster Opposed: Hunter Motion passed 4-1 12. Receive update from Strategic Committee. (Carr/Brewster) President Carr stated that the committee agreed to proceed with gathering information as to what the be impact to Trophy Club residents including the PID. The committee will also look at the positive and negative impacts on residents as far as losing revenue. Carr stated it was agreed that the District would have an appraisal on District infrastructure in Westlake. The Board convened into Executive Session at 7:26 p.m. EXECUTIVE SESSION 13. 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 35 of 91 October 19, 2022 Complete Agenda Packet Meetings Act or to seek advice of counsel on legal matters involving pending or contemplated litigation or settlement offers: a. Consult with legal counsel concerning the potential joint strategic planning with the Town of Trophy Club. 14. Deliberations pursuant to Section 551.074(a)(1) of the Texas Open Meetings Act regarding appointment, employment, evaluation, reassignment, duties, discipline, or dismissal of a public officer or employee: General Manager annual performance evaluation. The Board reconvened into Regular Session at 9:46 p.m. REGULAR SESSION 15. Consider and act regarding items discussed in Executive Session. Item 13. a. Direction provided to General Manager Fourmentin to provide data to the town for the town to update the Citizens Advisory Committee report. The new numbers along with potential benefits to customers and schedule strategic committee meeting as necessary to follow up. 16. Items for future agendas: 17. Set future Meeting dates — October 19, 2022 ADJOURN Vice President Brewster called the meeting adjourned at 9:49p.m. Kevin Carr, President Doug Harper, Secretary/Treasurer Laurie Slaght, District Secretary 36 of 91 (SEAL) I WHEN EXPERIENCE, REPUTATION AND PERFORMANCE MATTER PERDUE BRANDON lit FIELDERCOLLINS&MOTT LLP ATTORNEYS AT LAW October 19, 2022 Complete Agenda Packet COLLECTION REPORT TO THE TROPHY CLUB MUNICIPAL UTILITY DISTRICT No. 1 Submitted by: Alison Callison /Andrew Brink 500 East Border Street, Suite 640 Arlington, Texas 76010 www.pbfcm.com October 2022 )13 2021 TAX YEAR ANALYSIS Delinquent Turnover Original Tax Levy Ad j. Delinquent July 1, 2022 Turnover • $2,039,976 41 • $1Z086 • 0.84 • October 19, 2022 Complete Agenda Packet • Collected • Delinquent 99.16% 0.84% Source: Denton County Tax O144f %ar-To-Date Summary Reports. Perdue Brandon Fielder Collins & Mott, LLP October 19, 2022 Complete Agenda Packet 1?3 2021 TAX YEAR — DELINQUENT COLLECTIONS H July 1, 2022 - September 30, 2022 Adj. July 1 Turnover Base Tax Collected Base Tax Remaining • $1Z086 • $14,067 11 • 82.33% • $3,079 1 Base Tax Only - No Penalties or Interest Added $3,019 Collected $14,067 Source: Denton County Tax Office, Year -To -Date Summary Reports.39 of 91 I urnover Accounts for Adjustments and Refunds. Base Taxes Only - No Penalties or Interest Added. Perdue Brandon Fielder Collins & Mott, LLP October 19, 2022 Complete Agenda Packet 18 ACCOUNT BREAKDOWN CHART In Trust, $0.90, 0.0% In Bankruptcy, $656.99, 2.1% Action Pending, AIL$3,121.95, 10.1% In Uncollectable, $1,697.17, 5.5% In Litigation, $3,798.19, 12.3% In Deferral, $21,730.20, 70.1% As of 10/3/2022 -Total Base Tax: $31,005 (2021 Tax Year & Prior) 40of91 Action Pending Accounts: Notification Letters, Telephone Collections, Lienholder Notification, Title Research, Property Inspection and Payment Agreements. Source: Perdue Brandon tape download on 9/13/22 from the Denton County Tax Office. October 19, 2022 Complete Agenda Packet [8 PERDUE BRANDON FIELDERCOLLINS&MATT LLP ATTORNEYS AT LA ATTORNEYS AT LAW AUTHORITY ACTIVITY ANALYSIS TROPHY CLUB MUNICIPAL UTILITY DISTRICT #1 As Of 10/3/2022, Tax Years Between 1997 And 2021 Description # Properties Pct Of Total Base Tax Amount Pct Of Total In Bankruptcy In Trust In Deferral In Litigation In Uncollectable Action Pending Totals 1 2 6 7 24 42 82 1.22% 2.44% 7.32% 8.54% 29.27% 51.22% 100.00% $656.99 $0.90 $21,730.20 $3,798.19 $1,697.17 $3,121.95 $31,005.40 2.12% 0.00% 70.09% 12.25% 5.47% 10.07% 100.00% Dollar Range # Properties Pct Of Total Base Tax Amount Pct Of Total $0.01 - $100.00 $100.01 - $250.00 $250.01 - $500.00 $500.01 - $1000.00 $1000.01 - $2500.00 $2500.01 - $5000.00 $5000.01 - $10,000.00 Totals 55 5 7 3 5 2 1 78 70.51% 6.41% 8.97% 3.85% 6.41% 2.56% 1.28% 100.00% $1,223.58 $748.91 $2,434.95 $2,035.81 $7,619.92 $8,955.03 $7,987.20 $31,005.40 3.95% 2.42% 7.85% 6.57% 24.58% 28.88% 25.76% 100.00% Year # Transaction Pct Of Total Base Tax Amount Pct Of Total 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Totals 1 1 1 1 4 12 8 10 12 12 9 9 12 14 19 39 164 0.61% 0.61% 0.61% 0.61% 2.44% 7.32% 4.88% 6.10% 7.32% 7.32% 5.49% 5.49% 7.32% 8.54% 11.59% 23.78% 100.00% $306.84 $517.32 $530.21 $495.08 $2,874.47 $2,377.37 $1,913.91 $2,077.28 $2,264.16 $1,970.79 $1,956.02 $979.73 $2,188.68 $2,315.40 $3,027.34 $5,210.80 $31,005.40 **Number of properties may differ in the first two sections because a property may reside in more than one category in the first section. 41 of 91 0.99% 1.67% 1.71% 1.60% 9.27% 7.67% 6.17% 6.70% 7.30% 6.36% 6.31% 3.16% 7.06% 7.47% 9.76% 16.81% 100.00% October 19, 2022 Complete Agenda Packet Top Tax Due Report Top 100 Percent Properties - TROPHY CLUB MUNICIPAL UTILITY DISTRICT #1 GEO Code Legal Description 209674DEN THE ESTATES OF HOGANS GLEN PH II BLK 1 LOT 6 ACRES: 0.495700 Taxpayer # Taxpayer Name Years Tax Due Total Due 799 BAKER BOB J 2010-2016 $7,987.20 $13,401.67 72060DEN TROPHY CLUB # 6 LOT 499 ACRES: 0.384000 Taxpayer # Taxpayer Name Years Tax Due Total Due 76 MCDONALD JAMES E & HUESTIS LAURA LEA 2006-2018 $4,508.02 $7,797.24 TR 71012DEN TROPHY CLUB #10 LOT 1219 ACRES: 0.235000 Taxpayer # Taxpayer Name Years Tax Due Total Due 968 BOREN BENJAMIN C & BEVERLY C 2010-2021 $4,447.01 $6,063.97 71779DEN TROPHY CLUB # 2 LOT 77 ACRES: 0.253600 Taxpayer # Taxpayer Name Years Tax Due Total Due 91176 PARROW JAMES J & ELENA 2017-2021 $2,040.02 $2,308.77 72277DEN TROPHY CLUB # 3 LOT 174 ACRES: 0.256100 Taxpayer # Taxpayer Name Years Tax Due Total Due 914 MORTON DENVER & JANIE 2018-2021 $1,526.13 $1,982.58 650109DEN PERSONAL PROPERTY - DENTIST LOCATION: 925 TROPHY CLUB DR TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 90829 MEMBERS ONLY DENTAL PA 2018-2021 $1,476.01 $2,454.48 11514221TAR DIEGO'S TEX MEX KITCHEN PERSONAL PROPERTY TANGIBLE COMMERCIAL Taxpayer # Taxpayer Name Years Tax Due Total Due 59 SUMMERS, JAMES M 2010-2014 $1,355.94 $3,771.70 70173DEN TROPHY CLUB OAK HILL LOT 15 ACRES: 0.164400 Taxpayer # Taxpayer Name Years Tax Due Total Due 91396 RYAN BRUCE E & SHELIA A 2018-2021 $1,221.82 $1,357.23 14692614TAR MAR-COSINA TEX-MEX GOURMET LLC PERSONAL PROPERTY TANGIBLE COMMERCIAL Taxpayer # Taxpayer Name Years Tax Due Total Due 92145 MAR-COSINA TEX-MEX GOURMET LLC 2018-2021 $819.11 $1,280.23 72034DEN TROPHY CLUB # 4 LOT 333 ACRES: 0.361600 Taxpayer # Taxpayer Name Years Tax Due Total Due 1219 BINGHAM GENE C 2020-2021 $656.99 $988.66 975819DEN PERSONAL PROPERTY - LEASED VEHICLES Taxpayer # Taxpayer Name Years Tax Due Total Due 93735 ALLY BANK 2021 $559.71 $812.70 71082DEN TROPHY CLUB #10 LOT 1249 ACRES: 0.286000 Taxpayer # Taxpayer Name Years Tax Due Total Due 93518 CULPEPPER LEE & ADRIANNE BEHR 2021 $476.46 $691.82 526096DEN CHURCHILL DOWNS BLK A LOT 1 ACRES: 0.258300 Taxpayer # Taxpayer Name Years Tax Due Total Due 895 SEAY MARK SR & TERRI 2020 $471.00 $751.72 339971DEN PERSONAL PROPERTY - AIRCRAFT CESSNA 150L 1972-N5428Q LOCATION : NORTHWEST Taxpayer # Taxpayer Name Years Tax Due Total Due 759 MORRISON AVIATION LLC 2011-2021 $310.76 $685.56 620602DEN PERSONAL PROPERTY - DENTIST OFFICE LOCAITON : 301 TROPHY LAKE DR STE 120, Taxpayer # Taxpayer Name Years Tax Due Total Due 1560 BURGAR BRANDON 2013-2014 $310.41 $783.92 926478DEN PERSONAL PROPERTY - CHIROPRACTOR LOCATION : 100 TROPHY CLUB DR. STE 108 TROPHY Taxpayer # Taxpayer Name Years Tax Due Total Due 10/3/2022 1:57:10 PM Page 1 of 5 42 of 91 October 19, 2022 Complete Agenda Packet 1242 FORD LESLIE 2012-2017 $304.07 $699.01 11514205TAR WEINBERGERS DELICATESSEN PERSONAL PROPERTY TANGIBLE COMMERCIAL Taxpayer # Taxpayer Name Years Tax Due Total Due 58 WEINBERGER DELI TWO LLC 2016-2019 $297.12 $565.54 71548DEN TROPHY CLUB VILLAGE WEST SEC B LOT 1020 ACRES: 0.184800 Taxpayer # Taxpayer Name Years Tax Due Total Due 91422 CROY JEFFERY F 2021 $265.13 $384.97 73499DEN THE SUMMIT (TROPHY CLUB) BLK 2 LOT 1 ACRES: 0.120000 Taxpayer # Taxpayer Name Years Tax Due Total Due 90970 STILLWELL TRENTON 2021 $199.00 $288.95 70560DEN LAKE FOREST VILLAGE PH 3 LOT 114 ACRES: 0.374800 Taxpayer # Taxpayer Name Years Tax Due Total Due 139 ANDERSON STEVE 2021 $153.82 $212.27 676474DEN PERSONAL PROPERTY - DRY CLEANERS LOCATION: 2003 SH 114 STE 390 TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 90856 J.A.E.H.K. INC 2018-2021 $139.49 $232.45 748396DEN PERSONAL PROPERTY - RESTAURANT LOCATION: 2550 BOBCAT BLVD STE 108 ROANOKE Taxpayer # Taxpayer Name Years Tax Due Total Due 93608 9 EIGHTEEN FOOD INC 2021 $136.75 $198.56 776375DEN PERSONAL PROPERTY - ACCOUNTING AUDITING & BOOKKEEPING LOCATION : 99 TROPHY Taxpayer # Taxpayer Name Years Tax Due Total Due 92697 KENNETH ARMSTRONG 2020-2021 $119.85 $182.73 676471DEN PERSONAL PROPERTY - DOG TRAINING/RETAIL LOCATION: 2001 SH 114 STE 200 TROPHY Taxpayer # Taxpayer Name Years Tax Due Total Due 90854 HANNICK INC 2020-2021 $97.27 $148.30 42641576TAR KNOLLS AT SOLANA BLOCK B LOT 23 ACRES: 0.247900 Taxpayer # Taxpayer Name Years Tax Due Total Due 93256 MAYA WALDEMAR 2021 $91.87 $133.40 42641584TAR KNOLLS AT SOLANA BLOCK B LOT 24 ACRES: 0.247900 Taxpayer # Taxpayer Name Years Tax Due Total Due 93257 LULLA SONIA AND LULLA RAJIV NAND 2021 $91.87 $133.40 72595DEN TROPHY CLUB # 3 LOT 222 ACRES: 0.252600 Taxpayer # Taxpayer Name Years Tax Due Total Due 1588 BOICE SHON 2021 $88.21 $121.73 14690069TAR THE CELL SPA/MCKENNA ORTHOPEDI PERSONAL PROPERTY TANGIBLE COMMERCIAL Taxpayer # Taxpayer Name Years Tax Due Total Due 92192 MCKENNA OTHOPAEDIC AND SPORT 2021 $87.95 $127.70 MEDICINE PA 469054DEN PERSONAL PROPERTY - RETAIL STORE LOCATION: 301 TROPHY LAKE DR STE 124, TROPHY Taxpayer # Taxpayer Name Years Tax Due Total Due 1184 VERIZON 2011-2013 $82.41 $225.91 42616725TAR WESTLAKE ENTRADA BLOCK C LOT 1B SCHOOL BOUNDARY SPLIT ACRES: 0.197000 Taxpayer # Taxpayer Name Years Tax Due Total Due 92381 AMR WESTLAKE STORAGE LLC 2021 $72.68 $105.53 620585DEN PERSONAL PROPERTY - DAYCARE CENTER LOCATION : 50 VILLAGE TRL TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 90818 NOBEL LEARNING COMMUNITIES INC #1706 2021 $68.43 $99.36 336365DEN PERSONAL PROPERTY - LEASED VEHICLES Taxpayer # Taxpayer Name Years Tax Due Total Due 92366 MOTORLEASE CORPORATION 2020 $58.53 $93.41 336817DEN PERSONAL PROPERTY - DRY CLEANERS DROP OFF LOCATION : 2003 SH 114 STE 390, TROPHY Taxpayer # Taxpayer Name Years Tax Due Total Due 1164 WALJI SHANIF M 2014-2015 $45.93 $109.40 10/3/2022 1:57:10 PM Page 2 of 5 43 of 91 726615DEN Taxpayer # 93837 975792DEN Taxpayer # 93734 14318755TAR Taxpayer # 92920 633172DEN Taxpayer # 1730 70209DEN Taxpayer # 1011 14265180TAR Taxpayer # 91517 563646DEN Taxpayer # 1711 499622DEN Taxpayer # 1530 70450DEN Taxpayer # 93834 723199DEN Taxpayer # 91433 682747DEN Taxpayer # 91619 676479DEN Taxpayer # 90858 953825DEN Taxpayer # 887 13442112TAR Taxpayer # 91068 10374248TAR Taxpayer # 57 11457732TAR Taxpayer # 190 336821DEN Taxpayer # 741 72303DEN Taxpayer # October 19, 2022 Complete Agenda Packet TROPHY CLUB TOWN CENTER ADDITION BLK A LOT 12 ACRES: 0.088700 Taxpayer Name KESHRI BALARAM & AMRITA PERSONAL PROPERTY - LEASED EQUIPMENT Taxpayer Name Years 2021 Years ADT LLC 2021 DYNAMIC ACTION PERSONAL PROPERTY TANGIBLE COMMERCIAL Taxpayer Name Years Tax Due $45.41 Tax Due $41.69 Total Due $64.30 Total Due $60.53 Tax Due Total Due DYNAMIC ACTION INC 2021 $36.66 $53.23 PERSONAL PROPERTY - AUDIOLOGISTS LOCATION: 501 TROPHY LAKE DR, STE 318, TROPHY Taxpayer Name Years Tax Due Total Due EARCARE HEARING AIDS 2014-2015 $35.18 $83.80 TROPHY CLUB #11 LOT 1346 ACRES: 0.486800 Taxpayer Name Years Tax Due Total Due BOCLAIR JOSEPH 2021 $31.62 $45.91 FUSE ENERGY LLC PERSONAL PROPERTY TANGIBLE COMMERCIAL Taxpayer Name Years Tax Due Total Due FUSE ENERGY LLC 2021 $26.93 $39.10 PERSONAL PROPERTY - MISC PERSONAL SERVICE LOCATION: 2003 SH 114 STE 340 TROPHY Taxpayer Name Years Tax Due Total Due STYLES OF INDIA 2015-2016 $20.23 $45.28 PERSONAL PROPERTY - HAIR SALON LOCATION: 2001 W SH 114, STE 150, TROPHY CLUB Taxpayer Name DESIRE SALON & SPA TROPHY CLUB #11 LOT 1402 ACRES: 0.259800 Taxpayer Name Years 2013 Years Tax Due $16.51 Tax Due Total Due $42.99 Total Due SMITH JAMES J & JENNIFER M 2021 $15.18 $21.49 PERSONAL PROPERTY - INSURANCE AGENT LOCATION: 2101 SH 114 STE B TROPHY CLUB Taxpayer Name Years Tax Due Total Due MILLER CRAIG 2019-2021 $14.45 $23.10 PERSONAL PROPERTY - RESTAURANT LOCATION: 301 TROPHY LAKE DR STE 116 TROPHY Taxpayer Name Years Tax Due Total Due 7 MILES TASTE GROUP INC 2019 $14.43 $25.11 PERSONAL PROPERTY - DANCE & MUSIC LESSONS LOCATION: 905 TROPHY CLUB DR STE 204 Taxpayer Name Years Tax Due FULLER CHRISTINA 2020-2021 $14.38 PERSONAL PROPERTY - SALON & SPA LOCATION: 2001 SH114 # 120 TROPHY CLUB Taxpayer Name Years Tax Due TONY CAO SALON & SPA 2011 $13.48 HEART TEST LABORATORIES PERSONAL PROPERTY TANGIBLE COMMERCIAL Years Tax Due Total Due $21.92 Total Due $38.98 Taxpayer Name Total Due HEART TEST LABORATORIES INC 2017-2019 $12.32 $22.35 BUSINESS PERSONAL PROPERTY Taxpayer Name Years Tax Due Total Due J P TALBOT INSURANCE 2011 $11.96 $34.59 BUSINESS PERSONAL PROPERTY THOMAS PART *RVN10/7/08 PRNL OFF. BIZ LOCA 9 PER PH Taxpayer Name WHITTON CONSTRUCTION INC PERSONAL PROPERTY - OFFICE LOCATION Taxpayer Name MIJOL REALTY.COM TROPHY CLUB # 6 LOT 528 ACRES: 0.266100 Taxpayer Name Years Tax Due Total Due 2011 $11.56 $33.43 : 100 INDIAN CREEK DR STE 120, ROANOKE Years 2011 Years Tax Due $9.63 Tax Due Total Due $27.85 Total Due 10/3/2022 1:57:10 PM Page 3 of 5 44 of 91 October 19, 2022 Complete Agenda Packet 91664 TABER JOHN K 2020 $9.15 $13.94 198411DEN LAKES OF TROPHY CLUB PH 1 BLK 3 LOT 17 ACRES: 0.342900 Taxpayer # Taxpayer Name Years Tax Due Total Due 93826 SNOW-HILL DONNA SUE 2021 $8.69 $12.31 71493DEN TROPHY CLUB VILLAGE WEST SEC B LOT 993 ACRES: 0.199400 Taxpayer # Taxpayer Name Years Tax Due Total Due 93847 POOL TURNER 2021 $7.69 $10.70 676473DEN PERSONAL PROPERTY - PERSONAL TRAINER SERVICES LOCATION: 2003 SH 114 STE 90 Taxpayer # Taxpayer Name Years Tax Due Total Due 90855 THE FORCE BY LUKE 2021 $5.98 $8.68 659388DEN PERSONAL PROPERTY - BUSINESS SERVICES LOCATION: 99 TROPHY CLUB DR TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 91141 CHIP MUNDY INC 2017 $4.85 $9.84 566115DEN PERSONAL PROPERTY - BUSINESS SERVICES LOCATION: 99 TROPHY CLUB DR, TROPHY Taxpayer # Taxpayer Name Years Tax Due Total Due 1555 DONNA & ASSOCIATES 2013 $4.40 $11.46 679913DEN PERSONAL PROPERTY - OFFICE LOCATION: 99 TROPHY CLUB DR TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 91389 SMITH CLINICAL SERVICES PLLC 2019 $4.31 $7.50 659398DEN PERSONAL PROPERTY - BUSINESS SERVICES LOCATION: 99 TROPHY CLUB DR, TROPHY Taxpayer # Taxpayer Name Years Tax Due Total Due 90372 RAY DERSTEIN 2015 $3.61 $8.36 701746DEN PERSONAL PROPERTY - OFFICE LOCATION: 99 TROPHY CLUB DR TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 93483 GRAY CAROL 2021 $3.50 $5.08 13730967TAR RANDSTAD RANDSTAD US LP PERSONAL PROPERTY TANGIBLE COMMERCIAL Taxpayer # Taxpayer Name Years Tax Due Total Due 90303 RANDSTAD US LP 2014-2015 $2.76 $6.46 925240DEN PERSONAL PROPERTY - LEGAL SERVICE LOCATION : 100 INDIAN CREEK, TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 875 CHRISTLIEB LAW OFFICE 2011 $2.54 $7.35 727270DEN PERSONAL PROPERTY - INSURANCE OFFICE LOCATION: 100 INDIAN CREEK DR STE 110 Taxpayer # Taxpayer Name Years Tax Due Total Due 92609 FOLEY BEVERLY 2020-2021 $1.98 $3.02 943642DEN PERSONAL PROPERTY - BUSINESS SVCS LOCATION: 100 INDIAN CREEK TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 91198 ERIC RANSLEBEN 2021 $1.86 $2.70 14658688TAR DXC TECHNOLOGY SERVICES LLC VARX COMMERCIAL Taxpayer # Taxpayer Name Years Tax Due Total Due 93824 DXC TECHNOLOGY SERVICES LLC 2021 $1.77 $2.51 335713DEN PERSONAL PROPERTY - OFFICE LOCATION: 99 TROPHY CLUB DR, TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 1329 HELM INSURANCE AGENCY 2012 $0.87 $2.39 314763DEN PERSONAL PROPERTY - LEASED EQUIPMENT Taxpayer # Taxpayer Name Years Tax Due Total Due 298 NORTHERN LEASING SYSTEMS INC 2020 $0.68 $1.09 14461451 TAR DELL MARKETING LP VARX COMMERCIAL Taxpayer # Taxpayer Name Years Tax Due Total Due 91207 DELL MARKETING LP 2016 $0.61 $1.23 624324DEN A0821A J.R. MICHAEL TR 1A(2) .09 ACRES ACRES: 0.090000 Taxpayer # Taxpayer Name Years Tax Due Total Due 1628 TROPHY CLUB TOWN OF 2014 S0.48 $1.18 624325DEN A0821A J.R. MICHAEL TR 1A(3) .081 ACRES ACRES: 0.081000 10/3/2022 1:57:10 PM Page 4 of 5 45 of 91 October 19, 2022 Complete Agenda Packet Taxpayer # Taxpayer Name Years Tax Due Total Due 1628 TROPHY CLUB TOWN OF 2014 $0.42 $1.03 42345560TAR WESTLAKE ENTRADA BLOCK I LOT 13 REF PLAT D218192054 Taxpayer # Taxpayer Name Years Tax Due Total Due 91351 JJP TREVI LLC 2018 $0.19 $0.36 14381350TAR SONIFI SOLUTIONS INC VARX COMMERCIAL Taxpayer # Taxpayer Name Years Tax Due Total Due 1290 SONIFI SOLUTIONS INC 2015 $0.15 $0.31 14479384TAR RS WATER HOLDING LLC VARX COMMERCIAL Taxpayer # Taxpayer Name Years Tax Due Total Due 354 RS WATER HOLDING LLC 2016 $0.09 $0.19 335711DEN PERSONAL PROPERTY - OFFICE LOCATION: 99 TROPHY CLUB DR, TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 1163 FULL CIRCLE LOGISTICS 2011 $0.07 $0.20 13661787TAR NATIONAL DEFAULT TITLE PERSONAL PROPERTY TANGIBLE COMMERCIAL Taxpayer # Taxpayer Name Years Tax Due Total Due 1638 NATIONAL DEFAULT TITLE SERVICE 2017 $0.07 $0.14 14448870TAR NEOPOST USA INC VARX COMMERCIAL Taxpayer # Taxpayer Name Years Tax Due Total Due 91049 NEOPOST USA INC 2015 $0.04 $0.08 71098DEN TROPHY CLUB # 8 LOT 644 ACRES: 0.202400 Taxpayer # Taxpayer Name Years Tax Due Total Due 90923 KIRKPATRICK GINGER G 2021 $0.03 $0.04 198454DEN LAKES OF TROPHY CLUB PH 1 BLK 5 LOT 11 ACRES: 0.160300 Taxpayer # Taxpayer Name Years Tax Due Total Due 91092 VILORIA PHILIP A & JOANNE 2019 $0.01 $0.02 308380DEN EAGLES RIDGE PH II BLK B LOT 5 ACRES: 0.305700 Taxpayer # Taxpayer Name Years Tax Due Total Due 91720 HAFIZ ARIF & FATIMA LIVING TRUST 2020 $0.01 $0.02 Total Tax Due $31,005.40 10/3/2022 1:57:10 PM Page 5 of 5 46 of 91 October 19, 2022 Complete Agenda Packet Top Tax Due Report Top 100 Percent Properties - TROPHY CLUB MUNICIPAL UTILITY DISTRICT #1 GEO Code Legal Description 975819DEN PERSONAL PROPERTY - LEASED VEHICLES Taxpayer # Taxpayer Name Years Tax Due Total Due 93735 ALLY BANK 2021 $559.71 $812.70 71082DEN TROPHY CLUB #10 LOT 1249 ACRES: 0.286000 Taxpayer # Taxpayer Name Years Tax Due Total Due 93518 CULPEPPER LEE & ADRIANNE BEHR 2021 $476.46 $691.82 71012DEN TROPHY CLUB #10 LOT 1219 ACRES: 0.235000 Taxpayer # Taxpayer Name Years Tax Due Total Due 968 BOREN BENJAMIN C & BEVERLY C 2021 $437.04 $451.59 71779DEN TROPHY CLUB # 2 LOT 77 ACRES: 0.253600 Taxpayer # Taxpayer Name Years Tax Due Total Due 91176 PARROW JAMES J & ELENA 2021 $421.13 $435.15 72034DEN TROPHY CLUB # 4 LOT 333 ACRES: 0.361600 Taxpayer # Taxpayer Name Years Tax Due Total Due 1219 BINGHAM GENE C 2021 $415.95 $603.96 72277DEN TROPHY CLUB # 3 LOT 174 ACRES: 0.256100 Taxpayer # Taxpayer Name Years Tax Due Total Due 914 MORTON DENVER & JANIE 2021 $387.05 $399.94 650109DEN PERSONAL PROPERTY - DENTIST LOCATION: 925 TROPHY CLUB DR TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 90829 MEMBERS ONLY DENTAL PA 2021 $371.50 $539.42 70173DEN TROPHY CLUB OAK HILL LOT 15 ACRES: 0.164400 Taxpayer # Taxpayer Name Years Tax Due Total Due 91396 RYAN BRUCE E & SHELIA A 2021 $291.17 $300.87 71548DEN TROPHY CLUB VILLAGE WEST SEC B LOT 1020 ACRES: 0.184800 Taxpayer # Taxpayer Name Years Tax Due Total Due 91422 CROY JEFFERY F 2021 $265.13 $384.97 73499DEN THE SUMMIT (TROPHY CLUB) BLK 2 LOT 1 ACRES: 0.120000 Taxpayer # Taxpayer Name Years Tax Due Total Due 90970 STILLWELL TRENTON 2021 $199.00 $288.95 14692614TAR MAR-COSINA TEX-MEX GOURMET LLC PERSONAL PROPERTY TANGIBLE COMMERCIAL Taxpayer # Taxpayer Name Years Tax Due Total Due 92145 MAR-COSINA TEX-MEX GOURMET LLC 2021 $187.95 $272.90 70560DEN LAKE FOREST VILLAGE PH 3 LOT 114 ACRES: 0.374800 Taxpayer # Taxpayer Name Years Tax Due Total Due 139 ANDERSON STEVE 2021 $153.82 $212.27 748396DEN PERSONAL PROPERTY - RESTAURANT LOCATION: 2550 BOBCAT BLVD STE 108 ROANOKE Taxpayer # Taxpayer Name Years Tax Due Total Due 93608 9 EIGHTEEN FOOD INC 2021 $136.75 $198.56 42641576TAR KNOLLS AT SOLANA BLOCK B LOT 23 ACRES: 0.247900 Taxpayer # Taxpayer Name Years Tax Due Total Due 93256 MAYA WALDEMAR 2021 $91.87 $133.40 42641584TAR KNOLLS AT SOLANA BLOCK B LOT 24 ACRES: 0.247900 Taxpayer # Taxpayer Name Years Tax Due Total Due 93257 LULLA SONIA AND LULLA RAJIV NAND 2021 $91.87 $133.40 72595DEN TROPHY CLUB # 3 LOT 222 ACRES: 0.252600 Taxpayer # Taxpayer Name Years Tax Due Total Due 1588 BOICE SHON 2021 $88.21 $121.73 10/3/2022 1:55:36 PM Page 1 of 3 47 of 91 October 19, 2022 Complete Agenda Packet 14690069TAR THE CELL SPA/MCKENNA ORTHOPEDI PERSONAL PROPERTY TANGIBLE COMMERCIAL Taxpayer # Taxpayer Name Years Tax Due Total Due 92192 MCKENNA OTHOPAEDIC AND SPORT 2021 $87.95 $127.70 MEDICINE PA 42616725TAR WESTLAKE ENTRADA BLOCK C LOT 1B SCHOOL BOUNDARY SPLIT ACRES: 0.197000 Taxpayer # Taxpayer Name Years Tax Due Total Due 92381 AMR WESTLAKE STORAGE LLC 2021 $72.68 $105.53 620585DEN PERSONAL PROPERTY - DAYCARE CENTER LOCATION : 50 VILLAGE TRL TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 90818 NOBEL LEARNING COMMUNITIES INC #1706 2021 $68.43 $99.36 776375DEN PERSONAL PROPERTY - ACCOUNTING AUDITING & BOOKKEEPING LOCATION : 99 TROPHY Taxpayer # Taxpayer Name Years Tax Due Total Due 92697 KENNETH ARMSTRONG 2021 $59.40 $86.25 676471DEN PERSONAL PROPERTY - DOG TRAINING/RETAIL LOCATION: 2001 SH 114 STE 200 TROPHY Taxpayer # Taxpayer Name Years Tax Due Total Due 90854 HANNICK INC 2021 $48.21 $70.00 726615DEN TROPHY CLUB TOWN CENTER ADDITION BLK A LOT 12 ACRES: 0.088700 Taxpayer # Taxpayer Name Years Tax Due Total Due 93837 KESHRI BALARAM & AMRITA 2021 $45.41 $64.30 975792DEN PERSONAL PROPERTY - LEASED EQUIPMENT Taxpayer # Taxpayer Name Years Tax Due Total Due 93734 ADT LLC 2021 $41.69 $60.53 14318755TAR DYNAMIC ACTION PERSONAL PROPERTY TANGIBLE COMMERCIAL Taxpayer # Taxpayer Name Years Tax Due Total Due 92920 DYNAMIC ACTION INC 2021 $36.66 $53.23 676474DEN PERSONAL PROPERTY - DRY CLEANERS LOCATION: 2003 SH 114 STE 390 TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 90856 J.A.E.H.K. INC 2021 $34.55 $50.17 70209DEN TROPHY CLUB #11 LOT 1346 ACRES: 0.486800 Taxpayer # Taxpayer Name Years Tax Due Total Due 1011 BOCLAIR JOSEPH 2021 $31.62 $45.91 14265180TAR FUSE ENERGY LLC PERSONAL PROPERTY TANGIBLE COMMERCIAL Taxpayer # Taxpayer Name Years Tax Due Total Due 91517 FUSE ENERGY LLC 2021 $26.93 $39.10 339971DEN PERSONAL PROPERTY - AIRCRAFT CESSNA 150L 1972-N5428Q LOCATION : NORTHWEST Taxpayer # Taxpayer Name Years Tax Due Total Due 759 MORRISON AVIATION LLC 2021 $25.16 $36.53 70450DEN TROPHY CLUB #11 LOT 1402 ACRES: 0.259800 Taxpayer # Taxpayer Name Years Tax Due Total Due 93834 SMITH JAMES J & JENNIFER M 2021 $15.18 $21.49 198411DEN LAKES OF TROPHY CLUB PH 1 BLK 3 LOT 17 ACRES: 0.342900 Taxpayer # Taxpayer Name Years Tax Due Total Due 93826 SNOW -HILL DONNA SUE 2021 $8.69 $12.31 71493DEN TROPHY CLUB VILLAGE WEST SEC B LOT 993 ACRES: 0.199400 Taxpayer # Taxpayer Name Years Tax Due Total Due 93847 POOL TURNER 2021 $7.69 $10.70 676479DEN PERSONAL PROPERTY - DANCE & MUSIC LESSONS LOCATION: 905 TROPHY CLUB DR STE 204 Taxpayer # Taxpayer Name Years Tax Due Total Due 90858 FULLER CHRISTINA 2021 $7.13 $10.35 676473DEN PERSONAL PROPERTY - PERSONAL TRAINER SERVICES LOCATION: 2003 SH 114 STE 90 Taxpayer # Taxpayer Name Years Tax Due Total Due 90855 THE FORCE BY LUKE 2021 $5.98 $8.68 10/3/2022 1:55:36 PM Page 2 of 3 48 of 91 October 19, 2022 Complete Agenda Packet 723199DEN PERSONAL PROPERTY - INSURANCE AGENT LOCATION: 2101 SH 114 STE B TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 91433 MILLER CRAIG 2021 $4.69 $6.81 701746DEN PERSONAL PROPERTY - OFFICE LOCATION: 99 TROPHY CLUB DR TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 93483 GRAY CAROL 2021 $3.50 $5.08 943642DEN PERSONAL PROPERTY - BUSINESS SVCS LOCATION: 100 INDIAN CREEK TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 91198 ERIC RANSLEBEN 2021 $1.86 $2.70 14658688TAR DXC TECHNOLOGY SERVICES LLC VARX COMMERCIAL Taxpayer # Taxpayer Name Years Tax Due Total Due 93824 DXC TECHNOLOGY SERVICES LLC 2021 $1.77 $2.51 727270DEN PERSONAL PROPERTY - INSURANCE OFFICE LOCATION: 100 INDIAN CREEK DR STE 110 Taxpayer # Taxpayer Name Years Tax Due Total Due 92609 FOLEY BEVERLY 2021 $0.98 $1.42 71098DEN TROPHY CLUB # 8 LOT 644 ACRES: 0.202400 Taxpayer # Taxpayer Name Years Tax Due Total Due 90923 KIRKPATRICK GINGER G 2021 $0.03 $0.04 Total Tax Due $5,210.80 10/3/2022 1:55:36 PM Page 3 of 3 49 of 91 Deferral Detail Report Locator: Denton Tax Clients: Trophy Club MUD 1 TP # Taxpayer Name 799 BAKER BOB J GEO Code 209674DEN 209674DEN 209674DEN 209674DEN 209674DEN 209674DEN 209674DEN Client Name Trophy Club MUD 1 Trophy Club MUD 1 Trophy Club MUD 1 Trophy Club MUD 1 Trophy Club MUD 1 Trophy Club MUD 1 Trophy Club MUD 1 91396 RYAN BRUCE E & SHELIA A GEO Code Client Name 70173DEN 70173DEN 70173DEN 70173DEN Trophy Club MUD 1 Trophy Club MUD 1 Trophy Club MUD 1 Trophy Club MUD 1 968 BOREN BENJAMIN C & BEVERLY C GEO Code Client Name 71012DEN 71012DEN 71012DEN 71012DEN 71012DEN 71012DEN 71012DEN 71012DEN 71012DEN 71012DEN 71012DEN 71012DEN Trophy Club MUD 1 Trophy Club MUD 1 Trophy Club MUD 1 Trophy Club MUD 1 Trophy Club MUD 1 Trophy Club MUD 1 Trophy Club MUD 1 Trophy Club MUD 1 Trophy Club MUD 1 Trophy Club MUD 1 Trophy Club MUD 1 Trophy Club MUD 1 91176 PARROW JAMES J & ELENA GEO Code Client Name 71779DEN 71779DEN 71779DEN 71779DEN 71779DEN Trophy Club MUD 1 Trophy Club MUD 1 Trophy Club MUD 1 Trophy Club MUD 1 Trophy Club MUD 1 76 MCDONALD JAMES E & HUESTIS LAURA LEA TR GEO Code Client Name 72060DEN Trophy Club MUD 1 72060DEN Trophy Club MUD 1 72060DEN Trophy Club MUD 1 72060DEN Trophy Club MUD 1 72060DEN Trophy Club MUD 1 72060DEN Trophy Club MUD 1 72060DEN Trophy Club MUD 1 72060DEN Trophy Club MUD 1 72060DEN Trophy Club MUD 1 72060DEN Trophy Club MUD 1 72060DEN Trophy Club MUD 1 72060DEN Trophy Club MUD 1 72060DEN Trophy Club MUD 1 914 MORTON DENVER & JANIE GEO Code Client Name 72277DEN 72277DEN 72277DEN 72277DEN 10/3/2022 1:52:06 PM Trophy Club MUD 1 Trophy Club MUD 1 Trophy Club MUD 1 Trophy Club MUD 1 Uctober 19, 2022 Complete Agenda Packet Tax Year Status Tran Type Start Date End Date Condition 2010 DEFE TAX 07/08/2011 2011 DEFE TAX 07/08/2011 2012 DEFE TAX 07/08/2011 2013 DEFE TAX 07/08/2011 2014 DEFE TAX 07/08/2011 2015 DEFE TAX 07/08/2011 2016 DEFE TAX 07/08/2011 12/01/2099 12/01/2099 12/01/2099 12/01/2099 12/01/2099 12/01/2099 12/01/2099 pre Defer Defer Defer Defer Defer Defer Property Base Due Taxpayer Base Due Tax Year Status Tran Type Start Date End Date Condition 2018 DEFE TAX 10/23/2018 2019 DEFE TAX 10/23/2018 2020 DEFE TAX 10/23/2018 2021 DEFE TAX 10/23/2018 12/01/2099 12/01/2099 12/01/2099 12/01/2099 Defer Defer Defer Defer Property Base Due Taxpayer Base Due Tax Year Status Tran Type Start Date End Date Condition 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 DEFE DEFE DEFE DEFE DEFE DEFE DEFE DEFE DEFE DEFE DEFE DEFE TAX TAX TAX TAX TAX TAX TAX TAX TAX TAX TAX TAX 06/30/2010 06/30/2010 06/30/2010 06/30/2010 06/30/2010 06/30/2010 06/30/2010 06/30/2010 06/30/2010 06/30/2010 06/30/2010 06/30/2010 12/01/2099 12/01/2099 12/01/2099 12/01/2099 12/01/2099 12/01/2099 12/01/2099 12/01/2099 12/01/2099 12/01/2099 12/01/2099 12/01/2099 Defer Defer Defer Defer Defer Defer Defer Defer Defer Defer Defer Defer Property Base Due Taxpayer Base Due Tax Year Status Tran Type Start Date End Date Condition 2017 2018 2019 2020 2021 DEFE DEFE DEFE DEFE DEFE TAX TAX TAX TAX TAX 11/03/2017 11/03/2017 11/03/2017 11/03/2017 11/03/2017 12/01/2099 12/01/2099 12/01/2099 12/01/2099 12/01/2099 Defer Defer Defer Defer Defer Property Base Due Taxpayer Base Due Tax Year Status Tran Type Start Date End Date Condition 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 DEFE DEFE DEFE DEFE DEFE DEFE DEFE DEFE DEFE DEFE DEFE DEFE DEFE TAX TAX TAX TAX TAX TAX TAX TAX TAX TAX TAX TAX TAX 01/25/2007 01/25/2007 01/25/2007 01/25/2007 01/25/2007 01/25/2007 01/25/2007 01/25/2007 01/25/2007 01/25/2007 01/25/2007 01/25/2007 01/25/2007 12/01/2099 12/01/2099 12/01/2099 12/01/2099 12/01/2099 12/01/2099 12/01/2099 12/01/2099 12/01/2099 12/01/2099 12/01/2099 12/01/2099 12/01/2099 pre Defer Defer Defer Defer Defer Defer Defer Defer Defer Defer Defer Defer Property Base Due Taxpayer Base Due Tax Year Status Tran Type Start Date End Date Condition 2018 DEFE TAX 03/24/2020 2019 DEFE TAX 03/24/2020 2020 DEFE TAX 03/24/2020 2021 DEFE TAX 03/24/2020 50 of 91 12/01/2099 12/01/2099 12/01/2099 12/01/2099 pre pre Defer Defer Property Base Due Taxpayer Base Due Total Base Due Base Due Base Tax $1,650.27 $1,172.50 $986.42 $959.74 $1,059.05 $1,089.73 $1,069.49 $7,987.20 $7,987.20 Base Tax $329.43 $304.93 $296.29 $291.17 $1,221.82 $1,221.82 Base Tax $414.60 $378.65 $295.79 $300.56 $325.30 $355.07 $367.89 $385.38 $380.30 $404.59 $401.84 $437.04 $4,447.01 $4,447.01 Base Tax $385.31 $412.53 $416.50 $404.55 $421.13 $2,040.02 $2,040.02 Base Tax $306.84 $517.32 $530.21 $495.08 $460.80 $405.50 $329.59 $331.12 $346.81 $378.34 $400.74 $5.37 $0.30 $4,508.02 $4,508.02 Base Tax $340.65 $404.44 $393.99 $387.05 $1,526.13 $1,526.13 $21,730.20 Page 1 of 1 Restricted/ Unrestricted Unrestricted- 135 Unrestricted- 122 Restricted- 533 Unrestricted- 135 Restricted- 122 Restricted- 137 Restricted- 533 Restricted- 534 Restricted- 528 Restricted- 519 Restricted- 535 Restricted- 520 Restricted- 536 Restricted Restricted- 519 Restricted- 520 EARNINGS SUMMARY 1 Restricted/ Unrestricted Unrestricted- 135 Unrestricted- 122 Restricted- 533 Unrestricted Restricted- 533 Restricted- 534 Restricted- 528 Restricted- 519 Restricted- 535 Restricted- 520 Restricted- 536 Restricted Restricted- 519 Trophy Club Municipal Utility District No. 1 Quarterly Investment Report Account or CUSIP Checkin¢ & Money Market Accounts XXX8701 XXX8701 XXX8701 Pools & Funds XXXXX0002 XXXXX0003 XXXXX00013 XXXXX00014 XXXXX00015 XXXXX00017 XXXXX00018 XXXXX00020 Savinus Accounts XXXXX7724 Escrow/ Treasuries 82-1747-01-1 82-3288-01-4 CD'S US Agencies NONE NONE Settle Date Checking & Money Market Accounts Pools & Funds Savings Accounts Escrows/ Treasuries CD'S NONE US Agencies NONE For Ending Period 9/30/2022 (July, August, and September) Sec Rate / T pe Par Coulon Prosperity Bank Consolidated Cash -General Fund Prosperity Bank Consolidated Cash -Fire Dept Prosperity Bank Consolidated Cash -Tax I&S TexPool Municipal Fund -Operating TexPool Municipal Fund -Fire Dept TexPool Municipal Fund -GASB Replacement TexPool Tax Debt Service Texpool Revenue Bond I&S Texpool Revenue Bond Reserve Texpool Revenue Bond Construction -SWIFT Texpool Revenue Bond I&S-SWIFT Texpool Revenue Bond Construction Series 2019 Texpool Revenue Bond I&S Series 2019 Prosperity Bank Cash Reserve- Money Mkt Revenue Bond Series 2016 Escrow- BOK Revenue Bond Series 2019 Escrow- BOK Sec Type Prosperity Bank Consolidated Cash -General Fund Prosperity Bank Consolidated Cash -Fire Dept Prosperity Bank Consolidated Cash -Tax I&S TexPool Municipal Fund TexPool Tax Debt Service Texpool Revenue Bond I&S Texpool Revenue Bond Reserve Texpool Revenue Bond Construction -SWIFT Texpool Revenue Bond I&S-SWIFT Texpool Revenue Bond Construction Series 2019 Texpool Revenue Bond I&S Series 2019 Prosperity Bank Cash Reserve- Money Mkt Revenue Bond Series 2016 Escrow- BOK PAR for this report is the statement balance on the last day of the quarter $ 4,516,399 3,782,898 675,927 2,985,575 51,961 27,958 900,604 6,555 1,497,693 1,429 $ 1,882,637 $ 787,221 $ 17,116,857 Account Number XXX8701 XXX8701 XXX8701 XXXXX0002 XXXXX0003 XXXXX00013 XXXXX00014 XXXXX00015 XXXXX00017 XXXXX00018 XXXXX00020 XXXXX7724 $ 82-1747-01-1 $ Call Maturi Date 0.000% N/A N/A 0.000% N/A N/A 0.000% N/A N/A 0.000% N/A N/A 0.000% N/A N/A 0.000% N/A N/A 0.000% N/A N/A 0.000% N/A N/A 0.000% N/A N/A 0.000% N/A N/A 0.000% N/A N/A 0.000% N/A N/A 0.000% N/A N/A 0.000% N/A N/A Par Coupon Maturity 4,516,399 N/A N/A N/A N/A N/A N/A 7,444,400 N/A N/A 51,961 N/A N/A 27,958 N/A N/A 900,604 N/A N/A N/A N/A 6,555 N/A N/A 1,497,693 N/A N/A 1,429 N/A N/A 1,882,637 N/A N/A 787,221 N/A N/A 51 of 91 Purchase Price 100.000 100.000 100.000 100.000 100.000 100.000 100.000 100.000 100.000 100.000 100.000 100.000 100.000 100.000 Qtr. Accrued $ 3,789 $ 34,072 $ 2,699 $ 1,307 $ 4,588 $ 612 $ 8,724 $ 608 $ 2,581 $ 2,080 $ 61,060 Yield % Prep Investm October 19, 2022 Complete Agenda Packet I certify that this Investment Report complies with requirements of TCMUD's Investment Policy and the Public Funds Act. ared By Steven Krolczyk ent Officer Alan Fourmentin Beginning Book 6/30/2022 Beginning Market 6/30/2022 0.26% $ 4,974,957 $ 0.26% $ $ 0.26% $ $ 2.85% $ 2,997,926 $ 2.85% $ 891,450 $ 2.85% $ 2,985,575 $ 2.85% $ 942,998 $ 2.85% $ 423,463 $ 2.85% $ 896,017 $ 2.85% $ - $ 2.85% $ 204,195 $ 2.85% $ 1,832,325 $ 2.85% $ 201,519 $ Ending Book 9/30/2022 DATE DATE Ending Market 9/30/2022 Gain/Loss End MV -End BV 4,974,957 $ 4,516,399 $ 4,516,399 0.00 $ $ 0.00 $ $ 0.00 2,997,926 $ 3,782,898 $ 3,782,898 0.00 891,450 $ 675,927 $ 675,927 0.00 2,985,575 $ 2,985,575 $ 2,985,575 0.00 942,998 $ 51,961 $ 51,961 0.00 423,463 $ 27,958 $ 27,958 0.00 896,017 $ 900,604 $ 900,604 0.00 - $ - $ - 0.00 204,195 $ 6,555 $ 6,555 0.00 1,832,325 $ 1,497,693 $ 1,497,693 0.00 201,519 $ 1,429 $ 1,429 0.00 0.76% $ 1,481,234 $ 1,481,234 $ 1,882,637 $ 1,882,637 0.00 2.35% $ 785,141 $ 2.35% $ - $ 785,141 $ 787,221 $ 787,221 0.00 $ $ 0.00 $ 18,616,800 $ 18,616,800 $ 17,116,857 $ 17,116,857 $ Qtr. Amort. Total Qtr. Earnings N/A $ 3,789 N/A $ - N/A $ - N/A $ 34,072 N/A $ 2,699 N/A $ 1,307 N/A $ 4,588 NA $ - NA $ 612 NA $ 8,724 NA $ 608 N/A $ 2,581 N/A $ 2,080 N/A $ 61,060 15,1 TROPHY CLUB MUNICIPAL UTILITY DISTRICT STAFF REPORT October 19, 2022 October 19, 2022 Complete Agenda Packet AGENDA ITEM: Consider and act regarding approval of Work Order #2 with Pipeline Analysis, LLC for professional engineering services related to the District wastewater collection system. DESCRIPTION: The District wastewater collection system has been divided into multiple study areas to be performed over an eleven year period. This will be the third year of condition assessment efforts, which also coincide with the sanitary sewer overflow initiative (SSOI) executed with the Texas Commission on Environmental Quality (TCEQ) in September 2021 and expires September 2032. This work order includes smoke testing, cleaning, and CCTV of approximately 47,800 linear feet of pipe and inspection of approximately 183 manholes. Upon completion of this work order and subsequent years of studies, the results will assist in determining annual capital improvement funding, long-term asset management needs, implementation with our computerized maintenance management system (CMMS), further refinement of the geographic information system (GIS), and provide the necessary data needed for annual reporting to TCEQ. ATTACHMENT: Work Order No. 2 RECOMMENDATION: Staff recommends the Board of Directors approve the work order agreement with Pipeline Analysis, LLC for professional engineering services related to the district wastewater collection system at a total cost not to exceed $217,363.50 and authorize the General Manager to execute the necessary documents. 52 of 91 October 19, 2022 Complete Agenda Packet Sanitary Sewer Condition Assessment and Infiltration/Inflow Reduction Program Work Order No.2 Alan Fourmentin General manager afourrnentint11tcrnud.ar r July 6, 2022 PIPELINE ANALYSIS" WASTEWATER COLLECTION ENGINEERS PIPELINE ANALYSIS LLC 1115 Main Street Garland, Texas 75040 800-637-0164 53 of 91 October 19, 2022 Complete Agenda Packet WORK ORDER NO.2 SCOPE OF SERVICES PURPOSE The purpose of this project is to perform the Year 3 phased systematic condition assessment of the District wastewater collection system to identity system defects that contribute to wet weather infiltration/inflow. Best management practice is to perform a condition assessment of the wastewater collection system assets followed by repairs and rehabilitation. Such inspections and testing will identify system defects that, if repaired early, will minimize rehabilitation costs, and extend the life of system assets. All work will follow the Pipeline Analysis LLC Master Service Agreement Contract No. 2021101801. This work will comply with sections of the TCEQ SSO Initiative agreement entered into on September 27, 2021. The District wastewater collection system consists of approximately 371,320 linear feet of mainline sewer and 1,600 manholes. Exhibit A presents the estimated cost for Work Order 2. The following summarizes the project tasks and approach to this phased project: Work Tasks TASK 100 MOBILIZATION Mobilize project team and coordinate startup. Establish personnel assignments and responsibilities. Inventory equipment needs and order expendable supplies. Review all relevant existing materials, previous reports, etc. developed for or by the District concerning this project, including, but not limited to, the following: 1. Previous studies for the service areas to be investigated 2. Sewer maps Deliverable: 1. Delivery of equipment and personnel 2. Work maps of Basin with delineated boundaries To Be Provided by the District: • Access for placement of equipment and personnel • Copies of all applicable reports, maps and historical data for the study area at no cost to ENGINEER • As -built drawings, sewer key maps, street plans, electronic aerial photographs if available and if requested at no cost to ENGINEER 54 of 91 October 19, 2022 Complete Agenda Packet TASK 200 MANHOLE/PIPE INSPECTION The existing GIS maps will be used and updated during the course of field inspections. Field verification of the map will be necessary to resolve flow directions, "race track" connections, split flow locations, and identify assets not shown on the existing sewer maps. The updated maps will be used for subsequent field testing and inspections. Work Order 2 includes the inspection and map update of Basin 14 consisting of approximately 183 manholes and 47,800 linear feet of mainline sewer. Manholes can be a significant source of extraneous infiltration/inflow and thereby reduce system wet weather capacity. For this reason, each manhole within the District will be inspected and undergo a condition assessment. The data gathered during this phase of the project will be used to prioritize manholes for rehabilitation and establish the base data necessary to accurately determine mainline sewer rehabilitation alternatives and costs. Other important deliverables resulting from this work task are the updating of the collection system map, determination of debris levels in pipes and verification of pipe sizes. This information is critical in preparing subsequent rehabilitation plans, cleaning requirements to restore capacity and updating of the system maps. Inspection personnel will use digital cameras during the inspection of all manholes on this project. All photographs will be included in the field inspection computer database so that a permanent electronic record can be maintained. During inspection, each of the following types of information will be obtained to establish the condition and prioritize least cost repairs: 1. Manhole/Cleanout ID 2. Inspection Status — (including buried, could not locate, etc) 3. Address and GPS coordinates (sub -meter x,y) of manhole 4. Surface cover, grade, type of cover (paved, yard, etc.) 5. Material of construction — brick, concrete, etc. 6. Area and Internal photos of manhole 7. All incoming and outgoing pipe depths from rim to invert 8. All incoming and outgoing pipe digital photographs 9. Defects — Active, Evidence or No Infiltration/Inflow with digital photographs 10. Field corrections to collection system map Upon completion of the manhole inspection, a prioritized manhole rehabilitation report will be prepared that will include: • Documentation with summary of field observations • List of manholes/lines requiring immediate attention • Digital photos • Documentation for preparing manhole rehabilitation quantities • Field updated map(s) • Prioritized Manhole Repair Recommendations and Cost Estimates To Be Provided by the District: • Access (if requested) to manholes that are buried or could not be opened. 55 of 91 October 19, 2022 Complete Agenda Packet • Assistance in locating assets (if requested) Measurement of Payment: Payment for this work task shall be a unit price for each manhole documented. Those manholes that are located, but buried or could not be opened will be noted and a list provided to the District. Manholes that could not be located using metal detectors or probes will be listed as Could Not Locate (CNL). CNL manholes will not be billed. Manholes located, but were buried or could not be opened will be billed. The District will provide replacement covers at no cost should a cover be broken while attempting opening. TASK 300 SMOKE TESTING OF STUDY AREA Smoke testing of Basin 14 will provide detailed information on wet weather inflow sources for the study area. In order to identify defects in the lines, a non-toxic smoke will be forced into the sewer by high capacity blowers. Data documentation includes measurements from two permanent points and will be sufficient to establish the location of each defect and determine the best repair method and priority. Color digital photographs will be taken to document each defect during the smoke test. The estimated total footage to be smoke tested is 47,800 linear feet. Forty-eight (48) hours prior to testing, door hangers will be used to notify residents. A telephone number will be provided for those individuals with questions or for anyone requiring special assistance. Each day the fire department will be notified of the crew location since smoke may enter homes through defective plumbing. To Be Provided by the District: • Review and approval of Notice to Residents • Letter of introduction to be carried by field crews • Previous smoke testing data, if any Final Report Deliverables: • Defects listing and database • Defect location sketch • Digital photographs • Smoke Notification Flyers and Notification of Residents • Priority ranking of defects (both private and public sector) • Repair methods and estimated costs 56 of 91 511 TROPHY CLUB MUNI CIPAL tr ILI Y DIsTRL 1' October 19, 2022 Complete Agenda Packet SMOKE TESTING NOTICE TO RESIDENT For the next few days, inspection crews will conduct a physical survey of the wastewater collection system. Pipeline Analysis will perform this study, which involves opening manholes in the streets and backyard utility easements. Information gained from this study will be used to repair and improve the wastewater collection system. One important task of the survey will be smoke testing of sewer lines to locate breaks and defects in the system. During this testing, white smoke will exit through vent pipes on the roofs of homes and through sewer line breaks. The smoke is non-toxic, leaves no residue, and creates no fire hazard. The smoke should not enter your home unless defective plumbing exists or drain traps are dry. If you have seldom -used drains, please pour a gallon of water in the drain to fill the drain trap. This procedure will help prevent the possibility of smoke entering your living areas through those drains. Field crews will perform testing of all sewers in the area. At no time will field crews have to enter your business or residence. Your cooperation is appreciated. Should you have any additional questions concerning this study or if you desire special assistance, please phone: 800-637-0164 PIPELINE ANALYSIS'" WASTEWATER COLLECTION SYSTEM ENGINEERS 57 of 91 October 19, 2022 Complete Agenda Packet Task 400 Dye Flooding Dye water testing can be anticipated to assist in locating specific defects during the evaluation. Non-toxic dye will be introduced as a powder or liquid. Cross -connections, roof drains and area drains, that are suspected of being connected to the sanitary sewer, may be positively identified using the dye tracer procedure. Field documentation and photographs will be used to record all findings. Internal inspection will determine the exact source of the 'cross -connection' and establish the best repair option (i.e., point repair, direct connection, etc.). Five (5) dye flood locations are estimated. To Be Provided by the District: • Water for dye flooding at no cost to Engineer TASK 500 & 600 CLEANING AND CCTV Preparatory cleaning shall consist of hydraulic jet cleaning to facilitate the internal CCTV inspection. Preparatory cleaning will consist of not more than three passes of the jet hose (normal cleaning). Heavy cleaning to remove large deposits of debris is not included in this work task. Debris will be removed from the line and transported for disposal. CCTV investigation is found to be critical in establishing the mainline condition and best practical repair methods. The total footage in Basin 14 for cleaning and CCTV inspection is estimated to be 47,800 linear feet. The following information will be gathered: 1. Field forms, equipment, supplies and oversight QA/QC 2. Document findings. Data to include: a. Date inspected b. Line segment being inspected c. Project name d. Location (Address) e. Footage location from manhole f. Defect code and/or type and severity rating using the national Pipeline Assessment Certification Program (PACP) codes g. Pipeline surface cover 3. Review video and logs 4. Provide reports on of segments televised in electronic format 5. Summary of line segments cleaned and CCTV'd 6. Results of TV inspection provided on printed logs 7. Prepare prioritized mainline rehabilitation plan To Be Provided by the District: • Access to site of work for placement of equipment and personnel 58 of 91 October 19, 2022 Complete Agenda Packet • Disposal site for any debris removed from the sewer system • Water for cleaning and dye testing at no cost to engineer Measurement of Payment: Pipeline Analysis will invoice for the actual linear feet of sewer cleaned per the unit price specified in Exhibit A. In the case of CCTV, should the camera not be able to pass the entire length of the segment (due to protruding taps, roots, dropped joints, etc.), then an attempt will be made from the opposite direction (if possible). Where a reverse setup was attempted, then the entire segment length will be billed at the unit price specified. If a reverse setup cannot be performed, then the actual segment footage CCTV'd will be billed. TASK 7OO ADMINISTRATION AND PROJECT MANAGEMENT This task includes internal project administration and oversight including scheduling, budget, quality assurance and control meetings and reporting. The project schedule will be reviewed and milestones for the completion of each task will be assigned. The project schedule will be reviewed and updated monthly to ensure that all tasks are completed in a timely and organized fashion. Management work items include: 1. Field crew supervision and project planning 2. Prepare monthly billings 3. Schedule equipment and order supplies Major system deficiencies that are identified during the field inspections that if corrected would result in significant reduction in Nor is deemed to be of a safety concern will be recorded and forwarded as soon as possible to the District's designated project manager. Likewise, should the District undertake a major repair within the study area, they will notify ENGINEER to determine the impact on data analysis. Deliverables: 1. Monthly invoice 2. Status reports 3. Project schedule and updates To Be Provided by the District: • All reports or materials deemed necessary by ENGINEER and identified during the course of the project that is not specifically stated above will be provided at no additional cost to the ENGINEER 59 of 91 October 19, 2022 Complete Agenda Packet TASK 800 DEFECT ANALYSIS/ REHABILITATION This project will generate a considerable amount of data that will require proper entry and quality control. Data collection will include the following: 1. All collected data will be integrated into the project existing defect database and will be compatible with ArcGIS. 2. All collected defect data will be correlated between sources to address duplicate defects that were identified by different testing methods. Identify duplicate defects to ensure multiple rehabilitation methods are not recommended for the same defect. 3. Defect data will be presented graphically (data visualization). 4. Much of the baseline data required for rehabilitation decision is gathered during the normal course of field investigations. For example, "area photos" are taken of each manhole in the direction of the outgoing pipe. This photograph not only shows the location of the manhole but also provide data on the line cover and easement conditions. 5. Since private sector defects can contribute to excessive inflow, proper documentation for subsequent repair is important. Property owner address, photograph and sufficient information to document the defect will be recorded. Private sector defects will be prioritized and repair methods/costs established. 6. Rehabilitation recommendations will consider the best repair for the particular asset (manhole, pipeline, etc.) being rehabilitated. A long-term least -cost solution may have an initial higher cost, but provide a higher level of service and lower operating and maintenance cost. Supporting data will be provided on accompanying flash drive. To Be Provided by the District: • Complaint records and SSO database if requested TASK 900 FINAL SSES REPORT AND TCEQ ANNUAL PROGRESS REPORT Prepare and submit three (3) Final SSES Report and electronic data that includes the following: • Executive Summary • Description of all tasks • Manhole and pipe inspection summary/inventory • Manhole and pipeline defect summary • Service lateral defect summary • Smoke test data summary • CCTV data summary • Recommendations and Cost Estimates for Private and Public sector repairs Compile applicable information necessary to complete and submit the TCEQ SSOI Annual Progress Report (TCEQ Form 20595) on behalf of the District as stipulated in the SSOI Agreement Enforcement Case No. 59814. 60 of 91 October 19, 2022 Complete Agenda Packet Basin 14 Study Area Map Manhole Inspection, Smoke Testing and CCTV Inspection 61 of 91 October 19, 2022 Complete Agenda Packet Exhibit A Project Cost and Schedule Year 3 — Basin 14 Basin 14 Condition Assessment Task Description Estimated Unit Total Quantity Price 100 Mobilization 200 Manhole/Pipe Inspection -(100%) 300 Smoke Testing, Public Awareness, Data Entry & Analysis (100%) 400 Dye Flooding 500 Preparatory Cleaning a. 6"-10" b. 12"-21" 600 CCTV Inspection 700 Admin.,Project Mgt. 800 Defect Analysis/Rehab. 900 Database, Cost Estimates, Mapping, Final Reports L.S. 183 47,800 5 47,800 L.S. $ 135.00 $ 0.60 $ 450.00 $ 3,780.00 $ 24,705.00 $ 28,680.00 $ 2,250.00 39,890 $ 1.60 $ 63,824.00 7,910 $ 1.95 $ 15,424.50 47,800 $ 1.40 $ 66,920.00 L.S. L.S. $ 1,650.00 L.S. L.S. $ 1,440.00 L.S. L.S. $ 8,690.00 Total Not To Exceed $ 217,363.50 Task Description Month 1 2 3 4 5 6 7 Estimated Quantity 100 Mobilization 200 Manhole/Pipe Inspection -(100%) 300 Smoke Testing, Public Awareness, Data Entry & Analysis (100%) 400 Dye Flooding 500 Preparatory Cleaning 600 CCTV Inspection 700 Admin.,Project Mgt. 800 Defect Analysis/Rehab. 900 Database, Cost Estimates, Mapping, Final Reports Anticipated notice to proceed October 2022 62 of 91 183 47,800 5 47,800 47,800 October 19, 2022 Complete Agenda Packet WORK ORDER MANAGER The Work Order Manager will be the primary contact person during performance of this work and will provide the ENGINEER the basin study area(s) to be inspected. All correspondence or inquiries should be addressed to the Work Order Manager. This work task will be coordinated by: Alan Fourmentin General Manager 682-831-4600 afourmentin a(�tcmud.orq APPROVAL The undersigned has reviewed and approved this Work Order and authorizes Pipeline Analysis LLC to perform the work as presented: Authorized by: Alan Fourmentin General Manager (Date) ACCEPTED BY The undersigned has reviewed and approved this Work Order. Pipeline Analysis is authorized to perform the scope of services in Work Order 2 as presented without exceeding contract not -to -exceed limits. Authorized by: Mattie A. Engels, P.E. Vice -President July 6, 2022 63 of 91 15,1 TROPHY CLUB MUNICIPAL UTILITY DISTRICT STAFF REPORT October 19, 2022 October 19, 2022 Complete Agenda Packet AGENDA ITEM: Consider and act regarding approval of Task Order Agreement with Halff Associates for professional engineering services for replacement of existing water lines at a total cost of $74,100 and authorize the General Manager to execute the task order documents. DESCRIPTION: Halff Associates will provide professional engineering services for the design and bidding for the replacement of approximately 6,000 linear feet of water lines along and adjacent to Sunset Drive, Berkshire Court, Lee Court, Riviera Court, and Skyline Drive as a part of FY 2023 Capital Improvement Projects. ATTACHMENTS: Halff Task Order Proposal RECOMMENDATION: Approval of Task Order Agreement as stated above as part of FY2023 Capital Improvement Projects. 64 of 91 October 19, 2022 Complete Agenda Packet October 4, 2022 P36681.004 Mr. Alan Fourmentin Trophy Club Municipal Utility District No.1 100 Municipal Drive Trophy Club, Texas 76262 RE: Proposal for FY 2023 8 -Inch Water Line Design Dear Mr. Fourmentin, We are pleased to present the following scope of services and fee schedule to provide professional engineering services for the Trophy Club Municipal Utility District No. 1 (District). Per our discussion, the District would like Halff Associates to prepare engineering design plans for the replacement of the existing water lines along Sunset Drive, Berkshire Court, Lee Court, Riviera Court and Skyline Drive. This contract proposal includes the following items: Attachment 'A' — Scope of Services and Attachment 'B' — Fee Summary. Refer to Halffs Agreement for Professional Engineering Services on a Task Order Basis, executed by the District on October 18, 2018, for the terms and conditions of this proposal. The fees quoted in this proposal will be honored for up to 60 days from the date of this proposal. The signed Agreement by both parties will serve as Notice to Proceed (NTP). Engineering services will begin upon NTP and following the initial meeting with the District. See Attachment 'B' for signature page. We trust this proposal meets your requirements for this project. We appreciate the opportunity to be of service to you, and trust that our association on this project will be mutually beneficial. Please feel free to contact us if you have any questions or comments concerning this proposal. Sincerely, HALFF ASSOCIATES, INC. 41-(14 Avity- Leah M. Hodge, PE, CFM Project Manager C: Ron King, PE - Halff 65 of 91 ATTACHMENT 'A' Scope of Services Overview October 19, 2022 Complete Agenda Packet Halff will prepare design plans for 8 -inch water lines and services, an approximate total length of 6,000 linear feet. The existing asbestos cement (AC) lines will be replaced in-place by AWWA C-900 pipe. The District has provided record drawings of the existing water lines. The water lines will be replaced in the existing alignment. The Sunset Drive water line replacement will begin at Wilshire Drive and end at Portland Drive. It also includes the water line between Sunset Drive and Straight Creek Court. The total length is approximately 2,025 if. The Berkshire Court replacement will begin at the cul-de-sac and end at Portland Drive. It also includes the water line between Berkshire Court and Wilshire Drive. The total length is approximately 1,155 if. The Lee Court replacement includes Lee Court and the water line between Carnoustie Drive and Lee Court, a total length of 7651f. The Riviera Court replacement will begin at the cul-de-sac and end at Trophy Club Drive, a total length of 1,1151f of water line. The Skyline Drive replacement will begin at Indian Creek Drive and run through 9 Skyline Drive, a total length of 8801f. Basemap Preparation No survey will be performed as part of this project. The basemap will be prepared using an aerial image, record drawings, and field verification. GIS property boundaries from the Denton County Appraisal District will be utilized. Final Design Phase (90% Submittal) Final plans will be prepared and submitted to the District for review. The plans will include the following sheets: 1. Cover Sheet with locator map and sheet index. 2. General notes/specifications sheet. 3. Project layout sheet. 4. Water line plan sheets; no profiles. 5. Construction detail sheets. 6. Contract Documents and Specifications (separate document). 66 of 91 October 19, 2022 Complete Agenda Packet Halff will deliver a PDF and two half size (11"x17") hard copies of the Construction Plans to the District for review. Halff will submit an estimate of probable construction cost with the 90% submittal. A review meeting with the District will be conducted at the end of the 90% Design Phase. Construction Plans (100% Submittal) District comments will be addressed, and the plans will be submitted for construction. Each plan sheet will be stamped, dated and signed by the Engineer. Contract Documents and Specifications will be prepared. Halff will submit an updated estimate of probable construction cost with the 100% submittal. Halff will deliver a PDF, and one full size (22"x34") and three half size (11"x17") hard copies of the Construction Plans to the District. Bidding and Construction Phase Services Halff will provide bidding and construction phase services, including the following tasks: 1. Provide Link to Bidding Documents and Maintain Plan holder List through Civcast 2. Attend Pre -Bid Meeting 3. Issue Addenda and Respond to Contractor Questions 4. Prepare Bid Tabulation and Letter of Recommendation 5. Prepare Conformed Contract Documents for Execution (4 Originals) 6. Provide Plans for Construction (1-22"x34" and 3-11"x17") 7. Attend Pre -Construction Meeting 8. Review Submittals and Answer RFIs 9. Review Pay Applications 10. Prepare Project Closeout Documents 11. Prepare Record Drawings Schedule • Completion of final construction plans and contract documents and specifications (90%): 90 calendar days from notice to proceed. • Completion of construction plans (100%): 150 calendar days from notice to proceed, excluding District review time. • Bidding services: 30 calendar days from District's approval of construction plans. • Construction services: In accordance with construction schedule • Closure: 30 calendar days from the date of construction completion Additional services not included in the Scope of Services: • Geotechnical investigation 67 of 91 October 19, 2022 Complete Agenda Packet • Subsurface Utility Engineering (SUE) services • Traffic control services • ROW/Easement services, including temporary right -of -entries • Pavement replacement or rehabilitation outside of the trench width • Public meetings • Performance of materials testing or specialty testing services • Services related to submitting for permits (ie. Town, utilities, etc.) • Services related to survey construction staking • Construction site visits • Construction inspection services, including final walk through 68 of 91 ATTACHMENT 'B' Fee Summary PROPOSED FEE SCHEDULE October 19, 2022 Complete Agenda Packet I. Construction Plan Preparation $57,600 (Lump Sum) IL Bidding and Construction Phase Services $16,500 (Lump Sum) TOTAL FEE $74,100 This project will be a lump sum fee. The lump sum fee will not be exceeded without prior approval from the District. The lump sum fee will be invoiced monthly based on percent completed. Halff will coordinate with the District to establish the billing schedule. Direct costs, including printing, plotting, and reproduction, postage, messenger service, specialized equipment (such as GPS), long distance telephone calls and vehicle mileage will be considered reimbursable and will be billed at 1.10 times the direct cost incurred. Additional services may be requested by the District on a task order basis. Halff will develop a separate scope and fee for each additional service and obtain approval from the District prior to initiating work on the additional services. A summary of current hourly billing rates and current unit pricing schedule is in Halff's Agreement for Professional Engineering Services on a Task Order Basis with the District (dated October 18, 2018). Unless otherwise stated, fees quoted in this proposal exclude state and federal sales taxes on professional services. Current Texas law requires assessment of sales tax on certain kinds of surveying services but does not require sales taxes on other professional services. In the event that new or additional state or federal taxes are implemented on the professional services provided under this contract during the term of the work, such taxes will be added to the applicable billings and will be in addition to the quoted fees and budgets. The fees and budgets established above do not include revisions once the project is underway. If revisions are requested, a revision to the scope and budget will be required. Refer to Halff's Agreement for Professional Engineering Services on a Task Order Basis, executed by the District on October 18, 2018, for the terms and conditions of this proposal. We will proceed upon receiving the signed copy of this proposal. Signature blocks are on the following page. 69 of 91 By: October 19, 2022 Complete Agenda Packet Submitted: Approved: HALFF ASSOCIATES, INC. TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO.1 e, Signature Ron King Printed Name W/WW Team Leader Title 10/4/2022 Date By: 70 of 91 Signature Printed Name Title Date October 19, 2022 Complete Agenda Packet October 4, 2022 P36681.004 Mr. Alan Fourmentin Trophy Club Municipal Utility District No.1 100 Municipal Drive Trophy Club, Texas 76262 RE: Proposal for FY 2023 8 -Inch Water Line Design Dear Mr. Fourmentin, We are pleased to present the following scope of services and fee schedule to provide professional engineering services for the Trophy Club Municipal Utility District No. 1 (District). Per our discussion, the District would like Halff Associates to prepare engineering design plans for the replacement of the existing water lines along Sunset Drive, Berkshire Court, Lee Court, Riviera Court and Skyline Drive. This contract proposal includes the following items: Attachment 'A' — Scope of Services and Attachment 'B' — Fee Summary. Refer to Halffs Agreement for Professional Engineering Services on a Task Order Basis, executed by the District on October 18, 2018, for the terms and conditions of this proposal. The fees quoted in this proposal will be honored for up to 60 days from the date of this proposal. The signed Agreement by both parties will serve as Notice to Proceed (NTP). Engineering services will begin upon NTP and following the initial meeting with the District. See Attachment 'B' for signature page. We trust this proposal meets your requirements for this project. We appreciate the opportunity to be of service to you, and trust that our association on this project will be mutually beneficial. Please feel free to contact us if you have any questions or comments concerning this proposal. Sincerely, HALFF ASSOCIATES, INC. 41-(14 Avity- Leah M. Hodge, PE, CFM Project Manager C: Ron King, PE - Halff 71 of 91 ATTACHMENT 'A' Scope of Services Overview October 19, 2022 Complete Agenda Packet Halff will prepare design plans for 8 -inch water lines and services, an approximate total length of 6,000 linear feet. The existing asbestos cement (AC) lines will be replaced in-place by AWWA C-900 pipe. The District has provided record drawings of the existing water lines. The water lines will be replaced in the existing alignment. The Sunset Drive water line replacement will begin at Wilshire Drive and end at Portland Drive. It also includes the water line between Sunset Drive and Straight Creek Court. The total length is approximately 2,025 if. The Berkshire Court replacement will begin at the cul-de-sac and end at Portland Drive. It also includes the water line between Berkshire Court and Wilshire Drive. The total length is approximately 1,155 if. The Lee Court replacement includes Lee Court and the water line between Carnoustie Drive and Lee Court, a total length of 7651f. The Riviera Court replacement will begin at the cul-de-sac and end at Trophy Club Drive, a total length of 1,1151f of water line. The Skyline Drive replacement will begin at Indian Creek Drive and run through 9 Skyline Drive, a total length of 8801f. Basemap Preparation No survey will be performed as part of this project. The basemap will be prepared using an aerial image, record drawings, and field verification. GIS property boundaries from the Denton County Appraisal District will be utilized. Final Design Phase (90% Submittal) Final plans will be prepared and submitted to the District for review. The plans will include the following sheets: 1. Cover Sheet with locator map and sheet index. 2. General notes/specifications sheet. 3. Project layout sheet. 4. Water line plan sheets; no profiles. 5. Construction detail sheets. 6. Contract Documents and Specifications (separate document). 72 of 91 October 19, 2022 Complete Agenda Packet Halff will deliver a PDF and two half size (11"x17") hard copies of the Construction Plans to the District for review. Halff will submit an estimate of probable construction cost with the 90% submittal. A review meeting with the District will be conducted at the end of the 90% Design Phase. Construction Plans (100% Submittal) District comments will be addressed, and the plans will be submitted for construction. Each plan sheet will be stamped, dated and signed by the Engineer. Contract Documents and Specifications will be prepared. Halff will submit an updated estimate of probable construction cost with the 100% submittal. Halff will deliver a PDF, and one full size (22"x34") and three half size (11"x17") hard copies of the Construction Plans to the District. Bidding and Construction Phase Services Halff will provide bidding and construction phase services, including the following tasks: 1. Provide Link to Bidding Documents and Maintain Plan holder List through Civcast 2. Attend Pre -Bid Meeting 3. Issue Addenda and Respond to Contractor Questions 4. Prepare Bid Tabulation and Letter of Recommendation 5. Prepare Conformed Contract Documents for Execution (4 Originals) 6. Provide Plans for Construction (1-22"x34" and 3-11"x17") 7. Attend Pre -Construction Meeting 8. Review Submittals and Answer RFIs 9. Review Pay Applications 10. Prepare Project Closeout Documents 11. Prepare Record Drawings Schedule • Completion of final construction plans and contract documents and specifications (90%): 90 calendar days from notice to proceed. • Completion of construction plans (100%): 150 calendar days from notice to proceed, excluding District review time. • Bidding services: 30 calendar days from District's approval of construction plans. • Construction services: In accordance with construction schedule • Closure: 30 calendar days from the date of construction completion Additional services not included in the Scope of Services: • Geotechnical investigation 73 of 91 October 19, 2022 Complete Agenda Packet • Subsurface Utility Engineering (SUE) services • Traffic control services • ROW/Easement services, including temporary right -of -entries • Pavement replacement or rehabilitation outside of the trench width • Public meetings • Performance of materials testing or specialty testing services • Services related to submitting for permits (ie. Town, utilities, etc.) • Services related to survey construction staking • Construction site visits • Construction inspection services, including final walk through 74 of 91 ATTACHMENT 'B' Fee Summary PROPOSED FEE SCHEDULE October 19, 2022 Complete Agenda Packet I. Construction Plan Preparation $57,600 (Lump Sum) IL Bidding and Construction Phase Services $16,500 (Lump Sum) TOTAL FEE $74,100 This project will be a lump sum fee. The lump sum fee will not be exceeded without prior approval from the District. The lump sum fee will be invoiced monthly based on percent completed. Halff will coordinate with the District to establish the billing schedule. Direct costs, including printing, plotting, and reproduction, postage, messenger service, specialized equipment (such as GPS), long distance telephone calls and vehicle mileage will be considered reimbursable and will be billed at 1.10 times the direct cost incurred. Additional services may be requested by the District on a task order basis. Halff will develop a separate scope and fee for each additional service and obtain approval from the District prior to initiating work on the additional services. A summary of current hourly billing rates and current unit pricing schedule is in Halff's Agreement for Professional Engineering Services on a Task Order Basis with the District (dated October 18, 2018). Unless otherwise stated, fees quoted in this proposal exclude state and federal sales taxes on professional services. Current Texas law requires assessment of sales tax on certain kinds of surveying services but does not require sales taxes on other professional services. In the event that new or additional state or federal taxes are implemented on the professional services provided under this contract during the term of the work, such taxes will be added to the applicable billings and will be in addition to the quoted fees and budgets. The fees and budgets established above do not include revisions once the project is underway. If revisions are requested, a revision to the scope and budget will be required. Refer to Halff's Agreement for Professional Engineering Services on a Task Order Basis, executed by the District on October 18, 2018, for the terms and conditions of this proposal. We will proceed upon receiving the signed copy of this proposal. Signature blocks are on the following page. 75 of 91 By: October 19, 2022 Complete Agenda Packet Submitted: Approved: HALFF ASSOCIATES, INC. TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO.1 e, Signature Ron King Printed Name W/WW Team Leader Title 10/4/2022 Date By: 76 of 91 Signature Printed Name Title Date 15,1 TROPHY CLUB MUNICIPAL UTILITY DISTRICT STAFF REPORT October 19, 2022 October 19, 2022 Complete Agenda Packet AGENDA ITEM: Consider and act regarding approval of Work Order #4 with Garver for professional engineering services related to Pump Station improvements at a total cost of $240,464 and authorize the General Manager to execute the contract documents. DESCRIPTION: Garver will provide design, bidding, and construction services related to the replacement of two (2) vertical turbine pumps, incorporation of variable frequency drives, and replacement of discharge header piping and valves within the high service pump station. The pump replacements were identified and prioritized as recommended capital improvements resulting from the Water Master Plan update conducted in 2021. The pumps have met their useful life and are being replaced with more efficient pumps utilizing electrical components designed to assist with reduced electrical consumption, provide further system resiliency, unify pump operations, and standardize pump components. Additionally, leaks during January of 2022 reflected the necessity to replace the piping and valves on the discharge side of the pumps due to age and wear. ATTACHMENT: Work Order #4 RECOMMENDATION: Approval of Work Order Agreement as stated above as part of FY2023 Capital Improvement Projects. 77 of 91 October 19, 2022 Complete Agenda Packet Work Order No. 4 to the Master Agreement For Professional Services Trophy Club Municipal Utility District No. 1 Project No. 21W05181 Version 1 Trophy Club High Service Pump Station and Piping Garver Project No. 21W05181 WO #4 Improvements 78 of 91 October 19, 2022 Complete Agenda Packet This WORK ORDER ("Work Order") is made by and between the Trophy Club Municipal Utility District No. 1 (hereinafter referred to as "Owner") and Garver, LLC, (hereinafter referred to as "Garver") in accordance with the provisions of the MASTER AGREEMENT FOR PROFESSIONAL SERVICES executed on July 27, 2021 (the"Agreement'). Under this Work Order, the Owner intends to perform High Service Pump Station and Piping Improvements to include the following: • All improvements will be located within the existing fenced areas of the high service pump station. • Demolition as needed within the existing building. • Replace two (2) pumps and incorporate variable frequency drives(VFDs). • Install new NC unit. • Replace discharge header piping from the high service pump station. • Provide connections to the existing electrical system. • Note- no building design is included with this proposal. Garver will provide professional services related to these improvements as described herein. Terms not defined herein shall have the meaning assigned to them in the Agreement. SECTION 1 - SCOPE OF SERVICES Garver shall provide the following Services: 1. TASK 1 - PROJECT MANAGEMENT 1.1. Garver will also perform the following: (a) Conduct a kick-off meeting with the Owner to discuss project scope, introduce teams, establish lines of communication, and present the project schedule. At that time, up to three (3) Garver members will visit each of the sites under the scope of work. (b) Garver will prepare and provide up to eighteen (18) monthly progress/status reports, sufficient to support monthly billings. Monthly status reports shall be submitted with monthly invoices and project updates. (c) Consultant will develop a Project Management Plan (PMP) for internal use. This will include the development of a detailed schedule to communicate key deadlines to the design teams. Consultant will also develop a Quality Control/Assurance Plan and perform internal Quality Assurance/Quality Control (QA/QC) reviews of all major deliverables. 1 Trophy Club High Service Pump Station and Piping Improvements 79 of 91 Version 1 Garver Project No. 21W05181 WO #4 2. TASK 2 - PRELIMINARY DESIGN October 19, 2022 Complete Agenda Packet The Preliminary Design phase submittal will include preliminary drawings and an opinion of probable construction cost (OPCC). The preliminary design phase will represent approximately 60 percent of final construction contract plans. This submittal will not include technical specifications or "front end" contract documents. Garver will incorporate comments from the Owner on the Preliminary Design in the Final Design. Garver will complete the Preliminary Design within 90 days from receipt of the Notice to Proceed (NTP). 2.1. Design Submittal Workshops GARVER will lead a 60% design workshop to solicit comments and feedback from the Owner. This workshop will be conducted at the Owner's office and will be attended by up to two (2) Garver members. 2.2. Deliverables This task will include the following deliverables: 1. Preliminary Design Drawings — one (1) electronic (pdf) copy to the Owner 3. TASK 3 - FINAL DESIGN During the final design phase of the project, Garver will conduct final designs to prepare construction plans and specifications for one (1) construction contract, including final construction details, special provisions, and OPCC. The final design phase is anticipated to have two major submittals: a 90% Design and a 100% Design/Issued for Bid. Garver will complete the Final Design within 90 days from receipt of Owner's approval of the Preliminary Design. 3.1. Drawings and Specifications Based upon the results of the approved preliminary design by the Owner, Garver will develop the detailed plans and specifications as a part of the Final Design for a single construction contract. Garver will utilize Engineers Joint Council Documents Committee (EJCDC) standard documents as a basefor developing the project's front-end documents. EJCDC's standard General Conditions shall be utilized with edits being provided by the Supplementary Conditions. Multiple design scenarios or bid packages and/or pre -purchased equipment packages are not included as part of the level of effort provided with this agreement. The drawings will include: • Demolition Plans and Sections • Site Plan • Process Mechanical • Instrumentation • Electrical Plans and Schematics 3.2. Contract Documents The Contract Documents will consist of drawings and specifications that set forth requirements for construction of the improvements, and shall include proposal forms, notice to bidders, bid forms, bond forms, and other information as required by the Owner to competitively bid the work. Garver's standard contract forms including documents from the Engineers Joint Contract Documents Committee 2 Trophy Club High Service Pump Station and Piping Improvements 80 of 91 Version 1 Garver Project No. 21W05181 WO #4 October 19, 2022 Complete Agenda Packet (EJCDC) will be used, along with Garver's standard drawing format and technical specifications. Standard forms required by the funding source will also be included as necessary. 3.3. TCEQ Construction Permit Garver will prepare and submit a TCEQ Construction Permit Application. 3.4. Design Submittal Workshops Garver will lead a 90% design workshop to solicit comments and feedback from the Owner. This workshop will be conducted at the Owner's office and will be attended by up to two (2) Garver members. 3.5. Deliverables This task will include the following deliverables: (a) 90% design documents (plans, specifications, and OPCC) — one (1) electronic (pdf) copy of each to the Owner (b) 100% design/Issue for Bid documents (plans, specifications, and OPCC) — one (1) electronic (pdf) copy of each to the Owner) 4. TASK 4 - BIDDING SERVICES This task will accomplish the following: • Advertise for bids • Conduct a pre-bid meeting • Prepare a letter of recommendation • Conducta pre -construction meeting Garver will complete the Bidding Services within 60 days from receipt of Owner's approval to advertise. 4.1. Bidding Assistance The scope of services assumes the bidding period for bidders is 30 calendar days. During the bidding period phase of the project, the following tasks will be accomplished: (a) Garver will prepare and submit Advertisement for Bids to an online plan room (such as Civcast). Other construction contract documents and any other necessary information will also be uploaded. Garver will also respond to questions submitted by potential bidders. (b) The Owner will submit the advertisement to newspaper(s) for publication and will pay for those advertising costs outside of this contract. (c) Garver will support the contract documents by preparing addenda as appropriate and posting on Garver's online plan room. (d) Garver will participate in a pre-bid meeting. (e) Garver will prepare pre-bid meeting minutes. Following Owner authorization, post the pre-bid meeting minutes with attendance record on GARVER's online planroom. (f) Garver will participate and chair a construction site tour by interested pre-bid meeting attendees and other interested parties. (g) Garver will prepare a bid tabulation. (h) Garver will evaluate bids and recommend award. 3 Trophy Club High Service Pump Station and Piping Improvements 81 of 91 Version 1 Garver Project No. 21W05181 WO #4 October 19, 2022 Complete Agenda Packet 5. TASK 5 - CONSTRUCTION ADMINISTRATION SERVICES During the construction phase of work, Garver will accomplish the following: (a) Issue a Notice to Proceed letter to the Contractor and prepare and attend preconstruction meeting. (b) Attend regular progress/coordination meetings, up to a maximum of six (6), with the Owner/Contractor. (c) Evaluate and respond to construction material submittals and shop drawings. Corrections or comments made by Garver on the shop drawings during this review will not relieve Contractor from compliance with requirements of the drawings and specifications. The check will only be for review of general conformance with the design concept of the project and general compliance with the information given in the contract documents. The Contractor will be responsible for confirming and correlating all quantities and dimensions, selecting fabrication processes and techniques of construction, coordinating his work with that of all other trades, and performing his work in a safe and satisfactory manner. Garver's review shall not constitute approval of safety precautions or constitute approval of construction means, methods, techniques, sequences, procedures, or assembly of various components. When certification of performance characteristics of materials, systems or equipment is required by the Contract Documents, either directly or implied for a complete and workable system, Garver shall be entitled to rely upon such submittal or implied certification to establish that the materials, systems or equipment will meet the performance criteria required by the Contract Documents. The fee is based upon approximately 10 estimated submittals. (d) Issue instructions to the Contractor on behalf of the Owner and issue necessary clarifications (respond to RFIs) regarding the construction contract documents. The fee is based upon approximately five (5) estimated RFIs. (e) When authorized by the Owner, prepare change orders for changes in the work from that originally provided for in the construction contract documents. If redesign or substantial engineering or surveying is required in the preparation of these change order documents, the Owner will pay Garver an additional fee to be agreed upon by the Owner and Garver. The fee is based upon reviewing approximately two (2) contract modification requests and preparing up to one (1) change orders. (f) Participate in final project inspection, prepare punch list, review final project closing documents, and submit final pay request. Garver will also provide a project certification letter with final project cost to the Owner. 6. Extra Work The following items are not included under this agreement but will be considered as extra work: • Boundary, topographic, or any other survey • Realignment or modification of the electrical utility service to thesites • Realignment of the site boundary or fencing • Site lighting improvements • Design of a new building to house the new pumps • Arc flash or other power system studies 4 Trophy Club High Service Pump Station and Piping Improvements 82 of 91 Version 1 Garver Project No. 21W05181 WO #4 October 19, 2022 Complete Agenda Packet • Design for generator systems • Submittals or deliverables in addition to those listed herein • Redesign for the Owner's convenience or due to changed conditions after previous alternate direction and/or approval SECTION 2 — PAYMENT For the Services set forth above, Owner will pay Garver as follows: The table below presents a summary of the fee amounts and fee types for this Work Order. WORK DESCRIPTION FEE AMOUNT FEE TYPE Task 1 - Project Manavement $17,530 LUMP SUM Task 2 - Preliminary Design (60%) $64,928 LUMP SUM Task 3 - Final Design (90% and 100%) $82,072 LUMP SUM Task 4 — Bidding Services $17,922 LUMP SUM Task 5 — Construction Services $58,012 HOURLY TOTAL FEE $240,464 The total amount to be paid under this Work Order is $240,464. Hourly Tasks and Additional Services (Extra Work). For hourly tasks or services not described or included in Section 2, but requested by the Owner in writing or otherwise, the Owner will pay Garver as expressly set forth in the applicable Amendment, or in the event the Amendment is silent, for the additional time spent on the Project, at the rates shown in this Appendix A for each classification of Garver's personnel (may include contract staff classified at Garver's discretion) plus reimbursable expenses including but not limited to printing, courier service, reproduction, and travel. The rates shown in Appendix A will be increased annually on or about June 30, 2023. SECTION 3 — APPENDICES 3.1 The following Appendices are attached to and made a part of this Work Order: Appendix A — Hourly Rate Schedule This Work Order may be executed in two (2) or more counterparts each of which shall be deemed an original, but all of which together shall constitute one and the same instrument. 5 Trophy Club High Service Pump Station and Piping Improvements 83 of 91 Version 1 Garver Project No. 21W05181 WO #4 October 19, 2022 Complete Agenda Packet The effective date of this Work Order shall be the last date written below. Trophy Club Municipal Utility District No. 1 GARVER, LLC By: By: Signature Signature Name: Alan Fourmentin Printed Name Title: General Manager Name: Lance Klement Printed Name Title: North Texas Water Team Leader 9/29/2022 Date: Date: 6 Trophy Club High Service Pump Station and Piping Improvements 84 of 91 Version 1 Garver Project No. 21W05181 WO #4 October 19, 2022 Complete Agenda Packet APPENDIX A HOURLY RATE SCHEDULE Trophy Glob Litt Station Generators Garver Hourly Rate Schedule: July 2022 -June 2023 Classification Rates nr.s. !Architects E-1 114.00 E-2 $ 132.00 E-3 $ 160.0D E-4 $ 187.00 E-5 $ 228.00 E-6 $ 280,00 E-7• $ 373.00 Planners ir Environmental Specialist P-1 ..,......„. ..... .... ...... ...... $ 137.00 P-2 $ 172.00 P-3 $ 209.00 P-4 $ 239.00 Designers 3 • D-1 $ 106.00 124.00 D-3 $ 148.00 D-4 172.00 Technicians 7-1 $ 83.00 7-2 .......................... ..... ...... ............ ...... ...... .....„$ 105.00 T-3.... .......... ........ ....... ...... ...... ...... ............ $ 128.00 Surveyors 5-1 $ 51.0D 8-2 $ 68 00 5-3 $ 91 00 S-4 $ 130,00 5-5 $ 172.00 5-6 $ 196.0D 2 -Main Crew (Survey) $ 208.00 3 -Man Crew (Survey) ................... .......... $ 259.00 2 -Man Crew (GPS Survey) $ 228.00 3 -Man Crew '0P8 Survey)...... ..... ...... ..... ....... ...... $ 279.00 Construction Observation 0-1 $ 100.00 C-2 ........ ........... ....... ...... ........ $ 129.00 C-3 158.00 C-4 $ 194 OD C-5 $ 232.00 Ma nage me ntiAdrnini strati on ........ .................. ...... ....„...... ...... ..... ...... . $ 65.00 X-2 5 39.00 X-3 $ 123.00 X-4 $ 157.0D X-5 ............. ..... . ......... ___..... ......... $ 193.00 X-6 5 238.00 7 Trophy Club High Service Pump Station and Piping Improvements 85 of 91 Version 1 Garver Project No. 21W05181 WO #4 15,1 TROPHY CLUB MUNICIPAL UTILITY DISTRICT STAFF REPORT October 19, 2022 October 19, 2022 Complete Agenda Packet AGENDA ITEM: Consider and act to award bid for Lift Station Generators. DESCRIPTION: 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. This project was advertised, and a public bid opening was held on October 10, 2022. Five (5) bids were received and are outlined in the attached letter of recommendation. ATTACHMENTS: Staff report Engineer recommendation Bid Tab RECOMMENDATION: Staff recommends awarding Contract 2022101902 for Lift Station Generators as part of FY 2023 Capital Improvement Projects to 308 Construction for an amount not to exceed $608,979.40 and authorize the General Manager to execute any necessary documents. 86 of 91 October 19, 2022 Complete Agenda Packet 3010 Gaylord Parkway Suite 190 Frisco, TX 75034 TEL 972.377.7480 FAX 972.377.8380 www.GarverUSA.com Trophy Club MUD No. 1 Attn: Alan Fourmentin 100 Municipal Drive Trophy Club, TX 76262 Re: Trophy Club MUD No.1 Lift Station Generators Improvements Recommendation of Award Dear Mr. Fourmentin: On October 10, 2022 at 10:O0AM, 5 bids were received on the Lift Station Generator Improvements project. 308 Construction submitted the apparent low bid for the project in the amount of $608,978.40. The submitted bid included a statement of lead times, which requested additional Contract Time based on equipment procurement estimates provided by a selected equipment manufacturer. Per Section 00 72 00 Article 4.05 Paragraph B, if the Contractor's performance or progress is delayed, disrupted, or interfered with by unanticipated causes not the fault of and beyond the control of Owner, Contractor, and those for which they are responsible, then Contractor shall be entitled to an equitable adjustment in Contract Time. We believe that the bid submitted by 308 Construction represents a good value for the Trophy Club MUD No.1. Contingent upon successful negotiation of terms with 308 Construction, we recommend that the construction contract for Lift Station Generators Improvements be awarded to 308 Construction and the statement of lead times be rejected based on the provisions included in Section 00 77 22 Article 4.05. Please call me if you have any questions. Sincerely, GARVER, LLC J /Justin Rackley, P.E. Senior Project Manager Project No. 21W05182 1 of 1 Recommendation of Award Trophy Club MUD No.1 Lift Station Generators Improvements 13 Oct. 2022 87 of 91 rROPN4 CLUB mvRIcUR1 UTILITY DISTRICT October 19, 2022 Complete Agenda Packet Trophy Club MUD No.1 Lift Station Improvements Bid Tabulation Trophy Club MUD No.1 Lift Station Improvements Bid Tabulation COMPANY NAME TOTAL BASE BID PRICE 308 Construction Prater Electric McDonald Municipal & Industrial CSE, W -Industries Rey -Mar Construction 608,978.40 1,000,536.00 662,469.00 798,469.00 1,670,350.00 TOTAL BASE BIDS AS READ ALOUD FROM THE WRITTEN TOTALS ON 10/10/2022 WHEN BIDS WERE OPENED. Project No. 21W05182 1 of 1 Trophy Club MUD No.1 Lift Station Generators Improvements 88 of 91 Bid Tabulation 10/10/2022 15,1 TROPHY CLUB MUNICIPAL UTILITY DISTRICT STAFF REPORT October 19, 2022 October 19, 2022 Complete Agenda Packet AGENDA ITEM: Consider and act to award bid for Wastewater Treatment Plant Membrane Bioreactor (MBR) improvements. DESCRIPTION: This project consists of piping improvements to the existing MBR filtrate pumps to correct issues related to loss of prime during "at -rest" stages as well as corrective measures to remediate fluctuation in backpressure that creates vibration and surges in pressure when pumps are operating. This project was advertised, and a public bid opening was held on October 10, 2022. One (1) bid was received and is outlined in the attached letter of recommendation. ATTACHMENTS Recommendation of award RECOMMENDATION: Staff recommends awarding Contract 2022101901 for Membrane Bioreactor (MBR) improvements as part of FY 2023 Capital Improvement Projects to Rey -Mar Construction for an amount not to exceed $213,000.00 and authorize the General Manager to execute any necessary documents. 89 of 91 October 19, 2022 Complete Agenda Packet 3010 Gaylord Parkway Suite 190 Frisco, TX 75034 TEL 972.377.7480 FAX 972.377.8380 www.GarverUSA.com Trophy Club MUD No. 1 Attn: Alan Fourmentin 100 Municipal Drive Trophy Club, TX 76262 Re: Trophy Club MUD No.1 Membrane Bioreactor Improvements Recommendation of Award Dear Mr. Fourmentin: On October 10, 2022 at 11:OOAM, 1 bid was received on the Membrane Bioreactor (MBR) Improvements project. Rey -Mar Construction submitted a responsible bid for the project in the amount of $213,000.00 and an Additive Bid Alternate A for $23,000.00. We believe that the bid submitted by Rey -Mar Construction represents a good value for the Trophy Club MUD No.1. Contingent upon successful negotiation of terms with Rey -Mar Construction, we recommend that the construction contract for MBR Improvements be awarded to Rey -Mar Construction. Please call me if you have any questions. Sincerely, GARVER, LLC Lance Klement, P.E. Senior Project Manager Project No. 21W05182 Recommendation of Award Trophy Club MUD No.1 MBR Improvements 11 Oct. 2022 90 of 91 Trophy Club Municipal Utility District No. 1 November 2022 Sun 45 Oct 30, 202' nam Denton County Gen 46 47 48 20 49 Mon d1 Tue Nov 1 Wed 2 Thu October 19, 2022 Complete Agenda PacckStrie Slaght 3 Fri Sat 7am Denton County General Election Early Voting 1 7am Election Day 15 2`z 9 16 r`J Board of Directors Re 10 11 12 17 18 19 24 25 27 28 29 Dec 1 26 3 91 of 91 Printed on: 10/13/202212:58pm Q Central Time US & Ca Powered by _ teamup