Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2019-1114 November 14, 2019 Agenda Packet
November 14, 2019 4 TROPHY CLUB MUNICIPAL i UTILITY DISTRICT November 14, 2019 Regular Meeting Agenda Packet BOARD OF DIRECTORS REGULAR MEETING TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 100 MUNICIPAL DRIVE TROPHY CLUB, TEXAS 76262 4:30 P.M. Svore Municipal Boardroom REGULAR MEETING AGENDA PACKET CALL TO ORDER AND ANNOUNCE A QUORUM 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. REGULAR SESSION 2. Consider and take appropriate action on matters deliberated in Executive Session: a. Authorize offer of employment to candidate for General Manager. 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. 3. Consider and take appropriate action to approve the Consent Agenda. a. October Check Register b. October 21, 2019 Regular Meeting minutes attachments: October Check Register October 21, 2019 Regular Meeting minutes REGULAR SESSION 4. Consider and take appropriate action to appoint two (2) directors to serve on the Audit Committee. (Staff) 1 of 120 November 14, 2019 Regular Meeting Agenda Packet 5. Discussion and possible action regarding noise level at the wastewater treatment plant. (Flynn/Wilson) 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) attachments: Staff Report Employee benefits 7. Consider and take appropriate action regarding the October 2019 Combined Financials and Variance Report. (Staff) 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 • Utility Billing Report • Permits Collected • Cash Report attachments: GM Report Water Operations Report Wastewater Operations Report Utility Billing Report Permits Cash Report 9. Items for future agendas: 10. Set future Meeting dates: a. Regular Board Meeting — Monday, December 16, 2019 at 6:30 p.m. attachment: December meeting calendar ADJOURN 2 of 120 aparlo nt2 skrolczyk Trophy Quo MOD No.1 AP Checks Far Date/Amount Range Begin Date: 10/01/2019 Ehd Date: 10/31/2019 From Amt: .00 To Amt: 99,999,999.99 Nogg 1914pg;QV Regular Meeting Agenda Pap PaRigort 1 venoor v x r [Name Invoice MIIDer invoice Inv Dept ACoo:alt Descraptacia Line Item Lae= Laecx timber Date Stat No Ember Value Number Date 998 tBIZEN, LOOMI'LA 09036002858901A 09/30/19 P 135-20050-000-000 A/P Vernhra 25.71 5770 10/03/19 Totals for Check: 5770 25.71 998 EiIBY HATLIDAY REAL ESTATE, INC 00050350010108A 09/30/19 P 135-20050-000-000 A/P VensMs 15.43 5771 10/03/19 Totals for Check: 5771 15.43 998 BETTE, STEVEN 00010020121106A 09/30/19 P 135-20050-000-000 A/P Vendors 47.26 5772 10/03/19 Totals for Check: 5772 47.26 998 METh8S, JEREMY 09021110001902A 09/30/19 P 135-20050-000-000 A/P Vendars 21.20 5773 10/03/19 Totals for Check: 5773 21.20 998 ROBISCN, CHARLES 00020000913205A 09/30/19 P 135-20050-000-000 A/P V®dars 110.69 5774 10/03/19 Totals for C4:eck: 5774 110.69 998 SWA3St84, STEM00030121603202A 09/30/19 P 135-20050-000-000 A/P Vendors 04.82 5775 10/03/19 Totals for Check: 5775 04.82 998 WELLS, SHAWN 00020000906203A 09/30/19 P 135-20050-000-000 A/P Venders 04.58 5776 10/03/19 Totals for Check: 5776 04.58 998 WILSON, JOYCE 00020460012207A 09/30/19 P 135-20050-000-000 A/9 Vendors 260.55 5777 10/03/19 Totals for Check: 5777 260.55 2727 Advanced Paint Regain Service 12128 09/16/19 P 45 122-69005-045-000 Capital Outlays 1,400.00 5778 10/04/19 Totals for heck: 5778 1,400.00 1005 ATLAS UTILITY SUPPLY CO. 11234 09/30/19 P 20 135-55080-020-000 Maintenance & Re ai s 65.95 5779 10/04/19 Tbtals far Check: 5779 65.95 1030 CITY OF FORT WORTH 09/26/2019 09/26/19 P 10 519-69005-010-000 Capital Outlays 68,533.20 5780 10/04/19 Totals far Check: 5780 68,533.20 2655 Core & Main LP L237457 09/26/19 P 10 135-55080-010-000 Maintenance & Repairs 1,291.25 5781 10/04/19 Totals far Check: 5781 1,291.25 2730 Mike MdMatre 09/30/2019 09/30/19 P 10 135-60100-010-000 Travel & per diem 187.12 5782 10/04/19 Totals for Check: 5782 187.12 1238 NORTH TEXAS PUMP CO. 14186 09/30/19 P 20 135-55085-020-000 Gemenator Maint. and Repair 285.00 5783 10/04/19 Totals far Check: 5783 285.00 3156 COMDOR 1ABORA1ORIES IEC 19090624 09/30/19 P 20 135-55135-020-000 Lab Analysis 317.40 5784 10/04/19 3156 OXIDCR 1A0.4%aiLaLies LLC 19090634 09/30/19 P 20 135-55135-020-000 lab Analysis 230.00 5784 10/04/19 Totals far Check: 5784 547.40 1000 TROPHY' CLUB MID MATER BMA 09/30/2019 09/30/19 P 30 135-60025-030-000 Water 118.09 5785 10/04/19 3of120 apachamt2 skrolczyk Begin Date: 10/01/2019 End Date: 10/31/2019 venoor vexYlor Name Muter Totals for Check: 5785 Fran Amt: Invoice tanner invoice Inv Dept Account Date Stat No Number 3270 WEE 2-CADAGUA PARTNERS 41 09/25/19 P Totals for Cheek: 5786 2716 Wiss, Janney, EOstner Assoc 0420331 09/01/19 P Totals for Check: 5787 2222 AFLAC PR00679 996 10/04/19 P Totals for Check: 5788 PR00679 996 10/04/19 P 3193 CCMPUPAY, INC. Totals for Check: 5789 2676 Humana Inc 2676 Humana Inc 2676 Humana Inc 2676 Humana Inc 2676 Burana Inc 2676 Humana Tnr Totals for Check: 5790 1834 IDE=Ot DISTRIBUTION, INC 1834 IDE = DISTRIBurIC , 1 C Totals for Check: 5791 3124 IRS Tax Payment 3124 IRS Tax Payment 3124 IRS Tax Payment Totals for Check: 5792 3167 KEYSTONE PARK SIAL Totals for Check: 5793 3132 Legal Sh; Pld Totals for Check: 5794 3216 M3 Networks Totals for Check: 5795 3115 NETUFE GROUP moms 3115 MEILI1'E GROUP moms 3115 MEILIFE GROUP RST 3115 MER41FE GROUP BEI EFITS Tbtaly for Check: 5796 2664 Onsolve Intermediate Bolding 155516816 10/13/19 P 155516816 10/13/19 P 155516816 10/13/19 P 155516816 10/13/19 P 155516816 10/13/19 P 155516816 10/13/19 P 20 517-69005-020-000 20 517-69005-020-000 135-21312-000-000 135-21313-000-000 135-21308-000-000 135-21309-000-000 135-21311-000-000 10 135-50029-010-000 20 135-50029-020-000 30 135-50029-030-000 3054069012 10/01/19 P 20 135-65045-020-000 3054069013 10/01/19 P 20 135-65045-020-000 PR00679 996 10/04/19 P PR00679 996 10/04/19 P 9800679 996 10/04/19 P 156983 10/01/19 P 9800679 996 10/04/19 P 5532 09/15/19 P 10/15/2019 10/15/19 P 10/15/2019 10/15/19 P 10/15/2019 10/15/19 P 10/15/2019 10/15/19 P 135-21302-000-000 135-21303-000-000 135-21304-000-000 30 135-60005-030-000 135-21310-000-000 30 135-55030-030-000 135-21315-000-000 10 135-50029-010-000 20 135-50029-020-000 30 135-50029-030-000 54661794725 09/23/19 P 30 135-55030-030-000 Trophy Club NOD No.1 Now/Wm 14v2.439 Regular Meeting Agenda PaP,kat 2 AP Checks Eor Date/Amount Range .00 lb Amt: 99,999,999.99 Description Capital Outlays Capital Outlays Af1ac Cafe 125 -Medical Remo Dental Vision Voluntary Life Life Insurance & Other Life Insurance & Other Life Insurance & Other Lab Supplies Lab Supplies Sidi Taxes Social Security Taxes Medicare Taxes Telephone Legal Plan Software & Support Short Term Dinahility Life Insurance & Other Life Insurance & Other Life Insurance & Other Software & Support 4 of 120 item Value tmecx (mem N'.i ber Date 118.09 10,152.50 5786 10/04/19 10,152.50 845.00 5787 10/04/19 845.00 151.13 5788 10/04/19 151.13 586.80 5789 10/04/19 586.80 1,253.49 5790 10/04/19 181.70 5790 10/04/19 274.75 5790 10/04/19 98.56 5790 10/04/19 175.00 5790 10/04/19 149.52 5790 10/04/19 2,133.02 960.96 5791 10/04/19 213.52 5791 10/04/19 1,174.48 3,708.52 5792 10/04/19 4,795.96 5792 10/04/19 1,121.62 5792 10/04/19 9,626.10 194.75 5793 10/04/19 194.75 17.46 5794 10/04/19 17.46 510.00 5795 10/04/19 510.00 97.51 5796 10/04/19 91.11 5796 10/04/19 162.14 5796 10/04/19 142.90 5796 10/04/19 493.66 3,670.00 5797 10/04/19 apackamt2 skrolczyk Begin Date: 10/01/2019 End Date: 10/31/2019 ve ocr ve dor Name Number Tbtals for Check: 5797 3113 TOURS Tbtals for Check: 5798 3243 WIN -911 SOFTWARE Totals for Check: 5799 2651 Cannan Consulting LLC. 2651 Caiman CL-nsulting LIC. 2651 Carttan Consulting nsul tixg LiC. Totals for Check: 5800 1030 CITY OF FORD WORTH Totals for Check: 5801 3080 CP&Y/WAL ACE GROUP, INC. Tbtals for Check: 5802 3184 DA'TAPE LLC 3184 DAMNPROSE LLC Totals far Check: 5803 2606 Fisery Solutions, LLC Totals for Chadic: 5804 Fran Amt: Invoice Ntmner Invoke Inv Dept Account Date Stat Nb Number PR00679 996 10/04/19 P 20191228 135-21317-000-000 09/29/19 9 30 135-55030-030-000 26 09/30/19 P 26 09/30/19 P 26 09/30/19 9 30 135-55070-030-000 30 135-55070-030-000 20 517-69005-020-000 093019IN1PACTFEE 09/30/19 P 135-20500-000-000 1600916.05-3 10/08/19 9 20 517-69005-020-000 DP1903296 09/30/19 P 30 135-60035-030-000 DP1903296 09/30/19 P 30 135-55205-030-000 91584577 09/30/19 P 30 135-60040-030-000 2558 FIRST CHECK APPLICANT SCEQ 17206 Totals far Check: 5805 2732 MC 1&E LLC Totals for Check: 5806 2943 O9MRGAN CHASE BANK NA 2943 alveRGAN CHASE BANK NA Totals for Ctheck: 5807 2643 xeLean & Howard, L.L.P. 2643 Mr_Lean & Howard, L.L.P. Totals for Check: 5808 1238 NORTH TEXAS POMP CO. Totals for Check: 5809 2685 Quality Excavation, LTU Totals for Check: 5810 09/30/19 P 10 135-50060-010-000 190123 09/29/19 9 30 135-55080-030-000 09262019 09/26/19 P 135-20060-000-000 9/26/2019-A 09/26/19 P 135-20060-000-000 35009 09/30/19 P 39 135-55045-039-000 35010 09/30/19 P 39 135-55045-039-000 14094 09/30/19 9 20 135-55085-020-000 6 09/30/19 P 10 135-69005-010-000 09/30/19 P 10 135-55135-010-001 2440 TARR NT CTY PUBLIC HEALTH LAB 32558 Trophy Club MOD No.1 N 03/PARIA914p $9 Regular Meeting Agenda PaPiot 3 AP Checks Far Date/Amount Range .00 Tb Amt: 99,999,999.99 1Jeseripticn =RS Software & Support Independent labor Independent Jahr. - Capital Outlays Fort North Water -Impact Fees Capital Outlays Postage Utility Billing Cb ntract Service Charges & Fees Pre-etp Physicals/Tasting Maintenance & Repairs Procurement Clearing Pin urenelt Clearing Legal J,=g.,l Generator Maint. and Repair Capital Outlays Lab Analysis for PID 5 of 120 Lane Item lnec K (mem Value NJarber Date 3,670.00 6,566.20 5798 10/04/19 6,566.20 495.00 5799 10/04/19 495.00 11,720.00 5800 10/07/19 64.31 5800 10/07/19 220.79 5800 10/07/19 12,005.10 144,179.00 5801 10/11/19 144,179.00 3,510.00 5802 10/11/19 3,510.00 1,637.84 5803 10/11/19 585.85 5803 10/11/19 2,223.69 50.00 5804 10/11/19 50.00 167.90 5805 10/11/19 167.90 385.99 5806 10/11/19 385.99 6,441.79 5807 10/11/19 317.27 5807 10/11/19 6,759.06 6,000.00 5808 10/11/19 1,050.00 5808 10/11/19 7,050.00 423.23 5809 10/11/19 423.23 4,973.25 5810 10/11/19 4,973.25 80.00 5811 10/11/19 apaccan t2 skrolczyk Begin Date: 10/01/2019 End Date: 10/31/2019 vendor V®Oor Mahe Rosner Fran Amt: Invoice Numoer invoice inv. uept Account Date Stat No Number 2440 TARRANT CIY PUBLIC HEALTH LAB 32557 Tbtals for Check: 5811 2696 Teras Ekcavation Safety System 19-18656 Totals for Beck: 5812 1001 TOWN OF TROPHY CLUB 1001 TOWN OF TROPHY CLUB 1001 TOWN OF TROPHY CLUB Tbt'1s for Check: 5813 2683 Charter Cannmicaticos Totals for Check: 5814 2497 LATS ADD:NATICK, INC Totals for Check: 5815 998 HURLEY, J Totals for Check: 5816 3216 M3 Networks Totals for Check: 5817 998 MX RE, CYNDIA Totals for Check: 5818 3156 C3CIDOR IAB RATORIES LLC 3156 OXIDDR LABORATORIES LLC Totals for Check: 5819 3249 PNC Bank, N.A. Totals for Check: 5820 1001 TOWN OF TROPHY CLUB Totals for Check: 5821 1058 V 2IZC8T WIRELESS 1058 VERDECKWIRELESS 1058 VER Zc WIRE[ SS Totals farCheck: 5822 2683 Charter {Xannmications Totals far Check: 5823 SEPT REFUSE SEPT REFUSE SEPT REFUSE 71672100619 09/30/19 P 10 135-55135-010-000 09/30/19 P 30 135-60040-030-000 09/30/19 P 09/30/19 P 09/30/19 P 135-25040-000-000 135-25000-000-000 135-25010-000-000 10/06/19 P 30 135-55030-030-000 06-1913 10/04/19 P 20 135-55080-020-000 U9048080024901A 10/11/19 P 135-20050-000-000 5422 10/01/19 P 30 135-55030-030-000 U0020001065204A 10/11/19 P 135-20050-000-000 19100167 19100194 584365 100119 9839123331 9839123331 9839123331 09/30/2019 2653 Dubois Bryant Campbell LLP 102019 Totals for Check: 5824 10/09/19 P 20 135-55135-020-000 10/09/19 P 20 135-55135-020-000 10/01/19 P 45 122-69305-045-000 10/07/19 P 45 122-60337-045-000 10/01/19 P 10/01/19 P 10/01/19 P 10 135-60010-010-000 20 135-60010-020-000 30 135-60010-030-000 09/30/19 P 30 135-55030-030-000 10/09/19 P 20 517-69005-020-000 Trophy Club IW No.1 NomfetbA914012129 Regular Meeting Agenda Pates 4 AP Checks Far Date/Ana t Range .00 To Amt: 99,999,999.99 Uesciiption Lab Analysis Service Charges & Fees Turn -Storm Drainage Refuse Refuse Tax Software & Support Maintenance & Repairs A/P Vendors Software & Support ATP Vendors Lab Analysis Lab Analysis Coital Leases Transfer to Town/Fire Budget Camxmicaticns/Mobiles cbmu Licatiars/Mobiles Cknmunicatiars/Mbiles Software & Suxaort Capital Outlays 6 of 120 Line 1tHn Value amber Date 200.00 5811 10/11/19 280.00 242.25 5812 10/11/19 242.25 35,604.73 65,167.37 5,893.50 106,665.60 899.00 899.00 490.00 490.00 801.07 801.07 54,600.00 54,600.00 89.23 89.23 317.40 230.00 547.40 127,148.60 127,148.60 59,888.08 59,888.08 338.17 372.84 88.02 799.03 899.00 899.00 10,792.00 10,792.00 5813 10/11/19 5813 10/11/19 5813 10/11/19 5814 10/14/19 5815 10/14/19 5816 10/14/19 5817 10/14/19 5818 10/14/19 5819 10/14/19 5819 10/14/19 5820 10/14/19 5821 10/14/19 5822 10/14/19 5822 10/14/19 5822 10/14/19 5823 10/14/19 5824 10/14/19 apackamt2 skrolczyk Begin Date: 10/01/2019 Fsd Date: 10/31/2019 Vendor vendor Name Nuauber 1081 TRI COUNTY ELECTRIC Totals for Check: 5825 1481 TML INTERGOIAMMENTAL RISK 1481 IIS INTERGOVERMENIAL RISK Totals for Check: 5826 2920 CARE ZW CORPORATE Totals for Check: 5827 2635 Halff Associates, INC 2635 Halff Associates, INC 2635 Halff Associates, INC Totals for Check: 5828 1834 ILIE QC DLSlRIBLATCN, INC 1834 MEEK DISTRIBi7l'I R , INC Totals far Cheek: 5829 1001 TIC OF TROPHY CLUB Totals for Check: 5830 1087 WHITAKER CALK SWINDLE Totals for Check: 5831 2222 AFLAC Totals for Check: 5832 1005 ATLAS UTILITY SUPPLY CO. Tofa1A for Check: 5833 2655 Cbre & Main LP Totals for Check: 5834 3193 CIMPOPAY, INC. Tbtals for Check: 5835 2677 Digital Air Control, Inc Totals for Check: 5836 2775 HUDSON ENERGY SERVICES, LLC 2775 HCIDStZI ENERGY SERVICES, ISG Totals for Check: 5837 3124 IRS Tac Payment 3124 IRS Tax Payment 3124 IRS Tax Payment From Amt: Trophy Club MUD No.l Nownfilm 1408'.39 Regular Meeting Agenda PaAga 5 AP Checks For Date/Amount Range .00 To Amt: 99,999,999.99 Invoice comber =mice Inv rept Account LesCripticn Date Stat No N.zrbcr 76212892 09/30/19 P 20 135-60020-020-000 Electricity 3464/100519 3464/100519 10/05/19 P 122-11202-000-000 Prepaid Insurance -TML 10/05/19 P 135-11202-000-000 Prepaid Insurance -TML a 1536-4050239 10/08/19 P 20 135-50060-020-000 Pre-emp Physicals/Testing 29522 29516 29518 10/16/19 P 10/16/19 P 10/16/19 P 10 135-69005-010-000 10 520-69005-010-000 30 135-69005-030-000 3052519891 09/30/19 P 20 135-65045-020-000 3053196392 09/12/19 P 20 135-65045-020-000 Capital Outlays Capital Outlays Capital Outlays Lab Supplies Lab Supplies 1001191 09/30/19 P 30 135-60020-030-000 Electricity/Gas 252624 09/30/19 P 39 135-55045-039-000 Tay+1. PR00680 996 10/18/19 P 135-21312-000-000 Aflac 11290 10/14/19 P 10 135-65050-010-000 Meter Expense L292034 10/10/19 P 10 135-55080-010-000 Maintenance & Repairs PR00680 996 10/18/19 P 135-21313-000-000 Cafe 125 -Medical Reiub 2050200 10/10/19 P 30 135-60235-030-000 Security 1910150001-27 10/15/19 P 10 135-60020-010-000 Electricity 1910150001-27 10/15/19 P 20 135-60020-020-000 Electricity PR00680 PR00680 PR00680 996 10/18/19 P 996 10/18/19 P 996 10/18/19 P 135-21302-000-000 135-21303-000-000 135-21304-000-000 FSdi Taxes Social Security Taxes Medicare Th.oles 7 of 120 rine iter t-tecis LineC} Value Nurber Date 523.92 523.92 19,690.56 107,842.72 127,533.28 76.00 76.00 1,961.26 6,878.75 9,832.92 18,672.93 1,542.29 521.98 2,064.27 572.82 572.82 2,755.50 2,755.50 151.13 151.13 1,825.28 1,825.28 1,132.30 1,132.30 586.80 586.80 24.00 24.00 14,721.00 11,935.31 26,656.31 3,850.83 5,045.54 1,180.04 5825 10/14/19 5826 10/14/19 5826 10/14/19 5827 10/17/19 5828 10/17/19 5828 10/17/19 5828 10/17/19 5829 10/17/19 5829 10/17/19 5830 10/17/19 5831 10/17/19 5832 10/17/19 5833 10/17/19 5834 10/17/19 5835 10/17/19 5836 10/17/19 5837 10/17/19 5837 10/17/19 5838 10/17/19 5838 10/17/19 5838 10/17/19 az ckam 2 skrolczyk Begin Date: 10/01/2019 End Date: 10/31/2019 Venoor venni= Name Number Totals far Check: 5838 FYcm Amt: Invoice Nu oer Invoice Inv uept AC.CCUMt Date Stat No Number 1468 L.H. (HLANEY MATERIALS, INC. 167144 10/05/19 P Total' for Check: 5839 3132 Legal Shield PR00680 996 10/18/19 P Totals for Check: 5840 2712 MARYLAND BIOCHEMICAL CO, INC 104M1007 10/01/19 P Totals for Check: 5841 1056 OFFICE mar, INC 385521545001 10/02/19 P Totals for Check: 5842 2733 SciainScOntinlos Algae Control 1027 10/10/19 P Totals for Check: 5843 3113 TOURS PR00680 996 10/18/19 P Totals for C beck: 5844 3282 TTAA CmDPJERCIAL FINANCE 6593016 10/07/19 P Totals for Check: 5845 3197 BeiefitMail 3197 PonpfitMall 3197 BenefitMall Totals for Check: 5846 9045067-1N 9045067 -IN 9045067 -IN 3186 MEMBER'S BUILDING MA/NIENAME TC19091CMOD 3186 MEMBER'S BUILDIMMUNDASPNCE TC19091010 3186 MEMBER'S BUILD= t4it NIFtYOX TC19091INUD Totals for Check: 5847 2665 MICAJEL CRUZ Totals for Check: 5848 10/14/19 P 10/14/19 P 10/14/19 P 09/30/19 P 09/30/19 P 09/30/19 P 20 135-55125-020-000 135-21310-000-000 20 135-65030-020-000 30 135-65085-030-000 20 135-55135-020-000 135-21317-000-000 30 135-69170-030-000 10 135-50029-010-000 20 135-50029-020-000 30 135-50029-030-000 20 135-55120-020-000 30 135-55120-030-000 10 135-55120-010-000 MUD 2019-10 09/30/19 P 30 135-55070-030-000 3225 US Bank Voyager Fleet Systems 869338111943-1 10/24/19 P 3225 US Bank Voyager Fleet Systeme 869338111943-1 10/24/19 P Totals for Check: 5849 2716 Wins, Janney, Elstner Assoc 0434016 lbtals for Check: 5850 3262 FRANCON R REED 3262 BRAND31 R REED Totals far Check: 5851 10 135-65005-010-000 20 135-65005-020-000 10/16/19 P 20 517-69005-020-000 2735 10/21/19 P 30 135-55080-030-000 2733 10/21/19 P 30 135-55080-030-000 Trophy Ci>ib MUD No.1 No3ip10kiiz9 1400 429 Regular Meeting Agenda PaBlet 6 AP Checks For Date/Amount Range .00 1b Amt: 99,999,999.99 Descriptun trumpeter Services Legal Plan Chemicals Office Supplies lab Analysis KUBs Copier Lease Installments Life Insurance & Other Life Insurance & Other Life Insurance & Other Cleaning Services Cleaning Services Cleaning Services Independent Fuel & Lube Fuel & Lube Capital Outlays Maintenance & Repair's Maintenance & Repairs 8 of 120 Line lien Value (meat Lnecx Nu, 1,cu Date 10,076.41 1,240.00 5839 10/17/19 1,240.00 17.44 5840 10/17/19 17.44 2,825.96 5841 10/17/19 2,825.96 61.77 5842 10/17/19 61.77 200.00 5843 10/17/19 200.00 7,049.97 5844 10/17/19 7,049.97 165.00 5845 10/17/19 165.00 20.00 5846 10/29/19 36.00 5846 10/29/19 20.00 5846 10/29/19 76.00 87.50 5847 10/29/19 869.06 5847 10/29/19 87.50 5847 10/29/19 1,044.06 55.00 5848 10/29/19 55.00 246.71 5849 10/29/19 139.42 5849 10/29/19 386.13 16,988.87 5850 10/29/19 16,988.87 355.00 5851 10/29/19 160.00 5851 10/29/19 515.00 apackamt2 skrolczyk Begin Date: 10/01/2019 End Date: 10/31/2019 Vendor Vendor Name amber 2655 Cbre & Main LP Totals for Check: 5852 2497 LES AUTOMATION, INC 2497 DHS AUICEATION, INC Totals for Check: 5853 1737 DPC INDUSTRIES, INC Tbtals far (heck: 5854 3258 FRANCCYTYp-POSIAL1'A, INC. Totals for Check: 5855 1372 HACH MANY 1372 HACH COMPANY Tbtale for Check: 5856 Fran Amt: 1nvolce Matter =wane Inv Dept Account Date Stat No Nunber L363224 10/17/19 P 10 135-55080-010-000 06-1916 10/21/19 P 20 135-69005-020-000 06-1917 10/21/19 P 20 135-55080-020-000 767005611-19 10/22/19 P 10 135-65030-010-000 RI104241477 10/16/19 P 30 135-60035-030-000 11684651 10/16/19 P 20 135-65045-020-000 11666094 10/03/19 P 20 135-65045-020-000 10/21/19 P 20 135-55081-020-000 10/24/19 P 20 135-65045-020-000 CD10018863 10/08/19 P 20 135-55080-020-000 5581695774 10/23/19 P 30 135-69170-030-000 167502 10/19/19 P 20 135-55125-020-000 167353 10/12/19 P 20 135-55125-020-000 031121 10/17/19 P 20 135-65045-020-000 5597 10/15/19 P 30 135-55030-030-000 19159 10/29/19 P 30 135-55030-030-000 14321 10/16/19 P 10 135-55080-010-000 388513543001 10/10/19 P 30 135-65085-030-000 19100328 10/15/19 P 20 135-55135-020-000 3076 HD SUPPLY FACII+ MAINP L'ID 44073 3076 HD SUPPLY FACILTI'I3S MINI' LTD 048309 Totals for Check: 5857 2641 Huber Technology Inc Totals for Check: 5858 3278 KYOCERA DOCUMENT SOLUTIONS Totals for Check: 5859 1468 L.H. CHANEY MALS, INC. 1468 L.H. CHANEY MATERIALS, INC. Totals for Check: 5860 3195 LOU'S GIMES INCORPORATED Totals for Check: 5861 3216 M3 Netks Totals for Check: 5862 2628 MSI Totals for Check: 5863 1238 NORTH TEXAS PUP CO. Totals for Check: 5864 1056 OFFICE DEPOT, INC Totals for Check: 5865 3156 OXUXR LABORAIDRIES ILC Cab MOD No.1 N oirritotv 140'g,44i9 Regular Meeting Agenda Paper 7 AP Checks For Date/Anrnmt Range .00 Tb Amt: 99,999,999.99 Description Maintenance & Repairs Capital Outlays Maintenance & Repairs Chanicals Postage Lab Supplies Lab Supplies Mainten & Repairs C011ecticns Lab Supplies Maintenance & Repairs Copier Lease Installments Dunpeter Services Deter Services Lab Supplies Software & Support Software & Support Maintenance & Repairs Office Supplies Lab Analysis 9of120 Lane lten Value 771.00 771.00 5,789.00 1,773.46 7,562.46 781.77 781.77 102.54 102.54 118.50 257.28 375.78 179.90 64.95 244.85 744.00 744.00 88.84 88.84 1,240.00 1,086.24 2,326.24 169.20 169.20 484.00 484.00 5,180.75 5,180.75 759.51 759.51 499.56 499.56 317.40 ('n Y''C (-neck Number Date 5852 10/29/19 5853 10/29/19 5853 10/29/19 5854 10/29/19 5855 10/29/19 5856 10/29/19 5856 10/29/19 5857 10/29/19 5857 10/29/19 5858 10/29/19 5859 10/29/19 5860 10/29/19 5860 10/29/19 5861 10/29/19 5862 10/29/19 5863 10/29/19 5864 10/29/19 5865 10/29/19 5866 10/29/19 apackaat2 skrolczyk Begin Date: 10/01/2019 End Date: 10/31/2019 Venom vendor Name Number Fran Ant: Invoice Number invoice Iry Leat A[XSO.mt Date Stat No Number 3156 OXIDOR LABORATCRCES LIC 19100445 Totals for Check: 5866 3176 REY-NAR uaaOanu iiu1 LS REPAIR 3176 REY-MAR C CNSIRDC1TCN 5 Tbtala for Check: 5867 2698 Ritz Safety, LLC 5849564 Tbtals for Check: 5868 2629 SSS Group, LLC 19670 Totals for Check: 5869 1578 SMITH PUMP COMPANY, INC. SI016719 Totals for Check: 5870 1973 TX COMMISSION ENVIIiLYI 8N1 iL QC 10/31/2019 Totals for Check: 5871 1267 TX COMPTROLLER D2077-2020 Totals for Check: 5872 10/17/19 P 20 135-55135-020-000 10/28/19 P 20 135-55081-020-000 10/25/19 P 10 135-69005-010-000 10/25/19 P 10/23/19 P 10/21/19 P 10/31/19 P 10/25/19 P 3225 US Bank Voyager Fleet Systems 869338111943-2 10/24/19 P 3225 US Bank Voyager Fleet Systems 869338111943-2 10/24/19 P Totals for Check: 5873 1030 CTTY OF FORT NORTH Totals for Check: 5874 Grand Tbta1a: xxxxxx End of Report xxxxxxxxx 20 135-65010-020-000 20 135-55080-020-000 20 135-55081-020-000 20 135-60135-020-000 30 135-60070-030-000 10 135-65005-010-000 20 135-65005-020-000 TYcpby p,Ub MOD No.1 NoypAgygg 14OgQ1t9 Regular Meeting Agenda Papkga 8 AP Alecks Fbr Date/Anrnalt Range .00 Tb Amt: 99,999,999.99 Description lab Analysis Mainten & Repairs Collections Capital Outlays Uniforms Maintenance & Repairs Mainten & Repairs Collections Tt Fees & Permits Dues & Memberships F11el & lube Fuel & lube 10/28/2019 10/28/19 P 10 135-60150-010-000 Wholesale Water 10 of 120 tare Item CneC1C (.S1e7K Value umber Date 230.00 5866 10/29/19 547.40 6,676.20 5867 10/29/19 10,092.60 5867 10/29/19 16,768.80 192.41 5868 10/29/19 192.41 668.00 5869 10/29/19 668.00 567.40 5870 10/29/19 567.40 9,888.02 5871 10/29/19 9,888.02 100.00 5872 10/29/19 100.00 773.48 923.61 1,697.09 199,481.56 199,481.56 1,128,680.16 5873 10/29/19 5873 10/29/19 5874 10/30/19 November 14, 2019 Regular Meeting Agenda Packet REGULAR MEETING MINUTES TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 BOARD OF DIRECTORS October 21, 2019 at 6:30 P.M. Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in Regular Session on October 21, 2019 at 6:30 P.M., in the Boardroom of the Administration Building, 100 Municipal Drive, Trophy Club, Texas 76262. The meeting was held within the boundaries of the District and was open to the public. STATE OF TEXAS § COUNTIES OF DENTON AND TARRANT § BOARD MEMBERS PRESENT: Gregory Wilson President William C. Rose Vice President Steve Flynn Secretary/Treasurer Kelly Castonguay Director Mark Chapman Director STAFF PRESENT: John Carman Laurie Slaght Mike McMahon Steven Krolczyk Tony Corbett General Manager District Secretary Operations Manager Finance Manager Legal Counsel CALL TO ORDER AND ANNOUNCE A QUORUM President Wilson announced the date of Monday, October 21, 2019, announced a quorum present and called the meeting to order at 6:31 p.m. CITIZEN COMMENTS There were no citizen comments 1. Consider and take appropriate action to approve the Consent Agenda. a. September Check Register b. September 16, 2019 Regular Meeting minutes c. Tax Collection Report — 4th Quarter FY2019 d. Quarterly Investment Report -4th Quarter FY2019 e. Wholesale Water Customer Advisory Committee Appointment Form Motion made by Director Flynn and seconded by Director Chapman to approve the consent agenda. Motion carried unanimously REGULAR SESSION 2. Consider and take appropriate action regarding Annexation Matters: a. Consider Petition for Annexation of approximately 1.0055 acres of land situated in the J. Michael 11 of 120 November 14, 2019 Regular Meeting Agenda Packet Survey, Abstract No. 821 of the Town of Trophy Club, Denton County, Texas and submitted by McJunkin Signature Homes LLC, a Texas Limited Liability Corporation. b. Consider and take appropriate action to adopt Order No. 2019-1021A approving annexation of approximately 1.0055 acres of land situated in the J. Michael Survey, Abstract No. 821 of the Town of Trophy Club, Denton County, Texas and submitted by McJunkin Signature Homes LLC, a Texas Limited Liability Corporation. c. Consider and take appropriate action to approve Amendment of District Information Form including updated District boundary description and map that incorporates the annexed property. Motion made by Director Rose and seconded by Director Flynn to adopt Order No. 2019-1021A approving annexation of approximately 1.0055 acres of land situated in the J. Michael Survey, Abstract No. 821 of the Town of Trophy Club, Denton County, Texas as submitted by McJunkin Signature Homes LLC, a Texas Limited Liability Corporation and approve amendment of District Information Form including updated District boundary description and map that incorporates the annexed property. Motion carried unanimously 3. Consider and take appropriate action to adopt Order No. 2019-1021B Declaring certain scrap metal to be Surplus Property and Authorizing the Disposition Thereof. Motion made by Director Rose and seconded by Director Castonguay to adopt Order No. 2019-1021B Declaring certain scrap metal Surplus Property and Authorizing the Disposition thereof. Motion carried unanimously 4. Consider and take appropriate action regarding approval of acquisition of a 2020 Dodge Ram 2500 Reg Cab truck for the water department to be purchased through the Buy Board contract at Grapevine Dodge Chrysler Jeep for an amount not to exceed $30,114 and authorize the General Manager to execute the necessary documents to complete the vehicle purchase. Motion made by Director Chapman and seconded by Director Castonguay to approve the acquisition of a 2020 Dodge Ram 2500 Regular Cab truck for the water department to be purchased through the Buy Board contract at Grapevine Dodge Chrysler Jeep for an amount not to exceed $30,114 and authorize the General Manager to execute the necessary documents to complete the vehicle purchase. Motion carried unanimously 5. Consider and take appropriate action regarding the September 2019 Combined Financials and Variance Report. a. Combined Financials b. Combined Variance 12 of 120 November 14, 2019 Regular Meeting Agenda Packet Motion made by Director Flynn and seconded by Director Chapman to approve the September 2019 Combined Financials and Variance Report. Motion carried unanimously 6. Discussion regarding availability of property tax ceiling or exemption for District residents over 65 or disabled. (Corbett) District Legal Counsel, Tony Corbett stated that at a previous meeting a resident asked the board to consider a tax freeze or ceiling for ages 65 and over. Corbett stated that school districts have a mandatory tax freeze and counties and municipalities have the authority to do so under the discretion of their governing bodies. Corbett stated that there is no statutory authority for a water district to impose a tax freeze or set a tax ceiling and therefore the Board could not consider this option. The District does have the authority to grant an exemption for residents who are age 65 or over or disabled. The minimum exception is $3,000. The exemption can be done on the initiative of the Board of directors or by petition of the taxpayers. The District currently has an exemption of $25,000 for those age 65 and older or disabled persons. 7. Consider and take appropriate action necessary to authorize the acquisition by purchase or condemnation of easements required for the construction and operation of Water Transmission Line Improvements from District Pump Station to Elevated Water Tank located on T.W. King Road. a. Approve engagement of Jackson Walker LLP as special condemnation counsel. b. Authorize such other actions as may be necessary to proceed with purchase or condemnation of easements. Motion made by Director Chapman and seconded by Director Flynn to authorize the acquisition by purchase or condemnation of easements required for the construction and operation of Water Transmission Line Improvements from District Pump Station to Elevated Water Tank located on T.W. King Road and to Approve engagement ofJackson Walker LLP as special condemnation counsel and to authorize such other actions as may be necessary to proceed with purchase or condemnation of easements. For: Rose, Castonguay, Chapman, Flynn Oppose: Wilson Motion passed 4-1 REPORTS & UPDATES 8. Receive report from General Manager Hiring Committee. (Castonguay/Flynn) Director Flynn provided an update to the Board. 13 of 120 November 14, 2019 Regular Meeting Agenda Packet 9. 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 report to the Board and answered questions related thereto. The Board of Directors convened into Executive Session at 7:32 p.m. EXECUTIVE SESSION 10. 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 11. 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 14 of 120 November 14, 2019 Regular Meeting Agenda Packet Improvements from District Pump Station to Elevated Water Tank located on T.W. King Road 12. 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 of Directors Reconvened into Regular Session at 8:12 p.m. REGULAR SESSION 13. Consider and take appropriate action on matters deliberated in Executive Session: No actions were taken 14. Items for future agendas: 15. Set future Meeting dates: a. Regular Board Meeting — Monday, November 18, 2019 at 6:30 p.m. ADJOURN Motion made by Director Flynn and seconded by Director Castonguay to adjourn. Director Wilson called the meeting adjourned at 8:13 p.m. Gregory Wilson, President Steve Flynn, Secretary/Treasurer Laurie Slaght, District Secretary 15 of 120 (SEAL) TROPHY CLUB MUNICIPAL UTILITY DISTRICT STAFF REPORT November 14, 2019 — Board of Directors Regular Meeting Regular Session Agenda Item No. 6 Staff Report: November 14, 2019 Regular Meeting Agenda Packet The current medical benefit packages offered by the District terminates on December 31, 2019. Dean Casey and Associates, the District's insurance broker, has secured two quotes for these benefits for the period beginning January 1, 2020 and ending on December 31, 2020. The quotes received are from our current insurer, UHC All Savers and BCBS. The current ancillary benefit package offered by the District terminates on December 31, 2019. Dean Casey and Associates, the District's insurance broker, has secured three quotes for these benefits for the period beginning January 1, 2020 and ending on December 31, 2020. The quotes received are from our current insurers, MetLife and Humana, and also Unum. The ancillary coverage includes: dental, vision, life, long term disability and short term disability coverages. Staff has provided an ancillary benefit comparison sheet for the Board's review. Staff Recommendation: Staff recommends staying with UHC All Savers for medical benefits and staying with Humana and MetLife Insurance for ancillary benefits based on the benefits offered, renewal rates, and the adopted FY2020 budget. 16 of 120 November 14, 2019 Regular Meeting Agenda Packet Carrier UHC All Savers UIHC All Savers Plan P15003060e P30003060e Network Choice Plus Choice Plus Prescription Card 30 day supply $15 Generic/$35 Brand/$75 Non Formulary Brand/$250 Specialty $15 Generic/$35 Brand/$75 NFBrand/$250 Spec Annual Deductible In Network $1,500 Individual/$3,000 Family $3,000 Individual/$6,000 Family Coinsurance 100% In Network / 50% Out of Network 100% In Network / 50% Out of Network Out of Pocket Max includes Deductible $4,000 Individual / $8,000 Family $5,500 Individual / $14,000 Family Doctor's Office Visit $30 Primary Care Physician/$60 Specialist/ Free Virtual Visits $30 Primary Care Physician/$60 Specialist/ Free Virtual Visits Preventive 100% No Copay 100% No Copay Hospital Emergency $300 Copay + Deductible + 100% $300 Copay + Deductible + 100% Urgent Care Facility $100 Copay Physician/$100 Copay Facility $100 Copay Physician/$100 Copay Facility Maternity Yes Yes Medical Benefits out of Network Yes Yes Rate Guarantee RENEWAL RATES RENEWAL RATES Employee $ 918.52 $ 812.87 Employee/Spouse $ 1,884.90 $ 1,663.06 Employee/Child $ 1,709.20 $ 1,508.48 Employee/Family $ 2,763.43 $ 2,435.94 Current Total MUD Annual Cost $ 209,321.76 Renewal Total MUD Annual Cost $ 270,692.64 FY 2020 Budget $ 313,578.15 Carrier BCBS of Texas BCBS of Texas Plan G650CHC G653CHC Network ppo PPO Prescription Card 30 day supply $10 Generic -Non Pref $20/$70 Brand -Non Pref $120/$150 Pref Spec -Non Pref $250 $10 Generic -Non Pref $20/$70 Brand -Non Pref $120/$150 Pref Spec -Non Pref $250 Annual Deductible In Network $3,000 Individual/$9,000 Family $1,500 Individual/$4,500 Family Coinsurance 100% In Network/80% Out Network 80% Individual/60% Out of Network Out of Pocket Max Includes Deductible $3,000 Individual/$9,000 Family $6,000 Individual/$12,000 Family Doctor's Office Visit $30 Primary Care Physician/$50 Specialist/ Virtual Visits $30 Primary Care Physcian/$60 Specialist/$30 Virtual Visit Preventive 100% No Copay 100% No Copay Hospital Emergency $400 Copay + Deductible + 80% In or Out of Network $400 Copay + Dedutible + 80% In or Out of Network Urgent Care Facility $30 Copay $30 Copay No Deductible Maternity Yes Yes Medical Benefits out of Network Yes Yes Employee $ 930.92 $ 880.87 Employee/Spouse $ 1,861.84 $ 1,761.74 Employee/Child(ren) $ 1,861.84 $ 1,761.74 Family $ 2,792.76 $ 2,642.61 Current Total MUD Annual Cost $ 209,321.76 Proposed MUD Annual Cost $ 292,905.24 FY 2020 Budget $ 313,578.15 17 of 120 Humana Employer Paid Dent Freedom of Choice Dentist or Netw ,rk 100%/80%/50%/50% 90% U&C Unlimited Annual Max $50 Deductible/$150 Family Child Ortho Max 51,500 Endo,Perio,Oral Surg at 80% Basic Composite Fillings and Implants Employer Paid Vision 510 Exam/$15 Material copay $130 Frame Allowance 5130 Contact Allowance 12/12/12/12 Frequency Employer Paid Life 2 X Annual Salary with AD&D Max 5100,000 Employee Employee/Spouse Employee/Child(ren) Family Current Total MUD Annual Co Renewal Total MUD Annual Cot FY 2020 Budget Employee $ Employee/Spouse $ Employee/Child(ren) $ Family $ Current Total MUD Annual Co Renewal Total MUD Annual Cot FY 2020 Budget Employee Curren, RENEWAL 33.15 $ 38.06 66.30 $ 76.11 93.78 $ 106.29 128.93 $ 146.95 $ 13,643.40 $ 15,589.62 $ 17,011.95 Curren, RENEWAL 6.59 $ 6.98 13.18 5 13.97 12.52 $ 13.27 19.68 5 20.85 $ 2,235.42 5 2,368.62 $ 2,751.38 Current RENEWAL .28 per $1,000 .33 per $1,000 Humana Voluntary Employee Paid Life AD& Less than 30 30 to 34 35 to 39 40 to 44 45 to 49 50 to 54 55 to 59 60 to 64 65 to 69 70 plus Children Employee Paid ST Disability Jay Accident/ 7 Day Illness,13 Wee! 60% to 51,000 Weekly Benef Employer Paid LT Disabili 90 Day Elimination 60% to $5,000 to Age 6! 5100,000 coverage 5100,000 coverage 5100,000 coverage 5100,000 coverage 5100,000 coverage 5100,000 coverage 5100,000 coverage 5100,000 coverage 5100,000 coverage 5100,000 coverage 510,000 of each child Met Life Employee Employee Current No Increase Rate Held Current Employee Spouse .12 $12.0c .10 $10.00 .13 $13.0C .11 $11.00 .16 $16.0c .13 $13.00 .23 $23.0C .18 $18.00 .33 $33.0C .27 $27.00 .51 $51.0C .41 $41.00 .81 $81.0C .63 $63.00 1.12 $112.0C .87 587.00 1.83 $183.0c 1.42 5142.00 3.54 $354.0C 2.74 $274.00 .20 $2.1 .20 52. Age Banded Rates- No Increase Rate Hel No limit to participa e Curren! .461 per $100 No Increase Rate Hel November 14, 2019 Regular Meeting Agenda Packet Unum Employer Paid Dents Freedom of Choice Dentist or Networ! 100%/80%/50%/50% 90% U&C $5,000 ANNUAL MAX 550 Deductible/$150 Family Child Ortho Max 51,500 Endo,Perio,Oral Surg at 80% Basic Composite Fillings and Implants Employer Paid Vision 510 Exam/$10 Material copay 5130 Frame Allowance 5130 Contact Allowance 12/12/12/12 Frequency Employer Paid Life 2 X Annual Salary with AD&D Max 5100,000 Voluntary Employee Paid Life AD&D Less than 30 30 to 34 35 to 39 40 to 44 45 to 49 50 to 54 55 to 59 60 to 64 65 to 69 70 plus Children Employee Paid ST Disability 0 Day Accident/ 7 Day Illness,13 Weeks 60% to $1,000 Weekly Benef Employer Paid LT Disabili 90 Day Elimination 60% to $5,000 to Age 6! 18 of 120 Employee Employee/Spouse Employee/Child(ren) Family Current Total MUD Annual Cos Proposed Total MUD Annual Cc :t FY 2020 Budget Employee $ Employee/Spouse 5 Employee/Child(ren) $ Family 5 Current Total MUD Annual Co! Proposed Total MUD Annual Cc 1 FY 2020 Budget Employee 5100,000 coverage $100,000 coverage 5100,000 coverage $100,000 coverage 5100,000 coverage $100,000 coverage 5100,000 coverage $100,000 coverage 5100,000 coverage $100,000 coverage 510,000 of each child Employee Employee Curren, RENEWAL 33.15 $ 25.91 66.30 $ 50.84 93.78 $ 65.60 128.93 $ 97.90 $ 13,643.40 5 10,328.46 $ 17,011.95 Curren, RENEWAL 6.59 $ 5.66 13.18 $ 11.32 12.52 $ 12.39 19.68 $ 19.47 $ 2,235.42 5 2,021.16 $ 2,751.38 Current -Humana Unum .28 per $1,000 .34 per 51,000 Current- 7umana Employee 512.00 $13.00 516.00 $23.00 $33.00 551.00 $81.00 $112.0C $183.0c $354.0C 52.1 .12 .13 .16 .23 .33 .51 .81 1.12 1.83 3.54 .20 Current -Humana Age ttanaea Kates- N limit to participate Current .461 per 5100 Spouse .10 $10.0C .11 $11.0C .13 $13.0c .18 $18.0C .27 $27.0c .41 $41.00 .63 563.00 .87 587.0, 1.42 5142.0, 2.74 $274.0, .20 $2. Unum Aged Banded Rates 10 employees musi participate for STD t be issued .46 per 5100 Unum Emplyoee & Spouse - Same Rate for Each .114 .148 .212 .326 .513 .757 1.099 1.436 2.029 3.838 .25 $2.. 511.40 $14.80 521.20 532.60 $51.30 575.70 5109.90 $143.60 5202.90 5383.80 November 14, 2019 Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET OCTOBER 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,851 18,050 1,247,487 TOTAL ASSETS 1,595,388 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 19 of 120 1,247,493 1,247,493 603,769 (255,874) 347,895 1,595,388 glbase_tbam skrolczyk 17:07 11/07/19 Fund: 122 Trophy Club MUD Fire Dept. Account 1 1 122-40010-000-000 1 122-40011-000-000 1 Description Property Taxes/MUD Fire Property Taxes/Fire-Delinquent Trophy Club MUD No.1 Budget Summary with Amendment Department: Fire Revenues Period Ending: 10/2019 Program: Page 1 November 14, 2019 Regular Meeting Agenda Packet Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1,214,230.00- 1,214,230.00- 15,522.86- 1,367.73 15,522.86- 1,367.73 1.278 1,198,707.14- 1,367.73- 122-40020-000-000 Property Taxes/Fire P&i 68.47- 68.47- 68.47 Subtotal: 1,214,230.00- 1,214,230.00- 14,223.60- 14,223.60- 1.171 1,200,006.40 - Program number: 1,214,230.00- 1,214,230.00- 14,223.60- 14,223.60- 1.171 1,200,006.40 - Department number: Fire Revenues 1,214,230.00- 1,214,230.00- 14,223.60- 14,223.60- 1.171 1,200,006.40 - Revenues Subtotal 1,214,230.00- 1,214,230.00- 14,223.60- 14,223.60- 1.171 1,200,006.40- 20 of 120 glbase_tbam skrolczyk 17:07 11/07/19 Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Trophy Club MUD No.1 Page 2 Budget Summary with Amendment 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 Subtotal: 122-69005-045-000 122-69009-045-000 122-69195-045-000 122-69305-045-000 Subtotal: Program number: Capital Outlays Short Term Debt -Interest GASB34/Reserve for Replacement Capital Leases Department number: Fire Expenditures Subtotal Fund number: 122 Trophy Club MUD Fire Dept. 239,004.00 239,004.00 48,000.00 48,000.00 81,420.00 81,420.00 127,149.00 127,149.00 256,569.00 256,569.00 495,573.00 495,573.00 495,573.00 495,573.00 718,657.00- 495,573.00 495,573.00 718,657.00- 21 of 120 1,640.88 1,640.88 59,888.08 59,888.08 61,528.96 61,528.96 11,958.24 11,958.24 81,420.00 81,420.00 115,190.36 115,190.36 208,568.60 208,568.60 270,097.56 270,097.56 270,097.56 270,097.56 270,097.56 270,097.56 255,873.96 255,873.96 7.814 25.744 100.000 90.595 81.291 54.502 54.502 54.502 -35.604 218,004.00 19,359.12 59,888.08- 177,475.04 48,000.00 11,958.24- 11,958.64 48,000.40 225,475.44 225,475.44 225,475.44 974,530.96- glpdatb2 skrolczyk Trophy Club MUD No.1 Page 1 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/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 1 188 10/02/2019 Property Taxes 191 10/08/2019 Property Taxes 192 10/09/2019 Property Taxes 193 10/10/2019 Property Taxes 194 10/11/2019 Property Taxes 196 10/15/2019 Property Taxes 197 10/16/2019 Property Taxes 198 10/17/2019 Property Taxes 199 10/18/2019 Property Taxes 200 10/21/2019 Property Taxes 201 10/22/2019 Property Taxes 202 10/24/2019 Property Taxes 203 10/25/2019 Property Taxes 204 10/28/2019 Property Taxes 205 10/29/2019 Property Taxes 206 10/30/2019 Property Taxes 207 10/31/2019 Property Taxes (48.87) (48.87) GL (461.55) (510.42) GL (165.03) (675.45) GL (241.22) (916.67) GL (828.17) (1,744.84) GL (228.14) (1,972.98) GL (8.15) (1,981.13) GL (415.89) (2,397.02) GL (716.66) (3,113.68) GL (896.42) (4,010.10) GL (186.42) (4,196.52) GL (1,275.47) (5,471.99) GL (555.43) (6,027.42) GL (6,276.64) (12,304.06) GL (388.32) (12,692.38) GL (1,119.70) (13,812.08) GL (1,710.78) (15,522.86) GL Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (15,522.86) (15,522.86) ** (1,214,230.00) Budgeted (1,198,707.14) Remaining 1 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 189 10/03/2019 Property Taxes 190 10/07/2019 Property Taxes 193 10/10/2019 Property Taxes 194 10/11/2019 Property Taxes 196 10/15/2019 Property Taxes 199 10/18/2019 Property Taxes 201 10/22/2019 Property Taxes 202 10/24/2019 Property Taxes 203 10/25/2019 Property Taxes 205 10/29/2019 Property Taxes 206 10/30/2019 Property Taxes 942.30 942.30 GL (15.66) 926.64 GL 33.98 960.62 GL (35.06) 925.56 GL (3.62) 921.94 GL 664.09 1,586.03 GL (180.43) 1,405.60 GL (.52) 1,405.08 GL (10.24) 1,394.84 GL (13.20) 1,381.64 GL (13.91) 1,367.73 GL Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: 1,367.73 1,367.73 ** .00 Budgeted (1,367.73) Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire PSI 190 10/07/2019 Property Taxes 194 10/11/2019 Property Taxes 22 of 120 (3.21) (3.21) GL (7.37) (10.58) GL glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 196 10/15/2019 Property Taxes 201 10/22/2019 Property Taxes 203 10/25/2019 Property Taxes 205 10/29/2019 Property Taxes 206 10/30/2019 Property Taxes (.65) (11.23) GL (48.83) (60.06) GL (1.84) (61.90) GL (1.98) (63.88) GL (4.59) (68.47) GL Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (68.47) (68.47) ** Department Totals: .00 Budgeted (14,223.60) Monthly Total 68.47 Remaining 0 % Used (14,223.60) ** (1,214,230.00) Budgeted (1,200,006.40) Remaining 1 % Used 23 of 120 glpdatb2 skrolczyk 17:07 11/07/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: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/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 66 10/01/2019 Insurance/Wrk Comp Expense Oct Account: 122-60055-045-000 Account: 122-60337-045-000 48 10/11/2019 October A/P Account: 122-60337-045-000 218,004.00 Remaining 0 % Used Insurance Totals: 21,000.00 Budgeted 19,359.12 Remaining Transfer to Town/Fire Budget Fire admin -Oct Transfer to Town/Fire Budget Totals: .00 Budgeted (59,888.08) Remaining .00 .00 .00 .00 ** 1,640.88 1,640.88 GL 8 % Used 1,640.88 1,640.88 ** 59,888.08 59,888.08 TOWN OF TROPHY CLUB 5821 AP 0 % Used 59,888.08 59,888.08 ** Account: 122-69005-045-000 Capital Outlays .00 .00 Account: 122-69005-045-000 Capital Outlays Totals: .00 .00 ** 48,000.00 Budgeted 48,000.00 Remaining 0 % Used Account: 122-69009-045-000 Short Term Debt -Interest 129 10/11/2019 Sep Out Int/Prin Fire Trk FY20 Seperate Interest in Cap Lease 11,958.24 11,958.24 GL Account: 122-69009-045-000 ' Short Term Debt -Interest Totals: 11,958.24 11,958.24 ** .00 Budgeted (11,958.24) Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 151 10/01/2019 GASB 34 Transfers FY 2020 Fire Truck Future Replacement 81,420.00 81,420.00 GL Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: 81,420.00 81,420.00 ** 81,420.00 Budgeted .00 Remaining 100 % Used Account: 122-69305-045-000 Capital Leases 24 of 120 glpdatb2 skrolczyk 17:07 11/07/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 Detailed Accounting Trial Balance Program: Page 4 November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) 48 10/11/2019 October A/P lease payment FD ladder -T681 129 10/11/2019 Sep Out Int/Prin Fire Trk FY20 127,148.60 (11,958.24) 127,148.60 PNC Bank, N.A. 115,190.36 5820 AP GL Account: 122-69305-045-000 Capital Leases Totals: 115,190.36 115,190.36 ** 127,149.00 Budgeted 11,958.64 Remaining 91 % Used Department 45 Totals: Fund 122 Totals: 270,097.56 Monthly Total 495,573.00 Budgeted 270,097.56 ** 225,475.44 Remaining 55 % Used 255,873.96 255,873.96 Monthly Total (718,657.00) Budgeted (974,530.96) Remaining -36 % Used 25 of 120 TROPHY CLUB MUD #1 - O&M (GENERAL FUND) BALANCE SHEET OCTOBER 2019 November 14, 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,298,274 2,298,274 CASH IN BANK -SAVINGS -CASH RESERVE 1,397,251 1,397,251 INVESTMENTS-TEXPOOL 4,317,837 919,266 5,237,103 PREPAID EXPENSES 102,342 102,342 ADVALOREM PROPERTY TAXES RECEIVABLE 138,406 138,406 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,190,325 1,190,325 TOTAL ASSETS 9,445,035 919,266 10,364,301 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 138,406 138,406 ACCOUNTS AND OTHER PAYABLES 373,176 373,176 CUSTOMER DEPOSITS 319,829 319,829 TOTAL LIABILITIES 831,411 831,411 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 212,239 212,239 TOTAL FUND BALANCE 8,613,624 919,266 9,532,890 TOTAL LIABILITIES AND FUND BALANCE 9,445,035 919,266 10,364,301 26 of 120 glbase_tbam skrolczyk 17:07 11/07/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: 10/2019 Amended Total Budget Encumb. 134,871.00- 300.00- 300.00- 164,253.00- Current Month Program: YTD Total 1,723.24- 1,723.24- 155.66 155.66 7.82- 7.82- Page 3 November 14, 2019 Regular Meeting Agenda Packet % of Budget 1.278 -51.887 2.607 Remaining Budget 133,147.76- 455.66- 292.18- 164,253.00- Subtotal: 299,724.00- 299,724.00- 1,575.40- 1,575.40- .526 298,148.60- 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 Subtotal: 135-49011-000-000 135-49016-000-000 135-49018-000-000 135-49026-000-000 135-49075-000-000 135-49900-000-000 Water Sewer Penalties Service Charges Plumbing Inspections Sewer Inspections TCCC Effluent Charges Interest Income Cell Tower Revenue Building Rent Income Proceeds from Sale of Assets Oversize Meter Reimbursement Miscellaneous Income Subtotal: Program number: Department number: Revenues Revenues Subtotal 6,486,623.00- 3,503,885.00- 112,608.00- 15,150.00- 750.00- 2,500.00- 50,000.00- 10,171,516.00- 120,000.00- 14,146.00- 7,000.00- 13,000.00- 12,691.00- 7,000.00- 173,837.00- 10,645,077.00- 10,645,077.00- 10,645,077.00 - 6,486,623.00- 3,503,885.00- 112,608.00- 15,150.00- 750.00- 2,500.00- 50,000.00- 10,171,516.00- 120,000.00- 14,146.00- 7,000.00- 13,000.00- 12,691.00- 7,000.00- 173,837.00- 10,645,077.00- 10,645,077.00- 10,645,077.00- 27 of 120 536,379.28- 536,379.28- 221,960.36- 221,960.36- 9,981.43- 9,981.43- 1,075.00- 1,075.00- 1,800.00- 1,800.00- 400.00- 400.00- 15,036.00- 15,036.00- 786,632.07- 786,632.07- 11,765.78- 11,765.78- 583.33- 583.33- 5,355.28- 5,355.28- 7,372.29- 7,372.29- 25,076.68- 813,284.15- 813,284.15- 813,284.15- 25,076.68- 813,284.15- 813,284.15- 813,284.15 - 8.269 6.335 8.864 7.096 240.000 16.000 30.072 5,950,243.72- 3,281,924.64- 102,626.57- 14,075.00- 1,050.00 2,100.00- 34,964.00- 7.734 9,384,883.93- 9.805 8.333 42.197 105.318 14.425 7.640 7.640 7.640 108,234.22- 14,146.00- 6,416.67- 13,000.00- 7,335.72- 372.29 08,234.22-14,146.00-6,416.67-13,000.00- 7,335.72- 372.29 148,760.32- 9,831,792.85- 9,831,792.85- 9,831,792.85- glbase_tbam skrolczyk 17:07 11/07/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: 10/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 November 14, 2019 Regular Meeting Agenda Packet 10,227.68 10,227.68 2.920 821.89 821.89 4.835 350.00 350.00 6.481 2,135.12 2,135.12 6.124 3,821.04 3,821.04 4.531 243.97 243.97 5.163 38.90 38.90 5.072 189.67 189.67 6.056 693.28 693.28 2.969 162.14 162.14 2.969 .80 .80 .074 771.49 771.49 6.510 Remaining Budget 340,039.32 16,178.11 3,920.00 5,050.00 32,727.88 80,504.96 4,481.03 728.10 2,942.33 22,654.72 5,298.86 1,079.20 11,078.51 400.00 300.00 Subtotal: 546,839.00 546,839.00 19,455.98 19,455.98 3.558 527,383.02 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 2,926.83 2,926.83 2.927 207.88 207.88 4.158 87.50 87.50 8.750 20,000.00 97,073.17 3,000.00 4,792.12 3,500.00 912.50 7,500.00 Subtotal: 140,000.00 140,000.00 3,222.21 3,222.21 2.302 136,777.79 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 28 of 120 364.16 364.16 7.283 14,721.00 14,721.00 11.713 295.00 295.00 3.973 462.00 47,943.74 4,600.00 462.00 47,943.74 4,600.00 15.400 9.091 8.334 4,635.84 110,956.00 1,000.00 500.00 7,131.00 400.00 2,845.00 1,500.00 63,000.00 2,714,710.00 200.00 2,538.00 14,750.00 479,437.26 50,593.00 180,000.00 glbase_tbam skrolczyk 17:07 11/07/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: 10/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 29 of 120 Current Month Program: YTD Total 68,385.90 68,385.90 773.48 773.48 819.99 819.99 1,689.24 1,689.24 8,875.28 8,875.28 12,157.99 12,157.99 18,651.60 75,000.00 93,651.60 196,873.68 18,651.60 75,000.00 93,651.60 196,873.68 November 14, 2019 Regular Meeting Agenda Packet % of Budget 1.846 5.157 15.799 8.446 12.679 6.098 2.723 100.000 10.251 3.576 Remaining Budget 2,500.00 3,636,696.10 14,226.52 4,370.01 18,310.76 1,200.00 1,000.00 61,124.72 87,000.00 187,232.01 666,223.40 30,512.00 3,231.00 120,000.00 819,966.40 5,308,055.32 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 6 17:07 11/07/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis fo400Dnber14,2019 Regular Meeting Agenda Packet Period Ending: 10/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 30 of 120 196,873.68 196,873.68 3.575 2,000.00 2,000.00 2,000.00 5,310,055.32 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7 17:07 11/07/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/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 135-50010-020-000 Overtime 33,000.00 33,000.00 135-50016-020-000 Longevity 8,035.00 8,035.00 135-50017-020-000 Certification 9,000.00 9,000.00 135-50020-020-000 Retirement 45,531.00 45,531.00 135-50026-020-000 Medical Insurance 104,858.00 104,858.00 135-50027-020-000 Dental Insurance 5,817.00 5,817.00 135-50028-020-000 Vision Insurance 948.00 948.00 135-50029-020-000 Life Insurance & Other 4,500.00 4,500.00 135-50030-020-000 Social Security Taxes 30,494.00 30,494.00 135-50035-020-000 Medicare Taxes 7,132.00 7,132.00 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 135-50045-020-000 Workman's Compensation 15,373.00 15,373.00 135-50060-020-000 Pre-emp Physicals/Testing 400.00 400.00 135-50070-020-000 Employee Relations 300.00 300.00 Subtotal: 708,447.00 708,447.00 135-55005-020-000 Engineering 30,000.00 30,000.00 135-55070-020-000 Independent Labor 15,000.00 15,000.00 135-55080-020-000 Maintenance & Repairs 88,000.00 88,000.00 135-55081-020-000 Mainten & Re/Pairs Collections 10,000.00 10,000.00 135-55085-020-000 Generator Maint. and Repair 10,000.00 10,000.00 135-55090-020-000 Vehicle Maintenance 4,000.00 4,000.00 135-55091-020-000 Veh Maintenance Collections 8,000.00 8,000.00 135-55105-020-000 Maintenance-Backhoe/SkidLoader 3,000.00 3,000.00 135-55120-020-000 Cleaning Services 1,500.00 1,500.00 135-55125-020-000 Dumpster Services 100,000.00 100,000.00 135-55135-020-000 Lab Analysis 40,000.00 40,000.00 Subtotal: 309,500.00 309,500.00 12,956.76 649.08 625.00 2,854.98 5,987.13 358.15 59.22 337.14 803.96 188.01 12,956.76 649.08 625.00 2,854.98 5,987.13 358.15 59.22 337.14 803.96 188.01 1,110.20 1,110.20 25,929.63 25,929.63 3,704.54 7,925.25 47.02 856.24- 87.50 4,806.24 2,389.60 3,704.54 7,925.25 2.933 1.967 6.944 6.270 5.710 6.157 6.247 7.492 2.636 2.636 7.222 3.660 4.210 79.253 47.02 1.176 856.24- 87.50 4,806.24 2,389.60 18,103.91 18,103.91 135-60010-020-000 Communications/Mobiles 5,000.00 5,000.00 372.84 372.84 135-60020-020-000 Electricity 160,067.00 160,067.00 11,761.29 11,761.29 135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 135-60070-020-000 Dues & Memberships 300.00 300.00 135-60080-020-000 Schools & Training 4,990.00 4,990.00 840.00 840.00 16.834 135-60090-020-000 Safety Program 1,000.00 1,000.00 135-60100-020-000 Travel & per diem 1,545.00 1,545.00 135-60105-020-000 Rent/Lease Equipment 5,000.00 5,000.00 135-60125-020-000 Advertising 2,500.00 2,500.00 135-60135-020-000 TCEQ Fees & Permits 15,000.00 15,000.00 9,888.02 9,888.02 65.920 -28.541 5.833 4.806 5.974 5.849 7.457 7.348 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 135-60280-020-000 Property Maintenance 5,000.00 5,000.00 31 of 120 428,842.24 32,350.92 8,035.00 8,375.00 42,676.02 98,870.87 5,458.85 888.78 4,162.86 29,690.04 6,943.99 1,260.00 14,262.80 400.00 300.00 682,517.37 30,000.00 15,000.00 84,295.46 2,074.75 10,000.00 3,952.98 8,000.00 3,856.24 1,412.50 95,193.76 37,610.40 291,396.09 4,627.16 148,305.71 200.00 300.00 4,150.00 1,000.00 1,545.00 5,000.00 2,500.00 5,111.98 450.00 5,000.00 glbase_tbam skrolczyk 17:07 11/07/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 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 Department: Adopted Budget 14,000.00 114,563.00 673,867.00 125,187.00 180,000.00 2,000.00 Trophy Club MUD No.1 Budget Summary with Amendment 20 Wastewater Period Ending: 10/2019 Amended Total Budget Encumb. 14,000.00 114,563.00 673,867.00 125,187.00 180,000.00 2,000.00 Current Month Program: YTD Total 10,414.81 10,414.81 61,260.70 61,260.70 5,750.00 5,750.00 Page 8 November 14, 2019 Regular Meeting Agenda Packet % of Budget 9.091 9.091 4.593 Remaining Budget 14,000.00 104,148.19 612,606.30 119,437.00 180,000.00 2,000.00 Subtotal: 1,310,669.00 1,310,669.00 100,287.66 100,287.66 7.652 1,210,381.34 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 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 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 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 32 of 120 923.61 923.61 892.41 892.41 2,825.96 2,825.96 2,983.01 2,983.01 7,624.99 7,624.99 5,789.00 5,789.00 130,000.00 130,000.00 135,789.00 135,789.00 287,735.19 287,735.19 287,735.19 287,735.19 7.389 16.240 14.130 14.915 9.789 1.091 100.000 18.083 9.113 9.113 11,576.39 4,602.59 17,174.04 17,500.00 1,200.00 1,200.00 17,016.99 70,270.01 524,711.00 79,133.00 11,277.00 615,121.00 2,869,685.81 2,869,685.81 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 9 17:07 11/07/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Period Ending: 10/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 33 of 120 1.99 1.99 1.99 1.99 November 14, 2019 Regular Meeting Agenda Packet 6.633 Remaining Budget 28.01 6.633 28.01 150.00 750.00 1,300.00 4,000.00 5,000.00 2,000.00 13,200.00 1.99 1.99 .015 13,228.01 1.99 1.99 .015 13,228.01 glbase_tbam skrolczyk Trophy Club MUD No.1 17:07 11/07/19 Budget Summary with Amendment Page 10 Fund: 135 MUD 1 General Fund Department: 30 Administration Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/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 2,000.00 2,208.00 58,554.00 124,394.00 6,464.00 1,035.00 4,500.00 39,215.00 9,171.00 1,440.00 1,775.00 500.00 8,000.00 628,298.00 2,000.00 2,208.00 58,554.00 124,394.00 6,464.00 1,035.00 4,500.00 39,215.00 9,171.00 1,440.00 1,775.00 500.00 8,000.00 13,565.85 13,565.85 2.159 614,732.15 2,000.00 2,208.00 2,760.64 2,760.64 4.715 55,793.36 5,488.81 5,488.81 4.412 118,905.19 306.40 306.40 4.740 6,157.60 48.77 48.77 4.712 986.23 292.42 292.42 6.498 4,207.58 782.00 782.00 1.994 38,433.00 182.91 182.91 1.994 8,988.09 1,440.00 104.82 104.82 5.905 1,670.18 500.00 178.85 178.85 2.236 7,821.15 Subtotal: 887,554.00 887,554.00 23,711.47 23,711.47 2.672 863,842.53 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 135,000.00 15,000.00 10,000.00 10,000.00 65,600.00 9,000.00 134,681.00 135,000.00 15,000.00 10,000.00 10,000.00 65,600.00 9,000.00 65,525.85 65,525.85 48.653 69,155.15 135,000.00 515.00 515.00 3.433 14,485.00 10,000.00 869.06 869.06 8.691 9,130.94 65,600.00 582.15 582.15 6.468 8,417.85 Subtotal: 379,281.00 379,281.00 67,492.06 67,492.06 17.795 311,788.94 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-60125-030-000 135-60235-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 Advertising Security 23,680.00 4,000.00 6,879.00 1,500.00 30,000.00 67,000.00 1,500.00 84,000.00 1,000.00 6,000.00 400.00 6,000.00 6,850.00 3,545.00 200.00 2,500.00 1,288.00 23,680.00 4,000.00 6,879.00 1,500.00 30,000.00 67,000.00 1,500.00 84,000.00 1,000.00 6,000.00 400.00 6,000.00 6,850.00 3,545.00 200.00 2,500.00 1,288.00 34 of 120 1,479.80 1,479.80 6.249 22,200.20 238.02 238.02 5.951 3,761.98 6,879.00 66.78 66.78 4.452 1,433.22 1,726.61 1,726.61 5.755 28,273.39 7,047.93 7,047.93 10.519 59,952.07 1,500.00 6,998.39 6,998.39 8.331 77,001.61 1,000.00 200.00 200.00 3.333 5,800.00 400.00 349.75 349.75 5.829 5,650.25 777.71 777.71 11.353 6,072.29 91.78 91.78 2.589 3,453.22 200.00 2,500.00 24.00 24.00 1.863 1,264.00 glbase_tbam skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund Account Description 135-60245-030-000 135-60246-030-000 135-60360-030-000 Miscellaneous Expenses General Manager Contingency Furniture/Equipment < $5000 Trophy Club MUD No.1 Budget Summary with Amendment Department: 30 Administration Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Page 11 500.00 17,000.00 2,500.00 500.00 17,000.00 2,500.00 500.00 17,000.00 2,500.00 Subtotal: 266,342.00 266,342.00 19,000.77 19,000.77 7.134 247,341.23 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 561.33 428.00 561.33 428.00 9.356 10.700 2,050.00 26,485.00 5,438.67 3,500.00 3,572.00 2,500.00 Subtotal: 44,535.00 44,535.00 989.33 989.33 2.221 43,545.67 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 253.84 253.84 6.346 3,746.16 Subtotal: 199,000.00 199,000.00 253.84 253.84 .128 198,746.16 Program number: 1,776,712.00 1,776,712.00 111,447.47 111,447.47 6.273 1,665,264.53 Department number: Administration 1,776,712.00 1,776,712.00 111,447.47 111,447.47 6.273 1,665,264.53 35 of 120 glbase_tbam skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund Department: Account Description Adopted Budget 135-55045-039-000 Legal 135,000.00 135-55055-039-000 Auditing 33,800.00 135-55060-039-000 Appraisal 11,761.00 135-55065-039-000 Tax Admin Fees 4,000.00 Trophy Club MUD No.1 Page 12 Budget Summary with Amendment 39 Non Departmental Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/2019 Amended Total Current YTD % of Remaining Budget Encumb. Month Total Budget Budget 135,000.00 33,800.00 11,761.00 4,000.00 5,000.00 13.35- 5,000.00 13.35- 14.793 -.114 135,000.00 28,800.00 11,774.35 4,000.00 Subtotal: 184,561.00 184,561.00 4,986.65 4,986.65 2.702 179,574.35 Program number: 184,561.00 184,561.00 4,986.65 4,986.65 2.702 179,574.35 Department number: Non Departmental 184,561.00 184,561.00 4,986.65 4,986.65 2.702 179,574.35 Expenditures Subtotal 10,638,853.00 10,638,853.00 601,044.98 601,044.98 5.650 10,037,808.02 Fund number: 135 MUD 1 General Fund 6,224.00- 6,224.00- 212,239.17- 212,239.17- 3,410.012 206,015.17 36 of 120 glbase_tbam skrolczyk 17:07 11/07/19 Fund: 137 MUD 1 Consolidated GASB Account Description Department: Adopted Budget Trophy Club MUD No.1 Budget Summary with Amendment Period Ending: 10/2019 Amended Total Current Budget Encumb. Month Program: YTD Total % of Budget Page 13 November 14, 2019 Regular Meeting Agenda Packet Remaining Budget 137-49145-000-000 1 137-49146-000-000 Intergov Transfer -General Fund Intergov Transfer -Fire Dept 205,000.00- 81,420.00- 205,000.00- 81,420.00- 205,000.00 81,420.00 Subtotal: 286,420.00- 286,420.00- 286,420.00 Program number: 286,420.00- 286,420.00- 286,420.00 Department number: 286,420.00- 286,420.00- 286,420.00 Revenues Subtotal 286,420.00- 286,420.00- 286,420.00 Fund number: 137 MUD 1 Consolidated GASB 286,420.00- 286,420.00- 286,420.00 37 of 120 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 5 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/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 188 10/02/2019 Property Taxes 191 10/08/2019 Property Taxes 192 10/09/2019 Property Taxes 193 10/10/2019 Property Taxes 194 10/11/2019 Property Taxes 196 10/15/2019 Property Taxes 197 10/16/2019 Property Taxes 198 10/17/2019 Property Taxes 199 10/18/2019 Property Taxes 200 10/21/2019 Property Taxes 201 10/22/2019 Property Taxes 202 10/24/2019 Property Taxes 203 10/25/2019 Property Taxes 204 10/28/2019 Property Taxes 205 10/29/2019 Property Taxes 206 10/30/2019 Property Taxes 207 10/31/2019 Property Taxes (5.43) (5.43) GL (51.24) (56.67) GL (18.32) (74.99) GL (26.77) (101.76) GL (91.94) (193.70) GL (25.33) (219.03) GL (.90) (219.93) GL (46.17) (266.10) GL (79.56) (345.66) GL (99.51) (445.17) GL (20.70) (465.87) GL (141.59) (607.46) GL (61.66) (669.12) GL (696.78) (1,365.90) GL (43.12) (1,409.02) GL (124.30) (1,533.32) GL (189.92) (1,723.24) GL Account: 135-40000-000-000 Property Taxes Totals: (1,723.24) (1,723.24) ** (134,871.00) Budgeted (133,147.76) Remaining 1 6 Used Account: 135-40002-000-000 Property Taxes/Delinquent 189 10/03/2019 Property Taxes 190 10/07/2019 Property Taxes 193 10/10/2019 Property Taxes 194 10/11/2019 Property Taxes 196 10/15/2019 Property Taxes 199 10/18/2019 Property Taxes 201 10/22/2019 Property Taxes 202 10/24/2019 Property Taxes 203 10/25/2019 Property Taxes 205 10/29/2019 Property Taxes 206 10/30/2019 Property Taxes 107.29 107.29 GL (1.78) 105.51 GL 3.88 109.39 GL (3.99) 105.40 GL (.41) 104.99 GL 75.61 180.60 GL (20.62) 159.98 GL (.06) 159.92 GL (1.17) 158.75 GL (1.50) 157.25 GL (1.59) 155.66 GL Account: 135-40002-000-000 Property Taxes/Delinquent Totals: 155.66 155.66 ** (300.00) Budgeted (455.66) Remaining -52 % Used Account: 135-40015-000-000 Property Taxes/P & I 190 10/07/2019 Property Taxes 194 10/11/2019 Property Taxes 38 of 120 (.37) (.37) GL (.84) (1.21) GL glpdatb2 skrolczyk Trophy Club MUD No.1 17:07 11/07/19 Detailed Accounting Trial Balance Page 6 Fund: 135 MUD 1 General Fund Department: Revenues Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 196 10/15/2019 Property Taxes 201 10/22/2019 Property Taxes 203 10/25/2019 Property Taxes 205 10/29/2019 Property Taxes 206 10/30/2019 Property Taxes (.07) (5.58) (.21) (.22) (.53) (1.28) (6.86) (7.07) (7.29) (7.82) GL GL GL GL GL Account: 135-40015-000-000 Property Taxes/P & I Totals: (536,379.28) (7.82) ** (300.00) Budgeted (292.18) Remaining 3 8 Used Account: 135-40025-000-000 PID Surcharges 135-47005-000-000 Sewer i 119 10/01/2019 Reversed Accrued UB JE2182 29 10/07/2019 UB 10/07/2019 Water adjustment 13B20191007-20191007 User: 172 10/31/2019 UB 10/31/2019 Billing UB20191031-20191031 User: .00 .00 44,805.28 52.00 (266,817.64) Account: 135-40025-000-000 PID Surcharges Totals: Account: .00 .00 ** (221,960.36) (164,253.00) Budgeted (164,253.00) Remaining 0 % Used (3,503,885.00) Budgeted (3,281,924.64) Remaining 6 % Account: 135-47000-000-000 Water Account: 135-47025-000-000 Penalties 119 10/01/2019 Reversed Accrued UB JE2182 29 10/07/2019 UB 10/07/2019 Water adjustment 0820191007-20191007 User: 182 10/15/2019 Adj-16 Timberline Dr UB20191015-20191015 User: 172 10/31/2019 UB 10/31/2019 Billing UB20191031-20191031 User: 123,626.59 17.15 169.02 (660,192.04) 123,626.59 123,643.74 123,812.76 (536,379.28) GL UB UB UB Account: 135-47000-000-000 Water Totals: (536,379.28) (536,379.28) ** (6,486,623.00) Budgeted (5,950,243.72) Remaining 8 % Used Account: 135-47005-000-000 Sewer i 119 10/01/2019 Reversed Accrued UB JE2182 29 10/07/2019 UB 10/07/2019 Water adjustment 13B20191007-20191007 User: 172 10/31/2019 UB 10/31/2019 Billing UB20191031-20191031 User: 44,805.28 52.00 (266,817.64) 44,805.28 44,857.28 (221,960.36) GL UB UB Account: 135-47005-000-000 ■ Sewer Totals: (221,960.36) (221,960.36) ** (3,503,885.00) Budgeted (3,281,924.64) Remaining 6 % Used Account: 135-47025-000-000 Penalties 55 10/14/2019 ub 10/14/2019 Penalty removal UB20191014-20191014 User: 114 10/22/2019 UB 10/22/2019 Penalties 13B20191022-20191022 User: 125 10/24/2019 UB 10/24/2019 Penalty Removal 13B20191024-20191024 User: 149 10/30/2019 UB 10/30/2019 Penalty removal 13820191030-20191030 User: 96.21 (10,315.11) 226.02 11.45 96.21 (10,218.90) (9,992.88) (9,981.43) UB UB UB UB Account: 135-47025-000-000 Penalties Totals: (9,981.43) (9,981.43) ** (112,608.00) Budgeted (102,626.57) Remaining 9 % Used 39 of 120 glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 10/2019 JE Detail Beginning Balance Description/Comment Account: 135-47030-000-000 Service Charges 35 10/08/2019 DB 10/08/2019 Disconnect Fees UB20191008-20191008 User: 124 10/22/2019 UB 10/22/2019 NSF Check UB20191022-20191022 User: Account: 135-47030-000-000 Service Charges (15,150.00) Budgeted (14,075.00) Remaining Account: 135-47035-000-000 Plumbing Inspections 175 10/02/2019 Permits -TC Town Center Assoc 2210 State Hwy 114 175 10/02/2019 176 10/09/2019 177 10/10/2019 177 10/10/2019 178 10/18/2019 178 10/18/2019 Account: 135-47035-000-000 Permits -TC Town Center Assoc Permits-Irrig TC townhome HOA Permits -16 & 29 Katie Lane Permits -16 & 29 Katie Lane permits -CB Jeni Townhomes permits -CB Jeni Townhomes 2210 State Hwy 114 Lot 47X Block A Claire Dr 16 Katie Lane 29 Katie Lane 100 Claire Drive multiple addresses -Claire Dr Plumbing Inspections (750.00) Budgeted Totals: 1,050.00 Remaining 7 % Used Program: Transaction Detail (1,050.00) (25.00) (1,075.00) Page 7 November 14, 2019 Regular Meeting Agenda Packet Transaction Vendor_Name Detail (SUBTOTAL) (1,050.00) (1,075.00) (1,075.00) ** (150.00) (150.00) (300.00) (450.00) (150.00) (600.00) (150.00) (750.00) (150.00) (900.00) (150.00) (1,050.00) (750.00) (1,800.00) 240 % Used (1,800.00) (1,800.00) Trophy Clunb Town Center Assoc Trophy Club Town Center Assoc TC Town Center Townhome HOA Drees Homes Drees Homes CB Jeni Homes CB Jeni Homes Check Source Number UB UB CR CR CR CR CR CR CR Account: 135-47045-000-000 Sewer Inspections 177 10/10/2019 Permits -16 & 29 Katie Lane 177 10/10/2019 Permits -16 & 29 Katie Lane 178 10/18/2019 permits -CB Jeni Townhomes 178 10/18/2019 permits -CB Jeni Townhomes Account: 135-47045-000-000 16 Katie Lane 29 Katie Lane 100 Claire Drive mulitple addresses -Claire Dr Sewer Inspections (2,500.00) Budgeted Totals: (2,100.00) Remaining Account: 135-47070-000-000 TCCC Effluent Charges 172 10/31/2019 UB 10/31/2019 Billing UB20191031-20191031 User: Account: 135-47070-000-000 TCCC Effluent Charges Totals: (50,000.00) Budgeted (34,964.00) Remaining Account: 135-49011-000-000 Interest Income 217 10/31/2019 Bank Interest- October 217 10/31/2019 Bank Interest- October 217 10/31/2019 Bank Interest- October 16 % Used 30 8 Used 40 of 120 (50.00) (50.00) (50.00) (250.00) (400.00) (15,036.00) (15,036.00) (1,001.06) (1,304.16) (9,460.56) (50.00) Drees Homes (100.00) Drees Homes (150.00) CB Jeni Homes (400.00) CB Jeni Homes (400.00) ** (15,036.00) (15,036.00) ** (1,001.06) (2,305.22) (11,765.78) CR CR CR CR UB GL GL GL glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE Number JE Date Account: 135-49011-000-000 JE Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 10/2019 JE Detail Beginning Balance Description/Comment Interest Income (120,000.00) Budgeted Account: 135-49016-000-000 Cell Tower Revenue Account: 135-49016-000-000 Cell Tower Revenue (14,146.00) Budgeted Account: 135-49018-000-000 Building Rent Income 219 10/31/2019 Town Billed Invoices 1710-1713 AR 20191031-20191031 User: Totals: (108,234.22) Remaining Totals: (14,146.00) Remaining Account: 135-49018-000-000 Account: 135-49026-000-000 Account: 135-49026-000-000 Account: 135-49075-000-000 175 10/02/2019 175 10/02/2019 176 10/09/2019 177 10/10/2019 177 10/10/2019 178 10/18/2019 178 10/18/2019 Account: 135-49075-000-000 Building Rent Income (7,000.00) Budgeted Totals: (6,416.67) Remaining Proceeds from Sale of Assets Proceeds from Sale of Assets Totals: (13,000.00) Budgeted (13,000.00) Remaining Oversize Meter Reimbursement Permits -TC Town Center Assoc Permits -TC Town Center Assoc Permits-Irrig TC townhome HOA Permits -16 & 29 Katie Lane Permits -16 & 29 Katie Lane permits -CB Jeni Townhomes permits -CB Jeni Townhomes 2210 State Hwy 114 2210 state hwy 114 Lot 47X Block A Claire Dr 16 Katie Lane 29 Katie Lane 100 Claire Drive multiple addresses -Claire Dr Oversize Meter Reimbursement Totals: (12,691.00) Budgeted (7,335.72) Remaining Account: 135-49900-000-000 Miscellaneous Income 178 10/18/2019 permits -CB Jeni Townhomes 100 Claire Drive 178 10/18/2019 permits -CB Jeni Townhomes various addresses -Claire Dr 172 10/31/2019 UB 10/31/2019 Billing UB20191031-20191031 User: Program: Transaction Detail 10 % Used 0 % Used 8 % Used 0 % Used 42 % Used 41 of 120 (11,765.78) .00 .00 (583.33) (583.33) .00 .00 Page 8 November 14, 2019 Regular Meeting Agenda Packet Transaction Vendor_Name Detail (SUBTOTAL) (11,765.78) ** .00 .00 ** (583.33) (583.33) ** .00 .00 ** (353.00) (353.00) (1,825.28) (2,178.28) (353.00) (2,531.28) (353.00) (2,884.28) (353.00) (3,237.28) (353.00) (3,590.28) (1,765.00) (5,355.28) (5,355.28) (1,200.00) (6,000.00) (172.29) Trophy Clunb Town Center Assoc Trophy Club Town Center Assoc TC Town Center Townhome HOA Drees Homes Drees Homes CB Jeni Homes CB Jeni Homes (5,355.28) ** (1,200.00) CB Jeni Homes (7,200.00) CB Jeni Homes (7,372.29) Check Source Number AR CR CR CR CR CR CR CR CR CR UB glpdatb2 skrolczyk 17:07 11/07/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: 10/2019 Beginning Transaction Transaction Vendor_Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment Page 9 November 14, 2019 Regular Meeting Agenda Packet Check Source Number Account: 135-49900-000-000 Miscellaneous Income Totals: (7,372.29) (7,372.29) ** (7,000.00) Budgeted 372.29 Remaining 105 % Used Department Totals: (813,284.15) Monthly Total (813,284.15) ** (10,645,077.00) Budgeted (9,831,792.85) Remaining 8 % Used 42 of 120 glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Department: Trophy Club MUD No.1 Detailed Accounting Trial Balance 10 Water Period Ending: 10/2019 Beginning Balance JE Detail Description/Comment Account: 135-50005-010-000 Salaries & Wages 5 10/04/2019 MUD Payroll 10/04/2019 Salaries & Wages 87 10/04/2019 Revr Accr Sept FY19 Payroll #1 65 10/18/2019 MUD Payroll 10/18/2019 Salaries & Wages 88 10/18/2019 Revr Accr Sept FY19 Payroll #2 Account: 135-50005-010-000 Salaries 6 Wages 350,267.00 Budgeted Account: 135-50010-010-000 Overtime 5 10/04/2019 MUD Payroll 10/04/2019 Overtime 87 10/04/2019 Revr Accr Sept FY19 Payroll #1 65 10/18/2019 MUD Payroll 10/18/2019 Overtime Account: 135-50010-010-000 Overtime 17,000.00 Budgeted Totals: 340,039.32 Remaining Totals: 16,178.11 Remaining 3 % Used 5 o Used Program: Transaction Detail Page 10 November 14, 2019 Regular Meeting Agenda Packet Transaction Vendor_Name Detail (SUBTOTAL) 9,638.70 9,638.70 (9,638.70) .00 11,382.64 11,382.64 (1,154.96) 10,227.68 10,227.68 10,227.68 ** 889.18 (889.18) 821.89 821.89 889.18 .00 821.89 821.89 ** Check Source Number PR GL PR GL PR GL PR Account: 135-50016-010-000 Longevity Account: 135-50016-010-000 Longevity 3,920.00 Budgeted Account: 135-50017-010-000 Certification 65 10/18/2019 MUD Payroll 10/18/2019 Certification Account: 135-50017-010-000 Certification 5,400.00 Budgeted Account: 135-50020-010-000 Retirement 5 10/04/2019 MUD Payroll 10/04/2019 Retirement 65 10/18/2019 MUD Payroll 10/18/2019 Retirement Account: 135-50020-010-000 Retirement 34,863.00 Budgeted Account: 135-50026-010-000 Medical Insurance 5 10/04/2019 MUD Payroll 10/04/2019 Medical Insurance Totals: 3,920.00 Remaining Totals: 5,050.00 Remaining Totals: 32,727.88 Remaining 0 % Used 6 6 Used 6 6 Used 43 of 120 .00 .00 350.00 350.00 973.82 1,161.30 2,135.12 1,558.33 .00 .00 ** 350.00 350.00 ** PR 973.82 2,135.12 2,135.12 ** 1,558.33 PR PR PR glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 65 10/18/2019 MUD Payroll 10/18/2019 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Period Ending: 10/2019 JE Detail Beginning Balance Description/Comment Medical Insurance Program: Page 11 November 14, 2019 Regular Meeting Agenda Packet Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) 2,262.71 3,821.04 Check Source Number PR 5 10/04/2019 MUD Payroll 10/04/2019 Social Security Taxes 87 10/04/2019 Revr Accr Sept FY19 Payroll #1 65 10/18/2019 MUD Payroll 10/18/2019 Social Security Taxes 88 10/18/2019 Revr Accr Sept FY19 Payroll #2 653.26 (653.26) 763.35 (70.07) 653.26 .00 763.35 693.28 PR GL PR GL Account: 135-50030-010-000 Social Security Taxes Totals: 693.28 693.28 ** 23,348.00 Budgeted 22,654.72 Remaining 3 % Used Account: 135-50035-010-000 Medicare Taxes 5 10/04/2019 MUD Payroll 10/04/2019 Medicare Taxes 87 10/04/2019 Revr Accr Sept FY19 Payroll #1 44 of 120 152.78 152.78 (152.78) .00 PR GL Account: 135-50026-010-000 Medical Insurance Totals: 3,821.04 3,821.04 ** 84,326.00 Budgeted 80,504.96 Remaining 5 % Used Account: 135-50027-010-000 Dental Insurance 5 10/04/2019 MUD Payroll 10/04/2019 Dental Insurance 65 10/18/2019 MUD Payroll 10/18/2019 Dental Insurance 105.42 138.55 105.42 243.97 PR PR Account: 135-50027-010-000 Dental Insurance Totals: 243.97 243.97 ** 4,725.00 Budgeted 4,481.03 Remaining 5 % Used Account: 135-50028-010-000 11111 Vision Insurance 5 10/04/2019 MUD Payroll 10/04/2019 Vision Insurance 65 10/18/2019 MUD Payroll 10/18/2019 Vision Insurance 16.16 22.74 16.16 38.90 PR PR Account: 135-50028-010-000 ' Vision Insurance Totals: 38.90 38.90 ** 767.00 Budgeted 728.10 Remaining 5 % Used Account: 135-50029-010-000 Life Insurance & Other 3 10/15/2019 Payroll Benefits October 3 10/15/2019 Payroll Benefits October 91.11 98.56 91.11 189.67 METLIFE GROUP BENEFITS Humana Inc 5796 5790 AP AP Account: 135-50029-010-000 Life Insurance & Other Totals: 189.67 189.67 ** 3,132.00 Budgeted 2,942.33 Remaining 6 % Used Account: 135-50030-010-000 Social Security Taxes 5 10/04/2019 MUD Payroll 10/04/2019 Social Security Taxes 87 10/04/2019 Revr Accr Sept FY19 Payroll #1 65 10/18/2019 MUD Payroll 10/18/2019 Social Security Taxes 88 10/18/2019 Revr Accr Sept FY19 Payroll #2 653.26 (653.26) 763.35 (70.07) 653.26 .00 763.35 693.28 PR GL PR GL Account: 135-50030-010-000 Social Security Taxes Totals: 693.28 693.28 ** 23,348.00 Budgeted 22,654.72 Remaining 3 % Used Account: 135-50035-010-000 Medicare Taxes 5 10/04/2019 MUD Payroll 10/04/2019 Medicare Taxes 87 10/04/2019 Revr Accr Sept FY19 Payroll #1 44 of 120 152.78 152.78 (152.78) .00 PR GL glpdatb2 skrolczyk 17:07 11/07/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 Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/2019 JE Detail Beginning Transaction Transaction Vendor_Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 12 65 10/18/2019 MUD Payroll 10/18/2019 Medicare Taxes 88 10/18/2019 Revr Accr Sept FY19 Payroll #2 178.53 (16.39) 178.53 162.14 PR GL 45 of 120 Account: 135-50035-010-000 Medicare Taxes Totals: 162.14 162.14 ** 5,461.00 Budgeted 5,298.86 Remaining 3 % Used Account: 135-50040-010-000 Unemployment Taxes 65 10/18/2019 MUD Payroll 10/18/2019 Unemployment Taxes .80 .80 PR Account: 135-50040-010-000 Unemployment Taxes Totals: .80 .80 ** 1,080.00 Budgeted 1,079.20 Remaining 0 % Used Account: 135-50045-010-000 Workman's Compensation 66 10/01/2019 Insurance/Wrk Comp Expense Oct 771.49 771.49 GL Account: 135-50045-010-000 Workman's Compensation Totals: 771.49 771.49 ** 11,850.00 Budgeted 11,078.51 Remaining 7 % 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 Account: 135-55080-010-000 Maintenance & Repairs 45 of 120 glpdatb2 skrolczyk Trophy Club MUD No.1 17:07 11/07/19 Detailed Accounting Trial Balance Page 13 Fund: 135 MUD 1 General Fund Department: 10 Water Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 91 10/17/2019 October A/P 173 10/28/2019 PCards 10/1/19-10/28/19 173 10/28/2019 PCards 10/1/19-10/28/19 173 10/28/2019 PCards 10/1/19-10/28/19 141 10/29/2019 October A/P 141 10/29/2019 October A/P parts infared interface adapter toilet seat adapters, coupling, elbow, tee relays parts 1,132.30 189.00 29.98 45.04 759.51 771.00 1,132.30 Core & Main LP 1,321.30 ACTISYS CORPORATION 1,351.28 THE HOME DEPOT #6581 1,396.32 THE HOME DEPOT #6581 2,155.83 NORTH TEXAS PUMP CO. 2,926.83 Core & Main LP 5834 AP PC PC PC 5864 AP 5852 AP Account: 135-55080-010-000 Maintenance & Repairs Totals: 2,926.83 2,926.83 ** 100,000.00 Budgeted 97,073.17 Remaining 3 % Used 4 % Used Account: 135-55085-010-000 Generator Maint. and Repair Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader .00 .00 Account: 135-55085-010-000 Generator Maint. and Repair Totals: .00 .00 .00 ** 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: 3,000.00 Budgeted 3,000.00 Remaining 0 % Used .00 ** Account: 135-55090-010-000 Vehicle Maintenance 3,500.00 Budgeted 3,500.00 Remaining 0 % Used 173 10/28/2019 PCards 10/1/19-10/28/19 173 10/28/2019 PCards 10/1/19-10/28/19 173 10/28/2019 PCards 10/1/19-10/28/19 173 10/28/2019 PCards 10/1/19-10/28/19 173 10/28/2019 PCards 10/1/19-10/28/19 173 10/28/2019 PCards 10/1/19-10/28/19 Vehicle Registration Vehicle Registration Fee 22IN Trico Force Blades Terra Cair def oil change inspection 8.25 8.25 DENTON VEHREG 2.00 10.25 TX.GOV*SERVICEFEE-DIR 107.96 118.21 ROANOKE AUTO SUPPLY LT 20.00 138.21 ROANOKE AUTO SUPPLY LT 44.17 182.38 KWIK KAR LUBE & TUNE 0 25.50 207.88 KWIK KAR LUBE & TUNE 0 PC PC PC PC PC PC Account: 135-55090-010-000 _ Vehicle Maintenance Totals: 207.88 207.88 ** 5,000.00 Budgeted 4,792.12 Remaining 4 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader .00 .00 Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-55120-010-000 Cleaning Services 224 10/31/2019 October A/P janitorial svc-October 87.50 87.50 MEMBER'S BUILDING MAINTENANCE 5895 AP Account: 135-55120-010-000 Cleaning Services Totals: 87.50 87.50 ** 1,000.00 Budgeted 912.50 Remaining 9 8 Used 46 of 120 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 14 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/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 Lab Analysis Account: 135-55135-010-000 Lab Analysis Totals: 7,500.00 Budgeted 7,500.00 Remaining 0 % Used Account: 135-60010-010-000 _ Communications/Mobiles 48 10/11/2019 October A/P cell phones-Ocotber 173 10/28/2019 PCards 10/1/19-10/28/19 Tablet case Account: 135-60010-010-000 .00 .00 .00 .00 ** 338.17 338.17 VERIZON WIRELESS 5822 AP 25.99 364.16 AMZN MKTP US*RO6FB8QX3 _ Communications/Mobile Totals: NE 364.16 364.16 ** 5,000.00 Budgeted 4,635.84 Remaining 7 % Used PC Account: 135-60020-010-000 Electricity 91 10/17/2019 October A/P Electricity- 9/10-10/10 14,721.00 Account: 135-60020-010-000 Electricity 125,677.00 Budgeted 14,721.00 HUDSON ENERGY SERVICES, LLC 5837 AP 14,721.00 14,721.00 ** 110,956.00 Remaining 12 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining Account: 135-60070-010-000 Dues & Memberships 0 % Used .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 173 10/28/2019 PCards 10/1/19-10/28/19 Clayton H. Water license train 295.00 295.00 NCTCOG RTC TRAINING PC Account: 135-60080-010-000 Schools & Training Totals: 295.00 295.00 ** Account: 135-60090-010-000 7,426.00 Budgeted Safety Program 7,131.00 Remaining 4 % Used 47 of 120 glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 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 Account: 135-60135-010-000 Account: 135-60150-010-000 Account: 135-60150-010-000 Account: 135-60245-010-000 Account: 135-60245-010-000 Trophy Club MUD No.1 Page 15 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 10/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment November 14, 2019 Regular Meeting Agenda Packet .00 .00 Safety Program Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Travel & per diem .00 .00 Travel & per diem Totals: .00 .00 ** 2,845.00 Budgeted 2,845.00 Remaining 0 6 Used Rent/Lease Equipment .00 .00 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 6 Used TCEQ Fees & Permits .00 .00 TCEQ Fees & Permits Totals: .00 .00 ** 63,000.00 Budgeted 63,000.00 Remaining 0 % Used Wholesale Water .00 .00 Wholesale Water Totals: .00 .00 ** 2,714,710.00 Budgeted 2,714,710.00 Remaining 0 6 Used Miscellaneous Expenses .00 .00 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted Account: 135-60280-010-000 Property Maintenance 173 10/28/2019 PCards 10/1/19-10/28/19 cushion sand 200.00 Remaining 0 % Used 48 of 120 126.00 126.00 DENTON SAND & GRAVEL, PC glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 173 10/28/2019 PCards 10/1/19-10/28/19 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Period Ending: 10/2019 JE Detail Beginning Balance Description/Comment top soil Program: Page 16 November 14, 2019 Regular Meeting Agenda Packet Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) 336.00 462.00 DENTON SAND & GRAVEL, Check Source Number PC 49 of 120 Account: 135-60280-010-000 Property Maintenance Totals: 462.00 462.00 ** 3,000.00 Budgeted 2,538.00 Remaining 15 % 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 158 10/31/2019 TexPool Transfers October TexPool O&M to 16Swift Rev I&S 158 10/31/2019 TexPool Transfers October TexPool O&M to 19 W&WW Rev I&S 25,047.72 22,896.02 25,047.72 47,943.74 GL GL Account: 135-60332-010-000 Interfund Transfer Out -Rev I&S Totals: 47,943.74 47,943.74 ** 527,381.00 Budgeted 479,437.26 Remaining 9 % Used Account: 135-60333-010-000 Interfund Transfer Out -Reserve 158 10/31/2019 TexPool Transfers October TexPool O&M to Rev Bond Resevr 4,600.00 4,600.00 GL Account: 135-60333-010-000 Interfund Transfer Out -Reserve Totals: 4,600.00 4,600.00 ** 55,193.00 Budgeted 50,593.00 Remaining 8 % 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 .00 .00 Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-65005-010-000 Fuel & Lube 49 of 120 glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 139 10/24/2019 Fuel- October Account: 135-65005-010-000 Account: 135-65010-010-000 173 10/28/2019 PCards 173 10/28/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 Account: 135-65010-010-000 PCards PCards PCards PCards PCards Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Period Ending: 10/2019 JE Detail Beginning Balance Description/Comment Fuel -October Fuel & Lube 15,000.00 Budgeted Uniforms 10/1/19-10/28/19 jacket tax 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 Account: 135-65030-010-000 141 10/29/2019 October A/P 224 10/31/2019 October A/P Account: 135-65030-010-000 Account: 135-65035-010-000 Account: 135-65035-010-000 Account: 135-65040-010-000 Account: 135-65040-010-000 Account: 135-65050-010-000 91 10/17/2019 October A/P 224 10/31/2019 October A/P jacket Matt C. Shoes Michael H. SHoes Clayton H. Shoes Jason R. Shoes Uniforms 5,190.00 Budgeted Chemicals chlorine testing supplies Chemicals 20,000.00 Budgeted Small Tools Small Tools 1,200.00 Budgeted Safety Equipment Safety Equipment 1,000.00 Budgeted Meter Expense meters meters Totals: 14,226.52 Remaining Totals: 4,370.01 Remaining Totals: 18,310.76 Remaining Totals: 1,200.00 Remaining Totals: 1,000.00 Remaining Program: Transaction Detail Page 17 November 14, 2019 Regular Meeting Agenda Packet Transaction Vendor_Name Detail (SUBTOTAL) Check Source Number 773.48 773.48 US Bank Voyager Fleet Systems 5873 AP 5 % Used 16 % Used 8 % Used 0 % Used 0 % Used 50 of 120 773.48 (9.90) 129.89 175.00 175.00 175.00 175.00 819.99 781.77 907.47 1,689.24 .00 .00 .00 1,825.28 7,050.00 773.48 ** (9.90) CARHARTT 119.99 CARHARTT 294.99 RED WING 469.99 RED WING 644.99 RED WING 819.99 RED WING 819.99 ** SHOES #573 SHOES #573 SHOES #573 SHOES #573 781.77 DPC INDUSTRIES, INC 1,689.24 HACH COMPANY 1,689.24 ** .00 .00 ** .00 .00 ** 1,825.28 ATLAS UTILITY SUPPLY CO. 8,875.28 ATLAS UTILITY SUPPLY CO. PC PC PC PC PC PC 5854 AP 5890 AP 5833 AP 5882 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 18 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/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 Meter Expense Totals: 70,000.00 Budgeted Account: 135-65053-010-000 Meter Change Out Program Account: 135-65053-010-000 Account: 135-69005-010-000 143 10/29/2019 October A/P 224 10/31/2019 October A/P 224 10/31/2019 October A/P 229 10/31/2019 October A?P 61,124.72 Remaining 13 % Used Meter Change Out Program Totals: 87,000.00 Budgeted 87,000.00 Remaining Capital Outlays VFD upgrade Beacon software Beacon software Straight Creek/Carnoustie O % Used 8,875.28 .00 8,875.28 ** .00 .00 .00 ** 10,092.60 3,800.00 3,500.00 1,259.00 10,092.60 REY-MAR CONSTRUCTION 13,892.60 ATLAS UTILITY SUPPLY CO. 17,392.60 ATLAS UTILITY SUPPLY CO. 18,651.60 Halff Associates, INC 5867 AP 5882 AP 5882 AP 5889 AP Account: 135-69005-010-000 Capital Outlays Totals: 18,651.60 18,651.60 ** 684,875.00 Budgeted 666,223.40 Remaining 3 5 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 Account: 135-69009-010-000 Short Term Debt -Interest Account: 135-69009-010-000 Short Term Debt -Interest Totals: 3,231.00 Budgeted 3,231.00 Remaining O % Used .00 .00 O % Used .00 Account: 135-69195-010-000 Gasb34/Reserve for Replacement 151 10/01/2019 GASB 34 Transfers FY 2020 Town Elevated Tank 45,000.00 45,000.00 GL 151 10/01/2019 GASB 34 Transfers FY 2020 Water Replacement 30,000.00 75,000.00 GL Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: 75,000.00 Budgeted .00 Remaining 75,000.00 75,000.00 ** 100 % Used 51 of 120 glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Page 19 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 10/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment November 14, 2019 Regular Meeting Agenda Packet Account: 135-69281-010-000 Water Tank Inspection Contract .00 .00 Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 .00 ** 120,000.00 Budgeted 120,000.00 Remaining 0 % Used 52 of 120 glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Department: 10 Water JE Detail Description/Comment Trophy Club MUD No.1 Page 20 Detailed Accounting Trial Balance Program: 1 Lab Analysis for PiNovember 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 135-55135-010-001 Lab Analysis for PID Account: 135-55135-010-001 Department 10 Totals: Lab Analysis for PID Totals: 2,000.00 Budgeted 196,873.68 Monthly Total 2,000.00 Remaining 0 % Used .00 .00 .00 .00 ** 196,873.68 ** 5,506,929.00 Budgeted 5,310,055.32 Remaining 4 % Used 53 of 120 glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Department: Trophy Club MUD No.1 Detailed Accounting Trial Balance 20 Wastewater Period Ending: 10/2019 Beginning Balance JE Detail Description/Comment Account: 135-50005-020-000 Salaries & Wages 5 10/04/2019 MUD Payroll 10/04/2019 Salaries & Wages 87 10/04/2019 Revr Accr Sept FY19 Payroll #1 65 10/18/2019 MUD Payroll 10/18/2019 Salaries & Wages 88 10/18/2019 Revr Accr Sept FY19 Payroll #2 Account: 135-50005-020-000 Salaries 6 Wages 441,799.00 Budgeted Account: 135-50010-020-000 Overtime 5 10/04/2019 MUD Payroll 10/04/2019 Overtime 87 10/04/2019 Revr Accr Sept FY19 Payroll #1 65 10/18/2019 MUD Payroll 10/18/2019 Overtime Account: 135-50010-020-000 Overtime 33,000.00 Budgeted Totals: 428,842.24 Remaining Totals: 32,350.92 Remaining 3 % Used 2 % Used Program: Transaction Detail Page 21 November 14, 2019 Regular Meeting Agenda Packet Transaction Vendor_Name Detail (SUBTOTAL) 14,490.58 14,490.58 (14,490.58) .00 14,509.18 14,509.18 (1,552.42) 12,956.76 12,956.76 12,956.76 ** 590.87 (590.87) 649.08 649.08 590.87 .00 649.08 649.08 ** Check Source Number PR GL PR GL PR GL PR Account: 135-50016-020-000 Longevity Account: 135-50016-020-000 Longevity 8,035.00 Budgeted Account: 135-50017-020-000 Certification 65 10/18/2019 MUD Payroll 10/18/2019 Certification Account: 135-50017-020-000 Certification 9,000.00 Budgeted Account: 135-50020-020-000 Retirement 5 10/04/2019 MUD Payroll 10/04/2019 Retirement 65 10/18/2019 MUD Payroll 10/18/2019 Retirement Account: 135-50020-020-000 Retirement 45,531.00 Budgeted Account: 135-50026-020-000 Medical Insurance 5 10/04/2019 MUD Payroll 10/04/2019 Medical Insurance Totals: 8,035.00 Remaining Totals: 8,375.00 Remaining Totals: 42,676.02 Remaining 0 % Used 7 % Used 6 % Used 54 of 120 .00 .00 625.00 625.00 1,395.03 1,459.95 2,854.98 2,993.58 .00 .00 ** 625.00 625.00 ** 1,395.03 2,854.98 2,854.98 ** 2,993.58 PR PR PR PR glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 65 10/18/2019 MUD Payroll 10/18/2019 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 10/2019 JE Detail Beginning Balance Description/Comment Medical Insurance Program: Page 22 November 14, 2019 Regular Meeting Agenda Packet Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) 2,993.55 5,987.13 Check Source Number PR 5 10/04/2019 MUD Payroll 10/04/2019 Social Security Taxes 87 10/04/2019 Revr Accr Sept FY19 Payroll #1 65 10/18/2019 MUD Payroll 10/18/2019 Social Security Taxes 88 10/18/2019 Revr Accr Sept FY19 Payroll #2 889.61 (889.61) 892.07 (88.11) 889.61 .00 892.07 803.96 PR GL PR GL Account: 135-50030-020-000 Social Security Taxes Totals: 803.96 803.96 ** 30,494.00 Budgeted 29,690.04 Remaining 3 % Used Account: 135-50035-020-000 Medicare Taxes 5 10/04/2019 MUD Payroll 10/04/2019 Medicare Taxes 87 10/04/2019 Revr Accr Sept FY19 Payroll #1 55 of 120 208.06 208.06 (208.06) .00 PR GL Account: 135-50026-020-000 Medical Insurance Totals: 5,987.13 5,987.13 ** 104,858.00 Budgeted 98,870.87 Remaining 6 % Used Account: 135-50027-020-000 Dental Insurance 5 10/04/2019 MUD Payroll 10/04/2019 Dental Insurance 65 10/18/2019 MUD Payroll 10/18/2019 Dental Insurance 179.09 179.06 179.09 358.15 PR PR Account: 135-50027-020-000 Dental Insurance Totals: 358.15 358.15 ** 5,817.00 Budgeted 5,458.85 Remaining 6 % Used Account: 135-50028-020-000 11111 Vision Insurance 5 10/04/2019 MUD Payroll 10/04/2019 Vision Insurance 65 10/18/2019 MUD Payroll 10/18/2019 Vision Insurance 29.62 29.60 29.62 59.22 PR PR Account: 135-50028-020-000 ' Vision Insurance Totals: 59.22 59.22 ** 948.00 Budgeted 888.78 Remaining 6 % Used Account: 135-50029-020-000 Life Insurance & Other 3 10/15/2019 Payroll Benefits October 3 10/15/2019 Payroll Benefits October 162.14 175.00 162.14 337.14 METLIFE GROUP BENEFITS Humana Inc 5796 5790 AP AP Account: 135-50029-020-000 Life Insurance & Other Totals: 337.14 337.14 ** 4,500.00 Budgeted 4,162.86 Remaining 7 % Used Account: 135-50030-020-000 Social Security Taxes 5 10/04/2019 MUD Payroll 10/04/2019 Social Security Taxes 87 10/04/2019 Revr Accr Sept FY19 Payroll #1 65 10/18/2019 MUD Payroll 10/18/2019 Social Security Taxes 88 10/18/2019 Revr Accr Sept FY19 Payroll #2 889.61 (889.61) 892.07 (88.11) 889.61 .00 892.07 803.96 PR GL PR GL Account: 135-50030-020-000 Social Security Taxes Totals: 803.96 803.96 ** 30,494.00 Budgeted 29,690.04 Remaining 3 % Used Account: 135-50035-020-000 Medicare Taxes 5 10/04/2019 MUD Payroll 10/04/2019 Medicare Taxes 87 10/04/2019 Revr Accr Sept FY19 Payroll #1 55 of 120 208.06 208.06 (208.06) .00 PR GL glpdatb2 skrolczyk 17:07 11/07/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 Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/2019 JE Detail Beginning Transaction Transaction Vendor_Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 23 65 10/18/2019 MUD Payroll 10/18/2019 Medicare Taxes 88 10/18/2019 Revr Accr Sept FY19 Payroll #2 208.63 (20.62) 208.63 188.01 PR GL 56 of 120 Account: 135-50035-020-000 Medicare Taxes Totals: 188.01 188.01 ** 7,132.00 Budgeted 6,943.99 Remaining 3 % Used Account: 135-50040-020-000 Unemployment Taxes .00 .00 Account: 135-50040-020-000 Unemployment Taxes Totals: .00 .00 ** 1,260.00 Budgeted 1,260.00 Remaining 0 % Used Account: 135-50045-020-000 Workman's Compensation 66 10/01/2019 Insurance/Wrk Comp Expense Oct 1,110.20 1,110.20 GL Account: 135-50045-020-000 Workman's Compensation Totals: 1,110.20 1,110.20 ** 15,373.00 Budgeted 14,262.80 Remaining 7 % 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 Account: 135-55070-020-000 Independent Labor 56 of 120 glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 10/2019 JE Detail Beginning Balance Description/Comment Account: 135-55070-020-000 Independent Labor 15,000.00 Budgeted Account: 135-55080-020-000 48 10/11/2019 October A/P 140 10/11/2019 Reverse Exp Oct A/P- Sept Exp 173 10/28/2019 PCards 10/1/19-10/28/19 173 10/28/2019 PCards 10/1/19-10/28/19 173 10/28/2019 PCards 10/1/19-10/28/19 141 10/29/2019 October A/P 141 10/29/2019 October A/P 143 10/29/2019 October A/P 224 10/31/2019 October A/P Maintenance & Repairs air solenoid valve replacement Reversing JE 48- Moving to Sep Insulation, winterizing Barrel Pump Sponge, Valve, tape, batteries quick connect cable LS VFD for RAS pump Longo bags Filters/Filter wraps Account: 135-55080-020-000 Totals: 15,000.00 Remaining Maintenance & Repairs Totals: 88,000.00 Budgeted 84,295.46 Remaining Account: 135-55081-020-000 Mainten & Repairs Collections 173 10/28/2019 PCards 10/1/19-10/28/19 APC BK350 350VA UPS System 141 10/29/2019 October A/P Avenue Twenty LS 141 10/29/2019 October A/P 143 10/29/2019 October A/P 224 10/31/2019 October A/P Account: 135-55081-020-000 Account: 135-55085-020-000 Account: 135-55085-020-000 • parts for LS 20 Ball valves soc LS #20 LS #20 Mainten & Repairs Collections Totals: 10,000.00 Budgeted 2,074.75 Remaining Generator Maint. and Repair Generator Maint. and Repair Totals: 10,000.00 Budgeted 10,000.00 Remaining Account: 135-55090-020-000 ■ Vehicle Maintenance 173 10/28/2019 PCards 10/1/19-10/28/19 belt dressing, dsl f additive 173 10/28/2019 PCards 10/1/19-10/28/19 Terra Cair Def Program: Transaction Detail .00 0 % Used .00 Page 24 November 14, 2019 Regular Meeting Agenda Packet Transaction Vendor_Name Detail (SUBTOTAL) .00 .00 ** 490.00 490.00 (490.00) .00 47.84 47.84 39.99 87.83 100.13 187.96 1,773.46 1,961.42 668.00 2,629.42 744.00 3,373.42 331.12 3,704.54 4 % Used 79 % Used 0 % Used 57 of 120 3,704.54 85.69 6,676.20 567.40 179.90 416.06 7,925.25 .00 .00 DHS AUTOMATION, INC THE HOME DEPOT #6581 O'REILLY AUTO PARTS 55 THE HOME DEPOT 6581 DHS AUTOMATION, INC SES Group, LLC Huber Technology Inc Filter Element Store 3,704.54 ** 85.69 6,761.89 7,329.29 7,509.19 7,925.25 AMAZON.COM*KP6QZ6K03 REY-MAR CONSTRUCTION SMITH PUMP COMPANY, INC. HD SUPPLY FACILITIES MAINT LTD SMITH PUMP COMPANY, INC. 7,925.25 ** .00 .00 ** 27.02 27.02 ROANOKE AUTO SUPPLY LT 20.00 47.02 ROANOKE AUTO SUPPLY LT Check Source Number 5815 AP GL PC PC PC 5853 AP 5869 AP 5858 AP 5887 AP PC 5867 AP 5870 AP 5857 AP 5900 AP PC PC glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/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 Totals: 47.02 47.02 ** 4,000.00 Budgeted 3,952.98 Remaining 1 % Used Account: 135-55091-020-000 Veh Maintenance Collections Account: 135-55091-020-000 Veh Maintenance Collections Totals: 8,000.00 Budgeted 8,000.00 Remaining Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 171 10/30/2019 Credit Expense A/P Refund 0 9 Used .00 .00 .00 .00 ** (856.24) (856.24) GL Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: (856.24) (856.24) ** Account: 135-55120-020-000 224 10/31/2019 October A/P 3,000.00 Budgeted 3,856.24 Remaining Cleaning Services janitorial svc-October -29 o Used 87.50 87.50 MEMBER'S BUILDING MAINTENANCE 5895 AP Account: 135-55120-020-000 Cleaning Services Totals: 87.50 87.50 ** 1,500.00 Budgeted Account: 135-55125-020-000 Dumpster Services 91 10/17/2019 October A/P sludge haul off 141 10/29/2019 October A/P sludge/grit 141 10/29/2019 October A/P SLudge/grit 224 10/31/2019 October A/P Sludge haul off Account: 135-55125-020-000 Account: 135-55135-020-000 48 10/11/2019 October A/P 48 10/11/2019 October A/P 91 10/17/2019 October A/P 141 10/29/2019 October A/P 141 10/29/2019 October A/P 224 10/31/2019 October A/P Dumpster Services 100,000.00 Budgeted Lab Analysis Lab testing lab testing algae sample lab testing lab testing Lab testing 1,412.50 Remaining 6 % Used 1,240.00 1,086.24 1,240.00 1,240.00 Totals: 95,193.76 Remaining 5 % Used 58 of 120 1,240.00 L.H. CHANEY MATERIALS, INC. 2,326.24 L.H. CHANEY MATERIALS, INC. 3,566.24 L.H. CHANEY MATERIALS, INC. 4,806.24 L.H. CHANEY MATERIALS, INC. 4,806.24 4,806.24 ** 317.40 317.40 OXIDOR LABORATORIES LLC 230.00 547.40 OXIDOR LABORATORIES LLC 200.00 747.40 SonicSolutions Algae Control 317.40 1,064.80 OXIDOR LABORATORIES LLC 230.00 1,294.80 OXIDOR LABORATORIES LLC 317.40 1,612.20 OXIDOR LABORATORIES LLC 5839 AP 5860 AP 5860 AP 5894 AP 5819 AP 5819 AP 5843 AP 5866 AP 5866 AP 5898 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 224 10/31/2019 October A/P 224 10/31/2019 October A/P 224 10/31/2019 October A/P lab testing lab testing lab testing 230.00 1,842.20 OXIDOR LABORATORIES LLC 317.40 2,159.60 OXIDOR LABORATORIES LLC 230.00 2,389.60 OXIDOR LABORATORIES LLC 5898 AP 5898 AP 5898 AP Account: 135-55135-020-000 Lab Analysis Totals: 2,389.60 2,389.60 ** 40,000.00 Budgeted 37,610.40 Remaining 6 % Used Account: 135-60010-020-000 Communications/Mobiles 48 10/11/2019 October A/P cell phones-Ocotber 372.84 372.84 VERIZON WIRELESS 5822 AP Account: 135-60010-020-000 Communications/Mobiles Totals: a � 4,627.16 Remaining 7 % Used 5,000.00 Budgeted Account: 135-60020-020-000 Electricity 91 10/17/2019 October A/P Electricity- 9/10-10/10 219 10/31/2019 Town Billed Invoices 1710-1713 AR 20191031-20191031 User: Account: 135-60020-020-000 11,935.31 11,935.31 HUDSON ENERGY SERVICES, LLC 5837 AP (174.02) 11,761.29 AR Electricity 11,761.29 11,761.29 ** 160,067.00 Budgeted 148,305.71 Remaining 7 % Used Account: 135-60066-020-000 1 Publications/Books/Subscripts .00 .00 Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 6 Used Account: 135-60070-020-000 Dues & Memberships .00 .00 Account: 135-60070-020-000 1 Dues & Memberships Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-60080-020-000 Schools & Training 173 10/28/2019 PCards 10/1/19-10/28/19 Water Utilites Safety DeWayne 420.00 420.00 TEEX ECOMMERCE PC 173 10/28/2019 PCards 10/1/19-10/28/19 Water Utilities Safety Jeff 420.00 840.00 TEEX ECOMMERCE PC Account: 135-60080-020-000 Schools & Training Totals: 840.00 840.00 ** 4,990.00 Budgeted 4,150.00 Remaining 17 o Used 59 of 120 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/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-020-000 Safety Program Account: 135-60090-020-000 Account: 135-60100-020-000 Account: 135-60100-020-000 Account: 135-60105-020-000 Account: 135-60105-020-000 Account: 135-60125-020-000 Safety Program Totals: 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Travel & per diem Travel & per diem Totals: 1,545.00 Budgeted Rent/Lease Equipment Rent/Lease Equipment 5,000.00 Budgeted Advertising 1,545.00 Remaining 0 % Used .00 .00 .00 .00 ** .00 .00 .00 .00 ** 1 00 .00 Totals: 5,000.00 Remaining 0 % Used .00 .00 .00 Account: 135-60125-020-000 Advertising Totals: .00 Account: 135-60135-020-000 141 10/29/2019 October A/P 2,500.00 Budgeted TCEQ Fees & Permits Permit WWTP 2,500.00 Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits Totals: Account: 135-60245-020-000 Account: 135-60245-020-000 1 15,000.00 Budgeted 5,111.98 Remaining 66 % Used Miscellaneous Expenses Miscellaneous Expenses Totals: 450.00 Budgeted Account: 135-60280-020-000 Property Maintenance 450.00 Remaining 0 % Used 60 of 120 9,888.02 9,888.02 TX COMMISSION ENVIRONMENTAL QU 5871 AP 9,888.02 9,888.02 ** ' .00 .00 1 .00 411.111.4 1 glpdatb2 skrolczyk 17:07 11/07/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: 10/2019 JE Detail Beginning Balance Description/Comment Program: Page 28 November 14, 2019 Regular Meeting Agenda Packet Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) .00 .00 Check Source Number 61 of 120 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 158 10/31/2019 TexPool Transfers October TexPool O&M to I&S- PID Debt 10,414.81 10,414.81 GL Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S Totals: 10,414.81 10,414.81 ** 114,563.00 Budgeted 104,148.19 Remaining 9 % Used Account: 135-60332-020-000 Interfund Transfer Out -Rev I&S 158 10/31/2019 TexPool Transfers October TexPool O&M to Rev Bd WWTP I&S 158 10/31/2019 TexPool Transfers October TexPool O&M to 19 W&WW Rev I&S 54,421.63 6,839.07 54,421.63 61,260.70 GL GL Account: 135-60332-020-000 Interfund Transfer Out -Rev I&S Totals: 61,260.70 61,260.70 ** 673,867.00 Budgeted 612,606.30 Remaining 9 % Used Account: 135-60333-020-000 Interfund Transfer Out -Reserve 158 10/31/2019 TexPool Transfers October TexPool O&M to Rev Bond Resevr 5,750.00 5,750.00 GL Account: 135-60333-020-000 Interfund Transfer Out -Reserve Totals: 5,750.00 5,750.00 ** 125,187.00 Budgeted 119,437.00 Remaining 5 % Used Account: 135-60334-020-000 Interfund Transfer Out .00 .00 Account: 135-60334-020-000 Interfund Transfer Out Totals: .00 .00 ** 180,000.00 Budgeted 180,000.00 Remaining 0 % Used Account: 135-60360-020-000 Furniture/Equipment < $5000 61 of 120 glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Account: 135-60360-020-000 Account: 135-65005-020-000 139 10/24/2019 Fuel- October Account: 135-65005-020-000 1 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 10/2019 JE Detail Beginning Balance Description/Comment Furniture/Equipment < $5000 Totals: 2,000.00 Budgeted 2,000.00 Remaining Fuel & Lube Fuel -October Fuel & Lube 12,500.00 Budgeted Account: 135-65010-020-000 - Uniforms 173 10/28/2019 PCards 10/1/19-10/28/19 Jeff R. Shoes 173 10/28/2019 PCards 10/1/19-10/28/19 173 10/28/2019 PCards 10/1/19-10/28/19 173 10/28/2019 PCards 10/1/19-10/28/19 143 10/29/2019 October A/P Account: 135-65010-020-000 Account: 135-65030-020-000 91 10/17/2019 October A/P Account: 135-65030-020-000 Account: 135-65031-020-000 Account: 135-65031-020-000 Account: 135-65035-020-000 Account: 135-65035-020-000 1 Orlando V. Shoes Frank W. Shoes Lance H. Shoes uniform/boots forms 5,495.00 Budgeted Chemicals defoamer/Bacteria Chemicals 20,000.00 Budgeted Chemicals Collections Chemicals Collections 17,500.00 Budgeted Small Tools Small Tools 1,200.00 Budgeted Totals: 11,576.39 Remaining Totals: 4,602.59 Remaining Totals: 17,174.04 Remaining Totals: 17,500.00 Remaining Program: Transaction Detail .00 0 % Used .00 Page 29 November 14, 2019 Regular Meeting Agenda Packet Transaction Vendor_Name Detail (SUBTOTAL) .00 .00 ** Check Source Number 923.61 923.61 US Bank Voyager Fleet Systems 5873 AP 7 8 Used 16 % Used 14 8 Used 0 8 Used 923.61 175.00 175.00 175.00 175.00 192.41 892.41 2,825.96 2,825.96 .00 .00 .00 Totals: 1,200.00 Remaining 0 o Used 62 of 120 .00 923.61 ** 175.00 350.00 525.00 700.00 892.41 RED WING SHOES #573 RED WING SHOES #573 RED WING SHOES #573 RED WING SHOES #573 Ritz Safety, LLC 892.41 ** PC PC PC PC 5868 AP 2,825.96 MARYLAND BIOCHEMICAL CO, INC 5841 AP 2,825.96 ** .00 .00 ** .00 .00 ** glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 10/2019 JE Detail Beginning Balance Description/Comment Program: Transaction Detail Page 30 November 14, 2019 Regular Meeting Agenda Packet Transaction Vendor_Name Detail (SUBTOTAL) Check Source Number Account: 135-65040-020-000 Safety Equipment Account: 135-65040-020-000 Safety Equipment 1,200.00 Budgeted Account: 135-65045-020-000 18 10/04/2019 October A/P 18 10/04/2019 October A/P 173 10/28/2019 PCards 10/1/19-10/28/19 141 10/29/2019 October A/P 143 10/29/2019 October A/P 143 10/29/2019 October A/P 143 10/29/2019 October A/P 224 10/31/2019 October A/P Account: 135-65045-020-000 Account: 135-69005-020-000 141 10/29/2019 October A/P Account: 135-69005-020-000 Lab Supplies lab supplies lab supplies Nesslers Reagent lab gloves lab supllies lab supplies lab supplies biomonitoring Lab Supplies 20,000.00 Budgeted Capital Outlays LS upgrades FY 19 Capital Outlays 530,500.00 Budgeted Totals: 1,200.00 Remaining Totals: 17,016.99 Remaining Totals: 524,711.00 Remaining O % Used .00 .00 213.52 960.96 118.60 169.20 64.95 257.28 118.50 1,080.00 15 % Used 1 % Used Account: 135-69008-020-000 Short Term Debt -Principal Account: 135-69008-020-000 Short Term Debt -Principal Totals: 79,133.00 Budgeted 79,133.00 Remaining O % Used Account: 135-69009-020-000 Short Term Debt -Interest Account: 135-69009-020-000 Account: 135-69195-020-000 Short Term Debt -Interest Totals: 11,277.00 Budgeted 11,277.00 Remaining Gasb34/Reserve for Replacement O % Used 63 of 120 2,983.01 5,789.00 5,789.00 .00 .00 .00 .00 .00 .00 .00 .00 ** • 213.52 1,174.48 1,293.08 1,462.28 1,527.23 1,784.51 1,903.01 2,983.01 IDEXX DISTRIBUTION, INC IDEXX DISTRIBUTION, INC THE LAB DEPOT LOU'S GLOVES INCORPORATED HD SUPPLY FACILITIES MAINT HACH COMPANY HACH COMPANY HUTHER AND ASSOCIATES,INC 2,983.01 ** 5,789.00 DHS AUTOMATION, INC 5,789.00 ** .00 ** .00 ** 5791 AP 5791 AP PC 5861 AP LTD 5857 AP 5856 AP 5856 AP 5892 AP 5853 AP glpdatb2 skrolczyk 17:07 11/07/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 Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/2019 JE Detail Beginning Transaction Transaction Vendor_Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 31 151 10/01/2019 GASB 34 Transfers FY 2020 Sewer Replacement 151 10/01/2019 GASB 34 Transfers FY 2020 WWTP MBR Replacement 30,000.00 100,000.00 30,000.00 130,000.00 GL GL Account: 135-69195-020-000 Gasb34/Reserve for Replacement Totals: 130,000.00 130,000.00 ** 130,000.00 Budgeted .00 Remaining 100 % Used Department 20 Totals: 287,735.19 Monthly Total 287,735.19 ** 3,157,421.00 Budgeted 2,869,685.81 Remaining 9 % Used 64 of 120 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/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 66 10/01/2019 Insurance/Wrk Comp Expense Oct Account: 135-50045-026-000 Workman's Compensation Totals: Account: 135-60066-026-000 Account: 135-60066-026-000 30.00 Budgeted Publications/Books/Subscripts Publications/Books/Subscripts Totals: 150.00 Budgeted 150.00 Remaining 28.01 Remaining 7 % Used 1.99 1.99 GL 1.99 1.99 ** .00 0 % Used .00 .00 .00 ** Account: 135-60070-026-000 Dues & Memberships Dues & Memberships 750.00 Budgeted Account: 135-60070-026-000 .00 Totals: 750.00 Remaining 0 % Used .00 .00 .00 ** Account: 135-60075-026-000 Meetings Account: 135-60075-026-000 Meetings 1,300.00 Budgeted Totals: 1,300.00 Remaining 0 % Used .00 .00 .00 .00 ** Account: 135-60080-026-000 Schools & Training Account: 135-60080-026-000 Schools & Training 4,000.00 Budgeted Totals: 4,000.00 Remaining 0 6 Used .00 .00 .00 .00 ** Account: 135-60100-026-000 Travel & per diem .00 .00 Account: 135-60100-026-000 Travel & per diem Totals: .00 .00 5,000.00 Budgeted Account: 135-60245-026-000 Miscellaneous Expenses 5,000.00 Remaining 0 % Used 65 of 120 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/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 ** Department 26 Totals: 2,000.00 Budgeted 1.99 Monthly Total 2,000.00 Remaining 0 % Used 13,230.00 Budgeted 13,228.01 Remaining 66 of 120 1.99 ** 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 17:07 11/07/19 Detailed Accounting Trial Balance Page 34 Fund: 135 MUD 1 General Fund Department: 30 Administration Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/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-50005-030-000 Salaries & Wages 5 10/04/2019 MUD Payroll 10/04/2019 Salaries 9 Wages 87 10/04/2019 Revr Accr Sept FY19 Payroll #1 65 10/18/2019 MUD Payroll 10/18/2019 Salaries & Wages 88 10/18/2019 Revr Accr Sept FY19 Payroll #2 14,798.28 (14,798.28) 15,046.49 (1,480.64) 14,798.28 .00 15,046.49 13,565.85 PR GL PR GL Account: 135-50005-030-000 Salaries & Wages Totals: 13,565.85 13,565.85 ** 628,298.00 Budgeted 614,732.15 Remaining 2 % Used Account: 135-50010-030-000 Overtime .00 .00 Account: 135-50010-030-000 Overtime Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 135-50016-030-000 Longevity .00 .00 Account: 135-50016-030-000 Longevity Totals: .00 .00 ** 2,208.00 Budgeted 2,208.00 Remaining 0 % Used Account: 135-50020-030-000 Retirement 5 10/04/2019 MUD Payroll 65 10/18/2019 MUD Payroll 10/04/2019 Retirement 10/18/2019 Retirement 1,368.84 1,391.80 1,368.84 2,760.64 PR PR Account: 135-50020-030-000 Retirement Totals: 2,760.64 2,760.64 ** 58,554.00 Budgeted 55,793.36 Remaining 5 % Used Account: 135-50026-030-000 Medical Insurance 5 10/04/2019 MUD Payroll 65 10/18/2019 MUD Payroll 10/04/2019 Medical Insurance 10/18/2019 Medical Insurance 2,744.43 2,744.38 2,744.43 5,488.81 PR PR Account: 135-50026-030-000 Medical Insurance Totals: 5,488.81 5,488.81 ** 124,394.00 Budgeted 118,905.19 Remaining 4 % Used Account: 135-50027-030-000 Dental Insurance 5 10/04/2019 MUD Payroll 10/04/2019 Dental Insurance 153.21 153.21 PR 65 10/18/2019 MUD Payroll 10/18/2019 Dental Insurance 67 of 120 153.19 306.40 PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 35 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/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-50027-030-000 Dental Insurance Totals: 306.40 306.40 ** 6,464.00 Budgeted Account: 135-50028-030-000 Vision Insurance 5 10/04/2019 MUD Payroll 10/04/2019 Vision Insurance 65 10/18/2019 MUD Payroll 10/18/2019 Vision Insurance 6,157.60 Remaining 5 % Used 24.40 24.40 PR 24.37 48.77 PR Account: 135-50028-030-000 Vision Insurance Totals: 48.77 48.77 ** 1,035.00 Budgeted Account: 135-50029-030-000 Life Insurance & Other 3 10/15/2019 Payroll Benefits October 3 10/15/2019 Payroll Benefits October 986.23 Remaining 5 % Used 142.90 142.90 METLIFE GROUP BENEFITS 5796 AP 149.52 292.42 Humana Inc 5790 AP Account: 135-50029-030-000 Life Insurance & Other Totals: 292.42 292.42 ** 4,500.00 Budgeted 4,207.58 Remaining 6 8 Used Account: 135-50030-030-000 Social Security Taxes 5 10/04/2019 MUD Payroll 10/04/2019 Social Security Taxes 855.11 855.11 PR 87 10/04/2019 Revr Accr Sept FY19 Payroll #1 (855.11) .00 GL 65 10/18/2019 MUD Payroll 10/18/2019 Social Security Taxes 867.35 867.35 PR 88 10/18/2019 Revr Accr Sept FY19 Payroll #2 (85.35) 782.00 GL Account: 135-50030-030-000 Social Security Taxes Totals: 782.00 782.00 ** 39,215.00 Budgeted 38,433.00 Remaining 2 % Used Account: 135-50035-030-000 Medicare Taxes 5 10/04/2019 MUD Payroll 10/04/2019 Medicare Taxes 199.97 199.97 PR 87 10/04/2019 Revr Accr Sept FY19 Payroll #1 (199.97) .00 GL 65 10/18/2019 MUD Payroll 10/18/2019 Medicare Taxes 202.86 202.86 PR 88 10/18/2019 Revr Accr Sept FY19 Payroll #2 (19.95) 182.91 GL Account: 135-50035-030-000 Medicare Taxes Totals: 182.91 182.91 ** 9,171.00 Budgeted 8,988.09 Remaining 2 6 Used Account: 135-50040-030-000 Unemployment Taxes .00 .00 68 of 120 glpdatb2 skrolczyk 17:07 11/07/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: 10/2019 JE Detail Beginning Balance Description/Comment Unemployment Taxes Totals: 1,440.00 Budgeted 1,440.00 Remaining Account: 135-50045-030-000 Workman's Compensation 66 10/01/2019 Insurance/Wrk Comp Expense Oct Account: 135-50045-030-000 Account: 135-50060-030-000 Account: 135-50060-030-000 Workman's Compensation Totals: 1,775.00 Budgeted 1,670.18 Remaining Pre-emp Physicals/Testing Pre-emp Physicals/Testing Totals: 500.00 Budgeted 500.00 Remaining Account: 135-50070-030-000 Employee Relations 173 10/28/2019 PCards 10/1/19-10/28/19 End of year Celebration Lunch Account: 135-50070-030-000 Employee Relations Totals: 8,000.00 Budgeted 7,821.15 Remaining Account: 135-55030-030-000 2 10/01/2019 October A/P 18 10/04/2019 October A/P 18 10/04/2019 October A/P 48 10/11/2019 October A/P 48 10/11/2019 October A/P 173 10/28/2019 PCards 10/1/19-10/28/19 173 10/28/2019 PCards 10/1/19-10/28/19 173 10/28/2019 PCards 10/1/19-10/28/19 173 10/28/2019 PCards 10/1/19-10/28/19 141 10/29/2019 October A/P Account: 135-55030-030-000 Account: 135-55070-030-000 Software & Support Microsoft exchange -October New SCADA Computer renewal -FY Code Red renewal -10/27/19-10/2 Annual M3 Service -FY 20 internet-October Internet bill internet bill internet Adobe Subscriptions Laserfiche renewal FY 20 Software & Support Totals: 134,681.00 Budgeted Independent Labor 69,155.15 Remaining Program: Transaction Detail 0 % Used 6 % Used 0 % Used 2 % Used 49 % Used 69 of 120 .00 104.82 104.82 .00 .00 178.85 178.85 Page 36 November 14, 2019 Regular Meeting Agenda Packet Transaction Vendor_Name Detail (SUBTOTAL) .00 ** 104.82 104.82 ** .00 .00 ** 178.85 CRISTINA'S MEXICAN 178.85 ** 510.00 510.00 495.00 1,005.00 3,670.00 4,675.00 54,600.00 59,275.00 899.00 60,174.00 42.37 60,216.37 42.37 60,258.74 53.91 60,312.65 32.45 60,345.10 5,180.75 65,525.85 65,525.85 65,525.85 M3 Networks WIN -911 SOFTWARE Onsolve Intermediate Holding M3 Networks Charter Communications ATT*BILL PAYMENT ATT*BILL PAYMENT ATT*BILL PAYMENT ADOBE ACROPRO SUBS MCCI Check Source Number GL PC 5795 AP 5799 AP 5797 AP 5817 AP 5814 AP PC PC PC PC 5863 AP glpdatb2 skrolczyk 17:07 11/07/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: 10/2019 JE Detail Beginning Balance Description/Comment Program: Page 37 November 14, 2019 Regular Meeting Agenda Packet Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) .00 .00 Check Source Number 70 of 120 Account: 135-55070-030-000 Independent Labor Totals: .00 .00 ** 135,000.00 Budgeted 135,000.00 Remaining 0 % Used Account: 135-55080-030-000 Maintenance & Repairs 141 10/29/2019 October A/P 141 10/29/2019 October A/P a/c in office A/C in office 160.00 355.00 160.00 515.00 BRANDON R REED BRANDON R REED 5851 5851 AP AP Account: 135-55080-030-000 Maintenance & Repairs Totals: 515.00 515.00 ** 15,000.00 Budgeted 14,485.00 Remaining 3 % Used Account: 135-55085-030-000 Generator Maint. and Repair .00 .00 Account: 135-55085-030-000 Generator Maint. and Repair Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-55120-030-000 Cleaning Services 224 10/31/2019 October A/P janitorial svc-October 869.06 869.06 MEMBER'S BUILDING MAINTENANCE 5895 AP Account: 135-55120-030-000 Cleaning Services Totals: 869.06 869.06 ** 10,000.00 Budgeted 9,130.94 Remaining 9 % Used Account: 135-55160-030-000 Professional Outside Services .00 .00 Account: 135-55160-030-000 Professional Outside Services Totals: .00 .00 ** 65,600.00 Budgeted 65,600.00 Remaining 0 % Used Account: 135-55205-030-000 Utility Billing Contract 224 10/31/2019 October A/P Billings -October 582.15 582.15 DATAPROSE LLC 5885 AP Account: 135-55205-030-000 Utility Billing Contract Totals: 582.15 582.15 ** 9,000.00 Budgeted 8,417.85 Remaining 6 % Used Account: 135-60005-030-000 Telephone 70 of 120 glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE Number JE Date 18 10/04/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 219 10/31/2019 Account: 135-60005-030-000 JE Description October A/P PCards 10/1/19-10/28/19 PCards 10/1/19-10/28/19 PCards 10/1/19-10/28/19 PCards 10/1/19-10/28/19 Town Billed Invoices 1710-1713 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 10/2019 JE Detail Beginning Balance Description/Comment Answering service -October phone bill phone bill Phone Bill Answering Service AR 20191031-20191031 User: Telephone 23,680.00 Budgeted Account: 135-60010-030-000 48 10/11/2019 October A/P 65 10/18/2019 MUD Payroll 10/18/2019 Account: 135-60010-030-000 Account: 135-60020-030-000 Account: 135-60020-030-000 Totals: 22,200.20 Remaining Communications/Mobiles cell phones-Ocotber Communications/Mobiles Communications/Mobiles Totals: 4,000.00 Budgeted 3,761.98 Remaining Electricity/Gas Electricity/Gas 6,879.00 Budgeted Totals: 6,879.00 Remaining Account: 135-60025-030-000 Water 219 10/31/2019 Town Billed Invoices 1710-1713 AR 20191031-20191031 User: 224 10/31/2019 October A/P water -October Account: 135-60025-030-000 Account: 135-60035-030-000 141 10/29/2019 October A/P 224 10/31/2019 October A/P Account: 135-60035-030-000 Account: 135-60040-030-000 Water 1,500.00 Budgeted Postage Postage lease Billings -October Postage 30,000.00 Budgeted Service Charges & Fees Totals: 1,433.22 Remaining Totals: 28,273.39 Remaining 6 % Used 6 % Used 0 % Used 4 % Used 6 % Used 71 of 120 Program: Transaction Detail 194.75 795.42 468.33 186.31 14.99 (180.00) 1,479.80 88.02 150.00 238.02 .00 .00 (66.77) Page 38 November 14, 2019 Regular Meeting Agenda Packet Transaction Vendor_Name Detail (SUBTOTAL) 194.75 990.17 1,458.50 1,644.81 1,659.80 1,479.80 KEYSTONE PARK SECRETARIAL ATT*BUS PHONE PMT ATT*BUS PHONE PMT ATT*BILL PAYMENT RINGCENTRAL, INC 1,479.80 ** 88.02 VERIZON WIRELESS 238.02 238.02 ** .00 .00 ** (66.77) 133.55 66.78 TROPHY CLUB MUD (WATER BILLS) 66.78 66.78 ** 102.54 102.54 FRANCOTYP-POSTALIA, INC. 1,624.07 1,726.61 DATAPROSE LLC 1,726.61 1,726.61 ** Check Source Number 5793 AP PC PC PC PC AR 5822 AP PR AR 5902 AP 5855 AP 5885 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 157 10/31/2019 Pace Credit Card Fees 157 10/31/2019 Pace Credit Card Fees 224 10/31/2019 October A/P Account: 135-60040-030-000 Direct send fees -October Service Charges & Fees Totals: 67,000.00 Budgeted 59,952.07 Remaining 11 % Used 6,812.40 6,812.40 GL 185.53 6,997.93 GL 50.00 7,047.93 Fisery Solutions, LLC 5888 AP 7,047.93 7,047.93 ** Account: 135-60050-030-000 Bad Debt Expense .00 .00 Account: 135-60050-030-000 Bad Debt Expense Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60055-030-000 Insurance 66 10/01/2019 Insurance/Wrk Comp Expense Oct 6,998.39 6,998.39 GL Account: 135-60055-030-000 Insurance Totals: 6,998.39 6,998.39 ** 84,000.00 Budgeted 77,001.61 Remaining 8 % Used Account: 135-60066-030-000 Publications/Books/Subscripts .00 .00 Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 .00 ** Account: 135-60070-030-000 141 10/29/2019 October A/P 229 10/31/2019 October A?P 1,000.00 Budgeted 1,000.00 Remaining Dues & Memberships FY 2020 renewal 0 % Used 100.00 100.00 TX COMPTROLLER 5872 AP 100.00 200.00 NORTH CENTRAL TX COG 5897 AP Account: 135-60070-030-000 Dues & Memberships Totals: 200.00 200.00 ** 6,000.00 Budgeted 5,800.00 Remaining 3 % Used Account: 135-60075-030-000 Meetings .00 .00 Account: 135-60075-030-000 Meetings Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used 72 of 120 glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Account: 135-60079-030-000 173 10/28/2019 PCards 173 10/28/2019 PCards 173 10/28/2019 PCards 173 10/28/2019 PCards 173 10/28/2019 PCards Account: 135-60079-030-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 10/2019 JE Detail Beginning Balance Description/Comment _ Public Education 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 Dist info Form & Fee Annexations and Fee Real Property Recordings & fee Parking Fee for Ft Worth Court Notice Purchaser Public Education 6,000.00 Budgeted Totals: 5,650.25 Remaining Account: 135-60080-030-000 Schools & Training 173 10/28/2019 PCards 10/1/19-10/28/19 Election Training 173 10/28/2019 PCards 10/1/19-10/28/19 Training Webinars 173 10/28/2019 PCards 10/1/19-10/28/19 Public Funds Invest training Account: 135-60080-030-000 Schools & Training 6,850.00 Budgeted Account: 135-60100-030-000 Travel & per diem 65 10/18/2019 MUD Payroll 10/18/2019 Travel & per diem Account: 135-60100-030-000 Account: 135-60110-030-000 Account: 135-60110-030-000 Account: 135-60125-030-000 Account: 135-60125-030-000 Travel & per diem 3,545.00 Budgeted Physicals/Testing Physicals/Testing 200.00 Budgeted Advertising Advertising 2,500.00 Budgeted Totals: 6,072.29 Remaining Totals: 3,453.22 Remaining Totals: 200.00 Remaining Totals: 2,500.00 Remaining 6 % Used 11 % Used 3 % Used 0 % Used 0 % Used Program: Transaction Detail 140.00 124.00 48.50 1.25 36.00 349.75 Page 40 November 14, 2019 Regular Meeting Agenda Packet Transaction Vendor_Name Detail (SUBTOTAL) 140.00 264.00 312.50 313.75 349.75 VCN*DENTONFLOWERMOUNDC VCN*DENTONFLOWERMOUNDC VCN*DENTONFLOWERMOUNDC CFW PARKING METER NCOURT *TXTARRANTCOSWP 5 ** 210.00 210.00 TEXAS SECRETARY OF STA 432.71 642.71 GOVERNMENT FINANCE OFF 135.00 777.71 NCTCOG RTC TRAINING 777.71 91.78 91.78 .00 .00 .00 .00 777.71 ** 91.78 91.78 ** .00 .00 ** .00 .00 ** Check Source Number PC PC PC PC PC PC PC PC PR Account: 135-60235-030-000 Security 91 10/17/2019 October A/P monitoring svc-soct 73 of 120 24.00 24.00 Digital Air Control, Inc 5836 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/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-60235-030-000 Security Totals: 1,288.00 Budgeted Account: 135-60245-030-000 Miscellaneous Expenses Account: 135-60245-030-000 1,264.00 Remaining 2 % Used Miscellaneous Expenses Totals: 500.00 Budgeted Account: 135-60246-030-000 General Manager Contingency Account: 135-60246-030-000 General Manager Contingency Totals: 17,000.00 Budgeted 17,000.00 Remaining 500.00 Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: 2,500.00 Budgeted 2,500.00 Remaining Account: 135-65010-030-000 Uniforms Account: 135-65010-030-000 Uniforms Totals: 2,050.00 Budgeted Account: 135-65055-030-000 Hardware Account: 135-65055-030-000 Account: 135-65085-030-000 91 10/17/2019 October A/P 141 10/29/2019 October A/P 0 % Used 0 % Used 2,050.00 Remaining 0 % Used Hardware Totals: 26,485.00 Budgeted Office Supplies office supplies office supplies 26,485.00 Remaining 0 % Used 74 of 120 24.00 .00 24.00 ** .00 .00 .00 ** .00 .00 .00 .00 ** .00 .00 .00 .00 ** .00 .00 .00 .00 .00 .00 .00 .00 61.77 61.77 OFFICE DEPOT, INC 5842 AP 499.56 561.33 OFFICE DEPOT, INC 5865 AP glpdatb2 skrolczyk 17:07 11/07/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: 10/2019 Beginning Balance JE Detail Description/Comment Program: Transaction Detail Page 42 November 14, 2019 Regular Meeting Agenda Packet Transaction Vendor_Name Detail (SUBTOTAL) Check Source Number 173 10/28/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 PCards PCards PCards PCards PCards PCards PCards PCards PCards PCards 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 coffee badge holders coffee coffee coffee coffee water, truvia, soap, pt, wipes air freshner coffee coffee 15.99 8.99 47.59 25.08 50.99 25.45 190.74 25.22 27.45 10.50 15.99 24.98 72.57 97.65 148.64 174.09 364.83 390.05 417.50 428.00 AMZN MKTP US*IO26K2LT3 AMZN MKTP US*DW33R73N3 AMAZON.COM*XP8XK1FY3 AMAZON.COM*2W2GT6GB3 AMZN MKTP US*PU81F4MV3 AMAZON.COM*JJ1H16P13 SAMSCLUB.COM AMZN MKTP US*VR0566TW3 AMAZON.COM*CU9JJ85M3 AMZN MKTP US*G09UDORX3 PC PC PC PC PC PC PC PC PC PC Account: 135-65095-030-000 Maintenance Supplies Totals: 428.00 428.00 Account: 135-65085-030-000 Office Supplies Totals: 561.33 561.33 ** 6,000.00 Budgeted 5,438.67 Remaining 9 % Used ' Printing Account: 135-65090-030-000 Printer Supplies & Maintenance .00 .00 .00 .00 Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: Account: 135-65095-030-000 Maintenance Supplies 173 10/28/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 173 10/28/2019 PCards PCards PCards PCards PCards PCards PCards PCards PCards PCards 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 10/1/19-10/28/19 coffee badge holders coffee coffee coffee coffee water, truvia, soap, pt, wipes air freshner coffee coffee 15.99 8.99 47.59 25.08 50.99 25.45 190.74 25.22 27.45 10.50 15.99 24.98 72.57 97.65 148.64 174.09 364.83 390.05 417.50 428.00 AMZN MKTP US*IO26K2LT3 AMZN MKTP US*DW33R73N3 AMAZON.COM*XP8XK1FY3 AMAZON.COM*2W2GT6GB3 AMZN MKTP US*PU81F4MV3 AMAZON.COM*JJ1H16P13 SAMSCLUB.COM AMZN MKTP US*VR0566TW3 AMAZON.COM*CU9JJ85M3 AMZN MKTP US*G09UDORX3 PC PC PC PC PC PC PC PC PC PC Account: 135-65095-030-000 Maintenance Supplies Totals: 428.00 428.00 ** 4,000.00 Budgeted 3,572.00 Remaining 11 % 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 ** 195,000.00 Budgeted 195,000.00 Remaining 0 % Used Account: 135-69170-030-000 Copier Lease Installments 75 of 120 glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 91 10/17/2019 October A/P 141 10/29/2019 October A/P Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/2019 JE Detail Beginning Transaction Transaction Vendor_Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) Page 43 copier lease-SOct copies 165.00 165.00 TIAA COMMERCIAL FINANCE 88.84 253.84 KYOCERA DOCUMENT SOLUTIONS 5845 AP 5859 AP Account: 135-69170-030-000 Copier Lease Installments Totals: 253.84 253.84 ** 4,000.00 Budgeted 3,746.16 Remaining 6 % Used Department 30 Totals: 111,447.47 Monthly Total 111,447.47 ** 1,776,712.00 Budgeted 1,665,264.53 Remaining 6 % Used 76 of 120 glpdatb2 skrolczyk 17:07 11/07/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 39 Non Departmental Period Ending: 10/2019 JE Detail Beginning Balance Description/Comment Program: Page 44 November 14, 2019 Regular Meeting Agenda Packet Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Check Source Number Department 39 Totals: Fund 135 Totals: 4,000.00 Budgeted 4,986.65 Monthly Total 4,000.00 Remaining 0 % Used 184,561.00 Budgeted 4,986.65 ** 179,574.35 Remaining 3 % Used (212,239.17) (212,239.17) Monthly Total (6,224.00) Budgeted 206,015.17 Remaining 9999999999 77 of 120 Account: 135-55045-039-000 Legal .00 .00 Account: 135-55045-039-000 Legal Totals: .00 .00 ** 135,000.00 Budgeted 135,000.00 Remaining 0 % Used Account: 135-55055-039-000 Auditing 165 10/01/2019 Reverse PPD Audit Retainer 5,000.00 5,000.00 GL Account: 135-55055-039-000 Auditing Totals: 5,000.00 5,000.00 ** 33,800.00 Budgeted 28,800.00 Remaining 15 % Used Account: 135-55060-039-000 Appraisal 170 10/30/2019 TAD Entity Refund (13.35) (13.35) GL Account: 135-55060-039-000 Appraisal Totals: (13.35) (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 ** Department 39 Totals: Fund 135 Totals: 4,000.00 Budgeted 4,986.65 Monthly Total 4,000.00 Remaining 0 % Used 184,561.00 Budgeted 4,986.65 ** 179,574.35 Remaining 3 % Used (212,239.17) (212,239.17) Monthly Total (6,224.00) Budgeted 206,015.17 Remaining 9999999999 77 of 120 glpdatb2 skrolczyk 17:07 11/07/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 Program: Page 45 November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 137-49145-000-000 Intergov Transfer -General Fund 151 10/01/2019 GASB 34 Transfers FY 2020 151 10/01/2019 GASB 34 Transfers FY 2020 151 10/01/2019 GASB 34 Transfers FY 2020 151 10/01/2019 GASB 34 Transfers FY 2020 Town Elevated Tank Water Replacement Sewer Replacement WWTP MBR Replacement (45,000.00) (30,000.00) (30,000.00) (100,000.00) (45,000.00) (75,000.00) (105,000.00) (205,000.00) GL GL GL GL Department Totals: Fund 137 Totals: (286,420.00) Monthly Total (286,420.00) Monthly Total .00 Budgeted .00 Budgeted 78 of 120 (286,420.00) ** 286,420.00 Remaining 0 % Used (286,420.00) 286,420.00 Remaining 0 % Used Account: 137-49145-000-000 Intergov Transfer -General Fund Totals: (205,000.00) (205,000.00) ** .00 Budgeted 205,000.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer -Fire Dept 151 10/01/2019 GASB 34 Transfers FY 2020 Fire Truck Future Replacement (81,420.00) (81,420.00) GL Account: 137-49146-000-000 Intergov Transfer -Fire Dept Totals: (81,420.00) (81,420.00) ** .00 Budgeted 81,420.00 Remaining 0 % Used Department Totals: Fund 137 Totals: (286,420.00) Monthly Total (286,420.00) Monthly Total .00 Budgeted .00 Budgeted 78 of 120 (286,420.00) ** 286,420.00 Remaining 0 % Used (286,420.00) 286,420.00 Remaining 0 % Used November 14, 2019 Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - WWTP TAX BOND CONST BALANCE SHEET OCTOBER 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 517 TAX BOND CONSTRUCTION 568,105 TOTAL ASSETS 568,105 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 685,476 TOTAL LIABILITIES 685,476 FUND BALANCE ASSIGNED FUND BALANCE (118,410) NET REVENUES / EXPENDITURES 1,039 TOTAL FUND BALANCE (117,371) TOTAL LIABILITIES AND FUND BALANCE 568,105 79 of 120 glbase_tbam skrolczyk 17:07 11/07/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: 10/2019 Amended Total Budget Encumb. Current Month Program: YTD Total % of Budget Page 14 November 14, 2019 Regular Meeting Agenda Packet Remaining Budget 517-49011-000-000 Interest Income 1,038.84- 1,038.84- 1,038.84 Subtotal: 1,038.84- 1,038.84- 1,038.84 Program number: 1,038.84- 1,038.84- 1,038.84 Department number: Revenues 1,038.84- 1,038.84- 1,038.84 Revenues Subtotal 1,038.84- 1,038.84- 1,038.84 Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 1,038.84- 1,038.84- 1,038.84 80 of 120 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/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 217 10/31/2019 Bank Interest- October (1,038.84) (1,038.84) GL Account: 517-49011-000-000 Interest Income Totals: (1,038.84) (1,038.84) ** .00 Budgeted 1,038.84 Remaining 0 % Used Department Totals: (1,038.84) ** (1,038.84) Monthly Total .00 Budgeted 1,038.84 Remaining 0 % Used Fund 517 Totals: (1,038.84) (1,038.84) Monthly Total .00 Budgeted 81 of 120 1,038.84 Remaining 0 % Used November 14, 2019 Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET OCTOBER 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 82 of 120 81,691 81,691 698,648 698,648 780,339 November 14, 2019 Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - 16" WATERLINE REV BOND BALANCE SHEET OCTOBER 2019 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND CASH IN BANK 585,675 INVESTMENTS 3,869,575 ACCOUNTS RECEIVABLE TOTAL ASSETS 4,455,250 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 4,454,290 NET REVENUES / EXPENDITURES 960 TOTAL FUND BALANCE 4,455,250 TOTAL LIABILITIES AND FUND BALANCE 4,455,250 83 of 120 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 15 17:07 11/07/19 Budget Summary with Amendment Fund: 520 Revenue Bond 16" Waterline Department: Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 520-49011-000-000 Subtotal: Program number: Department number: Revenues Interest Income Subtotal Fund number: 520 Revenue Bond 16" Waterline 84 of 120 959.75- 959.75- 959.75- 959.75- 959.75- 959.75- 959.75- 959.75- 959.75- 959.75- 959.75- 959.75- 959.75 959.75 959.75 959.75 959.75 959.75 glpdatb2 skrolczyk 17:07 11/07/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: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 520-49011-000-000 Interest Income 217 10/31/2019 Bank Interest- October (959.75) (959.75) GL Account: 520-49011-000-000 Interest Income Totals: (959.75) (959.75) ** .00 Budgeted 959.75 Remaining 0 % Used Department Totals: (959.75) ** (959.75) Monthly Total .00 Budgeted 959.75 Remaining 0 % Used Fund 520 Totals: (959.75) (959.75) Monthly Total .00 Budgeted 85 of 120 959.75 Remaining 0 % Used November 14, 2019 Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET OCTOBER 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 815,113 TOTAL ASSETS 815,113 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 86 of 120 803,457 11,655 815,113 815,113 glbase_tbam skrolczyk 17:07 11/07/19 Fund: 528 2015 Revenue Bond Reserve Fund Department: Account Description 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 Trophy Club MUD No.1 Page 16 Budget Summary with Amendment Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 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- 87 of 120 1,305.47- 4,600.00- 5,750.00- 1,305.47- 4,600.00- 5,750.00- 11,655.47- 11,655.47- 11,655.47- 11,655.47- 11,655.47- 11,655.47- 11,655.47- 11,655.47- 11,655.47- 11,655.47- 11.868 1.498 2.869 2.248 9,694.53- 302,449.00- 194,667.00- 506,810.53- 2.248 506,810.53- 2.248 2.248 2.248 506,810.53- 506,810.53- 506,810.53- glpdatb2 skrolczyk 17:07 11/07/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 217 10/31/2019 Bank Interest- October Account: 528-49011-000-000 Trophy Club MUD No.1 Page 48 Detailed Accounting Trial Balance Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Interest Income Totals: (11,000.00) Budgeted (9,694.53) Remaining 12 % Used Account: 528-49142-000-000 Interfund transfer in -Water 158 10/31/2019 TexPool Transfers October TexPool O&M to Rev Bond Resevr Account: 528-49142-000-000 Interfund transfer in -Water Totals: (307,049.00) Budgeted (302,449.00) Remaining Account: 528-49143-000-000 Interfund transfer in -WW 158 10/31/2019 TexPool Transfers October TexPool 0&M to Rev Bond Resevr Account: 528-49143-000-000 Department Totals: Fund 528 Totals: Interfund transfer in -WW Totals: (200,417.00) Budgeted (194,667.00) Remaining (1,305.47) (1,305.47) GL (1,305.47) (1,305.47) ** (4,600.00) (4,600.00) GL 1 % Used (4,600.00) (4,600.00) ** (5,750.00) (5,750.00) GL 3 % Used (11,655.47) Monthly Total (518,466.00) Budgeted (11,655.47) Monthly Total (518,466.00) Budgeted 88 of 120 (5,750.00) (5,750.00) ** (11,655.47) ** (506,810.53) Remaining 2 % Used (11,655.47) (506,810.53) Remaining 2 % Used November 14, 2019 Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - I&S (DEBT SERVICE) BALANCE SHEET OCTOBER 2019 ASSETS CASH IN BANK INVESTMENTS PREPAID EXPENSES ADVALOREM PROPERTY TAXES RECEIVABLE ACCOUNTS RECEIVABLE -OTHER TOTAL ASSETS LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 89 of 120 TROPHY CLUB MUNICIPAL UTILITY DISTRICT INTEREST & SINKING- 533 101,433 701,994 803,427 701,994 701,994 82,954 18,479 101,433 803,427 glbase_tbam skrolczyk 17:07 11/07/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: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Page 17 682,441.00- 1,000.00- 2,000.00- 682,441.00- 1,000.00- 2,000.00- 8,724.42- 839.78 42.80- 8,724.42- 839.78 42.80- 1.278 -83.978 2.140 673,716.58- 1,839.78- 1,957.20 - Subtotal: 685,441.00- 685,441.00- 7,927.44- 7,927.44- 1.157 677,513.56- 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- 136.86- 136.86- 2.737 4,863.14- 218,004.00- 533-49141-000-000 Interfund Trans In -PID Surchg 114,563.00- 114,563.00- 10,414.81- 10,414.81- 9.091 104,148.19 - Subtotal: 337,567.00- 337,567.00- 10,551.67- 10,551.67- 3.126 327,015.33 - Program number: 1,023,008.00- 1,023,008.00- 18,479.11- 18,479.11- 1.806 1,004,528.89 - Department number: Revenues 1,023,008.00- 1,023,008.00- 18,479.11- 18,479.11- 1.806 1,004,528.89 - Revenues Subtotal 1,023,008.00- 1,023,008.00- 18,479.11- 18,479.11- 1.806 1,004,528.89- 90 of 120 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 18 17:07 11/07/19 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 2,150.00 2,150.00 533-70025-051-000 Bond Interest Expense -Tax 266,058.00 266,058.00 533-70035-051-000 Bond Principal Payment -Tax 755,000.00 755,000.00 Subtotal: 1,023,208.00 1,023,208.00 Program number: 1,023,208.00 Department number: Administration Expenditures Subtotal Fund number: 533 MUD 1 I&S Consolidated 2,150.00 266,058.00 755,000.00 1,023,208.00 1,023,208.00 1,023,208.00 1,023,208.00 1,023,208.00 1,023,208.00 1,023,208.00 200.00 200.00 91 of 120 18,479.11- 18,479.11- -9,239.555 1,023,208.00 1,023,208.00 18,679.11 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 533 MUD 1 ISS Consolidated Department: Revenues Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/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 188 10/02/2019 Property Taxes 191 10/08/2019 Property Taxes 192 10/09/2019 Property Taxes 193 10/10/2019 Property Taxes 194 10/11/2019 Property Taxes 196 10/15/2019 Property Taxes 197 10/16/2019 Property Taxes 198 10/17/2019 Property Taxes 199 10/18/2019 Property Taxes 200 10/21/2019 Property Taxes 201 10/22/2019 Property Taxes 202 10/24/2019 Property Taxes 203 10/25/2019 Property Taxes 204 10/28/2019 Property Taxes 205 10/29/2019 Property Taxes 206 10/30/2019 Property Taxes 207 10/31/2019 Property Taxes (27.48) (27.48) GL (259.41) (286.89) GL (92.76) (379.65) GL (135.58) (515.23) GL (465.45) (980.68) GL (128.22) (1,108.90) GL (4.58) (1,113.48) GL (233.74) (1,347.22) GL (402.79) (1,750.01) GL (503.82) (2,253.83) GL (104.78) (2,358.61) GL (716.84) (3,075.45) GL (312.17) (3,387.62) GL (3,527.70) (6,915.32) GL (218.27) (7,133.59) GL (629.30) (7,762.89) GL (961.53) (8,724.42) GL Account: 533-40000-000-000 Property Taxes Totals: (8,724.42) (8,724.42) ** (682,441.00) Budgeted (673,716.58) Remaining 1 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 189 10/03/2019 Property Taxes 190 10/07/2019 Property Taxes 193 10/10/2019 Property Taxes 194 10/11/2019 Property Taxes 196 10/15/2019 Property Taxes 199 10/18/2019 Property Taxes 201 10/22/2019 Property Taxes 202 10/24/2019 Property Taxes 203 10/25/2019 Property Taxes 205 10/29/2019 Property Taxes 206 10/30/2019 Property Taxes 579.77 579.77 GL (9.63) 570.14 GL 21.24 591.38 GL (21.57) 569.81 GL (2.22) 567.59 GL 408.60 976.19 GL (112.82) 863.37 GL (.33) 863.04 GL (6.31) 856.73 GL (8.12) 848.61 GL (8.83) 839.78 GL Account: 533-40002-000-000 Property Taxes/Delinquent Totals: 839.78 839.78 ** (1,000.00) Budgeted (1,839.78) Remaining -84 % Used Account: 533-40015-000-000 Property Taxes/P & I 190 10/07/2019 Property Taxes 194 10/11/2019 Property Taxes 92 of 120 (1.96) (1.96) GL (4.53) (6.49) GL glpdatb2 skrolczyk Trophy Club MUD No.1 Page 50 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 196 10/15/2019 Property Taxes (.39) (6.88) GL 201 10/22/2019 Property Taxes (30.65) (37.53) GL 203 10/25/2019 Property Taxes (1.14) (38.67) GL 205 10/29/2019 Property Taxes (1.22) (39.89) GL 206 10/30/2019 Property Taxes (2.91) (42.80) GL Account: 533-40015-000-000 Property Taxes/P & I Totals: (42.80) (42.80) ** (2,000.00) Budgeted Account: 533-49011-000-000 Interest Income 217 10/31/2019 Bank Interest- October (1,957.20) Remaining 2 % Used (136.86) (136.86) GL Account: 533-49011-000-000 Interest Income Totals: (136.86) (136.86) ** (5,000.00) Budgeted (4,863.14) Remaining 3 % 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 158 10/31/2019 TexPool Transfers October TexPool O&M to I&S- PID Debt (10,414.81) (10,414.81) GL Account: 533-49141-000-000 Interfund Trans In -PID Surchg Totals: (114,563.00) Budgeted (104,148.19) Remaining (10,414.81) (10,414.81) ** 9 % Used Department Totals: (18,479.11) ** (18,479.11) Monthly Total (1,023,008.00) Budgeted (1,004,528.89) Remaining 2 % Used 93 of 120 glpdatb2 skrolczyk 17:07 11/07/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: 10/2019 JE Detail Beginning Balance Description/Comment Program: Page 51 November 14, 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 (18,479.11) Monthly Total 755,000.00 Remaining 0 % Used .00 ** 1,023,208.00 Budgeted 1,023,208.00 Remaining 0 % Used (18,479.11) 200.00 Budgeted 18,679.11 Remaining ########## 94 of 120 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 (18,479.11) Monthly Total 755,000.00 Remaining 0 % Used .00 ** 1,023,208.00 Budgeted 1,023,208.00 Remaining 0 % Used (18,479.11) 200.00 Budgeted 18,679.11 Remaining ########## 94 of 120 November 14, 2019 Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - REVENUE BOND I&S (WWTP) BALANCE SHEET OCTOBER 2019 CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND ASSETS I&S WWTP 78,985 TOTAL ASSETS 78,985 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 24,518 54,467 78,985 TOTAL LIABILITIES AND FUND BALANCE 78,985 95 of 120 glbase_tbam skrolczyk 17:07 11/07/19 Fund: 534 2015 Revenue Bond I&S Account 1 1 534-49011-000-000 1 Description Interest Income Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Period Ending: 10/2019 Adopted Amended Total Budget Budget Encumb. 2,500.00- 2,500.00 - Current Month 45.27 - Program: YTD Total 45.27 - Page 19 November 14, 2019 Regular Meeting Agenda Packet % of Remaining Budget Budget 1.811 2,454.73- 534-49143-000-000 Interfund Transfer In -WW Sales 598,638.00- 598,638.00- 54,421.63- 54,421.63- 9.091 544,216.37 - Subtotal: 601,138.00- 601,138.00- 54,466.90- 54,466.90- 9.061 546,671.10 - Program number: 601,138.00- 601,138.00- 54,466.90- 54,466.90- 9.061 546,671.10 - Department number: Revenues 601,138.00- 601,138.00- 54,466.90- 54,466.90- 9.061 546,671.10 - Revenues Subtotal 601,138.00- 601,138.00- 54,466.90- 54,466.90- 9.061 546,671.10- 96 of 120 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 20 17:07 11/07/19 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/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,466.90- 54,466.90- 2,178.676 51,966.90 97 of 120 glpdatb2 skrolczyk 17:07 11/07/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: 10/2019 Beginning Balance JE Detail Description/Comment Program: Page 52 November 14, 2019 Regular Meeting Agenda Packet Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Check Source Number Department Totals: (598,638.00) Budgeted (54,466.90) Monthly Total (544,216.37) Remaining 9 % Used (601,138.00) Budgeted 98 of 120 (54,466.90) ** (546,671.10) Remaining 9 % Used Account: 534-49011-000-000 Interest Income 217 10/31/2019 Bank Interest- October (45.27) (45.27) GL Account: 534-49011-000-000 Interest Income Totals: (45.27) (45.27) ** (2,500.00) Budgeted (2,454.73) Remaining 2 % Used Account: 534-49143-000-000 Interfund Transfer In -WW Sales 158 10/31/2019 TexPool Transfers October TexPool O&M to Rev Bd WWTP I&S (54,421.63) (54,421.63) GL Account: 534-49143-000-000 Interfund Transfer In -WW Sales Totals: (54,421.63) (54,421.63) ** Department Totals: (598,638.00) Budgeted (54,466.90) Monthly Total (544,216.37) Remaining 9 % Used (601,138.00) Budgeted 98 of 120 (54,466.90) ** (546,671.10) Remaining 9 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 53 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/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 % Used .00 Monthly Total 598,638.00 Budgeted .00 ** 598,638.00 Remaining 0 % Used Fund 534 Totals: (54,466.90) (54,466.90) Monthly Total (2,500.00) Budgeted 51,966.90 Remaining ########## 99 of 120 November 14, 2019 Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET OCTOBER 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 30,025 TOTAL ASSETS 30,025 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 4,967 25,058 30,025 TOTAL LIABILITIES AND FUND BALANCE 30,025 100 of 120 glbase_tbam skrolczyk 17:07 11/07/19 Fund: 535 2016 Rev Bond I&S-SWIFT Account 535-49011-000-000 535-49142-000-000 Description Interest Income Interfund Tran In -Water Sales Subtotal: Program number: Department number: Revenues Revenues 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: 10/2019 Amended Total Budget Encumb. 1,000.00- 275,525.00- 276,525.00- 276,525.00- 276,525.00- 276,525.00- 101 of 120 Program: Current YTD Month Total 10.54- 10.54- 25,047.72- 25,047.72- 25,058.26- 25,058.26- 25,058.26- 25,058.26- 25,058.26- 25,058.26- 25,058.26- 25,058.26 - Page 21 November 14, 2019 Regular Meeting Agenda Packet % of Budget 1.054 9.091 9.062 9.062 9.062 9.062 Remaining Budget 989.46- 250,477.28- 251,466.74- 251,466.74- 251,466.74- 251,466.74- glbase_tbam skrolczyk Trophy Club MUD No.1 Page 22 17:07 11/07/19 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/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 602,611.00 602,611.00 326,086.00 326,086.00 102 of 120 25,058.26- 25,058.26- -7.685 800.00 386,811.00 215,000.00 602,611.00 602,611.00 602,611.00 602,611.00 351,144.26 glpdatb2 skrolczyk 17:07 11/07/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: 10/2019 Beginning Balance JE Detail Description/Comment Program: Page 54 November 14, 2019 Regular Meeting Agenda Packet Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Check Source Number Department Totals: (275,525.00) Budgeted (25,058.26) Monthly Total (250,477.28) Remaining 9 % Used (276,525.00) Budgeted 103 of 120 (25,058.26) ** (251,466.74) Remaining 9 % Used Account: 535-49011-000-000 Interest Income 217 10/31/2019 Bank Interest- October (10.54) (10.54) GL Account: 535-49011-000-000 Interest Income Totals: (10.54) (10.54) ** (1,000.00) Budgeted (989.46) Remaining 1 % Used Account: 535-49142-000-000 Interfund Tran In -Water Sales 158 10/31/2019 TexPool Transfers October TexPool O&M to 16Swift Rev I&S (25,047.72) (25,047.72) GL Account: 535-49142-000-000 Interfund Tran In -Water Sales Totals: (25,047.72) (25,047.72) ** Department Totals: (275,525.00) Budgeted (25,058.26) Monthly Total (250,477.28) Remaining 9 % Used (276,525.00) Budgeted 103 of 120 (25,058.26) ** (251,466.74) Remaining 9 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 55 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond IBS -SWIFT Department: 51 Administration Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/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 nn - Account: 535-70045-051-000 Revenue Bond Principal Expense Account: 535-70045-051-000 Revenue Bond Principal Expense Totals: 215,000.00 Budgeted 215,000.00 Remaining Department 51 Totals: .00 Monthly Total .00 .00 O % Used .00 ** 602,611.00 Budgeted 602,611.00 Remaining 0 % Used Fund 535 Totals: (25,058.26) (25,058.26) Monthly Total 326,086.00 Budgeted 104 of 120 351,144.26 Remaining -8 % Used November 14, 2019 Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET OCTOBER 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB i No. 1 MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 29,738 TOTAL ASSETS 29,738 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES 29,738 TOTAL FUND BALANCE 29,738 TOTAL LIABILITIES AND FUND BALANCE 29,738 105 of 120 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 23 17:07 11/07/19 Budget Summary with Amendment Fund: 536 2019 Rev Bond I&S- W&WW System Department: Revenues Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/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 2.98- 2.98- 22,896.02- 22,896.02- 6,839.07- 6,839.07- 2.98 22,896.02 6,839.07 Subtotal: 29,738.07- 29,738.07 - 29,738.07 Program number: 29,738.07 - Department number: Revenues Revenues Subtotal Fund number: 536 2019 Rev Bond I&S- W&WW System End of Report ********* 106 of 120 29,738.07- 29,738.07 29,738.07- 29,738.07- 29,738.07- 29,738.07- 29,738.07- 29,738.07- 29,738.07 29,738.07 29,738.07 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 56 17:07 11/07/19 Detailed Accounting Trial Balance Fund: 536 2019 Rev Bond I&S- W&WW System Department: Revenues Program: November 14, 2019 Regular Meeting Agenda Packet Period Ending: 10/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 217 10/31/2019 Bank Interest- October (2.98) (2.98) GL Account: 536-49011-000-000 Interest Income Totals: (2.98) (2.98) ** .00 Budgeted 2.98 Remaining 0 6 Used Account: 536-49142-000-000 Interfund Tran In -Water Sales 158 10/31/2019 TexPool Transfers October TexPool O&M to 19 W&WW Rev I&S Account: 536-49142-000-000 Interfund Tran In -Water Sales Totals: .00 Budgeted 22,896.02 Remaining Account: 536-49143-000-000 Interfund Transfer In -WW Sales 158 10/31/2019 TexPool Transfers October TexPool O&M to 19 W&WW Rev I&S Account: 536-49143-000-000 Interfund Transfer In -WW Sales Totals: .00 Budgeted 6,839.07 Remaining (22,896.02) (22,896.02) GL 0 % Used (22,896.02) (22,896.02) ** (6,839.07) (6,839.07) GL 0 % Used (6,839.07) (6,839.07) ** Department Totals: (29,738.07) ** (29,738.07) Monthly Total .00 Budgeted 29,738.07 Remaining 0 % Used Fund 536 Totals: (29,738.07) (29,738.07) Monthly Total .00 Budgeted 29,738.07 Remaining 0 % Used Grand Totals: (384,181.61) **** ******* End of Report ********* (384,181.61) Monthly Total (919,561.00) Budgeted 107 of 120 (535,379.39) Remaining 42 % Used BUDGET VARIANCE REPORT FUND: FINANCIALS MONTH: REVENUE VARIANCE: EXPENSE VARIANCE: NOTE: ACCOUNT FIRE REVENUES 122-40010 122-40011 122-40020 FIRE EXPENSES 122-69195-045 122-69305-045 122-69009-045 November 14, 2019 Regular Meeting Agenda Packet 122 - Fire O&M October 2019 0.0% 18.3% 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 Property Taxes/Mud Fire Property Taxes/Fire - Delinquent Property Taxes/Fire P&I GASB34/Reserve for Replacement Capital Leases Capital Leases Interest TOTAL CURRENT YTD BUDGET MONTH TOTAL $1,214,230 $15,523 $15,523 -$1,368 -$1,368 $68 $68 YTD % DATE OF COMMENT 1.28% 10/2019 Property Taxes/MUD Fire VARIANCE EXPLANATION 10/2019 Delinquent Fire Taxes collected/paid out 10/2019 Fire Taxes Penalties & Interest collected $ 81,420 $ 81,420 $ 81,420 100.00% 10/2019 Annual Contribution for Reserve Replacement $ 127,149 $ 115,190 $ 115,190 90.59% 10/2019 Annual Fire Truck Payment 11,958 11,958 108 of 120 10/2019 Seperated out Interest Expense of Annual Fire Truck Payment BUDGET VARIANCE FUND: FINANCIALS MONTH: REVENUE VARIANCE: EXPENSE VARIANCE: NOTE: ACCOUNT REVENUE 135-40000-000 135-40002-000 135-40015-000 EXPENSES WATER 135-69195-010 WASTEWATER 135-55081-020 135-60135-020 135-69195-020 BOARD OF DIRECTORS ADMINISTRATION 135-55030-030 1 Non -Departmental November 14, 2019 Regular Meeting Agenda Packet REPORT 135 - MUD 1 O&M October 2019 0.0% 18.3% 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 Property Taxes/Delinquent Property Taxes/P&I 134,871 $300 $300 1,723 -$156 $8 1,723 -$156 $8 1.28% 10/2019 -51.89% 10/2019 2.61% 10/2019 Property Taxes Delinquent Tax Shortage/Paid Out Property Taxes/P&I GASB34/Reserve for Replacement $75,000 $75,000 $75,000 100.00% 10/2019 Annual GASB34 Replacement Maintenance & Repairs Collections TCEQ Fees & Permits GASB34/Reserve for Replacement $10,000 $7,509 $7,509 $15,000 $9,888 $9,888 $130,000 $130,000 $130,000 75.09% 10/2019 65.92% 10/2019 100.00% 10/2019 Avenue Twenty Lift Station Repair WWTP Permit Fees; WWTP Permit Annual GASB34 Replacement Software & Support $134,681 $65,526 $65,526 48.65% 10/2019 Annual IT Contract with M3 Networks 109 of 120 November 14, 2019 Regular Meeting Agenda Packet Trophy Club Municipal Utility District No. 1 Date: 11/14/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 Board meeting Breaks and Leaks — One main break occurred since the last Board packet was published, and technically prior to the last Board meeting, on Rivera Court. The outage affected three (3) houses and lasted for two hours. Samples were taken and negative for contamination. 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. Parcel 1 is complete and signed up, and Parcels 3, 4, 5, 7, and 8 have been verbally accepted by the relevant landowners. WWTP — Our special inspector's report, which has been provided to the Board in a separate distribution, was discussed in Austin on October 25 with WCP — PLW. At the end of the meeting, which was intended to provide the contractor with the opportunity to discuss the findings of the report with the authors of the report, WCP-PLW said they would prepare a position statement on the findings of the special inspector. We expect that to be delivered soon. A separate WWTP project, the in -plant water system, is slated for installation the week of November 11th High Service Pump Station Improvements — The startup on the new pumps is anticipated to occur during the week of November 11tH System Repairs One water service line was tunneled under Carnoustie to replace a leaking service. 110 of 120 J November 14, 2019 Regular Meeting Agenda Packet Monthly Water Operations Report Water Billed FY October November December January February March April May June July August September Total Year 2010 39,794 39,713 29,547 30,305 25,328 23,279 41,646 53,439 102,921 89,760 128,687 82,331 686,750 2011 70,502 50,909 44,365 35,983 27,845 55,972 69,165 61,467 99,326 117,707 170,464 123,692 927,397 2012 85,869 53,571 40,815 30,616 31,665 35,263 47,194 84,905 114,104 137,174 144,573 108,622 914,371 2013 85,488 75,251 48,527 39,601 34,450 43,137 56,947 76,542 85,312 110,072 130,945 114,497 900,769 2014 82,660 48,813 34,482 39,767 37,085 54,794 66,337 84,384 99,240 92,913 113,135 110,873 864,483 2015 90,994 58,986 49,607 36,162 38,776 30,566 46,543 39,576 60,731 100,622 139,441 123,886 815,890 2016 108,951 41,936 39,028 39,622 44,551 49,498 55,181 50,827 65,390 115,687 119,611 98,945 829,227 2017 74,785 68,638 38,580 33,028 38,380 60,841 56,683 86,794 98,864 95,355 104,303 99,541 855,792 2018 83,228 69,099 48,144 34,592 40,658 43,411 60,079 89,802 118,899 126,588 125,531 73,735 913,766 2019 47,193 41,933 36,244 34,604 33,740 40,421 55,970 42,773 70,747 96,174 131,472 114,784 746,055 2020 1 102,150 1 1 1 1 1 1 1 1 1 I 1 1 1 1 102,150 WATER BILLED IN THOUSANDS OF GALLONS 140,000 120,000 100,000 /' -2016 -2017 80,000 -2018 -2019 60,000 - -2020 40,000 20,000 0 October November December January February March April May June September 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 1 1 1 1 1 1 112,9711 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 2020 Total 2020 MUD 2020 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 4795 3351 1444 111 of 120 Ammonia -N November 14, 2019 Regular Meeting Agenda Packet October 2019 Results CBOD5 TSS Date % Removal % Removal % Removal Influent Effluent Influent Effluent Influent Effluent 1 -Oct 25 0.20 99.2% 321 2.0 99.4% 323 1.0 99.7% 2 -Oct 70.0 0.20 99.7% 274 2.0 99.3% 270 1.0 99.6% 7 -Oct 46 0.20 99.6% 388 2.0 99.5% 432 1.0 99.8% 10 -Oct 47.5 0.20 99.6% 203 2.0 99.0% 320 1.0 99.7% 14 -Oct 44.5 0.20 99.6% 300 2.0 99.3% 278 1.0 99.6% 17 -Oct 44.5 0.41 99.1% 282 2.0 99.3% 209 1.0 99.5% 21 -Oct 52.8 0.70 98.7% 183 2.0 98.9% 206 1.0 99.5% 24 -Oct 45.5 0.20 99.6% 277 2.0 99.3% 232 1.0 99.6% 28 -Oct 47.5 0.2 99.6% 264 2.0 99.2% 264 1.0 99.6% 30 -Oct 37.0 0.2 99.5% 241 2 99.2% 180 1.0 99.4% IReport Ammonia -N 0.29 99.4% CBOD5 2.0 112 of 120 1 99.2% 1.0 TSS 1 99.6% I 3.50 3.00 2.50 2.00 1.50 1.00 0.50 0.00 6.0 5.0 4.0 3.0 2.0 1.0 0.0 November 14, 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 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 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 I: 11 11 11 11 11 11 11 11 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 113 of 120 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 November 14, 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 -. .. .. -. -. -. 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.304.0 4.97 4.69 4.6 4.68 5.1 4.74 57 4.86 4.73 5.9 4.8 5.1 4.9 4.6 5.19 1 1 1111 , 1 3.5 , 1 1 1 1 1 1 3.7 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 114 of 120 Aug -19 Sep -19 Oct -19 Nov -19 Dec -19 T55 T55 Ave Permit Limit N -N N -N Aver Permit Limit 10 9 8 7 6 5 4 3 2 1 0 10.0 9.0 8.0 7.0 6.0 5.0 4.0 3.0 2.0 1.0 0.0 November 14, 2019 Regular Meeting Agenda Packet E. Coli Permit Limit 126 1.0 1.0 1.0 1.0 • 11 11 1 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 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 High 9 8.36 7.89 7.81 61 7.42 '.45 7.44 7.327.417.37 7.197.347.27 7.28 7.59 7.347.627.48 7.357.457.40 7.26 5 7.23 6.98 7.11 6.88 6.58 6.73 6.37 7.80 7.09 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 115 of 120 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 November 14, 2019 Regular Meeting Agenda Packet Dissolved Oxygen (DO) 7.77 7.5 7.5 Permit 1 imit Max q - ,9 7.5 7.63 7.8 7.56 7.7 7.48 7.6 7.33 7.6 ' it Limit M 22 7.5 61 7.37 7.6 7.7 7.6 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 116 of 120 Sep -19 Oct -19 Nov -19 Dec -19 - DO - DO Aver - Permit Limit Min. - Permit Limit Max ebills Bills Mailed Bank Draft Credit Card Draft Online Payments Late Notices Disconnects Connections Trophy Club MUD 81 Utility Billing Report Fiscal Year 2020 October November December January February March 938 3841 646 1193 1145 378 21 M 3351 P 1444 ebills Bills Mailed Bank Draft Credit Card Draft Online Payments Late Notices Disconnects M Connections P November 14, 2019 Regular Meeting Agenda Packet April May June July August September 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 117 of 120 November 14, 2019 Regular Meeting Agenda Packet MUD Permits Month: October 2019 Plumbing Sewer Date of Customer Deposit Due to FW Water 135- Inspections 135- Inspections 135 - Permit Permit No. 135-25030 20500 Oversize Meter 135-49075 47035 47045 2020-01 $ 75.00 $ 1,173.00 $ 353.00 $ 150.00 $ 50.00 2020-02 $ 75.00 $ 1,173.00 $ 353.00 $ 150.00 $ 50.00 2020-03 $ 100.00 $ 4,396.00 $ 353.00 $ 150.00 2020-04 $ 500.00 $ 14,066.00 $ 912.64 $ 150.00 2020-05 $ 100.00 $ 4,396.00 $ 353.00 $ 150.00 2020-06 $ 500.00 $ 14,066.00 $ 912.64 $ 150.00 2020-07 $ 75.00 $ 4,396.00 $ 353.00 $ 150.00 $ 50.00 2020-08 $ 75.00 $ 4,396.00 $ 353.00 $ 150.00 $ 50.00 2020-09 $ 75.00 $ 4,396.00 $ 353.00 $ 150.00 $ 50.00 2020-10 $ 75.00 $ 4,396.00 $ 353.00 $ 150.00 $ 50.00 2020-11 $ 75.00 $ 4,396.00 $ 353.00 $ 150.00 $ 50.00 2020-12 $ 75.00 $ 4,396.00 $ 353.00 $ 150.00 $ 50.00 Total $ 1,800.00 $ 65,646.00 $ 5,355.28 $ 118 of 120 Fire Line 135-49900 1,800.00 $ 400.00 $ Misc Income 135-49900 Total $ 1,801.00 $ 1,801.00 $ 4,999.00 $ 15,628.64 $ 4,999.00 $ 15,628.64 $ 1,200.00 $ 6,224.00 $ 1,200.00 $ 6,224.00 $ 1,200.00 $ 6,224.00 $ 1,200.00 $ 6,224.00 $ 1,200.00 $ 6,224.00 $ 1,200.00 $ 6,224.00 $ 7,200.00 $ 82,201.28 CASH STATUS AS OF OCTOBER 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) *10/31/2019 Customer Water Deposits $319,829 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 119 of 120 November 14, 2019 Regular Meeting Agenda Packet Restricted - Unable to be spent $o $319,829 $1,397,251 $0 $0 $919,266 $568,106 $0 $0 $780,339 $585,675 $3,869,575 $815,113 $101,433 $0 $78,985 $30,025 $78,985 $9,465,595 $o $0 Unrestricted - Available for spending $4,317,837 $1,978,445 $0 $150 $450 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $6,296,882 1 $0 1 $6,296,882 $6,296,882 $329,851 $0 $329,851 1 $329,851 $329,851 Total in Accounts (Restricted & Unrestricted) $4,317,837 $2,298,274 $1,397,251 $150 $450 $919,266 $568,106 $0 $0 $780,339 $585,675 $3,869,575 $815,113 $101,433 $0 $78,985 $30,025 $78,985 $15,762,477 General Fund 135 Available 1,978,445 Prosperity General Fund 4,317,837 Texpool General Fund 600 Petty Cash 6,296,882 3,486 2,072,098 6,325,800 212,239 $8,613,624 $329,851 $0 $329,851 TC Meeting Spaces December 2019 Sun Mon Tue 49 Dec 1, 2019 2 3 Wed November 14, 2019 Regular Meeting Agenda Packer, Modifier Thu 4 5 50 8 9 10 51 15 52 16 17 6:30pm �.� Board of 22 23 24 *District Closing at 1 29 30 31 Printed on: 11/04/2019 10:30pm 11 Fri Sat 7 12 13 14 18 19 25 *District Closed - 120 of 120 • 20 21 26 27 28 3 4 Powered by ;- teamup