Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2019-0819 August 19 2019 Regular Meeting Agenda Packet
TROPHY CLUB ` MUNICIPAL J UTILITY DISTRICT No. 1 BOARD OF DIRECTORS REGULAR MEETING August 19, 2019 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 100 MUNICIPAL DRIVE TROPHY CLUB, TEXAS 76262 August 19, 2019 6:30 P.M. REGULAR MEETING AGENDA PACKET CALL TO ORDER AND ANNOUNCE A QUORUM Svore Municipal Boardroom CITIZEN COMMENTS This is an opportunity for citizens to address the Board on any matter whether or not it is posted on the agenda. The Board is not permitted to take action on or discuss any comments made to the Board at this time concerning an item not listed on the agenda. The Board will hear comments on specific agenda items prior to the Board addressing those items. You may speak up to four (4) minutes or the time limit determined by the President or presiding officer. To speak during this item, you must complete the Speaker's form that includes the topic(s) of your statement. Citizen Comments should be limited to matters over which the Board has authority. CONSENT AGENDA All matters listed as Consent Agenda are considered to be routine by the Board of Directors and will be enacted by one motion. There will not be a separate discussion of these items. If discussion is desired, that item will be removed from the consent agenda and will be considered separately. 1. Consider and take appropriate action to approve the Consent Agenda. a. July 2019 Check Register b. July 22, 2019 Regular Meeting Minutes c. July 29, 2019 Joint Meeting Minutes attachments: July 2019 Check Register July 22, 2019 Regular Meeting Minutes July 29, 2019 Joint Meeting Minutes REGULAR SESSION 2. Consider and take appropriate action to award the bid and approve Contract No. 2019081901 for Municipal Sludge Hauling services. 3. Consider and take appropriate action regarding Fiscal Year 2020 Budget Matters: a. Report from Rate Committee b. Consider and take appropriate action regarding rate assumptions and projections for FY2020 Budget. (Staff/NewGen) c. Discussion regarding the Draft Fiscal Year 2020 Budget. 1 of 127 August 19, 2019 Regular Meeting Agenda Packet 4. Consider and take appropriate action regarding tax rates for 2019 tax year: a. Approve proposed tax rate for 2019 tax year; and b. Schedule date and authorize publication of notice for hearing regarding adoption of final tax rates for 2019 tax year. 5. Consider and take appropriate action regarding the July 2019 Combined Financials and Variance Report. a. Combined Financials b. Combined Variance attachments: July Combined Financials July Combined Variance 6. Consider and take appropriate action to approve Open House Event at the Wastewater Treatment Facility on September 7, 2019 from 9:00 a.m. — 11:00 a.m. attachment: Staff Report REPORTS & UPDATES 7. Receive report from General Manager Hiring Committee. (Castonguay/Flynn) 8. General Manager Monthly Reports and Update: a. Regulatory Update b. Capital Improvement Projects • Interconnect Water Transmission Line Phase 2 • Wastewater Treatment Plant Upgrade Project • High Service Pump c. System Repairs d. Fire Department Summary e. Water System Operations f. Wastewater System Operations g. Finance Update • Utility Billing Report • Permits Collected • Water Budget vs. Actual • Cash Report attachments: General Manager Report Water Operations Report Wastewater Operations Report Utility Billing Report Permits Collected Water Budget vs. Actual Cash Report 2 of 127 August 19, 2019 Regular Meeting Agenda Packet EXECUTIVE SESSION 9. Pursuant to Section 551.071 of the Texas Open Meetings Act, the Board may consult with its attorney in Executive Session on a matter in which the duty of the attorney to the Governmental Body under the Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflicts with the Open Meetings Act or to seek advice of counsel on legal matters involving pending or contemplated litigation or settlement offers: a. Contractor breach, performance and payment issues related to District's contract with Webber- Cadagua Partners for construction of the Wastewater Treatment Plant Improvements; and b. Trophy Club Municipal Utility District No. 1 v. Acadia Services, LLC, In the District Court of Tarrant County, 141st Judicial District (Cause No. 141-299351-18). 10. Pursuant to Section 551.072 of the Texas Open Meetings Act, the Board may deliberate the purchase, exchange, lease, or value of real property if deliberation in an open meeting would have a detrimental effect on the position of the governmental body in negotiations with a third person: a. Sale or Exchange of District real property located at 100 Municipal Drive and 1501 Junction Way. b. Purchase of Easements required for construction and operation of Water Transmission Line Improvements from District Pump Station to Elevated Water Tank located on T.W. King Road REGULAR SESSION 11. Consider and take appropriate action on matters deliberated in Executive Session: 12. Items for future agendas: 13. Set future Meeting dates: a. Regular Board Meeting — Monday, September 16, 2019 at 6:30 p.m. attachment: 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 THE STATE OF TEXAS § COUNTIES OF DENTON AND TARRANT § THIS NOTICE CERTIFIES THAT BY 6:30 P.M. ON FRIDAY, AUGUST 16, 2019, THE AGENDA OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1, BOARD OF DIRECTORS REGULAR MEETING TO BE HELD ON MONDAY, 3 of 127 August 19, 2019 Regular Meeting Agenda Packet MONDAY, AUGUST 19, 2019 AT 6:30 P.M., WAS POSTED ON THE FRONT WINDOW OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 ADMINISTRATION BUILDING, 100 MUNICIPAL DRIVE, TROPHY CLUB, TEXAS, WHICH ISA PLACE CONVENIENT TO THE PUBLIC AND WITHIN THE BOUNDARIES OF THE DISTRICT AND NOTIFICATION WAS POSTED TO THE DISTRICT WEBSITE, IN ACCORDANCE WITH SECTION 49.063 OF THE WATER CODE AND SECTION 551.054 OF THE TEXAS GOVERNMENT CODE, AS AMENDED. LAURIE SLAGHT, DISTRICT SECRETARY 4 of 127 apackant2 sk olczyk Begin Date: 07/01/2019 End Date: 07/31/2019 Fran Amt: venoor ve oor Name Maher 2222 AFLAC Tbtals for Check: 5444 998 AILEY, MARSHA Totals for Check: 5445 998 AQUADAID POOL TEEMS Tbtals for Check: 5446 998 ARCHER, PATRICIA Totals for Check: 5447 998 ASHTON %CMS BONES Totals for Check: 5448 998 SABER, LYN Totals for Check: 5449 998 BEALrHAb P, KIM Totals for Check: 5450 998 BELSC3 NE32, ANDES4 Totals for Check: 5451 998 BRANDYBE38 , MELISSA Totals for Check: 5452 998 PRM SOLADA LLC Totals for Check: 5453 998 BRE SOLADA LLC Tbtals for Check: 5454 998 BRE NADA LLC Tbtals for Check: 5455 998 BRE mum LLC Totals for Check: 5456 998 BRE SOLANA LLC Totals for Check: 5457 998 BRE SOLADA LLC Tbtals for Check: 5458 998 BRE SOLADA LLC Totals for Check: 5459 August 1 9 2019 Regular Meeting Agenda Psckgeet Trophy Club MOD Nb.1 08/1271909:541 AP Checks For Date/Amount Range .00 To Amt: 99,999,999.99 invoice Number invoice Inv Dept Account Description Date Stat No Number PR00671 996 06/28/19 P 135-21312-000-000 Aflac 00017050041103A 06/30/19 P 135-20050-000-000 A/P Vendors U0511000105523A 06/30/19 P 135-20050-000-000 A/P Vendors 00023150021202A 06/30/19 P 135-20050-000-000 A/P Vendors U0036010651100A 06/30/19 P 135-20050-000-000 A/P Verbrs 00010070485104A 06/30/19 P 135-20050-000-000 A/P vendors 00050090787102A 06/30/19 P 135-20050-000-000 A/P Vendors U9022040045907A 06/30/19 P 135-20050-000-000 A/P Ve dors 09048060016901A 06/30/19 P 135-20050-000-000 A/P Vendors 00211600010101A 06/30/19 P 135-20050-000-000 A/P Vendors 00211600014101A 06/30/19 P 135-20050-000-000 A/P Vendors 00211600016101A 06/30/19 P 135-20050-000-000 A/P Ve n30ss 00211600018101A 06/30/19 P 135-20050-000-000 A/P Vendors U0211600019101A 06/30/19 P 135-20050-000-000 A/P Vendors 130211600024101A 06/30/19 P 135-20050-000-000 A/P Vendors 130211600025101A 06/30/19 P 135-20050-000-000 A/P Vendors f 197 Lane 1tHn (meat LneCK Value Nta,be . Date 151.13 5444 07/01/19 151.13 06.91 5445 07/01/19 06.91 1,689.58 5446 07/01/19 1,689.58 29.22 5447 07/01/19 29.22 36.46 5448 07/01/19 36.46 07.60 5449 07/01/19 07.60 04.30 5450 07/01/19 04.30 06.92 5451 07/01/19 06.92 23.02 5452 07/01/19 23.02 193.73 5453 07/01/19 193.73 397.65 5454 07/01/19 397.65 163.56 5455 07/01/19 163.56 268.73 5456 07/01/19 268.73 587.25 5457 07/01/19 587.25 1,099.21 545B 07/01/19 1,099.21 6,394.93 5459 07/01/19 6,394.93 apackamt2 skrolczyk Begin Date: 07/01/2019 Bed Date: 07/31/2019 Fran Amt: Trophy club MOD No.1 AP Checks For Date/Amount Range .00 Tb Amt: 99,999,999.99 August 19, 2019 Regular Meeting Agenda Packet 08/12/19 09:54 Page 2 venoor venoor mane invoice Natter invoice Inv Dept Amt Description Lane item c 7neCx (Bleck Number Date Stat No Nun Lrs Value Nisrber Date 998 BRE SOLAfA LLC 00211600029101A 06/30/19 P 135-20050-000-000 A/P vendors 2,385.38 5460 07/01/19 Tbratn for Check: 5460 2,385.38 998 BRE soma LLC U0211600030101A 06/30/19 P 135-20050-000-000 A/P Vendors 472.36 5461 07/01/19 Tbtals for Check: 5461 472.36 998 BUNCE, NATAL= U0020620008210A 06/30/19 P 135-20050-000-000 A/P Vendors 26.63 5462 07/01/19 Tbtals for Check: 5462 26.63 2651 Carman Consulting LLC. 23 07/01/19 P 30 135-55070-030-000 Independent TAhn, 10,400.00 5463 07/01/19 2651 Carman Consulting LIC. 23 07/01/19 P 30 135-55070-030-000 Independent Tatum 31.61 5463 07/01/19 Tbtals for Check: 5463 10,431.61 998 CAMPBELL, SCOTT 00020590006203A 06/30/19 P 135-20050-000-000 A/P Venders 05.25 5464 07/01/19 Totals for Check: 5464 05.25 998 CANTERBURY HttLLLS HOA 00037000361100A 06/30/19 P 135-20050-000-000 A/P Vendors 47.42 5465 07/01/19 Tbtals for Check: 5465 47.42 998 CDR3000VA, MONICA U0050060550103A 06/30/19 P 135-20050-000-000 A/P Vendors 45.45 5466 07/01/19 ,Tbtals for Check: 5466 45.45 998 COZINE, TTSHA 00010110010104A 06/30/19 P 135-20050-000-000 A/P Vendors 20.11 5467 07/01/19 Tbtals for Check: 5467 20.11 998 GLOVER, STACEY H 170050160006106K 06/30/19 P 135-20050-000-000 A/P Vendors 29.54 5468 07/01/19 Totals for Check: 5468 29.54 998 JACKSON, NIKKI U0022080006205A 06/30/19 P 135-20050-000-000 A/P Vendors 42.47 5469 07/01/19 Totals for Check: 5469 42.47 3132 Legal Shield 9000671 996 06/28/19 P 135-21310-000-000 Legal Plan 17.44 5470 07/01/19 Totals for Check: 5470 17.44 998 LUN)V9LS, STEVEN 00020540011204A 06/30/19 P 135-20050-000-000 A/P Vendors 50.13 5471 07/01/19 Totals for Check: 5471 50.13 998 03.D TC CXI4ENID, LLC 00116000090100B 06/30/19 P 135-20050-000-000 A/P Vec)dors 1,636.46 5472 07/01/19 Totals for Check: 5472 1,636.46 998 OTD TC 0a4POUND, LLC U0116000095100A 06/30/19 P 135-20050-000-000 A/P Venthrs 445.39 5473 07/01/19 Totals for Check: 5473 445.39 998 PRIMER, MICHELLE U0020450037205A 06/30/19 P 135-20050-000-000 A/P Vendors 16.60 5474 07/01/19 Totals for Check: 5474 16.60 998 ROBERTS, ANDA U0042330002202A 06/30/19 P 135-20050-000-000 A/P Vendors 10.53 5475 07/01/19 Fnf177 apackamh2 skrolczyk Begin Date: 07/01/2019 End Tate: 07/31/2019 F.n.m Amt: vendor vendor Nate Maher Totals for Check: 5475 998 SANDERS, CHARLEY Totals far Check: 5476 998 SANDERS, KEMB 8LY ANN Totals for Check: 5477 998 SfELLIS, CARIA Totals for Check: 5478 998 SIZER, DANIEL 8 Totals for Check: 5479 998 1 RRES, MAT1HEW Totals for Check: 5480 998 TUCSOR, ROBERT Tbtals for Check: 5481 998 TURNER, KIMBERLY Totals for Check: 5482 998 UPTh RE, BRADLEY Totals for Check: 5483 998 WRIDE, FELLY Totals for Check: 5484 1030 CITY OF FORT WORTH Trophy Clvb MUD No.l 08/lzJ�iSst 109 5019 Regular Meeting Agenda Pdcgkeet 3 AP Checks For Date/Amount Range .00 To Pmt: 99,999,999.99 Invoice Narver Invoice Inv Dept Acc mt Description lane item cslecx CnecK Date Stat No Mather Value NUarber Date 10.53 U0050030217101A 06/30/19 P 135-20050-000-000 A/P Verr3ors 29.90 5476 07/01/19 29.90 U0050360009106A 06/30/19 P 135-20050-000-000 A/P Vendors 20.25 5477 07/01/19 20.25 09021120007902A 06/30/19 P 135-20050-000-000 A/P Vendors 92.48 5478 07/01/19 92.48 U0010020091102A 06/30/19 P 135-20050-000-000 A/P Vendors 03.78 5479 07/01/19 03.78 U9048020003901A 06/30/19 P 135-20050-000-000 A/P Vendors 16.28 5480 07/01/19 16.28 U0010050392107A 06/30/19 P 135-20050-000-000 A/P yes s 04.39 5481 07/01/19 04.39 U0030121591201A 06/30/19 P 135-20050-000-000 A/P Vendors 20.88 5482 07/01/19 20.88 U0010190004103A 06/30/19 P 135-20050-000-000 A/P Veniors 96.22 5483 07/01/19 96.22 U0042200500203A 06/30/19 P 135-20050-000-000 A/P Vendb s 27.38 5484 07/01/19 27.38 063019IMPPCTFEE 06/30/19 P 135-20500-000-000 Fort North Water -fact Fees 7,659.32 5485 07/02/19 Totals for Check: 5485 7,659.32 1005 ATLAS UTILITY SUPPLY CO. 96268 05/31/19 P 10 135-65053-010-000 Meter Change Out Program 43,092.00 5486 07/17/19 1005 ATLAS UTILITY SUPPLY CO. 9711 06/30/19 P 10 135-65050-010-000 Meter Expense 2,974.00 5486 07/17/19 1005 ATLAS UTILITY SUPPLY CO. 9712 06/30/19 P 10 135-65050-010-000 Meter Expense 6,338.50 5486 07/17/19 Totals for Check: 5486 52,404.50 1030 CITY OF FORT WORTH Totals for Check: 5487 2655 Core & Main LP Totals for Check: 5488 3193 COMPUPAY, I. 2btals for Check: 5489 3184 DATAPROSE LLC 06/25/2019 06/25/19 P 10 135-60150-010-000 hbolesale water 139,696.39 5487 07/17/19 139,696.39 1C/44093 06/25/19 P 10 135-55080-010-000 Maintenance & Repairs 197.00 5488 07/17/19 197.00 9R00672 996 07/12/19 P 135-21313-000-000 Cafe 125 -Medical Rei.nb 586.80 5489 07/17/19 586.80 DP1902140 06/30/19 P 30 135-60035-030-000 Postage 1,602.26 5490 07/17/19 7 qf 127 apackarnt2 skrolczyk Begin Date: 07/01/2019 End Date: 07/31/2019 vendor vendor Name Number 3184 DATAPI8)SE LLC Totals far Check: 5490 1737 DPC INDUSTRIES, INC Totals for Check: 5491 Fran Amt: Invoice Nmber invoice Inv Dept Acmwnt Date Stat No Number 3P1902140 06/30/19 P 30 135-55205-030-000 767002843-19 06/18/19 P 10 135-65030-010-000 2717 Eaviro re ntal Irprovene nts Inc 43204 -IN 2717 Environmental Improvements Inc 44344 -IN 2717 Environmental Improvements Inc 44345 -IN Totals far Check: 5492 3124 IRS Tax Payment 3124 IRS Tax Payment 3124 IRS Tax Payment Totals for Check: 5493 2764 JAMIE LYNN MCNAHal Totals for Check: 5494 2943 JPMCP�AN CHASE BANK NA Totals for Check: 5495 3194 MORALEEN eicintcrxu.scA Totals for check: 5496 2643 Mclean & Howard, L.L.P. 2643 W.Lean & Howard, L.L.P. Rbtals for Check: 5497 2401 NDN REX;MCY ORP, INC Totals for Check: 5498 2983 NTTA Tbtals for Check: 5499 1056 OFFICE DEPOT, INC 1056 OFFICE DEPOT, IS)C Totals for Check: 5500 1466 POLE, INC Totals for Check: 5501 3176 RET -MAR r.c.ev:aixcmn�iic.aa Totals for Check: 5502 2698 Ritz Safety, LIC 2698 Ritz Safety, TIC PR00672 PR00672 PR00672 06/01/19 06/30/19 06/30/19 996 07/12/19 996 07/12/19 996 07/12/19 P 20 135-69005-020-000 P 20 135-55080-020-000 P 20 135-69005-020-000 P 135-21302-000-000 P 135-21303-000-000 P 135-21304-000-000 PR00672 996 07/12/19 P 135-21410-000-000 06262019 06/26/19 P 135-20060-000-000 6762 06/14/19 P 10 135-55080-010-000 34333 06/30/19 P 39 135-55045-039-000 34334 06/30/19 P 39 135-55045-039-000 8391 06/13/19 P 20 135-55080-020-000 791809252-3UNE 06/23/19 P 30 135-60100-030-000 333068154001 06/24/19 P 30 135-65085-030-000 333515680001 06/25/19 P 30 135-65095-030-000 1367528 07/05/19 P 20 135-65030-020-000 2 06/18/19 P 10 135-69005-010-000 5776946 06/04/19 P 20 135-65040-020-000 5776538 06/04/19 P 20 135-65040-020-000 Trophy Club MUD No.1 AP Checks For Date/Annunt Range .00 To Amt: 99,999,999.99 17escription Utility Billing Contract Chemicals Capital Outlays Maintenance & Repairs Capital Outlays FWH Taxes Social Security Taxes Medicare Taxes Child Support Procurement Clearing Maintanam & Repairs lojal r"3 -Ai bra ntnnaance & Repairs Travel & per diem Office Supplies Maintenance Supplies Chemicals Capital Outlays Safety Equipment Safety Sguipmnt nf177 August 19, 2019 Regular Meeting Agenda Packet 08/12/19 09:54 Page 4 Lune item Check Check Value Number Date 575.26 5490 07/17/19 2,177.52 670.09 5491 07/17/19 670.09 3,251.95 380.00 17,494.00 21,125.95 3,686.90 4,846.88 1,133.56 9,667.34 5492 07/17/19 5492 07/17/19 5492 07/17/19 5493 07/17/19 5493 07/17/19 5493 07/17/19 147.69 5494 07/17/19 6,438.97 5495 07/17/19 89.33 5496 07/17/19 147.69 6,438.97 89.33 6,060.00 5497 07/17/19 1,050.00 5497 07/17/19 7,110.00 711.47 5498 07/17/19 711.47 09.15 5499 07/17/19 09.15 463.82 5500 07/17/19 276.44 5500 07/17/19 740.26 2,856.60 5501 07/17/19 2,856.60 66,600.00 5502 07/17/19 66,600.00 123.96 5503 07/17/19 31.62 5503 07/17/19 apackamt2 skrolczyk Trophy club ASID No.1 AP Checks For pate/Anount Range Begin Date: 07/01/2019 End Date: 07/31/2019 Fran Amt: .00 'Ib Amt: 99,999,999.99 08/ jst Vg.Z 19 Regular Meeting Agenda P Cet 5 vendor vendor Name invoice Number 1nvoace .Lnv Dept Account DeSQ1ption Line Item U eCK unci Nmber Date Stat No Number Value Number Date Tbtals for Check: 5503 155.58 2440 TARRANT CTY PUBLIC HEALTH LAB 32179 06/30/19 P 10 135-55135-010-001 Lab Analysis for PID 80.00 5504 07/17/19 2440 TAIRRANT CTY PUBLIC HEALTH LAB 32180 06/30/19 P 10 135-55135-010-000 Lab Analysis 295.00 5504 07/17/19 Totals for Check: 5504 375.00 3113 TCDRS PR00672 996 07/12/19 P 135-21317-000-000 TCDRS 6,600.14 5505 07/17/19 Tbtals for Check: 5505 6,600.14 2696 Texas Excavation Safety System 19-13398 06/30/19 P 30 135-60040-030-000 Service Charges & Fees 231.80 5506 07/17/19 Totals for Check: 5506 231.80 999 The Kno11 H.O.A. 06/30/2019 06/30/19 P 135-20500-000-000 Pbrt Worth Water -1 pact Fees 551.68 5507 07/17/19 Totals for Check: 5507 551.68 1001 TUMOR TROPHY CLUB JUNE REFUSE 06/30/19 P 135-25040-000-000 Ttra1-Storm Drainage 35,444.62 5508 07/17/19 1001 TOWN OF TROPHY CLUB JUNE: REFUSE 06/30/19 P 135-25000-000-000 Refuse 64,903.78 5508 07/17/19 1001 TOWEL OF TROPHY CLUB .)UNE REFUSE 06/30/19 P 135-25010-000-000 Refuse Tax 5,346.30 5508 07/17/19 Totals for Check: 5508 105,694.70 1081 TRI COUNTY ELB1 IRTC 75862554 06/25/19 P 20 135-60020-020-000 Electricity 550.41 5509 07/17/19 Totals for Check: 5509 550.41 1000 TROPHY CLUB ASID (MATER BTTTq) 06/30/2019 06/30/19 P 30 135-60025-030-000 Water 107.71 5510 07/17/19 Totals for Check: 5510 107.71 3263 UV DOCTOR LAMPS LLC 12609 06/24/19 P 20 135-55080-020-000 MaintPnanrr & Repairs 362.86 5511 07/17/19 Totals for Check: 5511 362.86 3280 WATTS Rma.TSGN LLC 20556 07/02/19 P 10 135-60285-010-000 Lavin Eguipmaat & Maintenance 750.00 5512 07/17/19 3280 WATTS EL.LISON LLC 20556 07/02/19 P 20 135-60285-020-000 Lawn Reuixrent & Maintenance 590.00 5512 07/17/19 Totals for Check: 5512 1,340.00 1087 1'Kr1 K R CHALK SWINDLE 249283 06/30/19 P 39 135-55045-039-000 Legal 12,597.66 5513 07/17/19 Totals for Check: 5513 12,597.66 2683 Charter Communications 71672070619 07/06/19 P 30 135-55030-030-000 Software & Supyuct 899.00 5514 07/19/19 Totals for Check: 5514 899.00 2655 Cbre & Main LP X647965 07/03/19 P 10 135-55080-010-000 Maintenance & Repairs 3,432.48 5515 07/19/19 Totals for Check: 5515 3,432.48 3080 CP&Y/WESSSACE GROUP, INC. 'IC2&n600916-10 07/17/19 P 10 135-69005-010-000 Capital Outlays 1,059.72 5516 07/19/19 Totals for Check: 5516 1,059.72 2606 Fisery Solutions, LLC 91539542 07/11/19 P 30 135-60040-030-000 Service Charges & Fees 50.00 5517 07/19/19 Tbtals for Check: 5517 50.00 cf 127 aap ckamt2 slaolczyk Begin Date: 07/01/2019 End Date: 07/31/2019 ven cor vendor Name Number uu Amt: invoice Nnarber Invoice IIIV Dept ACCOST:It Date Stat No Nu,i,cc 3076 HD SUPPLY EAC31,ITffi MAIN/ LID 941620 3076 HD SUPPLY FAL' LITIES HALM' LTD 941779 Totals for Checks: 5518 2641 Huber Technology Inc 2641 Huber Technology Inc Tbtals for Check: 5519 2775 HtDDCN ENERGY SERVICES, LLC 2775 /8ID93N ENERGY SERVICES, LLC Totals for Check: 5520 1834 IDBDC DISTRIBUTION, INV Totals for Check: 5521 3167 KEYSTONE PARK SECRF1'ARTAT Tbtals far Check: 5522 1468 L.H. CHANEY MATERIALS, INC. Totals for Check: 5523 3216 Mi Networks 3216 M3 Networks Totals far Check: 5524 CD10018456 CD10018476 07/03/19 P 20 135-65045-020-000 07/03/19 P 20 135-65045-020-000 07/08/19 P 20 135-55080-020-000 07/10/19 P 20 135-55080-020-000 51907150003-20 07/15/19 P 10 135-60020-010-000 51907150003-20 07/15/19 P 20 135-60020-020-000 3050070475 155207 164453 5401 5364 3186 MEMBER'S BUILDING MAINTENAME TC1906It3 JD Totals for Check: 5525 2983 NITA Totals for Check: 5526 1056 OFFICE DEPOT, INC Tbtals for Check: 5527 3156 OR= LABORATORIES LLC 3156 O CZI t LABORATORIES LLC 3156 =ODOR LABCRATORIFS LLC 3156 C7>aroR LABORATORZES LLC 3156 OX OR LABORATORIES LLC 3156 OXIDOR LAB RNTCRIES LLC Totals far Check: 5528 3282 TTAA COMMERCIAL FINANCE E Torahs for Check: 5529 1001 TAW OF TROPHY CLUB Totals for Chedk: 5530 07/09/19 P 07/21/19 P 07/06/19 P 07/15/19 P 07/11/19 P 20 135-65045-020-000 30 135-60005-030-000 20 135-55125-020-000 30 135-55030-030-000 30 135-65055-030-000 06/30/19 P 30 135-55120-030-000 804638774 -JULY 07/05/19 P 30 135-60100-030-000 336095467001 07/01/19 P 30 135-65085-030-000 19070037 19070063 19070156 19070211 19070316 19070321 07/01/19 07/02/19 07/09/19 07/11/19 07/16/19 07/16/19 P 20 135-55135-020-000 P 20 135-55135-020-000 P 20 135-55135-020-000 P 20 135-55135-020-000 P 20 135-55135-020-000 P 20 135-55135-020-000 6345865 07/07/19 P 30 135-69170-030-000 070119 07/08/19 P 45 122-60337-045-000 Trophy Laub NCD No.1 AP (decks For Date/Aron nt Range .00 Tb Amt: 99,999,999.99 Description Lab Supplies Lab Supplies Maintenance & Repairs Maintenance & Repairs Electricity Electricity Lab Supplies Telephone Du pater Services Software & Support Hardware Cleaning Services Travel & per diem Office Supplies Lab Analysis Lab Analysis Lab Analysis Lab Analysis Lab Analysis Lab Analysis Dopier Lease Installments Transfer to Tbwn/Fire Beset Innf177 08/12/19 09:54 19,0 2019 Regular Meeting Agenda Packet 6 Line iter (neck cmecx Value Umber Date 68.69 5518 07/19/19 11.58 5518 07/19/19 80.27 5,820.99 5519 07/19/19 1,065.00 5519 07/19/19 6,885.99 10,458.80 5520 07/19/19 11,482.13 5520 07/19/19 21,940.93 1,703.47 5521 07/19/19 1,703.47 194.75 5522 07/19/19 194.75 845.00 5523 07/19/19 845.00 510.00 5524 07/19/19 528.98 5524 07/19/19 1,038.98 869.06 5525 07/19/19 869.06 13.89 5526 07/19/19 13.89 75.43 5527 07/19/19 75.43 317.40 5528 07/19/19 230.00 5528 07/19/19 317.40 5528 07/19/19 230.00 5528 07/19/19 317.40 5528 07/19/19 230.00 5528 07/19/19 1,642.20 165.00 5529 07/19/19 165.00 56,204.33 5530 07/19/19 56,204.33 apackart2 skrolczyk Begin Date: 07/01/2019 End Date: 07/31/2019 Vendor venckor Name Ntmber 1058 VERDUN WIRELESS 1058 VERID14 WIRELESS 1058 VERIZ,(PI WIRELESS Totals far Check: 5531 Fran Amt: invoice Number invoice lay Dept Account Date Stat No Number 9833119588 9833119588 9833119588 3045 3RD EYE SORVEELLANCE SYSTEMS 1122-2 Totals for Check: 5532 2635 Halff Associates, INC Totals for Check: 5533 3176 REY-MAR uaa anwu & Totals for Check: 5534 1832 1832 1832 1832 Totals FIRST FIIAiNZIAI, BANK FIRST FTNANCSAL BANK FIRST F1NAN< TAT• BANK FIRST FINANCIAL BANK for Check: 5535 2635 Halff Associates, 1NC Totals for Check: 5536 2222 AFLAC 2222 AFLAC Totals for Check: 5537 3197 BeLefitMall 3197 BeaefitMall 3197 Be iefitMi11 Totals for Check: 5538 3193 OXMPOPAY, INC. Totals for Check: 5539 2677 Digital Air Control, Inc Totals for Check: 5540 1737 DPC INDUSTRIES, INC Totals for Check: 5541 2718 DSHS Central Lab Nf2004 Totals for Check: 5542 3258 FRANCOTYP-POSTALIA, INC. Totals for Check: 5543 07/01/19 07/01/19 07/01/19 P 10 135-60010-010-000 P 20 135-60010-020-000 P 30 135-60010-030-000 07/10/19 P 30 135-69005-030-000 26316 07/19/19 P 10 520-69005-010-000 STRAIGHT CREEK 07/19/19 P 10 135-69005-010-000 91500005391-819 08/01/19 91500005391-819 08/01/19 91500007223-819 08/01/19 91500007223-819 08/01/19 P 10 135-69009-010-000 P 20 135-69009-020-000 P 20 135-69009-020-000 P 20 135-69008-020-000 26321 07/19/19 P 30 135-69005-030-000 PR00672 996 07/12/19 P PR00673 996 07/26/19 P 9043753 -IN 9043753 -IN 9043753 -IN PR00673 2049277 767003353-19 0610018 81104126658 07/15/19 P 07/15/19 P 07/15/19 P 996 07/26/19 P 07/10/19 P 07/15/19 P 07/02/19 P 07/15/19 P 135-21312-000-000 135-21312-000-000 10 135-50029-010-000 20 135-50029-020-000 30 135-50029-030-000 135-21313-000-000 30 135-60235-030-000 10 135-65030-010-000 10 135-55135-010-000 30 135-60035-030-000 iiophy club MOD No.1 AP Checks For Date/Am:1mM Range .00 To Amt: 99,999,999.99 Description ca ammicaticws/Mbbiles C mnmicatiays/Mobiles carr mications/Mrbiles Capital Outlays Capital Outlays Capital Outlays Short Tenn Debt -Interest Short Term Debt -Interest Short Tenn Debt -Interest Short 'Iti m Debt -Principal Capital Outlays Aflac Aflac Life Insurance & Other Life Insurance 4 Other Life Insurance & Other Cafe 125 -Medical Reinb Security Chemicals Lab Analysis Postage 11 of 197 OeAuglu0st 19 5019 Regular Meeting Agenda P c4gkeet/12T7 in»v 1teo Value 237.69 372.26 87.94 697.89 15,656.43 15,656.43 7,901.83 7,901.83 74,906.00 74,906.00 1,840.43 2,439.63 3,765.56 19,075.14 27,120.76 7,304.71 7,304.71 151.13 151.13 302.26 20.00 38.00 20.00 78.00 586.80 586.80 24.00 24.00 558.41 558.41 279.35 279.35 102.54 102.54 cY]eCK (-neck Number Date 5531 07/19/19 5531 07/19/19 5531 07/19/19 5532 07/19/19 5533 07/19/19 5534 07/19/19 5535 07/19/19 5535 07/19/19 5535 07/19/19 5535 07/19/19 5536 07/19/19 5537 07/29/19 5537 07/29/19 5538 07/29/19 5538 07/29/19 5538 07/29/19 5539 07/29/19 5540 07/29/19 5541 07/29/19 5542 07/29/19 5543 07/29/19 aacka,nt2 skrolczyk Begin Date: 07/01/2019 Hid Date: 07/31/2019 Venaor venaor Name Number 1372 HACH COMPANY Tbtals for Check: 5544 2676 2676 2676 2676 2676 2676 Humana Inc Humana Inc Humana Inc Humana Inc Humana Inc Humana Inc Totals for Check: 5545 1834 IDE CC DISTRIBUTION, INC 1834 MI= INC Totals for Check: 5546 3124 IRS Tax Payment 3124 IRS Tax Payment 3124 IRS Tax Payment Totals for Check: 5547 2764 JAMIE LYNN MCMAHON Tbtalr: for Check: 5548 iuu Amt: invoice Number Invoice Inv Dept Account Date Stat No Nun Trophy Club MOD NO.1 AP checks Por Date/Anrn nt Range .00 Tb Ant: 99,999,999.99 Description 11556887 07/19/19 P 10 135-65030-010-000 Chemicals 155516806 155516806 155516806 155516806 155516806 155516806 3048359788 3047014447 13200673 PR00673 PR00673 08/13/19 08/13/19 08/13/19 08/13/19 08/13/19 08/13/19 P 135-21308-000-000 P 135-21309-000-000 P 135-21311-000-000 P 10 135-50029-010-000 P 20 135-50029-020-000 P 30 135-50029-030-000 Dental Vision Voluntary Life Life Insurance & Other Life Insurance & Other Life Insurance & Other 06/04/19 P 20 135-55135-020-000 Lab Analysis 05/06/19 P 20 135-55135-020-000 Lab Analysis 996 07/26/19 996 07/26/19 996 07/26/19 P 135-21302-000-000 P 135-21303-000-000 P 135-21304-000-000 9900673 996 07/26/19 P 3278 KKtOCERA DOCUME 7T 90W1'ICN5 5581666537 totals far Cheek: 5549 1468 L.H. CHANEY MATERIALS, INC. 164529 1468 L.H. CHANES MATERIALS, INC. 164939 Totals for Check: 5550 3132 Legal Shield 3132 Tsx3a1 Shield Totals for Check: 5551 3115 M 'LIFE GROUP i9 EFTLS 3115 MEI I E GROUP BMW= 3115 MSILIFE GROUP mem= 3115 MEILIFE CSP BENEFITS Tbtals for Check: 5552 3156 OXIDOR L?BDRA53RIPS LSP 3156 OXIDOR IMORATtRaES LLC Totals for Check: 5553 135-21410-000-000 07/23/19 P 30 135-69170-030-000 07/13/19 P 20 135-55125-020-000 07/20/19 P 20 135-55125-020-000 135-21310-000-000 135-21310-000-000 9900672 996 07/12/19 P PR00673 996 07/26/19 P 8/15/2019 8/15/2019 8/15/2019 8/15/2019 19070560 19070521 2633 Sluder flrcrgecy Power Service 923 Totals for Check: 5554 08/15/19 08/15/19 08/15/19 08/15/19 P 135-21315-000-000 P 10 135-50029-010-000 P 20 135-50029-020-000 P 30 135-50029-030-000 07/24/19 P 20 135-55135-020-000 07/23/19 P 20 135-55135-020-000 FAH Taxes Social Security Taxes Medicare Taxes Child Support Copier Lease Installments Dumjster Services Duupster Services Legal Plan Legal Plan Short Tenn Disability Life Insurance & Other Life Insurance & Other Life Insurance & Other Lab Analysis Lab Analysis 07/23/19 P 20 135-55085-020-000 Generator Maint. and Repair 17 'f 177 August 19, 2019 Regular Meeting Agenda Packet 08/12[19 09:54 Page 8 Line Iter Cneca (-neck Value NutLea. Date 1,666.88 5544 07/29/19 1,666.88 1,220.34 5545 07/29/19 175.11 5545 07/29/19 189.51 5545 07/29/19 98.56 5545 07/29/19 184.80 5545 07/29/19 149.52 5545 07/29/19 2,017.84 319.49 5546 07/29/19 1,703.47 5546 07/29/19 2,022.96 3,731.49 5547 07/29/19 4,887.58 5547 07/29/19 1,143.12 5547 07/29/19 9,762.19 147.69 5548 07/29/19 147.69 145.33 5549 07/29/19 145.33 845.00 5550 07/29/19 884.29 5550 07/29/19 1,729.29 17.46 5551 07/29/19 17.44 5551 07/29/19 34.90 97.51 5552 07/29/19 91.11 5552 07/29/19 162.14 5552 07/29/19 142.90 5552 07/29/19 493.66 317.40 5553 07/29/19 230.00 5553 07/29/19 547.40 570.00 5554 07/29/19 570.00 apackamt2 skrolczyk Begin Date: 07/01/2019 End Date: 07/31/2019 Vet vendor Name Number 3113 TCDRS Totals for Check: 5555 1001 TOWN OF TROPHY CLUB Tbtala for Check: 5556 Finn Amt: Invoice Ntmmber Invoice Inv Dept ACCOUnt Date Stat No Number PR00673 996 07/26/19 P 135-21317-000-000 070119-A 07/23/19 P 30 135-60020-030-000 07/24/19 P 10 135-65005-010-000 07/24/19 P 20 135-65005-020-000 07/24/19 P 20 135-65030-020-000 Chemicals 20831 07/29/19 P 10 135-60285-010-000 20831 07/29/19 P 20 135-60285-020-000 0425730 07/17/19 P 20 517-69005-020-000 Capital Outlays 3225 US Bank Voyager Fleet Systems 869338111930 3225 US Bank Voyager Fleet Systems 869338111930 Totals for Check: 5557 2634 Valley Solvent Cbepany, INC 44834 Totals for Check: 5558 3280 liATTS ELLISON LLC 3280 WATTS ELLISON LLC Totals for Check: 5559 2716 Wiss, Janney, Elstner Assoc Totals for Cheek: 5560 Trophy Club MUD No.1 AP Checks For Rate/Arco unt Range .00 Tb Amt: 99,999,999.99 Description TCORS Electricity/Gas Fuel & Lube Fuel & Lube Laval Evi trent & Maintenance Lavin Equipment & Maintenance 2707 United Rentals (North Ai,c,.ica) 172062208-001 07/29/19 P Totals for Cheat: 5561 Grand Totals: ***•** End of Report ********* 20 135-69005-020-000 Capital Outlays ^2 if 127 08/1fst 1,M919 Regular Meeting Agenda P cket 9 ,ane Iters Value t.:neck Limos Nuirber Date 6,808.18 5555 07/29/19 6,808.18 399.06 5556 07/29/19 399.06 913.65 5557 07/29/19 617.08 5557 07/29/19 1,530.73 569.00 5558 07/29/19 569.00 1,500.00 5559 07/29/19 1,480.00 5559 07/29/19 2,980.00 3,885.00 5560 07/29/19 3,885.00 47,942.93 5561 07/30/19 47,942.93 790,382.97 August 19, 2019 Regular Meeting Agenda Packet REGULAR MEETING MINUTES TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 BOARD OF DIRECTORS July 22, 2019 at 6:30 P.M. Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in regular session on July 22, 2019 at 6:30 P.M., in the Boardroom of the Administration Building, 100 Municipal Drive, Trophy Club, Texas 76262. The meeting was held within the boundaries of the District and was open to the public. STATE OF TEXAS COUNTIES OF DENTON AND TARRANT BOARD MEMBERS PRESENT: Gregory Wilson William C. Rose Steve Flynn Kelly Castonguay Mark Chapman STAFF PRESENT: John Carman Laurie Slaght Mike McMahon Steven Krolczyk Tony Corbett President Vice President Secretary/Treasurer Director Director General Manager District Secretary Operations Manager Finance Manager Legal Counsel § § CALL TO ORDER AND ANNOUNCE A QUORUM President Wilson announced the date of July 22, 2019, 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. June 2019 Check Register b. June 17, 2019 Regular Meeting Minutes c. Tax Collections Report — 3rd Quarter FY2019 d. Quarterly Investment Report — 3rd Quarter FY2019 Motion made by Director Flynn and seconded by Director Chapman to approve the Consent Agenda as presented. Motion carried unanimously REGULAR SESSION 2. Consider and take appropriate action to approve an Interlocal Cooperation Agreement with Denton 14 of 127 August 19, 2019 Regular Meeting Agenda Packet County for Property Tax Assessment and Collection. Motion made by Director Rose and seconded by Director Castonguay to approve the Interlocal Cooperation Agreement with Denton County and Trophy Club Municipal Utility District No. 1, Trophy Club Texas for Property Tax Assessment and Collection. Motion carried unanimously 3. Consider and take appropriate action regarding District participation in Texas Commission on Environmental Quality Sanitary Sewer Overflow Initiative. Motion made by Director Rose and seconded by Director Flynn to have the direct staff to participate in Texas Commission on Environmental Quality Sanitary Sewer Overflow Initiative. Motion carried unanimously 4. Discussion and possible action regarding adoption of Amended and Restated Reserve Fund Policy. Motion made by Director Rose and seconded by Director Flynn to approve Resolution No. 2019-0722 adopting cash Reserve Policy with the following changes: Section 2.03 Strike the sentence "Reserve targets are shown in Appendix A; change the last sentence to read "Reserve targets shall be adopted as a part of the annual budget"; and eliminate Appendix A. Motion carried unanimously 5. Consider and take appropriate action regarding Candidate Search for General Manager (Castonguay/Flynn) a.Receive report and recommendations from Recruitment and Retention Subcommittee; and b.Approve contract with executive search firm. Director Flynn and Director Castonguay are the on the Hiring Committee. Director Flynn provided an overview of the Committee's progress and stated that the Committee interviewed different firms for the search and cost structure of each. The Committee recommends moving forward with the Mercer Group. Motion made by Director Flynn and seconded by Director Chapman authorizing staff to execute Contract No. 2019072201 with The Mercer Group for an amount not to exceed $25,000 after review by legal counsel. Motion carried unanimously Board recess from 8:00 p.m. through 8:10 p.m. 6. Consider and take appropriate action to appoint two Directors to serve on a Committee to work with 15 of 127 August 19, 2019 Regular Meeting Agenda Packet Town of Trophy Club Council representatives regarding the sale or exchange of District real property located at 100 Municipal Drive and 1501 Junction Way. Motion made by Director Rose and seconded by Director Castonguay to authorize President Wilson and Vice President Rose to work on a Strategic Partnership Committee with the Town of Trophy Club Council representatives regarding the sale or exchange of District real property located at 100 Municipal Drive and 1501 Junction Way. For: Castonguay, Rose, Wilson and Chapman Oppose: Flynn Motion carried 4-1 7. Consider and take appropriate action regarding the June 2019 Combined Financials and Variance Report. a.Combined Financials b.Combined Variance Motion made by Director Flynn and seconded by Director Castonguay to approve the June 2019 Combined Financials and Variance Report. Motion carried unanimously REPORTS & UPDATES 8. Receive report from Directors that attended Association of Water Board Directors (AWBD). Director Rose provided an update to the Board. 9. Receive update from Budget Committee (Flynn/Rose) Director Flynn provided an update to the Board. 10. General Manager Monthly Reports and Update: a. Regulatory Update b. Capital Improvement Projects • Interconnect Water Transmission Line Phase 2 • Wastewater Treatment Plant Upgrade Project • High Service Pump • In -Plant Water System • Straight Creek Court & Carnoustie c. Staff Recruitment and Retention Update d. Water System Operations e. Wastewater System Operations f. Finance Update 16 of 127 August 19, 2019 Regular Meeting Agenda Packet • Utility Billing Report • Permits Collected • Cash Report • Revenue vs. Expenditure Report (Capital Projects) General Manager John Carman presented the monthly report to the Board and answered questions related thereto. Discussion ensued regarding staff recruitment and difficulties that the District has had attracting qualified applicants. The Board would like the District to be competitive in the market for qualified applicants and directed staff to adjust the compensation for the operator positions. Carman stated staff will bring this item back with suggested market adjustments at a future meeting. The Board convened into Executive Session at 8:45 p.m. EXECUTIVE SESSION 11. 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; 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); and c. Fire Department Matters: a. Interlocal Agreement with the Town of Trophy Club relating to Fire Department funding and operations; and b. Funding alternatives for acquisition of new fire truck. 12. Pursuant to Section 551.072 of the Texas Open Meetings Act, the Board may deliberate the purchase, exchange, lease, or value of real property if deliberation in an open meeting would have a detrimental effect on the position of the governmental body in negotiations with a third person: a. Sale or Exchange of District real property located at 100 Municipal Drive and 1501 Junction Way. b. Purchase of Easements required for construction and operation of Water Transmission Line Improvements from District Pump Station to Elevated Water Tank located on T.W. King Road The Board reconvened into Regular Session 9:56 p.m. REGULAR SESSION President Wilson stated that no decisions, votes or actions were taken in Executive Session. 13. Consider and take appropriate action on matters deliberated in Executive Session: 17 of 127 August 19, 2019 Regular Meeting Agenda Packet No action taken 14. Items for future agendas: 15. Set future Meeting dates: a. Joint Meeting with Town Council — Monday, July 29, 2019 at 7:00 p.m. b. Regular Board Meeting — Monday, August 19, 2019 at 6:30 p.m. ADJOURN Motion to adjourn made by Director Flynn President Wilson called the meeting adjourned at 9:57 p.m. Gregory Wilson, President Steve Flynn, Secretary/Treasurer Laurie Slaght, District Secretary 18 of 127 (SEAL) August 19, 2019 Regular Meeting Agenda Packet SPECIAL SESSION JOINT MEETING MINUTES TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 BOARD OF DIRECTORS JULY 29, 2019 at 7:00 P.M. Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in a Special Session Joint Meeting with the Town of Trophy Club Town Council on July 29, 2019 at 7:00 P.M., in the Boardroom of the Administration Building, 100 Municipal Drive, Trophy Club, Texas 76262. The meeting was held within the boundaries of the District and was open to the public. STATE OF TEXAS § COUNTIES OF DENTON AND TARRANT § BOARD MEMBERS PRESENT: Gregory Wilson William C. Rose Steve Flynn Kelly Castonguay Mark Chapman STAFF PRESENT: John Carman Laurie Slaght Steven Krolczyk President Vice President Secretary/Treasurer Director Director General Manager District Secretary Finance Manager TOWN COUNCIL PRESENT: C. Nick Sanders Eric Jensen Alicia L. Fleury Sean Bone Michael Geraci Mayor Mayor Pro Tem, Place 2 Council Member, Place 1 Council Member, Place 3 Council Member, Place 5 TOWN COUNCIL ABSENT: Philip Shoffner Council Member, Place 6 TOWN STAFF PRESENT: Wade Carroll Fire Chief/Acting Town Manager Holly Fimbres David Dodd Gary Cochran Cheryl Davenport Town Secretary Town Attorney Fire Marshall, Interim Fire Interim Finance Manager CALL TO ORDER AND ANNOUNCE A QUORUM President Wilson announced the date of July 29, 2019, called the meeting to order and announced a quorum present at 7:00 p.m. REGULAR SESSION 1. Consider and take appropriate action regarding the Fire Protection Services Fiscal Year 2020 budget. 19 of 127 August 19, 2019 Regular Meeting Agenda Packet Fire Chief Wade Carroll presented the Fire Services annual budget for Fiscal Year 2019 and answered related questions. Motion by Mayor Pro Tem, Eric Jenson and seconded by Alicia Fleury authorizing town staff to include funding of a new vehicle for the Fire Marshall for an amount not to exceed $40,000; and the purchase of necessary Information technology equipment for the ambulance in the fiscal year 2020 budget. Motion carried unanimously Motion made by Director Rose and seconded by Director Flynn to purchase two computer units for the fire trucks. Motion carried unanimously Chief Carroll requested that the extradition equipment be paid for with reserves funds. District Finance Manager Steven Krolczyk stated that the funds were available in the Fire Department reserves. Krolczyk stated that $20,000 would need to be pulled from reserves so we don't exceed the roll back rate. Motion made by Director Rose and seconded by Director Chapman to approve the Fire Protection Service Fiscal year 2020 Budget in a total amount not to exceed $1,832,019 and to remove $20,000 from reserves to supplement the budget. Motion carried unanimously ADJOURN President Wilson called the meeting adjourned at 8:07 p.m. Gregory Wilson, President Steve Flynn, Secretary/Treasurer Laurie Slaght, District Secretary 20 of 127 (SEAL) August 19, 2019 Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET JULY 2019 ASSETS CASH IN BANK INVESTMENTS PREPAID EXPENSES ADVALOREM PROPERTY TAXES RECEIVABLE EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT No. 1 122 FIRE DEPT. 776,543 2,982 23,245 TOTAL ASSETS 802,771 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES 23,252 TOTAL LIABILITIES 23,252 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE 543,884 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES 235,636 TOTAL FUND BALANCE 779,519 TOTAL LIABILITIES AND FUND BALANCE 802,771 21 of 127 glbase_tbam skrolczyk 15:23 08/14/19 Fund: 122 Trophy Club MUD Fire Dept. Account Description 1 1 122-40010-000-000 1 122-40011-000-000 1 122-40020-000-000 Property Taxes/MUD Fire Property Taxes/Fire-Delinquent Property Taxes/Fire P&i Trophy Club MUD No.1 Budget Summary with Amendment Department: Fire Revenues Program: Period Ending: 7/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Page 1 August 19, 2019 Regular Meeting Agenda Packet 1,117,000.00- 1,117,000.00- 3,169.30- 243.84- 126.69- 1,100,036.67- 3,128.00 4,618.95- 98.481 16,963.33- 3,128.00- 4,618.95 Subtotal: 1,117,000.00- 1,117,000.00- 3,539.83- 1,101,527.62- 98.615 15,472.38- 122-49035-000-000 Prior Year Reserves 75,000.00- 75,000.00- 75,000.00- 122-49900-000-000 Miscellaneous Income 135,611.06- 135,611.06 Subtotal: 75,000.00- 75,000.00- 135,611.06- 180.815 60,611.06 Program number: 1,192,000.00- 1,192,000.00- 3,539.83- 1,237,138.68- 103.787 45,138.68 Department number: Fire Revenues 1,192,000.00- 1,192,000.00- 3,539.83- 1,237,138.68- 103.787 45,138.68 Revenues Subtotal 1,192,000.00- 1,192,000.00- 3,539.83- 1,237,138.68- 103.787 45,138.68 22 of 127 glbase_tbam skrolczyk 15:23 08/14/19 Fund: 122 Trophy Club MUD Fire Dept. Account Description 1 1 122-60030-045-000 1 122-60055-045-000 1 122-60337-045-000 Rent And/Or Usage Insurance Transfer to Town/Fire Budget Trophy Club MUD No.1 Budget Summary with Amendment Department: 45 Fire Program: Period Ending: 7/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Page 2 August 19, 2019 Regular Meeting Agenda Packet 215,979.00 18,000.00 674,452.00 215,979.00 18,000.00 674,452.00 1,491.21 56,204.33 215,979.00 14,912.10 562,042.97 100.000 82.845 83.333 3,087.90 112,409.03 Subtotal: 908,431.00 908,431.00 57,695.54 792,934.07 87.286 115,496.93 122-69005-045-000 1 122-69195-045-000 Capital Outlays GASB34/Reserve for Replacement 75,000.00 81,420.00 75,000.00 81,420.00 81,420.00 100.000 75,000.00 122-69305-045-000 Capital Leases 127,149.00 127,149.00 127,148.60 100.000 .40 Subtotal: 283,569.00 283,569.00 208,568.60 73.551 75,000.40 Program number: 1,192,000.00 1,192,000.00 57,695.54 1,001,502.67 84.019 190,497.33 Department number: Fire 1,192,000.00 1,192,000.00 57,695.54 1,001,502.67 84.019 190,497.33 Expenditures Subtotal 1,192,000.00 1,192,000.00 57,695.54 1,001,502.67 84.019 190,497.33 Fund number: 122 Trophy Club MUD Fire Dept. 54,155.71 235,636.01- 235,636.01 23 of 127 glpdatb2 skrolczyk 15:24 08/14/19 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Fire Revenues Program: Period Ending: 7/2019 JE Detail Description/Comment Page 1 August 19, 2019 Regular Meeting Agenda Packet Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 122-40010-000-000 Property Taxes/MUD Fire 1829 07/01/2019 Property Taxes 1830 07/02/2019 Property Taxes 1831 07/03/2019 Property Taxes 1832 07/08/2019 Property Taxes 1833 07/09/2019 Property Taxes 1834 07/10/2019 Property Taxes 1835 07/11/2019 Property Taxes 1837 07/15/2019 Property Taxes 1838 07/16/2019 Property Taxes 1839 07/17/2019 Property Taxes 1840 07/18/2019 Property Taxes 1841 07/19/2019 Property Taxes 1842 07/22/2019 Property Taxes 1843 07/23/2019 Property Taxes 1844 07/24/2019 Property Taxes 1845 07/25/2019 Property Taxes 1846 07/26/2019 Property Taxes 1847 07/29/2019 Property Taxes 1848 07/30/2019 Property Taxes 1850 07/31/2019 Property Taxes (1,096,867.37) (29.55) (1,096,896.92) GL (14.54) (1,096,911.46) GL (19.22) (1,096,930.68) GL (31.77) (1,096,962.45) GL (30.74) (1,096,993.19) GL (6.77) (1,096,999.96) GL (10.72) (1,097,010.68) GL (190.89) (1,097,201.57) GL (43.88) (1,097,245.45) GL (442.78) (1,097,688.23) GL (45.86) (1,097,734.09) GL (387.03) (1,098,121.12) GL (585.29) (1,098,706.41) GL (124.74) (1,098,831.15) GL (264.87) (1,099,096.02) GL (163.17) (1,099,259.19) GL (131.37) (1,099,390.56) GL (377.87) (1,099,768.43) GL 16.80 (1,099,751.63) GL (285.04) (1,100,036.67) GL Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (3,169.30) (1,100,036.67) ** (1,117,000.00) Budgeted (16,963.33) Remaining 98 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1830 07/02/2019 Property Taxes 1832 07/08/2019 Property Taxes 1836 07/12/2019 Property Taxes 1850 07/31/2019 Property Taxes 3,371.84 (191.39) 3,180.45 GL (10.75) 3,169.70 GL (18.00) 3,151.70 GL (23.70) 3,128.00 GL Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (243.84) ' 3,128.00 ** .00 Budgeted (3,128.00) Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P8I 1829 07/01/2019 Property Taxes 1830 07/02/2019 Property Taxes 1831 07/03/2019 Property Taxes 1832 07/08/2019 Property Taxes 1833 07/09/2019 Property Taxes 1834 07/10/2019 Property Taxes (4,492.26) (1.54) (4,493.80) GL (26.47) (4,520.27) GL (2.50) (4,522.77) GL (1.52) (4,524.29) GL (2.76) (4,527.05) GL (.82) (4,527.87) GL 24 of 127 glpdatb2 skrolczyk 15:24 08/14/19 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description 1835 07/11/2019 Property Taxes 1836 07/12/2019 Property Taxes 1839 07/17/2019 Property Taxes 1841 07/19/2019 Property Taxes 1842 07/22/2019 Property Taxes 1843 07/23/2019 Property Taxes 1845 07/25/2019 Property Taxes 1847 07/29/2019 Property Taxes 1850 07/31/2019 Property Taxes Account: 122-40020-000-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Fire Revenues Program: Period Ending: 7/2019 JE Detail Description/Comment Page 2 August 19, 2019 Regular Meeting Agenda Packet Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Property Taxes/Fire PSI Totals: .00 Budgeted 4,618.95 Remaining (4,492.26) (1.62) (4,529.49) GL (3.43) (4,532.92) GL (1.55) (4,534.47) GL (12.08) (4,546.55) GL (52.98) (4,599.53) GL (.81) (4,600.34) GL (.68) (4,601.02) GL (3.82) (4,604.84) GL (14.11) (4,618.95) GL 0 % Used (126.69) (4,618.95) ** Account: 122-49035-000-000 Prior Year Reserves .00 .00 Account: 122-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (75,000.00) Budgeted (75,000.00) Remaining 0 % Used Account: 122-49900-000-000 Miscellaneous Income (135,611.06) .00 (135,611.06) Account: 122-49900-000-000 Miscellaneous Income Totals: .00 (135,611.06) ** .00 Budgeted 135,611.06 Remaining 0 % Used Department Totals: (1,237,138.68) ** (3,539.83) Monthly Total (1,192,000.00) Budgeted 45,138.68 Remaining 104 % Used 25 of 127 glpdatb2 skrolczyk 15:24 08/14/19 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Department: 45 Fire JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 7/2019 Beginning Balance Program: Page 3 August 19, 2019 Regular Meeting Agenda Packet Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Check Source Number Department 45 Totals: 127,149.00 Budgeted 57,695.54 Monthly Total .40 Remaining 100 % Used 1,192,000.00 Budgeted 26 of 127 1,001,502.67 ** 190,497.33 Remaining 84 % Used Account: 122-60030-045-000 Rent And/Or Usage 215,979.00 215,979.00 .00 Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 215,979.00 ** 215,979.00 Budgeted .00 Remaining 100 % Used Account: 122-60055-045-000 Insurance 134 07/01/2019 Insurance/Wrk Comp Expense Jul 13,420.89 1,491.21 14,912.10 GL Account: 122-60055-045-000 Insurance Totals: 1,491.21 14,912.10 ** 18,000.00 Budgeted 3,087.90 Remaining 83 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 1724 07/18/2019 July A/p July Fire admin 505,838.64 56,204.33 562,042.97 TOWN OF TROPHY CLUB 5530 AP Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 56,204.33 562,042.97 ** 674,452.00 Budgeted 112,409.03 Remaining 83 % Used Account: 122-69005-045-000 Capital Outlays .00 .00 Account: 122-69005-045-000 Capital Outlays Totals: .00 .00 ** 75,000.00 Budgeted 75,000.00 Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 .00 81,420.00 Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 81,420.00 ** 81,420.00 Budgeted .00 Remaining 100 % Used Account: 122-69305-045-000 Capital Leases 127,148.60 .00 127,148.60 Account: 122-69305-045-000 Capital Leases Totals: .00 127,148.60 ** Department 45 Totals: 127,149.00 Budgeted 57,695.54 Monthly Total .40 Remaining 100 % Used 1,192,000.00 Budgeted 26 of 127 1,001,502.67 ** 190,497.33 Remaining 84 % Used glpdatb2 skrolczyk 15:24 08/14/19 Fund: 122 Trophy Club MUD Fire Dept. JE JE JE Number Date Description Department: 45 Fire JE Detail Description/Comment Trophy Club MUD No.1 Page 4 Detailed Accounting Trial Balance Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Fund 122 Totals: (235,636.01) 54,155.71 Monthly Total .00 Budgeted 27 of 127 235,636.01 Remaining 0 % Used TROPHY CLUB MUD #1 - O&M (GENERAL FUND) BALANCE SHEET JULY 2019 August 19, 2019 Regular Meeting Agenda Packet 135 137 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 1,956,943 1,956,943 CASH IN BANK -SAVINGS -CASH RESERVE 1,193,446 1,193,446 INVESTMENTS-TEXPOOL 4,809,314 516,233 5,325,547 PREPAID EXPENSES 20,582 20,582 ADVALOREM PROPERTY TAXES RECEIVABLE 2,537 2,537 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,031,529 1,031,529 TOTAL ASSETS 9,014,951 516,233 9,531,184 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 2,537 2,537 ACCOUNTS AND OTHER PAYABLES 638,797 638,797 CUSTOMER DEPOSITS 312,525 312,525 TOTAL LIABILITIES 953,859 953,859 FUND BALANCE NON -SPENDABLE FUND BALANCE 8,486 8,486 ASSIGNED FUND BALANCE 2,173,156 2,173,156 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 225,000 225,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT (116,613) (116,613) ASSIGNED FUND BALANCE/SEWER REPLACEMENT 97,805 97,805 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 310,041 310,041 UNASSIGNED FUND BALANCE 5,442,543 5,442,543 COMMITTED FUND BALANCE NET REVENUES / EXPENDITURES 436,907 436,907 TOTAL FUND BALANCE 8,061,092 516,233 8,577,325 TOTAL LIABILITIES AND FUND BALANCE 9,014,951 516,233 9,531,184 28 of 127 glbase_tbam skrolczyk 15:23 08/14/19 Fund: 135 MUD 1 General Fund Account 135-40000-000-000 135-40002-000-000 135-40015-000-000 135-40025-000-000 Subtotal: 135-47000-000-000 135-47005-000-000 135-47025-000-000 135-47030-000-000 135-47035-000-000 135-47045-000-000 135-47070-000-000 Subtotal: 135-49011-000-000 135-49016-000-000 135-49018-000-000 135-49026-000-000 135-49035-000-000 135-49036-000-000 135-49075-000-000 135-49141-000-000 135-49900-000-000 135-49901-000-000 Description Property Taxes Property Taxes/Delinquent Property Taxes/P & i PID Surcharges Water Sewer Penalties Service Charges Plumbing Inspections Sewer Inspections TCCC Effluent Charges Interest Income Cell Tower Revenue Building Rent Income Proceeds from Sale of Assets Prior Year Reserves GASB Reserves Oversize Meter Reimbursement Interfund Transfer In Miscellaneous income Records Management Revenue Subtotal: Program number: Department number: Revenues Revenues Subtotal Department: Adopted Budget 132,384.00- 300.00- 300.00- 171,983.00- 304,967.00- 6,599,484.00- 3,412,665.00- 136,418.00- 17,000.00- 1,500.00- 4,500.00- 60,000.00- 10,231,567.00- 20,000.00- 14,146.00- 7,000.00- 10,000.00- 18,522.00- 7,000.00- 76,668.00- 10,613,202.00- 10,613,202.00- 10,613,202.00 - Trophy Club MUD No.1 Budget Summary with Amendment Revenues Period Ending: 7/2019 Amended Total Budget Encumb. 132,384.00- 300.00- 300.00- 171,983.00- 304,967.00- 6,599,484.00- 3,412,665.00- 136,418.00- 17,000.00- 1,500.00- 4,500.00- 60,000.00- 10,231,567.00- 80,000.00- 14,146.00- 7,000.00- 55,000.00- 358,600.00- 266,613.00- 18,522.00- 7,000.00- 806,881.00- 11,343,415.00- 11,343,415.00- 11,343,415.00- 29 of 127 Current Month 360.84- 27.54- 14.17- 402.55- 617,040.04- 264,167.00- 6,438.92- 700.00- 50.00- 150.00- 14,340.80- 902,886.76- 14,544.41- 1,178.81- 583.33- 343.00- 324.16- 16,973.71- 920,263.02- 920,263.02- 920,263.02 - Program: YTD Total 125,246.10- 322.64 511.81- 125,435.27- 3,570,646.57- 2,543,194.81- 78,957.91- 13,050.00- 1,150.00- 3,450.00- 19,685.60- 6,230,134.89- 113,447.48- 12,114.77- 5,833.30- 52,600.00- 266,613.00- 8,232.00- 25,000.00- 32,383.27- 4.00- 516,227.82- 6,871,797.98- 6,871,797.98- 6,871,797.98- % of Budget 94.608 -107.547 170.603 41.131 54.105 74.522 57.879 76.765 76.667 76.667 32.809 60.891 141.809 85.641 83.333 95.636 100.000 44.444 462.618 63.978 60.580 60.580 60.580 Page 3 August 19, 2019 Regular Meeting Agenda Packet Remaining Budget 7,137.90- 622.64- 211.81 171,983.00- 179,531.73- 3,028,837.43- 869,470.19- 57,460.09- 3,950.00- 350.00- 1,050.00- 40,314.40- 4,001,432.11- 33,447.48 2,031.23- 1,166.70- 2,400.00- 358,600.00- 10,290.00- 25,000.00 ,031.23-1,166.70-2,400.00- 358,600.00- 10,290.00- 25,000.00 25,383.27 4.00 290,653.18- 4,471,617.02- 4,471,617.02- 4,471,617.02- glbase_tbam skrolczyk 15:23 08/14/19 Fund: 135 MUD 1 General Fund Account 135-50005-010-000 135-50010-010-000 135-50016-010-000 135-50017-010-000 135-50020-010-000 135-50026-010-000 135-50027-010-000 135-50028-010-000 135-50029-010-000 135-50030-010-000 135-50035-010-000 135-50040-010-000 135-50045-010-000 135-50060-010-000 135-50070-010-000 Subtotal: 135-55005-010-000 135-55080-010-000 135-55085-010-000 135-55090-010-000 135-55105-010-000 135-55120-010-000 135-55135-010-000 Subtotal: 135-60010-010-000 135-60020-010-000 135-60066-010-000 135-60070-010-000 135-60080-010-000 135-60090-010-000 135-60100-010-000 135-60105-010-000 135-60135-010-000 135-60150-010-000 135-60245-010-000 135-60280-010-000 135-60285-010-000 135-60332-010-000 135-60333-010-000 135-60334-010-000 Description Salaries & Wages Overtime Longevity Certification Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Pre-emp Physicals/Testing Employee Relations Engineering Maintenance & Repairs Generator Maint. and Repair Vehicle Maintenance Maintenance-Backhoe/SkidLoader Cleaning Services Lab Analysis Communications/Mobiles Electricity Publications/Books/Subscripts Dues & Memberships Schools & Training Safety Program Travel & per diem Rent/Lease Equipment TCEQ Fees & Permits Wholesale Water Miscellaneous Expenses Property Maintenance Lawn Equipment & Maintenance Interfund Transfer Out -Rev I&S Interfund Transfer Out -Reserve Interfund Transfer Out Department: Adopted Budget 326,755.00 20,000.00 3,620.00 4,800.00 33,304.00 74,818.00 4,317.00 701.00 3,131.00 22,021.00 5,150.00 1,080.00 12,895.00 200.00 300.00 513,092.00 20,000.00 100,000.00 3,000.00 5,000.00 3,500.00 5,214.00 6,500.00 143,214.00 5,000.00 154,204.00 1,000.00 500.00 4,651.00 400.00 2,345.00 1,500.00 58,000.00 3,013,494.00 200.00 3,000.00 14,750.00 585,209.00 55,193.00 200,000.00 Trophy Club MUD No.1 Page 4 Budget Summary with Amendment 10 Water Period Ending: 7/2019 Amended Total Budget Encumb. 326,755.00 20,000.00 3,620.00 4,800.00 33,304.00 74,818.00 4,317.00 701.00 3,131.00 22,021.00 5,150.00 1,080.00 12,895.00 200.00 300.00 513,092.00 20,000.00 153,000.00 3,000.00 5,000.00 3,500.00 5,214.00 6,500.00 196,214.00 5,000.00 154,204.00 1,000.00 500.00 4,651.00 400.00 2,345.00 1,500.00 58,000.00 3,013,494.00 200.00 3,000.00 14,750.00 585,209.00 55,193.00 200,000.00 30 of 127 Current Month 23,886.34 696.35 125.00 2,285.46 4,219.68 261.55 42.47 209.67 1,491.85 348.91 930.94 34,498.22 3,527.09 8.44 279.35 3,814.88 237.69 10,458.80 39.00- 199,622.35 1,500.00 25,172.81 4,600.00 Program: YTD Total 245,931.86 9,930.62 3,620.00 1,800.00 25,219.94 38,384.16 2,471.80 405.05 2,134.46 15,769.23 3,687.97 46.80 9,038.80 202.45 358,643.14 111,535.51 1,906.30 3,210.54 7,176.62 123,828.97 3,095.46 86,145.65 790.00 122.00 3,556.01 678.98 16,336.53 1,200,444.80 612.00 6,590.00 251,728.10 46,000.00 % of Budget 75.265 49.653 100.000 37.500 75.726 51.303 57.257 57.782 68.172 71.610 71.611 4.333 70.095 101.225 69.898 72.899 63.543 64.211 110.410 63.109 61.909 55.865 79.000 24.400 76.457 28.954 28.166 39.836 20.400 44.678 43.015 83.344 August 19, 2019 Regular Meeting Agenda Packet Remaining Budget 80,823.14 10,069.38 3,000.00 8,084.06 36,433.84 1,845.20 295.95 996.54 6,251.77 1,462.03 1,033.20 3,856.20 2.45- 300.00 154,448.86 20,000.00 41,464.49 1,093.70 1,789.46 3,500.00 5,214.00 676.62- 72,385.03 1,904.54 68,058.35 210.00 378.00 1,094.99 400.00 1,666.02 1,500.00 41,663.47 1,813,049.20 200.00 2,388.00 8,160.00 333,480.90 9,193.00 200,000.00 glbase_tbam skrolczyk 15:23 08/14/19 Fund: 135 MUD 1 General Fund Account 135-60360-010-000 Subtotal: 135-65005-010-000 135-65010-010-000 135-65030-010-000 135-65035-010-000 135-65040-010-000 135-65050-010-000 135-65053-010-000 Subtotal: 135-69005-010-000 135-69008-010-000 135-69009-010-000 135-69195-010-000 135-69281-010-000 Subtotal: Program number: Description Furniture/Equipment < $5000 Fuel & Lube Uniforms Chemicals Small Tools Safety Equipment Meter Expense Meter Change Out Program Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Water Tank Inspection Contract Department: Adopted Budget 2,500.00 4,101,946.00 15,000.00 5,190.00 20,000.00 1,200.00 1,000.00 70,000.00 87,000.00 199,390.00 453,000.00 30,068.00 4,124.00 75,000.00 120,000.00 682,192.00 5,639,834.00 Trophy Club MUD No.1 Page 5 Budget Summary with Amendment 10 Water Period Ending: 7/2019 Amended Total Budget Encumb. 2,500.00 4,101,946.00 15,000.00 5,190.00 20,000.00 1,200.00 1,000.00 70,000.00 87,000.00 199,390.00 719,613.00 30,068.00 4,124.00 75,000.00 120,000.00 948,805.00 5,959,447.00 31 of 127 Current Month 241,552.65 913.65 2,530.54 3,444.19 81,910.70 81,910.70 365,220.64 Program: YTD Total 1,616,099.53 8,566.02 2,070.81 18,554.88 641.25 17,861.60 86,949.00 134,643.56 624,503.90 30,068.00 2,283.93 75,000.00 99,877.11 831,732.94 3,064,948.14 % of Budget 39.398 57.107 39.900 92.774 64.125 25.517 99.941 67.528 86.783 100.000 55.381 100.000 83.231 87.661 51.430 August 19, 2019 Regular Meeting Agenda Packet Remaining Budget 2,500.00 2,485,846.47 6,433.98 3,119.19 1,445.12 1,200.00 358.75 52,138.40 51.00 64,746.44 95,109.10 1,840.07 20,122.89 117,072.06 2,894,498.86 glbase_tbam skrolczyk 15:23 08/14/19 Fund: 135 MUD 1 General Fund Account Description 135-55135-010-001 Subtotal: Program number: Department number: Lab Analysis for PID 1 Lab Analysis for PID Water Department: 10 Water Trophy Club MUD No.1 Page 6 Budget Summary with Amendment Program: 1 Lab Analysis for PAugust 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 2,000.00 2,000.00 2,000.00 5,641,834.00 2,000.00 2,000.00 2,000.00 5,961,447.00 32 of 127 365,220.64 1,351.59 1,351.59 1,351.59 3,066,299.73 67.580 648.41 67.580 648.41 67.580 51.435 648.41 2,895,147.27 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7 15:23 08/14/19 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 421,699.00 421,699.00 26,981.36 279,694.57 66.326 142,004.43 135-50010-020-000 Overtime 30,000.00 30,000.00 2,636.96 29,602.23 98.674 397.77 135-50016-020-000 Longevity 7,445.00 7,445.00 7,445.00 100.000 135-50017-020-000 Certification 8,700.00 8,700.00 725.00 7,125.00 81.897 1,575.00 135-50020-020-000 Retirement 43,276.00 43,276.00 2,806.74 31,474.36 72.729 11,801.64 135-50026-020-000 Medical Insurance 91,627.00 91,627.00 5,588.48 55,060.34 60.092 36,566.66 135-50027-020-000 Dental Insurance 5,104.00 5,104.00 340.56 3,499.59 68.566 1,604.41 135-50028-020-000 Vision Insurance 826.00 826.00 55.64 566.18 68.545 259.82 135-50029-020-000 Life Insurance & Other 4,495.00 4,495.00 384.94 3,292.15 73.240 1,202.85 135-50030-020-000 Social Security Taxes 29,006.00 29,006.00 1,776.79 18,954.89 65.348 10,051.11 135-50035-020-000 Medicare Taxes 6,784.00 6,784.00 415.55 4,433.01 65.345 2,350.99 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 54.00 4.286 1,206.00 135-50045-020-000 Workman's Compensation 16,941.00 16,941.00 1,205.73 11,707.50 69.107 5,233.50 135-50060-020-000 Pre-emp Physicals/Testing 400.00 400.00 114.00 28.500 286.00 135-50070-020-000 Employee Relations 300.00 300.00 75.74 25.247 224.26 Subtotal: 667,863.00 667,863.00 42,917.75 453,098.56 67.843 214,764.44 135-55005-020-000 Engineering 30,000.00 30,000.00 30,000.00 135-55070-020-000 Independent Labor 15,000.00 15,000.00 2,921.00 19.473 12,079.00 135-55080-020-000 Maintenance & Repairs 88,000.00 133,000.00 10,688.88 110,241.73 82.889 22,758.27 135-55085-020-000 Generator Maint. and Repair 10,000.00 10,000.00 570.00 5,451.63 54.516 4,548.37 135-55090-020-000 Vehicle Maintenance 8,000.00 8,000.00 16.50 1,692.74 21.159 6,307.26 135-55105-020-000 Maintenance-Backhoe/SkidLoader 1,500.00 7,000.00 6,803.00 97.186 197.00 135-55120-020-000 Cleaning Services 5,214.00 5,214.00 5,214.00 135-55125-020-000 Dumpster Services 75,000.00 75,000.00 2,574.29 59,619.84 79.493 15,380.16 135-55135-020-000 Lab Analysis 35,000.00 35,000.00 4,759.96 27,869.21 79.626 7,130.79 Subtotal: 267,714.00 318,214.00 18,609.63 214,599.15 67.439 103,614.85 135-60010-020-000 Communications/Mobiles 5,000.00 5,000.00 372.26 4,182.20 83.644 817.80 135-60020-020-000 Electricity 174,165.00 174,165.00 11,298.62 122,624.98 70.407 51,540.02 135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 200.00 135-60070-020-000 Dues & Memberships 300.00 300.00 191.00 63.667 109.00 135-60080-020-000 Schools & Training 7,155.00 7,155.00 150.00- 1,658.23 23.176 5,496.77 135-60090-020-000 Safety Program 1,000.00 1,000.00 100.74 10.074 899.26 135-60100-020-000 Travel & per diem 1,895.00 1,895.00 544.55 28.736 1,350.45 135-60105-020-000 Rent/Lease Equipment 5,000.00 5,000.00 3,491.07 69.821 1,508.93 135-60125-020-000 Advertising 2,500.00 2,500.00 2,500.00 135-60135-020-000 TCEQ Fees & Permits 30,000.00 30,000.00 16,545.22 55.151 13,454.78 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 4.00 4.00 .889 446.00 135-60280-020-000 Property Maintenance 5,000.00 5,000.00 225.18 4.504 4,774.82 135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 1,480.00 5,639.47 48.616 5,960.53 135-60331-020-000 Interfund Transfer Out -Tax I&S 120,053.00 120,053.00 10,913.90 109,139.00 90.909 10,914.00 33 of 127 glbase_tbam skrolczyk Trophy Club MUD No.1 15:23 08/14/19 Budget Summary with Amendment Page 8 Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60332-020-000 135-60333-020-000 135-60334-020-000 135-60360-020-000 Interfund Transfer Out -Rev I&S Interfund Transfer Out -Reserve Interfund Transfer Out Furniture/Equipment < $5000 688,330.00 125,187.00 200,000.00 3,500.00 688,330.00 125,187.00 200,000.00 3,500.00 54,203.45 10,432.00 791.00 542,034.50 104,320.00 78.746 83.331 791.00 22.600 146,295.50 20,867.00 200,000.00 2,709.00 Subtotal: 1,381,335.00 1,381,335.00 89,345.23 911,491.14 65.986 469,843.86 135-65005-020-000 135-65010-020-000 135-65030-020-000 135-65035-020-000 135-65040-020-000 135-65045-020-000 Fuel & Lube Uniforms Chemicals Small Tools Safety Equipment Lab Supplies 12,500.00 5,495.00 30,000.00 1,200.00 1,200.00 20,000.00 12,500.00 5,495.00 30,000.00 1,200.00 1,200.00 20,000.00 617.08 569.00 230.21 1,956.90 10,776.36 2,713.30 29,925.09 1,004.27 1,637.69 15,933.84 86.211 49.378 99.750 83.689 136.474 79.669 1,723.64 2,781.70 74.91 195.73 437.69- 4,066.16 Subtotal: 70,395.00 70,395.00 3,373.19 61,990.55 88.061 8,404.45 135-69005-020-000 135-69008-020-000 135-69009-020-000 1 135-69195-020-000 Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement 330,000.00 109,858.00 14,917.00 30,000.00 688,600.00 109,858.00 14,917.00 30,000.00 55,466.39 581,362.10 39,858.59 3,027.55 30,000.00 84.427 36.282 20.296 100.000 107,237.90 69,999.41 11,889.45 34 of 127 Subtotal: 484,775.00 843,375.00 55,466.39 654,248.24 77.575 189,126.76 135-70020-020-000 Capital Lease Issuance Cost 1,500.00 1,500.00 - Subtotal: 1,500.00 1,500.00 - Program number: 2,872,082.00 3,281,182.00 209,712.19 2,296,927.64 70.003 984,254.36 Department number: Wastewater 2,872,082.00 3,281,182.00 209,712.19 2,296,927.64 70.003 984,254.36 34 of 127 glbase_tbam skrolczyk 15:23 08/14/19 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: 7/2019 Adopted Amended Total Budget Budget Encumb. 30.00 30.00 Current Month 2.12 Program: YTD Total 21.20 Page 9 August 19, 2019 Regular Meeting Agenda Packet % of Remaining Budget Budget 70.667 8.80 Subtotal: 30.00 30.00 2.12 21.20 70.667 8.80 135-60066-026-000 135-60070-026-000 135-60075-026-000 135-60080-026-000 135-60100-026-000 Publications/Books/Subscripts Dues & Memberships Meetings Schools & Training Travel & per diem 150.00 750.00 1,300.00 4,000.00 5,000.00 150.00 750.00 1,300.00 4,000.00 5,000.00 16.97 650.00 64.34 920.00 800.06 86.667 4.949 23.000 16.001 150.00 100.00 1,235.66 3,080.00 4,199.94 135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 2,000.00 Subtotal: 13,200.00 13,200.00 16.97 2,434.40 18.442 10,765.60 Program number: 13,230.00 13,230.00 19.09 2,455.60 18.561 10,774.40 Department number: Board of Directors 13,230.00 13,230.00 19.09 2,455.60 18.561 10,774.40 35 of 127 glbase_tbam skrolczyk Trophy Club MUD No.1 15:23 08/14/19 Budget Summary with Amendment Page 10 Fund: 135 MUD 1 General Fund Department: 30 Administration Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 135-50010-030-000 135-50016-030-000 135-50020-030-000 135-50026-030-000 135-50027-030-000 135-50028-030-000 135-50029-030-000 135-50030-030-000 135-50035-030-000 135-50040-030-000 135-50045-030-000 135-50060-030-000 135-50070-030-000 Salaries & Wages Overtime Longevity Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Pre-emp Physicals/Testing Employee Relations 441,006.00 2,000.00 1,833.00 41,148.00 81,895.00 4,291.00 701.00 4,495.00 27,580.00 6,450.00 1,260.00 1,295.00 500.00 5,000.00 441,006.00 2,000.00 1,833.00 41,148.00 81,895.00 4,291.00 701.00 4,495.00 27,580.00 6,450.00 1,260.00 1,295.00 500.00 5,000.00 27,461.86 2,540.22 5,123.40 289.83 45.48 312.42 1,598.59 373.88 106.55 76.80 300,079.09 57.98 1,832.50 29,292.38 48,053.76 2,763.33 443.24 3,027.44 17,836.64 4,171.49 59.58 1,025.90 141.95 3,115.29 68.044 2.899 99.973 71.188 58.677 64.398 63.230 67.351 64.672 64.674 4.729 79.220 28.390 62.306 140,926.91 1,942.02 .50 11,855.62 33,841.24 1,527.67 257.76 1,467.56 9,743.36 2,278.51 1,200.42 269.10 358.05 1,884.71 Subtotal: 619,454.00 619,454.00 37,929.03 411,900.57 66.494 207,553.43 135-55030-030-000 135-55070-030-000 135-55080-030-000 135-55085-030-000 135-55120-030-000 135-55160-030-000 135-55205-030-000 Software & Support Independent Labor Maintenance & Repairs Generator Maint. and Repair Cleaning Services Professional Outside Services Utility Billing Contract 77,849.00 175,000.00 20,000.00 10,000.00 10,000.00 66,055.00 9,000.00 77,849.00 175,000.00 20,000.00 10,000.00 10,000.00 66,055.00 9,000.00 1,618.16 13,262.89 869.06 575.41 52,869.15 119,511.23 4,975.00 927.52 7,821.54 61,926.50 5,801.84 67.912 68.292 24.875 9.275 78.215 93.750 64.465 24,979.85 55,488.77 15,025.00 9,072.48 2,178.46 4,128.50 3,198.16 Subtotal: 367,904.00 367,904.00 16,325.52 253,832.78 68.994 114,071.22 135-60005-030-000 135-60010-030-000 135-60020-030-000 135-60025-030-000 135-60035-030-000 135-60040-030-000 135-60050-030-000 135-60055-030-000 135-60066-030-000 135-60070-030-000 135-60075-030-000 135-60079-030-000 135-60080-030-000 135-60100-030-000 135-60110-030-000 135-60125-030-000 135-60235-030-000 Telephone Communications/Mobiles Electricity/Gas Water Postage Service Charges & Fees Bad Debt Expense Insurance Publications/Books/Subscripts Dues & Memberships Meetings Public Education Schools & Training Travel & per diem Physicals/Testing Advertising Security 23,500.00 4,000.00 8,690.00 2,000.00 30,000.00 55,560.00 1,500.00 65,000.00 1,000.00 6,000.00 400.00 6,000.00 8,950.00 4,345.00 200.00 25,000.00 1,288.00 23,500.00 4,000.00 8,690.00 2,000.00 30,000.00 55,560.00 1,500.00 65,000.00 1,000.00 6,000.00 400.00 6,000.00 8,950.00 4,345.00 200.00 25,000.00 1,288.00 36 of 127 1,458.33 237.94 399.06 59.05 1,709.81 5,154.61 6,302.73 260.99 125.00 13.89 24.00 14,590.51 2,375.41 5,210.47 558.97 18,218.99 53,846.10 62.087 59.385 59.959 27.949 60.730 96.915 63,027.30 96.965 4,269.25 133.82 260.99 1,172.00 140.96 71.154 33.455 4.350 13.095 3.244 240.00 18.634 8,909.49 1,624.59 3,479.53 1,441.03 11,781.01 1,713.90 1,500.00 1,972.70 1,000.00 1,730.75 266.18 5,739.01 7,778.00 4,204.04 200.00 25,000.00 1,048.00 glbase_tbam skrolczyk 15:23 08/14/19 Fund: 135 MUD 1 General Fund Account Description 135-60245-030-000 135-60246-030-000 135-60360-030-000 Miscellaneous Expenses General Manager Contingency Furniture/Equipment < $5000 Trophy Club MUD No.1 Budget Summary with Amendment Department: 30 Administration Program: Period Ending: 7/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Page 11 August 19, 2019 Regular Meeting Agenda Packet 500.00 17,000.00 2,500.00 500.00 17,000.00 2,500.00 239.99 124.49 239.99 24.898 9.600 375.51 17,000.00 2,260.01 Subtotal: 263,433.00 263,433.00 15,985.40 164,409.25 62.410 99,023.75 135-65010-030-000 135-65055-030-000 135-65085-030-000 135-65090-030-000 135-65095-030-000 135-65105-030-000 Uniforms Hardware Office Supplies Printer Supplies & Maintenance Maintenance Supplies Printing 2,050.00 7,064.00 6,000.00 3,500.00 4,000.00 2,500.00 2,050.00 7,064.00 6,000.00 3,500.00 4,000.00 2,500.00 528.98 75.43 533.20 3,554.79 6,245.44 4,327.87 50.323 104.091 108.197 2,050.00 3,509.21 245.44- 3,500.00 327.87- 2,500.00 Subtotal: 25,114.00 25,114.00 1,137.61 14,128.10 56.256 10,985.90 135-69005-030-000 Capital Outlays 280,000.00 280,000.00 22,961.14 69,927.14 24.974 210,072.86 135-69170-030-000 Copier Lease Installments 4,000.00 4,000.00 310.33 2,723.97 68.099 1,276.03 Subtotal: 284,000.00 284,000.00 23,271.47 72,651.11 25.581 211,348.89 Program number: 1,559,905.00 1,559,905.00 94,649.03 916,921.81 58.781 642,983.19 Department number: Administration 1,559,905.00 1,559,905.00 94,649.03 916,921.81 58.781 642,983.19 37 of 127 glbase_tbam skrolczyk 15:23 08/14/19 Fund: 135 MUD 1 General Fund Department: Account Description Adopted Budget Trophy Club MUD No.1 Page 12 Budget Summary with Amendment 39 Non Departmental Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 Amended Total Current YTD % of Remaining Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 137,000.00 137,000.00 113,228.07 82.648 135-55055-039-000 Auditing 30,800.00 30,800.00 26,459.53 85.908 135-55060-039-000 Appraisal 11,714.00 11,714.00 2,111.10 8,945.42 76.365 135-55065-039-000 Tax Admin Fees 4,800.00 4,800.00 3,653.00 76.104 Subtotal: 184,314.00 184,314.00 2,111.10 152,286.02 82.623 Program number: 184,314.00 184,314.00 2,111.10 152,286.02 82.623 Department number: Non Departmental 184,314.00 184,314.00 2,111.10 152,286.02 82.623 Expenditures Subtotal 10,271,365.00 11,000,078.00 671,712.05 6,434,890.80 58.499 Fund number: 135 MUD 1 General Fund 341,837.00- 343,337.00- 248,550.97- 436,907.18- 127.253 38 of 127 23,771.93 4,340.47 2,768.58 1,147.00 32,027.98 32,027.98 32,027.98 4,565,187.20 93,570.18 glbase_tbam skrolczyk 15:23 08/14/19 Fund: 137 MUD 1 Consolidated GASB Account 137-49145-000-000 Description Intergov Transfer -General Fund Department: Adopted Budget Trophy Club MUD No.1 Budget Summary with Amendment Program: Period Ending: 7/2019 Amended Total Current YTD Budget Encumb. Month Total 105,000.00 - Page 13 August 19, 2019 Regular Meeting Agenda Packet % of Remaining Budget Budget 105,000.00 137-49146-000-000 Intergov Transfer -Fire Dept 81,420.00- 81,420.00 Subtotal: 186,420.00- 186,420.00 Program number: 186,420.00- 186,420.00 Department number: 186,420.00- 186,420.00 Revenues Subtotal 186,420.00- 186,420.00 39 of 127 glbase_tbam skrolczyk Trophy Club MUD No.l Page 14 15:23 08/14/19 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: 10 Water Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Account Description 137-69195-010-000 Subtotal: Program number: Department number: Expenditures GASB Replacement Water Subtotal Fund number: 137 MUD 1 Consolidated GASB 40 of 127 266,613.00 266,613.00 266,613.00 266,613.00 266,613.00 80,193.00 266,613.00- 266,613.00- 266,613.00- 266,613.00- 266,613.00- 80,193.00- glpdatb2 skrolczyk 15:24 08/14/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 7/2019 JE Detail Description/Comment Page 5 August 19, 2019 Regular Meeting Agenda Packet Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 135-40000-000-000 Property Taxes 1829 07/01/2019 Property Taxes 1830 07/02/2019 Property Taxes 1831 07/03/2019 Property Taxes 1832 07/08/2019 Property Taxes 1833 07/09/2019 Property Taxes 1834 07/10/2019 Property Taxes 1835 07/11/2019 Property Taxes 1837 07/15/2019 Property Taxes 1838 07/16/2019 Property Taxes 1839 07/17/2019 Property Taxes 1840 07/18/2019 Property Taxes 1841 07/19/2019 Property Taxes 1842 07/22/2019 Property Taxes 1843 07/23/2019 Property Taxes 1844 07/24/2019 Property Taxes 1845 07/25/2019 Property Taxes 1846 07/26/2019 Property Taxes 1847 07/29/2019 Property Taxes 1848 07/30/2019 Property Taxes 1850 07/31/2019 Property Taxes (124,885.26) (3.36) (124,888.62) GL (1.65) (124,890.27) GL (2.19) (124,892.46) GL (3.62) (124,896.08) GL (3.50) (124,899.58) GL (.77) (124,900.35) GL (1.22) (124,901.57) GL (21.73) (124,923.30) GL (5.00) (124,928.30) GL (50.41) (124,978.71) GL (5.22) (124,983.93) GL (44.07) (125,028.00) GL (66.64) (125,094.64) GL (14.20) (125,108.84) GL (30.16) (125,139.00) GL (18.58) (125,157.58) GL (14.96) (125,172.54) GL (43.02) (125,215.56) GL 1.91 (125,213.65) GL (32.45) (125,246.10) GL Account: 135-40000-000-000 Property Taxes Totals: (360.84) (125,246.10) ** (132,384.00) Budgeted (7,137.90) Remaining 95 6 Used Account: 135-40002-000-000 Property Taxes/Delinquent 1830 07/02/2019 Property Taxes 1832 07/08/2019 Property Taxes 1836 07/12/2019 Property Taxes 1850 07/31/2019 Property Taxes 350.18 (21.95) 328.23 GL (1.23) 327.00 GL (2.07) 324.93 GL (2.29) 322.64 GL Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (27.54) 322.64 ** (300.00) Budgeted (622.64) Remaining -108 % Used Account: 135-40015-000-000 Property Taxes/P & I 1829 07/01/2019 Property Taxes 1830 07/02/2019 Property Taxes 1831 07/03/2019 Property Taxes 1832 07/08/2019 Property Taxes 1833 07/09/2019 Property Taxes 1834 07/10/2019 Property Taxes (497.64) (.18) (497.82) GL (3.04) (500.86) GL (.28) (501.14) GL (.18) (501.32) GL (.31) (501.63) GL (.09) (501.72) GL 41 of 127 glpdatb2 skrolczyk 15:24 08/14/19 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 1835 07/11/2019 Property Taxes 1836 07/12/2019 Property Taxes 1839 07/17/2019 Property Taxes 1841 07/19/2019 Property Taxes 1842 07/22/2019 Property Taxes 1843 07/23/2019 Property Taxes 1845 07/25/2019 Property Taxes 1847 07/29/2019 Property Taxes 1850 07/31/2019 Property Taxes Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 7/2019 Beginning Balance JE Detail Description/Comment Account: 135-40015-000-000 Property Taxes/P & I (300.00) Budgeted Account: 135-40025-000-000 PID Surcharges Account: 135-40025-000-000 PID Surcharges (171,983.00) Budgeted Account: 135-47000-000-000 Water 1 (497.64) Program: Transaction Detail (.18) (.39) (.18) (1.37) (6.03) (.10) (.08) (.44) (1.32) Page 6 August 19, 2019 Regular Meeting Agenda Packet Transaction Vendor_Name Detail (SUBTOTAL) (501.90) (502.29) (502.47) (503.84) (509.87) (509.97) (510.05) (510.49) (511.81) (511.81) ** Check Source Number GL GL GL GL GL GL GL GL GL Totals: 211.81 Remaining 7) 171 % Used .00 .00 Totals: (171,983.00) Remaining .00 .00 ** 1800 07/31/2019 UB 07/31/2019 Billing 0320190731-20190731 User: Account: 135-47000-000-000 Water (6,599,484.00) Budgeted Account: 135-47005-000-000 Sewer 1659 07/10/2019 UB 07/10/2019 WA adjustment 1794 07/31/2019 UB 07/31/2019 WA adjustment 1800 07/31/2019 UB 07/31/2019 Billing Account: 135-47005-000-000 1 Account: 135-47025-000-000 1637 07/08/2019 UB 07/08/2019 1753 07/23/2019 UB 07/23/2019 1756 07/23/2019 UB 07/23/2019 1776 07/29/2019 UB 07/29/2019 1788 07/30/2019 UB 07/30/2019 (2,953,606.53) 0 % Used (617,040.04) (3,570,646.57) UB Totals: (3,028,837.43) Remaining (617,040.04) (3,570,646.57) ** UB20190710-20190710 User: UB20190731-20190731 User: UB20190731-20190731 User: Sewer (3,412,665.00) Budgeted Penalties Penalty Removal Penalties Penalty removal Penalty removal Penalty removal 54 % Used (2,279,027.81) Totals: (869,470.19) Remaining UB20190708-20190708 User: UB20190723-20190723 User: UB20190723-20190723 User: UB20190729-20190729 User: UB20190730-20190730 User: 56.56 28.89 (264,252.45) 75 % Used (72,518.99) 42 of 127 (2,278,971.25) (2,278,942.36) (2,543,194.81) (264,167.00) (2,543,194.81) ** 86.73 (72,432.26) (6,664.33) (79,096.59) 14.25 (79,082.34) 63.46 (79,018.88) 23.48 (78,995.40) UB UB UB UB UB UB UB UB glpdatb2 skrolczyk 15:24 08/14/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 7/2019 Beginning Transaction Transaction Vendor_Name Balance Detail Detail (SUBTOTAL) JE Detail Description/Comment 1789 07/30/2019 UB 07/30/2019 Penalty revmoval 13B20190730-20190730 User: Page 7 August 19, 2019 Regular Meeting Agenda Packet (72,518.99) 37.49 (78,957.91) Check Source Number UB 43 of 127 Account: 135-47025-000-000 Penalties Totals: (6,438.92) (78,957.91) ** (136,418.00) Budgeted (57,460.09) Remaining 58 % Used Account: 135-47030-000-000 Service Charges 1647 07/02/2019 UB 07/02/2019 NSF Check UB20190702-20190702 User: (12,350.00) 1646 07/03/2019 UB 07/03/2019 NSF Check 13B20190703-20190703 User: 1650 07/09/2019 UB 07/09/2019 Disconnect Fees UB20190709-20190709 User: (25.00) (25.00) (650.00) (12,375.00) (12,400.00) (13,050.00) UB UB UB Account: 135-47030-000-000 Service Charges Totals: (700.00) (13,050.00) ** (17,000.00) Budgeted (3,950.00) Remaining 77 % Used Account: 135-47035-000-000 Plumbing Inspections 1808 07/19/2019 Permits -18 Katie Lane 18 Katie Lane (1,100.00) (50.00) (1,150.00) Drees Homes CR Account: 135-47035-000-000 Plumbing Inspections Totals: (50.00) (1,150.00) ** (1,500.00) Budgeted (350.00) Remaining 77 % Used Account: 135-47045-000-000 Sewer Inspections 1808 07/19/2019 Permits -18 Katie Lane 18 Katie Lane (3,300.00) (150.00) (3,450.00) Drees Homes CR Account: 135-47045-000-000 Sewer Inspections Totals: (150.00) (3,450.00) ** (4,500.00) Budgeted (1,050.00) Remaining 77 % Used Account: 135-47070-000-000 TCCC Effluent Charges 1800 07/31/2019 UB 07/31/2019 Billing UB20190731-20190731 User: (5,344.80) (14,340.80) (19,685.60) UB Account: 135-47070-000-000 TCCC Effluent Charges Totals: (14,340.80) (19,685.60) ** (60,000.00) Budgeted (40,314.40) Remaining 33 % Used Account: 135-49011-000-000 Interest Income 1861 07/31/2019 Bank Interest- July (98,903.07) 1861 07/31/2019 Bank Interest- July 1861 07/31/2019 Bank Interest- July (895.37) (1,265.67) (12,383.37) (99,798.44) (101,064.11) (113,447.48) GL GL GL Account: 135-49011-000-000 Interest Income Totals: (14,544.41) (113,447.48) ** (80,000.00) Budgeted 33,447.48 Remaining 142 o Used 43 of 127 glpdatb2 skrolczyk 15:24 08/14/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 7/2019 Beginning Balance JE Detail Description/Comment Program: Page 8 August 19, 2019 Regular Meeting Agenda Packet Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Check Source Number 44 of 127 Account: 135-49016-000-000 ' Cell Tower Revenue 1801 07/26/2019 Cell Tower Rev AT&T July (10,935.96) (1,178.81) (12,114.77) GL Account: 135-49016-000-000 ' Cell Tower Revenue Totals: (1,178.81) (12,114.77) ** (14,146.00) Budgeted (2,031.23) Remaining 86 % Used Account: 135-49018-000-000 Building Rent Income 1862 07/31/2019 Town Billed Invoices 1698-1701 AR 20190731-20190731 User: (5,249.97) (583.33) (5,833.30) AR Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (5,833.30) ** (7,000.00) Budgeted (1,166.70) Remaining 83 % Used Account: 135-49026-000-000 Proceeds from Sale of Assets (52,600.00) .00 (52,600.00) Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: .00 (52,600.00) ** (55,000.00) Budgeted (2,400.00) Remaining 96 % Used Account: 135-49035-000-000 Prior Year Reserves .00 .00 Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (358,600.00) Budgeted (358,600.00) Remaining 0 % Used Account: 135-49036-000-000 GASB Reserves (266,613.00) .00 (266,613.00) Account: 135-49036-000-000 GASB Reserves Totals: .00 (266,613.00) ** (266,613.00) Budgeted .00 Remaining 100 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 1808 07/19/2019 Permits -18 Katie Lane 18 Katie Lane (7,889.00) (343.00) (8,232.00) Drees Homes CR Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (343.00) (8,232.00) ** (18,522.00) Budgeted (10,290.00) Remaining 44 o Used Account: 135-49141-000-000 Interfund Transfer In 44 of 127 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 9 15:24 08/14/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) (25,000.00) .00 (25,000.00) Account: 135-49141-000-000 Interfund Transfer In Totals: .00 (25,000.00) ** .00 Budgeted 25,000.00 Remaining 0 % Used Account: 135-49900-000-000 Miscellaneous Income 1800 07/31/2019 UB 07/31/2019 Billing UB20190731-20190731 User: (32,059.11) (324.16) (32,383.27) UB Account: 135-49900-000-000 Miscellaneous Income Totals: (324.16) (32,383.27) ** (7,000.00) Budgeted 25,383.27 Remaining 463 % Used Account: 135-49901-000-000 Records Management Revenue Account: 135-49901-000-000 Department Totals: (4.00) Records Management Revenue Totals: .00 Budgeted (920,263.02) Monthly Total 4.00 Remaining 0 % Used .00 .00 (4.00) (4.00) ** (6,871,797.98) ** (11,343,415.00) Budgeted (4,471,617.02) Remaining 61 % Used 45 of 127 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 15:24 08/14/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-010-000 1653 07/12/2019 MUD P/R 07.12.19 1747 07/26/2019 MUD Payroll 07/26/2019 Account: 135-50005-010-000 Salaries & Wages Salaries & Wages Salaries & Wages 222,045.52 11,943.27 11,943.07 233,988.79 PR 245,931.86 PR Salaries & Wages Totals: 23,886.34 245,931.86 ** 326,755.00 Budgeted Account: 135-50010-010-000 Overtime 1653 07/12/2019 MUD P/R 07.12.19 Overtime 1747 07/26/2019 MUD Payroll 07/26/2019 Overtime Account: 135-50010-010-000 80,823.14 Remaining 75 % Used 9,234.27 162.43 9,396.70 PR 533.92 9,930.62 PR Overtime Totals: 696.35 9,930.62 ** 20,000.00 Budgeted Account: 135-50016-010-000 Longevity Account: 135-50016-010-000 Longevity Totals: 3,620.00 Budgeted .00 Remaining 10,069.38 Remaining 50 % Used Account: 135-50017-010-000 Certification 1747 07/26/2019 MUD Payroll 07/26/2019 Certification Account: 135-50017-010-000 3,620.00 100 % Used 1,675.00 Certification Totals: 4,800.00 Budgeted 3,000.00 Remaining 38 % Used Account: 135-50020-010-000 Retirement 1653 07/12/2019 MUD P/R 07.12.19 Retirement 1747 07/26/2019 MUD Payroll 07/26/2019 Retirement 22,934.48 .00 3,620.00 .00 3,620.00 ** 125.00 1,800.00 125.00 1,800.00 ** 1,119.77 24,054.25 1,165.69 25,219.94 PR PR PR Account: 135-50020-010-000 Retirement Totals: 2,285.46 25,219.94 ** 33,304.00 Budgeted Account: 135-50026-010-000 1653 07/12/2019 MUD P/R 07.12.19 1747 07/26/2019 MUD Payroll 07/26/2019 Account: 135-50026-010-000 Medical Insurance Medical Insurance Medical Insurance 8,084.06 Remaining 76 % Used 34,164.48 2,109.86 36,274.34 2,109.82 38,384.16 Medical Insurance Totals: 4,219.68 38,384.16 ** 74,818.00 Budgeted 36,433.84 Remaining 51 % Used 46 of 127 PR PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11 15:24 08/14/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-010-000 1653 07/12/2019 MUD P/R 07.12.19 1747 07/26/2019 MUD Payroll 07/26/2019 Account: 135-50027-010-000 Account: 135-50028-010-000 1653 07/12/2019 MUD P/R 07.12.19 1747 07/26/2019 MUD Payroll 07/26/2019 Dental Insurance Dental Insurance Dental Insurance Dental Insurance Totals: 4,317.00 Budgeted Vision Insurance Vision Insurance Vision Insurance 2,210.25 130.80 2,341.05 PR 130.75 2,471.80 PR 1,845.20 Remaining 57 % Used 2,471.80 ** 362.58 21.25 383.83 PR 21.22 405.05 PR Account: 135-50028-010-000 Vision Insurance Totals: 42.47 405.05 ** Account: 135-50029-010-000 1600 07/01/2019 July A/P 1600 07/01/2019 July A/P 1763 07/25/2019 July A/P 701.00 Budgeted 295.95 Remaining 58 % Used Life Insurance & Other Employee LTD & STD -July Employee Benefits -July Caf 125 1,924.79 91.11 2,015.90 METLIFE GROUP BENEFITS 98.56 2,114.46 Humana Inc 20.00 2,134.46 BenefitMall 5434 AP 5427 AP 5538 AP Account: 135-50029-010-000 Life Insurance & Other Totals: 209.67 2 Account: 135-50030-010-000 1653 07/12/2019 MUD P/R 07.12.19 1747 07/26/2019 MUD Payroll 07/26/2019 Account: 135-50030-010-000 3,131.00 Budgeted 996.54 Remaining 68 % Used Social Security Taxes Social Security Taxes Social Security Taxes Social Security Taxes Totals: 22,021.00 Budgeted Account: 135-50035-010-000 1653 07/12/2019 MUD P/R 07.12.19 1747 07/26/2019 MUD Payroll 07/26/2019 Medicare Taxes Medicare Taxes Medicare Taxes 14,277.38 6,251.77 Remaining 72 % Used 3,339.06 744.50 747.35 1,491.85 15,021.88 15,769.23 15,769.23 ** 174.11 3,513.17 174.80 3,687.97 PR PR PR PR Account: 135-50035-010-000 Medicare Taxes Totals: 348.91 3,687.97 ** 5,150.00 Budgeted 1,462.03 Remaining 72 % Used Account: 135-50040-010-000 Unemployment Taxes 46.80 47 of 127 .00 46.80 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 12 15:24 08/14/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50040-010-000 Unemployment Taxes Totals: 1,080.00 Budgeted 1,033.20 Remaining 4 % Used Account: 135-50045-010-000 Workman's Compensation 134 07/01/2019 Insurance/Wrk Comp Expense Jul 8,107.86 Account: 135-50045-010-000 Workman's Compensation Totals: 12,895.00 Budgeted Account: 135-50060-010-000 Pre-emp Physicals/Testing Account: 135-50060-010-000 Account: 135-50070-010-000 Account: 135-50070-010-000 3,856.20 Remaining 70 % Used 202.45 Pre-emp Physicals/Testing Totals: 200.00 Budgeted (2.45) Remaining 101 % Used Employee Relations Employee Relations Totals: 300.00 Budgeted Account: 135-55005-010-000 Engineering Account: 135-55005-010-000 300.00 Remaining 0 % Used Engineering Totals: 20,000.00 Budgeted 20,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 1724 07/18/2019 July A/p meter boxes 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 Sharkbite adapters & end stop 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 Tank lever 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 Sharkbite pvc adapter Account: 135-55080-010-000 Maintenance & Repairs Totals: 153,000.00 Budgeted .00 46.80 ** 930.94 9,038.80 GL 930.94 9,038.80 ** .00 202.45 .00 202.45 ** .00 .00 .00 .00 ** .00 .00 .00 .00 ** 108,008.42 3,432.48 111,440.90 Core & Main LP 5515 AP 53.18 111,494.08 THE HOME DEPOT #6581 PC 18.95 111,513.03 THE HOME DEPOT #6581 PC 22.48 111,535.51 THE HOME DEPOT #6581 PC 41,464.49 Remaining 73 % Used Account: 135-55085-010-000 Generator Maint. and Repair 48 of 127 3,527.09 111,535.51 ** glpdatb2 skrolczyk Trophy Club MUD No.1 Page 13 15:24 08/14/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1,906.30 .00 1,906.30 Account: 135-55085-010-000 Generator Maint. and Repair Totals: .00 1,906.30 ** 3,000.00 Budgeted 1,093.70 Remaining Account: 135-55090-010-000 Vehicle Maintenance 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 Crash Report Account: 135-55090-010-000 Vehicle Maintenance Totals: 5,000.00 Budgeted 64 % Used 3,202.10 8.44 3,210.54 TXDOT CRASH REPORT 8.44 3,210.54 ** 1,789.46 Remaining 64 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Account: 135-55105-010-000 Account: 135-55120-010-000 Account: 135-55120-010-000 Account: 135-55135-010-000 1778 07/29/2019 July A/P Account: 135-55135-010-000 Account: 135-60010-010-000 1724 07/18/2019 July A/p Account: 135-60010-010-000 Maintenance-Backhoe/SkidLoader Totals: 3,500.00 Budgeted 3,500.00 Remaining Cleaning Services Cleaning Services Totals: 5,214.00 Budgeted Lab Analysis TCEQ samples 5,214.00 Remaining Lab Analysis Totals: 6,500.00 Budgeted Communications/Mobiles Cell phones-july (676.62) Remaining Communications/Mobiles Totals: 5,000.00 Budgeted .00 .00 .00 .00 ** 0 % Used .00 .00 .00 .00 ** 0 8 Used 6,897.27 279.35 7,176.62 DSHS Central Lab MC2004 279.35 7,176.62 ** 110 % Used PC 5542 AP 2,857.77 237.69 3,095.46 VERIZON WIRELESS 5531 AP 1,904.54 Remaining 62 8 Used Account: 135-60020-010-000 Electricity 1724 07/18/2019 July A/p Electricity 6/10-7/10 237.69 3,095.46 ** 75,686.85 10,458.80 49 of 127 86,145.65 HUDSON ENERGY SERVICES, LLC 5520 AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 14 15:24 08/14/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60020-010-000 Electricity Totals: 10,458.80 86,145.65 ** 154,204.00 Budgeted 68,058.35 Remaining 56 % Used Account: 135-60066-010-000 Publications/Books/Subscripts 790.00 .00 790.00 Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 790.00 ** 1,000.00 Budgeted 210.00 Remaining 79 8 Used Account: 135-60070-010-000 Dues & Memberships 122.00 .00 122.00 Account: 135-60070-010-000 Dues & Memberships Totals: .00 122.00 ** 500.00 Budgeted 378.00 Remaining 24 % Used Account: 135-60080-010-000 Schools & Training 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 Water operator license 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 overcharged reg for mike 3,595.01 111.00 3,706.01 TCEQ EPAYMENT PC (150.00) 3,556.01 WEF REG PC Account: 135-60080-010-000 Schools & Training Totals: (39.00) 3,556.01 ** 4,651.00 Budgeted 1,094.99 Remaining 76 % Used Account: 135-60090-010-000 Safety Program Account: 135-60090-010-000 Safety Program 400.00 Budgeted Account: 135-60100-010-000 Travel & per diem Account: 135-60100-010-000 Travel & per diem 2,345.00 Budgeted Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 Totals: 400.00 Remaining 0 % Used .00 .00 ** 678.98 .00 678.98 Totals: 1,666.02 Remaining 29 8 Used .00 678.98 ** 50 of 127 .00 .00 glpdatb2 skrolczyk 15:24 08/14/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Period Ending: 7/2019 JE Detail Beginning Balance Description/Comment Program: Page 15 August 19, 2019 Regular Meeting Agenda Packet Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Check Source Number 51 of 127 Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 16,336.53 .00 16,336.53 Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 16,336.53 ** 58,000.00 Budgeted 41,663.47 Remaining 28 % Used Account: 135-60150-010-000 Wholesale Water 1849 07/31/2019 July A/p fort worth water 1,000,822.45 199,622.35 1,200,444.80 CITY OF FORT WORTH 5591 AP Account: 135-60150-010-000 Wholesale Water Totals: 199,622.35 1,200,444.80 ** 3,013,494.00 Budgeted 1,813,049.20 Remaining 40 % Used Account: 135-60245-010-000 Miscellaneous Expenses .00 .00 Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 8 Used Account: 135-60280-010-000 Property Maintenance 612.00 .00 612.00 Account: 135-60280-010-000 Property Maintenance Totals: .00 612.00 ** 3,000.00 Budgeted 2,388.00 Remaining 20 9 Used Account: 135-60285-010-000 Lawn Equipment & Maintenance 1777 07/29/2019 JULY a/p Mowinf-July 5,090.00 1,500.00 6,590.00 WATTS ELLISON LLC 5559 AP Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: 1,500.00 6,590.00 ** 14,750.00 Budgeted 8,160.00 Remaining 45 5 Used Account: 135-60332-010-000 Interfund Transfer Out -Rev I&S 1797 07/31/2019 TexPool Transfers July TexPool O&M to 16Swift Rev I&S 226,555.29 25,172.81 251,728.10 GL 51 of 127 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16 15:24 08/14/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60332-010-000 Interfund Transfer Out -Rev I&S Totals: 585,209.00 Budgeted 333,480.90 Remaining Account: 135-60333-010-000 Interfund Transfer Out -Reserve 1797 07/31/2019 TexPool Transfers July TexPool O&M to Rev Bond Resevr Account: 135-60333-010-000 Interfund Transfer Out -Reserve Totals: 55,193.00 Budgeted 9,193.00 Remaining Account: 135-60334-010-000 Interfund Transfer Out Account: 135-60334-010-000 Account: 135-60360-010-000 25,172.81 251,728.10 ** 43 % Used 41,400.00 4,600.00 46,000.00 GL 83 5 Used 4,600.00 46,000.00 ** .00 .00 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining Furniture/Equipment < $5000 Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: 2,500.00 Budgeted 2,500.00 Remaining 0 o Used 0 % Used .00 .00 .00 .00 ** Account: 135-65005-010-000 Fuel & Lube 1764 07/24/2019 Fuel Fuel -June 7,652.37 913.65 8,566.02 US Bank Voyager Fleet Systems 5557 AP Account: 135-65005-010-000 Fuel & Lube Totals: 15,000.00 Budgeted Account: 135-65010-010-000 Uniforms Account: 135-65010-010-000 6,433.98 Remaining 57 6 Used 2,070.81 913.65 8,566.02 ** .00 2,070.81 Uniforms Totals: .00 2,070.81 ** 5,190.00 Budgeted Account: 135-65030-010-000 Chemicals 1763 07/25/2019 July A/P chlorine 1777 07/29/2019 JULY a/p testing supplies 3,119.19 Remaining 40 % Used 16,024.34 52 of 127 558.41 16,582.75 DPC INDUSTRIES, INC 5541 AP 1,666.88 18,249.63 HACH COMPANY 5544 AP glpdatb2 skrolczyk 15:24 08/14/19 Fund: 135 MUD 1 General Fund JE Number JE Date JE Description 1849 07/31/2019 July A/p 1849 07/31/2019 July A/p Account: 135-65030-010-000 Account: 135-65035-010-000 Account: 135-65035-010-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Period Ending: 7/2019 JE Detail Beginning Balance Description/Comment testing supplies testing supplies Chemicals Totals: 20,000.00 Budgeted 1,445.12 Remaining Small Tools Small Tools Totals: Account: 135-65040-010-000 Account: 135-65040-010-000 Account: 135-65050-010-000 1,200.00 Budgeted Safety Equipment Safety Equipment 1,000.00 Budgeted Meter Expense 1,200.00 Remaining Totals: 358.75 Remaining 16,024.34 641.25 17,861.60 93 % Used Program: Transaction Detail 216.00 89.25 2,530.54 .00 0 % Used .00 .00 64 % Used .00 .00 Page 17 August 19, 2019 Regular Meeting Agenda Packet Transaction Vendor_Name Detail (SUBTOTAL) Account: 135-65050-010-000 Meter Expense Totals: .00 Account: 135-65053-010-000 Account: 135-65053-010-000 Account: 135-69005-010-000 1724 07/18/2019 July A/p 1731 07/19/2019 July A/P 1849 07/31/2019 July A/p 1849 07/31/2019 July A/p 70,000.00 Budgeted Meter Change Out Program Meter Change Out Program 87,000.00 Budgeted 52,138.40 Remaining Totals: 51.00 Remaining Capital Outlays VFD upgrade water line replacement-Straigh Straight Creek & carnoustie dr VFD upgrade 26 % Used 86,949.00 100 % Used 542,593.20 .00 .00 18,465.63 HACH COMPANY 18,554.88 HACH COMPANY 18,554.88 ** .00 .00 ** 641.25 641.25 ** 17,861.60 17,861.60 ** 86,949.00 86,949.00 ** 1,059.72 543,652.92 74,906.00 618,558.92 4,820.49 623,379.41 1,124.49 624,503.90 Account: 135-69005-010-000 Capital Outlays Totals: 81,910.70 719,613.00 Budgeted 95,109.10 Remaining 87 % Used 53 of 127 CP&Y/WALLACE GROUP, INC. REY-MAR CONSTRUCTION Halff Associates, INC CP&Y/WALLACE GROUP, INC. 624,50310 ** Check Source Number 5598 AP 5598 AP 5516 5534 5597 5592 AP AP AP AP glpdatb2 skrolczyk Trophy Club MUD No.1 Page 18 15:24 08/14/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69008-010-000 Short Term Debt -Principal Account: 135-69008-010-000 30,068.00 .00 30,068.00 Short Term Debt -Principal Totals: .00 30,068.00 ** 30,068.00 Budgeted .00 Remaining 100 % Used Account: 135-69009-010-000 Short Term Debt -Interest 2,283.93 .00 2,283.93 Account: 135-69009-010-000 Short Term Debt -Interest Totals: .00 2,283.93 ** 4,124.00 Budgeted 1,840.07 Remaining 55 % Used Account: 135-69195-010-000 Account: 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 .00 75,000.00 Gasb34/Reserve for Replacement Totals: .00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 99,877.11 .00 99,877.11 Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 99,877.11 ** 120,000.00 Budgeted 20,122.89 Remaining 83 % Used 54 of 127 glpdatb2 skrolczyk 15:24 08/14/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Department: 10 Water JE Detail Description/Comment Trophy Club MUD No.1 Page 19 Detailed Accounting Trial Balance Program: 1 Lab Analysis for PID August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 135-55135-010-001 Lab Analysis for PID Account: 135-55135-010-001 1,351.59 .00 1,351.59 Lab Analysis for PID Totals: .00 1,351.59 ** 2,000.00 Budgeted 648.41 Remaining 68 6 Used Department 10 Totals: 3,066,299.73 ** 365,220.64 Monthly Total 5,961,447.00 Budgeted 2,895,147.27 Remaining 51 % Used 55 of 127 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 15:24 08/14/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-020-000 1653 07/12/2019 MUD P/R 07.12.19 1747 07/26/2019 MUD Payroll 07/26/2019 Account: 135-50005-020-000 Salaries & Wages Salaries & Wages Salaries & Wages 252,713.21 13,576.20 266,289.41 PR 13,405.16 279,694.57 PR Salaries & Wages Totals: 26,981.36 279,694.57 ** 421,699.00 Budgeted Account: 135-50010-020-000 Overtime 1653 07/12/2019 MUD P/R 07.12.19 Overtime 1747 07/26/2019 MUD Payroll 07/26/2019 Overtime 142,004.43 Remaining 66 % Used 26,965.27 1,314.29 28,279.56 PR 1,322.67 29,602.23 PR Account: 135-50010-020-000 Overtime Totals: 2,636.96 29,602.23 ** 30,000.00 Budgeted Account: 135-50016-020-000 Longevity Account: 135-50016-020-000 Longevity Totals: 7,445.00 Budgeted .00 Remaining 397.77 Remaining 99 % Used Account: 135-50017-020-000 Certification 1747 07/26/2019 MUD Payroll 07/26/2019 Certification Account: 135-50017-020-000 7,445.00 .00 7,445.00 .00 100 % Used 6,400.00 725.00 7,125.00 PR Certification Totals: 8,700.00 Budgeted 1,575.00 Remaining 82 % Used Account: 135-50020-020-000 Retirement 1653 07/12/2019 MUD P/R 07.12.19 Retirement 1747 07/26/2019 MUD Payroll 07/26/2019 Retirement 28,667.62 725.00 7,125.00 ** 1,377.37 30,044.99 1,429.37 31,474.36 PR PR Account: 135-50020-020-000 Retirement Totals: 2,806.74 31,474.36 ** 43,276.00 Budgeted Account: 135-50026-020-000 1653 07/12/2019 MUD P/R 07.12.19 1747 07/26/2019 MUD Payroll 07/26/2019 Account: 135-50026-020-000 Medical Insurance Medical Insurance Medical Insurance 11,801.64 Remaining 73 % Used 49,471.86 2,794.26 52,266.12 2,794.22 55,060.34 Medical Insurance Totals: 5,588.48 55,060.34 ** 91,627.00 Budgeted 36,566.66 Remaining 60 % Used 56 of 127 PR PR glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 15:24 08/14/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-020-000 1653 07/12/2019 MUD P/R 07.12.19 1747 07/26/2019 MUD Payroll 07/26/2019 Account: 135-50027-020-000 Account: 135-50028-020-000 1653 07/12/2019 MUD P/R 07.12.19 1747 07/26/2019 MUD Payroll 07/26/2019 Dental Insurance Dental Insurance Dental Insurance 3,159.03 170.29 3,329.32 PR 170.27 3,499.59 PR Dental Insurance Totals: 340.56 3,499.59 ** 5,104.00 Budgeted Vision Insurance Vision Insurance Vision Insurance 1,604.41 Remaining 69 % Used 510.54 27.83 538.37 PR 27.81 566.18 PR Account: 135-50028-020-000 Vision Insurance Totals: 55.64 566.18 ** Account: 135-50029-020-000 1600 07/01/2019 July A/P 1600 07/01/2019 July A/P 1763 07/25/2019 July A/P 826.00 Budgeted 259.82 Remaining 69 % Used Life Insurance & Other Employee LTD & STD -July Employee Benefits -July Caf 125 2,907.21 162.14 3,069.35 METLIFE GROUP BENEFITS 184.80 3,254.15 Humana Inc 38.00 3,292.15 BenefitMall 5434 AP 5427 AP 5538 AP Account: 135-50029-020-000 Life Insurance 6 Other Totals: 384.94 3,292.15 ** Account: 135-50030-020-000 1653 07/12/2019 MUD P/R 07.12.19 1747 07/26/2019 MUD Payroll 07/26/2019 Account: 135-50030-020-000 4,495.00 Budgeted 1,202.85 Remaining 73 % Used Social Security Taxes Social Security Taxes Social Security Taxes Social Security Taxes Totals: 29,006.00 Budgeted Account: 135-50035-020-000 1653 07/12/2019 MUD P/R 07.12.19 1747 07/26/2019 MUD Payroll 07/26/2019 Medicare Taxes Medicare Taxes Medicare Taxes 17,178.10 10,051.11 Remaining 65 % Used 4,017.46 884.96 891.83 1,776.79 18,063.06 18,954.89 18,954.89 ** 206.98 4,224.44 208.57 4,433.01 PR PR PR PR Account: 135-50035-020-000 Medicare Taxes Totals: 415.55 4,433.01 ** 6,784.00 Budgeted 2,350.99 Remaining 65 % Used Account: 135-50040-020-000 Unemployment Taxes 54.00 57 of 127 .00 54.00 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22 15:24 08/14/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50040-020-000 Unemployment Taxes Totals: 1,260.00 Budgeted 1,206.00 Remaining 4 % Used Account: 135-50045-020-000 Workman's Compensation 134 07/01/2019 Insurance/Wrk Comp Expense Jul 10,501.77 Account: 135-50045-020-000 Workman's Compensation Totals: 16,941.00 Budgeted Account: 135-50060-020-000 Pre-emp Physicals/Testing Account: 135-50060-020-000 Account: 135-50070-020-000 Account: 135-50070-020-000 5,233.50 Remaining 69 % Used Pre-emp Physicals/Testing Totals: 400.00 Budgeted 286.00 Remaining Employee Relations Employee Relations Totals: 300.00 Budgeted Account: 135-55005-020-000 Engineering Account: 135-55005-020-000 114.00 29 5 Used 75.74 224.26 Remaining 25 % Used Engineering Totals: 30,000.00 Budgeted Account: 135-55070-020-000 Independent Labor Account: 135-55070-020-000 Account: 135-55080-020-000 1724 07/18/2019 July A/p 1724 07/18/2019 July A/p 30,000.00 Remaining 0 5 Used Independent Labor Totals: 15,000.00 Budgeted 2,921.00 12,079.00 Remaining 19 % Used Maintenance & Repairs Parts for BCR screen Bags for grit .00 54.00 ** 1,205.73 1,205.73 .00 .00 11,707.50 11,707.50 ** 114.00 114.00 ** .00 75.74 .00 75.74 ** .00 .00 .00 .00 ** .00 2,921.00 .00 2,921.00 ** 99,552.85 5,820.99 1,065.00 58 of 127 GL 105,373.84 Huber Technology Inc 5519 AP 106,438.84 Huber Technology Inc 5519 AP glpdatb2 skrolczyk 15:24 08/14/19 Fund: 135 MUD 1 General Fund JE Number 1804 1804 1804 1804 1804 1804 1804 1804 1804 1849 JE Date 07/26/2019 07/26/2019 07/26/2019 07/26/2019 07/26/2019 07/26/2019 07/26/2019 07/26/2019 07/26/2019 07/31/2019 JE Description Pcard 06/27/19 Pcard 06/27/19 Pcard 06/27/19 Pcard 06/27/19 Pcard 06/27/19 Pcard 06/27/19 Pcard 06/27/19 Pcard 06/27/19 Pcard 06/27/19 July A/p - 07/26/19 - 07/26/19 - 07/26/19 - 07/26/19 - 07/26/19 - 07/26/19 - 07/26/19 - 07/26/19 - 07/26/19 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 7/2019 JE Detail Beginning Balance Description/Comment Belts hose adapter, wrench,valve,etc Sprayers & weed&grass killer 4x8, stud rain gauge, gloss paint thread, concrete bucket, trowel, sponge, concrete regal service tool pvc, freight, coupling, cement UV-repairs/maint 99,552.85 Program: Transaction Detail 635.91 235.06 63.91 23.88 18.90 23.04 56.41 29.91 70.87 2,645.00 Page 23 August 19, 2019 Regular Meeting Agenda Packet Transaction Vendor_Name Detail (SUBTOTAL) 107,074.75 107,309.81 107,373.72 107,397.60 107,416.50 107,439.54 107,495.95 107,525.86 107,596.73 110,241.73 ROANOKE AUTO SUPPLY LT ROANOKE WINNELSON CO THE HOME THE HOME THE HOME THE HOME THE HOME DEPOT #6581 DEPOT #6581 DEPOT #6581 DEPOT #6581 DEPOT #6581 ROANOKE WINNELSON CO ROANOKE WINNELSON CO NEWMAN REGENCY GROUP, INC Check Source Number PC PC PC PC PC PC PC PC PC 5603 AP Account: 135-55080-020-000 Maintenance & Repairs Totals: 10,688.88 110,241.73 ** 133,000.00 Budgeted 22,758.27 Remaining 83 % Used Account: 135-55085-020-000 Generator Maint. and Repair 1763 07/25/2019 July A/P LS #1 generator 4,881.63 570.00 5,451.63 Sluder Emergency Power Service 5554 AP Account: 135-55085-020-000 Generator Maint. and Repair Totals: 570.00 5,451.63 ** 10,000.00 Budgeted 4,548.37 Remaining 55 % Used Account: 135-55090-020-000 Vehicle Maintenance 1804 07/26/2019 Pcard 06/27/19 1804 07/26/2019 Pcard 06/27/19 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 ww crane truck - 07/26/19 fee for ww crane truck renewal - 07/26/19 safety inspection 1,676.24 7.50 2.00 7.00 1,683.74 1,685.74 1,692.74 DENTON VEHREG TX.GOV*SERVICEFEE-DIR KWIK KAR LUBE & TUNE 0 PC PC PC Account: 135-55090-020-000 Vehicle Maintenance Totals: 16.50 1,692.74 ** 8,000.00 Budgeted 6,307.26 Remaining 21 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 6,803.00 .00 6,803.00 Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 6,803.00 ** 7,000.00 Budgeted 197.00 Remaining 97 % Used Account: 135-55120-020-000 Cleaning Services .00 .00 Account: 135-55120-020-000 Cleaning Services Totals: .00 .00 ** 5,214.00 Budgeted 5,214.00 Remaining 0 % Used 59 of 127 glpdatb2 skrolczyk 15:24 08/14/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 7/2019 JE Detail Beginning Balance Description/Comment Program: Page 24 August 19, 2019 Regular Meeting Agenda Packet Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Check Source Number 1724 07/18/2019 July A/p 1724 07/18/2019 July A/p 1724 07/18/2019 July A/p 1724 07/18/2019 July A/p 1724 07/18/2019 July A/p 1763 07/25/2019 July A/P 1763 07/25/2019 July A/P 1777 07/29/2019 JULY a/p 1777 07/29/2019 JULY a/p 1849 07/31/2019 July A/p 1849 07/31/2019 July A/p lab testing lab testing lab testing lab testing lab testing lab supplies lab supplies lab testing lab testing lab testing lab testing 230.00 317.40 230.00 317.40 230.00 1,703.47 319.49 230.00 317.40 317.40 230.00 23,656.65 OXIDOR LABORATORIES LLC 23,974.05 OXIDOR LABORATORIES LLC 24,204.05 OXIDOR LABORATORIES LLC 24,521.45 OXIDOR LABORATORIES LLC 24,751.45 OXIDOR LABORATORIES LLC 26,454.92 IDEXX DISTRIBUTION, INC 26,774.41 IDEXX DISTRIBUTION, INC 27,004.41 OXIDOR LABORATORIES LLC 27,321.81 OXIDOR LABORATORIES LLC 27,639.21 OXIDOR LABORATORIES LLC 27,869.21 OXIDOR LABORATORIES LLC 5528 AP 5528 AP 5528 AP 5528 AP 5528 AP 5546 AP 5546 AP 5553 AP 5553 AP 5605 AP 5605 AP Account: 135-55135-020-000 Lab Analysis Totals: 4,759.96 27,869.21 ** 35,000.00 Budgeted 7,130.79 Remaining 80 % Used Account: 135-55125-020-000 Dumpster Services Account: 135-60010-020-000 Communications/Mobiles 1724 07/18/2019 July A/p 1763 07/25/2019 July A/P 1779 07/29/2019 July A/P sludge haul off sludge haul off sludge haul off 57,045.55 845.00 845.00 884.29 57,890.55 58,735.55 59,619.84 L.H. CHANEY MATERIALS, L.H. CHANEY MATERIALS, L.H. CHANEY MATERIALS, INC. INC. INC. 5523 5550 5550 AP AP AP Account: 135-55125-020-000 Dumpster Services Totals: 4,182.20 ** 2,574.29 59,619.84 ** 5,000.00 Budgeted 817.80 Remaining 84 % Used 75,000.00 Budgeted 15,380.16 Remaining 79 % Used Account: 135-60020-020-000 Electricity Account: 135-55135-020-000 Lab Analysis 1724 07/18/2019 July A/p Electricity 6/10-7/10 111,326.36 1862 07/31/2019 Town Billed Invoices 1698-1701 AR 20190731-20190731 User: 11,482.13 (183.51) 122,808.49 122,624.98 HUDSON ENERGY SERVICES, LLC 5520 AP AR Account: 1724 07/18/2019 July A/p lab testing 11,298.62 23,109.25 ** 317.40 23,426.65 OXIDOR LABORATORIES LLC 5528 AP 1724 07/18/2019 July A/p 1724 07/18/2019 July A/p 1724 07/18/2019 July A/p 1724 07/18/2019 July A/p 1724 07/18/2019 July A/p 1763 07/25/2019 July A/P 1763 07/25/2019 July A/P 1777 07/29/2019 JULY a/p 1777 07/29/2019 JULY a/p 1849 07/31/2019 July A/p 1849 07/31/2019 July A/p lab testing lab testing lab testing lab testing lab testing lab supplies lab supplies lab testing lab testing lab testing lab testing 230.00 317.40 230.00 317.40 230.00 1,703.47 319.49 230.00 317.40 317.40 230.00 23,656.65 OXIDOR LABORATORIES LLC 23,974.05 OXIDOR LABORATORIES LLC 24,204.05 OXIDOR LABORATORIES LLC 24,521.45 OXIDOR LABORATORIES LLC 24,751.45 OXIDOR LABORATORIES LLC 26,454.92 IDEXX DISTRIBUTION, INC 26,774.41 IDEXX DISTRIBUTION, INC 27,004.41 OXIDOR LABORATORIES LLC 27,321.81 OXIDOR LABORATORIES LLC 27,639.21 OXIDOR LABORATORIES LLC 27,869.21 OXIDOR LABORATORIES LLC 5528 AP 5528 AP 5528 AP 5528 AP 5528 AP 5546 AP 5546 AP 5553 AP 5553 AP 5605 AP 5605 AP Account: 135-55135-020-000 Lab Analysis Totals: 4,759.96 27,869.21 ** 35,000.00 Budgeted 7,130.79 Remaining 80 % Used Account: 135-60010-020-000 Communications/Mobiles 1724 07/18/2019 July A/p Cell phones-july 3,809.94 372.26 4,182.20 VERIZON WIRELESS 5531 AP Account: 135-60010-020-000 Communications/Mobiles Totals: 372.26 4,182.20 ** 5,000.00 Budgeted 817.80 Remaining 84 % Used Account: 135-60020-020-000 Electricity 1724 07/18/2019 July A/p Electricity 6/10-7/10 111,326.36 1862 07/31/2019 Town Billed Invoices 1698-1701 AR 20190731-20190731 User: 11,482.13 (183.51) 122,808.49 122,624.98 HUDSON ENERGY SERVICES, LLC 5520 AP AR Account: 135-60020-020-000 Electricity Totals: 11,298.62 122,624.98 ** 174,165.00 Budgeted 51,540.02 Remaining 70 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 60 of 127 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 15:24 08/14/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** Account: 135-60070-020-000 Account: 135-60070-020-000 200.00 Budgeted 200.00 Remaining Dues & Memberships 191.00 0 % Used .00 191.00 Dues & Memberships Totals: .00 191.00 ** 300.00 Budgeted 109.00 Remaining 64 % Used Account: 135-60080-020-000 Schools & Training 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 Overcharged reg for Frank I Account: 135-60080-020-000 1,808.23 (150.00) 1,658.23 WEF REG PC Schools & Training Totals: (150.00) 1,658.23 ** 7,155.00 Budgeted Account: 135-60090-020-000 Safety Program Account: 135-60090-020-000 5,496.77 Remaining 23 % Used 100.74 .00 100.74 Safety Program Totals: .00 100.74 ** 1,000.00 Budgeted Account: 135-60100-020-000 Travel & per diem Account: 135-60100-020-000 899.26 Remaining 10 % Used 544.55 .00 544.55 Travel & per diem Totals: .00 544.55 ** 1,895.00 Budgeted Account: 135-60105-020-000 Rent/Lease Equipment Account: 135-60105-020-000 1,350.45 Remaining 29 % Used 3,491.07 .00 3,491.07 Rent/Lease Equipment Totals: .00 3,491.07 ** 5,000.00 Budgeted Account: 135-60125-020-000 Advertising 1,508.93 Remaining 70 % Used 61 of 127 .00 .00 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 15:24 08/14/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60125-020-000 Advertising Totals: 2,500.00 Budgeted Account: 135-60135-020-000 TCEQ Fees & Permits Account: 135-60135-020-000 2,500.00 Remaining 0 % Used TCEQ Fees & Permits Totals: 30,000.00 Budgeted 16,545.22 13,454.78 Remaining 55 % Used Account: 135-60245-020-000 Miscellaneous Expenses 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 newspaper for document of RFP Account: 135-60245-020-000 Account: 135-60280-020-000 Account: 135-60280-020-000 Miscellaneous Expenses 450.00 Budgeted Property Maintenance Property Maintenance 5,000.00 Budgeted Totals: 446.00 Remaining 1 % Used 225.18 Totals: 4,774.82 Remaining 5 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 1777 07/29/2019 JULY a/p Mowinf-July 4,159.47 Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 11,600.00 Budgeted 5,960.53 Remaining Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S 1797 07/31/2019 TexPool Transfers July TexPool O&M to I&S- PID Debt Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S Totals: 120,053.00 Budgeted 10,914.00 Remaining Account: 135-60332-020-000 Interfund Transfer Out -Rev I&S 1797 07/31/2019 TexPool Transfers July TexPool O&M to Rev Bd WWTP I&S 49 % Used .00 .00 ** .00 16,545.22 .00 16,545.22 ** 4.00 4.00 TOM THUMB #2580 4.00 4.00 ** .00 225.18 .00 225.18 ** PC 1,480.00 5,639.47 WATTS ELLISON LLC 5559 AP 1,480.00 5,639.47 ** 98,225.10 10,913.90 109,139.00 GL 10,913.90 109,139.00 ** 91 6 Used 487,831.05 54,203.45 542,034.50 GL 62 of 127 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 15:24 08/14/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60332-020-000 Interfund Transfer Out -Rev I&S Totals: 688,330.00 Budgeted 146,295.50 Remaining Account: 135-60333-020-000 Interfund Transfer Out -Reserve 1797 07/31/2019 TexPool Transfers July TexPool O&M to Rev Bond Resevr Account: 135-60333-020-000 Interfund Transfer Out -Reserve Totals: 125,187.00 Budgeted 20,867.00 Remaining Account: 135-60334-020-000 Interfund Transfer Out Account: 135-60334-020-000 54,203.45 542,034.50 ** 79 % Used 93,888.00 10,432.00 104,320.00 GL 83 % Used 10,432.00 104,320.00 ** .00 Interfund Transfer Out Totals: .00 200,000.00 Budgeted 200,000.00 Remaining 0 o Used .00 .00 ** Account: 135-60360-020-000 Furniture/Equipment < $5000 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 furniture 791.00 791.00 PEARCE OFFICE FURNITUR PC Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: 791.00 791.00 ** 3,500.00 Budgeted 2,709.00 Remaining 23 6 Used Account: 135-65005-020-000 Fuel & Lube 1764 07/24/2019 Fuel Fuel -June 10,159.28 617.08 10,776.36 US Bank Voyager Fleet Systems 5557 AP Account: 135-65005-020-000 Fuel & Lube Totals: 12,500.00 Budgeted Account: 135-65010-020-000 Uniforms Account: 135-65010-020-000 1,723.64 Remaining 86 6 Used 617.08 2,713.30 .00 Uniforms Totals: .00 5,495.00 Budgeted Account: 135-65030-020-000 Chemicals 1777 07/29/2019 JULY a/p sodium hypo 2,781.70 Remaining 49 % Used 10,776.36 ** 2,713.30 2,713.30 ** 29,356.09 569.00 29,925.09 Valley Solvent Company, INC 63 of 127 5558 AP glpdatb2 skrolczyk 15:24 08/14/19 Fund: 135 MUD 1 General Fund JE Number JE JE Date Description Account: 135-65030-020-000 Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 20 Wastewater Period Ending: 7/2019 JE Detail Beginning Balance Description/Comment Chemicals 30,000.00 Budgeted Account: 135-65035-020-000 Small Tools 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 tool set, pliers, saw Account: 135-65035-020-000 Account: 135-65040-020-000 Account: 135-65040-020-000 Account: 135-65045-020-000 1724 07/18/2019 July A/p 1724 07/18/2019 July A/p 1724 07/18/2019 July A/p 1804 07/26/2019 Pcard 06/27/19 1849 07/31/2019 July A/p Account: 135-65045-020-000 Account: 135-69005-020-000 1781 07/30/2019 July A/P 1849 07/31/2019 July A/p Account: 135-69005-020-000 Account: 135-69008-020-000 Account: 135-69008-020-000 Small Tools 1,200.00 Budgeted Safety Equipment Safety Equipment 1,200.00 Budgeted Lab Supplies Lab supplies lab materials lab materials - 07/26/19 distilled water lab supplies Lab Supplies 20,000.00 Budgeted Capital Outlays 6" pump spare parts Capital Outlays Totals: 74.91 Remaining Totals: 195.73 Remaining Totals: (437.69) Remaining Totals: 4,066.16 Remaining Totals: Program: Transaction Detail 100 % Used 774.06 84 % Used 1,637.69 136 5 Used 13,976.94 80 % Used 569.00 230.21 230.21 .00 .00 Page 28 August 19, 2019 Regular Meeting Agenda Packet Transaction Vendor_Name Detail (SUBTOTAL) 29,925.09 ** 1,004.27 THE HOME DEPOT 6581 1,004.27 ** 1,637.69 1,637.69 ** 1,703.47 15,680.41 68.69 15,749.10 11.58 15,760.68 3.96 15,764.64 169.20 15,933.84 1,956.90 IDEXX DISTRIBUTION, INC HD SUPPLY FACILITIES MAINT LTD HD SUPPLY FACILITIES MAINT LTD TOM THUMB #1789 LOU'S GLOVES INCORPORATED 15,933.84 ** Check Source Number PC 5521 AP 5518 AP 5518 AP PC 5600 AP 525,895.71 47,942.93 573,838.64 United Rentals (North America) 5561 AP 7,523.46 581,362.10 NORTH TEXAS PUMP CO. 5604 AP 688,600.00 Budgeted 107,237.90 Remaining Short Term Debt -Principal Short Term Debt -Principal Totals: 109,858.00 Budgeted 69,999.41 Remaining 39,858.59 845 Used 55,466.39 .00 36 o Used 64 of 127 .00 581,362.10 ** 39,858.59 39,858.59 ** glpdatb2 skrolczyk Trophy Club MUD No.1 Page 29 15:24 08/14/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69009-020-000 Short Term Debt -Interest Account: 135-69009-020-000 3,027.55 .00 3,027.55 Short Term Debt -Interest Totals: .00 3,027.55 ** 14,917.00 Budgeted 11,889.45 Remaining 20 5 Used Account: 135-69195-020-000 Account: 135-69195-020-000 Gasb34/Reserve for Replacement 30,000.00 .00 30,000.00 Gasb34/Reserve for Replacement Totals: .00 30,000.00 ** 30,000.00 Budgeted .00 Remaining 100 5 Used Account: 135-70020-020-000 Capital Lease Issuance Cost 1,500.00 .00 1,500.00 Account: 135-70020-020-000 Capital Lease Issuance Cost Totals: .00 1,500.00 ** .00 Budgeted (1,500.00) Remaining 0 % Used Department 20 Totals: 2,296,927.64 ** 209,712.19 Monthly Total 3,281,182.00 Budgeted 65 of 127 984,254.36 Remaining 70 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 15:24 08/14/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-026-000 Workman's Compensation 134 07/01/2019 Insurance/Wrk Comp Expense Jul 19.08 Account: 135-50045-026-000 Workman's Compensation Totals: 30.00 Budgeted Account: 135-60066-026-000 Publications/Books/Subscripts Account: 135-60066-026-000 Publications/Books/Subscripts Totals: 150.00 Budgeted 150.00 Remaining 8.80 Remaining 71 5 Used 2.12 21.20 GL 2.12 21.20 ** .00 0 % Used .00 .00 .00 ** Account: 135-60070-026-000 Dues & Memberships Dues & Memberships 750.00 Budgeted Account: 135-60070-026-000 1 650.00 .00 650.00 Totals: 100.00 Remaining 87 5 Used Account: 135-60075-026-000 Meetings 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 snacks for board meeting Account: 135-60075-026-000 _ Meetings Totals: 1,300.00 Budgeted .00 650.00 ** 47.37 16.97 64.34 TOM THUMB #2580 PC 16.97 64.34 ** 1,235.66 Remaining 5 5 Used Account: 135-60080-026-000 Schools & Training 920.00 .00 920.00 Account: 135-60080-026-000 Schools & Training Totals: .00 920.00 ** 4,000.00 Budgeted 3,080.00 Remaining 23 8 Used Account: 135-60100-026-000 Travel & per diem 800.06 .00 800.06 Account: 135-60100-026-000 Travel & per diem Totals: .00 800.06 ** 5,000.00 Budgeted Account: 135-60245-026-000 Miscellaneous Expenses 4,199.94 Remaining 16 % Used 66 of 127 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 15:24 08/14/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Department 26 Totals: 2,455.60 ** 19.09 Monthly Total 13,230.00 Budgeted 67 of 127 10,774.40 Remaining 19 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 15:24 08/14/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-030-000 1653 07/12/2019 MUD P/R 07.12.19 1747 07/26/2019 MUD Payroll 07/26/2019 Salaries & Wages Salaries & Wages Salaries & Wages 272,617.23 13,620.05 13,841.81 286,237.28 PR 300,079.09 PR Account: 135-50005-030-000 Salaries & Wages Totals: 27,461.86 300,079.09 ** 441,006.00 Budgeted 140,926.91 Remaining 68 % Used Account: 135-50010-030-000 Overtime 57.98 .00 57.98 Account: 135-50010-030-000 Overtime Totals: MINIM .00 57.98 ** 2,000.00 Budgeted 1,942.02 Remaining 3 5 Used Account: 135-50016-030-000 Longevity 1,832.50 .00 1,832.50 Account: 135-50016-030-000 Longevity Totals: 1,832.50 ** 1,833.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000meRetirement 1653 07/12/2019 MUD P/R 07.12.19 Retirement 1747 07/26/2019 MUD Payroll 07/26/2019 Retirement 26,752.16 1,259.87 28,012.03 PR 1,280.35 29,292.38 PR Account: 135-50020-030-000 IM Retirement Totals: 2,540.22 29,292.38 ** 41,148.00 Budgeted Account: 135-50026-030-000 1653 07/12/2019 MUD P/R 07.12.19 1747 07/26/2019 MUD Payroll 07/26/2019 Medical Insurance Medical Insurance Medical Insurance 11,855.62 Remaining 71 % Used 42,930.36 2,561.73 45,492.09 PR 2,561.67 48,053.76 PR Account: 135-50026-030-000 Medical Insurance Totals: 5,123.40 48,053.76 ** 81,895.00 Budgeted Account: 135-50027-030-000 1653 07/12/2019 MUD P/R 07.12.19 1747 07/26/2019 MUD Payroll 07/26/2019 Dental Insurance Dental Insurance Dental Insurance 33,841.24 Remaining 59 % Used 2,473.50 144.93 2,618.43 PR 144.90 2,763.33 PR Account: 135-50027-030-000 Dental Insurance Totals: 289.83 2,763.33 ** 4,291.00 Budgeted 1,527.67 Remaining 64 % Used 68 of 127 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33 15:24 08/14/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50028-030-000 1653 07/12/2019 MUD P/R 07.12.19 1747 07/26/2019 MUD Payroll 07/26/2019 Vision Insurance Vision Insurance Vision Insurance 397.76 22.76 420.52 PR 22.72 443.24 PR Account: 135-50028-030-000 Vision Insurance Totals: 45.48 443.24 ** Account: 135-50029-030-000 1600 07/01/2019 July A/P 1600 07/01/2019 July A/P 1763 07/25/2019 July A/P 701.00 Budgeted 257.76 Remaining 63 % Used Life Insurance & Other Employee LTD & STD -July Employee Benefits -July Caf 125 2,715.02 142.90 2,857.92 METLIFE GROUP BENEFITS 149.52 3,007.44 Humana Inc 20.00 3,027.44 BenefitMall 5434 AP 5427 AP 5538 AP Account: 135-50029-030-000 Life Insurance & Other Totals: 312.42 3,027.44 ** 4,495.00 Budgeted 1,467.56 Remaining 67 % Used Account: 135-50030-030-000 ' Social Security Taxes 1653 07/12/2019 MUD P/R 07.12.19 Social Security Taxes 1747 07/26/2019 MUD Payroll 07/26/2019 Social Security Taxes Account: 135-50030-030-000 ■ Social Security Taxes Totals: 27,580.00 Budgeted Account: 135-50035-030-000 1653 07/12/2019 MUD P/R 07.12.19 1747 07/26/2019 MUD Payroll 07/26/2019 Account: 135-50035-030-000 Account: 135-50040-030-000 Account: 135-50040-030-000 Medicare Taxes Medicare Taxes Medicare Taxes 16,238.05 793.98 17,032.03 804.61 17,836.64 PR PR 1,598.59 17,836.64 ** 9,743.36 Remaining 65 % Used Medicare Taxes Totals: 3,797.61 6,450.00 Budgeted 2,278.51 Remaining 65 5 Used Unemployment Taxes Unemployment Taxes Totals: 1,260.00 Budgeted Account: 135-50045-030-000 Workman's Compensation 134 07/01/2019 Insurance/Wrk Comp Expense Jul 1,200.42 Remaining 59.58 5 5 Used 185.69 188.19 373.88 .00 3,983.30 4,171.49 4,171.49 ** 59.58 .00 59.58 ** PR PR 919.35 106.55 1,025.90 GL 69 of 127 glpdatb2 skrolczyk 15:24 08/14/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 7/2019 JE Detail Beginning Balance Description/Comment Program: Page 34 August 19, 2019 Regular Meeting Agenda Packet Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Check Source Number 1724 07/18/2019 July A/p 1724 07/18/2019 July A/p 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 Microsoft exchange internet-July web domain renewal Internet Internet Internet Adobe Subscription 51,250.99 510.00 51,760.99 M3 Networks 899.00 52,659.99 Charter Communications 39.34 52,699.33 DNH*GODADDY.COM 42.02 52,741.35 ATT*BILL PAYMENT 53.33 52,794.68 ATT*BILL PAYMENT 42.02 52,836.70 ATT*BILL PAYMENT 32.45 52,869.15 ADOBE *ACROPRO SUBS 5524 AP 5514 AP PC PC PC PC PC Account: 135-55030-030-000 ■ Software & Support Totals: 1,618.16 52,869.15 ** Account: 135-50045-030-000 Workman's Compensation Totals: % Used 106.55 1,025.90 ** Account: 135-55070-030-000 1,295.00 Budgeted 269.10 Remaining 79 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 106,248.34 13,240.00 22.89 119,488.34 119,511.23 Carman Consulting LLC. Carman Consulting LLC. 5590 5590 AP AP Account: 135-55070-030-000 Independent Labor Totals: 141.95 13,262.89 .00 141.95 Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: % Used .00 141.95 ** Account: 135-55080-030-000 500.00 Budgeted 358.05 Remaining 28 % Used Account: 135-50070-030-000 Employee Relations 4,975.00 .00 4,975.00 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 desiree flowers 3,038.49 76.80 3,115.29 TLF*GORDON BOSWELL FLO PC Account: 135-50070-030-000 Employee Relations Totals: 76.80 3,115.29 ** 5,000.00 Budgeted 1,884.71 Remaining 62 o Used Account: 135-55030-030-000 Software & Support 1724 07/18/2019 July A/p 1724 07/18/2019 July A/p 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 Microsoft exchange internet-July web domain renewal Internet Internet Internet Adobe Subscription 51,250.99 510.00 51,760.99 M3 Networks 899.00 52,659.99 Charter Communications 39.34 52,699.33 DNH*GODADDY.COM 42.02 52,741.35 ATT*BILL PAYMENT 53.33 52,794.68 ATT*BILL PAYMENT 42.02 52,836.70 ATT*BILL PAYMENT 32.45 52,869.15 ADOBE *ACROPRO SUBS 5524 AP 5514 AP PC PC PC PC PC Account: 135-55030-030-000 ■ Software & Support Totals: 1,618.16 52,869.15 ** 77,849.00 Budgeted 24,979.85 Remaining 68 % Used Account: 135-55070-030-000 Independent Labor 1849 07/31/2019 July A/p 1849 07/31/2019 July A/p GM -July GM -July 106,248.34 13,240.00 22.89 119,488.34 119,511.23 Carman Consulting LLC. Carman Consulting LLC. 5590 5590 AP AP Account: 135-55070-030-000 Independent Labor Totals: 13,262.89 119,511.23 ** 175,000.00 Budgeted 55,488.77 Remaining 68 % Used Account: 135-55080-030-000 Maintenance & Repairs 4,975.00 .00 4,975.00 70 of 127 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 35 15:24 08/14/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55080-030-000 Maintenance & Repairs Totals: .00 4,975.00 ** 20,000.00 Budgeted 15,025.00 Remaining 25 % Used Account: 135-55085-030-000 Generator Maint. and Repair 927.52 .00 Account: 135-55085-030-000 Generator Maint. and Repair Totals: .00 10,000.00 Budgeted 9,072.48 Remaining 9 % Used Account: 135-55120-030-000 Cleaning Services 1724 07/18/2019 July A/p Janitorial svc-June 6,952.48 869.06 Account: 135-55120-030-000 Cleaning Services Totals: 869.06 10,000.00 Budgeted 2,178.46 Remaining 78 % Used Account: 135-55160-030-000 Professional Outside Services 61,926.50 .00 Account: 135-55160-030-000 Professional Outside Services Totals: .00 66,055.00 Budgeted 4,128.50 Remaining 94 % Used Account: 135-55205-030-000 Utility Billing Contract 1849 07/31/2019 July A/p Water billings -July 5,226.43 575.41 Account: 135-55205-030-000 Utility Billing Contract Totals: 9,000.00 Budgeted 3,198.16 Remaining Account: 135-60005-030-000 Telephone 1600 07/01/2019 July A/P Answering service -July 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 Phone 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 Phone 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 Phone 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 Answering Service 1862 07/31/2019 Town Billed Invoices 1698-1701 AR 20190731-20190731 User: Account: 135-60005-030-000 Telephone Totals: 23,500.00 Budgeted 575.41 64 % Used 927.52 927.52 ** 7,821.54 MEMBER'S BUILDING MAINTENANCE 5525 AP 7,821.54 ** 61,926.50 61,926.50 ** 5,801.84 DATAPROSE LLC 5593 AP 5,801.84 ** 13,132.18 207.75 13,339.93 KEYSTONE PARK SECRETARIAL 5431 AP 468.23 13,808.16 ATT*BUS PHONE PMT PC 780.07 14,588.23 ATT*BUS PHONE PMT PC 167.29 14,755.52 ATT*BILL PAYMENT PC 14.99 14,770.51 RINGCENTRAL, INC PC (180.00) 14,590.51 AR 8,909.49 Remaining 62 % Used 71 of 127 1,458.33 14,590.51 ** glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36 15:24 08/14/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60010-030-000 Communications/Mobiles 1724 07/18/2019 July A/p Cell phones-july 1747 07/26/2019 MUD Payroll 07/26/2019 Communications/Mobiles 2,137.47 87.94 2,225.41 VERIZON WIRELESS 5531 AP 150.00 2,375.41 PR Account: 135-60010-030-000 Communications/Mobiles Totals: 237.94 2,375.41 ** 4,000.00 Budgeted 1,624.59 Remaining 59 % Used Account: 135-60020-030-000 Electricity/Gas 1763 07/25/2019 July A/P Electricity 5/9-6/10 Account: 135-60020-030-000 Electricity/Gas 8,690.00 Budgeted 4,811.41 399.06 1 3,479.53 Remaining 60 % Used 5,210.47 TOWN OF TROPHY CLUB 5556 AP 399.06 5,210.47 ** Account: 135-60025-030-000 Water 1849 07/31/2019 July A/p water-july 499.92 118.09 618.01 TROPHY CLUB MUD (WATER BILLS) 5609 AP 1862 07/31/2019 Town Billed Invoices 1698-1701 AR 20190731-20190731 User: (59.04) 558.97 AR Account: 135-60025-030-000 Account: 135-60035-030-000 1777 07/29/2019 JULY a/p 1849 07/31/2019 July A/p Account: 135-60035-030-000 2,000.00 Budgeted Postage lease Totals: 1,441.03 Remaining 28 6 Used 59.05 558.97 ** 16,509.18 102.54 16,611.72 FRANCOTYP-POSTALIA, INC. Water billings -July 1,607.27 30,000.00 Budgeted Totals: 11,781.01 Remaining 61 6 Used 5543 AP 18,218.99 DATAPROSE LLC 5593 AP 1,709.81 18,218.99 ** Account: 135-60040-030-000 Service Charges & Fees 1654 07/12/2019 Child Support Fee 1724 07/18/2019 July A/p 1750 07/26/2019 Child Support Fee 1802 07/31/2019 Pace Credit Card Fees 1802 07/31/2019 Pace Credit Card Fees 1849 07/31/2019 July A/p Dig Tess -July Direct send fees 48,691.49 1.50 48,692.99 GL 50.00 48,742.99 Fisery Solutions, LLC 5517 AP 1.50 48,744.49 GL 4,708.92 53,453.41 GL 99.14 53,552.55 GL 293.55 53,846.10 Texas Excavation Safety System 5607 AP Account: 135-60040-030-000 Service Charges & Fees Totals: 5,154.61 55,560.00 Budgeted 1,713.90 Remaining 97 6 Used Account: 135-60050-030-000 Bad Debt Expense 72 of 127 glpdatb2 skrolczyk 15:24 08/14/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 7/2019 JE Detail Beginning Balance Description/Comment Program: Page 37 August 19, 2019 Regular Meeting Agenda Packet Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) .00 .00 Check Source Number 73 of 127 Account: 135-60050-030-000 Bad Debt Expense Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60055-030-000 Insurance 134 07/01/2019 Insurance/Wrk Comp Expense Jul 56,724.57 6,302.73 63,027.30 GL Account: 135-60055-030-000 Insurance Totals: 6,302.73 63,027.30 ** 65,000.00 Budgeted 1,972.70 Remaining 97 % Used Account: 135-60066-030-000 Publications/Books/Subscripts .00 .00 Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-60070-030-000 Dues & Memberships ' 4,269.25 .00 4,269.25 Account: 135-60070-030-000 Dues & Memberships Totals: .00 4,269.25 ** 6,000.00 Budgeted 1,730.75 Remaining 71 % Used Account: 135-60075-030-000 Meetings 133.82 .00 133.82 Account: 135-60075-030-000 Meetings Totals: .00 133.82 ** 400.00 Budgeted 266.18 Remaining 33 % Used Account: 135-60079-030-000 Public Education 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 Toilet tabs 260.99 260.99 NRG PC Account: 135-60079-030-000 Public Education Totals: 260.99 260.99 ** 6,000.00 Budgeted 5,739.01 Remaining 4 % Used Account: 135-60080-030-000 Schools & Training 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 TWC HR Conference 1,047.00 125.00 1,172.00 TX BUSINESS CONF TWC PC 73 of 127 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38 15:24 08/14/19 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60080-030-000 Schools & Training Totals: 8,950.00 Budgeted Account: 135-60100-030-000 Travel & per diem 1724 07/18/2019 July A/p Account: 135-60100-030-000 7,778.00 Remaining 13 % Used tolls to lab 127.07 Travel & per diem Totals: 4,345.00 Budgeted Account: 135-60110-030-000 Physicals/Testing Account: 135-60110-030-000 Account: 135-60125-030-000 Account: 135-60125-030-000 4,204.04 Remaining 3 % Used Physicals/Testing Totals: 200.00 Budgeted 200.00 Remaining 0 % Used Advertising Advertising Totals: 25,000.00 Budgeted 25,000.00 Remaining 0 % Used Account: 135-60235-030-000 Security 1763 07/25/2019 July A/P monitoring svc-July Account: 135-60235-030-000 Security Totals: 1,288.00 Budgeted Account: 135-60245-030-000 Miscellaneous Expenses Account: 135-60245-030-000 125.00 1,172.00 ** 13.89 140.96 NTTA 5526 AP 13.89 140.96 ** .00 .00 .00 .00 ** .00 .00 .00 .00 ** 216.00 24.00 240.00 Digital Air Control, Inc 1,048.00 Remaining 19 % Used Miscellaneous Expenses Totals: 500.00 Budgeted Account: 135-60246-030-000 General Manager Contingency 124.49 375.51 Remaining 25 % Used 74 of 127 24.00 240.00 ** .00 124.49 .00 124.49 ** .00 .00 5540 AP glpdatb2 skrolczyk 15:24 08/14/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 30 Administration Period Ending: 7/2019 JE Detail Beginning Balance Description/Comment Program: Page 39 August 19, 2019 Regular Meeting Agenda Packet Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Check Source Number 75 of 127 Account: 135-60246-030-000 General Manager Contingency Totals: .00 .00 ** 17,000.00 Budgeted 17,000.00 Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 removal of tax 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 chair (19.80) 259.79 (19.80) 239.99 OFFICE DEPOT #406 OFFICE DEPOT #406 PC PC Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: 239.99 239.99 ** 2,500.00 Budgeted 2,260.01 Remaining 10 % Used Account: 135-65010-030-000 Uniforms .00 .00 Account: 135-65010-030-000 Uniforms Totals: .00 .00 ** 2,050.00 Budgeted 2,050.00 Remaining 0 % Used Account: 135-65055-030-000 Hardware ' 1724 07/18/2019 July A/p monitors 3,025.81 528.98 3,554.79 M3 Networks 5524 AP Account: 135-65055-030-000 Hardware Totals: 528.98 3,554.79 ** 7,064.00 Budgeted 3,509.21 Remaining 50 % Used Account: 135-65085-030-000 Office Supplies 1724 07/18/2019 July A/p office supplies 6,170.01 75.43 6,245.44 OFFICE DEPOT, INC 5527 AP Account: 135-65085-030-000 Office Supplies Totals: 75.43 6,245.44 ** 6,000.00 Budgeted (245.44) Remaining 104 9 Used Account: 135-65090-030-000 Printer Supplies & Maintenance .00 .00 Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-65095-030-000 Maintenance Supplies 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 water,pt, tp,detergent, plates 3,794.67 185.33 3,980.00 SAMSCLUB.COM PC 75 of 127 glpdatb2 skrolczyk Trophy Club MUD No.1 15:24 08/14/19 Detailed Accounting Trial Balance Page 40 Fund: 135 MUD 1 General Fund Department: 30 Administration Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 coffee 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 coffee 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 tea 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 drum liner, cups 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 coffee 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 heath bar & kit kat minis 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 popcorn 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 tissue dispenser 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 coffee 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 soap dispenser 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 coffeemate,water,towels,bleach 1804 07/26/2019 Pcard 06/27/19 - 07/26/19 kit kats 3,794.67 12.50 3,992.50 AMAZON.COM*MH6X10Y02 32.73 4,025.23 AMAZON.COM*MH2CT3R52 12.95 4,038.18 AMAZON.COM*MH3ZR3RZ2 56.18 4,094.36 SAMSCLUB #4795 20.99 4,115.35 AMAZON.COM*MH72H2RO1 5.72 4,121.07 WAL-MART #5247 29.49 4,150.56 AMZN MKTP US*MH89V3HM1 25.68 4,176.24 AMZN MKTP US*MH6N19PE1 17.74 4,193.98 AMAZON.COM*MH4HR6ZI2 28.99 4,222.97 AMZN MKTP US*MH9K874A0 97.87 4,320.84 SAMS CLUB #4795 7.03 4,327.87 TOM THUMB #3625 PC PC PC PC PC PC PC PC PC PC PC PC Account: 135-65095-030-000 Maintenance Supplies Totals: 533.20 4,327.87 ** 4,000.00 Budgeted (327.87) Remaining 108 a Used Account: 135-65105-030-000 Printing .00 .00 Account: 135-65105-030-000 Printing Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-69005-030-000 Capital Outlays 1731 07/19/2019 July A/P 1735 07/19/2019 July A/P WWTP security phase II GIS support 46,966.00 15,656.43 7,304.71 62,622.43 69,927.14 3RD EYE SURVEILLANCE SYSTEMS Halff Associates, INC 5532 5536 AP AP Account: 135-69005-030-000 Capital Outlays Totals: 22,961.14 69,927.14 ** 280,000.00 Budgeted 210,072.86 Remaining 25 % Used Account: 135-69170-030-000 Copier Lease Installments 1724 07/18/2019 July A/p 1763 07/25/2019 July A/P copier lease -July copy charges 2,413.64 165.00 145.33 2,578.64 2,723.97 TIAA COMMERCIAL FINANCE KYOCERA DOCUMENT SOLUTIONS 5529 5549 AP AP Account: 135-69170-030-000 Copier Lease Installments Totals: 310.33 2,723.97 ** Department 30 Totals: 4,000.00 Budgeted 94,649.03 Monthly Total 1,276.03 Remaining 68 % Used 1,559,905.00 Budgeted 76 of 127 916,921.81 ** 642,983.19 Remaining 59 % Used glpdatb2 skrolczyk 15:24 08/14/19 Fund: 135 MUD 1 General Fund JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 39 Non Departmental Period Ending: 7/2019 JE Detail Beginning Balance Description/Comment Program: Page 41 August 19, 2019 Regular Meeting Agenda Packet Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Check Source Number Department 39 Totals: Fund 135 Totals: 4,800.00 Budgeted 2,111.10 Monthly Total (248,550.97) Monthly Total 1,147.00 Remaining 76 % Used 184,314.00 Budgeted 152,286.02 ** 32,027.98 Remaining 83 o Used (436,907.18) (343,337.00) Budgeted 93,570.18 Remaining 127 5 Used 77 of 127 Account: 135-55045-039-000 Legal 113,228.07 .00 113,228.07 Account: 135-55045-039-000 Legal Totals: .00 113,228.07 ** 137,000.00 Budgeted 23,771.93 Remaining 83 % Used Account: 135-55055-039-000 Auditing 26,459.53 .00 26,459.53 Account: 135-55055-039-000 Auditing Totals: .00 26,459.53 ** 30,800.00 Budgeted 4,340.47 Remaining 86 % Used Account: 135-55060-039-000 Appraisal 1849 07/31/2019 July A/p 3rd quarter allotment 6,834.32 2,111.10 8,945.42 DENTON CENTRAL APPRAISAL DISTR 5594 AP Account: 135-55060-039-000 Appraisal Totals: 2,111.10 8,945.42 ** 11,714.00 Budgeted 2,768.58 Remaining 76 % Used Account: 135-55065-039-000 Tax Admin Fees 3,653.00 .00 3,653.00 Account: 135-55065-039-000 Tax Admin Fees Totals: .00 3,653.00 ** Department 39 Totals: Fund 135 Totals: 4,800.00 Budgeted 2,111.10 Monthly Total (248,550.97) Monthly Total 1,147.00 Remaining 76 % Used 184,314.00 Budgeted 152,286.02 ** 32,027.98 Remaining 83 o Used (436,907.18) (343,337.00) Budgeted 93,570.18 Remaining 127 5 Used 77 of 127 glpdatb2 skrolczyk 15:24 08/14/19 Fund: 137 MUD 1 Consolidated GASB JE JE JE Number Date Description Department: JE Detail Description/Comment Trophy Club MUD No.1 Detailed Accounting Trial Balance Period Ending: 7/2019 Beginning Balance Program: Page 42 August 19, 2019 Regular Meeting Agenda Packet Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Check Source Number Department Totals: .00 Budgeted .00 Monthly Total 81,420.00 Remaining 0 % Used .00 Budgeted 78 of 127 (186,420.00) ** 186,420.00 Remaining 0 % Used Account: 137-49145-000-000 Intergov Transfer -General Fund (105,000.00) .00 (105,000.00) Account: 137-49145-000-000 Intergov Transfer -General Fund Totals: .00 (105,000.00) ** .00 Budgeted 105,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) ** Department Totals: .00 Budgeted .00 Monthly Total 81,420.00 Remaining 0 % Used .00 Budgeted 78 of 127 (186,420.00) ** 186,420.00 Remaining 0 % Used glpdatb2 skrolczyk 15:24 08/14/19 Fund: 137 MUD 1 Consolidated GASB JE JE JE Number Date Description Trophy Club MUD No.1 Page 43 Detailed Accounting Trial Balance Department: 10 Water Program: Period Ending: 7/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) JE Detail Description/Comment August 19, 2019 Regular Meeting Agenda Packet Account: 137-69195-010-000 GASB Replacement 266,613.00 .00 266,613.00 Account: 137-69195-010-000 GASB Replacement Totals: .00 266,613.00 ** .00 Budgeted (266,613.00) Remaining 0 % Used Department 10 Totals: 266,613.00 ** .00 Monthly Total .00 Budgeted (266,613.00) Remaining 0 % Used Fund 137 Totals: 80,193.00 .00 Monthly Total .00 Budgeted 79 of 127 (80,193.00) Remaining 0 % Used August 19, 2019 Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - WWTP TAX BOND CONST BALANCE SHEET JULY 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 517 TAX BOND CONSTRUCTION 726,599 TOTAL ASSETS 726,599 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 684,962 TOTAL LIABILITIES 684,962 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES (1,479,465) 1,521,102 TOTAL FUND BALANCE 41,637 TOTAL LIABILITIES AND FUND BALANCE 726,599 80 of 127 glbase_tbam skrolczyk Trophy Club MUD No.l Page 15 15:23 08/14/19 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49011-000-000 Interest Income 1,497.11- 4,832.06- 4,832.06 517-49105-000-000 Bond Proceeds 1,743,522.00- 1,743,522.00 Subtotal: 1,497.11- 1,748,354.06- 1,748,354.06 Program number: 1,497.11- 1,748,354.06- 1,748,354.06 Department number: Revenues 1,497.11- 1,748,354.06- 1,748,354.06 Revenues Subtotal 1,497.11- 1,748,354.06- 1,748,354.06 81 of 127 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 16 15:23 08/14/19 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-69005-020-000 Capital Outlays 3,885.00 227,252.02 227,252.02 - Subtotal: 3,885.00 227,252.02 227,252.02 - Program number: 3,885.00 227,252.02 227,252.02 - Department number: Wastewater 3,885.00 227,252.02 227,252.02 - Expenditures Subtotal 3,885.00 227,252.02 227,252.02 - Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 2,387.89 1,521,102.04- 1,521,102.04 82 of 127 glpdatb2 skrolczyk 15:24 08/14/19 Fund: 517 2014 MUD 1 Tax Bond Const WWTP JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 7/2019 JE Detail Description/Comment Program: Page 44 August 19, 2019 Regular Meeting Agenda Packet Beginning Transaction Transaction Vendor_Name Balance Detail Detail (SUBTOTAL) Check Source Number Department Totals: (1,497.11) Monthly Total (1,748,354.06) ** .00 Budgeted 1,748,354.06 Remaining 0 % Used 83 of 127 Account: 517-49011-000-000 Interest Income 1861 07/31/2019 Bank Interest- July (3,334.95) (1,497.11) (4,832.06) GL Account: 517-49011-000-000 Interest Income Totals: (1,497.11) (4,832.06) ** .00 Budgeted 4,832.06 Remaining 0 % Used Account: 517-49105-000-000 Bond Proceeds (1,743,522.00) .00 (1,743,522.00) Account: 517-49105-000-000 Bond Proceeds Totals: .00 (1,743,522.00) ** .00 Budgeted 1,743,522.00 Remaining 0 % Used Department Totals: (1,497.11) Monthly Total (1,748,354.06) ** .00 Budgeted 1,748,354.06 Remaining 0 % Used 83 of 127 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45 15:24 08/14/19 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-69005-020-000 Capital Outlays 1763 07/25/2019 July A/P WWTP Crane 223,367.02 3,885.00 227,252.02 Wiss, Janney, Elstner Assoc 5560 AP Account: 517-69005-020-000 Capital Outlays Totals: 3,885.00 227,252.02 ** .00 Budgeted (227,252.02) Remaining 0 % Used Department 20 Totals: 227,252.02 ** 3,885.00 Monthly Total .00 Budgeted (227,252.02) Remaining 0 % Used Fund 517 Totals: (1,521,102.04) 2,387.89 Monthly Total .00 Budgeted 1,521,102.04 Remaining 0 % Used 84 of 127 August 19, 2019 Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET JULY 2019 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 767,358 TOTAL ASSETS 767,358 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 13,158 TOTAL LIABILITIES 13,158 FUND BALANCE ASSIGNED FUND BALANCE 754,200 NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 754,200 TOTAL LIABILITIES AND FUND BALANCE 767,358 85 of 127 August 19, 2019 Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - 16" WATERLINE REV BOND BALANCE SHEET JULY 2019 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND CASH IN BANK 569,776 INVESTMENTS 3,846,120 ACCOUNTS RECEIVABLE 45,000 TOTAL ASSETS 4,460,896 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE (366,246) NET REVENUES / EXPENDITURES 4,827,141 TOTAL FUND BALANCE 4,460,896 TOTAL LIABILITIES AND FUND BALANCE 4,460,896 86 of 127 glbase_tbam skrolczyk 15:23 08/14/19 Fund: 520 Revenue Bond 16" Waterline Department: Trophy Club MUD No.1 Page 17 Budget Summary with Amendment Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 520-49011-000-000 Interest Income 1,169.02- 10,726.19- 10,726.19 520-49105-000-000 Bond Proceeds 5,229,675.71- 5,229,675.71 520-49110-000-000 Bond Premium 4,224.10- 4,224.10 520-49141-000-000 Interfund Transfer In -Gen Fund 25,000.00 25,000.00 - Subtotal: 1,169.02- 5,219,626.00- 5,219,626.00 Program number: 1,169.02- 5,219,626.00- 5,219,626.00 Department number: 1,169.02- 5,219,626.00- 5,219,626.00 Revenues Subtotal 1,169.02- 5,219,626.00- 5,219,626.00 87 of 127 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 18 15:23 08/14/19 Budget Summary with Amendment Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 520-69005-010-000 Capital Outlays 7,901.83 163,530.43 163,530.43 - Subtotal: 7,901.83 163,530.43 163,530.43- 520-70005-010-000 Paying Agent Fee 800.00 800.00- 520-70020-010-000 Bond issuance Costs 228,154.32 228,154.32 - Subtotal: 228,954.32 228,954.32 - Program number: 7,901.83 392,484.75 392,484.75 - Department number: Water Department 7,901.83 392,484.75 392,484.75 - Expenditures Subtotal 7,901.83 392,484.75 392,484.75 - Fund number: 520 Revenue Bond 16" Waterline 6,732.81 4,827,141.25- 4,827,141.25 88 of 127 glpdatb2 skrolczyk 15:24 08/14/19 Fund: 520 Revenue Bond 16" waterline JE JE JE Number Date Description Department: JE Detail Description/Comment Account: 520-49011-000-000 Interest Income 1861 07/31/2019 Bank Interest- July Trophy Club MUD No.1 Page 46 Detailed Accounting Trial Balance Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) (9,557.17) (1,169.02) (10,726.19) GL Account: 520-49011-000-000 Interest Income Totals: (1,169.02) (10,726.19) ** .00 Budgeted 10,726.19 Remaining 0 6 Used Account: 520-49105-000-000 Bond Proceeds (5,229,675.71) .00 (5,229,675.71) Account: 520-49105-000-000 Bond Proceeds Totals: .00 (5,229,675.71) ** .00 Budgeted 5,229,675.71 Remaining 0 % Used Account: 520-49110-000-000 Bond Premium (4,224.10) .00 (4,224.10) Account: 520-49110-000-000 Bond Premium Totals: .00 (4,224.10) ** .00 Budgeted 4,224.10 Remaining 0 % Used Account: 520-49141-000-000 Interfund Transfer In -Gen Fund 25,000.00 .00 25,000.00 Account: 520-49141-000-000 Interfund Transfer In -Gen Fund Totals: .00 25,000.00 ** .00 Budgeted (25,000.00) Remaining 0 % Used Department Totals: (5,219,626.00) ** (1,169.02) Monthly Total .00 Budgeted 5,219,626.00 Remaining 0 % Used 89 of 127 glpdatb2 skrolczyk 15:24 08/14/19 Fund: 520 Revenue Bond 16" Waterline JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: 10 Water Department Period Ending: 7/2019 Program: Page 47 August 19, 2019 Regular Meeting Agenda Packet JE Detail Beginning Transaction Transaction Vendor_Name Balance Detail Detail (SUBTOTAL) Description/Comment Check Source Number Department 10 Totals: Fund 520 Totals: .00 Budgeted 7,901.83 Monthly Total 6,732.81 Monthly Total (228,154.32) Remaining 0 % Used .00 Budgeted 392,484.75 ** (392,484.75) Remaining 0 % Used (4,827,141.25) .00 Budgeted 4,827,141.25 Remaining 0 8 Used 90 of 127 Account: 520-69005-010-000 Capital Outlays 1731 07/19/2019 July A/P 16" waterline 155,628.60 7,901.83 163,530.43 Halff Associates, INC 5533 AP Account: 520-69005-010-000 Capital Outlays Totals: 7,901.83 163,530.43 ** .00 Budgeted (163,530.43) Remaining 0 % Used Account: 520-70005-010-000 Paying Agent Fee 800.00 .00 800.00 Account: 520-70005-010-000 Paying Agent Fee Totals: .00 800.00 ** .00 Budgeted (800.00) Remaining 0 % Used Account: 520-70020-010-000 Bond Issuance Costs 228,154.32 .00 228,154.32 Account: 520-70020-010-000 Bond Issuance Costs Totals: .00 228,154.32 ** Department 10 Totals: Fund 520 Totals: .00 Budgeted 7,901.83 Monthly Total 6,732.81 Monthly Total (228,154.32) Remaining 0 % Used .00 Budgeted 392,484.75 ** (392,484.75) Remaining 0 % Used (4,827,141.25) .00 Budgeted 4,827,141.25 Remaining 0 8 Used 90 of 127 August 19, 2019 Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET JULY 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 770,560 TOTAL ASSETS 770,560 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 91 of 127 606,910 163,650 770,560 770,560 glbase_tbam skrolczyk 15:23 08/14/19 Fund: 528 2015 Revenue Bond Reserve Fund Department: Account Description 528-49011-000-000 528-49142-000-000 528-49143-000-000 Subtotal: Program number: Department number: Revenues Interest Income Interfund transfer in -Water Interfund transfer in -WW Subtotal Fund number: 528 2015 Revenue Bond Reserve Fund Trophy Club MUD No.1 Page 19 Budget Summary with Amendment Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 5,000.00- 5,000.00- 55,193.00- 55,193.00- 125,187.00- 125,187.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 185,380.00- 92 of 127 1,529.98- 13,329.64- 4,600.00- 46,000.00- 10,432.00- 104,320.00- 16,561.98- 163,649.64- 16,561.98- 163,649.64- 16,561.98- 163,649.64- 16,561.98- 163,649.64- 16,561.98- 163,649.64- 266.593 83.344 83.331 88.278 88.278 88.278 88.278 88.278 8,329.64 9,193.00- 20,867.00- 21,730.36- 21,730.36- 21,730.36- 21,730.36- 21,730.36- glpdatb2 skrolczyk 15:24 08/14/19 Fund: 528 2015 Revenue Bond Reserve Fund JE JE JE Number Date Description Department: JE Detail Description/Comment Account: 528-49011-000-000 Interest Income 1861 07/31/2019 Bank Interest- July Account: 528-49011-000-000 Trophy Club MUD No.1 Page 48 Detailed Accounting Trial Balance Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Interest Income Totals: (5,000.00) Budgeted (11,799.66) 8,329.64 Remaining 267 % Used Account: 528-49142-000-000 Interfund transfer in -Water 1797 07/31/2019 TexPool Transfers July TexPool O&M to Rev Bond Resevr Account: 528-49142-000-000 Interfund transfer in -Water Totals: (41,400.00) (55,193.00) Budgeted (9,193.00) Remaining Account: 528-49143-000-000 Interfund transfer in -WW 1797 07/31/2019 TexPool Transfers July TexPool 0&M to Rev Bond Resevr Account: 528-49143-000-000 Department Totals: Fund 528 Totals: (1,529.98) (13,329.64) GL (1,529.98) (13,329.64) ** (4,600.00) (46,000.00) GL 83 % Used (93,888.00) Interfund transfer in -WW Totals: (125,187.00) Budgeted (20,867.00) Remaining (4,600.00) (46,000.00) ** (10,432.00) (104,320.00) GL 83 9 Used (16,561.98) Monthly Total (185,380.00) Budgeted (16,561.98) Monthly Total (185,380.00) Budgeted 93 of 127 (10,432.00) (104,320.00) ** (163,649.64) ** (21,730.36) Remaining 88 9 Used (163,649.64) (21,730.36) Remaining 88 8 Used August 19, 2019 Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - I&S (DEBT SERVICE) BALANCE SHEET JULY 2019 ASSETS CASH IN BANK INVESTMENTS 957,317 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 14,116 ACCOUNTS RECEIVABLE -OTHER - TOTAL ASSETS 971,433 Q TROPHY CLUB MUNICIPAL UTILITY DISTRICT INTEREST & SINKING- 533 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 14,116 ACCOUNTS AND OTHER PAYABLES 657 TOTAL LIABILITIES 14,773 FUND BALANCE ASSIGNED FUND BALANCE 53,289 NET REVENUES / EXPENDITURES 903,372 TOTAL FUND BALANCE 956,660 TOTAL LIABILITIES AND FUND BALANCE 971,433 94 of 127 glbase_tbam skrolczyk 15:23 08/14/19 Fund: 533 MUD 1 I&S Consolidated Account Description 1 1 533-40000-000-000 1 533-40002-000-000 1 533-40015-000-000 Property Taxes Property Taxes/Delinquent Property Taxes/P & i Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Program: Period Ending: 7/2019 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Page 20 August 19, 2019 Regular Meeting Agenda Packet 687,175.00- 1,800.00- 2,000.00- 687,175.00- 1,800.00- 2,000.00- 1,950.01- 155.35- 72.62- 676,819.99- 1,889.51 2,054.31- 98.493 -104.973 102.716 10,355.01- 3,689.51- 54.31 Subtotal: 690,975.00- 690,975.00- 2,177.98- 676,984.79- 97.975 13,990.21- 533-49010-000-000 533-49011-000-000 533-49015-000-000 Interest Income Interest Income Lease/Rental Income 2,000.00- 215,979.00- 2,000.00- 215,979.00- 1,912.63- 35,747.66- 215,979.00- 100.000 2,000.00- 35,747.66 533-49141-000-000 Interfund Trans In -PID Surchg 120,053.00- 120,053.00- 10,913.90- 109,139.00- 90.909 10,914.00 - Subtotal: 338,032.00- 338,032.00- 12,826.53- 360,865.66- 106.755 22,833.66 Program number: 1,029,007.00- 1,029,007.00- 15,004.51- 1,037,850.45- 100.859 8,843.45 Department number: Revenues 1,029,007.00- 1,029,007.00- 15,004.51- 1,037,850.45- 100.859 8,843.45 Revenues Subtotal 1,029,007.00- 1,029,007.00- 15,004.51- 1,037,850.45- 100.859 8,843.45 95 of 127 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 21 15:23 08/14/19 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 2,150.00 2,150.00 533-70025-051-000 Bond Interest Expense -Tax 266,058.00 266,058.00 533-70035-051-000 Bond Principal Payment -Tax 755,000.00 755,000.00 Subtotal: 1,023,208.00 1,023,208.00 Program number: 1,023,208.00 1,023,208.00 Department number: Administration 1,023,208.00 1,023,208.00 Expenditures Subtotal 1,023,208.00 1,023,208.00 Fund number: 533 MUD 1 I&S Consolidated 5,799.00- 5,799.00- 96 of 127 1,450.00 133,028.75 134,478.75 134,478.75 134,478.75 134,478.75 67.442 50.000 13.143 13.143 13.143 13.143 15,004.51- 903,371.70- ############### 700.00 133,029.25 755,000.00 888,729.25 888,729.25 888,729.25 888,729.25 897,572.70 glpdatb2 skrolczyk 15:24 08/14/19 Fund: 533 MUD 1 I&S Consolidated JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 7/2019 JE Detail Description/Comment Page 49 August 19, 2019 Regular Meeting Agenda Packet Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 Property Taxes 1829 07/01/2019 Property Taxes 1830 07/02/2019 Property Taxes 1831 07/03/2019 Property Taxes 1832 07/08/2019 Property Taxes 1833 07/09/2019 Property Taxes 1834 07/10/2019 Property Taxes 1835 07/11/2019 Property Taxes 1837 07/15/2019 Property Taxes 1838 07/16/2019 Property Taxes 1839 07/17/2019 Property Taxes 1840 07/18/2019 Property Taxes 1841 07/19/2019 Property Taxes 1842 07/22/2019 Property Taxes 1843 07/23/2019 Property Taxes 1844 07/24/2019 Property Taxes 1845 07/25/2019 Property Taxes 1846 07/26/2019 Property Taxes 1847 07/29/2019 Property Taxes 1848 07/30/2019 Property Taxes 1850 07/31/2019 Property Taxes (674,869.98) (18.20) (674,888.18) GL (8.95) (674,897.13) GL (11.82) (674,908.95) GL (19.54) (674,928.49) GL (18.92) (674,947.41) GL (4.17) (674,951.58) GL (6.59) (674,958.17) GL (117.45) (675,075.62) GL (27.00) (675,102.62) GL (272.44) (675,375.06) GL (28.21) (675,403.27) GL (238.14) (675,641.41) GL (360.12) (676,001.53) GL (76.75) (676,078.28) GL (162.97) (676,241.25) GL (100.40) (676,341.65) GL (80.83) (676,422.48) GL (232.48) (676,654.96) GL 10.33 (676,644.63) GL (175.36) (676,819.99) GL Account: 533-40000-000-000 Property Taxes Totals: (1,950.01) (676,819.99) ** (687,175.00) Budgeted (10,355.01) Remaining 98 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1830 07/02/2019 Property Taxes 1832 07/08/2019 Property Taxes 1836 07/12/2019 Property Taxes 1850 07/31/2019 Property Taxes 2,044.86 (121.55) 1,923.31 GL (6.83) 1,916.48 GL (11.44) 1,905.04 GL (15.53) 1,889.51 GL Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (155.35) 1,889.51 ** (1,800.00) Budgeted (3,689.51) Remaining -105 % Used Account: 533-40015-000-000 Property Taxes/P & I 1829 07/01/2019 Property Taxes 1830 07/02/2019 Property Taxes 1831 07/03/2019 Property Taxes 1832 07/08/2019 Property Taxes 1833 07/09/2019 Property Taxes 1834 07/10/2019 Property Taxes (1,981.69) (.95) (1,982.64) GL (16.78) (1,999.42) GL (1.54) (2,000.96) GL (1.00) (2,001.96) GL (1.71) (2,003.67) GL (.50) (2,004.17) GL 97 of 127 glpdatb2 skrolczyk 15:24 08/14/19 Fund: 533 MUD 1 I&S Consolidated JE JE JE Number Date Description 1835 07/11/2019 Property Taxes 1836 07/12/2019 Property Taxes 1839 07/17/2019 Property Taxes 1841 07/19/2019 Property Taxes 1842 07/22/2019 Property Taxes 1843 07/23/2019 Property Taxes 1845 07/25/2019 Property Taxes 1847 07/29/2019 Property Taxes 1850 07/31/2019 Property Taxes Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Program: Period Ending: 7/2019 JE Detail Description/Comment Page 50 August 19, 2019 Regular Meeting Agenda Packet Beginning Transaction Transaction Vendor_Name Check Source Balance Detail Detail Number (SUBTOTAL) (1,981.69) (.98) (2,005.15) GL (2.17) (2,007.32) GL (.96) (2,008.28) GL (7.43) (2,015.71) GL (29.99) (2,045.70) GL (.50) (2,046.20) GL (.41) (2,046.61) GL (1.18) (2,047.79) GL (6.52) (2,054.31) GL Account: 533-40015-000-000 Property Taxes/P & I Totals: (72.62) (2,054.31) ** (2,000.00) Budgeted 54.31 Remaining 103 % Used Account: 533-49010-000-000 Interest Income .00 .00 Account: 533-49010-000-000 Interest Income Totals: .00 .00 ** (2,000.00) Budgeted (2,000.00) Remaining 0 % Used Account: 533-49011-000-000 Interest Income 1861 07/31/2019 Bank Interest- July (33,835.03) (1,912.63) (35,747.66) GL Account: 533-49011-000-000 Interest Income Totals: (1,912.63) (35,747.66) ** .00 Budgeted 35,747.66 Remaining 0 % Used Account: 533-49015-000-000 Lease/Rental Income (215,979.00) .00 (215,979.00) Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (215,979.00) ** (215,979.00) Budgeted .00 Remaining 100 5 Used Account: 533-49141-000-000 Interfund Trans In -PID Surchg 1797 07/31/2019 TexPool Transfers July TexPool O&M to I&S- PID Debt (98,225.10) (10,913.90) (109,139.00) GL Account: 533-49141-000-000 Interfund Trans In -PID Surchg Totals: (10,913.90) (109,139.00) ** (120,053.00) Budgeted (10,914.00) Remaining 91 % Used Department Totals: (1,037,850.45) ** (15,004.51) Monthly Total (1,029,007.00) Budgeted 8,843.45 Remaining 101 % Used 98 of 127 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 51 15:24 08/14/19 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-70005-051-000 Paying Agent Fee Account: 533-70005-051-000 Account: 533-70025-051-000 Account: 533-70025-051-000 1,450.00 Paying Agent Fee Totals: 2,150.00 Budgeted 700.00 Remaining 67 % Used Bond Interest Expense -Tax Bond Interest Expense -Tax Totals: 266,058.00 Budgeted 133,029.25 Remaining 133,028.75 .00 1,450.00 .00 1,450.00 ** .00 50 % Used 133,028.75 .00 133,028.75 ** Account: 533-70035-051-000 Bond Principal Payment -Tax Account: 533-70035-051-000 Department 51 Totals: Fund 533 Totals: Bond Principal Payment -Tax Totals: 755,000.00 Budgeted 755,000.00 Remaining .00 0 % Used .00 .00 .00 ** 134,478.75 ** .00 Monthly Total 1,023,208.00 Budgeted 888,729.25 Remaining 13 % Used (903,371.70) (15,004.51) Monthly Total (5,799.00) Budgeted 897,572.70 Remaining ########## 99 of 127 August 19, 2019 Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - REVENUE BOND I&S (WWTP) BALANCE SHEET JULY 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 457,689 TOTAL ASSETS 457,689 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 100 of 127 19,562 438,128 457,689 457,689 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 22 15:23 08/14/19 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49011-000-000 Interest Income 1,000.00- 1,000.00- 820.09- 4,212.05- 421.205 3,212.05 534-49143-000-000 Interfund Transfer In -WW Sales 596,238.00- 596,238.00- 54,203.45- 542,034.50- 90.909 54,203.50 - Subtotal: 597,238.00- 597,238.00- 55,023.54- 546,246.55- 91.462 50,991.45 - Program number: 597,238.00- 597,238.00- 55,023.54- 546,246.55- 91.462 50,991.45 - Department number: Revenues 597,238.00- 597,238.00- 55,023.54- 546,246.55- 91.462 50,991.45 - Revenues Subtotal 597,238.00- 597,238.00- 55,023.54- 546,246.55- 91.462 50,991.45- 101 of 127 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 23 15:23 08/14/19 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-70005-051-000 Rev Bond Paying Agent Fee 400.00 400.00 534-70040-051-000 Revenue Bond Interest Expense 215,838.00 215,838.00 534-70045-051-000 Revenue Bond Principal Expense 380,000.00 380,000.00 Subtotal: 596,238.00 596,238.00 Program number: 596,238.00 596,238.00 Department number: Administration 596,238.00 596,238.00 Expenditures Subtotal 596,238.00 596,238.00 Fund number: 534 2015 Revenue Bond I&S 1,000.00- 1,000.00- 102 of 127 200.00 107,918.75 108,118.75 108,118.75 108,118.75 108,118.75 50.000 50.000 18.133 18.133 18.133 18.133 55,023.54- 438,127.80- ############### 200.00 107,919.25 380,000.00 488,119.25 488,119.25 488,119.25 488,119.25 437,127.80 glpdatb2 skrolczyk 15:24 08/14/19 Fund: 534 2015 Revenue Bond ISS JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 7/2019 JE Detail Description/Comment Program: Page 52 August 19, 2019 Regular Meeting Agenda Packet Beginning Transaction Transaction Vendor_Name Balance Detail Detail (SUBTOTAL) Check Source Number Department Totals: (55,023.54) Monthly Total (546,246.55) ** (597,238.00) Budgeted (50,991.45) Remaining 91 % Used 103 of 127 Account: 534-49011-000-000 Interest Income 1861 07/31/2019 Bank Interest- July (3,391.96) (820.09) (4,212.05) GL Account: 534-49011-000-000 Interest Income Totals: (820.09) (4,212.05) ** (1,000.00) Budgeted 3,212.05 Remaining 421 % Used Account: 534-49143-000-000 Interfund Transfer In -WW Sales 1797 07/31/2019 TexPool Transfers July TexPool O&M to Rev Bd WWTP ISS (487,831.05) (54,203.45) (542,034.50) GL Account: 534-49143-000-000 Interfund Transfer In -WW Sales Totals: (54,203.45) (542,034.50) ** (596,238.00) Budgeted (54,203.50) Remaining 91 % Used Department Totals: (55,023.54) Monthly Total (546,246.55) ** (597,238.00) Budgeted (50,991.45) Remaining 91 % Used 103 of 127 glpdatb2 skrolczyk Trophy Club MUD No.1 Page 53 15:24 08/14/19 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-70005-051-000 Rev Bond Paying Agent Fee Account: 534-70005-051-000 Account: 534-70040-051-000 Account: 534-70040-051-000 Account: 534-70045-051-000 Account: 534-70045-051-000 Department 51 Totals: Fund 534 Totals: Rev Bond Paying Agent Fee Totals: 400.00 Budgeted 200.00 Remaining Revenue Bond Interest Expense Revenue Bond Interest Expense Totals: 215,838.00 Budgeted 107,919.25 Remaining Revenue Bond Principal Expense Revenue Bond Principal Expense Totals: 380,000.00 Budgeted 380,000.00 Remaining 200.00 107,918.75 50 % Used .00 200.00 .00 200.00 ** .00 50 % Used 107,918.75 .00 107,918.75 ** .00 0 % Used .00 Monthly Total 596,238.00 Budgeted (55,023.54) Monthly Total .00 .00 .00 ** 108,118.75 ** 488,119.25 Remaining 18 % Used (438,127.80) (1,000.00) Budgeted 437,127.80 Remaining QQQQQQQ#99 104 of 127 August 19, 2019 Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET JULY 2019 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB ` MUNICIPAL UTILITY DISTRICT No. 1 535 NSII FTW SWIFT REVENUE BOND I&S 225,393 TOTAL ASSETS 225,393 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 105 of 127 2,584 222,810 225,393 225,393 glbase_tbam skrolczyk 15:23 08/14/19 Fund: 535 2016 Rev Bond I&S-SWIFT Account 1 1 535-49011-000-000 1 Description Interest Income Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Period Ending: 7/2019 Adopted Amended Total Budget Budget Encumb. 600.00- 600.00 - Current Month 406.82 - Program: YTD Total 2,032.05 - Page 24 August 19, 2019 Regular Meeting Agenda Packet % of Remaining Budget Budget 338.675 1,432.05 535-49142-000-000 Interfund Tran In -Water Sales 276,901.00- 276,901.00- 25,172.81- 251,728.10- 90.909 25,172.90 - Subtotal: 277,501.00- 277,501.00- 25,579.63- 253,760.15- 91.445 23,740.85 - Program number: 277,501.00- 277,501.00- 25,579.63- 253,760.15- 91.445 23,740.85 - Department number: Revenues 277,501.00- 277,501.00- 25,579.63- 253,760.15- 91.445 23,740.85 - Revenues Subtotal 277,501.00- 277,501.00- 25,579.63- 253,760.15- 91.445 23,740.85- 106 of 127 glbase_tbam skrolczyk 15:23 08/14/19 Fund: 535 2016 Rev Bond I&S-SWIFT Account 1 535-70005-051-000 Description Rev Bond Paying Agent Fee Trophy Club MUD No.1 Budget Summary with Amendment Department: 51 Administration Period Ending: 7/2019 Adopted Amended Total Budget Budget Encumb. 400.00 400.00 Current Month Program: YTD Total 200.00 Page 25 August 19, 2019 Regular Meeting Agenda Packet % of Remaining Budget Budget 50.000 200.00 535-70040-051-000 Revenue Bond Interest Expense 1 535-70045-051-000 Revenue Bond Principal Expense 61,501.00 215,000.00 61,501.00 215,000.00 30,750.50 50.000 30,750.50 215,000.00 Subtotal: 276,901.00 276,901.00 30,950.50 11.177 245,950.50 Program number: 276,901.00 276,901.00 30,950.50 11.177 245,950.50 Department number: Administration 276,901.00 276,901.00 30,950.50 11.177 245,950.50 Expenditures Subtotal 276,901.00 276,901.00 30,950.50 11.177 245,950.50 Fund number: 535 2016 Rev Bond I&S-SWIFT 600.00- 600.00- 25,579.63- 222,809.65- ############### 222,209.65 ******* End of Report ********* 107 of 127 glpdatb2 skrolczyk 15:24 08/14/19 Fund: 535 2016 Rev Bond I&S-SWIFT JE JE JE Number Date Description Trophy Club MUD No.1 Detailed Accounting Trial Balance Department: Revenues Period Ending: 7/2019 Beginning Balance JE Detail Description/Comment Program: Page 54 August 19, 2019 Regular Meeting Agenda Packet Transaction Transaction Vendor_Name Detail Detail (SUBTOTAL) Check Source Number Department Totals: (276,901.00) Budgeted (25,579.63) Monthly Total (25,172.90) Remaining 91 % Used (277,501.00) Budgeted 108 of 127 (253,760.15) ** (23,740.85) Remaining 91 % Used Account: 535-49011-000-000 Interest Income 1861 07/31/2019 Bank Interest- July GL (1,625.23) (406.82) (2,032.05) Account: 535-49011-000-000 Interest Income Totals: (406.82) (2,032.05) ** (600.00) Budgeted 1,432.05 Remaining 339 % Used Account: 535-49142-000-000 Interfund Tran In -Water Sales 1797 07/31/2019 TexPool Transfers July TexPool O&M to 16Swift Rev I&S (226,555.29) (25,172.81) (251,728.10) GL Account: 535-49142-000-000 Interfund Tran In -Water Sales Totals: (25,172.81) (251,728.10) ** Department Totals: (276,901.00) Budgeted (25,579.63) Monthly Total (25,172.90) Remaining 91 % Used (277,501.00) Budgeted 108 of 127 (253,760.15) ** (23,740.85) Remaining 91 % Used glpdatb2 skrolczyk Trophy Club MUD No.1 Page 55 15:24 08/14/19 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: August 19, 2019 Regular Meeting Agenda Packet Period Ending: 7/2019 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 535-70005-051-000 Rev Bond Paying Agent Fee Account: 535-70005-051-000 200.00 .00 200.00 Rev Bond Paying Agent Fee Totals: .00 200.00 ** 400.00 Budgeted 200.00 Remaining 50 % Used Account: 535-70040-051-000 Revenue Bond Interest Expense 30,750.50 .00 30,750.50 Account: 535-70040-051-000 Revenue Bond Interest Expense Totals: .00 30,750.50 ** 61,501.00 Budgeted 30,750.50 Remaining 50 % Used Account: 535-70045-051-000 Revenue Bond Principal Expense .00 .00 Account: 535-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 ** Department 51 Totals: Fund 535 Totals: Grand Totals: 215,000.00 Budgeted 215,000.00 Remaining 0 % Used .00 Monthly Total 276,901.00 Budgeted 30,950.50 ** 245,950.50 Remaining 11 % Used (222,809.65) (25,579.63) Monthly Total (600.00) Budgeted 222,209.65 Remaining NNNNNNNNNN ******* End of Report ********* (8,668,552.27) **** (297,444.22) Monthly Total (536,116.00) Budgeted 8,132,436.27 Remaining NNNNNNNNNN 109 of 127 August 19, 2019 Regular Meeting Agenda Packet BUDGET VARIANCE REPORT FUND: 122 - Fire O&M FINANCIALS MONTH: July 2019 REVENUE VARIANCE: 74.7% EXPENSE VARIANCE: 93.0% 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 FIRE REVENUES 122-40010 Property Taxes/Mud Fire 122-40011 Property Taxes/Fire - Delinquent 122-40020 FIRE EXPENSES Property Taxes/Fire P&I TOTAL CURRENT YTD YTD % DATE OF VARIANCE EXPLANATION BUDGET MONTH TOTAL COMMENT $1,117,000 $3,169 $1,100,037 98.48% 10/2018 Property Taxes/MUD Fire $244 -$3,128 6/2019 Delinquent Fire Taxes collected Paid Out 2017 Delinquent Tax Shortage $127 $4,619 10/2018 Fire Taxes Penalties & Interest collected 110 of 127 BUDGET VARIANCE FUND: FINANCIALS MONTH: REVENUE VARIANCE: EXPENSE VARIANCE: NOTE: ACCOUNT REVENUE 135-40002-000 135-47000-000 135-47005-000 135-47025-000 135-47070-000 135-49075-000 'EXPENSES WATER 1135-55135-010 WASTEWATER 1135-50010-020 1135-65030-020 BOARD OF DIRECTORS 'ADMINISTRATION 135-60040-030 135-60055-030 135-65085-030 135-65095-030 Non -Departmental REPORT 135 - MUD 1 O&M July 2019 74.7% 93.0% Explanation provided for all accounts with a Year -To -Date percentage (YTD%) Expense Variance. The Revenue and Expense Variance is calculated on a revenues and plus 10% for expenses. Only accounts with current month activ DESCRIPTION TOTAL CURRENT YTD August 19, 2019 Regular Meeting Agenda Packet less than the Revenue Variance and greater than or equal to the straight-line method (Financials Month x 8.3%), less 8.3% for ity will be listed YTD % DATE OF VARIANCE EXPLANATION COMMENT Property Taxes/Delinquent Water Sewer Penalties TCCC Effluent Charges Oversize Meter Reimbursment Lab Analysis Overtime Chemicals Service Charges & Fees Insurance Office Supplies Maintenance Supplies BUDGET MONTH TOTAL $300 $28 -$323 -107.55% 06/2019 $6,599,484 $617,040 $3,570,647 54.10% 10/2018 $3,412,665 $264,167 $2,543,195 74.52% 08/2019 $136,418 $6,439 $78,958 57.88% 02/2019 $60,000 $14,341 $19,686 32.81% 07/2019 $18,522 $343 $8,232 44.44% 06/2019 Paid Out 2017 Delinquent Tax Shortage Water Sales Sewer Sales Penalties TCCC Effluent Charges Oversize Meter Reimbursment $6,500 $279 $7,177 110.41% 04/2019 Lab Testing $30,000 $2,637 $29,602 98.67% 04/2019 Overtime $30,000 $569 $29,925 99.75% 04/2019 Bacteria, Chemicals $55,560 $5,155 $53,846 96.92% 02/2019 $65,000 $6,303 $63,027 96.97% 06/2019 $6,000 $75 $6,245 104.09% 02/2019 $4,000 $533 $4,328 108.20% 07/2019 111 of 127 Pace Credit Cards Fees Insurance Office supplies Maintenance Supplies TROPHY CLUB MUNICIPAL 1 UTILITY DISTRICT Not STAFF REPORT August 19, 2019 REGULAR SESSION — WASTEWATER PLANT TOURS STAFF REPORT August 19, 2019 Regular Meeting Agenda Packet Upgrades to the Wastewater Plant are nearing completion and staff would like to hold a "Public Tour Event" on Saturday, September 7, 2019 from 9 — 11 a.m. This will be an informal opportunity for our residents to gain a better understanding of the wastewater process and ask questions. Staff will host the event and provide very light refreshments. Parking is available at the plant as well as the maintenance barn. A Notice of Quorum will be posted for the selected time. John R. Carman General Manager 112 of 127 August 19, 2019 Regular Meeting Agenda Packet Trophy Club Municipal Utility District No. 1 Date: 8/19/2019 To: Board of Directors From: John Robert Carman Subject: General Manager's Report gulatory Updates Breaks and Leaks — No reportable breaks or leaks have occurred since the fast report. Sanitary Sewer Overflows (550) — No 550's have occurred since the last report. Capital Improvement Proiects Interconnecting Pipeline Project Phase 2 — Offers for each easement to be acquired have been made, five (5) have been verbally accepted with one of these completed. The other three (3) have not expressed any reservations regarding the offer, but are slow to respond. Separately, our engineer is working with both Oncor and TxDOT to pay the application fees required for both of our encroachments into their respective easements along the route. Given the unknowns, our design and construction management engineer is hesitant to offer even a projected date for bidding at this point in time. WWTP — Sampling for soil compaction adjacent and near the footings along north side of basins 3-6 has been completed and our special inspector is waiting on the results from the laboratory to include in their final inspection report. Staff expects this report in the next 2 weeks. One challenge that has come up relates to the hydraulics of the piping system downstream of the membranes. Anomalous behavior created a situation where the downstream valve on the membrane permeate systems had to be kept in nearly closed position in order to ensure that wild flow fluctuations did not occur when a membrane train was put into service. At least once in the last year this condition had created an 550. A root cause analysis pointed to the possibility that the plumbing downstream of the membranes created the possibility of siphoning controlling the flow rate when membranes are clean and just turned into service. This theory was confirmed by introducing, for the lack of a 113 of 127 August 19, 2019 Regular Meeting Agenda Packet better term, a weir into the system to ensure no possibility for vacuum (below atmospheric pressure) in the membrane discharge line. The test condition is shown in the photo — the permanent fix is yet to be designed. High Service Pump — The high service pump upgrade project has reached a critical milestone in that the pump, valves and appurtenances have been installed. It looks like the first change order on this project — replacement of the breaker to which all this equipment is connected -- will be coming in the near term. It is between $5,000 and $10,000 so staff doesn't anticipate needing to bring the change order back for Board approval. This project will likely be close to substantial completion prior to the next Board meeting. (see photos below) Straight Creek Court and Carnoustie — This project is complete. Miscellaneous Capital Items WWTP In -plant Water System Upgrade — A preconstruction walkthrough on this project has been conducted and we are under way. Project expected to be complete prior to end of calendar year. Lift Station Upgrades and Generator — While the lift station upgrade program is a multi- year project, the generator we budgeted for has arrived. It looks like it has tremendous 114 of 127 August 19, 2019 Regular Meeting Agenda Packet flexibility to accommodate our lift stations — from smallest to largest. A picture of our new generator is shown below. System Repairs Two unplanned/unanticipated valve replacements became necessary as our Operations Team worked to help the contractor for the Sundance and Meadowbrook prepare for isolating the system, One of these replacements is shown below. 115 of 127 August 19, 2019 Regular Meeting Agenda Packet Fire Department Summary - Since the June 1, 2019, the Fire Department has been busy: • Fire/ EMS responses: 197 • Training: Hazmat , EMS, Rescue, Firefighter Safety and Live Fire Burns. • Multiple fire prevention/public education events. • Preparing for the annual Citizen Fire Academy to start on September 19 and Fire Prevention programs in all of our schools within the town. The fire department will be hosting an Open House on October 19 at the Fire Station from l0am-2pm. Everyone is welcome to come!!! • The fire station exhaust system for the apparatus bays has been completed and running great!! • Fire Marshal Office and Fire Department have completed 75 commercial and residential inspections, with around 15 violations found in commercial buildings, which have all been corrected or in the process of being corrected. 116 of 127 FY 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 October 63,730 39,794 70,502 85,869 85,488 82,660 90,994 108,951 74,785 83.228 November 48,170 39,713 50,909 53,571 75,251 48,813 58,986 41,936 68,638 69,099 December 35,215 29,547 44,365 40,815 48,527 34,482 49,607 39,028 38,580 48.144 January 35,759 30,305 35,983 30,616 39,601 39,767 36,162 39,622 33,028 34.592 August 19, 2019 Regular Meeting Agenda Packet Monthly Water Operations Report February 32,240 25,328 27,845 31,665 34,450 37,085 38,776 44,551 38,380 40,658 Water Billed April 46,151 41,646 69,165 47,194 56,947 66,337 46,543 55,181 56,683 60.079 March 39,331 23,279 55,972 35,263 43,137 54,794 30,566 49,498 60,841 43.411 May 37,382 53,439 61,467 84,905 76,542 84,384 39,576 50,827 86,794 89.802 June 56,370 102,921 99,326 114,104 85,312 99,240 60,731 65,390 98,864 118,899 July 125,089 89,760 117,707 137,174 110,072 92,913 100,622 115,687 95,355 126,588 August September 91,724 79,137 128,687 82,331 170,464 123,692 144,573 108,622 130,945 114,497 113,135 110,873 139,441 123,886 119,611 98,945 104,303 99,541 125,531 73,735 Total Year 690,298 686,750 927,397 914,371 900,769 864,483 815,890 829,227 855,792 913,766 2019 1 47,193 1 41,933 1 36,244 1 34,604 1 33,740 1 40,421 1 55,970 1 42,773 1 70,747 1 96,174 1 1 1 499,799 160,000 140,000 120,000 100,000 80,000 60,000 40,000 20,000 WATER BILLED IN THOUSANDS OF GALLONS 0 ary March April st September - 2015 - 2016 - 2017 2018 - 2019 FY 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 October November December January February 65,110 48,570 36,411 36,587 36,385 40,803 41,600 32,700 31,400 30,145 70,502 50,993 44,220 33,789 36,053 83,750 54,245 41,650 34,740 31,581 85,966 77,758 55,110 39,283 37,867 81,909 51,769 39,769 48,758 42,395 106,251 67,825 58,659 45,691 39,675 106,731 52,616 43,708 46,945 50,721 82,677 77,937 43,792 43,207 43,024 91,439 78,282 55,745 40,796 40,750 60,576 1 53,119 1 45,651 45,552 1 39,014 Water Pumped March 44,120 27,240 54,775 46,519 56,743 61,100 35,752 55,178 69,549 51,711 43,048 April 48,881 43,400 71,306 62,649 60,969 71,283 56,704 60,434 65,723 67,217 61,238 May June July August 38,250 66,450 116,823 94,525 62,646 113,049 94,950 131,650 63,500 116,350 152,002 169,621 100,402 110,324 153,813 139,005 87,168 96,602 119,414 145,988 96,481 95,206 110,173 123,369 48,637 72,934 117,302 143,413 55,562 68,138 112,533 128,963 94,452 103,867 101,184 114,872 97,980 124,109 155,354 144,015 48,787 1 79,167 1 102,887 1 September Total Year 81,500 713,612 76,159 725,742 117,190 980,301 123,045 981,723 120,342 983,210 115,607 937,819 142,394 935,237 104,664 886,193 109,769 950,053 85,946 1,033,344 1 579,0391 180,000 160,000 140,000 120,000 100,000 80,000 60,000 40,000 20,000 WATER PUMPED IN THOUSANDS OF GALLONS October November December January February March April May Ju J - 2015 2016 - 2017 2018 - 2019 Active Connections FY October November December January February March April May June July August September 2014 Total 4139 4157 4173 4206 4209 4219 4240 4268 4280 4308 4333 4339 2015 Total 4353 4363 4377 4404 4413 4429 4443 4459 4478 4486 4498 4517 2015 MUD 3083 3087 3095 3119 3120 3122 3123 3128 3133 3134 3137 3149 2015 PID 1270 1276 1282 1285 1293 1307 1320 1331 1345 1352 1361 1368 2016 Total 4531 4538 4556 4568 4593 4604 4607 4616 4622 4627 4632 4636 2016 MUD 3155 3158 3167 3172 3176 3181 3183 3186 3188 3192 3196 3200 2016 PID 1376 1380 1389 1396 1417 1423 1424 1430 1434 1435 1436 1436 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 2019Total 4741 4743 4745 4753 ] 4753 4758 4761 4762 4768 4770 2019 MUD 3297 3299 3301 3309 3309 3314 3317 3318 3324 3326 2019 PID 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 117 of 127 Date 1 -Jul 2 -Jul 8 -Jul 9 -Jul 15 -Jul 16 -Jul 22 -Jul 23 -Jul 29 -Jul 30 -Jul IReport Ammonia -N Influent Effluent 50.5 0.21 47.8 0.20 49.5 0.20 44.5 0.20 37.0 0.20 40.0 0.20 42.0 0.20 53.8 0.20 45.0 0.2 46.0 0.2 Removal 99.6% 99.6% July 2019 Results CBOD5 Influent Effluent 211 2.0 287 2.0 99.6% 160 2.0 99.6% 162 2.0 99.5% 225 2.0 99.5% 299 2.0 99.5% 248 2.0 99.6% 320 2.0 99.6% 163 2.0 99.6% 230 2.0 Ammonia -N 0.20 I 99.6% CBOD5 2.0 118 of 127 Removal 99.1% 99.3% 98.8% 98.8% 99.1% 99.3% 99.2% 99.4% 98.8% 99.1% I 99.1% August 19, 2019 Regular Meeting Agenda Packet TSS Influent Effluent 181 1.0 192 1.0 196 1.0 224 1.0 286 1.0 231 1.0 170 1.0 210 1.0 185 1.0 222 1 Removal 99.4% 99.5% 99.5% 99.6% 99.7% 99.6% 99.4% 99.5% 99.5% 99.5% TSS I1.0 I 99.5% 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 August 19, 2019 Regular Meeting Agenda Packet Ammonia Nitrogen Permit Limit 3 (Jan - March) Permit Limit 3 (Sept. - Dec.) 0.21 0.2 0.481 0.498 0.309 0.316 Permit Limit - 1 from April - August 0.215 0.201 ■ - Dec -18 Jan -19 Feb -19 Mar -19 Apr -19 May -19 Jun -19 Jul -19 Aug -19 Max mg/L = .20 Average mg/L =.20 Carbonaceous Biochemical Demand (CBODS) Sep -19 Oct -19 Nov -19 Dec -19 Permit Limit 5 2.0 2.0 2.0 2.0 2.13 2.0 2.04 2.0 2.00 2.0 2.00 2.0 2.00 2.0 2.00 2.0 iiiiiiiiruuiiii Dec -18 Jan -19 Feb -19 Mar -19 Apr -19 May -19 Jun -19 Jul -19 Max mg/L = 2.0 Average mg/L = 2.0 119 of 127 Aug -19 Sep -19 Oct -19 Nov -19 Dec -19 Nh3Ave Nh3 - Permit Limit Bod Bod Aver - Permit Limit 14.0 12.0 10.0 8.0 6.0 4.0 2.0 0.0 30.0 25.0 20.0 15.0 10.0 5.0 0.0 August 19, 2019 Regular Meeting Agenda Packet Total Suspended Solids (TSS) Permit Limit 12 1.0 1.0 1.0 1.0 .. .. .. .. . ■ .. .. 1.00 1.0 1.00 1.0 1.00 1.0 1.00 1.0 1.00 1.0 1.00 1.0 Dec -18 Jan -19 Feb -19 Mar -19 Apr -19 May -19 Jun -19 Jul -19 Aug -19 Max mg/L = 1.0 Average mg/L = 1.0 Nitrate - Nitrogen Sep -19 Oct -19 Nov -19 Dec -19 Permit Limit 24 5.8 4.86 4.6 4.86 5.5 4.86 4.0 4.86 4.864.6 4.86 5.1 4.74 5.7 11 11 111 3.5 1 11 11 11114.9 Dec-18 Jan -19 Feb -19 Mar -19 Apr -19 May -19 Jun -19 Jul -19 Max mg/L = 5.8 Average = 4.6 120 of 127 Aug -19 Sep -19 Oct -19 Nov -19 Dec -19 Tss TSS Ave ,Permit Limit N -N N -N Aver Permit Limit 10 9 8 7 6 5 4 3 2 1 0 10.0 9.0 8.0 7.0 6.0 5.0 4.0 3.0 2.0 1.0 0.0 August 19, 2019 Regular Meeting Agenda Packet E. Coli Permit Limit 126 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.001.0 1.001.0 1.001.0 1.001.0 11 11 ■■ ■■ N■ ■■ 11 Dec -18 Jan -19 Feb -19 Mar -19 Apr -19 May -19 Jun -19 Jul -19 Aug -19 Max mg/L = 1.0 Average mg/L = 1.0 Potential for Hydrogen (pH) Sep -19 Oct -19 Nov -19 Dec -19 Permit Limit High 9 a. b 7.89 7.•1 742 -.45 7.44 7.327.417.37 7.197.347.27 7.28 7.59 7.347.627.48 7.357.457.40 7.26 '.1 5 7.57 Permit Limit Low 6 Dec -18 Jan -19 Feb -19 Mar -19 Apr -19 May -19 Jun -19 Jul -19 Aug -19 Sep -19 Max mg/L = 7.45 Min mg/L = 7.42 Average mg/L = 7.436 121 of 127 Oct -19 Nov -19 Dec -19 • E. Coli • E. Coli Ave. ■ Permit Limit pH Min - pH Max pH Aver - Permit Limit Low - Permit Limit High 10 9 8 7 6 5 4 3 2 1 0 August 19, 2019 Regular Meeting Agenda Packet Dissolved Oxygen (DO) Permit Limit Max 9 7.5 8.0 7.5 7.77 7.5 7.39 7.5 7.63 7.8 7.56 7.7 7.48 7.64 11 7.33 7.66 Permit Limit Min 6 1 Dec -18 Jan -19 Feb -19 Mar -19 Apr -19 May -19 Jun -19 Jul -19 Aug -19 Max mg/L = 8.1 Average mg/L = 7.5 122 of 127 Sep -19 Oct -19 Nov -19 Dec -19 DO DO Aver - Permit Limit Min. - Permit Limit Max ebills Bills Mailed Bank Draft Credit Card Draft Online Payments Late Notices Disconnects M Connections P ebills Bills Mailed Bank Draft Credit Card Draft Online Payments Late Notices Disconnects Connections August 19, 2019 Regular Meeting Agenda Packet Trophy Club MUD 61 Utility Billing Report 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 3921 3921 3927 3903 3856 3859 3866 3859 3878 3875 650 650 660 664 661 669 666 666 664 656 1077 1109 1103 1114 1128 1151 1152 1152 1168 1161 1157 1130 1,124 1,149 1,111 1,129 1,100 1,162 1,098 1132 402 432 439 387 431 421 342 399 346 330 29 22 33 28 27 25 36 14 25 13 3297 3299 3301 3309 3309 3314 3317 3318 3324 3326 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 Fiscal Year 2018 October November December January February March April May June July August September 796 828 829 834 839 844 841 849 848 851 860 865 3906 3900 3912 3911 3908 3913 3921 3935 3956 3946 3948 3929 631 623 639 653 657 656 655 654 660 651 654 653 1018 1020 1026 1033 1042 1056 1054 1056 1067 1068 1061 1076 1037 1079 1,072 1,065 1,086 1,097 1,019 1,080 1,084 1128 1130 1102 391 420 457 362 424 407 299 355 413 352 427 438 25 M 3257 P 1444 27 27 25 22 27 24 17 20 20 16 30 3262 3268 3272 3276 3280 3280 3284 3288 3291 3292 3294 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 123 of 127 MUD Permits Month: July 2019 August 19, 2019 Regular Meeting Agenda Packet Plumbing Sewer Date of Customer Deposit Due to FW Water 135- Inspections 135- Inspections 135- Misc Income Permit Permit No. 135-25030 20500 Oversize Meter 135-49075 47035 47045 Fire Line 135-49900 135-49900 Total 7/18/2019 2019-20 $ 75.00 $ 1,173.00 $ 343.00 $ 150.00 $ 50.00 $ 1,791.00 Total $ 75.00 $ 1,173.00 $ 343.00 $ 150.00 $ 50.00 $ 124 of 127 $ 1,791.00 140,000,000 120,000,000 100,000,000 80,000,000 60,000,000 40,000,000 20,000,000 Water Consumption Budget vs Actual 123,125,257 47 193,000 41,933,000 36,244,000 34,604,000 40,421,000 33,740,000 2,773,000 —0—Budget Actual Nov Dec Jan Feb Mar Apr May Jun Jul 1,200,000,000 1,000,000,000 800,000,000 600,000,000 400,000,000 200,000,000 0 Budgeted Water Consumption Vs Projected Actual Water Consumption 960,607,716 741,622,580 Total Consumption • Budgeted Total Consumption • Projected Actual Consumption August 19, 2019 Regular Meeting Agenda Packet 900000 800,000. 700,000 600000 500,000 400,000 300000 693053 200,000 270,765 100,000 0 Oct Water Revenue Budget vs Actual 2,425 40,959 59,299 345,355 406,145 324,297 485,760 600,420 800,720 617,040 474,975 325,801 33n179 360,534 316,799 287,952 289,939 296,662 —8—Budget Revenue —0—Actual Revenue Nov Dec Jan Feb Mar Apr May Jun Jul $7,000,000 56,000,000 $5,000,000 $4,000,000 $3,000,000 52,000,000 51,000,000 50 Budgeted Total Water Revenue Vs Projected Actual Total Water Revenue $6,599,484 S5,016,541 S3,585,990 Total Water Revenue 83,111,181 • Budgeted Total Revenue • Projected Actual Total Revenue ■ Net Budget Total Revenue Minus Budgeted Expenses • Net Projected Actual Total Revenue Minus Projected Actual Expenses Budgeted Revenues & Expenses vs YTD Revenues & Expenses YTD Expense By Departments 5550,439,05 $2,456, 05_ 56,164,868 =illiRevenues vs Expenses YTD Expenses Amended Budget Expenses Amended Budget Revenues $0 $2,03,000 $4,000,000 56,000,000 $8,000,000 $10,000,000 $12,000,000 •ttD Expense- Water •YTD Expense- WW • 130 Expense- Admin •YTD Expense- BOD • YTD Expense- Non Dept 125 of 127 CASH STATUS AS OF JULY 2019 135-10250 TexPool 0 & M (XXXXX0002)-General Fund Operating *** 135-10300 Prosperity Bank (XXX8701) General Fund Operating 135-10305 Prosperity Bank Reserve -Savings Acct (XXXXX7724) 135-11100 Petty Cash Administration 135-11150 Petty Cash Utility Billing 137-10250 TexPool 0 & M (XXXXX0002) GASB Replacement 517-10250 TexPool Construction Tax (X)XXX011) WWTP Improvements 517-10300 Prosperity Bank Construction WWTP Improvements 519-10250 Texpool Revenue Bond Construction (XXXXX015) SWIFT 519-11155 Cash -Bond Escrow Bank of Texas (SWIFT) 520-10250 Texpool Revenue Bond Water & Waste Water Systems 2019 (XXXXX018) 520-11155 Cash -Bond Escrow Bank of Texas (Water & Waste Water Systems) 528-10250 TexPool Revenue Bond Reserve (XXXXX014) WWTP Improvements 533-10250 TexPool Tax I & S (XXXXX0003) 533-10300 Prosperity Bank (XXX8701) Tax I&S 534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements 535-10250 Texpool Revenue I & S (XXXXX017) SWIFT Amount available in cash (MUD Accounts) Amount available for spending (MUD Accounts) *07/31/2019 Customer Water Deposits $312,525 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 126 of 127 August 19, 2019 Regular Meeting Agenda Packet Restricted - Unable to be spent $o $312,525 $1,193,446 $0 $0 $516,233 $726,599 $0 $0 $767,358 $577,677 $3,846,120 $770,560 $957,317 $0 $457,689 $225,393 $10,350,917 Unrestricted - Available for spending $4,809,314 $1,644,418 $0 $150 $450 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $6,454,333 1 $0 1 $6,454,333 $6,454,333 $776,543 $0 $776,543 $776,543 $776,543 Total in Accounts (Restricted & Unrestricted) $4,809,314 $1,956,943 $1,193,446 $150 $450 $516,233 $726,599 $0 $0 $767,358 $577,677 $3,846,120 $770,560 $957,317 $0 $457,689 $225,393 $16,805,250 General Fund 135 Available 1,644,418 Prosperity General Fund 4,809,314 Texpool General Fund 600 Petty Cash 6,454,333 8,486 2,173,156 5,442,543 436,907 $8,061,092 $776,543 $0 $776,543 16 I► ggi.11aNiSintlu.aai d TC Meeting Spaces Calendars FS Conference Room'' FS Training Room Svore Board Room September 2019 I•1\ 36 37 38 39 40 Sun Sep 1, 2019 8 15 22 August 19, 2019 Regular Meeting Agenda Packets& Modifier Mon Tue Wed Thu Fri Sat 2 ISI/I�IIIlL I��I�k iSY l%1I1I1' 3 4 5 9 10 11 12 6 13 Reserved for staff meetings (Laurie) 23 29 30 17 24 net 1 127 of 127 18 25 19 26 20 27 7 14 21 28 Powered by 7 team