HomeMy WebLinkAbout2019-1216 December 16, 2019 Regular Meeting Complete Agenda PacketEP
TROPHY CLUB
MUNICIPAL I
UTILITY
DISTRICT
December 16, 2019 Regular Meeting Agenda Packet
BOARD OF DIRECTORS
REGULAR MEETING
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
100 MUNICIPAL DRIVE
TROPHY CLUB, TEXAS 76262
December 16, 2019 6:30 P.M.
REGULAR MEETING AGENDA
CALL TO ORDER AND ANNOUNCE A QUORUM
Svore Municipal Boardroom
CITIZEN COMMENTS
This is an opportunity for citizens to address the Board on any matter whether or not it is posted on the agenda.
The Board is not permitted to take action on or discuss any comments made to the Board at this time
concerning an item not listed on the agenda. The Board will hear comments on specific agenda items prior to
the Board addressing those items. You may speak up to four (4) minutes or the time limit determined by the
President or presiding officer. To speak during this item, you must complete the Speaker's form that includes
the topic(s) of your statement. Citizen Comments should be limited to matters over which the Board has
authority.
CONSENT AGENDA
All matters listed as Consent Agenda are considered to be routine by the Board of Directors and will be
enacted by one motion. There will not be a separate discussion of these items. If discussion is desired, that
item will be removed from the consent agenda and will be considered separately.
1. Consider and take appropriate action to approve the Consent Agenda.
a. November Check Register
b. November 14, 2019 Regular Meeting minutes
c. November 22, 2019 Special Meeting minutes
attachments: Check Register
November 14, 2019 meeting minutes
November 22, 2019 meeting minutes
REGULAR SESSION
2. Discussion and possible action regarding sewer line break at 55 Sonora Drive and related repairs and
damages.
3. Consider and take appropriate action regarding Candidate Search for General Manager
(Castonguay/Flynn)
a. Receive report and recommendation from Recruitment and Retention Subcommittee; and
b. Approve Contract No. 2019121601 with executive search firm to identify potential General Manager
1 of 140
December 16, 2019 Regular Meeting Agenda Packet
Candidates
attachment: Contract No. 2019121601
4. Consider and take appropriate action regarding approval of Contract with Texas Commission on
Environmental Quality relating to the District's Superior Water System Designation and Related Sign
Obligations
attachment: TCEQ Superior Water Recognition Agreement
5. Consider and take appropriate action regarding Adoption of Order No. 2019-1216 Authorizing General
Manager to Contract for Purchase and Installation of Prefabricated Building and Sound Mitigation
Improvements at the Wastewater Treatment Plant Facility
attachment: Order No. 2019-1216
6. Consider and take appropriate action regarding approval of Proposal by Halff Associates, Inc. for
Preparation of an Updated Legal Description and Boundary Map Trophy Club Municipal Utility District
No. 1 and authorize execution thereof by General Manager.
attachment: Halff Associates Proposal
7. Consider and take appropriate action regarding the November 2019 Combined Financials and Variance
Report.
a. Combined Financials
b. Combined Variance
attachments: Combined Financials
Combined Variance
REPORTS & UPDATES
8. General Manager Monthly Reports and Update:
a. Regulatory Update
b. Capital Improvement Projects
• Interconnect Water Transmission Line Phase 2
• Wastewater Treatment Plant Upgrade Project
• High Service Pump
c. System Repairs & Maintenance
d. Water System Operations
e. Wastewater System Operations
f. Finance Update
• Fiscal Year 2019 Summary
• GASB 54 Reporting
• Utility Billing Report
2 of 140
December 16, 2019 Regular Meeting Agenda Packet
• Permits Collected
• Cash Report
attachments: General Manager Report
Water Operations Report
Wastewater Operations Report
FY2019 Yearend Summary
GASB54 Calculations
GASB54 Designations
Utility Billing Report
Permits Collected
Cash Report
EXECUTIVE SESSION
9. Pursuant to Section 551.071 of the Texas Open Meetings Act, the Board may consult with its attorney in
Executive Session on a matter in which the duty of the attorney to the Governmental Body under the
Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflicts with the Open
Meetings Act or to seek advice of counsel on legal matters involving pending or contemplated litigation
or settlement offers:
a. Contractor breach, performance and payment issues related to District's contract with Webber-
Cadagua Partners for construction of the Wastewater Treatment Plant Improvements; and
b. Trophy Club Municipal Utility District No. 1 v. Acadia Services, LLC, In the District Court of Tarrant
County, 141st Judicial District (Cause No. 141-299351-18).
c. Potential Condemnation of Easements required for construction and operation of Water
Transmission Line Improvements from District Pump Station to Elevated Water Tank located on T.W.
King Road
10. Pursuant to Section 551.072 of the Texas Open Meetings Act, the Board may deliberate the purchase,
exchange, lease, or value of real property if deliberation in an open meeting would have a detrimental
effect on the position of the governmental body in negotiations with a third person:
a. Sale or Exchange of District real property located at 100 Municipal Drive and 1501 Junction Way.
b. Purchase of Easements required for construction and operation of Water Transmission Line
Improvements from District Pump Station to Elevated Water Tank located on T.W. King Road
11. 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.
REGULAR SESSION
12. Consider and take appropriate action on matters deliberated in Executive Session:
13. Items for future agendas:
3 of 140
December 16, 2019 Regular Meeting Agenda Packet
14. Set future Meeting dates:
a. Regular Board Meeting — Monday, January 20, 2020 at 6:30 p.m.
attachment: January meeting calendar
*THE BOARD RESERVES THE RIGHT TO ADJOURN INTO EXECUTIVE SESSION AT ANY TIME DURING THE
MEETING PURSUANT TO THE APPLICABLE SECTION OF SUBCHAPTER D, CHAPTER 551, TEXAS GOVERNMENT
CODE, THE TEXAS OPEN MEETINGS ACT, WITH RESPECT TO ANY ITEM ON THE AGENDA. NO FINAL ACTION,
DECISION OR VOTE WILL BE TAKEN ON ANY SUBJECT OR MATTER IN EXECUTIVE SESSION. THIS NOTICE
MODIFIES THE DISTRICT'S PRIOR PRACTICE OF SPECIFICALLY IDENTIFYING ALL AGENDA ITEMS TO BE
DISCUSSED IN EXECUTIVE SESSION.
ADJOURN
4 of 140
apackamt2 skrolczyk
Begin Date: 11/01/2019 End Date: 11/30/2019
vends vend Name
Number
998 HRCF41, DEE
Totals for Check: 5875
998 DREES MS= MSS
Totals for Check: 5876
998 DRUt48, WILISPM
Totals for Check: 5877
998 REDWINE, EL/ZABETH
Totals for Check: 5878
998 SHAM3N, .XE4 C
Tbtals for Check: 5879
2943 JPMORGAN CHASE BANK NA
2943 .7PMGRGAN CHASE BANK NA
Totals for Check: 5880
3213 Alan's Gates, Inc.
Totals for Cherdc: 5881
1005 =mummy SUPPLY CO.
1005 ATLAS UTILITY SUPPLY CO.
1005 ATLAS UT L TY SUPPLY CO.
Totals for Chedk: 5882
1926 BADGER METER, INC
Tbtals for Check: 5883
2655 Care & Main LP
Tbtals for Check: 5884
3184 namnunaF LLC
3184 DPTAPROSE LLC
Totals for Check: 5885
998 ffiS., SAIW L.
Totals for Check: 5886
2720 Filter Element Store
Tbtals for Check: 5887
2606 Fisery Solutions, LLC
Totals for Check: 5888
2635 Half£ Associates, INC
From Amt:
Invoice muter Invoice Inv Dept Account
Date Stat No Number
U0010020066104A 10/31/19 P 135-20050-000-000
U0017000007100A 10/31/19 P 135-20050-000-000
U0010050444103A 10/31/19 P 135-20050-000-000
00020000935213A 10/31/19 P 135-20050-000-000
U0010200020106A 10/31/19 P 135-20050-000-000
9/30/2019 09/30/19 P 135-20060-000-000
10282019 10/28/19 P 135-20060-000-000
9371 11/06/19 P 10 135-55080-010-000
10913A 11/05/19 P 10 135-69005-010-000
10913 10/30/19 P 10 135-69005-010-000
11497 10/22/19 P 10 135-65050-010-000
1330065 11/01/19 P 10 135-69005-010-000
1447823 11/01/19 P 10 135-55080-010-000
DP1903698 10/31/19 P 30 135-60035-030-000
DP1903698 10/31/19 P 30 135-55205-030-000
U0020660003201A 11/07/19 P 135-20050-000-000
SI -107780
91600888
30251
10/28/19 P 20 135-55080-020-000
11/04/19 P 30 135-60040-030-000
11/06/19 P 10. 135-69005-010-000
Trophy Club NOD No.1
AP Checks For Date/Amount Range
.00 To Amt: 99,999,999.99
i>escriptaon
A/P Verdo s
A/P Vendors
A/P Vendors
A/P Vendors
A/P Venders
Procurement Clearing
Procurement Clearing
Maintpr m, & Repairs
Capital Outlays
Capital Outlays
Meter Expense
Capital Outlays
Maintenance & Repairs
Postage
Utility Billing Oontract
A/P Verk¢s
Maintenance & Repairs
Service Charges & Fees
Capital Outlays
5 of 140
Ctilo r 10,,:2419 Regular Meeting Agenda Pmt 1
Lane lten C leClc C21eCJc
Value Nus Date
13.31 5875 11/05/19
13.31
53.41 5876 11/05/19
53.41
39.63 5877 11/05/19
39.63
27.15 5878 11/05/19
27.15
08.16 5879 11/05/19
08.16
32284.42 5880 11/05/19
7,424.61 5880 11/05/19
10,709.03
1,178.00 5881 11/07/19
1,178.00
3,500.00 5882 11/07/19
3,800.00 5882 11/07/19
7,050.00 5882 11/07/19
14,350.00
5,472.00 5883 11/07/19
5,472.00
257.50 5884 11/07/19
257.50
1,624.07 5885 11/07/19
582.15 5885 11/07/19
2,206.22
483.29 5886 11/07/19
483.29
331.12 5887 11/07/19
331.12
50.00 5888 11/07/19
50.00
1,259.00 5889 11/07/19
apackasnt2 skrolczyk
Begin Date: 11/01/2019 End Date: 11/30/2019
vemor vgwnr Name
Number
Tbtals for Check: 5889
1372 HACH COMPANY
Totals for Check: 5890
2676 Humana Inc
2676 }Arcane Inc
2676 Humana Inc
2676 Humana Inc
2676 Humana Inc
2676 Humana Inc
Totals for Check: 5891
um Ant:
invoice Tami'teer invoice Inv pep: Amt
Date Stat No Number
11684701 10/16/19 P 10 135-65030-010-000
155516833 11/13/19 P
155516833 11/13/19 P
155516833 11/13/19 P
155516833 11/13/19 P
155516833 11/13/19 P
155516833 11/13/19 P
1249 BOTHER AND ASSOCIATTS,INC 8113
Totals for Check: 5892
3167 KEYSTONE PARK SECREMIAL 157561
Totals for Cheek: 5893
1468 L.H. CSHANET MATERIALS, INC. 167521
Totals for Check: 5894
3186 MEMBER'S BUILDING NAINIENANCE TC1910TOMD
3186 MEMBER'S DING LAIN ENA1ICE TC1910TCMUD
3186 MEMBER'S BUILDING MAINTENANCE TC1910TCMUD
Totals for check: 5895
3115 MEI1I9E GROUP BEFITS
3115 ME11IFE GROUP BENEFITS
3115 MTTT•IPE CROUP BENEFITS
3115 M ML1PE (ROUP BENEFITS
Totals for Check: 5896
1053 NORTH CENTRAL TX CLOG
Totals for Check: 5897
3156 OXLDOR LABORATORIES LLC
3156 0=0R LABORATORIES LIC
3156 07CLtXit2 LABORATORIES LLC
3156 C=OR LABOATC$tii+5 LTC
3156 OXLDOR LABORATORIES LLC
3156 O7iID0a2 uocemonms LTC
Totals for CSck: 5898
11/15/2019
11/15/2019
11/15/2019
11/15/2019
INV -36926
19100513
19100577
19100656
19100722
19110097
19110052
3231 SC TRACKING SOLUTIONS LSC 128
Totais far•Chedk: 5899
10/29/19 P
10/30/19 P
10/26/19 P
10/31/19
10/31/19
10/31/19
11/15/19
11/15/19
11/15/19
11/15/19
10
20
30
135-21308-000-000
135-21309-000-000
135-21311-000-000
135-50029-010-000
135-50029-020-000
135-50029-030-000
20, 135-65045-020-000
30 135-60005-030-000
20 135-55125-020-000
P 20 135-55120-020-000
P 30 135-55120-030-000
P 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
10/30/19 P 30 135-60070-030-000
10/21/19
10/23/19
10/28/19
10/31/19
11/06/19
11/04/19
P 20 135-55135-020-000
P 20' 135-55135-020-000
P 20 135-55135-020-000
P 20 135-55135-020-000
P 20 135-55135-020-000
P 20 135-55135-020-000
11/01/19 P 30 135-55070-030-000
Trophy club MUD No.1
AP Checks For Date/Amount Range
.00 To Amt: 99,999,999.99
17escriptaon
Chemicals
Dental
Vision
Voluntary Life
Life Insurance & Other
Life Insurance & Other
Life Insurance & Other
Lab Supplies
Telephone
Dumpsters Services
Cleaning Services
C7cgnirg Services
Cleaning Services
Start Tenn Disability
Life Insurance & Other
Life Insurance & Other
Life Insurance & Other
Dues & Memberships
Lab Analysis
Lab Analysis
Lab Analysis
Lab Analysis
Lab Analysis
Lab Analysis
TxtdepemdeatTahrrr
6 of 140
C UNA r 1$:x®19 Regular Meeting Agenda Pmt 2
t.,,•w item U ec1 - check
Value _ Number Date
1,259.00
907.47 5890 11/07/19
907.47
1,253.49 5891 11/07/19
181.70 5891 11/07/19
274.75 5891 11/07/19
125.44 5891 11/07/19
148.12 5891 11/07/19
149.52 5891 11/07/19
2,133.02
1,080.00 5892 11/07/19
1,080.00
207.75 5893 11/07/19
207.75
1,240.00 5894 11/07/19
1,240.00
87.50 5895 11/07/19
869.06 5895 11/07/19
87.50 5895 11/07/19
1,044.06
97.51 5896 11/07/19
123.66 5896 11/07/19
157.87 5896 11/07/19
160.48 5896 11/07/19
539.52
100.00 5897 11/07/19
100.00
317.40 5898 11/07/19
230.00 5898 11/07/19
317.40 5898 11/07/19
230.00 5898 11/07/19
230.00 5898 11/07/19
317.40 5898 11/07/19
1,642.20
595.00 5899 11/07/19
595.00
apackamt2 skoolczyk
Begin Date: 11/01/2019 Find Date: 11/30/2019
Vendor Vendor fame
Number
1578 SMITH PUMP MANY, INC.
Totals for Check: 5900
1001
1001
1001
1001
1001
1001
1001
WAN OF TROPHY CLUB
TOM OF TROPHY CLUB
TOWN OF TROPHY CLUB
MSC OF TROPHY OWB
TOWN OF TROPHY CLUB
TOWN OF TROPHY CLUB
TON OF TROPHY CLUB
Totals for Cheat: 5901
1000 TROPHY CLiB MOD (EATER BTT )
Totals for Check: 5902
2858 UTILTPY SERVICE OJ, INC.
Totals for Check: 5903
1rivalCe ,fhxtt er
SI016753
Fran Amt:
Invoice 1x1V Dep: Account
Date Stat fb Number
10/29/19 P 20 135-55081-020-000
OCT REFUSE 10/31/19
OCT REFUSE 10/31/19
OCT REFUSE 10/31/19
FY19 REFUSE AAT 09/30/19
EY19 RUSE AAT 09/30/19
FY19 REFUSE ADT 09/30/19
110119 11/04/19
10/31/2019
P 135-25040-000-000
P 135-25000-000-000
P 135-25010-000-000
P 135-25040-000-000
P 135-25000-000-000
P 135-25010-000-000
P 45 122-60337-045-000
10/31/19 P 30 135-60025-030-000
492210 11/01/19 P 10 135-69281-010-000
2663 ACE Heating & Air Conditioning 11/1/2019
Totals for Check: 5904
2651 Carman Cknsultiag ILC.
2651 Carman Consulting LLC.
2651 Chan Cknsulting LLC.
Totals for (Heck: 5905
2683 Charter C annanicaticns
Totals for Check: 5906
2677 Digital Air Ointrol, Inc
Totals for Cheek: 5907
2635 Raiff Associates, INC
Totals for Check: 5908
1372 HACH COMPANY
Totals for Chedeckk: 5909
1468 L.H. CHAN'sY MATERIALS, INC.
Totals for Check: 5910
2643 Mttean & Howard, L.L.P.
2643 McLean & Howard, L.L.P.
Totals for Check: 5911
2392 MICKEY D MESON EEA/
Totals for Check: 5912
Troptxy club MUD No.1
AP Checks For Date/Amount Range
.00 Tb Pmt: 99,999,999.99
Description
Mainten & Repairs C'+1lections
Town -Stomp. Drainage
Refuse
Refuse Tax
Town -Storm Drainage
Refuse
Refuse Tax
Transfer to Tbrax/Fire Budget
Water
Water Tank Inspection contract
11/01/19 P 45 122-69005-045-000 Capital Outlays
27 11/08/19 P 3
27 11/08/19 P 3
27 11/08/19 P 3
71672110619
2050313
30284
11709701
168104
35276
35277
1004191
11/06/19 P
11/10/19 P
11/07/19 P
11/04/19 P
11/09/19 P
10/31/19 P
10/31/19 P
11/08/19 P
O 135-55070-030-000
0 135-55070-030-000
O 135-55070-030-000
30 135-55030-030-000
30 135-60235-030-000
10 135-69005-010-000
20 135-65045-020-000
20 135-55125-020-000
39 135-55045-039-000
39 135-55045-039-000
20 135-65031-020-000
IndePmdent Iah+r
/ndependont Iabor
Independent rAbor
Software & Support
Security
Capital Outlays
Lab Supplies
Darpster Sertiices
Legal
Legal
Chemicals Collections
7 of 140
114 r 14i4,:2419 Regular Meeting Agenda Pmt 3
Litre ltem C:necx cue=
Value Harker Date
416.06 5900 11/07/19
416.06
35,751.59
65,109.34
5,351.11
06.00
14.94
02.46
59,888 08
166,123.52
5901
5901
5901
5901
5901
5901
5901
11/07/19
11/07/19
11/07/19
11/07/19
11/07/19
11/07/19
11/07/19
133.55 5902 11/07/19
133.55
57;932.73 5903 11/07/19
57,932:73
1,700.00 5904 11/14/19
1,700.00
32.48
11,680.00
04:15
11,716.63
5905 11/14/19
5905 11/14/19
5905 11/14/19
899.00 5906 11/14/19
899.00
24.00 5907 11/14/19
24.00
3,055.78 5908 11/14/19
3;055:78
298.43 5909 11/14/19
1,233.18 5910 11/14/19
1,233.18
298.43
3,570.00 5911 11/14/19
1,050.00 5911 11/14/19
4,620.00
4,994.00 5912 11/14/19
4,994.00
aackattt2 skrolczyk
Begin Date: 11/01/2019 End Date: 11/30/2019
Vendor vendor Name
N Amber
3111 North N693OroundWater
Total q far Check: 5913
1056 OFFICE DEPOT, SNC
Totals far Check: 5914
2723 Ross en Enterprises Inc
Tbtais far Check: 5915
uu Amt:
Invoice amber Invoice Inv Dept Account
Date Stat No Nhnber
177
395550479001
PSI19-1140
2440 TARRANT CTY PUBLIC HEALTH LAB 32686
2440 TARRANT CTY PUBLIC HEALTH IAB 32687
Totals far Check: 5916
3282 TIAA COMMERCIAL FIANCE 6677723
Totals for Check: 5917
1081 TRI COUNTY ELECTRIC 76332899
Totals for Check: 5918
2634 Valley Solvent CknCaany, INC 49314
Totals for Check: 5919
1058 VERIZENTRILESS
1058 VFRIZLN WIRELESS
1058 VERIZ(N WSRE[ESS
Ttjta1q for Check: 5920
Grand Totals:
****** End of Report *********
9841164346
9641164346
9841164346
10/31/19 P
10/29/19 P
11/14/19 P
10/31/19 P
10/31/19 P
11/07/19 P
10/29/19 P
11/11/19 P
10 135-60135-010-000
30 135-65085-030-000
45 122-69005-045-000
10 135-55135-010-000
10 135-55135-010-001
30 135-69170-030-000
20 135-60020-020-000
20 135-65030-020-000
11/01/19 P 10 135-60010-010-000
11/01/19 P 20 135-60010-020-000
11/01/19 P 30 135-60010-030-000
Trophy Club ).W No.1
AP Checks For Date/Amount Range
.00 Tb Amt: 99,999,999.99
Description
TC3sl0 Fees & Permits
Office Supplies
Capital Outlays
Lab Analysis
Lab Analysis for PID
Copier Lease Installments
Electricity
Chsniral a
Camrunications/Mobiles
Carrru:icaticns/Mobiles
Oattrunicatirmw/Mnbiles
8 of 140
E % /i r 1 :2419 Regular Meeting Agenda Pmt 4
Luse Item (Zeck (meek
Value Number Date
5,752.20
5,752.20
112.18
112.18
1,050.00
1,050.00
140.00
80.00
220.00
165.00
165.00
500.86
500.86
569.00
569.00
865.02
769.01
88.02
1,722.05
309,165.01
5913 11/14/19
5914 11/14/19
5915 11/14/19
5916 11/14/19
5916 11/14/19
5917 11/14/19
5918 11/14/19
5919 11/14/19
5920 11/14/19
5920 11/14/19
5920 11/14/19
December 16, 2019 Regular Meeting Agenda Packet
REGULAR MEETING MINUTES
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
BOARD OF DIRECTORS
November 14, 2019 at 4:30 P.M.
Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in regular
session on Thursday, November 14, 2019 at 4: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
Desiree Grubbs
President
Vice President
Secretary/Treasurer
Director
Director
General Manager
District Secretary
Operations Manager
Finance Manager
Wastewater Superintendent
Staff Accountant/HR Coordinator
CALL TO ORDER AND ANNOUNCE A QUORUM
President Wilson announced the date of November 14,
quorum of the Board was present at 4:30 p.m.
The Board convened into Executive Session at 4:31 p.m.
2019, called the meeting to order and stated a
EXECUTIVE SESSION
1. 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 8:39 p.m.
REGULAR SESSION
2. Consider and take appropriate action on matters deliberated in Executive Session:
President Wilson stated that no decisions, votes or actions were taken in Executive Session.
CITIZEN COMMENTS:
Brock Harwell
55 Sonora Drive
9 of 140
December 16, 2019 Regular Meeting Agenda Packet
CONSENT AGENDA
3. Consider and take appropriate action to approve the Consent Agenda.
a. October Check Register
b. October 21, 2019 Regular Meeting minutes
Motion made by Director Rose and seconded by Director Flynn to approve the Consent Agenda.
Motion carried unanimously
REGULAR SESSION
4. Consider and take appropriate action to appoint two (2) directors to serve on the Audit Committee.
Motion made by Director Castonguay and seconded by Director Flynn to appoint President Wilson and
Vice President Rose to serve on the Audit Committee.
Motion carried unanimously
5. Discussion and possible action regarding noise level at the wastewater treatment plant. (Flynn/Wilson)
Direction was provided for staff to obtain a total cost for the structure along with a timeline for
completion back to the board on the December 16, 2019 meeting.
6. Consider and take appropriate action regarding employee health and ancillary benefits for the calendar
year beginning January 1, 2020 and ending December 31, 2020. (Staff)
Motion made by Director Rose and seconded by Director Castonguay to have the District maintain
coverage with United Healthcare All Savers for Medical benefits, and Humana and MetLife for ancillary
benefits for the 2020 year.
Motion carried unanimously
7. Consider and take appropriate action regarding the October 2019 Combined Financials and Variance
Report. (Staff)
a. Combined Financials
b. Combined Variance
Motion made by Director Flynn and seconded by Director Chapman to approve the October 2019
Combined Financials and Variance Reports.
Motion carried unanimously
10 of 140
December 16, 2019 Regular Meeting Agenda Packet
REPORTS & UPDATES
8. General Manager Monthly Reports and Update:
a. Regulatory Update
b. Capital Improvement Projects
• Interconnect Water Transmission Line Phase 2
• Wastewater Treatment Plant Upgrade Project
• High Service Pump
c. System Repairs & Maintenance
d. Water System Operations
e. Wastewater System Operations
f. Finance Update
• Utility Billing Report
• Permits Collected
• Cash Report
General Manager John Carman presented his monthly update to the Board and answered questions
related thereto.
9. Items for future agendas:
— Staff is to provide an estimate of the total cost for the blower surround structure at the wastewater
treatment plant as well as a timeline for completion at the December meeting
— Update regarding 55 Sonora Drive
10. Set future Meeting dates:
a. Regular Board Meeting — Monday, December 16, 2019 at 6:30 p.m.
ADJOURN
President Wilson called the meeting adjourned at 9:18p.m.
Gregory Wilson, President
Steve Flynn, Secretary/Treasurer
Laurie Slaght, District Secretary
11 of 140
(SEAL)
December 16, 2019 Regular Meeting Agenda Packet
SPECIAL MEETING MINUTES
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
BOARD OF DIRECTORS
November 22, 2019 at 3:00 P.M.
Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in a
special session on Friday, November 22, 2019 at 3:00 P.M., in the Boardroom of the Administration Building,
100 Municipal Drive, Trophy Club, Texas 76262. The meeting was held within the boundaries of the District
and was open to the public.
STATE OF TEXAS §
COUNTIES OF DENTON AND TARRANT
BOARD MEMBERS PRESENT:
Gregory Wilson President
William C. Rose Vice President
Steve Flynn Secretary/Treasurer
Kelly Castonguay Director
Mark Chapman Director
STAFF PRESENT:
John Carman
Laurie Slaght
Frank Isola
Desiree Grubbs
§
General Manager
District Secretary
Wastewater Superintendent
Staff Accountant/HR Coordinator
CALL TO ORDER AND ANNOUNCE A QUORUM
President Wilson announced the date of November 22, 2019, called the meeting to order and announced a
quorum of the Board was present at 3:00 p.m.
The Board convened into Executive Session at 3:01 p.m.
EXECUTIVE SESSION
1. 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 4:34 p.m.
REGULAR SESSION
2. Consider and take appropriate action relating to employment of new General Manager
No action taken
3. Consider and take appropriate action relating to repair of groundwater well pump and related
equipment.
General Manager John Carman stated that there had been a failure in groundwater well No. 1 involving
the electrical panel and breakers as well as the pump. The estimate to replace the pump is $50,000 and
12 of 140
December 16, 2019 Regular Meeting Agenda Packet
that the parts had been ordered as this was an emergency procurement.
4. Consider and take appropriate action regarding request by Denton County Elections to use the Svore
Municipal Boardroom as an early voting polling location for the March 2, 2020 Primary Election.
Discussion only, no action taken
ADJOURN
President Wilson called the meeting adjourned at 4:45 p.m.
Gregory Wilson, President
Steve Flynn, Secretary/Treasurer
Laurie Slaght, District Secretary
13 of 140
(SEAL)
Sk0R
December 16, 2019 Regular Meeting Agenda Packet
Date: December 12, 2019
Agreement for Executive Recruitment Services
for General Manager
between
Strategic Government Resources, Inc. ("SGR")
and
Trophy Club Municipal Utility District No. 1 ("Organization")
Scope of Services. SGR shall provide all services for recruitment as described in the formal
proposal dated June 28, 2019, a copy of which is attached hereto, and described in abbreviated
form as follows:
• Develop a position profile and recruitment brochure for the position. **Please note that
for any changes made to the Position Profile Brochure after the position is launched,
there will be a $250 Change Fee per occurrence**
• Place ads in appropriate professional publications, as approved.
• Social media and email marketing of position.
• Identify high -probability prospects and follow up with those prospects.
• Receive, track, and maintain all inquiries and applications.
• Conduct a "triage" level review of all resumes and conduct initial phone/email
conversations with candidates.
• Develop written questionnaire customized to the position, distribute questionnaires to
semifinalist candidates, and evaluate responses.
• Conduct pre-recorded online interviews with up to 12 semifinalist candidates.
• Conduct Stage 1 Media Searches on up to 12 semifinalist candidates.
• Provide periodic updates regarding the progress of the search, as frequently as desired.
• Assist Organization in developing a short list of up to 6 finalist candidates recommended
for interviews and present a verbal briefing on relevant issues related to each.
• Assist in preparation of recommended interview questions and of the interview process.
• Conduct comprehensive Stage 2 Media Searches on up to 6 finalist candidates.
• Conduct psychometric assessments on up to 6 finalist candidates, if requested.
PO Box 1642, Keller, TX 76244 817143 7t$ 81 www.GovernmentResource.com
December 16, 2019 Regular Meeting Agenda Packet
• Conduct Reference Checks. Our reference checks are the most comprehensive in the
industry. We will talk to as many professional contacts as necessary in order to fully
understand a given candidate's style, personality, strengths, and weaknesses. We will ask
candidates for contacts from their current or most recent organization, including:
• All Department Heads and/or Direct Reports
• Two Professional Peers in other organizations
• All Assistant or Deputy City Managers, if any
• All Elected Officials
• Two Community Leaders
• Any other individuals who would provide meaningful insights
We always seek out the candidate's greatest critics and greatest fans to ensure a
complete, yet balanced, perspective and overview of each candidate.
• Conduct comprehensive background investigation on up to 6 finalist candidates
consisting of SSN trace and address verification; credit and financial summaries and credit
bureau report; personal information, address, and employment comparisons; county
criminal and civil records search (for last three counties of residence); state criminal
records search (for last three states of residence); county wants and warrants; Federal
criminal records search; InstaCriminal national search; Global homeland security search;
sex offender records search; driving/motor vehicle records; education verification for
highest degree obtained; employment verification (if desired); and military verification (if
desired).
The Organization shall:
• Provide photos/graphics and information necessary to develop position profile brochure.
• Provide reproduction of hard copy brochure production, if desired.
• Provide any direct mailings desired by the Organization.
• Provide legal opinions to SGR regarding when and if any information must be released by
the Organization in accordance with Public Information requests. The parties agree that
all work product generated by SGR shall be owned by SGR, and the Organization shall only
be entitled to the deliverables described herein.
• Reimburse finalists for travel -related expenses to interview.
Page 2 of 6
15 of 140
December 16, 2019 Regular Meeting Agenda Packet
SGR shall be compensated by the Organization as detailed below:
• Pricing
o Professional Services = $30,000 (Plus any optional services as described below, if
desired.)
• Expense Items - SGR considers incidentals to be covered by the professional services fee,
and we do not bill the Organization for any expenses except for those explicitly detailed
herein. The expense items included in the professional services fee are as follows.
o Professional production of a high-quality brochure. This brochure (typically four
pages) is produced by SGR's graphic designer for a flat fee of $1,500.
o Marketing and Ad Placements:
■ Announcement in SGR's 10 in 10 Leadership and Innovation e -newsletter.
■ Email blast to SGR's profession -specific opt -in subscriber list.
■ Featured post on SGR's website.
■ Featured ad on SGR's job board.
■ Promotions on SGR's social media pages — Facebook, Twitter, Linkedln,
Instagram.
■ Targeted ad placements on Linkedln users' pages who have been selected
by Linkedln's algorithm to be a match for your job posting.
■ Ad placements with one national association and one state association.
These two ads are billed at actual cost, with no markup for overhead.
Additional ad placements, of the organization's choice, will be billed over
and above the not -to -exceed maximum price.
o Printing of documents and materials. The reproduction costs for briefing materials
for the governing body and/or search committee up to 10 binders, which include
semifinalist and finalist materials are billed at 26 cents per copy, plus the cost of
binders and shipping. Flash drives are billed at $10 each.
o Online Interviews. There is a cost of $200 for each recorded online interview (up
to 12 semifinalist candidates included in not -to -exceed expenses above).
o Comprehensive Media Reports — Stage 2. There is a cost of $500 per candidate (up
to 6 finalist candidates included in not -to -exceed expenses above).
o Comprehensive Background Investigation Reports. There is a cost of $400 per
candidate for our comprehensive background screening reports prepared by our
licensed private investigation provider (up to 6 finalist candidates included in not -
to -exceed expenses above).
o Travel and related costs for the Recruiter that are approved in advance by the
organization are incurred for the benefit of the Organization including travel
to/from airport. Meals are billed back at a per diem rate of $10 for breakfast, $15
Page 3 of 6
16 of 140
December 16, 2019 Regular Meeting Agenda Packet
for lunch, and $25 for dinner. Mileage will be reimbursed at the current IRS rate.
All other travel -related expenses are billed back at actual cost, with no markup for
overhead.
o Up to four (4) visits/trips by the Recruiter to the Organization. Upon prior approval
of the Organization, any additional visits/trips by the Recruiter will be billed over
and above the not -to -exceed maximum price.
• Billing
o Professional fees for the search are billed in three equal installments during the
course of the search. The initial installment is billed after the Organizational
Inquiry and Analysis is completed. The second installment is billed when
semifinalists are selected. The final installment is billed at the conclusion of the
search. Approved expense (reimbursable) items and supplemental services will be
billed with each of the three installments, as appropriate.
Organization Contact for Invoicing:
Name:
Position:
Email:
Phone:
• Optional/Supplemental Services (not included in the price above)
o Candidate Travel. Candidates are typically reimbursed directly by the Organization
for approved travel expenses. If the Organization prefers a different arrangement
for candidate travel, SGR will be glad to accommodate the Organization's wishes.
o Stakeholder Survey. SGR will conduct a Stakeholder Survey for $1,000 upon
request of the Organization. SGR provides recommended survey questions and
sets up an online survey. Stakeholders are directed to a web page or invited to
take the survey by email. A written summary of results is provided to the
organization.
o Additional Ad Placements. Additional ad placements, as approved by the
organization, that are not included in the not -to -exceed expenses will be billed
back at actual cost with no markup for overhead.
o DiSC or IOPT Assessments. There is a cost of $150 per candidate for the DiSC or
IOPT Management profile.
o Approved Site Visits to Communities of Finalist Candidates will be charged at a day
rate of $1,000 per day, plus travel expenses.
Page 4 of 6
17 of 140
December 16, 2019 Regular Meeting Agenda Packet
o In the unexpected event the Organization shall request that unusual out of pocket
expenses be incurred, said expenses will be reimbursed at the actual cost with no
mark-up for overhead.
o If the Organization desires any supplemental services not mentioned in this
section, an estimate of the cost and hours to be committed will be provided at
that time, and no work shall be done without approval. Supplemental services will
be billed out at $250 per hour.
Terms and Conditions:
• SGR guarantees that the Organization will be satisfied with the results of the recruitment
process, or SGR will repeat the entire process at no additional professional fee until the
Organization selects a candidate. Additionally, if the Organization selects a candidate
(that SGR has fully vetted through our recruitment process) who resigns or is released
within 18 months of their hire date, SGR will repeat the process at no additional
professional fee to the Organization. If the Organization circumvents SGR's recruitment
process or selects a candidate that did not participate in the full recruitment process, this
service guarantee is null and void.
• The Organization reserves the right to terminate this agreement at any time upon giving
SGR seven days advanced written notice. In such event SGR will be compensated for all
work satisfactorily completed up to and through the date of termination. In addition, SGR
shall provide to the Organization all deliverables completed through the date of
termination.
• The Organization acknowledges that the nature of executive recruitment is such that SGR
engages in discussions with prospects throughout the process who may or may not
ultimately become a candidate, and that SGR is utilizing its proprietary network of
relationships to identify and engage prospective candidates, and that premature release
of such proprietary information, including names of prospective candidates who SGR may
be having conversations with as part of the recruitment process, may be damaging to the
prospects and to SGR. Accordingly, the Organization acknowledges and, to the extent
provided by law, agrees that all information related to this search is proprietary, and
remains the property of and under the exclusive control of SGR, regardless of whether
such information has been shared with the Organization or not, including all decisions
regarding release of information, until such time that a finalist is named. At the time
finalists are determined, all information related to the finalists shall become the property
of the Organization and all decisions regarding public disclosure shall be determined by
the Organization, except that psychometric assessments, questionnaires, and any
information produced by SGR is proprietary and shall not become the property of the
Organization or subject to disclosure except as otherwise required by applicable law.
Page 5 of 6
18 of 140
Approved and Agreed to, this the
Melissa Valentine, Managing Director of
Recruitment and Human Resources
Strategic Government Resources
December 16, 2019 Regular Meeting Agenda Packet
day of . 2019 by and between
Trophy Club Municipal Utility District No. 1
Printed Name:
Title:
Page 6 of 6
19 of 140
Jon Niermann, Chairman
Emily Lindley, Commissioner
Bobby Janecka, Commissioner
Toby Baker, Executive Director
December 16, 2019 Regular Meeting Agenda Packet
PWS_0610018_CO_20191205_Superior
TEXAS COMMISSION ON ENVIRONMENTAL QUALITY
Protecting Texas by Reducing and Preventing Pollution
December 5, 2019
Gregory Wilson, President
Trophy Club MUD 1
100 Municipal DR
Trophy Club, TX 76262-5420
Subject: Superior Public Water System (PWS) Recognition
Trophy Club MUD 1, PWSID - 0610018
Denton County, Texas
Dear Mr. Wilson:
As a result of the Texas Commission on Environmental Quality's (TCEQ) recent Comprehensive
Compliance Investigation (CCI) and review of records concerning the Trophy Club MUD 1, it has
been determined that the public water system meets the TCEQ's Superior Public Water System
recognition requirements in accordance with 30 Texas Administrative Code §290.47. This
recognition authorizes display of Superior Public Water System signs on highways entering the area
served by this public water system. Please note that before installing the signs along the highway
rights-of-way, the District Engineer of the Texas Department of Transportation (TxDOT) should be
contacted and his approval obtained concerning the proposed sign installation sites.
We are enclosing two copies of an Agreement Form to be signed by the person indicated and
returned to this office. My signature will be affixed to this document and one copy returned to
you for your files.
In conclusion, we wish to thank you for your diligence and concern regarding the Trophy Club MUD
1's public water system. If you have any questions or require further assistance, please do not
hesitate to contact Leticia De Leon in the Drinking Water Special Functions Section at (512) 239-
4978 or Leticia.DeLeon@tcea.texas.gov.
Sincerely,
Michele Risko, Manager
Drinking Water Special Functions Section
Water Supply Division
MR/TN/av
cc: TCEQ Region 4, Dallas/Fort Worth - Brent Candler, Water Program
P.O. Box 13087 • Austin, Texas 78711-3087 • 512-239-1000 • tceq.texas.gov
How is our customer service? tceq.texas.gov/customersurvey
20 of 140
printed on recycled paper using vegetable based ink
December 16, 2019 Regular Meeting Agenda Packet
AN AGREEMENT
In view of having received a SUPERIOR PUBLIC WATER SYSTEM rating in
accordance with TEXAS COMMISSION ON ENVIRONMENTAL QUALITY
standards and in order to create public confidence and to properly advertise the good
quality of the drinking water supply of Trophy Club MUD 1, the TEXAS
COMMISSION ON ENVIRONMENTAL QUALITY has granted this permission to
install standard highway markers on the recognized highways leading into the area served
by Trophy Club 1.
On their part, the OFFICIALS of Trophy Club 1 agree to prepare, install, maintain and
be entirely responsible for these signs. The OFFICIALS further agree to effect the
immediate removal of such signs whenever they are advised by the TEXAS
COMMISSION ON ENVIRONMENTAL QUALITY that the rating of this supply has
fallen below the required standards. Should the OFFICIALS fail to remove the signs
upon notification that the rating of this supply has fallen below the required standards, it
is understood and agreed that the TEXAS COMMISSION ON ENVIRONMENTAL
QUALITY is empowered to effect their removal as though the signs were property of the
COMMISSION.
In AGREEMENT OF THE ABOVE CONSIDERATION, the following parties attach
their names to this understanding.
Trophy Club MUD 1
Public Water System ID No. 0610018
Gregory Wilson, President
Trophy Club MUD 1
Michele Risko, Manager
Drinking Water Special Functions
Water Supply Division
21 of 140
December 16, 2019 Regular Meeting Agenda Packet
ORDER NO. 2019-1216
ORDER AUTHORIZING GENERAL MANAGER TO CONTRACT FOR PURCHASE AND
INSTALLATION OF PREFABRICATED BUILDING AND SOUND MITIGATION
IMPROVEMENTS
(Wastewater Treatment Plant Sound Mitigation Project)
WHEREAS, Trophy Club Municipal Utility District No. 1 (the "District") is a duly created and
existing municipal utility district created and operating under Chapters 49 and 54 of the Texas Water Code,
as amended;
WHEREAS, the District owns and operates a wastewater treatment plant facility for the treatment
and disposal of domestic wastewater;
WHEREAS, to mitigate the sound impact of wastewater treatment plant on the use and enjoyment
of property by nearby residents, the Board of Directors desires to purchase and install a prefabricated
building and sound mitigation improvements for the wastewater treatment plant blowers and related
equipment;
WHEREAS, Section 49.056(a) of the Texas Water Code authorizes the board of directors of a
municipal utility district to delegate to its general manager full authority to manage and operate the affairs
of the district subject only to the orders of the board; and
WHEREAS, pursuant to the foregoing authority, the Board of Directors desires to authorize the
District's General Manager to contract for purchase and installation of a prefabricated building and sound
mitigation improvements at the wastewater treatment plant facility. 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 found 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 hereby authorizes the General Manager to enter into solicit
bids from qualified contracts and to contract for purchase and installation of a prefabricated building and
sound mitigation improvements at the wastewater treatment plant (the "Project") subject to the following
parameters and limitations:
i. The General Manager shall solicit at least three bids from qualified contractors for the
Project; and
ii. The total cost of the Project shall not exceed $70,000 without prior authorization of the
Board of Directors; and
iii. The form of the contract shall be subject to review and approval by the District's legal
counsel prior to execution by the General Manager.
22 of 140
December 16, 2019 Regular Meeting Agenda Packet
ADOPTED, PASSED AND APPROVED by the Board of Directors of Trophy Club Municipal
Utility District No. 1, Trophy Club, Texas this 16th day of December 2019.
Greg Wilson, President
Board of Directors
Steve Flynn, Secretary/Treasurer
Board of Directors
Laurie Slaght, District Secretary
23 of 140
(SEAL)
p HALFF
November 20, 2019
P37835.001
Mr. John Carman
Trophy Club Municipal Utility District No.1
100 Municipal Drive
Trophy Club, Texas 76262
December 16, 2019 Regular Meeting Agenda Packet
RE: Proposal for Legal Description of Boundaries of Trophy Club Municipal Utility District No. 1
Dear Mr. Carman,
We are pleased to present the following scope of services and fee schedule to provide professional engineering
services for the Trophy Club Municipal Utility District No.1 (District). Per our discussion, the District would
like Halff Associates to prepare an updated boundary description of the Trophy Club Municipal Utility District
No. 1.
This contract proposal includes the following items: Attachment 'A' — Scope of Services and Attachment 'B'
— Fee Summary. Refer to Halff's Agreement for Professional Engineering Services on a Task Order Basis,
executed by the District on October 18, 2018, for the terms and conditions of this proposal. The fees quoted
in this proposal will be honored for up to 60 days from the date of this proposal. The signed Agreement by
both parties will serve as Notice to Proceed (NTP). Services will begin upon NTP. See Attachment B' for
signature page.
We trust this proposal meets your requirements for this project. We appreciate the opportunity to be of
service to you, and trust that our association on this project will be mutually beneficial. Please feel free to
contact us if you have any questions or comments concerning this proposal.
Sincerely,
HALFF ASSOCIATES, INC.
Leah M. Hodge, PE, CFM
Project Manager
C: David M. Smith, PE - Halff
HALFF ASSOCIATES, INC
4000 FOSSIL CREEK B LVD TEL (817) 8 47-1422 WW W HALF F COM
FORT WORTH TX 76137 FAX (817) 232- 9784
24 of 140
Now HALFF
NOM
December 16, 2019 Regulmplly g AI Packet
TCMUD No. 1
November 20, 2019
Page 2
ATTACHMENT 'A'
Scope of Services
Overview
Halff will compile descriptions of all tracts included in the District boundary. Tracts with common boundaries
will be merged. The District will review the outer boundary and Halff will make any necessary edits. Once
approved, Halff will provide the metes and bounds of the final boundary in Word format. Both CADD and
shapefiles (GIS) of the updated boundary will be provided to the Distrct.
Store Existing Tracts
Halff will store the coordinate geometry of each tract contained within the District. It is assumed that there
are fifteen (15) tracts. The tracts include:
1. Northerly Parcel
2. South Parcel
3. Westerly Section
4. Easterly Section
5. Lot 1 Block 2
6. Lot 2 Block 2
7. Lot 3 Block 2
8. Lot 4 Block 2
9. Churchill Downs Annexation (12.2346 acres)
10. Northwest Independent School District Byron Nelson High School Annexation (92.655 acres)
11. Highlands Annexation (2.503 acres)
12. Wonderland Plaza Addition, Lots 1 & 2, Block A (4.5161 acres)
13. Trophy Club Village Centre, Lots 1 & 2, Block 1 (2.532 acres)
14. Trophy Club Drive Church Addition, Lots 1 & 2, Block 1 (7.0441 acres)
15. Meadowbrook Lane Lot Annexation (1.055 acres)
Merge Existing Tracts
Halff will rectify the individual tracts as necessary to ensure the common boundaries are identical. Tracts with
differing coordinate systems will be converted to a common coordinate system. Halff will then merge all
tracts with shared boundaries.
Review
Halff will meet with District staff to review the updated/merged boundary description and determine if any
adjustments need to be made. The boundary will be visualized and compared with a high-resolution aerial
image to confirm all properties served by the District are contained within the boundary. The District will
also verify the boundary follows the intended roads, parcel boundaries, adjacent jurisdictions, etc. Halff will
make any necessary revisions based on the District's review.
Boundary Description
Halff will provide the metes and bounds of the final boundary in Word format. Since the boundary does not
include any field verification, "more or less" will be added to all calls. Halff will also provide the boundary
in both CADD and GIS (shapefile) formats
25 of 140
HALFF
December 16, 2019 RegullaF r. o m man Mee�tin�A enda Packet
TCMUD No. 1
November 20, 2019
Page 3
No survey field investigation is included in the scope of this project.
26 of 140
;M; HALFF
PROPOSED FEE SCHEDULE
December 16, 2019 Regual,MpiWVW Packet
TCMUD No. 1
November 20, 2019
Page 4
ATTACHMENT `B'
Fee Summary
1. Store, Merge, Rectify, and Redefine District Boundary $30,000 (Hourly)
TOTAL FEE $30,000
The hourly fee (cost plus max) will not be exceeded without prior approval from the District. The hourly fee
(cost plus max) will be invoiced monthly based on the hourly effort completed. Halff will coordinate with
the District to establish the billing schedule.
Direct costs, including printing, plotting, and reproduction, postage, messenger service, specialized equipment
(such as GPS), long distance telephone calls and vehicle mileage will be considered reimbursable and will be
billed at 1.10 times the direct cost incurred.
Additional services may be requested by the District on a task order basis. Halff will develop a separate scope
and fee for each additional service and obtain approval from the District prior to initiating work on the
additional services. The summary of hourly billing rates included in the October 18, 2018 Agreement for
Professional Engineering Services has been updated. The rate table below reflects the current rates which will
apply to this task order.
Labor Categoryai -vel
Billing Rate Range
Low H ig,4
Architect
Engineer
Scientist
75.00
II 92.00
III 130.00
IV 199.00
✓ 226.00
85.00
I I 107.00
III 146.00
IV 188.00
✓ 232.00
72.00
I I 98.00
10 133.00
IV 170.00
✓ 213.00
27 of 140
90.00
126.00
166.00
219.00
325.00
110.00
145.00
211.00
239.00
350.00
97.00
128.00
168.00
215.00
350.00
,•„ HALFF
Landscape/
Planner
Surveyor
Field Tech
Office Tech
Administrative
Specialist
Intern
Notes:
1. Labor Category (Specialty):
December 16, 2019 Regulic1FFic0 Packet
TCMUD No. 1
November 20, 2019
Page 5
72.00 88.00
II 88.00 121.00
II1 121.00 153.00
IV 155.00 201.00
✓ 209.00 340.00
92.00 95.00
11 96.00 118.00
III 133.00 142.00
IV 140.00 186.00
51.00 69.00
II 65.00 85.00
til 86.00 107.00
IV 116.00 138.00
✓ 153.00 216.00
43.00 69.00
I I 69.00 89.00
III 86.00 120.00
IV 112.00 144.00
✓ 140.00 182.00
29.00 69.00
I I 67.00 85.00
III 82.00 112.00
IV 111.00 143.00
✓ 144.00 350.00
66.00 97.00
I 97.00 133.00
III 124.00 171.00
IV 174.00 208.00
✓ 223.00 333.00
44.00 69.00
Architect
Engineer (Civil, Structural, Mechanical, Electrical, Oil & Gas)
Scientist (Environmental and Geological)
Landscape/Planner
Surveyor
Field Tech (Survey, SUE, Environmental & Construction)
28 of 140
By:
HALFF
Submitted:
December 16, 2019 Regutprll Packet
TCMUD No. 1
November 20, 2019
Page 7
Approved:
HALFF ASSOCIATES, INC. TROPHY CLUB MUNICIPAL UTILITY
DISTRICT NO.1
Signature
David M. Smith
Printed Name
Public Works Team Leader
Title
November 19. 2019
Date
By:
30 of 140
Signature
Printed Name
Title
Date
December 16, 2019 Regular Meeting Agenda Packet
TROPHY CLUB MUD #1 - FIRE DEPARTMENT
BALANCE SHEET
NOVEMBER 2019
ASSETS
CASH IN BANK
INVESTMENTS
PREPAID EXPENSES
ADVALOREM PROPERTY TAXES RECEIVABLE
EMERGENCY SERVICES ASSESSMENTS RECEIVABLE
UTILITY AND OTHER ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
122
FIRE DEPT.
329,248
16,409
1,187,888
TOTAL ASSETS 1,533,547
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
RESERVE FOR ENCUMBRANCES
NET REVENUES / EXPENDITURES
TOTAL FUND BALANCE
TOTAL LIABILITIES AND FUND BALANCE
31 of 140
1,187,895
1,187,895
603,769
(258,117)
345,652
1,533,547
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 1
16:37 12/09/19 Budget Summary with Amendment
Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
122-40010-000-000 Property Taxes/MUD Fire
122-40011-000-000 Property Taxes/Fire-Delinquent
122-40020-000-000 Property Taxes/Fire P&i
Subtotal:
Program number:
Department number:
Revenues
Fire Revenues
Subtotal
1,214,230.00- 1,214,230.00-
1,214,230.00- 1,214,230.00-
1,214,230.00- 1,214,230.00-
1,214,230.00- 1,214,230.00-
1,214,230.00- 1,214,230.00-
32 of 140
60,041.08- 75,563.94-
914.94- 452.79
1,079.94- 1,148.41-
62,035.96- 76,259.56-
62,035.96- 76,259.56-
62,035.96- 76,259.56-
62,035.96- 76,259.56-
6.223
6.280
6.280
6.280
6.280
1,138,666.06-
452.79-
1,148.41
1,137,970.44-
1,137,970.44-
1,137,970.44-
1,137,970.44-
glbase_tbam skrolczyk
16:37 12/09/19
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
Trophy Club MUD No.1
Budget Summary with Amendment
Page 2
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
Subtotal: 957,661.00 957,661.00
122-69005-045-000
122-69009-045-000
122-69195-045-000
122-69305-045-000
Subtotal:
Capital Outlays
Short Term Debt -Interest
GASB34/Reserve for Replacement
Capital Leases
48,000.00 48,000.00
81,420.00 81,420.00
127,149.00 127,149.00
256,569.00 256,569.00
Program number: 1,214,230.00 1,214,230.00
Department number: Fire
Expenditures
Subtotal
Fund number: 122 Trophy Club MUD Fire Dept.
1,214,230.00 1,214,230.00
1,214,230.00 1,214,230.00
33 of 140
1,640.88
59,888.08
61,528.96
2,750.00
3,281.76
119,776.16
123,057.92
2,750.00
11,958.24
81,420.00
115,190.36
2,750.00 211,318.60
64,278.96 334,376.52
64,278.96
64,278.96
2,243.00
334,376.52
334,376.52
258,116.96
15.627
16.667
12.850
5.729
100.000
90.595
82.363
27.538
27.538
27.538
218,004.00
17,718.24
598,880.84
834,603.08
45,250.00
11,958.24-
11,958.64
45,250.40
879,853.48
879,853.48
879,853.48
258,116.96-
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 1
16:38 12/09/19 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 122-40010-000-000 Property Taxes/MUD Fire
363 11/01/2019 Property Taxes
364 11/04/2019 Property Taxes
365 11/05/2019 Property Taxes
366 11/06/2019 Property Taxes
367 11/07/2019 Property Taxes
368 11/08/2019 Property Taxes
369 11/12/2019 Property Taxes
370 11/13/2019 Property Taxes
371 11/14/2019 Property Taxes
372 11/15/2019 Property Taxes
373 11/18/2019 Property Taxes
374 11/19/2019 Property Taxes
375 11/20/2019 Property Taxes
376 11/21/2019 Property Taxes
377 11/22/2019 Property Taxes
378 11/25/2019 Property Taxes
379 11/26/2019 Property Taxes
380 11/27/2019 Property Taxes
(15,522.86)
(1,541.19) (17,064.05) GL
(3,618.25) (20,682.30) GL
(6,659.43) (27,341.73) GL
(2,600.62) (29,942.35) GL
(3,105.87) (33,048.22) GL
(5,666.45) (38,714.67) GL
(1,442.44) (40,157.11) GL
(6,701.27) (46,858.38) GL
(3,596.12) (50,454.50) GL
(1,484.48) (51,938.98) GL
(838.39) (52,777.37) GL
(3,442.24) (56,219.61) GL
(8,699.42) (64,919.03) GL
(1,935.40) (66,854.43) GL
(177.09) (67,031.52) GL
(3,646.78) (70,678.30) GL
(3,604.20) (74,282.50) GL
(1,281.44) (75,563.94) GL
Account: 122-40010-000-000
Property Taxes/MUD Fire Totals: (60,041.08) (75,563.94) **
(1,214,230.00) Budgeted
(1,138,666.06) Remaining 6 % Used
Account: 122-40011-000-000 Property Taxes/Fire-Delinquent
363 11/01/2019 Property Taxes
366 11/06/2019 Property Taxes
374 11/19/2019 Property Taxes
377 11/22/2019 Property Taxes
380 11/27/2019 Property Taxes
1,367.73 (212.72) 1,155.01 GL
(282.07) 872.94 GL
(3.44) 869.50 GL
16.80 886.30 GL
(433.51) 452.79 GL
Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals:
(914.94) 452.79 **
.00 Budgeted
(452.79) Remaining 0 % Used
Account: 122-40020-000-000 Property Taxes/Fire P6I
363 11/01/2019 Property Taxes
365 11/05/2019 Property Taxes
366 11/06/2019 Property Taxes
369 11/12/2019 Property Taxes
370 11/13/2019 Property Taxes
372 11/15/2019 Property Taxes
374 11/19/2019 Property Taxes
(68.47) (46.79) (115.26) GL
(1.13) (116.39) GL
(17.04) (133.43) GL
(1.12) (134.55) GL
(.08) (134.63) GL
(.97) (135.60) GL
(.65) (136.25) GL
34 of 140
glpdatb2 skrolczyk
16:38 12/09/19
Fund: 122 Trophy Club MUD Fire Dept.
JE JE JE
Number Date Description
375 11/20/2019 Property Taxes
380 11/27/2019 Property Taxes
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: Fire Revenues Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Page 2
(68.47)
(917.10)
(95.06)
(1,053.35)
(1,148.41)
GL
GL
Account: 122-40020-000-000
Property Taxes/Fire P6I Totals: (1,079.94) (1,148.41) **
.00 Budgeted
1,148.41 Remaining 0 % Used
Department Totals:
(62,035.96) Monthly Total
(76,259.56) **
(1,214,230.00) Budgeted (1,137,970.44) Remaining 6 % Used
35 of 140
glpdatb2 skrolczyk
16:38 12/09/19
Fund: 122 Trophy Club MUD Fire Dept.
JE JE JE
Number Date Description
Department: 45 Fire
JE Detail
Description/Comment
Trophy Club MUD No.1 Page 3
Detailed Accounting Trial Balance
Program:
December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
Beginning Transaction Transaction Vendor_Name Check Source
Balance Detail Detail Number
(SUBTOTAL)
Account: 122-60030-045-000 Rent And/Or Usage
Account: 122-60030-045-000
Rent And/Or Usage Totals:
218,004.00 Budgeted
Account: 122-60055-045-000 Insurance
67 11/01/2019 Insurance/Wrk Comp Expense Nov
Account: 122-60055-045-000
Account: 122-60337-045-000
225 11/06/2019 November A?P
Account: 122-60337-045-000
Account: 122-69005-045-000
254 11/14/2019 November A/P
254 11/14/2019 November A/P
Insurance
21,000.00 Budgeted
218,004.00 Remaining 0 % Used
Totals:
17,718.24 Remaining
Transfer to Town/Fire Budget
Fire admin november
Transfer to Town/Fire Budget Totals:
718,657.00 Budgeted 598,880.84 Remaining
Capital Outlays
exhaust silencer -capital
exhaust silencer -capital
.00
.00
.00 .00 **
1,640.88 1,640.88 3,281.76 GL
1,640.88 3,281.76 **
16 % Used
59,888.08 59,888.08 119,776.16 TOWN OF TROPHY CLUB 5901 AP
17 % Used
59,888.08 119,776.16 **
1,700.00 1,700.00 ACE Heating s Air Conditioning 5904 AP
1,050.00 2,750.00 Rossman Enterprises Inc 5915 AP
Account: 122-69005-045-000
Capital Outlays Totals:
2,750.00 2,750.00 **
Account: 122-69009-045-000
48,000.00 Budgeted
Short Term Debt -Interest
45,250.00 Remaining 6 % Used
11,958.24 .00 11,958.24
Account: 122-69009-045-000
Short Term Debt -Interest Totals:
.00 11,958.24 **
.00 Budgeted (11,958.24) Remaining 0 % Used
Account: 122-69195-045-000 GASB34/Reserve for Replacement
Account: 122-69195-045-000
81,420.00 .00 81,420.00
GASB34/Reserve for Replacement Totals: .00 81,420.00 **
81,420.00 Budgeted .00 Remaining 100 % Used
Account: 122-69305-045-000
Capital Leases
36 of 140
glpdatb2 skrolczyk
16:38 12/09/19
Fund: 122 Trophy Club MUD Fire Dept.
JE JE JE
Number Date Description
Department: 45 Fire
JE Detail
Description/Comment
Trophy Club MUD No.1 Page 4
Detailed Accounting Trial Balance
Program:
December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
Beginning Transaction Transaction Vendor_Name Check Source
Balance Detail Detail Number
(SUBTOTAL)
115,190.36
.00 115,190.36
Account: 122-69305-045-000
Capital Leases Totals: .00 115,190.36 **
127,149.00 Budgeted
11,958.64 Remaining 91 % Used
Department 45 Totals: 334,376.52 **
64,278.96 Monthly Total 1,214,230.00 Budgeted
879,853.48 Remaining 28 % Used
Fund 122 Totals: 258,116.96
2,243.00 Monthly Total .00 Budgeted (258,116.96) Remaining 0 % Used
37 of 140
TROPHY CLUB MUD #1 - O&M (GENERAL FUND)
BALANCE SHEET
NOVEMBER 2019
December 16, 2019 Regular Meeting Agenda Packet
135 137
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
GENERAL FUND GASB TOTAL
ASSETS
CASH ON HAND 600 600
CASH IN BANK -CHECKING 2,983,393 2,983,393
CASH IN BANK -SAVINGS -CASH RESERVE 1,398,315 1,398,315
INVESTMENTS-TEXPOOL 4,202,332 919,266 5,121,598
PREPAID EXPENSES 93,355 93,355
ADVALOREM PROPERTY TAXES RECEIVABLE 131,786 131,786
UTILITY AND OTHER ACCOUNTS RECEIVABLE 845,820 845,820
TOTAL ASSETS 9,655,601 919,266 10,574,867
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 131,786 131,786
ACCOUNTS AND OTHER PAYABLES 843,081 843,081
CUSTOMER DEPOSITS 320,304 320,304
TOTAL LIABILITIES 1,295,171 1,295,171
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 (40,954) (40,954)
TOTAL FUND BALANCE 8,360,430 919,266 9,279,696
TOTAL LIABILITIES AND FUND BALANCE 9,655,601 919,266 10,574,867
38 of 140
glbase_tbam skrolczyk
16:37 12/09/19
Fund: 135 MUD 1 General Fund
Account
135-40000-000-000
135-40002-000-000
135-40015-000-000
135-40025-000-000
Description
Property Taxes
Property Taxes/Delinquent
Property Taxes/P & i
PID Surcharges
Department:
Adopted
Budget
134,871.00-
300.00-
300.00-
164,253.00 -
Trophy Club MUD No.1
Budget Summary with Amendment
Revenues
Period Ending: 11/2019
Amended Total
Budget Encumb.
134,871.00-
300.00-
300.00-
164,253.00 -
Current
Month
6,665.28-
104.26-
120.35 -
Program:
YTD
Total
8,388.52-
51.40
128.17 -
Page 3
December 16, 2019 Regular Meeting Agenda Packet
% of
Budget
6.220
-17.133
42.723
Remaining
Budget
126,482.48-
351.40-
171.83-
164,253.00 -
Subtotal:
299,724.00-
299,724.00-
6,889.89-
8,465.29-
2.824
291,258.71-
135-47000-000-000
135-47005-000-000
135-47025-000-000
135-47030-000-000
135-47035-000-000
135-47045-000-000
135-47070-000-000
Water
Sewer
Penalties
Service Charges
Plumbing Inspections
Sewer Inspections
TCCC Effluent Charges
6,486,623.00-
3,503,885.00-
112,608.00-
15,150.00-
750.00-
2,500.00-
50,000.00-
6,486,623.00-
3,503,885.00-
112,608.00-
15,150.00-
750.00-
2,500.00-
50,000.00-
330,533.22-
255,418.37-
10,521.29-
2,150.00-
12.80-
866,912.50-
477,378.73-
20,502.72-
3,225.00-
1,800.00-
400.00-
15,048.80-
13.365
13.624
18.207
21.287
240.000
16.000
30.098
5,619,710.50-
3,026,506.27-
92,105.28-
11,925.00-
1,050.00
,619,710.50-3,026,506.27-92,105.28-
11,925.00-
1,050.00
2,100.00-
34,951.20 -
Subtotal:
10,171,516.00-
10,171,516.00-
598,635.68- 1,385,267.75-
13.619 8,786,248.25-
135-49011-000-000
135-49016-000-000
135-49018-000-000
135-49026-000-000
135-49075-000-000
Interest Income
Cell Tower Revenue
Buildir}p Rent Income
Proceeds from Sale of Assets
Oversize Meter Reimbursement
120,000.00-
14,146.00-
7,000.00-
13,000.00-
12,691.00-
120,000.00-
14,146.00-
7,000.00-
13,000.00-
12,691.00-
9,712.65-
1,178.81-
583.33-
21,478.43-
1,178.81-
1,166.66-
5,355.28-
17.899
8.333
16.667
42.197
98,521.57-
12,967.19-
5,833.34-
13,000.00-
7,335.72-
135-49900-000-000
Miscellaneous Income
7,000.00-
7,000.00-
228.85-
7,601.14-
108.588
601.14
Subtotal:
173,837.00-
173,837.00-
11,703.64-
36,780.32-
21.158
137,056.68 -
Program number:
10,645,077.00-
10,645,077.00-
617,229.21-
1,430,513.36-
13.438
9,214,563.64 -
Department number:
Revenues
10,645,077.00-
10,645,077.00-
617,229.21-
1,430,513.36-
13.438
9,214,563.64 -
Revenues
Subtotal
10,645,077.00-
10,645,077.00-
617,229.21-
1,430,513.36-
13.438
9,214,563.64-
39 of 140
glbase_tbam skrolczyk
16:37 12/09/19
Fund: 135 MUD 1 General Fund
Account
135-50005-010-000
135-50010-010-000
135-50016-010-000
135-50017-010-000
135-50020-010-000
135-50026-010-000
135-50027-010-000
135-50028-010-000
135-50029-010-000
135-50030-010-000
135-50035-010-000
135-50040-010-000
135-50045-010-000
135-50060-010-000
135-50070-010-000
Description
Salaries & Wages
Overtime
Longevity
Certification
Retirement
Medical Insurance
Dental Insurance
Vision Insurance
Life Insurance & Other
Social Security Taxes
Medicare Taxes
Unemployment Taxes
Workman's Compensation
Pre-emp Physicals/Testing
Employee Relations
Department:
Adopted
Budget
350,267.00
17,000.00
3,920.00
5,400.00
34,863.00
84,326.00
4,725.00
767.00
3,132.00
23,348.00
5,461.00
1,080.00
11,850.00
400.00
300.00
10 Water
Trophy Club MUD No.1 Page 4
Budget Summary with Amendment
Period Ending: 11/2019
Total
Encumb.
Amended
Budget
350,267.00
17,000.00
3,920.00
5,400.00
34,863.00
84,326.00
4,725.00
767.00
3,132.00
23,348.00
5,461.00
1,080.00
11,850.00
400.00
300.00
Current
Month
Program:
YTD
Total
% of
Budget
December 16, 2019 Regular Meeting Agenda Packet
41,130.51 51,358.19 14.663
3,378.93 4,200.82 24.711
5,082.50 5,082.50 129.656
450.00 800.00 14.815
4,628.88 6,764.00 19.402
5,229.85 9,050.89 10.733
310.26 554.23 11.730
52.07 90.97 11.860
269.10 458.77 14.648
3,079.60 3,772.88 16.159
720.23 882.37 16.158
9.34 10.14 .939
771.49 1,542.98 13.021
Remaining
Budget
298,908.81
12,799.18
1,162.50-
4,600.00
28,099.00
75,275.11
4,170.77
676.03
2,673.23
19,575.12
4,578.63
1,069.86
10,307.02
400.00
300.00
Subtotal:
546,839.00
546,839.00
65,112.76 84,568.74 15.465
462,270.26
135-55005-010-000
135-55080-010-000
135-55085-010-000
135-55090-010-000
135-55105-010-000
135-55120-010-000
135-55135-010-000
Engineering
Maintenance & Repairs
Generator Maint. and Repair
Vehicle Maintenance
Maintenance-Backhoe/SkidLoader
Cleaning Services
Lab Analysis
20,000.00
100,000.00
3,000.00
5,000.00
3,500.00
1,000.00
7,500.00
20,000.00
100,000.00
3,000.00
5,000.00
3,500.00
1,000.00
7,500.00
10,190.54 13,117.37 13.117
207.88 4.158
87.50 8.750
740.00 740.00 9.867
20,000.00
86,882.63
3,000.00
4,792.12
3,500.00
912.50
6,760.00
Subtotal:
140,000.00
140,000.00
10,930.54 14,152.75 10.109
125,847.25
135-60010-010-000
135-60020-010-000
135-60066-010-000
135-60070-010-000
135-60080-010-000
135-60090-010-000
135-60100-010-000
135-60105-010-000
135-60135-010-000
135-60150-010-000
135-60245-010-000
135-60280-010-000
135-60285-010-000
135-60332-010-000
135-60333-010-000
135-60334-010-000
Communications/Mobiles
Electricity
Publications/Books/Subscripts
Dues & Memberships
Schools & Training
Safety Program
Travel & per diem
Rent/Lease Equipment
TCEQ Fees & Permits
Wholesale Water
Miscellaneous Expenses
Property Maintenance
Lawn Equipment & Maintenance
Interfund Transfer Out -Rev I&S
Interfund Transfer Out -Reserve
Interfund Transfer Out
5,000.00
125,677.00
1,000.00
500.00
7,426.00
400.00
2,845.00
1,500.00
63,000.00
2,714,710.00
200.00
3,000.00
14,750.00
527,381.00
55,193.00
180,000.00
5,000.00
125,677.00
1,000.00
500.00
7,426.00
400.00
2,845.00
1,500.00
63,000.00
2,714,710.00
200.00
3,000.00
14,750.00
527,381.00
55,193.00
180,000.00
40 of 140
875.01 1,239.17 24.783
11,423.51 26,144.51 20.803
14,207.15
220,912.63
47,943.74
4,600.00
295.00 3.973
14,207.15 22.551
220,912.63 8.138
462.00 15.400
95,887.48 18.182
9,200.00 16.669
3,760.83
99,532.49
1,000.00
500.00
7,131.00
400.00
2,845.00
1,500.00
48,792.85
2,493,797.37
200.00
2,538.00
14,750.00
431,493.52
45,993.00
180,000.00
glbase_tbam skrolczyk
16:37 12/09/19
Fund: 135 MUD 1 General Fund
Account
135-60360-010-000
Subtotal:
135-65005-010-000
135-65010-010-000
135-65030-010-000
135-65035-010-000
135-65040-010-000
135-65050-010-000
135-65053-010-000
Subtotal:
135-69005-010-000
135-69008-010-000
135-69009-010-000
135-69195-010-000
135-69281-010-000
Subtotal:
Program number:
Description
Furniture/Equipment < $5000
Fuel & Lube
Uniforms
Chemicals
Small Tools
Safety Equipment
Meter Expense
Meter Change Out Program
Capital Outlays
Short Term Debt -Principal
Short Term Debt -Interest
Gasb34/Reserve for Replacement
Water Tank Inspection Contract
Department:
Adopted
Budget
2,500.00
3,705,082.00
15,000.00
5,190.00
20,000.00
1,200.00
1,000.00
70,000.00
87,000.00
199,390.00
684,875.00
30,512.00
3,231.00
75,000.00
120,000.00
913,618.00
5,504,929.00
10 Water
Trophy Club MUD No.1 Page 5
Budget Summary with Amendment
Period Ending: 11/2019
Total
Encumb.
Amended
Budget
2,500.00
3,705,082.00
15,000.00
5,190.00
20,000.00
1,200.00
1,000.00
70,000.00
87,000.00
199,390.00
684,875.00
30,512.00
3,231.00
75,000.00
120,000.00
913,618.00
5,504,929.00
41 of 140
Current
Month
100.57
300,062.61
970.35
909.36
1,642.32
3,522.03
11,152.78
57,932.73
69,085.51
448,713.45
Program:
YTD
Total
100.57
368,448.51
1,743.83
1,729.35
3,331.56
8,875.28
15,680.02
29,804.38
75,000.00
57,932.73
162,737.11
645,587.13
December 16, 2019 Regular Meeting Agenda Packet
% of
Budget
4.023
9.944
11.626
33.321
16.658
12.679
7.864
4.352
100.000
48.277
17.812
11.727
Remaining
Budget
2,399.43
3,336,633.49
13,256.17
3,460.65
16,668.44
1,200.00
1,000.00
61,124.72
87,000.00
183,709.98
655,070.62
30,512.00
3,231.00
62,067.27
750,880.89
4,859,341.87
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 6
16:37 12/09/19 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for DebAmber 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-55135-010-001 Lab Analysis for PID 2,000.00 2,000.00
Subtotal: 2,000.00 2,000.00
Program number: 1 Lab Analysis for PID 2,000.00 2,000.00
Department number: Water 5,506,929.00 5,506,929.00
42 of 140
80.00
80.00
80.00
80.00
4.000
80.00 4.000
80.00
448,793.45 645,667.13
4.000
11.725
1,920.00
1,920.00
1,920.00
4,861,261.87
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7
16:37 12/09/19 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-50005-020-000 Salaries & Wages 441,799.00 441,799.00 43,724.72 56,681.48 12.830 385,117.52
135-50010-020-000 Overtime 33,000.00 33,000.00 3,538.90 4,187.98 12.691 28,812.02
135-50016-020-000 Longevity 8,035.00 8,035.00 6,872.50 6,872.50 85.532 1,162.50
135-50017-020-000 Certification 9,000.00 9,000.00 625.00 1,250.00 13.889 7,750.00
135-50020-020-000 Retirement 45,531.00 45,531.00 5,065.41 7,920.39 17.396 37,610.61
135-50026-020-000 Medical Insurance 104,858.00 104,858.00 5,987.13 11,974.26 11.420 92,883.74
135-50027-020-000 Dental Insurance 5,817.00 5,817.00 358.15 716.30 12.314 5,100.70
135-50028-020-000 Vision Insurance 948.00 948.00 59.22 118.44 12.494 829.56
135-50029-020-000 Life Insurance & Other 4,500.00 4,500.00 341.99 679.13 15.092 3,820.87
135-50030-020-000 Social Security Taxes 30,494.00 30,494.00 3,251.71 4,055.67 13.300 26,438.33
135-50035-020-000 Medicare Taxes 7,132.00 7,132.00 760.48 948.49 13.299 6,183.51
135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 1,260.00
135-50045-020-000 Workman's Compensation 15,373.00 15,373.00 1,110.20 2,220.40 14.444 13,152.60
135-50060-020-000 Pre-emp Physicals/Testing 400.00 400.00 400.00
135-50070-020-000 Employee Relations 300.00 300.00 300.00
Subtotal: 708,447.00 708,447.00 71,695.41 97,625.04 13.780 610,821.96
135-55005-020-000 Engineering 30,000.00 30,000.00 30,000.00
135-55070-020-000 Independent Labor 15,000.00 15,000.00 3,000.00 3,000.00 20.000 12,000.00
135-55080-020-000 Maintenance & Repairs 88,000.00 88,000.00 2,982.28 6,686.82 7.599 81,313.18
135-55081-020-000 Mainten & Re/Pairs Collections 10,000.00 10,000.00 6,351.91 14,277.16 142.772 4,277.16-
135-55085-020-000 Generator Maint. and Repair 10,000.00 10,000.00 10,000.00
135-55090-020-000 Vehicle Maintenance 4,000.00 4,000.00 115.46 162.48 4.062 3,837.52
135-55091-020-000 Veh Maintenance Collections 8,000.00 8,000.00 1,837.08 1,837.08 22.964 6,162.92
135-55105-020-000 Maintenance-Backhoe/SkidLoader 3,000.00 3,000.00 856.24- -28.541 3,856.24
135-55120-020-000 Cleaning Services 1,500.00 1,500.00 87.50 5.833 1,412.50
135-55125-020-000 Dumpster Services 100,000.00 100,000.00 7,433.18 12,239.42 12.239 87,760.58
135-55135-020-000 Lab Analysis 40,000.00 40,000.00 2,019.60 4,409.20 11.023 35,590.80
Subtotal: 309,500.00 309,500.00 23,739.51 41,843.42 13.520 267,656.58
135-60010-020-000 Communications/Mobiles 5,000.00 5,000.00 801.99 1,174.83 23.497 3,825.17
135-60020-020-000 Electricity 160,067.00 160,067.00 10,925.83 22,687.12 14.174 137,379.88
135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 200.00
135-60070-020-000 Dues & Memberships 300.00 300.00 300.00
135-60080-020-000 Schools & Training 4,990.00 4,990.00 333.53 1,173.53 23.518 3,816.47
135-60090-020-000 Safety Program 1,000.00 1,000.00 1,000.00
135-60100-020-000 Travel & per diem 1,545.00 1,545.00 356.71 356.71 23.088 1,188.29
135-60105-020-000 Rent/Lease Equipment 5,000.00 5,000.00 5,000.00
135-60125-020-000 Advertising 2,500.00 2,500.00 2,500.00
135-60135-020-000 TCEQ Fees & Permits 15,000.00 15,000.00 9,888.02 65.920 5,111.98
135-60245-020-000 Miscellaneous Expenses 450.00 450.00 450.00
135-60280-020-000 Property Maintenance 5,000.00 5,000.00 5,000.00
43 of 140
glbase_tbam skrolczyk
16:37 12/09/19
Fund: 135 MUD 1 General Fund
Account
135-60285-020-000
135-60331-020-000
135-60332-020-000
135-60333-020-000
135-60334-020-000
135-60360-020-000
Subtotal:
135-65005-020-000
135-65010-020-000
135-65030-020-000
135-65031-020-000
135-65035-020-000
135-65040-020-000
135-65045-020-000
Subtotal:
135-69005-020-000
135-69008-020-000
135-69009-020-000
135-69195-020-000
Description
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
Fuel & Lube
Uniforms
Chemicals
Chemicals Collections
Small Tools
Safety E uipment
Lab Supplies
Capital Outlays
Short Term Debt -Principal
Short Term Debt -Interest
Gasb34/Reserve for Replacement
Subtotal:
Program number:
Department number: Wastewater
Department:
Adopted
Budget
14,000.00
114,563.00
673,867.00
125,187.00
180,000.00
2,000.00
1,310,669.00
12,500.00
5,495.00
20,000.00
17,500.00
1,200.00
1,200.00
20,000.00
77,895.00
530,500.00
79,133.00
11,277.00
130,000.00
750,910.00
3,157,421.00
3,157,421.00
Trophy Club MUD No.1
Budget Summary with Amendment
20 Wastewater
Period Ending: 11/2019
Amended Total
Budget Encumb.
14,000.00
114,563.00
673,867.00
125,187.00
180,000.00
2,000.00
1,310,669.00
12,500.00
5,495.00
20,000.00
17,500.00
1,200.00
1,200.00
20,000.00
77,895.00
530,500.00
79,133.00
11,277.00
130,000.00
750,910.00
3,157,421.00
3,157,421.00
44 of 140
Current
Month
10,414.81
61,260.10
5,750.00
190.00
90,032.97
906.43
2,111.52
569.00
4,994.00
995.32
9,576.27
84,803.30
84,803.30
279,847.46
279,847.46
Program:
YTD
Total
% of
Budget
Page 8
December 16, 2019 Regular Meeting Agenda Packet
20,829.62 18.182
122,520.80 18.182
11,500.00 9.186
190.00 9.500
190,320.63 14.521
1,830.04 14.640
3,003.93 54.667
3,394.96 16.975
4,994.00 28.537
3,978.33 19.892
17,201.26 22.083
90,592.30 17.077
130,000.00 100.000
220,592.30 29.377
567,582.65 17.976
567,582.65 17.976
Remaining
Budget
14,000.00
93,733.38
551,346.20
113,687.00
180,000.00
1,810.00
1,120,348.37
10,669.96
2,491.07
16,605.04
12,506.00
1,200.00
1,200.00
16,021.67
60,693.74
439,907.70
79,133.00
11,277.00
530,317.70
2,589,838.35
2,589,838.35
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 9
16:37 12/09/19 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 26 Board of Directors
Period Ending: 11/2019
Account Description Adopted Amended Total Current YTD % of
Budget Budget Encumb. Month Total Budget
Program:
135-50045-026-000
Subtotal:
Workman's Compensation
30.00
30.00
30.00 30.00
135-60066-026-000 Publications/Books/Subscripts 150.00
135-60070-026-000 Dues & Memberships 750.00
135-60075-026-000 Meetings 1,300.00
135-60080-026-000 Schools & Training 4,000.00
135-60100-026-000 Travel & per diem 5,000.00
135-60245-026-000 Miscellaneous Expenses 2,000.00
Subtotal: 13,200.00
Program number: 13,230.00
Department number: Board of Directors 13,230.00
150.00
750.00
1,300.00
4,000.00
5,000.00
2,000.00
13,200.00
13,230.00
13,230.00
45 of 140
1.99
3.98
1.99 3.98
675.00
156.36
831.36
833.35
833.35
675.00
156.36
December 16, 2019 Regular Meeting Agenda Packet
13.267
Remaining
Budget
26.02
13.267 26.02
90.000
12.028
831.36 6.298
835.34
835.34
6.314
6.314
150.00
75.00
1,143.64
4,000.00
5,000.00
2,000.00
12,368.64
12,394.66
12,394.66
glbase_tbam skrolczyk Trophy Club MUD No.1
16:37 12/09/19 Budget Summary with Amendment
Page 10
Fund: 135 MUD 1 General Fund Department: 30 Administration Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-50005-030-000
135-50010-030-000
135-50016-030-000
135-50020-030-000
135-50026-030-000
135-50027-030-000
135-50028-030-000
135-50029-030-000
135-50030-030-000
135-50035-030-000
135-50040-030-000
135-50045-030-000
135-50060-030-000
135-50070-030-000
Salaries & Wages
Overtime
Longevity
Retirement
Medical Insurance
Dental Insurance
Vision Insurance
Life Insurance & Other
Social Security Taxes
Medicare Taxes
Unemployment Taxes
Workman's Compensation
Pre-emp Physicals/Testing
Employee Relations
628,298.00 628,298.00
2,000.00 2,000.00
2,208.00 2,208.00
58,554.00 58,554.00
124,394.00 124,394.00
6,464.00 6,464.00
1,035.00 1,035.00
4,500.00 4,500.00
39,215.00 39,215.00
9,171.00 9,171.00
1,440.00 1,440.00
1,775.00 1,775.00
500.00 500.00
8,000.00 8,000.00
45,241.82
3.11
2,207.50
4,389.34
5,488.81
306.40
48.77
330.00
2,814.13
658.13
104.82
107.37
61,700.20
2,671.60
23,380.71
Subtotal:
887,554.00 887,554.00
135-55030-030-000
135-55070-030-000
135-55080-030-000
135-55085-030-000
135-55120-030-000
135-55160-030-000
135-55205-030-000
Software & Support
Independent Labor
Maintenance & Repairs
Generator Maint. and Repair
Cleaning Services
Professional Outside Services
Utility Billing Contract
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
58,807.67 9.360 569,490.33
3.11 .156 1,996.89
2,207.50 99.977 .50
7,149.98 12.211 51,404.02
10,977.62 8.825 113,416.38
612.80 9.480 5,851.20
97.54 9.424 937.46
622.42 13.832 3,877.58
3,596.13 9.170 35,618.87
841.04 9.171 8,329.96
1,440.00
209.64 11.811 1,565.36
500.00
286.22 3.578 7,713.78
85,411.67 9.623 802,142.33
68,197.45
23,380.71
515.00
869.06
582.15
50.636
17.319
3.433
8.691
6.468
66,483.55
111,619.29
14,485.00
10,000.00
9,130.94
65,600.00
8,417.85
Subtotal:
379,281.00 379,281.00
26,052.31 93,544.37
24.664 285,736.63
135-60005-030-000
135-60010-030-000
135-60020-030-000
135-60025-030-000
135-60035-030-000
135-60040-030-000
135-60050-030-000
135-60055-030-000
135-60066-030-000
135-60070-030-000
135-60075-030-000
135-60079-030-000
135-60080-030-000
135-60100-030-000
135-60110-030-000
135-60115-030-000
135-60125-030-000
Telephone
Communications/Mobiles
Electricity/Gas
Water
Postage
Service Charges & Fees
Bad Debt Expense
Insurance
Publications/Books/Subscripts
Dues & Memberships
Meetings
Public Education
Schools & Training
Travel & per diem
Physicals/Testing
Elections
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
Advertising 2,500.00 2,500.00
46 of 140
1,487.98
238.02
56.40
49.43
7,222.85
6,998.39
35.18
126.45
195.00
36.30
2,967.78
476.04
123.18
1,776.04
14,270.78
12.533
11.901
8.212
5.920
21.300
13,996.78 16.663
200.00
35.18
476.20
972.71
128.08
43.01 43.01
3.333
8.795
7.937
14.200
3.613
20,712.22
3,523.96
6,879.00
1,376.82
28,223.96
52,729.22
1,500.00
70,003.22
1,000.00
5,800.00
364.82
5,523.80
5,877.29
3,416.92
200.00
43.01-
2,500.00
glbase_tbam skrolczyk
16:37 12/09/19
Fund: 135 MUD 1 General Fund
Account Description
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
Trophy Club MUD No.1
Budget Summary with Amendment
Department: 30 Administration Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
Page 11
1,288.00
500.00
17,000.00
2,500.00
1,288.00
500.00
17,000.00
2,500.00
24.00
48.00
3.727
1,240.00
500.00
17,000.00
2,500.00
Subtotal:
266,342.00 266,342.00
16,513.01 35,513.78
13.334 230,828.22
135-65010-030-000
135-65055-030-000
135-65085-030-000
135-65090-030-000
135-65095-030-000
135-65105-030-000
Uniforms
Hardware
Office Supplies
Printer Supplies & Maintenance
Maintenance Supplies
Printing
2,050.00
26,485.00
6,000.00
3,500.00
4,000.00
2,500.00
2,050.00
26,485.00
6,000.00
3,500.00
4,000.00
2,500.00
538.29
249.72
1,099.62
677.72
18.327
16.943
2,050.00
26,485.00
4,900.38
3,500.00
3,322.28
2,500.00
Subtotal:
44,535.00
44,535.00
788.01
1,777.34
3.991
42,757.66
135-69005-030-000
Capital Outlays
195,000.00
195,000.00
195,000.00
135-69170-030-000
Copier Lease Installments
4,000.00
4,000.00
239.52
493.36
12.334
3,506.64
Subtotal:
199,000.00
199,000.00
239.52
493.36
.248
198,506.64
Program number:
1,776,712.00
1,776,712.00
105,293.05
216,740.52
12.199
1,559,971.48
Department number:
Administration
1,776,712.00
1,776,712.00
105,293.05
216,740.52
12.199
1,559,971.48
47 of 140
glbase_tbam skrolczyk
16:37 12/09/19
Fund: 135 MUD 1 General Fund Department:
Account Description Adopted
Budget
Trophy Club MUD No.1 Page 12
Budget Summary with Amendment
39 Non Departmental Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
Amended Total Current YTD % of Remaining
Budget Encumb. Month Total Budget Budget
135-55045-039-000 Legal 135,000.00 135,000.00 25,504.93
135-55055-039-000 Auditing 33,800.00 33,800.00 10,150.00
135-55060-039-000 Appraisal 11,761.00 11,761.00
135-55065-039-000 Tax Admin Fees 4,000.00 4,000.00
Subtotal: 184,561.00 184,561.00 35,654.93
Program number: 184,561.00 184,561.00 35,654.93
Department number: Non Departmental 184,561.00 184,561.00 35,654.93
Expenditures Subtotal 10,638,853.00 10,638,853.00 870,422.24
Fund number: 135 MUD 1 General Fund 6,224.00- 6,224.00- 253,193.03
48 of 140
25,504.93 18.893 109,495.07
15,150.00 44.822 18,650.00
13.35- -.114 11,774.35
4,000.00
40,641.58
40,641.58
40,641.58
1,471,467.22
40,953.86
22.021
22.021
22.021
13.831
-657.999
143,919.42
143,919.42
143,919.42
9,167,385.78
47,177.86-
glbase_tbam skrolczyk Trophy Club MUD No.l Page 13
16:37 12/09/19 Budget Summary with Amendment
Fund: 137 MUD 1 Consolidated GASB Department: Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
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
Subtotal: 286,420.00- 286,420.00
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
49 of 140
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 5
16:38 12/09/19 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: Revenues Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-40000-000-000 Property Taxes
363 11/01/2019 Property Taxes
364 11/04/2019 Property Taxes
365 11/05/2019 Property Taxes
366 11/06/2019 Property Taxes
367 11/07/2019 Property Taxes
368 11/08/2019 Property Taxes
369 11/12/2019 Property Taxes
370 11/13/2019 Property Taxes
371 11/14/2019 Property Taxes
372 11/15/2019 Property Taxes
373 11/18/2019 Property Taxes
374 11/19/2019 Property Taxes
375 11/20/2019 Property Taxes
376 11/21/2019 Property Taxes
377 11/22/2019 Property Taxes
378 11/25/2019 Property Taxes
379 11/26/2019 Property Taxes
380 11/27/2019 Property Taxes
(1,723.24)
(171.09)
(401.67)
(739.28)
(288.70)
(344.79)
(629.04)
(160.13)
(743.92)
(399.21)
(164.79)
(93.07)
(382.13)
(965.74)
(214.85)
(19.66)
(404.84)
(400.11)
(142.26)
(1,894.33)
(2,296.00)
(3,035.28)
(3,323.98)
(3,668.77)
(4,297.81)
(4,457.94)
(5,201.86)
(5,601.07)
(5,765.86)
(5,858.93)
(6,241.06)
(7,206.80)
(7,421.65)
(7,441.31)
(7,846.15)
(8,246.26)
(8,388.52)
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
Account: 135-40000-000-000
Property Taxes Totals:
(6,665.28) (8,388.52) **
(134,871.00) Budgeted
(126,482.48) Remaining 6 % Used
Account: 135-40002-000-000 Property Taxes/Delinquent
363 11/01/2019 Property Taxes
366 11/06/2019 Property Taxes
374 11/19/2019 Property Taxes
377 11/22/2019 Property Taxes
380 11/27/2019 Property Taxes
155.66 (24.22) 131.44 GL
(32.20) 99.24 GL
(.39) 98.85 GL
1.91 100.76 GL
(49.36) 51.40 GL
Account: 135-40002-000-000
Property Taxes/Delinquent Totals:
(104.26) 51.40 **
(300.00) Budgeted
(351.40) Remaining -17 % Used
Account: 135-40015-000-000 Property Taxes/P & I
363 11/01/2019 Property Taxes
365 11/05/2019 Property Taxes
366 11/06/2019 Property Taxes
369 11/12/2019 Property Taxes
370 11/13/2019 Property Taxes
372 11/15/2019 Property Taxes
374 11/19/2019 Property Taxes
(7.82) (5.33) (13.15) GL
(.12) (13.27) GL
(1.95) (15.22) GL
(.12) (15.34) GL
(.01) (15.35) GL
(.11) (15.46) GL
(.08) (15.54) GL
50 of 140
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 6
16:38 12/09/19 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: Revenues Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
375 11/20/2019 Property Taxes
380 11/27/2019 Property Taxes
(7.82) (101.81) (117.35) GL
(10.82) (128.17) GL
Account: 135-40015-000-000
Property Taxes/P & I Totals: (120.35) (128.17) **
(300.00) Budgeted
(171.83) Remaining 43 6 Used
Account: 135-40025-000-000 PID Surcharges
.00 .00
Account: 135-40025-000-000
PID Surcharges Totals: .00 .00 **
(164,253.00) Budgeted
(164,253.00) Remaining 0 % Used
Account: 135-47000-000-000 Water
240 11/11/2019 UB 11/11/2019 Adjustments
331 11/14/2019 RFD-Miniates incorrect read
312 11/30/2019 UB 11/30/2019 Billing
UB20191111-20191111 User:
UB20191114-20191114 User:
UB20191130-20191130 User:
(536,379.28)
20.38 (536,358.90) UB
111.60 (536,247.30) UB
(330,665.20) (866,912.50) UB
Account: 135-47000-000-000
Water Totals:
1
(330,533.22) (866,912.50) **
(6,486,623.00) Budgeted
(5,619,710.50) Remaining 13 % Used
Account: 135-47005-000-000 Sewer
240 11/11/2019 UB 11/11/2019 Adjustments
UB20191111-20191111 User: (221,960.36)
312 11/30/2019 UB 11/30/2019 Billing UB20191130-20191130 User:
34.15 (221,926.21) UB
(255,452.52) (477,378.73) UB
Account: 135-47005-000-000
Sewer Totals:
1
(255,418.37) (477,378.73) **
(3,503,885.00) Budgeted
(3,026,506.27) Remaining 14 % Used
Account: 135-47025-000-000 Penalties
246 11/12/2019 UB 11/12/2019 Penalty removal UB20191112-20191112 User:
283 11/20/2019 UB 11/20/2019 Penalty removal UB20191120-20191120 User:
288 11/21/2019 UB 11/21/2019 Penalties UB20191121-20191121 User:
293 11/25/2019 UB 11/25/2019 Penalty removal UB20191125-20191125 User:
302 11/26/2019 UB 11/26/2019 Penalty removal UB20191126-20191126 User:
305 11/26/2019 UB 11/26/2019 Penalty removal UB20191126-20191126 User:
(9,981.43) 182.03 (9,799.40) UB
480.33 (9,319.07) UB
(11,403.51) (20,722.58) UB
68.63 (20,653.95) UB
125.39 (20,528.56) UB
25.84 (20,502.72) UB
Account: 135-47025-000-000
1
Penalties
Totals:
(10,521.29) (20,502.72) **
(112,608.00) Budgeted
(92,105.28) Remaining 18 6 Used
Account: 135-47030-000-000 Service Charges
51 of 140
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 7
16:38 12/09/19 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: Revenues Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
247 11/01/2019 UB 11/01/2019 NSF Check
222 11/06/2019 Cut Offs -November 2019
282 11/18/2019 UB 11/18/2019 NSF check
UB20191101-20191101 User:
UB20191106-20191106 User:
UB20191118-20191118 User:
(1,075.00) (25.00) (1,100.00) UB
(2,050.00) (3,150.00) UB
(75.00) (3,225.00) UB
Account: 135-47030-000-000 Service Charges Totals: (3,225.00) **
(15,150.00) Budgeted
Account: 135-47035-000-000
Account: 135-47035-000-000
(11,925.00) Remaining 21 % Used
Plumbing Inspections
(1,800.00) .00 (1,800.00)
Plumbing Inspections .00 (1,800.00) **
(750.00) Budgeted 1,050.00 Remaining 240 % Used
Account: 135-47045-000-000 Sewer Inspections
(400.00)
.00 (400.00)
Account: 135-47045-000-000 Sewer Inspections .00 (400.00) **
(2,500.00) Budgeted (2,100.00) Remaining 16 % Used
Account: 135-47070-000-000 TCCC Effluent Charges
312 11/30/2019 UB 11/30/2019 Billing UB20191130-20191130 User: (15,036.00)
Account: 135-47070-000-000
TCCC Effluent Charges Totals:
(50,000.00) Budgeted (34,951.20) Remaining
Account: 135-49011-000-000 Interest Income
348 11/30/2019 Bank Interest- November
348 11/30/2019 Bank Interest- November
348 11/30/2019 Bank Interest- November
384 11/30/2019 Prosperity Bank Interest Corr Interest from Savings/Checking
384 11/30/2019 Prosperity Bank Interest Corr Interest from Savings/Checking
Account: 135-49011-000-000
(12.80) (15,048.80) UB
30 % Used
(11,765.78)
(12.80) (15,048.80) **
(1,064.21) (12,829.99) GL
(1,075.00) (13,904.99) GL
(7,573.44) (21,478.43) GL
(10.79) (21,489.22) GL
10.79 (21,478.43) GL
Interest Income Totals: (9,712.65) (21,478.43) **
(120,000.00) Budgeted
Account: 135-49016-000-000 Cell Tower Revenue
347 11/12/2019 Cell Tower Rev AT&T November
(98,521.57) Remaining 18 % Used
52 of 140
(1,178.81) (1,178.81) GL
glpdatb2 skrolczyk
16:38 12/09/19
Fund: 135 MUD 1 General Fund
JE JE JE
Number Date Description
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: Revenues Program:
Period Ending: 11/2019
Beginning Transaction Transaction Vendor_Name
Balance Detail Detail
(SUBTOTAL)
JE Detail
Description/Comment
Page 8
December 16, 2019 Regular Meeting Agenda Packet
Check Source
Number
Department Totals:
(7,000.00) Budgeted
(617,229.21) Monthly Total
601.14 Remaining
109 % Used
(1,430,513.36) **
(10,645,077.00) Budgeted (9,214,563.64) Remaining 13 % Used
53 of 140
Account:
135-49016-000-000 Cell Tower Revenue Totals:
(1,178.81)
(1,178.81)
**
(14,146.00) Budgeted (12,967.19) Remaining
8 %
Used
Account:
135-49018-000-000 Building Rent Income
350 11/30/2019 Town Billed Invoices 1714-1717 AR 20191130-20191130 User:
(583.33)
(583.33)
(1,166.66)
AR
Account:
135-49018-000-000 Building Rent Income Totals:
(583.33)
(1,166.66)
**
(7,000.00) Budgeted (5,833.34) Remaining
17 %
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
(5,355.28)
.00
(5,355.28)
Account:
135-49075-000-000 Oversize Meter Reimbursement Totals:
.00
(5,355.28)
**
(12,691.00) Budgeted (7,335.72) Remaining
42 %
Used
Account:
135-49900-000-000 Miscellaneous Income
312 11/30/2019 UB 11/30/2019 Billing UB20191130-20191130 User:
UB
(7,372.29)
(228.85)
(7,601.14)
Account:
135-49900-000-000 Miscellaneous Income Totals:
(228.85)
(7,601.14)
**
Department Totals:
(7,000.00) Budgeted
(617,229.21) Monthly Total
601.14 Remaining
109 % Used
(1,430,513.36) **
(10,645,077.00) Budgeted (9,214,563.64) Remaining 13 % Used
53 of 140
glpdatb2 skrolczyk
16:38 12/09/19
Fund: 135 MUD 1 General Fund
JE JE JE
Number Date Description
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: 10 Water
Period Ending: 11/2019
JE Detail Beginning
Balance
Description/Comment
Program:
Page 9
December 16, 2019 Regular Meeting Agenda Packet
Transaction Transaction Vendor_Name
Detail Detail
(SUBTOTAL)
Check Source
Number
134 11/01/2019 MUD Payroll 11/01/19
241 11/15/2019 MUD Payroll 11/15/2019
276 11/22/2019 MUD Payroll 11/22/19
298 11/27/2019 MUD Payroll 11/27/19
Retirement
Retirement
Retirement
Retirement
2,135.12
1,260.61
1,423.21
470.14
1,474.92
3,395.73
4,818.94
5,289.08
6,764.00
PR
PR
PR
PR
Account: 135-50020-010-000
Retirement
Totals:
4,628.88 6,764.00 **
34,863.00 Budgeted
28,099.00 Remaining 19 % Used
Account: 135-50026-010-000
Medical Insurance
54 of 140
Account:
135-50005-010-000
Salaries & Wages
134 11/01/2019 MUD Payroll
241 11/15/2019 MUD Payroll
298 11/27/2019 MUD Payroll
11/01/19 Salaries
11/15/2019 Salaries
11/27/19 Salaries
& Wages
& Wages
& Wages
10,227.68
12,896.59
13,915.33
14,318.59
23,124.27
37,039.60
51,358.19
PR
PR
PR
Account:
135-50005-010-000
Salaries & Wages
Totals:
41,130.51
51,358.19
**
350,267.00 Budgeted
298,908.81 Remaining
15
% Used
Account:
135-50010-010-000
' Overtime
134 11/01/2019 MUD Payroll
241 11/15/2019 MUD Payroll
298 11/27/2019 MUD Payroll
11/01/19 Overtime
11/15/2019 Overtime
11/27/19 Overtime
821.89
731.69
1,020.71
1,626.53
1,553.58
2,574.29
4,200.82
PR
PR
PR
Account:
135-50010-010-000
' Overtime
Totals:
3,378.93
4,200.82
**
17,000.00 Budgeted
12,799.18 Remaining
25
% Used
Account:
135-50016-010-000
Longevity
276 11/22/2019 MUD Payroll
11/22/19 Longevity
5,082.50
5,082.50
PR
Account:
135-50016-010-000
Longevity
Totals:
5,082.50
5,082.50
**
3,920.00 Budgeted
(1,162.50) Remaining
130
% Used
Account:
135-50017-010-000
Certification
241 11/15/2019 MUD Payroll
11/15/2019 Certification
350.00
450.00
800.00
PR
Account:
135-50017-010-000
Certification
Totals:
450.00
800.00
**
5,400.00 Budgeted
4,600.00 Remaining
15
% Used
Account:
135-50020-010-000
Retirement
134 11/01/2019 MUD Payroll 11/01/19
241 11/15/2019 MUD Payroll 11/15/2019
276 11/22/2019 MUD Payroll 11/22/19
298 11/27/2019 MUD Payroll 11/27/19
Retirement
Retirement
Retirement
Retirement
2,135.12
1,260.61
1,423.21
470.14
1,474.92
3,395.73
4,818.94
5,289.08
6,764.00
PR
PR
PR
PR
Account: 135-50020-010-000
Retirement
Totals:
4,628.88 6,764.00 **
34,863.00 Budgeted
28,099.00 Remaining 19 % Used
Account: 135-50026-010-000
Medical Insurance
54 of 140
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10
16:38 12/09/19 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
134 11/01/2019 MUD Payroll 11/01/19
Medical Insurance 3,821.04
241 11/15/2019 MUD Payroll 11/15/2019 Medical Insurance
2,614.96 6,436.00 PR
2,614.89 9,050.89 PR
Account: 135-50026-010-000
Medical Insurance Totals: 5,229.85 9,050.89 **
84,326.00 Budgeted
75,275.11 Remaining 11 % Used
Account: 135-50027-010-000 ' Dental Insurance
134 11/01/2019 MUD Payroll 11/01/19 Dental Insurance
241 11/15/2019 MUD Payroll 11/15/2019 Dental Insurance
243.97 155.16 399.13 PR
155.10 554.23 PR
Account: 135-50027-010-000
Dental Insurance Totals: 310.26 554.23 **
4,725.00 Budgeted
4,170.77 Remaining 12 % Used
Account: 135-50028-010-000 Vision Insurance
134 11/01/2019 MUD Payroll 11/01/19 Vision Insurance
241 11/15/2019 MUD Payroll 11/15/2019 Vision Insurance
38.90 26.06 64.96 PR
26.01 90.97 PR
Account: 135-50028-010-000
_ Vision Insurance Totals:
52.07 90.97 **
767.00 Budgeted
676.03 Remaining 12 % Used
Account: 135-50029-010-000 11111 Life Insurance & Other
216 11/01/2019 Payroll Benefits November
216 11/01/2019 Payroll Benefits November
318 11/30/2019 November A/P
Employee LTD & STD
Employee Benefits
caf 125 -October
189.67 123.66 313.33 METLIFE GROUP BENEFITS
125.44 438.77 Humana Inc
20.00 458.77 BenefitMall
5896 AP
5891 AP
5923 AP
Account: 135-50029-010-000
Life Insurance & Other Totals: 269.10 458.77 **
3,132.00 Budgeted
2,673.23 Remaining 15 % Used
Account: 135-50030-010-000 Social Security Taxes
134 11/01/2019 MUD Payroll 11/01/19
241 11/15/2019 MUD Payroll 11/15/2019
276 11/22/2019 MUD Payroll 11/22/19
298 11/27/2019 MUD Payroll 11/27/19
Social Security Taxes
Social Security Taxes
Social Security Taxes
Social Security Taxes
693.28 834.35 1,527.63 PR
940.23 2,467.86 PR
315.11 2,782.97 PR
989.91 3,772.88 PR
Account: 135-50030-010-000
Social Security Taxes Totals: 3,079.60 3,772.88 **
23,348.00 Budgeted
19,575.12 Remaining 16 % Used
Account: 135-50035-010-000 Medicare Taxes
55 of 140
glpdatb2 skrolczyk Trophy Club MUD No.1
16:38 12/09/19 Detailed Accounting Trial Balance
Page 11
Fund: 135 MUD 1 General Fund Department: 10 Water Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
134 11/01/2019 MUD Payroll 11/01/19
241 11/15/2019 MUD Payroll 11/15/2019
276 11/22/2019 MUD Payroll 11/22/19
298 11/27/2019 MUD Payroll 11/27/19
Medicare Taxes
Medicare Taxes
Medicare Taxes
Medicare Taxes
162.14
195.12
219.90
73.69
231.52
357.26
577.16
650.85
882.37
PR
PR
PR
PR
Account:
135-50035-010-000
- Medicare Taxes Totals:
720.23
882.37
**
5,461.00 Budgeted 4,578.63 Remaining
16 %
Used
Account:
135-50040-010-000
' Unemployment Taxes
134 11/01/2019
241 11/15/2019
298 11/27/2019
MUD Payroll 11/01/19 Unemployment Taxes
MUD Payroll 11/15/2019 Unemployment Taxes
MUD Payroll 11/27/19 Unemployment Taxes
.80
2.28
3.19
3.87
3.08
6.27
10.14
PR
PR
PR
Account:
135-50040-010-000
' Unemployment Taxes Totals:
9.34
10.14
**
1,080.00 Budgeted 1,069.86 Remaining
1 %
Used
Account:
135-50045-010-000
Workman's Compensation
67 11/01/2019
Insurance/Wrk Comp Expense Nov
771.49
771.49
1,542.98
GL
Account:
135-50045-010-000
Workman's Compensation Totals:
771.49
1,542.98
**
11,850.00 Budgeted 10,307.02 Remaining
13 %
Used
Account:
135-50060-010-000
Pre-emp Physicals/Testing
.00
.00
Account:
135-50060-010-000
Pre-emp Physicals/Testing Totals:
.00
.00
**
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:
.00
.00
**
300.00 Budgeted 300.00 Remaining
0 %
Used
Account:
135-55005-010-000
Engineering
.00
.00
Account:
135-55005-010-000
Engineering Totals:
.00
.00
**
20,000.00 Budgeted 20,000.00 Remaining
0 %
Used
56 of 140
glpdatb2 skrolczyk
16:38 12/09/19
Fund: 135 MUD 1 General Fund
JE
Number
JE
Date
JE
Description
Account: 135-55080-010-000
231 11/07/2019 November A/P
231 11/07/2019 November A/P
359 11/26/2019 PCards
359 11/26/2019 PCards
359 11/26/2019 PCards
359 11/26/2019 PCards
359 11/26/2019 PCards
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: 10 Water
Period Ending: 11/2019
JE Detail Beginning
Balance
Description/Comment
Program:
Transaction
Detail
Page 12
December 16, 2019 Regular Meeting Agenda Packet
Transaction Vendor_Name
Detail
(SUBTOTAL)
Check Source
Number
Maintenance & Repairs
water plant gate
parts
Sprinkler Check/Repair
Multch for Customer Repiar
Sprinkler Check/Repair
Turf Customer Repair
Sharkbite Elbow and Adapter
Well 61 emergency repair
meter boxes
hydrant parts
parts
10/29/19
10/29/19
10/29/19
10/29/19
10/29/19
318 11/30/2019 November A/P
318 11/30/2019 November A/P
318 11/30/2019 November A/P
318 11/30/2019 November A/P
Account: 135-55080-010-000
Account: 135-55085-010-000
Account: 135-55085-010-000
Account: 135-55090-010-000
Account: 135-55090-010-000
- 11/26/19
- 11/26/19
- 11/26/19
- 11/26/19
- 11/26/19
Maintenance & Repairs Totals:
100,000.00 Budgeted 86,882.63 Remaining
Generator Maint. and Repair
Generator Maint. and Repair Totals:
3,000.00 Budgeted 3,000.00 Remaining
Vehicle Maintenance
Vehicle Maintenance Totals:
5,000.00 Budgeted 4,792.12 Remaining
2,926.83
207.88
13 % Used
0 % Used
4 % Used
1,178.00 4,104.83
257.50 4,362.33
490.50 4,852.83
3.75 4,856.58
490.50 5,347.08
29.25 5,376.33
75.74 5,452.07
5,946.00 11,398.07
1,477.80 12,875.87
37.50 12,913.37
204.00 13,117.37
10,190.54
.00
.00
.00
.00
Alan's Gates, Inc.
Core & Main LP
ARS RR FT WORTH 9127
THE HOME DEPOT 66581
ARS RR FT WORTH 9127
TEX-TURF
THE HOME DEPOT 66581
DHS AUTOMATION, INC
Core & Main LP
Core & Main LP
Core & Main LP
13,117.37 **
.00
.00 **
207.88
207.88 **
5881 AP
5884 AP
PC
PC
PC
PC
PC
5930 AP
5928 AP
5928 AP
5928 AP
Account: 135-55105-010-000
Maintenance-Backhoe/SkidLoader
Account: 135-55105-010-000
Maintenance-Backhoe/SkidLoader Totals:
3,500.00 Budgeted 3,500.00 Remaining
0 % Used
.00
.00
.00
.00 **
Account: 135-55120-010-000
Cleaning Services
Account: 135-55120-010-000
Cleaning Services
1,000.00 Budgeted
87.50
.00
Totals:
912.50 Remaining 9 o Used
57 of 140
.00
87.50
87.50 **
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 13
16:38 12/09/19 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-55135-010-000
254 11/14/2019 November A/P
318 11/30/2019 November A/P
Lab Analysis
water samples
Lead & copper sampling
140.00 140.00 TARRANT CTY PUBLIC HEALTH LAB 5916 AP
600.00 740.00 Centralized Water & Wastewater 5925 AP
Account: 135-55135-010-000
Lab Analysis Totals: 740.00 740.00 **
7,500.00 Budgeted
6,760.00 Remaining 10 % Used
Account: 135-60010-010-000 Communications/Mobiles
254 11/14/2019 November A/P cell phones -november
359 11/26/2019 PCards 10/29/19 - 11/26/19 screen protectors
364.16 865.02
1,229.18 VERIZON WIRELESS 5920 AP
9.99 1,239.17 AMZN MKTP US*J16PNOT63
PC
Account: 135-60010-010-000
Communications/Mobiles Totals: 875.01 1,239.17 **
Account: 135-60020-010-000
318 11/30/2019 November A/P
Account: 135-60020-010-000
Account: 135-60066-010-000
5,000.00 Budgeted
3,760.83 Remaining 25 % Used
Electricity
electricity 10/10-11/8 14,721.00 11,423.51 26,144.51 HUDSON ENERGY SERVICES, LLC 5936 AP
Electricity Totals: 11,423.51 26,144.51 **
125,677.00 Budgeted 99,532.49 Remaining 21 % Used
Account: 135-60066-010-000
Publications/Books/Subscripts
.00 .00
Publications/Books/Subscripts Totals: .00 .00 **
1,000.00 Budgeted 1,000.00 Remaining 0 6 Used
Account: 135-60070-010-000
Dues & Memberships
.00 .00
Account: 135-60070-010-000 Dues & Memberships Totals: .00 .00 **
500.00 Budgeted 500.00 Remaining 0 % Used
Account: 135-60080-010-000 Schools & Training
295.00 .00 295.00
Account: 135-60080-010-000 Schools & Training Totals: .00 295.00 **
7,426.00 Budgeted 7,131.00 Remaining 4 % Used
58 of 140
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 14
16:38 12/09/19 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-60090-010-000 Safety Program
Account: 135-60090-010-000
Account: 135-60100-010-000
Account: 135-60100-010-000
Account: 135-60105-010-000
Account: 135-60105-010-000
Account: 135-60135-010-000
254 11/14/2019 November A/P
318 11/30/2019 November A/P
Safety Program
400.00 Budgeted
Travel & per diem
Travel & per diem
2,845.00 Budgeted
Rent/Lease Equipment
Rent/Lease Equipment
1,500.00 Budgeted
Account: 135-60135-010-000
Account: 135-60150-010-000
318 11/30/2019 November A/P
Totals:
400.00 Remaining 0 6 Used
Totals:
2,845.00 Remaining
.00
.00
.00 .00 **
.00
0 % Used
.00
.00
n=
.00 .00
Totals:
1,500.00 Remaining 0 6 Used
TCEQ Fees & Permits
well water
Water system Fee TCEQ
.00
5,752.20 5,752.20 North Texas Groundwater 5913 AP
8,454.95 14,207.15 TX COMMISSION ENVIRONMENTAL QU 5951 AP
TCEQ Fees & Permits Totals: 14,207.15 14,207.E
63,000.00 Budgeted
Wholesale Water
wholesale water
48,792.85 Remaining 23 % Used
220,912.63
220,912.63 CITY OF FORT WORTH 5926 AP
Account: 135-60150-010-000
Wholesale Water Totals:
220,912.63 220,912.63 **
2,714,710.00 Budgeted
Account: 135-60245-010-000 Miscellaneous Expenses
Account: 135-60245-010-000
Miscellaneous Expenses
200.00 Budgeted
2,493,797.37 Remaining 8 6 Used
Totals:
200.00 Remaining 0 6 Used
.00
.00
.00 .00 **
Account: 135-60280-010-000
Property Maintenance
59 of 140
glpdatb2 skrolczyk
16:38 12/09/19
Fund: 135 MUD 1 General Fund
JE JE JE
Number Date Description
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: 10 Water
Period Ending: 11/2019
JE Detail Beginning
Balance
Description/Comment
462.00
Program:
Page 15
December 16, 2019 Regular Meeting Agenda Packet
Transaction Transaction Vendor_Name
Detail Detail
(SUBTOTAL)
.00
462.00
Check Source
Number
60 of 140
Account:
135-60280-010-000 Property Maintenance Totals:
.00
462.00
**
3,000.00 Budgeted 2,538.00 Remaining
15
5 Used
Account:
135-60285-010-000 Lawn Equipment & Maintenance
.00
.00
Account:
135-60285-010-000 Lawn Equipment & Maintenance Totals:
.00
.00
**
14,750.00 Budgeted 14,750.00 Remaining
0
% Used
Account:
135-60332-010-000 Interfund Transfer Out -Rev I&S
346 11/15/2019 TexPool Transfers November TexPool O&M to 16Swift Rev I&S
346 11/15/2019 TexPool Transfers November TexPool O&M to 19 W&WW Rev I&S
47,943.74
25,047.72
22,896.02
72,991.46
95,887.48
GL
GL
Account:
135-60332-010-000 Interfund Transfer Out -Rev I&S Totals:
47,943.74
95,887.48
**
527,381.00 Budgeted 431,493.52 Remaining
18
% Used
Account:
135-60333-010-000 Interfund Transfer Out -Reserve
346 11/15/2019 TexPool Transfers November TexPool O&M to Rev Bond Resevr
4,600.00
4,600.00
9,200.00
GL
Account:
135-60333-010-000 Interfund Transfer Out -Reserve Totals:
4,600.00
9,200.00
**
55,193.00 Budgeted 45,993.00 Remaining
17
% Used
Account:
135-60334-010-000 Interfund Transfer Out
.00
.00
Account:
135-60334-010-000 Interfund Transfer Out Totals:
.00
.00
**
180,000.00 Budgeted 180,000.00 Remaining
0
% Used
Account:
135-60360-010-000 Furniture/Equipment < $5000
359 11/26/2019 PCards 10/29/19 - 11/26/19 hanging clamps
100.57
100.57
AMZN MKTP US*PK4EH4DP3
PC
Account:
135-60360-010-000 Furniture/Equipment < $5000 Totals:
100.57
100.57
**
2,500.00 Budgeted 2,399.43 Remaining
4
% Used
Account:
135-65005-010-000 Fuel & Lube
60 of 140
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16
16:38 12/09/19 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
352 11/24/2019 Fuel -November Fuel -Nov 773.48 970.35 1,743.83 US Bank Voyager Fleet Systems 5985 AP
Account: 135-65005-010-000
Fuel & Lube Totals: 970.35 1,743.83 **
15,000.00 Budgeted
13,256.17 Remaining 12 % Used
Account: 135-65010-010-000 Uniforms
359 11/26/2019 PCards 10/29/19 - 11/26/19 shoes
359 11/26/2019 PCards 10/29/19 - 11/26/19 pants
359 11/26/2019 PCards 10/29/19 - 11/26/19 pants
359 11/26/2019 PCards 10/29/19 - 11/26/19 Uniforms Water
359 11/26/2019 PCards 10/29/19 - 11/26/19 Uniforms Water
819.99 166.49 986.48 RED WING SHOES #573 PC
291.97 1,278.45 AMAZON.COM*AX75E74Y3 PC
160.93 1,439.38 AMAZON.COM*SOODX8NS3 PC
179.98 1,619.36 TRACTOR SUPPLY COMPANY PC
109.99 1,729.35 TRACTOR SUPPLY COMPANY PC
Account: 135-65010-010-000
Uniforms Totals:
909.36 1,729.35 **
5,190.00 Budgeted
3,460.65 Remaining 33 o Used
Account: 135-65030-010-000
Chemicals
318 11/30/2019 November A/P
318 11/30/2019 November A/P
318 11/30/2019 November A/P
356 11/30/2019 November A/P
testing supplies
testing supplies
chlorine
ammonia
1,689.24 287.77 1,977.01 HACH COMPANY
539.90 2,516.91 HACH COMPANY
335.05 2,851.96 DPC INDUSTRIES, INC
479.60 3,331.56 Valley Solvent Company, INC
5933 AP
5933 AP
5931 AP
5986 AP
Account:
135-65030-010-000
Chemicals
Totals:
1,642.32
3,331.56
**
20,000.00 Budgeted
16,668.44 Remaining
17
% 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
9 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
8,875.28
.00
8,875.28
61 of 140
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17
16:38 12/09/19 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-65050-010-000
Account: 135-65053-010-000
Account: 135-65053-010-000
Account: 135-69005-010-000
231 11/07/2019 November A/P
254 11/14/2019 November A/P
318 11/30/2019 November A/P
356 11/30/2019 November A/P
Meter Expense Totals:
70,000.00 Budgeted
Meter Change Out Program
61,124.72 Remaining 13 % Used
Meter Change Out Program Totals:
87,000.00 Budgeted 87,000.00 Remaining
Capital Outlays
beacon software
16" water line
Sundance & meadowbrook
meadowbrook s sundance
Account: 135-69005-010-000 Capital Outlays
684,875.00 Budgeted
18,651.60
O % Used
.00 8,875.28 **
.00
.00
.00 .00 **
5,472.00
3,055.78
2,025.00
600.00
24,123.60 BADGER METER, INC
27,179.38 Halff Associates, INC
29,204.38 Jackson Construction, LTD
29,804.38 TEAGUE, NALL S PERKINS,INC
5883 AP
5908 AP
5938 AP
5982 AP
11,152.78 29,804.38 **
655,070.62 Remaining 4 6 Used
Account: 135-69008-010-000 Short Term Debt -Principal
.00 .00
Account: 135-69008-010-000
Short Term Debt -Principal Totals: .00 .00 **
30,512.00 Budgeted 30,512.00 Remaining
O % Used
Account: 135-69009-010-000
Short Term Debt -Interest
.00 .00
Account: 135-69009-010-000
Short Term Debt -Interest Totals:
3,231.00 Budgeted 3,231.00 Remaining
Account: 135-69195-010-000 Gasb34/Reserve for Replacement
Account: 135-69195-010-000
Gasb34/Reserve for Replacement Totals:
75,000.00 Budgeted .00 Remaining
O % Used
75,000.00
100 % Used
.00 75,000.00
Account: 135-69281-010-000
Water Tank Inspection Contract
62 of 140
glpdatb2 skrolczyk
16:38 12/09/19
Fund: 135 MUD 1 General Fund
JE JE JE
Number Date Description
Trophy Club MUD No.1 Page 18
Detailed Accounting Trial Balance
Department: 10 Water Program:
Period Ending: 11/2019
Beginning Transaction Transaction Vendor_Name Check Source
Balance Detail Detail Number
(SUBTOTAL)
JE Detail
Description/Comment
231 11/07/2019 November A/P Tank contract
December 16, 2019 Regular Meeting Agenda Packet
57,932.73 57,932.73 UTILITY SERVICE CO, INC. 5903 AP
Account: 135-69281-010-000 Water Tank Inspection Contract Totals:
57,932.73 57,932.73
120,000.00 Budgeted
62,067.27 Remaining 48 % Used
63 of 140
glpdatb2 skrolczyk
16:38 12/09/19
Fund: 135 MUD 1 General Fund
JE JE JE
Number Date Description
Department: 10 Water
JE Detail
Description/Comment
Account: 135-55135-010-001 Lab Analysis for PID
254 11/14/2019 November A/P water samples
Account: 135-55135-010-001
Department 10 Totals:
Trophy Club MUD No.1 Page 19
Detailed Accounting Trial Balance
Program: 1 Lab Analysis for "December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
Beginning Transaction Transaction Vendor_Name Check Source
Balance Detail Detail Number
(SUBTOTAL)
Lab Analysis for PID Totals:
2,000.00 Budgeted
1,920.00 Remaining 4 % Used
80.00 80.00 TARRANT CTY PUBLIC HEALTH LAB 5916 AP
80.00 80.00 **
645,667.13 **
448,793.45 Monthly Total 5,506,929.00 Budgeted 4,861,261.87 Remaining 12 % Used
64 of 140
glpdatb2 skrolczyk
16:38 12/09/19
Fund: 135 MUD 1 General Fund
JE JE JE
Number Date Description
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: 20 Wastewater
Period Ending: 11/2019
JE Detail Beginning
Balance
Description/Comment
Program:
Page 20
December 16, 2019 Regular Meeting Agenda Packet
Transaction Transaction Vendor_Name
Detail Detail
(SUBTOTAL)
Check Source
Number
134 11/01/2019 MUD Payroll 11/01/19
241 11/15/2019 MUD Payroll 11/15/2019
276 11/22/2019 MUD Payroll 11/22/19
298 11/27/2019 MUD Payroll 11/27/19
Retirement
Retirement
Retirement
Retirement
2,854.98
1,510.53
1,486.46
635.72
1,432.70
4,365.51
5,851.97
6,487.69
7,920.39
PR
PR
PR
PR
Account: 135-50020-020-000
Retirement
Totals:
5,065.41 7,920.39 **
45,531.00 Budgeted
37,610.61 Remaining 17 % Used
Account: 135-50026-020-000
Medical Insurance
65 of 140
Account:
135-50005-020-000
Salaries & Wages
134 11/01/2019 MUD Payroll
241 11/15/2019 MUD Payroll
298 11/27/2019 MUD Payroll
11/01/19 Salaries
11/15/2019 Salaries
11/27/19 Salaries
& Wages
& Wages
& Wages
12,956.76
14,635.56
14,544.58
14,544.58
27,592.32
42,136.90
56,681.48
PR
PR
PR
Account:
135-50005-020-000
Salaries & Wages
Totals:
43,724.72
56,681.48
**
441,799.00 Budgeted
385,117.52 Remaining
13
% Used
Account:
135-50010-020-000
' Overtime
134 11/01/2019 MUD Payroll
241 11/15/2019 MUD Payroll
298 11/27/2019 MUD Payroll
11/01/19 Overtime
11/15/2019 Overtime
11/27/19 Overtime
649.08
1,694.42
900.40
944.08
2,343.50
3,243.90
4,187.98
PR
PR
PR
Account:
135-50010-020-000
' Overtime
Totals:
3,538.90
4,187.98
**
33,000.00 Budgeted
28,812.02 Remaining
13
% Used
Account:
135-50016-020-000
Longevity
276 11/22/2019 MUD Payroll
11/22/19 Longevity
6,872.50
6,872.50
PR
Account:
135-50016-020-000
Longevity
Totals:
6,872.50
6,872.50
**
8,035.00 Budgeted
1,162.50 Remaining
86
% Used
Account:
135-50017-020-000
Certification
241 11/15/2019 MUD Payroll
11/15/2019 Certification
625.00
625.00
1,250.00
PR
Account:
135-50017-020-000
Certification
Totals:
625.00
1,250.00
**
9,000.00 Budgeted
7,750.00 Remaining
14
% Used
Account:
135-50020-020-000
Retirement
134 11/01/2019 MUD Payroll 11/01/19
241 11/15/2019 MUD Payroll 11/15/2019
276 11/22/2019 MUD Payroll 11/22/19
298 11/27/2019 MUD Payroll 11/27/19
Retirement
Retirement
Retirement
Retirement
2,854.98
1,510.53
1,486.46
635.72
1,432.70
4,365.51
5,851.97
6,487.69
7,920.39
PR
PR
PR
PR
Account: 135-50020-020-000
Retirement
Totals:
5,065.41 7,920.39 **
45,531.00 Budgeted
37,610.61 Remaining 17 % Used
Account: 135-50026-020-000
Medical Insurance
65 of 140
glpdatb2 skrolczyk
16:38 12/09/19
Fund: 135 MUD 1 General Fund
JE JE JE
Number Date Description
134 11/01/2019 MUD Payroll 11/01/19
241 11/15/2019 MUD Payroll 11/15/2019
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: 20 Wastewater Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Page 21
Medical Insurance
Medical Insurance
5,987.13
2,993.58
2,993.55
8,980.71
11,974.26
PR
PR
134 11/01/2019 MUD Payroll 11/01/19
241 11/15/2019 MUD Payroll 11/15/2019
276 11/22/2019 MUD Payroll 11/22/19
298 11/27/2019 MUD Payroll 11/27/19
Social Security Taxes
Social Security Taxes
Social Security Taxes
Social Security Taxes
803.96
952.88
909.83
426.08
962.92
1,756.84
2,666.67
3,092.75
4,055.67
PR
PR
PR
PR
Account: 135-50030-020-000
Social Security Taxes Totals:
3,251.71 4,055.67 **
30,494.00 Budgeted
26,438.33 Remaining 13 % Used
Account: 135-50035-020-000
Medicare Taxes
66 of 140
Account:
135-50026-020-000 Medical Insurance
Totals:
5,987.13
11,974.26
**
104,858.00 Budgeted
92,883.74 Remaining
11 % Used
Account:
135-50027-020-000 ' Dental Insurance
134 11/01/2019 MUD Payroll 11/01/19 Dental Insurance
241 11/15/2019 MUD Payroll 11/15/2019 Dental Insurance
358.15
179.09
179.06
537.24
716.30
PR
PR
Account:
135-50027-020-000 Dental Insurance
Totals:
358.15
716.30
**
5,817.00 Budgeted
5,100.70 Remaining
12 %
Used
Account:
135-50028-020-000 Vision Insurance
134 11/01/2019 MUD Payroll 11/01/19 Vision Insurance
241 11/15/2019 MUD Payroll 11/15/2019 Vision Insurance
59.22
29.62
29.60
88.84
118.44
PR
PR
Account:
135-50028-020-000 11111 Vision Insurance
Totals:
59.22
118.44
**
948.00 Budgeted
829.56 Remaining
12 8
Used
Account:
135-50029-020-000 Life Insurance & Other
216 11/01/2019 Payroll Benefits November Employee LTD & STD
216 11/01/2019 Payroll Benefits November Employee Benefits
318 11/30/2019 November A/P caf 125 -October
337.14
157.87
148.12
36.00
495.01
643.13
679.13
METLIFE GROUP BENEFITS
Humana Inc
BenefitMall
5896
5891
5923
AP
AP
AP
Account:
135-50029-020-000 Life Insurance & Other
Totals:
341.99
679.13
**
4,500.00 Budgeted
3,820.87 Remaining
15 % Used
Account:
135-50030-020-000 Social Security Taxes
134 11/01/2019 MUD Payroll 11/01/19
241 11/15/2019 MUD Payroll 11/15/2019
276 11/22/2019 MUD Payroll 11/22/19
298 11/27/2019 MUD Payroll 11/27/19
Social Security Taxes
Social Security Taxes
Social Security Taxes
Social Security Taxes
803.96
952.88
909.83
426.08
962.92
1,756.84
2,666.67
3,092.75
4,055.67
PR
PR
PR
PR
Account: 135-50030-020-000
Social Security Taxes Totals:
3,251.71 4,055.67 **
30,494.00 Budgeted
26,438.33 Remaining 13 % Used
Account: 135-50035-020-000
Medicare Taxes
66 of 140
glpdatb2 skrolczyk Trophy Club MUD No.1
16:38 12/09/19 Detailed Accounting Trial Balance
Page 22
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
134 11/01/2019 MUD Payroll 11/01/19
241 11/15/2019 MUD Payroll 11/15/2019
276 11/22/2019 MUD Payroll 11/22/19
298 11/27/2019 MUD Payroll 11/27/19
Medicare Taxes
Medicare Taxes
Medicare Taxes
Medicare Taxes
188.01
222.85
212.77
99.65
225.21
410.86
623.63
723.28
948.49
PR
PR
PR
PR
Account:
135-50035-020-000 Medicare Taxes
Totals:
760.48
948.49
**
7,132.00 Budgeted
6,183.51 Remaining
13
% Used
Account:
135-50040-020-000 Unemployment Taxes
'
.00
.00
Account:
135-50040-020-000 Unemployment Taxes
Totals:
1111=.00
**
1,260.00 Budgeted
1,260.00 Remaining
0
% Used
Account:
135-50045-020-041 Workman's Compensation
67 11/01/2019 Insurance/Wrk Comp Expense Nov
1,110.20
1,110.20
2,220.40
GL
Account:
135-50045-020-000 Workman's Compensation
Totals:
1,110.20
2,220.40
**
15,373.00 Budgeted
13,152.60 Remaining
14
% Used
Account:
135-50060-020-000 Pre-emp Physicals/Testing
.00
.00
Account:
135-50060-020-000 Pre-emp Physicals/Testing
Totals:
.00
.00
**
400.00 Budgeted
400.00 Remaining
0
% Used
Account:
135-50070-020-000 Employee Relations
.00
.00
Account:
135-50070-020-000 Employee Relations
Totals:
.00
.00
**
300.00 Budgeted
300.00 Remaining
0
% Used
Account:
135-55005-020-000 Engineering
.00
.00
Account:
135-55005-020-000 Engineering
Totals:
.00
.00
**
30,000.00 Budgeted
30,000.00 Remaining
0
% Used
67 of 140
glpdatb2 skrolczyk
16:38 12/09/19
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: 11/2019
JE Detail Beginning
Balance
Description/Comment
Program:
Transaction
Detail
Page 23
December 16, 2019 Regular Meeting Agenda Packet
Transaction Vendor_Name
Detail
(SUBTOTAL)
Check Source
Number
Account: 135-55070-020-000
Independent Labor
318 11/30/2019 November A/P
Huber contract
3,000.00
3,000.00 Huber Technology Inc
5935 AP
Account: 135-55070-020-000
Independent Labor
Totals:
3,000.00
3,000.00 **
15,000.00 Budgeted 12,000.00 Remaining
20 % Used
Account: 135-55080-020-000
Maintenance & Repairs
359 11/26/2019
359 11/26/2019
359 11/26/2019
359 11/26/2019
359 11/26/2019
359 11/26/2019
359 11/26/2019
359 11/26/2019
318 11/30/2019
318 11/30/2019
356 11/30/2019
356 11/30/2019
PCards
PCards
PCards
PCards
PCards
PCards
PCards
10/29/19
10/29/19
10/29/19
10/29/19
10/29/19
10/29/19
10/29/19
PCards 10/29/19
November A/P
November A/P
November A/P
November A/P
- 11/26/19
- 11/26/19
- 11/26/19
- 11/26/19
- 11/26/19
- 11/26/19
- 11/26/19
- 11/26/19
Misc Parts
Hose
Misc Parts
nozzle
brass bushing
belt
dressing
bucket
thermostats in barn & WWTP
thermostats in barn & WWTP
permeate #6 fix
parts
3,704.54
138.94
79.97
140.17
126.28
35.44
374.94
10.58
13.75
215.00
450.00
490.00
907.21
3,843.48
3,923.45
4,063.62
4,189.90
4,225.34
4,600.28
4,610.86
4,624.61
4,839.61
5,289.61
5,779.61
6,686.82
ACADEMY SPORTS #81
THE HOME DEPOT 6581
GRAINGER
STUART HOSE & PIPE - F
ROANOKE WINNELSON CO
ROANOKE AUTO SUPPLY LT
ROANOKE AUTO SUPPLY LT
THE HOME DEPOT #6581
BRANDON R REED
BRANDON R REED
DHS AUTOMATION, INC
Huber Technology Inc
PC
PC
PC
PC
PC
PC
PC
PC
5924 AP
5924 AP
5968 AP
5971 AP
Account: 135-55080-020-000
Maintenance & Repairs
Totals:
2,982.28
6,686.82 **
88,000.00 Budgeted 81,313.18 Remaining
8 % Used
Account: 135-55081-020-000
Mainten & Repairs Collections
359 11/26/2019
318 11/30/2019
318 11/30/2019
318 11/30/2019
356 11/30/2019
356 11/30/2019
PCards 10/29/19
November A/P
November A/P
November A/P
November A/P
November A/P
11/26/19
concrete grade ring
LS #4 repair
manhole lids
gasketa
LS #20 pump and floats
pump for Ave 20 L/S
7,925.25
22.25
2,391.74
1,745.00
130.92
812.00
1,250.00
7,947.50
10,339.24
12,084.24
12,215.16
13,027.16
14,277.16
FERGUSON ENT 1241
DHS AUTOMATION, INC
Core & Main LP
SMITH PUMP COMPANY, INC.
DHS AUTOMATION, INC
NORTH TEXAS PUMP CO.
PC
5930 AP
5928 AP
5948 AP
5968 AP
5976 AP
Account: 135-55081-020-000
Mainten & Repairs Collections Totals:
6,351.91
14,277.16 **
10,000.00 Budgeted (4,277.16) Remaining
143 % Used
Account: 135-55085-020-000
Generator Maint. and Repair
.00
.00
Account: 135-55085-020-000
Generator Maint. and Repair Totals:
.00
.00 **
10,000.00 Budgeted
10,000.00 Remaining 0 % Used
68 of 140
glpdatb2 skrolczyk Trophy Club MUD No.1
16:38 12/09/19 Detailed Accounting Trial Balance
Page 24
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-55090-020-000 Vehicle Maintenance
359 11/26/2019 PCards 10/29/19 - 11/26/19
359 11/26/2019 PCards 10/29/19 - 11/26/19
359 11/26/2019 PCards 10/29/19 - 11/26/19
359 11/26/2019 PCards 10/29/19 - 11/26/19
Washer Fluid
car wash
truck maintenance
oil change
47.02 6.94 53.96 THE HOME DEPOT 6581
7.00 60.96 CARMEL CARWASH - ROANO
40.00 100.96 INLAND TRUCK PARTS #
61.52 162.48 KWIK KAR LUBE & TUNE 0
PC
PC
PC
PC
Account:
135-55090-020-000
Vehicle Maintenance Totals:
115.46
162.48
**
4,000.00 Budgeted 3,837.52 Remaining
4
% Used
Account:
135-55091-020-000
Veh Maintenance Collections
318 11/30/2019 November A/P
Vac truck service
1,837.08
1,837.08
CLS SEWER EQUIPMENT CO.,
INC
5927
AP
Account:
135-55091-020-000
Veh Maintenance Collections Totals:
1,837.08
1,837.08
**
8,000.00 Budgeted 6,162.92 Remaining
23
% Used
Account:
135-55105-020-000
Maintenance-Backhoe/SkidLoader
(856.24)
.00
(856.24)
Account:
135-55105-020-000
Maintenance-Backhoe/SkidLoader Totals:
.00
(856.24)
**
3,000.00 Budgeted 3,856.24 Remaining
-29
% Used
Account:
135-55120-020-000
Cleaning Services
87.50
.00
87.50
Account:
135-55120-020-000
Cleaning Services Totals:
.00
87.50
**
1,500.00 Budgeted 1,412.50 Remaining
6
% Used
Account:
135-55125-020-000
Dumpster Services
254 11/14/2019 November A/P
318 11/30/2019 November A/P
356 11/30/2019 November A/P
356 11/30/2019 November A/P
sludge/grit
Sludge grit
sludge haul off
sludge haul off
4,806.24
1,233.18
2,520.30
2,523.40
1,156.30
6,039.42 L.H. CHANEY MATERIALS, INC.
8,559.72 L.H. CHANEY MATERIALS, INC.
11,083.12 L.H. CHANEY MATERIALS, INC.
12,239.42 L.H. CHANEY MATERIALS, INC.
5910 AP
5941 AP
5974 AP
5974 AP
Account: 135-55125-020-000
Dumpster Services Totals:
7,433.18 12,239.42 **
100,000.00 Budgeted
87,760.58 Remaining 12 % Used
Account: 135-55135-020-000 Lab Analysis
228 11/07/2019 November A/P lab testing
2,389.60 317.40 2,707.00 OXIDOR LABORATORIES LLC
69 of 140
5898 AP
glpdatb2 skrolczyk Trophy Club MUD No.1
16:38 12/09/19 Detailed Accounting Trial Balance
Page 25
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
228 11/07/2019 November A/P lab testing
359 11/26/2019 PCards 10/29/19 - 11/26/19 Calibration Gas Monitor
318 11/30/2019 November A/P lab testing
318 11/30/2019 November A/P lab testing
318 11/30/2019 November A/P lab testing
318 11/30/2019 November A/P lab testing
356 11/30/2019 November A/P lab testing
2,389.60 230.00 2,937.00 OXIDOR LABORATORIES LLC
60.00 2,997.00 RITZ SAFETY DALLAS
317.40 3,314.40 OXIDOR LABORATORIES LLC
230.00 3,544.40 OXIDOR LABORATORIES LLC
317.40 3,861.80 OXIDOR LABORATORIES LLC
230.00 4,091.80 OXIDOR LABORATORIES LLC
317.40 4,409.20 OXIDOR LABORATORIES LLC
5898 AP
PC
5946 AP
5946 AP
5946 AP
5946 AP
5978 AP
Account: 135-55135-020-000 Lab Analysis Totals:
2,019.60
4,409.20
**
40,000.00 Budgeted 35,590.80 Remaining
11
% Used
Account: 135-60010-020-000 I Communications/Mobiles
254 11/14/2019 November A/P cell phones -november
359 11/26/2019 PCards 10/29/19 - 11/26/19 Tablet cases
372.84
769.01
32.98
1,141.85
1,174.83
VERIZON WIRELESS
AMZN MKTP US*IM2TO3FT3
5920
AP
PC
Account: 135-60010-020-000 ' Communications/Mobiles _ Totals:
801.99
1,174.83
**
5,000.00 Budgeted 3,825.17 Remaining
23
% Used
Account: 135-60020-020-000 Electricity
254 11/14/2019 November A/P electricity 9/27-10/29
318 11/30/2019 November A/P electricity 10/10-11/8
350 11/30/2019 Town Billed Invoices 1714-1717 AR 20191130-20191130 User:
11,761.29
500.86
10,861.33
(436.36)
12,262.15
23,123.48
22,687.12
TRI COUNTY ELECTRIC
HUDSON ENERGY SERVICES,
LLC
5918
5936
AP
AP
AR
Account: 135-60020-020-000 Electricity Totals:
10,925.83
22,687.12
**
160,067.00 Budgeted 137,379.88 Remaining
14
% Used
Account: 135-60066-020-000 Publications/Books/Subscripts
.00
.00
Account: 135-60066-020-000 Publications/Books/Subscripts Totals:
.00
.00
**
200.00 Budgeted 200.00 Remaining
0
% Used
Account: 135-60070-020-000 Dues & Memberships
.00
.00
Account: 135-60070-020-000 Dues & Memberships Totals:
.00
.00
**
300.00 Budgeted 300.00 Remaining
0
% Used
Account: 135-60080-020-000 Schools & Training
70 of 140
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26
16:38 12/09/19 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
359 11/26/2019 PCards 10/29/19 - 11/26/19 management training
840.00 333.53 1,173.53 SKILLPATH / NATIONAL
PC
Account: 135-60080-020-000
Schools & Training Totals: 333.53 1,173.53 **
4,990.00 Budgeted
3,816.47 Remaining 24 8 Used
Account: 135-60090-020-000
Safety Program
.00 .00
Account: 135-60090-020-000
Safety Program Totals: .00 .00 **
1,000.00 Budgeted
1,000.00 Remaining 0 % Used
Account: 135-60100-020-000 avel & per diem
241 11/15/2019 MUD Payroll 11/15/2019 Travel & per diem
359 11/26/2019 PCards 10/29/19 - 11/26/19 Richey Per Diem Training
359 11/26/2019 PCards 10/29/19 - 11/26/19 Richey Per Diem Training
Account: 135-60100-020-000
Travel & per diem
Totals:
297.57 297.57 PR
28.53 326.10 DIETER BROS RESTAURANT PC
30.61 356.71 THE SMOKEHOUSE LINDSAY PC
1,545.00 Budgeted 1,188.29 Remaining 23 % Used
356.71 356.71 **
Account: 135-60105-020-000
Rent/Lease Equipment
Account: 135-60105-020-000
Account: 135-60125-020-000
Account: 135-60125-020-000
.00 .00
Rent/Lease Equipment Totals:
5,000.00 Budgeted 5,000.00 Remaining 0 % Used
Advertising
.00 .00 **
.00 .00
Advertising Totals:
2,500.00 Budgeted 2,500.00 Remaining 0 % Used
.00 .00 **
Account: 135-60135-020-000
TCEQ Fees & Permits
9,888.02
Account: 135-60135-020-000
Account: 135-60245-020-000
TCEQ Fees & Permits Totals:
15,000.00 Budgeted 5,111.98 Remaining 66 % Used
Miscellaneous Expenses
71 of 140
.00 9,888.02
.00 9,888.02 **
glpdatb2 skrolczyk
16:38 12/09/19
Fund: 135 MUD 1 General Fund
JE JE JE
Number Date Description
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: 20 Wastewater
Period Ending: 11/2019
JE Detail Beginning
Balance
Description/Comment
Program:
Page 27
December 16, 2019 Regular Meeting Agenda Packet
Transaction Transaction Vendor_Name
Detail Detail
(SUBTOTAL)
.00
.00
Check Source
Number
72 of 140
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
.00
.00
Account:
135-60285-020-000 Lawn Equipment & Maintenance Totals:
.00
.00
**
14,000.00 Budgeted 14,000.00 Remaining
0
% Used
Account:
135-60331-020-000 Interfund Transfer Out -Tax I&S
346 11/15/2019 TexPool Transfers November TexPool O&M to I&S- PID Debt
10,414.81
10,414.81
20,829.62
GL
Account:
135-60331-020-000 Interfund Transfer Out -Tax I&S Totals:
10,414.81
20,829.62
**
114,563.00 Budgeted 93,733.38 Remaining
18
% Used
Account:
135-60332-020-000 1 Interfund Transfer Out -Rev I&S
I
346 11/15/2019 TexPool Transfers November TexPool O&M to Rev Bd WWTP I&S
346 11/15/2019 TexPool Transfers November TexPool O&M to 19 W&WW Rev I&S
389 11/15/2019 Adjust TexPool Tnfr Dep JE346
61,260.70
54,421.63
6,839.07
(.60)
115,682.33
122,521.40
122,520.80
GL
GL
GL
Account:
135-60332-020-000 Interfund Transfer Out -Rev I&S Totals:
61,260.10
122,520.80
**
673,867.00 Budgeted 551,346.20 Remaining
18
% Used
Account:
135-60333-020-000 Interfund Transfer Out -Reserve
346 11/15/2019 TexPool Transfers November TexPool O&M to Rev Bond Resevr
5,750.00
5,750.00
11,500.00
GL
Account:
135-60333-020-000 Interfund Transfer Out -Reserve Totals:
5,750.00
11,500.00
**
125,187.00 Budgeted 113,687.00 Remaining
9
5 Used
Account:
135-60334-020-000 Interfund Transfer Out
72 of 140
glpdatb2 skrolczyk
16:38 12/09/19
Fund: 135 MUD 1 General Fund
JE
Number
JE JE
Date Description
Account: 135-60334-020-000
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: 20 Wastewater
Period Ending: 11/2019
JE Detail Beginning
Balance
Description/Comment
Interfund Transfer Out Totals:
180,000.00 Budgeted 180,000.00 Remaining
Account: 135-60360-020-000 Furniture/Equipment < $5000
359 11/26/2019 PCards 10/29/19 - 11/26/19 Washer WWTP
Account: 135-60360-020-000
Account: 135-65005-020-000
352 11/24/2019 Fuel -November
Account: 135-65005-020-000
Account: 135-65010-020-000
359 11/26/2019 PCards 10/29/19
359 11/26/2019 PCards 10/29/19
359 11/26/2019 PCards 10/29/19
359 11/26/2019 PCards 10/29/19
359 11/26/2019 PCards 10/29/19
359 11/26/2019 PCards 10/29/19
318 11/30/2019 November A/P
■
Account: 135-65010-020-000
Account: 135-65030-020-000
254 11/14/2019 November A/P
Account: 135-65030-020-000
Account: 135-65031-020-000
254 11/14/2019 November A/P
Furniture/Equipment < $5000 Totals:
2,000.00 Budgeted 1,810.00 Remaining
Fuel & Lube
Fuel -Nov
Fuel & Lube
12,500.00 Budgeted
Uniforms
- 11/26/19 Orly- Uniforms
- 11/26/19 Richey Uniforms
- 11/26/19 Lnace Uniforms
- 11/26/19 pants
- 11/26/19 boots
- 11/26/19 pants
uniforms
Uniforms
5,495.00 Budgeted
Totals:
10,669.96 Remaining
Totals:
2,491.07 Remaining
Chemicals
4 drums -sodium hypo
Chemicals
20,000.00 Budgeted
Totals:
16,605.04 Remaining
Chemicals Collections
chemical for collections
Program:
Transaction
Detail
.00
0 % Used
.00
190.00
190.00
10 6 Used
Page 28
December 16, 2019 Regular Meeting Agenda Packet
Transaction Vendor_Name
Detail
(SUBTOTAL)
.00
.00 **
190.00 AAAA KELLER APPLIANCE
190.00 **
Check Source
Number
PC
923.61 906.43 1,830.04 US Bank Voyager Fleet Systems 5985 AP
892.41
15 6 Used
55 6 Used
906.43
136.88
114.94
110.95
96.46
170.00
154.95
1,327.34
2,111.52
1,830.04 **
1,029.29
1,144.23
1,255.18
1,351.64
1,521.64
1,676.59
3,003.93
THE HOME DEPOT #6581
ACADEMY SPORTS #81
ACADEMY SPORTS #81
WAL-MART #5247
RITZ SAFETY DALLAS
DICKIES OUTLET FW
RON MONTGOMERY & ASSOC INC
3,003.93 **
2,825.96 569.00 3,394.96 Valley Solvent Company, INC
17 % Used
73 of 140
569.00
4,994.00
3,394.96 **
4,994.00 MICKEY D CARSON DBA/NUSCO
PC
PC
PC
PC
PC
PC
5947 AP
5919 AP
5912 AP
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 29
16:38 12/09/19 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-65031-020-000
Chemicals Collections Totals: 4,994.00 4,994.00 **
17,500.00 Budgeted
Account: 135-65035-020-000 Small Tools
Account: 135-65035-020-000
Account: 135-65040-020-000
Account: 135-65040-020-000
Small Tools
1,200.00 Budgeted
Safety Equipment
Safety Equipment
1,200.00 Budgeted
12,506.00 Remaining 29 % Used
Totals:
1,200.00 Remaining 0 % Used
Totals:
1,200.00 Remaining 0 % Used
Account: 135-65045-020-000 ` Lab Supplies
254 11/14/2019 November A/P lab supplies
359 11/26/2019 PCards 10/29/19 - 11/26/19 Batteries
359 11/26/2019 PCards 10/29/19 - 11/26/19 thermometer
318 11/30/2019 November A/P lab supplies
318 11/30/2019 November A/P sensor COP replacement
356 11/30/2019 November A/P lab supplies
Account: 135-65045-020-000
Lab Supplies Totals:
20,000.00 Budgeted
.00
.00
.00 .00 **
.00
.00
.00 .00 **
2,983.01 298.43 3,281.44 HACH COMPANY 5909 AP
21.95 3,303.39 TOM THUMB 91789 PC
177.46 3,480.85 GRAINGER PC
113.94 3,594.79 HD SUPPLY FACILITIES MAINT LTD 5934 AP
153.06 3,747.85 HACH COMPANY 5933 AP
230.48 3,978.33 HACH COMPANY 5970 AP
16,021.67 Remaining 20 % Used
Account: 135-69005-020-000 Capital Outlays
359 11/26/2019 PCards 10/29/19 - 11/26/19 hoses
356 11/30/2019 November A/P plant water system
Account: 135-69005-020-000
Capital Outlays Totals:
530,500.00 Budgeted
995.32
3,978.33 **
5,789.00 476.00 6,265.00 STUART HOSE S PIPE - F
439,907.70 Remaining 17 6 Used
Account: 135-69008-020-000 Short Term Debt -Principal
Account: 135-69008-020-000
PC
84,327.30 90,592.30 REY-MAR CONSTRUCTION 5979 AP
84,803.30 90,592.30 **
.00 .00
Short Term Debt -Principal Totals: .00 .00 **
79,133.00 Budgeted 79,133.00 Remaining
0 % Used
74 of 140
glpdatb2 skrolczyk
16:38 12/09/19
Fund: 135 MUD 1 General Fund
JE JE JE
Number Date Description
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: 20 Wastewater
Period Ending: 11/2019
Program:
Page 30
December 16, 2019 Regular Meeting Agenda Packet
JE Detail Beginning Transaction Transaction Vendor_Name
Balance Detail Detail
(SUBTOTAL)
Description/Comment
Check Source
Number
Department 20 Totals:
279,847.46 Monthly Total
567,582.65 **
3,157,421.00 Budgeted 2,589,838.35 Remaining 18 % Used
75 of 140
Account:
135-69009-020-000
Short Term Debt -Interest
.00
.00
Account:
135-69009-020-000
Short Term Debt -Interest Totals:
.00
.00
**
11,277.00 Budgeted 11,277.00 Remaining 0 %
Used
Account:
135-69195-020-000
Gasb34/Reserve for Replacement
130,000.00
130,000.00
.00
Account:
135-69195-020-000
Gasb34/Reserve for Replacement Totals:
.00
130,000.00
**
130,000.00 Budgeted .00 Remaining 100 %
Used
Department 20 Totals:
279,847.46 Monthly Total
567,582.65 **
3,157,421.00 Budgeted 2,589,838.35 Remaining 18 % Used
75 of 140
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31
16:38 12/09/19 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-50045-026-000 Workman's Compensation
67 11/01/2019 Insurance/Wrk Comp Expense Nov
Account: 135-50045-026-000
Account: 135-60066-026-000
Account: 135-60066-026-000
Account: 135-60070-026-000
318 11/30/2019 November A/P
Account: 135-60070-026-000
Workman's Compensation Totals:
1.99 1.99 3.98 GL
30.00 Budgeted 26.02 Remaining 13 5 Used
Publications/Books/Subscripts
Publications/Books/Subscripts Totals:
150.00 Budgeted 150.00 Remaining
Dues & Memberships
Board annual membership dues F
Dues & Memberships Totals:
750.00 Budgeted
Account: 135-60075-026-000 Meetings
359 11/26/2019 PCards 10/29/19 - 11/26/19 Food Board Meeting
359 11/26/2019 PCards 10/29/19 - 11/26/19 board meeting
1.99 3.98 **
.00
0 % Used
.00
.00 .00 **
675.00 675.00 AWBD
75.00 Remaining 90 6 Used
675.00 675.00 **
5922 AP
118.43 118.43 VINNYS ITALIAN RESTAUR PC
37.93 156.36 TOM THUMB #1789 PC
Account: 135-60075-026-000
Meetings Totals: 156.36 156.36 **
Account: 135-60080-026-000
Account: 135-60080-026-000
1,300.00 Budgeted 1,143.64 Remaining 12 % Used
Schools S Training
Schools 6 Training Totals:
4,000.00 Budgeted
Account: 135-60100-026-000 Travel & per diem
4,000.00 Remaining 0 % Used
.00 .00
.00 .00 **
.00
.00
Account: 135-60100-026-000
Travel & per diem Totals:
.00 .00 **
Account: 135-60245-026-000
5,000.00 Budgeted
Miscellaneous Expenses
5,000.00 Remaining 0 6 Used
76 of 140
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32
16:38 12/09/19 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
.00 .00
Account: 135-60245-026-000
Miscellaneous Expenses Totals: .00 .00 **
2,000.00 Budgeted
2,000.00 Remaining 0 % Used
Department 26 Totals: 835.34 **
833.35 Monthly Total 13,230.00 Budgeted
77 of 140
12,394.66 Remaining 6 % Used
glpdatb2 skrolczyk
16:38 12/09/19
Fund: 135 MUD 1 General Fund
JE JE JE
Number Date Description
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: 30 Administration
Period Ending: 11/2019
JE Detail Beginning
Balance
Description/Comment
Program:
Page 33
December 16, 2019 Regular Meeting Agenda Packet
Transaction Transaction Vendor_Name
Detail Detail
(SUBTOTAL)
Check Source
Number
134 11/01/2019 MUD Payroll 11/01/19
241 11/15/2019 MUD Payroll 11/15/2019
276 11/22/2019 MUD Payroll 11/22/19
298 11/27/2019 MUD Payroll 11/27/19
Retirement
Retirement
Retirement
Retirement
2,760.64
1,395.32
1,393.86
204.18
1,395.98
4,155.96
5,549.82
5,754.00
7,149.98
PR
PR
PR
PR
Account:
135-50020-030-000
Retirement Totals:
4,389.34
7,149.98
**
Account:
135-50005-030-000
12 5
Salaries & Wages
Account:
135-50026-030-000
1 Medical Insurance
134 11/01/2019 MUD Payroll
241 11/15/2019 MUD Payroll
298 11/27/2019 MUD Payroll
11/01/19
11/15/2019
11/27/19
Salaries
Salaries
Salaries
& Wages
& Wages
& Wages
13,565.85
134 11/01/2019 MUD Payroll
241 11/15/2019 MUD Payroll
15,084.65
15,068.62
15,088.55
28,650.50
43,719.12
58,807.67
PR
PR
PR
Account:
135-50005-030-000
Salaries & Wages
Account:
Totals:
Medical Insurance Totals:
45,241.82
58,807.67
**
10,977.62
**
628,298.00 Budgeted
569,490.33 Remaining
9
% Used
Used
Account:
135-50010-030-000
135-50027-030-000
Overtime
134 11/01/2019 MUD Payroll
298 11/27/2019 MUD Payroll
11/27/19
Overtime
153.21
459.61
3.11
3.11
PR
Account:
135-50010-030-000
Overtime
Totals:
3.11
**
2,000.00 Budgeted
1,996.89 Remaining
0
% Used
Account:
135-50016-030-000
Longevity
276 11/22/2019 MUD Payroll
11/22/19
Longevity
2,207.50
2,207.50
PR
Account:
135-50016-030-000
Longevity
Totals:
2,207.50
2,207.50
**
2,208.00 Budgeted
.50 Remaining
100
8 Used
Account:
135-50020-030-000
Retirement
134 11/01/2019 MUD Payroll 11/01/19
241 11/15/2019 MUD Payroll 11/15/2019
276 11/22/2019 MUD Payroll 11/22/19
298 11/27/2019 MUD Payroll 11/27/19
Retirement
Retirement
Retirement
Retirement
2,760.64
1,395.32
1,393.86
204.18
1,395.98
4,155.96
5,549.82
5,754.00
7,149.98
PR
PR
PR
PR
Account:
135-50020-030-000
Retirement Totals:
4,389.34
7,149.98
**
58,554.00 Budgeted 51,404.02 Remaining
12 5
Used
Account:
135-50026-030-000
1 Medical Insurance
134 11/01/2019 MUD Payroll
241 11/15/2019 MUD Payroll
11/01/19 Medical Insurance
11/15/2019 Medical Insurance
5,488.81
2,744.43
2,744.38
8,233.24
10,977.62
PR
PR
Account:
135-50026-030-000
Medical Insurance Totals:
5,488.81
10,977.62
**
124,394.00 Budgeted 113,416.38 Remaining
9 %
Used
Account:
135-50027-030-000
Dental Insurance
134 11/01/2019 MUD Payroll
11/01/19 Dental Insurance
306.40
153.21
459.61
PR
78 of 140
glpdatb2 skrolczyk
16:38 12/09/19
Fund: 135 MUD 1 General Fund
JE JE JE
Number Date Description
241 11/15/2019 MUD Payroll 11/15/2019
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: 30 Administration
Period Ending: 11/2019
JE Detail Beginning
Balance
Description/Comment
Dental Insurance
306.40
Program:
Page 34
December 16, 2019 Regular Meeting Agenda Packet
Transaction Transaction Vendor_Name
Detail Detail
(SUBTOTAL)
153.19
612.80
Check Source
Number
PR
134 11/01/2019 MUD Payroll 11/01/19
241 11/15/2019 MUD Payroll 11/15/2019
276 11/22/2019 MUD Payroll 11/22/19
298 11/27/2019 MUD Payroll 11/27/19
Social Security Taxes
Social Security Taxes
Social Security Taxes
Social Security Taxes
782.00
872.87
868.73
136.86
935.67
1,654.87
2,523.60
2,660.46
3,596.13
PR
PR
PR
PR
Account: 135-50030-030-000
Social Security Taxes Totals:
2,814.13 3,596.13 **
39,215.00 Budgeted
35,618.87 Remaining 9 % Used
Account: 135-50035-030-000
Medicare Taxes
134 11/01/2019 MUD Payroll 11/01/19
241 11/15/2019 MUD Payroll 11/15/2019
276 11/22/2019 MUD Payroll 11/22/19
298 11/27/2019 MUD Payroll 11/27/19
Medicare Taxes
Medicare Taxes
Medicare Taxes
Medicare Taxes
182.91
204.12
203.17
32.02
218.82
387.03
590.20
622.22
841.04
PR
PR
PR
PR
Account: 135-50040-030-000
9,171.00 Budgeted
8,329.96 Remaining 9 6 Used
Unemployment Taxes
79 of 140
Account:
135-50027-030-000 Dental Insurance Totals:
306.40
612.80
**
6,464.00 Budgeted 5,851.20 Remaining
9
% Used
Account:
135-50028-030-000 Vision Insurance
134 11/01/2019 MUD Payroll 11/01/19 Vision Insurance
241 11/15/2019 MUD Payroll 11/15/2019 Vision Insurance
48.77
24.40
24.37
73.17
97.54
PR
PR
Account:
135-50028-030-000 Vision Insurance Totals:
48.77
97.54
**
1,035.00 Budgeted 937.46 Remaining
9
% Used
Account:
135-50029-030-000 Life Insurance & Other
216 11/01/2019 Payroll Benefits November Employee LTD & STD
216 11/01/2019 Payroll Benefits November Employee Benefits
318 11/30/2019 November A/P caf 125 -October
292.42
160.48
149.52
20.00
452.90
602.42
622.42
METLIFE GROUP BENEFITS
Humana Inc
BenefitMall
5896
5891
5923
AP
AP
AP
Account:
135-50029-030-000 Life Insurance & Other Totals:
330.00
622.42
**
4,500.00 Budgeted 3,877.58 Remaining
14
% Used
Account:
135-50030-030-000 Social Security Taxes
134 11/01/2019 MUD Payroll 11/01/19
241 11/15/2019 MUD Payroll 11/15/2019
276 11/22/2019 MUD Payroll 11/22/19
298 11/27/2019 MUD Payroll 11/27/19
Social Security Taxes
Social Security Taxes
Social Security Taxes
Social Security Taxes
782.00
872.87
868.73
136.86
935.67
1,654.87
2,523.60
2,660.46
3,596.13
PR
PR
PR
PR
Account: 135-50030-030-000
Social Security Taxes Totals:
2,814.13 3,596.13 **
39,215.00 Budgeted
35,618.87 Remaining 9 % Used
Account: 135-50035-030-000
Medicare Taxes
134 11/01/2019 MUD Payroll 11/01/19
241 11/15/2019 MUD Payroll 11/15/2019
276 11/22/2019 MUD Payroll 11/22/19
298 11/27/2019 MUD Payroll 11/27/19
Medicare Taxes
Medicare Taxes
Medicare Taxes
Medicare Taxes
182.91
204.12
203.17
32.02
218.82
387.03
590.20
622.22
841.04
PR
PR
PR
PR
Account: 135-50040-030-000
9,171.00 Budgeted
8,329.96 Remaining 9 6 Used
Unemployment Taxes
79 of 140
glpdatb2 skrolczyk
16:38 12/09/19
Fund: 135 MUD 1 General Fund
JE
Number
JE JE
Date Description
Account: 135-50040-030-000
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: 30 Administration
Period Ending: 11/2019
JE Detail Beginning
Balance
Description/Comment
Unemployment Taxes
1,440.00 Budgeted
Account: 135-50045-030-000 Workman's Compensation
67 11/01/2019 Insurance/Wrk Comp Expense Nov
Account: 135-50045-030-000
Workman's Compensation
1,775.00 Budgeted
Totals:
1,440.00 Remaining
Totals:
1,565.36 Remaining
104.82
Program:
Transaction
Detail
.00
O % Used
.00
104.82
12 % Used
104.82
Page 35
December 16, 2019 Regular Meeting Agenda Packet
Transaction Vendor_Name
Detail
(SUBTOTAL)
.00
.00 **
209.64
209.64 **
Check Source
Number
GL
Account: 135-50060-030-000
Pre-emp Physicals/Testing
Account: 135-50060-030-000
1
Pre-emp Physicals/Testing Totals:
500.00 Budgeted 500.00 Remaining
Account: 135-50070-030-000 Employee Relations
359 11/26/2019 PCards 10/29/19 - 11/26/19 Lunch Staff- Audit
359 11/26/2019 PCards 10/29/19 - 11/26/19 Steven Get Well Basket
Account: 135-50070-030-000
Account: 135-55030-030-000
145 11/01/2019 November A/P
255 11/14/2019 November A/P
359 11/26/2019 PCards 10/29/19
359 11/26/2019 PCards 10/29/19
359 11/26/2019 PCards 10/29/19
359 11/26/2019 PCards 10/29/19
318 11/30/2019 November A/P
318 11/30/2019 November A/P
360 11/30/2019 November A/P
Account: 135-55030-030-000
Employee Relations
8,000.00 Budgeted
Totals:
7,713.78 Remaining
178.85
O % Used
4 % Used
.00
.00
37.02
.00
.00 **
215.87 PIZZA HUT 24623
70.35 286.22 HAD*HARRY & DAVID
107.37
286.22 **
PC
PC
Software & Support
Microsoft exchang
internet-November
Phone Bill
Phone Bill
Phone Bill
Monthly Fee
support -P Card
Microsoft exchange
UB & Fixed Assets support
- 11/26/19
- 11/26/19
- 11/26/19
- 11/26/19
Software & Support
134,681.00 Budgeted
Totals:
66,483.55 Remaining
65,525.85
51 % Used
484.00
899.00
53.91
42.37
42.37
32.45
116.00
494.00
507.50
2,671.60
66,009.85
66,908.85
66,962.76
67,005.13
67,047.50
67,079.95
67,195.95
67,689.95
68,197.45
M3 Networks
Charter Communications
ATT*BILL PAYMENT
ATT*BILL PAYMENT
ATT*SILL PAYMENT
ADOBE ACROPRO SUBS
STW INC
M3 Networks
STW INC
68,197.45 **
5862 AP
5906 AP
PC
PC
PC
PC
5949 AP
5945 AP
5980 AP
Account: 135-55070-030-000
Independent Labor
80 of 140
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36
16:38 12/09/19 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
225 11/06/2019 November A?P
254 11/14/2019 November A/P
254 11/14/2019 November A/P
254 11/14/2019 November A/P
356 11/30/2019 November A/P
356 11/30/2019 November A/P
356 11/30/2019 November A/P
Account: 135-55070-030-000
Backflow Annual fee -FY 2020
GM -October
GM -October
GM -October
GM -November 2019
GM -November 2019
GM -November 2019
595.00 595.00 SC TRACKING SOLUTIONS LLC
32.48 627.48 Carman Consulting LLC.
11,680.00 12,307.48 Carman Consulting LLC.
4.15 12,311.63 Carman Consulting LLC.
11,040.00 23,351.63 Carman Consulting LLC.
26.68 23,378.31 Carman Consulting LLC.
2.40 23,380.71 Carman Consulting LLC.
Independent Labor Totals: 23,380.71 23,380.71 **
135,000.00 Budgeted
Account: 135-55080-030-000 Maintenance & Repairs
Account: 135-55080-030-000
Account: 135-55085-030-000
Account: 135-55085-030-000
111,619.29 Remaining 17 6 Used
Maintenance & Repairs Totals:
15,000.00 Budgeted
515.00
14,485.00 Remaining 3 % Used
Generator Maint. and Repair
.00 515.00
.00 515.00 **
.00 .00
Generator Maint. and Repair Totals: .00
10,000.00 Budgeted 10,000.00 Remaining
Account: 135-55120-030-000 Cleaning Services
Account: 135-55120-030-000
Cleaning Services Totals:
10,000.00 Budgeted
0 6 Used
869.06
9,130.94 Remaining 9 % Used
Account: 135-55160-030-000 Professional Outside Services
.00 **
.00 869.06
.00 869.06 **
.00 .00
Account: 135-55160-030-000 Professional Outside Services Totals: .00 .00 **
65,600.00 Budgeted 65,600.00 Remaining
Account: 135-55205-030-000 Utility Billing Contract
0 % Used
582.15
81 of 140
.00 582.15
1
1
1
1
5899 AP
5905 AP
5905 AP
5905 AP
5967 AP
5967 AP
5967 AP
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 37
16:38 12/09/19 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-55205-030-000
Utility Billing Contract Totals: .00 582.15 **
9,000.00 Budgeted
8,417.85 Remaining 6 8 Used
Account: 135-60005-030-000 Telephone
225 11/06/2019 November A?P Answering service -November
359 11/26/2019 PCards 10/29/19 - 11/26/19 Phone Bill
359 11/26/2019 PCards 10/29/19 - 11/26/19 Phone Bill
359 11/26/2019 PCards 10/29/19 - 11/26/19 Phone Bill
359 11/26/2019 PCards 10/29/19 - 11/26/19 Monthly Fee
350 11/30/2019 Town Billed Invoices 1714-1717 AR 20191130-20191130 User:
1,479.80 207.75 1,687.55 KEYSTONE PARK SECRETARIAL 5893 AP
471.71 2,159.26 ATT*BUS PHONE PMT PC
793.33 2,952.59 ATT*BUS PHONE PMT PC
180.20 3,132.79 ATT*BILL PAYMENT PC
14.99 3,147.78 RINGCENTRAL, INC PC
(180.00) 2,967.78 AR
Account: 135-60005-030-000
Telephone Totals: 1,487.98 2,967.78 **
23,680.00 Budgeted
20,712.22 Remaining 13 8 Used
Account: 135-60010-030-000 Communications/Mobiles
254 11/14/2019 November A/P cell phones -november
241 11/15/2019 MUD Payroll 11/15/2019 Communications/Mobiles
238.02 88.02
150.00
326.04 VERIZON WIRELESS 5920 AP
476.04 PR
Account: 135-60010-030-000 ■
Communications/Mobiles Totals:
238.02 476.04 **
4,000.00 Budgeted
3,523.96 Remaining 12 9 Used
Account: 135-60020-030-000 Electricity/Gas
.00 .00
Account: 135-60020-030-000
Electricity/Gas Totals: .00 .00 **
6,879.00 Budgeted
6,879.00 Remaining 0 % Used
Account: 135-60025-030-000 Water
350 11/30/2019 Town Billed Invoices 1714-1717 AR 20191130-20191130 User:
66.78 (56.39)
10.39 AR
356 11/30/2019 November A/P water -October 112.79 123.18 TROPHY CLUB MUD (WATER BILLS) 5984 AP
Account: 135-60025-030-000
Water Totals: 56.40 123.18 **
1,500.00 Budgeted
1,376.82 Remaining 8 % Used
Account: 135-60035-030-000 Postage
359 11/26/2019 PCards 10/29/19 - 11/26/19 Mailing Fees
1,726.61 49.43
82 of 140
1,776.04 FEDEX 99710126 PC
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38
16:38 12/09/19 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-60035-030-000
Account: 135-60040-030-000
345 11/30/2019 Pace Credit Card Fees
345 11/30/2019 Pace Credit Card Fees
356 11/30/2019 November A/P
360 11/30/2019 November A/P
Account: 135-60040-030-000
Postage Totals:
30,000.00 Budgeted
Service Charges & Fees
28,223.96 Remaining 6 % Used
Direct send fees -November
Dig Tess -October
Service Charges & Fees Totals:
67,000.00 Budgeted 52,729.22 Remaining
49.43
1,776.04 **
7,047.93 6,725.10 13,773.03 GL
195.05 13,968.08 GL
50.00 14,018.08 Fisery Solutions, LLC 5969 AP
252.70 14,270.78 Texas Excavation Safety System 5981 AP
21 % Used
7,222.85 14,270.78 **
Account: 135-60050-030-000 Bad Debt Expense
.00 .00
Account: 135-60050-030-000
Bad Debt Expense Totals: .00 .00 **
1,500.00 Budgeted
Account: 135-60055-030-000 Insurance
67 11/01/2019 Insurance/Wrk Comp Expense Nov
1,500.00 Remaining 0 % Used
6,998.39 6,998.39
13,996.78 GL
Account: 135-60055-030-000
Insurance Totals: 6,998.39 13,996.78 **
Account: 135-60066-030-000
Account: 135-60066-030-000
84,000.00 Budgeted
70,003.22 Remaining 17 % Used
Publications/Books/Subscripts
Publications/Books/Subscripts Totals:
1,000.00 Budgeted 1,000.00 Remaining
Account: 135-60070-030-000 Dues & Memberships
200.00
.00 .00
0 % Used
.00 .00 **
.00 200.00
Account: 135-60070-030-000
Dues & Memberships Totals: .00 200.00 **
6,000.00 Budgeted
5,800.00 Remaining 3 % Used
Account: 135-60075-030-000
Meetings
83 of 140
glpdatb2 skrolczyk
16:38 12/09/19
Fund: 135 MUD 1 General Fund
JE JE JE
Number Date Description
359 11/26/2019 PCards 10/29/19 - 11/26/19
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: 30 Administration
Period Ending: 11/2019
JE Detail Beginning
Balance
Description/Comment
safety meeting
Program:
Page 39
December 16, 2019 Regular Meeting Agenda Packet
Transaction Transaction Vendor_Name
Detail Detail
(SUBTOTAL)
35.18 35.18 SQ *SQ *HOT & CREAMY D
Check Source
Number
PC
84 of 140
Account:
135-60075-030-000 Meetings Totals:
35.18
35.18
**
400.00 Budgeted 364.82 Remaining
9
% Used
Account:
135-60079-030-000 Public Education
359 11/26/2019 PCards 10/29/19 - 11/26/19 District Document Filing
359 11/26/2019 PCards 10/29/19 - 11/26/19 District Document Filing
349.75
1.25
125.20
351.00
476.20
CFW PARKING METER
NCOURT *TXTARRANTCOSWP
PC
PC
Account:
135-60079-030-000 Public Education Totals:
126.45
476.20
**
6,000.00 Budgeted 5,523.80 Remaining
8
% Used
Account:
135-60080-030-000 Schools & Training
359 11/26/2019 PCards 10/29/19 - 11/26/19 Training GFOA
777.71
195.00
972.71
GOVERNMENT FINANCE OFF
PC
Account:
135-60080-030-000 Schools & Training Totals:
195.00
972.71
**
6,850.00 Budgeted 5,877.29 Remaining
14
% Used
Account:
135-60100-030-000 Travel & per diem
241 11/15/2019 MUD Payroll 11/15/2019 Travel & per diem
91.78
36.30
128.08
PR
Account:
135-60100-030-000 Travel & per diem Totals:
36.30
128.08
**
3,545.00 Budgeted 3,416.92 Remaining
4
% Used
Account:
135-60110-030-000 Physicals/Testing
.00
.00
Account:
135-60110-030-000 Physicals/Testing Totals:
.00
.00
**
200.00 Budgeted 200.00 Remaining
0
% Used
Account:
135-60115-030-000 Elections
359 11/26/2019 PCards 10/29/19 - 11/26/19 Pizza for Election Staff
43.01
43.01
MARCOS PIZZA - 5143
PC
Account:
135-60115-030-000 Elections Totals:
43.01
43.01
**
.00 Budgeted (43.01) Remaining
0
% Used
Account:
135-60125-030-000 Advertising
84 of 140
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 40
16:38 12/09/19 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-60125-030-000
Account: 135-60235-030-000
255 11/14/2019 November A/P
Account: 135-60235-030-000
.00 .00
Advertising Totals: .00 .00 **
2,500.00 Budgeted
Security
monitoring svc-nov
2,500.00 Remaining 0 % Used
24.00 24.00 48.00 Digital Air Control, Inc
Security Totals: 24.00 48.00 **
1,288.00 Budgeted
Account: 135-60245-030-000 Miscellaneous Expenses
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
1,240.00 Remaining 4 % Used
Miscellaneous Expenses Totals:
500.00 Budgeted 500.00 Remaining 0 % Used
General Manager Contingency
General Manager Contingency Totals:
17,000.00 Budgeted 17,000.00 Remaining
Furniture/Equipment < $5000
Furniture/Equipment < $5000 Totals:
2,500.00 Budgeted 2,500.00 Remaining
Uniforms
Uniforms Totals:
2,050.00 Budgeted
Hardware
0 o Used
0 % Used
2,050.00 Remaining 0 % Used
85 of 140
.00 .00
.00 .00 **
.00
.00
.00 .00 **
.00
.00
.00 .00 **
.00
.00
.00 .00 **
.00
.00
5907 AP
glpdatb2 skrolczyk
16:38 12/09/19
Fund: 135 MUD 1 General Fund
JE
Number
JE JE
Date Description
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: 30 Administration
Period Ending: 11/2019
JE Detail Beginning
Balance
Description/Comment
Program:
Transaction
Detail
Page 41
December 16, 2019 Regular Meeting Agenda Packet
Transaction Vendor_Name
Detail
(SUBTOTAL)
Check Source
Number
Account: 135-65055-030-000
Hardware
Totals:
.00
.00 **
26,485.00 Budgeted
26,485.00 Remaining
O % Used
Account: 135-65085-030-000
Office Supplies
254 11/14/2019
359 11/26/2019
359 11/26/2019
359 11/26/2019
359 11/26/2019
356 11/30/2019
356 11/30/2019
356 11/30/2019
356 11/30/2019
November A/P
PCards 10/29/19
PCards 10/29/19
PCards 10/29/19
PCards 10/29/19
November A/P
November A/P
November A/P
November A/P
- 11/26/19
- 11/26/19
- 11/26/19
- 11/26/19
office supplies
clipboards
monitor
ink
clock
office supplies
office supplies
office supplies
office supplies
561.33
112.18
9.95
249.99
12.83
15.59
63.50
46.91
11.19
16.15
673.51
683.46
933.45
946.28
961.87
1,025.37
1,072.28
1,083.47
1,099.62
OFFICE DEPOT, INC
AMAZON.COM*WP17E7D13
AMAZON.COM*EI1DV6713
AMZN MKTP US*2042M75S3
AMZN MKTP US*ZG9FP0XN3
OFFICE DEPOT, INC
OFFICE DEPOT, INC
OFFICE DEPOT, INC
OFFICE DEPOT, INC
5914 AP
PC
PC
PC
PC
5977 AP
5977 AP
5977 AP
5977 AP
Account: 135-65085-030-000
Office Supplies
Totals:
538.29
1,099.62 **
6,000.00 Budgeted
4,900.38 Remaining
18 % Used
Account: 135-65090-030-000
Printer Supplies & Maintenance
.00
.00
Account: 135-65090-030-000
Printer Supplies & Maintenance Totals:
.00
.00 **
3,500.00 Budgeted
3,500.00 Remaining
O % Used
Account: 135-65095-030-000
Maintenance Supplies
359 11/26/2019 PCards 10/29/19 - 11/26/19
359 11/26/2019 PCards 10/29/19 - 11/26/19
359 11/26/2019 PCards 10/29/19 - 11/26/19
359 11/26/2019 PCards 10/29/19 - 11/26/19
359 11/26/2019 PCards 10/29/19 - 11/26/19
359 11/26/2019 PCards 10/29/19 - 11/26/19
359 11/26/2019 PCards 10/29/19 - 11/26/19
359 11/26/2019 PCards 10/29/19 - 11/26/19
359 11/26/2019 PCards 10/29/19 - 11/26/19
359 11/26/2019 PCards 10/29/19 - 11/26/19
359 11/26/2019 PCards 10/29/19 - 11/26/19
359 11/26/2019 PCards 10/29/19 - 11/26/19
359 11/26/2019 PCards 10/29/19 - 11/26/19
359 11/26/2019 PCards 10/29/19 - 11/26/19
forks,water, cups, creamer,etc
cups
batteries
refund for coffee
refund for coffee
refund for tea
refund for coffee
coffee
coffee
coffee
tea
tea
coffee
coffee
428.00
86 of 140
111.67
15.67
10.99
(29.28)
(12.01)
(12.88)
(29.11)
50.99
32.95
29.11
12.01
12.88
27.45
29.28
539.67
555.34
566.33
537.05
525.04
512.16
483.05
534.04
566.99
596.10
608.11
620.99
648.44
677.72
SAMSCLUB.COM
SAMSCLUB #4795
AMAZON.COM*1X6R423D3
AMAZON.COM
AMAZON.COM
AMAZON.COM
AMAZON.COM
AMZN MKTP US*8R9KH2VM3
AMAZON.COM*WU4PB61V3
AMAZON.COM*E09VG5QH3
AMAZON.COM*TM8QL2DH3
AMAZON.COM*6530M29J3
AMAZON.COM*B25AT9BG3
AMAZON.COM*6W79C8WN3
PC
PC
PC
PC
PC
PC
PC
PC
PC
PC
PC
PC
PC
PC
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42
16:38 12/09/19 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-65095-030-000
Maintenance Supplies Totals:
249.72 677.72 **
4,000.00 Budgeted
3,322.28 Remaining 17 % Used
Account: 135-65105-030-000 Printing
.00
.00
Account: 135-65105-030-000
Printing Totals:
.00 .00 **
2,500.00 Budgeted
2,500.00 Remaining 0 % Used
Account: 135-69005-030-000 Capital Outlays
.00
.00
Account: 135-69005-030-000
Capital Outlays Totals:
.00 .00 **
Account: 135-69170-030-000
254 11/14/2019 November A/P
318 11/30/2019 November A/P
Account: 135-69170-030-000
Department 30 Totals:
195,000.00 Budgeted
195,000.00 Remaining 0 o Used
Copier Lease Installments
copier lease-nov
copies
Copier Lease Installments Totals:
4,000.00 Budgeted 3,506.64 Remaining
105,293.05 Monthly Total
253.84 165.00 418.84 TIAA COMMERCIAL FINANCE
74.52 493.36 KYOCERA DOCUMENT SOLUTIONS
239.52
12 % Used
493.36 **
216,740.52 **
1,776,712.00 Budgeted 1,559,971.48 Remaining 12 % Used
87 of 140
5917 AP
5940 AP
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 43
16:38 12/09/19 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-55045-039-000 Legal
254 11/14/2019 November A/P legal 3,570.00 3,570.00 McLean & Howard, L.L.P. 5911 AP
254 11/14/2019 November A/P legal -travel 1,050.00 4,620.00 McLean & Howard, L.L.P. 5911 AP
318 11/30/2019 November A/P Southlake easement 20,884.93 25,504.93 WHITAKER CHALK SWINDLE 5952 AP
Account: 135-55045-039-000
Legal Totals:
3 25,504.93 **
Account: 135-55055-039-000
318 11/30/2019 November A/P
135,000.00 Budgeted
109,495.07 Remaining 19 % Used
Auditing
FYE 2019 Audit 5,000.00 10,150.00
15,150.00 LAFOLLETT & COMPANY, PLLC
5943 AP
Account: 135-55055-039-000
Auditing Totals: 10,150.00
15,150.00 **
33,800.00 Budgeted
Account: 135-55060-039-000
Account: 135-55060-039-000
Appraisal
18,650.00 Remaining 45 % Used
(13.35) .00 (13.35)
Appraisal Totals: .00 (13.35) **
11,761.00 Budgeted
11,774.35 Remaining 0 % Used
Account: 135-55065-039-000 Tax Admin Fees
.00
.00
Account: 135-55065-039-000
Tax Admin Fees Totals:
.00
.00 **
4,000.00 Budgeted
4,000.00 Remaining 0 % Used
Department 39 Totals: 40,641.58 **
Fund 135 Totals:
35,654.93 Monthly Total 184,561.00 Budgeted
253,193.03 Monthly Total
143,919.42 Remaining 22 % Used
40,953.86
(6,224.00) Budgeted (47,177.86) Remaining ####*9####
88 of 140
glpdatb2 skrolczyk
16:38 12/09/19
Fund: 137 MUD 1 Consolidated GASB
JE JE JE
Number Date Description
Department:
JE Detail
Description/Comment
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Period Ending: 11/2019
Beginning
Balance
Program:
Page 44
December 16, 2019 Regular Meeting Agenda Packet
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
89 of 140
(286,420.00) **
286,420.00 Remaining 0 % Used
(286,420.00)
286,420.00 Remaining 0 % Used
Account:
137-49145-000-000
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
89 of 140
(286,420.00) **
286,420.00 Remaining 0 % Used
(286,420.00)
286,420.00 Remaining 0 % Used
December 16, 2019 Regular Meeting Agenda Packet
TROPHY CLUB MUD #1 - WWTP TAX BOND CONST
BALANCE SHEET
NOVEMBER 2019
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
131
TROPHY CLUB
MUNICIPAL /
UTILITY
DISTRICT
517
TAX BOND
CONSTRUCTION
568,889
TOTAL ASSETS 568,889
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
691,868
TOTAL LIABILITIES 691,868
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES
(118,410)
(4,569)
TOTAL FUND BALANCE (122,979)
TOTAL LIABILITIES AND FUND BALANCE 568,889
90 of 140
glbase_tbam skrolczyk
16:37 12/09/19
Fund: 517 2014 MUD 1 Tax Bond Const WWTP
Account
Description
Department:
Adopted
Budget
Trophy Club MUD No.1
Budget Summary with Amendment
Revenues
Period Ending: 11/2019
Amended Total
Budget Encumb.
Current
Month
Program:
YTD
Total
% of
Budget
Page 14
December 16, 2019 Regular Meeting Agenda Packet
Remaining
Budget
517-49011-000-000
Interest Income
783.24-
1,822.08-
1,822.08
Subtotal:
783.24-
1,822.08-
1,822.08
Program number:
783.24-
1,822.08-
1,822.08
Department number:
Revenues
783.24-
1,822.08-
1,822.08
Revenues
Subtotal
783.24-
1,822.08-
1,822.08
91 of 140
glbase_tbam skrolczyk
16:37 12/09/19
Fund: 517 2014 MUD 1 Tax Bond Const WWTP
Account
Description
Trophy Club MUD No.1
Budget Summary with Amendment
Department: 20 Wastewater
Period Ending: 11/2019
Adopted Amended Total
Budget Budget Encumb.
Current
Month
Program:
YTD
Total
% of
Budget
Page 15
December 16, 2019 Regular Meeting Agenda Packet
Remaining
Budget
517-69005-020-000 Capital Outlays
6,391.00
6,391.00
6,391.00 -
Subtotal:
6,391.00
6,391.00
6,391.00 -
Program number:
6,391.00
6,391.00
6,391.00 -
Department number: Wastewater
6,391.00
6,391.00
6,391.00 -
Expenditures
Subtotal
6,391.00
6,391.00
6,391.00 -
Fund number:
517 2014 MUD 1 Tax Bond Const WWTP
5,607.76
4,568.92
4,568.92-
92 of 140
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45
16:38 12/09/19 Detailed Accounting Trial Balance
Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 517-49011-000-000 Interest Income
348 11/30/2019 Bank Interest- November (1,038.84)
Account: 517-49011-000-000
Interest Income Totals:
.00 Budgeted
1,822.08 Remaining 0 % Used
(783.24) (1,822.08) GL
(783.24)
(1,822.08) **
Department Totals: (1,822.08) **
(783.24) Monthly Total .00 Budgeted
93 of 140
1,822.08 Remaining 0 % Used
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46
16:38 12/09/19 Detailed Accounting Trial Balance
Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 517-69005-020-000
318 11/30/2019 November A/P
318 11/30/2019 November A/P
Account: 517-69005-020-000
Capital Outlays
WWTP Crane survey
WWTP legal
2,056.00 2,056.00 Wiss, Janney, Elstner Assoc 5953 AP
4,335.00 6,391.00 Dubois Bryant Campbell LLP 5932 AP
Capital Outlays Totals: 6,391.00 6,391.00 **
.00 Budgeted
(6,391.00) Remaining 0 % Used
Department 20 Totals: 6,391.00 **
6,391.00 Monthly Total .00 Budgeted
(6,391.00) Remaining 0 % Used
Fund 517 Totals: 4,568.92
5,607.76 Monthly Total .00 Budgeted
94 of 140
(4,568.92) Remaining 0 % Used
December 16, 2019 Regular Meeting Agenda Packet
TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION
NSII FORT WORTH- SWIFT FUNDING
BALANCE SHEET
NOVEMBER 2019
ASSETS
CASH IN BANK
CASH IN ESCROW
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
519
REVENUE BOND
CONSTRUCTION
780,339
TOTAL ASSETS 780,339
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
95 of 140
81,691
81,691
698,648
698,648
780,339
December 16, 2019 Regular Meeting Agenda Packet
TROPHY CLUB MUD #1 - 16" WATERLINE REV BOND
BALANCE SHEET
NOVEMBER 2019
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
FUND 520
16" 2019
ASSETS REVENUE BOND
CASH IN BANK 586,482
INVESTMENTS 3,869,575
ACCOUNTS RECEIVABLE
TOTAL ASSETS 4,456,058
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES 6,004
TOTAL LIABILITIES 6,004
FUND BALANCE
ASSIGNED FUND BALANCE 4,454,290
NET REVENUES / EXPENDITURES (4,236)
TOTAL FUND BALANCE 4,450,054
TOTAL LIABILITIES AND FUND BALANCE 4,456,058
96 of 140
glbase_tbam skrolczyk
16:37 12/09/19
Fund: 520 Revenue Bond 16" Waterline
Account
Description
Department:
Adopted
Budget
Trophy Club MUD No.1
Budget Summary with Amendment
Period Ending: 11/2019
Amended Total Current
Budget Encumb. Month
Program:
YTD
Total
% of
Budget
Page 16
December 16, 2019 Regular Meeting Agenda Packet
Remaining
Budget
520-49011-000-000
Interest Income
807.46-
1,767.21-
1,767.21
Subtotal:
807.46-
1,767.21-
1,767.21
Program number:
807.46-
1,767.21-
1,767.21
Department number:
807.46-
1,767.21-
1,767.21
Revenues
Subtotal
807.46-
1,767.21-
1,767.21
97 of 140
glbase_tbam skrolczyk
16:37 12/09/19
Fund: 520 Revenue Bond 16" Waterline
Account
Description
Trophy Club MUD No.1
Budget Summary with Amendment
Department: 10 Water Department
Period Ending: 11/2019
Adopted Amended Total
Budget Budget Encumb.
Current
Month
Program:
YTD
Total
% of
Budget
Page 17
December 16, 2019 Regular Meeting Agenda Packet
Remaining
Budget
520-69005-010-000
Capital Outlays
6,003.50
6,003.50
6,003.50 -
Subtotal:
6,003.50
6,003.50
6,003.50 -
Program number:
6,003.50
6,003.50
6,003.50 -
Department number:
Water Department
6,003.50
6,003.50
6,003.50 -
Expenditures
Subtotal
6,003.50
6,003.50
6,003.50 -
Fund number: 520
Revenue Bond 16" Waterline
5,196.04
4,236.29
4,236.29-
98 of 140
glpdatb2 skrolczyk
16:38 12/09/19
Fund: 520 Revenue Bond 16" Waterline
JE JE JE
Number Date Description
Department:
JE Detail
Description/Comment
Trophy Club MUD No.1 Page 47
Detailed Accounting Trial Balance
Program:
December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
Beginning Transaction Transaction Vendor_Name Check Source
Balance Detail Detail Number
(SUBTOTAL)
Account: 520-49011-000-000 Interest Income
348 11/30/2019 Bank Interest- November (959.75)
Account: 520-49011-000-000
Interest Income Totals:
.00 Budgeted
1,767.21 Remaining 0 % Used
(807.46) (1,767.21) GL
(807.46)
(1,767.21) **
Department Totals: (1,767.21) **
(807.46) Monthly Total .00 Budgeted
99 of 140
1,767.21 Remaining 0 % Used
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 48
16:38 12/09/19 Detailed Accounting Trial Balance
Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
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
318 11/30/2019 November A/P
318 11/30/2019 November A/P
Account: 520-69005-010-000
Capital Outlays
Easement -Lake Cities Church of
16" waterline easement acquisi
4,424.00 4,424.00 Lake Cities Church of Christ 5942 AP
1,579.50 6,003.50 Jackson Walker LLP 5939 AP
Capital Outlays Totals: 6,003.50 6,003.50 **
.00 Budgeted
(6,003.50) Remaining 0 % Used
Department 10 Totals: 6,003.50 **
6,003.50 Monthly Total .00 Budgeted
(6,003.50) Remaining 0 % Used
Fund 520 Totals: 4,236.29
5,196.04 Monthly Total .00 Budgeted
100 of 140
(4,236.29) Remaining 0 % Used
December 16, 2019 Regular Meeting Agenda Packet
TROPHY CLUB MUD #1 - REVENUE BOND RESERVE
BALANCE SHEET
NOVEMBER 2019
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
528
REVENUE BOND
RESERVE
826,594
TOTAL ASSETS 826,594
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
101 of 140
803,457
23,137
826,594
826,594
glbase_tbam skrolczyk
16:37 12/09/19
Fund: 528 2015 Revenue Bond Reserve Fund Department:
Trophy Club MUD No.1 Page 18
Budget Summary with Amendment
Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
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
Subtotal:
Program number:
Department number:
Revenues
Interest Income
Interfund transfer in -Water
Interfund transfer in -WW
Subtotal
Fund number: 528 2015 Revenue Bond Reserve Fund
11,000.00- 11,000.00-
307,049.00- 307,049.00-
200,417.00- 200,417.00-
518,466.00- 518,466.00-
518,466.00- 518,466.00-
518,466.00- 518,466.00-
518,466.00- 518,466.00-
518,466.00- 518,466.00-
102 of 140
1,131.32- 2,436.79-
4,600.00- 9,200.00-
5,750.00- 11,500.00-
11,481.32- 23,136.79-
11,481.32- 23,136.79-
11,481.32- 23,136.79-
11,481.32- 23,136.79-
11,481.32- 23,136.79-
22.153
2.996
5.738
4.463
4.463
4.463
4.463
4.463
8,563.21-
297,849.00-
188,917.00-
495,329.21-
495,329.21-
495,329.21-
495,329.21-
495,329.21-
glpdatb2 skrolczyk
16:38 12/09/19
Fund: 528 2015 Revenue Bond Reserve Fund
JE JE JE
Number Date Description
Department:
JE Detail
Description/Comment
Account: 528-49011-000-000 Interest Income
348 11/30/2019 Bank Interest- November
Account: 528-49011-000-000
Trophy Club MUD No.1 Page 49
Detailed Accounting Trial Balance
Program:
December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
Beginning Transaction Transaction Vendor_Name Check Source
Balance Detail Detail Number
(SUBTOTAL)
(1,305.47) (1,131.32)
(2,436.79) GL
Interest Income Totals: (1,131.32) (2,436.79) **
(11,000.00) Budgeted
(8,563.21) Remaining 22 6 Used
Account: 528-49142-000-000 Interfund transfer in -Water
346 11/15/2019 TexPool Transfers November TexPool O&M to Rev Bond Resevr
Account: 528-49142-000-000 Interfund transfer in -Water Totals:
(307,049.00) Budgeted (297,849.00) Remaining
Account: 528-49143-000-000 Interfund transfer in -WW
346 11/15/2019 TexPool Transfers November TexPool 0&M to Rev Bond Resevr
Account: 528-49143-000-000
Interfund transfer in -WW Totals:
(200,417.00) Budgeted (188,917.00) Remaining
(4,600.00) (4,600.00)
3 % Used
(9,200.00) GL
(4,600.00) (9,200.00) **
(5,750.00) (5,750.00) (11,500.00) GL
6 % Used
(5,750.00) (11,500.00) **
Department Totals: (23,136.79) **
(11,481.32) Monthly Total (518,466.00) Budgeted
(495,329.21) Remaining 4 % Used
Fund 528 Totals: (23,136.79)
(11,481.32) Monthly Total (518,466.00) Budgeted
103 of 140
(495,329.21) Remaining 4 % Used
December 16, 2019 Regular Meeting Agenda Packet
TROPHY CLUB MUD #1 - I&S (DEBT SERVICE)
BALANCE SHEET
NOVEMBER 2019
ASSETS
CASH IN BANK
INVESTMENTS 146,424
PREPAID EXPENSES -
ADVALOREM PROPERTY TAXES RECEIVABLE 668,429
ACCOUNTS RECEIVABLE -OTHER -
TOTAL ASSETS 814,853
Q
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
INTEREST &
SINKING- 533
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 668,429
ACCOUNTS AND OTHER PAYABLES -
TOTAL LIABILITIES 668,429
FUND BALANCE
ASSIGNED FUND BALANCE 82,954
NET REVENUES / EXPENDITURES 63,470
TOTAL FUND BALANCE 146,424
TOTAL LIABILITIES AND FUND BALANCE 814,853
104 of 140
glbase_tbam skrolczyk
16:37 12/09/19
Fund: 533 MUD 1 I&S Consolidated
Account Description
1
1 533-40000-000-000
1 533-40002-000-000
1 533-40015-000-000
Property Taxes
Property Taxes/Delinquent
Property Taxes/P & I
Trophy Club MUD No.1
Budget Summary with Amendment
Department: Revenues Program:
Period Ending: 11/2019
Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
Page 19
December 16, 2019 Regular Meeting Agenda Packet
682,441.00-
1,000.00-
2,000.00-
682,441.00-
1,000.00-
2,000.00-
33,745.30-
565.22-
98.36-
42,469.72-
274.56
141.16-
6.223
-27.456
7.058
639,971.28-
1,274.56-
1,858.84 -
Subtotal:
685,441.00- 685,441.00-
34,408.88- 42,336.32-
6.177 643,104.68-
533-49011-000-000
1 533-49015-000-000
Interest Income
Lease/Rental Income
5,000.00-
218,004.00-
5,000.00-
218,004.00-
166.99-
303.85-
6.077
4,696.15-
218,004.00-
533-49141-000-000
Interfund Trans In -PID Surchg
114,563.00-
114,563.00-
10,414.81-
20,829.62-
18.182
93,733.38 -
Subtotal:
337,567.00-
337,567.00-
10,581.80-
21,133.47-
6.261
316,433.53 -
Program number:
1,023,008.00-
1,023,008.00-
44,990.68-
63,469.79-
6.204
959,538.21 -
Department number:
Revenues
1,023,008.00-
1,023,008.00-
44,990.68-
63,469.79-
6.204
959,538.21 -
Revenues
Subtotal
1,023,008.00-
1,023,008.00-
44,990.68-
63,469.79-
6.204
959,538.21-
105 of 140
glbase_tbam skrolczyk
16:37 12/09/19
Fund: 533 MUD 1 I&S Consolidated
Account
1 533-70005-051-000
Description
Paying Agent Fee
Trophy Club MUD No.1
Budget Summary with Amendment
Department: 51 Administration
Period Ending: 11/2019
Adopted Amended Total
Budget Budget Encumb.
2,150.00
2,150.00
Current
Month
Program:
YTD
Total
Page 20
December 16, 2019 Regular Meeting Agenda Packet
% of Remaining
Budget Budget
2,150.00
533-70025-051-000
1 533-70035-051-000
Bond Interest Expense -Tax
Bond Principal Payment -Tax
266,058.00
755,000.00
266,058.00
755,000.00
266,058.00
755,000.00
Subtotal:
1,023,208.00
1,023,208.00
1,023,208.00
Program number:
1,023,208.00
1,023,208.00
1,023,208.00
Department number:
Administration
1,023,208.00
1,023,208.00
1,023,208.00
Expenditures
Subtotal
1,023,208.00
1,023,208.00
1,023,208.00
Fund number: 533
MUD 1 I&S Consolidated
200.00
200.00
44,990.68-
63,469.79- ###############
63,669.79
106 of 140
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 50
16:38 12/09/19 Detailed Accounting Trial Balance
Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 533-40000-000-000 Property Taxes
363 11/01/2019 Property Taxes
364 11/04/2019 Property Taxes
365 11/05/2019 Property Taxes
366 11/06/2019 Property Taxes
367 11/07/2019 Property Taxes
368 11/08/2019 Property Taxes
369 11/12/2019 Property Taxes
370 11/13/2019 Property Taxes
371 11/14/2019 Property Taxes
372 11/15/2019 Property Taxes
373 11/18/2019 Property Taxes
374 11/19/2019 Property Taxes
375 11/20/2019 Property Taxes
376 11/21/2019 Property Taxes
377 11/22/2019 Property Taxes
378 11/25/2019 Property Taxes
379 11/26/2019 Property Taxes
380 11/27/2019 Property Taxes
(8,724.42)
(866.20)
(2,033.58)
(3,742.83)
(1,461.62)
(1,745.61)
(3,184.72)
(810.70)
(3,766.35)
(2,021.15)
(834.34)
(471.21)
(1,934.66)
(4,889.40)
(1,087.78)
(99.53)
(2,049.66)
(2,025.74)
(720.22)
(9,590.62)
(11,624.20)
(15,367.03)
(16,828.65)
(18,574.26)
(21,758.98)
(22,569.68)
(26,336.03)
(28,357.18)
(29,191.52)
(29,662.73)
(31,597.39)
(36,486.79)
(37,574.57)
(37,674.10)
(39,723.76)
(41,749.50)
(42,469.72)
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
GL
Account: 533-40000-000-000
Property Taxes Totals:
(33,745.30) (42,469.72) **
(682,441.00) Budgeted
(639,971.28) Remaining 6 % Used
Account: 533-40002-000-000 Property Taxes/Delinquent
363 11/01/2019 Property Taxes
366 11/06/2019 Property Taxes
374 11/19/2019 Property Taxes
377 11/22/2019 Property Taxes
380 11/27/2019 Property Taxes
839.78
(130.88)
(175.84)
(2.11)
10.33
(266.72)
708.90
533.06
530.95
541.28
274.56
GL
GL
GL
GL
GL
Account: 533-40002-000-000
Property Taxes/Delinquent Totals:
(565.22) 274.56 **
(1,000.00) Budgeted
(1,274.56) Remaining -27 % Used
Account: 533-40015-000-000 Property Taxes/P & I
363 11/01/2019 Property Taxes
366 11/06/2019 Property Taxes
374 11/19/2019 Property Taxes
380 11/27/2019 Property Taxes
(42.80)
(28.80) (71.60)
(10.66) (82.26)
(.40) (82.66)
(58.50) (141.16)
GL
GL
GL
GL
Account: 533-40015-000-000
Property Taxes/P & I Totals:
(98.36) (141.16) **
(2,000.00) Budgeted
(1,858.84) Remaining 7 % Used
107 of 140
glpdatb2 skrolczyk
16:38 12/09/19
Fund: 533 MUD 1 I&S Consolidated
JE JE JE
Number Date Description
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: Revenues
Period Ending: 11/2019
Beginning
Balance
JE Detail
Description/Comment
Program:
Page 51
December 16, 2019 Regular Meeting Agenda Packet
Transaction Transaction Vendor_Name
Detail Detail
(SUBTOTAL)
Check Source
Number
Department Totals:
(114,563.00) Budgeted
(44,990.68) Monthly Total
(93,733.38) Remaining
18 % Used
(1,023,008.00) Budgeted
108 of 140
(63,469.79) **
(959,538.21) Remaining 6 % Used
Account:
533-49011-000-000 Interest Income
348 11/30/2019 Bank Interest- November (136.86)
(166.99)
(303.85)
GL
Account:
533-49011-000-000 Interest Income Totals:
(166.99)
(303.85)
**
(5,000.00) Budgeted (4,696.15) Remaining 6
% 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
346 11/15/2019 TexPool Transfers November TexPool O&M to I&S- PID Debt (10,414.81)
(10,414.81)
(20,829.62)
GL
Account:
533-49141-000-000 Interfund Trans In -PID Surchg Totals:
(10,414.81)
(20,829.62)
**
Department Totals:
(114,563.00) Budgeted
(44,990.68) Monthly Total
(93,733.38) Remaining
18 % Used
(1,023,008.00) Budgeted
108 of 140
(63,469.79) **
(959,538.21) Remaining 6 % Used
glpdatb2 skrolczyk
16:38 12/09/19
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: 11/2019
JE Detail Beginning
Balance
Description/Comment
Program:
Page 52
December 16, 2019 Regular Meeting Agenda Packet
Transaction Transaction Vendor_Name
Detail Detail
(SUBTOTAL)
Check Source
Number
Department 51 Totals:
Fund 533 Totals:
755,000.00 Budgeted
.00 Monthly Total
(44,990.68) Monthly Total
755,000.00 Remaining
0 % Used
.00 **
1,023,208.00 Budgeted 1,023,208.00 Remaining 0 % Used
(63,469.79)
200.00 Budgeted 63,669.79 Remaining ##########
109 of 140
Account: 533-70005-051-000
Paying 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
**
266,058.00 Budgeted 266,058.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
.00
**
Department 51 Totals:
Fund 533 Totals:
755,000.00 Budgeted
.00 Monthly Total
(44,990.68) Monthly Total
755,000.00 Remaining
0 % Used
.00 **
1,023,208.00 Budgeted 1,023,208.00 Remaining 0 % Used
(63,469.79)
200.00 Budgeted 63,669.79 Remaining ##########
109 of 140
December 16, 2019 Regular Meeting Agenda Packet
TROPHY CLUB MUD #1 - REVENUE BOND I&S (WWTP)
BALANCE SHEET
NOVEMBER 2019
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
534
REVENUE BOND
I&S WWTP
133,554
TOTAL ASSETS 133,554
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
110 of 140
24,518
109,037
133,554
133,554
glbase_tbam skrolczyk
16:37 12/09/19
Fund: 534 2015 Revenue Bond I&S
Account
534-49011-000-000
534-49143-000-000
Subtotal:
Program number:
Department number: Revenues
Revenues
Description
Interest Income
Interfund Transfer In -WW Sales
Subtotal
Department:
Adopted
Budget
2,500.00-
598,638.00-
601,138.00-
601,138.00-
601,138.00-
601,138.00 -
Trophy Club MUD No.1
Budget Summary with Amendment
Revenues
Period Ending: 11/2019
Amended Total
Budget Encumb.
2,500.00-
598,638.00-
601,138.00-
601,138.00-
601,138.00-
601,138.00-
111 of 140
Program:
Current YTD
Month Total
148.62- 193.89-
54,421.03- 108,842.66-
54,569.65- 109,036.55-
54,569.65- 109,036.55-
54,569.65- 109,036.55-
54,569.65- 109,036.55-
% of
Budget
Page 21
December 16, 2019 Regular Meeting Agenda Packet
Remaining
Budget
7.756 2,306.11-
18.182 489,795.34-
18.138 492,101.45-
18.138 492,101.45-
18.138 492,101.45-
18.138 492,101.45-
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 22
16:37 12/09/19 Budget Summary with Amendment
Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
534-70005-051-000 Rev Bond Paying Agent Fee 400.00 400.00 400.00
534-70040-051-000 Revenue Bond Interest Expense 208,238.00 208,238.00 208,238.00
534-70045-051-000 Revenue Bond Principal Expense 390,000.00 390,000.00 390,000.00
Subtotal: 598,638.00 598,638.00 598,638.00
Program number: 598,638.00 598,638.00 598,638.00
Department number: Administration 598,638.00 598,638.00 598,638.00
Expenditures Subtotal 598,638.00 598,638.00 598,638.00
Fund number: 534 2015 Revenue Bond I&S 2,500.00- 2,500.00- 54,569.65- 109,036.55- 4,361.462 106,536.55
112 of 140
glpdatb2 skrolczyk
16:38 12/09/19
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: 11/2019
Beginning
Balance
JE Detail
Description/Comment
Program:
Page 53
December 16, 2019 Regular Meeting Agenda Packet
Transaction Transaction Vendor_Name
Detail Detail
(SUBTOTAL)
Check Source
Number
Department Totals:
(598,638.00) Budgeted
(54,569.65) Monthly Total
(489,795.34) Remaining
18 % Used
(601,138.00) Budgeted
113 of 140
(109,036.55) **
(492,101.45) Remaining 18 % Used
Account:
534-49011-000-000 Interest Income
348 11/30/2019 Bank Interest- November (45.27)
(148.62)
(193.89)
GL
Account:
534-49011-000-000 Interest Income Totals:
(148.62)
(193.89)
**
(2,500.00) Budgeted (2,306.11) Remaining
8 %
Used
Account:
534-49143-000-000 Interfund Transfer In -WW Sales
346 11/15/2019 TexPool Transfers November TexPool O&M to Rev Bd WWTP I&S (54,421.63)
389 11/15/2019 Adjust TexPool Tnfr Dep JE346
(54,421.63)
.60
(108,843.26)
(108,842.66)
GL
GL
Account:
534-49143-000-000 Interfund Transfer In -WW Sales Totals:
(54,421.03)
(108,842.66)
**
Department Totals:
(598,638.00) Budgeted
(54,569.65) Monthly Total
(489,795.34) Remaining
18 % Used
(601,138.00) Budgeted
113 of 140
(109,036.55) **
(492,101.45) Remaining 18 % Used
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 54
16:38 12/09/19 Detailed Accounting Trial Balance
Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 534-70005-051-000 Rev Bond Paying Agent Fee
Account: 534-70005-051-000 Rev Bond Paying Agent Fee Totals:
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
O 6 Used
.00
.00
.00 .00 **
.00
O % Used
.00
.00 .00 **
Account: 534-70045-051-000 Revenue Bond Principal Expense
.00 .00
Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 **
Department 51 Totals:
390,000.00 Budgeted 390,000.00 Remaining
O 9 Used
.00 Monthly Total 598,638.00 Budgeted
.00 **
598,638.00 Remaining 0 % Used
Fund 534 Totals: (109,036.55)
(54,569.65) Monthly Total
(2,500.00) Budgeted 106,536.55 Remaining NNNNNNNNNN
114 of 140
December 16, 2019 Regular Meeting Agenda Packet
TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S
BALANCE SHEET
NOVEMBER 2019
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
` MUNICIPAL
UTILITY
DISTRICT
Na. 1
535
NSII FTW SWIFT
REVENUE BOND
I&S
55,132
TOTAL ASSETS 55,132
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES
TOTAL FUND BALANCE
4,967
50,165
55,132
TOTAL LIABILITIES AND FUND BALANCE 55,132
115 of 140
glbase_tbam skrolczyk
16:37 12/09/19
Fund: 535 2016 Rev Bond I&S-SWIFT
Account
535-49011-000-000
535-49142-000-000
Subtotal:
Program number:
Department number: Revenues
Revenues
Description
Interest Income
Interfund Tran In -Water Sales
Subtotal
Department:
Adopted
Budget
1,000.00-
275,525.00-
276,525.00-
276,525.00-
276,525.00-
276,525.00 -
Trophy Club MUD No.1
Budget Summary with Amendment
Revenues
Period Ending: 11/2019
Amended Total
Budget Encumb.
1,000.00-
275,525.00-
276,525.00-
276,525.00-
276,525.00-
276,525.00-
116 of 140
Program:
Current YTD
Month Total
59.67- 70.21-
25,047.72- 50,095.44-
25,107.39- 50,165.65-
25,107.39- 50,165.65-
25,107.39- 50,165.65-
25,107.39- 50,165.65-
% of
Budget
Page 23
December 16, 2019 Regular Meeting Agenda Packet
Remaining
Budget
7.021 929.79-
18.182 225,429.56-
18.141 226,359.35-
18.141 226,359.35-
18.141 226,359.35-
18.141 226,359.35-
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 24
16:37 12/09/19 Budget Summary with Amendment
Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
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 Bond Interest Expense 386,811.00 386,811.00
535-70045-051-000 Revenue Bond Principal Expense 215,000.00 215,000.00
Subtotal:
Program number:
Department number: Administration
Expenditures
Subtotal
Fund number: 535 2016 Rev Bond I&S-SWIFT
602,611.00 602,611.00
602,611.00 602,611.00
602,611.00
602,611.00
326,086.00
602,611.00
602,611.00
326,086.00
117 of 140
25,107.39-
50,165.65- -15.384
800.00
386,811.00
215,000.00
602,611.00
602,611.00
602,611.00
602,611.00
376,251.65
glpdatb2 skrolczyk
16:38 12/09/19
Fund: 535 2016 Rev Bond I&S-SWIFT
JE JE JE
Number Date Description
Trophy Club MUD No.1
Detailed Accounting Trial Balance
Department: Revenues
Period Ending: 11/2019
Beginning
Balance
JE Detail
Description/Comment
Program:
Page 55
December 16, 2019 Regular Meeting Agenda Packet
Transaction Transaction Vendor_Name
Detail Detail
(SUBTOTAL)
Check Source
Number
Department Totals:
(275,525.00) Budgeted
(25,107.39) Monthly Total
(225,429.56) Remaining
18 % Used
(276,525.00) Budgeted
118 of 140
(50,165.65) **
(226,359.35) Remaining 18 % Used
Account:
535-49011-000-000 Interest Income
348 11/30/2019 Bank Interest- November (10.54)
(59.67)
(70.21)
GL
Account:
535-49011-000-000 Interest Income Totals:
(59.67)
(70.21)
**
(1,000.00) Budgeted (929.79) Remaining 7
% Used
Account:
535-49142-000-000 Interfund Tran In -Water Sales
346 11/15/2019 TexPool Transfers November TexPool O&M to 16Swift Rev I&S (25,047.72)
(25,047.72)
(50,095.44)
GL
Account:
535-49142-000-000 Interfund Tran In -Water Sales Totals:
(25,047.72)
(50,095.44)
**
Department Totals:
(275,525.00) Budgeted
(25,107.39) Monthly Total
(225,429.56) Remaining
18 % Used
(276,525.00) Budgeted
118 of 140
(50,165.65) **
(226,359.35) Remaining 18 % Used
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 56
16:38 12/09/19 Detailed Accounting Trial Balance
Fund: 535 2016 Rev Bond IBS -SWIFT Department: 51 Administration Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 535-70005-051-000 Rev Bond Paying Agent Fee
Account: 535-70005-051-000 Rev Bond Paying Agent Fee Totals:
800.00 Budgeted 800.00 Remaining
Account: 535-70040-051-000 Revenue Bond Interest Expense
Account: 535-70040-051-000 Revenue Bond Interest Expense Totals:
386,811.00 Budgeted 386,811.00 Remaining
O 6 Used
.00
.00
.00 .00 **
.00
O % Used
.00
.00 .00 **
Account: 535-70045-051-000 Revenue Bond Principal Expense
.00 .00
Account: 535-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 **
Department 51 Totals:
215,000.00 Budgeted 215,000.00 Remaining
O % Used
.00 Monthly Total 602,611.00 Budgeted
.00 **
602,611.00 Remaining 0 % Used
Fund 535 Totals: (50,165.65)
(25,107.39) Monthly Total
326,086.00 Budgeted 376,251.65 Remaining -15 % Used
119 of 140
December 16, 2019 Regular Meeting Agenda Packet
TROPHY CLUB MUD #1 - REVENUE BOND I&S
WATER & WASTEWATER SYSTEM 2019
BALANCE SHEET
NOVEMBER 2019
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
i
No. 1
MUNICIPAL
UTILITY
DISTRICT
536
REVENUE BOND
SERIES 2019 I&S
59,536
TOTAL ASSETS 59,536
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES 59,536
TOTAL FUND BALANCE 59,536
TOTAL LIABILITIES AND FUND BALANCE 59,536
120 of 140
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 25
16:37 12/09/19 Budget Summary with Amendment
Fund: 536 2019 Rev Bond I&S- W&WW System Department: Revenues Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
Account
536-49011-000-000
536-49142-000-000
536-49143-000-000
Description
Interest Income
Interfund Tran In -Water Sales
Interfund Transfer In -WW Sales
62.71- 65.69-
22,896.02- 45,792.04-
6,839.07- 13,678.14-
65.69
45,792.04
13,678.14
Subtotal:
29,797.80- 59,535.87 -
59,535.87
Program number: 29,797.80 -
Department number: Revenues
Revenues
Subtotal
Fund number: 536 2019 Rev Bond I&S- W&WW System
End of Report *********
121 of 140
59,535.87- 59,535.87
29,797.80- 59,535.87-
29,797.80- 59,535.87-
29,797.80- 59,535.87-
59,535.87
59,535.87
59,535.87
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 57
16:38 12/09/19 Detailed Accounting Trial Balance
Fund: 536 2019 Rev Bond I&S- W&WW System Department: Revenues Program: December 16, 2019 Regular Meeting Agenda Packet
Period Ending: 11/2019
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
348 11/30/2019 Bank Interest- November (2.98)
Account: 536-49011-000-000
Interest Income Totals:
.00 Budgeted
65.69 Remaining 0 % Used
Account: 536-49142-000-000 Interfund Tran In -Water Sales
346 11/15/2019 TexPool Transfers November TexPool O&M to 19 W&WW Rev I&S
(22,896.02)
Account: 536-49142-000-000 Interfund Tran In -Water Sales Totals:
.00 Budgeted 45,792.04 Remaining
Account: 536-49143-000-000 Interfund Transfer In -WW Sales
346 11/15/2019 TexPool Transfers November TexPool O&M to 19 W&WW Rev I&S
Account: 536-49143-000-000 Interfund Transfer In -WW Sales Totals:
.00 Budgeted 13,678.14 Remaining
(62.71) (65.69) GL
(62.71)
(65.69) **
(22,896.02) (45,792.04) GL
(22,896.02) (45,792.04) **
0 % Used
(6,839.07) (6,839.07) (13,678.14) GL
0 % Used
(6,839.07) (13,678.14) **
Department Totals: (59,535.87) **
(29,797.80) Monthly Total .00 Budgeted
59,535.87 Remaining 0 % Used
Fund 536 Totals: (59,535.87)
(29,797.80) Monthly Total .00 Budgeted
59,535.87 Remaining 0 % Used
Grand Totals: (283,888.62) ****
100,292.99 Monthly Total
******* End of Report *********
(200,904.00) Budgeted 82,984.62 Remaining 141 % Used
122 of 140
December 16, 2019 Regular Meeting Agenda Packet
BUDGET VARIANCE REPORT
FUND: 122 - Fire O&M
FINANCIALS MONTH: November 2019
REVENUE VARIANCE: 8.3%
EXPENSE VARIANCE: 26.6%
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 $60,041 $75,564 6.22% 10/2019 Property Taxes/MUD Fire
122-40011 Property Taxes/Fire - Delinquent $915 -$453 10/2019 Delinquent Fire Taxes
collected/paid out
122-40020 Property Taxes/Fire P&I $1,080 $1,148 10/2019 Fire Taxes Penalties & Interest
collected
FIRE EXPENSES
123 of 140
BUDGET VARIANCE
FUND:
FINANCIALS MONTH:
REVENUE VARIANCE:
EXPENSE VARIANCE:
NOTE:
ACCOUNT
REVENUE
135-40000-000
135-40002-000
EXPENSES
WATER
135-50016-010
135-65010-010
135-69281-010
WASTEWATER
135-50016-020
135-55081-020
1135-65010-020
1135-65031-020
BOARD OF DIRECTORS
1135-60070-026
(ADMINISTRATION
1135-50016-030
135-55030-030
1
1 Non -Departmental
1135-55055-039
December 16, 2019 Regular Meeting Agenda Packet
REPORT
135 - MUD 1 O&M
November 2019
8.3%
26.6%
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
Property Taxes 134,871 6,665 8,389 6.22% 10/2019 Property Taxes
Property Taxes/Delinquent $300 $104 -$51 -17.13% 10/2019 Delinquent Tax Shortage/Paid Out
Longevity
Uniforms
Water Tank Inspection Contract
Longevity
Maintenance & Repairs Collections
Uniforms
Chemicals Collections
Dues & Memberships
Longevity
Software & Support
Auditing
$3,920 $5,083 $5,083 129.66% 11/2019 Annual Longevity- Moved Position
$5,190 $909 $1,729 33.32% 10/2019 Pants, Shoes- New Hires
$120,000 $57,933 $57,933 48.28% 11/2019 Tank Contract
$8,035 $6,873 $6,873 85.53% 11/2019 Annual Longevity
$10,000 $6,352 $14,277 142.77% 11/2019 Avenue Twenty Lift Station Repair;
Well Repair; LS 4 Repair
$5,495 $2,112 $3,004 54.67% 11/2019 Pants, Shoes- New Hires
$17,500 $4,994 $4,994 28.54% 11/2019 Chemicals
$750 $675 $675 90.00% 11/2019 Board Annual Membership Dues
$2,208 $2,208 $2,208 99.98% 11/2019 Annual Longevity
$134,681 $2,672 $68,197 50.64% 10/2019 Annual IT Contract with M3 Networks
$33,800 $10,150 $15,150 44.82% 11/2019 Annual Audit
124 of 140
December 16, 2019 Regular Meeting Agenda Packet
Trophy Club Municipal Utility District No. 1
Date: 12/16/2019
To: Board of Directors
From: John Robert Carman
Subject: General Manager's Report
Regulatory Updates
Sanitary Sewer Overflows (SSO) — No SSO's have occurred since the last regular Board meeting
Breaks and Leaks — One leak occurred at the intersection of Trophy Wood and Inverness occurred
since the last regular Board. This leak was small and difficult to locate (in the first photo below,
you can see water coming from a hairline crack). To access the leak we had to remove a section
of the road. We employed a contractor for cutting and replacing the concrete, which was
completed the day of the repair.
Other Regulatory Updates — An updated Lead and Copper Rule has been published by EPA and
the comment period has begun. Our national professional associations, such as the American
Water Works Association, have participated in the rule development and will submit comments
to the rule changes during the comment period. While we don't anticipate commenting directly,
this rule change will create additional compliance costs for the District.
125 of 140
December 16, 2019 Regular Meeting Agenda Packet
Capital Improvement Projects
Interconnecting Pipeline Project Phase 2 — Staff has been working with the easement acquisition
team and the attorney to move the process forward. A check has been cut for easement parcel
1. Parcels 2 and 6 are being prepared for condemnation.
WWTP — We are still working through the special inspector's report regarding the crane and the
contractor's response to the report. We did meet on site with the contractor to go over three
specific warranty items.
High Service Pump Station Improvements — The startup on the new pump is now scheduled for
December 17th, 2019.
System Repairs
In -plant Water System - The in -plant water system at the wastewater treatment plant was
redesigned by Halff and Associates and installed by Rey Mar construction. The system has been
gone through start-up and it performed as we hoped. This system allows us to use the high
quality plant effluent for several in -plant water needs such as spraying down the fine screens,
washing foam from basin walls and cleaning the belt press.
126 of 140
December 16, 2019 Regular Meeting Agenda Packet
Well Number 1 Emergency Repair Update — Well number 1 electrical control panel repairs are
underway. As previously reported nature of the leak in the pump discharge piping gave rise to
concerns that the well casing itself had been damaged. A video inspection was authorized and
the good news is that no damage to the well casing was found. At this point the total repair
estimate for this emergency repair is $ 63,816.00.
127 of 140
J
December 16, 2019 Regular Meeting Agenda Packet
Monthly Water Operations Report
Water Billed
FY October November December January February March April May June
2010 39,794 39,713 29,547 30,305 25,328 23,279 41,646 53,439 102,921
2011 70,502 50,909 44,365 35,983 27,845 55,972 69,165 61,467 99,326
2012 85,869 53,571 40,815 30,616 31,665 35,263 47,194 84,905 114,104
2013 85,488 75,251 48,527 39,601 34,450 43,137 56,947 76,542 85,312
2014 82,660 48,813 34,482 39,767 37,085 54,794 66,337 84,384 99,240
2015 90,994 58,986 49,607 36,162 38,776 30,566 46,543 39,576 60,731
2016 108,951 41,936 39,028 39,622 44,551 49,498 55,181 50,827 65,390
2017 74,785 68,638 38,580 33,028 38,380 60,841 56,683 86,794 98,864
2018 83,228 69,099 48,144 34,592 40,658 43,411 60,079 89,802 118,899
2019 47,193 41,933 36,244 34,604 33,740 40,421 55,970 42,773 70,747
July
89,760
117,707
137,174
110,072
92,913
100,622
115,687
95,355
126,588
96,174
August September
128,687 82,331
170,464 123,692
144,573 108,622
130,945 114,497
113,135 110,873
139,441 123,886
119,611 98,945
104,303 99,541
125,531 73,735
131,472 114,784
Total Year
686,750
927,397
914,371
900,769
864,483
815,890
829,227
855,792
913,766
746,055
2020 1 102,150 1 40,988 1 1 1 1 1 1 1 1 1 1 1 1 143,138
140,000
120,000
100,000
80,000
60,000
40,000
20,000
0
WATER BILLED IN THOUSANDS OF GALLONS
L
October November December January February March
April May June
September
- 2016
- 2017
- 2018
- 2019
- 2020
Water Pumped
FY October November December January February March April May June July August September Total Year
2010 40,803 41,600 32,700 31,400 30,145 27,240 43,400 62,646 113,049 94,950 131,650 76,159 725,742
2011 70,502 50,993 44,220 33,789 36,053 54,775 71,306 63,500 116,350 152,002 169,621 117,190 980,301
2012 83,750 54,245 41,650 34,740 31,581 46,519 62,649 100,402 110,324 153,813 139,005 123,045 981,723
2013 85,966 77,758 55,110 39,283 37,867 56,743 60,969 87,168 96,602 119,414 145,988 120,342 983,210
2014 81,909 51,769 39,769 48,758 42,395 61,100 71,283 96,481 95,206 110,173 123,369 115,607 937,819
2015 106,251 67,825 58,659 45,691 39,675 35,752 56,704 48,637 72,934 117,302 143,413 142,394 935,237
2016 106,731 52,616 43,708 46,945 50,721 55,178 60,434 55,562 68,138 112,533 128,963 104,664 886,193
2017 82,677 77,937 43,792 43,207 43,024 69,549 65,723 94,452 103,867 101,184 114,872 109,769 950,053
2018 91,439 78,282 55,745 40,796 40,750 51,711 67,217 97,980 124,109 155,354 144,015 85,946 1,033,344
2019 60,576 53,119 45,651 45,552 39,014 43,048 61,238 48,787 79,167 102,887 144,299 130,752 854,090
2020 1 112,971 1 48,627 1 1 1 1 1 1 161,5981
180,000
160,000
140,000
120,000
100,000
80,000
60,000
40,000
20,000
WATER PUMPED IN THOUSANDS OF GALLONS
October November December January February March
April May June July August September
-2016
-2017
-2018
2019
-2020
FY
2014 Total
2015 Total
2016 Total
2017 Total
2017 MUD
2017 PID
2018 Total
2018 MUD
2018 PID
2019 Total
2019 MUD
2019 PID
Active Connections
October 1 November December January February March April May June July August September
4139 1 4157 4173 4206 4209 4219 4240 4268 4280 4308 4333 4339
4353 1 4363 4377 4404 4413 4429 4443 4459 4478 4486 4498 4517
4531 1 4538 4556 4568 4593 4604 4607 4616 4622 4627 4632 4636
4644 4647 4661 4657 4663 4666 4670 4676 4685 4690 4696 4700
3208 3210 3220 3216 3221 3224 3228 3234 3242 3247 3252 3256
1436 1437 1441 1441 1442 1442 1442 1442 1443 1443 1444 1444
4701 4706 4712 4716 4720 4724 4724 4728 4732 4735 4736 4738
3257 3262 3268 3272 3276 3280 3280 3284 3288 3291 3292 3294
1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444
4741 4743 4745 4753 4753 4758 4761 4762 4768 4770 4773 4782
3297 3299 3301 3309 3309 3314 3317 3318 3324 3326 3329 3338
1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444
2020 Total
2020 MUD
2020 PID
4795
3351
4796
3352
1444
1444
128 of 140
Date
4 -Nov
7 -Nov
11 -Nov
14 -Nov
18 -Nov
21 -Nov
25 -Nov
26 -Nov
IReport
1 Ammonia -N
Influent Effluent
52.5 0.88
32.0 0.22
47.5 0.20
57.0 0.20
51.0 0.20
55.0 0.20
38.8 0.20
49.5 0.20
November 2019 Results
Removal
98.3%
99.3%
CBOD5
Influent Effluent
370 2.0
247 2.0
Removal 1
99.5%
99.2%
December 16, 2019 Regular Meeting Agenda Packet
TSS
Influent Effluent
356 1.0
172 1.0
99.6% 319 2.0 99.4% 194 1.0
99.6% 252 2.0 99.2% 225 1.0
99.6% 225 2.0 99.1% 250 1.0
99.6% 247 2.0 99.2% 292 1.0
99.5% 273 2.0 99.3% 245 1.0
99.6% 218 2.0 99.1% 251 1.0
Removal
99.7
99.4%
99.5%
99.6%
99.6%
99.7%
99.6%
99.6%
Ammonia -N CBOD5 TSS
0.29 1 99.4% 2.0 1 99.2% 1.0 1 99.6%
129 of 140
3.50
3.00
2.50
2.00
1.50
1.00
0.50
0.00
6.0
5.0
4.0
3.0
2.0
1.0
0.0
December 16, 2019 Regular Meeting Agenda Packet
Ammonia Nitrogen
Permit Limit 3 (Jan - March)
0.21 0.2
Permit Limit -1 from April - August
0.481 0.498
0.309 J • 1
0.316• 0.215 0.201 0.224 0.2
Permit Limit 3 (Sept. - Dec.)
0.271 0.288
■
Dec -18
Jan -19 Feb -19
Mar -19 Apr -19
May -19 Jun -19
Jul -19 Aug -19
Max mg/L = .20 Average mg/L =.20
Carbonaceous Biochemical Demand (CBOD5)
Sep -19 Oct -19
Nov -19 Dec -19
2.0 2.0 2.0 2.0
2.13
2.0
2.04 2.0
2.00 2.0 2.00 2.0
Permit Limit 5
2.00 2.0 2.00 2.0
2.00 2.0 2.00 2.0
2.00 2.0 2.00 2.0
11 11 IIIIIIIIIIIIIIIIIII
Dec -18
Jan -19 Feb -19
Mar -19 Apr -19
May -19 Jun -19 Jul -19
Max mg/L = 2.0 Average mg/L = 2.0
130 of 140
Aug -19
Sep -19 Oct -19
Nov -19 Dec -19
- Nh3Ave
- Nh3
Permit Limit
Bod
Bod Aver
Permit Limit
14.0
12.0
10.0
8.0
6.0
4.0
2.0
0.0
30.0
25.0
20.0
15.0
10.0
5.0
0.0
December 16, 2019 Regular Meeting Agenda Packet
Total Suspended Solids (TSS)
Permit Limit 12
1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.00 1.0
-. .. .. -. -. -. -. -. - -
Dec -18
Jan -19 Feb -19
Mar -19 Apr -19
May -19 Jun -19
Jul -19 Aug -19
Max mg/L = 1.0 Average mg/L = 1.0
Nitrate - Nitrogen
Sep -19 Oct -19
Nov -19 Dec -19
Permit Limit 24
5.8 5.80 5.5 5.30 5.1 5.7 5.9 5.1 4.9 5.4 4.9
4.6 5.19 4.97 4.69 4.6 4.68 4.74 4.86 4.73 4.8
1 1 1111 , 1 3.5
, 1 1 1 1 1 1 3.7
1 1 1 1 1 1 1 1
Dec -18
Jan -19 Feb -19
Mar -19 Apr -19
May -19 Jun -19 Jul -19
Max mg/L = 5.8 Average = 4.6
131 of 140
Aug -19
Sep -19 Oct -19
Nov -19 Dec -19
T55
111-55 Ave
Permit Limit
N -N
N -N Aver
Permit Limit
10
9
8
7
6
5
4
3
2
1
0
10.0
9.0
8.0
7.0
6.0
5.0
4.0
3.0
2.0
1.0
0.0
December 16, 2019 Regular Meeting Agenda Packet
E. Coli
Permit Limit 126
1.0 1.0 1.0 1.0
1.0 1.0
1.0 1.0 1.0 1.0
1.0 1.0 1.0 1.0
1.0 1.0 1.0 1.0
1.0 1.0 1.0 1.0
1.0 1.0
Dec -18
Jan -19 Feb -19
Mar -19 Apr -19
May -19 Jun -19
Jul -19 Aug -19
Max mg/L = 1.0 Average mg/L = 1.0
Potential for Hydrogen (pH)
Sep -19 Oct -19
Nov -19 Dec -19
Permit Limit Hi r 9
7.897.59
.89 8. 6
5 -.627.48 7.357.457.40 7.26 7.81
61 7.42 '.45 7.44 7.327.417.37 7.197.347.27 7.28
5
6.987.237.11
6.886.73
6.58
6.37
7.80
7.49
7.09 7.09
6.69
Dec -18
Jan -19
Feb -19
Mar -19 Apr -19
May -19 Jun -19
Jul -19
Aug -19 Sep -19
Max mg/L = 7.45 Min mg/L = 7.42 Average mg/L = 7.436
132 of 140
Oct -19
Nov -19
Dec -19
• E. Coli
• E. Coli Ave.
• Permit Limit
�pH Min
pH Max
pH Aver
Permit Limit Low
-Permit Limit
High
10
9
8
7
6
5
4
3
2
1
0
December 16, 2019 Regular Meeting Agenda Packet
Dissolved Oxygen (DO)
Permit Limit Max 9
7.77 7.5
7.5
mq 7.5
11
7.63 7.8 7.56 7.7 7.48 7.6 7.33 7.6
1 1 1 'It
Limit MI 1
22 7.5
Ul
7.37 7.6
7 .7 7.92
7.6 7.6
.11
Dec -18
Jan -19 Feb -19
Mar -19 Apr -19
May -19 Jun -19 Jul -19 Aug 19
Max mg/L = 8.1 Average mg/L = 7.5
133 of 140
Sep -19 Oct -19
Nov -19 Dec -19
- DO
- DO Aver
- Permit Limit Min.
- Permit Limit Max
Fiscal Year End 2019 Summary
December 16, 2019 Regular Meeting Agenda Packet
180,000,000
160,000,000
140,000,000
120,000,000
100,000,000
80,000,000
60,000,000
Water Consumption Adopted Budget vs Actual
105,503,890
62,188,370
46,469,904
69,150,547
54,829,261 61,428,276
44,578,015
40,552,473
40,000,000 \ 55,970,000
47,193,000 \
41 933,000 40,421,000 42,773,000
36,244,000
20,000,000 34,604,000 33,740,000
89,372,80
157,606,000
140,655,764
23,125,257
122,753,154
114,100,000
70,747,000
O
—0—Budget
—0—Actual
Oct Nov Dec Jan Feb Mar Apr May Jun Jul
35,597,000
Aug Sep
1,000,000,000
950,000,000
900,000,000
850,000,000
800,000,000
750,000,000
700,000,000
Adopted Budget Water Consumption Vs Actual Water Consumption
960,607,716
810,928,000
1
Total Consumption
• Budgeted Total Consumption
• Actual Total Consumption
Adopted Budget vs YTD Actuals Revenues & Expenses
$8,709,093
$10,271,365
$10,613,202
YTD Expenses YTD Revenues Adopted Budget Expenses Adopted Budget Revenues
Presented by:
Finance Department
1,000,000
900,000
800,000
600,000
500,000 406,145
359,299 345,355
400,000 324,297
Water Revenue Adopted Budget vs Actual
906,180 848,476
300,000
325,801
200,000 2701765 296,662
100,000
0
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
—0—Budget
Revenue
—0—Actual Revenue
57,000,000
56,000,000
55,000,000
54,000,000
53,000,000
52,000,000
51,000,000
50
Adopted Budget Total Water Revenue Vs Actual Total Water Revenue
56,599,484
r
05,243,386
53,585,990
1
Total Water Revenue
53,265,538
• Budgeted Total Revenue
• Actual Total Revenue
• Net Budget Total Revenue
Minus Budgeted Expenses
• Net Actual Total Revenue
Minus Actual Expenses
$2,500
0%
$179,748
2%
- YTD Expense By Departments
$4,590,936
53%
• YTD Expense- Water
• YTD Expense- WW
YTD Expense- Admin
• 9TD Expense- BOD
• YTD Expense- Non Dept
134 of 140
December 16, 2019
Gasb 54 Balances 9/30/2019
'und 135 General Fund
Project Non Spendable Year adopted Original Assigned Ammended Assigned
Assets not in spendable form (Prepaids)
Reserve for Budget deficits
18,486.00
Capital Projects Fund 135:
Water
Pump VFD for Water Plant (Carry Forward FY 2017) 2017 $370,000.00 $266,613.00 I 1592,000.56
Beacon Meter Software 2018 $11,012.00 $0.00 111,012.00
Indian Creek and Phoenix (Town) 2018 $410,000.00 $76,258.13 $218,192.37
Sundance Ct/Meadowbrook Ln (Town) 2018 $169,000.00 144,859.00 $195,609.00
Pump Discharge Head 2018 150,000.00 10.00 150,00100
Carnoustie/Creek 2019 $275,000.00 -141,403.02 $233,596.98
Valve Replacement 2018 $50,000.00 1403.02 150,403.02
Fencing 2019 1100,000.00 55,490.00 1105,490.00
On Call Truck 2019 128,000.00 10.00 128,000.00
Committed
Carry Over
Carry Over
December 16, 2019 Regular Meeting Agenda Packet
Fund 122 Fire Dept Fund 137 GASB 34 Total Total
JE Transaction
Non Spendable Assigned Non Spendable New Assigned Prior Assigned Remaining Spent FY 19 9/30/2019
Carry Over* added 41000 for engineering/survey
Carry Over
Carry Over
DONE* excess funds of 56159.13 partially moved to indian creek and valve replacements l
DONE* added 403.02 for excess cost
DONE
DONE
Wastewater
Lift Station 1 Relocation Study 2018 $10,000.00 $0.00 $9,572.50 Carry Over
Legal/WWTP Contractor Litigation 2018 $175,000.00 $0.00 $154,886.51 Carry Over
LS Upgrades (Lights, Control Panels, Quick Connects) 2019 $75,000.00 $0.00 $75,000.00 Carry Over
Spare Part Inventory 2019 $50,00000 $0.00 $50,000.00 DONE
1581 Engineering 2019 $30,000.00 $0.00 $30,000.00 Carry Over
In -Plant Water System 2019 $100,000 00 $47,222.00 $147,222 00 Carry Over
Back Up Generator (WW) 2019 $75,000.00 $0.00 $]5,000.00
Adm in
GIS Mapping Development 2019 $30,00000 $8,247.00 $38,24700
CMMS (Asset Management) Development 2019 $35,000.00 -110,638.16 $24,361.84
Board Room Audio and Video Improvements 2019 $85,00000 -$85,000.00 $0.00
Security Improvements Phase 2 WWTP and Water Plant 2019 $65,000.00 12391.16 167,391.16
Point to Point Communication/Town Project 2019 $35,00000 $0.00 =I $35,00000
Budget Software 2019 130,000.00
GASB 34 Fund 137:
GASB Replacement -Town Elevated Tank
GASB Replacement -Water
GASB Replacement -Sewer
GASB Replacement -Fire Truck
Total
$8,486.00
GASB Replacement -Town Elevated Tank 137-32100-000
GASB Replacement -Water 137-32111-000
GASB Replacement -Sewer 137-32113-000
GASB Replacement -Fire Truck 137-32112-000
Assigned 135-31100-000
Unassigned 135-31110-000
Carry Over • 6000 for first year webhost & 2247 for NCTCOG aerial photos
DONE * Excess funds of 29700 partially moved to GIS 1
Postponed to FY 20
DONE* added 2391.16 for fire department expense
Carry Over
19,887.00 $39,887.00 DONE
$2,230,071.94
135 of 140
$0.00
145,000.00
$30,000.00
130,000.00
181,420.00
10.00 $186,420.00
$69,707.93 $ 1522292.63) x92.63)
$11,012.00 $
532,749.25 $ (185,443.12) 85,443.12)
$138,086.20 $ (57,522.80) (57,522.80)
$50,000.00 $ -
514,756.11 $ (218,840.87) (233,596.98)
$0.00 $ (50,403.02) (50,403.02)
$0.00 $ (105,490.00) (105,490.00)
1394.00 $ (27,606.00) 8,000.00)
$ (2,349.58) ,349.58)
1117,386.22 $ (37,500.29) 37,500.29)
$37,647.00 $ (37,353.00) (37,353.00)
$6,753.20 $ (43,246.80) (50,000.00)
530,000.00 $ -
1132,911.60 $ (14,310.40) (14,310.40)
$1.00 $ (74,999.00) (75,000.00)
$0.00 $ (38,247.00) (38,247.00)
519,061.84 $ (5,300.00) (24,361.84)
10.00 $ - -
10.00 $ (67,391.16)
$0.00 $ (39,887.00)
1180,000.00 1225,000.00
-1150,000.00 $120,000.00 50.00
567,804.58 197,804.58
$228,621.39 $310,041.39
-5150,000.06 5596,425.97 51,335,535.24 -51,528,182.67
-$1,569,148.82
Protect
December 16, 2019 Regular Meeting Agenda Packet
Gasb 54 Balances 10/1/2019
Fund 135 Ge',era) Fund Fund 122 ,ire Dept Fund 137 GASB 34 Total lE
Non Spendable Year Adopted Original Assigned Carry Over Assigned Ammended Total Assigned Committed Non Spendable Assigned Non Spendable Assigned Transaction
Assets not in spendable form (Prepaids) 58,486.00
Reserve for Budget deficits
Capital Projects Fund 135:
Water
Pump VFD for Water Plant 2017 5370,000.00 569,707.93 50.00 569,707.93
Pump Discharge Head 2018 550,000.00 550,000.00 50.00 550,000.00
Quick Connects Fire Hydrants 2020 55,000.00 55,000.00 55,000.00
Beacon Meter Software 2018 511,012.00 511,012.00 59,000.00
Indian Creek and Phoenix (Town) 2018 5410,000.00 532,749.25 50.00
Sundance Ct/Meadowbrook Ln (Town) 2018 5169,000.00 5138,086.20 50.00
Valve Replacement 2020 550,000.00 550,000.00 550,000.00
Water Line Replacement 2020 5500,000.00 5500,000.00 5500,000.00
Fencing 2020 510,000.00 510,000.00 510,000.00
Fleet Replacement 2020 $41,000.00 541,000.00 541,000.00
20' Line Stops and Gate Valves 2020 569,875.00 569,875.00 569,875.00
Carry Over
Carry Over
520,012.00 Carry Over
532,749.25 Carry Over
5138,086.20 Carry Over
Wastewater
Lift Station 1 Relocation Study 2018 510,000.00 57,222.92 50.00
1egal/WWfP 2018 5175,000.00 5117,386.22 5150,000.00
L5 Upgrades (Lights, Control Pannels, Quick Connects) 2019 575,000.00 $37,647.00 550,000.00
LS Pumps
Spare Part Inventory
L5 81 Upgrade/Engineering
In -Plant Water System
Blower Curtains
Hose Upgrades MBR
Belt Press Belt
Telemetry Upgrades
Lift Station Fencing
W WTP Fencing Replacement
Manhole Rehab and Replacement
Paving Road and Driveway W WTP
$7,222.92 Carry Over
5267,386.22 Carry Over
587,64700 Carry Over
2020 520,000.00 520,000.00 520,000.00
2020 525,000.00 525,000.00 $25,000.00
2019 530,000.00 530,000.00 530,000.00
2019 5100,000.00 5132,911.60 50.00
2020 513,000.00 513,000.00
2020 55,000.00 55,000.00
2020 55,000.00 55,000.00
2020 530,000.00 530,000.00
2020 55,000.00 55,000.00
2020 550,000.00 550,000.00
2020 522,500.00 522,500.00
2020 5125,000.00 5125,000.00
Admin
Board Room Audio and Video Improvements 2020 5100,000.00
Point to Point Communication/Town Project 2019 $35,000.00
Security Improvements Phase 3 2020 525,000.00
Building Maintenance 2020 550,000.00
Pavement and Driveway Repair 2020 520,000.00
535,000 00
5100,000.00
50.00
525,000.00
550,000.00
520,000.00
560,00000 Carry Over
5132,91160 Carry Over
513,000.00
55,000.00
55,000.00
$0.00 50.00
$0.00 50.00
55,000.00 55,000.00
50.00 59,000.00
50.00 50.00
50.00 50.00
550,000.00 550,000.00
5500,000.00 5500,000.00
510,000.00 510,000.00
541,000.00 541,000.00
569,875.00 569,875.00
50.00 50.00
50.00 5150,000.00
50.00 550,000.00
520,000.00 520,000.00
525,000.00 525,000.00
50.00 530,000.00
50.00 50.00
513,000.00 513,000.00
55,000.00 55,000.00
55,000.00 55,000.00
530,000.00 530,000.00 530,000.00
55,000.00 55,000.00 55,000.00
550,000.00 $50,000.00 550,000.00
$22,500.00 $22,500.00 $22,500.00
5125,00000 5125,000.00 5125,000.00
5100,000.00
535,00000 Carry Over
525,000.00
550,000 00
520,000.00
Total $8,486.00 $661,723.12 $1,410,375. 52,072,098.12
GASB Fund 137:
GASB Replacement -Town Elevated Tank
GASB Replacement -Water
GASB Replacement -Sewer
GASB Replacement- Sewer MBR's
GASB Replacement -Fire Truck
Total
1 1 1
136 of 140
5100,000.00 5100,000.00
50.00 $0.00
525,000.00 525,000.00
550,000.00 550,000.00
520,000.00 520,000.00
$1,171,375.00 51,410,375.00
09/30 Balance 10/01 Addtions 10/01 Balance 1 6058 54
$225,00000 5270,000.00r JE 1631
5000 53 530,000.00
597,804 58 53 , 5127,804.58 6058 34
50.00 5100,000.0 5100,000.00 JE 151,
5310,04139 $81,420.00 5391,461.39
5632,845.97 5286,420.001 $919,265.97
ebills
Bills Mailed
Bank Draft
Credit Card Draft
Online Payments
Late Notices
Disconnects
M
Connections P
ebills
Bills Mailed
Bank Draft
Credit Card Draft
Online Payments
Late Notices
Disconnects
M
Connections P
December 16, 2019 Regular Meeting Agenda Packet
Trophy Club MUD 141
Utility Billing Report
Fiscal Year 2020
October November December January February March April May June July August September
938 941
3841 3845
646 650
1193 1185
1145 1192
378 453
21 41
3351 3352
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
3297 3299 3301 3309 3309 3314 3317 3318 3324 3326 3329 3338
1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444
137 of 140
December 16, 2019 Regular Meeting Agenda Packet
MUD Permits
Month: November 2019
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
11/26/2019 2020-13 $ 75.00 $ 1,173.00 $ 353.00 $ 150.00 $ 50.00 $ 1,801.00
11/26/2019 2020-14 $ 75.00 $ 1,173.00 $ 353.00 $ 150.00 $ 50.00 $ 1,801.00
Total $ 150.00 $ 2,346.00 $ 706.00 $ 300.00 $ 100.00 $
138 of 140
$ 3,602.00
CASH STATUS AS OF NOVEMBER 2019
135-10250 TexPool 0 & M (XXXXX0002)-General Fund Operating ***
135-10300 Prosperity Bank (XXX8701) General Fund Operating
135-10305 Prosperity Bank Reserve -Savings Acct (XXXXX7724)
135-11100 Petty Cash Administration
135-11150 Petty Cash Utility Billing
137-10250 TexPool 0 & M (XXXXX0002) GASB Replacement
517-10250 TexPool Construction Tax (X)XXX011) WWTP Improvements
517-10300 Prosperity Bank Construction WWTP Improvements
519-10250 Texpool Revenue Bond Construction (XXXXX015) SWIFT
519-11155 Cash -Bond Escrow Bank of Texas (SWIFT)
520-10250 Texpool Revenue Bond Water & Waste Water Systems 2019 (XXXXX018)
520-11155 Cash -Bond Escrow Bank of Texas (Water & Waste Water Systems)
528-10250 TexPool Revenue Bond Reserve (XXXXX014) WWTP Improvements
533-10250 TexPool Tax I & S (XXXXX0003)
533-10300 Prosperity Bank (XXX8701) Tax I&S
534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements
535-10250 Texpool Revenue I & S (XXXXX017) SWIFT
536-10250 TexPool Revenue I & S (XXXXX020) Water & Waste Water Systems
Amount available in cash (MUD Accounts)
Amount available for spending (MUD Accounts)
*11/30/2019 Customer Water Deposits $320,304
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
139 of 140
December 16, 2019 Regular Meeting Agenda Packet
Restricted -
Unable to be spent
$o
$320,304
$1,398,315
$0
$0
$919,266
$568,889
$0
$0
$780,339
$586,482
$3,869,575
$826,594
$146,424
$0
$133,554
$55,132
$59,536
$9,664,410
$o
$0
Unrestricted -
Available for
spending
$4,202,332
$2,663,089
$0
$150
$450
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$6,866,021
$0 1
$6,866,021
$6,866,021
$329,248
$0
$329,248
$329,248
$329,248
Total in Accounts
(Restricted &
Unrestricted)
$4,202,332
$2,983,393
$1,398,315
$150
$450
$919,266
$568,889
$0
$0
$780,339
$586,482
$3,869,575
$826,594
$146,424
$0
$133,554
$55,132
$59,536
$16,530,432
General Fund 135 Available
2,663,089 Prosperity General Fund
4,202,332 Texpool General Fund
600 Petty Cash
6,866,021
3,486
2,072,098
6,325,800
(40,954)
$8,360,431
$329,248
$0
$329,248
TC Meeting Spaces
Calendars
FS Conference
FS Training Room„
Svore Board Room
January 2020
2
3
4
Sun Mon Tue Wed
Dec 29, 2019
5
12
19
30
6
13
20
6:30pm r4J Board of Di
31
7
14
21
5 26 27I
28
140 of 140
Jan 1
Office Closed
8
15
22
29
December 16, 2019 Regular Meeting Agenda Packe 2 Modifier
Thu
Fri Sat
2 3
9
10
16
23
30
17
24
4
11
18
25
311 Feb 1
Powered by T team