Loading...
HomeMy WebLinkAbout2019-0217 February 17, 2020 Regular Meeting Agenda PacketMonday, February 17, 2020 Q TROPHY CLUB MUNICIPAL UTILITY DISTRICT February 17, 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 CALL TO ORDER AND ANNOUNCE A QUORUM CITIZEN COMMENTS This is an opportunity for citizens to address the Board on any matter whether or not it is posted on the agenda. The Board is not permitted to take action on or discuss any comments made to the Board at this time concerning an item not listed on the agenda. The Board will hear comments on specific agenda items prior to the Board addressing those items. You may speak up to four (4) minutes or the time limit determined by the President or presiding officer. To speak during this item, you must complete the Speaker's form that includes the topic(s) of your statement. Citizen Comments should be limited to matters over which the Board has authority. CONSENT AGENDA All matters listed as Consent Agenda are considered to be routine by the Board of Directors and will be enacted by one motion. There will not be a separate discussion of these items. If discussion is desired, that item will be removed from the consent agenda and will be considered separately. 1. Consider and take appropriate action to approve the Consent Agenda. a. January 2020 Check Register b. January 20, 2020 Regular Meeting Minutes attachments: January 2020 Check Register January 20, 2020 Regular Meeting Minutes REGULAR SESSION 2. Consider and take appropriate action regarding approval of Fourth Amendment to Independent Contractor Agreement with John Carman for Consulting Services. attachment: Fourth Amendment to Independent Contractor Agreement 3. Consider and take appropriate action to authorize staff to issue a Request for Qualifications from qualified contractors to prepare a Water, Wastewater and Facility Master Planning and Risk and Resiliency Assessment to begin on October 1, 2020 as part of the Fiscal Year 2021 Capital Projects. attachment: DRAFT RFQ 1 of 155 February 17, 2020 Regular Meeting Agenda Packet 4. Presentation and discussion regarding hardness and turbidity in District water lines. 5. Consider and take appropriate action to approve Joint Election Agreement and Contract for Election Services with Denton County for the May 2, 2020 General Election. attachment: Denton County Joint Election Agreement 6. Consider and take appropriate action to adopt Order No. 2020-0217A declaring the following operations equipment and vehicle to be to be surplus property of the District and authorizing staff to sell such surplus property: a. Truck No. 102 — 2012 Ford F250 king cab pick-up truck with 71,600 miles and purchased on February 7, 2012. b. 2020 Dodge Truck bed c. 2 - Automatic Transfer Switches attachment: Order No. 2020-0217A 7. Consider and take appropriate action regarding Fiscal Years 2020 — 2022 Audit Services: a. Authorize staff to Issue a Request for Proposals for auditing services from qualified auditors. b. Appoint two directors to serve on Audit Committee to review proposals and develop recommendations to the Board of Directors for final selection of auditor. 8. Consider and take appropriate action regarding approval of Interlocal Agreement with the Texas Department of Transportation and the City of Southlake for the reimbursement of costs relating to the relocation of District infrastructure located at Kirkwood Blvd. and Highway 114. attachment: DRAFT ILA 9. Consider and take appropriate action regarding approval of a Proposal by CP&Y, Inc. for Professional Engineering Services relating to the Preparation of Design and Construction Documents for a Pressure Spray System at the Wastewater Treatment Plant Facility. attachment: CP&Y Proposal 10. Discuss and take appropriate action concerning Acting General Manager compensation. (Rose/Flynn) 11. Consider and take appropriate action regarding the January 2020 Combined Financials and Variance Report. a. Combined Financials b. Combined Variance attachments: Combined Financials Combined Variance 2 of 155 February 17, 2020 Regular Meeting Agenda Packet REPORTS & UPDATES 12. Receive report from General Manager Hiring Committee. (Castonguay/Flynn) 13. General Manager Monthly Reports and Update: a. Regulatory Update b. Capital Improvement Projects ■ WWTP Installation of Building and sound wall ■ High Service Pump Station Upgrade c. Water System Operations d. Wastewater System Operations e. Finance Update ■ Utility Billing Report ■ Permits Collected ■ Cash Report attachments: General Manager Report Water Operations Report Utility Billing Report Permits Collected Cash Report EXECUTIVE SESSION 14. 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 15. 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. 3 of 155 February 17, 2020 Regular Meeting Agenda Packet 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 16. 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: Acting General Manager REGULAR SESSION 17. Consider and take appropriate action on matters deliberated in Executive Session: 18. Items for future agendas: 19. Set future Meeting dates - Regular Board Meeting on March 16, 2020 at 6:30 p.m. attachment: March meeting calendar *THE BOARD RESERVES THE RIGHT TO ADJOURN INTO EXECUTIVE SESSION AT ANY TIME DURING THE MEETING PURSUANT TO THE APPLICABLE SECTION OF SUBCHAPTER D, CHAPTER 551, TEXAS GOVERNMENT CODE, THE TEXAS OPEN MEETINGS ACT, WITH RESPECT TO ANY ITEM ON THE AGENDA. NO FINAL ACTION, DECISION OR VOTE WILL BE TAKEN ON ANY SUBJECT OR MATTER IN EXECUTIVE SESSION. THIS NOTICE MODIFIES THE DISTRICTS PRIOR PRACTICE OF SPECIFICALLY IDENTIFYING ALL AGENDA ITEMS TO BE DISCUSSED IN EXECUTIVE SESSION. ADJOURN 4 of 155 apackamt2 skzolczyk Begin Date: 01/01/2020 End Date: 01/31/2020 vendor vencor Name Number 2651 Carman Consulting Lim. 2651 Carman Cknsulting LLC. 2651 Carman Cxansulting LLC. Totals for Check: 6056 3156 OXIDOR 1AEOi2ATCRIES LLC 3156 CMIDOR LABORATORIBS LABORATORIESTIC 3156 OXIDOR LABORATORIES LLC 3156 OXIDOR LABOR/ IFS LLC 3156 O] DEX1 LABORATORIES LLC Tbrw1s for Check: 6057 1001 TOWN OF TROPHY CLUB Totals for Check: 6058 Fran Amt: invoice Number Invoice ririr Dept ACCOUrit Date Stat No Number 29 29 29 19120687 19120598 19120467 19120698 20010027 010120 1000 TROPHY CLUB ram (WATER RTf Ls) 12/31/2019 Totals for Check: 6059 998 AMRHEIN, SHANNON Totals for Check: 6060 998 BURKHALTER, ADRIAN?. Tbtals for Check: 6061 01/02/20 P 01/02/20 P 01/02/20 P 12/31/19 P 12/23/19 P 12/31/19 P 12/31/19 P 12/31/19 P 01/02/20 P 12/31/19 P U0010080582109A 12/31/19 P 090123100579028 12/31/19 P 998 CENTURY RY 21 MICE BOWMAN, INC. 00 0 3 01114 6 12 03A 12/31/19 P Totals for Check: 6062 998 CDSTELILW, JOEL Totals for Check: 6063 998 mums CUSTOM Fri Totals for Check: 6064 998 DREES CUSTOM HOMES Totals for Check: 6065 998 ELY, SUSAN Tbtals for Cheek: 6066 998 C3tCD uabaxur:aiuv, IIC. Totals for Check: 6067 998 HIGH AMS OF TROPHY CLUB HOA Tbtals for Check: 6068 998 ICS CCMERCIAL, L.P. Totals for Check: 6069 09035120010901A 12/31/19 P 00017000021100A 12/31/19 P 00017000105100A 12/31/19 P 09048060057901A 12/31/19 P U0511000105524A 12/31/19 P U9029011006900A 12/31/19 P U0511000095511A 12/31/19 P 30 135-55070-030-000 30 135-55070-030-000 30 135-60075-030-000 20 135-55135-020-000 20 135-55135-020-000 20 135-55135-020-000 20 135-55135-020-000 20 135-55135-020-000 Trophy club ram rb.1 AP Checks Fbr Date/Amount Range .00 To Amt: 99,999,999.99 Description Independent yahrm Indzendent TAlrvr Meetings Tab Analysis Lab Analysis Tab Analysis Lab Analysis Tab Analysis 45 122-60337-045-000 Transfer to Tbman/Fire Budget 30 135-60025-030-000 Water 135-20050-000-000 A/P Vemdoss 135-20050-000-000 A/P Ve>Y3ors 135-20050-000-000 A/P Vendors 135-20050-000-000 A/P Vendors 135-20050-000-000 A/P Vaxkirs 135-20050-000-000 A/P Vendors 135-20050-000-000 A/P Vendors 135-20050-000-000 A/P Vendazs 135-20050-000-000 A/P Vendors 135-20050-000-000 A/P Vendors 5of155 0)110020y 10 :x®20 Regular Meeting Agenda Pfticet 1 Line item Value 10,640.00 15.08 10.50 10,665.58 230.00 317.40 1,053.97 317.40 230.00 2,148.77 59,888.08 59,888.08 123.17 123.17 117.99 117.99 27.90 27.90 28.26 28.26 08.17 08.17 52.41 52.41 53.17 53.17 24.86 24.86 1,660.21 1,660.21 42.02 42.02 1,881.97 1,881.97 trieCR LrieCK Number Date 6056 01/02/20 6056 01/02/20 6056 01/02/20 6057 01/02/20 6057 01/02/20 6057 01/02/20 6057 01/02/20 6057 01/02/20 6058 01/02/20 6059 01/02/20 6060 01/02/20 6061 01/02/20 6062 01/02/20 6063 01/02/20 6064 01/02/20 6065 01/02/20 6066 01/02/20 6067 01/02/20 6068 01/02/20 6069 01/02/20 apackamt2 skrolczyk Begin Date: 01/01/2020 End Date: 01/31/2020 vendor vemar Aldine Number 998 1CALTI'7 2v, COLTER Totals for Check: 6070 998 KRAPES, ROBERT Totals for Check: 6071 998 KRUK, DFPIATF Totals for Check: 6072 998 OPEN HOUSE =CAS Totals for Check: 6073 998 PECHAL, BOBBY Totals for Check: 6074 998 PFra.rnn, IRIS L Totals for Check: 6075 998 RAY-BRETHMER, MICHELE Totals for Check: 6076 998 ROGERSON, DEBRA Totals for Check: 6077 998 THE KNOLL H.O.A. INC. Totals for Cheek: 6078 1001 TOWN OF TROPHY CLUB Totals for Chheck: 6079 1001 WAN OF TROPHY CLUB Totals for Check: 6080 2694 BladkmonMboring Company Totals for Check: 6081 2497 DHS AUiCMATICN, INC Totals for Check: 6082 1372 HACH COMPANY Totals for Check: 6083 2667 HOLT CAT Totals for Check: 6084 1834 IDE= 143...1.1,12 41.1..1,64, INu 1834 m520C DISSTRIBtYITCN, INC Fran Amt: Tivphy Club MUD N3.1 AP Checks Fcr Date/Amount Range .00 To Amt: 99,999,999.99 Invoice Nurpex Invoice Inv Uept Account Description Date Stat No Nunber U00204500162097i. 12/31/19 P 135-20050-000-000 A/P Vendors U0037000339101A 12/31/19 P 135-20050-000-000 A/P Vendors U9035110003902A 12/31/19 P 135-20050-000-000 A/P Vectors U0010080640105A 12/31/19 P 135-20050-000-000 A/P Vendors U0050090707110A 12/31/19 P 135-20050-000-000 A/P Vendors U0020540003201A 12/31/19 P 135-20050-000-000 A/P Vendors U0023150021203A 12/31/19 P 135-20050-000-000 A/P Vendors U0016010001104A 12/31/19 P 135-20050-000-000 A/P Vendors U0035020002200A 12/31/19 P 135-20050-000-000 A/P Vendors 122319-A 12/31/19 P 122-43415-000-000 Denton County Pledge -Fire 123019-A 12/30/19 P 20 135-69005-020-000 Capital Outlays 1B112687 12/17/19 P 20 135-55080-020-000 Maintenance & Repairs 06-1934 01/01/20 P 20 135-55081-020-000 M inter & Repairs Collections 11776778 12/27/19 P 20 135-65045-020-000 lab Supplies WLU/0031178 12/30/19 P 10 135-55105-010-000 Mainz *ce.-Backhoe/Skirmem 3058141891 3058141890 01/02/20 P 01/02/20 P 20 135-65045-020-000 Tab Supplies 20 135-65045-020-000 Lab Supplies 6 of 155 03081/20-y 1119:2020 Regular Meeting Agenda Deet 2 LIne ltetl tueCK tnneCK Value Number Date 91.10 6070 01/02/20 91.10 26.48 6071 01/02/20 26.48 03.22 6072 01/02/20 03.22 11.73 6073 01/02/20 11.73 11.07 6074 01/02/20 11.07 04.06 6075 01/02/20 04.06 90.41 6076 01/02/20 90.41 06.32 6077 01/02/20 06.32 46.15 6078 01/02/20 46.15 10,000.00 6079 01/03/20 10,000.00 500.00 6080 01/03/20 500.00 4,388.28 6081 01/07/20 4,388.28 646.00 6082 01/07/20 646.00 372.55 6083 01/07/20 372.55 920.37 6084 01/07/20 920.37 458.66 6085 01/07/20 1,463.76 6085 01/07/20 apackamt2 skrolczyk Begin Date: 01/01/2020 &d Date: 01/31/2020 Veneta VeY1Ct'+1' Nance Number 1834 IDE OC DISTRIBUTION, Tbtals for Check: 6085 2943 JPNO GAN CHASE BANK NA 'Lbtals for Check: 6086 3195 LOU'S GLOVES INOMPORATED Totalq for Check: 6087 3168 IDBRICYiT2(N EN3INEERS, INC Totals for Check: 6088 1001 TOWN OF TROPHY CLUB 1001 =MCP OF TROPHY CLUB 1001 =MOP TROPHY CURB Totals for Check: 6089 Fran Amt: 1nvOeCe karma= invoice" .lSN Uept ACCOlnt Date Stat No Number 3056622613 12262019 032310 1N412464 DEC mum DEC REFUSE EEC REFUSE 2634 'alley Solvent Ckmgany, INC 51094 Totals for Check: 6090 2698 2698 2698 2698 2698 Totals Ritz Safety, LIC Ritz Safety, TLC Ritz Safety, LIC Ritz Safety, LIC Ritz Safety, ILC for Check: 6091 1005 ATLAS UT1L/TY SUPPLY CO. 1005 ATLAS tiTILrrt SUPPLY CO. 1005 ATLAS UTILITY SUPPLY CO. Totals for Check: 6092 2683 Charter Carm nications Totals for Check: 6093 2655 Ooze & Main LP 2655 Clore & Main LP Totals for Check: 6094 3193 CONPOPAY, INC. Totals for Cbeok: 6095 3080 CP&Y/WALSACE GROUP, INC. Totals for Check: 6096 3184 DATAPISE RSC 3184 DATAPROSE LIC 5824896 5829738 5861524 5861617 5865775 11/25/19 P 12/26/19 P 01/02/20 P 01/03/20 P 12/31/19 P 12/31/19 P 12/31/19 P 20 135-65045-020-000 135-20060-000-000 20 135-65045-020-000 20 135-55080-020-000 135-25040-000-000 135-25000-000-000 135-25010-000-000 12/31/19 P 20 135-65030-020-000 12/01/19 P 20 12/01/19 P 20 12/01/19 P 20 11/18/19 P 20 11/26/19 P 20 135-60090-020-000 135-60090-020-000 135-65040-020-000 135-65040-020-000 135-65040-020-000 12168 01/13/20 P 10 135-65050-010-000 011497A 01/13/20 P 10 135-65050-010-000 012089 01/09/20 P 10 135-65053-010-000 71672010620 01/06/20 P 30 135-55030-030-000 1652032 01/03/20 P 10 135-55080-010-000 L676828 01/03/20 P 20 135-55080-020-000 PR00687 996 01/10/20 P 135-21313-000-000 1600916.05-5 01/10/20 P 20 517-69005-020-000 DP1904482 12/31/19 P 30 135-60035-030-000 DP1904482 12/31/19 P 30 135-55205-030-000 Trophy Club tW No.1 Q 9/ y 198:2620 Regular Meeting Agenda Pmt 3 AP Checks Far Date/Amount Range .00 To Amt: 99,999,999.99 uescriptial lab Supplies Procurement Clearing Lab Supplies Maintenance & Tbwa-Stone Drainage Refuse Refuse Tax Chemicals Safety P dfl Safety P10gta t Safety Equipment Safety Equilment Safety Equipment Meter &pease Meter Expelse Meter Change Out Program Software & Support Maintenance & Repairs Maintenance & Repairs Cafe 125 -Medical Reilrb Capital Outlays Postage Utility Billing cb tract 7 of 155 Jane -"lten - tmec4 ";meCK Value Reber Date 1,381.63 6085 01/07/20 3,306.05 12,829:65 6086 01/07/20 12,829.65 169.20 6087 01/07/20 169.20 366.09 6088 01/07/20 366.09 36,251.47 66,838.24 5,463.96 108,553,67 6089 01/07/20 6089 01/07/20 6089 01/07/20 569.00 6090 01/07/20 569:00 56.82 52.32 43.42: 183.20 683:18 1,018.94 6091 6091 6091 6091 6091 01/07/20 01/07/20 01/07/20 01/07/20 01/07/20 4,259:50 " 6092 01/20/20 2,970:00 -6092 01/20/20 36,900.00 6092 01/20/20 44,129.50 899.00 6093 01/20/20 899.00 464.00 6094 01/20/20 220.00 6094 01/20/20 684.00 549.37 6095 01/20/20 549.37 2,220.00 6096 01/20/20 2,220.00 158.50 6097 01/20/20 182.94 6097 01/20/20 apackamt2 slc olczyk Begin Date: 01/01/2020 End Date: 01/31/2020 Venoor venoor Nene NUmber Totals for Check: 6097 2677 Digital Air Control, Inc Totals for Check: 6098 2653 Dubois Bryant Canpbell LLP Totals for check: 6099 3118 Exclusive Pest Control Tbtals for check: 6100 2606 Fisery Solutions, LLC Totals for Check: 6101 2635 Halff Associates, INC 2635 Halff Associates, INC Totals for Check: 6102 1372 HACH COMPANY Totals for Check: 6103 2775 HODSON ENERGY SERVICES, LIC 2775 HODSCN ENERGY SERVICES, LLC Totals for Check: 6104 1834 IDEOCX DISfRIBi I'I 84, INC 1834 IDE70C DISIRIBUTICN, SNC Totals for Check: 6105 3124 IRS Tax Payment 3124 IRS Tax Payment 3124 IRS Tax Payment Totals for Check: 6106 1468 L.H. CW NEY MATPRIALS, INC. 1468 L.H. CHANEY MATERIALS, INC. Totals for Check: 6107 3216 M3 Networks Totals for C11e+.k: 6108 2643 Mclean & Howard, L.L.P. 2643 McLean & Howard, L.L.P. Totals for Check: 6109 998 MCJO IICC EN SIGNATURE HOMES Totals for Check: 6110 Fran Amt: Invoice NUiner invoice Inv iiegt SCOW= Date Stat No Nutter 2051044 01/10/20 P 30 135-60235-030-000 104044 01/16/20 P 20 517-69005-020-000 7384 12/18/19 P 30 135-55080-030-000 91635045 01/04/20 P 30 135-60040-030-000 10032459 01/09/20 P 30 135-55030-030-000 10032451 01/09/20 P 10 520-69005-010-000 11781258 01/02/20 P 10 135-65030-010-000 52001150001-31 01/15/20 P 10 135-60020-010-000 52001150001-31 01/15/20 P 20 135-60020-020-000 3058368367 01/08/20 P 20 135-65045-020-000 3058295136 01/06/20 P 20 135-65045-020-000 PR00687 PR00687 PR00687 996 01/10/20 P 996 01/10/20 P 996 01/10/20 P 135-21302-000-000 135-21303-000-000 135-21304-000-000 169006 01/04/20 P 20 135-55125-020-000 169441 01/11/20 P 20 135-55125-020-000 5802 01/15/20 P 30 135-55030-030-000 35712 12/31/19 P 39 135-55045-039-000 35711 12/31/19 P 39 135-55045-039-000 00511000109501A 01/10/20 P 135-20050-000-000 Trophy club MOD No.1 AP Checks For Date/Anoint Range .00 Tb Amt: 99,999,999.99 Description Security Capital Outlays Maintenance & Repairs Service Charges & Pees Software & Support Capital Outlays Chemicals Electricity Electricity Lab Supplies Lab Supplies FVlsi Taxes Social Security Taxes Medicare Taxes Dempster Services Dempster Services Software & Support leSal legal A/P Vendors 8 of 155 d'u j y 104:2020 Regular Meeting Agenda Int 4 Line Item trieCK LTISOr Value amber Date 341.44 24.00 6098 01/20/20 24.00 1,572.50 6099 01/20/20 1,572.50 110.00 6100 01/20/20 110.00 50.00 6101 01/20/20 50.00 9,952.61 6102 01/20/20 4,704.93 6102 01/20/20 14,657.54 977.77 6103 01/20/20 977.77 5,903.40 6104 01/20/20 12,728.09 6104 01/20/20 18,631.49 505.07 6105 01/20/20 229.33 6105 01/20/20 734.40 4,131.14 6106 01/20/20 5,433.84 6106 01/20/20 1,270.84 6106 01/20/20 10,835.82 2,573.62 6107 01/20/20 2,183.02 6107 01/20/20 4,756.64 494.00 6108 01/20/20 494.00 1,050.00 6109 01/20/20 2,430.00 6109 01/20/20 3,480.00 1,364.85 6110 01/20/20 1,364.85 apa.kaant2 skrolczyk Begin Date: 01/01/2020 End Date: 01/31/2020 vex= venaor Name N Mber Frim Amt: Invoice 1VtiS4Er Jnvo3c AIN Dept Account Date Stat No Nur%er 1051 SL11CAN WBtL SERVICE, LLC 5696 Totals for Check: 6111 2983 NITA Torek for Check: 6112 3156 =DOLABORATORIES LLC 3156 MDMI LA83RATO2I LLC 3156 0 CIDOR LABCBA1O LLC 3156 MOOR IABCRATCRIES ILC Totals far Check: 6113 2703 RDO Equipment Co Tbtals far Check: 6114 3176 REY-MAR u.muiavni,,sv Totals for Bieck: 6115 01/16/20 P 01/05/2020 01/05/20 P 20010102 01/06/20 P 20010111 01/07/20 P 20010198 01/13/20 P 20010286 01/16/20 P E11282 12/09/19 P 01/15/20 P 12/31/19 P 12/31/19 P 2440 TARRANT CIY PUBLIC HEALTH LAB 32943 2440 TARRANT CTY PUBLIC HEALTH LAB 32942 Tbtals for Check: 6116 3113 TCDRS S Totals for Check: 6117 PRO0687 996 01/10/20 P 12/31/19 P 6846041 01/07/20 P 010920 01/09/20 P 76575898 01/07/20 P 2696 Texas Ekcavatian Safety System 19-25407 Totals for Check: 6118 3282 TVA OY.4 8BCIAL FINANCE E Totals for Check: 6119 1001 TCFAN OF TROPHY CLUB Totals for Check: 6120 1081 TRI COUNTY ELECTRIC Totals far Check: 6121 2858 UTILITY SERVICE OD, INC. 2858 UTILITY SERVICE CO, INC. Totals for Check: 6122 496290 497436 2634 Valley Solvent Carpany, INC 51611 Totals for Check: 6123 1058 VFRIZCN WII2IIESS 1058 VERUCKMIRELEBB 1058 V8BIZca WIRES 9845304374 9845304374 9845304374 12/18/19 P 01/01/20 P 01/14/20 P 01/01/20 P 01/01/20 P 01/01/20 P 10 135-69005-010-000 30 135-60100-030-000 20 135-55135-020-000 20 135-55135-020-000 20 135-55135-020-000 20 135-55135-020-000 20 135-55080-020-000 10 135-55080-010-000 10 135-55135-010-001 10 135-55135-010-000 135-21317-000-000 30 135-60040-030-000 30 135-69170-030-000 30 135-60020-030-000 20 135-60020-020-000 10 135-69281-010-000 10 135-69281-010-000 20 135-65030-020-000 10 135-60010-010-000 20 135-60010-020-000 30 135-60010-030-000 Trophy Club MUD No.1 AP Checks For Date/Amount Range .00 Tb Amt: 99,999,999.99 Description Capital Outlays Travel & per diem Lab Analysis Lab Analysis Lab Analysis Lab Analysis Maintenance & Repairs Maintenance & Repairs Lab Analysis for PID lab Analysis TCLIRS Service Charges & Fees Copier Lease Installments Electricity/Gas Electricity Water Tank Inspection Contract Water Tank Inspection Contract Chemicals Qamnmicatia s/Mobiles Cs ran,ications/Mobiles O nimications/&biles 9 of 155 (Wing:TY 1013:2020 Regular Meeting Agenda P,t¢Jeet 5 Lame Item Value (meek (meek Number Date 58,645.00 6111 01/20/20 08.25 6112 01/20/20 317.40 6113 01/20/20 230.00 6113 01/20/20 341.55 6113 01/20/20 241.50 6113 01/20/20 1,130.45 9,900.00 6114 01/20/20 4,375.00 6115 01/20/20 80.00 6116 01/20/20 200.00 6116 01/20/20 280.00 58,645.00 08.25 9,900.00 4,375.00 7,488.50 6117 01/20/20 7,488.50 190.00 6118 01/20/20 165.00 6119 01/20/20 690.43 6120 01/20/20 624.40 6121 01/20/20 190.00 165.00 690.43 624.40 2,200.00 6122 01/20/20 41,944.38 6122 01/20/20 44,144.38 569.00 6123 01/20/20 424.30 6124 01/20/20 408.87 6124 01/20/20 87.75 6124 01/20/20 569.00 apackamt2 skrolczyk Begin Date: 01/01/2020 End Date: 01/31/2020 ve cor Vencor Name Nurber Totals for Check: 6124 Frau Amt: invoice runner Invoice Jnv Dept Account Date Stat No Number 2196 VIcj.a 0 SCHINNERER & W, INC 1291775-035174 01/17/20 P Totals for Check: 6125 1087 WHITAKER CHAIR SWINDLE Totals for Check: 6126 2222 AFLAC 2222 AFLAC Totals for Check: 6127 3197 BenefitMall 3197 BenefitMall 3197 BenefitMall Totals for Check: 6128 1030 CITY OF FDIC % TH 1030 CITY OF FORT WORTH Totals for Check: 6129 2655 Core & Main LP 2655 Care & Main LP Totals for Check: 6130 3193 CCMPUPAY, INC. Totals for Check: 6131 2497 DHS AIMMATICN, INC 2497 DHS AUICMATICN, INC 2497 LOS AUICMATICN, INC Tbtals for Check: 6132 1737 DPC INDUSTRIES, INC Totals for Check: 6133 1832 FIRST FINAMI AL BANK 1832 FIRST FIIVOZ,TAL BANK 1832 FIRST Ffl 1 TAL BANK 1832 FIRST F.QANCIAL BANK 1832 FIRST FIt N2IM. BANK 1832 FIRST FINANCIAL BANK Totals for Check: 6134 3258 ERANCOTYP-FOSTALIA, INC. Totals for Check: 6135 Trophy Club MUD No.1 AP Checks For Date/Amount Range .00 To Amt: 99,999,999.99 30 135-60055-030-000 Insurance 255822 12/31/19 P 39 135-55045-039-000 legal PR00687 996 01/10/20 P 135-21312-000-000 Aflac 9900688 996 01/24/20 P 135-21312-000-000 Aflac 9046576 -IN 9046576 -IN 9046576 -IN 01/24/20 01/30/20 01/16/20 P 01/16/20 P 01/16/20 P 10 135-50029-010-000 20 135-50029-020-000 30 135-50029-030-000 01/24/20 P 10 135-60150-010-000 01/30/20 P 135-20500-000-000 Life Insurance & Other Life Insurance & Other Life Insurance & Other Wholesale Water Fort W rth Water-Lipact L766822 01/15/20 P 10 135-55080-010-000 Maintenance & Repaixs L759040 01/13/20 P 20 135-55081-020-000 Maintea & Repairs Collections PR00688 996 01/24/20 P 06-1945 06-1944 06-1942 01/22/20 P 01/17/20 P 01/17/20 P 135-21313-000-000 Cafe 125 -Medical Reirb 10 135-69005-010-000 Capital Outlays 10 135-55080-010-000 Maintenance & Repairs 20 135-55080-020-000 Maintenance & R�irs 7670000331-20 01/20/20 P 10 135-65030-010-000 01/17/20 01/17/20 01/17/2020 01/17/2020 01/17/2020 01/17/2020 01/17/20 01/17/20 01/17/20 01/17/20 01/17/20 01/17/20 P 20 135-69009-020-000 P 20 135-69008-020-000 P 10 135-69009-010-000 P 20 135-69009-020-000 P 10 135-69008-010-000 P 20 135-69008-020-000 82104336872 01/15/20 P 30 135-60035-030-000 Chemicals Start Term Debt -Interest Stmt Tern Debt -Principal Snort Tern Debt -Interest Short Tern Debt -Interest Short Tenn Debt -Principal Start Tern Debt -Principal Postage 10 of 155 101420'y 11:74:2(120 Regular Meeting Agenda Pagjeet 6 £.ue Lten caeca - "tne:R Value 1 i±ber Date 920.92 50.00 6125 01/20/20 50.00 6,198.50 6126 01/20/20 6,198.50 151.13 6127 01/30/20 210.67 6127 01/30/20 361:80 20.00 36.00 20.00 76.00 6128 01/30/20 6128 01/30/20 6128 01/30/20 118,562:59 6129 01/30/20 69,165.00 6129 01/30/20 187,727.59 100.00 " 6130 01/30/20 117.42 6130 01/30/20 217.42 549.37 6131 01/30/20 549.37 9,125.00. 1,965.30 765.00 11,855.30 6132 01/30/20 6132 01/30/20 6132 01/30/20 558.40 6133 01/30/20 558.40 3,681.96 19,158.74 1,840.00 2,440.07 30,512:00 40,446.00 98,078.77 6134 6134 6134 6134 6134 6134 01/30/20 01/30/20 01/30/20 01/30/20 01/30/20 01/30/20 105.96 6135 01/30/20 105.96 apackan t2 skrolczyk Begin Date: 01/01/2020 End Date: 01/31/2020 Veno' venoor Mee Weber 2676 Humana Inc 2676 Hratana Inc 2676 Humana Inc 2676 Humana Inc 2676 Humana Inc 2676 Humana Ina Tbtals for Check: 6136 3124 IRS Tax Payment 3124 IRS Tax Payment 3124 IRS Tax Payment Tbtals for Check: 6137 2735 Jackson. Walker LLP Totals for therk: 6138 3167 REYSIC E PARK SECRETARIAL Totals for Check: 6139 3278 KYOMA DOCUMENT SCUM= Totals for Check: 6140 1468 L.H. C EMEW MATERIA1S, INC. Totals for Check: 6141 3053 LAFOLLETT & COMPANY, PLLC Totals for Check: 6142 3132 Legal Shield 3132 Legal Shield Totals for Chedk: 6143 Invoice Nuttier invoice env Date Stat 155516821 02/13/20 P 155516821 02/13/20 P 155516821 02/13/20 P 155516821 02/13/20 P 155516821 02/13/20 P 155516821 02/13/20 P PR00688 PR00688 PR00688 996 01/24/20 P 996 01/24/20 P 996 01/24/20 P 1696113 01/23/20 P 159286 01/22/20 P 55R1724700 01/23/20 P 169592 01/18/20 P 01/21/20 01/21/20 P 1R00687 996 01/10/20 P 19.00688 996 01/24/20 P 3186 MEMBER'S maw= MATNIEMAN= 1C1912TOIOD 3186 ' S BUILD= MAIN FLAME TC19121=11 3186 MEMBER' EstrilDmv tikum2TAic2 7C19121 DD Totals for Check: 6144 3115 ME;TLSEE GROUP BENEFITS 3115 MET= GROUP BENEFITS 3115 MEITSEE GROUP BENEFITS 3115 METUFE GRIP B8 EF1T5 Totals for Crick: 6145 1238 NORTH TEXAS R)9.' CO. Totals for Check: 6146 1056 OFFICE DEEOr, INC 2/15/2020 2/15/2020 2/15/2020 2/15/2020 14383 12/31/19 P 12/31/19 P 12/31/19 P 02/15/20 02/15/20 02/15/20 02/15/20 Fruu Pmt: Dept scrota= No Number 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 135-21302-000-000 135-21303-000-000 135-21304-000-000 10 135-69005-010-000 30 135-60005-030-000 30 135-69170-030-000 20 135-55125-020-000 39 135-55055-039-000 135-21310-000-000 135-21310-000-000 20 135-55120-020-000 30 135-55120-030-000 10 135-55120-010-000 P 135-21315-000-000 P 10 135-50029-010-000 P 20 135-50029-020-000 P 30 135-50029-030-000 01/20/20 P 429772551001 01/16/20 P 20 135-55080-020-000 30 135-65085-030-000 Trc by Club MUD No.1 AP Checks For Date/Airuimt Range .00 TO Amt: 99,999,999.99 Description Dental Vision Voluntary Life Life Insurance & Other Life Insurance & Other Life Insurance & Other MAA Taxes Social Security Tis Mefiicare Taxes Capital Outlays Copier T.P.Ang. Installments arrester Services Auditing Legal Plan. Legal Plan Cleaning Services es Cleaning Services Cleaning Services Short Term Disability Life Insurance & Other Life insurance & Other Life Insurance & Other Maintenance & Repairs Office Supplies 11 of 155 ot20bz(EBry 13;2/020 Regular Meeting Agenda FPagget 7 Dine Item One= isle= Value Nimber Date 1,503.31 206.49 318.36 176.88 198.33 176.22 2,579.59 4,258.33 5,476.60. 1,280.82 11,015.75 6136 6136 6136 6136 6136 6136 6137 6137 6137 01/30/20 01/30/20 01/30/20 01/30/20 01/30/20 01/30/20 01/30/20 01/30/20 01/30/20 7,452.00 6138 01/30/20 194.75 6139 01/30/20 76.68 6140 01/30/20 2,505.42 6141 01/30/20 2,505.42 12,563.27 6142 01/30/20 7,452.00 194.75 76.68 12,563.27 17.46 6143 01/30/20 17.44 6143 01/30/20 34.90 87.50 869.06 87.50 1,044.06 74.36 132.01 165.74 151.69. 523.80 6144 01/30/20 6144 01/30/20 6144 01/30/20 6145 01/30/20 6145 01/30/20 6145 01/30/20 6145 01/30/20 1,150.00 6146 01/30/20 1,150.00 161.83 6147 01/30/20 apackamt2 skrolczyk Begin Date: 01/01/2020 End Date: 01/31/2020 venoor venom tine Number Totals for Check: 6147 3156 =DOR LAB)RATtRIES LLC 3156 CNIDOR LABORATORIES LLC Totals for Check: 6148 3176 REY-MAR lxavoucu uJ Totals for Check: 6149 999 Sandra Stiltner Totals for Check: 6150 2736 Stuart Hose & Pipe 2736 Stuart Hose & Pipe Totals for Check: 6151 3113 TCDRS Totals for Check: 6152 3123 Te)ms Tbllcamays/T5[&1g Totals for Check: 6153 Fran Amt: D1vo .ce NtXTh er invoice Inv Dept Account Date Stat No Number 20010372 20010424 02 01/30/20 52001702911 SI001702891 01/20/20 P 01/22/20 P 01/28/20 P 01/30/20 P 01/24/20 P 01/24/20 P 2900688 996 01/24/20 P 01/10/2020 01/10/20 P 01/31/20 P 1973 TX C7C ISSICP7 ENVIROMENIAL CXJ 7250002077 Totals for Check: 6154 3225 US Bank Voyager Fleet Systems 869338111004 3225 US Bank Voyager Fleet Systems 869338111004 Totals for Check: 6155 2634 Valley Solvent Oam4,any, INC 51846 Totals for Check: 6156 2943 JP443RGAN (BASE BANK NA 2943 JPMORGAN CHASE BANK NA Totals for Check: 6157 Grand Totals: ****** Ehd of Report ********* 01/26/2020 01272020 01/24/20 P 01/24/20 P 20 135-55135-020-000 20 135-55135-020-000 20 135-69005-020-000 20 135-55080-020-000 20 135-69005-020-000 20 135-69005-020-000 135-21317-000-000 20 135-60100-020-000 10 135-60135-010-000 10 135-65005-010-000 20 135-65005-020-000 Trophy Club MOD NO.1 er209Vgary x,:2920 Regular Meeting Agenda flet 8 AP Checks For Date/Amxmt Range .00 To Amt: 99,999,999.99 Description Lab Analysis Lab Analysis Capital Outlays Maintenance & Repairs Capital Outlays Capital Outlays Travel & per diem TCI Fees & Permits Et:el & Lute E1eel & Lam 01/20/20 P 20 135-65030-020-000 Chemicals 01/26/20 P 01/27/20 P 135-20060-000-000 Procurement Clearing 135-20060-000-000 Procurement Clearing 12 of 155 JnnP item (],ecK merit Value Number Date 161:83 341.55 6148 01/30/20 241.50 6148 01/30/20 583.05 50,394.70 6149 01/30/20 50,394.70 459.00 6150 01/30/20 459.00 187.41 6151 01/30/20 1,074.13 6151 01/30/20 1,261.54 7,666.92 6152 01/30/20 7,666.92 04.13 6153 01/30/20 04.13 50.00 6154 01/30/20 50.00 1,140.42 6155 01/30/20 625.22 6155 01/30/20 1,765:64 717.50 6156 01/30/20 717.50 4,078.66 6157 01/30/20 542.43 6157 01/30/20 4,621.09 868,901.28 February 17, 2020 Regular Meeting Agenda Packet REGULAR MEETING MINUTES TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 BOARD OF DIRECTORS JANUARY 20, 2020 at 6:30 P.M. Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in a regular session meeting on Monday, January 20, 2020 at 6:30 P.M., in the Boardroom of the Administration Building, 100 Municipal Drive, Trophy Club, Texas 76262. The meeting was held within the boundaries of the District and was open to the public. STATE OF TEXAS § COUNTIES OF DENTON AND TARRANT § BOARD MEMBERS PRESENT: Gregory Wilson William C. Rose Steve Flynn Kelly Castonguay Mark Chapman STAFF PRESENT: John Carman Laurie Slaght Mike McMahon Steven Krolczyk Frank Isola Tony Corbett President Vice President Secretary/Treasurer Director Director General Manager District Secretary Operations Manager Finance Manager Wastewater Superintendent Legal Counsel GUESTS PRESENT: Susan LaFollett with LaFollett & Company, PLLC. CALL TO ORDER AND ANNOUNCE A QUORUM President Wilson announced the date of January 20, 2020, stated a quorum was present and called the meeting to order at 6:30 p.m. CITIZEN COMMENTS Brock Harwell 55 Sonora Drive (Agenda Item #2) CONSENT AGENDA 1. Consider and take appropriate action to approve the Consent Agenda. a. b. c. d. December 2019 Check Register December 16, 2019 Regular Meeting Minutes Quarterly Investment Report — 15t Quarter FY2020 Tax Collections Report — 1' Quarter FY2020 Motion made by Director Flynn and seconded by Director Chapman to approve the Consent Agenda. Motion carried unanimously 13 of 155 February 17, 2020 Regular Meeting Agenda Packet REGULAR SESSION 2. Discussion and possible action regarding sewer line break at 55 Sonora Drive and request for District payment for related repairs and damages. General Manager John Carman provided a timeline of events that occurred at 55 Sonora Drive as well as a video showing the line. Mr. Brock Harwell who resides at 55 Sonora Drive stated that he had 3 plumbers to his home to look at the line and they all stated the line break was on the District side. Discussion ensued regarding the location of the line dislocation and the most cost effective way to make that determination. Attorney Corbett would like to discuss the legal implications related to this matter with the Board in Executive Session. The General Manager will follow up with the homeowners following the meeting. This item is Tabled for further discussion in Executive Session. ** 3. Receive update from the Audit Committee. (Rose/Wilson) Director Rose and Director Wilson met with the auditor and reviewed the report and the adjustments made to the audit. 4. Consider and take appropriate action to accept the Fiscal Year 2019 Annual Financial Audit performed by LaFollet & Company, PLLC. Susan LaFollett with LaFollett & Company, PLLC., provided the findings of the 2019 audit. The District received an Unmodified Audit Opinion "Clean Audit" and no deficiencies or material weaknesses were noted. The audit identified no material misstatements and found no unexplainable transactions. There were 6 audit adjustments made. The only material adjustments identified by the audit firm related to the new debt and pension balances. Ms. LaFollet stated that Finance Manager, Steven Krolczyk and the Finance Department as well as the Audit Committee did a great job. The Board commended staff for their work. Motion made by Director Flynn and seconded by Director Rose to accept the Fiscal Year 2019 Annual Financial Audit performed by LaFollet & Company, PLLC. Motion carried unanimously 5. Consider and take appropriate action to approve Contract No. 2020012001 with Rey -Mar Construction for construction of a building and installation of a sound mitigation improvements at the wastewater treatment plant. 14 of 155 February 17, 2020 Regular Meeting Agenda Packet Motion made by Director Rose and seconded by Director Flynn to approve Contract No. 2020012001 with Rey -Mar Construction for construction of a building and installation of a sound mitigation improvements at the wastewater treatment plant for an amount not to exceed $75,000 and authorize the general manager to make necessary actions required for this project Motion to amend by Director Rose and seconded by Director Flynn to fund the project out of undesignated reserve funds. Amendment withdrawn by the first and the second Motion to amend the made by Director Rose and seconded by Director Flynn to fund the project out of contributions to funds that are going to the reserve fund. Motion to approve the amendment carried unanimously Motion as amended carried unanimously 6. Consider and take appropriate action regarding approval of bid and award Contract No. 2020012002 for 20 inch Valve Replacement to include Line Stop at Trophy Club Drive and Oak Hill Drive as part of Fiscal Year 2020 Capital Improvement projects. Motion made by Director Rose and seconded by Director Chapman to award Contract No. 2020012002 to Rey -Mar Construction for 20 inch Valve Replacement to include Line Stop at Trophy Club Drive and Oak Hill Drive for an amount not to exceed $69,874.48 and to fund the project out of Fiscal Year 2020 Capital Improvements and authorize the General Manager to execute necessary documents. Motion carried unanimously 7. Consider and take appropriate action regarding approval of change orders submitted by Rey -Mar Construction for the High Service Pump Station project: a. Change Order #2 Lower short circuit rating pump 1 $28,716.45 b. Change Order #4 32" OD Flange Leveling $9,285.53 Mike McMahon, Operations Manager stated that Change Order #2 would be brought back to the Board for consideration as a FY 2021 Capital Improvement Project and asked the Board to consider Change Order #4 at this time. Motion made by Director Chapman and seconded by Director Flynn to approve Change Order #4 submitted by Rey -Mar Construction for the High Service Pump Station project 32" OD Flange Leveling for an amount not to exceed $9,285.53 and to fund the projected out of allocated reserve funds. Motion carried unanimously Board Recessed from 7:53 p.m. to 7:57 p.m. 15 of 155 February 17, 2020 Regular Meeting Agenda Packet 8. Discussion and Action Regarding Adoption of Resolution 2020-0120A Authorizing the Acquisition of Real Property by Purchase or Condemnation, including Consideration of the Use of Eminent Domain to Condemn Property, and Containing Other Matters Related Thereto, for Purposes of Acquiring Easements Required for the Construction and Operation of Water Transmission Line Improvements from the District Pump Station to the Elevated Water Tank Located on T.W. King Road. Trophy Club Municipal Utility District No. 1 (the "District") must acquire certain parcels, easements and/or related property interests from real estate in Trophy Club, Denton and Tarrant County, Texas in connection with the construction and operation of new public water transmission lines. If, for any reason, a negotiation to acquire a parcel reaches an impasse, the District intends to use its power of eminent domain to condemn the following property: a. Parcel 2(a), an easement taking of 0.0054 acres, from 0.0793 acres of real estate, owned by the County of Denton, Trustee, and located along the southern line of Indian Creek Drive, just east of Troon Drive, Denton County, Texas; b. Parcel 2(b), an easement taking of 0.0695 acres, from 0.43 acres of real estate, owned by Citibank, N.A., and located northeast of the intersection of Davis Blvd and the north frontage road of State Highway 114, Tarrant County, Texas; and c. Parcel 6, an easement taking of 0.0693 acres, from 2.925 acres of real estate, owned by Trophy Lodging, Ltd., and located at 2900 State Highway 114, Trophy Club, TX 76262, Tarrant County, Texas. Motion made by Director Chapman and seconded by Director Rose to move that the Board of Directors of Trophy Club Municipal Utility District Number 1, authorize the use of the power of eminent domain to acquire an easement interest in the following properties located in Trophy Club, Tarrant and Denton County, Texas: • Parcel 2(a), an easement taking of 0.0054 acres, from 0.0793 acres of real estate, owned by the County of Denton, Trustee, and located along the southern line of Indian Creek Drive, just east of Troon Drive, Denton County, Texas; • Parcel 2(b), an easement taking of 0.0695 acres, from 0.43 acres of real estate, owned by Citibank, N.A., and located northeast of the intersection of Davis Blvd and the north frontage road of State Highway 114, Tarrant County, Texas; and • Parcel 6, an easement taking of 0.0693 acres, from 2.925 acres of real estate, owned by Trophy Lodging, Ltd., and located at 2900 State Highway 114, Trophy Club, Texas 76262, Tarrant County, Texas; with each aforementioned parcel being necessary for the construction, operation, and maintenance of water lines from the district Pump Station to the Elevated Water Tank located on T.W. King Road. My motion includes approval of the proposed Resolution 2020-0120A, and the first record vote on this matter applies to all units of property to be condemned. Motion carried unanimously 9. Consider and take appropriate action to approve matters related to May 2, 2020 General Election: a. Adopt Order No. 2020-0120A calling the May 2, 2020 General Election b. Approve Notice of Appointment of Agent 16 of 155 February 17, 2020 Regular Meeting Agenda Packet c. Authorize General Manager to sign and execute all necessary documents relating to the election d. Adopt Resolution No. 2020-0120B adopting the new Hart Verity Voting System for District Elections conducted in Tarrant County, Texas e. Authorize other necessary actions as may be necessary or convenient for conducting the May 2, 2020 General Election Motion made by Director Rose and seconded by Director Castonguay to Adopt Order No. 2020-0120A calling the May 2, 2020 General Election; Approve Notice of Appointment of Agent; Authorize General Manager to sign and execute all necessary documents relating to the election; Adopt Resolution No. 2020- 0120B adopting the new Hart Verity Voting System for District Elections conducted in Tarrant County, Texas; and Authorize other necessary actions as may be necessary or convenient for conducting the May 2, 2020 General Election Motion carried unanimously 10. Discussion and possible action regarding the assignment of undesignated reserve funds. Steven Krolczyk, Finance Manager reviewed current reserve funds. The Finance Manager will bring back updated information on reserve allocations in April for Board action. 11. Consider and take appropriate action regarding the December 2019 Combined Financials and Variance Report. a. Combined Financials b. Combined Variance Motion made by Director Flynn and seconded by Director Chapman to approve the December 2019 Combined Financials and Combined Variance Reports. Motion carried unanimously 12. Discussion and possible action regarding approval of Third Amendment to Independent Contractor Agreement with John Carman for General Manager services relating to compensation. (Chapman) The Board would like to have Carman turn over the day to day obligations of the District to staff and for him to take on a limited scope of duties. (Litigation, Completion of the wastewater treatment plant, Computerized Maintenance Management Software "CMMS", and GIS) Carman stated that Mike McMahon, Operations Manager is the Acting General Manager in his absence. Attorney Corbett will write up a new employment agreement for Carman as a separate agreement for the next meeting. Motion made by Director Chapman and seconded by Director Flynn to approval of Third Amendment to 17 of 155 February 17, 2020 Regular Meeting Agenda Packet Independent Contractor Agreement with John Carman for General Manager services relating to compensation. Motion carried unanimously 13. Discussion and possible action regarding search for General Manager candidates. (Castonguay/Flynn) a. Receive report from General Manager Hiring Committee. b. Review and approval of candidate search materials to be utilized by executive search firm. c. Other action related thereto. Director Flynn asked the Board to review the documents that were prepared by SGR and send their edits to the District Secretary by end of day on Tuesday, January 21, 2020. The final edits will then be documented and sent to SGR for publication. REPORTS & UPDATES 14. General Manager Monthly Reports and Update: a. Regulatory Update b. Capital Improvement Projects • Interconnect Water Transmission Line Phase 2 • 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 • Permits Collected • Cash Report Finance Software Update g. General Manager John Carman presented his monthly reports to the Board and answered questions related thereto. The Board convened into Executive Session at 9:04 p.m. EXECUTIVE SESSION 15. 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). 18 of 155 February 17, 2020 Regular Meeting Agenda Packet 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. Discussion and possible action regarding sewer line break at 55 Sonora Drive and request for District payment for related repairs and damages** 16. 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 17. Pursuant to Section 551.074 of the Texas Government Code (Texas Open Meetings Act), the Board of Directors may deliberate the employment of a new General Manager. The Board reconvened into Regular Session at 10:00 P.M. REGULAR SESSION 18. Consider and take appropriate action on matters deliberated in Executive Session: No final actions, deliberations, decisions or votes were made in Executive Session 19. Items for future agendas: Presentation regarding Hard Water & Sedimentation in District water and does the MUD have a plan regarding addressing it and solutions for it. (Rose) 20. Set future Meeting dates - Regular Board Meeting on February 17, 2020 at 6:30 p.m. ADJOURN President Wilson called the meeting adjourned at 10:04 p.m. Gregory Wilson, President Steve Flynn, Secretary/Treasurer Laurie Slaght, District Secretary 19 of 155 (SEAL) February 17, 2020 Regular Meeting Agenda Packet FOURTH AMENDMENT TO INDEPENDENT CONTRACTOR AGREEMENT This Fourth Amendment to Independent Contractor Agreement ("Amendment") is entered into between Trophy Club Municipal Utility District No. 1 (the "District") and John Robert Carman ("Contractor") as of the 5th day of February, 2020 (the "Effective Date"). The District and Contractor are collectively referred to as the "Parties" under this Agreement. Recitals WHEREAS, the District and Contractor entered into that certain "Independent Contractor Agreement" effective August 1, 2017 (the "Agreement") setting forth the terms and conditions pursuant to which the Contractor agreed to provide certain services as general manager for the District under an independent contractor relationship; and WHEREAS, the Parties entered into that certain "First Amendment to Independent Contractor Agreement" effective September 28, 2017 (the "First Amendment") in order to amend certain authority of the Contractor under the Agreement; entered into that certain "Second Amendment to Independent Contractor Agreement" effective August 1, 2018 in order to amend provisions relating to the compensation payable to the Contractor and reimbursement of expenses for authorized services (the "Second Amendment"); and entered into that certain "Third Amendment to Independent Contractor Agreement effective January 20, 2020 (the "Third Amendment") in order to further revise the compensation provisions of the Agreement; and WHEREAS, Contractor has advised the District that he intends to terminate services under the Agreement, and the District has commenced a search for retaining a new General Manager; WHEREAS, the District has appointed Mike McMahon ("Acting General Manager") as the Acting General Manager of the District; and WHEREAS, the Parties desire to amend the Agreement, as previously amended, in order to amend the scope of services to be provided by Contractor to provide for the transition of General Manager services from Contractor to the Acting General Manager and his successors. NOW, THEREFORE, in consideration of the following terms, covenants, and conditions contained herein, the sufficiency of which are hereby acknowledged, the District and Contractor agree as follows: Section 1. Scope of Services. Article I of the Agreement, as previously amended, is hereby deleted and replaced in its entirety with the following: "Section 1.1 Engagement of Independent Contractor. The District hereby engages Contractor to provide the consulting services more particularly described in Exhibit "A" attached hereto (the "Services"). The Services shall be performed only on an as -needed basis and as requested by the Acting General Manager or other authorized representatives of the District from time to time. Contractor acknowledges and agrees that this Agreement 20 of 155 February 17, 2020 Regular Meeting Agenda Packet is non-exclusive, and that the District may utilize the services of its employees or other consultants to provide some or all of the same services to be rendered by Contractor." Section 2. Capitalized Terms. Except as specifically defined herein, all capitalized terms in this Amendment shall have the meanings set forth in the Agreement, as previously amended. Section 3. Effect on Agreement. Except as specifically modified by this Amendment, all terms and conditions of the Agreement, as previously amended, shall remain in full force and effect. IN WITNESS WHEREOF, the Parties hereto have caused this instrument to be signed, sealed and attested in duplicate by their duly authorized officers, as of the Effective Date. Lu Secretary TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 By: Name: Title: Gregory Wilson President, Board of Directors Date: 07 jc b aDa-Z CONTRACTOR: n Robert Carman Date: 2. z6'2_v 21 of 155 February 17, 2020 Regular Meeting Agenda Packet Exhibit "A" Scope of Services General: Contractor shall no longer serve as the General Manager of the District, shall not have any of the powers, duties or authority of the General Manager under the rules and policies of the District, and the Acting General Manager of the District shall assume all such duties, authority and responsibilities in lieu of Contractor. Contractor shall provide general consulting services to the District regarding the following matters on an as -needed and requested basis (the "Services"): 1. Completion of the District's wastewater treatment plant improvement project and resolution of all outstanding contractual disputes with the project contractor; 2. Litigation support to the District, including providing testimony as requested by the District's litigation counsel or Acting General Manager, with respect to the following proceeding: 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); 3. Support to the District's condemnation counsel in connection with waterline easement acquisition; 4. Implementation of the District's Computer Maintenance Management System (CMMS) as requested by the Acting General Manager; 5. Implementation of the District's GIS mapping system as requested by the Acting General Manager; 6. Finalize and advertise a Request for Proposal for a Master Plan; and 7. Other tasks as may be requested by the Acting General Manager or Board of Directors, and accepted by Contractor, from time to time. Meetings: Subject to availability, Contractor shall attend future meetings of the Board of Directors on an as -requested basis. Attendance at Administrative Office: Contractor shall no longer be required to come to the District's administrative office to provide Services except as requested by the Acting General Manager or required for the Services. Management of Services and Compensation: To the maximum extent practicable, Contractor shall communicate the anticipated hours of individual tasks to, and receive approval from, the Acting General Manager in advance of performance of authorized Services to manage costs of the District. 3 22 of 155 February 17, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 REQUEST FOR QUALIFICATIONS WATER, WASTEWATER, AND FACILITY MASTER PLANNING AND RISK AND RESILIENCY ASSESSMENT Trophy Club Municipal Utility District No. 1 requests statements of qualification from consultants for the purpose of updating their Water Master Plan, developing their Wastewater Collection and Facility Master Plans, as well as a Risk and Resiliency Assessment in conformance with the American Water Infrastructure Act of 2018. Kev Proiect Tasks Water, Wastewater, and Facilities Master Plan: • Review of existing reports including associated Capital Improvements Plans • Perform temporary wastewater flow • Perform fire flow testing • Evaluate wholesale water p • Evaluate commercial a • Evaluate existing waste plan update • Develop, cali► e, and hyo. lic m deficiencies • Perform an asses e wastewater treatment facility • Perform an assessme . d pump performance testing on lift station facilities • Perform an assessment and pump performance testing on pump station facilities • Recommend CIP for the next 20 years in five-year increments tewater, and Facilities Plans and oundwater production data er water usage and billing data hat have been developed since the last master odel simulations to evaluate existing and future Risk and Resiliency Assessment: • Review of existing District policies, condition assessment(s) and emergency response plan(s) • Conduct a Risk and Resiliency Assessment (RRA) per AWWA J100 standards • Aid District in certifying RRA to the Environmental Protection Agency (EPA) • Perform Emergency Response Plan (ERP) updates in conformance with the RRA • Aid District in certifying ERP to the EPA 6 months after RRA submittal 23 of 155 February 17, 2020 Regular Meeting Agenda Packet GENERAL QUALIFICATION REQUIREMENTS: All submissions in response to this RFQ should comply with the requirements as described herein, and shall include the following items: • Packet Submittal: Firms must submit a qualification packet meeting the requirements contained herein. The submittal packet shall be no more than twenty (81/2" x 11") pages in length, and shall introduce the project team, detail the applicable experience of the firm, team, and sub -consultants and how that experience will benefit Trophy Club Municipal Utility District No. 1 on the identified project, provide applicable references, and provide a project schedule. Transmittal letters (not counted as one of the twenty pages), if desired, shall not exceed one page. Required resumes (See Proiect Team and Key Professional Member Resumes below) are also required. Hard covers, binders and brochures are discouraged. Each submittal shall include eight copies of e qualification packet for the identified project plus one electronic copy addressed to. Greg Wilson, Board President Attn: Laurie Slaght, District Secretary Trophy Club Municipal Utility Distr 100 Municipal Drive, Trophy Club, lslaght@tcmud.org RFQs should be sealed in envelope m submission of written propos. unles 2020 at 4:00 p.m. Deliver s ld b received after this date Once the plannin the final scope is anticipate o. 1 ASTERPLAN'. The deadline for ise tated in the RFQ) is Friday March 20, ade to the address shown above. Submittals on -responsive. ted by the Board of Directors, the District plans to negotiate orporate that fee into the FY2021 budgeting process. It wi .egin on October 1, 2020 o Proiect Te. an. ev Professional Member Resumes: Provide an organization chart showin_ ' members listed by name and responsibility. Resumes of key personnel of the project team and their respective backgrounds, experience, and project responsibilities must be provided. Professional member resumes (not to exceed 2 pages per person) may be attached as an appendix (not to exceed 25 pages in addition to the 20 -page submittal packet). o Proiect Understanding and Approach: The proposal shall establish the objectives for the Project and contain a description of the Consultant's project management and technical approach to meet these objectives. o Experience with Related Studies and References: Provide a record of three studies similar in size and scope to this project and completed within the past ten years in the State of Texas. Each referenced project shall include names, telephone numbers, and emails of responsible individuals who may be contacted as references. 24 of 155 February 17, 2020 Regular Meeting Agenda Packet o Conflict of Interest Disclosure Requirement: Pursuant to Chapter 176 of the Local Government Code, any person or agent of a person who contracts or seeks to contract for the sale or purchase of property, goods, or services with a local governmental entity (i.e. Trophy Club Municipal Utility District No. 1) must disclose in the Questionnaire Form CIQ included in Appendix "A" ("Questionnaire") the person's affiliation or business relationship that might cause a conflict of interest with the local governmental entity. By law, the Questionnaire must be filed with the District Secretary no later than seven days after the date the person begins contract discussions or negotiations with the District, or submits an application or response to a request for proposals or bids, correspondence, or another writing related to a potential agreement with the District. Updated Questionnaires must be filed with the District Secretary in conformance with Chapter 176. The form is also available at https://www.ethics.state.tx.us/data/forms/confli IO.ndf. If you have any questions about compliance, please consult your 'n legal counsel. Compliance is the individual responsibility of each person • = of a person who is subject to the filing requirement. An offense under Ji. pter s a Class C misdemeanor. FURTHER INFORMATION: All interested firms desiring any further in an e-mail to lslaghtatcmud.org with subj Additional Information" to guarant eceip addendums. For information or io one email or phone at 682-831-460 ums or Clarifications, should send ASTERPLAN Request for any dditi • nal information, clarifications and/or ng the RFQ process, contact Laurie Slaght by 25 of 155 February 17, 2020 Regular Meeting Agenda Packet THE STATE OF TEXAS COUNTY OF DENTON JOINT ELECTION AGREEMENT AND CONTRACT FOR ELECTION SERVICES This CONTRACT for election services is made by and between the Denton County Elections Administrator and the following political subdivisions, herein referred to as "participating authority or participating authorities" located entirely or partially inside the boundaries of Denton County: Participating Authorities: [entities] This contract is made pursuant to Texas Election Code Sections 31.092 and 271.002 and Texas Education Code Section 11.0581 for a joint [election -date] election to be administered by Frank Phillips, Denton County Elections Administrator, hereinafter referred to as "Elections Administrator." RECITALS Each participating authority listed above plans to hold a General or Special Election on May 2, 2020. Denton County plans to hold county -wide voting for this General Election. The County owns the Hart InterCivic Verity Voting System, which has been duly approved by the Secretary of State pursuant to Texas Election Code Chapter 122 as amended and is compliant with the accessibility requirements for persons with disabilities set forth by Texas Election Code Section 61.012. The contracting political subdivisions (participating authorities) desire to use the County's voting system and to compensate the County for such use and to share in certain other expenses connected with joint elections, in accordance with the applicable provisions of Chapters 31 and 271 of the Texas Election Code, as amended. NOW THEREFORE, in consideration of the mutual covenants, agreements, and benefits to all parties, IT IS AGREED as follows: I. ADMINISTRATION The participating authorities agree to hold a "Joint Election" with Denton County and each other in accordance with Chapter 271 of the Texas Election Code and this agreement. The Elections Administrator shall coordinate, supervise, and handle all aspects of administering the Joint Election as provided in this agreement. Each participating authority agrees to pay the Elections Administrator for equipment, supplies, services, and administrative costs as provided in this agreement. The Elections Administrator shall serve as the administrator for the Joint Election; however, each participating authority shall remain responsible for the decisions and actions of its officers necessary for the lawful conduct of its election. The Elections Administrator shall provide advisory services in connection with decisions to be made and actions to be taken by the officers of each participating authority as necessary. 26 of 155 February 17, 2020 Regular Meeting Agenda Packet It is understood that other political subdivisions may wish to participate in the use of the County's Verity voting system and polling places, and it is agreed that the Elections Administrator may enter into other contracts for election services for those purposes, on terms and conditions generally similar to those set forth in this contract. In such cases, costs shall be pro -rated among the participants according to Section XI of this contract. II. LEGAL DOCUMENTS Each participating authority shall be responsible for the preparation, adoption, and publication of all required election orders, resolutions, notices, and any other pertinent documents required by the Texas Election Code and/or the participating authority's governing body, charter, or ordinances, except that the Elections Administrator shall be responsible for the preparation and publication of all voting equipment testing notices that are required by the Texas Election Code. Election orders should include language that would not necessitate amending the order if any of the Early Voting and/or Election Day polling places change. Preparation of the necessary materials for notices and the official ballot shall be the responsibility of each participating authority, including translation to languages other than English. Each participating authority shall provide a copy of their respective election orders and notices to the Elections Administrator. III. VOTING LOCATIONS The Elections Administrator shall select and arrange for the use of and payment for all Early Voting and Election Day voting locations. Voting locations will be, whenever possible, the usual voting location for each election precinct in elections conducted by each participating authority, and shall be compliant with the accessibility requirements established by Election Code Section 43.034 and the Americans with Disabilities Act (ADA). All Early Voting and Election Day voting locations shall be within the boundaries of Denton County. The proposed voting locations are listed in Exhibit A of this agreement. In the event a voting location is not available or appropriate, the Elections Administrator will arrange for use of an alternate location. The Elections Administrator shall notify the participating authorities of any changes from the locations listed in Exhibit A. If polling place(s) for the [election -date] joint election are different from the polling place(s) used by a participating authority in its most recent election, the authority agrees to post a notice no later than May 1st, 2020 at the entrance to any previous polling places in the jurisdiction stating that the polling location has changed and stating the political subdivision's polling place names, addresses, and room or suite number, if applicable, in effect for the [election -date] election. This notice shall be written in both the English and Spanish languages. IV. ELECTION JUDGES, CLERKS, AND OTHER ELECTION PERSONNEL Denton County shall be responsible for the appointment of the presiding judge and alternate judge for each polling location. The Elections Administrator shall make emergency appointments of election officials if necessary. 27 of 155 February 17, 2020 Regular Meeting Agenda Packet Upon request by the Elections Administrator, each participating authority agrees to assist in recruiting polling place officials who are bilingual (fluent in both English and Spanish). In compliance with the Federal Voting Rights Act of 1965, as amended, each polling place containing more than 5% Hispanic population as determined by the 2010 Census shall have one or more election officials who are fluent in both the English and Spanish languages. If a presiding judge is not bilingual, and is unable to appoint a bilingual clerk, the Elections Administrator may recommend a bilingual worker for the polling place. If the Elections Administrator is unable to recommend or recruit a bilingual worker, the participating authority or authorities served by that polling place shall be responsible for recruiting a bilingual worker for translation services at that polling place. The Elections Administrator shall notify all election judges of the eligibility requirements of Subchapter C of Chapter 32 of the Texas Election Code, and will take the necessary steps to insure that all election judges appointed for the Joint Election are eligible to serve. The Elections Administrator shall arrange for the training and compensation of all election judges and clerks. The Election judges and clerks who attend in-person voting equipment training and/or procedures training, shall be compensated at the rate of $10 an hour. Election judges and clerks that elect to complete online training shall be compensated as a rate of a flat $30. In the event that as Election judge or clerk completes both in-person and online training, they shall be compensated for the training resulting in the highest pay and will not be compensated for both trainings. The Elections Administrator shall arrange for the date, time, and place for presiding election judges to pick up their election supplies. Each presiding election judge will be sent a letter from the Elections Administrator notifying them of their appointment, the dates/times and locations of training and distribution of election supplies, and the number of election clerks that the presiding judge may appoint. Each election judge and clerk will receive compensation at the hourly rate established by Denton County pursuant to Texas Election Code Section 32.091. The election judge, or their designee, will receive an additional sum of $25.00 for picking up the election supplies and equipment prior to Election Day and for returning the supplies and equipment to the central counting station after the polls close. Likewise, the Lead Clerk in Early Voting, or their designee, will receive an additional sum of $25.00 for picking up the election supplies prior to the first day of Early Voting and for returning the supplies and equipment to the Elections Department after Early Voting has ended. The compensation rates established by Denton County are: Early Voting — Lead Clerk ($12/hour), Clerk ($10/hour) Election Day — Presiding Judge ($12/hour), Alternate Judge ($11 /hour), Clerk ($10/hour) The Elections Administrator may employ other personnel necessary for the proper administration of the election, as well as, pre and post-election administration. In such cases, costs shall be pro - 28 of 155 February 17, 2020 Regular Meeting Agenda Packet rated among participants of this contract. Part-time help is included as is necessary to prepare for the election, to ensure the timely delivery of supplies during Early Voting and on Election Day, and for the efficient tabulation of ballots at the central counting station. Part-time personnel working in support of the Early Voting Ballot Board and/or central counting station on election night will be compensated at the hourly rate set by Denton County in accordance with Election Code Sections 87.005, 127.004, and 127.006. If elections staff is required outside of the hours of the office's normal scope of business, the entity(ies) responsible for the hours will be billed for those hours. The Elections Administrator will determine when those hours are necessary, the number of staff and whom are necessary, along with to whom the hours are to be billed. Cost for these hours will be billed at a rate of 1.5 times the staffs hourly rate (See Sections XV #10). The Election Administrator has the right to waive these costs as they see fit. V. PREPARATION OF SUPPLIES AND VOTING EQUIPMENT The Elections Administrator shall arrange for all election supplies and voting equipment including, but not limited to, the County's Verity voting system and equipment, official ballots, sample ballots, voter registration lists, and all forms, signs, maps and other materials used by the election judges at the voting locations. The Elections Administrator shall ensure availability of tables and chairs at each polling place and shall procure rented tables and chairs for those polling places that do not have tables and/or chairs. Any additional required materials (required by the Texas Election Code) must be provided by the Participating Authority and delivered to the Elections Office thirty-three (33) calendar days (March 30, 2020) prior to Election Day. If this deadline is not met, the material must be delivered by the participating authority, to all Early Voting and Election Day locations affected, prior to voting commencing. The Elections Administrator shall be responsible for conducting all required testing of the voting equipment, as required by Chapters 127 and 129 of the Texas Election Code. At each polling location, joint participants shall share voting equipment and supplies to the extent possible. The participating authorities shall share a mutual ballot in those precincts where jurisdictions overlap. Multiple ballot styles shall be available in those shared polling places where jurisdictions do not overlap. The Elections Administrator shall provide the necessary voter registration information, maps, instructions, and other information needed to enable the election judges in the voting locations that have more than one ballot style to conduct a proper election. Each Participating Authority shall furnish the Elections Administrator a list of candidates and/or propositions showing the order and the exact manner in which the candidate names and/or proposition(s) are to appear on the official ballot (including titles and text in each language in which the authority's ballot is to be printed). Said list must be provided to the Elections Office within three (3) business days following the last day to file for a place on the ballot or after the election is ordered, whichever is later. Said list must be in a Word document, the information must be in an upper and lower case format, be in Arial 12 point font, and contain candidate contact information for the purposes of verifying the pronunciation of each of the candidates' names. Each participating authority shall be responsible for proofreading and approving the ballot insofar as it pertains to that authority's candidates and/or propositions. Each 29 of 155 February 17, 2020 Regular Meeting Agenda Packet participating authority shall be responsible for proofing and approving the audio recording of the ballot insofar as it pertains to that authority's candidates and/or propositions. The approvals must be finalized with the Elections Office within five (5) calendar days of receipt of the proofs, or the provided proofs shall be considered approved. The joint election ballots shall list the County's election first. The joint election ballots that contain ballot content for more than one joint participant because of overlapping territory shall be arranged with the appropriate school district ballot content appearing on the ballot following the County's election, followed by the appropriate city ballot content, and followed by the appropriate water district or special district ballot content. Early Voting by Personal Appearance and on Election Day shall be conducted exclusively on Denton County's Verity voting system including provisional ballots. The Elections Administrator shall be responsible for the preparation, testing, and delivery of the voting equipment for the election as required by the Election Code. The Elections Administrator shall conduct criminal background checks on the relevant employees upon hiring as required by Election Code 129.051(g). VI. EARLY VOTING The participating authorities agree to conduct joint early voting and to appoint the Election Administrator as the Early Voting Clerk in accordance with Sections 31.097 and 271.006 of the Texas Election Code. Each participating authority agrees to appoint the Elections Administrator's permanent county employees as deputy early voting clerks. The participating authorities further agree that the Elections Administrator may appoint other deputy early voting clerks to assist in the conduct of early voting as necessary, and that these additional deputy early voting clerks shall be compensated at an hourly rate set by Denton County pursuant to Section 83.052 of the Texas Election Code. Deputy early voting clerks who are permanent employees of the Denton County Elections Administrator or any participating authorities shall serve in that capacity without additional compensation. Early Voting by personal appearance will be held at the locations, dates, and times listed in Exhibit B of this document. Any qualified voter of the Joint Election may vote early by personal appearance at any one of the joint early voting locations. All requests for Temporary Early Voting Locations will be considered and determined based on the availability of sites and if it is within the Election Code parameters. All costs for temporary sites including coverage by Election Administration staff will be borne by the requesting authority. The Elections Administrator will determine when those hours are necessary, the number of staff and whom are necessary, along with to whom the hours are to be billed. Cost for these hours will be billed at a rate of 1.5 times the staffs hourly rate (See Sections XV #10). The Election Administrator has the right to waive these costs as they see fit. As Early Voting Clerk, the Elections Administrator shall receive applications for early voting ballots to be voted by mail in accordance with Chapters 31 and 86 of the Texas Election Code. 30 of 155 February 17, 2020 Regular Meeting Agenda Packet Any requests for early voting ballots to be voted by mail received by the participating authorities shall be forwarded immediately by fax or courier to the Elections Administrator for processing. The address of the Early Voting Clerk is as follows: Frank Phillips, Early Voting Clerk Denton County Elections PO Box 1720 Denton, TX 76202 Email: elections@dentoncounty.com Any requests for early voting ballots to be voted by mail, and the subsequent actual voted ballots that are sent by a contract carrier (ie. UPS, FedEx, etc.) shall be delivered to the Early Voting Clerk at the Denton County Elections Department physical address as follows: Frank Phillips, Early Voting Clerk Denton County Elections 701 Kimberly Drive, Suite A101 Denton, TX 76208 Email: elections@dentoncounty.com The Elections Administrator shall post on the county website, the Participating Authority's Early Voting Roster on a daily basis. In accordance with Section 87.121 of the Election Code, the daily roster showing the previous day's early voting activity will be posted no later than 11:00 AM each business day. VII. EARLY VOTING BALLOT BOARD Denton County shall appoint the Presiding Judge of an Early Voting Ballot Board (EVBB) to process early voting results from the Joint Election. The Presiding Judge, with the assistance of the Elections Administrator, shall appoint two or more additional members to constitute the EVBB. The Elections Administrator shall determine the number of EVBB members required to efficiently process the early voting ballots. VIII. CENTRAL COUNTING STATION AND ELECTION RETURNS The Elections Administrator shall be responsible for establishing and operating the central counting station to receive and tabulate the voted ballots in accordance with the provisions of the Texas Election Code and of this agreement. The participating authorities hereby, in accordance with Section 127.002, 127.003, and 127.005 of the Texas Election Code, appoint the following central counting station officials: Counting Station Manager: Tabulation Supervisor: Presiding Judge: Alternate Judge: Brandy Grimes, Deputy Elections Administrator Jason Slonaker, Technology Resources Coordinator Early Voting Ballot Board Judge Early Voting Ballot Board Alternate Judge 31 of 155 February 17, 2020 Regular Meeting Agenda Packet The counting station manager or their representative shall deliver timely cumulative reports of the election results as precincts report to the central counting station and are tabulated by posting on the Election Administrator's Election Night Results website. The manager shall be responsible for releasing unofficial cumulative totals and precinct returns from the election to the joint participants, candidates, press, and general public by distribution of hard copies at the central counting station (if requested) and by posting to the Election Administrator's Election Night Results website. To ensure the accuracy of reported election returns, results printed on the tapes produced by Denton County's voting equipment will not be released to the participating authorities at the remote collection sites or by phone from individual polling locations. The Elections Administrator will prepare the unofficial canvass reports after all precincts have been counted and will deliver a copy of the unofficial canvass to each participating authority as soon as possible after all returns have been tabulated. The Elections Administrator will include the tabulation and precinct returns that are required by Texas Election Code Section 67.004 for the participating authorities to conduct their respective canvasses. Each participating authority shall be responsible for the official canvass of its respective election(s), and shall notify the Elections Administrator, or their designee, of the date of the canvass, no later than three days after Election Day. The Elections Administrator shall be responsible for conducting the post-election manual recount required by Section 127.201 of the Texas Election Code unless a waiver is granted by the Secretary of State. Notification and copies of the recount, if waiver is denied, will be provided to each Participating Authority for uploading, by each participating authority, to the Secretary of State's Office. IX. PARTICIPATING AUTHORITIES WITH TERRITORY OUTSIDE DENTON COUNTY Each participating authority with territory containing population outside of Denton County agrees that they Elections Administrator shall administer only the Denton County portion of those elections. X. RUNOFF ELECTIONS Each participating authority shall have the option of extending the terms of this agreement through its runoff election, if applicable. In the event of such runoff election, the terms of this agreement shall automatically extend unless the participating authority notifies the Elections Administrator in writing within three (3) business days of the original election. Each participating authorities shall reserve the right to reduce the number of early voting locations and/or Election Day voting locations in a runoff election. Each participating authority agrees to order any runoff election(s) at its meeting for canvassing the votes from the [election -date] election and to conduct its drawing for ballot positions at or immediately following such meeting in order to expedite preparations for its runoff election. 32 of 155 February 17, 2020 Regular Meeting Agenda Packet Each participating authority eligible to hold runoff elections agrees that the date of the runoff election, if necessary, shall be [run -off -date], with early voting being held in accordance with the Election Code. XI. ELECTION EXPENSES AND ALLOCATION OF COSTS The participating authorities agree to share the costs of administering the Joint Election. Allocation of the costs, unless specifically stated otherwise, is mutually agreed to be shared according to a formula which is based on the number of registered voters within the district per Elections Day polling place. Costs for polling places shared by more than one participating authority shall be pro -rated among the participants utilizing that polling place. It is agreed that the charges for Election Day judges and clerks and Election Day polling place rental fees shall be directly charged to the appropriate participating authority rather than averaging those costs among all participants. If a participating authority's election is conducted at more than one Election Day polling place, there shall be no charges or fees allocated to the participating authority for the cost of the Election Day polling place in which the authority has fewer than 50% of the total registered voters served by that polling place, except that if the number of registered voters in all of the authority's polling places is less than the 50% threshold, the participating authority shall pay a pro -rata share of the cost associated with the polling place where it has the greatest number of registered voters. Costs for Early Voting by Personal Appearance shall be allocated based upon the actual costs associated with each early voting site. Each participating authority shall be responsible for an equal portion of the actual costs associated with the early voting sites located within their jurisdiction. Participating authorities that do not have a regular (non -temporary) early voting site within their jurisdiction shall pay an equal portion of the nearest regular early voting site. Costs for Early Voting by mail shall be allocated according to the actual number of ballots mailed to each participating authority's voters. Each participating authority agrees to pay the Elections Administrator an administrative fee equal to ten percent (10%) of its total billable costs in accordance with Section 31.100(d) of the Texas Election Code. The Denton County Elections Administrator shall deposit all funds payable under this contract into the appropriate fund(s) within the county treasury in accordance with Election Code Section 31.100. The Denton County Elections Administrator reserves the right to adjust the above formulas in agreement with an individual jurisdiction if the above formula results in a cost allocation that is inequitable. 33 of 155 February 17, 2020 Regular Meeting Agenda Packet If any participating authority makes a special request for extra Temporary Branch Early Voting by Personal Appearance locations as provided by the Texas Election Code, that entity agrees to pay the entire cost for that request. Participating authorities having the majority of their voters in another county, and fewer than 500 registered voters in Denton County, and that do not have an Election Day polling place or early voting site within their Denton County territory shall pay a flat fee of $400 for election expenses. Election expenses, including but not limited to, overtime charges for Election Office staff, and any unforeseen expenses needed to conduct the election, will be borne by the participating authority or authorities, affected. XII. WITHDRAWAL FROM CONTRACT DUE TO CANCELLATION OF ELECTION Any participating authority may withdraw from this agreement and the Joint Election should it cancel its election in accordance with Sections 2.051 - 2.053 of the Texas Election Code. The withdrawing authority is fully liable for any expenses incurred by the Denton County Elections Administrator on behalf of the authority plus an administrative fee of ten percent (10%) of such expenses. Any monies deposited with the Elections Administrator by the withdrawing authority shall be refunded, minus the aforementioned expenses and administrative fees, if applicable. It is agreed that any of the joint election early voting sites that are not within the boundaries of one or more of the remaining participating authorities, with the exception of the early voting site located at the Denton County Elections Building, may be dropped from the joint election unless one or more of the remaining participating authorities agreed to fully fund such site(s). In the event that any early voting site is eliminated under this section, as addendum to the contract shall be provided to the remaining participants within five days after notification of all intents to withdraw have been received by the Elections Administrator. XIII. RECORDS OF THE ELECTION The Elections Administrator is hereby appointed general custodian of the voted ballots and all records of the Joint Election as authorized by Section 271.010 of the Texas Election Code. Access to the election records shall be available to each participating authority as well as to the public in accordance with applicable provisions of the Texas Election Code and the Texas Public Information Act. The election records shall be stored at the offices of the Elections Administrator or at an alternate facility used for storage of county records. The Elections Administrator shall ensure that the records are maintained in an orderly manner so that the records are clearly identifiable and retrievable. Records of the election shall be retained and disposed of in accordance with the provisions of Section 66.058 of the Texas Election Code. If records of the election are involved in any pending election contest, investigation, litigation, or open records request, the Elections Administrator shall maintain the records until final resolution or until final judgment, whichever is applicable. 34 of 155 February 17, 2020 Regular Meeting Agenda Packet It is the responsibility of each participating authority to bring to the attention of the Elections Administrator any notice of pending election contest, investigation, litigation or open records request which may be filed with the appropriate participating authority. XIV. RECOUNTS A recount may be obtained as provided by Title 13 of the Texas Election Code. By signing this document, the presiding officer of the contracting participating authorities agree that any recount shall take place at the offices of the Elections Administrator, and that the Elections Administrator shall serve as Recount Supervisor, and the participating authority's official or employee who performs the duties of a secretary under the Texas Election Code shall serve as Recount Coordinator. The Elections Administrator agrees to provide advisory services to each participating authority as necessary to conduct a proper recount. XV. MISCELLANEOUS PROVISIONS 1. It is understood that to the extent space is available, other districts and political subdivisions may wish to participate in the use of the County's election equipment and voting places, and it is agreed that the Elections Administrator may contract with such other districts or political subdivisions for such purposes and that in such event there may be an adjustment of the pro -rata share to be paid to the County by the participating authorities. 2. The Elections Administrator shall file copies of this document with the Denton County Treasurer and the Denton County Auditor in accordance with Section 31.099 of the Texas Election Code. 3. Nothing in this contract prevents any party from taking appropriate legal action against any other party and/or other election personnel for a breach of this contract or a violation of the Texas Election Code. 4. This agreement shall be construed under and in accord with the laws of the State of Texas, and all obligations of the parties created hereunder are performable in Denton County, Texas. 5. In the event that one of more of the provisions contained in this Agreement shall for any reason be held to be invalid, illegal, or unenforceable in any respect, such invalidity, illegality, or unenforceability shall not affect any other provision hereof and this agreement shall be construed as if such invalid, illegal, or unenforceable provision had never been contained herein. 6. All parties shall comply with all applicable laws, ordinances, and codes of the State of Texas, all local governments, and any other entities with local jurisdiction. 35 of 155 February 17, 2020 Regular Meeting Agenda Packet 7. The waiver by any party of a breach of any provision of this agreement shall not operate as or be construed as a waiver of any subsequent breach. 8. Any amendments of this agreement shall be of no effect unless in writing and signed by all parties hereto. 9. Failure for a participating authority to meet the deadlines as outline in this contract may result in additional charges, including but not limited to, overtime charges, etc. 10. Elections Staffing Hourly Rate (includes all benefit pay): Absentee Voting Coordinator Voter Registration Clerk Technology Resources Coordinator Elections Technician Voter Registration Coordinator Training Coordinator Election Coordinator $40.023 $31.883 $34.763 $43.277 $30.521 $34.763 $41.106 $41.899 $34.763 XVI. COST ESTIMATES AND DEPOSIT OF FUNDS The total estimated obligation for each participating authority under the terms of this agreement is listed below. The exact amount of each participating authority's obligation under the terms of this agreement shall be calculated after the [election -date] election (or runoff election, if applicable). The participating authority's obligation shall be paid to Denton County within 30 days after the receipt of the final invoice from the Denton County Elections Administrator. The total estimated obligation for each participating authority under the terms of this agreement shall be provided within 45 days after the last deadline for ordering an election: 36 of 155 February 17, 2020 Regular Meeting Agenda Packet THIS PAGE INTENTIONALLY BLANK. 37 of 155 February 17, 2020 Regular Meeting Agenda Packet XVII. JOINT CONTRACT ACCEPTANCE AND APPROVAL IN TESTIMONY HEREOF, this agreement has been executed on behalf of the parties hereto as follows, to -wit: (1) It has on the day of _ , 2020 been executed by the Denton County Elections Administrator pursuant to the Texas Election Code so authorizing; (2) It has on the 17th day of February 2020 been executed on behalf of Trophy Club Municipal Utility District No. 1 pursuant to an action of the Board of Directors so authorizing; ACCEPTED AND AGREED TO BY DENTON COUNTY ELECTIONS ADMINISTRATOR: APPROVED: 70,,,,,L Frank Phillips, CERA ACCEPTED AND AGREED TO BY TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1: APPROVED: ATTESTED: Gregory Wilson, Board President Laurie Slaght, District Secretary 38 of 155 February 17, 2020 Regular Meeting Agenda Packet ORDER NO. 2020-0217A ORDER DECLARING PROPERTY SURPLUS AND AUTHORIZING SALE THEREOF WHEREAS, Trophy Club Municipal Utility District No. 1 (the "District") is a conservation and reclamation district, a body corporate and politic and governmental agency of the State of Texas, created under Article XVI, Sec. 59 of the Texas Constitution by order of the Texas Water Commission, now the Texas Commission on Environmental Quality ("TCEQ"), and the District operates under Chapters 49 and 54 of the Texas Water Code, as amended; WHEREAS, Section 49.226 of the Texas Water Code provides that any personal property valued at more than $300 which is found by the board to be surplus and is not needed by the district may be sold under order of the board either by public or private sale; WHEREAS, the District owns the following equipment and vehicle that are no longer used or useful for the District's operations (the "Property"): 1. Truck No. 102 — 2012 Ford F250 king cab pick-up truck with 71,600 miles. 2. Dodge Truck bed 3. 2 Automatic transfer switches; and WHEREAS, the Board of Directors desires to declare the Property to be surplus and not needed by the District and further desires to authorize the sale thereof by public sale. NOW, THEREFORE, BE IT ORDERED BY THE BOARD OF DIRECTORS OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 THAT: Section 1. The facts and recitations in the preamble of this Order are hereby found and declared to be true and correct and are incorporated by reference herein and expressly made a part hereof, as if copied verbatim. Section 2. The Board of Directors of the District hereby finds and declares that the Property is surplus and not needed by the District. Section 3. The Board of Directors hereby orders and directs that the Property be sold at a public sale. Section 4. The General Manager is hereby authorized to take any and all actions necessary to effectuate this Order. Section 5. Upon adoption of this Order, an original Order shall be filed in the permanent records of the District. 39 of 155 February 17, 2020 Regular Meeting Agenda Packet ORDERED, PASSED AND APPROVED this 17th clay of February 2020. Gregory Wilson, President Steve Flynn, Secretary/Treasurer Laurie Slaght, District Secretary 40 of 155 (SEAL) February 17, 2020 Regular Meeting Agenda Packet DRAFT INTERLOCAL AGREEMENT BETWEEN THE CITY OF SOUTHLAKE AND THE TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 REGARDING SANITARY SEWER LINE ADJUSTMENTS CROSSING SH 114 This Interlocal Agreement (the "Agreement") for the Construction of certain Sanitary Sewer Line Adjustments made necessary by construction of improvements to State Highway 114 is made and entered into by and between the City of Southlake, Texas ("Southlake"), a municipal corporation located in Tarrant County, Texas, and the Trophy Club MUD No. 1, Texas ("the District"), a municipal utility district located in Denton County, Texas. Southlake and the District shall hereafter be collectively referred to as "the Parties." RECITALS WHEREAS, the Parties mutually desire -nter into terlocal agreement to undertake the adjustments to the exist' 10" d 12" nitary Sewer Line serving the District (the "Project") necessita b e construction of the SH 114 Frontage Road Improvements; and WHEREAS, Chapter 791, Te -nt Code, as amended (the "Act"), provides authorization • ocal nme is to contract with one another for the performance of gove t ' I fun ons and services under the terms of the Act; and WHEREAS such as Southla rnment" is defined to include both municipalities ricts such as the District; and WHEREA Southlake; and have need to construct the Project located in WHEREAS, due to the compelling urgency of the Project, the City of Southlake has previously contracted for Consulting Engineering Services related to the design of the Project; and WHEREAS, the Parties are required to provide financing for the Project; and WHEREAS, the costs of the design and construction of the Project are eligible for full reimbursement from the Texas Department of Transportation ("TxDOT") under a Reimbursement Agreement between the District and TxDOT; and 41 of 155 February 17, 2020 Regular Meeting Agenda Packet WHEREAS, the Parties are willing to cooperate with one another to accomplish the construction of the Project as provided in this Agreement; and WHEREAS, state law requires that a local government paying for the performance of governmental functions or services under this Agreement must make those payments from current revenues; and WHEREAS, it is mutually advantageous to both parties to enter into this Agreement: AGREEMENTS, TERMS AND CONDITIONS NOW, THEREFORE, for and in consideration of the mutual covenants, terms and conditions set forth herein, and the mutual b efits to each party, the receipt and sufficiency of which are hereby acknow ged, the Parties hereby contract, covenant, warrant and agree as follows: I. ADOPTION OF RECITALS All of the matters stated in the Recit t above are agreed to be true and correct and are hereby incorporated in e body of the Agreement by reference as though fully set forth in -.tiret ein. II. OBLIGATIONS OF TH 1. The District sha ave op• unity to review and approve the construction plans - • _ _ submittals. 2. The Parti = . gre. a • uthlake shall retain a General Contractor to construct the P -ct ands ma age all aspects of the contract with the General Contractor inclu• « Biddi ' ; Phase and Construction Phase Services, but excluding Construc In ction Services, which will be provided by the District. 3. The Parties agree that the General Contractor shall provide Performance and Payment Bonds in the full amount of the Project contract cost, to be issued naming Southlake as beneficiary. 4. The Parties agree that the General Contractor shall also provide a Maintenance Bond in the amount of 25% of the Project contract cost, to be issued naming the District as beneficiary. 5. The Parties agree that the General Contractor shall provide Insurance to the contracting party, Southlake, with the District named as an additional insured. 6. The Parties agree to fund the Project as follows: 42 of 155 February 17, 2020 Regular Meeting Agenda Packet a) The District shall reimburse Southlake for the District's proportionate share of the cost of all design services for the Project, including Bidding Phase Services, under an agreement for Engineering Services with Kimley Horn Engineers, said cost of which is agreed to be $16,645, plus 100% of the cost of any revisions necessitated by amendments that may arise in the future within five business days of receipt of request for payment from Southlake. b.) The District shall reimburse Southlake 100% of the estimated total cost for all construction for the Project, which the Parties estimate to be $172,000.00. The final cost shall be the actual construction contract final costs. 7. Southlake shall submit monthly bills to TxD construction costs of the Project with a copy p District shall sign their copy and forward to T of receipt to insure prompt processing by a OT. for the design and ided to the District. The ithin five business days 8. The Parties anticipate that TxDOT w of receipt of the bill. 9. The District agrees to mak transfer pursuant to instruction days of receiving its rei • • . rse 10. The Parties agree Services for the Pr 11. The Parti be in ac necessarl construction, rict within 30 days outhlake by electronic fund outhlake within five business nt from TxDOT. ill provide all Construction Inspection construction to be done within Southlake shall So hlake's Code of Ordinances including, but not providing proper barricades, traffic control during nd project clean up after the contractor is completed. INDEMNIFICATION AND HOLD HARMLESS 1. To the extent allowed by law, the District agrees to indemnify and hold Southlake harmless from any claim by a third party for damages arising from or resulting from the construction or maintenance of the improvements constituting the Project in accordance with terms set forth in this Agreement, or in any other way arising from any portion of the Project, including but not limited to any property damage or personal injuries, including death. 2. To the extent allowed by law, Southlake agrees to indemnify and hold the District harmless from any claim by a third party for damages arising from or resulting from the construction or maintenance of the improvements constituting the Project in accordance with terms set forth in this Agreement, or in any other 43 of 155 February 17, 2020 Regular Meeting Agenda Packet way arising from any portion of the Project, including but not limited to any property damage or personal injuries, including death. 3. The provisions of these indemnification and hold harmless provisions of this Agreement shall not apply to acts of gross negligence or willful misconduct by the indemnified party. 4. The indemnification provisions of this Agreement are solely for the benefit of the parties hereto and not intended to create or grant any rights, contractual or otherwise, to any other person or entity. 5. The provisions relating to indemnification and hold harmless contained herein shall not be deemed a waiver of any sovereign or governmental immunity or limitation on damages created or recogniz by any applicable law, including but not limited to Tex. Civ. Proc. & Rem. Co ection 101.001 et. seq. IV. NOTICES Any notice required to be given and have been adequately given if deposited in with sufficient postage and properly addresse eements`hall be deemed to ed States mail in an envelope the other party as follows: TO SOUTHLAKE: ESTLAKE: City of Southlake 1400 Main Street Southlake, Texas 76092 Attention: City Man Notice o ten (10) days aft provision. Trophy Club MUD No. 1 100 Municipal Drive Trophy Club, Texas 76262 Attention: District Manager ddr-ss may be given by either party, to be effective g of written notice of such change pursuant to this V. MISCELLANEOUS PROVISIONS 1. This Agreement shall be binding upon and inure to the benefit of the parties hereto and their respective successors and assigns. 2. This Agreement constitutes the sole and only agreement of the parties hereto and supersedes any prior understandings or written or oral agreements between the parties respecting the subject matter hereof. 3. No amendment, modification or alteration of the terms hereof shall be binding unless the same be in writing, dated subsequent to the date hereof and duly executed by the parties. 44 of 155 February 17, 2020 Regular Meeting Agenda Packet 4. All payments made hereunder shall be payable from funds currently available to the District. 5. This Agreement may be executed concurrently in one or more counterparts, each of which shall be deemed an original, but all of which together shall constitute one and the same instrument. 6. If, in case any one or more of the provisions contained in this Agreement shall for any reason be held to be invalid, illegal, or unenforceable in any respect, such invalidity, illegality, or unenforceability shall not affect any other provision hereof and this Agreement shall be construed as if such invalid, illegal or unenforceable provision had never been contained herein. 7. The obligations and undertakings of ea of the parties to this Agreement are performable and shall be fully perform= Tarrant County, Texas. 8. Each person signing this Agree - t w. ' nts that person has received authority from the governing body of party for ''ch it is signing this Agreement to enter into this Agreement. EXECUTED this the _ day o ATTEST: , 2020. UTHLAKE, TEXAS ayor for the City of Southlake, Texas City Secretary for the of Southlake, Texas [SEAL] APPROVED AS TO FORM: City Attorney for the City of Southlake, Texas 45 of 155 EXECUTED this the ATTEST: February 17, 2020 Regular Meeting Agenda Packet day of , 2020. TROPHY CLUB MUD NO.1 Chairman of the Board of Directors Trophy Club MUD NO. 1, Texas District Secretary for Trophy Club MUD NO. 1 [SEAL] APPROVED AS TO FORM: Attorney for Trophy Club MUD NO. <(11p c)IIIII"P 46 of 155 cP&Yi February 11, 2020 February 17, 2020 Regular Meeting Agenda Packet Partners for a Better Quality of Life Mr. Mike McMahon, Operations Manager Trophy Club MUD No. 1 100 Municipal Drive Trophy Club, TX 76262 Re: Scope & Fee Proposal for Antifoaming Spray System Design (20TCM000070) Dear Mike: CP&Y (Consultant) is pleased to submit to Trophy Club MUD No. 1 (TCMUD) the following scope and fee proposal for design of a pressure spray system located on the five (5) treatment trains using the existing wastewater treatment plant reuse water system. The overall project will generally consist of providing engineering design and construction documents as required to install the spray system in the pre - aeration and anaerobic basins on each treatment train to assist with managing foam that can accumulate on the basin surface. Task 1: Antifoam Spray System Design and Project Management This task will include the following engineering design services: 1. Site Visits/Meetings a. CP&Y will visit the Owner's treatment facility up to one (1) time to gather field data and information to complete our project design. At the same site visit and if needed we will meet with the Owner's representative to review the preliminary design and obtain Owner's comments. 2. Spray System Design a. CP&Y will provide a spray system design in the pre -aeration and anaerobic basins in each of the five (5) treatment trains. The spray system will tie into the existing plant reuse water supply/distribution system located adjacent to each treatment train and will be equipped with valves and nozzles to allow the operations staff to isolate the system at each basin and treatment train. b. Provide technical specifications and construction drawings as required to obtain qualified bids from contractors. i. CP&Y will compile the project manual front-end documents using EJCDC forms and templates. 47 of 155 200 West Highway 6, Suite 620 Waco, Texas 76712 TBPE # F.1741 TBPLS 1410194124 (p) 254.772.9272 (0 254,776.2924 www.cpyi.com February 17, 2020 Regular Meeting Agenda Packet Trophy Club MUD No. 1— Anti Foaming Design & Construction Administration Services Page 2 3. Project Management a. CP&Y will provide project management throughout the entirety of the project. Services will generally include communicating with the Owner, scheduling and coordinating project construction documents, submitting correspondence to the Owner, including invoices, progress updates and project documents. Task -1 Total Fee (Lump Sum): $16,940.00 Task 2: Bidding Services This task will include the following engineering services: 1. Provide Owner with a written project description to assist in advertising Project for bid. 2. Prepare construction plans and technical specifications in portable document format (PDF). Submit the PDF documents to CIVCAST for distribution to potential bidders. 3. CP&Y will provide clarifications and/or address bidder's questions during the bid process. CP&Y will prepare and issue addenda as may be required to modify the Contract Documents before or after they have been issued to prospective Bidders. 4. Prepare an opinion of probable construction cost (OPCC) for the project. 5. Attend one (1) Bid Opening for Project. 6. Assist Owner with review of bids received for completeness and accuracy. Engineer will assist Owner with assembling the bid tabulation to be submitted to the respondents and prepare notice of award. 7. CP&Y will compile and distribute the Contract Documents to the contractor for signatures and execution. 8. Engineer will prepare and provide 'conformed' construction plans and technical specifications in PDF to Contractor as modified to reflect changes resulting from addenda and clearly indicate approval for construction status. Task -2 Total Fee (Lump Sum): $5,340.00 Task 3: Construction Administration & Startup Services Engineer agrees to perform the following Construction Phase Services listed below. The projected fee (hours and expenses) is an estimate and may vary depending on the contractor's schedule and performance. These services shall be provided on a time (hourly billing rate) and materials (direct expenses plus 10%) basis, not to exceed the amount listed herein without written prior approval from Owner. 1. Interpretation. During construction, Engineer's Project Manager or Design Staff shall be available for interpretation of the Drawings, Specifications, or Bidding Documents. 2. Project Submittals. Review Contractor submitted Shop Drawings, material samples, equipment drawings, and other data submittals required by the Contract Documents for conformance with the applicable sections of the Documents. 48 of 155 Partners for a Better Quality of Life cp&y February 17, 2020 Regular Meeting Agenda Packet Trophy Club MUD No. 1— Anti Foaming Design & Construction Administration Services Page 3 3. Preconstruction Conference. Provide representation for Owner at one (1) preconstruction review meeting with the selected Contractor. 4. Construction Observation. No construction observation services are provided. Should these services be required, they shall be considered additional and shall be negotiated for an additional fee. 5. Progress Meetings. No construction progress meeting services are provided. Should these services be required, they shall be considered additional and shall be negotiated for an additional fee. 6. Construction Administration. Review and make recommendations on pay requests and change orders. 7. Record Drawings. Upon completion of the construction work and upon final project approval, CP&Y shall revise the original reproducible drawings to reflect changes made during construction based on Contractor and/or Owner mark-ups. Mark-ups shall be submitted by the Contractor. CP&Y shall then submit two (2) sets of hard -copy prints to Owner, and one CD/DVD containing portable digital files (PDF) of the plans. Task -3 Total Fee (Hourly/Expenses): $7,520.00 Should additional services be required or requested by Owner, the following is the current billing rates for CP&Y. Category Rate Principal $235.00 Sr Project Manager $215.00 Sr. Electrical Engineer $205.00 Deputy Project Manager $185.00 Sr. Engineer $175.00 Project Controls Specialist $125.00 Project Professional Engineer $135.00 Sr. CADD Tech $120.00 Sr. Technician $110.00 EIT $105.00 Exec Assistant Clerical Intern $42.00 $85.00 $65.00 49 of 155 Partners for a Better Quality of Life cp&y February 17, 2020 Regular Meeting Agenda Packet Trophy Club MUD No. 1— Anti Foaming Design & Construction Administration Services Page 4 Compensation Summary Task 1 Design and Project Management Services $16,940.00 Task 2 Bidding Services $5,340.00 Sub -Total $22,280.00 Task 3 Construction Administration (hourly not to exceed) $7,520.00 Total $29,800.00 Attachment -A provides a detailed labor breakdown of our fee proposal. Project Schedule CP&Y will deliver the 100% project documents to the Owner within approximately 120 calendar days following receipt of a signed agreement and written notification from the Owner to proceed with the services provided herein. Services Not Provided by Engineer The following are services not provided by the Engineer under this scope. These additional services can be provided by Engineer for additional compensation and upon written authorization by Owner. 1. Any topographic or metes/bounds surveying services. 2. Any geotechnical engineering services or soils borings. 3. Any wastewater treatment or process design services. 4. Construction progress meetings, site visits and construction observation/resident project representative services. 5. Any other services not expressly identified as being provided herein. Services to Be Provided by TCMUD 1. Owner shall provide to CP&Y the technical information and/or manuals on the new reuse water pumps and controls system. 2. Timely review of submittals by CP&Y for design review and equipment selection. Opinion of Probable Construction Cost (OPCC) The Engineer's OPCC for this project is $90,000 based on a project concept. Since no actual design or construction drawings have been completed at this time, the actual bid price will vary from this original OPCC value. 50 of 155 Partners for a Better Quality of Life cp&y February 17, 2020 Regular Meeting Agenda Packet Trophy Club MUD No. 1— Anti Foaming Design & Construction Administration Services Page 5 Please review this proposal for professional services on this project and if satisfactory, please sign and return to me at your earliest convenience. If you have any questions you can contact me at 254-399- 7153 or at swetzel@cpvi.com . Sincerely, Accepted By: Scott Wetzel, P.E. Project Manager CP&Y, Inc. SCW:scw cc: File 20TCM000070 Signature: Printed Name: Date: 51 of 155 Partners for a Better Quality of Life cp&y February 17, 2020 Regular Meeting Agenda Packet Trophy Club MUD No. 1— Anti Foaming Design & Construction Administration Services Page 6 ATTACH E M NT -A Fee Schedule 52 of 155 Partners for a Better Quality of Life cp&y February 17, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 WWTP ANTI -FOAM SYSTEM 11 -Feb -20 Fee Sch 'dule/Budget for CP&Y Inc. #20TC N000070 Project Project CAD Field Admin. Total Task Description Manager Senior PE Engineer EIT Architect RPLS Operator Observation Support Hours Personnel $215.00 $175.00 $135.00 $105.00 $165.00 $150.00 $105.00 $110.00 $100.00 1 Engineering Design & PM: Site Visits (1) Engineering Design (60%) Engineering Design (100%) Project Manual Project Management 6.00 16.00 12.00 8.00 2.00 2 Bidding Phase Services: 8.00 3 Construction Phase Services: Construction Administration Construction Meetings (0) Construction Observation (0) HOURS SUB -TOTALS FEES SUBTOTAL 8.00 32.00 24.00 16.00 Basic Total Basic Engineering Total Engineering Engineering as Percent Engineering as Percent Fees of Total Fee Fees of Total Fee 6.00 $ 1,290.00 48.00 $ 6,800.00 36.00 $ 5,100.00 24.00 $ 3,320.00 2.00 $ 430.00 4.3 22.8% 17.1 11.1% 1.4% $ 16,940.00 56.8% 4.00 32.00 44.00 $ 5,340.00 17.9% $ 5,340.00 17.9% 32.00 8.00 16.00 64.00 $ 7,520.00 25.2 - $ - 0.0°% - $ 0.0% $ 7,520.00 25.2% - - 60.00 - 36.00 - 64.00 - 64.00 224.00 $ 12,900.00 $ $ - $ 3,780.00 $ - $ - $ 6,720.00 $ - $ 6,400.00 $ 29,800.00 100.0% $ 29,800.00 100.0% 53 of 155 February 17, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET JANUARY 2020 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 1,220,452 PREPAID EXPENSES 13,127 ADVALOREM PROPERTY TAXES RECEIVABLE 177,817 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE TOTAL ASSETS 1,411,396 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE 603,769 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES 629,804 TOTAL FUND BALANCE 1,233,573 177,823 177,823 TOTAL LIABILITIES AND FUND BALANCE 1,411,396 54 of 155 glbase_tbam skrolczyk 10:43 02/11/20 Fund: 122 Trophy Club MUD Fire Dept. Account Description 122-40010-000-000 122-40011-000-000 122-40020-000-000 February 17, 2020 Regular Meeting Agenda Packet Trophy Club MUD No.1 Budget Summary with Amendment Department: Fire Revenues Program: Period Ending: 1/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Property Taxes/MUD Fire 1,214,230.00- 1,214,230.00 - Property Taxes/Fire-Delinquent Property Taxes/Fire P61 Program number: Department number: Fire Revenues Revenues Subtotal 1,214,230.00- 1,214,230.00- 1,214,230.00- 1,214,230.00- 1,214,230.00- 1,214,230.00- MEMII 1,214,230.00- 1,214,230.00- 55 of 155 456,982.39- 1,376.20- 426.40- 1,084,568.93- 1,022.23- 1,647.72- 458,784.99- 1,087,238.88- 458,784.99- 1,087,238.88- 458,784.99- 1,087,238.88- 458,784.99- 1,087,238.88- 89.322 89.541 129,661.07- 1,022.23 1,647.72 126,991.12- Page 89.541 126,991.12- 89.541 126,991.12- 89.541 126,991.12 - February 17, 2020 Regular Meeting Agenda Packet glbase_tbam skrolczyk Trophy Club MUD No.1 10:43 02/11/20 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/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 6,563.52 239,552.32 31.255 33.333 218,004.00 14,436.48 479,104.68 tota1: 957,661.00 957,661.00 61,528.96 122-69005-045-000 Capital Outlays 48,000.00 48,000.00 2,750.00 5.729 45,250.00 122-69009-045-000 Short Term Debt -Interest 11,958.24 11,958.24- 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 81,420.00 81,420.00 100.000 122-69305-045-000 Capital Leases 127,149.00 127,149.00 115,190.36 90.595 11,958.64 Subtota1: 256,569.00 256,569.00 211,318.60 ' 45, Program number: 1,214,230.00 1,214,230.00 61,528.96 457,434.44 756,795.56 Department number: Fire 1,214,230.00 1,214,230.00 61,528.96 457,434.44 /3 756,795.56 Expenditures Subtotal 1,214,230.00 1,214,230.00 61,528.96 457,434.44 /3 756,795.56 Fund number: 122 Trophy Club MUD Fire Dept. 397,256.03- 629,804.44- 629,804.44 56 of 155 Page 2 glpdatb2 skrolczyk 10:44 02/11/20 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description February 17, 2020 Regular Meeting Agenda Packet Trophy Club MUD No.1 Page 1 Detailed Accounting Trial Balance Department: Fire Revenues Program: Period Ending: 1/2020 JE Detail Beginning Transaction Transaction Vendor Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40010-000-000 Property Taxes/MUD Fire 670 01/02/2020 Property Taxes 671 01/03/2020 Property Taxes 672 01/06/2020 Property Taxes 673 01/07/2020 Property Taxes 674 01/08/2020 Property Taxes 691 01/09/2020 Property Taxes 692 01/10/2020 Property Taxes 693 01/13/2020 Property Taxes 694 01/14/2020 Property Taxes 695 01/15/2020 Property Taxes 696 01/16/2020 Property Taxes 697 01/17/2020 Property Taxes 698 01/21/2020 Property Taxes 699 01/22/2020 Property Taxes 700 01/23/2020 Property Taxes 701 01/24/2020 Property Taxes 704 01/27/2020 Property Taxes 705 01/28/2020 Property Taxes 706 01/29/2020 Property Taxes 707 01/30/2020 Property Taxes 708 01/31/2020 Property Taxes (627,586.54) (24,040.24) (15,369.98) (12,677.57) (23,873.74) (22,592.43) (6,233.18) (11,411.00) (8,720.18) (4,702.34) (25,633.01) (8,539.62) (11,615.77) (5,588.50) (11,955.93) (10,781.89) (85,374.77) (22,897.23) (105,049.46) (13,630.74) (12,832.45) (13,462.36) (651,626.78) GL (666,996.76) GL (679,674.33) GL (703,548.07) GL (726,140.50) GL (732,373.68) GL (743,784.68) GL (752,504.86) GL (757,207.20) GL (782,840.21) GL (791,379.83) GL (802,995.60) GL (808,584.10) GL (820,540.03) GL (831,321.92) GL (916,696.69) GL (939,593.92) GL (1,044,643.38) GL (1,058,274.12) GL (1,071,106.57) GL (1,084,568.93) GL Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (456,982.39) (1,084,568.93) ** (1,214,230.00) Budgeted (129,661.07) Remaining 89 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent • 670 01/02/2020 Property Taxes 673 01/07/2020 Property Taxes 692 01/10/2020 Property Taxes 695 01/15/2020 Property Taxes 699 01/22/2020 Property Taxes 700 01/23/2020 Property Taxes 704 01/27/2020 Property Taxes 353.97 (18.99) 334.98 GL (14.71) 320.27 GL (43.85) 276.42 GL (1,175.83) (899.41) GL (99.82) (999.23) GL (.01) (999.24) GL (22.99) (1,022.23) GL Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (1,376.20) (1,022.23) ** .00 Budgeted 1,022.23 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 670 01/02/2020 Property Taxes (1,221.32) 671 01/03/2020 Property Taxes 57 of 155 (60.57) (1,281.89) GL (3.87) (1,285.76) GL February 17, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 2 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 672 01/06/2020 Property Taxes 673 01/07/2020 Property Taxes 674 01/08/2020 Property Taxes 691 01/09/2020 Property Taxes 692 01/10/2020 Property Taxes 695 01/15/2020 Property Taxes 696 01/16/2020 Property Taxes 697 01/17/2020 Property Taxes 699 01/22/2020 Property Taxes 700 01/23/2020 Property Taxes 701 01/24/2020 Property Taxes 704 01/27/2020 Property Taxes Account: 122-40020-000-000 Property Taxes/Fire P&I .00 Budgeted (1,221.32) (7.75) (1,293.51) GL (3.38) (1,296.89) GL (1.94) (1,298.83) GL (15.13) (1,313.96) GL (22.77) (1,336.73) GL (282.92) (1,619.65) GL (1.03) (1,620.68) GL (.69) (1,621.37) GL (15.77) (1,637.14) GL (.25) (1,637.39) GL (5.89) (1,643.28) GL (4.44) (1,647.72) GL Totals: (426.40) (1,647.72) ** 1,647.72 Remaining 0 % Used Department Totals: (1,087,238.88) ** (458,784.99) Monthly Total (1,214,230.00) Budgeted (126,991.12) Remaining 90 % Used 58 of 155 February 17, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 3 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60030-045-000 Rent And/Or .00 .00 Account: 122-60030-045-000 Rent And/Or Usage Totals: 218,004.00 Budgeted Account: 122-60055-045-000 Insurance 69 01/01/2020 Insurance/Wrk Comp Expense Jan Account 218,004.00 Remaining 0 % Ueed 21,000.00 Budgeted 14,436.48 Remaining Accoun - Transfer to Town/Fire Budget 483 01/02/2020 January A/P Jan Fire Admin Account: 122-60337-045-00 Transfer to T•: •• 718,657.00 Budgeted Account: 122-69005-045-000 Capital Outlays Account: 122-69005-045-000 Capital Outlays 48,000.00 Budgeted 479,104.68 4,922.64 1,640.88 6,563.52 31 % Ueed 59,888.08 239,552.32 TOWN OF TROPHY CLUB 179,664.24 Remaining 45,250.00 Remaining 2,750.00 33 % Ueed 6 % Ueed .00 2,750.00 GL 6058 AP Account: 122-69009-045-000 Account: 122-69009-045-000 Short Term Debt -Interest Totals, .00 Budgeted (11,958.24) Remaining Account: 122-69195-045-000 GASB34/Reserve for Replacement Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: 81,420.00 Budgeted .00 Remaining 11,958.24 0 % Used 81,420.00 100 % Used .00 .00 11,958.24 81,420.00 Account: 122-69305-045-000 Capital Leases 59 of 155 February 17, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 115,190.36 .00 115,190.36 Capital Leases Totals: 0 127,149.00 Budgeted 11,958.64 Remaining 91 % Used Department 45 Totals: 457,434.44 •• 61,528.96 Monthly Total 1,214,230.00 Budgeted 756,795.56 Remaining 38 % Used Fund 122 Totals: (629,804.44) (397,256.03) Monthly Total .00 Budgeted 60 of 155 629,804.44 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M (GENERAL FUND) BALANCE SHEET JANUARY 2020 February 17, 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 2,594,636 2,594,636 CASH IN BANK -SAVINGS -CASH RESERVE 1,400,451 1,400,451 INVESTMENTS-TEXPOOL 4,066,755 919,266 4,986,021 PREPAID EXPENSES 75,381 75,381 ADVALOREM PROPERTY TAXES RECEIVABLE 19,651 19,651 UTILITY AND OTHER ACCOUNTS RECEIVABLE 809,277 809,277 TOTAL ASSETS 8,966,751 919,266 9,886,017 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 19,651 19,651 ACCOUNTS AND OTHER PAYABLES 393,299 393,299 CUSTOMER DEPOSITS 318,815 318,815 TOTAL LIABILITIES 731,765 731,765 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 (166,399) (166,399) TOTAL FUND BALANCE 8,234,985 919,266 9,154,251 TOTAL LIABILITIES AND FUND BALANCE 8,966,751 919,266 9,886,017 61 of 155 February 17, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 Page 3 10:43 02/11/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/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- 50,730.63- 120,400.36- 89.271 14,470.64- 157.13- 116.99- 38.997 183.01- 47.81- 184.15- 61.383 115.85- 164,253.00- 71 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- 308,153.82- 1,523,137.03- 23.481 4,963,485.97- 255,733.19- 995,260.50- 28.404 2,508,624.50- 8,437.81- 35,066.86- 31.141 77,541.14- 1,400.00- 6,750.00- 44.554 8,400.00- 350.00- 2,150.00- 286.667 1,400.00 650.00- 1,050.00- 42.000 1,450.00- 19.20- 15,068.00- 30.136 34,932.00- 10,171,516.00- 10,171,516.00- 574,744.02- 2,578,482.39- 7,593,033.61- 135-49011-000-000 135-49016-000-000 135-49018-000-000 135-49026-000-000 135-49075-000-000 135-49900-000-000 Interest Income Cell Tower Revenue Building Rent Income Proceeds from Sale of Assets Oversize Meter Reimbursement Miscellaneous Income ENSubtots. Program number: Department number: Revenues Revenues Subtotal 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- 173,837.00- 0- 10,645,077.00- 0- 10,645,077.00- 1(110- 10,645,077.00- 62 of 155 10,396.30- 41,939.08- 34.949 78,060.92- 3,536.43- 25.000 10,609.57- 583.33- 2,333.32- 33.333 4,666.68- 13,000.00- 1,765.00- 7,120.28- 56.105 5,570.72- 231.52- 8,153.54- 116.479 1,153.54 12,976.15- 110,754.35 638,655.74- 2 7,882,810.46- 638,655.74- 7,882,810.46- 638,655 7,882,810.46- February 17, 2020 Regular Meeting Agenda Packet glbase_tbam skrolczyk Trophy Club MUD No.1 10:43 02/11/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/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 135-50010-010-000 Overtime 17,000.00 17,000.00 135-50016-010-000 Longevity 3,920.00 3,920.00 135-50017-010-000 Certification 5,400.00 5,400.00 135-50020-010-000 Retirement 34,863.00 34,863.00 135-50026-010-000 Medical Insurance 84,326.00 84,326.00 135-50027-010-000 Dental Insurance 4,725.00 4,725.00 135-50028-010-000 Vision Insurance 767.00 767.00 135-50029-010-000 Life Insurance & Other 3,132.00 3,132.00 135-50030-010-000 Social Security Taxes 23,348.00 23,348.00 135-50035-010-000 Medicare Taxes 5,461.00 5,461.00 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 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 135-55005-010-000 Engineering 20,000.00 20,000.00 135-55080-010-000 Maintenance & Repairs 100,000.00 100,000.00 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 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 135-55135-010-000 Lab Analysis 7,500.00 7,500.00 25,800.75 104,419.99 2,257.31 7,647.68 5,082.50 425.00 1,650.00 2,637.53 12,072.53 5,225.04 19,153.58 316.93 1,164.85 48.18 187.93 352.65 1,223.77 1,737.92 7,276.76 406.45 1,701.80 28.48 45.16 771.49 3,085.96 7,256.26 21,176.04 62.41 441.65 920.37 87.50 262.50 200.00 1,347.70 29.812 44.986 129.656 30.556 34.628 22.714 24.653 24.502 39.073 31.167 31.163 4.181 26.042 .121 21.176 8.833 26.296 26.250 17.969 245,847.01 9,352.32 1,162.50- 3,750.00 22,790.47 65,172.42 3,560.15 579.07 1,908.23 16,071.24 3,759.20 1,034.84 8,764.04 400.00 300.00 Page 4 382,126.49 20,000.00 78,823.96 3,000.00 4,558.35 2,579.63 737.50 6,152.30 140,000.00 140,000.00 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 63 of 155 424.30 2,048.65 5,903.40 39,326.83 111.00 406.00 50.00 14,257.15 118,562.59 468,955.29 462.00 47,943.74 191,774.96 4,600.00 18,400.00 40.973 2,951.35 31.292 86,350.17 1,000.00 500.00 5.467 7,020.00 400.00 2,845.00 1,500.00 22.630 48,742.85 17.275 2,245,754.71 200.00 15.400 2,538.00 14,750.00 36.364 335,606.04 33.338 36,793.00 180,000.00 glbase_tbam skrolczyk 10:43 02/11/20 Fund: 135 MUD 1 General Fund Account 1 1 135-60360-010-000 1 Description Furniture/Equipment < $5000 Department: Adopted Budget Trophy Club MUD No.1 Budget Summary with Amendment 10 Water Period Ending: 1/2020 Program: February 17, 2020 Regular Meeting Agenda Packet Amended Total Current YTD % of Remaining Budget Encumb. Month Total Budget Budget 2,500.00 2,500.00 561.72 22.469 1,938.28 Page 5 2,968,889.40 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 135-69005-010-000 135-69008-010-000 135-69009-010-000 135-69195-010-000 135-69281-010-000 Fuel & Lube Uniforms Chemicals Small Tools Safety Equipment Meter Expense Meter Change Out Program Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Water Tank Inspection Contract 15,000.00 15,000.00 5,190.00 5,190.00 20,000.00 20,000.00 1,200.00 1,200.00 1,000.00 1,000.00 70,000.00 70,000.00 87,000.00 87,000.00 684,875.00 684,875.00 30,512.00 30,512.00 3,231.00 3,231.00 75,000.00 75,000.00 120,000.00 120,000.00 3,618.00 5,504,929.00 5,0-474111..._ 64 of 155 1,140.42 3,569.35 2,917.33 2,760.11 7,625.15 7,229.50 16,104.78 36,900.00 36,900.00 75,222.00 165,790.03 30,512.00 30,512.00 1,840.00 1,840.00 75,000.00 44,144.38 102,077.11 23.796 56.211 38.126 23.007 42.414 11,430.65 2,272.67 12,374.85 1,200.00 1,000.00 53,895.22 50,100.00 33.661 27 24.207 519,084.97 100.000 56.948 1,391.00 100.000 85.064 17,922.89 538,398.86 ,137,539.88 glbase_tbam skrolczyk 10:43 02/11/20 Fund: 135 MUD 1 General Fund Account Description 1 1 135-55135-010-001 Lab Analysis for PID February 17, 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: 1/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 2,000.00 2,000.00 80.00 467.70 23.385 1,532.30 Page Subtotal: 2,000.00 2,000.00 80.00 467.70 23.385 1,532.30 Program number: 1 Lab Analysis for PID 2,000.00 2,000.00 80.00 467.70 23.385 1,532.30 Department number: Water 5,506,929.00 5,506,929.00 425,037.34 1,367,856.82 24.839 4,139,072.18 65 of 155 February 17, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 Page 7 10:43 02/11/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 135-50010-020-000 Overtime 135-50016-020-000 Longevity 135-50017-020-000 Certification 135-50020-020-000 Retirement 135-50026-020-000 Medical Insurance 135-50027-020-000 Dental Insurance 135-50028-020-000 Vision Insurance 135-50029-020-000 Life Insurance & Other 135-50030-020-000 Social Security Taxes 135-50035-020-000 Medicare Taxes 135-50040-020-000 Unemployment Taxes 135-50045-020-000 Workman's Compensation 135-50060-020-000 Pre-emp Physicals/Testing 135-50070-020-000 Employee Relations FSubtotal: 135-55005-020-000 Engqinee ing 135-55070-020-000 Independent Labor 135-55080-020-000 Maintenance & Repairs 135-55081-020-000 Mainten & Repairs Collections 135-55085-020-000 Generator Meant. and Repair 135-55090-020-000 Vehicle Maintenance 135-55091-020-000 Veh Maintenance Collections 135-55105-020-000 Maintenance-Backhoe/SkidLoader 135-55120-020-000 Cleaning Services 135-55125-020-000 Dumpster Services 135-55135-020-000 Lab Analysis 441,799.00 441,799.00 33,000.00 33,000.00 8,035.00 8,035.00 9,000.00 9,000.00 45,531.00 45,531.00 104,858.00 104,858.00 5,817.00 5,817.00 948.00 948.00 4,500.00 4,500.00 30,494.00 30,494.00 7,132.00 7,132.00 1,260.00 1,260.00 15,373.00 15,373.00 400.00 400.00 300.00 300.00 31,950.85 119,177.15 26.975 1,965.55 8,065.27 24.440 6,872.50 85.532 650.00 2,550.00 28.333 3,200.84 14,183.59 31.152 7,738.24 26,051.83 24.845 447.50 1,538.52 26.449 69.74 250.69 26.444 376.31 1,390.36 30.897 1,988.22 7,951.71 26.076 464.99 1,859.66 26.075 34.56 34.56 2.743 1,110.20 4,440.80 28.887 322,621.85 24,934.73 1,162.50 6,450.00 31,347.41 78,806.17 4,278.48 697.31 3,109.64 22,542.29 5,272.34 1,225.44 10,932.20 400.00 300.00 7.00 194,366.64 30,000.00 30,000.00 15,000.00 15,000.00 88,000.00 88,000.00 10,000.00 10,000.00 10,000.00 10,000.00 4,000.00 4,000.00 8,000.00 8,000.00 3,000.00 3,000.00 1,500.00 1,500.00 100,000.00 100,000.00 40,000.00 40,000.00 13,090.25 1,101.29 278.75 3,000.00 20.000 28,715.17 32.631 15,378.45 153.785 682.98 17.075 72.87 1,932.95 24.162 504.68 16.823 262.50 17.500 32,786.78 32.787 12,716.45 31.791 87.50 12,210.28 2,657.31 30,000.00 12,000.00 59,284.83 5,378.45- 10,000.00 3,317.02 6,067.05 2,495.32 1,237.50 67,213.22 27,283.55 135-60010-020-000 Communications/Mobiles 5,000.00 5,000.00 684.87 135-60020-020-000 Electricity 160,067.00 160,067.00 12,730.12 135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 135-60070-020-000 Dues & Memberships 300.00 300.00 135-60080-020-000 Schools & Training 4,990.00 4,990.00 440.00 135-60090-020-000 Safety Program 1,000.00 1,000.00 135-60100-020-000 Travel & per diem 1,545.00 1,545.00 4.13 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 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 135-60280-020-000 Property Maintenance 5,000.00 5,000.00 66 of 155 2,270.53 45.411 47,873.47 29.908 111.00 37.000 1,910.85 38.294 109.14 10.914 360.84 23.355 10,088.02 67.253 2,729.47 112,193.53 200.00 189.00 3,079.15 890.86 1,184.16 5,000.00 2,500.00 4,911.98 450.00 5,000.00 February 17, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 10:43 02/11/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/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 Subtotal: 1,310,669.00 r 135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 135-65010-020-000 Uniforms 5,495.00 5,495.00 135-65030-020-000 Chemicals 20,000.00 20,000.00 135-65031-020-000 Chemicals Collections 17,500.00 17,500.00 135-65035-020-000 Small Tools 1,200.00 1,200.00 135-65040-020-000 Safety Equipment 1,200.00 1,200.00 135-65045-020-000 Lab Supplies 20,000.00 20,000.00 10,414.81 61,260.70 5,750.00 91,284.63 625.22 3,047.71 2,830.97 41,659.24 245,042.20 23,000.00 190.00 372,615.29 2,960.40 3,507.93 9,868.27 4,994.00 1,088.92 10,837.36 14,000.00 36.364 72,903.76 36.364 428,824.80 18.373 102,187.00 180,000.00 9.500 1,810.00 Page 8 28.429 938,053.71 23.683 9,539.60 63.839 1,987.07 49.341 10,131.73 28.537 12,506.00 1,200.00 90.743 111.08 54.187 9,162.64 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 67 of 155 51,656.24 59,604.74 6,122.03 3.01 6.79 6.79 145,872.09 27.497 384,627.91 59,604.74 75.322 19,528.26 6,122.03 54.288 5,154.97 130,000.00 100.000 341,598.86 -91 409,311.14 1,037,817.63 ,119,603.37 1,037,817.63 19,603.31 glbase_tbam skrolczyk 10:43 02/11/20 Fund: 135 MUD 1 General Fund Account 135-50045-026-000 Description Workman's Compensation Trophy Club MUD No.1 Budget Summary with Amendment Department: 26 Board of Directors Period Ending: 1/2020 Adopted Amended Total Current Budget Budget Encumb. Month 30.00 30.00 1.99 Program: YTD Total 7.96 February 17, 2020 Regular Meeting Agenda Packet % of Remaining Budget Budget 26.533 22.04 Page 9 135-60066-026-000 135-60070-026-000 135-60075-026-000 135-60080-026-000 135-60100-026-000 135-60245-026-000 Publications/Books/Subscripts Dues & Memberships Meetings Schools & Training Travel & per diem Miscellaneous Expenses 150.00 750.00 1,300.00 4,000.00 5,000.00 2,000.00 150.00 750.00 1,300.00 4,000.00 5,000.00 2,000.00 5.72 675.00 176.28 90.000 13.560 150.00 75.00 1,123.72 4,000.00 5,000.00 2,000.00 Subtotal: 13,200.00 13,200.00 5.72 851.28 6.449 12,348.72 Program number: 13,230.00 13,230.00 7.71 859.24 6.495 12,370.76 L Department number: Board of Directors 13,230.00 13,230.00 7.71 859.24 6.495 12,370.76 68 of 155 February 17, 2020 Regular Meeting Agenda Packet glbase_tbam skrolczyk Trophy Club MUD No.1 10:43 02/11/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/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 30,152.71 119,116.36 18.959 509,181.64 135-50010-030-000 Overtime 2,000.00 2,000.00 4.75 16.57 .829 1,983.43 135-50016-030-000 Longevity 2,208.00 2,208.00 2,207.50 99.977 .50 135-50020-030-000 Retirement 58,554.00 58,554.00 2,792.56 12,732.78 21.745 45,821.22 135-50026-030-000 Medical Insurance 124,394.00 124,394.00 6,345.77 22,812.20 18.339 101,581.80 135-50027-030-000 Dental Insurance 6,464.00 6,464.00 349.75 1,268.95 19.631 5,195.05 135-50028-030-000 Vision Insurance 1,035.00 1,035.00 51.68 197.99 19.129 837.01 135-50029-030-000 Life Insurance & Other 4,500.00 4,500.00 347.91 1,291.54 28.701 3,208.46 135-50030-030-000 Social Security Taxes 39,215.00 39,215.00 1,729.08 7,067.51 18.022 32,147.49 135-50035-030-000 Medicare Taxes 9,171.00 9,171.00 404.39 1,652.92 18.023 7,518.08 135-50040-030-000 Unemployment Taxes 1,440.00 1,440.00 30.16 30.16 2.094 1,409.84 135-50045-030-000 Workman's Compensation 1,775.00 1,775.00 104.82 419.28 23.621 1,355.72 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 500.00 135-50070-030-000 Employee Relations 8,000.00 8,000.00 3,078.10 38.476 4,921.90 Page 10 42,313.58 171, 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 135-60005-030-000 Telephone 135-60010-030-000 Communications/Mobiles 135-60020-030-000 Electricity/Gas 135-60025-030-000 Water 135-60035-030-000 Postage 135-60040-030-000 Service Charges & Fees 135-60050-030-000 Bad Debt Expense 135-60055-030-000 Insurance 135-60066-030-000 Publications/Books/Subscripts 135-60070-030-000 Dues & Memberships 135-60075-030-000 Meetings 135-60079-030-000 Public Education 135-60080-030-000 Schools & Training 135-60100-030-000 Travel & per diem 135-60110-030-000 Physicals/Testing 135-60115-030-000 Elections 135-60125-030-000 Advertising 2,500.00 2,500.00 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 23,680.00 23,680.00 4,000.00 4,000.00 6,879.00 6,879.00 1,500.00 1,500.00 30,000.00 30,000.00 67,000.00 67,000.00 1,500.00 1,500.00 84,000.00 84,000.00 1,000.00 1,000.00 6,000.00 6,000.00 400.00 400.00 6,000.00 6,000.00 6,850.00 6,850.00 3,545.00 3,545.00 200.00 200.00 69 of 155 51,870.09 125,274.22 93.016 20,788.70 54,824.49 40.611 110.00 1,165.00 7.767 869.06 2,607.18 26.072 775.12 2,474.81 27.498 1,669.83 6,125.59 25.868 237.75 951.81 23.795 690.43 1,282.43 18.643 56.40 241.17 16.078 1,930.85 6,806.80 22.689 5,286.16 26,018.83 38.834 3,415.53 24,431.70 29.085 125.00 12.500 80.00 4,166.55 69.443 61.37 15.343 476.20 7.937 1,152.71 16.828 8.25 695.14 19.609 43.01 9,406.78 80,175.51 13,835.00 10,000.00 7,392.82 65,600.00 6,525.19 192-79 17,554.41 3,048.19 5,596.57 1,258.83 23,193.20 40,981.17 1,500.00 59,568.30 875.00 1,833.45 338.63 5,523.80 5,697.29 2,849.86 200.00 43.01- 2,500.00 February 17, 2020 Regular Meeting Agenda Packet glbase_tbam skrolczyk Trophy Club MUD No.1 10:43 02/11/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/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 70 of 155 24.00 96.00 7.453 13,399.20 72,674.31 188.73 1,175.74 1,364.47 241.68 241.68 131,731.90 131,731.90 3,235.24 12.215 1,866.47 31.108 2,396.62 59.916 7,498.33 1,037.66 1,037.66 25.942 439,447.86 24.734 439,447.86 1,192.00 500.00 17,000.00 2,500.00 2,050.00 23,249.76 4,133.53 3,500.00 1,603.38 2,500.00 195,000.00 2,962.34 1,337,264 24.734 1,337 Page 11 glbase_tbam skrolczyk 10:43 02/11/20 Fund: 135 MUD 1 General Fund Account Description 135-55045-039-000 135-55055-039-000 135-55060-039-000 1 135-55065-039-000 Le al Auditing_ Appraisal Tax Admin Fees February 17, 2020 Regular Meeting Agenda Packet Trophy Club MUD No.1 Budget Summary with Amendment Department: 39 Non Departmental Program: Period Ending: 1/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135,000.00 33,800.00 11,761.00 4,000.00 135,000.00 33,800.00 11,761.00 4,000.00 10,728.50 12,563.27 46,036.39 27,713.27 5,178.56 3,756.00 34.101 81.992 44.032 93.900 88,963.61 6,086.73 6,582.44 244.00 Page 12 71 of 155 ir Subtotal: ' 184,561.00 184,561.00 23,291.77 82,684.22 44.800 101,876.78 Program number: 184,561.00 184,561.00 23,291.77 82,684.22 44.800 101,876.78 Department number: Non Departmental 184,561.00 184,561.00 23,291.77 82,684.22 44.800 101,876.78 Expenditures Subtotal 10,638,853.00 10,638,853.00 874,735.51 2,928,665.77 27.528 7,710,187.23 Fund number: 135 MUD 1 General Fund 6,224.00- 6,224.00- 236,079.77 166,399.23 -2,673.509 172,623.23- 71 of 155 February 17, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 Page 13 10:43 02/11/20 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASS Department: Program: Period Ending: 1/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer -General Fund 205,000.00- 205,000.00 137-49146-000-000 Intergov Transfer -Fire Dept 81,420.00- 81,420.00 Subtot 286, H Program number: 286,420.00- 286,420.00 Department number: 286,420.00- 286,420.00 Revenues Subtotal 286,420.00- 286,420.00 Fund number: 137 MUD 1 Consolidated GASB 286,420.00- 286,420.00 72 of 155 glpdatb2 skrolczyk 10:44 02/11/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Account: 135-40000-000- 670 01/02/2020 Property Taxes 671 01/03/2020 Property Taxes 672 01/06/2020 Property Taxes 673 01/07/2020 Property Taxes 674 01/08/2020 Property Taxes 691 01/09/2020 Property Taxes 692 01/10/2020 Property Taxes 693 01/13/2020 Property Taxes 694 01/14/2020 Property Taxes 695 01/15/2020 Property Taxes 696 01/16/2020 Property Taxes 697 01/17/2020 Property Taxes 698 01/21/2020 Property Taxes 699 01/22/2020 Property Taxes 700 01/23/2020 Property Taxes 701 01/24/2020 Property Taxes 704 01/27/2020 Property Taxes 705 01/28/2020 Property Taxes 706 01/29/2020 Property Taxes 707 01/30/2020 Property Taxes 708 01/31/2020 Property Taxes 40000-000-000 Account: 135-40002-000-00 670 01/02/2020 Property Taxes 671 01/03/2020 Property Taxes 673 01/07/2020 Property Taxes 692 01/10/2020 Property Taxes 695 01/15/2020 Property Taxes 699 01/22/2020 Property Taxes 704 01/27/2020 Property Taxes February 17, 2020 Regular Meeting Agenda Packet Trophy Club MUD No.1 Page 5 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 1/2020 JE Detail Beginning Transaction Transaction Vendor Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) Property Taxes (134,871.00) Budgeted (300.00) Budgeted (69,669.73) (2,668.76) (72,338.49) GL (1,706.26) (74,044.75) GL (1,407.36) (75,452.11) GL (2,650.28) (78,102.39) GL (2,508.04) (80,610.43) GL (691.96) (81,302.39) GL (1,266.76) (82,569.15) GL (968.05) (83,537.20) GL (522.02) (84,059.22) GL (2,845.58) (86,904.80) GL (948.00) (87,852.80) GL (1,289.49) (89,142.29) GL (620.39) (89,762.68) GL (1,327.25) (91,089.93) GL (1,196.92) (92,286.85) GL (9,477.64) (101,764.49) GL (2,541.87) (104,306.36) GL (11,661.77) (115,968.13) GL (1,513.18) (117,481.31) GL (1,424.56) (118,905.87) GL (1,494.49) (120,400.36) GL (14,470.64) Remaining 89 % Used 40.14 (2.17) 37.97 GL (.43) 37.54 GL (1.68) 35.86 GL (4.99) 30.87 GL (133.88) (103.01) GL (11.36) (114.37) GL (2.62) (116.99) GL (183.01) Remaining 39 % Used Property Taxes/P & I 670 01/02/2020 Property Taxes (136.34) 672 01/06/2020 Property Taxes 73 of 155 (6.74) (143.08) GL (.86) (143.94) GL February 17, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 6 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 673 01/07/2020 Property Taxes 674 01/08/2020 Property Taxes 691 01/09/2020 Property Taxes 692 01/10/2020 Property Taxes 695 01/15/2020 Property Taxes 696 01/16/2020 Property Taxes 697 01/17/2020 Property Taxes 699 01/22/2020 Property Taxes 700 01/23/2020 Property Taxes 701 01/24/2020 Property Taxes 704 01/27/2020 Property Taxes 5-40015-001.1 Account: 135-40025-000-000 J Account: 135-40025-000-000 AMM Property Taxes/P & I (300.00) Budgeted PID Surcharges PID Surcharges Totals: (136.34) (.38) (144.32) GL (.21) (144.53) GL (1.68) (146.21) GL (2.56) (148.77) GL (32.20) (180.97) GL (.12) (181.09) GL (.08) (181.17) GL (1.80) (182.97) GL (.03) (183.00) GL (.65) (183.65) GL (.50) (184.15) GL (115.85) Remaining 61 % Used (164,253.00) Budgeted Account: 135- 511 01/06/2020 UB 01/06/2020 Bill adjustment 664 01/31/2020 UB 01/31/2020 Billing Account: 135 .00 .00 (164,253.00) Remaining 0 % Used UB20200106-20200106 User: UB20200131-20200131 User: (6,486,623.00) Budgeted (1,214,983.21) 34.11 (1,214,949.10) (308,187.93) (1,523,137.03) (4,963,485.97) Remaining 23 % Used Account: 135-47005-00 Sewe 511 01/06/2020 UB 01/06/2020 Bill adjustment UB20200106-20200106 User: 664 01/31/2020 UB 01/31/2020 Billing UB20200131-20200131 User: Account: 135-47005-000-000 Account: (739,527.31) (3,503,885.00) Budgeted (2,508,624.50) Remaining Penalt 526 01/07/2020 UB 01/07/2020 Penalty removal UB20200107-20200107 User: 606 01/20/2020 UB 01/20/2020 Penalty removal UB20200120-20200120 User: 617 01/21/2020 UB 01/21/2020 Penalties UB20200121-20200121 User: 28 % Used (26,629.05) 74 of 155 43.00 (255,776.19) 108.64 40.34 (9,257.00) (739,484.31) (995,260.50) (26,520.41) (26,480.07) (35,737.07) UB UB UB UB UB UB February 17, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 7 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 636 01/27/2020 UB 01/27/2020 Penalty removal UB20200127-20200127 User: 650 01/30/2020 UB 01/30/2020 Penalty Removal UB20200130-20200130 User: 652 01/30/2020 UB 10/30/2020 Penalty removal UB20200130-20200130 User: (26,629.05) 397.35 (35,339.72) UB 256.10 (35,083.62) UB 16.76 (35,066.86) UB Account: 135-47025-000-000 ■ Penalties Totals: (8,437.81) (35,066.86) ** (112,608.00) Budgeted (77,541.14) Remaining 31 % Used Account: 135-47030-000-000 Service Chargee 541 01/02/2020 UB 01/02/2020 NSF Check UB20200102-20200102 User: 521 01/07/2020 UB 07/07/2020 Disconnect Fees UB20200107-20200107 User: 575 01/13/2020 UB 01/13/2020 DF adjustment UB20200113-20200113 User: 619 01/21/2020 UB 01/21/2020 NSF Check UB20200121-20200121 User: 620 01/22/2020 UB 01/22/2020 NSF Check UB20200122-20200122 User: 624 01/22/2020 UB 01/22/2020 NSF Check UB20200122-20200122 User: (5,350.00) (25.00) (5,375.00) UB (1,350.00) (6,725.00) UH 50.00 (6,675.00) UH (25.00) (6,700.00) UH (25.00) (6,725.00) UH (25.00) (6,750.00) UH Account: 135-47030-000-000 Service Charges Totals: (1,400.00) (6,750.00) ** (15,150.00) Budgeted (8,400.00) Remaining 45 % Used Account: 135-47035-000-000 Plumbing Inspections 654 01/02/2020 Permits 25 KATIE LANE 654 01/02/2020 Permits 27 KATIE LANE 655 01/02/2020 permits 3 655 01/02/2020 permits 32 KATIE LANE 655 01/02/2020 permits 3 687 01/05/2020 Permits -25/27 Katie Lane 25 Katie Lane 687 01/05/2020 Permits -25/27 Katie Lane 27 Katie Lane (1,800.00) (50.00) (1,850.00) Drees Homes CR (50.00) (1,900.00) DREES HOMES CR (50.00) (1,950.00) DREES HOMES CR (50.00) (2,000.00) DREES HOMES CR 50.00 (1,950.00) DREES HOMES CR (50.00) (2,000.00) Drees Homes CR (150.00) (2,150.00) Drees Homes CR Account: 135-47035-000-000 Plumbing Inspections Totals: 1.1 (350.00) (2,150.00) ** (750.00) Budgeted 1,400.00 Remaining 287 % Used Account: 135-47045-000-000 Sewer Inspections 654 01/02/2020 Permits 654 01/02/2020 Permits 655 01/02/2020 permits 655 01/02/2020 permits 655 01/02/2020 permits 687 01/05/2020 Permits -25/27 Katie Lane 687 01/05/2020 Permits -25/27 Katie Lane 25 KATIE LANE 27 KATIE LANE 3 32 KATIE LANE 3 25 Katie Lane 27 Katie Lane (400.00) (150.00) (150.00) (150.00) (150.00) 150.00 (150.00) (50.00) (550.00) Drees Homes (700.00) DREES HOMES (850.00) DREES HOMES (1,000.00) DREES HOMES (850.00) DREES HOMES (1,000.00) Drees Homes (1,050.00) Drees Homes CR CR CR CR CR CR CR Account: 135-47045-000-000 Sewer Inspections Totals: (650.00) (1,050.00) ** (2,500.00) Budgeted (1,450.00) Remaining 42 % Used 75 of 155 glpdatb2 skrolczyk 10:44 02/11/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: 1/2020 JE Detail Description/Comment February 17, 2020 Regular Meeting Agenda Packet Page 8 Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Check Source Number 654 01/02/2020 Permits 654 01/02/2020 Permits 655 01/02/2020 permits 655 01/02/2020 permits 655 01/02/2020 permits 25 KATIE LANE 27 KATIE LANE 3 32 KATIE LANE 3 (5,355.28) 76 of 155 (353.00) (353.00) (343.00) (353.00) 343.00 (5,708.28) Drees Homes (6,061.28) DREES HOMES (6,404.28) DREES HOMES (6,757.28) DREES HOMES (6,414.28) DREES HOMES CR CR CR CR CR Account: 135-47070-000-000 TCCC Effluent Charges 664 01/31/2020 UB 01/31/2020 Billing UB20200131-20200131 User: (15,048.80) (19.20) (15,068.00) UB Account: 135-47070-000-000 TCCC Effluent Charges Totals: 19.20) (15,068.00) ** (50,000.00) Budgeted (34,932.00) Remaining 30 % Used Account: 135-49011-000-000 , Interest Income 724 01/31/2020 724 01/31/2020 724 01/31/2020 Bank Interest- Bank Interest- Bank Interest- January (31,542.78) January January (1,238.68) (1,066.75) (8,090.87) (32,781.46) (33,848.21) (41,939.08) GL GL GL Account: 135-49011-000-000 ■ ' Interest Income Totals: (10,396.30) (41,939.08) ** (120,000.00) Budgeted (78,060.92) Remaining 35 5 Used Account: 135-49016-000-000 Cell Tower Revenue (3,536.43) .00 (3,536.43) Account: 135-49016-000-000 Cell Tower Revenue Totals: .00 (3,536.43) ** (14,146.00) Budgeted (10,609.57) Remaining 25 5 Used Account: 135-49018-000-000 Building Rent Income 733 01/31/2020 Town Billed Invoices 1722-1725 AR 20200131-20200131 User: (1,749.99) (583.33) (2,333.32) AR Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (2,333.32) ** (7,000.00) Budgeted (4,666.68) Remaining 33 5 Used Account: 135-49026-000-000 Proceeds from Sale of Assets .00 .00 Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: .00 .00 ** (13,000.00) Budgeted (13,000.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 654 01/02/2020 Permits 654 01/02/2020 Permits 655 01/02/2020 permits 655 01/02/2020 permits 655 01/02/2020 permits 25 KATIE LANE 27 KATIE LANE 3 32 KATIE LANE 3 (5,355.28) 76 of 155 (353.00) (353.00) (343.00) (353.00) 343.00 (5,708.28) Drees Homes (6,061.28) DREES HOMES (6,404.28) DREES HOMES (6,757.28) DREES HOMES (6,414.28) DREES HOMES CR CR CR CR CR February 17, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 9 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 687 01/05/2020 Permits -25/27 Katie Lane 687 01/05/2020 Permits -25/27 Katie Lane Accal1111035-4907 25 Katie Lane 27 Katie Lane (5,355.28) (353.00) (6,767.28) Drees Homes (353.00) (7,120.28) Drees Homes Oversize Meter Reimbursement Totals: '0.28) ** (12,691.00) Budgeted (5,570.72) Remaining Account: 135-49900-000-000 Miscellaneous Income 680 01/10/2020 Rfd of deposit for portable me UB20200110-20200110 User: 664 01/31/2020 UB 01/31/2020 Billing UB20200131-20200131 User: Account: 135-49900-000-000 Miscellaneous Income (7,000.00) Budgeted 56 % Used CR CR (7,922.02) (.30) (7,922.32) UB (231.22) (8,153.54) UB 1,153.54 Remaining 116 % Used (8,153.54) ** Department Totals: (2,762,266.54) ** (638,655.74) Monthly Total (10,645,077.00) Budgeted (7,882,810.46) Remaining 26 % Used 77 of 155 glpdatb2 skrolczyk Trophy Club MUD No.1 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) February 17, 2020 Regular Meeting Agenda Packet Page 10 Account: 135-50005-010-000 Salaries & Wages 513 01/10/2020 MUD Payroll 1/10/2020 Salaries & Wages 611 01/24/2020 MUD Payroll 1/24/2020 Salaries & Wages 78,619.24 12,900.38 91,519.62 PR 12,900.37 104,419.99 PR Account: 135-50005-010-000 Salaries & Wages Totals: 25,800.75 104,419.99 ** 350,267.00 Budgeted 245,847.01 Remaining 30 % Used Account: 135-50010-010-000 Overtime 513 01/10/2020 MUD Payroll 1/10/2020 Overtime 5,390.37 981.83 6,372.20 PR 611 01/24/2020 MUD Payroll 1/24/2020 Overtime 1,275.48 7,647.68 PR Account: 135-50010-010-000 Overtime Totals: 2,257.31 7,647.68 ** 17,000.00 Budgeted 9,352.32 Remaining 45 % Used Account: 135-50016-010-000 Longevity 5,082.50 .00 5,082.50 Account: 135-50016-010-000 Longevity Totals: .00 5,082.50 ** 3,920.00 Budgeted (1,162.50) Remaining 130 % Used Account: 135-50017-010-000 Certification 611 01/24/2020 MUD Payroll 1/24/2020 Certification 1,225.00 425.00 1,650.00 PR Account: 135-50017-010-000 Certification Totals: 425.00 1,650.00 ** 5,400.00 Budgeted 3,750.00 Remaining 31 5 Used Account: 135-50020-010-000 Retirement 513 01/10/2020 MUD Payroll 1/10/2020 611 01/24/2020 MUD Payroll 1/24/2020 Retirement Retirement 9,435.00 1,285.49 10,720.49 PR 1,352.04 12,072.53 PR Account: 135-50020-010-000 Retirement Totals: 2,637.53 12,072.53 ** 34,863.00 Budgeted 22,790.47 Remaining 35 % Used Account: 135-50026-010-000 Medical Insurance 513 01/10/2020 MUD Payroll 1/10/2020 Medical Insurance 13,928.54 611 01/24/2020 MUD Payroll 1/24/2020 Medical Insurance 2,612.55 16,541.09 PR 2,612.49 19,153.58 PR Account: 135-50026-010-000 Medical Insurance Totals: 5,225.04 19,153.58 ** 84,326.00 Budgeted 65,172.42 Remaining 23 5 Used 78 of 155 glpdatb2 skrolczyk Trophy Club MUD No.1 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) February 17, 2020 Regular Meeting Agenda Packet Page 11 ACOOunt: 135-50027}0- ental IneuI 513 01/10/2020 MUD Payroll 1/10/2020 Dental Insurance 611 01/24/2020 MUD Payroll 1/24/2020 Dental Insurance Account: - Dental Ineuranc Totals: 4,725.00 Budgeted 3,560.15 Remaining Account: 135-50028-010-000 Vision Insurance 513 01/10/2020 MUD Payroll 1/10/2020 Vision Insurance 611 01/24/2020 MUD Payroll 1/24/2020 Vision Insurance 847.92 158.47 1,006.39 PR 158.46 1,164.85 PR 1 25 % Used 139.75 24.10 163.85 PR 24.08 187.93 PR Account: 135-50028-01C1 Vision Insurance Totals: 767.00 Budgeted 579.07 Remaining 25 % Used Life Insurance & Other 432 01/01/2020 Payroll Benefits January 452 01/01/2020 Payroll Benefits January 646 01/29/2020 January A/P Employee Benefits Employee LTD & STD caf 125 -December 871.12 200.64 1,071.76 Humana Inc 132.01 1,203.77 METLIFE GROUP BENEFITS 20.00 1,223.77 BenefitMall 6035 AP 6042 AP 6128 AP Account: 135-50029-010-000 Life Insurance & Other Totals: Account: 135-50030-010-000 513 01/10/2020 MUD Payroll 1/10/2020 611 01/24/2020 MUD Payroll 1/24/2020 Account: 513 01/10/2020 MUD Payroll 1/10/2020 611 01/24/2020 MUD Payroll 1/24/2020 3,132.00 Budgeted 1,908.23 Remaining 39 % Used Social Security Taxes Social Security Taxes Social Security Taxes Social S- 23,348.00 Budgeted Medicare Taxes Medicare Taxes Medicare Taxes Account: Medicare Taxe, m. 5,461.00 Budgeted Account: 135-50 513 01/10/2020 MUD Payroll 1/10/2020 16,071.24 Unemployment Taxes Remaining 3,759.20 Remaining 5,538.84 31 1,295.35 848.22 889.70 Used 6,387.06 7,276.76 198.38 1,493.73 208.07 1,701.80 31 % Used 16.68 79 of 155 13.88 30.56 PR PR PR PR PR glpdatb2 skrolczyk Trophy Club MUD No.1 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) February 17, 2020 Regular Meeting Agenda Packet Page 12 611 01/24/2020 MUD Payroll 1/24/2020 Unemployment Taxes 16.68 14.60 Account: 135-50040-010-8 Unemployment Taxes T 28 1,080.00 Budgeted Account: 135-50045-010-00 Workman's Compensation 69 01/01/2020 Insurance/Wrk Comp Expense Jan Account: 135-50045-010-006 Compensation 11,850.00 Budgeted 1,034.84 Remaining 4 % Used 2,314.47 771.49 8,764.04 Remaining 26 % Used 45.16 PR 3,085.96 GL Account: 135-50060-010-000 � Pre-emp Physicals/Testing .00 .00 Account: 135-50060-010-000 * Pre-emp Physicals/Testing Tota 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-50070-010-000 Employee Relations .00 .00 Account: 135-50070-010-000 Employee Relations Totals: 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-55005-010-000 Engineering .00 .00 Account: 135-55005-010-000 Engineering Totals: 20,000.00 Budgeted 20,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 596 01/17/2020 January A/P masin break repair -Inverness & 13,919.78 4,375.00 18,294.78 REY-MAR CONSTRUCTION 6115 AP 596 01/17/2020 January A/P water clamps 464.00 18,758.78 Core & Main LP 6094 AP 653 01/26/2020 PCards 12/27/2019-01/26/2020 door handle for breakroom 14.09 18,772.87 AMAZON.COM*AG9SJ5XM3 PC 653 01/26/2020 PCards 12/27/2019-01/26/2020 paint, cement, tape 157.87 18,930.74 THE HOME DEPOT *6581 PC 646 01/29/2020 January A/P antenna @ TW Ring Tank 1,965.30 20,896.04 DHS AUTOMATION, INC 6132 AP 646 01/29/2020 January A/P blue marking flags 100.00 20,996.04 Core & Main LP 6130 AP 723 01/31/2020 January A/P parts 180.00 21,176.04 Core & Main LP AP 80 of 155 glpdatb2 skrolczyk 10:44 02/11/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Account: 135-55085-010-000 Account: 135-55085-010-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 1/2020 JE Detail Description/Comment February 17, 2020 Regular Meeting Agenda Packet Page 13 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) Maintenance & Repairs 100,000.00 Budgeted 78,823.96 Remaining Generator Maint. and Repair 21 % Used .00 Generator Maint. and Repair Totals: 3,000.00 Budgeted 3,000.00 Remaining Account: 135- Vehicle Maintenance 653 01/26/2020 PCards 12/27/2019-01/26/2020 windshield wipers 658 01/27/2020 PCards 1/27/2020 trailer wire, connector Account: 135-55090-010-000 Account: 135-55105-010-000 Account: 135-55105-010-000 Vehicle Maintenance Totals: 5,000.00 Budgeted 0 % Used .00 379.24 39.98 419.22 AUTOZONE #4206 PC 22.43 441.65 ROANOKE AUTO SUPPLY LT PC 4,558.35 Remaining 9 % Used ■ Maintenance-Backhoe/SkidLoader 920.37 Maintenance-Backhoe/SkidLoader Totals: i 3,500.00 Budgeted 2,579.63 Remaining 26 % Ueed Account: 135-55120-010-000 - Cleanin 646 01/29/2020 January A/P Janitorial svc-December Account: 135-55120-010-000 Cleaning Services otals: 1,000.00 Budgeted 737.50 Remaining Account: 135-55135-010-000 596 01/17/2020 January A/P Account: 135-55135-010-000 Account: 135-6' 597 01/20/2020 January A/P Lab Analysis water samples Lab Analysis 7,500.00 Budgeted 6,152.30 Remaining cell phones -January 175.00 .00 920.37 87.50 26 % Used 262.50 MEMBER'S BUILDING MAINTENANCE 6144 AP 1,147.70 200.00 1,347.70 TARRANT CTY PUBLIC HEALTH LAB 6116 AP 18 % Used 1,624.35 81 of 155 424.30 2,048.65 VERIZON WIRELESS 6124 AP glpdatb2 skrolczyk Trophy Club MUD No.1 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) February 17, 2020 Regular Meeting Agenda Packet Page 14 Accamp Account: Communications/Mobiles 5,000.00 Budgeted Electric 2,951.35 Remaining 41 % Used 598 01/20/2020 January A/P Electricity 12/10-1/10 Electricity Totals: 125,677.00 Budgeted 86,350.17 Remaining Account: 135-60066-010-000 lir Publications/Books/Subscripts Account: 135-60066-010-000 Account: 135-60070-010-000 Publications/Books/Subscripts Totals: 1,000.00 Budgeted 1,000.00 Remaining Dues & Memberships Account: 135-60070-010-00 Dues & Memberships 500.00 Budgeted Account: 135-60080-010- choole & Traini 653 01/26/2020 PCards 12/27/2019-01/26/2020 Account: 135-60080-0 Account: 135-60090-01 Account: 135-60090-010-000 Account: 135-60100-010-000 500.00 Remaining Clayton Water License 7,426.00 Budgeted Safety Program Safety Program 400.00 Budgeted Travel & per diem 7,020.00 Remaining 33,423.43 5,903.40 295.00 31 % Used 0 % Used 0 % Used 2,048.65 ** 39,326.83 HUDSON ENERGY SERVICES, LLC 6104 AP 5,903.40 39,326.83 ** .00 .00 .00 ** .00 .00 111.00 5 % Used 406.00 .00 .00 400.00 Remaining 0 % Used 82 of 155 .00 .00 TCEQ EPAYMENT PC glpdatb2 skrolczyk 10:44 02/11/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Department: 10 Water JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 1/2020 Beginning Balance February 17, 2020 Regular Meeting Agenda Packet Page 15 Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) Check Source Number 83 of 155 Account: 135-60100-010-000 Travel & per diem Totals: .00 .00 ** 2,845.00 Budgeted 2,845.00 Remaining 0 5 Used Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 5 Used Account: 135-60135-010-000 TCEQ Fees & Permits 646 01/29/2020 January A/P TIER 2 Submittal 14,207.15 50.00 14,257.15 TX COMMISSION ENVIRONMENTAL QU 6154 AP Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 50.00 14,257.15 ** 63,000.00 Budgeted 48,742.85 Remaining 23 % Used Account: 135-60150-010-000 Wholesale Water 651 01/30/2020 January A/P wholesale water 350,392.70 118,562.59 468,955.29 CITY OF FORT WORTH 6129 AP Account: 135-60150-010-000 Wholesale Water Totals: 118,562.59 468,955.29 ** 2,714,710.00 Budgeted 2,245,754.71 Remaining 17 5 Used Account: 135-60245-010-000 M Miscellaneous Expenses .00 .00 Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60280-010-000 Property Maintenance 462.00 .00 462.00 Account: 135-60280-010-000 Property Maintenance Totals: .00 462.00 ** 3,000.00 Budgeted 2,538.00 Remaining 15 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 83 of 155 glpdatb2 skrolczyk 10:44 02/11/20 Fund: 135 MUD 1 General Fund Account JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 1/2020 JE Detail Description/Comment February 17, 2020 Regular Meeting Agenda Packet Page 16 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) Lawn Equipment & Maintenance Totals: 14,750.00 Budgeted 14,750.00 Remaining LInterfund Transfer Out -Rev I&S 645 01/30/2020 TexPool Transfers January TexPool O&M to 16Swift Rev I&S 645 01/30/2020 TexPool Transfers January TexPool O&M to 19 W&WW Rev I&S Account: 135-60331 Interfund Transfer Out - 527,381.00 Budgeted Account: 115-60133-010-000 Interfund 335,606.04 143,831.22 Remaining 645 01/30/2020 TexPool Transfers January TexPool O&M to Rev Bond Resevr Accoun r Out -Reserve Tota 55,193.00 Budgeted 36,793.00 Remaining Account: 135-60334-010-000 Account: 135-60334-010-000 Account: 135-60360-010-000 Account: 135-60360-010-000 Account: 135-65005-010-000 640 01/24/2020 Fuel Account: 135-65005-010-000 Account: 135-65010-010-000 Interfund Transfer Out Interfund Transfer Out Totals: 180,000.00 Budgeted 180,000.00 Remaining Furniture/Equipment < $5000 0 % Used 25,047.72 168,878.94 22,896.02 36 % Used 191,774.96 GL GL 13,800.00 4,600.00 18,400.00 GL 33 % Ueed .00 .00 0 % Ueed 561.72 .00 561.72 Furniture/Equipment < $5000 Totals: .00 2,500.00 Budgeted 1,938.28 Remaining 22 % Used AIL Al & Lube Fuel -JAN 2,428.93 1,140.42 3,569.35 US Bank Voyager Fleet Systeme 6155 AP 1,140.42 15,000.00 Budgeted 11,430.65 Remaining 24 % Used 2,917.33 .00 2,917.33 84 of 155 glpdatb2 skrolczyk 10:44 02/11/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Department: 10 Water JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 1/2020 Beginning Balance February 17, 2020 Regular Meeting Agenda Packet Page 17 Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) Check Source Number 85 of 155 Account: 135-65010-010-000 Uniforms Totals: .00 2,917.33 ** 5,190.00 Budgeted 2,272.67 Remaining 56 5 Used Account: 135-65030-010-000 Chemical= 596 01/17/2020 651 01/30/2020 723 01/31/2020 January A/P January A/P January A/P testing supplies chlorine Testing supplies 4,865.04 977.77 558.40 1,223.94 5,842.81 6,401.21 7,625.15 HACH COMPANY DPC INDUSTRIES, INC HACH COMPANY 6103 6133 AP AP AP Account: 135-65030-010-000 ` Chemicals Totals: 2,760.11 7,625.15 ** 20,000.00 Budgeted 12,374.85 Remaining 38 % 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 5 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 596 01/17/2020 596 01/17/2020 January A/P January A/P meters meters 8,875.28 2,970.00 4,259.50 11,845.28 16,104.78 ATLAS UTILITY SUPPLY ATLAS UTILITY SUPPLY CO. CO. 6092 6092 AP AP Account: 135-65050-010-000 Meter Expense Totals: 7,229.50 16,104.78 ** 70,000.00 Budgeted 53,895.22 Remaining 23 5 Used Account: 135-65053-010-000 Meter Change Out Program 596 01/17/2020 January A/P meter heads 36,900.00 36,900.00 ATLAS UTILITY SUPPLY CO. 6092 AP Account: 135-65053-010-000 Meter Change Out Program Totals: 36,900.00 36,900.00 ** 87,000.00 Budgeted 50,100.00 Remaining 42 5 Used Account: 135-69005-010-000 Capital Outlays 85 of 155 glpdatb2 skrolczyk Trophy Club MUD No.1 10:44 02/11/20 Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 1/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 February 17, 2020 Regular Meeting Agenda Packet Page 18 596 01/17/2020 January A/P well #1 646 01/29/2020 January A/P LS upgrades FY 19 646 01/29/2020 January A/P easement 90,568.03 58,645.00 9,125.00 7,452.00 149,213.03 MILLICAN WELL SERVICE, LLC 158,338.03 DHS AUTOMATION, INC 165,790.03 Jackson Walker LLP 6111 AP 6132 AP 6138 AP Account: 135 Capital Outlays Totals: 684,875.00 Budgeted 519,084.97 Remaining 24 % Used Account: 135-69008-010-000 Alb Short Term Debt -Principal 646 01/29/2020 January A/P Vaccon P & I payment Account: 135-69008-010-000 Short Term Debt -Principal 30,512.00 Budgeted 30,512.00 Totals: Account: 135-69009-010-000 IlLriferm Debt -Interest 646 01/29/2020 January A/P Vaccon P & I payment Account: 135-69009-010-000 Account: 135-69195-010-000 .00 Remaining 100 % Used Short Term Debt -Interest Totals: 3,231.00 Budgeted 1,391.00 Remaining Gasb34/Reserve for Replacement Account: 135-69195-010-000 mil Gasb34/Reserve for Replacement Totals: 75,000.00 Budgeted .00 Remaining 596 01/17/2020 January A/P 596 01/17/2020 January A/P Account: 135-69281-010-000 Water Tank Inspection Contract PID tank inspection tank contract Water Tank Inspection Contract Total 120,000.00 Budgeted 17,922.89 Remaining 75,000.00 57 % Used 1,840.00 1,840.00 30,512.00 FIRST FINANCIAL BANK 1,840.00 FIRST FINANCIAL BANK .00 75,000.00 100 % Used 57,932.73 2,200.00 41,944.38 85 % Used 86 of 155 6134 AP 6134 AP 60,132.73 UTILITY SERVICE CO, INC. 6122 AP 102,077.11 UTILITY SERVICE CO, INC. 6122 AP glpdatb2 skrolczyk 10:44 02/11/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 1/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) February 17, 2020 Regular Meeting Agenda Packet Page 19 JE Detail Description/Comment Account: 135-55135-010-001 Lab Analysis for PID 596 01/17/2020 January A/P water samples 387.70 80.00 467.70 TARRANT CTY PUBLIC HEALTH LAB 6116 AP Account: 135-55135-010-001 Lab Analysis for PID Totals: 80.00 467.70 ** 2,000.00 Budgeted 1,532.30 Remaining 23 9 Used Department 10 Totals: 1,367,856.82 ** 425,037.34 Monthly Total 5,506,929.00 Budgeted 4,139,072.18 Remaining 25 % Used 87 of 155 February 17, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/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-000 Salaries & Wages 513 01/10/2020 MUD Payroll 1/10/2020 Salaries & Wages 611 01/24/2020 MUD Payroll 1/24/2020 Salaries & Wages 87,226.30 16,024.41 103,250.71 PR 15,926.44 119,177.15 PR Account: 135-50005-020-000 Salaries & Wages Totals: 31,950.85 119,177.15 ** 441,799.00 Budgeted 322,621.85 Remaining 27 % Used Account: 135-50010-020-000 Overtime 513 01/10/2020 MUD Payroll 1/10/2020 Overtime 6,099.72 1,050.62 7,150.34 PR 611 01/24/2020 MUD Payroll 1/24/2020 Overtime 914.93 8,065.27 PR Account: 135-50010-020-000 Overtime Totals: 1,965.55 8,065.27 ** 33,000.00 Budgeted 24,934.73 Remaining 24 % Used Account: 135-50016-020-000 Longevity 6,872.50 .00 6,872.50 Account: 135-50016-020-000 Longevity Totals: .00 6,872.50 ** 8,035.00 Budgeted 1,162.50 Remaining 86 % Used Account: 135-50017-020-000 Certification 611 01/24/2020 MUD Payroll 1/24/2020 Certification 1,900.00 650.00 2,550.00 PR Account: 135-50017-020-000 Certification Totals: 650.00 2,550.00 ** 9,000.00 Budgeted 6,450.00 Remaining 28 % Used Account: 135-50020-020-000 Retirement 513 01/10/2020 MUD Payroll 1/10/2020 611 01/24/2020 MUD Payroll 1/24/2020 Retirement Retirement 10,982.75 1,581.15 12,563.90 PR 1,619.69 14,183.59 PR Account: 135-50020-020-000 Retirement Totals: 3,200.84 14,183.59 ** 45,531.00 Budgeted 31,347.41 Remaining 31 % Used Account: 135-50026-020-000 Medical Insurance 513 01/10/2020 MUD Payroll 1/10/2020 Medical Insurance 18,313.59 611 01/24/2020 MUD Payroll 1/24/2020 Medical Insurance 3,869.14 22,182.73 PR 3,869.10 26,051.83 PR Account: 135-50026-020-000 Medical Insurance Totals: 7,738.24 26,051.83 ** 104,858.00 Budgeted 78,806.17 Remaining 25 % Used 88 of 155 February 17, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/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-50027020- ental InsuI 513 01/10/2020 MUD Payroll 1/10/2020 Dental Insurance 611 01/24/2020 MUD Payroll 1/24/2020 Dental Insurance Account: -1.1 Dental Insuranc Totals: 5,817.00 Budgeted 4,278.48 Remaining Account: 135-50028-020-000 Vision Insurance 513 01/10/2020 MUD Payroll 1/10/2020 Vision Insurance 611 01/24/2020 MUD Payroll 1/24/2020 Vision Insurance 1,091.02 223.77 1,314.79 PR 223.73 1,538.52 PR _ 4 26 % Used 180.95 34.87 215.82 PR 34.87 250.69 PR Account: 135-50028-020-000 Vision Insurance Totals: 948.00 Budgeted 697.31 Remaining 26 % Used Life Insurance & Other 432 01/01/2020 Payroll Benefits January 452 01/01/2020 Payroll Benefits January 646 01/29/2020 January A/P Employee Benefits Employee LTD & STD caf 125 -December 1,014.05 174.57 1,188.62 Humana Inc 165.74 1,354.36 METLIFE GROUP BENEFITS 36.00 1,390.36 BenefitMall 6035 AP 6042 AP 6128 AP Account: 135-50029-020-000 Life Insurance & Other Totals: Account: 135-50030-020-000 513 01/10/2020 MUD Payroll 1/10/2020 611 01/24/2020 MUD Payroll 1/24/2020 Account: 135-50035-020-000 513 01/10/2020 MUD Payroll 1/10/2020 611 01/24/2020 MUD Payroll 1/24/2020 4,500.00 Budgeted 3,109.64 Remaining 31 % Used Social Security Taxes Social Security Taxes Social Security Taxes Social Security T 30,494.00 Budgeted Medicare Taxes Medicare Taxes Medicare Taxes Account: 135-50035-020-000 Medicare Taxe, m. 7,132.00 Budgeted 22,542.29 Account: 135-50040-0 513 01/10/2020 MUD Payroll 1/10/2020 Unemployment Taxes Remaining 5,963.49 1,394.67 26 1,000.04 988.18 Used 6,963.53 7,951.71 233.88 1,628.55 231.11 1,859.66 5,272.34 Remaining 26 % Used 89 of 155 PR PR PR PR 17.07 17.07 PR February 17, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 611 01/24/2020 MUD Payroll 1/24/2020 Unemployment Taxes Account: 135 -50040 -020 - Unemployment Taxes Totals: 1,260.00 Budgeted Account: 135-50045-020-00 Workman's Compensation 69 01/01/2020 Insurance/Wrk Comp Expense Jan Account: 135-50045-020-00 s Compensation 15,373.00 Budgeted Account: 135-50060-020-000 � Pre-emp Physicals/Testing 17.49 34.56 PR 1,225.44 Remaining 3 % Used 34 3,330.60 1,110.20 10,932.20 Remaining 29 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing Tota 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-50070-020-000 Employee Relations Account: 135-50070-020-000 Employee Relations Totals: 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-55005-020-000 Engineering 4,440.80 GL .00 .00 .00 .00 .00 .00 Account: 135-55005-020-000 Engineering Totals: 30,000.00 Budgeted 30,000.00 Remaining 0 % Ueed Account: 135-55070-020-000 Independent Labor 3,000.00 Account: 135-55070-020-000 Independent Labor 15,000.00 Budgeted Account: 135-551Ie & R 523 01/07/2020 January A/P oil .00 3,000.00 12,000.00 Remaining 20 % Used 15,624.92 366.09 15,991.01 LUBRICATION ENGINEERS, INC 90 of 155 6088 AP glpdatb2 skrolczyk 10:44 02/11/20 Fund: 135 MUD 1 General Fund JE Number JE Date 596 01/17/2020 596 01/17/2020 653 01/26/2020 653 01/26/2020 653 01/26/2020 646 01/29/2020 646 01/29/2020 651 01/30/2020 JE Description January A/P January A/P PCards 12/27/2019-01/26/2020 PCards 12/27/2019-01/26/2020 PCards 12/27/2019-01/26/2020 January A/P January A/P January A/P Account: 135-55080-020-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 1/2020 JE Detail Beginning Balance Description/Comment 3 sets forks for back hoe butterfly valve Tape, pvc, adapters Nuts, washers, u post adapters, clamps floats & install for WWTP 10" flanges for RAS pumps Emergency repair -13 Heritage C Maintenance & Repairs 88,000.00 Budgeted 59,284.83 Remaining 15,624.92 Program: Transaction Detail 33 % Used February 17, 2020 Regular Meeting Agenda Packet Page 23 Transaction Vendor Name Detail (SUBTOTAL) 9,900.00 25,891.01 220.00 26,111.01 182.63 26,293.64 25.81 26,319.45 21.72 26,341.17 765.00 27,106.17 1,150.00 28,256.17 459.00 28,715.17 28,715.17 RDO Equipment Co Core & Main LP THE HOME DEPOT #6581 THE HOME DEPOT #6581 THE HOME DEPOT #6581 DHS AUTOMATION, INC NORTH TEXAS PUMP CO. Sandra Stiltner Check Source Number 6114 AP 6094 AP PC PC PC 6132 AP 6146 AP 6150 AP ACCO : 135 -55081 -020 - Mainten & Repairs Co 523 01/07/2020 January A/P 653 01/26/2020 PCards 12/27/2019-01/26/2020 646 01/29/2020 January A/P Account: 135 Account: 135-55085-020-000 Account: 135-55085-020-000 LS twenty pvc pipes clean out shie Mainten & Repairs Collections Totals: 10,000.00 Budgeted (5,378.45) Remaining Generator Maint. and Repair Generator Maint. and Repair Totals: 10,000.00 Budgeted 10,000.00 Remaining Vehicle Maintenance 653 01/26/2020 PCards 12/27/2019-01/26/2020 653 01/26/2020 PCards 12/27/2019-01/26/2020 653 01/26/2020 PCards 12/27/2019-01/26/2020 oil change oil change Air Filter, fluids Account: 135-55090-020-00 Vehicle Maintenance Totals: 4,000.00 Budgeted 3,317.02 Remaining 14,277.16 154 % Used 646.00 14,923.16 DHS AUTOMATION, INC 337.87 15,261.03 FERGUSON ENT 1241 117.42 15,378.45 Core & Main LP .00 0 % Used .00 404.23 87.89 492.12 GIERISCH CARE 0050292 88.91 581.03 GIERISCH CARE 0050292 101.95 682.98 ROANOKE AUTO SUPPLY LT 17 % Used 6082 AP PC 6130 AP PC PC PC Account: Veh Maintenance Collections 653 01/26/2020 PCards 12/27/2019-01/26/2020 653 01/26/2020 PCards 12/27/2019-01/26/2020 653 01/26/2020 PCards 12/27/2019-01/26/2020 653 01/26/2020 PCards 12/27/2019-01/26/2020 Tax on oil change oil change plus tax vehicle registration Fee for Vehicle Registration 1,860.08 91 of 155 (27.86) 90.48 8.25 2.00 1,832.22 1,922.70 1,930.95 1,932.95 FERGUSON ENT 1241 KWIK KAR LUBE & TUNE 0 DENTON VEHREG TX.GOV*SERVICEFEE-DIR PC PC PC PC glpdatb2 skrolczyk 10:44 02/11/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 1/2020 JE Detail Beginning Balance Description/Comment Veh Maintenance Collectio 8,000.00 Budgeted 6,067.05 Remaining Program: Transaction Detail 24 % Ueed 7a February 17, 2020 Regular Meeting Agenda Packet Page 24 Transaction Vendor Name Detail (SUBTOTAL) Check Source Number Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Account: 135-55105-020-000 Account: 135-55120-020-000 646 01/29/2020 January A/P Account: 135-55120-020-000 Account: 135-55125-020-000 596 01/17/2020 January A/P 596 01/17/2020 January A/P 646 01/29/2020 January A/P 723 01/31/2020 January A/P 734 01/31/2020 January A/P Account: 135-55125-020-000 Account: 135-55135-020-000 ' 596 01/17/2020 January A/P 596 01/17/2020 January A/P 596 01/17/2020 January A/P 596 01/17/2020 January A/P 646 01/29/2020 January A/P 646 01/29/2020 January A/P 723 01/31/2020 January A/P 723 01/31/2020 January A/P 723 01/31/2020 January A/P Maintenance-Backhoe/SkidLoader Totals: 3,000.00 Budgeted 2,495.32 Remaining Cleaning Services janitorial svC-December Cleaning Services 1,500.00 Budgeted Dumpster Services sludge/grit sludge haul off sludge/grit sludge/grit sludge/grit Dumpster Services 100,000.00 Budgeted Total.. 1,237.50 Remaining 67,213.22 lab testing lab testing lab testing lab trsting lab testing lab trsting lab testing lab trsting Calibrate lab scale ACCOu yeie 40,000.00 Budgeted Remaining 504.68 17 % Used .00 504.68 175.00 87.50 262.50 MEMBER'S BUILDING MAINTENANCE 20,576.50 10,059.14 18 % Used 33 % Used 27,283.55 Remaining 32 % Ueed 92 of 155 2,573.62 2,183.02 2,505.42 2,600.90 2,347.32 23,150.12 25,333.14 27,838.56 30,439.46 32,786.78 317.40 10,376.54 230.00 10,606.54 341.55 10,948.09 241.50 11,189.59 341.55 11,531.14 241.50 11,772.64 341.55 12,114.19 241.50 12,355.69 360.76 12,716.45 L.H. CHANEY MATERIALS, INC. 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 OXIDOR LABORATORIES LLC OXIDOR LABORATORIES LLC METTLER TOLEDO INTERNATIONAL 6144 AP 6107 AP 6107 AP 6141 AP AP AP 6113 AP 6113 AP 6113 AP 6113 AP 6148 AP 6148 AP AP AP AP February 17, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 465 01/02/2020 January A/P 597 01/20/2020 January A/P Account: ..0-02 - Communications/Mobiles — PID inverted siphon cell phones -January 1,585.66 276.00 408.87 Communications/Mobil Totals: 5,000.00 Budgeted 2,729.47 Remaining Account: 135-60020-020-000 Electricity 596 01/17/2020 January A/P electricity 11/27-1/2 598 01/20/2020 January A/P Electricity 12/10-1/10 733 01/31/2020 Town Billed Invoices 1722-1725 AR 20200131-20200131 User: Account: 135-60020-020-000— Electri. 160,067.00 Budgeted 112,193.53 Remaining 45 % Used 1,861.66 OMNISITE 6045 AP 2,270.53 VERIZON WIRELESS 6124 AP 35,143.35 624.40 35,767.75 TRI COUNTY ELECTRIC 6121 AP 12,728.09 48,495.84 HUDSON ENERGY SERVICES, LLC 6104 AP (622.37) 47,873.47 AR 30 Used Account: 135-60066-020-000 Publications/Books/Subscripts Account: 135-60066-020-000 Publications/Books/Subscripts Tot 200.00 Budgeted 200.00 Remaining 0 Used .00 .00 Account: 135-60070-020-000 Dues & Memberships 111.00 .00 111.00 Account: 135-60070-020-000 Dues & Memberships Totals: 111.00 ** 300.00 Budgeted 189.00 Remaining 37 % Used Account: 135 Schools & Training 658 01/27/2020 PCards 1/27/2020 Surface water class- F. Isola Account: 135-60080-020-00 Schools & Training 4,990.00 Budgeted 1,470.85 440.00 Totals: 3,079.15 Remaining 38 % Used 1,910.85 TEEX ECOMMERCE PC Account: 135-60090-020-000 Safety Program Account: 135-60090-020-00 109.14 Safety Program Totals: 1,000.00 Budgeted 890.86 Remaining 11 % Used 93 of 155 .00 109.14 glpdatb2 skrolczyk 10:44 02/11/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 1/2020 JE Detail Description/Comment February 17, 2020 Regular Meeting Agenda Packet Page 26 Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Check Source Number 94 of 155 Account: 135-60100-020-000 Travel & per diem 646 01/29/2020 January A/P tolls to Austin -GM car 356.71 4.13 360.84 Texas Tollways/TxTag 6153 AP Account: 135-60100-020-000 Travel & per diem Totals: 4.13 360.84 ** 1,545.00 Budgeted 1,184.16 Remaining 23 % Used Account: 135-60105-020-000 Rent/Lease Equipment .00 .00 Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 5 Used Account: 135-60125-020-000 Advertising .00 .00 Account: 135-60125-020-000 Advertising Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 10,088.02 .00 10,088.02 Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 10,088.02 ** 15,000.00 Budgeted 4,911.98 Remaining 67 % Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** 450.00 Budgeted 450.00 Remaining 0 % Used Account: 135-60280-020-000 Property Maintenance .00 .00 Account: 135-60280-020-000 Property Maintenance Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 94 of 155 February 17, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/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-60285-1 Lawn Equipment & Maintenance Totals: 14,000.00 Budgeted 14,000.00 Remaining Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S 645 01/30/2020 TexPool Tlansfers January TexPool O&M to I&S- PID Debt Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S Tot 114,563.00 Budgeted 72,903.76 .00 .00 0 % Used Remaining Account: 135-60332 020- aterfund T -Rev I&S 645 01/30/2020 TexPool Transfers January TexPool O&M to Rev Bd WWTP I&S 645 01/30/2020 TexPool Transfers January TexPool O&M to 19 W&WW Rev I&S Account1332-02 - Interfund Transfer Ou 673,867.00 Budgeted 31,244.43 10,414.81 41,659.24 GL 183,781.50 36 % Used 54,421.63 238,203.13 6,839.07 245,042.20 428,824.80 Remaining 36 % Used Account: 135-60333-020-000 Interfund Transfer Out -Reserve 645 01/30/2020 TexPool Transfers January TexPool O&M to Rev Bond Resevr Account: 135-60333-020-000 Account: 135-60334-020-000 Account: 135-60334-020-000 Account: 135-60360-020-000 Account: 135-60360-020-000 Account: 135-65005-020-000 Interfund Transfer Out -Reserve Tota 125,187.00 Budgeted 102,187.00 Remaining Interfund Transfer Ou 180,000.00 Budgeted 180,000.00 Remaining 17,250.00 18 % Used 0 Used 5,750.00 23,000.00 00 .00 GL GL GL Furniture/Equipment < $5000 Furniture/Equipment < $500 2,000.00 Budgeted 1,810.00 Remaining 190.00 10 Used .00 190.00 Fuel & Lube 95 of 155 glpdatb2 skrolczyk 10:44 02/11/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 640 01/24/2020 Fuel Account: 135-65010-020-000 Account: 135-65010-020-00 Account: 135-65030-020- 596 01/17/2020 January A/P 646 01/29/2020 January A/P 734 01/31/2020 January A/P Account: 135- Account: 135-65031-020-000 Account: 135-65031-020-000 Account: 135-65035-020-000 Account: 135-65035-020-000 Account: 135-65040-020-000 Account: 135-65040-020-000 Account: 135-65045-020-000 12,500.00 5,495.00 Chemical February 17, 2020 Regular Meeting Agenda Packet Trophy Club MUD No.1 Page 28 Detailed Accounting Trial Balance Department: 20 Wastewater Program: Period Ending: 1/2020 JE Detail Beginning Transaction Transaction Vendor Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) Fuel -JAN Budgeted Budgeted sodium hypo sodium hypo 12.5% De foamier 20,000.00 Budgeted Chemicals Collections Chemicals Collections 17,500.00 Budgeted Small Tools 9,539.60 1,987.07 Remaining Remaining 2,335.18 625.22 2,960.40 US Bank Voyager Fleet Systems 6155 AP 3,507.93 6,820.56 24 % Used 64 % Used Totals: 10,131.73 Remaining 49 % Used 4,994.00 12,506.00 Remaining 29 % Used Small Tools Totals: 1,200.00 Budgeted Safety Equipment Safety Equipment 1,200.00 Budgeted 1,200.00 Remaining 0 % Ueed 1,088.92 .00 569.00 717.50 1,761.21 3,507.93 7,389.56 Valley Solvent Company, INC 8,107.06 Valley Solvent Company, INC 9,868.27 MARYLAND BIOCHEMICAL CO, INC .00 4,994.00 .00 .00 .00 1,088.92 Totals: 111.08 Remaining 91 % Used 6123 AP 6156 AP AP Lab Supplies 96 of 155 February 17, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 29 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 523 01/07/2020 January A/P gloves 8,006.39 169.20 8,175.59 LOU'S GLOVES INCORPORATED 6087 AP 523 01/07/2020 January A/P lab supplies 1,463.76 9,639.35 IDEXX DISTRIBUTION, INC 6085 AP 523 01/07/2020 January A/P Lab supplies 458.66 10,098.01 IDEXX DISTRIBUTION, INC 6085 AP 596 01/17/2020 January A/P lab supplies 229.33 10,327.34 IDEXX DISTRIBUTION, INC 6105 AP 596 01/17/2020 January A/P lab supplies 505.07 10,832.41 IDEXX DISTRIBUTION, INC 6105 AP 653 01/26/2020 PCards 12/27/2019-01/26/2020 distilled water 4.95 10,837.36 TOM THUMB #1789 PC Account: 135-65045-020-000 Lab Supplies Totals: 2,830.97 10,837.36 ** 20,000.00 Budgeted 9,162.64 Remaining 54 % Used Account: 135-69005-020-000 Capital Outlays 646 01/29/2020 January A/P 646 01/29/2020 January A/P 651 01/30/2020 January A/P hoes for plants and reels hoses for plants and reels In -plant water system WWTP 94,215.85 1,074.13 187.41 50,394.70 95,289.98 Stuart Hose & Pipe 95,477.39 Stuart Hose & Pipe 145,872.09 REY-MAR CONSTRUCTION 6151 AP 6151 AP 6149 AP Account: 135-69005-020-000 Capital Outlays Totals: 51,656.24 145,872.09 ** 530,500.00 Budgeted 384,627.91 Remaining 27 % Used Account: 135-69008-020-000 Short Term Debt -Principal 646 01/29/2020 January A/P 646 01/29/2020 January A/P Camera van P & I pymnt 19,158.74 Vaccon P & I payment 40,446.00 19,158.74 FIRST FINANCIAL BANK 6134 AP 59,604.74 FIRST FINANCIAL BANK 6134 AP Account: 135-69008-020-000 Short Term Debt -Principal Totals: 59,604.74 ** 79,133.00 Budgeted 19,528.26 Remaining 75 % Used Account: 135-69009-020-000 Short Term Debt -Interest 646 01/29/2020 January A/P Camera van P & I pymnt 3,681.96 646 01/29/2020 January A/P Vaccon P & I payment 2,440.07 3,681.96 FIRST FINANCIAL BANK 6134 AP 6,122.03 FIRST FINANCIAL BANK 6134 AP Account: 135-69009-020-000 Short Term Debt -Interest Totals: 6,122.03 6,122.03 ** 11,277.00 Budgeted 5,154.97 Remaining 54 % Used Account: 135-69195-020-000 Gasb34/Reserve for Replacement 130,000.00 .00 130,000.00 Account: 135-69195-020-000 Gasb34/Reserve for Replacement Totals: .00 130,000.00 ** 130,000.00 Budgeted .00 Remaining 100 % Used 97 of 155 February 17, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department 20 Totals: 1,037,817.63 ** 294,666.79 Monthly Total 3,157,421.00 Budgeted 2,119,603.37 Remaining 33 % Used 98 of 155 February 17, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-026-0 Workman's Compensation 69 01/01/2020 lneurance/Wrk Comp Expense Jan 5.97 Acal Workman's Compensation 30.00 Budgeted Total 22.04 Remaining 27 % Used 1.99 7.96 GL 1 Account: 135-60066-026-000 ■ Publications/Books/Subscripts Account: 135-60066-026-000 Publications/Books/Subscripts Totals: 150.00 Budgeted 150.00 Remaining .00 .00 0 % Ueed 111 Dues & Memberships Account: - - - Dues & Memberships Total= 750.00 Budgeted 75.00 Remaining Account: 135-60075-026-000 Meetings 653 01/26/2020 PCarde 12/27/2019-01/26/2020 candy Account: 135-60075-026-00 Meeting. 1,300.00 Budgeted 1,123.72 Remaining 675.00 170.56 .00 90 % Ueed 14 Used 5.72 Account: 135-60080-026-000 .00 Account: 135-60080-026-000 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Account: 135-60100-026-000 Travel & per diem 675.00 176.28 WM SUPERCENTER *5247 .00 .00 .00 Account: 135-60100-026-000 Travel & per diem Totals: 5,000.00 Budgeted 5,000.00 Remaining 0 % Used PC Account: 135-60245-026-000 Miscellaneous Expenses 99 of 155 February 17, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 1/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 i• 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Department 26 Totals: 859.24 ++ 7.71 Monthly Total 13,230.00 Budgeted 100 of 155 12,370.76 Remaining 6 % Used February 17, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/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-5000 030- Salaries & 415 - 513 01/10/2020 MUD Payroll 1/10/2020 Salaries & Wages 611 01/24/2020 MUD Payroll 1/24/2020 Salaries & Wages 88,963.65 15,092.71 104,056.36 PR 15,060.00 119,116.36 PR Account: - Salaries & Wages Totals: 628,298.00 Budgeted 509,181.64 Remaining 19 % Used Account: 135-50010-030-000 Overtime 513 01/10/2020 MUD Payroll 1/10/2020 Overtime Account: 135-50010-030-000 Overtime 2,000.00 Budgeted Account: 135-50016-030-000 11.82 1,983.43 Remaining 1 % Used Account: 135-50016-030-00 Totals: 2,208.00 Budgeted .50 Remaining Account: 135-50020-030-00 irement 513 01/10/2020 MUD Payroll 1/10/2020 Retirement 611 01/24/2020 MUD Payroll 1/24/2020 Retirement Account: 135-50020-030-000 58,554.00 Budgeted Account: 135-50026-030-000edical ce 513 01/10/2020 MUD Payroll 1/10/2020 Medical Insurance 611 01/24/2020 MUD Payroll 1/24/2020 Medical Insurance Account: 135-50026-030-000 45,821.22 Remaining Medical Insurance Totals: 124,394.00 Budgeted 101,581.80 Remaining 2,207.50 100 % Used 9,940.22 16,466.43 Account: 135 Dental Insurance M 513 01/10/2020 MUD Payroll 1/10/2020 Dental Insurance 919.20 611 01/24/2020 MUD Payroll 1/24/2020 Dental Insurance Account: 135 `Dental InsuraaTotals: 6,464.00 Budgeted 5,195.05 Remaining 22 % Used 4.75 16.57 .00 2,207.50 1,398.03 1,394.53 11,338.25 12,732.78 3,172.91 19,639.34 3,172.86 22,812.20 18 % Used 20 % Used 101 of 155 174.88 1,094.08 PR PR PR PR PR PR 174.87 1,268.95 PR glpdatb2 skrolczyk 10:44 02/11/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description February 17, 2020 Regular Meeting Agenda Packet Trophy Club MUD No.1 Page 34 Detailed Accounting Trial Balance Department: 30 Administration Program: Period Ending: 1/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment ACCO -5002:-030- cion Ins 513 01/10/2020 MUD Payroll 1/10/2020 611 01/24/2020 MUD Payroll 1/24/2020 Account: Vision Insurance Vision Insurance ision Insuranc> 1,035.00 Budgeted Account: 135-50029-030-000 Life Insurance & Other 432 01/01/2020 Payroll Benefits January Employee Benefits 452 01/01/2020 Payroll Benefits January Employee LTD & STD 646 01/29/2020 January A/P caf 125 -December Totals: 146.31 1 837.01 Remaining 19 % Used 25.85 172.16 25.83 197.99 943.63 176.22 1,119.85 Humana Inc 151.69 1,271.54 METLIFE GROUP BENEFITS 20.00 1,291.54 BenefitMall PR PR 6035 AP 6042 AP 6128 AP Account: 135-50029-030 4,500.00 Budgeted 3,208.46 Account: 135-50030-030-000 ity Taxes 513 01/10/2020 MUD Payroll 1/10/2020 Social Security Taxes 611 01/24/2020 MUD Payroll 1/24/2020 Social Security Taxes Remaining 5,338.43 29 Used 868.66 6,207.09 860.42 7,067.51 PR PR Account: 135-50030-030-000 Social Security Taxes Totals: 39,215.00 Budgeted Account: 135-50035-030-000 Medicare Taxes 513 01/10/2020 MUD Payroll 1/10/2020 Medicare Taxes 611 01/24/2020 MUD Payroll 1/24/2020 Medicare Taxes Account: 135-50040-030-000 513 01/10/2020 MUD Payroll 1/10/2020 611 01/24/2020 MUD Payroll 1/24/2020 Account: 135-50040-030-000 32,147.49 Remaining 18 % Used Medicare Taxes Totals: 9,171.00 Budgeted Unemployment Taxes Unemployment Taxes Unemployment Taxes Unemployment Taxes 1,440.00 Budgeted Account: 135-50045-03s Compens 69 01/01/2020 Insurance/Wrk Comp Expense Jan 1,248.53 7,518.08 Remaining 18 % Used 1,409.84 Remaining 314.46 203.16 1,451.69 PR 201.23 1,652.92 PR 15.09 15.09 15.07 30.16 2 % Used 102 of 155 104.82 419.28 PR PR GL glpdatb2 skrolczyk 10:44 02/11/20 Fund: 135 MUD 1 General Fund JE Number JE Date Account: 135-50060-030-000 Account: 135-50060-030-000 Account: 135-50070-030-000 Account: 135-50070-030-000 Account: 135-55030-030-000 596 01/17/2020 596 01/17/2020 596 01/17/2020 653 01/26/2020 653 01/26/2020 653 01/26/2020 653 01/26/2020 723 01/31/2020 723 01/31/2020 734 01/31/2020 JE Description January January January PCards PCards PCards PCards January January January Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 1/2020 JE Detail Beginning Balance Description/Comment Workman's Compensation 1,775.00 Budgeted Pre-emp Physicals/Testing 1,355.72 Remaining Pre-emp Physicals/Testing 500.00 Budgeted 500.00 Remaining Employee Relations Employee Relations o a s• 8,000.00 Budgeted 4,921.90 Remaining Software & Support GIS development Microsoft exchange internet-January Internet internet Adobe subscription internet Annual software leaseFY 20 Annual license fee Vision Annual License A/P A/P A/P 12/27/2019-01/26/2020 12/27/2019-01/26/2020 12/27/2019-01/26/2020 12/27/2019-01/26/2020 A/P A/P A/P 723 01/31/2020 January A/P 740 01/31/2020 January A/p 740 01/31/2020 January A/p Software & Support 134,681.00 Budgeted 9,406.78 Remaining Independent Labor GM recruitment gm consulting -January gm consulting -January Independent Labor 135,000.00 Budgeted 24 Program: Transaction Detail Ueed 0 % Ueed 3,078.10 38 % Used 73,404.13 93 % Used 34,035.79 80,175.51 Remaining 41 % Used 103 of 155 February 17, 2020 Regular Meeting Agenda Packet Page 35 Transaction Vendor Name Detail (SUBTOTAL) .00 .00 .00 3,078.10 9,952.61 83,356.74 494.00 83,850.74 899.00 84,749.74 42.37 84,792.11 42.37 84,834.48 36.78 84,871.26 53.91 84,925.17 16,800.00 101,725.17 22,587.00 124,312.17 962.05 125,274.22 10,000.00 10,780.00 8.70 Halff Associates, INC M3 Networks Charter Communications ATT*BILL PAYMENT ATT*BILL PAYMENT ADOBE ACROPRO SUBS ATT*BILL PAYMENT STW INC OpenGov, Inc SW INC Check Source Number 44,035.79 Strategic Government Resources 54,815.79 Carman Consulting LLC. 54,824.49 Carman Consulting LLC. 6102 AP 6108 AP 6093 AP PC PC PC PC AP AP AP AP AP AP glpdatb2 skrolczyk 10:44 02/11/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 1/2020 Beginning Balance JE Detail Description/Comment Program: Transaction Detail February 17, 2020 Regular Meeting Agenda Packet Page 36 Transaction Vendor Name Detail (SUBTOTAL) Check Source Number 465 01/02/2020 653 01/26/2020 653 01/26/2020 653 01/26/2020 653 01/26/2020 646 01/29/2020 January A/P PCards 12/27/2019-01/26/2020 PCards 12/27/2019-01/26/2020 PCards 12/27/2019-01/26/2020 PCards 12/27/2019-01/26/2020 January A/P Answering service-january Telephone Answering Service phone phone Answering service -February 4,455.76 104 of 155 207.75 176.78 14.99 788.45 467.11 194.75 4,663.51 4,840.29 4,855.28 5,643.73 6,110.84 6,305.59 KEYSTONE PARK SECRETARIAL ATT*SILL PAYMENT RINGCENTRAL, INC ATT*BUS PHONE PMT ATT*BUS PHONE PMT KEYSTONE PARK SECRETARIAL 6037 AP PC PC PC PC 6139 AP Account: 135-55080-030-000 Maintenance & Repairs 597 01/20/2020 January A/P pest control -quarterly 1,055.00 110.00 1,165.00 Exclusive Pest Control 6100 AP Account: 135-55080-030-000 Maintenance & Repairs Totals: 110.00 1,165.00 ** 15,000.00 Budgeted 13,835.00 Remaining 8 % Used Account: 135-55085-030-000 Generator Maint. and Repair .00 .00 Account: 135-55085-030-000 Generator Maint. and Repair Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-55120-030-000 Cleaning Services 646 01/29/2020 January A/P janitorial svc-December 1,738.12 869.06 2,607.18 MEMBER'S BUILDING MAINTENANCE 6144 AP Account: 135-55120-030-000 Cleaning Services Totals: 869.06 2,607.18 ** 10,000.00 Budgeted 7,392.82 Remaining 26 5 Used Account: 135-55160-030-000 Professional Outside Services .00 .00 Account: 135-55160-030-000 Professional Outside Services Totals: .00 .00 ** 65,600.00 Budgeted 65,600.00 Remaining 0 % Used Account: 135-55205-030-000 Utility Billing Contract 596 01/17/2020 January A/P 726 01/31/2020 January A/P December billings January Billings 1,699.69 182.94 592.18 1,882.63 2,474.81 DATAPROSE DATAPROSE LLC LLC 6097 AP AP Account: 135-55205-030-000 Utility Billing Contract Totals: 775.12 2,474.81 ** 9,000.00 Budgeted 6,525.19 Remaining 27 5 Used Account: 135-60005-030-000 Telephone E. 465 01/02/2020 653 01/26/2020 653 01/26/2020 653 01/26/2020 653 01/26/2020 646 01/29/2020 January A/P PCards 12/27/2019-01/26/2020 PCards 12/27/2019-01/26/2020 PCards 12/27/2019-01/26/2020 PCards 12/27/2019-01/26/2020 January A/P Answering service-january Telephone Answering Service phone phone Answering service -February 4,455.76 104 of 155 207.75 176.78 14.99 788.45 467.11 194.75 4,663.51 4,840.29 4,855.28 5,643.73 6,110.84 6,305.59 KEYSTONE PARK SECRETARIAL ATT*SILL PAYMENT RINGCENTRAL, INC ATT*BUS PHONE PMT ATT*BUS PHONE PMT KEYSTONE PARK SECRETARIAL 6037 AP PC PC PC PC 6139 AP February 17, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 37 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 733 01/31/2020 Town Billed Invoices 1722-1725 AR 20200131-20200131 User: 4,455.76 ccouut: 135-60005-030- Telephone 23,680.00 Budgeted (180.00) 6,125.59 17,554.41 Remaining 26 % Used Account: 135-60010-030-000 Communications/Mobiles 597 01/20/2020 January A/P cell phones -January 611 01/24/2020 MUD Payroll 1/24/2020 Communications/Mobiles Account: Communications/Mobile 4,000.00 Budgeted 3,048.19 Account: Electricity/Gas 596 01/17/2020 January A/P gexa energy 11/8-12/10 Account: 135-60020-030-00 Electricity/Ga= 6,879.00 Budgeted 5,596.57 Account: 135-60025-030-000 Nat= 723 01/31/2020 January A/P water -January 733 01/31/2020 Town Billed Invoices 1722-1725 AR 20200131-20200131 User: Account: 135-60025-030-000 1,500.00 Budgeted Account: 135-60035-030-000 Postage 596 01/17/2020 January A/P December billings 646 01/29/2020 January A/P Postage lease 726 01/31/2020 January A/P January Billings Account: 135-60035-030-000 596 01/17/2020 January A/P 596 01/17/2020 January A/P 710 01/31/2020 Pace Credit Card Fees 710 01/31/2020 Pace Credit Card Fees Remaining Remaining 714.06 592.00 1,669.83 87.75 150.00 24 % Used 690.43 19 % Used 801.81 VERIZON WIRELESS 951.81 1,282.43 TOWN OF TROPHY CLUB 184.77 112.79 297.56 TROPHY CLUB MUD (WATER BILLS) (56.39) 1,258.83 Remaining 16 % Ueed Postage = Totals: 30,000.00 Budgeted 241.17 AR 6124 AP PR 6120 AP AP AR 4,875.95 158.50 5,034.45 DATAPROSE LLC 6097 AP 105.96 5,140.41 FRANCOTYP-POSTALIA, INC. 6135 AP 1,666.39 6,806.80 DATAPROSE LLC AP 23,193.20 Remaining 23 % Used Service Charges & Fees Dig Tess -December Direct send fees -December 20,732.67 190.00 20,922.67 Texas Excavation Safety System 6118 AP 50.00 20,972.67 Fisery Solutions, LLC 6101 AP 4,879.37 25,852.04 GL 116.79 25,968.83 GL 105 of 155 February 17, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 723 01/31/2020 January A/P Direct send fees -January 20,732.67 50.00 26,018.83 Fisery Solutions, LLC AP ccoun - - - Service Chargee & Fees Totals: 26,018.83 ** 67,000.00 Budgeted 40,981.17 Remaining 39 % Used Account: 135-60050-030-000 Bad Debt Expense Account: 135-60050-030-000 Bad Debt Expense 1,500.00 Budgeted Acco : 135-60055-030- 69 01/01/2020 Insurance/Wrk Comp Expense Jan 596 01/17/2020 January A/P Notary-Slaght 725 01/31/2020 TML Liability Insurance Refund Account: 135-60055-030-000 Account: 135-60066-030-000 1,500.00 Remaining Ias ale: 84,000.00 Budgeted 59,568.30 Remaining Publications/Books/Subscript Account: 135-60066-030-00f Publications/Books/Subscripts Totals: 1,000.00 Budgeted 875.00 Remaining 21,016.17 .00 .00 0 % Used 29 % Used 6,998.39 50.00 (3,632.86) 28,014.56 28,064.56 24,431.70 GL VICTOR 0 SCHINNERER & CO, INC 6125 AP GL 125.00 .00 125.00 13 % Used e & Memberahipai Accoun 658 01/27/2020 PCards 1/27/2020 GFOAT membership 4,086.55 80.00 4,166.55 PAYPAL *TXMUNLEAGUE PC Dues & Memberships' Totals: 6,000.00 Budgeted 1,833.45 Remaining 69 % Ueed Account: 135-60075-030-000 Meetings • Account: 135-60075-030-000 Me otals: 400.00 Budgeted 61.37 .00 338.63 Remaining 15 0 Used 61.37 Account: 135-60079-030-000 106 of 155 February 17, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/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 Account: 135-60080-030-000 Schools & Training Schools & Training 6,850.00 Budgeted Account: 15-60100-030- Travel & per diem 596 01/17/2020 January A/P tolls to lab Account Account Travel & per diem 3,545.00 Budgeted Physicals/Testing Physicals/Testing 200.00 Budgeted Account: 135-60115-030-000 Elections Account: 135-60115-030-000 5,523.80 Remaining 5,697.29 Remaining 2,849.86 Remaining Totals: 476.20 1,152.71 .00 476.20 8 % Used 17 % Used .00 1,152.71 686.89 8.25 695.14 NTTA 6112 AP 20 % Used 200.00 Remaining 0 % Used Elections Totals: .00 Budgeted Account: 135-60125-030-000 Advertising Account: 135-60125-030-000 Advertising 2,500.00 Budgeted 43.01 .00 .00 .00 43.01 (43.01) Remaining 0 % Ueed dMa Account: 135-60235-0 596 01/17/2020 January A/P monitoring svc-jan .00 .00 2,500.00 Remaining 0 % Ueed 72.00 24.00 96.00 Digital Air Control, Inc 107 of 155 6098 AP February 17, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 40 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/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 Account: 135-65055-030-000 Account: 135-65055-030-000 Security 1,288.00 Budgeted Miscellaneous Expenses 24 1,192.00 Remaining 7 % 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 `Furniture/Equipment c $50 2,500.00 Budgeted Uniforms 2,050.00 Budgeted Hardware Hardware 26,485.00 Budgeted Account: 135-65085-030-00 Office Supplies 653 01/26/2020 PCards 12/27/2019-01/26/2020 Notary Stamp 646 01/29/2020 January A/P office supplies 2,500.00 Remaining 0 % Used 0 Used 2,050.00 Remaining 0 % Used 3,235.24 23,249.76 Remaining 12 % Used .00 .00 .00 .00 .00 .00 .00 .00 .00 3,235.24 1,677.74 26.90 1,704.64 AMER ASSOC NOTARIES 108 of 155 PC 161.83 1,866.47 OFFICE DEPOT, INC 6147 AP glpdatb2 skrolczyk 10:44 02/11/20 Fund: 135 MUD 1 General Fund JE Number JE Date Account: 135-65090-030-000 Account: 135-65090-030-000 JE Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 1/2020 JE Detail Beginning Balance Description/Comment Office Supplies 6,000.00 Budgeted Program: Transaction Detail February 17, 2020 Regular Meeting Agenda Packet Page 41 Transaction Vendor Name Detail (SUBTOTAL) 4,133.53 Remaining Printer Supplies & Maintenance Printer Supplies & Maintenance Totals: 3,500.00 Budgeted 3,500.00 Remaining Account: 135-rillimaimilMaintenance Supplies 653 01/26/2020 PCarde 12/27/2019-01/26/2020 adapter 653 01/26/2020 PCards 653 01/26/2020 PCards 653 01/26/2020 PCards 653 01/26/2020 PCards 653 01/26/2020 PCarde 653 01/26/2020 PCards 653 01/26/2020 PCarde 653 01/26/2020 PCards 653 01/26/2020 PCards 653 01/26/2020 PCards 653 01/26/2020 PCards 653 01/26/2020 PCards 653 01/26/2020 PCards 653 01/26/2020 PCarde 653 01/26/2020 PCards 12/27/2019-01/26/2020 12/27/2019-01/26/2020 12/27/2019-01/26/2020 12/27/2019-01/26/2020 12/27/2019-01/26/2020 12/27/2019-01/26/2020 12/27/2019-01/26/2020 12/27/2019-01/26/2020 12/27/2019-01/26/2020 12/27/2019-01/26/2020 12/27/2019-01/26/2020 12/27/2019-01/26/2020 12/27/2019-01/26/2020 12/27/2019-01/26/2020 12/27/2019-01/26/2020 paper products, air freshner, coffee creamer popcorn coffee tea coffee coffee coffee water filter air filters air filters batteries air filters air filter tea All,r5-030-all Maintenance Supplies Account: 135-65105-030-000 Account: 135-65105-030-000 Account: 135-69005-030-000 Totals: 4,000.00 Budgeted 1,603.38 Remaining Printing Priatin• 2,500.00 Budgeted 2,500.00 Remaining 1,220.88 31 % Ueed 0 % Used 60 % Ueed 0 .00 .00 7.45 1,228.33 197.88 1,426.21 12.99 1,439.20 47.25 1,486.45 101.98 1,588.43 12.01 1,600.44 25.70 1,626.14 51.39 1,677.53 27.45 1,704.98 30.99 1,735.97 259.84 1,995.81 259.84 2,255.65 18.48 2,274.13 59.88 2,334.01 51.61 2,385.62 11.00 2,396.62 Used 109 of 155 .00 .00 .00 .00 AMZN MRTP US*IV5L658D3 SAMSCLUB.COM AMAZON.COM*7173V4YD3 AMAZON.COM*HJ2657H73 AMZN MKTP US*017K89KQ3 AMAZON.COM*YA50Y4J73 AMAZON.COM*J45GI9053 AMAZON.COM*E96AA3UJ3 AMAZON.COM*BE2SW1HM3 AMZN METP US*WW9HZ2AL3 AMAZON.COM*R04Y134N3 AMAZON.COM*BT0NZ5703 AMAZON.COM*CZ42N8P43 HOMEDEPOT .COM AMAZON. COM*0W2238HE3 AMAZON. COM*P33Q27R53 Check Source Number PC PC PC PC PC PC PC PC PC PC PC PC PC PC PC PC February 17, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 596 01/17/2020 January A/P 646 01/29/2020 January A/P Account: 135 Department 30 Totals: Capital Outlays 195,000.00 Budgeted 195,000.00 Remaining 0 % Ueed Copier Lease Installments copier lease-jan copies L Copier Lease Installments Tota 4,000.00 Budgeted 2,962.34 Remaining .00 ** 795.98 165.00 960.98 TIAA COMMERCIAL FINANCE 76.68 1,037.66 KYOCERA DOCUMENT SOLUTIONS 26 % Used 439,447.86 ** 131,731.90 Monthly Total 1,776,712.00 Budgeted 1,337,264.14 Remaining 25 % Used 110 of 155 6119 AP 6140 AP glpdatb2 skrolczyk 10:44 02/11/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 39 Non Departmental Period Ending: 1/2020 JE Detail Description/Comment February 17, 2020 Regular Meeting Agenda Packet Page 43 Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Check Source Number 596 01/17/2020 January A/P 596 01/17/2020 January A/P 596 01/17/2020 January A/P 734 01/31/2020 January A/P Westlake easement legal legal legal 35,307.89 6,198.50 2,430.00 1,050.00 1,050.00 41,506.39 WHITAKER CHALK SWINDLE 43,936.39 McLean & Howard, L.L.P. 44,986.39 McLean & Howard, L.L.P. 46,036.39 McLean & Howard, L.L.P. 6126 AP 6109 AP 6109 AP AP Account: 135-55045-039-000 Legal Totals: 10,728.50 46,036.39 ** 135,000.00 Budgeted 88,963.61 Remaining 34 % Used Account: 135-55055-039-000 Auditing 651 01/30/2020 January A/P FY 19 Audit completed work 15,150.00 12,563.27 27,713.27 LAFOLLETT & COMPANY, PLLC 6142 AP Account: 135-55055-039-000 Auditing Totals: 12,563.27 27,713.27 ** 33,800.00 Budgeted 6,086.73 Remaining 82 % Used Account: 135-55060-039-000 Appraisal 5,178.56 .00 5,178.56 Account: 135-55060-039-000 Appraisal Totals: .00 5,178.56 ** 11,761.00 Budgeted 6,582.44 Remaining 44 % Used Account: 135-55065-039-000 Tax Admin Fees 3,756.00 .00 3,756.00 Account: 135-55065-039-000 Tax Admin Fees Totals: .00 3,756.00 ** Department 39 Totals: Fund 135 Totals: 4,000.00 Budgeted 23,291.77 Monthly Total 244.00 Remaining 94 % Used 82,684.22 ** 184,561.00 Budgeted 101,876.78 Remaining 45 % Used 166,399.23 236,079.77 Monthly Total (6,224.00) Budgeted (172,623.23) Remaining ########## 111 of 155 glpdatb2 skrolczyk 10:44 02/11/20 Fund: 137 MUD 1 Consolidated GASB JE JE JE Number Date Description Department: JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 1/2020 Beginning Balance February 17, 2020 Regular Meeting Agenda Packet Page 44 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 112 of 155 (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 112 of 155 (286,420.00) ** 286,420.00 Remaining 0 % Used (286,420.00) 286,420.00 Remaining 0 % Used February 17, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - WWTP TAX BOND CONST BALANCE SHEET JANUARY 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 517 TAX BOND CONSTRUCTION 547,320 TOTAL ASSETS 547,320 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 685,476 TOTAL LIABILITIES 685,476 FUND BALANCE ASSIGNED FUND BALANCE (118,409) NET REVENUES / EXPENDITURES (19,747) TOTAL FUND BALANCE (138,156) TOTAL LIABILITIES AND FUND BALANCE 547,320 113 of 155 February 17, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 10:43 02/11/20 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 1/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1 517-49011-000-000 Interest Income 743.88- 3,349.11- 3,349.11 Page 14 Subtotal: 743.88- 3,349.11- 3,349.11 Program number: 743.88- 3,349.11- 3,349.11 Department number: Revenues 743.88- 3,349.11- 3,349.11 Revenues Subtotal 743.88- 3,349.11- 3,349.11 114 of 155 glbase_tbam skrolczyk 10:43 02/11/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: 1/2020 Adopted Amended Total Current Budget Budget Encumb. Month 3,792.50 Program: YTD Total 23,096.00 February 17, 2020 Regular Meeting Agenda Packet % of Remaining Budget Budget 23,096.00 - Page 15 115 of 155 Subtotal: 3,792.50 23,096.00 23,096.00 - Program number: 3,792.50 23,096.00 23,096.00 - Department number: Wastewater 3,792.50 23,096.00 23,096.00 - Expenditures Subtotal 3,792.50 23,096.00 23,096.00 - Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 3,048.62 19,746.89 19,746.89- 115 of 155 February 17, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-49011-000-000 Interest Income 724 01/31/2020 Bank Interest- January Account: 517-49011-000-000 Interest Income .00 Budgeted (2,605.23) (743.88) 3,349.11 Remaining 0 % Used (3,349.11) GL Total (741. Department Totals: (3,349.11) ** (743.88) Monthly Total .00 Budgeted 116 of 155 3,349.11 Remaining 0 % Used February 17, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) A000unt: 517-69005-020- ial 596 01/17/2020 January A/P 596 01/17/2020 January A/P Capital Outl WWTP legal WWTP Legal Account: - Capital Outlays Totals: .00 Budgeted 19,303.50 1,572.50 2,220.00 (23,096.00) Remaining 0 % Used 20,876.00 Dubois Bryant Campbell LLP 6099 AP 23,096.00 CP&Y/WALLACE GROUP, INC. 6096 AP Department 20 Totals: 23,096.00 ** 3,792.50 Monthly Total .00 Budgeted (23,096.00) Remaining 0 % Used Fund 517 Totals: 19,746.89 3,048.62 Monthly Total .00 Budgeted 117 of 155 (19,746.89) Remaining 0 % Used February 17, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET JANUARY 2020 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE SIPA TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 783,441 TOTAL ASSETS 783,441 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 118 of 155 81,691 81,691 698,648 3,102 701,750 783,441 February 17, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 10:43 02/11/20 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const -SWIFT Department: Revenues Program: Period Ending: 1/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1 1 519-49011-000-000 Interest Income 669.42- 3,101.87- 3,101.87 Page 16 Subtotal: 669.42- 3,101.87- 3,101.87 Program number: 669.42- 3,101.87- 3,101.87 Department number: Revenues 669.42- 3,101.87- 3,101.87 Revenues Subtotal 1 669.42- 3,101.87- 3,101.87 I Fund number: 519 2016 Rev Bond Const -SWIFT 119 of 155 February 17, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 47 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const -SWIFT Department: Revenues Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 519-49011-000-000 Interest Income 724 01/31/2020 Bank Interest- January (2,432.45) (669.42) (3,101.87) GL Account: 519-49011-000-000 Interest Income Totals: .00 Budgeted 3,101.67 Remaining 0 % Used Department Totals: (3,101.87) ** (669.42) Monthly Total .00 Budgeted 3,101.87 Remaining 0 % Used Fund 519 Totals: (3,101.87) (669.42) Monthly Total .00 Budgeted 120 of 155 3,101.87 Remaining 0 % Used February 17, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - 16" WATERLINE REV BOND BALANCE SHEET JANUARY 2020 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND CASH IN BANK 552,598 INVESTMENTS 3,884,957 ACCOUNTS RECEIVABLE TOTAL ASSETS 4,437,555 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 121 of 155 4,454,290 (16,735) 4,437,555 4,437,555 February 17, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 Page 17 10:43 02/11/20 Budget Summary with Amendment Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 1/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1 520-49011-000-000 Interest Income 4,071.63- 18,707.81- 18,707.81 Subtotal: 4,071.63- 18,707.81- 18,707.81 Program number: 4,071.63- 18,707.81- 18,707.81 Department number: 4,071.63- 18,707.81- 18,707.81 Revenues Subtotal 1 4,071.63- 18,707.81- 18,707.81 122 of 155 glbase_tbam skrolczyk 10:43 02/11/20 Fund: 520 Revenue Bond 16" Waterline Account 1 520-69005-010-000 Description Capital Outlays Trophy Club MUD No.1 Budget Summary with Amendment Department: 10 Water Department Period Ending: 1/2020 Adopted Amended Total Current Budget Budget Encumb. Month 4,704.93 Program: YTD Total 35,442.91 February 17, 2020 Regular Meeting Agenda Packet % of Remaining Budget Budget 35,442.91 - Page 18 123 of 155 Subtotal: 4,704.93 35,442.91 35,442.91 - Program number: 4,704.93 35,442.91 35,442.91 - Department number: Water Department 4,704.93 35,442.91 35,442.91 - Expenditures Subtotal I 4,704.93 35,442.91 35,442.91 - Fund number: 520 Revenue Bond 16" Waterline 633.30 16,735.10 16,735.10- 123 of 155 glpdatb2 skrolczyk Trophy Club MUD No.1 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) February 17, 2020 Regular Meeting Agenda Packet Page 48 724 01/31/2020 Bank Interest- January (14,636.18) 724 01/31/2020 Bank Interest- January Account: 520-490 nterest Income Totals: .00 Budgeted 18,707.81 Remaining 0 % Used (752.10) (15,388.28) GL (3,319.53) (18,707.81) GL Department Totals: (18,707.81) ** (4,071.63) Monthly Total .00 Budgeted 124 of 155 18,707.81 Remaining 0 % Used February 17, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 520-69005-010-000 Capital Outlays 596 01/17/2020 January A/P Right away acquisition- 16" wa 30,737.98 4,704.93 35,442.91 Halff Associates, INC 6102 AP Account: 520-69005-010-000 Capital Outlays Totals: 4,704.93 35,442.91 ** .00 Budgeted (35,442.91) Remaining 0 5 Used Department 10 Totals, 35,442.91 ** 4,704.93 Monthly Total .00 Budgeted (35,442.91) Remaining 0 % Used Fund 520 Totals: 16,735.10 633.30 Monthly Total .00 Budgeted 125 of 155 (16,735.10) Remaining 0 % Used February 17, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET JANUARY 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE MIA TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 849,568 TOTAL ASSETS 849,568 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 126 of 155 803,457 46,111 849,568 849,568 February 17, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 Page 19 10:43 02/11/20 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 1/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- 1,134.84- 4,600.00- 5,750.00- 4,711.24- 18,400.00- 23,000.00- 42.829 5.993 11.476 6,288.76- 288,649.00- 177,417.00 - Subtotal: m 518,466.00- 518,466.00- 11,484.84- 46, 8.894 472,354.76 - Program number: 1 518,466.00- 518,466.00- 11,484.84- 46,111117271 8.894 472,354.76 - Department number: 518,466.00- 518,466.00- 11,484.84- 46,1.1.24- 8.894 472,354.76 - Revenues Subtotal 518,466.00- 518,466.00- 11,484.84- L1.24- 8.894 472,354.76 - Fund number: 528 2015 Revenue Bond Reserve Fund 518,466.00- 518,466.00- 11,484.84- L1.24- 8.894 472,354.76- 127 of 155 glpdatb2 skrolczyk Trophy Club MUD No.1 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) February 17, 2020 Regular Meeting Agenda Packet Page 50 Account: 528-49011-000-000 Interest Income 724 01/31/2020 Bank Interest- January (3,576.40) Account: 528-49011-000-000 (11,000.00) Budgeted Account: 528-49142-000-000 645 01/30/2020 TexPool Transfers January (1,134.84) (4,711.24) Total (6,288.76) Remaining 43 % Used TexPool O&M to Rev Bond Resevr (13,800.00) 4.84) (4,600.00) (18,400.00) GL GL Account (307,049.00) Budgeted (288,649.00) Remaining 6 % Used Interfund transfer in -WW 645 01/30/2020 TexPool Transfers January TexPool O&M to Rev Bond Resevr Account: 528-49143- nterfund transfer i (200,417.00) Budgeted (17,250.00) (177,417.00) Remaining (5,750.00) 11 % Used (23,000.00) Department Totals: (46,111.24) ** (11,484.84) Monthly Total (518,466.00) Budgeted (472,354.76) Remaining 9 % Used Fund 528 Totals: (46,111.24) (11,484.84) Monthly Total (518,466.00) Budgeted 128 of 155 (472,354.76) Remaining 9 % Used GL February 17, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - I&S (DEBT SERVICE) BALANCE SHEET JANUARY 2020 ASSETS CASH IN BANK INVESTMENTS 736,540 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 100,659 ACCOUNTS RECEIVABLE -OTHER - TOTAL ASSETS 837,199 TROPHY CLUB MUNICIPAL UTILITY DISTRICT INTEREST & SINKING- 533 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 100,659 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 100,659 FUND BALANCE ASSIGNED FUND BALANCE 82,954 NET REVENUES / EXPENDITURES 653,586 TOTAL FUND BALANCE 736,540 TOTAL LIABILITIES AND FUND BALANCE 837,199 129 of 155 February 17, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 10:43 02/11/20 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 1/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 533-49011-000-000 533-49015-000-000 533-49141-000-000 Subtot Property Taxes Property Taxes/Delinquent Property Taxes/P & I Interest Income Lease/Rental Income Interfund Trans In -PID Surchg Program number: Department number: Revenues Revenues Subtotal 682,441.00- 1,000.00- 2,000.00- 682,441.00- 1,000.00- 2,000.00- 685,441.00- 685,441.00- 5,000.00- 218,004.00- 114,563.00- 5,000.00- 218,004.00- 114,563.00- 337,567.00- 1,023,008.00- 1,023,008.00- 1,023,008.00- 1,023,008.00- 0- 0- 1,023,008.00- 256,840.76- 846.94- 196.25- 257,883.95- 609,567.64- 633.46- 349.49- 610,550.59- 130 of 155 723.25- 1,375.71- 10,414.81- 41,659.24- 01- 89.322 63.346 17.475 89.074 27.514 36.364 72,873.36- 366.54- 1,650.51- 3,624.29- 218,004.00- 72,903.76- 6 369,422.46- 653,585.54- 369,422.46- 653,585.54- 369,422.46 - Page 20 February 17, 2020 Regular Meeting Agenda Packet glbase_tbam skrolczyk Trophy Club MUD No.1 10:43 02/11/20 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 1/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 2,150.00 247,858.00 765,000.00 Page 21 Subtotal: 1,015,008.00 1,015,008.00 1,015,008.00 Program number: 1,015,008.00 1,015,008.00 1,015,008.00 Department number: Administration 1,015,008.00 1,015,008.00 1,015,008.00 Expenditures Subtotal 1,015,008.00 1,015,008.00 1,015,008.00 p Fund number: 533 MUD 1 I&S Consolidated 8,000.00- 8,000.00- 269,022.01- 653,585.54- 8,169.819 645,585.54 131 of 155 glpdatb2 skrolczyk 10:44 02/11/20 Fund: 533 MUD 1 I&S Consolidated JE JE JE Number Date Description February 17, 2020 Regular Meeting Agenda Packet Trophy Club MUD No.1 Page 51 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 1/2020 JE Detail Beginning Transaction Transaction Vendor Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 L Property Taxes 670 01/02/2020 Property Taxes 671 01/03/2020 Property Taxes 672 01/06/2020 Property Taxes 673 01/07/2020 Property Taxes 674 01/08/2020 Property Taxes 691 01/09/2020 Property Taxes 692 01/10/2020 Property Taxes 693 01/13/2020 Property Taxes 694 01/14/2020 Property Taxes 695 01/15/2020 Property Taxes 696 01/16/2020 Property Taxes 697 01/17/2020 Property Taxes 698 01/21/2020 Property Taxes 699 01/22/2020 Property Taxes 700 01/23/2020 Property Taxes 701 01/24/2020 Property Taxes 704 01/27/2020 Property Taxes 705 01/28/2020 Property Taxes 706 01/29/2020 Property Taxes 707 01/30/2020 Property Taxes 708 01/31/2020 Property Taxes (352,726.88) (13,511.47) (366,238.35) GL (8,638.50) (374,876.85) GL (7,125.22) (382,002.07) GL (13,417.94) (395,420.01) GL (12,697.75) (408,117.76) GL (3,503.28) (411,621.04) GL (6,413.40) (418,034.44) GL (4,901.08) (422,935.52) GL (2,642.89) (425,578.41) GL (14,406.75) (439,985.16) GL (4,799.57) (444,784.73) GL (6,528.49) (451,313.22) GL (3,140.90) (454,454.12) GL (6,719.64) (461,173.76) GL (6,059.81) (467,233.57) GL (47,983.71) (515,217.28) GL (12,869.15) (528,086.43) GL (59,041.65) (587,128.08) GL (7,660.94) (594,789.02) GL (7,212.31) (602,001.33) GL (7,566.31) (609,567.64) GL Account: 533-40000-000-000 Property Taxes Totals: (256,840.76) (609,567.64) ** (682,441.00) Budgeted (72,873.36) Remaining 89 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 670 01/02/2020 Property Taxes 673 01/07/2020 Property Taxes 692 01/10/2020 Property Taxes 695 01/15/2020 Property Taxes 699 01/22/2020 Property Taxes 704 01/27/2020 Property Taxes 213.48 (11.91) 201.57 GL (9.05) 192.52 GL (26.98) 165.54 GL (723.45) (557.91) GL (61.41) (619.32) GL (14.14) (633.46) GL Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (846.94) (633.46) ** (1,000.00) Budgeted (366.54) Remaining 63 % Used Account: 533-40015-000-000 ` Property Taxes/P & I 670 01/02/2020 Property Taxes 673 01/07/2020 Property Taxes 692 01/10/2020 Property Taxes (153.24) (3.36) (156.60) GL (2.09) (158.69) GL (5.67) (164.36) GL 132 of 155 glpdatb2 skrolczyk Trophy Club MUD No.1 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) February 17, 2020 Regular Meeting Agenda Packet Page 52 695 01/15/2020 Property Taxes 699 01/22/2020 Property Taxes 704 01/27/2020 Property Taxes (153.24) (173.64) (8.76) (2.73) (338.00) (346.76) (349.49) GL GL GL Account: 533-40015-000-000 Property Taxes/P & I Totals: (196.25) (349.49) ** (2,000.00) Budgeted (1,650.51) Remaining 17 % Used Account: 533-49011-000-000 Interest Income 724 01/31/2020 Bank Interest- January (652.46) (723.25) (1,375.71) GL Account: 533-49011-000-000 Interest Income Totals: (723.25) (1,375.71) ** (5,000.00) Budgeted (3,624.29) Remaining 28 % Used Account: 533-49015-000-000 Lease/Rental Income .00 .00 Account: 533-49015-000-000 Lease/Rental Income Totals: .00 .00 ** (218,004.00) Budgeted (218,004.00) Remaining 0 % Used Account: 533-49141-000-000 Interfund Trans In -PID Surchg 645 01/30/2020 TexPool Transfers January TexPool O&M to I&S- PID Debt (31,244.43) (10,414.81) (41,659.24) GL Account: 533-49141-000-000 Interfund Trans In -PID Surchg Totals: (10,414.81) (41,659.24) ** Department Totals: (114,563.00) Budgeted (269,022.01) Monthly Total (72,903.76) Remaining 36 % Used (653,585.54) ** (1,023,008.00) Budgeted (369,422.46) Remaining 64 % Used 133 of 155 glpdatb2 skrolczyk 10:44 02/11/20 Fund: 533 MUD 1 I&S Consolidated JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 51 Administration Period Ending: 1/2020 JE Detail Description/Comment February 17, 2020 Regular Meeting Agenda Packet Page 53 Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Check Source Number Department 51 Totals: Fund 533 Totals: .00 Monthly Total (269,022.01) Monthly Total .00 ** 1,015,008.00 Budgeted 1,015,008.00 Remaining 0 5 Used (653,585.54) (8,000.00) Budgeted 645,585.54 Remaining ########## 134 of 155 Account: 533-70005-051-000"IIIIPaying Agent Fee .00 .00 Account: 533-70005-051-000 Paying Agent Fee Totals: .00 .00 ** 2,150.00 Budgeted 2,150.00 Remaining 0 % Used Account: 533-70025-051-000 Bond Interest Expense -Tax .00 .00 Account: 533-70025-051-000 Bond Interest Expense -Tax Totals: .00 .00 ** 247,858.00 Budgeted 247,858.00 Remaining 0 % Used Account: 533-70035-051-000 Bond Principal Payment -Tax .00 .00 Account: 533-70035-051-000 Bond Principal Payment -Tax Totals: .00 ** 765,000.00 Budgeted 765,000.00 Remaining 0 % Used Department 51 Totals: Fund 533 Totals: .00 Monthly Total (269,022.01) Monthly Total .00 ** 1,015,008.00 Budgeted 1,015,008.00 Remaining 0 5 Used (653,585.54) (8,000.00) Budgeted 645,585.54 Remaining ########## 134 of 155 February 17, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - REVENUE BOND I&S (WWTP) BALANCE SHEET JANUARY 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE In TROPHY CLUB MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 242,846 TOTAL ASSETS 242,846 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 135 of 155 24,518 218,328 242,846 242,846 February 17, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 10:43 02/11/20 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 1/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49011-000-000 Interest Income 2,500.00- 534-49143-000-000 Interfund Transfer In -WW Sales 598,638.00- Subtot Program number: Department number: Revenues Revenues Subtotal 60i�0- 601 00- 6011'38.00- 601,138.00- 2,500.00- 598,638.00- 6011.38.00- 601,138.00- 601,138.00- 601,138.00- 136 of 155 261.57- 54,421.63- 641.92- 217,685.92- 54,683.20- 218,3./. 54,683.20- 54,683.20- 54,683.20- 218,327.84- 218,327.84- 218,327.84 - 25.677 1,858.08- 36.364 36.319 36.319 36.319 36.319 380,952.08- 38 382mommorr 382,810.16- Page 22 February 17, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 10:43 02/11/20 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 1/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-70005-051-000 534-70040-051-000 534-70045-051-000 Rev Bond Paying Agent Fee Revenue Bona Interest Expense Revenue Bond Principal Expense 400.00 208,238.00 390,000.00 400.00 208,238.00 390,000.00 Subtotal: , 598,638.00 598,638.00 Program number: III 598,638.00 598,638.00 Department number: Administration III 598,638.00 598,638.00 Expenditures Subtotal III 598,638.00 598,638.00 Fund number: 534 2015 Revenue Bond I&S M2,500.00- 2,500.00- 54,683.20- 218,327.84- 8,733.114 137 of 155 400.00 208,238.00 390,000.00 598,638.00 598,638.00 598,638. 598,638.00 215,827.84 Page 23 glpdatb2 skrolczyk 10:44 02/11/20 Fund: 534 2015 Revenue Bond I&S JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 1/2020 JE Detail Description/Comment February 17, 2020 Regular Meeting Agenda Packet Page 54 Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Check Source Number Department Totals: (54,683.20) Monthly Total (218,327.84) ** (601,138.00) Budgeted (382,810.16) Remaining 36 % Used 138 of 155 Account: 534-49011-000-000 Interest Income 724 01/31/2020 Bank Interest- January (380.35) (261.57) (641.92) GL Account: 534-49011-000-000 Interest Income Totals: (261.57) (641.92) ** (2,500.00) Budgeted (1,858.08) Remaining 26 % Used Account: 534-49143-000-000 Interfund Transfer In -WW Sales 645 01/30/2020 TexPool Transfers January TexPool O&M to Rev Bd WWTP I&S (163,264.29) (54,421.63) (217,685.92) GL Account: 534-49143-000-000 Interfund Transfer In -WW Sales Totals: (54,421.63) (217,685.92) ** (598,638.00) Budgeted (380,952.08) Remaining 36 % Used Department Totals: (54,683.20) Monthly Total (218,327.84) ** (601,138.00) Budgeted (382,810.16) Remaining 36 % Used 138 of 155 February 17, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 55 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond IES Department: 51 Administration Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-70005-051-000 Rev Bond Paying Agent Fee Account: 534-70005-051-000 11 Rev Bond Paying Agent Fee Total 400.00 Budgeted 400.00 Remaining Account: 534-70040-051-000 Revenue Bond Interest Expense Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: 208,238.00 Budgeted 208,238.00 Remaining 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 Department 51 Totals: .00 Monthly Total O % Used • O % Used .00 .00 .00 .00 .00 .00 0 % Used .00 ** 598,638.00 Budgeted 598,638.00 Remaining 0 % Used Fund 534 Totals: (218,327.84) (54,683.20) Monthly Total (2,500.00) Budgeted 215,827.84 Remaining ########## 139 of 155 February 17, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET JANUARY 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE ra TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 105,417 TOTAL ASSETS 105,417 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 140 of 155 4,967 100,450 105,417 105,417 February 17, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 10:43 02/11/20 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 1/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1 1 535-49011-000-000 1 535-49142-000-000 Interest Income Interfund Tran In -Water Sales 1,000.00- 275,525.00- 1,000.00- 275,525.00- 111.83- 25,047.72- 259.12- 100,190.88- 25.912 36.364 740.88- 175,334.12 - Page 24 Subtotal: 276,525.00- 276,525.00- 1 25,159.55- 100,450.00- 36.326 176,075.00 - Program number: 276,525.00- 276,525.00- 25,159.55- 100,450.00- 36.326 176,075.00 - Department number: Revenues 276,525.00- 276,525.00- 25,159.55- 100,450.00- 36.326 176,075.00 - Revenues Subtotal 276,525.00- 276,525.00- 25,159.55- 100,450.00- 36.326 176,075.00- 141 of 155 February 17, 2020 Regular Meeting Agenda Packet glbase_tbam skrolczyk Trophy Club MUD No.1 10:43 02/11/20 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 1/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-70005-051-000 Rev Bond Paying Agent Fee 800.00 800.00 535-70040-051-000 Revenue Bona Interest Expense 386,811.00 386,811.00 535-70045-051-000 Revenue Bond Principal Expense 215,000.00 215,000.00 Subtotal: ,111111102,611.00 602,611.00 Program number: _b02,611.00 602,611.00 Department number: Administration mEr 602,611.00 602,611.00 Expenditures Subtotal 602,611.00 602,611.00 Fund number: 535 2016 Rev Bond I&S-SWIFT 326,086.00 326,086.00 25,159.55- 100,450.00- -30.805 142 of 155 800.00 386,811.00 215,000.00 602,611.00 602,611.00 602,611.00 602,611.00 426,536.00 Page 25 glpdatb2 skrolczyk 10:44 02/11/20 Fund: 535 2016 Rev Bond I&S-SWIFT JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 1/2020 JE Detail Description/Comment February 17, 2020 Regular Meeting Agenda Packet Page 56 Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Check Source Number Department Totals: (25,159.55) Monthly Total (100,450.00) ** (276,525.00) Budgeted (176,075.00) Remaining 36 5 Used 143 of 155 Account: 535-49011-000-000 Interest Income 724 01/31/2020 Bank Interest- January (147.29) (111.83) (259.12) GL Account: 535-49011-000-000 Interest Income Totals: (111.83) (259.12) ** (1,000.00) Budgeted (740.88) Remaining 26 5 Used Account: 535-49142-000-000 Interfund Tran In -Water Sales 645 01/30/2020 TexPool Transfers January TexPool O&M to 16Swift Rev I&S (75,143.16) (25,047.72) (100,190.88) GL Account: 535-49142-000-000 Interfund Tran In -Water Sales Totals: Ur (25,047.72) (100,190.88) ** (275,525.00) Budgeted (175,334.12) Remaining 36 5 Used Department Totals: (25,159.55) Monthly Total (100,450.00) ** (276,525.00) Budgeted (176,075.00) Remaining 36 5 Used 143 of 155 February 17, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 57 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 1/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 535-70005-051-000 Rev Bond Paying Agent Fee Account: 535-70005-051-000 11 Rev Bond Paying Agent Fee Total Account: 535-70040-051-000 800.00 Budgeted 800.00 Remaining Revenue Bond Interest Expense Account: 535-70040-051-000 Revenue Bond Interest Expense Totals: 386,811.00 Budgeted 386,811.00 Remaining Account: 535-70045-051-000 Revenue Bond Principal Expense Revenue Bond Principal Expense Totals: 215,000.00 Budgeted 215,000.00 Remaining 0 % Used 0 % Used .00 .00 .00 .00 .00 .00 0 % Used Department 51 Totals: .00 ** .00 Monthly Total 602,611.00 Budgeted 602,611.00 Remaining 0 % Used Fund 535 Totals: (100,450.00) (25,159.55) Monthly Total 326,086.00 Budgeted 426,536.00 Remaining -31 % Used 144 of 155 February 17, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET JANUARY 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE ILIP TROPHY CLUB 1 MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 119,214 TOTAL ASSETS 119,214 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES 119,214 TOTAL FUND BALANCE 119,214 TOTAL LIABILITIES AND FUND BALANCE 119,214 145 of 155 glbase_tbam skrolczyk 10:43 02/11/20 Fund: 536 2019 Rev Bond I&S- W&WW System Account Description 1 1 536-49011-000-000 1 536-49142-000-000 1 536-49143-000-000 Interest Income Interfund Tran In -Water Sales Interfund Transfer In -WW Sales February 17, 2020 Regular Meeting Agenda Packet Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Program: Period Ending: 1/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 124.73- 22,896.02- 6,839.07- 273.78- 91,584.08- 27,356.28- 273.78 91,584.08 27,356.28 Page 26 Subtotal: "mmm797W-59.82- 119,714.14- 119,214.14 Program number: 29,859.82- 119,214.14- 119,214.14 Department number: Revenues 29,859.82- 119,214.14- 119,214.14 Revenues Subtotal 29,859.82- 119,214.14- 119,214.14 Fund number: 536 2019 Rev Bond I&S- W&WW System 29,859.82- 119,214.14- 119,214.14 ******* End of Report ********* 146 of 155 February 17, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 58 10:44 02/11/20 Detailed Accounting Trial Balance Fund: 536 2019 Rev Bond I&S- W&WW System Department: Revenues Program: Period Ending: 1/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-49011-000-000 Interest Income 724 01/31/2020 Bank Interest- January (149.05) (124.73) (273.78) GL Account: 536-49011-000-000 11 Interest Income Total .00 Budgeted 273.78 Remaining 0 % Ueed Account: 536-49142-000-000 Interfund Tran In -Water Sales 645 01/30/2020 TexPool Transfers January TexPool O&M to 19 W&WW Rev I&S Account (68,688.06) (22,896.02) (91,584.08) GL Interfund Tran In -Water Sales Totals: .00 Budgeted 91,584.08 Remaining Interfund Transfer In -WW Sales i 645 01/30/2020 TexPool Transfers January TexPool O&M to 19 W&WW Rev I&S 0 % Ueed (20,517.21) (6,839.07) (27,356.28) GL Account: 536-49143-1116 rfund Transfer In -WW Sales Total .00 Budgeted 27,356.28 Remaining 0 % Used Department Totals: (119,214.14) ** (29,859.82) Monthly Total .00 Budgeted 119,214.14 Remaining 0 % Used Fund 536 Totals: (119,214.14) (29,859.82) Monthly Total .00 Budgeted 119,214.14 Remaining 0 % Used Grand Totals: (1,854,133.85) **** (548,373.18) Monthly Total (209,104.00) Budgeted 1,645,029.85 Remaining 887 % Used ******* End of Report ********* 147 of 155 February 17, 2020 Regular Meeting Agenda Packet BUDGET VARIANCE REPORT FUND: 122 - Fire O&M FINANCIALS MONTH: January 2020 REVENUE VARIANCE: 24.9% EXPENSE VARIANCE: 43.2% 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 $456,982 $1,084,569 89.32% 10/2019 Property Taxes/MUD Fire 122-40011 Property Taxes/Fire - Delinquent $1,376 $1,022 10/2019 Delinquent Fire Taxes collected/paid out 122-40020 Property Taxes/Fire P&I $426 $1,648 10/2019 Fire Taxes Penalties & Interest collected FIRE EXPENSES 148 of 155 BUDGET VARIANCE FUND: FINANCIALS MONTH: REVENUE VARIANCE: EXPENSE VARIANCE: NOTE: ACCOUNT REVENUE 135-47000-000 EXPENSES WATER 135-50010-010 135-69008-010 135-69009-010 135-69281-010 WASTEWATER 135-55081-020 135-60010-020 135-65030-020 135-65045-020 135-69008-020 135-69009-020 BOARD OF DIRECTORS ADMINISTRATION 1135-55030-030 1135-60070-030 1135-65095-030 1 1 Non -Departmental 1135-55055-039 1 February 17, 2020 Regular Meeting Agenda Packet REPORT 135 - MUD 1 O&M January 2020 24.9% 43.2% 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 $6,486,623 $308,154 $1,523,137 23.48% 01/2020 Water Sales Overtime Short Term Debt- Principal Short Term Debt- Interest Water Tank Inspection Contract Maintenance & Repairs Collections Communications/Mobiles Chemicals Lab Supplies Short Term Debt- Principal Short Term Debt- Interest Software & Support Dues & Memberships Maintenance Supplies Auditing $17,000 $2,257 $7,648 44.99% 01/2020 $30,512 $30,512 $30,512 100.00% 01/2020 $3,231 $1,840 $1,840 56.95% 01/2020 $120,000 $44,144 $102,077 85.06% 01/2020 $10,000 $1,101 $15,378 153.78% 01/2020 $5,000 $685 $2,271 45.41% 01/2020 $20,000 $3,048 $9,868 49.34% 11/2019 $20,000 $2,831 $10,837 54.19% 12/2019 $79,133 $59,605 $59,605 75.32% 01/2020 $11,277 $6,122 $6,122 54.29% 01/2020 $134,681 $6,000 $4,000 $51,870 $125,274 $80 $4,167 $1,176 $2,397 93.02% 01/2020 69.44% 01/2020 59.92% 01/2020 Overtime Annual Principal Payment Semi -Annual Interest Payment Annual Contract Multiple Tanks LS Repairs New Tablet and Service Chemicals Lab PH Meter, Lab Supplies Semi -Annual Principal Payment Semi -Annual Interest Payment Annual Contract STW & OpenGov Annual Dues Office Supplies $33,800 $12,563 $27,713 81.99% 01/2020 FY 19 Audit Completion 149 of 155 February 17, 2020 Regular Meeting Agenda Packet Trophy Club Municipal Utility District No. 1 General Manager's Report Regulatory Updates Breaks and Leaks — No reportable breaks or leaks have occurred since the last report. Sanitary Sewer Overflows (SSO1— No SSO's have occurred since the last report. Capital Improvement Projects WWTP — Here is the timeline for the Building with sound curtains provided by the contractor: Provide Structural Drawings 2-4-2020 Release Building 2-5-2020 Receive Building 2-11-2020 Install building 2-11-2020 to 2-18-2020 Install Sound Wall 2-19-2020 to 2-21-2020 High Service Pump Station Upgrade — The pump can leveling has been completed and the pump and motor is installed. We have a startup date of Feb. 24tH 150 of 155 - 2016 - 2017 - 2018 2019 - 2020 1 February 17, 2020 Regular Meeting Agenda Packet Monthly Water Operations Report Water Billed FY October November December January February March April May June July August September Total Year 2011 70,502 50,909 44,365 35,983 27,845 55,972 69,165 61,467 99,326 117,707 170,464 123,692 927,397 2012 85,869 53,571 40,815 30,616 31,665 35,263 47,194 84,905 114,104 137,174 144,573 108,622 914,371 2013 85,488 75,251 48,527 39,601 34,450 43,137 56,947 76,542 85,312 110,072 130,945 114,497 900,769 2014 82,660 48,813 34,482 39,767 37,085 54,794 66,337 84,384 99,240 92,913 113,135 110,873 864,483 2015 90,994 58,986 49,607 36,162 38,776 30,566 46,543 39,576 60,731 100,622 139,441 123,886 815,890 2016 108,951 41,936 39,028 39,622 44,551 49,498 55,181 50,827 65,390 115,687 119,611 98,945 829,227 2017 74,785 68,638 38,580 33,028 38,380 60,841 56,683 86,794 98,864 95,355 104,303 99,541 855,792 2018 83,228 69,099 48,144 34592 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 1 140,000 120,000 100,000 80,000 60,000 40,000 20,000 0 102,150 1 40.988 1 43,946 1 36,418 1 WATER BILLED IN THOUSANDS OF GALLONS 1 -I 1 7 October November December January Februaryril May June ust September Water Pumped FY October November December January February March April May June July August September Total Year 2011 70,502 50,993 44,220 33,789 36,053 54,775 71,306 63,500 116,350 152,002 169,621 117,190 980,301 2012 83,750 54,245 41,650 34,740 31,581 46,519 62,649 100,402 110,324 153,813 139,005 123,045 981,723 2013 85,966 77,758 55,110 39,283 37,867 56,743 60,969 87,168 96,602 119,414 145,988 120,342 983,210 2014 81,909 51,769 39,769 48,758 42,395 61,100 71,283 96,481 95,206 110,173 123,369 115,607 937,819 2015 106,251 67,825 58,659 45,691 39,675 35,752 56,704 48,637 72,934 117,302 143,413 142,394 935,237 2016 106,731 52,616 43,708 46,945 50,721 55,178 60,434 55,562 68,138 112,533 128,963 104,664 886,193 2017 82,677 77,937 43,792 43,207 43,024 69,549 65,723 94,452 103,867 101,184 114,872 109,769 950,053 2018 91,439 78,282 55,745 40,796 40,750 51,711 67,217 97,980 124,109 155,354 144,015 85,946 1,033,344 2019 60,576 53,119 45,651 45,552 39,014 43,048 61,238 48,787 79,167 102,887 144,299 130,752 854,090 2020 1 112,971 1 48,627 1 49,384 1 40,726 1 1 1 1 1 1 1 ■ 1 180,000 160,000 140,000 120,000 100,000 80,000 60,000 40,000 20,000 0 WATER PUMPED IN THOUSANDS 16Z5MI October November December January February March April May June 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 2015 MUD 3083 3087 3095 3119 3120 3122 3123 3128 3133 3134 3137 3149 2015 PID 1270 1276 1282 1285 1293 1307 1320 1331 1345 1352 1361 1368 2016 PID 1376 1380 1389 1396 1417 1423 1424 1430 1434 1435 1436 1436 2017 PID 1436 1437 1441 1441 1442 1442 1442 1442 1443 1443 1444 1444 2018 PID 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 2019 PID 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 2020 Total 4795 4796 4797 4797 2020 MUD 3351 3352 3353 3353 2020 PID 1444 1444 1444 1444 151 of 155 ebills Bills Mailed Bank Draft Credit Card Draft Online Payments Late Notices Disconnects Connections ebills Bills Mailed Bank Draft Credit Card Draft Online Payments Late Notices Disconnects Connections February 17, 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 938 941 944 951 3841 3845 3860 3835 646 650 652 654 1193 1185 1193 1198 1145 1192 1,184 1,208 378 453 339 462 21 41 42 27 M 3351 3352 3353 3353 P 1444 1444 1444 1444 Fiscal Year 2019 October November December January February March April May June July August September 870 867 868 883 885 890 903 904 932 932 932 936 3921 3921 3927 3903 3856 3859 3866 3859 3878 3875 3871 3859 650 650 660 664 661 669 666 666 664 656 656 653 1077 1109 1103 1114 1128 1151 1152 1152 1168 1161 1173 1179 1157 1130 1,124 1,149 1,111 1,129 1,100 1,162 1,098 1132 1145 1172 402 432 439 387 431 421 342 399 346 330 392 391 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 P 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 152 of 155 February 17, 2020 Regular Meeting Agenda Packet MUD Permits Month: January 2020 Plumbing Sewer Date of Customer Deposit Due to FW Water 135- Inspections 135- Inspections 135- Misc Income Permit Permit No. 135-25030 20500 Oversize Meter 135-49075 47035 47045 Fire Line 135-49900 135-49900 Total 1/17/2020 2020-16 $ 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 $ 153 of 155 $ 1,801.00 CASH STATUS AS OF JANUARY 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) *01/31/2020 Customer Water Deposits $318,815 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 (FY2019 Capital Projects plus prior year carry forward) Unassigned Fund Balance Current Year Revenue/Expenses Total Nonspendable, Assigned & Committed Fund Balances - General Fund 135 154 of 155 February 17, 2020 Regular Meeting Agenda Packet Restricted - Unable to be spent $o $318,815 $1,400,451 $0 $0 $919,266 $547,320 $0 $0 $783,441 $552,598 $3,884,957 $849,568 $736,540 $0 $242,846 $105,417 $119,214 $10,460,431 $o $0 Unrestricted - Available for spending $4,066,755 $2,275,821 $0 $150 $450 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $6,343,176 1 $0 1 $6,343,176 $6,343,176 $1,220,452 $0 $1,220,452 l $1,220,452 $1,220,452 Total in Accounts (Restricted & Unrestricted) $4,066,755 $2,594,636 $1,400,451 $150 $450 $919,266 $547,320 $0 $0 $783,441 $552,598 $3,884,957 $849,568 $736,540 $0 $242,846 $105,417 $119,214 $16,803,608 General Fund 135 Available 2,275,821 Prosperity General Fund 4,066,755 Texpool General Fund 600 Petty Cash 6,343,176 3,486 2,072,098 6,325,800 (166,399) $8,234,985 $1,220,452 $0 $1,220,452 TC Meeting Spaces Calendars FS Conference Roo FS Training Room Svore Board Room March 2020 10 11 12 13 Sun Mon Mar 1, 2020 8 15 22 2 9 16 6:30pm ritJ Boar 23 Tue February 17, 2020 Regular Meeting Agenda Packed,_ Modifier Wed Election Day ( 6am Denton C 4 10 11 17 18 24 25 14 29 30 31 tips 155 of 155 Thu 5 6:30pm TCWC 12 19 26 6:30pm TCWC Fri Sat 6 13 20 27 7 14 21 28 Powered by 7 team