Loading...
HomeMy WebLinkAbout2019-1216 December 16, 2019 Regular Meeting Complete Agenda PacketEP TROPHY CLUB MUNICIPAL I UTILITY DISTRICT December 16, 2019 Regular Meeting Agenda Packet BOARD OF DIRECTORS REGULAR MEETING TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 100 MUNICIPAL DRIVE TROPHY CLUB, TEXAS 76262 December 16, 2019 6:30 P.M. REGULAR MEETING AGENDA CALL TO ORDER AND ANNOUNCE A QUORUM Svore Municipal Boardroom 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. November Check Register b. November 14, 2019 Regular Meeting minutes c. November 22, 2019 Special Meeting minutes attachments: Check Register November 14, 2019 meeting minutes November 22, 2019 meeting minutes REGULAR SESSION 2. Discussion and possible action regarding sewer line break at 55 Sonora Drive and related repairs and damages. 3. Consider and take appropriate action regarding Candidate Search for General Manager (Castonguay/Flynn) a. Receive report and recommendation from Recruitment and Retention Subcommittee; and b. Approve Contract No. 2019121601 with executive search firm to identify potential General Manager 1 of 140 December 16, 2019 Regular Meeting Agenda Packet Candidates attachment: Contract No. 2019121601 4. Consider and take appropriate action regarding approval of Contract with Texas Commission on Environmental Quality relating to the District's Superior Water System Designation and Related Sign Obligations attachment: TCEQ Superior Water Recognition Agreement 5. Consider and take appropriate action regarding Adoption of Order No. 2019-1216 Authorizing General Manager to Contract for Purchase and Installation of Prefabricated Building and Sound Mitigation Improvements at the Wastewater Treatment Plant Facility attachment: Order No. 2019-1216 6. Consider and take appropriate action regarding approval of Proposal by Halff Associates, Inc. for Preparation of an Updated Legal Description and Boundary Map Trophy Club Municipal Utility District No. 1 and authorize execution thereof by General Manager. attachment: Halff Associates Proposal 7. Consider and take appropriate action regarding the November 2019 Combined Financials and Variance Report. a. Combined Financials b. Combined Variance attachments: Combined Financials Combined Variance REPORTS & UPDATES 8. 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 • Fiscal Year 2019 Summary • GASB 54 Reporting • Utility Billing Report 2 of 140 December 16, 2019 Regular Meeting Agenda Packet • Permits Collected • Cash Report attachments: General Manager Report Water Operations Report Wastewater Operations Report FY2019 Yearend Summary GASB54 Calculations GASB54 Designations Utility Billing Report Permits Collected Cash Report EXECUTIVE SESSION 9. Pursuant to Section 551.071 of the Texas Open Meetings Act, the Board may consult with its attorney in Executive Session on a matter in which the duty of the attorney to the Governmental Body under the Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflicts with the Open Meetings Act or to seek advice of counsel on legal matters involving pending or contemplated litigation or settlement offers: a. Contractor breach, performance and payment issues related to District's contract with Webber- Cadagua Partners for construction of the Wastewater Treatment Plant Improvements; and b. Trophy Club Municipal Utility District No. 1 v. Acadia Services, LLC, In the District Court of Tarrant County, 141st Judicial District (Cause No. 141-299351-18). c. Potential Condemnation of Easements required for construction and operation of Water Transmission Line Improvements from District Pump Station to Elevated Water Tank located on T.W. King Road 10. Pursuant to Section 551.072 of the Texas Open Meetings Act, the Board may deliberate the purchase, exchange, lease, or value of real property if deliberation in an open meeting would have a detrimental effect on the position of the governmental body in negotiations with a third person: a. Sale or Exchange of District real property located at 100 Municipal Drive and 1501 Junction Way. b. Purchase of Easements required for construction and operation of Water Transmission Line Improvements from District Pump Station to Elevated Water Tank located on T.W. King Road 11. 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. REGULAR SESSION 12. Consider and take appropriate action on matters deliberated in Executive Session: 13. Items for future agendas: 3 of 140 December 16, 2019 Regular Meeting Agenda Packet 14. Set future Meeting dates: a. Regular Board Meeting — Monday, January 20, 2020 at 6:30 p.m. attachment: January meeting calendar *THE BOARD RESERVES THE RIGHT TO ADJOURN INTO EXECUTIVE SESSION AT ANY TIME DURING THE MEETING PURSUANT TO THE APPLICABLE SECTION OF SUBCHAPTER D, CHAPTER 551, TEXAS GOVERNMENT CODE, THE TEXAS OPEN MEETINGS ACT, WITH RESPECT TO ANY ITEM ON THE AGENDA. NO FINAL ACTION, DECISION OR VOTE WILL BE TAKEN ON ANY SUBJECT OR MATTER IN EXECUTIVE SESSION. THIS NOTICE MODIFIES THE DISTRICT'S PRIOR PRACTICE OF SPECIFICALLY IDENTIFYING ALL AGENDA ITEMS TO BE DISCUSSED IN EXECUTIVE SESSION. ADJOURN 4 of 140 apackamt2 skrolczyk Begin Date: 11/01/2019 End Date: 11/30/2019 vends vend Name Number 998 HRCF41, DEE Totals for Check: 5875 998 DREES MS= MSS Totals for Check: 5876 998 DRUt48, WILISPM Totals for Check: 5877 998 REDWINE, EL/ZABETH Totals for Check: 5878 998 SHAM3N, .XE4 C Tbtals for Check: 5879 2943 JPMORGAN CHASE BANK NA 2943 .7PMGRGAN CHASE BANK NA Totals for Check: 5880 3213 Alan's Gates, Inc. Totals for Cherdc: 5881 1005 =mummy SUPPLY CO. 1005 ATLAS UTILITY SUPPLY CO. 1005 ATLAS UT L TY SUPPLY CO. Totals for Chedk: 5882 1926 BADGER METER, INC Tbtals for Check: 5883 2655 Care & Main LP Tbtals for Check: 5884 3184 namnunaF LLC 3184 DPTAPROSE LLC Totals for Check: 5885 998 ffiS., SAIW L. Totals for Check: 5886 2720 Filter Element Store Tbtals for Check: 5887 2606 Fisery Solutions, LLC Totals for Check: 5888 2635 Half£ Associates, INC From Amt: Invoice muter Invoice Inv Dept Account Date Stat No Number U0010020066104A 10/31/19 P 135-20050-000-000 U0017000007100A 10/31/19 P 135-20050-000-000 U0010050444103A 10/31/19 P 135-20050-000-000 00020000935213A 10/31/19 P 135-20050-000-000 U0010200020106A 10/31/19 P 135-20050-000-000 9/30/2019 09/30/19 P 135-20060-000-000 10282019 10/28/19 P 135-20060-000-000 9371 11/06/19 P 10 135-55080-010-000 10913A 11/05/19 P 10 135-69005-010-000 10913 10/30/19 P 10 135-69005-010-000 11497 10/22/19 P 10 135-65050-010-000 1330065 11/01/19 P 10 135-69005-010-000 1447823 11/01/19 P 10 135-55080-010-000 DP1903698 10/31/19 P 30 135-60035-030-000 DP1903698 10/31/19 P 30 135-55205-030-000 U0020660003201A 11/07/19 P 135-20050-000-000 SI -107780 91600888 30251 10/28/19 P 20 135-55080-020-000 11/04/19 P 30 135-60040-030-000 11/06/19 P 10. 135-69005-010-000 Trophy Club NOD No.1 AP Checks For Date/Amount Range .00 To Amt: 99,999,999.99 i>escriptaon A/P Verdo s A/P Vendors A/P Vendors A/P Vendors A/P Venders Procurement Clearing Procurement Clearing Maintpr m, & Repairs Capital Outlays Capital Outlays Meter Expense Capital Outlays Maintenance & Repairs Postage Utility Billing Oontract A/P Verk¢s Maintenance & Repairs Service Charges & Fees Capital Outlays 5 of 140 Ctilo r 10,,:2419 Regular Meeting Agenda Pmt 1 Lane lten C leClc C21eCJc Value Nus Date 13.31 5875 11/05/19 13.31 53.41 5876 11/05/19 53.41 39.63 5877 11/05/19 39.63 27.15 5878 11/05/19 27.15 08.16 5879 11/05/19 08.16 32284.42 5880 11/05/19 7,424.61 5880 11/05/19 10,709.03 1,178.00 5881 11/07/19 1,178.00 3,500.00 5882 11/07/19 3,800.00 5882 11/07/19 7,050.00 5882 11/07/19 14,350.00 5,472.00 5883 11/07/19 5,472.00 257.50 5884 11/07/19 257.50 1,624.07 5885 11/07/19 582.15 5885 11/07/19 2,206.22 483.29 5886 11/07/19 483.29 331.12 5887 11/07/19 331.12 50.00 5888 11/07/19 50.00 1,259.00 5889 11/07/19 apackasnt2 skrolczyk Begin Date: 11/01/2019 End Date: 11/30/2019 vemor vgwnr Name Number Tbtals for Check: 5889 1372 HACH COMPANY Totals for Check: 5890 2676 Humana Inc 2676 }Arcane Inc 2676 Humana Inc 2676 Humana Inc 2676 Humana Inc 2676 Humana Inc Totals for Check: 5891 um Ant: invoice Tami'teer invoice Inv pep: Amt Date Stat No Number 11684701 10/16/19 P 10 135-65030-010-000 155516833 11/13/19 P 155516833 11/13/19 P 155516833 11/13/19 P 155516833 11/13/19 P 155516833 11/13/19 P 155516833 11/13/19 P 1249 BOTHER AND ASSOCIATTS,INC 8113 Totals for Check: 5892 3167 KEYSTONE PARK SECREMIAL 157561 Totals for Cheek: 5893 1468 L.H. CSHANET MATERIALS, INC. 167521 Totals for Check: 5894 3186 MEMBER'S BUILDING NAINIENANCE TC1910TOMD 3186 MEMBER'S DING LAIN ENA1ICE TC1910TCMUD 3186 MEMBER'S BUILDING MAINTENANCE TC1910TCMUD Totals for check: 5895 3115 MEI1I9E GROUP BEFITS 3115 ME11IFE GROUP BENEFITS 3115 MTTT•IPE CROUP BENEFITS 3115 M ML1PE (ROUP BENEFITS Totals for Check: 5896 1053 NORTH CENTRAL TX CLOG Totals for Check: 5897 3156 OXLDOR LABORATORIES LLC 3156 0=0R LABORATORIES LIC 3156 07CLtXit2 LABORATORIES LLC 3156 C=OR LABOATC$tii+5 LTC 3156 OXLDOR LABORATORIES LLC 3156 O7iID0a2 uocemonms LTC Totals for CSck: 5898 11/15/2019 11/15/2019 11/15/2019 11/15/2019 INV -36926 19100513 19100577 19100656 19100722 19110097 19110052 3231 SC TRACKING SOLUTIONS LSC 128 Totais far•Chedk: 5899 10/29/19 P 10/30/19 P 10/26/19 P 10/31/19 10/31/19 10/31/19 11/15/19 11/15/19 11/15/19 11/15/19 10 20 30 135-21308-000-000 135-21309-000-000 135-21311-000-000 135-50029-010-000 135-50029-020-000 135-50029-030-000 20, 135-65045-020-000 30 135-60005-030-000 20 135-55125-020-000 P 20 135-55120-020-000 P 30 135-55120-030-000 P 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 10/30/19 P 30 135-60070-030-000 10/21/19 10/23/19 10/28/19 10/31/19 11/06/19 11/04/19 P 20 135-55135-020-000 P 20' 135-55135-020-000 P 20 135-55135-020-000 P 20 135-55135-020-000 P 20 135-55135-020-000 P 20 135-55135-020-000 11/01/19 P 30 135-55070-030-000 Trophy club MUD No.1 AP Checks For Date/Amount Range .00 To Amt: 99,999,999.99 17escriptaon Chemicals Dental Vision Voluntary Life Life Insurance & Other Life Insurance & Other Life Insurance & Other Lab Supplies Telephone Dumpsters Services Cleaning Services C7cgnirg Services Cleaning Services Start Tenn Disability Life Insurance & Other Life Insurance & Other Life Insurance & Other Dues & Memberships Lab Analysis Lab Analysis Lab Analysis Lab Analysis Lab Analysis Lab Analysis TxtdepemdeatTahrrr 6 of 140 C UNA r 1$:x®19 Regular Meeting Agenda Pmt 2 t.,,•w item U ec1 - check Value _ Number Date 1,259.00 907.47 5890 11/07/19 907.47 1,253.49 5891 11/07/19 181.70 5891 11/07/19 274.75 5891 11/07/19 125.44 5891 11/07/19 148.12 5891 11/07/19 149.52 5891 11/07/19 2,133.02 1,080.00 5892 11/07/19 1,080.00 207.75 5893 11/07/19 207.75 1,240.00 5894 11/07/19 1,240.00 87.50 5895 11/07/19 869.06 5895 11/07/19 87.50 5895 11/07/19 1,044.06 97.51 5896 11/07/19 123.66 5896 11/07/19 157.87 5896 11/07/19 160.48 5896 11/07/19 539.52 100.00 5897 11/07/19 100.00 317.40 5898 11/07/19 230.00 5898 11/07/19 317.40 5898 11/07/19 230.00 5898 11/07/19 230.00 5898 11/07/19 317.40 5898 11/07/19 1,642.20 595.00 5899 11/07/19 595.00 apackamt2 skoolczyk Begin Date: 11/01/2019 Find Date: 11/30/2019 Vendor Vendor fame Number 1578 SMITH PUMP MANY, INC. Totals for Check: 5900 1001 1001 1001 1001 1001 1001 1001 WAN OF TROPHY CLUB TOM OF TROPHY CLUB TOWN OF TROPHY CLUB MSC OF TROPHY OWB TOWN OF TROPHY CLUB TOWN OF TROPHY CLUB TON OF TROPHY CLUB Totals for Cheat: 5901 1000 TROPHY CLiB MOD (EATER BTT ) Totals for Check: 5902 2858 UTILTPY SERVICE OJ, INC. Totals for Check: 5903 1rivalCe ,fhxtt er SI016753 Fran Amt: Invoice 1x1V Dep: Account Date Stat fb Number 10/29/19 P 20 135-55081-020-000 OCT REFUSE 10/31/19 OCT REFUSE 10/31/19 OCT REFUSE 10/31/19 FY19 REFUSE AAT 09/30/19 EY19 RUSE AAT 09/30/19 FY19 REFUSE ADT 09/30/19 110119 11/04/19 10/31/2019 P 135-25040-000-000 P 135-25000-000-000 P 135-25010-000-000 P 135-25040-000-000 P 135-25000-000-000 P 135-25010-000-000 P 45 122-60337-045-000 10/31/19 P 30 135-60025-030-000 492210 11/01/19 P 10 135-69281-010-000 2663 ACE Heating & Air Conditioning 11/1/2019 Totals for Check: 5904 2651 Carman Cknsultiag ILC. 2651 Carman Consulting LLC. 2651 Chan Cknsulting LLC. Totals for (Heck: 5905 2683 Charter C annanicaticns Totals for Check: 5906 2677 Digital Air Ointrol, Inc Totals for Cheek: 5907 2635 Raiff Associates, INC Totals for Check: 5908 1372 HACH COMPANY Totals for Chedeckk: 5909 1468 L.H. CHAN'sY MATERIALS, INC. Totals for Check: 5910 2643 Mttean & Howard, L.L.P. 2643 McLean & Howard, L.L.P. Totals for Check: 5911 2392 MICKEY D MESON EEA/ Totals for Check: 5912 Troptxy club MUD No.1 AP Checks For Date/Amount Range .00 Tb Pmt: 99,999,999.99 Description Mainten & Repairs C'+1lections Town -Stomp. Drainage Refuse Refuse Tax Town -Storm Drainage Refuse Refuse Tax Transfer to Tbrax/Fire Budget Water Water Tank Inspection contract 11/01/19 P 45 122-69005-045-000 Capital Outlays 27 11/08/19 P 3 27 11/08/19 P 3 27 11/08/19 P 3 71672110619 2050313 30284 11709701 168104 35276 35277 1004191 11/06/19 P 11/10/19 P 11/07/19 P 11/04/19 P 11/09/19 P 10/31/19 P 10/31/19 P 11/08/19 P O 135-55070-030-000 0 135-55070-030-000 O 135-55070-030-000 30 135-55030-030-000 30 135-60235-030-000 10 135-69005-010-000 20 135-65045-020-000 20 135-55125-020-000 39 135-55045-039-000 39 135-55045-039-000 20 135-65031-020-000 IndePmdent Iah+r /ndependont Iabor Independent rAbor Software & Support Security Capital Outlays Lab Supplies Darpster Sertiices Legal Legal Chemicals Collections 7 of 140 114 r 14i4,:2419 Regular Meeting Agenda Pmt 3 Litre ltem C:necx cue= Value Harker Date 416.06 5900 11/07/19 416.06 35,751.59 65,109.34 5,351.11 06.00 14.94 02.46 59,888 08 166,123.52 5901 5901 5901 5901 5901 5901 5901 11/07/19 11/07/19 11/07/19 11/07/19 11/07/19 11/07/19 11/07/19 133.55 5902 11/07/19 133.55 57;932.73 5903 11/07/19 57,932:73 1,700.00 5904 11/14/19 1,700.00 32.48 11,680.00 04:15 11,716.63 5905 11/14/19 5905 11/14/19 5905 11/14/19 899.00 5906 11/14/19 899.00 24.00 5907 11/14/19 24.00 3,055.78 5908 11/14/19 3;055:78 298.43 5909 11/14/19 1,233.18 5910 11/14/19 1,233.18 298.43 3,570.00 5911 11/14/19 1,050.00 5911 11/14/19 4,620.00 4,994.00 5912 11/14/19 4,994.00 aackattt2 skrolczyk Begin Date: 11/01/2019 End Date: 11/30/2019 Vendor vendor Name N Amber 3111 North N693OroundWater Total q far Check: 5913 1056 OFFICE DEPOT, SNC Totals far Check: 5914 2723 Ross en Enterprises Inc Tbtais far Check: 5915 uu Amt: Invoice amber Invoice Inv Dept Account Date Stat No Nhnber 177 395550479001 PSI19-1140 2440 TARRANT CTY PUBLIC HEALTH LAB 32686 2440 TARRANT CTY PUBLIC HEALTH IAB 32687 Totals far Check: 5916 3282 TIAA COMMERCIAL FIANCE 6677723 Totals for Check: 5917 1081 TRI COUNTY ELECTRIC 76332899 Totals for Check: 5918 2634 Valley Solvent CknCaany, INC 49314 Totals for Check: 5919 1058 VERIZENTRILESS 1058 VFRIZLN WIRELESS 1058 VERIZ(N WSRE[ESS Ttjta1q for Check: 5920 Grand Totals: ****** End of Report ********* 9841164346 9641164346 9841164346 10/31/19 P 10/29/19 P 11/14/19 P 10/31/19 P 10/31/19 P 11/07/19 P 10/29/19 P 11/11/19 P 10 135-60135-010-000 30 135-65085-030-000 45 122-69005-045-000 10 135-55135-010-000 10 135-55135-010-001 30 135-69170-030-000 20 135-60020-020-000 20 135-65030-020-000 11/01/19 P 10 135-60010-010-000 11/01/19 P 20 135-60010-020-000 11/01/19 P 30 135-60010-030-000 Trophy Club ).W No.1 AP Checks For Date/Amount Range .00 Tb Amt: 99,999,999.99 Description TC3sl0 Fees & Permits Office Supplies Capital Outlays Lab Analysis Lab Analysis for PID Copier Lease Installments Electricity Chsniral a Camrunications/Mobiles Carrru:icaticns/Mobiles Oattrunicatirmw/Mnbiles 8 of 140 E % /i r 1 :2419 Regular Meeting Agenda Pmt 4 Luse Item (Zeck (meek Value Number Date 5,752.20 5,752.20 112.18 112.18 1,050.00 1,050.00 140.00 80.00 220.00 165.00 165.00 500.86 500.86 569.00 569.00 865.02 769.01 88.02 1,722.05 309,165.01 5913 11/14/19 5914 11/14/19 5915 11/14/19 5916 11/14/19 5916 11/14/19 5917 11/14/19 5918 11/14/19 5919 11/14/19 5920 11/14/19 5920 11/14/19 5920 11/14/19 December 16, 2019 Regular Meeting Agenda Packet REGULAR MEETING MINUTES TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 BOARD OF DIRECTORS November 14, 2019 at 4:30 P.M. Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in regular session on Thursday, November 14, 2019 at 4: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 Desiree Grubbs President Vice President Secretary/Treasurer Director Director General Manager District Secretary Operations Manager Finance Manager Wastewater Superintendent Staff Accountant/HR Coordinator CALL TO ORDER AND ANNOUNCE A QUORUM President Wilson announced the date of November 14, quorum of the Board was present at 4:30 p.m. The Board convened into Executive Session at 4:31 p.m. 2019, called the meeting to order and stated a EXECUTIVE SESSION 1. 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 8:39 p.m. REGULAR SESSION 2. Consider and take appropriate action on matters deliberated in Executive Session: President Wilson stated that no decisions, votes or actions were taken in Executive Session. CITIZEN COMMENTS: Brock Harwell 55 Sonora Drive 9 of 140 December 16, 2019 Regular Meeting Agenda Packet CONSENT AGENDA 3. Consider and take appropriate action to approve the Consent Agenda. a. October Check Register b. October 21, 2019 Regular Meeting minutes Motion made by Director Rose and seconded by Director Flynn to approve the Consent Agenda. Motion carried unanimously REGULAR SESSION 4. Consider and take appropriate action to appoint two (2) directors to serve on the Audit Committee. Motion made by Director Castonguay and seconded by Director Flynn to appoint President Wilson and Vice President Rose to serve on the Audit Committee. Motion carried unanimously 5. Discussion and possible action regarding noise level at the wastewater treatment plant. (Flynn/Wilson) Direction was provided for staff to obtain a total cost for the structure along with a timeline for completion back to the board on the December 16, 2019 meeting. 6. Consider and take appropriate action regarding employee health and ancillary benefits for the calendar year beginning January 1, 2020 and ending December 31, 2020. (Staff) Motion made by Director Rose and seconded by Director Castonguay to have the District maintain coverage with United Healthcare All Savers for Medical benefits, and Humana and MetLife for ancillary benefits for the 2020 year. Motion carried unanimously 7. Consider and take appropriate action regarding the October 2019 Combined Financials and Variance Report. (Staff) a. Combined Financials b. Combined Variance Motion made by Director Flynn and seconded by Director Chapman to approve the October 2019 Combined Financials and Variance Reports. Motion carried unanimously 10 of 140 December 16, 2019 Regular Meeting Agenda Packet REPORTS & UPDATES 8. 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 General Manager John Carman presented his monthly update to the Board and answered questions related thereto. 9. Items for future agendas: — Staff is to provide an estimate of the total cost for the blower surround structure at the wastewater treatment plant as well as a timeline for completion at the December meeting — Update regarding 55 Sonora Drive 10. Set future Meeting dates: a. Regular Board Meeting — Monday, December 16, 2019 at 6:30 p.m. ADJOURN President Wilson called the meeting adjourned at 9:18p.m. Gregory Wilson, President Steve Flynn, Secretary/Treasurer Laurie Slaght, District Secretary 11 of 140 (SEAL) December 16, 2019 Regular Meeting Agenda Packet SPECIAL MEETING MINUTES TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 BOARD OF DIRECTORS November 22, 2019 at 3:00 P.M. Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in a special session on Friday, November 22, 2019 at 3:00 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 President William C. Rose Vice President Steve Flynn Secretary/Treasurer Kelly Castonguay Director Mark Chapman Director STAFF PRESENT: John Carman Laurie Slaght Frank Isola Desiree Grubbs § General Manager District Secretary Wastewater Superintendent Staff Accountant/HR Coordinator CALL TO ORDER AND ANNOUNCE A QUORUM President Wilson announced the date of November 22, 2019, called the meeting to order and announced a quorum of the Board was present at 3:00 p.m. The Board convened into Executive Session at 3:01 p.m. EXECUTIVE SESSION 1. 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 4:34 p.m. REGULAR SESSION 2. Consider and take appropriate action relating to employment of new General Manager No action taken 3. Consider and take appropriate action relating to repair of groundwater well pump and related equipment. General Manager John Carman stated that there had been a failure in groundwater well No. 1 involving the electrical panel and breakers as well as the pump. The estimate to replace the pump is $50,000 and 12 of 140 December 16, 2019 Regular Meeting Agenda Packet that the parts had been ordered as this was an emergency procurement. 4. Consider and take appropriate action regarding request by Denton County Elections to use the Svore Municipal Boardroom as an early voting polling location for the March 2, 2020 Primary Election. Discussion only, no action taken ADJOURN President Wilson called the meeting adjourned at 4:45 p.m. Gregory Wilson, President Steve Flynn, Secretary/Treasurer Laurie Slaght, District Secretary 13 of 140 (SEAL) Sk0R December 16, 2019 Regular Meeting Agenda Packet Date: December 12, 2019 Agreement for Executive Recruitment Services for General Manager between Strategic Government Resources, Inc. ("SGR") and Trophy Club Municipal Utility District No. 1 ("Organization") Scope of Services. SGR shall provide all services for recruitment as described in the formal proposal dated June 28, 2019, a copy of which is attached hereto, and described in abbreviated form as follows: • Develop a position profile and recruitment brochure for the position. **Please note that for any changes made to the Position Profile Brochure after the position is launched, there will be a $250 Change Fee per occurrence** • Place ads in appropriate professional publications, as approved. • Social media and email marketing of position. • Identify high -probability prospects and follow up with those prospects. • Receive, track, and maintain all inquiries and applications. • Conduct a "triage" level review of all resumes and conduct initial phone/email conversations with candidates. • Develop written questionnaire customized to the position, distribute questionnaires to semifinalist candidates, and evaluate responses. • Conduct pre-recorded online interviews with up to 12 semifinalist candidates. • Conduct Stage 1 Media Searches on up to 12 semifinalist candidates. • Provide periodic updates regarding the progress of the search, as frequently as desired. • Assist Organization in developing a short list of up to 6 finalist candidates recommended for interviews and present a verbal briefing on relevant issues related to each. • Assist in preparation of recommended interview questions and of the interview process. • Conduct comprehensive Stage 2 Media Searches on up to 6 finalist candidates. • Conduct psychometric assessments on up to 6 finalist candidates, if requested. PO Box 1642, Keller, TX 76244 817143 7t$ 81 www.GovernmentResource.com December 16, 2019 Regular Meeting Agenda Packet • Conduct Reference Checks. Our reference checks are the most comprehensive in the industry. We will talk to as many professional contacts as necessary in order to fully understand a given candidate's style, personality, strengths, and weaknesses. We will ask candidates for contacts from their current or most recent organization, including: • All Department Heads and/or Direct Reports • Two Professional Peers in other organizations • All Assistant or Deputy City Managers, if any • All Elected Officials • Two Community Leaders • Any other individuals who would provide meaningful insights We always seek out the candidate's greatest critics and greatest fans to ensure a complete, yet balanced, perspective and overview of each candidate. • Conduct comprehensive background investigation on up to 6 finalist candidates consisting of SSN trace and address verification; credit and financial summaries and credit bureau report; personal information, address, and employment comparisons; county criminal and civil records search (for last three counties of residence); state criminal records search (for last three states of residence); county wants and warrants; Federal criminal records search; InstaCriminal national search; Global homeland security search; sex offender records search; driving/motor vehicle records; education verification for highest degree obtained; employment verification (if desired); and military verification (if desired). The Organization shall: • Provide photos/graphics and information necessary to develop position profile brochure. • Provide reproduction of hard copy brochure production, if desired. • Provide any direct mailings desired by the Organization. • Provide legal opinions to SGR regarding when and if any information must be released by the Organization in accordance with Public Information requests. The parties agree that all work product generated by SGR shall be owned by SGR, and the Organization shall only be entitled to the deliverables described herein. • Reimburse finalists for travel -related expenses to interview. Page 2 of 6 15 of 140 December 16, 2019 Regular Meeting Agenda Packet SGR shall be compensated by the Organization as detailed below: • Pricing o Professional Services = $30,000 (Plus any optional services as described below, if desired.) • Expense Items - SGR considers incidentals to be covered by the professional services fee, and we do not bill the Organization for any expenses except for those explicitly detailed herein. The expense items included in the professional services fee are as follows. o Professional production of a high-quality brochure. This brochure (typically four pages) is produced by SGR's graphic designer for a flat fee of $1,500. o Marketing and Ad Placements: ■ Announcement in SGR's 10 in 10 Leadership and Innovation e -newsletter. ■ Email blast to SGR's profession -specific opt -in subscriber list. ■ Featured post on SGR's website. ■ Featured ad on SGR's job board. ■ Promotions on SGR's social media pages — Facebook, Twitter, Linkedln, Instagram. ■ Targeted ad placements on Linkedln users' pages who have been selected by Linkedln's algorithm to be a match for your job posting. ■ Ad placements with one national association and one state association. These two ads are billed at actual cost, with no markup for overhead. Additional ad placements, of the organization's choice, will be billed over and above the not -to -exceed maximum price. o Printing of documents and materials. The reproduction costs for briefing materials for the governing body and/or search committee up to 10 binders, which include semifinalist and finalist materials are billed at 26 cents per copy, plus the cost of binders and shipping. Flash drives are billed at $10 each. o Online Interviews. There is a cost of $200 for each recorded online interview (up to 12 semifinalist candidates included in not -to -exceed expenses above). o Comprehensive Media Reports — Stage 2. There is a cost of $500 per candidate (up to 6 finalist candidates included in not -to -exceed expenses above). o Comprehensive Background Investigation Reports. There is a cost of $400 per candidate for our comprehensive background screening reports prepared by our licensed private investigation provider (up to 6 finalist candidates included in not - to -exceed expenses above). o Travel and related costs for the Recruiter that are approved in advance by the organization are incurred for the benefit of the Organization including travel to/from airport. Meals are billed back at a per diem rate of $10 for breakfast, $15 Page 3 of 6 16 of 140 December 16, 2019 Regular Meeting Agenda Packet for lunch, and $25 for dinner. Mileage will be reimbursed at the current IRS rate. All other travel -related expenses are billed back at actual cost, with no markup for overhead. o Up to four (4) visits/trips by the Recruiter to the Organization. Upon prior approval of the Organization, any additional visits/trips by the Recruiter will be billed over and above the not -to -exceed maximum price. • Billing o Professional fees for the search are billed in three equal installments during the course of the search. The initial installment is billed after the Organizational Inquiry and Analysis is completed. The second installment is billed when semifinalists are selected. The final installment is billed at the conclusion of the search. Approved expense (reimbursable) items and supplemental services will be billed with each of the three installments, as appropriate. Organization Contact for Invoicing: Name: Position: Email: Phone: • Optional/Supplemental Services (not included in the price above) o Candidate Travel. Candidates are typically reimbursed directly by the Organization for approved travel expenses. If the Organization prefers a different arrangement for candidate travel, SGR will be glad to accommodate the Organization's wishes. o Stakeholder Survey. SGR will conduct a Stakeholder Survey for $1,000 upon request of the Organization. SGR provides recommended survey questions and sets up an online survey. Stakeholders are directed to a web page or invited to take the survey by email. A written summary of results is provided to the organization. o Additional Ad Placements. Additional ad placements, as approved by the organization, that are not included in the not -to -exceed expenses will be billed back at actual cost with no markup for overhead. o DiSC or IOPT Assessments. There is a cost of $150 per candidate for the DiSC or IOPT Management profile. o Approved Site Visits to Communities of Finalist Candidates will be charged at a day rate of $1,000 per day, plus travel expenses. Page 4 of 6 17 of 140 December 16, 2019 Regular Meeting Agenda Packet o In the unexpected event the Organization shall request that unusual out of pocket expenses be incurred, said expenses will be reimbursed at the actual cost with no mark-up for overhead. o If the Organization desires any supplemental services not mentioned in this section, an estimate of the cost and hours to be committed will be provided at that time, and no work shall be done without approval. Supplemental services will be billed out at $250 per hour. Terms and Conditions: • SGR guarantees that the Organization will be satisfied with the results of the recruitment process, or SGR will repeat the entire process at no additional professional fee until the Organization selects a candidate. Additionally, if the Organization selects a candidate (that SGR has fully vetted through our recruitment process) who resigns or is released within 18 months of their hire date, SGR will repeat the process at no additional professional fee to the Organization. If the Organization circumvents SGR's recruitment process or selects a candidate that did not participate in the full recruitment process, this service guarantee is null and void. • The Organization reserves the right to terminate this agreement at any time upon giving SGR seven days advanced written notice. In such event SGR will be compensated for all work satisfactorily completed up to and through the date of termination. In addition, SGR shall provide to the Organization all deliverables completed through the date of termination. • The Organization acknowledges that the nature of executive recruitment is such that SGR engages in discussions with prospects throughout the process who may or may not ultimately become a candidate, and that SGR is utilizing its proprietary network of relationships to identify and engage prospective candidates, and that premature release of such proprietary information, including names of prospective candidates who SGR may be having conversations with as part of the recruitment process, may be damaging to the prospects and to SGR. Accordingly, the Organization acknowledges and, to the extent provided by law, agrees that all information related to this search is proprietary, and remains the property of and under the exclusive control of SGR, regardless of whether such information has been shared with the Organization or not, including all decisions regarding release of information, until such time that a finalist is named. At the time finalists are determined, all information related to the finalists shall become the property of the Organization and all decisions regarding public disclosure shall be determined by the Organization, except that psychometric assessments, questionnaires, and any information produced by SGR is proprietary and shall not become the property of the Organization or subject to disclosure except as otherwise required by applicable law. Page 5 of 6 18 of 140 Approved and Agreed to, this the Melissa Valentine, Managing Director of Recruitment and Human Resources Strategic Government Resources December 16, 2019 Regular Meeting Agenda Packet day of . 2019 by and between Trophy Club Municipal Utility District No. 1 Printed Name: Title: Page 6 of 6 19 of 140 Jon Niermann, Chairman Emily Lindley, Commissioner Bobby Janecka, Commissioner Toby Baker, Executive Director December 16, 2019 Regular Meeting Agenda Packet PWS_0610018_CO_20191205_Superior TEXAS COMMISSION ON ENVIRONMENTAL QUALITY Protecting Texas by Reducing and Preventing Pollution December 5, 2019 Gregory Wilson, President Trophy Club MUD 1 100 Municipal DR Trophy Club, TX 76262-5420 Subject: Superior Public Water System (PWS) Recognition Trophy Club MUD 1, PWSID - 0610018 Denton County, Texas Dear Mr. Wilson: As a result of the Texas Commission on Environmental Quality's (TCEQ) recent Comprehensive Compliance Investigation (CCI) and review of records concerning the Trophy Club MUD 1, it has been determined that the public water system meets the TCEQ's Superior Public Water System recognition requirements in accordance with 30 Texas Administrative Code §290.47. This recognition authorizes display of Superior Public Water System signs on highways entering the area served by this public water system. Please note that before installing the signs along the highway rights-of-way, the District Engineer of the Texas Department of Transportation (TxDOT) should be contacted and his approval obtained concerning the proposed sign installation sites. We are enclosing two copies of an Agreement Form to be signed by the person indicated and returned to this office. My signature will be affixed to this document and one copy returned to you for your files. In conclusion, we wish to thank you for your diligence and concern regarding the Trophy Club MUD 1's public water system. If you have any questions or require further assistance, please do not hesitate to contact Leticia De Leon in the Drinking Water Special Functions Section at (512) 239- 4978 or Leticia.DeLeon@tcea.texas.gov. Sincerely, Michele Risko, Manager Drinking Water Special Functions Section Water Supply Division MR/TN/av cc: TCEQ Region 4, Dallas/Fort Worth - Brent Candler, Water Program P.O. Box 13087 • Austin, Texas 78711-3087 • 512-239-1000 • tceq.texas.gov How is our customer service? tceq.texas.gov/customersurvey 20 of 140 printed on recycled paper using vegetable based ink December 16, 2019 Regular Meeting Agenda Packet AN AGREEMENT In view of having received a SUPERIOR PUBLIC WATER SYSTEM rating in accordance with TEXAS COMMISSION ON ENVIRONMENTAL QUALITY standards and in order to create public confidence and to properly advertise the good quality of the drinking water supply of Trophy Club MUD 1, the TEXAS COMMISSION ON ENVIRONMENTAL QUALITY has granted this permission to install standard highway markers on the recognized highways leading into the area served by Trophy Club 1. On their part, the OFFICIALS of Trophy Club 1 agree to prepare, install, maintain and be entirely responsible for these signs. The OFFICIALS further agree to effect the immediate removal of such signs whenever they are advised by the TEXAS COMMISSION ON ENVIRONMENTAL QUALITY that the rating of this supply has fallen below the required standards. Should the OFFICIALS fail to remove the signs upon notification that the rating of this supply has fallen below the required standards, it is understood and agreed that the TEXAS COMMISSION ON ENVIRONMENTAL QUALITY is empowered to effect their removal as though the signs were property of the COMMISSION. In AGREEMENT OF THE ABOVE CONSIDERATION, the following parties attach their names to this understanding. Trophy Club MUD 1 Public Water System ID No. 0610018 Gregory Wilson, President Trophy Club MUD 1 Michele Risko, Manager Drinking Water Special Functions Water Supply Division 21 of 140 December 16, 2019 Regular Meeting Agenda Packet ORDER NO. 2019-1216 ORDER AUTHORIZING GENERAL MANAGER TO CONTRACT FOR PURCHASE AND INSTALLATION OF PREFABRICATED BUILDING AND SOUND MITIGATION IMPROVEMENTS (Wastewater Treatment Plant Sound Mitigation Project) WHEREAS, Trophy Club Municipal Utility District No. 1 (the "District") is a duly created and existing municipal utility district created and operating under Chapters 49 and 54 of the Texas Water Code, as amended; WHEREAS, the District owns and operates a wastewater treatment plant facility for the treatment and disposal of domestic wastewater; WHEREAS, to mitigate the sound impact of wastewater treatment plant on the use and enjoyment of property by nearby residents, the Board of Directors desires to purchase and install a prefabricated building and sound mitigation improvements for the wastewater treatment plant blowers and related equipment; WHEREAS, Section 49.056(a) of the Texas Water Code authorizes the board of directors of a municipal utility district to delegate to its general manager full authority to manage and operate the affairs of the district subject only to the orders of the board; and WHEREAS, pursuant to the foregoing authority, the Board of Directors desires to authorize the District's General Manager to contract for purchase and installation of a prefabricated building and sound mitigation improvements at the wastewater treatment plant facility. 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 found 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 hereby authorizes the General Manager to enter into solicit bids from qualified contracts and to contract for purchase and installation of a prefabricated building and sound mitigation improvements at the wastewater treatment plant (the "Project") subject to the following parameters and limitations: i. The General Manager shall solicit at least three bids from qualified contractors for the Project; and ii. The total cost of the Project shall not exceed $70,000 without prior authorization of the Board of Directors; and iii. The form of the contract shall be subject to review and approval by the District's legal counsel prior to execution by the General Manager. 22 of 140 December 16, 2019 Regular Meeting Agenda Packet ADOPTED, PASSED AND APPROVED by the Board of Directors of Trophy Club Municipal Utility District No. 1, Trophy Club, Texas this 16th day of December 2019. Greg Wilson, President Board of Directors Steve Flynn, Secretary/Treasurer Board of Directors Laurie Slaght, District Secretary 23 of 140 (SEAL) p HALFF November 20, 2019 P37835.001 Mr. John Carman Trophy Club Municipal Utility District No.1 100 Municipal Drive Trophy Club, Texas 76262 December 16, 2019 Regular Meeting Agenda Packet RE: Proposal for Legal Description of Boundaries of Trophy Club Municipal Utility District No. 1 Dear Mr. Carman, We are pleased to present the following scope of services and fee schedule to provide professional engineering services for the Trophy Club Municipal Utility District No.1 (District). Per our discussion, the District would like Halff Associates to prepare an updated boundary description of the Trophy Club Municipal Utility District No. 1. This contract proposal includes the following items: Attachment 'A' — Scope of Services and Attachment 'B' — Fee Summary. Refer to Halff's Agreement for Professional Engineering Services on a Task Order Basis, executed by the District on October 18, 2018, for the terms and conditions of this proposal. The fees quoted in this proposal will be honored for up to 60 days from the date of this proposal. The signed Agreement by both parties will serve as Notice to Proceed (NTP). Services will begin upon NTP. See Attachment B' for signature page. We trust this proposal meets your requirements for this project. We appreciate the opportunity to be of service to you, and trust that our association on this project will be mutually beneficial. Please feel free to contact us if you have any questions or comments concerning this proposal. Sincerely, HALFF ASSOCIATES, INC. Leah M. Hodge, PE, CFM Project Manager C: David M. Smith, PE - Halff HALFF ASSOCIATES, INC 4000 FOSSIL CREEK B LVD TEL (817) 8 47-1422 WW W HALF F COM FORT WORTH TX 76137 FAX (817) 232- 9784 24 of 140 Now HALFF NOM December 16, 2019 Regulmplly g AI Packet TCMUD No. 1 November 20, 2019 Page 2 ATTACHMENT 'A' Scope of Services Overview Halff will compile descriptions of all tracts included in the District boundary. Tracts with common boundaries will be merged. The District will review the outer boundary and Halff will make any necessary edits. Once approved, Halff will provide the metes and bounds of the final boundary in Word format. Both CADD and shapefiles (GIS) of the updated boundary will be provided to the Distrct. Store Existing Tracts Halff will store the coordinate geometry of each tract contained within the District. It is assumed that there are fifteen (15) tracts. The tracts include: 1. Northerly Parcel 2. South Parcel 3. Westerly Section 4. Easterly Section 5. Lot 1 Block 2 6. Lot 2 Block 2 7. Lot 3 Block 2 8. Lot 4 Block 2 9. Churchill Downs Annexation (12.2346 acres) 10. Northwest Independent School District Byron Nelson High School Annexation (92.655 acres) 11. Highlands Annexation (2.503 acres) 12. Wonderland Plaza Addition, Lots 1 & 2, Block A (4.5161 acres) 13. Trophy Club Village Centre, Lots 1 & 2, Block 1 (2.532 acres) 14. Trophy Club Drive Church Addition, Lots 1 & 2, Block 1 (7.0441 acres) 15. Meadowbrook Lane Lot Annexation (1.055 acres) Merge Existing Tracts Halff will rectify the individual tracts as necessary to ensure the common boundaries are identical. Tracts with differing coordinate systems will be converted to a common coordinate system. Halff will then merge all tracts with shared boundaries. Review Halff will meet with District staff to review the updated/merged boundary description and determine if any adjustments need to be made. The boundary will be visualized and compared with a high-resolution aerial image to confirm all properties served by the District are contained within the boundary. The District will also verify the boundary follows the intended roads, parcel boundaries, adjacent jurisdictions, etc. Halff will make any necessary revisions based on the District's review. Boundary Description Halff will provide the metes and bounds of the final boundary in Word format. Since the boundary does not include any field verification, "more or less" will be added to all calls. Halff will also provide the boundary in both CADD and GIS (shapefile) formats 25 of 140 HALFF December 16, 2019 RegullaF r. o m man Mee�tin�A enda Packet TCMUD No. 1 November 20, 2019 Page 3 No survey field investigation is included in the scope of this project. 26 of 140 ;M; HALFF PROPOSED FEE SCHEDULE December 16, 2019 Regual,MpiWVW Packet TCMUD No. 1 November 20, 2019 Page 4 ATTACHMENT `B' Fee Summary 1. Store, Merge, Rectify, and Redefine District Boundary $30,000 (Hourly) TOTAL FEE $30,000 The hourly fee (cost plus max) will not be exceeded without prior approval from the District. The hourly fee (cost plus max) will be invoiced monthly based on the hourly effort completed. Halff will coordinate with the District to establish the billing schedule. Direct costs, including printing, plotting, and reproduction, postage, messenger service, specialized equipment (such as GPS), long distance telephone calls and vehicle mileage will be considered reimbursable and will be billed at 1.10 times the direct cost incurred. Additional services may be requested by the District on a task order basis. Halff will develop a separate scope and fee for each additional service and obtain approval from the District prior to initiating work on the additional services. The summary of hourly billing rates included in the October 18, 2018 Agreement for Professional Engineering Services has been updated. The rate table below reflects the current rates which will apply to this task order. Labor Categoryai -vel Billing Rate Range Low H ig,4 Architect Engineer Scientist 75.00 II 92.00 III 130.00 IV 199.00 ✓ 226.00 85.00 I I 107.00 III 146.00 IV 188.00 ✓ 232.00 72.00 I I 98.00 10 133.00 IV 170.00 ✓ 213.00 27 of 140 90.00 126.00 166.00 219.00 325.00 110.00 145.00 211.00 239.00 350.00 97.00 128.00 168.00 215.00 350.00 ,•„ HALFF Landscape/ Planner Surveyor Field Tech Office Tech Administrative Specialist Intern Notes: 1. Labor Category (Specialty): December 16, 2019 Regulic1FFic0 Packet TCMUD No. 1 November 20, 2019 Page 5 72.00 88.00 II 88.00 121.00 II1 121.00 153.00 IV 155.00 201.00 ✓ 209.00 340.00 92.00 95.00 11 96.00 118.00 III 133.00 142.00 IV 140.00 186.00 51.00 69.00 II 65.00 85.00 til 86.00 107.00 IV 116.00 138.00 ✓ 153.00 216.00 43.00 69.00 I I 69.00 89.00 III 86.00 120.00 IV 112.00 144.00 ✓ 140.00 182.00 29.00 69.00 I I 67.00 85.00 III 82.00 112.00 IV 111.00 143.00 ✓ 144.00 350.00 66.00 97.00 I 97.00 133.00 III 124.00 171.00 IV 174.00 208.00 ✓ 223.00 333.00 44.00 69.00 Architect Engineer (Civil, Structural, Mechanical, Electrical, Oil & Gas) Scientist (Environmental and Geological) Landscape/Planner Surveyor Field Tech (Survey, SUE, Environmental & Construction) 28 of 140 By: HALFF Submitted: December 16, 2019 Regutprll Packet TCMUD No. 1 November 20, 2019 Page 7 Approved: HALFF ASSOCIATES, INC. TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO.1 Signature David M. Smith Printed Name Public Works Team Leader Title November 19. 2019 Date By: 30 of 140 Signature Printed Name Title Date December 16, 2019 Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET NOVEMBER 2019 ASSETS CASH IN BANK INVESTMENTS PREPAID EXPENSES ADVALOREM PROPERTY TAXES RECEIVABLE EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 FIRE DEPT. 329,248 16,409 1,187,888 TOTAL ASSETS 1,533,547 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 31 of 140 1,187,895 1,187,895 603,769 (258,117) 345,652 1,533,547 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 1 16:37 12/09/19 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40010-000-000 Property Taxes/MUD Fire 122-40011-000-000 Property Taxes/Fire-Delinquent 122-40020-000-000 Property Taxes/Fire P&i Subtotal: Program number: Department number: Revenues Fire 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- 1,214,230.00- 1,214,230.00- 1,214,230.00- 1,214,230.00- 32 of 140 60,041.08- 75,563.94- 914.94- 452.79 1,079.94- 1,148.41- 62,035.96- 76,259.56- 62,035.96- 76,259.56- 62,035.96- 76,259.56- 62,035.96- 76,259.56- 6.223 6.280 6.280 6.280 6.280 1,138,666.06- 452.79- 1,148.41 1,137,970.44- 1,137,970.44- 1,137,970.44- 1,137,970.44- glbase_tbam skrolczyk 16:37 12/09/19 Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Trophy Club MUD No.1 Budget Summary with Amendment Page 2 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 Subtotal: 957,661.00 957,661.00 122-69005-045-000 122-69009-045-000 122-69195-045-000 122-69305-045-000 Subtotal: Capital Outlays Short Term Debt -Interest GASB34/Reserve for Replacement Capital Leases 48,000.00 48,000.00 81,420.00 81,420.00 127,149.00 127,149.00 256,569.00 256,569.00 Program number: 1,214,230.00 1,214,230.00 Department number: Fire Expenditures Subtotal Fund number: 122 Trophy Club MUD Fire Dept. 1,214,230.00 1,214,230.00 1,214,230.00 1,214,230.00 33 of 140 1,640.88 59,888.08 61,528.96 2,750.00 3,281.76 119,776.16 123,057.92 2,750.00 11,958.24 81,420.00 115,190.36 2,750.00 211,318.60 64,278.96 334,376.52 64,278.96 64,278.96 2,243.00 334,376.52 334,376.52 258,116.96 15.627 16.667 12.850 5.729 100.000 90.595 82.363 27.538 27.538 27.538 218,004.00 17,718.24 598,880.84 834,603.08 45,250.00 11,958.24- 11,958.64 45,250.40 879,853.48 879,853.48 879,853.48 258,116.96- glpdatb2 skrolczyk Trophy Club MUD No.1 Page 1 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40010-000-000 Property Taxes/MUD Fire 363 11/01/2019 Property Taxes 364 11/04/2019 Property Taxes 365 11/05/2019 Property Taxes 366 11/06/2019 Property Taxes 367 11/07/2019 Property Taxes 368 11/08/2019 Property Taxes 369 11/12/2019 Property Taxes 370 11/13/2019 Property Taxes 371 11/14/2019 Property Taxes 372 11/15/2019 Property Taxes 373 11/18/2019 Property Taxes 374 11/19/2019 Property Taxes 375 11/20/2019 Property Taxes 376 11/21/2019 Property Taxes 377 11/22/2019 Property Taxes 378 11/25/2019 Property Taxes 379 11/26/2019 Property Taxes 380 11/27/2019 Property Taxes (15,522.86) (1,541.19) (17,064.05) GL (3,618.25) (20,682.30) GL (6,659.43) (27,341.73) GL (2,600.62) (29,942.35) GL (3,105.87) (33,048.22) GL (5,666.45) (38,714.67) GL (1,442.44) (40,157.11) GL (6,701.27) (46,858.38) GL (3,596.12) (50,454.50) GL (1,484.48) (51,938.98) GL (838.39) (52,777.37) GL (3,442.24) (56,219.61) GL (8,699.42) (64,919.03) GL (1,935.40) (66,854.43) GL (177.09) (67,031.52) GL (3,646.78) (70,678.30) GL (3,604.20) (74,282.50) GL (1,281.44) (75,563.94) GL Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (60,041.08) (75,563.94) ** (1,214,230.00) Budgeted (1,138,666.06) Remaining 6 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 363 11/01/2019 Property Taxes 366 11/06/2019 Property Taxes 374 11/19/2019 Property Taxes 377 11/22/2019 Property Taxes 380 11/27/2019 Property Taxes 1,367.73 (212.72) 1,155.01 GL (282.07) 872.94 GL (3.44) 869.50 GL 16.80 886.30 GL (433.51) 452.79 GL Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (914.94) 452.79 ** .00 Budgeted (452.79) Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P6I 363 11/01/2019 Property Taxes 365 11/05/2019 Property Taxes 366 11/06/2019 Property Taxes 369 11/12/2019 Property Taxes 370 11/13/2019 Property Taxes 372 11/15/2019 Property Taxes 374 11/19/2019 Property Taxes (68.47) (46.79) (115.26) GL (1.13) (116.39) GL (17.04) (133.43) GL (1.12) (134.55) GL (.08) (134.63) GL (.97) (135.60) GL (.65) (136.25) GL 34 of 140 glpdatb2 skrolczyk 16:38 12/09/19 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description 375 11/20/2019 Property Taxes 380 11/27/2019 Property Taxes Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Fire Revenues Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 JE Detail Beginning Transaction Transaction Vendor_Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 2 (68.47) (917.10) (95.06) (1,053.35) (1,148.41) GL GL Account: 122-40020-000-000 Property Taxes/Fire P6I Totals: (1,079.94) (1,148.41) ** .00 Budgeted 1,148.41 Remaining 0 % Used Department Totals: (62,035.96) Monthly Total (76,259.56) ** (1,214,230.00) Budgeted (1,137,970.44) Remaining 6 % Used 35 of 140 glpdatb2 skrolczyk 16:38 12/09/19 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Department: 45 Fire JE Detail Description/Comment Trophy Club MUD No.1 Page 3 Detailed Accounting Trial Balance Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 122-60030-045-000 Rent And/Or Usage Account: 122-60030-045-000 Rent And/Or Usage Totals: 218,004.00 Budgeted Account: 122-60055-045-000 Insurance 67 11/01/2019 Insurance/Wrk Comp Expense Nov Account: 122-60055-045-000 Account: 122-60337-045-000 225 11/06/2019 November A?P Account: 122-60337-045-000 Account: 122-69005-045-000 254 11/14/2019 November A/P 254 11/14/2019 November A/P Insurance 21,000.00 Budgeted 218,004.00 Remaining 0 % Used Totals: 17,718.24 Remaining Transfer to Town/Fire Budget Fire admin november Transfer to Town/Fire Budget Totals: 718,657.00 Budgeted 598,880.84 Remaining Capital Outlays exhaust silencer -capital exhaust silencer -capital .00 .00 .00 .00 ** 1,640.88 1,640.88 3,281.76 GL 1,640.88 3,281.76 ** 16 % Used 59,888.08 59,888.08 119,776.16 TOWN OF TROPHY CLUB 5901 AP 17 % Used 59,888.08 119,776.16 ** 1,700.00 1,700.00 ACE Heating s Air Conditioning 5904 AP 1,050.00 2,750.00 Rossman Enterprises Inc 5915 AP Account: 122-69005-045-000 Capital Outlays Totals: 2,750.00 2,750.00 ** Account: 122-69009-045-000 48,000.00 Budgeted Short Term Debt -Interest 45,250.00 Remaining 6 % Used 11,958.24 .00 11,958.24 Account: 122-69009-045-000 Short Term Debt -Interest Totals: .00 11,958.24 ** .00 Budgeted (11,958.24) Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement Account: 122-69195-045-000 81,420.00 .00 81,420.00 GASB34/Reserve for Replacement Totals: .00 81,420.00 ** 81,420.00 Budgeted .00 Remaining 100 % Used Account: 122-69305-045-000 Capital Leases 36 of 140 glpdatb2 skrolczyk 16:38 12/09/19 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Department: 45 Fire JE Detail Description/Comment Trophy Club MUD No.1 Page 4 Detailed Accounting Trial Balance Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) 115,190.36 .00 115,190.36 Account: 122-69305-045-000 Capital Leases Totals: .00 115,190.36 ** 127,149.00 Budgeted 11,958.64 Remaining 91 % Used Department 45 Totals: 334,376.52 ** 64,278.96 Monthly Total 1,214,230.00 Budgeted 879,853.48 Remaining 28 % Used Fund 122 Totals: 258,116.96 2,243.00 Monthly Total .00 Budgeted (258,116.96) Remaining 0 % Used 37 of 140 TROPHY CLUB MUD #1 - O&M (GENERAL FUND) BALANCE SHEET NOVEMBER 2019 December 16, 2019 Regular Meeting Agenda Packet 135 137 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 2,983,393 2,983,393 CASH IN BANK -SAVINGS -CASH RESERVE 1,398,315 1,398,315 INVESTMENTS-TEXPOOL 4,202,332 919,266 5,121,598 PREPAID EXPENSES 93,355 93,355 ADVALOREM PROPERTY TAXES RECEIVABLE 131,786 131,786 UTILITY AND OTHER ACCOUNTS RECEIVABLE 845,820 845,820 TOTAL ASSETS 9,655,601 919,266 10,574,867 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 131,786 131,786 ACCOUNTS AND OTHER PAYABLES 843,081 843,081 CUSTOMER DEPOSITS 320,304 320,304 TOTAL LIABILITIES 1,295,171 1,295,171 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 (40,954) (40,954) TOTAL FUND BALANCE 8,360,430 919,266 9,279,696 TOTAL LIABILITIES AND FUND BALANCE 9,655,601 919,266 10,574,867 38 of 140 glbase_tbam skrolczyk 16:37 12/09/19 Fund: 135 MUD 1 General Fund Account 135-40000-000-000 135-40002-000-000 135-40015-000-000 135-40025-000-000 Description Property Taxes Property Taxes/Delinquent Property Taxes/P & i PID Surcharges Department: Adopted Budget 134,871.00- 300.00- 300.00- 164,253.00 - Trophy Club MUD No.1 Budget Summary with Amendment Revenues Period Ending: 11/2019 Amended Total Budget Encumb. 134,871.00- 300.00- 300.00- 164,253.00 - Current Month 6,665.28- 104.26- 120.35 - Program: YTD Total 8,388.52- 51.40 128.17 - Page 3 December 16, 2019 Regular Meeting Agenda Packet % of Budget 6.220 -17.133 42.723 Remaining Budget 126,482.48- 351.40- 171.83- 164,253.00 - Subtotal: 299,724.00- 299,724.00- 6,889.89- 8,465.29- 2.824 291,258.71- 135-47000-000-000 135-47005-000-000 135-47025-000-000 135-47030-000-000 135-47035-000-000 135-47045-000-000 135-47070-000-000 Water Sewer Penalties Service Charges Plumbing Inspections Sewer Inspections TCCC Effluent Charges 6,486,623.00- 3,503,885.00- 112,608.00- 15,150.00- 750.00- 2,500.00- 50,000.00- 6,486,623.00- 3,503,885.00- 112,608.00- 15,150.00- 750.00- 2,500.00- 50,000.00- 330,533.22- 255,418.37- 10,521.29- 2,150.00- 12.80- 866,912.50- 477,378.73- 20,502.72- 3,225.00- 1,800.00- 400.00- 15,048.80- 13.365 13.624 18.207 21.287 240.000 16.000 30.098 5,619,710.50- 3,026,506.27- 92,105.28- 11,925.00- 1,050.00 ,619,710.50-3,026,506.27-92,105.28- 11,925.00- 1,050.00 2,100.00- 34,951.20 - Subtotal: 10,171,516.00- 10,171,516.00- 598,635.68- 1,385,267.75- 13.619 8,786,248.25- 135-49011-000-000 135-49016-000-000 135-49018-000-000 135-49026-000-000 135-49075-000-000 Interest Income Cell Tower Revenue Buildir}p Rent Income Proceeds from Sale of Assets Oversize Meter Reimbursement 120,000.00- 14,146.00- 7,000.00- 13,000.00- 12,691.00- 120,000.00- 14,146.00- 7,000.00- 13,000.00- 12,691.00- 9,712.65- 1,178.81- 583.33- 21,478.43- 1,178.81- 1,166.66- 5,355.28- 17.899 8.333 16.667 42.197 98,521.57- 12,967.19- 5,833.34- 13,000.00- 7,335.72- 135-49900-000-000 Miscellaneous Income 7,000.00- 7,000.00- 228.85- 7,601.14- 108.588 601.14 Subtotal: 173,837.00- 173,837.00- 11,703.64- 36,780.32- 21.158 137,056.68 - Program number: 10,645,077.00- 10,645,077.00- 617,229.21- 1,430,513.36- 13.438 9,214,563.64 - Department number: Revenues 10,645,077.00- 10,645,077.00- 617,229.21- 1,430,513.36- 13.438 9,214,563.64 - Revenues Subtotal 10,645,077.00- 10,645,077.00- 617,229.21- 1,430,513.36- 13.438 9,214,563.64- 39 of 140 glbase_tbam skrolczyk 16:37 12/09/19 Fund: 135 MUD 1 General Fund Account 135-50005-010-000 135-50010-010-000 135-50016-010-000 135-50017-010-000 135-50020-010-000 135-50026-010-000 135-50027-010-000 135-50028-010-000 135-50029-010-000 135-50030-010-000 135-50035-010-000 135-50040-010-000 135-50045-010-000 135-50060-010-000 135-50070-010-000 Description Salaries & Wages Overtime Longevity Certification Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Pre-emp Physicals/Testing Employee Relations Department: Adopted Budget 350,267.00 17,000.00 3,920.00 5,400.00 34,863.00 84,326.00 4,725.00 767.00 3,132.00 23,348.00 5,461.00 1,080.00 11,850.00 400.00 300.00 10 Water Trophy Club MUD No.1 Page 4 Budget Summary with Amendment Period Ending: 11/2019 Total Encumb. Amended Budget 350,267.00 17,000.00 3,920.00 5,400.00 34,863.00 84,326.00 4,725.00 767.00 3,132.00 23,348.00 5,461.00 1,080.00 11,850.00 400.00 300.00 Current Month Program: YTD Total % of Budget December 16, 2019 Regular Meeting Agenda Packet 41,130.51 51,358.19 14.663 3,378.93 4,200.82 24.711 5,082.50 5,082.50 129.656 450.00 800.00 14.815 4,628.88 6,764.00 19.402 5,229.85 9,050.89 10.733 310.26 554.23 11.730 52.07 90.97 11.860 269.10 458.77 14.648 3,079.60 3,772.88 16.159 720.23 882.37 16.158 9.34 10.14 .939 771.49 1,542.98 13.021 Remaining Budget 298,908.81 12,799.18 1,162.50- 4,600.00 28,099.00 75,275.11 4,170.77 676.03 2,673.23 19,575.12 4,578.63 1,069.86 10,307.02 400.00 300.00 Subtotal: 546,839.00 546,839.00 65,112.76 84,568.74 15.465 462,270.26 135-55005-010-000 135-55080-010-000 135-55085-010-000 135-55090-010-000 135-55105-010-000 135-55120-010-000 135-55135-010-000 Engineering Maintenance & Repairs Generator Maint. and Repair Vehicle Maintenance Maintenance-Backhoe/SkidLoader Cleaning Services Lab Analysis 20,000.00 100,000.00 3,000.00 5,000.00 3,500.00 1,000.00 7,500.00 20,000.00 100,000.00 3,000.00 5,000.00 3,500.00 1,000.00 7,500.00 10,190.54 13,117.37 13.117 207.88 4.158 87.50 8.750 740.00 740.00 9.867 20,000.00 86,882.63 3,000.00 4,792.12 3,500.00 912.50 6,760.00 Subtotal: 140,000.00 140,000.00 10,930.54 14,152.75 10.109 125,847.25 135-60010-010-000 135-60020-010-000 135-60066-010-000 135-60070-010-000 135-60080-010-000 135-60090-010-000 135-60100-010-000 135-60105-010-000 135-60135-010-000 135-60150-010-000 135-60245-010-000 135-60280-010-000 135-60285-010-000 135-60332-010-000 135-60333-010-000 135-60334-010-000 Communications/Mobiles Electricity Publications/Books/Subscripts Dues & Memberships Schools & Training Safety Program Travel & per diem Rent/Lease Equipment TCEQ Fees & Permits Wholesale Water Miscellaneous Expenses Property Maintenance Lawn Equipment & Maintenance Interfund Transfer Out -Rev I&S Interfund Transfer Out -Reserve Interfund Transfer Out 5,000.00 125,677.00 1,000.00 500.00 7,426.00 400.00 2,845.00 1,500.00 63,000.00 2,714,710.00 200.00 3,000.00 14,750.00 527,381.00 55,193.00 180,000.00 5,000.00 125,677.00 1,000.00 500.00 7,426.00 400.00 2,845.00 1,500.00 63,000.00 2,714,710.00 200.00 3,000.00 14,750.00 527,381.00 55,193.00 180,000.00 40 of 140 875.01 1,239.17 24.783 11,423.51 26,144.51 20.803 14,207.15 220,912.63 47,943.74 4,600.00 295.00 3.973 14,207.15 22.551 220,912.63 8.138 462.00 15.400 95,887.48 18.182 9,200.00 16.669 3,760.83 99,532.49 1,000.00 500.00 7,131.00 400.00 2,845.00 1,500.00 48,792.85 2,493,797.37 200.00 2,538.00 14,750.00 431,493.52 45,993.00 180,000.00 glbase_tbam skrolczyk 16:37 12/09/19 Fund: 135 MUD 1 General Fund Account 135-60360-010-000 Subtotal: 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 Subtotal: 135-69005-010-000 135-69008-010-000 135-69009-010-000 135-69195-010-000 135-69281-010-000 Subtotal: Program number: Description Furniture/Equipment < $5000 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 Department: Adopted Budget 2,500.00 3,705,082.00 15,000.00 5,190.00 20,000.00 1,200.00 1,000.00 70,000.00 87,000.00 199,390.00 684,875.00 30,512.00 3,231.00 75,000.00 120,000.00 913,618.00 5,504,929.00 10 Water Trophy Club MUD No.1 Page 5 Budget Summary with Amendment Period Ending: 11/2019 Total Encumb. Amended Budget 2,500.00 3,705,082.00 15,000.00 5,190.00 20,000.00 1,200.00 1,000.00 70,000.00 87,000.00 199,390.00 684,875.00 30,512.00 3,231.00 75,000.00 120,000.00 913,618.00 5,504,929.00 41 of 140 Current Month 100.57 300,062.61 970.35 909.36 1,642.32 3,522.03 11,152.78 57,932.73 69,085.51 448,713.45 Program: YTD Total 100.57 368,448.51 1,743.83 1,729.35 3,331.56 8,875.28 15,680.02 29,804.38 75,000.00 57,932.73 162,737.11 645,587.13 December 16, 2019 Regular Meeting Agenda Packet % of Budget 4.023 9.944 11.626 33.321 16.658 12.679 7.864 4.352 100.000 48.277 17.812 11.727 Remaining Budget 2,399.43 3,336,633.49 13,256.17 3,460.65 16,668.44 1,200.00 1,000.00 61,124.72 87,000.00 183,709.98 655,070.62 30,512.00 3,231.00 62,067.27 750,880.89 4,859,341.87 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 6 16:37 12/09/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for DebAmber 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis for PID 2,000.00 2,000.00 Subtotal: 2,000.00 2,000.00 Program number: 1 Lab Analysis for PID 2,000.00 2,000.00 Department number: Water 5,506,929.00 5,506,929.00 42 of 140 80.00 80.00 80.00 80.00 4.000 80.00 4.000 80.00 448,793.45 645,667.13 4.000 11.725 1,920.00 1,920.00 1,920.00 4,861,261.87 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7 16:37 12/09/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 441,799.00 441,799.00 43,724.72 56,681.48 12.830 385,117.52 135-50010-020-000 Overtime 33,000.00 33,000.00 3,538.90 4,187.98 12.691 28,812.02 135-50016-020-000 Longevity 8,035.00 8,035.00 6,872.50 6,872.50 85.532 1,162.50 135-50017-020-000 Certification 9,000.00 9,000.00 625.00 1,250.00 13.889 7,750.00 135-50020-020-000 Retirement 45,531.00 45,531.00 5,065.41 7,920.39 17.396 37,610.61 135-50026-020-000 Medical Insurance 104,858.00 104,858.00 5,987.13 11,974.26 11.420 92,883.74 135-50027-020-000 Dental Insurance 5,817.00 5,817.00 358.15 716.30 12.314 5,100.70 135-50028-020-000 Vision Insurance 948.00 948.00 59.22 118.44 12.494 829.56 135-50029-020-000 Life Insurance & Other 4,500.00 4,500.00 341.99 679.13 15.092 3,820.87 135-50030-020-000 Social Security Taxes 30,494.00 30,494.00 3,251.71 4,055.67 13.300 26,438.33 135-50035-020-000 Medicare Taxes 7,132.00 7,132.00 760.48 948.49 13.299 6,183.51 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 1,260.00 135-50045-020-000 Workman's Compensation 15,373.00 15,373.00 1,110.20 2,220.40 14.444 13,152.60 135-50060-020-000 Pre-emp Physicals/Testing 400.00 400.00 400.00 135-50070-020-000 Employee Relations 300.00 300.00 300.00 Subtotal: 708,447.00 708,447.00 71,695.41 97,625.04 13.780 610,821.96 135-55005-020-000 Engineering 30,000.00 30,000.00 30,000.00 135-55070-020-000 Independent Labor 15,000.00 15,000.00 3,000.00 3,000.00 20.000 12,000.00 135-55080-020-000 Maintenance & Repairs 88,000.00 88,000.00 2,982.28 6,686.82 7.599 81,313.18 135-55081-020-000 Mainten & Re/Pairs Collections 10,000.00 10,000.00 6,351.91 14,277.16 142.772 4,277.16- 135-55085-020-000 Generator Maint. and Repair 10,000.00 10,000.00 10,000.00 135-55090-020-000 Vehicle Maintenance 4,000.00 4,000.00 115.46 162.48 4.062 3,837.52 135-55091-020-000 Veh Maintenance Collections 8,000.00 8,000.00 1,837.08 1,837.08 22.964 6,162.92 135-55105-020-000 Maintenance-Backhoe/SkidLoader 3,000.00 3,000.00 856.24- -28.541 3,856.24 135-55120-020-000 Cleaning Services 1,500.00 1,500.00 87.50 5.833 1,412.50 135-55125-020-000 Dumpster Services 100,000.00 100,000.00 7,433.18 12,239.42 12.239 87,760.58 135-55135-020-000 Lab Analysis 40,000.00 40,000.00 2,019.60 4,409.20 11.023 35,590.80 Subtotal: 309,500.00 309,500.00 23,739.51 41,843.42 13.520 267,656.58 135-60010-020-000 Communications/Mobiles 5,000.00 5,000.00 801.99 1,174.83 23.497 3,825.17 135-60020-020-000 Electricity 160,067.00 160,067.00 10,925.83 22,687.12 14.174 137,379.88 135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 200.00 135-60070-020-000 Dues & Memberships 300.00 300.00 300.00 135-60080-020-000 Schools & Training 4,990.00 4,990.00 333.53 1,173.53 23.518 3,816.47 135-60090-020-000 Safety Program 1,000.00 1,000.00 1,000.00 135-60100-020-000 Travel & per diem 1,545.00 1,545.00 356.71 356.71 23.088 1,188.29 135-60105-020-000 Rent/Lease Equipment 5,000.00 5,000.00 5,000.00 135-60125-020-000 Advertising 2,500.00 2,500.00 2,500.00 135-60135-020-000 TCEQ Fees & Permits 15,000.00 15,000.00 9,888.02 65.920 5,111.98 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 450.00 135-60280-020-000 Property Maintenance 5,000.00 5,000.00 5,000.00 43 of 140 glbase_tbam skrolczyk 16:37 12/09/19 Fund: 135 MUD 1 General Fund Account 135-60285-020-000 135-60331-020-000 135-60332-020-000 135-60333-020-000 135-60334-020-000 135-60360-020-000 Subtotal: 135-65005-020-000 135-65010-020-000 135-65030-020-000 135-65031-020-000 135-65035-020-000 135-65040-020-000 135-65045-020-000 Subtotal: 135-69005-020-000 135-69008-020-000 135-69009-020-000 135-69195-020-000 Description 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 Fuel & Lube Uniforms Chemicals Chemicals Collections Small Tools Safety E uipment Lab Supplies Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Subtotal: Program number: Department number: Wastewater Department: Adopted Budget 14,000.00 114,563.00 673,867.00 125,187.00 180,000.00 2,000.00 1,310,669.00 12,500.00 5,495.00 20,000.00 17,500.00 1,200.00 1,200.00 20,000.00 77,895.00 530,500.00 79,133.00 11,277.00 130,000.00 750,910.00 3,157,421.00 3,157,421.00 Trophy Club MUD No.1 Budget Summary with Amendment 20 Wastewater Period Ending: 11/2019 Amended Total Budget Encumb. 14,000.00 114,563.00 673,867.00 125,187.00 180,000.00 2,000.00 1,310,669.00 12,500.00 5,495.00 20,000.00 17,500.00 1,200.00 1,200.00 20,000.00 77,895.00 530,500.00 79,133.00 11,277.00 130,000.00 750,910.00 3,157,421.00 3,157,421.00 44 of 140 Current Month 10,414.81 61,260.10 5,750.00 190.00 90,032.97 906.43 2,111.52 569.00 4,994.00 995.32 9,576.27 84,803.30 84,803.30 279,847.46 279,847.46 Program: YTD Total % of Budget Page 8 December 16, 2019 Regular Meeting Agenda Packet 20,829.62 18.182 122,520.80 18.182 11,500.00 9.186 190.00 9.500 190,320.63 14.521 1,830.04 14.640 3,003.93 54.667 3,394.96 16.975 4,994.00 28.537 3,978.33 19.892 17,201.26 22.083 90,592.30 17.077 130,000.00 100.000 220,592.30 29.377 567,582.65 17.976 567,582.65 17.976 Remaining Budget 14,000.00 93,733.38 551,346.20 113,687.00 180,000.00 1,810.00 1,120,348.37 10,669.96 2,491.07 16,605.04 12,506.00 1,200.00 1,200.00 16,021.67 60,693.74 439,907.70 79,133.00 11,277.00 530,317.70 2,589,838.35 2,589,838.35 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 9 16:37 12/09/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Period Ending: 11/2019 Account Description Adopted Amended Total Current YTD % of Budget Budget Encumb. Month Total Budget Program: 135-50045-026-000 Subtotal: Workman's Compensation 30.00 30.00 30.00 30.00 135-60066-026-000 Publications/Books/Subscripts 150.00 135-60070-026-000 Dues & Memberships 750.00 135-60075-026-000 Meetings 1,300.00 135-60080-026-000 Schools & Training 4,000.00 135-60100-026-000 Travel & per diem 5,000.00 135-60245-026-000 Miscellaneous Expenses 2,000.00 Subtotal: 13,200.00 Program number: 13,230.00 Department number: Board of Directors 13,230.00 150.00 750.00 1,300.00 4,000.00 5,000.00 2,000.00 13,200.00 13,230.00 13,230.00 45 of 140 1.99 3.98 1.99 3.98 675.00 156.36 831.36 833.35 833.35 675.00 156.36 December 16, 2019 Regular Meeting Agenda Packet 13.267 Remaining Budget 26.02 13.267 26.02 90.000 12.028 831.36 6.298 835.34 835.34 6.314 6.314 150.00 75.00 1,143.64 4,000.00 5,000.00 2,000.00 12,368.64 12,394.66 12,394.66 glbase_tbam skrolczyk Trophy Club MUD No.1 16:37 12/09/19 Budget Summary with Amendment Page 10 Fund: 135 MUD 1 General Fund Department: 30 Administration Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 135-50010-030-000 135-50016-030-000 135-50020-030-000 135-50026-030-000 135-50027-030-000 135-50028-030-000 135-50029-030-000 135-50030-030-000 135-50035-030-000 135-50040-030-000 135-50045-030-000 135-50060-030-000 135-50070-030-000 Salaries & Wages Overtime Longevity Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Pre-emp Physicals/Testing Employee Relations 628,298.00 628,298.00 2,000.00 2,000.00 2,208.00 2,208.00 58,554.00 58,554.00 124,394.00 124,394.00 6,464.00 6,464.00 1,035.00 1,035.00 4,500.00 4,500.00 39,215.00 39,215.00 9,171.00 9,171.00 1,440.00 1,440.00 1,775.00 1,775.00 500.00 500.00 8,000.00 8,000.00 45,241.82 3.11 2,207.50 4,389.34 5,488.81 306.40 48.77 330.00 2,814.13 658.13 104.82 107.37 61,700.20 2,671.60 23,380.71 Subtotal: 887,554.00 887,554.00 135-55030-030-000 135-55070-030-000 135-55080-030-000 135-55085-030-000 135-55120-030-000 135-55160-030-000 135-55205-030-000 Software & Support Independent Labor Maintenance & Repairs Generator Maint. and Repair Cleaning Services Professional Outside Services Utility Billing Contract 134,681.00 134,681.00 135,000.00 135,000.00 15,000.00 15,000.00 10,000.00 10,000.00 10,000.00 10,000.00 65,600.00 65,600.00 9,000.00 9,000.00 58,807.67 9.360 569,490.33 3.11 .156 1,996.89 2,207.50 99.977 .50 7,149.98 12.211 51,404.02 10,977.62 8.825 113,416.38 612.80 9.480 5,851.20 97.54 9.424 937.46 622.42 13.832 3,877.58 3,596.13 9.170 35,618.87 841.04 9.171 8,329.96 1,440.00 209.64 11.811 1,565.36 500.00 286.22 3.578 7,713.78 85,411.67 9.623 802,142.33 68,197.45 23,380.71 515.00 869.06 582.15 50.636 17.319 3.433 8.691 6.468 66,483.55 111,619.29 14,485.00 10,000.00 9,130.94 65,600.00 8,417.85 Subtotal: 379,281.00 379,281.00 26,052.31 93,544.37 24.664 285,736.63 135-60005-030-000 135-60010-030-000 135-60020-030-000 135-60025-030-000 135-60035-030-000 135-60040-030-000 135-60050-030-000 135-60055-030-000 135-60066-030-000 135-60070-030-000 135-60075-030-000 135-60079-030-000 135-60080-030-000 135-60100-030-000 135-60110-030-000 135-60115-030-000 135-60125-030-000 Telephone Communications/Mobiles Electricity/Gas Water Postage Service Charges & Fees Bad Debt Expense Insurance Publications/Books/Subscripts Dues & Memberships Meetings Public Education Schools & Training Travel & per diem Physicals/Testing Elections 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 Advertising 2,500.00 2,500.00 46 of 140 1,487.98 238.02 56.40 49.43 7,222.85 6,998.39 35.18 126.45 195.00 36.30 2,967.78 476.04 123.18 1,776.04 14,270.78 12.533 11.901 8.212 5.920 21.300 13,996.78 16.663 200.00 35.18 476.20 972.71 128.08 43.01 43.01 3.333 8.795 7.937 14.200 3.613 20,712.22 3,523.96 6,879.00 1,376.82 28,223.96 52,729.22 1,500.00 70,003.22 1,000.00 5,800.00 364.82 5,523.80 5,877.29 3,416.92 200.00 43.01- 2,500.00 glbase_tbam skrolczyk 16:37 12/09/19 Fund: 135 MUD 1 General Fund Account Description 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 Trophy Club MUD No.1 Budget Summary with Amendment Department: 30 Administration Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Page 11 1,288.00 500.00 17,000.00 2,500.00 1,288.00 500.00 17,000.00 2,500.00 24.00 48.00 3.727 1,240.00 500.00 17,000.00 2,500.00 Subtotal: 266,342.00 266,342.00 16,513.01 35,513.78 13.334 230,828.22 135-65010-030-000 135-65055-030-000 135-65085-030-000 135-65090-030-000 135-65095-030-000 135-65105-030-000 Uniforms Hardware Office Supplies Printer Supplies & Maintenance Maintenance Supplies Printing 2,050.00 26,485.00 6,000.00 3,500.00 4,000.00 2,500.00 2,050.00 26,485.00 6,000.00 3,500.00 4,000.00 2,500.00 538.29 249.72 1,099.62 677.72 18.327 16.943 2,050.00 26,485.00 4,900.38 3,500.00 3,322.28 2,500.00 Subtotal: 44,535.00 44,535.00 788.01 1,777.34 3.991 42,757.66 135-69005-030-000 Capital Outlays 195,000.00 195,000.00 195,000.00 135-69170-030-000 Copier Lease Installments 4,000.00 4,000.00 239.52 493.36 12.334 3,506.64 Subtotal: 199,000.00 199,000.00 239.52 493.36 .248 198,506.64 Program number: 1,776,712.00 1,776,712.00 105,293.05 216,740.52 12.199 1,559,971.48 Department number: Administration 1,776,712.00 1,776,712.00 105,293.05 216,740.52 12.199 1,559,971.48 47 of 140 glbase_tbam skrolczyk 16:37 12/09/19 Fund: 135 MUD 1 General Fund Department: Account Description Adopted Budget Trophy Club MUD No.1 Page 12 Budget Summary with Amendment 39 Non Departmental Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 Amended Total Current YTD % of Remaining Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 135,000.00 135,000.00 25,504.93 135-55055-039-000 Auditing 33,800.00 33,800.00 10,150.00 135-55060-039-000 Appraisal 11,761.00 11,761.00 135-55065-039-000 Tax Admin Fees 4,000.00 4,000.00 Subtotal: 184,561.00 184,561.00 35,654.93 Program number: 184,561.00 184,561.00 35,654.93 Department number: Non Departmental 184,561.00 184,561.00 35,654.93 Expenditures Subtotal 10,638,853.00 10,638,853.00 870,422.24 Fund number: 135 MUD 1 General Fund 6,224.00- 6,224.00- 253,193.03 48 of 140 25,504.93 18.893 109,495.07 15,150.00 44.822 18,650.00 13.35- -.114 11,774.35 4,000.00 40,641.58 40,641.58 40,641.58 1,471,467.22 40,953.86 22.021 22.021 22.021 13.831 -657.999 143,919.42 143,919.42 143,919.42 9,167,385.78 47,177.86- glbase_tbam skrolczyk Trophy Club MUD No.l Page 13 16:37 12/09/19 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 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 Subtotal: 286,420.00- 286,420.00 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 49 of 140 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 5 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-40000-000-000 Property Taxes 363 11/01/2019 Property Taxes 364 11/04/2019 Property Taxes 365 11/05/2019 Property Taxes 366 11/06/2019 Property Taxes 367 11/07/2019 Property Taxes 368 11/08/2019 Property Taxes 369 11/12/2019 Property Taxes 370 11/13/2019 Property Taxes 371 11/14/2019 Property Taxes 372 11/15/2019 Property Taxes 373 11/18/2019 Property Taxes 374 11/19/2019 Property Taxes 375 11/20/2019 Property Taxes 376 11/21/2019 Property Taxes 377 11/22/2019 Property Taxes 378 11/25/2019 Property Taxes 379 11/26/2019 Property Taxes 380 11/27/2019 Property Taxes (1,723.24) (171.09) (401.67) (739.28) (288.70) (344.79) (629.04) (160.13) (743.92) (399.21) (164.79) (93.07) (382.13) (965.74) (214.85) (19.66) (404.84) (400.11) (142.26) (1,894.33) (2,296.00) (3,035.28) (3,323.98) (3,668.77) (4,297.81) (4,457.94) (5,201.86) (5,601.07) (5,765.86) (5,858.93) (6,241.06) (7,206.80) (7,421.65) (7,441.31) (7,846.15) (8,246.26) (8,388.52) GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 135-40000-000-000 Property Taxes Totals: (6,665.28) (8,388.52) ** (134,871.00) Budgeted (126,482.48) Remaining 6 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 363 11/01/2019 Property Taxes 366 11/06/2019 Property Taxes 374 11/19/2019 Property Taxes 377 11/22/2019 Property Taxes 380 11/27/2019 Property Taxes 155.66 (24.22) 131.44 GL (32.20) 99.24 GL (.39) 98.85 GL 1.91 100.76 GL (49.36) 51.40 GL Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (104.26) 51.40 ** (300.00) Budgeted (351.40) Remaining -17 % Used Account: 135-40015-000-000 Property Taxes/P & I 363 11/01/2019 Property Taxes 365 11/05/2019 Property Taxes 366 11/06/2019 Property Taxes 369 11/12/2019 Property Taxes 370 11/13/2019 Property Taxes 372 11/15/2019 Property Taxes 374 11/19/2019 Property Taxes (7.82) (5.33) (13.15) GL (.12) (13.27) GL (1.95) (15.22) GL (.12) (15.34) GL (.01) (15.35) GL (.11) (15.46) GL (.08) (15.54) GL 50 of 140 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 6 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 375 11/20/2019 Property Taxes 380 11/27/2019 Property Taxes (7.82) (101.81) (117.35) GL (10.82) (128.17) GL Account: 135-40015-000-000 Property Taxes/P & I Totals: (120.35) (128.17) ** (300.00) Budgeted (171.83) Remaining 43 6 Used Account: 135-40025-000-000 PID Surcharges .00 .00 Account: 135-40025-000-000 PID Surcharges Totals: .00 .00 ** (164,253.00) Budgeted (164,253.00) Remaining 0 % Used Account: 135-47000-000-000 Water 240 11/11/2019 UB 11/11/2019 Adjustments 331 11/14/2019 RFD-Miniates incorrect read 312 11/30/2019 UB 11/30/2019 Billing UB20191111-20191111 User: UB20191114-20191114 User: UB20191130-20191130 User: (536,379.28) 20.38 (536,358.90) UB 111.60 (536,247.30) UB (330,665.20) (866,912.50) UB Account: 135-47000-000-000 Water Totals: 1 (330,533.22) (866,912.50) ** (6,486,623.00) Budgeted (5,619,710.50) Remaining 13 % Used Account: 135-47005-000-000 Sewer 240 11/11/2019 UB 11/11/2019 Adjustments UB20191111-20191111 User: (221,960.36) 312 11/30/2019 UB 11/30/2019 Billing UB20191130-20191130 User: 34.15 (221,926.21) UB (255,452.52) (477,378.73) UB Account: 135-47005-000-000 Sewer Totals: 1 (255,418.37) (477,378.73) ** (3,503,885.00) Budgeted (3,026,506.27) Remaining 14 % Used Account: 135-47025-000-000 Penalties 246 11/12/2019 UB 11/12/2019 Penalty removal UB20191112-20191112 User: 283 11/20/2019 UB 11/20/2019 Penalty removal UB20191120-20191120 User: 288 11/21/2019 UB 11/21/2019 Penalties UB20191121-20191121 User: 293 11/25/2019 UB 11/25/2019 Penalty removal UB20191125-20191125 User: 302 11/26/2019 UB 11/26/2019 Penalty removal UB20191126-20191126 User: 305 11/26/2019 UB 11/26/2019 Penalty removal UB20191126-20191126 User: (9,981.43) 182.03 (9,799.40) UB 480.33 (9,319.07) UB (11,403.51) (20,722.58) UB 68.63 (20,653.95) UB 125.39 (20,528.56) UB 25.84 (20,502.72) UB Account: 135-47025-000-000 1 Penalties Totals: (10,521.29) (20,502.72) ** (112,608.00) Budgeted (92,105.28) Remaining 18 6 Used Account: 135-47030-000-000 Service Charges 51 of 140 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 7 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 247 11/01/2019 UB 11/01/2019 NSF Check 222 11/06/2019 Cut Offs -November 2019 282 11/18/2019 UB 11/18/2019 NSF check UB20191101-20191101 User: UB20191106-20191106 User: UB20191118-20191118 User: (1,075.00) (25.00) (1,100.00) UB (2,050.00) (3,150.00) UB (75.00) (3,225.00) UB Account: 135-47030-000-000 Service Charges Totals: (3,225.00) ** (15,150.00) Budgeted Account: 135-47035-000-000 Account: 135-47035-000-000 (11,925.00) Remaining 21 % Used Plumbing Inspections (1,800.00) .00 (1,800.00) Plumbing Inspections .00 (1,800.00) ** (750.00) Budgeted 1,050.00 Remaining 240 % Used Account: 135-47045-000-000 Sewer Inspections (400.00) .00 (400.00) Account: 135-47045-000-000 Sewer Inspections .00 (400.00) ** (2,500.00) Budgeted (2,100.00) Remaining 16 % Used Account: 135-47070-000-000 TCCC Effluent Charges 312 11/30/2019 UB 11/30/2019 Billing UB20191130-20191130 User: (15,036.00) Account: 135-47070-000-000 TCCC Effluent Charges Totals: (50,000.00) Budgeted (34,951.20) Remaining Account: 135-49011-000-000 Interest Income 348 11/30/2019 Bank Interest- November 348 11/30/2019 Bank Interest- November 348 11/30/2019 Bank Interest- November 384 11/30/2019 Prosperity Bank Interest Corr Interest from Savings/Checking 384 11/30/2019 Prosperity Bank Interest Corr Interest from Savings/Checking Account: 135-49011-000-000 (12.80) (15,048.80) UB 30 % Used (11,765.78) (12.80) (15,048.80) ** (1,064.21) (12,829.99) GL (1,075.00) (13,904.99) GL (7,573.44) (21,478.43) GL (10.79) (21,489.22) GL 10.79 (21,478.43) GL Interest Income Totals: (9,712.65) (21,478.43) ** (120,000.00) Budgeted Account: 135-49016-000-000 Cell Tower Revenue 347 11/12/2019 Cell Tower Rev AT&T November (98,521.57) Remaining 18 % Used 52 of 140 (1,178.81) (1,178.81) GL glpdatb2 skrolczyk 16:38 12/09/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 11/2019 Beginning Transaction Transaction Vendor_Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment Page 8 December 16, 2019 Regular Meeting Agenda Packet Check Source Number Department Totals: (7,000.00) Budgeted (617,229.21) Monthly Total 601.14 Remaining 109 % Used (1,430,513.36) ** (10,645,077.00) Budgeted (9,214,563.64) Remaining 13 % Used 53 of 140 Account: 135-49016-000-000 Cell Tower Revenue Totals: (1,178.81) (1,178.81) ** (14,146.00) Budgeted (12,967.19) Remaining 8 % Used Account: 135-49018-000-000 Building Rent Income 350 11/30/2019 Town Billed Invoices 1714-1717 AR 20191130-20191130 User: (583.33) (583.33) (1,166.66) AR Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (1,166.66) ** (7,000.00) Budgeted (5,833.34) Remaining 17 % 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 (5,355.28) .00 (5,355.28) Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: .00 (5,355.28) ** (12,691.00) Budgeted (7,335.72) Remaining 42 % Used Account: 135-49900-000-000 Miscellaneous Income 312 11/30/2019 UB 11/30/2019 Billing UB20191130-20191130 User: UB (7,372.29) (228.85) (7,601.14) Account: 135-49900-000-000 Miscellaneous Income Totals: (228.85) (7,601.14) ** Department Totals: (7,000.00) Budgeted (617,229.21) Monthly Total 601.14 Remaining 109 % Used (1,430,513.36) ** (10,645,077.00) Budgeted (9,214,563.64) Remaining 13 % Used 53 of 140 glpdatb2 skrolczyk 16:38 12/09/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Period Ending: 11/2019 JE Detail Beginning Balance Description/Comment Program: Page 9 December 16, 2019 Regular Meeting Agenda Packet Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Check Source Number 134 11/01/2019 MUD Payroll 11/01/19 241 11/15/2019 MUD Payroll 11/15/2019 276 11/22/2019 MUD Payroll 11/22/19 298 11/27/2019 MUD Payroll 11/27/19 Retirement Retirement Retirement Retirement 2,135.12 1,260.61 1,423.21 470.14 1,474.92 3,395.73 4,818.94 5,289.08 6,764.00 PR PR PR PR Account: 135-50020-010-000 Retirement Totals: 4,628.88 6,764.00 ** 34,863.00 Budgeted 28,099.00 Remaining 19 % Used Account: 135-50026-010-000 Medical Insurance 54 of 140 Account: 135-50005-010-000 Salaries & Wages 134 11/01/2019 MUD Payroll 241 11/15/2019 MUD Payroll 298 11/27/2019 MUD Payroll 11/01/19 Salaries 11/15/2019 Salaries 11/27/19 Salaries & Wages & Wages & Wages 10,227.68 12,896.59 13,915.33 14,318.59 23,124.27 37,039.60 51,358.19 PR PR PR Account: 135-50005-010-000 Salaries & Wages Totals: 41,130.51 51,358.19 ** 350,267.00 Budgeted 298,908.81 Remaining 15 % Used Account: 135-50010-010-000 ' Overtime 134 11/01/2019 MUD Payroll 241 11/15/2019 MUD Payroll 298 11/27/2019 MUD Payroll 11/01/19 Overtime 11/15/2019 Overtime 11/27/19 Overtime 821.89 731.69 1,020.71 1,626.53 1,553.58 2,574.29 4,200.82 PR PR PR Account: 135-50010-010-000 ' Overtime Totals: 3,378.93 4,200.82 ** 17,000.00 Budgeted 12,799.18 Remaining 25 % Used Account: 135-50016-010-000 Longevity 276 11/22/2019 MUD Payroll 11/22/19 Longevity 5,082.50 5,082.50 PR Account: 135-50016-010-000 Longevity Totals: 5,082.50 5,082.50 ** 3,920.00 Budgeted (1,162.50) Remaining 130 % Used Account: 135-50017-010-000 Certification 241 11/15/2019 MUD Payroll 11/15/2019 Certification 350.00 450.00 800.00 PR Account: 135-50017-010-000 Certification Totals: 450.00 800.00 ** 5,400.00 Budgeted 4,600.00 Remaining 15 % Used Account: 135-50020-010-000 Retirement 134 11/01/2019 MUD Payroll 11/01/19 241 11/15/2019 MUD Payroll 11/15/2019 276 11/22/2019 MUD Payroll 11/22/19 298 11/27/2019 MUD Payroll 11/27/19 Retirement Retirement Retirement Retirement 2,135.12 1,260.61 1,423.21 470.14 1,474.92 3,395.73 4,818.94 5,289.08 6,764.00 PR PR PR PR Account: 135-50020-010-000 Retirement Totals: 4,628.88 6,764.00 ** 34,863.00 Budgeted 28,099.00 Remaining 19 % Used Account: 135-50026-010-000 Medical Insurance 54 of 140 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 134 11/01/2019 MUD Payroll 11/01/19 Medical Insurance 3,821.04 241 11/15/2019 MUD Payroll 11/15/2019 Medical Insurance 2,614.96 6,436.00 PR 2,614.89 9,050.89 PR Account: 135-50026-010-000 Medical Insurance Totals: 5,229.85 9,050.89 ** 84,326.00 Budgeted 75,275.11 Remaining 11 % Used Account: 135-50027-010-000 ' Dental Insurance 134 11/01/2019 MUD Payroll 11/01/19 Dental Insurance 241 11/15/2019 MUD Payroll 11/15/2019 Dental Insurance 243.97 155.16 399.13 PR 155.10 554.23 PR Account: 135-50027-010-000 Dental Insurance Totals: 310.26 554.23 ** 4,725.00 Budgeted 4,170.77 Remaining 12 % Used Account: 135-50028-010-000 Vision Insurance 134 11/01/2019 MUD Payroll 11/01/19 Vision Insurance 241 11/15/2019 MUD Payroll 11/15/2019 Vision Insurance 38.90 26.06 64.96 PR 26.01 90.97 PR Account: 135-50028-010-000 _ Vision Insurance Totals: 52.07 90.97 ** 767.00 Budgeted 676.03 Remaining 12 % Used Account: 135-50029-010-000 11111 Life Insurance & Other 216 11/01/2019 Payroll Benefits November 216 11/01/2019 Payroll Benefits November 318 11/30/2019 November A/P Employee LTD & STD Employee Benefits caf 125 -October 189.67 123.66 313.33 METLIFE GROUP BENEFITS 125.44 438.77 Humana Inc 20.00 458.77 BenefitMall 5896 AP 5891 AP 5923 AP Account: 135-50029-010-000 Life Insurance & Other Totals: 269.10 458.77 ** 3,132.00 Budgeted 2,673.23 Remaining 15 % Used Account: 135-50030-010-000 Social Security Taxes 134 11/01/2019 MUD Payroll 11/01/19 241 11/15/2019 MUD Payroll 11/15/2019 276 11/22/2019 MUD Payroll 11/22/19 298 11/27/2019 MUD Payroll 11/27/19 Social Security Taxes Social Security Taxes Social Security Taxes Social Security Taxes 693.28 834.35 1,527.63 PR 940.23 2,467.86 PR 315.11 2,782.97 PR 989.91 3,772.88 PR Account: 135-50030-010-000 Social Security Taxes Totals: 3,079.60 3,772.88 ** 23,348.00 Budgeted 19,575.12 Remaining 16 % Used Account: 135-50035-010-000 Medicare Taxes 55 of 140 glpdatb2 skrolczyk Trophy Club MUD No.1 16:38 12/09/19 Detailed Accounting Trial Balance Page 11 Fund: 135 MUD 1 General Fund Department: 10 Water Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 134 11/01/2019 MUD Payroll 11/01/19 241 11/15/2019 MUD Payroll 11/15/2019 276 11/22/2019 MUD Payroll 11/22/19 298 11/27/2019 MUD Payroll 11/27/19 Medicare Taxes Medicare Taxes Medicare Taxes Medicare Taxes 162.14 195.12 219.90 73.69 231.52 357.26 577.16 650.85 882.37 PR PR PR PR Account: 135-50035-010-000 - Medicare Taxes Totals: 720.23 882.37 ** 5,461.00 Budgeted 4,578.63 Remaining 16 % Used Account: 135-50040-010-000 ' Unemployment Taxes 134 11/01/2019 241 11/15/2019 298 11/27/2019 MUD Payroll 11/01/19 Unemployment Taxes MUD Payroll 11/15/2019 Unemployment Taxes MUD Payroll 11/27/19 Unemployment Taxes .80 2.28 3.19 3.87 3.08 6.27 10.14 PR PR PR Account: 135-50040-010-000 ' Unemployment Taxes Totals: 9.34 10.14 ** 1,080.00 Budgeted 1,069.86 Remaining 1 % Used Account: 135-50045-010-000 Workman's Compensation 67 11/01/2019 Insurance/Wrk Comp Expense Nov 771.49 771.49 1,542.98 GL Account: 135-50045-010-000 Workman's Compensation Totals: 771.49 1,542.98 ** 11,850.00 Budgeted 10,307.02 Remaining 13 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing .00 .00 Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 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: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-55005-010-000 Engineering .00 .00 Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 20,000.00 Budgeted 20,000.00 Remaining 0 % Used 56 of 140 glpdatb2 skrolczyk 16:38 12/09/19 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Account: 135-55080-010-000 231 11/07/2019 November A/P 231 11/07/2019 November A/P 359 11/26/2019 PCards 359 11/26/2019 PCards 359 11/26/2019 PCards 359 11/26/2019 PCards 359 11/26/2019 PCards Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Period Ending: 11/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Detail Page 12 December 16, 2019 Regular Meeting Agenda Packet Transaction Vendor_Name Detail (SUBTOTAL) Check Source Number Maintenance & Repairs water plant gate parts Sprinkler Check/Repair Multch for Customer Repiar Sprinkler Check/Repair Turf Customer Repair Sharkbite Elbow and Adapter Well 61 emergency repair meter boxes hydrant parts parts 10/29/19 10/29/19 10/29/19 10/29/19 10/29/19 318 11/30/2019 November A/P 318 11/30/2019 November A/P 318 11/30/2019 November A/P 318 11/30/2019 November A/P Account: 135-55080-010-000 Account: 135-55085-010-000 Account: 135-55085-010-000 Account: 135-55090-010-000 Account: 135-55090-010-000 - 11/26/19 - 11/26/19 - 11/26/19 - 11/26/19 - 11/26/19 Maintenance & Repairs Totals: 100,000.00 Budgeted 86,882.63 Remaining Generator Maint. and Repair Generator Maint. and Repair Totals: 3,000.00 Budgeted 3,000.00 Remaining Vehicle Maintenance Vehicle Maintenance Totals: 5,000.00 Budgeted 4,792.12 Remaining 2,926.83 207.88 13 % Used 0 % Used 4 % Used 1,178.00 4,104.83 257.50 4,362.33 490.50 4,852.83 3.75 4,856.58 490.50 5,347.08 29.25 5,376.33 75.74 5,452.07 5,946.00 11,398.07 1,477.80 12,875.87 37.50 12,913.37 204.00 13,117.37 10,190.54 .00 .00 .00 .00 Alan's Gates, Inc. Core & Main LP ARS RR FT WORTH 9127 THE HOME DEPOT 66581 ARS RR FT WORTH 9127 TEX-TURF THE HOME DEPOT 66581 DHS AUTOMATION, INC Core & Main LP Core & Main LP Core & Main LP 13,117.37 ** .00 .00 ** 207.88 207.88 ** 5881 AP 5884 AP PC PC PC PC PC 5930 AP 5928 AP 5928 AP 5928 AP Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: 3,500.00 Budgeted 3,500.00 Remaining 0 % Used .00 .00 .00 .00 ** Account: 135-55120-010-000 Cleaning Services Account: 135-55120-010-000 Cleaning Services 1,000.00 Budgeted 87.50 .00 Totals: 912.50 Remaining 9 o Used 57 of 140 .00 87.50 87.50 ** glpdatb2 skrolczyk Trophy Club MUD No.1 Page 13 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55135-010-000 254 11/14/2019 November A/P 318 11/30/2019 November A/P Lab Analysis water samples Lead & copper sampling 140.00 140.00 TARRANT CTY PUBLIC HEALTH LAB 5916 AP 600.00 740.00 Centralized Water & Wastewater 5925 AP Account: 135-55135-010-000 Lab Analysis Totals: 740.00 740.00 ** 7,500.00 Budgeted 6,760.00 Remaining 10 % Used Account: 135-60010-010-000 Communications/Mobiles 254 11/14/2019 November A/P cell phones -november 359 11/26/2019 PCards 10/29/19 - 11/26/19 screen protectors 364.16 865.02 1,229.18 VERIZON WIRELESS 5920 AP 9.99 1,239.17 AMZN MKTP US*J16PNOT63 PC Account: 135-60010-010-000 Communications/Mobiles Totals: 875.01 1,239.17 ** Account: 135-60020-010-000 318 11/30/2019 November A/P Account: 135-60020-010-000 Account: 135-60066-010-000 5,000.00 Budgeted 3,760.83 Remaining 25 % Used Electricity electricity 10/10-11/8 14,721.00 11,423.51 26,144.51 HUDSON ENERGY SERVICES, LLC 5936 AP Electricity Totals: 11,423.51 26,144.51 ** 125,677.00 Budgeted 99,532.49 Remaining 21 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 Publications/Books/Subscripts Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 6 Used Account: 135-60070-010-000 Dues & Memberships .00 .00 Account: 135-60070-010-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60080-010-000 Schools & Training 295.00 .00 295.00 Account: 135-60080-010-000 Schools & Training Totals: .00 295.00 ** 7,426.00 Budgeted 7,131.00 Remaining 4 % Used 58 of 140 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 14 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60090-010-000 Safety Program Account: 135-60090-010-000 Account: 135-60100-010-000 Account: 135-60100-010-000 Account: 135-60105-010-000 Account: 135-60105-010-000 Account: 135-60135-010-000 254 11/14/2019 November A/P 318 11/30/2019 November A/P Safety Program 400.00 Budgeted Travel & per diem Travel & per diem 2,845.00 Budgeted Rent/Lease Equipment Rent/Lease Equipment 1,500.00 Budgeted Account: 135-60135-010-000 Account: 135-60150-010-000 318 11/30/2019 November A/P Totals: 400.00 Remaining 0 6 Used Totals: 2,845.00 Remaining .00 .00 .00 .00 ** .00 0 % Used .00 .00 n= .00 .00 Totals: 1,500.00 Remaining 0 6 Used TCEQ Fees & Permits well water Water system Fee TCEQ .00 5,752.20 5,752.20 North Texas Groundwater 5913 AP 8,454.95 14,207.15 TX COMMISSION ENVIRONMENTAL QU 5951 AP TCEQ Fees & Permits Totals: 14,207.15 14,207.E 63,000.00 Budgeted Wholesale Water wholesale water 48,792.85 Remaining 23 % Used 220,912.63 220,912.63 CITY OF FORT WORTH 5926 AP Account: 135-60150-010-000 Wholesale Water Totals: 220,912.63 220,912.63 ** 2,714,710.00 Budgeted Account: 135-60245-010-000 Miscellaneous Expenses Account: 135-60245-010-000 Miscellaneous Expenses 200.00 Budgeted 2,493,797.37 Remaining 8 6 Used Totals: 200.00 Remaining 0 6 Used .00 .00 .00 .00 ** Account: 135-60280-010-000 Property Maintenance 59 of 140 glpdatb2 skrolczyk 16:38 12/09/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Period Ending: 11/2019 JE Detail Beginning Balance Description/Comment 462.00 Program: Page 15 December 16, 2019 Regular Meeting Agenda Packet Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) .00 462.00 Check Source Number 60 of 140 Account: 135-60280-010-000 Property Maintenance Totals: .00 462.00 ** 3,000.00 Budgeted 2,538.00 Remaining 15 5 Used Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 14,750.00 Budgeted 14,750.00 Remaining 0 % Used Account: 135-60332-010-000 Interfund Transfer Out -Rev I&S 346 11/15/2019 TexPool Transfers November TexPool O&M to 16Swift Rev I&S 346 11/15/2019 TexPool Transfers November TexPool O&M to 19 W&WW Rev I&S 47,943.74 25,047.72 22,896.02 72,991.46 95,887.48 GL GL Account: 135-60332-010-000 Interfund Transfer Out -Rev I&S Totals: 47,943.74 95,887.48 ** 527,381.00 Budgeted 431,493.52 Remaining 18 % Used Account: 135-60333-010-000 Interfund Transfer Out -Reserve 346 11/15/2019 TexPool Transfers November TexPool O&M to Rev Bond Resevr 4,600.00 4,600.00 9,200.00 GL Account: 135-60333-010-000 Interfund Transfer Out -Reserve Totals: 4,600.00 9,200.00 ** 55,193.00 Budgeted 45,993.00 Remaining 17 % Used Account: 135-60334-010-000 Interfund Transfer Out .00 .00 Account: 135-60334-010-000 Interfund Transfer Out Totals: .00 .00 ** 180,000.00 Budgeted 180,000.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 359 11/26/2019 PCards 10/29/19 - 11/26/19 hanging clamps 100.57 100.57 AMZN MKTP US*PK4EH4DP3 PC Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: 100.57 100.57 ** 2,500.00 Budgeted 2,399.43 Remaining 4 % Used Account: 135-65005-010-000 Fuel & Lube 60 of 140 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 352 11/24/2019 Fuel -November Fuel -Nov 773.48 970.35 1,743.83 US Bank Voyager Fleet Systems 5985 AP Account: 135-65005-010-000 Fuel & Lube Totals: 970.35 1,743.83 ** 15,000.00 Budgeted 13,256.17 Remaining 12 % Used Account: 135-65010-010-000 Uniforms 359 11/26/2019 PCards 10/29/19 - 11/26/19 shoes 359 11/26/2019 PCards 10/29/19 - 11/26/19 pants 359 11/26/2019 PCards 10/29/19 - 11/26/19 pants 359 11/26/2019 PCards 10/29/19 - 11/26/19 Uniforms Water 359 11/26/2019 PCards 10/29/19 - 11/26/19 Uniforms Water 819.99 166.49 986.48 RED WING SHOES #573 PC 291.97 1,278.45 AMAZON.COM*AX75E74Y3 PC 160.93 1,439.38 AMAZON.COM*SOODX8NS3 PC 179.98 1,619.36 TRACTOR SUPPLY COMPANY PC 109.99 1,729.35 TRACTOR SUPPLY COMPANY PC Account: 135-65010-010-000 Uniforms Totals: 909.36 1,729.35 ** 5,190.00 Budgeted 3,460.65 Remaining 33 o Used Account: 135-65030-010-000 Chemicals 318 11/30/2019 November A/P 318 11/30/2019 November A/P 318 11/30/2019 November A/P 356 11/30/2019 November A/P testing supplies testing supplies chlorine ammonia 1,689.24 287.77 1,977.01 HACH COMPANY 539.90 2,516.91 HACH COMPANY 335.05 2,851.96 DPC INDUSTRIES, INC 479.60 3,331.56 Valley Solvent Company, INC 5933 AP 5933 AP 5931 AP 5986 AP Account: 135-65030-010-000 Chemicals Totals: 1,642.32 3,331.56 ** 20,000.00 Budgeted 16,668.44 Remaining 17 % 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 9 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 8,875.28 .00 8,875.28 61 of 140 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65050-010-000 Account: 135-65053-010-000 Account: 135-65053-010-000 Account: 135-69005-010-000 231 11/07/2019 November A/P 254 11/14/2019 November A/P 318 11/30/2019 November A/P 356 11/30/2019 November A/P Meter Expense Totals: 70,000.00 Budgeted Meter Change Out Program 61,124.72 Remaining 13 % Used Meter Change Out Program Totals: 87,000.00 Budgeted 87,000.00 Remaining Capital Outlays beacon software 16" water line Sundance & meadowbrook meadowbrook s sundance Account: 135-69005-010-000 Capital Outlays 684,875.00 Budgeted 18,651.60 O % Used .00 8,875.28 ** .00 .00 .00 .00 ** 5,472.00 3,055.78 2,025.00 600.00 24,123.60 BADGER METER, INC 27,179.38 Halff Associates, INC 29,204.38 Jackson Construction, LTD 29,804.38 TEAGUE, NALL S PERKINS,INC 5883 AP 5908 AP 5938 AP 5982 AP 11,152.78 29,804.38 ** 655,070.62 Remaining 4 6 Used Account: 135-69008-010-000 Short Term Debt -Principal .00 .00 Account: 135-69008-010-000 Short Term Debt -Principal Totals: .00 .00 ** 30,512.00 Budgeted 30,512.00 Remaining O % Used Account: 135-69009-010-000 Short Term Debt -Interest .00 .00 Account: 135-69009-010-000 Short Term Debt -Interest Totals: 3,231.00 Budgeted 3,231.00 Remaining Account: 135-69195-010-000 Gasb34/Reserve for Replacement Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: 75,000.00 Budgeted .00 Remaining O % Used 75,000.00 100 % Used .00 75,000.00 Account: 135-69281-010-000 Water Tank Inspection Contract 62 of 140 glpdatb2 skrolczyk 16:38 12/09/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Page 18 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 11/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment 231 11/07/2019 November A/P Tank contract December 16, 2019 Regular Meeting Agenda Packet 57,932.73 57,932.73 UTILITY SERVICE CO, INC. 5903 AP Account: 135-69281-010-000 Water Tank Inspection Contract Totals: 57,932.73 57,932.73 120,000.00 Budgeted 62,067.27 Remaining 48 % Used 63 of 140 glpdatb2 skrolczyk 16:38 12/09/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Department: 10 Water JE Detail Description/Comment Account: 135-55135-010-001 Lab Analysis for PID 254 11/14/2019 November A/P water samples Account: 135-55135-010-001 Department 10 Totals: Trophy Club MUD No.1 Page 19 Detailed Accounting Trial Balance Program: 1 Lab Analysis for "December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Lab Analysis for PID Totals: 2,000.00 Budgeted 1,920.00 Remaining 4 % Used 80.00 80.00 TARRANT CTY PUBLIC HEALTH LAB 5916 AP 80.00 80.00 ** 645,667.13 ** 448,793.45 Monthly Total 5,506,929.00 Budgeted 4,861,261.87 Remaining 12 % Used 64 of 140 glpdatb2 skrolczyk 16:38 12/09/19 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: 11/2019 JE Detail Beginning Balance Description/Comment Program: Page 20 December 16, 2019 Regular Meeting Agenda Packet Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Check Source Number 134 11/01/2019 MUD Payroll 11/01/19 241 11/15/2019 MUD Payroll 11/15/2019 276 11/22/2019 MUD Payroll 11/22/19 298 11/27/2019 MUD Payroll 11/27/19 Retirement Retirement Retirement Retirement 2,854.98 1,510.53 1,486.46 635.72 1,432.70 4,365.51 5,851.97 6,487.69 7,920.39 PR PR PR PR Account: 135-50020-020-000 Retirement Totals: 5,065.41 7,920.39 ** 45,531.00 Budgeted 37,610.61 Remaining 17 % Used Account: 135-50026-020-000 Medical Insurance 65 of 140 Account: 135-50005-020-000 Salaries & Wages 134 11/01/2019 MUD Payroll 241 11/15/2019 MUD Payroll 298 11/27/2019 MUD Payroll 11/01/19 Salaries 11/15/2019 Salaries 11/27/19 Salaries & Wages & Wages & Wages 12,956.76 14,635.56 14,544.58 14,544.58 27,592.32 42,136.90 56,681.48 PR PR PR Account: 135-50005-020-000 Salaries & Wages Totals: 43,724.72 56,681.48 ** 441,799.00 Budgeted 385,117.52 Remaining 13 % Used Account: 135-50010-020-000 ' Overtime 134 11/01/2019 MUD Payroll 241 11/15/2019 MUD Payroll 298 11/27/2019 MUD Payroll 11/01/19 Overtime 11/15/2019 Overtime 11/27/19 Overtime 649.08 1,694.42 900.40 944.08 2,343.50 3,243.90 4,187.98 PR PR PR Account: 135-50010-020-000 ' Overtime Totals: 3,538.90 4,187.98 ** 33,000.00 Budgeted 28,812.02 Remaining 13 % Used Account: 135-50016-020-000 Longevity 276 11/22/2019 MUD Payroll 11/22/19 Longevity 6,872.50 6,872.50 PR Account: 135-50016-020-000 Longevity Totals: 6,872.50 6,872.50 ** 8,035.00 Budgeted 1,162.50 Remaining 86 % Used Account: 135-50017-020-000 Certification 241 11/15/2019 MUD Payroll 11/15/2019 Certification 625.00 625.00 1,250.00 PR Account: 135-50017-020-000 Certification Totals: 625.00 1,250.00 ** 9,000.00 Budgeted 7,750.00 Remaining 14 % Used Account: 135-50020-020-000 Retirement 134 11/01/2019 MUD Payroll 11/01/19 241 11/15/2019 MUD Payroll 11/15/2019 276 11/22/2019 MUD Payroll 11/22/19 298 11/27/2019 MUD Payroll 11/27/19 Retirement Retirement Retirement Retirement 2,854.98 1,510.53 1,486.46 635.72 1,432.70 4,365.51 5,851.97 6,487.69 7,920.39 PR PR PR PR Account: 135-50020-020-000 Retirement Totals: 5,065.41 7,920.39 ** 45,531.00 Budgeted 37,610.61 Remaining 17 % Used Account: 135-50026-020-000 Medical Insurance 65 of 140 glpdatb2 skrolczyk 16:38 12/09/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 134 11/01/2019 MUD Payroll 11/01/19 241 11/15/2019 MUD Payroll 11/15/2019 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 JE Detail Beginning Transaction Transaction Vendor_Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 21 Medical Insurance Medical Insurance 5,987.13 2,993.58 2,993.55 8,980.71 11,974.26 PR PR 134 11/01/2019 MUD Payroll 11/01/19 241 11/15/2019 MUD Payroll 11/15/2019 276 11/22/2019 MUD Payroll 11/22/19 298 11/27/2019 MUD Payroll 11/27/19 Social Security Taxes Social Security Taxes Social Security Taxes Social Security Taxes 803.96 952.88 909.83 426.08 962.92 1,756.84 2,666.67 3,092.75 4,055.67 PR PR PR PR Account: 135-50030-020-000 Social Security Taxes Totals: 3,251.71 4,055.67 ** 30,494.00 Budgeted 26,438.33 Remaining 13 % Used Account: 135-50035-020-000 Medicare Taxes 66 of 140 Account: 135-50026-020-000 Medical Insurance Totals: 5,987.13 11,974.26 ** 104,858.00 Budgeted 92,883.74 Remaining 11 % Used Account: 135-50027-020-000 ' Dental Insurance 134 11/01/2019 MUD Payroll 11/01/19 Dental Insurance 241 11/15/2019 MUD Payroll 11/15/2019 Dental Insurance 358.15 179.09 179.06 537.24 716.30 PR PR Account: 135-50027-020-000 Dental Insurance Totals: 358.15 716.30 ** 5,817.00 Budgeted 5,100.70 Remaining 12 % Used Account: 135-50028-020-000 Vision Insurance 134 11/01/2019 MUD Payroll 11/01/19 Vision Insurance 241 11/15/2019 MUD Payroll 11/15/2019 Vision Insurance 59.22 29.62 29.60 88.84 118.44 PR PR Account: 135-50028-020-000 11111 Vision Insurance Totals: 59.22 118.44 ** 948.00 Budgeted 829.56 Remaining 12 8 Used Account: 135-50029-020-000 Life Insurance & Other 216 11/01/2019 Payroll Benefits November Employee LTD & STD 216 11/01/2019 Payroll Benefits November Employee Benefits 318 11/30/2019 November A/P caf 125 -October 337.14 157.87 148.12 36.00 495.01 643.13 679.13 METLIFE GROUP BENEFITS Humana Inc BenefitMall 5896 5891 5923 AP AP AP Account: 135-50029-020-000 Life Insurance & Other Totals: 341.99 679.13 ** 4,500.00 Budgeted 3,820.87 Remaining 15 % Used Account: 135-50030-020-000 Social Security Taxes 134 11/01/2019 MUD Payroll 11/01/19 241 11/15/2019 MUD Payroll 11/15/2019 276 11/22/2019 MUD Payroll 11/22/19 298 11/27/2019 MUD Payroll 11/27/19 Social Security Taxes Social Security Taxes Social Security Taxes Social Security Taxes 803.96 952.88 909.83 426.08 962.92 1,756.84 2,666.67 3,092.75 4,055.67 PR PR PR PR Account: 135-50030-020-000 Social Security Taxes Totals: 3,251.71 4,055.67 ** 30,494.00 Budgeted 26,438.33 Remaining 13 % Used Account: 135-50035-020-000 Medicare Taxes 66 of 140 glpdatb2 skrolczyk Trophy Club MUD No.1 16:38 12/09/19 Detailed Accounting Trial Balance Page 22 Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 134 11/01/2019 MUD Payroll 11/01/19 241 11/15/2019 MUD Payroll 11/15/2019 276 11/22/2019 MUD Payroll 11/22/19 298 11/27/2019 MUD Payroll 11/27/19 Medicare Taxes Medicare Taxes Medicare Taxes Medicare Taxes 188.01 222.85 212.77 99.65 225.21 410.86 623.63 723.28 948.49 PR PR PR PR Account: 135-50035-020-000 Medicare Taxes Totals: 760.48 948.49 ** 7,132.00 Budgeted 6,183.51 Remaining 13 % Used Account: 135-50040-020-000 Unemployment Taxes ' .00 .00 Account: 135-50040-020-000 Unemployment Taxes Totals: 1111=.00 ** 1,260.00 Budgeted 1,260.00 Remaining 0 % Used Account: 135-50045-020-041 Workman's Compensation 67 11/01/2019 Insurance/Wrk Comp Expense Nov 1,110.20 1,110.20 2,220.40 GL Account: 135-50045-020-000 Workman's Compensation Totals: 1,110.20 2,220.40 ** 15,373.00 Budgeted 13,152.60 Remaining 14 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing .00 .00 Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-50070-020-000 Employee Relations .00 .00 Account: 135-50070-020-000 Employee Relations Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-55005-020-000 Engineering .00 .00 Account: 135-55005-020-000 Engineering Totals: .00 .00 ** 30,000.00 Budgeted 30,000.00 Remaining 0 % Used 67 of 140 glpdatb2 skrolczyk 16:38 12/09/19 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: 11/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Detail Page 23 December 16, 2019 Regular Meeting Agenda Packet Transaction Vendor_Name Detail (SUBTOTAL) Check Source Number Account: 135-55070-020-000 Independent Labor 318 11/30/2019 November A/P Huber contract 3,000.00 3,000.00 Huber Technology Inc 5935 AP Account: 135-55070-020-000 Independent Labor Totals: 3,000.00 3,000.00 ** 15,000.00 Budgeted 12,000.00 Remaining 20 % Used Account: 135-55080-020-000 Maintenance & Repairs 359 11/26/2019 359 11/26/2019 359 11/26/2019 359 11/26/2019 359 11/26/2019 359 11/26/2019 359 11/26/2019 359 11/26/2019 318 11/30/2019 318 11/30/2019 356 11/30/2019 356 11/30/2019 PCards PCards PCards PCards PCards PCards PCards 10/29/19 10/29/19 10/29/19 10/29/19 10/29/19 10/29/19 10/29/19 PCards 10/29/19 November A/P November A/P November A/P November A/P - 11/26/19 - 11/26/19 - 11/26/19 - 11/26/19 - 11/26/19 - 11/26/19 - 11/26/19 - 11/26/19 Misc Parts Hose Misc Parts nozzle brass bushing belt dressing bucket thermostats in barn & WWTP thermostats in barn & WWTP permeate #6 fix parts 3,704.54 138.94 79.97 140.17 126.28 35.44 374.94 10.58 13.75 215.00 450.00 490.00 907.21 3,843.48 3,923.45 4,063.62 4,189.90 4,225.34 4,600.28 4,610.86 4,624.61 4,839.61 5,289.61 5,779.61 6,686.82 ACADEMY SPORTS #81 THE HOME DEPOT 6581 GRAINGER STUART HOSE & PIPE - F ROANOKE WINNELSON CO ROANOKE AUTO SUPPLY LT ROANOKE AUTO SUPPLY LT THE HOME DEPOT #6581 BRANDON R REED BRANDON R REED DHS AUTOMATION, INC Huber Technology Inc PC PC PC PC PC PC PC PC 5924 AP 5924 AP 5968 AP 5971 AP Account: 135-55080-020-000 Maintenance & Repairs Totals: 2,982.28 6,686.82 ** 88,000.00 Budgeted 81,313.18 Remaining 8 % Used Account: 135-55081-020-000 Mainten & Repairs Collections 359 11/26/2019 318 11/30/2019 318 11/30/2019 318 11/30/2019 356 11/30/2019 356 11/30/2019 PCards 10/29/19 November A/P November A/P November A/P November A/P November A/P 11/26/19 concrete grade ring LS #4 repair manhole lids gasketa LS #20 pump and floats pump for Ave 20 L/S 7,925.25 22.25 2,391.74 1,745.00 130.92 812.00 1,250.00 7,947.50 10,339.24 12,084.24 12,215.16 13,027.16 14,277.16 FERGUSON ENT 1241 DHS AUTOMATION, INC Core & Main LP SMITH PUMP COMPANY, INC. DHS AUTOMATION, INC NORTH TEXAS PUMP CO. PC 5930 AP 5928 AP 5948 AP 5968 AP 5976 AP Account: 135-55081-020-000 Mainten & Repairs Collections Totals: 6,351.91 14,277.16 ** 10,000.00 Budgeted (4,277.16) Remaining 143 % Used Account: 135-55085-020-000 Generator Maint. and Repair .00 .00 Account: 135-55085-020-000 Generator Maint. and Repair Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used 68 of 140 glpdatb2 skrolczyk Trophy Club MUD No.1 16:38 12/09/19 Detailed Accounting Trial Balance Page 24 Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55090-020-000 Vehicle Maintenance 359 11/26/2019 PCards 10/29/19 - 11/26/19 359 11/26/2019 PCards 10/29/19 - 11/26/19 359 11/26/2019 PCards 10/29/19 - 11/26/19 359 11/26/2019 PCards 10/29/19 - 11/26/19 Washer Fluid car wash truck maintenance oil change 47.02 6.94 53.96 THE HOME DEPOT 6581 7.00 60.96 CARMEL CARWASH - ROANO 40.00 100.96 INLAND TRUCK PARTS # 61.52 162.48 KWIK KAR LUBE & TUNE 0 PC PC PC PC Account: 135-55090-020-000 Vehicle Maintenance Totals: 115.46 162.48 ** 4,000.00 Budgeted 3,837.52 Remaining 4 % Used Account: 135-55091-020-000 Veh Maintenance Collections 318 11/30/2019 November A/P Vac truck service 1,837.08 1,837.08 CLS SEWER EQUIPMENT CO., INC 5927 AP Account: 135-55091-020-000 Veh Maintenance Collections Totals: 1,837.08 1,837.08 ** 8,000.00 Budgeted 6,162.92 Remaining 23 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader (856.24) .00 (856.24) Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 (856.24) ** 3,000.00 Budgeted 3,856.24 Remaining -29 % Used Account: 135-55120-020-000 Cleaning Services 87.50 .00 87.50 Account: 135-55120-020-000 Cleaning Services Totals: .00 87.50 ** 1,500.00 Budgeted 1,412.50 Remaining 6 % Used Account: 135-55125-020-000 Dumpster Services 254 11/14/2019 November A/P 318 11/30/2019 November A/P 356 11/30/2019 November A/P 356 11/30/2019 November A/P sludge/grit Sludge grit sludge haul off sludge haul off 4,806.24 1,233.18 2,520.30 2,523.40 1,156.30 6,039.42 L.H. CHANEY MATERIALS, INC. 8,559.72 L.H. CHANEY MATERIALS, INC. 11,083.12 L.H. CHANEY MATERIALS, INC. 12,239.42 L.H. CHANEY MATERIALS, INC. 5910 AP 5941 AP 5974 AP 5974 AP Account: 135-55125-020-000 Dumpster Services Totals: 7,433.18 12,239.42 ** 100,000.00 Budgeted 87,760.58 Remaining 12 % Used Account: 135-55135-020-000 Lab Analysis 228 11/07/2019 November A/P lab testing 2,389.60 317.40 2,707.00 OXIDOR LABORATORIES LLC 69 of 140 5898 AP glpdatb2 skrolczyk Trophy Club MUD No.1 16:38 12/09/19 Detailed Accounting Trial Balance Page 25 Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 228 11/07/2019 November A/P lab testing 359 11/26/2019 PCards 10/29/19 - 11/26/19 Calibration Gas Monitor 318 11/30/2019 November A/P lab testing 318 11/30/2019 November A/P lab testing 318 11/30/2019 November A/P lab testing 318 11/30/2019 November A/P lab testing 356 11/30/2019 November A/P lab testing 2,389.60 230.00 2,937.00 OXIDOR LABORATORIES LLC 60.00 2,997.00 RITZ SAFETY DALLAS 317.40 3,314.40 OXIDOR LABORATORIES LLC 230.00 3,544.40 OXIDOR LABORATORIES LLC 317.40 3,861.80 OXIDOR LABORATORIES LLC 230.00 4,091.80 OXIDOR LABORATORIES LLC 317.40 4,409.20 OXIDOR LABORATORIES LLC 5898 AP PC 5946 AP 5946 AP 5946 AP 5946 AP 5978 AP Account: 135-55135-020-000 Lab Analysis Totals: 2,019.60 4,409.20 ** 40,000.00 Budgeted 35,590.80 Remaining 11 % Used Account: 135-60010-020-000 I Communications/Mobiles 254 11/14/2019 November A/P cell phones -november 359 11/26/2019 PCards 10/29/19 - 11/26/19 Tablet cases 372.84 769.01 32.98 1,141.85 1,174.83 VERIZON WIRELESS AMZN MKTP US*IM2TO3FT3 5920 AP PC Account: 135-60010-020-000 ' Communications/Mobiles _ Totals: 801.99 1,174.83 ** 5,000.00 Budgeted 3,825.17 Remaining 23 % Used Account: 135-60020-020-000 Electricity 254 11/14/2019 November A/P electricity 9/27-10/29 318 11/30/2019 November A/P electricity 10/10-11/8 350 11/30/2019 Town Billed Invoices 1714-1717 AR 20191130-20191130 User: 11,761.29 500.86 10,861.33 (436.36) 12,262.15 23,123.48 22,687.12 TRI COUNTY ELECTRIC HUDSON ENERGY SERVICES, LLC 5918 5936 AP AP AR Account: 135-60020-020-000 Electricity Totals: 10,925.83 22,687.12 ** 160,067.00 Budgeted 137,379.88 Remaining 14 % Used Account: 135-60066-020-000 Publications/Books/Subscripts .00 .00 Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60070-020-000 Dues & Memberships .00 .00 Account: 135-60070-020-000 Dues & Memberships Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-60080-020-000 Schools & Training 70 of 140 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 359 11/26/2019 PCards 10/29/19 - 11/26/19 management training 840.00 333.53 1,173.53 SKILLPATH / NATIONAL PC Account: 135-60080-020-000 Schools & Training Totals: 333.53 1,173.53 ** 4,990.00 Budgeted 3,816.47 Remaining 24 8 Used Account: 135-60090-020-000 Safety Program .00 .00 Account: 135-60090-020-000 Safety Program Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-60100-020-000 avel & per diem 241 11/15/2019 MUD Payroll 11/15/2019 Travel & per diem 359 11/26/2019 PCards 10/29/19 - 11/26/19 Richey Per Diem Training 359 11/26/2019 PCards 10/29/19 - 11/26/19 Richey Per Diem Training Account: 135-60100-020-000 Travel & per diem Totals: 297.57 297.57 PR 28.53 326.10 DIETER BROS RESTAURANT PC 30.61 356.71 THE SMOKEHOUSE LINDSAY PC 1,545.00 Budgeted 1,188.29 Remaining 23 % Used 356.71 356.71 ** Account: 135-60105-020-000 Rent/Lease Equipment Account: 135-60105-020-000 Account: 135-60125-020-000 Account: 135-60125-020-000 .00 .00 Rent/Lease Equipment Totals: 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Advertising .00 .00 ** .00 .00 Advertising Totals: 2,500.00 Budgeted 2,500.00 Remaining 0 % Used .00 .00 ** Account: 135-60135-020-000 TCEQ Fees & Permits 9,888.02 Account: 135-60135-020-000 Account: 135-60245-020-000 TCEQ Fees & Permits Totals: 15,000.00 Budgeted 5,111.98 Remaining 66 % Used Miscellaneous Expenses 71 of 140 .00 9,888.02 .00 9,888.02 ** glpdatb2 skrolczyk 16:38 12/09/19 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: 11/2019 JE Detail Beginning Balance Description/Comment Program: Page 27 December 16, 2019 Regular Meeting Agenda Packet Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) .00 .00 Check Source Number 72 of 140 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 .00 .00 Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 14,000.00 Budgeted 14,000.00 Remaining 0 % Used Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S 346 11/15/2019 TexPool Transfers November TexPool O&M to I&S- PID Debt 10,414.81 10,414.81 20,829.62 GL Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S Totals: 10,414.81 20,829.62 ** 114,563.00 Budgeted 93,733.38 Remaining 18 % Used Account: 135-60332-020-000 1 Interfund Transfer Out -Rev I&S I 346 11/15/2019 TexPool Transfers November TexPool O&M to Rev Bd WWTP I&S 346 11/15/2019 TexPool Transfers November TexPool O&M to 19 W&WW Rev I&S 389 11/15/2019 Adjust TexPool Tnfr Dep JE346 61,260.70 54,421.63 6,839.07 (.60) 115,682.33 122,521.40 122,520.80 GL GL GL Account: 135-60332-020-000 Interfund Transfer Out -Rev I&S Totals: 61,260.10 122,520.80 ** 673,867.00 Budgeted 551,346.20 Remaining 18 % Used Account: 135-60333-020-000 Interfund Transfer Out -Reserve 346 11/15/2019 TexPool Transfers November TexPool O&M to Rev Bond Resevr 5,750.00 5,750.00 11,500.00 GL Account: 135-60333-020-000 Interfund Transfer Out -Reserve Totals: 5,750.00 11,500.00 ** 125,187.00 Budgeted 113,687.00 Remaining 9 5 Used Account: 135-60334-020-000 Interfund Transfer Out 72 of 140 glpdatb2 skrolczyk 16:38 12/09/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Account: 135-60334-020-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 11/2019 JE Detail Beginning Balance Description/Comment Interfund Transfer Out Totals: 180,000.00 Budgeted 180,000.00 Remaining Account: 135-60360-020-000 Furniture/Equipment < $5000 359 11/26/2019 PCards 10/29/19 - 11/26/19 Washer WWTP Account: 135-60360-020-000 Account: 135-65005-020-000 352 11/24/2019 Fuel -November Account: 135-65005-020-000 Account: 135-65010-020-000 359 11/26/2019 PCards 10/29/19 359 11/26/2019 PCards 10/29/19 359 11/26/2019 PCards 10/29/19 359 11/26/2019 PCards 10/29/19 359 11/26/2019 PCards 10/29/19 359 11/26/2019 PCards 10/29/19 318 11/30/2019 November A/P ■ Account: 135-65010-020-000 Account: 135-65030-020-000 254 11/14/2019 November A/P Account: 135-65030-020-000 Account: 135-65031-020-000 254 11/14/2019 November A/P Furniture/Equipment < $5000 Totals: 2,000.00 Budgeted 1,810.00 Remaining Fuel & Lube Fuel -Nov Fuel & Lube 12,500.00 Budgeted Uniforms - 11/26/19 Orly- Uniforms - 11/26/19 Richey Uniforms - 11/26/19 Lnace Uniforms - 11/26/19 pants - 11/26/19 boots - 11/26/19 pants uniforms Uniforms 5,495.00 Budgeted Totals: 10,669.96 Remaining Totals: 2,491.07 Remaining Chemicals 4 drums -sodium hypo Chemicals 20,000.00 Budgeted Totals: 16,605.04 Remaining Chemicals Collections chemical for collections Program: Transaction Detail .00 0 % Used .00 190.00 190.00 10 6 Used Page 28 December 16, 2019 Regular Meeting Agenda Packet Transaction Vendor_Name Detail (SUBTOTAL) .00 .00 ** 190.00 AAAA KELLER APPLIANCE 190.00 ** Check Source Number PC 923.61 906.43 1,830.04 US Bank Voyager Fleet Systems 5985 AP 892.41 15 6 Used 55 6 Used 906.43 136.88 114.94 110.95 96.46 170.00 154.95 1,327.34 2,111.52 1,830.04 ** 1,029.29 1,144.23 1,255.18 1,351.64 1,521.64 1,676.59 3,003.93 THE HOME DEPOT #6581 ACADEMY SPORTS #81 ACADEMY SPORTS #81 WAL-MART #5247 RITZ SAFETY DALLAS DICKIES OUTLET FW RON MONTGOMERY & ASSOC INC 3,003.93 ** 2,825.96 569.00 3,394.96 Valley Solvent Company, INC 17 % Used 73 of 140 569.00 4,994.00 3,394.96 ** 4,994.00 MICKEY D CARSON DBA/NUSCO PC PC PC PC PC PC 5947 AP 5919 AP 5912 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 29 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65031-020-000 Chemicals Collections Totals: 4,994.00 4,994.00 ** 17,500.00 Budgeted Account: 135-65035-020-000 Small Tools Account: 135-65035-020-000 Account: 135-65040-020-000 Account: 135-65040-020-000 Small Tools 1,200.00 Budgeted Safety Equipment Safety Equipment 1,200.00 Budgeted 12,506.00 Remaining 29 % Used Totals: 1,200.00 Remaining 0 % Used Totals: 1,200.00 Remaining 0 % Used Account: 135-65045-020-000 ` Lab Supplies 254 11/14/2019 November A/P lab supplies 359 11/26/2019 PCards 10/29/19 - 11/26/19 Batteries 359 11/26/2019 PCards 10/29/19 - 11/26/19 thermometer 318 11/30/2019 November A/P lab supplies 318 11/30/2019 November A/P sensor COP replacement 356 11/30/2019 November A/P lab supplies Account: 135-65045-020-000 Lab Supplies Totals: 20,000.00 Budgeted .00 .00 .00 .00 ** .00 .00 .00 .00 ** 2,983.01 298.43 3,281.44 HACH COMPANY 5909 AP 21.95 3,303.39 TOM THUMB 91789 PC 177.46 3,480.85 GRAINGER PC 113.94 3,594.79 HD SUPPLY FACILITIES MAINT LTD 5934 AP 153.06 3,747.85 HACH COMPANY 5933 AP 230.48 3,978.33 HACH COMPANY 5970 AP 16,021.67 Remaining 20 % Used Account: 135-69005-020-000 Capital Outlays 359 11/26/2019 PCards 10/29/19 - 11/26/19 hoses 356 11/30/2019 November A/P plant water system Account: 135-69005-020-000 Capital Outlays Totals: 530,500.00 Budgeted 995.32 3,978.33 ** 5,789.00 476.00 6,265.00 STUART HOSE S PIPE - F 439,907.70 Remaining 17 6 Used Account: 135-69008-020-000 Short Term Debt -Principal Account: 135-69008-020-000 PC 84,327.30 90,592.30 REY-MAR CONSTRUCTION 5979 AP 84,803.30 90,592.30 ** .00 .00 Short Term Debt -Principal Totals: .00 .00 ** 79,133.00 Budgeted 79,133.00 Remaining 0 % Used 74 of 140 glpdatb2 skrolczyk 16:38 12/09/19 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: 11/2019 Program: Page 30 December 16, 2019 Regular Meeting Agenda Packet JE Detail Beginning Transaction Transaction Vendor_Name Balance Detail Detail (SUBTOTAL) Description/Comment Check Source Number Department 20 Totals: 279,847.46 Monthly Total 567,582.65 ** 3,157,421.00 Budgeted 2,589,838.35 Remaining 18 % Used 75 of 140 Account: 135-69009-020-000 Short Term Debt -Interest .00 .00 Account: 135-69009-020-000 Short Term Debt -Interest Totals: .00 .00 ** 11,277.00 Budgeted 11,277.00 Remaining 0 % Used Account: 135-69195-020-000 Gasb34/Reserve for Replacement 130,000.00 130,000.00 .00 Account: 135-69195-020-000 Gasb34/Reserve for Replacement Totals: .00 130,000.00 ** 130,000.00 Budgeted .00 Remaining 100 % Used Department 20 Totals: 279,847.46 Monthly Total 567,582.65 ** 3,157,421.00 Budgeted 2,589,838.35 Remaining 18 % Used 75 of 140 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 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-000 Workman's Compensation 67 11/01/2019 Insurance/Wrk Comp Expense Nov Account: 135-50045-026-000 Account: 135-60066-026-000 Account: 135-60066-026-000 Account: 135-60070-026-000 318 11/30/2019 November A/P Account: 135-60070-026-000 Workman's Compensation Totals: 1.99 1.99 3.98 GL 30.00 Budgeted 26.02 Remaining 13 5 Used Publications/Books/Subscripts Publications/Books/Subscripts Totals: 150.00 Budgeted 150.00 Remaining Dues & Memberships Board annual membership dues F Dues & Memberships Totals: 750.00 Budgeted Account: 135-60075-026-000 Meetings 359 11/26/2019 PCards 10/29/19 - 11/26/19 Food Board Meeting 359 11/26/2019 PCards 10/29/19 - 11/26/19 board meeting 1.99 3.98 ** .00 0 % Used .00 .00 .00 ** 675.00 675.00 AWBD 75.00 Remaining 90 6 Used 675.00 675.00 ** 5922 AP 118.43 118.43 VINNYS ITALIAN RESTAUR PC 37.93 156.36 TOM THUMB #1789 PC Account: 135-60075-026-000 Meetings Totals: 156.36 156.36 ** Account: 135-60080-026-000 Account: 135-60080-026-000 1,300.00 Budgeted 1,143.64 Remaining 12 % Used Schools S Training Schools 6 Training Totals: 4,000.00 Budgeted Account: 135-60100-026-000 Travel & per diem 4,000.00 Remaining 0 % Used .00 .00 .00 .00 ** .00 .00 Account: 135-60100-026-000 Travel & per diem Totals: .00 .00 ** Account: 135-60245-026-000 5,000.00 Budgeted Miscellaneous Expenses 5,000.00 Remaining 0 6 Used 76 of 140 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 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 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Department 26 Totals: 835.34 ** 833.35 Monthly Total 13,230.00 Budgeted 77 of 140 12,394.66 Remaining 6 % Used glpdatb2 skrolczyk 16:38 12/09/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 11/2019 JE Detail Beginning Balance Description/Comment Program: Page 33 December 16, 2019 Regular Meeting Agenda Packet Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Check Source Number 134 11/01/2019 MUD Payroll 11/01/19 241 11/15/2019 MUD Payroll 11/15/2019 276 11/22/2019 MUD Payroll 11/22/19 298 11/27/2019 MUD Payroll 11/27/19 Retirement Retirement Retirement Retirement 2,760.64 1,395.32 1,393.86 204.18 1,395.98 4,155.96 5,549.82 5,754.00 7,149.98 PR PR PR PR Account: 135-50020-030-000 Retirement Totals: 4,389.34 7,149.98 ** Account: 135-50005-030-000 12 5 Salaries & Wages Account: 135-50026-030-000 1 Medical Insurance 134 11/01/2019 MUD Payroll 241 11/15/2019 MUD Payroll 298 11/27/2019 MUD Payroll 11/01/19 11/15/2019 11/27/19 Salaries Salaries Salaries & Wages & Wages & Wages 13,565.85 134 11/01/2019 MUD Payroll 241 11/15/2019 MUD Payroll 15,084.65 15,068.62 15,088.55 28,650.50 43,719.12 58,807.67 PR PR PR Account: 135-50005-030-000 Salaries & Wages Account: Totals: Medical Insurance Totals: 45,241.82 58,807.67 ** 10,977.62 ** 628,298.00 Budgeted 569,490.33 Remaining 9 % Used Used Account: 135-50010-030-000 135-50027-030-000 Overtime 134 11/01/2019 MUD Payroll 298 11/27/2019 MUD Payroll 11/27/19 Overtime 153.21 459.61 3.11 3.11 PR Account: 135-50010-030-000 Overtime Totals: 3.11 ** 2,000.00 Budgeted 1,996.89 Remaining 0 % Used Account: 135-50016-030-000 Longevity 276 11/22/2019 MUD Payroll 11/22/19 Longevity 2,207.50 2,207.50 PR Account: 135-50016-030-000 Longevity Totals: 2,207.50 2,207.50 ** 2,208.00 Budgeted .50 Remaining 100 8 Used Account: 135-50020-030-000 Retirement 134 11/01/2019 MUD Payroll 11/01/19 241 11/15/2019 MUD Payroll 11/15/2019 276 11/22/2019 MUD Payroll 11/22/19 298 11/27/2019 MUD Payroll 11/27/19 Retirement Retirement Retirement Retirement 2,760.64 1,395.32 1,393.86 204.18 1,395.98 4,155.96 5,549.82 5,754.00 7,149.98 PR PR PR PR Account: 135-50020-030-000 Retirement Totals: 4,389.34 7,149.98 ** 58,554.00 Budgeted 51,404.02 Remaining 12 5 Used Account: 135-50026-030-000 1 Medical Insurance 134 11/01/2019 MUD Payroll 241 11/15/2019 MUD Payroll 11/01/19 Medical Insurance 11/15/2019 Medical Insurance 5,488.81 2,744.43 2,744.38 8,233.24 10,977.62 PR PR Account: 135-50026-030-000 Medical Insurance Totals: 5,488.81 10,977.62 ** 124,394.00 Budgeted 113,416.38 Remaining 9 % Used Account: 135-50027-030-000 Dental Insurance 134 11/01/2019 MUD Payroll 11/01/19 Dental Insurance 306.40 153.21 459.61 PR 78 of 140 glpdatb2 skrolczyk 16:38 12/09/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 241 11/15/2019 MUD Payroll 11/15/2019 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 11/2019 JE Detail Beginning Balance Description/Comment Dental Insurance 306.40 Program: Page 34 December 16, 2019 Regular Meeting Agenda Packet Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) 153.19 612.80 Check Source Number PR 134 11/01/2019 MUD Payroll 11/01/19 241 11/15/2019 MUD Payroll 11/15/2019 276 11/22/2019 MUD Payroll 11/22/19 298 11/27/2019 MUD Payroll 11/27/19 Social Security Taxes Social Security Taxes Social Security Taxes Social Security Taxes 782.00 872.87 868.73 136.86 935.67 1,654.87 2,523.60 2,660.46 3,596.13 PR PR PR PR Account: 135-50030-030-000 Social Security Taxes Totals: 2,814.13 3,596.13 ** 39,215.00 Budgeted 35,618.87 Remaining 9 % Used Account: 135-50035-030-000 Medicare Taxes 134 11/01/2019 MUD Payroll 11/01/19 241 11/15/2019 MUD Payroll 11/15/2019 276 11/22/2019 MUD Payroll 11/22/19 298 11/27/2019 MUD Payroll 11/27/19 Medicare Taxes Medicare Taxes Medicare Taxes Medicare Taxes 182.91 204.12 203.17 32.02 218.82 387.03 590.20 622.22 841.04 PR PR PR PR Account: 135-50040-030-000 9,171.00 Budgeted 8,329.96 Remaining 9 6 Used Unemployment Taxes 79 of 140 Account: 135-50027-030-000 Dental Insurance Totals: 306.40 612.80 ** 6,464.00 Budgeted 5,851.20 Remaining 9 % Used Account: 135-50028-030-000 Vision Insurance 134 11/01/2019 MUD Payroll 11/01/19 Vision Insurance 241 11/15/2019 MUD Payroll 11/15/2019 Vision Insurance 48.77 24.40 24.37 73.17 97.54 PR PR Account: 135-50028-030-000 Vision Insurance Totals: 48.77 97.54 ** 1,035.00 Budgeted 937.46 Remaining 9 % Used Account: 135-50029-030-000 Life Insurance & Other 216 11/01/2019 Payroll Benefits November Employee LTD & STD 216 11/01/2019 Payroll Benefits November Employee Benefits 318 11/30/2019 November A/P caf 125 -October 292.42 160.48 149.52 20.00 452.90 602.42 622.42 METLIFE GROUP BENEFITS Humana Inc BenefitMall 5896 5891 5923 AP AP AP Account: 135-50029-030-000 Life Insurance & Other Totals: 330.00 622.42 ** 4,500.00 Budgeted 3,877.58 Remaining 14 % Used Account: 135-50030-030-000 Social Security Taxes 134 11/01/2019 MUD Payroll 11/01/19 241 11/15/2019 MUD Payroll 11/15/2019 276 11/22/2019 MUD Payroll 11/22/19 298 11/27/2019 MUD Payroll 11/27/19 Social Security Taxes Social Security Taxes Social Security Taxes Social Security Taxes 782.00 872.87 868.73 136.86 935.67 1,654.87 2,523.60 2,660.46 3,596.13 PR PR PR PR Account: 135-50030-030-000 Social Security Taxes Totals: 2,814.13 3,596.13 ** 39,215.00 Budgeted 35,618.87 Remaining 9 % Used Account: 135-50035-030-000 Medicare Taxes 134 11/01/2019 MUD Payroll 11/01/19 241 11/15/2019 MUD Payroll 11/15/2019 276 11/22/2019 MUD Payroll 11/22/19 298 11/27/2019 MUD Payroll 11/27/19 Medicare Taxes Medicare Taxes Medicare Taxes Medicare Taxes 182.91 204.12 203.17 32.02 218.82 387.03 590.20 622.22 841.04 PR PR PR PR Account: 135-50040-030-000 9,171.00 Budgeted 8,329.96 Remaining 9 6 Used Unemployment Taxes 79 of 140 glpdatb2 skrolczyk 16:38 12/09/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Account: 135-50040-030-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 11/2019 JE Detail Beginning Balance Description/Comment Unemployment Taxes 1,440.00 Budgeted Account: 135-50045-030-000 Workman's Compensation 67 11/01/2019 Insurance/Wrk Comp Expense Nov Account: 135-50045-030-000 Workman's Compensation 1,775.00 Budgeted Totals: 1,440.00 Remaining Totals: 1,565.36 Remaining 104.82 Program: Transaction Detail .00 O % Used .00 104.82 12 % Used 104.82 Page 35 December 16, 2019 Regular Meeting Agenda Packet Transaction Vendor_Name Detail (SUBTOTAL) .00 .00 ** 209.64 209.64 ** Check Source Number GL Account: 135-50060-030-000 Pre-emp Physicals/Testing Account: 135-50060-030-000 1 Pre-emp Physicals/Testing Totals: 500.00 Budgeted 500.00 Remaining Account: 135-50070-030-000 Employee Relations 359 11/26/2019 PCards 10/29/19 - 11/26/19 Lunch Staff- Audit 359 11/26/2019 PCards 10/29/19 - 11/26/19 Steven Get Well Basket Account: 135-50070-030-000 Account: 135-55030-030-000 145 11/01/2019 November A/P 255 11/14/2019 November A/P 359 11/26/2019 PCards 10/29/19 359 11/26/2019 PCards 10/29/19 359 11/26/2019 PCards 10/29/19 359 11/26/2019 PCards 10/29/19 318 11/30/2019 November A/P 318 11/30/2019 November A/P 360 11/30/2019 November A/P Account: 135-55030-030-000 Employee Relations 8,000.00 Budgeted Totals: 7,713.78 Remaining 178.85 O % Used 4 % Used .00 .00 37.02 .00 .00 ** 215.87 PIZZA HUT 24623 70.35 286.22 HAD*HARRY & DAVID 107.37 286.22 ** PC PC Software & Support Microsoft exchang internet-November Phone Bill Phone Bill Phone Bill Monthly Fee support -P Card Microsoft exchange UB & Fixed Assets support - 11/26/19 - 11/26/19 - 11/26/19 - 11/26/19 Software & Support 134,681.00 Budgeted Totals: 66,483.55 Remaining 65,525.85 51 % Used 484.00 899.00 53.91 42.37 42.37 32.45 116.00 494.00 507.50 2,671.60 66,009.85 66,908.85 66,962.76 67,005.13 67,047.50 67,079.95 67,195.95 67,689.95 68,197.45 M3 Networks Charter Communications ATT*BILL PAYMENT ATT*BILL PAYMENT ATT*SILL PAYMENT ADOBE ACROPRO SUBS STW INC M3 Networks STW INC 68,197.45 ** 5862 AP 5906 AP PC PC PC PC 5949 AP 5945 AP 5980 AP Account: 135-55070-030-000 Independent Labor 80 of 140 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 225 11/06/2019 November A?P 254 11/14/2019 November A/P 254 11/14/2019 November A/P 254 11/14/2019 November A/P 356 11/30/2019 November A/P 356 11/30/2019 November A/P 356 11/30/2019 November A/P Account: 135-55070-030-000 Backflow Annual fee -FY 2020 GM -October GM -October GM -October GM -November 2019 GM -November 2019 GM -November 2019 595.00 595.00 SC TRACKING SOLUTIONS LLC 32.48 627.48 Carman Consulting LLC. 11,680.00 12,307.48 Carman Consulting LLC. 4.15 12,311.63 Carman Consulting LLC. 11,040.00 23,351.63 Carman Consulting LLC. 26.68 23,378.31 Carman Consulting LLC. 2.40 23,380.71 Carman Consulting LLC. Independent Labor Totals: 23,380.71 23,380.71 ** 135,000.00 Budgeted Account: 135-55080-030-000 Maintenance & Repairs Account: 135-55080-030-000 Account: 135-55085-030-000 Account: 135-55085-030-000 111,619.29 Remaining 17 6 Used Maintenance & Repairs Totals: 15,000.00 Budgeted 515.00 14,485.00 Remaining 3 % Used Generator Maint. and Repair .00 515.00 .00 515.00 ** .00 .00 Generator Maint. and Repair Totals: .00 10,000.00 Budgeted 10,000.00 Remaining Account: 135-55120-030-000 Cleaning Services Account: 135-55120-030-000 Cleaning Services Totals: 10,000.00 Budgeted 0 6 Used 869.06 9,130.94 Remaining 9 % Used Account: 135-55160-030-000 Professional Outside Services .00 ** .00 869.06 .00 869.06 ** .00 .00 Account: 135-55160-030-000 Professional Outside Services Totals: .00 .00 ** 65,600.00 Budgeted 65,600.00 Remaining Account: 135-55205-030-000 Utility Billing Contract 0 % Used 582.15 81 of 140 .00 582.15 1 1 1 1 5899 AP 5905 AP 5905 AP 5905 AP 5967 AP 5967 AP 5967 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 37 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55205-030-000 Utility Billing Contract Totals: .00 582.15 ** 9,000.00 Budgeted 8,417.85 Remaining 6 8 Used Account: 135-60005-030-000 Telephone 225 11/06/2019 November A?P Answering service -November 359 11/26/2019 PCards 10/29/19 - 11/26/19 Phone Bill 359 11/26/2019 PCards 10/29/19 - 11/26/19 Phone Bill 359 11/26/2019 PCards 10/29/19 - 11/26/19 Phone Bill 359 11/26/2019 PCards 10/29/19 - 11/26/19 Monthly Fee 350 11/30/2019 Town Billed Invoices 1714-1717 AR 20191130-20191130 User: 1,479.80 207.75 1,687.55 KEYSTONE PARK SECRETARIAL 5893 AP 471.71 2,159.26 ATT*BUS PHONE PMT PC 793.33 2,952.59 ATT*BUS PHONE PMT PC 180.20 3,132.79 ATT*BILL PAYMENT PC 14.99 3,147.78 RINGCENTRAL, INC PC (180.00) 2,967.78 AR Account: 135-60005-030-000 Telephone Totals: 1,487.98 2,967.78 ** 23,680.00 Budgeted 20,712.22 Remaining 13 8 Used Account: 135-60010-030-000 Communications/Mobiles 254 11/14/2019 November A/P cell phones -november 241 11/15/2019 MUD Payroll 11/15/2019 Communications/Mobiles 238.02 88.02 150.00 326.04 VERIZON WIRELESS 5920 AP 476.04 PR Account: 135-60010-030-000 ■ Communications/Mobiles Totals: 238.02 476.04 ** 4,000.00 Budgeted 3,523.96 Remaining 12 9 Used Account: 135-60020-030-000 Electricity/Gas .00 .00 Account: 135-60020-030-000 Electricity/Gas Totals: .00 .00 ** 6,879.00 Budgeted 6,879.00 Remaining 0 % Used Account: 135-60025-030-000 Water 350 11/30/2019 Town Billed Invoices 1714-1717 AR 20191130-20191130 User: 66.78 (56.39) 10.39 AR 356 11/30/2019 November A/P water -October 112.79 123.18 TROPHY CLUB MUD (WATER BILLS) 5984 AP Account: 135-60025-030-000 Water Totals: 56.40 123.18 ** 1,500.00 Budgeted 1,376.82 Remaining 8 % Used Account: 135-60035-030-000 Postage 359 11/26/2019 PCards 10/29/19 - 11/26/19 Mailing Fees 1,726.61 49.43 82 of 140 1,776.04 FEDEX 99710126 PC glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60035-030-000 Account: 135-60040-030-000 345 11/30/2019 Pace Credit Card Fees 345 11/30/2019 Pace Credit Card Fees 356 11/30/2019 November A/P 360 11/30/2019 November A/P Account: 135-60040-030-000 Postage Totals: 30,000.00 Budgeted Service Charges & Fees 28,223.96 Remaining 6 % Used Direct send fees -November Dig Tess -October Service Charges & Fees Totals: 67,000.00 Budgeted 52,729.22 Remaining 49.43 1,776.04 ** 7,047.93 6,725.10 13,773.03 GL 195.05 13,968.08 GL 50.00 14,018.08 Fisery Solutions, LLC 5969 AP 252.70 14,270.78 Texas Excavation Safety System 5981 AP 21 % Used 7,222.85 14,270.78 ** Account: 135-60050-030-000 Bad Debt Expense .00 .00 Account: 135-60050-030-000 Bad Debt Expense Totals: .00 .00 ** 1,500.00 Budgeted Account: 135-60055-030-000 Insurance 67 11/01/2019 Insurance/Wrk Comp Expense Nov 1,500.00 Remaining 0 % Used 6,998.39 6,998.39 13,996.78 GL Account: 135-60055-030-000 Insurance Totals: 6,998.39 13,996.78 ** Account: 135-60066-030-000 Account: 135-60066-030-000 84,000.00 Budgeted 70,003.22 Remaining 17 % Used Publications/Books/Subscripts Publications/Books/Subscripts Totals: 1,000.00 Budgeted 1,000.00 Remaining Account: 135-60070-030-000 Dues & Memberships 200.00 .00 .00 0 % Used .00 .00 ** .00 200.00 Account: 135-60070-030-000 Dues & Memberships Totals: .00 200.00 ** 6,000.00 Budgeted 5,800.00 Remaining 3 % Used Account: 135-60075-030-000 Meetings 83 of 140 glpdatb2 skrolczyk 16:38 12/09/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 359 11/26/2019 PCards 10/29/19 - 11/26/19 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 11/2019 JE Detail Beginning Balance Description/Comment safety meeting Program: Page 39 December 16, 2019 Regular Meeting Agenda Packet Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) 35.18 35.18 SQ *SQ *HOT & CREAMY D Check Source Number PC 84 of 140 Account: 135-60075-030-000 Meetings Totals: 35.18 35.18 ** 400.00 Budgeted 364.82 Remaining 9 % Used Account: 135-60079-030-000 Public Education 359 11/26/2019 PCards 10/29/19 - 11/26/19 District Document Filing 359 11/26/2019 PCards 10/29/19 - 11/26/19 District Document Filing 349.75 1.25 125.20 351.00 476.20 CFW PARKING METER NCOURT *TXTARRANTCOSWP PC PC Account: 135-60079-030-000 Public Education Totals: 126.45 476.20 ** 6,000.00 Budgeted 5,523.80 Remaining 8 % Used Account: 135-60080-030-000 Schools & Training 359 11/26/2019 PCards 10/29/19 - 11/26/19 Training GFOA 777.71 195.00 972.71 GOVERNMENT FINANCE OFF PC Account: 135-60080-030-000 Schools & Training Totals: 195.00 972.71 ** 6,850.00 Budgeted 5,877.29 Remaining 14 % Used Account: 135-60100-030-000 Travel & per diem 241 11/15/2019 MUD Payroll 11/15/2019 Travel & per diem 91.78 36.30 128.08 PR Account: 135-60100-030-000 Travel & per diem Totals: 36.30 128.08 ** 3,545.00 Budgeted 3,416.92 Remaining 4 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60115-030-000 Elections 359 11/26/2019 PCards 10/29/19 - 11/26/19 Pizza for Election Staff 43.01 43.01 MARCOS PIZZA - 5143 PC Account: 135-60115-030-000 Elections Totals: 43.01 43.01 ** .00 Budgeted (43.01) Remaining 0 % Used Account: 135-60125-030-000 Advertising 84 of 140 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 40 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60125-030-000 Account: 135-60235-030-000 255 11/14/2019 November A/P Account: 135-60235-030-000 .00 .00 Advertising Totals: .00 .00 ** 2,500.00 Budgeted Security monitoring svc-nov 2,500.00 Remaining 0 % Used 24.00 24.00 48.00 Digital Air Control, Inc Security Totals: 24.00 48.00 ** 1,288.00 Budgeted Account: 135-60245-030-000 Miscellaneous Expenses 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 1,240.00 Remaining 4 % Used Miscellaneous Expenses Totals: 500.00 Budgeted 500.00 Remaining 0 % Used General Manager Contingency General Manager Contingency Totals: 17,000.00 Budgeted 17,000.00 Remaining Furniture/Equipment < $5000 Furniture/Equipment < $5000 Totals: 2,500.00 Budgeted 2,500.00 Remaining Uniforms Uniforms Totals: 2,050.00 Budgeted Hardware 0 o Used 0 % Used 2,050.00 Remaining 0 % Used 85 of 140 .00 .00 .00 .00 ** .00 .00 .00 .00 ** .00 .00 .00 .00 ** .00 .00 .00 .00 ** .00 .00 5907 AP glpdatb2 skrolczyk 16:38 12/09/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 11/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Detail Page 41 December 16, 2019 Regular Meeting Agenda Packet Transaction Vendor_Name Detail (SUBTOTAL) Check Source Number Account: 135-65055-030-000 Hardware Totals: .00 .00 ** 26,485.00 Budgeted 26,485.00 Remaining O % Used Account: 135-65085-030-000 Office Supplies 254 11/14/2019 359 11/26/2019 359 11/26/2019 359 11/26/2019 359 11/26/2019 356 11/30/2019 356 11/30/2019 356 11/30/2019 356 11/30/2019 November A/P PCards 10/29/19 PCards 10/29/19 PCards 10/29/19 PCards 10/29/19 November A/P November A/P November A/P November A/P - 11/26/19 - 11/26/19 - 11/26/19 - 11/26/19 office supplies clipboards monitor ink clock office supplies office supplies office supplies office supplies 561.33 112.18 9.95 249.99 12.83 15.59 63.50 46.91 11.19 16.15 673.51 683.46 933.45 946.28 961.87 1,025.37 1,072.28 1,083.47 1,099.62 OFFICE DEPOT, INC AMAZON.COM*WP17E7D13 AMAZON.COM*EI1DV6713 AMZN MKTP US*2042M75S3 AMZN MKTP US*ZG9FP0XN3 OFFICE DEPOT, INC OFFICE DEPOT, INC OFFICE DEPOT, INC OFFICE DEPOT, INC 5914 AP PC PC PC PC 5977 AP 5977 AP 5977 AP 5977 AP Account: 135-65085-030-000 Office Supplies Totals: 538.29 1,099.62 ** 6,000.00 Budgeted 4,900.38 Remaining 18 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance .00 .00 Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining O % Used Account: 135-65095-030-000 Maintenance Supplies 359 11/26/2019 PCards 10/29/19 - 11/26/19 359 11/26/2019 PCards 10/29/19 - 11/26/19 359 11/26/2019 PCards 10/29/19 - 11/26/19 359 11/26/2019 PCards 10/29/19 - 11/26/19 359 11/26/2019 PCards 10/29/19 - 11/26/19 359 11/26/2019 PCards 10/29/19 - 11/26/19 359 11/26/2019 PCards 10/29/19 - 11/26/19 359 11/26/2019 PCards 10/29/19 - 11/26/19 359 11/26/2019 PCards 10/29/19 - 11/26/19 359 11/26/2019 PCards 10/29/19 - 11/26/19 359 11/26/2019 PCards 10/29/19 - 11/26/19 359 11/26/2019 PCards 10/29/19 - 11/26/19 359 11/26/2019 PCards 10/29/19 - 11/26/19 359 11/26/2019 PCards 10/29/19 - 11/26/19 forks,water, cups, creamer,etc cups batteries refund for coffee refund for coffee refund for tea refund for coffee coffee coffee coffee tea tea coffee coffee 428.00 86 of 140 111.67 15.67 10.99 (29.28) (12.01) (12.88) (29.11) 50.99 32.95 29.11 12.01 12.88 27.45 29.28 539.67 555.34 566.33 537.05 525.04 512.16 483.05 534.04 566.99 596.10 608.11 620.99 648.44 677.72 SAMSCLUB.COM SAMSCLUB #4795 AMAZON.COM*1X6R423D3 AMAZON.COM AMAZON.COM AMAZON.COM AMAZON.COM AMZN MKTP US*8R9KH2VM3 AMAZON.COM*WU4PB61V3 AMAZON.COM*E09VG5QH3 AMAZON.COM*TM8QL2DH3 AMAZON.COM*6530M29J3 AMAZON.COM*B25AT9BG3 AMAZON.COM*6W79C8WN3 PC PC PC PC PC PC PC PC PC PC PC PC PC PC glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65095-030-000 Maintenance Supplies Totals: 249.72 677.72 ** 4,000.00 Budgeted 3,322.28 Remaining 17 % Used Account: 135-65105-030-000 Printing .00 .00 Account: 135-65105-030-000 Printing Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-69005-030-000 Capital Outlays .00 .00 Account: 135-69005-030-000 Capital Outlays Totals: .00 .00 ** Account: 135-69170-030-000 254 11/14/2019 November A/P 318 11/30/2019 November A/P Account: 135-69170-030-000 Department 30 Totals: 195,000.00 Budgeted 195,000.00 Remaining 0 o Used Copier Lease Installments copier lease-nov copies Copier Lease Installments Totals: 4,000.00 Budgeted 3,506.64 Remaining 105,293.05 Monthly Total 253.84 165.00 418.84 TIAA COMMERCIAL FINANCE 74.52 493.36 KYOCERA DOCUMENT SOLUTIONS 239.52 12 % Used 493.36 ** 216,740.52 ** 1,776,712.00 Budgeted 1,559,971.48 Remaining 12 % Used 87 of 140 5917 AP 5940 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 43 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55045-039-000 Legal 254 11/14/2019 November A/P legal 3,570.00 3,570.00 McLean & Howard, L.L.P. 5911 AP 254 11/14/2019 November A/P legal -travel 1,050.00 4,620.00 McLean & Howard, L.L.P. 5911 AP 318 11/30/2019 November A/P Southlake easement 20,884.93 25,504.93 WHITAKER CHALK SWINDLE 5952 AP Account: 135-55045-039-000 Legal Totals: 3 25,504.93 ** Account: 135-55055-039-000 318 11/30/2019 November A/P 135,000.00 Budgeted 109,495.07 Remaining 19 % Used Auditing FYE 2019 Audit 5,000.00 10,150.00 15,150.00 LAFOLLETT & COMPANY, PLLC 5943 AP Account: 135-55055-039-000 Auditing Totals: 10,150.00 15,150.00 ** 33,800.00 Budgeted Account: 135-55060-039-000 Account: 135-55060-039-000 Appraisal 18,650.00 Remaining 45 % Used (13.35) .00 (13.35) Appraisal Totals: .00 (13.35) ** 11,761.00 Budgeted 11,774.35 Remaining 0 % Used Account: 135-55065-039-000 Tax Admin Fees .00 .00 Account: 135-55065-039-000 Tax Admin Fees Totals: .00 .00 ** 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Department 39 Totals: 40,641.58 ** Fund 135 Totals: 35,654.93 Monthly Total 184,561.00 Budgeted 253,193.03 Monthly Total 143,919.42 Remaining 22 % Used 40,953.86 (6,224.00) Budgeted (47,177.86) Remaining ####*9#### 88 of 140 glpdatb2 skrolczyk 16:38 12/09/19 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: 11/2019 Beginning Balance Program: Page 44 December 16, 2019 Regular Meeting Agenda Packet 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 89 of 140 (286,420.00) ** 286,420.00 Remaining 0 % Used (286,420.00) 286,420.00 Remaining 0 % Used Account: 137-49145-000-000 Intergov Transfer -General Fund (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 89 of 140 (286,420.00) ** 286,420.00 Remaining 0 % Used (286,420.00) 286,420.00 Remaining 0 % Used December 16, 2019 Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - WWTP TAX BOND CONST BALANCE SHEET NOVEMBER 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 131 TROPHY CLUB MUNICIPAL / UTILITY DISTRICT 517 TAX BOND CONSTRUCTION 568,889 TOTAL ASSETS 568,889 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 691,868 TOTAL LIABILITIES 691,868 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES (118,410) (4,569) TOTAL FUND BALANCE (122,979) TOTAL LIABILITIES AND FUND BALANCE 568,889 90 of 140 glbase_tbam skrolczyk 16:37 12/09/19 Fund: 517 2014 MUD 1 Tax Bond Const WWTP Account Description Department: Adopted Budget Trophy Club MUD No.1 Budget Summary with Amendment Revenues Period Ending: 11/2019 Amended Total Budget Encumb. Current Month Program: YTD Total % of Budget Page 14 December 16, 2019 Regular Meeting Agenda Packet Remaining Budget 517-49011-000-000 Interest Income 783.24- 1,822.08- 1,822.08 Subtotal: 783.24- 1,822.08- 1,822.08 Program number: 783.24- 1,822.08- 1,822.08 Department number: Revenues 783.24- 1,822.08- 1,822.08 Revenues Subtotal 783.24- 1,822.08- 1,822.08 91 of 140 glbase_tbam skrolczyk 16:37 12/09/19 Fund: 517 2014 MUD 1 Tax Bond Const WWTP Account Description Trophy Club MUD No.1 Budget Summary with Amendment Department: 20 Wastewater Period Ending: 11/2019 Adopted Amended Total Budget Budget Encumb. Current Month Program: YTD Total % of Budget Page 15 December 16, 2019 Regular Meeting Agenda Packet Remaining Budget 517-69005-020-000 Capital Outlays 6,391.00 6,391.00 6,391.00 - Subtotal: 6,391.00 6,391.00 6,391.00 - Program number: 6,391.00 6,391.00 6,391.00 - Department number: Wastewater 6,391.00 6,391.00 6,391.00 - Expenditures Subtotal 6,391.00 6,391.00 6,391.00 - Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 5,607.76 4,568.92 4,568.92- 92 of 140 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 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 348 11/30/2019 Bank Interest- November (1,038.84) Account: 517-49011-000-000 Interest Income Totals: .00 Budgeted 1,822.08 Remaining 0 % Used (783.24) (1,822.08) GL (783.24) (1,822.08) ** Department Totals: (1,822.08) ** (783.24) Monthly Total .00 Budgeted 93 of 140 1,822.08 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-69005-020-000 318 11/30/2019 November A/P 318 11/30/2019 November A/P Account: 517-69005-020-000 Capital Outlays WWTP Crane survey WWTP legal 2,056.00 2,056.00 Wiss, Janney, Elstner Assoc 5953 AP 4,335.00 6,391.00 Dubois Bryant Campbell LLP 5932 AP Capital Outlays Totals: 6,391.00 6,391.00 ** .00 Budgeted (6,391.00) Remaining 0 % Used Department 20 Totals: 6,391.00 ** 6,391.00 Monthly Total .00 Budgeted (6,391.00) Remaining 0 % Used Fund 517 Totals: 4,568.92 5,607.76 Monthly Total .00 Budgeted 94 of 140 (4,568.92) Remaining 0 % Used December 16, 2019 Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET NOVEMBER 2019 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 780,339 TOTAL ASSETS 780,339 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 95 of 140 81,691 81,691 698,648 698,648 780,339 December 16, 2019 Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - 16" WATERLINE REV BOND BALANCE SHEET NOVEMBER 2019 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND CASH IN BANK 586,482 INVESTMENTS 3,869,575 ACCOUNTS RECEIVABLE TOTAL ASSETS 4,456,058 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 6,004 TOTAL LIABILITIES 6,004 FUND BALANCE ASSIGNED FUND BALANCE 4,454,290 NET REVENUES / EXPENDITURES (4,236) TOTAL FUND BALANCE 4,450,054 TOTAL LIABILITIES AND FUND BALANCE 4,456,058 96 of 140 glbase_tbam skrolczyk 16:37 12/09/19 Fund: 520 Revenue Bond 16" Waterline Account Description Department: Adopted Budget Trophy Club MUD No.1 Budget Summary with Amendment Period Ending: 11/2019 Amended Total Current Budget Encumb. Month Program: YTD Total % of Budget Page 16 December 16, 2019 Regular Meeting Agenda Packet Remaining Budget 520-49011-000-000 Interest Income 807.46- 1,767.21- 1,767.21 Subtotal: 807.46- 1,767.21- 1,767.21 Program number: 807.46- 1,767.21- 1,767.21 Department number: 807.46- 1,767.21- 1,767.21 Revenues Subtotal 807.46- 1,767.21- 1,767.21 97 of 140 glbase_tbam skrolczyk 16:37 12/09/19 Fund: 520 Revenue Bond 16" Waterline Account Description Trophy Club MUD No.1 Budget Summary with Amendment Department: 10 Water Department Period Ending: 11/2019 Adopted Amended Total Budget Budget Encumb. Current Month Program: YTD Total % of Budget Page 17 December 16, 2019 Regular Meeting Agenda Packet Remaining Budget 520-69005-010-000 Capital Outlays 6,003.50 6,003.50 6,003.50 - Subtotal: 6,003.50 6,003.50 6,003.50 - Program number: 6,003.50 6,003.50 6,003.50 - Department number: Water Department 6,003.50 6,003.50 6,003.50 - Expenditures Subtotal 6,003.50 6,003.50 6,003.50 - Fund number: 520 Revenue Bond 16" Waterline 5,196.04 4,236.29 4,236.29- 98 of 140 glpdatb2 skrolczyk 16:38 12/09/19 Fund: 520 Revenue Bond 16" Waterline JE JE JE Number Date Description Department: JE Detail Description/Comment Trophy Club MUD No.1 Page 47 Detailed Accounting Trial Balance Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 520-49011-000-000 Interest Income 348 11/30/2019 Bank Interest- November (959.75) Account: 520-49011-000-000 Interest Income Totals: .00 Budgeted 1,767.21 Remaining 0 % Used (807.46) (1,767.21) GL (807.46) (1,767.21) ** Department Totals: (1,767.21) ** (807.46) Monthly Total .00 Budgeted 99 of 140 1,767.21 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 48 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 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 318 11/30/2019 November A/P 318 11/30/2019 November A/P Account: 520-69005-010-000 Capital Outlays Easement -Lake Cities Church of 16" waterline easement acquisi 4,424.00 4,424.00 Lake Cities Church of Christ 5942 AP 1,579.50 6,003.50 Jackson Walker LLP 5939 AP Capital Outlays Totals: 6,003.50 6,003.50 ** .00 Budgeted (6,003.50) Remaining 0 % Used Department 10 Totals: 6,003.50 ** 6,003.50 Monthly Total .00 Budgeted (6,003.50) Remaining 0 % Used Fund 520 Totals: 4,236.29 5,196.04 Monthly Total .00 Budgeted 100 of 140 (4,236.29) Remaining 0 % Used December 16, 2019 Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET NOVEMBER 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 826,594 TOTAL ASSETS 826,594 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 101 of 140 803,457 23,137 826,594 826,594 glbase_tbam skrolczyk 16:37 12/09/19 Fund: 528 2015 Revenue Bond Reserve Fund Department: Trophy Club MUD No.1 Page 18 Budget Summary with Amendment Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 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 Subtotal: Program number: Department number: Revenues Interest Income Interfund transfer in -Water Interfund transfer in -WW Subtotal Fund number: 528 2015 Revenue Bond Reserve Fund 11,000.00- 11,000.00- 307,049.00- 307,049.00- 200,417.00- 200,417.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 518,466.00- 102 of 140 1,131.32- 2,436.79- 4,600.00- 9,200.00- 5,750.00- 11,500.00- 11,481.32- 23,136.79- 11,481.32- 23,136.79- 11,481.32- 23,136.79- 11,481.32- 23,136.79- 11,481.32- 23,136.79- 22.153 2.996 5.738 4.463 4.463 4.463 4.463 4.463 8,563.21- 297,849.00- 188,917.00- 495,329.21- 495,329.21- 495,329.21- 495,329.21- 495,329.21- glpdatb2 skrolczyk 16:38 12/09/19 Fund: 528 2015 Revenue Bond Reserve Fund JE JE JE Number Date Description Department: JE Detail Description/Comment Account: 528-49011-000-000 Interest Income 348 11/30/2019 Bank Interest- November Account: 528-49011-000-000 Trophy Club MUD No.1 Page 49 Detailed Accounting Trial Balance Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) (1,305.47) (1,131.32) (2,436.79) GL Interest Income Totals: (1,131.32) (2,436.79) ** (11,000.00) Budgeted (8,563.21) Remaining 22 6 Used Account: 528-49142-000-000 Interfund transfer in -Water 346 11/15/2019 TexPool Transfers November TexPool O&M to Rev Bond Resevr Account: 528-49142-000-000 Interfund transfer in -Water Totals: (307,049.00) Budgeted (297,849.00) Remaining Account: 528-49143-000-000 Interfund transfer in -WW 346 11/15/2019 TexPool Transfers November TexPool 0&M to Rev Bond Resevr Account: 528-49143-000-000 Interfund transfer in -WW Totals: (200,417.00) Budgeted (188,917.00) Remaining (4,600.00) (4,600.00) 3 % Used (9,200.00) GL (4,600.00) (9,200.00) ** (5,750.00) (5,750.00) (11,500.00) GL 6 % Used (5,750.00) (11,500.00) ** Department Totals: (23,136.79) ** (11,481.32) Monthly Total (518,466.00) Budgeted (495,329.21) Remaining 4 % Used Fund 528 Totals: (23,136.79) (11,481.32) Monthly Total (518,466.00) Budgeted 103 of 140 (495,329.21) Remaining 4 % Used December 16, 2019 Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - I&S (DEBT SERVICE) BALANCE SHEET NOVEMBER 2019 ASSETS CASH IN BANK INVESTMENTS 146,424 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 668,429 ACCOUNTS RECEIVABLE -OTHER - TOTAL ASSETS 814,853 Q TROPHY CLUB MUNICIPAL UTILITY DISTRICT INTEREST & SINKING- 533 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 668,429 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 668,429 FUND BALANCE ASSIGNED FUND BALANCE 82,954 NET REVENUES / EXPENDITURES 63,470 TOTAL FUND BALANCE 146,424 TOTAL LIABILITIES AND FUND BALANCE 814,853 104 of 140 glbase_tbam skrolczyk 16:37 12/09/19 Fund: 533 MUD 1 I&S Consolidated Account Description 1 1 533-40000-000-000 1 533-40002-000-000 1 533-40015-000-000 Property Taxes Property Taxes/Delinquent Property Taxes/P & I Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Program: Period Ending: 11/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Page 19 December 16, 2019 Regular Meeting Agenda Packet 682,441.00- 1,000.00- 2,000.00- 682,441.00- 1,000.00- 2,000.00- 33,745.30- 565.22- 98.36- 42,469.72- 274.56 141.16- 6.223 -27.456 7.058 639,971.28- 1,274.56- 1,858.84 - Subtotal: 685,441.00- 685,441.00- 34,408.88- 42,336.32- 6.177 643,104.68- 533-49011-000-000 1 533-49015-000-000 Interest Income Lease/Rental Income 5,000.00- 218,004.00- 5,000.00- 218,004.00- 166.99- 303.85- 6.077 4,696.15- 218,004.00- 533-49141-000-000 Interfund Trans In -PID Surchg 114,563.00- 114,563.00- 10,414.81- 20,829.62- 18.182 93,733.38 - Subtotal: 337,567.00- 337,567.00- 10,581.80- 21,133.47- 6.261 316,433.53 - Program number: 1,023,008.00- 1,023,008.00- 44,990.68- 63,469.79- 6.204 959,538.21 - Department number: Revenues 1,023,008.00- 1,023,008.00- 44,990.68- 63,469.79- 6.204 959,538.21 - Revenues Subtotal 1,023,008.00- 1,023,008.00- 44,990.68- 63,469.79- 6.204 959,538.21- 105 of 140 glbase_tbam skrolczyk 16:37 12/09/19 Fund: 533 MUD 1 I&S Consolidated Account 1 533-70005-051-000 Description Paying Agent Fee Trophy Club MUD No.1 Budget Summary with Amendment Department: 51 Administration Period Ending: 11/2019 Adopted Amended Total Budget Budget Encumb. 2,150.00 2,150.00 Current Month Program: YTD Total Page 20 December 16, 2019 Regular Meeting Agenda Packet % of Remaining Budget Budget 2,150.00 533-70025-051-000 1 533-70035-051-000 Bond Interest Expense -Tax Bond Principal Payment -Tax 266,058.00 755,000.00 266,058.00 755,000.00 266,058.00 755,000.00 Subtotal: 1,023,208.00 1,023,208.00 1,023,208.00 Program number: 1,023,208.00 1,023,208.00 1,023,208.00 Department number: Administration 1,023,208.00 1,023,208.00 1,023,208.00 Expenditures Subtotal 1,023,208.00 1,023,208.00 1,023,208.00 Fund number: 533 MUD 1 I&S Consolidated 200.00 200.00 44,990.68- 63,469.79- ############### 63,669.79 106 of 140 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 50 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 Property Taxes 363 11/01/2019 Property Taxes 364 11/04/2019 Property Taxes 365 11/05/2019 Property Taxes 366 11/06/2019 Property Taxes 367 11/07/2019 Property Taxes 368 11/08/2019 Property Taxes 369 11/12/2019 Property Taxes 370 11/13/2019 Property Taxes 371 11/14/2019 Property Taxes 372 11/15/2019 Property Taxes 373 11/18/2019 Property Taxes 374 11/19/2019 Property Taxes 375 11/20/2019 Property Taxes 376 11/21/2019 Property Taxes 377 11/22/2019 Property Taxes 378 11/25/2019 Property Taxes 379 11/26/2019 Property Taxes 380 11/27/2019 Property Taxes (8,724.42) (866.20) (2,033.58) (3,742.83) (1,461.62) (1,745.61) (3,184.72) (810.70) (3,766.35) (2,021.15) (834.34) (471.21) (1,934.66) (4,889.40) (1,087.78) (99.53) (2,049.66) (2,025.74) (720.22) (9,590.62) (11,624.20) (15,367.03) (16,828.65) (18,574.26) (21,758.98) (22,569.68) (26,336.03) (28,357.18) (29,191.52) (29,662.73) (31,597.39) (36,486.79) (37,574.57) (37,674.10) (39,723.76) (41,749.50) (42,469.72) GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 533-40000-000-000 Property Taxes Totals: (33,745.30) (42,469.72) ** (682,441.00) Budgeted (639,971.28) Remaining 6 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 363 11/01/2019 Property Taxes 366 11/06/2019 Property Taxes 374 11/19/2019 Property Taxes 377 11/22/2019 Property Taxes 380 11/27/2019 Property Taxes 839.78 (130.88) (175.84) (2.11) 10.33 (266.72) 708.90 533.06 530.95 541.28 274.56 GL GL GL GL GL Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (565.22) 274.56 ** (1,000.00) Budgeted (1,274.56) Remaining -27 % Used Account: 533-40015-000-000 Property Taxes/P & I 363 11/01/2019 Property Taxes 366 11/06/2019 Property Taxes 374 11/19/2019 Property Taxes 380 11/27/2019 Property Taxes (42.80) (28.80) (71.60) (10.66) (82.26) (.40) (82.66) (58.50) (141.16) GL GL GL GL Account: 533-40015-000-000 Property Taxes/P & I Totals: (98.36) (141.16) ** (2,000.00) Budgeted (1,858.84) Remaining 7 % Used 107 of 140 glpdatb2 skrolczyk 16:38 12/09/19 Fund: 533 MUD 1 I&S Consolidated JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 11/2019 Beginning Balance JE Detail Description/Comment Program: Page 51 December 16, 2019 Regular Meeting Agenda Packet Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Check Source Number Department Totals: (114,563.00) Budgeted (44,990.68) Monthly Total (93,733.38) Remaining 18 % Used (1,023,008.00) Budgeted 108 of 140 (63,469.79) ** (959,538.21) Remaining 6 % Used Account: 533-49011-000-000 Interest Income 348 11/30/2019 Bank Interest- November (136.86) (166.99) (303.85) GL Account: 533-49011-000-000 Interest Income Totals: (166.99) (303.85) ** (5,000.00) Budgeted (4,696.15) Remaining 6 % 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 346 11/15/2019 TexPool Transfers November TexPool O&M to I&S- PID Debt (10,414.81) (10,414.81) (20,829.62) GL Account: 533-49141-000-000 Interfund Trans In -PID Surchg Totals: (10,414.81) (20,829.62) ** Department Totals: (114,563.00) Budgeted (44,990.68) Monthly Total (93,733.38) Remaining 18 % Used (1,023,008.00) Budgeted 108 of 140 (63,469.79) ** (959,538.21) Remaining 6 % Used glpdatb2 skrolczyk 16:38 12/09/19 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: 11/2019 JE Detail Beginning Balance Description/Comment Program: Page 52 December 16, 2019 Regular Meeting Agenda Packet Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Check Source Number Department 51 Totals: Fund 533 Totals: 755,000.00 Budgeted .00 Monthly Total (44,990.68) Monthly Total 755,000.00 Remaining 0 % Used .00 ** 1,023,208.00 Budgeted 1,023,208.00 Remaining 0 % Used (63,469.79) 200.00 Budgeted 63,669.79 Remaining ########## 109 of 140 Account: 533-70005-051-000 Paying 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 ** 266,058.00 Budgeted 266,058.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 .00 ** Department 51 Totals: Fund 533 Totals: 755,000.00 Budgeted .00 Monthly Total (44,990.68) Monthly Total 755,000.00 Remaining 0 % Used .00 ** 1,023,208.00 Budgeted 1,023,208.00 Remaining 0 % Used (63,469.79) 200.00 Budgeted 63,669.79 Remaining ########## 109 of 140 December 16, 2019 Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - REVENUE BOND I&S (WWTP) BALANCE SHEET NOVEMBER 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 133,554 TOTAL ASSETS 133,554 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 110 of 140 24,518 109,037 133,554 133,554 glbase_tbam skrolczyk 16:37 12/09/19 Fund: 534 2015 Revenue Bond I&S Account 534-49011-000-000 534-49143-000-000 Subtotal: Program number: Department number: Revenues Revenues Description Interest Income Interfund Transfer In -WW Sales Subtotal Department: Adopted Budget 2,500.00- 598,638.00- 601,138.00- 601,138.00- 601,138.00- 601,138.00 - Trophy Club MUD No.1 Budget Summary with Amendment Revenues Period Ending: 11/2019 Amended Total Budget Encumb. 2,500.00- 598,638.00- 601,138.00- 601,138.00- 601,138.00- 601,138.00- 111 of 140 Program: Current YTD Month Total 148.62- 193.89- 54,421.03- 108,842.66- 54,569.65- 109,036.55- 54,569.65- 109,036.55- 54,569.65- 109,036.55- 54,569.65- 109,036.55- % of Budget Page 21 December 16, 2019 Regular Meeting Agenda Packet Remaining Budget 7.756 2,306.11- 18.182 489,795.34- 18.138 492,101.45- 18.138 492,101.45- 18.138 492,101.45- 18.138 492,101.45- glbase_tbam skrolczyk Trophy Club MUD No.1 Page 22 16:37 12/09/19 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-70005-051-000 Rev Bond Paying Agent Fee 400.00 400.00 400.00 534-70040-051-000 Revenue Bond Interest Expense 208,238.00 208,238.00 208,238.00 534-70045-051-000 Revenue Bond Principal Expense 390,000.00 390,000.00 390,000.00 Subtotal: 598,638.00 598,638.00 598,638.00 Program number: 598,638.00 598,638.00 598,638.00 Department number: Administration 598,638.00 598,638.00 598,638.00 Expenditures Subtotal 598,638.00 598,638.00 598,638.00 Fund number: 534 2015 Revenue Bond I&S 2,500.00- 2,500.00- 54,569.65- 109,036.55- 4,361.462 106,536.55 112 of 140 glpdatb2 skrolczyk 16:38 12/09/19 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: 11/2019 Beginning Balance JE Detail Description/Comment Program: Page 53 December 16, 2019 Regular Meeting Agenda Packet Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Check Source Number Department Totals: (598,638.00) Budgeted (54,569.65) Monthly Total (489,795.34) Remaining 18 % Used (601,138.00) Budgeted 113 of 140 (109,036.55) ** (492,101.45) Remaining 18 % Used Account: 534-49011-000-000 Interest Income 348 11/30/2019 Bank Interest- November (45.27) (148.62) (193.89) GL Account: 534-49011-000-000 Interest Income Totals: (148.62) (193.89) ** (2,500.00) Budgeted (2,306.11) Remaining 8 % Used Account: 534-49143-000-000 Interfund Transfer In -WW Sales 346 11/15/2019 TexPool Transfers November TexPool O&M to Rev Bd WWTP I&S (54,421.63) 389 11/15/2019 Adjust TexPool Tnfr Dep JE346 (54,421.63) .60 (108,843.26) (108,842.66) GL GL Account: 534-49143-000-000 Interfund Transfer In -WW Sales Totals: (54,421.03) (108,842.66) ** Department Totals: (598,638.00) Budgeted (54,569.65) Monthly Total (489,795.34) Remaining 18 % Used (601,138.00) Budgeted 113 of 140 (109,036.55) ** (492,101.45) Remaining 18 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 54 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 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 Rev Bond Paying Agent Fee Totals: 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 O 6 Used .00 .00 .00 .00 ** .00 O % Used .00 .00 .00 ** Account: 534-70045-051-000 Revenue Bond Principal Expense .00 .00 Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 ** Department 51 Totals: 390,000.00 Budgeted 390,000.00 Remaining O 9 Used .00 Monthly Total 598,638.00 Budgeted .00 ** 598,638.00 Remaining 0 % Used Fund 534 Totals: (109,036.55) (54,569.65) Monthly Total (2,500.00) Budgeted 106,536.55 Remaining NNNNNNNNNN 114 of 140 December 16, 2019 Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET NOVEMBER 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB ` MUNICIPAL UTILITY DISTRICT Na. 1 535 NSII FTW SWIFT REVENUE BOND I&S 55,132 TOTAL ASSETS 55,132 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 4,967 50,165 55,132 TOTAL LIABILITIES AND FUND BALANCE 55,132 115 of 140 glbase_tbam skrolczyk 16:37 12/09/19 Fund: 535 2016 Rev Bond I&S-SWIFT Account 535-49011-000-000 535-49142-000-000 Subtotal: Program number: Department number: Revenues Revenues Description Interest Income Interfund Tran In -Water Sales Subtotal Department: Adopted Budget 1,000.00- 275,525.00- 276,525.00- 276,525.00- 276,525.00- 276,525.00 - Trophy Club MUD No.1 Budget Summary with Amendment Revenues Period Ending: 11/2019 Amended Total Budget Encumb. 1,000.00- 275,525.00- 276,525.00- 276,525.00- 276,525.00- 276,525.00- 116 of 140 Program: Current YTD Month Total 59.67- 70.21- 25,047.72- 50,095.44- 25,107.39- 50,165.65- 25,107.39- 50,165.65- 25,107.39- 50,165.65- 25,107.39- 50,165.65- % of Budget Page 23 December 16, 2019 Regular Meeting Agenda Packet Remaining Budget 7.021 929.79- 18.182 225,429.56- 18.141 226,359.35- 18.141 226,359.35- 18.141 226,359.35- 18.141 226,359.35- glbase_tbam skrolczyk Trophy Club MUD No.1 Page 24 16:37 12/09/19 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 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 Bond Interest Expense 386,811.00 386,811.00 535-70045-051-000 Revenue Bond Principal Expense 215,000.00 215,000.00 Subtotal: Program number: Department number: Administration Expenditures Subtotal Fund number: 535 2016 Rev Bond I&S-SWIFT 602,611.00 602,611.00 602,611.00 602,611.00 602,611.00 602,611.00 326,086.00 602,611.00 602,611.00 326,086.00 117 of 140 25,107.39- 50,165.65- -15.384 800.00 386,811.00 215,000.00 602,611.00 602,611.00 602,611.00 602,611.00 376,251.65 glpdatb2 skrolczyk 16:38 12/09/19 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: 11/2019 Beginning Balance JE Detail Description/Comment Program: Page 55 December 16, 2019 Regular Meeting Agenda Packet Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Check Source Number Department Totals: (275,525.00) Budgeted (25,107.39) Monthly Total (225,429.56) Remaining 18 % Used (276,525.00) Budgeted 118 of 140 (50,165.65) ** (226,359.35) Remaining 18 % Used Account: 535-49011-000-000 Interest Income 348 11/30/2019 Bank Interest- November (10.54) (59.67) (70.21) GL Account: 535-49011-000-000 Interest Income Totals: (59.67) (70.21) ** (1,000.00) Budgeted (929.79) Remaining 7 % Used Account: 535-49142-000-000 Interfund Tran In -Water Sales 346 11/15/2019 TexPool Transfers November TexPool O&M to 16Swift Rev I&S (25,047.72) (25,047.72) (50,095.44) GL Account: 535-49142-000-000 Interfund Tran In -Water Sales Totals: (25,047.72) (50,095.44) ** Department Totals: (275,525.00) Budgeted (25,107.39) Monthly Total (225,429.56) Remaining 18 % Used (276,525.00) Budgeted 118 of 140 (50,165.65) ** (226,359.35) Remaining 18 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 56 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond IBS -SWIFT Department: 51 Administration Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 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 Rev Bond Paying Agent Fee Totals: 800.00 Budgeted 800.00 Remaining Account: 535-70040-051-000 Revenue Bond Interest Expense Account: 535-70040-051-000 Revenue Bond Interest Expense Totals: 386,811.00 Budgeted 386,811.00 Remaining O 6 Used .00 .00 .00 .00 ** .00 O % Used .00 .00 .00 ** Account: 535-70045-051-000 Revenue Bond Principal Expense .00 .00 Account: 535-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 ** Department 51 Totals: 215,000.00 Budgeted 215,000.00 Remaining O % Used .00 Monthly Total 602,611.00 Budgeted .00 ** 602,611.00 Remaining 0 % Used Fund 535 Totals: (50,165.65) (25,107.39) Monthly Total 326,086.00 Budgeted 376,251.65 Remaining -15 % Used 119 of 140 December 16, 2019 Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET NOVEMBER 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB i No. 1 MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 59,536 TOTAL ASSETS 59,536 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES 59,536 TOTAL FUND BALANCE 59,536 TOTAL LIABILITIES AND FUND BALANCE 59,536 120 of 140 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 25 16:37 12/09/19 Budget Summary with Amendment Fund: 536 2019 Rev Bond I&S- W&WW System Department: Revenues Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Account 536-49011-000-000 536-49142-000-000 536-49143-000-000 Description Interest Income Interfund Tran In -Water Sales Interfund Transfer In -WW Sales 62.71- 65.69- 22,896.02- 45,792.04- 6,839.07- 13,678.14- 65.69 45,792.04 13,678.14 Subtotal: 29,797.80- 59,535.87 - 59,535.87 Program number: 29,797.80 - Department number: Revenues Revenues Subtotal Fund number: 536 2019 Rev Bond I&S- W&WW System End of Report ********* 121 of 140 59,535.87- 59,535.87 29,797.80- 59,535.87- 29,797.80- 59,535.87- 29,797.80- 59,535.87- 59,535.87 59,535.87 59,535.87 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 57 16:38 12/09/19 Detailed Accounting Trial Balance Fund: 536 2019 Rev Bond I&S- W&WW System Department: Revenues Program: December 16, 2019 Regular Meeting Agenda Packet Period Ending: 11/2019 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 348 11/30/2019 Bank Interest- November (2.98) Account: 536-49011-000-000 Interest Income Totals: .00 Budgeted 65.69 Remaining 0 % Used Account: 536-49142-000-000 Interfund Tran In -Water Sales 346 11/15/2019 TexPool Transfers November TexPool O&M to 19 W&WW Rev I&S (22,896.02) Account: 536-49142-000-000 Interfund Tran In -Water Sales Totals: .00 Budgeted 45,792.04 Remaining Account: 536-49143-000-000 Interfund Transfer In -WW Sales 346 11/15/2019 TexPool Transfers November TexPool O&M to 19 W&WW Rev I&S Account: 536-49143-000-000 Interfund Transfer In -WW Sales Totals: .00 Budgeted 13,678.14 Remaining (62.71) (65.69) GL (62.71) (65.69) ** (22,896.02) (45,792.04) GL (22,896.02) (45,792.04) ** 0 % Used (6,839.07) (6,839.07) (13,678.14) GL 0 % Used (6,839.07) (13,678.14) ** Department Totals: (59,535.87) ** (29,797.80) Monthly Total .00 Budgeted 59,535.87 Remaining 0 % Used Fund 536 Totals: (59,535.87) (29,797.80) Monthly Total .00 Budgeted 59,535.87 Remaining 0 % Used Grand Totals: (283,888.62) **** 100,292.99 Monthly Total ******* End of Report ********* (200,904.00) Budgeted 82,984.62 Remaining 141 % Used 122 of 140 December 16, 2019 Regular Meeting Agenda Packet BUDGET VARIANCE REPORT FUND: 122 - Fire O&M FINANCIALS MONTH: November 2019 REVENUE VARIANCE: 8.3% EXPENSE VARIANCE: 26.6% 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 $60,041 $75,564 6.22% 10/2019 Property Taxes/MUD Fire 122-40011 Property Taxes/Fire - Delinquent $915 -$453 10/2019 Delinquent Fire Taxes collected/paid out 122-40020 Property Taxes/Fire P&I $1,080 $1,148 10/2019 Fire Taxes Penalties & Interest collected FIRE EXPENSES 123 of 140 BUDGET VARIANCE FUND: FINANCIALS MONTH: REVENUE VARIANCE: EXPENSE VARIANCE: NOTE: ACCOUNT REVENUE 135-40000-000 135-40002-000 EXPENSES WATER 135-50016-010 135-65010-010 135-69281-010 WASTEWATER 135-50016-020 135-55081-020 1135-65010-020 1135-65031-020 BOARD OF DIRECTORS 1135-60070-026 (ADMINISTRATION 1135-50016-030 135-55030-030 1 1 Non -Departmental 1135-55055-039 December 16, 2019 Regular Meeting Agenda Packet REPORT 135 - MUD 1 O&M November 2019 8.3% 26.6% 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 Property Taxes 134,871 6,665 8,389 6.22% 10/2019 Property Taxes Property Taxes/Delinquent $300 $104 -$51 -17.13% 10/2019 Delinquent Tax Shortage/Paid Out Longevity Uniforms Water Tank Inspection Contract Longevity Maintenance & Repairs Collections Uniforms Chemicals Collections Dues & Memberships Longevity Software & Support Auditing $3,920 $5,083 $5,083 129.66% 11/2019 Annual Longevity- Moved Position $5,190 $909 $1,729 33.32% 10/2019 Pants, Shoes- New Hires $120,000 $57,933 $57,933 48.28% 11/2019 Tank Contract $8,035 $6,873 $6,873 85.53% 11/2019 Annual Longevity $10,000 $6,352 $14,277 142.77% 11/2019 Avenue Twenty Lift Station Repair; Well Repair; LS 4 Repair $5,495 $2,112 $3,004 54.67% 11/2019 Pants, Shoes- New Hires $17,500 $4,994 $4,994 28.54% 11/2019 Chemicals $750 $675 $675 90.00% 11/2019 Board Annual Membership Dues $2,208 $2,208 $2,208 99.98% 11/2019 Annual Longevity $134,681 $2,672 $68,197 50.64% 10/2019 Annual IT Contract with M3 Networks $33,800 $10,150 $15,150 44.82% 11/2019 Annual Audit 124 of 140 December 16, 2019 Regular Meeting Agenda Packet Trophy Club Municipal Utility District No. 1 Date: 12/16/2019 To: Board of Directors From: John Robert Carman Subject: General Manager's Report Regulatory Updates Sanitary Sewer Overflows (SSO) — No SSO's have occurred since the last regular Board meeting Breaks and Leaks — One leak occurred at the intersection of Trophy Wood and Inverness occurred since the last regular Board. This leak was small and difficult to locate (in the first photo below, you can see water coming from a hairline crack). To access the leak we had to remove a section of the road. We employed a contractor for cutting and replacing the concrete, which was completed the day of the repair. Other Regulatory Updates — An updated Lead and Copper Rule has been published by EPA and the comment period has begun. Our national professional associations, such as the American Water Works Association, have participated in the rule development and will submit comments to the rule changes during the comment period. While we don't anticipate commenting directly, this rule change will create additional compliance costs for the District. 125 of 140 December 16, 2019 Regular Meeting Agenda Packet Capital Improvement Projects Interconnecting Pipeline Project Phase 2 — Staff has been working with the easement acquisition team and the attorney to move the process forward. A check has been cut for easement parcel 1. Parcels 2 and 6 are being prepared for condemnation. WWTP — We are still working through the special inspector's report regarding the crane and the contractor's response to the report. We did meet on site with the contractor to go over three specific warranty items. High Service Pump Station Improvements — The startup on the new pump is now scheduled for December 17th, 2019. System Repairs In -plant Water System - The in -plant water system at the wastewater treatment plant was redesigned by Halff and Associates and installed by Rey Mar construction. The system has been gone through start-up and it performed as we hoped. This system allows us to use the high quality plant effluent for several in -plant water needs such as spraying down the fine screens, washing foam from basin walls and cleaning the belt press. 126 of 140 December 16, 2019 Regular Meeting Agenda Packet Well Number 1 Emergency Repair Update — Well number 1 electrical control panel repairs are underway. As previously reported nature of the leak in the pump discharge piping gave rise to concerns that the well casing itself had been damaged. A video inspection was authorized and the good news is that no damage to the well casing was found. At this point the total repair estimate for this emergency repair is $ 63,816.00. 127 of 140 J December 16, 2019 Regular Meeting Agenda Packet Monthly Water Operations Report Water Billed FY October November December January February March April May June 2010 39,794 39,713 29,547 30,305 25,328 23,279 41,646 53,439 102,921 2011 70,502 50,909 44,365 35,983 27,845 55,972 69,165 61,467 99,326 2012 85,869 53,571 40,815 30,616 31,665 35,263 47,194 84,905 114,104 2013 85,488 75,251 48,527 39,601 34,450 43,137 56,947 76,542 85,312 2014 82,660 48,813 34,482 39,767 37,085 54,794 66,337 84,384 99,240 2015 90,994 58,986 49,607 36,162 38,776 30,566 46,543 39,576 60,731 2016 108,951 41,936 39,028 39,622 44,551 49,498 55,181 50,827 65,390 2017 74,785 68,638 38,580 33,028 38,380 60,841 56,683 86,794 98,864 2018 83,228 69,099 48,144 34,592 40,658 43,411 60,079 89,802 118,899 2019 47,193 41,933 36,244 34,604 33,740 40,421 55,970 42,773 70,747 July 89,760 117,707 137,174 110,072 92,913 100,622 115,687 95,355 126,588 96,174 August September 128,687 82,331 170,464 123,692 144,573 108,622 130,945 114,497 113,135 110,873 139,441 123,886 119,611 98,945 104,303 99,541 125,531 73,735 131,472 114,784 Total Year 686,750 927,397 914,371 900,769 864,483 815,890 829,227 855,792 913,766 746,055 2020 1 102,150 1 40,988 1 1 1 1 1 1 1 1 1 1 1 1 143,138 140,000 120,000 100,000 80,000 60,000 40,000 20,000 0 WATER BILLED IN THOUSANDS OF GALLONS L October November December January February March April May June September - 2016 - 2017 - 2018 - 2019 - 2020 Water Pumped FY October November December January February March April May June July August September Total Year 2010 40,803 41,600 32,700 31,400 30,145 27,240 43,400 62,646 113,049 94,950 131,650 76,159 725,742 2011 70,502 50,993 44,220 33,789 36,053 54,775 71,306 63,500 116,350 152,002 169,621 117,190 980,301 2012 83,750 54,245 41,650 34,740 31,581 46,519 62,649 100,402 110,324 153,813 139,005 123,045 981,723 2013 85,966 77,758 55,110 39,283 37,867 56,743 60,969 87,168 96,602 119,414 145,988 120,342 983,210 2014 81,909 51,769 39,769 48,758 42,395 61,100 71,283 96,481 95,206 110,173 123,369 115,607 937,819 2015 106,251 67,825 58,659 45,691 39,675 35,752 56,704 48,637 72,934 117,302 143,413 142,394 935,237 2016 106,731 52,616 43,708 46,945 50,721 55,178 60,434 55,562 68,138 112,533 128,963 104,664 886,193 2017 82,677 77,937 43,792 43,207 43,024 69,549 65,723 94,452 103,867 101,184 114,872 109,769 950,053 2018 91,439 78,282 55,745 40,796 40,750 51,711 67,217 97,980 124,109 155,354 144,015 85,946 1,033,344 2019 60,576 53,119 45,651 45,552 39,014 43,048 61,238 48,787 79,167 102,887 144,299 130,752 854,090 2020 1 112,971 1 48,627 1 1 1 1 1 1 161,5981 180,000 160,000 140,000 120,000 100,000 80,000 60,000 40,000 20,000 WATER PUMPED IN THOUSANDS OF GALLONS October November December January February March April May June July August September -2016 -2017 -2018 2019 -2020 FY 2014 Total 2015 Total 2016 Total 2017 Total 2017 MUD 2017 PID 2018 Total 2018 MUD 2018 PID 2019 Total 2019 MUD 2019 PID Active Connections October 1 November December January February March April May June July August September 4139 1 4157 4173 4206 4209 4219 4240 4268 4280 4308 4333 4339 4353 1 4363 4377 4404 4413 4429 4443 4459 4478 4486 4498 4517 4531 1 4538 4556 4568 4593 4604 4607 4616 4622 4627 4632 4636 4644 4647 4661 4657 4663 4666 4670 4676 4685 4690 4696 4700 3208 3210 3220 3216 3221 3224 3228 3234 3242 3247 3252 3256 1436 1437 1441 1441 1442 1442 1442 1442 1443 1443 1444 1444 4701 4706 4712 4716 4720 4724 4724 4728 4732 4735 4736 4738 3257 3262 3268 3272 3276 3280 3280 3284 3288 3291 3292 3294 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 4741 4743 4745 4753 4753 4758 4761 4762 4768 4770 4773 4782 3297 3299 3301 3309 3309 3314 3317 3318 3324 3326 3329 3338 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 2020 Total 2020 MUD 2020 PID 4795 3351 4796 3352 1444 1444 128 of 140 Date 4 -Nov 7 -Nov 11 -Nov 14 -Nov 18 -Nov 21 -Nov 25 -Nov 26 -Nov IReport 1 Ammonia -N Influent Effluent 52.5 0.88 32.0 0.22 47.5 0.20 57.0 0.20 51.0 0.20 55.0 0.20 38.8 0.20 49.5 0.20 November 2019 Results Removal 98.3% 99.3% CBOD5 Influent Effluent 370 2.0 247 2.0 Removal 1 99.5% 99.2% December 16, 2019 Regular Meeting Agenda Packet TSS Influent Effluent 356 1.0 172 1.0 99.6% 319 2.0 99.4% 194 1.0 99.6% 252 2.0 99.2% 225 1.0 99.6% 225 2.0 99.1% 250 1.0 99.6% 247 2.0 99.2% 292 1.0 99.5% 273 2.0 99.3% 245 1.0 99.6% 218 2.0 99.1% 251 1.0 Removal 99.7 99.4% 99.5% 99.6% 99.6% 99.7% 99.6% 99.6% Ammonia -N CBOD5 TSS 0.29 1 99.4% 2.0 1 99.2% 1.0 1 99.6% 129 of 140 3.50 3.00 2.50 2.00 1.50 1.00 0.50 0.00 6.0 5.0 4.0 3.0 2.0 1.0 0.0 December 16, 2019 Regular Meeting Agenda Packet Ammonia Nitrogen Permit Limit 3 (Jan - March) 0.21 0.2 Permit Limit -1 from April - August 0.481 0.498 0.309 J • 1 0.316• 0.215 0.201 0.224 0.2 Permit Limit 3 (Sept. - Dec.) 0.271 0.288 ■ Dec -18 Jan -19 Feb -19 Mar -19 Apr -19 May -19 Jun -19 Jul -19 Aug -19 Max mg/L = .20 Average mg/L =.20 Carbonaceous Biochemical Demand (CBOD5) Sep -19 Oct -19 Nov -19 Dec -19 2.0 2.0 2.0 2.0 2.13 2.0 2.04 2.0 2.00 2.0 2.00 2.0 Permit Limit 5 2.00 2.0 2.00 2.0 2.00 2.0 2.00 2.0 2.00 2.0 2.00 2.0 11 11 IIIIIIIIIIIIIIIIIII Dec -18 Jan -19 Feb -19 Mar -19 Apr -19 May -19 Jun -19 Jul -19 Max mg/L = 2.0 Average mg/L = 2.0 130 of 140 Aug -19 Sep -19 Oct -19 Nov -19 Dec -19 - Nh3Ave - Nh3 Permit Limit Bod Bod Aver Permit Limit 14.0 12.0 10.0 8.0 6.0 4.0 2.0 0.0 30.0 25.0 20.0 15.0 10.0 5.0 0.0 December 16, 2019 Regular Meeting Agenda Packet Total Suspended Solids (TSS) Permit Limit 12 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.00 1.0 -. .. .. -. -. -. -. -. - - Dec -18 Jan -19 Feb -19 Mar -19 Apr -19 May -19 Jun -19 Jul -19 Aug -19 Max mg/L = 1.0 Average mg/L = 1.0 Nitrate - Nitrogen Sep -19 Oct -19 Nov -19 Dec -19 Permit Limit 24 5.8 5.80 5.5 5.30 5.1 5.7 5.9 5.1 4.9 5.4 4.9 4.6 5.19 4.97 4.69 4.6 4.68 4.74 4.86 4.73 4.8 1 1 1111 , 1 3.5 , 1 1 1 1 1 1 3.7 1 1 1 1 1 1 1 1 Dec -18 Jan -19 Feb -19 Mar -19 Apr -19 May -19 Jun -19 Jul -19 Max mg/L = 5.8 Average = 4.6 131 of 140 Aug -19 Sep -19 Oct -19 Nov -19 Dec -19 T55 111-55 Ave Permit Limit N -N N -N Aver Permit Limit 10 9 8 7 6 5 4 3 2 1 0 10.0 9.0 8.0 7.0 6.0 5.0 4.0 3.0 2.0 1.0 0.0 December 16, 2019 Regular Meeting Agenda Packet E. Coli Permit Limit 126 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Dec -18 Jan -19 Feb -19 Mar -19 Apr -19 May -19 Jun -19 Jul -19 Aug -19 Max mg/L = 1.0 Average mg/L = 1.0 Potential for Hydrogen (pH) Sep -19 Oct -19 Nov -19 Dec -19 Permit Limit Hi r 9 7.897.59 .89 8. 6 5 -.627.48 7.357.457.40 7.26 7.81 61 7.42 '.45 7.44 7.327.417.37 7.197.347.27 7.28 5 6.987.237.11 6.886.73 6.58 6.37 7.80 7.49 7.09 7.09 6.69 Dec -18 Jan -19 Feb -19 Mar -19 Apr -19 May -19 Jun -19 Jul -19 Aug -19 Sep -19 Max mg/L = 7.45 Min mg/L = 7.42 Average mg/L = 7.436 132 of 140 Oct -19 Nov -19 Dec -19 • E. Coli • E. Coli Ave. • Permit Limit �pH Min pH Max pH Aver Permit Limit Low -Permit Limit High 10 9 8 7 6 5 4 3 2 1 0 December 16, 2019 Regular Meeting Agenda Packet Dissolved Oxygen (DO) Permit Limit Max 9 7.77 7.5 7.5 mq 7.5 11 7.63 7.8 7.56 7.7 7.48 7.6 7.33 7.6 1 1 1 'It Limit MI 1 22 7.5 Ul 7.37 7.6 7 .7 7.92 7.6 7.6 .11 Dec -18 Jan -19 Feb -19 Mar -19 Apr -19 May -19 Jun -19 Jul -19 Aug 19 Max mg/L = 8.1 Average mg/L = 7.5 133 of 140 Sep -19 Oct -19 Nov -19 Dec -19 - DO - DO Aver - Permit Limit Min. - Permit Limit Max Fiscal Year End 2019 Summary December 16, 2019 Regular Meeting Agenda Packet 180,000,000 160,000,000 140,000,000 120,000,000 100,000,000 80,000,000 60,000,000 Water Consumption Adopted Budget vs Actual 105,503,890 62,188,370 46,469,904 69,150,547 54,829,261 61,428,276 44,578,015 40,552,473 40,000,000 \ 55,970,000 47,193,000 \ 41 933,000 40,421,000 42,773,000 36,244,000 20,000,000 34,604,000 33,740,000 89,372,80 157,606,000 140,655,764 23,125,257 122,753,154 114,100,000 70,747,000 O —0—Budget —0—Actual Oct Nov Dec Jan Feb Mar Apr May Jun Jul 35,597,000 Aug Sep 1,000,000,000 950,000,000 900,000,000 850,000,000 800,000,000 750,000,000 700,000,000 Adopted Budget Water Consumption Vs Actual Water Consumption 960,607,716 810,928,000 1 Total Consumption • Budgeted Total Consumption • Actual Total Consumption Adopted Budget vs YTD Actuals Revenues & Expenses $8,709,093 $10,271,365 $10,613,202 YTD Expenses YTD Revenues Adopted Budget Expenses Adopted Budget Revenues Presented by: Finance Department 1,000,000 900,000 800,000 600,000 500,000 406,145 359,299 345,355 400,000 324,297 Water Revenue Adopted Budget vs Actual 906,180 848,476 300,000 325,801 200,000 2701765 296,662 100,000 0 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep —0—Budget Revenue —0—Actual Revenue 57,000,000 56,000,000 55,000,000 54,000,000 53,000,000 52,000,000 51,000,000 50 Adopted Budget Total Water Revenue Vs Actual Total Water Revenue 56,599,484 r 05,243,386 53,585,990 1 Total Water Revenue 53,265,538 • Budgeted Total Revenue • Actual Total Revenue • Net Budget Total Revenue Minus Budgeted Expenses • Net Actual Total Revenue Minus Actual Expenses $2,500 0% $179,748 2% - YTD Expense By Departments $4,590,936 53% • YTD Expense- Water • YTD Expense- WW YTD Expense- Admin • 9TD Expense- BOD • YTD Expense- Non Dept 134 of 140 December 16, 2019 Gasb 54 Balances 9/30/2019 'und 135 General Fund Project Non Spendable Year adopted Original Assigned Ammended Assigned Assets not in spendable form (Prepaids) Reserve for Budget deficits 18,486.00 Capital Projects Fund 135: Water Pump VFD for Water Plant (Carry Forward FY 2017) 2017 $370,000.00 $266,613.00 I 1592,000.56 Beacon Meter Software 2018 $11,012.00 $0.00 111,012.00 Indian Creek and Phoenix (Town) 2018 $410,000.00 $76,258.13 $218,192.37 Sundance Ct/Meadowbrook Ln (Town) 2018 $169,000.00 144,859.00 $195,609.00 Pump Discharge Head 2018 150,000.00 10.00 150,00100 Carnoustie/Creek 2019 $275,000.00 -141,403.02 $233,596.98 Valve Replacement 2018 $50,000.00 1403.02 150,403.02 Fencing 2019 1100,000.00 55,490.00 1105,490.00 On Call Truck 2019 128,000.00 10.00 128,000.00 Committed Carry Over Carry Over December 16, 2019 Regular Meeting Agenda Packet Fund 122 Fire Dept Fund 137 GASB 34 Total Total JE Transaction Non Spendable Assigned Non Spendable New Assigned Prior Assigned Remaining Spent FY 19 9/30/2019 Carry Over* added 41000 for engineering/survey Carry Over Carry Over DONE* excess funds of 56159.13 partially moved to indian creek and valve replacements l DONE* added 403.02 for excess cost DONE DONE Wastewater Lift Station 1 Relocation Study 2018 $10,000.00 $0.00 $9,572.50 Carry Over Legal/WWTP Contractor Litigation 2018 $175,000.00 $0.00 $154,886.51 Carry Over LS Upgrades (Lights, Control Panels, Quick Connects) 2019 $75,000.00 $0.00 $75,000.00 Carry Over Spare Part Inventory 2019 $50,00000 $0.00 $50,000.00 DONE 1581 Engineering 2019 $30,000.00 $0.00 $30,000.00 Carry Over In -Plant Water System 2019 $100,000 00 $47,222.00 $147,222 00 Carry Over Back Up Generator (WW) 2019 $75,000.00 $0.00 $]5,000.00 Adm in GIS Mapping Development 2019 $30,00000 $8,247.00 $38,24700 CMMS (Asset Management) Development 2019 $35,000.00 -110,638.16 $24,361.84 Board Room Audio and Video Improvements 2019 $85,00000 -$85,000.00 $0.00 Security Improvements Phase 2 WWTP and Water Plant 2019 $65,000.00 12391.16 167,391.16 Point to Point Communication/Town Project 2019 $35,00000 $0.00 =I $35,00000 Budget Software 2019 130,000.00 GASB 34 Fund 137: GASB Replacement -Town Elevated Tank GASB Replacement -Water GASB Replacement -Sewer GASB Replacement -Fire Truck Total $8,486.00 GASB Replacement -Town Elevated Tank 137-32100-000 GASB Replacement -Water 137-32111-000 GASB Replacement -Sewer 137-32113-000 GASB Replacement -Fire Truck 137-32112-000 Assigned 135-31100-000 Unassigned 135-31110-000 Carry Over • 6000 for first year webhost & 2247 for NCTCOG aerial photos DONE * Excess funds of 29700 partially moved to GIS 1 Postponed to FY 20 DONE* added 2391.16 for fire department expense Carry Over 19,887.00 $39,887.00 DONE $2,230,071.94 135 of 140 $0.00 145,000.00 $30,000.00 130,000.00 181,420.00 10.00 $186,420.00 $69,707.93 $ 1522292.63) x92.63) $11,012.00 $ 532,749.25 $ (185,443.12) 85,443.12) $138,086.20 $ (57,522.80) (57,522.80) $50,000.00 $ - 514,756.11 $ (218,840.87) (233,596.98) $0.00 $ (50,403.02) (50,403.02) $0.00 $ (105,490.00) (105,490.00) 1394.00 $ (27,606.00) 8,000.00) $ (2,349.58) ,349.58) 1117,386.22 $ (37,500.29) 37,500.29) $37,647.00 $ (37,353.00) (37,353.00) $6,753.20 $ (43,246.80) (50,000.00) 530,000.00 $ - 1132,911.60 $ (14,310.40) (14,310.40) $1.00 $ (74,999.00) (75,000.00) $0.00 $ (38,247.00) (38,247.00) 519,061.84 $ (5,300.00) (24,361.84) 10.00 $ - - 10.00 $ (67,391.16) $0.00 $ (39,887.00) 1180,000.00 1225,000.00 -1150,000.00 $120,000.00 50.00 567,804.58 197,804.58 $228,621.39 $310,041.39 -5150,000.06 5596,425.97 51,335,535.24 -51,528,182.67 -$1,569,148.82 Protect December 16, 2019 Regular Meeting Agenda Packet Gasb 54 Balances 10/1/2019 Fund 135 Ge',era) Fund Fund 122 ,ire Dept Fund 137 GASB 34 Total lE Non Spendable Year Adopted Original Assigned Carry Over Assigned Ammended Total Assigned Committed Non Spendable Assigned Non Spendable Assigned Transaction Assets not in spendable form (Prepaids) 58,486.00 Reserve for Budget deficits Capital Projects Fund 135: Water Pump VFD for Water Plant 2017 5370,000.00 569,707.93 50.00 569,707.93 Pump Discharge Head 2018 550,000.00 550,000.00 50.00 550,000.00 Quick Connects Fire Hydrants 2020 55,000.00 55,000.00 55,000.00 Beacon Meter Software 2018 511,012.00 511,012.00 59,000.00 Indian Creek and Phoenix (Town) 2018 5410,000.00 532,749.25 50.00 Sundance Ct/Meadowbrook Ln (Town) 2018 5169,000.00 5138,086.20 50.00 Valve Replacement 2020 550,000.00 550,000.00 550,000.00 Water Line Replacement 2020 5500,000.00 5500,000.00 5500,000.00 Fencing 2020 510,000.00 510,000.00 510,000.00 Fleet Replacement 2020 $41,000.00 541,000.00 541,000.00 20' Line Stops and Gate Valves 2020 569,875.00 569,875.00 569,875.00 Carry Over Carry Over 520,012.00 Carry Over 532,749.25 Carry Over 5138,086.20 Carry Over Wastewater Lift Station 1 Relocation Study 2018 510,000.00 57,222.92 50.00 1egal/WWfP 2018 5175,000.00 5117,386.22 5150,000.00 L5 Upgrades (Lights, Control Pannels, Quick Connects) 2019 575,000.00 $37,647.00 550,000.00 LS Pumps Spare Part Inventory L5 81 Upgrade/Engineering In -Plant Water System Blower Curtains Hose Upgrades MBR Belt Press Belt Telemetry Upgrades Lift Station Fencing W WTP Fencing Replacement Manhole Rehab and Replacement Paving Road and Driveway W WTP $7,222.92 Carry Over 5267,386.22 Carry Over 587,64700 Carry Over 2020 520,000.00 520,000.00 520,000.00 2020 525,000.00 525,000.00 $25,000.00 2019 530,000.00 530,000.00 530,000.00 2019 5100,000.00 5132,911.60 50.00 2020 513,000.00 513,000.00 2020 55,000.00 55,000.00 2020 55,000.00 55,000.00 2020 530,000.00 530,000.00 2020 55,000.00 55,000.00 2020 550,000.00 550,000.00 2020 522,500.00 522,500.00 2020 5125,000.00 5125,000.00 Admin Board Room Audio and Video Improvements 2020 5100,000.00 Point to Point Communication/Town Project 2019 $35,000.00 Security Improvements Phase 3 2020 525,000.00 Building Maintenance 2020 550,000.00 Pavement and Driveway Repair 2020 520,000.00 535,000 00 5100,000.00 50.00 525,000.00 550,000.00 520,000.00 560,00000 Carry Over 5132,91160 Carry Over 513,000.00 55,000.00 55,000.00 $0.00 50.00 $0.00 50.00 55,000.00 55,000.00 50.00 59,000.00 50.00 50.00 50.00 50.00 550,000.00 550,000.00 5500,000.00 5500,000.00 510,000.00 510,000.00 541,000.00 541,000.00 569,875.00 569,875.00 50.00 50.00 50.00 5150,000.00 50.00 550,000.00 520,000.00 520,000.00 525,000.00 525,000.00 50.00 530,000.00 50.00 50.00 513,000.00 513,000.00 55,000.00 55,000.00 55,000.00 55,000.00 530,000.00 530,000.00 530,000.00 55,000.00 55,000.00 55,000.00 550,000.00 $50,000.00 550,000.00 $22,500.00 $22,500.00 $22,500.00 5125,00000 5125,000.00 5125,000.00 5100,000.00 535,00000 Carry Over 525,000.00 550,000 00 520,000.00 Total $8,486.00 $661,723.12 $1,410,375. 52,072,098.12 GASB Fund 137: GASB Replacement -Town Elevated Tank GASB Replacement -Water GASB Replacement -Sewer GASB Replacement- Sewer MBR's GASB Replacement -Fire Truck Total 1 1 1 136 of 140 5100,000.00 5100,000.00 50.00 $0.00 525,000.00 525,000.00 550,000.00 550,000.00 520,000.00 520,000.00 $1,171,375.00 51,410,375.00 09/30 Balance 10/01 Addtions 10/01 Balance 1 6058 54 $225,00000 5270,000.00r JE 1631 5000 53 530,000.00 597,804 58 53 , 5127,804.58 6058 34 50.00 5100,000.0 5100,000.00 JE 151, 5310,04139 $81,420.00 5391,461.39 5632,845.97 5286,420.001 $919,265.97 ebills Bills Mailed Bank Draft Credit Card Draft Online Payments Late Notices Disconnects M Connections P ebills Bills Mailed Bank Draft Credit Card Draft Online Payments Late Notices Disconnects M Connections P December 16, 2019 Regular Meeting Agenda Packet Trophy Club MUD 141 Utility Billing Report Fiscal Year 2020 October November December January February March April May June July August September 938 941 3841 3845 646 650 1193 1185 1145 1192 378 453 21 41 3351 3352 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 3297 3299 3301 3309 3309 3314 3317 3318 3324 3326 3329 3338 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 137 of 140 December 16, 2019 Regular Meeting Agenda Packet MUD Permits Month: November 2019 Plumbing Sewer Date of Customer Deposit Due to FW Water 135- Inspections 135- Inspections 135- Misc Income Permit Permit No. 135-25030 20500 Oversize Meter 135-49075 47035 47045 Fire Line 135-49900 135-49900 Total 11/26/2019 2020-13 $ 75.00 $ 1,173.00 $ 353.00 $ 150.00 $ 50.00 $ 1,801.00 11/26/2019 2020-14 $ 75.00 $ 1,173.00 $ 353.00 $ 150.00 $ 50.00 $ 1,801.00 Total $ 150.00 $ 2,346.00 $ 706.00 $ 300.00 $ 100.00 $ 138 of 140 $ 3,602.00 CASH STATUS AS OF NOVEMBER 2019 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) *11/30/2019 Customer Water Deposits $320,304 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 139 of 140 December 16, 2019 Regular Meeting Agenda Packet Restricted - Unable to be spent $o $320,304 $1,398,315 $0 $0 $919,266 $568,889 $0 $0 $780,339 $586,482 $3,869,575 $826,594 $146,424 $0 $133,554 $55,132 $59,536 $9,664,410 $o $0 Unrestricted - Available for spending $4,202,332 $2,663,089 $0 $150 $450 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $6,866,021 $0 1 $6,866,021 $6,866,021 $329,248 $0 $329,248 $329,248 $329,248 Total in Accounts (Restricted & Unrestricted) $4,202,332 $2,983,393 $1,398,315 $150 $450 $919,266 $568,889 $0 $0 $780,339 $586,482 $3,869,575 $826,594 $146,424 $0 $133,554 $55,132 $59,536 $16,530,432 General Fund 135 Available 2,663,089 Prosperity General Fund 4,202,332 Texpool General Fund 600 Petty Cash 6,866,021 3,486 2,072,098 6,325,800 (40,954) $8,360,431 $329,248 $0 $329,248 TC Meeting Spaces Calendars FS Conference FS Training Room„ Svore Board Room January 2020 2 3 4 Sun Mon Tue Wed Dec 29, 2019 5 12 19 30 6 13 20 6:30pm r4J Board of Di 31 7 14 21 5 26 27I 28 140 of 140 Jan 1 Office Closed 8 15 22 29 December 16, 2019 Regular Meeting Agenda Packe 2 Modifier Thu Fri Sat 2 3 9 10 16 23 30 17 24 4 11 18 25 311 Feb 1 Powered by T team