The URL can be used to link to this page

Home My WebLink About2020-1116 November 16 2020 Regular Meeting Agenda PacketTROPHY CLUB MUNICIPAL UTILITY DISTRICT November 16, 2020 Regular Meeting Agenda Packet BOARD OF DIRECTORS REGULAR MEETING TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 100 MUNICIPAL DRIVE TROPHY CLUB, TEXAS 76262 Monday, November 16, 2020 6:30 P.M. Svore Municipal Boardroom REGULAR MEETING AGENDA 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. October Combined Financials b. September 21, 2020 Regular Meeting Minutes - Amended c. October 19, 2020 Regular Meeting Minutes d. Appointment to Fort Worth Wholesale Advisory Committee attachments: October Financials September 21, 2020 Amended Meeting Minutes October 19, 2020 Regular Meeting Minutes Fort Worth Wholesale Advisory Committee Appointment form 1 of 148 November 16, 2020 Regular Meeting Agenda Packet EXECUTIVE SESSION 3. 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 review. REGULAR SESSION 4. Consider and act on matters deliberated in Executive Session. 5. Presentation of service award to Director Wilson by President Flynn. 6. Consider and take appropriate action regarding election matters: a. Approve Order 2020-1116 canvassing the election returns and declaring the results of the November 3, 2020 General Election. b. Administer the oath of office, approve statement of officers and director bonds, and take other such actions as necessary for Directors to qualify for office. attachments: Order No. 2020-1116 7. Receive introductory comments from elected Board members. 8. Consider and act regarding approval of employee health and ancillary benefits for the calendar year beginning January 1, 2021 and ending December 31, 2021 and authorize the General Manager to execute the necessary documents to implement the Board action. attachments: Staff Report 9. Consider and act regarding approval of task order agreement with Halff Associates for professional engineering services for District compliance with America's Water Infrastructure Act (AWIA) for completion by June 30, 2021: Phase I Risk and Resiliency Assessment (RRA) and Phase II Emergency Response Plans (ERP) for a cost of $77,200, and authorize the General Manager to execute the necessary documents to implement the Board action. attachments: Staff Report Halff Task Order AWIA 10. Consider and act to award Contract No. 2020111601 for Fence Replacement at the wastewater treatment plant as part of Fiscal Year 2021 Capital Improvement Projects and authorize the General Manager to execute the necessary documents. attachments: Staff Report 11. Consider and take appropriate action to select two (2) directors to serve as part of the Audit Committee. 12. Discussion and possible action regarding the purchase and installation of smart meters for residential 2 of 148 November 16, 2020 Regular Meeting Agenda Packet customers. (Chapman) attachments: Badger Orion Cellular Badger Orion SE 13. Discussion and possible action regarding expiration, renewal or amendment of Interlocal Cooperation Agreement for Administration of Fire Protection Services with the Town of Trophy Club, including the following: a. Authorize the Strategic Partnership Committee to engage in negotiations with the Town of Trophy Club related thereto; b. Appoint new member to the Strategic Partnership Committee to replace former Director Greg Wilson; and c. Other action related thereto appointment of a director. 14. Items for future agendas: 15. Set future Meeting dates — Regular Meeting Monday December 21, 2020 at 6:30 p.m. attachments: Meeting Calendar *THE BOARD RESERVES THE RIGHT TO ADJOURN INTO EXECUTIVE SESSION AT ANY TIME DURING THE MEETING PURSUANT TO THE APPLICABLE SECTION OF SUBCHAPTER D, CHAPTER 551, TEXAS GOVERNMENT CODE, THE TEXAS OPEN MEETINGS ACT, WITH RESPECT TO ANY ITEM ON THE AGENDA. NO FINAL ACTION, DECISION OR VOTE WILL BE TAKEN ON ANY SUBJECT OR MATTER IN EXECUTIVE SESSION. THIS NOTICE MODIFIES THE DISTRICTS PRIOR PRACTICE OF SPECIFICALLY IDENTIFYING ALL AGENDA ITEMS TO BE DISCUSSED IN EXECUTIVE SESSION. ADJOURN 3 of 148 180,000 160,000 140,000 120,000 100,000 80,000 60,000 40,000 20,000 1. November 16, 2020 Regular Meeting Agenda Packet Monthly Water Operations Report Water Billed FY October November December January February March April May June July August September Total Year 2011 70,502 50,909 44,365 35,983 27,845 55,972 69,165 61,467 99,326 117,707 170,464 123,692 927,397 2012 85,869 53,571 40,815 30,616 31,665 35,263 47,194 84,905 114,104 137,174 144,573 108,622 914,371 2013 85,488 75,251 48,527 39,601 34,450 43,137 56,947 76,542 85,312 110,072 130,945 114,497 900,769 2014 82,660 48,813 34,482 39,767 37,085 54,794 66,337 84,384 99,240 92,913 113,135 110,873 864,483 2015 90,994 58,986 49,607 36,162 38,776 30,566 46,543 39,576 60,731 100,622 139,441 123,886 815,890 2016 108,951 41,936 39,028 39,622 44,551 49,498 55,181 50,827 65,390 115,687 119,611 98,945 829,227 2017 74,785 68,638 38,580 33,028 38,380 60,841 56,683 86,794 98,864 95,355 104,303 99,541 855,792 2018 83,228 69,099 48,144 34,592 40,658 43,411 60,079 89,802 118,899 126,588 125,531 73,735 913,766 2019 47,193 41,933 36,244 34,604 33,740 40,421 55,970 42,773 70,747 96,174 131,472 114,784 746,055 2020 102,150 40,988 43,946 36,418 31,000 34,047 53,755 67,030 96,195 123,309 118,522 83,570 830,930 2021 98,232 1 1 1 1 1 1 1 1 1 1 1 1 98,232 100,000 80,000 60,000 40,000 20,000 0 WATER BILLED IN THOUSANDS OF GALLONS March Ap - 2017 - 2018 2019 - 2020 - 2021 Water Jumped FY October November December January February March April May June July August September Total Year 2011 70,502 50,993 44,220 33,789 36,053 54,775 71,306 63,500 116,350 152,002 169,621 117,190 980,301 2012 83,750 54,245 41,650 34,740 31,581 46,519 62,649 100,402 110,324 153,813 139,005 123,045 981,723 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 l 106,660 I l 1 l l 1 l 1 l 1 l 106,660) WATER PUMPED IN THOUSANDS OF GALLONS r October November December January February June July August September -2017 -2018 -2019 -202 -202 FY 2015 Total 2016 Total 2017 Total 2018 Total 2019 Total 2020 Total 2020 MUD 2020 PID October 4353 4531 4644 4701 4741 4795 3351 1444 November 4363 4538 4647 4706 4743 4796 3352 1444 December 4377 4556 4661 4712 4745 4797 3353 1444 January 4404 4568 4657 4716 4753 4797 3353 1444 Active Connections February March April 4413 4429 4443 4593 4604 4607 4663 4666 4670 4720 4724 4724 4753 4758 4761 4807 4807 4816 3363 3363 3372 1444 1444 1444 May 4459 4616 4676 4728 4762 4817 3373 1444 June 4478 4622 4685 4732 4768 4830 3386 1444 July 4486 4627 4690 4735 4770 4836 3392 1444 August September 4498 4517 4632 4636 4696 4700 4736 4738 4773 4782 4836 4837 3392 3393 1444 1444 4837 3393 2021 Total 2021 MUD 2021 PID 1444 4 of 148 November 16, 2020 Regular Meeting Agenda Packet October 2020 Results Ammonia -N CBOD5 TSS Date % Removal % Removal % Removal Influent Effluent Influent Effluent Influent Effluent 6 -Oct 49.5 0.20 99.6% 301 2.0 99.3% 246 1.0 99.6% 8 -Oct 52.0 0.20 99.6% 289 2.0 99.3% 315 1.0 99.7% 12 -Oct 57.5 0.20 99.7% 282 2.0 99.3% 302 1.0 99.7% 15 -Oct 60.2 0.20 99.7% 289 2.0 99.3% 260 1.0 99.6% 19 -Oct 52.5 0.20 99.6% 294 2.0 99.3% 320 1.0 99.7% 22 -Oct 50.5 0.20 99.6% 282 2.0 99.3% 307 1.0 99.7% 26 -Oct 57.8 0.20 99.7% 268 2.0 99.3% 257 1.0 99.6% 29 -Oct 48.8 0.20 99.6% 297 2.0 99.3% 252 1.0 99.6% IReport Ammonia -N CBOD5 TSS 0.20 1 99.6% 2.0 1 99.3% 1.0 1 99.6% 5 of 148 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 November 16, 2020 Regular Meeting Agenda Packet Ammonia Nitrogen Permit Limit 3 (Jan - March) 0.523 0.23 , 0.2 0.2 0.57 0.241 J Permit Limit -1 from April - August 0.2 0.2 0.2 0.2 0.2 Permit Limit 3 (Sept. - Dec.) Dec -19 Jan -20 Feb -20 Mar -20 Apr -20 May -20 Jun -20 Jul -20 Max mg/L = .20 Average mg/L =.20 Aug -20 Carbonaceous Biochemical Demand (CBOD5) Sep -20 Oct -20 Nov -20 Dec -20 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 II II II II II II II II II II II Dec -19 Jan -20 Feb -20 Mar -20 Apr -20 May -20 Jun -20 Jul -20 Max mg/L = 2.0 Average mg/L = 2.0 6 of 148 Aug -20 Sep -20 Oct -20 Nov -20 Dec -20 - Nh3Ave - Nh3 Permit Limit Bod Bod Aver .,Permit Limit 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 November 16, 2020 Regular Meeting Agenda Packet Total Suspended Solids (TSS) 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 1.0 1.0 1.0 1.0 1.0 1.0 .. M. .. .. M. .. .. .. .. .. Dec -19 Jan -20 Feb -20 Mar -20 Apr -20 May -20 Jun -20 Jul -20 Aug -20 Max mg/L = 1.0 Average mg/L = 1.0 Nitrate - Nitrogen Sep -20 Oct -20 Nov -20 Dec -20 Permit Limit 24 5.1 5.10 4.9 5.00 6.0 5.34 5.0 5.26 4.5 5.11 4.3 4.97 5.0 4.97 4.9 4.96 4.6 4.92 5.8 5.0 5.8 5.1 11111111 1 1 ' 1 1 1 1 1 111111 Dec -19 Jan -20 Feb -20 Mar -20 Apr -20 May -20 Jun -20 Jul -20 Max mg/L = 5.8 Average = 4.6 7 of 148 Aug -20 Sep -20 Oct -20 Nov -20 Dec -20 TSS TSS Ave ,Permit Limit N -N N -N Aver ,Permit Limit 10 9 8 7 6 5 4 3 2 1 0 10.0 9.0 8.0 7.0 6.0 5.0 4.0 3.0 2.0 1.0 0.0 November 16, 2020 Regular Meeting 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 1.0 1.0 1.0 1.0 HI MI MI MI MI MI 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Dec -19 Jan -20 Feb -20 Mar -20 Apr -20 May -20 Jun -20 Jul -20 Aug -20 Max mg/L = 1.0 Average mg/L = 1.0 Potential for Hydrogen (pH) Sep -20 Oct -20 Nov -20 Dec -20 6.89 Permit Limit High 9 7.77 3 7.41 7.67 7.72 7.48 7.627.39 7.47 7.48 7.03 7.16 7.11 7.06 6.74 6.64 6.29 11 11 7.44 7.48 7.02 7.01 6.59 6.53 Lim 6.7 6.72 7.146.92 7.196.96 6.87.116.96 0.00 0.00 Dec -19 Jan -20 Feb -20 Mar -20 Apr -20 May -20 Jun -20 Jul -20 Aug -20 Sep -20 Max mg/L = 7.45 Min mg/L = 7.42 Average mg/L = 7.436 8 of 148 Oct -20 Nov -20 Dec -20 • E. Coli • E. Coli Ave. • Permit Limit pH Min pH Max pH Aver ,Permit Limit Low ,Permit Limit High 10 9 8 7 6 5 4 3 2 1 0 November 16, 2020 Regular Meeting Agenda Packet Dissolved Oxygen (DO) Permit Limit Max 9 8.3 a.v 8.2 8.3 8.0 8.3 8.2 8.1 8.0 7.9 7.8 7.8 7.7 , 7.8 7.5 7.1 '3 7.4 P it Limit M E II II II 11 11 i Dec -19 Jan -20 Feb -20 Mar -20 Apr -20 May -20 Jun -20 Jul -20 Aug -20 Max mg/L = 8.1 Average mg/L = 7.5 9 of 148 Sep -20 Oct -20 Nov -20 Dec -20 - DO - DO Aver - Permit Limit Min. - Permit Limit Max ebills Bills Mailed Bank Draft Credit Card Draft Online Payments Late Notices Disconnects Connections P ebills Bills Mailed Bank Draft Credit Card Draft Online Payments Late Notices Disconnects Connections P M M November 16, 2020 Regular Meeting Agenda Packet Trophy Club MUD #1 Utility Billing Report Fiscal Year 2021 October November December January February March April May June July August September 1031 3921 651 1282 1258 442 39 3393 1444 Fiscal Year 2020 October November December January February March April May June July August September 938 941 944 951 963 970 979 986 1001 995 1004 1015 3841 3845 3860 3835 3817 3833 3815 3810 3808 3841 3882 3932 646 650 652 654 649 649 661 660 657 653 650 648 1193 1185 1193 1198 1168 1208 1249 1259 1241 1239 1258 1278 1145 1192 1,184 1,208 1,187 1,216 1,096 1,112 1,116 1144 1203 1201 378 453 339 462 452 425 428^ 544" 356" 419" 479" 423 21 41 42 27 38 20 0* 0* 0* 0* 0* 0* 3351 3352 3353 3353 3363 3363 3372 3373 3386 3392 3392 3393 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 A In response to COVID-19 the District has suspended Late Notices * In response to COVID-19 the District has suspended Disconnects 10 of 148 November 16, 2020 Regular Meeting Agenda Packet MUD Permits Month: October 2020 Plumbing Sewer Date of Customer Deposit Due to FW Water 135- Inspections 135- Inspections 135- Misc Income Permit Permit No. 135-25030 20500 Oversize Meter 135-49075 47035 47045 Fire Line 135-49900 135-49900 Total $ $ $ $ $ $ $ $ 11 of 148 Total apackamt2 skrolczyk Begin Date: 10/01/2020 End Date: 10/31/2020 • :•:•:•:•:•:•:•: .'.'.'.......'.'.'.' '.'.'.'.'.'.'.'. .•.•.•.•.•.•.•.•.•.•.•.•.• .•.•.•.•.•.•.•.•.•. 998 BROWN, ALOYSIA & tLAN Totals for Check: 6854 . . 998 . CAMON,. TRS:.:.:.:.:.:.:.:.:.:.:.: 998"CB JENI HOMES TROPIIY'CUA3 LLC" Totals for Check: 6856 Fran Ant: Trophy Club MJD No.1 AP Checks For Date/Amount Range .00 To Amt: 99,999,999.99 Date. Stat No mter . •-•11P44c.T:IPPWIT•'•:•:•.• • '•'• ......... • • • • • • • • • • • • •.•.• . . . . . . . . • • 100•":•;•:•94 164A".. 09/30;20.:*•'*P 135-20050- A/P Vendors 00 0 0 0 0 •••• :198 :C4 )ENI lighTS ThOPIW CU..0 LLC U00 Check: 6857:•:.: : : : : : : : : : • • • 998 CB JENI HOMES TROPHY CLUB LLC U001 Totals for Check: 6858 0 0 0 0 •:•:.: .998 DAVIS,-.JOEN M. TOtaLS for Check: 6859 X.: 998 DiftLieiN; Totals for Check: 6860 ::. 990. FRATfiNT,..GtE000Y:. 998 GUERRA, ERNEST" • Totals for Check: 6862 • 0 0 0 0 15209A 09/30/20 P •:•:•••:•:•• • :•••:•:•••:• •.•.• •.•.• 131100A 09/30/20 13' ••• ' "20050t999.7 • • 0 0 0 N11.011128-18172320 Regular Meeting Agenda PStiget 1 liatee:•:•:•:•:•:•thnher.•:•:•: Date : 119.97 • • "6854 10/05/20 • • 119.97 • A/P ::::•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•: • • A/P Vendors 13.36 133100A ::135-20050-000-000 ::::::::: • . . -• • • • • • • • • • 141100A 09/30/20 P 135-20050- U0010080594105A 09/30/20 P 135-20050- 03A 09/30/20" • P: 00/ 0, :100 00. 0 .000. %.H135-2 00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 • • -• • • • ... • •• • A/Pyen clars A/P Vendors A/P liendart " • " • " • " • • 1104A 09/30/20 • • ' • • ' • "135-20050000 000 " • " A/P Vendors . .998..•MOLLEY, J01-14. •:•:•:•:•:•:•:•:•/.....:•q0020040007.204A .09/30/20 .•P. . . .135-20050-000-000. A/P Vendors.... . . . .•.•.•.•.•.•. ..•.•.•.•.•.•.•.• %. • • • • • • • • 1•0•6•326jA. ci6/3too" • • • • • • . 135-20050-0 0 00 0 0 Totals for Check: 6864 0 0/ 0 0 0 24.16 6858 10/05/20 24.16 08.78 6859 10/05/20 08.78 71.46 71.46 49.42 49.42 30.51 30.51 03.49 6860 10/05a0 • • • • • • • .•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.• 6861 .10/05120 • *••••••••••••••• • • • • • •.•.•.•.•.•.•.•.... 6862 10/05/20 ::10/05/20::::::::::: • ••••••:•::::: '•••:::::::::•:•:::::: .....'.•.•.•. 00 0 0 : --:•••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••• 3262 • BRANDON R REED • • • • • 3093. • • • • • •09/30/20 • • P • • •30.i35.-550.306.3&000 • • • Naikeharice•&•RePairS • • • • • ."--j,86680. . 6866 10/05/20. ."'"'"'""'"'""'"'"" Totals for Check: 6866 3,380.00 ciTY PFF7PM- WORTH 08/.24)28% CheCk;:::: 6867 Totals for Check: 6868 ..•.•.•. .09/24/20.•.•P•.•..10:,.135-760150010t000:::::::.Whotesale:Wfater • • 09/2..4/20.•.ii••••••ili.•.13,55oilesji0000 • • • .• • • /21/20:•:•:f:•:•:• :•.•517,69005: •:•:•:•...Capital.Dutlays.-:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:. • • • • •.•.•.•.•.•••••••••••••••••••••••••••••••.•.•.•.•.•.•.•.•.... 3 063 2g 6867 10)'9/2° : : " 538.75 6868 10/05/20 538.75 " ".'.'.•.".'.•.'.'.'...... • ••:•••••••••:•:•:•:•:•:•:•:•:•:••••••••••••••:•:•:•:•:•:•:••••• ••••••••••• •• • •• ••••••••••••••••••••:•:•:•:•:•:•:•:••••••• : • • ••••:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:::::::::::•:•:•:•:•:•:::::::::::::::::::::•:•:•:•• 12 OT 148 • • •••••••• .....•.•.•.•.•.•.•.. • •.•.•.'. . • '•'• • • • • • • • • '•'•'• • • • ....•.•.•.•. apackamt2 skrolczyk Begin Date: 10/01/2020 End Date: 10/31/2020 • :•:•:•fther:•:•:•:•:•:•:•:•:•:•:•:::::::::• •:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•-• 1056. OFFICE DEPOT, INC • 1056 OFFICE DEPOT, INC 1056 OFFICE DEPOT, INC 3156 cectOORLABORktOkftS LLC Totals for Check: 6871 :-:•:•4AJML!tXX.-:•41:111•:•: . ................ 125335269001 09/24/20 126770434001 126779858001 ... Fran Ant: -30%%115-45.038.5430- 09/23/20 P 30 135-65085-030- 09/24/20 P 30 135-65085-030- 000 000 000 Trophy Club MUD No.1 AP Checks For Date/Amount Range .00 To Amt: 99,999,999.99 N11.011120-10,728120 Regular Meeting Agenda PStiget 2 ••••:•:•:•:•:::•:•:•:•:•:•:•:•:• :•:•:•%%%%%% • • :•:•.•:•:•:•:•:•:•:•:•:•: ••••••••• • OfficeOffice Supplies Office Supplies (8565) - 6870-16/05/26- 110.78 6870 10/05/20 16.86 6870 10/05/20 • • 200.0 51 09/30/20:.-:OH:::24:::.it4 4 09/28/20 " P 20 13555135020- • **- Lab itrietysie • " • 3411: 583.05 000 ::::.2696 TeoExavattcnSafetySysten20-18826 1.35-60040-030-000 '.-:-xServirwtha • • • • 1000 TROPHY CLUB MD (WATER BILLS) 09/30/20 .09/30/20 P 30 135-60025-030-000 Totals for Check: 6873 1087 WHITAKER CHALK SWINDLE • 4eiets for Check: 6874 2716 Wtss. jatmeY, E.stner Assoc Totals for Check: 6875 : 2943 JPMORCA . CHASE BM( Ni TotaLs for Check: 6876 • • • ..3686 • coohlkiiottaii6ii;.iii: Totals for Check: 6877 264377 08/31/20 P 39 135-55045-039- 09/09/26" • P" 20– 517-69005-020- 000 000 Legal " Capital OatTxlys" • " • " • ' • " 6871 • 10/05/20 • 6871 10/05/20 239.40 6872 10/05/20-: 239.40 %.29615" 6873 10/05/20 296.15 *-.1,367-.54: 6874 10/05/20 1,367..50• 2;885188' •••••&878i0105120.••'''''''' ••• 2,685.00 :::135-20060-000-000 : :Pr9L-tiremnt :Clearir9: . 6,784.85 : • • • : :•:•:•:•:•:•:•:•:•:•:•:•:-: • 6,784.85 •••••••••• ••••••••••••••••••••••• • • • • .•. TGIU20000 o 70-4 09/30/20 P 20 135-69005-020-oo Capital Outlayt' •••••••••••••"2,056.25 2,056.25 ••••••••••2635•••iiitetitieiii:Eis; • nic • • • • • • • • to3842686' • • • • 10/01/20 Totals for Check: 6879 000 • • 2676 Hunana Inc 155516898 10/01/20 P 135-21309- .. • - - • • ." " " " " . " °00:0 000 • • • • • • 2676 HUMana 155516898 10/01/20 P • • 10 • 135-50029018- • • • 000 2676 Humana Inc 2676 Humana Inc •• • Capital °Irtl-c?Ys--•• • •••••••:•::::::. •-• •••••••• ..'5Oft);Jare's*itUPPort ••• •••:•1161untei*:Life:•:::•••••• ...••••••••• ' • Life•IiiWreiite & Other • 155516898 10/01/20 P 20 135-50029-020-000 Life Insurance & Other 155516898 10/01/20 P 30 135-50029-030-00 0 Life Insurance & Other ••••.•••••.•••••••••••.•••.•••.• 6876 . 10/05/20 6877 10/05/20 • * ' '*•• ••• . • • • 750000""6879 10/05/20 7,500.00 220 45 6880 10/05/20 ::::::::::::368.2&:::6880.. • • • • 173.58 * 68843• 16/65/20 • • 209.88 6880 10/05/20 209.22 6880 10/05/20 • • • • ••••••••••••••••••••••• .'..•.•...•.•...•.•..•••••••••••••••••.•...•.•.•.•.•.•.•.... '.'.'.'.'.'.".'.'.'.'.•. 000 000 i0/15/2020— 10/01/20...15.%%.16%.13550029 -010 -000 10/15/2020 10/01/20 P 20 135 -50029 -020 - 10/15/2020 10/01/20 P 30 135-50029-030- 000 000 • • • Ltfe iitueake&other—..--. Life insurance & Other Life Insurance & Other 179.16 6881 10/05/20 197.79 6881 10/05/20 .....'.•.'.•• ....•.•.•.•• apackamt2 skrolczyk Begin Date: 10/01/2020 End Date: 10/31/2020 :::::::r1!::::rigiPP•ocw••••••••••• ".".2616. Humana 2676 Humana Inc 2676 Humana Inc for Check:. 6882 2655 Core & M.aiji LJ Totals for Check: 6884 3184 DATAPROSE LLC 3184 DATAPROSE : LLC : : : for Check: •6885 •:::•• .•:::::::•• .• 2606 Fisery Solutions, LLC Totals for Check: 6886 •••••••••11itaL4'fiai.:1:filik::*: :6887 • • • • • • • • Date::•Stat::N • ••• 155516898A 09/30/20% 155516898A 09/30/20 P 135 -21309 - 155516898A 09/30/20 P 10 1.35-50029-010- N093551 . . . . . . . . . . . . . . . • • " • " " " • • " • Fran Ant: r•:•:•:•:•:•:• :•:• •:• ••:•:•:•: •:•: :•: DP2003405 09/30/20 P 30 135-60035-030- 000 • • • DP2003405 09/30/20. : : P : : : 30 : 135,55205030,t00.0. 91782158 " " 09/30/20" " s' 30"135- .00,0 000 Trophy Club MUD No.1 AP Checks For Date/Mount Range .00 To Amt: 99,999,999.99 Vision Life Insurance & Other N11.0111:20-10,723120 Regular Meeting Agenda PStiget 3 • Da-te 38.06 6882 10/05/20 06.98 6882 10/05/20 23.10 6882 10/05/20 68.14 .".•.'.. 258.42 6884 10/ 258.42 ..'.'.'...'.'.'.'.'.'.'.'.'.. Postage 1,655.85 6885 10/09/20 730.91:-:•:•. 6885 10/09/20 •••*•:-:•:•:-:•:•:•: : : •2.386.76 Senate Charges & Fees 50.00" 6886 10/09/20 50.00 1058 1058 09/24/20 o o o ....... . . . . . . . . . . 2735 Jackson Walker LLP 1719690 Totals for Check: 6888 Totats for Check 88 3216 FB Networks 3216 M3 Networks • 1:S:•:tot.:-c-h:0-01t::•:.. "•••" •:::::::::••••••••:::••••••••••••• ••••••••••• • • • • 2643• •ildain•& • Lif..0.• • Totals for Check: 6891 09/01/20 P 10 520-69005-010 000 Capital Outlays • • • • .• • • er Services ..•.•.•.•.•.•.•.•. 6360 09/28/20 P 30 135 -65055 -030 - 6357 09/28/20 P 30 135-65055-030-000 000 •••••°9/2812....?:•1:!.. 000 Hardware Hardware :-.••Haraaare • 1,630,00 6887 10/09/20 2,379.00 6887 10/09/20 . 4,009:00 3,895.30 6888 10/09/20 3,895.30 •.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.• • 1.4/0.9,•20 3,589.00 6890 10/09/20 11,443.60 6890 10/09/20 ***•• ''''' • ''' 1,300.00 • • .•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.• ......•.•.•.•.•.•.•.•.•.•.• ::::::: ' ' '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' 226-.67: ................. • " • PiirtiltiO4ices kelikes 22:4422991177 6893 100920 Totals for Check: 6893 : • : : 3156 : :OXIDOR: :080RATORIES LLC : • : • • : : :20 : • : : : 09/30/20 : : P • • . . 20 : • :1355513570207000 : : : • Lab : : • : • 3156 0X1D LP8ATUES LLC 20100083 09 30 20 P 20 135-55135-020-000 Lab Analysts 3156 OX]DOR LM�ATORIES LLC 20100088: • • • 3156• batiik• iisittiii-akits.•Lt • • • • • • • • • ' 69/Ed/Zo• • • ti• • • to• • 3.35iE--ci2o 0 o• • • .....i..66.•kriksti••••••• • • • • • • • • • • •••• Totals for Check: 6894 000:C 0 000:: 583.05 • . :•••••••• .....'.•.•.•. ....•.•.•.•. apackamt2 skrolczyk Begin Date: 10/01/2020 End Date: 10/31/2020 Fran Ant: • • • • •••••:•••:•:•::::::::* * * * ::•:. • No: :••• ••• . . . . . . . . . . • . • • . • . .•.' .•.•.•..... . 2698 Rite Safety, LLC " 6010056 09/01/20 :0 20 135 -65010 -020 - Totals for Check: 6896 0 0 0 0 0 0 •••••• • '•:•••••••••••••:-.•:•' '•'•: 2977: :vittutept:wo-ms: •:• • •:•:•:94100 • •••••••••::::09/30/20:::::p:::::• •• Totals for Chick: 6899 .•.'.•.•.'. 2222 AFLAC PR00708 996 10/02/20 P 3.35-23312- 000 0 0 0 Trophy Club MUD No.1 AP Checks For Date/Amount Range .00 To Amt: 99,999,999.99 :::::1:4:20..:F.:T!..14011.:•:•:•:•:• • • • • • • • •". • • ••• ••• : :•:•:•:•:•:•: Uniforms • • • • " N11.011129- 10,72E120 Regular Meeting Agenda PStkjet 4 . . . .•. • • •.•.•. • ••••••••••••••• Value • Nurbei,:•:•: Date • • 224.20 6896 10/09/20 224.20 Advertising. . 6897 10/09/29 • • .1•6:411-Stiiiiii Drainage • • • • • • • • • • • • • • • 40152.58 • • 6898 10/09/26 • • • • • Refuse 66,050.92 6898 10/09/20 Totals for Check: 6900 •.. •.•:•:•:•:::::•: ::::::•:•:•:-. •:•:•• : 3193. CO:yRIPAY;•:*;:::::•:•:•:•:•:•:-:•:•:-:•:•: :p.F38068. : . : : : .• ............. • • • • • • • .•.•...•.•...•...•......•.........•...•.• 3124 IRS Tax Payment PRO0708 996 10/02/20 P 135 -21302 - 3124 IRS Tax Payment FX708 996 10/02/20 P 000 000 Totat for (heck 6902 :•:•:•:•:•:•: :-:•: : 3167 KEYSTONE PARK SECRETARIAL Totals for Check: 6903 164487 •:•:•:•tokati•for.:triEjok.:•:•:6904•:•:•••••••:•:•:•:•:•:•:•:•:•:•:•:•:•:•.•••. :•:•:•:••••••••••••:•••••:•:••••••••••••:•: :•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•••. 10/01/20 P 30 135- ••••• : ••••• .000 0 0 0 -030- 000 000 •:•:•:•:•:•:•:•:•: Refuse Tax . . . . . . . . . . . . . . . . . . . . . . . . .:.:.:.:. • : • • Aflac 5,417.75 6898 10/09/20 .::::342.;??;47:::::::::::::::::::::::::::::::::::::::::::::::::::::' ....•••••• :::::.::.:: .. .. . .. ....... .. .. . .. . :.: : :••••• 41:461;j7 6400.* :::::::•:.: : • • • • • • • 210.67 6900 10/09/20 210.67 Cafe 125-Medtcal. . :•:::•:•:::•:•::: . -..:6901-:-10/09/20-.-:- • • • • • • • • • • • . ••••••• ••••••••••• . • .-.•••••••••••••••. FIC Taxes 5,021.50 6902 10/09/20 :Social.Methcare .40/09/20 Taxes 1,493 22 6902•••••1.0 '' • • • • ••• ••• ••• • ••• • • • ••• ••• : ••••••: : : : : : Telephone ••• '•'•.•.•.•.•.•..... • ••:•:•:•:•:•::::::::::•::: 194.75 6903 10/09/20 194.75 :•:10 •:•:•:•:•:•:•:•:•:•:•:• 2760 NDS Leasing 69649900-1 10/01/20 P 30 135-69170-030-000 Copier Lease Installments 175.00 6905 10/09/20 Totals for Check: 6905 175.00 Totats for dieck 906••••:•:•:•:•:•.• . • • •3•:-:•:•:-:•:•:-:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:-./853 50 .••••••••••••••••••••••••••••.•:•:-:•:•:-:••• • 3249 PNC Bank, N.A. Totals for Check: 6907 •.• tatali foi.: • : :6gog: :•:•:•:•:•:•:•:•:•:•: : 943353 1001 TOWN OF TROPHY CLUB Totals for Check: 6909 • ..-.-...-.-...-.-.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•... 10/01/20 P 45 122-69305-045- 0 0 0 Capital Leases .23;3.17'.400t000:•:•:•••• • •••••••••••:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•: . • • • 100120 10/07/20 P 45 122-60337-045-000 Transfer to Town/Fire Budget • ' •••••••• . . .•.•.•.•.•.•.'. . 127,148.60 6907 10/09/20 127,148.60 • ••:•:•::•:::•::•:•:•:•:: •:•:0•737;•38:•:•:• . :•:•: 8;7 •- ••••• •• • .• • .• •• .•.•.•.•.•.•. •:•:-:•:•:•:• •.•.•.•.•.•.• .•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.• ...•.•.•.•.•.•.•.•.•.•.•.•. 68,335.58 6909 10/09/20 68,335.58 ..•.•.'.•.".'.•.'.'.. '•••:::::::::•:•:::::: .....•.•.•.•.•.•.•.. ....•.•.•.•. apackamt2 skrolczyk Begin Date: 10/01/2020 End Date: 10/31/2020 '•'•:•:•:•:•:•:•:•:•:•:•:•:• : • : • : •:•:• .""io,dtl-s for Check: •6910 Fran Ant: •.• ..... ..•.•.•••.•••••.••••• 1468 L.H. CHP1EY MATERIALS INC 174667A 09/30/20 P 20 135-55125-020- . :rptplsfor . 1081 TRX C�I'JTY ELECIRR 77675909 09/30/20 Totals for Check: oft- Trophy Club MUD No.1 AP Checks For Date/Amount Range .00 To Amt: 99,999,999.99 -:-:•:-:-:•:-.•.-:-:•:-:-:•:•:•:•.• •••••••••••••••••••••••••••••••••••••••••••• • • •••••••••••••••••••••• N11.011120 -10,72E120 Regular Meeting Agenda PStiget 5 :•:•:•:•:•: :•:•:•:•:•:•:•:•:. Dunpster Services 1,292.70 ••••••••••••••:•••••:•:•:•:•:•:•:•:::::::::::::::::::::::::::::•:•:•:•:- • • • • •••••• • • • 6911 10/16/20 /16(a 3193 COPFUPAY, INC. PRO0709 996 10/16/20 P135 -21313 - 000 000 Cafe 125 -Medical Rehab 549.37 6913 10/19/20 – ................................. . •.' ' • ' ••• ' • • * • • • • • 2775 HUDSON ENERGY SERVICES, LLC 2010015125 10/09/20 P 30 135-60020-030- 000 •:::::::::2775:::11qp5ONENERGY.:SEEKCES-,•:LLC•:•:•:2010015125:•:-.10/09/20:•:•P•H.10135760020-.0107000: .2775 IWS�J ENEROY:$000*(0$;.:04:A01000.0$40/09/20:H:011$;! .... -020- ... ENERGY:SERVICE%::LLC:$20101500a-37:10/09/20::4:30*I3540020430400: 2775 HUDSON ENERGY . SERVItES,LLCS2dio 1-37 10/09/20P""1013560020010 • • 1-37 10/09/20 P 20 135-60020-020- 2775 HUDSON ENERGY SERVICES, LLC S2010 Totals for Check: 6915 3.834 IDEXX DISTRIBUTION, INC 1834 IDEXX DISTRIBUTION, INC 1834 IDEXX DISTRIBUTION, INC •-..x.x1834.:•IDEXX DISTRIBUTION,.INC • .. •.. -• miC 1834 IDEXX DISTRIBUTION, INC Totals for Check: 6916 ":::::::::::: 3124 IRS Tax Payment " " ' ' " 000 000 .00 0 000 000 000 Electricity/Gas : Electricity •:::*Ebadeicity/Gas. irk* Electricity • 3072321.1.90 1D/02/20.P20X13.5.4504541120-000: Lab Su lies 3072321.190 • 1::-135-65045-020-000:•:•:.- Lab Supplies 3072321190 10/02/20 P 20 135-65045-020- Lab Supplies 3072321190 10/02/20 P 20 135-65045-020- Lab Supplies 3072321190 10/02/20 P 20 135-65045-020- Lab Supplies P . Lab Supplies . . . . .630.16 1:!:::*:J4,!0.0045-020- Lab SuPPlies:: .Fi:.::Ar:•:135-65045-020-000.::::::' Lab Supplies 1 271 91 0"135-65045-020- %.". Lab Supplies ""' """ P 20 135-65045-020- Lab Supplies 143.14 3,226.54 000 000 000 533.07 6915 10/19/20 00.00 6915 10/19/20 00.00 6915 10/19/20 ... 6915 10/19/20 ' 11,336:71%. 6915 10/19/20 11,173.32 6915 10/19/20 23,043.10 00.00 1/20 00 6916 10/ 0 •••• . • 19,2 229.33 6916 10/19/20 00.00 6916 10/19/20 6916 • .% 6916 10/19/20 6916 10/19/20 3072321174 10/02/20 ::::.:30244.1.4 10/02/20 ::A072321174. 10/02/20. 3072:E21174 10/02/26.'. 3072321174 10/02/20 ".00o0704 946.16/i6/20 000 000 000 000 • • • • • • • • • 000 SoctatSecurityTax 645862 :00.00 mentat Taket• • • " • • .13510:44.. Totals for Check: 6917 12,993.11 03420..IP :::::::::::::::::::::::::::::::::::::•• :•:•::•::: : :::•:::•::•:•::•:•::•:•:•:•:•:•:•:•:•:•::•:•::•::::::: • 1466 POLYNE; INC• • 1488598. • • 10/09/20 P 26 3:3:5650*620- Totals for Check: 6919 .•.•.•.•.•.•.•.•.•.•.• :••••••• 000 000 ::Pqm.POW:WTIPPP:::::•::: • - • • • • • %%%%%%%:•:•:•:•: . 135-55080rM000. •:. • Maintenance • • • • ...-:•:•:-:•:•:-:•:•:•:•:•:•: :•:•:•:•::*:':':':':':':':*:*:':':':*:* .-.'.'.-. '-:•:•:•:•:•:•:•:•:•: :•••••••••••• ••••••••. 6917 .10/19/20— . . . . . ......................... . . . • 10/19/20:': • 2,856.60 ....•.•.•.•. apackamt2 skrolczyk Begin Date: 10/01/2020 End Date: 10/31/2020 From Amt: Jkflter Date Stat No Nuther 3176 REY4IAR CONSTRUCTION " " TELECONT1 LINE 10/01/20. P 10 135-55080-010 3176 REY-MAR CONSTRUCTION 24 SKYLINE MAMH 10/01/20 P 20 135-69005-020-00 REY-MAR CONSTRUCTION 24 SKYLINE MAAH 10/01/20 P 20 135-69005-020-3176 00 CONSTRUCTION••••••:•:•:•:•:•: : 24.1W XING. : : : : 10/.01420 : . P : 20 : 135-69005-020-00 3176 REY4IAR 0NSTRUTI0N :.:.: 24 TW .IW 6 • • ..6:-4..,1$6600$4.6 : Total.s for Check: 6921 • • • • • .•.•.•.•.•.•.•.•.•.-.•.•.•.•: • 3113 TCDRS PR00709 996 10/16/20 P Totals for Check: 6922 • : • 000 1481 ThL TBG VE1'I1IAL RIS( 1481 TML DITERGOVERFIThTAL RIS1( Totals for Check: 6923 4-2021 • .. 2021: 10/01420 P. .•.•:•.•.•.•: 3243 WIN -911 SOFTWARE 20201228 Totals for Check: 6924 2653 Dubois Bryant Canpbell LLP 109599 Totals for Check: 6925 2713 OpenGov, Inc INV -005110 •.:•••••.:.::31702:RBY.4.142:1:C1NETRUCTICIN::::••••.:::ClikOili:• • Totals fOr Check: 6927 •••••••••••••••••••• • • 2440 TARRANT CTY PUBLIC HEALTH LAB 34215 . 2440 TARRANT CTY PUBLICHkALTH..LAB 34216. ..::::::TOtal:S40.:Cbeck: 6928 . : • -::•:•::•:: • • • 1087 iPilETAKER tNALK -..• • • Totals for Check: 6929 135-21317- 000 000 .12241202000 - NO i* -142/412-0004 ("/ 10/01/20 P 30 135-55030-030- 000 09/30/20 P 517-69005-°2°-®0 : • ••• Trophy Club MUD No.1 AP Checks For DateAknount Range .00 To Amt: 99,999,999.99 ,.•.•:•:•:•:•:•:•:•:•:•:•:•:•:•:•: • Matriteilaike& Repairs - Capital Outlays Capital Outlays . Capttal. �ttLays 3, 00 6921 10/19/20 N11.011120- 1%72E120 Regular Meeting Agenda PStaget 6 :•:•:.:• : : NOrber•:•:•: Date: •••'• '.'3,42500 6921 10/19/20 3,812.00 6921 10/19/20 00.00 6921 10/19/20 RIM 8,961.37 8,961.37 .'.'.'.'..'.'.'.'.'.'.'..'.'.'.'..'.'..'.'.'....'........ 6922 10/19/20 • .::Ippir-414et 11.207.7.:468;35 2,..47 6923 10/1.9/204 Software & Support 495.00 6924 10/19/20 495.00' 255.00 09/03/20 P 30 135-55030-030-000 Software & Support 5,147.50 6926 10/19/20 . . . . . . .•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.• 09/30/20 P 10 135-55135-010- 000 09130120 P. 10 3.35-55135-030-001 • : '••:::::: : 09/30/20 P 39• 13555045-039000 - .BenefitMall .::•:•:•:•:•:•:•:•:•::::::::::. 9050630 -IN 3197 BeneftlU 9050610 -IN 09/30/20 20 135.50029-020-000 3197 866eftiftia::: .....••••••••••••••••••• .9050630 -IN 09/30/20 1' 30 135-50029-030-000 Totals fee Chetk:6930 • • " • ' • • " 1030 CITY OF FORT WORTH 9/30/20 -IMPACT 09/30/20 P : : : : CITY:OF FORT.hORTH:.: • P TutaL for Check 6931 . :•:•:•:•:•:•:•:::•:::::::::::::::::::::::::: 135-20500.135-2 - 7 7 Ytii 64/02/.0. P 10 520-69085-010-000 2738 Community National Title LLC 995 09/30/20 P 10 520-69005-010-000 Totals for Check: 6932 Lab Analysis ....Lab Analysis.for.PID.... • •:•:•:•:•:•:•:•:::•:•.•:•:•:•:•::•:•:•:•:•:•:•:•:•:•:•:•:•:.. • • ••'•••••••:•:•:• 56,127.97 220.00 1;626.00 1,626.00 Ltfa Insurance & Other 16 00 ' • " 68..00 • 6928 10/19/20 • • .•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.• ••••••••••••••••••••••••••••••••• ••:•:•:•:•:•:•:•:•:•:•:•:•:•:•: " • :•:•:•:•:•:•:•:• •:•:•:•:•:•:•:•:•:•. • • • • •.•.•. .•.•.•. . • • • • • • •.•.•.•.• • 692910/19/20 • • • • • • • 6930 10/28/20 6930 10/28/20 6930 10,28/20 Fort Worth ;Atter -Impact Fees 26,376.00 6931 10/28/20 Fort Inbrth Viater7Inpact Fees (1i400.00):::.:691,..:10iq:8(20 24,976.00• • • • ..... Capital. outlays.. • • • 424:44 Capital Outlays 1,079.47 6932 10/28/20 2,004.46 :•:•:• 5.5120;1 •.•.•...•.•.•.•.•.• -.•:•:-:•:-:-:•:-:•:•:-:•:•:•:•:•:•:•:•:•:•:•:•:-:-:•:-: • • .....•.•.•.•.•.•.•.. ....•.•.•.•. 3186 ER'S BUILDING MAINTENANCE TC2009TOIJD 09/30/20 30 135 -55120 -030 3186 MBIBER'S BUILDING MAINTENANCE TC2009TCMJD 09/30/20 P 10 135 -55120 -010 - Totals for Check: 6933 000 000 Trophy Club MUD No.1 AP Checks For Date/Amount Range .00 To Amt: 99,999,999.99 I.,10.0101 'OF. TROPPFCCUEu.'•'•'•':':*:*:':': • • • • • : • • •• • • • • -0••• • • • • • • ••••: ..• •:•:.hT4'.:00.;:.?,..14:::::•:•••:•:•:•:•:•:•••••••••••••••••••••••••:•:•:••••••••••••••• • ••:•:•:•: .•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•: ..................................... .00 . 0 0/ 0 000 • cleaning Servtce Cleaning Services N11.01140-10,722020 Regular Meeting Agenda PStiget 7 .............. • • • • • I,89692 87.50 6933 10/28/20 2,071.92 0 0 0 000 000 6935 10/28/20 6935 10/28/20 • • • • 6936 6936 10/214,i20.%%%--%%%. 3,964.51 6936 10/29/20 4,448.91 6936 10/29/20 1,091.09 6936 10/29/20 11,754.51 .• . Totals for Check: 6937 210.67 . .•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.• 00.00 6938. 10/29/20 125 00 6938 10/29/20 150.00 6938 10/29/20 ""*"--- 00.00 6938 10/29/20 00.00 6938 10/29/20 ':'00;00:*: 6938 ''' ----•••••270-00 • 6941,10/29/20:-:.. 140 04 6941 10/29/20 •.•.•.•... 767005271-20 10/19/20 P 10 135-65030-010-000 Chemicals . . .'.•.'.•. agackuut2 skrolczyk Begin Date: 10/01/2020 End Date: 10/31/2020 3258 FIlANOTYR-P80TAIiiA, INC. Totals for Check: 6943 Fran Put: :•:.: :•:•.:• •: •:•: :•: R1104649555 10/16/20 II, 23560035030 Trophy Club MUD No.1 AP Checks For Date/Amount Range .00 To Amt: 99,999,999.99 : • ". • : • "• "• " • "• " • " • "• " • : • : • :• : • : • : • : • : • :• • • N11.011120- 1E1,72S120 Regular Meeting Agenda PStiget 8 : • : •: • : • : •Nrsiber : :Datp : • . 10L67• 6943 16Z24/26 107.67 : HACH COPPANY: : : .::10:135765030-(40-000 13fl IO1 C)PN1Y 12257387 10 09 20 P 10 135-65030-010-000 Chm.ca1.s 324 30 6944 10/29/20 id/24m : " " • 2372' HAM CaTNIY 000 1372 HACH COMPANY 12157387 10/09/20 P 10 135-65030-010- 000 Chemicals 88.16 6944 10/29/20 Totals for Check: 6944 896.56 2943 JF0fflf CHAH( 1020 10/26,20 lotal.s for Check: 6945 1468 L.H. CHANEY MATERIALS, INC. 176492 1468 L.H. CHANEY MATERIALS, INC. 176478 135-2o006 • Ooo 10/24/20 P 20 135-55125-020- 10/17/20 P 20 135-55125-020- 000 000 Totals for Check: 6946 ..•.•.•.•.•. •••••••••••• •.•.•.•. • " -"•" : • : • : : • : : : • : : • : Dragster Services Duster Services 3195 LOU'S GLOVES INCORPORATED 10/20/20 P 20 135-65040-020- Safety Equipment .....•.•.•.•.•.•.•.•.•...•.•...•... ••%%% ••••••••••• • • •.••• • ••• • • ••• • • • • • • • • • ........•.•...•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•.•. -.•.•.•.•.•.•.•...•.•.•.• • • TotaLs for Check: -6949 " • - 0 :0.0 3156 OXIDOR LABORATORIES LLC 20100196 • • • • • 3156. OXIDOR LMLLC.•.•xx.:•-.20100303.•.•.• •:•:-:•:-:• • • - ----- - -------- ....... .•.-. 455:-0XTP41:000RATORT5 LLC : : 2010035 3156 OXIDOR LABORATORIES LLC . : 20100422 , 3156 • •Cokbalt li800ot00 akE8 • lit . .............. Totals for Check: 6950 000 10/13/20 P 20 135-55135-020-000 Lab Analysis 10/15/20' PX-X29X:13575513579?P700XJ-0-M4Y0-::::: • -'•10/19/20H:P::::::20.::••155-55.1.3502000 ,! .:::::::::: 40:MaLysts 0 10/22/20 P 20 135-55135-020-000 Lab Mal.ysts • • 10/26/20' • " 20 • 13555135- 000 -020 • ' • * 'Leh Analysts • • • • • " • " " ' " • ' :::::::-:•3276: :FR0 FIRE .&:8PRINCLJER :Lit • :. x •:•:-:8757:::::. :::::. :::::: :::•10. ft:•:•:•30:•:•135550130030000-:•••••:. Maiirtenance & Rpatrs :::::•tOilVs:Ergt Check::695i,: :•:•:::•:•:-:::::::::::::•:-:-:•::::::::::::•:•:•••••-•••••••••••:••••••• • • ••••:-:•:•:-:•:•:-:•:•:-:•:-:-:•:-:-:•:•:::•:•:-••••• ••••• ••• ...: ........... .•••••:•.....•••••••• ' -:•:-..-:•:-:::-:-:-:-•-:-:-:-:•:-:-:•:-:-•••••:••••:•:••••:•••••:•••••:•••• • : ::::::::::::::::::::•:•:•:•:•:•:•:•:•:•:•:•:•:::::•:•:•:•:•:•:•:•:•::••••••:•:•: .. 2648 RLC Controls 8285 10/22/20 P 20 I35 -55080 -0200.00 .• NeintenlicCe&RegirS:.:.:.:.:%%'....% Totals for Check: 6952 :30/29120 • :•••:•:•:•::.: 83066;00:.:: 1,066.40 6946 10/29/20 2,101.80 6946 10/29/20 3,168.20'. : : : : ' 17.44 252.00 6948 10/29/20 • . • . • . • .•. . . . • . • . • . • . • . • . • . • . • . • . • . • . • . • . • . • • • : • • • : • • . • . • . • . • • • . . . . . . • .• . • . • . • .• . • .• 341.55 6950 10/29/20 ..x.:•241.50.... 6950 10/29/20 .. . 6950 10/29/20 ...•.•.•.•.•.•.. x241.50 6950 10/29/20 •%%%%%%%%%'.. : • : • • ' • : • : • : : • : • : : • : • : • : • : : • : • : • 341.55 6950 10/29/20 1,507.65 •:.: :•:.: 260.68 : • 330.00 330.00 P00.(119Yeger Fleet systems 8693381.U043 -2..10/24/2G. ::::::::::3275:::115:000K:VoYager Fleet SYstens 86.93301:11043.4.2::10/24a0:: •.• -.tatati fii:thedk: 6953 ..... 2634 Valley Solvent Company, INC 62743 Totals for Check: 6954 :::::::::::•:•:•:•:::•:•:•:::•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•::::::-•••••-•••••••:•:•:•:•:•:•:•: ••••••:•:::: P :10:::135-65005010t000... Fuel. & Lube P 20 135-65005-020-000 :: FueL & Lube 10/15/20 P 20 135-65030-020- Chemicals ;,030-•• :•:ititritenailite•* •.•.• •.• • • • . . . . . • . • .• . • .• . . "• : • : • :• : • :• . . .'.•.'.• •*•••• • 6952 10/29/20 :524.19 6953 10/29/20 640:07 6953 10/29/20 1,174 26 :•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•.• 717.50 6954 10/29/20 717.50 . . . . . • . • .• . • . . apackamt2 skrolczyk Trophy Club MUD No.1 AP Checks For Date/hnount Range Begin Date: 10/01/2020 End Date: 10/31/2020 From ABC .00 To Amt: 99,999,999.99 : • : • :VRA, :VR1UI 1!1.01111:: : • : • • : :•:•:•:•:•:•: • •-•Date::::stcif • •No •Ntmter ............ •.•.•.•.•.•.•.•.•.•.•.•.• .•.•.•.•.• .... ............ • ••••••3116 • MO FIRE & SPRINKLER LLC 8758 " 135-55080-030-::: Totals for Check: 6955 Maintenance & Henairs' " • N1101120-10,728020 Regular Meeting Agenda PStiget 9 . . Value Nunber •• • •:••• . • •••••• 319.28 6955 10/29/20 477.12 • : 2655 : COre :41: Main: : : • : • : • : • • : : : :135.755080,.010:-.000 : : Maintenance: :6•: 6956 • • • :: : :10 . • • • • • • • • : : 738.00: 2746 DFW Compressor LLC 1011 Total..s for Check: 6957 • • • 2763 Novotx 1971 • Totals for Check: 6958 10/26/20 P 20 135-55080-020-000 Maintenance & Repairs 695.09 6957 10/30/20 •-•.-:•••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••• ••••••••••••••••:-:-:-:-:-:-:.:-:-:.:-:-:-:-:-:-:-:.:-:-:.:-:-:-:-:-:-•-:.:-:-..:09=PB.:-:.: • *-•-•.,.-:-:.:-:-:-:-:.:-:-:.:-:-:-:-:-:-:-:.:-• • • ".•-•.,..:-:-:-:-:-:-:-:.: • • •-•.-:-: •:*:':•:*:•:•:':::.:.• • •':•:::::::•:':•:•:':•:*:•:•:*:•:•:*: • • • :*:':::•-'•••••••••••••••'•••••'-:.:.•-•.*-:-:.:-:-:.:-:.:.'-•::.:.:.:-:....-..:.....:.:.. -:.:-:-:.:-:.:-:-:.:-:-:.:-:-:-:-:.:-:- -:::-:.:-:-:::- ... : • • ':••••'•••••••••••••••':'::.:•::•::::.:.:::::::.:.:.::::-•••,- • • • '.'-'.•,•-• •-•••.' -•.'•••••'-•••••••.:•••:::::::::::::: ••••*::::..... .. /.0i7./2§:.::::ji.:::::: '• • ..,.0307.. -iiil:.04.6:cliii::::•:.•.:::.•......• • .:•:::,H *40,f05..po :r?c45.8.:::• :•.:•:::.• • • • • • .•.•.•.......•.•.•.•.•.•.•.•.•.•. ...•.-...•.-. 1238 NORTH TEXAS PUMP CO. 14814 10/05/20 P 20 135-55080-020- .: Tcrtals for Check: 6959 .•:•:•.•: 1056 OFFICE DEPOT, INC 130609281001 10/16/20 P 30 135-65085-030-000 o 0: o o o 1056 OFFICE DEPOT, INC '•' '• 1 10/16/20 'P" 30 135 -65085 -030 - Totals for Check: 6960 0 0 0 0 0 0 Maintenance & Repairs 920.00 6959 10/30/20 : ..6960 10/30/20 .............. 292.55 • TotaLs for ch6cis!•:•: : • • • • • ........ ............... ............... ............ ............ .................. ............................. . ....... .............. ............... ........... 1973 TX COMMISSION ENVIROMEITAL QU 1" 10/12/20 P "20 135-60135-020-000 TCEQ Fees & Permits Totals for Check: 6962 9,888.02 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . '• . ' :•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:•:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: AAAAAk End of Report AAAAAAAAk ••••••••••:••••••..•:•:•:•:•:•:•:•••:•:•:•:•: ' • • • • . • .• .•. . • '. • :• : • : • :• : • : • :• : • : • :• • . . . . . • .• . • .• . • .• . • .• . . . . . . . . . . . . : • .• : • : • : • :• • • • • • • • • • • : • : • : • : • : : • : • : • : • : • : • • • : : • : • : : • :• : : • : : • : • : : • :• : • :• : • : • ' • : • : • :• : • :• . . .•.'.• . • . • . • . • .• . • . • . • . • .• . • . • . • . • .• . • . • . • . • .• . • . • . • . • .• . • .•. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . - • • • • • • • • • • • • • - - • - • • - . • . • . . • . • . . • . • . • . • . • . • . • • • : : : : • : • • • • . . . • . • .• . • .• . • . . . . . . . • .• . • . . . . . . . • . • . • . • . . . . . . . • . • .• . • . . . • . • .• . • . • . • . . . . . . • . • • • • . . . . . . • . • . • . • . . . . . • . • . • . • . • . . . . . . . • . • .• . • . . . . . . . • . • .• . • . . . . . . . . • . • . • .• . • . . . . . . . • . • .• . • . . • ' • • • • • • • • • . • . • • . • . • . • . • . • . • . • . • . • . • . . . . . . . . . • • • • • .. • . • . • . • . • . • . • ... • • .. CASH STATUS AS OF OCTOBER 2020 135-10250 TexPool 0 & M (XXXXX0002)-General Fund Operating *** 135-10300 Prosperity Bank (XXX8701) General Fund Operating 135-10305 Prosperity Bank Reserve -Savings Acct (XXXXX7724) 135-11100 Petty Cash Administration 135-11150 Petty Cash Utility Billing 137-10250 TexPool 0 & M (XXXXX0002) GASB Replacement 517-10250 TexPool Construction Tax (X)XXX011) WWTP Improvements 517-10300 Prosperity Bank Construction WWTP Improvements 519-10250 Texpool Revenue Bond Construction (XXXXX015) SWIFT 519-11155 Cash -Bond Escrow Bank of Texas (SWIFT) 520-10250 Texpool Revenue Bond Water & Waste Water Systems 2019 (XXXXX018) 520-11155 Cash -Bond Escrow Bank of Texas (Water & Waste Water Systems) 528-10250 TexPool Revenue Bond Reserve (XXXXX014) WWTP Improvements 533-10250 TexPool Tax I & S (XXXXX0003) 533-10300 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) *10/31/2020 Customer Water Deposits $311,040 Fire Department Cash 122-10250 TexPool 0 & M (XXXXX0002)-Fire Operating Cash 122-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 (FY2020 Capital Projects plus prior year carry forward) Unassigned Fund Balance Current Year Revenue/Expenses Total Nonspendable, Assigned & Committed Fund Balances - General Fund 135 21 of 148 November 16, 2020 Regular Meeting Agenda Packet Restricted - Unable to be spent $0 $311,040 $1,845,227 $0 $0 $2,007,484 $486,413 $0 $0 $784,973 $258,888 $3,892,557 $893,969 $51,561 $0 $80,613 $30,534 $34,985 $10,678,244 Unrestricted - Available for spending $3,479,185 $2,953,044 $0 $150 $450 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $6,432,829 1 $0 1 $6,432,829 $6,432,829 $367,311 $0 $367,311 l $367,311 $367,311 Total in Accounts (Restricted & Unrestricted) $3,479,185 $3,264,084 $1,845,227 $150 $450 $2,007,484 $486,413 $0 $0 $784,973 $258,888 $3,892,557 $893,969 $51,561 $0 $80,613 $30,534 $34,985 $17,111,073 General Fund 135 Available 2,953,044 Prosperity General Fund 3,479,185 Texpool General Fund 600 Petty Cash 6,432,829 3,486 2,404,829 6,763,058 (43,114) $9,128,258 $367,311 $0 $367,311 November 16, 2020 Regular Meeting Agenda Packet Combined Financials Fiscal Year 2020 YTD as of 09/30/2020 Adopted Budget vs YTD Actuals Revenues & Expenses ■ YTD Expenses ■ YTD Revenues lip.■ Amended Expenses 'M Amended Revenues Adopted Expenses • Adopted Revenues $8,891,690 $9,915,457 $9,964,572 $10,645,077 $1,733 5156,584 0% 2% YTD Expense By Departments YTD Expense- Water YTD Expense- WW D Expense -Admin D Expense- BOD D Expense- Non Dept Water Budgeted vs Actual 160,000,000 140,000,000 120,000,000 100,000,000 80,000,000 60,000,000 40,000,000 20,000,000 Water Consumption Adopted Budget vs Actual 120,945,000 65,006,642 46,315,229 59,031,249 150,840,000 116,075,000 80,821,519 63,077,077 - 142,212,000 45,293,105 100,098,564 40,324,983 41,014,000 44,023,000 36,442,000 31,000,000 O Oct 56,252,000 34,047,000 134,074,841 129,995,809 - 106,694,878 103,800,567 78,084,000 91,409,000 —0—Budget —0—Actual Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep 1,200,000,000 1,100,000,000 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 974,534,461 942 343 000 Total Water Consumption • Budgeted Water Consumption ■ Actual Water Consumption Presented by: Finance Department $900,000 $800,000 $700,000 $600,000 8500,000 8300,000 $200,000 $100,000 80 Water Revenue Adopted Budget vs Actual 5643,772 5810,322 5676,884 5532,482 5779,30 $834,475 $668,268 $448,477 $421,318 $434,80 5353,442 5347,093 8400000 5536,379 5330,533 5348,071 5308,154 $282,378 5296,300 5390,375 $616,408 5459,564 5661,284 —0—Budget Revenue —0—Actual Revenue Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep 87,000,000 $6,000,000 85,000,000 $4,000,000 83,000,000 82,000,000 81,000,000 $0 Adopted Budget Total Water Revenue Vs Projected Total Water Revenue $6,599,484 $5,765,931 53,771,913 Total Water Revenue $3,846,328 • Budgeted Total Revenue • Actual Total Revenue • Net Budget Total Revenue Minus Budgeted Expenses • Net Projected Total Revenue Minus Actual Expenses 22 of 148 November 16, 2020 Regular Meeting Agenda Packet GASB Capital Project Balances 10/01/2020 Fund 135 General Fund Total Spent Total JE Project Non Spendable Year Adopted Original Assigned Carry Over Assigned FY 2021 Additions FY 2021 Amendments Total Assigned Status FY 2021 Remaining Transaction Assets not in spendable form (Prepaids) $8,486.00 Capital Projects Fund 135: Water Sundance Ct/Meadowbrook Ln (Town) 2018 $169,000.00 $49,579.40 Valve Replacement 2020 $50,000.00 $50,000.00 $50,000.00 Water Line Replacement 2020 $500,000.00 $480,650.00 $500,000.00 Fencing 2020 $10,000.00 $10,000.00 $15,000.00 Engineer Master Plan of Improvements 2021 $100,000.00 $100,000.00 $100,000.00 RRA/ERP 2021 $75,000.00 $75,000.00 $75,000.00 $49,579.40 $100,000.00 $980,650.00 $25,000.00 Carry Over Carry Over Carry Over Carry Over Wastewater Legal/WWTP 2018 $175,000.00 $218,040.81 $150,000.00 LS 81 Upgrade/Engineering 2019 $30,000.00 $65,272.92 LS Upgrades (Lights, Control Panels, Quick Connects) 2019 $75,000.00 $63,337.00 LS Pumps 2020 $20,000.00 $12,443.60 Telemetry Upgrades 2020 $30,000.00 $30,000.00 Lift Station Fencing 2020 $5,000.00 $5,000.00 $5,000.00 Manhole Rehab and Replacement 2020 $22,500.00 $22,500.00 Paving Road and Driveway WWTP 2020 $125,000.00 $125,000.00 Aeration Pump for MBR's 2021 $30,000.00 $30,000.00 $30,000.00 Engineer Master Plan of Improvements 2021 $100,000.00 $100,000.00 $100,000.00 WWTP Fencing Replacement 2021 $50,000.00 $50,000.00 $50,000.00 $368,040.81 $65,272.92 $63,337.00 $12,443.60 $30,000.00 $10,000.00 $22,500.00 $125,000.00 Carry Over Carry Over Carry Over Carry Over Carry Over Carry Over Carry Over Carry Over Admin MUD Boundaries 2019 $35,000.00 $11,337.46 Board Room Upgrades 2020 $100,000.00 $48,668.08 CMMS 2021 $50,000.00 $50,000.00 $50,000.00 Website Rebuild 2021 $35,000.00 $35,000.00 $35,000.00 Pavement and Driveway Repair 2021 $20,000.00 $20,000.00 $20,000.00 Fleet Replacement 2021 $33,000.00 $33,000.00 $33,000.00 $11,337.46 Carry Over $48,668.08 Carry Over Total $8,486.00 $1,191,829.27 $1,213,000.00 $2,404,829.27 $49,579.40 $0.00 $100,000.00 $0.00 $980,650.00 $0.00 $25,000.00 $0.00 $100,000.00 $0.00 $75,000.00 $368,040.81 $0.00 $65,272.92 $0.00 $63,337.00 $0.00 $12,443.60 $0.00 $30,000.00 $0.00 $10,000.00 $0.00 $22,500.00 $0.00 $125,000.00 $0.00 $30,000.00 $100,000.00 $50,000.00 $11,337.46 $0.00 $48,668.08 $0.00 $50,000.00 $35,000.00 $20,000.00 $33,000.00 $2,404,829.27 $0.00 GASB Fund 137: 09/30 Balance 10/01 Additions I FY 2021 Balance I Assign/Unassign GASB Replacement -Town Elevated Tank $270,000.00 $45,000.00 $315,000.00 JE 8241 GASB Replacement -Water $430,899.00 $30,000.00 $460,899.00 GASB Replacement -Sewer $528,703.58 $30,000.00 $558,703.58 GASB Replacement- Sewer MBR's $100,000.00 $100,000.00 $200,000.00 GASB Replacement -Fire Truck $391,461.39 $81,420.00 $472,881.39 'Total $1,721,063.97 $286,420.001 $2,007,483.971 23 of 148 GASB Capital Project Balances 9/30/2020 Fund 135 General Fund Protect Non Spendable Year Adopted Original Assigned Carry Over Assigned FY 2020 Additions FY 2020 Amendments Assets not in spendable form (Prepaids) Reserve for Budget deficits 58,486 00 Capital Projects Fund 135: Water Pump VFD for Water Plant 2017 5370,00000 569,70793 50.00 Pump Discharge Head 2018 $50,000 00 550,00000 50.00 Quick Connects Fire Hydrants 2020 55,00000 55,000.00 Beacon Meter Software 2018 511,012.00 511,012.00 59,000.00 Indian Creek and Phoenix (Town) 2018 5410,00000 532,74925 50.00 Sundance Ct/Meadowbrook Ln (Town) 2018 5169,000.00 5138,086.20 50.00 Valve Replacement 2020 550,00000 560,000.00 Water Line Replacement 2020 5500,000.00 5500,000.00 Fencing 2020 510,00000 510,000.00 Fleet Replacement 2020 541,000.00 541,000.00 20' Line Stops and Gate Valves 2020 569,875 00 569,875.00 Well 01 2020 50.00 $0.00 50.00 Straight Creek/Carnourtie 2019 5275,00000 5000 Wastewater Lift Station 1 Relocation Study 2018 510,000 00 57,222 92 -57,222.92 527,696 17 558,645 00 51,259.00 LS gl Upgrade/Engineering 2019 530,00000 530,00000 537,222.92 Legal/WYVrP 2018 5175,000.00 5117,386.22 5150,000.00 LS Upgrades (Lights, Control Panels, Quick Connects) 2019 575,000.00 537,647.00 550,000.00 LS Pumps 2020 520,000.00 520,000.00 55,00000 Spare Part Inventory 2020 525,000.00 525,000.00 In -Plant Water System 2019 5100,000.00 5132,911.60 $0.00 510,410.40 Blower Curtains/Sound Wall 2020 513,000.00 513,000.00 562,000.00 Hose Upgrades MBR 2020 55,000.00 55,000.00 Belt Press Belt 2020 55,000.00 55,000.00 -55,000.00 Telemetry Upgrades 2020 530,000.00 530,000.00 Lift Station Fencing 2020 55,000.00 55,000.00 WWTP Fencing Replacement 2020 550,000.00 550,000.00 Manhole Rehab and Replacement 2020 522,500.00 522,500.00 Paving Road and Driveway WWTP 2020 5125,000.00 5125,000.00 Admin Board Room Upgrades MUD Boundaries Security Improvements Phase 3 Building Maintenance Pavement and Driveway Repair Total 58.436.01$ 2020 5100,00000 5100,000.00 2019 535,000.00 535,000.00 50.00 2020 525,000 00 525,000.00 2020 550,000.00 550,000.00 2020 520,00000 520,000.00 -550,000.00 535,000 00 5661,723.12 51.410.375.00 5145,010.57 Total Assigned $9],404 10 550,00000 $5,00000 520,012.00 532,749.25 Finished Finished Finished Finished Finished Status $138,086 20 550,00000 5500,000 00 510,00000 Carry Over Carry Over Carry Over Carry Over 541,000 CO 569,875.00 $58,645 00 51,259.00 L 5000 $67,222 92 5267,386.22 587,647.00 525,000.00 Finished Finished Finished Finished Finished- Combined with LS 21 Upgrade/Engineering Carry Over Carry Over Carry Over Carry Over- added $5k from belt press November 16, 2020 Regular Meeting Agenda Packet Total $Rent Total 9/15/2020 16 Total As.' d TotalA0 ', ed FY 2020 Remaining 18 Transaction Transaction Remad1e RemalJlp 9/1 / 020 9/3 2020 597,403 85 50.25 537,843.67 512,156.33 54,85852 5141.48 517,972.00 52,040.00 520,591.13 512,158.12 588,506 80 549,579.40 50.00 550,000.00 519,35000 5480,650.00 5000 510,000.00 569,874.48 50.52 -569,875.00 558,645 00 50.00 -558,645 00 51,259.00 $0.00 -$1,259. -597,40810 50.00 5000 5000 -512,980.67 -537,019.33 537,019.33 5000 -55,000 Da 50.00 50Do 5000 -520,012. 50.00 50.00 5000 -532,7 50.00 50.00 5000 -587,60680 -5900.00 550,47940 549,57940 5000 50.00 550,000.00 550,000.00 -51,35000 -518,000.00 5498,65000 5480,65000 5000 50.00 510,000.00 510,00000 50.00 50 00 50 00 50.00 50.00 5000 $0.00 50 00 50 00 50.00 50.00 5000 $1,95000 549,345.41 524,31000 512,556.40 50. Do $65,2]2.92 5218,040.81 563,337.00 512,443.60 50.00 50 00 5000 -51,300 00 -5650.00 565,922 92 565,272 92 -548,07041 -51,275.00 5219,315.81 5218,04081 424,310.00 $0.00 563,337.00 563,337.00 -512,556.40 50.00 512,443.60 512,443.60 -52,617.85 52,617.85 50.00 50.00 50.00 5000 50.00 50.00 50.00 50.00 50.00 50.00 50.00 50.00 50.00 50.00 50.00 530,000.00 530,000.00 50.00 $0.00 55,000.00 55,000.00 -550,000.00 $0.00 50.00 $0.00 50.00 $0.00 522,500.00 522,500.00 5000 $0.00 5125,000.00 5125,000.00 525,000.00 5143,322.00 575,000.00 55,000.00 50.00 Finished Finished Finished Finished Finished- project closed 520,657.15 5142,23091 571,496.00 54,861.09 54,342.85 51,091.09 53,504.00 5138.91 $0.00 -522,382.15 -5143,322.00 -575,00000 -55,00000 5000 530,000.00 55,000.00 550,00000 522,500.00 5125,000.00 Carry Over Carry Over Finished Carry Over Carry Over 5100,00000 Carry Over 535,000.00 $25,000 CO 50.00 555.000 00 Carry Over Finished Finished- 15k into main & repairs & 35k into pavement & driveway Finished ego 058.00 551,331 92 523,662.54 111- $24,984 2] 556.12] 97 530,000.00 55,000.00 522,500.00 5125,000.00 548,668.08 -58,63455 -542,697.37 591,36545 548,66808 511,337.46 -522,555.02 -51,107.52 512,444.98 511,337.46 50.00 5000 5000 50.00 50.00 50.00 -555,000.00 555,000 00 50 00 $15 ]3 $0.00 -51.127.9] -525, 52,217,108.69 $989,830.1f 51,227,278.58 4866,012.351 -5159.267.07 51.351.096.34 51,191,829.27 1 GASB Fund 137: 10/01 Balance 09/15 Additions 09/30 Balance Assign/Unasslgn GASB Replacement -Town Elevated Tank $2]0,00000 50.00 $2]0,00000 GASB Replacement -Water 530,000 00 5400,899.00 5430,899 00 GASB Replacement -Sewer 5127,804.58 5400,899.00 5528,703.58 GASB Replacement- Sewer MBR's 5100,00000 50.00 5100,00000 GASB Replacement -Fire Truck 5391,461.39 50.00 5391,461.39 !Total 5919,265.97 6001.798.06 51,721,063.97 24 of 148 November 16, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - FIRE DEPARTMENT BALANCE SHEET OCTOBER 2020 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 367,311 PREPAID EXPENSES 18,140 ADVALOREM PROPERTY TAXES RECEIVABLE 1,194,770 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE TOTAL ASSETS 1,580,220 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 25 of 148 1,194,776 1,194,776 652,065 (266,622) 385,444 1,580,220 November 16, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40010-000-000 122-40011-000-000 1 122-40020-000-000 Property Taxes/MUD Fire 1,246,877.00- 1,246,877.00 - Property Taxes/Fire-Delinquent Property Taxes/Fire P&I 9,008.84- 2,902.88- 20.28- 9,008.84- 2,902.88- 20.28- .723 1,237,868.16- 2,902.88 20.28 Page Subtotal: 1,246,877.00- 1,246,877.00- 11,932.00- 11,932.00- .957 1,234,945.00 - Program number: 1,246,877.00- 1,246,877.00- 11,932.00- 11,932.00- .957 1,234,945.00 - Department number: Fire Revenues - 1,246,877.00- 1,246,877.00- 11,932.00- 11,932.00- .957 1,234,945.00 - Revenues Subtotal 1,246,877.00- 1,246,877.00- 11,932.00- 11,932.00- .957 1,234,945.00- 26 of 148 glbase_tbam skrolczyk 17:58 11/11/20 Fund: 122 Trophy Club MUD Fire Dept. Account Description 122-60030-045-000 122-60055-045-000 122-60337-045-000 11111e2total: 122-69009-045-000 122-69195-045-000 122-69305-045-000 Subtot Program number: Expenditures Rent And/Or Usage Insurance Transfer to Town/Fire Budget Short Term Debt -Interest GASB34/Reserve for Replacement Capital Leases Fund number: 122 Trophy Club MUD Fire Dept. Trophy Club MUD No.1 Budget Summary with Amendment Department: 45 Fire Period Ending: 10/2020 Adopted Amended Total Budget Budget Encumb. 197,281.00 21,000.00 820,027.00 197,281.00 21,000.00 820,027.00 1,038,308.00 J11110,308.00 6,127.00 81,420.00 121,022.00 6,127.00 81,420.00 121,022.00 208,569.00 27 of 148 Current Month 1,649.06 68,335.58 69,984.64 6,126.73 81,420.00 121,021.87 .24 .24 .24 .24 November 16, 2020 Regular Meeting Agenda Packet Program: YTD Total 1,649.06 68,335.58 6,126.73 81,420.00 121,021.87 % of Budget 7.853 8.333 99.996 100.000 100.000 22.340 Remaining Budget 197,281.00 19,350.94 751,691.42 .27 .13 968,323.76 266,621.24 - Page 2 glpdatb2 skrolczyk 17:58 11/11/20 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Account: 122-40010-000- 179 10/09/2020 Property Taxes 180 10/12/2020 Property Taxes 183 10/15/2020 Property Taxes 184 10/16/2020 Property Taxes 188 10/20/2020 Property Taxes 189 10/21/2020 Property Taxes 190 10/22/2020 Property Taxes 192 10/23/2020 Property Taxes 193 10/26/2020 Property Taxes 194 10/27/2020 Property Taxes 195 10/28/2020 Property Taxes 196 10/29/2020 Property Taxes 197 10/30/2020 Property Taxes November 16, 2020 Regular Meeting Agenda Packet Trophy Club MUD No.1 Page 1 Detailed Accounting Trial Balance Department: Fire Revenues Program: Period Ending: 10/2020 JE Detail Beginning Transaction Transaction Vendor Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) Property Taxes/MUD Fire (253.00) (253.00) GL (538.30) (791.30) GL (957.15) (1,748.45) GL (511.60) (2,260.05) GL (780.25) (3,040.30) GL (349.14) (3,389.44) GL (216.73) (3,606.17) GL (544.95) (4,151.12) GL (1,004.78) (5,155.90) GL (1,218.66) (6,374.56) GL (917.00) (7,291.56) GL (525.51) (7,817.07) GL (1,191.77) (9,008.84) GL Account: 122 -40010 -899 -:.Property Taxes/MUD Fire Totals: (1,246,877.00) Budgeted (1,237,868.16) Remaining 1 % Used Account: 122-40011-000-00 177 10/05/2020 Property Taxes 178 10/07/2020 Property Taxes 188 10/20/2020 Property Taxes 192 10/23/2020 Property Taxes 194 10/27/2020 Property Taxes 196 10/29/2020 Property Taxes Account: 122 177 10/05/2020 Property Taxes 192 10/23/2020 Property Taxes 194 10/27/2020 Property Taxes 196 10/29/2020 Property Taxes Account: 122-40020-000-000 Department Totals: Property Taxes/Fire-Delinquent (49.32) (49.32) GL 331.81 282.49 GL (3,153.40) (2,870.91) GL (9.42) (2,880.33) GL (18.24) (2,898.57) GL (4.31) (2,902.88) GL Property Taxes/Fire-Delinquent Totals: .00 Budgeted 2,902.88 Remaining Property Taxes/Fire PRI 0 % Used (10.89) (2.83) (4.56) (2.00) Property Taxes/Fire P8I Totals: .00 Budgeted (11,932.00) Monthly Total 20.28 Remaining 0 % Used (10.89) (13.72) (18.28) (20.28) (11,932.00) ** (1,246,877.00) Budgeted (1,234,945.00) Remaining 1 4 Used 28 of 148 GL GL GL GL November 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 2 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60030-045-000 Account: 122-60030-045-000 197,281.00 Budgeted Account: 122-60055-045-000 Insurance 128 10/01/2020 Insurance/Wrk Comp Expense Oct Account. 60055-045-000 .00 .00 197,281.00 Remaining 0 % Ueed 21,000.00 Budgeted 19,350.94 Remaining efer to Town/Fire Budget 43 10/08/2020 October A/P October Fire admin Account: 122-60337-045-W Transfer to 820,027.00 Budgeted 751,691.42 Remaining Account: 122-69009-045-000 Ilk Short Term Debt -Interest 46 10/08/2020 Sep Out Int/Prin Fire Trk FY21 Seperate Interest in Cap Lease Account: 122-69009-045-000 Short Term Debt -Interest 6,127.00 Budgeted 1,649.06 8 % Ueed a 68,335.58 Used .27 Remaining 100 % Used Account: 122-69195-045-00d for Replacement 130 10/01/2020 GASB Reserve Transfers FY 2021 Fire Truck Future Replacement Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: 81,420.00 Budgeted .00 Remaining Account: 122-69305-045-00 Capital Lease 43 10/08/2020 October A/P lease payment 46 10/08/2020 Sep Out Int/Prin Fire Trk FY21 D ladder -T681 100 % Used 6,126.73 81,420.00 1,649.06 68,335.58 TOWN OF TROPHY CLUB 6,126.73 81,420.00 81,420.00 8 127,148.60 (6,126.73) 127,148.60 121,021.87 PNC Bank, N. GL 6909 AP 6907 GL GL AP GL Account: 122-69305-045-00 Capital Lea 121,022.00 Budgeted .13 Remaining 100 Ueed 29 of 148 November 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 3 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department 45 Totals: 278,553.24 ** 278,553.24 Monthly Total 1,246,877.00 Budgeted 968,323.76 Remaining 22 % Used Fund 122 Totals: 266,621.24 266,621.24 Monthly Total .00 Budgeted (266,621.24) Remaining 0 % Used 30 of 148 TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET OCTOBER 2020 November 16, 2020 Regular Meeting Agenda Packet 135 137 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 3,264,084 3,264,084 CASH IN BANK -SAVINGS -CASH RESERVE 1,845,227 1,845,227 INVESTMENTS-TEXPOOL 3,479,185 2,007,484 5,486,669 PREPAID EXPENSES 102,195 102,195 ADVALOREM PROPERTY TAXES RECEIVABLE 130,720 130,720 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,186,415 1,186,415 TOTAL ASSETS 10,008,426 2,007,484 12,015,910 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 130,720 130,720 ACCOUNTS AND OTHER PAYABLES 438,438 438,438 CUSTOMER DEPOSITS 311,040 311,040 TOTAL LIABILITIES 880,198 880,198 FUND BALANCE NON -SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 2,404,829 2,404,829 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 315,000 315,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT 460,899 460,899 ASSIGNED FUND BALANCE/SEWER REPLACEMENT 558,704 558,704 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 472,881 472,881 ASSIGNED FUND BALANCE/WWTP MBR REPLACEMENT 200,000 200,000 UNASSIGNED FUND BALANCE 6,763,058 6,763,058 COMMITTED FUND BALANCE NET REVENUES / EXPENDITURES (43,144) (43,144) TOTAL FUND BALANCE 9,128,229 2,007,484 11,135,713 TOTAL LIABILITIES AND FUND BALANCE 10,008,426 2,007,484 12,015,910 31 of 148 November 16, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 Page 3 17:58 11/11/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 135-40002-000-000 135-40015-000-000 135-40025-000-000 Property Taxes 136,531.00- 136,531.00- 986.32- 986.32- .722 135,544.68 - Property Taxes/Delinquent 300.00- 300.00- 321.43- 321.43- 107.143 21.43 Property Taxes/P & I 300.00- 300.00- 2.27- 2.27- .757 297.73 - PID Surcharges 163,725.00- 163,725.00- 163,725.00- 135-47000-000-000 Water 5,932,489.00- 5,932,489.00- 135-47005-000-000 Sewer 3,677,146.00- 3,677,146.00- 135-47025-000-000 Penalties 112,608.00- 112,608.00- 135-47030-000-000 Service Charges 16,550.00- 16,550.00- 135-47035-000-000 Plumbing Inspections 750.00- 750.00- 135-47045-000-000 Sewer Inspections 2,500.00- 2,500.00- 135-47070-000-000 TCCC Effluent Charges 50,000.00- 50,000.00- 135-49011-000-000 135-49016-000-000 135-49026-000-000 135-49075-000-000 135-49900-000-000 Subtot Program number: Department number: Revenues Interest Income Cell Tower Revenue Proceeds from Sale of Assets Oversize Meter Reimbursement Miscellaneous Income Revenues 9,792,043.00- 9,792,043.00- 100,000.00- 100,000.00- 14,146.00- 14,146.00- 5,000.00- 5,000.00- 8,232.00- 8,232.00- 7,000.00- 7,000.00- ,2 521,135.86- 230,388.79- 7,657.60- 2,000.00- 14,039.20- 775,221.45- 2,015.19- 1,178.81- 187.11- 521,135.86- 230,388.79- 7,657.60- 2,000.00- 8.784 6.265 6.800 12.085 14,039.20- 28.078 299,545.98- 5,411,353.14- 3,446,757.21- 104,950.40- 14,550.00- 750.00- 2,500.00- 35,960.80- 7.917 9,016,821.55- 2,015.19- 2.015 1,178.81- 8.333 187.11- 2.673 3,381.11- 779,912. 779,912.58- Subtotal 779,912.5 7.626 32 of 148 97,984.81- 12,967.19- 5,000.00- 8,232.00- 6,812.89- 9,447,31 7,984.81-12,967.19-5,000.00-8,232.00- 6,812.89- 9,447, 9,447,364.42- 9,447,364.42- November 16, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 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 FSubtotal: Salaries & Wages 365,309.00 365,309.00 23,007.66 23,007.66 6.298 342,301.34 Overtime 17,000.00 17,000.00 1,698.29 1,698.29 9.990 15,301.71 Longevity 5,435.00 5,435.00 5,435.00 Certification 6,000.00 6,000.00 200.00 200.00 3.333 5,800.00 Retirement 36,520.00 36,520.00 3,983.96 3,983.96 10.909 32,536.04 Medical Insurance 86,182.00 86,182.00 5,225.04 5,225.04 6.063 80,956.96 Dental Insurance 4,933.00 4,933.00 316.63 316.63 6.419 4,616.37 Vision Insurance 789.00 789.00 48.18 48.18 6.106 740.82 Life Insurance & Other 3,289.00 3,289.00 303.83 303.83 9.238 2,985.17 Social Security Taxes 24,412.00 24,412.00 1,540.62 1,540.62 6.311 22,871.38 Medicare Taxes 5,709.00 5,709.00 360.31 360.31 6.311 5,348.69 Unemployment Taxes 1,080.00 1,080.00 34.41 34.41 3.186 1,045.59 Workman's Compensation 10,877.00 10,877.00 901.29 901.29 8.286 9,975.71 Pre-emp Physicals/Testing 400.00 400.00 400.00 Employee Relations 300.00 300.00 300.00 530,614.78 568,235.00 568,235.00 37,620.22 135-55005-010-000 Engineering 20,000.00 20,000.00 20,000.00 135-55080-010-000 Maintenance & Repairs 124,000.00 124,000.00 4,050.86 13,284.36 17,335.22 13.980 106,664.78 135-55085-010-000 Generator Maint. and Repair 3,000.00 3,000.00 3,000.00 135-55090-010-000 Vehicle Maintenance 5,000.00 5,000.00 1,042.09 1,042.09 20.842 3,957.91 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 3,500.00 135-55120-010-000 Cleaning Services 1,000.00 1,000.00 1,000.00 1,000.00 100.000 135-55135-010-000 Lab Analysis 7,500.00 7,500.00 4,066.06 433.94 4,500.00 60.000 3,000.00 1 135-60010-010-000 Communications/Mobiles 7,500.00 7,500.00 135-60020-010-000 Electricity 123,487.00 123,487.00 112,150.29 11,336.71 123,487.00 135-60066-010-000 Publications/Books/Subscripts 1,000.00 1,000.00 516.00 516.00 135-60070-010-000 Dues & Memberships 500.00 500.00 135-60080-010-000 Schools & Training 7,426.00 7,426.00 135-60090-010-000 Safety Program 400.00 400.00 135-60100-010-000 Travel & per diem 2,875.00 2,875.00 135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 135-60135-010-000 TCHQ Fees & Permits 30,000.00 30,000.00 135-60150-010-000 Wholesale Water 2,596,295.00 2,596,295.00 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 135-60280-010-000 Property Maintenance 3,000.00 3,000.00 135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 750.00 135-60332-010-000 Interfund Transfer Out -Rev I&S 565,820.00 565,820.00 51,438.13 135-60334-010-000 Interfund Transfer Out 75,000.00 75,000.00 135-60360-010-000 Furniture/Equipment < $5000 2,500.00 2,500.00 54,579.12 33 of 148 100.000 51.600 54,579.12 2.102 750.00 5.085 51,438.13 9.091 7,500.00 484.00 500.00 7,426.00 400.00 2,875.00 1,500.00 30,000.00 2,541,715.88 200.00 3,000.00 14,000.00 514,381.87 75,000.00 2,500.00 Page 4 glbase tbam skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Period Ending: 10/2020 Account Description Adopted Amended Total 135-65005-010-000 Fuel & Lube 135-65010-010-000 Uniforms 135-65030-010-000 Chemicals 135-65035-010-000 Small Tools 135-65040-010-000 Safety Equipment 135-65050-010-000 Meter Expense 135-65053-010-000 Meter Change Out Program 135-69005-010-000 135-69008-010-000 135-69009-010-000 135-69195-010-000 135-69281-010-000 Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Water Tank Inspection Contract Budget Budget Encumb. 15,000.00 15,000.00 5,190.00 5,190.00 25,000.00 25,000.00 1,200.00 1,200.00 1,000.00 1,000.00 70,000.00 70,000.00 87,000.00 87,000.00 740,000.00 740,000.00 30,962.00 30,962.00 2,324.00 2,324.00 75,000.00 75,000.00 108,000.00 108,000.00 8,818.23 Current Month Program: YTD Total 118,619.96 230,770. 524.19 1,520.23 1,678.33 8,818.23 3,722.75 7,140.40- 50,470.55 75,000.00 ,140.40- 125,470.55 November 16, 2020 Regular Meeting Agenda Packet 524.19 1,520.23 10,496.56 43,330.15 75,000.00 % of Remaining Budget Budget 3.495 29.292 41.986 6.136 14,475.81 3,669.77 14,503.44 1,200.00 1,000.00 70,000.00 87,000.00 5.855 696,669.85 30,962.00 2,324.00 100.000 108,000.00 12. Page Program 2,945.04 34 of 148 300,193.87 423,138 November 16, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 Page 6 17:58 11/11/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 10/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis for PID 2,000.00 2,000.00 1,120.00 80.00 Subtotal: 2,000.00 2,000.00 1,120.00 80.00 Program number: 1 Lab Analysis for PI1111111111 2,000.00 2,000.00 1,120.00 80.00 Department number: Water 5,327,164.00 5,327,164.00 124,065.04 300,273.87 35 of 148 1,200.00 1,200.00 1,200.00 424,338.91 60.000 800.00 60.000 800.00 60.000 800.00 7.966 4,902,825.09 November 16, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 Page 7 17:58 11/11/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2020 Account Description Adopted Amended Total Current YTD % of Budget Budget Encumb. Month Total Budget 135-50005-020-000 Salaries & Wages 483,633.00 483,633.00 135-50010-020-000 Overtime 33,000.00 33,000.00 135-50016-020-000 Longevity 7,420.00 7,420.00 135-50017-020-000 Certification 8,100.00 8,100.00 135-50020-020-000 Retirement 49,358.00 49,358.00 135-50026-020-000 Medical Insurance 122,035.00 122,035.00 135-50027-020-000 Dental Insurance 6,443.00 6,443.00 135-50028-020-000 Vision Insurance 1,098.00 1,098.00 135-50029-020-000 Life Insurance & Other 4,725.00 4,725.00 135-50030-020-000 Social Security Taxes 32,993.00 32,993.00 135-50035-020-000 Medicare Taxes 7,716.00 7,716.00 135-50040-020-000 Unemployment Taxes 1,440.00 1,440.00 135-50045-020-000 Workman's Compensation 14,607.00 14,607.00 135-50060-020-000 Pre-emp Physicals/Testing 400.00 400.00 135-50070-020-000 Employee Relations 300.00 300.00 FSubtotal: 773,268.00 773,268.00 135-55005-020-000 Engineering 30,000.00 30,000.00 135-55070-020-000 Independent Labor 15,000.00 15,000.00 135-55080-020-000 Maintenance & Repairs 108,000.00 108,000.00 135-55081-020-000 Mainten & Revairs Collections 157,500.00 157,500.00 135-55085-020-000 Generator Meant. and Repair 10,000.00 10,000.00 135-55090-020-000 Vehicle Maintenance 4,000.00 4,000.00 135-55091-020-000 Veh Maintenance Collections 13,000.00 13,000.00 135-55105-020-000 Maintenance-Backhoe/SkidLoader 3,000.00 3,000.00 135-55120-020-000 Cleaning Services 1,500.00 1,500.00 135-55125-020-000 Dumpster Services 100,000.00 100,000.00 135-55135-020-000 Lab Analysis 40,000.00 40,000.00 135-60010-020-000 Communications/Mobiles 7,500.00 7,500.00 135-60020-020-000 Electricity 157,735.00 157,735.00 135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 135-60070-020-000 Dues & Memberships 300.00 300.00 135-60080-020-000 Schools & Training 4,991.00 4,991.00 135-60090-020-000 Safety Program 1,000.00 1,000.00 135-60100-020-000 Travel & per diem 1,575.00 1,575.00 135-60105-020-000 Rent/Lease Equipment 5,000.00 5,000.00 135-60125-020-000 Advertising 2,500.00 2,500.00 135-60135-020-000 TCEQ Fees & Permits 45,000.00 45,000.00 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 135-60280-020-000 Property Maintenance 5,000.00 5,000.00 30,458.64 30,458.64 1,552.50 1,552.50 625.00 625.00 5,259.20 5,259.20 7,739.58 7,739.58 430.81 430.81 69.78 69.78 389.04 389.04 1,983.69 1,983.69 463.95 463.95 36.86 36.86 1,218.11 1,218.11 50,227 50,227.16 786.75- 5,256.73 1,500.00 94,616.54 31,170.85 146,150.09 36 of 148 1,448.50 366.50 5,383.46 2,829.15 28 11,555.18 113.75 9,888.02 6.298 4.705 7.716 10.655 6.342 6.686 6.355 8.234 6.012 6.013 2.560 8.339 4,469.98 4.139 1,448.50 36.213 366.50 2.819 1,500.00 100,000.00 34,000.00 100.000 100.000 85.000 157,705.27 99.981 113.75 2.279 9,888.02 21.973 Remaining Budget 453,174.36 31,447.50 7,420.00 7,475.00 44,098.80 114,295.42 6,012.19 1,028.22 4,335.96 31,009.31 7,252.05 1,403.14 13,388.89 400.00 300.00 30,000.00 15,000.00 103,530.02 157,500.00 10,000.00 2,551.50 12,633.50 3,000.00 6,000.00 340,215.02' 7,500.00 29.73 200.00 300.00 4,877.25 1,000.00 1,575.00 5,000.00 2,500.00 35,111.98 450.00 5,000.00 November 16, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60285-020-000 135-60331-020-000 135-60332-020-000 135-60334-020-000 135-60360-020-000 Lawn Equipment & Maintenance Interfund Transfer Out -Tax I&S Interfund Transfer Out -Rev I&S Interfund Transfer Out Furniture/Equipment < $5000 135-65005-020-000 Fuel & Lube 135-65010-020-000 Uniforms 135-65030-020-000 Chemicals 135-65031-020-000 Chemicals Collections 135-65035-020-000 Small Tools 135-65040-020-000 Safety EQuipment 135-65045-020-000 Lab Supplies FSubtotal: 135-69005-020-000 135-69008-020-000 135-69009-020-000 135-69195-020-000 Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement FProgram number: Department number: Wastewater 14,000.00 14,000.00 114,681.00 114,681.00 688,005.00 688,005.00 75,000.00 75,000.00 2,000.00 2,000.00 1,124,937.00 1,124,937.00 12,500.00 12,500.00 6,280.00 6,280.00 25,000.00 25,000.00 17,500.00 17,500.00 1,200.00 1,200.00 1,200.00 1,200.00 28,000.00 28,000.00 1,680.00 335,000.00 335,000.00 81,273.00 81,273.00 8,532.00 8,532.00 130,000.00 130,000.00 3,026,690.00 3,026,690.00 890.00 10,425.55 62,545.87 35.90 146,150.09 .4.27 650.07 5,282.50 3,574.10 3,999.00 9,281.50 252.00 4,563.88 9,040.05 49,636.25 7,624.00 331,568.48 37 of 148 130,000.00 307,629.82 890.00 10,425.55 62,545.87 35.90 241,604.36 650.07 8,856.60 252.00 8,562.88 18, 57,260.25 130,000.00 639,198.30 Mm - 6.357 13,110.00 9.091 104,255.45 9.091 625,459.13 75,000.00 1.795 1,964.10 21.4'W 883,332.64 5.201 11,849.93 6,280.00 35.426 16,143.40 17,500.00 1,200.00 21.000 948.00 30.582 19,437.12 19.984 17.093 277,739.75 81,273.00 8,532.00 100.000 21.119 367,544.75 2,387,491.7 2,387,491.70 Page 8 glbase_tbam skrolczyk 17:58 11/11/20 Fund: 135 MUD 1 General Fund Account 135-50045-026-000 Description Workman's Compensation Trophy Club MUD No.1 Budget Summary with Amendment Department: 26 Board of Directors Period Ending: 10/2020 Adopted Amended Total Current Budget Budget Encumb. Month 30.00 30.00 .79 Program: YTD Total November 16, 2020 Regular Meeting Agenda Packet .79 % of Remaining Budget Budget 2.633 29.21 Page 9 Subtotal: 30.00 30.00 .79 .79 2.633 29.21 135-60066-026-000 135-60070-026-000 135-60075-026-000 135-60080-026-000 135-60100-026-000 135-60245-026-000 Publications/Books/Subscripts Dues & Memberships Meetings Schools & Training Travel & per diem Miscellaneous Expenses 150.00 750.00 1,300.00 4,000.00 5,000.00 2,000.00 150.00 750.00 1,300.00 4,000.00 5,000.00 2,000.00 89.50 89.50 6.885 150.00 750.00 1,210.50 4,000.00 5,000.00 2,000.00 Subtotal: 13,200.00 13,200.00 89.50 89.50 .678 13,110.50 Program number: 13,230.00 13,230.00 90.29 90.29 .682 13,139.71 L Department number: Board of Directors 13,230.00 13,230.00 90.29 90.29 .682 13,139.71 38 of 148 November 16, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 626,592.00 626,592.00 34,634.24 34,634.24 5.527 591,957.76 135-50010-030-000 Overtime 2,000.00 2,000.00 2,000.00 135-50016-030-000 Longevity 2,668.00 2,668.00 2,668.00 135-50020-030-000 Retirement 58,550.00 58,550.00 5,753.10 5,753.10 9.826 52,796.90 135-50026-030-000 Medical Insurance 136,834.00 136,834.00 7,970.17 7,970.17 5.825 128,863.83 135-50027-030-000 Dental Insurance 7,109.00 7,109.00 441.96 441.96 6.217 6,667.04 135-50028-030-000 Vision Insurance 1,138.00 1,138.00 65.60 65.60 5.764 1,072.40 135-50029-030-000 Life Insurance & Other 4,730.00 4,730.00 407.01 407.01 8.605 4,322.99 135-50030-030-000 Social Security Taxes 39,138.00 39,138.00 2,093.70 2,093.70 5.350 37,044.30 135-50035-030-000 Medicare Taxes 9,153.00 9,153.00 489.64 489.64 5.350 8,663.36 135-50040-030-000 Unemployment Taxes 1,440.00 1,440.00 1,440.00 135-50045-030-000 Workman's Compensation 1,573.00 1,573.00 128.50 128.50 8.169 1,444.50 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 500.00 135-50070-030-000 Employee Relations 8,000.00 8,000.00 78.83 78.83 .985 7,921.17 Page 10 899,425.00 899,425.00 135-55030-030-000 135-55070-030-000 135-55080-030-000 135-55085-030-000 135-55120-030-000 135-55160-030-000 135-55205-030-000 Software & Support Independent Labor Maintenance & Repairs Generator Maint. and Repair Cleanin7 Services Professional Outside Services Utility Billing Contract 126,854.00 126,854.00 15,000.00 15,000.00 40,000.00 40,000.00 10,000.00 10,000.00 15,000.00 15,000.00 104,925.00 104,925.00 9,000.00 9,000.00 7,152.75- 985.00 15,000.00 7,417.73 33,166.94 26,014.19 20.507 3,561.68 4,546.68 11.367 75.00 15,075.00 100.500 57,876.00 57,876.00 55.159 582.27 8,000.00 88.889 100,839.81 15,000.00 35,453.32 10,000.00 75.00- 47,049.00 1,000.00 135-60005-030-000 Telephone 9,680.00 9,680.00 2,760.00 440.91 3,200.91 33.067 6,479.09 135-60010-030-000 Communications/Mobiles 3,000.00 3,000.00 225.00 225.00 7.500 2,775.00 135-60020-030-000 Electricity/Gas 14,512.00 14,512.00 13,978.93 533.07 14,512.00 100.000 135-60025-030-000 Water 5,000.00 5,000.00 320.10 320.10 6.402 4,679.90 135-60035-030-000 Postage 30,000.00 30,000.00 19,332.05 1,775.62 21,107.67 70.359 8,892.33 135-60040-030-000 Service Charges & Fees 67,000.00 67,000.00 600.00 8,020.93 8,620.93 12.867 58,379.07 135-60050-030-000 Bad Debt Expense 1,500.00 1,500.00 1,500.00 135-60055-030-000 Insurance 84,000.00 84,000.00 6,724.87 6,724.87 8.006 77,275.13 135-60066-030-000 Publications/Books/Subscripts 1,000.00 1,000.00 1,000.00 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 100.00 100.00 1.667 5,900.00 135-60075-030-000 Meetings 400.00 400.00 400.00 135-60079-030-000 Public Education 6,000.00 6,000.00 111.00 111.00 1.850 5,889.00 135-60080-030-000 Schools & Training 6,850.00 6,850.00 75.00 75.00 1.095 6,775.00 135-60100-030-000 Travel & per diem 3,575.00 3,575.00 95.34 95.34 2.667 3,479.66 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 135-60115-030-000 Elections 5,000.00 5,000.00 59.43 59.43 1.189 4,940.57 135-60125-030-000 Advertising 2,500.00 2,500.00 2,500.00 39 of 148 November 16, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60235-030-000 135-60245-030-000 135-60246-030-000 135-60285-030-000 135-60360-030-000 Security Miscellaneous Expenses General Manager Contingency Lawn Equipment & Maintenance Furniture/Equipment < $5000 7 135-65010-030-000 Uniforms 135-65055-030-000 Hardware 135-65085-030-000 Office Supplies 135-65095-030-000 Maintenance Supplies 135-65105-030-000 Printing 135-69005-030-000 135-69170-030-000 Capital Outlays Copier Lease Installments Department number: Administration 1,288.00 1,288.00 500.00 500.00 17,000.00 17,000.00 5,000.00 5,000.00 2,500.00 2,500.00 272,505.00 272,505.00 36,670.98 2,050.00 2,050.00 20,253.00 20,253.00 1,483.60 6,000.00 6,000.00 4,000.00 4,000.00 2,500.00 2,500.00 1,483.60 138,000.00 138,000.00 4,000.00 4,000.00 1,669,5#0 1,011111111 1,669,5:0 54,404.56 40 of 148 90.00 18,571411111 55, 693.52 183.78 46,825.00 47 175.00 90.00 1.800 1,483.60 693.52 183.78 46,825.00 175.00 7.325 11.559 4.595 33.931 4.375 1,288.00 500.00 17,000.00 4,910.00 2,500.00 2,050.00 18,769.40 5,306.48 3,816.22 2,500.00 91,175.00 3,825.00 1,401,334.23 Page 11 glbase_tbam skrolczyk 17:58 11/11/20 Fund: 135 MUD 1 General Fund Account Description 135-55045-039-000 135-55055-039-000 135-55060-039-000 1 135-55065-039-000 Le al Auditing_ Appraisal Tax Admin Fees November 16, 2020 Regular Meeting Agenda Packet Trophy Club MUD No.1 Budget Summary with Amendment Department: 39 Non Departmental Program: Period Ending: 10/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135,000.00 33,800.00 11,925.00 4,850.00 135,000.00 33,800.00 11,925.00 4,850.00 1,397.50 107.67- 1,397.50 107.67- 1.035 -.903 133,602.50 33,800.00 12,032.67 4,850.00 Page 12 41 of 148 ir Subtotal: ' 185,575.00 185,575.00 1,289.83 1,289.83 .695 184,285.17 Program number: 185,575.00 185,575.00 1,289.83 1,289.83 .695 184,285.17 Department number: Non Departmental 185,575.00 185,575.00 1,289.83 1,289.83 .695 184,285.17 Expenditures Subtotal 10,222,171.00 10,222,171.00 510,038.08 823,057.02 1,333,095.10 13.041 8,889,075.90 Fund number: 135 MUD 1 General Fund 5,106.00- 5,106.00- 510,038.08 43,144.44 553,182.52 ############### 558,288.52- 41 of 148 glbase_tbam skrolczyk 17:58 11/11/20 Fund: 137 MUD 1 Consolidated GASS Account Description 137-49145-000-000 137-49146-000-000 H Subtot Intergov Transfer -General Fund Intergov Transfer -Fire Dept Fund number: 137 MUD 1 Consolidated GASB Department: November 16, 2020 Regular Meeting Agenda Packet Trophy Club MUD No.1 Page 13 Budget Summary with Amendment Program: Period Ending: 10/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 42 of 148 205,000.00- 81,420.00- 205,000.00- 81,420.00- 286,420.00- 286,420.00- 205,000.00 81,420.00 286, 286,420.00 glpdatb2 skrolczyk 17:58 11/11/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description November 16, 2020 Regular Meeting Agenda Packet Trophy Club MUD No.1 Page 4 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 10/2020 JE Detail Beginning Transaction Transaction Vendor Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-40000-000-000 L Property Taxes 179 10/09/2020 Property Taxes 180 10/12/2020 Property Taxes 183 10/15/2020 Property Taxes 184 10/16/2020 Property Taxes 188 10/20/2020 Property Taxes 189 10/21/2020 Property Taxes 190 10/22/2020 Property Taxes 192 10/23/2020 Property Taxes 193 10/26/2020 Property Taxes 194 10/27/2020 Property Taxes 195 10/28/2020 Property Taxes 196 10/29/2020 Property Taxes 197 10/30/2020 Property Taxes (27.70) (27.70) GL (58.93) (86.63) GL (104.79) (191.42) GL (56.01) (247.43) GL (85.42) (332.85) GL (38.22) (371.07) GL (23.73) (394.80) GL (59.67) (454.47) GL (110.01) (564.48) GL (133.43) (697.91) GL (100.39) (798.30) GL (57.54) (855.84) GL (130.48) (986.32) GL Account: 135-40000-000-000 Property Taxes Totals: (986.32)■ (986.32) ** (136,531.00) Budgeted (135,544.68) Remaining 1 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 177 10/05/2020 Property Taxes 178 10/07/2020 Property Taxes 188 10/20/2020 Property Taxes 192 10/23/2020 Property Taxes 194 10/27/2020 Property Taxes 196 10/29/2020 Property Taxes (5.53) (5.53) GL 37.78 32.25 GL (350.07) (317.82) GL (1.07) (318.89) GL (2.06) (320.95) GL (.48) (321.43) GL Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (321.43) (321.43) ** (300.00) Budgeted 21.43 Remaining 107 % Used Account: 135-40015-000-000 Property Taxes/P & I 177 10/05/2020 Property Taxes 192 10/23/2020 Property Taxes 194 10/27/2020 Property Taxes 196 10/29/2020 Property Taxes (1.22) (1.22) GL (.32) (1.54) GL (.51) (2.05) GL (.22) (2.27) GL Account: 135-40015-000-000 Property Taxes/P & I Totals: (2.27) ** (300.00) Budgeted (297.73) Remaining 1 % Used Account: 135-40025-000-000 PID Surcharges .00 .00 43 of 148 glpdatb2 skrolczyk 17:58 11/11/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Account: 135-40025-000-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 10/2020 Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment November 16, 2020 Regular Meeting Agenda Packet Page 5 -PID Surcha otals: (163,725.00) Budgeted (163,725.00) Remaining 0 % Used Nat ' 108 10/01/2020 Reversed Accrued UB JE# 1929 39 10/08/2020 UB 10/08/2020 Account reversal UB20201008-20201008 User: 72 10/16/2020 UB 10/16/2020 Trane reversal UB20201016-20201016 User: 155 10/31/2020 UB 10/31/2020 Billing UB20201031-20201031 User: Account: 135-47000-000-000 (5,932,489.00) Budgeted (5,411,353.14) Remaining 9 % Used Account: 135-47005-000-000 108 10/01/2020 Reversed Accrued UB JE# 1929 39 10/08/2020 UB 10/08/2020 Account reversal UB20201008-20201008 User: 72 10/16/2020 UB 10/16/2020 Trans reversal UB20201016-20201016 User: 155 10/31/2020 UB 10/31/2020 Billing UB20201031-20201031 User: Account: 135-47005-000-000 Account: 135-47025-000-000 112,426.19 14.71 27.65 (633,604.41) 56,800.41 34.54 34.54 (287,258.28) Totals: (3,677,146.00) Budgeted (3,446,757.21) Remaining 6 % Used Penalties 112,426.19 112,440.90 112,468.55 (521,135.86) 56,800.41 56,834.95 56,869.49 (230,388.79) Check Source Number GL UB UB UB GL UB UB UB 27 10/06/2020 UB 10/06/2020 Penalty removal UB20201006-20201006 User: 279.58 279.58 UB 30 10/07/2020 738 10/07/2020 Penalty removal UB20201007-20201007 User: 164.21 443.79 UB 73 10/16/2020 UB 10/16/2020 Penalty removal UB20201016-20201016 User: 112.02 555.81 UB 95 10/20/2020 UB 10/20/2020 Penalty removal UB20201020-20201020 User: 34.16 589.97 UB 101 10/21/2020 UB 10/21/2020 Penalties UB20201021-20201021 User: (9,262.81) (8,672.84) UB 106 10/22/2020 UB 10/22/2020 Penalty removal UB20201022-20201022 User: 175.32 (8,497.52) UB 133 10/28/2020 UB 10/28/2020 Penalty removal UB20201028-20201028 User: 545.95 (7,951.57) UB 137 10/29/2020 UB 10/29/2020 Penalty removal UB20201029-20201029 User: 108.67 (7,842.90) UB 152 10/30/2020 UB 10/30/2020 Penalty removal UB20201030-20201030 User: 185.30 (7,657.60) UB alta (112,608.00) Budgeted (104,950.40) Remaining 7 % Used Service Charges 33 10/07/2020 UB 10/07/2020 Disconnect Fees UB20201007-20201007 User: 100 10/20/2020 UB 10/20/2020 NSF Check UB20201020-20201020 User: 44 of 148 (1,950.00) (1,950.00) UB (25.00) (1,975.00) UB glpdatb2 skrolczyk 17:58 11/11/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 153 10/26/2020 UB 10/26/2020 NSF Check Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 10/2020 Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment UB20201026-20201026 User: November 16, 2020 Regular Meeting Agenda Packet Page 6 (25.00) (2,000.00) Check Source Number UB 45 of 148 Account: 135-47030-000-000 Service Charges Totals: (2,000.00) (2,000.00) ** (16,550.00) Budgeted (14,550.00) Remaining 12 % Used Account: 135-47035-000-000 Plumbing Inspections .00 .00 Account: 135-47035-000-000 Plumbing Inspections Totals: .00 .00 ** (750.00) Budgeted (750.00) Remaining 0 % Used Account: 135-47045-000-000 Sewer Inspections .00 .00 Account: 135-47045-000-000 Sewer Inspections Totals: .00 ** (2,500.00) Budgeted (2,500.00) Remaining 0 % Used Account: 135-47070-000-000 TCCC Effluent Chargee 155 10/31/2020 UB 10/31/2020 Billing UB20201031-20201031 User: (14,039.20) (14,039.20) UB Account: 135-47070-000-000 TCCC Effluent Charges Totals: (14,039.20) (14,039.20) ** (50,000.00) Budgeted (35,960.80) Remaining 28 % Used Account: 135-49011-000-000 Interest Income i 239 10/31/2020 239 10/31/2020 239 10/31/2020 Bank Bank Bank Interest- Interest- Interest- October October October (624.95) (695.32) (694.92) (624.95) (1,320.27) (2,015.19) GL GL GL Account: 135-49011-000-000 Interest Income Totals: (2,015.19) (2,015.19) ** (100,000.00) Budgeted (97,984.81) Remaining 2 % Used Account: 135-49016-000-000 Cell Tower Revenue 11 10/02/2020 Cell Tower Rev AT&T (1,178.81) (1,178.81) GL Account: 135-49016-000-000 Cell Tower Revenue Totals: (1,178.81) (1,178.81) ** (14,146.00) Budgeted (12,967.19) Remaining 8 % Used Account: 135-49026-000-000 Proceeds from Sale of Assets 45 of 148 November 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 7 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-49026-000-05 Proceeds from Sale of Assets Totals: (5,000.00) Budgeted (5,000.00) Remaining Account: 135-49075-000-000 Account: 135-49075-000-000 Accoypt: 135 -49900 -000 - Oversize Meter Reimbursement Oversize Meter Reimbursem (8,232.00) Budgeted Miscellaneous Income (8,232.00) 155 10/31/2020 UB 10/31/2020 Billing 0020201031-20201031 User: Account Miscellaneous Income IIITota (7,000.00) Budgeted (6,812.89) Remaining Department Totals: .00 .00 0 % Used .00 .00 (187.11) (187.11) UB ls: (18 (779,912.58) ** (10,227,277.00) Budgeted (9,447,364.42) Remaining 8 % Used Remaining (779,912.58) Monthly Total 0 % Used 3 % Used 46 of 148 glpdatb2 skrolczyk 17:58 11/11/20 Fund: 135 MUD 1 General Fund ACC 4 10/02/2020 113 10/02/2020 57 10/16/2020 114 10/16/2020 121 10/30/2020 JE Number JE Date JE Description ount: 135-50005-010- Salaries MUD payroll 10/2/2020 Salaries & Wages Department: 10 Water JE Detail Description/Comment Revr Accr Sept FY20 Payroll #1 MUD Payroll 10/16/2020 Salaries & Wages Revr Accr Sept FY20 Payroll #2 MUD P/R 10/30/2020 Salaries & Wages Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 10/2020 Beginning Balance Program: Transaction Detail November 16, 2020 Regular Meeting Agenda Packet Page 8 Transaction Vendor Name Detail (SUBTOTAL) 13,139.19 13,139.19 (13,139.19) .00 13,714.67 13,714.67 (4,268.89) 9,445.78 13,561.88 23,007.66 Check Source Number PR GL PR GL PR Account: 135-50005-010-000 23,007.66 Accou 365,309.00 Budgeted 4 10/02/2020 MUD payroll 10/2/2020 Overtime 113 10/02/2020 Revr Accr Sept FY20 Payroll #1 57 10/16/2020 MUD Payroll 10/16/2020 Overtime 121 10/30/2020 MUD P/R 10/30/2020 Overtime Account: 135-50010-010- Overtime 17,000.00 Budgeted 342,301.34 Remaining 6 % Used Account: 135-50016-010-000 Longevity Account: 135-50016-010-000 Account: 135-50017-010-00 57 10/16/2020 MUD Payroll 10/16/2020 `Longevir 5,435.00 Budgeted Certification Certification 4 10/02/2020 MUD payroll 10/2/2020 57 10/16/2020 MUD Payroll 10/16/2020 121 10/30/2020 MUD P/R 10/30/2020 6,000.00 Budgeted rement Retirement Retirement Retirement 36,520.00 Budgeted 15,301.71 Remaining 5,435.00 Remaining 5,800.00 Remaining 10 % Used 0 % Used 3 % Used 32,536.04 Remaining 11 % Used 47 of 148 709.21 (709.21) 788.26 910.03 .00 200.00 1,282.36 1,361.50 1,340.10 709.21 .00 788.26 1,698.29 .00 200.00 1,282.36 2,643.86 3,983.96 i PR GL PR PR PR PR PR PR glpdatb2 skrolczyk 17:58 11/11/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Department: 10 Water JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 10/2020 Beginning Balance November 16, 2020 Regular Meeting Agenda Packet Page 9 Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) Check Source Number 4 10/02/2020 MUD payroll 10/2/2020 Social Security Taxes 113 10/02/2020 Revr Accr Sept FY20 Payroll #1 57 10/16/2020 MUD Payroll 10/16/2020 Social Security Taxes 114 10/16/2020 Revr Accr Sept FY20 Payroll #2 121 10/30/2020 MUD P/R 10/30/2020 Social Security Taxes 848.69 (848.69) 893.42 (259.36) 906.56 848.69 .00 893.42 634.06 1,540.62 PR GL PR GL PR Account: 135-50030-010-000 Social Security Taxes Totals: 1,540.62 1,540.62 ** 24,412.00 Budgeted 22,871.38 Remaining 6 % Used Account: 135-50035-010-000 Medicare Taxes 48 of 148 Account: 135-50026-010-000 Medical Insurance 4 10/02/2020 MUD payroll 10/2/2020 Medical Insurance 57 10/16/2020 MUD Payroll 10/16/2020 Medical Insurance 2,612.55 2,612.49 2,612.55 5,225.04 PR PR Account: 135-50026-010-000 Medical Insurance Totals: 5,225.04 5,225.04 ** 86,182.00 Budgeted 80,956.96 Remaining 6 % Used Account: 135-50027-010-000 Dental Insurance 4 10/02/2020 MUD payroll 10/2/2020 Dental Insurance 57 10/16/2020 MUD Payroll 10/16/2020 Dental Insurance 158.32 158.31 158.32 316.63 PR PR Account: 135-50027-010-000 Dental Insurance Totals: 316.63 316.63 ** 4,933.00 Budgeted 4,616.37 Remaining 6 % Used Account: 135-50028-010-000 Vision Insurance 4 10/02/2020 MUD payroll 10/2/2020 Vision Insurance 57 10/16/2020 MUD Payroll 10/16/2020 Vision Insurance 24.10 24.08 24.10 48.18 PR PR Account: 135-50028-010-000 Vision Insurance Totals: 48.18 48.18 ** 789.00 Budgeted 740.82 Remaining 6 % Used Account: 135-50029-010-000 Life Insurance & Other 17 10/01/2020 Payroll Benefits 17 10/01/2020 Payroll Benefits 130.25 173.58 130.25 303.83 METLIFE Humana GROUP Inc BENEFITS 6881 6880 AP AP Account: 135-50029-010-000 Life Insurance & Other Totals: 303.83 303.83 ** 3,289.00 Budgeted 2,985.17 Remaining 9 % Used Account: 135-50030-010-000 Social Security Taxes 4 10/02/2020 MUD payroll 10/2/2020 Social Security Taxes 113 10/02/2020 Revr Accr Sept FY20 Payroll #1 57 10/16/2020 MUD Payroll 10/16/2020 Social Security Taxes 114 10/16/2020 Revr Accr Sept FY20 Payroll #2 121 10/30/2020 MUD P/R 10/30/2020 Social Security Taxes 848.69 (848.69) 893.42 (259.36) 906.56 848.69 .00 893.42 634.06 1,540.62 PR GL PR GL PR Account: 135-50030-010-000 Social Security Taxes Totals: 1,540.62 1,540.62 ** 24,412.00 Budgeted 22,871.38 Remaining 6 % Used Account: 135-50035-010-000 Medicare Taxes 48 of 148 glpdatb2 skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) November 16, 2020 Regular Meeting Agenda Packet Page 10 4 10/02/2020 MUD payroll 10/2/2020 Medicare Taxes 113 10/02/2020 Revr Accr Sept FY20 Payroll #1 57 10/16/2020 MUD Payroll 10/16/2020 Medicare Taxes 114 10/16/2020 Revr Accr Sept FY20 Payroll #2 121 10/30/2020 MUD P/R 10/30/2020 Medicare Taxes Account Medicare Taxes Mr Totals: 5,709.00 Budgeted 5,348.69 Remaining Account: 135 Unemployment Taxes 4 10/02/2020 MUD payroll 10/2/2020 Unemployment Taxes 113 10/02/2020 Revr Accr Sept FY20 Payroll #1 57 10/16/2020 MUD Payroll 10/16/2020 Unemployment Taxes 114 10/16/2020 Revr Accr Sept FY20 Payroll #2 121 10/30/2020 MUD P/R 10/30/2020 Unemployment Taxes Account: 135-50040-010- Unemployment Taxes 1,080.00 Budgeted Account: 135-50045-010-00 Workman's Compensation 128 10/01/2020 Insurance/Wrk Comp Expense Oct Account: 135-50045-010-00 Workman's Compensatio 10,877.00 Budgeted 198.48 198.48 PR (198.48) .00 GL 208.95 208.95 PR (60.66) 148.29 GL 212.02 360.31 PR 360.31 6 % Used 21.51 21.51 (21.51) .00 21.64 21.64 (6.58) 15.06 19.35 34.41 PR GL PR GL PR 1,045.59 Remaining 3 % Used 9,975.71 Remaining 8 Used 901.29 901.29 GL Account: 135-50060-010-000 -re-emp -•yslca a es in. Pre-emp Physicals/Testing Total 400.00 Budgeted 400.00 Remaining 0 % Used .00 .00 Account: 135-50070-010-000 Employee Relations .00 .00 Account: 135-50070-010-000 Employee Relations Totals: 300.00 Budgeted 300.00 Remaining 0 % Used Engineering 49 of 148 glpdatb2 skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) ACCoun November 16, 2020 Regular Meeting Agenda Packet Page 11 Account: 135-55080-010-000 Account: Engineering Totals: 20,000.00 Budgeted .00 .00 20,000.00 Remaining 0 % Used Maintenance & Repairs 77 10/16/2020 October A/P TC MUD Telecommunication line 3,425.00 3,425.00 REY-MAR CONSTRUCTION 6921 AP 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 AMZN MKTP US*2T92078I0 69.99 3,494.99 AMZN MKTP US*2T92078I0 PC 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 THE HOME DEPOT #6581 32.67 3,527.66 THE HOME DEPOT #6581 PC 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 TEX-TURF 54.10 3,581.76 TEX-TURF PC 143 10/29/2020 October A/P parts 30.60 3,612.36 Core & Main LP 6940 AP 143 10/29/2020 October A/P angle stops 900.00 4,512.36 Core & Main LP 6940 AP 150 10/30/2020 October A/P Parts -meter boxes 1,014.00 5,526.36 Core & Main LP 6956 AP 150 10/30/2020 October A/P Parts -meter boxes 466.80 5,993.16 Core & Main LP 6956 AP 150 10/30/2020 October A/P Parts -meter boxes 738.00 6,731.16 Core & Main LP 6956 AP 201 10/31/2020 October A/P Gas chlorinator 85.20 6,816.36 SCOOP 6978 AP 201 10/31/2020 October A/P Gas chlorinator 6,468.00 13,284.36 SCOOP 6978 AP 135-55080-0 - Account: 135-55085-010-000 Maintenance & Repair Totals: 124,000.00 Budgeted 110,715.64 Remaining Generator Maint. and Repair Generator Maint. and Repai 3,000.00 Budgeted 11 % Used 3,000.00 Remaining 0 % Used Account: 135-55090-010-000 Wrrre Maintenance 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 DENTON VEHREG 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 DENTON VEHREG 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 TX.GOV*SERVICEFEE-DIR 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 TX.GOV*SERVICEFEE-DIR 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 KWIK KAR LUBE & TUNE 0 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 KWIK KAR LUBE & TUNE 0 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 KWIK KAR LUBE & TUNE 0 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 KWIK KAR LUBE & TUNE 0 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 DISCOUNT TIRE TXD 75 Account: 135-55090-010-0 enance Totals: 5,000.00 Budgeted 3,957.91 Remaining 21 % Used 50 of 148 .00 .00 8.25 8.25 DENTON VEHREG PC 15.00 23.25 DENTON VEHREG PC 2.00 25.25 TX.GOV*SERVICEFEE-DIR PC 4.00 29.25 TX.GOV*SERVICEFEE-DIR PC 7.00 36.25 KWIK KAR LUBE & TUNE 0 PC 210.34 246.59 KWIK KAR LUBE & TUNE 0 PC 7.00 253.59 KWIK KAR LUBE & TUNE 0 PC 25.50 279.09 KWIK KAR LUBE & TUNE 0 PC 763.00 1,042.09 DISCOUNT TIRE TXD 75 PC glpdatb2 skrolczyk 17:58 11/11/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Department: 10 Water JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 10/2020 Beginning Balance November 16, 2020 Regular Meeting Agenda Packet Page 12 Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) Check Source Number 51 of 148 Account: 135-55105-010-000"IIIIMaintenance-Backhoe/SkidLoader .00 .00 Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-55120-010-000 Cleaning Services .00 .00 Account: 135-55120-010-000 Cleaning Services Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-55135-010-000 Lab Analysis 201 10/31/2020 October A/P 214 10/31/2020 October A/P TCEQ samples water samples 213.94 220.00 213.94 433.94 LOWER COLORADO RIVER AUTHORITY TARRANT CTY PUBLIC HEALTH LAB 6967 7007 AP AP Account: 135-55135-010-000 Lab Analysis Totals: 433.94 433.94 ** 7,500.00 Budgeted 7,066.06 Remaining 6 % Used Account: 135-60010-010-000 Communications/Mobiles .00 .00 Account: 135-60010-010-000 Communications/Mobiles Totals: .00 .00 ** 7,500.00 Budgeted 7,500.00 Remaining 0 % Used Account: 135-60020-010-000 Electricity 74 10/16/2020 October A/P Electricity -WW, Water 11,336.71 11,336.71 HUDSON ENERGY SERVICES, LLC 6915 AP Account: 135-60020-010-000 Electricity Totals: 11,336.71 11,336.71 ** 123,487.00 Budgeted 112,150.29 Remaining 9 % Used Account: 135-60066-010-000 Publications/Books/Subscripts 141 10/26/2020 Pcard 09/29/2020 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 SIGN-A-RAMA - 10/26/2020 SIGN-A-RAMA 165.00 351.00 165.00 516.00 SIGN-A-RAMA SIGN-A-RAMA PC PC Account: 135-60066-010-000 Publications/Books/Subscripts Totals: 516.00 516.00 ** 1,000.00 Budgeted 484.00 Remaining 52 % Used 51 of 148 glpdatb2 skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) November 16, 2020 Regular Meeting Agenda Packet Page 13 Account: 135 Dues & Memberships • Account: 135-60070-01: Dues & Memberships 500.00 Budgeted Account: 135-60080-010-000 Schools & Training .00 .00 Totals: .00 ** 500.00 Remaining 0 % Used Account: 135-60080-010-000 Schools & Training Totals: 7,426.00 Budgeted Account: 135-60090-010-000 Safety Program Account: 135-60090-010-000 Safety Program 400.00 Budgeted Account: 135-60100-010-000 7,426.00 Remaining 0 % Used ■ i 400.00 Remaining 0 % Used .00 .00 .00 ** .00 .00 .0' .00 ** Travel & per diem Account: 135-60100-010-000 Account: 135-60105-010-000 Account: 135-60105-010-000 'el & per diem 2,875.00 Budgeted 2,875.00 Remaining O % Used .00 .00 4u Rent/Lease Equipm 1,500.00 Budgeted 1,500.00 Remaining 0 Used 00 00 Account: 135-60135-010-000 TCEQ Fees & Permits Account: 135-60135-010-000 30,000.00 Budgeted TCEQ Fees & Permits Totals: 30,000.00 Remaining 411111 O % Used .00 .00 .00 .00 ** Account: 135-60150-010-000 Wholesale Water 52 of 148 glpdatb2 skrolczyk 17:58 11/11/20 Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Trophy Club MUD No.1 Detailed Accounting Trial Balance November 16, 2020 Regular Meeting Agenda Packet Page 14 214 10/31/2020 October A/P wholesale water ccou."1113,411Mr-ellIr Account: 135-60245-010-000 Account: 135-60245-010-000 Account: 135-60280-010-000 Account: 135-60280-010-000 54,579.12 54,579.12 CITY OF FORT WORTH 6996 AP 2,596,295.00 Budgeted 2,541,715.88 Remaining 2 % Used Miscellaneous Expenses Miscellaneous Expense 200.00 Budgeted Property Maintenance 200.00 Remaining 0 % Used Property Maintenance 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 135-60285-010-00 Lawn Equipment & Maintenance 201 10/31/2020 October A/P October Mowing Account: Lawn Equipment & Maintenance Totals: 14,750.00 Budgeted 14,000.00 Remaining Account: 135-60332-010-000 240 10/30/2020 TexPool Transfers October 240 10/30/2020 TexPool Transfers October TexPool O&M to 16Swift Rev I&S TexPool O&M to I&S- W&WW SYS Interfund Transfer Out -Rev I&S Totals: 565,820.00 Budgeted 514,381.87 Remaining Account: 135-60334-010-000 Interfund Transfer Out Account: 135-60334-010-000 Interfund Transfer Out Totals: 75,000.00 Budgeted 75,000.00 Remaining 5 % Used 9 % Used 0 % Used 54'51E1111111154,579.12 ** .00 .00 .00 ** .00 .00 750.00 750.00 WATTS ELLISON LLC 6982 AP 24,909.00 24,909.00 GL 26,529.13 51,438.13 GL .00 .00 Account: 135-60360-010-000 Furniture/Equipment < $5000 53 of 148 glpdatb2 skrolczyk 17:58 11/11/20 Fund: 135 MUD 1 General Fund JE Number Account: 135 -TO JE Date 135-65005-010-000 JE Description Department: 10 Water JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 10/2020 Beginning Balance Furniture/Equipment < $5000 Totals: 2,500.00 Budgeted 2,500.00 Remaining 143 10/29/2020 October A/P fuel Account: 135-65005-010-000 15,000.00 Budgeted 14,475.81 Remaining Account: 135-6501 - 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 AMAZON.COM*2T4J20SH1 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 JUSTIN DISCOUNT BOOTS 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 ACADEMY SPORTS #141 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 ACADEMY SPORTS #141 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 RED WING SHOES #573 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 RED WING SHOES #573 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 RED WING SHOES #573 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 RED WING SHOES #573 Account: 135010-01 Account: 135-65030-010-000 107 10/22/2020 107 10/22/2020 107 10/22/2020 107 10/22/2020 107 10/22/2020 143 10/29/2020 Account: 135 - Account: 135-65035-010-000 Account: 135-65035-010-000 October October October October October October A/P A/P A/P A/P A/P A/P • 1 Uniforms - 5,190.00 Budgeted 3,669.77 Remaining hemicals chemicals chemicals chemicals chemicals chemicals chlorine Chemicals 25,000.00 Budgeted 23,321.67 Remaining Small Tools Small Tools 1,200.00 Budgeted 1,200.00 Remaining Program: Transaction Detail .00 0 % Used November 16, 2020 Regular Meeting Agenda Packet Page 15 Transaction Vendor Name Detail (SUBTOTAL) .00 Check Source Number 524.19 524.19 US Bank Voyager Fleet Systems 6953 AP 3 % Used 29 % Used 7 % Used 0 % Used 54 of 148 326.20 275.15 161.94 150.95 175.00 175.00 80.99 175.00 296.95 103.75 324.30 83.40 88.16 781.77 .00 326.20 601.35 763.29 914.24 1,089.24 1,264.24 1,345.23 1,520.23 AMAZON. COM*2T4J20SH1 JUSTIN DISCOUNT BOOTS ACADEMY SPORTS #141 ACADEMY SPORTS #141 RED WING SHOES 4573 RED WING SHOES #573 RED WING SHOES #573 RED WING SHOES #573 296.95 HACH COMPANY 400.70 HACH COMPANY 725.00 HACH COMPANY 808.40 HACH COMPANY 896.56 HACH COMPANY 1,678.33 DPC INDUSTRIES, INC .00 00 PC PC PC PC PC PC PC PC 6944 AP 6944 AP 6944 AP 6944 AP 6944 AP 6942 AP glpdatb2 skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) November 16, 2020 Regular Meeting Agenda Packet Page 16 Account: 135-65040-010-000 Safety Equipment .00 .00 Account: 135-65040-010-000 Safety Equipment Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-65050-010-000 Meter Expense .00 .00 Account: 135-65050-010-000 Meter Expense Totals: .00 .00 ** 70,000.00 Budgeted 70,000.00 Remaining 0 % Used Account: 135-65053-010-000 Meter Change Out Program • .00 .00 Account: 135-65053-010-000 Meter Change Out Program Totals: .00 .00 ** 87,000.00 Budgeted 87,000.00 Remaining 0 % Used Account: 135-69005-010-000 Capital Outlays i 150 10/30/2020 October A/P 214 10/31/2020 October A/P 214 10/31/2020 October A/P valve replacements Meadowbrook & Sundance waterline project 32,956.15 15,364.40 2,150.00 32,956.15 REY-MAR CONSTRUCTION 48,320.55 Jackson Construction, LTD 50,470.55 Halff Associates, INC 6961 AP 7000 AP 6998 AP Account: 135-69005-010-000 Capital Outlays Totals: 50,470.55 50,470.55 ** 740,000.00 Budgeted 689,529.45 Remaining 7 5 Used Account: 135-69008-010-000 Short Term Debt -Principal .00 .00 Account: 135-69008-010-000 Short Term Debt -Principal i Totals: .00 .00 ** 30,962.00 Budgeted 30,962.00 Remaining 0 % Used Account: 135-69009-010-000 Short Term Debt -Interest .00 .00 Account: 135-69009-010-000 Short Term Debt -Interest Totals: .00 .00 ** 2,324.00 Budgeted 2,324.00 Remaining 0 % Used 55 of 148 glpdatb2 skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Detailed Accounting Trial Balance November 16, 2020 Regular Meeting Agenda Packet Page 17 Account: 35-6919W}0- Gasb34/Reserve for Replacement 130 10/01/2020 GASB Reserve Transfers FY 2021 Town Elevated Tank 130 10/01/2020 GASB Reserve Transfers FY 2021 Water Replacement Account:195-010-00 Gasb34/Reserve for Replacement Totals: 75,000.00 Budgeted .00 Remaining 100 % Used 45,000.00 45,000.00 30,000.00 75,000.00 GL GL Account: 135-69281-010-000 Water Tank Inspection Contract Account: 135-69281-010-000= Water Tank Inspection Contract To 108,000.00 Budgeted 108,000.00 Remaining 0 Used 56 of 148 .00 .00 glpdatb2 skrolczyk 17:58 11/11/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 10/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) November 16, 2020 Regular Meeting Agenda Packet Page 18 JE Detail Description/Comment Account: 135-55135-010-001 Lab Analysis for PID 214 10/31/2020 October A/P water samples 80.00 80.00 TARRANT CTY PUBLIC HEALTH LAB 7007 AP Account: 135-55135-010-001 Lab Analysis for PID Totals: 80.00 80.00 ** 2,000.00 Budgeted 1,920.00 Remaining 4 % Used Department 10 Totals: 300,273.87 ** 300,273.87 Monthly Total 5,327,164.00 Budgeted 5,026,890.13 Remaining 6 % Used 57 of 148 glpdatb2 skrolczyk 17:58 11/11/20 Fund: 135 MUD 1 General Fund JE Number Account: JE Date 135-50005-020- 4 10/02/2020 113 10/02/2020 57 10/16/2020 114 10/16/2020 121 10/30/2020 Account: 135-50005-020-000 JE Description Salaries MUD payroll 10/2/2020 Salaries & Wages Department: Trophy Club MUD No.1 Detailed Accounting Trial Balance 20 Wastewater Period Ending: 10/2020 Beginning Balance JE Detail Description/Comment Revr Accr Sept FY20 Payroll #1 MUD Payroll 10/16/2020 Salaries & Wages Revr Accr Sept FY20 Payroll #2 MUD P/R 10/30/2020 Salaries & Wages Totals: 483,633.00 Budgeted 453,174.36 Remaining Account: 135-50010-020-0' 4 10/02/2020 MUD payroll 10/2/2020 Overtime 113 10/02/2020 Revr Accr Sept FY20 Payroll #1 57 10/16/2020 MUD Payroll 10/16/2020 Overtime 121 10/30/2020 MUD P/R 10/30/2020 Overtime Program: Transaction Detail November 16, 2020 Regular Meeting Agenda Packet Page 19 Transaction Vendor Name Detail (SUBTOTAL) 17,903.46 17,903.46 (17,903.46) .00 17,978.60 17,978.60 (5,423.42) 12,555.18 17,903.46 30,458.64 6 % Used 30,458.64 831.74 (831.74) 664.64 887.86 831.74 .00 664.64 1,552.50 Check Source Number PR GL PR GL PR PR GL PR PR Account: 135 -50010 -020 - Account: 135-50016-020-000 Account: 135-50016-020-000 Account: 135-50017-020-00 57 10/16/2020 MUD Payroll 33,000.00 Budgeted Longevity • Longevi# 7,420.00 Budgeted 10/16/2020 Certification Account: 135-50017-020-00 Certification 8,100.00 Budgeted plE?unt: 135-50020-020-00 4 10/02/2020 MUD payroll 10/2/2020 57 10/16/2020 MUD Payroll 10/16/2020 121 10/30/2020 MUD P/R 10/30/2020 rement Retirement Retirement Retirement 49,358.00 Budgeted 31,447.50 Remaining 7,420.00 Remaining 7,475.00 Remaining 1 Totals: 1 5 % Used 0 % Used 8 % Used 44,098.80 Remaining 11 % Used 58 of 148 .00 625.00 1,734.89 1,784.24 1,740.07 .00 625.00 1,734.89 3,519.13 5,259.20 PR PR PR PR glpdatb2 skrolczyk 17:58 11/11/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 10/2020 JE Detail Description/Comment November 16, 2020 Regular Meeting Agenda Packet Page 20 Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Check Source Number 4 10/02/2020 MUD payroll 10/2/2020 Social Security Taxes 113 10/02/2020 Revr Accr Sept FY20 Payroll #1 57 10/16/2020 MUD Payroll 10/16/2020 Social Security Taxes 114 10/16/2020 Revr Accr Sept FY20 Payroll #2 121 10/30/2020 MUD P/R 10/30/2020 Social Security Taxes 1,129.13 (1,129.13) 1,125.43 (316.46) 1,174.72 1,129.13 .00 1,125.43 808.97 1,983.69 PR GL PR GL PR Account: 135-50030-020-000 Social Security Taxes Totals: 1,983.69 1,983.69 ** 32,993.00 Budgeted 31,009.31 Remaining 6 % Used Account: 135-50035-020-000 Medicare Taxes 59 of 148 Account: 135-50026-020-000 Medical Insurance 4 10/02/2020 MUD payroll 10/2/2020 Medical Insurance 57 10/16/2020 MUD Payroll 10/16/2020 Medical Insurance 3,869.82 3,869.76 3,869.82 7,739.58 PR PR Account: 135-50026-020-000 Medical Insurance Totals: 7,739.58 7,739.58 ** 122,035.00 Budgeted 114,295.42 Remaining 6 % Used Account: 135-50027-020-000 Dental Insurance 4 10/02/2020 MUD payroll 10/2/2020 Dental Insurance 57 10/16/2020 MUD Payroll 10/16/2020 Dental Insurance 215.42 215.39 215.42 430.81 PR PR Account: 135-50027-020-000 Dental Insurance Totals: 430.81 430.81 ** 6,443.00 Budgeted 6,012.19 Remaining 7 % Used Account: 135-50028-020-000 Vision Insurance 4 10/02/2020 MUD payroll 10/2/2020 Vision Insurance 57 10/16/2020 MUD Payroll 10/16/2020 Vision Insurance 34.89 34.89 34.89 69.78 PR PR Account: 135-50028-020-000 Vision Insurance Totals: 69.78 69.78 ** 1,098.00 Budgeted 1,028.22 Remaining 6 % Used Account: 135-50029-020-000 Life Insurance & Other 17 10/01/2020 Payroll Benefits 17 10/01/2020 Payroll Benefits 179.16 209.88 179.16 389.04 METLIFE Humana GROUP Inc BENEFITS 6881 6880 AP AP Account: 135-50029-020-000 Life Insurance & Other Totals: 389.04 389.04 ** 4,725.00 Budgeted 4,335.96 Remaining 8 % Used Account: 135-50030-020-000 Social Security Taxes 4 10/02/2020 MUD payroll 10/2/2020 Social Security Taxes 113 10/02/2020 Revr Accr Sept FY20 Payroll #1 57 10/16/2020 MUD Payroll 10/16/2020 Social Security Taxes 114 10/16/2020 Revr Accr Sept FY20 Payroll #2 121 10/30/2020 MUD P/R 10/30/2020 Social Security Taxes 1,129.13 (1,129.13) 1,125.43 (316.46) 1,174.72 1,129.13 .00 1,125.43 808.97 1,983.69 PR GL PR GL PR Account: 135-50030-020-000 Social Security Taxes Totals: 1,983.69 1,983.69 ** 32,993.00 Budgeted 31,009.31 Remaining 6 % Used Account: 135-50035-020-000 Medicare Taxes 59 of 148 glpdatb2 skrolczyk 17:58 11/11/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description November 16, 2020 Regular Meeting Agenda Packet Trophy Club MUD No.1 Page 21 Detailed Accounting Trial Balance Department: 20 Wastewater Program: Period Ending: 10/2020 JE Detail Beginning Transaction Transaction Vendor Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) 4 10/02/2020 MUD payroll 10/2/2020 Medicare Taxes 113 10/02/2020 Revr Accr Sept FY20 Payroll #1 57 10/16/2020 MUD Payroll 10/16/2020 Medicare Taxes 114 10/16/2020 Revr Accr Sept FY20 Payroll #2 121 10/30/2020 MUD P/R 10/30/2020 Medicare Taxes Account.1137T67576=611 Medicare Taxes 1 7,716.00 Budgeted Account: 135- Unemployment Taxes 4 10/02/2020 MUD payroll 10/2/2020 Unemployment Taxes 113 10/02/2020 Revr Accr Sept FY20 Payroll #1 57 10/16/2020 MUD Payroll 10/16/2020 Unemployment Taxes 114 10/16/2020 Revr Accr Sept FY20 Payroll #2 121 10/30/2020 MUD P/R 10/30/2020 Unemployment Taxes Account: 135-50040-020- Unemployment Taxes 1,440.00 Budgeted Account: 135-50045-020-00 Workman's Compensation 128 10/01/2020 Insurance/Wrk Comp Expense Oct Account: 135-50045-020-00 Workman's Compensation 14,607.00 Budgeted Totals: - 7,252.05 Remaining 6 % Used 264.06 264.06 PR (264.06) .00 GL 263.20 263.20 PR (74.01) 189.19 GL 274.76 463.95 PR 21.51 21.51 (21.51) .00 21.81 21.81 (6.45) 15.36 21.50 36.86 1,403.14 Remaining 3 5 Used 13,388.89 Remaining 8 % Used 1,218.11 1,218.11 PR GL PR GL PR GL Account: 135-50060-020-000 -re-emp -•yslca a es in. Account: 135-50060-020-00: Pre-emp Physicals/Testing Total 400.00 Budgeted 400.00 Remaining 0 5 Used .00 .00 Account: 135-50070-020-000 Employee Relations .00 .00 Account: 135-50070-020-000 Employee Relations Totals: 300.00 Budgeted 300.00 Remaining 0 % Used Engineering 60 of 148 glpdatb2 skrolczyk 17:58 11/11/20 Fund: 135 MUD 1 General Fund JE Number JE Date Account: 135-55005-020-05 JE Description Account: 135-55070-020-000 Account: 135-55070-020-000 Acc Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 10/2020 JE Detail Beginning Balance Description/Comment Engineering Totals: 30,000.00 Budgeted 30,000.00 Remaining Independent Labor Independent Labor 15,000.00 Budgeted o.11111--A1111-t: October A/P 5-55080-020 107 10/22/2020 141 10/26/2020 141 10/26/2020 141 10/26/2020 141 10/26/2020 141 10/26/2020 141 10/26/2020 141 10/26/2020 141 10/26/2020 143 10/29/2020 143 10/29/2020 143 10/29/2020 150 10/30/2020 150 10/30/2020 201 10/31/2020 Pcard 09/29/2020 Pcard 09/29/2020 Pcard 09/29/2020 Pcard 09/29/2020 Pcard 09/29/2020 Pcard 09/29/2020 Pcard 09/29/2020 Pcard 09/29/2020 October October October October October October A/P A/P A/P A/P A/P A/P Maintenance & Repair= filters - 10/26/2020 ROANOKE WINNELSON CO Program: Transaction Detail .00 0 % Used 15,000.00 Remaining - 10/26/2020 - 10/26/2020 - 10/26/2020 - 10/26/2020 - 10/26/2020 - 10/26/2020 - 10/26/2020 THE HOME DEPOT #6581 PAYPAL *AQUARIUSTEC ROANOKE WINNELSON CO THE HOME DEPOT #6581 ROANOKE WINNELSON CO F B MCINTIRE EQUIPMENT THE HOME DEPOT 6581 filters and oil filters and oil filters and oil belts for bloers and wraps field labor Calibration of all Flow Meters Account: 135-55080-020-00 Maintenance & Repa otals: 108,000.00 Budgeted 102,743.27 Remaining 0 % Used 5 % Used .00 November 16, 2020 Regular Meeting Agenda Packet Page 22 Transaction Vendor Name Detail (SUBTOTAL) .00 .00 330.00 330.00 101.51 431.51 48.09 479.60 388.60 868.20 27.00 895.20 60.51 955.71 147.30 1,103.01 1,024.85 2,127.86 81.99 2,209.85 270.00 2,479.85 140.04 2,619.89 235.00 2,854.89 695.09 3,549.98 920.00 4,469.98 786.75 5,256.73 RLC Controls ROANOKE WINNELSON CO THE HOME DEPOT #6581 PAYPAL *AQUARIUSTEC ROANOKE WINNELSON CO THE HOME DEPOT #6581 ROANOKE WINNELSON CO F B MCINTIRE EQUIPMENT THE HOME DEPOT 6581 DFW Compressor LLC DFW Compressor LLC DFW Compressor LLC DFW Compressor LLC NORTH TEXAS PUMP CO. Prime Controls, LP Check Source Number 6952 AP PC PC PC PC PC PC PC PC 6941 AP 6941 AP 6941 AP 6957 AP 6959 AP 6974 AP Account: 135-55081-020-000 Mainten & Repairs Collections Account: 135-55081-020-000 Account: 135-55085-020-000 Mainten & Repairs Collect' 157,500.00 Budgeted 157,500.00 Remaining 0 % Used 61 of 148 .00 .00 .00 .00 November 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 23 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Generator Maint. and Repair 10,000.00 Budgeted 10,000.00 Remaining Vehicle Maintenance 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 CLEAN STREAK AUTO SPA 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 DISCOUNT TIRE TXD 75 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 CLEAN STREAK AUTO SPA 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 SQ *CAR BODY LAB Account: 135-55090-020-000 Vehicle Maintenanc 4,000.00 Budgeted 2,551.50 Acco••^•• ' - - - .. Maintenance Collec - - 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 DISCOUNT TIRE TXD 75 Account: 135-55105-020-00a Remaining Veh Maintenance Collections Totals: 13,000.00 Budgeted 12,633.50 Remaining Maintenance-Backhoe/SkidLoader Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: 3,000.00 Budgeted 3,000.00 Remaining Account: 135-55120-020-000 Account: 135-55120-020-000 Cleaning Services Cleaning Services 1,500.00 Budgeted 0 % Ueed 36 Used 3 % Used 59.00 59.00 CLEAN STREAK AUTO SPA 485.50 544.50 DISCOUNT TIRE TXD 75 59.00 603.50 CLEAN STREAK AUTO SPA 845.00 1,448.50 SQ *CAR BODY LAB 366.50 366.50 .00 .00 0 % Used Totals: 1,500.00 Remaining 0 % Ueed .00 .00 DISCOUNT TIRE TXD 75 PC PC PC PC PC Account: 135-55125-020-000- Dempster Services 74 10/16/2020 October A/P sludge 1,187.92 1,187.92 L.H. CHANEY MATERIALS, INC. 6918 AP 143 10/29/2020 October A/P sludge 2,101.80 3,289.72 L.H. CHANEY MATERIALS, INC. 6946 AP 143 10/29/2020 October A/P Sludge haul off 1,066.40 4,356.12 L.H. CHANEY MATERIALS, INC. 6946 AP 204 10/31/2020 October A/P Sludge haul off 1,027.34 5,383.46 L.H. CHANEY MATERIALS, INC. 6966 AP Account: 135 1 Dumpster Services 100,000.00 Budgeted Totals: 94,616.54 Remaining 5 s Used 62 of 148 November 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 24 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55135-020-000 Lab Analysis 143 10/29/2020 October A/P 143 10/29/2020 October A/P 143 10/29/2020 October A/P 143 10/29/2020 October A/P 143 10/29/2020 October A/P 201 10/31/2020 October A/P 201 10/31/2020 October A/P Lab testing lab testing lab testing lab testing lab testing lab testing Biomonitoring October 341.55 241.50 341.55 241.50 341.55 241.50 1,080.00 341.55 OXIDOR LABORATORIES LLC 583.05 OXIDOR LABORATORIES LLC 924.60 OXIDOR LABORATORIES LLC 1,166.10 OXIDOR LABORATORIES LLC 1,507.65 OXIDOR LABORATORIES LLC 1,749.15 OXIDOR LABORATORIES LLC 2,829.15 HUTHER AND ASSOCIATES,INC 6950 AP 6950 AP 6950 AP 6950 AP 6950 AP 6973 AP 6964 AP Account: 135-55135-020-000 Lab Analysis Totals: 2,829.15 2,829.15 ** 40,000.00 Budgeted 37,170.85 Remaining 7 % Used Account: 135-60010-020-000 Communications/Mobiles ■ .00 .00 Account: 135-60010-020-000 Communications/Mobiles Totals: .00 ** 7,500.00 Budgeted 7,500.00 Remaining 0 % Used Account: 135-60020-020-000 Electricity Electricity -WW, Water Electricity 9/29-10/28 1755 AR 20201031-20201031 User: 11,173.32 411.59 (29.73) 11,173.32 11,584.91 11,555.18 HUDSON ENERGY SERVICES, TRI COUNTY ELECTRIC LLC 6915 7009 AP AP AR 74 10/16/2020 October A/P 214 10/31/2020 October A/P 244 10/31/2020 Town Billed Invoice Account: 135-60020-020-000 Electricity = Totals: 11,555.18 11,555.18 ** 157,735.00 Budgeted 146,179.82 Remaining 7 % Used Account: 135-60066-020-000 Publications/Books/Subscripts .00 .00 Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60070-020-000 Dues & Memberships .00 .00 Account: 135-60070-020-000 Dues & Memberships Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-60080-020-000 Schools & Training 63 of 148 November 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 TCEQ EPAYMENT 113.75 113.75 TCEQ EPAYMENT PC Account: 135-60080-020-000 Schools & Training Totals: 113.75 113.75 ** 4,991.00 Budgeted 4,877.25 Remaining 2 % Used Account: 135-60090-020-000 Safety Program .00 .00 Account: 135-60090-020-000 Safety Program Totals: .00 .00 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-60100-020-000 Travel & per diem .00 .00 Account: 135-60100-020-000 Travel & per diem Totals: .00 .00 1,575.00 Budgeted 1,575.00 Remaining 0 % Used Account: 135-60105-020-000 Rent/Lease Equipment .00 .00 Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60125-020-000 Advertising .00 .00 Account: 135-60125-020-000 Advertising Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 150 10/30/2020 October A/P WWTP permit FY 2021 9,888.02 9,888.02 TX COMMISSION ENVIRONMENTAL QU 6962 AP Account: 135-60135-020-000 TCEQ Fees & Permits Totals: 9,888.02 9,888.02 ** 45,000.00 Budgeted 35,111.98 Remaining 22 % Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 64 of 148 November 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60280-020-000 Account: 135-60280-020-000 Miscellaneous Expenses 450.00 Budgeted Property Maintenance Property Maintenance 5,000.00 Budgeted 450.00 Remaining 0 % Ueed 5,000.00 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 201 10/31/2020 October A/P October Mowing Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 14,000.00 Budgeted 13,110.00 Remaining Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S 240 10/30/2020 TexPool Transfers October TexPool O&M to I&S- PID Debt A000unt: 135-60331-020-000 .00 .00 890.00 890.00 WATTS ELLISON LLC 6982 AP 6 s Used 10,425.55 10,425.55 �Interfund Transfer Out -Tax I&S Tot 10,425.55 114,681.00 Budgeted 104,255.45 Remaining 9 5 Used Account: 135-60332-020- erfund Tranef� Rev I&S 240 10/30/2020 TexPool Transfers October TexPool O&M to Rev Bd WWTP I&S 240 10/30/2020 TexPool Transfers October TexPool O&M to I&S- W&WW SYS Account:nterfund Transfer Out -Rev I&S Totals: 688,005.00 Budgeted 625,459.13 Remaining Account: 135-60334-020-000 Interfund Transfer OuP Account: 135-60334-020-000 Interfund Transfer 75,000.00 Budgeted 75,000.00 Remaining Account: 135-60360-0 re/Equipmen 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 EPARTSFAST.COM 54,621.59 54,621.59 7,924.28 62,545.87 9 b Ueed .00 .00 0 5 Used 65 of 148 35.90 35.90 EPARTSFAST.COM GL GL GL PC November 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) AC 143 10/29/2020 October A/P Account: 135-65005-020-00: Account: 135-65010-020-000 Furniture/Equipment < $500 35 2,000.00 Budgeted 1,964.10 Remaining 2 % Ueed Fuel & Lube fuel 650.07 650.07 US Bank Voyager Fleet Systems 6953 AP Fuel & Lube Totals: 12,500.00 Budgeted Uniforms Account: 135-65010-020-000 Uniforms - 6,280.00 Budgeted Account: 135-65030-020-000 Alall Chemicals 77 10/16/2020 October A/P plymer for press 107 10/22/2020 October A/P CIP solution Account: Chemicals 25,000.00 Budgeted Chemicals Collections Account: 135-65031-020-000 Chemicals Collections 17,500.00 Budgeted Account: 135-65035-020-000 Small Tools Account: 135-65035-020-000 Small Tools 1,200.00 Budgeted Account: 135-65040-02 quipment 107 10/22/2020 October A/P nitrile gloves 11,849.93 Remaining 5 % Used 6,280.00 Remaining 0 % Used 21,425.90 Remaining 14 % Used Totals: 17,500.00 Remaining 0 % Ueed 650.07 ** .00 .00 2,856.60 2,856.60 POLYDYNE, INC 6919 AP 717.50 3,574.10 Valley Solvent Company, INC .00 .00 .00 .00 1,200.00 Remaining 0 % Used 66 of 148 252.00 252.00 LOU'S GLOVES INCORPORATED 6954 AP 6948 AP glpdatb2 skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) November 16, 2020 Regular Meeting Agenda Packet Page 28 Safety Equipment Tota 1,200.00 Budgeted 948.00 Remaining 74 10/16/2020 October A/P 74 10/16/2020 October A/P 74 10/16/2020 October A/P 74 10/16/2020 October A/P 74 10/16/2020 October A/P 77 10/16/2020 October A/P Account: 135-65045-020-000 Account: -69005-, 77 10/16/2020 October A/P 77 10/16/2020 October A/P Account: 135-69005-020-00 Lab Supplies • lab supplies lab supplies lab supplies lab supplies lab supplies lab supplies Lab Supplies 28,000.00 Budgeted Capital Outlays manhole rehab manhole rehab 21 Ueed 630.16 952.00 1,271.91 143.14 229.33 1,337.34 630.16 IDEXX DISTRIBUTION, INC 1,582.16 IDEXX DISTRIBUTION, INC 2,854.07 IDEXX DISTRIBUTION, INC 2,997.21 IDEXX DISTRIBUTION, INC 3,226.54 IDEXX DISTRIBUTION, INC 4,563.88 HACH COMPANY 4,563.88 ** 23,436.12 Remaining 16 % Used Capital Outlays - Totals: 335,000.00 Budgeted 6916 AP 6916 AP 6916 AP 6916 AP 6916 AP 6914 AP 3,812.00 3,812.00 REY-MAR CONSTRUCTION 6921 AP 3,812.00 7,624.00 REY-MAR CONSTRUCTION 6921 AP 327,376.00 Remaining 2 % Ueed 7,624.00 ** Account: 135-69008-020-000 Short Term Debt -Principal Account: 135-69008-020-000 Short Term Debt -Principal Totals: 81,273.00 Budgeted 81,273.00 Remaining .00 .00 0 % Ueed .00 ** Account: 135-69009-020-000 Short Term Debt -Interest Account: 135-69009-020-000 Short Term Debt-Intere 8,532.00 Budgeted 8,532.00 Account: 135-69195-03.221 Gasb34/Reserve for Replacement 130 10/01/2020 GASS Reserve Transfers FY 2021 Sewer Replacement 130 10/01/2020 GASB Reserve Transfers FY 2021 WWTP MBR Replacement Remaining 0 % Used 67 of 148 .00 .00 30,000.00 30,000.00 100,000.00 130,000.00 GL GL glpdatb2 skrolczyk 17:58 11/11/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Program: Period Ending: 10/2020 Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment November 16, 2020 Regular Meeting Agenda Packet Page 29 Check Source Number Account: 135-69195-020-000 Gasb34/Reserve for Replacement Totals: 130,000.00 130,000.00 ** 130,000.00 Budgeted .00 Remaining 100 % Used Department 20 Totals: 307,629.82 Monthly Total 307,629.82 ** 3,026,690.00 Budgeted 2,719,060.18 Remaining 10 % Used 68 of 148 November 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-026-0 Workman's Compensation • 128 10/01/2020 Insurance/Wrk Comp Expense Oct .79 .79 GL Acil Workman's Compensation 30.00 Budgeted Totals: 29.21 Remaining 3 % Used .79 ** Account: 135-60066-026-000 ■ Publications/Books/Subscripts Account: 135-60066-026-000 Publications/Books/Subscripts Totals: 150.00 Budgeted 150.00 Remaining 111 Dues & Memberships Account:• - - - Dues & Memberships otale. 750.00 Budgeted 0 5 Used .00 .00 .00 750.00 Remaining 0 % Used Account: 135-60075-026-000 Meetings 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 SQ *KELLER TROPHY AND Account: 135-60075-026-00 Meeting. 1,300.00 Budgeted 1,210.50 Remaining 7 Used 89.50 Account: 135-60080-026-000 Account: 135-60080-026-000 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Account: 135-60100-026-000 Travel & per diem Account: 135-60100-026-000 Travel & per diem Totals: 5,000.00 Budgeted 5,000.00 Remaining 0 % Used .00 .00 89.50 SQ *KELLER TROPHY AND .00 .00 .00 PC .00 Account: 135-60245-026-000 Miscellaneous Expenses 69 of 148 November 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 17:56 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Department 26 Totals: 90.29 •• 90.29 Monthly Total 13,230.00 Budgeted 70 of 148 13,139.71 Remaining 1 % Used November 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-030-000 Salaries & Wages ■ 4 10/02/2020 MUD payroll 10/2/2020 Salaries & Wages 21,151.78 21,151.78 PR 113 10/02/2020 Revr Accr Sept FY20 Payroll #1 (21,151.78) .00 GL 57 10/16/2020 MUD Payroll 10/16/2020 Salaries & Wages 21,141.69 21,141.69 PR 114 10/16/2020 Revr Accr Sept FY20 Payroll #2 (6,342.44) 14,799.25 GL 121 10/30/2020 MUD P/R 10/30/2020 Salaries & Wages 19,834.99 34,634.24 PR Account: 135-50005-030-000 Salaries & Wages Totals: 34,634.24 34,634.24 ** 626,592.00 Budgeted 591,957.76 Remaining 6 % Used Account: 135-50010-030-000 .00 .00 Account: 135-50010-030-000 Overtime Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 135-50016-030-000 Longevity .00 .00 Account: 135-50016-030-000 Longevity Totals: .00 .00 ** 2,668.00 Budgeted 2,668.00 Remaining 0 % Used Account: 135-50020-030-000 Retirement 4 10/02/2020 MUD payroll 10/2/2020 Retirement 1,958.66 1,958.66 PR 57 10/16/2020 MUD Payroll 10/16/2020 Retirement 1,957.70 3,916.36 PR 121 10/30/2020 MUD P/R 10/30/2020 Retirement 1,836.74 5,753.10 PR Account: 135-50020-030-000 Retirement Totals: 5,753.10 5,753.10 ** 58,550.00 Budgeted 52,796.90 Remaining 10 % Used Account: 135-50026-030-000 Medical Insurance 4 10/02/2020 MUD payroll 10/2/2020 Medical Insurance 57 10/16/2020 MUD Payroll 10/16/2020 Medical Insurance 3,985.11 3,985.11 PR 3,985.06 7,970.17 PR Account: 135-50026-030-000 Medical Insurance Totals: 7,970.17 7,970.17 ** 136,834.00 Budgeted 128,863.83 Remaining 6 % Used Account: 135-50027-030-000 Dental Insurance 71 of 148 November 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 4 10/02/2020 MUD payroll 10/2/2020 Dental Insurance 57 10/16/2020 MUD Payroll 10/16/2020 Dental Insurance Account: 135-50027-03 Dental Insurance 7,109.00 Budgeted Account: 135-50028-030-009 Vision Insurance 4 10/02/2020 MUD payroll 10/2/2020 Vision Insurance 57 10/16/2020 MUD Payroll 10/16/2020 Vision Insurance Account: 135-50028-030-000 Vision Incur- 1,138.00 Budgeted Account :_AdiiiiiIIMIrarilErath 17 10/01/2020 Payroll Benefits 17 10/01/2020 Payroll Benefits Account: 135-5002 - - 220.99 220.99 220.97 441.96 Total 441.96 ** 6,667.04 Remaining 6 % Used 1,072.40 Remaining Life Insurance & Other Totals: 4,730.00 Budgeted 6 Used 32.81 32.79 197.79 209.22 4,322.99 Remaining 9 % Used Account: 135-50030-030-000 Social Security Taxes 4 10/02/2020 MUD payroll 10/2/2020 Social Security Taxes 113 10/02/2020 Revr Accr Sept FY20 Payroll #1 57 10/16/2020 MUD Payroll 10/16/2020 Social Security Taxes 114 10/16/2020 Revr Accr Sept FY20 Payroll #2 121 10/30/2020 MUD P/R 10/30/2020 Social Security Taxes 32.81 65.60 197.79 METLIFE GROUP BENEFITS 407.01 Humana Inc 1,214.53 1,214.53 (1,214.53) .00 1,210.46 1,210.46 (357.68) 852.78 1,240.92 2,093.70 Account: 135-50030-030W Social Security Taxes Totals: 39,138.00 Budgeted 37,044.30 Remaining 5 % Used Account: 135-50035-030-000 Medicare Taxes 4 10/02/2020 MUD payroll 10/2/2020 Medicare Taxes 113 10/02/2020 Revr Accr Sept FY20 Payroll #1 57 10/16/2020 MUD Payroll 10/16/2020 Medicare Taxes 114 10/16/2020 Revr Accr Sept FY20 Payroll #2 121 10/30/2020 MUD P/R 10/30/2020 Medicare Taxes icare Taxes Totals: 9,153.00 Budgeted 8,663.36 Remaining 5 % Ueed 72 of 148 6881 PR PR PR PR AP 6880 AP PR GL PR GL PR 284.07 284.07 PR (284.07) .00 GL 283.07 283.07 PR (83.65) 199.42 GL 290.22 489.64 PR glpdatb2 skrolczyk 17:58 11/11/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 10/2020 JE Detail Beginning Balance Description/Conmient Program: Transaction Detail November 16, 2020 Regular Meeting Agenda Packet Page 34 Transaction Vendor Name Detail (SUBTOTAL) Check Source Number Account: 135-50040-030-000 Unemployment Taxes Account: 135-50040-030-000 Unemployment Taxes 1,440.00 Budgeted Account: 135-50045-030-000 Workman's Compensation 128 10/01/2020 Insurance/Wrk Comp Expense Oct Account: 50045-030-000 Workman's Compensation 1,573.00 Budgeted Total 1,440.00 Remaining Totals: 1,444.50 Remaining 0 % Used .00 128.50 8 % Used .00 128.50 Account: 135-50060-030-000 Pre-emp Physicals/Testing Account: - - - Pre-emp Physicals/Testing 500.00 Budgeted Account: 135-50070-030-000 Employee Relations 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 FTD.COM Account: 135-50070-030-001 Employee Relations 8,000.00 Budgeted Account: 135-55030-03. 3 10/01/2020 20 10/05/2020 43 10/08/2020 74 10/16/2020 107 10/22/2020 141 10/26/2020 141 10/26/2020 141 10/26/2020 141 10/26/2020 201 10/31/2020 214 10/31/2020 214 10/31/2020 October A?P October A/P October A/P October A/P October A/P Pcard 09/29/2020 Pcard 09/29/2020 Pcard 09/29/2020 Pcard 09/29/2020 October A/P October A/P October A/P - 10/26/2020 - 10/26/2020 - 10/26/2020 - 10/26/2020 500.00 Remaining 7,921.17 Remaining Annual GIS Code Red Scada licensing internet-october FS *FREEMAKE ATT*BILL PAYMENT ATT*BILL PAYMENT ADOBE ACROPRO SUBS Software training/help GIS support STW Annual Renewal FY 21 126,854.00 Budgeted .00 0 % Used 1 % Used Totals: - 93,687.06 Remaining 26 % Used 73 of 148 78.83 .00 78.83 FTD.COM 484.00 484.00 7,500.00 7,984.00 3,853.50 11,837.50 495.00 12,332.50 899.00 13,231.50 1.01 13,232.51 74.52 13,307.03 225.16 13,532.19 36.78 13,568.97 253.75 13,822.72 2,544.22 16,366.94 16,800.00 33,166.94 M3 Networks Halff Associates, INC Onaolve Intermediate Holding WIN -911 SOFTWARE Charter Communications FS *FREEMAKE ATT*BILL PAYMENT ATT*BILL PAYMENT ADOBE ACROPRO SUBS OpenGov, Inc Halff Associates, INC OpenGov, Inc GL PC 6811 AP 6879 AP 6906 AP 6924 AP 6939 AP PC PC PC PC 6972 AP 6998 AP 7004 AP November 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 35 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 13 Independent Labor Account: 135-55070-030-000 Independent Labor Totals: 15,000.00 Budgeted 15,000.00 Remaining 0 % Used .00 .00 Account: 135-55080-030-000 Maintenance & Repairs 77 10/16/2020 October A/P Lighting upgrades front entry 2,686.00 2,686.00 R & D Electric 6920 AP 107 10/22/2020 October A/P A/C 150.00 2,836.00 BRANDON R REED 6938 AP 107 10/22/2020 October A/P A/C annex bldg 340.00 3,176.00 BRANDON R REED 6938 AP 107 10/22/2020 October A/P office a/c 125.00 3,301.00 BRANDON R REED 6938 AP 143 10/29/2020 October A/P fire alarm maintenance 260.68 3,561.68 PRO FIRE & SPRINKLER LLC 6951 AP Maintenance & Repairs 40,000.00 Budgeted 36,438.32 Remaining 9 % Ueed Account: 135-55085-030-000 ' Generator Maint. and Repair Account: 135-55085-030-000 Generator Maint. and Repair Totals: 10,000.00 Budgeted 10,000.00 Remaining Account: 135-55120-030-000 Cleaning Services 107 10/22/2020 October A/P Cleaning -admin initial cleanin Account: 135-55120-030-000 Cleaning Services 15,000.00 Budgeted .00 .00 0 % Ueed 14,925.00 Remaining 1 % Used Account: 135-55160-030-000 Professional Outside Services 2 10/01/2020 October A/P FY 21 Annual IT Contract Account: 135-55160-030-000 Professional Outside Sery 104,925.00 Budgeted 47,049.00 Remaining 55 % Used Account: 135-55205-03 - lity Billing Cont 214 10/31/2020 October A/P Water billings -October Account Utility Sill Totals: 9,000.00 Budgeted 8,417.73 Remaining 6 % Used 74 of 148 75.00 75.00 MEMBER'S BUILDING MAINTENANCE 6949 AP 57,876.00 57,876.00 57,876.00 M3 Networks 6811 AP 582.27 582.27 DATAPROSE LLC 6997 AP 582.27 glpdatb2 skrolczyk 17:58 11/11/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Account: 135-60005-03 2 10/01/2020 October A/P 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 44 10/31/2020 October A/P November 16, 2020 Regular Meeting Agenda Packet Trophy Club MUD No.1 Page 36 Detailed Accounting Trial Balance Department: 30 Administration Program: Period Ending: 10/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment Answering SVc-Oct RINGCENTRAL, INC 8X8, INC. Answering SVc-Nov Account: 135-60005-030-b,,Telephon Totals: 9,680.00 Budgeted 9,239.09 Remaining Account: 135-60010-030-000 Communications/Mobiles 57 10/16/2020 MUD Payroll 10/16/2020 Communications/Mobiles Account: 135-60010-030-000 Account: 135-60020-030-000 74 10/16/2020 October A/P Account: 135-60020-030-000 Account: 135-60025-030-0: 201 10/31/2020 October A/P AC 143 10/29/2020 October A/P 214 10/31/2020 October A/P Account: 135-60040-030- 201 10/31/2020 October A/P 237 10/31/2020 Pace Credit Card Fees 237 10/31/2020 Pace Credit Card Fees omm , icatioas/Mobil 3,000.00 Budgeted 2,775.00 Electricity admin bldg Electricity/Gae ■ 14,512.00 Budgeted 5,000.00 30,000.00 ater-October Budgeted Remaining 13,978.93 Remaining 4,679.90 Postage lease Water billings -October Budgeted Service Charges & Fees Dig Tess -Oct Remaining 5 % Used 8 Used 4 % Used 6 Used 28,224.38 Remaining 6 % Used 75 of 148 194.75 194.75 KEYSTONE PARK SECRETARIAL 6807 AP 16.76 211.51 RINGCENTRAL, INC PC 34.65 246.16 8X8, INC. PC 194.75 440.91 KEYSTONE PARK SECRETARIAL 6903 AP 225.00 225.00 533.07 533.07 HUDSON ENERGY SERVICES, LLC 320.10 320.10 TROPHY CLUB MUD (WATER BILLS) 107.67 107.67 FRANCOTYP-POSTALIA, INC. 1,667.95 1,775.62 DATAPROSE LLC 1 PR 6915 AP 6981 AP 6943 AP 6997 AP 265.05 265.05 Texas Excavation Safety System 6979 AP 7,699.73 7,964.78 GL 56.15 8,020.93 GL glpdatb2 skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) November 16, 2020 Regular Meeting Agenda Packet Page 37 Account: 135-60040-030-000 Service Charges & Fees 67,000.00 Budgeted 58,979.07 Remaining AC Account - Bad Debt Expense Bad Debt Expense 1,500.00 Budgeted Accountlice 128 10/01/2020 Insurance/Wrk Comp Expense Oct Account: 135 - 84,000 00 Budgeted 12 % Used 1,500.00 Remaining 0 % Used 77,275 13 Remaining 8 Used .00 6,724.87 .00 6,724.87 GL Account: 135-60066-030-000 Publications/Books/Subscripts Account: 135-60066-030-000 Publications/Books/Subscri: 1,000.00 Budgeted 1,000.00 Remaining Accountil Dues & Memberships 214 10/31/2020 October A/P Annual membership dues Acc Dues & Memberships 6,000.00 Budgeted Meetings 0 % Used 5,900.00 Remaining 2 % Used .00 .00 100.00 100.00 NORTH CENTRAL TX COG 7003 AP .00 .00 400.00 Budgeted Account: 135 Public Education 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 DEEDS.COM 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 DEEDS.COM 400.00 Remaining 0 % Used 76 of 148 61.00 61.00 DEEDS.COM PC 50.00 111.00 DEEDS.COM PC November 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Public Education 6,000.00 Budgeted Accgi & Training 5,889.00 Remaining 2 % Ueed 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 UNT COMMERCE MANAGER Account: 135-60080-030-00 Schools & Training Totals: Account 6,850.00 Budgeted el & per diem 57 10/16/2020 MUD Payroll 10/16/2020 Travel & per diem Account: 135- - - Travel & per diem Account: 135-60110-030-000 Account: 135-60110-030-00& Account: 135-60115-030- 6,775.00 Remaining 1 % Ueed Totals: 3,575.00 Budgeted 3,479.66 Remaining 3 % Ueed Physicals/Testing Physicals/Testing 200.00 Budgeted 200.00 Remaining 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 IN *TIN -TRANSLATION IN 141 10/26/2020 Pcard 09/29/2020 - 10/26/2020 AMEN MRTP IIS*MR83435Q0 -030- Elections I 5,000.00 Budgeted Account: 135-60125-030-000 Advertising Account: 135-60125-030-000 Advertising 2,500.00 Budgeted Account: 135-60235-030-000 0 % Used 111.00 ** 75.00 75.00 UNT COMMERCE MANAGER 95.34 95.34 .00 .00 45.63 45.63 IN *TIN -TRANSLATION IN 13.80 59.43 AMEN MRTP US*MR83435Q0 r Totals: 4,940.57 Remaining 1 % Ueed .00 2,500.00 Remaining 0 % Used 77 of 148 .00 .00 .00 PC PR PC PC November 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60235-030-000 Account: 135-60245-030-000 Account: 135-60245-030-000 Account: 135-60246-030-000 Account: 135-60246-030-000 Account: 135-60285-030-000 201 10/31/2020 October A/P Account: 135-60285-030-000 Account: 135-60360-030-000 Account: 135-60360-030-000 Account: 135-65010-030-000 Account: 135-65010-030-000 Security 1,288.00 Budgeted Miscellaneous Expenses 1,288.00 Remaining 0 % Used Miscellaneous Expenses 500.00 Budgeted General Manager Contingency General Manager Contingency Totals: 17,000.00 Budgeted 17,000.00 Remaining Lawn Equipment & Maintenance October Mowing 500.00 Remaining 0 % Used Lawn Equipment & Maintenan 5,000.00 Budgeted Furniture/Equipment e 4,910.00 Remaining Furniture/Equipment < $5000 2,500.00 Budgeted 2,500.00 Remaining Uniforms= 0 s Used 2 Used .00 .00 .00 .00 90.00 90.00 WATTS ELLISON LLC .00 .00 0 % Used .00 .00 2,050.00 Budgeted 2,050.00 Remaining 0 5 Used Account: 135-65055-030-000 Hardware 78 of 148 .00 .00 6982 AP glpdatb2 ekrolczyk 17:58 11/11/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 150 10/30/2020 October A/P 150 10/30/2020 October A/P 204 10/31/2020 October A/P 204 10/31/2020 October A/P Account: 135-65085-030-000 Account: 135-65095-030-000 141 10/26/2020 141 10/26/2020 141 10/26/2020 141 10/26/2020 141 10/26/2020 141 10/26/2020 141 10/26/2020 Account: 135-65095-030-000 Account: 135-65105-030-00 Account: 135-6510 Pcard 09/29/2020 Pcard 09/29/2020 Pcard 09/29/2020 Pcard 09/29/2020 Pcard 09/29/2020 Pcard 09/29/2020 Pcard 09/29/2020 pount: 135-69005-030-00 150 10/30/2020 October A/P Account: 135-69005-0 Account: 135-69170-030-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 10/2020 JE Detail Beginning Balance Description/Comment Hardware 20,253.00 Budgeted Office Supplies office supplies office supplies office supplies office supplies Office Suppl 6,000.00 Budgeted - 10/26/2020 - 10/26/2020 - 10/26/2020 - 10/26/2020 - 10/26/2020 - 10/26/2020 - 10/26/2020 20,253.00 Remaining 5,306.48 TOM THUMB #1789 SAMSCLUB.COM AMZN MRTP US*2TOBS7XQ2 SAMS CLUB #6781 AMZN MRTP US*2T75F3P21 AMAZON.COM*MR34J1WI0 AMAZON.COM*MK59N5YY0 Maintenance Supp 4,000.00 Budgeted 14111111* 2,500.00 Budgeted 3,816.22 Remaining Remaining 2,500.00 Remaining Capital Outl. Elements XS annual subecriptio Capital Outlays 138,000.00 Budgeted 91,175.00 Remaining Copier Lease Installments Program: Transaction Detail 0 % Used 12 5 Used Used 0 % Used 34 % Used 79 of 148 November 16, 2020 Regular Meeting Agenda Packet Page 40 Transaction Vendor Name Detail (SUBTOTAL) 0 .00 ** 283.93 8.62 133.63 267.34 283.93 292.55 426.18 693.52 Check Source Number OFFICE DEPOT, INC OFFICE DEPOT, INC OFFICE DEPOT, INC OFFICE DEPOT, INC 9.71 9.71 TOM THUMB #1789 63.10 72.81 SAMSCLUB.COM 8.99 81.80 AMZN MRTP US*2TOBS7XQ2 31.83 113.63 SAMS CLUB #6781 48.58 162.21 AMZN MKTP US*2T75F3P21 9.88 172.09 AMAZON.COM*MR34J1W10 11.69 183.78 AMAZON.COM*MX59N5YY0 00 46,825.00 46,825.00 0 46,825.00 Novot 6960 AP 6960 AP 6971 AP 6971 AP 6958 PC PC PC PC PC PC PC AP November 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 48 10/09/2020 October A/P New copier lease 175.00 175.00 NDS Leasing 6905 AP Account: 135-69170-030-000 Copier Lease Installments Totals: 175.00 175.00 i• 4,000.00 Budgeted 3,825.00 Remaining 4 % Used Department 30 Totals: 213,773.21 ++ 213,773.21 Monthly Total 1,669,512.00 Budgeted 1,455,738.79 Remaining 13 % Used 80 of 148 November 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55045-039- 214 10/31/2020 October A/P Legal legal 1,397.50 Ac Legal 135,000.00 Budgeted 133,602.50 Remaining 1 % Ueed Account: 135-55055-039-000 Auditing .00 Account: 135-55055-039-000 Auditing Totals: 33,800.00 Budgeted 33,800.00 Remaining 0 % Used Account: 135-55060-039-000 126 10/22/2020 TAD Entity Refund Appraisal Account: 135-55060-039-00 Appraisal 11,925.00 Budgeted (107.67) 12,032.67 Remaining -1 % Ueed 1,397.50 McLean & Howard, L.L.P. .00 (107.67) 7001 AP GL Account: 135-55065-039-000 Tax Admin Fees Account: 135-55065-039-000 Department 39 Totals: `Tax Admin Fees 4,850.00 Budgeted 4,850.00 Remaining 0 % Used 1,289.83 Monthly Total 185,575.00 Budgeted .00 .00 1,289.83 ** 184,285.17 Remaining 1 % Used Fund 135 Totals: 43,144.44 43,144.44 Monthly Total (5,106.00) Budgeted (48,250.44) Remaining ########## 81 of 148 glpdatb2 skrolczyk 17:58 11/11/20 Fund: 137 MUD 1 Consolidated GASB JE JE JE Number Date Description Department: JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Program: November 16, 2020 Regular Meeting Agenda Packet Page 43 Period Ending: 10/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 137-49145-000-000 Intergov Transfer -General Fund 130 10/01/2020 GASH Reserve Transfers FY 2021 Town Elevated Tank 130 10/01/2020 GASH Reserve Transfers FY 2021 Water Replacement 130 10/01/2020 GASH Reserve Transfers FY 2021 Sewer Replacement 130 10/01/2020 GASH Reserve Transfers FY 2021 WWTP MBR Replacement (45,000.00) (30,000.00) (30,000.00) (100,000.00) (45,000.00) (75,000.00) (105,000.00) (205,000.00) GL GL GL GL Department Totals: Fund 137 Totals: (286,420.00) Monthly Total (286,420.00) Monthly Total .00 Budgeted .00 Budgeted 82 of 148 (286,420.00) ** 286,420.00 Remaining 0 % Used (286,420.00) 286,420.00 Remaining 0 % Used Account: 137-49145-000-000 ■ Intergov Transfer -General Fund Totals: (205,000.00) (205,000.00) ** .00 Budgeted 205,000.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer -Fire Dept 130 10/01/2020 GASH Reserve Transfers FY 2021 Fire Truck Future Replacement (81,420.00) (81,420.00) GL Account: 137-49146-000-000 Intergov Transfer -Fire Dept Totals: (81,420.00) (81,420.00) ** .00 Budgeted 81,420.00 Remaining 0 % Used Department Totals: Fund 137 Totals: (286,420.00) Monthly Total (286,420.00) Monthly Total .00 Budgeted .00 Budgeted 82 of 148 (286,420.00) ** 286,420.00 Remaining 0 % Used (286,420.00) 286,420.00 Remaining 0 % Used November 16, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - WWTP TAX BOND CONST BALANCE SHEET OCTOBER 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 517 TAX BOND CONSTRUCTION 486,413 TOTAL ASSETS 486,413 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 685,476 TOTAL LIABILITIES 685,476 FUND BALANCE ASSIGNED FUND BALANCE (199,119) NET REVENUES / EXPENDITURES 56 TOTAL FUND BALANCE (199,064) TOTAL LIABILITIES AND FUND BALANCE 486,413 83 of 148 November 16, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 10/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1 1 517-49011-000-000 Interest Income 55.76- 55.76- 55.76 Page 14 Subtotal: 55.76- 55.76- 55.76 - Program number: 55.76- 55.76- 55.76 Department number: Revenues 55.76- 55.76- 55.76 Revenues Subtotal 55.76- 55.76- 55.76 I Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 84 of 148 November 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 44 17:56 11/11/20 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-49011-000-000 Interest Income 239 10/31/2020 Bank Interest- October (55.76) (55.76) GL Account: 517-49011-000-000 Interest Income Totals: .00 Budgeted 55.76 Remaining 0 % Used Department Totals: (55.76) ** (55.76) Monthly Total .00 Budgeted 55.76 Remaining 0 % Used Fund 517 Totals: (55.76) (55.76) Monthly Total .00 Budgeted 85 of 148 55.76 Remaining 0 % Used November 16, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET OCTOBER 2020 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 1 OPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 784,973 TOTAL ASSETS 784,973 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 86 of 148 81,691 81,691 703,276 6 703,282 784,973 November 16, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const -SWIFT Department: Revenues Program: Period Ending: 10/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1 1 519-49011-000-000 Interest Income 6.45- 6.45- 6.45 Page 15 Subtotal: 6.45- 6.45- 6.45 Program number: 6.45- 6.45- 6.45 Department number: Revenues 6.45- 6.45- 6.45 Revenues Subtotal 6.45- 6.45- 6.45 I Fund number: 519 2016 Rev Bond Const -SWIFT 1 6.45- 6.45- 6.45 87 of 148 November 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45 17:56 11/11/20 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const -SWIFT Department: Revenues Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 519-49011-000-000 Interest Income 239 10/31/2020 Bank Interest- October (6.45) Account: 519-49011-000-000 Interest Income Totals: .00 Budgeted 6.45 Remaining 0 % Used (6.45) GL Department Totals: (6.45) ** (6.45) Monthly Total .00 Budgeted 6.45 Remaining 0 % Used Fund 519 Totals: (6.45) (6.45) Monthly Total .00 Budgeted 88 of 148 6.45 Remaining 0 % Used November 16, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET OCTOBER 2020 raj TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND CASH IN BANK 258,888 INVESTMENTS 3,892,557 ACCOUNTS RECEIVABLE TOTAL ASSETS 4,151,445 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 2,539 TOTAL LIABILITIES 2,539 FUND BALANCE ASSIGNED FUND BALANCE 4,151,382 NET REVENUES / EXPENDITURES (2,476) TOTAL FUND BALANCE 4,148,906 TOTAL LIABILITIES AND FUND BALANCE 4,151,445 89 of 148 November 16, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 Page 16 17:58 11/11/20 Budget Summary with Amendment Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 10/2020 Account Description Adopted Amended Total Current YTD 5 of Remaining Budget Budget Encumb. Month Total Budget Budget 520-49011-000-000 Subtotal: Program number: Department number: Revenues Interest Income Subtotal 90 of 148 62.51- 62.51- 62.51- 62.51- 62.51- 62.51- 62.51- 62.51- 62.51- 62.51- 62.51 62. 62. 62. glbase_tbam skrolczyk 17:58 11/11/20 Fund: 520 Revenue Bond 16" Waterline Account 1 520-69005-010-000 Description Capital Outlays Trophy Club MUD No.1 Budget Summary with Amendment Department: 10 Water Department Period Ending: 10/2020 Adopted Amended Total Current Budget Budget Encumb. Month 2,538.78 November 16, 2020 Regular Meeting Agenda Packet Program: YTD Total 2,538.78 % of Remaining Budget Budget 2,538.78 - Page 17 91 of 148 Subtotal: 2,538.78 2,538.78 2,538.78 - Program number: 2,538.78 2,538.78 2,538.78 - Department number: Water Department 2,538.78 2,538.78 2,538.78 - Expenditures Subtotal I 2,538.78 2,538.78 2,538.78 - Fund number: 520 Revenue Bond 16" Waterline 2,476.27 2,476.27 2,476.27- 91 of 148 glpdatb2 skrolczyk Trophy Club MUD No.1 17:56 11/11/20 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) November 16, 2020 Regular Meeting Agenda Packet Page 46 Accol-011giagilL Interest Income 239 10/31/2020 Bank Interest- October (30.51) (30.51) GL 239 10/31/2020 Bank Interest- October (32.00) (62.51) GL Account: 520-490 Interest Income Totals: .00 Budgeted 62.51 Remaining 0 % Used Department Totals: (62.51) ** (62.51) Monthly Total .00 Budgeted 92 of 148 62.51 Remaining 0 % Used November 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 47 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 520-69005-010-000 Capital Outlays 214 10/31/2020 October A/P 16' waterline project 2,538.78 2,538.78 Halff Associates, INC 6998 AP Account: 520-69005-010-000 Capital Outlays Totals: 2,538.78 2,538.78 ** .00 Budgeted (2,538.78) Remaining 0 % Used Department 10 Totals: 2,538.78 ** 2,538.78 Monthly Total .00 Budgeted (2,538.78) Remaining 0 % Used Fund 520 Totals: 2,476.27 2,476.27 Monthly Total .00 Budgeted 93 of 148 (2,476.27) Remaining 0 % Used November 16, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET OCTOBER 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 511 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 893,969 TOTAL ASSETS 893,969 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 94 of 148 893,867 101 893,969 893,969 November 16, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 Page 18 17:58 11/11/20 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 10/2020 Account Description Adopted Amended Total Current YTD 5 of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49011-000-000 Interest Income 10,000.00- 10,000.00- 101.33- 101.33- 1.013 9,898.67- I Subtotal: 10,000.00- 10,000.00- 11111101.33- 101.33- 1.013 9,898. Program number: 10,000.00- 10,000.00- 11111101.33- 101.33- 1.013 9,898. Department number: = 10,000.00- 10,000.00- 101.33- 101.33- 1.013 9,898. Revenues Subtotal 10,000.00- 10,000.00- 101.33- 101.33- 1.013 9,898. Fund number: 528 2015 Revenue Bond Reserve Fund 10,000.00- 10,000.00- 101.33- 101.33- 1.013 9,898. 95 of 148 glpdatb2 skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) November 16, 2020 Regular Meeting Agenda Packet Page 48 Account: 528-49011-000-000 Interest Income 239 10/31/2020 Bank Interest- October (101.33) Account: 528-49011-000-000 (10,000.00) Budgeted Total (9,898.67) Remaining 1 % Used (101.33) GL Department Totals: (101.33) ** (101.33) Monthly Total (10,000.00) Budgeted (9,898.67) Remaining 1 % Used Fund 528 Totals: (101.33) (101.33) Monthly Total (10,000.00) Budgeted 96 of 148 (9,898.67) Remaining 1 % Used November 16, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET OCTOBER 2020 ASSETS CASH IN BANK INVESTMENTS 51,561 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 662,454 ACCOUNTS RECEIVABLE -OTHER - TOTAL ASSETS 714,015 TROPHY CLUB MUNICIPAL UTILITY DISTRICT INTEREST & SINKING- 533 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 662,454 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 662,454 FUND BALANCE ASSIGNED FUND BALANCE 34,511 NET REVENUES / EXPENDITURES 17,050 TOTAL FUND BALANCE 51,561 TOTAL LIABILITIES AND FUND BALANCE 714,015 97 of 148 November 16, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 10/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 533-40002-000-000 533-40015-000-000 Subtotal: Property Taxes Property Taxes/Delinquent Property Taxes/P & I 691,010.00- 1,000.00- 2,000.00- 691,010.00- 1,000.00- 2,000.00- 4,992.76- 1,615.99- 11.54- 4,992.76- 1,615.99- 11.54- .723 161.599 .577 686,017.24- 615.99 1,988.46 - Page 19 Mr - 694,010.00- 6,620.29- 6,620.29- 533-49011-000-000 533-49015-000-000 533-49141-000-000 Interest Income Lease/Rental Income Interfund Trans In -PID Surchg 5,000.00- 197,281.00- 114,681.00- 5,000.00- 197,281.00- 114,681.00- 4.12- 4.12- 10,425.55- 10,425.55- .082 9.091 4,995.88- 197,281.00- 104,255.45 - Subtotal: 316,962.00- 316,962.00- 10,429.67- 10,429.67- 3.291 306,532.33 - Program number: 1,010,972.00- 1,010,972.00- 17,049.96- 17,049.96- 1.686 993,922.04 - Department number: Revenues 1,010,972.00- 1,010,972.00- 17,049.96- 17,049.96- 1.686 993,922.04 - Revenues Subtotal 1,010,972.00- 1,010,972.00- 17,049.96- 17,049.96- 1.686 993,922.04- 98 of 148 November 16, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 10/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Page 20 533-70005-051-000 Paying Agent Fee 2,900.00 2,900.00 2,900.00 1 533-70025-051-000 Bond Interest Expense -Tax 190,073.00 190,073.00 190,073.00 1 533-70035-051-000 Bond Principal Payment -Tax 810,000.00 810,000.00 810,000.00 1 1 Subtotal: 1,002,973.00 1,002,973.00 1,002,973.00 Program number: 1,002,973.00 1,002,973.00 1,002,973.00 Department number: Administration 1,002,973.00 1,002,973.00 1,002,973.00 Expenditures Subtotal 1,002,973.00 1,002,973.00 1,002,973.00 Fund number: 533 MUD 1 I&S Consolidated 7,999.00- 7,999.00- 17,049.96- 17,049.96- 213.151 9,050.96 99 of 148 glpdatb2 skrolczyk 17:58 11/11/20 Fund: 533 MUD 1 I&S Consolidated JE JE JE Number Date Description November 16, 2020 Regular Meeting Agenda Packet Trophy Club MUD No.1 Page 49 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 10/2020 JE Detail Beginning Transaction Transaction Vendor Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 L Property Taxes 179 10/09/2020 Property Taxes 180 10/12/2020 Property Taxes 183 10/15/2020 Property Taxes 184 10/16/2020 Property Taxes 188 10/20/2020 Property Taxes 189 10/21/2020 Property Taxes 190 10/22/2020 Property Taxes 192 10/23/2020 Property Taxes 193 10/26/2020 Property Taxes 194 10/27/2020 Property Taxes 195 10/28/2020 Property Taxes 196 10/29/2020 Property Taxes 197 10/30/2020 Property Taxes (140.22) (140.22) GL (298.33) (438.55) GL (530.46) (969.01) GL (283.53) (1,252.54) GL (432.42) (1,684.96) GL (193.49) (1,878.45) GL (120.12) (1,998.57) GL (302.01) (2,300.58) GL (556.85) (2,857.43) GL (675.38) (3,532.81) GL (508.21) (4,041.02) GL (291.24) (4,332.26) GL (660.50) (4,992.76) GL Account: 533-40000-000-000 Property Taxes Totals: (4,992.76) (4,992.76) ** (691,010.00) Budgeted (686,017.24) Remaining 1 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 177 10/05/2020 Property Taxes 178 10/07/2020 Property Taxes 188 10/20/2020 Property Taxes 192 10/23/2020 Property Taxes 194 10/27/2020 Property Taxes 196 10/29/2020 Property Taxes (28.63) (28.63) GL 204.15 175.52 GL (1,772.28) (1,596.76) GL (5.79) (1,602.55) GL (10.89) (1,613.44) GL (2.55) (1,615.99) GL Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (1,615.99) (1,615.99) ** (1,000.00) Budgeted 615.99 Remaining 162 % Used Account: 533-40015-000-000 Property Taxes/P & I 177 10/05/2020 Property Taxes 192 10/23/2020 Property Taxes 194 10/27/2020 Property Taxes 196 10/29/2020 Property Taxes (6.38) (6.38) GL (1.74) (8.12) GL (2.73) (10.85) GL (.69) (11.54) GL Account: 533-40015-000-000 Property Taxes/P & I Totals: 4) (11.54) ** (2,000.00) Budgeted (1,988.46) Remaining 1 % Used Account: 533-49011-000-000 Interest Income 239 10/31/2020 Bank Interest- October (4.12) 100 of 148 (4.12) GL November 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 50 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-49011-000-000 Interest Income (5,000.00) Budgeted (4.12) Account: 533-49015-000-000 Account: 533-49015-000-000 Lease/Rental Income _ Lease/Rental Income (197,281.00) Budgeted (4,995.88) Remaining 0 % Ueed Totals: (197,281.00) Remaining 0 % Used .00 .00 Account: 533-49141-00 d Trans In -PID Surchg 240 10/30/2020 TexPool Transfers October TexPool O&M to I&S- PID Debt (10,425.55) (10,425.55) GL Account: 533-49 Interfund Trans In -PID Surchg Totals: 7 (114,681.00) Budgeted (104,255.45) Remaining 9 % Used Department Totals: (17,049.96) ** (17,049.96) Monthly Total (1,010,972.00) Budgeted 101 of 148 (993,922.04) Remaining 2 % Used glpdatb2 skrolczyk 17:58 11/11/20 Fund: 533 MUD 1 I&S Consolidated JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 51 Administration Period Ending: 10/2020 JE Detail Description/Comment November 16, 2020 Regular Meeting Agenda Packet Page 51 Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Check Source Number Department 51 Totals: Fund 533 Totals: .00 Monthly Total (17,049.96) Monthly Total 1,002,973.00 Budgeted 1,002,973.00 Remaining .00 ** 0 % Used (17,049.96) (7,999.00) Budgeted 9,050.96 Remaining 213 % Used 102 of 148 Account: 533-70005-051-000"IIIIPaying Agent Fee .00 .00 Account: 533-70005-051-000 Paying Agent Fee Totals: .00 .00 ** 2,900.00 Budgeted 2,900.00 Remaining 0 % Used Account: 533-70025-051-000 Bond Interest Expense -Tax .00 .00 Account: 533-70025-051-000 Bond Interest Expense -Tax Totals: .00 .00 ** 190,073.00 Budgeted 190,073.00 Remaining 0 % Used Account: 533-70035-051-000 Bond Principal Payment -Tax .00 .00 Account: 533-70035-051-000 Bond Principal Payment -Tax Totals: .00 ** 810,000.00 Budgeted 810,000.00 Remaining 0 % Used Department 51 Totals: Fund 533 Totals: .00 Monthly Total (17,049.96) Monthly Total 1,002,973.00 Budgeted 1,002,973.00 Remaining .00 ** 0 % Used (17,049.96) (7,999.00) Budgeted 9,050.96 Remaining 213 % Used 102 of 148 November 16, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET OCTOBER 2020 CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND ASSETS I&S WWTP 80,613 TOTAL ASSETS 80,613 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 25,988 54,625 80,613 TOTAL LIABILITIES AND FUND BALANCE 80,613 103 of 148 November 16, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 10/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49011-000-000 Interest Income 2,500.00- 534-49143-000-000 Interfund Transfer In-ww Sales 600,838.00- Subtot Program number: Department number: Revenues Revenues Subtotal 60/1111110- 6031111110- 603,38.00- 603,338.00- 2,500.00- 600,838.00- 60 338.00- 603,338.00- 603,338.00- 603,338.00- 3.38- 54,621.59- 3.38- 54,621.59- 104 of 148 .135 9.091 9.054 9.054 9.054 9.054 2,496.62- 546,216.41- 548,713.03- 548,713.03- 548,713.03- 548,713.03- Page 21 November 16, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 10/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1 1 534-70005-051-000 1 534-70040-051-000 1 534-70045-051-000 Rev Bond Paying, Agent Fee Revenue Bond Interest Expense Revenue Bond Principal Expense 400.00 200,438.00 400,000.00 400.00 200,438.00 400,000.00 400.00 200,438.00 400,000.00 Page 22 Subtotal: X00,838.00 600,838.00 Program number: 600,838.00 600,838.00 600,838.00 Department number: Administration 600,838.00 600,838.00 600,838.00 Expenditures Subtotal 600,838.00 600,838.00 600,838.00 p Fund number: 534 2015 Revenue Bond I&S 2,500.00- 2,500.00- 54,624.97- 54,624.97- 2,184.999 52,124.97 105 of 148 glpdatb2 skrolczyk 17:58 11/11/20 Fund: 534 2015 Revenue Bond I&S JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 10/2020 JE Detail Description/Comment November 16, 2020 Regular Meeting Agenda Packet Page 52 Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Check Source Number Department Totals: (54,624.97) Monthly Total (603,338.00) Budgeted 106 of 148 (54,624.97) ** (548,713.03) Remaining 9 % Used Account: 534-49011-000-000 Interest Income 239 10/31/2020 Bank Interest- October (3.38) (3.38) GL Account: 534-49011-000-000 Interest Income Totals: (3.38) (3.38) ** (2,500.00) Budgeted (2,496.62) Remaining 0 % Used Account: 534-49143-000-000 Interfund Transfer In -WW Sales 240 10/30/2020 TexPool Transfers October TexPool O&M to Rev Bd WWTP I&S (54,621.59) (54,621.55) GL Account: 534-49143-000-000 Interfund Transfer In -WW Sales Totals: (54,621.59) (54,621.59) ** (600,838.00) Budgeted (546,216.41) Remaining 9 % Used Department Totals: (54,624.97) Monthly Total (603,338.00) Budgeted 106 of 148 (54,624.97) ** (548,713.03) Remaining 9 % Used November 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 53 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond IRS Department: 51 Administration Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-70005-051-000 Rev Bond Paying Agent Fee Account: 534-70005-051-000 11 Rev Bond Paying Agent Fee Total 400.00 Budgeted 400.00 Remaining Account: 534-70040-051-000 Revenue Bond Interest Expense Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: 200,438.00 Budgeted 200,438.00 Remaining Account: 534-70045-051-000 Revenue Bond Principal Expense 534-70045-051-000 Revenue Bond Principal Expense Totals: 400,000.00 Budgeted 400,000.00 Remaining O % Used • O % Used .00 .00 .00 .00 .00 .00 O % Used Department 51 Totals: .00 ** .00 Monthly Total 600,838.00 Budgeted 600,838.00 Remaining 0 % Used Fund 534 Totals: (54,624.97) (54,624.97) Monthly Total (2,500.00) Budgeted 52,124.97 Remaining ########## 107 of 148 November 16, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET OCTOBER 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 30,534 TOTAL ASSETS 30,534 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 5,625 24,910 30,534 TOTAL LIABILITIES AND FUND BALANCE 30,534 108 of 148 November 16, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 10/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-49011-000-000 Interest Income 1,000.00- 535-49142-000-000 Interfund Tran In -Water Sales 273,999.00- Subtot Program number: Department number: Revenues Revenues Subtotal -99.00- 274,999.00- 1,000.00- 273,999.00- 274,999 274,999.00- 274,999.00- 274,999.00- 109 of 148 .80- 24,909.00- 24,909.80- ' 24,909.80- .80- 24,909.00- 24,909.80- 24,909.80- 24,909.80- .080 9.091 9.058 9.058 9.058 9.058 999.20- 249,090.00- 250,089.20- 250,089.20- 250,089.20- Page 23 November 16, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 10/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Page 24 535-70005-051-000 Rev Bond Paying Agent Fee 400.00 400.00 400.00 I 535-70040-051-000 Revenue Bona Interest Expense 58,599.00 58,599.00 58,599.00 I 535-70045-051-000 Revenue Bond Principal Expense 215,000.00 215,000.00 215,000.00 I Subtotal: ,IIW273,999.00 273,999.00 Program number: III 273,999.00 273,999.00 Department number: Administration mEr 273,999.00 273,999.00 Expenditures Subtotal 273,999.00 273,999.00 Fund number: 535 2016 Rev Bond I&S-SWIFT 1,000.00- 1,000.00- 11141.441114 273,999.00 273,999.00 23,909.80 24,909.80- 24,909.80- 2,490.980 110 of 148 glpdatb2 skrolczyk 17:58 11/11/20 Fund: 535 2016 Rev Bond I&S-SWIFT JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 10/2020 JE Detail Description/Comment November 16, 2020 Regular Meeting Agenda Packet Page 54 Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Check Source Number Department Totals: (24,909.80) Monthly Total (274,999.00) Budgeted 111 of 148 (24,909.80) ** (250,089.20) Remaining 9 % Used Account: 535-49011-000-000 Interest Income 239 10/31/2020 Bank Interest- October (.80) (.80) GL Account: 535-49011-000-000 Interest Income Totals: 111111 (.80) (.80) ** (1,000.00) Budgeted (999.20) Remaining 0 % Used Account: 535-49142-000-000 Interfund Tran In -Water Sales 240 10/30/2020 TexPool Transfers October TexPool O&M to 16Swift Rev I&S (24,909.00) (24,909.00) GL Account: 535-49142-000-000 Interfund Tran In -Water Sales Totals: (24,909.00) (24,909.00) ** (273,999.00) Budgeted (249,090.00) Remaining 9 9 Used Department Totals: (24,909.80) Monthly Total (274,999.00) Budgeted 111 of 148 (24,909.80) ** (250,089.20) Remaining 9 % Used November 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 55 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 535-70005-051-000 Rev Bond Paying Agent Fee Account: 535-70005-051-000 11 Rev Bond Paying Agent Fee Total Account: 535-70040-051-000 400.00 Budgeted 400.00 Remaining Revenue Bond Interest Expense Account: 535-70040-051-000 Revenue Bond Interest Expense Totals: 58,599.00 Budgeted 58,599.00 Remaining Account: 535-70045-051-000 Revenue Bond Principal Expense Department 51 Totals: Revenue Bond Principal Expense Totals: 215,000.00 Budgeted 215,000.00 Remaining .00 Monthly Total 0 % Used 0 % Used .00 .00 .00 .00 .00 .00 0 % Used .00 ** 273,999.00 Budgeted 273,999.00 Remaining 0 % Used Fund 535 Totals: (24,909.80) (24,909.80) Monthly Total (1,000.00) Budgeted 23,909.80 Remaining ########## 112 of 148 November 16, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET OCTOBER 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE Erin TROPHY CLUB MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 34,985 TOTAL ASSETS 34,985 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 531 NET REVENUES / EXPENDITURES 34,454 TOTAL FUND BALANCE 34,985 TOTAL LIABILITIES AND FUND BALANCE 34,985 113 of 148 glbase_tbam skrolczyk 17:58 11/11/20 Fund: 536 2019 Rev Bond I&S- W&WW System Account Description 536-49011-000-000 536-49142-000-000 536-49143-000-000 Interest Income Interfund Tran In -Water Sales Interfund Transfer In -WW Sales Subtotal: Program number: Department number: Revenues Revenues Subtotal November 16, 2020 Regular Meeting Agenda Packet Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Program: Period Ending: 10/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1,000.00- 291,820.00- 87,168.00- 379,988.00- 379,988.00- 379,988.00- 379,988.00- 1,000.00- 291,820.00- 87,168.00- .26- 26,529.13- 7,924.28- .26- 26,529.13- 7,924.28- .026 9.091 9.091 999.74- 265,290.87- 79,243.72- 379,988.00- 67 345,534.33- 379,988.00- .067 379,988.00- 67 379,988.00- 345,534.33 - 114 of 148 345,53 345,534.33- Page 25 November 16, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Budget Summary with Amendment Fund: 536 2019 Rev Bond I&S- W&WW System Department: 51 Administration Program: Period Ending: 10/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 536-70005-051-000 536-70040-051-000 536-70045-051-000 Rev Bond Paying Agent Fee Revenue Bona Interest Expense Revenue Bond Principal Expense 400.00 223,588.00 155,000.00 400.00 223,588.00 155,000.00 Subtotal: , gliiiii78,988.00 378,988.00 Program number: 111111178,988.00 378,988.00 Department number: Administration X78,988.00 378,988.00 Expenditures Subtotal 378,988.00 378,988.00 Fund number: 536 2019 Rev Bond I&S- W&WW System 1,000.00- 1,000.00- ******* End of Report ********* 34,453.67- 34,453.67- 3,445.367 115 of 148 400.00 223,588.00 155,000.00 378,988.00 378,988.00 378,988.00 378,988.00 33,453.67 Page 26 glpdatb2 skrolczyk Trophy Club MUD No.1 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 536 2019 Rev Bond I&S- W&WW System Department: Revenues Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) November 16, 2020 Regular Meeting Agenda Packet Page 56 Account: 536-49011-000-000 Interest Income 239 10/31/2020 Bank Interest- October Account: 536-49011-000-000 come (1,000.00) Budgeted Total= (999.74) Remaining Account: 536-49142-000-000 Interfund Tran In -Water Sales 240 10/30/2020 TexPool Transfers October TexPool O&M to I&S- W&WW SYS Account Interfund Tran In -Water Sales Totals: (291,820.00) Budgeted (265,290.67) Remaining Interfund Transfer In -WW Sales 240 10/30/2020 TexPool Transfers October TexPool O&M to I&S- W&WW SYS Account: 536-49143-11terfund Transfer In -WW Sales Totals: (87,168.00) Budgeted (79,243.72) Remaining Department Totals: 1 0 (.26) (.26) GL Used (26,529.13) (26,529.13) GL 9 % Used (7,924.28) (7,924.28) GL 9 % Used (34,453.67) Monthly Total (379,988.00) Budgeted 116 of 148 (34,453.67) ** (345,534.33) Remaining 9 % Used November 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 57 17:58 11/11/20 Detailed Accounting Trial Balance Fund: 536 2019 Rev Bond I8S- W&WW System Department: 51 Administration Program: Period Ending: 10/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 536-70005-051-000 Rev Bond Paying Agent Fee Account: 536-70005-051-000 11 Rev Bond Paying Agent Fee Total 400.00 Budgeted 400.00 Remaining Account: 536-70040-051-000 Revenue Bond Interest Expense Account: 536-70040-051-000 Revenue Bond Interest Expense Totals: 223,588.00 Budgeted 223,588.00 Remaining Account: 536-70045-051-000 Revenue Bond Principal Expense Account: 536-70045-051-000 Revenue Bond Principal Expense Totals: 155,000.00 Budgeted 155,000.00 Remaining Department 51 Totals: Fund 536 Totals: Grand Totals: .00 Monthly Total (34,453.67) Monthly Total O % Used O % Used O % Used .00 .00 .00 .00 .00 .00 .00 ** 378,988.00 Budgeted 378,988.00 Remaining 0 5 Used (34,453.67) (1,000.00) Budgeted 33,453.67 Remaining ########## (105,379.99) Monthly Total ******* End of Report ********* (105,379.99) **** (27,605.00) Budgeted 77,774.99 Remaining 382 5 Used 117 of 148 November 16, 2020 Regular Meeting Agenda Packet REGULAR MEETING MINUTES AMENDED** TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 BOARD OF DIRECTORS September 21, 2020 at 6:30 P.M. Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in a Public Hearing and Regular Session on September 21, 2020 at 6:30 P.M., in a Zoom video/telephone conference in accordance with the Governor's emergency proclamation suspending certain provisions of the Texas Open Meetings Act effective March 16, 2020 in response to the COVID-19 virus and was open to the public. STATE OF TEXAS § COUNTIES OF DENTON AND TARRANT § BOARD MEMBERS PRESENT: Steve Flynn Mark Chapman Kelly Castonguay William C. Rose Gregory Wilson STAFF PRESENT: Alan Fourmentin Laurie Slaght Mike McMahon Steven Krolczyk Tony Corbett President Vice President Secretary/Treasurer Director Director General Manager District Secretary Operations Manager Finance Manager Legal Counsel CALL TO ORDER AND ANNOUNCE A QUORUM President Flynn announced the date of September 21, 2020, called the meeting to order and announced a quorum present at 6:31 p.m. President Flynn opened the Public Hearing at 6:32 p.m. PUBLIC HEARING Trophy Club Municipal Utility District No. 1 will conduct a Public Hearing regarding adoption of the final District Tax Rates for Tax Year 2020. President Flynn Closed the Public Hearing at 6:33 p.m. CITIZEN COMMENTS There were no citizen comments REPORTS & UPDATES 1. Staff Reports 118 of 148 November 16, 2020 Regular Meeting Agenda Packet a. Capital Improvement Projects b. Water Operations Report c. Wastewater System Reports d. Finance Reports General Manager Alan Fourmentin presented the reports and updates to the Board and answered questions related thereto. CONSENT AGENDA 2. Consider and act to approve the Consent Agenda. a. August 2020 Combined Financials b. August 17, 2020 Regular Meeting Minutes c. Adopt Order No. 2020-0921A Declaring Surplus Property d. Adopt Rate Order No. 2020-0921B amending cost for boring and meter fees and setting an effective date of October 1, 2020. Director Rose requested that Consent Agenda items c. Order No. 2020-0921A and d. Order No. 2020- 0921B removed for further consideration. Motion made by Director Wilson and seconded by Director Castonguay to approve items a. and b. on the Consent Agenda. Motion carried unanimously **Motion made by Director Wilson and seconded by Director Chapman to approve item c. Order No. 2020- 0921A on the Consent agenda. For: Castonguay, Chapman, Flynn and Wilson Oppose: 0 Abstain: Rose Motion passed 4-0-1 Motion made by Director Rose and seconded by Director Chapman to Adopt Rate Order No. 2020-09218. Motion carried unanimously REGULAR SESSION 3. Consider and act regarding adoption of Resolution No. 2020-0921A approving Budget for Fiscal Year 2021. 119 of 148 November 16, 2020 Regular Meeting Agenda Packet Motion made by Director Castonguay and seconded by Director Chapman to adopt Resolution No. 2020- 0921A adopting the budget for the fiscal year beginning October 1, 2020. Motion carried unanimously 4. Consider and act regarding Order No. 2020-0921C, fixing and levying Trophy Club Municipal Utility District No. 1 Debt Service Tax Rate and Operations and Maintenance Tax Rate for 2020 Tax Year. Motion made by Director Chapman and seconded by Director Wilson to adopt Order No. 2020-0921C, fixing and levying Trophy Club Municipal Utility District No. 1 Debt Service tax rate Operations and Maintenance tax rate for the 2020 Tax Year. Motion is amended made by Director Rose and seconded by Director Wilson to state the Debt Service Tax Rate is $ at $0.03589 per $100 taxable value on all taxable property within the District and the Ad Valorem Tax Rate of $0.07185 on $100 taxable value on all taxable property within the District. Motion on amendment carries unanimously Motion as amended carries unanimously 5. Consider and act to approve of Amendment to District Information Form, including Notice to Purchaser Form. Motion made by Director Rose and seconded by Director Castonguay to approve the Amendment to District Information Form, including Notice to Purchaser Form showing the total Trophy Club Municipal Utility District No. 1 tax rate of $0.10774 per $100 of assessed valuation for the 2020 Tax Year. Motion carried unanimously 6. Consider and act to adopt Resolution 2020-0921B approving 2020 Tax Roll for Trophy Club Municipal Utility District No. 1. Motion made by Director Chapman and seconded by Director Wilson to approve Resolution No. 2020- 0921B approving 2020 Tax Roll for Trophy Club Municipal Utility District No. 1. Motion carried unanimously 7. Consider and act regarding annual review of District Investment Policy and Investment Strategies including: a. Adopt Order No. 2020-0921D approving Amended and Restated Investment Policy, including the 120 of 148 November 16, 2020 Regular Meeting Agenda Packet District's Investment Strategies and Appointment of Investment Officer(s). Motion made by Director Rose and seconded by Director Wilson to adopt Order No. 2020-0921D approving Amended and Restated Investment Policy, including the District's Investment Strategies and Appointment of Investment Officers as Steve Flynn, Alan Fourmentin and Steven Krolczyk. Motion carried unanimously 8. Consider and act to adopt Resolution No. 2020-0921C Cash Reserve Policy. Motion made by Director Rose and seconded by Director Wilson that the $647,588 in Undesignated Reserves and the $381,631 excess in Operating Reserves be reallocated with $801,798 going to Rehabilitation & Replacement Reserves, $75,000 going to Equipment Replacement Reserves, and $152,421 going to Rate Stabilization Reserves. Motion carried unanimously Motion made by Director Rose and seconded by Director Chapman to approve Resolution No. 2020-0921C Cash Reserve Policy. Motion carried unanimously 9. Consider and act to approve a Task Order with Halff Associates in the amount not to exceed $197,400 for completion of a Water and Wastewater Master Plan, and to authorize the General Manager to execute such Task Order. Motion made by Director Rose and seconded by Director Chapman to approve the Task Order agreement with Halff Associates for completion of a Water and Wastewater Master Plan for an amount not to exceed $197,400 and authorize the General Manager to execute the Task Order. Motion carried unanimously 10. Consider and act to approve a software license agreement with Novotx LLC (Elements XS) and to provide payment in the amount of $59,100, and to authorize the General Manager to execute such agreement. Motion by Director Chapman and seconded by Director Wilson to approve a software license agreement with Novotx LLC (Elements XS) for an amount of $59,100 and authorize the General Manager to execute the agreement. 121 of 148 November 16, 2020 Regular Meeting Agenda Packet Motion carried unanimously 11. Consider and act to approve a contract with Four Man Furnace for website upgrades at a cost of $34,250, and to authorize the General Manager to execute such contract. Motion by Director Chapman and seconded by Director Castonguay to approve a contract with Four Man Furnace for website upgrades at a cost not to exceed $34,250, and to authorize the General Manager to execute such contract. Motion carried unanimously 12. Consider and act regarding commencing in-person Board of Director meetings. (Flynn) This item is tabled and will be brought back at the October meeting. The Board convened into Executive Session at 7:53 p.m. EXECUTIVE SESSION 13. Pursuant to Section 551.072 of the Texas Open Meetings Act, the Board may deliberate the purchase, exchange, lease, or value of real property if deliberation in an open meeting would have a detrimental effect on the position of the governmental body in negotiations with a third person: a. Purchase of Easements or Real Property interests required for access to Wastewater Lift Station No. 1 The Board convened into Regular Session at 8:26 p.m. REGULAR SESSION President Flynn stated that no actions, decisions or votes were taken in Executive Session. No action is taken regarding executive Session 14. Consider and act on matters deliberated in Executive Session: 15. Items for future agendas: Future In person meetings 16. Set future Meeting dates - Regular Board Meeting on October 19, 2020 at 6:30 p.m. via zoom ADJOURN 122 of 148 President Flynn called the meeting adjourned at 8:27 p.m. Steve Flynn, President Kelly Castonguay, Secretary/Treasurer Laurie Slaght, District Secretary 123 of 148 November 16, 2020 Regular Meeting Agenda Packet (SEAL) November 16, 2020 Regular Meeting Agenda Packet REGULAR MEETING MINUTES TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 BOARD OF DIRECTORS October 19, 2020 at 6:30 P.M. Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in a Regular Session meeting on October 19, 2020 at 6:30 P.M., in a Zoom video/telephone conference in accordance with the Governor's emergency proclamation suspending certain provisions of the Texas Open Meetings Act effective March 16, 2020 in response to the COVID-19 virus and was open to the public. STATE OF TEXAS COUNTIES OF DENTON AND TARRANT BOARD MEMBERS PRESENT: Steve Flynn Mark Chapman Kelly Castonguay William C. Rose Gregory Wilson STAFF PRESENT: Alan Fourmentin Laurie Slaght Mike McMahon Steven Krolczyk Tony Corbett President Vice President Secretary/Treasurer Director Director General Manager District Secretary Operations Manager Finance Manager Legal Counsel CALL TO ORDER AND ANNOUNCE A QUORUM President Flynn announced the date of Monday, October 19, 2020, stated a quorum of the Board of Directors was present and called the meeting to order at 6:34 p.m. MOMENT OF SILENCE IN REMEMBRANCE OF MR. JOHN CARMAN, FORMER GENERAL MANAGER OF THE DISTRICT. President Flynn asked for a moment of silence in remembrance of former General manager John Carman. RECEIVE COMMENTS BY OUTGOING DIRECTOR WILSON. Director Wilson provided comments regarding his time on the board and thanked the Board for their positive efforts and joint accomplishments. The Directors expressed their appreciation to Director Wilson for his strong teamwork and wished him only the best as a Trophy Club Town Councilmember. CITIZEN COMMENTS There were no citizen comments REPORTS & UPDATES 1. Staff Reports a. Capital Improvement Projects 124 of 148 November 16, 2020 Regular Meeting Agenda Packet b. Water Operations Report c. Wastewater System Reports d. Finance Reports General Manager Alan Fourmentin presented the monthly reports and updates to the board and answered questions related thereto. CONSENT AGENDA 2. Consider and act to approve the Consent Agenda. a. September 2020 Combined Financials b. September 21, 2020 Regular Meeting Minutes c. Tax Collection Reports — 4th Quarter FY 2020 d. Investment Report — 4th Quarter FY 2020 Director Flynn requested that item b be removed for further review. Motion made by Director Wilson and seconded by Director Castonguay to approve items a., c. and d. on Consent Agenda. Motion carried unanimously Consent Agenda item b. September 21, 2020 Regular Meeting minutes will be corrected and brought back to the November meeting for approval. REGULAR SESSION 3. Discussion and possible action regarding request for billing adjustment by the resident at 519 Indian Creek Drive. General Manager Alan Fourmentin provided a timeline of correspondence with the resident and District Response. Motion made by Director Rose and seconded by Director Chapman to set a consumption of usage for April at 6000 gallons and credit the account accordingly. In Favor: 0 Oppose: 5 Abstain: 0 Motion Failed 0-0-5 4. Consider and act to approve Contract No. 2020101901 for Electrical and Scada Upgrades to Lift Stations #7, #8 and #9, as part of FY2020 Capital Improvement Projects and authorize the General Manager to execute the necessary contract documents. 125 of 148 November 16, 2020 Regular Meeting Agenda Packet Motion made by Director Rose and seconded by Director Castonguay to approve Contract No. 2020101901 to DHS Automation for Electrical and Scada Upgrades to Lift Stations #7, #8 and #9, as part of FY2020 Capital Improvement Projects for an amount not to exceed $47,580 and authorize the General Manager to execute the necessary contract documents. Motion carried unanimously 5. Consider and take appropriate action to resume in person Board of Director meetings beginning November 16, 2020 in the Svore Municipal Boardroom. Motion made by Director Castonguay and seconded by Director Chapman to resume in person Board meetings beginning November 16, 2020 and for the meetings to structured so that any member of the Board or public may attend if they so choose. In Favor: Castonguay, Chapman and Flynn Opposed: Rose Abstain: Wilson Motion carried 3,1,1 6. Items for future agendas: Chapman — Smart meters Election Matters 7. Set future Meeting dates — November 16, 2020 ADJOURN President Flynn called the meeting adjourned at 7:24 p.m. Steve Flynn, President Kelly Castonguay, Secretary/Treasurer Laurie Slaght, District Secretary 126 of 148 (SEAL) November 16, 2020 Regular Meeting Agenda Packet FORTWORTH. APPOINTMENT FORM Wholesale Water and Wastewater Customer Advisory Committee DATE: November 16, 2020 WHOLESALE CUSTOMER: Trophy Club Municipal Utility District No. 1 Check all that apply: 1 Water ❑ Wastewater The following individuals have been officially appointed by the CUSTOMER's GOVERNING BODY, under the terms of the Wholesale Contract for Services as the VOTING MEMBER and ALTERNATE for the Water and/or Wastewater System Advisory Committee. The term is for the Fiscal Year beginning October 1, 2020 through September 30, 2021. Voting Member: Alternate Member Mike McMahon Alan Fourmentin Name Name Operations Manager General Manager Title Title 682-831-4600 682-831-4600 Office Phone Office Phone Cell Phone mmcmahon@tcmud.org Email Address Cell Phone afourmentin@tcmud.org Email Address Mailing Address: Mailing Address: Trophy Club Municipal Utility District No. 1 Trophy Club Municipal Utility District No. 1 100 Municipal Drive 100 Municipal Drive Trophy Club, Texas 76262 Trophy Club, Texas 76262 Official Seal Signature of Mayor/Board President Please complete and return as soon as possible, but no later than December 31, 2020 to: WaterWholesale(&,fortworthtexas.gov or City of Fort Worth Water Utility Billing Section/Wholesale P. O. Box 870 Fort Worth, Texas 76101 cfs01\water\Groups\WholeSale\Wholesale Customer Advisory Committee\Water APPT Sheets\OfficialAppointsmentsForm2021 127 of 148 November 16, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 ORDER NO. 2020-1116 AN ORDER CANVASSING RETURNS AND DECLARING RESULTS OF BOARD OF DIRECTORS' ELECTION WHEREAS, on the 3rd day of November 2020, there was held in Trophy Club Municipal Utility District No. 1 (the "District") an election at which there were submitted the question of the election of two (2) Directors for the Board of Directors of the District; and WHEREAS, the official returns of said election have been delivered to the presiding officer of the Board of Directors of the District and have been certified to the Board of Directors by the presiding judge of said election; and WHEREAS, set forth on Exhibit "A" to this Order is a tabulation identifying the number of votes received by each candidate from voters in Tarrant County and in Denton County, including the total number of votes received in each precinct, the sum of the precinct totals, and the total number of voters who cast a ballot for a candidate for each precinct; and WHEREAS, the election was called and held in all respects under and in strict conformity with the Constitution and laws of the State of Texas and the United States of America; Now, Therefore, BE IT ORDERED BY THE BOARD OF DIRECTORS OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 THAT: Section 1: The matters and facts recited in the above preamble of this Order are found to be true and correct and are adopted for all purposes. Section 2: The election held in the District on the 3rd day of November, 2020, which is more fully described in the preamble of this Order, was called and notice given thereof in accordance with law; the election was held in all respects in conformity with law; and the returns of the election have been made by the proper officer. Section 3: Said election has resulted in the election of the following persons as directors of the District: PLACE MEMBER TERM OF OFFICE 1 Kevin R. Carr Until May 2024 2 Bill Rose Until May 2024 Each of said persons shall enter into the duties of his or her office and shall begin to serve his or her term of office upon posting bond in such amount as required by law and as may be specified by order or resolution of Board of Directors of the District and upon taking the constitutional oath of office. 128 of 148 November 16, 2020 Regular Meeting Agenda Packet ADOPTED, PASSED AND APPROVED on this 16th day of November 2020. Steve Flynn, President Board of Directors ATTEST: Kelly Castonguay, Secretary/Treasurer Board of Directors Laurie Slaght, District Secretary 129 of 148 (SEAL) November 16, 2020 Regular Meeting Agenda Packet Exhibit "A" Vote Tabulation 130 of 148 Trophy Municipal Utility District No. 1 Run Time 7:51 PM Run Date 11/11/2020 Tarrant County November 16, 2020 Regul Joint General and Special Elections 11/3/2020 Page 1 Trophy Club Municipal Utility District No. 1 Director for Place 1 (4 year term) ar Meeting A icial Results istered Voters 45 of 1216618 = 0.04% Choice Kevin R. Carr Torie Stephens-Bonty David Stout Party Absentee Voting Early Voting Election Day Voting Total 9 50.00% 125 52.08% 15 62.50% 149 52.84% 5 27.78% 66 27.50% 4 16.67% 75 26.60% 4 22.22% 49 20.42% 5 20.83% 58 20.57% Cast Votes: 18 100.00% 240 100.00% 24 100.00% 282 100.00% Undervotes: 7 138 16 ■ 161 Overvotes: 0 0 0 0 Trophy Club Municipal Utility District No. 1 Director for Place 2 (4 year term) Choice Party Absentee Voting Early Voting Election Day Voting Total Bill Rose 17 100.00% 237 100.00% 21 100.00% 275 100.00% Cast Votes: 17 100.00% 237 100.00% 21 100.00% • 275 100.00% Undervotes: 8 141 19 168 Overvotes: 0 0 0 *** End of report*** 131 of 148 1 0 November 16, 2020 Regular Meeting Agenda Packet Denton County Official Results will be added when received 132 of 148 rtOPHV CLUB MIITIICI PAL UTILITY DISTRICT November 16, 2020 Regular Meeting Agenda Packet STAFF REPORT November 16, 2020 AGENDA ITEM: Consider and act regarding approval of employee health and ancillary benefits for the calendar year beginning January 1, 2021 and ending December 31, 2021 and authorize the General Manager to execute the necessary documents to implement the Board action. STAFF REPORT: The District provides medical and ancillary benefits to its employees that run on a calendar year term. Current employee benefits expire on December 31, 2020. Dean Casey and Associates, the District's insurance broker has secured quotes for these benefits for the period beginning January 1, 2021 and ending on December 31, 2021. Medical Benefits — Quotes were received from United Healthcare and Blue Cross Blue Shield of Texas. Staff is presenting two scenarios with United Healthcare All Savers for medical benefits to the Board, Scenario 1 and Scenario 2. Ancillary Benefits - The ancillary coverage includes dental, vision, life, long term disability and short term disability coverages. The quotes received were from MetLife, UNUM, and Humana. STAFF RECOMMENDATION: Staff recommends approval of Scenario 2 for medical benefits with United Health Care All Savers and Humana and MetLife Insurance for ancillary benefits based on the benefits offered, renewal rates, and the adopted FY2021 budget. 133 of 148 151 TROPHY CLUB MUNICIPAL UTILITY DISTRICT STAFF REPORT November 16, 2020 Regular Meeting Agenda Packet November 16, 2020 AGENDA ITEM: Consider and act regarding approve task order agreement with Halff Associates for professional engineering services for District compliance with America's Water Infrastructure Act (AWIA) for completion by June 30, 2021: Phase I Risk and Resiliency Assessment (RRA) and Phase II Emergency Response Plans (ERP) for a cost of $77,200, and authorize the General Manager to execute the necessary documents to implement the Board action. DESCRIPTION: In October 2018, the passage of America's Water Infrastructure Act (AWIA) established the requirement that all community water systems serving a population of greater than 3,300 must comply with Environmental Protection Agency (EPA) requirements for risk and resilience assessments and emergency response plans. The AWIA also requires all drinking water system providers who serve a population greater than 3,300 to prepare or revise their Emergency Response Plans (ERPs) to incorporate the findings of each risk and resilience assessment. Halff Associates will prepare both a Risk and Resilience Assessment (RRA) and Emergency Response Plans (ERP) for the District to enhance the District's ability to withstand a wide variety of threats and prepare the District to certify completion by June 30, 2021. RECOMMENDATION: Staff recommends approval of a Task Order Agreement with Halff Associates for professional engineering services for Phase I Risk and Resiliency Assessment (RRA) and Phase II Emergency Response Plans (ERP) for a cost of $77,200, and authorize the General Manager to execute the necessary documents to implement the Board action. 134 of 148 November 16, 2020 Regular Meeting Agenda Packet October 30, 2020 P38683.002 Mr. Alan Fourmentin Trophy Club Municipal Utility District No.1 100 Municipal Drive Trophy Club, Texas 76262 RE: Proposal for AWIA RRA and ERP Preparation 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 both a Risk and Resilience Assessment (RRA) and Emergency Response Plan (ERP) in compliance with America's Water Infrastructure Act (AWIA). 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). Services will begin upon NTP. 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: David M. Smith, PE — Halff Preston D. Dillard, PE - Halff 135 of 148 November 16, 2020 Regular Meeting Agenda Packet ATTACHMENT 'A' Scope of Services Overview Halff Associates will prepare both a Risk and Resilience Assessment (RRA) and Emergency Response Plans (ERP) for the Trophy Club MUD No.1 (District) to enhance the District's ability to withstand a wide variety of threats and prepare the District to certify completion by June 30, 2021. By the EPA deadline of December 30, 2021, we will provide the District with an ERP that clearly identifies emergency response needs and procedures and can be maintained as a living document. As background, in October 2018, the passage of America's Water Infrastructure Act (AWIA) established the requirement that all community water systems serving a population of greater than 3,300 must comply with Environmental Protection Agency (EPA) requirements for risk and resilience assessments and emergency response plans. The AWIA also requires all drinking water system providers who serve a population greater than 3,300 to prepare or revise their Emergency Response Plans (ERPs) to incorporate the findings of each risk and resilience assessment. Scope Tasks Halff will conduct the following specific tasks as part of this Task Order: PHASE I: Risk & Resilience Assessment Task 1: Identify Critical Assets and Threat Scenarios The first task will be to evaluate the threats to the District's existing water assets and partner systems based on metrics associated with potential loss of life or serious injury; economic disruption; loss of confidence in the utility; and impacts to the environment. To expedite this task, Halff will consult with utility staff to eliminate non-critical assets from any further assessment. We will develop and distribute a survey to gather information from a specific group of stakeholders that are appointed by the District to serve as the Stakeholders Advisory Committee (SAC) to assist at key points in this project. This committee should include representatives of the water utility, public works, police and fire departments, IT official charged with cybersecurity, staff member involved in public outreach and the District manager or appointed representative. Assets to be evaluated may include: • Pipes for potable water transmission and distribution • Storage and distribution facilities • Other critical assets as identified by the District • Water quality monitoring system • Standard Operations and Maintenance procedures • IT Network (SCADA System, Billing system, etc.) Task 2: Consequence and Vulnerability Analysis to Determine Threat Likelihood In this stage of the RRA, we will perform a quantitative ranking of the most severe consequences that may result from specific threats to the District's critical water assets. Consequences to consider include: • Service interruption 136 of 148 November 16, 2020 Regular Meeting Agenda Packet • Financial loss • Serious injury or fatalities • Economic impact to the District and the customers in its service area • Vulnerability of shared systems and connections. Vulnerabilities will be identified through site inspection reports, the evaluation of existing asset data, the survey responses obtained from the SAC, examination of existing system and partner mitigation plans, the District's operating procedures and financial management infrastructure. To determine relevant threats from natural hazards, we will analyze historical natural hazards data to identify threats of concern. Task 3: Risk & Resilience Assessment The primary task completed in this phase will be the Risk and Resilience Assessment of all identified Utility risks, resulting in a ranking of the threat -asset pairs that identifies the greatest vulnerabilities to the water utility. The baseline calculation of risk for each threat scenario will result in a full accounting of risks and projected financial impact for a broad range of hazards. We will review the results of the baseline RRA and potential countermeasures with staff. To prepare the final RRA, we will reconvene the SAC in a workshop to identify and prioritize operational and financial resiliency strategies that provide the District with the greatest human and financial benefits. The outcome of this final meeting will be an actionable plan of risk reduction alternatives. Task 4: Risk & Resilience Action Plan This task will be completed to contribute to the District's CIP by building upon the assessment conducted in Task 3. We will identify preliminary options to promote resilience associated with the threats, vulnerabilities and their potential costs as identified in Task 2. A cost benefit analysis will be conducted in order to vet the preliminary options into an action plan, and the Halff team will meet with the SAC to review those results. Based upon that analysis and feedback from the SAC, recommendations will be made for the District to include in their CIP. Task 5: EPA Certification of RRA Halff will prepare and submit a Certification of Completion to the EPA Administrator by June 30, 2021 to certify that the District has complied with the requirements of AWIA to "conduct an assessment of the risks to and resilience of its system." 137 of 148 November 16, 2020 Regular Meeting Agenda Packet PHASE II: Emergency Response Plan This project will develop a new a ERP that responds to the District's current emergency response needs while meeting requirements of the AWIA. An effective emergency response takes more than a plan. An ERP provides the greatest value if it is maintained as a living document and understood by everyone in the organization. Halff will develop a District Water Utilities ERP according to AWWA M19 guidance standards to meet all EPA requirements, while establishing methods to help employees understand their roles and responsibilities in mitigating threats and responding to incidents. Task 1: Planning the District's new ERP The planning process will build upon the findings of the RRA to engage utility personnel and other partners in the District's water supply and delivery system through the SAC. Halff will help the District to define each partner's role in emergency response. Our cybersecurity team will meet with the District's IT personnel and identified stakeholders to develop a map of connectivity among these partner systems and identify potential risks and responses for process control and enterprise systems. Task 2: Prepare Draft Emergency Response Plan (ERP) Once these roles and interdependencies are defined, Halff will convene the SAC to facilitate a half-day of cross -functional planning sessions and tabletop workshops that address both physical security and cybersecurity. The planning exercises will consider natural hazards, threats arising from malevolent acts, cyber threats and other risks identified in the RRA. The workshops will identify procedures, equipment and actions to detect, deter and mitigate threats, thereby improving the resilience of the system and protecting the general public, personnel, property and equipment. The outcomes of these sessions will be hazard -specific plans that consider: • emergency interconnects options for temporary source disruption • alternative water sources • construction of flood protection barriers • operations and maintenance procedures • chemical storage and handling • asset management procedures • financial readiness Based on the specific actions defined in the plan, Halff will recommend role -based training and communication activities for appropriate employees and procedures for ongoing plan review and maintenance, emergency drills and training to establish and maintain a culture of preparedness. To conclude the planning process, Halff will incorporate the work session proceedings and recommendations into a draft plan document according to AWWA's M19 guidance for review. Task 3: Finalize Emergency Response Plan The team will then facilitate a plan review session with the SAC to finalize the document. The resulting ERP will be revised according to District specifications. When implemented, it will improve the safety and reliability of the District's water system. Task 4: EPA Certification of ERP Make final revisions as necessary and certify completion of ERP to EPA Administrator by December 31, 2021. 138 of 148 November 16, 2020 Regular Meeting Agenda Packet ITEMS NOT INCLUDED IN THE EXISTING SCOPE OF SERVICES Additional Services not included in the existing Scope of Services — District and Consultant agree the following services are beyond the Scope of Services described in the tasks above. However, Consultant can provide these services upon District's written request. Any additional amounts paid to Consultant as a result of any material change to the Scope of the Project shall be agreed upon in writing by both parties before the services are performed. These Additional Services include the following: 1. Planning and engineering design services of resilience solutions as identified through the course of this assessment. DELIVERABLES AND DISTRICT'S ROLE Deliverabl Phaar imillimil District's Role in Task 1: Identify Critical Assets and Threat Scenarios Task 2: Consequence and Vulnerabiliy Analysis to Determine Threat Likelihood Task 3: Risk & Resilience Assessment Task 4: Risk & Resilience Action Plan Task 5: EPA Certification of RRA Subtotal. Task 1: Plan Plan -Kick-off meeting w District -Data request -Survey of stakeholders - Meet w/SAC - Report on consequences of multiple threat scenarios. - Database of interdependency and proximity threats. -RRA draft - Risk & Resiliency Assessment - SAC priority -setting workshop - RRA Action Priorities document with CIP recommendations - Certification of Completion to EPA Administrator District's New Emergency Response -Recommendations for the ERP and/or related documents - Connectivity report of automated systems. - Meeting with SAC - Identification of Critical Risks - Prepare Draft ERP - Circulate Draft ERP to SAC - Incorporate comments - Preparation of final ERP - Certification of Completion to EPA Administrator Task 2: Prepare Draft ERP Task 3: Finalize ERP Task 4: EPA Certification of ERP Subtotal: Total: 139 of 148 -Provide data $18,400 -Establish SAC -Invite SAC - Provide mtg location - Respond to inquiries $10,500 in a timely manner - Provide additional $6,800 data as needed - Invite SAC to $17,500 workshop - Provide mtg location - Feedback on priorities - Mail certification $1,000 document from District offices $54,200 - Provide data and $6,000 related documents - Invite SAC $10,000 - Provide mtg location - Review and provide $4,500 comments on draft - Mail certification $2,500 document $23,000 $77,200 SCHEDULE Aug. Phase I Task 1 Task 2 Task 3 Task 4 Task 5 Sept. I Oct 2020 Nov I Dec November 16, 2020 Regular Meeting Agenda Packet Jan I Feb I Mar I April I May I June I July I Aug I Sept I Oct I Nov Dec 2021 M ■ Phase II Task 1 Task 2 Task 3 Task 4 ATTACHMENT 'B' PROPOSED FEE SCHEDULE I. BASIC SERVICES A. Identify Critical Assets and Threat Scenarios $ 18,400.00 B. Consequence and Vulnerability Analysis $ 10,500.00 C. Risk & Resilience Assessment $ 6,800.00 D. Risk & Resilience Action Plan $ 17,500.00 E. EPA Certification of RRA $ 1,000.00 F. Plan New Emergency Response Plan (ERP) $ 6,000.00 G. Prepare Draft ERP $ 10,000.00 H. Finalize ERP $ 4,500.00 I. EPA Certification of ERP $ 2,500.00 Total Basic Services (Lump Sum, Not -To -Exceed) $ 77,200.00 Direct Expenses $ 200.00 (Included in Basic Services Lump Sum and Special Services Not to Exceed) The project will be lump sum. 140 of 148 November 16, 2020 Regular Meeting Agenda Packet 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. The summary of hourly billing rates included in the October 18, 2018 Agreement for Professional Engineering Services has been updated. The rate table below reflects the current rates which will apply to this task order. Labor Category Level Billing Rate Range Low gh Architect Engineer Scientist Landscape/ Planner Surveyor Field Tech 141 of 148 75.00 92.00 130.00 199.00 226.00 85.00 107.00 146.00 188.00 232.00 72.00 98.00 133.00 170.00 213.00 72.00 88.00 121.00 155.00 209.00 92.00 96.00 133.00 140.00 51.00 65.00 86.00 116.00 90.00 126.00 166.00 219.00 325.00 110.00 145.00 211.00 239.00 350.00 97.00 128.00 168.00 215.00 350.00 88.00 121.00 153.00 201.00 340.00 95.00 118.00 142.00 186.00 69.00 85.00 107.00 138.00 Office Tech Administrative Specialist Intern Notes: 1. Labor Category (Specialty): November 16, 2020 Regular Meeting Agenda Packet ✓ 153.00 216.00 43.00 69.00 I I 69.00 89.00 III 86.00 120.00 IV 112.00 144.00 ✓ 140.00 182.00 29.00 69.00 I I 67.00 85.00 III 82.00 112.00 IV 111.00 143.00 ✓ 144.00 350.00 66.00 97.00 11 97.00 133.00 III 124.00 171.00 IV 174.00 208.00 ✓ 223.00 333.00 44.00 69.00 Architect Engineer (Civil, Structural, Mechanical, Electrical, Oil & Gas) Scientist (Environmental and Geological) Landscape/Planner Surveyor Field Tech (Survey, SUE, Environmental & Construction) Office Tech (CADD, Designer & Surveyor) Administrative (Accounting, Assistant, Marketing & Human Resources) Specialist (GIS, ROW, Visualization & IT) Intern 2. Rate Changes: All rates are subject to annual adjustment (typically in July) which will be submitted to the client for review prior to implementation. 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. 142 of 148 November 16, 2020 Regular Meeting Agenda Packet 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 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. We will proceed upon receiving the signed copy of this proposal. Signature blocks are on the following page. 143 of 148 By: HALFF Submitted: November 16, 2020 Regra. r AlManeetingourmAgeenndatin Packet Mr. TCMUD No. 1 October 30, 2020 Page 10 Approved: HALFF ASSOCIATES, INC. TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO.1 David M. Smith Printed Name Public Works Team Leader Title /0 /30/ ZvZO Date By: 144 of 148 Signature Printed Name Title Date rtOPHV CLUB MIITIICI PAL FTILITY DISTRICT November 16, 2020 Regular Meeting Agenda Packet STAFF REPORT November 16, 2020 AGENDA ITEM: Consider and act to award Contract No. 2020111601 for Fence Replacement at the wastewater treatment plant as part of Fiscal Year 2021 Capital Improvement Projects and authorize the General Manager to execute the necessary documents. STAFF REPORT: In March of 2020 as part of FY2020 Capital Improvement Projects the Board awarded a contract to replace half of the fence at the wastewater treatment plant and budgeted for the remaining 773 LF of fence to be replaced in FY2021. The following bids were received for this project: Felix Construction Company: $79,234 DFW Services, LLC: $57,235 Rey -Mar Construction: $49,478 STAFF RECOMMENDATION: Staff recommends awarding Contract No. 2021111601 to Rey -Mar Construction for an amount not to exceed $49,478 as part of Fiscal Year 2021 Capital Improvement Projects and authorize the General Manager to execute the necessary documents. 145 of 148 g4'4m -111tf'727,, ATLAS UTILITY SUPPLY COMPANY 2301 CARSON STREET FORT WORTH. TEXAS 76117-5212 817.8314275 FAX 817.831.1014 EMAIL: SALESCATLASUTILITY.COM November 16, 2020 Regular Meeting Apit IttatIOTE Page 1 Printed 07/15/20 DKJ Quoted Ship To TROPHY CLUB MUD #1 SAME 100 MUNICIPAL DR. TROPHY CLUB TX 76262 Te1:682-831-4687 Fax:817-490-0705 . EH 9003339 07/13/2020 01/09/2021 0001615 BEACON CELLULAR DKJ NET 30 DAYS Std DENNIS JOHNSON JR BMM70 HRELCD TW BADGER M70 HRE LCD WITH TWIST EA 5053 67.00 338551.00 TIGHT CONNECTOR - USG BMO LTE -M CELLE BADGER CELLULAR LTE -M ENDPOINT EA 5053 121.00 611413.00 WITH TWIST TIGHT CONNECTOR - ORION LTE -M - TWIST TIGHT CONNECTOR - THRU-LID MOUNTING KIT TRAINING TRAINING FOR BEACON DATA EA 1 1500.00 1500.00 EXCHANGE BMSUBFEE BADGER METER MONTHLY EA 0 0.81 0.00 SUBSCRIPTION FEE ************* X: (Accepted by) *Beacon Cellular Subscription Fee* (Fee is .81 cents per meter per month if paid annually.) ************** Sub Total $951,464.00 Freight $0.00 Total Misc Charges $0.00 Tax Amount $0.00 951,464.00 MESSAGE TERMS 146 of 148 g4 4111, +lei 'AM %i_w "Off ATLAS UTILITY SUPPLY COMPANY 2301 CARSON STREET FORT WORTH. TEXAS 76117-5212 817.8311.42.75 FAX 811 7.831.10114 EMAIL: SALESCATLASUTILITY.COM November 16, 2020 Regular Meeting A/VtQtIO/ L Page 1 Printed 07/15/20 DKJ Quoted Ship To TROPHY CLUB MUD #1 SAME 100 MUNICIPAL DR. TROPHY CLUB TX 76262 Buyer: Mike McMahon Te1:682-831-4687 Fax:817-490-0705 iter::: _003340107/13/2020101/09/2021 0001615 ISE ENDPOINTS BEST WAY DKJ NET 30 DAYS Std DENNIS JOHNSON JR :�:r�?�:4�4'"��:�.':.'.':.'.'.'.':.'.'.�:�::13:es�:>"p�#�:':':':':':':':':':':':':':':':�:�:�:':':�:�:�:�:�:�:':':�:�:�:�:�tJi�d::::::Qiaa��:;�:thz�•t::1?:r�:ce• •::•Erxter�s�:��: BMM70 HRELCD TW BADGER M70 HRE LCD WITH TWIST EA 5053 67.00 338551.00 TIGHT CONNECTOR - USG BMOFHSE TT BADGER ORION - SE - FIXED EA 5053 119.00 601307.00 NETWORK ENDPOINT WITH 8" WIRE LEAD AND TWIST TIGHT CONNECTOR TRAINING 2 DAY BADGER 2 DAY ON SITE TRAINING EA 1 5500.00 5500.00 BMOSEGWTRANS BADGER ORION * SE * FIXED EA 10 5495.00 54950.00 NETWORK GATEWAY TRANSCEIVER - LTE/LAN DUAL BACKHAUL, 100' POWER/COMMUNICATION CABLE. BADGER BACKHAUL BADGER GATEWAY CELLULAR EA 120 19.00 2280.00 BACKHAUL COMMUNICATION SERVICE CHARGES *BILLED DIRECTLY BY BADGER* BADGER HOSTING BADGER HOSTING FEE (HOSTING FEE CHARGE IS A PER MONTH PER ENDPOINT FEE BILLED ANNUAL DIRECTLY BY BADGER TO CUSTOMER) X: (Accepted by) EA 5053 0.20 1010.60 Sub Total 1,003,598.60 Freight $0.00 Total Misc Charges $0.00 Tax Amount $0.00 1003598.60 MESSAGE TERMS 147 of 148 TC Meeting Spaces FS Confe Calendars December 2020 Sun Mon Tue Wed Thu Fri Sat FS Training Room Svore Board Room co Modifier November 16, 2020 Regular Meeting Agenda Packet 49 Nov 29, 2020 30 50 6 51 13 52 20 1 27 7 14 21 6:30pm r'�1 Board of Di Dec 1 8 15 22 9 16 23 3 17 24 1. 18 2pm Bid Opening Chi 25 5 12 19 26 28 29 30 31 Jan 1 2 148 of 148 Powered by teamup