Loading...
HomeMy WebLinkAbout2020-0420 April 20, 2020 Regular Meeting Agenda PacketMonday, April 20, 2020 EPA TROPHY CLUB MUNICIPAL UTILITY DISTRICT BOARD OF DIRECTORS REGULAR MEETING April 20, 2020 Complete Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 100 MUNICIPAL DRIVE TROPHY CLUB, TEXAS 76262 6:30 P.M. Svore Municipal Boardroom REGULAR MEETING AGENDA PACKET In accordance with Order of the Office of the Governor issued March 16, 2020 and March 19, 2020, Trophy Club Municipal Utility District No. 1 Board of Directors will conduct a meeting at 6:30 p.m. on Monday, April 20, 2020 by Zoom/telephone conference. In order to advance the public health goal of limiting face- to-face meetings (also called "social distancing") to slow the spread of the Coronavirus (COVID-19), there will be no public access to the location described above. A recording of the telephonic meeting will be made and will be available to the public. To join the meeting via Zoom: https://zoom.us/i/94327321678 The public toll-free dial -in numbers to participate in the telephonic meeting are: (877) 853-5257 and (888) 475-4499; Meeting ID: 943 2732 1678 If you cannot get through on one of the numbers due to network congestion or if the audio quality is poor, please try the next number. When your call is answered you will hear "Welcome to Zoom, enter your Meeting ID followed by pound." Enter in the following Meeting ID below followed by the pound sign (#): Meeting ID: 943 2732 1678 CITIZEN COMMENTS: Public comment will be allowed during the Citizen Comment agenda item. No in-person input will be allowed. Members of the public that desire to provide public comment may do so by videoconference, by telephone or by submission of written comments. Written public comments that are timely received will be read into record and can be emailed to Islaght@tcmud.org. Written comments must be received by 4:00 PM on the date of the meeting. To provide verbal public comment remotely (by videoconference or telephone), members of the public must register in advance by emailing Islaght@tcmud.org prior to 4:00 p.m. on the date of the meeting. CALL TO ORDER AND ANNOUNCE A QUORUM CITIZEN COMMENTS This is an opportunity for citizens to address the Board on any matter whether or not it is posted on the agenda. 1 of 149 April 20, 2020 Complete Agenda Packet The Board is not permitted to take action on or discuss any comments made to the Board at this time concerning an item not listed on the agenda. The Board will hear comments on specific agenda items prior to the Board addressing those items. You may speak up to four (4) minutes or the time limit determined by the President or presiding officer. To speak during this item, you must complete the Speaker's form that includes the topic(s) of your statement. Citizen Comments should be limited to matters over which the Board has authority. CONSENT AGENDA All matters listed as Consent Agenda are considered to be routine by the Board of Directors and will be enacted by one motion. There will not be a separate discussion of these items. If discussion is desired, that item will be removed from the consent agenda and will be considered separately. 1. Consider and take appropriate action to approve the Consent Agenda. a. March 2020 Check Register b. March 16, 2020 Regular Meeting Minutes c. April 2, 2020 Special Meeting Minutes d. April 6, 2020 Special Meeting Minutes e. April 8, 2020 Special Meeting Minutes f. Quarterly Investment Report 2"d Quarter FY2020 g. Tax Collections 2nd Quarter FY2020 h. Ratify and approve the following utility operation and billing policies in response to the COVID-19 coronavirus to remain effective for so long as PUC's Project No. 50664 Order dated March 26, 2020 remains in effect or until such time as the Board of Directors approves otherwise: (i) suspend the disconnection of water and wastewater services to customers for non-payment; (ii) suspend the assessment of late fees for delinquent payment by customers; and (iii) suspend the application of interest on deferred payment plans. attachments: March Check Register March 16, 2020 Meeting Minutes April 2, 2020 Meeting Minutes April 6, 2020 Meeting Minutes April 8, 2020 Meeting Minutes Quarterly Investment Report Tax Collections REGULAR SESSION 2. Discussion and possible action regarding potential refunding of the Trophy Club Municipal Utility District No. 1 Unlimited Tax Bonds, Series 2020. attachment: Refunding Summary 3. Consider and take action related to the postponement of May 2, 2020 Director election and other matters related thereto. 2 of 149 April 20, 2020 Complete Agenda Packet 4. Discussion and possible action regarding Director attendance at Association of Water Board Directors (AWBD) 2020 Annual Conference scheduled for June 11 — June 13, 2020 at the Gaylord Texan in Grapevine, Texas. (Chapman/Rose) attachment: 2020 AWBD Annual Conference 5. Discussion and possible action relating to a proposed Agreement Regarding Real Property Matters between Trophy Club Municipal Utility District No. 1 and the Town of Trophy Club pertaining to the following real property matters: (i) the termination of leases and other matters relating to the Annex Building and Police Building located at Lot 2, Block 1, MUNICIPAL UTILITY DISTRICT NO. 1 COMPLEX, an addition to the Town of Trophy Club, Denton County, Texas, by a plat filed February 12, 2010, and recorded as Instrument Number 2010-22, of the Plat Records of Denton County, Texas; (ii) the lease of the storage and maintenance building located at the District's wastewater treatment facility; and (iii) the construction of road improvements and tree mitigation requirements applicable to the District's wastewater treatment facility tract. 6. Consider and take appropriate action regarding the March 2020 Combined Financials and Variance Report. a. Combined Financials b. Combined Variance attachments: Combined Financials Combined Variance REPORTS & UPDATES 7. Receive report from General Manager Hiring Committee. (Castonguay/Flynn) 8. General Manager Monthly Reports and Update: a. Regulatory Update b. Capital Improvement Projects • Wastewater Treatment Plant Upgrade Project • High Service Pump c. System Repairs & Maintenance d. Water System Operations e. Wastewater System Operations f. Finance Update • Utility Billing Report • Permits Collected • Cash Report attachments: General Manager Report Water Operations Report Wastewater Operations Report 3 of 149 April 20, 2020 Complete Agenda Packet Utility Billing report Permits Collected Cash Report EXECUTIVE SESSION 9. Pursuant to Section 551.071 of the Texas Open Meetings Act, the Board may consult with its attorney in Executive Session on a matter in which the duty of the attorney to the Governmental Body under the Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflicts with the Open Meetings Act or to seek advice of counsel on legal matters involving pending or contemplated litigation or settlement offers: a. Contractor breach, performance and payment issues related to District's contract with Webber- Cadagua Partners for construction of the Wastewater Treatment Plant Improvements; and b. Trophy Club Municipal Utility District No. 1 v. Acadia Services, LLC, In the District Court of Tarrant County, 141st Judicial District (Cause No. 141-299351-18). c. Potential Condemnation of Easements required for construction and operation of Water Transmission Line Improvements from District Pump Station to Elevated Water Tank located on T.W. King Road 10. Pursuant to Section 551.072 of the Texas Open Meetings Act, the Board may deliberate the purchase, exchange, lease, or value of real property if deliberation in an open meeting would have a detrimental effect on the position of the governmental body in negotiations with a third person: a. Sale or Exchange of District real property located at 100 Municipal Drive, 1501 Junction Way and other real property owned by the District. b. Purchase of Easements required for construction and operation of Water Transmission Line Improvements from District Pump Station to Elevated Water Tank located on T.W. King Road 11. Deliberations pursuant to Section 551.074(a)(1) of the Texas Open Meetings Act regarding the appointment, employment, evaluation, reassignment, duties, discipline, or dismissal of a public officer or employee: General Manager. REGULAR SESSION 12. Consider and take appropriate action on matters deliberated in Executive Session: 13. Items for future agendas: 14. Set future Meeting dates - Regular Board Meeting on May 20, 2020 at 6:30 p.m. attachment: May meeting calendar *THE BOARD RESERVES THE RIGHT TO ADJOURN INTO EXECUTIVE SESSION AT ANY TIME DURING THE 4 of 149 April 20, 2020 Complete Agenda Packet MEETING PURSUANT TO THE APPLICABLE SECTION OF SUBCHAPTER D, CHAPTER 551, TEXAS GOVERNMENT CODE, THE TEXAS OPEN MEETINGS ACT, WITH RESPECT TO ANY ITEM ON THE AGENDA. NO FINAL ACTION, DECISION OR VOTE WILL BE TAKEN ON ANY SUBJECT OR MATTER IN EXECUTIVE SESSION. THIS NOTICE MODIFIES THE DISTRICT'S PRIOR PRACTICE OF SPECIFICALLY IDENTIFYING ALL AGENDA ITEMS TO BE DISCUSSED IN EXECUTIVE SESSION. ADJOURN 5 of 149 apackamt2 skrolczyk Begin Date: 03/01/2020 End Date: 03/31/2020 Vendor Vendor Name Nutter 3080 CP&Y GROUP, INC. Totals for Check: 6238 2735 Jackson walker LLP Totals for Check: 6239 Prom Amt: Invoice Nu %et Invoice Inv Dept Account Date Stat No Number 9923000.00-43 02/18/20 P 1700085 02/18/20 P 2737 Trophy club Eco anic Dev Corp PARCEL 7 2737 TYcpby COIN Economic Dev Corp PARCEL 8 Totals for Check: 6240 2716 Wise, Janney, E1stner Assoc Tbtals for Check: 6241 998 AKK nimsneurs LLC Totals for check: 6242 998 ALBRIC r, i NIHO 1Y JAMES Totals for Check: 6243 998 AICERSCS1, JOSHUA Tbtals for Check: 6244 998 ASt3TCN WOODS BORES Totals for Check: 6245 998 ASHTON WACVS BOMBS Totals for Check: 6246 998 IQRAat7VIL, MARK Totals for Check: 6247 998 LURD, NICOLAS Totals for Check: 6248 998 RDPN VEND, INC. Totals far Check: 6249 998 SARTSN, RCS Totals for Check: 6250 998 TURNER, Emma Totals for Check: 6251 3127 ALLIED WELDING SUPPLY, INC Totals for Check: 6252 2738 O nsmn ty National Title LLC 02/24/20 V 02/24/20 V 0444585 02/19/20 P 20 517-69005-020-000 10 520-69005-010-000 10 520-69005-010-000 10 520-69005-010-000 20 517-69005-020-000 00030101289205A 02/28/20 P 135-20050-000-000 U0036010402102A 02/28/20 P 135-20050-000-000 119036002807901A 02/28/20 P 135-20050-000-000 00017000505100A 02/28/20 P 135-20050-000-000 00030600010100A 02/28/20 P 135-20050-000-000 U0010110012101A 02/28/20 P 135-20050-000-000 00010050366102A 02/28/20 P 135-20050-000-000 U0023120016202A 02/28/20 P 135-20050-000-000 110015030007103A 02/28/20 P 135-20050-000-000 110050060508107A 02/28/20 P 135-20050-000-000 R 22000124 02/29/20 P 10 135-55080-010-000 10 01/29/20 P 10 520-69005-010-000 Trophy club MUD No.1 AP Checks For Date/Amount Range .00 Tb Amt: 99,999,999.99 Description ("natal Outlays Capital Outlays Capital Outlays Capital Outlays Capital Outlays A/P Vendors A/P Vendors A/P Vendars A/P Vendors A/P Vendors A/P Vendors A/P VenrYrs A/P Venders A/P Vendors A/P Vetrs Maintenance & Repairs Capital Outlays 6 of 149 04/14/20 13ft-iI 20, 2020 Complete Agenda Rfitet 1 1•ine Item Check Check Value Rudder Date 2,957.91 6238 03/02/20 2,957.91 20,150.56 6239 03/02/20 20,150.56 64,106.00 6240 03/02/20 5,096.00 6240 03/02/20 69,202.00 2,112.50 6241 03/02/20 2,112.50 15.41 6242 03/02/20 15.41 52.65 6243 03/02/20 52.65 26.75 6244 03/02/20 26.75 46.39 6245 03/02/20 46.39 04.85 6246 03/02/20 04.85 30.10 6247 03/02/20 30.10 33.54 6248 03/02/20 33.54 11.43 6249 03/02/20 11.43 36.63 6250 03/02/20 36.63 64.57 6251 03/02/20 64.57 42.00 6252 03/12/20 42.00 940.00 6253 03/12/20 apackant2 skrolczyk Begin Date: 03/01/2020 End Date: 03/31/2020 Vendor Verb Name Nuaber Totals for Check: 6253 2655 Core & Main LP Totals for Check: 6254 3193 CXMPUPAY, INC. Totals for Check: 6255 3184 DATAPROSE LLC 3184 DATAPROSE LLC Totals for Check: 6256 invoice Number invoice Date L963434 Fran Amt: Inv Dept Account Stat No Nxrber 02/27/20 P PR00691 996 03/06/20 P DP2000623 DP2000623 1018 DEMON CENTRAL APPRAISAL DIS1R 8551 Totals for Check: 6257 2497 EMS AUMMAT1C , INC 2497 DHS ADICMATION, INC Totals far Check: 6258 06-1959 06-1957 2653 Dubois Bryant Campbell LLP 105302 Totals for Check: 6259 2717 Ersriroanental Tnprovaoents Inc 0044495 -IN Totals far Check: 6260 2606 Fisery Solutions, LIC Totals for (heck: 6261 3234 Fortress Resources, Totals for Check: 6262 1372 HACH COMPANY Totals for Check: 6263 2667 MOM CAT Totals for Check: 6264 3124 IRS Tax Payment 3124 IRS Tax Payment 3124 IRS Tax Payment Totals for Cheek: 6265 2943 JPMOMMN (BASE BANK NA Totais for Check: 6266 91667607 0120710 -IN 11867590 PIt1F0304167 PR00691 PR00691 PR00691 02262020 2754 LowER ccai RADO RIVER AUTHORITY LAB -0040957 2754 LOWER CX1i.[1RADO RIVER mammy LAB -0040958 02/29/20 P 02/29/20 P 03/01/20 P 02/28/20 P 02/28/20 P 03/11/20 P 03/01/20 P 03/03/20 P 02/01/20 P 03/05/20 P 02/26/20 P 996 03/06/20 P 996 03/06/20 P 996 03/06/20 9 02/26/20 P 02/28/20 P 02/28/20 P Trophy club MUD No.1 AP checks Far Date/Amount Range .00 To Amt: 99,999,999.99 04/14/20 1.3.400X120, 2020 Complete Agendacet 2 Description J.;ne Iter Check Check Value Nunber Date 940.00 20 135-55081-020-000 Mainten & Repairs Collections 656.10 6254 03/12/20 656.10 135-21313-000-000 Cafe 125 Medical Reinb 549.37 6255 03/12/20 549.37 30 135-60035-030-000 Postage 1,675.51 6256 03/12/20 30 135-55205-030-000 Utility Billing c. tract 588.05 6256 03/12/20 2,263.56 39 135-55060-039-000 Appraisal 2,243.48 6257 03/12/20 2,243.48 20 135-69005-020-000 Capital Outlays 8,536.00 6258 03/12/20 20 135-55080-020-000 Maintenance & Repairs 490.00 6258 03/12/20 9,026.00 20 517-69005-020-000 Capital Outlays 1,190.00 6259 03/12/20 1,190.00 20 135-55080-020-000 Maintenance & Repairs 1,400.00 6260 03/12/20 1,400.00 30 135-60040-030-000 Service Charges & Fees 50.00 6261 03/12/20 50.00 10 135-69005-010-000 Capital Outlays 7,550.00 6262 03/12/20 7,550.00 20 135-65045-020-000 Iab Supplies 342.38 6263 03/12/20 342.38 10 135-55105-010-000 Maintenance-Backhoe/Skierev'i 907.82 6264 03/12/20 907.82 135-21302-000-000 FWH Taxes 4,455.33 6265 03/12/20 135-21303-000-000 Social Security Taxes 5,468.98 6265 03/12/20 135-21304-000-000 Medicare Taxes 1,279.06 6265 03/12/20 11, 203.37 135-20060-000-000 Procurement Clearing 6,437.76 6266 03/12/20 6,437.76 10 135-55135-010-000 Lab Analysis 213.94 6267 03/12/20 10 135-55135-010-001 Lab Analysis far PID 213.94 6267 03/12/20 7 of 149 apackamt2 akrolczyk Begin Date: 03/01/2020 End Date: 03/31/2020 Vendor Vel Name Number Tbtals for Check: 6267 Ftuu Amt: Invoice Ntnber Invoice Inv Dept Account Date Stat No amber 2712 MARYLAND BIOCICINL CO, 1NC 3NN1026 Totals for Check: 6268 2643 McLean & Howard, L.L.P. 2643 McLean & Howard, L.L.P. Totals for Check: 6269 3156 OXECCRLAECPATCRIZS LLC 3156 OXt LABC$tATCRCPS LSC Tbtals for Check: 6270 1466 POLYDYNE, INC Totals for Check: 6271 03/06/20 P 20 135-65030-020-000 36113 02/29/20 P 39 135-55045-039-000 36112 02/29/20 P 39 135-55045-039-000 20030033 20030100 03/02/20 P 20 135-55135-020-000 03/05/20 P 20 135-55135-020-000 1435068 02/28/20 P 20 135-65030-020-000 2440 TARRANT CT1 PUBLIC HEALTH LAB 33198 2440 TARRANT CTY PUBLIC HEALTH LAB 33199 Totals for Check: 6272 3113 TCERS Tbtals for Check: 6273 02/29/20 P 10 135-55135-010-000 02/29/20 P 10 135-55135-010-001 PR00691 996 03/06/20 P 135-21317-000-000 02/29/20 P 30 135-60040-030-000 2696 Texas Excavation Safety System 20-03501 Totals for Check: 6274 2862 T=OE DATA SYST[S INC Totals far Check: 6275 3282 TIAA comacm FINANCE Totals for Check: 6276 1481 TML INIERGOVERIESUML RISK 1481 TML INTERGOVERMENIM RISC Totals for Check: 6277 1001 WAN OF TROPHY CLUB 1001 WAN OF TROPHY CLUB 1001 TOWN OF TROPHY CAB 1001 TOWN OF TROPHY CLUB 1001 TOWN OF TROPHY CDB Totals for Check: 6278 1081 TRI COUNTY ELECTRIC Totals for Check: 6279 53313 03/02/20 P 30 135-55030-030-000 7018806 03/07/20 P 30 135-69170-030-000 3464 03/01/20 P 10 135-50045-010-000 3464 03/01/20 P 20 135-50045-020-000 030120 03/03/20 P 45 122-60337-045-000 FEB REFUSE 02/29/20 P 135-25040-000-000 FEB REFUSE 02/29/20 P 135-25000-000-000 FEB REFUSE 02/29/20 P 135-25010-000-000 031020 03/10/20 P 30 135-60020-030-000 76819913 03/03/20 P 20 135-60020-020-000 1000 TROPHY CLUB MCD (U771TER RIMS) 02/28/20 02/28/20 P 30 135-60025-030-000 Troy C1ub MUD No.1 04/14/20 13233rll 20, 2020 Complete Agenda PaBel<et 3 AP Checks Fs Date/Amount Range .00 Tb Pmt: 99,999,999.99 Description Chemicals Legal Lab Analysis Lab Analysis Chemicals Lab Analysis Lab Analysis for PID TCDRS Service Charges & Fees Software & Sit Copier Lease Installments W r men's C arpensation Nbriman's Compensation Transfer to Tbwan/Fire Budget Town -Storm Drainage Refuse Refuse Tax Electricity/Cas Electricity Water 8 of 149 Line Iter C'hmok Check Value Nzrber Date 427.88 1,624.08 1,624.08 1,050.00 5,590.00 6,640.00 341.55 241.50 583.05 2,856.60 2,856.60 220.00 80.00 300.00 7,537.35 7,537.35 202.35 202.35 425.00 425.00 165.00 165.00 175.50 175.50 351.00 59,888.08 39,297.64 65,574.39 5,421.89 753.27 170,935.27 511.03 511.03 285.43 6268 03/12/20 6269 03/12/20 6269 03/12/20 6270 03/12/20 6270 03/12/20 6271 03/12/20 6272 03/12/20 6272 03/12/20 6273 03/12/20 6274 03/12/20 6275 03/12/20 6276 03/12/20 6277 03/12/20 6277 03/12/20 6278 03/12/20 6278 03/12/20 6278 03/12/20 6278 03/12/20 6278 03/12/20 6279 03/12/20 6280 03/12/20 apackarnt2 skrolczyk Begin Date: 03/01/2020 End Date: 03/31/2020 Vendor Vendor Name Number Totals fcxr Check: 6280 1058 VERDIAN WIRELESS 1058 VFRIUN Wilt 1058 VERIZM WAS Totals 5=Check: 6281 2651 Carmen Consulting LLC. 2651 Caiman Consulting LLC. Totals for Check: 6282 2683 Charter Camunricatios Totals for Check: 6283 2677 Digital Air Control, Inc Totals for Check: 6284 2635 Halff Associates, DC 2635 Halff Associates, INC 2635 Halff Associates, fl Totals for Check: 6285 Fran Amt: Invoice Nurber Invoice Inv Dept Account 9849447220 9849447220 9849447220 Date Stat Tb Natter 03/01/20 P 03/01/20 P 03/01/20 P 20 135-60010-020-000 30 135-60010-030-000 10 135-60010-010-000 31 03/04/20 P 30 135-55070-030-000 31 03/04/20 P 30 135-55070-030-000 0071672030620 03/06/20 P 30 135-55030-030-000 2052290 03/10/20 P 30 135-60235-030-000 10034896 10034890 10034893 03/12/20 P 03/12/20 P 03/12/20 P 1834 ID990 DISfl IB TI7'C94, INC 3061215416 03/05/20 P Totals for Check: 6286 2735 Jackson Walker LLP 1704289 03/12/20 P Totals for Check: 6287 3195 LOU'S MOUES INOTRPORAIED 033850 03/13/20 P Totals for Check: 6288 3216 M3 Netv'ks 5930 03/15/20 P Totals for Cherk: 6289 2739 the icipal Valve & Equipment Cb 22274 03/13/20 P Tbtals for Check: 6290 450131002001 03/02/20 P 1056 OFFICE DEPOT, INC Totals for Check: 6291 3156 OXIDCR LABCRtA70R3ES LLC 3156 OCSX)2 LABCRiAI LFSS LIC Totals for Check: 6292 1087 WE/TAKER CHALK SWINDLE Totals for Check: 6293 20030152 20030225 257766 03/10/20 P 03/11/20 P 02/29/20 P 30 135-69005-030-000 10 520-69005-010-000 20 135-69005-020-000 20 135-65045-020-000 10 520-69005-010-000 20 135-65045-020-000 30 135-55030-030-000 20 135-69005-020-000 30 135-65085-030-000 20 135-55135-020-000 20 135-55135-020-000 39 135-55045-039-000 Trophy club MOD No.1 AP Checks For Date/Amount Range .00 To Amt: 99,999,999.99 Descriptio Clznnmications/Mobiles C tmmicatios/Mobiles O mum icatioas/bk:biles Independent labor Independent Labor Softvare & Suppatt Security Capital Outlays Capital Outlays Capital Outlays Lab Supplies Capital Outlays Lab Supplies Software & Support Capital Outlays Office Supplies Lab Analysis Lab Analysis Legal 9 of 149 04/14/20 13414n120, 2020 Complete Agenda lizgL1<et 4 T,i,, Item Check Check Value Number Date 285.43 408.87 87.75 424.30 920.92 6281 03/12/20 6281 03/12/20 6281 03/12/20 1,700.00 6282 03/16/20 15.53 6282 03/16/20 1,715.53 899.00 6283 03/16/20 899.00 24.00 6284 03/16/20 24.00 2,867.91 624.09 1,389.11 4,881.11 6285 03/16/20 6285 03/16/20 6285 03/16/20 2,142.46 6286 03/16/20 13,289.86 6287 03/16/20 169.20 6288 03/16/20 494.00 6289 03/16/20 1,725.00 6290 03/16/20 55.91 6291 03/16/20 2,142.46 13,289.86 169.20 494.00 1,725.00 55.91 341.55 241.50 583.05 6292 03/16/20 6292 03/16/20 13,935.00 6293 03/16/20 13,935.00 apackant2 the olczyk Begin Date: 03/01/2020 End Date: 03/31/2020 Vendor Vendor Name Number 2222 AFLAC 2222 AFLAC Tbtals for deck: 6294 3197 BenefitMall 3197 BerfitMall 3197 BenefitMall Tbtals for Check: 6295 1030 CITY OF FORT WORTH Totals for Check: 6296 3193 CC14,PtJPAY, INC. Totals for Check: 6297 3080 cP&Y/4ALLALE GROUP, INC. Totals for Cheek: 6298 2740 Cues Inc Totals for Check: 6299 2720 Filter Elect Stare Totals for Check: 6300 1372 HACH COMPANY 1372 HACH COMPANY 1372 HACH COMPANY Totals for Check: 6301 2676 Humana Inc 2676 Humana Inc 2676 Hhaana Inc 2676 Humana Inc 2676 Humana Inc 2676 Humana Inc Totals for Cheek: 6302 2775 HODSON ENERGY SERVICES, LSC 2775 HUDSON ENERGY SERVICES, LSC Totals for Check: 6303 1834 IDEXX DISIRIBurICN, INC Ibt.le for Check: 6304 3124 IRS Tax Payment 3124 IRS Tax Payment 3124 IRS Tax Payment Frim Amt: Invoice Namber Invoice Inv Dept Account Date Stat Ab Number PR00691 996 03/06/20 P 9R00692 996 03/20/20 P 9047575 -IN 9047575 -IN 9047575 -IN 03/19/20 PR00692 1600916.05-7 03/01/20 SI -109115 03/16/20 P 03/16/20 P 03/16/20 P 03/19/20 P 996 03/20/20 P 03/09/20 P 03/23/20 P 03/01/20 P 11876566 03/11/20 P 11883490 03/17/20 P 11885570 03/18/20 P Trophy club MUD No.1 AP Checks For Date/Amount Range .00 Tb Amt: 99,999,999.99 Description 135-21312-000-000 Aflac 135-21312-000-000 Aflac 10 135-50029-010-000 20 135-50029-020-000 30 135-50029-030-000 10 135-60150-010-000 135-21313-000-000 20 517-69005-020-000 30 135-55030-030-000 20 135-55080-020-000 10 135-65030-010-000 10 135-65030-010-000 20 135-65045-020-000 155516878 04/01/20 P 155516878 04/01/20 P 155516878 04/01/20 P 155516878 04/01/20 P 10 155516878 04/01/20 P 20 155516878 04/01/20 P 30 S2003160002-35 03/16/20 P S2003160002-35 03/16/20 P 3061800055 03/17/20 P PR00692 996 03/20/20 P 9200692 996 03/20/20 P 9200692 996 03/20/20 P 135-21308-000-000 135-21309-000-000 135-21311-000-000 135-50029-010-000 135-50029-020-000 135-50029-030-000 Life Insurance & Other Life Insurance & Other Life Insurance & Other Wholesale Water Cafe 125 -Medical Reimb Capital Outlays Software & Support Maintenance & Repairs Chemicals Chemicals Lab Supplies Dental Vision Voluntary Life Life Insurance & Other Life Insurance & Other Life Insurance & Other 10 135-60020-010-000 Electricity 10 135-60020-010-000 Electricity 20 135-65045-020-000 Lab Supplies 135-21302-000-000 135-21303-000-000 135-21304-000-000 FW i Taxes Sn,ial Security Taxes Medicate Taxes 10 of 149 04/14/20 132Npril 20, 2020 Complete Agenda met 5 Line Item Cheek Cheek Value Number Date 210.67 6294 03/24/20 210.67 6294 03/24/20 421.34 22.00 6295 03/24/20 32.00 6295 03/24/20 16.00 6295 03/24/20 70.00 86,448.49 6296 03/24/20 86,448.49 549.37 6297 03/24/20 549.37 10,950.00 6298 03/24/20 10,950.00 1,250.00 6299 03/24/20 1,250.00 100.80 6300 03/24/20 100.80 748.77 6301 03/24/20 504.63 6301 03/24/20 552.67 6301 03/24/20 1,806.07 1,432.12 6302 03/24/20 196.71 6302 03/24/20 303.28 6302 03/24/20 168.50 6302 03/24/20 188.94 6302 03/24/20 167.88 6302 03/24/20 2,457.43 12,367.52 6303 03/24/20 6,540.65 6303 03/24/20 18,908.17 1,968.83 6304 03/24/20 1,968.83 4,598.72 6305 03/24/20 5,694.04 6305 03/24/20 1,331.64 6305 03/24/20 apackamt2 skrnlczyk Begin Date: 03/01/2020 End Late: 03/31/2020 Vendor Vendor Name Number Totals for Check: 6305 arm Amt: invoice Nufier Invoice Inv Dept Account 3167 KE SIONE PARR SECRETARIAL 159823 3167 KEYSTONE PARK SECRETARIAL 160403 Totals for Check: 6306 3278 KYOC RA DOCUMENT SOLUTIONS Totals for Check: 6307 3132 Legal Shield 3132 Legal. Shield Totals for Check: 6308 Date Stat No Number 02/20/20 P 03/18/20 P Trophy Club NOD No.1 AP Checks For Date/Amount Range .00 To Amt: 99,999,999.99 Description 30 135-60005-030-000 Telephone 30 135-60005-030-000 Telephone 55R1743807 03/23/20 P 30 135-69170-030-000 Copier Lease Installments PR00691 996 03/06/20 P PR00692 996 03/20/20 P 3186 MEMBER'S BUILDING MAINTENANCE 7C20021040D 3186 MEMBER'S BOIIDItvv MAINTENANCE TC2002TCSSID 3186 'S BOImD1I MAIIITEN ANCE TC2002TCMOD Totals for Check: 6309 3115 ME1LIFE GROUP BFIIERTrS 3115 MST IPE GROUP mums 3115 ME/LIFE GROUP BENEFITS 3115 ME1Tt9E CROUP BPI'S Totals for Check: 6310 4/15/2020 4/15/2020 4/15/2020 4/15/2020 3179 NE1 @1 STRATB3IES & SOLUTIONS 9096 Totals for Check: 6311 1056 OFFICE rear, INC Totals for Check: 6312 3156 OXIIX>f2 LABORATORIES LLC 3156 OXIDOR LABORATCXctI1:S LLC Totals for Check: 6313 3113 TCDR3 Totals for Check: 6314 998 AS TOR WOODS HOMES Totals for Check: 6315 998 ASHTON WOE FSS Totals for Check: 6316 998 BARXKLV, ANIt Totals for Check: 6317 998 CANIREtL, 02/29/20 P 02/29/20 P 02/29/20 P 04/01/20 04/01/20 04/01/20 04/01/20 135-21310-000-000 Legal Plan 135-21310-000-000 Legal Plan 20 135-55120-020-000 30 135-55120-030-000 10 135-55120-010-000 P 135-21315-000-000 P 10 135-50029-010-000 P 20 135-50029-020-000 P 30 135-50029-030-000 Cleaning Services Cleaning Services Cleaning Services Short Tern Disability Life Insurance & Other Life Insurance & Other Life Insurance & Other 03/17/20 P 30 135-55160-030-000 Professional Outside Services 456169326001 03/11/20 P 30 135-65085-030-000 Office Supplies 20030292 03/16/20 P 20 135-55135-020-000 Lab Analysis 20030379 03/19/20 P 20 135-55135-020-000 Lab Analysis PR00692 996 03/20/20 P 135-21317-000-000 =DRS U0017000507100A 03/31/20 P 135-20050-000-000 A/P Vendors U0036040653100A 03/31/20 P 135-20050-000-000 A/P Vexkus U0020490004203A 03/31/20 P 135-20050-000-000 A/P Vemxirs U0010080657106A 03/31/20 P 135-20050-000-000 A/P Vendors 11 of 149 04/14/20 13,4124-11 20, 2020 Complete Agenda P@E51cet 6 r.irw Iter Check check Value Number Date 11,624.40 194.75 6306 03/24/20 194.75 6306 03/24/20 389.50 109.86 6307 03/24/20 109.86 17.46 6308 03/24/20 17.44 6308 03/24/20 34.90 87.50 869.06 87.50 1,044.06 74.36 132.01 165.74 151.69 523.80 6309 03/24/20 6309 03/24/20 6309 03/24/20 6310 03/24/20 6310 03/24/20 6310 03/24/20 6310 03/24/20 2,500.00 6311 03/24/20 2,500.00 74.11 6312 03/24/20 74.11 341.55 6313 03/24/20 241.50 6313 03/24/20 583.05 7,955.44 6314 03/24/20 56.18 6315 03/31/20 20.10 6316 03/31/20 17.26 6317 03/31/20 30.10 6318 03/31/20 7,955.44 56.18 20.10 17.26 apackamt2 skrolczyk Trophy Club MUD No.l 04/14/20 13f*Til 20, 2020 Complete Agenda PEN9ket 7 AP Checks For Date/Amount Range Begin Date: 03/01/2020 End Date: 03/31/2020 Fran Amt: .00 To Ate: 99,999,999.99 Vendor Vector Name Number Totals for Check: 6318 Invoice Nudger Invoice Inv Dept Account Description 7.;rw Item Check Check Date Stat No Amber Value amber Date 30.10 998 CSR, BRYAN U9035130033901A 03/31/20 P 135-20050-000-000 A/P Vendors 16.16 6319 03/31/20 Totals far Check: 6319 16.16 998 CROMER, TAYII>I. 00020000968204A 03/31/20 P 135-20050-000-000 A/P Vendors 101.12 6320 03/31/20 Tpta1a for Check: 6320 101.12 998 D31IAVEN, MICHAEL U9023260016904A 03/31/20 P 135-20050-000-000 A/P Vendors 02.15 6321 03/31/20 Totals for Check: 6321 02.15 998 11EE19 CUSTOM HOMES 00017000015100A 03/31/20 P 135-20050-000-000 A/P Vendors 17.07 6322 03/31/20 Totals for Check: 6322 17.07 998 t8 EELS CUSTOM HOMES U0017000029100A 03/31/20 P 135-20050-000-000 A/P Vendors 59.53 6323 03/31/20 Totals for Checck: 6323 59.53 998 EGGE, DAVID U0020001042205A 03/31/20 P 135-20050-000-000 A/P Vey rs 54.03 6324 03/31/20 Totals for Check: 6324 54.03 998 GO DSTEIN, LOUIS U0015020009103A 03/31/20 P 135-20050-000-000 A/P Vendors 38.54 6325 03/31/20 Torah for Check: 6325 38.54 998 HARR EL, KEN U0042320009203A 03/31/20 P 135-20050-000-000 A/P Vendors 52.41 6326 03/31/20 Totals for Check: 6326 52.41 998 JMO OMD LLC U0010020114104A 03/31/20 P 135-20050-000-000 A/P Vendbms 18.78 6327 03/31/20 Totals for Check: 6327 18.78 998 LEONE, SALLEY RENEE U0010080619108A 03/31/20 P 135-20050-000-000 A/2 Ve dors 25.94 6328 03/31/20 Totals for Check: 6328 25.94 998 MAGNCTTT, MICHAEL & KATRI U0020650003201A 03/31/20 P 135-20050-000-000 A/P Vendors 118.49 6329 03/31/20 Totals for Check: 6329 118.49 998 PARMLEY, KRISSA U0010080673109A 03/31/20 P 135-20050-000-000 A/P Vendors 70.64 6330 03/31/20 Totals for Check: 6330 70.64 998 RAJA, MUHAM AD 00023120015202A 03/31/20 P 135-20050-000-000 A/P Vendors 09.89 6331 03/31/20 Totals for Check: 6331 09.89 998 =man HOMES, INC. 00010020101105A 03/31/20 P 135-20050-000-000 A/P Vend= 22.76 6332 03/31/20 Totals for Check: 6332 22.76 998 STARK, SCOTT 00020001061207A 03/31/20 P 135-20050-000-000 A/P Vendors 17.26 6333 03/31/20 Totals for Check: 6333 17.26 12 of 149 apackamt2 skrolczyk Begin Date: 03/01/2020 End Date: 03/31/2020 Vendor Vendor Name Idnber 998 SUTTON, CHARLES Totals for Check: 6334 998 TAN, C41AN Tbtals for Check: 6335 998 TAPPAN, DONNA Totals for Check: 6336 998 WILSON, acme 7btals for Check: 6337 Invoice Number Invoice Inv Date Stat U0010020112104A 03/31/20 P U0050101198104A 03/31/20 P 000206200082117. 03/31/20 P U0010050371106A 03/31/20 P 1737 DPC INDUSTRIES, INC 767001291-20 03/18/20 P 'Ibtals for Check: 6338 1372 BACH COMPANY 11887779 03/19/20 P 1372 HACH COMPANY 11881587 03/16/20 P 1372 HACH COMPANY 11888942 03/20/20 P Ibtals for Check: 6339 2943 JPMDEGAN CHASE BANK NA 03262020 03/26/20 P Totals for Check: 6340 1056 OFFICE DEPOT, INC 460552575001 03/17/20 P 1056 OFFICE DEPOT, INC 460554057001 03/17/20 P Totals for Check: 6341 3156 OXIDOR LABORATORIES LLC 20030482 03/25/20 P 3156 OXIDOR ZAB:PAMIR/ S LLC 20030434 03/23/20 P 'Ibtals for Check: 6342 3225 US Bank Voyager Fleet Systems 869338111013 03/24/20 P 3225 US Bank Voyager Fleet Systeme 869338111013 03/24/20 P Totals for Cheek: 6343 1249 HUTHER AND ASSOCIATES, INC 8335-A Zbtals for th k: 6344 Grand Totals: ****** End of Report ********* Fran Amt: Trophy Club MUD Nb.1 AP Q:ecks For Date/Amount Range .00 To Amt: 99,999,999.99 Dept Account Descriptio No Nurber 135-20050-000-000 A/P Vendors 135-20050-000-000 A/P Vendors 135-20050-000-000 A/P Vendors 135-20050-000-000 A/P Vendors 10 135-65030-010-000 Chemicals 20 135-65045-020-000 10 135-69005-010-000 10 135-65030-010-000 Lab Smplies Capital Outlays Chemicals 135-20060-000-000 Procurement Clearing 30 135-65085-030-000 Office Supplies 30 135-65085-030-000 Office Supplies 20 135-55135-020-000 20 135-55135-020-000 10 135-65005-010-000 20 135-65005-020-000 01/28/20 P 20 135-55135-020-000 Lab Analysis Lab Analysis Fuel & TAN. Fuel & Lube Lab Analysis 13 of 149 04/14/20 3.3Pionl 20, 2020 Complete Agenda Paxiiket 8 Lina Item Check Check Value Number Date 29.56 6334 03/31/20 29.56 20.92 6335 03/31/20 20.92 62.54 6336 03/31/20 62.54 102.76 6337 03/31/20 102.76 558.41 6338 03/31/20 558.41 257.28 6339 03/31/20 12,503.46 6339 03/31/20 475.53 6339 03/31/20 13,236.27 9,028.56 6340 03/31/20 9,028.56 26.34 6341 03/31/20 34.99 6341 03/31/20 61.33 241.50 6342 03/31/20 341.55 6342 03/31/20 583.05 906.24 6343 03/31/20 491.70 6343 03/31/20 1,397.94 1,080.00 6344 03/31/20 1,080.00 549,905.58 April 20, 2020 Complete Agenda Packet REGULAR MEETING MINUTES TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 BOARD OF DIRECTORS March 16, 2020 at 6:30 P.M. Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in a regular session on March 16, 2020 at 6:30 P.M., in the Boardroom of the Administration Building, 100 Municipal Drive, Trophy Club, Texas 76262. The meeting was held within the boundaries of the District and was open to the public. STATE OF TEXAS § COUNTIES OF DENTON AND TARRANT § BOARD MEMBERS PRESENT: Gregory Wilson President William C. Rose Vice President Steve Flynn Secretary/Treasurer Mark Chapman Director BOARD MEMBERS ABSENT: Kelly Castonguay Director STAFF PRESENT: Mike McMahon Laurie Slaght Steven Krolczyk Acting General Manager District Secretary Finance Manager GUESTS PRESENT: Chris Ekrut Michael Summerdorf NewGen Strategies & Solutions NewGen Strategies & Solutions CALL TO ORDER AND ANNOUNCE A QUORUM President Wilson announced the date of March 16, 2020, called the meeting to order and announced a quorum present at 6:30 p.m. CITIZEN COMMENTS Janet Lamont 15 Avalon Drive (received via email and read by President Wilson) CONSENT AGENDA 1. Consider and take appropriate action to approve the Consent Agenda. a. February 2020 Check Register b. February 17, 2020 Regular Meeting Minutes Director Rose pulled item b. February 17, 2020 Regular Meeting Minutes from the Consent Agenda for further discussion. Motion made by Director Flynn and seconded by Director Chapman to approve item A in the Consent Agenda. 14 of 149 April 20, 2020 Complete Agenda Packet Motion carried unanimously Director Rose pulled item b. for corrections that were sent out to the Board earlier in the day. The corrected minutes were presented at the dais. Motion by Director Rose and seconded by Director Flynn to approve the February 17, 2020 minutes as amended at the dais. Motion carried unanimously. REGULAR SESSION 2. Discussion and possible action regarding Winter Average Analysis completed by NewGen Strategies & Solutions. Chris Ekrut with NewGen Strategies & Solutions presented the winter average analysis and answered questions related thereto. Discussion Only, no action taken 3. Consider and take appropriate action regarding matters related to adoption of Order No. 2020-0316A (Rate Order) Establishing Policies, Procedures and Rates, Fees and Charges for Water and Sewer Services. a. Amending Section 2.02 relating to Sewer Service Rates and setting an effective date of April 1, 2020 for such revisions. b. Amending Section 3.05 District policies relating to the maintenance and repair of customer's sewer lines that pass under streets. (Rose/Chapman) Motion made by Director Rose and seconded by Director Flynn to adopt Order No. 2020-0316A Rate Order Establishing Policies, Procedures and Rates, Fees and Charges for Water and Sewer Services; and, amending Section 2.02 with Scenario No. 2 for both commercial and residential rates with an effective date of April 1, 2020. Motion carried unanimously No action was taken regarding Section 3.05. 4. Consider and take appropriate action to award Contract No. 2020031601 for Fence Replacement at the Wastewater Treatment Plant as part of FY2020 Capital Improvement Projects. Motion made by Director Chapman and seconded by Director Rose to award Contract No. 2020031601 to ReyMar Construction Company for an amount not to exceed $49,978.00.00 for Fence Replacement at the 15 of 149 April 20, 2020 Complete Agenda Packet Wastewater Treatment Plant as part of FY2020 Capital Improvement Projects. Motion carried unanimously 5. Consider and take appropriate action to authorize staff to issue a Request for Qualifications to qualified Engineering firms to secure Professional General Engineering Services on an as needed basis. Motion made by Director Rose and seconded by Director Flynn to authorize staff to issue a Request for Qualifications to qualified Engineering firms to secure Professional General Engineering Services on an as needed basis and bring proposals utilizing the document with one amendment to 3.2 qualifications, that the second the firms must be able to staff "this to these" projects with qualified individuals from inception to completion. Motion was withdrawn by the first and second Motion by Director Rose and seconded by Director Flynn to authorize staff to issue a Request for Qualifications to qualified Engineering firms to secure Professional General Engineering Services on an as needed basis and bring proposals utilizing the document provided in the packet. Motion carried unanimously 6. Discussion and possible action regarding COVID-19 and District operations. Motion Rose and seconded by Director Chapman that it is Board policy that we immediately suspend disconnecting customers for non-payment and that disconnect fees also be suspended until further notice. For Rose, Chapman Oppose Flynn, Wilson Motion Fails Motion by Director Wilson and seconded by director Flynn the district terminates all disconnects for nonpayment until the declaration of emergency declared by nation, state and county are rescinded and at that time the disconnect fees are reinstated For: Wilson, Flynn Opposed: Rose, Chapman Motion fails 7. Consider and take appropriate action regarding the February 2020 Combined Financials and Variance 16 of 149 April 20, 2020 Complete Agenda Packet Report. a. Combined Financials b. Combined Variance Motion made by Director Flynn and seconded by Director Rose to approve the February 2020 Combined Financials and Variance Reports. Motion carried unanimously REPORTS & UPDATES 8. Receive report from General Manager Hiring Committee. (Flynn) Director Flynn provided a status update of the search for the new General Manager. 9. General Manager Monthly Reports and Update: a. Regulatory Update b. Capital Improvement Projects • Wastewater Treatment Plant Upgrade Project • High Service Pump c. System Repairs & Maintenance d. Water System Operations e. Wastewater System Operations f. Finance Update • Utility Billing Report • Permits Collected • Cash Report Acting General Manager Mike McMahon presented the monthly reports to the Board and answered questions related thereto. The Board convened into Executive Session at 8:20 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). 17 of 149 April 20, 2020 Complete Agenda Packet c. Potential Condemnation of Easements required for construction and operation of Water Transmission Line Improvements from District Pump Station to Elevated Water Tank located on T.W. King Road 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, 1501 Junction Way and other real property owned by the District. b. Purchase of Easements required for construction and operation of Water Transmission Line Improvements from District Pump Station to Elevated Water Tank located on T.W. King Road The Board re -convened into Regular Session at 9:15 p.m. REGULAR SESSION 12. Consider and take appropriate action on matters deliberated in Executive Session: No action taken 13. Items for future agendas: Resolutions and Orders by inactive MUD's 14. Set future Meeting dates - Regular Board Meeting on April 20, 2020 at 6:30 p.m. ADJOURN President Wilson called the meeting adjourned at 9:17p.m. Gregory Wilson, President Steve Flynn, Secretary/Treasurer (SEAL) Laurie Slaght, District Secretary 18 of 149 April 20, 2020 Complete Agenda Packet SPECIAL ZOOM MEETING MINUTES TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 BOARD OF DIRECTORS April 2, 2020 at 5:30 P.M. Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in a Special Session Meeting on Thursday, April 2, 2020 at 5:30 P.M., in a Zoom video/telephone conference in accordance with the Governor's emergency proclamation suspending certain provisions of the Texas Open Meetings Act effective March 16, 2020 in response to the COVID-19 virus and was open to the public. STATE OF TEXAS COUNTIES OF DENTON AND TARRANT BOARD MEMBERS PRESENT: Gregory Wilson President William C. Rose Vice President Steve Flynn Secretary/Treasurer Kelly Castonguay Director Mark Chapman Director STAFF PRESENT: Mike McMahon Laurie Slaght Steven Krolczyk Acting General Manager District Secretary Finance Manager § § CALL TO ORDER AND ANNOUNCE A QUORUM President Wilson announced the date of April 2, 2020, called the meeting to order and announced a quorum present at 5:30 p.m. CITIZEN COMMENTS There were no Citizen Comments REGULAR SESSION 1. Consider and take appropriate action to Adopt Order No. 2020-0402A Postponing the May 2, 2020 Director Election until the next uniform date occurring on November 3, 2020. Motion made by Director Rose and seconded by Director Flynn to Adopt Order No. 2020-0402A Postponing the May 2, 2020 Director Election until the next uniform date occurring on November 3, 2020. Motion carried unanimously 2. Consider and take appropriate action to suspend the disconnection of utility services for non-payment. Motion made by Director Rose and seconded by Director Chapman to take the following actions in response to the growing COVID-19 threat, and the PUC's Project No. 50664 Order dated March 26, 2020: (1) ratify the 19 of 149 April 20, 2020 Complete Agenda Packet Acting General Manager's March 17, 2020 decision to suspend MUD disconnects for non-payment; (2) terminate the assessment of late fees on customers for delinquent bills; (3) terminate the application of interest on any deferred payment plans; and (4) direct that the preceding actions shall continue in force until such time as the Board of Directors directs otherwise. Motion is retracted by the first and second. New Motion Motion made by Director Rose and seconded by Director Chapman to take the following actions in response to the growing COVID-19 threat, and the PUC's Project No. 50664 Order dated March 26, 2020: (1) ratify the Acting General Manager's March 17, 2020 decision to suspend MUD disconnects for non- payment; (2) terminate the assessment of late fees on customers for delinquent bills; (3) terminate the application of interest on any deferred payment plans; and (4) direct that the preceding actions shall continue in force until such time as PUC terminates the applicable order. Motion carried unanimously ADJOURN Director Wilson adjourned the Meeting at 6:06 p.m. Gregory Wilson, President Steve Flynn, Secretary/Treasurer (SEAL) Laurie Slaght, District Secretary 20 of 149 April 20, 2020 Complete Agenda Packet SPECIAL ZOOM MEETING MINUTES TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 BOARD OF DIRECTORS April 6, 2020 at 3:45 P.M. Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in a Special Session Meeting on Monday, April 6, 2020 at 3:45 P.M., in a Zoom video/telephone conference in accordance with the Governor's emergency proclamation suspending certain provisions of the Texas Open Meetings Act effective March 16, 2020 in response to the COVID-19 virus and was open to the public. STATE OF TEXAS § COUNTIES OF DENTON AND TARRANT § BOARD MEMBERS PRESENT: Gregory Wilson President William C. Rose Vice President Steve Flynn Secretary/Treasurer Kelly Castonguay Director Mark Chapman Director STAFF PRESENT: Mike McMahon Laurie Slaght Steven Krolczyk Desiree Grubbs Acting General Manager District Secretary Finance Manager Financial Analyst CALL TO ORDER AND ANNOUNCE A QUORUM President Wilson announced the date of April 6, 2020, called the meeting to order and announced a quorum present at 3:50 p.m. CITIZEN COMMENTS There were no Citizen Comments The Board convened into Executive Session at 3:50 p.m. EXECUTIVE SESSION 1. Pursuant to Section 551.074 of the Texas Government Code (Texas Open Meetings Act), the Board of Directors may convene into Executive Session to deliberate the employment of a new General Manager. REGULAR SESSION The Board convened into Regular Session at 7:12 p.m. ADJOURN 21 of 149 April 20, 2020 Complete Agenda Packet Director Wilson called the meeting adjourned at 7:12 p.m. Gregory Wilson, President Steve Flynn, Secretary/Treasurer (SEAL) Laurie Slaght, District Secretary 22 of 149 April 20, 2020 Complete Agenda Packet SPECIAL ZOOM MEETING MINUTES TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 BOARD OF DIRECTORS April 8, 2020 at 3:45 P.M. Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in a Special Session Meeting on Wednesday, April 8, 2020 at 3:45 P.M., in a Zoom video/telephone conference in accordance with the Governor's emergency proclamation suspending certain provisions of the Texas Open Meetings Act effective March 16, 2020 in response to the COVID-19 virus and was open to the public. STATE OF TEXAS § COUNTIES OF DENTON AND TARRANT § BOARD MEMBERS PRESENT: Gregory Wilson President William C. Rose Vice President Steve Flynn Secretary/Treasurer Kelly Castonguay Director Mark Chapman Director joined the meeting at 4:00 p.m. STAFF PRESENT: Mike McMahon Laurie Slaght Steven Krolczyk Desiree Grubbs Acting General Manager District Secretary Finance Manager Financial Analyst CALL TO ORDER AND ANNOUNCE A QUORUM President Wilson announced the date of April 8, 2020, called the meeting to order and announced a quorum present at 3:50 p.m. CITIZEN COMMENTS There were no Citizen Comments The Board convened into Executive Session at 3:51 p.m. EXECUTIVE SESSION 1. Pursuant to Section 551.074 of the Texas Government Code (Texas Open Meetings Act), the Board of Directors may convene into Executive Session to deliberate the employment of a new General Manager. REGULAR SESSION The Board convened into Regular Session at 7:24 p.m. ADJOURN 23 of 149 April 20, 2020 Complete Agenda Packet Director Wilson called the meeting adjourned at 7:24 p.m. Gregory Wilson, President Steve Flynn, Secretary/Treasurer (SEAL) Laurie Slaght, District Secretary 24 of 149 Trophy Club Municipal Utility District No. 1 OUARTERLY INVESTMENT REPORT For Ending Period 03/31/2020 (January, February, and March) RsMcted/ Account or Unrestricted I CUSIP Sec Type Par 1 Rate / Coupon 1 Call 1 Purchase Matunty Date Pnce certify that 20, 20201Complctc Agcnd Packet B TCMUD's Investment Policy and the Public Funds Act. steve Flynn DATE Begining Book 1 Begining Market 1 Ending Book 1 Ending Market I Gain/Loss Yield % 1/1/2020 1/1/2020 3/31/2020 3/31/2020 End MV -End BV ecldng & Money Market Accounts Unrestricted- 135 XXX8701 Unrestricted- 122 XXX8701 Restricted- 533 XXX8701 Pools & Funds Unrestricted- 135 Restricted- 122 Restricted- 137 Restricted- 533 Restricted- 517 Restricted- 534 Restricted- 528 Restricted- 519 Restricted- 535 Restricted- 520 Restricted- 536 XXXXX0002 20000(0003 XXXXX00011 XXXXX00013 XXXXX00014 XXXXX00015 XXXXX00017 XXXXX00018 XXXXX00020 Savings Accounts Restricted XXXXX7724 Escrow/ Treasuries Restricted- 519 82-1747-01-1 Restricted- 520 82-3288-01-4 CD'S US Agencies EARNINGS SUMMARY 1 Restricted/ 1 Unrestricted NONE NONE Settle Date Prosperity Bank Consolidated Cash -General Fund Prosperity Bank Consolidated Cash -Fire Dept Prosperity Bank Consolidated Cash -Tax 1&S TexPool Municipal Fund -Operating TexPool Municipal Fund -Fire Dept TexPool Municipal Fund -GASB Replacemenent TexPool Tax Debt Service TexPool WW Construction Tax Texpool Revenue Bond 1&S Texpool Revenue Bond Reserve Texpool Revenue Bond Construction -SWIFT Texpool Revenue Bond 1&S -SWIFT Texpool Revenue Bond Construction Serres 2019 Texpool Revenue Bond 1&S Series 2019 Prosperity Bank Cash Reserve- Money Mkt Revenue Bond Series 2016 Escrow- BOK Revenue Bond Series 2019 Escrow- BOK Sec Type 2,787,572 0.000% 0 000 0 000 3,774,203 1,010,278 919,266 923,693 524,254 247,837 872,080 125,471 448,915 23,281 N/A N/A N/A 0.000% N/A 0 000% N/A 0.000% N/A 0.000% N/A 0.000% N/A 0 000% N/A 0.000% N/A 0.000% N/A 0 000% N/A 0.000% N/A 0.000% N/A $ 1,602,621 0000% N/A $ 784,703 $ 3,891,217 $ 17,935,390 Account Number Par N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A 100.000 0.500% $ 2,721,282 $ 2,721,282 $ 2,787,572 $ 2,787,572 100.000 0.500% $ 20,000 $ 20,000 $ - $ - 100.000 0.500% $ - $ - $ - $ - 100.000 1.580% $ 4,137,698 $ 4,137,698 $ 3,774,203 $ 3,774,203 100.000 1.580% $ 811,555 $ 811,555 $ 1,010,278 $ 1,010,278 100.000 1.580% $ 919,266 $ 919,266 $ 919,266 $ 919,266 100.000 1.580% $ 467,518 $ 467,518 $ 923,693 $ 923,693 100.000 1.580% $ 550,368 $ 550,368 $ 524,254 $ 524,254 100.000 1.580% $ 188,162 $ 188,162 $ 247,837 $ 247,837 100.000 1.580% $ 838,083 $ 838,083 $ 872,080 $ 872,080 100.000 1.580% $ - $ - $ - $ - 100.000 1.580% $ 80,257 $ 80,257 $ 125,471 $ 125,471 100.000 1.580% $ 556,551 $ 556,551 $ 448,915 $ 448,915 100.000 1.580% $ 89,354 $ 89,354 $ 23,281 $ 23,281 100.000 1.260% $ 1,399,384 $ 1,399,384 $ 1,602,621 $ 1,602,621 0.09% $ 782,771 $ 782,771 $ 784,703 $ 784,703 0.09% $ 3,881,637 $ 3,881,637 $ 3,891,217 $ 3,891,217 17,443,886 $ 17,443,886 $ 17,935,390 $ 17,935,390 S Coupon Maturity Ott Accrued Oh Amort. Total Ott Earnings 1 Unrestricted- 135 Unrestricted- 122 Restricted- 533 Unrestricted Restricted- 533 Restricted- 517 Restricted- 534 Restricted- 528 Restricted- 519 Restricted- 535 Restricted- 520 Restricted- 536 Restricted Restricted- 519 Restricted- 520 Checking & Money Market Accounts Pools & Funds Savings Accounts Escrows/ Treasuries CD'S NONE US Agencies NONE Prosperity Bank Consolidated Cash -General Fund XXX8701 $ 2,787,572 N/A N/A $ 3,512 N/A $ 3,512 Prosperity Bank Consolidated Cash -Fire Dept XXX870I $ - N/A N/A $ - N/A $ - Prosperity Bank Consolidated Cash -Tax I&S XXX8701 $ - N/A N/A $ - N/A $ TexPool Municipal Fund XXXXX0002 $ 5,703,746 N/A N/A $ 20,816 N/A $ 20,816 TexPool Tax Debt Service XXXXX0003 $ 923,693 N/A N/A $ 2,533 N/A $ 2,533 TexPool Construction Tax XXXXX00011 $ 524,254 N/A N/A $ 1,893 N/A $ 1,893 Texpool Revenue Bond I&S XXXXX00013 $ 247,837 N/A N/A $ 729 N/A $ 729 Texpool Revenue Bond Reserve XXXXX00014 $ 872,080 N/A N/A $ 2,947 N/A $ 2,947 Texpool Revenue Bond Construction -SWIFT XXXXX00015 $ - N/A N/A $ - NA $ - Texpool Revenue Bond I&S-SWIFT 20000(00017 $ 125,471 N/A N/A $ 333 NA $ 333 Texpool Revenue Bond Construction Series 2019 XXXXX00018 $ 448,915 N/A N/A $ 1,918 NA $ 1,918 Texpool Revenue Bond 1&S Series 2019 XXXXX00020 $ 23,281 N/A N/A $ 286 NA $ 286 Prosperity Bank Cash Reserve- Money Mkt XXX000724 $ 1,602,621 N/A N/A $ 3,237 N/A $ 3,237 Revenue Bond Series 2016 Escrow- BOK 82-1747-01-1 $ 784,703 N/A N/A $ 1,932 N/A $ 1,932 Revenue Bond Series 2019 Escrow- BOK 82-3288-01-4 $ 3,891,217 N/A N/A $ 9,580 N/A $ 9,580 PAR for this report is the statement balance on the last day of the quarter 25 of 149 $ 49,716 N/A $ 49,716 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 th ANNIVERSARY PERDUE BRANDON ATTORNEYS AT LAW Aril 20, 2020 Complete Agenda Parket April, 2020 to the Tronhv Club Mti,niiiriiI IJtiIitv � District No. 1 Submitted by: Alison Callison Perdue Brandon Fielder Collins & Mott. LLP 500 E. Border Street. Suite 640 Arlington. Texas 76010 811 461-3344 www.pbfcm.com Original 2018 Tax Year Levy $1,924,734 TROPHY CLUB MUNICIPAL UTILITY DISTRICT'N8.9°CompleteAgendaPacket 2018 Tax Year Analysis 98.86% Original Levy Collected $1,902,822 1.14% Adjusted Delinquent July 1, 2019 Turnover $21,912 Source: Denton County Tax Office, Year -To -Date Summary Reports. Perdue, Brandon, Fielder, Collins & Mott, L.L.P. 27 of 149 Adjusted Delinquent July 1,2019 Turnover $21,912 TROPHY CLUB MUNICIPAL UTILITY DISTRICT �p1i O 2fOCorripleteAgenda Packet Delinquent Tax Collections for the 2018 Tax Year 'Vv Collections from 7/1/2019 thru 3/31/2020 Remaining $4,310 80.33% Collected $17,603 Source: Denton County Tax Office, Year -To -Date Summary Reports. Collections and Turnover Account for Adjustments and Refunds. Base Taxes Only - No Penalties or Interest Added. Perdue, Brandon, Fielder, Collins & Mott, L.L.P. 28 of 149 In Trust, $920.60, 3.6% Action Pending, $2,778.22, 10.9% In Uncollectable, $567.00, 2.2% April 20, 2020 Complete Agenda Packet Trophy Club Municipal Utility District No. 1 Analysis of Delinquent Tax Roll - Status of Outstanding Accounts In Deferral, $17,410.95, 68.0% In Litigation, $3,922.85, 15.3% Action Pending Accounts: Payment Agreements, Notification Letters, Telephone Collections, Lienholder Notification, Address Research, Title Research, Property Inspection. As of April 7, 2020 there was $25,600 in base taxes due on 69 accounts. Source: Denton County Tax Office tape download. 29 of 149 April 20, 2020 Complete Agenda Packet It PERDUE BRANDON FIELDERCOLLINS&MOrr LLP ATTORNEYS AT LAW AUTHORITY ACTIVITY ANALYSIS TROPHY CLUB MUNICIPAL UTILITY DISTRICT #1 As Of 4/7/2020, Tax Years Between 1998 And 2018 Description # Properties Pct Of Total Base Tax Amount Pct Of Total In Trust In Deferral In Litigation In Uncollectable Action Pending Totals 5 8 8 17 34 72 6.94% 11.11% 11.11% 23.61% 47.22% 100.00% $920.60 $17,410.95 $3,922.85 $567.00 $2,778.22 $25,599.62 3.60% 68.01% 15.32% 2.21% 10.85% 100.00% Dollar Range # Properties Pct Of Total Base Tax Amount Pct Of Total $0.01 - $100.00 $100.01 - $250.00 $250.01 - $500.00 $500.01 - $1000.00 $1000.01 - $2500.00 $2500.01 - $5000.00 $5000.01 - $10,000.00 Totals 46 5 10 4 1 2 1 69 66.67% 7.25% 14.49% 5.80% 1.45% 2.90% 1.45% 100.00% $535.27 $1,040.28 $3,121.66 $3,139.15 $2,064.50 $7,711.56 $7,987.20 $25,599.62 2.097 4.06% 12.19% 12.26% 8.06% 30.12% 31.20% 100.00% Year # Transaction Pct Of Total Base Tax Amount Pct Of Total 1998 1 0.58% $68.76 0.27 1999 1 0.58% $58.94 0.23% 2000 1 0.58% $58.94 0.23% 2001 1 0.58% $58.94 0.23% 2002 1 0.58% $73.67 0.29% 2003 1 0.58% $110.02 0.43% 2004 1 0.58% $110.02 0.43% 2005 1 0.58% $110.02 0.43% 2006 3 1.75% $405.07 1.58% 2007 3 1.75% $607.69 2.37% 2008 4 2.34% $967.20 3.78% 2009 6 3.51% $981.60 3.83% 2010 13 7.60% $3,057.61 11.94% 2011 14 8.19% $2,477.69 9.68% 2012 10 5.85% $1,990.38 7.78% 2013 12 7.02% $2,153.75 8.41% 2014 17 9.94% $2,373.90 9.27% 2015 18 10.53% $2,049.45 8.01% 2016 15 8.77% $2,029.66 7.93% 2017 18 10.53% $1,507.19 5.89% 2018 30 17.54% $4,349.12 16.99% Totals 171 100.00% $25,599.62 100.00% **Number of properties may differ in the Just two sections because a property may reside in more than one category in the first section. 30 of 149 Deferral Detail Report Locator: Denton Tax Clients: Trophy Club MUD 1 TP # Taxpayer Name 799 BAKER BOB J GEO Code Client Name 209674DEN Trophy Club MUD 1 April 20, 2020 Complete Agenda Packet Base Due Tax Year Status Tran Type Start Date End Date Condition Base Tax 2010 DEFE TAX 07/08/2011 12/01/2099 pre $1,650.27 209674DEN Trophy Club MUD 1 2011 DEFE TAX 07/08/2011 12/01/2099 Defer $1,172.50 209674DEN Trophy Club MUD 1 2012 DEFE TAX 07/08/2011 12/01/2099 Defer $986.42 209674DEN Trophy Club MUD 1 2013 DEFE TAX 07/08/2011 12/01/2099 Defer $959.74 209674DEN Trophy Club MUD 1 2014 DEFE TAX 07/08/2011 12/01/2099 Defer $1,059.05 209674DEN Trophy Club MUD 1 2015 DEFE TAX 07/08/2011 12/01/2099 Defer $1,089.73 968 209674DEN Trophy Club MUD 1 2016 DEFE TAX 07/08/2011 12/01/2099 Defer $1,069.49 Property Base Due $7,987.20 Taxpayer Base Due $7,987.20 BOREN BENJAMIN C & BEVERLY C GEO Code Client Name 71012DEN Trophy Club MUD 1 Tax Year Status Tran Type Start Date End Date Condition 2010 DEFE TAX 06/30/2010 12/01/2099 Defer Base Tax $414.60 71012DEN Trophy Club MUD 1 2011 DEFE TAX 06/30/2010 12/01/2099 Defer $378.65 71012DEN Trophy Club MUD 1 2012 DEFE TAX 06/30/2010 12/01/2099 Defer $295.79 71012DEN Trophy Club MUD 1 2013 DEFE TAX 06/30/2010 12/01/2099 Defer $300.56 71012DEN Trophy Club MUD 1 2014 DEFE TAX 06/30/2010 12/01/2099 Defer $325.30 71012DEN Trophy Club MUD 1 2015 DEFE TAX 06/30/2010 12/01/2099 Defer $355.07 71012DEN Trophy Club MUD 1 2016 DEFE TAX 06/30/2010 12/01/2099 Defer $367.89 71012DEN Trophy Club MUD 1 2017 DEFE TAX 06/30/2010 12/01/2099 Defer $385.38 71012DEN Trophy Club MUD 1 2018 DEFE TAX 06/30/2010 12/01/2099 Defer $380.30 73 71012DEN Trophy Club MUD 1 2019 DEFE TAX 06/30/2010 12/01/2099 Defer Property Base Due Taxpayer Base Due $404.59 $3,608.13 $3,608.13 FORD DAVID L GEO Code Client Name Tax Year Status Tran Type Start Date End Date Condition Base Tax 70606DEN Trophy Club MUD 1 2018 QPAY TAX 02/03/2020 12/01/2099 pre $213.39 76 70606DEN Trophy Club MUD 1 2019 DEFE TAX 02/03/2020 12/01/2099 pre $406.15 Property Base Due $619.54 Taxpayer Base Due $619.54 MCDONALD JAMES E GEO Code Client Name Tax Year Status Tran Type Start Date End Date Condition Base Tax 72060DEN Trophy Club MUD 1 2006 DEFE TAX 01/25/2007 12/01/2099 pre $306.84 72060DEN Trophy Club MUD 1 72060DEN Trophy Club MUD 1 72060DEN Trophy Club MUD 1 72060DEN Trophy Club MUD 1 72060DEN Trophy Club MUD 1 72060DEN Trophy Club MUD 1 72060DEN Trophy Club MUD 1 2007 DEFE TAX 01/25/2007 12/01/2099 Defer $517.32 2008 DEFE TAX 01/25/2007 12/01/2099 Defer $530.21 2009 DEFE TAX 01/25/2007 12/01/2099 Defer 2010 DEFE TAX $495.08 01/25/2007 12/01/2099 Defer 2011 DEFE TAX $460.80 01/25/2007 12/01/2099 Defer 2012 DEFE TAX $405.50 01/25/2007 12/01/2099 Defer 2013 DEFE TAX $329.59 01/25/2007 12/01/2099 Defer 72060DEN Trophy Club MUD 1 2014 DEFE TAX $331.12 01/25/2007 12/01/2099 Defer 72060DEN Trophy Club MUD 1 2015 DEFE TAX $346.81 01/25/2007 12/01/2099 Defer $378.34 72060DEN Trophy Club MUD 1 2016 DEFE TAX 01/25/2007 12/01/2099 Defer $400.74 72060DEN Trophy Club MUD 1 2017 DEFE TAX 01/25/2007 12/01/2099 Defer $5.37 914 72060DEN Trophy Club MUD 1 2018 DEFE TAX 01/25/2007 12/01/2099 Defer Property Base Due Taxpayer Base Due $0.30 $4,508.02 $4,508.02 MORTON DENVER & JANIE GEO Code Client Name Tax Year Status Tran Type Start Date End Date Condition Base Tax 72277DEN Trophy Club MUD 1 2018 EMP TAX 03/24/2020 12/01/2099 pre $340.65 72277DEN Trophy Club MUD 1 2019 DEFE TAX 03/24/2020 12/01/2099 pre $404.44 Property Base Due $745.09 Taxpayer Base Due $745.09 91176 PARROW JAMES J & ELENA GEO Code Client Name 71779DEN Trophy Club MUD 1 Tax Year Status Tran Type Start Date End Date Condition 2017 DEFE TAX 11/03/2017 12/01/2099 Defer Base Tax $385.31 71779DEN Trophy Club MUD 1 2018 DEFE TAX 11/03/2017 12/01/2099 Defer $412.53 71779DEN Trophy Club MUD 1 2019 DEFE TAX 11/03/2017 12/01/2099 Defer Property Base Due Taxpayer Base Due 91396 RYAN BRUCE E & SHELIA A GEO Code Client Name 70173DEN Trophy Club MUD 1 Tax Year Status Tran Type Start Date End Date Condition 2018 DEFE TAX 10/23/2018 12/01/2099 Defer $416.50 $1,214.34 $1,214.34 Base Tax $329.43 1205 70173DEN Trophy Club MUD 1 2019 DEFE TAX 10/23/2018 12/01/2099 Defer $304.93 Property Base Due $634.36 Taxpayer Base Due $634.36 SHIRES BRENDA GEO Code Client Name 70643DEN Trophy Club MUD 1 Tax Year Status Tran Type Start Date End Date Condition 2014 DEFE TAX 02/03/2012 12/01/2099 Defer Base Tax $30.88 70643DEN Trophy Club MUD 1 2019 DEFE TAX 02/03/2012 12/01/2099 Defer $343.83 Property Base Due $374.71 Taxpayer Base Due $374.71 Total Base Due $19,691.39 TROPHY CLUB MUNICIPAL UTILITY DISTRICT #1 TROPHY CLUB MUNICIPAL UTILITY DISTRICT #1 pre 31 oN#9 $3,321.74 $16,369.65 4/7/2020 3:41:47 PM Page 1 of 1 Top Tax Top 100 Properties GEO Code 209674DEN Taxpayer # 799 72060DEN Taxpayer # 76 71012DEN Taxpayer # 968 11514221TAR Taxpayer # 59 189825DEN Taxpayer # 90337 71779DEN Taxpayer # 91176 173225DEN Taxpayer # 91232 40778495TAR Taxpayer # 91503 72277DEN Taxpayer # 914 526096DEN Taxpayer # April 20, 2020 Complete Agenda Packet Due Report - TROPHY CLUB MUNICIPAL UTILITY DISTRICT #1 Legal Description THE ESTATES OF HOGANS GLEN PH II BLK 1 LOT 6 895 650109DEN Taxpayer # 90829 70173DEN Taxpayer # 91396 70214DEN Taxpayer # 91400 4/8/2020 11:39:37 AM Taxpayer Name BAKER BOB J TROPHY CLUB # 6 LOT 499 Taxpayer Name MCDONALD JAMES E TROPHY CLUB #10 LOT 1219 Taxpayer Name Years 2010-2016 Years 2006-2018 Years BOREN BENJAMIN C & BEVERLY C 2010 DIEGO'S TEX MEX KITCHEN PERSONAL PROPERTY Taxpayer Name SUMMERS, JAMES M LAKESIDE AT TROPHY CLUB BLK C LOT 9 Taxpayer Name Years WISE JEFFREY L 2017-2018 TROPHY CLUB # 2 LOT 77 Taxpayer Name Years PARROW JAMES J & ELENA 2017-2018 A1045A W. H. PEA TR 9 .0793 ACRES Taxpayer Name Years DENTON COUNTY TRUSTEE 2000-2017 PEA, WM H SURVEY ABSTRACT 2025 TRACT 2G Taxpayer Name Years LAKE CITIES CHURCH OF CHRIST 2008-2018 TROPHY CLUB # 3 LOT 174 Taxpayer Name Years MORTON DENVER & JANIE 2018 CHURCHILL DOWNS BLK A LOT 1 Taxpayer Name Years Tax Due Total Due $7,987.20 $12,362.02 Tax Due Total Due $4,508.02 $7,233.73 Tax Due Total Due -2018 $3,203.54 $4,318.11 TANGIBLE COMMERCIAL Tax Due Total Due $2,064.50 $5,288.66 Tax Due Total Due $803.82 $1,283.54 Tax Due Total Due $797.84 $863.62 Tax Due Total Due $789.61 $2,478.66 Tax Due Total Due $620.18 $1,443.40 Tax Due Total Due $340.65 $515.06 Tax Due Total Due Years 2008-2014 SEAY MARK SR & TERRI 2018 $334.77 $510.19 PERSONAL PROPERTY - DENTIST LOCATION: 925 TROPHY CLUB DR TROPHY CLUB Taxpayer Name MEMBERS ONLY DENTAL PA TROPHY CLUB OAK HILL LOT 15 Taxpayer Name RYAN BRUCE E & SHELIA A TROPHY CLUB OAK HILL LOT 33 Taxpayer Name BUFORD MAURY A & DANA M 32 of 149 Years 2018 Years 2018 Years 2018 Tax Due $330.92 Tax Due $329.43 Tax Due $324.60 Total Due $504.32 Total Due $348.64 Total Due $494.69 Page 1 of 6 April 20, 2020 Complete Agenda Packet 620602DEN PERSONAL PROPERTY - DENTIST OFFICE LOCAITON : 301 TROPHY LAKE DR STE 120, TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 1560 BURGAR BRANDON 2013-2014 $310.41 $672.18 116514DEN TROPHY CLUB #12 LOT 1559 Taxpayer # Taxpayer Name Years Tax Due Total Due 1626 GARD JEFFERY L & MARGARET PONIG 2018 $304.82 $464.55 926478DEN PERSONAL PROPERTY - CHIROPRACTOR LOCATION : 100 TROPHY CLUB DR. STE 108 TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 1242 FORD LESLIE 2012-2017 $304.07 $589.55 563647DEN PERSONAL PROPERTY - HEALTH CLUB LOCATION: 501 TROPHY LAKE DR STE 326 TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 1712 HOLLIMAN VENTURES LLC 2018 $271.35 $413.54 339971DEN PERSONAL PROPERTY - AIRCRAFT CESSNA 150L 1972-N5428Q LOCATION : NORTHWEST REGIONAL AIRPORT L -52F Taxpayer # Taxpayer Name Years Tax Due Total Due 759 MORRISON AVIATION LLC 2010-2018 $270.64 $574.42 70731 DEN TROPHY CLUB #11 LOT 1469 Taxpayer # Taxpayer Name Years Tax Due Total Due 1033 WALES BRIDGET A 2018 $241.37 $350.47 72370DEN TROPHY CLUB # 2 LOT 141 Taxpayer # Taxpayer Name Years Tax Due Total Due 1750 LYNCH HELEN M 2018 $223.43 $324.42 70606DEN LAKE FOREST VILLAGE PH 3 LOT 84 Taxpayer # Taxpayer Name Years Tax Due Total Due 73 FORD DAVID L 2018 $213.39 $305.80 11514205TAR WEINBERGERS DELICATESSEN PERSONAL PROPERTY TANGIBLE COMMERCIAL Taxpayer # Taxpayer Name Years Tax Due Total Due 58 WEINBERGER DELI TWO LLC 2016-2018 $206.67 $333.75 296671DEN A1045A W. H. PEA, TRACT 9, ACRES 0.3717 (TARRANT CO PORTION)G27 Taxpayer # Taxpayer Name Years Tax Due Total Due 65 FIRST MADISON BANK FSB 2006-2007 $155.42 $474.09 469054DEN PERSONAL PROPERTY - RETAIL STORE LOCATION: 301 TROPHY LAKE DR STE 124, TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 1184 VERIZON 2011-2013 $82.41 $196.24 336817DEN PERSONAL PROPERTY - DRY CLEANERS DROP OFF LOCATION : 2003 SH 114 STE 390, TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 1164 WALJI SHANIF M 2014-2015 $45.93 $92.86 10374248TAR BUSINESS PERSONAL PROPERTY Taxpayer # Taxpayer Name Years Tax Due Total Due 57 J P TALBOT INSURANCE 2009-2011 $37.30 $100.00 4/8/2020 11:39:37 AM 33 of 149 Page 2 of 6 April 20, 2020 Complete Agenda Packet 70277DEN TROPHY CLUB #11 LOT 1358 Taxpayer # Taxpayer Name Years Tax Due Total Due 90894 MCDOWELL NANCY 2017 $36.54 $58.32 676477DEN PERSONAL PROPERTY - MEDICAL OFFICE LOCATION: 300 TROPHY CLUB RD STE 300 TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 91387 TRUE MEDICINE PA 2018 $36.39 $55.46 633172DEN PERSONAL PROPERTY - AUDIOLOGISTS LOCATION: 501 TROPHY LAKE DR, STE 318, TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 1730 EARCARE HEARING AIDS 2014-2015 $35.18 $71.13 676474DEN PERSONAL PROPERTY - DRY CLEANERS LOCATION: 2003 SH 114 STE 390 TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 90856 J.A.E.H.K. INC 2018 $32.97 $50.25 70643DEN LAKE FOREST VILLAGE PH 3 LOT 96 Taxpayer # Taxpayer Name Years Tax Due Total Due 1205 SHIRES BRENDA 2014 $30.88 $41.56 953826DEN PERSONAL PROPERTY - REALTY OFFICE LOCATION: 2001 SH114 # 150 TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 129 REMAX INTEGRITY 2009-2010 $28.61 $78.67 336821DEN PERSONAL PROPERTY - OFFICE LOCATION : 100 INDIAN CREEK DR STE 120, ROANOKE Taxpayer # Taxpayer Name Years Tax Due Total Due 741 MIJOL REALTY.COM 2010-2011 $20.36 $53.09 563646DEN PERSONAL PROPERTY - MISC PERSONAL SERVICE LOCATION: 2003 SH 114 STE 340 TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 1711 STYLES OF INDIA 2015-2016 $20.23 $38.00 499622DEN PERSONAL PROPERTY - HAIR SALON LOCATION: 2001 W SH 114, STE 150, TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 1530 DESIRE SALON & SPA 2013 $16.51 $37.05 656967DEN PERSONAL PROPERTY - SUNLESS TANNING SALON: 2003 SH 114 STE 400 TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 90837 THE BRONZE BAR 2017 $14.54 $24.25 953825DEN PERSONAL PROPERTY - SALON & SPA LOCATION: 2001 SH114 # 120 TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 887 TONY CAO SALON & SPA 2011 $13.48 $34.13 930792DEN PERSONAL PROPERTY - TITLE COMPANY LOCATION: 99 TROPHY CLUB DR, TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 103 FIDELITY NATIONAL TITLE 2010 $12.86 $34.41 13442112TAR HEART TEST LABORATORIES PERSONAL PROPERTY TANGIBLE COMMERCIAL Taxpayer # Taxpayer Name Years Tax Due Total Due 91068 HEART TEST LABORATORIES INC 2017-2018 $12.68 $20.25 4/8/2020 11:39:37 AM 34 of 149 Page 3 of 6 April 20, 2020 Complete Agenda Packet 11457732TAR BUSINESS PERSONAL PROPERTY THOMAS PART *RVN10/7/08 PRNL OFF. BIZ LOCA 9 PER PH CONV W/NACY @ Taxpayer # Taxpayer Name Years Tax Due Total Due 190 WHITTON CONSTRUCTION INC 2011 $11.56 $29.27 336819DEN PERSONAL PROPERTY - OFFICE LOCATION : 100 INDIAN CREEK DR, TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 740 CJ HOOD CO INC 2010 $10.73 $28.71 925240DEN PERSONAL PROPERTY - LEGAL SERVICE LOCATION : 100 INDIAN CREEK, TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 875 CHRISTLIEB LAW OFFICE 2010-2011 $5.37 $14.00 659388DEN PERSONAL PROPERTY - BUSINESS SERVICES LOCATION: 99 TROPHY CLUB DR TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 91141 CHIP MUNDY INC 2017 $4.85 $8.09 566115DEN PERSONAL PROPERTY - BUSINESS SERVICES LOCATION: 99 TROPHY CLUB DR, TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 1555 DONNA & ASSOCIATES 2013 $4.40 $9.87 701749DEN PERSONAL PROPERTY - OFFICE LOCATION: 99 TROPHY CLUB DR TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 91397 BEARDEN CORY 2018 $3.84 $5.85 659398DEN PERSONAL PROPERTY - BUSINESS SERVICES LOCATION: 99 TROPHY CLUB DR, TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 90372 RAY DERSTEIN 2015 $3.61 $7.06 12675504TAR D L PETERSON TRUST VARX COMMERCIAL Taxpayer # Taxpayer Name Years Tax Due Total Due 90423 D L PETERSON TRUST 2015 $2.88 $5.53 13730967TAR RANDSTAD RANDSTAD US LP PERSONAL PROPERTY TANGIBLE COMMERCIAL Taxpayer # Taxpayer Name Years Tax Due Total Due 90303 RANDSTAD US LP 2014-2015 $2.76 $5.47 116598DEN TROPHY CLUB #12 LOT 1613 Taxpayer # Taxpayer Name Years Tax Due Total Due 1628 TROPHY CLUB TOWN OF 2014 $1.20 $2.52 116600DEN TROPHY CLUB #12 LOT 1614 Taxpayer # Taxpayer Name Years Tax Due Total Due 1628 TROPHY CLUB TOWN OF 2014 $1.11 $2.33 14380710TAR ROYAL CUP INC VARX COMMERCIAL Taxpayer # Taxpayer Name Years Tax Due Total Due 90713 ROYAL CUP INC 2015-2018 $1.06 $1.72 335713DEN PERSONAL PROPERTY - OFFICE LOCATION: 99 TROPHY CLUB DR, TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 1329 HELM INSURANCE AGENCY 2012 $0.87 $2.08 14384456TAR AUTO -CHLOR SERVICES OF FORT WO VARX COMMERCIAL Taxpayer # Taxpayer Name Years Tax Due Total Due 90777 AUTO -CHLOR SERVICES LLC 2016-2018 $0.82 $1.25 4/8/2020 11:39:37 AM 35 of 149 Page 4 of 6 April 20, 2020 Complete Agenda Packet 14370986TAR FIRST DATA MERCHANT SVCS VARX COMMERCIAL Taxpayer # Taxpayer Name Years Tax Due Total Due 90293 FIRST DATA MERCHANT SVCS INC 2015-2018 $0.80 $1.30 14461451 TAR DELL MARKETING LP VARX COMMERCIAL Taxpayer # Taxpayer Name Years Tax Due Total Due 91207 DELL MARKETING LP 2016 $0.61 $1.01 624324DEN A0821A J.R. MICHAEL TR 1A(2) .09 ACRES Taxpayer # Taxpayer Name Years Tax Due Total Due 1628 TROPHY CLUB TOWN OF 2014 $0.52 $1.09 624325DEN A0821A J.R. MICHAEL TR 1A(3) .081 ACRES Taxpayer # Taxpayer Name Years Tax Due Total Due 1628 TROPHY CLUB TOWN OF 2014 $0.46 $0.97 42345560TAR WESTLAKE ENTRADA BLOCK I LOT 13 Taxpayer # Taxpayer Name Years Tax Due Total Due 91351 JJP TREVI LLC 2018 $0.19 $0.29 14360212TAR WAYPORT INC VARX COMMERCIAL Taxpayer # Taxpayer Name Years Tax Due Total Due 91212 WAYPORT INC 2018 $0.16 $0.23 14381350TAR SONIFI SOLUTIONS INC VARX COMMERCIAL Taxpayer # Taxpayer Name Years Tax Due Total Due 1290 SONIFI SOLUTIONS INC 2015 $0.15 $0.26 14358803TAR AMERIGAS PROPANE LP VARX COMMERCIAL Taxpayer # Taxpayer Name Years Tax Due Total Due 91045 AMERIGAS PROPANE LP 2015-2016, 2018 $0.14 $0.23 14479384TAR RS WATER HOLDING LLC VARX COMMERCIAL Taxpayer # Taxpayer Name Years Tax Due Total Due 354 RS WATER HOLDING LLC 2016 $0.09 $0.15 13661787TAR NATIONAL DEFAULT TITLE PERSONAL PROPERTY TANGIBLE COMMERCIAL Taxpayer # Taxpayer Name Years Tax Due Total Due 1638 NATIONAL DEFAULT TITLE SERVICE 2017 $0.07 $0.12 335711DEN PERSONAL PROPERTY - OFFICE LOCATION: 99 TROPHY CLUB DR, TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 1163 FULL CIRCLE LOGISTICS 2011 $0.07 $0.18 14448870TAR NEOPOST USA INC VARX COMMERCIAL Taxpayer # Taxpayer Name Years Tax Due Total Due 91049 NEOPOST USA INC 2015 $0.04 $0.07 42203285TAR GRANADA BLOCK A LOT 4 TROPHY CLUB MUD #1 Taxpayer # Taxpayer Name Years Tax Due Total Due 91223 SOLEIL DEVELOPMENT LLC 2018 $0.01 $0.02 203744DEN LAKES OF TROPHY CLUB PH 3 BLK 1 LOT 6 Taxpayer # Taxpayer Name Years Tax Due Total Due 91298 BRYANT CHRISTY LIVING TRUST 2018 $0.01 $0.02 72300DEN TROPHY CLUB # 6 LOT 552 Taxpayer # Taxpayer Name Years Tax Due Total Due 893 BULAND RUDY A 2017 $0.01 $0.02 4/8/2020 11:39:37 AM Page 5 of 6 36 of 149 April 20, 2020 Complete Agenda Packet 929539DEN PERSONAL PROPERTY - DRY CLEANERS LOCATION: 301 TROPHY LAKE DR #104 TROPHY CLUB Taxpayer # Taxpayer Name Years Tax Due Total Due 277 TROPHY CLUB CLEANERS 2018 $0.01 $0.02 Total Tax Due $25,471.92 4/8/2020 11:39:37 AM 37 of 149 Page 6 of 6 Aril 20, 2020 Com.lete A.enda Packet 17. SAMCO Capital Trophy Club Municipal Utility District No. 1 Bond Refunding Opportunity April 20, 2020 Andrew T. Friedman MANAGING DIRECTOR SAMCO Capital MEMBER: FINRA/SIPC www.samcocapital.com (210) 832-9760 (San Antonio) (214) 765-1439 (Dallas) afried man@samcocapital.com 38 of 149 TROPHY CLUB MUNICIPAL UTILITY DISTRICT Na. 1 Potential Refunding Results A ril 20, 2020 Com.lete A.enda Packet Series Name Summary of Bonds to be Refunded Par Refunded Refunded Coupon Range Maturities Refunded Call Date Unlimited Tax Bonds, Series 2010 Pro'ected Annual Savin _ s $ 1,220,000 4.00% - 5.00% Date Prior Debt Service [Refunding Present Value Debt Service Gross Savings Savings 09/30/2020 09/30/2021 09/30/2022 09/30/2023 09/30/2024 09/30/2025 09/30/2026 09/30/2027 09/30/2028 09/30/2029 09/30/2030 09/30/2031 Total $ 6,100 53,433 153,433 153,433 153,183 152,683 148,083 153,368 153,243 152,783 152,113 151,163 $ 1,583,013 $ 6,100 34,400 134,200 137,000 134,700 137,400 130,000 137,700 135,200 132,700 135,200 132,600 $ 1,387,200 $ 19,033 19,233 16,433 18,483 15,283 18,083 15,668 18,043 20,083 16,913 18,563 $ 195,813 $ (102) 18,706 18,530 15,527 17,091 13,858 16,047 13,630 15,366 16,748 13,820 14,853 $ 174,074 39 of 149 2022-2031 9/1/2020 Summary of Refunding Results Par Amount of Refunded Bonds Refunding Par Amount Average Coupon of Refunded Bonds True Interest Cost of Refunding Bonds Net Present Value Savings* $ 1,315,000 $ 1,315,000 4.27% 2.00% $ 119,074 Present Value Savings as a Percentage of Bonds Refunded 9.76% * 'Net Present Value Savings' reflects cash contribution by the District totaling $55,000 in order to meet statutorily required 'par -to - par requirement'. 17,1 SAMCO Capital Timetable of Events A ril 20, 2020 Com.lete A.enda Packet April 20th May 18th June 17th Timetable of Events SAMCO presents refunding opportunity to the Board and Board authorizes Staff and Consultants to proceed with Refunding so long as certain debt service savings targets are met Bids from potential purchasers due at noon Board reviews competitive bids received and awards the sale to the low bidder Bond Closing 40 of 149 SAMCO Capital 2020 AWBD Annual Conference When 6/11/2020 - 6/13/2020 April 20, 2020 Complete Agenda Packet Where Gaylord Texan (817) 778-1000 1501 Gaylord Trail Grapevine, TX 76051 United States AWBD REGISTRATION CANCELLATION POLICY: All Cancellations must be made in writing. A $50.00 administrative fee is assessed for each conference registration cancelled on or before April M, 2020 Mav 15, 2020. There will be no refunds after April a9, 2020 Mav 15, 2020. All registrations are non -transferable. 'mummy 2020 Quick overview of events: Thursday: AWBD Check-in 1:00 pm - 7:00 pm; Welcome Reception begins at 5:30 pm - 7:00 pm; DELEGATES ONLY FRIDAY AND SATURDAY Friday & Saturday: AWBD Check-in re -opens at 8:00 am Registrations received no later than the close of business March 18, 2020 will be charged at the rate of $375.00 for members and $750.00 for non-members. Registrations made after March 18, 2020 will be charged at the rate of $425.00 for members and $850.00 for non-members. Any registration accepted after April 20, 2020 May 15, 2020 will be charged $525.00 for members and $1050.00 for non-members per registration and do not guarantee the registrant seating at food functions nor receipt of conference materials or hospitality items. Cancellation Policy: All Cancellations must be made in writing. A $50.00 administrative fee is assessed for each conference registration cancelled on or before April 20, 232-0 May 15, 2020. There will be no refunds after April '19, 2328 May 15, 2020. All registrations are non -transferable. REGISTRATION OPTIONS ® Registration ® Vendor Registration for Booth Badge 41 of 149 PRICE 425.00 0.00 SCHEDULE OF EVENTS Welcome Reception 6/11/2020 5:30 PM Price 0.00 Time 5:30 PM - 7:00 PM April 20, 2020 Complete Agenda Packet Welcome Reception Guest 6/11/2020 5:30 PM Price 0.00 Time 5:30 PM - 7:00 PM Friday Continental Breakfast 6/12/2020 8:00 AM DELEGATES ONLY; Hit "ADD" to add to your registration Price 0.00 Time 8:00 AM - 8:45 AM Friday Luncheon 6/12/2020 12:30 PM DELEGATES ONLY; Hit "ADD" to add to your registration Price 0.00 Time 12:30 PM - 1:45 PM Saturday Continental Breakfast 6/13/2020 8:00 AM DELEGATES ONLY; Hit "ADD" to add to your registration Price 0.00 Time 8:00 AM - 8:45 AM Saturday Luncheon 6/13/2020 12:45 PM DELEGATES ONLY; Hit "ADD" to add to your registration Price 0.00 Time 12:45 PM - 2:00 PM 42 of 149 TROPHY CLUB MUD NO. 1 - FIRE DEPARTMENT BALANCE SHEET MARCH 2020 ASSETS CASH IN BANK INVESTMENTS PREPAID EXPENSES ADVALOREM PROPERTY TAXES RECEIVABLE EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE April 20, 2020 Complete Agenda Packet 57, TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 FIRE DEPT. 1,010,278 9,845 42,336 TOTAL ASSETS 1,062,460 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 42,343 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 42,343 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON -SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 603,769 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 416,349 TOTAL FUND BALANCE 1,020,118 TOTAL LIABILITIES AND FUND BALANCE 1,062,460 43 of 149 glbase_tbam skrolczyk 2:47 04/15/20 Fund: 122 Trophy Club MUD Fire Dept. Account Description 122-40010-000-000 122-40011-000-000 122-40020-000-000 Subtotal: April 20, 2020 Complete Agenda Packet Trophy Club MUD No.1 Budget Summary with Amendment Department: Fire Revenues Program: Period Ending: 3/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Property Taxes/MUD Fire 1,214,230.00- 1,214,230.00 - Property Taxes/Fire-Delinquent Property Taxes/Fire P51 Program number: Department number: Fire Revenues Revenues Subtotal 11,550.61- 408.73- 713.71- 1,208,468.49- 2,830.70- 3,546.01- 1,214,230.00- 1,214,230.00- 12,673.05- 1,214,845.20- 1,214,230.00- 1,214,230.00- 1,214,230.00- 1,214,230.00- MEMII 1,214,230.00- 1,214,230.00- 44 of 149 12,673.05- 1,214,845.20- 12,673.05- 1,214,845.20- 12,673.05- 1,214,845.20- 99.526 100.051 100.051 100.051 100.051 5,761.51- 2,830.70 3,546.01 615.20 615.20 615.20 glbase tbam skrolczyk Trophy Club MUD No.1 12:47 04/15/20 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Period Ending: 3/2020 Account Description Adopted Amended Total Current Budget Budget Encumb. Month 122-60030-045-000 122-60055-045-000 122-60337-045-000 11111Wtotal: 122-69005-045-000 Capital Outlays 48,000.00 48,000.00 122-69009-045-000 Short Term Debt -Interest 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 81,420.00 122-69305-045-000 Capital Leases 127,149.00 127,149.00 Rent And/Or Usage 218,004.00 218,004.00 Insurance 21,000.00 21,000.00 Transfer to Town/Fire Budget 718,657.00 718,657.00 957,661.00 957,661.00 (Subtotal: Program number: Department number: Expenditures Fire Subtotal Fund number: 122 Trophy Club MUD Fire Dept. 256,569.00 1,214,230.00 1,214,230.00 1,214,230.00 256,569.00 1,214,230.00 1,214,230.00 1,214,230.00 45 of 149 April 20, 2020 Complete Agenda Packet Program: YTD % of Remaining Total Budget Budget 218,004.00 100.000 1,640.88 9,845.28 46.882 11,154.72 59,888.08 359,328.48 50.000 359,328.52 61,528.96 2,750.00 5.729 11,958.24 81,420.00 100.000 115,190.36 90.595 211,318.60 61,528.96 798,496.36 61,528.96 61,528.96 48,855.91 798,496.36 798,496.36 416,348.84- 82 65.762 65.762 65.762 45,250.00 11,958.24- 11,958.64 45,2301.11 415,733.64 415,733.64 415,733.64 416,348.84 glpdatb2 skrolczyk 12:48 04/15/20 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Account: 122-40010-000- 1024 03/02/2020 Property Taxes 1025 03/03/2020 Property Taxes 1026 03/04/2020 Property Taxes 1027 03/05/2020 Property Taxes 1029 03/06/2020 Property Taxes 1031 03/10/2020 Property Taxes 1032 03/11/2020 Property Taxes 1033 03/12/2020 Property Taxes 1034 03/13/2020 Property Taxes 1035 03/16/2020 Property Taxes 1036 03/17/2020 Property Taxes 1037 03/18/2020 Property Taxes 1038 03/19/2020 Property Taxes 1039 03/20/2020 Property Taxes 1040 03/23/2020 Property Taxes 1041 03/24/2020 Property Taxes 1042 03/31/2020 Property Taxes Account: 122-40010-000-6 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Fire Revenues Program: Period Ending: 3/2020 JE Detail Beginning Transaction Transaction Vendor Name Description/Comment Balance Detail Detail (SUBTOTAL) Property Taxes/MUD Fire (1,196,917.88) Property Taxes/MUD Fire Totals: (1,214,230.00) Budgeted (5,761.51) Remaining 100 % Used (931.42) (1,197,849.30) (155.26) (1,198,004.56) (1,145.95) (1,199,150.51) (165.11) (1,199,315.62) (1,738.27) (1,201,053.89) (44.12) (1,201,098.01) (452.54) (1,201,550.55) (35.16) (1,201,585.71) (619.11) (1,202,204.82) (503.62) (1,202,708.44) (993.41) (1,203,701.85) (535.69) (1,204,237.54) (604.77) (1,204,842.31) (246.24) (1,205,088.55) (596.01) (1,205,684.56) (487.78) (1,206,172.34) (2,296.15) (1,208,468.49) (11,5.) (1,208,468.49) ** April 20, 2020 Complete Agenda Packet Check Source Number Property Taxes/Fire-Delinquent 1025 03/03/2020 Property Taxes 1030 03/09/2020 Property Taxes 1033 03/12/2020 Property Taxes 1041 03/24/2020 Property Taxes 1042 03/31/2020 Property Taxes Account: 122-40011-000- Property Taxes/Fire-Delinquent Totals: .00 Budgeted 2,830.70 Remaining Account: 122-40020-000-00' 1024 03/02/2020 Property Taxes 1025 03/03/2020 Property Taxes 1026 03/04/2020 Property Taxes 1027 03/05/2020 Property Taxes 1029 03/06/2020 Property Taxes 1030 03/09/2020 Property Taxes 1032 03/11/2020 Property Taxes 1033 03/12/2020 Property Taxes (2,421.97) (162.95) (2,584.92) (14.36) (2,599.28) (208.79) (2,808.07) (.02) (2,808.09) (22.61) (2,830.70) 0 % Used GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL T GL GL GL GL GL Property Taxes/Fire P41 (2,832.30) 46 of 149 (59.60) (2,891.90) (51.62) (2,943.52) (82.19) (3,025.71) (11.55) (3,037.26) (121.66) (3,158.92) (3.73) (3,162.65) (40.73) (3,203.38) (61.51) (3,264.89) GL GL GL GL GL GL GL GL glpdatb2 skrolczyk 12:48 04/15/20 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description 1034 03/13/2020 Property Taxes 1035 03/16/2020 Property Taxes 1036 03/17/2020 Property Taxes 1040 03/23/2020 Property Taxes 1041 03/24/2020 Property Taxes 1042 03/31/2020 Property Taxes Account: 122-40020-000-000 Department Totals: April 20, 2020 Complete Agenda Packet Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Fire Revenues Program: Period Ending: 3/2020 JE Detail Beginning Transaction Transaction Vendor Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) Property Taxes/Fire P0 .00 Budgeted (12,673.05) Monthly Total (2,832.30) 3,546.01 Remaining 0 % Used (61.31) (3,326.20) (32.11) (3,358.31) (52.92) (3,411.23) (36.11) (3,447.34) (29.39) (3,476.73) (69.28) (3,546.01) (1,214,845.20) ** (1,214,230.00) Budgeted 615.20 Remaining 100 % Used 47 of 149 GL GL GL GL GL GL April 20, 2020 Complete Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60030-045-000 Rent And/Or Usage 218,004.00 .00 218,004.00 Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 218,004.00 ** 218,004.00 Budgeted .00 Remaining 100 5 Used Account: 122-60055-045-000 Insurance 71 03/01/2020 Insurance/Wrk Comp Expense Mar 8,204.40 1,640.88 9,845.28 GL Account: 122-60055-045-000 Insurance Totals: 1,640.88 9,845.28 ** 21,000.00 Budgeted 11,154.72 Remaining 47 5 Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 891 03/05/2020 March A/P Fire admin march 299,440.40 59,888.08 359,328.48 TOWN OF TROPHY CLUB 6278 AP Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 59,888.08 359,328.48 ** 718,657.00 Budgeted 359,328.52 Remaining 50 % Used Account: 122-69005-045-000 Capital Outlays 2,750.00 .00 2,750.00 Account: 122-69005-045-000 Capital Outlays Totals: .00 2,750.00 ** 48,000.00 Budgeted 45,250.00 Remaining 6 % Used Account: 122-69009-045-000 Short Term Debt -Interest 11,958.24 .00 11,958.24 Account: 122-69009-045-000 Short Term Debt -Interest Totals: .00 11,958.24 ** .00 Budgeted (11,958.24) Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 .00 81,420.00 Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 81,420.00 ** 81,420.00 Budgeted .00 Remaining 100 % Used Account: 122-69305-045-000 Capital Leases 48 of 149 April 20, 2020 Complete Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 115,190.36 .00 115,190.36 Account: 122-69305-045-000 Capital Leases Totals: .00 115,190.36 ** 127,149.00 Budgeted 11,958.64 Remaining 91 % Used Department 45 Totals: 798,496.36 ++ 61,528.96 Monthly Total 1,214,230.00 Budgeted 415,733.64 Remaining 66 % Used Fund 122 Totals: (416,348.84) 48,855.91 Monthly Total .00 Budgeted 49 of 149 416,348.84 Remaining 0 % Used TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET MARCH 2020 April 20, 2020 Complete Agenda Packet SI TROPHY CLI MUNICIPAL UTILITY DISTRICT No.1 135 137 GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 2,787,572 2,787,572 CASH IN BANK -SAVINGS -CASH RESERVE 1,602,621 1,602,621 INVESTMENTS-TEXPOOL 3,774,203 919,266 4,693,469 PREPAID EXPENSES 57,407 57,407 ADVALOREM PROPERTY TAXES RECEIVABLE 4,636 4,636 UTILITY AND OTHER ACCOUNTS RECEIVABLE 794,494 794,494 TOTAL ASSETS 9,021,533 919,266 9,940,799 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 4,636 4,636 ACCOUNTS AND OTHER PAYABLES 354,869 354,869 CUSTOMER DEPOSITS 316,540 316,540 TOTAL LIABILITIES 676,045 676,045 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 (55,896) (55,896) TOTAL FUND BALANCE 8,345,488 919,266 9,264,754 TOTAL LIABILITIES AND FUND BALANCE 9,021,533 919,266 9,940,799 50 of 149 April 20, 2020 Complete Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 12:47 04/15/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 135-40002-000-000 135-40015-000-000 135-40025-000-000 Subtotal: Property Taxes Property Taxes/Delinquent Property Taxes/P & I PID Surcharges 134,871.00- 300.00- 300.00- 164,253.00- 134,871.00- 300.00- 300.00- 164,253.00- 1,282.27- 46.51- 79.53- 134,154.72- 292.80- 384.98- 99.469 97.600 128.327 716.28- 7.20- 84.98 164,253.00- 299,724.00- 299,724.00- 1,408.31- 134,832.50- 44.986 J. 164,891.50- 135-47000-000-000 Water 6,486,623.00- 6,486,623.00- 296,299.54- 2,101,814.57- 32.402 4,384,808.43- 135-47005-000-000 Sewer 3,503,885.00- 3,503,885.00- 250,710.40- 1,501,759.99- 42.860 2,002,125.01- 135-47025-000-000 Penalties 112,608.00- 112,608.00- 6,221.03- 52,117.51- 46.282 60,490.49- 135-47030-000-000 Service Charges 15,150.00- 15,150.00- 1,000.00- 9,800.00- 64.686 5,350.00- 135-47035-000-000 Plumbing Inspections 750.00- 750.00- 2,250.00- 300.000 1,500.00 135-47045-000-000 Sewer Inspections 2,500.00- 2,500.00- 1,350.00- 54.000 1,150.00- 135-47070-000-000 TCCC Effluent Charges 50,000.00- 50,000.00- 15,068.00- 30.136 34,932.00 - Subtotal: 10,171,516.00- 10,171,516.00- 554,230.97- 3,684,160.07- 36.220 6,487,355.93- 135-49011-000-000 135-49016-000-000 135-49018-000-000 135-49026-000-000 135-49075-000-000 135-49900-000-000 Interest Income Cell Tower Revenue Building Rent Income Proceeds from Sale of Assets Oversize Meter Reimbursement Miscellaneous Income 120,000.00- 120,000.00- 14,146.00- 14,146.00- 7,000.00- 7,000.00- 13,000.00- 13,000.00- 12,691.00- 12,691.00- 7,000.00- 7,000.00- 7,296.68- 583.33- 254.44- 59,107.74- 5,894.05- 3,499.98- 49.256 41.666 50.000 7,730.28- 60.912 8,596.20- 122.803 60,892.26- 8,251.95- 3,500.02- 13,000.00- 4,960.72- 1,596.20 0,892.26-8,251.95-3,500.02-13,000.00- 4,960.72- 1,596.20 Subtotal: 173,837.00- 173,837.00- 8,134.45- 84,828.25- 48.798 89,008.75 - mm Program number: 10,645,077.00- 10,645,077.00- 563,773.73- 3,903,820.82- 36.673 6,741,256.18 - Department number: Revenues 10,645,077.00- 10,645,077.00- 563,773.73- 3,903,820.82- 36.673 6,741,256.18 - Revenues Subtotal 10,645,077.00- 10,645,077.00- 563,773.73- 3,903,820.82- 36.673 6,741,256.18- 51 of 149 April 20, 2020 Complete Agenda Packet glbase_tbam skrolczyk Trophy Club MUD No.1 12:47 04/15/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 350,267.00 350,267.00 135-50010-010-000 Overtime 17,000.00 17,000.00 135-50016-010-000 Longevity 3,920.00 3,920.00 135-50017-010-000 Certification 5,400.00 5,400.00 135-50020-010-000 Retirement 34,863.00 34,863.00 135-50026-010-000 Medical Insurance 84,326.00 84,326.00 135-50027-010-000 Dental Insurance 4,725.00 4,725.00 135-50028-010-000 Vision Insurance 767.00 767.00 135-50029-010-000 Life Insurance & Other 3,132.00 3,132.00 135-50030-010-000 Social Security Taxes 23,348.00 23,348.00 135-50035-010-000 Medicare Taxes 5,461.00 5,461.00 135-50040-010-000 Unemployment Taxes 1,080.00 1,080.00 135-50045-010-000 Workman's Compensation 11,850.00 11,850.00 135-50060-010-000 Pre-emp Physicals/Testing 400.00 400.00 135-50070-010-000 Employee Relations 300.00 300.00 30,099.11 162,362.11 1,475.58 10,337.34 5,082.50 425.00 2,500.00 2,963.16 17,765.74 5,225.04 29,603.66 316.63 1,798.11 48.18 284.29 352.89 1,905.55 1,957.27 11,047.48 457.75 2,583.66 817.03 880.68 946.99 4,804.44 46.354 60.808 129.656 46.296 50.959 35.106 38.055 37.065 60.841 47.317 47.311 81.544 40.544 FSubtotal: ' 546,839.00 546,839.00 45,084.63 250,955.56 135-55005-010-000 Engineering 20,000.00 20,000.00 135-55080-010-000 Maintenance & Repairs 100,000.00 100,000.00 439.19 23,715.69 23.716 135-55085-010-000 Generator Maint. and Repair 3,000.00 3,000.00 135-55090-010-000 Vehicle Maintenance 5,000.00 5,000.00 1,114.89 1,842.56 36.851 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 907.82 1,828.19 52.234 135-55120-010-000 Cleaning Services 1,000.00 1,000.00 87.50 437.50 43.750 135-55135-010-000 Lab Analysis 7,500.00 7,500.00 433.94 2,031.64 27.089 187,904.89 6,662.66 1,162.50- 2,900.00 17,097.26 54,722.34 2,926.89 482.71 1,226.45 12,300.52 2,877.34 199.32 7,045.56 400.00 300.00 295,883.44 20,000.00 76,284.31 3,000.00 3,157.44 1,671.81 562.50 5,468.36 140,000.00 140,000.00 2,983.34 29,855. 110,144.42 135-60010-010-000 Communications/Mobiles 5,000.00 5,000.00 135-60020-010-000 Electricity 125,677.00 125,677.00 135-60066-010-000 Publications/Books/Subscripts 1,000.00 1,000.00 135-60070-010-000 Dues & Memberships 500.00 500.00 135-60080-010-000 Schools & Training 7,426.00 7,426.00 135-60090-010-000 Safety Program 400.00 400.00 135-60100-010-000 Travel & per diem 2,845.00 2,845.00 135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 135-60135-010-000 TCEQ Fees & Permits 63,000.00 63,000.00 135-60150-010-000 Wholesale Water 2,714,710.00 2,714,710.00 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 135-60280-010-000 Property Maintenance 3,000.00 3,000.00 135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 135-60332-010-000 Interfund Transfer Out -Rev I&S 527,381.00 527,381.00 135-60333-010-000 Interfund Transfer Out -Reserve 55,193.00 55,193.00 135-60334-010-000 Interfund Transfer Out 180,000.00 180,000.00 52 of 149 424.30 2,897.25 18,908.17 65,059.77 240.00 1,436.00 16,942.84 86,448.49 658,469.22 756.00 750.00 750.00 25,047.72 333,454.48 4,600.00 27,600.00 57.945 51.767 19.337 26.893 24.256 25.200 5.085 63.228 50.006 2,102.75 60,617.23 1,000.00 500.00 5,990.00 400.00 2,845.00 1,500.00 46,057.16 2,056,240.78 200.00 2,244.00 14,000.00 193,926.52 27,593.00 180,000.00 136,418.68 glbase_tbam skrolczyk 12:47 04/15/20 Department: 10 Water Account 1 1 135-60360-010-000 1 Description Furniture/Equipment < $5000 April 20, 2020 Complete Agenda Packet Trophy Club MUD No.1 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Program: Period Ending: 3/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 2,500.00 2,500.00 561.72 22.469 1,938.28 135-65005-010-000 135-65010-010-000 135-65030-010-000 135-65035-010-000 135-65040-010-000 135-65050-010-000 135-65053-010-000 135-69005-010-000 135-69008-010-000 135-69009-010-000 135-69195-010-000 135-69281-010-000 Fuel & Lube Uniforms Chemicals Small Tools Safety Equipment Meter Expense Meter Change Out Program Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Water Tank Inspection Contract 15,000.00 15,000.00 5,190.00 5,190.00 20,000.00 20,000.00 1,200.00 1,200.00 1,000.00 1,000.00 70,000.00 70,000.00 87,000.00 87,000.00 684,875.00 684,875.00 30,512.00 30,512.00 3,231.00 3,231.00 75,000.00 75,000.00 120,000.00 120,000.00 3,618.00 5,504,929.00 5, 53 of 149 906.24 2,287.34 12,503.46 5,421.15 2,917.33 11,303.84 16,869.78 36,900.00 189,213.49 30,512.00 1,840.00 75,000.00 102,077.11 36.141 9,578.85 56.211 2,272.67 56.519 8,696.16 1,200.00 1,000.00 24.100 53,130.22 42.414 50,100.00 27.627 100.000 56.948 100.000 85.064 7 495,661.51 1,391.00 17,922.89 April 20, 2020 Complete Agenda Packet glbase_tbam skrolczyk Trophy Club MUD No.1 Page 6 12:47 04/15/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 3/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis for PID 2,000.00 2,000.00 Subtotal: 2,000.00 2,000.00 Program number: 1 Lab Analysis for PU1111111111 2,000.00 2,000.00 Department number: Water 5,506,929.00 5,506,929.00 54 of 149 293.94 293.94 293.94 200,477.63 841.64 841.64 841.64 1,861,634.76 42.082 42.082 42.082 33.805 1,158.36 1,158.36 1,158.36 3,645,294.2 April 20, 2020 Complete Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 12:47 04/15/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 441,799.00 441,799.00 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 FSubtotal: 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 & Repairs Collections 10,000.00 10,000.00 135-55085-020-000 Generator Meant. and Repair 10,000.00 10,000.00 135-55090-020-000 Vehicle Maintenance 4,000.00 4,000.00 135-55091-020-000 Veh Maintenance Collections 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 31,844.60 182,682.53 41.350 259,116.47 1,577.13 11,342.43 34.371 21,657.57 6,872.50 85.532 1,162.50 625.00 3,825.00 42.500 5,175.00 3,152.73 20,485.72 44.993 25,045.28 7,738.24 41,528.31 39.604 63,329.69 446.90 2,432.32 41.814 3,384.68 69.74 390.17 41.157 557.83 428.07 2,214.50 49.211 2,285.50 1,955.07 11,870.39 38.927 18,623.61 457.23 2,776.13 38.925 4,355.87 936.10 995.22 78.986 264.78 1,285.70 6,836.70 44.472 8,536.30 38.00 9.500 362.00 300.00 6.51 294,289.92 111111i540 414,157.08 30,000.00 3,000.00 20.000 12,000.00 6,136.74 41,580.62 47.251 46,419.38 45.88 17,723.66 177.237 7,723.66- 10,000.00 51.00 793.98 19.850 3,206.02 24.94 2,011.88 25.149 5,988.12 272.55 832.22 27.741 2,167.78 87.50 437.50 29.167 1,062.50 4,803.76 43,283.38 43.283 56,716.62 3,995.25 19,043.90 47.610 20,956.10 417.62 135-60010-020-000 Communications/Mobiles 5,000.00 5,000.00 135-60020-020-000 Electricity 160,067.00 160,067.00 135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 135-60070-020-000 Dues & Memberships 300.00 300.00 135-60080-020-000 Schools & Training 4,990.00 4,990.00 135-60090-020-000 Safety Program 1,000.00 1,000.00 135-60100-020-000 Travel & per diem 1,545.00 1,545.00 135-60105-020-000 Rent/Lease Equipment 5,000.00 5,000.00 135-60125-020-000 Advertising 2,500.00 2,500.00 135-60135-020-000 TCEQ Fees & Permits 15,000.00 15,000.00 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 135-60280-020-000 Property Maintenance 5,000.00 5,000.00 55 of 149 408.87 3,088.27 61.765 1,911.73 447.24 61,290.51 38.291 98,776.49 200.00 105.00 216.00 72.000 84.00 531.00 2,962.85 59.376 2,027.15 109.14 10.914 890.86 49.88 410.72 26.584 1,134.28 5,000.00 2,500.00 10,088.02 67.253 4,911.98 450.00 584.94 11.699 4,415.06 April 20, 2020 Complete Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 12:47 04/15/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60285-020-000 135-60331-020-000 135-60332-020-000 135-60333-020-000 135-60334-020-000 135-60360-020-000 Lawn Equipment & Maintenance Interfund Transfer Out -Tax I&S Interfund Transfer Out -Rev I&S Interfund Transfer Out -Reserve Interfund Transfer Out Furniture/Equipment < $5000 14,000.00 114,563.00 673,867.00 125,187.00 180,000.00 2,000.00 14,000.00 114,563.00 673,867.00 125,187.00 180,000.00 2,000.00 Subtotal: 1,310,669.00 r 135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 135-65010-020-000 Uniforms 5,495.00 5,495.00 135-65030-020-000 Chemicals 20,000.00 20,000.00 135-65031-020-000 Chemicals Collections 17,500.00 17,500.00 135-65035-020-000 Small Tools 1,200.00 1,200.00 135-65040-020-000 Safety Equipment 1,200.00 1,200.00 135-65045-020-000 Lab Supplies 20,000.00 20,000.00 135-69005-020-000 135-69008-020-000 135-69009-020-000 135-69195-020-000 Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Subt . Program number: Department number: Wastewater 530,500.00 79,133.00 11,277.00 130,000.00 530,500.00 79,133.00 11,277.00 130,000.00 750,910.00 3,157,421.00 3,157,421.00 56 of 149 590.00 590.00 4.214 13,410.00 10,414.81 62,488.86 54.545 52,074.14 54,421.63 381,241.74 56.575 292,625.26 5,750.00 34,500.00 27.559 90,687.00 180,000.00 190.00 9.500 1,810.00 557,761.05 42.555 752,907.95 491.70 4,246.70 33.974 8,253.30 3,507.93 63.839 1,987.07 2,204.08 14,928.95 74.645 5,071.05 4,994.00 28.537 12,506.00 1,200.00 54.90 1,166.53 97.211 33.47 5,432.82 16,270.18 81.351 3,729.82 12,510.11 172,538.00 59,604.74 6,122.03 130,000.00 12,510.11 368,264.77 159,346.17 1,394,137.17 159,346.17 1,394,137.E 32.524 357,962.00 75.322 19,528.26 54.288 5,154.97 100.000 382,645.23 1,763,283.83 1,763,283.13 glbase_tbam skrolczyk 12:47 04/15/20 Fund: 135 MUD 1 General Fund Account 135-50045-026-000 Description Workman's Compensation Trophy Club MUD No.1 Budget Summary with Amendment Department: 26 Board of Directors Period Ending: 3/2020 Adopted Amended Total Current Budget Budget Encumb. Month 30.00 30.00 1.99 Program: YTD Total 11.94 April 20, 2020 Complete Agenda Packet % of Remaining Budget Budget 39.800 18.06 Subtotal: 30.00 30.00 1.99 11.94 39.800 18.06 135-60066-026-000 135-60070-026-000 135-60075-026-000 135-60080-026-000 135-60100-026-000 135-60245-026-000 Publications/Books/Subscripts Dues & Memberships Meetings Schools & Training Travel & per diem Miscellaneous Expenses 150.00 750.00 1,300.00 4,000.00 5,000.00 2,000.00 150.00 750.00 1,300.00 4,000.00 5,000.00 2,000.00 675.00 176.28 90.000 13.560 150.00 75.00 1,123.72 4,000.00 5,000.00 2,000.00 Subtotal: 13,200.00 13,200.00 851.28 6.449 12,348.72 Program number: 13,230.00 13,230.00 1.99 863.22 6.525 12,366.78 L Department number: Board of Directors 13,230.00 13,230.00 1.99 863.22 6.525 12,366.78 57 of 149 April 20, 2020 Complete Agenda Packet glbase_tbam skrolczyk Trophy Club MUD No.1 12:47 04/15/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 628,298.00 628,298.00 29,223.93 135-50010-030-000 Overtime 2,000.00 2,000.00 11.24 135-50016-030-000 Longevity 2,208.00 2,208.00 135-50020-030-000 Retirement 58,554.00 58,554.00 2,707.18 135-50026-030-000 Medical Insurance 124,394.00 124,394.00 6,345.77 135-50027-030-000 Dental Insurance 6,464.00 6,464.00 349.75 135-50028-030-000 Vision Insurance 1,035.00 1,035.00 51.68 135-50029-030-000 Life Insurance & Other 4,500.00 4,500.00 359.91 135-50030-030-000 Social Security Taxes 39,215.00 39,215.00 1,669.17 135-50035-030-000 Medicare Taxes 9,171.00 9,171.00 390.37 135-50040-030-000 Unemployment Taxes 1,440.00 1,440.00 797.17 135-50045-030-000 Workman's Compensation 1,775.00 1,775.00 104.82 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 135-50070-030-000 Employee Relations 8,000.00 8,000.00 178,489.43 31.77 2,207.50 18,232.16 35,503.74 1,968.45 301.35 1,995.36 10,460.02 2,446.32 843.83 628.92 3,078.10 28.408 449,808.57 1.589 1,968.23 99.977 .50 31.137 40,321.84 28.541 88,890.26 30.453 4,495.55 29.116 733.65 44.341 2,504.64 26.674 28,754.98 26.675 6,724.68 58.599 596.17 35.432 1,146.08 500.00 38.476 4,921.90 42,010.99 256,186.95 135-55030-030-000 135-55070-030-000 135-55080-030-000 135-55085-030-000 135-55120-030-000 135-55160-030-000 135-55205-030-000 Software & Support Independent Labor Maintenance & Repairs Generator Maint. and Repair Cleanin7 Services Professional Outside Services Utility Billing Contract 134,681.00 134,681.00 135,000.00 135,000.00 15,000.00 15,000.00 10,000.00 10,000.00 10,000.00 10,000.00 65,600.00 65,600.00 9,000.00 9,000.00 135-60005-030-000 Telephone 23,680.00 23,680.00 135-60010-030-000 Communications/Mobiles 4,000.00 4,000.00 135-60020-030-000 Electricity/Gas 6,879.00 6,879.00 135-60025-030-000 Water 1,500.00 1,500.00 135-60035-030-000 Postage 30,000.00 30,000.00 135-60040-030-000 Service Charges & Fees 67,000.00 67,000.00 135-60050-030-000 Bad Debt Expense 1,500.00 1,500.00 135-60055-030-000 Insurance 84,000.00 84,000.00 135-60066-030-000 Publications/Books/Subscripts 1,000.00 1,000.00 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 135-60075-030-000 Meetings 400.00 400.00 135-60079-030-000 Public Education 6,000.00 6,000.00 135-60080-030-000 Schools & Training 6,850.00 6,850.00 135-60100-030-000 Travel & per diem 3,545.00 3,545.00 135-60110-030-000 Physicals/Testing 200.00 200.00 135-60115-030-000 Elections 135-60125-030-000 Advertising 2,500.00 2,500.00 58 of 149 4,833.93 2,615.53 869.06 2,500.00 1,167.23 1,480.62 237.75 753.27 126.07- 3,346.77 5,301.14 6,998.39 53.72 161.82 219.00 19.02 1,772.20 131,676.58 57,200.02 1,165.00 531.00 4,345.30 2,500.00 3,642.04 97.769 42.370 7.767 5.310 43.453 3.811 40.467 3,004.42 77,799.98 13,835.00 9,469.00 5,654.70 63,100.00 5,357.96 201,0 178,2 8,880.17 1,427.31 2,753.81 257.82 10,153.57 36,723.18 38,428.48 125.00 4,285.55 115.09 3,971.51 1,382.21 714.16 138.04 1,772.20 37.501 35.683 40.032 17.188 33.845 54.811 45.748 12.500 71.426 28.773 66.192 20.178 20.146 70.888 14,799.83 2,572.69 4,125.19 1,242.18 19,846.43 30,276.82 1,500.00 45,571.52 875.00 1,714.45 284.91 2,028.49 5,467.79 2,830.84 200.00 138.04- 727.80 April 20, 2020 Complete Agenda Packet glbase_tbam skrolczyk Trophy Club MUD No.1 12:47 04/15/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60235-030-000 135-60245-030-000 135-60246-030-000 135-60360-030-000 Security Miscellaneous Expenses General Manager Contingency Furniture/Equipment < $5000 1,288.00 1,288.00 500.00 500.00 17,000.00 17,000.00 2,500.00 2,500.00 135-65010-030-000 Uniforms 2,050.00 2,050.00 135-65055-030-000 Hardware 26,485.00 26,485.00 135-65085-030-000 Office Supplies 6,000.00 6,000.00 135-65090-030-000 Printer Supplies & Maintenance 3,500.00 3,500.00 135-65095-030-000 Maintenance Supplies 4,000.00 4,000.00 135-65105-030-000 Printing 2,500.00 2,500.00 135-69005-030-000 Capital Outlays 135-69170-030-000 Copier Lease Installments Program number: Department number: Administration 195,000.00 4,000.00 195,000.00 4,000.00 ,000.00 ,712.00 .712.00 59 of 149 24.00 144.00 11.180 20,241.63 111,272.10 3,235.24 198.01 2,200.25 110.83 2,809.63 2,867.91 274.86 8,245.12 2,915.30 1,546.33 12.215 36.671 70.241 1.495 38.658 1,144.00 500.00 17,000.00 2,500.00 2,050.00 23,249.76 3,799.75 3,500.00 1,190.37 2,500.00 192,084.70 2,453.67 581,225.74 32.714 1,195,486.26 glbase_tbam skrolczyk 12:47 04/15/20 Fund: 135 MUD 1 General Fund Account Description 135-55045-039-000 135-55055-039-000 135-55060-039-000 1 135-55065-039-000 Le al Auditing_ Appraisal Tax Admin Fees April 20, 2020 Complete Agenda Packet Trophy Club MUD No.1 Budget Summary with Amendment Department: 39 Non Departmental Program: Period Ending: 3/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135,000.00 33,800.00 11,761.00 4,000.00 135,000.00 33,800.00 11,761.00 4,000.00 26,262.50 2,243.48 82,964.89 27,713.27 7,422.04 3,756.00 61.455 81.992 63.107 93.900 52,035.11 6,086.73 4,338.96 244.00 Page 12 60 of 149 ir Subtotal: ' 184,561.00 184,561.00 28,505.98 121,856.20 66.025 62,704.80 Program number: 184,561.00 184,561.00 28,505.98 121,856.20 66.025 62,704.80 Department number: Non Departmental 184,561.00 184,561.00 28,505.98 121,856.20 66.025 62,704.80 Expenditures Subtotal 10,638,853.00 10,638,853.00 466,021.75 3,959,717.09 37.219 6,679,135.91 Fund number: 135 MUD 1 General Fund 6,224.00- 6,224.00- 97,751.98- 55,896.27 -898.076 62,120.27- 60 of 149 glbase_tbam skrolczyk 12:47 04/15/20 Fund: 137 MUD 1 Consolidated GASS Account Description 137-49145-000-000 137-49146-000-000 H Subtot Program number: Department number: Revenues Fund number: 137 MUD Intergov Transfer -General Fund Intergov Transfer -Fire Dept Subtotal 1 Consolidated GASB Trophy Club MUD No.1 Budget Summary with Amendment Department: Program: April 20, 2020 Complete Agenda Packet Period Ending: 3/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 61 of 149 205,000.00- 81,420.00- 286,420.00- 286,420.00- 286,420.00- 286,420.00- 205,000.00 81,420.00 286, 286,420.00 286,420.00 286,420.00 286,420.00 glpdatb2 skrolczyk 12:48 04/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Ac0ount: 135-40000-000- 1024 03/02/2020 Property Taxes 1025 03/03/2020 Property Taxes 1026 03/04/2020 Property Taxes 1027 03/05/2020 Property Taxes 1029 03/06/2020 Property Taxes 1031 03/10/2020 Property Taxes 1032 03/11/2020 Property Taxes 1033 03/12/2020 Property Taxes 1034 03/13/2020 Property Taxes 1035 03/16/2020 Property Taxes 1036 03/17/2020 Property Taxes 1037 03/18/2020 Property Taxes 1038 03/19/2020 Property Taxes 1039 03/20/2020 Property Taxes 1040 03/23/2020 Property Taxes 1041 03/24/2020 Property Taxes 1042 03/31/2020 Property Taxes Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 3/2020 JE Detail Beginning Description/Comment Balance Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) April 20, 2020 Complete Agenda Packet Check Source Number Property Taxes (132,872.45) (103.40) (132,975.85) (17.24) (132,993.09) (127.21) (133,120.30) (18.33) (133,138.63) (192.97) (133,331.60) (4.90) (133,336.50) (50.24) (133,386.74) (3.90) (133,390.64) (68.73) (133,459.37) (55.91) (133,515.28) (110.28) (133,625.56) (59.47) (133,685.03) (67.14) (133,752.17) (27.34) (133,779.51) (66.16) (133,845.67) (54.15) (133,899.82) (254.90) (134,154.72) GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 135-40000-000-b Property Taxes Totals: (134,871.00) Budgeted (716.28) Remaining 99 % Used Account: 135-40002-000-00 1025 03/03/2020 Property Taxes 1030 03/09/2020 Property Taxes 1033 03/12/2020 Property Taxes 1042 03/31/2020 Property Taxes Property Taxes/Delinquent Property Taxes/Delinquent (300.00) Budgeted (246.29) (7.20) Remaining 98 % Used (18.55) (1.63) (23.76) (2.57) (264.84) (266.47) (290.23) (292.80) GL GL GL GL Account: 135-40015-000-000 1024 03/02/2020 Property Taxes 1025 03/03/2020 Property Taxes 1026 03/04/2020 Property Taxes 1027 03/05/2020 Property Taxes 1029 03/06/2020 Property Taxes 1030 03/09/2020 Property Taxes 1032 03/11/2020 Property Taxes 1033 03/12/2020 Property Taxes 1034 03/13/2020 Property Taxes Property Taxes/P & I (305.45) 62 of 149 (6.62) (5.84) (9.13) (1.28) (13.51) (.43) (4.52) (6.98) (6.81) (312.07) (317.91) (327.04) (328.32) (341.83) (342.26) (346.78) (353.76) (360.57) GL GL GL GL GL GL GL GL GL April 20, 2020 Complete Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1035 03/16/2020 Property Taxes 1036 03/17/2020 Property Taxes 1040 03/23/2020 Property Taxes 1041 03/24/2020 Property Taxes 1042 03/31/2020 Property Taxes (305.45) (3.56) (5.87) (4.01) (3.26) (7.71) (364.13) (370.00) (374.01) (377.27) (384.98) GL GL GL GL GL Account: 135-40015n76611 Property Taxes/P & I Totals: (300.00) Budgeted 84.98 Remaining 128 % Used Account: 135-40025-000-000 PID Surcharges Account: 135-40025-000-000 PID Surcharges (164,253.00) Budgeted Account: 135-47000-000-000 995 03/31/2020 UB 03/31/2020 Billing (164,253.00) Remaining 0 % Used UB20200331-20200331 User: (1,805,515.03) .00 .00 .00 (296,299.54) (2,101,814.57) UB Account: 135-47000-000-00 96,299.54 (6,486,623.00) Budgeted (4,384,808.43) Remaining Account: 135-47005-000-0 995 03/31/2020 UB 03/31/2020 Billing UB20200331-20200331 User: 32 % Used (1,251,049.59) (250,710.40) (1,501,759.99) UB AC (3,503,885.00) Penaltie Budgeted (2,002,125.01) Remaining 904 03/09/2020 UB 03/09/2020 Penalty removal UB20200309-20200309 User: 945 03/18/2020 UB 03/18/2020 Penalty removal UB20200318-20200318 User: 963 03/23/2020 UB 03/23/2020 Penalties UB20200323-20200323 User: 989 03/30/2020 penalty removal UB20200330-20200330 User: 990 03/31/2020 penalty removals UB20200331-20200331 User: 43 (45,896.48) Used 1,329.06 (44,567.42) 125.09 (44,442.33) (8,741.12) (53,183.45) 628.77 (52,554.68) 437.17 (52,117.51) UB UB UB UB UB Penalties Totals: (112,608.00) Budgeted (60,490.49) Remaining 46 % Used Service 63 of 149 April 20, 2020 Complete Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 914 03/10/2020 UB 03/10/2020 Disconnect Fees UB20200310-20200310 User: 953 03/13/2020 UB 03/13/2020 NSF Check UB20200313-20200313 User: 945 03/18/2020 UB 03/18/2020 Penalty removal UB20200318-20200318 User: 964 03/19/2020 UB 03/19/2020 NSF Check UB20200319-20200319 User: (8,800.00) (1,000.00) (9,800.00) UB (25.00) (9,825.00) UB 50.00 (9,775.00) UB (25.00) (9,800.00) UB Account: 135-47030-000-000 Service Charges Totals: (1,000.00) ■ (9,800.00) ** (15,150.00) Budgeted (5,350.00) Remaining 65 % Used Account: 135-47035-000-000 Plumbing Inspections (2,250.00) .00 (2,250.00) Account: 135-47035-000-000 Plumbing Inspections Totals: .00 (2,250.00) ** (750.00) Budgeted 1,500.00 Remaining 300 % Used Account: 135-47045-000-000 Sewer Inspections (1,350.00) .00 (1,350.00) Account: 135-47045-000-000 Sewer Inspections Totals: .00 (1,350.00) ** (2,500.00) Budgeted (1,150.00) Remaining 54 % Used Account: 135-47070-000-000 TCCC Effluent Charges (15,068.00) .00 (15,068.00) Account: 135-47070-000-000 TCCC Effluent Charges Totals: .00 (15,068.00) ** (50,000.00) Budgeted (34,932.00) Remaining 30 5 Used Account: 135-49011-000-000 Interest Income 1047 03/31/2020 Bank Interest- March 1047 03/31/2020 Bank Interest- March 1047 03/31/2020 Bank Interest- March (51,811.06) (1,155.83) (52,966.89) GL (1,161.71) (54,128.60) GL (4,979.14) (59,107.74) GL Account: 135-49011-000-000 ■ come Totals: (7,296.68) (59,107.74) ** (120,000.00) Budgeted (60,892.26) Remaining 49 5 Used Account: 135-49016-000-000 Cell Tower Revenue (5,894.05) .00 (5,894.05) Account: 135-49016-000-000 Cell Tower Revenue Totals: .00 (5,894.05) ** (14,146.00) Budgeted (8,251.95) Remaining 42 % Used 64 of 149 glpdatb2 skrolczyk 12:48 04/15/20 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: 3/2020 JE Detail Description/Comment Account: 135-49018-000-0 Building Rent Incom 1028 03/31/2020 Town Billed Invoices 1730-1733 AR 20200331-20200331 User: April 20, 2020 Complete Agenda Packet Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 135-49018-00 Building Rent Ince (7,000.00) Budgeted (3,500.02) Remaining (2,916.65) (583.33) (3,499.98) AR 50 Ueed Account: 135-49026-000-000 • Proceeds from Sale of Assets Account: 135-49026-000-000 ■ Proceeds from Sale of Assets (13,000.00) Budgeted (13,000.00) Remaining .00 0 % Ueed .00 Oversize Meter Reimbursement Account: - - - Oversize Meter Reimbursement Totals: (12,691.00) Budgeted (4,960.72) Remaining Account: 135-49900-000-000 Miscellaneous Income 995 03/31/2020 GB 03/31/2020 Billing UB20200331-20200331 User: Account: 135-49900-000-000 (7,730.28) .00 (7,730.28) 61 % Used (8,341.76) (254.44) Miscellaneous In (254.44) (7,000.00) Budgeted 1,596.20 Remaining 123 % Used (8,596.20) GB (8,596.20) ** Department Totals: (3,903,820.82) ** (563,773.73) Monthly Total (10,645,077.00) Budgeted (6,741,256.18) Remaining 37 % Used 65 of 149 April 20, 2020 Complete Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-010-000 Salaries & Wages 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Salaries & Wages 132,263.00 933 03/20/2020 MUD Payroll 3/20/2020 Salaries & Wages 14,944.73 147,207.73 PR 15,154.38 162,362.11 PR Account: 135-50005-010-000 Salaries & Wages Totals: 30,099.11 162,362.11 ** 350,267.00 Budgeted 187,904.89 Remaining 46 % Used Account: 135-50010-010-000 Overtime 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Overtime 8,861.76 691.45 9,553.21 PR 933 03/20/2020 MUD Payroll 3/20/2020 Overtime 784.13 10,337.34 PR Account: 135-50010-010-000 Overtime Totals: 1,475.58 10,337.34 ** 17,000.00 Budgeted 6,662.66 Remaining 61 % Used Account: 135-50016-010-000 Longevity 5,082.50 .00 5,082.50 Account: 135-50016-010-000 Longevity Totals: .00 5,082.50 ** 3,920.00 Budgeted (1,162.50) Remaining 130 % Used Account: 135-50017-010-000 Certification 933 03/20/2020 MUD Payroll 3/20/2020 Certification 2,075.00 425.00 2,500.00 PR Account: 135-50017-010-000 Certification Totals: 425.00 2,500.00 ** 5,400.00 Budgeted 2,900.00 Remaining 46 % Used Account: 135-50020-010-000 Retirement 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Retirement 933 03/20/2020 MUD Payroll 3/20/2020 Retirement 14,802.58 1,447.89 16,250.47 PR 1,515.27 17,765.74 PR Account: 135-50020-010-000 Retirement Totals: 2,963.16 17,765.74 ** 34,863.00 Budgeted 17,097.26 Remaining 51 % Used Account: 135-50026-010-000 Medical Insurance 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Medical Insurance 24,378.62 933 03/20/2020 MUD Payroll 3/20/2020 Medical Insurance 2,612.55 26,991.17 PR 2,612.49 29,603.66 PR Account: 135-50026-010-000 Medical Insurance Totals: 5,225.04 29,603.66 ** 84,326.00 Budgeted 54,722.34 Remaining 35 % Used 66 of 149 April 20, 2020 Complete Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-010- 1 Insul 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Dental Insurance 933 03/20/2020 MUD Payroll 3/20/2020 Dental Insurance 1,481.48 158.32 1,639.80 PR 158.31 1,798.11 PR Account: -1.1 Dental Ineuranc Totals: mEllir 4,725.00 Budgeted 2,926.89 Remaining 38 % Used Account: 135-50028-010-000 ion Insurance 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Vision Insurance 933 03/20/2020 MUD Payroll 3/20/2020 Vision Insurance 236.11 24.10 260.21 24.08 284.29 PR PR Account: Vision Insurance Totals: - 812 03/01/2020 March Payroll Benefits 812 03/01/2020 March Payroll Benefits 966 03/23/2020 March A/P 1063 03/31/2020 March A/P Account: 135-50029-010-00 767.00 Budgeted e Insurance & Other Employee Benefits Employee LTD & STD Caf 125 Caf 125 Life Insuran• 3,132.00 Budgeted 482.71 Remaining 37 % Used 1,226.45 Account: 135-50030-010- ocial Securi 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Social Security Taxes 933 03/20/2020 MUD Payroll 3/20/2020 Social Security Taxes A Remaining 030-037"911111111111111111.Social Security Taxes AL Totals: 23,348.00 Budgeted 12,300.52 Remaining Account: 135-50035-010-000 Medicare Taxes 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Medicare Taxes 933 03/20/2020 MUD Payroll 3/20/2020 Medicare Taxes • 1,552.66 176.88 1,729.54 Humana Inc 6223 AP 132.01 1,861.55 METLIFE GROUP BENEFITS 6231 AP 22.00 1,883.55 BenefitMall 6295 AP 22.00 1,905.55 BenefitMall AP 9,090.21 2,125.91 61 Used 959.58 10,049.79 997.69 11,047.48 47 % Used 224.43 2,350.34 PR PR PR 233.32 2,583.66 PR Account Medicare Taxes Totals: 5,461.00 Budgeted 2,877.34 Remaining 47 % Used Account: 135-5004 Unemployment Taxes 67 of 149 glpdatb2 skrolczyk 12:48 04/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Department: 10 Water JE Detail Description/Comment 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Unemployment Taxes 933 03/20/2020 MUD Payroll 3/20/2020 Unemployment Taxes Trophy Club MUD No.1 Detailed Accounting Trial Balance Program: April 20, 2020 Complete Agenda Packet Period Ending: 3/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) 63.65 5.38 811.65 69.03 880.68 PR PR 1001 03/26/2020 PCards 2/27/2020-3/26/2020 1001 03/26/2020 PCards 2/27/2020-3/26/2020 1001 03/26/2020 PCards 2/27/2020-3/26/2020 1001 03/26/2020 PCards 2/27/2020-3/26/2020 1001 03/26/2020 PCards 2/27/2020-3/26/2020 1001 03/26/2020 PCards 2/27/2020-3/26/2020 Carb+Ignit Coil Air Filter kit fluid, flat back, bushing quick connects, hose gauge refund gauge 23,276.50 68 of 149 19.98 48.63 90.88 107.39 (142.12) 209.43 23,296.48 AMZN MKTP US*I82AK8HT3 23,345.11 THE HOME DEPOT 86581 23,435.99 IN *HOSE TECH USA 23,543.38 GALCO INDUSTRIAL ELECT 23,401.26 GALCO INDUSTRIAL ELECT 23,610.69 GALCO INDUSTRIAL ELECT PC PC PC PC PC PC Account: 135-50040-010-000 Unemployment Taxes Totals: 817.03 880.68 ** 1,080.00 Budgeted 199.32 Remaining 82 % Used Account: 135-50045-010-000 Workman's Compensation 71 03/01/2020 Insurance/Wrk 923 03/12/2020 March A/P Comp Expense Mar WC FY 19 Adjustment 3,857.45 771.49 175.50 4,628.94 4,804.44 TML INTERGOVERNMENTAL RISK 6277 GL AP Account: 135-50045-010-000 Workman's Compensation Totals: 946.99 ** 11,850.00 Budgeted 7,045.56 Remaining 41 % 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 A Repairs 1001 03/26/2020 PCards 2/27/2020-3/26/2020 1001 03/26/2020 PCards 2/27/2020-3/26/2020 1001 03/26/2020 PCards 2/27/2020-3/26/2020 1001 03/26/2020 PCards 2/27/2020-3/26/2020 1001 03/26/2020 PCards 2/27/2020-3/26/2020 1001 03/26/2020 PCards 2/27/2020-3/26/2020 Carb+Ignit Coil Air Filter kit fluid, flat back, bushing quick connects, hose gauge refund gauge 23,276.50 68 of 149 19.98 48.63 90.88 107.39 (142.12) 209.43 23,296.48 AMZN MKTP US*I82AK8HT3 23,345.11 THE HOME DEPOT 86581 23,435.99 IN *HOSE TECH USA 23,543.38 GALCO INDUSTRIAL ELECT 23,401.26 GALCO INDUSTRIAL ELECT 23,610.69 GALCO INDUSTRIAL ELECT PC PC PC PC PC PC glpdatb2 skrolczyk 12:48 04/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Department: 10 Water JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 3/2020 Beginning Balance Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) April 20, 2020 Complete Agenda Packet Check Source Number I 1001 03/26/2020 PCards 2/27/2020-3/26/2020 gauge check/calibration 23,276.50 105.00 23,715.69 MACARTHUR GAUGE INC PC Account: 135-55080-010-000 Maintenance & Repairs Totals: 439.19 23,715.69 ** Used 100,000.00 Budgeted 76,284.31 Remaining 24 % Used Account: 135-55105-010-000 Account: 135-55085-010-000 Generator Maint. and Repair 111r- 923 03/12/2020 March A/P backhoe windsheild 920.37 .00 .00 1,828.19 HOLT CAT 135-55085-010-000 Generator Maint. and Repair Totals: Account: 135-55105-010-000 —AVAccount: .00 .00 ** 907.82 1,828.19 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 135-55090-010-000 Vehicle Maintenance Account: 1001 03/26/2020 PCards 2/27/2020-3/26/2020 vehicle registration 727.67 22.00 749.67 DENTON VEHREG PC 1001 03/26/2020 PCards 2/27/2020-3/26/2020 1001 03/26/2020 PCards 2/27/2020-3/26/2020 1001 03/26/2020 PCards 2/27/2020-3/26/2020 1001 03/26/2020 PCards 2/27/2020-3/26/2020 veh registration fee back glass install tires oil change, parking brake 2.00 751.67 TX.GOV*SERVICEFEE-DIR 243.56 995.23 ELITE AUTO GLASS 335.50 1,330.73 DISCOUNT TIRE TXD 75 511.83 1,842.56 INLAND TRUCK PARTS # PC PC PC PC Account: 135-55090-010-000 Vehicle Maintenance Totals: 1,114.89 1,842.56 ** - 5,000.00 Budgeted 3,157.44 Remaining 37 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 111r- 923 03/12/2020 March A/P backhoe windsheild 920.37 907.82 1,828.19 HOLT CAT 6264 AP Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: 907.82 1,828.19 ** 3,500.00 Budgeted 1,671.81 Remaining 52 % Used Account: 135-55120-010-000 Cleaning Services 966 03/23/2020 March A/P janitorial svc-february 350.00 87.50 437.50 MEMBER'S BUILDING MAINTENANCE 6309 AP Account: 135-55120-010-000 Cleaning Services Totals: 87.50 437.50 ** 1,000.00 Budgeted 562.50 Remaining 44 % Used Account: 135-55135-010-000 Lab Analysis 923 03/12/2020 923 03/12/2020 March A/P March A/P water samples TCEQ samples 1,597.70 220.00 213.94 1,817.70 2,031.64 TARRANT CTY PUBLIC HEALTH LAB LOWER COLORADO RIVER AUTHORITY 6272 6267 AP AP Account: 135-55135-010-000 Lab Analysis Totals: 433.94 2,031.64 ** 7,500.00 Budgeted 5,468.36 Remaining 27 % Used 69 of 149 glpdatb2 skrolczyk 12:48 04/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Department: 10 Water JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 3/2020 Beginning Balance Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) April 20, 2020 Complete Agenda Packet Check Source Number 70 of 149 Account: 135-60010-010-000 7 Communications/Mobiles i_ 923 03/12/2020 March A/P Cell phones -March 2,472.95 424.30 2,897.25 VERIZON WIRELESS 6281 AP Account: 135-60010-010-000 Communications/Mobiles Totals: 424.30 2,897.25 ** 5,000.00 Budgeted 2,102.75 Remaining 58 % Used Account: 135-60020-010-000 Electricity 966 03/23/2020 March A/P Electricity 2/10-3/10 966 03/23/2020 March A/P Electricity 2/10-3/10 46,151.60 12,367.52 6,540.65 58,519.12 65,059.77 HUDSON ENERGY SERVICES, HUDSON ENERGY SERVICES, LLC LLC 6303 6303 AP AP Account: 135-60020-010-000 Electricity Totals: 18,908.17 65,059.77 125,677.00 Budgeted 60,617.23 Remaining 52 % 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 0 % Used Account: 135-60070-010-000 Dues & Memberships .00 .00 Account: 135-60070-010-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60080-010-000 Schools & Training 1001 03/26/2020 PCards 2/27/2020-3/26/2020 M. Hubbard Mid Citie Dist Memb 1001 03/26/2020 PCarde 2/27/2020-3/26/2020 C.Howard Mid Cities Dist Memb 1,196.00 120.00 120.00 1,316.00 1,436.00 TRAINING TRAINING PC PC Account: 135-60080-010-000 Schools & Training ma_ Totals: 240.00 1,436.00 ** 7,426.00 Budgeted 5,990.00 Remaining 19 s Used Account: 135-60090-010-000 T Safety Program .00 .00 Account: 135-60090-010-000 Safety Program Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used 70 of 149 glpdatb2 skrolczyk 12:48 04/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Department: 10 Water JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 3/2020 Beginning Balance Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) April 20, 2020 Complete Agenda Packet Check Source Number 71 of 149 Account: 135-60100-010-000"IIIITravel & per diem .00 .00 Account: 135-60100-010-000 Travel & per diem Totals: .00 .00 ** 2,845.00 Budgeted 2,845.00 Remaining 0 % Used Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 16,942.84 16,942.84 .00 Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 16,942.84 ** 63,000.00 Budgeted 46,057.16 Remaining 27 % Used Account: 135-60150-010-000 Wholesale Water 966 03/23/2020 March A/P wholesale water 572,020.73 86,448.49 658,469.22 CITY OF FORT WORTH 6296 AP Account: 135-60150-010-000 Wholesale Water Totals: 86,448.49 658,469.22 ** 2,714,710.00 Budgeted 2,056,240.78 Remaining 24 % Used Account: 135-60245-010-000 Miscellaneous Expenses .00 .00 Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60280-010-000 Property Maintenance 756.00 .00 756.00 Account: 135-60280-010-000 Property Maintenance Totals: .00 756.00 ** 3,000.00 Budgeted 2,244.00 Remaining 25 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance 71 of 149 April 20, 2020 Complete Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1058 03/31/2020 March A?P Mowing -March 750.00 750.00 WATTS ELLISON LLC AP Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: 750.00 750.00 ** 14,750.00 Budgeted 14,000.00 Remaining 5 % Used Account: 135-60332-010-000 Interfund Transfer Out -Rev I&S 1046 03/30/2020 TexPool Transfers March TexPool O&M to 16Swift Rev I&S 308,406.76 25,047.72 333,454.48 GO. Account: 135-60332-010-000 Interfund Transfer Out -Rev I&S Totals: 25,047.72 333,454.48 ** 527,381.00 Budgeted 193,926.52 Remaining 63 % Used Account: 135-60333-010-000 Interfund Transfer Out -Reserve 1046 03/30/2020 TexPool Transfers March TexPool O&M to Rev Bond Resevr 23,000.00 4,600.00 27,600.00 GL Account: 135-60333-010-000 Interfund Transfer Out -Reserve Totals: 4,600.00 27,600.00 ** 55,193.00 Budgeted 27,593.00 Remaining 50 % 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 561.72 .00 561.72 Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 561.72 ** 2,500.00 Budgeted 1,938.28 Remaining 22 % Uaed Account: 135-65005-010-000 Fuel & Lube 979 03/24/2020 Fuel- March 2020 Fuel -Mar 4,514.91 906.24 5,421.15 US Bank Voyager Fleet Systems 6343 AP Account: 135-65005-010-000 Fuel & Lube Totals: 906.24 5,421.15 ** 15,000.00 Budgeted 9,578.65 Remaining 36 5 Uaed Account: 135-65010-010-000 Uniforms 2,917.33 72 of 149 .00 2,917.33 April 20, 2020 Complete Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Uniforms 5,190.00 Budgeted Chemicals 966 03/23/2020 March A/P testing supplies 966 03/23/2020 March A/P testing supplies 1000 03/31/2020 March AP testing supplies 1000 03/31/2020 March AP chlorine 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 Account: 135-65050-010-000 Account: 135-65053-010-000 Account: 135-65053-010-000 Account: 135-69005-010-000 Chemical 20,000.00 Budgeted Sural Small Tools 1,200.00 Budgeted Safety Equipment Safety Equipment 1,000.00 Budgeted Meter Expense Meter Expense Totals: 2,272.67 Remaining 56 % Ueed 2,917.33 •• 9,016.50 748.77 9,765.27 HACH COMPANY 504.63 10,269.90 HACH COMPANY 475.53 10,745.43 HACH COMPANY 558.41 11,303.84 DPC INDUSTRIES, INC 8,696.16 Remaining 57 % Used Totals: 1,200.00 Remaining 0 % Used .00 .00 .00 .00 Totals: 1,000.00 Remaining 0 % Used 16,869.78 70,000.00 Budgeted 53,130.22 Remaining 24 % Ueed Meter Change Out Program -nge Out Program T•tals: 87,000.00 Budgeted 50,100.00 Remaining 36,900.00 42 Ueed 73 of 149 .00 16,869.78 .00 36,900.00 6301 AP 6301 AP 6339 AP 6338 AP April 20, 2020 Complete Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 986 03/30/2020 March A/P spare parts 176,710.03 12,503.46 189,213.49 HACH COMPANY 6339 AP Accoun. 0 Capital approir12,50 684,875.00 Budgeted 495,661.51 Remaining Account: 135-69008-010-000 Account: 135-69008-010-000 Short Term Debt -Principal Short Term Debt -Principal 30,512.00 Budgeted 30,512.00 28 % Used .00 30,512.00 .00 Remaining 100 % Used Account: 135-69009-010-000 Short Term Debt -Interest Account: 135-69009-010-000 Short Term Debt -Interest 3,231.00 Budgeted 1,391.00 Remaining 1,840.00 .00 1,840.00 57 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: 75,000.00 Budgeted .00 Remaining 75,000.00 100 % Used .00 75,000.00 Account: 135-69281-010-000 Water Tank Inspection Contract 102,077.11 Account: 135-69281-010-000 Water Tank Inspection Contract Totals: 120,000.00 Budgeted 17,922.89 Remaining .00 102,077.11 85 % Used 74 of 149 glpdatb2 skrolczyk 12:48 04/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Account: 135-55135-010-001 4M11- 923 03/12/2020 March A/P 923 03/12/2020 March A/P Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 3/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment Lab Analysis for PID water samples TCEQ samples April 20, 2020 Complete Agenda Packet 547.70 80.00 627.70 TARRANT CTY PUBLIC HEALTH LAB 6272 AP 213.94 841.64 LOWER COLORADO RIVER AUTHORITY 6267 AP Account: Lab Analysis for PID Totals: 2,000.00 Budgeted 1,158.36 Remaining Department 10 Totals: 42 Used 1,861,634.76 ** 200,477.63 Monthly Total 5,506,929.00 Budgeted 3,645,294.24 Remaining 34 % Used 75 of 149 April 20, 2020 Complete Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) ACOOUnt: 135-5000 020- 8laries & We 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Salaries & Wages 933 03/20/2020 MUD Payroll 3/20/2020 Salaries & Wages 150,837.93 15,820.49 166,658.42 PR 16,024.11 182,682.53 PR Account :-'5nrelSalaries & Wages Totals: 441,799.00 Budgeted Account: 135-50010-020-000 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Overtime 933 03/20/2020 MUD Payroll 3/20/2020 Overtime 259,116.47 Remaining 41 % Used 9,765.30 776.31 10,541.61 PR 800.82 11,342.43 PR Account: 33,000.00 Budgeted 21,657.57 Remaining 34 % Ueed Account: 135 - Longevity 6,872.50 .00 6,872.50 Account: 135-50016-020-000 Longevity 8,035.00 Budgeted 1,162.50 Remaining 86 % Used Totals: Account: 135-50017-020-000 933 03/20/2020 MUD Payroll 3/20/2020 Certification Certification Account: 135-50017-020-000 ertification 9,000.00 Budgeted Account: 135-50020-020-000 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Retirement 933 03/20/2020 MUD Payroll 3/20/2020 Retirement Account: 135-50020-020-000 5,175.00 Remaining 3,200.00 625.00 3,825.00 PR 17,332.99 43 % Used Retirement 3 Totals: 45,531.00 Budgeted 25,045.28 Remaining 45 % Used Account: Medical Insurance 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Medical Insurance 33,790.07 933 03/20/2020 MUD Payroll 3/20/2020 Medical Insurance Accci Medical Insurance 104,858.00 Budgeted Totals: 63,329.69 Remaining 40 % Used 76 of 149 1,536.87 18,869.86 1,615.86 20,485.72 3,869.14 37,659.21 PR PR PR 3,869.10 41,528.31 PR April 20, 2020 Complete Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) ACCOunt: 135-50027-020- 1 InsuI 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Dental Insurance 933 03/20/2020 MUD Payroll 3/20/2020 Dental Insurance 1,985.42 223.47 2,208.89 PR 223.43 2,432.32 PR Account: -1.1 Dental Insuranc Totals: mMillr 5,817.00 Budgeted 3,384.68 Remaining 42 % Used Account: 135-50028-020-000 ion Insurance 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Vision Insurance 933 03/20/2020 MUD Payroll 3/20/2020 Vision Insurance Account: Vision Insurance Totals: 948.00 Budgeted 320.43 4 34.87 355.30 34.87 390.17 557.83 Remaining 41 % Used - PR PR Life Insurance & Other Employee Benefits Employee LTD & STD Caf 125 Caf 125 • 812 03/01/2020 March Payroll Benefits 812 03/01/2020 March Payroll Benefits 966 03/23/2020 March A/P 1063 03/31/2020 March A/P Account: 135-50029-020-000 Life Insuran• 4,500.00 Budgeted 2,285.50 Account: 135-50030-020- ocial Securi 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Social Security Taxes 933 03/20/2020 MUD Payroll 3/20/2020 Social Security Taxes A Remaining 030-0°"91111111111111111Social Security Taxs- Totals: 30,494.00 Budgeted 18,623.61 Remaining Account: 135-50035-020-000 Medicare Taxes 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Medicare Taxes 933 03/20/2020 MUD Payroll 3/20/2020 Medicare Taxes Account Medicare Taxes 7,132.00 Budgeted 1,786.43 198.33 1,984.76 Humana Inc 6223 AP 165.74 2,150.50 METLIFE GROUP BENEFITS 6231 AP 32.00 2,182.50 BenefitMall 6295 AP 32.00 2,214.50 BenefitMall AP 9,915.32 49 Used - 969.45 10,884.77 985.62 11,870.39 39 % Ueed - 11112,318.90 226.71 2,545.61 230.52 2,776.13 Totals: 4,355.87 Remaining 39 6 Used PR PR PR PR Account: 135-5004 Unemployment Taxes - 77 of 149 glpdatb2 skrolczyk 12:48 04/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description April 20, 2020 Complete Agenda Packet Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Program: Period Ending: 3/2020 JE Detail Beginning Transaction Transaction Vendor Name Check Source Description/Comment Balance Detail Detail Number (SUBTOTAL) 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Unemployment Taxes 933 03/20/2020 MUD Payroll 3/20/2020 Unemployment Taxes 59.12 1.58 934.52 60.70 995.22 PR PR 78 of 149 Account: 135-50040-020-000 Unemployment Taxes Totals: IIIIIP 936.10 995.22 ** 1,260.00 Budgeted 264.78 Remaining 79 % Used Account: 135-50045-020-000 Workman's Compensation 71 03/01/2020 Insurance/Wrk Comp 923 03/12/2020 March A/P Expense Mar WC FY 19 Adjustment 5,551.00 1,110.20 175.50 6,661.20 6,836.70 GL TML INTERGOVERNMENTAL RISK 6277 AP Account: 135-50045-020-000 Workman's Compensation Totals: 1,285.70 6,836.70 ** 15,373.00 Budgeted 8,536.30 Remaining 44 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 38.00 .00 38.00 Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 38.00 ** 400.00 Budgeted 362.00 Remaining 10 % 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 3,000.00 .00 3,000.00 Account: 135-55070-020-000 Independent Labor Totals: .00 3,000.00 ** 15,000.00 Budgeted 12,000.00 Remaining 20 % Used Account: 135-55080-020-000 Maintenance & Repairs 78 of 149 glpdatb2 skrolczyk 12:48 04/15/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 923 03/12/2020 March A/P 966 03/23/2020 March A/P 1001 03/26/2020 PCarde 2/27/2020-3/26/2020 1001 03/26/2020 1001 03/26/2020 1001 03/26/2020 1001 03/26/2020 1001 03/26/2020 1001 03/26/2020 1001 03/26/2020 PCards PCarde PCarde PCards PCards PCards PCarde 2/27/2020-3/26/2020 2/27/2020-3/26/2020 2/27/2020-3/26/2020 2/27/2020-3/26/2020 2/27/2020-3/26/2020 2/27/2020-3/26/2020 2/27/2020-3/26/2020 1058 03/31/2020 March A?P Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 3/2020 JE Detail Beginning Balance Description/Comment work/repair on perm pump #5 filter wraps water filters n95 masks, air freshner returned water filters Hose assembly plungers, bleach alcohol, vinyl tube,clamps,etc pump pump MBR 5 float 35,443.88 Program: Transaction Detail 1,400.00 100.80 99.98 144.98 (99.98) 158.79 57.82 82.01 2,143.87 1,357.47 691.00 Transaction Vendor Name Detail (SUBTOTAL) 36,843.88 36,944.68 37,044.66 37,189.64 37,089.66 37,248.45 37,306.27 37,388.28 39,532.15 40,889.62 41,580.62 April 20, 2020 Complete Agenda Packet Environmental Improvements Inc Filter Element Store LOWES #00732* LOWES #00732* LOWES #00732* IN *HOSE TECH USA THE HOME DEPOT #6581 THE HOME DEPOT 6581 MANUFACTURERS EDGE, IN MANUFACTURERS EDGE, IN DHS AUTOMATION, INC Check Source Number 6260 AP 6300 AP PC PC PC PC PC PC PC PC AP Account: 135-55080-020-000 Maintenance & Repairs Totals: 6,136.74 41,580.62 ** ' 88,000.00 Budgeted 46,419.38 Remaining 47 % Used Account: 135-55081-020-000 Mainten & Repairs Collections 1001 03/26/2020 PCards 2/27/2020-3/26/2020 brooms, cleaner, hose 17,677.78 45.88 17,723.66 THE HOME DEPOT #6581 PC Account: 135-55081-020-000 Mainten & Repairs Collections Totals: 45.88 17,723.66 ** 10,000.00 Budgeted (7,723.66) Remaining 177 % Used Account: 135-55085-020-000 Generator Maint. and Repair .00 .00 Account: 135-55085-020-000 Generator Maint. and Repair Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 5 Used Account: 135-55090-020-000 Vehicle Maintenance 1001 03/26/2020 1001 03/26/2020 PCarde PCards 2/27/2020-3/26/2020 state inspection 2/27/2020-3/26/2020 state inspection 742.98 25.50 25.50 768.48 793.98 KWIK KAR LUBE KWIK KAR LUBE & TUNE & TUNE 0 0 PC PC Account: 135-55090-020-000 Vehicle Maintenance Totals: 51.00 793.98 ** 4,000.00 Budgeted 3,206.02 Remaining 20 % Used Account: 135-55091-020-000 Veh Maintenance Collections 1001 03/26/2020 PCards 2/27/2020-3/26/2020 blue def peak 1,986.94 24.94 2,011.88 THE HOME DEPOT #6581 PC Account: 135-55091-020-000 Veh Maintenance Collections Totals: 24.94 2,011.88 ** 8,000.00 Budgeted 5,988.12 Remaining 25 % Used 79 of 149 April 20, 2020 Complete Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-5510020- aintenance-Backhoe/SkidLoader 1001 03/26/2020 PCards 2/27/2020-3/26/2020 tire repair Ac Maintenance-Backhoe/SkidLoader Total 3,000.00 Budgeted 2,167.78 Remaining Account: 135-55120-020-000 Account: Cleaning Services 966 03/23/2020 March A/P janitorial svc-february Cleaning Services 1,500.00 Budgeted Acc.85-55125-020-000 + Dempster Services 1058 03/31/2020 March A?P Sludge/grit 1058 03/31/2020 March A?P Sludge/grit 1058 03/31/2020 March A?P Sludge/grit Account: 135-55125-020-6111 Account: 135-55135-020-000 923 03/12/2020 March A/P 923 03/12/2020 March A/P 932 03/16/2020 March A/P 932 03/16/2020 March A/P 966 03/23/2020 March A/P 966 03/23/2020 March A/P 986 03/30/2020 March A/P 986 03/30/2020 March A/P 1007 03/31/2020 March A/P 1058 03/31/2020 March A?P 1058 03/31/2020 March A?P ACCOunt: 135 Dumpster Services 100,000.00 Budgeted Lab Analysis lab testing lab trsting lab testing lab trsting lab testing lab trsting lab testing lab trsting Bio -monitoring lab testing lab trsting Lab Analysis 40,000.00 Budgeted 559.67 272.55 28 % Used 832.22 BLAGGS TIRE WHOLESALE PC 350.00 87.50 437.50 MEMBER'S BUILDING MAINTENANCE 6309 AP 1,062.50 Remaining 29 % Used 38,479.62 2,468.22 40,947.84 L.H. CHANEY MATERIALS, INC. AP 1,181.10 42,128.94 L.H. CHANEY MATERIALS, INC. AP 1,154.44 43,283.38 L.H. CHANEY MATERIALS, INC. AP Totals: 56,716.62 Remaining 43 % Used Account: 135-60010-020-000 Communications/Mobiles 923 03/12/2020 March A/P Cell phones -March 15,048.65 341.55 15,390.20 OXIDOR LABORATORIES LLC 6270 AP 241.50 15,631.70 OXIDOR LABORATORIES LLC 6270 AP 341.55 15,973.25 OXIDOR LABORATORIES LLC 6292 AP 241.50 16,214.75 OXIDOR LABORATORIES LLC 6292 AP 341.55 16,556.30 OXIDOR LABORATORIES LLC 6313 AP 241.50 16,797.80 OXIDOR LABORATORIES LLC 6313 AP 341.55 17,139.35 OXIDOR LABORATORIES LLC 6342 AP 241.50 17,380.85 OXIDOR LABORATORIES LLC 6342 AP 1,080.00 18,460.85 HUTHER AND ASSOCIATES,INC 6344 AP 341.55 18,802.40 OXIDOR LABORATORIES LLC AP 241.50 19,043.90 OXIDOR LABORATORIES LLC AP Totals: ' 20,956.10 Remaining 48 % Used 2,679.40 408.87 80 of 149 • 3,088.27 VERIZON WIRELESS 6281 AP April 20, 2020 Complete Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Communications/Mobiles 5,000.00 Budgeted 1,911.73 Remaining 62 % Ueed 923 03/12/2020 March A/P electricity 2/3-3/3 1028 03/31/2020 Town Billed Invoices 1730-1733 AR 20200331-20200331 User: 1063 03/31/2020 March A/P electricity 3/3-4/1 Account: 135-60066-020-000 Account: 135-60066-020-000 Elate� 160,067.00 Budgeted Total 3,088.27 ** 60,843.27 511.03 61,354.30 TRI COUNTY ELECTRIC 6279 AP (572.62) 60,781.68 AR 508.83 61,290.51 TRI COUNTY ELECTRIC AP 98,776.49 Remaining 38 % Used Publications/Books/Subscripts Publications/Books/Subscripts Totals: 200.00 Budgeted 200.00 Remaining Account: 135-60070-020-000 ftos & Memberships 1001 03/26/2020 PCards 2/27/2020-3/26/2020 WEF Membership Account: 135-60070-020-00 & Memberships 300.00 Budgeted .00 .00 0 % Used 111.00 105.00 84.00 Remaining 72 % Used Account: 135-60080-020-0 r 1001 03/26/2020 PCards 2/27/2020-3/26/2020 O.Valadez license renewal 1001 03/26/2020 PCards 2/27/2020-3/26/2020 F.Isola class Account."1117S687781778Tchools & Training 4,990.00 Budgeted Safety Program Safety Program Totals: Account: 135-60090-020-000 Account: 135-60090-020-000 216.00 WEF MAIN PC 2,431.85 111.00 2,542.85 TCEQ IND RENEWAL LIC PC 420.00 2,962.85 TEEX ECOMMERCE PC Totals: 2,027.15 Remaining 59 % Ueed 1,000.00 Budgeted 109.14 .00 109.14 890.66 Remaining 11 % Used Account: 135-60100-020-000 .1.11131Fr diem 81 of 149 April 20, 2020 Complete Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Travel & per diem Account: 135-60100-020-8 Travel & per diem 1,545.00 Budgeted Account: 135-60105-020-000 Account: 135-60105-020-000 Rent/Lease Equipment Rent/Lease Equipment 5,000.00 Budgeted Account: 135-60125-020-000 Advertie Account: 135-60125-020-000 Account: 135-60135-020-000 Account: 135-60135-020-000 Account: 135-60245-020-000 Account: 135-60245-020-000 Account: 135-60280-020-000 Account: 135-60280-020-000 2,500.00 Budgeted TCEQ Fees & Permits TCEQ Fees & Permits 15,000.00 Budgeted Miscellaneous Expenses Miscellaneous Expenses 450.00 Budgeted Property Maintenance Property Maintenance 5,000.00 Budgeted Account: 135-60285-020-000 1058 03/31/2020 March An, Mowing -March 360.84 49.88 Totals: 49 1,134.28 Remaining 27 % Used 5,000.00 Remaining 2,500.00 Remaining 10,088.02 Totals: 0 % Used 0 % Used 4,911.98 Remaining 67 % Used 410.72 PR .00 .00 .00 .00 .00 10,088.02 .00 .00 Totals: 450.00 Remaining 0 % Ueed AIL Mir 584.94 .00 584.94 4,415.06 Remaining 12 % Used 82 of 149 590.00 590.00 WATTS ELLISON LLC AP glpdatb2 skrolczyk 12:48 04/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Program: Period Ending: 3/2020 Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment April 20, 2020 Complete Agenda Packet Check Source Number 83 of 149 Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 590.00 590.00 ** 14,000.00 Budgeted 13,410.00 Remaining 4 5 Used Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S 1046 03/30/2020 TexPool Transfers March TexPool O&M to I&S- PID Debt 52,074.05 10,414.81 62,488.86 GL Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S Totals: 10,414.81 62,488.86 ** 114,563.00 Budgeted 52,074.14 Remaining 55 % Used Account: 135-60332-020-000 Interfund Transfer Out -Rev I&S 1046 03/30/2020 TexPool Transfers March TexPool O&M to Rev Bd WWTP I&S 326,820.11 54,421.63 381,241.74 GL Account: 135-60332-020-000 Interfund Transfer Out -Rev I&S Totals: 54,421.63 381,241.74 ** 673,867.00 Budgeted 292,625.26 Remaining 57 % Used Account: 135-60333-020-000 Interfund Transfer Out -Reserve 1046 03/30/2020 TexPool Transfers March TexPool O&M to Rev Bond Resevr 28,750.00 5,750.00 34,500.00 GL Account: 135-60333-020-000 Interfund Transfer Out -Reserve Totals: i 5,750.00 34,500.00 ** 125,187.00 Budgeted 90,687.00 Remaining 28 % 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 190.00 .00 190.00 Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: .00 190.00 ** 2,000.00 Budgeted 1,810.00 Remaining 10 % Used Account: 135-65005-020-000 Fuel & Lube 979 03/24/2020 Fuel- March 2020 Fuel -Mar 3,755.00 491.70 4,246.70 US Bank Voyager Fleet Systems 6343 AP 83 of 149 glpdatb2 skrolczyk 12:48 04/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Program: Period Ending: 3/2020 Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment April 20, 2020 Complete Agenda Packet Check Source Number 84 of 149 Account: 135-65005-020-000 Fuel & Lube Totals: 491.70 4,246.70 ** 12,500.00 Budgeted 8,253.30 Remaining 34 5 Used Account: 135-65010-020-000 Uniforms 3,507.93 .00 3,507.93 Account: 135-65010-020-000 Uniforms Totals: .00 3,507.93 ** 5,495.00 Budgeted 1,987.07 Remaining 64 % Used Account: 135-65030-020-000 Chemicals 923 03/12/2020 March A/P Defoamer 1058 03/31/2020 March A?P sodium hypo 12.55 12,724.87 1,624.08 580.00 14,348.95 14,928.95 MARYLAND BIOCHEMICAL CO, Valley Solvent Company, INC INC 6266 AP AP Account: 135-65030-020-000 Chemicals Totals: 2,204.08 14,928.95 ** 20,000.00 Budgeted 5,071.05 Remaining 75 % Used Account: 135-65031-020-000 Chemicals Collections 4,994.00 .00 4,994.00 Account: 135-65031-020-000 Chemicals Collections Totals: .00 4,994.00 ** 17,500.00 Budgeted 12,506.00 Remaining 29 % Used Account: 135-65035-020-000 Small Tools .00 .00 Account: 135-65035-020-000 Small Tools Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-65040-020-000 Safety Equipment 1001 03/26/2020 PCards 2/27/2020-3/26/2020 respirator 1,111.63 54.90 1,166.53 THE HOME DEPOT #6581 PC Account: 135-65040-020-000 Safety Equipment Totals: 54.90 1,166.53 ** 1,200.00 Budgeted 33.47 Remaining 97 % Used Account: 135-65045-020-000 Lab Supplies 923 03/12/2020 March A/P lab supplies 10,837.36 342.38 11,179.74 HACH COMPANY 6263 AP 84 of 149 April 20, 2020 Complete Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 932 03/16/2020 March A/P nitrile gloves 932 03/16/2020 March A/P lab supplies 974 03/24/2020 March A/P lab supplies 974 03/24/2020 March A/P Lab supplies 986 03/30/2020 March A/P lab supplies 1005 03/31/2020 March A/P biomonitoring 1006 03/31/2020 March A/P Void to Recode biomonitoring Account: 135-65045-020-00u Lab Supplies 20,000.00 Budgeted Account: 10,837.36 169.20 11,348.94 LOU'S GLOVES INCORPORATED 6288 AP 2,142.46 13,491.40 IDEXX DISTRIBUTION, INC 6286 AP 552.67 14,044.07 HACH COMPANY 6301 AP 1,968.83 16,012.90 IDEXX DISTRIBUTION, INC 6304 AP 257.28 16,270.18 HACH COMPANY 6339 AP 1,080.00 17,350.18 HUTHER AND ASSOCIATES,INC AP (1,080.00) 16,270.18 HUTHER AND ASSOCIATES,INC AP Totals: 1_ 3,729.82 Remaining 81 % Used Capital Outlays 932 03/16/2020 March A/P Inplant water system WWTP 160,027.89 1,389.11 161,417.00 Halff Associates, INC 6285 AP 932 03/16/2020 March A/P Auma Actuator 1,725.00 163,142.00 Municipal Valve & Equipment Co 6290 AP 1058 03/31/2020 March A?P LS upgrades 9,396.00 172,538.00 DHS AUTOMATION, INC AP Account: 135-69005-020-000 Capital Outlays 530,500.00 Budgeted 357,962.00 Remaining 33 % Used Account: 135-69008-020-000 Short Term Debt -Principal 59,604.74 Account: 135-69008-020-000 Short Term Debt -Principal 79,133.00 Budgeted 19,528.26 Remaining 75 % Used .00 59,604.74 Account: 135-69009-020-000 Account: 135-69009-020-000 Short Term Debt -Interest 11,277.00 Budgeted 5,154.97 Remaining 6,122.03 54 % Used 00 6,122.03 Account: 135-69195-020-000 Gasb34/Reserve for Replacement 130,000.00 Account: 135-69195-020-000 Gasb34/Reserve for Replacement Totals: 1 130,000.00 Budgeted .00 Remaining Department 20 Totals: 100 % Used .00 130,000.00 1,394,137.17 •• 159,346.17 Monthly Total 3,157,421.00 Budgeted 1,763,283.83 Remaining 44 % Used 85 of 149 April 20, 2020 Complete Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-026-0 Workman's Compensation 71 03/01/2020 lneurance/Wrk Comp Expense Mar 9.95 Acil Workman's Compensation Total 30.00 Budgeted 18.06 Remaining 40 % Used Account: 135-60066-026-000 ■ Publications/Books/Subscripts Account: 135-60066-026-000 . Publications/Books/Subscripts Totals: 150.00 Budgeted 150.00 Remaining 1.99 11.94 GL 1 .00 .00 0 % Ueed Account: 135-60070-026-000 Account: 135-60070-026-000 Dues & Memberships 675.00 Dues & Memberships Total= 750.00 Budgeted 75.00 Remaining .00 90 % Ueed 675.00 Account: 135-60075-026-000 Account: 135-60075-026-000 Meetings Account: 135-60080-026-000 Account: 135-60080-026-000 Account: 135-60100-026-000 Account: 135-60100-026-000 Meeting. 1,300.00 Budgeted 1,123.72 Remaining 176.28 14 Used 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Travel & per diem Travel & per diem Totals: 5,000.00 Budgeted 5,000.00 Remaining 0 % Used .00 .00 176.28 .00 .00 .00 Account: 135-60245-026-000 Miscellaneous Expenses 86 of 149 April 20, 2020 Complete Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Department 26 Totals: 863.22 ** 1.99 Monthly Total 13,230.00 Budgeted 87 of 149 12,366.78 Remaining 7 % Used glpdatb2 skrolczyk 12:48 04/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 3/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) April 20, 2020 Complete Agenda Packet Check Source Number 88 of 149 Account: 135-50005-030-000 Salaries & Wages 843 03/06/2020 933 03/20/2020 MUD MUD Payroll Payroll 2/16/20-2/29/20 Salaries & Wages 3/20/2020 Salaries & Wages 149,265.50 14,122.33 15,101.60 163,387.83 178,489.43 PR PR Account: 135-50005-030-000 Salaries & Wages Totals: 29,223.93 178,489.43 ** 628,298.00 Budgeted 449,808.57 Remaining 28 5 Used Account: 135-50010-030-000 Overtime 933 03/20/2020 MUD Payroll 3/20/2020 Overtime 20.53 11.24 31.77 PR Account: 135-50010-030-000 Overtime Totals: 11.24 31.77 ** 2,000.00 Budgeted 1,968.23 Remaining 2 % Used Account: 135-50016-030-000 Longevity 2,207.50 .00 2,207.50 Account: 135-50016-030-000 Longevity Totals: .00 2,207.50 ** 2,208.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 843 03/06/2020 933 03/20/2020 MUD MUD Payroll Payroll 2/16/20-2/29/20 Retirement 3/20/2020 Retirement 15,524.98 1,307.73 1,399.45 16,832.71 18,232.16 PR PR Account: 135-50020-030-000 Retirement Totals: 2,707.18 18,232.16 ** 58,554.00 Budgeted 40,321.84 Remaining 31 % Used Account: 135-50026-030-000 Medical Insurance 843 03/06/2020 933 03/20/2020 MUD MUD Payroll Payroll 2/16/20-2/29/20 Medical Insurance 3/20/2020 Medical Insurance 29,157.97 3,172.91 3,172.86 32,330.88 35,503.74 PR PR Account: 135-50026-030-000 Medical Insurance Totals: 6,345.77 35,503.74 ** 124,394.00 Budgeted 88,890.26 Remaining 29 % Used Account: 135-50027-030-000 Dental Insurance 843 03/06/2020 933 03/20/2020 MUD MUD Payroll Payroll 2/16/20-2/29/20 Dental Insurance 3/20/2020 Dental Insurance 1,618.70 174.88 174.87 1,793.58 1,968.45 PR PR Account: 135-50027-030-000 Dental Insurance ■ Totals: 349.75 1,968.45 ** 6,464.00 Budgeted 4,495.55 Remaining 30 % Used 88 of 149 glpdatb2 skrolczyk 12:48 04/15/20 Fund: 135 MUD 1 General Fund ACCO JE JE JE Number Date Description 002: -030 - Account: 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 933 03/20/2020 MUD Payroll 3/20/2020 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Program: Period Ending: 3/2020 JE Detail Description/Comment Inc Vision Insurance Vision Insurance Bion Insuranc> 1,035.00 Budgeted Account: 135-50029-030-000 ffirimTesurance & Other 812 03/01/2020 March Payroll Benefits Employee Benefits AC 812 03/01/2020 March Payroll Benefits 966 03/23/2020 March A/P 1063 03/31/2020 March A/P Employee LTD & STD Caf 125 Caf 125 Life Insurance & Other 4,500.00 Budgeted April 20, 2020 Complete Agenda Packet Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) 249.67 25.85 275.52 PR 25.83 301.35 PR Totals: i 733.65 Remaining 29 % Used 1,635.45 176.22 1,811.67 Humana Inc 6223 AP 151.69 1,963.36 METLIFE GROUP BENEFITS 6231 AP 16.00 1,979.36 BenefitMall 6295 AP 16.00 1,995.36 BenefitMall AP 2,504.64 Remaining 44 % Used Social Security Ta� 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Social Security Taxes 933 03/20/2020 MUD Payroll 3/20/2020 Social Security Taxes Account: 135 Social Security Taxes 39,215.00 Budgeted Accoun Medicare Taxes 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 933 03/20/2020 MUD Payroll 3/20/2020 Medicare Taxes Medicare Taxes 8,790.85 805.46 9,596.31 PR 863.71 10,460.02 PR 28,754.98 Remaining 27 % Used Acwu,ac: i.ao-3 35-03 - Medicare Taxes Totals: 9,171.00 Budgeted Account: 135-50040-030-000 Unemployment Taxes 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Unemployment Taxes 933 03/20/2020 MUD Payroll 3/20/2020 Unemployment Taxes 2,055.95 188.39 2,244.34 PR 201.98 2,446.32 PR 6,724.68 Remaining 27 % Used 46.66 3.28 49.94 PR 793.89 843.83 PR Account Unemployment Taxes Totals: 1,440.00 Budgeted 596.17 Remaining 59 % Used Account: 135-50045-030-000 Workman's Compensation 89 of 149 glpdatb2 skrolczyk 12:48 04/15/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 71 03/01/2020 Insurance/Wrk Comp Expense Mar Account: 135-50045-030-000 Account: 135-50060-030-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 3/2020 JE Detail Beginning Balance Description/Comment 111an'e Compensation Wotale: i 1,775.00 Budgeted 1,146.08 Remaining Account: 135-50060-030-000 Account: 135-50070-030-000 Account: 135-50070-030-000 Pre-emp Physicals/Testing Pre-emp Physicals/Testing 500.00 Budgeted 500.00 Remaining Employee Relate= Employee Relations 8,000.00 Budgeted 4,921.90 Remaining 524.10 3,078.10 Program: Transaction Detail 104.82 35 % Used 0 % Used 38 % Used 10 .00 .00 Transaction Vendor Name Detail (SUBTOTAL) 628.92 .00 3,078.10 April 20, 2020 Complete Agenda Packet Check Source Number GL Account: 135 Software & Support Check scanner maintenance internet-March Microsoft exchange Camera van support plan Internet internet Internet Adobe program Server support Annual license renewal 923 03/12/2020 March A/P 932 03/16/2020 March A/P 934 03/16/2020 March A/P 966 03/23/2020 March A/P 1001 03/26/2020 PCards 2/27/2020-3/26/2020 1001 03/26/2020 PCards 2/27/2020-3/26/2020 1001 03/26/2020 PCards 2/27/2020-3/26/2020 1001 03/26/2020 PCards 2/27/2020-3/26/2020 1058 03/31/2020 March A?P 1058 03/31/2020 March A?P 126,842.65 Account Software & Support Totals: 134,681.00 Budgeted 3,004.42 Remaining Account: 932 03/16/2020 March A/P 932 03/16/2020 March A/P 1058 03/31/2020 March A?P Independent Labor GM contract -February GM contract -February GM -March hours 135,000.00 Budgeted 98 % Ueed 54,584.49 Totals: 77,799.98 Remaining 42 % Ueed 90 of 149 425.00 127,267.65 899.00 128,166.65 494.00 128,660.65 1,250.00 129,910.65 42.37 129,953.02 42.37 129,995.39 53.91 130,049.30 36.78 130,086.08 130.50 130,216.58 1,460.00 131,676.58 1,700.00 15.53 900.00 TECHNIQUE DATA SYSTEMS INC Charter Communications M3 Networks Cues Inc ATT*BILL PAYMENT ATT*BILL PAYMENT ATT*SILL PAYMENT ADOBE ACROPRO SUBS SW INC Data Management Inc. 56,284.49 Carman Consulting LLC. 56,300.02 Carman Consulting LLC. 57,200.02 Carman Consulting LLC. 6275 AP 6283 AP 6289 AP 6299 AP PC PC PC PC AP AP 6282 AP 6282 AP AP April 20, 2020 Complete Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55080-030-000 Account: 135-55080-030-000 Maintenance & Repairs 111 Maintenance & Repairs Totals: 15,000.00 Budgeted 1,165.00 13,835.00 Remaining 8 % Used Account: 135-55085-030-00: Generator Maint. and Repair Accoun Generator Maint. and Repair Totals: 10,000.00 Budgeted 9,469.00 Remaining Account: 135-55120-030-000 - Cleaning Service 966 03/23/2020 March A/P janitorial svc-february Account: 135-55120-030-00- Cleaning Services 10,000.00 Budgeted Account: 135-55160-030-000 974 03/24/2020 March A/P Account: 135-55160-030-000 Account: 135-55205-03' 923 03/12/2020 March A/P 1058 03/31/2020 March A?P Account: 135-55205-030-0191 531.00 3,476.24 .00 1,165.00 .00 531.00 4,345.30 5 % Used 5,654.70 Remaining 43 % Used Professional Outside Services FY 20 Winter avg rate revision Professional Outside Sery 65,600.00 Budgeted 63,100.00 Remaining 4 % Used ater billings -February 869.06 869.06 MEMBER'S BUILDING MAINTENANCE 6309 AP 2,500.00 2,500.00 NEW GEN STRATEGIES & SOLUTIONS 6311 AP 2,500.00 2,474.81 588.05 Water billings -March 579.18 Utility Billing Contract ' Totals: 9,000.00 Budgeted 5,357.96 Remaining Account: 135-60005-030-000 966 03/23/2020 March A/P Answering service -March 1001 03/26/2020 PCards 2/27/2020-3/26/2020 phone 1001 03/26/2020 PCards 2/27/2020-3/26/2020 phone 1001 03/26/2020 PCards 2/27/2020-3/26/2020 phone 1001 03/26/2020 PCards 2/27/2020-3/26/2020 Answering service 1028 03/31/2020 Town Billed Invoices 1730-1733 AR 20200331-20200331 User: 40 5 Used 3,062.86 DATAPROSE LLC 6256 AP 3,642.04 DATAPROSE LLC AP 7,399.55 194.75 7,594.30 KEYSTONE PARK SECRETARIAL 6306 AP 805.99 8,400.29 ATT*BUS PHONE PMT PC 468.11 8,868.40 ATT*BUS PHONE PMT PC 176.78 9,045.18 ATT*SILL PAYMENT PC 14.99 9,060.17 RINGCENTRAL, INC PC (180.00) 8,880.17 AR 91 of 149 glpdatb2 skrolczyk 12:48 04/15/20 Fund: 135 MUD 1 General Fund Account JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Program: Period Ending: 3/2020 JE Detail Description/Comment April 20, 2020 Complete Agenda Packet Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) Telephone 23,680.00 Budgeted 14,799.83 Remaining Communications/Mobiles 923 03/12/2020 March A/P Cell phones -March 933 03/20/2020 MUD Payroll 3/20/2020 Communications/Mobiles Account: 135-600 Communications/Mobiles 4,000.00 Budgeted ACCou 11 Electricity/ 923 03/12/2020 March A/P Gexa energy 1/10-2/10 2,572.69 Remaining Electricity 6,879.00 Budgeted 4,125.19 Remaining Account: 135-60025-030-00 Wat 1028 03/31/2020 Town Billed Invoices 1730-1733 AR 20200331-20200331 User: Account: 135-60025-030-00 1,500.00 Budgeted 1,242.18 Account: 135-60035-030-000 923 03/12/2020 March A/P water billings -February 1001 03/26/2020 PCarde 2/27/2020-3/26/2020 FedEx 1058 03/31/2020 March A?P Water billings -March Aocoun Account: 1 1045 03/31/2020 Pace Credit Card Fees 1045 03/31/2020 Pace Credit Card Fees 1045 03/31/2020 Pace Credit Card Fees 1045 03/31/2020 Pace Credit Card Fees 1058 03/31/2020 March A?P 1058 03/31/2020 March A?P Postage 30,000.00 Budgeted Service Charges & Fees Remaining 38 % Ueed 1,189.56 87.75 1,277.31 VERIZON WIRELESS 150.00 1,427.31 2,000.54 383.89 6,806.80 36 % Used 753.27 40 % Used 17 % Used Totals: 19,846.43 Remaining 34 % Ueed Dig Tess -march Direct send fees -March (126.07) 1,675.51 10.94 1,660.32 2,753.81 TOWN OF TROPHY CLUB 257.82 8,482.31 DATAPROSE LLC 8,493.25 FEDEX 91716198 10,153.57 DATAPROSE LLC 6281 AP 6278 PR AP 6256 AP PC AP 31,422.04 1,930.13 33,352.17 GL 33.52 33,385.69 GL 2,982.87 36,368.56 GL 65.22 36,433.78 GL 239.40 36,673.18 Texas Excavation Safety System AP 50.00 36,723.18 Fisery Solutions, LLC AP 92 of 149 April 20, 2020 Complete Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) ACC Account - Account Service Charges & Fees Totals: 67,000.00 Budgeted 30,276.82 Remaining 55 5 Used Bad Debt Expense Bad Debt Expense 1,500.00 Budgeted Insurance 71 03/01/2020 Insurance/Wrk Comp Expense Mar Account: 135 - In Account: 135-60066-030-000 Account: 135-60066-030-000 Account: 135-60070-030-000 Account: 135-60070-030-000 84,000 00 Budgeted Totals: J111111- 1,500.00 Remaining 0 % Used 45,571 Publications/Books/Subscripts 52 Remaining Publications/Books/Subscripts 1,000.00 Budgeted 875.00 Remaining Dues & Memberships Dues & Memberships 6,000.00 Budgeted Acci075-039 Meetings 1001 03/26/2020 PCards 2/27/2020-3/26/2020 donuts Account: 135 400.00 Budgeted Public Education - 1001 03/26/2020 PCards 2/27/2020-3/26/2020 voting staff lunch 31,430.09 125.00 4,285.55 46 Used 13 % Used 5,301 .00 .00 6,998.39 38,428.48 .00 125.00 .00 4,285.55 115.09 SQ *CK NDD INC PC 1,714.45 Remaining 71 % Used 61.37 53.72 284.91 Remaining 29 % Used GL 3,809.69 161.82 3,971.51 PANERA BREAD #601996 93 of 149 PC April 20, 2020 Complete Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60079-030-0011111111111 Public Education Tot- 6,000.00 Budgeted 2,028.49 Remaining ACC 0018 & Training 66 % Ueed 1001 03/26/2020 PCards 2/27/2020-3/26/2020 SHRM membership 1,163.21 219.00 1,382.21 SOCIETYFORHUMANRESOURC Account: 135-60080-030-00 Schools & Training Totals: 6,850.00 Budgeted 5,467.79 Remaining 20 5 Used Account Travel & per diem 843 03/06/2020 MUD Payroll 2/16/20-2/29/20 Travel & per diem 695.14 19.02 714.16 Account: 135- - - ravel & per diem Totals: Account: 135-60110-030-000 INF- A080unt: 135-60110-030-000 Account: 135-60115-030-000 Account: 135-60115-030-000 Account: 135-60125-030-000 1058 03/31/2020 March A?P Account: 135 3,545.00 Budgeted Physicals/Testing Physicals/Testing 200.00 Budgeted Election .00 Budgeted Advertising RFP Auditor 2,500.00 Budgeted 2,830.84 Remaining 20 % Ueed 200.00 Remaining 0 % Used 138.04 .00 .00 .00 138.04 (138.04) Remaining 0 5 Used Account: 135-60235-030-000 932 03/16/2020 March A/P monitoring svc-march 727.80 Remaining 71 138.04 *• PC PR 1,772.20 1,772.20 Star -Telegram Media AP Used 20 120.00 24.00 144.00 Digital Air Control, Inc 94 of 149 6284 AP glpdatb2 skrolczyk 12:48 04/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Program: Period Ending: 3/2020 Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment April 20, 2020 Complete Agenda Packet Check Source Number 966 03/23/2020 March A/P office supplies 95 of 149 74.11 2,132.26 OFFICE DEPOT, INC 6312 AP Account: 135-60235-030-000 Security Totals: 24.00 144.00 ** 1,288.00 Budgeted 1,144.00 Remaining 11 5 Used Account: 135-60245-030-000 Miscellaneous Expenses .00 .00 Account: 135-60245-030-000 Miscellaneous Expenses Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 5 Used Account: 135-60246-030-000 General Manager Contingency .00 .00 Account: 135-60246-030-000 General Manager Contingency Totals: .00 .00 ** 17,000.00 Budgeted 17,000.00 Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 .00 .00 Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 5 Used Account: 135-65010-030-000 Uniform .00 .00 Account: 135-65010-030-000 Uniforms Totals: .00 .00 ** 2,050.00 Budgeted 2,050.00 Remaining 0 % Used Account: 135-65055-030-000 Hardware 3,235.24 .00 3,235.24 Account: 135-65055-030-000 Hardware Totals: .00 3,235.24 ** 26,485.00 Budgeted 23,249.76 Remaining 12 % Used Account: 135-65085-030-000 Office Supplies 932 03/16/2020 March A/P office supplies 2,002.24 55.91 2,058.15 OFFICE DEPOT, INC 6291 AP 966 03/23/2020 March A/P office supplies 95 of 149 74.11 2,132.26 OFFICE DEPOT, INC 6312 AP April 20, 2020 Complete Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1001 03/26/2020 PCards 2/27/2020-3/26/2020 986 03/30/2020 March A/P 986 03/30/2020 March A/P reciept book 2,002.24 6.66 2,138.92 AMAZON.COM*IF3HB6OC3 PC office supplies 26.34 2,165.26 OFFICE DEPOT, INC 6341 AP office supplies 34.99 2,200.25 OFFICE DEPOT, INC 6341 AP Account: 135-65085-030-000 Office Supplies Totals: 198.01 2,200.25 ** 6,000.00 Budgeted 3,799.75 Remaining 37 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance .00 .00 Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-65095-030-000 Maintenance Supplies 1001 03/26/2020 PCards 2/27/2020-3/26/2020 trash bags 2,698.80 26.99 2,725.79 AMZN MKTP US*AW2T28EC3 PC 1001 03/26/2020 PCards 2/27/2020-3/26/2020 thermometer 42.95 2,768.74 WM SUPERCENTER #5247 PC 1001 03/26/2020 PCards 2/27/2020-3/26/2020 coffee 28.72 2,797.46 AMAZON.COM*BK3736783 PC 1001 03/26/2020 PCards 2/27/2020-3/26/2020 candy, soap 12.17 2,809.63 WAL-MART 85247 PC Account: 135-65095-030-000 Maintenance Supplies Totals: 110.83 2,809.63 ** 4,000.00 Budgeted 1,190.37 Remaining 70 % 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 932 03/16/2020 March A/P TC MUD Boundary update 47.39 2,867.91 2,915.30 Halff Associates, INC 6285 AP Account: 135-69005-030-000 Capital Outlays Totals: 2,867.91 2,915.30 ** 195,000.00 Budgeted 192,084.70 Remaining 1 % Used Account: 135-69170-030-000 Copier Lease Installments 923 03/12/2020 March A/P copier lease -march 1,271.47 165.00 1,436.47 TIAA COMMERCIAL FINANCE 6276 AP 974 03/24/2020 March A/P copies 109.86 1,546.33 KYOCERA DOCUMENT SOLUTIONS 6307 AP 96 of 149 glpdatb2 skrolczyk 12:48 04/15/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Program: Period Ending: 3/2020 Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment April 20, 2020 Complete Agenda Packet Check Source Number Account: 135-69170-030-000 Copier Lease Installments Totals: 274.86 1,546.33 ** 4,000.00 Budgeted 2,453.67 Remaining 39 5 Used Department 30 Totals: 77,689.98 Monthly Total 581,225.74 ** 1,776,712.00 Budgeted 1,195,486.26 Remaining 33 5 Used 97 of 149 April 20, 2020 Complete Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55045-039-000 Legal 923 03/12/2020 March A/P 923 03/12/2020 March A/P 932 03/16/2020 March A/P 1058 03/31/2020 March A?P legal legal travel Westlake easment legal 56,702.39 5,590.00 1,050.00 13,935.00 5,687.50 62,292.39 McLean & Howard, L.L.P. 63,342.39 McLean & Howard, L.L.P. 77,277.39 WHITAKER CHALK SWINDLE 82,964.89 McLean & Howard, L.L.P. 6269 AP 6269 AP 6293 AP AP Account: 135-55045-039-000 Legal Totals: 26,262.50 82,964.89 ** 135,000.00 Budgeted 52,035.11 Remaining 61 % Used Account: 135-55055-039-000 Auditing 27,713.27 .00 27,713.27 Account: 135-55055-039-000 Auditing Totals: .00 27,713.27 ** 33,800.00 Budgeted 6,086.73 Remaining 82 % Used Account: 135-55060-039-000 Appraisal 891 03/05/2020 March A/P 2nd qtr 2020 appraisel/DCAD 5,178.56 2,243.48 7,422.04 DENTON CENTRAL APPRAISAL DISTR 6257 AP Account: 135-55060-039-000 Appraisal Totals: 2,243.48 7,422.04 ** 11,761.00 Budgeted 4,338.96 Remaining 63 % Used Account: 135-55065-039-000 Tax Admin Fees 3,756.00 .00 3,756.00 Account: 135-55065-039-000 Tax Admin Fees Totals: .00 3,756.00 ** Department 39 Totals: Fund 135 Totals: 4,000.00 Budgeted 28,505.98 Monthly Total 244.00 Remaining 94 % Used 121,856.20 ** 184,561.00 Budgeted 62,704.80 Remaining 66 % Used 55,896.27 (97,751.98) Monthly Total (6,224.00) Budgeted (62,120.27) Remaining ########## 98 of 149 glpdatb2 skrolczyk 12:48 04/15/20 Fund: 137 MUD 1 Consolidated GASB JE JE JE Number Date Description Department: JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 3/2020 Beginning Balance Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) April 20, 2020 Complete Agenda Packet Check Source Number Department Totals: Fund 137 Totals: .00 Monthly Total .00 Monthly Total .00 Budgeted .00 Budgeted 99 of 149 (286,420.00) ** 286,420.00 Remaining 0 5 Used (286,420.00) 286,420.00 Remaining 0 % Used Account: 137-49145-000-000"IIII Intergov Transfer -General Fund (205,000.00) .00 (205,000.00) Account: 137-49145-000-000 Intergov Transfer -General Fund Totals: .00 (205,000.00) ** .00 Budgeted 205,000.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer -Fire Dept (81,420.00) .00 (81,420.00) Account: 137-49146-000-000 Intergov Transfer -Fire Dept Totals: ; .00 (81,420.00) ** .00 Budgeted 81,420.00 Remaining 0 5 Used Department Totals: Fund 137 Totals: .00 Monthly Total .00 Monthly Total .00 Budgeted .00 Budgeted 99 of 149 (286,420.00) ** 286,420.00 Remaining 0 5 Used (286,420.00) 286,420.00 Remaining 0 % Used April 20, 2020 Complete Agenda Packet TROPHY CLUB MUD NO. 1 - WWTP TAX BOND CONST BALANCE SHEET MARCH 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE Q/ u TROPHY CLUB MUNICIPAL UTILITY DISTRICT 517 TAX BOND CONSTRUCTION 524,254 TOTAL ASSETS 524,254 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 685,477 TOTAL LIABILITIES 685,477 FUND BALANCE ASSIGNED FUND BALANCE (118,410) NET REVENUES / EXPENDITURES (42,813) TOTAL FUND BALANCE (161,223) TOTAL LIABILITIES AND FUND BALANCE 524,254 100 of 149 April 20, 2020 Complete Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 12:47 04/15/20 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 3/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1 517-49011-000-000 Interest Income 460.49- 4,498.62- 4,498.62 Subtotal: 460.49- 4,498.62- 4,498.62 Program number: 460.49- 4,498.62- 4,498.62 Department number: Revenues 460.49- 4,498.62- 4,498.62 Revenues Subtotal ` 460.49- 4,498.62- 4,498.62 101 of 149 glbase_tbam skrolczyk 12:47 04/15/20 Fund: 517 2014 MUD 1 Tax Bond Const WWTP Account 1 517-69005-020-000 Description Capital Outlays Trophy Club MUD No.1 Budget Summary with Amendment Department: 20 Wastewater Period Ending: 3/2020 Adopted Amended Total Current Budget Budget Encumb. Month 12,140.00 Program: YTD Total 47,311.41 April 20, 2020 Complete Agenda Packet % of Remaining Budget Budget 47,311.41 - 102 of 149 Subtotal: 12,140.00 47,311.41 47,311.41 - Program number: 1.I. 12,140.00 47,311.41 47,311.41 - Department number: Wastewater ` 12,140.00 47,311.41 47,311.41 - Expenditures Subtotal 12,140.00 47,311.41 47,311.41 - Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 11,679.51 42,812.79 42,812.79- 102 of 149 April 20, 2020 Complete Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-49011-000-000 1047 03/31/2020 Bank Interest- March Interest Income (4,038.13) (460.49) (4,498.62) GL Account: 517-49011-000-000 Interest Income Total (460.49) (4,498.62) ** .00 Budgeted 4,498.62 Remaining 0 % Used Department Totals: (4,498.62) ** (460.49) Monthly Total .00 Budgeted 103 of 149 4,498.62 Remaining 0 % Used April 20, 2020 Complete Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-69005-020-000 Mr - 923 03/12/2020 March A/P 974 03/24/2020 March A/P Capital Outlays J WWTP legal WWTP legal 35,171.41 1,190.00 10,950.00 Account: - Capital Outlays Totals: .00 Budgeted (47,311.41) Remaining 0 % Used 36,361.41 Dubois Bryant Campbell LLP 6259 AP 47,311.41 CP&Y/WALLACE GROUP, INC. 6298 AP Department 20 Totals: 47,311.41 ** 12,140.00 Monthly Total .00 Budgeted (47,311.41) Remaining 0 % Used Fund 517 Totals: 42,812.79 11,679.51 Monthly Total .00 Budgeted 104 of 149 (42,812.79) Remaining 0 % Used April 20, 2020 Complete Agenda Packet TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET MARCH 2020 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 784,703 TOTAL ASSETS 784,703 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 105 of 149 81,691 81,691 698,648 4,364 703,012 784,703 glbase_tbam skrolczyk 12:47 04/15/20 Fund: 519 2016 Rev Bond Const -SWIFT Account 1 519-49011-000-000 Description Interest Income Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Period Ending: 3/2020 Adopted Amended Total Current Budget Budget Encumb. Month 612.47 - Program: YTD Total 4,364.30 - April 20, 2020 Complete Agenda Packet % of Remaining Budget Budget 4,364.30 106 of 149 Subtotal: 612.47- 4,364.30- 4,364.30 Program number: 612.47- 4,364.30- 4,364.30 Department number: Revenues 612.47- 4,364.30- 4,364.30 Revenues Subtotal ._ 612.47- 4,364.30- 4,364.30 Fund number: 519 2016 Rev Bond Const -SWIFT 612.47- 4,364.30- 4,364.30 106 of 149 April 20, 2020 Complete Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const -SWIFT Department: Revenues Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 519-49011-000-000 1047 03/31/2020 Bank Interest- March Interest Income (3,751.83) (612.47) (4,364.30) GL Account: 519-49011-000-000 Interest Income Totals: Department Totals: .00 Budgeted 4,364.30 Remaining 0 % Used (612.47) Monthly Total .00 Budgeted (4,364.30) ** 4,364.30 Remaining 0 % Used Fund 519 Totals: (4,364.30) (612.47) Monthly Total .00 Budgeted 107 of 149 4,364.30 Remaining 0 % Used TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET MARCH 2020 April 20, 2020 Complete Agenda Packet TROPHY CLUB 1 MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND CASH IN BANK 448,915 INVESTMENTS 3,891,217 ACCOUNTS RECEIVABLE TOTAL ASSETS 4,340,132 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 108 of 149 4,454,290 (114,158) 4,340,132 4,340,132 April 20, 2020 Complete Agenda Packet glbase_tbam skrolczyk Trophy Club MUD No.1 12:47 04/15/20 Budget Summary with Amendment Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 3/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1 520-49011-000-000 Interest Income 3,504.93- 26,133.94- 26,133.94 Subtotal: 3,504.93- 26,133.94- 26,133.94 Program number: 3,504.93- 26,133.94- 26,133.94 Department number: 3,504.93- 26,133.94- 26,133.94 Revenues Subtotal ` 3,504.93- 26,133.94- 26,133.94 109 of 149 glbase_tbam skrolczyk 12:47 04/15/20 Fund: 520 Revenue Bond 16" Waterline Account 1 520-69005-010-000 Description Capital Outlays Trophy Club MUD No.1 Budget Summary with Amendment Department: 10 Water Department Period Ending: 3/2020 Adopted Amended Total Current Budget Budget Encumb. Month 14,853.95 Program: YTD Total 140,292.71 April 20, 2020 Complete Agenda Packet % of Remaining Budget Budget 140,292.71 - 110 of 149 Subtotal: 14,853.95 140,292.71 140,292.71 - Program number: 1.I. 14,853.95 140,292.71 140,292.71 - Department number: Water Department ` 14,853.95 140,292.71 140,292.71 - Expenditures Subtotal 14,853.95 140,292.71 140,292.71 - Fund number: 520 Revenue Bond 16" Waterline 11,349.02 114,158.77 114,158.77- 110 of 149 April 20, 2020 Complete Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 520-49011-000-0 1047 03/31/2020 Bank Interest- March 1047 03/31/2020 Bank Interest- March Account: 520-490 Interest Income Interest Income Totals: .00 Budgeted (22,629.01) (467.79) (23,096.80) GL (3,037.14) (26,133.94) GL 26,133.94 Remaining 0 % Used Department Totals: (26,133.94) ** (3,504.93) Monthly Total .00 Budgeted 111 of 149 26,133.94 Remaining 0 % Used April 20, 2020 Complete Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 520-69005-010-000 Mr - 923 03/12/2020 March A/P 932 03/16/2020 March A/P 932 03/16/2020 March A/P Capital Outla Easement fee -title 125,438.76 940.00 16" water line easement 624.09 easement legal 13,289.86 Capital Outla .00 Budgeted (140,292.71) Remaining 0 % Used 11 126,378.76 Community National Title LLC 127,002.85 Halff Associates, INC 140,292.71 Jackson Walker LLP Department 10 Totals: 140,292.71 •• 14,853.95 Monthly Total .00 Budgeted (140,292.71) Remaining 0 % Used Fund 520 Totals: 114,158.77 11,349.02 Monthly Total .00 Budgeted (114,158.77) Remaining 0 % Used 112 of 149 6253 AP 6285 AP 6287 AP TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET MARCH 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE April 20, 2020 Complete Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 872,080 TOTAL ASSETS 872,080 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 113 of 149 803,457 68,623 872,080 872,080 April 20, 2020 Complete Agenda Packet glbase_tbam skrolczyk Trophy Club MUD No.1 12:47 04/15/20 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 3/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49011-000-000 Interest Income 11,000.00- 11,000.00- 734.06- 6,523.06- 59.301 4,476.94- 528-49142-000-000 Interfund transfer in -Water 307,049.00- 307,049.00- 4,600.00- 27,600.00- 8.989 279,449.00- 528-49143-000-000 Interfund transfer in -WW 200,417.00- 200,417.00- 5,750.00- 34,500.00- 17.214 165,917.00- Subtota1: m 518,466.00- 518,466.00- 11,084.06- 68,623.06- 111111 449,842.94 - Program number: 518,466.00- 518,466.00- 11,084.06- 68,623.06- 1111236 449,842.94 - Department number: 518,466.00- 518,466.00- 11,084.06- 68,623.06- 13.236 449,842.94 - Revenues Subtotal 518,466.00- 518,466.00- 11,084.06- 68,623.06- 13.236 449,842.94 - Fund number: 528 2015 Revenue Bond Reserve Fund 518,466.00- 518,466.00- 11,084.06- 68,623.06- 13.236 449,842.94- 114 of 149 glpdatb2 skrolczyk 12:48 04/15/20 Fund: 528 2015 Revenue Bond Reserve Fund JE JE JE Number Date Description Account: 528-49011-000-000 1047 03/31/2020 Bank Interest- March Department: JE Detail Description/Comment Interest Income Trophy Club MUD No.1 Detailed Accounting Trial Balance Program: April 20, 2020 Complete Agenda Packet Period Ending: 3/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 528-49011-000-000 come 1 i (11,000.00) Budgeted (4,476.94) Remaining Account: 528-49142-000-000 1046 03/30/2020 TexPool Transfers March TexPool O&M to Rev Bond Resevr (5,789.00) (734.06) (6,523.06) 59 % Used (23,000.00) Interfund transfer in -Wats (307,049.00) Budgeted (279,449.00) Remaining Interfund transfer in -WW 1046 03/30/2020 TexPool Transfers March TexPool O&M to Rev Bond Resevr Account: 528-49143-11Interfund transfer i (200,417.00) Budgeted (28,750.00) (165,917.00) Remaining (4,600.00) 9 % Used (5,750.00) 17 % Used (27,600.00) (34,500.00) Department Totals: (68,623.06) ** (11,084.06) Monthly Total (518,466.00) Budgeted (449,842.94) Remaining 13 % Used Fund 528 Totals: (68,623.06) (11,084.06) Monthly Total (518,466.00) Budgeted (449,842.94) Remaining 13 % Used 115 of 149 GL GL GL TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET MARCH 2020 ASSETS CASH IN BANK INVESTMENTS PREPAID EXPENSES ADVALOREM PROPERTY TAXES RECEIVABLE ACCOUNTS RECEIVABLE -OTHER TOTAL ASSETS LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 116 of 149 April 20, 2020 Complete Agenda Packet PAI TROPHY CLUB MUNICIPAL UTILITY DISTRICT INTEREST & SINKING- 533 923,693 24,375 948,068 24,375 24,375 82,954 840,739 923,693 948,068 April 20, 2020 Complete Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 12:47 04/15/20 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 3/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 533-40002-000-000 533-40015-000-000 Property Taxes Property Taxes/Delinquent Property Taxes/P & I 682,441.00- 1,000.00- 2,000.00- 682,441.00- 1,000.00- 2,000.00- 6,491.91- 251.43- 398.76- 679,203.89- 1,831.16- 1,403.58- 99.526 183.116 70.179 3,237.11- 831.16 596.42 - Subtotal: 7,142.10- 99.562 3,002.37- 533-49011-000-000 533-49015-000-000 533-49141-000-000 Interest Income Lease/Rental Income Interfund Trans In -PID Surchg 5,000.00- 218,004.00- 114,563.00- 5,000.00- 218,004.00- 114,563.00- 773.47- 10,414.81- 3,185.87- 218,004.00- 62,488.86- 63.717 100.000 54.545 1,814.13- 52,074.14- 1 Subtotal: 337,567.00- 337,567.00- 11,188.28- 283,678.73- 84.036 53,888.27 - Program number: 1,023,008.00- 1,023,008.00- 18,330.38- 966,117.36- 94.439 56,890.64 - Department number: Revenues 1,023,008.00- 1,023,008.00- 18,330.38- 966,117.36- 94.439 56,890.64 - Revenues Subtotal 1,023,008.00- 1,023,008.00- 18,330.38- 966,117.36- 94.439 56,890.64- 117 of 149 April 20, 2020 Complete Agenda Packet glbase_tbam skrolczyk Trophy Club MUD No.1 12:47 04/15/20 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 3/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1 1 533-70005-051-000 1 533-70025-051-000 1 533-70035-051-000 Payin$g Agent Fee Bond 2nterest Expense -Tax Bond Principal Payment -Tax 2,150.00 247,858.00 765,000.00 2,150.00 247,858.00 765,000.00 1,450.00 123,928.75 67.442 50.000 700.00 123,929.25 765,000.00 Subtotal: 1,015,008.00 1,015,008.00 125,378.75 12.352 889,11r.25 Program number: 1,015,008.00 1,015,008.00 125,378.75 12.352 889,629.25 Department number: Administration 1,015,008.00 1,015,008.00 125,378.75 12.352 889,629.25 Expenditures Subtotal 1,015,008.00 1,015,008.00 125,378.75 12.352 889,629.25 p Fund number: 533 MUD 1 I&S Consolidated 8,000.00- 8,000.00- 18,330.38- 840,738.61- ############### 832,738.61 118 of 149 glpdatb2 skrolczyk 12:48 04/15/20 Fund: 533 MUD 1 I&S Consolidated JE JE JE Number Date Description Account: 533-40000-000- 1024 03/02/2020 Property Taxes 1025 03/03/2020 Property Taxes 1026 03/04/2020 Property Taxes 1027 03/05/2020 Property Taxes 1029 03/06/2020 Property Taxes 1031 03/10/2020 Property Taxes 1032 03/11/2020 Property Taxes 1033 03/12/2020 Property Taxes 1034 03/13/2020 Property Taxes 1035 03/16/2020 Property Taxes 1036 03/17/2020 Property Taxes 1037 03/18/2020 Property Taxes 1038 03/19/2020 Property Taxes 1039 03/20/2020 Property Taxes 1040 03/23/2020 Property Taxes 1041 03/24/2020 Property Taxes 1042 03/31/2020 Property Taxes Account: 533-4000 d=r8,11 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 3/2020 JE Detail Beginning Transaction Transaction Vendor Name Description/Comment Balance Detail Detail (SUBTOTAL) Property Taxes (672,711.98) (523.48) (673,235.46) (87.27) (673,322.73) (644.07) (673,966.80) (92.80) (674,059.60) (976.98) (675,036.58) (24.80) (675,061.38) (254.34) (675,315.72) (19.76) (675,335.48) (347.95) (675,683.43) (283.07) (675,966.50) (558.33) (676,524.83) (301.08) (676,825.91) (339.92) (677,165.83) (138.40) (677,304.23) (334.99) (677,639.22) (274.16) (677,913.38) (1,290.51) (679,203.89) April 20, 2020 Complete Agenda Packet Check Source Number Property Taxes Totals: (682,441.00) Budgeted (3,237.11) Remaining 100 % Used Account: 533-40002-000-00 1025 03/03/2020 Property Taxes 1030 03/09/2020 Property Taxes 1033 03/12/2020 Property Taxes 1041 03/24/2020 Property Taxes 1042 03/31/2020 Property Taxes Property Taxes/Delinquent Account: 533-40002-000-0 Account: 533-40015-000-00' 1024 03/02/2020 Property Taxes 1025 03/03/2020 Property Taxes 1026 03/04/2020 Property Taxes 1027 03/05/2020 Property Taxes 1029 03/06/2020 Property Taxes 1030 03/09/2020 Property Taxes 1032 03/11/2020 Property Taxes 1033 03/12/2020 Property Taxes Property Taxes/Delinquent Totals: (1,000.00) Budgeted (1,579.73) (100.25) (1,679.98) (8.84) (1,688.82) (128.43) (1,817.25) (.01) (1,817.26) (13.90) (1,831.16) 831.16 Remaining 183 % Used GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL T GL GL GL GL GL Property Taxes/P & I (1,004.82) 119 of 149 (33.50) (1,038.32) (31.17) (1,069.49) (46.19) (1,115.68) (6.50) (1,122.18) (68.39) (1,190.57) (2.30) (1,192.87) (22.89) (1,215.76) (35.17) (1,250.93) GL GL GL GL GL GL GL GL April 20, 2020 Complete Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 3/2020 JE JE JB JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1034 03/13/2020 Property Taxes 1035 03/16/2020 Property Taxes 1036 03/17/2020 Property Taxes 1040 03/23/2020 Property Taxes 1041 03/24/2020 Property Taxes 1042 03/31/2020 Property Taxes (1,004.82) (31.31) (18.04) (28.10) (19.53) (16.51) (39.16) (1,282.24) (1,300.28) (1,328.38) (1,347.91) (1,364.42) (1,403.58) GL GL GL GL GL GL Account: 533-40015-000-000 Property Taxes/P & I ■ Totals: (398.76) (1,403.58) ** (2,000.00) Budgeted (596.42) Remaining 70 % Used Account: 533-49011-000-000 Interest Income 1047 03/31/2020 Bank Interest- March (2,412.40) (773.47) (3,185.87) GL Account: 533-49011-000-000 Interest Income Totals: (773.47) (3,185.87) ** (5,000.00) Budgeted (1,814.13) Remaining 64 % Used Account: 533-49015-000-000 Lease/Rental Income (218,004.00) .00 (218,004.00) Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (218,004.00) ** (218,004.00) Budgeted .00 Remaining 100 % Used Account: 533-49141-000-000 Interfund Trans In -PID Surchg 1046 03/30/2020 TexPool Transfers March TexPool O&M to I - PID Debt (52,074.05) (10,414.81) (62,488.86) GL Account: 533-49141-000-000 Interfund Trans In -PID Surchg Totals: (10,414.81) (62,488.86) ** Department Totals: (114,563.00) Budgeted (18,330.38) Monthly Total (52,074.14) Remaining 55 % Used (966,117.36) ** (1,023,008.00) Budgeted (56,890.64) Remaining 94 % Used 120 of 149 April 20, 2020 Complete Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-70005-051-000 Paying Agent Fee 1,450.00 .00 1,450.00 Account: 533-70005-051-000 Paying Agent Fee Totals: .00 1,450.00 ** 2,150.00 Budgeted 700.00 Remaining 67 % Used Account: 533-70025-051-000 Bond Interest Expense -Tax 123,928.75 .00 123,928.75 Account: 533-70025-051-000 Bond Interest Expense -Tax Totals: .00 123,928.75 ** 247,858.00 Budgeted 123,929.25 Remaining 50 % Used Account: 533-70035-051-000 Bond Principal Payment -Tax .00 .00 Account: 533-70035-051-000 Bond Principal Payment -Tax Totals: .00 .00 ** 765,000.00 Budgeted 765,000.00 Remaining 0 % Used Department 51 Totals: 125,378.75 ** .00 Monthly Total 1,015,008.00 Budgeted 889,629.25 Remaining 12 5 Used Fund 533 Totals: (840,738.61) (18,330.38) Monthly Total (8,000.00) Budgeted 832,738.61 Remaining ########## 121 of 149 April 20, 2020 Complete Agenda Packet TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET MARCH 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE Ep TROPHY CLUB i MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 247,837 TOTAL ASSETS 247,837 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 122 of 149 24,518 223,320 247,837 247,837 April 20, 2020 Complete Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 12:47 04/15/20 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 3/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49011-000-000 Interest Income 2,500.00- 534-49143-000-000 Interfund Transfer In -WW Sales 598,638.00- Subtot Program number: Department number: Revenues Revenues Subtotal 60I�0- 601 00- 6011'38.00- 601,138.00- 2,500.00- 598,638.00- 6011.38.00- 601,138.00- 601,138.00- 601,138.00- 123 of 149 166.33- 54,421.63- 587.96- 54,587.96- , 54,587.96- 1,109.24- 326,529.18- 327,638.42- 327,638.42- 327,638.42- 44.370 54.545 54.503 54.503 54.503 54.503 1,390.76- 272,108.82- 273,499.58- 273,499.58- 273,499.58- April 20, 2020 Complete Agenda Packet glbase_tbam skrolczyk Trophy Club MUD No.1 12:47 04/15/20 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 3/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-70005-051-000 Rev Bond Paying Agent Fee 400.00 400.00 200.00 50.000 200.00 1 534-70040-051-000 Revenue Bond Interest Expense 208,238.00 208,238.00 104,118.75 50.000 104,119.25 1 534-70045-051-000 Revenue Bond Principal Expense 390,000.00 390,000.00 390,000.00 1 I Subtotal: , 598,638.00 598,638.00 17.426 494,319.25 Program number: III 598,638.00 598,638.00 111111111 17.426 494,319.25 Department number: Administration III 598,638.00 598,638.00 10 17.426 494,31 Expenditures Subtotal ill 598,638.00 598,638.00 1011111:75 17.426 494,319.25 Fund number: 534 2015 Revenue Bond I&S M2,500.00- 2,500.00- 54,587.96- 2200.67- gilip32.787 220,819.67 124 of 149 glpdatb2 skrolczyk 12:48 04/15/20 Fund: 534 2015 Revenue Bond I&S JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 3/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) April 20, 2020 Complete Agenda Packet Check Source Number Department Totals: (54,587.96) Monthly Total (327,638.42) ** (601,138.00) Budgeted (273,499.58) Remaining 55 % Used 125 of 149 Account: 534-49011-000-000 Interest Income 1047 03/31/2020 Bank Interest- March (942.91) (166.33) (1,109.24) GL Account: 534-49011-000-000 Interest Income Totals: (166.33) (1,109.24) ** (2,500.00) Budgeted (1,390.76) Remaining 44 5 Used Account: 534-49143-000-000 Interfund Transfer In -WW Sales 1046 03/30/2020 TexPool Transfers March TexPool O&M to Rev Bd WWTP I&S (272,107.55) (54,421.63) (326,529.18) GL Account: 534-49143-000-000 Interfund Transfer In -WW Sales Totals: (54,421.63) (326,529.18) ** (598,638.00) Budgeted (272,108.82) Remaining 55 5 Used Department Totals: (54,587.96) Monthly Total (327,638.42) ** (601,138.00) Budgeted (273,499.58) Remaining 55 % Used 125 of 149 April 20, 2020 Complete Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond IES Department: 51 Administration Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-70005-051-000 Rev Bond Paying Agent Fee Account: 534-70005-051-000 11 Rev Bond Paying Agent Fee 400.00 Budgeted 200.00 Remaining Account: 534-70040-051-000 Revenue Bond Interest Expense Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: 208,238.00 Budgeted 104,119.25 Remaining 200.00 104,118.75 50 % Used .00 200.00 .00 104,118.75 50 % Used Account: 534-70045-051-000 Revenue Bond Principal Expense A,t: 534-70045-051-000 Revenue Bond Principal Expense Totals: 390,000.00 Budgeted 390,000.00 Remaining .00 .00 0 % Used Department 51 Totals: 104,318.75 ** .00 Monthly Total 598,638.00 Budgeted 494,319.25 Remaining 17 % Used Fund 534 Totals: (223,319.67) (54,587.96) Monthly Total (2,500.00) Budgeted 220,819.67 Remaining ########## 126 of 149 April 20, 2020 Complete Agenda Packet TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET MARCH 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 535 NSII FTW SWIFT REVENUE BOND I&S 125,471 TOTAL ASSETS 125,471 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 127 of 149 4,967 120,504 125,471 125,471 April 20, 2020 Complete Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 12:47 04/15/20 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 3/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-49011-000-000 535-49142-000-000 Interest Income 1,000.00- 1,000.00- Interfund Tran In -Water Sales 275,525.00- 275,525.00- Subtot Program number: Department number: Revenues Revenues Subtotal 25.00- 0- 276t25.00- 0- 276,525.00- 276,525.00- 276,525.00- 128 of 149 86.27- 25,047.72- 480.54- 150,286.32- 48.054 54.545 519.46- 125,238.68- 54.522 12 54.522 125 54.522 125,75 54.522 125,758.14- April 20, 2020 Complete Agenda Packet glbase_tbam skrolczyk Trophy Club MUD No.1 12:47 04/15/20 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 3/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-70005-051-000 Rev Bond Paying Agent Fee 800.00 800.00 200.00 25.000 600.00 535-70040-051-000 Revenue Bona Interest Expense 386,811.00 386,811.00 30,062.50 7.772 356,748.50 535-70045-051-000 Revenue Bond Principal Expense 215,000.00 215,000.00 215,000.00 Subtotal: ,111111102,611.00 602,611.00 30,262.50 5.022 572,348.50 Program number: _b02,611.00 602,611.00 30,262.50 5.022 572,348.50 Department number: Administration mEr 602,611.00 602,611.00 30,262.50 5.022 572,348.50 Expenditures Subtotal 602,611.00 602,611.00 30,262.50 5.022 572,348.50 Fund number: 535 2016 Rev Bond I&S-SWIFT 326,086.00 326,086.00 120,504.36- -36.955 446,590.36 129 of 149 glpdatb2 skrolczyk 12:48 04/15/20 Fund: 535 2016 Rev Bond I&S-SWIFT JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 3/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) April 20, 2020 Complete Agenda Packet Check Source Number Department Totals: (25,133.99) Monthly Total (150,766.86) ** (276,525.00) Budgeted (125,758.14) Remaining 55 % Used 130 of 149 Account: 535-49011-000-000 Interest Income 1047 03/31/2020 Bank Interest- March (394.27) (86.27) (480.54) GL Account: 535-49011-000-000 Interest Income Totals: (86.27) (480.54) ** (1,000.00) Budgeted (519.46) Remaining 48 5 Used Account: 535-49142-000-000 Interfund Tran In -Water Sales 1046 03/30/2020 TexPool Transfers March TexPool O&M to 16Swift Rev I&S (125,238.60) (25,047.72) (150,286.32) GL Account: 535-49142-000-000 Interfund Tran In -Water Sales Totals: W. (25,047.72) (150,286.32) ** (275,525.00) Budgeted (125,238.68) Remaining 55 5 Used Department Totals: (25,133.99) Monthly Total (150,766.86) ** (276,525.00) Budgeted (125,758.14) Remaining 55 % Used 130 of 149 April 20, 2020 Complete Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 535-70005-051-000 Account: 535-70005-051-000 11 Rev Bond Paying Agent Fee Rev Bond Paying Agent Fee 800.00 Budgeted 600.00 Remaining Account: 535-70040-051-000 Revenue Bond Interest Expense Account: 535-70040-051-000 Account: 535-70045-051-000 Revenue Bond Interest Expense Totals: 386,811.00 Budgeted 356,748.50 Remaining Revenue Bond Principal Expense Revenue Bond Principal Expense Totals: 215,000.00 Budgeted 215,000.00 Remaining 200.00 30,062.50 25 % Used .00 200.00 .00 30,062.50 8 % Used .00 .00 0 % Used Department 51 Totals: 30,262.50 ** .00 Monthly Total 602,611.00 Budgeted 572,348.50 Remaining 5 % Used Fund 535 Totals: (120,504.36) (25,133.99) Monthly Total 326,086.00 Budgeted 446,590.36 Remaining -37 % Used 131 of 149 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET MARCH 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE April 20, 2020 Complete Agenda Packet TROPHY CLUB MTJNICIPAL UTILITY IIISTRICT 536 REVENUE BOND SERIES 2019 I&S 23,281 TOTAL ASSETS 23,281 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES 23,281 TOTAL FUND BALANCE 23,281 TOTAL LIABILITIES AND FUND BALANCE 23,281 132 of 149 glbase tbam skrolczyk Trophy Club MUD No.1 12:47 04/15/20 Budget Summary with Amendment Fund: 536 2019 Rev Bond I&S- W&WW System Department: Revenues Period Ending: 3/2020 Account Description Adopted Amended Total Current Budget Budget Encumb. Month 536-49011-000-000 536-49142-000-000 536-49143-000-000 Subtotal: Program number: Department number: Revenues Interest Income Interfund Tran In -Water Sales Interfund Transfer In -WW Sales Revenues Subtotal 133 of 149 19.84- 19.84- 19.84- 19.84- 19.84 - April 20, 2020 Complete Agenda Packet Program: YTD % of Remaining Total Budget Budget 434.80- 434.80 183,168.16- 183,168.16 54,712.56- 54,712.56 238,315.! 238,315.52 238,315.52- 238,315.52 238,315.52- 238,315.52 238,315.52- 238,315.52 glbase_tbam skrolczyk 12:47 04/15/20 Fund: 536 2019 Rev Bond I&S- W&WW System Account 1 1 536-70005-051-000 1 536-70040-051-000 Description Rev Bond Paying Agent Fee Revenue Bond Interest Expense Trophy Club MUD No.1 Budget Summary with Amendment Department: 51 Administration Period Ending: 3/2020 Program: April 20, 2020 Complete Agenda Packet Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 142.08 214,892.43 142.08- 214,892.43 - ******* End of Report ********* 134 of 149 Subtotal: 215,034.51 215,034.51 - Program number: 215,034.51 215,034.51 - Department number: Administration 215,034.51 215,034.51 - Expenditures Subtotal 215,034.51 215,034.51 - Fund number: 536 2019 Rev Bond I&S- W&WW System 19.84- 23,281.01- 23,281.01 ******* End of Report ********* 134 of 149 glpdatb2 skrolczyk 12:48 04/15/20 Fund: 536 2019 Rev Bond I&S- W&WW System JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 3/2020 JE Detail Description/Comment Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) April 20, 2020 Complete Agenda Packet Check Source Number Department Totals: (19.84) Monthly Total .00 Budgeted 135 of 149 (238,315.52) ** 238,315.52 Remaining 0 % Used Account: 536-49011-000-000 Interest Income 1047 03/31/2020 Bank Interest- March (414.96) (19.84) (434.80) GL Account: 536-49011-000-000 Interest Income Totals: 11 (19.84) (434.80) ** .00 Budgeted 434.80 Remaining 0 % Used Account: 536-49142-000-000 Interfund Tran In -Water Sales (183,168.16) .00 (183,168.16) Account: 536-49142-000-000 Interfund Tran In -Water Sales Totals: ; .00 (183,168.16) ** .00 Budgeted 183,168.16 Remaining 0 % Used Account: 536-49143-000-000 Interfund Transfer In -WW Sales (54,712.56) .00 (54,712.56) Account: 536-49143-000-000 Interfund Transfer In -WW Sales Totals: .00 (54,712.56) ** .00 Budgeted 54,712.56 Remaining 0 % Used Department Totals: (19.84) Monthly Total .00 Budgeted 135 of 149 (238,315.52) ** 238,315.52 Remaining 0 % Used April 20, 2020 Complete Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 12:48 04/15/20 Detailed Accounting Trial Balance Fund: 536 2019 Rev Bond 2&S- W&WW System Department: 51 Administration Program: Period Ending: 3/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 536-70005-051-000 Account: 536-70005-051-000 11 Rev Bond Paying Agent Fee Rev Bond Paying Agent .00 Budgeted 142.08 (142.08) Remaining 0 % Used Account: 536-70040-051-000 Revenue Bond Interest Expense 214,892.43 Account: 536-70040-051-000 Revenue Bond Interest Expense Totals: .00 Budgeted (214,892.43) Remaining Department 51 Totals: Fund 536 Totals: Grand Totals: 0 % Used .00 Monthly Total .00 Budgeted (19.84) Monthly Total .00 Budgeted .00 142.08 .00 214,892.43 215,034.51 ** (215,034.51) Remaining 0 % Used (23,281.01) 23,281.01 Remaining 0 % Used ******* End of Report ********* (1,770,732.02) **** (135,636.24) Monthly Total (209,104.00) Budgeted 1,561,628.02 Remaining 847 % Used 136 of 149 BUDGET VARIANCE REPORT FUND: FINANCIALS MONTH: REVENUE VARIANCE: EXPENSE VARIANCE: NOTE: ACCOUNT AFIRE REVENUES 122-40010 122-40011 122-40020 FIRE EXPENSES 122 - Fire O&M March 2020 41.5% 59.8% Explanation provided for all accounts the Expense Variance. The Revenue revenues and plus 10% for expenses. DESCRIPTION Property Taxes/Mud Fire Property Taxes/Fire - Delinquent Property Taxes/Fire P&I April 20, 2020 Complete Agenda Packet with a Year -To -Date percentage (YTD%) less than the Revenue Variance and greater than or equal to and Expense Variance is calculated on a straight-line method (Financials Month x 8.3%), less 8.3% for Only accounts with current month activity will be listed TOTAL CURRENT YTD BUDGET MONTH TOTAL $1,214,230 $11,551 $409 $714 137 of 149 $1,208,468 $2,831 $3,546 YTD % DATE OF COMMENT 99.53% 10/2019 10/2019 10/2019 VARIANCE EXPLANATION Property Taxes/MUD Fire Delinquent Fire collected/paid out Fire Taxes Penalties & collected Taxes Interest BUDGET VARIANCE FUND: FINANCIALS MONTH: REVENUE VARIANCE: EXPENSE VARIANCE: NOTE: ACCOUNT REVENUE 135-47000-000 EXPENSES WATER 135-50010-010 135-50029-010 135-50040-010 135-60332-010 WASTEWATER 135-50040-020 135-55081-020 135-60010-020 135-60070-020 135-65030-020 135-65040-020 135-65040-020 BOARD OF DIRECTORS ADMINISTRATION 135-55030-030 135-60079-030 135-60125-030 135-65095-030 Non -Departmental 135-55045-039 135-55060-039 April 20, 2020 Complete Agenda Packet REPORT 135 - MUD 1 O&M March 2020 41.5% 59.8% 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 a^counts with current month activity will be listed DESCRIPTION TOTAL CURRENT YTD YTD BUDGET MONTH TOTAL DATE OF COMMENT VARIANCE EXPLANATION Water $6,486,623 $296,300 $2,101,815 32.40% 01/2020 Water Sales Overtime Life Insurance & Other Unemployment Taxes Interfund Transfer Out -Rev I&S Unemployment Taxes Maintenance & Repairs Collections Communications/Mobiles Dues & Memberships Chemicals Safety Equipment Lab Supplies $17,000 $1,476 $10,337 60.81% 01/2020 $3,132 $353 $1,906 60.84% 03/2020 $1,080 $817 $881 81.54% 03/2020 $527,381 $25,048 $333,454 63.23% 02/2020 $1,260 $936 $995 78.99% 03/2020 $10,000 $46 $17,724 177.24% 01/2020 $5,000 $409 $3,088 61.77% 01/2020 $300 $105 $216 72.00% 01/2020 $20,000 $2,204 $14,929 74.64% 11/2019 $1,200 $55 $1,167 97.21% 02/2020 $20,000 $5,433 $16,270 81.35% 03/2020 Software & Support $134.681 Public Education $6,000 Advertising $2.500 Maintenance Supplies $4.000 Legal Appraisal $4,834 $162 $1,772 $111 $131.677 $3,972 $1,772 $2.810 $135,000 $26,263 $82,965 $11,761 $2,243 $7,422 138 of 149 Overtime Life Insurance Unemployment Taxes I&S Interest Payment- 2019 Bond Unemployment Taxes LS Repairs New Tablet and Service WEF Membership Chemicals Safety Equpiment Lab Supplies 97.77% 01/2020 Annual Contract STW & OpenGov 66.19% 02/2020 MUD Boundary Update 70.89% 03/2020 RFP Advertisment 70.24% 01/2020 Office Supplies 61.46% 03/2020 Legal 63.11% 03/2020 Appraisal April 20, 2020 Complete Agenda Packet Trophy Club Municipal Utility District No. 1 General Manager's Report Regulatory Updates Breaks and Leaks — No reportable breaks or leaks have occurred since the last report. Sanitary Sewer Overflows (SSO) — No SSO's have occurred since the last report. Capital Improvement Projects WWTP — The awning structure is completed. The sound curtains will be installed once they have been received. This should be completed next week. We have started the fence replacement for the WWTP. They are moving along with the project and is starting to look good. The Plant is secure during this replacement as temporary fence is being utilized during this project. High Service Pump Station Upgrade — The VFD started up and ran perfectly. It was shutting down too fast, so they electricians are looking at a permanent fix to slow down the pump shutting down. 139 of 149 April 20, 2020 Complete Agenda Packet Monthly Water Operations Report Wate- 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 40,988 43,946 1 36,418 31,000 1 34,047 288,549 140,000 120,000 100,000 80,000 60,000 40,000 20,000 0 WATER BILLED IN THOUSANDS OF GALLONS October November December January February March April May June July August September - 2016 -2017 -2018 2019 - 2020 Water pumped FY October November December January February March April May June July August September Total Year 2010 40,803 41,600 32,700 31,400 30,145 27,240 43,400 62,646 113,049 94,950 131,650 76,159 725,742 2011 70,502 50,993 44,220 33,789 36,053 54,775 71,306 63,500 116,350 152,002 169,621 117,190 980,301 2012 83,750 54,245 41,650 34,740 31,581 46,519 62,649 100,402 110,324 153,813 139,005 123,045 981,723 2013 85,966 77,758 55,110 39,283 37,867 56,743 60,969 87,168 96,602 119,414 145,988 120,342 983,210 2014 81,909 51,769 39,769 48,758 42,395 61,100 71,283 96,481 95,206 110,173 123,369 115,607 937,819 2015 106,251 67,825 58,659 45,691 39,675 35,752 56,704 48,637 72,934 117,302 143,413 142,394 935,237 2016 106,731 52,616 43,708 46,945 50,721 55,178 60,434 55,562 68,138 112,533 128,963 104,664 886,193 2017 82,677 77,937 43,792 43,207 43,024 69,549 65,723 94,452 103,867 101,184 114,872 109,769 950,053 2018 91,439 78,282 55,745 40,796 40,750 51,711 67,217 97,980 124,109 155,354 144,015 85,946 1,033,344 2019 60,576 53,119 45,651 45,552 39,014 43,048 61,238 48,787 79,167 102,887 144,299 130,752 854,090 2020 1 112,971 1 48,627 1 49,384 1 40,726 1 35,749 1 38,576 1 1 1 1 1 1 1 326,0331 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 Fell=1111 June July August September ----2016 2017 2018 2019 - 2020 FY October 2014 Total 4139 2015 Total 4353 2016 Total 4531 2017 Total 4644 2017 MUD 3208 2017 PID 1436 2018 Total 4701 2018 MUD 3257 2018 PID 1444 2019 Total 4741 2019 MUD 3297 2019 PID 1444 2020 Tota 2020 MUD 2020 PID November 4157 4363 4538 4647 3210 1437 4706 3262 1444 4743 3299 1444 December 4173 4377 4556 4661 3220 1441 4712 3268 1444 4745 3301 1444 January 4206 4404 4568 4657 3216 1441 4716 3272 1444 4753 3309 1444 Active Connections February 4209 4413 4593 4663 3221 1442 4720 3276 1444 4753 3309 1444 March 4219 4429 4604 4666 3224 1442 4724 3280 1444 4758 3314 1444 April May June July 4240 4268 4280 4308 4443 4459 4478 4486 4607 4616 4622 4627 4670 4676 4685 4690 3228 3234 3242 3247 1442 1442 1443 1443 4724 4728 4732 4735 3280 3284 3288 3291 1444 1444 1444 1444 4761 4762 4768 4770 3317 3318 3324 3326 1444 1444 1444 1444 August 4333 4498 4632 4696 3252 1444 4736 3292 1444 4773 3329 1444 September 4339 4517 4636 4700 3256 1444 4738 3294 1444 4782 3338 1444 4795 3351 1444 4796 4797 4797 4807 4807 3352 3353 3353 3363 3363 1444 1444 1444 1444 1444 140 of 149 i April 20, 2020 Complete Agenda Packet March 2020 Results Ammonia -N CBOD5 TSS Date % Removal % Removal % Removal Influent Effluent Influent Effluent Influent Effluent 2 -Mar 51.2 0.20 99.6% 216 2.0 99.1% 256 1.0 99.6% 5 -Mar 42.0 0.20 99.5% 221 2.0 99.1% 214 1.0 99.5% 9 -Mar 44.8 0.20 99.6% 232 2.0 99.1% 164 1.0 99.4% 12 -Mar 37.5 0.20 99.5% 291 2.0 99.3% 285 1.0 99.6% 16 -Mar 22.0 0.20 99.1% 267 2.0 99.3% 144 1.0 99.3% 18 -Mar 36.5 0.20 99.5% 236 2.0 99.2% 111 1.0 99.1% 23 -Mar 34.5 0.20 99.4% 238 2.0 99.2% 134 1.0 99.3% 25 -Mar 36.9 0.20 99.5% 186 2.0 98.9% 240 1.0 99.6% IReport Ammonia -N CBOD5 TSS 0.20 1 99.4% 2.0 1 99.1% 1.0 1 99.4% 141 of 149 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 April 20, 2020 Complete Agenda Packet Ammonia Nitrogen Permit Limit 3 (Jan - March) 0.523 0.23 0.2 0.2 L_ Permit Limit - 1 from April - August Permit Limit 3 (Sept. - Dec.) Dec -19 Jan -20 Feb -20 Mar -20 Apr -20 May -20 Jun -20 Jul -20 Aug -20 Max mg/L = .20 Average mg/L =.20 Carbonaceous Biochemical Demand (CBOD5) Sep -20 Oct -20 Nov -20 Dec -20 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 II II II II Permit Limit 5 Dec -19 Jan -20 Feb -20 Mar -20 Apr -20 May -20 Jun -20 Jul -20 Max mg/L = 2.0 Average mg/L = 2.0 142 of 149 Aug -20 Sep -20 Oct -20 Nov -20 Dec -20 - Nh3Ave - Nh3 Permit Limit Bod Bod Aver Permit Limit 14.0 12.0 10.0 8.0 6.0 4.0 2.0 0.0 30.0 25.0 20.0 15.0 10.0 5.0 0.0 April 20, 2020 Complete Agenda Packet Total Suspended Solids (TSS) 1.0 1.0 - - 1.0 1.0 1.0 1.0 1.0 1.0 -- -- -- Permit Limit 12 Dec -19 Jan-20 Feb -20 Mar -20 Apr -20 May -20 Jun -20 Jul -20 Aug -20 Max mg/L = 1.0 Average mg/L = 1.0 Nitrate - Nitrogen Sep -20 Oct -20 Nov -20 Dec -20 5.1 5.10 4.9 6.0 5.34 5.0 5.26 11111111 5 Permit Limit 24 Dec-19 Jan -20 Feb -20 Mar -20 Apr -20 May -20 Jun -20 Jul -20 Max mg/L = 5.8 Average = 4.6 143 of 149 Aug -20 Sep -20 Oct -20 Nov -20 Dec -20 T55 - TSS Ave - Permit Limit - N -N N -N Aver - Permit Limit 10 9 8 7 6 5 4 3 2 1 0 10.0 9.0 8.0 7.0 6.0 5.0 4.0 3.0 2.0 1.0 0.0 April 20, 2020 Complete Agenda Packet E. Coli Permit Limit 126 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 MI MI MI MI Dec -19 Jan -20 Feb -20 Mar -20 Apr -20 May -20 Jun -20 Jul -20 Aug -20 Max mg/L = 1.0 Average mg/L = 1.0 Potential for Hydrogen (pH) Sep -20 Oct -20 Nov -20 Dec -20 Permit Limit High 9 7.77 7.41 7.67 7.72 7.48 7.627.39 3 7.03 7.16 6.89 6.29 II 1 Permit Limit Low 6 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Dec -19 Jan -20 Feb -20 Mar -20 Apr -20 May -20 Jun -20 Jul -20 Aug -20 Sep -20 Max mg/L = 7.45 Min mg/L = 7.42 Average mg/L = 7.436 144 of 149 Oct -20 Nov -20 Dec -20 • E. Coli • E. Coli Ave. • Permit Limit pH Min pH Max pH Aver - Permit Limit Low - Permit Limit High 10 9 8 7 6 5 4 3 2 1 0 April 20, 2020 Complete Agenda Packet Dissolved Oxygen (DO) 101 II ill r 11 Permit limit Njav q Permit Limit Min 6 Dec -19 Jan -20 Feb -20 Mar -20 Apr -20 May -20 Jun -20 Jul -20 Aug -20 Max mg/L = 8.1 Average mg/L = 7.5 145 of 149 Sep -20 Oct -20 Nov -20 Dec -20 - DO - DO Aver - Permit Limit Min. - Permit Limit Max ebills Bills Mailed Bank Draft Credit Card Draft Online Payments Late Notices Disconnects M Connections P ebills Bills Mailed Bank Draft Credit Card Draft Online Payments Late Notices Disconnects M Connections P April 20, 2020 Complete Agenda Packet Trophy Club MUD #1 Utility Billing Report Fiscal Year 2020 October November December January February March April May June July August September 938 941 944 951 963 970 3841 3845 3860 3835 3817 3833 646 650 652 654 649 649 1193 1185 1193 1198 1168 1208 1145 1192 1,184 1,208 1,187 1,216 378 453 339 462 452 425 21 41 42 27 38 20 3351 3352 3353 3353 3363 3363 1444 1444 1444 1444 1444 1444 Fiscal Year 2019 October November December January February March April May lune 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 146 of 149 April 20, 2020 Complete Agenda Packet MUD Permits Month: March 2020 Plumbing Sewer Date of Customer Deposit Due to FW Water 135- Inspections 135- Inspections 135- Misc Income Permit Permit No. 135-25030 20500 Oversize Meter 135-49075 47035 47045 Fire Line 135-49900 135-49900 Total 3/3/2020 2020-25 $ 75.00 $ 4,396.00 $ 353.00 $ 150.00 $ 50.00 $ 5,024.00 Total $ 75.00 $ 4,396.00 $ 353.00 $ 150.00 $ 50.00 $ 147 of 149 $ 5,024.00 CASH STATUS AS OF MARCH 2020 135-10250 TexPool 0 & M (XXXXX0002)-General Fund Operating *** 135-10300 Prosperity Bank (XXX8701) General Fund Operating 135-10305 Prosperity Bank Reserve -Savings Acct (XXXXX7724) 135-11100 Petty Cash Administration 135-11150 Petty Cash Utility Billing 137-10250 TexPool 0 & M (XXXXX0002) GASB Replacement 517-10250 TexPool Construction Tax (XXXXX011) 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) *03/31/2020 Customer Water Deposits $316,540 Fire Department Cash 1122-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 148 of 149 April 20, 2020 Complete Agenda Packet Restricted - Unable to be spent $o $316,540 $1,602,621 $0 $0 $919,266 $524,254 $0 $0 $784,703 $448,915 $3,891,217 $872,080 $923,693 $0 $247,837 $125,471 $23,281 $10,679,877 $o $0 Unrestricted - Available for spending $3,774,203 $2,471,032 $0 $150 $450 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $6,245,835 $0 1 $6,245,835 $6,245,835 $1,010,278 $0 $1,010,278 $1,010,278 $1,010,278 Total in Accounts (Restricted & Unrestricted) $3,774,203 $2,787,572 $1,602,621 $150 $450 $919,266 $524,254 $0 $0 $784,703 $448,915 $3,891,217 $872,080 $923,693 $0 $247,837 $125,471 $23,281 $16,925,712 General Fund 135 Available $ 2,471,032 Prosperity General Fund $ 3,774,203 Texpool General Fund $ 600 Petty Cash $ 6,245,835 3,486 2,072,098 6,325,800 (55,896) $8,345,488 $1,010,278 $0 $1,010,278 TC Meeting Spaces May 2020 18 19 20 21 22 23 Sun Apr 26, 2020 3 10 17 24 Mon Tue Wed Thu 27 28 4 5 Hold for Special Meetings 11 18 6:30pm (44-) Board of Direct 25 31 Jun 1 Printed on: 04/16/2020 2:12pm 12 19 26 29 6 13 7 14 20 21 27 149 of 149 28 April 20, 2020 Complete Agenda Packet2 Modifier Fri Sat May 1 8 15 22 29 5 2 9 16 23 30 Powered by _ teamup