Loading...
HomeMy WebLinkAbout2020-0615 June 15, 2020 Regular Meeting Agenda PacketMonday, June 15, 2020 Nei TROPHY CLUB June 15, 2020 Regular Meeting Agenda Packet BOARD OF DIRECTORS REGULAR MEETING TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 100 MUNICIPAL DRIVE TROPHY CLUB, TEXAS 76262 6:30 P.M. Svore Municipal Boardroom REGULAR MEETING AGENDA PACKET In accordance with Order of the Office of the Governor issued March 16, 2020, Trophy Club Municipal Utility District No. 1 Board of Directors will conduct a meeting at 6:30 p.m. on Monday, June 15, 2020 by Zoom/telephone conference. In order to advance the public health goal of limiting face-to-face meetings (also called "social distancing") to slow the spread of the Coronavirus (COVID-19), there will be no public access to the location described above, but members of the public may join the meeting by weblink or telephone by following the instructions below. A recording of the telephonic meeting will be made and will be available to the public. To join the meeting via Zoom: https://us02web.zoom.us/i/86164493466 The public toll-free dial -in numbers to participate in the telephonic meeting are: 1 888 475 4499 and 1 877 853 5257; Meeting ID: 861 6449 3466 If you cannot get through on one of the numbers due to network congestion or if the audio quality is poor, please try the next number. When your call is answered you will hear "Welcome to Zoom, enter your Meeting ID followed by pound." Enter in the following Meeting ID below followed by the pound sign (#): Meeting ID: 861 6449 3466 CITIZEN COMMENTS: Public comment will be allowed during the Citizen Comment agenda item. No in-person input will be allowed. Members of the public that desire to provide public comment may do so by videoconference, by telephone or by submission of written comments. Written public comments that are timely received will be read into record and can be emailed to Islaght@tcmud.org . Written comments must be received by 4:00 p.m. on the date of the meeting. To provide verbal public comment remotely (by videoconference or telephone), members of the public must register in advance by emailing Islaght@tcmud.org prior to 4:00 p.m. on the date of the meeting. 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 1 of 150 June 15, 2020 Regular Meeting Agenda Packet 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. Citizen Comments should be limited to matters over which the Board has authority. CONSENT AGENDA All matters listed on the 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. 1. Consider and take appropriate action to approve the Consent Agenda. a. May 2020 Check Register b. May 18, 2020 Regular Meeting Minutes attachments: May Check Register May 18, 2020 Meeting Minutes REGULAR SESSION 2. Introduction of new General Manager Alan Fourmentin (Steve Flynn) 3. Consider and take appropriate action regarding proposals received for Annual Financial Auditing Services and award Contract No. 2020061501; and authorize the General Manager to execute the necessary documents. (Chapman/Flynn/Krolczyk) attachments: Auditor Score Summary Contract No. 2020061501 4. Consider and take appropriate action to select two (2) Directors to participate on the Budget Review Committee. (Krolczyk) 5. Consider and take appropriate action regarding District bank signatories including: a. Approve Resolution No. 2020-0615A designating authorized signers on Prosperity Bank accounts. b. Approve Resolution No. 2020-0615B designating depository designating authorized signers on Texpool Accounts. attachments: Resolution No. 2020-0615A Resolution No. 2020-0615B 6. Discussion and possible action regarding District Payment and Billing Policies. (Wilson) 7. Consider and take appropriate action regarding the May 2020 Combined Financials and Variance Report. (Krolczyk) a. Combined Financials b. Combined Variance 2 of 150 June 15, 2020 Regular Meeting Agenda Packet attachments: Combined Financials Combined Variance REPORTS & UPDATES 8. Staff Updates: a. Capital Improvement Projects b. Water Operations Report c. 2019 Consumer Confidence Report (CCR) d. Wastewater System Reports e. Finance Reports attachment: General Manager Report EXECUTIVE SESSION 9. Pursuant to Section 551.071 of the Texas Open Meetings Act, the Board may consult with its attorney in Executive Session on a matter in which the duty of the attorney to the Governmental Body under the Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflicts with the Open Meetings Act or to seek advice of counsel on legal matters involving pending or contemplated litigation or settlement offers: a. Contractor breach, performance and payment issues related to District's contract with Webber- Cadagua Partners for construction of the Wastewater Treatment Plant Improvements; and b. Trophy Club Municipal Utility District No. 1 v. Acadia Services, LLC, In the District Court of Tarrant County, 141st Judicial District (Cause No. 141-299351-18). c. Potential Condemnation of Easements required for construction and operation of Water Transmission Line Improvements from District Pump Station to Elevated Water Tank located on T.W. King Road. d. Potential modification or termination of Independent Contractor Agreement dated August 1, 2017, as subsequently amended, for independent contractor services relating to pending litigation matters, condemnation proceedings, completion of wastewater treatment plant project, and other pending District projects. 10. 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. Sale, Lease or Exchange of District real property located at 100 Municipal Drive, 1501 Junction Way and other real property owned by the District. b. Purchase of Easements required for construction and operation of Water Transmission Line Improvements from District Pump Station to Elevated Water Tank located on T.W. King Road 3 of 150 June 15, 2020 Regular Meeting Agenda Packet REGULAR SESSION 11. Consider and take appropriate action on matters deliberated in Executive Session: 12. Discussion and possible action relating to modification or termination of Independent Contractor Agreement dated August 1, 2017, as subsequently amended, for independent contractor services relating to pending litigation matters, condemnation proceedings, completion of wastewater treatment plant project, and other pending District projects. 13. Items for future agendas: 14. Set future Meeting dates: a. Regular Board Meeting on July 20, 2020 at 6:30 p.m. b. Joint Meeting with Town Council regarding FY2021 Fire Department Budget attachment: July 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 DISTRICT'S PRIOR PRACTICE OF SPECIFICALLY IDENTIFYING ALL AGENDA ITEMS TO BE DISCUSSED IN EXECUTIVE SESSION. ADJOURN 4 of 150 Tckamt2 skrolazyk Begin Date: 05/01/2020 End Date: 05/31/2020 Number - 998 »19L AN REAL PM Tbtals for Check: 6400 In :ace D001002006110 From amt: Inv pert AOCCnnt Date - Stat _ .NCS Nuaber 04/30/20 P 998 CB JENI HCMSs-TROPHY Cites-idC- U00100001 ODA 04/30/20 Totals.for (heck: 6401 998 MIRY, DAN /EL Totals for Check: 6402 996 DAL-RESIDENTIAL"1 LLC Totals for Check: 6103 996 MESS, DON Totals far C21edk: 6404 . 996-FERDL, BARRY 7bi a7 s for C beck: 6405 x001005042410 135-20050-000-000 P -135-.20050-000-000_ 135-20050-000-000 2 135-20050=000-000 P 135-20050-000-000 04/30/20 P 170010080604105A 04/30/20 00030121499205A 04/30/20 00020001099273! 04/30/20 "2 TroOhy clth Nw No.1 AP Checks For Date/Amount Rarer .00 Tb Ani: 99,999,999.99 Desdription A/P Vers A/P Veodars A/P Venders A/P Vers A/P Veadass 135-20050-000-000 A/P Vendors 998 iii, PATRICIA x0023150021204X 04/30/20 P 135-20050-000-000 A/P Vendars Totals for Check: 6406 x0010070466101A 04/30/20 P 135-20050-000-000.. 7/2 Verrs 998 KE i, AARON 110022080005202A 04/30/20 P 135-20050-000-000 A/P Vendors Totals for Check: 6408 998 NICi/60N,.BRAN' x0020001075219A-04/30/20 _P 135-20050000-000.- - A/PVeredrs Thtal8 for Check: 6409. 998 NITSCHKE, FELIX AND SYLVIA 000200009682057. 04/30/20 P 135-20050-000-000 A/2 Vendars Totals for Check: 6410 996. swim., RC6 d' 1:0050360004105A 04/30/20 P 135-20050-000000 A/PVendors TOtale far Cii@c1s: " 6411 998 SWEATT, JERRY 09012510009902A 04/30/20 9 135-20050-000-000 A/P Vers Totals for Check: 6412 998- Vii,- HAT Totals for Check: 6407 3193 - C,LNPOPAY, INC. - - Totals far C3sedk: 6413 2676 2676 2676 2676 2676 Humana Inc Manna lnd Humana Inc IncManna i6aa Inc -PRO 996-05/01/20-. 155516458 155516458 155516458 155516458 155516458 05/01/20 05/01/20 05/01/20 05/01/20 05/01/20 P P P 2 135-21313-000-900 Cafe _1254ed4.da1 Rema - 135 -21308-000-000 135-21309-000-000 135-21311-000-000 16 135-50029-010-000 20 135.50029-020-000 Dental Vision Voluntary Life Life Insurance &-Other - - Life Insurance - & Othere 5 of 150 J595920204Regular Meeting Agenda Past 1 Lacus Iwo- (seat (mem Val a Ncaber Date 12.33 6400 05/01/20 12.33 54.44 6401 05/01/20 106.39 6402 05/01/20 106.39 53.89. 6403- 05/01/20 - 53.89 66.63 6404 05/01/20 86.63 06.94" :-6405 05/01/20- 06.94 40.66 6406 05/01/20 40.66 -04:72_ --6407- "05/01/20 -04.72 27.46 6408 05/01/20 27.46 85.76 .6.4.09 05/01/20. 85.76- 33.78 6410 05/01/20 33.78 08.70- 6411 -05/01/20 _- 08,70 08:70 49.12 6412 05/01/20 49.12 549.37 - 6413 .05/01/20 549.37 1,395.02 192.62 318.36 176.88 186,78 6414 05/01/20 6414 05/01/20 6414 05/01/20 6414 05/01/20, 6414 -55/01/20 .. apacisamt2 skro1czyk Begin Date: 05/01/2020 and Date: 05/31/2020 ue accr- venom- Name a aeN . 2676 arcane lac Totals for Chet'.k: 6414 3124 SRS 'Faze Paynent 3124 IRS 'Paas Pay t 3124 IRS Tact Payment Totals for Check: 6415 2943 ..7ENCRGAN CHASE SANK NA Lbtais for Check: 6416 - -3115-_- AEMLIFB GROUP IHNEFITS 3115 9E1LIF3 MOIR aTLS 3115 NEIL= GROUP BENEFITS 3115 MBTLIPE CROUP BTPS Totals :for (Heck: 6417 From Mat: Irate Stat - N3 rubes 155516458 05/01/20 -PR00695 996-05/01/20 PRLi0695- 996- 05/01/20 PR00595 996.05/01/20 04272020 5/15/2020 5/15/2020 5/15/2020 5/15/2020 3113 TCORS PR00695 Tbtals for Check: 6418. 2742 Pmber Beard 051120 Totals- ft= Check: 6419 3187 LIS SHtil t"EQUIPMENT=," TNC 25094 Totals f& (Heck: 6420 2655 Core & Main LP M184918 Totals for Check: 6421 3080 i'P&Y At Ems, ' INC. 1 4:i2000070- Totals for Check: 6422 3184 DAA LLC . 3104:DATAPROSE ILC Tatals far Cheek:.. 6423 1737 DPC INDUSTRIES, INC Totals for Check: 6424 3118-33cclusive Peat antral Totals foraeek:- 6425 2606 Fisery Solutions, LLC Totals for Check: 6426 P P 04/27/20 P _05/01/20 05/01/20 05/01/20 05/01/20 30 135-50029-030-000 135-21302-000-000 135-21303-000-000 -_ 135-233044100-000 135-20060-000-000 E- ---.135-21315-000-000-_- P 10 135-50029-010-000 P 20 135-50029-020-000 P 30 135-50029-030-000 996 5/01/20: 05/11/20 P 1 04/27/20 "P 135-21317400-000 30 135-60100-030-000 20-.135-55081-020-000 - 04/23/20 P 10 135-65050-010-000 05/06/20 - P_- 20 135-69005-020-000. D22001393 04/30/20 P 30 135-60035-030-000 D22001593 04/30/20 2- 30 - 135-5520505-030-000 767001875-20 7791 91700671 04/20/20 P 10 135-65030-010-000 03/25/20 - P- -30 135-55080-030-000 05/05/20 P 30 135-60040-030-000 -- 2635 3a1ff.Assocs.ates, INQ 10037154 - - 05/05/20 --P- -30 135-69005-030-000 ttatais -fon' Check: - 6427 Trophy Club MD No.1 AP Checks For iaate/Arra ntt Range .00 To Int: 99,999,999.99 Life Thsuauce & Other DM Taxes gn,4a1- S6curity 7:axes Medicare Taxes Procurement Clearing Short Term Disability Life Insurance & Other Life Insurance & Other Life Insurance & Other TCDRS Travel & per diem Maintea & 1 aJ. C oIlectiaaas: - Meter Zcpense Capital Outlays - - Postage Utility Billing g- Contract C nemi.cal.s maintenance & Repairs_ Service Charges & Fees tel Outlays 6 of 150 Juro&&p20ffi4tegular Meeting Agenda Pah 2 Jar.- =en - cmc uamt Value Amber rate 176.22 6414 05/01/20 2,445.88 4,806.93_ - 6415 -415/01/20." 5,841.72 - -6415 05/01/20 1,366.25- 6415 05/01/2.0. 12,014.91 2,007.14 6416 05/01/20 2,107.14. - 74.36-1 --0417 .€15/01/20 132.01 6417 05/01/20 165.74 6417 05/01/20 151.69 6417 05/01/20 523.80 7,92291 6418 05/01/2 7,922.91 306.48 6419 05/11/20 306.48- 390.21 - - 6420. 05/11/20 390.21 14,713.30 6421 05/11/20 14,713:30 9;525.00 ---6422 05/11/20 9,525.00 1,464.27 6423 05/11/20 537.64 6423 05/11/20 2,001,91 558.41 6424 05/11/20 558.41 110.00 "6425 05/11/20 -110.00 50.00 6426 05/11/20 50.00 3,669.08 6427 :05/11120- 3:.669.08 _ - apackamt2 skrolczyk Begin Date: 05/01/2020 End Date: 05/31/2020 vent r v mar mane Hurter 1468 L.H. CHANEYHATFRIALS, 3, 171381 1468 L.H. �N( MATERIALS, INC. 171534 Totals far Q k: 6428 3216 -M3 Networks - - Tatalar far 6429 3111 North Texas Groundwater Totals for Check: 6430 3156 CEIDDR=LABOMMES LW 3156 CACCDORIaiLLC. - 3156 =DOR IAMPATCRIES ILC 3156 flims Leoussikauso LLC 1t,tals for Check: 6431 3176 - RE-31AR C IT N 3176 REY- 4W. usoaaw-4-.4 - 3176 "REY-bAR C[tISx mriCN Totals far Check: 6432 6014" Fran Pint: In ide-late-Dept Acoamit Date -Stat -No - Halter 04/25/20 P 20 135-55125-020-000 05/02/20 P 20 135-55125-020-000 04/29/20 -30- 135-69005-030-000 186 04/01/20 P 10 135-60135-010-000 20050037 20040465- 20040511 20050105 05/04/20 P: "20 "135-55235020-000 04/27/20. :P 20--135-55135-020-000_" 04/29/20 P 20 135-55135-020-000 05/07/20 P 20 135-55135-020-000 6. 05/11/20. P 10 135-69005-010400 HIM BLEWSOCIND 05/08/20 9- 20 135-69005.020-000 MIT 8 Fi FENCE 05/08/20 P 20 135-69005-020-000 2440 MEOW 2 r CIY PUBLIC HEALTH. IAB 33452 :2440 - T4YRRAt r C1Y PUBLIC -F iAB - 33453 Tbra1 q for CSieCk: 6433 2696 Texas SYceavatioo Safety Systen 20-07904 Totals for Check: 6434 1001 . TOW OF MOM? CLUB APRIL REFC78E- 1001 1stioacce TROPHY CLUB: APRIL. MUM 1001 TUN OF TROPHY CLUB APRIL REFUSE 1001 TC11U OF TROPHY CLUB 050120 Totals for Check: 6435 1000 1000 Totals TROPHY CUB Mw 049TER 90r74) TFC851Y. CLUB 1,.113 (WRIERRTra.r,)" for Check: 6436 04/30/20 9 10 135-55135-010-000 04/30/20" -P 10- 135-55135-010-001 04/30/20 P 30 135-60040-030-000 04/30/20 04/30/20 04/30/20 05/05/20 P - - --- -135-25040-000-000- P_ 135-25000-000-000 P 135-25010-000-000 9 45 122-60337-045-000 03/33,26" -03/31/20 F- --30 . 13540025-030-000 4/30/20 04/30/20 -P 30---135-60025-030.000 2634 Valley Solvent Capany, INC 56180 Totals for Cheek; 6437 1058 " VERL2CHICRETZSS 1058 VERIZCNI41203L8S8 1058 VERIZONICRELESS 1058 VERIZON WIRELESS teals- for Check- £438 __9853608143 9853608143 9853608143 9853608143 05/05/20 P 20 135-65030-020-000 05/01/20 05/01/20 05/01/20 05/01/20 P P" P P 10 20 30 30 135-60010-010-000 135-60010-020-000 135-60010-030-000 135-60010-030-000 Trophy Club MUD No.1 AP Cheres For nate/Amount Range .00 TO ant: 99,999,999.99 Description tumpeter Services 0aipoter Service Capital Outlays TOM Fees 8 Permits Laix- Analysis lab Aknal.ysis Lab Analysis lab Analysis Capital Outlays-- Capital Outlays Capital Outlays Lab Analysis Laic Analysis for PID Service Charges & Fees Tbs+a-Stcu3n Irainage. I base Refuse Tax Transfer to /Fire Budget Water" Seater Chemicals Catrani.attircs/Hcbilee Ckmmuni.catia a/Mobiles Crenunicaticros/Mobiles Ckimcaiicatitns/Mabiles Juri0304k020i1fiegular Meeting Agenda Pao 3 !lane lean - cs�er�c Value - Hunter Date 1,259.84 6428 05/11/20 2,471.32 6428 05/11/20 3,731.16 4,866.55 6429: 05/11/20. 4,866.55 3,262.20 6430 05/11/20 3,262.20 341.55 .4431 05/11/20.. 341.55 6431 05/11/20 241.50 6431 05/11/20 241.50 6431 05/11/20 1,166.10 87,311.25 6432' 05/11/20 71,496.00 -5432'05/11/20.-- 49,978.00 6432 -05/11/20 208,785.25 220.00 6433 05/11/20 80.00 6433 05/11/20 300. [10 252.70 6434 05/11/20 252.70 34,820.92 6435 05/11/20" 64,875;39 6435-05/11/20 5,439.38 6435 05/11/20 59,888.08 6435 05/11/20 165,023.77 504,30 6436 05/11/20 1,354.70 6436 05/11/20 1,859.00 580.00 6437 05/11/20 580.00 385.40 -- 6438 : -05/11/20 407.91 6438 05/11/20 (150.00} 6438 05/11/20 99.26 6438 05/11/20 742.57 7 of 150 apackarr-2 skrolczyk Begin Date: 05/01/2020 End Date: 05/31/2020 verso= - veer= Name . Umber 3280 WATT" Puss -ON LLC 3280 WATTS EELI91 IZC Totals far Check: 6439 2222 - - AFDC:. . . . 2222 AMC: . . Totals for Check: 6440 3197 HenefitMall 3197 :.BereiHtMall. 3197 Teug,fttMall Tota1.8 #tar Check: - - 6447. 3262 BRANDON R REED Totals far Check: 6442 2683 C3aarter tbtstnicatic es 'Ibtala for check: 6443 2655 Care & Main LP Totals far Check: 6444 3393 O:HPIiPAY, :DC. Totals for cheek: 6445 2497 2497 2497 2497 2497" 2497 DHS AUPCNATION, 1N DIS AUDOMATICV, iNC pas AtTICHATICU, INV DHS ANTO 7AT 4; INV DHS ;INC. DHS AllICKATICil, 324; Ibtals for Check: 6446 2635 Half/ Associates, INC 2635 Haiff Associates, 11 Totala- far Cheek: 6447 1372 HACH COMPANY' Totals for (heck: 6448 2676 2676 2676 2676 Humem a Fisc Humana Inc Humana Inc Huns= Imre 2676 Humana Inc 2676 Humana Inc Totals -16r Cheek: 6449 13:670132e turner m a 1Av Ac count Bate Stet kb Barber Arm: 23186 05/04/20 P 10 135-60285-010-000 23186 05/04/20 P 20 135-60285-020-000 P800695 996:05/01/20 -P 335-21312-000-000- 9800696 996.05/15/20 ,P - 135-21312-000-000 9048516 -IN 9048516-12 9048516.1N 05/14/20 P 10 135-50029-010-000 05/14/20. P 20 .135-50029-020-000 O 5/14/20 -9 30 135-5002$-030-000 2892 05/12/20 P 30 135-55080-030-000 -71672050620.. 05/06/20 : P 30 135-55030=030-000 M281188 05/11/20 P 10 135-55080-010-000 96 . 996 05/15/20 - , - 06-1970 06-1971 06-1972_ 06-1973 .- 06-1974: 06-1977 10037606 10037600 11949673 155516885 1.55516885 155516885 155516885 155516885 155516885 05/12/20 05/12/20 05/12/20 05/12120 O 5/12/20 05/12/20 -1357121313400-000 P 20 135-55080-020-000 P 20 135-55080-020-000 P 20 "135,55080-020-000 P 20 :13555080-020-000 P 20 :135-55080-020-000: P 20 135-55080-020-000 05/17/20 .P 30 135-69005-030.000 05/17/20" -:P 10 520-69005',010000 05/06/20 P 10 135-65030-010-000 06/01/20 06/01/20 06/01/20 06/01/20 06/01/20 -06/01/20 P P-" P P P -135-21308-000-000 135-21309-000-000 135-21311-000-000 10 135-50029-010-000 20 135-50029-020-000 30 -135-50029-030-000 Txnphy Cab NUD Na.1 AP checks Fbr Date/Amount Range .00 Ta Amt: 99,999,999.99 DeSCriptial, La9xi Equipment & Maintenance _._ Equipment & Maintenance Aflac- A£lac Life Insurance & Other Life Insurance & Other - Life Insurance &- Other Maintenance & Repairs Software &: Support Maintenance & Repairs Cafe 125-MediRehab Maintenance & Rg3airs Maintenance & Repairs :Maintenance & Repairs 6 RepaLire Maintenance & Repairs Maintenance & Repairs Capital Outlays Capital Outlays Chenica1a Dental_ Visite Voluntary Life Life Insurance & Other Life Insurance & Other Life is,nurance &-Other 8 of 150 Jmapaly5g20.7304degular Meeting Agenda Past 4 t zne sten meek taint Value Neer IIste- 750.00 6439 05/11/20 890.00 6439 05/11/20 1,640.00 210.67- 6440 05/21/20 -_ 210.67 - 6440 05/21/20 421.34 20.00 32.00 16,00 68.00 6441 6441 6441 05/21/20 05/21/20 05/21/20. 285.00 6442 05/21/20 285.00 899.00:-- 6443 05/21/20 899.00 3,931.20 6444 05/21/20 3,931.20 549_37 ; 6445 -05/21/20" :549.37 632.00 490.00 750.00 1,460.00- 774.00 1,310.00 5,416.00 6446 05/21/20 6446 05/21/20 6446 05/21/20 6446 15/21/20 6446. 05/21/20 6446 05/21/20 1,170.62 6447 05/21/20 10,690.00 6.447 05/21/20 11,860-62 1,008.16 6448 05/21/20 1,008.16 1,395.02 192.62 318.36 176.88 186.78 176..22 2,445.88 6449 6449 6449 6449 6449 6449 05/21/20 05/21/20 05/21/20 05/21/20 05/21/20 05/21/20 aparkamt- skrolczyk Begin Date: 05/01/2020 Sad Date: 05/31/2020 Fr m Pmt: Trophy Club Nam No.1 AP Checks 9br Date/Amount Range .00 Tb Amt: 99,999,999.99 vete ,' _ "VenC10r- Naue - - _ - - - InVDiis~ rower - Jnvzlace. -Inv. "Dept account " NbObec `Mate "--Stat No. N.rher 2775 HCOkSST ENEMY SERVICES; LLC 2005150001-19 05/15/20 P 10 135-60020-010-000 Electricity 2775 HUDSON ENERGY SERVICES, ILC 2005150001-19 05/15/20 P 20 135-60020-020-000 Electricity Totals for Check: 6450 3124 -- IRS flax.- Pam - 3124 IRS:Tax 1,4sept 3124 IRS Tax Payment Totals for Check: 6451 2735: Oac ksan 1+Ta]ker 141./=, Meals for 3 ck; 6452 9880696 996 05/15/20 P 135-21302-000-000- Pili ides PR00696 996'05/15/20 P 135-21303-000-000 Social Security Taxes " PR00696 996 05/15/20 P 135-21304-000-000 Medicare Taxes haistolAp20i334F2egular Meeting Agenda Pam 5 1tFe(? Item - "'.ileac Laze= :Value Va1u INuMbDate.- . 9,128.56 6450 05/21/20 10,912.04 6450 05/21/20 20,040.60 4,958.84'. 6451 05/21/20 5,995.04 6451 05/21/20 -_ 1,402.00 6451 05/21/20 12,355.88 4714556 05/14/20 P 10 520--69005-010-000 i tai 0ut1ays 5,128.65 6452 _05/21/2. 5,128,65 3167 REESTCNE.PARK SEM 161575 05/13/20 P 30 135-60005-030-000 Totals for Check: 6453 3132 Legai Shield PR00695 996 05/01/20 P 135-21310-000-000 3132. r.01.0 al4 2800696 996.05/15/20 P 135-21310-000-000 Totals" for Check: 6454 3216 M3 Networks 6060 05/15/20 P 30 135-55030-030-000 Software & Support Totals for Check: 6455 2712" MAS BI03QO t90; CIT, INC" 5l 1009 05/04/20 - P 20 135-65030-4220-000:- - Cle niEa3.8 Totals for -Caeck: -- 6456 2643 Yr -Lean & Howard, L.L.P. 36637 04/30/20 P 39 135-55045-039-000 530.99 6453 05/21/20 530.99 17.46. 6454 05/21/20 17.44 6454 05/21/20 34.90 494.00 6455 05/21/20 494.00 1,628.92 _":6456 .05/21/20_ 1,.628-.92- 4,842.50 6457 05/21/20 Totals for Check: 6457 4,842.50 3186 146113WS BUILD= MAINIENANCE 1C20042E3W 04/30/20 P 20--135-55120-020.000 Cleaning Services 3165 'B:BOIID}33 E :2C20041CS 04/30/20: . P 30 1.35-55120-030-000 Clsaning`Services 3186 MEMMVS 501131143 MAIHI NCE 31:2004312&D 04/30/20 P 10 135-55120-010-000 Cleaning Services Totals forCheck: 6458 87.50 6458 05/21/20 1,896.92 6458 05/21/20 87.50 6458 05/21/20 2,071.92 3115 r rrI COMP ME= 6/15/2020 . - . 06/01/20" P - 135-2131.5-000-000 Start. TennDisability 74.36 6459 05/21/20 . 3115 1m-COUAP_BMS 6/15/2020 06/01/20 . P '10 135-50029-010-000 .Life.IUst & C)kher--- 132.01 "6459 05/21/20 3115 MSPLLPE GROUP BENEFITS 6/15/2029 06/01/20 P. 20 135-50029-020-000 T fe Insurance & Other ' - 165.74 6459 05/21/202- 3115 1 TLIPE GROUP BENEFITS 6/15/2020 06/01/20 P 30 135-50029-030-000 Life Insurance & Other 151.69 6459 05/21/20 Totals for Check: 6459 523.80 1056 OFFICE 01 Tr,DC 486163052001_. 05/01/20 - P 30 135-65085-030-000- Offioe-applies 55.36 6460 05/21/20 tale for Check 6460 - 55.36 3156 anOORLABCRA1CRIMS TUC 20050177 05/13/20 P 20 135-55135-020-000 lab Analysis 241.50 6461 05/21/20 3156 oxioatIAKERATCRIES LTC 20050138 05/11/20 P 20 135-55135-020-000 Lab Analysis 326.70 6461 05/21/20 3156 OXIDOR LA8K3A'T, ILC 20050287 05/18/20 P 20 135-55135-020-000 Lab Analysis 341.55 6461 05/21/20 -3156 OKL IABCRtA2tf1 -car-- - 20050301 - :05/19/20 --P - 20 135-55135-020-000 - _ LabAnalysis- - -. 241.50- -6461. 05/21/20 Totals fOr theck3 6461 1.1.51.25 9 of 150 apacicant2 skrrlczyk Trophy Club 1W No.1 AP Checks For Date/Anrnmt Range Begin Date: 05/01/2020 End late: 05/31/2020 F au Amt: .00 To Ate: 99,999,999.99 uenr r WOO= Male Number 3176 REY-MAR OCUMICCTICH Juiefol p201Z04Flegular Meeting Agenda Paeket 6 - Invoice taxnaer DIVOI.Ce ` .1X17 . -Dept ACCMIt - - - Ute' iptiCtl - - - - - 1 d,w -.Lte l - 1.'11eCA - - - meekDate Stat No - Ember- Value Air i7ate 20 TN LINE STOP 05/01/20 P 10 135-69005-010-000 Capital Outlays 69,874.48 6462 05/21/20 Totals for Check: 6462 69,874.48 2743- Stephen, Necker 111819 05/20/20- P 10- 135755080-010-000 - _14eintenanas & Repairs 500.00 6463 05/21/200 2743- Stephen -N - 040220 04/02/20 P 10 135-55080-014-000 4ai.ntenance & Repairs 257.25 6463 05/21/20 2743 StePtenttaracer 04022020 04'/02/20 P 10 135-55080-010-000 24a ate+anf 4 Repairs ` 235..74' 6463 05/21/20 Totals far Check: 6463 992.99 3113 'iias PR00696 996 05/15/20 P 135-21317-000-000 'rriBS 8,265.58 5464 05/21/20 Totals Bar. Check. -6464 8,265.58 3282 -33AR CSt7187041 05./07/20 --P -=30- 135=69170-030-000 Copier Lease Installments 165.00 : 6465 05/21/20 'lbrals for Check: 6465 165.00 1001 TOWN OF TROPHY CLUB 051920 05/19/20 P 30 135-60020-030-000 Electricity/Gas 458.22 6466 05/21/20 . Totals - far Check: - 6456 458.22- 1081: IMILIOUNWEIXTRIC 77059896 - 05/05/20 F _ 20 -135-60020-020000 - 8%ectr5city 528.61 6467- 05/21/20 ToFaIs far Check: 6467 528.61 1087 1HITAKEt CHALK SWINDLE 259947 05/21/20 P 20 517-69005-020-000 C3pital Outlays 1,487.50 6468 05/21/20 Ibtale:for Check: _-6468 1,487.50 2716 Wilma, 7anney,.Elstner As. -- .0451255 - 05/24/20 -P 20. 517-69005-020-000- - Olathe]. Outlays 4,055c00 6469 05/21/20 Totals for Check: 6469 4,065.00 2879 ATTORNEY GEINEIRAWSTATE OF TX X2020 05/19/20 P 10 135-70040-010-000 BandRelated Expanses 1,220.00 6501 05/20/20 Totals far Check: 6501 1.220.00- CYand'%tals; 612,369,24 .a***** god of 14„,,,,,..*****. 10 of 150 June 15, 2020 Regular Meeting Agenda Packet REGULAR ZOOM MEETING MINUTES TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 BOARD OF DIRECTORS May 18, 2020 at 6:30 P.M. Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in Regular Session Meeting on Monday, May 18, 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: Gregory Wilson President William C. Rose Vice President Steve Flynn Secretary/Treasurer Kelly Castonguay Director Mark Chapman Director STAFF PRESENT: Mike McMahon Laurie Slaght Steven Krolczyk Tony Corbett Acting General Manager District Secretary Finance Manager General Legal Counsel GUESTS PRESENT: Andrew Friedman Samco Capital Jack Taylor Fire Chief CALL TO ORDER AND ANNOUNCE A QUORUM President Wilson announced the date of May 18, 2020, called the meeting to order and announced a quorum present at 6:31 p.m. CITIZEN COMMENTS There were no citizen comments CONSENT AGENDA 1. Consider and take appropriate action to approve the Consent Agenda. a. April 2020 Check Register b. April 20, 2020 Regular Meeting Minutes Motion made by Director Chapman and seconded by Director Flynn to approve the consent agenda as presented. Motion carried unanimously 11 of 150 June 15, 2020 Regular Meeting Agenda Packet REGULAR SESSION 2. Consider and take appropriate action to approve purchase of replacement emergency rescue equipment from Hurst Jaws of Life, Inc. at a total cost of $31,679 for Trophy Club Fire Department. Motion made by Director Rose and seconded by Director Chapman to approve the purchase of Hurst Jaws of Life from MES (Municipal Emergency Services) for the replacement of emergency rescue equipment for the Trophy Club Fire Department for an amount not to exceed $31,679. Motion carried unanimously 3. Consider and take appropriate action relating to potential issuance of Trophy Club Municipal Utility District No. 1 Unlimited Tax Refunding Bonds, Series 2020 in a principal amount not to exceed $1,220,000 (the "Bonds"): a. Receive report and recommendations from Financial Advisor regarding potential sale and issuance of the Bonds; b. Adopt Order Authorizing the Issuance of the Trophy Club Municipal Utility District No. 1 Unlimited Tax Refunding Bonds, Series 2020; Prescribing the Terms and Provisions Thereof; Making Provision for the Payment of the Interest Thereon and Principal Thereof; Authorizing the Sale of the Bonds; Approving a Purchase Contract, a Paying Agent/Registrar Agreement and an Escrow Agreement; and Containing Other Provisions Relating to the Subject; c. Approve Payment of Attorney General Bond Review Fee; and d. Authorize the District Officers, General Manager, Legal Counsel and Financial Advisor to take such actions as may be necessary, appropriate or convenient to complete the issuance, sale and delivery of the Bonds, including execution of all agreements and documents related thereto. Motion made by Director Flynn and seconded by Director Chapman to approve the issuance of Trophy Club Municipal Utility District No. 1 Unlimited Tax Refunding Bonds, Series 2020 in a principal amount not to exceed $1,220,000; and a. Receive report and recommendations from Financial Advisor regarding potential sale and issuance of the Bonds; b. Adopt Order Authorizing the Issuance of the Trophy Club Municipal Utility District No. 1 Unlimited Tax Refunding Bonds, Series 2020; Prescribing the Terms and Provisions Thereof; Making Provision for the Payment of the Interest Thereon and Principal Thereof; Authorizing the Sale of the Bonds; Approving a Purchase Contract, a Paying Agent/Registrar Agreement and an Escrow Agreement; and Containing Other Provisions Relating to the Subject; c. Approve Payment of Attorney General Bond Review Fee; and d. Authorize the District Officers, General Manager, Legal Counsel and Financial Advisor to take such actions as may be necessary, appropriate or convenient to complete the issuance, sale and delivery of the Bonds, including execution of all agreements and documents related thereto. Motion carried unanimously 12 of 150 June 15, 2020 Regular Meeting Agenda Packet 4. Consider and take appropriate action to elect officers of the Board of Directors. Director Wilson called for nominations for Board President. Director Castonguay nominated Director Flynn for President. For: Wilson, Rose, Chapman, Flynn, Castonguay Oppose: none Director Flynn will serve as Board President. Director Wilson called for nominations for Board Vice President. Director Chapman volunteered to be Vice President of the Board. For: Wilson, Rose, Chapman, Flynn, Castonguay Oppose: none Director Chapman will serve as Vice President of the Board. Director Wilson called for nominations for Board Secretary/Treasurer. Director Flynn nominated Director Rose for Secretary/Treasurer of the Board. Director Rose stated he would prefer that Director Castonguay have the opportunity to serve in the position. Director Rose nominated Director Castonguay for Secretary/Treasurer of the Board. For: Wilson, Rose, Chapman, Flynn Oppose: none Abstain: Castonguay Director Castonguay will serve as Secretary/Treasurer of the Board. 5. Consider and take appropriate action to adopt Order No. 2020-0518B declaring a truck hitch and light poles to be to be surplus property of the District and authorizing staff to sell such surplus property. Motion made by Director Chapman and seconded by Director Castonguay to adopt Order No. 2020-0518B declaring a truck hitch and light poles to be to be surplus property of the District and authorizing staff to sell such surplus property. 13 of 150 June 15, 2020 Regular Meeting Agenda Packet Motion carried unanimously 6. Discussion and possible action regarding District Payment and Billing Policies. (Wilson) Director Wilson moved to Table this item until June. With no objection, the item is Tabled. 7. Consider and take appropriate action regarding the April 2020 Combined Financials and Variance Report. a. Combined Financials b. Combined Variance Motion by Director Flynn and seconded by Director Castonguay to approve the April 2020 Combined Financials and Variance Reports. Motion carried unanimously REPORTS & UPDATES 8. General Manager Monthly Reports and Update: a. Regulatory Update b. Capital Improvement Projects • Wastewater Treatment Plant Upgrade Project • High Service Pump c. System Repairs & Maintenance d. Water System Operations e. Wastewater System Operations f. Finance Update • Utility Billing Report • Disconnects and late fees report • Permits Collected • Cash Report Acting General Manager Mike McMahon provided the monthly reports to the Board and answered questions related thereto. The Board convened into Executive Session at 7:21 p.m. EXECUTIVE SESSION 9. Pursuant to Section 551.071 of the Texas Open Meetings Act, the Board may consult with its attorney in Executive Session on a matter in which the duty of the attorney to the Governmental Body under the Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflicts with the Open Meetings Act or to seek advice of counsel on legal matters involving pending or contemplated litigation 14 of 150 June 15, 2020 Regular Meeting Agenda Packet or settlement offers: a. Contractor breach, performance and payment issues related to District's contract with Webber- Cadagua Partners for construction of the Wastewater Treatment Plant Improvements; and b. Trophy Club Municipal Utility District No. 1 v. Acadia Services, LLC, In the District Court of Tarrant County, 141st Judicial District (Cause No. 141-299351-18). c. Potential Condemnation of Easements required for construction and operation of Water Transmission Line Improvements from District Pump Station to Elevated Water Tank located on T.W. King Road 10. 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. Sale or Exchange of District real property located at 100 Municipal Drive, 1501 Junction Way and other real property owned by the District. b. Purchase of Easements required for construction and operation of Water Transmission Line Improvements from District Pump Station to Elevated Water Tank located on T.W. King Road 11. Deliberations pursuant to Section 551.074(a)(1) of the Texas Open Meetings Act regarding the appointment, employment, evaluation, reassignment, duties, discipline, or dismissal of a public officer or employee: Hiring a General Manager. The Board reconvened into Regular Session at 8:15p.m. REGULAR SESSION President Wilson stated that no final decisions, actions, or votes were made in Executive Session. 12. Consider and take appropriate action on matters deliberated in Executive Session: 13. Consider and take appropriate action relating to approval of employment contract with new General Manager. Motion by Director Flynn and seconded by Director Castonguay to approve the employment agreement, date to be determined, between Trophy Club Municipal Utility District No. 1 and Alan Fourmentin for the position of General Manager and with a mutually agreeable effective date. Attorney Corbett clarified that by not setting the effective date of the employment agreement, the Board authorizes the General Manager Hiring Committee to negotiate the effective date with Mr. Fourmentin. The Board acknowledged that is understood. 15 of 150 June 15, 2020 Regular Meeting Agenda Packet Motion carried unanimously 14. Items for future agendas: Agenda Item 6. 15. Set future Meeting dates - Regular Board Meeting on June 15, 2020 at 6:30 p.m. ADJOURN Director Castonguay moved to adjourn. Director Wilson called the meeting adjourned at 8:18 p.m. Gregory Wilson, President Steve Flynn, Secretary/Treasurer Laurie Slaght, District Secretary 16 of 150 (SEAL) June 15, 2020 Regular Meeting Agenda Packet Request for Proposal Professional Audit Services May 2020 Score Summary Clifton Larson Rod L. Abbott, Did the submitted proposals provide the following: Allen LLP CPA PLLC RFP Complete Yes Yes Prior experience auditing water districts. Yes Yes Prior experience auditing similar governmental entities. Yes Yes Prior experience auditing similar nonprofit entities. Yes Yes Adequate size of the CPA Firm. Yes Yes Audit team qualifications. Yes Yes Overall supervision to be exercised. Yes Yes Prior experience of audit team. Yes Yes Presentation of work to be performed. Yes Yes Realistic time estimates of each audit step. Yes Yes Prior experience with single audits. Yes Yes Price Yes Yes Alan Fourmentin Score 96 93 Mike McMahon Score 82 78 Steven Krolczyk Score 92 85 Director Chapman Score Director Flynn Score 100 87 89 63 Average Score 91.8 81.2 Proposed Rates FY 2020 $25,000 $18,670 FY 2021 $25,375 $18,950 FY 2022 $25,756 $19,450 FY 2023 $26,142 $20,100 FY 2024 $26,534 $20,950 Total $128,807 $98,120 17 of 150 June 9, 2020 Board of Directors and Management Trophy Club Municipal Utility District No. 1 100 Municipal Drive Trophy Club, Texas 76262 Junt AS(di g l nyi_rting Agenda Packet 801 Cherry Street, Suite 1400 Fort Worth, TX 76102 817-877-50001 fax 817-877-5330 CLAconnect.com We are pleased to confirm our understanding of the terms and objectives of our engagement and the nature and limitations of the audit and nonaudit services CliftonLarsonAllen LLP ("CLA," "we," "us," and "our") will provide for Trophy Club Municipal Utility District No. 1 ("you," "your," or "the entity") for the year ended September 30, 2020, 2021, 2022, 2023, and 2024. Chris Knopik, CPA, CFE is responsible for the performance of the audit engagement. Audit services We will audit the financial statements of the governmental activities, each major fund, and the aggregate remaining fund information, which collectively comprise the basic financial statements of Trophy Club Municipal Utility District No. 1, as of and for the year ended September 30, 2020, 2021, 2022, 2023, and 2024, and the related notes to the financial statements. The Governmental Accounting Standards Board (GASB) provides for certain required supplementary information (RSI) to accompany the entity's basic financial statements. The following RSI will be subjected to certain limited procedures, but will not be audited: 1. Management's discussion and analysis. 2. Budgetary comparison schedules. 3. GASB -required supplementary pension and OPEB under modified reporting. We will also evaluate and report on the presentation of the supplementary information accompanying the financial statements in relation to the financial statements as a whole. The information accompanying the financial statements will not be subjected to the auditing procedures applied in our audit of the financial statements and our auditors' report will not provide an opinion or any assurance on that information. We will also evaluate and report on the presentation of the following supplementary information other than RSI accompanying the financial statements in relation to the financial statements as a whole: 1. Texas Commission On Environmental Quality Supplemental Information a. TSI -1 Services and Rates b. TSI -2 General Fund Expenditures and other Financing Uses c. TSI -3 Temporary Investments d. TSI -4 Taxes Levied and Receivable Aft&A member of Nexia International 18 of 150 June 15, 2020 Regular Meeting Agenda Packet June 9, 2020 Trophy Club Municipal Utility District No. 1 Page 2 e. TSI -5 Long -Term Debt Service Requirements — By Years f. TSI -6 Changes in Long -Term Bonded Debt g. TSI -7 Comparative Schedules of Revenues and Expenditures — Five Years h. TSI -8 Board Members, Key Personnel and Consultants Nonaudit services We will also provide the following nonaudit services: • Preparation of your financial statements and related notes. • Preparation of adjusting journal entries, if required. Audit objectives The objective of our audit is the expression of opinions about whether your basic financial statements are fairly presented, in all material respects, in conformity with accounting principles generally accepted in the United States of America (U.S. GAAP). Our audit will be conducted in accordance with auditing standards generally accepted in the United States of America (U.S. GAAS) and the standards for financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States, and will include tests of your accounting records and other procedures we consider necessary to enable us to express such opinions. We will apply certain limited procedures to the RSI in accordance with U.S. GAAS. However, we will not express an opinion or provide any assurance on the RSI because the limited procedures do not provide us with sufficient evidence to express an opinion or provide any assurance. We will also perform procedures to enable us to express an opinion on whether the supplementary information (as identified above) other than RSI accompanying the financial statements is fairly stated, in all material respects, in relation to the financial statements as a whole. We will issue a written report upon completion of our audit of your financial statements. We cannot provide assurance that unmodified opinions will be expressed. Circumstances may arise in which it is necessary for us to modify our opinions, add an emphasis -of -matter or other -matter paragraph(s), or withdraw from the engagement. If our opinions are other than unmodified, we will discuss the reasons with you in advance. If circumstances occur related to the condition of your records, the availability of sufficient, appropriate audit evidence, or the existence of a significant risk of material misstatement of the financial statements caused by error, fraudulent financial reporting, or misappropriation of assets, which in our professional judgment prevent us from completing the audit or forming opinions on the financial statements, we retain the right to take any course of action permitted by professional standards, including declining to express opinions or issue a report, or withdrawing from the engagement. We will also provide a report (which does not include an opinion) on internal control related to the financial statements and on compliance with the provisions of laws, regulations, contracts, and grant agreements, noncompliance with which could have a material effect on the financial statements, as required by Government Auditing Standards. The report on internal control over financial reporting and on compliance and other matters will include a paragraph that states (1) that the purpose of the report is solely to describe the scope of our testing of internal control and compliance and the result of that testing, and not to provide an opinion on the effectiveness of the entity's internal control or on compliance, and (2) that the report is an integral part of an audit performed in accordance with Government Auditing Standards in considering the entity's internal control and compliance. The paragraph will also state that the report is not suitable for any other purpose. If during our 19 of 150 June 15, 2020 Regular Meeting Agenda Packet June 9, 2020 Trophy Club Municipal Utility District No. 1 Page 3 audit we become aware that the entity is subject to an audit requirement that is not encompassed in the terms of this engagement, we will communicate to management and those charged with governance that an audit conducted in accordance with U.S. GAAS and the standards for financial audits contained in Government Auditing Standards may not satisfy the relevant legal, regulatory, or contractual requirements. Auditor responsibilities, procedures, and limitations We will conduct our audit in accordance with U.S. GAAS and the standards for financial audits contained in Government Auditing Standards. Those standards require that we plan and perform the audit to obtain reasonable assurance about whether the basic financial statements as a whole are free from material misstatement, whether due to fraud or error. An audit involves performing procedures to obtain sufficient appropriate audit evidence about the amounts and disclosures in the basic financial statements. The procedures selected depend on the auditors' judgment, including the assessment of the risks of material misstatement of the financial statements, whether due to fraud or error. An audit also includes evaluating the appropriateness of accounting policies used and the reasonableness of significant accounting estimates made by management, as well as evaluating the overall presentation of the basic financial statements. There is an unavoidable risk, because of the inherent limitations of an audit, together with the inherent limitations of internal control, that some material misstatements may not be detected, even though the audit is properly planned and performed in accordance with U.S. GAAS and Government Auditing Standards. Because we will not perform a detailed examination of all transactions, material misstatements, whether from (1) errors, (2) fraudulent financial reporting, (3) misappropriation of assets, or (4) violations of laws or governmental regulations that are attributable to the entity or to acts by management or employees acting on behalf of the entity, may not be detected. Because the determination of waste and abuse is subjective, Government Auditing Standards do not require auditors to perform specific procedures to detect waste or abuse in financial audits nor do they expect auditors to provide reasonable assurance of detecting waste or abuse. In addition, an audit is not designed to detect immaterial misstatements or violations of laws or governmental regulations that do not have a direct and material effect on the financial statements. However, we will inform the appropriate level of management and those charged with governance of any material errors, fraudulent financial reporting, or misappropriation of assets that come to our attention. We will also inform the appropriate level of management and those charged with governance of any violations of laws or governmental regulations that come to our attention, unless clearly inconsequential. In making our risk assessments, we consider internal control relevant to the entity's preparation and fair presentation of the basic financial statements in order to design audit procedures that are appropriate in the circumstances, but not for the purpose of expressing an opinion on the effectiveness of the entity's internal control. Tests of controls may be performed to test the effectiveness of certain controls that we consider relevant to preventing and detecting fraud or errors that are material to the financial statements and to preventing and detecting misstatements resulting from noncompliance with provisions of laws, regulations, contracts, and grant agreements that have a material effect on the financial statements. Our tests, if performed, will be less in scope than would be necessary to render an opinion on internal control and, accordingly, no opinion will be expressed in our report on internal control issued pursuant to Government Auditing Standards. An audit is not designed to provide assurance on internal control or to identify deficiencies, significant deficiencies, or material weaknesses in internal control. However, we will communicate to you in writing significant deficiencies or material weaknesses in internal control relevant to the audit of the basic financial 20 of 150 June 15, 2020 Regular Meeting Agenda Packet June 9, 2020 Trophy Club Municipal Utility District No. 1 Page 4 statements that we identify during the audit that are required to be communicated under AICPA professional standards and Government Auditing Standards. As part of obtaining reasonable assurance about whether the financial statements are free of material misstatement, we will perform tests of the entity's compliance with the provisions of laws, regulations, contracts, and grant agreements that have a material effect on the financial statements. However, the objective of our audit will not be to provide an opinion on overall compliance and we will not express such an opinion in our report on compliance issued pursuant to Government Auditing Standards. We will include in our report on internal control over financial reporting and on compliance relevant information about any identified or suspected instances of fraud and any identified or suspected noncompliance with provisions of laws, regulations, contracts, or grant agreements that may have occurred that are required to be communicated under Government Auditing Standards. Our responsibility as auditors is limited to the period covered by our audit and does not extend to any later periods for which we are not engaged as auditors. Management responsibilities Our audit will be conducted on the basis that you (management and, when appropriate, those charged with governance) acknowledge and understand that you have certain responsibilities that are fundamental to the conduct of an audit. You are responsible for the preparation and fair presentation of the financial statements and RSI in accordance with U.S. GAAP. Management's responsibilities include the selection and application of accounting principles; recording and reflecting all transactions in the financial statements; determining the reasonableness of significant accounting estimates included in the financial statements; adjusting the financial statements to correct material misstatements; and confirming to us in the management representation letter that the effects of any uncorrected misstatements aggregated by us during the current engagement and pertaining to the latest period presented are immaterial, both individually and in the aggregate, to the financial statements taken as a whole. You are responsible for the design, implementation, and maintenance of effective internal control, including evaluating and monitoring ongoing activities, to help ensure that appropriate goals and objectives are met relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. You are responsible for the design, implementation, and maintenance of internal controls to prevent and detect fraud; assessing the risk that the financial statements may be materially misstated as a result of fraud; and for informing us about all known or suspected fraud affecting the entity involving (1) management, (2) employees who have significant roles in internal control, and (3) others where the fraud could have a material effect on the financial statements. Your responsibilities include informing us of your knowledge of any allegations of fraud or suspected fraud affecting the entity received in communications from employees, former employees, grantors, regulators, or others. In addition, you are responsible for implementing systems designed to achieve compliance with applicable laws and regulations and the provisions of contracts and grant agreements; identifying and ensuring that the entity complies with applicable laws, regulations, contracts, and grant agreements; and informing us of all instances of identified or suspected noncompliance whose effects on the financial statements should be considered. You are responsible 21 of 150 June 15, 2020 Regular Meeting Agenda Packet June 9, 2020 Trophy Club Municipal Utility District No. 1 Page 5 for taking timely and appropriate steps to remedy any fraud and noncompliance with provisions of laws, regulations, contracts, and grant agreements that we may report. You are responsible for ensuring that management is reliable and for providing us with (1) access to all information of which you are aware that is relevant to the preparation and fair presentation of the financial statements, such as records, documentation, and other matters, and for the accuracy and completeness of that information, and for ensuring the information is reliable and properly reported; (2) additional information that we may request for the purpose of the audit; and (3) unrestricted access to persons within the entity from whom we determine it necessary to obtain audit evidence. You agree to inform us of events occurring or facts discovered subsequent to the date of the financial statements that may affect the financial statements. Management is responsible for providing us with a written confirmation concerning representations made by you and your staff to us in connection with the audit and the presentation of the basic financial statements and RSI. During our engagement, we will request information and explanations from you regarding, among other matters, the entity's activities, internal control, future plans, specific transactions, and accounting systems and procedures. The procedures we will perform during our engagement and the conclusions we reach as a basis for our report will be heavily influenced by the representations that we receive in the representation letter and otherwise from you. Accordingly, inaccurate, incomplete, or false representations could cause us to expend unnecessary effort or could cause a material fraud or error to go undetected by our procedures. In view of the foregoing, you agree that we shall not be responsible for any misstatements in the entity's financial statements that we may fail to detect as a result of misrepresentations made to us by you. Management is responsible for authorizing the predecessor auditor to allow us to review the predecessor auditor's workpapers and to respond fully to our inquiries, thereby providing us with information to assist us in planning and performing the engagement. You will be responsible for any fees billed by the predecessor auditor related to our review of their workpapers and our inquiries. Management is responsible for establishing and maintaining a process for tracking the status of audit findings and recommendations. Management is also responsible for identifying for us previous financial audits, attestation engagements, performance audits, or other studies related to the objectives discussed in the "Audit objectives" section of this letter. This responsibility includes relaying to us corrective actions taken to address significant findings and recommendations resulting from those audits, attestation engagements, performance audits, or other engagements or studies. You are also responsible for providing management's views on our current findings, conclusions, and recommendations, as well as your planned corrective actions for the report, and for the timing and format for providing that information. Responsibilities and limitations related to nonaudit services For all nonaudit services we may provide to you, management agrees to assume all management responsibilities; oversee the services by designating an individual, preferably within senior management, who possesses suitable skill, knowledge, and/or experience to understand and oversee the services; evaluate the adequacy and results of the services; and accept responsibility for the results of the services. Management is also responsible for ensuring that your data and records are complete and that you have received sufficient information to oversee the services. 22 of 150 June 15, 2020 Regular Meeting Agenda Packet June 9, 2020 Trophy Club Municipal Utility District No. 1 Page 6 The responsibilities and limitations related to the nonaudit services performed as part of this engagement are as follows: • We will prepare a draft of your financial statements and related notes. Since the preparation and fair presentation of the financial statements is your responsibility, you will be required to acknowledge in the representation letter our assistance with preparation of the financial statements and that you have reviewed and approved the financial statements and related notes prior to their issuance and have accepted responsibility for those financial statements. You have a responsibility to be in a position in fact and appearance to make an informed judgment on those financial statements. • We will propose adjusting journal entries as needed. You will be required to review and approve those entries and to understand the nature of the changes and their impact on the financial statements. These nonaudit services do not constitute an audit under Government Auditing Standards and such services will not be conducted in accordance with Government Auditing Standards. Use of financial statements The financial statements and our report thereon are for management's use. If you intend to reproduce and publish the financial statements and our report thereon, they must be reproduced in their entirety. Inclusion of the audited financial statements in a document, such as an annual report or an offering document, should be done only with our prior approval of the document. You are responsible to provide us the opportunity to review such documents before issuance. If the parties (i.e., you and CLA) agree that CLA will not be involved with your official statements related to municipal securities filings or other offering documents, we will require that any official statements or other offering documents issued by you with which we are not involved clearly indicate that CLA is not involved with the contents of such documents. Such disclosure should read as follows: CliftonLarsonAllen LLP, our independent auditor, has not been engaged to perform and has not performed, since the date of its report included herein, any procedures on the financial statements addressed in that report. CliftonLarsonAllen LLP also has not performed any procedures relating to this offering document. Should you decide to include or incorporate by reference these financial statements and our auditors' report(s) thereon in a future private placement or other offering of equity or debt securities, you agree that we are under no obligation to re -issue our report or provide consent for the use of our report in such a registration or offering document. We will determine, at our sole discretion, whether we will re -issue our report or provide consent for the use of our report only after we have performed the procedures we consider necessary in the circumstances. If we decide to re -issue our report or consent to the use of our report, we will be required to perform certain procedures including, but not limited to, (a) reading other information incorporated by reference in the registration statement or other offering document and (b) subsequent event procedures. These procedures will be considered an engagement separate and distinct from our audit engagement, and we will bill you separately. If we decide to re -issue our report or consent to the use of our report, you agree that we will be included on each distribution of draft offering materials and we will receive a complete set of final documents. If we decide not to re -issue our report or decide to withhold our consent to the use of our report, you may be required to 23 of 150 June 15, 2020 Regular Meeting Agenda Packet June 9, 2020 Trophy Club Municipal Utility District No. 1 Page 7 engage another firm to audit periods covered by our audit reports, and that firm will likely bill you for its services. While the successor auditor may request access to our workpapers for those periods, we are under no obligation to permit such access. If the parties (i.e., you and CLA) agree that CLA will not be involved with your official statements related to municipal securities filings or other offering documents, we will require that any official statements or other offering documents issued by you with which we are not involved clearly indicate that CLA is not involved with the contents of such documents. Such disclosure should read as follows: CliftonLarsonAllen LLP, our independent auditor, has not been engaged to perform and has not performed, since the date of its report included herein, any procedures on the financial statements addressed in that report. CliftonLarsonAllen LLP also has not performed any procedures relating to this offering document. With regard to the electronic dissemination of audited financial statements, including financial statements published electronically on your website or submitted on a regulator website, you understand that electronic sites are a means to distribute information and, therefore, we are not required to read the information contained in those sites or to consider the consistency of other information in the electronic site with the original document. We may issue preliminary draft financial statements to you for your review. Any preliminary draft financial statements should not be relied on or distributed. Engagement administration and other matters We understand that your employees will prepare all confirmations, account analyses, and audit schedules we request and will locate any documents or invoices selected by us for testing. A list of information we expect to need for our audit and the dates required will be provided in a separate communication. We will provide copies of our reports to the entity; however, management is responsible for distribution of the reports and the financial statements. Unless restricted by law or regulation, or containing confidential or sensitive information, copies of our reports are to be made available for public inspection. We are available to perform additional procedures with regard to fraud detection and prevention, at your request, as a separate engagement, subject to completion of our normal engagement acceptance procedures. The terms and fees of such an engagement would be documented in a separate engagement letter. The audit documentation for this engagement is the sole and exclusive property of CLA and constitutes confidential and proprietary information. However, subject to applicable laws and regulations, audit documentation and appropriate individuals will be made available upon request and in a timely manner to a federal agency providing direct or indirect funding, or the U.S. Government Accountability Office for purposes of a quality review of the audit, to resolve audit findings, or to carry out oversight responsibilities. We will notify you of any such request. If requested, access to such audit documentation will be provided under the supervision of CLA personnel. Furthermore, upon request, we may provide copies of selected audit documentation to the aforementioned parties. These parties may intend, or decide, to distribute the copies or information contained therein to others, including other governmental agencies. 24 of 150 June 15, 2020 Regular Meeting Agenda Packet June 9, 2020 Trophy Club Municipal Utility District No. 1 Page 8 The audit documentation for this engagement will be retained for a minimum of seven years after the report release. If we are aware that a federal awarding agency, pass-through entity, or auditee is contesting an audit finding, we will contact the party(ies) contesting the audit finding for guidance prior to destroying the audit documentation. CLA will not disclose any confidential, proprietary, or privileged information of the entity to any persons without the authorization of entity management or unless required by law. This confidentiality provision does not prohibit us from disclosing your information to one or more of our affiliated companies in order to provide services that you have requested from us or from any such affiliated company. Any such affiliated company shall be subject to the same restrictions on the use and disclosure of your information as apply to us. Professional standards require us to be independent with respect to you in the performance of these services. Any discussion that you have with our personnel regarding potential employment with you could impair our independence with respect to this engagement. Therefore, we request that you inform us prior to any such discussions so that we can implement appropriate safeguards to maintain our independence and objectivity. Further, any employment offers to any staff members working on this engagement without our prior knowledge may require substantial additional procedures to ensure our independence. You will be responsible for any additional costs incurred to perform these procedures. Our relationship with you is limited to that described in this letter. As such, you understand and agree that we are acting solely as independent accountants. We are not acting in any way as a fiduciary or assuming any fiduciary responsibilities for you. We are not responsible for the preparation of any report to any governmental agency, or any other form, return, or report or for providing advice or any other service not specifically recited in this letter. Our engagement and responsibility end on delivery of our signed report. Any additional services that might be requested will be a separate, new engagement. The terms and conditions of that new engagement will be governed by a new, specific engagement letter for that service. Government Auditing Standards require that we make our most recent external peer review report publicly available. The report is posted on our website at www.CLAconnect.com/Aboutus/. Mediation Any disagreement, controversy, or claim ("Dispute") that may arise out of any aspect of our services or relationship with you, including this engagement, shall be submitted to non-binding mediation by written notice ("Mediation Notice") to the other party. In mediation, we will work with you to resolve any differences voluntarily with the aid of an impartial mediator. The mediation will be conducted as specified by the mediator and agreed upon by the parties. The parties agree to discuss their differences in good faith and to attempt, with the assistance of the mediator, to reach an amicable resolution of the Dispute. Each party will bear its own costs in the mediation. The fees and expenses of the mediator will be shared equally by the parties. 25 of 150 Audit Fee 5% Technology and Total Fees Client Support Fee June 15, 2020 Regular Meeting Agenda Packet June 9, 2020 Trophy Club Municipal Utility District No. 1 Page 9 Any Dispute will be governed by the laws of the state of Minnesota, without giving effect to choice of law principles. Time limitation The nature of our services makes it difficult, with the passage of time, to gather and present evidence that fully and fairly establishes the facts underlying any Dispute that may arise between the parties. The parties agree that, notwithstanding any statute or law of limitations that might otherwise apply to a Dispute, including one arising out of this agreement or the services performed under this agreement, for breach of contract or fiduciary duty, tort, fraud, misrepresentation or any other cause of action or remedy, any action or legal proceeding by you against us must be commenced within twenty-four (24) months ("Limitation Period") after the date when we deliver our final audit report under this agreement to you, regardless of whether we do other services for you relating to the audit report, or you shall be forever barred from commencing a lawsuit or obtaining any legal or equitable relief or recovery. The Limitation Period applies and begins to run even if you have not suffered any damage or loss, or have not become aware of the existence or possible existence of a Dispute. Fees Our professional fees for the engagement will be billed as shown below. This estimate is based on anticipated cooperation from your personnel and their assistance with preparing confirmations and requested schedules. If the requested items are not available on the dates required or are not accurate, the fees and expenses will likely be higher. If unexpected circumstances require significant additional time, we will advise you before undertaking work that would require a substantial increase in the fee and expense estimate. Our invoices, including applicable state and local taxes, will be rendered each month as work progresses and are payable on presentation. In accordance with our firm policies, work may be suspended if your account becomes 60 days or more overdue and will not be resumed until your account is paid in full. If we elect to terminate our services for nonpayment, our engagement will be deemed to have been completed even if we have not issued our reports. You will be obligated to compensate us for all time expended and related fees and to reimburse us for all out-of- pocket expenditures through the date of termination. Audit Period FY2020 $ 23,809 $1,191 $25,000 FY2021 $ 24,167 $1,208 $25,375 FY2022 $ 24,530 $1,226 $25,756 FY2023 (option) $ 24,897 $1,245 $26,142 FY2024 (option) $25,270 $1,264 $26,534 Unanticipated services We do not anticipate encountering the need to perform additional services beyond those described in this letter. Below are listings of services considered to be outside the scope of our engagement. If any such service 26 of 150 June 15, 2020 Regular Meeting Agenda Packet June 9, 2020 Trophy Club Municipal Utility District No. 1 Page 10 needs to be completed before the audit can proceed in an efficient manner, we will determine whether we can provide the service and maintain our independence. If appropriate, we will notify you and provide a fair and reasonable price for providing the service. We will bill you for the service at periodic dates after the additional service has been performed. Bookkeeping services Bookkeeping services are not audit services. Bookkeeping services include the following activities: • Preparation of a trial balance • Account reconciliations • Bank statement reconciliations • Capital asset accounting (e.g., calculating depreciation, identify capital assets for additions and deletions) • Calculating accruals • Analyzing transactions for proper recording • Converting cash basis accounting records to accrual basis • Preparation of financial statements and the related notes to the financial statements • Processing immaterial adjustments through the financial statements • Adjusting the financial statements for new activities and new disclosures Additional work resulting from unanticipated changes in your organization or accounting records If your organization undergoes significant changes in key personnel, accounting systems, and/or internal control, we are required to update our audit documentation and audit plan. The following are examples of situations that will require additional audit work: • Revising documentation of your internal control for changes resulting from your implementation of new information systems • Deterioration in the quality of the entity's accounting records during the current -year engagement in comparison to the prior -year engagement • Significant new accounting issues • Significant changes in your volume of business • Mergers, acquisitions, or other business combinations 27 of 150 June 15, 2020 Regular Meeting Agenda Packet June 9, 2020 Trophy Club Municipal Utility District No. 1 Page 11 • New or unusual transactions • Changes in audit scope or requirements resulting from changes in your activities • Erroneous or incomplete accounting records • Evidence of material weaknesses or significant deficiencies in internal control • Substantial increases in the number or significance of problem loans • Regulatory examination matters • Implementation or adoption of new or existing accounting, reporting, regulatory, or tax requirements • New financial statement disclosures Changes in engagement timing and assistance by your personnel The fee estimate is based on anticipated cooperation from your personnel and their assistance with timely preparation of confirmations and requested schedules. If the requested items are not available on the dates required or are not accurate, we will advise management. Additional time and costs may be necessary because of such unanticipated delays. Examples of situations that may cause our estimated fee to increase include: • Significant delays in responding to our requests for information such as reconciling variances or providing requested supporting documentation (e.g., invoices, contracts, and other documents) • Rescheduling our fieldwork • Schedule disruption caused by litigation, financial challenges (going concern), loan covenants (waivers), etc. • Identifying a significant number of proposed audit adjustments • Schedules prepared by your personnel that do not reconcile to the general ledger • Numerous revisions to information and schedules provided by your personnel • Restating financial statements for accounting errors in the prior year • Lack of availability of entity personnel during audit fieldwork Changes in accounting and audit standards Standard setters and regulators continue to evaluate and modify standards. Such changes may result in new or revised financial reporting and disclosure requirements or expand the nature, timing, and scope of the activities 28 of 150 June 15, 2020 Regular Meeting Agenda Packet June 9, 2020 Trophy Club Municipal Utility District No. 1 Page 12 we are required to perform. To the extent that the amount of time required to provide the services described in the letter increases due to such changes, our fee may need to be adjusted. We will discuss such circumstances with you prior to performing the additional work. Other fees You also agree to compensate us for any time and expenses, including time and expenses of legal counsel, we may incur in responding to discovery requests or participating as a witness or otherwise in any legal, regulatory, or other proceedings that we are asked to respond to on your behalf. Finance charges and collection expenses You agree that if any statement is not paid within 30 days from its billing date, the unpaid balance shall accrue interest at the monthly rate of one and one-quarter percent (1.25%), which is an annual percentage rate of 15%. In the event that any collection action is required to collect unpaid balances due us, reasonable attorney fees and expenses shall be recoverable. Consent Consent to use financial information Annually, we assemble a variety of benchmarking analyses using client data obtained through our audit and other engagements. Some of this benchmarking information is published and released publicly. However, the information that we obtain is confidential, as required by the AICPA Code of Professional Conduct. Your acceptance of this engagement letter will serve as your consent to use of Trophy Club Municipal Utility District No. l's information in these cost comparison, performance indicator, and/or benchmarking reports. Subcontractors CLA may, at times, use subcontractors to perform services under this agreement, and they may have access to your information and records. Any such subcontractors will be subject to the same restrictions on the use of such information and records as apply to CLA under this agreement. Predecessor auditor communications You agree to provide us permission to communicate with the predecessor auditor and to authorize the predecessor auditor to respond fully to our inquiries regarding any matters that will assist us in finalizing our engagement acceptance. You further acknowledge that our final acceptance of the engagement is subject to the completion of those inquiries and evaluation of the responses. Agreement We appreciate the opportunity to be of service to you and believe this letter accurately summarizes the significant terms of our engagement. This letter constitutes the entire agreement regarding these services and supersedes all prior agreements (whether oral or written), understandings, negotiations, and discussions between you and CLA. If you have any questions, please let us know. Please sign, date, and return a copy of this letter to us to indicate your acknowledgment and understanding of, and agreement with, the arrangements for our audit of your financial statements including the terms of our engagement and the parties' respective responsibilities. This agreement is also subject to successful engagement acceptance procedures which include communication with the predecessor auditor. 29 of 150 June 15, 2020 Regular Meeting Agenda Packet June 9, 2020 Trophy Club Municipal Utility District No. 1 Page 13 Sincerely, CliftonLarsonAllen LLP --.4, 1---A- Christopher Knopik, CPA, CFE Principal 612-397-3266 Christopher.Knopik@CLAconnect.com Enclosure Response: This letter correctly sets forth the understanding of Trophy Club Municipal Utility District No. 1. Authorized governance signature: Title: Date: Authorized management signature: Title: Date: 30 of 150 June 15, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 RESOLUTION NO. 2020-0615A A RESOLUTION REGARDING SIGNATORY AUTHORITY FOR TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 ACCOUNTS AT PROSPERTY BANK USA WHEREAS, Trophy Club Municipal Utility District No. 1 (the "District") is a conservation and reclamation district, a body corporate and politic and governmental agency of the State of Texas, created under Article XVI, Sec. 59 of the Texas Constitution by order of the Texas Water Commission, now the Texas Commission on Environmental Quality ("TCEQ"), and the District operates under Chapters 49 and 54 of the Texas Water Code, as amended; WHEREAS, banking rules and effective management of the District's finances require that the Board of Directors (the "Board") of Trophy Club Municipal Utility District No. 1 (the "District") establish designated persons who shall have signature authority over the District's bank accounts at Prosperity Bank USA (the "Bank"); and WHEREAS, it is necessary for the Board to provide that a sufficient number of District officials be designated with signature authority; and NOW, THEREFORE, BE IT RESOLVED BY THE BOARD OF DIRECTORS OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 THAT: 1. The following members of the Board of Directors and the General Manager of Trophy Club Municipal Utility District No. 1 shall have signatory authority over the District's accounts at Prosperity Bank USA, each of them mutually having authority to act in the place of any other as may be convenient for effectively transacting the business of the District: a. Gregory Wilson Director b. William C. Rose Director c. Kelly Castonguay Director d. Stephen J. Flynn Director e. Mark Chapman Director f. Alan Fourmentin General Manager 2. At least two (2) authorized signors must sign all disbursements of the District. 3. The Board of Directors directs the staff of the District to take all actions necessary and apply such information and documentation as may be requested by the Bank to affect the provisions of this Resolution. 4. These changes supersede all previously existing signatory authorities on record with Prosperity Bank USA. 31 of 150 June 15, 2020 Regular Meeting Agenda Packet RESOLVED, PASSED, AND APPROVED on this the 15st day of June 2020. ATTEST: Kelly Castonguay Secretary, Board of Directors Steve Flynn President, Board of Directors 32 of 150 (SEAL) ai 111 111 III TjLJooL AN 1WFOR PUBLIC FUNDS June 15, 2020 Regular Meeting Agenda Packet Resolution Amending Authorized Representatives Please use this form to amend or designate Authorized Representatives. This document supersedes all prior Authorized Representative forms. * Required Fields 1. Resolution WHEREAS, Trophy Club Municipal Utility District No. 1 Participant Name* 1 7 7 3 8 4 Location Number* ("Participant") is a local government of the State of Texas and is empowered to delegate to a public funds investment pool the authority to invest funds and to act as custodian of investments purchased with local investment funds; and WHEREAS, it is in the best interest of the Participant to invest local funds in investments that provide for the preservation and safety of principal, liquidity, and yield consistent with the Public Funds Investment Act; and WHEREAS, the Texas Local Government Investment Pool ("TexPool/ Texpool Prime"), a public funds investment pool, were created on behalf of entities whose investment objective in order of priority are preservation and safety of principal, liquidity, and yield consistent with the Public Funds Investment Act. NOW THEREFORE, be it resolved as follows: A. That the individuals, whose signatures appear in this Resolution, are Authorized Representatives of the Participant and are each hereby authorized to transmit funds for investment in TexPool / TexPool Prime and are each further authorized to withdraw funds from time to time, to issue letters of instruction, and to take all other actions deemed necessary or appropriate for the investment of local funds. B. That an Authorized Representative of the Participant may be deleted by a written instrument signed by two remaining Authorized Representatives provided that the deleted Authorized Representative (1) is assigned job duties that no longer require access to the Participant's TexPool / TexPool Prime account or (2) is no longer employed by the Participant; and C. That the Participant may by Amending Resolution signed by the Participant add an Authorized Representative provided the additional Authorized Representative is an officer, employee, or agent of the Participant; List the Authorized Representative(s) of the Participant. Any new individuals will be issued personal identification numbers to transact business with TexPool Participant Services. 1. Alan Fourmentin Name 1 General Manager Title 1682-831-4610/817-491-9312/afourmentin@tcmud.org Phone/Fax/Email Signature 2 Laurie Slaght Name District Secretary Title 1682-831-4685/817-491-9312/Islaght@tcmud.org Phone/Fax/Email Signature FORM CONTINUES ON NEXT PAGE 1 OF 2 33 of 150 June 15, 2020 Regular Meeting Agenda Packet 1. Resolution (continued) s Gregory Wilson Name Director Title 1 682-831-4600/817-491-9312/gwilson@tcmud.org Phone/Fax/Email Signature 4 William C. Rose Name Director Title 1 682-831-4600/817-491-9312/brose@tcmud.org Phone/Fax/Email Signature List the name of the Authorized Representative listed above that will have primary responsibility for performing transactions and receiving confirmations and monthly statements under the Participation Agreement. 1 Alan Fourmentin Name In addition and at the option of the Participant, one additional Authorized Representative can be designated to perform only inquiry of selected information. This limited representative cannot perform transactions. If the Participant desires to designate a representative with inquiry rights only, complete the following information. 1 Steven Krolczyk Name 1 Finance Manager Title 1682-831-4692/817-491-9312/skrolczyk@tcmud.org Phone/Fax/Email D. That this Resolution and its authorization shall continue in full force and effect until amended or revoked by the Participant, and until TexPool Participant Services receives a copy of any such amendment or revocation. This Resolution is hereby introduced and adopted by the Participant at its regular/special meeting held on the 15th day June , 20 20 . Note: Document is to be signed by your Board President, Mayor or County Judge and attested by your Board Secretary, City Secretary or County Clerk. Trophy Club MUD No. 1 Name of Participant* SIGNED Signature* Stephen J. Flynn Printed Name* 1President Title* ATTEST Signature* Kelly Castonguay Printed Name* 1Secretary/Treasurer Title* 2. Mailing Instructions The completed Resolution Amending Authorized Representatives can be faxed to TexPool Participant Services at 1-866-839-3291, and mailed to: TexPool Participant Services 1001 Texas Avenue, Suite 1400 Houston, TX 77002 ORIGINAL SIGNATURE AND DOCUMENT REQUIRED TEX-REP TexPool Participant Services 1001 Texas Avenue, Suite 1400 • Houston, TX 77002 Phone: 1-866-TEXPOOL (839-7665) • Fax: 1-866-839-3291 • www.texpool.com 34 of 150 2 OF 2 Managed d band Federated® o G45340-17 (12/15) ai 111 111 III TExPO0L AN INVESTMENT SERVICE FOR PUBLIC FUNDS June 15, 2020 Regular Meeting Agenda Packet Resolution Amending Authorized Representatives Please use this form to amend or designate Authorized Representatives. This document supersedes all prior Authorized Representative forms. * Required Fields 1. Resolution WHEREAS, Trophy Club Municipal Utility District No. 1 Participant Name* 7 7 3 8 4 Location Number* ("Participant") is a local government of the State of Texas and is empowered to delegate to a public funds investment pool the authority to invest funds and to act as custodian of investments purchased with local investment funds; and WHEREAS, it is in the best interest of the Participant to invest local funds in investments that provide for the preservation and safety of principal, liquidity, and yield consistent with the Public Funds Investment Act; and WHEREAS, the Texas Local Government Investment Pool ("TexPool/ Texpool Prime"), a public funds investment pool, were created on behalf of entities whose investment objective in order of priority are preservation and safety of principal, liquidity, and yield consistent with the Public Funds Investment Act. NOW THEREFORE, be it resolved as follows: A. That the individuals, whose signatures appear in this Resolution, are Authorized Representatives of the Participant and are each hereby authorized to transmit funds for investment in TexPool / TexPool Prime and are each further authorized to withdraw funds from time to time, to issue letters of instruction, and to take all other actions deemed necessary or appropriate for the investment of local funds. B. That an Authorized Representative of the Participant may be deleted by a written instrument signed by two remaining Authorized Representatives provided that the deleted Authorized Representative (1) is assigned job duties that no longer require access to the Participant's TexPool / TexPool Prime account or (2) is no longer employed by the Participant; and C. That the Participant may by Amending Resolution signed by the Participant add an Authorized Representative provided the additional Authorized Representative is an officer, employee, or agent of the Participant; List the Authorized Representative(s) of the Participant. Any new individuals will be issued personal identification numbers to transact business with TexPool Participant Services. Steve Flynn 1. Name President Title 1682-831-4600/817-491-9312/sflynn@tcmud.org Phone/Fax/Email Signature 2.1 Kelly Castonguay Name 1 Secretary/Treasurer Title 1682-831-4600/817-491-9312/kcastonguay@tcmud.org Phone/Fax/Email Signature FORM CONTINUES ON NEXT PAGE 1 OF 2 35 of 150 June 15, 2020 Regular Meeting Agenda Packet 1. Resolution (continued) 3 Mark Chapman Name Vice -President 4. Title 682-831-4600/817-491-9312/mchapman@tcmud.org Phone/Fax/Email Signature Name Title Phone/Fax/Email Signature List the name of the Authorized Representative listed above that will have primary responsibility for performing transactions and receiving confirmations and monthly statements under the Participation Agreement. l Alan Fourmentin Name In addition and at the option of the Participant, one additional Authorized Representative can be designated to perform only inquiry of selected information. This limited representative cannot perform transactions. If the Participant desires to designate a representative with inquiry rights only, complete the following information. 1 Steven Krolczyk Name 1 Finance Manager Title 1682-831-4692/817-491-9312/skrolczyk@tcmud.org Phone/Fax/Email D. That this Resolution and its authorization shall continue in full force and effect until amended or revoked by the Participant, and until TexPool Participant Services receives a copy of any such amendment or revocation. This Resolution is hereby introduced and adopted by the Participant at its regular/special meeting held on the 15th day June , 20 20 . Note: Document is to be signed by your Board President, Mayor or County Judge and attested by your Board Secretary, City Secretary or County Clerk. Trophy Club MUD No. 1 Name of Participant* SIGNED Signature* Stephen J. Flynn Printed Name* President Title* ATTEST Signature* Kelly Castonguay Printed Name* Secretary/Treasurer Title* 2. Mailing Instructions The completed Resolution Amending Authorized Representatives can be faxed to TexPool Participant Services at 1-866-839-3291, and mailed to: TexPool Participant Services 1001 Texas Avenue, Suite 1400 Houston, TX 77002 ORIGINAL SIGNATURE AND DOCUMENT REQUIRED TEX-REP TexPool Participant Services 1001 Texas Avenue, Suite 1400 • Houston, TX 77002 Phone: 1-866-TEXPOOL (839-7665) • Fax: 1-866-839-3291 • www.texpool.com 36 of 150 2 OF 2 Managed d band Federated® o G45340-17 (12/15) June 15, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - FIRE DEPARTMENT BALANCE SHEET MAY 2020 ASSETS CASH IN BANK INVESTMENTS PREPAID EXPENSES ADVALOREM PROPERTY TAXES RECEIVABLE EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE ix TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 FIRE DEPT. 895,282 6,564 37,757 TOTAL ASSETS 939,603 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES 37,763 TOTAL LIABILITIES 37,763 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE 603,769 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES 298,071 TOTAL FUND BALANCE 901,840 TOTAL LIABILITIES AND FUND BALANCE 939,603 37 of 150 June 15, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 5/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,214,230.00- 1,214,230.00 - Property Taxes/Fire-Delinquent Property Taxes/Fire P&I 5,990.97- 1,212,561.75- 104.81 2,762.65- 289.88- 4,300.92- 99.863 1,668.25- 2,762.65 4,300.92 Page Subtotal: 1,214,230.00- 1,214,230.00- = 6,176.04- 1,219,625.32- 100.444 5,395.32 Program number: 1,214,230.00- 1,214,230.00- 6,176.04- 1,219,625.32- 100.444 5,395.32 Department number: Fire Revenues 1,214,230.00- 1,214,230.00- 6,176.04- 1,219,625.32- 100.444 5,395.32 I Revenues Subtotal 1,214,230.00- 1,214,230.00- 6,176.04- 1,219,625.32- 100.444 5,395.32 38 of 150 June 15, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 Page 2 10:08 06/10/20 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60030-045-000 Rent And/Or Usage 218,004.00 218,004.00 122-60055-045-000 Insurance 21,000.00 21,000.00 122-60337-045-000 Transfer to Town/Fire Budget 718,657.00 718,657.00 1,640.88 59,888.08 11111111?total: 957,661.00 957,661.00 61,528.96 122-69005-045-000 Capital Outlays 48,000.00 48,000.00 122-69009-045-000 Short Term Debt -Interest 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 81,420.00 122-69305-045-000 Capital Leases 127,149.00 127,149.00 Subtota1: 256,569.00 256,569.00 Program number: 1,214,230.00 1,214,230.00 61,528.96 Department number: Fire 1,214,230.00 1,214,230.00 61,528.96 Expenditures Subtotal 1,214,230.00 1,214,230.00 61,528.96 Fund number: 122 Trophy Club MUD Fire Dept. 55,352.92 39 of 150 218,004.00 100.000 13,127.04 62.510 479,104.64 66.667 710,235.68 2,750.00 5.729 11,958.24 81,420.00 100.000 115,190.36 90.595 211,318.60 , 82.363 921,554.28 , 921,554.11111 921,554.2x, 298,071.04- , 75.896 75.896 75.896 7,872.96 239,552.36 247,425.32 45,250.00 11,958.24- 11,958.64 292,675.72 292,675.72 292,675.72 298,071.04 glpdatb2 skrolczyk 10:08 06/10/20 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Account: 122-40010-020- 1272 05/01/2020 Property Taxes 1273 05/04/2020 Property Taxes 1274 05/05/2020 Property Taxes 1275 05/06/2020 property taxes 1277 05/07/2020 property taxes 1278 05/08/2020 property taxes 1279 05/11/2020 Property Taxes 1280 05/12/2020 Property Taxes 1281 05/14/2020 property taxes 1282 05/15/2020 property taxes 1283 05/18/2020 property taxes 1293 05/19/2020 property taxes 1284 05/20/2020 property taxes 1285 05/21/2020 property taxes 1286 05/22/2020 property taxes 1287 05/26/2020 property taxes 1288 05/27/2020 property taxes 1289 05/28/2020 property taxes 1290 05/29/2020 property taxes Account: 122-40010-000-000 June 15, 2020 Regular Meeting Agenda Packet Page 1 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Fire Revenues Program: Period Ending: 5/2020 JE Detail Beginning Transaction Transaction Vendor Name Description/Comment Balance Detail Detail (SUBTOTAL) Check Source Number Property Taxes/MUD Fire (1,206,570.78) (73.86) (1,206,644.64) (1.77) (1,206,646.41) (8.07) (1,206,654.48) (333.59) (1,206,988.07) (1,081.52) (1,208,069.59) (44.00) (1,208,113.59) (53.23) (1,208,166.82) 227.10 (1,207,939.72) (152.61) (1,208,092.33) (733.84) (1,208,826.17) (264.16) (1,209,090.33) (182.32) (1,209,272.65) (442.61) (1,209,715.26) (596.60) (1,210,311.86) (420.83) (1,210,732.69) (203.39) (1,210,936.08) (669.13) (1,211,605.21) (416.87) (1,212,022.08) (539.67) (1,212,561.75) Property Taxes/MUD Fire Totals: .di.97) (1,212,561.75) (1,214,230.00) Budgeted (1,668.25) Remaining 100 % Used GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL Property Taxes/Fire-Delinquent 1275 05/06/2020 property taxes 1280 05/12/2020 Property Taxes 1284 05/20/2020 property taxes 1285 05/21/2020 property taxes 1287 05/26/2020 property taxes 1288 05/27/2020 property taxes Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Total .00 Budgeted 2,762.65 Remaining Account: 122-40020-000-0 1272 05/01/2020 Property Taxes 1273 05/04/2020 Property Taxes 1274 05/05/2020 Property Taxes 1275 05/06/2020 property taxes 1277 05/07/2020 property taxes (2,867.46) 0 % Used (14.13) (2,881.59) 194.89 (2,686.70) (20.88) (2,707.58) (32.85) (2,740.43) (9.79) (2,750.22) (12.43) (2,762.65) GL GL GL GL GL GL Property Taxes/Fire P&2 (4,011.04) 40 of 150 (1.13) (4,012.17) (.20) (4,012.37) (1.07) (4,013.44) (3.97) (4,017.41) (119.68) (4,137.09) GL GL GL GL GL glpdatb2 ekrolczyk 10:08 06/10/20 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description 1279 05/11/2020 Property Taxes 1280 05/12/2020 Property Taxes 1282 05/15/2020 property taxes 1283 05/18/2020 property taxes 1293 05/19/2020 property taxes 1284 05/20/2020 property taxes 1285 05/21/2020 property taxes 1286 05/22/2020 property taxes 1287 05/26/2020 property taxes 1288 05/27/2020 property taxes 1289 05/28/2020 property taxes 1290 05/29/2020 property taxes Account: 122-40020-000-000 Department Totals: June 15, 2020 Regular Meeting Agenda Packet Page 2 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Fire Revenues Program: Period Ending: 5/2020 JE Detail Beginning Transaction Transaction Vendor Name Description/Comment Balance Detail Detail (SUBTOTAL) Property Taxes/Fire P52 To .00 Budgeted 4,300.92 Remaining (6,176.04) Monthly Total (4,011.04) 0 Used (15.02) (4,152.11) (.94) (4,153.05) (65.77) (4,218.82) (5.06) (4,223.88) (.94) (4,224.82) (31.01) (4,255.83) .27 (4,255.56) (24.92) (4,280.48) (2.47) (4,282.95) (3.68) (4,286.63) (.30) (4,286.93) (13.99) (4,300.92) (4,300.92) ** (1,219,625.32) ** (1,214,230.00) Budgeted 5,395.32 Remaining 100 % Used 41 of 150 Check Source Number GL GL GL GL GL GL GL GL GL GL GL GL glpdatb2 akrolczyk 10:08 06/10/20 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 45 Fire Period Ending: 5/2020 Program: June 15, 2020 Regular Meeting Agenda Packet Page 3 JE Detail Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Description/Comment Check Source Number 42 of 150 Account: 122-60030-045-000 Rent And/Or Usage 218,004.00 .00 218,004.00 Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 218,004.00 ** 218,004.00 Budgeted .00 Remaining 100 % Used Account: 122-60055-045-000 Insurance 73 05/01/2020 Insurance/Wrk Comp Expense May 11,486.16 1,640.88 13,127.04 GL Account: 122-60055-045-000 Insurance Totals: ' 1,640.88 13,127.04 ** 21,000.00 Budgeted 7,872.96 Remaining 63 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 1178 05/11/2020 May A/P May Fire admin 419,216.56 59,888.08 479,104.64 TOWN OF TROPHY CLUB 6435 AP Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 59,888.08 479,104.64 ** 718,657.00 Budgeted 239,552.36 Remaining 67 % Used Account: 122-69005-045-000 Capital Outlays 2,750.00 .00 2,750.00 Account: 122-69005-045-000 Capital Outlays Totals: .00 2,750.00 ** 48,000.00 Budgeted 45,250.00 Remaining 6 % Used Account: 122-69009-045-000 Short Term Debt -Interest 11,958.24 .00 11,958.24 Account: 122-69009-045-000 Short Term Debt -Interest Totals: .00 11,958.24 ** .00 Budgeted (11,958.24) Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement A11111_ 81,420.00 .00 81,420.00 Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 81,420.00 ** 81,420.00 Budgeted .00 Remaining 100 % Used Account: 122-69305-045-000 Capital Leases . 42 of 150 June 15, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Capital Leases Totals: 127,149.00 Budgeted 115,190.36 .00 115,190.36 11,958.64 Remaining 91 % Used Department 45 Totals: 921,554.28 •• 61,528.96 Monthly Total 1,214,230.00 Budgeted 292,675.72 Remaining 76 % Used Fund 122 Totals: (298,071.04) 55,352.92 Monthly Total .00 Budgeted 43 of 150 298,071.04 Remaining 0 % Used TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET MAY 2020 June 15, 2020 Regular Meeting Agenda Packet 135 137 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 3,088,104 3,088,104 CASH IN BANK -SAVINGS -CASH RESERVE 1,604,892 1,604,892 INVESTMENTS-TEXPOOL 3,577,659 919,266 4,496,925 PREPAID EXPENSES 39,434 39,434 ADVALOREM PROPERTY TAXES RECEIVABLE 4,097 4,097 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,009,838 1,009,838 TOTAL ASSETS 9,324,623 919,266 10,243,889 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 4,097 4,097 ACCOUNTS AND OTHER PAYABLES 499,383 499,383 CUSTOMER DEPOSITS 315,760 315,760 TOTAL LIABILITIES 819,239 819,239 FUND BALANCE NON -SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 2,072,098 2,072,098 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 270,000 270,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT 30,000 30,000 ASSIGNED FUND BALANCE/SEWER REPLACEMENT 127,805 127,805 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 391,461 391,461 ASSIGNED FUND BALANCE/WWTP MBR REPLACEMENT 100,000 100,000 UNASSIGNED FUND BALANCE 6,325,800 6,325,800 COMMITTED FUND BALANCE NET REVENUES / EXPENDITURES 103,999 103,999 TOTAL FUND BALANCE 8,505,384 919,266 9,424,650 TOTAL LIABILITIES AND FUND BALANCE 9,324,623 919,266 10,243,889 44 of 150 June 15, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 Page 3 10:08 06/10/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/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 Property Taxes/Delinquent Property Taxes/P & I PID Surcharges 134,871.00- 134,871.00- 300.00- 300.00- 300.00- 300.00- 164,253.00- 164,253.00- 665.06- 11.90 32.19- 134,609.11- 285.08- 468.83- 99.806 95.027 156.277 261.89- 14.92- 168.83 164,253.00- 164 135-47000-000-000 Water 6,486,623.00- 6,486,623.00- 135-47005-000-000 Sewer 3,503,885.00- 3,503,885.00- 135-47025-000-000 Penalties 112,608.00- 112,608.00- 135-47030-000-000 Service Charges 15,150.00- 15,150.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- 459,563.85- 273,756.56- 57.86 25.00- 8,843.20- 2,951,753.71- 2,053,404.14- 51,074.93- 9,825.00- 2,250.00- 1,350.00- 25,908.80- 45.505 58.604 45.356 64.851 300.000 54.000 51.818 3,534,869.29- 1,450,480.86- 61,533.07- 5,325.00- 1,500.00 ,534,869.29-1,450,480.86-61,533.07- 5,325.00- 1,500.00 1,150.00- 24,091.20- 10,171,516.00- 10,171,516.00- A11111111E0.75- 5,095,566 135-49011-000-000 135-49016-000-000 135-49018-000-000 135-49026-000-000 135-49075-000-000 135-49900-000-000 ENSubtots. Program number: Department number: Revenues Revenues Interest Income Cell Tower Revenue Building Rent Income Proceeds from Sale of Assets Oversize Meter Reimbursement Miscellaneous Income 120,000.00- 120,000.00- 14,146.00- 14,146.00- 7,000.00- 7,000.00- 13,000.00- 13,000.00- 12,691.00- 12,691.00- 7,000.00- 7,000.00- 3,764.35- 1,178.81- 583.33- 169.84- 67,382.29- 8,251.67- 4,666.64- 8,925.00- 7,730.28- 8,971.93- 45.505 7,382.29-8,251.67-4,666.64-8,925.00-7,730.28- 8,971.93- 56.152 58.332 66.666 68.654 60.912 128.170 52,617.71- 5,894.33- 2,333.36- 4,075.00- 4,960.72- 1,971.93 2,617.71 -5,894.33-2,333.36-4,075.00- 4,960.72- 1,971.93 173,837.00- Subtotal 0- 10,645,077.00- 0- 10,645,077.00- 10- 10,645,077.00- 45 of 150 748 08,219.59- 08,219.59- 08,219.59- June 15, 2020 Regular Meeting Agenda Packet glbase_tbam skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 350,267.00 350,267.00 46,318.05 135-50010-010-000 Overtime 17,000.00 17,000.00 1,562.49 135-50016-010-000 Longevity 3,920.00 3,920.00 135-50017-010-000 Certification 5,400.00 5,400.00 425.00 135-50020-010-000 Retirement 34,863.00 34,863.00 4,473.10 135-50026-010-000 Medical Insurance 84,326.00 84,326.00 5,225.04 135-50027-010-000 Dental Insurance 4,725.00 4,725.00 316.63 135-50028-010-000 Vision Insurance 767.00 767.00 48.18 135-50029-010-000 Life Insurance & Other 3,132.00 3,132.00 328.89 135-50030-010-000 Social Security Taxes 23,348.00 23,348.00 2,974.38 135-50035-010-000 Medicare Taxes 5,461.00 5,461.00 695.62 135-50040-010-000 Unemployment Taxes 1,080.00 1,080.00 135-50045-010-000 Workman's Compensation 11,850.00 11,850.00 771.49 135-50060-010-000 Pre-emp Physicals/Testing 400.00 400.00 135-50070-010-000 Employee Relations 300.00 300.00 FSubtotal: ' 546,839.00 546,839.00 63,138.87 135-55005-010-000 Engineering 20,000.00 20,000.00 135-55080-010-000 Maintenance & Repairs 100,000.00 100,000.00 5,089.98 135-55085-010-000 Generator Maint. and Repair 3,000.00 3,000.00 135-55090-010-000 Vehicle Maintenance 5,000.00 5,000.00 601.87 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 135-55120-010-000 Cleaning Services 1,000.00 1,000.00 87.50 135-55135-010-000 Lab Analysis 7,500.00 7,500.00 239,064.24 68.252 13,427.75 78.987 5,082.50 129.656 3,350.00 62.037 25,233.24 72.378 40,053.74 47.499 2,431.37 51.458 380.65 49.628 2,534.95 80.937 16,001.33 68.534 3,742.22 68.526 880.68 81.544 6,347.42 53.565 358,530.09 29,521.69 29.522 2,444.43 48.889 1,828.19 52.234 612.50 61.250 2,451.64 32.689 111,202.76 3,572.25 1,162.50- 2,050.00 9,629.76 44,272.26 2,293.63 386.35 597.05 7,346.67 1,718.78 199.32 5,502.58 400.00 300.00 188,308.91 20,000.00 70,478.31 3,000.00 2,555.57 1,671.81 387.50 5,048.36 103,141.55 Page 4 140,000.00 140,000.00 26.327 135-60010-010-000 Communications/Mobiles 5,000.00 5,000.00 135-60020-010-000 Electricity 125,677.00 125,677.00 135-60066-010-000 Publications/Books/Subscripts 1,000.00 1,000.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,845.00 2,845.00 135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 135-60135-010-000 TCEQ Fees & Permits 63,000.00 63,000.00 135-60150-010-000 Wholesale Water 2,714,710.00 2,714,710.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 135-60332-010-000 Interfund Transfer Out -Rev I&S 527,381.00 527,381.00 135-60333-010-000 Interfund Transfer Out -Reserve 55,193.00 55,193.00 135-60334-010-000 Interfund Transfer Out 180,000.00 180,000.00 46 of 150 385.40 9,128.56 111.00 130,922.95 1,500.00 25,047.72 4,600.00 3,653.34 73.067 80,762.35 64.262 850.00 85.000 105.00 21.000 1,547.00 20.832 20,205.04 32.071 883,304.49 32.538 756.00 25.200 3,000.00 20.339 383,549.92 72.727 36,800.00 66.675 1,346.66 44,914.65 150.00 395.00 5,879.00 400.00 2,845.00 1,500.00 42,794.96 1,831,405.51 200.00 2,244.00 11,750.00 143,831.08 18,393.00 180,000.00 glbase_tbam skrolczyk 10:08 06/10/20 Fund: 135 MUD 1 General Fund Account 1 1 135-60360-010-000 1 Description Furniture/Equipment < $5000 June 15, 2020 Regular Meeting Agenda Packet Trophy Club MUD No.1 Page 5 Budget Summary with Amendment Department: 10 Water Program: Period Ending: 5/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 2,500.00 2,500.00 135-65005-010-000 135-65010-010-000 135-65030-010-000 135-65035-010-000 135-65040-010-000 135-65050-010-000 135-65053-010-000 Fuel & Lube Uniforms Chemicals Small Tools Safety Equipment Meter Expense Meter Change Out Program 15,000.00 5,190.00 20,000.00 1,200.00 1,000.00 70,000.00 87,000.00 15,000.00 5,190.00 20,000.00 1,200.00 1,000.00 70,000.00 87,000.00 442.13 1,789.93 561.72 22.469 1,938.28 1,415,094.86 = 2,289,98.7 6,175.98 41.173 2,917.33 56.211 13,652.18 68.261 59,593.08 85.133 36,900.00 42.414 8,824.02 2,272.67 6,347.82 1,200.00 1,000.00 10,406.92 50,100.00 135-69005-010-000 135-69008-010-000 135-69009-010-000 135-69195-010-000 135-69281-010-000 Subtot 135-70040-010-000 Subtot- Program number: Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Water Tank Inspection Contract Bond Related Expenses 684,875.00 30,512.00 3,231.00 75,000.00 120,000.00 684,875.00 30,512.00 3,231.00 75,000.00 120,000.00 .00 5,504,929.00 5,504,929.00 47 of 150 59,366.70 335,891.44 49.044 30,512.00 100.000 1,840.00 56.948 75,000.00 100.000 102,077.11 85.064 59,366.70 7111,320.55 1,220.00 1,220.00 1,220.00 -171941.1. 303,432.61 2,476,262.52 348,983.56 1,391.00 17,922.89 368,297. 1,220.00- 1,220.00- ,028,666.48 glbase_tbam skrolczyk 10:08 06/10/20 Fund: 135 MUD 1 General Fund Account Description 1 1 135-55135-010-001 Lab Analysis for PID June 15, 2020 Regular Meeting Agenda Packet Trophy Club MUD No.1 Budget Summary with Amendment Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 5/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 2,000.00 2,000.00 1,001.64 50.082 998.36 Page Subtotal: 2,000.00 2,000.00 Mr - 1,001.64 50.082 998.36 Program number: 1 Lab Analysis for PID 2,000.00 2,000.00 1,001.64 50.082 998.36 Department number: Water 5,506,929.00 5,506,929.00 303,432.61 2,477,264.16 44.984 3,029,664.84 48 of 150 June 15, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 Page 7 10:08 06/10/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 441,799.00 441,799.00 49,678.38 264,922.83 59.965 135-50010-020-000 Overtime 33,000.00 33,000.00 3,057.29 15,052.67 45.614 135-50016-020-000 Longevity 8,035.00 8,035.00 6,872.50 85.532 135-50017-020-000 Certification 9,000.00 9,000.00 700.00 5,075.00 56.389 135-50020-020-000 Retirement 45,531.00 45,531.00 4,948.15 28,560.50 62.728 135-50026-020-000 Medical Insurance 104,858.00 104,858.00 6,926.71 56,193.26 53.590 135-50027-020-000 Dental Insurance 5,817.00 5,817.00 392.75 3,271.97 56.248 135-50028-020-000 Vision Insurance 948.00 948.00 62.80 522.71 55.138 135-50029-020-000 Life Insurance & Other 4,500.00 4,500.00 384.52 2,953.70 65.638 135-50030-020-000 Social Security Taxes 30,494.00 30,494.00 3,225.26 17,033.26 55.858 135-50035-020-000 Medicare Taxes 7,132.00 7,132.00 754.28 3,983.55 55.855 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 1,008.00 80.000 135-50045-020-000 Workman's Compensation 15,373.00 15,373.00 1,110.20 9,057.10 58.916 135-50060-020-000 Pre-emp Physicals/Testing 400.00 400.00 38.00 9.500 135-50070-020-000 Employee Relations 300.00 300.00 46.08 46.08 15.360 FSubtotal: 71,286.42 414,591.13 135-55005-020-000 Engqinee ing 30,000.00 30,000.00 135-55070-020-000 Independent Labor 15,000.00 15,000.00 3,000.00 20.000 135-55080-020-000 Maintenance & Repairs 88,000.00 88,000.00 5,867.12 48,003.48 54.549 135-55081-020-000 Mainten & Repairs Collections 10,000.00 10,000.00 18,113.87 181.139 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 824.94 20.624 135-55091-020-000 Veh Maintenance Collections 8,000.00 8,000.00 8.92 2,020.80 25.260 135-55105-020-000 Maintenance-Backhoe/SkidLoader 3,000.00 3,000.00 200.00 1,032.22 34.407 135-55120-020-000 Cleaning Services 1,500.00 1,500.00 87.50 612.50 40.833 135-55125-020-000 Dumpster Services 100,000.00 100,000.00 10,256.66 61,872.84 61.873 135-55135-020-000 Lab Analysis 40,000.00 40,000.00 2,440.24 23,816.34 59.541 135-60010-020-000 Communications/Mobiles 5,000.00 5,000.00 407.91 3,904.09 78.082 135-60020-020-000 Electricity 160,067.00 160,067.00 11,132.02 84,380.01 52.715 135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 135-60070-020-000 Dues & Memberships 300.00 300.00 216.00 72.000 135-60080-020-000 Schools & Training 4,990.00 4,990.00 420.00- 2,542.85 50.959 135-60090-020-000 Safety Program 1,000.00 1,000.00 109.14 10.914 135-60100-020-000 Travel & per diem 1,545.00 1,545.00 410.72 26.584 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 15,000.00 15,000.00 10,088.02 67.253 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 135-60280-020-000 Property Maintenance 5,000.00 5,000.00 584.94 11.699 49 of 150 176,876.17 17,947.33 1,162.50 3,925.00 16,970.50 48,664.74 2,545.03 425.29 1,546.30 13,460.74 3,148.45 252.00 6,315.90 362.00 253.92 293,855.87 30,000.00 12,000.00 39,996.52 8,113.87- 10,000.00 3,175.06 5,979.20 1,967.78 887.50 38,127.16 16,183.66 1,095.91 75,686.99 200.00 84.00 2,447.15 890.86 1,134.28 5,000.00 2,500.00 4,911.98 450.00 4,415.06 June 15, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/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-60333-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 -Reserve Interfund Transfer Out Furniture/Equipment < $5000 14,000.00 114,563.00 673,867.00 125,187.00 180,000.00 2,000.00 14,000.00 114,563.00 673,867.00 125,187.00 180,000.00 2,000.00 1,480.00 2,960.00 10,414.81 83,318.48 54,421.63 490,085.00 5,750.00 46,000.00 190.00 Subtotal: 1,310,669.00 83,186.37 724,789.25 r 135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 368.08 5,106.21 40.850 7,393.79 135-65010-020-000 Uniforms 5,495.00 5,495.00 3,507.93 63.839 1,987.07 135-65030-020-000 Chemicals 20,000.00 20,000.00 2,788.92 19,928.34 99.642 71.66 135-65031-020-000 Chemicals Collections 17,500.00 17,500.00 4,994.00 28.537 12,506.00 135-65035-020-000 Small Tools 1,200.00 1,200.00 1,200.00 135-65040-020-000 Safety Equipment 1,200.00 1,200.00 1,166.53 97.211 33.47 135-65045-020-000 Lab Supplies 20,000.00 20,000.00 101.88 16,534.06 82.670 3,465.94 21.143 11,040.00 72.727 31,244.52 72.727 183,782.00 36.745 79,187.00 180,000.00 9.500 1,810.00 55.299 585,879.75 Page 8 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 Subtota.- Program number: Department number: Wastewater 530,500.00 79,133.00 11,277.00 130,000.00 530,500.00 79,133.00 11,277.00 130,000.00 750,910.00 3,157,421.00 3,157,421.00 50 of 150 111,949.00 111,949.00 288,541.11 288,541.11 294,012.00 59,604.74 6,122.03 130,000.00 489,738.77 1,839,653.21 1,839,653.E 55.422 75.322 54.288 100.000 �19 236,488.00 19,528.26 5,154.97 4 1,317,767 4 1,317,767 glbase_tbam skrolczyk 10:08 06/10/20 Fund: 135 MUD 1 General Fund Account 1 1 135-50045-026-000 1 Description Workman's Compensation Trophy Club MUD No.1 Budget Summary with Amendment Department: 26 Board of Directors Period Ending: 5/2020 Adopted Amended Total Budget Budget Encumb. Current Month 30.00 30.00 1.99 June 15, 2020 Regular Meeting Agenda Packet Program: YTD Total 15.92 of Budget 53.067 Remaining Budget 14.08 Page 3 3 135-60066-026-000 135-60070-026-000 135-60075-026-000 135-60080-026-000 135-60100-026-000 135-60245-026-000 EMrSubtota1: Program number: Department number: 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 13,200. 0 13,200.00 123.99 675.00 413.81 90.000 31.832 150.00 75.00 886.19 4,000.00 5,000.00 2,000.00 12,111.19 — 13,230.00 — 13,230.00 125.98 12,125.27 Board of Directors 13,230.00 13,230.00 51 of 150 125.98 12,125.27 June 15, 2020 Regular Meeting Agenda Packet glbase_tbam skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 628,298.00 628,298.00 135-50010-030-000 Overtime 2,000.00 2,000.00 135-50016-030-000 Longevity 2,208.00 2,208.00 135-50020-030-000 Retirement 58,554.00 58,554.00 135-50026-030-000 Medical Insurance 124,394.00 124,394.00 135-50027-030-000 Dental Insurance 6,464.00 6,464.00 135-50028-030-000 Vision Insurance 1,035.00 1,035.00 135-50029-030-000 Life Insurance & Other 4,500.00 4,500.00 135-50030-030-000 Social Security Taxes 39,215.00 39,215.00 135-50035-030-000 Medicare Taxes 9,171.00 9,171.00 135-50040-030-000 Unemployment Taxes 1,440.00 1,440.00 135-50045-030-000 Workman's Compensation 1,775.00 1,775.00 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 135-50070-030-000 Employee Relations 8,000.00 8,000.00 47,423.61 256,791.62 40.871 371,506.38 31.77 1.589 1,968.23 2,207.50 99.977 .50 4,391.41 25,482.92 43.520 33,071.08 6,345.77 48,195.28 38.744 76,198.72 349.75 2,667.95 41.274 3,796.05 51.68 404.71 39.102 630.29 343.91 2,658.84 59.085 1,841.16 2,796.86 15,027.94 38.322 24,187.06 654.10 3,514.62 38.323 5,656.38 864.00 60.000 576.00 104.82 838.56 47.243 936.44 500.00 3,078.10 38.476 4,921.90 Page 10 525,790.19 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 134,681.00 134,681.00 135,000.00 135,000.00 15,000.00 15,000.00 10,000.00 10,000.00 10,000.00 10,000.00 65,600.00 65,600.00 9,000.00 9,000.00 135-60005-030-000 Telephone 23,680.00 23,680.00 135-60010-030-000 Communications/Mobiles 4,000.00 4,000.00 135-60020-030-000 Electricity/Gas 6,879.00 6,879.00 135-60025-030-000 Water 1,500.00 1,500.00 135-60035-030-000 Postage 30,000.00 30,000.00 135-60040-030-000 Service Charges & Fees 67,000.00 67,000.00 135-60050-030-000 Bad Debt Expense 1,500.00 1,500.00 135-60055-030-000 Insurance 84,000.00 84,000.00 135-60066-030-000 Publications/Books/Subscripts 1,000.00 1,000.00 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 135-60075-030-000 Meetings 400.00 400.00 135-60079-030-000 Public Education 6,000.00 6,000.00 135-60080-030-000 Schools & Training 6,850.00 6,850.00 135-60100-030-000 Travel & per diem 3,545.00 3,545.00 135-60110-030-000 Physicals/Testing 200.00 200.00 135-60115-030-000 Elections 135-60125-030-000 Advertising 2,500.00 2,500.00 52 of 150 52,776.08- 13,098.66 285.00 1,896.92 54,600.00 2,021.79 99.26 458.22 228.42- 4,934.27 80,570.16 59.823 88,810.54 65.786 1,560.00 10.400 531.00 5.310 7,658.64 76.586 57,100.00 87.043 4,179.68 46.441 12,195.34 51.501 1,815.12 45.378 3,907.56 56.804 1,250.60 83.373 11,725.51 39.085 46,836.29 69.905 6,998.39 52,425.26 62.411 125.00 12.500 4,285.55 71.426 115.09 28.773 3,971.51 66.192 1,452.21 21.200 77.97 1,098.61 30.990 138.04 1,772.20 70.888 54,110.84 46,189.46 13,440.00 9,469.00 2,341.36 8,500.00 4,820.32 138-rowye 11,484.66 2,184.88 2,971.44 249.40 18,274.49 20,163.71 1,500.00 31,574.74 875.00 1,714.45 284.91 2,028.49 5,397.79 2,446.39 200.00 138.04- 727.80 June 15, 2020 Regular Meeting Agenda Packet glbase_tbam skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/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-60360-030-000 Security Miscellaneous Expenses General Manager Contingency Furniture/Equipment < $5000 1,288.00 1,288.00 500.00 500.00 17,000.00 17,000.00 2,500.00 2,500.00 135-65010-030-000 Uniforms 2,050.00 2,050.00 135-65055-030-000 Hardware 26,485.00 26,485.00 135-65085-030-000 Office Supplies 6,000.00 6,000.00 135-65090-030-000 Printer Supplies & Maintenance 3,500.00 3,500.00 135-65095-030-000 Maintenance Supplies 4,000.00 4,000.00 135-65105-030-000 Printing 2,500.00 2,500.00 135-69005-030-000 Capital Outlays 135-69170-030-000 Copier Lease Installments Program number: Department number: Administration 195,000.00 4,000.00 195,000.00 4,000.00 ,000.00 ,712.00 ,712.00 53 of 150 361.48 680.97 504.14 1,438.09 178.50 168.00 13.043 3,916.21 2,935.99 2,848.53 9,700.73 28,447.84 1,912.60 53.796 14.787 48.933 71.213 14.589 47.815 1111111157 1111111112 1,120.00 500.00 17,000.00 2,500.00 2,050.00 22,568.79 3,064.01 3,500.00 1,151.47 2,500.00 166,552.16 2,087.40 59 785,516.89 111111112 991,195.11 Page 11 June 15, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 5/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1 1 135-55045-039-000 Le al 135,000.00 135,000.00 1 135-55055-039-000 Auditing 33,800.00 33,800.00 1 135-55060-039-000 Appraisal 11,761.00 11,761.00 1 135-55065-039-000 Tax Admin Fees 4,000.00 4,000.00 4,842.50 90,427.89 27,713.27 7,422.04 3,756.00 66.984 81.992 63.107 93.900 44,572.11 6,086.73 4,338.96 244.00 Page 12 Subtotal: 184,561.00 184,561.00 4,842.50 129,319.20 70.069 55,241.80 Program number: 184,561.00 184,561.00 4,842.50 129,319.20 70.069 55,241.80 Department number: Non Departmental 184,561.00 184,561.00 4,842.50 129,319.20 70.069 55,241.80 Expenditures Subtotal 10,638,853.00 10,638,853.00 693,671.79 5,232,858.19 49.186 5,405,994.81 Fund number: 135 MUD 1 General Fund 6,224.00- 6,224.00- 54,840.64- 103,999.22- 1,670.939 97,775.22 54 of 150 glbase_tbam skrolczyk 10:08 06/10/20 Fund: 137 MUD 1 Consolidated GASS Account Description 137-49145-000-000 137-49146-000-000 H Subtot Program number: Intergov Transfer -General Fund Intergov Transfer -Fire Dept Department number: Revenues Subtotal Fund number: 137 MUD 1 Consolidated GASP Department: June 15, 2020 Regular Meeting Agenda Packet Trophy Club MUD No.1 Page 13 Budget Summary with Amendment Program: Period Ending: 5/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 55 of 150 205,000.00- 81,420.00- 286,420.00- 286,420.00- 286,420.00- 286,420.00- 205,000.00 81,420.00 286, 286,420.00 286,420.00 286,420.00 286,420.00 glpdatb2 skrolczyk 10:08 06/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 5/2020 JE Detail Description/Comment June 15, 2020 Regular Meeting Agenda Packet Page 5 Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Check Source Number Account: 135-40000-000-000 L Property Taxes -11111 1272 05/01/2020 Property Taxes 1273 05/04/2020 Property Taxes 1274 05/05/2020 Property Taxes 1275 05/06/2020 property taxes 1277 05/07/2020 property taxes 1278 05/08/2020 property taxes 1279 05/11/2020 Property Taxes 1280 05/12/2020 Property Taxes 1281 05/14/2020 property taxes 1282 05/15/2020 property taxes 1283 05/18/2020 property taxes 1293 05/19/2020 property taxes 1284 05/20/2020 property taxes 1285 05/21/2020 property taxes 1286 05/22/2020 property taxes 1287 05/26/2020 property taxes 1288 05/27/2020 property taxes 1289 05/28/2020 property taxes 1290 05/29/2020 property taxes (133,944.05) (8.20) (133,952.25) (.20) (133,952.45) (.90) (133,953.35) (37.03) (133,990.38) (120.06) (134,110.44) (4.88) (134,115.32) (5.91) (134,121.23) 25.21 (134,096.02) (16.94) (134,112.96) (81.46) (134,194.42) (29.32) (134,223.74) (20.24) (134,243.98) (49.13) (134,293.11) (66.23) (134,359.34) (46.72) (134,406.06) (22.58) (134,428.64) (74.28) (134,502.92) (46.28) (134,549.20) (59.91) (134,609.11) Account: 135-40000-000-000 Property Taxes Totals: (665.06) (134,609.11) (134,871.00) Budgeted (261.69) Remaining 100 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1275 05/06/2020 property taxes 1280 05/12/2020 Property Taxes 1284 05/20/2020 property taxes 1285 05/21/2020 property taxes 1287 05/26/2020 property taxes 1288 05/27/2020 property taxes (296.98) (1.61) 22.19 (2.40) (3.74) (1.12) (1.42) (298.59) (276.40) (278.80) (282.54) (283.66) (285.08) GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (285.08) (300.00) Budgeted (14.92) Remaining 95 5 Used Account: 135-40015-000-000 Property Taxes/P & I 1272 05/01/2020 Property Taxes 1273 05/04/2020 Property Taxes 1274 05/05/2020 Property Taxes 1275 05/06/2020 property taxes 1277 05/07/2020 property taxes (436.64) 56 of 150 (.12) (436.76) (.02) (436.78) (.11) (436.89) (.45) (437.34) (13.29) (450.63) GL GL GL GL GL glpdatb2 skrolczyk 10:08 06/10/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 1279 05/11/2020 Property Taxes 1280 05/12/2020 Property Taxes 1282 05/15/2020 property taxes 1283 05/18/2020 property taxes 1293 05/19/2020 property taxes 1284 05/20/2020 property taxes 1285 05/21/2020 property taxes 1286 05/22/2020 property taxes 1287 05/26/2020 property taxes 1288 05/27/2020 property taxes 1289 05/28/2020 property taxes 1290 05/29/2020 property taxes Account: 135-40015-000-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 5/2020 JE Detail Beginning Balance Description/Comment Property Taxes/P & I (300.00) Budgeted 168.83 Remaining (436.64) 156 % Used Program: Transaction Detail June 15, 2020 Regular Meeting Agenda Packet Page 6 Transaction Vendor Name Detail (SUBTOTAL) (1.67) (452.30) (.10) (452.40) (7.31) (459.71) (.57) (460.28) (.10) (460.38) (3.46) (463.84) .03 (463.81) (2.76) (466.57) (.27) (466.84) (.41) (467.25) (.03) (467.28) (1.55) (468.83) (468.83) Check Source Number GL GL GL GL GL GL GL GL GL GL GL GL Account: 135-40025-000-000 PID Surcharges Account: 135-40025-000-000 PID Surcharges (164,253.00) Budgeted (164,253.00) Remaining Account: 135-47000-000-0:- 1134 05/01/2020 UB 05/01/2020 Acct Adjustment UB20200501-20200501 User: 1243 05/31/2020 UB 05/31/2020 Billing UB20200531-20200531 User: (2,492,189.86) 0 % Used .00 .00 71.31 (2,492,118.55) (459,635.16) (2,951,753.71) GB GB Account: (6,486,623.00) Budgeted 135-47005-000-000 1139 05/04/2020 UB 05/04/2020 WA Adjustment 1141 05/04/2020 UB 05/04/2020 WA Adjustment 1246 05/05/2020 Swr adj 1247 05/06/2020 swr adj 1195 05/19/2020 UB 05/19/2020 WA Adjustments 1196 05/19/2020 UB 05/19/2020 WA Adjustments 1200 05/20/2020 UB 05/20/2020 WA Adjustment 1233 05/28/2020 UB 05/28/2020 WA Adjustments 1243 05/31/2020 UB 05/31/2020 Billing (3,534,869.29) UB20200504-20200504 User: UB20200504-20200504 User: UB20200505-20200505 User: UB20200506-20200506 User: UB20200519-20200519 User: UB20200519-20200519 User: UB20200520-20200520 User: UB20200528-20200528 User: UB20200531-20200531 User: Remaining 46 (1,779,647.58) Used 57 of 150 28.01 (1,779,619.57) 95.08 (1,779,524.49) 118.91 (1,779,405.58) 96.31 (1,779,309.27) 842.15 (1,778,467.12) 87.80 (1,778,379.32) 433.17 (1,777,946.15) 1,027.15 (1,776,919.00) (276,485.14) (2,053,404.14) UB GB GB GB GB GB G B GB G B glpdatb2 skrolczyk 10:08 06/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Account: 135-47005-00 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 5/2020 JE Detail Description/Comment Sewer (3,503,885.00) Budgeted June 15, 2020 Regular Meeting Agenda Packet Page 7 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) (1,450,480.86) Remaining Account: 135-47025-000-000 Penalties 1245 05/01/2020 penalty removal UB20200501-20200501 User: 1232 05/28/2020 UB 05/28/2020 Penalty Removal UB20200528-20200528 User: Account: 135-47025-000-000 ,,Penalties (112,608.00) Budgeted (61,533.07) 59 Ueed (51,132.79) 43.45 (51,089.34) UB 14.41 (51,074.93) UB Remaining 45 % Used AccountillEvice Cha 1231 05/21/2020 UB 05/21/2020 NSF Check Account: 135-47035-000-000 UB20200521-20200521 User: Service Charges (15,150.00) Budgeted Account: 135-47035-000-000 Account: 135-47045-000-000 Account: 135-47045-000-000 (9,800.00) (25.00) (9,825.00) UB (5,325.00) Remaining 65 % Used Plumbing Inspections (2,250.00) .00 (2,250.00) Plumbing Inspections Tota (750.00) Budgeted 1,500.00 Remaining 300 % Used Sewer Inspections (1,350.00) .00 (1,350.00) Sewer Inspections Totals: .00 (2,500.00) Budgeted (1,150.00) Remaining 54 % Used Account: 135-47070-000-000 TCCC Effluent Charges 1243 05/31/2020 UB 05/31/2020 Billing UB20200531-20200531 User: (17,065.60) (8,843.20) (25,908.80) GB Account: 135-47070-000-000 TCCC Effluent Charges (50,000.00) Budgeted (8,843.20) (25,908.80) ** (24,091.20) Remaining 52 % Used Account: 135-49011-00 ome 1269 05/31/2020 Bank Interest- May (63,617.94) (1,347.32) (64,965.26) GL 58 of 150 June 15, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 8 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1269 05/31/2020 Bank Interest- May (63,617.94) 1269 05/31/2020 Bank Interest- May Account: 135-49011-000-0001111111 Account: 135-49016-000-000 1263 05/29/2020 Cell Tower Rev AT&T (1,154.60) (66,119.86) GL (1,262.43) (67,382.29) GL Totals: (120,000.00) Budgeted (52,617.71) Remaining 56 % Used Cell Tower Revenue (7,072.86) (1,178.81) (8,251.67) GL Cell Tower Revenue Totals: (14,146.00) Budgeted (5,894.33) Remaining 58 % Ueed Building Rent Income 1265 05/31/2020 Town Billed Invoices 1738-1741 AR 20200531-20200531 User: (4,083.31) Account: 135-49018-000-00 Building Rent Income (7,000.00) Budgeted Account: 135-49026-000-000 (583.33) (4,666.64) (2,333.36) Remaining 67 % Used 111111111 Proceeds from Sale of Assets Account: 135-49026-000-000 Proceeds from Sale of Asse (13,000.00) Budgeted (4,075.00) Remaining (8,925.00) 69 % Ueed .00 (8,925.00) AR Account: 135-49075-000-000 Account: 135-49075-000-000 ` Oversize Meter Reimbursement Totals: (12,691.00) Budgeted (4,960.72) Remaining (7,730.28) 61 % Used .00 (7,730.28) Account: 135-49900-000-00 Miscellaneous In 1243 05/31/2020 UB 05/31/2020 Billing U820200531-20200531 Ueer: Miscellaneous In (7,000.00) Budgeted 1,971.93 Remaining (8,802.09) 128 Used (169.84) (8,971.93) Department Totals: (5,336,857.41) •• (748,512.43) Monthly Total (10,645,077.00) Budgeted (5,308,219.59) Remaining 50 % Used 59 of 150 UB glpdatb2 skrolczyk 10:08 06/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Department: 10 Water JE Detail Description/Comment Account: 135-50005-010- Salaries & W 1110 05/01/2020 MUD Payroll 5/1/2020 1180 05/15/2020 MUD Payroll 5/15/2020 1223 05/29/2020 MUD Payroll 5/29/2020 Account Salaries & Wages Salaries & Wages Salaries & Wages 350,267.00 Budgeted Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 5/2020 Beginning Balance June 15, 2020 Regular Meeting Agenda Packet Page 9 Program: Transaction Transaction Vendor Name Check Source Detail Detail Number (SUBTOTAL) 192,746.19 15,439.35 208,185.54 PR 15,439.35 223,624.89 PR 15,439.35 239,064.24 PR 111,202.76 Remaining 68 % Used ACCOun 1110 05/01/2020 MUD Payroll 5/1/2020 Overtime 1180 05/15/2020 MUD Payroll 5/15/2020 Overtime 1223 05/29/2020 MUD Payroll 5/29/2020 Overtime 11,865.26 515.40 12,380.66 PR 505.40 12,886.06 PR 541.69 13,427.75 PR Aoc 17,000.00 Budgeted 3,572.25 Remaining 79 Used Account: 135-50016-010-000 Longevity 5,082.50 .00 5,082.50 Accmmtall Longevity 3,920.00 Budgeted Totals: (1,162.50) Remaining 130 % Used Account: 135-50017-010-000 Certification 1180 05/15/2020 MUD Payroll 5/15/2020 Certification 2,925.00 425.00 3,350.00 PR Account: 135-50017-010-001 Certification Totals: 5,400.00 Budgeted Account: 135-50020-010-000 1110 05/01/2020 MUD Payroll 5/1/2020 Retirement 1180 05/15/2020 MUD Payroll 5/15/2020 Retirement 1223 05/29/2020 MUD Payroll 5/29/2020 Retirement Account: 135-50020-010-000 34,863.00 Budgeted Account: 135-50026-0 1110 05/01/2020 MUD Payroll 5/1/2020 Medical Insurance 2,050.00 Remaining 62 % Ueed 20,760.14 1,477.42 22,237.56 PR 1,515.84 23,753.40 PR 1,479.84 25,233.24 PR 9,629.76 Remaining 72 % Ueed 34,828.70 2,612.55 37,441.25 PR 60 of 150 glpdatb2 skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/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 June 15, 2020 Regular Meeting Agenda Packet Page 10 1180 05/15/2020 MUD Payroll 5/15/2020 Medical Insurance Account: 135-50026-010- edical Insurance 84,326.00 Budgeted Account: 135-50027-010-000 Dental Insurance 1110 05/01/2020 MUD Payroll 5/1/2020 Dental Insurance 1180 05/15/2020 MUD Payroll 5/15/2020 Dental Insurance Account: Totals: 44,272.26 Remaining 34,828.70 2,114.74 2,612.49 40,053.74 47 % Used 158.32 158.31 2,273.06 2,431.37 PR PR PR 4,725.00 Budgeted 1110 05/01/2020 MUD Payroll 5/1/2020 Vision Insurance 1180 05/15/2020 MUD Payroll 5/15/2020 Vision Insurance Account: 135 Vision Insurance 767.00 Budgeted 2,293.63 Remaining Account: 135-50029-010-00 Life Insuran 1095 05/01/2020 May A/P Employee Benefits 1122 05/01/2020 May Payroll Benefits Employee LTD & STD 1215 05/21/2020 May A/P cafe 125 plan Account: 135 1110 05/01/2020 MUD Payroll 5/1/2020 1180 05/15/2020 MUD Payroll 5/15/2020 1223 05/29/2020 MUD Payroll 5/29/2020 Account: 135 1110 05/01/2020 MUD Payroll 5/1/2020 1180 05/15/2020 MUD Payroll 5/15/2020 Life Insurance & Othe 3,132.00 Budgeted 51 % Used 332.47 s Totals: 386.35 Remaining 50 % Used 24.10 356.57 24.08 380.65 2,206.06 176.88 2,382.94 Humana Inc 132.01 2,514.95 METLIFE GROUP BENEFITS 20.00 2,534.95 BenefitMall 597.05 Remaining 81 % Used Social Security Taxes Social Security Taxes Social Security Taxes Social Security Taxes Social Security Taxes 23,348.00 Budgeted Medicare Taxes Medicare Taxes Medicare Taxes 7,346.67 Remaining 95 ** PR PR 6414 AP 6417 AP 6441 AP 13,026.95 984.19 14,011.14 PR 999.37 15,010.51 PR 990.82 16,001.33 PR 69 3,046.60 Used 61 of 150 230.18 3,276.78 233.72 3,510.50 PR PR glpdatb2 skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) June 15, 2020 Regular Meeting Agenda Packet Page 11 1223 05/29/2020 MUD Payroll 5/29/2020 Medicare Taxes Account: 135-58 I.0-000 3,046.60 231.72 Medicare Taxes Totals: 69 5,461.00 Budgeted 1,718.78 Remaining 69 % Used Account: 135-50040-010-000 Account: 135-50040-010-000 3,742.22 PR Unemployment Taxes 880.68 .00 880.68 Unemployment Taxes 1,080.00 Budgeted 199.32 Remaining 82 % Used Account: 135-50045-010- Workman's Compensation 73 05/01/2020 Insurance/Wrk Comp Expense May Account: 135-50045-0 kman's Compensation 11,850.00 Budgeted Account: 135-50060-010-000 Account: 135-50060-010-000 Pre-emp Physicals/Testing 5,575.93 771.49 5,502.58 Remaining 54 % Used Pre-emp Physicals/Testing Totals: 400.00 Budgeted 400.00 Remaining Account: 135-50070-010-000 Employee Relations Account: 135-50070-010-000 Employee Relations Totals: 300.00 Budgeted Account: 135-55005-010-000 Engineering Account: 135-55005-010-000 — Engineer 20,000.00 Budgeted Account: 13580-010-000 e & R 1215 05/21/2020 May A/P Irrigation repair 0 % Used 6,347.42 GL .00 .00 .00 .00 300.00 Remaining 0 % Ueed .00 .00 20,000.00 Remaining 0 % Used 24,431.71 257.25 62 of 150 24,688.96 Stephen [,arxer 6463 AP glpdatb2 skrolczyk 10:08 06/10/20 Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/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 June 15, 2020 Regular Meeting Agenda Packet Page 12 1215 05/21/2020 May A/P irrigation repair 1215 05/21/2020 May A/P Irrigation repair 1215 05/21/2020 May A/P meter boxes 1249 05/26/2020 PCards 4/28/2020-5/26/2020 4x4 bushing 1249 05/26/2020 PCards 4/28/2020-5/26/2020 valves, pressure principles 1249 05/26/2020 PCards 4/28/2020-5/26/2020 torch head, propane cylinder 1249 05/26/2020 PCards 4/28/2020-5/26/2020 sod 24,431.71 235.74 500.00 3,931.20 3.50 76.65 41.44 44.20 24,924.70 Stephen Marxer 25,424.70 Stephen Marxer 29,355.90 Core & Main LP 29,359.40 ROANOKE WINNELSON CO 29,436.05 SC TRACKING SOLUTIONS 29,477.49 THE HOME DEPOT #6581 29,521.69 TEX-TURF 6463 AP 6463 AP 6444 AP PC PC PC PC Account: 135-55080-010-000 Maintenance & Repairs Totals: 5,089.98 29,521.69 ** 100,000.00 Budgeted 70,478.31 Remaining 30 5 Used Account: 135-55085-010-000 Generator Maint. and Repair .00 .00 Account: 135-55085-010-000 Generator Maint. and Repair Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 135-55090-010-000 Vehicle Maintenance 1249 05/26/2020 PCards 1249 05/26/2020 PCards 4/28/2020-5/26/2020 wheel bearing 4/28/2020-5/26/2020 oil change 1,842.56 517.51 84.36 2,360.07 2,444.43 GIERISCH CARE 0050292 KWIK KAR LUBE & TUNE 0 PC PC Account: 135-55090-010-000 Vehicle Maintenance Totals: 601.87 2,444.43 ** 5,000.00 Budgeted 2,555.57 Remaining 49 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 1,828.19 .00 1,828.19 Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 1,828.19 ** 3,500.00 Budgeted 1,671.81 Remaining 52 % Used Account: 135-55120-010-000 Cleaning Services 1215 05/21/2020 May A/P Janitorial service -April 525.00 87.50 612.50 MEMBER'S BUILDING MAINTENANCE 6458 AP Account: 135-55120-010-000 Cleaning Services Totals: 87.50 612.50 ** 1,000.00 Budgeted 387.50 Remaining 61 5 Used Account: 135-55135-010-000 Lab Analysis 2,451.64 .00 2,451.64 63 of 150 glpdatb2 skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) June 15, 2020 Regular Meeting Agenda Packet Page 13 Account: 135-55135-010-000 Lab Analysis Totals: .00 2,451.64 ** 7,500.00 Budgeted 5,048.36 Remaining 33 % Used Account: 135-60010-010-000 Communications/Mobiles 1178 05/11/2020 May A/P Cell phones 3,267.94 385.40 3,653.34 VERIZON WIRELESS 6438 AP Account: 135-60010-010-000 Communications/Mobiles Totals: 385.40 3,653.34 ** 5,000.00 Budgeted 1,346.66 Remaining 73 % Used Account: 135-60020-010-000 Electricity 1215 05/21/2020 May A/P Electricity 4/8-5/8 71,633.79 9,128.56 80,762.35 HUDSON ENERGY SERVICES, LLC 6450 AP Account: 135-60020-010-000 Electricity Totals: 9,128.56 80,762.35 ** 125,677.00 Budgeted 44,914.65 Remaining 64 % Used Account: 135-60066-010-000 Publications/Books/Subscripts 850.00 .00 850.00 Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 850.00 ** 1,000.00 Budgeted 150.00 Remaining 85 % Used Account: 135-60070-010-000 Dues & Memberships 105.00 .00 105.00 Account: 135-60070-010-000 Dues & Memberships Totals: .00 105.00 ** 500.00 Budgeted 395.00 Remaining 21 % Used Account: 135-60080-010-000 Schools & Training 1249 05/26/2020 PCards 4/28/2020-5/26/2020 license renewal J. Ramirez 1,436.00 111.00 1,547.00 TCEQ IND RENEWAL LIC PC Account: 135-60080-010-000 Schools & Training Totals: 111.00 1,547.00 ** 7,426.00 Budgeted 5,879.00 Remaining 21 % Used Account: 135-60090-010-000 Safety Program .00 .00 64 of 150 glpdatb2 skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) ACC June 15, 2020 Regular Meeting Agenda Packet Page 14 Account: 135-60100-010-000 Account: 135-60105-010-000 Account: 135-60105-010-000 Account: 135-60135-010-000 Account: 135-60135-010-00: Account: 135-60150-010-0 1251 05/31/2020 May A/P Account: 135-60245-010-000 Account: 135-60245-010-000 Account: 135-60280-010-000 Safety Program 400.00 Budgeted Travel & per diem 400.00 Remaining 0 % Used Travel & per diem Totals: 2,845.00 Budgeted Rent/Lease Equipment Rent/Lease Equipment 1,500.00 Budgeted TCEQ Fees & Permit TCEQ Fees & Permits 63,000.00 Budgeted 2,845.00 Remaining 0 % Used Totals: 1,500.00 Remaining 20,205.04 0 % Used 42,794.96 Remaining 32 % Used Wholesale Water Wholesale water 752,381.54 Wholesale Water 2,714,710.00 Budgeted Miscellaneous Expenses Miscellaneous Expenses 200.00 Budgeted Property Maintenance .00 .00 .00 .00 .00 20,205.04 130,922.95 883,304.49 CITY OF FORT WORTH 1,831,405.51 Remaining 33 % Used .00 200.00 Remaining 0 % Used 756.00 .00 65 of 150 .00 756.00 6470 AP glpdatb2 skrolczyk 10:08 06/10/20 Fund: 135 MUD 1 General Fund ACC JE JE JE Number Date Description 1251 05/31/2020 May A/P Account: 135-60285-010-000 Account: 135 1292 05/31/2020 TexPool Transfers May Account: 135-60332-010-00 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 5/2020 JE Detail Description/Comment Property Maintenance Tota 3,000.00 Budgeted June 15, 2020 Regular Meeting Agenda Packet Page 15 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) 2,244.00 Remaining 25 % Used Lawn Equipment & Maintenance Mowing -May Lawn Equipment & Maintenance Totals: 14,750.00 Budgeted 11,750.00 Remaining Interfund Transfe- TexPool O&M to 16Swift Rev I&S Interfund Transfer 527,381.00 Budgeted Account: 135-60333-010-000 1292 05/31/2020 TexPool Transfers May 143,831.08 1,500.00 1,500.00 3,000.00 WATTS ELLISON LLC 20 % Used 25,047.72 383,549.92 358,502.20 Remaining Interfund Transfer Out -Reserve TexPool O&M to Rev Bond Resevr 32,200.00 73 Used Account: 135-60333-010-000 X Interfund Transfer Out -Reserve TotlEr 55,193.00 Budgeted 18,393.00 Remaining 67 % Used Account: 135-60334-010-000 erfund Transfer Ou Account: 135-60334-010-000 Interfund Transfer Out 180,000.00 Budgeted 180,000.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: 2,500.00 Budgeted 1,938.28 Remaining Account: 135-65005-010-000 Fuel & Lube 1236 05/24/2020 Fuel Fuel -may 561.72 4,600.00 4,600.00 36,800.00 36,800.00 .00 .00 .00 .00 .00 561.72 22 % Used 6483 AP GL GL 5,733.85 442.13 6,175.98 US Bank Voyager Fleet Systems 6481 AP 66 of 150 glpdatb2 skrolczyk 10:08 06/10/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: 5/2020 Beginning Balance June 15, 2020 Regular Meeting Agenda Packet Page 16 Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) Check Source Number 67 of 150 Account: 135-65005-010-000 Fuel & Lube Totals: 442.13 6,175.98 ** 15,000.00 Budgeted 8,824.02 Remaining 41 % Used Account: 135-65010-010-000 Uniforms 2,917.33 .00 2,917.33 Account: 135-65010-010-000 Uniforms Totals: .00 2,917.33 ** _ 5,190.00 Budgeted 2,272.67 Remaining 56 % Used Account: 135-65030-010-000 Chemicals = 1191 05/18/2020 mAY a/p 1251 05/31/2020 May A/P testing supplies chorine 11,862.25 1,008.16 781.77 12,870.41 13,652.18 HACH DPC COMPANY INDUSTRIES, INC 6448 6471 AP AP Account: 135-65030-010-000 Chemicals Totals: 1,789.93 13,652.18 ** 20,000.00 Budgeted 6,347.82 Remaining 68 % Used Account: 135-65035-010-000 Small Tools .00 .00 Account: 135-65035-010-000 Small Tools Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used 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 59,593.08 .00 59,593.08 Account: 135-65050-010-000 Meter Expense Totals: .00 59,593.08 ** 70,000.00 Budgeted 10,406.92 Remaining 85 % Used Account: 135-65053-010-000 Meter Change Out Program 36,900.00 .00 36,900.00 67 of 150 glpdatb2 skrolczyk 10:08 06/10/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: Period Ending: 5/2020 JE Detail Description/Comment June 15, 2020 Regular Meeting Agenda Packet Page 17 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 135-65053-010-000 Meter Change Out Program Tota 87,000.00 Budgeted 50,100.00 Remaining Account: Capital Outlays 1084 05/01/2020 Capital Asset Fund Corrections 1215 05/21/2020 May A/P 20. gate valve and line stop -f Account: 135-69005-010-000 Capital Outlays 684,875.00 Budgeted Account: 135-69008-010-000 42 % Used 276,524.74 (10,507.78) 266,016.96 GL 348,983.56 Remaining 49 % Used Short Term Debt -Principal Account: 135-69008-010-000 30,512.00 Budgeted Account: 135-69009-010-000 Short Term Debt -Principal Account: 135-69009-010-000 Account: 135-69195-010-000 Account: 135-69195-010-000 Short Term Debt -Interest Totals: - .00 Remaining Short Term Debt -Interest Totals: 3,231.00 Budgeted 1,391.00 Remaining Gasb34/Reserve for Replacement Gasb34/Reserve for Replacement Total.. 75,000.00 Budgeted .00 Remaining 30,512.00 100 % Used 1,840.00 75,000.00 57 ', Used 69,874.48 335,891.44 REY-MAR CONSTRUCTION 6462 AP .00 30,512.00 .00 1,840.00 .00 100 % Used 75,000.00 Account: 135-69281-010-000 Water Tank Inspection Contract Account: 135-69281-010-000 102,077.11 Water Tank Inspection Contract Totals: 120,000.00 Budgeted 17,922.89 Remaining .00 102,077.11 85 % Used Account: 135-70040-010-000 ed Expenses 1300 05/20/2020 AG Fee Refund Tax Series 2020 Refunding Tax Bond Series 2020 1,220.00 68 of 150 1,220.00 ATTORNEY GENERAL/STATE OF TX 6501 AP glpdatb2 skrolczyk 10:08 06/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 1 Account: 135-70040-010-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 5/2020 JE Detail Description/Comment Bond Related Expenses Totals: .00 Budgeted June 15, 2020 Regular Meeting Agenda Packet Page 18 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) (1,220.00) Remaining 0 % Used 69 of 150 1,220.00 1,220.00 ** glpdatb2 skrolczyk 10:08 06/10/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: 5/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) June 15, 2020 Regular Meeting Agenda Packet Page 19 JE Detail Description/Comment Account: 135-55135-010-001 Lab Analysis for PID 1,001.64 .00 1,001.64 Account: 135-55135-010-001 Lab Analysis for PID Totals: .00 1,001.64 ** 2,000.00 Budgeted 998.36 Remaining 50 % Used Department 10 Totals: 2,477,264.16 ** 303,432.61 Monthly Total 5,506,929.00 Budgeted 3,029,664.84 Remaining 45 % Used 70 of 150 June 15, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/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-020- Salaries & We 1110 05/01/2020 MUD Payroll 5/1/2020 Salaries & Wages 1180 05/15/2020 MUD Payroll 5/15/2020 Salaries & Wages 1223 05/29/2020 MUD Payroll 5/29/2020 Salaries & Wages Account Iies & Wages 441,799.00 Budgeted Account: 135-50010-020-00 1110 05/01/2020 MUD Payroll 5/1/2020 Overtime 1180 05/15/2020 MUD Payroll 5/15/2020 Overtime 1223 05/29/2020 MUD Payroll 5/29/2020 Overtime 215,244.45 16,559.46 231,803.91 PR 16,559.46 248,363.37 PR 16,559.46 264,922.83 PR 176,876.17 Remaining 60 % Used 11,995.38 329.19 12,324.57 PR 1,471.69 13,796.26 PR 1,256.41 15,052.67 PR Aoc 33,000.00 Budgeted 17,947.33 Remaining 46 Used Account: 135-50016-020-000 Longevity Account: 135-50016-020-000 Longevity 8,035.00 Budgeted Account: 135 Certification 1110 05/01/2020 MUD Payroll 5/1/2020 Certification 1180 05/15/2020 MUD Payroll 5/15/2020 Certification Certification 9,000.00 Budgeted Account: 135-50020-020-000 Retirement 1110 05/01/2020 MUD Payroll 5/1/2020 Retirement 1180 05/15/2020 MUD Payroll 5/15/2020 Retirement 1223 05/29/2020 MUD Payroll 5/29/2020 Retirement 6,872.50 .00 6,872.50 Totals: 1,162.50 Remaining 86 % Used 4,375.00 3,925.00 Remaining 56 % Used 23,612.35 etirement Totals: 45,531.00 Budgeted 1 Ac Medical Insurance 16,970.50 Remaining 63 % Used 71 of 150 75.00 4,450.00 625.00 5,075.00 PR PR 1,570.84 25,183.19 PR 1,727.55 26,910.74 PR 1,649.76 28,560.50 PR June 15, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1110 05/01/2020 MUD Payroll 5/1/2020 Medical Insurance 49,266.55 1180 05/15/2020 MUD Payroll 5/15/2020 Medical Insurance 3,463.38 52,729.93 3,463.33 56,193.26 PR PR Accal1111035-50026-020 Medical Insurance Totals: 48,664.74 Remaining 54 % Used 104,858.00 Budgeted Account: 135-50027-020-009 Dental Insurance 1110 05/01/2020 MUD Payroll 5/1/2020 Dental Insurance 1180 05/15/2020 MUD Payroll 5/15/2020 Dental Insurance Account: 135-50027-020-000 limiEcount: 135-1028-020-00 1110 05/01/2020 MUD Payroll 5/1/2020 1180 05/15/2020 MUD Payroll 5/15/2020 Dental Insur- 5,817.00 Budgeted Vision Insurance Vision Insurance 2,545.03 Remaining 2,879.22 459.91 56 Used 196.39 196.36 3,075.61 3,271.97 31.40 491.31 31.40 522.71 PR PR PR PR Account: 135 -50028 -020 - Vision Insurance Totals: Account: 135-50029-020-000 1095 05/01/2020 May A/P 1122 05/01/2020 May Payroll Benefits 1215 05/21/2020 May A/P Account: 135-50029-020-000 Account: 135-50030-020-000 1110 05/01/2020 MUD Payroll 5/1/2020 1180 05/15/2020 MUD Payroll 5/15/2020 1223 05/29/2020 MUD Payroll 5/29/2020 Account: 135-50030-020-000 Account: 135-50035-0 1110 05/01/2020 MUD Payroll 5/1/2020 948.00 Budgeted Life Insurance & Other Employee Benefits Employee LTD & STD cafe 125 plan Life Insurance & Other 4,500.00 Budgeted 425.29 Remaining 55 % Used 2,569.18 186.78 2,755.96 Humana Inc 165.74 2,921.70 METLIFE GROUP BENEFITS 32.00 2,953.70 BenefitMall 1,546.30 Remaining 66 % Ueed Social Security Taxes Social Security Taxes Social Security Taxes Social Security Taxes Social Security Taxes 30,494.00 Budgeted Faxen ■ Medicare Taxes 13,808.00 1,026.69 1,091.37 1,107.20 13,460.74 Remaining 56 % Used 14,834.69 15,926.06 17,033.26 6414 AP 6417 AP 6441 AP PR PR PR 3,229.27 240.13 3,469.40 PR 72 of 150 June 15, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1180 05/15/2020 MUD Payroll 5/15/2020 1223 05/29/2020 MUD Payroll 5/29/2020 Account: 135 Account: 135-50040-020-000 Medicare Taxes Medicare Taxes Medicare Taxes Totals: 7,132.00 Budgeted Unemployment Taxes Account Unemployment Taxes 1,260.00 Budgeted Account: 135-50045-020-000 Workman's Compensation 73 05/01/2020 Insurance/Wrk Comp Expense May 3,229.27 255.22 3,724.62 PR 258.93 3,983.55 PR 3,148.45 Remaining 56 % Used 1,008.00 .00 1,008.00 252.00 Remaining 80 % Ueed Account: 135-50045-020- Workman's Compensation Tot - 15,373.00 Budgeted 6,315.90 Remaining 7,946.90 1,110.20 59 % Used 9,057.10 GL Account: 135-50060-020-000 Pre-emp Physicals/Testing Account: 135-50060-020-000 Pre-emp Physicals/Testing 400.00 Budgeted Account: 135-50070-020-0' 1249 05/26/2020 PCarde 4/28/2020-5/26/2020 lunch 362.00 Remaining or WWTP employees Account: 135-50070-02 Employee Relations 300.00 Budgeted 38.00 10 % Used 253.92 Remaining 15 % Used .00 38.00 46.08 46.08 MARCOS PIZZA 5143 PC Account: 135-55005-020-000 . Engineering .00 .00 Account: 135-55005-020-000 Engineering T 30,000.00 Budgeted 30,000.00 Remaining 0 % Used Account: 135-55070-020-000 Independent Labor 73 of 150 June 15, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 23 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 3,000.00 .00 3,000.00 Account: 135-55070-020-000 Independent Labor Totals: .00 3,000.00 ** 15,000.00 Budgeted 12,000.00 Remaining 20 % Used Account: 135-55080-020-000 Maintenance & Repairs 1191 05/18/2020 mAY a/p replace float 42,136.36 632.00 42,768.36 DHS AUTOMATION, INC 6446 AP 1191 05/18/2020 mAY a/p 490.00 43,258.36 DHS AUTOMATION, INC 6446 AP 1191 05/18/2020 mAY a/p 750.00 44,008.36 DHS AUTOMATION, INC 6446 AP 1191 05/18/2020 mAY a/p replace light fixtures 1,460.00 45,468.36 DHS AUTOMATION, INC 6446 AP 1191 05/18/2020 mAY a/p replace ballasts in press room 774.00 46,242.36 DHS AUTOMATION, INC 6446 AP 1191 05/18/2020 mAY a/p install lights under shoot 1,310.00 47,552.36 DHS AUTOMATION, INC 6446 AP 1249 05/26/2020 PCarde 4/28/2020-5/26/2020 hose and accessories 451.12 48,003.48 IN *HOSE TECH USA PC Account: 135-55080-020-000"1111 Maintenance & Repairs Totals: 5,867.12 48,003.48 ** 88,000.00 Budgeted 39,996.52 Remaining 55 % Used Account: 135-55081-020-000 Mainten & Repairs Collections 18,113.87 .00 18,113.87 Account: 135-55081-020-000 Mainten & Repairs Collections Totals: .00 18,113.87 ** 10,000.00 Budgeted (8,113.87) Remaining 181 % Used Account: 135-55085-020-000 Generator Maint. and Repair .00 .00 Account: 135-55085-020-000 Generator Maint. and Repair Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-55090-020-000 Vehicle Maintenance 824.94 .00 824.94 Account: 135-55090-020-000 Vehicle Maintenance Totals: .00 824.94 ** 4,000.00 Budgeted 3,175.06 Remaining 21 % Used Account: 135-55091-020-000 Veh Maintenance Collections 1249 05/26/2020 PCards 4/28/2020-5/26/2020 gas cap 2,011.88 8.92 2,020.80 ROANOKE AUTO SUPPLY LT 74 of 150 PC glpdatb2 skrolczyk 10:08 06/10/20 Fund: 135 MUD 1 General Fund ACC JE Number JE Date JE Description 1251 05/31/2020 May A/P Account: 135-55105-020-000 Account: 135-55120-020-000 1215 05/21/2020 May A/P Account: 135-55120-020-000 Account: 135-55125-020-000 1178 05/11/2020 May A/P 1251 05/31/2020 May A/P 1251 05/31/2020 May A/P 1251 05/31/2020 May A/P Account: 135-55125-020-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 5/2020 JE Detail Beginning Balance Description/Comment Veh Maintenance Collections Totals: 8,000.00 Budgeted 5,979.20 Remaining Maintenance-Backhoe/SkidLoader 1 yr JD -Link renewal (backhoe) Maintenance-Backhoe/SkidLoader Totals: 3,000.00 Budgeted 1,967.78 Remaining Cleaning Services Janitorial service -April Cleaning Sery cec - 1,500.00 Budgeted 887.50 Remaining Dumpster Services sludge haul off sludge haul off sludge haul off sludge haul off Dumpster Services 100,000.00 Budgeted 38,127.16 Remaining 5-55135-020-000 ' Lab Analysis 1178 05/11/2020 May A/P lab testing 1178 05/11/2020 May A/P lab testing 1191 05/18/2020 mAY a/p lab testing 1191 05/18/2020 mAY a/p lab testing 1215 05/21/2020 May A/P lab testing 1215 05/21/2020 May A/P lab testing 1249 05/26/2020 PCards 4/28/2020-5/26/2020 shipping for lab analysis 1251 05/31/2020 May A/P lab testing 1251 05/31/2020 May A/P lab testing Lab Analysis 40,000.00 Budgeted 832.22 Program: Transaction Detail 25 % Used 34 % Used June 15, 2020 Regular Meeting Agenda Packet Page 24 Transaction Vendor Name Detail (SUBTOTAL) 8_ 2,020.80 ** 200.00 200.00 1,032.22 RDO Equipment Co 1,032.22 ** Check Source Number AIIII 6477 AP 525.00 87.50 612.50 MEMBER'S BUILDING MAINTENANCE 6458 AP 41 % Used 51,616.18 62 % Used 21,376.10 16,183.66 Remaining 60 % Used 75 of 150 2,471.32 3,402.56 3,317.62 1,065.16 341.55 241.50 326.70 241.50 341.55 241.50 122.89 341.55 241.50 54,087.50 57,490.06 60,807.68 61,872.84 21,717.65 21,959.15 22,285.85 22,527.35 22,868.90 23,110.40 23,233.29 23,574.84 23,816.34 L.H. CHANEY MATERIALS, INC. L.H. CHANEY MATERIALS, INC. L.H. CHANEY MATERIALS, INC. L.H. CHANEY MATERIALS, INC. OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC POSTNET TX193 OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC 6428 AP 6474 AP 6474 AP 6474 AP 6431 AP 6431 AP 6461 AP 6461 AP 6461 AP 6461 AP PC 6476 AP 6476 AP June 15, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/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-60010-020-00 1178 05/11/2020 May A/P Account: 135-60010-02 Account: 135-60020-020-000 1191 05/18/2020 mAY a/p 1215 05/21/2020 May A/P Communications/Mobiles Cell phones 3,496.18 407.91 Communications/Mobiles Tota 5,000.00 Budgeted 1,095.91 Remaining 78 % Ueed Electric electricity 4/1-5/5 73,247.99 Electricity 4/8-5/8 1265 05/31/2020 Town Billed Invoices 1738-1741 AR 20200531-20200531 User: Account: 135-60020-020-000 Ole,, 160,067.00 Budgeted 3,904.09 VERIZON WIRELESS 6438 AP 528.61 73,776.60 TRI COUNTY ELECTRIC 6467 AP 10,912.04 84,688.64 HUDSON ENERGY SERVICES, LLC 6450 AP (308.63) 84,380.01 AR 75,686.99 Remaining 53 % Used Account: 135-60066-020-000 Publications/Books/Subscripts Account: 135-60066-020-000 Publications/Books/Subscripts Totals: 200.00 Budgeted 200.00 Remaining Account: 135-60070-020-000 Dues & Memberships 216.00 .00 .00 0 % Used .00 216.00 2,542.85 TEEX ECOMMERCE .00 109.14 Account: 135-60070-020-000 Dues & Memberships 300.00 Budgeted Account: 135-60080-020-000 Dols 7F aining 1249 05/26/2020 PCards 4/28/2020-5/26/2020 F.Isola Class Refund 84.00 Remaining 72 % Ueed Account: 135-60080-020-000 Dols & Training Total Account: 135-60090-020-000 4,990.00 Budgeted - Safety Program Account: 135-60090-020-000 Safety Program 1,000.00 Budgeted 2,447.15 Remaining 2,962.85 109.14 51 % Used 890.86 Remaining 11 % Used 76 of 150 (420.00) PC June 15, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/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-60100-020-000 Travel & per diem 410.72 .00 410.72 Account: 135-60100-020-000 Travel & per diem Totals: 410.72 ** 1,545.00 Budgeted 1,134.28 Remaining 27 % Used Account: 135-60105-020-000 Rent/Lease Equipment Account: 135-60105-020-000 Rent/Lease Equipment Totals: 5,000.00 Budgeted 5,000.00 Remaining 0 % Used .00 .00 .00 ** Account: 135-60125-020-000 Advertising Account: 135-60125-020-000 Advertising 2,500.00 Budgeted 2,500.00 Remaining .00 0 % Used .00 Account: 135-60135-020-000 TCEQ Fees & Fermi Account: 135-60135-020-000 TCEQ Fees & Permits 15,000.00 Budgeted Account: 135-60245-020-000 xpense Account: 135-60245-020-000 Account: 135-60280-020-000 Account: 135-60280-020-000 Miscellaneous Expenses 450.00 Budgeted Property Maintenance Property Maintenance 5,000.00 Budgeted 4,911.98 Remaining 450.00 Remaining Totals: 10,088.02 584.94 67 % Used 0 % Used 4,415.06 Remaining 12 % Used 0 10,088.02 .00 .00 .00 584.94 Account: 135-60285-020-000 Lawn Equipment & Maintenance 77 of 150 June 15, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1251 05/31/2020 May A/P Mowing -May 1,480.00 1,480.00 2,960.00 WATTS ELLISON LLC Account: 135-6028 Lawn Equipment & Maintenance Totals: W 1 1,4 14,000.00 Budgeted 11,040.00 Remaining 21 % Used 83,318.48 Account: 135-60331-020-000 1292 05/31/2020 TexPool Transfers May Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S TexPool O&M to I&S- PID Debt Interfund Transfer Out -Tax I&S Tot 114,563.00 Budgeted 31,244.52 Account: 135-&0332-020-000 Interfund Rev I&S 1292 05/31/2020 TexPool Transfers May Account: 135-60333-020-000 Remaining TexPool O&M to Rev Bd WWTP I&S 72,903.67 435,663.37 -r Out -Rev I&S Tota 673,867.00 Budgeted 183,782.00 Remaining Interfund Transfer Out -Reserve 1292 05/31/2020 TexPool Transfers May TexPool O&M to Rev Bond Reeevr 40,250.00 5,750.00 46,000.00 73 % Used 73 % Used 10,414.81 54,421.63 490,085.00 54,421.63 Account :0 Interfund Transfer Out -Reserve Totals: 125,187.00 Budgeted 79,187.00 Remaining Account: 135-60334-020-000 Interfund Transfer Out Account: 135-60334-020-000 Interfund Transfer Out Totals: 180,000.00 Budgeted 180,000.00 Remaining 37 % Used .00 .00 0 % Ueed 6483 AP GL GL GL Account: 135-60360-020-000 Furniture/Equipment < $5000 Account: 135-60360-020-000 e/Equipment < $500 2,000.00 Budgeted Account: 135-65005-020-000 1236 05/24/2020 Fuel Fuel -may 1,810.00 Remaining 190.00 10 .00 Used 190.00 4,738.13 368.08 5,106.21 US Bank Voyager Fleet Systems 6481 AP 78 of 150 glpdatb2 skrolczyk 10:08 06/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Account: 135-65010-020-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Program: Period Ending: 5/2020 JE Detail Description/Comment Fuel & Lube 12,500.00 Budgeted RP Uniforms Account: 135-65010-020-000 June 15, 2020 Regular Meeting Agenda Packet Page 28 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) 7,393.79 Remaining 3,507.93 41 % Ueed Uniforms - Totals: 5,495.00 Budgeted 1,987.07 Remaining 64 % Used Account: 135-65030-020 Chemicals 1178 05/11/2020 May A/P Sodium Hypo 1191 05/18/2020 mAY a/p Defoamer 1251 05/31/2020 May A/P Sodium Hypo Account: 135-65030-020-00' Chemicals 20,000.00 Budgeted Account: 135-65031-020-000 Chemicals Collections Account: 135-65031-020-000 Chemicals Collections 17,500.00 Budgeted Account: 135-65035-020-000 Account: 135-65035-020-000 Account: 135-65040-020-000 Account: 135-65040-020-000 ma oo s Small Tools 1,200.00 Budgeted Safety Equipment Safety Equipment 1,200.00 Budgeted 71.66 Remaining 12,506.00 Remaining 1,200.00 Remaining Totals: 17,139.42 .00 3,507.93 580.00 1,628.92 580.00 100 5 Used 4,994.00 1,166.53 29 % Used 0 % Used 33.47 Remaining 97 % Used 17,719.42 Valley Solvent Company, INC 19,348.34 MARYLAND BIOCHEMICAL CO, INC 19,928.34 Valley Solvent Company, INC .00 4,994.00 .00 .00 .00 1,166.53 6437 AP 6456 AP 6482 AP Account: 135-65045-020-000 Lab Supplies 79 of 150 June 15, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 29 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1249 05/26/2020 PCards 4/28/2020-5/26/2020 distilled water 16,432.18 1249 05/26/2020 PCards 4/28/2020-5/26/2020 black light Acc(1135-65045-0211 Lab Supplies 20,000.00 Budgeted 3,465.94 Remaining 83 % Used 3.96 16,436.14 TOM THUMB #1789 97.92 16,534.06 WWW.INTERLIGHT.BIZ 1.88 16,534.06 ** PC PC Account: 135-69005-020-000 Capital Outlays 1084 05/01/2020 Capital Asset Fund Corrections Foam System- Recode 135 to 517 182,063.00 (9,525.00) 172,538.00 GL 1178 05/11/2020 May A/P WWTP0 49,978.00 222,516.00 REY-MAR CONSTRUCTION 6432 AP 1178 05/11/2020 May A/P WWTP building and sound wall 71,496.00 294,012.00 REY-MAR CONSTRUCTION 6432 AP Acc 69005-020-000 Capital Outlays 530,500.00 Budgeted 236,488.00 Remaining 55 % Used Account: 135-69008-020-000 Short Term Debt -Principal Account: 135-69008-020-000 Short Term Debt -Principal Totals: 79,133.00 Budgeted 19,528.26 Remaining 59,604.74 .00 59,604.74 75 % Used Account: 135-69009-020-000 Short Term Debt -Interest Account: 135-69009-020-000 Term Debt -Inter 11,277.00 Budgeted 5,154.97 Remaining 6,122.03 54 Used .00 6,122.03 Account: 135-69195-020-000 Gasb34/Reserve for Replacement 130,000.00 Account: 135-69195-020-000 Gasb34/Reserve for Replacement Totals: 130,000.00 Budgeted .00 Remaining Department 20 Totals: 100 % Used .00 130,000.00 1,839,653.21 ** 288,541.11 Monthly Total 3,157,421.00 Budgeted 1,317,767.79 Remaining 58 % Used 80 of 150 glpdatb2 skrolczyk 10:08 06/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 26 Board of Directors Period Ending: 5/2020 JE Detail Description/Comment June 15, 2020 Regular Meeting Agenda Packet Page 30 Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Check Source Number 81 of 150 Account: 135-50045-026-000 Workman's Compensation 73 05/01/2020 Insurance/Wrk Comp Expense May 13.93 1.99 15.92 GL Account: 135-50045-026-000 Workman's Compensation Totals: 1.99 15.92 ** 30.00 Budgeted 14.08 Remaining 53 % Used Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60070-026-000 Dues & Memberships 675.00 .00 675.00 Account: 135-60070-026-000 Dues & Memberships Totals: .00 675.00 ** 750.00 Budgeted 75.00 Remaining 90 % Used Account: 135-60075-026-000 Meetings 1249 05/26/2020 PCards 4/28/2020-5/26/2020 zoom meetings subscription 289.82 123.99 413.81 ZOOM.US PC Account: 135-60075-026-000 Meetings Totals: 123.99 413.81 ** 1,300.00 Budgeted 886.19 Remaining 32 % Used Account: 135-60080-026-000 Schools & Training .00 .00 Account: 135-60080-026-000 Schools & Training Totals: .00 .00 ** 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Account: 135-60100-026-000 Travel & per diem .00 .00 Account: 135-60100-026-000 Travel & per diem Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60245-026-000 Miscellaneous Expenses 81 of 150 June 15, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 5/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: 1,104.73 ** 125.98 Monthly Total 13,230.00 Budgeted 82 of 150 12,125.27 Remaining 8 % Used glpdatb2 skrolczyk 10:08 06/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Program: Period Ending: 5/2020 JE Detail Description/Comment ACCOunt: 135-50005-030- Salaries & W 1110 05/01/2020 MUD Payroll 5/1/2020 1180 05/15/2020 MUD Payroll 5/15/2020 1223 05/29/2020 MUD Payroll 5/29/2020 Account Salaries & Wages Salaries & Wages Salaries & Wages 628,298.00 Budgeted June 15, 2020 Regular Meeting Agenda Packet Page 32 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) 209,368.01 15,807.87 225,175.88 PR 15,807.87 240,983.75 PR 15,807.87 256,791.62 PR 371,506.38 Remaining 41 % Used Account: 135-50010-030-000 Account: 135-50010-030-000 Account: 135-50016-030-000 31.77 .00 31.77 2,000.00 Budgeted 1,968.23 Remaining 2 % Used Longevit 2,207.50 .00 2,207.50 Longevity Totals: 2,208.00 Budgeted .50 Remaining 100 % Ueed Account: 135-50020-030-000 irement 1110 05/01/2020 MUD Payroll 5/1/2020 Retirement 1180 05/15/2020 MUD Payroll 5/15/2020 Retirement 1223 05/29/2020 MUD Payroll 5/29/2020 Retirement 21,091.51 1,463.81 22,555.32 PR 1,463.82 24,019.14 PR 1,463.78 25,482.92 PR Account: 135-50020-030-000 Account: 135-50026-030-000 1110 05/01/2020 MUD Payroll 5/1/2020 1180 05/15/2020 MUD Payroll 5/15/2020 Account: 135 58,554.00 Budgeted 33,071.08 Remaining 44 % Ueed Medical Insurance Medical Insurance 41,849.51 Medical Insurance 76,198.72 Remaining 39 % Used 2,318.20 Medical Insurance 124,394.00 Budgeted 1110 05/01/2020 MUD Payroll 5/1/2020 1180 05/15/2020 MUD Payroll 5/15/2020 Dental Insurance Dental Insurance Dental Insurance 83 of 150 3,172.91 45,022.42 PR 3,172.86 48,195.28 PR 174.88 2,493.08 PR 174.87 2,667.95 PR glpdatb2 skrolczyk 10:08 06/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Program: Period Ending: 5/2020 June 15, 2020 Regular Meeting Agenda Packet Page 33 JE Detail Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) Description/Comment Account: 135-50027-030-000- Dental Insurance 6,464.00 Budgeted Account: ion Insurance 1110 05/01/2020 MUD Payroll 5/1/2020 Vision Insurance 1180 05/15/2020 MUD Payroll 5/15/2020 Vision Insurance Account: 135-50028-030-000 Vision Insurance 1,035.00 Budgeted Account: 135-50029_- 1095 05/01/2020 May A/P 1122 05/01/2020 May Payroll Benefits 1215 05/21/2020 May A/P Account: 135- 1110 05/01/2020 MUD Payroll 5/1/2020 1180 05/15/2020 MUD Payroll 5/15/2020 1223 05/29/2020 MUD Payroll 5/29/2020 3,796.05 Employee Benefits Employee LTD & STD cafe 125 plan Remaining 353.03 41 Ueed 25.85 25.83 630.29 Remaining 39 % Used Life Insurance & Other Totals: 4,500.00 Budgeted 378.88 404.71 2,314.93 176.22 2,491.15 Humana Inc 151.69 2,642.84 METLIFE GROUP BENEFITS 16.00 2,658.84 BenefitMall 1,841.16 Remaining 59 % Used Social Security Taxes Social Security Taxes Social Security Taxes Social Security Taxes Account: Social Security Taxes 39,215.00 Budgeted 1110 05/01/2020 MUD Payroll 5/1/2020 1180 05/15/2020 MUD Payroll 5/15/2020 1223 05/29/2020 MUD Payroll 5/29/2020 Account: 135 Medicare Taxes Medicare Taxes Medicare Taxes Medicare Taxes Medicare Taxes 9,171.00 Budgeted Account: 135-5004 Unemployment Taxes 12,231.08 24,187.06 Remaining 38 % Used 909.98 906.78 980.10 13,141.06 14,047.84 15,027.94 PR PR 6414 AP 6417 AP 6441 AP PR PR PR 2,860.52 212.82 3,073.34 PR 212.06 3,285.40 PR 229.22 3,514.62 PR 5,656.38 Remaining 38 % Used 864.00 84 of 150 .00 864.00 glpdatb2 skrolczyk 10:08 06/10/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: 5/2020 JE Detail Beginning Balance Description/Comment Unemployment Taxes 1,440.00 Budgeted Acc410 Workman's Compensation 73 05/01/2020 Insurance/Wrk Comp Expense May Account: 135-50045-030-000 Account: 135-50060-030-000 Account: 135-50060-030-000 Account: 135-50070-030-000 Account: 135-50070-030-000 Acc Workman's Compensation 1,775.00 Budgeted Pre-emp Physicals/Testing Tota 576.00 Remaining 733.74 Totals: 936.44 Remaining Pre-emp Physicals/Testing To a e• 500.00 Budgeted 500.00 Remaining Employee Relations Employee Relations 8,000.00 Budgeted 1215 05/21/2020 May A/P 1249 05/26/2020 PCards 4/28/2020-5/26/2020 1249 05/26/2020 1249 05/26/2020 1249 05/26/2020 1249 05/26/2020 1249 05/26/2020 1249 05/26/2020 1249 05/26/2020 1249 05/26/2020 1249 05/26/2020 1309 05/31/2020 Account: 135 PCarde 4/28/2020-5/26/2020 PCards 4/28/2020-5/26/2020 PCarde 4/28/2020-5/26/2020 PCarde 4/28/2020-5/26/2020 PCards 4/28/2020-5/26/2020 PCards 4/28/2020-5/26/2020 PCards 4/28/2020-5/26/2020 PCarde 4/28/2020-5/26/2020 PCards 4/28/2020-5/26/2020 Recode M3 Annual Soft & Supprt Internet -may website Website internet internet Internet' adobe subscription Internet internet Internet bank rec software Recode 134,681.00 Budgeted 3,078.10 4,921.90 Remaining Program: Transaction Detail 60 % Ueed 47 % Ueed 0 % Used 38 % Used June 15, 2020 Regular Meeting Agenda Packet Page 34 Transaction Vendor Name Detail (SUBTOTAL) 104.82 .00 .00 838.56 .00 3,078.10 133,346.24 899.00 134,245.24 Charter Communications 10.77 134,256.01 FS *DIGITALWAVE 18.17 134,274.18 DNB*GODADDY.COM 52.37 134,326.55 ATT*BILL PAYMENT 42.37 134,368.92 ATT*SILL PAYMENT 42.37 134,411.29 ATT*BILL PAYMENT 36.78 134,448.07 ADOBE ACROPRO SUBS 42.37 134,490.44 ATT*BILL PAYMENT 42.35 134,532.79 ATT*BILL PAYMENT 42.37 134,575.16 ATT*BILL PAYMENT 595.00 135,170.16 CONWAY COMPANY CPAS (54,600.00) 80,570.16 54,110.84 Remaining 60 % Used 85 of 150 Check Source Number 6443 GL AP PC PC PC PC PC PC PC PC PC PC GL June 15, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 35 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 1 Independent Labor 1251 05/31/2020 May A/P GM search Final invoice Account: 135-55070-03 Independent Labor 135,000.00 Budgeted Account: 135-55080-030-00r Maintenance & Repairs 1191 05/18/2020 mAY a/p 75,711.88 13,098.66 88,810.54 Strategic Government Resources 6478 AP 46,189.46 Remaining 66 % Used a/c in office 1,275.00 285.00 1,560.00 BRANDON R REED Account: Maintenance & Repairs Totals: 15,000.00 Budgeted 13,440.00 Remaining 10 % Used 6442 AP Generator Maint. and Repair 531.00 .00 531.00 Account: 135-55085-030-000 Generator Maint. and Repair Totals: .00 Account: 135-55120-030-000 1215 05/21/2020 May A/P Account: 135-55120-030-000 10,000.00 Budgeted 9,469.00 Remaining Cleaning Services Janitorial service -April 5,761.72 "ing Services 10,000.00 Budgeted Account: 135-55160-030 1309 05/31/2020 Recode M3 Annual Soft & Supprt Recode 2,341.36 Remaining Account: 135- Professional Outside Servic 65,600.00 Budgeted 8,500.00 Remaining 2,500.00 5 % Used 77 % Used 87 % Used 1,896.92 7,658.64 MEMBER'S BUILDING MAINTENANCE 6458 AP 1,896.92 54,600 00 57,100.00 GL Account: 135-55205-030-000 Utility Billing Contract Account: 135-55205-030-000 Utility Billing Contract Totals: 9,000.00 Budgeted 4,820.32 Remaining 4,179.68 46 % Used .00 4,179.68 Account: 135-60005-030-000 Telephone 86 of 150 June 15, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36 10:06 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1090 05/01/2020 May A'P Answering service -May 10,173.55 1249 05/26/2020 PCards 4/28/2020-5/26/2020 phone 1249 05/26/2020 PCards 4/28/2020-5/26/2020 phone 1249 05/26/2020 PCards 4/28/2020-5/26/2020 phone 1249 05/26/2020 PCards 4/28/2020-5/26/2020 answering service 1249 05/26/2020 PCards 4/28/2020-5/26/2020 phone 1265 05/31/2020 Town Billed Invoices 1738-1741 AR 20200531-20200531 User: Account: 135-60005-030-00 Telephone 23,680.00 Budgeted 1178 05/11/2020 May A/P Communications/Mobiles Cell phones 1178 05/11/2020 May A/P Cell phones 1180 05/15/2020 MUD Payroll 5/15/2020 Communications/Mobiles 11,484.66 Remaining 52 % Used Account: 135-60010-0 Account: 135-60020-030-000 1215 05/21/2020 May A/P Account: 135-60020-030-000 Account: 135-60025-03' 1251 05/31/2020 May A/P 1265 05/31/2020 Town Billed Invoices 1738-1741 AR 20200531-20200531 User: Communications/Mobile 4,000.00 Budgeted 2,184.88 Electricity/Gas Gexa energy 3/10-4/08 Electricity 6,879.00 Budgeted water -May 2,971.44 Account: 135-50025-030-8,,, 11 Account: 135-60035-030-000 Account: 135-60035-030-000 Water 1,500.00 Budgeted Postage Postag= 30,000.00 Budgeted Remaining Remaining 571.98 10,745.53 KEYSTONE PARK SECRETARIAL 6361 AP 466.71 11,212.24 ATT*BUS PHONE PMT PC 797.51 12,009.75 ATT*BUS PHONE PMT PC 175.30 12,185.05 ATT*BILL PAYMENT PC 14.99 12,200.04 RINGCENTRAL, INC PC 175.30 12,375.34 ATT*BILL PAYMENT PC (180.00) 12,195.34 AR 1,715.86 (150.00) 1,565.86 VERIZON WIRELESS 6438 AP 99.26 1,665.12 VERIZON WIRELESS 6438 AP 150.00 1,815.12 PR 3,449.34 1,479.02 45 % Used 57 Used Totals: 249.40 Remaining 83 % Ueed 18,274.49 Remaining 11,725.51 39 458.22 47.45 (275.87) .00 Used 3,907.56 TOWN OF TROPHY CLUB 1,526.47 1,250.60 11,725.51 TROPHY CLUB MUD (WATER BILLS) 6466 AP 6480 AP AR Account: 135-60040-030-000 Service Charges & Fees 87 of 150 glpdatb2 skrolczyk 10:08 06/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 1268 05/31/2020 Pace Credit Card Fees 1268 05/31/2020 Pace Credit Card Fees Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Program: Period Ending: 5/2020 June 15, 2020 Regular Meeting Agenda Packet Page 37 JE Detail Beginning Transaction Transaction Vendor Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) 41,902.02 4,924.49 9.78 46,826.51 46,836.29 GL GL 88 of 150 Account: 135-60040-030-000 Service Charges & Fees Totals: 4,934.27 46,836.29 ** 67,000.00 Budgeted 20,163.71 Remaining 70 % Used Account: 135-60050-030-000 Bad Debt Expense .00 .00 Account: 135-60050-030-000 Bad Debt Expense Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60055-030-000 Insurance 73 05/01/2020 Insurance/Wrk Comp Expense May 45,426.87 6,998.39 52,425.26 GL Account: 135-60055-030-000 Insurance Totals: 6,998.39 52,425.26 ** 84,000.00 Budgeted 31,574.74 Remaining 62 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 125.00 .00 125.00 Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 125.00 ** 1,000.00 Budgeted 875.00 Remaining 13 % Used Account: 135-60070-030-000 Dues & Memberships 4,285.55 .00 4,285.55 Account: 135-60070-030-000 Dues & Memberships Totals: .00 4,285.55 ** 6,000.00 Budgeted 1,714.45 Remaining 71 % Used Account: 135-60075-030-000 Meetings 115.09 .00 115.09 Account: 135-60075-030-000 Meetings Totals: .00 115.09 ** 400.00 Budgeted 284.91 Remaining 29 % Used Account: 135-60079-030-000 Public Education 88 of 150 June 15, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38 10:06 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/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-60079-030-0 Public Education 6,000.00 Budgeted Account: 135-60080-030-000 Schools & Training Account: 135-60080-030-000 Schools & Training 6,850.00 Budgeted Account: 135-60100-030- Travel & per di 1249 05/26/2020 PCards 4/28/2020-5/26/2020 GM interview hotel stay 3,971.51 .00 3,971.51 Totals: 2,028.49 Remaining 66 % Used 5,397.79 Remaining vel & per diem 3,545.00 Budgeted Account Physicals/Testing Account Physicals/Testing 200.00 Budgeted Account: 135-60115-030-000 Elections Account: 135-60115-030-000 els: 2,446.39 Remaining Elections Totals: .00 Budgeted Account: 135-60125-030-000 Advertising Account: 135-60125-030-000 Advertising 2,500.00 Budgeted Account: 135-60235-030-000 1,452.21 1,020.64 .00 21 % Used 77.97 1,452.21 1,098.61 HAMPTON INN HOTELS PC 7 31 % Used .00 .00 138.04 .00 138.04 Totals: 200.00 Remaining 0 % Used (138.04) Remaining 0 % Ueed 1,772.20 .00 1,772.20 727.80 Remaining 71 % Used 168.00 .00 168.00 89 of 150 June 15, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/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-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,120.00 Remaining 13 % Ueed Miscellaneous Expenses 500.00 Budgeted General Manager Contingency General Manager Contingency Totals: 17,000.00 Budgeted 17,000.00 Remaining Furniture/Equipment < $5000 500.00 Remaining 0 % Ueed O % Used .00 .00 .00 .00 .00 ** .00 .00 Furniture/Equipment c $50 .00 ** 2,500.00 Budgeted 2,500.00 Remaining Uniforms 2,050.00 Budgeted Account: -0 Hardware 1249 05/26/2020 PCards 4/28/2020-5/26/2020 computer monitor 1251 05/31/2020 May A/P GM monitors Account: 135-65055-030-000 O % Used .00 .00 .00 ** 2,050.00 Remaining 0 % Used 3,235.24 199.99 3,435.23 AMZN MRTP US*M74R02PZ0 PC 480.98 3,916.21 M3 Networks 6475 AP Hardwar11111111111M ,916.21 ** 26,485.00 Budgeted Account: 135-65085-03 1215 05/21/2020 May A/P office supplies 22,568.79 Remaining 15 % Used 2,431.85 55.36 2,487.21 OFFICE DEPOT, INC 90 of 150 6460 AP June 15, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 40 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1249 05/26/2020 PCards 4/28/2020-5/26/2020 ink cartridges Account: 135-65085-030-0 Account: 135-65090-030-000 2,431.85 448.78 2,935.99 AMAZON.COM*MC63U99W1 PC Office Supplies Total 2,935.99 ** 6,000.00 Budgeted 3,064.01 Remaining 49 % Used Printer Supplies & Maintenance .00 .00 Account: 135-65090-030-000 Printer Supplies & Maintenance Tot .00 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-65095-030-000 Maintenance Supplies Account: 135-65095-030-000 Maintenance Supplies 4,000.00 Budgeted Account: 135-65105-030-000 Pri. 2,848.53 1,151.47 Remaining 71 % Used .00 2,848.53 .00 .00 Account: 135-65105-030-000 Tota 2,500.00 Remaining 0 % Used Account: 135-69005-030-000 1215 05/21/2020 May A/P 1266 05/31/2020 May A/P 1191 05/18/2020 mAY a/p 1251 05/31/2020 May A/P 2,500.00 Budgeted Capital Outlays TCMUD boundary TCMUD boundary Capital Outlaill Totals: 195,000.00 Budgeted 27,009.75 1,170.62 166,552.16 Remaining 15 % Used Copier Lease Installments copier lease -may copies 28,180.37 Halff Associates, INC 6447 AP 267.47 28,447.84 Halff Associates, INC 28,447.84 ** 1,734.10 165.00 1,899.10 TIAA COMMERCIAL FINANCE 13.50 1,912.60 KYOCERA DOCUMENT SOLUTIONS Account: 135-69170-030-00 ase Installments 4,000.00 Budgeted 2,087.40 Remaining 48 % Used 91 of 150 6509 AP 6465 AP 6473 AP June 15, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department 30 Totals: 785,516.89 ** 96,729.59 Monthly Total 1,776,712.00 Budgeted 991,195.11 Remaining 44 % Used 92 of 150 1215 05/21/2020 May A/P Ac legal 85,585.39 Legal 135,000.00 Budgeted Account: 135-55055-039-000 Auditing Account: 135-55055-039-000 Auditing 33,800.00 Budgeted Account: 135-55060-039-000 Appraisal Account: 135-55060-039-000 Appraisal 11,761.00 Budgeted Account: 135-55065-039-000 Tax Admin Fees Account: 135-55065-039-000 Tax Admin Fees 4,000.00 Budgeted Department 39 Totals: Fund 135 Totals: 4,842.50 Monthly Total (54,840.64) Monthly Total 44,572.11 Remaining 27,713.27 6,086.73 Remaining 7,422.04 4,338.96 Remaining 244.00 3,756.00 Remaining glpdatb2 skrolczyk 10:08 06/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description June 15, 2020 Regular Meeting Agenda Packet Trophy Club MUD No.1 Page 42 Detailed Accounting Trial Balance Department: 39 Non Departmental Program: Period Ending: 5/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment Account: 135-55045-039- Legal 4,842.50 90,427.89 McLean & Howard, L.L.P. 67 % Used .00 27,713.27 82 % Used .00 7,422.04 63 % Used 94 Used .00 3,756.00 129,319.20 ** 184,561.00 Budgeted 55,241.80 Remaining 70 t Used (103,999.22) (6,224.00) Budgeted 97,775.22 Remaining ########## 93 of 150 6457 AP glpdatb2 skrolczyk 10:08 06/10/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 Period Ending: 5/2020 Beginning Balance June 15, 2020 Regular Meeting Agenda Packet Page 43 Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) Check Source Number Department Totals: Fund 137 Totals: .00 Monthly Total .00 Monthly Total .00 Budgeted .00 Budgeted 94 of 150 (286,420.00) ** 286,420.00 Remaining 0 % Used (286,420.00) 286,420.00 Remaining 0 % Used Account: 137-49145-000-000"IIII Intergov Transfer -General Fund (205,000.00) .00 (205,000.00) Account: 137-49145-000-000 Intergov Transfer -General Fund Totals: .00 (205,000.00) ** .00 Budgeted 205,000.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer -Fire Dept (81,420.00) .00 (81,420.00) Account: 137-49146-000-000 Intergov Transfer -Fire Dept Totals: ; .00 (81,420.00) ** .00 Budgeted 81,420.00 Remaining 0 % Used Department Totals: Fund 137 Totals: .00 Monthly Total .00 Monthly Total .00 Budgeted .00 Budgeted 94 of 150 (286,420.00) ** 286,420.00 Remaining 0 % Used (286,420.00) 286,420.00 Remaining 0 % Used June 15, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - WWTP TAX BOND CONST BALANCE SHEET MAY 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 517 TAX BOND CONSTRUCTION 504,533 TOTAL ASSETS 504,533 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 685,476 TOTAL LIABILITIES 685,476 FUND BALANCE ASSIGNED FUND BALANCE (118,410) NET REVENUES / EXPENDITURES (62,534) TOTAL FUND BALANCE (180,944) TOTAL LIABILITIES AND FUND BALANCE 504,533 95 of 150 June 15, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 5/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1 517-49011-000-000 Interest Income 118.15- 4,812.81- 4,812.81 Page 14 Subtotal: 118.15- 4,812.81- 4,812.81 Program number: 118.15- 4,812.81- 4,812.81 Department number: Revenues 118.15- 4,812.81- 4,812.81 Revenues Subtotal 118.15- 4,812.81- 4,812.81 96 of 150 glbase_tbam skrolczyk 10:08 06/10/20 Fund: 517 2014 MUD 1 Tax Bond Const WWTP Account 1 517-69005-020-000 Description Capital Outlays Trophy Club MUD No.1 Budget Summary with Amendment Department: 20 Wastewater Period Ending: 5/2020 Adopted Amended Total Current Budget Budget Encumb. Month 15,077.50 June 15, 2020 Regular Meeting Agenda Packet Program: YTD Total 67,346.41 % of Remaining Budget Budget 67,346.41 - Page 15 97 of 150 Subtotal: 15,077.50 67,346.41 67,346.41 - Program number: 15,077.50 67,346.41 67,346.41 - Department number: Wastewater 7. 15,077.50 67,346.41 67,346.41 - Expenditures Subtotal 15,077.50 67,346.41 67,346.41 - Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 14,959.35 62,533.60 62,533.60- 97 of 150 glpdatb2 skrolczyk 10:08 06/10/20 Fund: 517 2014 MUD 1 Tax Bond Const WWTP JE JE JE Number Date Description Account: 517-49011-000-000 1269 05/31/2020 Bank Interest- May Account: 517-49011-000-000 June 15, 2020 Regular Meeting Agenda Packet Trophy Club MUD No.1 Page 44 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 5/2020 JE Detail Beginning Transaction Transaction Vendor Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) Interest Income Interest Income Total= .00 Budgeted 4,812.81 Remaining (4,694.66) (118.15) 0 % Used (4,812.81) GL Department Totals: (4,812.81) ** (118.15) Monthly Total .00 Budgeted 98 of 150 4,812.81 Remaining 0 % Used glpdatb2 skrolczyk 10:08 06/10/20 Fund: 517 2014 MUD 1 Tax Bond Const WWTP JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Program: Period Ending: 5/2020 Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment Account: 517-69005-020- Capital Outl 1084 05/01/2020 Capital Asset Fund Corrections Foam System- Recode 135 to 517 1215 05/21/2020 May A/P Crane review engineering 1215 05/21/2020 May A/P WWTP legal Department 20 Totals: apital Outlays .00 Budgeted June 15, 2020 Regular Meeting Agenda Packet Page 45 52,268.91 Totals: (67,346.41) Remaining 0 % Used 15,077.50 Monthly Total .00 Budgeted 9,525.00 4,065.00 1,487.50 61,793.91 65,858.91 Wise, Janney, Eletner Assoc 67,346.41 WHITAKER CHALK SWINDLE 67,346.41 •• (67,346.41) Remaining 0 % Used Fund 517 Totals: 62,533.60 14,959.35 Monthly Total .00 Budgeted 99 of 150 (62,533.60) Remaining 0 % Used Check Source Number GL 6469 AP 6468 AP June 15, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET MAY 2020 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 5111, TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 784,940 TOTAL ASSETS 784,940 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 100 of 150 81,691 81,691 698,648 4,602 703,249 784,940 June 15, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const -SWIFT Department: Revenues Program: Period Ending: 5/2020 Account Description Adopted AmendedTotal Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 519-49011-000-000 Interest Income 6.45- 4,601.70- 4,601.70 Subtotal: 6.45- 4,601.70- 4,601.70 Program number: 6.45- 4,601.70- 4,601.70 Department number: Revue 6.45- 4,601.70- 4,601.70 Revenues Subtotal 6.45- 4,601.70- 4,601.70 Fund number: 519 2016 Rev Bond Const -SWIFT 6.45- 4,601.70- 4,601.70 101 of 150 Page 16 glpdatb2 skrolczyk 10:06 06/10/20 Fund: 519 2016 Rev Bond Const -SWIFT JE JE JE Number Date Description Account: 519-49011-000-000 1269 05/31/2020 Bank Interest- May Account: 519-49011-000-000 June 15, 2020 Regular Meeting Agenda Packet Trophy Club MUD No.1 Page 46 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 5/2020 JE Detail Beginning Transaction Transaction Vendor Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) Interest Income Interest Income Totals: .00 Budgeted (4,595.25) (6.45) 4,601.70 Remaining 0 % Used (6.45) (4,601.70) GL ) ** Department Totals: (4,601.70) ** (6.45) Monthly Total .00 Budgeted 4,601.70 Remaining 0 % Used Fund 519 Totals: (4,601.70) (6.45) Monthly Total .00 Budgeted 102 of 150 4,601.70 Remaining 0 % Used June 15, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET MAY 2020 Li ip TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND CASH IN BANK 418,569 INVESTMENTS 3,892,394 ACCOUNTS RECEIVABLE TOTAL ASSETS 4,310,963 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 2,658 TOTAL LIABILITIES 2,658 FUND BALANCE ASSIGNED FUND BALANCE 4,454,290 NET REVENUES / EXPENDITURES (145,985) TOTAL FUND BALANCE 4,308,305 TOTAL LIABILITIES AND FUND BALANCE 4,310,963 103 of 150 June 15, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 Page 17 10:08 06/10/20 Budget Summary with Amendment Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 5/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1 520-49011-000-000 Interest Income 132.92- 27,579.97- 27,579.97 Subtotal: 132.92- 27,579.97- 27,579.97 Program number: 132.92- 27,579.97- 27,579.97 Department number: 132.92- 27,579.97- 27,579.97 Revenues Subtotal 132.92- 27,579.97- 27,579.97 104 of 150 glbase_tbam skrolczyk 10:08 06/10/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: 5/2020 Adopted Amended Total Current Budget Budget Encumb. Month 28,983.97 June 15, 2020 Regular Meeting Agenda Packet Program: YTD Total 173,564.78 % of Remaining Budget Budget 173,564.78 - Page 18 105 of 150 Subtotal: 28,983.97 173,564.78 173,564.78 - Program number: 28,983.97 173,564.78 173,564.78 - Department number: Water Department 7" 28,983.97 173,564.78 173,564.78 - Expenditures Subtotal 28,983.97 173,564.78 173,564.78 - Fund number: 520 Revenue Bond 16" Waterline Ell 28,851.05 145,984.81 145,984.81- 105 of 150 glpdatb2 ekrolczyk Trophy Club MUD No.1 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 5/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) June 15, 2020 Regular Meeting Agenda Packet Page 47 Account: 520-49011-000-0 1269 05/31/2020 Bank Interest- May 1269 05/31/2020 Bank xntereat- May Interest Income (27,447.05) (100.92) (27,547.97) GL (32.00) (27,579.97) GL Account: 520-490 Interest Income Totals: .00 Budgeted 27,579.97 Remaining 0 % Used Department Totals: (27,579.97) ** (132.92) Monthly Total .00 Budgeted 106 of 150 27,579.97 Remaining 0 % Used glpdatb2 skrolczyk 10:08 06/10/20 Fund: 520 Revenue Bond 16" Waterline JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Department Program: Period Ending: 5/2020 JE Detail Description/Comment Account: 520-69005-0 - Capital Outlays 1084 05/01/2020 Capital Asset Fund Corrections Halff Nov Inv# 30284 coded 135 1084 05/01/2020 Capital Asset Fund Corrections J Walker Jan Inv# 1696113 F135 1215 05/21/2020 May A/P 16" water line acquistion 1215 05/21/2020 May A/P Easement Acquistition 1266 05/31/2020 May A/P easement Account: 520-69005-010-000 Department 10 Totals: Fund 520 Totals: June 15, 2020 Regular Meeting Agenda Packet Page 48 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) 144,580.81 3,055.78 147,636.59 GL 7,452.00 155,088.59 GL 10,690.00 165,778.59 Halff Associates, INC 6447 AP 5,128.65 170,907.24 Jackson Walker LLP 6452 AP 2,657.54 173,564.78 Halff Associates, INC 6509 AP Capital Outlays Tn� .00 Budgeted (173,564.78) Remaining 0 % Used 28,983.97 171 173,564.78 ** 28,983.97 Monthly Total .00 Budgeted (173,564.78) Remaining 0 % Used 145,984.81 28,851.05 Monthly Total .00 Budgeted (145,984.81) Remaining 0 % Used 107 of 150 June 15, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET MAY 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE MI TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 893,308 TOTAL ASSETS 893,308 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 108 of 150 803,457 89,851 893,308 893,308 June 15, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 Page 19 10:08 06/10/20 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 5/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49011-000-000 528-49142-000-000 528-49143-000-000 Interest Income Interfund transfer in -Water Interfund transfer in -WW 11,000.00- 307,049.00- 200,417.00- 11,000.00- 307,049.00- 200,417.00- 201.50- 4,600.00- 5,750.00- Subtotal: m 518,466.00- 518,466.00- 10,551.50 - Program number: 1 518,466.00- 518,466.00- 10,551.50 - Department number: 518,466.00- 518,466.00- 10,551.50 - Revenues Subtotal 518,466.00- 518,466.00- 10,551.50 - Fund number: 528 2015 Revenue Bond Reserve Fund 518,466.00- 518,466.00- 10,551.50- 109 of 150 7,051.03- 36,800.00- 46,000.00- 64.100 11.985 22.952 17.330 17.330 17.330 17.330 3,948.97- 270,249.00- 154,417.00- 428,614.97- 428,614.97- 428,614.97- 428,614.97- 428,614.97- glpdatb2 skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 5/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) June 15, 2020 Regular Meeting Agenda Packet Page 49 Account: 528-49011-000-000 1269 05/31/2020 Bank Interest- May Interest Income Account: 528-49011-000-000 come 1 (11,000.00) Budgeted (3,948.97) Remaining Account: 528-49142-000-000 7 1292 05/31/2020 TexPool Transfers May (6,849.53) (201.50) (7,051.03) GL (201.50) 64 % Used TexPool O&M to Rev Bond Resevr (32,200.00) (4,600.00) (36,800.00) GL (307,049.00) Budgeted (270,249.00) Remaining 12 % Used Interfund transfer in -WW 1292 05/31/2020 TexPool Transfers May TexPool O&M to Rev Bond Resevr Account: 528-49143-11Interfund transfer in - (200,417.00) Budgeted (40,250.00) (154,417.00) Remaining (5,750.00) 23 % Used (46,000.00) Department Totals: (89,851.03) ** (10,551.50) Monthly Total (518,466.00) Budgeted (428,614.97) Remaining 17 % Used Fund 528 Totals: (89,851.03) (10,551.50) Monthly Total (518,466.00) Budgeted (428,614.97) Remaining 17 % Used 110 of 150 GL June 15, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET MAY 2020 ASSETS CASH IN BANK INVESTMENTS PREPAID EXPENSES ADVALOREM PROPERTY TAXES RECEIVABLE ACCOUNTS RECEIVABLE -OTHER TOTAL ASSETS LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 111 of 150 TROPHY CLUB MUNICIPAL UTILITY DISTRICT INTEREST & SINKING- 533 947,761 21,518 969,279 21,518 21,518 82,954 864,807 947,761 969,279 June 15, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 5/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 Property Taxes Property Taxes/Delinquent Property Taxes/P & I 682,441.00- 1,000.00- 2,000.00- 682,441.00- 1,000.00- 2,000.00- 3,367.17- 64.06 158.35- 681,504.50- 1,789.72- 1,823.78- 99.863 178.972 91.189 936.50- 789.72 176.22 - Page 20 Subtotal: Mr - 3,461.46- 99.953 323.00- 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- 218,004.00- 114,563.00- 5,000.00- 218,004.00- 114,563.00- 213.71- 10,414.81- 3,745.64- 218,004.00- 83,318.48- 74.913 100.000 72.727 1,254.36- 31,244.52- 1 Subtotal: 337,567.00- 337,567.00- 10,628.52- 305,068.12- 90.373 32,498.88 - Program number: 1,023,008.00- 1,023,008.00- 14,089.98- 990,186.12- 96.792 32,821.88 - Department number: Revenues 1,023,008.00- 1,023,008.00- 14,089.98- 990,186.12- 96.792 32,821.88 - Revenues Subtotal 1,023,008.00- 1,023,008.00- 14,089.98- 990,186.12- 96.792 32,821.88- 112 of 150 June 15, 2020 Regular Meeting Agenda Packet glbase_tbam skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 5/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1 1 533-70005-051-000 1 533-70025-051-000 1 533-70035-051-000 Payin$g Agent Fee Bond 2nterest Expense -Tax Bond Principal Payment -Tax 2,150.00 247,858.00 765,000.00 2,150.00 247,858.00 765,000.00 1,450.00 123,928.75 67.442 50.000 700.00 123,929.25 765,000.00 Page 21 Subtotal: 1,015,008.00 1,015,008.00 125,378.75 12.352 889,11r.25 Program number: 1,015,008.00 1,015,008.00 125,378.75 12.352 889,629.25 Department number: Administration 1,015,008.00 1,015,008.00 125,378.75 12.352 889,629.25 Expenditures Subtotal 1,015,008.00 1,015,008.00 125,378.75 12.352 889,629.25 p Fund number: 533 MUD 1 I&S Consolidated 8,000.00- 8,000.00- 14,089.98- 864,807.37- ############### 856,807.37 113 of 150 glpdatb2 skrolczyk 10:08 06/10/20 Fund: 533 MUD 1 I&S Consolidated JE JE JE Number Date Description Accoyyyyta 533-40000-000- 1272 05/01/2020 Property Taxes 1273 05/04/2020 Property Taxes 1274 05/05/2020 Property Taxes 1275 05/06/2020 property taxes 1277 05/07/2020 property taxes 1278 05/08/2020 property taxes 1279 05/11/2020 Property Taxes 1280 05/12/2020 Property Taxes 1281 05/14/2020 property taxes 1282 05/15/2020 property taxes 1283 05/18/2020 property taxes 1293 05/19/2020 property taxes 1284 05/20/2020 property taxes 1285 05/21/2020 property taxes 1286 05/22/2020 property taxes 1287 05/26/2020 property taxes 1288 05/27/2020 property taxes 1289 05/28/2020 property taxes 1290 05/29/2020 property taxes Account: 533-40000-000-000 Account: 533-40002-000-000- 1275 05/06/2020 property taxes 1280 05/12/2020 Property Taxes 1284 05/20/2020 property taxes 1285 05/21/2020 property taxes 1287 05/26/2020 property taxes 1288 05/27/2020 property taxes Account: 533-40002-000-000 June 15, 2020 Regular Meeting Agenda Packet Page 50 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 5/2020 JE Detail Beginning Transaction Transaction Vendor Name Description/Comment Balance Detail Detail (SUBTOTAL) Property Taxes Property Taxes Totals: (682,441.00) Budgeted Property Taxes/Delinquent (678,137.33) (41.52) (678,178.85) (1.00) (678,179.85) (4.54) (678,184.39) (187.49) (678,371.88) (607.86) (678,979.74) (24.72) (679,004.46) (29.91) (679,034.37) 127.65 (678,906.72) (85.78) (678,992.50) (412.44) (679,404.94) (148.47) (679,553.41) (102.48) (679,655.89) (248.76) (679,904.65) (335.33) (680,239.98) (236.54) (680,476.52) (114.31) (680,590.83) (376.06) (680,966.89) (234.31) (681,201.20) (303.30) (681,504.50) (936.50) Remaining 100 % Used IIIIII1Eperty Taxes/Delinquent Totals: (1,000.00) Budgeted 789.72 Remaining Account: 533-40015-000-0 Property Taxes/P & I 1272 05/01/2020 Property Taxes 1273 05/04/2020 Property Taxes 1274 05/05/2020 Property Taxes 1275 05/06/2020 property taxes 1277 05/07/2020 property taxes (1,853.78) 179 % Used (1,665.43) 114 of 150 (8.70) (1,862.48) 119.90 (1,742.58) (13.26) (1,755.84) (20.20) (1,776.04) (6.03) (1,782.07) (7.65) (1,789.72) (.25) (1,665.68) (.11) (1,665.79) (.53) (1,666.32) (2.43) (1,668.75) (66.91) (1,735.66) Check Source Number GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL glpdatb2 skrolczyk 10:08 06/10/20 Fund: 533 MUD 1 I&S Consolidated JE JE JE Number Date Description 1279 05/11/2020 Property Taxes 1280 05/12/2020 Property Taxes 1282 05/15/2020 property taxes 1283 05/18/2020 property taxes 1293 05/19/2020 property taxes 1284 05/20/2020 property taxes 1285 05/21/2020 property taxes 1286 05/22/2020 property taxes 1287 05/26/2020 property taxes 1288 05/27/2020 property taxes 1289 05/28/2020 property taxes 1290 05/29/2020 property taxes June 15, 2020 Regular Meeting Agenda Packet Trophy Club MUD No.1 Page 51 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 5/2020 JE Detail Beginning Transaction Transaction Vendor Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-40015-000-000 Property Taxes/P & I (2,000.00) Budgeted Account: 533-49011-000-000 Interest Income 1269 05/31/2020 Bank Interest- May (1,665.43) (3.89) (1,739.55) GL (.53) (1,740.08) GL (36.96) (1,777.04) GL (2.86) (1,779.90) GL (.53) (1,780.43) GL (17.85) (1,798.28) GL .14 (1,798.14) GL (13.99) (1,812.13) GL (1.50) (1,813.63) GL (2.21) (1,815.84) GL (.16) (1,816.00) GL (7.78) (1,823.78) GL (176.22) Remaining 91 % Used (3,531.93) (213.71) (1,823.78) ** (3,745.64) GL Account: 533-49011-000-000 Interest Income (213.71) Account: 533-49015-000-000 (5,000.00) Budgeted (1,254.36) Remaining 75 % Used ental Incom IL Account: 533-49015-000-000 Lease/Rental Income (218,004.00) Budgeted Account: (218,004.00) .00 Remaining 100 % Used Interfund Trans In -PID Surchg 1292 05/31/2020 TexPool Transfers May TexPool O&M to I&S- PID Debt (72,903.67) Account: 533-49141-000-000 Interfund Trans In -PID Surchg Totals: 1 (114,563.00) Budgeted (31,244.52) Remaining .00 (218,004.00) (10,414.81) (83,318.48) 73 % Used Department Totals: (990,186.12) ** (14,089.98) Monthly Total (1,023,008.00) Budgeted (32,821.88) Remaining 97 % Used 115 of 150 GL June 15, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 52 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 5/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-70005-051-000 Paying Agent Fee 1,450.00 .00 1,450.00 Account: 533-70005-051-000 Paying Agent Fee Totals: .00 1,450.00 ** 2,150.00 Budgeted 700.00 Remaining 67 % Used Account: 533-70025-051-000 Bond Interest Expense -Tax 123,928.75 .00 123,928.75 Account: 533-70025-051-000 Bond Interest Expense -Tax Totals: .00 123,928.75 ** 247,858.00 Budgeted 123,929.25 Remaining 50 % Used Account: 533-70035-051-000 Bond Principal Payment -Tax .00 .00 Account: 533-70035-051-000 Bond Principal Payment -Tax Totals: .00 .00 ** 765,000.00 Budgeted 765,000.00 Remaining 0 % Used Department 51 Totals: 125,378.75 ** .00 Monthly Total 1,015,008.00 Budgeted 889,629.25 Remaining 12 % Used Fund 533 Totals: (864,807.37) (14,089.98) Monthly Total (8,000.00) Budgeted 856,807.37 Remaining ########## 116 of 150 June 15, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET MAY 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 356,844 TOTAL ASSETS 356,844 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 117 of 150 24,518 332,326 356,844 356,844 June 15, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 5/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- 2,500.00- 534-49143-000-000 Interfund Transfer In -WW Sales 598,638.00- 598,638.00- Subtot 6060- 601 438.00 - Program number: 6011111100 - Department number: Revenues 6011'36.00 - Revenues Subtotal 601,138.00- 601,138.00- 601,138.00- 601,138.00- 118 of 150 69.98- 1,272.98- 50.919 54,421.63- 435,372.44- 72.727 54,491.61- 431E85.42- -636 54,491.61- 54,491.61- 54,491.61- 436,645.42- 436,645.42- 436,645.42- 636 1,227.02- 163,265.56- 164,492.58- 164,492.58- 164,492.58- 164,492.58 - Page 22 June 15, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 5/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-70005-051-000 Rev Bond Paying Agent Fee 400.00 400.00 200.00 50.000 200.00 534-70040-051-000 Revenue Bond Interest Expense 208,238.00 208,238.00 104,118.75 50.000 104,119.25 534-70045-051-000 Revenue Bond Principal Expense 390,000.00 390,000.00 390,000.00 Subtotal: , 598,638.00 598,638.00 17.426 494,319.25 Program number: III 598,638.00 598,638.00 10 17.426 494,319.25 Department number: Administration III 598,638.00 598,638.00 10L8.75 17.426 494,31 Expenditures Subtotal ill 598,638.00 598,638.00 1imL8.75 17.426 494,319.25 Fund number: 534 2015 Revenue Bond I&S M2,500.00- 2,500.00- 54,491.61- 6.67- ############### 329,826.67 119 of 150 Page 23 glpdatb2 skrolczyk 10:08 06/10/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: 5/2020 JE Detail Description/Comment June 15, 2020 Regular Meeting Agenda Packet Page 53 Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Check Source Number Department Totals: (54,491.61) Monthly Total (436,645.42) ** (601,138.00) Budgeted (164,492.58) Remaining 73 % Used 120 of 150 Account: 534-49011-000-000 Interest Income 1269 05/31/2020 Bank Interest- May (1,203.00) (69.98) (1,272.98) GL Account: 534-49011-000-000 Interest Income Totals: (69.98) (1,272.98) ** (2,500.00) Budgeted (1,227.02) Remaining 51 % Used Account: 534-49143-000-000 Interfund Transfer In -WW Sales .11 1292 05/31/2020 TexPool Transfers May TexPool O&M to Rev Bd WWTP I&S (380,950.81) (54,421.63) (435,372.44) GL Account: 534-49143-000-000 Interfund Transfer In -WW Sales Totals: W. (54,421.63) (435,372.44) ** (598,638.00) Budgeted (163,265.56) Remaining 73 % Used Department Totals: (54,491.61) Monthly Total (436,645.42) ** (601,138.00) Budgeted (164,492.58) Remaining 73 % Used 120 of 150 June 15, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 54 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond IES Department: 51 Administration Program: Period Ending: 5/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 400.00 Budgeted 200.00 Remaining Account: 534-70040-051-000 Revenue Bond Interest Expense Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: 208,238.00 Budgeted 104,119.25 Remaining 200.00 104,118.75 50 % Used .00 200.00 .00 104,118.75 50 % Used Account: 534-70045-051-000 Revenue Bond Principal Expense A,t: 534-70045-051-000 Revenue Bond Principal Expense Totals: 390,000.00 Budgeted 390,000.00 Remaining .00 .00 0 % Used Department 51 Totals: 104,318.75 ** .00 Monthly Total 598,638.00 Budgeted 494,319.25 Remaining 17 % Used Fund 534 Totals: (332,326.67) (54,491.61) Monthly Total (2,500.00) Budgeted 329,826.67 Remaining ########## 121 of 150 June 15, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET MAY 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE PIA TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 175,649 TOTAL ASSETS 175,649 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 122 of 150 4,967 170,682 175,649 175,649 June 15, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 10:08 06/10/20 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 5/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- 1,000.00- 34.80- 562.78- 56.278 437.22- 535-49142-000-000 Interfund Tran In -Water Sales 275,525.00- 275,525.00- 25,047.72- 200,381.76- 72.727 75,143.24 - Sub tot 5,143.24-Subtot 25.00- - 0,944.54- 75,580.46 - Program number: 0- 276125.00- = 25,082.52- 200,944.54- , 72.668 75,580.46 - Department number: Revenues 0- 276,525.00- II 25,082.52- 200,944.54- , 72.668 75,580.46 - Revenues Subtotal 276,525.00- 276,525.00- II 25,082.52- 200,944.54- , 72.668 75,580.46- 123 of 150 Page 24 glbase_tbam skrolczyk 10:08 06/10/20 Fund: 535 2016 Rev Bond I&S-SWIFT Account Description 535-70005-051-000 535-70040-051-000 1 535-70045-051-000 Rev Bond Paying,Agent Fee Revenue Bond Interest Expense Revenue Bond Principal Expense June 15, 2020 Regular Meeting Agenda Packet Trophy Club MUD No.1 Budget Summary with Amendment Department: 51 Administration Program: Period Ending: 5/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 800.00 386,811.00 215,000.00 800.00 386,811.00 215,000.00 200.00 30,062.50 25.000 7.772 600.00 356,748.50 215,000.00 Page 25 Subtotal: -ImmommlOOPk11.00 60211.00 30,262.50 5.022 572,348.50 Program number: 602,611.00 602,611.00 30,262.50 5.022 572,348.50 Department number: Administration 602,611.00 602,611.00 30,262.50 5.022 572,348.50 Expenditures Subtotal 602,611.00 602,611.00 30,262.50 5.022 572,348.50 Fund number: 535 2016 Rev Bond I&S-SWIFT 326,086.00 326,086.00 25,082.52- 170,682.04- -52.343 496,768.04 124 of 150 glpdatb2 skrolczyk 10:08 06/10/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: 5/2020 JE Detail Description/Comment June 15, 2020 Regular Meeting Agenda Packet Page 55 Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Check Source Number Department Totals: (25,082.52) Monthly Total (200,944.54) ** (276,525.00) Budgeted (75,580.46) Remaining 73 % Used 125 of 150 Account: 535-49011-000-000 Interest Income 1269 05/31/2020 Bank Interest- May (527.98) (34.80) (562.78) GL Account: 535-49011-000-000 Interest Income Totals: (34.80) (562.78) ** (1,000.00) Budgeted (437.22) Remaining 56 9 Used Account: 535-49142-000-000 Interfund Tran In -Water Sales 1292 05/31/2020 TexPool Transfers May TexPool O&M to 16Swift Rev I&S (175,334.04) (25,047.72) (200,381.76) GL Account: 535-49142-000-000 Interfund Tran In -Water Sales Totals: (25,047.72) (200,381.76) ** (275,525.00) Budgeted (75,143.24) Remaining 73 % Used Department Totals: (25,082.52) Monthly Total (200,944.54) ** (276,525.00) Budgeted (75,580.46) Remaining 73 % Used 125 of 150 June 15, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 56 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 5/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 Account: 535-70005-051-000 11 Rev Bond Paying Agent Fee 200.00 Rev Bond Paying Agent Fee 800.00 Budgeted 600.00 Remaining Account: 535-70040-051-000 Revenue Bond Interest Expense Account: 535-70040-051-000 Account: 535-70045-051-000 30,062.50 Revenue Bond Interest Expense Totals: 386,811.00 Budgeted 356,748.50 Remaining 25 % Used .00 200.00 .00 30,062.50 8 % Used Revenue Bond Principal Expense Revenue Bond Principal Expense Totals: 215,000.00 Budgeted 215,000.00 Remaining .00 .00 0 % Used Department 51 Totals: 30,262.50 ** .00 Monthly Total 602,611.00 Budgeted 572,348.50 Remaining 5 % Used Fund 535 Totals: (170,682.04) (25,082.52) Monthly Total 326,086.00 Budgeted 496,768.04 Remaining -52 % Used 126 of 150 June 15, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET MAY 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE ILIP TROPHY CLUB 1 MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 23,295 TOTAL ASSETS 23,295 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES 23,295 TOTAL FUND BALANCE 23,295 TOTAL LIABILITIES AND FUND BALANCE 23,295 127 of 150 glbase_tbam skrolczyk 10:08 06/10/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 June 15, 2020 Regular Meeting Agenda Packet Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Program: Period Ending: 5/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 5.34- Program number: 5.34- Department number: Revenues Revenues Subtotal 128 of 150 5.34- 5.34- 448.86- 183,168.16- 54,712.56- 238,329.58- 238,329.58- 238,329.58- 238,329.58 - 448.86 183,168.16 54,712.56 238,329.58 238,329.58 238,329.58 238,329.58 Page 26 glbase_tbam skrolczyk 10:08 06/10/20 Fund: 536 2019 Rev Bond I&S- W&WW System Account 1 1 536-70005-051-000 1 536-70040-051-000 Description Rev Bond Paying Agent Fee Revenue Bond Interest Expense Trophy Club MUD No.1 Budget Summary with Amendment Department: 51 Administration Period Ending: 5/2020 Program: June 15, 2020 Regular Meeting Agenda Packet Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 142.08 214,892.43 142.08- 214,892.43 - Page 27 ******* End of Report ********* 129 of 150 Subtotal: 215,034.51 215,034.51 - Program number: 215,034.51 215,034.51 - Department number: Administration 215,034.51 215,034.51 - Expenditures Subtotal 215,034.51 215,034.51 - Fund number: 536 2019 Rev Bond I&S- W&WW System 5.34- 23,295.07- 23,295.07 ******* End of Report ********* 129 of 150 glpdatb2 skrolczyk 10:08 06/10/20 Fund: 536 2019 Rev Bond I&S- W&WW System JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 5/2020 JE Detail Description/Comment June 15, 2020 Regular Meeting Agenda Packet Page 57 Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Check Source Number Department Totals: (5.34) Monthly Total .00 Budgeted 130 of 150 (238,329.58) ** 238,329.58 Remaining 0 % Used Account: 536-49011-000-000 Interest Income 1269 05/31/2020 Bank Interest- May (443.52) (5.34) (448.86) GL Account: 536-49011-000-000 Interest Income Totals: (5.34) (448.86) ** .00 Budgeted 448.86 Remaining 0 % Used Account: 536-49142-000-000 Interfund Tran In -Water Sales (183,168.16) .00 (183,168.16) Account: 536-49142-000-000 Interfund Tran In -Water Sales Totals: ; .00 (183,168.16) ** .00 Budgeted 183,168.16 Remaining 0 % Used Account: 536-49143-000-000 Interfund Transfer In -WW Sales (54,712.56) .00 (54,712.56) Account: 536-49143-000-000 Interfund Transfer In -WW Sales Totals: .00 (54,712.56) ** .00 Budgeted 54,712.56 Remaining 0 % Used Department Totals: (5.34) Monthly Total .00 Budgeted 130 of 150 (238,329.58) ** 238,329.58 Remaining 0 % Used June 15, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 58 10:08 06/10/20 Detailed Accounting Trial Balance Fund: 536 2019 Rev Bond 1&S- W&WW System Department: 51 Administration Program: Period Ending: 5/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 Account: 536-70005-051-000 11 Rev Bond Paying Agent Fee Rev Bond Paying Agent .00 Budgeted 142.08 (142.08) Remaining 0 % Used Account: 536-70040-051-000 Revenue Bond Interest Expense 214,892.43 Account: 536-70040-051-000 Revenue Bond Interest Expense Totals: .00 Budgeted (214,892.43) Remaining Department 51 Totals: Fund 536 Totals: Grand Totals: 0 % Used .00 Monthly Total .00 Budgeted (5.34) Monthly Total .00 Budgeted .00 142.08 .00 214,892.43 215,034.51 ** (215,034.51) Remaining 0 % Used (23,295.07) 23,295.07 Remaining 0 % Used ******* End of Report ********* (1,965,535.73) **** (59,904.72) Monthly Total (209,104.00) Budgeted 1,756,431.73 Remaining 940 % Used 131 of 150 June 15, 2020 Regular Meeting Agenda Packet BUDGET VARIANCE REPORT FUND: 122 - Fire O&M FINANCIALS MONTH: May 2020 REVENUE VARIANCE: 58.1% EXPENSE VARIANCE: 76.4% NOTE: Explanation provided for all accounts with a Year -To -Date percentage (YTD%) less than the Revenue Variance and greater than or equal to the Expense Variance. The Revenue and Expense Variance is calculated on a straight-line method (Financials Month x 8.3%), less 8.3% for revenues and plus 10% for expenses. Only accounts with current month activity will be listed ACCOUNT DESCRIPTION TOTAL BUDGET CURRENT MONTH YTD TOTAL YTD % DATE OF COMMENT VARIANCE EXPLANATION FIRE REVENUES 122-40010 Property Taxes/Mud Fire $1,214,230 $5,991 $1,212,562 99.86% 10/2019 Property Taxes/MUD Fire 122-40011 Property Taxes/Fire - Delinquent -$105 $2,763 10/2019 Delinquent Fire Taxes collected/paid out 122-40020 Property Taxes/Fire P&I $290 $4,301 10/2019 Fire Taxes Penalties & Interest collected FIRE EXPENSES 132 of 150 BUDGET VARIANCE FUND: FINANCIALS MONTH: REVENUE VARIANCE: EXPENSE VARIANCE: NOTE: ACCOUNT REVENUE 135-47000-000 135-47025-000 135-47070-000 135-49011-000 EXPENSES WATER 135-50010-010 135-50029-010 WASTEWATER 135-60010-020 135-65030-020 135-65045-020 BOARD OF DIRECTORS (ADMINISTRATION 1135-55120-030 1135-55160-030 135-60025-030 1 Non -Departmental June 15, 2020 Regular Meeting Agenda Packet REPORT 135 - MUD 1 O&M May 2020 58.1% 76.4% Explanation provided for all accounts with a Year -To -Date percentage (YTD%) less than the Revenue Variance and greater than or equal to the Expense Variance. The Revenue and Expense Variance is calculated on a straight-line method (Financials Month x 8.3%), less 8.3% for revenues and plus 10% for expenses. Only accounts with current month activity will be listed DESCRIPTION TOTAL CURRENT YTD YTD % DATE OF VARIANCE EXPLANATION BUDGET MONTH TOTAL COMMENT Water Penalties TCCC Effluent Charges Interest Income Overtime Life Insurance & Other Communications/Mobiles Chemicals Lab Supplies Cleaning Services Professional Outside Services Water $6,486,623 $459,564 $2,951,754 45.51% 01/2020 $112,608 -$58 $51,075 45.36% 04/2020 $50,000 $8,843 $25,909 51.82% 04/2020 $120,000 $3,764 $67,382 56.15% 5/2020 $17,000 $1,562 $13,428 $3,132 $329 $2,535 Water Sales Penalties TCCC Effluent Charges Interest Income Decrease Rates 78.99% 01/2020 Overtime 80.94% 03/2020 Life Insurance $5,000 $408 $3,904 78.08% 01/2020 New Tablet and Service $20,000 $2,789 $19,928 99.64% 11/2019 Chemicals $20,000 $102 $16,534 82.67% 03/2020 Lab Supplies $10,000 $65,600 $1,500 $1,897 $54,600 -$228 133 of 150 $7,659 $57,100 $1,251 76.59% 87.04% 83.37% 05/2020 05/2020 04/2020 COVID-19; extra cleaning M3 Contract Reclass Increase due to Elections and Town Public Service Building Leak TROPHY CLUB MUNICIPAL UTILITY DISTRICT June 15, 2020 Regular Meeting Agenda Packet Trophy Club Municipal Utility District No. 1 General Manager's Report June 15, 2020 Regulatory Updates • 2019 Consumer Confidence Report has been completed and approved by TCEQ Capital Improvement Projects • Wastewater Treatment Plant — Awaiting recommended testing procedures for the crane. • Waterline Interconnect — Comments have been provided for the 95% plans and two easements were received this month. • Meadowbrook Water Line — The water line replacement is substantially complete. Awaiting pressure testing, bacteriological sampling, and service connections. • Board Room Upgrades — Awaiting quotes for the installation of new audio and video components. Water Operations • Water pumped — 80.279 MG • Average day — 2.590 MGD • Peak day — 3.764 on Tuesday, May 2nd, 2020 • Work orders completed - 206 • New meters set - 1 • Meter change outs - 3 • Meter heads changed - 0 • Leaks — 1 • Valve and hydrant Maintenance — 0 Wastewater Operations • Wastewater treated - 7.94 MG • Average daily flow - 1.13 MGD • Peak flow - 1.49 MGD on Tuesday, May 26, 2020 • Rainfall - 2.43" • Plant performance — no issues • Plant effluent - no detect on laboratory test results and E -coli • CCTV - 0 • Pipe cleaning — 300' (inverted syphon) 134 of 150 Ju . 5 020 e ar M ting Agenda Packet Trophy Club Municipal Utility iiis' ric o. Public Water System ID No. TX0610018 2019 Annual Drinking Water Quality Report Consumer Confidence Report June 2020 This information is provided to you by: Trophy Club Municipal Utility District No. 1 100 Municipal Drive, Trophy Club, Texas 76262, Phone: (682) 831-4600 District Contact: Alan Fourmentin, General Manager Our Drinking Water Meets or Exceeds All Federal (EPA) Drinking Water Requirements This report is a summary of the quality of the water we provide our customers. The analysis was made by using the data from the most recent U.S. Environmental Protection Agency (EPA) required tests and is presented in the following pages. We hope this information helps you become more knowledgeable about what is in your drinking water. Should you have questions or need additional copies of this report, please call the District office at (682) 831-4600. The report is also available on our website at www.tcmud.orci. Special Population Advisory You may be more vulnerable than the general population to certain microbial contaminants, such as Cryptosporidium, in drinking water. Infants, some elderly, or immunocompromised persons such as those undergoing chemotherapy for cancer; those who have undergone organ transplants; those who are undergoing treatment with steroids; and people with HIV/AIDS or other immune system disorders can be particularly at risk from infections. You should seek advice about drinking water from your physician or health care provider. Additional guidelines on appropriate means to lessen the risk of infection by Cryptosporidium are available from the Safe Drinking Water Hotline at (800) 426-4791. Water Sources: The sources of drinking water (both tap water and bottled water) include rivers, lakes, streams, ponds, reservoirs, springs, and wells. As water travels over the surface of the land or through the ground, it dissolves naturally -occurring minerals, and in some cases, radioactive material, and can pick up substances resulting from the presence of animals or from human activity. Contaminants that may be present in source water before treatment include: • Microbial contaminants, such as viruses and bacteria, which may come from sewage treatment plants, septic systems, and agricultural livestock operations and wildlife. • Inorganic contaminants, such as salts and metals, which can be naturally -occurring or result from urban storm water runoff, industrial or domestic wastewater discharges, oil and gas production, mining, or farming. • Pesticides and herbicides, which may come from a variety of sources such as agriculture and urban storm water runoff, and residential uses. • Organic chemical contaminants, including synthetic and volatile organic chemicals, which are by-products of industrial processes and petroleum production, and can also come from gas stations, urban storm water runoff, and septic systems. • Radioactive contaminants, which can be naturally -occurring or be the result of oil and gas production and mining activities. Public Participation Opportunities Date: June 15, 2020 Time: 6:30 p.m. Location: Zoom/telephone conference The public toll-free dial -in numbers to participate in the telephonic meeting are: 1 888 475 4499 and 1 877 853 5257; Meeting ID: 861 6449 3466 Este informe incluye informacion importante sobre el agua potable. Si tiene preguntas o comentarios sobre este informe en espanol, favor de !lamer al tel. (682) 831-4600 para hablar con una persona bilingue en espanol. Where Do We Get Our Drinking Water? Our drinking water is obtained from both surface and groundwater sources. Surface water is purchased from the City of Fort Worth and its sources are Lake Worth, Eagle Mountain Lake, Lake Bridgeport, Richland Chambers Reservoir, Cedar Creek Reservoir, and the Clear Fork Trinity River (from Lake Benbrook). Groundwater sources are from four wells including three from the Paluxy Aquifer and one from the Trinity Aquifer. The Texas Commission on Environmental Quality (TCEQ) completed an assessment of your drinking water sources and results indicate that some of your sources are susceptible to certain contaminants. The sampling requirements for your water system are based on this susceptibility and previous sample data. Any detection of these contaminants may be found in this report. For more information about your sources of water please refer to the Source Water Assessment Viewer available at http://www.tcecl.texas.aov/ais/swaview. Further details about sources and source -water assessments are available on Texas Drinking Water Watch at http://dww2.tcea.texas.aov/DWW/. For more information on source water assessments and protection efforts at our 135 ofslyMem, contact Alan Fourmentin at (682) 831-4600. June 15, 2020 Regular Meeting Agenda Packet All Drinking Water May Contain Contaminants When drinking water meets federal standards there may not be any health -based benefits to purchasing bottled water or point -of -use devices. Drinking water, including bottled water, may reasonably be expected to contain at least small amounts of some contaminants. The presence of contaminants does not necessarily indicate that water poses a health risk. In order to ensure tap water is safe to drink, the EPA and TCEQ prescribe regulations which limit the amount of certain contaminants in water provided by public water systems. FDA regulations establish limits for contaminants in bottled water, which must provide the same protection for public health. More information about contaminants and potential health effects can be obtained by calling the EPA's Safe Drinking Water Hotline at (800) 426-4791. Water Quality Data The table in this report lists all the drinking water contaminants we detected during tests conducted from the previous calendar year, unless otherwise noted. The state requires us to monitor for certain contaminants less than once per year because the concentrations of these contaminants are not expected to vary significantly from year to year. Therefore, some of the data, though representative of the water quality, is more than one year old. Secondary Constituents Many constituents (such as calcium, sodium or iron) which are often found in drinking water, can cause taste, color and odor problems. The taste and odor constituents are called secondary constituents and are regulated by the State of Texas, not the EPA. These constituents are not causes for health concerns. Therefore, secondary constituents are not required to be reported in this document, but they may greatly affect the appearance and taste of your water. About the Following Pages The pages that follow list all of the federally regulated or monitored contaminants which have been found in your drinking water. The United States Environmental Protection Agency (EPA) requires water systems to test up to 97 constituents. Please note that not all constituents are required to be sampled every year. Only the most recent year for sampling of a constituent is included in the report. Definitions Action Level (AL): The concentration of a contaminant which, if exceeded, triggers treatment or other requirements which a water system must follow. Action Level Goal (ALG): The level of a contaminant in drinking water below which there is no known or expected risk to health. ALGs allow for a margin of safety. Average (Avg): Regulatory compliance with some MCLs are based on running annual average of monthly samples. Maximum Contaminant Level (MCL): The highest permissible level of a contaminant in drinking water. MCLs are set as close to the MCLGs as feasible using the best available treatment technology. Maximum Contaminant Level Goal (MCLG): The level of a contaminant in drinking water below which there is no known or expected health risk. MCLGs allow for a margin of safety. Maximum Residual Disinfectant Level (MRDL): The highest level of disinfectant allowed in drinking water. There is convincing evidence that addition of a disinfectant is necessary for control of microbial contaminants. Maximum Residual Disinfectant Level Goal (MRDLG): The level of a drinking water disinfectant below which there is no known or expected risk to health. MRDLGs do not reflect the benefits of the use of disinfectants to control microbial contamination. Treatment Technique (TT): A required process intended to reduce the level of a contaminant in drinking water. Abbreviations MFL - million fibers per liter (a measure of asbestos) N/A - not applicable NTU - Nephelometric Turbidity Units ppq - parts per quadrillion, or picograms per liter ppt - parts per trillion, or nanograms per liter pCi/L - picocuries per liter (a measure of radioactivity) ppm - parts per million, or milligrams per liter (mg/I) ppb - parts per billion, or micrograms per liter (ug/I) mrem/yr — millirems per year ND — (not -detectable) lab analysis indicates not present UMHO/CM — micromhos Lead and Date MCLG Action 90th # Sites Units Violation Likely Source of Contamination Copper Sampled Level (AL) Percentile Over AL Copper 2019 1.3 1.3 0.3508 0 ppm N Erosion of natural deposits; Leaching from wood preservatives; Corrosion of household plumbing systems. Lead 2019 0 15 2.9 0 ppb N Corrosion of household plumbing systems; Erosion of natural deposits. If present, elevated levels of lead can cause serious health problems, especially for pregnant women and young children. Lead in drinking water is primarily from materials and components associated with service lines and home plumbing. Trophy Club Municipal Utility District No. 1 is responsible for providing high quality drinking water but cannot control the variety of materials used in plumbing components. When your water has been sitting for several hours, you can minimize the potential for lead exposure by flushing your tap for 30 seconds to 2 minutes before using water for drinking or cooking. If you are concerned about lead in your water, you may wish to have your water tested. Information on lead in drinking water, testing methods, and steps you can take to minimize exposure is available from the Safe Drinking Water Hotline or at http://www.epa.gov/safewater/lead. 136 of 150 Maximum Residual Disinfectant Level Average Minimum Maximum Year Disinfectant Level Level Level MRDL 2019 Chloramine Residual 2.91 1.0 3.90 4.0 (Total Chlorine) Disinfection By -Products June 15, 2020 Regular Meeting Agenda Packet MRDLG <4.0 Unit of Violation Measure (Y or N) ppm N Highest Range of Collectio Contaminant Level Levels MCL Unit of Violation n Date Detected Detected Measure (Y or N) 2019 HAA5 Total Haloacetic Acids 11 7.2-12.7 60 2019 Total Trihalomethanes 19 9.08-31.6 80 ppb N ppb N Source of Disinfectant Disinfectant used to control microbes. Source of Contaminant Byproduct of drinking water disinfection. Byproduct of drinking water disinfection. [*The value in the Highest Level or Average Detected column is the highest average of all sample results collected at a location over a year' *Highest level detected is based on a running annual average calculated from quarterly samples as required by TCEQ, and may be from predecessor system measurement Inorganic Collection Highest Range of Individual Contaminants Date Level Samples MCLG MCL Units Violation Likely Source of Contamination Detected Barium 2019 0.055 0.055 - 0.055 2 2 ppm N Discharge of drilling wastes; Discharge from metal refineries; Erosion of natural deposits. Cyanide Fluoride Mercury Nitrate [measured as Nitrogen] 10/10/2017 73.2 73.2 - 73.2 200 200 ppb N Discharge from plastic and fertilizer factories; Discharge from steel/metal factories. 10/10/2017 0.666 0.666 - 0.666 4 4.0 ppm N Erosion of natural deposits; Water additive which promotes strong teeth; Discharge from fertilizer and aluminum factories. 2019 2.26 2.26 - 2.26 2 2 ppb N Erosion of natural deposits; Discharge from refineries and factories; Runoff from landfills; Runoff from cropland. 2019 0.257 0.257 - 0.257 10 10 ppm N Runoff from fertilizer use; Leaching from septic tanks, sewage; Erosion of natural deposits. Radioactive Collection Highest Level Range of Individual Contaminants Date Detected Samples Beta/photon emitters 2019 4.8 4.8 - 4.8 MCLG MCL Units Violation Likely Source of Contamination *EPA considers 50 pCi/L to be the level of concern for beta particles. Organic Contaminants — (Measured in Fort Worth system) Year 2019 Contaminant Atrazine Highest Level Detected 0.1 Range of Levels Detected 0-0.1 Microbial Contaminants NONE DETECTED 0 50 pCi/L* N Decay of natural and man-made deposits. MCLG 3 Highest Single Measurement MCL 3 Unit of Measure ppb Lowest Monthly % Year Contaminant MCL of Samples Source of Contaminant Meeting Limits 2019 Total Coliform, including E. Coli 0 Absent 100% N Human and animal fecal waste. Total Coliform Bacteria are used as indicators of microbial contamination of drinking water because testing for them is easy. While not disease -causing organisms themselves, they are often found in association with other microbes that are capable of causing disease. Coliform are hardier than many disease -causing organisms; therefore, their absence from water is a good indication that the water is microbiologically safe for human consumption. Violation (Y or N) N Violation (Y or N) Source of Contaminant Herbicide Radioactive Contaminants (Source Water: City of Fort Worth) Year Contaminant Highest Level Range of Levels MCLG MCL Unit of Violation Detected Detected Measure (Y or N) 2017 Combined Radium 2.5 NA 0 5 pCi/L N (-226 & -228) 137 of 150 Source of Contaminant Erosion of natural deposits. 2017 Beta/photon emitters 5.6 4.4 - 5.6 *EPA considers 50 pCi/L to be the level of concern for Beta particles Inorganic C^ntaminants (Source Water: Cloy of Fort Worth) Highest Range of 0 50* June 15, 2020 Regular Meeting Agenda Packet (mrem/year) /(pCi/L) Unit of Violation N Decay of natural and man- made deposits. Year Contaminant Level Levels MCLG MCL Measure (Y or N) Source of Contaminant Detected Detected Erosion of natural deposits; runoff from 2019 Arsenic 1.50 0 — 1.10 0 10 ppb N orchards; runoff from glass and electronics production wastes. Discharge of drilling wastes; discharge 2019 Barium .07 .05 - .07 2 2 ppm N from metal refineries; erosion of natural deposits. 2019 Uranium 1.1 0 to 1.1 0 30 Ppb N Erosion of natural deposits 2019 Cyanide 126 74.8 to 126 200 200 ppb N Discharge plastic and fertilizer factories; discharge from steel/metal factories. Water additive which promotes strong teeth; Erosion of natural deposits; water 2019 Fluoride .54 .15 - .54 4 4 ppm N additive which promotes strong teeth; discharge from fertilizer and aluminum factories. 2019 Bromate 4.35 0 — 14.8 10 0 ppm N By-product of drinking water disinfection Inorganic Contaminants Cont. Source Wa er: City of Fort Worth) Collection Contaminant Highest Range of MCLG MCL Unit of Violation Collection Date Date Level Levels Measure Detected Detected Nitrate * Runoff from fertilizer use; leaching from 2019 (measured as .58 0.18 — 0.58 10 10 ppm N septic tanks, sewage; erosion of natural nitrogen) deposits. Runoff from fertilizer use; leaching from 2019 Nitrite** .02 .01 - .02 1 1 ppm N septic tanks, sewage; erosion of natural deposits. **Measured in Fort Worth System *Nitrate Advisory: Nitrate in drinking water at levels above 10 ppm is a health risk for infants of less than six months of age. High nitrate levels in drinking water can cause blue baby syndrome. Nitrate levels may rise quickly for short periods of time because of rainfall or agricultural activity. If you are caring for an infant, you should ask advice from your health care provider. Turbidity (Source Water: City of Fort Worth) Year Contaminant MCL MCLG Highest Single Range of Levels Turbidity Unit of Violation Source of Measurement Detected Limits Measure (Y or N) Contaminant Turbidity — 2019 Highest TT=1 NA 0.5 NA 0.3 NTU N Soil runoff. Measurement 2019 % of Samples TT=99 NA NA NA 0.3 NTU N Soil Runoff <_ 0.3 NTU §290.275(3)(5) Turbidity. Turbidity has no health effects. However, turbidity can interfere with disinfection and provide a medium for microbial growth. Turbidity may indicate the presence of disease -causing organisms. These organisms include bacteria, viruses, and parasites that can cause symptoms such as nausea, cramps, diarrhea, and associated headaches. Total Or Ianic Carbon (Source Water: City of Fort Worth) Year Contaminant MCL MCLG Highest Lowest Average Violation Source of Measurement Measurement (Y or N) Contaminant 2019 Total Organic Carbon % TT = removal N/A 1 1 1 N Naturally occurring. Total Organic Carbon is used to determine disinfection by-product precursors. The City of Fort Worth was compliant with all monitoring and treatment technique requirements for disinfection by-product precursors. Year -Round Watering Restrictions in Effect Consult the TCMUD.org website for further details. htto://tcmud.ora/customer-service/water-restrictions/ 138 of 150 June 15, 2020 Regular Meeting Agenda Packet Unregulated Contaminants Unregulated contaminants are those for which EPA has not established drinking water standards. The purpose of unregulated contaminant monitoring is to assist EPA in determining the occurrence of unregulated contaminants in drinking water and whether future regulation is warranted. Compound Measure MRDL MRDLG Average Range of Detects Common Sources of Substance Chloral Hydrate ppb Not regulated N/A 0.33 0.23 to 0.43 By-product of drinking water disinfection Bromoform Bromodichloromethane Chloroform Dibromochloromethane ppb Not regulated ppb Not regulated ppb ppb 0 1.07 1.02 to 4.09 0 3.97 1.12 to 8.94 Not regulated 70 3.68 Not regulated 60 3.68 1.32 to 8.11 1.01 to 10.4 By-products of drinking water disinfection; not regulated individually; included in Total Trihalomethanes Dibromoacetic Acid Dichloroacetic Acid Monobromoacetic Acid Monochloroacetic Acid Trichloroacetic Acid ppb Not regulated ppb Not regulated ppb Not regulated N/A 1.41 0 4.78 1.00 to 3.20 2.40 to 9.20 By-products of drinking water disinfection; not regulated individually; included in Haloacetic 1.00 to 2.50 Acids 1.00 to 2.00 N/A 0.02 1.00 to 1.00 ppb Not regulated 70 0.61 ppb Not regulated 20 0.09 (Source Water: City of Fort Worth) Secondary Constituents These items do not relate to public health but rather to the aesthetic effects. These items are often important to industry. Compound Measure Your water Bicarbonate Calcium Chloride Conductivity pH Magnesium Sodium Sulfate Total Alkalinity as CaCO Total Dissolved Solids Total Hardness as CaCO3 Total Hardness in Grains ppm ppm ppm pmhos/cm units ppm ppm ppm ppm ppm ppm grains/gallon (Source Water: City of Fort Worth) 128 to 149 42.4 to 60.7 19.5 to 35.1 403 to 482 8.1 to 8.4 4.64 to 8.30 15.1 to 26.8 23.4 to 44.3 128 to 150 192 to 266 138 to 178 8 to 10 Contaminants may be found in drinking water that may cause taste, color, or odor problems. These types of problems are not necessarily causes for health concerns. For more information on taste, odor, or color of drinking water, please contact the system's business office. 139 of 150 June 15, 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 2010 39,794 39,713 29,547 30,305 25,328 23,279 41,646 53,439 102,921 89,760 128,687 82,331 686,750 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 140,000 120,000 100,000 80,000 60,000 40,000 20,000 WATER BILLED IN THOUSANDS OF GALLONS 409,334 Agi 0 October November December January February March April Mr June July August September - 2016 - 2017 - 2018 2019 - 2020 Water Pumped FY October November December January February March April May June July August September Total Year 2010 40,803 41,600 32,700 31,400 30,145 27,240 43,400 62,646 113,049 94,950 131,650 76,159 725,742 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 457,900 180,000 160,000 140,000 120,000 100,000 80,000 60,000 40,000 20,000 WATER PUMPED IN THOUSANDS OF GALLONS October November December January February March April May June July August September - 2016 - 2017 - 2018 2019 - 2020 Active Connections FY October November December January February March April May June July August September 2014 Total 4139 4157 4173 4206 4209 4219 4240 4268 4280 4308 4333 4339 2015 Total 4353 4363 4377 4404 4413 4429 4443 4459 4478 4486 4498 4517 2016 Total 4531 4538 4556 4568 4593 4604 4607 4616 4622 4627 4632 4636 2017 Total 4644 4647 4661 4657 4663 4666 4670 4676 4685 4690 4696 4700 2017 MUD 3208 3210 3220 3216 3221 3224 3228 3234 3242 3247 3252 3256 2017 PID 1436 1437 1441 1441 1442 1442 1442 1442 1443 1443 1444 1444 2018 Total 4701 4706 4712 4716 4720 4724 4724 4728 4732 4735 4736 4738 2018 MUD 3257 3262 3268 3272 3276 3280 3280 3284 3288 3291 3292 3294 2018 PID 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 2019 Total 4741 4743 4745 4753 4753 4758 4761 4762 4768 4770 4773 4782 2019 MUD 3297 3299 3301 3309 3309 3314 3317 3318 3324 3326 3329 3338 2019 PID 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 140 of 150 June 15, 2020 Regular Meeting Agenda Packet May 2020 Results Ammonia -N CBOD5 TSS Date % Removal % Removal % Removal Influent Effluent Influent Effluent Influent Effluent 5 -May 5.3 0.20 96.2% 189 2.0 98.9% 138 1.0 99.3% 6 -May 44.8 0.20 99.6% 321 2.0 99.4% 290 1.0 99.7% 11 -May 47.2 0.20 99.6% 277 2.0 99.3% 170 1.0 99.4% 12 -May 49.5 0.20 99.6% 284 2.0 99.3% 353 1.0 99.7% 18 -May 37.2 0.20 99.5% 167 2.0 98.8% 146 1.0 99.3% 20 -May 42.5 0.29 99.3% 214 2.0 99.1% 323 1.0 99.7% 26 -May 47.5 0.44 99.1% 299 2.0 99.3% 214 1.0 99.5% 27 -May 35.0 0.20 99.4% 299 2.0 99.3% 143 1.0 99.3% IReport Ammonia -N CBOD5 TSS 0.24 1 99.0% 2.0 1 99.2% 1.0 1 99.5% 141 of 150 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 June 15, 2020 Regular Meeting Agenda Packet Ammonia Nitrogen Permit Limit 3 (Jan - March) Permit Limit - 1 from April - August 0.523 0.57 0.23 0.2 0.21 0.241 Permit Limit 3 (Sept. - Dec.) Dec -19 Jan -20 Feb -20 Mar -20 Apr -20 May -20 Jun -20 Jul -20 Aug -20 Max mg/L = .20 Average mg/L =.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 2.0 2.0 II II II II II II Permit Limit 5 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 142 of 150 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 June 15, 2020 Regular Meeting Agenda Packet Total Suspended Solids (TSS) 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 .EP Permit Limit 12 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 5.1 5.10 4.95.00 6.0 5.34 5.05.26 4.5 5.11 4.3 4'97 11111111 1 1 1 1 Permit Limit 24 Dec -19 Jan -20 Feb -20 Mar -20 Apr -20 May -20 Jun -20 Jul -20 Max mg/L = 5.8 Average = 4.6 143 of 150 Aug -20 Sep -20 Oct -20 Nov -20 Dec -20 T55 - 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 June 15, 2020 Regular Meeting Agenda Packet E. Coli Permit Limit 126 1.0 1.0 1.0 1.0 NM 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 MI MI 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 77 3 7.41 7.67 7.72 7.48 7.627.39 7.47 7.03 7.16 7.11 6.74•- 6.29 7.48 7.06 6.64• Permit Limit High 9 Permit Limit Low 6 0.00 0.00 0.00 0.00 0.00 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 144 of 150 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 June 15, 2020 Regular Meeting Agenda Packet Dissolved Oxygen (DO) 8.3 7.7 8.3 8.5 8.4 18.2 8.3 8.0 1II111It II 8.3 1 8.2 7.8 Permit Limit Max 9 Permit Limit Min 6 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 145 of 150 Sep -20 Oct -20 Nov -20 Dec -20 - DO - DO Aver - Permit Limit Min. - Permit Limit Max June 15, 2020 Regular Meeting Agenda Packet Trophy Club MUD #1 Utility Billing Report Fiscal Year 2020 October November December January February March April May June July August September ebills 938 941 944 951 963 970 979 986 Bills Mailed 3841 3845 3860 3835 3817 3833 3815 3810 Bank Draft 646 650 652 654 649 649 661 660 Credit Card Draft 1193 1185 1193 1198 1168 1208 1249 1259 Online Payments 1145 1192 1,184 1,208 1,187 1,216 1,096 1,112 Late Notices 378 453 339 462 452 425 428^ 544^ Disconnects 21 41 42 27 38 20 64* 78* M 3351 3352 3353 3353 3363 3363 3372 3373 Connections P 1444 1444 1444 1444 1444 1444 1444 1444 ^ In response to COVID-19 the District has suspended Late Notices * In response to COVID-19 the District has suspended Disconnects Fiscal Year 2019 October November December January February March April May June July August September ebills 870 867 868 883 885 890 903 904 932 932 932 936 Bills Mailed 3921 3921 3927 3903 3856 3859 3866 3859 3878 3875 3871 3859 Bank Draft 650 650 660 664 661 669 666 666 664 656 656 653 Credit Card Draft 1077 1109 1103 1114 1128 1151 1152 1152 1168 1161 1173 1179 Online Payments 1157 1130 1,124 1,149 1,111 1,129 1,100 1,162 1,098 1132 1145 1172 Late Notices 402 432 439 387 431 421 342 399 346 330 392 391 Disconnects 29 22 33 28 27 25 36 14 25 13 25 29 M 3297 3299 3301 3309 3309 3314 3317 3318 3324 3326 3329 3338 Connections P 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 146 of 150 MUD Permits Month: May 2020 June 15, 2020 Regular Meeting Agenda Packet 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 5/11/2020 2020-34 $ 75.00 $ 1,173.00 $ 353.00 $ 150.00 $ 50.00 $ 1,801.00 Total $ 75.00 $ 1,173.00 $ 353.00 $ 150.00 $ 50.00 $ 147 of 150 $ 1,801.00 J June 15, 2020 Regular Meeting Agenda Packet Fiscal Year 2020 Actuals vs Budgeted YTD as of 05/31/2020 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 00098,564 945,000 65,006,642 80,821,519 59,031,249 63,077,077 46,315,229 45,293,105 40,324,983 44,023,000 41,014,000 36,442,000 56,252,000 31,000,00034,047,000 106,694,8 78,084,000 134,074,841 129,995,80 —0—Budget —0—Actual Oct Nov Dec Jan Feb Mar Apr May Jun Jul 103,800,567 Aug Sep 1,200,000,000 1,000,000,000 800,000,000 600,000,000 400,000,000 200,000,000 O Adopted Budget Water Consumption Vs Actual Water Consumption 974,534,461 441,807,000 Total Water Consumption • Budgeted Water Consumption • Actual Water Consumption Adopted Budget vs YTD Actuals Revenues & Expenses $5,232,858 $5,336,857 $10,638,853 $10,645,077 1 YTD Expenses YTD Revenues Adopted Budget Expenses Adopted Budget Revenues Presented by: Finance Department 900000.00 800000.00 700000.00 643222 29 600000.00 500000.00 400000.00 300000.00 200000.00 100000.00 0.00 Water Revenue Adopted Budget vs Actual 834474 99 411 5344246 347093 20 322271.27 —0—Budget Revenue --Actual Revenue Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 so Adopted Budget Total Water Revenue Vs Actual Total Water Revenue $6,599,484 $2,951,754 $3,771,913 Total Water Revenue $2,068,449 • Budgeted Total Revenue • Actual Total Revenue • Net Budget Total Revenue Minus Budgeted Expenses • Net Actual Total Revenue Minus Actual Expenses $1,105 0% $129,319 3% YTD Expense By Departments • YTD Expense- Water • YTD Expense- WW YTD Expense- Admin • YTD Expense- BOD • YTD Expense- Non Dept 148 of 150 CASH STATUS AS OF MAY 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) *05/31/2020 Customer Water Deposits $315,760 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 149 of 150 June 15, 2020 Regular Meeting Agenda Packet Restricted - Unable to be spent $0 $315,760 $1,604,892 $0 $0 $919,266 $504,533 $0 $0 $784,940 $418,569 $3,892,394 $893,308 $947,761 $0 $356,844 $175,649 $23,295 $10,837,212 1 $o $0 Unrestricted - Available for spending $3,577,659 $2,772,344 $0 $150 $450 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $6,350,603 1 $0 1 $6,350,603 $6,350,603 $895,282 $0 $895,282 l $895,282 $895,282 Total in Accounts (Restricted & Unrestricted) $3,577,659 $3,088,104 $1,604,892 $150 $450 $919,266 $504,533 $0 $0 $784,940 $418,569 $3,892,394 $893,308 $947,761 $0 $356,844 $175,649 $23,295 $17,187,815 General Fund 135 Available 2,772,344 Prosperity General Fund 3,577,659 Texpool General Fund 600 Petty Cash 6,350,603 3,486 2,072,098 6,325,800 103,999 $8,505,384 $895,282 $0 $895,282 A 11 150 of 150 June 15, 2020 Regular Meeting Agenda Packet c' team