Loading...
HomeMy WebLinkAbout2020-0316 March 16 2020 Regular Meeting Agenda Packet AMENDEDMonday, March 16, 2020 Q TROPHY CLUB MUNICIPAL UTILITY DISTRICT AMENDED March 16, 2020 Regular Meeting Agenda Packet BOARD OF DIRECTORS REGULAR MEETING AGENDA PACKET — AMENDED** TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 100 MUNICIPAL DRIVE TROPHY CLUB, TEXAS 76262 6:30 P.M. Svore Municipal Boardroom REGULAR MEETING CALL TO ORDER AND ANNOUNCE A QUORUM CITIZEN COMMENTS This is an opportunity for citizens to address the Board on any matter whether or not it is posted on the agenda. The Board is not permitted to take action on or discuss any comments made to the Board at this time 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. February 2020 Check Register b. February 17, 2020 Regular Meeting Minutes attachments: February Check Register February 17, 2020 Regular Meeting Minutes REGULAR SESSION 2. Discussion and possible action regarding Winter Average Analysis completed by NewGen Strategies & Solutions. 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) attachments: Order No. 2020-0316A Rate Order 1 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet 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. attachments: Staff Report Bids Received 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. attachment: RFQ for Professional Engineering Services 6. Discussion and possible action regarding COVID-19 and District operations.** 7. Consider and take appropriate action regarding the February 2020 Combined Financials and Variance Report. a. Combined Financials b. Combined Variance attachments: Combined Financials Combined Variance REPORTS & UPDATES 8. Receive report from General Manager Hiring Committee. (Flynn) 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 attachments: General Manager Report Water Operations Report Wastewater Operations Report Utility Billing Report Permits Collected Cash Report 2 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet EXECUTIVE SESSION 10. Pursuant to Section 551.071 of the Texas Open Meetings Act, the Board may consult with its attorney in Executive Session on a matter in which the duty of the attorney to the Governmental Body under the Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflicts with the Open Meetings Act or to seek advice of counsel on legal matters involving pending or contemplated litigation or settlement offers: a. Contractor breach, performance and payment issues related to District's contract with Webber- Cadagua Partners for construction of the Wastewater Treatment Plant Improvements; and b. Trophy Club Municipal Utility District No. 1 v. Acadia Services, LLC, In the District Court of Tarrant County, 141st Judicial District (Cause No. 141-299351-18). c. Potential Condemnation of Easements required for construction and operation of Water Transmission Line Improvements from District Pump Station to Elevated Water Tank located on T.W. King Road 11. Pursuant to Section 551.072 of the Texas Open Meetings Act, the Board may deliberate the purchase, exchange, lease, or value of real property if deliberation in an open meeting would have a detrimental effect on the position of the governmental body in negotiations with a third person: a. Sale or Exchange of District real property located at 100 Municipal Drive, 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 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 April 20, 2020 at 6:30 p.m. attachment: April meeting calendar *THE BOARD RESERVES THE RIGHT TO ADJOURN INTO EXECUTIVE SESSION AT ANY TIME DURING THE MEETING PURSUANT TO THE APPLICABLE SECTION OF SUBCHAPTER D, CHAPTER 551, TEXAS GOVERNMENT CODE, THE TEXAS OPEN MEETINGS ACT, WITH RESPECT TO ANY ITEM ON THE AGENDA. NO FINAL ACTION, DECISION OR VOTE WILL BE TAKEN ON ANY SUBJECT OR MATTER IN EXECUTIVE SESSION. THIS NOTICE MODIFIES THE DISTRICT'S PRIOR PRACTICE OF SPECIFICALLY IDENTIFYING ALL AGENDA ITEMS TO BE DISCUSSED IN EXECUTIVE SESSION. ADJOURN 3 of 157 apackamt2 skrolczyk Begin Date: 02/01/2020 End Date: 02/29/2020 Vendor vendor Name Number 998 BYNU M, BRENI' Tbtals for Check: 6158 998 FISHER, HENRY U Totals for Check: 6159 998 GEORGE, SHERRY Tbtals far Check: 6160 998 GOR AN, TIMOTHY 'btals for Check: 6161 998 HAIL, SANDRA Tbtals for Check: 6162 998 KIRK, KAYLA Tbta1s for Check: 6163 998 RIC, STACIE Totals for Check: 6164 998 MARMNIEL, RODNEY Totals for Check: 6165 998 NICHOLAS, TYSON Totals for Check: 6166 998 OPEN HOUSE TE AS Totals for Check: 6167 998 PACKAN, GARY Tbtals for Check: 6168 998 SHAFFER, IOWA Totals for Check: 6169 998 SIMMONS, JIi+P1Y Totals for Check: 6170 998 SIRVA REO A5TC Totals for Check: 6171 998 W IITFORD, KATHERINE Totals for Check: 6172 998 wnsoN, ICOMERLEY Totals for (heck: 6173 Fran Pmt: Trophy club FYID Nb.1 AP Checks Fbr Date/Arount Range .00 Tb Amt: 99,999,999.99 lnvolce Number lnVo.ce Inv Dept Account Descraptam Date Stat Nb Number U0034000019203A 01/31/20 P 135-20050-000-000 A/P Vendors U0010080657105A 01/31/20 P 135-20050-000-000 A/P Vendors U9023250029902A 01/31/20 P 135-20050-000-000 A/P Vendors U9046040057901A 01/31/20 P 135-20050-000-000 A/P Vendors U0010050364109A 01/31/20 P 135-20050-000-000 A/P Vendors 00010080577109A 01/31/20 P 135-20050-000-000 A/P Vendors U0050360009107A 01/31/20 P 135-20050-000-000 A/P Veadbrs U0030111477203A 01/31/20 P 135-20050-000-000 A/P Vendors 09048020010903A 01/31/20 P 135-20050-000-000 A/P Vendors U0010110010106A 01/31/20 P 135-20050-000-000 A/P Vendors U0010130103111A 01/31/20 P 135-20050-000-000 A/P Vests U0020000941208A 01/31/20 P 135-20050-000-000 A/P Vendors U0020000946202A 01/31/20 P 135-20050-000-000 A/P Vendors U0030400002207A 01/31/20 P 135-20050-000-000 A/P Vendors 130010170003103A 01/31/20 P 135-20050-000-000 A/P Vendors U0040002107101A 01/31/20 P 135-20050-000-000 A/P Vendors 4 of 157 AMENDED 03A1G'1' d1 1021120 Regular Meeting Agenda Pitt 1 Lane It= Value Narioer Date 18.32 6158 02/12/20 18.32 83.35 6159 02/12/20 83.35 12.02 6160 02/12/20 12.02 02.40 6161 02/12/20 02.40 97.76 6162 02/12/20 97.76 77.54 6163 02/12/20 77.54 26.43 6164 02/12/20 26.43 16.94 6165 02/12/20 16.94 20.79 6166 02/12/20 20.79 28.26 6167 02/12/20 28.26 101.45 6168 02/12/20 101.45 48.44 6169 02/12/20 48.44 21.11 6170 02/12/20 21.11 06.91 6171 02/12/20 06.91 40.52 6172 02/12/20 40.52 54.10 6173 02/12/20 54.10 apackamt2 skrolczyk Begin Date: 02/01/2020 FYtd Date: 02/29/2020 vendor venoor Namme Number 1005 AIMS UTILITY SUPPLY CO. Totals for Check: 6174 2651 Carman Consulting ILC. 2651 Cancan Consulting ILC. Totals for Check: 6175 2655 Core & Main LP Tbtala for Che:k: 6176 3193 OtPt3PAY, INC. Tbtals for Check: 6177 3080 CP&Y/VALLACE GROUP, INC. Totals far Check: 6178 3184 DATAPRASE LLC 3184 DAA LLC Tb+'al g for Check: 6179 2606 Fisery Solutions, LLC Totals for Check: 6180 1372 HACH COMPANY Totals for Check: 6181 3124 IRS Tax Payment 3124 IRS Tax Payment 3124 IRS Tax Payment Totals for Check: 6182 1468 L.H. CHANEY MATERIALS, INC. 1468 L.H. CHARY MATERIALS, INC. Totals for Check: 6183 Fiuu Amt: invoice Number .Invoke lnv Dept ACCOLUlt Date Stat No Nurber 12168A 02/03/20 P 10 135-65050-010-000 30 02/06/20 V 30 135-55070-030-000 30 02/06/20 V 30 135-55070-030-000 L793516 01/27/20 P 10 135-55080-010-000 PR00689 996 02/07/20 P 135-21313-000-000 1600916.05-6 02/10/20 P 20 517-69005-020-000 DP2000223 01/31/20 P 30 135-60035-030-000 DE2000223 01/31/20 P 30 135-55205-030-000 91650948 02/04/20 P 30 135-60040-030-000 11807237 01/23/20 P 10 135-65030-010-000 9R00689 996 02/07/20 9R00689 996 02/07/20 9800689 996 02/07/20 P 135-21302-000-000 P 135-21303-000-000 P 135-21304-000-000 169800 01/25/20 P 20 135-55125-020-000 169894 02/07/20 P 20 135-55125-020-000 2712 MARYLAND BIOCHEMICAL CD, INC 1NN1068 Totals for Check: 6184 2643 McLean & Howard, L.L.P. 2643 McLean & Howard, L.L.P. Totals for Check: 6185 01/17/20 P 20 135-65030-020-000 35931 01/31/20 P 39 135-55045-039-000 35930 01/31/20 P 39 135-55045-039-000 3200 MET= TOLEDO IITICE9L 654806524 Totals for Check: 6186 3111 North Tums Groundwater Totals for Check: 6187 01/21/20 P 20 135-55135-020-000 180 01/31/20 P 10 135-60135-010-000 AMENDED Trophy Club MCD No.1 03 1692A20 Regular Meeting Agenda PB&.et 2 AP checks For Date/Amount Range .00 To Amt: 99,999,999.99 Description Meter Hcpense Independent Labor indepeThelent Tahnr Maintenance & Repairs Cafe 125 -Medical Reinb Capital Outlays Postage Utility Billing Contract Service Charges & Fees Chemicals PW Taxes Social Security Tapes Medicare Taxes Du peter Services Dunpster Services Chemicals Legal Legal lab Analysis TC.EQ Pees & Permits 5of157 JnTg. 1tHm UtIeCK (-neck Value Nutter Date 765.00 6174 02/12/20 765.00 10,780.00 6175 02/12/20 08.70 6175 02/12/20 10,788.70 180.00 6176 02/12/20 180.00 549.37 6177 02/12/20 549.37 5,985.00 6178 02/12/20 5,985.00 1,666.39 6179 02/12/20 592.18 6179 02/12/20 2,258.57 50.00 6180 02/12/20 50:00 1,223.94 6181 02/12/20 1,223.94 4,075.31 6182 02/12/20 5,334.40 6182 02/12/20 1,247.58 6182 02/12/20 10,657.29 2,600.90 6183 02/12/20 2,347.32 6183 02/12/20 4,948.22 1,761.21 6184 02/12/20 1,761.21 1,050.00 6185 02/12/20 5,100.00 6185 02/12/20 6,150.00 360.76 6186 02/12/20 360.76 2,685.69 6187 02/12/20 2,685.69 apackamt2 skrolczyk Begin Date: 02/01/2020 End Date: 02/29/2020 Venbar veno ' Name Natter 2713 Opa13ov, inc Tbtals far Check: 6188 3156 0702 LABCRATORIES LLC 3156 CMDDO2. ZABORATDRIES LLC Totals far Check: 6189 Fran Amt: Invoice Number Invoice Inv Dept Account Date Stat No Number I2V-002964 02/01/20 P 30 135-55030-030-000 20010546 20010609 3182 Strategic Goverresnt Resources 2020-101521 Totals far Check: 6190 1163 STW SNC 1163 STW INC Totals far Check: 6191 01/28/20 P 20 135-55135-020-000 01/30/20 P 20 135-55135-020-000 01/30/20 P 30 135-55070-030-000 26553 01/22/20 P 30 135-55030-030-000 26607 01/31/20 P 30 135-55030-030-000 2440 moue CTY PUBLIC HEALTH LAB 33070 2440 TARRANT CTY PUBLIC HEALTH LAB 33071 Totals far Check: 6192 3113 =CRS Totals for Check: 6193 01/31/20 P 10 135-55135-010-000 01/31/20 P 10 135-55135-010-001 9R00689 996 02/07/20 P 2696 Texas ESccavatiaa Safety Systen 20-01698 Torok for Cbeck: 6194 1001 WAN OFT OMP/ CLUB 1001 wail OF TROPHY CLUB 1001 TC roSI OF TROPHY CHID 1001 RCM OF TROPHY CLUB 1001 maN OF TS30PHY CLUB Totals for Check: 6195 1081 TRI COUNTY ELECTRIC Totals for Check: 6196 JAN REFUSE JAN REFUSE JAN REFUSE 020120 021020 76696890 1000 TROPHY CLUB MUD NAM FRTe) 01/31/2020 Totals for Check: 6197 1058 VERIZON WIRELESS 1058 VERIZON WIRELESS 1058 VERIZONWMELESS Totals far Check: 6198 1087 4W13. 9R CHALK SWINDLE Totals for Check: 6199 2651 Garan Cmsulting LSC. 2651 Carman Consulting LIC. 9847373300 9847373300 9847373300 135-21317-000-000 01/31/20 P 30 135-60040-030-000 01/31/20 01/31/20 01/31/20 02/03/20 02/10/20 P 135-25040-000-000 P 135-25000-000-000 P 135-25010-000-000 P 45 122-60337-045-000 P 30 135-60020-030-000 02/03/20 P 20 135-60020-020-000 01/31/20 P 30 135-60025-030-000 02/01/20 P 02/01/20 P 02/01/20 P 20 135-60010-020-000 30 135-60010-030-000 10 135-60010-010-000 256575 01/31/20 P 39 135-55045-039-000 30-1 02/06/20 P 30 135-55070-030-000 30-1 02/06/20 P 30 135-55070-030-000 Trophy club MUD No.1 AP Checks Eur Date/Amount Range .00 TO Amt: 99,999,999.99 Description Software & Support Lab Analysis Lab Analysis independent Lairs Software & Support Software & Support Lab Analysis Lab Analysis for PID TC;DRS Service Charges & Fees Tema -Storm Drainage Refuse Refuse Tax Transfer to Tbwn/Eire Budget Faectricity/Cas Electricity Water Cannmicatieos/Mobiles Ca runicat-ir,s/Mobiles Casmanicatims/Mobiles T1 Independent Labor Independent Jalrsr 6 of 157 AMENDED 03e1 169x20 Regular Meeting Agenda Past 3 Line Item check Cnec1c Value Number Date 22,587.00 6188 02/12/20 22,587.00 341.55 6189 02/12/20 241.50 6189 02/12/20 583.05 10,000.00 6190 02/12/20 10,000.00 16,800.00 6191 02/12/20 962.05 6191 02/12/20 17,762.05 250.00 6192 02/12/20 80.00 6192 02/12/20 330.00 7,360.91 6193 02/12/20 7,360.91 210.90 6194 02/12/20 210.90 32,050.33 6195 02/12/20 66,176.78 6195 02/12/20 5,431.33 6195 02/12/20 59,888.08 6195 02/12/20 718.11 6195 02/12/20 164,264.63 483.78 6196 02/12/20 483.78 112.79 6197 02/12/20 112.79 408.87 6198 02/12/20 87.75 6198 02/12/20 424.30 6198 02/12/20 920.92 5,566.00 6199 02/12/20 5,566.00 10,540.00 6200 02/17/20 08.70 6200 02/17/20 apackamt2 slcrrolczyk Begin Date: 02/01/2020 End Date: 02/29/2020 vena. veno ' Name Number Totals for Check: 6200 2920 C ARESTJW CXH2PMTE Tbtais for Check: 6201 2683 Charter Communications Totals for Qieck: 6202 2677 Digital Air Control, Inc Totals for Check: 6203 2653 Dubois Bryant Campbell LLP Totals for Check: 6204 2635 Halff Associates, INC 2635 Halff Associates, IIx 2635 Halff Associates, INC 2635 Halff Associates, INC Totals for Check: 6205 2641 Huber Technology Inc Totals for Check: 6206 1468 L.H. CHNS ST MATERIALS, INC. Totals for Check: 6207 3216 M3 Netvaarks Totals for Chedk: 6208 3156 3156 3156 3156 Totals 2719 2719 Totals mama Lucencams LLC a mxa IABOMOR= LLC =CR LABORATCRIBS LLC =DOR IAB3RATORIES LLC for Check: 6209 Precision Pump Systems Precision Pump Systems for Check: 6210 From Amt: Invoice Number invoice SSiv Dept scoot= Date Stat No limber CN1536-4059732 02/08/20 P 20 135-50060-020-000 71672020620 02/06/20 P 30 135-55030-030-000 2051125 02/10/20 P 30 135-60235-030-000 104584 02/11/20 P 20 517-69005-020-000 10033737 10033736 10033733 10033739 CD10019225 169974 5865 02/12/20 02/12/20 02/12/20 02/12/20 P 20 135-69005-020-000 P 30 135-69005-030-000 P 10 520-69005-010-000 P 30 135-60079-030-000 12/23/19 P 02/08/20 P 02/15/20 P 20020048 02/04/20 P 20020122 02/06/20 P 20020295 02/14/20 P 20020173 02/11/20 P 20 135-55080-020-000 20 135-55125-020-000 30 135-55030-030-000 20 135-55135-020-000 20 135-55135-020-000 20 135-55135-020-000 20 135-55135-020-000 20071019 02/04/20 P 20 135-55080-020-000 20070155 02/01/20 P 20 135-55080-020-000 2633 Sluder Eftergency Power Service 1146 02/12/20 P Totals for Check: 6211 3282 TIAA CXt4CTAL, FINANCE 6932849 02/07/20 P Totals for Check: 6212 2222 AFLAC 2222 AFLAC 9500689 996 02/07/20 P 9500690 996 02/21/20 P 30 135-55085-030-000 30 135-69170-030-000 135-21312-000-000 135-21312-000-000 AMENDED Trophy Club NDS No.1 03 i 1602/420 Regular Meeting Agenda Pe*et 4 AP Checks nor Date/Amount Range .00 Tb Amt: 99,999,999.99 lleacxlptloa Pre-gtp Ithysira1A/Testing Software & Smart Security Capital Outlays Capital Outlays Capital Outlays Capital Outlays Public Education Maintenance & Repairs Dempster Services Software & Support Lab Analysis Lab Analysis Lab Analysis Lab Analysis Maintenance & Repairs Maintenance & Rd's Generator Naant. and Repair Copier Lease installments Aflac Afar 7of157 Line Item u ecK Cnecir Value Niarber Date 10,548.70 38.00 6201 02/17/20 899.00 6202 02/17/20 24.00 6203 02/17/20 1,020.00 6204 02/17/20 38.00 899.00 24.00 1,020.00 6,119.80 47,39 643.29 2,508.78 9,319.26 6205 02/17/20 6205 02/17/20 6205 02/17/20 6205 02/17/20 637.87 6206 02/17/20 1,079.42 6207 02/17/20 494.00 6208 02/17/20 637.87 1,079.42 494.00 341.55 6209 02/17/20 241.50 6209 02/17/20 241.50 6209 02/17/20 341.55 6209 02/17/20 1,166.10 2,310.00 6210 02/17/20 605.00 6210 02/17/20 2,915.00 531.00 6211 02/17/20 165.00 6212 02/17/20 210.67 6213 02/28/20 270.21 6213 02/28/20 531.00 165.00 apackamt2 skrolczyk Begin Date: 02/01/2020 End Date: 02/29/2020 Vella= Vemr Name Number Totals for (]neck: 6213 3197 Fwn-f4tMall 3197 BenefitMal.1 3197 PanPfitMall Tbtals for Check: 6214 3262 BRANDON R REM Totals for Check: 6215 1030 CITY OF YLya WORTH Tbtals for Check: 6216 3193 03MPUPAY, INC. Total R for Check: 6217 2705 Defender Supply Totals for Check: 6218 2497 DHS AUICMATICN, INC 2497 DHS ANIMATION, INC 2497 DRS AUICMATICN, INC Totals for Check: 6219 1737 DPC INDUSTRIES, INC Tbtals for Check: 6220 2720 Filter Element Store Totals for Check: 6221 2641 Huber Technology Inc 2641 Humber Technology Inc Totals for Check: 6222 2676 Humana Inc 2676 Humana Inc 2676 Humana Inc 2676 Humana Inc 2676 Hunan Inc 2676 Humana Inc Totals for Chedk: 6223 2775 HUDSMI ENERGY SERVICES, LIC 2775 HUDSON ENERGY SERVICES, ILC Totals for Clheck: 6224 3124 IRS Tax Payment Fran Amt: invoice Number Invoice Inv Dept Account Date Stat No Number 9047092 -IN 9047092 -IN 9047092 -IN 2835 2/18/20 PR00690 26511 02/13/20 P 02/13/20 P 02/13/20 P 02/20/20 P 02/18/20 P 996 02/21/20 P 02/18/20 P 06-1950 02/20/20 P 06-1950 02/20/20 P 06-1949 02/20/20 P 767000755-20 02/17/20 P SI -109052 02/25/20 P 0010019432 02/17/20 P CD10019440 02/18/20 P 155516847 03/01/20 P 155516847 03/01/20 P 155516847 03/01/20 P 155516847 03/01/20 P 155516847 03/01/20 P 155516847 03/01/20 P 10 135-50029-010-000 20 135-50029-020-000 30 135-50029-030-000 20 135-60280-020-000 10 135-60150-010-000 135-21313-000-000 10 135-69005-010-000 10 135-55080-010-000 20 135-55081-020-000 10 135-55080-010-000 10 135-65030-010-000 20 135-55080-020-000 20 135-55080-020-000 20 135-55080-020-000 135-21308-000-000 135-21309-000-000 135-21311-000-000 10 135-50029-010-000 20 135-50029-020-000 30 135-50029-030-000 52002180001-33 02/18/20 P 10 135-60020-010-000 52002180001-33 02/18/20 P 20 135-60020-020-000 9500690 996 02/21/20 P 135-21302-000-000 Trophy Club MUD No.1 AP Checks For Date/Amount Range .00 To Amt: 99,999,999.99 Description Life Insurance & Other Life Insurance & Other Life Insurance & Other Property Maintenance hbolele Fater Cafe 125 -Medical Reisrb Capital Outlays Maintenance & Repairs Mainten & Repairs Collections Maintenance & Repairs Chemicals Maintenance & Repairs Maintenance & Repairs Maintenance & Repair's Dental Vision Voluntary Life Life Insurance & Other Life Insurance & Other Life Insurance & Other Electricity Electricity Fldi Taxes 8 of 157 AMENDED 03,W2th 18,2:420 Regular Meeting Agenda P1a et 5 Line ltan Check Cr+ACk Value Naber Date 480.88 20.00 6214 02/28/20 32.00 6214 02/28/20 16.00 6214 02/28/20 68.00 584.94 6215 02/28/20 584.94 103,065.44 6216 02/28/20 103,065.44 549.37 6217 02/28/20 549.37 2,245.00 6218 02/28/20 2,245.00 611.76 6219 02/28/20 1,405.00 6219 02/28/20 1,175.00 6219 02/28/20 3,191.76 670.09 6220 02/28/20 670.09 109.20 6221 02/28/20 109.20 665.00 6222 02/28/20 1,120.32 6222 02/28/20 1,785.32 1,503.31 6223 02/28/20 206.49 6223 02/28/20 318.36 6223 02/28/20 176.88 6223 02/28/20 198.33 6223 02/28/20 176.22 6223 02/28/20 2,579.59 6,824.77 6224 02/28/20 13,152.71 6224 02/28/20 19,977.48 4,612.11 6225 02/28/20 apackant2 skrolczyk Begin Date: 02/01/2020 End Date: 02/29/2020 verrt r venoor Name Nunber 3124 IRS Tax Paynent 3124 IRS Tax Payment Totals for Check: 6225 3278 RBOOM A DOCUMENT SOLUTIONS Totals for check: 6226 1468 L.H. CHANEY MATERIALS, INC. 1468 L.H. CHANEY MATERIALS, INC. Totals for Check: 6227 3132 3132 Totals Legal Shield Legal Shield for Check: 6228 2932 M -RAM IIID. Totals for Check: 6229 From Amt: Invoice MnDer Invoice ITN Dept Account Date Stat Db Mh:rber P290690 996 02/21/20 P 9290690 996 02/21/20 P 5581734064 Trophy club MAID Nb.1 AP checks For Date/Amount Range .00 Tb Amt: 99,999,999.99 1)esor pt1. 1 135-21303-000-000 Social Security Taxes 135-21304-000-000 Medicare Taxes 02/20/20 P 30 135-69170-030-000 cagier Lease Installments 169991 02/15/20 P 20 135-55125-020-000 Do ter Services 170149 02/22/20 P 20 135-55125-020-000 Donpeter Services 9200689 996 02/07/20 P 9200690 996 02/21/20 P 135-21310-000-000 Isga1 Plan 135-21310-000-000 Legal Plan 26052 02/17/20 P 10 135-69005-010-000 Capital Outlays 3186 EMBER'S BunanzMAINIENAINEE TC2001TavED 3186 MEMBER'S BUIIDIm MAINTENANCE TC2001It3W 3186 MEMBER'S BUILDING leis NIENANCE TC2001 343D Totals for Check: 6230 3115 METLIFE GROUP mamas 3115 MEI5IIPE GROUP BENEFITS 3115 METLIFE GROUP BENEFITS 3115 METTSFE GROUP moms Tbtals for Check: 6231 1056 OFFICE DEPOT, INC 1056 OFFICE DEPOT, INC Totals for Check: 6232 3156 OXIDOR LABORATI ILC 3156 OXIDOR LABCHiATC%2lls"S LLC 3156 OXZDOR IABORATCE IES LLC 3156 OX/DOR LABQiATC IMS LLC Torw1a for Check: 6233 3113 2C ERS Totals for Check: 6234 1973 TX cS2dmD SSI00 ENVIRCUMENTAL Q1 Totals for Check: 6235 3/15/2020 3/15/2020 3/15/2020 3/15/2020 442813083001 442804041001 20020346 20020469 20020489 20020539 01/31/20 P 01/31/20 P 01/31/20 P 02/16/20 02/16/20 02/16/20 02/16/20 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 Teem Disability Life Insurance & Otber Life Insurance & Other Life Insurance & Other 02/13/20 P 30 135-65085-030-000 Office Supplies 02/13/20 P 30 135-65085-030-000 Office Supplies 02/18/20 02/24/20 02/24/20 02/26/20 P 20 135-55135-020-000 P 20 135-55135-020-000 P 20 135-55135-020-000 P 20 135-55135-020-000 9200690 996 02/21/20 P RAF0006187 3225 US Bank Voyager Fleet Systems 869338111009 3225 US Bank Voyager Fleet Systems 869338111009 02/21/20 P 02/24/20 P 02/24/20 P Lab Analysis Lab Analysis Lab Analysis Lab Analysis 135-21317-000-000 '1 RS 135-25045-000-000 10 135-65005-010-000 20 135-65005-020-000 TC0 Reg Assesaswnt Charge Fuel & Lube Fbel & Tube 9 of 157 AMENDED micilptch 1692f420 Regular Meeting Agenda PBeet 6 lane Item CbeCK Luecx Value archer Date 5,666.40 6225 02/28/20 1,325.18 6225 02/28/20 11,603.69 68.81 6226 02/28/20 68.81 2,236.96 6227 02/28/20 2,376.46 6227 02/28/20 4,613.42 17.46 6228 02/28/20 17.44 6228 02/28/20 34.90 125.00 6229 02/28/20 125.00 87.50 6230 02/28/20 869.06 6230 02/28/20 87.50 6230 02/28/20 1,044.06 74.36 6231 02/28/20 132.01 6231 02/28/20 165.74 6231 02/28/20 151.69 6231 02/28/20 523.80 01.95 6232 02/28/20 60.83 6232 02/28/20 62.78 341.55 6233 02/28/20 241.50 6233 02/28/20 341.55 6233 02/28/20 241.50 6233 02/28/20 1,166.10 7,865.96 6234 02/28/20 7,865.96 30,308.61 6235 02/28/20 30,308.61 945.56 6236 02/28/20 794.60 6236 02/28/20 AMENDED apackamt2 slo:olczyk Trophy Club NOD No.1 03 Rh 1®9 20 Regular Meeting Agenda P 01.4t@t 7 AP Checks For Date/Amotmt Range Begin Date: 02/01/2020 Sod Date: 02/29/2020 Fran Amt: .00 To Amt: 99,999,999.99 vearn ve nor tvame Number Totals for Check: 6236 JAvolce Ammer invoice Div Dept Acconnt £escxaptza3 Lame item cflecx taw= Date Stat NO Umber Value Number Date 2634 Valley Solvent CaTpany, INC 53051 Totals for Check: 6237 Grand Totals: ****** Enda Report ********* 02/18/20 P 10 135-65030-010-000 Chemicals 10 of 157 1,740.16 721.26 6237 02/28/20 721.26 503,225.09 AMENDED March 16, 2020 Regular Meeting Agenda Packet REGULAR MEETING MINUTES TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 BOARD OF DIRECTORS February 17, 2020 at 6:30 P.M. Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in a regular session meeting on February 17, 2020 at 6:30 P.M., in the Boardroom of the Administration Building, 100 Municipal Drive, Trophy Club, Texas 76262. The meeting was held within the boundaries of the District and was open to the public. STATE OF TEXAS COUNTIES OF DENTON AND TARRANT BOARD MEMBERS PRESENT: Gregory Wilson William C. Rose Steve Flynn Kelly Castonguay Mark Chapman STAFF PRESENT: Mike McMahon Laurie Slaght Steven Krolczyk Frank Isola Tony Corbett President Vice President Secretary/Treasurer Director Director § Acting General Manager District Secretary Finance Manager Wastewater Superintendent Legal Counsel CALL TO ORDER AND ANNOUNCE A QUORUM President Wilson announced the date of February 17, 2020, called the meeting to order and announced a quorum present at 6:30 p.m. CITIZEN COMMENTS There were no Citizen Comments CONSENT AGENDA 1. Consider and take appropriate action to approve the Consent Agenda. a. January 2020 Check Register b. January 20, 2020 Regular Meeting Minutes Motion made by Director Chapman and seconded by Director Flynn to approve the Consent Agenda as presented. Motion carried unanimously REGULAR SESSION 2. Consider and take appropriate action regarding approval of Fourth Amendment to Independent Contractor Agreement with John Carman for Consulting Services. 11 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet Motion made by Director Rose and seconded by Director Chapman moved to ratify and approve the Fourth Amendment to Independent Contractor Agreement with John Carman for Consulting Services. Motion carried unanimously 3. Consider and take appropriate action to authorize staff to issue a Request for Qualifications from qualified contractors to prepare a Water, Wastewater and Facility Master Planning and Risk and Resiliency Assessment to begin on October 1, 2020 as part of the Fiscal Year 2021 Capital Projects. This item is tabled 4. Presentation and discussion regarding hardness and turbidity in District water lines. Acting General Manager Mike McMahon presented information regarding hardness and turbidity in District lines and answered questions related thereto. Direction was provided to the Acting General Manager to put the presentation on the website. 5. Consider and take appropriate action to approve Joint Election Agreement and Contract for Election Services with Denton County for the May 2, 2020 General Election. Motion made by Director Rose and seconded by Director Castonguay to approve Joint Election Agreement and Contract for Election Services with Denton County for the May 2, 2020 General Election. Motion carried unanimously 6. Consider and take appropriate action to adopt Order No. 2020-0217A declaring the following operations equipment and vehicle to be to be surplus property of the District and authorizing staff to sell such surplus property: a. Truck No. 102 — 2012 Ford F250 king cab pick-up truck with 71,600 miles and purchased on February 7, 2012. b. 2020 Dodge Truck bed c. 2 - Automatic Transfer Switches Motion made by Director Rose and seconded by Director Flynn to adopt Order No. 2020-0217A Order Declaring Surplus and authorizing staff to sell such surplus with the change in Section 4 from "the General Manager" to say, "the Acting General Manager". Motion carried unanimously 7. Consider and take appropriate action regarding Fiscal Years 2020 — 2022 Audit Services: 12 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet a. Authorize staff to Issue a Request for Proposals for auditing services from qualified auditors. b. Appoint two directors to serve on Audit Committee to review proposals and develop recommendations to the Board of Directors for final selection of auditor. Motion made by Director Flynn and seconded by Director Chapman to appoint Director Flynn and Chapman authorize staff to issue a request for proposal for auditing services from qualified auditors for Fiscal Years 2020-2022 and to appoint Director Flynn and Director Chapman to an audit committee to review said proposals and provide a recommendation to the Board for selection and approval. Motion carried unanimously 8. Consider and take appropriate action regarding approval of Interlocal Agreement with the Texas Department of Transportation and the City of Southlake for the reimbursement of costs relating to the relocation of District infrastructure located at Kirkwood Blvd. and Highway 114. Motion made by Director Rose and seconded by Director Flynn to approve the revised Interlocal Agreement with the City of Southlake and the Trophy Club Municipal Utility District No. 1 regarding sanitary sewer line adjustments crossing SH114 as amended at the dais. Motion to amend by Director Wilson and seconded by Director Rose to amend allow the General Manager to transfer funds received by the Texas Department of Transportation to the City of Southlake. Motion to amend carried unanimously Motion as amended carried unanimously 9. Consider and take appropriate action regarding approval of a Proposal by CP&Y, Inc. for Professional Engineering Services relating to the Preparation of Design and Construction Documents for a Pressure Spray System at the Wastewater Treatment Plant Facility. Motion made by Director Rose and seconded by Director Chapman to approve the proposal by CP&Y, Inc. for Professional Engineering Services relating to the Preparation of Design and Construction Documents for a Pressure Spray System at the Wastewater Treatment Plant Facility in an amount not to $29,800.00. Motion carried unanimously 10. Discuss and take appropriate action concerning Acting General Manager compensation. (Rose/Flynn) Item is tabled for discussion in Executive Session 11. Consider and take appropriate action regarding the January 2020 Combined Financials and Variance Report. a. Combined Financials 13 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet b. Combined Variance Motion made by Director Flynn and seconded by Director Castonguay to approve the January 2020 combined financials and variance report. Motion carried unanimously REPORTS & UPDATES 12. Receive report from General Manager Hiring Committee. (Castonguay/Flynn) Director Flynn provided an update and presentation to the Board regarding the status of the search for a General Manager. 13. General Manager Monthly Reports and Update: a. Regulatory Update b. Capital Improvement Projects ■ WWTP Installation of Building and sound wall ■ High Service Pump Station Upgrade c. Water System Operations d. Wastewater System Operations e. Finance Update ■ Utility Billing Report ■ Permits Collected ■ Cash Report Acting General Manager Mike McMahon presented his monthly report to the Board and answered questions related thereto. The Board convened into Executive Session at 7:44 p.m. EXECUTIVE SESSION 14. Pursuant to Section 551.071 of the Texas Open Meetings Act, the Board may consult with its attorney in Executive Session on a matter in which the duty of the attorney to the Governmental Body under the Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflicts with the Open Meetings Act or to seek advice of counsel on legal matters involving pending or contemplated litigation or settlement offers: a. Contractor breach, performance and payment issues related to District's contract with Webber- Cadagua Partners for construction of the Wastewater Treatment Plant Improvements; and b. Trophy Club Municipal Utility District No. 1 v. Acadia Services, LLC, In the District Court of Tarrant County, 141st Judicial District (Cause No. 141-299351-18). c. Potential Condemnation of Easements required for construction and operation of Water Transmission Line Improvements from District Pump Station to Elevated Water Tank located on T.W. King Road 14 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet 15. Pursuant to Section 551.072 of the Texas Open Meetings Act, the Board may deliberate the purchase, exchange, lease, or value of real property if deliberation in an open meeting would have a detrimental effect on the position of the governmental body in negotiations with a third person: a. Sale or Exchange of District real property located at 100 Municipal Drive, 1501 Junction Way and other real property owned by the District. b. Purchase of Easements required for construction and operation of Water Transmission Line Improvements from District Pump Station to Elevated Water Tank located on T.W. King Road 16. Deliberations pursuant to Section 551.074(a)(1) of the Texas Open Meetings Act regarding the appointment, employment, evaluation, reassignment, duties, discipline, or dismissal of a public officer or employee: Acting General Manager The Board Reconvened into Regular Session at 9:04 p.m. REGULAR SESSION 17. Consider and take appropriate action on matters deliberated in Executive Session: Motion by Director Rose and seconded by Director Castonguay to approve an interim salary supplement for the Acting General Manager that equates to an annual salary of $160,000 for the time he is acting General manager. Motion carried unanimously 18. Items for future agendas: 19. Set future Meeting dates - Regular Board Meeting on March 16, 2020 at 6:30 p.m. ADJOURN Director Wilson called the meeting adjourned at 9:07 p.m. Gregory Wilson, President Steve Flynn, Secretary/Treasurer Laurie Slaght, District Secretary 15 of 157 (SEAL) AMENDED March 16, 2020 Regular Meeting Agenda Packet RATE ORDER TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO.1 ORDER NO. 2020-0316A AN ORDER ESTABLISHING POLICIES, PROCEDURES, AND RATES FOR WATER AND SEWER SERVICE; PROVIDING FEES FOR CONNECTION, RECONNECTION, INSPECTION, ACCURACY READINGS, AND RETURNED CHECKS; REQUIRING DEPOSITS FOR SERVICE; PROVIDING A PENALTY FOR DELINQUENT PAYMENTS; AND CONTAINING OTHER PROVISIONS RELATING TO THE SUBJECT. WHEREAS, Trophy Club Municipal Utility District No. 1 (the "District") is the owner and/or operator of a water and sewer system designed to serve present and future inhabitants within the District and the Trophy Club Development; and WHEREAS, the District's most recent Rate Order was adopted on September 16, 2019 (Order No 2019-0916A), and additional modifications are needed. The District desires to establish all of its rate policies in a single new Rate Order; and WHEREAS, the Board of Directors of the District has carefully considered the terms of this Rate Order No. 2020-0316A and is of the opinion that the following conditions and provisions should be established as the policies, procedures, and rates for obtaining service from the District's water and sewer system. THEREFORE, IT IS ORDERED BY THE BOARD OF DIRECTORS OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 THAT: ARTICLE I TAP FEES AND CONNECTION POLICY Section 1.01. Initiation of Water and Sanitary Sewer Connections. Each person desiring a water and sanitary sewer service connection to the District's System shall be required to pay such fees as set forth in this Order. No service shall be established or re-established until such fees are paid. All service connections are subject to all other rules, regulations, and policies of the District. A. Certification of System. Connections shall not be made to the District's System or portions of the System until the District's engineer or District staff has certified that the System or applicable portion thereof is operable and meets all regulatory requirements. B. Backflow Prevention. No water connections from any public drinking water supply system shall be allowed to any residential or commercial establishment where an actual or potential contamination hazard exists unless the public water facilities are protected from contamination. 16 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet At any residential or commercial establishment where an actual or potential contamination hazard exists, protection shall be required in the form of a backflow prevention assembly. The type of assembly required shall be specified by the District. The existence of potential contamination hazards without installation having been made of the means of control and prevention as set out in the preceding paragraph; or, the same having been installed, there is a failure to properly maintain the same, shall be considered sufficient grounds for immediate termination of water service. Service can be restored only when the health hazard no longer exists, or when the health hazard has been isolated from the public water system in accordance with the foregoing requirements. All backflow prevention assemblies that are required according to this section shall be tested upon installation by a recognized backflow prevention assembly tester and certified to be operating within specifications. Backflow prevention assemblies that are installed to provide protection against health hazards must also be tested and certified to be operating within specifications at least annually by a recognized backflow prevention assembly tester. The Customer shall, at his expense, properly install, test, and maintain any backflow prevention device required by this Rate Order. Copies of all testing and maintenance records shall be provided to the District within ten (10) days after maintenance and/or testing is performed. If the Customer fails to comply with the terms of this Order, the District shall, at its option, either terminate service to the property or properly install, test, and maintain an appropriate backflow prevention device at the service connection at the expense of the Customer. Any expenses associated with the enforcement of this agreement shall be billed to the Customer. C. Availability of Access/Obstructions. By application for connection to the District's System, the Customer shall be deemed to be granting to the District and its representatives a right of ingress and egress to and from the meter or point of service for such installation, maintenance and repair as the District, in its judgment, may deem reasonably necessary. The Customer shall also be deemed to be granting to the District and its representatives a right of ingress and egress to the Customer's property, including the exterior of the Customer's premises, for the purpose of performing the inspections and completing the Customer's Service Inspection Certifications required by the District's rules and regulations. Taps and connections will not be made when, in the opinion of the District, building materials or other debris obstructs the work area or the work area is not completed or finished to grade. When sidewalks, driveways or other improvements have been constructed prior to application for service, such application shall be construed and accepted as the Customer's waiver of a claim for any damages to such improvements resulting from the reasonable actions of the District in installation of the connection. 17 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet Section 1.02. Residential Fire Lines. Connections. and Fees. A residence of at least six -thousand (6,000) square feet but less than eight -thousand (8,000) square feet shall have installed on its one -inch (1") water service line, for fire protection, a one -inch (1") U -branch, with a separate meter and meter -box. The cost of installation, including parts, equipment, and labor shall be eight -hundred dollars ($800.00), payable at the time of permitting. A residence of eight -thousand (8,000) square feet or greater, in addition to its regular one - inch (1") water service line, shall have installed a separate one -and one-half (1 '/2 ") water service line for fire protection with its own meter and meter -box. The cost of connection and installation of the fire line and meter shall be either one thousand six hundred dollars ($1,600.00) if the home is on the same side of the street as the waterline; or, if it is on the opposite side of the street from the waterline, necessitating boring, then the charge shall be two thousand nine hundred seventy five dollars ($2,975.00), payable at the time of permitting to the District. Section 1.03. Connections by District. All Connections to the District's water and sewer system shall be made with written approval of the District and in accordance with the District's Plumbing Code and its rules and regulations. No person except the General Manager or his/her authorized agent shall be permitted to tap or make any connection to the mains or distribution piping of the District's water system, or make any repairs, additions to, or alterations in any meter, box, tap, pipe, cock or other fixture connected with the water system or any manhole, main, trunk or appurtenance of the District's sanitary sewer system. No sewer connection shall be covered in the ground and no house lead shall be covered in the ground before it has been inspected and approved by a licensed plumbing inspector with jurisdiction of the site. Section 1.04. Water and Sewer Tap Fees. Fees for water and sewer taps performed by the District are as follows: Water Service Taps: Size Fee for Tap Bore (if applicable) up to 1" Tap $1,200.00 $5,000.00 2" Tap $1,800.00 $10,000.00 3" Tap $4,500.00 $10,000.00 4" Tap $5,500.00 $10,000.00 6" Tap $6,500.00 $10,000.00 8" Tap $7,500.00 $10,000.00 10" Tap $8,500.00 $10,000.00 Sewer Service Taps: Actual cost plus 10%. An estimate will be provided prior to work being performed. 18 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet When water taps have been made by someone other than the District personnel, there is an installation/inspection fee of fifty dollars ($50.00) plus the cost of the appropriate meter. Section 1.05. Inspections and Fees. Fees for permits and for plumbing inspections (other than for sewer and backflow inspections referred to below in subparagraphs A and B) should be paid to the city or town in which the property is located or to the District if the property is not located within a city or town. A. Sewer Inspection and Fees. Sewer connections and house service lines shall be inspected by the District. An inspection fee of one -hundred -fifty dollars ($150.00) shall be paid to the District for each connection to the District sanitary sewer system. Installations that fail to conform at any time to the rules and regulations shall be disconnected. Any customer whose connection is disconnected for such failure shall be notified as to the basis for such disconnection. After noted deficiencies have been corrected, a re -inspection shall be made upon payment to the District of a re- inspection fee of twenty-five dollars ($25.00), plus payment by the customer of all outstanding charges. If subsequent re -inspections are required before the sewer connection and service lines are in compliance with the rules and regulations, a re- inspection fee of twenty-five dollars ($25.00) shall be paid to the District for each subsequent re -inspection. Inspections by the District requested after regular business hours will be charged at a minimum of one -hundred dollars ($100.00). B. Backflow Inspections. Backflow installations (residential and commercial) that require annual inspections must have a certified Backflow Technician perform the testing and submit the report annually to the District. C. Swimming Pool Discharge into Sanitary Sewer System. New swimming pools permitted on or after June 24, 2005, shall have all backwash and/or drainage from said pool discharge into the sanitary sewer system. Owners of pools built or permitted prior to July 1, 2005 are not required to retrofit the pool equipment and tie into the sanitary sewer. However, swimming pool backwash and drainage must drain to grassy areas and is not permitted to flow into the storm drain system, creeks, or other waterways. For swimming pools discharging to the sanitary sewer system, an indirect connection shall be made by means of an air break, discharging into a tailpiece installed a minimum of six inches (6") (or 152 mm) above adjacent grade. The tailpiece shall be connected to a minimum three-inch (3" or 76mm) p -trap not less than twelve inches (12" or 304 mm) below grade which discharges into the yard cleanout riser. Backwash systems shall not flow onto neighboring properties or into the storm sewer. The tie-in and inspection fee shall be seventy-five dollars ($75.00) to be paid at the time of issuance of the pool permit. 19 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet Section 1.06 Temporary Water Service -Construction Meters. A. Construction Meters. The District shall be authorized to make a temporary connection to any fire hydrant or flushing valve upon request for temporary water service. All temporary service shall be metered and billed to the temporary customer as provided herein. All unauthorized withdrawal of water from flushing valves, fire hydrants, or other appurtenances of the District's System is prohibited. B. Application and Deposit. Each temporary customer desiring temporary water service shall be required to execute an application for such temporary service and shall provide a minimum -security deposit of one -thousand -seven -hundred - seventy -five dollars ($1,775.00) for a three-inch (3") meter and RPZ; one -thousand - four -hundred -twenty-five dollars ($1,425.00) for a smaller meter and smaller RPZ. The deposit shall be made by cashier's check or money order payable to the District. The deposit shall be used by the District to secure the payment for temporary water supplied by the District, the installation fee, and the cost of repair of any damages caused by the temporary customer. The balance of the security deposit, if any, shall be refunded after disconnection from the District's System. C. Construction Meter Fees and Rates. Construction meters will be charged the same monthly rates (base fee and volumetric rate) for water as commercial accounts as set forth in Article II of this Rate Order. D. Temporary Construction Meter Use and Billing. Construction meters can be rented by filing an application at the District office and payment of all required deposits. Upon approval of the application, a temporary meter and RPZ will be provided to the applicant. Installation on any fire hydrant or flush valve must be approved by the District and District meters may only be used within the District's service area. The location of installation must be indicated on the application and cannot be relocated unless notification is provided to and approved by the District in advance. Temporary meters may only be rented for a period of ninety (90) days and extensions may be approved upon request and approval. Failure to return a temporary meter or request a usage extension by the due date will result in repossession of the meter and forfeiture of the deposit. Upon return of a temporary construction meter, an inspection of the meter and RPZ will be performed. Any and all damages to the meter and/or RPZ will be charged to the customer and deducted from the deposit. If the deposit does not cover the total amount of damages, the balance will be billed to the customer and payment must be received by the due date. Failure to pay all charges due will result in suspension of rental privileges until payment in full and may result in collection procedures. E. Return of Temporary Meter at District Request. The District reserves the right to request the return of a temporary construction meter at any time determined 20 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet necessary by the District. Should Stage 2 Drought Restrictions or more stringent restrictions be implemented, all temporary construction meters must be returned within three (3) business days of notification by the District. Failure to promptly return the temporary meter within three business days will result in repossession of the meter and forfeiture of the deposit. Should District personnel be unable to locate the temporary meter for repossession, theft charges will be filed against the meter holder with local law enforcement. Section 1.07 Service Outside the District. The rates and charges stated in this Rate Order are for services to customers and property located within the boundaries of the District. Any service to a customer or property located outside the boundaries of the District shall be granted only upon approval by the Board of Directors of the District. Out of District customers will pay the adopted rates for in district customers plus 15% for both water and sewer base and volumetric rates. For the purpose of customer classification, Trophy Club Park at Lake Grapevine is considered "in -district" and subject to all rates and service provisions related to in -district customers. Section 1.08 Service to New Development and Extension of Facilities. A. New Service Connections and Extension of Facilities. New service connections and extension of facilities must be constructed and installed in accordance with the District's Rules Governing New Service Connections and Extension of Facilities as approved through separate Resolution by the Board of Directors. Applicants for Non -Standard Service must submit all required information and pay all fees prior to conveyance of facilities and service commencement. B. Application Fee for Non -Standard Service. Upon request for non-standard service an application fee of $150 must be submitted. C. Design of Facilities. All water and wastewater facilities to be constructed to extend service to new developments must be designed by a professional engineer licensed in the State of Texas at the applicant's expense. The District must approve the plans and specifications prior to the commencement of construction. At the time of plan review submittal, the applicant must provide payment to the District in the amount of $2,500.00 as deposit for review of each set of plans and specifications reviewed by the District's engineer. The actual final fee for plan review by the District's engineer shall be provided to the applicant upon approval of the plans. If there is a balance due over the $2,500 paid by the applicant at submittal, the balance due shall be paid by the applicant prior to receiving District approval of plans and specifications. District construction plans, and specifications shall be strictly adhered to, but the District reserves the right to change order any specifications, due to unforeseen circumstances during the design or construction of the proposed facilities, or as otherwise authorized by applicable laws, to better facilitate the operation of the facility. All expenses and costs associated with a change order shall be charged to the 21 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet applicant. Service to new developments is subject to available capacity in the District's water and wastewater systems. All new potential developments must seek written approval from the General Manager that capacity is available to serve and may be required to install offsite improvements if capacity is not available with current system infrastructure. D. Inspection Fees. The District will inspect all infrastructure during construction. Inspection fees of $100 per lot must be paid to the District prior to a notice to proceed being issued. A minimum of $500 for inspection fees is required if less than five (5) lots are to be developed. Section 1.09 Water Meter Fees. METER SIZE WATER METER FEE 5/8" $279 1" $353 1-1/2" $736 2" Quoted at Time of Purchase 3" Quoted at Time of Purchase 4" Quoted at Time of Purchase 6" Quoted at Time of Purchase 8" Quoted at Time of Purchase 10" Quoted at Time of Purchase Fees must be received by the District before any connection is installed. A customer seeking service through an oversized connection line or from a meter larger than a one -inch (1") standard meter shall follow the District's policy for new development as outlined in Section 1.07 above. Should approval be granted by the District, the customer agrees to pay the water and sewer rates as outlined in Article II of this Rate Order. Section 1.10. Fort Worth Impact Fee. Each customer requesting an initial connection, shall also pay to the District the applicable City of Fort Worth Impact Fee. Section 1.11. Title to Facilities. Title to all water meters, water and sewer taps, and all other appurtenances, including meter boxes, shall lie in the District. 22 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet ARTICLE II SERVICE RATES Section 2.01. Water Service Rates. The following monthly rates for water service shall be in effect for each separate connection within the District. The base rate for each connection (meter) is calculated upon meter size and will be charged for each residential and commercial meter: (1) Water Rates BASE RATES: METER SIZE MONTHLY BASE RATE 5/8" & 3/4" $ 18.15 1" $ 34.11 1.5" $ 60.26 2" $ 91.63 3" $164.84 4" $269.43 6" $530.89 VOLUMETRIC RATES: Gallons Used 0 to 6,000 6,001 to 17,000 17,001 to 25,000 25,001 to 50,000 50,001 + (2) Multi -Unit Buildinas. Rate per 1000 gallons $3.96 $4.61 $5.34 $6.20 $7.21 Each multi -unit building (apartments, townhomes, business complex, etc.) served by a single 5/8" meter or 1" meter shall be billed the base rate for the meter size servicing the building multiplied by the number of units in the building or complex. 23 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet Section 2.02. Sewer Service Rates. The following monthly rates for the collection and disposal of sewage shall be in effect for each separate connection within the District: Residential Sewer Rates: The District uses winter averaging for the purpose of calculating sewer charges on utility bills. The sewer charges are based on average water consumption for three months (December, January and February billing). The average consumption will be analyzed annually and take effect the first of April each year. New customers will be assigned a default value user charge that is equal to the average winter water use for all residential customers. The winter average used for new residential customer is 7,000 gallons. A customer with a water leak during the averaging months may request a reduction in the sewer usage calculation. Any customer filling a pool after resurfacing, construction or major repairs during the averaging months may request that their winter average calculation be adjusted. Requests for a reduction in sewer usage calculations must be submitted in writing to the General Manager and have documentation showing the construction or repairs as applicable to the issue. The General Manager or a duly authorized representative may adjust the metered water usage in determining the winter average. To assist in establishing winter averaging sewer rates, customers are encouraged to submit requests for sewer average reductions no later than March 15th. A. Residential Sewer Rates: Effective April 1, 2020 Base Rate: 0 to 4,000 4,001 to 8,000 8,001 to 12,000 12,000+ Current Rates $ 20.60 $ 3.80 $ 5.40 $ 7.65 $ 10.90 B. Commercial Sewer Rates: Effective April 1, 2020 Scenario 1 $ 20.60 $ 4.25 $ 6.05 $ 8.55 $ 12.20 Scenario 2 $ 22.15 $ 4.10 $ 5.85 $ 8.25 $ 11.75 Current Rates Scenario 1 Scenario 2 Base Rate: $ 20.60 $ 20.60 $ 22.15 Volumetric Rate: $ 6.37 $ 7.18 $ 6.94 *Commercial sewer usage is billed based on actual water usage per month 24 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet C. Multi -Unit Buildings. Each multi -unit building (apartments, townhomes, business complex, etc.) shall be billed the base rate for each meter servicing the building and sewer usage will be billed based on actual water usage per month. Section 2.03 Effluent Charge. The effluent from the District's wastewater treatment plant will be sold pursuant to separate contracts entered into with the District and approved by its Board of Directors. Section 2.04. Master Meter (Cooling Tower Calculation). The water usage from the master meter reading minus the reading from the "Blow Down" meter equals the "evaporation." Water usage less "evaporation" equals sewer usage for billing purposes. Section 2.06. Regulatory Assessment. Pursuant to Section 5.235, Texas Water Code, and 30 TAC 291.76, the District shall collect and pay an annual regulatory assessment fee to the Texas Commission on Environmental Quality ("TCEQ") in the amount required by law on the total charges for retail water and sewer service billed to its customers annually. The regulatory assessment fee will be detailed separately on customer bills. Section 2.07. No Reduced Rates or Free Service. All customers receiving water and/or sewer service from the District shall be subject to the provisions of this Order and shall be charged the rates established in this Order. No reduced rate or free service shall be furnished to any customer whether such user be a charitable or eleemosynary institution, a political subdivision, or municipal corporation; provided, however, this provision shall not prohibit the District from establishing reasonable classifications of customers. ARTICLE III SERVICE POLICY Section 3.01. Security Deposits. Security deposits shall be required as follows: A. Builder's Deposit. A seventy-five dollar ($75.00) security deposit shall be required of builders for each tap made by the District for such service connection, payable at or prior to the time that such tap is made, and the security deposit is refundable to the builder when the account is later transferred to an owner if that account and all other accounts of the builder are current at the time of the transfer; but, if that account or any other account of the same builder is not current at the time of such transfer to an owner, then the security deposit shall be applied against the outstanding balance of the builder's account(s) at the time of such transfer. The District shall deduct from the deposit the cost to repair any damage caused to the District's property by the builder or the builder's employees, contractors, 25 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet subcontractors or agents and shall deduct any delinquent water and sewer service bills of the builder. In the event any amounts are deducted from the builder's deposit, it will be incumbent on the builder to reinstate the original amount of the deposit, and failure to do so will result in the suspension of any additional water taps for the builder. B. Residential Owners. A security deposit of seventy-five ($75.00) shall be required from each residential owner customer for a single-family home connected to the District's system. Upon discontinuation of service, the deposit shall be applied against amounts due, including disconnection fees. C. Commercial Deposits COMMERCIAL DEPOSITS METER SIZE WATER SEWER 3/4" $75 $60 1" $100 $100 1.5" $250 $200 2" $500 $320 3" $1,000 $700 4" $1,800 $1,200 6" $3,750 $2,500 8" $5,400 $3,600 D. Residential Lessees. A security deposit of one -hundred -fifty dollars ($150.00) shall be required from each residential lessee customer for a single-family home. Upon discontinuation of service, the deposit shall be applied against amounts due, including any disconnection fees. E. Construction Meters. See Section 1.06 above. F. Other customers. A security deposit equal to two (2) months estimated average monthly water and sewer bill shall be required of all other customers including commercial and multi -unit accounts. G. Deposits. The District does not pay interest on deposits. The interest drawn by the District on customer deposits is returned into the operating budget of the water/sewer fund to help in providing the lowest possible water and sewer rates for our customers. Section 3.02. Billing Procedures. All accounts shall be billed in accordance with the following: 26 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet A. Due Date and Delinquency. Charges for water and sewer service shall be billed monthly. Payment shall be due on or before the twentieth (20th) day of the month in the month in which the bill was received. Unless payment is received on or before the twentieth (20th) day of the month, such account shall be considered delinquent. If the due date falls on a holiday or weekend, the due date for payment purposes shall be the next working day after the due date. The District shall charge a penalty on past due accounts calculated at the rate of fifteen percent (15%) per month on water and sewer charges. The rates for water and sewer service shall depend upon the type of user and upon whether the water used has been chemically treated, as provided in this Rate Order. All accounts not paid by the due date shall be deemed delinquent and failure to make payment thereafter may result in the termination of water and sewer service. B. Notice and Appeal. Prior to termination of service, a customer who is delinquent in payment shall be sent a notice that service will be discontinued on or after the fifteenth (15th) day after the date of such notice unless payment in full is received before by such day disconnection is scheduled. Notice shall be sent by first class United States mail and shall inform the customer of the amount of the delinquent bill, the date service will be disconnected if payment is not made, and of the customer's right to contest, explain, or correct the charges, services, or disconnection. Service shall not be disconnected where a customer has informed the District of his or her desire to contest or explain the bill. If the customer appears before the Board, the Board shall hear and consider the matter and inform the customer of the Board's determination by sending written notice to the customer by first class United States mail stating whether or not service will be disconnected. In the event of a service is disconnected more than two (2) times per calendar year (January through December) for non-payment, an additional Security Deposit of $150.00 will be required for Residential homeowners and $150.00 for Lessees to restore service in addition to a $50.00 service fee, and afterhours re -connection charges if applicable, and any outstanding balance in Arrears will need to be brought current. As set out above in Section 3.01. If payment is not received prior to the date that disconnection has been scheduled, a service charge of $50.00 dollars will be added to the account. Reconnections made outside of the District's normal business hours at the customer's request will be charged at an additional after hour's fee of one -hundred dollars ($100.00). C. Business Hours. For purposes of assessing the foregoing charges, "normal" or "regular" business hours shall mean only the hours between 8 a.m. and 5 p.m., Monday through Friday. All other times, including District holidays, are outside of the District's normal business hours and will result in the higher charge. D. Returned Checks and Bank Drafts. A twenty -five -dollar ($25.00) charge will be charged to the customer's account for any check or ACH bank draft returned by 27 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet the bank. Any amounts due on an account which have been paid with a check or ACH bank draft that has been returned by the bank must be paid in full by cash, cashier's check or money order, including all late charges and returned check charges, within ten (10) days from the day the District mails notice to the customer or otherwise notifies the customer that the check or ACH bank draft has been returned by the bank. E. Same -Day Service. An additional charge of twenty-five dollars ($25.00) shall be made when a customer requests same-day service. As an example, this charge will be implemented upon request by a customer for same-day service to start or terminate water and sewer service or to perform re -reads the same day as requested. F. Accuracy Reading Fee. A meter accuracy reading fee in the amount of twenty-five dollars ($25.00) shall be charged to a customer by the District for each meter accuracy reading made by the District for such customer when the original reading appears to be accurate. If the original meter reading appears to be in error, no fee will be charged. Each customer will be allowed one accuracy meter reading per calendar year at no charge. **Should a customer request that a meter be removed, and bench tested by an outside source, then a fee of one -hundred -twenty- five dollars ($125.00) will be charged to the customer. If the meter fails to meet American Water Works Association standards for in-service meters, then the customer will be given a credit offsetting the amount of the charge. https://www.awwa.orq/publications/iournal-awwa/abstract/articleid/34055179.aspx G. Meter Data Logging Fee. Each customer will be allowed one data log at no - cost per fiscal year. A fee of twenty-five dollars ($25.00) shall be charged to a customer by the District for each meter data logging service performed thereafter. Meter data logging service can only be provided during regular business hours. Section 3.03. Entitlement. Water and sewer service shall be provided to customers in accordance with all TCEQ rules covering minimum water and sewer standards. Section 3.04. Unauthorized and Extraordinary Waste. The rates established herein are applicable for Domestic Waste as defined herein. Customers proposing to generate other types of waste will be assessed additional charges as established by the District. Section 3.05. Damacie to District Facilities. A. Damage to Meter and Appurtenances. No person other than a duly authorized agent of the District shall tamper with or in any way interfere with a meter, meter box, service line or other water and/or sewer system appurtenance. The District reserves the right, immediately and without notice, to remove the meter or disconnect water service to any customer whose meter has been tampered with and to assess repair charges to the customer, plus a damage fee not to exceed five -thousand 28 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet dollars ($5,000.00), plus any applicable charge for same day service. The District also reserves the right to file civil and/or criminal charges against any person or entity tampering with the District's public water system and/or sewer system. B. Repair. Absent any significant structural defect in that portion of a sewer line passing under the street, it shall be the responsibility of each customer to maintain the sewer line from the point of connection to the District's sewer system (the main) to the building served. In case of such significant structural defect, the District will bear the cost of remedying that defect. In either case, in order to provide access to that portion of the line under the street, in order to affect a necessary repair, the District will, at the District expense, break the street as necessary, and replace the street after the completion of repairs. It shall be the responsibility of and at the expense of the homeowner to provide to the District, through the General Manager or his or her designee, conclusive visual evidence that the problem with the homeowner's sewer line lies within the area beneath the street. To facilitate this determination, all building permits hereafter issued shall require that a one-way cleanout shall be made a part of the sewer line and placed at the point where the homeowner's property adjoins the street right of way. As to existing buildings, customer must provide access to the sewer line by a cleanout, either by one already in place or by one that the customer will have installed at customer's expense. Final determination of the necessity of repair of that portion of the sanitary sewer line beneath the street will reside exclusively with the District It is the responsibility of the customer to maintain and repair the water service line from the point of connection to the District's water meter. The District reserves the right to repair any damage to the District's System and appurtenances without prior notice and to assess against any customer such penalties as are provided by law and such penalties provided for in this Rate Order in addition to those charges necessary to repair the portion of the System so damaged. C. Video. If at any time a resident/customer wishes to have the District video their sewer line to help the resident determine the condition of their sewer line, the fee will be one - hundred -fifty dollars ($150.00) payable to the District assessed on the next month's bill. Section 3.06. Easements. Before service is established to any customer, the person requesting such service shall grant an easement of ingress and egress to and from the meter(s) for such maintenance and repair as the District, in its judgment, may deem necessary. Section 3.07. Required Service. No service will be provided by the District unless the customer agrees to receive both water and sewer service, except that permanent irrigation only 29 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet meters may receive water service only. Irrigation meters cannot be connected to any building plumbing. Section 3.08. Additional Charges. In all cases where services are performed, and equipment or supplies are furnished to a party or entity not within the District, the charge to said party or entity shall be the District's cost of providing such services, equipment and/or supplies, plus fifteen percent (15%). This shall not apply to services, equipment and/or supplies furnished by the District under an existing Interlocal Agreement. ARTICLE IV INDUSTRIAL WASTE Section 4.01. Industrial Waste Policy. The following policy regarding industrial waste shall be effective: A. Definition. "Industrial waste" shall mean the water -borne solids, liquids, and/or gaseous wastes (including Cooling Water), resulting from any industrial, manufacturing, trade, business, commercial, or food processing operation or process, or from the development of any natural resource, or any mixture of such solids, liquids, or wastes with water or domestic sewage. The Clean Water Act of 1977, as amended, and the General Pretreatment Regulations contained in 40 C.F.R. 403 contain the requirements for user's discharge of industrial waste into wastewater facilities. B. Industrial Waste Discharge, Charges, and Rates. If any customer of the District's sanitary sewer system proposes to discharge industrial waste into such system, the Board of Directors of the District shall request the recommendation of the District Engineer and shall establish rates and charges to provide for an equitable assessment of costs whereby such rates and charges for discharges of industrial waste correspond to the cost of waste treatment, taking into account the volume and strength of the industrial, domestic, commercial waste, and all other waste discharges treated and techniques of the treatment required. Such rates shall be an equitable system of cost recovery which is sufficient to produce revenues, in proportion to the percentage of industrial wastes proportionately relative to the total waste load to be treated by the District for the operation and maintenance of the treatment works, for the amortization of the District's indebtedness for the cost as may be necessary to assure adequate waste treatment on a continuing basis. C. Pretreatment. The Board of Directors of the District shall rely upon the recommendation of the District Engineer and shall require pretreatment of any industrial waste that would otherwise be detrimental to the treatment works or to its proper and efficient operation and maintenance or will otherwise prevent the entry of such industrial waste into the treatment plant. 30 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet ARTICLE V ENFORCEMENT/CIVIL PENALTIES Section 5.01. Enforcement. A. Civil Penalties. The Board hereby imposes the following civil penalties for breach of any rule of the District: The violator shall pay the District twice the costs the District has sustained due to the violation up to ten -thousand dollars ($10,000.00). A penalty under this Section is in addition to any other penalty provided by the laws of this State and may be enforced by complaints filed in the appropriate court of jurisdiction in the county in which the District's principal office or meeting place is located. If the District prevails in any suit to enforce its rules, it may, in the same action, recover any reasonable fees for attorneys, expert witnesses, and other costs incurred by the District before the court. The court shall fix the amount of the attorneys' fees. B. Liability for Costs. Any person violating any of the provisions of this Order and/or the rules and regulations governing water and sanitary sewer facilities, service lines, and connections shall become liable to the District for any expense, loss or damage occasioned by the District by reason of such violation, and enforcement thereof shall be in accordance with Paragraph A of Section 5.01 of this Order. Section 5.02. Non -waiver. The failure on the part of the District to enforce any section, clause, sentence, or provision of this Order shall not constitute a waiver of the right of the District later to enforce any section, clause, sentence, or provision of this Order. Section 5.03. Appeal. Any determination by the District of any dispute regarding the terms and provisions of this order may be appealed to the Board of Directors of the District, which shall conduct a hearing on the matter. The District shall provide the customer with information regarding appeals and hearing procedures upon the customer's request. ARTICLE VI MISCELLANEOUS Section 6.01. Amendments. The Board of the District has and specifically reserves the right to change, alter or amend any rate or provision of this Order at any time. Section 6.02. Severabilitv. The provisions of this Order are severable, and if any provision or part of this Order or the application thereof to any person or circumstance shall ever be held by any court of competent jurisdiction to be invalid or unconstitutional for any reason, the remainder of this Order and application of such provision or part of this Order shall not be affected thereby. 31 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet ARTICLE VII REPEAL OF PREVIOUS ORDERS This Rate Order shall be known as the "2020-0316A Rate Order" (Order No. 2020-0316A) of the District. All previous Orders adopted by the Board of Directors pertaining to the subject matter hereof are each hereby repealed in their entirety as of the effective date hereof. ARTICLE VIII EFFECTIVE DATE This Order shall be effective on April 1, 2020. ARTICLE IX PUBLIC MEETING It is hereby found that the meeting at which this Order is adopted is open to the public as required by law, and that public notice of the time, place, and subject matter of said meeting and of the proposed adoption of this Order was given as required by law. ADOPTED AND APPROVED this 16th day of March, 2020. Gregory Wilson, President Board of Directors Steve Flynn, Secretary/Treasurer Board of Directors 32 of 157 (SEAL) TROPHY CLUB MUNICIPAL UTILITY DISTRICT AMENDED March 16, 2020 Regular Meeting Agenda Packet STAFF REPORT Wastewater Treatment Plant Fence Replacement The existing fence at the wastewater treatment plant has met its life span and needs to be replaced. We have budgeted to replace half of the fence this year as part of the FY2020 Capital Improvement Projects and will budget for the completion of the project in FY2021. The following bids were received for this project: Felix Construction: $79,243.00 DFW Services LLC.: $77,874.00 Rey -Mar Construction: $49,978.00 Staff recommends awarding Contract No. 2020031601 to the low bidder, Rey -Mar Construction for an amount not to exceed $49,978.00, for fence replacement as part of FY2020 Capital Improvement Projects. Mike McMahon Acting General Manager 33 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet DFW Services, LLC Trophy Club MUD No. 1 8' Ornamental Fence & Gate Bid Date: 2-28-2020 Bid To: Trophy Club MUD No. 1 Item # Description Quantity Unit Unit Price Total WWTP 8' Fence & Gate 1 Om. 8' Fence 773 LF $ 88.00 $ 68,024.00 2 Replace Entry Gate Fence 1 LS $ 4,850.00 $ 4,850.00 3 Mob / Demob 1 LS $ 5,000.00 $ 5,000.00 $ 77,874.00 • Notes 1 DFW Services LLC. is licensed in Underground Fire. 2 DFW Services LLC . is on Oncor's WAS approved contractors list 3 DFW Services LLC. is currently NOT DBE Certified. 4 Permits, Fees, Lab Fees, Inspection Fees, Tap Fees, Meter Fees, and Impact Fees are Excluded. 5 Performance, Payment, & Maintenance Bonds are Excluded. 6 All work is bid prior to "Bluetopped" or Final grade. 7 Staking for our portion of work is excluded. 8 Sanitary facilities for our term of work are excluded. 9 Excludes any utility relocations not shown on plans. 10 Excludes rock excavation, if rock is encountered it will be removed at hourly rates 11 Excludes any topsoil, seeding, vegetation, sod watering or tree replacement 12 Excludes irrigation repair. 13 Excludes any buried debris removal. 14 DFW Services LLC. shall not be liable for any liquidated, actual, indirect, or consequential damages arising from any cause. 15 DFW Services LLC. is not liable for unforeseen, concealed conditions, or incorrect information that may be provided. 16 DFW Services LLC. will not be responsible for and will be indemnified from claims resulting from the pre-existence of any hazardous materials. 17 DFW has no liability for design. 18 DFW will not be responsible for and will be granted additional time and compensation for circumstances which it is not responsible or which are not in its control. 19 Upon completion and acceptance of DFW Services LLC's work by the owner, final payment should be made upon receipt of our invoice, with interest at (18%) eighteen percent per annum charged on any amount remaining unpaid (30) thirty days thereafter, together with reasonable attorneys fees and costs of collection, if incurred. 20 One Mobilization and applicable taxes are included. Mobilizations in excess of quoted amounts will result in additional charges. 21 SWPPP plan, implementation, or installation is excluded. 22 Contractor or Owner to provide adequate and safe access to work areas. 23 Bid is based upon a 50 hour work week excluding nights, holidays, & weekends. Any work required at these times will be billed at a higher rate. 24 Project is bid with (1) one crew. Additional workforces requested or accelerated schedules will result in additional charges. 25 Final connections to water, sewer, or roof drain are excluded unless specifically noted. 26 If staking is included CAD drawings must be made available for our surveyor. DFW will not do layout without CAD file. 27 Any item not specifically listed on this proposal is excluded. 28 This proposal must become part of any contract issued for this project 29 All items bid per plans dated June 2016 & agreement with David Martinez. 30 GeoTech report was not included. 32 All project info is required to start the project. Job name, bonding, owner info etc. DFW Services LLC. • 6309 Industrial Drive *Sachse Texas 75048 * 972-495-4400 • 800-510-3631 Fax 34 of f57 AMENDED March 16, 2020 Regular Meeting Agenda Packet Tuesday, March 10, 2020 Trophy Club MUD No.1 Mike McMahon mmcmahon@tcmud.org Attn: Mike McMahon Re: Wastewater Treatment Plant 8' Ornamental Fence Subject: Quote Mr. McMahon, Thank you for allowing us to quote the Wastewater treatment plant 8' ornamental fence replacement projects. Please see our quote and exclusions. Mobilization = 1,200.00 773 LF 8' ornamental fence = 70,343.00 Front Gate Replacement = 7,700.00 Total: $79,243.00 Grand Total: $79,234.00 Exclusions: • Sales Tax • Permits • Liquidated Damages If you have any questions or wish to discuss this matter further, please contact me at (469) 458-0011 or mobile (469) 404- 6716. Sincerely, Matt Phillips Felix Construction Company Project Manager Xc: FCC Project Files 35 of 157 3416 Reed Street Fort Worth, TX 76119 Date: 2-19-2020 AMENDED March 16, 2020 Regular Meeting Agenda Packet FORT WORTH, TX REY-MAR CONSTRUCTION PHONE (817) 535-3451 FAX (817) 535-0153 Reference: BID PROPOSAL: Trophy Club Municipal Utility District No.1 — Wastewater Treatment Plant 8' Ornamental Fence & Gates TO: Trophy Club Municipal Utility District RE: Mike McMahon Our scope of work shall include labor and materials as follows: • Mobilization to site — Transitions & traffic control • Installation of approximately 773 LF of 8' Ornamental Fence (black in color) • (1) 20' Gate to work in conjunction with the existing automated gate Bid Item Item Description Units Unit Price Total 1 Mobilization 1 1,800.00 1,800.00 773 8' Ornamental Fence 1 56.00 43,288.00 1 20' Gate 1 4,890.00 4,890.00 49,978.00 EXCLUSIONS: Are as followed: • Bonding (Add 2%) • Sales Taxes (where applicable) • Permits, easements & right-of-way • Material Testing Cost • Manifest of Hazardous materials — unforeseen materials • Liquidated Damages • Impact Fees • Landscaping, sod, & seeding. • Concrete Mow Strip 36 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet REQUEST FOR QUALIFICFATIONS PROFESSIONAL ENGINEERING SERVICES March 2020 This Request for Qualifications (RFQ) is being sent to professional engineering firms interested in providing Professional General Engineering Services (the "Services") to Trophy Club Municipal Utility District No. 1 (the "District") on an as needed basis. Qualified professional engineering firms should submit a Statement of Qualifications to the District before the close of business on , 2020. Under the Professional Service Procurement Act (Government Code, Chapter 2254, Subchapter A), the District will select an engineer based on demonstrated competence and qualifications to provide the Services. The District shall select the most highly qualified professional engineering firm on the basis of demonstrated competence and qualifications, and will then attempt to negotiate a contract with that firm at a fair and reasonable price. Proposals must be delivered to the following individual and address: Laurie Slaght, District Secretary Trophy Club Municipal Utility District No. 1 100 Municipal Drive Trophy Club, Texas 76262 Late submittals will not be considered. 37 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet The RFQ is organized as follows: SECTION 1.0 INTRODUCTION SECTION 2.0 SCOPE OF SERVICES SECTION 3.0 SUBMISSION CONTENT AND FORMAT SECTION 4.0 SCHEDULE SECTION 5.0 EVALUATION AND SELECTION PROCESS SECTION 6.0 SUBMISSION OF STATEMENT OF QUALIFICATIONS RFQ list of Attachments The following attachments are included in this RFQ. Attachment A Conflict of Interest Form 38 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet 1.0 INTRODUCTION 1.1 PROJECT BACKGROUND 1.1.1 Trophy Club Municipal Utility District No. 1 (the "District") is a municipal utility district created and operating pursuant to Article 16, Section 59 of the Texas Constitution and Chapters 49 and 54 of the Texas Water Code, as amended. The District is located within the corporate boundaries of the Town of Trophy Club and the Town of Westlake. The District provides retail water, wastewater, and drainage services. It also provides fire protection to its residents pursuant to an interlocal agreement with the Town of Trophy Club. The District provides water and wastewater services to approximately 4,800 customer accounts. It provides retail services to its own customers and provides wholesale and contract operation services to the Town of Trophy Club for Town residents located in the Town of Trophy Club Public Improvement District. The District purchases roughly 90% of its water from the City of Fort Worth on a wholesale base. The wholesale water supply is supplemented with groundwater produced from four wells. The District also owns and operates a wastewater treatment plant facility for sewer service. 1.1.2 The District currently works with certain professional engineering firms to provide engineering services on its behalf, but has need for additional professional design, inspection, troubleshooting, and/or engineering and consulting services. In order to maintain and upgrade the facilities, implement regional programs, and provide efficient, cost effective operations, the District wishes to obtain professional engineering services under a General Engineering Contract. Engineering projects will be contracted for on a task order basis as the need arises. 1.1.3 The specific scope of services sought by the District relates to the following areas with respect to the District's water, sewer and drainage facilities and operations: 1.1.3.1 Engineer Design and Related Services 1.1.3.3 Engineering and Construction Support Services 1.1.3.4 Regulatory Compliance Support Services 39 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet 2.0 SCOPE OF SERVICES 2.1 SCOPE OF SERVICES This Request for Qualifications has been developed to obtain professional engineering services related to the District's Water Treatment Plant, Distribution System, Wastewater Collection System, Wastewater Treatment Facility, and f o r Engineering Support Services. 2.1.1 Design and Related Services: Provide general consultation services on technical issues related to District facilities on an as -requested basis. The scope of work includes, but is not limited to, the following: 2.1.1.1 Preparation of engineering reports such as structural/geotechnical analyses. 2.1.1.2 Develop and produce complete, detailed, and biddable plans and specifications that will be part of an overall set of documents to be maintained by the District. Examples could include design of specific disciplines such as structural or mechanical. Provide and/or review an opinion of probable construction cost as requested. 2.1.1.3 Review and evaluate specific products or equipment information for incorporation into the specifications and as recommendations on values or gates. 2.1.1.4 Assist in or produce complete process analysis, reports, and recommendations in optimizing facility process operations, both formal and informal. This could include process or hydraulic modeling. 2.1.1.5 Provide design services for the following disciplines: HVAC; pumping and piping design; mechanical engineering; instrumentation and control; architecture; civil/site development; hydraulics; process engineering; and electrical engineering. This may include temporary staffing of an individual within a specific discipline (e.g., electrical, mechanical) at the District's facilities. 2.1.1.6 Assist the District in reviewing construction plans and proposals. 2.1.1.7 Assist in the development of facility record drawings with 40 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet personnel. 2.1.1.8 Any other professional services related to the District's Capital Improvement Projects as directed by the District. Provide general consultation services on technical issues related to District Facilities on an as -requested basis. The scope of work includes but is not limited to, the following: 2.1.2.1 Preparation of engineering reports, such as geotechnical/slope stability analyses and geotechnical baseline reports. 2.1.2.2 Develop and produce complete, detailed, and biddable plans and specifications that will be part of an overall set of documents to be compiled by the District. Provide an opinion of probable construction cost as requested. Types of designs could include minor water/sewer repairs (e.g., sewer/manhole spot repairs, major sewer repairs (e.g., slip lining, cured -in- place -pipe), trenchless sewer, and open cut sewer projects. 2.1.2.3 Review and evaluate specific products or equipment information for incorporation into the specifications. 2.1.2.4 Assist in or produce complete process analysis, reports, and recommendations such as pump station rehabilitation analyses and sewer system hydraulic modeling. 2.1.2.5 Provide design services for the following disciplines: HVAC; pumping and piping design; mechanical engineering; instrumentation and control; concrete and steel structures; architecture; civil/site development; hydraulics; process engineering; and electrical engineering. 2.1.2.8 Assist in the development of facility record drawings with District personnel. 2.1.2.9 Any other professional services related to the District's Capital Improvement Projects or Emergency Construction as directed by the District. 2.1.2.10 Perform surveying services, easement descriptions, deeds, and for acquisition of rights in real property. 2.1.3 Engineering and Construction Support Services 41 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet Provide services to supplement or enhance the various related support services provided to the Engineering and Construction related to District Facilities and various administrative functions on an as -requested basis. The scope of work includes but is not limited to, the following: 2.1.3.1 Support Service Requests — may include data analysis, collection, research, reporting or related tasks. 2.1.4 Regulatory Reporting Support Services Provide Regulatory Reporting assistance to the District on an as -needed basis. The scope of work includes assisting the District in the following areas, but is not limited to: 2.1.4.1 Permit renewal applications and/or renewal assistance; 2.1.4.2 Preparing for upcoming regulations and initiatives; 2.1.4.3 Preparation of reports and responses to/for regulatory agencies; 2.1.4.4 Specialized technical assistance; 2.1.4.5 Interpretation of environmental, health and/or safety impacts on Department Operations; 2.1.4.6 Hazard and risk assessments; 2.1.4.7 Sustainability -related projects including energy audits and waste stream analyses; 2.1.4.8 Other environmental and regulatory compliance studies and assessments. CONSULTANT'S RESPONSIBILITIES: For each Task Order authorized, the Engineer shall provide all engineering services necessary to develop and produce a complete deliverable that will satisfy the scope of work negotiated. The Consultant shall carefully consider the input by the District's staff, but based on the Consultant's own experience and ability, shall be solely responsible to provide a complete and workable deliverable in accordance with the requirements of the scope of work. DISTRICT'S RESPONSIBILITIES: 42 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet The District will, at the consultant's request, provide information and material on file that is pertinent to the task order authorized. This may include plan and profile sheets of existing services, standard drawings, specifications, etc. 2.2 TRANSFER OF RECORDS It is the intent of the District that the work effort be conducted in a manner that maximizes the District's flexibility regarding follow-up studies or design related efforts and other District projects. Software and software programs that would be necessary to achieve this shall be made available to the District. Utilization of proprietary software which cannot be made available to the District at the end of this project will not be allowed. All records (project reports, meeting notes, data files, project data, original tracings, maps, field sketches, lab reports, flow data, design calculations, graphic originals, electronic files, etc.) generated shall be the property of the District and shall be turned over to the District upon completion or as directed. All deliverables shall be required to be delivered to the District in hardcopy and electronic (original software and PDF) format. Depending on the size of the electronic deliverables, the consultant may be required to provide and utilize portable hard drive(s) for delivery. 2.3 AUTHORIZATION OF TASK ORDERS The District will negotiate the scope of services and the compensation with the selected Engineer prior to the authorization of a contract or task order. The method of payment under this Contract shall be based on a time and materials compensation, up to a negotiated not to exceed amount for each task order, including subcontracting costs and other direct costs with no markup allowed. 2.4 PROJECT MANAGEMENT Project management is a critical activity to be included within the execution of all tasks identified above. Utilize procedures related to cost estimating, scheduling, project documentation, risk management, QA/QC, and others as necessary to enhance budget, scope and time management. 43 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet In order to ensure that this improvement project is successfully completed in a timely manner and to the satisfaction of the District, the following project management items are being included in the scope of work for this project: 2.4.1 Monthly Project Summary Report The Consultant's project manager shall prepare a monthly project summary report within 7 working days of the close of the billing month. The monthly report shall include the following items (items that are required as part of the standard invoice need not be duplicated for the monthly reports): 2.4.1.1 A listing of work performed during the month and a listing of anticipated work during the next two months. Information shall be broken down by Tasks. 2.4.1.2 Consultant person -hours utilized to date, along with total person - hours allocated. This shall be done for each Task. Invoices for the period covered in the report, will not be paid until the monthly report is delivered to and approved by the District. 2.4.2 Project Meetings The Consultant's Project Manager shall meet, in person, with select District personnel monthly to review the progress of this project and to discuss any outstanding issues and potential problems. These meetings should include identification of work performed last period work to be completed next period, critical action item status, and responsible parties to complete actions. Budget or schedule problems shall be identified, and corrective actions noted. The Consultant shall prepare and deliver an agenda, a revised action items table and a revised risk register, as appropriate, 3 working days in advance of the meeting and shall prepare and deliver meeting minutes for review within 3 working days of the meeting. All draft submittals shall be in Word or Excel, and all final submittals shall be in PDF and delivered to the project manager. 44 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet It is also recommended that the Consultant's and the District's Project Manager hold telephone discussions as frequently as needed. The Consultant shall also make personnel available for meetings with the regulators to answer questions pertaining to design elements of the project. The District will take the lead in organizing, planning and conducting any meetings with the regulators. In support of the Project Management Plan, the consultant should anticipate the need for ongoing coordination meetings with the District. The Project Manager and other staff will be required to attend these meetings. The meetings will be conducted to distribute information and/or to get input from other staff members at the District. The meetings will be limited to a total of one per month. 2.4.3 Monthly Invoices The Consultant shall submit to the District monthly invoices detailing costs incurred in conjunction with this project. Each invoice shall cover a period of one calendar month (or a four-week time period) and shall be submitted to the District within 21 days of the close of the monthly billing cycle. Invoices submitted after this date shall be processed on the next monthly invoice review period. Prior to the start of this project, the Consultant's Project Manager shall meet with District personnel to review the District's invoicing requirements and format. The Consultant shall be required to submit their invoices in the District's specified format and via the District's SharePoint Website, using the specified workflow process. In the event that work is not progressing in a manner which is satisfactory to the District, monthly progress payments may be reduced. The recommended Project Management hours should be included in each of the specific tasks previously mentioned. 3.0 CONTENT AND FORMAT FOR STATEMENT OF QUALIFICATIONS 45 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet Each Consultant shall submit one original and seven (7) copies of the Statement of Qualifications. Submission shall be no more than 60 printed pages and be printed on double -sided recycled paper. The page count includes all submitted information except as indicated otherwise in this section. The page count includes project team resumes. The following information shall be included in the technical proposal: 3.1 EXECUTIVE SUMMARY Engineer should include an Executive Summary providing an overview of the firm's qualifications and competence to provide the Services. 3.2 QUALIFICATIONS Because of the critical nature of the work described within this Request for Qualifications, the District intends to obtain services from highly experienced and qualified firms. The firms must be able to staff this project with qualified individuals who shall remain committed to this work from inception through completion. The Consultant shall describe the availability and the commitment of resources for the Services. A discussion of the commitment and availability of key project personnel (Project Manager and designated task leaders) shall also be included. It is expected that the Consultant will honor their proposed project staffing in that all proposed individuals shall be assigned to the project. Substitutions will not be made or allowed for the convenience of the Consultant. In the event a proposed individual becomes unavailable the firm must propose in writing a substitution. The District reserves the right to accept or reject any and all proposed substitutions. The Consultant must demonstrate within their statement of qualifications that they have staff available to assume the responsibilities of the proposed project manager, proposed key design engineers, proposed construction administrator, and proposed resident representative in the event that the proposed individuals become unavailable. 46 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet 3.2.1 Team Qualifications Include the resume and office location of the proposed Project Manager and his or her proposed time commitment to the project. The District reserves the right to approve the proposed Project Manager, and if that individual leaves the firm during the project, to subsequently approve his or her replacement. Resumes of key staff members and/or sub -consultants proposed to work on the project as well as the guaranteed back-up personnel. The roles proposed for each sub -consultant as well as their qualifications in that area shall also be identified in the proposal. The District fully expects that personnel included in the proposal will be assigned to the project. Any personnel added to the project team or changes of personnel in significant roles shall be subject to advance approval by the District. 3.2.1.1 Proposed Project Manager The Consultant's proposed project manager must be experienced in multi- disciplined projects of the nature outlined in the request for proposals. The Consultant's proposed project manager must have within the last five years managed a project that included multi - disciplined design covering a range of disciplines identified in this request for proposals. It is expected that the Consultant's proposed project manager will manage the team within its local office and be available for frequent personal interaction with the District project management team. The project manager must meet the following requirements: The firms' proposed project manager must be a registered professional engineer in the State of Texas at the time of contract award and throughout the contract duration. 3.2.1.2 Proposed Key Program Leads and Designers 47 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet The following program lead capabilities must be demonstrated in the Consultant's response to the RFQ: x Wastewater Treatment Plant x Wastewater Collection System x Distribution System x Regulatory Compliance Services x Engineering Support Services 3.2.2 Firm Qualifications Provide a statement of the Firm's qualifications, including a description of three (3) of the most recent projects/programs/efforts that included similar scope of work. The following information shall be included for each project: x Start and end dates of project x Consultant fees and overall project budget x Engineers' construction cost estimate and final award amount x Consultant's role in project -highlight roles of staff x Contact information of reference person for project Owner The firms proposing to this work must meet all the requirements as outlined within this proposal or their submission shall be eliminated for consideration without any further consideration. x The firm must demonstrate successful experience in similar projects of each of the following categories: • Distribution System • Collection system and lift station design, rehabilitation, construction and start-up. • Water/Sewer pipeline replacement • Regulatory compliance • Engineering support services x The firm's experience in conducting projects of similar nature and 48 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet complexity, and the ability of the firm to draw upon this experience to benefit the District, should be submitted. References and contact information are to be submitted for projects submitted. x Describe the performance record of your team with regard to delivering quality products and services within scope, schedule, and budget. Describe how the team will assure quality performance for all services monitoring and timely delivering of invoices and client -required reports. Describe the record retention/document control methods to be used during this Contract. 3.3 STATEMENTS The Consultant shall include a statement confirming that no personal or organizational conflicts of interest are known to exist. 3.5 CERTIFICATION FORMS The Consultant shall provide in this section a completed and signed copy of the District's Declaration Regarding Material Assistance/No Assistance to a Terrorist Organization, included as Attachment I. 4.0 SCHEDULE AND LENGTH OF SERVICE The duration of the contract between the District and Engineer shall be a maximum of three years. Services rendered shall be funded under negotiated, not to exceed, amounts for individual task orders on an as needed basis. 5.0 EVALUATION AND SELECTION PROCESS 5.1 Once all Qualifications and Technical proposals have been received, the following steps will be followed to select the Consultant: 5.1.1. The written Statement of Qualifications will be evaluated by a District 49 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet Selection Committee based on an evaluation of demonstrated competence and qualifications. 5.1.2. Upon completion of the evaluation of the written submittals, the District may select the most highly qualified firms to deliver a presentation and provide further clarification of their competence and qualifications. The District may prepare and submit a list of questions to each of the short-listed firms to address during their interview. 5.1.3. After evaluation, the District will enter into negotiations with the most qualified selected firm to develop a final and mutually agreed-upon contract and fee structure. If an agreement cannot be reached with the highest ranked firm, the District may initiate negotiations with the next highest ranked firm. 5.1.4. District Staff will report to the Board of Directors and make a recommendation to enter into a contract with a firm. 50 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet 6.0 SUBMISSION OF STATEMENT OF QUALIFICATIONS One original and seven (7) copies of the Statement of Qualifications with seven (7) bookmarked .pdf copies of the proposal are to be delivered to the following names and address: Deadline for submission of proposals is ., ,2020. Late submittals will not be considered. All questions regarding this RFQ shall be directed to Mike McMahon, Acting General manager. by e- mailing to mmcmahon@tcmud.org. END OF RFQ ATTACHMENTS TO FOLLOW 51 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - FIRE DEPARTMENT BALANCE SHEET FEBRUARY 2020 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 1,057,493 PREPAID EXPENSES 11,486 ADVALOREM PROPERTY TAXES RECEIVABLE 62,340 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE TOTAL ASSETS 1,131,319 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES 62,346 TOTAL LIABILITIES 62,346 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE 603,769 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES 465,205 TOTAL FUND BALANCE 1,068,973 TOTAL LIABILITIES AND FUND BALANCE 1,131,319 52 of 157 glbase_tbam skrolczyk 11:28 03/10/20 Fund: 122 Trophy Club MUD Fire Dept. Account Description 122-40010-000-000 122-40011-000-000 122-40020-000-000 AMENDED March 16, 2020 Regular Meeting Agenda Packet Trophy Club MUD No.1 Budget Summary with Amendment Department: Fire Revenues Program: Period Ending: 2/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 Subtotal: Program number: Department number: Fire Revenues Revenues Subtotal 1,214,230.00- 1,214,230.00- 1,214,230.00- 1,214,230.00- 1,214,230.00- 1,214,230.00- 1,214,230.00- 1,214,230.00- 53 of 157 112,348.95- 1,196,917.88- 1,399.74- 2,421.97- 1,184.58- 2,832.30- 1 114 114 98.574 III 99.007 99.007 99.007 17,312.12- 2,421.97 2,832.30 2,057.85- 12,057.85- 12,057.85- 12,057.85- Page ,057.85-12,057.85-12,057.85- 12,057.85- Page glbase_tbam skrolczyk 11:28 03/10/20 Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Trophy Club MUD No.1 Budget Summary with Amendment AMENDED March 16, 2020 Regular Meeting Agenda Packet 122-60030-045-000 Rent And/Or Usage 218,004.00 218,004.00 122-60055-045-000 Insurance 21,000.00 21,000.00 122-60337-045-000 Transfer to Town/Fire Budget 718,657.00 718,657.00 tota1: 957,661.00 957,661.00 122-69005-045-000 122-69009-045-000 122-69195-045-000 122-69305-045-000 (Subtotal: Program number: Department number: Expenditures Capital Outlays Short Term Debt -Interest GASB34/Reserve for Replacement Capital Leases Fire Subtotal Fund number: 122 Trophy Club MUD Fire Dept. 48,000.00 48,000.00 81,420.00 81,420.00 127,149.00 127,149.00 256,569.00 256,569.00 1,214,230.00 1,214,230.00 1,214,230.00 1,214,230.00 1,214,230.00 1,214,230.00 54 of 157 218,004.00 1,640.88 59,888.08 218,004.00 8,204.40 299,440.40 279,532.96 525,648.80 279,532.96 279,532.96 279,532.96 164,599.69 2,750.00 11,958.24 81,420.00 115,190.36 -116.318211111 736,967.'1111 736,967.477-- 736,967.40 465,204.75- 100.000 39.069 41.667 54.889 5.729 12,795.60 419,216.60 432,012.20 45,250.00 11,958.24- 100.000 90.595 11,958.64 82.363 60.694 60.694 60.694 45, 477,262. 477,262. 477,262. 465, Page 2 glpdatb2 skrolczyk 11:28 03/10/20 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description AMENDED March 16, 2020 Regular Meeting Agenda Packet Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Fire Revenues Program: Period Ending: 2/2020 JE Detail Beginning Transaction Transaction Vendor Name Description/Comment Balance Detail Detail (SUBTOTAL) Page 1 Check Source Number Property Taxes/MUD Fire 867 02/03/2020 Property Taxes 870 02/04/2020 property taxes 871 02/05/2020 property taxes 872 02/06/2020 property taxes 875 02/07/2020 property taxes 876 02/10/2020 property taxes 877 02/11/2020 property taxes 878 02/12/2020 property taxes 879 02/13/2020 property taxes 880 02/18/2020 property taxes 881 02/19/2020 property taxes 882 02/20/2020 property taxes 883 02/21/2020 property taxes 884 02/24/2020 property taxes 885 02/25/2020 property taxes 886 02/26/2020 property taxes 887 02/27/2020 property taxes 886 02/28/2020 property taxes Account: 122-40010-000-000 Property Taxes/MUD Fir (1,214,230.00) Budgeted (17,312.12) (1,084,568.93) Remaining 99 Used (17,604.47) (1,102,173.40) (14,414.19) (1,116,587.59) (16,288.12) (1,132,875.71) (13,003.35) (1,145,879.06) (40,269.70) (1,186,148.76) (255.96) (1,186,404.72) (16.89) (1,186,421.61) (.07) (1,186,421.68) (603.61) (1,187,025.29) (270.02) (1,187,295.31) (.03) (1,187,295.34) (319.78) (1,187,615.12) (868.20) (1,188,483.32) (2,688.22) (1,191,171.54) (474.02) (1,191,645.56) (412.69) (1,192,058.25) (2,022.18) (1,194,080.43) (2,837.45) (1,196,917.88) GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL Property Taxes/Fire-Delinquent 867 02/03/2020 Property Taxes 871 02/05/2020 property taxes 872 02/06/2020 property taxes 875 02/07/2020 property taxes 880 02/18/2020 property taxes 886 02/26/2020 property taxes 887 02/27/2020 property taxes Account: Account: 122-40020-000-0 867 02/03/2020 Property Taxes 870 02/04/2020 property taxes 871 02/05/2020 property taxes 872 02/06/2020 property taxes 875 02/07/2020 property taxes Property Taxes/Fire-Delinquent Total= .00 Budgeted 2,421.97 Remaining Property Taxes/Fire P62 (1,022.23) 0 (1,647.72) Used 55 of 157 (91.49) (1,113.72) (6.07) (1,119.79) (1,279.39) (2,399.18) (.01) (2,399.19) .01 (2,399.18) (10.04) (2,409.22) (12.75) (2,421.97) (24.33) (1,672.05) (1.69) (1,673.74) (9.26) (1,683.00) (283.02) (1,966.02) (135.72) (2,101.74) GL GL GL GL GL GL GL GL GL GL GL GL AMENDED March 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 2 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 876 02/10/2020 property taxes 877 02/11/2020 property taxes 879 02/13/2020 property taxes 880 02/18/2020 property taxes 882 02/20/2020 property taxes 883 02/21/2020 property taxes 884 02/24/2020 property taxes 885 02/25/2020 property taxes 886 02/26/2020 property taxes 887 02/27/2020 property taxes 888 02/28/2020 property taxes Account: 122-40020-000-000 Department Totals: Property Taxes/Fire PCI Totals: .00 Budgeted 2,832.30 Remaining (114,933.27) Monthly Total (1,647.72) (17.91) (2,119.65) GL (1.18) (2,120.83) GL (42.26) (2,163.09) GL (.67) (2,163.76) GL (22.39) (2,186.15) GL (60.78) (2,246.93) GL (188.15) (2,435.08) GL (28.47) (2,463.55) GL (31.10) (2,494.65) GL (147.82) (2,642.47) GL (189.83) (2,832.30) GL (1,184.58) (2,832.30) ** 0 % Used (1,202,172.15) ** (1,214,230.00) Budgeted (12,057.85) Remaining 99 % Used 56 of 157 glpdatb2 skrolczyk 11:28 03/10/20 Fund: 122 Trophy Club MUD Fire Dept. A000 Ac JE JE JE Number Date Description AMENDED March 16, 2020 Regular Meeting Agenda Packet Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 45 Fire Program: Period Ending: 2/2020 JE Detail Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Description/Comment -045-And Or 799 02/21/2020 Fire Rent Transfer 2020 Rent And/Or Usage 218,004.00 Budgeted Totals: .00 Remaining 218,004.00 100 % Used 218,004.00 Page 3 Check Source Number GL Account: 122-60055-045-000 Insurance 70 02/01/2020 Insurance/Wrk Comp Expense Feb 6,563.52 1,640.88 8,204.40 GL Account 727 02/06/2020 February A/P Account: 122-60337-045-0 Account: 122-69005-045-000 21,000.00 Budgeted 12,795.60 Remaining sfer to Town/Fire Budg Fire Admin February ^Pfansfer to 718,657.00 Budgeted Capital Outlays Account: 122-69005-045-000 Capital Outlays 48,000.00 Budgeted 419,216.60 239,552.32 Remaining 2,750.00 39 % Used 59,888.08 42 % Used 45,250.00 Remaining 6 % Used Account: 122-69009-045-000 Account: 122-69009-045-000 Short Term Debt -Interest Totals, .00 Budgeted (11,958.24) Remaining Account: 122-69195-045-000 GASB34/Reserve for Replacement Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: 81,420.00 Budgeted .00 Remaining 11,958.24 0 % Used 81,420.00 100 % Used 299,440.40 .00 2,750.00 .00 11,958.24 .00 81,420.00 TOWN OF TROPHY CLUB 6195 AP Account: 122-69305-045-000 Capital Leases 57 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Capital Leases Totals: 127,149.00 Budgeted 115,190.36 .00 115,190.36 11,958.64 Remaining 91 % Used Department 45 Totals: 736,967.40 •• 279,532.96 Monthly Total 1,214,230.00 Budgeted 477,262.60 Remaining 61 % Used Fund 122 Totals: (465,204.75) 164,599.69 Monthly Total .00 Budgeted 58 of 157 465,204.75 Remaining 0 % Used TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET FEBRUARY 2020 AMENDED March 16, 2020 Regular Meeting Agenda Packet 135 137 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 2,578,751 2,578,751 CASH IN BANK -SAVINGS -CASH RESERVE 1,601,459 1,601,459 INVESTMENTS-TEXPOOL 3,868,049 919,266 4,787,315 PREPAID EXPENSES 66,394 66,394 ADVALOREM PROPERTY TAXES RECEIVABLE 6,858 6,858 UTILITY AND OTHER ACCOUNTS RECEIVABLE 788,993 788,993 TOTAL ASSETS 8,911,105 919,266 9,830,371 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 6,858 6,858 ACCOUNTS AND OTHER PAYABLES 337,536 337,536 CUSTOMER DEPOSITS 318,975 318,975 TOTAL LIABILITIES 663,369 663,369 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 (153,648) (153,648) TOTAL FUND BALANCE 8,247,736 919,266 9,167,002 TOTAL LIABILITIES AND FUND BALANCE 8,911,105 919,266 9,830,371 59 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet glbase_tbam skrolczyk Trophy Club MUD No.1 Page 3 11:28 03/10/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 135-40002-000-000 135-40015-000-000 135-40025-000-000 Property Taxes Property Taxes/Delinquent Property Taxes/P & I PID Surcharges 134,871.00- 134,871.00- 300.00- 300.00- 300.00- 300.00- 164,253.00- 164,253.00- 12,472.09- 129.30- 121.30- 132,872.45- 246.29- 305.45- 98.518 82.097 101.817 1,998.55- 53.71- 5.45 164,253.00- 135-47000-000-000 Water 6,486,623.00- 6,486,623.00- 135-47005-000-000 Sewer 3,503,885.00- 3,503,885.00- 135-47025-000-000 Penalties 112,608.00- 112,608.00- 135-47030-000-000 Service Charges 15,150.00- 15,150.00- 135-47035-000-000 Plumbing Inspections 750.00- 750.00- 135-47045-000-000 Sewer Inspections 2,500.00- 2,500.00- 135-47070-000-000 TCCC Effluent Charges 50,000.00- 50,000.00- 10,171,516.00- 10,171,516.00- 135-49011-000-000 135-49016-000-000 135-49018-000-000 135-49026-000-000 135-49075-000-000 135-49900-000-000 Interest Income Cell Tower Revenue Building Rent Income Proceeds from Sale of Assets Oversize Meter Reimbursement Miscellaneous Income ENSubtots. Program number: Department number: Revenues Revenues Subtotal 120,000.00- 120,000.00- 14,146.00- 14,146.00- 7,000.00- 7,000.00- 13,000.00- 13,000.00- 12,691.00- 12,691.00- 7,000.00- 7,000.00- 173,837.00- 0- 10,645,077.00- 0- 10,645,077.00- 1(110- 10,645,077.00- 60 of 157 282,378.00- 255,789.09- 10,829.62- 2,050.00- 100.00- 300.00- 6.71- 9,871.98- 2,357.62- 583.33- 610.00- 188.22- 1,805,515.03- 1,251,049.59- 45,896.48- 8,800.00- 2,250.00- 1,350.00- 15,068.00- 27.834 35.705 40.758 58.086 300.000 54.000 30.136 4,681,107.97- 2,252,835.41- 66,711.52- 6,350.00- 1,500.00 1,150.00- 34,932.00- 3,129,929.10-.772 7,041,586 13,611.15- 577,780.55- 3 577,780.5 577,780.55- 51,811.06- 5,894.05- 2,916.65- 43.176 41.666 41.666 7,730.28- 60.912 8,341.76- 119.168 68,188.94- 8,251.95- 4,083.35- 13,000.00- 4,960.72- 1,341.76 8,188.94-8,251.95-4,083.35-13,000.00- 4,960.72- 1,341.76 AMENDED March 16, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 350,267.00 350,267.00 135-50010-010-000 Overtime 17,000.00 17,000.00 135-50016-010-000 Longevity 3,920.00 3,920.00 135-50017-010-000 Certification 5,400.00 5,400.00 135-50020-010-000 Retirement 34,863.00 34,863.00 135-50026-010-000 Medical Insurance 84,326.00 84,326.00 135-50027-010-000 Dental Insurance 4,725.00 4,725.00 135-50028-010-000 Vision Insurance 767.00 767.00 135-50029-010-000 Life Insurance & Other 3,132.00 3,132.00 135-50030-010-000 Social Security Taxes 23,348.00 23,348.00 135-50035-010-000 Medicare Taxes 5,461.00 5,461.00 135-50040-010-000 Unemployment Taxes 1,080.00 1,080.00 135-50045-010-000 Workman's Compensation 11,850.00 11,850.00 135-50060-010-000 Pre-emp Physicals/Testing 400.00 400.00 135-50070-010-000 Employee Relations 300.00 300.00 FSubtotal: ' 546,839.00 546,839.00 135-55005-010-000 Engineering 135-55080-010-000 Maintenance & Repairs 135-55085-010-000 Generator Maint. and Repair 135-55090-010-000 Vehicle Maintenance 135-55105-010-000 Maintenance-Backhoe/SkidLoader 135-55120-010-000 Cleaning Services 135-55135-010-000 Lab Analysis 20,000.00 20,000.00 100,000.00 100,000.00 3,000.00 3,000.00 5,000.00 5,000.00 3,500.00 3,500.00 1,000.00 1,000.00 7,500.00 7,500.00 27,843.01 132,263.00 1,214.08 8,861.76 5,082.50 425.00 2,075.00 2,730.05 14,802.58 5,225.04 24,378.62 316.63 1,481.48 48.18 236.11 328.89 1,552.66 1,813.45 9,090.21 424.11 2,125.91 18.49 63.65 771.49 3,857.45 37.761 52.128 129.656 38.426 42.459 28.910 31.354 30.784 49.574 38.934 38.929 5.894 32.552 218,004.00 8,138.24 1,162.50- 3,325.00 20,060.42 59,947.38 3,243.52 530.89 1,579.34 14,257.79 3,335.09 1,016.35 7,992.55 400.00 300.00 Page 4 41,158.42 205,870.93 340,968.07 2,100.46 23,276.50 286.02 727.67 920.37 87.50 350.00 250.00 1,597.70 23.277 14.553 26.296 35.000 21.303 20,000.00 76,723.50 3,000.00 4,272.33 2,579.63 650.00 5,902.30 1 135-60010-010-000 Communications/Mobiles 135-60020-010-000 Electricity 135-60066-010-000 Publications/Books/Subscripts 135-60070-010-000 Dues & Memberships 135-60080-010-000 Schools & Training 135-60090-010-000 Safety Program 135-60100-010-000 Travel & per diem 135-60105-010-000 Rent/Lease Equipment 135-60135-010-000 TCHQ Fees & Permits 135-60150-010-000 Wholesale Water 135-60245-010-000 Miscellaneous Expenses 135-60280-010-000 Property Maintenance 135-60285-010-000 Lawn Equipment & Maintenance 135-60332-010-000 Interfund Transfer Out -Rev I&S 135-60333-010-000 Interfund Transfer Out -Reserve 135-60334-010-000 Interfund Transfer Out 5,000.00 5,000.00 125,677.00 125,677.00 1,000.00 1,000.00 500.00 500.00 7,426.00 7,426.00 400.00 400.00 2,845.00 2,845.00 1,500.00 1,500.00 63,000.00 63,000.00 2,714,710.00 2,714,710.00 200.00 200.00 3,000.00 3,000.00 14,750.00 14,750.00 527,381.00 527,381.00 55,193.00 55,193.00 180,000.00 180,000.00 61 of 157 424.30 2,472.95 6,824.77 46,151.60 790.00 1,196.00 2,685.69 16,942.84 103,065.44 572,020.73 294.00 756.00 116,631.80 308,406.76 4,600.00 23,000.00 49.459 2,527.05 36.722 79,525.40 1,000.00 500.00 16.106 6,230.00 400.00 2,845.00 1,500.00 26.893 46,057.16 21.071 2,142,689.27 200.00 25.200 2,244.00 14,750.00 58.479 218,974.24 41.672 32,193.00 180,000.00 I: . glbase_tbam skrolczyk 11:28 03/10/20 Fund: 135 MUD 1 General Fund Account 1 1 135-60360-010-000 1 Description Furniture/Equipment < $5000 Department: Adopted Budget Trophy Club MUD No.1 Budget Summary with Amendment 10 Water Period Ending: 2/2020 Program: AMENDED March 16, 2020 Regular Meeting Agenda Packet Amended Total Current YTD % of Remaining Budget Encumb. Month Total Budget Budget 2,500.00 2,500.00 561.72 22.469 1,938.28 Page 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, 62 of 157 945.56 4,514.91 2,917.33 1,391.35 9,016.50 765.00 16,869.78 36,900.00 10,920.00 176,710.03 30,512.00 1,840.00 75,000.00 102,077.11 30.099 10,485.09 56.211 2,272.67 45.083 10,983.50 1,200.00 1,000.00 24.100 53,130.22 42.414 50,100.00 25.802 100.000 56.948 100.000 85.064 17 508,164.97 1,391.00 17,922.89 ,478.86 9.57 AMENDED March 16, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 2/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 63 of 157 80.00 80.00 80.00 31 547.70 547.70 547.70 1,661,157.13 27.385 1,452.30 27.385 1,452.30 27.385 1,452.30 30.165 3,845,771.87 Page 6 AMENDED March 16, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 Page 7 11:28 03/10/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/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 31,660.78 150,837.93 34.142 290,961.07 135-50010-020-000 Overtime 33,000.00 33,000.00 1,700.03 9,765.30 29.592 23,234.70 135-50016-020-000 Longevity 8,035.00 8,035.00 6,872.50 85.532 1,162.50 135-50017-020-000 Certification 9,000.00 9,000.00 650.00 3,200.00 35.556 5,800.00 135-50020-020-000 Retirement 45,531.00 45,531.00 3,149.40 17,332.99 38.069 28,198.01 135-50026-020-000 Medical Insurance 104,858.00 104,858.00 7,738.24 33,790.07 32.225 71,067.93 135-50027-020-000 Dental Insurance 5,817.00 5,817.00 446.90 1,985.42 34.131 3,831.58 135-50028-020-000 Vision Insurance 948.00 948.00 69.74 320.43 33.801 627.57 135-50029-020-000 Life Insurance & Other 4,500.00 4,500.00 396.07 1,786.43 39.698 2,713.57 135-50030-020-000 Social Security Taxes 30,494.00 30,494.00 1,963.61 9,915.32 32.516 20,578.68 135-50035-020-000 Medicare Taxes 7,132.00 7,132.00 459.24 2,318.90 32.514 4,813.10 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 24.56 59.12 4.692 1,200.88 135-50045-020-000 Workman's Compensation 15,373.00 15,373.00 1,110.20 5,551.00 36.109 9,822.00 135-50060-020-000 Pre-emp Physicals/Testing 400.00 400.00 38.00 38.00 9.500 362.00 135-50070-020-000 Employee Relations 300.00 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 & Revairs 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 3,000.00 20.000 6,728.71 35,443.88 40.277 2,299.33 17,677.78 176.778 60.00 742.98 18.575 53.99 1,986.94 24.837 54.99 559.67 18.656 87.50 350.00 23.333 5,692.84 38,479.62 38.480 2,332.20 15,048.65 37.622 30,000.00 12,000.00 52,556.12 7,677.78- 10,000.00 3,257.02 6,013.06 2,440.33 1,150.00 61,520.38 24,951.35 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 64 of 157 408.87 2,679.40 53.588 2,320.60 12,969.80 60,843.27 38.011 99,223.73 200.00 111.00 37.000 189.00 521.00 2,431.85 48.734 2,558.15 109.14 10.914 890.86 360.84 23.355 1,184.16 5,000.00 2,500.00 10,088.02 67.253 4,911.98 450.00 584.94 584.94 11.699 4,415.06 AMENDED March 16, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60285-020-000 135-60331-020-000 135-60332-020-000 135-60333-020-000 135-60334-020-000 135-60360-020-000 Lawn Equipment & Maintenance Interfund Transfer Out -Tax I&S Interfund Transfer Out -Rev I&S Interfund Transfer Out -Reserve Interfund Transfer Out Furniture/Equipment < $5000 14,000.00 114,563.00 673,867.00 125,187.00 180,000.00 2,000.00 14,000.00 114,563.00 673,867.00 125,187.00 180,000.00 2,000.00 Subtotal: 1,310,669.00 r 135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 135-65010-020-000 Uniforms 5,495.00 5,495.00 135-65030-020-000 Chemicals 20,000.00 20,000.00 135-65031-020-000 Chemicals Collections 17,500.00 17,500.00 135-65035-020-000 Small Tools 1,200.00 1,200.00 135-65040-020-000 Safety Equipment 1,200.00 1,200.00 135-65045-020-000 Lab Supplies 20,000.00 20,000.00 10,414.81 81,777.91 5,750.00 112,427.33 794.60 2,856.60 22.71 14,000.00 52,074.05 45.455 62,488.95 326,820.11 48.499 347,046.89 28,750.00 22.966 96,437.00 180,000.00 190.00 9.500 1,810.00 Page 8 485,042.62 825,626.38 3,755.00 30.040 8,745.00 3,507.93 63.839 1,987.07 12,724.87 63.624 7,275.13 4,994.00 28.537 12,506.00 1,200.00 1,111.63 92.636 88.37 10,837.36 54.187 9,162.64 135-69005-020-000 135-69008-020-000 135-69009-020-000 135-69195-020-000 Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Subtota.- Program number: Department number: Wastewater 530,500.00 79,133.00 11,277.00 130,000.00 530,500.00 79,133.00 11,277.00 130,000.00 750,910.00 3,157,421.00 3,157,421.00 65 of 157 14,155.80 14,155.80 196,973.37 • 196,973.37 1, 160,027.89 30.165 370,472.11 59,604.74 75.322 19,528.26 6,122.03 54.288 5,154.97 130,000.00 100.000 395,155.34 1,922,630.00 1,922,630. glbase_tbam skrolczyk 11:28 03/10/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: 2/2020 Adopted Amended Total Current Budget Budget Encumb. Month 30.00 30.00 1.99 Program: YTD Total 9.95 AMENDED March 16, 2020 Regular Meeting Agenda Packet % of Remaining Budget Budget 33.167 20.05 Page 9 135-60066-026-000 135-60070-026-000 135-60075-026-000 135-60080-026-000 135-60100-026-000 135-60245-026-000 Publications/Books/Subscripts Dues & Memberships Meetings Schools & Training Travel & per diem Miscellaneous Expenses 150.00 750.00 1,300.00 4,000.00 5,000.00 2,000.00 150.00 750.00 1,300.00 4,000.00 5,000.00 2,000.00 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 861.23 6.510 12,368.77 L Department number: Board of Directors 13,230.00 13,230.00 1.99 861.23 6.510 12,368.77 66 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 628,298.00 628,298.00 30,149.14 149,265.50 23.757 479,032.50 135-50010-030-000 Overtime 2,000.00 2,000.00 3.96 20.53 1.027 1,979.47 135-50016-030-000 Longevity 2,208.00 2,208.00 2,207.50 99.977 .50 135-50020-030-000 Retirement 58,554.00 58,554.00 2,792.20 15,524.98 26.514 43,029.02 135-50026-030-000 Medical Insurance 124,394.00 124,394.00 6,345.77 29,157.97 23.440 95,236.03 135-50027-030-000 Dental Insurance 6,464.00 6,464.00 349.75 1,618.70 25.042 4,845.30 135-50028-030-000 Vision Insurance 1,035.00 1,035.00 51.68 249.67 24.123 785.33 135-50029-030-000 Life Insurance & Other 4,500.00 4,500.00 343.91 1,635.45 36.343 2,864.55 135-50030-030-000 Social Security Taxes 39,215.00 39,215.00 1,723.34 8,790.85 22.417 30,424.15 135-50035-030-000 Medicare Taxes 9,171.00 9,171.00 403.03 2,055.95 22.418 7,115.05 135-50040-030-000 Unemployment Taxes 1,440.00 1,440.00 16.50 46.66 3.240 1,393.34 135-50045-030-000 Workman's Compensation 1,775.00 1,775.00 104.82 524.10 29.527 1,250.90 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 500.00 135-50070-030-000 Employee Relations 8,000.00 8,000.00 3,078.10 38.476 4,921.90 Page 10 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 1,568.43 126,842.65 94.180 7,838.35 240.00- 54,584.49 40.433 80,415.51 1,165.00 7.767 13,835.00 531.00 531.00 5.310 9,469.00 869.06 3,476.24 34.762 6,523.76 65,600.00 2,474.81 27.498 6,525.19 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 67 of 157 1,273.96 237.75 718.11 142.72 5,403.21 6,998.39 119.00 3,333.49 7,399.55 31.248 1,189.56 29.739 2,000.54 29.082 383.89 25.593 6,806.80 22.689 31,422.04 46.899 31,430.09 37.417 125.00 12.500 4,285.55 71.426 61.37 15.343 3,809.69 63.495 10.50 1,163.21 16.981 695.14 19.609 95.03 138.04 16,280.45 2,810.44 4,878.46 1,116.11 23,193.20 35,577.96 1,500.00 52,569.91 875.00 1,714.45 338.63 2,190.31 5,686.79 2,849.86 200.00 138.04- 2,500.00 AMENDED March 16, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/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 135-65010-030-000 Uniforms 135-65055-030-000 Hardware 135-65085-030-000 Office Supplies 135-65090-030-000 Printer Supplies & Maintenance 135-65095-030-000 Maintenance Supplies 135-65105-030-000 Printing 135-69005-030-000 Capital Outlays 135-69170-030-000 Copier Lease Installments Program number: Department number: Administration 1,288.00 1,288.00 500.00 500.00 17,000.00 17,000.00 2,500.00 2,500.00 2,050.00 2,050.00 26,485.00 26,485.00 6,000.00 6,000.00 3,500.00 3,500.00 4,000.00 4,000.00 2,500.00 2,500.00 195,000.00 4,000.00 195,000.00 4,000.00 ,000.00 712.00 .712.00 68 of 157 24.00 120.00 9.317 18,356.16 91,030.47 135.77 302.18 47.39 233.81 3,235.24 12.215 2,002.24 33.371 2,698.80 47.39 1,271.47 67.470 .024 31.787 50 1 50 1 1,168.00 500.00 17,000.00 2,500.00 2,050.00 23,249.76 3,997.76 3,500.00 1,301.20 2,500.00 194,952.61 2,728.53 1,273,176.24 1,273,176.24 Page 11 glbase_tbam skrolczyk 11:28 03/10/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 AMENDED March 16, 2020 Regular Meeting Agenda Packet Trophy Club MUD No.1 Budget Summary with Amendment Department: 39 Non Departmental Program: Period Ending: 2/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135,000.00 33,800.00 11,761.00 4,000.00 135,000.00 33,800.00 11,761.00 4,000.00 10,666.00 56,702.39 27,713.27 5,178.56 3,756.00 42.002 81.992 44.032 93.900 78,297.61 6,086.73 6,582.44 244.00 Page 12 69 of 157 p• Subtotal: ' 184,561.00 184,561.00 10,666.00 93,350.22 50.580 91,210.78 Program number: 184,561.00 184,561.00 10,666.00 93,350.22 50.580 91,210.78 Department number: Non Departmental 184,561.00 184,561.00 10,666.00 93,350.22 50.580 91,210.78 Expenditures Subtotal 10,638,853.00 10,638,853.00 565,029.57 3,493,695.34 32.839 7,145,157.66 Fund number: 135 MUD 1 General Fund 6,224.00- 6,224.00- 12,750.98- 153,648.25 -2,468.642 159,872.25- 69 of 157 glbase_tbam skrolczyk 11:28 03/10/20 Fund: 137 MUD 1 Consolidated GASS Account Description 137-49145-000-000 137-49146-000-000 Subtot Program number: Department number: Revenues Subtotal Fund number: 137 MUD 1 Consolidated GASB H Intergov Transfer -General Fund Intergov Transfer -Fire Dept Department: AMENDED March 16, 2020 Regular Meeting Agenda Packet Trophy Club MUD No.1 Page 13 Budget Summary with Amendment Program: Period Ending: 2/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 70 of 157 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 11:28 03/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Ac0ount: 135-40000-000- 867 02/03/2020 Property Taxes 870 02/04/2020 property taxes 871 02/05/2020 property taxes 872 02/06/2020 property taxes 875 02/07/2020 property taxes 876 02/10/2020 property taxes 877 02/11/2020 property taxes 878 02/12/2020 property taxes 879 02/13/2020 property taxes 880 02/18/2020 property taxes 882 02/20/2020 property taxes 883 02/21/2020 property taxes 884 02/24/2020 property taxes 885 02/25/2020 property taxes 886 02/26/2020 property taxes 887 02/27/2020 property taxes 888 02/28/2020 property taxes Account:135-40000-000-b,, AMENDED March 16, 2020 Regular Meeting Agenda Packet Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 2/2020 JE Detail Beginning Transaction Transaction Vendor Name Description/Comment Balance Detail Detail (SUBTOTAL) Property Taxes (120,400.36) (1,954.31) (122,354.67) (1,600.15) (123,954.82) (1,808.18) (125,763.00) (1,443.53) (127,206.53) (4,470.43) (131,676.96) (28.41) (131,705.37) (1.87) (131,707.24) (.01) (131,707.25) (67.01) (131,774.26) (29.97) (131,804.23) (35.50) (131,839.73) (96.38) (131,936.11) (298.43) (132,234.54) (52.62) (132,287.16) (45.81) (132,332.97) (224.49) (132,557.46) (314.99) (132,872.45) Page 5 Check Source Number Property Taxes Totals: Account: 135-40002-000-00 867 02/03/2020 Property Taxes 871 02/05/2020 property taxes 872 02/06/2020 property taxes 886 02/26/2020 property taxes 887 02/27/2020 property taxes Account: 135 -40002 -000 - Account: 135-40015-000-00' 867 02/03/2020 Property Taxes 870 02/04/2020 property taxes 871 02/05/2020 property taxes 872 02/06/2020 property taxes 875 02/07/2020 property taxes 876 02/10/2020 property taxes 877 02/11/2020 property taxes 879 02/13/2020 property taxes (134,871.00) Budgeted Property Taxes/Delinquent (1,998.55) Remaining 99 % Used Property Taxes/Delinquent Totals: (300.00) Budgeted (116.99) (9.63) (126.62) (.69) (127.31) (116.39) (243.70) (1.14) (244.84) (1.45) (246.29) (53.71) Remaining 82 % 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 5, I (184.15) 71 of 157 (2.73) (186.88) (.19) (187.07) (1.03) (188.10) (21.16) (209.26) (15.06) (224.32) (1.99) (226.31) (.14) (226.45) (4.69) (231.14) GL GL GL GL GL GL GL GL glpdatb2 skrolczyk 11:28 03/10/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 880 02/18/2020 property 882 02/20/2020 property 883 02/21/2020 property 884 02/24/2020 property 885 02/25/2020 property 886 02/26/2020 property 887 02/27/2020 property 888 02/28/2020 property Account: 135-40015-000-000 Account: 135-40025-000-000 Account: 135-40025-000-000 taxes taxes taxes taxes taxes taxes taxes taxes Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 2/2020 JE Detail Beginning Balance Description/Comment Property Taxes/P & I (300.00) Budgeted ■ PID Surcharges JIIPID Surcharges (164,253.00) Budgeted Account: 135-47000-000-000 718 02/05/2020 UB 02/05/2020 Bill adjustment 834 02/28/2020 UB 03/02/2020 Billing Account: 135-47000-000-000 5.45 Remaining (164,253.00) Remaining UB20200205-20200205 User: UB20200228-20200228 User: (6,486,623.00) Budgeted (184.15) Program: Transaction Detail (.08) (2.48) (6.75) (20.88) (3.16) (3.47) (16.42) (21.07) 102 % Used (1,523,137.03) (4,681,107.97) Remaining Account: 135-47005-000-00 718 02/05/2020 UB 02/05/2020 Bill adjustment 0020200205-20200205 User: 834 02/28/2020 UB 03/02/2020 Billing 0020200228-20200228 User: Account: 135-47 glo Account: 135-47025-000-000 759 02/13/2020 UB 797 02/21/2020 UB 810 02/25/2020 UB 821 02/27/2020 UB Ace (3,503,885.00) Budgeted .00 0 % Used 28 % Used AMENDED March 16, 2020 Regular Meeting Agenda Packet Page 6 Transaction Vendor Name Detail (SUBTOTAL) (231.22) (233.70) (240.45) (261.33) (264.49) (267.96) (284.38) (305.45) .00 153.94 (1,522,983.09) (282,531.94) (1,805,515.03) (282,378.00) Check Source Number GL GL GL GL GL GL GL GL UB UB (995,260.50) Totals: (2,252,835.41) Remaining 36 % Used 44.80 (995,215.70) (255,833.89) (1,251,049.59) (1,251,049.59) ** UB UB Penalties 02/13/2020 Penalty removal 02/21/2020 Penalties 02/25/2020 Penalty removal 02/27/2020 Penalty removal 0820200213-20200213 User: UB20200221-20200221 User: 0820200225-20200225 User: UB20200227-20200227 User: (35,066.86) Penalties (112,608.00) Budgeted (66,711.52) Remaining Totals: 41 % Used 72 of 157 73.68 (11,008.51) 41.49 63.72 (34,993.18) (46,001.69) (45,960.20) (45,896.48) UB UB UB UB AMENDED March 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 7 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/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-47030-000- Service Cha 743 02/04/2020 UB 02/04/2020 NSF Check UB20200204-20200204 User: (6,750.00) (25.00) (6,775.00) UB 716 02/05/2020 UB 02/05/2020 Disconnect Fees UB20200205-20200205 User: (1,900.00) (8,675.00) UB 765 02/10/2020 UB 02/10/2020 NSF check UB20200210-20200210 User: (25.00) (8,700.00) UB 794 02/19/2020 UB 02/19/2020 NSF Check UB20200219-20200219 User: (25.00) (8,725.00) UB 793 02/20/2020 UB 02/20/2020 NSF Check UB20200220-20200220 User: (50.00) (8,775.00) UB 844 02/24/2020 UB 02/24/2020 NSF Check UB20200224-20200224 User: (25.00) (8,800.00) UB Account: 135-47030-000-00' Service Charges (15,150.00) Budgeted Account: 135-47035-000-000 848 02/03/2020 Permits -2 Sadie Court 849 02/13/2020 Permits -222 Phoenix Account: 135-47035-000-000 Totals: ' (6,350.00) Remaining 58 % Used Plumbing Inspections 2 Sadie Court (2,150.00) (50.00) (2,200.00) Drees 222 Phoenix Drive (50.00) (2,250.00) Dazzling Homes Plumbing Inspections (10 ee (750.00) Budgeted 1,500.00 Remaining 300 % Used Account: 135-47045-000-002 Sewer Inspections 848 02/03/2020 Permits -2 Sadie Court 2 Sadie Court 849 02/13/2020 Permits -222 Phoenix 222 Phoenix Drive Account: 135-47045-000-000 Account: 135-47070-000-00 Account: 135-47070-000-000 Sewer Inspections (2,500.00) Budgeted (1,150.00) Remaining (1,050.00) (150.00) (1,200.00) Drees (150.00) (1,350.00) Dazzling Homes 54 % Used (15,068.00) TCCC Effluent Charges (50,000.00) Budgeted (34,932.00) Remaining 857 02/28/2020 Bank Interest- February 857 02/28/2020 Bank Interest- February 857 02/28/2020 Bank Interest- February 30 % Used (41,939.08) .00 (1,117.33) (1,008.52) (7,746.13) (15,068.00) (43,056.41) (44,064.93) (51,811.06) CR CR CR CR GL GL GL (120,000.00) Budgeted (68,188.94) Remaining 43 % Used 73 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet glpdatb2 ekrolczyk Trophy Club MUD No.1 Page 8 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) ACCO Cell Tower Revenue 859 02/28/2020 Cell Tower Rev AT&T February 860 02/28/2020 Cell Tower Rev AT&T March Account :-'19nr--0'15.lTower Revenue Totals: (14,146.00) Budgeted (3,536.43) (1,178.81) (4,715.24) GL (1,178.81) (5,894.05) GL (8,251.95) Remaining 42 % Used Account: 135-49018-000-000 Building Rent In 896 02/29/2020 Town Billed Invoices 1726-1729 AR 20200229-20200229 User: (2,333.32) Account: 135-49018-000-000 •Mil4ing Rent Income (7,000.00) Budgeted Account: 135-49026-000-000 (13,000.00) Account: 135-49075-000-00 848 02/03/2020 Permits -2 Sadie Court 849 02/13/2020 Permits -222 Phoenix Budgeted (583.33) (2,916.65) (583.33) (2,916.65) ** (4,083.35) Remaining 42 % Used als: (13,000.00) Remaining 0 % Used Oversize Meter Reimbu 2 Sadie Court 222 Phoenix Drive (7,120.28) .00 .00 (353.00) (257.00) (7,473.28) Drees (7,730.28) Dazzling Homes CR CR Account: 135-49075-000-000 Oversize Meter R (12,691.00) Budgeted (4,960.72) Remaining Account: 135-49900-000-000 1.91RWIETRWus Income 851 02/18/2020 customer dep refund UB20200218-20200218 User: 834 02/28/2020 UB 03/02/2020 Billing Account: 135-49900-000-000 Department Totals: UB20200228-20200228 User: Miscellaneous Ii1COme 11111 (7,000.00) Budgeted 1,341.76 Remaining Totals: 61 (8,153.54) % Ueed 119 % Used (.70) (8,154.24) (187.52) (8,341.76) (3,340,047.09) ** (577,780.55) Monthly Total (10,645,077.00) Budgeted (7,305,029.91) Remaining 31 % Used 74 of 157 UB UB glpdatb2 skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) AMENDED March 16, 2020 Regular Meeting Agenda Packet Page 9 Account: 135-50005-010-000 Salaries & Wages 675 02/07/2020 MUD Payroll 02/07/2020 Salaries & Wages 782 02/21/2020 MUD Payroll 02/21/2020 Salaries & Wages 104,419.99 12,900.75 117,320.74 PR 14,942.26 132,263.00 PR Account: 135-50005-010-000 Salaries & Wages Totals: 27,843.01 132,263.00 ** 350,267.00 Budgeted 218,004.00 Remaining 38 % Used Account: 135-50010-010-000 Overtime 675 02/07/2020 MUD Payroll 02/07/2020 Overtime 7,647.68 516.39 8,164.07 PR 782 02/21/2020 MUD Payroll 02/21/2020 Overtime 697.69 8,861.76 PR Account: 135-50010-010-000 Overtime Totals: 1,214.08 8,861.76 ** 17,000.00 Budgeted 8,138.24 Remaining 52 % 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 782 02/21/2020 MUD Payroll 02/21/2020 Certification 1,650.00 425.00 2,075.00 PR Account: 135-50017-010-000 Certification Totals: 425.00 2,075.00 ** 5,400.00 Budgeted 3,325.00 Remaining 38 5 Used Account: 135-50020-010-000 Retirement 675 02/07/2020 MUD Payroll 02/07/2020 782 02/21/2020 MUD Payroll 02/21/2020 Retirement Retirement 12,072.53 1,242.44 13,314.97 PR 1,487.61 14,802.58 PR Account: 135-50020-010-000 Retirement Totals: 2,730.05 14,802.58 ** 34,863.00 Budgeted 20,060.42 Remaining 42 5 Used Account: 135-50026-010-000 Medical Insurance 675 02/07/2020 MUD Payroll 02/07/2020 Medical Insurance 782 02/21/2020 MUD Payroll 02/21/2020 Medical Insurance 19,153.58 2,612.55 21,766.13 PR 2,612.49 24,378.62 PR Account: 135-50026-010-000 Medical Insurance Totals: Immo 5,225.04 24,378.62 ** 84,326.00 Budgeted 59,947.38 Remaining 29 % Used 75 of 157 glpdatb2 skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) AMENDED March 16, 2020 Regular Meeting Agenda Packet Page 10 ACCOunt: 135-50027-010- ental IneuI 675 02/07/2020 MUD Payroll 02/07/2020 Dental Insurance 782 02/21/2020 MUD Payroll 02/21/2020 Dental Insurance 1,164.85 158.32 1,323.17 PR 158.31 1,481.48 PR Account: - Dental Insuranc Totals: mEllir 4,725.00 Budgeted 3,243.52 Remaining 31 % Used Account: 135-50028-010-000 Vision Insurance 675 02/07/2020 MUD Payroll 02/07/2020 Vision Insurance 782 02/21/2020 MUD Payroll 02/21/2020 Vision Insurance Account: 135-50028-01 Vision Insurance 767.00 Budgeted 626 02/01/2020 February A/P 626 02/01/2020 February A/P 822 02/27/2020 February AMP Life Insurance & Other Employee Benefits Employee LTD & STD caf 125 plan 1111111 187.93 24.10 212.03 PR 24.08 236.11 PR 530.89 Remaining 31 % Used 1,223.77 176.88 1,400.65 Humana Inc 132.01 1,532.66 METLIFE GROUP BENEFITS 20.00 1,552.66 BenefitMall 6136 AP 6145 AP 6214 AP Account: 135-50029-010-000 Life Insurance & Other Totals: Account: 135-50030-010-000 675 02/07/2020 MUD Payroll 02/07/2020 782 02/21/2020 MUD Payroll 02/21/2020 Account: 135-500 3,132.00 Budgeted 1,579.34 Remaining 50 % Ueed Social Security Taxes Social Security Taxes Social Security Taxes Social S- 23,348.00 Budgeted Account: 675 02/07/2020 MUD Payroll 02/07/2020 782 02/21/2020 MUD Payroll 02/21/2020 Medicare Taxes Medicare Taxes Medicare Taxes Account: Medicare Tax 5,461.00 Budgeted Account: 135-50 675 02/07/2020 MUD Payroll 02/07/2020 14,257.79 Remaining 7,276.76 1,701.80 39 Used 822.02 991.43 8,098.78 9,090.21 192.26 1,894.06 231.85 2,125.91 PR PR PR PR Unemployment Taxes 3,335.09 Remaining 39 % Used 45.16 76 of 157 10.09 55.25 PR glpdatb2 skrolczyk 11:28 03/10/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 782 02/21/2020 MUD Payroll 02/21/2020 Department: 10 Water JE Detail Description/Comment Unemployment Taxes Unemployment Taxes 1,080.00 Budgeted Account: 135-50045-010-00 Workman's Compensation 70 02/01/2020 Insurance/Wrk Comp Expense Feb Account: 135-50045-010-00 workman's Compensation 11,850.00 Budgeted Account: 135-50060-010-000 Pre-emp Physicals/Testing Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 2/2020 Beginning Balance 1,016.35 Remaining 7,992.55 Remaining Account: 135-50060-010-000 * Pre-emp Physicals/Testing Tota 400.00 Budgeted 400.00 Remaining Account: 135-50070-010-000 Employee Relations Account: 135-50070-010-000 Employee Relations Totals: 300.00 Budgeted 300.00 Remaining Account: 135-55005-010-000 Engineering Account: 135-55005-010-000 ■ Engineering Totals: 20,000.00 Budgeted 20,000.00 Remaining Account: 135-55080-010-000 Maintenance & Repairs 869 02/26/2020 PCards 1/28/20-2/26/20 grass 869 02/26/2020 869 02/26/2020 869 02/26/2020 822 02/27/2020 822 02/27/2020 890 02/28/2020 PCards 1/28/20-2/26/20 PCards 1/28/20-2/26/20 PCards 1/28/20-2/26/20 February A?P February A?P February A/P insulation, ice melt, tape,etc pvc cap cutoff blade repairs repiars Tank rental 45.16 3,085.96 21,176.04 Program: Transaction Detail 8.40 6 % Used 18 771.49 33 % Used .00 O % Used O % Used .00 .00 0 % Ueed 77 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet Page 11 Transaction Vendor Name Detail (SUBTOTAL) 63.65 3,857.45 .00 .00 .00 15.50 21,191.54 234.10 21,425.64 8.16 21,433.80 13.94 21,447.74 1,175.00 22,622.74 611.76 23,234.50 42.00 23,276.50 TEX-TURF THE HOME DEPOT 6581 ROANOKE WINNELSON CO THE HOME DEPOT #6581 DHS AUTOMATION, INC DHS AUTOMATION, INC ALLIED WELDING SUPPLY, INC Check Source Number PR GL PC PC PC PC 6219 AP 6219 AP AP glpdatb2 skrolczyk 11:28 03/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 2/2020 JE Detail Description/Comment Maintenance & Repairs 100,000.00 Budgeted AMENDED March 16, 2020 Regular Meeting Agenda Packet Page 12 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) 76,723.50 Remaining 23 Used Account: 135-55085-010-000 Generator Maint. and Repair Account: 135-55085-010-000 Generator Maint. and Repair Totals: 3,000.00 Budgeted 3,000.00 Remaining Account: 135 Vehicle Maintenance 869 02/26/2020 PCards 1/28/20-2/26/20 oil change 869 02/26/2020 PCards 1/28/20-2/26/20 helicoil 869 02/26/2020 PCards 1/28/20-2/26/20 truck bed mat 869 02/26/2020 PCards 1/28/20-2/26/20 document holder for visor Account: 135 Vehicle Maintenancals: 5,000.00 Budgeted 4,272.33 Remaining Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Account: 135-55105-010-005 Maintenance-Backhoe/SkidLoader Totals: 3,500.00 Budgeted 2,579.63 Remaining Account: Cleaning Services 822 02/27/2020 February AMP janitorial svc-january Cleaning Service Totals: 1,000.00 Budgeted .00 0 % Used .00 441.65 72.17 513.82 KWIK KAR LUBE & TUNE 0 PC 28.86 542.68 ROANOKE AUTO SUPPLY LT PC 124.99 667.67 TRACTOR SUPPLY COMPANY PC 60.00 727.67 AMZN MKTP US*B79M75A53 PC 920.37 15 % Used A .00 26 % Used 920.37 262.50 87.50 350.00 MEMBER'S BUILDING MAINTENANCE 6230 AP 650.00 Remaining 35 % Used Account: 135-55135-010-000 Lab Analysis 747 02/11/2020 February A?P water samples 1,347.70 250.00 1,597.70 TARRANT CTY PUBLIC HEALTH LAB 6192 AP Account: 135-55135-010-000 Lab Analysi Tot 7,500.00 Budgeted 5,902.30 Remaining 21 Used Account: 135-60010-010-000 Commu!!ications/Mobiles 78 of 157 glpdatb2 skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) AMENDED March 16, 2020 Regular Meeting Agenda Packet Page 13 747 02/11/2020 February A?P Cell phones -February 2,048.65 424.30 2,472.95 VERIZON WIRELESS 6198 AP Account: 135-60010-010-000 Communications/Mobiles Totals: 42 5,000.00 Budgeted 2,527.05 Remaining 49 % Used Account: 135-60020-010-000 Electricity 822 02/27/2020 February A?P Electricity 1/10-2/10 Account: 135-60020-010-000 Electric 125,677.00 Budgeted 79,525.40 Remaining 39,326.83 6,824.77 37 % Used 46,151.60 HUDSON ENERGY SERVICES, LLC 6224 AP Account: 135-60066-010-000 Publications/Books/Subscrip Account: 135-60066-010-000 Publications/Books/Subscripts Tota 1,000.00 Budgeted 1,000.00 Remaining .00 0 % Used .00 Account: 135-60070-010-00 Dues & Memberships .00 .00 Accoun Dues & Memberships in Totals: 500.00 Budgeted 500.00 Remaining 0 % Ueed Account: 135-60080-010-000 869 02/26/2020 PCards 1/28/20-2/26/20 Texas Water Conference 406.00 790.00 1,196.00 TEXAS WATER Account: 135-60080-010-00 ools & Traini Totals: 7,426.00 Budgeted 6,230.00 Remaining 16 % Ueed Account: 135-60090-010-000 .00 .00 Safety Program Account: 135-60090-010-000 Safety - 400.00 Budgeted 400.00 Remaining 0 % Used PC Account: 135-60100-010-000 0 79 of 157 0 glpdatb2 skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) ACC AMENDED March 16, 2020 Regular Meeting Agenda Packet Page 14 Account: 135-60105-010-000 Account: 135-60135-010-000 747 02/11/2020 February A?P Account: 135-60135-010-000 Account: 135-60150-010-000 822 02/27/2020 February A?P Account: 135-60150-010-000 Account: 135-60245-010-000 Account: 135-60245-010-000 Travel & per diem Tota 2,845.00 Budgeted 2,845.00 Remaining 0 % Used Rent/Lease Equipment .00 .00 Rent/Lease Equipment 1,500.00 Budgeted 1,500.00 Remaining 0 % Used TCEQ Fees & Permits well water 14,257.15 2,685.69 16,942.84 North Texas Groundwater TCEQ Fees & Permits To a e• 63,000.00 Budgeted 46,057.16 Remaining 27 % Used Wholesale Water wholesale water 468,955.29 103,065.44 572,020.73 CITY OF FORT WORTH Wholesale Water 2,714,710.00 Budgeted 2,142,689.27 Remaining Miscellaneous Expenses Miscellaneous Expenses 200.00 Budgeted 200.00 Remaining Account: 135-60280-010-000 Property Maintenance 869 02/26/2020 PCards 1/28/20-2/26/20 top soil, sand Account: 135 Property Maintenance Totals: 3,000.00 Budgeted 21 % Used .00 .00 .00 0 % Used .00 ** 462.00 294.00 756.00 DENTON SAND & GRAVEL, 2,244.00 Remaining 25 % Used Lawn Equipment & Maintenance 80 of 157 294.00 756.00 ** .00 .00 6187 AP 6216 AP PC glpdatb2 skrolczyk 11:28 03/10/20 Fund: 135 MUD 1 General Fund Account: JE JE JE Number Date Description Department: 10 Water JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Program: AMENDED March 16, 2020 Regular Meeting Agenda Packet Page 15 Period Ending: 2/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) Lawn Equipment & Maintenance Totals: 14,750.00 Budgeted 14,750.00 Remaining Interfund Transfer Out -Rev I&S 798 02/21/2020 TexPool Transfers February TexPool O&M to 16Swift Rev I&S 798 02/21/2020 TexPool Transfers February TexPool O&M to 19 W&WW Rev I&S Account: 135M5332-01011 Interfund Transfer Out -Rev I&S To 527,381.00 Budgeted 218,974.24 191,774.96 Remaining Account: 135-60333-010-000 Iaterfund 798 02/21/2020 TexPool Transfers February TexPool O&M to Rev Bond Resevr Account: 135-60334-010-000 Account: 135-60334-010-000 r Out -Reserve Tota 55,193.00 Budgeted Interfund Transfer Out 32,193.00 Remaining Interfund Transfer Out Totals: 180,000.00 Budgeted 180,000.00 Remaining Account: 135-60360-010-000 ' Furniture/Equipment < $5000 Account: 135-60360-010-000 Account: 135-65005-010-000 811 02/24/2020 Fuel Account: 135-65005-010-000 Account: 135-65010-010-000 0 % Used 25,047.72 216,822.68 91,584.08 58 % Used 308,406.76 GL GL 18,400.00 4,600.00 23,000.00 GL 42 % Ueed .00 .00 0 % Ueed 561.72 .00 561.72 Furniture/Equipment < $5000 Totals: 2,500.00 Budgeted 1,938.28 Remaining 22 % Ueed AIL AL1 & Lube Fuel -FEB 3,569.35 945.56 4,514.91 US Bank Voyager Fleet Systems 6236 AP 15,000.00 Budgeted 10,485.09 Remaining 30 % Used 2,917.33 .00 2,917.33 81 of 157 glpdatb2 skrolczyk 11:28 03/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Department: 10 Water JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 2/2020 Beginning Balance AMENDED March 16, 2020 Regular Meeting Agenda Packet Page 16 Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) Check Source Number 82 of 157 Account: 135-65010-010-000 Uniforms Totals: .00 2,917.33 ** di 5,190.00 Budgeted 2,272.67 Remaining 56 5 Used Account: 135-65030-010-000 Chemicals 822 02/27/2020 February A?P 822 02/27/2020 February A?P ammonia chlorine 7,625.15 721.26 670.09 8,346.41 9,016.50 Valley Solvent Company, DPC INDUSTRIES, INC INC 6237 6220 AP AP Account: 135-65030-010-000 Chemicals Totals: 1,391.35 9,016.50 ** 20,000.00 Budgeted 10,983.50 Remaining 45 % Used Account: 135-65035-010-000 Small Tools .00 .00 Account: 135-65035-010-000 Small Tools Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-65040-010-000 Safety Equipment .00 .00 Account: 135-65040-010-000 Safety Equipment Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 5 Used Account: 135-65050-010-000 Meter Expense 727 02/06/2020 February A/P meter parts 16,104.78 765.00 16,869.78 ATLAS UTILITY SUPPLY CO. 6174 AP Account: 135-65050-010-000 Meter Expense Totals: 765.00 16,869.78 ** 70,000.00 Budgeted 53,130.22 Remaining 24 5 Used Account: 135-65053-010-000 Meter Change Out Program 36,900.00 .00 36,900.00 Account: 135-65053-010-000 Meter Change Out Program Totals: .00 36,900.00 ** 87,000.00 Budgeted 50,100.00 Remaining 42 5 Used Account: 135-69005-010-000 Capital Outlays 894 02/04/2020 Cashier's Chk Denton Land Purc Res 14-03488-211 Denton Sherif 165,790.03 1,000.00 166,790.03 GL 82 of 157 glpdatb2 skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Detailed Accounting Trial Balance AMENDED March 16, 2020 Regular Meeting Agenda Packet Page 17 822 02/27/2020 February A?P 822 02/27/2020 February A?P 890 02/28/2020 February A/P Account: 135-69005-01 Account: 135-69008-010-000 Account: 135-69008-010-000 Account: 135-69009-010-000 Account: 135-69009-010-000 Account: 135-69195-010-000 Account: 135-69195-010-000 Account: 135-69281-010-000 Account: 135-69281-010-000 truck decals lights for truck Truck bed for 2020 Dodge 2500 165,790.03 125.00 166,915.03 M-KAM LTD. 6229 AP 2,245.00 169,160.03 Defender Supply 6218 AP 7,550.00 176,710.03 Fortress Resources, LLC AP Capital Outlays Totals: 684,875.00 Budgeted 508,164.97 Remaining 26 % Used Short Term Debt -Principal Short Term Debt -Principal 30,512.00 Budgeted erm Interest 30,512.00 Totals: .00 Remaining 100 % Used Short Term Debt -Interest Totals: 3,231.00 Budgeted 1,391.00 Remaining Gasb34/Reserve for Replacement Gasb34/Reserve for Replacement Totals: 75,000.00 Budgeted .00 Remaining 1,840.00 75,000.00 57 % Used .00 30,512.00 .00 1,840.00 .00 75,000.00 100 % Used Water Tank Inspection Contract 102,077.11 Water Tank Inspection Contract Totals: 120,000.00 Budgeted 17,922.89 Remaining 85 % Used 83 of 157 .00 102,077.11 glpdatb2 skrolczyk 11:28 03/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 2/2020 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) AMENDED March 16, 2020 Regular Meeting Agenda Packet Page 18 JE Detail Description/Comment Account: 135-55135-010-001 Lab Analysis for PID 747 02/11/2020 February A?P water samples 467.70 80.00 547.70 TARRANT CTY PUBLIC HEALTH LAB 6192 AP Account: 135-55135-010-001 Lab Analysis for PID Totals: 80.00 547.70 ** 2,000.00 Budgeted 1,452.30 Remaining 27 % Used Department 10 Totals: 1,661,157.13 ** 293,300.31 Monthly Total 5,506,929.00 Budgeted 3,845,771.87 Remaining 30 % Used 84 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 19 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-020-000 Salaries & Wages 675 02/07/2020 MUD Payroll 02/07/2020 Salaries & Wages 782 02/21/2020 MUD Payroll 02/21/2020 Salaries & Wages 119,177.15 15,801.44 134,978.59 PR 15,859.34 150,837.93 PR Account: 135-50005-020-000 Salaries & Wages Totals: 31,660.78 150,837.93 ** 441,799.00 Budgeted 290,961.07 Remaining 34 % Used Account: 135-50010-020-000 Overtime 675 02/07/2020 MUD Payroll 02/07/2020 Overtime 8,065.27 977.08 9,042.35 PR 782 02/21/2020 MUD Payroll 02/21/2020 Overtime 722.95 9,765.30 PR Account: 135-50010-020-000 Overtime Totals: 1,700.03 9,765.30 ** 33,000.00 Budgeted 23,234.70 Remaining 30 % Used Account: 135-50016-020-000 Longevity 6,872.50 .00 6,872.50 Account: 135-50016-020-000 Longevity Totals: .00 6,872.50 ** 8,035.00 Budgeted 1,162.50 Remaining 86 % Used Account: 135-50017-020-000 Certification 782 02/21/2020 MUD Payroll 02/21/2020 Certification 2,550.00 650.00 3,200.00 PR Account: 135-50017-020-000 Certification Totals: 650.00 3,200.00 ** 9,000.00 Budgeted 5,800.00 Remaining 36 % Used Account: 135-50020-020-000 Retirement 675 02/07/2020 MUD Payroll 02/07/2020 782 02/21/2020 MUD Payroll 02/21/2020 Retirement Retirement 14,183.59 1,553.69 15,737.28 PR 1,595.71 17,332.99 PR Account: 135-50020-020-000 Retirement Totals: 3,149.40 17,332.99 ** 45,531.00 Budgeted 28,198.01 Remaining 38 % Used Account: 135-50026-020-000 Medical Insurance 675 02/07/2020 MUD Payroll 02/07/2020 Medical Insurance 782 02/21/2020 MUD Payroll 02/21/2020 Medical Insurance 26,051.83 3,869.14 29,920.97 PR 3,869.10 33,790.07 PR Account: 135-50026-020-000 Medical Insurance Totals: 7,738.24 33,790.07 ** 104,858.00 Budgeted 71,067.93 Remaining 32 % Used 85 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/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-50027 020- ental InsuI 675 02/07/2020 MUD Payroll 02/07/2020 Dental Insurance 782 02/21/2020 MUD Payroll 02/21/2020 Dental Insurance 1,538.52 223.47 1,761.99 PR 223.43 1,985.42 PR Account: -1.1 Dental Insuranc Totals: 5,817.00 Budgeted 3,831.58 Remaining 34 % Used Account: 135-50028-020-000 675 02/07/2020 MUD Payroll 02/07/2020 782 02/21/2020 MUD Payroll 02/21/2020 Vision Insurance Vision Insurance Vision Insurance 250.69 4 34.87 285.56 PR 34.87 320.43 PR Account: 135-50028-020-000 Vision Insurance Totals: 626 02/01/2020 February A/P 626 02/01/2020 February A/P 822 02/27/2020 February AMP 948.00 Budgeted e Insurance & Other Employee Benefits Employee LTD & STD caf 125 plan Account: 135-50029-020-000 Life Insurance & Other 4,500.00 Budgeted Account: 135-50030-020-000 675 02/07/2020 MUD Payroll 02/07/2020 782 02/21/2020 MUD Payroll 02/21/2020 627.57 Remaining 34 % Used 1,390.36 198.33 1,588.69 Humana Inc 165.74 1,754.43 METLIFE GROUP BENEFITS 32.00 1,786.43 BenefitMall Totals: =ff.43 ** 2,713.57 Remaining 40 % Ueed Social Security Taxes Social Security Taxes Social Security Taxes Social Security T 30,494.00 Budgeted Account: 135-50035-020-000 Medicare Taxes 675 02/07/2020 MUD Payroll 02/07/2020 Medicare Taxes 782 02/21/2020 MUD Payroll 02/21/2020 Medicare Taxes Account: 135-50035-020-000 Medicare Tax 7,132.00 Budgeted 20,578.68 Account: 135-50040-0 675 02/07/2020 MUD Payroll 02/07/2020 Unemployment Taxes Remaining s: 4,813.10 Remaining 7,951.71 1,859.66 33 980.70 982.91 Used 8,932.41 9,915.32 229.36 2,089.02 229.88 2,318.90 33 % Used 6136 AP 6145 AP 6214 AP PR PR PR PR 34.56 16.79 51.35 PR 86 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 782 02/21/2020 MUD Payroll 02/21/2020 Unemployment Taxes AccOUn - - - Unemployment Taxes 1,260.00 Budgeted 34.56 7.77 1,200.88 Remaining 5 % Used 24 59.12 PR Account: 135-50045-020-00 Workman's Compensation 70 02/01/2020 Insurance/Wrk Comp Expense Feb 4,440.80 1,110.20 5,551.00 Account: 135-50045-020-00 workman's Compensation 15,373.00 Budgeted 9,822.00 Remaining 36 % Used Account: 135-50060-020- Pre-emp Physicals/Testing 771 02/17/2020 February A/P employee drug screen -Frank Iso 38.00 38.00 CARENOW CORPORATE Pre-emp Physicals/Testing 400.00 Budgeted 362.00 Remaining 10 % Used Account. Employee Relations .00 .00 Account Employee Relations Totals: 300.00 Budgeted Account: 135-55005-020-000 Engineering Account: 135-55005-020-000 300.00 Remaining 0 % Used Engineering Totals: 30,000.00 Budgeted .00 .00 30,000.00 Remaining 0 % Ueed Account: 135-55070-020-000 Independent Labor Account: 135-55070-020-000 Account: 135 771 02/17/2020 February A/P Independent Labor 15,000.00 Budgeted 12,000.00 Remaining e & Repai. pm on digester blowers 3,000.00 28,715.17 .00 3,000.00 20 % Used 87 of 157 605.00 29,320.17 Precision Pump Systems GL 6201 AP 6210 AP glpdatb2 skrolczyk 11:28 03/10/20 Fund: 135 MUD 1 General Fund JE Number JE Date 771 02/17/2020 771 02/17/2020 869 02/26/2020 869 02/26/2020 869 02/26/2020 822 02/27/2020 822 02/27/2020 822 02/27/2020 890 02/28/2020 JE Description February A/P February A/P PCards 1/28/20-2/26/20 PCards 1/28/20-2/26/20 PCards 1/28/20-2/26/20 February A?P February A?P February A?P February A/P Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 2/2020 JE Detail Beginning Balance Description/Comment sludge pump rotor & stator parts for bar screen pvc cement, primer, pipe,elbow synthetic gear oil, HD Creeper coupling, pvc, drain pipe, saw longo bags for grit rollers for rotary drums pre -wraps for digester blowers change out air scada mbr Maintenance & Repairs 88,000.00 Budgeted 52,556.12 Remaining 869 02/26/2020 PCards 1/28/20-2/26/20 869 02/26/2020 PCards 1/28/20-2/26/20 869 02/26/2020 PCards 1/28/20-2/26/20 869 02/26/2020 PCards 1/28/20-2/26/20 869 02/26/2020 PCards 1/28/20-2/26/20 822 02/27/2020 February A?P 890 02/28/2020 February A/P Ac 5-55081-0a Account: 135-55085-020-000 Account: 135-55085-020-000 1 Mainten & Repairs Collections anvil, taperule concrete grade ring refund due to tax charged concrete grade ring/ no tax lopper, mop, bucket, disinfect repiars manhole parts Mainten & Repairs Collections Totals: 10,000.00 Budgeted (7,677.78) Remaining Generator Maint. and Repair Generator Maint. and Repair Totals: 10,000.00 Budgeted 10,000.00 Remaining Account: 135-55090-020-000 Vehicle Maintenance 869 02/26/2020 PCards 1/28/20-2/26/20 document holder for visor Account: 135-55090-020-000 Account: 135-55091-020-000 869 02/26/2020 PCards 1/28/20-2/26/20 Vehicle Maintenance 4,000.00 Budgeted 3,257.02 Remaining Collecti 28,715.17 Program: Transaction Detail 40 % Used AMENDED March 16, 2020 Regular Meeting Agenda Packet Page 22 Transaction Vendor Name Detail (SUBTOTAL) 2,310.00 31,630.17 637.87 32,268.04 33.83 32,301.87 719.99 33,021.86 37.50 33,059.36 665.00 33,724.36 1,120.32 34,844.68 109.20 34,953.88 490.00 35,443.88 88 Precision Pump Systems Huber Technology Inc THE HOME DEPOT #6581 ROANOKE AUTO SUPPLY LT THE HOME DEPOT #6581 Huber Technology Inc Huber Technology Inc Filter Element Store DHS AUTOMATION, INC 15,378.45 13.72 15,392.17 THE HOME DEPOT #6581 168.16 15,560.33 FERGUSON ENT 1241 (168.16) 15,392.17 FERGUSON ENT 1241 155.34 15,547.51 FERGUSON ENT 1241 69.17 15,616.68 THE HOME DEPOT #6581 1,405.00 17,021.68 DHS AUTOMATION, INC 656.10 17,677.78 Core & Main LP 177 % Used 682.98 0 % Ueed .00 60.00 19 % Used • prem AW 46 HYD Fluid 5gallons 1,932.95 88 of 157 53.99 .00 742.98 AMZN MKTP US•B79M75A53 1,986.94 ROANOKE AUTO SUPPLY LT Check Source Number 6210 AP 6206 AP PC PC PC 6222 AP 6222 AP 6221 AP AP PC PC PC PC PC 6219 AP AP PC PC glpdatb2 skrolczyk 11:28 03/10/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: 2/2020 Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment AMENDED March 16, 2020 Regular Meeting Agenda Packet Page 23 Check Source Number 773 02/17/2020 February A/P 773 02/17/2020 February A/P 773 02/17/2020 February A/P 773 02/17/2020 February A/P 822 02/27/2020 February A?P 822 02/27/2020 February A?P 828 02/28/2020 February A/P 828 02/28/2020 February A/P lab testing lab trsting lab testing lab trsting lab testing lab trsting lab testing lab trsting 12,716.45 341.55 13,058.00 OXIDOR LABORATORIES LLC 241.50 13,299.50 OXIDOR LABORATORIES LLC 341.55 13,641.05 OXIDOR LABORATORIES LLC 241.50 13,882.55 OXIDOR LABORATORIES LLC 341.55 14,224.10 OXIDOR LABORATORIES LLC 241.50 14,465.60 OXIDOR LABORATORIES LLC 341.55 14,807.15 OXIDOR LABORATORIES LLC 241.50 15,048.65 OXIDOR LABORATORIES LLC 6209 AP 6209 AP 6209 AP 6209 AP 6233 AP 6233 AP 6233 AP 6233 AP Account: 135-55135-020-000 Lab Analysis Totals: 2,332.20 15,048.65 ** 40,000.00 Budgeted 24,951.35 Remaining 38 % Used Account: 135-60010-020-000 Communications/Mobiles 89 of 157 Account: 135-55091-020-000 Veh Maintenance Collections Totals: 53.99 1,986.94 ** 8,000.00 Budgeted 6,013.06 Remaining 25 5 Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 869 02/26/2020 PCards 1/28/20-2/26/20 Terra Cair Defrost/Right angle 504.68 54.99 559.67 ROANOKE AUTO SUPPLY LT PC Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: 54.99 559.67 ** 3,000.00 Budgeted 2,440.33 Remaining 19 5 Used Account: 135-55120-020-000 Cleaning Services 822 02/27/2020 February A?P janitorial svc-january 262.50 87.50 350.00 MEMBER'S BUILDING MAINTENANCE 6230 AP Account: 135-55120-020-000 Cleaning Services Totals: 87.50 350.00 ** 1,500.00 Budgeted 1,150.00 Remaining 23 % Used Account: 135-55125-020-000 i Dumpster Services 771 02/17/2020 828 02/28/2020 828 02/28/2020 February A/P February A/P February A/P Sludge/grit Sludge/grit Sludge/grit 32,786.78 1,079.42 2,236.96 2,376.46 33,866.20 36,103.16 38,479.62 L.H. CHANEY MATERIALS, L.H. CHANEY MATERIALS, L.H. CHANEY MATERIALS, INC. INC. INC. 6207 6227 6227 AP AP AP Account: 135-55125-020-000 Dempster Services Totals: 5,692.84 38,479.62 ** 100,000.00 Budgeted 61,520.38 Remaining 38 % Used Account: 135-55135-020-000 Lab Analysis 773 02/17/2020 February A/P 773 02/17/2020 February A/P 773 02/17/2020 February A/P 773 02/17/2020 February A/P 822 02/27/2020 February A?P 822 02/27/2020 February A?P 828 02/28/2020 February A/P 828 02/28/2020 February A/P lab testing lab trsting lab testing lab trsting lab testing lab trsting lab testing lab trsting 12,716.45 341.55 13,058.00 OXIDOR LABORATORIES LLC 241.50 13,299.50 OXIDOR LABORATORIES LLC 341.55 13,641.05 OXIDOR LABORATORIES LLC 241.50 13,882.55 OXIDOR LABORATORIES LLC 341.55 14,224.10 OXIDOR LABORATORIES LLC 241.50 14,465.60 OXIDOR LABORATORIES LLC 341.55 14,807.15 OXIDOR LABORATORIES LLC 241.50 15,048.65 OXIDOR LABORATORIES LLC 6209 AP 6209 AP 6209 AP 6209 AP 6233 AP 6233 AP 6233 AP 6233 AP Account: 135-55135-020-000 Lab Analysis Totals: 2,332.20 15,048.65 ** 40,000.00 Budgeted 24,951.35 Remaining 38 % Used Account: 135-60010-020-000 Communications/Mobiles 89 of 157 glpdatb2 skrolczyk 11:28 03/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description 747 02/11/2020 February A?P Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Program: Period Ending: 2/2020 Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment Cell phones -February AMENDED March 16, 2020 Regular Meeting Agenda Packet Page 24 2,270.53 408.87 2,679.40 VERIZON WIRELESS Check Source Number 6198 AP 90 of 157 Account: 135-60010-020-000 Communications/Mobiles Totals: 408.87 2,679.40 ** 5,000.00 Budgeted 2,320.60 Remaining 54 % Used Account: 135-60020-020-000 — Electricity 747 02/11/2020 822 02/27/2020 896 02/29/2020 February A?P electricity 1/2-2/3 February A?P Electricity 1/10-2/10 Town Billed Invoices 1726-1729 AR 20200229-20200229 User: 47,873.47 483.78 13,152.71 (666.69) 48,357.25 61,509.96 60,843.27 TRI COUNTY ELECTRIC HUDSON ENERGY SERVICES, LLC 6196 6224 AP AP AR Account: 135-60020-020-000 Electricity — Totals: 12,969.80 60,843.27 ** 160,067.00 Budgeted 99,223.73 Remaining 38 % Used Account: 135-60066-020-000 Publications/Books/Subscripts .00 .00 Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60070-020-000 Dues & Memberships 111.00 .00 111.00 Account: 135-60070-020-000 Dues & Memberships Totals: .00 111.00 ** 300.00 Budgeted 189.00 Remaining 37 % Used Account: 135-60080-020-000 Schools & Training 869 02/26/2020 869 02/26/2020 PCards 1/28/20-2/26/20 WW License Renewal PCards 1/28/20-2/26/20 groundwater class- jjones 1,910.85 111.00 410.00 2,021.85 2,431.85 TCEQ IND RENEWAL LIC TEEX ECOMMERCE PC PC Account: 135-60080-020-000 Schools & Training 1 Totals: 521.00 2,431.85 ** 4,990.00 Budgeted 2,558.15 Remaining 49 % Used Account: 135-60090-020-000 = Safety Program 109.14 .00 109.14 Account: 135-60090-020-000 Safety Program Totals: .00 109.14 ** 1,000.00 Budgeted 890.86 Remaining 11 % Used 90 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60100-020-000 Travel & per diem 360.84 .00 360.84 Account: 135-60100-020-000 Travel & per diem Totals: .00 360.84 ** 1,545.00 Budgeted 1,184.16 Remaining 23 % Used Account: 135-60105-020-000 Rent/Lease Equipment .00 .00 Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60125-020-000 Advertising .00 .00 Account: 135-60125-020-000 Advertising Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 10,088.02 .00 10,088.02 Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 10,088.02 ** 15,000.00 Budgeted 4,911.98 Remaining 67 % Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** 450.00 Budgeted 450.00 Remaining 0 % Used Account: 135-60280-020-000 Property Maintenance 822 02/27/2020 February A?P WWTP heater in barn 584.94 584.94 BRANDON R REED 6215 AP Account: 135-60280-020-000 Property Maintenance Totals: 584.94 584.94 ** 5,000.00 Budgeted 4,415.06 Remaining 12 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 91 of 157 rfund Transfer Out -Reserve Tot 125,187.00 Budgeted 96,437.00 Remaining 23,000.00 23 Used 5,750.00 28,750.00 GL GL GL GL un. raps• AMENDED March 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60285-020-81 Lawn Equipment & Maintenance Totals: 14,000.00 Budgeted 14,000.00 Remaining Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S 798 02/21/2020 TexPool Transfers February TexPool O&M to I&S- PID Debt Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S Tot 114,563.00 Budgeted 62,488.95 Remaining Account: 135-60 020- Interfund T -Rev I&S 798 02/21/2020 TexPool Transfers February TexPool O&M to Rev Bd WWTP I&S 798 02/21/2020 TexPool Transfers February TexPool O&M to 19 W&WW Rev I&S Account1332-02 - terfund Transfe 673,867.00 Budgeted 41,659.24 245,042.20 .00 .00 0 % Used 45 % Used 10,414.81 52,074.05 54,421.63 299,463.83 27,356.28 326,820.11 347,046.89 Remaining 48 % Used Account: 135-60333-020-000 Interfund Transfer Out -Reserve 798 02/21/2020 TexPool Transfers February TexPool O&M to Rev Bond Resevr Account: 135-60333-020-000 Account: 135-60334-020-000 Account: 135-60334-020-000 Account: 135-60360-020-000 Account: 135-60360-020-000 Account: 135-65005-020-000 Interfund Transfer Ou 180,000.00 Budgeted 180,000.00 Remaining 0 Used .00 .00 Furniture/Equipment < $5000 190.00 Furniture/Equipment < $5000 2,000.00 Budgeted 1,810.00 Remaining 10 % Used .00 190.00 Fuel & Lube 92 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2020 JE JE JB JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 811 02/24/2020 Fuel Fuel -FEB Account: 135-65005-17e 12,500.00 Budgeted Totals: 8,745.00 Remaining 2,960.40 794.60 3,755.00 US Bank Voyager Fleet Systems 6236 AP 30 % Used 79113,755.00 a. Account: 135-65010-020-000 3,507.93 .00 Account: 135-65010-020-00 5,495.00 Account: 135-65035..020-0 Chemicals 890 02/28/2020 February A/P Budgeted polymer 1,987.07 Remaining 9,868.27 64 % Used 2,856.60 3,507.93 12,724.87 POLYDYNE, INC AP ACCouR Chemicals 20,000.00 Budgeted 7,275.13 Remaining 64 % Used Account: 135-65031-020-000 Chemicals Collections Account: 135-65031-020-000 Chemicals Collections Totals: 17,500.00 Budgeted Account: 135-65035-020-000 Small Tools Account: 135-65035-020-000 Small Tools 1,200.00 Budgeted Account: 135-65040-020-000 Safety Equipment 869 02/26/2020 PCards 1/28/20-2/26/20 phone case- lholt Account: 135-65040-020-000 Safety Equipment 1,200.00 Budgeted Account: 135-65045-020-000 4,994.00 .00 4,994.00 12,506.00 Remaining 29 % Used .00 .00 Totals: 1,200.00 Remaining 0 % Ueed 1,088.92 22.71 1,111.63 AMZN NNTP US.S95255OF3 Totals: 88.37 Remaining 93 % Used 10,837.36 .00 10,837.36 93 of 157 PC glpdatb2 skrolczyk 11:28 03/10/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: 2/2020 JE Detail Description/Comment Lab Supplies 20,000.00 Budgeted 9,162.64 pital Outla 754 02/13/2020 Void check per finance WWTP Sound curtain/building 771 02/17/2020 February A/P WWTP-water system 890 02/28/2020 February A/P spare pump -lift station Capital Outlays 530,500.00 Budgeted AMENDED March 16, 2020 Regular Meeting Agenda Packet Page 28 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) Remaining 54 Ueed 145,872.09 (500.00) 145,372.09 TOWN OF TROPHY CLUB 6080 AP 6,119.80 151,491.89 Halff Associates, INC 6205 AP 8,536.00 160,027.89 DHS AUTOMATION, INC AP 370,472.11 Remaining 30 % Ueed Short Term Debt -Principal 59,604.74 Account: 135-69008-020-000 Short Term Debt -Principal 79,133.00 Budgeted 19,528.26 Remaining .00 59,604.74 75 % Ueed Account: 135-69009-020-000 Short Term Debt -Interest Account: 135-69009-020-000 Short Term Debt-Inte 11,277.00 Budgeted 5,154.97 Remaining 6,122.03 54 % Used .00 6,122.03 Account: 135-69195-020-000 .eserve or .ep acemen Account: 135-69195-020-000 Department 20 Totals: 130,000.00 Gasb34/Reserve for Replacement Totals: 130,000.00 Budgeted .00 Remaining 100 % Used .00 130,000.00 1,234,791.00 ** 196,973.37 Monthly Total 3,157,421.00 Budgeted 1,922,630.00 Remaining 39 % Used 94 of 157 glpdatb2 skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) AMENDED March 16, 2020 Regular Meeting Agenda Packet Page 29 Account: 135-50045-026-0 Workman's Compensation 70 02/01/2020 lneurance/Wrk Comp Expense Feb Ac Workman's Compensation Total= 30.00 Budgeted 20.05 Remaining Account: 135-60066-026-000 ■ Publications/Books/Subscripts Account: 135-60066-026-000 . Publications/Books/Subscripts Totals: 150.00 Budgeted 150.00 Remaining 7.96 1.99 9.95 1 33 % Used .00 .00 0 % Ueed GL 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 95 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 i• 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Department 26 Totals: 861.23 •• 1.99 Monthly Total 13,230.00 Budgeted 96 of 157 12,368.77 Remaining 7 % Used AMENDED March 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) ACCOUnt: 135-5000 030- Salaries & 415 - 675 02/07/2020 MUD Payroll 02/07/2020 Salaries & Wages 782 02/21/2020 MUD Payroll 02/21/2020 Salaries & Wages 119,116.36 15,074.28 134,190.64 PR 15,074.86 149,265.50 PR Account:05-0 Salaries & Wages 628,298.00 Budgeted _ Totals: 479,032.50 Remaining 24 % Used Account: 135-50010-030-000 782 02/21/2020 MUD Payroll 02/21/2020 Account: 135-50010-030-000 Account: 135-50016-030-000 Overtime Overtime Overtime 2,000.00 Budgeted 16.57 1,979.47 Remaining 1 % Used Account: 135-50016-030-00 Totals: 2,208.00 Budgeted .50 Remaining Account: 135-50020-030-00 irement 675 02/07/2020 MUD Payroll 02/07/2020 782 02/21/2020 MUD Payroll 02/21/2020 Retirement Retirement 2,207.50 100 % Used 12,732.78 3.96 20.53 .00 2,207.50 1,395.90 1,396.30 14,128.68 15,524.98 PR PR PR Account: 135-50020-030-000 58,554.00 Budgeted Account: 135-50026-030-000-11Pal ce 675 02/07/2020 MUD Payroll 02/07/2020 Medical Insurance 782 02/21/2020 MUD Payroll 02/21/2020 Medical Insurance Account: 135-50026-030-000 Account: Medical Insurance 124,394.00 Budgeted Dental Insurance 675 02/07/2020 MUD Payroll 02/07/2020 Dental Insurance 782 02/21/2020 MUD Payroll 02/21/2020 Dental Insurance Acc Dental Insuraa� 6,464.00 Budgeted 43,029.02 Remaining 22,812.20 27 % Used 3,172.91 25,985.11 3,172.86 29,157.97 Totals: 95,236.03 Remaining 23 % Used 1,268.95 Totals: 4,845.30 Remaining 25 % Used 97 of 157 174.88 1,443.83 PR PR PR 174.87 1,618.70 PR glpdatb2 skrolczyk 11:28 03/10/20 Fund: 135 MUD 1 General Fund ACCO JE JE JE Number Date Description 002:-030- 675 02/07/2020 MUD Payroll 02/07/2020 782 02/21/2020 MUD Payroll 02/21/2020 Account: Account: 135-50029-030-000 626 02/01/2020 February A/P 626 02/01/2020 February A/P 822 02/27/2020 February A?P Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Program: Period Ending: 2/2020 JE Detail Description/Comment sion Inc Vision Insurance Vision Insurance Vision Insuranc> 1,035.00 Budgeted Life Insurance & Other' Employee Benefits Employee LTD & STD caf 125 plan AMENDED March 16, 2020 Regular Meeting Agenda Packet Page 32 Beginning Transaction Transaction Vendor Name Check Source Balance Detail Detail Number (SUBTOTAL) 197.99 Totals: 785.33 Remaining 24 % Used Account: 135-50029-030Ter 4,500.00 Budgeted 2,864.55 Remaining Account: 135-50030-030-000 1 Security Taxes 675 02/07/2020 MUD Payroll 02/07/2020 Social Security Taxes 782 02/21/2020 MUD Payroll 02/21/2020 Social Security Taxes Account: 135-50030-0 25.85 25.83 223.84 249.67 1,291.54 176.22 1,467.76 Humana Inc 151.69 1,619.45 METLIFE GROUP BENEFITS 16.00 1,635.45 BenefitMall 1,635.45 •• 36 % Used PR PR 6136 AP 6145 AP 6214 AP 7,067.51 864.48 7,931.99 PR 858.86 8,790.85 PR Social Security Taxes Totals: 39,215.00 Budgeted Account: 135-50035-030-000 675 02/07/2020 MUD Payroll 02/07/2020 782 02/21/2020 MUD Payroll 02/21/2020 Medicare Taxes Medicare Taxes Medicare Taxes 30,424.15 Remaining 22 % Used 1,652.92 202.17 1,855.09 PR 200.86 2,055.95 PR Medicare Taxes Totals: 40 Account: 135-50040-030-000 675 02/07/2020 MUD Payroll 02/07/2020 782 02/21/2020 MUD Payroll 02/21/2020 Account: 135-50040-030-000 9,171.00 Budgeted Unemployment Taxes Unemployment Taxes Unemployment Taxes Unemployment Taxes 1,440.00 Budgeted Account: 135-50045-03. 70 02/01/2020 Insurance/Wrk Comp Expense Feb Comp 7,115.05 Remaining 22 % Used 1,393.34 Remaining 30.16 419.28 9.64 39.80 6.86 46.66 3 % Used 98 of 157 104.82 524.10 PR PR GL glpdatb2 ekrolczyk 11:28 03/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Program: Period Ending: 2/2020 Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment AMENDED March 16, 2020 Regular Meeting Agenda Packet Page 33 Check Source Number 771 02/17/2020 February A/P 771 02/17/2020 February A/P 869 02/26/2020 PCards 1/28/20-2/26/20 869 02/26/2020 PCards 1/28/20-2/26/20 869 02/26/2020 PCards 1/28/20-2/26/20 869 02/26/2020 PCards 1/28/20-2/26/20 Microsoft exchange internet-February Internet Internet internet Adobe subscription 125,274.22 494.00 125,768.22 M3 Networks 899.00 126,667.22 Charter Communications 42.37 126,709.59 ATT*BILL PAYMENT 53.91 126,763.50 ATT*BILL PAYMENT 42.37 126,805.87 ATT*SILL PAYMENT 36.78 126,842.65 ADOBE ACROPRO SUBS 6208 AP 6202 AP PC PC PC PC 134,681.00 Budgeted 7,838.35 Remaining 94 % Used Account: 135-55070-030-000 755 02/12/2020 revising inv 755 02/12/2020 revising inv 771 02/17/2020 February A/P 771 02/17/2020 February A/P gm consulting -January gm consulting -January GM contract January GM contract January 54,824.49 (10,780.00) (8.70) 10,540.00 8.70 44,044.49 Carman Consulting LLC. 44,035.79 Carman Consulting LLC. 54,575.79 Carman Consulting LLC. 54,584.49 Carman Consulting LLC. 6175 AP 6175 AP 6200 AP 6200 AP Account: 135-55070-030-000 Mr - Independent Labor - Totals: (240.00) 54,584.49 ** 135,000.00 Budgeted 80,415.51 Remaining 40 5 Used Account: 135-55080-030-000 Maintenance & Repairs 1,165.00 99 of 157 .00 1,165.00 Account: 135-50045-030-000 Workman's Compensation Totals: 104.82 524.10 ** 1,775.00 Budgeted 1,250.90 Remaining 30 5 Used Account: 135-50060-030-000 Pre-emp Physicals/Testing .00 .00 Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 5 Used Account: 135-50070-030-000 Employee Relations 3,076.10 .00 3,078.10 Account: 135-50070-030-000 Employee Relations Totals: .00 3,078.10 ** 8,000.00 Budgeted 4,921.90 Remaining 38 % Used Account: 135-55030-030-000 Software & Support 771 02/17/2020 February A/P 771 02/17/2020 February A/P 869 02/26/2020 PCards 1/28/20-2/26/20 869 02/26/2020 PCards 1/28/20-2/26/20 869 02/26/2020 PCards 1/28/20-2/26/20 869 02/26/2020 PCards 1/28/20-2/26/20 Microsoft exchange internet-February Internet Internet internet Adobe subscription 125,274.22 494.00 125,768.22 M3 Networks 899.00 126,667.22 Charter Communications 42.37 126,709.59 ATT*BILL PAYMENT 53.91 126,763.50 ATT*BILL PAYMENT 42.37 126,805.87 ATT*SILL PAYMENT 36.78 126,842.65 ADOBE ACROPRO SUBS 6208 AP 6202 AP PC PC PC PC 134,681.00 Budgeted 7,838.35 Remaining 94 % Used Account: 135-55070-030-000 755 02/12/2020 revising inv 755 02/12/2020 revising inv 771 02/17/2020 February A/P 771 02/17/2020 February A/P gm consulting -January gm consulting -January GM contract January GM contract January 54,824.49 (10,780.00) (8.70) 10,540.00 8.70 44,044.49 Carman Consulting LLC. 44,035.79 Carman Consulting LLC. 54,575.79 Carman Consulting LLC. 54,584.49 Carman Consulting LLC. 6175 AP 6175 AP 6200 AP 6200 AP Account: 135-55070-030-000 Mr - Independent Labor - Totals: (240.00) 54,584.49 ** 135,000.00 Budgeted 80,415.51 Remaining 40 5 Used Account: 135-55080-030-000 Maintenance & Repairs 1,165.00 99 of 157 .00 1,165.00 glpdatb2 skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) AC AMENDED March 16, 2020 Regular Meeting Agenda Packet Page 34 Maintenance & Repairs 15,000.00 Budgeted 13,835.00 Remaining 8 % Used Generator Maint. and Repair 773 02/17/2020 February A/P admin generator repair Account: 135-55085-030-000 Generator Maint. and Repair Totals: 10,000.00 Budgeted 9,469.00 Remaining Account: 135-55120-030-000 822 02/27/2020 February A?P Account: 135-55120-030-000 Account: 135-55160-030-000 Account: 135-55160-030-000 Account: 135-55205-030-000 Account: 135-55205-030-000 Cleaning Services janitorial evc-january g 10,000.00 Budgeted 6,523.76 Professional Outside Services Professional Outside Servi 65,600.00 Budgeted 65,600.00 Utility Billing Contra Utility Billing Contract Remaining Remaining 9,000.00 Budgeted 6,525.19 Remaining Account: 135-60005-030-000 ephone 869 02/26/2020 PCards 1/28/20-2/26/20 phone 869 02/26/2020 PCards 1/28/20-2/26/20 phone 869 02/26/2020 PCards 1/28/20-2/26/20 phone 869 02/26/2020 PCards 1/28/20-2/26/20 answering service 896 02/29/2020 Town Billed Invoices 1726-1729 AR 20200229-20200229 User: 23,680.00 Budgeted 531.00 531.00 Sluder Emergency Power Service 6211 AP 5 % Used 2,607.18 869.06 3,476.24 MEMBER'S BUILDING MAINTENANCE 6230 AP 2,474.81 35 0 Used Used .00 .00 .00 2,474.81 27 % Used 6,125.59 468.11 6,593.70 ATT*BUS PHONE PMT PC 789.08 7,382.78 ATT*BUS PHONE PMT PC 176.78 7,559.56 ATT*BILL PAYMENT PC 19.99 7,579.55 RINGCENTRAL, INC PC (180.00) 7,399.55 AR 16,280.45 Remaining 31 % Used 100 of 157 glpdatb2 skrolczyk 11:28 03/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 2/2020 JE Detail Description/Comment AMENDED March 16, 2020 Regular Meeting Agenda Packet Page 35 Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Check Source Number 747 02/11/2020 February A?P 856 02/28/2020 Pace Credit Card Fees 856 02/28/2020 Pace Credit Card Fees 890 02/28/2020 February A/P 895 02/28/2020 February A/P Dig Tess -January Dig Tess -February Direct send fees -February 26,018.83 210.90 26,229.73 Texas Excavation Safety System 4,833.54 31,063.27 106.42 31,169.69 202.35 31,372.04 Texas Excavation Safety System 50.00 31,422.04 Fisery Solutions, LLC 6194 AP GL GL AP AP Account: 135-60040-030-000 Service Charges & Fees Totals: 5,403.21 31,422.04 ** 67,000.00 Budgeted 35,577.96 Remaining 47 % Used Account: 135-60050-030-000 Bad Debt Expense .00 .00 101 of 157 Account: 135-60010-030-000 Communications/Mobiles 747 02/11/2020 782 02/21/2020 February A?P MUD Payroll Cell phones -February 02/21/2020 Communications/Mobiles 951.81 87.75 150.00 1,039.56 1,189.56 VERIZON WIRELESS 6198 AP PR Account: 135-60010-030-000 Communications/Mobiles Totals: 237.75 1,189.56 ** 4,000.00 Budgeted 2,810.44 Remaining 30 % Used Account: 135-60020-030-000 Electricity/Gas 747 02/11/2020 February A?P gexa energy 12/10-1/10 1,282.43 718.11 2,000.54 TOWN OF TROPHY CLUB 6195 AP Account: 135-60020-030-000 Electricity/Gan Totals: 718.11 2,000.54 ** 6,879.00 Budgeted 4,878.46 Remaining 29 % Used Account: 135-60025-030-000 Water 890 02/28/2020 896 02/29/2020 February A/P Town Billed water-february Invoices 1726-1729 AR 20200229-20200229 User: 241.17 285.43 (142.71) 526.60 383.89 TROPHY CLUB MUD (WATER BILLS) AP AR Account: 135-60025-030-000 Water Totals: 142.72 383.89 ** 1,500.00 Budgeted 1,116.11 Remaining 26 % Used Account: 135-60035-030-000 Postage 6,806.80 .00 6,806.80 Account: 135-60035-030-000 Postage Totals: .00 6,806.80 ** 30,000.00 Budgeted 23,193.20 Remaining 23 % Used Account: 135-60040-030-000 Service Charges & Fees 747 02/11/2020 February A?P 856 02/28/2020 Pace Credit Card Fees 856 02/28/2020 Pace Credit Card Fees 890 02/28/2020 February A/P 895 02/28/2020 February A/P Dig Tess -January Dig Tess -February Direct send fees -February 26,018.83 210.90 26,229.73 Texas Excavation Safety System 4,833.54 31,063.27 106.42 31,169.69 202.35 31,372.04 Texas Excavation Safety System 50.00 31,422.04 Fisery Solutions, LLC 6194 AP GL GL AP AP Account: 135-60040-030-000 Service Charges & Fees Totals: 5,403.21 31,422.04 ** 67,000.00 Budgeted 35,577.96 Remaining 47 % Used Account: 135-60050-030-000 Bad Debt Expense .00 .00 101 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/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-60050-030-000 Bad Debt Expense Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 5 Used Account: 135-60055-030-000 Insurance 70 02/01/2020 Insurance/Wrk Comp Expense Feb 24,431.70 6,998.39 31,430.09 GL Account: 135-60055-030-000 Insurance Totals: 6,998.39 31,430.09 ** 84,000.00 Budgeted 52,569.91 Remaining 37 5 Used Account: 135-60066-030-000 Publications/Books/Subscripts 125.00 .00 125.00 Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 125.00 ** 1,000.00 Budgeted 875.00 Remaining 13 % Used Account: 135-60070-030-000 Dues & Memberships 869 02/26/2020 PCards 1/28/20-2/26/20 prime membership 4,166.55 119.00 4,285.55 AMAZON PRIME*NL52T9C73 PC Account: 135-60070-030-000 Dues & Memberships Totals: 119.00 4,285.55 ** 6,000.00 Budgeted 1,714.45 Remaining 71 % Used Account: 135-60075-030-000 Meeting 61.37 .00 61.37 Account: 135-60075-030-000 iMeetings Totals: .00 61.37 ** 400.00 Budgeted 338.63 Remaining 15 % Used Account: 135-60079-030-000 Public Education 771 02/17/2020 February A/P 869 02/26/2020 PCards 1/28/20-2/26/20 869 02/26/2020 PCards 1/28/20-2/26/20 MUD boundary update real estate sign/frame sign holder 476.20 2,508.78 2,984.98 Halff Associates, INC 6205 AP 595.00 3,579.98 SIGN-A-RAMA PC 229.71 3,809.69 AMZN MKTP US*XJ3GW3BP3 PC Account: 135-60079-030-000 Public Education Totals: 3,333.49 3,809.69 6,000.00 Budgeted 2,190.31 Remaining 63 % Used Account: 135-60080-030-000 Schools & Training 102 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 37 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 869 02/26/2020 PCards 1/28/20-2/26/20 SErolczyk college transcript Account: 135 -60080 -030 - Schools & Training Totals: 6,850.00 Budgeted 1,152.71 10.50 1,163.21 COLLEGE TRANSCRIPT 5,686.79 Remaining 17 % Used 163.21 ** PC Account: 135-60100-030-000 Travel & per diem 695.14 .00 695.14 Account: 135-60100-030-000 Travel & per diem 3,545.00 Budgeted 2,849.86 Remaining 20 % Used Account: 135-60110-030-000 Physicals/Test ng .00 .00 Account: 135-60110-030-000 11111 Physicals/Testing Account: 135-60115-030-000 869 02/26/2020 PCards 1/28/20-2/26/20 869 02/26/2020 PCards 1/28/20-2/26/20 Account Account: 135 -60125 -lime 771 02/17/2020 February A/P 1 Account: 135-60245-030-00 200.00 Budgeted 200.00 Remaining 0 % Used Ballot translate for may elect Ballot translate for may elect .00 Budgeted (138.04) Remaining Adver Advertising 2,500.00 Budgeted 2,500.00 Remaining Secu monitoring svc-feb 1,288.00 Budgeted 1,168.00 Remaining Miscellaneous Expenses 43.01 76.13 119.14 IN *TIN -TRANSLATION IN PC 18.90 138.04 IN *TIN -TRANSLATION IN PC 0 % Used .00 .00 0 % Used 96.00 24.00 120.00 Digital Air Control, Inc 9 % Used 103 of 157 6203 AP AMENDED March 16, 2020 Regular Meeting Agenda Packet glpdatb2 ekrolczyk Trophy Club MUD No.1 Page 38 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/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-60245-030-000 Account: 135-60246-030-000 Account: 135-60246-030-000 17,000.00 Budgeted Account: 135-60360-030-000 Miscellaneous Expenses Totals: 500.00 Budgeted General Manager Contingency General Manager Contingen Furniture/Equipment e Account: 135-60360-030-000 Furniture/Equipme 2,500.00 Budgeted Account: 135-65010-030-000 Uniforms .00 .00 500.00 Remaining 0 % Used 17,000.00 2,500.00 Remaining Remaining Account: 135-65010-030-000 Uniforms 2,050.00 Budgeted 2,050.00 Remaining Account: 135-65055-030-000 Hardware 3,235.24 0 % Used 0 Used 0 % Ueed .00 .00 .00 .00 Account: 135-65055-030-000 Hardware Totals: 26,485.00 Budgeted 23,249.76 Remaining 12 % Ueed .00 .00 .00 3,235.24 Account: 135-65085-030-000 Office Supplies ` 869 02/26/2020 PCarde 1/28/20-2/26/20 Noatry stamp 1,866.47 43.00 1,909.47 AMER ASSOC NOTARIES PC 869 02/26/2020 PCarde 1/28/20-2/26/20 envelopes 29.99 1,939.46 AMZN MKTP US*F09688JJ3 PC 822 02/27/2020 February A?P office supplies 60.83 2,000.29 OFFICE DEPOT, INC 6232 AP 822 02/27/2020 February A?P office supplies 1.95 2,002.24 OFFICE DEPOT, INC 6232 AP Acc Office Supplies 6,000.00 Budgeted 3,997.76 Remaining 33 % Used 104 of 157 glpdatb2 skrolczyk 11:28 03/10/20 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 2/2020 JE Detail Beginning Balance Description/Comment Program: Transaction Detail AMENDED March 16, 2020 Regular Meeting Agenda Packet Page 39 Transaction Vendor Name Detail (SUBTOTAL) Check Source Number Account: 135-65090-030-000 Printer Supplies & Maintenance Account: 135-65090-030-000 Printer Supplies & Maintenance Total= 3,500.00 Budgeted 3,500.00 Remaining Account: 135-65095-030-000 Maintenance Supplies 869 02/26/2020 PCards 1/28/20-2/26/20 popcorn 869 02/26/2020 PCards 1/28/20-2/26/20 tea 869 02/26/2020 PCards 1/28/20-2/26/20 tea 869 02/26/2020 PCards 1/28/20-2/26/20 paper prodcuts, soap, cc 869 02/26/2020 PCards 1/28/20-2/26/20 cofee Maintenance Supplies 4,000.00 Budgeted Totals: 1,301.20 Remaining 2,396.62 0 % Used 67 % Used .00 44.89 11.00 11.00 133.31 101.98 .00 2,441.51 2,452.51 2,463.51 2,596.82 2,698.80 AMAZON.COM*917RX0373 AMAZON. COM*6E84V0UT3 AMAZON.COM*HP6E490B3 SAMSCLUB.COM AMZN MKTP US*7G2DR5YT3 PC PC PC PC PC Account: 135-65105-030-000 Printing Account: 135-65105-030-000 Account: 135-69005-030-000 771 02/17/2020 February A/P Account: 135-69005-030-000 Account: 135-69170-030-000 771 02/17/2020 February A/P 822 02/27/2020 February A?P Department 30 Totals: Printing 2,500.00 Budgeted Capital Outlays GIS development Capital Outlays Totals: 2,500.00 Remaining Totals: 195,000.00 Budgeted 194,952.61 Remaining Copier Lease Installments copier lease-feb copies Copier Lease Installments Totals: 4,000.00 Budgeted 2,728.53 Remaining 64,087.90 Monthly Total .00 0 % Used 47.39 0 % Used .00 47.39 Halff Associates, INC 1,037.66 165.00 1,202.66 TIAA COMMERCIAL FINANCE 68.81 1,271.47 KYOCERA DOCUMENT SOLUTIONS 32 % Used 503,535.76 ** 1,776,712.00 Budgeted 1,273,176.24 Remaining 28 % Used 105 of 157 6205 AP 6212 AP 6226 AP glpdatb2 skrolczyk 11:28 03/10/20 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 39 Non Departmental Period Ending: 2/2020 JE Detail Description/Comment AMENDED March 16, 2020 Regular Meeting Agenda Packet Page 40 Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Check Source Number Department 39 Totals: Fund 135 Totals: 4,000.00 Budgeted 10,666.00 Monthly Total 244.00 Remaining 94 % Used 93,350.22 ** 184,561.00 Budgeted 91,210.78 Remaining 51 % Used 153,648.25 (12,750.98) Monthly Total (6,224.00) Budgeted (159,872.25) Remaining ########## 106 of 157 Account: 135-55045-039-000 Legal 747 02/11/2020 February A?P 749 02/12/2020 February A/p Westlake legal easement 46,036.39 5,566.00 5,100.00 51,602.39 56,702.39 WHITAKER CHALK SWINDLE McLean & Howard, L.L.P. 6199 6185 AP AP Account: 135-55045-039-000 Legal Totals: 10,666.00 56,702.39 ** 135,000.00 Budgeted 78,297.61 Remaining 42 % 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 5,178.56 .00 5,178.56 Account: 135-55060-039-000 Appraisal Totals: .00 5,178.56 ** 11,761.00 Budgeted 6,582.44 Remaining 44 % Used Account: 135-55065-039-000 Tax Admin Fees 3,756.00 .00 3,756.00 Account: 135-55065-039-000 Tax Admin Fees Totals: .00 3,756.00 ** Department 39 Totals: Fund 135 Totals: 4,000.00 Budgeted 10,666.00 Monthly Total 244.00 Remaining 94 % Used 93,350.22 ** 184,561.00 Budgeted 91,210.78 Remaining 51 % Used 153,648.25 (12,750.98) Monthly Total (6,224.00) Budgeted (159,872.25) Remaining ########## 106 of 157 glpdatb2 skrolczyk 11:28 03/10/20 Fund: 137 MUD 1 Consolidated GASB JE JE JE Number Date Description Department: JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 2/2020 Beginning Balance AMENDED March 16, 2020 Regular Meeting Agenda Packet Page 41 Program: Transaction Transaction Vendor Name Detail Detail (SUBTOTAL) Check Source Number Department Totals: Fund 137 Totals: .00 Monthly Total .00 Monthly Total .00 Budgeted .00 Budgeted 107 of 157 (286,420.00) ** 286,420.00 Remaining 0 % Used (286,420.00) 286,420.00 Remaining 0 % Used Account: 137-49145-000-000"IIII Intergov Transfer -General Fund (205,000.00) .00 (205,000.00) Account: 137-49145-000-000 Intergov Transfer -General Fund Totals: .00 (205,000.00) ** .00 Budgeted 205,000.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer -Fire Dept (81,420.00) .00 (81,420.00) Account: 137-49146-000-000 Intergov Transfer -Fire Dept Totals: ; .00 (81,420.00) ** .00 Budgeted 81,420.00 Remaining 0 % Used Department Totals: Fund 137 Totals: .00 Monthly Total .00 Monthly Total .00 Budgeted .00 Budgeted 107 of 157 (286,420.00) ** 286,420.00 Remaining 0 % Used (286,420.00) 286,420.00 Remaining 0 % Used AMENDED March 16, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - WWTP TAX BOND CONST BALANCE SHEET FEBRUARY 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 517 TAX BOND CONSTRUCTION 541,004 TOTAL ASSETS 541,004 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 690,547 TOTAL LIABILITIES 690,547 FUND BALANCE ASSIGNED FUND BALANCE (118,409) NET REVENUES / EXPENDITURES (31,133) TOTAL FUND BALANCE (149,543) TOTAL LIABILITIES AND FUND BALANCE 541,004 108 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 2/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1 517-49011-000-000 Interest Income 689.02- 4,038.13- 4,038.13 Page 14 Subtotal: 689.02- 4,038.13- 4,038.13 Program number: 689.02- 4,038.13- 4,038.13 Department number: Revenues i 689.02- 4,038.13- 4,038.13 Revenues Subtotal 689.02- 4,038.13- 4,038.13 109 of 157 glbase_tbam skrolczyk 11:28 03/10/20 Fund: 517 2014 MUD 1 Tax Bond Const WWTP Account Description 517-69005-020-000 Capital Outlays Subtotal: Department number: Wastewater Expenditures AMENDED March 16, 2020 Regular Meeting Agenda Packet Trophy Club MUD No.1 Budget Summary with Amendment Department: 20 Wastewater Program: Period Ending: 2/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 110 of 157 12,075.41 35,171.41 35,171.41- 12,075.41 35,171.41 35,171.41- 12,075.41 35,171.41 35,171.41- 12,075.41 35,171.41 35,171.41- 12,075.41 35,171.41 35,171.41- 11,386.39 31,133.28 31,133.28 - Page 15 AMENDED March 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-49011-000-000 Interest Income 857 02/28/2020 Bank Interest- February (3,349.11) (689.02) (4,038.13) GL Account Interest Income Totals: .00 Budgeted 4,038.13 Remaining 0 % Used Department Totals: (4,038.13) ** (689.02) Monthly Total .00 Budgeted 111 of 157 4,038.13 Remaining 0 % Used AMENDED March 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 43 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) A000unt: 517-69005-02hL 0-000 747 02/11/2020 February AMP 771 02/17/2020 February A/P 830 02/28/2020 February A/P 830 02/28/2020 February A/P Accor Capital Outlays WWTP Lege WWTP legal WWTP Crane survey WWTP Improvements Capital Outlays .00 Budgeted 23,096.00 _ Totals: (35,171.41) Remaining 0 % Used 5,985.00 1,020.00 2,112.50 2,957.91 29,081.00 CP&Y/WALLACE GROUP, INC. 30,101.00 Dubois Bryant Campbell LLP 32,213.50 Wiss, Janney, Elstner Assoc 35,171.41 CP&Y/WALLACE GROUP, INC. Department 20 Totals: 35,171.41 ** 12,075.41 Monthly Total .00 Budgeted (35,171.41) Remaining 0 % Used Fund 517 Totals: 31,133.28 11,386.39 Monthly Total .00 Budgeted 112 of 157 (31,133.28) Remaining 0 is Used 6178 AP 6204 AP 6241 AP 6238 AP AMENDED March 16, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET FEBRUARY 2020 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 5111, TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 784,091 TOTAL ASSETS 784,091 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 157 81,691 81,691 698,648 3,752 702,400 784,091 AMENDED March 16, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const -SWIFT Department: Revenues Program: Period Ending: 2/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1 1 519-49011-000-000 Interest Income 649.96- 3,751.83- 3,751.83 Page 16 Subtotal: 649.96- 3,751.83- 3,751.83 wIM Program number: 649.96- 3,751.83- 3,751.83 Department number: Revenues 649.96- 3,751.83- 3,751.83 Revenues Subtotal 649.96- 3,751.83- 3,751.83 I Fund number: 519 2016 Rev Bond Const -SWIFT 114 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet glpdatb2 akrolczyk Trophy Club MUD No.1 Page 44 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const -SWIFT Department: Revenues Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 519-49011-000-000 Interest Income 857 02/28/2020 Bank Interest- February Account Interest Income .00 Budgeted (3,101.87) (649.96) (3,751.83) GL ) ** 3,751.83 Remaining 0 % Used Department Totals: (3,751.83) ** (649.96) Monthly Total .00 Budgeted 3,751.83 Remaining 0 % Used Fund 519 Totals: (3,751.83) (649.96) Monthly Total .00 Budgeted 115 of 157 3,751.83 Remaining 0 % Used AMENDED March 16, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET FEBRUARY 2020 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND CASH IN BANK 552,653 INVESTMENTS 3,888,180 ACCOUNTS RECEIVABLE TOTAL ASSETS 4,440,833 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 89,353 TOTAL LIABILITIES 89,353 FUND BALANCE ASSIGNED FUND BALANCE 4,454,290 NET REVENUES / EXPENDITURES (102,809) TOTAL FUND BALANCE 4,351,481 TOTAL LIABILITIES AND FUND BALANCE 4,440,834 116 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 Page 17 11:28 03/10/20 Budget Summary with Amendment Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 2/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,921.20- 22,629.01- 22,629.01 Subtotal: 3,921.20- 22,629.01- 22,629.01 Program number: 3,921.20- 22,629.01- 22,629.01 Department number: i 3,921.20- 22,629.01- 22,629.01 Revenues Subtotal 3,921.20- 22,629.01- 22,629.01 117 of 157 glbase_tbam skrolczyk 11:28 03/10/20 Fund: 520 Revenue Bond 16" Waterline Account 1 520-69005-010-000 Description Capital Outlays Trophy Club MUD No.1 Budget Summary with Amendment Department: 10 Water Department Period Ending: 2/2020 Adopted Amended Total Current Budget Budget Encumb. Month 89,995.85 Program: YTD Total 125,438.76 AMENDED March 16, 2020 Regular Meeting Agenda Packet % of Remaining Budget Budget 125,438.76 - Page 18 118 of 157 Subtotal: 89,995.85 125,438.76 125,438.76 - Program number: 89,995.85 125,438.76 125,438.76 - Department number: Water Department 89,995.85 125,438.76 125,438.76 - Expenditures Subtotal 89,995.85 125,438.76 125,438.76 - Fund number: 520 Revenue Bond 16" Waterline 86,074.65 102,809.75 102,809.75- 118 of 157 glpdatb2 skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16. Waterline Department: Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) AMENDED March 16, 2020 Regular Meeting Agenda Packet Page 45 Account: 520-49011-000-0 857 02/28/2020 Bank Interest- February 857 02/28/2020 Bank Interest- February Account: 520-490 Interest Income Totals: .00 Budgeted (18,707.81) (698.14) (19,405.95) GL (3,223.06) (22,629.01) GL 22,629.01 Remaining 0 % Used Department Totals: (22,629.01) ** (3,921.20) Monthly Total .00 Budgeted 119 of 157 22,629.01 Remaining 0 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) AMENDED March 16, 2020 Regular Meeting Agenda Packet Page 46 ACCOyit: 520-69005-010-000 i 771 02/17/2020 February A/P 830 02/28/2020 February A/P 836 02/28/2020 February A/P 836 02/28/2020 February A/P Department 10 Totals: Capital Outlays Easement acquisition Easement legal 16" water Line easement 16" Water Line easement Capital Outlaysl .00 Budgeted 35,442.91 643.29 36,086.20 Halff Associates, INC 6205 AP 20,150.56 56,236.76 Jackson Walker LLP 6239 AP 64,106.00 120,342.76 Trophy Club Economic Dev Corp 6240 AP 5,096.00 125,438.76 Trophy Club Economic Dev Corp 6240 AP Totals: (125,438.76) Remaining 0 % Used 89,995.85 125,438.76 ** 89,995.85 Monthly Total .00 Budgeted (125,438.76) Remaining 0 % Used Fund 520 Totals: 102,809.75 86,074.65 Monthly Total .00 Budgeted (102,809.75) Remaining 0 % Used 120 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET FEBRUARY 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE MIA TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 860,996 TOTAL ASSETS 860,996 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 121 of 157 803,457 57,539 860,996 860,996 AMENDED March 16, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 Page 19 11:28 03/10/20 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 2/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- 1,077.76- 5,789.00- 52.627 5,211.00- 528-49142-000-000 Interfund transfer in -Water 307,049.00- 307,049.00- 4,600.00- 23,000.00- 7.491 284,049.00- 528-49143-000-000 Interfund transfer in -WW 200,417.00- 200,417.00- 5,750.00- 28,750.00- 14.345 171,667.00- Subtota1: m 518,466.00- 518,466.00- 7,539.00- , 11.098 460,927.00 - Program number: 518,466.00- 518,466.00- 57,539.00- , 11.098 460,927.00 - Department number: 518,466.00- 518,466.00- 57,539.00- m 11.098 460,927.00 - Revenues Subtotal 518,466.00- 518,466.00- 57,539.00- 11.098 460,927.00 - Fund number: 528 2015 Revenue Bond Reserve Fund 518,466.00- 518,466.00- 57,539.00- 111.11.1. 460,927.00- 122 of 157 glpdatb2 skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) AMENDED March 16, 2020 Regular Meeting Agenda Packet Page 47 Account: 528-49011-000-000 Interest Income 857 02/28/2020 Bank Interest- February (4,711.24) (1,077.76) (5,789.00) GL Ac come 1 (11,000.00) Budgeted Account: 528-49142-000-000 798 02/21/2020 TexPool Transfers February (5,211.00) Remaining 53 % Used TexPool O&M to Rev Bond Resevr (18,400.00) Account Interfund transfer in -Water Totals: (307,049.00) Budgeted (284,049.00) Remaining Interfund transfer in -WW 798 02/21/2020 TexPool Transfers February TexPool O&M to Rev Bond Resevr Account: 528-49143-11Interfund transfer i (200,417.00) Budgeted (23,000.00) (171,667.00) Remaining (4,600.00) (23,000.00) 7 % Used (5,750.00) 14 % Used (28,750.00) Department Totals: (57,539.00) ** (11,427.76) Monthly Total (518,466.00) Budgeted (460,927.00) Remaining 11 % Used Fund 528 Totals: (57,539.00) (11,427.76) Monthly Total (518,466.00) Budgeted (460,927.00) Remaining 11 % Used 123 of 157 GL GL AMENDED March 16, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET FEBRUARY 2020 ASSETS CASH IN BANK INVESTMENTS 905,362 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 35,640 ACCOUNTS RECEIVABLE -OTHER - TOTAL ASSETS 941,002 TROPHY CLUB MUNICIPAL UTILITY DISTRICT INTEREST & SINKING- 533 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 35,640 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 35,640 FUND BALANCE ASSIGNED FUND BALANCE 82,954 NET REVENUES / EXPENDITURES 822,408 TOTAL FUND BALANCE 905,362 TOTAL LIABILITIES AND FUND BALANCE 941,002 124 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 2/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 533-40002-000-000 533-40015-000-000 533-49011-000-000 533-49015-000-000 533-49141-000-000 Subtot Property Taxes Property Taxes/Delinquent Property Taxes/P & I Interest Income Lease/Rental Income Interfund Trans In -PID Surchg Program number: Department number: Revenues Revenues Subtotal 682,441.00- 1,000.00- 2,000.00- 682,441.00- 1,000.00- 2,000.00- 685,441.00- 685,441.00- 5,000.00- 218,004.00- 114,563.00- 5,000.00- 218,004.00- 114,563.00- 337,567.00- 1,023,008.00- 1,023,008.00- 1,023,008.00- 1,023,008.00- 0- 0- 1,023,008.00- 125 of 157 63,144.34- 946.27- 655.33- 64,745.94- 1,036.69- 218,004.00- 10,414.81- 672,711.98- 1,579.73- 1,004.82- 2,412.40- 218,004.00- 52,074.05- 272,490. 98.574 157.973 50.241 98.520 48.248 100.000 45.455 9,729.02- 579.73 995.18- 2,587.60- 62,488.95- 92.647 75,221.02- 44- 947,786.98- 92.647 75,221.02- 92.647 75,221.02- 44- 947,786. 44- 947,786.98 - Page 20 glbase_tbam skrolczyk 11:28 03/10/20 Fund: 533 MUD 1 I&S Consolidated Account Description 533-70005-051-000 533-70025-051-000 1 533-70035-051-000 Payin$g Agent Fee Bond 2nterest Expense -Tax Bond Principal Payment -Tax Trophy Club MUD No.1 Budget Summary with Amendment Department: 51 Administration Period Ending: 2/2020 Adopted Amended Total Current Budget Budget Encumb. Month 2,150.00 2,150.00 247,858.00 247,858.00 765,000.00 765,000.00 1,450.00 123,928.75 AMENDED March 16, 2020 Regular Meeting Agenda Packet Program: YTD % of Remaining Total Budget Budget 1,450.00 123,928.75 67.442 50.000 700.00 123,929.25 765,000.00 Page 21 Subtotal: 1,015,008.00 1,015,008.00 125,378.75 125,378.75 12.352 889,11r.25 Program number: 1,015,008.00 1,015,008.00 125,378.75 125,378.75 12.352 889,629.25 Department number: Administration 1,015,008.00 1,015,008.00 125,378.75 125,378.75 12.352 889,629.25 Expenditures Subtotal 1,015,008.00 1,015,008.00 125,378.75 125,378.75 12.352 889,629.25 Fund number: 533 MUD 1 I&S Consolidated 8,000.00- 8,000.00- 168,822.69- 822,408.23- ############### 814,408.23 126 of 157 glpdatb2 skrolczyk 11:28 03/10/20 Fund: 533 MUD 1 I&S Consolidated JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 2/2020 JE Detail Description/Comment AMENDED March 16, 2020 Regular Meeting Agenda Packet Page 48 Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Check Source Number 867 02/03/2020 Property Taxes 870 02/04/2020 property taxes 871 02/05/2020 property taxes 872 02/06/2020 property taxes 875 02/07/2020 property taxes 876 02/10/2020 property taxes 877 02/11/2020 property taxes 878 02/12/2020 property taxes 879 02/13/2020 property taxes 880 02/18/2020 property taxes 881 02/19/2020 property taxes 882 02/20/2020 property taxes 883 02/21/2020 property taxes 884 02/24/2020 property taxes 885 02/25/2020 property taxes 886 02/26/2020 property taxes 887 02/27/2020 property taxes 888 02/28/2020 property taxes (609,567.64) (9,894.38) (619,462.02) (8,101.32) (627,563.34) (9,154.58) (636,717.92) (7,308.34) (644,026.26) (22,633.07) (666,659.33) (143.86) (666,803.19) (9.49) (666,812.68) (.04) (666,812.72) (339.25) (667,151.97) (151.76) (667,303.73) (.01) (667,303.74) (179.72) (667,483.46) (487.96) (667,971.42) (1,510.90) (669,482.32) (266.42) (669,748.74) (231.94) (669,980.68) (1,136.55) (671,117.23) (1,594.75) (672,711.98) GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL GL Account: 533-40000-000-000 Property Taxes Totals: (63,144.34) (672,711.98) ** ■ (682,441.00) Budgeted (9,729.02) Remaining 99 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 867 02/03/2020 Property Taxes 871 02/05/2020 property taxes 872 02/06/2020 property taxes 883 02/21/2020 property taxes 886 02/26/2020 property taxes 887 02/27/2020 property taxes (633.46) (57.25) (3.74) (837.11) (34.15) (6.17) (7.85) (690.71) (694.45) (1,531.56) (1,565.71) (1,571.88) (1,579.73) GL GL GL GL GL GL Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (946.27) (1,579.73) ** (1,000.00) Budgeted 579.73 Remaining 158 % Used Account: 533-40015-000-000 Property Taxes/P & I 867 02/03/2020 Property Taxes 871 02/05/2020 property taxes 872 02/06/2020 property taxes 875 02/07/2020 property taxes 876 02/10/2020 property taxes 877 02/11/2020 property taxes (349.49) 127 of 157 (11.62) (361.11) (.90) (362.01) (192.04) (554.05) (76.27) (630.32) (10.07) (640.39) (.66) (641.05) GL GL GL GL GL GL AMENDED March 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 879 02/13/2020 property taxes 880 02/18/2020 property taxes 882 02/20/2020 property taxes 884 02/24/2020 property taxes 885 02/25/2020 property taxes 886 02/26/2020 property taxes 887 02/27/2020 property taxes 888 02/28/2020 property taxes Account: 533-40015-000-000 Ac 0 : 533 -49011 -000 - Property Taxes/P & I (2,000.00) Budgeted 857 02/28/2020 Bank Interest- February Accountil Interest Income (5,000.00) Budgeted Account: 533-49015-000-000 Lease/Rental Income 799 02/21/2020 Fire Rent Transfer 2020 Account: 533-49015-000-000 Lease/Rental Income (218,004.00) Budgeted (995.18) Remaining (349.49) (23.74) (664.79) GL (.38) (665.17) GL (12.58) (677.75) GL (105.74) (783.49) GL (15.99) (799.48) GL (17.59) (817.07) GL (81.04) (898.11) GL (106.71) (1,004.82) GL 50 % Used (1,375.71) 3) (1,004.82) ** (1,036.69) (2,587.60) Remaining 48 % Ueed Totals: ' .00 Remaining Account: 533-49141-000-00 Interfund Trans In -PID Surchg 798 02/21/2020 TexPool Transfers February TexPool O&M to I&S- PID Debt 100 % Ueed (41,659.24) Account: 533-49141-000-000 Interfund Trans In -PID Surchg Total.. (114,563.00) Budgeted (62,488.95) Remaining Department Totals: (2,412.40) (218,004.00) (218,004.00) (218,004.00) (10,414.81) 45 % Used (52,074.05) (947,786.98) ** (294,201.44) Monthly Total (1,023,008.00) Budgeted (75,221.02) Remaining 93 % Used 128 of 157 GL GL GL AMENDED March 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 50 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Accoaaot: 533-70005-051- Paying Agent Fee 820 02/24/2020 3/1/20 Bond Payments INTEREST BOKF Unl Tax Bond, 1TROP1214UT 200.00 200.00 GL 820 02/24/2020 3/1/20 Bond Payments INTEREST TCMUD-12 500.00 700.00 GL 820 02/24/2020 3/1/20 Bond Payments INTEREST TCMUD-10 750.00 1,450.00 GL Account: Paying Agent Fee 2,150.00 Budgeted 700.00 Remaining 67 % Used Account: 533-70025-051-00 Bond Interest Expense -Tax 820 02/24/2020 3/1/20 Bond Payments INTEREST BOKF Unl Tax Bond, 1TROP1214UT 820 02/24/2020 3/1/20 Bond Payments INTEREST BNY MELLON Unl Tax Series 2010 820 02/24/2020 3/1/20 Bond Payments INTEREST BNYMELLON Unl Tax Ref Ser 2012 820 02/24/2020 3/1/20 Bond Payments INTEREST BNYMELLON Unl Tax Ref Ser 2013 Accoun70025-051-0U Account: 533-70035-051-000 Bond Interest Expense -Tax Totals: 247,858.00 Budgeted 123,929.25 Remaining Bond Principal Payment -Tax Account: 533-70035-051-000 Bond Principal Payment -T 765,000.00 Budgeted Department 51 Totals: 765,000.00 Remaining 50 % Used 0 Used 66,887.50 29,953.75 14,175.00 12,912.50 .00 66,887.50 96,841.25 111,016.25 123,928.75 .00 125,378.75 ** 125,378.75 Monthly Total 1,015,008.00 Budgeted 889,629.25 Remaining 12 % Used Fund 533 Totals: (822,408.23) (168,822.69) Monthly Total (8,000.00) Budgeted 814,408.23 Remaining 868888*8*8 129 of 157 GL GL GL GL AMENDED March 16, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET FEBRUARY 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 193,249 TOTAL ASSETS 193,249 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 130 of 157 24,518 168,732 193,249 193,249 AMENDED March 16, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 2/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1 1 534-49011-000-000 1 534-49143-000-000 Interest Income Interfund Transfer In -WW Sales 2,500.00- 598,638.00- 2,500.00- 598,638.00- 300.99- 54,421.63- 942.91- 272,107.55- 37.716 45.454 1,557.09- 326,530.45 - Page 22 Subtotal: 601,138.00- 601,138.00- 54,722.62- 273,050.46- 45.422 328,087.54 - Program number: 601,138.00- 601,138.00- 54,722.62- 273,050.46- 45.422 328,087.54 - Department number, Revenues 601,138.00- 601,138.00- 54,722.62- 273,050.46- 45.422 328,087.54 - Revenues Subtotal 601,138.00- 601,138.00- 54,722.62- 273,050.46- 45.422 328,087.54- 131 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 2/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Page 23 534-70005-051-000 Rev Bond Paying Agent Fee 400.00 400.00 200.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 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 Subtotal: , 598,638.00 598,638.00 . 104,318.75 17.426 494,319.25 Program number: III 598,638.00 598,638.00 104,318.75 10 17.426 494,319.25 Department number: Administration III 598,638.00 598,638.00 104,318.75 10 17.426 494,319.2 Expenditures Subtotal ill 598,638.00 598,638.00 104,318.75 1011111:75 17.426 494,31 Fund number: 534 2015 Revenue Bond I&S M2,500.00- 2,500.00- 49,596.13 161111.71- 49.268 166,231.71 132 of 157 glpdatb2 skrolczyk 11:28 03/10/20 Fund: 534 2015 Revenue Bond I&S JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 2/2020 JE Detail Description/Comment AMENDED March 16, 2020 Regular Meeting Agenda Packet Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 51 Check Source Number Department Totals: (54,722.62) Monthly Total (273,050.46) ** (601,138.00) Budgeted (328,087.54) Remaining 45 5 Used 133 of 157 Account: 534-49011-000-000 Interest Income 857 02/28/2020 Bank Interest- February (641.92) (300.99) (942.91) GL Account: 534-49011-000-000 Interest Income Totals: (300.99) (942.91) ** (2,500.00) Budgeted (1,557.09) Remaining 38 % Used Account: 534-49143-000-000 Interfund Transfer In -WW Sales 798 02/21/2020 TexPool Transfers February TexPool O&M to Rev Bd WWTP I&S (217,685.92) (54,421.63) (272,107.55) GL Account: 534-49143-000-000 Interfund Transfer In -WW Sales Totals: (54,421.63) (272,107.55) ** (598,638.00) Budgeted (326,530.45) Remaining 45 % Used Department Totals: (54,722.62) Monthly Total (273,050.46) ** (601,138.00) Budgeted (328,087.54) Remaining 45 5 Used 133 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 52 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond IRS Department: 51 Administration Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Acco lt: 534-70005-051- Rev Bond Paying Agent Fee 820 02/24/2020 3/1/20 Bond Payments INTEREST BOKF Rev Bond WWTP 1TROP215WSS Acil Rev Bond Paying Agent 400.00 Budgeted 200.00 Remaining Account: 534-70040-051-000_ Revenue Bond Interest Expense 820 02/24/2020 3/1/20 Bond Payments INTEREST BOKF Rev Bond WWTP 1TROP215WSS Account: 0040-051-000 — Revenue Bond Interest Expense Totals: 208,238.00 Budgeted 104,119.25 Remaining 50 200.00 200.00 GL Used 104,118.75 104,118.75 GL 50 % Ueed Account: 534-70045-051-000 Revenue Bond Principal Expense .00 .00 1111111111111145-051-000 Revenue Bond Principal Expense Totals: 390,000.00 Budgeted 390,000.00 Remaining Department 51 Totals: 0 % Used 104,318.75 ** 104,318.75 Monthly Total 598,638.00 Budgeted 494,319.25 Remaining 17 % Used Fund 534 Totals: (168,731.71) 49,596.13 Monthly Total (2,500.00) Budgeted 166,231.71 Remaining ########## 134 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET FEBRUARY 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE PIA TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 100,337 TOTAL ASSETS 100,337 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 135 of 157 4,967 95,370 100,337 100,337 AMENDED March 16, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 2/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- 136 of 157 135.15- 25,047.72- 111111111111111 - 1111111111112.87- 394.27- 125,238.60- 39.427 45.455 605.73- 150,286.40- 125, .433 f50,892.13- 125,632.87- 125,632.87- 125,632.87- 45.433 45.433 45.433 150,892.13- 150,892.13- 150,892.13 - Page 24 AMENDED March 16, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 2/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-70005-051-000 Rev Bond Paying Agent Fee 800.00 800.00 535-70040-051-000 Revenue Bona Interest Expense 386,811.00 386,811.00 535-70045-051-000 Revenue Bond Principal Expense 215,000.00 215,000.00 Subtotal: ,111111102,611.00 602,611.00 Program number: _b02,611.00 602,611.00 Department number: Administration mEr 602,611.00 602,611.00 Expenditures Subtotal 602,611.00 602,611.00 Fund number: 535 2016 Rev Bond I&S-SWIFT 326,086.00 326,086.00 137 of 157 200.00 30,062.50 30,262.50 30,262.50 ■ 30,262.50 30,262.50 • 5,079.63 200.00 25.000 30,062.50 7.772 30,262.50 30,262.50 30,262.50 30,262.50 95,370.37- 5.022 5.022 5.022 5.022 -29.247 600.00 356,748.50 215,000.00 572,348.50 572,348.50 572,348.50 572,348.50 421,456.37 Page 25 glpdatb2 skrolczyk 11:28 03/10/20 Fund: 535 2016 Rev Bond I&S-SWIFT JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 2/2020 JE Detail Description/Comment AMENDED March 16, 2020 Regular Meeting Agenda Packet Program: Beginning Transaction Transaction Vendor Name Balance Detail Detail (SUBTOTAL) Page 53 Check Source Number Department Totals: (25,182.87) Monthly Total (125,632.87) ** (276,525.00) Budgeted (150,892.13) Remaining 45 5 Used 138 of 157 Account: 535-49011-000-000 Interest Income 857 02/28/2020 Bank Interest- February (259.12) (135.15) (394.27) GL Account: 535-49011-000-000 Interest Income Totals: i (135.15) (394.27) ** (1,000.00) Budgeted (605.73) Remaining 39 % Used Account: 535-49142-000-000 Interfund Tran In -Water Sales 798 02/21/2020 TexPool Transfers February TexPool O&M to 16Swift Rev I&S (100,190.88) (25,047.72) (125,238.60) GL Account: 535-49142-000-000 Interfund Tran In -Water Sales Totals: Mr (25,047.72) (125,238.60) ** (275,525.00) Budgeted (150,286.40) Remaining 45 5 Used Department Totals: (25,182.87) Monthly Total (125,632.87) ** (276,525.00) Budgeted (150,892.13) Remaining 45 5 Used 138 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 54 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Accojt: 535-70005-051- Rev Bond Paying Agent Fee 820 02/24/2020 3/1/20 Bond Payments INTEREST BOKF SWIFT 1TROP1116WSS 200.00 Acil Rev Bond Paying Agent 800.00 Budgeted 600.00 Remaining 25 % Used Account: 535-70040-051-000_ Revenue Bond Interest Expense 820 02/24/2020 3/1/20 Bond Payments INTEREST BOKF SWIFT 1TROP1116WSS 30,062.50 Account: 0040-051-000 — Revenue Bond Interest Expense Totals: 386,811.00 Budgeted 356,748.50 Remaining 8 % Ueed 200.00 GL 30,062.50 GL Account. 535-70045-051-000 Revenue Bond Principal Expense Account: 535-70045-051-000 Revenue Bond Principal Expense Totals: 215,000.00 Budgeted 215,000.00 Remaining .00 .00 0 % Used Department 51 Totals: 30,262.50 ** 30,262.50 Monthly Total 602,611.00 Budgeted 572,348.50 Remaining 5 % Used Fund 535 Totals: (95,370.37) 5,079.63 Monthly Total 326,086.00 Budgeted 421,456.37 Remaining -29 % Used 139 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET FEBRUARY 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE ILIP TROPHY CLUB J MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 23,261 TOTAL ASSETS 23,261 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES 23,261 TOTAL FUND BALANCE 23,261 TOTAL LIABILITIES AND FUND BALANCE 23,261 140 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet glbase tbam skrolczyk Trophy Club MUD No.1 11:28 03/10/20 Budget Summary with Amendment Fund: 536 2019 Rev Bond 1&S- W&WW System Department: Revenues Program: Period Ending: 2/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Page 26 1 536-49011-000-000 Interest Income 141.18- 414.96- 414.96 1 1 536-49142-000-000 Interfund Tran In -Water Sales 91,584.08- 183,168.16- 183,168.16 1 1 536-49143-000-000 Interfund Transfer In -WW Sales 27,356.28- 54,712.56- 54,712.56 1 Subtotal: 119,081.54- 238,155.68- 238,295.68 Program number: 119,081.54- 238,295.68- 238,295.68 Department number: Revenues 119,081.54- 238,295.68- 238,295.68 I Revenues Subtotal 119,081.54- 238,295.68- 238,295.68 141 of 157 glbase_tbam skrolczyk 11:28 03/10/20 Fund: 536 2019 Rev Bond I&S- W&WW System Account Description 536-70005-051-000 536-70040-051-000 Subtot Rev Bond Paying Agent Fee Revenue Bond Interest Expense Department number: Administration Fund number: 536 2019 Rev Bond I&S- W&WW System ******* End of Report ********* AMENDED March 16, 2020 Regular Meeting Agenda Packet Trophy Club MUD No.1 Budget Summary with Amendment Department: 51 Administration Program: Period Ending: 2/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 142 of 157 142.08 214,892.43 142.08 214,892.43 23,261.17- 142.08- 214,892.43- 21 23,261.17 Page 27 AMENDED March 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 55 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 536 2019 Rev Bond 1&S- W&WW System Department: Revenues Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 536-49011-000-000 Interest Income 857 02/28/2020 Bank Interest- February (273.78) (141.18) (414.96) GL Account: 536-49011-000-000 Interest Income Totals: (141.18) (414.96) ** .00 Budgeted 414.96 Remaining 0 9 Used Account: 536-49142-000-000 Interfund Tran In -Water Sales 798 02/21/2020 TexPool Transfers February TexPool O&M to 19 W&WW Rev I&S (91,584.08) (91,584.08) (183,168.16) GL Account: 536-49142-000-000 Interfund Tran In -Water Sales Totals: (91,584.08) (183,168.16) ** .00 Budgeted 183,168.16 Remaining 0 % Used Account: 536-49143-000-000 Interfund Transfer In -WW Sales 798 02/21/2020 TexPool Transfers February TexPool O&M to 19 W&WW Rev I&S (27,356.28) (27,356.28) (54,712.56) GL Account: 536-49143-000-000 Interfund Transfer In -WW Sales Totals: (27,356.28) (54,712.56) ** .00 Budgeted 54,712.56 Remaining 0 % Used Department Totals: (238,295.68) ** (119,081.54) Monthly Total .00 Budgeted 143 of 157 238,295.68 Remaining 0 % Used AMENDED March 16, 2020 Regular Meeting Agenda Packet glpdatb2 skrolczyk Trophy Club MUD No.1 Page 56 11:28 03/10/20 Detailed Accounting Trial Balance Fund: 536 2019 Rev Bond 2&S- W&WW System Department: 51 Administration Program: Period Ending: 2/2020 JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Accost: 536-70005-051- Rev Bond Paying Agent Fee 11111111111111111 820 02/24/2020 3/1/20 Bond Payments INTEREST BOKF REV BOND 1TROP419WSSR 142.08 Acilking Agent .00 Budgeted (142.08) Remaining 0 % Used Account: 536-70040-051-000_ Revenue Bond Interest Expense 820 02/24/2020 3/1/20 Bond Payments INTEREST BOKF REV BOND 1TROP419WSSR 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: 215,034.51 Monthly Total 95,952.97 Monthly Total 0 % Used 142.08 GL 214,892.43 GL 43 ** 215,034.51 ** .00 Budgeted (215,034.51) Remaining 0 % Used (23,261.17) .00 Budgeted 23,261.17 Remaining 0 % Used ******* End of Report ********* (1,635,095.78) **** 219,038.07 Monthly Total (209,104.00) Budgeted 1,425,991.78 Remaining 782 % Used 144 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet BUDGET VARIANCE REPORT FUND: 122 - Fire O&M FINANCIALS MONTH: February 2020 REVENUE VARIANCE: 33.2% EXPENSE VARIANCE: 51.5% NOTE: Explanation provided for all accounts with a Year -To -Date percentage (YTD%) less than the Revenue Variance and greater than or equal to the Expense Variance. The Revenue and Expense Variance is calculated on a straight-line method (Financials Month x 8.3%), less 8.3% for revenues and plus 10% for expenses. Only accounts with current month activity will be listed ACCOUNT DESCRIPTION TOTAL BUDGET CURRENT MONTH YTD TOTAL YTD % DATE OF COMMENT VARIANCE EXPLANATION FIRE REVENUES 122-40010 Property Taxes/Mud Fire $1,214,230 $112,349 $1,196,918 98.57% 10/2019 Property Taxes/MUD Fire 122-40011 Property Taxes/Fire - Delinquent $1,400 $2,422 10/2019 Delinquent Fire Taxes collected/paid out 122-40020 Property Taxes/Fire P&I $1,185 $2,832 10/2019 Fire Taxes Penalties & Interest collected FIRE EXPENSES 122-60030-045 Rent and/or Usage 218,004 218,004 218,004 100.00% 02/2020 Annual Rent Payment 145 of 157 BUDGET VARIANCE FUND: FINANCIALS MONTH: REVENUE VARIANCE: EXPENSE VARIANCE: NOTE: ACCOUNT REVENUE 135-47000-000 EXPENSES WATER 135-50010-010 135-60332-010 WASTEWATER 135-55081-020 135-60010-020 135-65030-020 135-65040-020 BOARD OF DIRECTORS ADMINISTRATION 135-55030-030 135-60070-030 135-60079-030 135-65095-030 Non -Departmental REPORT 135 - MUD 1 O&M February 2020 33.2% 51.5% Explanation provided for all accounts with a Year -To -Date percentage (YTD%) less than the R Expense Variance. The Revenue and Expense Variance is calculated on a straight-line method and plus 10% for expenses. Only accounts with current month activity will be listed DESCRIPTION TOTAL CURRENT YTD YTD % BUDGET MONTH TOTAL AMENDED March 16, 2020 Regular Meeting Agenda Packet evenue Variance and greater than or equal to the (Financials Month x 8.3%), less 8.3% for revenues DATE OF COMMENT VARIANCE EXPLANATION Water $6,486,623 $282,378 $1,805,515 27.83% 01/2020 Water Sales Overtime Interfund Transfer Out -Rev I&S Maintenance & Repairs Collections Communications/Mobiles Chemicals Safety Equipment Software & Support Dues & Memberships Public Education Maintenance Supplies $17,000 $1,214 $8,862 52.13% 01/2020 Overtime $527,381 $116,632 $308,407 $10,000 $5,000 $20,000 $1,200 $134,681 $6,000 $6,000 $4,000 $2,299 $409 $2,857 $23 58.48% 02/2020 I&S Interest Payment- 2019 Bond $17,678 176.78% 01/2020 $2,679 53.59% 01/2020 $12,725 63.62% 11/2019 $1,112 92.64% 02/2020 $1,568 $126,843 94.18% 01/2020 $119 $4,286 71.43% 01/2020 $3,333 $3,810 63.49% 02/2020 $302 $2,699 67.47% 01/2020 146 of 157 LS Repairs New Tablet and Service Chemicals Safety Equpiment Annual Contract STW & OpenGov Annual Dues MUD Boundary Update Office Supplies AMENDED March 16, 2020 Regular Meeting Agenda Packet Trophy Club Municipal Utility District No. 1 General Manager's Report March 16, 2020 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. r� I 1 � 1111�I1Y�I��nm�uuu� � minafro 4I High Service Pump Station Upgrade — The pump on the VFD would not turn on startup. The pump had to be pulled and set back to factory to be repaired. We do not have another startup date at this time. 147 of 157 1 AMENDED March 16, 2020 Regular Meeting Agenda Packet Monthly Water Operations Report Water Billed FY October November December January February March April May June July August September Total Year 2010 39,794 39,713 29,547 30,305 25,328 23,279 41,646 53,439 102,921 89,760 128,687 82,331 686,750 2011 70,502 50,909 44,365 35,983 27,845 55,972 69,165 61,467 99,326 117,707 170,464 123,692 927,397 2012 85,869 53,571 40,815 30,616 31,665 35,263 47,194 84,905 114,104 137,174 144,573 108,622 914,371 2013 85,488 75,251 48,527 39,601 34,450 43,137 56,947 76,542 85,312 110,072 130,945 114,497 900,769 2014 82,660 48,813 34,482 39,767 37,085 54,794 66,337 84,384 99,240 92,913 113,135 110,873 864,483 2015 90,994 58,986 49,607 36,162 38,776 30,566 46,543 39,576 60,731 100,622 139,441 123,886 815,890 2016 108,951 41,936 39,028 39,622 44,551 49,498 55,181 50,827 65,390 115,687 119,611 98,945 829,227 2017 74,785 68,638 38,580 33,028 38,380 60,841 56,683 86,794 98,864 95,355 104,303 99,541 855,792 2018 83,228 69,099 48,144 34,592 40,658 43,411 60,079 89,802 118,899 126,588 125,531 73,735 913,766 2019 47,193 41,933 36,244 34,604 33,740 40,421 55,970 42,773 70,747 96,174 131,472 114,784 746,055 2020 102,150 40,988 43,946 36,418 31,000 140,000 120,000 100,000 80,000 60,000 40,000 20,000 WATER BILLED IN THOUSANDS OF GALLONS 254,502 All 0 October November December January February March April Mr June July August September - 2016 - 2017 - 2018 2019 - 2020 Water Pumped FY October November December January February March April May June July August September Total Year 2010 40,803 41,600 32,700 31,400 30,145 27,240 43,400 62,646 113,049 94,950 131,650 76,159 725,742 2011 70,502 50,993 44,220 33,789 36,053 54,775 71,306 63,500 116,350 152,002 169,621 117,190 980,301 2012 83,750 54,245 41,650 34,740 31,581 46,519 62,649 100,402 110,324 153,813 139,005 123,045 981,723 2013 85,966 77,758 55,110 39,283 37,867 56,743 60,969 87,168 96,602 119,414 145,988 120,342 983,210 2014 81,909 51,769 39,769 48,758 42,395 61,100 71,283 96,481 95,206 110,173 123,369 115,607 937,819 2015 106,251 67,825 58,659 45,691 39,675 35,752 56,704 48,637 72,934 117,302 143,413 142,394 935,237 2016 106,731 52,616 43,708 46,945 50,721 55,178 60,434 55,562 68,138 112,533 128,963 104,664 886,193 2017 82,677 77,937 43,792 43,207 43,024 69,549 65,723 94,452 103,867 101,184 114,872 109,769 950,053 2018 91,439 78,282 55,745 40,796 40,750 51,711 67,217 97,980 124,109 155,354 144,015 85,946 1,033,344 2019 60,576 53,119 45,651 45,552 39,014 43,048 61,238 48,787 79,167 102,887 144,299 130,752 854,090 2020 112,971 48,627 49,384 40,726 35,749 287,457 180,000 160,000 140,000 120,000 100,000 80,000 60,000 40,000 20,000 0 WATER PUMPED IN THOUSANDS OF GALLONS October November December January February March April May June July August September - 2016 - 2017 - 2018 2019 - 2020 Active Connections FY October November December January February March April May June July August September 2014 Total 4139 4157 4173 4206 4209 4219 4240 4268 4280 4308 4333 4339 2015 Total 4353 4363 4377 4404 4413 4429 4443 4459 4478 4486 4498 4517 2016 Total 4531 4538 4556 4568 4593 4604 4607 4616 4622 4627 4632 4636 2017 Total 4644 4647 4661 4657 4663 4666 4670 4676 4685 4690 4696 4700 2017 MUD 3208 3210 3220 3216 3221 3224 3228 3234 3242 3247 3252 3256 2017 PID 1436 1437 1441 1441 1442 1442 1442 1442 1443 1443 1444 1444 2018 Total 4701 4706 4712 4716 4720 4724 4724 4728 4732 4735 4736 4738 2018 MUD 3257 3262 3268 3272 3276 3280 3280 3284 3288 3291 3292 3294 2018 PID 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 2019 Total 4741 4743 4745 4753 4753 4758 4761 4762 4768 4770 4773 4782 2019 MUD 3297 3299 3301 3309 3309 3314 3317 3318 3324 3326 3329 3338 2019 PID 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 148 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet Febuary 2020 Results Ammonia -N CBOD5 TSS Date % Removal % Removal % Removal Influent Effluent Influent Effluent Influent Effluent 3 -Feb 54.2 0.20 99.6% 245 2.0 99.2% 362 1.0 99.7% 6 -Feb 49.5 0.20 99.6% 201 2.0 99.0% 211 1.0 99.5% 10 -Feb 42.2 0.20 99.5% 234 2.0 99.1% 177 1.0 99.4% 12 -Feb 26.0 0.20 99.2% 207 2.0 99.0% 160 1.0 99.4% 17 -Feb 57.8 0.20 99.7% 224 2.0 99.1% 170 1.0 99.4% 20 -Feb 33.5 0.20 99.4% 266 2.0 99.2% 149 1.0 99.3% 24 -Feb 47.2 0.20 99.6% 189 2.0 98.9% 206 1.0 99.5% 26 -Feb 42.2 0.20 99.5% 240 2.0 99.2% 237 1.0 99.6% 1 Report Ammonia -NI CBOD5 TSS 0.20 1 99.5% 2.0 1 99.1% 1.0 1 99.5% 149 of 157 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 AMENDED March 16, 2020 Regular Meeting Agenda Packet Ammonia Nitrogen 0.23 Permit Limit 3 (Jan - March) 0.523 0.2 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.00 2.0 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 150 of 157 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 AMENDED March 16, 2020 Regular Meeting Agenda Packet Total Suspended Solids (TSS) Permit Limit 12 1.0 1.0 - - 1.0 1.0 - - 1.0 1.0 - - 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 Permit Limit 24 5.1 5.10 4.9 6.0 5.34 5.00 111111 Dec -19 Jan -20 Feb -20 Mar -20 Apr -20 May -20 Jun -20 Jul -20 Max mg/L = 5.8 Average = 4.6 151 of 157 Aug -20 Sep -20 Oct -20 Nov -20 Dec -20 T55 11 T55 Ave -Permit Limit N -N N -N Aver -Permit Limit 10 9 8 7 6 5 4 3 2 1 0 10.0 9.0 8.0 7.0 6.0 5.0 4.0 3.0 2.0 1.0 0.0 AMENDED March 16, 2020 Regular Meeting Agenda Packet E. Coli Permit Limit 126 1.0 1.0 1.0 1.0 MI 1.0 1.0 MI MI Dec -19 Jan -20 Feb -20 Mar -20 Apr -20 May -20 Jun -20 Jul -20 Aug -20 Max mg/L = 1.0 Average mg/L = 1.0 Potential for Hydrogen (pH) Sep -20 Oct -20 Nov -20 Dec -20 Permit Limit High 9 7.77 7.41 7.67 7.72 7.48 111 3 iI1 Permit Limit Low 6 0.00 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 152 of 157 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 AMENDED March 16, 2020 Regular Meeting Agenda Packet Dissolved Oxygen (DO) Permit Limit Max 9 4 0.5 a v 8.3 iPermit Limit Min 6 ! ill 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 153 of 157 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 Connections ebills Bills Mailed Bank Draft Credit Card Draft Online Payments Late Notices Disconnects Connections AMENDED March 16, 2020 Regular Meeting Agenda Packet Trophy Club MUD #1 Utility Billing Report Fiscal Year 2020 October November December January February March April May June July August September 938 941 944 951 963 3841 3845 3860 3835 3817 646 650 652 654 649 1193 1185 1193 1198 1168 1145 1192 1,184 1,208 1,187 378 453 339 462 452 21 41 42 27 38 M 3351 3352 3353 3353 3363 P 1444 1444 1444 1444 1444 Fiscal Year 2019 October November December January February March April May June July August September 870 867 868 883 885 890 903 904 932 932 932 936 3921 3921 3927 3903 3856 3859 3866 3859 3878 3875 3871 3859 650 650 660 664 661 669 666 666 664 656 656 653 1077 1109 1103 1114 1128 1151 1152 1152 1168 1161 1173 1179 1157 1130 1,124 1,149 1,111 1,129 1,100 1,162 1,098 1132 1145 1172 402 432 439 387 431 421 342 399 346 330 392 391 29 22 33 28 27 25 36 14 25 13 25 29 M 3297 3299 3301 3309 3309 3314 3317 3318 3324 3326 3329 3338 P 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 154 of 157 MUD Permits Month: February 2020 Plumbing Sewer Date of Customer Deposit Due to FW Water 135- Inspections 135- Inspections 135 - Permit Permit No. 135-25030 20500 Oversize Meter 135-49075 47035 47045 2/13/2020 2020-17 $ 75.00 $ 335.60 $ 257.00 $ 150.00 $ 50.00 2/25/2020 2020-18 $ 75.00 $ 4,596.00 $ 353.00 $ 150.00 $ 50.00 2/25/2020 2020-19 $ 75.00 $ 4,596.00 $ 353.00 $ 150.00 $ 50.00 2/25/2020 2020-20 $ 75.00 $ 4,596.00 $ 353.00 $ 150.00 $ 50.00 2/25/2020 2020-21 $ 75.00 $ 4,596.00 $ 353.00 $ 150.00 $ 50.00 2/25/2020 2020-22 $ 75.00 $ 4,596.00 $ 353.00 $ 150.00 $ 50.00 2/25/2020 2020-23 $ 75.00 $ 4,596.00 $ 353.00 $ 150.00 $ 50.00 2/25/2020 2020-24 $ 75.00 $ 4,596.00 $ 353.00 $ 150.00 $ 50.00 Total $ 600.00 $ 32,507.60 $ 2,728.00 $ 155 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet Fire Line 135-49900 1,200.00 $ 400.00 $ Misc Income 135-49900 Total $ 867.60 $ 5,224.00 $ 5,224.00 $ 5,224.00 $ 5,224.00 $ 5,224.00 $ 5,224.00 $ 5,224.00 $ 37,435.60 CASH STATUS AS OF FEBRUARY 2020 135-10250 TexPool 0 & M (XXXXX0002)-General Fund Operating *** 135-10300 Prosperity Bank (XXX8701) General Fund Operating 135-10305 Prosperity Bank Reserve -Savings Acct (XXXXX7724) 135-11100 Petty Cash Administration 135-11150 Petty Cash Utility Billing 137-10250 TexPool 0 & M (XXXXX0002) GASB Replacement 517-10250 TexPool Construction Tax (X)XXX011) WWTP Improvements 517-10300 Prosperity Bank Construction WWTP Improvements 519-10250 Texpool Revenue Bond Construction (XXXXX015) SWIFT 519-11155 Cash -Bond Escrow Bank of Texas (SWIFT) 520-10250 Texpool Revenue Bond Water & Waste Water Systems 2019 (XXXXX018) 520-11155 Cash -Bond Escrow Bank of Texas (Water & Waste Water Systems) 528-10250 TexPool Revenue Bond Reserve (XXXXX014) WWTP Improvements 533-10250 TexPool Tax I & S (XXXXX0003) 533-10300 Prosperity Bank (XXX8701) Tax I&S 534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements 535-10250 Texpool Revenue I & S (XXXXX017) SWIFT 536-10250 TexPool Revenue I & S (XXXXX020) Water & Waste Water Systems Amount available in cash (MUD Accounts) Amount available for spending (MUD Accounts) *02/29/2020 Customer Water Deposits $318,975 Fire Department Cash 122-10250 TexPool 0 & M (XXXXX0002)-Fire Operating Cash 122-10300 Prosperity Bank (XXX8701) Fire Operating Amount available in cash (Fire Department Accounts) Amount available for spending (Fire Department Accounts) Total General Fund 135 Available for Spending General Fund 135 Fund Balances Nonspendable Fund Balance (Prepaids) Assigned Fund Balance (FY2019 Capital Projects plus prior year carry forward) Unassigned Fund Balance Current Year Revenue/Expenses Total Nonspendable, Assigned & Committed Fund Balances - General Fund 135 156 of 157 AMENDED March 16, 2020 Regular Meeting Agenda Packet Restricted - Unable to be spent $o $318,975 $1,601,459 $0 $0 $919,266 $541,004 $0 $0 $784,091 $552,653 $3,888,180 $860,996 $905,362 $0 $193,249 $100,337 $23,261 $10,688,834 so $0 Unrestricted - Available for spending $3,868,049 $2,259,776 $0 $150 $450 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $6,128,425 1 $6,128,425 $6,128,425 $1,057,493 $0 $0 I $1,057,4931 $1,057,493 $1,057,493 Total in Accounts (Restricted & Unrestricted) $3,868,049 $2,578,751 $1,601,459 $150 $450 $919,266 $541,004 $0 $0 $784,091 $552,653 $3,888,180 $860,996 $905,362 $0 $193,249 $100,337 $23,261 $16,817,259 General Fund 135 Available 2,259,776 Prosperity General Fund 3,868,049 Texpool General Fund 600 Petty Cash 6,128,425 3,486 2,072,098 6,325,800 (153,648) $8,247,736 $1,057,493 $0 $1,057,493 TC Meeting Spaces April 2020 14 15 16 17 18 AMENDED March 16, 2020 Regular Meeting Agenda Packet, Modifier Sun Mon Tue Wed Thu Fri Mar 29, 2020 5 12 19 26 11am Early Voting 30 6 13 20 MMEEMIZIED 6:30pm ('.-) Board of Direct 31 7 14 Apr 1 8 15 9 16 3 10 17 21 22 23 24 8am May 2, 2020 General Election Early Voting 27 28 29 30 May 1 7am Early Voting 157 of 157 Printed on: 03/04/20201:22pm Sat 11 18 25 7am Early voting Election Day Powered by _ teamup