HomeMy WebLinkAbout2020-0615 June 15, 2020 Regular Meeting Agenda PacketMonday, June 15, 2020
Nei
TROPHY CLUB
June 15, 2020 Regular Meeting Agenda Packet
BOARD OF DIRECTORS
REGULAR MEETING
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
100 MUNICIPAL DRIVE
TROPHY CLUB, TEXAS 76262
6:30 P.M. Svore Municipal Boardroom
REGULAR MEETING AGENDA PACKET
In accordance with Order of the Office of the Governor issued March 16, 2020, Trophy Club Municipal
Utility District No. 1 Board of Directors will conduct a meeting at 6:30 p.m. on Monday, June 15, 2020 by
Zoom/telephone conference. In order to advance the public health goal of limiting face-to-face meetings
(also called "social distancing") to slow the spread of the Coronavirus (COVID-19), there will be no public
access to the location described above, but members of the public may join the meeting by weblink or
telephone by following the instructions below. A recording of the telephonic meeting will be made and
will be available to the public.
To join the meeting via Zoom: https://us02web.zoom.us/i/86164493466
The public toll-free dial -in numbers to participate in the telephonic meeting are: 1 888 475 4499 and
1 877 853 5257; Meeting ID: 861 6449 3466
If you cannot get through on one of the numbers due to network congestion or if the audio quality is poor,
please try the next number.
When your call is answered you will hear "Welcome to Zoom, enter your Meeting ID followed by pound."
Enter in the following Meeting ID below followed by the pound sign (#): Meeting ID: 861 6449 3466
CITIZEN COMMENTS:
Public comment will be allowed during the Citizen Comment agenda item. No in-person input will be
allowed. Members of the public that desire to provide public comment may do so by videoconference, by
telephone or by submission of written comments.
Written public comments that are timely received will be read into record and can be emailed to
Islaght@tcmud.org . Written comments must be received by 4:00 p.m. on the date of the meeting. To
provide verbal public comment remotely (by videoconference or telephone), members of the public must
register in advance by emailing Islaght@tcmud.org prior to 4:00 p.m. on the date of the meeting.
CALL TO ORDER AND ANNOUNCE A QUORUM
CITIZEN COMMENTS
This is an opportunity for citizens to address the Board on any matter whether or not it is posted on the agenda.
The Board is not permitted to take action on or discuss any comments made to the Board at this time
1 of 150
June 15, 2020 Regular Meeting Agenda Packet
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. Citizen Comments should be limited to matters over which the Board has
authority.
CONSENT AGENDA
All matters listed on the 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. May 2020 Check Register
b. May 18, 2020 Regular Meeting Minutes
attachments: May Check Register
May 18, 2020 Meeting Minutes
REGULAR SESSION
2. Introduction of new General Manager Alan Fourmentin (Steve Flynn)
3. Consider and take appropriate action regarding proposals received for Annual Financial Auditing Services
and award Contract No. 2020061501; and authorize the General Manager to execute the necessary
documents. (Chapman/Flynn/Krolczyk)
attachments: Auditor Score Summary
Contract No. 2020061501
4. Consider and take appropriate action to select two (2) Directors to participate on the Budget Review
Committee. (Krolczyk)
5. Consider and take appropriate action regarding District bank signatories including:
a. Approve Resolution No. 2020-0615A designating authorized signers on Prosperity Bank accounts.
b. Approve Resolution No. 2020-0615B designating depository designating authorized signers on
Texpool Accounts.
attachments: Resolution No. 2020-0615A
Resolution No. 2020-0615B
6. Discussion and possible action regarding District Payment and Billing Policies. (Wilson)
7. Consider and take appropriate action regarding the May 2020 Combined Financials and Variance Report.
(Krolczyk)
a. Combined Financials
b. Combined Variance
2 of 150
June 15, 2020 Regular Meeting Agenda Packet
attachments: Combined Financials
Combined Variance
REPORTS & UPDATES
8. Staff Updates:
a. Capital Improvement Projects
b. Water Operations Report
c. 2019 Consumer Confidence Report (CCR)
d. Wastewater System Reports
e. Finance Reports
attachment: General Manager Report
EXECUTIVE SESSION
9. Pursuant to Section 551.071 of the Texas Open Meetings Act, the Board may consult with its attorney in
Executive Session on a matter in which the duty of the attorney to the Governmental Body under the
Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflicts with the Open
Meetings Act or to seek advice of counsel on legal matters involving pending or contemplated litigation
or settlement offers:
a. Contractor breach, performance and payment issues related to District's contract with Webber-
Cadagua Partners for construction of the Wastewater Treatment Plant Improvements; and
b. Trophy Club Municipal Utility District No. 1 v. Acadia Services, LLC, In the District Court of Tarrant
County, 141st Judicial District (Cause No. 141-299351-18).
c. Potential Condemnation of Easements required for construction and operation of Water
Transmission Line Improvements from District Pump Station to Elevated Water Tank located on T.W.
King Road.
d. Potential modification or termination of Independent Contractor Agreement dated August 1, 2017,
as subsequently amended, for independent contractor services relating to pending litigation matters,
condemnation proceedings, completion of wastewater treatment plant project, and other pending
District projects.
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, Lease or Exchange of District real property located at 100 Municipal Drive, 1501 Junction Way
and other real property owned by the District.
b. Purchase of Easements required for construction and operation of Water Transmission Line
Improvements from District Pump Station to Elevated Water Tank located on T.W. King Road
3 of 150
June 15, 2020 Regular Meeting Agenda Packet
REGULAR SESSION
11. Consider and take appropriate action on matters deliberated in Executive Session:
12. Discussion and possible action relating to modification or termination of Independent Contractor
Agreement dated August 1, 2017, as subsequently amended, for independent contractor services
relating to pending litigation matters, condemnation proceedings, completion of wastewater treatment
plant project, and other pending District projects.
13. Items for future agendas:
14. Set future Meeting dates:
a. Regular Board Meeting on July 20, 2020 at 6:30 p.m.
b. Joint Meeting with Town Council regarding FY2021 Fire Department Budget
attachment: July Meeting Calendar
*THE BOARD RESERVES THE RIGHT TO ADJOURN INTO EXECUTIVE SESSION AT ANY TIME DURING THE
MEETING PURSUANT TO THE APPLICABLE SECTION OF SUBCHAPTER D, CHAPTER 551, TEXAS GOVERNMENT
CODE, THE TEXAS OPEN MEETINGS ACT, WITH RESPECT TO ANY ITEM ON THE AGENDA. NO FINAL ACTION,
DECISION OR VOTE WILL BE TAKEN ON ANY SUBJECT OR MATTER IN EXECUTIVE SESSION. THIS NOTICE
MODIFIES THE DISTRICT'S PRIOR PRACTICE OF SPECIFICALLY IDENTIFYING ALL AGENDA ITEMS TO BE
DISCUSSED IN EXECUTIVE SESSION.
ADJOURN
4 of 150
Tckamt2 skrolazyk
Begin Date: 05/01/2020 End Date: 05/31/2020
Number -
998 »19L AN REAL PM
Tbtals for Check: 6400
In :ace
D001002006110
From amt:
Inv pert AOCCnnt
Date - Stat _ .NCS Nuaber
04/30/20 P
998 CB JENI HCMSs-TROPHY Cites-idC- U00100001 ODA 04/30/20
Totals.for (heck: 6401
998 MIRY, DAN /EL
Totals for Check: 6402
996 DAL-RESIDENTIAL"1 LLC
Totals for Check: 6103
996 MESS, DON
Totals far C21edk: 6404
. 996-FERDL, BARRY
7bi a7 s for C beck: 6405
x001005042410
135-20050-000-000
P -135-.20050-000-000_
135-20050-000-000
2 135-20050=000-000
P 135-20050-000-000
04/30/20 P
170010080604105A 04/30/20
00030121499205A 04/30/20
00020001099273! 04/30/20 "2
TroOhy clth Nw No.1
AP Checks For Date/Amount Rarer
.00 Tb Ani: 99,999,999.99
Desdription
A/P Vers
A/P Veodars
A/P Venders
A/P Vers
A/P Veadass
135-20050-000-000 A/P Vendors
998 iii, PATRICIA x0023150021204X 04/30/20 P 135-20050-000-000 A/P Vendars
Totals for Check: 6406
x0010070466101A 04/30/20 P 135-20050-000-000.. 7/2 Verrs
998 KE i, AARON 110022080005202A 04/30/20 P 135-20050-000-000 A/P Vendors
Totals for Check: 6408
998 NICi/60N,.BRAN' x0020001075219A-04/30/20 _P 135-20050000-000.- - A/PVeredrs
Thtal8 for Check: 6409.
998 NITSCHKE, FELIX AND SYLVIA 000200009682057. 04/30/20 P 135-20050-000-000 A/2 Vendars
Totals for Check: 6410
996. swim., RC6 d' 1:0050360004105A 04/30/20 P 135-20050-000000 A/PVendors
TOtale far Cii@c1s: " 6411
998 SWEATT, JERRY 09012510009902A 04/30/20 9 135-20050-000-000 A/P Vers
Totals for Check: 6412
998- Vii,- HAT
Totals for Check: 6407
3193 - C,LNPOPAY, INC. - -
Totals far C3sedk: 6413
2676
2676
2676
2676
2676
Humana Inc
Manna lnd
Humana Inc
IncManna
i6aa Inc
-PRO 996-05/01/20-.
155516458
155516458
155516458
155516458
155516458
05/01/20
05/01/20
05/01/20
05/01/20
05/01/20
P
P
P
2
135-21313-000-900 Cafe _1254ed4.da1 Rema -
135 -21308-000-000
135-21309-000-000
135-21311-000-000
16 135-50029-010-000
20 135.50029-020-000
Dental
Vision
Voluntary Life
Life Insurance &-Other - - Life Insurance - & Othere
5 of 150
J595920204Regular Meeting Agenda Past 1
Lacus Iwo- (seat (mem
Val a Ncaber Date
12.33 6400 05/01/20
12.33
54.44 6401 05/01/20
106.39 6402 05/01/20
106.39
53.89. 6403- 05/01/20
- 53.89
66.63 6404 05/01/20
86.63
06.94" :-6405 05/01/20-
06.94
40.66 6406 05/01/20
40.66
-04:72_ --6407- "05/01/20
-04.72
27.46 6408 05/01/20
27.46
85.76 .6.4.09 05/01/20.
85.76-
33.78 6410 05/01/20
33.78
08.70- 6411 -05/01/20 _-
08,70 08:70
49.12 6412 05/01/20
49.12
549.37 - 6413 .05/01/20
549.37
1,395.02
192.62
318.36
176.88
186,78
6414 05/01/20
6414 05/01/20
6414 05/01/20
6414 05/01/20,
6414 -55/01/20 ..
apacisamt2 skro1czyk
Begin Date: 05/01/2020 and Date: 05/31/2020
ue accr- venom- Name
a
aeN .
2676 arcane lac
Totals for Chet'.k: 6414
3124 SRS 'Faze Paynent
3124 IRS 'Paas Pay t
3124 IRS Tact Payment
Totals for Check: 6415
2943 ..7ENCRGAN CHASE SANK NA
Lbtais for Check: 6416
- -3115-_- AEMLIFB GROUP IHNEFITS
3115 9E1LIF3 MOIR aTLS
3115 NEIL= GROUP BENEFITS
3115 MBTLIPE CROUP BTPS
Totals :for (Heck: 6417
From Mat:
Irate Stat - N3 rubes
155516458 05/01/20
-PR00695 996-05/01/20
PRLi0695- 996- 05/01/20
PR00595 996.05/01/20
04272020
5/15/2020
5/15/2020
5/15/2020
5/15/2020
3113 TCORS PR00695
Tbtals for Check: 6418.
2742 Pmber Beard 051120
Totals- ft= Check: 6419
3187 LIS SHtil t"EQUIPMENT=," TNC 25094
Totals f& (Heck: 6420
2655 Core & Main LP M184918
Totals for Check: 6421
3080 i'P&Y At Ems, ' INC. 1 4:i2000070-
Totals for Check: 6422
3184 DAA LLC
. 3104:DATAPROSE ILC
Tatals far Cheek:.. 6423
1737 DPC INDUSTRIES, INC
Totals for Check: 6424
3118-33cclusive Peat antral
Totals foraeek:- 6425
2606 Fisery Solutions, LLC
Totals for Check: 6426
P
P
04/27/20 P
_05/01/20
05/01/20
05/01/20
05/01/20
30 135-50029-030-000
135-21302-000-000
135-21303-000-000 -_
135-233044100-000
135-20060-000-000
E- ---.135-21315-000-000-_-
P 10 135-50029-010-000
P 20 135-50029-020-000
P 30 135-50029-030-000
996 5/01/20:
05/11/20 P
1 04/27/20 "P
135-21317400-000
30 135-60100-030-000
20-.135-55081-020-000 -
04/23/20 P 10 135-65050-010-000
05/06/20 - P_- 20 135-69005-020-000.
D22001393 04/30/20 P 30 135-60035-030-000
D22001593 04/30/20 2- 30 - 135-5520505-030-000
767001875-20
7791
91700671
04/20/20 P 10 135-65030-010-000
03/25/20 - P- -30 135-55080-030-000
05/05/20 P 30 135-60040-030-000
-- 2635 3a1ff.Assocs.ates, INQ 10037154 - - 05/05/20 --P- -30 135-69005-030-000
ttatais -fon' Check: - 6427
Trophy Club MD No.1
AP Checks For iaate/Arra ntt Range
.00 To Int: 99,999,999.99
Life Thsuauce & Other
DM Taxes
gn,4a1- S6curity 7:axes
Medicare Taxes
Procurement Clearing
Short Term Disability
Life Insurance & Other
Life Insurance & Other
Life Insurance & Other
TCDRS
Travel & per diem
Maintea & 1 aJ. C oIlectiaaas: -
Meter Zcpense
Capital Outlays - -
Postage
Utility Billing g- Contract
C nemi.cal.s
maintenance & Repairs_
Service Charges & Fees
tel Outlays
6 of 150
Juro&&p20ffi4tegular Meeting Agenda Pah 2
Jar.- =en - cmc uamt
Value Amber rate
176.22 6414 05/01/20
2,445.88
4,806.93_ - 6415 -415/01/20."
5,841.72 - -6415 05/01/20
1,366.25- 6415 05/01/2.0.
12,014.91
2,007.14 6416 05/01/20
2,107.14. -
74.36-1 --0417 .€15/01/20
132.01 6417 05/01/20
165.74 6417 05/01/20
151.69 6417 05/01/20
523.80
7,92291 6418 05/01/2
7,922.91
306.48 6419 05/11/20
306.48-
390.21 - - 6420. 05/11/20
390.21
14,713.30 6421 05/11/20
14,713:30
9;525.00 ---6422 05/11/20
9,525.00
1,464.27 6423 05/11/20
537.64 6423 05/11/20
2,001,91
558.41 6424 05/11/20
558.41
110.00 "6425 05/11/20
-110.00
50.00 6426 05/11/20
50.00
3,669.08 6427 :05/11120-
3:.669.08 _ -
apackamt2 skrolczyk
Begin Date: 05/01/2020 End Date: 05/31/2020
vent r v mar mane
Hurter
1468 L.H. CHANEYHATFRIALS, 3, 171381
1468 L.H. �N( MATERIALS, INC. 171534
Totals far Q k: 6428
3216 -M3 Networks - -
Tatalar far 6429
3111 North Texas Groundwater
Totals for Check: 6430
3156 CEIDDR=LABOMMES LW
3156 CACCDORIaiLLC. -
3156 =DOR IAMPATCRIES ILC
3156 flims Leoussikauso LLC
1t,tals for Check: 6431
3176 - RE-31AR C IT N
3176 REY- 4W. usoaaw-4-.4 -
3176 "REY-bAR C[tISx mriCN
Totals far Check: 6432
6014"
Fran Pint:
In ide-late-Dept Acoamit
Date -Stat -No - Halter
04/25/20 P 20 135-55125-020-000
05/02/20 P 20 135-55125-020-000
04/29/20
-30- 135-69005-030-000
186 04/01/20 P 10 135-60135-010-000
20050037
20040465-
20040511
20050105
05/04/20 P: "20 "135-55235020-000
04/27/20. :P 20--135-55135-020-000_"
04/29/20 P 20 135-55135-020-000
05/07/20 P 20 135-55135-020-000
6. 05/11/20. P 10 135-69005-010400
HIM BLEWSOCIND 05/08/20 9- 20 135-69005.020-000
MIT 8 Fi FENCE 05/08/20 P 20 135-69005-020-000
2440 MEOW 2 r CIY PUBLIC HEALTH. IAB 33452
:2440 - T4YRRAt r C1Y PUBLIC -F iAB - 33453
Tbra1 q for CSieCk: 6433
2696 Texas SYceavatioo Safety Systen 20-07904
Totals for Check: 6434
1001 . TOW OF MOM? CLUB APRIL REFC78E-
1001 1stioacce TROPHY CLUB: APRIL. MUM
1001 TUN OF TROPHY CLUB APRIL REFUSE
1001 TC11U OF TROPHY CLUB 050120
Totals for Check: 6435
1000
1000
Totals
TROPHY CUB Mw 049TER 90r74)
TFC851Y. CLUB 1,.113 (WRIERRTra.r,)" for Check: 6436
04/30/20 9 10 135-55135-010-000
04/30/20" -P 10- 135-55135-010-001
04/30/20 P 30 135-60040-030-000
04/30/20
04/30/20
04/30/20
05/05/20
P - - --- -135-25040-000-000-
P_ 135-25000-000-000
P 135-25010-000-000
9 45 122-60337-045-000
03/33,26" -03/31/20 F- --30 . 13540025-030-000
4/30/20 04/30/20 -P 30---135-60025-030.000
2634 Valley Solvent Capany, INC 56180
Totals for Cheek; 6437
1058 " VERL2CHICRETZSS
1058 VERIZCNI41203L8S8
1058 VERIZONICRELESS
1058 VERIZON WIRELESS
teals- for Check- £438
__9853608143
9853608143
9853608143
9853608143
05/05/20 P 20 135-65030-020-000
05/01/20
05/01/20
05/01/20
05/01/20
P
P"
P
P
10
20
30
30
135-60010-010-000
135-60010-020-000
135-60010-030-000
135-60010-030-000
Trophy Club MUD No.1
AP Cheres For nate/Amount Range
.00 TO ant: 99,999,999.99
Description
tumpeter Services
0aipoter Service
Capital Outlays
TOM Fees 8 Permits
Laix- Analysis
lab Aknal.ysis
Lab Analysis
lab Analysis
Capital Outlays--
Capital Outlays
Capital Outlays
Lab Analysis
Laic Analysis for PID
Service Charges & Fees
Tbs+a-Stcu3n Irainage.
I base
Refuse Tax
Transfer to /Fire Budget
Water"
Seater
Chemicals
Catrani.attircs/Hcbilee
Ckmmuni.catia a/Mobiles
Crenunicaticros/Mobiles
Ckimcaiicatitns/Mabiles
Juri0304k020i1fiegular Meeting Agenda Pao 3
!lane lean - cs�er�c
Value - Hunter Date
1,259.84 6428 05/11/20
2,471.32 6428 05/11/20
3,731.16
4,866.55 6429: 05/11/20.
4,866.55
3,262.20 6430 05/11/20
3,262.20
341.55 .4431 05/11/20..
341.55 6431 05/11/20
241.50 6431 05/11/20
241.50 6431 05/11/20
1,166.10
87,311.25 6432' 05/11/20
71,496.00 -5432'05/11/20.--
49,978.00 6432 -05/11/20
208,785.25
220.00 6433 05/11/20
80.00 6433 05/11/20
300. [10
252.70 6434 05/11/20
252.70
34,820.92 6435 05/11/20"
64,875;39 6435-05/11/20
5,439.38 6435 05/11/20
59,888.08 6435 05/11/20
165,023.77
504,30 6436 05/11/20
1,354.70 6436 05/11/20
1,859.00
580.00 6437 05/11/20
580.00
385.40 -- 6438 : -05/11/20
407.91 6438 05/11/20
(150.00} 6438 05/11/20
99.26 6438 05/11/20
742.57
7 of 150
apackarr-2 skrolczyk
Begin Date: 05/01/2020 End Date: 05/31/2020
verso= - veer= Name
. Umber
3280 WATT" Puss -ON LLC
3280 WATTS EELI91 IZC
Totals far Check: 6439
2222 - - AFDC:. . . .
2222 AMC: . .
Totals for Check: 6440
3197 HenefitMall
3197 :.BereiHtMall.
3197 Teug,fttMall
Tota1.8 #tar Check: - - 6447.
3262 BRANDON R REED
Totals far Check: 6442
2683 C3aarter tbtstnicatic es
'Ibtala for check: 6443
2655 Care & Main LP
Totals far Check: 6444
3393 O:HPIiPAY, :DC.
Totals for cheek: 6445
2497
2497
2497
2497
2497"
2497
DHS AUPCNATION, 1N
DIS AUDOMATICV, iNC
pas AtTICHATICU, INV
DHS ANTO 7AT 4; INV
DHS ;INC.
DHS AllICKATICil, 324;
Ibtals for Check: 6446
2635 Half/ Associates, INC
2635 Haiff Associates, 11
Totala- far Cheek: 6447
1372 HACH COMPANY'
Totals for (heck: 6448
2676
2676
2676
2676
Humem a Fisc
Humana Inc
Humana Inc
Huns= Imre
2676 Humana Inc
2676 Humana Inc
Totals -16r Cheek: 6449
13:670132e turner m a 1Av Ac count
Bate Stet kb Barber
Arm:
23186 05/04/20 P 10 135-60285-010-000
23186 05/04/20 P 20 135-60285-020-000
P800695 996:05/01/20 -P 335-21312-000-000-
9800696 996.05/15/20 ,P - 135-21312-000-000
9048516 -IN
9048516-12
9048516.1N
05/14/20 P 10 135-50029-010-000
05/14/20. P 20 .135-50029-020-000
O 5/14/20 -9 30 135-5002$-030-000
2892 05/12/20 P 30 135-55080-030-000
-71672050620.. 05/06/20 : P 30 135-55030=030-000
M281188 05/11/20 P 10 135-55080-010-000
96 . 996 05/15/20 - , -
06-1970
06-1971
06-1972_
06-1973 .-
06-1974:
06-1977
10037606
10037600
11949673
155516885
1.55516885
155516885
155516885
155516885
155516885
05/12/20
05/12/20
05/12/20
05/12120
O 5/12/20
05/12/20
-1357121313400-000
P 20 135-55080-020-000
P 20 135-55080-020-000
P 20 "135,55080-020-000
P 20 :13555080-020-000
P 20 :135-55080-020-000:
P 20 135-55080-020-000
05/17/20 .P 30 135-69005-030.000
05/17/20" -:P 10 520-69005',010000
05/06/20 P 10 135-65030-010-000
06/01/20
06/01/20
06/01/20
06/01/20
06/01/20
-06/01/20
P
P-"
P
P
P
-135-21308-000-000
135-21309-000-000
135-21311-000-000
10 135-50029-010-000
20 135-50029-020-000
30 -135-50029-030-000
Txnphy Cab NUD Na.1
AP checks Fbr Date/Amount Range
.00 Ta Amt: 99,999,999.99
DeSCriptial,
La9xi Equipment & Maintenance
_._ Equipment & Maintenance
Aflac-
A£lac
Life Insurance & Other
Life Insurance & Other -
Life Insurance &- Other
Maintenance & Repairs
Software &: Support
Maintenance & Repairs
Cafe 125-MediRehab
Maintenance & Rg3airs
Maintenance & Repairs
:Maintenance & Repairs
6 RepaLire
Maintenance & Repairs
Maintenance & Repairs
Capital Outlays
Capital Outlays
Chenica1a
Dental_
Visite
Voluntary Life
Life Insurance & Other
Life Insurance & Other
Life is,nurance &-Other
8 of 150
Jmapaly5g20.7304degular Meeting Agenda Past 4
t zne sten meek taint
Value Neer IIste-
750.00 6439 05/11/20
890.00 6439 05/11/20
1,640.00
210.67- 6440 05/21/20 -_
210.67 - 6440 05/21/20
421.34
20.00
32.00
16,00
68.00
6441
6441
6441
05/21/20
05/21/20
05/21/20.
285.00 6442 05/21/20
285.00
899.00:-- 6443 05/21/20
899.00
3,931.20 6444 05/21/20
3,931.20
549_37 ; 6445 -05/21/20"
:549.37
632.00
490.00
750.00
1,460.00-
774.00
1,310.00
5,416.00
6446 05/21/20
6446 05/21/20
6446 05/21/20
6446 15/21/20
6446. 05/21/20
6446 05/21/20
1,170.62 6447 05/21/20
10,690.00 6.447 05/21/20
11,860-62
1,008.16 6448 05/21/20
1,008.16
1,395.02
192.62
318.36
176.88
186.78
176..22
2,445.88
6449
6449
6449
6449
6449
6449
05/21/20
05/21/20
05/21/20
05/21/20
05/21/20
05/21/20
aparkamt- skrolczyk
Begin Date: 05/01/2020 Sad Date: 05/31/2020 Fr m Pmt:
Trophy Club Nam No.1
AP Checks 9br Date/Amount Range
.00 Tb Amt: 99,999,999.99
vete ,' _ "VenC10r- Naue - - _ - - - InVDiis~ rower - Jnvzlace. -Inv. "Dept account "
NbObec `Mate "--Stat No. N.rher
2775 HCOkSST ENEMY SERVICES; LLC 2005150001-19 05/15/20 P 10 135-60020-010-000 Electricity
2775 HUDSON ENERGY SERVICES, ILC 2005150001-19 05/15/20 P 20 135-60020-020-000 Electricity
Totals for Check: 6450
3124 -- IRS flax.- Pam -
3124 IRS:Tax 1,4sept
3124 IRS Tax Payment
Totals for Check: 6451
2735: Oac ksan 1+Ta]ker 141./=,
Meals for 3 ck; 6452
9880696 996 05/15/20 P 135-21302-000-000- Pili ides
PR00696 996'05/15/20 P 135-21303-000-000 Social Security Taxes "
PR00696 996 05/15/20 P 135-21304-000-000 Medicare Taxes
haistolAp20i334F2egular Meeting Agenda Pam 5
1tFe(? Item - "'.ileac Laze=
:Value
Va1u INuMbDate.- .
9,128.56 6450 05/21/20
10,912.04 6450 05/21/20
20,040.60
4,958.84'. 6451 05/21/20
5,995.04 6451 05/21/20 -_
1,402.00 6451 05/21/20
12,355.88
4714556 05/14/20 P 10 520--69005-010-000 i tai 0ut1ays 5,128.65 6452 _05/21/2.
5,128,65
3167 REESTCNE.PARK SEM 161575 05/13/20 P 30 135-60005-030-000
Totals for Check: 6453
3132 Legai Shield PR00695 996 05/01/20 P 135-21310-000-000
3132. r.01.0 al4 2800696 996.05/15/20 P 135-21310-000-000
Totals" for Check: 6454
3216 M3 Networks 6060 05/15/20 P 30 135-55030-030-000 Software & Support
Totals for Check: 6455
2712" MAS BI03QO t90; CIT, INC" 5l 1009 05/04/20 - P 20 135-65030-4220-000:- - Cle niEa3.8
Totals for -Caeck: -- 6456
2643 Yr -Lean & Howard, L.L.P. 36637 04/30/20 P 39 135-55045-039-000
530.99 6453 05/21/20
530.99
17.46. 6454 05/21/20
17.44 6454 05/21/20
34.90
494.00 6455 05/21/20
494.00
1,628.92 _":6456 .05/21/20_
1,.628-.92-
4,842.50 6457 05/21/20
Totals for Check: 6457 4,842.50
3186 146113WS BUILD= MAINIENANCE 1C20042E3W 04/30/20 P 20--135-55120-020.000 Cleaning Services
3165 'B:BOIID}33 E :2C20041CS 04/30/20: . P 30 1.35-55120-030-000 Clsaning`Services
3186 MEMMVS 501131143 MAIHI NCE 31:2004312&D 04/30/20 P 10 135-55120-010-000 Cleaning Services
Totals forCheck: 6458
87.50 6458 05/21/20
1,896.92 6458 05/21/20
87.50 6458 05/21/20
2,071.92
3115 r rrI COMP ME= 6/15/2020 . - . 06/01/20" P - 135-2131.5-000-000 Start. TennDisability 74.36 6459 05/21/20
. 3115 1m-COUAP_BMS 6/15/2020 06/01/20 . P '10 135-50029-010-000 .Life.IUst & C)kher--- 132.01 "6459 05/21/20
3115 MSPLLPE GROUP BENEFITS 6/15/2029 06/01/20 P. 20 135-50029-020-000 T fe Insurance & Other ' - 165.74 6459 05/21/202-
3115 1 TLIPE GROUP BENEFITS 6/15/2020 06/01/20 P 30 135-50029-030-000 Life Insurance & Other 151.69 6459 05/21/20
Totals for Check: 6459 523.80
1056 OFFICE 01 Tr,DC 486163052001_. 05/01/20 - P 30 135-65085-030-000- Offioe-applies 55.36 6460 05/21/20
tale for Check 6460 - 55.36
3156 anOORLABCRA1CRIMS TUC 20050177 05/13/20 P 20 135-55135-020-000 lab Analysis 241.50 6461 05/21/20
3156 oxioatIAKERATCRIES LTC 20050138 05/11/20 P 20 135-55135-020-000 Lab Analysis 326.70 6461 05/21/20
3156 OXIDOR LA8K3A'T, ILC 20050287 05/18/20 P 20 135-55135-020-000 Lab Analysis 341.55 6461 05/21/20
-3156 OKL IABCRtA2tf1 -car-- - 20050301 - :05/19/20 --P - 20 135-55135-020-000 - _ LabAnalysis- - -. 241.50- -6461. 05/21/20
Totals fOr theck3 6461 1.1.51.25
9 of 150
apacicant2 skrrlczyk Trophy Club 1W No.1
AP Checks For Date/Anrnmt Range
Begin Date: 05/01/2020 End late: 05/31/2020 F au Amt: .00 To Ate: 99,999,999.99
uenr r WOO= Male
Number
3176 REY-MAR OCUMICCTICH
Juiefol p201Z04Flegular Meeting Agenda Paeket 6
- Invoice taxnaer DIVOI.Ce ` .1X17 . -Dept ACCMIt - - - Ute' iptiCtl - - - - - 1 d,w -.Lte l - 1.'11eCA - - - meekDate Stat No - Ember- Value Air i7ate
20 TN LINE STOP 05/01/20 P 10 135-69005-010-000 Capital Outlays 69,874.48 6462 05/21/20
Totals for Check: 6462 69,874.48
2743- Stephen, Necker 111819 05/20/20- P 10- 135755080-010-000 - _14eintenanas & Repairs 500.00 6463 05/21/200
2743- Stephen -N - 040220 04/02/20 P 10 135-55080-014-000 4ai.ntenance & Repairs 257.25 6463 05/21/20
2743 StePtenttaracer 04022020 04'/02/20 P 10 135-55080-010-000 24a ate+anf 4 Repairs ` 235..74' 6463 05/21/20
Totals far Check: 6463 992.99
3113 'iias PR00696 996 05/15/20 P 135-21317-000-000 'rriBS 8,265.58 5464 05/21/20
Totals Bar. Check. -6464 8,265.58
3282 -33AR CSt7187041 05./07/20 --P -=30- 135=69170-030-000 Copier Lease Installments 165.00 : 6465 05/21/20
'lbrals for Check: 6465 165.00
1001 TOWN OF TROPHY CLUB 051920 05/19/20 P 30 135-60020-030-000 Electricity/Gas 458.22 6466 05/21/20
. Totals - far Check: - 6456 458.22-
1081: IMILIOUNWEIXTRIC 77059896 - 05/05/20 F _ 20 -135-60020-020000 - 8%ectr5city 528.61 6467- 05/21/20
ToFaIs far Check: 6467 528.61
1087 1HITAKEt CHALK SWINDLE 259947 05/21/20 P 20 517-69005-020-000 C3pital Outlays 1,487.50 6468 05/21/20
Ibtale:for Check: _-6468 1,487.50
2716 Wilma, 7anney,.Elstner As. -- .0451255 - 05/24/20 -P 20. 517-69005-020-000- - Olathe]. Outlays 4,055c00 6469 05/21/20
Totals for Check: 6469 4,065.00
2879 ATTORNEY GEINEIRAWSTATE OF TX X2020 05/19/20 P 10 135-70040-010-000 BandRelated Expanses 1,220.00 6501 05/20/20
Totals far Check: 6501 1.220.00-
CYand'%tals; 612,369,24
.a***** god of 14„,,,,,..*****.
10 of 150
June 15, 2020 Regular Meeting Agenda Packet
REGULAR ZOOM MEETING MINUTES
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
BOARD OF DIRECTORS
May 18, 2020 at 6:30 P.M.
Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in
Regular Session Meeting on Monday, May 18, 2020 at 6:30 P.M., in a Zoom video/telephone conference in
accordance with the Governor's emergency proclamation suspending certain provisions of the Texas Open
Meetings Act effective March 16, 2020 in response to the COVID-19 virus and was open to the public.
STATE OF TEXAS §
COUNTIES OF DENTON AND TARRANT §
BOARD MEMBERS PRESENT:
Gregory Wilson President
William C. Rose Vice President
Steve Flynn Secretary/Treasurer
Kelly Castonguay Director
Mark Chapman Director
STAFF PRESENT:
Mike McMahon
Laurie Slaght
Steven Krolczyk
Tony Corbett
Acting General Manager
District Secretary
Finance Manager
General Legal Counsel
GUESTS PRESENT:
Andrew Friedman Samco Capital
Jack Taylor Fire Chief
CALL TO ORDER AND ANNOUNCE A QUORUM
President Wilson announced the date of May 18, 2020, called the meeting to order and announced a quorum
present at 6:31 p.m.
CITIZEN COMMENTS
There were no citizen comments
CONSENT AGENDA
1. Consider and take appropriate action to approve the Consent Agenda.
a. April 2020 Check Register
b. April 20, 2020 Regular Meeting Minutes
Motion made by Director Chapman and seconded by Director Flynn to approve the consent agenda as
presented.
Motion carried unanimously
11 of 150
June 15, 2020 Regular Meeting Agenda Packet
REGULAR SESSION
2. Consider and take appropriate action to approve purchase of replacement emergency rescue equipment
from Hurst Jaws of Life, Inc. at a total cost of $31,679 for Trophy Club Fire Department.
Motion made by Director Rose and seconded by Director Chapman to approve the purchase of Hurst Jaws
of Life from MES (Municipal Emergency Services) for the replacement of emergency rescue equipment for
the Trophy Club Fire Department for an amount not to exceed $31,679.
Motion carried unanimously
3. Consider and take appropriate action relating to potential issuance of Trophy Club Municipal Utility
District No. 1 Unlimited Tax Refunding Bonds, Series 2020 in a principal amount not to exceed $1,220,000
(the "Bonds"):
a. Receive report and recommendations from Financial Advisor regarding potential sale and issuance
of the Bonds;
b. Adopt Order Authorizing the Issuance of the Trophy Club Municipal Utility District No. 1 Unlimited
Tax Refunding Bonds, Series 2020; Prescribing the Terms and Provisions Thereof; Making Provision
for the Payment of the Interest Thereon and Principal Thereof; Authorizing the Sale of the Bonds;
Approving a Purchase Contract, a Paying Agent/Registrar Agreement and an Escrow Agreement; and
Containing Other Provisions Relating to the Subject;
c. Approve Payment of Attorney General Bond Review Fee; and
d. Authorize the District Officers, General Manager, Legal Counsel and Financial Advisor to take such
actions as may be necessary, appropriate or convenient to complete the issuance, sale and delivery
of the Bonds, including execution of all agreements and documents related thereto.
Motion made by Director Flynn and seconded by Director Chapman to approve the issuance of Trophy
Club Municipal Utility District No. 1 Unlimited Tax Refunding Bonds, Series 2020 in a principal amount not
to exceed $1,220,000; and
a. Receive report and recommendations from Financial Advisor regarding potential sale and issuance of
the Bonds;
b. Adopt Order Authorizing the Issuance of the Trophy Club Municipal Utility District No. 1 Unlimited Tax
Refunding Bonds, Series 2020; Prescribing the Terms and Provisions Thereof; Making Provision for the
Payment of the Interest Thereon and Principal Thereof; Authorizing the Sale of the Bonds; Approving
a Purchase Contract, a Paying Agent/Registrar Agreement and an Escrow Agreement; and Containing
Other Provisions Relating to the Subject;
c. Approve Payment of Attorney General Bond Review Fee; and
d. Authorize the District Officers, General Manager, Legal Counsel and Financial Advisor to take such
actions as may be necessary, appropriate or convenient to complete the issuance, sale and delivery of
the Bonds, including execution of all agreements and documents related thereto.
Motion carried unanimously
12 of 150
June 15, 2020 Regular Meeting Agenda Packet
4. Consider and take appropriate action to elect officers of the Board of Directors.
Director Wilson called for nominations for Board President.
Director Castonguay nominated Director Flynn for President.
For: Wilson, Rose, Chapman, Flynn, Castonguay
Oppose: none
Director Flynn will serve as Board President.
Director Wilson called for nominations for Board Vice President.
Director Chapman volunteered to be Vice President of the Board.
For: Wilson, Rose, Chapman, Flynn, Castonguay
Oppose: none
Director Chapman will serve as Vice President of the Board.
Director Wilson called for nominations for Board Secretary/Treasurer.
Director Flynn nominated Director Rose for Secretary/Treasurer of the Board.
Director Rose stated he would prefer that Director Castonguay have the opportunity to serve in the
position.
Director Rose nominated Director Castonguay for Secretary/Treasurer of the Board.
For: Wilson, Rose, Chapman, Flynn
Oppose: none
Abstain: Castonguay
Director Castonguay will serve as Secretary/Treasurer of the Board.
5. Consider and take appropriate action to adopt Order No. 2020-0518B declaring a truck hitch and light
poles to be to be surplus property of the District and authorizing staff to sell such surplus property.
Motion made by Director Chapman and seconded by Director Castonguay to adopt Order No. 2020-0518B
declaring a truck hitch and light poles to be to be surplus property of the District and authorizing staff to
sell such surplus property.
13 of 150
June 15, 2020 Regular Meeting Agenda Packet
Motion carried unanimously
6. Discussion and possible action regarding District Payment and Billing Policies. (Wilson)
Director Wilson moved to Table this item until June. With no objection, the item is Tabled.
7. Consider and take appropriate action regarding the April 2020 Combined Financials and Variance Report.
a. Combined Financials
b. Combined Variance
Motion by Director Flynn and seconded by Director Castonguay to approve the April 2020 Combined
Financials and Variance Reports.
Motion carried unanimously
REPORTS & UPDATES
8. General Manager Monthly Reports and Update:
a. Regulatory Update
b. Capital Improvement Projects
• Wastewater Treatment Plant Upgrade Project
• High Service Pump
c. System Repairs & Maintenance
d. Water System Operations
e. Wastewater System Operations
f. Finance Update
• Utility Billing Report
• Disconnects and late fees report
• Permits Collected
• Cash Report
Acting General Manager Mike McMahon provided the monthly reports to the Board and answered
questions related thereto.
The Board convened into Executive Session at 7:21 p.m.
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
14 of 150
June 15, 2020 Regular Meeting Agenda Packet
or settlement offers:
a. Contractor breach, performance and payment issues related to District's contract with Webber-
Cadagua Partners for construction of the Wastewater Treatment Plant Improvements; and
b. Trophy Club Municipal Utility District No. 1 v. Acadia Services, LLC, In the District Court of Tarrant
County, 141st Judicial District (Cause No. 141-299351-18).
c. Potential Condemnation of Easements required for construction and operation of Water
Transmission Line Improvements from District Pump Station to Elevated Water Tank located on T.W.
King Road
10. Pursuant to Section 551.072 of the Texas Open Meetings Act, the Board may deliberate the purchase,
exchange, lease, or value of real property if deliberation in an open meeting would have a detrimental
effect on the position of the governmental body in negotiations with a third person:
a. Sale or Exchange of District real property located at 100 Municipal Drive, 1501 Junction Way and
other real property owned by the District.
b. Purchase of Easements required for construction and operation of Water Transmission Line
Improvements from District Pump Station to Elevated Water Tank located on T.W. King Road
11. Deliberations pursuant to Section 551.074(a)(1) of the Texas Open Meetings Act regarding the
appointment, employment, evaluation, reassignment, duties, discipline, or dismissal of a public officer
or employee: Hiring a General Manager.
The Board reconvened into Regular Session at 8:15p.m.
REGULAR SESSION
President Wilson stated that no final decisions, actions, or votes were made in Executive Session.
12. Consider and take appropriate action on matters deliberated in Executive Session:
13. Consider and take appropriate action relating to approval of employment contract with new General
Manager.
Motion by Director Flynn and seconded by Director Castonguay to approve the employment agreement,
date to be determined, between Trophy Club Municipal Utility District No. 1 and Alan Fourmentin for the
position of General Manager and with a mutually agreeable effective date.
Attorney Corbett clarified that by not setting the effective date of the employment agreement, the Board
authorizes the General Manager Hiring Committee to negotiate the effective date with Mr. Fourmentin.
The Board acknowledged that is understood.
15 of 150
June 15, 2020 Regular Meeting Agenda Packet
Motion carried unanimously
14. Items for future agendas: Agenda Item 6.
15. Set future Meeting dates - Regular Board Meeting on June 15, 2020 at 6:30 p.m.
ADJOURN
Director Castonguay moved to adjourn.
Director Wilson called the meeting adjourned at 8:18 p.m.
Gregory Wilson, President
Steve Flynn, Secretary/Treasurer
Laurie Slaght, District Secretary
16 of 150
(SEAL)
June 15, 2020 Regular Meeting Agenda Packet
Request for Proposal Professional Audit Services
May 2020 Score Summary
Clifton Larson Rod L. Abbott,
Did the submitted proposals provide the following: Allen LLP CPA PLLC
RFP Complete Yes Yes
Prior experience auditing water districts. Yes Yes
Prior experience auditing similar governmental entities. Yes Yes
Prior experience auditing similar nonprofit entities. Yes Yes
Adequate size of the CPA Firm. Yes Yes
Audit team qualifications. Yes Yes
Overall supervision to be exercised. Yes Yes
Prior experience of audit team. Yes Yes
Presentation of work to be performed. Yes Yes
Realistic time estimates of each audit step. Yes Yes
Prior experience with single audits. Yes Yes
Price Yes Yes
Alan Fourmentin Score
96 93
Mike McMahon Score
82 78
Steven Krolczyk Score
92 85
Director Chapman Score
Director Flynn Score
100 87
89 63
Average Score
91.8 81.2
Proposed Rates
FY 2020 $25,000 $18,670
FY 2021 $25,375 $18,950
FY 2022 $25,756 $19,450
FY 2023 $26,142 $20,100
FY 2024 $26,534 $20,950
Total $128,807 $98,120
17 of 150
June 9, 2020
Board of Directors and Management
Trophy Club Municipal Utility District No. 1
100 Municipal Drive
Trophy Club, Texas 76262
Junt AS(di g l nyi_rting Agenda Packet
801 Cherry Street, Suite 1400
Fort Worth, TX 76102
817-877-50001 fax 817-877-5330
CLAconnect.com
We are pleased to confirm our understanding of the terms and objectives of our engagement and the nature
and limitations of the audit and nonaudit services CliftonLarsonAllen LLP ("CLA," "we," "us," and "our") will
provide for Trophy Club Municipal Utility District No. 1 ("you," "your," or "the entity") for the year ended
September 30, 2020, 2021, 2022, 2023, and 2024.
Chris Knopik, CPA, CFE is responsible for the performance of the audit engagement.
Audit services
We will audit the financial statements of the governmental activities, each major fund, and the aggregate
remaining fund information, which collectively comprise the basic financial statements of Trophy Club Municipal
Utility District No. 1, as of and for the year ended September 30, 2020, 2021, 2022, 2023, and 2024, and the
related notes to the financial statements.
The Governmental Accounting Standards Board (GASB) provides for certain required supplementary information
(RSI) to accompany the entity's basic financial statements. The following RSI will be subjected to certain limited
procedures, but will not be audited:
1. Management's discussion and analysis.
2. Budgetary comparison schedules.
3. GASB -required supplementary pension and OPEB under modified reporting.
We will also evaluate and report on the presentation of the supplementary information accompanying the
financial statements in relation to the financial statements as a whole.
The information accompanying the financial statements will not be subjected to the auditing procedures applied
in our audit of the financial statements and our auditors' report will not provide an opinion or any assurance on
that information.
We will also evaluate and report on the presentation of the following supplementary information other than RSI
accompanying the financial statements in relation to the financial statements as a whole:
1. Texas Commission On Environmental Quality Supplemental Information
a. TSI -1 Services and Rates
b. TSI -2 General Fund Expenditures and other Financing Uses
c. TSI -3 Temporary Investments
d. TSI -4 Taxes Levied and Receivable
Aft&A member of
Nexia
International 18 of 150
June 15, 2020 Regular Meeting Agenda Packet
June 9, 2020
Trophy Club Municipal Utility District No. 1
Page 2
e. TSI -5 Long -Term Debt Service Requirements — By Years
f. TSI -6 Changes in Long -Term Bonded Debt
g. TSI -7 Comparative Schedules of Revenues and Expenditures — Five Years
h. TSI -8 Board Members, Key Personnel and Consultants
Nonaudit services
We will also provide the following nonaudit services:
• Preparation of your financial statements and related notes.
• Preparation of adjusting journal entries, if required.
Audit objectives
The objective of our audit is the expression of opinions about whether your basic financial statements are fairly
presented, in all material respects, in conformity with accounting principles generally accepted in the United
States of America (U.S. GAAP). Our audit will be conducted in accordance with auditing standards generally
accepted in the United States of America (U.S. GAAS) and the standards for financial audits contained in
Government Auditing Standards, issued by the Comptroller General of the United States, and will include tests of
your accounting records and other procedures we consider necessary to enable us to express such opinions. We
will apply certain limited procedures to the RSI in accordance with U.S. GAAS. However, we will not express an
opinion or provide any assurance on the RSI because the limited procedures do not provide us with sufficient
evidence to express an opinion or provide any assurance. We will also perform procedures to enable us to
express an opinion on whether the supplementary information (as identified above) other than RSI
accompanying the financial statements is fairly stated, in all material respects, in relation to the financial
statements as a whole.
We will issue a written report upon completion of our audit of your financial statements. We cannot provide
assurance that unmodified opinions will be expressed. Circumstances may arise in which it is necessary for us to
modify our opinions, add an emphasis -of -matter or other -matter paragraph(s), or withdraw from the
engagement. If our opinions are other than unmodified, we will discuss the reasons with you in advance. If
circumstances occur related to the condition of your records, the availability of sufficient, appropriate audit
evidence, or the existence of a significant risk of material misstatement of the financial statements caused by
error, fraudulent financial reporting, or misappropriation of assets, which in our professional judgment prevent
us from completing the audit or forming opinions on the financial statements, we retain the right to take any
course of action permitted by professional standards, including declining to express opinions or issue a report,
or withdrawing from the engagement.
We will also provide a report (which does not include an opinion) on internal control related to the financial
statements and on compliance with the provisions of laws, regulations, contracts, and grant agreements,
noncompliance with which could have a material effect on the financial statements, as required by Government
Auditing Standards. The report on internal control over financial reporting and on compliance and other matters
will include a paragraph that states (1) that the purpose of the report is solely to describe the scope of our
testing of internal control and compliance and the result of that testing, and not to provide an opinion on the
effectiveness of the entity's internal control or on compliance, and (2) that the report is an integral part of an
audit performed in accordance with Government Auditing Standards in considering the entity's internal control
and compliance. The paragraph will also state that the report is not suitable for any other purpose. If during our
19 of 150
June 15, 2020 Regular Meeting Agenda Packet
June 9, 2020
Trophy Club Municipal Utility District No. 1
Page 3
audit we become aware that the entity is subject to an audit requirement that is not encompassed in the terms
of this engagement, we will communicate to management and those charged with governance that an audit
conducted in accordance with U.S. GAAS and the standards for financial audits contained in Government
Auditing Standards may not satisfy the relevant legal, regulatory, or contractual requirements.
Auditor responsibilities, procedures, and limitations
We will conduct our audit in accordance with U.S. GAAS and the standards for financial audits contained in
Government Auditing Standards. Those standards require that we plan and perform the audit to obtain
reasonable assurance about whether the basic financial statements as a whole are free from material
misstatement, whether due to fraud or error. An audit involves performing procedures to obtain sufficient
appropriate audit evidence about the amounts and disclosures in the basic financial statements. The procedures
selected depend on the auditors' judgment, including the assessment of the risks of material misstatement of
the financial statements, whether due to fraud or error. An audit also includes evaluating the appropriateness of
accounting policies used and the reasonableness of significant accounting estimates made by management, as
well as evaluating the overall presentation of the basic financial statements.
There is an unavoidable risk, because of the inherent limitations of an audit, together with the inherent
limitations of internal control, that some material misstatements may not be detected, even though the audit is
properly planned and performed in accordance with U.S. GAAS and Government Auditing Standards. Because we
will not perform a detailed examination of all transactions, material misstatements, whether from (1) errors,
(2) fraudulent financial reporting, (3) misappropriation of assets, or (4) violations of laws or governmental
regulations that are attributable to the entity or to acts by management or employees acting on behalf of the
entity, may not be detected. Because the determination of waste and abuse is subjective, Government Auditing
Standards do not require auditors to perform specific procedures to detect waste or abuse in financial audits nor
do they expect auditors to provide reasonable assurance of detecting waste or abuse.
In addition, an audit is not designed to detect immaterial misstatements or violations of laws or governmental
regulations that do not have a direct and material effect on the financial statements. However, we will inform
the appropriate level of management and those charged with governance of any material errors, fraudulent
financial reporting, or misappropriation of assets that come to our attention. We will also inform the
appropriate level of management and those charged with governance of any violations of laws or governmental
regulations that come to our attention, unless clearly inconsequential.
In making our risk assessments, we consider internal control relevant to the entity's preparation and fair
presentation of the basic financial statements in order to design audit procedures that are appropriate in the
circumstances, but not for the purpose of expressing an opinion on the effectiveness of the entity's internal
control. Tests of controls may be performed to test the effectiveness of certain controls that we consider
relevant to preventing and detecting fraud or errors that are material to the financial statements and to
preventing and detecting misstatements resulting from noncompliance with provisions of laws, regulations,
contracts, and grant agreements that have a material effect on the financial statements. Our tests, if performed,
will be less in scope than would be necessary to render an opinion on internal control and, accordingly, no
opinion will be expressed in our report on internal control issued pursuant to Government Auditing Standards.
An audit is not designed to provide assurance on internal control or to identify deficiencies, significant
deficiencies, or material weaknesses in internal control. However, we will communicate to you in writing
significant deficiencies or material weaknesses in internal control relevant to the audit of the basic financial
20 of 150
June 15, 2020 Regular Meeting Agenda Packet
June 9, 2020
Trophy Club Municipal Utility District No. 1
Page 4
statements that we identify during the audit that are required to be communicated under AICPA professional
standards and Government Auditing Standards.
As part of obtaining reasonable assurance about whether the financial statements are free of material
misstatement, we will perform tests of the entity's compliance with the provisions of laws, regulations,
contracts, and grant agreements that have a material effect on the financial statements. However, the objective
of our audit will not be to provide an opinion on overall compliance and we will not express such an opinion in
our report on compliance issued pursuant to Government Auditing Standards.
We will include in our report on internal control over financial reporting and on compliance relevant information
about any identified or suspected instances of fraud and any identified or suspected noncompliance with
provisions of laws, regulations, contracts, or grant agreements that may have occurred that are required to be
communicated under Government Auditing Standards.
Our responsibility as auditors is limited to the period covered by our audit and does not extend to any later
periods for which we are not engaged as auditors.
Management responsibilities
Our audit will be conducted on the basis that you (management and, when appropriate, those charged with
governance) acknowledge and understand that you have certain responsibilities that are fundamental to the
conduct of an audit.
You are responsible for the preparation and fair presentation of the financial statements and RSI in accordance
with U.S. GAAP. Management's responsibilities include the selection and application of accounting principles;
recording and reflecting all transactions in the financial statements; determining the reasonableness of
significant accounting estimates included in the financial statements; adjusting the financial statements to
correct material misstatements; and confirming to us in the management representation letter that the effects
of any uncorrected misstatements aggregated by us during the current engagement and pertaining to the latest
period presented are immaterial, both individually and in the aggregate, to the financial statements taken as a
whole.
You are responsible for the design, implementation, and maintenance of effective internal control, including
evaluating and monitoring ongoing activities, to help ensure that appropriate goals and objectives are met
relevant to the preparation and fair presentation of financial statements that are free from material
misstatement, whether due to fraud or error. You are responsible for the design, implementation, and
maintenance of internal controls to prevent and detect fraud; assessing the risk that the financial statements
may be materially misstated as a result of fraud; and for informing us about all known or suspected fraud
affecting the entity involving (1) management, (2) employees who have significant roles in internal control, and
(3) others where the fraud could have a material effect on the financial statements. Your responsibilities include
informing us of your knowledge of any allegations of fraud or suspected fraud affecting the entity received in
communications from employees, former employees, grantors, regulators, or others. In addition, you are
responsible for implementing systems designed to achieve compliance with applicable laws and regulations and
the provisions of contracts and grant agreements; identifying and ensuring that the entity complies with
applicable laws, regulations, contracts, and grant agreements; and informing us of all instances of identified or
suspected noncompliance whose effects on the financial statements should be considered. You are responsible
21 of 150
June 15, 2020 Regular Meeting Agenda Packet
June 9, 2020
Trophy Club Municipal Utility District No. 1
Page 5
for taking timely and appropriate steps to remedy any fraud and noncompliance with provisions of laws,
regulations, contracts, and grant agreements that we may report.
You are responsible for ensuring that management is reliable and for providing us with (1) access to all
information of which you are aware that is relevant to the preparation and fair presentation of the financial
statements, such as records, documentation, and other matters, and for the accuracy and completeness of that
information, and for ensuring the information is reliable and properly reported; (2) additional information that
we may request for the purpose of the audit; and (3) unrestricted access to persons within the entity from
whom we determine it necessary to obtain audit evidence. You agree to inform us of events occurring or facts
discovered subsequent to the date of the financial statements that may affect the financial statements.
Management is responsible for providing us with a written confirmation concerning representations made by
you and your staff to us in connection with the audit and the presentation of the basic financial statements and
RSI. During our engagement, we will request information and explanations from you regarding, among other
matters, the entity's activities, internal control, future plans, specific transactions, and accounting systems and
procedures. The procedures we will perform during our engagement and the conclusions we reach as a basis for
our report will be heavily influenced by the representations that we receive in the representation letter and
otherwise from you. Accordingly, inaccurate, incomplete, or false representations could cause us to expend
unnecessary effort or could cause a material fraud or error to go undetected by our procedures. In view of the
foregoing, you agree that we shall not be responsible for any misstatements in the entity's financial statements
that we may fail to detect as a result of misrepresentations made to us by you.
Management is responsible for authorizing the predecessor auditor to allow us to review the predecessor
auditor's workpapers and to respond fully to our inquiries, thereby providing us with information to assist us in
planning and performing the engagement. You will be responsible for any fees billed by the predecessor auditor
related to our review of their workpapers and our inquiries.
Management is responsible for establishing and maintaining a process for tracking the status of audit findings
and recommendations. Management is also responsible for identifying for us previous financial audits,
attestation engagements, performance audits, or other studies related to the objectives discussed in the "Audit
objectives" section of this letter. This responsibility includes relaying to us corrective actions taken to address
significant findings and recommendations resulting from those audits, attestation engagements, performance
audits, or other engagements or studies. You are also responsible for providing management's views on our
current findings, conclusions, and recommendations, as well as your planned corrective actions for the report,
and for the timing and format for providing that information.
Responsibilities and limitations related to nonaudit services
For all nonaudit services we may provide to you, management agrees to assume all management
responsibilities; oversee the services by designating an individual, preferably within senior management, who
possesses suitable skill, knowledge, and/or experience to understand and oversee the services; evaluate the
adequacy and results of the services; and accept responsibility for the results of the services. Management is
also responsible for ensuring that your data and records are complete and that you have received sufficient
information to oversee the services.
22 of 150
June 15, 2020 Regular Meeting Agenda Packet
June 9, 2020
Trophy Club Municipal Utility District No. 1
Page 6
The responsibilities and limitations related to the nonaudit services performed as part of this engagement are as
follows:
• We will prepare a draft of your financial statements and related notes. Since the preparation and fair
presentation of the financial statements is your responsibility, you will be required to acknowledge in
the representation letter our assistance with preparation of the financial statements and that you have
reviewed and approved the financial statements and related notes prior to their issuance and have
accepted responsibility for those financial statements. You have a responsibility to be in a position in
fact and appearance to make an informed judgment on those financial statements.
• We will propose adjusting journal entries as needed. You will be required to review and approve those
entries and to understand the nature of the changes and their impact on the financial statements.
These nonaudit services do not constitute an audit under Government Auditing Standards and such services will
not be conducted in accordance with Government Auditing Standards.
Use of financial statements
The financial statements and our report thereon are for management's use. If you intend to reproduce and
publish the financial statements and our report thereon, they must be reproduced in their entirety. Inclusion of
the audited financial statements in a document, such as an annual report or an offering document, should be
done only with our prior approval of the document. You are responsible to provide us the opportunity to review
such documents before issuance.
If the parties (i.e., you and CLA) agree that CLA will not be involved with your official statements related to
municipal securities filings or other offering documents, we will require that any official statements or other
offering documents issued by you with which we are not involved clearly indicate that CLA is not involved with
the contents of such documents. Such disclosure should read as follows:
CliftonLarsonAllen LLP, our independent auditor, has not been engaged to perform and has not
performed, since the date of its report included herein, any procedures on the financial statements
addressed in that report. CliftonLarsonAllen LLP also has not performed any procedures relating to this
offering document.
Should you decide to include or incorporate by reference these financial statements and our auditors' report(s)
thereon in a future private placement or other offering of equity or debt securities, you agree that we are under
no obligation to re -issue our report or provide consent for the use of our report in such a registration or offering
document. We will determine, at our sole discretion, whether we will re -issue our report or provide consent for
the use of our report only after we have performed the procedures we consider necessary in the circumstances.
If we decide to re -issue our report or consent to the use of our report, we will be required to perform certain
procedures including, but not limited to, (a) reading other information incorporated by reference in the
registration statement or other offering document and (b) subsequent event procedures. These procedures will
be considered an engagement separate and distinct from our audit engagement, and we will bill you separately.
If we decide to re -issue our report or consent to the use of our report, you agree that we will be included on
each distribution of draft offering materials and we will receive a complete set of final documents. If we decide
not to re -issue our report or decide to withhold our consent to the use of our report, you may be required to
23 of 150
June 15, 2020 Regular Meeting Agenda Packet
June 9, 2020
Trophy Club Municipal Utility District No. 1
Page 7
engage another firm to audit periods covered by our audit reports, and that firm will likely bill you for its
services. While the successor auditor may request access to our workpapers for those periods, we are under no
obligation to permit such access.
If the parties (i.e., you and CLA) agree that CLA will not be involved with your official statements related to
municipal securities filings or other offering documents, we will require that any official statements or other
offering documents issued by you with which we are not involved clearly indicate that CLA is not involved with
the contents of such documents. Such disclosure should read as follows:
CliftonLarsonAllen LLP, our independent auditor, has not been engaged to perform and has not
performed, since the date of its report included herein, any procedures on the financial statements
addressed in that report. CliftonLarsonAllen LLP also has not performed any procedures relating to this
offering document.
With regard to the electronic dissemination of audited financial statements, including financial statements
published electronically on your website or submitted on a regulator website, you understand that electronic
sites are a means to distribute information and, therefore, we are not required to read the information
contained in those sites or to consider the consistency of other information in the electronic site with the
original document.
We may issue preliminary draft financial statements to you for your review. Any preliminary draft financial
statements should not be relied on or distributed.
Engagement administration and other matters
We understand that your employees will prepare all confirmations, account analyses, and audit schedules we
request and will locate any documents or invoices selected by us for testing. A list of information we expect to
need for our audit and the dates required will be provided in a separate communication.
We will provide copies of our reports to the entity; however, management is responsible for distribution of the
reports and the financial statements. Unless restricted by law or regulation, or containing confidential or
sensitive information, copies of our reports are to be made available for public inspection.
We are available to perform additional procedures with regard to fraud detection and prevention, at your
request, as a separate engagement, subject to completion of our normal engagement acceptance procedures.
The terms and fees of such an engagement would be documented in a separate engagement letter.
The audit documentation for this engagement is the sole and exclusive property of CLA and constitutes
confidential and proprietary information. However, subject to applicable laws and regulations, audit
documentation and appropriate individuals will be made available upon request and in a timely manner to a
federal agency providing direct or indirect funding, or the U.S. Government Accountability Office for purposes of
a quality review of the audit, to resolve audit findings, or to carry out oversight responsibilities. We will notify
you of any such request. If requested, access to such audit documentation will be provided under the
supervision of CLA personnel. Furthermore, upon request, we may provide copies of selected audit
documentation to the aforementioned parties. These parties may intend, or decide, to distribute the copies or
information contained therein to others, including other governmental agencies.
24 of 150
June 15, 2020 Regular Meeting Agenda Packet
June 9, 2020
Trophy Club Municipal Utility District No. 1
Page 8
The audit documentation for this engagement will be retained for a minimum of seven years after the report
release. If we are aware that a federal awarding agency, pass-through entity, or auditee is contesting an audit
finding, we will contact the party(ies) contesting the audit finding for guidance prior to destroying the audit
documentation.
CLA will not disclose any confidential, proprietary, or privileged information of the entity to any persons without
the authorization of entity management or unless required by law. This confidentiality provision does not
prohibit us from disclosing your information to one or more of our affiliated companies in order to provide
services that you have requested from us or from any such affiliated company. Any such affiliated company shall
be subject to the same restrictions on the use and disclosure of your information as apply to us.
Professional standards require us to be independent with respect to you in the performance of these services.
Any discussion that you have with our personnel regarding potential employment with you could impair our
independence with respect to this engagement. Therefore, we request that you inform us prior to any such
discussions so that we can implement appropriate safeguards to maintain our independence and objectivity.
Further, any employment offers to any staff members working on this engagement without our prior knowledge
may require substantial additional procedures to ensure our independence. You will be responsible for any
additional costs incurred to perform these procedures.
Our relationship with you is limited to that described in this letter. As such, you understand and agree that we
are acting solely as independent accountants. We are not acting in any way as a fiduciary or assuming any
fiduciary responsibilities for you. We are not responsible for the preparation of any report to any governmental
agency, or any other form, return, or report or for providing advice or any other service not specifically recited in
this letter.
Our engagement and responsibility end on delivery of our signed report. Any additional services that might be
requested will be a separate, new engagement. The terms and conditions of that new engagement will be
governed by a new, specific engagement letter for that service.
Government Auditing Standards require that we make our most recent external peer review report publicly
available. The report is posted on our website at www.CLAconnect.com/Aboutus/.
Mediation
Any disagreement, controversy, or claim ("Dispute") that may arise out of any aspect of our services or
relationship with you, including this engagement, shall be submitted to non-binding mediation by written notice
("Mediation Notice") to the other party. In mediation, we will work with you to resolve any differences
voluntarily with the aid of an impartial mediator.
The mediation will be conducted as specified by the mediator and agreed upon by the parties. The parties agree
to discuss their differences in good faith and to attempt, with the assistance of the mediator, to reach an
amicable resolution of the Dispute.
Each party will bear its own costs in the mediation. The fees and expenses of the mediator will be shared equally
by the parties.
25 of 150
Audit Fee
5% Technology and Total Fees
Client Support Fee
June 15, 2020 Regular Meeting Agenda Packet
June 9, 2020
Trophy Club Municipal Utility District No. 1
Page 9
Any Dispute will be governed by the laws of the state of Minnesota, without giving effect to choice of law
principles.
Time limitation
The nature of our services makes it difficult, with the passage of time, to gather and present evidence that fully
and fairly establishes the facts underlying any Dispute that may arise between the parties. The parties agree
that, notwithstanding any statute or law of limitations that might otherwise apply to a Dispute, including one
arising out of this agreement or the services performed under this agreement, for breach of contract or fiduciary
duty, tort, fraud, misrepresentation or any other cause of action or remedy, any action or legal proceeding by
you against us must be commenced within twenty-four (24) months ("Limitation Period") after the date when
we deliver our final audit report under this agreement to you, regardless of whether we do other services for
you relating to the audit report, or you shall be forever barred from commencing a lawsuit or obtaining any legal
or equitable relief or recovery.
The Limitation Period applies and begins to run even if you have not suffered any damage or loss, or have not
become aware of the existence or possible existence of a Dispute.
Fees
Our professional fees for the engagement will be billed as shown below. This estimate is based on anticipated
cooperation from your personnel and their assistance with preparing confirmations and requested schedules. If
the requested items are not available on the dates required or are not accurate, the fees and expenses will likely
be higher. If unexpected circumstances require significant additional time, we will advise you before undertaking
work that would require a substantial increase in the fee and expense estimate. Our invoices, including
applicable state and local taxes, will be rendered each month as work progresses and are payable on
presentation. In accordance with our firm policies, work may be suspended if your account becomes 60 days or
more overdue and will not be resumed until your account is paid in full. If we elect to terminate our services for
nonpayment, our engagement will be deemed to have been completed even if we have not issued our reports.
You will be obligated to compensate us for all time expended and related fees and to reimburse us for all out-of-
pocket expenditures through the date of termination.
Audit Period
FY2020
$ 23,809
$1,191
$25,000
FY2021
$ 24,167
$1,208
$25,375
FY2022
$ 24,530
$1,226
$25,756
FY2023 (option) $ 24,897
$1,245 $26,142
FY2024 (option) $25,270 $1,264 $26,534
Unanticipated services
We do not anticipate encountering the need to perform additional services beyond those described in this
letter. Below are listings of services considered to be outside the scope of our engagement. If any such service
26 of 150
June 15, 2020 Regular Meeting Agenda Packet
June 9, 2020
Trophy Club Municipal Utility District No. 1
Page 10
needs to be completed before the audit can proceed in an efficient manner, we will determine whether we can
provide the service and maintain our independence. If appropriate, we will notify you and provide a fair and
reasonable price for providing the service. We will bill you for the service at periodic dates after the additional
service has been performed.
Bookkeeping services
Bookkeeping services are not audit services. Bookkeeping services include the following activities:
• Preparation of a trial balance
• Account reconciliations
• Bank statement reconciliations
• Capital asset accounting (e.g., calculating depreciation, identify capital assets for additions and
deletions)
• Calculating accruals
• Analyzing transactions for proper recording
• Converting cash basis accounting records to accrual basis
• Preparation of financial statements and the related notes to the financial statements
• Processing immaterial adjustments through the financial statements
• Adjusting the financial statements for new activities and new disclosures
Additional work resulting from unanticipated changes in your organization or accounting records
If your organization undergoes significant changes in key personnel, accounting systems, and/or internal
control, we are required to update our audit documentation and audit plan. The following are examples
of situations that will require additional audit work:
• Revising documentation of your internal control for changes resulting from your implementation
of new information systems
• Deterioration in the quality of the entity's accounting records during the current -year
engagement in comparison to the prior -year engagement
• Significant new accounting issues
• Significant changes in your volume of business
• Mergers, acquisitions, or other business combinations
27 of 150
June 15, 2020 Regular Meeting Agenda Packet
June 9, 2020
Trophy Club Municipal Utility District No. 1
Page 11
• New or unusual transactions
• Changes in audit scope or requirements resulting from changes in your activities
• Erroneous or incomplete accounting records
• Evidence of material weaknesses or significant deficiencies in internal control
• Substantial increases in the number or significance of problem loans
• Regulatory examination matters
• Implementation or adoption of new or existing accounting, reporting, regulatory, or tax
requirements
• New financial statement disclosures
Changes in engagement timing and assistance by your personnel
The fee estimate is based on anticipated cooperation from your personnel and their assistance with
timely preparation of confirmations and requested schedules. If the requested items are not available
on the dates required or are not accurate, we will advise management. Additional time and costs may
be necessary because of such unanticipated delays. Examples of situations that may cause our
estimated fee to increase include:
• Significant delays in responding to our requests for information such as reconciling variances or
providing requested supporting documentation (e.g., invoices, contracts, and other documents)
• Rescheduling our fieldwork
• Schedule disruption caused by litigation, financial challenges (going concern), loan covenants
(waivers), etc.
• Identifying a significant number of proposed audit adjustments
• Schedules prepared by your personnel that do not reconcile to the general ledger
• Numerous revisions to information and schedules provided by your personnel
• Restating financial statements for accounting errors in the prior year
• Lack of availability of entity personnel during audit fieldwork
Changes in accounting and audit standards
Standard setters and regulators continue to evaluate and modify standards. Such changes may result in new or
revised financial reporting and disclosure requirements or expand the nature, timing, and scope of the activities
28 of 150
June 15, 2020 Regular Meeting Agenda Packet
June 9, 2020
Trophy Club Municipal Utility District No. 1
Page 12
we are required to perform. To the extent that the amount of time required to provide the services described in
the letter increases due to such changes, our fee may need to be adjusted. We will discuss such circumstances
with you prior to performing the additional work.
Other fees
You also agree to compensate us for any time and expenses, including time and expenses of legal counsel, we
may incur in responding to discovery requests or participating as a witness or otherwise in any legal, regulatory,
or other proceedings that we are asked to respond to on your behalf.
Finance charges and collection expenses
You agree that if any statement is not paid within 30 days from its billing date, the unpaid balance shall accrue
interest at the monthly rate of one and one-quarter percent (1.25%), which is an annual percentage rate of 15%.
In the event that any collection action is required to collect unpaid balances due us, reasonable attorney fees
and expenses shall be recoverable.
Consent
Consent to use financial information
Annually, we assemble a variety of benchmarking analyses using client data obtained through our audit and
other engagements. Some of this benchmarking information is published and released publicly. However, the
information that we obtain is confidential, as required by the AICPA Code of Professional Conduct. Your
acceptance of this engagement letter will serve as your consent to use of Trophy Club Municipal Utility District
No. l's information in these cost comparison, performance indicator, and/or benchmarking reports.
Subcontractors
CLA may, at times, use subcontractors to perform services under this agreement, and they may have access to
your information and records. Any such subcontractors will be subject to the same restrictions on the use of
such information and records as apply to CLA under this agreement.
Predecessor auditor communications
You agree to provide us permission to communicate with the predecessor auditor and to authorize the
predecessor auditor to respond fully to our inquiries regarding any matters that will assist us in finalizing our
engagement acceptance. You further acknowledge that our final acceptance of the engagement is subject to the
completion of those inquiries and evaluation of the responses.
Agreement
We appreciate the opportunity to be of service to you and believe this letter accurately summarizes the
significant terms of our engagement. This letter constitutes the entire agreement regarding these services and
supersedes all prior agreements (whether oral or written), understandings, negotiations, and discussions
between you and CLA. If you have any questions, please let us know. Please sign, date, and return a copy of this
letter to us to indicate your acknowledgment and understanding of, and agreement with, the arrangements for
our audit of your financial statements including the terms of our engagement and the parties' respective
responsibilities. This agreement is also subject to successful engagement acceptance procedures which include
communication with the predecessor auditor.
29 of 150
June 15, 2020 Regular Meeting Agenda Packet
June 9, 2020
Trophy Club Municipal Utility District No. 1
Page 13
Sincerely,
CliftonLarsonAllen LLP
--.4, 1---A-
Christopher Knopik, CPA, CFE
Principal
612-397-3266
Christopher.Knopik@CLAconnect.com
Enclosure
Response:
This letter correctly sets forth the understanding of Trophy Club Municipal Utility District No. 1.
Authorized governance signature:
Title:
Date:
Authorized management signature:
Title:
Date:
30 of 150
June 15, 2020 Regular Meeting Agenda Packet
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
RESOLUTION NO. 2020-0615A
A RESOLUTION REGARDING SIGNATORY AUTHORITY FOR TROPHY
CLUB MUNICIPAL UTILITY DISTRICT NO. 1 ACCOUNTS AT
PROSPERTY BANK USA
WHEREAS, Trophy Club Municipal Utility District No. 1 (the "District") is a
conservation and reclamation district, a body corporate and politic and governmental agency of
the State of Texas, created under Article XVI, Sec. 59 of the Texas Constitution by order of the
Texas Water Commission, now the Texas Commission on Environmental Quality ("TCEQ"), and
the District operates under Chapters 49 and 54 of the Texas Water Code, as amended;
WHEREAS, banking rules and effective management of the District's finances require
that the Board of Directors (the "Board") of Trophy Club Municipal Utility District No. 1 (the
"District") establish designated persons who shall have signature authority over the District's bank
accounts at Prosperity Bank USA (the "Bank"); and
WHEREAS, it is necessary for the Board to provide that a sufficient number of District
officials be designated with signature authority; and
NOW, THEREFORE, BE IT RESOLVED BY THE BOARD OF DIRECTORS OF
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 THAT:
1. The following members of the Board of Directors and the General Manager of Trophy Club
Municipal Utility District No. 1 shall have signatory authority over the District's accounts at
Prosperity Bank USA, each of them mutually having authority to act in the place of any other as
may be convenient for effectively transacting the business of the District:
a. Gregory Wilson Director
b. William C. Rose Director
c. Kelly Castonguay Director
d. Stephen J. Flynn Director
e. Mark Chapman Director
f. Alan Fourmentin General Manager
2. At least two (2) authorized signors must sign all disbursements of the District.
3. The Board of Directors directs the staff of the District to take all actions necessary and
apply such information and documentation as may be requested by the Bank to affect the
provisions of this Resolution.
4. These changes supersede all previously existing signatory authorities on record with
Prosperity Bank USA.
31 of 150
June 15, 2020 Regular Meeting Agenda Packet
RESOLVED, PASSED, AND APPROVED on this the 15st day of June 2020.
ATTEST:
Kelly Castonguay
Secretary, Board of Directors
Steve Flynn
President, Board of Directors
32 of 150
(SEAL)
ai 111
111 III
TjLJooL
AN 1WFOR PUBLIC FUNDS
June 15, 2020 Regular Meeting Agenda Packet
Resolution Amending
Authorized Representatives
Please use this form to amend or designate Authorized Representatives.
This document supersedes all prior Authorized Representative forms.
* Required Fields
1. Resolution
WHEREAS,
Trophy Club Municipal Utility District No. 1
Participant Name*
1 7 7 3 8 4
Location Number*
("Participant") is a local government of the State of Texas and is empowered to delegate to a public funds investment pool the authority to invest funds
and to act as custodian of investments purchased with local investment funds; and
WHEREAS, it is in the best interest of the Participant to invest local funds in investments that provide for the preservation and safety of principal,
liquidity, and yield consistent with the Public Funds Investment Act; and
WHEREAS, the Texas Local Government Investment Pool ("TexPool/ Texpool Prime"), a public funds investment pool, were created on behalf of
entities whose investment objective in order of priority are preservation and safety of principal, liquidity, and yield consistent with the Public Funds
Investment Act.
NOW THEREFORE, be it resolved as follows:
A. That the individuals, whose signatures appear in this Resolution, are Authorized Representatives of the Participant and are each hereby
authorized to transmit funds for investment in TexPool / TexPool Prime and are each further authorized to withdraw funds from time to time,
to issue letters of instruction, and to take all other actions deemed necessary or appropriate for the investment of local funds.
B. That an Authorized Representative of the Participant may be deleted by a written instrument signed by two remaining Authorized
Representatives provided that the deleted Authorized Representative (1) is assigned job duties that no longer require access to the Participant's
TexPool / TexPool Prime account or (2) is no longer employed by the Participant; and
C. That the Participant may by Amending Resolution signed by the Participant add an Authorized Representative provided the additional
Authorized Representative is an officer, employee, or agent of the Participant;
List the Authorized Representative(s) of the Participant. Any new individuals will be issued personal identification numbers to transact business with
TexPool Participant Services.
1.
Alan Fourmentin
Name
1 General Manager
Title
1682-831-4610/817-491-9312/afourmentin@tcmud.org
Phone/Fax/Email
Signature
2 Laurie Slaght
Name
District Secretary
Title
1682-831-4685/817-491-9312/Islaght@tcmud.org
Phone/Fax/Email
Signature
FORM CONTINUES ON NEXT PAGE 1 OF 2
33 of 150
June 15, 2020 Regular Meeting Agenda Packet
1. Resolution (continued)
s Gregory Wilson
Name
Director
Title
1 682-831-4600/817-491-9312/gwilson@tcmud.org
Phone/Fax/Email
Signature
4 William C. Rose
Name
Director
Title
1 682-831-4600/817-491-9312/brose@tcmud.org
Phone/Fax/Email
Signature
List the name of the Authorized Representative listed above that will have primary responsibility for performing transactions and receiving confirmations
and monthly statements under the Participation Agreement.
1 Alan Fourmentin
Name
In addition and at the option of the Participant, one additional Authorized Representative can be designated to perform only inquiry of selected
information. This limited representative cannot perform transactions. If the Participant desires to designate a representative with inquiry rights only,
complete the following information.
1 Steven Krolczyk
Name
1 Finance Manager
Title
1682-831-4692/817-491-9312/skrolczyk@tcmud.org
Phone/Fax/Email
D. That this Resolution and its authorization shall continue in full force and effect until amended or revoked by the Participant, and until TexPool
Participant Services receives a copy of any such amendment or revocation. This Resolution is hereby introduced and adopted by the Participant
at its regular/special meeting held on the 15th day June , 20 20 .
Note: Document is to be signed by your Board President, Mayor or County Judge and attested by your Board Secretary, City Secretary or
County Clerk.
Trophy Club MUD No. 1
Name of Participant*
SIGNED
Signature*
Stephen J. Flynn
Printed Name*
1President
Title*
ATTEST
Signature*
Kelly Castonguay
Printed Name*
1Secretary/Treasurer
Title*
2. Mailing Instructions
The completed Resolution Amending Authorized Representatives can be faxed to TexPool Participant Services at 1-866-839-3291, and mailed to:
TexPool Participant Services
1001 Texas Avenue, Suite 1400
Houston, TX 77002
ORIGINAL SIGNATURE AND DOCUMENT REQUIRED TEX-REP
TexPool Participant Services
1001 Texas Avenue, Suite 1400 • Houston, TX 77002
Phone: 1-866-TEXPOOL (839-7665) • Fax: 1-866-839-3291 • www.texpool.com
34 of 150
2 OF 2
Managed d band Federated®
o
G45340-17 (12/15)
ai 111
111 III
TExPO0L
AN INVESTMENT SERVICE FOR PUBLIC FUNDS
June 15, 2020 Regular Meeting Agenda Packet
Resolution Amending
Authorized Representatives
Please use this form to amend or designate Authorized Representatives.
This document supersedes all prior Authorized Representative forms.
* Required Fields
1. Resolution
WHEREAS,
Trophy Club Municipal Utility District No. 1
Participant Name*
7 7 3 8 4
Location Number*
("Participant") is a local government of the State of Texas and is empowered to delegate to a public funds investment pool the authority to invest funds
and to act as custodian of investments purchased with local investment funds; and
WHEREAS, it is in the best interest of the Participant to invest local funds in investments that provide for the preservation and safety of principal,
liquidity, and yield consistent with the Public Funds Investment Act; and
WHEREAS, the Texas Local Government Investment Pool ("TexPool/ Texpool Prime"), a public funds investment pool, were created on behalf of
entities whose investment objective in order of priority are preservation and safety of principal, liquidity, and yield consistent with the Public Funds
Investment Act.
NOW THEREFORE, be it resolved as follows:
A. That the individuals, whose signatures appear in this Resolution, are Authorized Representatives of the Participant and are each hereby
authorized to transmit funds for investment in TexPool / TexPool Prime and are each further authorized to withdraw funds from time to time,
to issue letters of instruction, and to take all other actions deemed necessary or appropriate for the investment of local funds.
B. That an Authorized Representative of the Participant may be deleted by a written instrument signed by two remaining Authorized
Representatives provided that the deleted Authorized Representative (1) is assigned job duties that no longer require access to the Participant's
TexPool / TexPool Prime account or (2) is no longer employed by the Participant; and
C. That the Participant may by Amending Resolution signed by the Participant add an Authorized Representative provided the additional
Authorized Representative is an officer, employee, or agent of the Participant;
List the Authorized Representative(s) of the Participant. Any new individuals will be issued personal identification numbers to transact business with
TexPool Participant Services.
Steve Flynn
1.
Name
President
Title
1682-831-4600/817-491-9312/sflynn@tcmud.org
Phone/Fax/Email
Signature
2.1 Kelly Castonguay
Name
1 Secretary/Treasurer
Title
1682-831-4600/817-491-9312/kcastonguay@tcmud.org
Phone/Fax/Email
Signature
FORM CONTINUES ON NEXT PAGE 1 OF 2
35 of 150
June 15, 2020 Regular Meeting Agenda Packet
1. Resolution (continued)
3 Mark Chapman
Name
Vice -President
4.
Title
682-831-4600/817-491-9312/mchapman@tcmud.org
Phone/Fax/Email
Signature
Name
Title
Phone/Fax/Email
Signature
List the name of the Authorized Representative listed above that will have primary responsibility for performing transactions and receiving confirmations
and monthly statements under the Participation Agreement.
l Alan Fourmentin
Name
In addition and at the option of the Participant, one additional Authorized Representative can be designated to perform only inquiry of selected
information. This limited representative cannot perform transactions. If the Participant desires to designate a representative with inquiry rights only,
complete the following information.
1 Steven Krolczyk
Name
1 Finance Manager
Title
1682-831-4692/817-491-9312/skrolczyk@tcmud.org
Phone/Fax/Email
D. That this Resolution and its authorization shall continue in full force and effect until amended or revoked by the Participant, and until TexPool
Participant Services receives a copy of any such amendment or revocation. This Resolution is hereby introduced and adopted by the Participant
at its regular/special meeting held on the 15th day June , 20 20 .
Note: Document is to be signed by your Board President, Mayor or County Judge and attested by your Board Secretary, City Secretary or
County Clerk.
Trophy Club MUD No. 1
Name of Participant*
SIGNED
Signature*
Stephen J. Flynn
Printed Name*
President
Title*
ATTEST
Signature*
Kelly Castonguay
Printed Name*
Secretary/Treasurer
Title*
2. Mailing Instructions
The completed Resolution Amending Authorized Representatives can be faxed to TexPool Participant Services at 1-866-839-3291, and mailed to:
TexPool Participant Services
1001 Texas Avenue, Suite 1400
Houston, TX 77002
ORIGINAL SIGNATURE AND DOCUMENT REQUIRED TEX-REP
TexPool Participant Services
1001 Texas Avenue, Suite 1400 • Houston, TX 77002
Phone: 1-866-TEXPOOL (839-7665) • Fax: 1-866-839-3291 • www.texpool.com
36 of 150
2 OF 2
Managed d band Federated®
o
G45340-17 (12/15)
June 15, 2020 Regular Meeting Agenda Packet
TROPHY CLUB MUD NO. 1 - FIRE DEPARTMENT
BALANCE SHEET
MAY 2020
ASSETS
CASH IN BANK
INVESTMENTS
PREPAID EXPENSES
ADVALOREM PROPERTY TAXES RECEIVABLE
EMERGENCY SERVICES ASSESSMENTS RECEIVABLE
UTILITY AND OTHER ACCOUNTS RECEIVABLE
ix
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
122
FIRE DEPT.
895,282
6,564
37,757
TOTAL ASSETS 939,603
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS
ACCOUNTS AND OTHER PAYABLES
37,763
TOTAL LIABILITIES 37,763
FUND BALANCE
DESIGNATED FOR FUTURE ASSET REPLACEMENT
NON -SPENDABLE FUND BALANCE
UNASSIGNED FUND BALANCE 603,769
RESERVE FOR ENCUMBRANCES
NET REVENUES / EXPENDITURES 298,071
TOTAL FUND BALANCE 901,840
TOTAL LIABILITIES AND FUND BALANCE 939,603
37 of 150
June 15, 2020 Regular Meeting Agenda Packet
glbase tbam skrolczyk Trophy Club MUD No.1
10:08 06/10/20 Budget Summary with Amendment
Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program:
Period Ending: 5/2020
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
122-40010-000-000
122-40011-000-000
1 122-40020-000-000
Property Taxes/MUD Fire 1,214,230.00- 1,214,230.00 -
Property Taxes/Fire-Delinquent
Property Taxes/Fire P&I
5,990.97- 1,212,561.75-
104.81 2,762.65-
289.88- 4,300.92-
99.863
1,668.25-
2,762.65
4,300.92
Page
Subtotal: 1,214,230.00- 1,214,230.00- = 6,176.04- 1,219,625.32- 100.444 5,395.32
Program number:
1,214,230.00- 1,214,230.00- 6,176.04- 1,219,625.32-
100.444 5,395.32
Department number: Fire Revenues
1,214,230.00- 1,214,230.00- 6,176.04- 1,219,625.32-
100.444 5,395.32
I Revenues Subtotal 1,214,230.00- 1,214,230.00- 6,176.04- 1,219,625.32- 100.444 5,395.32
38 of 150
June 15, 2020 Regular Meeting Agenda Packet
glbase tbam skrolczyk Trophy Club MUD No.1 Page 2
10:08 06/10/20 Budget Summary with Amendment
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 5/2020
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
122-60030-045-000 Rent And/Or Usage 218,004.00 218,004.00
122-60055-045-000 Insurance 21,000.00 21,000.00
122-60337-045-000 Transfer to Town/Fire Budget 718,657.00 718,657.00
1,640.88
59,888.08
11111111?total: 957,661.00 957,661.00 61,528.96
122-69005-045-000 Capital Outlays 48,000.00 48,000.00
122-69009-045-000 Short Term Debt -Interest
122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 81,420.00
122-69305-045-000 Capital Leases 127,149.00 127,149.00
Subtota1: 256,569.00 256,569.00
Program number: 1,214,230.00 1,214,230.00 61,528.96
Department number: Fire 1,214,230.00 1,214,230.00 61,528.96
Expenditures Subtotal 1,214,230.00 1,214,230.00 61,528.96
Fund number: 122 Trophy Club MUD Fire Dept. 55,352.92
39 of 150
218,004.00 100.000
13,127.04 62.510
479,104.64 66.667
710,235.68
2,750.00 5.729
11,958.24
81,420.00 100.000
115,190.36 90.595
211,318.60 , 82.363
921,554.28 ,
921,554.11111
921,554.2x,
298,071.04- ,
75.896
75.896
75.896
7,872.96
239,552.36
247,425.32
45,250.00
11,958.24-
11,958.64
292,675.72
292,675.72
292,675.72
298,071.04
glpdatb2 skrolczyk
10:08 06/10/20
Fund: 122 Trophy Club MUD Fire Dept.
JE JE JE
Number Date Description
Account: 122-40010-020-
1272 05/01/2020 Property Taxes
1273 05/04/2020 Property Taxes
1274 05/05/2020 Property Taxes
1275 05/06/2020 property taxes
1277 05/07/2020 property taxes
1278 05/08/2020 property taxes
1279 05/11/2020 Property Taxes
1280 05/12/2020 Property Taxes
1281 05/14/2020 property taxes
1282 05/15/2020 property taxes
1283 05/18/2020 property taxes
1293 05/19/2020 property taxes
1284 05/20/2020 property taxes
1285 05/21/2020 property taxes
1286 05/22/2020 property taxes
1287 05/26/2020 property taxes
1288 05/27/2020 property taxes
1289 05/28/2020 property taxes
1290 05/29/2020 property taxes
Account: 122-40010-000-000
June 15, 2020 Regular Meeting Agenda Packet
Page 1
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: Fire Revenues Program:
Period Ending: 5/2020
JE Detail Beginning Transaction Transaction Vendor Name
Description/Comment Balance Detail Detail
(SUBTOTAL)
Check Source
Number
Property Taxes/MUD Fire
(1,206,570.78)
(73.86) (1,206,644.64)
(1.77) (1,206,646.41)
(8.07) (1,206,654.48)
(333.59) (1,206,988.07)
(1,081.52) (1,208,069.59)
(44.00) (1,208,113.59)
(53.23) (1,208,166.82)
227.10 (1,207,939.72)
(152.61) (1,208,092.33)
(733.84) (1,208,826.17)
(264.16) (1,209,090.33)
(182.32) (1,209,272.65)
(442.61) (1,209,715.26)
(596.60) (1,210,311.86)
(420.83) (1,210,732.69)
(203.39) (1,210,936.08)
(669.13) (1,211,605.21)
(416.87) (1,212,022.08)
(539.67) (1,212,561.75)
Property Taxes/MUD Fire Totals: .di.97) (1,212,561.75)
(1,214,230.00) Budgeted (1,668.25) Remaining 100 % Used
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
Property Taxes/Fire-Delinquent
1275 05/06/2020 property taxes
1280 05/12/2020 Property Taxes
1284 05/20/2020 property taxes
1285 05/21/2020 property taxes
1287 05/26/2020 property taxes
1288 05/27/2020 property taxes
Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Total
.00 Budgeted 2,762.65 Remaining
Account: 122-40020-000-0
1272 05/01/2020 Property Taxes
1273 05/04/2020 Property Taxes
1274 05/05/2020 Property Taxes
1275 05/06/2020 property taxes
1277 05/07/2020 property taxes
(2,867.46)
0 % Used
(14.13) (2,881.59)
194.89 (2,686.70)
(20.88) (2,707.58)
(32.85) (2,740.43)
(9.79) (2,750.22)
(12.43) (2,762.65)
GL
GL
GL
GL
GL
GL
Property Taxes/Fire P&2
(4,011.04)
40 of 150
(1.13) (4,012.17)
(.20) (4,012.37)
(1.07) (4,013.44)
(3.97) (4,017.41)
(119.68) (4,137.09)
GL
GL
GL
GL
GL
glpdatb2 ekrolczyk
10:08 06/10/20
Fund: 122 Trophy Club MUD Fire Dept.
JE JE JE
Number Date Description
1279 05/11/2020 Property Taxes
1280 05/12/2020 Property Taxes
1282 05/15/2020 property taxes
1283 05/18/2020 property taxes
1293 05/19/2020 property taxes
1284 05/20/2020 property taxes
1285 05/21/2020 property taxes
1286 05/22/2020 property taxes
1287 05/26/2020 property taxes
1288 05/27/2020 property taxes
1289 05/28/2020 property taxes
1290 05/29/2020 property taxes
Account: 122-40020-000-000
Department Totals:
June 15, 2020 Regular Meeting Agenda Packet
Page 2
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: Fire Revenues Program:
Period Ending: 5/2020
JE Detail Beginning Transaction Transaction Vendor Name
Description/Comment Balance Detail Detail
(SUBTOTAL)
Property Taxes/Fire P52 To
.00 Budgeted 4,300.92 Remaining
(6,176.04) Monthly Total
(4,011.04)
0
Used
(15.02) (4,152.11)
(.94) (4,153.05)
(65.77) (4,218.82)
(5.06) (4,223.88)
(.94) (4,224.82)
(31.01) (4,255.83)
.27 (4,255.56)
(24.92) (4,280.48)
(2.47) (4,282.95)
(3.68) (4,286.63)
(.30) (4,286.93)
(13.99) (4,300.92)
(4,300.92) **
(1,219,625.32) **
(1,214,230.00) Budgeted 5,395.32 Remaining 100 % Used
41 of 150
Check Source
Number
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
glpdatb2 akrolczyk
10:08 06/10/20
Fund: 122 Trophy Club MUD Fire Dept.
JE JE JE
Number Date Description
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: 45 Fire
Period Ending: 5/2020
Program:
June 15, 2020 Regular Meeting Agenda Packet
Page 3
JE Detail Beginning Transaction Transaction Vendor Name
Balance Detail Detail
(SUBTOTAL)
Description/Comment
Check Source
Number
42 of 150
Account:
122-60030-045-000
Rent And/Or Usage
218,004.00
.00
218,004.00
Account:
122-60030-045-000
Rent And/Or Usage Totals:
.00
218,004.00
**
218,004.00 Budgeted .00 Remaining 100 %
Used
Account:
122-60055-045-000
Insurance
73 05/01/2020 Insurance/Wrk
Comp
Expense May 11,486.16
1,640.88
13,127.04
GL
Account:
122-60055-045-000
Insurance Totals: '
1,640.88
13,127.04
**
21,000.00 Budgeted 7,872.96 Remaining 63 %
Used
Account:
122-60337-045-000
Transfer to Town/Fire Budget
1178 05/11/2020 May A/P
May Fire admin 419,216.56
59,888.08
479,104.64
TOWN OF
TROPHY
CLUB
6435
AP
Account:
122-60337-045-000
Transfer to Town/Fire Budget Totals:
59,888.08
479,104.64
**
718,657.00 Budgeted 239,552.36 Remaining 67 %
Used
Account:
122-69005-045-000
Capital Outlays
2,750.00
.00
2,750.00
Account:
122-69005-045-000
Capital Outlays Totals:
.00
2,750.00
**
48,000.00 Budgeted 45,250.00 Remaining 6 %
Used
Account:
122-69009-045-000
Short Term Debt -Interest
11,958.24
.00
11,958.24
Account:
122-69009-045-000
Short Term Debt -Interest Totals:
.00
11,958.24
**
.00 Budgeted (11,958.24) Remaining 0 %
Used
Account:
122-69195-045-000
GASB34/Reserve for Replacement A11111_
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 .
42 of 150
June 15, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4
10:08 06/10/20 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 5/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Capital Leases Totals:
127,149.00 Budgeted
115,190.36
.00 115,190.36
11,958.64 Remaining 91 % Used
Department 45 Totals: 921,554.28 ••
61,528.96 Monthly Total 1,214,230.00 Budgeted 292,675.72 Remaining 76 % Used
Fund 122 Totals: (298,071.04)
55,352.92 Monthly Total .00 Budgeted
43 of 150
298,071.04 Remaining 0 % Used
TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND)
BALANCE SHEET
MAY 2020
June 15, 2020 Regular Meeting Agenda Packet
135 137
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
GENERAL FUND GASB TOTAL
ASSETS
CASH ON HAND 600 600
CASH IN BANK -CHECKING 3,088,104 3,088,104
CASH IN BANK -SAVINGS -CASH RESERVE 1,604,892 1,604,892
INVESTMENTS-TEXPOOL 3,577,659 919,266 4,496,925
PREPAID EXPENSES 39,434 39,434
ADVALOREM PROPERTY TAXES RECEIVABLE 4,097 4,097
UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,009,838 1,009,838
TOTAL ASSETS 9,324,623 919,266 10,243,889
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 4,097 4,097
ACCOUNTS AND OTHER PAYABLES 499,383 499,383
CUSTOMER DEPOSITS 315,760 315,760
TOTAL LIABILITIES 819,239 819,239
FUND BALANCE
NON -SPENDABLE FUND BALANCE 3,486 3,486
ASSIGNED FUND BALANCE 2,072,098 2,072,098
ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 270,000 270,000
ASSIGNED FUND BALANCE/WATER REPLACEMENT 30,000 30,000
ASSIGNED FUND BALANCE/SEWER REPLACEMENT 127,805 127,805
ASSIGNED FUND BALANCE/FIRE DEPARTMENT 391,461 391,461
ASSIGNED FUND BALANCE/WWTP MBR REPLACEMENT 100,000 100,000
UNASSIGNED FUND BALANCE 6,325,800 6,325,800
COMMITTED FUND BALANCE
NET REVENUES / EXPENDITURES 103,999 103,999
TOTAL FUND BALANCE 8,505,384 919,266 9,424,650
TOTAL LIABILITIES AND FUND BALANCE 9,324,623 919,266 10,243,889
44 of 150
June 15, 2020 Regular Meeting Agenda Packet
glbase tbam skrolczyk Trophy Club MUD No.1 Page 3
10:08 06/10/20 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 5/2020
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-40000-000-000
135-40002-000-000
135-40015-000-000
135-40025-000-000
Property Taxes
Property Taxes/Delinquent
Property Taxes/P & I
PID Surcharges
134,871.00- 134,871.00-
300.00- 300.00-
300.00- 300.00-
164,253.00- 164,253.00-
665.06-
11.90
32.19-
134,609.11-
285.08-
468.83-
99.806
95.027
156.277
261.89-
14.92-
168.83
164,253.00-
164
135-47000-000-000 Water 6,486,623.00- 6,486,623.00-
135-47005-000-000 Sewer 3,503,885.00- 3,503,885.00-
135-47025-000-000 Penalties 112,608.00- 112,608.00-
135-47030-000-000 Service Charges 15,150.00- 15,150.00-
135-47035-000-000 Plumbing Inspections 750.00- 750.00-
135-47045-000-000 Sewer Inspections 2,500.00- 2,500.00-
135-47070-000-000 TCCC Effluent Charges 50,000.00- 50,000.00-
459,563.85-
273,756.56-
57.86
25.00-
8,843.20-
2,951,753.71-
2,053,404.14-
51,074.93-
9,825.00-
2,250.00-
1,350.00-
25,908.80-
45.505
58.604
45.356
64.851
300.000
54.000
51.818
3,534,869.29-
1,450,480.86-
61,533.07-
5,325.00-
1,500.00
,534,869.29-1,450,480.86-61,533.07-
5,325.00-
1,500.00
1,150.00-
24,091.20-
10,171,516.00- 10,171,516.00-
A11111111E0.75-
5,095,566
135-49011-000-000
135-49016-000-000
135-49018-000-000
135-49026-000-000
135-49075-000-000
135-49900-000-000
ENSubtots.
Program number:
Department number: Revenues
Revenues
Interest Income
Cell Tower Revenue
Building Rent Income
Proceeds from Sale of Assets
Oversize Meter Reimbursement
Miscellaneous Income
120,000.00- 120,000.00-
14,146.00- 14,146.00-
7,000.00- 7,000.00-
13,000.00- 13,000.00-
12,691.00- 12,691.00-
7,000.00- 7,000.00-
3,764.35-
1,178.81-
583.33-
169.84-
67,382.29-
8,251.67-
4,666.64-
8,925.00-
7,730.28-
8,971.93-
45.505
7,382.29-8,251.67-4,666.64-8,925.00-7,730.28-
8,971.93-
56.152
58.332
66.666
68.654
60.912
128.170
52,617.71-
5,894.33-
2,333.36-
4,075.00-
4,960.72-
1,971.93
2,617.71 -5,894.33-2,333.36-4,075.00-
4,960.72-
1,971.93
173,837.00-
Subtotal
0- 10,645,077.00-
0- 10,645,077.00-
10- 10,645,077.00-
45 of 150
748
08,219.59-
08,219.59-
08,219.59-
June 15, 2020 Regular Meeting Agenda Packet
glbase_tbam skrolczyk Trophy Club MUD No.1
10:08 06/10/20 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 5/2020
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-50005-010-000 Salaries & Wages 350,267.00 350,267.00 46,318.05
135-50010-010-000 Overtime 17,000.00 17,000.00 1,562.49
135-50016-010-000 Longevity 3,920.00 3,920.00
135-50017-010-000 Certification 5,400.00 5,400.00 425.00
135-50020-010-000 Retirement 34,863.00 34,863.00 4,473.10
135-50026-010-000 Medical Insurance 84,326.00 84,326.00 5,225.04
135-50027-010-000 Dental Insurance 4,725.00 4,725.00 316.63
135-50028-010-000 Vision Insurance 767.00 767.00 48.18
135-50029-010-000 Life Insurance & Other 3,132.00 3,132.00 328.89
135-50030-010-000 Social Security Taxes 23,348.00 23,348.00 2,974.38
135-50035-010-000 Medicare Taxes 5,461.00 5,461.00 695.62
135-50040-010-000 Unemployment Taxes 1,080.00 1,080.00
135-50045-010-000 Workman's Compensation 11,850.00 11,850.00 771.49
135-50060-010-000 Pre-emp Physicals/Testing 400.00 400.00
135-50070-010-000 Employee Relations 300.00 300.00
FSubtotal: ' 546,839.00 546,839.00 63,138.87
135-55005-010-000 Engineering 20,000.00 20,000.00
135-55080-010-000 Maintenance & Repairs 100,000.00 100,000.00 5,089.98
135-55085-010-000 Generator Maint. and Repair 3,000.00 3,000.00
135-55090-010-000 Vehicle Maintenance 5,000.00 5,000.00 601.87
135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00
135-55120-010-000 Cleaning Services 1,000.00 1,000.00 87.50
135-55135-010-000 Lab Analysis 7,500.00 7,500.00
239,064.24 68.252
13,427.75 78.987
5,082.50 129.656
3,350.00 62.037
25,233.24 72.378
40,053.74 47.499
2,431.37 51.458
380.65 49.628
2,534.95 80.937
16,001.33 68.534
3,742.22 68.526
880.68 81.544
6,347.42 53.565
358,530.09
29,521.69 29.522
2,444.43 48.889
1,828.19 52.234
612.50 61.250
2,451.64 32.689
111,202.76
3,572.25
1,162.50-
2,050.00
9,629.76
44,272.26
2,293.63
386.35
597.05
7,346.67
1,718.78
199.32
5,502.58
400.00
300.00
188,308.91
20,000.00
70,478.31
3,000.00
2,555.57
1,671.81
387.50
5,048.36
103,141.55
Page 4
140,000.00 140,000.00
26.327
135-60010-010-000 Communications/Mobiles 5,000.00 5,000.00
135-60020-010-000 Electricity 125,677.00 125,677.00
135-60066-010-000 Publications/Books/Subscripts 1,000.00 1,000.00
135-60070-010-000 Dues & Memberships 500.00 500.00
135-60080-010-000 Schools & Training 7,426.00 7,426.00
135-60090-010-000 Safety Program 400.00 400.00
135-60100-010-000 Travel & per diem 2,845.00 2,845.00
135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00
135-60135-010-000 TCEQ Fees & Permits 63,000.00 63,000.00
135-60150-010-000 Wholesale Water 2,714,710.00 2,714,710.00
135-60245-010-000 Miscellaneous Expenses 200.00 200.00
135-60280-010-000 Property Maintenance 3,000.00 3,000.00
135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00
135-60332-010-000 Interfund Transfer Out -Rev I&S 527,381.00 527,381.00
135-60333-010-000 Interfund Transfer Out -Reserve 55,193.00 55,193.00
135-60334-010-000 Interfund Transfer Out 180,000.00 180,000.00
46 of 150
385.40
9,128.56
111.00
130,922.95
1,500.00
25,047.72
4,600.00
3,653.34 73.067
80,762.35 64.262
850.00 85.000
105.00 21.000
1,547.00 20.832
20,205.04 32.071
883,304.49 32.538
756.00 25.200
3,000.00 20.339
383,549.92 72.727
36,800.00 66.675
1,346.66
44,914.65
150.00
395.00
5,879.00
400.00
2,845.00
1,500.00
42,794.96
1,831,405.51
200.00
2,244.00
11,750.00
143,831.08
18,393.00
180,000.00
glbase_tbam skrolczyk
10:08 06/10/20
Fund: 135 MUD 1 General Fund
Account
1
1 135-60360-010-000
1
Description
Furniture/Equipment < $5000
June 15, 2020 Regular Meeting Agenda Packet
Trophy Club MUD No.1 Page 5
Budget Summary with Amendment
Department: 10 Water Program:
Period Ending: 5/2020
Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
2,500.00
2,500.00
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
Fuel & Lube
Uniforms
Chemicals
Small Tools
Safety Equipment
Meter Expense
Meter Change Out Program
15,000.00
5,190.00
20,000.00
1,200.00
1,000.00
70,000.00
87,000.00
15,000.00
5,190.00
20,000.00
1,200.00
1,000.00
70,000.00
87,000.00
442.13
1,789.93
561.72 22.469 1,938.28
1,415,094.86 = 2,289,98.7
6,175.98 41.173
2,917.33 56.211
13,652.18 68.261
59,593.08 85.133
36,900.00 42.414
8,824.02
2,272.67
6,347.82
1,200.00
1,000.00
10,406.92
50,100.00
135-69005-010-000
135-69008-010-000
135-69009-010-000
135-69195-010-000
135-69281-010-000
Subtot
135-70040-010-000
Subtot-
Program number:
Capital Outlays
Short Term Debt -Principal
Short Term Debt -Interest
Gasb34/Reserve for Replacement
Water Tank Inspection Contract
Bond Related Expenses
684,875.00
30,512.00
3,231.00
75,000.00
120,000.00
684,875.00
30,512.00
3,231.00
75,000.00
120,000.00
.00
5,504,929.00 5,504,929.00
47 of 150
59,366.70
335,891.44 49.044
30,512.00 100.000
1,840.00 56.948
75,000.00 100.000
102,077.11 85.064
59,366.70 7111,320.55
1,220.00 1,220.00
1,220.00 -171941.1.
303,432.61 2,476,262.52
348,983.56
1,391.00
17,922.89
368,297.
1,220.00-
1,220.00-
,028,666.48
glbase_tbam skrolczyk
10:08 06/10/20
Fund: 135 MUD 1 General Fund
Account Description
1
1 135-55135-010-001
Lab Analysis for PID
June 15, 2020 Regular Meeting Agenda Packet
Trophy Club MUD No.1
Budget Summary with Amendment
Department: 10 Water Program: 1 Lab Analysis for PID
Period Ending: 5/2020
Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
2,000.00 2,000.00
1,001.64
50.082 998.36
Page
Subtotal:
2,000.00
2,000.00
Mr -
1,001.64
50.082
998.36
Program number: 1 Lab Analysis for PID
2,000.00
2,000.00
1,001.64
50.082
998.36
Department number: Water 5,506,929.00 5,506,929.00
303,432.61 2,477,264.16 44.984 3,029,664.84
48 of 150
June 15, 2020 Regular Meeting Agenda Packet
glbase tbam skrolczyk Trophy Club MUD No.1 Page 7
10:08 06/10/20 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 5/2020
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-50005-020-000 Salaries & Wages 441,799.00 441,799.00 49,678.38 264,922.83 59.965
135-50010-020-000 Overtime 33,000.00 33,000.00 3,057.29 15,052.67 45.614
135-50016-020-000 Longevity 8,035.00 8,035.00 6,872.50 85.532
135-50017-020-000 Certification 9,000.00 9,000.00 700.00 5,075.00 56.389
135-50020-020-000 Retirement 45,531.00 45,531.00 4,948.15 28,560.50 62.728
135-50026-020-000 Medical Insurance 104,858.00 104,858.00 6,926.71 56,193.26 53.590
135-50027-020-000 Dental Insurance 5,817.00 5,817.00 392.75 3,271.97 56.248
135-50028-020-000 Vision Insurance 948.00 948.00 62.80 522.71 55.138
135-50029-020-000 Life Insurance & Other 4,500.00 4,500.00 384.52 2,953.70 65.638
135-50030-020-000 Social Security Taxes 30,494.00 30,494.00 3,225.26 17,033.26 55.858
135-50035-020-000 Medicare Taxes 7,132.00 7,132.00 754.28 3,983.55 55.855
135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 1,008.00 80.000
135-50045-020-000 Workman's Compensation 15,373.00 15,373.00 1,110.20 9,057.10 58.916
135-50060-020-000 Pre-emp Physicals/Testing 400.00 400.00 38.00 9.500
135-50070-020-000 Employee Relations 300.00 300.00 46.08 46.08 15.360
FSubtotal: 71,286.42 414,591.13
135-55005-020-000 Engqinee ing 30,000.00 30,000.00
135-55070-020-000 Independent Labor 15,000.00 15,000.00 3,000.00 20.000
135-55080-020-000 Maintenance & Repairs 88,000.00 88,000.00 5,867.12 48,003.48 54.549
135-55081-020-000 Mainten & Repairs Collections 10,000.00 10,000.00 18,113.87 181.139
135-55085-020-000 Generator Meant. and Repair 10,000.00 10,000.00
135-55090-020-000 Vehicle Maintenance 4,000.00 4,000.00 824.94 20.624
135-55091-020-000 Veh Maintenance Collections 8,000.00 8,000.00 8.92 2,020.80 25.260
135-55105-020-000 Maintenance-Backhoe/SkidLoader 3,000.00 3,000.00 200.00 1,032.22 34.407
135-55120-020-000 Cleaning Services 1,500.00 1,500.00 87.50 612.50 40.833
135-55125-020-000 Dumpster Services 100,000.00 100,000.00 10,256.66 61,872.84 61.873
135-55135-020-000 Lab Analysis 40,000.00 40,000.00 2,440.24 23,816.34 59.541
135-60010-020-000 Communications/Mobiles 5,000.00 5,000.00 407.91 3,904.09 78.082
135-60020-020-000 Electricity 160,067.00 160,067.00 11,132.02 84,380.01 52.715
135-60066-020-000 Publications/Books/Subscripts 200.00 200.00
135-60070-020-000 Dues & Memberships 300.00 300.00 216.00 72.000
135-60080-020-000 Schools & Training 4,990.00 4,990.00 420.00- 2,542.85 50.959
135-60090-020-000 Safety Program 1,000.00 1,000.00 109.14 10.914
135-60100-020-000 Travel & per diem 1,545.00 1,545.00 410.72 26.584
135-60105-020-000 Rent/Lease Equipment 5,000.00 5,000.00
135-60125-020-000 Advertising 2,500.00 2,500.00
135-60135-020-000 TCEQ Fees & Permits 15,000.00 15,000.00 10,088.02 67.253
135-60245-020-000 Miscellaneous Expenses 450.00 450.00
135-60280-020-000 Property Maintenance 5,000.00 5,000.00 584.94 11.699
49 of 150
176,876.17
17,947.33
1,162.50
3,925.00
16,970.50
48,664.74
2,545.03
425.29
1,546.30
13,460.74
3,148.45
252.00
6,315.90
362.00
253.92
293,855.87
30,000.00
12,000.00
39,996.52
8,113.87-
10,000.00
3,175.06
5,979.20
1,967.78
887.50
38,127.16
16,183.66
1,095.91
75,686.99
200.00
84.00
2,447.15
890.86
1,134.28
5,000.00
2,500.00
4,911.98
450.00
4,415.06
June 15, 2020 Regular Meeting Agenda Packet
glbase tbam skrolczyk Trophy Club MUD No.1
10:08 06/10/20 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 5/2020
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-60285-020-000
135-60331-020-000
135-60332-020-000
135-60333-020-000
135-60334-020-000
135-60360-020-000
Lawn Equipment & Maintenance
Interfund Transfer Out -Tax I&S
Interfund Transfer Out -Rev I&S
Interfund Transfer Out -Reserve
Interfund Transfer Out
Furniture/Equipment < $5000
14,000.00
114,563.00
673,867.00
125,187.00
180,000.00
2,000.00
14,000.00
114,563.00
673,867.00
125,187.00
180,000.00
2,000.00
1,480.00 2,960.00
10,414.81 83,318.48
54,421.63 490,085.00
5,750.00 46,000.00
190.00
Subtotal: 1,310,669.00 83,186.37 724,789.25
r 135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 368.08 5,106.21 40.850 7,393.79
135-65010-020-000 Uniforms 5,495.00 5,495.00 3,507.93 63.839 1,987.07
135-65030-020-000 Chemicals 20,000.00 20,000.00 2,788.92 19,928.34 99.642 71.66
135-65031-020-000 Chemicals Collections 17,500.00 17,500.00 4,994.00 28.537 12,506.00
135-65035-020-000 Small Tools 1,200.00 1,200.00 1,200.00
135-65040-020-000 Safety Equipment 1,200.00 1,200.00 1,166.53 97.211 33.47
135-65045-020-000 Lab Supplies 20,000.00 20,000.00 101.88 16,534.06 82.670 3,465.94
21.143 11,040.00
72.727 31,244.52
72.727 183,782.00
36.745 79,187.00
180,000.00
9.500 1,810.00
55.299 585,879.75
Page 8
135-69005-020-000
135-69008-020-000
135-69009-020-000
135-69195-020-000
Capital Outlays
Short Term Debt -Principal
Short Term Debt -Interest
Gasb34/Reserve for Replacement
Subtota.-
Program number:
Department number: Wastewater
530,500.00
79,133.00
11,277.00
130,000.00
530,500.00
79,133.00
11,277.00
130,000.00
750,910.00
3,157,421.00
3,157,421.00
50 of 150
111,949.00
111,949.00
288,541.11
288,541.11
294,012.00
59,604.74
6,122.03
130,000.00
489,738.77
1,839,653.21
1,839,653.E
55.422
75.322
54.288
100.000
�19
236,488.00
19,528.26
5,154.97
4 1,317,767
4 1,317,767
glbase_tbam skrolczyk
10:08 06/10/20
Fund: 135 MUD 1 General Fund
Account
1
1 135-50045-026-000
1
Description
Workman's Compensation
Trophy Club MUD No.1
Budget Summary with Amendment
Department: 26 Board of Directors
Period Ending: 5/2020
Adopted Amended Total
Budget Budget Encumb.
Current
Month
30.00 30.00 1.99
June 15, 2020 Regular Meeting Agenda Packet
Program:
YTD
Total
15.92
of
Budget
53.067
Remaining
Budget
14.08
Page
3
3
135-60066-026-000
135-60070-026-000
135-60075-026-000
135-60080-026-000
135-60100-026-000
135-60245-026-000
EMrSubtota1:
Program number:
Department number:
Publications/Books/Subscripts
Dues & Memberships
Meetings
Schools & Training
Travel & per diem
Miscellaneous Expenses
150.00
750.00
1,300.00
4,000.00
5,000.00
2,000.00
150.00
750.00
1,300.00
4,000.00
5,000.00
2,000.00
13,200. 0 13,200.00
123.99
675.00
413.81
90.000
31.832
150.00
75.00
886.19
4,000.00
5,000.00
2,000.00
12,111.19
— 13,230.00 — 13,230.00
125.98
12,125.27
Board of Directors
13,230.00
13,230.00
51 of 150
125.98
12,125.27
June 15, 2020 Regular Meeting Agenda Packet
glbase_tbam skrolczyk Trophy Club MUD No.1
10:08 06/10/20 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 5/2020
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-50005-030-000 Salaries & Wages 628,298.00 628,298.00
135-50010-030-000 Overtime 2,000.00 2,000.00
135-50016-030-000 Longevity 2,208.00 2,208.00
135-50020-030-000 Retirement 58,554.00 58,554.00
135-50026-030-000 Medical Insurance 124,394.00 124,394.00
135-50027-030-000 Dental Insurance 6,464.00 6,464.00
135-50028-030-000 Vision Insurance 1,035.00 1,035.00
135-50029-030-000 Life Insurance & Other 4,500.00 4,500.00
135-50030-030-000 Social Security Taxes 39,215.00 39,215.00
135-50035-030-000 Medicare Taxes 9,171.00 9,171.00
135-50040-030-000 Unemployment Taxes 1,440.00 1,440.00
135-50045-030-000 Workman's Compensation 1,775.00 1,775.00
135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00
135-50070-030-000 Employee Relations 8,000.00 8,000.00
47,423.61 256,791.62 40.871 371,506.38
31.77 1.589 1,968.23
2,207.50 99.977 .50
4,391.41 25,482.92 43.520 33,071.08
6,345.77 48,195.28 38.744 76,198.72
349.75 2,667.95 41.274 3,796.05
51.68 404.71 39.102 630.29
343.91 2,658.84 59.085 1,841.16
2,796.86 15,027.94 38.322 24,187.06
654.10 3,514.62 38.323 5,656.38
864.00 60.000 576.00
104.82 838.56 47.243 936.44
500.00
3,078.10 38.476 4,921.90
Page 10
525,790.19
135-55030-030-000
135-55070-030-000
135-55080-030-000
135-55085-030-000
135-55120-030-000
135-55160-030-000
135-55205-030-000
Software & Support
Independent Labor
Maintenance & Repairs
Generator Maint. and Repair
Cleanin7 Services
Professional Outside Services
Utility Billing Contract
134,681.00 134,681.00
135,000.00 135,000.00
15,000.00 15,000.00
10,000.00 10,000.00
10,000.00 10,000.00
65,600.00 65,600.00
9,000.00 9,000.00
135-60005-030-000 Telephone 23,680.00 23,680.00
135-60010-030-000 Communications/Mobiles 4,000.00 4,000.00
135-60020-030-000 Electricity/Gas 6,879.00 6,879.00
135-60025-030-000 Water 1,500.00 1,500.00
135-60035-030-000 Postage 30,000.00 30,000.00
135-60040-030-000 Service Charges & Fees 67,000.00 67,000.00
135-60050-030-000 Bad Debt Expense 1,500.00 1,500.00
135-60055-030-000 Insurance 84,000.00 84,000.00
135-60066-030-000 Publications/Books/Subscripts 1,000.00 1,000.00
135-60070-030-000 Dues & Memberships 6,000.00 6,000.00
135-60075-030-000 Meetings 400.00 400.00
135-60079-030-000 Public Education 6,000.00 6,000.00
135-60080-030-000 Schools & Training 6,850.00 6,850.00
135-60100-030-000 Travel & per diem 3,545.00 3,545.00
135-60110-030-000 Physicals/Testing 200.00 200.00
135-60115-030-000 Elections
135-60125-030-000 Advertising 2,500.00 2,500.00
52 of 150
52,776.08-
13,098.66
285.00
1,896.92
54,600.00
2,021.79
99.26
458.22
228.42-
4,934.27
80,570.16 59.823
88,810.54 65.786
1,560.00 10.400
531.00 5.310
7,658.64 76.586
57,100.00 87.043
4,179.68 46.441
12,195.34 51.501
1,815.12 45.378
3,907.56 56.804
1,250.60 83.373
11,725.51 39.085
46,836.29 69.905
6,998.39 52,425.26 62.411
125.00 12.500
4,285.55 71.426
115.09 28.773
3,971.51 66.192
1,452.21 21.200
77.97 1,098.61 30.990
138.04
1,772.20 70.888
54,110.84
46,189.46
13,440.00
9,469.00
2,341.36
8,500.00
4,820.32
138-rowye
11,484.66
2,184.88
2,971.44
249.40
18,274.49
20,163.71
1,500.00
31,574.74
875.00
1,714.45
284.91
2,028.49
5,397.79
2,446.39
200.00
138.04-
727.80
June 15, 2020 Regular Meeting Agenda Packet
glbase_tbam skrolczyk Trophy Club MUD No.1
10:08 06/10/20 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 5/2020
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-60235-030-000
135-60245-030-000
135-60246-030-000
135-60360-030-000
Security
Miscellaneous Expenses
General Manager Contingency
Furniture/Equipment < $5000
1,288.00 1,288.00
500.00 500.00
17,000.00 17,000.00
2,500.00 2,500.00
135-65010-030-000 Uniforms 2,050.00 2,050.00
135-65055-030-000 Hardware 26,485.00 26,485.00
135-65085-030-000 Office Supplies 6,000.00 6,000.00
135-65090-030-000 Printer Supplies & Maintenance 3,500.00 3,500.00
135-65095-030-000 Maintenance Supplies 4,000.00 4,000.00
135-65105-030-000 Printing 2,500.00 2,500.00
135-69005-030-000 Capital Outlays
135-69170-030-000 Copier Lease Installments
Program number:
Department number: Administration
195,000.00
4,000.00
195,000.00
4,000.00
,000.00
,712.00
,712.00
53 of 150
361.48
680.97
504.14
1,438.09
178.50
168.00 13.043
3,916.21
2,935.99
2,848.53
9,700.73
28,447.84
1,912.60
53.796
14.787
48.933
71.213
14.589
47.815
1111111157
1111111112
1,120.00
500.00
17,000.00
2,500.00
2,050.00
22,568.79
3,064.01
3,500.00
1,151.47
2,500.00
166,552.16
2,087.40
59 785,516.89 111111112 991,195.11
Page 11
June 15, 2020 Regular Meeting Agenda Packet
glbase tbam skrolczyk Trophy Club MUD No.1
10:08 06/10/20 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program:
Period Ending: 5/2020
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
1
1 135-55045-039-000 Le al 135,000.00 135,000.00
1 135-55055-039-000 Auditing 33,800.00 33,800.00
1 135-55060-039-000 Appraisal 11,761.00 11,761.00
1 135-55065-039-000 Tax Admin Fees 4,000.00 4,000.00
4,842.50
90,427.89
27,713.27
7,422.04
3,756.00
66.984
81.992
63.107
93.900
44,572.11
6,086.73
4,338.96
244.00
Page 12
Subtotal:
184,561.00 184,561.00
4,842.50 129,319.20
70.069 55,241.80
Program number:
184,561.00 184,561.00
4,842.50 129,319.20
70.069 55,241.80
Department number: Non Departmental
184,561.00 184,561.00
4,842.50 129,319.20
70.069 55,241.80
Expenditures
Subtotal 10,638,853.00 10,638,853.00 693,671.79 5,232,858.19 49.186 5,405,994.81
Fund number: 135 MUD 1 General Fund
6,224.00- 6,224.00-
54,840.64- 103,999.22-
1,670.939 97,775.22
54 of 150
glbase_tbam skrolczyk
10:08 06/10/20
Fund: 137 MUD 1 Consolidated GASS
Account Description
137-49145-000-000
137-49146-000-000
H
Subtot
Program number:
Intergov Transfer -General Fund
Intergov Transfer -Fire Dept
Department number:
Revenues Subtotal
Fund number: 137 MUD 1 Consolidated GASP
Department:
June 15, 2020 Regular Meeting Agenda Packet
Trophy Club MUD No.1 Page 13
Budget Summary with Amendment
Program:
Period Ending: 5/2020
Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
55 of 150
205,000.00-
81,420.00-
286,420.00-
286,420.00-
286,420.00-
286,420.00-
205,000.00
81,420.00
286,
286,420.00
286,420.00
286,420.00
286,420.00
glpdatb2 skrolczyk
10:08 06/10/20
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: 5/2020
JE Detail
Description/Comment
June 15, 2020 Regular Meeting Agenda Packet
Page 5
Program:
Beginning Transaction Transaction Vendor Name
Balance Detail Detail
(SUBTOTAL)
Check Source
Number
Account: 135-40000-000-000
L Property Taxes -11111
1272 05/01/2020 Property Taxes
1273 05/04/2020 Property Taxes
1274 05/05/2020 Property Taxes
1275 05/06/2020 property taxes
1277 05/07/2020 property taxes
1278 05/08/2020 property taxes
1279 05/11/2020 Property Taxes
1280 05/12/2020 Property Taxes
1281 05/14/2020 property taxes
1282 05/15/2020 property taxes
1283 05/18/2020 property taxes
1293 05/19/2020 property taxes
1284 05/20/2020 property taxes
1285 05/21/2020 property taxes
1286 05/22/2020 property taxes
1287 05/26/2020 property taxes
1288 05/27/2020 property taxes
1289 05/28/2020 property taxes
1290 05/29/2020 property taxes
(133,944.05)
(8.20) (133,952.25)
(.20) (133,952.45)
(.90) (133,953.35)
(37.03) (133,990.38)
(120.06) (134,110.44)
(4.88) (134,115.32)
(5.91) (134,121.23)
25.21 (134,096.02)
(16.94) (134,112.96)
(81.46) (134,194.42)
(29.32) (134,223.74)
(20.24) (134,243.98)
(49.13) (134,293.11)
(66.23) (134,359.34)
(46.72) (134,406.06)
(22.58) (134,428.64)
(74.28) (134,502.92)
(46.28) (134,549.20)
(59.91) (134,609.11)
Account: 135-40000-000-000
Property Taxes Totals:
(665.06) (134,609.11)
(134,871.00) Budgeted
(261.69) Remaining 100 % Used
Account: 135-40002-000-000 Property Taxes/Delinquent
1275 05/06/2020 property taxes
1280 05/12/2020 Property Taxes
1284 05/20/2020 property taxes
1285 05/21/2020 property taxes
1287 05/26/2020 property taxes
1288 05/27/2020 property taxes
(296.98)
(1.61)
22.19
(2.40)
(3.74)
(1.12)
(1.42)
(298.59)
(276.40)
(278.80)
(282.54)
(283.66)
(285.08)
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
Account: 135-40002-000-000
Property Taxes/Delinquent Totals:
(285.08)
(300.00) Budgeted
(14.92) Remaining 95 5 Used
Account: 135-40015-000-000 Property Taxes/P & I
1272 05/01/2020 Property Taxes
1273 05/04/2020 Property Taxes
1274 05/05/2020 Property Taxes
1275 05/06/2020 property taxes
1277 05/07/2020 property taxes
(436.64)
56 of 150
(.12) (436.76)
(.02) (436.78)
(.11) (436.89)
(.45) (437.34)
(13.29) (450.63)
GL
GL
GL
GL
GL
glpdatb2 skrolczyk
10:08 06/10/20
Fund: 135 MUD 1 General Fund
JE
Number
JE
Date
JE
Description
1279 05/11/2020 Property Taxes
1280 05/12/2020 Property Taxes
1282 05/15/2020 property taxes
1283 05/18/2020 property taxes
1293 05/19/2020 property taxes
1284 05/20/2020 property taxes
1285 05/21/2020 property taxes
1286 05/22/2020 property taxes
1287 05/26/2020 property taxes
1288 05/27/2020 property taxes
1289 05/28/2020 property taxes
1290 05/29/2020 property taxes
Account: 135-40015-000-000
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: Revenues
Period Ending: 5/2020
JE Detail Beginning
Balance
Description/Comment
Property Taxes/P & I
(300.00) Budgeted
168.83 Remaining
(436.64)
156 % Used
Program:
Transaction
Detail
June 15, 2020 Regular Meeting Agenda Packet
Page 6
Transaction Vendor Name
Detail
(SUBTOTAL)
(1.67) (452.30)
(.10) (452.40)
(7.31) (459.71)
(.57) (460.28)
(.10) (460.38)
(3.46) (463.84)
.03 (463.81)
(2.76) (466.57)
(.27) (466.84)
(.41) (467.25)
(.03) (467.28)
(1.55) (468.83)
(468.83)
Check Source
Number
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
Account: 135-40025-000-000
PID Surcharges
Account: 135-40025-000-000
PID Surcharges
(164,253.00) Budgeted (164,253.00) Remaining
Account: 135-47000-000-0:-
1134 05/01/2020 UB 05/01/2020 Acct Adjustment UB20200501-20200501 User:
1243 05/31/2020 UB 05/31/2020 Billing UB20200531-20200531 User:
(2,492,189.86)
0 % Used
.00
.00
71.31 (2,492,118.55)
(459,635.16) (2,951,753.71)
GB
GB
Account:
(6,486,623.00) Budgeted
135-47005-000-000
1139 05/04/2020 UB 05/04/2020 WA Adjustment
1141 05/04/2020 UB 05/04/2020 WA Adjustment
1246 05/05/2020 Swr adj
1247 05/06/2020 swr adj
1195 05/19/2020 UB 05/19/2020 WA Adjustments
1196 05/19/2020 UB 05/19/2020 WA Adjustments
1200 05/20/2020 UB 05/20/2020 WA Adjustment
1233 05/28/2020 UB 05/28/2020 WA Adjustments
1243 05/31/2020 UB 05/31/2020 Billing
(3,534,869.29)
UB20200504-20200504 User:
UB20200504-20200504 User:
UB20200505-20200505 User:
UB20200506-20200506 User:
UB20200519-20200519 User:
UB20200519-20200519 User:
UB20200520-20200520 User:
UB20200528-20200528 User:
UB20200531-20200531 User:
Remaining
46
(1,779,647.58)
Used
57 of 150
28.01 (1,779,619.57)
95.08 (1,779,524.49)
118.91 (1,779,405.58)
96.31 (1,779,309.27)
842.15 (1,778,467.12)
87.80 (1,778,379.32)
433.17 (1,777,946.15)
1,027.15 (1,776,919.00)
(276,485.14) (2,053,404.14)
UB
GB
GB
GB
GB
GB
G B
GB
G B
glpdatb2 skrolczyk
10:08 06/10/20
Fund: 135 MUD 1 General Fund
JE JE JE
Number Date Description
Account: 135-47005-00
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: Revenues Program:
Period Ending: 5/2020
JE Detail
Description/Comment
Sewer
(3,503,885.00) Budgeted
June 15, 2020 Regular Meeting Agenda Packet
Page 7
Beginning Transaction Transaction Vendor Name Check Source
Balance Detail Detail Number
(SUBTOTAL)
(1,450,480.86) Remaining
Account: 135-47025-000-000 Penalties
1245 05/01/2020 penalty removal UB20200501-20200501 User:
1232 05/28/2020 UB 05/28/2020 Penalty Removal UB20200528-20200528 User:
Account: 135-47025-000-000
,,Penalties
(112,608.00) Budgeted
(61,533.07)
59
Ueed
(51,132.79) 43.45 (51,089.34) UB
14.41 (51,074.93) UB
Remaining
45 % Used
AccountillEvice Cha
1231 05/21/2020 UB 05/21/2020 NSF Check
Account: 135-47035-000-000
UB20200521-20200521 User:
Service Charges
(15,150.00) Budgeted
Account: 135-47035-000-000
Account: 135-47045-000-000
Account: 135-47045-000-000
(9,800.00) (25.00) (9,825.00) UB
(5,325.00) Remaining 65 % Used
Plumbing Inspections
(2,250.00) .00 (2,250.00)
Plumbing Inspections Tota
(750.00) Budgeted 1,500.00 Remaining 300 % Used
Sewer Inspections
(1,350.00) .00 (1,350.00)
Sewer Inspections Totals: .00
(2,500.00) Budgeted (1,150.00) Remaining 54 % Used
Account: 135-47070-000-000 TCCC Effluent Charges
1243 05/31/2020 UB 05/31/2020 Billing UB20200531-20200531 User:
(17,065.60) (8,843.20) (25,908.80) GB
Account: 135-47070-000-000 TCCC Effluent Charges
(50,000.00) Budgeted
(8,843.20) (25,908.80) **
(24,091.20) Remaining 52 % Used
Account: 135-49011-00
ome
1269 05/31/2020 Bank Interest- May (63,617.94) (1,347.32) (64,965.26) GL
58 of 150
June 15, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 8
10:08 06/10/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 5/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
1269 05/31/2020 Bank Interest- May (63,617.94)
1269 05/31/2020 Bank Interest- May
Account: 135-49011-000-0001111111
Account: 135-49016-000-000
1263 05/29/2020 Cell Tower Rev AT&T
(1,154.60) (66,119.86) GL
(1,262.43) (67,382.29) GL
Totals:
(120,000.00) Budgeted (52,617.71) Remaining 56 % Used
Cell Tower Revenue
(7,072.86)
(1,178.81) (8,251.67) GL
Cell Tower Revenue Totals:
(14,146.00) Budgeted
(5,894.33) Remaining 58 % Ueed
Building Rent Income
1265 05/31/2020 Town Billed Invoices 1738-1741 AR 20200531-20200531 User: (4,083.31)
Account: 135-49018-000-00 Building Rent Income
(7,000.00) Budgeted
Account: 135-49026-000-000
(583.33) (4,666.64)
(2,333.36) Remaining 67 % Used
111111111 Proceeds from Sale of Assets
Account: 135-49026-000-000 Proceeds from Sale of Asse
(13,000.00) Budgeted (4,075.00) Remaining
(8,925.00)
69 % Ueed
.00 (8,925.00)
AR
Account: 135-49075-000-000
Account: 135-49075-000-000
` Oversize Meter Reimbursement Totals:
(12,691.00) Budgeted (4,960.72) Remaining
(7,730.28)
61 % Used
.00
(7,730.28)
Account: 135-49900-000-00 Miscellaneous In
1243 05/31/2020 UB 05/31/2020 Billing
U820200531-20200531 Ueer:
Miscellaneous In
(7,000.00) Budgeted
1,971.93
Remaining
(8,802.09)
128
Used
(169.84)
(8,971.93)
Department Totals: (5,336,857.41) ••
(748,512.43) Monthly Total
(10,645,077.00) Budgeted (5,308,219.59) Remaining 50 % Used
59 of 150
UB
glpdatb2 skrolczyk
10:08 06/10/20
Fund: 135 MUD 1 General Fund
JE JE JE
Number Date Description
Department: 10 Water
JE Detail
Description/Comment
Account: 135-50005-010- Salaries & W
1110 05/01/2020 MUD Payroll 5/1/2020
1180 05/15/2020 MUD Payroll 5/15/2020
1223 05/29/2020 MUD Payroll 5/29/2020
Account
Salaries & Wages
Salaries & Wages
Salaries & Wages
350,267.00 Budgeted
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Period Ending: 5/2020
Beginning
Balance
June 15, 2020 Regular Meeting Agenda Packet
Page 9
Program:
Transaction Transaction Vendor Name Check Source
Detail Detail Number
(SUBTOTAL)
192,746.19 15,439.35 208,185.54 PR
15,439.35 223,624.89 PR
15,439.35 239,064.24 PR
111,202.76 Remaining 68 % Used
ACCOun
1110 05/01/2020 MUD Payroll 5/1/2020
Overtime
1180 05/15/2020 MUD Payroll 5/15/2020 Overtime
1223 05/29/2020 MUD Payroll 5/29/2020 Overtime
11,865.26 515.40 12,380.66 PR
505.40 12,886.06 PR
541.69 13,427.75 PR
Aoc
17,000.00
Budgeted
3,572.25
Remaining
79
Used
Account: 135-50016-010-000
Longevity
5,082.50
.00 5,082.50
Accmmtall Longevity
3,920.00 Budgeted
Totals:
(1,162.50) Remaining 130 % Used
Account: 135-50017-010-000 Certification
1180 05/15/2020 MUD Payroll 5/15/2020 Certification 2,925.00 425.00 3,350.00 PR
Account: 135-50017-010-001 Certification Totals:
5,400.00 Budgeted
Account: 135-50020-010-000
1110 05/01/2020 MUD Payroll 5/1/2020 Retirement
1180 05/15/2020 MUD Payroll 5/15/2020 Retirement
1223 05/29/2020 MUD Payroll 5/29/2020 Retirement
Account: 135-50020-010-000
34,863.00 Budgeted
Account: 135-50026-0
1110 05/01/2020 MUD Payroll 5/1/2020 Medical Insurance
2,050.00 Remaining 62 % Ueed
20,760.14 1,477.42 22,237.56 PR
1,515.84 23,753.40 PR
1,479.84 25,233.24 PR
9,629.76 Remaining 72 % Ueed
34,828.70 2,612.55 37,441.25 PR
60 of 150
glpdatb2 skrolczyk Trophy Club MUD No.1
10:08 06/10/20
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 5/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Detailed Accounting Trial Balance
June 15, 2020 Regular Meeting Agenda Packet
Page 10
1180 05/15/2020 MUD Payroll 5/15/2020 Medical Insurance
Account: 135-50026-010- edical Insurance
84,326.00 Budgeted
Account: 135-50027-010-000 Dental Insurance
1110 05/01/2020 MUD Payroll 5/1/2020 Dental Insurance
1180 05/15/2020 MUD Payroll 5/15/2020 Dental Insurance
Account:
Totals:
44,272.26 Remaining
34,828.70
2,114.74
2,612.49 40,053.74
47 % Used
158.32
158.31
2,273.06
2,431.37
PR
PR
PR
4,725.00 Budgeted
1110 05/01/2020 MUD Payroll 5/1/2020 Vision Insurance
1180 05/15/2020 MUD Payroll 5/15/2020 Vision Insurance
Account: 135 Vision Insurance
767.00 Budgeted
2,293.63 Remaining
Account: 135-50029-010-00 Life Insuran
1095 05/01/2020 May A/P Employee Benefits
1122 05/01/2020 May Payroll Benefits Employee LTD & STD
1215 05/21/2020 May A/P cafe 125 plan
Account: 135
1110 05/01/2020 MUD Payroll 5/1/2020
1180 05/15/2020 MUD Payroll 5/15/2020
1223 05/29/2020 MUD Payroll 5/29/2020
Account: 135
1110 05/01/2020 MUD Payroll 5/1/2020
1180 05/15/2020 MUD Payroll 5/15/2020
Life Insurance & Othe
3,132.00 Budgeted
51 % Used
332.47
s Totals:
386.35 Remaining 50 % Used
24.10 356.57
24.08 380.65
2,206.06 176.88 2,382.94 Humana Inc
132.01 2,514.95 METLIFE GROUP BENEFITS
20.00 2,534.95 BenefitMall
597.05 Remaining 81 % Used
Social Security Taxes
Social Security Taxes
Social Security Taxes
Social Security Taxes
Social Security Taxes
23,348.00 Budgeted
Medicare Taxes
Medicare Taxes
Medicare Taxes
7,346.67
Remaining
95 **
PR
PR
6414 AP
6417 AP
6441 AP
13,026.95 984.19 14,011.14 PR
999.37 15,010.51 PR
990.82 16,001.33 PR
69
3,046.60
Used
61 of 150
230.18 3,276.78
233.72 3,510.50
PR
PR
glpdatb2 skrolczyk Trophy Club MUD No.1
10:08 06/10/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 5/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
June 15, 2020 Regular Meeting Agenda Packet
Page 11
1223 05/29/2020 MUD Payroll 5/29/2020 Medicare Taxes
Account: 135-58 I.0-000
3,046.60 231.72
Medicare Taxes Totals: 69
5,461.00 Budgeted 1,718.78 Remaining 69 % Used
Account: 135-50040-010-000
Account: 135-50040-010-000
3,742.22 PR
Unemployment Taxes
880.68 .00 880.68
Unemployment Taxes
1,080.00 Budgeted 199.32 Remaining 82 % Used
Account: 135-50045-010- Workman's Compensation
73 05/01/2020 Insurance/Wrk Comp Expense May
Account: 135-50045-0 kman's Compensation
11,850.00 Budgeted
Account: 135-50060-010-000
Account: 135-50060-010-000
Pre-emp Physicals/Testing
5,575.93 771.49
5,502.58 Remaining 54 % Used
Pre-emp Physicals/Testing Totals:
400.00 Budgeted 400.00 Remaining
Account: 135-50070-010-000 Employee Relations
Account: 135-50070-010-000
Employee Relations Totals:
300.00 Budgeted
Account: 135-55005-010-000 Engineering
Account: 135-55005-010-000 — Engineer
20,000.00 Budgeted
Account: 13580-010-000 e & R
1215 05/21/2020 May A/P Irrigation repair
0 % Used
6,347.42 GL
.00 .00
.00 .00
300.00 Remaining 0 % Ueed
.00 .00
20,000.00 Remaining 0 % Used
24,431.71 257.25
62 of 150
24,688.96 Stephen [,arxer 6463 AP
glpdatb2 skrolczyk
10:08 06/10/20
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 5/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Trophy Club MUD No.1
Detailed Accounting Trial Balance
June 15, 2020 Regular Meeting Agenda Packet
Page 12
1215 05/21/2020 May A/P irrigation repair
1215 05/21/2020 May A/P Irrigation repair
1215 05/21/2020 May A/P meter boxes
1249 05/26/2020 PCards 4/28/2020-5/26/2020 4x4 bushing
1249 05/26/2020 PCards 4/28/2020-5/26/2020 valves, pressure principles
1249 05/26/2020 PCards 4/28/2020-5/26/2020 torch head, propane cylinder
1249 05/26/2020 PCards 4/28/2020-5/26/2020 sod
24,431.71
235.74
500.00
3,931.20
3.50
76.65
41.44
44.20
24,924.70 Stephen Marxer
25,424.70 Stephen Marxer
29,355.90 Core & Main LP
29,359.40 ROANOKE WINNELSON CO
29,436.05 SC TRACKING SOLUTIONS
29,477.49 THE HOME DEPOT #6581
29,521.69 TEX-TURF
6463 AP
6463 AP
6444 AP
PC
PC
PC
PC
Account:
135-55080-010-000
Maintenance & Repairs Totals:
5,089.98
29,521.69
**
100,000.00 Budgeted 70,478.31 Remaining
30 5
Used
Account:
135-55085-010-000
Generator Maint. and Repair
.00
.00
Account:
135-55085-010-000
Generator Maint. and Repair Totals:
.00
.00
**
3,000.00 Budgeted 3,000.00 Remaining
0 %
Used
Account:
135-55090-010-000
Vehicle Maintenance
1249 05/26/2020 PCards
1249 05/26/2020 PCards
4/28/2020-5/26/2020 wheel bearing
4/28/2020-5/26/2020 oil change
1,842.56
517.51
84.36
2,360.07
2,444.43
GIERISCH CARE 0050292
KWIK KAR LUBE & TUNE 0
PC
PC
Account:
135-55090-010-000
Vehicle Maintenance Totals:
601.87
2,444.43
**
5,000.00 Budgeted 2,555.57 Remaining
49 %
Used
Account:
135-55105-010-000
Maintenance-Backhoe/SkidLoader
1,828.19
.00
1,828.19
Account:
135-55105-010-000
Maintenance-Backhoe/SkidLoader Totals:
.00
1,828.19
**
3,500.00 Budgeted 1,671.81 Remaining
52 %
Used
Account:
135-55120-010-000
Cleaning Services
1215 05/21/2020 May A/P
Janitorial service -April
525.00
87.50
612.50
MEMBER'S BUILDING MAINTENANCE
6458
AP
Account:
135-55120-010-000
Cleaning Services Totals:
87.50
612.50
**
1,000.00 Budgeted 387.50 Remaining
61 5
Used
Account:
135-55135-010-000
Lab Analysis
2,451.64
.00
2,451.64
63 of 150
glpdatb2 skrolczyk Trophy Club MUD No.1
10:08 06/10/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 5/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
June 15, 2020 Regular Meeting Agenda Packet
Page 13
Account: 135-55135-010-000
Lab Analysis Totals: .00 2,451.64 **
7,500.00 Budgeted
5,048.36 Remaining 33 % Used
Account: 135-60010-010-000 Communications/Mobiles
1178 05/11/2020 May A/P Cell phones
3,267.94 385.40
3,653.34 VERIZON WIRELESS 6438 AP
Account: 135-60010-010-000
Communications/Mobiles Totals: 385.40 3,653.34 **
5,000.00 Budgeted
1,346.66 Remaining 73 % Used
Account: 135-60020-010-000 Electricity
1215 05/21/2020 May A/P Electricity 4/8-5/8
71,633.79 9,128.56
80,762.35 HUDSON ENERGY SERVICES, LLC 6450 AP
Account: 135-60020-010-000
Electricity Totals: 9,128.56 80,762.35 **
125,677.00 Budgeted
44,914.65 Remaining 64 % Used
Account: 135-60066-010-000 Publications/Books/Subscripts
850.00
.00 850.00
Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 850.00 **
1,000.00 Budgeted
150.00 Remaining 85 % Used
Account: 135-60070-010-000 Dues & Memberships
105.00
.00 105.00
Account: 135-60070-010-000
Dues & Memberships Totals: .00 105.00 **
500.00 Budgeted
395.00 Remaining 21 % Used
Account: 135-60080-010-000 Schools & Training
1249 05/26/2020 PCards 4/28/2020-5/26/2020 license renewal J. Ramirez
1,436.00 111.00 1,547.00 TCEQ IND RENEWAL LIC
PC
Account: 135-60080-010-000
Schools & Training Totals: 111.00 1,547.00 **
7,426.00 Budgeted
5,879.00 Remaining 21 % Used
Account: 135-60090-010-000 Safety Program
.00 .00
64 of 150
glpdatb2 skrolczyk Trophy Club MUD No.1
10:08 06/10/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 5/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
ACC
June 15, 2020 Regular Meeting Agenda Packet
Page 14
Account: 135-60100-010-000
Account: 135-60105-010-000
Account: 135-60105-010-000
Account: 135-60135-010-000
Account: 135-60135-010-00:
Account: 135-60150-010-0
1251 05/31/2020 May A/P
Account: 135-60245-010-000
Account: 135-60245-010-000
Account: 135-60280-010-000
Safety Program
400.00 Budgeted
Travel & per diem
400.00 Remaining 0 % Used
Travel & per diem Totals:
2,845.00 Budgeted
Rent/Lease Equipment
Rent/Lease Equipment
1,500.00 Budgeted
TCEQ Fees & Permit
TCEQ Fees & Permits
63,000.00 Budgeted
2,845.00 Remaining 0 % Used
Totals:
1,500.00 Remaining
20,205.04
0 % Used
42,794.96 Remaining 32 % Used
Wholesale Water
Wholesale water 752,381.54
Wholesale Water
2,714,710.00 Budgeted
Miscellaneous Expenses
Miscellaneous Expenses
200.00 Budgeted
Property Maintenance
.00 .00
.00 .00
.00
20,205.04
130,922.95 883,304.49 CITY OF FORT WORTH
1,831,405.51 Remaining 33 % Used
.00
200.00 Remaining 0 % Used
756.00 .00
65 of 150
.00
756.00
6470 AP
glpdatb2 skrolczyk
10:08 06/10/20
Fund: 135 MUD 1 General Fund
ACC
JE JE JE
Number Date Description
1251 05/31/2020 May A/P
Account: 135-60285-010-000
Account: 135
1292 05/31/2020 TexPool Transfers May
Account: 135-60332-010-00
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: 10 Water Program:
Period Ending: 5/2020
JE Detail
Description/Comment
Property Maintenance Tota
3,000.00 Budgeted
June 15, 2020 Regular Meeting Agenda Packet
Page 15
Beginning Transaction Transaction Vendor Name Check Source
Balance Detail Detail Number
(SUBTOTAL)
2,244.00 Remaining 25 % Used
Lawn Equipment & Maintenance
Mowing -May
Lawn Equipment & Maintenance Totals:
14,750.00 Budgeted 11,750.00 Remaining
Interfund Transfe-
TexPool O&M to 16Swift Rev I&S
Interfund Transfer
527,381.00 Budgeted
Account: 135-60333-010-000
1292 05/31/2020 TexPool Transfers May
143,831.08
1,500.00 1,500.00 3,000.00 WATTS ELLISON LLC
20 % Used
25,047.72 383,549.92
358,502.20
Remaining
Interfund Transfer Out -Reserve
TexPool O&M to Rev Bond Resevr 32,200.00
73
Used
Account: 135-60333-010-000 X Interfund Transfer Out -Reserve TotlEr
55,193.00 Budgeted 18,393.00 Remaining 67 % Used
Account: 135-60334-010-000 erfund Transfer Ou
Account: 135-60334-010-000 Interfund Transfer Out
180,000.00 Budgeted 180,000.00 Remaining 0 % Used
Account: 135-60360-010-000 Furniture/Equipment < $5000
Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals:
2,500.00 Budgeted 1,938.28 Remaining
Account: 135-65005-010-000 Fuel & Lube
1236 05/24/2020 Fuel Fuel -may
561.72
4,600.00
4,600.00
36,800.00
36,800.00
.00 .00
.00 .00
.00 561.72
22 % Used
6483 AP
GL
GL
5,733.85 442.13 6,175.98 US Bank Voyager Fleet Systems 6481 AP
66 of 150
glpdatb2 skrolczyk
10:08 06/10/20
Fund: 135 MUD 1 General Fund
JE JE JE
Number Date Description
Department: 10 Water
JE Detail
Description/Comment
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Period Ending: 5/2020
Beginning
Balance
June 15, 2020 Regular Meeting Agenda Packet
Page 16
Program:
Transaction Transaction Vendor Name
Detail Detail
(SUBTOTAL)
Check Source
Number
67 of 150
Account:
135-65005-010-000
Fuel & Lube
Totals:
442.13
6,175.98
**
15,000.00 Budgeted
8,824.02 Remaining
41 %
Used
Account:
135-65010-010-000
Uniforms
2,917.33
.00
2,917.33
Account:
135-65010-010-000
Uniforms
Totals:
.00
2,917.33
**
_
5,190.00 Budgeted
2,272.67 Remaining
56 %
Used
Account:
135-65030-010-000
Chemicals
=
1191 05/18/2020 mAY a/p
1251 05/31/2020 May A/P
testing supplies
chorine
11,862.25
1,008.16
781.77
12,870.41
13,652.18
HACH
DPC
COMPANY
INDUSTRIES, INC
6448
6471
AP
AP
Account:
135-65030-010-000
Chemicals
Totals:
1,789.93
13,652.18
**
20,000.00 Budgeted
6,347.82 Remaining
68 %
Used
Account:
135-65035-010-000
Small Tools
.00
.00
Account:
135-65035-010-000
Small Tools
Totals:
.00
.00
**
1,200.00 Budgeted
1,200.00 Remaining
0 %
Used
Account:
135-65040-010-000
Safety Equipment
.00
.00
Account:
135-65040-010-000
Safety Equipment
Totals:
.00
.00
**
1,000.00 Budgeted
1,000.00 Remaining
0 %
Used
Account:
135-65050-010-000
Meter Expense
59,593.08
.00
59,593.08
Account:
135-65050-010-000
Meter Expense
Totals:
.00
59,593.08
**
70,000.00 Budgeted
10,406.92 Remaining
85 %
Used
Account:
135-65053-010-000
Meter Change Out Program
36,900.00
.00
36,900.00
67 of 150
glpdatb2 skrolczyk
10:08 06/10/20
Fund: 135 MUD 1 General Fund
JE JE JE
Number Date Description
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: 10 Water Program:
Period Ending: 5/2020
JE Detail
Description/Comment
June 15, 2020 Regular Meeting Agenda Packet
Page 17
Beginning Transaction Transaction Vendor Name Check Source
Balance Detail Detail Number
(SUBTOTAL)
Account: 135-65053-010-000 Meter Change Out Program Tota
87,000.00 Budgeted 50,100.00 Remaining
Account: Capital Outlays
1084 05/01/2020 Capital Asset Fund Corrections
1215 05/21/2020 May A/P 20. gate valve and line stop -f
Account: 135-69005-010-000 Capital Outlays
684,875.00 Budgeted
Account: 135-69008-010-000
42 % Used
276,524.74 (10,507.78) 266,016.96 GL
348,983.56 Remaining 49 % Used
Short Term Debt -Principal
Account: 135-69008-010-000
30,512.00 Budgeted
Account: 135-69009-010-000
Short Term Debt -Principal
Account: 135-69009-010-000
Account: 135-69195-010-000
Account: 135-69195-010-000
Short Term Debt -Interest
Totals: -
.00 Remaining
Short Term Debt -Interest Totals:
3,231.00 Budgeted 1,391.00 Remaining
Gasb34/Reserve for Replacement
Gasb34/Reserve for Replacement Total..
75,000.00 Budgeted .00 Remaining
30,512.00
100 % Used
1,840.00
75,000.00
57 ', Used
69,874.48 335,891.44 REY-MAR CONSTRUCTION 6462 AP
.00 30,512.00
.00 1,840.00
.00
100 % Used
75,000.00
Account: 135-69281-010-000 Water Tank Inspection Contract
Account: 135-69281-010-000
102,077.11
Water Tank Inspection Contract Totals:
120,000.00 Budgeted 17,922.89 Remaining
.00 102,077.11
85 % Used
Account: 135-70040-010-000 ed Expenses
1300 05/20/2020 AG Fee Refund Tax Series 2020 Refunding Tax Bond Series 2020 1,220.00
68 of 150
1,220.00 ATTORNEY GENERAL/STATE OF TX 6501 AP
glpdatb2 skrolczyk
10:08 06/10/20
Fund: 135 MUD 1 General Fund
JE JE JE
Number Date Description
1 Account: 135-70040-010-000
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: 10 Water Program:
Period Ending: 5/2020
JE Detail
Description/Comment
Bond Related Expenses Totals:
.00 Budgeted
June 15, 2020 Regular Meeting Agenda Packet
Page 18
Beginning Transaction Transaction Vendor Name Check Source
Balance Detail Detail Number
(SUBTOTAL)
(1,220.00) Remaining 0 % Used
69 of 150
1,220.00
1,220.00 **
glpdatb2 skrolczyk
10:08 06/10/20
Fund: 135 MUD 1 General Fund
JE JE JE
Number Date Description
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: 10 Water Program: 1 Lab Analysis for PID
Period Ending: 5/2020
Beginning Transaction Transaction Vendor Name Check Source
Balance Detail Detail Number
(SUBTOTAL)
June 15, 2020 Regular Meeting Agenda Packet
Page 19
JE Detail
Description/Comment
Account: 135-55135-010-001
Lab Analysis for PID
1,001.64
.00 1,001.64
Account: 135-55135-010-001
Lab Analysis for PID Totals: .00 1,001.64 **
2,000.00 Budgeted
998.36 Remaining 50 % Used
Department 10 Totals: 2,477,264.16 **
303,432.61 Monthly Total 5,506,929.00 Budgeted 3,029,664.84 Remaining 45 % Used
70 of 150
June 15, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20
10:08 06/10/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 5/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-50005-020- Salaries & We
1110 05/01/2020 MUD Payroll 5/1/2020 Salaries & Wages
1180 05/15/2020 MUD Payroll 5/15/2020 Salaries & Wages
1223 05/29/2020 MUD Payroll 5/29/2020 Salaries & Wages
Account Iies & Wages
441,799.00 Budgeted
Account: 135-50010-020-00
1110 05/01/2020 MUD Payroll 5/1/2020 Overtime
1180 05/15/2020 MUD Payroll 5/15/2020 Overtime
1223 05/29/2020 MUD Payroll 5/29/2020 Overtime
215,244.45 16,559.46 231,803.91 PR
16,559.46 248,363.37 PR
16,559.46 264,922.83 PR
176,876.17 Remaining 60 % Used
11,995.38 329.19 12,324.57 PR
1,471.69 13,796.26 PR
1,256.41 15,052.67 PR
Aoc
33,000.00
Budgeted
17,947.33
Remaining
46
Used
Account: 135-50016-020-000
Longevity
Account: 135-50016-020-000
Longevity
8,035.00 Budgeted
Account: 135 Certification
1110 05/01/2020 MUD Payroll 5/1/2020 Certification
1180 05/15/2020 MUD Payroll 5/15/2020 Certification
Certification
9,000.00 Budgeted
Account: 135-50020-020-000 Retirement
1110 05/01/2020 MUD Payroll 5/1/2020 Retirement
1180 05/15/2020 MUD Payroll 5/15/2020 Retirement
1223 05/29/2020 MUD Payroll 5/29/2020 Retirement
6,872.50
.00 6,872.50
Totals:
1,162.50 Remaining 86 % Used
4,375.00
3,925.00 Remaining 56 % Used
23,612.35
etirement Totals:
45,531.00 Budgeted
1 Ac Medical Insurance
16,970.50 Remaining 63 % Used
71 of 150
75.00 4,450.00
625.00 5,075.00
PR
PR
1,570.84 25,183.19 PR
1,727.55 26,910.74 PR
1,649.76 28,560.50 PR
June 15, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21
10:08 06/10/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 5/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
1110 05/01/2020 MUD Payroll 5/1/2020
Medical Insurance 49,266.55
1180 05/15/2020 MUD Payroll 5/15/2020 Medical Insurance
3,463.38 52,729.93
3,463.33 56,193.26
PR
PR
Accal1111035-50026-020
Medical Insurance Totals:
48,664.74 Remaining 54 % Used
104,858.00 Budgeted
Account: 135-50027-020-009 Dental Insurance
1110 05/01/2020 MUD Payroll 5/1/2020 Dental Insurance
1180 05/15/2020 MUD Payroll 5/15/2020 Dental Insurance
Account: 135-50027-020-000
limiEcount: 135-1028-020-00
1110 05/01/2020 MUD Payroll 5/1/2020
1180 05/15/2020 MUD Payroll 5/15/2020
Dental Insur-
5,817.00 Budgeted
Vision Insurance
Vision Insurance
2,545.03
Remaining
2,879.22
459.91
56
Used
196.39
196.36
3,075.61
3,271.97
31.40 491.31
31.40 522.71
PR
PR
PR
PR
Account: 135 -50028 -020 -
Vision Insurance Totals:
Account: 135-50029-020-000
1095 05/01/2020 May A/P
1122 05/01/2020 May Payroll Benefits
1215 05/21/2020 May A/P
Account: 135-50029-020-000
Account: 135-50030-020-000
1110 05/01/2020 MUD Payroll 5/1/2020
1180 05/15/2020 MUD Payroll 5/15/2020
1223 05/29/2020 MUD Payroll 5/29/2020
Account: 135-50030-020-000
Account: 135-50035-0
1110 05/01/2020 MUD Payroll 5/1/2020
948.00 Budgeted
Life Insurance & Other
Employee Benefits
Employee LTD & STD
cafe 125 plan
Life Insurance & Other
4,500.00 Budgeted
425.29 Remaining 55 % Used
2,569.18 186.78 2,755.96 Humana Inc
165.74 2,921.70 METLIFE GROUP BENEFITS
32.00 2,953.70 BenefitMall
1,546.30 Remaining 66 % Ueed
Social Security Taxes
Social Security Taxes
Social Security Taxes
Social Security Taxes
Social Security Taxes
30,494.00 Budgeted
Faxen ■
Medicare Taxes
13,808.00
1,026.69
1,091.37
1,107.20
13,460.74 Remaining 56 % Used
14,834.69
15,926.06
17,033.26
6414 AP
6417 AP
6441 AP
PR
PR
PR
3,229.27 240.13 3,469.40 PR
72 of 150
June 15, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22
10:08 06/10/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 5/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
1180 05/15/2020 MUD Payroll 5/15/2020
1223 05/29/2020 MUD Payroll 5/29/2020
Account: 135
Account: 135-50040-020-000
Medicare Taxes
Medicare Taxes
Medicare Taxes Totals:
7,132.00 Budgeted
Unemployment Taxes
Account Unemployment Taxes
1,260.00 Budgeted
Account: 135-50045-020-000 Workman's Compensation
73 05/01/2020 Insurance/Wrk Comp Expense May
3,229.27 255.22 3,724.62 PR
258.93 3,983.55 PR
3,148.45 Remaining 56 % Used
1,008.00
.00 1,008.00
252.00 Remaining 80 % Ueed
Account: 135-50045-020- Workman's Compensation Tot -
15,373.00 Budgeted 6,315.90 Remaining
7,946.90
1,110.20
59 % Used
9,057.10
GL
Account: 135-50060-020-000
Pre-emp Physicals/Testing
Account: 135-50060-020-000
Pre-emp Physicals/Testing
400.00 Budgeted
Account: 135-50070-020-0'
1249 05/26/2020 PCarde 4/28/2020-5/26/2020
lunch
362.00 Remaining
or WWTP employees
Account: 135-50070-02 Employee Relations
300.00 Budgeted
38.00
10 % Used
253.92 Remaining 15 % Used
.00 38.00
46.08
46.08
MARCOS PIZZA
5143
PC
Account: 135-55005-020-000
. Engineering
.00 .00
Account: 135-55005-020-000
Engineering T
30,000.00 Budgeted
30,000.00 Remaining 0 % Used
Account: 135-55070-020-000 Independent Labor
73 of 150
June 15, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 23
10:08 06/10/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 5/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
3,000.00
.00 3,000.00
Account: 135-55070-020-000
Independent Labor Totals: .00 3,000.00 **
15,000.00 Budgeted
12,000.00 Remaining 20 % Used
Account: 135-55080-020-000 Maintenance & Repairs
1191 05/18/2020 mAY a/p replace float 42,136.36 632.00 42,768.36 DHS AUTOMATION, INC 6446 AP
1191 05/18/2020 mAY a/p 490.00 43,258.36 DHS AUTOMATION, INC 6446 AP
1191 05/18/2020 mAY a/p 750.00 44,008.36 DHS AUTOMATION, INC 6446 AP
1191 05/18/2020 mAY a/p replace light fixtures 1,460.00 45,468.36 DHS AUTOMATION, INC 6446 AP
1191 05/18/2020 mAY a/p replace ballasts in press room 774.00 46,242.36 DHS AUTOMATION, INC 6446 AP
1191 05/18/2020 mAY a/p install lights under shoot 1,310.00 47,552.36 DHS AUTOMATION, INC 6446 AP
1249 05/26/2020 PCarde 4/28/2020-5/26/2020 hose and accessories 451.12 48,003.48 IN *HOSE TECH USA PC
Account: 135-55080-020-000"1111 Maintenance & Repairs Totals: 5,867.12 48,003.48 **
88,000.00 Budgeted
39,996.52 Remaining 55 % Used
Account: 135-55081-020-000 Mainten & Repairs Collections
18,113.87
.00 18,113.87
Account: 135-55081-020-000 Mainten & Repairs Collections Totals: .00 18,113.87 **
10,000.00 Budgeted
(8,113.87) Remaining 181 % Used
Account: 135-55085-020-000 Generator Maint. and Repair
.00 .00
Account: 135-55085-020-000 Generator Maint. and Repair Totals: .00 .00 **
10,000.00 Budgeted
10,000.00 Remaining 0 % Used
Account: 135-55090-020-000 Vehicle Maintenance
824.94
.00 824.94
Account: 135-55090-020-000
Vehicle Maintenance Totals: .00 824.94 **
4,000.00 Budgeted
3,175.06 Remaining 21 % Used
Account: 135-55091-020-000 Veh Maintenance Collections
1249 05/26/2020 PCards 4/28/2020-5/26/2020 gas cap
2,011.88 8.92 2,020.80 ROANOKE AUTO SUPPLY LT
74 of 150
PC
glpdatb2 skrolczyk
10:08 06/10/20
Fund: 135 MUD 1 General Fund
ACC
JE
Number
JE
Date
JE
Description
1251 05/31/2020 May A/P
Account: 135-55105-020-000
Account: 135-55120-020-000
1215 05/21/2020 May A/P
Account: 135-55120-020-000
Account: 135-55125-020-000
1178 05/11/2020 May A/P
1251 05/31/2020 May A/P
1251 05/31/2020 May A/P
1251 05/31/2020 May A/P
Account: 135-55125-020-000
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: 20 Wastewater
Period Ending: 5/2020
JE Detail Beginning
Balance
Description/Comment
Veh Maintenance Collections Totals:
8,000.00 Budgeted 5,979.20 Remaining
Maintenance-Backhoe/SkidLoader
1 yr JD -Link renewal (backhoe)
Maintenance-Backhoe/SkidLoader Totals:
3,000.00 Budgeted 1,967.78 Remaining
Cleaning Services
Janitorial service -April
Cleaning Sery cec -
1,500.00 Budgeted 887.50 Remaining
Dumpster Services
sludge haul off
sludge haul off
sludge haul off
sludge haul off
Dumpster Services
100,000.00 Budgeted
38,127.16 Remaining
5-55135-020-000 ' Lab Analysis
1178 05/11/2020 May A/P lab testing
1178 05/11/2020 May A/P lab testing
1191 05/18/2020 mAY a/p lab testing
1191 05/18/2020 mAY a/p lab testing
1215 05/21/2020 May A/P lab testing
1215 05/21/2020 May A/P lab testing
1249 05/26/2020 PCards 4/28/2020-5/26/2020 shipping for lab analysis
1251 05/31/2020 May A/P lab testing
1251 05/31/2020 May A/P lab testing
Lab Analysis
40,000.00 Budgeted
832.22
Program:
Transaction
Detail
25 % Used
34 % Used
June 15, 2020 Regular Meeting Agenda Packet
Page 24
Transaction Vendor Name
Detail
(SUBTOTAL)
8_ 2,020.80 **
200.00
200.00
1,032.22 RDO Equipment Co
1,032.22 **
Check Source
Number
AIIII
6477 AP
525.00 87.50 612.50 MEMBER'S BUILDING MAINTENANCE 6458 AP
41 % Used
51,616.18
62 % Used
21,376.10
16,183.66 Remaining 60 % Used
75 of 150
2,471.32
3,402.56
3,317.62
1,065.16
341.55
241.50
326.70
241.50
341.55
241.50
122.89
341.55
241.50
54,087.50
57,490.06
60,807.68
61,872.84
21,717.65
21,959.15
22,285.85
22,527.35
22,868.90
23,110.40
23,233.29
23,574.84
23,816.34
L.H. CHANEY MATERIALS, INC.
L.H. CHANEY MATERIALS, INC.
L.H. CHANEY MATERIALS, INC.
L.H. CHANEY MATERIALS, INC.
OXIDOR LABORATORIES LLC
OXIDOR LABORATORIES LLC
OXIDOR LABORATORIES LLC
OXIDOR LABORATORIES LLC
OXIDOR LABORATORIES LLC
OXIDOR LABORATORIES LLC
POSTNET TX193
OXIDOR LABORATORIES LLC
OXIDOR LABORATORIES LLC
6428 AP
6474 AP
6474 AP
6474 AP
6431 AP
6431 AP
6461 AP
6461 AP
6461 AP
6461 AP
PC
6476 AP
6476 AP
June 15, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25
10:08 06/10/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 5/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-60010-020-00
1178 05/11/2020 May A/P
Account: 135-60010-02
Account: 135-60020-020-000
1191 05/18/2020 mAY a/p
1215 05/21/2020 May A/P
Communications/Mobiles
Cell phones
3,496.18 407.91
Communications/Mobiles Tota
5,000.00 Budgeted 1,095.91 Remaining 78 % Ueed
Electric
electricity 4/1-5/5 73,247.99
Electricity 4/8-5/8
1265 05/31/2020 Town Billed Invoices 1738-1741 AR 20200531-20200531 User:
Account: 135-60020-020-000 Ole,,
160,067.00 Budgeted
3,904.09 VERIZON WIRELESS 6438 AP
528.61 73,776.60 TRI COUNTY ELECTRIC 6467 AP
10,912.04 84,688.64 HUDSON ENERGY SERVICES, LLC 6450 AP
(308.63) 84,380.01 AR
75,686.99 Remaining 53 % Used
Account: 135-60066-020-000 Publications/Books/Subscripts
Account: 135-60066-020-000 Publications/Books/Subscripts Totals:
200.00 Budgeted 200.00 Remaining
Account: 135-60070-020-000
Dues & Memberships
216.00
.00 .00
0 % Used
.00 216.00
2,542.85 TEEX ECOMMERCE
.00 109.14
Account: 135-60070-020-000
Dues & Memberships
300.00 Budgeted
Account: 135-60080-020-000 Dols 7F aining
1249 05/26/2020 PCards 4/28/2020-5/26/2020 F.Isola Class Refund
84.00 Remaining 72 % Ueed
Account: 135-60080-020-000 Dols & Training Total
Account: 135-60090-020-000
4,990.00 Budgeted
- Safety Program
Account: 135-60090-020-000 Safety Program
1,000.00 Budgeted
2,447.15 Remaining
2,962.85
109.14
51 % Used
890.86 Remaining 11 % Used
76 of 150
(420.00)
PC
June 15, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26
10:08 06/10/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 5/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-60100-020-000
Travel & per diem
410.72 .00 410.72
Account: 135-60100-020-000
Travel & per diem Totals:
410.72 **
1,545.00 Budgeted
1,134.28 Remaining 27 % Used
Account: 135-60105-020-000 Rent/Lease Equipment
Account: 135-60105-020-000
Rent/Lease Equipment Totals:
5,000.00 Budgeted
5,000.00 Remaining 0 % Used
.00 .00
.00 **
Account: 135-60125-020-000 Advertising
Account: 135-60125-020-000 Advertising
2,500.00 Budgeted
2,500.00
Remaining
.00
0 % Used
.00
Account: 135-60135-020-000 TCEQ Fees & Fermi
Account: 135-60135-020-000 TCEQ Fees & Permits
15,000.00 Budgeted
Account: 135-60245-020-000
xpense
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
4,911.98 Remaining
450.00 Remaining
Totals:
10,088.02
584.94
67 % Used
0 % Used
4,415.06 Remaining 12 % Used
0
10,088.02
.00 .00
.00 584.94
Account: 135-60285-020-000 Lawn Equipment & Maintenance
77 of 150
June 15, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27
10:08 06/10/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 5/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
1251 05/31/2020 May A/P Mowing -May 1,480.00 1,480.00 2,960.00 WATTS ELLISON LLC
Account: 135-6028 Lawn Equipment & Maintenance Totals: W 1 1,4
14,000.00 Budgeted 11,040.00 Remaining 21 % Used
83,318.48
Account: 135-60331-020-000
1292 05/31/2020 TexPool Transfers May
Account: 135-60331-020-000
Interfund Transfer Out -Tax I&S
TexPool O&M to I&S- PID Debt
Interfund Transfer Out -Tax I&S Tot
114,563.00 Budgeted 31,244.52
Account: 135-&0332-020-000 Interfund Rev I&S
1292 05/31/2020 TexPool Transfers May
Account: 135-60333-020-000
Remaining
TexPool O&M to Rev Bd WWTP I&S
72,903.67
435,663.37
-r Out -Rev I&S Tota
673,867.00 Budgeted 183,782.00 Remaining
Interfund Transfer Out -Reserve
1292 05/31/2020 TexPool Transfers May TexPool O&M to Rev Bond Reeevr 40,250.00 5,750.00 46,000.00
73 % Used
73 % Used
10,414.81
54,421.63 490,085.00
54,421.63
Account :0
Interfund Transfer Out -Reserve Totals:
125,187.00 Budgeted 79,187.00 Remaining
Account: 135-60334-020-000 Interfund Transfer Out
Account: 135-60334-020-000
Interfund Transfer Out Totals:
180,000.00 Budgeted 180,000.00 Remaining
37 % Used
.00 .00
0 % Ueed
6483 AP
GL
GL
GL
Account: 135-60360-020-000 Furniture/Equipment < $5000
Account: 135-60360-020-000 e/Equipment < $500
2,000.00 Budgeted
Account: 135-65005-020-000
1236 05/24/2020 Fuel
Fuel -may
1,810.00
Remaining
190.00
10
.00
Used
190.00
4,738.13 368.08 5,106.21 US Bank Voyager Fleet Systems 6481 AP
78 of 150
glpdatb2 skrolczyk
10:08 06/10/20
Fund: 135 MUD 1 General Fund
JE JE JE
Number Date Description
Account: 135-65010-020-000
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: 20 Wastewater Program:
Period Ending: 5/2020
JE Detail
Description/Comment
Fuel & Lube
12,500.00 Budgeted
RP Uniforms
Account: 135-65010-020-000
June 15, 2020 Regular Meeting Agenda Packet
Page 28
Beginning Transaction Transaction Vendor Name Check Source
Balance Detail Detail Number
(SUBTOTAL)
7,393.79 Remaining
3,507.93
41 % Ueed
Uniforms - Totals:
5,495.00 Budgeted 1,987.07 Remaining 64 % Used
Account: 135-65030-020 Chemicals
1178 05/11/2020 May A/P Sodium Hypo
1191 05/18/2020 mAY a/p Defoamer
1251 05/31/2020 May A/P Sodium Hypo
Account: 135-65030-020-00' Chemicals
20,000.00 Budgeted
Account: 135-65031-020-000 Chemicals Collections
Account: 135-65031-020-000 Chemicals Collections
17,500.00 Budgeted
Account: 135-65035-020-000
Account: 135-65035-020-000
Account: 135-65040-020-000
Account: 135-65040-020-000
ma oo s
Small Tools
1,200.00 Budgeted
Safety Equipment
Safety Equipment
1,200.00 Budgeted
71.66 Remaining
12,506.00 Remaining
1,200.00 Remaining
Totals:
17,139.42
.00 3,507.93
580.00
1,628.92
580.00
100 5 Used
4,994.00
1,166.53
29 % Used
0 % Used
33.47 Remaining 97 % Used
17,719.42 Valley Solvent Company, INC
19,348.34 MARYLAND BIOCHEMICAL CO, INC
19,928.34 Valley Solvent Company, INC
.00 4,994.00
.00 .00
.00 1,166.53
6437 AP
6456 AP
6482 AP
Account: 135-65045-020-000 Lab Supplies
79 of 150
June 15, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 29
10:08 06/10/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 5/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
1249 05/26/2020 PCards 4/28/2020-5/26/2020 distilled water 16,432.18
1249 05/26/2020 PCards 4/28/2020-5/26/2020 black light
Acc(1135-65045-0211 Lab Supplies
20,000.00 Budgeted
3,465.94 Remaining 83 % Used
3.96 16,436.14 TOM THUMB #1789
97.92 16,534.06 WWW.INTERLIGHT.BIZ
1.88
16,534.06 **
PC
PC
Account: 135-69005-020-000 Capital Outlays
1084 05/01/2020 Capital Asset Fund Corrections Foam System- Recode 135 to 517 182,063.00 (9,525.00) 172,538.00 GL
1178 05/11/2020 May A/P WWTP0 49,978.00 222,516.00 REY-MAR CONSTRUCTION 6432 AP
1178 05/11/2020 May A/P WWTP building and sound wall 71,496.00 294,012.00 REY-MAR CONSTRUCTION 6432 AP
Acc 69005-020-000 Capital Outlays
530,500.00 Budgeted
236,488.00 Remaining 55 % Used
Account: 135-69008-020-000 Short Term Debt -Principal
Account: 135-69008-020-000
Short Term Debt -Principal Totals:
79,133.00 Budgeted 19,528.26 Remaining
59,604.74
.00 59,604.74
75 % Used
Account: 135-69009-020-000 Short Term Debt -Interest
Account: 135-69009-020-000 Term Debt -Inter
11,277.00 Budgeted
5,154.97
Remaining
6,122.03
54
Used
.00
6,122.03
Account: 135-69195-020-000 Gasb34/Reserve for Replacement
130,000.00
Account: 135-69195-020-000 Gasb34/Reserve for Replacement Totals:
130,000.00 Budgeted .00 Remaining
Department 20 Totals:
100 % Used
.00 130,000.00
1,839,653.21 **
288,541.11 Monthly Total 3,157,421.00 Budgeted 1,317,767.79 Remaining 58 % Used
80 of 150
glpdatb2 skrolczyk
10:08 06/10/20
Fund: 135 MUD 1 General Fund
JE JE JE
Number Date Description
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: 26 Board of Directors
Period Ending: 5/2020
JE Detail
Description/Comment
June 15, 2020 Regular Meeting Agenda Packet
Page 30
Program:
Beginning Transaction Transaction Vendor Name
Balance Detail Detail
(SUBTOTAL)
Check Source
Number
81 of 150
Account:
135-50045-026-000 Workman's Compensation
73 05/01/2020 Insurance/Wrk Comp Expense May
13.93
1.99
15.92
GL
Account:
135-50045-026-000 Workman's Compensation Totals:
1.99
15.92
**
30.00 Budgeted 14.08 Remaining
53 %
Used
Account:
135-60066-026-000 Publications/Books/Subscripts
.00
.00
Account:
135-60066-026-000 Publications/Books/Subscripts Totals:
.00
.00
**
150.00 Budgeted 150.00 Remaining
0 %
Used
Account:
135-60070-026-000 Dues & Memberships
675.00
.00
675.00
Account:
135-60070-026-000 Dues & Memberships Totals:
.00
675.00
**
750.00 Budgeted 75.00 Remaining
90 %
Used
Account:
135-60075-026-000 Meetings
1249 05/26/2020 PCards 4/28/2020-5/26/2020 zoom meetings subscription
289.82
123.99
413.81
ZOOM.US
PC
Account:
135-60075-026-000 Meetings Totals:
123.99
413.81
**
1,300.00 Budgeted 886.19 Remaining
32 %
Used
Account:
135-60080-026-000 Schools & Training
.00
.00
Account:
135-60080-026-000 Schools & Training Totals:
.00
.00
**
4,000.00 Budgeted 4,000.00 Remaining
0 %
Used
Account:
135-60100-026-000 Travel & per diem
.00
.00
Account:
135-60100-026-000 Travel & per diem Totals:
.00
.00
**
5,000.00 Budgeted 5,000.00 Remaining
0 %
Used
Account:
135-60245-026-000 Miscellaneous Expenses
81 of 150
June 15, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31
10:08 06/10/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program:
Period Ending: 5/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
.00 .00
Account: 135-60245-026-000
Miscellaneous Expenses Totals: .00 **
2,000.00 Budgeted
2,000.00 Remaining 0 % Used
Department 26 Totals: 1,104.73 **
125.98 Monthly Total 13,230.00 Budgeted
82 of 150
12,125.27 Remaining 8 % Used
glpdatb2 skrolczyk
10:08 06/10/20
Fund: 135 MUD 1 General Fund
JE JE JE
Number Date Description
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: 30 Administration Program:
Period Ending: 5/2020
JE Detail
Description/Comment
ACCOunt: 135-50005-030- Salaries & W
1110 05/01/2020 MUD Payroll 5/1/2020
1180 05/15/2020 MUD Payroll 5/15/2020
1223 05/29/2020 MUD Payroll 5/29/2020
Account
Salaries & Wages
Salaries & Wages
Salaries & Wages
628,298.00 Budgeted
June 15, 2020 Regular Meeting Agenda Packet
Page 32
Beginning Transaction Transaction Vendor Name Check Source
Balance Detail Detail Number
(SUBTOTAL)
209,368.01 15,807.87 225,175.88 PR
15,807.87 240,983.75 PR
15,807.87 256,791.62 PR
371,506.38 Remaining 41 % Used
Account: 135-50010-030-000
Account: 135-50010-030-000
Account: 135-50016-030-000
31.77
.00 31.77
2,000.00 Budgeted 1,968.23 Remaining 2 % Used
Longevit
2,207.50 .00 2,207.50
Longevity Totals:
2,208.00 Budgeted .50 Remaining 100 % Ueed
Account: 135-50020-030-000 irement
1110 05/01/2020 MUD Payroll 5/1/2020 Retirement
1180 05/15/2020 MUD Payroll 5/15/2020 Retirement
1223 05/29/2020 MUD Payroll 5/29/2020 Retirement
21,091.51 1,463.81 22,555.32 PR
1,463.82 24,019.14 PR
1,463.78 25,482.92 PR
Account: 135-50020-030-000
Account: 135-50026-030-000
1110 05/01/2020 MUD Payroll 5/1/2020
1180 05/15/2020 MUD Payroll 5/15/2020
Account: 135
58,554.00 Budgeted
33,071.08 Remaining 44 % Ueed
Medical Insurance
Medical Insurance 41,849.51
Medical Insurance
76,198.72 Remaining 39 % Used
2,318.20
Medical Insurance
124,394.00 Budgeted
1110 05/01/2020 MUD Payroll 5/1/2020
1180 05/15/2020 MUD Payroll 5/15/2020
Dental Insurance
Dental Insurance
Dental Insurance
83 of 150
3,172.91 45,022.42 PR
3,172.86 48,195.28 PR
174.88 2,493.08 PR
174.87 2,667.95 PR
glpdatb2 skrolczyk
10:08 06/10/20
Fund: 135 MUD 1 General Fund
JE JE JE
Number Date Description
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: 30 Administration Program:
Period Ending: 5/2020
June 15, 2020 Regular Meeting Agenda Packet
Page 33
JE Detail Beginning Transaction Transaction Vendor Name Check Source
Balance Detail Detail Number
(SUBTOTAL)
Description/Comment
Account: 135-50027-030-000- Dental Insurance
6,464.00 Budgeted
Account: ion Insurance
1110 05/01/2020 MUD Payroll 5/1/2020 Vision Insurance
1180 05/15/2020 MUD Payroll 5/15/2020 Vision Insurance
Account: 135-50028-030-000 Vision Insurance
1,035.00 Budgeted
Account: 135-50029_-
1095 05/01/2020 May A/P
1122 05/01/2020 May Payroll Benefits
1215 05/21/2020 May A/P
Account: 135-
1110 05/01/2020 MUD Payroll 5/1/2020
1180 05/15/2020 MUD Payroll 5/15/2020
1223 05/29/2020 MUD Payroll 5/29/2020
3,796.05
Employee Benefits
Employee LTD & STD
cafe 125 plan
Remaining
353.03
41
Ueed
25.85
25.83
630.29 Remaining 39 % Used
Life Insurance & Other Totals:
4,500.00 Budgeted
378.88
404.71
2,314.93 176.22 2,491.15 Humana Inc
151.69 2,642.84 METLIFE GROUP BENEFITS
16.00 2,658.84 BenefitMall
1,841.16 Remaining 59 % Used
Social Security Taxes
Social Security Taxes
Social Security Taxes
Social Security Taxes
Account: Social Security Taxes
39,215.00 Budgeted
1110 05/01/2020 MUD Payroll 5/1/2020
1180 05/15/2020 MUD Payroll 5/15/2020
1223 05/29/2020 MUD Payroll 5/29/2020
Account: 135
Medicare Taxes
Medicare Taxes
Medicare Taxes
Medicare Taxes
Medicare Taxes
9,171.00 Budgeted
Account: 135-5004 Unemployment Taxes
12,231.08
24,187.06 Remaining 38 % Used
909.98
906.78
980.10
13,141.06
14,047.84
15,027.94
PR
PR
6414 AP
6417 AP
6441 AP
PR
PR
PR
2,860.52 212.82 3,073.34 PR
212.06 3,285.40 PR
229.22 3,514.62 PR
5,656.38 Remaining 38 % Used
864.00
84 of 150
.00 864.00
glpdatb2 skrolczyk
10:08 06/10/20
Fund: 135 MUD 1 General Fund
JE
Number
JE
Date
JE
Description
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: 30 Administration
Period Ending: 5/2020
JE Detail Beginning
Balance
Description/Comment
Unemployment Taxes
1,440.00 Budgeted
Acc410 Workman's Compensation
73 05/01/2020 Insurance/Wrk Comp Expense May
Account: 135-50045-030-000
Account: 135-50060-030-000
Account: 135-50060-030-000
Account: 135-50070-030-000
Account: 135-50070-030-000
Acc
Workman's Compensation
1,775.00 Budgeted
Pre-emp Physicals/Testing
Tota
576.00 Remaining
733.74
Totals:
936.44 Remaining
Pre-emp Physicals/Testing To a e•
500.00 Budgeted 500.00 Remaining
Employee Relations
Employee Relations
8,000.00 Budgeted
1215 05/21/2020 May A/P
1249 05/26/2020 PCards 4/28/2020-5/26/2020
1249 05/26/2020
1249 05/26/2020
1249 05/26/2020
1249 05/26/2020
1249 05/26/2020
1249 05/26/2020
1249 05/26/2020
1249 05/26/2020
1249 05/26/2020
1309 05/31/2020
Account: 135
PCarde 4/28/2020-5/26/2020
PCards 4/28/2020-5/26/2020
PCarde 4/28/2020-5/26/2020
PCarde 4/28/2020-5/26/2020
PCards 4/28/2020-5/26/2020
PCards 4/28/2020-5/26/2020
PCards 4/28/2020-5/26/2020
PCarde 4/28/2020-5/26/2020
PCards 4/28/2020-5/26/2020
Recode M3 Annual Soft & Supprt
Internet -may
website
Website
internet
internet
Internet'
adobe subscription
Internet
internet
Internet
bank rec software
Recode
134,681.00 Budgeted
3,078.10
4,921.90 Remaining
Program:
Transaction
Detail
60 % Ueed
47 % Ueed
0 % Used
38 % Used
June 15, 2020 Regular Meeting Agenda Packet
Page 34
Transaction Vendor Name
Detail
(SUBTOTAL)
104.82
.00
.00
838.56
.00
3,078.10
133,346.24 899.00 134,245.24 Charter Communications
10.77 134,256.01 FS *DIGITALWAVE
18.17 134,274.18 DNB*GODADDY.COM
52.37 134,326.55 ATT*BILL PAYMENT
42.37 134,368.92 ATT*SILL PAYMENT
42.37 134,411.29 ATT*BILL PAYMENT
36.78 134,448.07 ADOBE ACROPRO SUBS
42.37 134,490.44 ATT*BILL PAYMENT
42.35 134,532.79 ATT*BILL PAYMENT
42.37 134,575.16 ATT*BILL PAYMENT
595.00 135,170.16 CONWAY COMPANY CPAS
(54,600.00) 80,570.16
54,110.84 Remaining 60 % Used
85 of 150
Check Source
Number
6443
GL
AP
PC
PC
PC
PC
PC
PC
PC
PC
PC
PC
GL
June 15, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 35
10:08 06/10/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 5/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 1 Independent Labor
1251 05/31/2020 May A/P GM search Final invoice
Account: 135-55070-03 Independent Labor
135,000.00 Budgeted
Account: 135-55080-030-00r Maintenance & Repairs
1191 05/18/2020 mAY a/p
75,711.88 13,098.66 88,810.54 Strategic Government Resources 6478 AP
46,189.46 Remaining 66 % Used
a/c in office 1,275.00 285.00 1,560.00 BRANDON R REED
Account: Maintenance & Repairs Totals:
15,000.00 Budgeted
13,440.00 Remaining 10 % Used
6442 AP
Generator Maint. and Repair
531.00 .00 531.00
Account: 135-55085-030-000 Generator Maint. and Repair Totals: .00
Account: 135-55120-030-000
1215 05/21/2020 May A/P
Account: 135-55120-030-000
10,000.00 Budgeted 9,469.00 Remaining
Cleaning Services
Janitorial service -April 5,761.72
"ing Services
10,000.00 Budgeted
Account: 135-55160-030
1309 05/31/2020 Recode M3 Annual Soft & Supprt Recode
2,341.36 Remaining
Account: 135- Professional Outside Servic
65,600.00 Budgeted 8,500.00 Remaining
2,500.00
5 % Used
77 % Used
87 % Used
1,896.92 7,658.64 MEMBER'S BUILDING MAINTENANCE 6458 AP
1,896.92
54,600 00
57,100.00
GL
Account: 135-55205-030-000
Utility Billing Contract
Account: 135-55205-030-000
Utility Billing Contract Totals:
9,000.00 Budgeted 4,820.32 Remaining
4,179.68
46 % Used
.00 4,179.68
Account: 135-60005-030-000 Telephone
86 of 150
June 15, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36
10:06 06/10/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 5/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
1090 05/01/2020 May A'P
Answering service -May 10,173.55
1249 05/26/2020 PCards 4/28/2020-5/26/2020 phone
1249 05/26/2020 PCards 4/28/2020-5/26/2020 phone
1249 05/26/2020 PCards 4/28/2020-5/26/2020 phone
1249 05/26/2020 PCards 4/28/2020-5/26/2020 answering service
1249 05/26/2020 PCards 4/28/2020-5/26/2020 phone
1265 05/31/2020 Town Billed Invoices 1738-1741 AR 20200531-20200531 User:
Account: 135-60005-030-00 Telephone
23,680.00 Budgeted
1178 05/11/2020 May A/P
Communications/Mobiles
Cell phones
1178 05/11/2020 May A/P Cell phones
1180 05/15/2020 MUD Payroll 5/15/2020 Communications/Mobiles
11,484.66 Remaining 52 % Used
Account: 135-60010-0
Account: 135-60020-030-000
1215 05/21/2020 May A/P
Account: 135-60020-030-000
Account: 135-60025-03'
1251 05/31/2020 May A/P
1265 05/31/2020 Town Billed Invoices 1738-1741 AR 20200531-20200531 User:
Communications/Mobile
4,000.00 Budgeted
2,184.88
Electricity/Gas
Gexa energy 3/10-4/08
Electricity
6,879.00 Budgeted
water -May
2,971.44
Account: 135-50025-030-8,,,
11
Account: 135-60035-030-000
Account: 135-60035-030-000
Water
1,500.00 Budgeted
Postage
Postag=
30,000.00 Budgeted
Remaining
Remaining
571.98 10,745.53 KEYSTONE PARK SECRETARIAL 6361 AP
466.71 11,212.24 ATT*BUS PHONE PMT PC
797.51 12,009.75 ATT*BUS PHONE PMT PC
175.30 12,185.05 ATT*BILL PAYMENT PC
14.99 12,200.04 RINGCENTRAL, INC PC
175.30 12,375.34 ATT*BILL PAYMENT PC
(180.00) 12,195.34 AR
1,715.86 (150.00) 1,565.86 VERIZON WIRELESS 6438 AP
99.26 1,665.12 VERIZON WIRELESS 6438 AP
150.00 1,815.12 PR
3,449.34
1,479.02
45 % Used
57
Used
Totals:
249.40 Remaining 83 % Ueed
18,274.49
Remaining
11,725.51
39
458.22
47.45
(275.87)
.00
Used
3,907.56 TOWN OF TROPHY CLUB
1,526.47
1,250.60
11,725.51
TROPHY CLUB MUD (WATER BILLS)
6466 AP
6480
AP
AR
Account: 135-60040-030-000 Service Charges & Fees
87 of 150
glpdatb2 skrolczyk
10:08 06/10/20
Fund: 135 MUD 1 General Fund
JE JE JE
Number Date Description
1268 05/31/2020 Pace Credit Card Fees
1268 05/31/2020 Pace Credit Card Fees
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: 30 Administration Program:
Period Ending: 5/2020
June 15, 2020 Regular Meeting Agenda Packet
Page 37
JE Detail Beginning Transaction Transaction Vendor Name Check Source
Description/Comment Balance Detail Detail Number
(SUBTOTAL)
41,902.02
4,924.49
9.78
46,826.51
46,836.29
GL
GL
88 of 150
Account:
135-60040-030-000
Service Charges & Fees Totals:
4,934.27
46,836.29
**
67,000.00 Budgeted 20,163.71 Remaining
70 %
Used
Account:
135-60050-030-000
Bad Debt Expense
.00
.00
Account:
135-60050-030-000
Bad Debt Expense Totals:
.00
.00
**
1,500.00 Budgeted 1,500.00 Remaining
0 %
Used
Account:
135-60055-030-000
Insurance
73 05/01/2020
Insurance/Wrk
Comp
Expense May
45,426.87
6,998.39
52,425.26
GL
Account:
135-60055-030-000
Insurance Totals:
6,998.39
52,425.26
**
84,000.00 Budgeted 31,574.74 Remaining
62 %
Used
Account:
135-60066-030-000
Publications/Books/Subscripts
125.00
.00
125.00
Account:
135-60066-030-000
Publications/Books/Subscripts Totals:
.00
125.00
**
1,000.00 Budgeted 875.00 Remaining
13 %
Used
Account:
135-60070-030-000
Dues & Memberships
4,285.55
.00
4,285.55
Account:
135-60070-030-000
Dues & Memberships Totals:
.00
4,285.55
**
6,000.00 Budgeted 1,714.45 Remaining
71 %
Used
Account:
135-60075-030-000
Meetings
115.09
.00
115.09
Account:
135-60075-030-000
Meetings Totals:
.00
115.09
**
400.00 Budgeted 284.91 Remaining
29 %
Used
Account:
135-60079-030-000
Public Education
88 of 150
June 15, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38
10:06 06/10/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 5/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-60079-030-0 Public Education
6,000.00 Budgeted
Account: 135-60080-030-000 Schools & Training
Account: 135-60080-030-000 Schools & Training
6,850.00 Budgeted
Account: 135-60100-030- Travel & per di
1249 05/26/2020 PCards 4/28/2020-5/26/2020 GM interview hotel stay
3,971.51
.00 3,971.51
Totals:
2,028.49 Remaining 66 % Used
5,397.79 Remaining
vel & per diem
3,545.00 Budgeted
Account Physicals/Testing
Account Physicals/Testing
200.00 Budgeted
Account: 135-60115-030-000 Elections
Account: 135-60115-030-000
els:
2,446.39 Remaining
Elections Totals:
.00 Budgeted
Account: 135-60125-030-000 Advertising
Account: 135-60125-030-000 Advertising
2,500.00 Budgeted
Account: 135-60235-030-000
1,452.21
1,020.64
.00
21 % Used
77.97
1,452.21
1,098.61 HAMPTON INN HOTELS
PC
7
31 % Used
.00 .00
138.04 .00 138.04
Totals:
200.00 Remaining 0 % Used
(138.04) Remaining 0 % Ueed
1,772.20 .00 1,772.20
727.80 Remaining 71 % Used
168.00 .00 168.00
89 of 150
June 15, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39
10:08 06/10/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 5/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-60235-030-000
Account: 135-60245-030-000
Account: 135-60245-030-000
Account: 135-60246-030-000
Account: 135-60246-030-000
Account: 135-60360-030-000
Account: 135-60360-030-000
Account: 135-65010-030-000
Account: 135-65010-030-000
Security
1,288.00 Budgeted
Miscellaneous Expenses
1,120.00 Remaining 13 % Ueed
Miscellaneous Expenses
500.00 Budgeted
General Manager Contingency
General Manager Contingency Totals:
17,000.00 Budgeted 17,000.00 Remaining
Furniture/Equipment < $5000
500.00 Remaining 0 % Ueed
O % Used
.00 .00
.00 .00
.00 **
.00 .00
Furniture/Equipment c $50 .00 **
2,500.00 Budgeted 2,500.00 Remaining
Uniforms
2,050.00 Budgeted
Account: -0 Hardware
1249 05/26/2020 PCards 4/28/2020-5/26/2020 computer monitor
1251 05/31/2020 May A/P GM monitors
Account: 135-65055-030-000
O % Used
.00 .00
.00 **
2,050.00 Remaining 0 % Used
3,235.24 199.99 3,435.23 AMZN MRTP US*M74R02PZ0
PC
480.98 3,916.21 M3 Networks 6475 AP
Hardwar11111111111M ,916.21 **
26,485.00 Budgeted
Account: 135-65085-03
1215 05/21/2020 May A/P office supplies
22,568.79 Remaining 15 % Used
2,431.85 55.36 2,487.21 OFFICE DEPOT, INC
90 of 150
6460 AP
June 15, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 40
10:08 06/10/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 5/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
1249 05/26/2020 PCards 4/28/2020-5/26/2020 ink cartridges
Account: 135-65085-030-0
Account: 135-65090-030-000
2,431.85 448.78 2,935.99 AMAZON.COM*MC63U99W1
PC
Office Supplies Total
2,935.99 **
6,000.00 Budgeted
3,064.01 Remaining 49 % Used
Printer Supplies & Maintenance
.00 .00
Account: 135-65090-030-000
Printer Supplies & Maintenance Tot .00
3,500.00 Budgeted 3,500.00 Remaining
0 % Used
Account: 135-65095-030-000
Maintenance Supplies
Account: 135-65095-030-000
Maintenance Supplies
4,000.00 Budgeted
Account: 135-65105-030-000
Pri.
2,848.53
1,151.47 Remaining 71 % Used
.00 2,848.53
.00 .00
Account: 135-65105-030-000
Tota
2,500.00 Remaining 0 % Used
Account: 135-69005-030-000
1215 05/21/2020 May A/P
1266 05/31/2020 May A/P
1191 05/18/2020 mAY a/p
1251 05/31/2020 May A/P
2,500.00 Budgeted
Capital Outlays
TCMUD boundary
TCMUD boundary
Capital Outlaill Totals:
195,000.00 Budgeted
27,009.75 1,170.62
166,552.16 Remaining 15 % Used
Copier Lease Installments
copier lease -may
copies
28,180.37 Halff Associates, INC 6447 AP
267.47 28,447.84 Halff Associates, INC
28,447.84 **
1,734.10 165.00 1,899.10 TIAA COMMERCIAL FINANCE
13.50 1,912.60 KYOCERA DOCUMENT SOLUTIONS
Account: 135-69170-030-00 ase Installments
4,000.00 Budgeted 2,087.40 Remaining 48 % Used
91 of 150
6509 AP
6465 AP
6473 AP
June 15, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41
10:08 06/10/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 5/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Department 30 Totals: 785,516.89 **
96,729.59 Monthly Total 1,776,712.00 Budgeted 991,195.11 Remaining 44 % Used
92 of 150
1215 05/21/2020 May A/P
Ac
legal 85,585.39
Legal
135,000.00 Budgeted
Account: 135-55055-039-000
Auditing
Account: 135-55055-039-000 Auditing
33,800.00 Budgeted
Account: 135-55060-039-000 Appraisal
Account: 135-55060-039-000 Appraisal
11,761.00 Budgeted
Account: 135-55065-039-000 Tax Admin Fees
Account: 135-55065-039-000 Tax Admin Fees
4,000.00 Budgeted
Department 39 Totals:
Fund 135 Totals:
4,842.50 Monthly Total
(54,840.64) Monthly Total
44,572.11 Remaining
27,713.27
6,086.73 Remaining
7,422.04
4,338.96 Remaining
244.00
3,756.00
Remaining
glpdatb2 skrolczyk
10:08 06/10/20
Fund: 135 MUD 1 General Fund
JE JE JE
Number Date Description
June 15, 2020 Regular Meeting Agenda Packet
Trophy Club MUD No.1 Page 42
Detailed Accounting Trial Balance
Department: 39 Non Departmental Program:
Period Ending: 5/2020
Beginning Transaction Transaction Vendor Name Check Source
Balance Detail Detail Number
(SUBTOTAL)
JE Detail
Description/Comment
Account: 135-55045-039-
Legal
4,842.50 90,427.89 McLean & Howard, L.L.P.
67 % Used
.00 27,713.27
82 % Used
.00 7,422.04
63 % Used
94
Used
.00
3,756.00
129,319.20 **
184,561.00 Budgeted 55,241.80 Remaining 70 t Used
(103,999.22)
(6,224.00) Budgeted 97,775.22 Remaining ##########
93 of 150
6457 AP
glpdatb2 skrolczyk
10:08 06/10/20
Fund: 137 MUD 1 Consolidated GASB
JE JE JE
Number Date Description
Department:
JE Detail
Description/Comment
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Period Ending: 5/2020
Beginning
Balance
June 15, 2020 Regular Meeting Agenda Packet
Page 43
Program:
Transaction Transaction Vendor Name
Detail Detail
(SUBTOTAL)
Check Source
Number
Department Totals:
Fund 137 Totals:
.00 Monthly Total
.00 Monthly Total
.00 Budgeted
.00 Budgeted
94 of 150
(286,420.00) **
286,420.00 Remaining 0 % Used
(286,420.00)
286,420.00 Remaining 0 % Used
Account:
137-49145-000-000"IIII
Intergov Transfer -General Fund
(205,000.00)
.00
(205,000.00)
Account:
137-49145-000-000
Intergov Transfer -General Fund Totals:
.00
(205,000.00)
**
.00 Budgeted 205,000.00 Remaining
0 %
Used
Account:
137-49146-000-000
Intergov Transfer -Fire Dept
(81,420.00)
.00
(81,420.00)
Account:
137-49146-000-000
Intergov Transfer -Fire Dept Totals: ;
.00
(81,420.00)
**
.00 Budgeted 81,420.00 Remaining
0 %
Used
Department Totals:
Fund 137 Totals:
.00 Monthly Total
.00 Monthly Total
.00 Budgeted
.00 Budgeted
94 of 150
(286,420.00) **
286,420.00 Remaining 0 % Used
(286,420.00)
286,420.00 Remaining 0 % Used
June 15, 2020 Regular Meeting Agenda Packet
TROPHY CLUB MUD NO. 1 - WWTP TAX BOND CONST
BALANCE SHEET
MAY 2020
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
517
TAX BOND
CONSTRUCTION
504,533
TOTAL ASSETS 504,533
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES 685,476
TOTAL LIABILITIES 685,476
FUND BALANCE
ASSIGNED FUND BALANCE (118,410)
NET REVENUES / EXPENDITURES (62,534)
TOTAL FUND BALANCE (180,944)
TOTAL LIABILITIES AND FUND BALANCE 504,533
95 of 150
June 15, 2020 Regular Meeting Agenda Packet
glbase tbam skrolczyk Trophy Club MUD No.1
10:08 06/10/20 Budget Summary with Amendment
Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program:
Period Ending: 5/2020
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
1 517-49011-000-000 Interest Income
118.15- 4,812.81- 4,812.81
Page 14
Subtotal: 118.15- 4,812.81- 4,812.81
Program number: 118.15-
4,812.81- 4,812.81
Department number: Revenues 118.15-
4,812.81- 4,812.81
Revenues Subtotal
118.15- 4,812.81- 4,812.81
96 of 150
glbase_tbam skrolczyk
10:08 06/10/20
Fund: 517 2014 MUD 1 Tax Bond Const WWTP
Account
1 517-69005-020-000
Description
Capital Outlays
Trophy Club MUD No.1
Budget Summary with Amendment
Department: 20 Wastewater
Period Ending: 5/2020
Adopted Amended Total Current
Budget Budget Encumb. Month
15,077.50
June 15, 2020 Regular Meeting Agenda Packet
Program:
YTD
Total
67,346.41
% of Remaining
Budget Budget
67,346.41 -
Page 15
97 of 150
Subtotal:
15,077.50
67,346.41
67,346.41 -
Program number:
15,077.50
67,346.41
67,346.41 -
Department number: Wastewater
7.
15,077.50
67,346.41
67,346.41 -
Expenditures Subtotal
15,077.50
67,346.41
67,346.41 -
Fund number: 517 2014 MUD 1 Tax Bond Const WWTP
14,959.35
62,533.60
62,533.60-
97 of 150
glpdatb2 skrolczyk
10:08 06/10/20
Fund: 517 2014 MUD 1 Tax Bond Const WWTP
JE JE JE
Number Date Description
Account: 517-49011-000-000
1269 05/31/2020 Bank Interest- May
Account: 517-49011-000-000
June 15, 2020 Regular Meeting Agenda Packet
Trophy Club MUD No.1 Page 44
Detailed Accounting Trial Balance
Department: Revenues Program:
Period Ending: 5/2020
JE Detail Beginning Transaction Transaction Vendor Name Check Source
Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Interest Income
Interest Income Total=
.00 Budgeted 4,812.81 Remaining
(4,694.66) (118.15)
0 % Used
(4,812.81) GL
Department Totals: (4,812.81) **
(118.15) Monthly Total
.00 Budgeted
98 of 150
4,812.81 Remaining 0 % Used
glpdatb2 skrolczyk
10:08 06/10/20
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: 20 Wastewater Program:
Period Ending: 5/2020
Beginning Transaction Transaction Vendor Name
Balance Detail Detail
(SUBTOTAL)
JE Detail
Description/Comment
Account: 517-69005-020- Capital Outl
1084 05/01/2020 Capital Asset Fund Corrections Foam System- Recode 135 to 517
1215 05/21/2020 May A/P Crane review engineering
1215 05/21/2020 May A/P WWTP legal
Department 20 Totals:
apital Outlays
.00 Budgeted
June 15, 2020 Regular Meeting Agenda Packet
Page 45
52,268.91
Totals:
(67,346.41) Remaining 0 % Used
15,077.50 Monthly Total .00 Budgeted
9,525.00
4,065.00
1,487.50
61,793.91
65,858.91 Wise, Janney, Eletner Assoc
67,346.41 WHITAKER CHALK SWINDLE
67,346.41 ••
(67,346.41) Remaining 0 % Used
Fund 517 Totals: 62,533.60
14,959.35 Monthly Total .00 Budgeted
99 of 150
(62,533.60) Remaining 0 % Used
Check Source
Number
GL
6469 AP
6468 AP
June 15, 2020 Regular Meeting Agenda Packet
TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION
NSII FORT WORTH- SWIFT FUNDING
BALANCE SHEET
MAY 2020
ASSETS
CASH IN BANK
CASH IN ESCROW
INVESTMENTS
ACCOUNTS RECEIVABLE
5111,
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
519
REVENUE BOND
CONSTRUCTION
784,940
TOTAL ASSETS 784,940
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 150
81,691
81,691
698,648
4,602
703,249
784,940
June 15, 2020 Regular Meeting Agenda Packet
glbase tbam skrolczyk Trophy Club MUD No.1
10:08 06/10/20 Budget Summary with Amendment
Fund: 519 2016 Rev Bond Const -SWIFT Department: Revenues Program:
Period Ending: 5/2020
Account Description Adopted AmendedTotal Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
519-49011-000-000 Interest Income 6.45- 4,601.70- 4,601.70
Subtotal: 6.45- 4,601.70- 4,601.70
Program number: 6.45- 4,601.70- 4,601.70
Department number: Revue 6.45- 4,601.70- 4,601.70
Revenues Subtotal 6.45- 4,601.70- 4,601.70
Fund number: 519 2016 Rev Bond Const -SWIFT 6.45- 4,601.70- 4,601.70
101 of 150
Page 16
glpdatb2 skrolczyk
10:06 06/10/20
Fund: 519 2016 Rev Bond Const -SWIFT
JE JE JE
Number Date Description
Account: 519-49011-000-000
1269 05/31/2020 Bank Interest- May
Account: 519-49011-000-000
June 15, 2020 Regular Meeting Agenda Packet
Trophy Club MUD No.1 Page 46
Detailed Accounting Trial Balance
Department: Revenues Program:
Period Ending: 5/2020
JE Detail Beginning Transaction Transaction Vendor Name Check Source
Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Interest Income
Interest Income Totals:
.00 Budgeted
(4,595.25) (6.45)
4,601.70 Remaining 0 % Used
(6.45)
(4,601.70) GL
) **
Department Totals: (4,601.70) **
(6.45) Monthly Total .00 Budgeted
4,601.70 Remaining 0 % Used
Fund 519 Totals: (4,601.70)
(6.45) Monthly Total .00 Budgeted
102 of 150
4,601.70 Remaining 0 % Used
June 15, 2020 Regular Meeting Agenda Packet
TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND
BALANCE SHEET
MAY 2020
Li ip
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
FUND 520
16" 2019
ASSETS REVENUE BOND
CASH IN BANK 418,569
INVESTMENTS 3,892,394
ACCOUNTS RECEIVABLE
TOTAL ASSETS 4,310,963
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES 2,658
TOTAL LIABILITIES 2,658
FUND BALANCE
ASSIGNED FUND BALANCE 4,454,290
NET REVENUES / EXPENDITURES (145,985)
TOTAL FUND BALANCE 4,308,305
TOTAL LIABILITIES AND FUND BALANCE 4,310,963
103 of 150
June 15, 2020 Regular Meeting Agenda Packet
glbase tbam skrolczyk Trophy Club MUD No.1 Page 17
10:08 06/10/20 Budget Summary with Amendment
Fund: 520 Revenue Bond 16" Waterline Department: Program:
Period Ending: 5/2020
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
1 520-49011-000-000 Interest Income
132.92- 27,579.97- 27,579.97
Subtotal: 132.92- 27,579.97- 27,579.97
Program number: 132.92-
27,579.97- 27,579.97
Department number: 132.92-
27,579.97- 27,579.97
Revenues Subtotal
132.92- 27,579.97- 27,579.97
104 of 150
glbase_tbam skrolczyk
10:08 06/10/20
Fund: 520 Revenue Bond 16" Waterline
Account
1 520-69005-010-000
Description
Capital Outlays
Trophy Club MUD No.1
Budget Summary with Amendment
Department: 10 Water Department
Period Ending: 5/2020
Adopted Amended Total Current
Budget Budget Encumb. Month
28,983.97
June 15, 2020 Regular Meeting Agenda Packet
Program:
YTD
Total
173,564.78
% of Remaining
Budget Budget
173,564.78 -
Page 18
105 of 150
Subtotal:
28,983.97
173,564.78
173,564.78 -
Program number:
28,983.97
173,564.78
173,564.78 -
Department number: Water Department
7"
28,983.97
173,564.78
173,564.78 -
Expenditures Subtotal
28,983.97
173,564.78
173,564.78 -
Fund number: 520 Revenue Bond 16" Waterline
Ell
28,851.05
145,984.81
145,984.81-
105 of 150
glpdatb2 ekrolczyk Trophy Club MUD No.1
10:08 06/10/20 Detailed Accounting Trial Balance
Fund: 520 Revenue Bond 16" Waterline Department: Program:
Period Ending: 5/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
June 15, 2020 Regular Meeting Agenda Packet
Page 47
Account: 520-49011-000-0
1269 05/31/2020 Bank Interest- May
1269 05/31/2020 Bank xntereat- May
Interest Income
(27,447.05) (100.92) (27,547.97) GL
(32.00) (27,579.97) GL
Account: 520-490
Interest Income Totals:
.00 Budgeted
27,579.97 Remaining 0 % Used
Department Totals: (27,579.97) **
(132.92) Monthly Total .00 Budgeted
106 of 150
27,579.97 Remaining 0 % Used
glpdatb2 skrolczyk
10:08 06/10/20
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 Program:
Period Ending: 5/2020
JE Detail
Description/Comment
Account: 520-69005-0 - Capital Outlays
1084 05/01/2020 Capital Asset Fund Corrections Halff Nov Inv# 30284 coded 135
1084 05/01/2020 Capital Asset Fund Corrections J Walker Jan Inv# 1696113 F135
1215 05/21/2020 May A/P 16" water line acquistion
1215 05/21/2020 May A/P Easement Acquistition
1266 05/31/2020 May A/P easement
Account: 520-69005-010-000
Department 10 Totals:
Fund 520 Totals:
June 15, 2020 Regular Meeting Agenda Packet
Page 48
Beginning Transaction Transaction Vendor Name Check Source
Balance Detail Detail Number
(SUBTOTAL)
144,580.81 3,055.78 147,636.59 GL
7,452.00 155,088.59 GL
10,690.00 165,778.59 Halff Associates, INC 6447 AP
5,128.65 170,907.24 Jackson Walker LLP 6452 AP
2,657.54 173,564.78 Halff Associates, INC 6509 AP
Capital Outlays Tn�
.00 Budgeted (173,564.78) Remaining
0 % Used
28,983.97 171
173,564.78 **
28,983.97 Monthly Total .00 Budgeted (173,564.78) Remaining 0 % Used
145,984.81
28,851.05 Monthly Total .00 Budgeted (145,984.81) Remaining 0 % Used
107 of 150
June 15, 2020 Regular Meeting Agenda Packet
TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE
BALANCE SHEET
MAY 2020
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
MI
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
528
REVENUE BOND
RESERVE
893,308
TOTAL ASSETS 893,308
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES
TOTAL FUND BALANCE
TOTAL LIABILITIES AND FUND BALANCE
108 of 150
803,457
89,851
893,308
893,308
June 15, 2020 Regular Meeting Agenda Packet
glbase tbam skrolczyk Trophy Club MUD No.1 Page 19
10:08 06/10/20 Budget Summary with Amendment
Fund: 528 2015 Revenue Bond Reserve Fund Department: Program:
Period Ending: 5/2020
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
528-49011-000-000
528-49142-000-000
528-49143-000-000
Interest Income
Interfund transfer in -Water
Interfund transfer in -WW
11,000.00-
307,049.00-
200,417.00-
11,000.00-
307,049.00-
200,417.00-
201.50-
4,600.00-
5,750.00-
Subtotal: m 518,466.00- 518,466.00- 10,551.50 -
Program number: 1 518,466.00- 518,466.00- 10,551.50 -
Department number: 518,466.00- 518,466.00- 10,551.50 -
Revenues Subtotal 518,466.00- 518,466.00- 10,551.50 -
Fund number: 528 2015 Revenue Bond Reserve Fund 518,466.00- 518,466.00- 10,551.50-
109 of 150
7,051.03-
36,800.00-
46,000.00-
64.100
11.985
22.952
17.330
17.330
17.330
17.330
3,948.97-
270,249.00-
154,417.00-
428,614.97-
428,614.97-
428,614.97-
428,614.97-
428,614.97-
glpdatb2 skrolczyk Trophy Club MUD No.1
10:08 06/10/20 Detailed Accounting Trial Balance
Fund: 528 2015 Revenue Bond Reserve Fund Department: Program:
Period Ending: 5/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
June 15, 2020 Regular Meeting Agenda Packet
Page 49
Account: 528-49011-000-000
1269 05/31/2020 Bank Interest- May
Interest Income
Account: 528-49011-000-000 come 1
(11,000.00) Budgeted (3,948.97) Remaining
Account: 528-49142-000-000 7
1292 05/31/2020 TexPool Transfers May
(6,849.53)
(201.50) (7,051.03)
GL
(201.50)
64 % Used
TexPool O&M to Rev Bond Resevr (32,200.00)
(4,600.00) (36,800.00)
GL
(307,049.00) Budgeted
(270,249.00) Remaining 12 % Used
Interfund transfer in -WW
1292 05/31/2020 TexPool Transfers May TexPool O&M to Rev Bond Resevr
Account: 528-49143-11Interfund transfer in -
(200,417.00) Budgeted
(40,250.00)
(154,417.00) Remaining
(5,750.00)
23 % Used
(46,000.00)
Department Totals: (89,851.03) **
(10,551.50) Monthly Total (518,466.00) Budgeted (428,614.97) Remaining 17 % Used
Fund 528 Totals: (89,851.03)
(10,551.50) Monthly Total (518,466.00) Budgeted (428,614.97) Remaining 17 % Used
110 of 150
GL
June 15, 2020 Regular Meeting Agenda Packet
TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE)
BALANCE SHEET
MAY 2020
ASSETS
CASH IN BANK
INVESTMENTS
PREPAID EXPENSES
ADVALOREM PROPERTY TAXES RECEIVABLE
ACCOUNTS RECEIVABLE -OTHER
TOTAL ASSETS
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES
TOTAL FUND BALANCE
TOTAL LIABILITIES AND FUND BALANCE
111 of 150
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
INTEREST &
SINKING- 533
947,761
21,518
969,279
21,518
21,518
82,954
864,807
947,761
969,279
June 15, 2020 Regular Meeting Agenda Packet
glbase tbam skrolczyk Trophy Club MUD No.1
10:08 06/10/20 Budget Summary with Amendment
Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program:
Period Ending: 5/2020
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
533-40000-000-000
533-40002-000-000
533-40015-000-000
Property Taxes
Property Taxes/Delinquent
Property Taxes/P & I
682,441.00-
1,000.00-
2,000.00-
682,441.00-
1,000.00-
2,000.00-
3,367.17-
64.06
158.35-
681,504.50-
1,789.72-
1,823.78-
99.863
178.972
91.189
936.50-
789.72
176.22 -
Page 20
Subtotal:
Mr -
3,461.46-
99.953 323.00-
533-49011-000-000
533-49015-000-000
533-49141-000-000
Interest Income
Lease/Rental Income
Interfund Trans In -PID Surchg
5,000.00-
218,004.00-
114,563.00-
5,000.00-
218,004.00-
114,563.00-
213.71-
10,414.81-
3,745.64-
218,004.00-
83,318.48-
74.913
100.000
72.727
1,254.36-
31,244.52-
1 Subtotal:
337,567.00- 337,567.00-
10,628.52- 305,068.12-
90.373 32,498.88 -
Program number:
1,023,008.00- 1,023,008.00-
14,089.98- 990,186.12-
96.792
32,821.88 -
Department number: Revenues
1,023,008.00- 1,023,008.00-
14,089.98- 990,186.12-
96.792 32,821.88 -
Revenues
Subtotal
1,023,008.00- 1,023,008.00-
14,089.98- 990,186.12-
96.792 32,821.88-
112 of 150
June 15, 2020 Regular Meeting Agenda Packet
glbase_tbam skrolczyk Trophy Club MUD No.1
10:08 06/10/20 Budget Summary with Amendment
Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program:
Period Ending: 5/2020
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
1
1 533-70005-051-000
1 533-70025-051-000
1 533-70035-051-000
Payin$g Agent Fee
Bond 2nterest Expense -Tax
Bond Principal Payment -Tax
2,150.00
247,858.00
765,000.00
2,150.00
247,858.00
765,000.00
1,450.00
123,928.75
67.442
50.000
700.00
123,929.25
765,000.00
Page 21
Subtotal:
1,015,008.00 1,015,008.00 125,378.75
12.352 889,11r.25
Program number:
1,015,008.00 1,015,008.00 125,378.75
12.352 889,629.25
Department number: Administration
1,015,008.00 1,015,008.00 125,378.75
12.352 889,629.25
Expenditures
Subtotal 1,015,008.00 1,015,008.00
125,378.75
12.352 889,629.25
p Fund number: 533 MUD 1 I&S Consolidated
8,000.00- 8,000.00-
14,089.98-
864,807.37- ############### 856,807.37
113 of 150
glpdatb2 skrolczyk
10:08 06/10/20
Fund: 533 MUD 1 I&S Consolidated
JE JE JE
Number Date Description
Accoyyyyta 533-40000-000-
1272 05/01/2020 Property Taxes
1273 05/04/2020 Property Taxes
1274 05/05/2020 Property Taxes
1275 05/06/2020 property taxes
1277 05/07/2020 property taxes
1278 05/08/2020 property taxes
1279 05/11/2020 Property Taxes
1280 05/12/2020 Property Taxes
1281 05/14/2020 property taxes
1282 05/15/2020 property taxes
1283 05/18/2020 property taxes
1293 05/19/2020 property taxes
1284 05/20/2020 property taxes
1285 05/21/2020 property taxes
1286 05/22/2020 property taxes
1287 05/26/2020 property taxes
1288 05/27/2020 property taxes
1289 05/28/2020 property taxes
1290 05/29/2020 property taxes
Account: 533-40000-000-000
Account:
533-40002-000-000-
1275 05/06/2020 property taxes
1280 05/12/2020 Property Taxes
1284 05/20/2020 property taxes
1285 05/21/2020 property taxes
1287 05/26/2020 property taxes
1288 05/27/2020 property taxes
Account: 533-40002-000-000
June 15, 2020 Regular Meeting Agenda Packet
Page 50
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: Revenues Program:
Period Ending: 5/2020
JE Detail Beginning Transaction Transaction Vendor Name
Description/Comment Balance Detail Detail
(SUBTOTAL)
Property Taxes
Property Taxes Totals:
(682,441.00) Budgeted
Property Taxes/Delinquent
(678,137.33)
(41.52) (678,178.85)
(1.00) (678,179.85)
(4.54) (678,184.39)
(187.49) (678,371.88)
(607.86) (678,979.74)
(24.72) (679,004.46)
(29.91) (679,034.37)
127.65 (678,906.72)
(85.78) (678,992.50)
(412.44) (679,404.94)
(148.47) (679,553.41)
(102.48) (679,655.89)
(248.76) (679,904.65)
(335.33) (680,239.98)
(236.54) (680,476.52)
(114.31) (680,590.83)
(376.06) (680,966.89)
(234.31) (681,201.20)
(303.30) (681,504.50)
(936.50) Remaining 100 % Used
IIIIII1Eperty Taxes/Delinquent Totals:
(1,000.00) Budgeted 789.72 Remaining
Account: 533-40015-000-0 Property Taxes/P & I
1272 05/01/2020 Property Taxes
1273 05/04/2020 Property Taxes
1274 05/05/2020 Property Taxes
1275 05/06/2020 property taxes
1277 05/07/2020 property taxes
(1,853.78)
179 % Used
(1,665.43)
114 of 150
(8.70) (1,862.48)
119.90 (1,742.58)
(13.26) (1,755.84)
(20.20) (1,776.04)
(6.03) (1,782.07)
(7.65) (1,789.72)
(.25) (1,665.68)
(.11) (1,665.79)
(.53) (1,666.32)
(2.43) (1,668.75)
(66.91) (1,735.66)
Check Source
Number
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
glpdatb2 skrolczyk
10:08 06/10/20
Fund: 533 MUD 1 I&S Consolidated
JE JE JE
Number Date Description
1279 05/11/2020 Property Taxes
1280 05/12/2020 Property Taxes
1282 05/15/2020 property taxes
1283 05/18/2020 property taxes
1293 05/19/2020 property taxes
1284 05/20/2020 property taxes
1285 05/21/2020 property taxes
1286 05/22/2020 property taxes
1287 05/26/2020 property taxes
1288 05/27/2020 property taxes
1289 05/28/2020 property taxes
1290 05/29/2020 property taxes
June 15, 2020 Regular Meeting Agenda Packet
Trophy Club MUD No.1 Page 51
Detailed Accounting Trial Balance
Department: Revenues Program:
Period Ending: 5/2020
JE Detail Beginning Transaction Transaction Vendor Name Check Source
Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 533-40015-000-000 Property Taxes/P & I
(2,000.00) Budgeted
Account: 533-49011-000-000 Interest Income
1269 05/31/2020 Bank Interest- May
(1,665.43) (3.89) (1,739.55) GL
(.53) (1,740.08) GL
(36.96) (1,777.04) GL
(2.86) (1,779.90) GL
(.53) (1,780.43) GL
(17.85) (1,798.28) GL
.14 (1,798.14) GL
(13.99) (1,812.13) GL
(1.50) (1,813.63) GL
(2.21) (1,815.84) GL
(.16) (1,816.00) GL
(7.78) (1,823.78) GL
(176.22) Remaining 91 % Used
(3,531.93) (213.71)
(1,823.78) **
(3,745.64) GL
Account: 533-49011-000-000
Interest Income
(213.71)
Account: 533-49015-000-000
(5,000.00) Budgeted
(1,254.36) Remaining 75 % Used
ental Incom
IL
Account: 533-49015-000-000 Lease/Rental Income
(218,004.00) Budgeted
Account:
(218,004.00)
.00 Remaining 100 % Used
Interfund Trans In -PID Surchg
1292 05/31/2020 TexPool Transfers May TexPool O&M to I&S- PID Debt
(72,903.67)
Account: 533-49141-000-000 Interfund Trans In -PID Surchg Totals: 1
(114,563.00) Budgeted (31,244.52) Remaining
.00 (218,004.00)
(10,414.81) (83,318.48)
73 % Used
Department Totals: (990,186.12) **
(14,089.98) Monthly Total
(1,023,008.00) Budgeted (32,821.88) Remaining 97 % Used
115 of 150
GL
June 15, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 52
10:08 06/10/20 Detailed Accounting Trial Balance
Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program:
Period Ending: 5/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 533-70005-051-000
Paying Agent Fee
1,450.00
.00 1,450.00
Account: 533-70005-051-000
Paying Agent Fee Totals: .00 1,450.00 **
2,150.00 Budgeted
700.00 Remaining 67 % Used
Account: 533-70025-051-000 Bond Interest Expense -Tax
123,928.75
.00 123,928.75
Account: 533-70025-051-000
Bond Interest Expense -Tax Totals:
.00 123,928.75 **
247,858.00 Budgeted
123,929.25 Remaining 50 % Used
Account: 533-70035-051-000 Bond Principal Payment -Tax
.00 .00
Account: 533-70035-051-000 Bond Principal Payment -Tax Totals: .00 .00 **
765,000.00 Budgeted
765,000.00 Remaining 0 % Used
Department 51 Totals: 125,378.75 **
.00 Monthly Total 1,015,008.00 Budgeted 889,629.25 Remaining 12 % Used
Fund 533 Totals: (864,807.37)
(14,089.98) Monthly Total
(8,000.00) Budgeted 856,807.37 Remaining ##########
116 of 150
June 15, 2020 Regular Meeting Agenda Packet
TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP)
BALANCE SHEET
MAY 2020
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
534
REVENUE BOND
I&S WWTP
356,844
TOTAL ASSETS 356,844
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
117 of 150
24,518
332,326
356,844
356,844
June 15, 2020 Regular Meeting Agenda Packet
glbase tbam skrolczyk Trophy Club MUD No.1
10:08 06/10/20 Budget Summary with Amendment
Fund: 534 2015 Revenue Bond I&S Department: Revenues Program:
Period Ending: 5/2020
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
534-49011-000-000 Interest Income 2,500.00- 2,500.00-
534-49143-000-000 Interfund Transfer In -WW Sales 598,638.00- 598,638.00-
Subtot 6060- 601 438.00 -
Program number: 6011111100 -
Department number: Revenues 6011'36.00 -
Revenues Subtotal 601,138.00-
601,138.00-
601,138.00-
601,138.00-
118 of 150
69.98- 1,272.98- 50.919
54,421.63- 435,372.44- 72.727
54,491.61- 431E85.42- -636
54,491.61-
54,491.61-
54,491.61-
436,645.42-
436,645.42-
436,645.42-
636
1,227.02-
163,265.56-
164,492.58-
164,492.58-
164,492.58-
164,492.58 -
Page 22
June 15, 2020 Regular Meeting Agenda Packet
glbase tbam skrolczyk Trophy Club MUD No.1
10:08 06/10/20 Budget Summary with Amendment
Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program:
Period Ending: 5/2020
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
534-70005-051-000 Rev Bond Paying Agent Fee 400.00 400.00 200.00 50.000 200.00
534-70040-051-000 Revenue Bond Interest Expense 208,238.00 208,238.00 104,118.75 50.000 104,119.25
534-70045-051-000 Revenue Bond Principal Expense 390,000.00 390,000.00 390,000.00
Subtotal: , 598,638.00 598,638.00 17.426 494,319.25
Program number: III 598,638.00 598,638.00 10 17.426 494,319.25
Department number: Administration III 598,638.00 598,638.00 10L8.75 17.426 494,31
Expenditures Subtotal ill 598,638.00 598,638.00 1imL8.75 17.426 494,319.25
Fund number: 534 2015 Revenue Bond I&S M2,500.00- 2,500.00- 54,491.61- 6.67- ############### 329,826.67
119 of 150
Page 23
glpdatb2 skrolczyk
10:08 06/10/20
Fund: 534 2015 Revenue Bond I&S
JE JE JE
Number Date Description
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: Revenues
Period Ending: 5/2020
JE Detail
Description/Comment
June 15, 2020 Regular Meeting Agenda Packet
Page 53
Program:
Beginning Transaction Transaction Vendor Name
Balance Detail Detail
(SUBTOTAL)
Check Source
Number
Department Totals:
(54,491.61) Monthly Total
(436,645.42) **
(601,138.00) Budgeted (164,492.58) Remaining 73 % Used
120 of 150
Account:
534-49011-000-000
Interest Income
1269 05/31/2020 Bank Interest- May
(1,203.00)
(69.98)
(1,272.98)
GL
Account:
534-49011-000-000
Interest Income Totals:
(69.98)
(1,272.98)
**
(2,500.00) Budgeted (1,227.02) Remaining 51 %
Used
Account:
534-49143-000-000
Interfund Transfer In -WW Sales
.11
1292 05/31/2020 TexPool Transfers
May TexPool O&M to Rev Bd WWTP I&S (380,950.81)
(54,421.63)
(435,372.44)
GL
Account:
534-49143-000-000
Interfund Transfer In -WW Sales Totals: W.
(54,421.63)
(435,372.44)
**
(598,638.00) Budgeted (163,265.56) Remaining 73 %
Used
Department Totals:
(54,491.61) Monthly Total
(436,645.42) **
(601,138.00) Budgeted (164,492.58) Remaining 73 % Used
120 of 150
June 15, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 54
10:08 06/10/20 Detailed Accounting Trial Balance
Fund: 534 2015 Revenue Bond IES Department: 51 Administration Program:
Period Ending: 5/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 534-70005-051-000
Rev Bond Paying Agent Fee
Account: 534-70005-051-000 11 Rev Bond Paying Agent Fee
400.00 Budgeted 200.00 Remaining
Account: 534-70040-051-000 Revenue Bond Interest Expense
Account: 534-70040-051-000 Revenue Bond Interest Expense Totals:
208,238.00 Budgeted 104,119.25 Remaining
200.00
104,118.75
50 % Used
.00 200.00
.00 104,118.75
50 % Used
Account: 534-70045-051-000 Revenue Bond Principal Expense
A,t: 534-70045-051-000 Revenue Bond Principal Expense Totals:
390,000.00 Budgeted 390,000.00 Remaining
.00 .00
0 % Used
Department 51 Totals: 104,318.75 **
.00 Monthly Total 598,638.00 Budgeted 494,319.25 Remaining 17 % Used
Fund 534 Totals: (332,326.67)
(54,491.61) Monthly Total
(2,500.00) Budgeted 329,826.67 Remaining ##########
121 of 150
June 15, 2020 Regular Meeting Agenda Packet
TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S
BALANCE SHEET
MAY 2020
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
PIA
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
535
NSII FTW SWIFT
REVENUE BOND
I&S
175,649
TOTAL ASSETS 175,649
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES
TOTAL FUND BALANCE
TOTAL LIABILITIES AND FUND BALANCE
122 of 150
4,967
170,682
175,649
175,649
June 15, 2020 Regular Meeting Agenda Packet
glbase tbam skrolczyk Trophy Club MUD No.1
10:08 06/10/20 Budget Summary with Amendment
Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program:
Period Ending: 5/2020
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
535-49011-000-000 Interest Income 1,000.00- 1,000.00- 34.80- 562.78- 56.278 437.22-
535-49142-000-000 Interfund Tran In -Water Sales 275,525.00- 275,525.00- 25,047.72- 200,381.76- 72.727 75,143.24 -
Sub tot
5,143.24-Subtot 25.00- - 0,944.54- 75,580.46 -
Program number: 0- 276125.00- = 25,082.52- 200,944.54- , 72.668 75,580.46 -
Department number: Revenues 0- 276,525.00- II 25,082.52- 200,944.54- , 72.668 75,580.46 -
Revenues Subtotal 276,525.00- 276,525.00- II 25,082.52- 200,944.54- , 72.668 75,580.46-
123 of 150
Page 24
glbase_tbam skrolczyk
10:08 06/10/20
Fund: 535 2016 Rev Bond I&S-SWIFT
Account Description
535-70005-051-000
535-70040-051-000
1 535-70045-051-000
Rev Bond Paying,Agent Fee
Revenue Bond Interest Expense
Revenue Bond Principal Expense
June 15, 2020 Regular Meeting Agenda Packet
Trophy Club MUD No.1
Budget Summary with Amendment
Department: 51 Administration Program:
Period Ending: 5/2020
Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
800.00
386,811.00
215,000.00
800.00
386,811.00
215,000.00
200.00
30,062.50
25.000
7.772
600.00
356,748.50
215,000.00
Page 25
Subtotal:
-ImmommlOOPk11.00 60211.00
30,262.50
5.022 572,348.50
Program number:
602,611.00
602,611.00
30,262.50
5.022
572,348.50
Department number: Administration
602,611.00
602,611.00
30,262.50
5.022
572,348.50
Expenditures
Subtotal
602,611.00
602,611.00
30,262.50
5.022
572,348.50
Fund number: 535 2016 Rev Bond I&S-SWIFT
326,086.00
326,086.00
25,082.52- 170,682.04-
-52.343
496,768.04
124 of 150
glpdatb2 skrolczyk
10:08 06/10/20
Fund: 535 2016 Rev Bond I&S-SWIFT
JE JE JE
Number Date Description
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: Revenues
Period Ending: 5/2020
JE Detail
Description/Comment
June 15, 2020 Regular Meeting Agenda Packet
Page 55
Program:
Beginning Transaction Transaction Vendor Name
Balance Detail Detail
(SUBTOTAL)
Check Source
Number
Department Totals:
(25,082.52) Monthly Total
(200,944.54) **
(276,525.00) Budgeted (75,580.46) Remaining 73 % Used
125 of 150
Account:
535-49011-000-000
Interest Income
1269 05/31/2020 Bank Interest- May
(527.98)
(34.80)
(562.78)
GL
Account:
535-49011-000-000
Interest Income
Totals:
(34.80)
(562.78)
**
(1,000.00) Budgeted
(437.22) Remaining 56 9
Used
Account:
535-49142-000-000
Interfund Tran In -Water
Sales
1292 05/31/2020 TexPool Transfers
May TexPool O&M to
16Swift Rev I&S (175,334.04)
(25,047.72)
(200,381.76)
GL
Account:
535-49142-000-000
Interfund Tran In -Water
Sales Totals:
(25,047.72)
(200,381.76)
**
(275,525.00) Budgeted
(75,143.24) Remaining 73 %
Used
Department Totals:
(25,082.52) Monthly Total
(200,944.54) **
(276,525.00) Budgeted (75,580.46) Remaining 73 % Used
125 of 150
June 15, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 56
10:08 06/10/20 Detailed Accounting Trial Balance
Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program:
Period Ending: 5/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 535-70005-051-000
Account: 535-70005-051-000 11
Rev Bond Paying Agent Fee
200.00
Rev Bond Paying Agent Fee
800.00 Budgeted 600.00 Remaining
Account: 535-70040-051-000 Revenue Bond Interest Expense
Account: 535-70040-051-000
Account: 535-70045-051-000
30,062.50
Revenue Bond Interest Expense Totals:
386,811.00 Budgeted 356,748.50 Remaining
25 % Used
.00 200.00
.00 30,062.50
8 % Used
Revenue Bond Principal Expense
Revenue Bond Principal Expense Totals:
215,000.00 Budgeted 215,000.00 Remaining
.00 .00
0 % Used
Department 51 Totals: 30,262.50 **
.00 Monthly Total 602,611.00 Budgeted
572,348.50 Remaining 5 % Used
Fund 535 Totals: (170,682.04)
(25,082.52) Monthly Total 326,086.00 Budgeted 496,768.04 Remaining -52 % Used
126 of 150
June 15, 2020 Regular Meeting Agenda Packet
TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S
WATER & WASTEWATER SYSTEM 2019
BALANCE SHEET
MAY 2020
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
ILIP
TROPHY CLUB
1
MUNICIPAL
UTILITY
DISTRICT
536
REVENUE BOND
SERIES 2019 I&S
23,295
TOTAL ASSETS 23,295
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES 23,295
TOTAL FUND BALANCE 23,295
TOTAL LIABILITIES AND FUND BALANCE 23,295
127 of 150
glbase_tbam skrolczyk
10:08 06/10/20
Fund: 536 2019 Rev Bond I&S- W&WW System
Account Description
536-49011-000-000
536-49142-000-000
536-49143-000-000
Interest Income
Interfund Tran In -Water Sales
Interfund Transfer In -WW Sales
June 15, 2020 Regular Meeting Agenda Packet
Trophy Club MUD No.1
Budget Summary with Amendment
Department: Revenues Program:
Period Ending: 5/2020
Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
5.34-
Program number:
5.34-
Department number:
Revenues
Revenues
Subtotal
128 of 150
5.34-
5.34-
448.86-
183,168.16-
54,712.56-
238,329.58-
238,329.58-
238,329.58-
238,329.58 -
448.86
183,168.16
54,712.56
238,329.58
238,329.58
238,329.58
238,329.58
Page 26
glbase_tbam skrolczyk
10:08 06/10/20
Fund: 536 2019 Rev Bond I&S- W&WW System
Account
1
1 536-70005-051-000
1 536-70040-051-000
Description
Rev Bond Paying Agent Fee
Revenue Bond Interest Expense
Trophy Club MUD No.1
Budget Summary with Amendment
Department: 51 Administration
Period Ending: 5/2020
Program:
June 15, 2020 Regular Meeting Agenda Packet
Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
142.08
214,892.43
142.08-
214,892.43 -
Page 27
******* End of Report *********
129 of 150
Subtotal:
215,034.51
215,034.51 -
Program number:
215,034.51
215,034.51 -
Department number:
Administration
215,034.51
215,034.51 -
Expenditures
Subtotal
215,034.51
215,034.51 -
Fund number: 536
2019 Rev Bond I&S- W&WW System
5.34-
23,295.07-
23,295.07
******* End of Report *********
129 of 150
glpdatb2 skrolczyk
10:08 06/10/20
Fund: 536 2019 Rev Bond I&S- W&WW System
JE JE JE
Number Date Description
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: Revenues
Period Ending: 5/2020
JE Detail
Description/Comment
June 15, 2020 Regular Meeting Agenda Packet
Page 57
Program:
Beginning Transaction Transaction Vendor Name
Balance Detail Detail
(SUBTOTAL)
Check Source
Number
Department Totals:
(5.34) Monthly Total
.00 Budgeted
130 of 150
(238,329.58) **
238,329.58 Remaining 0 % Used
Account:
536-49011-000-000
Interest Income
1269 05/31/2020 Bank
Interest-
May
(443.52)
(5.34)
(448.86)
GL
Account:
536-49011-000-000
Interest Income Totals:
(5.34)
(448.86)
**
.00 Budgeted 448.86 Remaining
0 %
Used
Account:
536-49142-000-000
Interfund Tran In -Water Sales
(183,168.16)
.00
(183,168.16)
Account:
536-49142-000-000
Interfund Tran In -Water Sales Totals: ;
.00
(183,168.16)
**
.00 Budgeted 183,168.16 Remaining
0 %
Used
Account:
536-49143-000-000
Interfund Transfer In -WW Sales
(54,712.56)
.00
(54,712.56)
Account:
536-49143-000-000
Interfund Transfer In -WW Sales Totals:
.00
(54,712.56)
**
.00 Budgeted 54,712.56 Remaining
0 %
Used
Department Totals:
(5.34) Monthly Total
.00 Budgeted
130 of 150
(238,329.58) **
238,329.58 Remaining 0 % Used
June 15, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 58
10:08 06/10/20 Detailed Accounting Trial Balance
Fund: 536 2019 Rev Bond 1&S- W&WW System Department: 51 Administration Program:
Period Ending: 5/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 536-70005-051-000
Account: 536-70005-051-000 11
Rev Bond Paying Agent Fee
Rev Bond Paying Agent
.00 Budgeted
142.08
(142.08) Remaining 0 % Used
Account: 536-70040-051-000 Revenue Bond Interest Expense
214,892.43
Account: 536-70040-051-000 Revenue Bond Interest Expense Totals:
.00 Budgeted (214,892.43) Remaining
Department 51 Totals:
Fund 536 Totals:
Grand Totals:
0 % Used
.00 Monthly Total .00 Budgeted
(5.34) Monthly Total .00 Budgeted
.00 142.08
.00 214,892.43
215,034.51 **
(215,034.51) Remaining 0 % Used
(23,295.07)
23,295.07 Remaining 0 % Used
******* End of Report *********
(1,965,535.73) ****
(59,904.72) Monthly Total (209,104.00) Budgeted 1,756,431.73 Remaining 940 % Used
131 of 150
June 15, 2020 Regular Meeting Agenda Packet
BUDGET VARIANCE REPORT
FUND: 122 - Fire O&M
FINANCIALS MONTH: May 2020
REVENUE VARIANCE: 58.1%
EXPENSE VARIANCE: 76.4%
NOTE: Explanation provided for all accounts with a Year -To -Date percentage (YTD%) less than the Revenue Variance and greater than or equal to the
Expense Variance. The Revenue and Expense Variance is calculated on a straight-line method (Financials Month x 8.3%), less 8.3% for
revenues and plus 10% for expenses. Only accounts with current month activity will be listed
ACCOUNT DESCRIPTION TOTAL
BUDGET CURRENT
MONTH YTD
TOTAL YTD % DATE OF
COMMENT VARIANCE EXPLANATION
FIRE REVENUES
122-40010 Property Taxes/Mud Fire $1,214,230 $5,991 $1,212,562 99.86% 10/2019 Property Taxes/MUD Fire
122-40011 Property Taxes/Fire - Delinquent -$105 $2,763 10/2019 Delinquent Fire Taxes
collected/paid out
122-40020 Property Taxes/Fire P&I $290 $4,301 10/2019 Fire Taxes Penalties & Interest
collected
FIRE EXPENSES
132 of 150
BUDGET VARIANCE
FUND:
FINANCIALS MONTH:
REVENUE VARIANCE:
EXPENSE VARIANCE:
NOTE:
ACCOUNT
REVENUE
135-47000-000
135-47025-000
135-47070-000
135-49011-000
EXPENSES
WATER
135-50010-010
135-50029-010
WASTEWATER
135-60010-020
135-65030-020
135-65045-020
BOARD OF DIRECTORS
(ADMINISTRATION
1135-55120-030
1135-55160-030
135-60025-030
1 Non -Departmental
June 15, 2020 Regular Meeting Agenda Packet
REPORT
135 - MUD 1 O&M
May 2020
58.1%
76.4%
Explanation provided for all accounts with a Year -To -Date percentage (YTD%) less than the Revenue Variance and greater than or equal to the
Expense Variance. The Revenue and Expense Variance is calculated on a straight-line method (Financials Month x 8.3%), less 8.3% for revenues
and plus 10% for expenses. Only accounts with current month activity will be listed
DESCRIPTION TOTAL CURRENT YTD YTD % DATE OF VARIANCE EXPLANATION
BUDGET MONTH TOTAL COMMENT
Water
Penalties
TCCC Effluent Charges
Interest Income
Overtime
Life Insurance & Other
Communications/Mobiles
Chemicals
Lab Supplies
Cleaning Services
Professional Outside Services
Water
$6,486,623 $459,564 $2,951,754 45.51% 01/2020
$112,608 -$58 $51,075 45.36% 04/2020
$50,000 $8,843 $25,909 51.82% 04/2020
$120,000 $3,764 $67,382 56.15% 5/2020
$17,000 $1,562 $13,428
$3,132 $329 $2,535
Water Sales
Penalties
TCCC Effluent Charges
Interest Income Decrease Rates
78.99% 01/2020 Overtime
80.94% 03/2020 Life Insurance
$5,000 $408 $3,904 78.08% 01/2020 New Tablet and Service
$20,000 $2,789 $19,928 99.64% 11/2019 Chemicals
$20,000 $102 $16,534 82.67% 03/2020 Lab Supplies
$10,000
$65,600
$1,500
$1,897
$54,600
-$228
133 of 150
$7,659
$57,100
$1,251
76.59%
87.04%
83.37%
05/2020
05/2020
04/2020
COVID-19; extra cleaning
M3 Contract Reclass
Increase due to Elections and Town
Public Service Building Leak
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
June 15, 2020 Regular Meeting Agenda Packet
Trophy Club Municipal Utility District No. 1
General Manager's Report
June 15, 2020
Regulatory Updates
• 2019 Consumer Confidence Report has been completed and approved by TCEQ
Capital Improvement Projects
• Wastewater Treatment Plant — Awaiting recommended testing procedures for the crane.
• Waterline Interconnect — Comments have been provided for the 95% plans and two easements
were received this month.
• Meadowbrook Water Line — The water line replacement is substantially complete. Awaiting pressure
testing, bacteriological sampling, and service connections.
• Board Room Upgrades — Awaiting quotes for the installation of new audio and video components.
Water Operations
• Water pumped — 80.279 MG
• Average day — 2.590 MGD
• Peak day — 3.764 on Tuesday, May 2nd, 2020
• Work orders completed - 206
• New meters set - 1
• Meter change outs - 3
• Meter heads changed - 0
• Leaks — 1
• Valve and hydrant Maintenance — 0
Wastewater Operations
• Wastewater treated - 7.94 MG
• Average daily flow - 1.13 MGD
• Peak flow - 1.49 MGD on Tuesday, May
26, 2020
• Rainfall - 2.43"
• Plant performance — no issues
• Plant effluent - no detect on laboratory
test results and E -coli
• CCTV - 0
• Pipe cleaning — 300' (inverted syphon)
134 of 150
Ju . 5 020 e ar M ting Agenda Packet
Trophy Club Municipal Utility iiis' ric o.
Public Water System ID No. TX0610018
2019 Annual Drinking Water Quality Report
Consumer Confidence Report June 2020
This information is provided to you by: Trophy Club Municipal Utility District No. 1
100 Municipal Drive, Trophy Club, Texas 76262, Phone: (682) 831-4600
District Contact: Alan Fourmentin, General Manager
Our Drinking Water Meets or Exceeds All
Federal (EPA) Drinking Water Requirements
This report is a summary of the quality of the water we
provide our customers. The analysis was made by using the
data from the most recent U.S. Environmental Protection
Agency (EPA) required tests and is presented in the
following pages. We hope this information helps you
become more knowledgeable about what is in your drinking
water. Should you have questions or need additional copies
of this report, please call the District office at (682) 831-4600.
The report is also available on our website at
www.tcmud.orci.
Special Population Advisory
You may be more vulnerable than the general
population to certain microbial contaminants, such as
Cryptosporidium, in drinking water. Infants, some
elderly, or immunocompromised persons such as those
undergoing chemotherapy for cancer; those who have
undergone organ transplants; those who are undergoing
treatment with steroids; and people with HIV/AIDS or
other immune system disorders can be particularly at
risk from infections. You should seek advice about
drinking water from your physician or health care
provider. Additional guidelines on appropriate means to
lessen the risk of infection by Cryptosporidium are
available from the Safe Drinking Water Hotline at (800)
426-4791.
Water Sources:
The sources of drinking water (both tap water and
bottled water) include rivers, lakes, streams, ponds,
reservoirs, springs, and wells. As water travels over the
surface of the land or through the ground, it dissolves
naturally -occurring minerals, and in some cases,
radioactive material, and can pick up substances
resulting from the presence of animals or from human
activity. Contaminants that may be present in source
water before treatment include:
• Microbial contaminants, such as viruses and
bacteria, which may come from sewage
treatment plants, septic systems, and
agricultural livestock operations and wildlife.
• Inorganic contaminants, such as salts and
metals, which can be naturally -occurring or
result from urban storm water runoff, industrial
or domestic wastewater discharges, oil and gas
production, mining, or farming.
• Pesticides and herbicides, which may come
from a variety of sources such as agriculture and
urban storm water runoff, and residential uses.
• Organic chemical contaminants, including
synthetic and volatile organic chemicals, which
are by-products of industrial processes and
petroleum production, and can also come from
gas stations, urban storm water runoff, and
septic systems.
• Radioactive contaminants, which can be
naturally -occurring or be the result of oil and gas
production and mining activities.
Public Participation Opportunities
Date: June 15, 2020
Time: 6:30 p.m.
Location: Zoom/telephone conference
The public toll-free dial -in numbers to participate
in the telephonic meeting are: 1 888 475 4499 and
1 877 853 5257; Meeting ID: 861 6449 3466
Este informe incluye informacion importante
sobre el agua potable. Si tiene preguntas o
comentarios sobre este informe en espanol, favor de
!lamer al tel. (682) 831-4600 para hablar con una
persona bilingue en espanol.
Where Do We Get Our Drinking Water?
Our drinking water is obtained from both surface and
groundwater sources. Surface water is purchased from the
City of Fort Worth and its sources are Lake Worth, Eagle
Mountain Lake, Lake Bridgeport, Richland Chambers
Reservoir, Cedar Creek Reservoir, and the Clear Fork
Trinity River (from Lake Benbrook). Groundwater sources
are from four wells including three from the Paluxy Aquifer
and one from the Trinity Aquifer. The Texas Commission on
Environmental Quality (TCEQ) completed an assessment of
your drinking water sources and results indicate that some
of your sources are susceptible to certain contaminants. The
sampling requirements for your water system are based on
this susceptibility and previous sample data. Any detection
of these contaminants may be found in this report. For more
information about your sources of water please refer to the
Source Water Assessment Viewer available at
http://www.tcecl.texas.aov/ais/swaview. Further details
about sources and source -water assessments are available
on Texas Drinking Water Watch at
http://dww2.tcea.texas.aov/DWW/. For more information on
source water assessments and protection efforts at our
135 ofslyMem, contact Alan Fourmentin at (682) 831-4600.
June 15, 2020 Regular Meeting Agenda Packet
All Drinking Water May Contain Contaminants
When drinking water meets federal standards there may not be any health -based benefits to purchasing bottled water or
point -of -use devices. Drinking water, including bottled water, may reasonably be expected to contain at least small amounts
of some contaminants. The presence of contaminants does not necessarily indicate that water poses a health risk. In order
to ensure tap water is safe to drink, the EPA and TCEQ prescribe regulations which limit the amount of certain contaminants
in water provided by public water systems. FDA regulations establish limits for contaminants in bottled water, which must
provide the same protection for public health. More information about contaminants and potential health effects can be
obtained by calling the EPA's Safe Drinking Water Hotline at (800) 426-4791.
Water Quality Data
The table in this report lists all the drinking water contaminants we detected during tests conducted from the previous
calendar year, unless otherwise noted. The state requires us to monitor for certain contaminants less than once per year
because the concentrations of these contaminants are not expected to vary significantly from year to year. Therefore, some
of the data, though representative of the water quality, is more than one year old.
Secondary Constituents
Many constituents (such as calcium, sodium or iron) which are often found in drinking water, can cause taste, color and
odor problems. The taste and odor constituents are called secondary constituents and are regulated by the State of Texas,
not the EPA. These constituents are not causes for health concerns. Therefore, secondary constituents are not required
to be reported in this document, but they may greatly affect the appearance and taste of your water.
About the Following Pages
The pages that follow list all of the federally regulated or monitored contaminants which have been found in your drinking
water. The United States Environmental Protection Agency (EPA) requires water systems to test up to 97 constituents.
Please note that not all constituents are required to be sampled every year. Only the most recent year for sampling of a
constituent is included in the report.
Definitions
Action Level (AL): The concentration of a contaminant which, if exceeded, triggers treatment or other requirements which a water
system must follow.
Action Level Goal (ALG): The level of a contaminant in drinking water below which there is no known or expected risk to health. ALGs
allow for a margin of safety.
Average (Avg): Regulatory compliance with some MCLs are based on running annual average of monthly samples.
Maximum Contaminant Level (MCL): The highest permissible level of a contaminant in drinking water. MCLs are set as close to the
MCLGs as feasible using the best available treatment technology.
Maximum Contaminant Level Goal (MCLG): The level of a contaminant in drinking water below which there is no known or expected
health risk. MCLGs allow for a margin of safety.
Maximum Residual Disinfectant Level (MRDL): The highest level of disinfectant allowed in drinking water. There is convincing
evidence that addition of a disinfectant is necessary for control of microbial contaminants.
Maximum Residual Disinfectant Level Goal (MRDLG): The level of a drinking water disinfectant below which there is no known or
expected risk to health. MRDLGs do not reflect the benefits of the use of disinfectants to control microbial contamination.
Treatment Technique (TT): A required process intended to reduce the level of a contaminant in drinking water.
Abbreviations
MFL - million fibers per liter (a measure of asbestos)
N/A - not applicable
NTU - Nephelometric Turbidity Units
ppq - parts per quadrillion, or picograms per liter
ppt - parts per trillion, or nanograms per liter
pCi/L - picocuries per liter (a measure of radioactivity)
ppm - parts per million, or milligrams per liter (mg/I)
ppb - parts per billion, or micrograms per liter (ug/I)
mrem/yr — millirems per year
ND — (not -detectable) lab analysis indicates not present
UMHO/CM — micromhos
Lead and Date MCLG Action 90th # Sites Units Violation Likely Source of Contamination
Copper Sampled Level (AL) Percentile Over AL
Copper 2019 1.3 1.3 0.3508 0 ppm N Erosion of natural deposits; Leaching from wood
preservatives; Corrosion of household plumbing
systems.
Lead 2019 0 15 2.9 0 ppb N Corrosion of household plumbing systems;
Erosion of natural deposits.
If present, elevated levels of lead can cause serious health problems, especially for pregnant women and young children. Lead in drinking water is primarily
from materials and components associated with service lines and home plumbing. Trophy Club Municipal Utility District No. 1 is responsible for providing
high quality drinking water but cannot control the variety of materials used in plumbing components. When your water has been sitting for several hours,
you can minimize the potential for lead exposure by flushing your tap for 30 seconds to 2 minutes before using water for drinking or cooking. If you are
concerned about lead in your water, you may wish to have your water tested. Information on lead in drinking water, testing methods, and steps you can
take to minimize exposure is available from the Safe Drinking Water Hotline or at http://www.epa.gov/safewater/lead.
136 of 150
Maximum Residual Disinfectant Level
Average Minimum Maximum
Year Disinfectant Level Level Level MRDL
2019 Chloramine Residual 2.91 1.0 3.90 4.0
(Total Chlorine)
Disinfection By -Products
June 15, 2020 Regular Meeting Agenda Packet
MRDLG
<4.0
Unit of Violation
Measure (Y or N)
ppm N
Highest Range of
Collectio Contaminant Level Levels MCL Unit of Violation
n Date Detected Detected Measure (Y or N)
2019 HAA5 Total Haloacetic Acids 11 7.2-12.7 60
2019 Total Trihalomethanes 19 9.08-31.6 80
ppb N
ppb N
Source of Disinfectant
Disinfectant used to
control microbes.
Source of Contaminant
Byproduct of drinking water
disinfection.
Byproduct of drinking water
disinfection.
[*The value in the Highest Level or Average Detected column is the highest average of all sample results collected at a location over a year'
*Highest level detected is based on a running annual average calculated from quarterly samples as required by TCEQ, and may be from
predecessor system measurement
Inorganic Collection Highest Range of Individual
Contaminants Date Level Samples MCLG MCL Units Violation Likely Source of Contamination
Detected
Barium 2019 0.055 0.055 - 0.055 2 2 ppm N Discharge of drilling wastes; Discharge from
metal refineries; Erosion of natural deposits.
Cyanide
Fluoride
Mercury
Nitrate
[measured as
Nitrogen]
10/10/2017 73.2 73.2 - 73.2 200 200 ppb N Discharge from plastic and fertilizer factories;
Discharge from steel/metal factories.
10/10/2017 0.666 0.666 - 0.666 4 4.0 ppm N Erosion of natural deposits; Water additive
which promotes strong teeth; Discharge from
fertilizer and aluminum factories.
2019 2.26 2.26 - 2.26 2 2 ppb N Erosion of natural deposits; Discharge from
refineries and factories; Runoff from landfills;
Runoff from cropland.
2019 0.257 0.257 - 0.257 10 10 ppm N Runoff from fertilizer use; Leaching from
septic tanks, sewage; Erosion of natural
deposits.
Radioactive Collection Highest Level Range of Individual
Contaminants Date Detected Samples
Beta/photon
emitters
2019 4.8 4.8 - 4.8
MCLG MCL Units Violation Likely Source of Contamination
*EPA considers 50 pCi/L to be the level of concern for beta particles.
Organic Contaminants — (Measured in Fort Worth system)
Year
2019
Contaminant
Atrazine
Highest Level
Detected
0.1
Range of Levels
Detected
0-0.1
Microbial Contaminants NONE DETECTED
0 50 pCi/L* N Decay of natural and man-made
deposits.
MCLG
3
Highest Single
Measurement
MCL
3
Unit of Measure
ppb
Lowest Monthly %
Year Contaminant MCL of Samples Source of Contaminant
Meeting Limits
2019 Total Coliform, including E. Coli 0 Absent 100% N Human and animal fecal waste.
Total Coliform Bacteria are used as indicators of microbial contamination of drinking water because testing for them is easy. While not disease -causing
organisms themselves, they are often found in association with other microbes that are capable of causing disease. Coliform are hardier than many
disease -causing organisms; therefore, their absence from water is a good indication that the water is microbiologically safe for human consumption.
Violation
(Y or N)
N
Violation
(Y or N)
Source of Contaminant
Herbicide
Radioactive Contaminants (Source Water: City of Fort Worth)
Year Contaminant Highest Level Range of Levels MCLG MCL Unit of Violation
Detected Detected Measure (Y or N)
2017 Combined Radium 2.5 NA 0 5 pCi/L N
(-226 & -228)
137 of 150
Source of Contaminant
Erosion of natural deposits.
2017
Beta/photon
emitters
5.6
4.4 - 5.6
*EPA considers 50 pCi/L to be the level of concern for Beta particles
Inorganic C^ntaminants (Source Water: Cloy of Fort Worth)
Highest Range of
0
50*
June 15, 2020 Regular Meeting Agenda Packet
(mrem/year)
/(pCi/L)
Unit of Violation
N
Decay of natural and man-
made deposits.
Year Contaminant Level Levels MCLG MCL Measure (Y or N) Source of Contaminant
Detected Detected
Erosion of natural deposits; runoff from
2019 Arsenic 1.50 0 — 1.10 0 10 ppb N orchards; runoff from glass and
electronics production wastes.
Discharge of drilling wastes; discharge
2019 Barium .07 .05 - .07 2 2 ppm N from metal refineries; erosion of natural
deposits.
2019 Uranium 1.1 0 to 1.1 0 30 Ppb N Erosion of natural deposits
2019 Cyanide 126 74.8 to 126 200 200 ppb N Discharge plastic and fertilizer factories;
discharge from steel/metal factories.
Water additive which promotes strong
teeth; Erosion of natural deposits; water
2019 Fluoride .54 .15 - .54 4 4 ppm N additive which promotes strong teeth;
discharge from fertilizer and aluminum
factories.
2019 Bromate 4.35 0 — 14.8 10 0 ppm N By-product of drinking water disinfection
Inorganic Contaminants Cont. Source Wa er: City of Fort Worth)
Collection Contaminant Highest Range of MCLG MCL Unit of Violation Collection Date
Date Level Levels Measure
Detected Detected
Nitrate * Runoff from fertilizer use; leaching from
2019 (measured as .58 0.18 — 0.58 10 10 ppm N septic tanks, sewage; erosion of natural
nitrogen) deposits.
Runoff from fertilizer use; leaching from
2019 Nitrite** .02 .01 - .02 1 1 ppm N septic tanks, sewage; erosion of natural
deposits.
**Measured in Fort Worth System
*Nitrate Advisory: Nitrate in drinking water at levels above 10 ppm is a health risk for infants of less than six months of age. High nitrate levels in
drinking water can cause blue baby syndrome. Nitrate levels may rise quickly for short periods of time because of rainfall or agricultural activity. If you
are caring for an infant, you should ask advice from your health care provider.
Turbidity (Source Water: City of Fort Worth)
Year Contaminant MCL MCLG Highest Single Range of Levels Turbidity Unit of Violation Source of
Measurement Detected Limits Measure (Y or N) Contaminant
Turbidity —
2019 Highest TT=1 NA 0.5 NA 0.3 NTU N Soil runoff.
Measurement
2019 % of Samples TT=99 NA NA NA 0.3 NTU N Soil Runoff
<_ 0.3 NTU
§290.275(3)(5) Turbidity. Turbidity has no health effects. However, turbidity can interfere with disinfection and provide a medium for microbial growth.
Turbidity may indicate the presence of disease -causing organisms. These organisms include bacteria, viruses, and parasites that can cause symptoms
such as nausea, cramps, diarrhea, and associated headaches.
Total Or Ianic Carbon (Source Water: City of Fort Worth)
Year Contaminant MCL MCLG Highest Lowest Average Violation Source of
Measurement Measurement (Y or N) Contaminant
2019 Total Organic Carbon % TT =
removal N/A 1 1 1 N Naturally occurring.
Total Organic Carbon is used to determine disinfection by-product precursors. The City of Fort Worth was compliant with all monitoring and treatment
technique requirements for disinfection by-product precursors.
Year -Round Watering Restrictions in Effect
Consult the TCMUD.org website for further details. htto://tcmud.ora/customer-service/water-restrictions/
138 of 150
June 15, 2020 Regular Meeting Agenda Packet
Unregulated Contaminants
Unregulated contaminants are those for which EPA has not established drinking water standards. The purpose of unregulated
contaminant monitoring is to assist EPA in determining the occurrence of unregulated contaminants in drinking water and
whether future regulation is warranted.
Compound Measure
MRDL
MRDLG Average Range of
Detects
Common Sources
of Substance
Chloral Hydrate
ppb Not regulated
N/A 0.33 0.23 to 0.43 By-product of drinking water
disinfection
Bromoform
Bromodichloromethane
Chloroform
Dibromochloromethane
ppb Not regulated
ppb Not regulated
ppb
ppb
0 1.07 1.02 to 4.09
0 3.97 1.12 to 8.94
Not regulated 70 3.68
Not regulated 60 3.68
1.32 to 8.11
1.01 to 10.4
By-products of drinking water
disinfection; not regulated
individually; included in Total
Trihalomethanes
Dibromoacetic Acid
Dichloroacetic Acid
Monobromoacetic Acid
Monochloroacetic Acid
Trichloroacetic Acid
ppb Not regulated
ppb Not regulated
ppb Not regulated
N/A 1.41
0 4.78
1.00 to 3.20
2.40 to 9.20 By-products of drinking water
disinfection; not regulated
individually; included in Haloacetic
1.00 to 2.50 Acids
1.00 to 2.00
N/A 0.02 1.00 to 1.00
ppb Not regulated 70 0.61
ppb Not regulated 20 0.09
(Source Water: City of Fort Worth)
Secondary Constituents
These items do not relate to public health but rather to the aesthetic
effects. These items are often important to industry.
Compound Measure Your water
Bicarbonate
Calcium
Chloride
Conductivity
pH
Magnesium
Sodium
Sulfate
Total Alkalinity as CaCO
Total Dissolved Solids
Total Hardness as CaCO3
Total Hardness in Grains
ppm
ppm
ppm
pmhos/cm
units
ppm
ppm
ppm
ppm
ppm
ppm
grains/gallon
(Source Water: City of Fort Worth)
128 to 149
42.4 to 60.7
19.5 to 35.1
403 to 482
8.1 to 8.4
4.64 to 8.30
15.1 to 26.8
23.4 to 44.3
128 to 150
192 to 266
138 to 178
8 to 10
Contaminants may be found in drinking water that may cause taste, color, or odor problems. These types of problems are not
necessarily causes for health concerns. For more information on taste, odor, or color of drinking water, please contact the system's
business office.
139 of 150
June 15, 2020 Regular Meeting Agenda Packet
Monthly Water Operations Report
Water Billed
FY October November December January February March April May June July August September Total Year
2010 39,794 39,713 29,547 30,305 25,328 23,279 41,646 53,439 102,921 89,760 128,687 82,331 686,750
2011 70,502 50,909 44,365 35,983 27,845 55,972 69,165 61,467 99,326 117,707 170,464 123,692 927,397
2012 85,869 53,571 40,815 30,616 31,665 35,263 47,194 84,905 114,104 137,174 144,573 108,622 914,371
2013 85,488 75,251 48,527 39,601 34,450 43,137 56,947 76,542 85,312 110,072 130,945 114,497 900,769
2014 82,660 48,813 34,482 39,767 37,085 54,794 66,337 84,384 99,240 92,913 113,135 110,873 864,483
2015 90,994 58,986 49,607 36,162 38,776 30,566 46,543 39,576 60,731 100,622 139,441 123,886 815,890
2016 108,951 41,936 39,028 39,622 44,551 49,498 55,181 50,827 65,390 115,687 119,611 98,945 829,227
2017 74,785 68,638 38,580 33,028 38,380 60,841 56,683 86,794 98,864 95,355 104,303 99,541 855,792
2018 83,228 69,099 48,144 34,592 40,658 43,411 60,079 89,802 118,899 126,588 125,531 73,735 913,766
2019 47,193 41,933 36,244 34,604 33,740 40,421 55,970 42,773 70,747 96,174 131,472 114,784 746,055
2020 102,150 40,988 43,946 36,418 31,000 34,047 53,755 67,030
140,000
120,000
100,000
80,000
60,000
40,000
20,000
WATER BILLED IN THOUSANDS OF GALLONS
409,334
Agi
0
October November December January February March April
Mr
June
July August September
- 2016
- 2017
- 2018
2019
- 2020
Water Pumped
FY October November December January February March April May June July August September Total Year
2010 40,803 41,600 32,700 31,400 30,145 27,240 43,400 62,646 113,049 94,950 131,650 76,159 725,742
2011 70,502 50,993 44,220 33,789 36,053 54,775 71,306 63,500 116,350 152,002 169,621 117,190 980,301
2012 83,750 54,245 41,650 34,740 31,581 46,519 62,649 100,402 110,324 153,813 139,005 123,045 981,723
2013 85,966 77,758 55,110 39,283 37,867 56,743 60,969 87,168 96,602 119,414 145,988 120,342 983,210
2014 81,909 51,769 39,769 48,758 42,395 61,100 71,283 96,481 95,206 110,173 123,369 115,607 937,819
2015 106,251 67,825 58,659 45,691 39,675 35,752 56,704 48,637 72,934 117,302 143,413 142,394 935,237
2016 106,731 52,616 43,708 46,945 50,721 55,178 60,434 55,562 68,138 112,533 128,963 104,664 886,193
2017 82,677 77,937 43,792 43,207 43,024 69,549 65,723 94,452 103,867 101,184 114,872 109,769 950,053
2018 91,439 78,282 55,745 40,796 40,750 51,711 67,217 97,980 124,109 155,354 144,015 85,946 1,033,344
2019 60,576 53,119 45,651 45,552 39,014 43,048 61,238 48,787 79,167 102,887 144,299 130,752 854,090
2020 112,971 48,627 49,384 40,726 35,749 38,576 57,714 74,153 457,900
180,000
160,000
140,000
120,000
100,000
80,000
60,000
40,000
20,000
WATER PUMPED IN THOUSANDS OF GALLONS
October November December January February March
April May June July August September
- 2016
- 2017
- 2018
2019
- 2020
Active Connections
FY October November December January February March April May June July August September
2014 Total 4139 4157 4173 4206 4209 4219 4240 4268 4280 4308 4333 4339
2015 Total 4353 4363 4377 4404 4413 4429 4443 4459 4478 4486 4498 4517
2016 Total 4531 4538 4556 4568 4593 4604 4607 4616 4622 4627 4632 4636
2017 Total 4644 4647 4661 4657 4663 4666 4670 4676 4685 4690 4696 4700
2017 MUD 3208 3210 3220 3216 3221 3224 3228 3234 3242 3247 3252 3256
2017 PID 1436 1437 1441 1441 1442 1442 1442 1442 1443 1443 1444 1444
2018 Total 4701 4706 4712 4716 4720 4724 4724 4728 4732 4735 4736 4738
2018 MUD 3257 3262 3268 3272 3276 3280 3280 3284 3288 3291 3292 3294
2018 PID 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444
2019 Total 4741 4743 4745 4753 4753 4758 4761 4762 4768 4770 4773 4782
2019 MUD 3297 3299 3301 3309 3309 3314 3317 3318 3324 3326 3329 3338
2019 PID 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444
140 of 150
June 15, 2020 Regular Meeting Agenda Packet
May 2020 Results
Ammonia -N CBOD5 TSS
Date % Removal % Removal % Removal
Influent Effluent Influent Effluent Influent Effluent
5 -May 5.3 0.20 96.2% 189 2.0 98.9% 138 1.0 99.3%
6 -May 44.8 0.20 99.6% 321 2.0 99.4% 290 1.0 99.7%
11 -May 47.2 0.20 99.6% 277 2.0 99.3% 170 1.0 99.4%
12 -May 49.5 0.20 99.6% 284 2.0 99.3% 353 1.0 99.7%
18 -May 37.2 0.20 99.5% 167 2.0 98.8% 146 1.0 99.3%
20 -May 42.5 0.29 99.3% 214 2.0 99.1% 323 1.0 99.7%
26 -May 47.5 0.44 99.1% 299 2.0 99.3% 214 1.0 99.5%
27 -May 35.0 0.20 99.4% 299 2.0 99.3% 143 1.0 99.3%
IReport
Ammonia -N CBOD5 TSS
0.24 1 99.0% 2.0 1 99.2% 1.0 1 99.5%
141 of 150
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
June 15, 2020 Regular Meeting Agenda Packet
Ammonia Nitrogen
Permit Limit 3 (Jan - March)
Permit Limit - 1 from April - August
0.523 0.57
0.23 0.2 0.21 0.241
Permit Limit 3 (Sept. - Dec.)
Dec -19
Jan -20 Feb -20
Mar -20 Apr -20
May -20 Jun -20
Jul -20 Aug -20
Max mg/L = .20 Average mg/L =.20
Carbonaceous Biochemical Demand (CBOD5)
Sep -20 Oct -20
Nov -20 Dec -20
2.0 2.0 2.0 2.0
2.0 2.0 2.0 2.0
2.0 2.0 2.0 2.0
II II II II II II
Permit Limit 5
Dec -19
Jan -20 Feb -20
Mar -20 Apr -20
May -20 Jun -20 Jul -20
Max mg/L = 2.0 Average mg/L = 2.0
142 of 150
Aug -20
Sep -20 Oct -20
Nov -20 Dec -20
- Nh3Ave
- Nh3
-Permit Limit
Bod
Bod Aver
Permit Limit
14.0
12.0
10.0
8.0
6.0
4.0
2.0
0.0
30.0
25.0
20.0
15.0
10.0
5.0
0.0
June 15, 2020 Regular Meeting Agenda Packet
Total Suspended Solids (TSS)
1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
.EP
Permit Limit 12
Dec -19
Jan -20 Feb -20
Mar -20 Apr -20
May -20 Jun -20
Jul -20 Aug -20
Max mg/L = 1.0 Average mg/L = 1.0
Nitrate - Nitrogen
Sep -20 Oct -20
Nov -20 Dec -20
5.1 5.10 4.95.00 6.0 5.34 5.05.26 4.5 5.11
4.3 4'97
11111111 1 1 1 1
Permit Limit 24
Dec -19
Jan -20 Feb -20
Mar -20 Apr -20
May -20 Jun -20 Jul -20
Max mg/L = 5.8 Average = 4.6
143 of 150
Aug -20
Sep -20 Oct -20
Nov -20 Dec -20
T55
- TSS Ave
- Permit Limit
- N -N
N -N Aver
- Permit Limit
10
9
8
7
6
5
4
3
2
1
0
10.0
9.0
8.0
7.0
6.0
5.0
4.0
3.0
2.0
1.0
0.0
June 15, 2020 Regular Meeting Agenda Packet
E. Coli
Permit Limit 126
1.0 1.0 1.0 1.0
NM
1.0 1.0 1.0 1.0
1.0 1.0 1.0 1.0
MI MI
Dec -19
Jan -20 Feb -20
Mar -20 Apr -20
May -20 Jun -20
Jul -20 Aug -20
Max mg/L = 1.0 Average mg/L = 1.0
Potential for Hydrogen (pH)
Sep -20 Oct -20
Nov -20 Dec -20
77
3
7.41 7.67 7.72
7.48 7.627.39 7.47
7.03 7.16 7.11
6.74•-
6.29
7.48
7.06
6.64•
Permit Limit High 9
Permit Limit Low 6
0.00
0.00 0.00
0.00 0.00 0.00 0.00
Dec -19
Jan -20 Feb -20
Mar -20 Apr -20
May -20 Jun -20
Jul -20
Aug -20 Sep -20
Max mg/L = 7.45 Min mg/L = 7.42 Average mg/L = 7.436
144 of 150
Oct -20
Nov -20 Dec -20
• E. Coli
• E. Coli Ave.
• Permit Limit
pH Min
pH Max
pH Aver
- Permit Limit Low
- Permit Limit
High
10
9
8
7
6
5
4
3
2
1
0
June 15, 2020 Regular Meeting Agenda Packet
Dissolved Oxygen (DO)
8.3 7.7 8.3 8.5 8.4 18.2 8.3 8.0
1II111It II
8.3
1
8.2
7.8
Permit Limit Max 9
Permit Limit Min 6
Dec -19
Jan -20 Feb -20
Mar -20 Apr -20
May -20 Jun -20 Jul -20 Aug -20
Max mg/L = 8.1 Average mg/L = 7.5
145 of 150
Sep -20 Oct -20
Nov -20 Dec -20
- DO
- DO Aver
- Permit Limit Min.
- Permit Limit Max
June 15, 2020 Regular Meeting Agenda Packet
Trophy Club MUD #1
Utility Billing Report
Fiscal Year 2020
October November December January February March April May June July August September
ebills 938 941 944 951 963 970 979 986
Bills Mailed 3841 3845 3860 3835 3817 3833 3815 3810
Bank Draft 646 650 652 654 649 649 661 660
Credit Card Draft 1193 1185 1193 1198 1168 1208 1249 1259
Online Payments 1145 1192 1,184 1,208 1,187 1,216 1,096 1,112
Late Notices 378 453 339 462 452 425 428^ 544^
Disconnects 21 41 42 27 38 20 64* 78*
M 3351 3352 3353 3353 3363 3363 3372 3373
Connections P 1444 1444 1444 1444 1444 1444 1444 1444
^ In response to COVID-19 the District has suspended Late Notices
* In response to COVID-19 the District has suspended Disconnects
Fiscal Year 2019
October November December January February March April May June July August September
ebills 870 867 868 883 885 890 903 904 932 932 932 936
Bills Mailed 3921 3921 3927 3903 3856 3859 3866 3859 3878 3875 3871 3859
Bank Draft 650 650 660 664 661 669 666 666 664 656 656 653
Credit Card Draft 1077 1109 1103 1114 1128 1151 1152 1152 1168 1161 1173 1179
Online Payments 1157 1130 1,124 1,149 1,111 1,129 1,100 1,162 1,098 1132 1145 1172
Late Notices 402 432 439 387 431 421 342 399 346 330 392 391
Disconnects 29 22 33 28 27 25 36 14 25 13 25 29
M 3297 3299 3301 3309 3309 3314 3317 3318 3324 3326 3329 3338
Connections P 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444
146 of 150
MUD Permits
Month: May 2020
June 15, 2020 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
5/11/2020 2020-34 $ 75.00 $ 1,173.00 $ 353.00 $ 150.00 $ 50.00 $ 1,801.00
Total $ 75.00 $ 1,173.00 $ 353.00 $ 150.00 $ 50.00 $
147 of 150
$ 1,801.00
J
June 15, 2020 Regular Meeting Agenda Packet
Fiscal Year 2020 Actuals vs Budgeted
YTD as of 05/31/2020
160,000,000
140,000,000
120,000,000
100,000,000
80,000,000
60,000,000
40,000,000
20,000,000
Water Consumption Adopted Budget vs Actual
00098,564
945,000
65,006,642
80,821,519
59,031,249 63,077,077
46,315,229
45,293,105
40,324,983
44,023,000
41,014,000
36,442,000
56,252,000
31,000,00034,047,000
106,694,8
78,084,000
134,074,841
129,995,80
—0—Budget
—0—Actual
Oct Nov Dec Jan Feb Mar Apr May Jun Jul
103,800,567
Aug Sep
1,200,000,000
1,000,000,000
800,000,000
600,000,000
400,000,000
200,000,000
O
Adopted Budget Water Consumption Vs Actual Water Consumption
974,534,461
441,807,000
Total Water Consumption
• Budgeted Water Consumption
• Actual Water Consumption
Adopted Budget vs YTD Actuals Revenues & Expenses
$5,232,858
$5,336,857
$10,638,853
$10,645,077
1
YTD Expenses YTD Revenues Adopted Budget Expenses Adopted Budget Revenues
Presented by:
Finance Department
900000.00
800000.00
700000.00
643222 29
600000.00
500000.00
400000.00
300000.00
200000.00
100000.00
0.00
Water Revenue Adopted Budget vs Actual
834474 99
411
5344246 347093 20
322271.27
—0—Budget
Revenue
--Actual Revenue
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
$7,000,000
$6,000,000
$5,000,000
$4,000,000
$3,000,000
$2,000,000
$1,000,000
so
Adopted Budget Total Water Revenue Vs Actual Total Water Revenue
$6,599,484
$2,951,754
$3,771,913
Total Water Revenue
$2,068,449
• Budgeted Total Revenue
• Actual Total Revenue
• Net Budget Total Revenue
Minus Budgeted Expenses
• Net Actual Total Revenue
Minus Actual Expenses
$1,105
0%
$129,319
3%
YTD Expense By Departments
• YTD Expense- Water
• YTD Expense- WW
YTD Expense- Admin
• YTD Expense- BOD
• YTD Expense- Non Dept
148 of 150
CASH STATUS AS OF MAY 2020
135-10250 TexPool 0 & M (XXXXX0002)-General Fund Operating ***
135-10300 Prosperity Bank (XXX8701) General Fund Operating
135-10305 Prosperity Bank Reserve -Savings Acct (XXXXX7724)
135-11100 Petty Cash Administration
135-11150 Petty Cash Utility Billing
137-10250 TexPool 0 & M (XXXXX0002) GASB Replacement
517-10250 TexPool Construction Tax (X)XXX011) WWTP Improvements
517-10300 Prosperity Bank Construction WWTP Improvements
519-10250 Texpool Revenue Bond Construction (XXXXX015) SWIFT
519-11155 Cash -Bond Escrow Bank of Texas (SWIFT)
520-10250 Texpool Revenue Bond Water & Waste Water Systems 2019 (XXXXX018)
520-11155 Cash -Bond Escrow Bank of Texas (Water & Waste Water Systems)
528-10250 TexPool Revenue Bond Reserve (XXXXX014) WWTP Improvements
533-10250 TexPool Tax I & S (XXXXX0003)
533-10300 Prosperity Bank (XXX8701) Tax I&S
534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements
535-10250 Texpool Revenue I & S (XXXXX017) SWIFT
536-10250 TexPool Revenue I & S (XXXXX020) Water & Waste Water Systems
Amount available in cash (MUD Accounts)
Amount available for spending (MUD Accounts)
*05/31/2020 Customer Water Deposits $315,760
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 (FY2020 Capital Projects plus prior year carry forward)
Unassigned Fund Balance
Current Year Revenue/Expenses
Total Nonspendable, Assigned & Committed Fund Balances - General Fund 135
149 of 150
June 15, 2020 Regular Meeting Agenda Packet
Restricted -
Unable to be spent
$0
$315,760
$1,604,892
$0
$0
$919,266
$504,533
$0
$0
$784,940
$418,569
$3,892,394
$893,308
$947,761
$0
$356,844
$175,649
$23,295
$10,837,212 1
$o
$0
Unrestricted -
Available for
spending
$3,577,659
$2,772,344
$0
$150
$450
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$6,350,603 1
$0 1
$6,350,603
$6,350,603
$895,282
$0
$895,282 l
$895,282
$895,282
Total in Accounts
(Restricted &
Unrestricted)
$3,577,659
$3,088,104
$1,604,892
$150
$450
$919,266
$504,533
$0
$0
$784,940
$418,569
$3,892,394
$893,308
$947,761
$0
$356,844
$175,649
$23,295
$17,187,815
General Fund 135 Available
2,772,344 Prosperity General Fund
3,577,659 Texpool General Fund
600 Petty Cash
6,350,603
3,486
2,072,098
6,325,800
103,999
$8,505,384
$895,282
$0
$895,282
A
11
150 of 150
June 15, 2020 Regular Meeting Agenda Packet c'
team