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