HomeMy WebLinkAbout2019-0217 February 17, 2020 Regular Meeting Agenda PacketMonday, February 17, 2020
Q
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
February 17, 2020 Regular Meeting Agenda Packet
BOARD OF DIRECTORS
REGULAR MEETING
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
100 MUNICIPAL DRIVE
TROPHY CLUB, TEXAS 76262
6:30 P.M. Svore Municipal Boardroom
REGULAR MEETING AGENDA PACKET
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. January 2020 Check Register
b. January 20, 2020 Regular Meeting Minutes
attachments: January 2020 Check Register
January 20, 2020 Regular Meeting Minutes
REGULAR SESSION
2. Consider and take appropriate action regarding approval of Fourth Amendment to Independent
Contractor Agreement with John Carman for Consulting Services.
attachment: Fourth Amendment to Independent Contractor Agreement
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.
attachment: DRAFT RFQ
1 of 155
February 17, 2020 Regular Meeting Agenda Packet
4. Presentation and discussion regarding hardness and turbidity in District water lines.
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.
attachment: Denton County Joint Election Agreement
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
attachment: Order No. 2020-0217A
7. Consider and take appropriate action regarding Fiscal Years 2020 — 2022 Audit Services:
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.
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.
attachment: DRAFT ILA
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.
attachment: CP&Y Proposal
10. Discuss and take appropriate action concerning Acting General Manager compensation. (Rose/Flynn)
11. Consider and take appropriate action regarding the January 2020 Combined Financials and Variance
Report.
a. Combined Financials
b. Combined Variance
attachments: Combined Financials
Combined Variance
2 of 155
February 17, 2020 Regular Meeting Agenda Packet
REPORTS & UPDATES
12. Receive report from General Manager Hiring Committee. (Castonguay/Flynn)
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
attachments: General Manager Report
Water Operations Report
Utility Billing Report
Permits Collected
Cash Report
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
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.
3 of 155
February 17, 2020 Regular Meeting Agenda Packet
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
REGULAR SESSION
17. Consider and take appropriate action on matters deliberated in Executive Session:
18. Items for future agendas:
19. Set future Meeting dates - Regular Board Meeting on March 16, 2020 at 6:30 p.m.
attachment: March 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 DISTRICTS PRIOR PRACTICE OF SPECIFICALLY IDENTIFYING ALL AGENDA ITEMS TO BE
DISCUSSED IN EXECUTIVE SESSION.
ADJOURN
4 of 155
apackamt2 skzolczyk
Begin Date: 01/01/2020 End Date: 01/31/2020
vendor vencor Name
Number
2651 Carman Consulting Lim.
2651 Carman Cknsulting LLC.
2651 Carman Cxansulting LLC.
Totals for Check: 6056
3156 OXIDOR 1AEOi2ATCRIES LLC
3156 CMIDOR LABORATORIBS LABORATORIESTIC
3156 OXIDOR LABORATORIES LLC
3156 OXIDOR LABOR/ IFS LLC
3156 O] DEX1 LABORATORIES LLC
Tbrw1s for Check: 6057
1001 TOWN OF TROPHY CLUB
Totals for Check: 6058
Fran Amt:
invoice Number Invoice ririr Dept ACCOUrit
Date Stat No Number
29
29
29
19120687
19120598
19120467
19120698
20010027
010120
1000 TROPHY CLUB ram (WATER RTf Ls) 12/31/2019
Totals for Check: 6059
998 AMRHEIN, SHANNON
Totals for Check: 6060
998 BURKHALTER, ADRIAN?.
Tbtals for Check: 6061
01/02/20 P
01/02/20 P
01/02/20 P
12/31/19 P
12/23/19 P
12/31/19 P
12/31/19 P
12/31/19 P
01/02/20 P
12/31/19 P
U0010080582109A 12/31/19 P
090123100579028 12/31/19 P
998 CENTURY RY 21 MICE BOWMAN, INC. 00 0 3 01114 6 12 03A 12/31/19 P
Totals for Check: 6062
998 CDSTELILW, JOEL
Totals for Check: 6063
998 mums CUSTOM Fri
Totals for Check: 6064
998 DREES CUSTOM HOMES
Totals for Check: 6065
998 ELY, SUSAN
Tbtals for Cheek: 6066
998 C3tCD uabaxur:aiuv, IIC.
Totals for Check: 6067
998 HIGH AMS OF TROPHY CLUB HOA
Tbtals for Check: 6068
998 ICS CCMERCIAL, L.P.
Totals for Check: 6069
09035120010901A 12/31/19 P
00017000021100A 12/31/19 P
00017000105100A 12/31/19 P
09048060057901A 12/31/19 P
U0511000105524A 12/31/19 P
U9029011006900A 12/31/19 P
U0511000095511A 12/31/19 P
30 135-55070-030-000
30 135-55070-030-000
30 135-60075-030-000
20 135-55135-020-000
20 135-55135-020-000
20 135-55135-020-000
20 135-55135-020-000
20 135-55135-020-000
Trophy club ram rb.1
AP Checks Fbr Date/Amount Range
.00 To Amt: 99,999,999.99
Description
Independent yahrm
Indzendent TAlrvr
Meetings
Tab Analysis
Lab Analysis
Tab Analysis
Lab Analysis
Tab Analysis
45 122-60337-045-000 Transfer to Tbman/Fire Budget
30 135-60025-030-000 Water
135-20050-000-000 A/P Vemdoss
135-20050-000-000 A/P Ve>Y3ors
135-20050-000-000 A/P Vendors
135-20050-000-000 A/P Vendors
135-20050-000-000 A/P Vaxkirs
135-20050-000-000 A/P Vendors
135-20050-000-000 A/P Vendors
135-20050-000-000 A/P Vendazs
135-20050-000-000 A/P Vendors
135-20050-000-000 A/P Vendors
5of155
0)110020y 10 :x®20 Regular Meeting Agenda Pfticet 1
Line item
Value
10,640.00
15.08
10.50
10,665.58
230.00
317.40
1,053.97
317.40
230.00
2,148.77
59,888.08
59,888.08
123.17
123.17
117.99
117.99
27.90
27.90
28.26
28.26
08.17
08.17
52.41
52.41
53.17
53.17
24.86
24.86
1,660.21
1,660.21
42.02
42.02
1,881.97
1,881.97
trieCR LrieCK
Number Date
6056 01/02/20
6056 01/02/20
6056 01/02/20
6057 01/02/20
6057 01/02/20
6057 01/02/20
6057 01/02/20
6057 01/02/20
6058 01/02/20
6059 01/02/20
6060 01/02/20
6061 01/02/20
6062 01/02/20
6063 01/02/20
6064 01/02/20
6065 01/02/20
6066 01/02/20
6067 01/02/20
6068 01/02/20
6069 01/02/20
apackamt2 skrolczyk
Begin Date: 01/01/2020 End Date: 01/31/2020
vendor vemar Aldine
Number
998 1CALTI'7 2v, COLTER
Totals for Check: 6070
998 KRAPES, ROBERT
Totals for Check: 6071
998 KRUK, DFPIATF
Totals for Check: 6072
998 OPEN HOUSE =CAS
Totals for Check: 6073
998 PECHAL, BOBBY
Totals for Check: 6074
998 PFra.rnn, IRIS L
Totals for Check: 6075
998 RAY-BRETHMER, MICHELE
Totals for Check: 6076
998 ROGERSON, DEBRA
Totals for Check: 6077
998 THE KNOLL H.O.A. INC.
Totals for Cheek: 6078
1001 TOWN OF TROPHY CLUB
Totals for Chheck: 6079
1001 WAN OF TROPHY CLUB
Totals for Check: 6080
2694 BladkmonMboring Company
Totals for Check: 6081
2497 DHS AUiCMATICN, INC
Totals for Check: 6082
1372 HACH COMPANY
Totals for Check: 6083
2667 HOLT CAT
Totals for Check: 6084
1834 IDE= 143...1.1,12 41.1..1,64, INu
1834 m520C DISSTRIBtYITCN, INC
Fran Amt:
Tivphy Club MUD N3.1
AP Checks Fcr Date/Amount Range
.00 To Amt: 99,999,999.99
Invoice Nurpex Invoice Inv Uept Account Description
Date Stat No Nunber
U00204500162097i. 12/31/19 P 135-20050-000-000 A/P Vendors
U0037000339101A 12/31/19 P 135-20050-000-000 A/P Vendors
U9035110003902A 12/31/19 P 135-20050-000-000 A/P Vectors
U0010080640105A 12/31/19 P 135-20050-000-000 A/P Vendors
U0050090707110A 12/31/19 P 135-20050-000-000 A/P Vendors
U0020540003201A 12/31/19 P 135-20050-000-000 A/P Vendors
U0023150021203A 12/31/19 P 135-20050-000-000 A/P Vendors
U0016010001104A 12/31/19 P 135-20050-000-000 A/P Vendors
U0035020002200A 12/31/19 P 135-20050-000-000 A/P Vendors
122319-A 12/31/19 P 122-43415-000-000 Denton County Pledge -Fire
123019-A 12/30/19 P 20 135-69005-020-000 Capital Outlays
1B112687 12/17/19 P 20 135-55080-020-000 Maintenance & Repairs
06-1934 01/01/20 P 20 135-55081-020-000 M inter & Repairs Collections
11776778 12/27/19 P 20 135-65045-020-000 lab Supplies
WLU/0031178 12/30/19 P 10 135-55105-010-000 Mainz *ce.-Backhoe/Skirmem
3058141891
3058141890
01/02/20 P
01/02/20 P
20 135-65045-020-000 Tab Supplies
20 135-65045-020-000 Lab Supplies
6 of 155
03081/20-y 1119:2020 Regular Meeting Agenda Deet 2
LIne ltetl tueCK tnneCK
Value Number Date
91.10 6070 01/02/20
91.10
26.48 6071 01/02/20
26.48
03.22 6072 01/02/20
03.22
11.73 6073 01/02/20
11.73
11.07 6074 01/02/20
11.07
04.06 6075 01/02/20
04.06
90.41 6076 01/02/20
90.41
06.32 6077 01/02/20
06.32
46.15 6078 01/02/20
46.15
10,000.00 6079 01/03/20
10,000.00
500.00 6080 01/03/20
500.00
4,388.28 6081 01/07/20
4,388.28
646.00 6082 01/07/20
646.00
372.55 6083 01/07/20
372.55
920.37 6084 01/07/20
920.37
458.66 6085 01/07/20
1,463.76 6085 01/07/20
apackamt2 skrolczyk
Begin Date: 01/01/2020 &d Date: 01/31/2020
Veneta VeY1Ct'+1' Nance
Number
1834 IDE OC DISTRIBUTION,
Tbtals for Check: 6085
2943 JPNO GAN CHASE BANK NA
'Lbtals for Check: 6086
3195 LOU'S GLOVES INOMPORATED
Totalq for Check: 6087
3168 IDBRICYiT2(N EN3INEERS, INC
Totals for Check: 6088
1001 TOWN OF TROPHY CLUB
1001 =MCP OF TROPHY CLUB
1001 =MOP TROPHY CURB
Totals for Check: 6089
Fran Amt:
1nvOeCe karma= invoice" .lSN Uept ACCOlnt
Date Stat No Number
3056622613
12262019
032310
1N412464
DEC mum
DEC REFUSE
EEC REFUSE
2634 'alley Solvent Ckmgany, INC 51094
Totals for Check: 6090
2698
2698
2698
2698
2698
Totals
Ritz Safety, LIC
Ritz Safety, TLC
Ritz Safety, LIC
Ritz Safety, LIC
Ritz Safety, ILC
for Check: 6091
1005 ATLAS UT1L/TY SUPPLY CO.
1005 ATLAS tiTILrrt SUPPLY CO.
1005 ATLAS UTILITY SUPPLY CO.
Totals for Check: 6092
2683 Charter Carm nications
Totals for Check: 6093
2655 Ooze & Main LP
2655 Clore & Main LP
Totals for Check: 6094
3193 CONPOPAY, INC.
Totals for Cbeok: 6095
3080 CP&Y/WALSACE GROUP, INC.
Totals for Check: 6096
3184 DATAPISE RSC
3184 DATAPROSE LIC
5824896
5829738
5861524
5861617
5865775
11/25/19 P
12/26/19 P
01/02/20 P
01/03/20 P
12/31/19 P
12/31/19 P
12/31/19 P
20 135-65045-020-000
135-20060-000-000
20 135-65045-020-000
20 135-55080-020-000
135-25040-000-000
135-25000-000-000
135-25010-000-000
12/31/19 P 20 135-65030-020-000
12/01/19 P 20
12/01/19 P 20
12/01/19 P 20
11/18/19 P 20
11/26/19 P 20
135-60090-020-000
135-60090-020-000
135-65040-020-000
135-65040-020-000
135-65040-020-000
12168 01/13/20 P 10 135-65050-010-000
011497A 01/13/20 P 10 135-65050-010-000
012089 01/09/20 P 10 135-65053-010-000
71672010620 01/06/20 P 30 135-55030-030-000
1652032 01/03/20 P 10 135-55080-010-000
L676828 01/03/20 P 20 135-55080-020-000
PR00687 996 01/10/20 P 135-21313-000-000
1600916.05-5 01/10/20 P 20 517-69005-020-000
DP1904482 12/31/19 P 30 135-60035-030-000
DP1904482 12/31/19 P 30 135-55205-030-000
Trophy Club tW No.1 Q 9/ y 198:2620 Regular Meeting Agenda Pmt 3
AP Checks Far Date/Amount Range
.00 To Amt: 99,999,999.99
uescriptial
lab Supplies
Procurement Clearing
Lab Supplies
Maintenance &
Tbwa-Stone Drainage
Refuse
Refuse Tax
Chemicals
Safety P dfl
Safety P10gta t
Safety Equipment
Safety Equilment
Safety Equipment
Meter &pease
Meter Expelse
Meter Change Out Program
Software & Support
Maintenance & Repairs
Maintenance & Repairs
Cafe 125 -Medical Reilrb
Capital Outlays
Postage
Utility Billing cb tract
7 of 155
Jane -"lten - tmec4 ";meCK
Value Reber Date
1,381.63 6085 01/07/20
3,306.05
12,829:65 6086 01/07/20
12,829.65
169.20 6087 01/07/20
169.20
366.09 6088 01/07/20
366.09
36,251.47
66,838.24
5,463.96
108,553,67
6089 01/07/20
6089 01/07/20
6089 01/07/20
569.00 6090 01/07/20
569:00
56.82
52.32
43.42:
183.20
683:18
1,018.94
6091
6091
6091
6091
6091
01/07/20
01/07/20
01/07/20
01/07/20
01/07/20
4,259:50 " 6092 01/20/20
2,970:00 -6092 01/20/20
36,900.00 6092 01/20/20
44,129.50
899.00 6093 01/20/20
899.00
464.00 6094 01/20/20
220.00 6094 01/20/20
684.00
549.37 6095 01/20/20
549.37
2,220.00 6096 01/20/20
2,220.00
158.50 6097 01/20/20
182.94 6097 01/20/20
apackamt2 slc olczyk
Begin Date: 01/01/2020 End Date: 01/31/2020
Venoor venoor Nene
NUmber
Totals for Check: 6097
2677 Digital Air Control, Inc
Totals for Check: 6098
2653 Dubois Bryant Canpbell LLP
Totals for check: 6099
3118 Exclusive Pest Control
Tbtals for check: 6100
2606 Fisery Solutions, LLC
Totals for Check: 6101
2635 Halff Associates, INC
2635 Halff Associates, INC
Totals for Check: 6102
1372 HACH COMPANY
Totals for Check: 6103
2775 HODSON ENERGY SERVICES, LIC
2775 HODSCN ENERGY SERVICES, LLC
Totals for Check: 6104
1834 IDEOCX DISfRIBi I'I 84, INC
1834 IDE70C DISIRIBUTICN, SNC
Totals for Check: 6105
3124 IRS Tax Payment
3124 IRS Tax Payment
3124 IRS Tax Payment
Totals for Check: 6106
1468 L.H. CW NEY MATPRIALS, INC.
1468 L.H. CHANEY MATERIALS, INC.
Totals for Check: 6107
3216 M3 Networks
Totals for C11e+.k: 6108
2643 Mclean & Howard, L.L.P.
2643 McLean & Howard, L.L.P.
Totals for Check: 6109
998 MCJO IICC EN SIGNATURE HOMES
Totals for Check: 6110
Fran Amt:
Invoice NUiner invoice Inv iiegt SCOW=
Date Stat No Nutter
2051044 01/10/20 P 30 135-60235-030-000
104044 01/16/20 P 20 517-69005-020-000
7384 12/18/19 P 30 135-55080-030-000
91635045 01/04/20 P 30 135-60040-030-000
10032459 01/09/20 P 30 135-55030-030-000
10032451 01/09/20 P 10 520-69005-010-000
11781258 01/02/20 P 10 135-65030-010-000
52001150001-31 01/15/20 P 10 135-60020-010-000
52001150001-31 01/15/20 P 20 135-60020-020-000
3058368367 01/08/20 P 20 135-65045-020-000
3058295136 01/06/20 P 20 135-65045-020-000
PR00687
PR00687
PR00687
996 01/10/20 P
996 01/10/20 P
996 01/10/20 P
135-21302-000-000
135-21303-000-000
135-21304-000-000
169006 01/04/20 P 20 135-55125-020-000
169441 01/11/20 P 20 135-55125-020-000
5802 01/15/20 P 30 135-55030-030-000
35712 12/31/19 P 39 135-55045-039-000
35711 12/31/19 P 39 135-55045-039-000
00511000109501A 01/10/20 P
135-20050-000-000
Trophy club MOD No.1
AP Checks For Date/Anoint Range
.00 Tb Amt: 99,999,999.99
Description
Security
Capital Outlays
Maintenance & Repairs
Service Charges & Pees
Software & Support
Capital Outlays
Chemicals
Electricity
Electricity
Lab Supplies
Lab Supplies
FVlsi Taxes
Social Security Taxes
Medicare Taxes
Dempster Services
Dempster Services
Software & Support
leSal
legal
A/P Vendors
8 of 155
d'u j y 104:2020 Regular Meeting Agenda Int 4
Line Item trieCK LTISOr
Value amber Date
341.44
24.00 6098 01/20/20
24.00
1,572.50 6099 01/20/20
1,572.50
110.00 6100 01/20/20
110.00
50.00 6101 01/20/20
50.00
9,952.61 6102 01/20/20
4,704.93 6102 01/20/20
14,657.54
977.77 6103 01/20/20
977.77
5,903.40 6104 01/20/20
12,728.09 6104 01/20/20
18,631.49
505.07 6105 01/20/20
229.33 6105 01/20/20
734.40
4,131.14 6106 01/20/20
5,433.84 6106 01/20/20
1,270.84 6106 01/20/20
10,835.82
2,573.62 6107 01/20/20
2,183.02 6107 01/20/20
4,756.64
494.00 6108 01/20/20
494.00
1,050.00 6109 01/20/20
2,430.00 6109 01/20/20
3,480.00
1,364.85 6110 01/20/20
1,364.85
apa.kaant2 skrolczyk
Begin Date: 01/01/2020 End Date: 01/31/2020
vex= venaor Name
N Mber
Frim Amt:
Invoice 1VtiS4Er Jnvo3c AIN Dept Account
Date Stat No Nur%er
1051 SL11CAN WBtL SERVICE, LLC 5696
Totals for Check: 6111
2983 NITA
Torek for Check: 6112
3156 =DOLABORATORIES LLC
3156 MDMI LA83RATO2I LLC
3156 0 CIDOR LABCBA1O LLC
3156 MOOR IABCRATCRIES ILC
Totals far Check: 6113
2703 RDO Equipment Co
Tbtals far Check: 6114
3176 REY-MAR u.muiavni,,sv
Totals for Bieck: 6115
01/16/20 P
01/05/2020 01/05/20 P
20010102 01/06/20 P
20010111 01/07/20 P
20010198 01/13/20 P
20010286 01/16/20 P
E11282 12/09/19 P
01/15/20 P
12/31/19 P
12/31/19 P
2440 TARRANT CIY PUBLIC HEALTH LAB 32943
2440 TARRANT CTY PUBLIC HEALTH LAB 32942
Tbtals for Check: 6116
3113 TCDRS
S
Totals for Check: 6117
PRO0687 996 01/10/20 P
12/31/19 P
6846041 01/07/20 P
010920 01/09/20 P
76575898 01/07/20 P
2696 Texas Ekcavatian Safety System 19-25407
Totals for Check: 6118
3282 TVA OY.4 8BCIAL FINANCE
E
Totals for Check: 6119
1001 TCFAN OF TROPHY CLUB
Totals for Check: 6120
1081 TRI COUNTY ELECTRIC
Totals far Check: 6121
2858 UTILITY SERVICE OD, INC.
2858 UTILITY SERVICE CO, INC.
Totals for Check: 6122
496290
497436
2634 Valley Solvent Carpany, INC 51611
Totals for Check: 6123
1058 VFRIZCN WII2IIESS
1058 VERUCKMIRELEBB
1058 V8BIZca WIRES
9845304374
9845304374
9845304374
12/18/19 P
01/01/20 P
01/14/20 P
01/01/20 P
01/01/20 P
01/01/20 P
10 135-69005-010-000
30 135-60100-030-000
20 135-55135-020-000
20 135-55135-020-000
20 135-55135-020-000
20 135-55135-020-000
20 135-55080-020-000
10 135-55080-010-000
10 135-55135-010-001
10 135-55135-010-000
135-21317-000-000
30 135-60040-030-000
30 135-69170-030-000
30 135-60020-030-000
20 135-60020-020-000
10 135-69281-010-000
10 135-69281-010-000
20 135-65030-020-000
10 135-60010-010-000
20 135-60010-020-000
30 135-60010-030-000
Trophy Club MUD No.1
AP Checks For Date/Amount Range
.00 Tb Amt: 99,999,999.99
Description
Capital Outlays
Travel & per diem
Lab Analysis
Lab Analysis
Lab Analysis
Lab Analysis
Maintenance & Repairs
Maintenance & Repairs
Lab Analysis for PID
lab Analysis
TCLIRS
Service Charges & Fees
Copier Lease Installments
Electricity/Gas
Electricity
Water Tank Inspection Contract
Water Tank Inspection Contract
Chemicals
Qamnmicatia s/Mobiles
Cs ran,ications/Mobiles
O nimications/&biles
9 of 155
(Wing:TY 1013:2020 Regular Meeting Agenda P,t¢Jeet 5
Lame Item
Value
(meek (meek
Number Date
58,645.00 6111 01/20/20
08.25 6112 01/20/20
317.40 6113 01/20/20
230.00 6113 01/20/20
341.55 6113 01/20/20
241.50 6113 01/20/20
1,130.45
9,900.00 6114 01/20/20
4,375.00 6115 01/20/20
80.00 6116 01/20/20
200.00 6116 01/20/20
280.00
58,645.00
08.25
9,900.00
4,375.00
7,488.50 6117 01/20/20
7,488.50
190.00 6118 01/20/20
165.00 6119 01/20/20
690.43 6120 01/20/20
624.40 6121 01/20/20
190.00
165.00
690.43
624.40
2,200.00 6122 01/20/20
41,944.38 6122 01/20/20
44,144.38
569.00 6123 01/20/20
424.30 6124 01/20/20
408.87 6124 01/20/20
87.75 6124 01/20/20
569.00
apackamt2 skrolczyk
Begin Date: 01/01/2020 End Date: 01/31/2020
ve cor Vencor Name
Nurber
Totals for Check: 6124
Frau Amt:
invoice runner Invoice Jnv Dept Account
Date Stat No Number
2196 VIcj.a 0 SCHINNERER & W, INC 1291775-035174 01/17/20 P
Totals for Check: 6125
1087 WHITAKER CHAIR SWINDLE
Totals for Check: 6126
2222 AFLAC
2222 AFLAC
Totals for Check: 6127
3197 BenefitMall
3197 BenefitMall
3197 BenefitMall
Totals for Check: 6128
1030 CITY OF FDIC % TH
1030 CITY OF FORT WORTH
Totals for Check: 6129
2655 Core & Main LP
2655 Care & Main LP
Totals for Check: 6130
3193 CCMPUPAY, INC.
Totals for Check: 6131
2497 DHS AIMMATICN, INC
2497 DHS AUICMATICN, INC
2497 LOS AUICMATICN, INC
Tbtals for Check: 6132
1737 DPC INDUSTRIES, INC
Totals for Check: 6133
1832 FIRST FINAMI AL BANK
1832 FIRST FIIVOZ,TAL BANK
1832 FIRST Ffl 1 TAL BANK
1832 FIRST F.QANCIAL BANK
1832 FIRST FIt N2IM. BANK
1832 FIRST FINANCIAL BANK
Totals for Check: 6134
3258 ERANCOTYP-FOSTALIA, INC.
Totals for Check: 6135
Trophy Club MUD No.1
AP Checks For Date/Amount Range
.00 To Amt: 99,999,999.99
30 135-60055-030-000 Insurance
255822 12/31/19 P 39 135-55045-039-000 legal
PR00687 996 01/10/20 P 135-21312-000-000 Aflac
9900688 996 01/24/20 P 135-21312-000-000 Aflac
9046576 -IN
9046576 -IN
9046576 -IN
01/24/20
01/30/20
01/16/20 P
01/16/20 P
01/16/20 P
10 135-50029-010-000
20 135-50029-020-000
30 135-50029-030-000
01/24/20 P 10 135-60150-010-000
01/30/20 P 135-20500-000-000
Life Insurance & Other
Life Insurance & Other
Life Insurance & Other
Wholesale Water
Fort W rth Water-Lipact
L766822 01/15/20 P 10 135-55080-010-000 Maintenance & Repaixs
L759040 01/13/20 P 20 135-55081-020-000 Maintea & Repairs Collections
PR00688 996 01/24/20 P
06-1945
06-1944
06-1942
01/22/20 P
01/17/20 P
01/17/20 P
135-21313-000-000
Cafe 125 -Medical Reirb
10 135-69005-010-000 Capital Outlays
10 135-55080-010-000 Maintenance & Repairs
20 135-55080-020-000 Maintenance & R�irs
7670000331-20 01/20/20 P 10 135-65030-010-000
01/17/20
01/17/20
01/17/2020
01/17/2020
01/17/2020
01/17/2020
01/17/20
01/17/20
01/17/20
01/17/20
01/17/20
01/17/20
P 20 135-69009-020-000
P 20 135-69008-020-000
P 10 135-69009-010-000
P 20 135-69009-020-000
P 10 135-69008-010-000
P 20 135-69008-020-000
82104336872 01/15/20 P 30 135-60035-030-000
Chemicals
Start Term Debt -Interest
Stmt Tern Debt -Principal
Snort Tern Debt -Interest
Short Tern Debt -Interest
Short Tenn Debt -Principal
Start Tern Debt -Principal
Postage
10 of 155
101420'y 11:74:2(120 Regular Meeting Agenda Pagjeet 6
£.ue Lten caeca - "tne:R
Value 1 i±ber Date
920.92
50.00 6125 01/20/20
50.00
6,198.50 6126 01/20/20
6,198.50
151.13 6127 01/30/20
210.67 6127 01/30/20
361:80
20.00
36.00
20.00
76.00
6128 01/30/20
6128 01/30/20
6128 01/30/20
118,562:59 6129 01/30/20
69,165.00 6129 01/30/20
187,727.59
100.00 " 6130 01/30/20
117.42 6130 01/30/20
217.42
549.37 6131 01/30/20
549.37
9,125.00.
1,965.30
765.00
11,855.30
6132 01/30/20
6132 01/30/20
6132 01/30/20
558.40 6133 01/30/20
558.40
3,681.96
19,158.74
1,840.00
2,440.07
30,512:00
40,446.00
98,078.77
6134
6134
6134
6134
6134
6134
01/30/20
01/30/20
01/30/20
01/30/20
01/30/20
01/30/20
105.96 6135 01/30/20
105.96
apackan t2 skrolczyk
Begin Date: 01/01/2020 End Date: 01/31/2020
Veno' venoor Mee
Weber
2676 Humana Inc
2676 Hratana Inc
2676 Humana Inc
2676 Humana Inc
2676 Humana Inc
2676 Humana Ina
Tbtals for Check: 6136
3124 IRS Tax Payment
3124 IRS Tax Payment
3124 IRS Tax Payment
Tbtals for Check: 6137
2735 Jackson. Walker LLP
Totals for therk: 6138
3167 REYSIC E PARK SECRETARIAL
Totals for Check: 6139
3278 KYOMA DOCUMENT SCUM=
Totals for Check: 6140
1468 L.H. C EMEW MATERIA1S, INC.
Totals for Check: 6141
3053 LAFOLLETT & COMPANY, PLLC
Totals for Check: 6142
3132 Legal Shield
3132 Legal Shield
Totals for Chedk: 6143
Invoice Nuttier invoice env
Date Stat
155516821 02/13/20 P
155516821 02/13/20 P
155516821 02/13/20 P
155516821 02/13/20 P
155516821 02/13/20 P
155516821 02/13/20 P
PR00688
PR00688
PR00688
996 01/24/20 P
996 01/24/20 P
996 01/24/20 P
1696113 01/23/20 P
159286 01/22/20 P
55R1724700 01/23/20 P
169592 01/18/20 P
01/21/20 01/21/20 P
1R00687 996 01/10/20 P
19.00688 996 01/24/20 P
3186 MEMBER'S maw= MATNIEMAN= 1C1912TOIOD
3186 ' S BUILD= MAIN FLAME TC19121=11
3186 MEMBER' EstrilDmv tikum2TAic2 7C19121 DD
Totals for Check: 6144
3115 ME;TLSEE GROUP BENEFITS
3115 MET= GROUP BENEFITS
3115 MEITSEE GROUP BENEFITS
3115 METUFE GRIP B8 EF1T5
Totals for Crick: 6145
1238 NORTH TEXAS R)9.' CO.
Totals for Check: 6146
1056 OFFICE DEEOr, INC
2/15/2020
2/15/2020
2/15/2020
2/15/2020
14383
12/31/19 P
12/31/19 P
12/31/19 P
02/15/20
02/15/20
02/15/20
02/15/20
Fruu Pmt:
Dept scrota=
No Number
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
135-21302-000-000
135-21303-000-000
135-21304-000-000
10 135-69005-010-000
30 135-60005-030-000
30 135-69170-030-000
20 135-55125-020-000
39 135-55055-039-000
135-21310-000-000
135-21310-000-000
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
01/20/20 P
429772551001 01/16/20 P
20 135-55080-020-000
30 135-65085-030-000
Trc by Club MUD No.1
AP Checks For Date/Airuimt Range
.00 TO Amt: 99,999,999.99
Description
Dental
Vision
Voluntary Life
Life Insurance & Other
Life Insurance & Other
Life Insurance & Other
MAA Taxes
Social Security Tis
Mefiicare Taxes
Capital Outlays
Copier T.P.Ang. Installments
arrester Services
Auditing
Legal Plan.
Legal Plan
Cleaning Services
es
Cleaning Services
Cleaning Services
Short Term Disability
Life Insurance & Other
Life insurance & Other
Life Insurance & Other
Maintenance & Repairs
Office Supplies
11 of 155
ot20bz(EBry 13;2/020 Regular Meeting Agenda FPagget 7
Dine Item One= isle=
Value Nimber Date
1,503.31
206.49
318.36
176.88
198.33
176.22
2,579.59
4,258.33
5,476.60.
1,280.82
11,015.75
6136
6136
6136
6136
6136
6136
6137
6137
6137
01/30/20
01/30/20
01/30/20
01/30/20
01/30/20
01/30/20
01/30/20
01/30/20
01/30/20
7,452.00 6138 01/30/20
194.75 6139 01/30/20
76.68 6140 01/30/20
2,505.42 6141 01/30/20
2,505.42
12,563.27 6142 01/30/20
7,452.00
194.75
76.68
12,563.27
17.46 6143 01/30/20
17.44 6143 01/30/20
34.90
87.50
869.06
87.50
1,044.06
74.36
132.01
165.74
151.69.
523.80
6144 01/30/20
6144 01/30/20
6144 01/30/20
6145 01/30/20
6145 01/30/20
6145 01/30/20
6145 01/30/20
1,150.00 6146 01/30/20
1,150.00
161.83 6147 01/30/20
apackamt2 skrolczyk
Begin Date: 01/01/2020 End Date: 01/31/2020
venoor venom tine
Number
Totals for Check: 6147
3156 =DOR LAB)RATtRIES LLC
3156 CNIDOR LABORATORIES LLC
Totals for Check: 6148
3176 REY-MAR lxavoucu uJ
Totals for Check: 6149
999 Sandra Stiltner
Totals for Check: 6150
2736 Stuart Hose & Pipe
2736 Stuart Hose & Pipe
Totals for Check: 6151
3113 TCDRS
Totals for Check: 6152
3123 Te)ms Tbllcamays/T5[&1g
Totals for Check: 6153
Fran Amt:
D1vo .ce NtXTh er invoice Inv Dept Account
Date Stat No Number
20010372
20010424
02
01/30/20
52001702911
SI001702891
01/20/20 P
01/22/20 P
01/28/20 P
01/30/20 P
01/24/20 P
01/24/20 P
2900688 996 01/24/20 P
01/10/2020 01/10/20 P
01/31/20 P
1973 TX C7C ISSICP7 ENVIROMENIAL CXJ 7250002077
Totals for Check: 6154
3225 US Bank Voyager Fleet Systems 869338111004
3225 US Bank Voyager Fleet Systems 869338111004
Totals for Check: 6155
2634 Valley Solvent Oam4,any, INC 51846
Totals for Check: 6156
2943 JP443RGAN (BASE BANK NA
2943 JPMORGAN CHASE BANK NA
Totals for Check: 6157
Grand Totals:
****** Ehd of Report *********
01/26/2020
01272020
01/24/20 P
01/24/20 P
20 135-55135-020-000
20 135-55135-020-000
20 135-69005-020-000
20 135-55080-020-000
20 135-69005-020-000
20 135-69005-020-000
135-21317-000-000
20 135-60100-020-000
10 135-60135-010-000
10 135-65005-010-000
20 135-65005-020-000
Trophy Club MOD NO.1 er209Vgary x,:2920 Regular Meeting Agenda flet 8
AP Checks For Date/Amxmt Range
.00 To Amt: 99,999,999.99
Description
Lab Analysis
Lab Analysis
Capital Outlays
Maintenance & Repairs
Capital Outlays
Capital Outlays
Travel & per diem
TCI Fees & Permits
Et:el & Lute
E1eel & Lam
01/20/20 P 20 135-65030-020-000 Chemicals
01/26/20 P
01/27/20 P
135-20060-000-000 Procurement Clearing
135-20060-000-000 Procurement Clearing
12 of 155
JnnP item (],ecK merit
Value Number Date
161:83
341.55 6148 01/30/20
241.50 6148 01/30/20
583.05
50,394.70 6149 01/30/20
50,394.70
459.00 6150 01/30/20
459.00
187.41 6151 01/30/20
1,074.13 6151 01/30/20
1,261.54
7,666.92 6152 01/30/20
7,666.92
04.13 6153 01/30/20
04.13
50.00 6154 01/30/20
50.00
1,140.42 6155 01/30/20
625.22 6155 01/30/20
1,765:64
717.50 6156 01/30/20
717.50
4,078.66 6157 01/30/20
542.43 6157 01/30/20
4,621.09
868,901.28
February 17, 2020 Regular Meeting Agenda Packet
REGULAR MEETING MINUTES
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
BOARD OF DIRECTORS
JANUARY 20, 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 Monday, January 20, 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:
John Carman
Laurie Slaght
Mike McMahon
Steven Krolczyk
Frank Isola
Tony Corbett
President
Vice President
Secretary/Treasurer
Director
Director
General Manager
District Secretary
Operations Manager
Finance Manager
Wastewater Superintendent
Legal Counsel
GUESTS PRESENT:
Susan LaFollett with LaFollett & Company, PLLC.
CALL TO ORDER AND ANNOUNCE A QUORUM
President Wilson announced the date of January 20, 2020, stated a quorum was present and called the
meeting to order at 6:30 p.m.
CITIZEN COMMENTS
Brock Harwell 55 Sonora Drive (Agenda Item #2)
CONSENT AGENDA
1. Consider and take appropriate action to approve the Consent Agenda.
a.
b.
c.
d.
December 2019 Check Register
December 16, 2019 Regular Meeting Minutes
Quarterly Investment Report — 15t Quarter FY2020
Tax Collections Report — 1' Quarter FY2020
Motion made by Director Flynn and seconded by Director Chapman to approve the Consent Agenda.
Motion carried unanimously
13 of 155
February 17, 2020 Regular Meeting Agenda Packet
REGULAR SESSION
2. Discussion and possible action regarding sewer line break at 55 Sonora Drive and request for District
payment for related repairs and damages.
General Manager John Carman provided a timeline of events that occurred at 55 Sonora Drive as well as
a video showing the line.
Mr. Brock Harwell who resides at 55 Sonora Drive stated that he had 3 plumbers to his home to look at
the line and they all stated the line break was on the District side.
Discussion ensued regarding the location of the line dislocation and the most cost effective way to make
that determination.
Attorney Corbett would like to discuss the legal implications related to this matter with the Board in
Executive Session.
The General Manager will follow up with the homeowners following the meeting.
This item is Tabled for further discussion in Executive Session. **
3. Receive update from the Audit Committee. (Rose/Wilson)
Director Rose and Director Wilson met with the auditor and reviewed the report and the adjustments
made to the audit.
4. Consider and take appropriate action to accept the Fiscal Year 2019 Annual Financial Audit performed
by LaFollet & Company, PLLC.
Susan LaFollett with LaFollett & Company, PLLC., provided the findings of the 2019 audit. The District
received an Unmodified Audit Opinion "Clean Audit" and no deficiencies or material weaknesses were
noted. The audit identified no material misstatements and found no unexplainable transactions. There
were 6 audit adjustments made. The only material adjustments identified by the audit firm related to
the new debt and pension balances. Ms. LaFollet stated that Finance Manager, Steven Krolczyk and the
Finance Department as well as the Audit Committee did a great job.
The Board commended staff for their work.
Motion made by Director Flynn and seconded by Director Rose to accept the Fiscal Year 2019 Annual
Financial Audit performed by LaFollet & Company, PLLC.
Motion carried unanimously
5. Consider and take appropriate action to approve Contract No. 2020012001 with Rey -Mar Construction
for construction of a building and installation of a sound mitigation improvements at the wastewater
treatment plant.
14 of 155
February 17, 2020 Regular Meeting Agenda Packet
Motion made by Director Rose and seconded by Director Flynn to approve Contract No. 2020012001 with
Rey -Mar Construction for construction of a building and installation of a sound mitigation improvements
at the wastewater treatment plant for an amount not to exceed $75,000 and authorize the general
manager to make necessary actions required for this project
Motion to amend by Director Rose and seconded by Director Flynn to fund the project out of
undesignated reserve funds.
Amendment withdrawn by the first and the second
Motion to amend the made by Director Rose and seconded by Director Flynn to fund the project out of
contributions to funds that are going to the reserve fund.
Motion to approve the amendment carried unanimously
Motion as amended carried unanimously
6. Consider and take appropriate action regarding approval of bid and award Contract No. 2020012002 for
20 inch Valve Replacement to include Line Stop at Trophy Club Drive and Oak Hill Drive as part of Fiscal
Year 2020 Capital Improvement projects.
Motion made by Director Rose and seconded by Director Chapman to award Contract No. 2020012002 to
Rey -Mar Construction for 20 inch Valve Replacement to include Line Stop at Trophy Club Drive and Oak
Hill Drive for an amount not to exceed $69,874.48 and to fund the project out of Fiscal Year 2020 Capital
Improvements and authorize the General Manager to execute necessary documents.
Motion carried unanimously
7. Consider and take appropriate action regarding approval of change orders submitted by Rey -Mar
Construction for the High Service Pump Station project:
a. Change Order #2 Lower short circuit rating pump 1 $28,716.45
b. Change Order #4 32" OD Flange Leveling $9,285.53
Mike McMahon, Operations Manager stated that Change Order #2 would be brought back to the Board
for consideration as a FY 2021 Capital Improvement Project and asked the Board to consider Change
Order #4 at this time.
Motion made by Director Chapman and seconded by Director Flynn to approve Change Order #4 submitted
by Rey -Mar Construction for the High Service Pump Station project 32" OD Flange Leveling for an amount
not to exceed $9,285.53 and to fund the projected out of allocated reserve funds.
Motion carried unanimously
Board Recessed from 7:53 p.m. to 7:57 p.m.
15 of 155
February 17, 2020 Regular Meeting Agenda Packet
8. Discussion and Action Regarding Adoption of Resolution 2020-0120A Authorizing the Acquisition of Real
Property by Purchase or Condemnation, including Consideration of the Use of Eminent Domain to
Condemn Property, and Containing Other Matters Related Thereto, for Purposes of Acquiring Easements
Required for the Construction and Operation of Water Transmission Line Improvements from the District
Pump Station to the Elevated Water Tank Located on T.W. King Road. Trophy Club Municipal Utility
District No. 1 (the "District") must acquire certain parcels, easements and/or related property interests
from real estate in Trophy Club, Denton and Tarrant County, Texas in connection with the construction
and operation of new public water transmission lines. If, for any reason, a negotiation to acquire a parcel
reaches an impasse, the District intends to use its power of eminent domain to condemn the following
property:
a. Parcel 2(a), an easement taking of 0.0054 acres, from 0.0793 acres of real estate, owned by the
County of Denton, Trustee, and located along the southern line of Indian Creek Drive, just east of
Troon Drive, Denton County, Texas;
b. Parcel 2(b), an easement taking of 0.0695 acres, from 0.43 acres of real estate, owned by Citibank,
N.A., and located northeast of the intersection of Davis Blvd and the north frontage road of State
Highway 114, Tarrant County, Texas; and
c. Parcel 6, an easement taking of 0.0693 acres, from 2.925 acres of real estate, owned by Trophy
Lodging, Ltd., and located at 2900 State Highway 114, Trophy Club, TX 76262, Tarrant County, Texas.
Motion made by Director Chapman and seconded by Director Rose to move that the Board of Directors of
Trophy Club Municipal Utility District Number 1, authorize the use of the power of eminent domain to
acquire an easement interest in the following properties located in Trophy Club, Tarrant and Denton
County, Texas:
• Parcel 2(a), an easement taking of 0.0054 acres, from 0.0793 acres of real estate, owned by the County
of Denton, Trustee, and located along the southern line of Indian Creek Drive, just east of Troon Drive,
Denton County, Texas;
• Parcel 2(b), an easement taking of 0.0695 acres, from 0.43 acres of real estate, owned by Citibank, N.A.,
and located northeast of the intersection of Davis Blvd and the north frontage road of State Highway
114, Tarrant County, Texas; and
• Parcel 6, an easement taking of 0.0693 acres, from 2.925 acres of real estate, owned by Trophy Lodging,
Ltd., and located at 2900 State Highway 114, Trophy Club, Texas 76262, Tarrant County, Texas;
with each aforementioned parcel being necessary for the construction, operation, and maintenance of
water lines from the district Pump Station to the Elevated Water Tank located on T.W. King Road.
My motion includes approval of the proposed Resolution 2020-0120A, and the first record vote on this
matter applies to all units of property to be condemned.
Motion carried unanimously
9. Consider and take appropriate action to approve matters related to May 2, 2020 General Election:
a. Adopt Order No. 2020-0120A calling the May 2, 2020 General Election
b. Approve Notice of Appointment of Agent
16 of 155
February 17, 2020 Regular Meeting Agenda Packet
c. Authorize General Manager to sign and execute all necessary documents relating to the election
d. Adopt Resolution No. 2020-0120B adopting the new Hart Verity Voting System for District Elections
conducted in Tarrant County, Texas
e. Authorize other necessary actions as may be necessary or convenient for conducting the May 2, 2020
General Election
Motion made by Director Rose and seconded by Director Castonguay to Adopt Order No. 2020-0120A
calling the May 2, 2020 General Election; Approve Notice of Appointment of Agent; Authorize General
Manager to sign and execute all necessary documents relating to the election; Adopt Resolution No. 2020-
0120B adopting the new Hart Verity Voting System for District Elections conducted in Tarrant County,
Texas; and Authorize other necessary actions as may be necessary or convenient for conducting the May
2, 2020 General Election
Motion carried unanimously
10. Discussion and possible action regarding the assignment of undesignated reserve funds.
Steven Krolczyk, Finance Manager reviewed current reserve funds. The Finance Manager will bring back
updated information on reserve allocations in April for Board action.
11. Consider and take appropriate action regarding the December 2019 Combined Financials and Variance
Report.
a. Combined Financials
b. Combined Variance
Motion made by Director Flynn and seconded by Director Chapman to approve the December 2019
Combined Financials and Combined Variance Reports.
Motion carried unanimously
12. Discussion and possible action regarding approval of Third Amendment to Independent Contractor
Agreement with John Carman for General Manager services relating to compensation. (Chapman)
The Board would like to have Carman turn over the day to day obligations of the District to staff and for
him to take on a limited scope of duties. (Litigation, Completion of the wastewater treatment plant,
Computerized Maintenance Management Software "CMMS", and GIS)
Carman stated that Mike McMahon, Operations Manager is the Acting General Manager in his absence.
Attorney Corbett will write up a new employment agreement for Carman as a separate agreement for
the next meeting.
Motion made by Director Chapman and seconded by Director Flynn to approval of Third Amendment to
17 of 155
February 17, 2020 Regular Meeting Agenda Packet
Independent Contractor Agreement with John Carman for General Manager services relating to
compensation.
Motion carried unanimously
13. Discussion and possible action regarding search for General Manager candidates. (Castonguay/Flynn)
a. Receive report from General Manager Hiring Committee.
b. Review and approval of candidate search materials to be utilized by executive search firm.
c. Other action related thereto.
Director Flynn asked the Board to review the documents that were prepared by SGR and send their edits
to the District Secretary by end of day on Tuesday, January 21, 2020. The final edits will then be
documented and sent to SGR for publication.
REPORTS & UPDATES
14. General Manager Monthly Reports and Update:
a. Regulatory Update
b. Capital Improvement Projects
• Interconnect Water Transmission Line Phase 2
• Wastewater Treatment Plant Upgrade Project
• High Service Pump
c. System Repairs & Maintenance
d. Water System Operations
e. Wastewater System Operations
f. Finance Update
• Utility Billing Report
• Permits Collected
• Cash Report
Finance Software Update
g.
General Manager John Carman presented his monthly reports to the Board and answered questions
related thereto.
The Board convened into Executive Session at 9:04 p.m.
EXECUTIVE SESSION
15. 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).
18 of 155
February 17, 2020 Regular Meeting Agenda Packet
c. Potential Condemnation of Easements required for construction and operation of Water
Transmission Line Improvements from District Pump Station to Elevated Water Tank located on T.W.
King Road
d. Discussion and possible action regarding sewer line break at 55 Sonora Drive and request for
District payment for related repairs and damages**
16. 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
17. Pursuant to Section 551.074 of the Texas Government Code (Texas Open Meetings Act), the Board of
Directors may deliberate the employment of a new General Manager.
The Board reconvened into Regular Session at 10:00 P.M.
REGULAR SESSION
18. Consider and take appropriate action on matters deliberated in Executive Session:
No final actions, deliberations, decisions or votes were made in Executive Session
19. Items for future agendas:
Presentation regarding Hard Water & Sedimentation in District water and does the MUD have a plan
regarding addressing it and solutions for it. (Rose)
20. Set future Meeting dates - Regular Board Meeting on February 17, 2020 at 6:30 p.m.
ADJOURN
President Wilson called the meeting adjourned at 10:04 p.m.
Gregory Wilson, President
Steve Flynn, Secretary/Treasurer
Laurie Slaght, District Secretary
19 of 155
(SEAL)
February 17, 2020 Regular Meeting Agenda Packet
FOURTH AMENDMENT TO
INDEPENDENT CONTRACTOR AGREEMENT
This Fourth Amendment to Independent Contractor Agreement ("Amendment") is entered
into between Trophy Club Municipal Utility District No. 1 (the "District") and John Robert
Carman ("Contractor") as of the 5th day of February, 2020 (the "Effective Date"). The District
and Contractor are collectively referred to as the "Parties" under this Agreement.
Recitals
WHEREAS, the District and Contractor entered into that certain "Independent Contractor
Agreement" effective August 1, 2017 (the "Agreement") setting forth the terms and conditions
pursuant to which the Contractor agreed to provide certain services as general manager for the
District under an independent contractor relationship; and
WHEREAS, the Parties entered into that certain "First Amendment to Independent
Contractor Agreement" effective September 28, 2017 (the "First Amendment") in order to amend
certain authority of the Contractor under the Agreement; entered into that certain "Second
Amendment to Independent Contractor Agreement" effective August 1, 2018 in order to amend
provisions relating to the compensation payable to the Contractor and reimbursement of expenses
for authorized services (the "Second Amendment"); and entered into that certain "Third
Amendment to Independent Contractor Agreement effective January 20, 2020 (the "Third
Amendment") in order to further revise the compensation provisions of the Agreement; and
WHEREAS, Contractor has advised the District that he intends to terminate services under
the Agreement, and the District has commenced a search for retaining a new General Manager;
WHEREAS, the District has appointed Mike McMahon ("Acting General Manager") as
the Acting General Manager of the District; and
WHEREAS, the Parties desire to amend the Agreement, as previously amended, in order
to amend the scope of services to be provided by Contractor to provide for the transition of General
Manager services from Contractor to the Acting General Manager and his successors.
NOW, THEREFORE, in consideration of the following terms, covenants, and conditions
contained herein, the sufficiency of which are hereby acknowledged, the District and Contractor
agree as follows:
Section 1. Scope of Services. Article I of the Agreement, as previously amended, is hereby
deleted and replaced in its entirety with the following:
"Section 1.1 Engagement of Independent Contractor. The District hereby engages
Contractor to provide the consulting services more particularly described in Exhibit "A"
attached hereto (the "Services"). The Services shall be performed only on an as -needed
basis and as requested by the Acting General Manager or other authorized representatives
of the District from time to time. Contractor acknowledges and agrees that this Agreement
20 of 155
February 17, 2020 Regular Meeting Agenda Packet
is non-exclusive, and that the District may utilize the services of its employees or other
consultants to provide some or all of the same services to be rendered by Contractor."
Section 2. Capitalized Terms. Except as specifically defined herein, all capitalized terms in
this Amendment shall have the meanings set forth in the Agreement, as previously amended.
Section 3. Effect on Agreement. Except as specifically modified by this Amendment, all
terms and conditions of the Agreement, as previously amended, shall remain in full force and
effect.
IN WITNESS WHEREOF, the Parties hereto have caused this instrument to be signed,
sealed and attested in duplicate by their duly authorized officers, as of the Effective Date.
Lu
Secretary
TROPHY CLUB MUNICIPAL UTILITY
DISTRICT NO. 1
By:
Name:
Title:
Gregory Wilson
President, Board of Directors
Date: 07 jc b aDa-Z
CONTRACTOR:
n Robert Carman
Date: 2. z6'2_v
21 of 155
February 17, 2020 Regular Meeting Agenda Packet
Exhibit "A"
Scope of Services
General: Contractor shall no longer serve as the General Manager of the District, shall not have
any of the powers, duties or authority of the General Manager under the rules and policies of the
District, and the Acting General Manager of the District shall assume all such duties, authority and
responsibilities in lieu of Contractor. Contractor shall provide general consulting services to the
District regarding the following matters on an as -needed and requested basis (the "Services"):
1. Completion of the District's wastewater treatment plant improvement project and
resolution of all outstanding contractual disputes with the project contractor;
2. Litigation support to the District, including providing testimony as requested by the
District's litigation counsel or Acting General Manager, with respect to the following
proceeding: 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);
3. Support to the District's condemnation counsel in connection with waterline
easement acquisition;
4. Implementation of the District's Computer Maintenance Management System
(CMMS) as requested by the Acting General Manager;
5. Implementation of the District's GIS mapping system as requested by the Acting
General Manager;
6. Finalize and advertise a Request for Proposal for a Master Plan; and
7. Other tasks as may be requested by the Acting General Manager or Board of
Directors, and accepted by Contractor, from time to time.
Meetings: Subject to availability, Contractor shall attend future meetings of the Board of Directors
on an as -requested basis.
Attendance at Administrative Office: Contractor shall no longer be required to come to the
District's administrative office to provide Services except as requested by the Acting General
Manager or required for the Services.
Management of Services and Compensation: To the maximum extent practicable, Contractor
shall communicate the anticipated hours of individual tasks to, and receive approval from, the
Acting General Manager in advance of performance of authorized Services to manage costs of the
District.
3
22 of 155
February 17, 2020 Regular Meeting Agenda Packet
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
REQUEST FOR QUALIFICATIONS
WATER, WASTEWATER, AND FACILITY MASTER PLANNING AND RISK AND
RESILIENCY ASSESSMENT
Trophy Club Municipal Utility District No. 1 requests statements of qualification from consultants
for the purpose of updating their Water Master Plan, developing their Wastewater Collection and
Facility Master Plans, as well as a Risk and Resiliency Assessment in conformance with the
American Water Infrastructure Act of 2018.
Kev Proiect Tasks
Water, Wastewater, and Facilities Master Plan:
• Review of existing reports including
associated Capital Improvements Plans
• Perform temporary wastewater flow
• Perform fire flow testing
• Evaluate wholesale water p
• Evaluate commercial a
• Evaluate existing waste
plan update
• Develop, cali► e, and hyo. lic m
deficiencies
• Perform an asses e wastewater treatment facility
• Perform an assessme . d pump performance testing on lift station facilities
• Perform an assessment and pump performance testing on pump station facilities
• Recommend CIP for the next 20 years in five-year increments
tewater, and Facilities Plans and
oundwater production data
er water usage and billing data
hat have been developed since the last master
odel simulations to evaluate existing and future
Risk and Resiliency Assessment:
• Review of existing District policies, condition assessment(s) and emergency response
plan(s)
• Conduct a Risk and Resiliency Assessment (RRA) per AWWA J100 standards
• Aid District in certifying RRA to the Environmental Protection Agency (EPA)
• Perform Emergency Response Plan (ERP) updates in conformance with the RRA
• Aid District in certifying ERP to the EPA 6 months after RRA submittal
23 of 155
February 17, 2020 Regular Meeting Agenda Packet
GENERAL QUALIFICATION REQUIREMENTS:
All submissions in response to this RFQ should comply with the requirements as described herein,
and shall include the following items:
• Packet Submittal: Firms must submit a qualification packet meeting the requirements
contained herein. The submittal packet shall be no more than twenty (81/2" x 11") pages in
length, and shall introduce the project team, detail the applicable experience of the firm,
team, and sub -consultants and how that experience will benefit Trophy Club Municipal
Utility District No. 1 on the identified project, provide applicable references, and provide
a project schedule. Transmittal letters (not counted as one of the twenty pages), if desired,
shall not exceed one page. Required resumes (See Proiect Team and Key Professional
Member Resumes below) are also required. Hard covers, binders and brochures are
discouraged. Each submittal shall include eight copies of e qualification packet for the
identified project plus one electronic copy addressed to.
Greg Wilson, Board President
Attn: Laurie Slaght, District Secretary
Trophy Club Municipal Utility Distr
100 Municipal Drive, Trophy Club,
lslaght@tcmud.org
RFQs should be sealed in envelope m
submission of written propos. unles
2020 at 4:00 p.m. Deliver s ld b
received after this date
Once the plannin
the final scope
is anticipate
o. 1
ASTERPLAN'. The deadline for
ise tated in the RFQ) is Friday March 20,
ade to the address shown above. Submittals
on -responsive.
ted by the Board of Directors, the District plans to negotiate
orporate that fee into the FY2021 budgeting process. It
wi .egin on October 1, 2020
o Proiect Te. an. ev Professional Member Resumes: Provide an organization
chart showin_ ' members listed by name and responsibility. Resumes of key
personnel of the project team and their respective backgrounds, experience, and
project responsibilities must be provided. Professional member resumes (not to
exceed 2 pages per person) may be attached as an appendix (not to exceed 25 pages
in addition to the 20 -page submittal packet).
o Proiect Understanding and Approach: The proposal shall establish the objectives
for the Project and contain a description of the Consultant's project management
and technical approach to meet these objectives.
o Experience with Related Studies and References: Provide a record of three studies
similar in size and scope to this project and completed within the past ten years in
the State of Texas. Each referenced project shall include names, telephone numbers,
and emails of responsible individuals who may be contacted as references.
24 of 155
February 17, 2020 Regular Meeting Agenda Packet
o Conflict of Interest Disclosure Requirement: Pursuant to Chapter 176 of the Local
Government Code, any person or agent of a person who contracts or seeks to
contract for the sale or purchase of property, goods, or services with a local
governmental entity (i.e. Trophy Club Municipal Utility District No. 1) must
disclose in the Questionnaire Form CIQ included in Appendix "A"
("Questionnaire") the person's affiliation or business relationship that might cause
a conflict of interest with the local governmental entity. By law, the Questionnaire
must be filed with the District Secretary no later than seven days after the date the
person begins contract discussions or negotiations with the District, or submits an
application or response to a request for proposals or bids, correspondence, or
another writing related to a potential agreement with the District. Updated
Questionnaires must be filed with the District Secretary in conformance with
Chapter 176. The form is also available at
https://www.ethics.state.tx.us/data/forms/confli IO.ndf. If you have any
questions about compliance, please consult your 'n legal counsel. Compliance is
the individual responsibility of each person • = of a person who is subject to
the filing requirement. An offense under Ji. pter s a Class C misdemeanor.
FURTHER INFORMATION:
All interested firms desiring any further in
an e-mail to lslaghtatcmud.org with subj
Additional Information" to guarant eceip
addendums. For information or io one
email or phone at 682-831-460
ums or Clarifications, should send
ASTERPLAN Request for any
dditi • nal information, clarifications and/or
ng the RFQ process, contact Laurie Slaght by
25 of 155
February 17, 2020 Regular Meeting Agenda Packet
THE STATE OF TEXAS COUNTY OF DENTON
JOINT ELECTION AGREEMENT AND CONTRACT FOR ELECTION SERVICES
This CONTRACT for election services is made by and between the Denton County Elections
Administrator and the following political subdivisions, herein referred to as "participating
authority or participating authorities" located entirely or partially inside the boundaries of
Denton County:
Participating Authorities:
[entities]
This contract is made pursuant to Texas Election Code Sections 31.092 and 271.002 and Texas
Education Code Section 11.0581 for a joint [election -date] election to be administered by Frank
Phillips, Denton County Elections Administrator, hereinafter referred to as "Elections
Administrator."
RECITALS
Each participating authority listed above plans to hold a General or Special Election on May 2,
2020. Denton County plans to hold county -wide voting for this General Election.
The County owns the Hart InterCivic Verity Voting System, which has been duly approved by
the Secretary of State pursuant to Texas Election Code Chapter 122 as amended and is compliant
with the accessibility requirements for persons with disabilities set forth by Texas Election Code
Section 61.012. The contracting political subdivisions (participating authorities) desire to use the
County's voting system and to compensate the County for such use and to share in certain other
expenses connected with joint elections, in accordance with the applicable provisions of
Chapters 31 and 271 of the Texas Election Code, as amended.
NOW THEREFORE, in consideration of the mutual covenants, agreements, and benefits to
all parties, IT IS AGREED as follows:
I. ADMINISTRATION
The participating authorities agree to hold a "Joint Election" with Denton County and each other
in accordance with Chapter 271 of the Texas Election Code and this agreement. The Elections
Administrator shall coordinate, supervise, and handle all aspects of administering the Joint
Election as provided in this agreement. Each participating authority agrees to pay the Elections
Administrator for equipment, supplies, services, and administrative costs as provided in this
agreement. The Elections Administrator shall serve as the administrator for the Joint Election;
however, each participating authority shall remain responsible for the decisions and actions of its
officers necessary for the lawful conduct of its election. The Elections Administrator shall
provide advisory services in connection with decisions to be made and actions to be taken by the
officers of each participating authority as necessary.
26 of 155
February 17, 2020 Regular Meeting Agenda Packet
It is understood that other political subdivisions may wish to participate in the use of the
County's Verity voting system and polling places, and it is agreed that the Elections
Administrator may enter into other contracts for election services for those purposes, on
terms and conditions generally similar to those set forth in this contract. In such cases, costs shall
be pro -rated among the participants according to Section XI of this contract.
II. LEGAL DOCUMENTS
Each participating authority shall be responsible for the preparation, adoption, and publication of
all required election orders, resolutions, notices, and any other pertinent documents required by
the Texas Election Code and/or the participating authority's governing body, charter, or
ordinances, except that the Elections Administrator shall be responsible for the preparation and
publication of all voting equipment testing notices that are required by the Texas Election Code.
Election orders should include language that would not necessitate amending the order if any of
the Early Voting and/or Election Day polling places change.
Preparation of the necessary materials for notices and the official ballot shall be the
responsibility of each participating authority, including translation to languages other than
English. Each participating authority shall provide a copy of their respective election orders and
notices to the Elections Administrator.
III. VOTING LOCATIONS
The Elections Administrator shall select and arrange for the use of and payment for all Early
Voting and Election Day voting locations. Voting locations will be, whenever possible, the usual
voting location for each election precinct in elections conducted by each participating authority,
and shall be compliant with the accessibility requirements established by Election Code Section
43.034 and the Americans with Disabilities Act (ADA). All Early Voting and Election Day
voting locations shall be within the boundaries of Denton County. The proposed voting locations
are listed in Exhibit A of this agreement. In the event a voting location is not available or
appropriate, the Elections Administrator will arrange for use of an alternate location. The
Elections Administrator shall notify the participating authorities of any changes from the
locations listed in Exhibit A.
If polling place(s) for the [election -date] joint election are different from the polling place(s)
used by a participating authority in its most recent election, the authority agrees to post a notice
no later than May 1st, 2020 at the entrance to any previous polling places in the jurisdiction
stating that the polling location has changed and stating the political subdivision's polling place
names, addresses, and room or suite number, if applicable, in effect for the [election -date]
election. This notice shall be written in both the English and Spanish languages.
IV. ELECTION JUDGES, CLERKS, AND OTHER ELECTION PERSONNEL
Denton County shall be responsible for the appointment of the presiding judge and alternate
judge for each polling location. The Elections Administrator shall make emergency
appointments of election officials if necessary.
27 of 155
February 17, 2020 Regular Meeting Agenda Packet
Upon request by the Elections Administrator, each participating authority agrees to assist in
recruiting polling place officials who are bilingual (fluent in both English and Spanish). In
compliance with the Federal Voting Rights Act of 1965, as amended, each polling place
containing more than 5% Hispanic population as determined by the 2010 Census shall have one
or more election officials who are fluent in both the English and Spanish languages. If a
presiding judge is not bilingual, and is unable to appoint a bilingual clerk, the Elections
Administrator may recommend a bilingual worker for the polling place. If the Elections
Administrator is unable to recommend or recruit a bilingual worker, the participating authority or
authorities served by that polling place shall be responsible for recruiting a bilingual worker for
translation services at that polling place.
The Elections Administrator shall notify all election judges of the eligibility requirements of
Subchapter C of Chapter 32 of the Texas Election Code, and will take the necessary steps to
insure that all election judges appointed for the Joint Election are eligible to serve.
The Elections Administrator shall arrange for the training and compensation of all election
judges and clerks. The Election judges and clerks who attend in-person voting equipment
training and/or procedures training, shall be compensated at the rate of $10 an hour. Election
judges and clerks that elect to complete online training shall be compensated as a rate of a flat
$30. In the event that as Election judge or clerk completes both in-person and online training,
they shall be compensated for the training resulting in the highest pay and will not be
compensated for both trainings.
The Elections Administrator shall arrange for the date, time, and place for presiding election
judges to pick up their election supplies. Each presiding election judge will be sent a letter from
the Elections Administrator notifying them of their appointment, the dates/times and locations of
training and distribution of election supplies, and the number of election clerks that the presiding
judge may appoint.
Each election judge and clerk will receive compensation at the hourly rate established by Denton
County pursuant to Texas Election Code Section 32.091. The election judge, or their designee,
will receive an additional sum of $25.00 for picking up the election supplies and equipment prior
to Election Day and for returning the supplies and equipment to the central counting station after
the polls close. Likewise, the Lead Clerk in Early Voting, or their designee, will receive an
additional sum of $25.00 for picking up the election supplies prior to the first day of Early
Voting and for returning the supplies and equipment to the Elections Department after Early
Voting has ended.
The compensation rates established by Denton County are:
Early Voting — Lead Clerk ($12/hour), Clerk ($10/hour)
Election Day — Presiding Judge ($12/hour), Alternate Judge ($11 /hour), Clerk ($10/hour)
The Elections Administrator may employ other personnel necessary for the proper administration
of the election, as well as, pre and post-election administration. In such cases, costs shall be pro -
28 of 155
February 17, 2020 Regular Meeting Agenda Packet
rated among participants of this contract. Part-time help is included as is necessary to prepare
for the election, to ensure the timely delivery of supplies during Early Voting and on Election
Day, and for the efficient tabulation of ballots at the central counting station. Part-time personnel
working in support of the Early Voting Ballot Board and/or central counting station on election
night will be compensated at the hourly rate set by Denton County in accordance with Election
Code Sections 87.005, 127.004, and 127.006.
If elections staff is required outside of the hours of the office's normal scope of business, the
entity(ies) responsible for the hours will be billed for those hours. The Elections Administrator
will determine when those hours are necessary, the number of staff and whom are necessary,
along with to whom the hours are to be billed. Cost for these hours will be billed at a rate of 1.5
times the staffs hourly rate (See Sections XV #10). The Election Administrator has the right to
waive these costs as they see fit.
V. PREPARATION OF SUPPLIES AND VOTING EQUIPMENT
The Elections Administrator shall arrange for all election supplies and voting equipment
including, but not limited to, the County's Verity voting system and equipment, official ballots,
sample ballots, voter registration lists, and all forms, signs, maps and other materials used by the
election judges at the voting locations. The Elections Administrator shall ensure availability of
tables and chairs at each polling place and shall procure rented tables and chairs for those polling
places that do not have tables and/or chairs. Any additional required materials (required by the
Texas Election Code) must be provided by the Participating Authority and delivered to the
Elections Office thirty-three (33) calendar days (March 30, 2020) prior to Election Day. If this
deadline is not met, the material must be delivered by the participating authority, to all Early
Voting and Election Day locations affected, prior to voting commencing. The Elections
Administrator shall be responsible for conducting all required testing of the voting equipment, as
required by Chapters 127 and 129 of the Texas Election Code.
At each polling location, joint participants shall share voting equipment and supplies to the
extent possible. The participating authorities shall share a mutual ballot in those precincts where
jurisdictions overlap. Multiple ballot styles shall be available in those shared polling places
where jurisdictions do not overlap. The Elections Administrator shall provide the necessary voter
registration information, maps, instructions, and other information needed to enable the election
judges in the voting locations that have more than one ballot style to conduct a proper election.
Each Participating Authority shall furnish the Elections Administrator a list of candidates and/or
propositions showing the order and the exact manner in which the candidate names and/or
proposition(s) are to appear on the official ballot (including titles and text in each language in
which the authority's ballot is to be printed). Said list must be provided to the Elections
Office within three (3) business days following the last day to file for a place on the ballot or
after the election is ordered, whichever is later. Said list must be in a Word document, the
information must be in an upper and lower case format, be in Arial 12 point font, and contain
candidate contact information for the purposes of verifying the pronunciation of each of the
candidates' names. Each participating authority shall be responsible for proofreading and
approving the ballot insofar as it pertains to that authority's candidates and/or propositions. Each
29 of 155
February 17, 2020 Regular Meeting Agenda Packet
participating authority shall be responsible for proofing and approving the audio recording of the
ballot insofar as it pertains to that authority's candidates and/or propositions. The approvals
must be finalized with the Elections Office within five (5) calendar days of receipt of the
proofs, or the provided proofs shall be considered approved.
The joint election ballots shall list the County's election first. The joint election ballots that
contain ballot content for more than one joint participant because of overlapping territory shall
be arranged with the appropriate school district ballot content appearing on the ballot following
the County's election, followed by the appropriate city ballot content, and followed by the
appropriate water district or special district ballot content.
Early Voting by Personal Appearance and on Election Day shall be conducted exclusively on
Denton County's Verity voting system including provisional ballots.
The Elections Administrator shall be responsible for the preparation, testing, and delivery of the
voting equipment for the election as required by the Election Code.
The Elections Administrator shall conduct criminal background checks on the relevant
employees upon hiring as required by Election Code 129.051(g).
VI. EARLY VOTING
The participating authorities agree to conduct joint early voting and to appoint the Election
Administrator as the Early Voting Clerk in accordance with Sections 31.097 and 271.006 of the
Texas Election Code. Each participating authority agrees to appoint the Elections
Administrator's permanent county employees as deputy early voting clerks. The participating
authorities further agree that the Elections Administrator may appoint other deputy early voting
clerks to assist in the conduct of early voting as necessary, and that these additional deputy early
voting clerks shall be compensated at an hourly rate set by Denton County pursuant to Section
83.052 of the Texas Election Code. Deputy early voting clerks who are permanent employees of
the Denton County Elections Administrator or any participating authorities shall serve in that
capacity without additional compensation.
Early Voting by personal appearance will be held at the locations, dates, and times listed in
Exhibit B of this document. Any qualified voter of the Joint Election may vote early by personal
appearance at any one of the joint early voting locations. All requests for Temporary Early
Voting Locations will be considered and determined based on the availability of sites and if it is
within the Election Code parameters. All costs for temporary sites including coverage by
Election Administration staff will be borne by the requesting authority. The Elections
Administrator will determine when those hours are necessary, the number of staff and whom are
necessary, along with to whom the hours are to be billed. Cost for these hours will be billed at a
rate of 1.5 times the staffs hourly rate (See Sections XV #10). The Election Administrator has
the right to waive these costs as they see fit.
As Early Voting Clerk, the Elections Administrator shall receive applications for early voting
ballots to be voted by mail in accordance with Chapters 31 and 86 of the Texas Election Code.
30 of 155
February 17, 2020 Regular Meeting Agenda Packet
Any requests for early voting ballots to be voted by mail received by the participating authorities
shall be forwarded immediately by fax or courier to the Elections Administrator for
processing. The address of the Early Voting Clerk is as follows:
Frank Phillips, Early Voting Clerk
Denton County Elections
PO Box 1720
Denton, TX 76202
Email: elections@dentoncounty.com
Any requests for early voting ballots to be voted by mail, and the subsequent actual voted ballots
that are sent by a contract carrier (ie. UPS, FedEx, etc.) shall be delivered to the Early Voting
Clerk at the Denton County Elections Department physical address as follows:
Frank Phillips, Early Voting Clerk
Denton County Elections
701 Kimberly Drive, Suite A101
Denton, TX 76208
Email: elections@dentoncounty.com
The Elections Administrator shall post on the county website, the Participating Authority's Early
Voting Roster on a daily basis. In accordance with Section 87.121 of the Election Code, the
daily roster showing the previous day's early voting activity will be posted no later than 11:00
AM each business day.
VII. EARLY VOTING BALLOT BOARD
Denton County shall appoint the Presiding Judge of an Early Voting Ballot Board (EVBB) to
process early voting results from the Joint Election. The Presiding Judge, with the assistance of
the Elections Administrator, shall appoint two or more additional members to constitute the
EVBB. The Elections Administrator shall determine the number of EVBB members required to
efficiently process the early voting ballots.
VIII. CENTRAL COUNTING STATION AND ELECTION RETURNS
The Elections Administrator shall be responsible for establishing and operating the central
counting station to receive and tabulate the voted ballots in accordance with the provisions of the
Texas Election Code and of this agreement.
The participating authorities hereby, in accordance with Section 127.002, 127.003, and 127.005
of the Texas Election Code, appoint the following central counting station officials:
Counting Station Manager:
Tabulation Supervisor:
Presiding Judge:
Alternate Judge:
Brandy Grimes, Deputy Elections Administrator
Jason Slonaker, Technology Resources Coordinator
Early Voting Ballot Board Judge
Early Voting Ballot Board Alternate Judge
31 of 155
February 17, 2020 Regular Meeting Agenda Packet
The counting station manager or their representative shall deliver timely cumulative reports of
the election results as precincts report to the central counting station and are tabulated by posting
on the Election Administrator's Election Night Results website. The manager shall be responsible
for releasing unofficial cumulative totals and precinct returns from the election to the joint
participants, candidates, press, and general public by distribution of hard copies at the central
counting station (if requested) and by posting to the Election Administrator's Election Night
Results website. To ensure the accuracy of reported election returns, results printed on the tapes
produced by Denton County's voting equipment will not be released to the participating
authorities at the remote collection sites or by phone from individual polling locations.
The Elections Administrator will prepare the unofficial canvass reports after all precincts have
been counted and will deliver a copy of the unofficial canvass to each participating authority as
soon as possible after all returns have been tabulated. The Elections Administrator will include
the tabulation and precinct returns that are required by Texas Election Code Section 67.004 for
the participating authorities to conduct their respective canvasses. Each participating authority
shall be responsible for the official canvass of its respective election(s), and shall notify the
Elections Administrator, or their designee, of the date of the canvass, no later than three days
after Election Day.
The Elections Administrator shall be responsible for conducting the post-election manual recount
required by Section 127.201 of the Texas Election Code unless a waiver is granted by the
Secretary of State. Notification and copies of the recount, if waiver is denied, will be provided to
each Participating Authority for uploading, by each participating authority, to the Secretary of
State's Office.
IX. PARTICIPATING AUTHORITIES WITH TERRITORY OUTSIDE DENTON
COUNTY
Each participating authority with territory containing population outside of Denton County
agrees that they Elections Administrator shall administer only the Denton County portion of
those elections.
X. RUNOFF ELECTIONS
Each participating authority shall have the option of extending the terms of this agreement
through its runoff election, if applicable. In the event of such runoff election, the terms of this
agreement shall automatically extend unless the participating authority notifies the Elections
Administrator in writing within three (3) business days of the original election.
Each participating authorities shall reserve the right to reduce the number of early voting
locations and/or Election Day voting locations in a runoff election.
Each participating authority agrees to order any runoff election(s) at its meeting for canvassing
the votes from the [election -date] election and to conduct its drawing for ballot positions at or
immediately following such meeting in order to expedite preparations for its runoff election.
32 of 155
February 17, 2020 Regular Meeting Agenda Packet
Each participating authority eligible to hold runoff elections agrees that the date of the runoff
election, if necessary, shall be [run -off -date], with early voting being held in accordance with the
Election Code.
XI. ELECTION EXPENSES AND ALLOCATION OF COSTS
The participating authorities agree to share the costs of administering the Joint
Election. Allocation of the costs, unless specifically stated otherwise, is mutually agreed to be
shared according to a formula which is based on the number of registered voters within the
district per Elections Day polling place. Costs for polling places shared by more than one
participating authority shall be pro -rated among the participants utilizing that polling place.
It is agreed that the charges for Election Day judges and clerks and Election Day polling place
rental fees shall be directly charged to the appropriate participating authority rather than
averaging those costs among all participants.
If a participating authority's election is conducted at more than one Election Day polling place,
there shall be no charges or fees allocated to the participating authority for the cost of the
Election Day polling place in which the authority has fewer than 50% of the total registered
voters served by that polling place, except that if the number of registered voters in all of the
authority's polling places is less than the 50% threshold, the participating authority shall pay a
pro -rata share of the cost associated with the polling place where it has the greatest number of
registered voters.
Costs for Early Voting by Personal Appearance shall be allocated based upon the actual costs
associated with each early voting site. Each participating authority shall be responsible for an
equal portion of the actual costs associated with the early voting sites located within their
jurisdiction. Participating authorities that do not have a regular (non -temporary) early voting site
within their jurisdiction shall pay an equal portion of the nearest regular early voting site.
Costs for Early Voting by mail shall be allocated according to the actual number of ballots
mailed to each participating authority's voters.
Each participating authority agrees to pay the Elections Administrator an administrative fee
equal to ten percent (10%) of its total billable costs in accordance with Section 31.100(d) of the
Texas Election Code.
The Denton County Elections Administrator shall deposit all funds payable under this contract
into the appropriate fund(s) within the county treasury in accordance with Election Code Section
31.100.
The Denton County Elections Administrator reserves the right to adjust the above formulas in
agreement with an individual jurisdiction if the above formula results in a cost allocation that is
inequitable.
33 of 155
February 17, 2020 Regular Meeting Agenda Packet
If any participating authority makes a special request for extra Temporary Branch Early Voting
by Personal Appearance locations as provided by the Texas Election Code, that entity agrees to
pay the entire cost for that request.
Participating authorities having the majority of their voters in another county, and fewer than 500
registered voters in Denton County, and that do not have an Election Day polling place or early
voting site within their Denton County territory shall pay a flat fee of $400 for election expenses.
Election expenses, including but not limited to, overtime charges for Election Office staff, and
any unforeseen expenses needed to conduct the election, will be borne by the participating
authority or authorities, affected.
XII. WITHDRAWAL FROM CONTRACT DUE TO CANCELLATION OF
ELECTION
Any participating authority may withdraw from this agreement and the Joint Election should it
cancel its election in accordance with Sections 2.051 - 2.053 of the Texas Election Code. The
withdrawing authority is fully liable for any expenses incurred by the Denton County Elections
Administrator on behalf of the authority plus an administrative fee of ten percent (10%) of such
expenses. Any monies deposited with the Elections Administrator by the withdrawing authority
shall be refunded, minus the aforementioned expenses and administrative fees, if applicable.
It is agreed that any of the joint election early voting sites that are not within the boundaries of
one or more of the remaining participating authorities, with the exception of the early voting site
located at the Denton County Elections Building, may be dropped from the joint election unless
one or more of the remaining participating authorities agreed to fully fund such site(s). In the
event that any early voting site is eliminated under this section, as addendum to the contract shall
be provided to the remaining participants within five days after notification of all intents to
withdraw have been received by the Elections Administrator.
XIII. RECORDS OF THE ELECTION
The Elections Administrator is hereby appointed general custodian of the voted ballots and all
records of the Joint Election as authorized by Section 271.010 of the Texas Election Code.
Access to the election records shall be available to each participating authority as well as to the
public in accordance with applicable provisions of the Texas Election Code and the Texas Public
Information Act. The election records shall be stored at the offices of the Elections
Administrator or at an alternate facility used for storage of county records. The Elections
Administrator shall ensure that the records are maintained in an orderly manner so that the
records are clearly identifiable and retrievable.
Records of the election shall be retained and disposed of in accordance with the provisions of
Section 66.058 of the Texas Election Code. If records of the election are involved in any pending
election contest, investigation, litigation, or open records request, the Elections Administrator
shall maintain the records until final resolution or until final judgment, whichever is applicable.
34 of 155
February 17, 2020 Regular Meeting Agenda Packet
It is the responsibility of each participating authority to bring to the attention of the Elections
Administrator any notice of pending election contest, investigation, litigation or open records
request which may be filed with the appropriate participating authority.
XIV. RECOUNTS
A recount may be obtained as provided by Title 13 of the Texas Election Code. By signing this
document, the presiding officer of the contracting participating authorities agree that any recount
shall take place at the offices of the Elections Administrator, and that the Elections Administrator
shall serve as Recount Supervisor, and the participating authority's official or employee who
performs the duties of a secretary under the Texas Election Code shall serve as Recount
Coordinator.
The Elections Administrator agrees to provide advisory services to each participating authority
as necessary to conduct a proper recount.
XV. MISCELLANEOUS PROVISIONS
1. It is understood that to the extent space is available, other districts and political
subdivisions may wish to participate in the use of the County's election equipment and
voting places, and it is agreed that the Elections Administrator may contract with such
other districts or political subdivisions for such purposes and that in such event there may
be an adjustment of the pro -rata share to be paid to the County by the participating
authorities.
2. The Elections Administrator shall file copies of this document with the Denton County
Treasurer and the Denton County Auditor in accordance with Section 31.099 of the Texas
Election Code.
3. Nothing in this contract prevents any party from taking appropriate legal action against
any other party and/or other election personnel for a breach of this contract or a violation
of the Texas Election Code.
4. This agreement shall be construed under and in accord with the laws of the State of
Texas, and all obligations of the parties created hereunder are performable in Denton
County, Texas.
5. In the event that one of more of the provisions contained in this Agreement shall for any
reason be held to be invalid, illegal, or unenforceable in any respect, such invalidity,
illegality, or unenforceability shall not affect any other provision hereof and this
agreement shall be construed as if such invalid, illegal, or unenforceable provision had
never been contained herein.
6. All parties shall comply with all applicable laws, ordinances, and codes of the State of
Texas, all local governments, and any other entities with local jurisdiction.
35 of 155
February 17, 2020 Regular Meeting Agenda Packet
7. The waiver by any party of a breach of any provision of this agreement shall not operate
as or be construed as a waiver of any subsequent breach.
8. Any amendments of this agreement shall be of no effect unless in writing and signed by
all parties hereto.
9. Failure for a participating authority to meet the deadlines as outline in this contract may
result in additional charges, including but not limited to, overtime charges, etc.
10. Elections Staffing Hourly Rate (includes all benefit pay):
Absentee Voting Coordinator
Voter Registration Clerk
Technology Resources Coordinator
Elections Technician
Voter Registration Coordinator
Training Coordinator
Election Coordinator
$40.023
$31.883 $34.763
$43.277
$30.521 $34.763
$41.106
$41.899
$34.763
XVI. COST ESTIMATES AND DEPOSIT OF FUNDS
The total estimated obligation for each participating authority under the terms of this agreement
is listed below. The exact amount of each participating authority's obligation under the terms of
this agreement shall be calculated after the [election -date] election (or runoff election, if
applicable). The participating authority's obligation shall be paid to Denton County within 30
days after the receipt of the final invoice from the Denton County Elections Administrator.
The total estimated obligation for each participating authority under the terms of this agreement
shall be provided within 45 days after the last deadline for ordering an election:
36 of 155
February 17, 2020 Regular Meeting Agenda Packet
THIS PAGE INTENTIONALLY BLANK.
37 of 155
February 17, 2020 Regular Meeting Agenda Packet
XVII. JOINT CONTRACT ACCEPTANCE AND APPROVAL
IN TESTIMONY HEREOF, this agreement has been executed on behalf of the parties hereto as follows, to -wit:
(1) It has on the day of _ , 2020 been executed by the Denton County Elections
Administrator pursuant to the Texas Election Code so authorizing;
(2) It has on the 17th day of February 2020 been executed on behalf of Trophy Club Municipal Utility
District No. 1 pursuant to an action of the Board of Directors so authorizing;
ACCEPTED AND AGREED TO BY DENTON COUNTY ELECTIONS ADMINISTRATOR:
APPROVED:
70,,,,,L
Frank Phillips, CERA
ACCEPTED AND AGREED TO BY TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1:
APPROVED: ATTESTED:
Gregory Wilson, Board President Laurie Slaght, District Secretary
38 of 155
February 17, 2020 Regular Meeting Agenda Packet
ORDER NO. 2020-0217A
ORDER DECLARING PROPERTY SURPLUS AND AUTHORIZING SALE THEREOF
WHEREAS, Trophy Club Municipal Utility District No. 1 (the "District") is a conservation
and reclamation district, a body corporate and politic and governmental agency of the State of
Texas, created under Article XVI, Sec. 59 of the Texas Constitution by order of the Texas Water
Commission, now the Texas Commission on Environmental Quality ("TCEQ"), and the District
operates under Chapters 49 and 54 of the Texas Water Code, as amended;
WHEREAS, Section 49.226 of the Texas Water Code provides that any personal property
valued at more than $300 which is found by the board to be surplus and is not needed by the district
may be sold under order of the board either by public or private sale;
WHEREAS, the District owns the following equipment and vehicle that are no longer used
or useful for the District's operations (the "Property"):
1. Truck No. 102 — 2012 Ford F250 king cab pick-up truck with 71,600 miles.
2. Dodge Truck bed
3. 2 Automatic transfer switches; and
WHEREAS, the Board of Directors desires to declare the Property to be surplus and not
needed by the District and further desires to authorize the sale thereof by public sale.
NOW, THEREFORE, BE IT ORDERED BY THE BOARD OF DIRECTORS OF TROPHY
CLUB MUNICIPAL UTILITY DISTRICT NO. 1 THAT:
Section 1. The facts and recitations in the preamble of this Order are hereby found and declared
to be true and correct and are incorporated by reference herein and expressly made a part hereof,
as if copied verbatim.
Section 2. The Board of Directors of the District hereby finds and declares that the Property is
surplus and not needed by the District.
Section 3. The Board of Directors hereby orders and directs that the Property be sold at a public
sale.
Section 4. The General Manager is hereby authorized to take any and all actions necessary to
effectuate this Order.
Section 5. Upon adoption of this Order, an original Order shall be filed in the permanent records
of the District.
39 of 155
February 17, 2020 Regular Meeting Agenda Packet
ORDERED, PASSED AND APPROVED this 17th clay of February 2020.
Gregory Wilson, President
Steve Flynn, Secretary/Treasurer
Laurie Slaght, District Secretary
40 of 155
(SEAL)
February 17, 2020 Regular Meeting Agenda Packet
DRAFT
INTERLOCAL AGREEMENT BETWEEN THE CITY OF SOUTHLAKE AND
THE TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 REGARDING
SANITARY SEWER LINE ADJUSTMENTS CROSSING SH 114
This Interlocal Agreement (the "Agreement") for the Construction of certain
Sanitary Sewer Line Adjustments made necessary by construction of
improvements to State Highway 114 is made and entered into by and between the
City of Southlake, Texas ("Southlake"), a municipal corporation located in Tarrant
County, Texas, and the Trophy Club MUD No. 1, Texas ("the District"), a municipal
utility district located in Denton County, Texas. Southlake and the District shall
hereafter be collectively referred to as "the Parties."
RECITALS
WHEREAS, the Parties mutually desire -nter into terlocal agreement
to undertake the adjustments to the exist' 10" d 12" nitary Sewer Line
serving the District (the "Project") necessita b e construction of the SH 114
Frontage Road Improvements; and
WHEREAS, Chapter 791, Te -nt Code, as amended (the
"Act"), provides authorization • ocal nme is to contract with one another
for the performance of gove t ' I fun ons and services under the terms of the
Act; and
WHEREAS
such as Southla
rnment" is defined to include both municipalities
ricts such as the District; and
WHEREA
Southlake; and
have need to construct the Project located in
WHEREAS, due to the compelling urgency of the Project, the City of
Southlake has previously contracted for Consulting Engineering Services related
to the design of the Project; and
WHEREAS, the Parties are required to provide financing for the Project;
and
WHEREAS, the costs of the design and construction of the Project are
eligible for full reimbursement from the Texas Department of Transportation
("TxDOT") under a Reimbursement Agreement between the District and TxDOT;
and
41 of 155
February 17, 2020 Regular Meeting Agenda Packet
WHEREAS, the Parties are willing to cooperate with one another to
accomplish the construction of the Project as provided in this Agreement; and
WHEREAS, state law requires that a local government paying for the
performance of governmental functions or services under this Agreement must
make those payments from current revenues; and
WHEREAS, it is mutually advantageous to both parties to enter into this
Agreement:
AGREEMENTS, TERMS AND CONDITIONS
NOW, THEREFORE, for and in consideration of the mutual covenants,
terms and conditions set forth herein, and the mutual b efits to each party, the
receipt and sufficiency of which are hereby acknow ged, the Parties hereby
contract, covenant, warrant and agree as follows:
I. ADOPTION OF RECITALS
All of the matters stated in the Recit t above are agreed to be true
and correct and are hereby incorporated in e body of the Agreement by
reference as though fully set forth in -.tiret ein.
II. OBLIGATIONS OF TH
1. The District sha ave op• unity to review and approve the
construction plans - • _ _ submittals.
2. The Parti = . gre. a • uthlake shall retain a General Contractor to
construct the P -ct ands ma age all aspects of the contract with the General
Contractor inclu• « Biddi ' ; Phase and Construction Phase Services, but
excluding Construc In ction Services, which will be provided by the District.
3. The Parties agree that the General Contractor shall provide Performance
and Payment Bonds in the full amount of the Project contract cost, to be issued
naming Southlake as beneficiary.
4. The Parties agree that the General Contractor shall also provide a
Maintenance Bond in the amount of 25% of the Project contract cost, to be issued
naming the District as beneficiary.
5. The Parties agree that the General Contractor shall provide Insurance to
the contracting party, Southlake, with the District named as an additional insured.
6. The Parties agree to fund the Project as follows:
42 of 155
February 17, 2020 Regular Meeting Agenda Packet
a) The District shall reimburse Southlake for the District's proportionate
share of the cost of all design services for the Project, including
Bidding Phase Services, under an agreement for Engineering
Services with Kimley Horn Engineers, said cost of which is agreed to
be $16,645, plus 100% of the cost of any revisions necessitated by
amendments that may arise in the future within five business days of
receipt of request for payment from Southlake.
b.)
The District shall reimburse Southlake 100% of the estimated total
cost for all construction for the Project, which the Parties estimate to
be $172,000.00. The final cost shall be the actual construction
contract final costs.
7. Southlake shall submit monthly bills to TxD
construction costs of the Project with a copy p
District shall sign their copy and forward to T
of receipt to insure prompt processing by a OT.
for the design and
ided to the District. The
ithin five business days
8. The Parties anticipate that TxDOT w
of receipt of the bill.
9. The District agrees to mak
transfer pursuant to instruction
days of receiving its rei • • . rse
10. The Parties agree
Services for the Pr
11. The Parti
be in ac
necessarl
construction,
rict within 30 days
outhlake by electronic fund
outhlake within five business
nt from TxDOT.
ill provide all Construction Inspection
construction to be done within Southlake shall
So hlake's Code of Ordinances including, but not
providing proper barricades, traffic control during
nd project clean up after the contractor is completed.
INDEMNIFICATION AND HOLD HARMLESS
1. To the extent allowed by law, the District agrees to indemnify and
hold Southlake harmless from any claim by a third party for damages arising from
or resulting from the construction or maintenance of the improvements constituting
the Project in accordance with terms set forth in this Agreement, or in any other
way arising from any portion of the Project, including but not limited to any property
damage or personal injuries, including death.
2. To the extent allowed by law, Southlake agrees to indemnify and hold
the District harmless from any claim by a third party for damages arising from or
resulting from the construction or maintenance of the improvements constituting
the Project in accordance with terms set forth in this Agreement, or in any other
43 of 155
February 17, 2020 Regular Meeting Agenda Packet
way arising from any portion of the Project, including but not limited to any property
damage or personal injuries, including death.
3. The provisions of these indemnification and hold harmless provisions
of this Agreement shall not apply to acts of gross negligence or willful misconduct
by the indemnified party.
4. The indemnification provisions of this Agreement are solely for the
benefit of the parties hereto and not intended to create or grant any rights,
contractual or otherwise, to any other person or entity.
5. The provisions relating to indemnification and hold harmless
contained herein shall not be deemed a waiver of any sovereign or governmental
immunity or limitation on damages created or recogniz by any applicable law,
including but not limited to Tex. Civ. Proc. & Rem. Co ection 101.001 et. seq.
IV. NOTICES
Any notice required to be given and
have been adequately given if deposited in
with sufficient postage and properly addresse
eements`hall be deemed to
ed States mail in an envelope
the other party as follows:
TO SOUTHLAKE: ESTLAKE:
City of Southlake
1400 Main Street
Southlake, Texas 76092
Attention: City Man
Notice o
ten (10) days aft
provision.
Trophy Club MUD No. 1
100 Municipal Drive
Trophy Club, Texas 76262
Attention: District Manager
ddr-ss may be given by either party, to be effective
g of written notice of such change pursuant to this
V. MISCELLANEOUS PROVISIONS
1. This Agreement shall be binding upon and inure to the benefit of the
parties hereto and their respective successors and assigns.
2. This Agreement constitutes the sole and only agreement of the
parties hereto and supersedes any prior understandings or written or oral
agreements between the parties respecting the subject matter hereof.
3. No amendment, modification or alteration of the terms hereof shall
be binding unless the same be in writing, dated subsequent to the date hereof and
duly executed by the parties.
44 of 155
February 17, 2020 Regular Meeting Agenda Packet
4. All payments made hereunder shall be payable from funds currently
available to the District.
5. This Agreement may be executed concurrently in one or more
counterparts, each of which shall be deemed an original, but all of which together
shall constitute one and the same instrument.
6. If, in case any one or more of the provisions contained in this
Agreement shall for any reason be held to be invalid, illegal, or unenforceable in
any respect, such invalidity, illegality, or unenforceability shall not affect any other
provision hereof and this Agreement shall be construed as if such invalid, illegal or
unenforceable provision had never been contained herein.
7. The obligations and undertakings of ea of the parties to this
Agreement are performable and shall be fully perform= Tarrant County, Texas.
8. Each person signing this Agree - t w. ' nts that person has
received authority from the governing body of party for ''ch it is signing this
Agreement to enter into this Agreement.
EXECUTED this the _ day o
ATTEST:
, 2020.
UTHLAKE, TEXAS
ayor for the City of Southlake, Texas
City Secretary for the of Southlake, Texas
[SEAL]
APPROVED AS TO FORM:
City Attorney for the City of Southlake, Texas
45 of 155
EXECUTED this the
ATTEST:
February 17, 2020 Regular Meeting Agenda Packet
day of , 2020.
TROPHY CLUB MUD NO.1
Chairman of the Board of Directors
Trophy Club MUD NO. 1, Texas
District Secretary for Trophy Club MUD NO. 1
[SEAL]
APPROVED AS TO FORM:
Attorney for Trophy Club MUD NO. <(11p
c)IIIII"P
46 of 155
cP&Yi
February 11, 2020
February 17, 2020 Regular Meeting Agenda Packet
Partners for a Better Quality of Life
Mr. Mike McMahon, Operations Manager
Trophy Club MUD No. 1
100 Municipal Drive
Trophy Club, TX 76262
Re: Scope & Fee Proposal for Antifoaming Spray System Design (20TCM000070)
Dear Mike:
CP&Y (Consultant) is pleased to submit to Trophy Club MUD No. 1 (TCMUD) the following scope and fee
proposal for design of a pressure spray system located on the five (5) treatment trains using the existing
wastewater treatment plant reuse water system. The overall project will generally consist of providing
engineering design and construction documents as required to install the spray system in the pre -
aeration and anaerobic basins on each treatment train to assist with managing foam that can
accumulate on the basin surface.
Task 1: Antifoam Spray System Design and Project Management
This task will include the following engineering design services:
1. Site Visits/Meetings
a. CP&Y will visit the Owner's treatment facility up to one (1) time to gather field data and
information to complete our project design. At the same site visit and if needed we will
meet with the Owner's representative to review the preliminary design and obtain Owner's
comments.
2. Spray System Design
a. CP&Y will provide a spray system design in the pre -aeration and anaerobic basins in each of
the five (5) treatment trains. The spray system will tie into the existing plant reuse water
supply/distribution system located adjacent to each treatment train and will be equipped
with valves and nozzles to allow the operations staff to isolate the system at each basin and
treatment train.
b. Provide technical specifications and construction drawings as required to obtain qualified
bids from contractors.
i. CP&Y will compile the project manual front-end documents using EJCDC forms and
templates.
47 of 155
200 West Highway 6, Suite 620
Waco, Texas 76712
TBPE # F.1741
TBPLS 1410194124
(p) 254.772.9272 (0 254,776.2924
www.cpyi.com
February 17, 2020 Regular Meeting Agenda Packet
Trophy Club MUD No. 1— Anti Foaming Design & Construction Administration Services Page 2
3. Project Management
a. CP&Y will provide project management throughout the entirety of the project. Services will
generally include communicating with the Owner, scheduling and coordinating project
construction documents, submitting correspondence to the Owner, including invoices,
progress updates and project documents.
Task -1 Total Fee (Lump Sum): $16,940.00
Task 2: Bidding Services
This task will include the following engineering services:
1. Provide Owner with a written project description to assist in advertising Project for bid.
2. Prepare construction plans and technical specifications in portable document format (PDF).
Submit the PDF documents to CIVCAST for distribution to potential bidders.
3. CP&Y will provide clarifications and/or address bidder's questions during the bid process. CP&Y
will prepare and issue addenda as may be required to modify the Contract Documents before or
after they have been issued to prospective Bidders.
4. Prepare an opinion of probable construction cost (OPCC) for the project.
5. Attend one (1) Bid Opening for Project.
6. Assist Owner with review of bids received for completeness and accuracy. Engineer will assist
Owner with assembling the bid tabulation to be submitted to the respondents and prepare
notice of award.
7. CP&Y will compile and distribute the Contract Documents to the contractor for signatures and
execution.
8. Engineer will prepare and provide 'conformed' construction plans and technical specifications in
PDF to Contractor as modified to reflect changes resulting from addenda and clearly indicate
approval for construction status.
Task -2 Total Fee (Lump Sum): $5,340.00
Task 3: Construction Administration & Startup Services
Engineer agrees to perform the following Construction Phase Services listed below. The projected fee
(hours and expenses) is an estimate and may vary depending on the contractor's schedule and
performance. These services shall be provided on a time (hourly billing rate) and materials (direct
expenses plus 10%) basis, not to exceed the amount listed herein without written prior approval from
Owner.
1. Interpretation. During construction, Engineer's Project Manager or Design Staff shall be
available for interpretation of the Drawings, Specifications, or Bidding Documents.
2. Project Submittals. Review Contractor submitted Shop Drawings, material samples, equipment
drawings, and other data submittals required by the Contract Documents for conformance with
the applicable sections of the Documents.
48 of 155 Partners for a Better Quality of Life cp&y
February 17, 2020 Regular Meeting Agenda Packet
Trophy Club MUD No. 1— Anti Foaming Design & Construction Administration Services Page 3
3. Preconstruction Conference. Provide representation for Owner at one (1) preconstruction
review meeting with the selected Contractor.
4. Construction Observation. No construction observation services are provided. Should these
services be required, they shall be considered additional and shall be negotiated for an
additional fee.
5. Progress Meetings. No construction progress meeting services are provided. Should these
services be required, they shall be considered additional and shall be negotiated for an
additional fee.
6. Construction Administration. Review and make recommendations on pay requests and change
orders.
7. Record Drawings. Upon completion of the construction work and upon final project approval,
CP&Y shall revise the original reproducible drawings to reflect changes made during
construction based on Contractor and/or Owner mark-ups. Mark-ups shall be submitted by the
Contractor. CP&Y shall then submit two (2) sets of hard -copy prints to Owner, and one CD/DVD
containing portable digital files (PDF) of the plans.
Task -3 Total Fee (Hourly/Expenses): $7,520.00
Should additional services be required or requested by Owner, the following is the current billing
rates for CP&Y.
Category Rate
Principal $235.00
Sr Project Manager $215.00
Sr. Electrical Engineer $205.00
Deputy Project Manager $185.00
Sr. Engineer $175.00
Project Controls Specialist $125.00
Project Professional Engineer $135.00
Sr. CADD Tech $120.00
Sr. Technician $110.00
EIT $105.00
Exec Assistant
Clerical
Intern $42.00
$85.00
$65.00
49 of 155 Partners for a Better Quality of Life cp&y
February 17, 2020 Regular Meeting Agenda Packet
Trophy Club MUD No. 1— Anti Foaming Design & Construction Administration Services Page 4
Compensation Summary
Task 1 Design and Project Management Services $16,940.00
Task 2 Bidding Services $5,340.00
Sub -Total $22,280.00
Task 3 Construction Administration (hourly not to exceed) $7,520.00
Total $29,800.00
Attachment -A provides a detailed labor breakdown of our fee proposal.
Project Schedule
CP&Y will deliver the 100% project documents to the Owner within approximately 120 calendar days
following receipt of a signed agreement and written notification from the Owner to proceed with the
services provided herein.
Services Not Provided by Engineer
The following are services not provided by the Engineer under this scope. These additional services
can be provided by Engineer for additional compensation and upon written authorization by Owner.
1. Any topographic or metes/bounds surveying services.
2. Any geotechnical engineering services or soils borings.
3. Any wastewater treatment or process design services.
4. Construction progress meetings, site visits and construction observation/resident project
representative services.
5. Any other services not expressly identified as being provided herein.
Services to Be Provided by TCMUD
1. Owner shall provide to CP&Y the technical information and/or manuals on the new reuse water
pumps and controls system.
2. Timely review of submittals by CP&Y for design review and equipment selection.
Opinion of Probable Construction Cost (OPCC)
The Engineer's OPCC for this project is $90,000 based on a project concept. Since no actual design
or construction drawings have been completed at this time, the actual bid price will vary from this
original OPCC value.
50 of 155 Partners for a Better Quality of Life cp&y
February 17, 2020 Regular Meeting Agenda Packet
Trophy Club MUD No. 1— Anti Foaming Design & Construction Administration Services Page 5
Please review this proposal for professional services on this project and if satisfactory, please sign and
return to me at your earliest convenience. If you have any questions you can contact me at 254-399-
7153 or at swetzel@cpvi.com .
Sincerely, Accepted By:
Scott Wetzel, P.E.
Project Manager
CP&Y, Inc.
SCW:scw
cc: File 20TCM000070
Signature:
Printed Name:
Date:
51 of 155 Partners for a Better Quality of Life cp&y
February 17, 2020 Regular Meeting Agenda Packet
Trophy Club MUD No. 1— Anti Foaming Design & Construction Administration Services Page 6
ATTACH E M NT -A
Fee Schedule
52 of 155 Partners for a Better Quality of Life cp&y
February 17, 2020 Regular Meeting Agenda Packet
TROPHY CLUB MUD NO. 1
WWTP ANTI -FOAM SYSTEM
11 -Feb -20
Fee Sch 'dule/Budget for CP&Y Inc. #20TC N000070
Project Project CAD Field Admin. Total
Task Description Manager Senior PE Engineer EIT Architect RPLS Operator Observation Support Hours
Personnel
$215.00 $175.00 $135.00 $105.00 $165.00 $150.00 $105.00 $110.00 $100.00
1 Engineering Design & PM:
Site Visits (1)
Engineering Design (60%)
Engineering Design (100%)
Project Manual
Project Management
6.00
16.00
12.00
8.00
2.00
2 Bidding Phase Services: 8.00
3 Construction Phase Services:
Construction Administration
Construction Meetings (0)
Construction Observation (0)
HOURS SUB -TOTALS
FEES SUBTOTAL
8.00
32.00
24.00
16.00
Basic Total
Basic Engineering Total Engineering
Engineering as Percent Engineering as Percent
Fees of Total Fee Fees of Total Fee
6.00 $ 1,290.00
48.00 $ 6,800.00
36.00 $ 5,100.00
24.00 $ 3,320.00
2.00 $ 430.00
4.3
22.8%
17.1
11.1%
1.4% $ 16,940.00 56.8%
4.00 32.00 44.00 $ 5,340.00 17.9% $ 5,340.00 17.9%
32.00 8.00 16.00 64.00 $ 7,520.00 25.2
- $ - 0.0°%
- $ 0.0% $ 7,520.00 25.2%
- -
60.00 - 36.00 - 64.00 - 64.00 224.00
$ 12,900.00 $ $ - $ 3,780.00 $ - $ - $ 6,720.00 $ - $ 6,400.00 $ 29,800.00 100.0% $ 29,800.00 100.0%
53 of 155
February 17, 2020 Regular Meeting Agenda Packet
TROPHY CLUB MUD #1 - FIRE DEPARTMENT
BALANCE SHEET
JANUARY 2020
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
122
ASSETS FIRE DEPT.
CASH IN BANK -
INVESTMENTS 1,220,452
PREPAID EXPENSES 13,127
ADVALOREM PROPERTY TAXES RECEIVABLE 177,817
EMERGENCY SERVICES ASSESSMENTS RECEIVABLE
UTILITY AND OTHER ACCOUNTS RECEIVABLE
TOTAL ASSETS 1,411,396
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
DESIGNATED FOR FUTURE ASSET REPLACEMENT
NON -SPENDABLE FUND BALANCE
UNASSIGNED FUND BALANCE 603,769
RESERVE FOR ENCUMBRANCES
NET REVENUES / EXPENDITURES 629,804
TOTAL FUND BALANCE 1,233,573
177,823
177,823
TOTAL LIABILITIES AND FUND BALANCE 1,411,396
54 of 155
glbase_tbam skrolczyk
10:43 02/11/20
Fund: 122 Trophy Club MUD Fire Dept.
Account Description
122-40010-000-000
122-40011-000-000
122-40020-000-000
February 17, 2020 Regular Meeting Agenda Packet
Trophy Club MUD No.1
Budget Summary with Amendment
Department: Fire Revenues Program:
Period Ending: 1/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 P61
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-
MEMII 1,214,230.00- 1,214,230.00-
55 of 155
456,982.39-
1,376.20-
426.40-
1,084,568.93-
1,022.23-
1,647.72-
458,784.99- 1,087,238.88-
458,784.99- 1,087,238.88-
458,784.99- 1,087,238.88-
458,784.99- 1,087,238.88-
89.322
89.541
129,661.07-
1,022.23
1,647.72
126,991.12-
Page
89.541
126,991.12-
89.541 126,991.12-
89.541
126,991.12 -
February 17, 2020 Regular Meeting Agenda Packet
glbase_tbam skrolczyk Trophy Club MUD No.1
10:43 02/11/20 Budget Summary with Amendment
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 1/2020
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
122-60030-045-000 Rent And/Or Usage 218,004.00 218,004.00
122-60055-045-000 Insurance 21,000.00 21,000.00
122-60337-045-000 Transfer to Town/Fire Budget 718,657.00 718,657.00
1,640.88
59,888.08
6,563.52
239,552.32
31.255
33.333
218,004.00
14,436.48
479,104.68
tota1: 957,661.00 957,661.00 61,528.96
122-69005-045-000 Capital Outlays 48,000.00 48,000.00 2,750.00 5.729 45,250.00
122-69009-045-000 Short Term Debt -Interest 11,958.24 11,958.24-
122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 81,420.00 81,420.00 100.000
122-69305-045-000 Capital Leases 127,149.00 127,149.00 115,190.36 90.595 11,958.64
Subtota1: 256,569.00 256,569.00 211,318.60 ' 45,
Program number: 1,214,230.00 1,214,230.00 61,528.96 457,434.44 756,795.56
Department number: Fire 1,214,230.00 1,214,230.00 61,528.96 457,434.44 /3 756,795.56
Expenditures Subtotal 1,214,230.00 1,214,230.00 61,528.96 457,434.44 /3 756,795.56
Fund number: 122 Trophy Club MUD Fire Dept. 397,256.03- 629,804.44- 629,804.44
56 of 155
Page 2
glpdatb2 skrolczyk
10:44 02/11/20
Fund: 122 Trophy Club MUD Fire Dept.
JE JE JE
Number Date Description
February 17, 2020 Regular Meeting Agenda Packet
Trophy Club MUD No.1 Page 1
Detailed Accounting Trial Balance
Department: Fire Revenues Program:
Period Ending: 1/2020
JE Detail Beginning Transaction Transaction Vendor Name Check Source
Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 122-40010-000-000
Property Taxes/MUD Fire
670 01/02/2020 Property Taxes
671 01/03/2020 Property Taxes
672 01/06/2020 Property Taxes
673 01/07/2020 Property Taxes
674 01/08/2020 Property Taxes
691 01/09/2020 Property Taxes
692 01/10/2020 Property Taxes
693 01/13/2020 Property Taxes
694 01/14/2020 Property Taxes
695 01/15/2020 Property Taxes
696 01/16/2020 Property Taxes
697 01/17/2020 Property Taxes
698 01/21/2020 Property Taxes
699 01/22/2020 Property Taxes
700 01/23/2020 Property Taxes
701 01/24/2020 Property Taxes
704 01/27/2020 Property Taxes
705 01/28/2020 Property Taxes
706 01/29/2020 Property Taxes
707 01/30/2020 Property Taxes
708 01/31/2020 Property Taxes
(627,586.54)
(24,040.24)
(15,369.98)
(12,677.57)
(23,873.74)
(22,592.43)
(6,233.18)
(11,411.00)
(8,720.18)
(4,702.34)
(25,633.01)
(8,539.62)
(11,615.77)
(5,588.50)
(11,955.93)
(10,781.89)
(85,374.77)
(22,897.23)
(105,049.46)
(13,630.74)
(12,832.45)
(13,462.36)
(651,626.78) GL
(666,996.76) GL
(679,674.33) GL
(703,548.07) GL
(726,140.50) GL
(732,373.68) GL
(743,784.68) GL
(752,504.86) GL
(757,207.20) GL
(782,840.21) GL
(791,379.83) GL
(802,995.60) GL
(808,584.10) GL
(820,540.03) GL
(831,321.92) GL
(916,696.69) GL
(939,593.92) GL
(1,044,643.38) GL
(1,058,274.12) GL
(1,071,106.57) GL
(1,084,568.93) GL
Account: 122-40010-000-000
Property Taxes/MUD Fire Totals:
(456,982.39)
(1,084,568.93) **
(1,214,230.00) Budgeted
(129,661.07) Remaining 89 % Used
Account: 122-40011-000-000 Property Taxes/Fire-Delinquent
•
670 01/02/2020 Property Taxes
673 01/07/2020 Property Taxes
692 01/10/2020 Property Taxes
695 01/15/2020 Property Taxes
699 01/22/2020 Property Taxes
700 01/23/2020 Property Taxes
704 01/27/2020 Property Taxes
353.97 (18.99) 334.98 GL
(14.71) 320.27 GL
(43.85) 276.42 GL
(1,175.83) (899.41) GL
(99.82) (999.23) GL
(.01) (999.24) GL
(22.99) (1,022.23) GL
Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals:
(1,376.20) (1,022.23) **
.00 Budgeted
1,022.23 Remaining 0 % Used
Account: 122-40020-000-000 Property Taxes/Fire P&I
670 01/02/2020 Property Taxes (1,221.32)
671 01/03/2020 Property Taxes
57 of 155
(60.57) (1,281.89) GL
(3.87) (1,285.76) GL
February 17, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 2
10:44 02/11/20 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program:
Period Ending: 1/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
672 01/06/2020 Property Taxes
673 01/07/2020 Property Taxes
674 01/08/2020 Property Taxes
691 01/09/2020 Property Taxes
692 01/10/2020 Property Taxes
695 01/15/2020 Property Taxes
696 01/16/2020 Property Taxes
697 01/17/2020 Property Taxes
699 01/22/2020 Property Taxes
700 01/23/2020 Property Taxes
701 01/24/2020 Property Taxes
704 01/27/2020 Property Taxes
Account: 122-40020-000-000
Property Taxes/Fire P&I
.00 Budgeted
(1,221.32) (7.75) (1,293.51) GL
(3.38) (1,296.89) GL
(1.94) (1,298.83) GL
(15.13) (1,313.96) GL
(22.77) (1,336.73) GL
(282.92) (1,619.65) GL
(1.03) (1,620.68) GL
(.69) (1,621.37) GL
(15.77) (1,637.14) GL
(.25) (1,637.39) GL
(5.89) (1,643.28) GL
(4.44) (1,647.72) GL
Totals: (426.40) (1,647.72) **
1,647.72 Remaining 0 % Used
Department Totals: (1,087,238.88) **
(458,784.99) Monthly Total (1,214,230.00) Budgeted (126,991.12) Remaining 90 % Used
58 of 155
February 17, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 3
10:44 02/11/20 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 1/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 122-60030-045-000
Rent And/Or
.00 .00
Account: 122-60030-045-000
Rent And/Or Usage Totals:
218,004.00 Budgeted
Account: 122-60055-045-000 Insurance
69 01/01/2020 Insurance/Wrk Comp Expense Jan
Account
218,004.00 Remaining 0 % Ueed
21,000.00 Budgeted 14,436.48 Remaining
Accoun - Transfer to Town/Fire Budget
483 01/02/2020 January A/P
Jan Fire Admin
Account: 122-60337-045-00 Transfer to T•: ••
718,657.00 Budgeted
Account: 122-69005-045-000
Capital Outlays
Account: 122-69005-045-000 Capital Outlays
48,000.00 Budgeted
479,104.68
4,922.64 1,640.88 6,563.52
31 % Ueed
59,888.08 239,552.32 TOWN OF TROPHY CLUB
179,664.24
Remaining
45,250.00 Remaining
2,750.00
33 % Ueed
6 % Ueed
.00
2,750.00
GL
6058 AP
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
.00
.00
11,958.24
81,420.00
Account: 122-69305-045-000 Capital Leases
59 of 155
February 17, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4
10:44 02/11/20 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 1/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
115,190.36
.00 115,190.36
Capital Leases Totals: 0
127,149.00 Budgeted
11,958.64 Remaining 91 % Used
Department 45 Totals: 457,434.44 ••
61,528.96 Monthly Total 1,214,230.00 Budgeted 756,795.56 Remaining 38 % Used
Fund 122 Totals: (629,804.44)
(397,256.03) Monthly Total .00 Budgeted
60 of 155
629,804.44 Remaining 0 % Used
TROPHY CLUB MUD #1 - O&M (GENERAL FUND)
BALANCE SHEET
JANUARY 2020
February 17, 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,594,636 2,594,636
CASH IN BANK -SAVINGS -CASH RESERVE 1,400,451 1,400,451
INVESTMENTS-TEXPOOL 4,066,755 919,266 4,986,021
PREPAID EXPENSES 75,381 75,381
ADVALOREM PROPERTY TAXES RECEIVABLE 19,651 19,651
UTILITY AND OTHER ACCOUNTS RECEIVABLE 809,277 809,277
TOTAL ASSETS 8,966,751 919,266 9,886,017
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 19,651 19,651
ACCOUNTS AND OTHER PAYABLES 393,299 393,299
CUSTOMER DEPOSITS 318,815 318,815
TOTAL LIABILITIES 731,765 731,765
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 (166,399) (166,399)
TOTAL FUND BALANCE 8,234,985 919,266 9,154,251
TOTAL LIABILITIES AND FUND BALANCE 8,966,751 919,266 9,886,017
61 of 155
February 17, 2020 Regular Meeting Agenda Packet
glbase tbam skrolczyk Trophy Club MUD No.1 Page 3
10:43 02/11/20 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 1/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-
50,730.63- 120,400.36- 89.271 14,470.64-
157.13- 116.99- 38.997 183.01-
47.81- 184.15- 61.383 115.85-
164,253.00-
71
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-
308,153.82- 1,523,137.03- 23.481 4,963,485.97-
255,733.19- 995,260.50- 28.404 2,508,624.50-
8,437.81- 35,066.86- 31.141 77,541.14-
1,400.00- 6,750.00- 44.554 8,400.00-
350.00- 2,150.00- 286.667 1,400.00
650.00- 1,050.00- 42.000 1,450.00-
19.20- 15,068.00- 30.136 34,932.00-
10,171,516.00- 10,171,516.00-
574,744.02- 2,578,482.39- 7,593,033.61-
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-
62 of 155
10,396.30- 41,939.08- 34.949 78,060.92-
3,536.43- 25.000 10,609.57-
583.33- 2,333.32- 33.333 4,666.68-
13,000.00-
1,765.00- 7,120.28- 56.105 5,570.72-
231.52- 8,153.54- 116.479 1,153.54
12,976.15- 110,754.35
638,655.74- 2 7,882,810.46-
638,655.74- 7,882,810.46-
638,655 7,882,810.46-
February 17, 2020 Regular Meeting Agenda Packet
glbase_tbam skrolczyk Trophy Club MUD No.1
10:43 02/11/20 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 1/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 20,000.00 20,000.00
135-55080-010-000 Maintenance & Repairs 100,000.00 100,000.00
135-55085-010-000 Generator Maint. and Repair 3,000.00 3,000.00
135-55090-010-000 Vehicle Maintenance 5,000.00 5,000.00
135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00
135-55120-010-000 Cleaning Services 1,000.00 1,000.00
135-55135-010-000 Lab Analysis 7,500.00 7,500.00
25,800.75 104,419.99
2,257.31 7,647.68
5,082.50
425.00 1,650.00
2,637.53 12,072.53
5,225.04 19,153.58
316.93 1,164.85
48.18 187.93
352.65 1,223.77
1,737.92 7,276.76
406.45 1,701.80
28.48 45.16
771.49 3,085.96
7,256.26 21,176.04
62.41 441.65
920.37
87.50 262.50
200.00 1,347.70
29.812
44.986
129.656
30.556
34.628
22.714
24.653
24.502
39.073
31.167
31.163
4.181
26.042
.121
21.176
8.833
26.296
26.250
17.969
245,847.01
9,352.32
1,162.50-
3,750.00
22,790.47
65,172.42
3,560.15
579.07
1,908.23
16,071.24
3,759.20
1,034.84
8,764.04
400.00
300.00
Page 4
382,126.49
20,000.00
78,823.96
3,000.00
4,558.35
2,579.63
737.50
6,152.30
140,000.00 140,000.00
135-60010-010-000 Communications/Mobiles 5,000.00 5,000.00
135-60020-010-000 Electricity 125,677.00 125,677.00
135-60066-010-000 Publications/Books/Subscripts 1,000.00 1,000.00
135-60070-010-000 Dues & Memberships 500.00 500.00
135-60080-010-000 Schools & Training 7,426.00 7,426.00
135-60090-010-000 Safety Program 400.00 400.00
135-60100-010-000 Travel & per diem 2,845.00 2,845.00
135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00
135-60135-010-000 TCEQ Fees & Permits 63,000.00 63,000.00
135-60150-010-000 Wholesale Water 2,714,710.00 2,714,710.00
135-60245-010-000 Miscellaneous Expenses 200.00 200.00
135-60280-010-000 Property Maintenance 3,000.00 3,000.00
135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00
135-60332-010-000 Interfund Transfer Out -Rev I&S 527,381.00 527,381.00
135-60333-010-000 Interfund Transfer Out -Reserve 55,193.00 55,193.00
135-60334-010-000 Interfund Transfer Out 180,000.00 180,000.00
63 of 155
424.30 2,048.65
5,903.40 39,326.83
111.00 406.00
50.00 14,257.15
118,562.59 468,955.29
462.00
47,943.74 191,774.96
4,600.00 18,400.00
40.973 2,951.35
31.292 86,350.17
1,000.00
500.00
5.467 7,020.00
400.00
2,845.00
1,500.00
22.630 48,742.85
17.275 2,245,754.71
200.00
15.400 2,538.00
14,750.00
36.364 335,606.04
33.338 36,793.00
180,000.00
glbase_tbam skrolczyk
10:43 02/11/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: 1/2020
Program:
February 17, 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 5
2,968,889.40
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,0-474111..._
64 of 155
1,140.42 3,569.35
2,917.33
2,760.11 7,625.15
7,229.50 16,104.78
36,900.00 36,900.00
75,222.00 165,790.03
30,512.00 30,512.00
1,840.00 1,840.00
75,000.00
44,144.38 102,077.11
23.796
56.211
38.126
23.007
42.414
11,430.65
2,272.67
12,374.85
1,200.00
1,000.00
53,895.22
50,100.00
33.661 27
24.207 519,084.97
100.000
56.948 1,391.00
100.000
85.064 17,922.89
538,398.86
,137,539.88
glbase_tbam skrolczyk
10:43 02/11/20
Fund: 135 MUD 1 General Fund
Account Description
1
1 135-55135-010-001
Lab Analysis for PID
February 17, 2020 Regular Meeting Agenda Packet
Trophy Club MUD No.1
Budget Summary with Amendment
Department: 10 Water Program: 1 Lab Analysis for PID
Period Ending: 1/2020
Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
2,000.00 2,000.00
80.00 467.70
23.385 1,532.30
Page
Subtotal:
2,000.00
2,000.00
80.00
467.70
23.385
1,532.30
Program number: 1 Lab Analysis for PID
2,000.00
2,000.00
80.00
467.70
23.385
1,532.30
Department number: Water 5,506,929.00 5,506,929.00
425,037.34 1,367,856.82 24.839 4,139,072.18
65 of 155
February 17, 2020 Regular Meeting Agenda Packet
glbase tbam skrolczyk Trophy Club MUD No.1 Page 7
10:43 02/11/20 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 1/2020
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-50005-020-000 Salaries & Wages
135-50010-020-000 Overtime
135-50016-020-000 Longevity
135-50017-020-000 Certification
135-50020-020-000 Retirement
135-50026-020-000 Medical Insurance
135-50027-020-000 Dental Insurance
135-50028-020-000 Vision Insurance
135-50029-020-000 Life Insurance & Other
135-50030-020-000 Social Security Taxes
135-50035-020-000 Medicare Taxes
135-50040-020-000 Unemployment Taxes
135-50045-020-000 Workman's Compensation
135-50060-020-000 Pre-emp Physicals/Testing
135-50070-020-000 Employee Relations
FSubtotal:
135-55005-020-000 Engqinee ing
135-55070-020-000 Independent Labor
135-55080-020-000 Maintenance & Repairs
135-55081-020-000 Mainten & Repairs Collections
135-55085-020-000 Generator Meant. and Repair
135-55090-020-000 Vehicle Maintenance
135-55091-020-000 Veh Maintenance Collections
135-55105-020-000 Maintenance-Backhoe/SkidLoader
135-55120-020-000 Cleaning Services
135-55125-020-000 Dumpster Services
135-55135-020-000 Lab Analysis
441,799.00 441,799.00
33,000.00 33,000.00
8,035.00 8,035.00
9,000.00 9,000.00
45,531.00 45,531.00
104,858.00 104,858.00
5,817.00 5,817.00
948.00 948.00
4,500.00 4,500.00
30,494.00 30,494.00
7,132.00 7,132.00
1,260.00 1,260.00
15,373.00 15,373.00
400.00 400.00
300.00 300.00
31,950.85 119,177.15 26.975
1,965.55 8,065.27 24.440
6,872.50 85.532
650.00 2,550.00 28.333
3,200.84 14,183.59 31.152
7,738.24 26,051.83 24.845
447.50 1,538.52 26.449
69.74 250.69 26.444
376.31 1,390.36 30.897
1,988.22 7,951.71 26.076
464.99 1,859.66 26.075
34.56 34.56 2.743
1,110.20 4,440.80 28.887
322,621.85
24,934.73
1,162.50
6,450.00
31,347.41
78,806.17
4,278.48
697.31
3,109.64
22,542.29
5,272.34
1,225.44
10,932.20
400.00
300.00
7.00 194,366.64
30,000.00 30,000.00
15,000.00 15,000.00
88,000.00 88,000.00
10,000.00 10,000.00
10,000.00 10,000.00
4,000.00 4,000.00
8,000.00 8,000.00
3,000.00 3,000.00
1,500.00 1,500.00
100,000.00 100,000.00
40,000.00 40,000.00
13,090.25
1,101.29
278.75
3,000.00 20.000
28,715.17 32.631
15,378.45 153.785
682.98 17.075
72.87 1,932.95 24.162
504.68 16.823
262.50 17.500
32,786.78 32.787
12,716.45 31.791
87.50
12,210.28
2,657.31
30,000.00
12,000.00
59,284.83
5,378.45-
10,000.00
3,317.02
6,067.05
2,495.32
1,237.50
67,213.22
27,283.55
135-60010-020-000 Communications/Mobiles 5,000.00 5,000.00 684.87
135-60020-020-000 Electricity 160,067.00 160,067.00 12,730.12
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 440.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 4.13
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
66 of 155
2,270.53 45.411
47,873.47 29.908
111.00 37.000
1,910.85 38.294
109.14 10.914
360.84 23.355
10,088.02 67.253
2,729.47
112,193.53
200.00
189.00
3,079.15
890.86
1,184.16
5,000.00
2,500.00
4,911.98
450.00
5,000.00
February 17, 2020 Regular Meeting Agenda Packet
glbase tbam skrolczyk Trophy Club MUD No.1
10:43 02/11/20 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 1/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
61,260.70
5,750.00
91,284.63
625.22
3,047.71
2,830.97
41,659.24
245,042.20
23,000.00
190.00
372,615.29
2,960.40
3,507.93
9,868.27
4,994.00
1,088.92
10,837.36
14,000.00
36.364 72,903.76
36.364 428,824.80
18.373 102,187.00
180,000.00
9.500 1,810.00
Page 8
28.429 938,053.71
23.683 9,539.60
63.839 1,987.07
49.341 10,131.73
28.537 12,506.00
1,200.00
90.743 111.08
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
67 of 155
51,656.24
59,604.74
6,122.03
3.01
6.79
6.79
145,872.09 27.497 384,627.91
59,604.74 75.322 19,528.26
6,122.03 54.288 5,154.97
130,000.00 100.000
341,598.86 -91 409,311.14
1,037,817.63 ,119,603.37
1,037,817.63 19,603.31
glbase_tbam skrolczyk
10:43 02/11/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: 1/2020
Adopted Amended Total Current
Budget Budget Encumb. Month
30.00
30.00
1.99
Program:
YTD
Total
7.96
February 17, 2020 Regular Meeting Agenda Packet
% of Remaining
Budget Budget
26.533
22.04
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
5.72
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
5.72
851.28
6.449 12,348.72
Program number:
13,230.00
13,230.00
7.71
859.24
6.495
12,370.76
L Department number: Board of Directors
13,230.00 13,230.00
7.71 859.24
6.495 12,370.76
68 of 155
February 17, 2020 Regular Meeting Agenda Packet
glbase_tbam skrolczyk Trophy Club MUD No.1
10:43 02/11/20 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 1/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,152.71 119,116.36 18.959 509,181.64
135-50010-030-000 Overtime 2,000.00 2,000.00 4.75 16.57 .829 1,983.43
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.56 12,732.78 21.745 45,821.22
135-50026-030-000 Medical Insurance 124,394.00 124,394.00 6,345.77 22,812.20 18.339 101,581.80
135-50027-030-000 Dental Insurance 6,464.00 6,464.00 349.75 1,268.95 19.631 5,195.05
135-50028-030-000 Vision Insurance 1,035.00 1,035.00 51.68 197.99 19.129 837.01
135-50029-030-000 Life Insurance & Other 4,500.00 4,500.00 347.91 1,291.54 28.701 3,208.46
135-50030-030-000 Social Security Taxes 39,215.00 39,215.00 1,729.08 7,067.51 18.022 32,147.49
135-50035-030-000 Medicare Taxes 9,171.00 9,171.00 404.39 1,652.92 18.023 7,518.08
135-50040-030-000 Unemployment Taxes 1,440.00 1,440.00 30.16 30.16 2.094 1,409.84
135-50045-030-000 Workman's Compensation 1,775.00 1,775.00 104.82 419.28 23.621 1,355.72
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
42,313.58 171,
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
135-60005-030-000 Telephone
135-60010-030-000 Communications/Mobiles
135-60020-030-000 Electricity/Gas
135-60025-030-000 Water
135-60035-030-000 Postage
135-60040-030-000 Service Charges & Fees
135-60050-030-000 Bad Debt Expense
135-60055-030-000 Insurance
135-60066-030-000 Publications/Books/Subscripts
135-60070-030-000 Dues & Memberships
135-60075-030-000 Meetings
135-60079-030-000 Public Education
135-60080-030-000 Schools & Training
135-60100-030-000 Travel & per diem
135-60110-030-000 Physicals/Testing
135-60115-030-000 Elections
135-60125-030-000 Advertising 2,500.00 2,500.00
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
23,680.00 23,680.00
4,000.00 4,000.00
6,879.00 6,879.00
1,500.00 1,500.00
30,000.00 30,000.00
67,000.00 67,000.00
1,500.00 1,500.00
84,000.00 84,000.00
1,000.00 1,000.00
6,000.00 6,000.00
400.00 400.00
6,000.00 6,000.00
6,850.00 6,850.00
3,545.00 3,545.00
200.00 200.00
69 of 155
51,870.09 125,274.22 93.016
20,788.70 54,824.49 40.611
110.00 1,165.00 7.767
869.06 2,607.18 26.072
775.12 2,474.81 27.498
1,669.83 6,125.59 25.868
237.75 951.81 23.795
690.43 1,282.43 18.643
56.40 241.17 16.078
1,930.85 6,806.80 22.689
5,286.16 26,018.83 38.834
3,415.53 24,431.70 29.085
125.00 12.500
80.00 4,166.55 69.443
61.37 15.343
476.20 7.937
1,152.71 16.828
8.25 695.14 19.609
43.01
9,406.78
80,175.51
13,835.00
10,000.00
7,392.82
65,600.00
6,525.19
192-79
17,554.41
3,048.19
5,596.57
1,258.83
23,193.20
40,981.17
1,500.00
59,568.30
875.00
1,833.45
338.63
5,523.80
5,697.29
2,849.86
200.00
43.01-
2,500.00
February 17, 2020 Regular Meeting Agenda Packet
glbase_tbam skrolczyk Trophy Club MUD No.1
10:43 02/11/20 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 1/2020
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-60235-030-000
135-60245-030-000
135-60246-030-000
135-60360-030-000
Security
Miscellaneous Expenses
General Manager Contingency
Furniture/Equipment < $5000
1,288.00 1,288.00
500.00 500.00
17,000.00 17,000.00
2,500.00 2,500.00
135-65010-030-000 Uniforms 2,050.00 2,050.00
135-65055-030-000 Hardware 26,485.00 26,485.00
135-65085-030-000 Office Supplies 6,000.00 6,000.00
135-65090-030-000 Printer Supplies & Maintenance 3,500.00 3,500.00
135-65095-030-000 Maintenance Supplies 4,000.00 4,000.00
135-65105-030-000 Printing 2,500.00 2,500.00
135-69005-030-000 Capital Outlays
135-69170-030-000 Copier Lease Installments
Program number:
Department number: Administration
195,000.00
4,000.00
195,000.00
4,000.00
000.00
712.00
.712.00
70 of 155
24.00
96.00 7.453
13,399.20 72,674.31
188.73
1,175.74
1,364.47
241.68
241.68
131,731.90
131,731.90
3,235.24 12.215
1,866.47 31.108
2,396.62 59.916
7,498.33
1,037.66
1,037.66
25.942
439,447.86 24.734
439,447.86
1,192.00
500.00
17,000.00
2,500.00
2,050.00
23,249.76
4,133.53
3,500.00
1,603.38
2,500.00
195,000.00
2,962.34
1,337,264
24.734 1,337
Page 11
glbase_tbam skrolczyk
10:43 02/11/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
February 17, 2020 Regular Meeting Agenda Packet
Trophy Club MUD No.1
Budget Summary with Amendment
Department: 39 Non Departmental Program:
Period Ending: 1/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,728.50
12,563.27
46,036.39
27,713.27
5,178.56
3,756.00
34.101
81.992
44.032
93.900
88,963.61
6,086.73
6,582.44
244.00
Page 12
71 of 155
ir Subtotal: '
184,561.00
184,561.00
23,291.77
82,684.22
44.800
101,876.78
Program number:
184,561.00
184,561.00
23,291.77
82,684.22
44.800
101,876.78
Department number: Non Departmental
184,561.00
184,561.00
23,291.77
82,684.22
44.800
101,876.78
Expenditures Subtotal
10,638,853.00
10,638,853.00
874,735.51
2,928,665.77
27.528
7,710,187.23
Fund number: 135 MUD 1 General Fund
6,224.00-
6,224.00-
236,079.77
166,399.23
-2,673.509
172,623.23-
71 of 155
February 17, 2020 Regular Meeting Agenda Packet
glbase tbam skrolczyk Trophy Club MUD No.1 Page 13
10:43 02/11/20 Budget Summary with Amendment
Fund: 137 MUD 1 Consolidated GASS Department: Program:
Period Ending: 1/2020
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
137-49145-000-000 Intergov Transfer -General Fund 205,000.00- 205,000.00
137-49146-000-000 Intergov Transfer -Fire Dept 81,420.00- 81,420.00
Subtot 286,
H
Program number: 286,420.00- 286,420.00
Department number: 286,420.00- 286,420.00
Revenues Subtotal 286,420.00- 286,420.00
Fund number: 137 MUD 1 Consolidated GASB 286,420.00- 286,420.00
72 of 155
glpdatb2 skrolczyk
10:44 02/11/20
Fund: 135 MUD 1 General Fund
JE JE JE
Number Date Description
Account: 135-40000-000-
670 01/02/2020 Property Taxes
671 01/03/2020 Property Taxes
672 01/06/2020 Property Taxes
673 01/07/2020 Property Taxes
674 01/08/2020 Property Taxes
691 01/09/2020 Property Taxes
692 01/10/2020 Property Taxes
693 01/13/2020 Property Taxes
694 01/14/2020 Property Taxes
695 01/15/2020 Property Taxes
696 01/16/2020 Property Taxes
697 01/17/2020 Property Taxes
698 01/21/2020 Property Taxes
699 01/22/2020 Property Taxes
700 01/23/2020 Property Taxes
701 01/24/2020 Property Taxes
704 01/27/2020 Property Taxes
705 01/28/2020 Property Taxes
706 01/29/2020 Property Taxes
707 01/30/2020 Property Taxes
708 01/31/2020 Property Taxes
40000-000-000
Account: 135-40002-000-00
670 01/02/2020 Property Taxes
671 01/03/2020 Property Taxes
673 01/07/2020 Property Taxes
692 01/10/2020 Property Taxes
695 01/15/2020 Property Taxes
699 01/22/2020 Property Taxes
704 01/27/2020 Property Taxes
February 17, 2020 Regular Meeting Agenda Packet
Trophy Club MUD No.1 Page 5
Detailed Accounting Trial Balance
Department: Revenues Program:
Period Ending: 1/2020
JE Detail Beginning Transaction Transaction Vendor Name Check Source
Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Property Taxes
(134,871.00) Budgeted
(300.00) Budgeted
(69,669.73) (2,668.76) (72,338.49) GL
(1,706.26) (74,044.75) GL
(1,407.36) (75,452.11) GL
(2,650.28) (78,102.39) GL
(2,508.04) (80,610.43) GL
(691.96) (81,302.39) GL
(1,266.76) (82,569.15) GL
(968.05) (83,537.20) GL
(522.02) (84,059.22) GL
(2,845.58) (86,904.80) GL
(948.00) (87,852.80) GL
(1,289.49) (89,142.29) GL
(620.39) (89,762.68) GL
(1,327.25) (91,089.93) GL
(1,196.92) (92,286.85) GL
(9,477.64) (101,764.49) GL
(2,541.87) (104,306.36) GL
(11,661.77) (115,968.13) GL
(1,513.18) (117,481.31) GL
(1,424.56) (118,905.87) GL
(1,494.49) (120,400.36) GL
(14,470.64) Remaining 89 % Used
40.14 (2.17) 37.97 GL
(.43) 37.54 GL
(1.68) 35.86 GL
(4.99) 30.87 GL
(133.88) (103.01) GL
(11.36) (114.37) GL
(2.62) (116.99) GL
(183.01) Remaining 39 % Used
Property Taxes/P & I
670 01/02/2020 Property Taxes (136.34)
672 01/06/2020 Property Taxes
73 of 155
(6.74) (143.08) GL
(.86) (143.94) GL
February 17, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 6
10:44 02/11/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 1/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
673 01/07/2020 Property Taxes
674 01/08/2020 Property Taxes
691 01/09/2020 Property Taxes
692 01/10/2020 Property Taxes
695 01/15/2020 Property Taxes
696 01/16/2020 Property Taxes
697 01/17/2020 Property Taxes
699 01/22/2020 Property Taxes
700 01/23/2020 Property Taxes
701 01/24/2020 Property Taxes
704 01/27/2020 Property Taxes
5-40015-001.1
Account: 135-40025-000-000
J
Account: 135-40025-000-000 AMM
Property Taxes/P & I
(300.00) Budgeted
PID Surcharges
PID Surcharges Totals:
(136.34) (.38) (144.32) GL
(.21) (144.53) GL
(1.68) (146.21) GL
(2.56) (148.77) GL
(32.20) (180.97) GL
(.12) (181.09) GL
(.08) (181.17) GL
(1.80) (182.97) GL
(.03) (183.00) GL
(.65) (183.65) GL
(.50) (184.15) GL
(115.85) Remaining 61 % Used
(164,253.00) Budgeted
Account: 135-
511
01/06/2020 UB 01/06/2020 Bill adjustment
664 01/31/2020 UB 01/31/2020 Billing
Account: 135
.00 .00
(164,253.00) Remaining 0 % Used
UB20200106-20200106 User:
UB20200131-20200131 User:
(6,486,623.00) Budgeted
(1,214,983.21) 34.11 (1,214,949.10)
(308,187.93) (1,523,137.03)
(4,963,485.97) Remaining 23 % Used
Account: 135-47005-00 Sewe
511 01/06/2020 UB 01/06/2020 Bill adjustment UB20200106-20200106 User:
664 01/31/2020 UB 01/31/2020 Billing UB20200131-20200131 User:
Account: 135-47005-000-000
Account:
(739,527.31)
(3,503,885.00) Budgeted (2,508,624.50) Remaining
Penalt
526 01/07/2020 UB 01/07/2020 Penalty removal UB20200107-20200107 User:
606 01/20/2020 UB 01/20/2020 Penalty removal UB20200120-20200120 User:
617 01/21/2020 UB 01/21/2020 Penalties UB20200121-20200121 User:
28 % Used
(26,629.05)
74 of 155
43.00
(255,776.19)
108.64
40.34
(9,257.00)
(739,484.31)
(995,260.50)
(26,520.41)
(26,480.07)
(35,737.07)
UB
UB
UB
UB
UB
UB
February 17, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 7
10:44 02/11/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 1/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
636 01/27/2020 UB 01/27/2020 Penalty removal UB20200127-20200127 User:
650 01/30/2020 UB 01/30/2020 Penalty Removal UB20200130-20200130 User:
652 01/30/2020 UB 10/30/2020 Penalty removal UB20200130-20200130 User:
(26,629.05) 397.35 (35,339.72) UB
256.10 (35,083.62) UB
16.76 (35,066.86) UB
Account: 135-47025-000-000
■
Penalties Totals:
(8,437.81) (35,066.86) **
(112,608.00) Budgeted
(77,541.14) Remaining 31 % Used
Account: 135-47030-000-000 Service Chargee
541 01/02/2020 UB 01/02/2020 NSF Check UB20200102-20200102 User:
521 01/07/2020 UB 07/07/2020 Disconnect Fees UB20200107-20200107 User:
575 01/13/2020 UB 01/13/2020 DF adjustment UB20200113-20200113 User:
619 01/21/2020 UB 01/21/2020 NSF Check UB20200121-20200121 User:
620 01/22/2020 UB 01/22/2020 NSF Check UB20200122-20200122 User:
624 01/22/2020 UB 01/22/2020 NSF Check UB20200122-20200122 User:
(5,350.00) (25.00) (5,375.00) UB
(1,350.00) (6,725.00) UH
50.00 (6,675.00) UH
(25.00) (6,700.00) UH
(25.00) (6,725.00) UH
(25.00) (6,750.00) UH
Account: 135-47030-000-000
Service Charges Totals:
(1,400.00) (6,750.00) **
(15,150.00) Budgeted
(8,400.00) Remaining 45 % Used
Account: 135-47035-000-000 Plumbing Inspections
654 01/02/2020 Permits 25 KATIE LANE
654 01/02/2020 Permits 27 KATIE LANE
655 01/02/2020 permits 3
655 01/02/2020 permits 32 KATIE LANE
655 01/02/2020 permits 3
687 01/05/2020 Permits -25/27 Katie Lane 25 Katie Lane
687 01/05/2020 Permits -25/27 Katie Lane 27 Katie Lane
(1,800.00) (50.00) (1,850.00) Drees Homes CR
(50.00) (1,900.00) DREES HOMES CR
(50.00) (1,950.00) DREES HOMES CR
(50.00) (2,000.00) DREES HOMES CR
50.00 (1,950.00) DREES HOMES CR
(50.00) (2,000.00) Drees Homes CR
(150.00) (2,150.00) Drees Homes CR
Account: 135-47035-000-000
Plumbing Inspections Totals: 1.1 (350.00) (2,150.00) **
(750.00) Budgeted
1,400.00 Remaining 287 % Used
Account: 135-47045-000-000 Sewer Inspections
654 01/02/2020 Permits
654 01/02/2020 Permits
655 01/02/2020 permits
655 01/02/2020 permits
655 01/02/2020 permits
687 01/05/2020 Permits -25/27 Katie Lane
687 01/05/2020 Permits -25/27 Katie Lane
25 KATIE LANE
27 KATIE LANE
3
32 KATIE LANE
3
25 Katie Lane
27 Katie Lane
(400.00)
(150.00)
(150.00)
(150.00)
(150.00)
150.00
(150.00)
(50.00)
(550.00) Drees Homes
(700.00) DREES HOMES
(850.00) DREES HOMES
(1,000.00) DREES HOMES
(850.00) DREES HOMES
(1,000.00) Drees Homes
(1,050.00) Drees Homes
CR
CR
CR
CR
CR
CR
CR
Account: 135-47045-000-000
Sewer Inspections Totals: (650.00) (1,050.00) **
(2,500.00) Budgeted
(1,450.00) Remaining 42 % Used
75 of 155
glpdatb2 skrolczyk
10:44 02/11/20
Fund: 135 MUD 1 General Fund
JE JE JE
Number Date Description
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: Revenues
Period Ending: 1/2020
JE Detail
Description/Comment
February 17, 2020 Regular Meeting Agenda Packet
Page 8
Program:
Beginning Transaction Transaction Vendor Name
Balance Detail Detail
(SUBTOTAL)
Check Source
Number
654 01/02/2020 Permits
654 01/02/2020 Permits
655 01/02/2020 permits
655 01/02/2020 permits
655 01/02/2020 permits
25 KATIE LANE
27 KATIE LANE
3
32 KATIE LANE
3
(5,355.28)
76 of 155
(353.00)
(353.00)
(343.00)
(353.00)
343.00
(5,708.28) Drees Homes
(6,061.28) DREES HOMES
(6,404.28) DREES HOMES
(6,757.28) DREES HOMES
(6,414.28) DREES HOMES
CR
CR
CR
CR
CR
Account:
135-47070-000-000
TCCC Effluent Charges
664 01/31/2020
UB 01/31/2020
Billing UB20200131-20200131 User: (15,048.80)
(19.20)
(15,068.00)
UB
Account:
135-47070-000-000
TCCC Effluent Charges Totals:
19.20)
(15,068.00)
**
(50,000.00) Budgeted (34,932.00) Remaining 30 %
Used
Account:
135-49011-000-000
,
Interest Income
724 01/31/2020
724 01/31/2020
724 01/31/2020
Bank Interest-
Bank Interest-
Bank Interest-
January (31,542.78)
January
January
(1,238.68)
(1,066.75)
(8,090.87)
(32,781.46)
(33,848.21)
(41,939.08)
GL
GL
GL
Account:
135-49011-000-000
■
' Interest Income Totals:
(10,396.30)
(41,939.08)
**
(120,000.00) Budgeted (78,060.92) Remaining
35 5
Used
Account:
135-49016-000-000
Cell Tower Revenue
(3,536.43)
.00
(3,536.43)
Account:
135-49016-000-000
Cell Tower Revenue Totals:
.00
(3,536.43)
**
(14,146.00) Budgeted (10,609.57) Remaining
25 5
Used
Account:
135-49018-000-000
Building Rent Income
733 01/31/2020
Town Billed Invoices 1722-1725 AR 20200131-20200131 User:
(1,749.99)
(583.33)
(2,333.32)
AR
Account:
135-49018-000-000
Building Rent Income Totals:
(583.33)
(2,333.32)
**
(7,000.00) Budgeted (4,666.68) Remaining
33 5
Used
Account:
135-49026-000-000
Proceeds from Sale of Assets
.00
.00
Account:
135-49026-000-000
Proceeds from Sale of Assets Totals:
.00
.00
**
(13,000.00) Budgeted (13,000.00) Remaining
0 %
Used
Account:
135-49075-000-000
Oversize Meter Reimbursement
654 01/02/2020 Permits
654 01/02/2020 Permits
655 01/02/2020 permits
655 01/02/2020 permits
655 01/02/2020 permits
25 KATIE LANE
27 KATIE LANE
3
32 KATIE LANE
3
(5,355.28)
76 of 155
(353.00)
(353.00)
(343.00)
(353.00)
343.00
(5,708.28) Drees Homes
(6,061.28) DREES HOMES
(6,404.28) DREES HOMES
(6,757.28) DREES HOMES
(6,414.28) DREES HOMES
CR
CR
CR
CR
CR
February 17, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 9
10:44 02/11/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 1/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
687 01/05/2020 Permits -25/27 Katie Lane
687 01/05/2020 Permits -25/27 Katie Lane
Accal1111035-4907
25 Katie Lane
27 Katie Lane
(5,355.28)
(353.00) (6,767.28) Drees Homes
(353.00)
(7,120.28) Drees Homes
Oversize Meter Reimbursement Totals: '0.28) **
(12,691.00) Budgeted (5,570.72) Remaining
Account: 135-49900-000-000 Miscellaneous Income
680 01/10/2020 Rfd of deposit for portable me UB20200110-20200110 User:
664 01/31/2020 UB 01/31/2020 Billing UB20200131-20200131 User:
Account: 135-49900-000-000
Miscellaneous Income
(7,000.00) Budgeted
56 % Used
CR
CR
(7,922.02) (.30) (7,922.32) UB
(231.22) (8,153.54) UB
1,153.54 Remaining 116 % Used
(8,153.54) **
Department Totals: (2,762,266.54) **
(638,655.74) Monthly Total (10,645,077.00) Budgeted (7,882,810.46) Remaining 26 % Used
77 of 155
glpdatb2 skrolczyk Trophy Club MUD No.1
10:44 02/11/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 1/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
February 17, 2020 Regular Meeting Agenda Packet
Page 10
Account: 135-50005-010-000 Salaries & Wages
513 01/10/2020 MUD Payroll 1/10/2020 Salaries & Wages
611 01/24/2020 MUD Payroll 1/24/2020 Salaries & Wages
78,619.24 12,900.38 91,519.62 PR
12,900.37 104,419.99 PR
Account: 135-50005-010-000
Salaries & Wages Totals: 25,800.75 104,419.99 **
350,267.00 Budgeted
245,847.01 Remaining 30 % Used
Account: 135-50010-010-000 Overtime
513 01/10/2020 MUD Payroll 1/10/2020 Overtime 5,390.37 981.83 6,372.20 PR
611 01/24/2020 MUD Payroll 1/24/2020 Overtime 1,275.48 7,647.68 PR
Account: 135-50010-010-000
Overtime Totals: 2,257.31 7,647.68 **
17,000.00 Budgeted
9,352.32 Remaining 45 % 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
611 01/24/2020 MUD Payroll 1/24/2020 Certification 1,225.00 425.00 1,650.00 PR
Account: 135-50017-010-000
Certification Totals: 425.00 1,650.00 **
5,400.00 Budgeted
3,750.00 Remaining 31 5 Used
Account: 135-50020-010-000 Retirement
513 01/10/2020 MUD Payroll 1/10/2020
611 01/24/2020 MUD Payroll 1/24/2020
Retirement
Retirement
9,435.00 1,285.49 10,720.49 PR
1,352.04 12,072.53 PR
Account: 135-50020-010-000
Retirement Totals: 2,637.53 12,072.53 **
34,863.00 Budgeted
22,790.47 Remaining 35 % Used
Account: 135-50026-010-000 Medical Insurance
513 01/10/2020 MUD Payroll 1/10/2020
Medical Insurance 13,928.54
611 01/24/2020 MUD Payroll 1/24/2020 Medical Insurance
2,612.55 16,541.09 PR
2,612.49 19,153.58 PR
Account: 135-50026-010-000
Medical Insurance Totals: 5,225.04 19,153.58 **
84,326.00 Budgeted
65,172.42 Remaining 23 5 Used
78 of 155
glpdatb2 skrolczyk Trophy Club MUD No.1
10:44 02/11/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 1/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
February 17, 2020 Regular Meeting Agenda Packet
Page 11
ACOOunt: 135-50027}0- ental IneuI
513 01/10/2020 MUD Payroll 1/10/2020 Dental Insurance
611 01/24/2020 MUD Payroll 1/24/2020 Dental Insurance
Account: - Dental Ineuranc Totals:
4,725.00 Budgeted 3,560.15 Remaining
Account: 135-50028-010-000 Vision Insurance
513 01/10/2020 MUD Payroll 1/10/2020 Vision Insurance
611 01/24/2020 MUD Payroll 1/24/2020 Vision Insurance
847.92 158.47 1,006.39 PR
158.46 1,164.85 PR
1
25 % Used
139.75 24.10 163.85 PR
24.08 187.93 PR
Account: 135-50028-01C1 Vision Insurance Totals:
767.00 Budgeted
579.07 Remaining 25 % Used
Life Insurance & Other
432 01/01/2020 Payroll Benefits January
452 01/01/2020 Payroll Benefits January
646 01/29/2020 January A/P
Employee Benefits
Employee LTD & STD
caf 125 -December
871.12 200.64 1,071.76 Humana Inc
132.01 1,203.77 METLIFE GROUP BENEFITS
20.00 1,223.77 BenefitMall
6035 AP
6042 AP
6128 AP
Account: 135-50029-010-000
Life Insurance & Other Totals:
Account: 135-50030-010-000
513 01/10/2020 MUD Payroll 1/10/2020
611 01/24/2020 MUD Payroll 1/24/2020
Account:
513 01/10/2020 MUD Payroll 1/10/2020
611 01/24/2020 MUD Payroll 1/24/2020
3,132.00 Budgeted
1,908.23 Remaining 39 % Used
Social Security Taxes
Social Security Taxes
Social Security Taxes
Social S-
23,348.00 Budgeted
Medicare Taxes
Medicare Taxes
Medicare Taxes
Account: Medicare Taxe,
m.
5,461.00 Budgeted
Account: 135-50
513 01/10/2020 MUD
Payroll 1/10/2020
16,071.24
Unemployment Taxes
Remaining
3,759.20 Remaining
5,538.84
31
1,295.35
848.22
889.70
Used
6,387.06
7,276.76
198.38 1,493.73
208.07 1,701.80
31 % Used
16.68
79 of 155
13.88
30.56
PR
PR
PR
PR
PR
glpdatb2 skrolczyk Trophy Club MUD No.1
10:44 02/11/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 1/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
February 17, 2020 Regular Meeting Agenda Packet
Page 12
611 01/24/2020 MUD Payroll 1/24/2020 Unemployment Taxes
16.68 14.60
Account: 135-50040-010-8 Unemployment Taxes T 28
1,080.00 Budgeted
Account: 135-50045-010-00 Workman's Compensation
69 01/01/2020 Insurance/Wrk Comp Expense Jan
Account: 135-50045-010-006 Compensation
11,850.00 Budgeted
1,034.84 Remaining 4 % Used
2,314.47 771.49
8,764.04 Remaining 26 % Used
45.16 PR
3,085.96 GL
Account: 135-50060-010-000 � Pre-emp Physicals/Testing
.00 .00
Account: 135-50060-010-000 * Pre-emp Physicals/Testing Tota
400.00 Budgeted 400.00 Remaining 0 % Used
Account: 135-50070-010-000 Employee Relations
.00 .00
Account: 135-50070-010-000 Employee Relations Totals:
300.00 Budgeted 300.00 Remaining 0 % Used
Account: 135-55005-010-000 Engineering
.00 .00
Account: 135-55005-010-000 Engineering Totals:
20,000.00 Budgeted 20,000.00 Remaining 0 % Used
Account: 135-55080-010-000 Maintenance & Repairs
596 01/17/2020 January A/P masin break repair -Inverness & 13,919.78 4,375.00 18,294.78 REY-MAR CONSTRUCTION 6115 AP
596 01/17/2020 January A/P water clamps 464.00 18,758.78 Core & Main LP 6094 AP
653 01/26/2020 PCards 12/27/2019-01/26/2020 door handle for breakroom 14.09 18,772.87 AMAZON.COM*AG9SJ5XM3 PC
653 01/26/2020 PCards 12/27/2019-01/26/2020 paint, cement, tape 157.87 18,930.74 THE HOME DEPOT *6581 PC
646 01/29/2020 January A/P antenna @ TW Ring Tank 1,965.30 20,896.04 DHS AUTOMATION, INC 6132 AP
646 01/29/2020 January A/P blue marking flags 100.00 20,996.04 Core & Main LP 6130 AP
723 01/31/2020 January A/P parts 180.00 21,176.04 Core & Main LP AP
80 of 155
glpdatb2 skrolczyk
10:44 02/11/20
Fund: 135 MUD 1 General Fund
JE JE JE
Number Date Description
Account: 135-55085-010-000
Account: 135-55085-010-000
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: 10 Water Program:
Period Ending: 1/2020
JE Detail
Description/Comment
February 17, 2020 Regular Meeting Agenda Packet
Page 13
Beginning Transaction Transaction Vendor Name Check Source
Balance Detail Detail Number
(SUBTOTAL)
Maintenance & Repairs
100,000.00 Budgeted 78,823.96 Remaining
Generator Maint. and Repair
21 % Used
.00
Generator Maint. and Repair Totals:
3,000.00 Budgeted 3,000.00 Remaining
Account: 135- Vehicle Maintenance
653 01/26/2020 PCards 12/27/2019-01/26/2020 windshield wipers
658 01/27/2020 PCards 1/27/2020 trailer wire, connector
Account: 135-55090-010-000
Account: 135-55105-010-000
Account: 135-55105-010-000
Vehicle Maintenance Totals:
5,000.00 Budgeted
0 % Used
.00
379.24 39.98 419.22 AUTOZONE #4206 PC
22.43 441.65 ROANOKE AUTO SUPPLY LT PC
4,558.35 Remaining 9 % Used
■ Maintenance-Backhoe/SkidLoader
920.37
Maintenance-Backhoe/SkidLoader Totals: i
3,500.00 Budgeted 2,579.63 Remaining 26 % Ueed
Account: 135-55120-010-000 - Cleanin
646 01/29/2020 January A/P
Janitorial svc-December
Account: 135-55120-010-000 Cleaning Services otals:
1,000.00 Budgeted 737.50 Remaining
Account: 135-55135-010-000
596 01/17/2020 January A/P
Account: 135-55135-010-000
Account: 135-6'
597 01/20/2020
January A/P
Lab Analysis
water samples
Lab Analysis
7,500.00 Budgeted
6,152.30 Remaining
cell phones -January
175.00
.00 920.37
87.50
26 % Used
262.50
MEMBER'S BUILDING MAINTENANCE
6144
AP
1,147.70 200.00 1,347.70 TARRANT CTY PUBLIC HEALTH LAB 6116 AP
18 % Used
1,624.35
81 of 155
424.30
2,048.65
VERIZON WIRELESS
6124
AP
glpdatb2 skrolczyk Trophy Club MUD No.1
10:44 02/11/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 1/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
February 17, 2020 Regular Meeting Agenda Packet
Page 14
Accamp
Account:
Communications/Mobiles
5,000.00 Budgeted
Electric
2,951.35 Remaining 41 % Used
598 01/20/2020 January A/P Electricity 12/10-1/10
Electricity Totals:
125,677.00 Budgeted 86,350.17 Remaining
Account: 135-60066-010-000 lir Publications/Books/Subscripts
Account: 135-60066-010-000
Account: 135-60070-010-000
Publications/Books/Subscripts Totals:
1,000.00 Budgeted 1,000.00 Remaining
Dues & Memberships
Account: 135-60070-010-00 Dues & Memberships
500.00 Budgeted
Account: 135-60080-010-
choole & Traini
653 01/26/2020 PCards 12/27/2019-01/26/2020
Account: 135-60080-0
Account: 135-60090-01
Account: 135-60090-010-000
Account: 135-60100-010-000
500.00 Remaining
Clayton Water License
7,426.00 Budgeted
Safety Program
Safety Program
400.00 Budgeted
Travel & per diem
7,020.00 Remaining
33,423.43 5,903.40
295.00
31 % Used
0 % Used
0 % Used
2,048.65 **
39,326.83 HUDSON ENERGY SERVICES, LLC 6104 AP
5,903.40 39,326.83 **
.00 .00
.00 **
.00 .00
111.00
5 % Used
406.00
.00 .00
400.00 Remaining 0 % Used
82 of 155
.00 .00
TCEQ EPAYMENT
PC
glpdatb2 skrolczyk
10:44 02/11/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: 1/2020
Beginning
Balance
February 17, 2020 Regular Meeting Agenda Packet
Page 15
Program:
Transaction Transaction Vendor Name
Detail Detail
(SUBTOTAL)
Check Source
Number
83 of 155
Account:
135-60100-010-000
Travel & per diem Totals:
.00
.00
**
2,845.00 Budgeted 2,845.00 Remaining 0 5
Used
Account:
135-60105-010-000
Rent/Lease Equipment
.00
.00
Account:
135-60105-010-000
Rent/Lease Equipment Totals:
.00
.00
**
1,500.00 Budgeted 1,500.00 Remaining 0 5
Used
Account:
135-60135-010-000
TCEQ Fees & Permits
646 01/29/2020 January A/P
TIER 2 Submittal 14,207.15
50.00
14,257.15
TX COMMISSION ENVIRONMENTAL
QU
6154
AP
Account:
135-60135-010-000
TCEQ Fees & Permits Totals:
50.00
14,257.15
**
63,000.00 Budgeted 48,742.85 Remaining 23 %
Used
Account:
135-60150-010-000
Wholesale Water
651 01/30/2020 January A/P
wholesale water 350,392.70
118,562.59
468,955.29
CITY OF FORT WORTH
6129
AP
Account:
135-60150-010-000
Wholesale Water Totals:
118,562.59
468,955.29
**
2,714,710.00 Budgeted 2,245,754.71 Remaining 17 5
Used
Account:
135-60245-010-000
M Miscellaneous Expenses
.00
.00
Account:
135-60245-010-000
Miscellaneous Expenses Totals:
.00
.00
**
200.00 Budgeted 200.00 Remaining 0 %
Used
Account:
135-60280-010-000
Property Maintenance
462.00
.00
462.00
Account:
135-60280-010-000
Property Maintenance Totals:
.00
462.00
**
3,000.00 Budgeted 2,538.00 Remaining 15 %
Used
Account:
135-60285-010-000
Lawn Equipment & Maintenance
.00
.00
83 of 155
glpdatb2 skrolczyk
10:44 02/11/20
Fund: 135 MUD 1 General Fund
Account
JE JE JE
Number Date Description
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: 10 Water Program:
Period Ending: 1/2020
JE Detail
Description/Comment
February 17, 2020 Regular Meeting Agenda Packet
Page 16
Beginning Transaction Transaction Vendor Name Check Source
Balance Detail Detail Number
(SUBTOTAL)
Lawn Equipment & Maintenance Totals:
14,750.00 Budgeted 14,750.00 Remaining
LInterfund Transfer Out -Rev I&S
645 01/30/2020 TexPool Transfers January TexPool O&M to 16Swift Rev I&S
645 01/30/2020 TexPool Transfers January TexPool O&M to 19 W&WW Rev I&S
Account: 135-60331 Interfund Transfer Out -
527,381.00 Budgeted
Account: 115-60133-010-000 Interfund
335,606.04
143,831.22
Remaining
645 01/30/2020 TexPool Transfers January TexPool O&M to Rev Bond Resevr
Accoun r Out -Reserve Tota
55,193.00 Budgeted 36,793.00 Remaining
Account: 135-60334-010-000
Account: 135-60334-010-000
Account: 135-60360-010-000
Account: 135-60360-010-000
Account: 135-65005-010-000
640 01/24/2020 Fuel
Account: 135-65005-010-000
Account: 135-65010-010-000
Interfund Transfer Out
Interfund Transfer Out Totals:
180,000.00 Budgeted 180,000.00 Remaining
Furniture/Equipment < $5000
0 % Used
25,047.72 168,878.94
22,896.02
36 % Used
191,774.96
GL
GL
13,800.00 4,600.00 18,400.00 GL
33 % Ueed
.00 .00
0 % Ueed
561.72 .00 561.72
Furniture/Equipment < $5000 Totals: .00
2,500.00 Budgeted 1,938.28 Remaining 22 % Used
AIL Al & Lube
Fuel -JAN 2,428.93 1,140.42 3,569.35 US Bank Voyager Fleet Systeme 6155 AP
1,140.42
15,000.00 Budgeted 11,430.65 Remaining 24 % Used
2,917.33 .00 2,917.33
84 of 155
glpdatb2 skrolczyk
10:44 02/11/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: 1/2020
Beginning
Balance
February 17, 2020 Regular Meeting Agenda Packet
Page 17
Program:
Transaction Transaction Vendor Name
Detail Detail
(SUBTOTAL)
Check Source
Number
85 of 155
Account:
135-65010-010-000
Uniforms
Totals:
.00
2,917.33
**
5,190.00 Budgeted
2,272.67 Remaining
56 5
Used
Account:
135-65030-010-000
Chemical=
596 01/17/2020
651 01/30/2020
723 01/31/2020
January A/P
January A/P
January A/P
testing supplies
chlorine
Testing supplies
4,865.04
977.77
558.40
1,223.94
5,842.81
6,401.21
7,625.15
HACH COMPANY
DPC INDUSTRIES, INC
HACH COMPANY
6103
6133
AP
AP
AP
Account:
135-65030-010-000
`
Chemicals
Totals:
2,760.11
7,625.15
**
20,000.00 Budgeted
12,374.85 Remaining
38 %
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 5
Used
Account:
135-65040-010-000
Safety Equipment
.00
.00
Account:
135-65040-010-000
Safety Equipment
Totals:
.00
.00
**
1,000.00 Budgeted
1,000.00 Remaining
0 %
Used
Account:
135-65050-010-000
Meter Expense
596 01/17/2020
596 01/17/2020
January A/P
January A/P
meters
meters
8,875.28
2,970.00
4,259.50
11,845.28
16,104.78
ATLAS UTILITY SUPPLY
ATLAS UTILITY SUPPLY
CO.
CO.
6092
6092
AP
AP
Account:
135-65050-010-000
Meter Expense
Totals:
7,229.50
16,104.78
**
70,000.00 Budgeted
53,895.22 Remaining
23 5
Used
Account:
135-65053-010-000
Meter Change Out Program
596 01/17/2020
January A/P
meter heads
36,900.00
36,900.00
ATLAS UTILITY SUPPLY
CO.
6092
AP
Account:
135-65053-010-000
Meter Change Out Program
Totals:
36,900.00
36,900.00
**
87,000.00 Budgeted
50,100.00 Remaining
42 5
Used
Account:
135-69005-010-000
Capital Outlays
85 of 155
glpdatb2 skrolczyk Trophy Club MUD No.1
10:44 02/11/20
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 1/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
February 17, 2020 Regular Meeting Agenda Packet
Page 18
596 01/17/2020 January A/P well #1
646 01/29/2020 January A/P LS upgrades FY 19
646 01/29/2020 January A/P easement
90,568.03
58,645.00
9,125.00
7,452.00
149,213.03 MILLICAN WELL SERVICE, LLC
158,338.03 DHS AUTOMATION, INC
165,790.03 Jackson Walker LLP
6111 AP
6132 AP
6138 AP
Account: 135
Capital Outlays Totals:
684,875.00 Budgeted
519,084.97 Remaining 24 % Used
Account: 135-69008-010-000 Alb Short Term Debt -Principal
646 01/29/2020 January A/P
Vaccon P & I payment
Account: 135-69008-010-000 Short Term Debt -Principal
30,512.00 Budgeted
30,512.00
Totals:
Account: 135-69009-010-000 IlLriferm Debt -Interest
646 01/29/2020 January A/P Vaccon P & I payment
Account: 135-69009-010-000
Account: 135-69195-010-000
.00 Remaining 100 % Used
Short Term Debt -Interest Totals:
3,231.00 Budgeted 1,391.00 Remaining
Gasb34/Reserve for Replacement
Account: 135-69195-010-000 mil Gasb34/Reserve for Replacement Totals:
75,000.00 Budgeted .00 Remaining
596 01/17/2020 January A/P
596 01/17/2020 January A/P
Account: 135-69281-010-000
Water Tank Inspection Contract
PID tank inspection
tank contract
Water Tank Inspection Contract Total
120,000.00 Budgeted 17,922.89 Remaining
75,000.00
57 % Used
1,840.00
1,840.00
30,512.00 FIRST FINANCIAL BANK
1,840.00 FIRST FINANCIAL BANK
.00 75,000.00
100 % Used
57,932.73 2,200.00
41,944.38
85 % Used
86 of 155
6134 AP
6134 AP
60,132.73 UTILITY SERVICE CO, INC. 6122 AP
102,077.11 UTILITY SERVICE CO, INC. 6122 AP
glpdatb2 skrolczyk
10:44 02/11/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: 1/2020
Beginning Transaction Transaction Vendor Name Check Source
Balance Detail Detail Number
(SUBTOTAL)
February 17, 2020 Regular Meeting Agenda Packet
Page 19
JE Detail
Description/Comment
Account: 135-55135-010-001 Lab Analysis for PID
596 01/17/2020 January A/P water samples
387.70 80.00 467.70 TARRANT CTY PUBLIC HEALTH LAB 6116 AP
Account: 135-55135-010-001
Lab Analysis for PID Totals: 80.00 467.70 **
2,000.00 Budgeted
1,532.30 Remaining 23 9 Used
Department 10 Totals: 1,367,856.82 **
425,037.34 Monthly Total 5,506,929.00 Budgeted 4,139,072.18 Remaining 25 % Used
87 of 155
February 17, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20
10:44 02/11/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 1/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
513 01/10/2020 MUD Payroll 1/10/2020 Salaries & Wages
611 01/24/2020 MUD Payroll 1/24/2020 Salaries & Wages
87,226.30 16,024.41 103,250.71 PR
15,926.44 119,177.15 PR
Account: 135-50005-020-000
Salaries & Wages Totals: 31,950.85 119,177.15 **
441,799.00 Budgeted
322,621.85 Remaining 27 % Used
Account: 135-50010-020-000 Overtime
513 01/10/2020 MUD Payroll 1/10/2020 Overtime 6,099.72 1,050.62 7,150.34 PR
611 01/24/2020 MUD Payroll 1/24/2020 Overtime 914.93 8,065.27 PR
Account: 135-50010-020-000
Overtime Totals: 1,965.55 8,065.27 **
33,000.00 Budgeted
24,934.73 Remaining 24 % 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
611 01/24/2020 MUD Payroll 1/24/2020 Certification 1,900.00 650.00 2,550.00 PR
Account: 135-50017-020-000
Certification Totals: 650.00 2,550.00 **
9,000.00 Budgeted
6,450.00 Remaining 28 % Used
Account: 135-50020-020-000 Retirement
513 01/10/2020 MUD Payroll 1/10/2020
611 01/24/2020 MUD Payroll 1/24/2020
Retirement
Retirement
10,982.75 1,581.15 12,563.90 PR
1,619.69 14,183.59 PR
Account: 135-50020-020-000
Retirement Totals: 3,200.84 14,183.59 **
45,531.00 Budgeted
31,347.41 Remaining 31 % Used
Account: 135-50026-020-000 Medical Insurance
513 01/10/2020 MUD Payroll 1/10/2020
Medical Insurance 18,313.59
611 01/24/2020 MUD Payroll 1/24/2020 Medical Insurance
3,869.14 22,182.73 PR
3,869.10 26,051.83 PR
Account: 135-50026-020-000
Medical Insurance Totals: 7,738.24 26,051.83 **
104,858.00 Budgeted
78,806.17 Remaining 25 % Used
88 of 155
February 17, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21
10:44 02/11/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 1/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-50027020- ental InsuI
513 01/10/2020 MUD Payroll 1/10/2020 Dental Insurance
611 01/24/2020 MUD Payroll 1/24/2020 Dental Insurance
Account: -1.1 Dental Insuranc Totals:
5,817.00 Budgeted 4,278.48 Remaining
Account: 135-50028-020-000 Vision Insurance
513 01/10/2020 MUD Payroll 1/10/2020 Vision Insurance
611 01/24/2020 MUD Payroll 1/24/2020 Vision Insurance
1,091.02 223.77 1,314.79 PR
223.73 1,538.52 PR
_ 4
26 % Used
180.95 34.87 215.82 PR
34.87 250.69 PR
Account: 135-50028-020-000
Vision Insurance Totals:
948.00 Budgeted
697.31 Remaining 26 % Used
Life Insurance & Other
432 01/01/2020 Payroll Benefits January
452 01/01/2020 Payroll Benefits January
646 01/29/2020 January A/P
Employee Benefits
Employee LTD & STD
caf 125 -December
1,014.05 174.57 1,188.62 Humana Inc
165.74 1,354.36 METLIFE GROUP BENEFITS
36.00 1,390.36 BenefitMall
6035 AP
6042 AP
6128 AP
Account: 135-50029-020-000
Life Insurance & Other Totals:
Account: 135-50030-020-000
513 01/10/2020 MUD Payroll 1/10/2020
611 01/24/2020 MUD Payroll 1/24/2020
Account: 135-50035-020-000
513 01/10/2020 MUD Payroll 1/10/2020
611 01/24/2020 MUD Payroll 1/24/2020
4,500.00 Budgeted
3,109.64 Remaining 31 % Used
Social Security Taxes
Social Security Taxes
Social Security Taxes
Social Security T
30,494.00 Budgeted
Medicare Taxes
Medicare Taxes
Medicare Taxes
Account: 135-50035-020-000 Medicare Taxe,
m.
7,132.00 Budgeted
22,542.29
Account: 135-50040-0
513 01/10/2020 MUD Payroll 1/10/2020 Unemployment Taxes
Remaining
5,963.49
1,394.67
26
1,000.04
988.18
Used
6,963.53
7,951.71
233.88 1,628.55
231.11 1,859.66
5,272.34 Remaining 26 % Used
89 of 155
PR
PR
PR
PR
17.07 17.07 PR
February 17, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22
10:44 02/11/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 1/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
611 01/24/2020 MUD Payroll 1/24/2020 Unemployment Taxes
Account: 135 -50040 -020 -
Unemployment Taxes Totals:
1,260.00 Budgeted
Account: 135-50045-020-00 Workman's Compensation
69 01/01/2020 Insurance/Wrk Comp Expense Jan
Account: 135-50045-020-00 s Compensation
15,373.00 Budgeted
Account: 135-50060-020-000 � Pre-emp Physicals/Testing
17.49 34.56 PR
1,225.44 Remaining 3 % Used
34
3,330.60 1,110.20
10,932.20 Remaining 29 % Used
Account: 135-50060-020-000 Pre-emp Physicals/Testing Tota
400.00 Budgeted 400.00 Remaining 0 % Used
Account: 135-50070-020-000 Employee Relations
Account: 135-50070-020-000 Employee Relations Totals:
300.00 Budgeted 300.00 Remaining 0 % Used
Account: 135-55005-020-000 Engineering
4,440.80 GL
.00 .00
.00 .00
.00 .00
Account: 135-55005-020-000 Engineering Totals:
30,000.00 Budgeted 30,000.00 Remaining 0 % Ueed
Account: 135-55070-020-000 Independent Labor
3,000.00
Account: 135-55070-020-000 Independent Labor
15,000.00 Budgeted
Account: 135-551Ie & R
523 01/07/2020 January A/P oil
.00 3,000.00
12,000.00 Remaining 20 % Used
15,624.92 366.09 15,991.01 LUBRICATION ENGINEERS, INC
90 of 155
6088 AP
glpdatb2 skrolczyk
10:44 02/11/20
Fund: 135 MUD 1 General Fund
JE
Number
JE
Date
596 01/17/2020
596 01/17/2020
653 01/26/2020
653 01/26/2020
653 01/26/2020
646 01/29/2020
646 01/29/2020
651 01/30/2020
JE
Description
January A/P
January A/P
PCards 12/27/2019-01/26/2020
PCards 12/27/2019-01/26/2020
PCards 12/27/2019-01/26/2020
January A/P
January A/P
January A/P
Account: 135-55080-020-000
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: 20 Wastewater
Period Ending: 1/2020
JE Detail Beginning
Balance
Description/Comment
3 sets forks for back hoe
butterfly valve
Tape, pvc, adapters
Nuts, washers, u post
adapters, clamps
floats & install for WWTP
10" flanges for RAS pumps
Emergency repair -13 Heritage C
Maintenance & Repairs
88,000.00 Budgeted
59,284.83 Remaining
15,624.92
Program:
Transaction
Detail
33 % Used
February 17, 2020 Regular Meeting Agenda Packet
Page 23
Transaction Vendor Name
Detail
(SUBTOTAL)
9,900.00 25,891.01
220.00 26,111.01
182.63 26,293.64
25.81 26,319.45
21.72 26,341.17
765.00 27,106.17
1,150.00 28,256.17
459.00 28,715.17
28,715.17
RDO Equipment Co
Core & Main LP
THE HOME DEPOT #6581
THE HOME DEPOT #6581
THE HOME DEPOT #6581
DHS AUTOMATION, INC
NORTH TEXAS PUMP CO.
Sandra Stiltner
Check Source
Number
6114 AP
6094 AP
PC
PC
PC
6132 AP
6146 AP
6150 AP
ACCO
: 135 -55081 -020 -
Mainten & Repairs Co
523 01/07/2020 January A/P
653 01/26/2020 PCards 12/27/2019-01/26/2020
646 01/29/2020 January A/P
Account: 135
Account: 135-55085-020-000
Account: 135-55085-020-000
LS twenty
pvc pipes
clean out shie
Mainten & Repairs Collections Totals:
10,000.00 Budgeted (5,378.45) Remaining
Generator Maint. and Repair
Generator Maint. and Repair Totals:
10,000.00 Budgeted 10,000.00 Remaining
Vehicle Maintenance
653 01/26/2020 PCards 12/27/2019-01/26/2020
653 01/26/2020 PCards 12/27/2019-01/26/2020
653 01/26/2020 PCards 12/27/2019-01/26/2020
oil change
oil change
Air Filter, fluids
Account: 135-55090-020-00 Vehicle Maintenance Totals:
4,000.00 Budgeted 3,317.02 Remaining
14,277.16
154 % Used
646.00 14,923.16 DHS AUTOMATION, INC
337.87 15,261.03 FERGUSON ENT 1241
117.42 15,378.45 Core & Main LP
.00
0 % Used
.00
404.23 87.89 492.12 GIERISCH CARE 0050292
88.91 581.03 GIERISCH CARE 0050292
101.95 682.98 ROANOKE AUTO SUPPLY LT
17 % Used
6082 AP
PC
6130 AP
PC
PC
PC
Account:
Veh Maintenance Collections
653 01/26/2020 PCards 12/27/2019-01/26/2020
653 01/26/2020 PCards 12/27/2019-01/26/2020
653 01/26/2020 PCards 12/27/2019-01/26/2020
653 01/26/2020 PCards 12/27/2019-01/26/2020
Tax on oil change
oil change plus tax
vehicle registration
Fee for Vehicle Registration
1,860.08
91 of 155
(27.86)
90.48
8.25
2.00
1,832.22
1,922.70
1,930.95
1,932.95
FERGUSON ENT 1241
KWIK KAR LUBE & TUNE 0
DENTON VEHREG
TX.GOV*SERVICEFEE-DIR
PC
PC
PC
PC
glpdatb2 skrolczyk
10:44 02/11/20
Fund: 135 MUD 1 General Fund
JE
Number
JE
Date
JE
Description
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: 20 Wastewater
Period Ending: 1/2020
JE Detail Beginning
Balance
Description/Comment
Veh Maintenance Collectio
8,000.00 Budgeted
6,067.05 Remaining
Program:
Transaction
Detail
24 % Ueed
7a
February 17, 2020 Regular Meeting Agenda Packet
Page 24
Transaction Vendor Name
Detail
(SUBTOTAL)
Check Source
Number
Account: 135-55105-020-000
Maintenance-Backhoe/SkidLoader
Account: 135-55105-020-000
Account: 135-55120-020-000
646 01/29/2020 January A/P
Account: 135-55120-020-000
Account: 135-55125-020-000
596 01/17/2020 January A/P
596 01/17/2020 January A/P
646 01/29/2020 January A/P
723 01/31/2020 January A/P
734 01/31/2020 January A/P
Account: 135-55125-020-000
Account: 135-55135-020-000 '
596 01/17/2020 January A/P
596 01/17/2020 January A/P
596 01/17/2020 January A/P
596 01/17/2020 January A/P
646 01/29/2020 January A/P
646 01/29/2020 January A/P
723 01/31/2020 January A/P
723 01/31/2020 January A/P
723 01/31/2020 January A/P
Maintenance-Backhoe/SkidLoader Totals:
3,000.00 Budgeted 2,495.32 Remaining
Cleaning Services
janitorial svC-December
Cleaning Services
1,500.00 Budgeted
Dumpster Services
sludge/grit
sludge haul off
sludge/grit
sludge/grit
sludge/grit
Dumpster Services
100,000.00 Budgeted
Total..
1,237.50 Remaining
67,213.22
lab testing
lab testing
lab testing
lab trsting
lab testing
lab trsting
lab testing
lab trsting
Calibrate lab scale
ACCOu yeie
40,000.00 Budgeted
Remaining
504.68
17 % Used
.00
504.68
175.00 87.50 262.50 MEMBER'S BUILDING MAINTENANCE
20,576.50
10,059.14
18 % Used
33 % Used
27,283.55 Remaining 32 % Ueed
92 of 155
2,573.62
2,183.02
2,505.42
2,600.90
2,347.32
23,150.12
25,333.14
27,838.56
30,439.46
32,786.78
317.40 10,376.54
230.00 10,606.54
341.55 10,948.09
241.50 11,189.59
341.55 11,531.14
241.50 11,772.64
341.55 12,114.19
241.50 12,355.69
360.76 12,716.45
L.H. CHANEY MATERIALS, INC.
L.H. CHANEY MATERIALS, INC.
L.H. CHANEY MATERIALS, INC.
L.H. CHANEY MATERIALS, INC.
L.H. CHANEY MATERIALS, INC.
OXIDOR LABORATORIES LLC
OXIDOR LABORATORIES LLC
OXIDOR LABORATORIES LLC
OXIDOR LABORATORIES LLC
OXIDOR LABORATORIES LLC
OXIDOR LABORATORIES LLC
OXIDOR LABORATORIES LLC
OXIDOR LABORATORIES LLC
METTLER TOLEDO INTERNATIONAL
6144 AP
6107 AP
6107 AP
6141 AP
AP
AP
6113 AP
6113 AP
6113 AP
6113 AP
6148 AP
6148 AP
AP
AP
AP
February 17, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25
10:44 02/11/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 1/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
465 01/02/2020 January A/P
597 01/20/2020 January A/P
Account: ..0-02 -
Communications/Mobiles —
PID inverted siphon
cell phones -January
1,585.66 276.00
408.87
Communications/Mobil Totals:
5,000.00 Budgeted 2,729.47 Remaining
Account: 135-60020-020-000 Electricity
596 01/17/2020 January A/P electricity 11/27-1/2
598 01/20/2020 January A/P Electricity 12/10-1/10
733 01/31/2020 Town Billed Invoices 1722-1725 AR 20200131-20200131 User:
Account: 135-60020-020-000— Electri.
160,067.00 Budgeted
112,193.53
Remaining
45 % Used
1,861.66 OMNISITE 6045 AP
2,270.53 VERIZON WIRELESS 6124 AP
35,143.35 624.40 35,767.75 TRI COUNTY ELECTRIC 6121 AP
12,728.09 48,495.84 HUDSON ENERGY SERVICES, LLC 6104 AP
(622.37) 47,873.47 AR
30
Used
Account: 135-60066-020-000
Publications/Books/Subscripts
Account: 135-60066-020-000 Publications/Books/Subscripts Tot
200.00 Budgeted 200.00 Remaining
0
Used
.00
.00
Account: 135-60070-020-000 Dues & Memberships
111.00
.00 111.00
Account: 135-60070-020-000
Dues & Memberships Totals:
111.00 **
300.00 Budgeted
189.00 Remaining 37 % Used
Account: 135
Schools & Training
658 01/27/2020 PCards 1/27/2020 Surface water class- F. Isola
Account: 135-60080-020-00 Schools & Training
4,990.00 Budgeted
1,470.85 440.00
Totals:
3,079.15 Remaining 38 % Used
1,910.85 TEEX ECOMMERCE PC
Account: 135-60090-020-000
Safety Program
Account: 135-60090-020-00
109.14
Safety Program Totals:
1,000.00 Budgeted
890.86 Remaining 11 % Used
93 of 155
.00 109.14
glpdatb2 skrolczyk
10:44 02/11/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
Period Ending: 1/2020
JE Detail
Description/Comment
February 17, 2020 Regular Meeting Agenda Packet
Page 26
Program:
Beginning Transaction Transaction Vendor Name
Balance Detail Detail
(SUBTOTAL)
Check Source
Number
94 of 155
Account:
135-60100-020-000
Travel & per diem
646 01/29/2020
January A/P tolls to Austin -GM car
356.71
4.13
360.84
Texas Tollways/TxTag 6153 AP
Account:
135-60100-020-000
Travel & per diem Totals:
4.13
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 5
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
.00
.00
Account:
135-60280-020-000
Property Maintenance Totals:
.00
.00
**
5,000.00 Budgeted 5,000.00 Remaining
0 %
Used
Account:
135-60285-020-000
Lawn Equipment & Maintenance
94 of 155
February 17, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27
10:44 02/11/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 1/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-1 Lawn Equipment & Maintenance Totals:
14,000.00 Budgeted 14,000.00 Remaining
Account: 135-60331-020-000 Interfund Transfer Out -Tax I&S
645 01/30/2020 TexPool Tlansfers January TexPool O&M to I&S- PID Debt
Account: 135-60331-020-000
Interfund Transfer Out -Tax I&S Tot
114,563.00 Budgeted 72,903.76
.00 .00
0 % Used
Remaining
Account: 135-60332 020- aterfund T -Rev I&S
645 01/30/2020 TexPool Transfers January TexPool O&M to Rev Bd WWTP I&S
645 01/30/2020 TexPool Transfers January TexPool O&M to 19 W&WW Rev I&S
Account1332-02 - Interfund Transfer Ou
673,867.00 Budgeted
31,244.43 10,414.81 41,659.24 GL
183,781.50
36 % Used
54,421.63 238,203.13
6,839.07 245,042.20
428,824.80 Remaining 36 % Used
Account: 135-60333-020-000 Interfund Transfer Out -Reserve
645 01/30/2020 TexPool Transfers January 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 Out -Reserve Tota
125,187.00 Budgeted 102,187.00 Remaining
Interfund Transfer Ou
180,000.00 Budgeted
180,000.00
Remaining
17,250.00
18 % Used
0
Used
5,750.00 23,000.00
00
.00
GL
GL
GL
Furniture/Equipment < $5000
Furniture/Equipment < $500
2,000.00 Budgeted
1,810.00
Remaining
190.00
10
Used
.00
190.00
Fuel & Lube
95 of 155
glpdatb2 skrolczyk
10:44 02/11/20
Fund: 135 MUD 1 General Fund
JE JE JE
Number Date Description
640 01/24/2020 Fuel
Account: 135-65010-020-000
Account: 135-65010-020-00
Account: 135-65030-020-
596 01/17/2020 January A/P
646 01/29/2020 January A/P
734 01/31/2020 January A/P
Account: 135-
Account: 135-65031-020-000
Account: 135-65031-020-000
Account: 135-65035-020-000
Account: 135-65035-020-000
Account: 135-65040-020-000
Account: 135-65040-020-000
Account: 135-65045-020-000
12,500.00
5,495.00
Chemical
February 17, 2020 Regular Meeting Agenda Packet
Trophy Club MUD No.1 Page 28
Detailed Accounting Trial Balance
Department: 20 Wastewater Program:
Period Ending: 1/2020
JE Detail Beginning Transaction Transaction Vendor Name Check Source
Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Fuel -JAN
Budgeted
Budgeted
sodium hypo
sodium hypo 12.5%
De foamier
20,000.00 Budgeted
Chemicals Collections
Chemicals Collections
17,500.00 Budgeted
Small Tools
9,539.60
1,987.07
Remaining
Remaining
2,335.18 625.22 2,960.40 US Bank Voyager Fleet Systems 6155 AP
3,507.93
6,820.56
24 % Used
64 % Used
Totals:
10,131.73 Remaining 49 % Used
4,994.00
12,506.00 Remaining 29 % Used
Small Tools Totals:
1,200.00 Budgeted
Safety Equipment
Safety Equipment
1,200.00 Budgeted
1,200.00 Remaining 0 % Ueed
1,088.92
.00
569.00
717.50
1,761.21
3,507.93
7,389.56 Valley Solvent Company, INC
8,107.06 Valley Solvent Company, INC
9,868.27 MARYLAND BIOCHEMICAL CO, INC
.00 4,994.00
.00 .00
.00 1,088.92
Totals:
111.08 Remaining 91 % Used
6123 AP
6156 AP
AP
Lab Supplies
96 of 155
February 17, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 29
10:44 02/11/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 1/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
523 01/07/2020 January A/P gloves 8,006.39 169.20 8,175.59 LOU'S GLOVES INCORPORATED 6087 AP
523 01/07/2020 January A/P lab supplies 1,463.76 9,639.35 IDEXX DISTRIBUTION, INC 6085 AP
523 01/07/2020 January A/P Lab supplies 458.66 10,098.01 IDEXX DISTRIBUTION, INC 6085 AP
596 01/17/2020 January A/P lab supplies 229.33 10,327.34 IDEXX DISTRIBUTION, INC 6105 AP
596 01/17/2020 January A/P lab supplies 505.07 10,832.41 IDEXX DISTRIBUTION, INC 6105 AP
653 01/26/2020 PCards 12/27/2019-01/26/2020 distilled water 4.95 10,837.36 TOM THUMB #1789 PC
Account: 135-65045-020-000
Lab Supplies Totals: 2,830.97 10,837.36 **
20,000.00 Budgeted
9,162.64 Remaining 54 % Used
Account: 135-69005-020-000 Capital Outlays
646 01/29/2020 January A/P
646 01/29/2020 January A/P
651 01/30/2020 January A/P
hoes for plants and reels
hoses for plants and reels
In -plant water system WWTP
94,215.85
1,074.13
187.41
50,394.70
95,289.98 Stuart Hose & Pipe
95,477.39 Stuart Hose & Pipe
145,872.09 REY-MAR CONSTRUCTION
6151 AP
6151 AP
6149 AP
Account: 135-69005-020-000
Capital Outlays Totals: 51,656.24 145,872.09 **
530,500.00 Budgeted
384,627.91 Remaining 27 % Used
Account: 135-69008-020-000 Short Term Debt -Principal
646 01/29/2020 January A/P
646 01/29/2020 January A/P
Camera van P & I pymnt 19,158.74
Vaccon P & I payment 40,446.00
19,158.74 FIRST FINANCIAL BANK 6134 AP
59,604.74 FIRST FINANCIAL BANK 6134 AP
Account: 135-69008-020-000 Short Term Debt -Principal Totals: 59,604.74 **
79,133.00 Budgeted
19,528.26 Remaining 75 % Used
Account: 135-69009-020-000 Short Term Debt -Interest
646 01/29/2020 January A/P
Camera van P & I pymnt 3,681.96
646 01/29/2020 January A/P Vaccon P & I payment
2,440.07
3,681.96 FIRST FINANCIAL BANK 6134 AP
6,122.03 FIRST FINANCIAL BANK 6134 AP
Account: 135-69009-020-000
Short Term Debt -Interest Totals: 6,122.03 6,122.03 **
11,277.00 Budgeted
5,154.97 Remaining 54 % Used
Account: 135-69195-020-000 Gasb34/Reserve for Replacement
130,000.00
.00 130,000.00
Account: 135-69195-020-000 Gasb34/Reserve for Replacement Totals: .00 130,000.00 **
130,000.00 Budgeted
.00 Remaining 100 % Used
97 of 155
February 17, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30
10:44 02/11/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 1/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Department 20 Totals: 1,037,817.63 **
294,666.79 Monthly Total 3,157,421.00 Budgeted 2,119,603.37 Remaining 33 % Used
98 of 155
February 17, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31
10:44 02/11/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program:
Period Ending: 1/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-50045-026-0 Workman's Compensation
69 01/01/2020 lneurance/Wrk Comp Expense Jan 5.97
Acal Workman's Compensation
30.00 Budgeted
Total
22.04 Remaining 27 % Used
1.99 7.96
GL
1
Account: 135-60066-026-000
■ Publications/Books/Subscripts
Account: 135-60066-026-000
Publications/Books/Subscripts Totals:
150.00 Budgeted 150.00 Remaining
.00 .00
0 % Ueed
111 Dues & Memberships
Account: - - -
Dues & Memberships Total=
750.00 Budgeted 75.00 Remaining
Account: 135-60075-026-000 Meetings
653 01/26/2020 PCarde 12/27/2019-01/26/2020 candy
Account: 135-60075-026-00
Meeting.
1,300.00 Budgeted
1,123.72
Remaining
675.00
170.56
.00
90 % Ueed
14
Used
5.72
Account: 135-60080-026-000
.00
Account: 135-60080-026-000
4,000.00 Budgeted 4,000.00 Remaining 0 % Used
Account: 135-60100-026-000 Travel & per diem
675.00
176.28 WM SUPERCENTER *5247
.00
.00 .00
Account: 135-60100-026-000 Travel & per diem Totals:
5,000.00 Budgeted 5,000.00 Remaining 0 % Used
PC
Account: 135-60245-026-000 Miscellaneous Expenses
99 of 155
February 17, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32
10:44 02/11/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program:
Period Ending: 1/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: 859.24 ++
7.71 Monthly Total 13,230.00 Budgeted
100 of 155
12,370.76 Remaining 6 % Used
February 17, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33
10:44 02/11/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 1/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
-
513 01/10/2020 MUD Payroll 1/10/2020 Salaries & Wages
611 01/24/2020 MUD Payroll 1/24/2020 Salaries & Wages
88,963.65 15,092.71 104,056.36 PR
15,060.00 119,116.36 PR
Account: - Salaries & Wages Totals:
628,298.00 Budgeted 509,181.64 Remaining 19 % Used
Account: 135-50010-030-000 Overtime
513 01/10/2020 MUD Payroll 1/10/2020 Overtime
Account: 135-50010-030-000 Overtime
2,000.00 Budgeted
Account: 135-50016-030-000
11.82
1,983.43 Remaining 1 % Used
Account: 135-50016-030-00 Totals:
2,208.00 Budgeted .50 Remaining
Account: 135-50020-030-00 irement
513 01/10/2020 MUD Payroll 1/10/2020 Retirement
611 01/24/2020 MUD Payroll 1/24/2020 Retirement
Account: 135-50020-030-000
58,554.00 Budgeted
Account: 135-50026-030-000edical ce
513 01/10/2020 MUD Payroll 1/10/2020 Medical Insurance
611 01/24/2020 MUD Payroll 1/24/2020 Medical Insurance
Account: 135-50026-030-000
45,821.22
Remaining
Medical Insurance Totals:
124,394.00 Budgeted 101,581.80 Remaining
2,207.50
100 % Used
9,940.22
16,466.43
Account: 135 Dental Insurance M
513 01/10/2020 MUD Payroll 1/10/2020 Dental Insurance 919.20
611 01/24/2020 MUD Payroll 1/24/2020 Dental Insurance
Account: 135
`Dental InsuraaTotals:
6,464.00 Budgeted 5,195.05 Remaining
22 % Used
4.75 16.57
.00 2,207.50
1,398.03
1,394.53
11,338.25
12,732.78
3,172.91 19,639.34
3,172.86 22,812.20
18 % Used
20 % Used
101 of 155
174.88 1,094.08
PR
PR
PR
PR
PR
PR
174.87 1,268.95 PR
glpdatb2 skrolczyk
10:44 02/11/20
Fund: 135 MUD 1 General Fund
JE JE JE
Number Date Description
February 17, 2020 Regular Meeting Agenda Packet
Trophy Club MUD No.1 Page 34
Detailed Accounting Trial Balance
Department: 30 Administration Program:
Period Ending: 1/2020
Beginning Transaction Transaction Vendor Name Check Source
Balance Detail Detail Number
(SUBTOTAL)
JE Detail
Description/Comment
ACCO
-5002:-030-
cion Ins
513 01/10/2020 MUD Payroll 1/10/2020
611 01/24/2020 MUD Payroll 1/24/2020
Account:
Vision Insurance
Vision Insurance
ision Insuranc>
1,035.00 Budgeted
Account: 135-50029-030-000 Life Insurance & Other
432 01/01/2020 Payroll Benefits January Employee Benefits
452 01/01/2020 Payroll Benefits January Employee LTD & STD
646 01/29/2020 January A/P caf 125 -December
Totals:
146.31
1
837.01 Remaining 19 % Used
25.85 172.16
25.83 197.99
943.63 176.22 1,119.85 Humana Inc
151.69 1,271.54 METLIFE GROUP BENEFITS
20.00 1,291.54 BenefitMall
PR
PR
6035 AP
6042 AP
6128 AP
Account: 135-50029-030
4,500.00 Budgeted
3,208.46
Account: 135-50030-030-000 ity Taxes
513 01/10/2020 MUD Payroll 1/10/2020 Social Security Taxes
611 01/24/2020 MUD Payroll 1/24/2020 Social Security Taxes
Remaining
5,338.43
29
Used
868.66 6,207.09
860.42 7,067.51
PR
PR
Account: 135-50030-030-000
Social Security Taxes Totals:
39,215.00 Budgeted
Account: 135-50035-030-000 Medicare Taxes
513 01/10/2020 MUD Payroll 1/10/2020 Medicare Taxes
611 01/24/2020 MUD Payroll 1/24/2020 Medicare Taxes
Account: 135-50040-030-000
513 01/10/2020 MUD Payroll 1/10/2020
611 01/24/2020 MUD Payroll 1/24/2020
Account: 135-50040-030-000
32,147.49 Remaining 18 % Used
Medicare Taxes Totals:
9,171.00 Budgeted
Unemployment Taxes
Unemployment Taxes
Unemployment Taxes
Unemployment Taxes
1,440.00 Budgeted
Account: 135-50045-03s Compens
69 01/01/2020 Insurance/Wrk Comp Expense Jan
1,248.53
7,518.08 Remaining 18 % Used
1,409.84 Remaining
314.46
203.16 1,451.69
PR
201.23 1,652.92 PR
15.09 15.09
15.07 30.16
2 % Used
102 of 155
104.82
419.28
PR
PR
GL
glpdatb2 skrolczyk
10:44 02/11/20
Fund: 135 MUD 1 General Fund
JE
Number
JE
Date
Account: 135-50060-030-000
Account: 135-50060-030-000
Account: 135-50070-030-000
Account: 135-50070-030-000
Account:
135-55030-030-000
596 01/17/2020
596 01/17/2020
596 01/17/2020
653 01/26/2020
653 01/26/2020
653 01/26/2020
653 01/26/2020
723 01/31/2020
723 01/31/2020
734 01/31/2020
JE
Description
January
January
January
PCards
PCards
PCards
PCards
January
January
January
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: 30 Administration
Period Ending: 1/2020
JE Detail Beginning
Balance
Description/Comment
Workman's Compensation
1,775.00 Budgeted
Pre-emp Physicals/Testing
1,355.72
Remaining
Pre-emp Physicals/Testing
500.00 Budgeted 500.00 Remaining
Employee Relations
Employee Relations o a s•
8,000.00 Budgeted 4,921.90 Remaining
Software & Support
GIS development
Microsoft exchange
internet-January
Internet
internet
Adobe subscription
internet
Annual software leaseFY 20
Annual license fee
Vision Annual License
A/P
A/P
A/P
12/27/2019-01/26/2020
12/27/2019-01/26/2020
12/27/2019-01/26/2020
12/27/2019-01/26/2020
A/P
A/P
A/P
723 01/31/2020 January A/P
740 01/31/2020 January A/p
740 01/31/2020 January A/p
Software & Support
134,681.00 Budgeted 9,406.78 Remaining
Independent Labor
GM recruitment
gm consulting -January
gm consulting -January
Independent Labor
135,000.00 Budgeted
24
Program:
Transaction
Detail
Ueed
0 % Ueed
3,078.10
38 % Used
73,404.13
93 % Used
34,035.79
80,175.51 Remaining 41 % Used
103 of 155
February 17, 2020 Regular Meeting Agenda Packet
Page 35
Transaction Vendor Name
Detail
(SUBTOTAL)
.00
.00
.00
3,078.10
9,952.61 83,356.74
494.00 83,850.74
899.00 84,749.74
42.37 84,792.11
42.37 84,834.48
36.78 84,871.26
53.91 84,925.17
16,800.00 101,725.17
22,587.00 124,312.17
962.05 125,274.22
10,000.00
10,780.00
8.70
Halff Associates, INC
M3 Networks
Charter Communications
ATT*BILL PAYMENT
ATT*BILL PAYMENT
ADOBE ACROPRO SUBS
ATT*BILL PAYMENT
STW INC
OpenGov, Inc
SW INC
Check Source
Number
44,035.79 Strategic Government Resources
54,815.79 Carman Consulting LLC.
54,824.49 Carman Consulting LLC.
6102 AP
6108 AP
6093 AP
PC
PC
PC
PC
AP
AP
AP
AP
AP
AP
glpdatb2 skrolczyk
10:44 02/11/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: 1/2020
Beginning
Balance
JE Detail
Description/Comment
Program:
Transaction
Detail
February 17, 2020 Regular Meeting Agenda Packet
Page 36
Transaction Vendor Name
Detail
(SUBTOTAL)
Check Source
Number
465 01/02/2020
653 01/26/2020
653 01/26/2020
653 01/26/2020
653 01/26/2020
646 01/29/2020
January A/P
PCards 12/27/2019-01/26/2020
PCards 12/27/2019-01/26/2020
PCards 12/27/2019-01/26/2020
PCards 12/27/2019-01/26/2020
January A/P
Answering service-january
Telephone
Answering Service
phone
phone
Answering service -February
4,455.76
104 of 155
207.75
176.78
14.99
788.45
467.11
194.75
4,663.51
4,840.29
4,855.28
5,643.73
6,110.84
6,305.59
KEYSTONE PARK SECRETARIAL
ATT*SILL PAYMENT
RINGCENTRAL, INC
ATT*BUS PHONE PMT
ATT*BUS PHONE PMT
KEYSTONE PARK SECRETARIAL
6037 AP
PC
PC
PC
PC
6139 AP
Account:
135-55080-030-000
Maintenance & Repairs
597 01/20/2020 January A/P
pest control -quarterly
1,055.00
110.00
1,165.00
Exclusive
Pest Control
6100
AP
Account:
135-55080-030-000
Maintenance & Repairs Totals:
110.00
1,165.00
**
15,000.00 Budgeted 13,835.00 Remaining
8 %
Used
Account:
135-55085-030-000
Generator Maint. and Repair
.00
.00
Account:
135-55085-030-000
Generator Maint. and Repair Totals:
.00
.00
**
10,000.00 Budgeted 10,000.00 Remaining
0 %
Used
Account:
135-55120-030-000
Cleaning Services
646 01/29/2020 January A/P
janitorial svc-December
1,738.12
869.06
2,607.18
MEMBER'S
BUILDING MAINTENANCE
6144
AP
Account:
135-55120-030-000
Cleaning Services Totals:
869.06
2,607.18
**
10,000.00 Budgeted 7,392.82 Remaining
26 5
Used
Account:
135-55160-030-000
Professional Outside Services
.00
.00
Account:
135-55160-030-000
Professional Outside Services Totals:
.00
.00
**
65,600.00 Budgeted 65,600.00 Remaining
0 %
Used
Account:
135-55205-030-000
Utility Billing Contract
596 01/17/2020 January A/P
726 01/31/2020 January A/P
December billings
January Billings
1,699.69
182.94
592.18
1,882.63
2,474.81
DATAPROSE
DATAPROSE
LLC
LLC
6097
AP
AP
Account:
135-55205-030-000
Utility Billing Contract Totals:
775.12
2,474.81
**
9,000.00 Budgeted 6,525.19 Remaining
27 5
Used
Account:
135-60005-030-000
Telephone
E.
465 01/02/2020
653 01/26/2020
653 01/26/2020
653 01/26/2020
653 01/26/2020
646 01/29/2020
January A/P
PCards 12/27/2019-01/26/2020
PCards 12/27/2019-01/26/2020
PCards 12/27/2019-01/26/2020
PCards 12/27/2019-01/26/2020
January A/P
Answering service-january
Telephone
Answering Service
phone
phone
Answering service -February
4,455.76
104 of 155
207.75
176.78
14.99
788.45
467.11
194.75
4,663.51
4,840.29
4,855.28
5,643.73
6,110.84
6,305.59
KEYSTONE PARK SECRETARIAL
ATT*SILL PAYMENT
RINGCENTRAL, INC
ATT*BUS PHONE PMT
ATT*BUS PHONE PMT
KEYSTONE PARK SECRETARIAL
6037 AP
PC
PC
PC
PC
6139 AP
February 17, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 37
10:44 02/11/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 1/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
733 01/31/2020 Town Billed Invoices 1722-1725 AR 20200131-20200131 User: 4,455.76
ccouut: 135-60005-030- Telephone
23,680.00 Budgeted
(180.00) 6,125.59
17,554.41 Remaining 26 % Used
Account: 135-60010-030-000 Communications/Mobiles
597 01/20/2020 January A/P cell phones -January
611 01/24/2020 MUD Payroll 1/24/2020 Communications/Mobiles
Account: Communications/Mobile
4,000.00 Budgeted
3,048.19
Account: Electricity/Gas
596 01/17/2020 January A/P gexa energy 11/8-12/10
Account: 135-60020-030-00
Electricity/Ga=
6,879.00 Budgeted
5,596.57
Account: 135-60025-030-000 Nat=
723 01/31/2020 January A/P water -January
733 01/31/2020 Town Billed Invoices 1722-1725 AR 20200131-20200131 User:
Account: 135-60025-030-000
1,500.00 Budgeted
Account: 135-60035-030-000 Postage
596 01/17/2020 January A/P December billings
646 01/29/2020 January A/P Postage lease
726 01/31/2020 January A/P January Billings
Account: 135-60035-030-000
596 01/17/2020 January A/P
596 01/17/2020 January A/P
710 01/31/2020 Pace Credit Card Fees
710 01/31/2020 Pace Credit Card Fees
Remaining
Remaining
714.06
592.00
1,669.83
87.75
150.00
24 % Used
690.43
19 % Used
801.81 VERIZON WIRELESS
951.81
1,282.43 TOWN OF TROPHY CLUB
184.77 112.79 297.56 TROPHY CLUB MUD (WATER BILLS)
(56.39)
1,258.83 Remaining 16 % Ueed
Postage = Totals:
30,000.00 Budgeted
241.17
AR
6124 AP
PR
6120 AP
AP
AR
4,875.95 158.50 5,034.45 DATAPROSE LLC 6097 AP
105.96 5,140.41 FRANCOTYP-POSTALIA, INC. 6135 AP
1,666.39 6,806.80 DATAPROSE LLC AP
23,193.20 Remaining 23 % Used
Service Charges & Fees
Dig Tess -December
Direct send fees -December
20,732.67 190.00 20,922.67 Texas Excavation Safety System 6118 AP
50.00 20,972.67 Fisery Solutions, LLC 6101 AP
4,879.37 25,852.04 GL
116.79 25,968.83 GL
105 of 155
February 17, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38
10:44 02/11/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 1/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
723 01/31/2020 January A/P Direct send fees -January
20,732.67 50.00 26,018.83 Fisery Solutions, LLC
AP
ccoun - - - Service Chargee & Fees Totals:
26,018.83 **
67,000.00 Budgeted
40,981.17 Remaining 39 % Used
Account: 135-60050-030-000
Bad Debt Expense
Account: 135-60050-030-000 Bad Debt Expense
1,500.00 Budgeted
Acco
: 135-60055-030-
69 01/01/2020 Insurance/Wrk Comp Expense Jan
596 01/17/2020 January A/P Notary-Slaght
725 01/31/2020 TML Liability Insurance Refund
Account: 135-60055-030-000
Account: 135-60066-030-000
1,500.00 Remaining
Ias ale:
84,000.00 Budgeted 59,568.30 Remaining
Publications/Books/Subscript
Account: 135-60066-030-00f Publications/Books/Subscripts Totals:
1,000.00 Budgeted 875.00 Remaining
21,016.17
.00 .00
0 % Used
29 % Used
6,998.39
50.00
(3,632.86)
28,014.56
28,064.56
24,431.70
GL
VICTOR 0 SCHINNERER & CO, INC 6125 AP
GL
125.00
.00 125.00
13 % Used
e & Memberahipai
Accoun
658 01/27/2020 PCards 1/27/2020 GFOAT membership
4,086.55 80.00 4,166.55 PAYPAL *TXMUNLEAGUE
PC
Dues & Memberships' Totals:
6,000.00 Budgeted
1,833.45 Remaining 69 % Ueed
Account: 135-60075-030-000
Meetings
•
Account: 135-60075-030-000
Me otals:
400.00 Budgeted
61.37
.00
338.63 Remaining 15 0 Used
61.37
Account: 135-60079-030-000
106 of 155
February 17, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39
10:44 02/11/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 1/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-60079-030-0 Public Education
6,000.00 Budgeted
Account: 135-60080-030-000
Account: 135-60080-030-000
Schools & Training
Schools & Training
6,850.00 Budgeted
Account: 15-60100-030- Travel & per diem
596 01/17/2020 January A/P tolls to lab
Account
Account
Travel & per diem
3,545.00 Budgeted
Physicals/Testing
Physicals/Testing
200.00 Budgeted
Account: 135-60115-030-000 Elections
Account: 135-60115-030-000
5,523.80 Remaining
5,697.29 Remaining
2,849.86 Remaining
Totals:
476.20
1,152.71
.00 476.20
8 % Used
17 % Used
.00 1,152.71
686.89 8.25 695.14 NTTA 6112 AP
20 % Used
200.00 Remaining 0 % Used
Elections Totals:
.00 Budgeted
Account: 135-60125-030-000 Advertising
Account: 135-60125-030-000 Advertising
2,500.00 Budgeted
43.01
.00 .00
.00 43.01
(43.01) Remaining 0 % Ueed
dMa
Account: 135-60235-0
596 01/17/2020 January A/P monitoring svc-jan
.00 .00
2,500.00 Remaining 0 % Ueed
72.00 24.00 96.00 Digital Air Control, Inc
107 of 155
6098 AP
February 17, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 40
10:44 02/11/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 1/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-60235-030-000
Account: 135-60245-030-000
Account: 135-60245-030-000
Account: 135-60246-030-000
Account: 135-60246-030-000
Account: 135-60360-030-000
Account: 135-60360-030-000
Account: 135-65010-030-000
Account: 135-65010-030-000
Account: 135-65055-030-000
Account: 135-65055-030-000
Security
1,288.00 Budgeted
Miscellaneous Expenses
24
1,192.00 Remaining 7 % Ueed
Miscellaneous Expenses
500.00 Budgeted
General Manager Contingency
General Manager Contingency Totals:
17,000.00 Budgeted 17,000.00 Remaining
Furniture/Equipment < $5000
500.00 Remaining 0 % Ueed
`Furniture/Equipment c $50
2,500.00 Budgeted
Uniforms
2,050.00 Budgeted
Hardware
Hardware
26,485.00 Budgeted
Account: 135-65085-030-00 Office Supplies
653 01/26/2020 PCards 12/27/2019-01/26/2020 Notary Stamp
646 01/29/2020 January A/P office supplies
2,500.00
Remaining
0 % Used
0
Used
2,050.00 Remaining 0 % Used
3,235.24
23,249.76 Remaining 12 % Used
.00 .00
.00 .00
.00
.00
.00
.00
.00 3,235.24
1,677.74 26.90 1,704.64 AMER ASSOC NOTARIES
108 of 155
PC
161.83 1,866.47 OFFICE DEPOT, INC 6147 AP
glpdatb2 skrolczyk
10:44 02/11/20
Fund: 135 MUD 1 General Fund
JE
Number
JE
Date
Account: 135-65090-030-000
Account: 135-65090-030-000
JE
Description
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: 30 Administration
Period Ending: 1/2020
JE Detail Beginning
Balance
Description/Comment
Office Supplies
6,000.00 Budgeted
Program:
Transaction
Detail
February 17, 2020 Regular Meeting Agenda Packet
Page 41
Transaction Vendor Name
Detail
(SUBTOTAL)
4,133.53 Remaining
Printer Supplies & Maintenance
Printer Supplies & Maintenance Totals:
3,500.00 Budgeted 3,500.00 Remaining
Account: 135-rillimaimilMaintenance Supplies
653 01/26/2020 PCarde 12/27/2019-01/26/2020 adapter
653 01/26/2020 PCards
653 01/26/2020 PCards
653 01/26/2020 PCards
653 01/26/2020 PCards
653 01/26/2020 PCarde
653 01/26/2020 PCards
653 01/26/2020 PCarde
653 01/26/2020 PCards
653 01/26/2020 PCards
653 01/26/2020 PCards
653 01/26/2020 PCards
653 01/26/2020 PCards
653 01/26/2020 PCards
653 01/26/2020 PCarde
653 01/26/2020 PCards
12/27/2019-01/26/2020
12/27/2019-01/26/2020
12/27/2019-01/26/2020
12/27/2019-01/26/2020
12/27/2019-01/26/2020
12/27/2019-01/26/2020
12/27/2019-01/26/2020
12/27/2019-01/26/2020
12/27/2019-01/26/2020
12/27/2019-01/26/2020
12/27/2019-01/26/2020
12/27/2019-01/26/2020
12/27/2019-01/26/2020
12/27/2019-01/26/2020
12/27/2019-01/26/2020
paper products, air freshner,
coffee creamer
popcorn
coffee
tea
coffee
coffee
coffee
water filter
air filters
air filters
batteries
air filters
air filter
tea
All,r5-030-all Maintenance Supplies
Account: 135-65105-030-000
Account: 135-65105-030-000
Account: 135-69005-030-000
Totals:
4,000.00 Budgeted 1,603.38 Remaining
Printing
Priatin•
2,500.00 Budgeted
2,500.00
Remaining
1,220.88
31 % Ueed
0 % Used
60 % Ueed
0
.00
.00
7.45 1,228.33
197.88 1,426.21
12.99 1,439.20
47.25 1,486.45
101.98 1,588.43
12.01 1,600.44
25.70 1,626.14
51.39 1,677.53
27.45 1,704.98
30.99 1,735.97
259.84 1,995.81
259.84 2,255.65
18.48 2,274.13
59.88 2,334.01
51.61 2,385.62
11.00 2,396.62
Used
109 of 155
.00
.00
.00
.00
AMZN MRTP US*IV5L658D3
SAMSCLUB.COM
AMAZON.COM*7173V4YD3
AMAZON.COM*HJ2657H73
AMZN MKTP US*017K89KQ3
AMAZON.COM*YA50Y4J73
AMAZON.COM*J45GI9053
AMAZON.COM*E96AA3UJ3
AMAZON.COM*BE2SW1HM3
AMZN METP US*WW9HZ2AL3
AMAZON.COM*R04Y134N3
AMAZON.COM*BT0NZ5703
AMAZON.COM*CZ42N8P43
HOMEDEPOT .COM
AMAZON. COM*0W2238HE3
AMAZON. COM*P33Q27R53
Check Source
Number
PC
PC
PC
PC
PC
PC
PC
PC
PC
PC
PC
PC
PC
PC
PC
PC
February 17, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42
10:44 02/11/20 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 1/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account:
596 01/17/2020 January A/P
646 01/29/2020 January A/P
Account: 135
Department 30 Totals:
Capital Outlays
195,000.00 Budgeted
195,000.00 Remaining 0 % Ueed
Copier Lease Installments
copier lease-jan
copies
L Copier Lease Installments Tota
4,000.00 Budgeted 2,962.34 Remaining
.00 **
795.98 165.00 960.98 TIAA COMMERCIAL FINANCE
76.68 1,037.66 KYOCERA DOCUMENT SOLUTIONS
26 % Used
439,447.86 **
131,731.90 Monthly Total 1,776,712.00 Budgeted 1,337,264.14 Remaining 25 % Used
110 of 155
6119 AP
6140 AP
glpdatb2 skrolczyk
10:44 02/11/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: 1/2020
JE Detail
Description/Comment
February 17, 2020 Regular Meeting Agenda Packet
Page 43
Program:
Beginning Transaction Transaction Vendor Name
Balance Detail Detail
(SUBTOTAL)
Check Source
Number
596 01/17/2020 January A/P
596 01/17/2020 January A/P
596 01/17/2020 January A/P
734 01/31/2020 January A/P
Westlake easement
legal
legal
legal
35,307.89
6,198.50
2,430.00
1,050.00
1,050.00
41,506.39 WHITAKER CHALK SWINDLE
43,936.39 McLean & Howard, L.L.P.
44,986.39 McLean & Howard, L.L.P.
46,036.39 McLean & Howard, L.L.P.
6126 AP
6109 AP
6109 AP
AP
Account:
135-55045-039-000
Legal Totals:
10,728.50
46,036.39
**
135,000.00 Budgeted 88,963.61 Remaining
34 %
Used
Account:
135-55055-039-000
Auditing
651 01/30/2020 January A/P
FY 19 Audit completed work
15,150.00
12,563.27
27,713.27
LAFOLLETT &
COMPANY,
PLLC
6142
AP
Account:
135-55055-039-000
Auditing Totals:
12,563.27
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
23,291.77 Monthly Total
244.00 Remaining
94 % Used
82,684.22 **
184,561.00 Budgeted 101,876.78 Remaining 45 % Used
166,399.23
236,079.77 Monthly Total (6,224.00) Budgeted (172,623.23) Remaining ##########
111 of 155
glpdatb2 skrolczyk
10:44 02/11/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: 1/2020
Beginning
Balance
February 17, 2020 Regular Meeting Agenda Packet
Page 44
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
112 of 155
(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
112 of 155
(286,420.00) **
286,420.00 Remaining 0 % Used
(286,420.00)
286,420.00 Remaining 0 % Used
February 17, 2020 Regular Meeting Agenda Packet
TROPHY CLUB MUD #1 - WWTP TAX BOND CONST
BALANCE SHEET
JANUARY 2020
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
517
TAX BOND
CONSTRUCTION
547,320
TOTAL ASSETS 547,320
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES 685,476
TOTAL LIABILITIES 685,476
FUND BALANCE
ASSIGNED FUND BALANCE (118,409)
NET REVENUES / EXPENDITURES (19,747)
TOTAL FUND BALANCE (138,156)
TOTAL LIABILITIES AND FUND BALANCE 547,320
113 of 155
February 17, 2020 Regular Meeting Agenda Packet
glbase tbam skrolczyk Trophy Club MUD No.1
10:43 02/11/20 Budget Summary with Amendment
Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program:
Period Ending: 1/2020
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
1 517-49011-000-000 Interest Income
743.88- 3,349.11- 3,349.11
Page 14
Subtotal: 743.88- 3,349.11- 3,349.11
Program number: 743.88-
3,349.11- 3,349.11
Department number: Revenues 743.88-
3,349.11- 3,349.11
Revenues Subtotal
743.88- 3,349.11- 3,349.11
114 of 155
glbase_tbam skrolczyk
10:43 02/11/20
Fund: 517 2014 MUD 1 Tax Bond Const WWTP
Account
1 517-69005-020-000
Description
Capital Outlays
Trophy Club MUD No.1
Budget Summary with Amendment
Department: 20 Wastewater
Period Ending: 1/2020
Adopted Amended Total Current
Budget Budget Encumb. Month
3,792.50
Program:
YTD
Total
23,096.00
February 17, 2020 Regular Meeting Agenda Packet
% of Remaining
Budget Budget
23,096.00 -
Page 15
115 of 155
Subtotal:
3,792.50
23,096.00
23,096.00 -
Program number:
3,792.50
23,096.00
23,096.00 -
Department number: Wastewater
3,792.50
23,096.00
23,096.00 -
Expenditures Subtotal
3,792.50
23,096.00
23,096.00 -
Fund number: 517 2014 MUD 1 Tax Bond Const WWTP
3,048.62
19,746.89
19,746.89-
115 of 155
February 17, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45
10:44 02/11/20 Detailed Accounting Trial Balance
Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program:
Period Ending: 1/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
724 01/31/2020 Bank Interest- January
Account: 517-49011-000-000 Interest Income
.00 Budgeted
(2,605.23) (743.88)
3,349.11 Remaining 0 % Used
(3,349.11) GL
Total
(741.
Department Totals: (3,349.11) **
(743.88) Monthly Total .00 Budgeted
116 of 155
3,349.11 Remaining 0 % Used
February 17, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46
10:44 02/11/20 Detailed Accounting Trial Balance
Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program:
Period Ending: 1/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-020-
ial
596 01/17/2020 January A/P
596 01/17/2020 January A/P
Capital Outl
WWTP legal
WWTP Legal
Account: - Capital Outlays Totals:
.00 Budgeted
19,303.50 1,572.50
2,220.00
(23,096.00) Remaining 0 % Used
20,876.00 Dubois Bryant Campbell LLP 6099 AP
23,096.00 CP&Y/WALLACE GROUP, INC. 6096 AP
Department 20 Totals: 23,096.00 **
3,792.50 Monthly Total .00 Budgeted
(23,096.00) Remaining 0 % Used
Fund 517 Totals: 19,746.89
3,048.62 Monthly Total .00 Budgeted
117 of 155
(19,746.89) Remaining 0 % Used
February 17, 2020 Regular Meeting Agenda Packet
TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION
NSII FORT WORTH- SWIFT FUNDING
BALANCE SHEET
JANUARY 2020
ASSETS
CASH IN BANK
CASH IN ESCROW
INVESTMENTS
ACCOUNTS RECEIVABLE
SIPA
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
519
REVENUE BOND
CONSTRUCTION
783,441
TOTAL ASSETS 783,441
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
118 of 155
81,691
81,691
698,648
3,102
701,750
783,441
February 17, 2020 Regular Meeting Agenda Packet
glbase tbam skrolczyk Trophy Club MUD No.1
10:43 02/11/20 Budget Summary with Amendment
Fund: 519 2016 Rev Bond Const -SWIFT Department: Revenues Program:
Period Ending: 1/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
669.42- 3,101.87-
3,101.87
Page 16
Subtotal:
669.42- 3,101.87-
3,101.87
Program number:
669.42- 3,101.87-
3,101.87
Department number: Revenues
669.42- 3,101.87-
3,101.87
Revenues
Subtotal
1
669.42-
3,101.87-
3,101.87
I Fund number: 519 2016 Rev Bond Const -SWIFT
119 of 155
February 17, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 47
10:44 02/11/20 Detailed Accounting Trial Balance
Fund: 519 2016 Rev Bond Const -SWIFT Department: Revenues Program:
Period Ending: 1/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
724 01/31/2020 Bank Interest- January
(2,432.45)
(669.42) (3,101.87) GL
Account: 519-49011-000-000
Interest Income Totals:
.00 Budgeted
3,101.67 Remaining 0 % Used
Department Totals: (3,101.87) **
(669.42) Monthly Total .00 Budgeted
3,101.87 Remaining 0 % Used
Fund 519 Totals: (3,101.87)
(669.42) Monthly Total .00 Budgeted
120 of 155
3,101.87 Remaining 0 % Used
February 17, 2020 Regular Meeting Agenda Packet
TROPHY CLUB MUD #1 - 16" WATERLINE REV BOND
BALANCE SHEET
JANUARY 2020
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
FUND 520
16" 2019
ASSETS REVENUE BOND
CASH IN BANK 552,598
INVESTMENTS 3,884,957
ACCOUNTS RECEIVABLE
TOTAL ASSETS 4,437,555
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 155
4,454,290
(16,735)
4,437,555
4,437,555
February 17, 2020 Regular Meeting Agenda Packet
glbase tbam skrolczyk Trophy Club MUD No.1 Page 17
10:43 02/11/20 Budget Summary with Amendment
Fund: 520 Revenue Bond 16" Waterline Department: Program:
Period Ending: 1/2020
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
1 520-49011-000-000 Interest Income
4,071.63-
18,707.81- 18,707.81
Subtotal: 4,071.63- 18,707.81- 18,707.81
Program number: 4,071.63-
18,707.81- 18,707.81
Department number: 4,071.63-
18,707.81- 18,707.81
Revenues Subtotal
1
4,071.63-
18,707.81- 18,707.81
122 of 155
glbase_tbam skrolczyk
10:43 02/11/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: 1/2020
Adopted Amended Total Current
Budget Budget Encumb. Month
4,704.93
Program:
YTD
Total
35,442.91
February 17, 2020 Regular Meeting Agenda Packet
% of Remaining
Budget Budget
35,442.91 -
Page 18
123 of 155
Subtotal:
4,704.93
35,442.91
35,442.91 -
Program number:
4,704.93
35,442.91
35,442.91 -
Department number:
Water Department
4,704.93
35,442.91
35,442.91 -
Expenditures
Subtotal
I
4,704.93
35,442.91
35,442.91 -
Fund number: 520
Revenue Bond 16" Waterline
633.30
16,735.10
16,735.10-
123 of 155
glpdatb2 skrolczyk Trophy Club MUD No.1
10:44 02/11/20 Detailed Accounting Trial Balance
Fund: 520 Revenue Bond 16" Waterline Department: Program:
Period Ending: 1/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
February 17, 2020 Regular Meeting Agenda Packet
Page 48
724 01/31/2020 Bank Interest- January (14,636.18)
724 01/31/2020 Bank Interest- January
Account: 520-490
nterest Income Totals:
.00 Budgeted
18,707.81 Remaining 0 % Used
(752.10) (15,388.28) GL
(3,319.53) (18,707.81) GL
Department Totals: (18,707.81) **
(4,071.63) Monthly Total .00 Budgeted
124 of 155
18,707.81 Remaining 0 % Used
February 17, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49
10:44 02/11/20 Detailed Accounting Trial Balance
Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program:
Period Ending: 1/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 520-69005-010-000 Capital Outlays
596 01/17/2020 January A/P Right away acquisition- 16" wa
30,737.98 4,704.93
35,442.91 Halff Associates, INC 6102 AP
Account: 520-69005-010-000
Capital Outlays Totals: 4,704.93 35,442.91 **
.00 Budgeted
(35,442.91) Remaining 0 5 Used
Department 10 Totals, 35,442.91 **
4,704.93 Monthly Total .00 Budgeted
(35,442.91) Remaining 0 % Used
Fund 520 Totals: 16,735.10
633.30 Monthly Total .00 Budgeted
125 of 155
(16,735.10) Remaining 0 % Used
February 17, 2020 Regular Meeting Agenda Packet
TROPHY CLUB MUD #1 - REVENUE BOND RESERVE
BALANCE SHEET
JANUARY 2020
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
MIA
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
528
REVENUE BOND
RESERVE
849,568
TOTAL ASSETS 849,568
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
126 of 155
803,457
46,111
849,568
849,568
February 17, 2020 Regular Meeting Agenda Packet
glbase tbam skrolczyk Trophy Club MUD No.1 Page 19
10:43 02/11/20 Budget Summary with Amendment
Fund: 528 2015 Revenue Bond Reserve Fund Department: Program:
Period Ending: 1/2020
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
528-49011-000-000
528-49142-000-000
528-49143-000-000
Interest Income
Interfund transfer in -Water
Interfund transfer in -WW
11,000.00-
307,049.00-
200,417.00-
11,000.00-
307,049.00-
200,417.00-
1,134.84-
4,600.00-
5,750.00-
4,711.24-
18,400.00-
23,000.00-
42.829
5.993
11.476
6,288.76-
288,649.00-
177,417.00 -
Subtotal: m 518,466.00- 518,466.00- 11,484.84- 46, 8.894 472,354.76 -
Program number: 1 518,466.00- 518,466.00- 11,484.84- 46,111117271 8.894 472,354.76 -
Department number: 518,466.00- 518,466.00- 11,484.84- 46,1.1.24- 8.894 472,354.76 -
Revenues Subtotal 518,466.00- 518,466.00- 11,484.84- L1.24- 8.894 472,354.76 -
Fund number: 528 2015 Revenue Bond Reserve Fund 518,466.00- 518,466.00- 11,484.84- L1.24- 8.894 472,354.76-
127 of 155
glpdatb2 skrolczyk Trophy Club MUD No.1
10:44 02/11/20 Detailed Accounting Trial Balance
Fund: 528 2015 Revenue Bond Reserve Fund Department: Program:
Period Ending: 1/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
February 17, 2020 Regular Meeting Agenda Packet
Page 50
Account: 528-49011-000-000 Interest Income
724 01/31/2020 Bank Interest- January (3,576.40)
Account: 528-49011-000-000
(11,000.00) Budgeted
Account: 528-49142-000-000
645 01/30/2020 TexPool Transfers January
(1,134.84) (4,711.24)
Total
(6,288.76) Remaining 43 % Used
TexPool O&M to Rev Bond Resevr (13,800.00)
4.84)
(4,600.00) (18,400.00)
GL
GL
Account
(307,049.00) Budgeted
(288,649.00) Remaining 6 % Used
Interfund transfer in -WW
645 01/30/2020 TexPool Transfers January TexPool O&M to Rev Bond Resevr
Account: 528-49143- nterfund transfer i
(200,417.00) Budgeted
(17,250.00)
(177,417.00) Remaining
(5,750.00)
11 % Used
(23,000.00)
Department Totals: (46,111.24) **
(11,484.84) Monthly Total
(518,466.00) Budgeted
(472,354.76) Remaining 9 % Used
Fund 528 Totals: (46,111.24)
(11,484.84) Monthly Total (518,466.00) Budgeted
128 of 155
(472,354.76) Remaining 9 % Used
GL
February 17, 2020 Regular Meeting Agenda Packet
TROPHY CLUB MUD #1 - I&S (DEBT SERVICE)
BALANCE SHEET
JANUARY 2020
ASSETS
CASH IN BANK
INVESTMENTS 736,540
PREPAID EXPENSES -
ADVALOREM PROPERTY TAXES RECEIVABLE 100,659
ACCOUNTS RECEIVABLE -OTHER -
TOTAL ASSETS 837,199
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
INTEREST &
SINKING- 533
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 100,659
ACCOUNTS AND OTHER PAYABLES -
TOTAL LIABILITIES 100,659
FUND BALANCE
ASSIGNED FUND BALANCE 82,954
NET REVENUES / EXPENDITURES 653,586
TOTAL FUND BALANCE 736,540
TOTAL LIABILITIES AND FUND BALANCE 837,199
129 of 155
February 17, 2020 Regular Meeting Agenda Packet
glbase tbam skrolczyk Trophy Club MUD No.1
10:43 02/11/20 Budget Summary with Amendment
Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program:
Period Ending: 1/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-
256,840.76-
846.94-
196.25-
257,883.95-
609,567.64-
633.46-
349.49-
610,550.59-
130 of 155
723.25- 1,375.71-
10,414.81- 41,659.24-
01-
89.322
63.346
17.475
89.074
27.514
36.364
72,873.36-
366.54-
1,650.51-
3,624.29-
218,004.00-
72,903.76-
6 369,422.46-
653,585.54- 369,422.46-
653,585.54-
369,422.46 -
Page 20
February 17, 2020 Regular Meeting Agenda Packet
glbase_tbam skrolczyk Trophy Club MUD No.1
10:43 02/11/20 Budget Summary with Amendment
Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program:
Period Ending: 1/2020
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
1
1 533-70005-051-000
1 533-70025-051-000
1 533-70035-051-000
Payin$g Agent Fee
Bond 2nterest Expense -Tax
Bond Principal Payment -Tax
2,150.00
247,858.00
765,000.00
2,150.00
247,858.00
765,000.00
2,150.00
247,858.00
765,000.00
Page 21
Subtotal:
1,015,008.00 1,015,008.00 1,015,008.00
Program number:
1,015,008.00 1,015,008.00 1,015,008.00
Department number: Administration 1,015,008.00 1,015,008.00 1,015,008.00
Expenditures
Subtotal 1,015,008.00 1,015,008.00 1,015,008.00
p Fund number: 533 MUD 1 I&S Consolidated
8,000.00- 8,000.00-
269,022.01- 653,585.54-
8,169.819 645,585.54
131 of 155
glpdatb2 skrolczyk
10:44 02/11/20
Fund: 533 MUD 1 I&S Consolidated
JE JE JE
Number Date Description
February 17, 2020 Regular Meeting Agenda Packet
Trophy Club MUD No.1 Page 51
Detailed Accounting Trial Balance
Department: Revenues Program:
Period Ending: 1/2020
JE Detail Beginning Transaction Transaction Vendor Name Check Source
Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 533-40000-000-000
L
Property Taxes
670 01/02/2020 Property Taxes
671 01/03/2020 Property Taxes
672 01/06/2020 Property Taxes
673 01/07/2020 Property Taxes
674 01/08/2020 Property Taxes
691 01/09/2020 Property Taxes
692 01/10/2020 Property Taxes
693 01/13/2020 Property Taxes
694 01/14/2020 Property Taxes
695 01/15/2020 Property Taxes
696 01/16/2020 Property Taxes
697 01/17/2020 Property Taxes
698 01/21/2020 Property Taxes
699 01/22/2020 Property Taxes
700 01/23/2020 Property Taxes
701 01/24/2020 Property Taxes
704 01/27/2020 Property Taxes
705 01/28/2020 Property Taxes
706 01/29/2020 Property Taxes
707 01/30/2020 Property Taxes
708 01/31/2020 Property Taxes
(352,726.88)
(13,511.47) (366,238.35) GL
(8,638.50) (374,876.85) GL
(7,125.22) (382,002.07) GL
(13,417.94) (395,420.01) GL
(12,697.75) (408,117.76) GL
(3,503.28) (411,621.04) GL
(6,413.40) (418,034.44) GL
(4,901.08) (422,935.52) GL
(2,642.89) (425,578.41) GL
(14,406.75) (439,985.16) GL
(4,799.57) (444,784.73) GL
(6,528.49) (451,313.22) GL
(3,140.90) (454,454.12) GL
(6,719.64) (461,173.76) GL
(6,059.81) (467,233.57) GL
(47,983.71) (515,217.28) GL
(12,869.15) (528,086.43) GL
(59,041.65) (587,128.08) GL
(7,660.94) (594,789.02) GL
(7,212.31) (602,001.33) GL
(7,566.31) (609,567.64) GL
Account: 533-40000-000-000
Property Taxes Totals:
(256,840.76) (609,567.64) **
(682,441.00) Budgeted
(72,873.36) Remaining 89 % Used
Account: 533-40002-000-000 Property Taxes/Delinquent
670 01/02/2020 Property Taxes
673 01/07/2020 Property Taxes
692 01/10/2020 Property Taxes
695 01/15/2020 Property Taxes
699 01/22/2020 Property Taxes
704 01/27/2020 Property Taxes
213.48 (11.91) 201.57 GL
(9.05) 192.52 GL
(26.98) 165.54 GL
(723.45) (557.91) GL
(61.41) (619.32) GL
(14.14) (633.46) GL
Account: 533-40002-000-000
Property Taxes/Delinquent Totals: (846.94) (633.46) **
(1,000.00) Budgeted
(366.54) Remaining 63 % Used
Account: 533-40015-000-000
` Property Taxes/P & I
670 01/02/2020 Property Taxes
673 01/07/2020 Property Taxes
692 01/10/2020 Property Taxes
(153.24) (3.36) (156.60) GL
(2.09) (158.69) GL
(5.67) (164.36) GL
132 of 155
glpdatb2 skrolczyk Trophy Club MUD No.1
10:44 02/11/20 Detailed Accounting Trial Balance
Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program:
Period Ending: 1/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
February 17, 2020 Regular Meeting Agenda Packet
Page 52
695 01/15/2020 Property Taxes
699 01/22/2020 Property Taxes
704 01/27/2020 Property Taxes
(153.24)
(173.64)
(8.76)
(2.73)
(338.00)
(346.76)
(349.49)
GL
GL
GL
Account:
533-40015-000-000 Property Taxes/P & I
Totals:
(196.25)
(349.49)
**
(2,000.00) Budgeted
(1,650.51) Remaining 17 %
Used
Account:
533-49011-000-000 Interest Income
724 01/31/2020 Bank Interest- January
(652.46)
(723.25)
(1,375.71)
GL
Account:
533-49011-000-000 Interest Income
Totals:
(723.25)
(1,375.71)
**
(5,000.00) Budgeted
(3,624.29) Remaining 28 %
Used
Account:
533-49015-000-000 Lease/Rental Income
.00
.00
Account:
533-49015-000-000 Lease/Rental Income
Totals:
.00
.00
**
(218,004.00) Budgeted
(218,004.00) Remaining 0 %
Used
Account:
533-49141-000-000 Interfund Trans In -PID
Surchg
645 01/30/2020 TexPool Transfers January TexPool O&M to
I&S- PID Debt (31,244.43)
(10,414.81)
(41,659.24)
GL
Account:
533-49141-000-000 Interfund Trans In -PID
Surchg Totals:
(10,414.81)
(41,659.24)
**
Department Totals:
(114,563.00) Budgeted
(269,022.01) Monthly Total
(72,903.76) Remaining
36 % Used
(653,585.54) **
(1,023,008.00) Budgeted (369,422.46) Remaining 64 % Used
133 of 155
glpdatb2 skrolczyk
10:44 02/11/20
Fund: 533 MUD 1 I&S Consolidated
JE JE JE
Number Date Description
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: 51 Administration
Period Ending: 1/2020
JE Detail
Description/Comment
February 17, 2020 Regular Meeting Agenda Packet
Page 53
Program:
Beginning Transaction Transaction Vendor Name
Balance Detail Detail
(SUBTOTAL)
Check Source
Number
Department 51 Totals:
Fund 533 Totals:
.00 Monthly Total
(269,022.01) Monthly Total
.00 **
1,015,008.00 Budgeted 1,015,008.00 Remaining 0 5 Used
(653,585.54)
(8,000.00) Budgeted 645,585.54 Remaining ##########
134 of 155
Account:
533-70005-051-000"IIIIPaying Agent Fee
.00
.00
Account:
533-70005-051-000
Paying Agent Fee Totals:
.00
.00
**
2,150.00 Budgeted 2,150.00 Remaining
0 %
Used
Account:
533-70025-051-000
Bond Interest Expense -Tax
.00
.00
Account:
533-70025-051-000
Bond Interest Expense -Tax Totals:
.00
.00
**
247,858.00 Budgeted 247,858.00 Remaining
0 %
Used
Account:
533-70035-051-000
Bond Principal Payment -Tax
.00
.00
Account:
533-70035-051-000
Bond Principal Payment -Tax Totals:
.00
**
765,000.00 Budgeted 765,000.00 Remaining
0 %
Used
Department 51 Totals:
Fund 533 Totals:
.00 Monthly Total
(269,022.01) Monthly Total
.00 **
1,015,008.00 Budgeted 1,015,008.00 Remaining 0 5 Used
(653,585.54)
(8,000.00) Budgeted 645,585.54 Remaining ##########
134 of 155
February 17, 2020 Regular Meeting Agenda Packet
TROPHY CLUB MUD #1 - REVENUE BOND I&S (WWTP)
BALANCE SHEET
JANUARY 2020
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
In
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
534
REVENUE BOND
I&S WWTP
242,846
TOTAL ASSETS 242,846
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 155
24,518
218,328
242,846
242,846
February 17, 2020 Regular Meeting Agenda Packet
glbase tbam skrolczyk Trophy Club MUD No.1
10:43 02/11/20 Budget Summary with Amendment
Fund: 534 2015 Revenue Bond I&S Department: Revenues Program:
Period Ending: 1/2020
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
534-49011-000-000 Interest Income 2,500.00-
534-49143-000-000 Interfund Transfer In -WW Sales 598,638.00-
Subtot
Program number:
Department number: Revenues
Revenues
Subtotal
60i�0-
601 00-
6011'38.00-
601,138.00-
2,500.00-
598,638.00-
6011.38.00-
601,138.00-
601,138.00-
601,138.00-
136 of 155
261.57-
54,421.63-
641.92-
217,685.92-
54,683.20- 218,3./.
54,683.20-
54,683.20-
54,683.20-
218,327.84-
218,327.84-
218,327.84 -
25.677 1,858.08-
36.364
36.319
36.319
36.319
36.319
380,952.08-
38
382mommorr
382,810.16-
Page 22
February 17, 2020 Regular Meeting Agenda Packet
glbase tbam skrolczyk Trophy Club MUD No.1
10:43 02/11/20 Budget Summary with Amendment
Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program:
Period Ending: 1/2020
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
534-70005-051-000
534-70040-051-000
534-70045-051-000
Rev Bond Paying Agent Fee
Revenue Bona Interest Expense
Revenue Bond Principal Expense
400.00
208,238.00
390,000.00
400.00
208,238.00
390,000.00
Subtotal: , 598,638.00 598,638.00
Program number: III 598,638.00 598,638.00
Department number: Administration III 598,638.00 598,638.00
Expenditures Subtotal III 598,638.00 598,638.00
Fund number: 534 2015 Revenue Bond I&S M2,500.00- 2,500.00-
54,683.20-
218,327.84- 8,733.114
137 of 155
400.00
208,238.00
390,000.00
598,638.00
598,638.00
598,638.
598,638.00
215,827.84
Page 23
glpdatb2 skrolczyk
10:44 02/11/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: 1/2020
JE Detail
Description/Comment
February 17, 2020 Regular Meeting Agenda Packet
Page 54
Program:
Beginning Transaction Transaction Vendor Name
Balance Detail Detail
(SUBTOTAL)
Check Source
Number
Department Totals:
(54,683.20) Monthly Total
(218,327.84) **
(601,138.00) Budgeted (382,810.16) Remaining 36 % Used
138 of 155
Account:
534-49011-000-000
Interest Income
724 01/31/2020
Bank Interest- January (380.35)
(261.57)
(641.92)
GL
Account:
534-49011-000-000
Interest Income Totals:
(261.57)
(641.92)
**
(2,500.00) Budgeted (1,858.08) Remaining 26 %
Used
Account:
534-49143-000-000
Interfund Transfer In -WW Sales
645 01/30/2020
TexPool Transfers January TexPool O&M to Rev Bd WWTP I&S (163,264.29)
(54,421.63)
(217,685.92)
GL
Account:
534-49143-000-000
Interfund Transfer In -WW Sales Totals:
(54,421.63)
(217,685.92)
**
(598,638.00) Budgeted (380,952.08) Remaining 36 %
Used
Department Totals:
(54,683.20) Monthly Total
(218,327.84) **
(601,138.00) Budgeted (382,810.16) Remaining 36 % Used
138 of 155
February 17, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 55
10:44 02/11/20 Detailed Accounting Trial Balance
Fund: 534 2015 Revenue Bond IES Department: 51 Administration Program:
Period Ending: 1/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 534-70005-051-000
Rev Bond Paying Agent Fee
Account: 534-70005-051-000 11 Rev Bond Paying Agent Fee Total
400.00 Budgeted 400.00 Remaining
Account: 534-70040-051-000 Revenue Bond Interest Expense
Account: 534-70040-051-000 Revenue Bond Interest Expense Totals:
208,238.00 Budgeted 208,238.00 Remaining
Account: 534-70045-051-000 Revenue Bond Principal Expense
A,t: 534-70045-051-000 Revenue Bond Principal Expense Totals:
390,000.00 Budgeted 390,000.00 Remaining
Department 51 Totals:
.00 Monthly Total
O % Used
•
O % Used
.00 .00
.00 .00
.00 .00
0 % Used
.00 **
598,638.00 Budgeted 598,638.00 Remaining 0 % Used
Fund 534 Totals: (218,327.84)
(54,683.20) Monthly Total (2,500.00) Budgeted 215,827.84 Remaining ##########
139 of 155
February 17, 2020 Regular Meeting Agenda Packet
TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S
BALANCE SHEET
JANUARY 2020
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
ra
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
535
NSII FTW SWIFT
REVENUE BOND
I&S
105,417
TOTAL ASSETS 105,417
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
140 of 155
4,967
100,450
105,417
105,417
February 17, 2020 Regular Meeting Agenda Packet
glbase tbam skrolczyk Trophy Club MUD No.1
10:43 02/11/20 Budget Summary with Amendment
Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program:
Period Ending: 1/2020
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
1
1 535-49011-000-000
1 535-49142-000-000
Interest Income
Interfund Tran In -Water Sales
1,000.00-
275,525.00-
1,000.00-
275,525.00-
111.83-
25,047.72-
259.12-
100,190.88-
25.912
36.364
740.88-
175,334.12 -
Page 24
Subtotal:
276,525.00- 276,525.00-
1
25,159.55- 100,450.00-
36.326 176,075.00 -
Program number:
276,525.00- 276,525.00-
25,159.55- 100,450.00-
36.326 176,075.00 -
Department number: Revenues
276,525.00- 276,525.00-
25,159.55- 100,450.00-
36.326 176,075.00 -
Revenues Subtotal 276,525.00- 276,525.00- 25,159.55- 100,450.00- 36.326 176,075.00-
141 of 155
February 17, 2020 Regular Meeting Agenda Packet
glbase_tbam skrolczyk Trophy Club MUD No.1
10:43 02/11/20 Budget Summary with Amendment
Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program:
Period Ending: 1/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
25,159.55-
100,450.00- -30.805
142 of 155
800.00
386,811.00
215,000.00
602,611.00
602,611.00
602,611.00
602,611.00
426,536.00
Page 25
glpdatb2 skrolczyk
10:44 02/11/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: 1/2020
JE Detail
Description/Comment
February 17, 2020 Regular Meeting Agenda Packet
Page 56
Program:
Beginning Transaction Transaction Vendor Name
Balance Detail Detail
(SUBTOTAL)
Check Source
Number
Department Totals:
(25,159.55) Monthly Total
(100,450.00) **
(276,525.00) Budgeted (176,075.00) Remaining 36 5 Used
143 of 155
Account:
535-49011-000-000
Interest Income
724 01/31/2020
Bank Interest- January
(147.29)
(111.83)
(259.12)
GL
Account:
535-49011-000-000
Interest Income
Totals:
(111.83)
(259.12)
**
(1,000.00) Budgeted
(740.88) Remaining 26 5
Used
Account:
535-49142-000-000
Interfund Tran In -Water
Sales
645 01/30/2020
TexPool Transfers
January TexPool O&M to
16Swift Rev I&S (75,143.16)
(25,047.72)
(100,190.88)
GL
Account:
535-49142-000-000
Interfund Tran In -Water
Sales Totals: Ur
(25,047.72)
(100,190.88)
**
(275,525.00) Budgeted
(175,334.12) Remaining 36 5
Used
Department Totals:
(25,159.55) Monthly Total
(100,450.00) **
(276,525.00) Budgeted (176,075.00) Remaining 36 5 Used
143 of 155
February 17, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 57
10:44 02/11/20 Detailed Accounting Trial Balance
Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program:
Period Ending: 1/2020
JE JE JE JE Detail Beginning Transaction Transaction Vendor Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 535-70005-051-000
Rev Bond Paying Agent Fee
Account: 535-70005-051-000 11 Rev Bond Paying Agent Fee Total
Account: 535-70040-051-000
800.00 Budgeted 800.00 Remaining
Revenue Bond Interest Expense
Account: 535-70040-051-000 Revenue Bond Interest Expense Totals:
386,811.00 Budgeted 386,811.00 Remaining
Account: 535-70045-051-000 Revenue Bond Principal Expense
Revenue Bond Principal Expense Totals:
215,000.00 Budgeted 215,000.00 Remaining
0 % Used
0 % Used
.00 .00
.00 .00
.00 .00
0 % Used
Department 51 Totals: .00 **
.00 Monthly Total 602,611.00 Budgeted
602,611.00 Remaining 0 % Used
Fund 535 Totals: (100,450.00)
(25,159.55) Monthly Total 326,086.00 Budgeted 426,536.00 Remaining -31 % Used
144 of 155
February 17, 2020 Regular Meeting Agenda Packet
TROPHY CLUB MUD #1 - REVENUE BOND I&S
WATER & WASTEWATER SYSTEM 2019
BALANCE SHEET
JANUARY 2020
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
ILIP
TROPHY CLUB
1
MUNICIPAL
UTILITY
DISTRICT
536
REVENUE BOND
SERIES 2019 I&S
119,214
TOTAL ASSETS 119,214
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES 119,214
TOTAL FUND BALANCE 119,214
TOTAL LIABILITIES AND FUND BALANCE 119,214
145 of 155
glbase_tbam skrolczyk
10:43 02/11/20
Fund: 536 2019 Rev Bond I&S- W&WW System
Account Description
1
1 536-49011-000-000
1 536-49142-000-000
1 536-49143-000-000
Interest Income
Interfund Tran In -Water Sales
Interfund Transfer In -WW Sales
February 17, 2020 Regular Meeting Agenda Packet
Trophy Club MUD No.1
Budget Summary with Amendment
Department: Revenues Program:
Period Ending: 1/2020
Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
124.73-
22,896.02-
6,839.07-
273.78-
91,584.08-
27,356.28-
273.78
91,584.08
27,356.28
Page 26
Subtotal:
"mmm797W-59.82- 119,714.14-
119,214.14
Program number:
29,859.82- 119,214.14-
119,214.14
Department number: Revenues
29,859.82-
119,214.14-
119,214.14
Revenues
Subtotal
29,859.82-
119,214.14-
119,214.14
Fund number: 536 2019 Rev Bond I&S- W&WW System
29,859.82- 119,214.14-
119,214.14
******* End of Report *********
146 of 155
February 17, 2020 Regular Meeting Agenda Packet
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 58
10:44 02/11/20 Detailed Accounting Trial Balance
Fund: 536 2019 Rev Bond I&S- W&WW System Department: Revenues Program:
Period Ending: 1/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
724 01/31/2020 Bank Interest- January
(149.05) (124.73)
(273.78) GL
Account: 536-49011-000-000 11 Interest Income Total
.00 Budgeted
273.78 Remaining 0 % Ueed
Account: 536-49142-000-000 Interfund Tran In -Water Sales
645 01/30/2020 TexPool Transfers January TexPool O&M to 19 W&WW Rev I&S
Account
(68,688.06) (22,896.02) (91,584.08) GL
Interfund Tran In -Water Sales Totals:
.00 Budgeted 91,584.08 Remaining
Interfund Transfer In -WW Sales i
645 01/30/2020 TexPool Transfers January TexPool O&M to 19 W&WW Rev I&S
0 % Ueed
(20,517.21) (6,839.07) (27,356.28) GL
Account: 536-49143-1116 rfund Transfer In -WW Sales Total
.00 Budgeted 27,356.28 Remaining
0 % Used
Department Totals: (119,214.14) **
(29,859.82) Monthly Total .00 Budgeted
119,214.14 Remaining 0 % Used
Fund 536 Totals: (119,214.14)
(29,859.82) Monthly Total .00 Budgeted
119,214.14 Remaining 0 % Used
Grand Totals: (1,854,133.85) ****
(548,373.18) Monthly Total (209,104.00) Budgeted 1,645,029.85 Remaining 887 % Used
******* End of Report *********
147 of 155
February 17, 2020 Regular Meeting Agenda Packet
BUDGET VARIANCE REPORT
FUND: 122 - Fire O&M
FINANCIALS MONTH: January 2020
REVENUE VARIANCE: 24.9%
EXPENSE VARIANCE: 43.2%
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 $456,982 $1,084,569 89.32% 10/2019 Property Taxes/MUD Fire
122-40011 Property Taxes/Fire - Delinquent $1,376 $1,022 10/2019 Delinquent Fire Taxes
collected/paid out
122-40020 Property Taxes/Fire P&I $426 $1,648 10/2019 Fire Taxes Penalties & Interest
collected
FIRE EXPENSES
148 of 155
BUDGET VARIANCE
FUND:
FINANCIALS MONTH:
REVENUE VARIANCE:
EXPENSE VARIANCE:
NOTE:
ACCOUNT
REVENUE
135-47000-000
EXPENSES
WATER
135-50010-010
135-69008-010
135-69009-010
135-69281-010
WASTEWATER
135-55081-020
135-60010-020
135-65030-020
135-65045-020
135-69008-020
135-69009-020
BOARD OF DIRECTORS
ADMINISTRATION
1135-55030-030
1135-60070-030
1135-65095-030
1
1 Non -Departmental
1135-55055-039
1
February 17, 2020 Regular Meeting Agenda Packet
REPORT
135 - MUD 1 O&M
January 2020
24.9%
43.2%
Explanation provided for all accounts with a Year -To -Date percentage (YTD%) less than the Revenue Variance and greater than or equal to the
Expense Variance. The Revenue and Expense Variance is calculated on a straight-line method (Financials Month x 8.3%), less 8.3% for revenues
and plus 10% for expenses. Only accounts with current month activity will be listed
DESCRIPTION TOTAL CURRENT YTD YTD % DATE OF VARIANCE EXPLANATION
BUDGET MONTH TOTAL COMMENT
Water $6,486,623 $308,154 $1,523,137 23.48% 01/2020 Water Sales
Overtime
Short Term Debt- Principal
Short Term Debt- Interest
Water Tank Inspection Contract
Maintenance & Repairs Collections
Communications/Mobiles
Chemicals
Lab Supplies
Short Term Debt- Principal
Short Term Debt- Interest
Software & Support
Dues & Memberships
Maintenance Supplies
Auditing
$17,000 $2,257 $7,648 44.99% 01/2020
$30,512 $30,512 $30,512 100.00% 01/2020
$3,231 $1,840 $1,840 56.95% 01/2020
$120,000 $44,144 $102,077 85.06% 01/2020
$10,000 $1,101 $15,378 153.78% 01/2020
$5,000 $685 $2,271 45.41% 01/2020
$20,000 $3,048 $9,868 49.34% 11/2019
$20,000 $2,831 $10,837 54.19% 12/2019
$79,133 $59,605 $59,605 75.32% 01/2020
$11,277 $6,122 $6,122 54.29% 01/2020
$134,681
$6,000
$4,000
$51,870 $125,274
$80 $4,167
$1,176 $2,397
93.02% 01/2020
69.44% 01/2020
59.92% 01/2020
Overtime
Annual Principal Payment
Semi -Annual Interest Payment
Annual Contract Multiple Tanks
LS Repairs
New Tablet and Service
Chemicals
Lab PH Meter, Lab Supplies
Semi -Annual Principal Payment
Semi -Annual Interest Payment
Annual Contract STW & OpenGov
Annual Dues
Office Supplies
$33,800 $12,563 $27,713 81.99% 01/2020 FY 19 Audit Completion
149 of 155
February 17, 2020 Regular Meeting Agenda Packet
Trophy Club Municipal Utility District No. 1
General Manager's Report
Regulatory Updates
Breaks and Leaks — No reportable breaks or leaks have occurred since the last report.
Sanitary Sewer Overflows (SSO1— No SSO's have occurred since the last report.
Capital Improvement Projects
WWTP — Here is the timeline for the Building with sound curtains provided by the contractor:
Provide Structural Drawings 2-4-2020
Release Building 2-5-2020
Receive Building 2-11-2020
Install building 2-11-2020 to 2-18-2020
Install Sound Wall 2-19-2020 to 2-21-2020
High Service Pump Station Upgrade — The pump can leveling has been completed and the pump and
motor is installed. We have a startup date of Feb. 24tH
150 of 155
- 2016
- 2017
- 2018
2019
- 2020
1
February 17, 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
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 34592 40,658 43,411 60,079 89,802 118,899 126,588 125,531 73,735 913,766
2019 47,193 41,933 36,244 34,604 33,740 40,421 55,970 42,773 70,747 96,174 131,472 114,784 746,055
2020 1
140,000
120,000
100,000
80,000
60,000
40,000
20,000
0
102,150 1 40.988 1
43,946 1 36,418 1
WATER BILLED IN THOUSANDS OF GALLONS
1
-I 1
7
October November December January Februaryril May
June
ust September
Water Pumped
FY October November December January February March April May June July August September Total Year
2011 70,502 50,993 44,220 33,789 36,053 54,775 71,306 63,500 116,350 152,002 169,621 117,190 980,301
2012 83,750 54,245 41,650 34,740 31,581 46,519 62,649 100,402 110,324 153,813 139,005 123,045 981,723
2013 85,966 77,758 55,110 39,283 37,867 56,743 60,969 87,168 96,602 119,414 145,988 120,342 983,210
2014 81,909 51,769 39,769 48,758 42,395 61,100 71,283 96,481 95,206 110,173 123,369 115,607 937,819
2015 106,251 67,825 58,659 45,691 39,675 35,752 56,704 48,637 72,934 117,302 143,413 142,394 935,237
2016 106,731 52,616 43,708 46,945 50,721 55,178 60,434 55,562 68,138 112,533 128,963 104,664 886,193
2017 82,677 77,937 43,792 43,207 43,024 69,549 65,723 94,452 103,867 101,184 114,872 109,769 950,053
2018 91,439 78,282 55,745 40,796 40,750 51,711 67,217 97,980 124,109 155,354 144,015 85,946 1,033,344
2019 60,576 53,119 45,651 45,552 39,014 43,048 61,238 48,787 79,167 102,887 144,299 130,752 854,090
2020 1 112,971 1 48,627 1 49,384 1 40,726 1 1 1 1 1 1 1 ■ 1
180,000
160,000
140,000
120,000
100,000
80,000
60,000
40,000
20,000
0
WATER PUMPED IN THOUSANDS 16Z5MI
October November December January February March
April May June 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
2015 MUD 3083 3087 3095 3119 3120 3122 3123 3128 3133 3134 3137 3149
2015 PID 1270 1276 1282 1285 1293 1307 1320 1331 1345 1352 1361 1368
2016 PID 1376 1380 1389 1396 1417 1423 1424 1430 1434 1435 1436 1436
2017 PID 1436 1437 1441 1441 1442 1442 1442 1442 1443 1443 1444 1444
2018 PID 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444
2019 PID 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444
2020 Total 4795 4796 4797 4797
2020 MUD 3351 3352 3353 3353
2020 PID 1444 1444 1444 1444
151 of 155
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
February 17, 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
3841 3845 3860 3835
646 650 652 654
1193 1185 1193 1198
1145 1192 1,184 1,208
378 453 339 462
21 41 42 27
M 3351 3352 3353 3353
P 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
152 of 155
February 17, 2020 Regular Meeting Agenda Packet
MUD Permits
Month: January 2020
Plumbing Sewer
Date of Customer Deposit Due to FW Water 135- Inspections 135- Inspections 135- Misc Income
Permit Permit No. 135-25030 20500 Oversize Meter 135-49075 47035 47045 Fire Line 135-49900 135-49900 Total
1/17/2020 2020-16 $ 75.00 $ 1,173.00 $ 353.00 $ 150.00 $ 50.00 $ 1,801.00
Total $ 75.00 $ 1,173.00 $ 353.00 $ 150.00 $ 50.00 $
153 of 155
$ 1,801.00
CASH STATUS AS OF JANUARY 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)
*01/31/2020 Customer Water Deposits $318,815
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
154 of 155
February 17, 2020 Regular Meeting Agenda Packet
Restricted -
Unable to be spent
$o
$318,815
$1,400,451
$0
$0
$919,266
$547,320
$0
$0
$783,441
$552,598
$3,884,957
$849,568
$736,540
$0
$242,846
$105,417
$119,214
$10,460,431
$o
$0
Unrestricted -
Available for
spending
$4,066,755
$2,275,821
$0
$150
$450
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$6,343,176 1
$0 1
$6,343,176
$6,343,176
$1,220,452
$0
$1,220,452 l
$1,220,452
$1,220,452
Total in Accounts
(Restricted &
Unrestricted)
$4,066,755
$2,594,636
$1,400,451
$150
$450
$919,266
$547,320
$0
$0
$783,441
$552,598
$3,884,957
$849,568
$736,540
$0
$242,846
$105,417
$119,214
$16,803,608
General Fund 135 Available
2,275,821 Prosperity General Fund
4,066,755 Texpool General Fund
600 Petty Cash
6,343,176
3,486
2,072,098
6,325,800
(166,399)
$8,234,985
$1,220,452
$0
$1,220,452
TC Meeting Spaces
Calendars
FS Conference Roo
FS Training Room
Svore Board Room
March 2020
10
11
12
13
Sun Mon
Mar 1, 2020
8
15
22
2
9
16
6:30pm ritJ Boar
23
Tue
February 17, 2020 Regular Meeting Agenda Packed,_ Modifier
Wed
Election Day (
6am Denton C
4
10 11
17 18
24 25
14 29 30 31 tips
155 of 155
Thu
5
6:30pm TCWC
12
19
26
6:30pm TCWC
Fri Sat
6
13
20
27
7
14
21
28
Powered by 7 team