HomeMy WebLinkAbout2018-1015 October 15, 2018 Regular Meeting Agenda Packet
BOARD OF DIRECTORS
REGULAR MEETING
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
100 MUNICIPAL DRIVE
TROPHY CLUB, TEXAS 76262
Monday, October 15, 2018 6:30 P.M. Svore Municipal Boardroom
REGULAR MEETING AGENDA
CALL TO ORDER AND ANNOUNCE A QUORUM
CITIZEN COMMENTS
This is an opportunity for citizens to address the Board on any matter whether or not it is posted on the agenda.
The Board is not permitted to take action on or discuss any comments made to the Board at this time
concerning an item not listed on the agenda. The Board will hear comments on specific agenda items prior to
the Board addressing those items. You may speak up to four (4) minutes or the time limit determined by the
President or presiding officer. To speak during this item, you must complete the Speaker’s form that includes
the topic(s) of your statement. Citizen Comments should be limited to matters over which the Board has
authority.
CONSENT AGENDA
All matters listed as Consent Agenda are considered to be routine by the Board of Directors and will be
enacted by one motion. There will not be a separate discussion of these items. If discussion is desired, that
item will be removed from the consent agenda and will be considered separately.
1. Consider and take appropriate action to approve the Consent Age nda.
a. September 2018 Check Register
b. September 17, 2018 Regular Meeting Minutes
c. Tax Collections Report – 4th Quarter FY2018
d. Quarterly Investment Report – 4th Quarter FY2018
attachments: Check Register
Regular Meeting Minutes
Tax Collections Report
Quarterly Investment Report
REGULAR SESSION
2. Introduction of new Wastewater Superintendent Frank Isola. (Staff)
3. Receive presentation and update from Leah Hodge PE with Halff and Associates regarding Design and
Construction of Water Transmission Line to elevated water tank located on T.W. King Road.
attachments: Interconnect Waterline Probable Cost
4. Consider and take appropriate action regarding approval of acquisition of a 2019 Dodge 1500 Quad Cab
October 15, 2018 Regular Meeting Agenda Packet
1 of 171
truck for the water department to be purchased through the Buy Board contract at Grapevine Dodge
Chrysler Jeep for an amount of $26,571. (Staff)
attachments: Staff Report
Buy Board Summary vehicle summary
5. Discussion and possible action regarding access to wastewater plant during rain event. (Staff)
6. Consider and take appropriate action regarding the following engineering matters: (Staff)
a. Request by CP&Y for Additional Engineering Fees relating to Preparation of Application to the Texas
Commission on Environmental Quality for Approval for Issuance of Bonds by the District.
b. Request by CP&Y for Approval of Amendment No. 5 to Contract for Professional Engineering Services
related to Wastewater Treatment Plant Project to authorize payment of additional engineering fees
for construction phase services.
c. Agreement with Halff Associates, Inc. for Professional Engineering Services to be implemented on a Task
Order Basis.
attachments: CP&Y Amendment to Task Order 3
CP&Y Addendum 5 – Additional Engineering fee
Halff Associates Master Engineering Contract
7. Consider and take appropriate action regarding the September 2018 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 1
Interconnect Water Transmission Line Phase 2
Wastewater Treatment Plant Upgrade Project
High Service Pump
Joint Projects with Town
c. Fire Department Summary
d. Water System Operations
e. Wastewater System Operations
f. Finance Update
Utility Billing Report
Permits Collected
October 15, 2018 Regular Meeting Agenda Packet
2 of 171
Cash Report
attachments: General Manager Report
Water Operations Report
Wastewater Operations Report
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. Claims for damages caused by District facilities and/or operations to property located at 1040 Trophy
Club Drive, Trophy Club Texas
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. District real property located at 100 Municipal Drive and 1501 Junction Way.
REGULAR SESSION
11. Consider and take appropriate action on matters deliberated in Executive Session:
12. Items for future agendas:
13. Consider and take appropriate action regarding rescheduling November and December meeting dates
for the Board of Directors of the District.
attachments: November Meeting Calendar
December 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,
October 15, 2018 Regular Meeting Agenda Packet
3 of 171
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
October 15, 2018 Regular Meeting Agenda Packet
4 of 171
October 15, 2018 Regular Meeting Agenda Packet
5 of 171
October 15, 2018 Regular Meeting Agenda Packet
6 of 171
October 15, 2018 Regular Meeting Agenda Packet
7 of 171
October 15, 2018 Regular Meeting Agenda Packet
8 of 171
October 15, 2018 Regular Meeting Agenda Packet
9 of 171
October 15, 2018 Regular Meeting Agenda Packet
10 of 171
October 15, 2018 Regular Meeting Agenda Packet
11 of 171
October 15, 2018 Regular Meeting Agenda Packet
12 of 171
October 15, 2018 Regular Meeting Agenda Packet
13 of 171
October 15, 2018 Regular Meeting Agenda Packet
14 of 171
October 15, 2018 Regular Meeting Agenda Packet
15 of 171
PUBLIC HEARING REGULAR MEETING MINUTES
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
BOARD OF DIRECTORS
September 17, 2018 at 6:30 P.M.
100 Municipal Drive, Trophy Club, Texas 76262
Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in a
Public Hearing and Regular Meeting on September 17, 2018 at 6:30 P.M., in the Boardroom of the
Administration Building, 100 Municipal Drive, Trophy Club, Texas 76262. The meeting was held within the
boundaries of the District and was open to the public.
STATE OF TEXAS §
COUNTIES OF DENTON AND TARRANT §
BOARD MEMBERS PRESENT:
Gregory Wilson President
William C. Rose Vice President
Kelly Castonguay Director
BOARD MEMBERS ABSENT:
Steve Flynn Secretary/Treasurer
Mark Chapman Director
STAFF PRESENT:
John Carman General Manager
Laurie Slaght District Secretary
Mike McMahon Water Superintendent
Steven Krolczyk Finance Manager
Tony Corbett Legal Counsel
GUESTS PRESENT:
Chris Ekrut NewGen Strategies
Andrew Friedman Samco Capital Marketing
CALL TO ORDER AND ANNOUNCE A QUORUM
President Wilson announced the date of September 17, 2018, called the meeting to order and announced a
quorum present at 6:34 p.m.
CITIZEN COMMENTS
Luanne Wing 1115 Wilshire Drive
PUBLIC HEARING
1. Trophy Club Municipal Utility District No. 1 will conduct a Public Hearing regarding adoption of the final
District Tax Rates for Tax Year 2018.
Director Wilson opened the Public Hearing at 6:35 p.m.
October 15, 2018 Regular Meeting Agenda Packet
16 of 171
There were no speakers for the Public Hearing
Director Wilson closed the Public Hearing at 6:36 p.m.
CONSENT AGENDA
2. Consider and take appropriate action to approve the Consent Age nda.
a. August 2018 Check Register
b. August 20, 2018 Regular Meeting Minutes
Motion made by Director Rose and seconded by Director Castonguay to approve the consent agenda as
presented.
Motion carried unanimously
REGULAR SESSION
3. Receive report from District Rate Consultant regarding proposed water and sewer rate
recommendations.
Chris Ekrut, Director at NewGen Strategies and Rate Consultant to the District presented proposed water
and sewer rates for FY2019 and answered questions related thereto.
Discussion Only, No Action Taken
4. Receive report from District Financial Advisor regarding outstanding District debt, issuance of proposed
revenue bonds, debt service funding obligations, future capital improvement project financing, and
general District financial recommendations.
Andrew Friedman, Managing Director at SAMCO Capital Markets and Financial Advisor to the District
provided an update to the board regarding the upcoming bond issuance and answered questions related
thereto. Mr. Friedman stated that he has reviewed the proposed FY19 Budget and feels the District
meets the revenue requirements for the upcoming bond issuance.
Discussion Only, No Action Taken
5. Consider and take appropriate action to approve Resolution No. 2018‐0917A amending the Fiscal Year
2018 Budget.
Steven Krolcyzk, Finance Manager reviewed the amendments to the Fiscal Year 2018 Budget and
answered questions related thereto.
Motion made by Director Rose and seconded by Director Castonguay to approve Resolution No. 2018‐
0917A amending the Fiscal Year 2018 Budget.
October 15, 2018 Regular Meeting Agenda Packet
17 of 171
Motion carried unanimously
6. Consider and take appropriate action regarding adoption of Resolution No. 2018‐0917B approving
Budget for Fiscal Year 2019.
Motion made by Director Rose and seconded by Director Castonguay to adopt Resolution No. 2018‐0917B
approving Budget for Fiscal Year 2019 using option 3 for the water and sewer rate increase.
For: Rose, Castonguay
Opposed: Wilson
Motion Failed 2‐1
Motion made by Director Wilson to approve the fiscal year budget as presented with option 2 for the
water and sewer rates.
Motion died for lack of a second.
Motion made by Director Rose and seconded by Director Castonguay to adopt Resolution No. 2018‐0917B
approving Budget for Fiscal Year 2019 using option 3 for the water and sewer rate increase.
For: Rose, Castonguay
Opposed: Wilson
Motion Failed 2‐1
Motion by director Wilson to approve the FY budget using Option 2 for the water and sewer increase.
Motion dies for the lack of a second.
Motion by Wilson seconded by Director Rose to adopt Resolution No. 2018‐0917B approving Budget for
Fiscal Year 2019 using option 2 for the water and sewer rate increase.
Motion carried unanimously
7. Consider and take appropriate action to adopt Rate Order No. 2018‐0917A amending water and sewer
rates and setting an effective date of October 1, 2018.
Motion made by Director Wilson and seconded by Director Rose to adopt Rate Order No. 2018‐0917A
amending water and sewer rates and setting an effective date of October 1, 2018.
Amendment to the Motion
Motion by Director Rose and seconded by Director Castonguay to amend Section 1.10 of Rate Order 2018‐
October 15, 2018 Regular Meeting Agenda Packet
18 of 171
0917A to read as follows: 1.10 FORT WORTH IMPACT FEE. Each customer requesting an initial connection
to the Districts water system shall also pay to the District the applicable City of Fort Worth Impact Fee.
Motion to amend Section 1.10 of the Rate Order carried unanimously
Motion to adopt Rate Order 2018‐0917A as amended carried unanimously
8. Consider and take appropriate action regarding Order No. 2018‐0917B, fixing and levying Trophy Club
Municipal Utility District No. 1 Debt Service Tax Rate and Operations and Maintenance Tax Rate for 2018
Tax Year.
Motion made by Director Rose and seconded by Director Castonguay to approve Order No. 2018‐0917B,
fixing and levying Trophy Club Municipal Utility District No. 1 Debt Service Tax Rate and Operations and
Maintenance Tax Rate for 2018 Tax Year.
Motion carried unanimously
9. Consider and take appropriate action regarding approval of amendment to District Information Form,
including Notice to Purchaser Form.
Motion made by Director Wilson and seconded by Director Castonguay to approve the amendment to
District Information form including Notice to Purchaser Form with a rate of .11618 per $100 valuation.
Motion carried unanimously
10. Consider and take appropriate action regarding adoption of Resolution 2018‐0917C approving FY 2018
Tax Roll for Trophy Club Municipal Utility District No. 1.
Motion made by Director Wilson and seconded by Director Rose to adopt Resolution 2018‐0917C
approving FY 2018 Tax Roll for Trophy Club Municipal Utility District No. 1.
Motion carried unanimously
11. Consider and take appropriate action regarding annual review of District Investment Policy and
Investment Strategies including:
a. Appoint District Investment Officer(s).
b. Order No. 2018‐0917C Adopting Amended and Restated Investment Policy.
Motion made by Director Rose and seconded by Director Wilson to approve Order No. 2018‐0917C
Adopting Amended and Restated Investment Policy.
Amendment to the Motion
Motion made by Director Rose second by Director Castonguay to amend the Section 7.02 Investment
October 15, 2018 Regular Meeting Agenda Packet
19 of 171
Training and delete board appointed treasurer 7.02 and treasurer in sentenance 2.
For: none
Opposed: Rose, Wilson and Castonguay
Motion to amend Section 7.02 of the Investment Policy Failed 0‐3
Motion approve Order No. 2018‐0917C carried unanimously
12. Consider and take appropriate action regarding adoption of Order No. 2018‐0917D Approving Cash
Reserve Policy.
Motion made by Director Rose and seconded by Director Castonguay delegate Director Rose and Director
Flynn work with the General Manager and Finance Manager to work on a reserve policy to bring back to
the Board for approval.
Motion carried unanimously
13. Consider and take appropriate action regarding the August 2018 combined financials and variance
report.
a. Combined financials
b. Variance report
Motion made by Director Rose and seconded by Director Castonguay to approve the August 2018
Combined Financials and Variance Report.
Motion carried unanimously
REPORTS & UPDATES
14. General Manager Monthly Reports and Updates
a. Regulatory Update
b. Capital Improvement Projects
Interconnect Water Transmission Line Phase 1
Interconnect Water Transmission Line Phase 2
Wastewater Treatment Plant Upgrade Project
Joint Projects with Town
c. Fire Department Summary
d. Water System Operations
e. Wastewater System Operations
f. Finance Update
Utility Billing Report
Permits Collected
Cash Report
October 15, 2018 Regular Meeting Agenda Packet
20 of 171
General Manager John Carman presented his monthly update to the Board and answered questions
related thereto.
The Board convened into Executive Session at 9:18 P.M.
EXECUTIVE SESSION
15. Pursuant to Section 551.071 of the Texas Open Meetings Act, the Board may consult with its attorney in
Executive Session on a matter in which the duty of the attorney to the Governmental Body under the
Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflicts with the Open
Meetings Act or to seek advice of counsel on legal matters involving pending or contemplated litigation
or settlement offers:
a. Contractor breach, performance and payment issues related to District’s contract with Webber‐
Cadagua Partners for construction of the Wastewater Treatment Plant Improvements; and
b. Trophy Club Municipal Utility District No. 1 v. Acadia Services, LLC, In the District Court of Tarrant
County, 141st Judicial District (Cause No. 141‐299351‐18).
c. Claims for damages caused by District facilities and/or operations to property located at 1040 Trophy
Club Drive, Trophy Club Texas.
16. Pursuant to Section 551.072 of the Texas Open Meetings Act, the Board may deliberate the purchase,
exchange, lease, or value of real property if deliberation in an open meeting would have a detrimental
effect on the position of the governmental body in negotiations with a third person:
a. District real property located at 100 Municipal Drive and 1501 Junction Way.
The Board convened into Regular Session at 9:52 p.m.
REGULAR SESSION
Director Wilson stated that no final decisions, actions or votes were taken in Executive Session.
17. Consider and take appropriate action on matters deliberated in Executive Session:
No action was taken
18. Items for future agendas: Director Rose would like to discuss rebranding.
19. Review and set future Meeting dates: Regular Board Meeting – Monday, October 15, 2018 at 6:30 p.m.
ADJOURN
Motion made by Director Rose and seconded by Director Castonguay to adjourn the meeting.
Motion carried unanimously
October 15, 2018 Regular Meeting Agenda Packet
21 of 171
Director Wilson adjourned the Meeting at 9:52 p.m.
___________________________
Gregory Wilson, President
(SEAL)
____________________________
Steve Flynn, Secretary/Treasurer
____________________________
Laurie Slaght, District Secretary
October 15, 2018 Regular Meeting Agenda Packet
22 of 171
PERDUE RANDON
FIELDER(OLUNS&MOTT LLP
ATTORNEYS AT LAW
David S. Crawford
Attorney at Law
500 East Border, Suite 640
Arlington, Texas 76010
p: 817-461-3344
f: 817-860-6509
w: www.pbfcm.com
October 9, 2018
Mr. Steven Krolczyk
Trophy Club MUD No. 1
1 00 Municipal Drive
Trophy Club, Texas 76262
RE: Status of Collection of Delinquent Taxes
Dear Mr. Krolczyk,
Please find attached a copy of the Authority Analysis report for Trophy Club MUD No. 1
as of today. Also included is a delinquent tax roll for all tax years through 2017, as well as a
delinquent tax roll for only the 2017 tax year. This update is good through September 30, 2018.
Through our collection efforts, we have reduced the 2017 tax base from $5,630.81 to
$4,509.41 in the delinquent collection year from July 1, 2018 through September 30, 2018. This
results in a collection percentage of 19.92%.
I have also included two charts that shows the amount of base taxes due to Trophy Club
MUD No. 1 that are currently deferred because the taxpayer filed a deferral with the Denton
CAD for their homestead since they are over 65 years of age. For 201 7 alone, this amounts to
$2,041.59. The ALL year total of deferred base tax is $18,230.27. Unfortunately, we cannot
collect these amounts until the deferral is removed by the Denton CAD.
If you have any questions or comments, please feel free to contact me at the office.
Thank you for your continued support and interest in our efforts to collect the delinquent taxes
for Trophy Club MUD No. 1.
PERDUE, BRANDON, FIELDER,
COLLINS & MOTT, L.L.P.
£lJ J. (V /) #
DavidS. Crawfor;;-r
AMARILLO ARLINGTON AUSTIN CONROE EDINBURG GARLAND
HOUSTON LUBBOCK MIDLAND SAN ANTONIO TYLER WICHITA FALLS
October 15, 2018 Regular Meeting Agenda Packet
23 of 171
ER UE
F~ElDER LtP
ATTORNEYS AT lAl'l'
AUTHORITY ACTIVITY ANALYSIS
TROPHY CLUB MUNICIPAL UTILITY DISTRICT #1 As Of 10/9/2018, Last Tax Year Included 2017
4.71% 0.01%
9.41% 69.64%
7.06% 13.25%
0.00% 0.00%
21.18% 4.41%
14.12% 4.92%
43.53% 7.77%
$0.01 -$1 00.00
$1 00.01 -$250.00 $1,371.27 5.24%
$250.01 -$500.00 $3,309.15 12.64%
$500.01 -$1 000.00 $1,566.20 5.98%
$1000.01 -$2500.00 $3,643.8 13.92%
$2500.01 -$5000.00 28.92%
$5000.01 -$10,000.00 30.51
Totals 100.00% 100.00%,
As Of 10/9/2018 Total Base Tax: $26,178.77
October 15, 2018 Regular Meeting Agenda Packet
24 of 171
As Of
ER UE
FIElDER(
.,-4TTORNEYS AT Lill\l
1
1
1
1
1
1
3
7
9
6
13
14
11
13
18
22
24
34
Totals 183
10/9/2018
N
0.55%
0.55%
0.55%
0.55%
0.55% 0.28
0.55% 0.42
0.55%
0.55% 0.42
1.64%
3.83%
4.92% 4.21%
3.28% 3.75
7.10%
7.65%
6.01%
7.10% 8.24%
9.84% 9.20%
12.02% 9.62
13.11 % 10.08
18.58%
100.00%
Total Base Tax: $26,178.77
October 15, 2018 Regular Meeting Agenda Packet
25 of 171
2017 TROPHY CLUB MUD #1 OVER 65 DEFERRALS
2017 TAX YEAR ONLY
Taxpayer# Name Base Tax Due
376 Masters, W. James & Sally P. $588.44
77 Foust, Amanda $476.32
968 Boren, Benjamin C. & Beverly C. $385.38
91176 Parrow, James J. & Elena $385.31
1570 Goswick, Cherie $200.77
76 McDonald, James E. $5.37
TOTAL $2,041.59
October 15, 2018 Regular Meeting Agenda Packet
26 of 171
2017 TROPHY CLUB MUD #1 OVER 65 DEFERRALS
All Years
Taxpayer# Name Base Tax Due
799 Baker, Bob J. $7,987.20
76 McDonald, James $4,746.91
1205 Shires, Brenda $30.88
968 Boren, Benjamin C & Beverly C $2,823.24
376 Masters, James & Sally $1,579.37
77 Foust, Amanda $476.32
91176 Parrow, James J. & Elena $385.31
1570 Goswick, Cherie $201.14
TOTAL $18,230.37
October 15, 2018 Regular Meeting Agenda Packet
27 of 171
Descending Tax Roll
TROPHY CLUB MUNICIPAL UTILITY DISTRICT #1
For Amounts $0.01 To $999,999,999.99
For Years 2017 Through 2017
Taxpayer# Name
376 MASTERS W JAMES & SALLY P
Address 10 FAIR GREEN DR
City/State/Zip TROPIN CLUB, TX 76262-5629
Phone No.
Client GEO Code Client Property Code
ll6467DEN R116467
77
Address
FOUST AivfANDA
31 0 OAKtvfONT DR
City/State/Zip TROPHY CLUB, TX 76262-5473
Phone No.
Client GEO Code Client Property Code
72073DEN R72073
90337 WISE JEFFREY L
116 ROLLING ROCK DR
City/State/Zip ROANOKE, TX 76262-5114
Phone No.
Client GEO Code Client Property Code
189825DEN R189825
10/9/2018 11:34:08 AM
Cause# Jdg Date
PTD Code Year Span
R 2017
PTD Code Year Span
R 2017
5/8/2017
PTD Code Year Span
R 2017
Status
Indicators
Tax Due
$588.44
Tax Due
$476.32
Tax Due
$406.37
Base Tax: oos LIBIPID
$588.44 D
Total Due
$608.04
$476.32 D
Total Due
$685.90
$406.37
Total Due
$590.05
Page 2 of9
October 15, 2018 Regular Meeting Agenda Packet
28 of 171
968
Address
BOREN BENJAMIN C & BEVERLY C
14 EDGEMERE DR
City/State/Zip TROPHY CLUB, TX 76262-9725
Phone No.
Client GEO Code Client Property Code
71012DEN R71012
91176 PARROvV JAMES J & ELENA
Address 8 BROOKFIELD CT
City/State/Zip TROPHY CLUB, TX 76262
Phone .No.
Client GEO Code Client Property Code
71779DEN R71779
90829 FOREMAN DR. JOSHUA
925 TROPHY CLUB DR
City/State/Zip ROANOKE, TX 76262-5582
Phone No.
Client GEO Code Client Property Code
650109DEN P650109
914
Address
110RTON DE:t\T\'ER & JANIE
3 HILLCREST CT
City/State/Zip TROP!-IY CLUB, TX 76262-5515
Phone No.
Client GEO Code Client Property Code
72277DEN R72277
1209 JONES BRETT W
.A.ddress 159 CREEK COURTS DR
City/State/Zip TROPHY CLUB, TX 76262-5441
10/9/2018 11:34:08 AM
PTD Code
R
PTD Code
R
17-3915-442
PTD Code
p
PTD Code
R
DEFE $385.38 D
Year Span Tax Due Total Due
2017 $385.38 $398.21
DEFE $385.31 D
Year Span Tax Due Total Due
2017 $385.31 $398.14
3/2/2018 SUIT $305.65 L
Year Span Tax Due Total Due
2017 $305.65 $443.80
$285.68
Year Span Tax Due Total Due
2017 $285.68 $414.81
$267.50
Page 3 of9
October 15, 2018 Regular Meeting Agenda Packet
29 of 171
Phone No.
Client GEO Code Client Property Code
71072DEN R71072
90894 MCDOWELL NANCY
Address 41 MEADOWBROOK LN
City/State/Zip TROPHY CLUB, TX 76262-5639
Client GEO Code Client Property Code
70277DEN R7277
1570 GOS\VICK CHERIE
542 TIMBER RfDGE DR
City/State/Zip TROPHY CLUB~ TX 76262-5644
Phone No.
Client GEO Code Client Property Code
70677DEN R7677
90738 BG FOX LLC
Address 2234 EDINBURGH AVE
City/State/Zip TROPHY CLUB, TX 76262
Phm:teNo.
Client GEO Code Client Property Code
42203277TAR R42203277T AR
42229993TAR R42229993TAR
91111 ASAAD NEAL ~1\TD TRAN ASAAD KIM M
Address 2025 GRANADA TRL
City/State/Zip WESTLAKE, TX 76262
Phone No.
10/9/2018 11:34:08 AM
PTD Code Year Span Tax Due Total Due
R 2017 $267.50 $388.41
QPAY $251.59
PTD Code Year Span Tax Due Total Due
R 2017 $251.59 $347.19
DEFE $200.77 D
PTD Code Year Span Tax Due Total Due
R 2017 $200.77 $202.44
$166.32
PTD Code Year Span Tax Due Total Due
R 2017 $6.71 $9.74
R 2017 $159.61 $231.75
$138.01
Page 4 of9
October 15, 2018 Regular Meeting Agenda Packet
30 of 171
Client GEO Code Client Property Code PTD Code
42ll0333TAR R42110333TAR R
91222 PENDERGRASS JIM E AND PENDERGRASS
CATHER
Address 1616 LIS"tY10RE CT
City/State/Zip ROANOKE, TX 76262
Phone No.
Client GEO Code Client Property Code
42110589TAR .R42110589TAR
1750 LYNCH HELEN M
207 CARNOUSTIE DR
City/State/Zip TROPHY CLUB, TX 76262-5462
Phone No.
Client GEO Code Client Property Code
72370DEN R72370
58
Address
\VEINBERGER DELI TWO LLC
3 VILLAGE CI.R STE 116
City/State/Zip WESTLAKE, TX 76262-7935
Phone No.
Client GEO Code Client Property Code
11514205TAR P11514205TAR
1242 FORD LESLIE
Address 1300 KELLER PKWY APT 523
City/State/Zip KELLER, TX 76248-8473
Phone No.
Client GEO Code Client Property Code
926478DEN P926478
10/9/2018 11:34:08 AM
PTD Code
R
PTD Code
R
PTD Code
p
15-06894-431
PTD Code
p
Year Span
2017
Year Span
2017
Year Span
2017
Year Span
2017
8/25/2016
3/21/2014
11/6/2014
Year Span
2017
Tax Due
$138.01
Tax Due
$120.05
QPAY
Tax Due
$106.05
Tax Due
$96.45
_,SUIT
Tax Due
$73.69
Total Due
$200.39
$120.05
Total Due
$174.31
$106.05
Total Due
$146.35
$96.45
Total Due
$140.05
$73.69 L
Total Due
$107.00
Page 5 of9
October 15, 2018 Regular Meeting Agenda Packet
31 of 171
90466
Address
LA SCALA RJSTORANTE ITALIANO
1301 SOLANA BLVD STE 4115
City/State/Zip Vv"'ESTLAKE, TX 76262-1660
Phone No.
Client GEO Code Client Property Code
10755195TAR P1755195TAR
65 FIRST MAD[SON BANK FSB
Address 14651 DALLAS PKW'l STE 200
City/State/Zip DALLAS, TX 75254
Phone No. (214) 770-3711
Client GEO Code Client Property Code
173225DEN R173225
40778495T AR R4778495TAR
1769
Address
CAMPUS CIRCLE WESTLAIZE LLC
29 COMMONWEALTH AVE
City/State/Zip BOSTON, I\1A 02116
Phon.e No.
759
Client GEO Code Client Property Code
41463978TAR R41463978TAR
MORRISON AVIATION LLC
P. 0. BOX 1691
City/State/Zip JACKSONVILLE, TX 75766-1691
Phone No.
Client GEO Code Client Property Code
339971DEN P339971
, .. , ,., .. ,. '"""""""""" ·······.·~·~···-·--·~··~
91071 TURNER CONSTRUCTION CO
10/9/2018 11:34:08 AM
$69.98
PTD Code Year Span Tax Due Total Due
p 2017 $69.98 $101.61
14-03488-211 1/29/2016 , SUIT $62.76 L
141-E31255-14 2/4/2016
2/23/2012
PTD Code Year Span Tax Due Total Due
R 2017 $18.78 $27.27
R 2017 $43.98 $63.86
$32.50
PTD Code Year Span Tax Due Total Due
R 2017 $32.50 $47.19
. UP $28.57
PTD Code Year Span Tax Due Total Due
p 2017 $28.57 $41.48
$20.46
Page 6 of9
October 15, 2018 Regular Meeting Agenda Packet
32 of 171
Address 10100 N CENTRAL EXPW STE 600
City/State/Zip DALLAS, TX 75231
Phone No.
Client GEO Code Client Property Code
14454543TAR P14454543TAR
'-.. ····-···-···
90837 THE BRONZE BAR
A.ddress 2003 E :t:UGHW A Y 114 STE 400
City/State/Zip ROANOKE, TX 76262-6678
Phone No.
Client GEO Code Client Property Code
656967DEN P656967
90369 FOOT' PALACE SPA
Address 301 TROPHY LAKE DR UNIT 124
City/State/Zip ROANOKE, 'I'X 76262-5237
Phone No.
Client GEO Code Client Property Code
656969DEN P656969
91068 :HEART TEST LABORATORIES INC
Address 5611 COLLEYVILLE BLVD
City/State/Zip COLLEYVILLE, TX 76034
.Phone No.
Client GEO Code Client Property Code
13442112T AR P13442112TAR
76
A.ddress
MCDONALD JAMES E
4ROSS CT
City/State/Zip TROPHY CLUB, TX 76262-671 l
Phone No.
10/9/2018 11:34:08 AM
PTD Code Year Span Tax Due Total Due
p 2017 $20.46 $29.71
$14.54
PTD Code Year Span Tax Due Total Due
p 2017 $14.54 $21.11
$9.53
PTD Code Year Span Tax Due Total Due
p 2017 $9.53 $13.84
$6.45
PTD Code Year Span Tax Due Total Due
p 2017 $6.45 $9.37
DEFE $5.37 D
Page 7 of9
October 15, 2018 Regular Meeting Agenda Packet
33 of 171
Client GEO Code Client Property Code
72060DEN R72060
91141
Address
CHIP :tviUNDY INC
2003 E H\VY 114
City/State/Zip ROANOKE, TX 76262
Phone No.
Client GEO Code Client Property Code
659388DEN P659388
1588 BOICE SHON
Address 3 GLENDALE CT
City/State/Zip TROPHY CLUB, TX 76262-5520
Phone No.
1638
Client GEO Code Client Property Code
72595DEN R72595
NATIONAL DEFAULT TITLE SERVICE
1 FIRST Aivt:ERICAN vV A Y
City/State/Zip SANTA ANA, CA 92707
Phone No.
Client GEO Code Client Property Code
PTD Code
R
PTD Code
p
PTD Code
R
PTD Code
13661787TAR P13661787TAR P
1497 THIBAULT LA'W'RENCE R & JEANNETTE E
Address 111 LAKESIDE DR
City/State/Zip ROANOKE, TX 76262-5231
Phone No.
Client GEO Code Client Property Code
203807DEN R23807
10/9/2018 11:34:08 AM
PTD Code
R
Year Span Tax Due Total Due
2017 $5.37 $5.55
$4.85
Year Span Tax Due Total Due
2017 $4.85 $7.04
QPAY $0.70
Year Span Tax Due Total Due
2017 $0.70 $0.97
$0.07
Year Span Tax Due Total Due
2017 $0.07 $0.10
QPAY $0.02
Year Span Tax Due Total Due
2017 $0.02 $0.03
Page 8 of9
October 15, 2018 Regular Meeting Agenda Packet
34 of 171
893 BULAND RlJDY A QPAY $0.01
Address 213 PHOENIX DR
City/State/Zip ROANOKE, TX 76262
Phone No.
Client GEO Code Client Property Code PTD Code Year Span Tax Due Total Due
72300DEN R 2017 $0.01 $0.01
"'•'''W'''•""~'" ·~-· '''' '''0''W'0''0'0''''" 'YW•0'~''"''"•'''-'0°-Y
91159 STvHTH MIL TON $0.01
Addn:.ss 1120 SUNSET DR
City/State/Zip TROPI-lY CLUB, TX 76262
Phone No.
Client GEO Code Client Property Code PTD Code Year Span Tax Due Total Due
70021DEN R721 R 2017 $0.01 $0.01 -" .. ~ ....
91203 SISODIYA KAMLESH J AND SISODIY A $0.01
HARSHA
Address 7003 GLADVvYNE CT
City/State/Zip COLLEYVU.I . .E, TX 76034-6625
·Phone No.
Client GEO Code Client Property Code PTD Code Year Span Tax Due Total Due
4211 0520T AR R42110520TAR R 2017 $0.01 $0.01
32 Taxpayers $4,509.41
10/9/2018 11:34:08 AM Page 9 of9
October 15, 2018 Regular Meeting Agenda Packet
35 of 171
Descending Tax oil
TROPHY CLUB MUNICIPAL UTILITY DISTRICT #1
For Amounts $0.01 To $999,999,999.99
For Years 1994 Through 2017
Taxpayer# Name
799 BAlCER BOB J
1 1 STEPHENS CT
City/State/Zip TROPI-N CLUB, TX 76262-5421
Phone No.
Client GEO Code Client Property Code
209674DEN R29674
76
Address
MCDONALD JAMES E
4 ROSS CT
City/State/Zii> TROPHY CLUB, TX 76262-6711
Phone No.
Client GEO Code Client Property Code
72060DEN R72060
968 BOREN BENJAMIN C & BEVERLY C
Address 14 EDGEMERE DR
City/State/Zip TROPI-N CLUB, TX 76262-9725
Phone No.
Client GEO Code Client Property Code
71012DEN R71012
10/9/2018 11:33:13 AM
Cause#
PTD Code
R
PTD Code
R
PTD Code
R
Jdg Date
Year Span
2010-2016
Year Span
2006-2017
Year Span
2010-2017
Status
Indicators
DEFE
Tax Due
$7,987.20
DEFE
Tax Due
$4,746.91
DEFE
Tax Due
$2,823.24
Base Tax: oos LIBIPID
$7,987.20 D
Total Due
$11,738.23
$4,746.91 D
Total Due
$7,352.36
$2,823.24 D
Total Due
$3,703.90
Page 2 of19
October 15, 2018 Regular Meeting Agenda Packet
36 of 171
59
Address
SlJ1'v1MERS, JAMES M
532 LEA VALLEY CIR
City/State/Zip COPPELL, TX 75019
Phone No.
Client GEO Code Client Property Code
11514221TAR Pl1514221TAR
65 FIRST 1\tiADISON BANK FSB
Address 14651 DALLAS PK\VY STE 200
City/State/Zip DALLAS, TX 75254
Phone No. (214) 770-3711
Client GEO Code Client Property Code
173225DEN Rl73225
296671DEN R296671
40778495TAR R4778495TAR
. ···---··· -··-·.
376 IviASTERS W JAMES & SALLY P
Address 10 FAIR GREEN DR
City/State/Zip TROPHY CLUB, TX 76262-5629
77
Client GEO Code Client Property Code
116467DEN R116467
FOUST Al\t1ANDA
310 OAKMONT DR
City/State/Zip TROPI-IY CLUB, TX 76262-5473
Plume No.
Client GEO Code Client Property Code
72073DEN R72073
10/9/2018 11:33:13 AM
L-24321 12il/2011 BKR, SUIT, lJP $2,064.50 L
PTD Code Year Span Tax Due Total Due
p 2008-2014 $2,064.50 $4,845.78
14-03488-211 1/29/2016 , StiTT $1,721.62 L
141-E31255-14 2/4/2016
2/23/2012
PTD Code Year Span Tax Due Total Due
R 1997-2017 $988.53 $3,113.29
R 2006-2007 $155.42 $441.91
R 2008-2017 $577.67 $1,254.58
.. ._ ....... ·-·············~···
$1,579.37 D
PTD Code Year Span Tax Due Total Due
R 2015-2017 $1,579.37 $2,164.95
$476.32 D
PTD Code Year Span Tax Due Total Due
R 2017 $476.32 $685.90
Page 3 of 19
October 15, 2018 Regular Meeting Agenda Packet
37 of 171
90337 WISE JEFFREY L
Address 116 ROLLING ROCK DR
City/State/Zip ROANOKE, TX 76262-5114
Phone No.
Client GEO Code Client Property Code
189825DEN R189825
91176
Address
PARROW JAfv1ES J & ELENA
8 BROOKFIELD CT
City/State/Zi.p TROPHY CLUB, TX 76262
Phone No.
Client GEO Code Client Property Code
71779DEN R71779
123
Address
DIEGO'S TEX-MEX STEAKS
3 VILLAGE CIR STE 1 08
City/State/Zip WESTLAKE, TX 76262-7935
Phone No. (817) 430-3558
Client GEO Code Client Property Code
947887DEN P947887
1560 BURGARBRANDON
301 TROPHY LAKE DR STE 120
City/State/Zip TROPHY CLUB, TX 76262-5237
Phone No.
Client GEO Code Client Property Code
620602DEN P620602
90829 FOREMAN DR. JOSHUA
925 TROPf-N CLUB DR
City/State/Zip ROANOKE, TX 76262-5582
10/9/2018 11:33:13 AM
PTD Code
R
PTD Code
R
PTD Code
p
16-04123-158
PTD Code
p
17-3915-442
5/8/2017 $406.37
Year Span Tax Due Total Due
2017 $406.37 $590.05
~ • .,. •• • ••y••w•'"' '
DEFE $385.31 D
Year Span Tax Due Total Due
2017 $385.31 $398.14
UP $316.25
Year Span Tax Due Total Due
2007 $316.25 $876.49
SUIT $310.41 L
Year Span Tax Due Total Due
2013-2014 $310.41 $605.13
3/2/2018 SUIT $305.65 L
Page 4 of 19
October 15, 2018 Regular Meeting Agenda Packet
38 of 171
Phone No.
Client GEO Code Client Property Code
650109DEN P650109
1242 FORD LESLIE
Address 1300 KELLER PKWY APT 523
City/State/Zip KELLER, TX 76248-8473
Phone No.
Client GEO Code Client Property Code
9264 78DEN P9264 78
914 MORTON DENVER & JANIE
Address 3 HILLCREST CT
City/State/Zip TROPHY CLUB, TX 76262-5515
Phone No.
Client GEO Code Client Property Code
72277DEN R72277
1209 JONES BRETT W
Address 159 CREEK COURTS DR
City/State/Zip TROPI-IY CLUB, TX 76262-5441
Phone No.
Client GEO Code Client Property Code
71072DEN R71072
90894
Addxess
MCDOWELL NANCY
4111EADOWBROOK LN
City/State/Zip TROPHY CLUB, TX 76262-5639
Plume No.
10/9/2018 11:33:13 AM
PTD Code
p
15-06894-431
PTD Code
p
PTD Code
R
PTD Code
R
Year Span
2017
8/25/2016
3/21/2014
ll/6/2014
Year Span
2012-2017
Year Span
2017
Year Span
2017
Tax Due
$305.65
, SUIT
Tax Due
$304.07
Tax Due
$285.68
Tax Due
$267.50
QPAY
Total Due
$443.80
$304.07 L
Total Due
$523.88
$285.68
Total Due
$414.81
$267.50
Total Due
$388.41
$251.59
Page 5 of 19
October 15, 2018 Regular Meeting Agenda Packet
39 of 171
Client GEO Code Client Property Code PTD Code Year Span Tax Due Total Due
70277DEN R7277 R 2017 $251.59 $347.19
759 :!'vfORRISON AVIATION LLC , UP $243.04
i\ddress P. 0. BOX 1691
City/State/Zip JACKSONVILLE, TX 75766-1691
.Phone No.
Client GEO Code Client Property Code PTD Code Year Span Tax Due Total Due
339971DEN P339971 p 2010-2017 $243.04 $479.86
' .... _.·~· ~~
, .. , .. ,.,_ .... _._._. ________
1570 GOSWICK CHERIE DEFE $201.14 D
Address 542 TIMBER RIDGE DR
City/State/Zip TROPHY CLUB, TX 76262-5644
"Phone No.
Client GEO Code Client Property Code PTD Code Year Span Tax Due Total Due
70677DEN R7677 R 2016-2017 $201.14 $202.84
90738 BGFOX LLC $166.32
Address 2234 EDINBURGH AVE
City/State/Zip TROPHY CLUB, TX 76262
Phone No.
Client GEO Code Client Property Code PTD Code Year Span Tax Due Total Due
42203277TAR R42203277TAR R 2017 $6.71 $9.74
42229993TAR R42229993T AR R 2017 $159.61 $231.75
····················-········
91111 ASAAD NEAL AND TRAN ASAAD KI.l\tl M $138.01
Address 2025 GRANADA TRL
City/State/Zip \VESTLAKE, TX 76262
.Phone No.
Client GEO Code Client Property Code PTD Code Year Span Tax Due Total Due
42110333TAR R42110333TAR R 2017 $138.01 $200.39
10/9/2018 11:33:13 AM Page 6 of19
October 15, 2018 Regular Meeting Agenda Packet
40 of 171
1769
Address
CAMPUS CIRCLE WESTLAKE LLC
29 COM.\10N\VEALTH AVE
City/State/Zip BOSTON, .MA 02116
Phone No.
Client GEO Code Client Property Code
41463978TAR R41463978TAR
PTD Code
R
91222 PENDERGRASS JIM E AND PENDERGRASS
CATHER
Address 1616 LIS-MORE CT
City/State/Zip ROANOKE, TX 76262
Client GEO Code Client Property Code PTD Code
4211 0589T AR R4211 0589T AR R
58 \VEINBERGER DELI T\VO LLC
Address 3 VILLAGE CIR STE 116
City/State/Zip WESTLAKE, TX 76262-7935
·Phone No.
Client GEO Code Client Property Code PTD Code
11514205TAR Pl1514205TAR p
1750 LYNCHHELENM
Address 207 CARNOUSTIE DR
City/State/Zip TROPHY CLUB, TX 76262-5462
Phone No.
Client GEO Code Client Property Code PTD Code
72370DEN R72370 R
1184 VERIZON
A.ddress 301 TROPHY LAKE DR UNIT 124
City/State/Zip ROANOKE, TX 76262
10/9/2018 11:33:13 AM
$134.49
Year Span Tax Due Total Due
2014-2017 $134.49 $224.88
$120.05
Year Span Tax Due Total Due
2017 $120.05 $174.31
$113.46
Year Span Tax Due Total Due
2016-2017 $113.46 $167.20
QPAY $106.05
Year Span Tax Due Total Due
2017 $106.05 $146.35
UP $82.41
Page 7 of19
October 15, 2018 Regular Meeting Agenda Packet
41 of 171
Phone No.
Client GEO Code Client Property Code
469054DEN P469054
90466 LA SCALA RISTORANTE ITALIANO
Addxess 1301 SOLANA BLVD STE 4115
City/State/Zip vVESTLAKE, TX 76262-1660
Client GEO Code Client Property Code
10755195TAR P1755195TAR
129 REMAX INTEGRITY
Address I 00 TROPHY CLUB DR STE. 1 02
City/State/Zip ROANOKE, TX 76262
.Phone No.
Client GEO Code Client Property Code
953826DEN P953826
130 POLO CLEANERS
2652 FM 407 E
City/State/Zip .ARGYLE, TX 76226
Phone No. (940) 241-1486
Client GEO Code Client Property Code
953833DEN P953833
57 J P TALBOT INSlJRANCE
Address PO BOX 93152
City/State/Zip SOUTHLAKE, TX 76092
Phone No.
10/9/2018 11:33:13 AM
PTD Code
p
PTD Code
p
PTD Code
p
PTD Code
p
Year Span Tax Due Total Due
2011-2013 $82.41 $178.44
$69.98
Year Span Tax Due Total Due
2017 $69.98 $101.61
UP $61.15
Year Span Tax Due Total Due
2007-2010 $61.15 $160.45
,, ... _. ... ,. '""""'""'"''""'''
UP $59.40
Year Span Tax Due Total Due
2008 $59.40 $156.43
UP $51.82
Page 8 of 19
October 15, 2018 Regular Meeting Agenda Packet
42 of 171
Client GEO Code Client Property Code
l0374248TAR P1374248TAR
1164 WALJI SHANIF Ivf
Address 504 N OAK ST STE 1
City/State/Zip ROANOKE, TX 76262-5005
Plume No.
Client GEO Code Client Property Code
336817DEN P336817
103 FIDELITY NATIONAL TITLE
Address 99 TROPHY CLUB DR
City/State/Zip TROPHY CLUB, TX 76262-5422
Plume No.
Client GEO Code Client Property Code
930792DEN P930792
1730 EARCARE HEARING AIDS
Address 501 TROPHY LAKE DR STE 318
City/State/Zip ROANOKE, TX 76262-5239
Phone No.
Client GEO Code Client Property Code
633172DEN P633172
1205 SHIRES BRENDA
Address 7 LAKE FOREST CT
City/State/Zip TROPHY CLUB, TX 76262-5504
Phone No.
Client GEO Code Client Property Code
70643DEN R7643
475 FIRST AMERICAN LEASING
10/9/2018 11:33:13 AM
PTD Code
p
PTD Code
p
PTD Code
p
PTD Code
p
PTD Code
R
Year Span Tax Due Total Due
2008-2011 $51.82 $130.18
UP $45.93
Year Span Tax Due Total Due
2014-2015 $45.93 $82.94
_. ... ,._ ... ,-..,.,.•.•y"""'
UP $42.70
Year Span Tax Due Total Due
2007-2008, 2010 $42.70 $112.29
UP $35.18
Year Span Tax Due Total Due
2014-2015 $35.18 $63.54
DEFE $30.88 D
Year Span Tax Due Total Due
2014 $30.88 $39.24
UP $29.05
Page 9 of 19
October 15, 2018 Regular Meeting Agenda Packet
43 of 171
Address PO BOX 168608
City/State/Zip IRVING, TX 75016-8608
Phone No.
Client GEO Code Client Property Code
13427849TAR P13427849TAR
•..• , • "' '""""""••n••••••
90369 FOOT PALACE SPA
.Address 301 TROPHY LAKE DR UNIT 124
City/State/Zip ROANOKE, TX 76262-5237
.Phone No.
Client GEO Code Client Property Code
656969DEN P656969
91071 TURNER CONSTRUCTION CO
Address 10100 N CENTRAL EXP\V STE 600
City/State/Zip DALLAS, TX 75231
Client GEO Code Client Property Code
14454543TAR Pl4454543TAR
741 MIJOL REALTY.COM
Address 100 INDIAN CREEK DR STE 120
City/State/Zip ROANOKE, TX 76262
Phone No.
Client GEO Code Client Property Code
336821DEN P336821
1711 STYLES OF INDIA
2003 SH 114, STE 340
City/State/Zip TROPHY CLUB, TX 76262
Phone No.
10/9/2018 11:33:13 AM
PTD Code Year Span Tax Due Total Due
p 2008 $29.05 $68.15
$25.14
PTD Code Year Span Tax Due Total Due
p 2015-2017 $25.14 $39.79
$20.46
PTD Code Year Span Tax Due Total Due
p 2017 $20.46 $29.71
UP $20.36
PTD Code Year Span Tax Due Total Due
p 2010-2011 $20.36 $48.70
$20.23
Page 10 of 19
October 15, 2018 Regular Meeting Agenda Packet
44 of 171
Client GEO Code Client Property Code
563646DEN P563646
'' "'¥""·-·w· ~··•· ···~·•··--••• •·•· ••
1530 DESIRE SALON & SPA
Address 2001 W SH 114 STE 150
C.ity/State/Zip TROPHY CLUB, TX 76262
Phone No.
Client GEO Code Client Property Code
499622DEN P499622
122 GARLITZ FINANCIAL SVCE
Address 103 SKYLINE DR
City/State/Zip ROANOKE, TX 76262
Phone No. (817) 491-1454
Client GEO Code Client Property Code
947758DEN P947758
90837 THE BRONZE BAR
Address 2003 E HIGHWAY 114 STE 400
City/State/Zip ROANOKE, TX 76262-6678
Phone No.
Client GEO Code Client Property Code
656967DEN P656967
887 TONY CAO SALON & SPA
Addxess 1901 LONG PRAIRIE RD STE 260
City/State/Zip FLOWER 1\10UND, TX 75022
Phone No.
Client GEO Code Client Property Code
953825DEN P953825
10/9/2018 11:33:13 AM
· PTD Code Year Span Tax Due Total Due
p 2015-2016 $20.23 $33.63
UP $16.51
PTD Code Year Span Tax Due Total Due
_p 2013 $16.51 $33.48
UP $15.18
PTD Code Year Span Tax Due Total Due
p 2007 $15.18 $42.07
$14.54
PTD Code Year Span Tax Due Total Due
p 2017 $14.54 S21.11
UP $13.48
PTD Code Year Span Tax Due Total Due
p 2011 $13.48 $31.22
Page 11 of 19
October 15, 2018 Regular Meeting Agenda Packet
45 of 171
190 WHITTON CONSTRUCTION INC
1241 CYPRESS CREEK CT
City/State/Zip SOUTHLAKE, TX 76092-4119
Phone No.
Client GEO Code Client Property Code
11457732TAR Pl1457732TAR
740 CJ HOOD CO INC
100 INDIAN CREEK DR
City/State/Zip TROPHY CLUB, TX 76262
Phone No.
Client GEO Code Client Property Code
336819DEN P336819
1284
Address
IBAHN GENERAL HOLDINGS CORP
1160 S PIONEER RD STE 5
City/State/Zip SALT LAKE CITY, UT 84104-3738
Phone No.
Client GEO Code Client Property Code
11648163TAR Pl1648163TAR
91068 HEART TEST LABORATORIES INC
Address 5611 COLLEYVILLE BLVD
City/State/Zip COLLEYviLLE, TX 76034
Phone No.
Client GEO Code Client Property Code
l3442112TAR P13442112TAR
875 CHRISTLIEB LA \V OFFICE
Address 3 LLANO DR
City/State/Zip ROANOKE, TX 76262
10/9/2018 11:33:13 AM
PTD Code
p
PTD Code
p
PTD Code
p
PTD Code
p
UP $11.56
Year Span Tax Due Total Due
2011 $11.56 $26.77
UP $10.73
Year Span Tax Due Total Due
2010 $10.73 $26.40
$6.48
Year Span Tax Due Total Due
2012-2013 $6.48 $13.65
$6.45
Year Span Tax Due Total Due
2017 $6.45 $9.37
UP $5.37
Page 12 of19
October 15, 2018 Regular Meeting Agenda Packet
46 of 171
Phone No.
Client GEO Code Client Property Code
925240DEN P925240
91141 CHIP 1\t1UNDY INC
Address 2003 E HW'{ 114
City/State/Zip ROANOKE, TX 76262
Phone No.
Client GEO Code Client Property Code
659388DEN P659388
1555 DONNA & ASSOCIATES
Address 99 TROPHY CLUB DR
City/State/Zip ROANOKE, TX 76262-5422
Phone .No.
Client GEO Code Client Property Code
566115DEN P566115
,__.,_.,, .. _.. ·-···· •··w~w.w.-· .. ~·-
90372 RAY DERSTEIN
99 TROPHY CLUB DR
City/State/Zip ROANOKE, TX 76262-5422
Phone No.
Client GEO Code Client Property Code
659398DEN P659398
1628 TROPHY CLUB TOVvN OF
Address 1 TROPHY WOOD DR
City/State/Zip ROANOKE, TX 76262
Phone No.
10/9/2018 11:33:13 AM
PTD Code
p
PTD Code
p
PTD Code
p
PTD Code
p
Year Span Tax Due Total Due
2010-2011 $5.37 $12.84
$4.85
Year Span Tax Due Total Due
2017 $4.85 $7.04
$4.40
Year Span Tax Due Total Due
2013 $4.40 $8.92
$3.61
Year Span Tax Due Total Due
2015 $3.61 $6.28
E $3.29
Page 13 of 19
October 15, 2018 Regular Meeting Agenda Packet
47 of 171
Client GEO Code Client Property Code
116598DEN R116598
116600DEN R116600
624324DEN R624324
624325DEN R624325
90423 D L PETERSON TRUST
POBOX 13085
City/State/Zip BALTIM.ORE, 1\tfD 21203-3085
l'hone No.
Client GEO Code Client Property Code
12675504TAR P12675504TAR
90303 RANDSTAD US LP
Address 150 PRESIDENTIAL FL 4 Vo./A Y
City/State/Zip \VOBURN, l\IIA 01801-1100
Client GEO Code Client Property Code
13730967TAR P13730967TAR
·~ W'o ,y""oYoo'•'•""•'•-'•Y'''" "''"'"""'""""~'' '' "" W•''•'''-"''''
90482 DAIICHI SANKYO INC
Address 2 HILTONCT
City/State/Zip PARSIPPANY, NJ 07054-4410
Phone No.
Client GEO Code Client Property Code
14511121TAR Pl4511121TAR
1329
Address
HELM INSURANCE AGENCY
99 TROPHY CLUB DR
City/State/Zip TROPHY CLUB, TX 76262-5422
Phone No.
10/9/2018 11:33:13 AM
PTD Code Year Span Tax Due Total Due
R 2014 $1.20 $2.26
R 2014 $1.11 $2.09
R 2014 $0.52 $0.98
R 2014 $0.46 $0.87
$2.88
PTD Code Year Span Tax Due Total Due
p 2015 $2.88 $4.91
$2.76
PTD Code Year Span Tax Due Total Due
p 2014-2015 $2.76 $4.87
$2.24
PTD Code Year Span Tax Due Total Due
p 2016 $2.24 $3.17
$0.87
Page 14 of 19
October 15, 2018 Regular Meeting Agenda Packet
48 of 171
Client GEO Code Client Property Code
335713DEN P335713
1588 BOICE SHON
3 GLENDALE CT
City/State/Zip TROPHY CLUB, TX 76262-5520
.Phone No.
Client GEO Code Client Property Code
72595DEN R 72595
90713 ROYAL CUP INC
Address PO BOX 170971
City/State/Zip BIRMINGHAM, AL 35217-0971
·Phone No.
Client GEO Code Client Property Code
1438071 OTAR P14380710TAR
91207
Address
DELL MARKETING LP
1 DELL WAY #RRl-35
City/State/Zip ROlTND ROCK, TX 78682-7000
Phone No.
Client GEO Code Client Property Code
14461451TAR P14461451 TAR
91052 BLOOMBERG LP
731 LEXINGTON AVE
City/State/Zip NEW YORK, NY 10022-1331
Phone No.
Client GEO Code Client Property Code
1 4460527TAR P14460527TAR
354 RS WATER HOLDING LLC
10/9/2018 11:33:13 AM
PTD Code
p
PTD Code
R
PTD Code
p
PTD Code
p
PTD Code
p
Year Span Tax Due Total Due
2012 $0.87 $1.89
QPAY $0.70
Year Span Tax Due Total Due
2017 $0.70 $0.97
$0.64
Year Span Tax Due Total Due
2015-2016 $0.64 $0.96
$0.61
Year Span Tax Due Total Due
2016 $0.61 $0.88
$0.57
Year Span Tax Due Total Due
2015-2016 $0.57 $0.83
, lJP $0.55
Page 15 of 19
October 15, 2018 Regular Meeting Agenda Packet
49 of 171
Address 3201 PREMIER DR STE 300
City/State/Zip IRVING, TX 75063-6075
Phone No.
Client GEO Code Client Property Code
14389563TAR Pl4389563TAR
14479384TAR Pl4479384TAR
90293
_A_ddress
FIRST DATA Mf,RCHANT SVCS INC
5755 DTC BLVD 4THFL
City/State/Zip GREENWOOD VILLAGE, CO 80111
Phone No.
Client GEO Code Client Property Code
143 70986T AR Pl4370986TAR
63
Address
PITNEY BO\\lES GLOBAL FINANCIAL
5310 CYPRESS CTR DR STE 110
City/State/Zip TAMPA, FL 33609-1041
Phone No.
Client GEO Code Client Property Code
14350063TAR P14350063TAR
1290 SONIFI SOLUTIONS INC
Address 3900 W IJ\i'NOVATION ST
City/State/ZiJl SIOUX FALLS, SD 57107-7002
Phone No.
Client GEO Code Client Property Code
14381350TAR Pl4381350TAR
91051
Address
AUTO-CHLOR SERVICES LLC
500 DAKIN ST
City/State/Z_ip JEFFERSON, LA 70121-4008
10/9/2018 11:33:13 AM
PTD Code Year Span Tax Due Total Due
p 2016 $0.46 $0.68
p 2016 $0.09 $0.13
$0.46
PTD Code Year Span Tax Due Total Due
p 2015-2016 $0.46 $0.69
$0.20
PTD Code Year Span Tax Due Total Due
p 2016 $0.20 $0.31
$0.15
PTD Code Year Span Tax Due Total Due
p 2015 $0.15 $0.23
$0.11
Page 16 of 19
October 15, 2018 Regular Meeting Agenda Packet
50 of 171
Phone No.
Client GEO Code Client Property Code
14384456TAR P14384456TAR
91045 AMERIGAS PROPANE LP
Address POBOX 798
City/State/Zip VALLEY FORGE, PA 19482-0798
Client GEO Code Client Property Code
14358803TAR P14358803TAR
1638 NAT'IONAL DEFAULT TITLE SERVICE
Address 1 FIRST AMERICAN \VA Y
City/State/Zip SANTA ANA, CA 92707
Client GEO Code Client Property Code
13661787T AR P13661787TAR
~· "·'~"" '·-·--··w·v~··""'
1163 FlJLL CIRCLE LOGISTICS
Address 99 TROPHY CLUB DR
City/State/Zip TROPHY CLUB, TX 76262-5422
Phone No.
Client GEO Code Client Property Code
335711 DEN P335711
91049 NEOPOST USA INC
Address 4 78 "/HEELERS FARMS RD
City/State/Zip MILFORD, CT 06461-91 05
Plume No.
10/9/2018 11:33:13 AM
PTD Code
p
PTD Code
p
PTD Code
p
PTD Code
p
Year Span Tax Due Total Due
2016 $0.1.1 $0.16
$0.10
Year Span Tax Due Total Due
2015-2016 $0.10 $0.15
$0.07
Year Span Tax Due Total Due
2017 $0.07 $0.10
$0.07
Year Span Tax Due Total Due
2011 $0.07 $0.16
$0.04
Page 17 of 19
October 15, 2018 Regular Meeting Agenda Packet
51 of 171
Client GEO Code Client Property Code PTD Code
14448870T AR Pl4448870TAR p
1497
.Address
THIBAULT LAWRENCE R & JEANNETTE E
111 LAKESIDE DR
City/State/Zip ROANOKE, TX 76262-5231
:Ph{rne No.
Client GEO Code Client Property Code
203807DEN R23807
893 BULAND RUDY A
Address 213 PHOENIX DR
City/State/Zip ROANOKE, TX 76262
Client GEO Code Client Property Code
72300DEN
90798 ROACH DAVID & SHARLA
Address 40XFORDPL
City/State/Zip TROPHY CLUB, TX 76262-5129
Phone No.
Client GEO Code Client Property Code
558563DEN R558563
91159 SMITH MILTON
A .. ddrcss 1120 SUNSET DR
City/State/Zip TROPHY CLUB, TX 76262
Plume No.
Client GEO Code Client Property Code
70021DEN R721
·········~·· .
91203 SISODIY A KAMLESH J AND SISODIY A
HARSHA
-10/9/2018 11:33:13 AM
PTD Code
R
PTD Code
R
PTD Code
R
PTD Code
R
Year Span Tax Due Total Due
2015 $0.04 $0.06
QPAY $0.02
Year Span Tax Due Total Due
2017 $0.02 $0.03
QPAY $0.01
Year Span Tax Due Total Due
2017 $0.01 $0.01
$0.01
Year Span Tax Due Total Due
2016 $0.01 $0.02
$0.01
Year Span Tax Due Total Due
2017 $0.01 $0.01
$0.01
Page 18 of 19
October 15, 2018 Regular Meeting Agenda Packet
52 of 171
Add:ress 7003 GLADWYNE CT
City/State/Zip COLLEYVILLE, TX 76034-6625
Phone No.
Client GEO Code Client Property Code
42110520TAR R421l0520TAR
73 Taxpayers
10/9/2018 11:33:13 AM
PTD Code Year Span Tax Due Total Due
R 2017 $0.01 $0.01
$26,178.77
Page 19 of 19
October 15, 2018 Regular Meeting Agenda Packet
53 of 171
Trophy Club Municipal Utility District No. 1I certify that this Investment Report complies with requirements of QUARTERLY INVESTMENT REPORTTCMUD's Investment Policy and the Public Funds Act. For Ending Period 09/30/2018 (July, August, and September 2018)John CarmanDATERstricted/Account orSec Rate /Call Purchase Begining Book Begining Market Ending Book Ending Market Gain/LossUnrestrictedCUSIPTypeParCoupon Maturity Date Price Yield % 6/30/20186/30/2018 9/30/2018 9/30/2018 End MV-End BVChecking & Money Market AccountsUnrestricted- 135XXX6372Bank of the West Money Market Account-$ 0.000% N/A N/A 100.000 0.000%715,223$ 715,223$ -$ -$ 0.00Unrestricted- 135XXX8701Prosperity Bank Consolidated Cash-General Fund 1,067,537$ 0.000% N/A N/A 100.0000.350%1,362,938$ 1,362,938$ 1,067,537$ 1,067,537$ 0.00Unrestricted- 122XXX8701Prosperity Bank Consolidated Cash-Fire Dept-$ 0.000% N/A N/A 100.000 0.350%60,743$ 60,743$ -$ -$ 0.00Restricted- 533XXX8701Prosperity Bank Consolidated Cash-Tax I&S4,573$ 0.000% N/A N/A 100.000 0.350%4,573$ 4,573$ 4,573$ 4,573$ 0.00Pools & Funds Unrestricted- 135XXXXX0002TexPool Municipal Fund-Operating3,227,798$ 0.000% N/A N/A 100.0001.950%2,261,972$ 2,261,972$ 3,227,798$ 3,227,798$ 0.00Restricted- 122TexPool Municipal Fund-Fire Dept543,883$ 0.000% N/A N/A 100.000 1.950%691,610$ 691,610$ 543,883$ 543,883$ 0.00Restricted- 137TexPool Municipal Fund-GASB Replacemenent596,426$ 0.000% N/A N/A 100.000 1.950%596,426$ 596,426$ 596,426$ 596,426$ 0.00Restricted- 533XXXXX0003TexPool Tax Debt Service48,716$ 0.000% N/A N/A 100.000 1.950%888,505$ 888,505$ 48,716$ 48,716$ 0.00Restricted- 517XXXXX00011TexPool WW Construction Tax-$ 0.000% N/A N/A 100.000 1.950%-$ -$ -$ -$ 0.00Restricted- 534XXXXX00013Texpool Revenue Bond I&S19,562$ 0.000% N/A N/A 100.000 1.950%396,346$ 396,346$ 19,562$ 19,562$ 0.00Restricted- 528XXXXX00014Texpool Revenue Bond Reserve606,910$ 0.000% N/A N/A 100.000 1.950%561,007$ 561,007$ 606,910$ 606,910$ 0.00Restricted- 519XXXXX00015Texpool Revenue Bond Construction-SWIFT-$ 0.000% N/A N/A 100.000 1.950%-$ -$ -$ -$ 0.00Restricted- 520XXXXX00016Texpool Revenue Bond Reserve-SWIFT-$ 0.000% N/A N/A 100.000 1.950%-$ -$ -$ -$ 0.00Restricted- 535XXXXX00017Texpool Revenue Bond I&S-SWIFT2,584$ 0.000% N/A N/A 100.000 1.950%197,971$ 197,971$ 2,584$ 2,584$ 0.00Savings Accounts RestrictedXXXXX7724Prosperity Bank Cash Reserve983,515$ 0.000% N/A N/A 100.000 0.400%782,658$ 782,658$ 983,515$ 983,515$ 0.00CD's NONEUS TreasuriesNONEUS Agencies NONE 7,101,504$ 8,519,972$ 8,519,972$ 7,101,504$ 7,101,504$ -$ EARNINGS SUMMARYRestricted/ Settle DateSec TypeAccount Number Par Coupon Maturity Qtr Accrued Qtr Amort. Total Qtr EarningsUnrestrictedChecking & Money Market AccountsUnrestricted- 135Bank of the West Money Market AccountXXX6372-$ N/A N/A309$ N/A309$ Unrestricted- 135 Prosperity Bank Consolidated Cash-General FundXXX8701 1,067,537$ N/A N/A 1,750$ N/A1,750$ Unrestricted- 122Prosperity Bank Consolidated Cash-Fire DeptXXX8701-$ N/A N/A-$ N/A-$ Restricted- 533Prosperity Bank Consolidated Cash-Tax I&SXXX87014,573$ N/A N/A-$ N/A-$ Pools & FundsUnrestricted TexPool Municipal FundXXXXX0002 4,368,107$ N/A N/A 18,332$ N/A18,332$ Restricted- 533 TexPool Tax Debt ServiceXXXXX0003 48,716$ N/A N/A 2,616$ N/A2,616$ Restricted- 517TexPool Construction TaxXXXXX00011-$ N/A N/A-$ N/A-$ Restricted- 534Texpool Revenue Bond I&SXXXXX00013 19,562$ N/A N/A 1,223$ N/A1,223$ Restricted- 528Texpool Revenue Bond ReserveXXXXX00014 606,910$ N/A N/A 2,820$ N/A2,820$ Restricted- 519Texpool Revenue Bond Construction-SWIFTXXXXX00015-$ N/A N/A-$ NA-$ Restricted- 520Texpool Revenue Bond Reserve-SWIFTXXXXX00016-$ N/A N/A-$ NA-$ Restricted- 535Texpool Revenue Bond I&S-SWIFTXXXXX00017 2,584$ N/A N/A594$ NA594$ Savings AccountsRestricted Prosperity Bank Cash ReserveXXXXX7724 983,515$ N/A N/A857$ N/A857$ CD'sNONEUS Treasuries NONE US Agencies NONE28,500$ N/A28,500$ PAR for this report is the statement balance on the last day of the quarterOctober 15, 2018 Regular Meeting Agenda Packet54 of 171
Project:Interconnect Prepared by:LMH
Client:TCMUD No.1 Date:10/10/2018
UNIT PRICE EXTENDED
PRICE
1 Mobilization (5% Max)LS 1 $129,000.00 $129,000.00
2 General Site Preparation STA 84 $1,500.00 $125,250.00
3 Construction Staking LS 1 $25,000.00 $25,000.00
4 Project Signs EA 2 $750.00 $1,500.00
5 SWPPP LS 1 $10,000.00 $10,000.00
6 Sawcut and Remove Concrete Pavement SY 1,357 $20.00 $27,140.00
7 Flexible Base (6")SY 1,424 $35.00 $49,840.00
8 Concrete Replacement (8")SY 1,357 $65.00 $88,205.00
9 12-Inch Waterline (C-900) (Open Cut)LF 522 $60.00 $31,320.00
10 14-Inch Waterline (C-900) (Open Cut)LF 127 $75.00 $9,525.00
11 16-Inch Waterline (C-900) (Open Cut)LF 2,385 $100.00 $238,500.00
12 18-Inch Waterline (C-900) (Open Cut)LF 2,678 $175.00 $468,650.00
13 Trench Safety LF 5,712 $3.00 $17,136.00
14 24-Inch Steel Casing Pipe LF 43 $250.00 $10,750.00
15 30-Inch Steel Casing Pipe LF 38 $275.00 $10,450.00
16 36-Inch Steel Casing Pipe LF 20 $300.00 $6,000.00
17 16-Inch Carrier Pipe in 30-Inch Steel Casing Pipe by OTOC LF 350 $500.00 $175,000.00
18 18-Inch Carrier Pipe in 36-Inch Steel Casing Pipe by OTOC LF 100 $875.00 $87,500.00
19 16-Inch Waterline (HDPE) (Directional Drill)LF 1,620 $475.00 $769,500.00
20 12-Inch Gate Valve EA 4 $2,000.00 $8,000.00
21 14-Inch Gate Valve EA 2 $5,000.00 $10,000.00
22 16-Inch Gate Valve EA 8 $12,500.00 $100,000.00
23 18-Inch Gate Valve EA 6 $15,000.00 $90,000.00
24 Blow-Off Valve (6")EA 3 $10,000.00 $30,000.00
25 Air Release Valve EA 3 $7,500.00 $22,500.00
26 Connect to Existing Water Line (12-Inch to 14-Inch)EA 1 $8,000.00 $8,000.00
27 Connect to Existing Water Line (14-Inch to 10-Inch)EA 1 $8,000.00 $8,000.00
28 Connect to Existing Water Line (12-Inch to 12-Inch)EA 1 $8,000.00 $8,000.00
29 Connect to Elevated Storage Tank EA 1 $10,000.00 $10,000.00
30 Sodding SY 8,169 $5.00 $40,845.00
31 Topsoil (4-Inches)SY 8,169 $3.00 $24,507.00
32 Silt Fence LF 4,902 $3.00 $14,706.00
33 Traffic Control LS 1 $50,000.00 $50,000.00
34 Storm Drain Junction Box (5'x3')EA 1 $5,000.00 $5,000.00
35 RCP (18")LF 12 $55.00 $660.00
Subtotal Section I $2,710,500
SUBTOTAL CONSTRUCTION $2,710,500
CONTINGENCY (10%)$271,050
TOTAL CONSTRUCTION $2,981,550
BASIC ENGINEERNIG SERVICES (SURVEYING AND ENGINEERING DESIGN)$357,500
RIGHT-OF-WAY ACQUISTION SERVICES (7 PARCELS)$121,088
CONSTRUCTION INSPECTION SERVICES $103,680
PROPERTY OWNER COMPENSATION FOR EASEMENTS $386,000
CONSTRUCTION MATERIAL TESTING (2.5%)$67,763
ISSUANCE COSTS $420,000
PROJECT TOTAL COST $4,437,581
ENGINEER'S STATEMENT OF PROBABLE COST
TROPHY CLUB MUD No.1
PRELIMINARY (50%) DESIGN
From HSPS to EST
NOTE: This statement was prepared utilizing standard cost and/or estimating practices. It is understood and agreed that this is a statement
of probable construction cost only, and the Engineer shall not be liable to the Owner or any Third Party for any failure to accurately estimate
the cost and/or quantities for the project, or any part thereof.
ITEM
NO.DESCRIPTION UNIT QTY
Engineer's Estimate
Section I - Water Line
Waterline Interconnect_Probable Cost for Board (10-10-2018)
HALFF ASSOCIATES, INC.
4000 Fossil Creek Boulevard
Fort Worth, Texas 76137
(817) 817-1422
1 of 1 10/10/2018
October 15, 2018 Regular Meeting Agenda Packet
55 of 171
STAFF REPORT
October 15, 2018
Agenda Item ‐ Consider and take appropriate action regarding approval of acquisition of a 2019
Dodge 1500 Quad Cab truck for the water department to be purchased through the Buy Board
contract at Grapevine Dodge Chrysler Jeep for an amount of $26,571.
Staff Report – This vehicle will replace the current on‐call truck a 2011 Ford F150. This vehicle
has over 70,000 miles and has required full brake replacement twice in the last twelve months.
Staff is noticing issues with the transmission and requested to have the new vehicle placed on
an agenda for approval. Anticipated delivery time from date of order is expected to be 3 – 4
months at which time the current on‐call vehicle will be 8 years old and have over 80,000 miles.
October 15, 2018 Regular Meeting Agenda Packet
56 of 171
16,993
kkkkk
End Use: TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 Rep: Dennis Thomas
Contact: MIKE MCMAHON Phone: 817‐410‐7541
Phone/Email: MMCMAHON@TCMUD.ORG Email: dthomas@grapevinedcj.com
Product Description: 2019 1500 QUAD CAB r1 Date: 10/02/2018
A. Bid Series 1500 QUAD CAB A. Base Price:
B. Published Options [Itemize each below]
Code Options Bid Price Code Options Bid Price
DS1L41 QUAD CAB 4X2 3756 27B 5.7L HEMI V8/8 SP AUTOMATIC 1892
DSA ANTI SPIN AXLE 480 AJY POPULAR EQUIPMENT GROUP 640
V9X8 CLOTH SEATING/CARPET 305PW7WHITE NC
AED EXTERIOR APPEARANCE GRP 674 TXN LT265/70R17E A/T TIRES 243
SPRAY BEDLINER INCL CLASS 4 HITCH INCL
RA2 UCONNECT 5.0 BLUETOOTH 674 AJB REMOTE START 383
CLF HD VINYL MATS 131
XAC BACKUP CAMERA INCL
Total of B. Published Options: 9,178
C. Unpublished Options $= 0.0%
Options Bid Price Options Bid Price
Total of C. Unpublished Options: ‐
D. Pre‐delivery Inspection:
E. Texas State Inspection: $
F. Manufacturer Destination/Delivery: $
G. Floor Plan Interest (for in‐stock and/or equipped vehicles): $
H. Lot Insurance (for in stock and/or equipped vehicles): $
I. Contract Price Adjustment:
J. Additional Delivery Charge: miles FOB GRAPEVINE
K. Subtotal: $ 26,171
L. Quantity Ordered x K = $
M. Trade in:
N. Buy Board fee $ 400
O. TOTAL PURCHASE PRICE $ 26,571
PRODUCT PRICING SUMMARY BASED ON CONTRACT
BUY BOARD 521‐16
Grapevine Dodge Chrysler Jeep 2601 William D Tate, Grapevine, TX 76051
October 15, 2018 Regular Meeting Agenda Packet
57 of 171
October 15, 2018 Regular Meeting Agenda Packet58 of 171
October 15, 2018 Regular Meeting Agenda Packet59 of 171
October 15, 2018 Regular Meeting Agenda Packet60 of 171
Agreement For Professional Services (Municipal Client‐Task Order) ‐ Page 1 of 4 _____________/________________
Revised 24 August 2018 Client Initial / Date
AGREEMENT FOR PROFESSIONAL ENGINEERING SERVICES ON A TASK ORDER BASIS
This Agreement for Professional Engineering Services, hereinafter called “Agreement,” is entered into by the Trophy
Club Municipal Utility District No. 1 a Municipal Utility District of the State of Texas, hereinafter referred to as
“Client”, duly authorized to act by the Board of Directors of said Client, and HALFF ASSOCIATES, INC., a Texas
corporation, acting through a duly authorized officer, herein called “Engineer,” relative to Engineer providing
professional engineering services to the Client. Client and Engineer when mentioned collectively shall be referred to
as the “Parties”.
W I T N E S S E T H:
For the mutual promises and benefits herein described, the Client and Engineer agree as follows:
I. Term of Agreement. This Agreement shall become effective on the date of its execution by both Parties, and shall
continue in effect thereafter until terminated as provided herein.
II. Services to be Performed by Engineer. Engineer shall provide to the Client basic engineering services on an “as
needed” or “task order” basis as determined by the Client which services may include, but will not be limited to, those
services normally rendered by an engineer to a similar client. It is anticipated that such services may include, but not be
limited to planning, surveying, project design, project development, and consultation regarding general engineering issues,
review of documentation, GIS services, database services, and defined construction phase services to assist the Client, as
determined by the Client. Engineer, upon specific written request by the Client, will prepare a detailed fee schedule for the
Client’s review and approval. Should the Client request, Engineer may agree to assist the Client in developing and preparing
a scope(s) of services responsive to a particular Task Order. Such task orders shall be bound by and interpreted by the
terms of this Agreement. Task Orders shall be numbered sequentially. Task Orders will be individual stand‐alone proposals
and when executed by both Parties shall incorporate the terms of this Agreement such that this Agreement shall be
amended. Engineer shall perform its obligations under this Agreement as an independent contractor and not as an agent
or fiduciary of any other party. Engineer shall not undertake any services prior to execution of a Task Order for such service s
executed by Client. This Agreement is non‐exclusive, and Client may retain other professional engineers to provide services
on Client’s behalf.
III. Compensation of Engineer. Client agrees that Engineer shall be paid for any services requested by the Client, at
the hourly rates or lump sum. Each Task Order shall specify the method of compensation applicable to the services
identified in the Task Order. The hourly rate will be Labor Costs times 2.3 multiplier. A range of hourly rates per position is
reflected in Exhibit A, attached hereto, plus reasonable and necessary reimbursable expenses (Direct Costs) incurred by
Engineer in the performance of the requested services. Direct costs shall include, but are not limited to, long distance
telephone, postage, equipment, expendables, mileage, subcontractors or special consultants, freight, testing fees, copies
and blueprints. See Exhibit B for the current Unit Pricing Schedule for direct costs. Direct Costs shall be billed at 1.1 times
actual costs. If additional services, trips or expenses are requested, Engineer will not provide such additional services until
authorized by the Client in writing to proceed.
Engineer agrees to submit monthly statements to the Client for basic professional engineering services. These
statements will be based upon Engineer’s actual services performed and reimbursable expenses incurred, if any, and the
Client shall endeavor to make prompt payments. Each monthly invoice submitted by Engineer to the Client shall be
reasonably itemized to show the amount of work performed during that month broken down by the identity of the person(s)
performing such work, the amount of time expended by such person(s) in performing that work, the billing rate for each
such person, and a brief summary of the work performed by each such person. If the Client fails to pay Engineer within
thirty (30) calendar days of the receipt of Engineer’s invoice, Engineer may, after giving ten (10) days written notice to the
Client, suspend professional engineering services until payment is received. Client agrees that Engineer shall be entitled to
interest on nondisputed accounts that are greater than 45 days and such interest shall be reimbursed to Engineer at a rate
of one percent (1%) per month. The assessment of interest on accounts receivable shall not preclude Engineer from
suspending services as described above.
IV. Client’s Obligations. The Client agrees that it will (i) designate a specific person to act as the Client’s
October 15, 2018 Regular Meeting Agenda Packet
61 of 171
Agreement For Professional Services (Municipal Client‐Task Order) ‐ Page 2 of 4 _____________/________________
Revised 24 August 2018 Client Initial / Date
representative, (ii) provide Engineer with any previous studies, reports, data, budget constraints, special Client
requirements, or other pertinent information known to the Client, when necessitated by a project, (iii) assist Engineer in
obtaining access to property necessary for performance of Engineer’s work for the Client, (iv) make prompt payments in
response to Engineer’s statements and (v) respond in a timely fashion to requests from Engineer. Engineer is entitled to
rely upon and use, without independent verification and without liability, all information and services provided by the Client
or the Client’s representatives.
V. Termination of Work ‐ The Client may terminate this Agreement at any time with or without cause upon giving
the other Party ten (10) calendar days’ prior written notice. Client agrees that termination of Engineer for Client’s
convenience shall only be utilized in good faith. Following Engineer’s receipt of such termination notice the Client shall,
within ten (10) calendar days of Client’s receipt of Engineer’s final invoice, pay the Engineer for all authorized services
rendered and all costs incurred up to the date of Engineer’s receipt of such notice of termination.
VI. Ownership of Documents ‐ Upon Engineer’s completion of services and receipt of payment in full, Engineer shall
grant to Client a non‐exclusive license to possess the final drawings and instruments produced in connection with Engineer’s
performance of the work under this Agreement, if any. Said drawings and instruments may be copied, duplicated,
reproduced and used by Client for the purpose of constructing, operating and maintaining the improvements. Client agrees
that such documents are not intended or represented to be suitable for reuse by Client or others for purposes outside the
Scope of Services of this Agreement. Notwithstanding the foregoing, Client understands and agrees that any and all
computer programs, GIS applications, proprietary data or processes, and standardized information related to the services
performable under this Agreement are and shall remain the sole and exclusive property of Engineer and may not be used
or reused, in any form, by Client without the express written authorization of Engineer. Client agrees that any reuse by
Client, or by those who obtain said information from or through Client, without written verification or adaptation by
Engineer, will be at Client’s sole risk and without liability or legal exposure to Engineer or to Engineer’s employees, agents,
representatives, officers, directors, affiliates, shareholders, owners, members, managers, attorneys, subsidiary entities,
advisors, subconsultants or independent contractors or associates. Engineer may reuse all drawings, reports, data and other
information developed in performing the services described by this Agreement in Engineer’s other activities.
VII. Notices. Any notices to be given hereunder by either party to the other may be affected either by personal
delivery, in writing, or by registered or certified mail.
VIII. Sole Parties and Entire Agreement. This Agreement shall not create any rights or benefits to anyone except the
Client and Engineer, and contains the entire agreement between the parties. Oral modifications to this Agreement shall
have no force or effect.
IX. Insurance. Engineer shall, at its own expense, purchase, maintain and keep in force throughout the duration of
this Agreement and for a period of four (4) years thereafter, professional liability insurance. The limits of liability shall be
$1,000,000 per claim and in the aggregate. Engineer shall submi t to the Client a certificate of insurance prior to commencing
work for the Client.
X. Prompt Performance by Engineer. All services provided by Engineer hereunder shall be performed in accordance
with the degree of care and skill ordinarily exercised under similar circumstances by competent members of the engineering
profession in the State of Texas applicable to such engineering services contemplated by this Agreement.
XI. Client Objection to Personnel. If at any time after entering into this Agreement, the Client has any reasonable
objection to any of Engineer’s personnel, or any personnel, professionals and/or consultants retained by Engineer, Engineer
shall promptly propose substitutes to whom the Client has no reasonable objection, and Engineer’s compensation shall be
equitably adjusted to reflect any difference in Engineer’s costs occasioned by such substitution.
XII. Assignment and Delegation. Neither the Client nor Engineer may assign their rights or delegate their duties
without the written consent of the other party. This Agreement is binding on the Client and Engineer to the fullest extent
permitted by law. Nothing herein is to be construed as creating any personal liability on the part of any Client officer,
employee or agent.
October 15, 2018 Regular Meeting Agenda Packet
62 of 171
Agreement For Professional Services (Municipal Client‐Task Order) ‐ Page 3 of 4 _____________/________________
Revised 24 August 2018 Client Initial / Date
XIII. Jurisdiction and Venue ‐ This Agreement shall be administered under the substantive laws of the State Texas (and
not its conflicts of law principles) which shall be used to govern all matters arising out of, or relating to, this Agreement and
all of the transactions it contemplates, including without limitation, its validity, interpretation, construction, performance
and enforcement. Venue shall lie exclusively in Denton and Tarrant County, Texas.
XIV. Integration, Merger and Severability – This Agreement and the authorized Task Orders are fully incorporated
herein and represent the entire understanding of Client and Engineer. No prior oral or written understanding shall be of
any force or effect with respect to those matters covered herein. The Agreement may not be modified or altered except in
writing signed by both Parties. This Agreement constitutes, represents and is intended by the Parties to be the complete
and final statement and expression of all of the terms and arrangements between the Parties to this Agreement with respect
to the matters provided for in this Agreement. This Agreement supersedes any and all prior or contemporaneous
agreements, understandings, negotiations, and discussions between the Parties and all such matters are merged into this
Agreement. Should any one or more of the provisions contained in this Agreement be determined by a court of competent
jurisdiction or by legislative pronouncement to be void, invalid, illegal, or unenforceable in any respect, such voiding,
invalidity, illegality, or unenforceability shall not affect any other provision hereof, and this Agreement shall be considered
as if the entirety of such void, invalid, illegal, or unenforceable provision had never been contained in this Agreement.
XV. Exclusivity of Remedies – The Parties acknowledge and agree that the remedies set forth in this Agreement,
including those set forth in Article XIX. Agreed Remedies are and shall remain the Parties’ sole and exclusive remedy with
respect to any claim arising from, or out of, or related to, the subject matter of this Agreement. The Parties agree that
Engineer is to have no liability or responsibility whatsoever to Client for any claim(s) or loss(es) of any nature, except as set
forth in this Agreement. No Party shall be able to avoid the limitations expressly set forth in this Agreement by electing to
pursue some other remedy.
XVI. Timeliness of Performance ‐ Engineer shall perform its professional services with due and reasonable diligence
consistent with sound professional practices.
XVII. Dispute Resolution. In the event of any disagreement or conflict concerning the interpretation of this Agreement,
and such disagreement cannot be resolved by the signatories hereto, the signatories agree to schedule a series of no less
than two meetings of senior personnel of Client and Engineer in which the disagreement or conflict will be discussed. The
first of such meetings will be scheduled as soon as possible following identification of such disagreement or conflict and the
second meeting must occur within thirty (30) days following the initial meeting. Subsequent meetings, if any may be
scheduled upon mutual agreement of the parties. The parties agree that these two meetings are conditions precedent to
the institution of legal proceedings unless such meetings will adversely affect the rights of one or more of the parties as
such rights relate to statutes of limitation or repose.
XVIII. Signatories. The Client and Engineer mutually warrant and represent that the representation of each who is
executing this Agreement on behalf of the Client or Engineer, respectively, has full authority to execute this Agreement and
bind the entity so represented.
XIX. PROJECT ENHANCEMENT ‐ IF DUE TO ANY ALLEGED OR ACTUAL BREACH OF CONTRACT, NEGLIGENCE, ERROR,
OR DEFICIENCY IN THE SERVICES OF ENGINEER OR ANY OF ITS CONSULTANTS, ANY ITEM, COMPONENT, OR CONDITION
OF THE SERVICES IS INACCURATE OR OMITTED FROM ANY OF THE DESIGN DOCUMENTS PRODUCED THROUGH
ENGINEER’S SERVICES, EGINEER’S AND ITS CONSULTANT’S LIABILITY, IF ANY, SHALL BE LIMITED TO THE DIFFERENCE
BETWEEN: I) THE COST OF ADDING, CORRECTING OR REPLACING THE ITEM AT THE TIME THE ERROR IS DISCOVERED, AND
II) THE COST HAD THE ITEM OR COMPONENT BEEN INCLUDED OR CORRECT IN THE DESIGN DOCUMENTS PROVIDED PRIOR
TO THE TIME CONSTRUCTION BEGAN. HOWEVER, IF THE CORRECTION TO THE DESIGN PROVIDES ADDED VALUE,
UPGRADE, OR ENHANCEMENT TO THE PROJECT OF CLIENT/OWNER, THE AMOUNT OF DAMAGES, IF ANY, SHALL BE
ADJUSTED DOWN BASED ON SUCH ADDED VALUE, UPGRADE, OR ENHANCEMENT OF THE PROJECT. CLIENT/OWNER
SHALL BE RESPONSIBLE FOR ANY COST OR EXPENSE ASSOCIATED WITH THE CORRECTION THAT PROVIDES ADDED VALUE,
UPGRADE, OR ENHANCEMENT OF THE PROJECT. IN NO EVENT AND REGARDLESS OF THE LEGAL THEORY OR FACTUAL
BASIS OF ANY CLAIM, SHALL ENGINEER’S OR ITS CONSULTANT’S LIABILITY INCLUDE ANY COST OR EXPENSE THAT
PROVIDES ADDED VALUE, UPGRADE, OR ENHANCEMENT OF THE PROJECT. IN ADDITION, IF ANY SUCH ITEM,
COMPONENT, OR CONDITION HAS AN IDENTIFIABLE USEFUL LIKE THAT IS LESS THAN THE BUILDING ITSELF, THE
DAMAGES OF THE CLIENT/OWNER SHALL BE REDUCED TO THE EXTENT THAT THE USEFUL LIFE OF THE COMPONENT WILL
October 15, 2018 Regular Meeting Agenda Packet
63 of 171
Agreement For Professional Services (Municipal Client‐Task Order) ‐ Page 4 of 4 _____________/________________
Revised 24 August 2018 Client Initial / Date
BE EXTENDED BY THE REPLACEMENT THEREOF. NOTWITHSTANDING THE FO REGOING OR ANY OTHER PROVISION HEREIN
TO THE CONTRARY, IN THE EVENT THAT ANY PROJECT OR WORK IS DEFECTIVE AND NEEDS TO BE CORRECTED DUE TO A
BREACH OF CONTRACT, NEGLIGENCE, ERROR OR DEFICIENCY IN THE SERVICES RENDERED BY ENGINEER, THE FOREGOING
LIMITATION OF LIABILITY SHALL NOT APPLY AND ENGINEER SHALL BE RESPONSIBLE FOR THE NON‐BETTERMENT COSTS
OF REPAIRING OR REPLACING SUCH DEFECTIVE WORK OR PROJECT.
XX. AGREED REMEDIES
A. IT IS THE INTENT OF THE PARTIES TO THIS AGREEMENT THAT ENGINEER'S SERVICES UNDER THIS AGREEMENT
SHALL NOT SUBJECT ENGINEER'S INDIVIDUAL EMPLOYEES, OFFICERS OR DIRECTORS TO ANY PERSONAL LEGAL EXPOSURE
FOR CLAIMS AND RISKS ASSOCIATED WITH THE SERVICES PERFORMED OR PERFORMABLE UNDER THIS AGREEMENT.
XXI. Waiver ‐ Any failure by either party to require strict compliance with any provision of this Agreement shall not be
construed as a waiver of such provision, and either party may subsequently require strict compliance at any time,
notwithstanding any prior failure to do so.
IN WITNESS WHEREOF, the parties, having read and understood this Agreement, have executed such in duplicate copies,
each of which shall have full dignity and force as an original, on the _____ day of _______________________, 20___.
HALFF ASSOCIATES, INC. CLIENT: TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
By: ______________________________ By: _______________________________
Signature Signature
______________________________ ________________________________
Printed Name Printed Name
______________________________ ________________________________
Title Title
______________________________ ________________________________
Date Date
October 15, 2018 Regular Meeting Agenda Packet
64 of 171
TROPHY CLUB MUD #1 - FIRE DEPARTMENT
BALANCE SHEET
SEPTEMBER 2018
122
ASSETS FIRE DEPT.
CASH IN BANK -
INVESTMENTS 543,883
PREPAID EXPENSES -
ADVALOREM PROPERTY TAXES RECEIVABLE 15,308
EMERGENCY SERVICES ASSESSMENTS RECEIVABLE -
UTILITY AND OTHER ACCOUNTS RECEIVABLE -
TOTAL ASSETS 559,191
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 15,308
ACCOUNTS AND OTHER PAYABLES -
TOTAL LIABILITIES 15,308
FUND BALANCE
DESIGNATED FOR FUTURE ASSET REPLACEMENT -
NON-SPENDABLE FUND BALANCE -
UNASSIGNED FUND BALANCE 522,253
RESERVE FOR ENCUMBRANCES -
NET REVENUES / EXPENDITURES 21,631
TOTAL FUND BALANCE 543,883
TOTAL LIABILITIES AND FUND BALANCE 559,191
October 15, 2018 Regular Meeting Agenda Packet
65 of 171
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 1
22:50 10/11/18 Budget Summary with Amendment
Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program:
Period Ending: 9/2018
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
122-40010-000-000 Property Taxes/MUD Fire 1,054,433.00- 1,054,433.00- 79.09- 1,066,060.62- 101.103 11,627.62
122-40011-000-000 Property Taxes/Fire-Delinquent 3,945.10- 3,945.10
122-40020-000-000 Property Taxes/Fire P&I 8.71- 4,786.64- 4,786.64
Subtotal: 1,054,433.00- 1,054,433.00- 87.80- 1,074,792.36- 101.931 20,359.36
Program number: 1,054,433.00- 1,054,433.00- 87.80- 1,074,792.36- 101.931 20,359.36
Department number: Fire Revenues 1,054,433.00- 1,054,433.00- 87.80- 1,074,792.36- 101.931 20,359.36
Revenues Subtotal ----------- 1,054,433.00- 1,054,433.00- 87.80- 1,074,792.36- 101.931 20,359.36
October 15, 2018 Regular Meeting Agenda Packet
66 of 171
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 2
22:50 10/11/18 Budget Summary with Amendment
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 9/2018
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
122-55080-045-000 Maintenance & Repairs 1,490.49 1,490.49-
Subtotal: 1,490.49 1,490.49-
122-60030-045-000 Rent And/Or Usage 218,954.00 218,954.00 218,954.00 100.000
122-60055-045-000 Insurance 18,000.00 18,000.00 1,269.84 15,238.41 84.658 2,761.59
122-60337-045-000 Transfer to Town/Fire Budget 608,910.00 608,910.00 50,742.50 608,910.00 100.000
Subtotal: 845,864.00 845,864.00 52,012.34 843,102.41 99.674 2,761.59
122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 81,420.00 81,420.00 100.000
122-69305-045-000 Capital Leases 127,149.00 127,149.00 127,148.60 100.000 .40
Subtotal: 208,569.00 208,569.00 208,568.60 100.000 .40
Program number: 1,054,433.00 1,054,433.00 52,012.34 1,053,161.50 99.879 1,271.50
Department number: Fire 1,054,433.00 1,054,433.00 52,012.34 1,053,161.50 99.879 1,271.50
Expenditures Subtotal ----------- 1,054,433.00 1,054,433.00 52,012.34 1,053,161.50 99.879 1,271.50
Fund number: 122 Trophy Club MUD Fire Dept. 51,924.54 21,630.86- 21,630.86
October 15, 2018 Regular Meeting Agenda Packet
67 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 1
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program:
Period Ending: 9/2018
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
2153 09/04/2018 Property Taxes (1,065,981.53) (54.72) (1,066,036.25) GL
2154 09/28/2018 Property Taxes (24.37) (1,066,060.62) GL
_______________
Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (79.09) (1,066,060.62) **
(1,054,433.00) Budgeted 11,627.62 Remaining 101 % Used
Account: 122-40011-000-000 Property Taxes/Fire-Delinquent
(3,945.10) .00 (3,945.10)
_______________
Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: .00 (3,945.10) **
.00 Budgeted 3,945.10 Remaining 0 % Used
Account: 122-40020-000-000 Property Taxes/Fire P&I
2153 09/04/2018 Property Taxes (4,777.93) (3.83) (4,781.76) GL
2154 09/28/2018 Property Taxes (4.88) (4,786.64) GL
_______________
Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (8.71) (4,786.64) **
.00 Budgeted 4,786.64 Remaining 0 % Used
Department Totals: ----------------------------------- (1,074,792.36) **
(87.80) Monthly Total (1,054,433.00) Budgeted 20,359.36 Remaining 102 % Used
October 15, 2018 Regular Meeting Agenda Packet
68 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 2
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 122-55080-045-000 Maintenance & Repairs
1,490.49 .00 1,490.49
_______________
Account: 122-55080-045-000 Maintenance & Repairs Totals: .00 1,490.49 **
.00 Budgeted (1,490.49) Remaining 0 % Used
Account: 122-60030-045-000 Rent And/Or Usage
218,954.00 .00 218,954.00
_______________
Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 218,954.00 **
218,954.00 Budgeted .00 Remaining 100 % Used
Account: 122-60055-045-000 Insurance
243 09/01/2018 Insurance/Wrk Comp Exp Sep 13,968.57 1,269.84 15,238.41 GL
_______________
Account: 122-60055-045-000 Insurance Totals: 1,269.84 15,238.41 **
18,000.00 Budgeted 2,761.59 Remaining 85 % Used
Account: 122-60337-045-000 Transfer to Town/Fire Budget
2034 09/07/2018 September A/P September Fire Admin 558,167.50 50,742.50 608,910.00 TOWN OF TROPHY CLUB 4552 AP
_______________
Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 50,742.50 608,910.00 **
608,910.00 Budgeted .00 Remaining 100 % Used
Account: 122-69195-045-000 GASB34/Reserve for Replacement
81,420.00 .00 81,420.00
_______________
Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 81,420.00 **
81,420.00 Budgeted .00 Remaining 100 % Used
Account: 122-69305-045-000 Capital Leases
127,148.60 .00 127,148.60
_______________
Account: 122-69305-045-000 Capital Leases Totals: .00 127,148.60 **
127,149.00 Budgeted .40 Remaining 100 % Used
Department 45 Totals: ----------------------------------- 1,053,161.50 **
52,012.34 Monthly Total 1,054,433.00 Budgeted 1,271.50 Remaining 100 % Used
October 15, 2018 Regular Meeting Agenda Packet
69 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 3
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Fund 122 Totals: ----------------------------------- (21,630.86)
51,924.54 Monthly Total .00 Budgeted 21,630.86 Remaining 0 % Used
October 15, 2018 Regular Meeting Agenda Packet
70 of 171
TROPHY CLUB MUD #1 - O&M
BALANCE SHEET
SEPTEMBER 2018
GTBGT 135 137
GENERAL FUND GASB TOTAL
ASSETS
CASH ON HAND 600 - 600
CASH IN BANK-CHECKING 1,379,652 - 1,379,652
CASH IN BANK-SAVINGS-CASH RESERVE 983,515 - 983,515
CD-BANK OF THE WEST/THB DEPOSIT - - -
INVESTMENTS-MONEY MARKET-BANK OF THE WEST - - -
INVESTMENTS-TEXPOOL 3,227,798 596,426 3,824,224
PREPAID EXPENSES 8,486 - 8,486
ADVALOREM PROPERTY TAXES RECEIVABLE 1,644 - 1,644
UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,473,411 - 1,473,411
TOTAL ASSETS 7,075,105 596,426 7,671,531
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 1,644 - 1,644
ACCOUNTS AND OTHER PAYABLES 308,547 - 308,547
CUSTOMER DEPOSITS 312,115 - 312,115
-
TOTAL LIABILITIES 622,306 - 622,306
FUND BALANCE
NON-SPENDABLE FUND BALANCE 3,486 3,486
ASSIGNED FUND BALANCE 1,778,760 1,778,760
ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 180,000 180,000
ASSIGNED FUND BALANCE/WATER REPLACEMENT 120,000 120,000
ASSIGNED FUND BALANCE/SEWER REPLACEMENT 67,805 67,805
ASSIGNED FUND BALANCE/FIRE DEPARTMENT 228,621 228,621
UNASSIGNED FUND BALANCE 2,368,122 - 2,368,122
COMMITTED FUND BALANCE - - -
NET REVENUES / EXPENDITURES 2,302,431 - 2,302,431
-
TOTAL FUND BALANCE 6,452,799 596,426 7,049,225
TOTAL LIABILITIES AND FUND BALANCE 7,075,105 596,426 7,671,531
October 15, 2018 Regular Meeting Agenda Packet
71 of 171
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 3
22:50 10/11/18 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 9/2018
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-40000-000-000 Property Taxes 120,950.00- 120,950.00- 9.08- 122,278.88- 101.099 1,328.88
135-40002-000-000 Property Taxes/Delinquent 200.00- 200.00- 347.07- 173.535 147.07
135-40015-000-000 Property Taxes/P & I 200.00- 200.00- .99- 530.33- 265.165 330.33
135-40025-000-000 PID Surcharges 177,839.00- 177,839.00- 177,839.00-
Subtotal: 299,189.00- 299,189.00- 10.07- 123,156.28- 41.163 176,032.72-
135-47000-000-000 Water 6,464,019.00- 6,464,019.00- 489,452.77- 5,953,140.59- 92.097 510,878.41-
135-47005-000-000 Sewer 2,978,067.00- 2,978,067.00- 258,662.34- 2,992,699.99- 100.491 14,632.99
135-47025-000-000 Penalties 106,279.00- 106,279.00- 16,306.53- 119,593.62- 112.528 13,314.62
135-47030-000-000 Service Charges 21,350.00- 14,350.00- 1,550.00- 13,880.50- 96.728 469.50-
135-47035-000-000 Plumbing Inspections 1,500.00- 1,500.00- 150.00- 2,200.00- 146.667 700.00
135-47045-000-000 Sewer Inspections 4,500.00- 4,500.00- 450.00- 5,800.00- 128.889 1,300.00
135-47070-000-000 TCCC Effluent Charges 60,000.00- 60,000.00- 5,025.60- 81,611.20- 136.019 21,611.20
Subtotal: 9,635,715.00- 9,628,715.00- 771,597.24- 9,168,925.90- 95.225 459,789.10-
135-49010-000-000 Interest Income 12,000.00- 50,000.00- 8,443.30- 58,856.46- 117.713 8,856.46
135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 1,178.81- 12,077.44- 110.539 1,151.44
135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.36- 6,999.99- 100.000 .01-
135-49026-000-000 Proceeds from Sale of Assets 2,000.00- 15,400.00- 15,400.00- 100.000
135-49075-000-000 Oversize Meter Reimbursement 18,179.00- 18,179.00- 1,029.00- 14,236.76- 78.314 3,942.24-
135-49141-000-000 Interfund Transfer In 796,145.00- 1,053,935.08 797,834.14- 100.212 1,689.14
135-49900-000-000 Miscellaneous Income 5,000.00- 15,000.00- 419.28 59,047.04- 393.647 44,047.04
135-49901-000-000 Records Management Revenue 20.00- 20.00- 2.00- 10.000 18.00-
135-49910-000-000 Reimbursement/Revenue Bond 260,000.00- 260,000.00- 260,000.00-
Subtotal: 315,125.00- 1,172,670.00- 1,043,119.89 964,453.83- 82.244 208,216.17-
Program number: 10,250,029.00- 11,100,574.00- 271,512.58 10,256,536.01- 92.396 844,037.99-
Department number: Revenues 10,250,029.00- 11,100,574.00- 271,512.58 10,256,536.01- 92.396 844,037.99-
Revenues Subtotal ----------- 10,250,029.00- 11,100,574.00- 271,512.58 10,256,536.01- 92.396 844,037.99-
October 15, 2018 Regular Meeting Agenda Packet
72 of 171
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 4
22:50 10/11/18 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 9/2018
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-50005-010-000 Salaries & Wages 274,279.00 274,279.00 26,095.72 234,283.97 85.418 39,995.03
135-50010-010-000 Overtime 20,000.00 20,000.00 1,191.16 14,133.01 70.665 5,866.99
135-50016-010-000 Longevity 3,425.00 3,425.00 3,310.00 96.642 115.00
135-50017-010-000 Certification 3,300.00 3,300.00 200.00 2,425.00 73.485 875.00
135-50020-010-000 Retirement 27,843.00 27,843.00 2,542.54 24,919.02 89.498 2,923.98
135-50026-010-000 Medical Insurance 52,196.00 52,196.00 2,948.80 32,815.76 62.870 19,380.24
135-50027-010-000 Dental Insurance 5,182.00 5,182.00 213.65 2,589.29 49.967 2,592.71
135-50028-010-000 Vision Insurance 994.00 994.00 35.92 459.83 46.261 534.17
135-50029-010-000 Life Insurance & Other 2,982.00 2,982.00 215.61 2,555.15 85.686 426.85
135-50030-010-000 Social Security Taxes 18,662.00 18,662.00 1,685.10 15,638.91 83.801 3,023.09
135-50035-010-000 Medicare Taxes 4,365.00 4,365.00 394.10 3,657.49 83.791 707.51
135-50040-010-000 Unemployment Taxes 1,080.00 1,080.00 818.68 75.804 261.32
135-50045-010-000 Workman's Compensation 11,854.00 11,854.00 899.88 10,799.00 91.100 1,055.00
135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 285.05 142.525 85.05-
135-50070-010-000 Employee Relations 300.00 300.00 138.84 178.13 59.377 121.87
Subtotal: 426,662.00 426,662.00 36,561.32 348,868.29 81.767 77,793.71
135-55005-010-000 Engineering 275,000.00
135-55080-010-000 Maintenance & Repairs 100,000.00 100,000.00 1,111.78 100,900.75 100.901 900.75-
135-55085-010-000 Generator Maint. and Repair 3,000.00 3,000.00 3,000.00
135-55090-010-000 Vehicle Maintenance 4,000.00 4,000.00 147.97 5,216.24 130.406 1,216.24-
135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 35.00 1.000 3,465.00
135-55135-010-000 Lab Analysis 5,500.00 5,500.00 817.70 7,412.86 134.779 1,912.86-
Subtotal: 391,000.00 116,000.00 2,077.45 113,564.85 97.901 2,435.15
135-60010-010-000 Communications/Mobiles 4,700.00 4,700.00 369.91 3,972.63 84.524 727.37
135-60020-010-000 Electricity 175,356.00 150,000.00 15,109.51 140,190.42 93.460 9,809.58
135-60066-010-000 Publications/Books/Subscripts 1,000.00 1,000.00 767.00 76.700 233.00
135-60070-010-000 Dues & Memberships 500.00 500.00 500.00
135-60080-010-000 Schools & Training 2,785.00 2,785.00 680.00 2,888.78 103.726 103.78-
135-60090-010-000 Safety Program 400.00 400.00 8.36 2.090 391.64
135-60100-010-000 Travel & per diem 1,735.00 1,735.00 87.48 5.042 1,647.52
135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 1,500.00
135-60135-010-000 TCEQ Fees & Permits 55,176.00 55,176.00 24,220.32 43.896 30,955.68
135-60150-010-000 Wholesale Water 2,823,170.00 2,823,170.00 291,820.90 2,162,163.82 76.586 661,006.18
135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00
135-60280-010-000 Property Maintenance 3,000.00 3,000.00 974.70 32.490 2,025.30
135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 750.00 11,250.00 76.271 3,500.00
135-60332-010-000 Interfund Transfer Out-Rev I&S 278,084.00 278,084.00 278,083.50 100.000 .50
135-60333-010-000 Interfund Transfer Out-Reserve 48,996.00 48,996.00 4,083.00 48,996.00 100.000
135-60334-010-000 Interfund Transfer Out 200,000.00 200,000.00 1,053,935.08- 200,000.00
135-60360-010-000 Furniture/Equipment < $5000 2,500.00 2,500.00 5,019.66 200.786 2,519.66-
October 15, 2018 Regular Meeting Agenda Packet
73 of 171
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 5
22:50 10/11/18 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 9/2018
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
Subtotal: 3,613,852.00 3,588,496.00 741,121.76- 2,678,622.67 74.645 909,873.33
135-65005-010-000 Fuel & Lube 15,000.00 15,000.00 993.47 11,207.95 74.720 3,792.05
135-65010-010-000 Uniforms 4,488.00 4,488.00 1,382.63 2,631.77 58.640 1,856.23
135-65030-010-000 Chemicals 20,000.00 20,000.00 1,603.29 18,687.20 93.436 1,312.80
135-65035-010-000 Small Tools 1,200.00 1,200.00 1,200.00
135-65040-010-000 Safety Equipment 1,000.00 1,000.00 1,080.95 108.095 80.95-
135-65050-010-000 Meter Expense 50,000.00 50,000.00 24,975.75 49.952 25,024.25
135-65053-010-000 Meter Change Out Program 84,000.00 84,000.00 82,312.50 97.991 1,687.50
Subtotal: 175,688.00 175,688.00 3,979.39 140,896.12 80.197 34,791.88
135-69005-010-000 Capital Outlays 810,012.00 1,085,012.00 79,244.33- 511,131.56 47.108 573,880.44
135-69008-010-000 Short Term Debt-Principal 38,731.00
135-69009-010-000 Short Term Debt-Interest 5,713.00 5,713.00 2,271.24 39.756 3,441.76
135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 75,000.00 75,000.00 100.000
135-69281-010-000 Water Tank Inspection Contract 118,775.00 110,001.00 107,864.38 98.058 2,136.62
Subtotal: 1,048,231.00 1,275,726.00 79,244.33- 696,267.18 54.578 579,458.82
Program number: 5,655,433.00 5,582,572.00 777,747.93- 3,978,219.11 71.261 1,604,352.89
October 15, 2018 Regular Meeting Agenda Packet
74 of 171
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 6
22:50 10/11/18 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID
Period Ending: 9/2018
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 367.70 1,752.78 87.639 247.22
Subtotal: 2,000.00 2,000.00 367.70 1,752.78 87.639 247.22
Program number: 1 Lab Analysis for PID 2,000.00 2,000.00 367.70 1,752.78 87.639 247.22
Department number: Water 5,657,433.00 5,584,572.00 777,380.23- 3,979,971.89 71.267 1,604,600.11
October 15, 2018 Regular Meeting Agenda Packet
75 of 171
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7
22:50 10/11/18 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 9/2018
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-50005-020-000 Salaries & Wages 410,866.00 410,866.00 25,205.59 349,759.54 85.127 61,106.46
135-50010-020-000 Overtime 30,000.00 30,000.00 2,706.07 33,380.39 111.268 3,380.39-
135-50016-020-000 Longevity 7,415.00 7,415.00 7,415.00 100.000
135-50017-020-000 Certification 8,400.00 8,400.00 700.00 8,436.00 100.429 36.00-
135-50020-020-000 Retirement 42,243.00 42,243.00 2,646.58 38,360.85 90.810 3,882.15
135-50026-020-000 Medical Insurance 62,175.00 62,175.00 5,518.69 65,584.02 105.483 3,409.02-
135-50027-020-000 Dental Insurance 5,271.00 5,271.00 371.89 4,691.74 89.010 579.26
135-50028-020-000 Vision Insurance 1,114.00 1,114.00 58.90 802.86 72.070 311.14
135-50029-020-000 Life Insurance & Other 4,281.00 4,281.00 321.20 4,168.88 97.381 112.12
135-50030-020-000 Social Security Taxes 28,314.00 28,314.00 1,593.24 22,807.95 80.554 5,506.05
135-50035-020-000 Medicare Taxes 6,622.00 6,622.00 372.62 5,334.11 80.551 1,287.89
135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 1,134.00 90.000 126.00
135-50045-020-000 Workman's Compensation 17,990.00 17,990.00 1,348.00 16,176.00 89.917 1,814.00
135-50060-020-000 Pre-emp Physicals/Testing 300.00 300.00 38.00 273.00 91.000 27.00
135-50070-020-000 Employee Relations 350.00 350.00 350.00
Subtotal: 626,601.00 626,601.00 40,880.78 558,324.34 89.104 68,276.66
135-55070-020-000 Independent Labor 20,550.00 5,550.00 2,145.00 38.649 3,405.00
135-55080-020-000 Maintenance & Repairs 86,100.00 86,100.00 4,747.50 82,754.50 96.114 3,345.50
135-55085-020-000 Generator Maint. and Repair 14,000.00 14,000.00 28.78 .206 13,971.22
135-55090-020-000 Vehicle Maintenance 8,000.00 8,000.00 149.70 9,821.71 122.771 1,821.71-
135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 395.40 79.080 104.60
135-55125-020-000 Dumpster Services 60,000.00 60,000.00 3,359.30 68,016.07 113.360 8,016.07-
135-55135-020-000 Lab Analysis 30,000.00 30,000.00 2,286.00 31,558.02 105.193 1,558.02-
Subtotal: 219,150.00 204,150.00 10,542.50 194,719.48 95.381 9,430.52
135-60010-020-000 Communications/Mobiles 4,700.00 4,700.00 381.26 4,843.51 103.053 143.51-
135-60020-020-000 Electricity 266,709.00 176,709.00 13,857.87 161,570.67 91.433 15,138.33
135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 200.00
135-60070-020-000 Dues & Memberships 300.00 300.00 60.00 20.000 240.00
135-60080-020-000 Schools & Training 5,677.00 5,677.00 658.00 11.591 5,019.00
135-60090-020-000 Safety Program 550.00 550.00 351.72 63.949 198.28
135-60100-020-000 Travel & per diem 1,635.00 1,635.00 90.46 5.533 1,544.54
135-60105-020-000 Rent/Lease Equipment 5,000.00 5,000.00 5,000.00
135-60125-020-000 Advertising 5,000.00 5,000.00 5,000.00
135-60135-020-000 TCEQ Fees & Permits 85,000.00 85,000.00 30,272.52 35.615 54,727.48
135-60245-020-000 Miscellaneous Expenses 450.00 450.00 .01 .002 449.99
135-60280-020-000 Property Maintenance 4,000.00 4,000.00 231.73 273.61 6.840 3,726.39
135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 590.00 8,730.00 75.259 2,870.00
135-60331-020-000 Interfund Transfer Out-Tax I&S 122,043.00 122,043.00 122,043.00 100.000
135-60332-020-000 Interfund Transfer Out-Rev I&S 598,738.00 598,738.00 598,738.00 100.000
135-60333-020-000 Interfund Transfer Out-Reserve 123,336.00 123,336.00 10,278.00 123,336.00 100.000
October 15, 2018 Regular Meeting Agenda Packet
76 of 171
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 8
22:50 10/11/18 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 9/2018
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-60334-020-000 Interfund Transfer Out 200,000.00 944,512.00 27,213.59 671,726.04 71.119 272,785.96
135-60360-020-000 Furniture/Equipment < $5000 4,000.00 4,000.00 1,762.00 44.050 2,238.00
Subtotal: 1,438,938.00 2,093,450.00 52,552.45 1,724,455.54 82.374 368,994.46
135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 812.01 8,932.87 71.463 3,567.13
135-65010-020-000 Uniforms 4,459.00 4,459.00 1,075.40 2,929.97 65.709 1,529.03
135-65030-020-000 Chemicals 27,500.00 27,500.00 4,957.86 19,715.59 71.693 7,784.41
135-65035-020-000 Small Tools 1,000.00 1,000.00 1,436.14 143.614 436.14-
135-65040-020-000 Safety Equipment 750.00 750.00 1,157.50 154.333 407.50-
135-65045-020-000 Lab Supplies 14,000.00 14,000.00 1,872.67 20,747.74 148.198 6,747.74-
Subtotal: 60,209.00 60,209.00 8,717.94 54,919.81 91.215 5,289.19
135-69005-020-000 Capital Outlays 547,327.00 547,327.00 85.00 108,729.29 19.866 438,597.71
135-69008-020-000 Short Term Debt-Principal 51,342.00
135-69009-020-000 Short Term Debt-Interest 7,573.00 7,573.00 3,010.73 39.756 4,562.27
135-69195-020-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 30,000.00 100.000
Subtotal: 636,242.00 584,900.00 85.00 141,740.02 24.233 443,159.98
Program number: 2,981,140.00 3,569,310.00 112,778.67 2,674,159.19 74.921 895,150.81
Department number: Wastewater 2,981,140.00 3,569,310.00 112,778.67 2,674,159.19 74.921 895,150.81
October 15, 2018 Regular Meeting Agenda Packet
77 of 171
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 9
22:50 10/11/18 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program:
Period Ending: 9/2018
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-50045-026-000 Workman's Compensation 30.00 30.00 2.38 29.00 96.667 1.00
Subtotal: 30.00 30.00 2.38 29.00 96.667 1.00
135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00
135-60070-026-000 Dues & Memberships 600.00 600.00 650.00 108.333 50.00-
135-60075-026-000 Meetings 1,200.00 1,200.00 31.74 135.00 11.250 1,065.00
135-60080-026-000 Schools & Training 4,000.00 4,000.00 2,755.00 68.875 1,245.00
135-60100-026-000 Travel & per diem 5,000.00 5,000.00 4,768.22 95.364 231.78
135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 1,473.98 73.699 526.02
Subtotal: 12,950.00 12,950.00 31.74 9,782.20 75.538 3,167.80
Program number: 12,980.00 12,980.00 34.12 9,811.20 75.587 3,168.80
Department number: Board of Directors 12,980.00 12,980.00 34.12 9,811.20 75.587 3,168.80
October 15, 2018 Regular Meeting Agenda Packet
78 of 171
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 10
22:50 10/11/18 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 9/2018
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-50005-030-000 Salaries & Wages 432,863.00 432,863.00 31,785.74 368,987.21 85.243 63,875.79
135-50010-030-000 Overtime 2,000.00 2,000.00 2.95 566.00 28.300 1,434.00
135-50016-030-000 Longevity 3,548.00 3,548.00 3,547.50 99.986 .50
135-50020-030-000 Retirement 40,553.00 40,553.00 2,940.44 36,818.75 90.792 3,734.25
135-50026-030-000 Medical Insurance 63,485.00 63,485.00 4,145.24 47,490.83 74.806 15,994.17
135-50027-030-000 Dental Insurance 5,502.00 5,502.00 259.52 3,276.89 59.558 2,225.11
135-50028-030-000 Vision Insurance 1,173.00 1,173.00 42.51 589.88 50.288 583.12
135-50029-030-000 Life Insurance & Other 5,059.00 5,059.00 282.49 3,716.55 73.464 1,342.45
135-50030-030-000 Social Security Taxes 27,181.00 27,181.00 1,892.22 22,201.40 81.680 4,979.60
135-50035-030-000 Medicare Taxes 6,357.00 6,357.00 442.53 5,192.25 81.678 1,164.75
135-50040-030-000 Unemployment Taxes 1,260.00 1,260.00 6.23 1,145.77 90.934 114.23
135-50045-030-000 Workman's Compensation 1,529.00 1,529.00 123.50 1,482.00 96.926 47.00
135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 211.90 42.380 288.10
135-50070-030-000 Employee Relations 4,960.00 4,960.00 3,273.18 65.992 1,686.82
Subtotal: 595,970.00 595,970.00 41,923.37 498,500.11 83.645 97,469.89
135-55030-030-000 Software & Support 78,391.00 78,391.00 1,929.11 68,007.47 86.754 10,383.53
135-55070-030-000 Independent Labor 154,000.00 154,000.00 14,150.30 153,669.10 99.785 330.90
135-55080-030-000 Maintenance & Repairs 14,000.00 14,000.00 5,183.13 10,583.61 75.597 3,416.39
135-55085-030-000 Generator Maint. and Repair 10,000.00 10,000.00 4,624.58 46.246 5,375.42
135-55120-030-000 Cleaning Services 10,000.00 10,000.00 869.06 9,176.75 91.768 823.25
135-55160-030-000 Professional Outside Services 63,325.00 63,325.00 3,060.00 62,300.00 98.381 1,025.00
135-55165-030-000 Collection Fees 200.00 200.00 200.00
135-55205-030-000 Utility Billing Contract 9,000.00 9,000.00 1,170.74 7,062.54 78.473 1,937.46
Subtotal: 338,916.00 338,916.00 26,362.34 315,424.05 93.069 23,491.95
135-60005-030-000 Telephone 27,300.00 17,300.00 3,016.78 18,245.89 105.468 945.89-
135-60010-030-000 Communications/Mobiles 4,000.00 4,000.00 237.33 2,986.16 74.654 1,013.84
135-60020-030-000 Electricity/Gas 16,261.00 16,261.00 602.05 6,590.97 40.532 9,670.03
135-60025-030-000 Water 2,500.00 2,500.00 58.32 718.83 28.753 1,781.17
135-60035-030-000 Postage 30,000.00 30,000.00 3,270.58 21,120.05 70.400 8,879.95
135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 6,639.91 62,305.61 112.141 6,745.61-
135-60050-030-000 Bad Debt Expense 1,500.00 1,500.00 1,500.00
135-60055-030-000 Insurance 56,000.00 56,000.00 6,100.33 76,999.29 137.499 20,999.29-
135-60066-030-000 Publications/Books/Subscripts 1,600.00 1,600.00 153.40 359.78 22.486 1,240.22
135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 3,988.42 66.474 2,011.58
135-60075-030-000 Meetings 400.00 400.00 133.56 33.390 266.44
135-60079-030-000 Public Education 6,000.00 6,000.00 6,000.00
135-60080-030-000 Schools & Training 7,600.00 7,600.00 3,238.00 42.605 4,362.00
135-60100-030-000 Travel & per diem 4,885.00 4,885.00 5.78 1,677.10 34.332 3,207.90
135-60110-030-000 Physicals/Testing 200.00 200.00 200.00
135-60115-030-000 Elections 4,500.00 4,500.00 220.00 4.889 4,280.00
October 15, 2018 Regular Meeting Agenda Packet
79 of 171
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 11
22:50 10/11/18 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 9/2018
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-60125-030-000 Advertising 2,500.00 2,500.00 625.00 925.00 37.000 1,575.00
135-60235-030-000 Security 2,700.00 2,700.00 24.00 442.00 16.370 2,258.00
135-60245-030-000 Miscellaneous Expenses 500.00 500.00 124.50 24.900 375.50
135-60246-030-000 General Manager Contingency 17,000.00 17,000.00 17,000.00 100.000
135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 211.99 8.480 2,288.01
Subtotal: 249,506.00 239,506.00 20,733.48 217,287.15 90.723 22,218.85
135-65010-030-000 Uniforms 700.00 700.00 473.72 747.45 106.779 47.45-
135-65055-030-000 Hardware 7,420.00 7,420.00 4,795.74 6,802.42 91.677 617.58
135-65085-030-000 Office Supplies 7,000.00 7,000.00 1,082.36 5,331.03 76.158 1,668.97
135-65090-030-000 Printer Supplies & Maintenance 2,000.00 2,000.00 2,365.05 118.253 365.05-
135-65095-030-000 Maintenance Supplies 4,000.00 4,000.00 401.91 4,198.62 104.966 198.62-
135-65105-030-000 Printing 4,000.00 4,000.00 144.00 3.600 3,856.00
Subtotal: 25,120.00 25,120.00 6,753.73 19,588.57 77.980 5,531.43
135-69005-030-000 Capital Outlays 13,000.00 13,000.00 48,354.99 371.961 35,354.99-
135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 668.74 3,231.05 70.240 1,368.95
Subtotal: 17,600.00 17,600.00 668.74 51,586.04 293.103 33,986.04-
Program number: 1,227,112.00 1,217,112.00 96,441.66 1,102,385.92 90.574 114,726.08
Department number: Administration 1,227,112.00 1,217,112.00 96,441.66 1,102,385.92 90.574 114,726.08
October 15, 2018 Regular Meeting Agenda Packet
80 of 171
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 12
22:50 10/11/18 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program:
Period Ending: 9/2018
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-55045-039-000 Legal 137,000.00 137,000.00 26,092.31 148,454.21 108.361 11,454.21-
135-55055-039-000 Auditing 24,500.00 24,500.00 25,658.70 104.729 1,158.70-
135-55060-039-000 Appraisal 11,446.00 11,446.00 2,011.87 10,695.79 93.446 750.21
135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,968.40 78.116 831.60
Subtotal: 176,746.00 176,746.00 28,104.18 187,777.10 106.241 11,031.10-
Program number: 176,746.00 176,746.00 28,104.18 187,777.10 106.241 11,031.10-
Department number: Non Departmental 176,746.00 176,746.00 28,104.18 187,777.10 106.241 11,031.10-
Expenditures Subtotal ----------- 10,055,411.00 10,560,720.00 540,021.60- 7,954,105.30 75.318 2,606,614.70
Fund number: 135 MUD 1 General Fund 194,618.00- 539,854.00- 268,509.02- 2,302,430.71- 426.491 1,762,576.71
October 15, 2018 Regular Meeting Agenda Packet
81 of 171
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 13
22:50 10/11/18 Budget Summary with Amendment
Fund: 137 MUD 1 Consolidated GASB Department: Program:
Period Ending: 9/2018
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
137-49145-000-000 Intergov Transfer-General Fund 105,000.00- 105,000.00
137-49146-000-000 Intergov Transfer-Fire Dept 81,420.00- 81,420.00
Subtotal: 186,420.00- 186,420.00
Program number: 186,420.00- 186,420.00
Department number: 186,420.00- 186,420.00
Revenues Subtotal ----------- 186,420.00- 186,420.00
Fund number: 137 MUD 1 Consolidated GASB 186,420.00- 186,420.00
October 15, 2018 Regular Meeting Agenda Packet
82 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 9/2018
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
2153 09/04/2018 Property Taxes (122,269.80) (6.28) (122,276.08) GL
2154 09/28/2018 Property Taxes (2.80) (122,278.88) GL
_______________
Account: 135-40000-000-000 Property Taxes Totals: (9.08) (122,278.88) **
(120,950.00) Budgeted 1,328.88 Remaining 101 % Used
Account: 135-40002-000-000 Property Taxes/Delinquent
(347.07) .00 (347.07)
_______________
Account: 135-40002-000-000 Property Taxes/Delinquent Totals: .00 (347.07) **
(200.00) Budgeted 147.07 Remaining 174 % Used
Account: 135-40015-000-000 Property Taxes/P & I
2153 09/04/2018 Property Taxes (529.34) (.44) (529.78) GL
2154 09/28/2018 Property Taxes (.55) (530.33) GL
_______________
Account: 135-40015-000-000 Property Taxes/P & I Totals: (.99) (530.33) **
(200.00) Budgeted 330.33 Remaining 265 % Used
Account: 135-40025-000-000 PID Surcharges
.00 .00
_______________
Account: 135-40025-000-000 PID Surcharges Totals: .00 .00 **
(177,839.00) Budgeted (177,839.00) Remaining 0 % Used
Account: 135-47000-000-000 Water
2103 09/18/2018 UB 09/18/2018 Payment Adjustme UB20180918-20180918 User: (5,463,687.82) 289.03 (5,463,398.79) UB
2115 09/24/2018 UB 09/24/2018 Water adjustment UB20180924-20180924 User: 239.94 (5,463,158.85) UB
2150 09/25/2018 222 oak Hill drive UB20180925-20180925 User: 534.48 (5,462,624.37) UB
2138 09/28/2018 Acct rfd-2850 Sherwood UB20180928-20180928 User: 439.89 (5,462,184.48) UB
2146 09/30/2018 UB 09/2018 Billing UB20180930-20180930 User: (490,956.11) (5,953,140.59) UB
_______________
Account: 135-47000-000-000 Water Totals: (489,452.77) (5,953,140.59) **
(6,464,019.00) Budgeted (510,878.41) Remaining 92 % Used
Account: 135-47005-000-000 Sewer
2150 09/25/2018 222 oak Hill drive UB20180925-20180925 User: (2,734,037.65) 79.12 (2,733,958.53) UB
October 15, 2018 Regular Meeting Agenda Packet
83 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 5
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
2146 09/30/2018 UB 09/2018 Billing UB20180930-20180930 User: (2,734,037.65) (258,741.46) (2,992,699.99) UB
_______________
Account: 135-47005-000-000 Sewer Totals: (258,662.34) (2,992,699.99) **
(2,978,067.00) Budgeted 14,632.99 Remaining 100 % Used
Account: 135-47025-000-000 Penalties
2026 09/06/2018 UB 09/06/2018 Penalty removal UB20180906-20180906 User: (103,287.09) 88.14 (103,198.95) UB
2109 09/21/2018 UB 09/21/2018 Penalties UB20180921-20180921 User: (22,752.51) (125,951.46) UB
2122 09/25/2018 UB 09/25/2018 Penalty removal UB20180925-20180925 User: 142.27 (125,809.19) UB
2129 09/27/2018 UB 09/27/2018 Penalty removal UB20180927-20180927 User: 6,157.89 (119,651.30) UB
2133 09/27/2018 UB 09/27/2018 Penalty Removal UB20180927-20180927 User: 43.53 (119,607.77) UB
2137 09/28/2018 UB 09/28/2018 Penalty removal UB20180928-20180928 User: 14.15 (119,593.62) UB
_______________
Account: 135-47025-000-000 Penalties Totals: (16,306.53) (119,593.62) **
(106,279.00) Budgeted 13,314.62 Remaining 113 % Used
Account: 135-47030-000-000 Service Charges
2005 09/05/2018 UB 09/05/2018 Disconnect Fees UB20180905-20180905 User: (12,330.50) (1,500.00) (13,830.50) UB
2107 09/20/2018 UB 09/20/2018 NSF check UB20180920-20180920 User: (25.00) (13,855.50) UB
2106 09/21/2018 UB 09/21/2018 NSF check UB20180921-20180921 User: (25.00) (13,880.50) UB
_______________
Account: 135-47030-000-000 Service Charges Totals: (1,550.00) (13,880.50) **
(14,350.00) Budgeted (469.50) Remaining 97 % Used
Account: 135-47035-000-000 Plumbing Inspections
2162 09/28/2018 Permits-650 Sheldon,4 Sadie C 650 Sheldon drive (2,050.00) (50.00) (2,100.00) Ashton Wood Homes CR
2162 09/28/2018 Permits-650 Sheldon,4 Sadie C 4 Sadie Court (50.00) (2,150.00) Drees Homes CR
2180 09/30/2018 Permits 26 Katie Lane 26 Katie Lane (50.00) (2,200.00) Drees Custom CR
_______________
Account: 135-47035-000-000 Plumbing Inspections Totals: (150.00) (2,200.00) **
(1,500.00) Budgeted 700.00 Remaining 147 % Used
Account: 135-47045-000-000 Sewer Inspections
2162 09/28/2018 Permits-650 Sheldon,4 Sadie C 650 Sheldon drive (5,350.00) (150.00) (5,500.00) Ashton Wood Homes CR
2162 09/28/2018 Permits-650 Sheldon,4 Sadie C 4 Sadie Court (150.00) (5,650.00) Drees Homes CR
2180 09/30/2018 Permits 26 Katie Lane 26 Katie Lane (150.00) (5,800.00) Drees Custom CR
_______________
Account: 135-47045-000-000 Sewer Inspections Totals: (450.00) (5,800.00) **
(4,500.00) Budgeted 1,300.00 Remaining 129 % Used
October 15, 2018 Regular Meeting Agenda Packet
84 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 6
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-47070-000-000 TCCC Effluent Charges
2146 09/30/2018 UB 09/2018 Billing UB20180930-20180930 User: (76,585.60) (5,025.60) (81,611.20) UB
_______________
Account: 135-47070-000-000 TCCC Effluent Charges Totals: (5,025.60) (81,611.20) **
(60,000.00) Budgeted 21,611.20 Remaining 136 % Used
Account: 135-49010-000-000 Interest Income
2155 09/30/2018 Bank Interest- September (50,413.16) (457.98) (50,871.14) GL
2155 09/30/2018 Bank Interest- September (7,286.80) (58,157.94) GL
2155 09/30/2018 Bank Interest- September (857.44) (59,015.38) GL
2171 09/30/2018 Recode THB CD Int from 06/18 158.92 (58,856.46) GL
_______________
Account: 135-49010-000-000 Interest Income Totals: (8,443.30) (58,856.46) **
(50,000.00) Budgeted 8,856.46 Remaining 118 % Used
Account: 135-49016-000-000 Cell Tower Revenue
2158 09/28/2018 Cell Tower Rev AT&T September (10,898.63) (1,178.81) (12,077.44) GL
_______________
Account: 135-49016-000-000 Cell Tower Revenue Totals: (1,178.81) (12,077.44) **
(10,926.00) Budgeted 1,151.44 Remaining 111 % Used
Account: 135-49018-000-000 Building Rent Income
2167 09/30/2018 Town Billed Invoices 1656-1659 AR 20180930-20180930 User: (6,416.63) (583.36) (6,999.99) AR
_______________
Account: 135-49018-000-000 Building Rent Income Totals: (583.36) (6,999.99) **
(7,000.00) Budgeted (.01) Remaining 100 % Used
Account: 135-49026-000-000 Proceeds from Sale of Assets
(15,400.00) .00 (15,400.00)
_______________
Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: .00 (15,400.00) **
(15,400.00) Budgeted .00 Remaining 100 % Used
Account: 135-49075-000-000 Oversize Meter Reimbursement
2162 09/28/2018 Permits-650 Sheldon,4 Sadie C 650 Sheldon drive (13,207.76) (343.00) (13,550.76) Ashton Wood Homes CR
2162 09/28/2018 Permits-650 Sheldon,4 Sadie C 4 Sadie Court (343.00) (13,893.76) Drees Homes CR
2180 09/30/2018 Permits 26 Katie Lane 26 Katie Lane (343.00) (14,236.76) Drees Custom CR
October 15, 2018 Regular Meeting Agenda Packet
85 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 7
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
_______________
Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (1,029.00) (14,236.76) **
(18,179.00) Budgeted (3,942.24) Remaining 78 % Used
Account: 135-49141-000-000 Interfund Transfer In
2065 09/30/2018 Correct Intrfd Trnsfr 519/135 (1,851,769.22) 1,053,935.08 (797,834.14) GL
_______________
Account: 135-49141-000-000 Interfund Transfer In Totals: 1,053,935.08 (797,834.14) **
(796,145.00) Budgeted 1,689.14 Remaining 100 % Used
Account: 135-49900-000-000 Miscellaneous Income
2138 09/28/2018 Acct rfd-2850 Sherwood UB20180928-20180928 User: (59,466.32) 550.00 (58,916.32) UB
2146 09/30/2018 UB 09/2018 Billing UB20180930-20180930 User: (130.72) (59,047.04) UB
_______________
Account: 135-49900-000-000 Miscellaneous Income Totals: 419.28 (59,047.04) **
(15,000.00) Budgeted 44,047.04 Remaining 394 % Used
Account: 135-49901-000-000 Records Management Revenue
(2.00) .00 (2.00)
_______________
Account: 135-49901-000-000 Records Management Revenue Totals: .00 (2.00) **
(20.00) Budgeted (18.00) Remaining 10 % Used
Account: 135-49910-000-000 Reimbursement/Revenue Bond
.00 .00
_______________
Account: 135-49910-000-000 Reimbursement/Revenue Bond Totals: .00 .00 **
(260,000.00) Budgeted (260,000.00) Remaining 0 % Used
Department Totals: ----------------------------------- (10,256,536.01) **
271,512.58 Monthly Total (11,100,574.00) Budgeted (844,037.99) Remaining 92 % Used
October 15, 2018 Regular Meeting Agenda Packet
86 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 8
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-50005-010-000 Salaries & Wages
2004 09/07/2018 MUD Payroll 09/07/2018 Salaries & Wages 208,188.25 10,140.46 218,328.71 PR
2089 09/21/2018 MUD Payroll 09/21/2018 Salaries & Wages 15,955.26 234,283.97 PR
_______________
Account: 135-50005-010-000 Salaries & Wages Totals: 26,095.72 234,283.97 **
274,279.00 Budgeted 39,995.03 Remaining 85 % Used
Account: 135-50010-010-000 Overtime
2004 09/07/2018 MUD Payroll 09/07/2018 Overtime 12,941.85 872.68 13,814.53 PR
2089 09/21/2018 MUD Payroll 09/21/2018 Overtime 318.48 14,133.01 PR
_______________
Account: 135-50010-010-000 Overtime Totals: 1,191.16 14,133.01 **
20,000.00 Budgeted 5,866.99 Remaining 71 % Used
Account: 135-50016-010-000 Longevity
3,310.00 .00 3,310.00
_______________
Account: 135-50016-010-000 Longevity Totals: .00 3,310.00 **
3,425.00 Budgeted 115.00 Remaining 97 % Used
Account: 135-50017-010-000 Certification
2089 09/21/2018 MUD Payroll 09/21/2018 Certification 2,225.00 200.00 2,425.00 PR
_______________
Account: 135-50017-010-000 Certification Totals: 200.00 2,425.00 **
3,300.00 Budgeted 875.00 Remaining 73 % Used
Account: 135-50020-010-000 Retirement
2004 09/07/2018 MUD Payroll 09/07/2018 Retirement 22,376.48 1,018.71 23,395.19 PR
2089 09/21/2018 MUD Payroll 09/21/2018 Retirement 1,523.83 24,919.02 PR
_______________
Account: 135-50020-010-000 Retirement Totals: 2,542.54 24,919.02 **
27,843.00 Budgeted 2,923.98 Remaining 89 % Used
Account: 135-50026-010-000 Medical Insurance
2004 09/07/2018 MUD Payroll 09/07/2018 Medical Insurance 29,866.96 1,474.40 31,341.36 PR
2089 09/21/2018 MUD Payroll 09/21/2018 Medical Insurance 1,474.40 32,815.76 PR
_______________
Account: 135-50026-010-000 Medical Insurance Totals: 2,948.80 32,815.76 **
52,196.00 Budgeted 19,380.24 Remaining 63 % Used
October 15, 2018 Regular Meeting Agenda Packet
87 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 9
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-50027-010-000 Dental Insurance
2004 09/07/2018 MUD Payroll 09/07/2018 Dental Insurance 2,375.64 106.85 2,482.49 PR
2089 09/21/2018 MUD Payroll 09/21/2018 Dental Insurance 106.80 2,589.29 PR
_______________
Account: 135-50027-010-000 Dental Insurance Totals: 213.65 2,589.29 **
5,182.00 Budgeted 2,592.71 Remaining 50 % Used
Account: 135-50028-010-000 Vision Insurance
2004 09/07/2018 MUD Payroll 09/07/2018 Vision Insurance 423.91 17.98 441.89 PR
2089 09/21/2018 MUD Payroll 09/21/2018 Vision Insurance 17.94 459.83 PR
_______________
Account: 135-50028-010-000 Vision Insurance Totals: 35.92 459.83 **
994.00 Budgeted 534.17 Remaining 46 % Used
Account: 135-50029-010-000 Life Insurance & Other
1930 09/01/2018 September A/P Employee benfits 2,339.54 110.60 2,450.14 Humana Inc 4481 AP
1981 09/01/2018 September A/P Employee benefits-September 87.01 2,537.15 METLIFE GROUP BENEFITS 4505 AP
2116 09/24/2018 September A/P Café 125 18.00 2,555.15 BenefitMall 4558 AP
_______________
Account: 135-50029-010-000 Life Insurance & Other Totals: 215.61 2,555.15 **
2,982.00 Budgeted 426.85 Remaining 86 % Used
Account: 135-50030-010-000 Social Security Taxes
2004 09/07/2018 MUD Payroll 09/07/2018 Social Security Taxes 13,953.81 675.78 14,629.59 PR
2089 09/21/2018 MUD Payroll 09/21/2018 Social Security Taxes 1,009.32 15,638.91 PR
_______________
Account: 135-50030-010-000 Social Security Taxes Totals: 1,685.10 15,638.91 **
18,662.00 Budgeted 3,023.09 Remaining 84 % Used
Account: 135-50035-010-000 Medicare Taxes
2004 09/07/2018 MUD Payroll 09/07/2018 Medicare Taxes 3,263.39 158.04 3,421.43 PR
2089 09/21/2018 MUD Payroll 09/21/2018 Medicare Taxes 236.06 3,657.49 PR
_______________
Account: 135-50035-010-000 Medicare Taxes Totals: 394.10 3,657.49 **
4,365.00 Budgeted 707.51 Remaining 84 % Used
Account: 135-50040-010-000 Unemployment Taxes
818.68 .00 818.68
October 15, 2018 Regular Meeting Agenda Packet
88 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
_______________
Account: 135-50040-010-000 Unemployment Taxes Totals: .00 818.68 **
1,080.00 Budgeted 261.32 Remaining 76 % Used
Account: 135-50045-010-000 Workman's Compensation
243 09/01/2018 Insurance/Wrk Comp Exp Sep 9,899.12 899.88 10,799.00 GL
_______________
Account: 135-50045-010-000 Workman's Compensation Totals: 899.88 10,799.00 **
11,854.00 Budgeted 1,055.00 Remaining 91 % Used
Account: 135-50060-010-000 Pre-emp Physicals/Testing
285.05 .00 285.05
_______________
Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 285.05 **
200.00 Budgeted (85.05) Remaining 143 % Used
Account: 135-50070-010-000 Employee Relations
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 TOM THUMB #1789 39.29 (1.19) 38.10 TOM THUMB #1789 PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 TOM THUMB #1789 119.49 157.59 TOM THUMB #1789 PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 DOLLARTREE 6.50 164.09 DOLLARTREE PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 WM SUPERCENTER #5247 14.04 178.13 WM SUPERCENTER #5247 PC
_______________
Account: 135-50070-010-000 Employee Relations Totals: 138.84 178.13 **
300.00 Budgeted 121.87 Remaining 59 % Used
Account: 135-55080-010-000 Maintenance & Repairs
2116 09/24/2018 September A/P 15A chlorine nozzle 99,788.97 475.25 100,264.22 SCOOP 4586 AP
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 THE HOME DEPOT #6581 19.12 100,283.34 THE HOME DEPOT #6581 PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 THE HOME DEPOT #6581 8.28 100,291.62 THE HOME DEPOT #6581 PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 THE HOME DEPOT #6581 25.59 100,317.21 THE HOME DEPOT #6581 PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ROANOKE AUTO SUPPLY LT 4.29 100,321.50 ROANOKE AUTO SUPPLY LT PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ROANOKE AUTO SUPPLY LT 199.99 100,521.49 ROANOKE AUTO SUPPLY LT PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ROANOKE AUTO SUPPLY LT 18.36 100,539.85 ROANOKE AUTO SUPPLY LT PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 FERGUSON ENT 1241 (93.01) 100,446.84 FERGUSON ENT 1241 PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 THE HOME DEPOT #6581 8.32 100,455.16 THE HOME DEPOT #6581 PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 TEX-TURF 185.60 100,640.76 TEX-TURF PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 THE HOME DEPOT #6581 6.96 100,647.72 THE HOME DEPOT #6581 PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 AMAZON.COM*MT1MV3TD2 30.44 100,678.16 AMAZON.COM*MT1MV3TD2 PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 TOM THUMB #3625 7.47 100,685.63 TOM THUMB #3625 PC
October 15, 2018 Regular Meeting Agenda Packet
89 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 HOMEDEPOT.COM 99,788.97 26.24 100,711.87 HOMEDEPOT.COM PC
2152 09/30/2018 September A/P 2" ball valves 188.88 100,900.75 Core & Main LP 4631 AP
_______________
Account: 135-55080-010-000 Maintenance & Repairs Totals: 1,111.78 100,900.75 **
100,000.00 Budgeted (900.75) Remaining 101 % Used
Account: 135-55085-010-000 Generator Maint. and Repair
.00 .00
_______________
Account: 135-55085-010-000 Generator Maint. and Repair Totals: .00 .00 **
3,000.00 Budgeted 3,000.00 Remaining 0 % Used
Account: 135-55090-010-000 Vehicle Maintenance
2160 09/30/2018 September A/P Battery, washer fluid 5,068.27 147.97 5,216.24 NAPA AUTO PARTS 4643 AP
_______________
Account: 135-55090-010-000 Vehicle Maintenance Totals: 147.97 5,216.24 **
4,000.00 Budgeted (1,216.24) Remaining 130 % Used
Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader
35.00 .00 35.00
_______________
Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 35.00 **
3,500.00 Budgeted 3,465.00 Remaining 1 % Used
Account: 135-55135-010-000 Lab Analysis
2116 09/24/2018 September A/P Water samples 6,595.16 410.00 7,005.16 TARRANT CTY PUBLIC HEALTH LAB 4588 AP
2116 09/24/2018 September A/P TCEQ sampling 207.70 7,212.86 LOWER COLORADO RIVER AUTHORITY 4580 AP
2173 09/30/2018 September A/P water samples 200.00 7,412.86 TARRANT CTY PUBLIC HEALTH LAB 4657 AP
_______________
Account: 135-55135-010-000 Lab Analysis Totals: 817.70 7,412.86 **
5,500.00 Budgeted (1,912.86) Remaining 135 % Used
Account: 135-60010-010-000 Communications/Mobiles
2116 09/24/2018 September A/P Cell phones 3,602.72 369.91 3,972.63 VERIZON WIRELESS 4595 AP
_______________
Account: 135-60010-010-000 Communications/Mobiles Totals: 369.91 3,972.63 **
4,700.00 Budgeted 727.37 Remaining 85 % Used
October 15, 2018 Regular Meeting Agenda Packet
90 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 12
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-60020-010-000 Electricity
2117 09/24/2018 September A/P Electricity 125,080.91 15,109.51 140,190.42 HUDSON ENERGY SERVICES, LLC 4573 AP
_______________
Account: 135-60020-010-000 Electricity Totals: 15,109.51 140,190.42 **
150,000.00 Budgeted 9,809.58 Remaining 93 % Used
Account: 135-60066-010-000 Publications/Books/Subscripts
767.00 .00 767.00
_______________
Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 767.00 **
1,000.00 Budgeted 233.00 Remaining 77 % 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
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 NCTCOG RTC TRAINING 2,208.78 165.00 2,373.78 NCTCOG RTC TRAINING PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 NCTCOG RTC TRAINING 165.00 2,538.78 NCTCOG RTC TRAINING PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 PAYPAL *TEXASWATERW 350.00 2,888.78 PAYPAL *TEXASWATERW PC
_______________
Account: 135-60080-010-000 Schools & Training Totals: 680.00 2,888.78 **
2,785.00 Budgeted (103.78) Remaining 104 % Used
Account: 135-60090-010-000 Safety Program
8.36 .00 8.36
_______________
Account: 135-60090-010-000 Safety Program Totals: .00 8.36 **
400.00 Budgeted 391.64 Remaining 2 % Used
Account: 135-60100-010-000 Travel & per diem
87.48 .00 87.48
_______________
Account: 135-60100-010-000 Travel & per diem Totals: .00 87.48 **
1,735.00 Budgeted 1,647.52 Remaining 5 % Used
October 15, 2018 Regular Meeting Agenda Packet
91 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 13
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-60105-010-000 Rent/Lease Equipment
.00 .00
_______________
Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 **
1,500.00 Budgeted 1,500.00 Remaining 0 % Used
Account: 135-60135-010-000 TCEQ Fees & Permits
24,220.32 .00 24,220.32
_______________
Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 24,220.32 **
55,176.00 Budgeted 30,955.68 Remaining 44 % Used
Account: 135-60150-010-000 Wholesale Water
2116 09/24/2018 September A/P Water 1,870,342.92 291,820.90 2,162,163.82 CITY OF FORT WORTH 4562 AP
_______________
Account: 135-60150-010-000 Wholesale Water Totals: 291,820.90 2,162,163.82 **
2,823,170.00 Budgeted 661,006.18 Remaining 77 % Used
Account: 135-60245-010-000 Miscellaneous Expenses
.00 .00
_______________
Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 **
200.00 Budgeted 200.00 Remaining 0 % Used
Account: 135-60280-010-000 Property Maintenance
974.70 .00 974.70
_______________
Account: 135-60280-010-000 Property Maintenance Totals: .00 974.70 **
3,000.00 Budgeted 2,025.30 Remaining 32 % Used
Account: 135-60285-010-000 Lawn Equipment & Maintenance
2152 09/30/2018 September A/P September mowing 10,500.00 750.00 11,250.00 WATTS ELLISON LLC 4651 AP
_______________
Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: 750.00 11,250.00 **
14,750.00 Budgeted 3,500.00 Remaining 76 % Used
Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S
October 15, 2018 Regular Meeting Agenda Packet
92 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 14
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
278,083.50 .00 278,083.50
_______________
Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S Totals: .00 278,083.50 **
278,084.00 Budgeted .50 Remaining 100 % Used
Account: 135-60333-010-000 Interfund Transfer Out-Reserve
2161 09/30/2018 Texpool Transfers September 44,913.00 4,083.00 48,996.00 GL
_______________
Account: 135-60333-010-000 Interfund Transfer Out-Reserve Totals: 4,083.00 48,996.00 **
48,996.00 Budgeted .00 Remaining 100 % Used
Account: 135-60334-010-000 Interfund Transfer Out
2065 09/30/2018 Correct Intrfd Trnsfr 519/135 1,053,935.08 (1,053,935.08) .00 GL
_______________
Account: 135-60334-010-000 Interfund Transfer Out Totals: (1,053,935.08) .00 **
200,000.00 Budgeted 200,000.00 Remaining 0 % Used
Account: 135-60360-010-000 Furniture/Equipment < $5000
5,019.66 .00 5,019.66
_______________
Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 5,019.66 **
2,500.00 Budgeted (2,519.66) Remaining 201 % Used
Account: 135-65005-010-000 Fuel & Lube
2139 09/28/2018 September A/p Fuel 10,214.48 993.47 11,207.95 US Bank Voyager Fleet Systems 4607 AP
_______________
Account: 135-65005-010-000 Fuel & Lube Totals: 993.47 11,207.95 **
15,000.00 Budgeted 3,792.05 Remaining 75 % Used
Account: 135-65010-010-000 Uniforms
2116 09/24/2018 September A/P uniforms 1,249.14 1,075.41 2,324.55 RON MONTGOMERY & ASSOC INC 4585 AP
2116 09/24/2018 September A/P uniforms 307.22 2,631.77 RON MONTGOMERY & ASSOC INC 4585 AP
_______________
Account: 135-65010-010-000 Uniforms Totals: 1,382.63 2,631.77 **
4,488.00 Budgeted 1,856.23 Remaining 59 % Used
Account: 135-65030-010-000 Chemicals
October 15, 2018 Regular Meeting Agenda Packet
93 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 15
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
2116 09/24/2018 September A/P Testing supplies 17,083.91 709.84 17,793.75 HACH COMPANY 4570 AP
2116 09/24/2018 September A/P Chlorine 893.45 18,687.20 DPC INDUSTRIES, INC 4568 AP
_______________
Account: 135-65030-010-000 Chemicals Totals: 1,603.29 18,687.20 **
20,000.00 Budgeted 1,312.80 Remaining 93 % Used
Account: 135-65035-010-000 Small Tools
.00 .00
_______________
Account: 135-65035-010-000 Small Tools Totals: .00 .00 **
1,200.00 Budgeted 1,200.00 Remaining 0 % Used
Account: 135-65040-010-000 Safety Equipment
1,080.95 .00 1,080.95
_______________
Account: 135-65040-010-000 Safety Equipment Totals: .00 1,080.95 **
1,000.00 Budgeted (80.95) Remaining 108 % Used
Account: 135-65050-010-000 Meter Expense
24,975.75 .00 24,975.75
_______________
Account: 135-65050-010-000 Meter Expense Totals: .00 24,975.75 **
50,000.00 Budgeted 25,024.25 Remaining 50 % Used
Account: 135-65053-010-000 Meter Change Out Program
82,312.50 .00 82,312.50
_______________
Account: 135-65053-010-000 Meter Change Out Program Totals: .00 82,312.50 **
84,000.00 Budgeted 1,687.50 Remaining 98 % Used
Account: 135-69005-010-000 Capital Outlays
2116 09/24/2018 September A/P 16" water line Phase I 590,375.89 115.26 590,491.15 Halff Associates, INC 4569 AP
2116 09/24/2018 September A/P 16" waterline Phase II 21,954.38 612,445.53 Halff Associates, INC 4569 AP
2116 09/24/2018 September A/P Scada panels 24,767.50 637,213.03 DHS AUTOMATION, INC 4566 AP
2123 09/25/2018 September A/P 16" water line phase I 1,543.00 638,756.03 Star-Telegram Media 4606 AP
2123 09/25/2018 September A/P Credit for double paying invoi (1,868.44) 636,887.59 Star-Telegram Media 4606 AP
2152 09/30/2018 September A/P Capitol projects 5,250.00 642,137.59 TEAGUE, NALL & PERKINS,INC 4647 AP
2174 09/30/2018 Due To/From -Fund 520 Sept 18 (157,313.85) 484,823.74 GL
October 15, 2018 Regular Meeting Agenda Packet
94 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
2179 09/30/2018 September A/P 16" water line 590,375.89 26,307.82 511,131.56 Halff Associates, INC 4661 AP
_______________
Account: 135-69005-010-000 Capital Outlays Totals: (79,244.33) 511,131.56 **
1,085,012.00 Budgeted 573,880.44 Remaining 47 % Used
Account: 135-69009-010-000 Short Term Debt-Interest
2,271.24 .00 2,271.24
_______________
Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 2,271.24 **
5,713.00 Budgeted 3,441.76 Remaining 40 % Used
Account: 135-69195-010-000 Gasb34/Reserve for Replacement
75,000.00 .00 75,000.00
_______________
Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 75,000.00 **
75,000.00 Budgeted .00 Remaining 100 % Used
Account: 135-69281-010-000 Water Tank Inspection Contract
107,864.38 .00 107,864.38
_______________
Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 107,864.38 **
110,001.00 Budgeted 2,136.62 Remaining 98 % Used
October 15, 2018 Regular Meeting Agenda Packet
95 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID
Period Ending: 9/2018
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-001 Lab Analysis for PID
2116 09/24/2018 September A/P water samples 1,385.08 80.00 1,465.08 TARRANT CTY PUBLIC HEALTH LAB 4588 AP
2116 09/24/2018 September A/P TCEQ samples PID 207.70 1,672.78 LOWER COLORADO RIVER AUTHORITY 4580 AP
2173 09/30/2018 September A/P Water samples-PID 80.00 1,752.78 TARRANT CTY PUBLIC HEALTH LAB 4657 AP
_______________
Account: 135-55135-010-001 Lab Analysis for PID Totals: 367.70 1,752.78 **
2,000.00 Budgeted 247.22 Remaining 88 % Used
Department 10 Totals: ----------------------------------- 3,979,971.89 **
(777,380.23) Monthly Total 5,584,572.00 Budgeted 1,604,600.11 Remaining 71 % Used
October 15, 2018 Regular Meeting Agenda Packet
96 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 18
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-50005-020-000 Salaries & Wages
2004 09/07/2018 MUD Payroll 09/07/2018 Salaries & Wages 324,553.95 12,602.79 337,156.74 PR
2089 09/21/2018 MUD Payroll 09/21/2018 Salaries & Wages 12,602.80 349,759.54 PR
_______________
Account: 135-50005-020-000 Salaries & Wages Totals: 25,205.59 349,759.54 **
410,866.00 Budgeted 61,106.46 Remaining 85 % Used
Account: 135-50010-020-000 Overtime
2004 09/07/2018 MUD Payroll 09/07/2018 Overtime 30,674.32 1,521.28 32,195.60 PR
2089 09/21/2018 MUD Payroll 09/21/2018 Overtime 1,184.79 33,380.39 PR
_______________
Account: 135-50010-020-000 Overtime Totals: 2,706.07 33,380.39 **
30,000.00 Budgeted (3,380.39) Remaining 111 % Used
Account: 135-50016-020-000 Longevity
7,415.00 .00 7,415.00
_______________
Account: 135-50016-020-000 Longevity Totals: .00 7,415.00 **
7,415.00 Budgeted .00 Remaining 100 % Used
Account: 135-50017-020-000 Certification
2089 09/21/2018 MUD Payroll 09/21/2018 Certification 7,736.00 700.00 8,436.00 PR
_______________
Account: 135-50017-020-000 Certification Totals: 700.00 8,436.00 **
8,400.00 Budgeted (36.00) Remaining 100 % Used
Account: 135-50020-020-000 Retirement
2004 09/07/2018 MUD Payroll 09/07/2018 Retirement 35,714.27 1,306.48 37,020.75 PR
2089 09/21/2018 MUD Payroll 09/21/2018 Retirement 1,340.10 38,360.85 PR
_______________
Account: 135-50020-020-000 Retirement Totals: 2,646.58 38,360.85 **
42,243.00 Budgeted 3,882.15 Remaining 91 % Used
Account: 135-50026-020-000 Medical Insurance
2004 09/07/2018 MUD Payroll 09/07/2018 Medical Insurance 60,065.33 2,759.36 62,824.69 PR
2089 09/21/2018 MUD Payroll 09/21/2018 Medical Insurance 2,759.33 65,584.02 PR
_______________
Account: 135-50026-020-000 Medical Insurance Totals: 5,518.69 65,584.02 **
62,175.00 Budgeted (3,409.02) Remaining 105 % Used
October 15, 2018 Regular Meeting Agenda Packet
97 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 19
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-50027-020-000 Dental Insurance
2004 09/07/2018 MUD Payroll 09/07/2018 Dental Insurance 4,319.85 185.96 4,505.81 PR
2089 09/21/2018 MUD Payroll 09/21/2018 Dental Insurance 185.93 4,691.74 PR
_______________
Account: 135-50027-020-000 Dental Insurance Totals: 371.89 4,691.74 **
5,271.00 Budgeted 579.26 Remaining 89 % Used
Account: 135-50028-020-000 Vision Insurance
2004 09/07/2018 MUD Payroll 09/07/2018 Vision Insurance 743.96 29.46 773.42 PR
2089 09/21/2018 MUD Payroll 09/21/2018 Vision Insurance 29.44 802.86 PR
_______________
Account: 135-50028-020-000 Vision Insurance Totals: 58.90 802.86 **
1,114.00 Budgeted 311.14 Remaining 72 % Used
Account: 135-50029-020-000 Life Insurance & Other
1930 09/01/2018 September A/P Employee benfits 3,847.68 164.36 4,012.04 Humana Inc 4481 AP
1981 09/01/2018 September A/P Employee benefits-September 120.84 4,132.88 METLIFE GROUP BENEFITS 4505 AP
2116 09/24/2018 September A/P Café 125 36.00 4,168.88 BenefitMall 4558 AP
_______________
Account: 135-50029-020-000 Life Insurance & Other Totals: 321.20 4,168.88 **
4,281.00 Budgeted 112.12 Remaining 97 % Used
Account: 135-50030-020-000 Social Security Taxes
2004 09/07/2018 MUD Payroll 09/07/2018 Social Security Taxes 21,214.71 796.78 22,011.49 PR
2089 09/21/2018 MUD Payroll 09/21/2018 Social Security Taxes 796.46 22,807.95 PR
_______________
Account: 135-50030-020-000 Social Security Taxes Totals: 1,593.24 22,807.95 **
28,314.00 Budgeted 5,506.05 Remaining 81 % Used
Account: 135-50035-020-000 Medicare Taxes
2004 09/07/2018 MUD Payroll 09/07/2018 Medicare Taxes 4,961.49 186.36 5,147.85 PR
2089 09/21/2018 MUD Payroll 09/21/2018 Medicare Taxes 186.26 5,334.11 PR
_______________
Account: 135-50035-020-000 Medicare Taxes Totals: 372.62 5,334.11 **
6,622.00 Budgeted 1,287.89 Remaining 81 % Used
Account: 135-50040-020-000 Unemployment Taxes
1,134.00 .00 1,134.00
October 15, 2018 Regular Meeting Agenda Packet
98 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
_______________
Account: 135-50040-020-000 Unemployment Taxes Totals: .00 1,134.00 **
1,260.00 Budgeted 126.00 Remaining 90 % Used
Account: 135-50045-020-000 Workman's Compensation
243 09/01/2018 Insurance/Wrk Comp Exp Sep 14,828.00 1,348.00 16,176.00 GL
_______________
Account: 135-50045-020-000 Workman's Compensation Totals: 1,348.00 16,176.00 **
17,990.00 Budgeted 1,814.00 Remaining 90 % Used
Account: 135-50060-020-000 Pre-emp Physicals/Testing
2116 09/24/2018 September A/P employee drug screen-Frank Iso 235.00 38.00 273.00 CARENOW CORPORATE 4560 AP
_______________
Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: 38.00 273.00 **
300.00 Budgeted 27.00 Remaining 91 % Used
Account: 135-50070-020-000 Employee Relations
.00 .00
_______________
Account: 135-50070-020-000 Employee Relations Totals: .00 .00 **
350.00 Budgeted 350.00 Remaining 0 % Used
Account: 135-55070-020-000 Independent Labor
2,145.00 .00 2,145.00
_______________
Account: 135-55070-020-000 Independent Labor Totals: .00 2,145.00 **
5,550.00 Budgeted 3,405.00 Remaining 39 % Used
Account: 135-55080-020-000 Maintenance & Repairs
2034 09/07/2018 September A/P Lift station uPS 78,007.00 492.25 78,499.25 DHS AUTOMATION, INC 4534 AP
2034 09/07/2018 September A/P Lift station UPS 752.25 79,251.50 DHS AUTOMATION, INC 4534 AP
2116 09/24/2018 September A/P Bags for augers 1,200.00 80,451.50 Huber Technology Inc 4571 AP
2116 09/24/2018 September A/P LS #3 pump parts 1,330.16 81,781.66 SMITH PUMP COMPANY, INC. 4587 AP
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 TELEDYNE INSTRUMENTS I (3.88) 81,777.78 TELEDYNE INSTRUMENTS I PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ROANOKE WINNELSON CO 25.28 81,803.06 ROANOKE WINNELSON CO PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 AMAZON.COM 515.50 82,318.56 AMAZON.COM PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 TELEDYNE INSTRUMENTS I (27.78) 82,290.78 TELEDYNE INSTRUMENTS I PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 THE HOME DEPOT #6581 48.76 82,339.54 THE HOME DEPOT #6581 PC
October 15, 2018 Regular Meeting Agenda Packet
99 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 TRACTOR SUPPLY COMPANY 78,007.00 29.99 82,369.53 TRACTOR SUPPLY COMPANY PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 THE HOME DEPOT 6581 99.83 82,469.36 THE HOME DEPOT 6581 PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ROYAL BRASS AND HOSE 36.62 82,505.98 ROYAL BRASS AND HOSE PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 THE HOME DEPOT #6581 8.70 82,514.68 THE HOME DEPOT #6581 PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 THE HOME DEPOT #6581 23.61 82,538.29 THE HOME DEPOT #6581 PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 THE HOME DEPOT #6581 17.40 82,555.69 THE HOME DEPOT #6581 PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 TRACTOR SUPPLY COMPANY 35.79 82,591.48 TRACTOR SUPPLY COMPANY PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 FERGUSON ENT 1241 163.02 82,754.50 FERGUSON ENT 1241 PC
_______________
Account: 135-55080-020-000 Maintenance & Repairs Totals: 4,747.50 82,754.50 **
86,100.00 Budgeted 3,345.50 Remaining 96 % Used
Account: 135-55085-020-000 Generator Maint. and Repair
28.78 .00 28.78
_______________
Account: 135-55085-020-000 Generator Maint. and Repair Totals: .00 28.78 **
14,000.00 Budgeted 13,971.22 Remaining 0 % Used
Account: 135-55090-020-000 Vehicle Maintenance
2152 09/30/2018 September A/P Clamps for vac truck 9,672.01 149.70 9,821.71 CLS SEWER EQUIPMENT CO., INC 4630 AP
_______________
Account: 135-55090-020-000 Vehicle Maintenance Totals: 149.70 9,821.71 **
8,000.00 Budgeted (1,821.71) Remaining 123 % Used
Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader
395.40 .00 395.40
_______________
Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 395.40 **
500.00 Budgeted 104.60 Remaining 79 % Used
Account: 135-55125-020-000 Dumpster Services
2117 09/24/2018 September A/P Dumpster services 64,656.77 914.29 65,571.06 L.H. CHANEY MATERIALS, INC. 4578 AP
2140 09/28/2018 September A/P dumpster services 849.65 66,420.71 L.H. CHANEY MATERIALS, INC. 4599 AP
2152 09/30/2018 September A/P Dumpster service 1,595.36 68,016.07 L.H. CHANEY MATERIALS, INC. 4641 AP
_______________
Account: 135-55125-020-000 Dumpster Services Totals: 3,359.30 68,016.07 **
60,000.00 Budgeted (8,016.07) Remaining 113 % Used
Account: 135-55135-020-000 Lab Analysis
October 15, 2018 Regular Meeting Agenda Packet
100 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
2020 09/05/2018 September A/P Effluent testing 29,272.02 246.00 29,518.02 OXIDOR LABORATORIES LLC 4521 AP
2020 09/05/2018 September A/P effluent testing 176.00 29,694.02 OXIDOR LABORATORIES LLC 4521 AP
2116 09/24/2018 September A/P Lab samples 246.00 29,940.02 OXIDOR LABORATORIES LLC 4584 AP
2116 09/24/2018 September A/P lab samples 176.00 30,116.02 OXIDOR LABORATORIES LLC 4584 AP
2116 09/24/2018 September A/P Lab testing 176.00 30,292.02 OXIDOR LABORATORIES LLC 4584 AP
2116 09/24/2018 September A/P Lab testing 246.00 30,538.02 OXIDOR LABORATORIES LLC 4584 AP
2140 09/28/2018 September A/P lab testing 176.00 30,714.02 OXIDOR LABORATORIES LLC 4605 AP
2140 09/28/2018 September A/P Lab testing 221.00 30,935.02 OXIDOR LABORATORIES LLC 4605 AP
2140 09/28/2018 September A/P lab testing 201.00 31,136.02 OXIDOR LABORATORIES LLC 4605 AP
2160 09/30/2018 September A/P lb testing 176.00 31,312.02 OXIDOR LABORATORIES LLC 4645 AP
2160 09/30/2018 September A/P lab testing 246.00 31,558.02 OXIDOR LABORATORIES LLC 4645 AP
_______________
Account: 135-55135-020-000 Lab Analysis Totals: 2,286.00 31,558.02 **
30,000.00 Budgeted (1,558.02) Remaining 105 % Used
Account: 135-60010-020-000 Communications/Mobiles
2116 09/24/2018 September A/P Cell phones 4,462.25 381.26 4,843.51 VERIZON WIRELESS 4595 AP
_______________
Account: 135-60010-020-000 Communications/Mobiles Totals: 381.26 4,843.51 **
4,700.00 Budgeted (143.51) Remaining 103 % Used
Account: 135-60020-020-000 Electricity
2116 09/24/2018 September A/P Electricity 7/26-8/24 147,712.80 63.88 147,776.68 TRI COUNTY ELECTRIC 4592 AP
2116 09/24/2018 September A/P Electricity 7/26-8/24 300.10 148,076.78 TRI COUNTY ELECTRIC 4592 AP
2116 09/24/2018 September A/P Electricity 7/26-8/24 27.83 148,104.61 TRI COUNTY ELECTRIC 4592 AP
2117 09/24/2018 September A/P Electricity 13,069.48 161,174.09 HUDSON ENERGY SERVICES, LLC 4573 AP
2167 09/30/2018 Town Billed Invoices 1656-1659 AR 20180930-20180930 User: (201.74) 160,972.35 AR
2178 09/30/2018 September A/P Electricity 8/24-9/25 168.73 161,141.08 TRI COUNTY ELECTRIC 4659 AP
2178 09/30/2018 September A/P Electricity 8/24-9/25 400.45 161,541.53 TRI COUNTY ELECTRIC 4659 AP
2178 09/30/2018 September A/P Electricity 8/24-9/25 29.14 161,570.67 TRI COUNTY ELECTRIC 4659 AP
_______________
Account: 135-60020-020-000 Electricity Totals: 13,857.87 161,570.67 **
176,709.00 Budgeted 15,138.33 Remaining 91 % 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
October 15, 2018 Regular Meeting Agenda Packet
101 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 23
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-60070-020-000 Dues & Memberships
60.00 .00 60.00
_______________
Account: 135-60070-020-000 Dues & Memberships Totals: .00 60.00 **
300.00 Budgeted 240.00 Remaining 20 % Used
Account: 135-60080-020-000 Schools & Training
658.00 .00 658.00
_______________
Account: 135-60080-020-000 Schools & Training Totals: .00 658.00 **
5,677.00 Budgeted 5,019.00 Remaining 12 % Used
Account: 135-60090-020-000 Safety Program
351.72 .00 351.72
_______________
Account: 135-60090-020-000 Safety Program Totals: .00 351.72 **
550.00 Budgeted 198.28 Remaining 64 % Used
Account: 135-60100-020-000 Travel & per diem
90.46 .00 90.46
_______________
Account: 135-60100-020-000 Travel & per diem Totals: .00 90.46 **
1,635.00 Budgeted 1,544.54 Remaining 6 % Used
Account: 135-60105-020-000 Rent/Lease Equipment
.00 .00
_______________
Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 .00 **
5,000.00 Budgeted 5,000.00 Remaining 0 % Used
Account: 135-60125-020-000 Advertising
.00 .00
_______________
Account: 135-60125-020-000 Advertising Totals: .00 .00 **
5,000.00 Budgeted 5,000.00 Remaining 0 % Used
Account: 135-60135-020-000 TCEQ Fees & Permits
October 15, 2018 Regular Meeting Agenda Packet
102 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 24
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
30,272.52 .00 30,272.52
_______________
Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 30,272.52 **
85,000.00 Budgeted 54,727.48 Remaining 36 % Used
Account: 135-60245-020-000 Miscellaneous Expenses
.01 .00 .01
_______________
Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .01 **
450.00 Budgeted 449.99 Remaining 0 % Used
Account: 135-60280-020-000 Property Maintenance
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 WM SUPERCENTER #5247 41.88 26.80 68.68 WM SUPERCENTER #5247 PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 TRACTOR SUPPLY COMPANY 204.93 273.61 TRACTOR SUPPLY COMPANY PC
_______________
Account: 135-60280-020-000 Property Maintenance Totals: 231.73 273.61 **
4,000.00 Budgeted 3,726.39 Remaining 7 % Used
Account: 135-60285-020-000 Lawn Equipment & Maintenance
2152 09/30/2018 September A/P September mowing 8,140.00 590.00 8,730.00 WATTS ELLISON LLC 4651 AP
_______________
Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 590.00 8,730.00 **
11,600.00 Budgeted 2,870.00 Remaining 75 % Used
Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S
122,043.00 .00 122,043.00
_______________
Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: .00 122,043.00 **
122,043.00 Budgeted .00 Remaining 100 % Used
Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S
598,738.00 .00 598,738.00
_______________
Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: .00 598,738.00 **
598,738.00 Budgeted .00 Remaining 100 % Used
Account: 135-60333-020-000 Interfund Transfer Out-Reserve
October 15, 2018 Regular Meeting Agenda Packet
103 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
2161 09/30/2018 Texpool Transfers September 113,058.00 10,278.00 123,336.00 GL
_______________
Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 10,278.00 123,336.00 **
123,336.00 Budgeted .00 Remaining 100 % Used
Account: 135-60334-020-000 Interfund Transfer Out
2161 09/30/2018 Texpool Transfers September 644,512.45 27,213.59 671,726.04 GL
_______________
Account: 135-60334-020-000 Interfund Transfer Out Totals: 27,213.59 671,726.04 **
944,512.00 Budgeted 272,785.96 Remaining 71 % Used
Account: 135-60360-020-000 Furniture/Equipment < $5000
1,762.00 .00 1,762.00
_______________
Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: .00 1,762.00 **
4,000.00 Budgeted 2,238.00 Remaining 44 % Used
Account: 135-65005-020-000 Fuel & Lube
2139 09/28/2018 September A/p Fuel 8,120.86 812.01 8,932.87 US Bank Voyager Fleet Systems 4607 AP
_______________
Account: 135-65005-020-000 Fuel & Lube Totals: 812.01 8,932.87 **
12,500.00 Budgeted 3,567.13 Remaining 71 % Used
Account: 135-65010-020-000 Uniforms
2116 09/24/2018 September A/P uniforms 1,854.57 1,075.40 2,929.97 RON MONTGOMERY & ASSOC INC 4585 AP
_______________
Account: 135-65010-020-000 Uniforms Totals: 1,075.40 2,929.97 **
4,459.00 Budgeted 1,529.03 Remaining 66 % Used
Account: 135-65030-020-000 Chemicals
2116 09/24/2018 September A/P CIP solution 14,757.73 536.00 15,293.73 Valley Solvent Company, INC 4594 AP
2117 09/24/2018 September A/P Collection chemicals 3,379.50 18,673.23 MICKEY D CARSON DBA/NUSCO 4582 AP
2140 09/28/2018 September A/P CIP solution 1,042.36 19,715.59 Valley Solvent Company, INC 4608 AP
_______________
Account: 135-65030-020-000 Chemicals Totals: 4,957.86 19,715.59 **
27,500.00 Budgeted 7,784.41 Remaining 72 % Used
Account: 135-65035-020-000 Small Tools
October 15, 2018 Regular Meeting Agenda Packet
104 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
1,436.14 .00 1,436.14
_______________
Account: 135-65035-020-000 Small Tools Totals: .00 1,436.14 **
1,000.00 Budgeted (436.14) Remaining 144 % Used
Account: 135-65040-020-000 Safety Equipment
1,157.50 .00 1,157.50
_______________
Account: 135-65040-020-000 Safety Equipment Totals: .00 1,157.50 **
750.00 Budgeted (407.50) Remaining 154 % Used
Account: 135-65045-020-000 Lab Supplies
2116 09/24/2018 September A/P Lab supplies 18,875.07 352.74 19,227.81 HACH COMPANY 4570 AP
2116 09/24/2018 September A/P Sampling supplies 1,318.20 20,546.01 IDEXX DISTRIBUTION, INC 4574 AP
2116 09/24/2018 September A/P sampling supplies 197.77 20,743.78 IDEXX DISTRIBUTION, INC 4574 AP
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 TOM THUMB #1789 3.96 20,747.74 TOM THUMB #1789 PC
_______________
Account: 135-65045-020-000 Lab Supplies Totals: 1,872.67 20,747.74 **
14,000.00 Budgeted (6,747.74) Remaining 148 % Used
Account: 135-69005-020-000 Capital Outlays
2140 09/28/2018 September A/P Legal WWTP 108,644.29 85.00 108,729.29 Dubois Bryant Campbell LLP 4598 AP
_______________
Account: 135-69005-020-000 Capital Outlays Totals: 85.00 108,729.29 **
547,327.00 Budgeted 438,597.71 Remaining 20 % Used
Account: 135-69009-020-000 Short Term Debt-Interest
3,010.73 .00 3,010.73
_______________
Account: 135-69009-020-000 Short Term Debt-Interest Totals: .00 3,010.73 **
7,573.00 Budgeted 4,562.27 Remaining 40 % Used
Account: 135-69195-020-000 Gasb34/Reserve for Replacement
30,000.00 .00 30,000.00
_______________
Account: 135-69195-020-000 Gasb34/Reserve for Replacement Totals: .00 30,000.00 **
30,000.00 Budgeted .00 Remaining 100 % Used
October 15, 2018 Regular Meeting Agenda Packet
105 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Department 20 Totals: ----------------------------------- 2,674,159.19 **
112,778.67 Monthly Total 3,569,310.00 Budgeted 895,150.81 Remaining 75 % Used
October 15, 2018 Regular Meeting Agenda Packet
106 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 28
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program:
Period Ending: 9/2018
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
243 09/01/2018 Insurance/Wrk Comp Exp Sep 26.62 2.38 29.00 GL
_______________
Account: 135-50045-026-000 Workman's Compensation Totals: 2.38 29.00 **
30.00 Budgeted 1.00 Remaining 97 % Used
Account: 135-60066-026-000 Publications/Books/Subscripts
.00 .00
_______________
Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 **
150.00 Budgeted 150.00 Remaining 0 % Used
Account: 135-60070-026-000 Dues & Memberships
650.00 .00 650.00
_______________
Account: 135-60070-026-000 Dues & Memberships Totals: .00 650.00 **
600.00 Budgeted (50.00) Remaining 108 % Used
Account: 135-60075-026-000 Meetings
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 TOM THUMB #2580 103.26 31.74 135.00 TOM THUMB #2580 PC
_______________
Account: 135-60075-026-000 Meetings Totals: 31.74 135.00 **
1,200.00 Budgeted 1,065.00 Remaining 11 % Used
Account: 135-60080-026-000 Schools & Training
2,755.00 .00 2,755.00
_______________
Account: 135-60080-026-000 Schools & Training Totals: .00 2,755.00 **
4,000.00 Budgeted 1,245.00 Remaining 69 % Used
Account: 135-60100-026-000 Travel & per diem
4,768.22 .00 4,768.22
_______________
Account: 135-60100-026-000 Travel & per diem Totals: .00 4,768.22 **
5,000.00 Budgeted 231.78 Remaining 95 % Used
Account: 135-60245-026-000 Miscellaneous Expenses
October 15, 2018 Regular Meeting Agenda Packet
107 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 29
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
1,473.98 .00 1,473.98
_______________
Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 1,473.98 **
2,000.00 Budgeted 526.02 Remaining 74 % Used
Department 26 Totals: ----------------------------------- 9,811.20 **
34.12 Monthly Total 12,980.00 Budgeted 3,168.80 Remaining 76 % Used
October 15, 2018 Regular Meeting Agenda Packet
108 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-50005-030-000 Salaries & Wages
2004 09/07/2018 MUD Payroll 09/07/2018 Salaries & Wages 337,201.47 13,385.75 350,587.22 PR
2089 09/21/2018 MUD Payroll 09/21/2018 Salaries & Wages 18,399.99 368,987.21 PR
_______________
Account: 135-50005-030-000 Salaries & Wages Totals: 31,785.74 368,987.21 **
432,863.00 Budgeted 63,875.79 Remaining 85 % Used
Account: 135-50010-030-000 Overtime
2004 09/07/2018 MUD Payroll 09/07/2018 Overtime 563.05 2.95 566.00 PR
_______________
Account: 135-50010-030-000 Overtime Totals: 2.95 566.00 **
2,000.00 Budgeted 1,434.00 Remaining 28 % Used
Account: 135-50016-030-000 Longevity
3,547.50 .00 3,547.50
_______________
Account: 135-50016-030-000 Longevity Totals: .00 3,547.50 **
3,548.00 Budgeted .50 Remaining 100 % Used
Account: 135-50020-030-000 Retirement
2004 09/07/2018 MUD Payroll 09/07/2018 Retirement 33,878.31 1,238.44 35,116.75 PR
2089 09/21/2018 MUD Payroll 09/21/2018 Retirement 1,702.00 36,818.75 PR
_______________
Account: 135-50020-030-000 Retirement Totals: 2,940.44 36,818.75 **
40,553.00 Budgeted 3,734.25 Remaining 91 % Used
Account: 135-50026-030-000 Medical Insurance
2004 09/07/2018 MUD Payroll 09/07/2018 Medical Insurance 43,345.59 2,072.63 45,418.22 PR
2089 09/21/2018 MUD Payroll 09/21/2018 Medical Insurance 2,072.61 47,490.83 PR
_______________
Account: 135-50026-030-000 Medical Insurance Totals: 4,145.24 47,490.83 **
63,485.00 Budgeted 15,994.17 Remaining 75 % Used
Account: 135-50027-030-000 Dental Insurance
2004 09/07/2018 MUD Payroll 09/07/2018 Dental Insurance 3,017.37 129.78 3,147.15 PR
2089 09/21/2018 MUD Payroll 09/21/2018 Dental Insurance 129.74 3,276.89 PR
_______________
Account: 135-50027-030-000 Dental Insurance Totals: 259.52 3,276.89 **
5,502.00 Budgeted 2,225.11 Remaining 60 % Used
October 15, 2018 Regular Meeting Agenda Packet
109 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-50028-030-000 Vision Insurance
2004 09/07/2018 MUD Payroll 09/07/2018 Vision Insurance 547.37 21.28 568.65 PR
2089 09/21/2018 MUD Payroll 09/21/2018 Vision Insurance 21.23 589.88 PR
_______________
Account: 135-50028-030-000 Vision Insurance Totals: 42.51 589.88 **
1,173.00 Budgeted 583.12 Remaining 50 % Used
Account: 135-50029-030-000 Life Insurance & Other
1930 09/01/2018 September A/P Employee benfits 3,434.06 145.04 3,579.10 Humana Inc 4481 AP
1981 09/01/2018 September A/P Employee benefits-September 119.45 3,698.55 METLIFE GROUP BENEFITS 4505 AP
2116 09/24/2018 September A/P Café 125 18.00 3,716.55 BenefitMall 4558 AP
_______________
Account: 135-50029-030-000 Life Insurance & Other Totals: 282.49 3,716.55 **
5,059.00 Budgeted 1,342.45 Remaining 73 % Used
Account: 135-50030-030-000 Social Security Taxes
2004 09/07/2018 MUD Payroll 09/07/2018 Social Security Taxes 20,309.18 792.05 21,101.23 PR
2089 09/21/2018 MUD Payroll 09/21/2018 Social Security Taxes 1,100.17 22,201.40 PR
_______________
Account: 135-50030-030-000 Social Security Taxes Totals: 1,892.22 22,201.40 **
27,181.00 Budgeted 4,979.60 Remaining 82 % Used
Account: 135-50035-030-000 Medicare Taxes
2004 09/07/2018 MUD Payroll 09/07/2018 Medicare Taxes 4,749.72 185.25 4,934.97 PR
2089 09/21/2018 MUD Payroll 09/21/2018 Medicare Taxes 257.28 5,192.25 PR
_______________
Account: 135-50035-030-000 Medicare Taxes Totals: 442.53 5,192.25 **
6,357.00 Budgeted 1,164.75 Remaining 82 % Used
Account: 135-50040-030-000 Unemployment Taxes
2004 09/07/2018 MUD Payroll 09/07/2018 Unemployment Taxes 1,139.54 6.23 1,145.77 PR
_______________
Account: 135-50040-030-000 Unemployment Taxes Totals: 6.23 1,145.77 **
1,260.00 Budgeted 114.23 Remaining 91 % Used
Account: 135-50045-030-000 Workman's Compensation
243 09/01/2018 Insurance/Wrk Comp Exp Sep 1,358.50 123.50 1,482.00 GL
October 15, 2018 Regular Meeting Agenda Packet
110 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 9/2018
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-030-000 Workman's Compensation Totals: 123.50 1,482.00 **
1,529.00 Budgeted 47.00 Remaining 97 % Used
Account: 135-50060-030-000 Pre-emp Physicals/Testing
211.90 .00 211.90
_______________
Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 211.90 **
500.00 Budgeted 288.10 Remaining 42 % Used
Account: 135-50070-030-000 Employee Relations
3,273.18 .00 3,273.18
_______________
Account: 135-50070-030-000 Employee Relations Totals: .00 3,273.18 **
4,960.00 Budgeted 1,686.82 Remaining 66 % Used
Account: 135-55030-030-000 Software & Support
2116 09/24/2018 September A/P Internet-Sept 66,078.36 903.72 66,982.08 Charter Communications 4561 AP
2116 09/24/2018 September A/P Microsoft exchange 456.00 67,438.08 M3 Networks 4581 AP
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 DNH*GODADDY.COM 149.98 67,588.06 DNH*GODADDY.COM PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ATT*BILL PAYMENT 124.34 67,712.40 ATT*BILL PAYMENT PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ATT*BILL PAYMENT 107.79 67,820.19 ATT*BILL PAYMENT PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ATT*BILL PAYMENT 85.71 67,905.90 ATT*BILL PAYMENT PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ATT*BILL PAYMENT 69.12 67,975.02 ATT*BILL PAYMENT PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ADOBE SYSTEMS INC 32.45 68,007.47 ADOBE SYSTEMS INC PC
_______________
Account: 135-55030-030-000 Software & Support Totals: 1,929.11 68,007.47 **
78,391.00 Budgeted 10,383.53 Remaining 87 % Used
Account: 135-55070-030-000 Independent Labor
2140 09/28/2018 September A/P Video MUD meeting 139,518.80 577.50 140,096.30 MIGUEL CRUZ 4602 AP
2152 09/30/2018 September A/P GM September 13,530.80 153,627.10 Carman Consulting LLC. 4628 AP
2160 09/30/2018 September A/P taxes consulting 42.00 153,669.10 DRG ENTERPRISES 4634 AP
_______________
Account: 135-55070-030-000 Independent Labor Totals: 14,150.30 153,669.10 **
154,000.00 Budgeted 330.90 Remaining 100 % Used
Account: 135-55080-030-000 Maintenance & Repairs
October 15, 2018 Regular Meeting Agenda Packet
111 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
2034 09/07/2018 September A/P rug cleaning reimbursement 5,400.48 166.29 5,566.77 TOWN OF TROPHY CLUB 4552 AP
2116 09/24/2018 September A/P Storage room building upgrade 4,716.84 10,283.61 3RD EYE SURVEILLANCE SYSTEMS 4555 AP
2116 09/24/2018 September A/P A/C admin 300.00 10,583.61 BRANDON R REED 4559 AP
_______________
Account: 135-55080-030-000 Maintenance & Repairs Totals: 5,183.13 10,583.61 **
14,000.00 Budgeted 3,416.39 Remaining 76 % Used
Account: 135-55085-030-000 Generator Maint. and Repair
4,624.58 .00 4,624.58
_______________
Account: 135-55085-030-000 Generator Maint. and Repair Totals: .00 4,624.58 **
10,000.00 Budgeted 5,375.42 Remaining 46 % Used
Account: 135-55120-030-000 Cleaning Services
2139 09/28/2018 September A/p Janitorial service 8,307.69 869.06 9,176.75 MEMBER'S BUILDING MAINTENANCE 4600 AP
_______________
Account: 135-55120-030-000 Cleaning Services Totals: 869.06 9,176.75 **
10,000.00 Budgeted 823.25 Remaining 92 % Used
Account: 135-55160-030-000 Professional Outside Services
2116 09/24/2018 September A/P FY 19 Rate consulting 59,240.00 3,060.00 62,300.00 NEW GEN STRATEGIES & SOLUTIONS 4583 AP
_______________
Account: 135-55160-030-000 Professional Outside Services Totals: 3,060.00 62,300.00 **
63,325.00 Budgeted 1,025.00 Remaining 98 % Used
Account: 135-55165-030-000 Collection Fees
.00 .00
_______________
Account: 135-55165-030-000 Collection Fees Totals: .00 .00 **
200.00 Budgeted 200.00 Remaining 0 % Used
Account: 135-55205-030-000 Utility Billing Contract
2116 09/24/2018 September A/P August billings 5,891.80 585.74 6,477.54 DATAPROSE LLC 4565 AP
2160 09/30/2018 September A/P Water billings 585.00 7,062.54 DATAPROSE LLC 4633 AP
_______________
Account: 135-55205-030-000 Utility Billing Contract Totals: 1,170.74 7,062.54 **
9,000.00 Budgeted 1,937.46 Remaining 78 % Used
October 15, 2018 Regular Meeting Agenda Packet
112 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 34
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-60005-030-000 Telephone
2034 09/07/2018 September A/P Answering service-sept 15,229.11 195.12 15,424.23 KEYSTONE PARK SECRETARIAL 4541 AP
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ATT*BUS PHONE PMT 858.55 16,282.78 ATT*BUS PHONE PMT PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ATT*BUS PHONE PMT 449.92 16,732.70 ATT*BUS PHONE PMT PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ATT*BILL PAYMENT 190.36 16,923.06 ATT*BILL PAYMENT PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 RINGCENTRAL, INC 13.95 16,937.01 RINGCENTRAL, INC PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 GOVERNMENT FINANCE OFF 170.00 17,107.01 GOVERNMENT FINANCE OFF PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ATT*BUS PHONE PMT 460.33 17,567.34 ATT*BUS PHONE PMT PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 AT&T *PAYMENT 858.55 18,425.89 AT&T *PAYMENT PC
2167 09/30/2018 Town Billed Invoices 1656-1659 AR 20180930-20180930 User: (180.00) 18,245.89 AR
_______________
Account: 135-60005-030-000 Telephone Totals: 3,016.78 18,245.89 **
17,300.00 Budgeted (945.89) Remaining 105 % Used
Account: 135-60010-030-000 Communications/Mobiles
2089 09/21/2018 MUD Payroll 09/21/2018 Communications/Mobiles 2,748.83 150.00 2,898.83 PR
2116 09/24/2018 September A/P Cell phones 87.33 2,986.16 VERIZON WIRELESS 4595 AP
_______________
Account: 135-60010-030-000 Communications/Mobiles Totals: 237.33 2,986.16 **
4,000.00 Budgeted 1,013.84 Remaining 75 % Used
Account: 135-60020-030-000 Electricity/Gas
2152 09/30/2018 September A/P Electricity admin 7/11-8/10 5,988.92 602.05 6,590.97 TOWN OF TROPHY CLUB 4649 AP
_______________
Account: 135-60020-030-000 Electricity/Gas Totals: 602.05 6,590.97 **
16,261.00 Budgeted 9,670.03 Remaining 41 % Used
Account: 135-60025-030-000 Water
2152 09/30/2018 September A/P Water-September 660.51 116.64 777.15 TROPHY CLUB MUD (WATER BILLS) 4650 AP
2167 09/30/2018 Town Billed Invoices 1656-1659 AR 20180930-20180930 User: (58.32) 718.83 AR
_______________
Account: 135-60025-030-000 Water Totals: 58.32 718.83 **
2,500.00 Budgeted 1,781.17 Remaining 29 % Used
Account: 135-60035-030-000 Postage
2116 09/24/2018 September A/P August billings 17,849.47 1,621.31 19,470.78 DATAPROSE LLC 4565 AP
2152 09/30/2018 September A/P Overnight- AT& T 5.50 19,476.28 FEDERAL EXPRESS CORP 4635 AP
2152 09/30/2018 September A/P Overnight-Denotn county tax 11.00 19,487.28 FEDERAL EXPRESS CORP 4635 AP
2160 09/30/2018 September A/P Water billings 1,632.77 21,120.05 DATAPROSE LLC 4633 AP
October 15, 2018 Regular Meeting Agenda Packet
113 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 35
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 9/2018
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 Postage Totals: 3,270.58 21,120.05 **
30,000.00 Budgeted 8,879.95 Remaining 70 % Used
Account: 135-60040-030-000 Service Charges & Fees
2006 09/07/2018 Child Support Fee 55,665.70 1.50 55,667.20 GL
2091 09/21/2018 Child Support Fee 1.50 55,668.70 GL
2152 09/30/2018 September A/P direct send fees 50.00 55,718.70 Fiserv Solutions, LLC 4636 AP
2156 09/30/2018 Pace Credit Card Fees 6,271.28 61,989.98 GL
2156 09/30/2018 Pace Credit Card Fees 128.40 62,118.38 GL
2160 09/30/2018 September A/P safety deposit box opening 187.23 62,305.61 Bank of the West 4627 AP
_______________
Account: 135-60040-030-000 Service Charges & Fees Totals: 6,639.91 62,305.61 **
55,560.00 Budgeted (6,745.61) Remaining 112 % Used
Account: 135-60050-030-000 Bad Debt Expense
.00 .00
_______________
Account: 135-60050-030-000 Bad Debt Expense Totals: .00 .00 **
1,500.00 Budgeted 1,500.00 Remaining 0 % Used
Account: 135-60055-030-000 Insurance
243 09/01/2018 Insurance/Wrk Comp Exp Sep 70,898.96 6,100.33 76,999.29 GL
_______________
Account: 135-60055-030-000 Insurance Totals: 6,100.33 76,999.29 **
56,000.00 Budgeted (20,999.29) Remaining 137 % Used
Account: 135-60066-030-000 Publications/Books/Subscripts
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 NCTCOG AGENCY SRVCS 206.38 153.40 359.78 NCTCOG AGENCY SRVCS PC
_______________
Account: 135-60066-030-000 Publications/Books/Subscripts Totals: 153.40 359.78 **
1,600.00 Budgeted 1,240.22 Remaining 22 % Used
Account: 135-60070-030-000 Dues & Memberships
3,988.42 .00 3,988.42
_______________
Account: 135-60070-030-000 Dues & Memberships Totals: .00 3,988.42 **
6,000.00 Budgeted 2,011.58 Remaining 66 % Used
October 15, 2018 Regular Meeting Agenda Packet
114 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-60075-030-000 Meetings
133.56 .00 133.56
_______________
Account: 135-60075-030-000 Meetings Totals: .00 133.56 **
400.00 Budgeted 266.44 Remaining 33 % Used
Account: 135-60079-030-000 Public Education
.00 .00
_______________
Account: 135-60079-030-000 Public Education Totals: .00 .00 **
6,000.00 Budgeted 6,000.00 Remaining 0 % Used
Account: 135-60080-030-000 Schools & Training
3,238.00 .00 3,238.00
_______________
Account: 135-60080-030-000 Schools & Training Totals: .00 3,238.00 **
7,600.00 Budgeted 4,362.00 Remaining 43 % Used
Account: 135-60100-030-000 Travel & per diem
2139 09/28/2018 September A/p Tolls 1,671.32 5.78 1,677.10 NTTA 4603 AP
_______________
Account: 135-60100-030-000 Travel & per diem Totals: 5.78 1,677.10 **
4,885.00 Budgeted 3,207.90 Remaining 34 % 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
220.00 .00 220.00
_______________
Account: 135-60115-030-000 Elections Totals: .00 220.00 **
4,500.00 Budgeted 4,280.00 Remaining 5 % Used
Account: 135-60125-030-000 Advertising
October 15, 2018 Regular Meeting Agenda Packet
115 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 37
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
2123 09/25/2018 September A/P Public hearing tax notice 300.00 625.00 925.00 Star-Telegram Media 4606 AP
_______________
Account: 135-60125-030-000 Advertising Totals: 625.00 925.00 **
2,500.00 Budgeted 1,575.00 Remaining 37 % Used
Account: 135-60235-030-000 Security
2116 09/24/2018 September A/P Monitoring service 418.00 24.00 442.00 Digital Air Control, Inc 4567 AP
_______________
Account: 135-60235-030-000 Security Totals: 24.00 442.00 **
2,700.00 Budgeted 2,258.00 Remaining 16 % Used
Account: 135-60245-030-000 Miscellaneous Expenses
124.50 .00 124.50
_______________
Account: 135-60245-030-000 Miscellaneous Expenses Totals: .00 124.50 **
500.00 Budgeted 375.50 Remaining 25 % Used
Account: 135-60246-030-000 General Manager Contingency
17,000.00 .00 17,000.00
_______________
Account: 135-60246-030-000 General Manager Contingency Totals: .00 17,000.00 **
17,000.00 Budgeted .00 Remaining 100 % Used
Account: 135-60360-030-000 Furniture/Equipment < $5000
211.99 .00 211.99
_______________
Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 211.99 **
2,500.00 Budgeted 2,288.01 Remaining 8 % Used
Account: 135-65010-030-000 Uniforms
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 RED WING SHOES #652 273.73 169.99 443.72 RED WING SHOES #652 PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 RED WING SHOES #652 303.73 747.45 RED WING SHOES #652 PC
_______________
Account: 135-65010-030-000 Uniforms Totals: 473.72 747.45 **
700.00 Budgeted (47.45) Remaining 107 % Used
Account: 135-65055-030-000 Hardware
October 15, 2018 Regular Meeting Agenda Packet
116 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
2116 09/24/2018 September A/P Computer replacement-Bert, rec 2,006.68 4,795.74 6,802.42 M3 Networks 4581 AP
_______________
Account: 135-65055-030-000 Hardware Totals: 4,795.74 6,802.42 **
7,420.00 Budgeted 617.58 Remaining 92 % Used
Account: 135-65085-030-000 Office Supplies
2139 09/28/2018 September A/p Office supplies 4,248.67 106.65 4,355.32 OFFICE DEPOT, INC 4604 AP
2139 09/28/2018 September A/p Office supplies' 49.39 4,404.71 OFFICE DEPOT, INC 4604 AP
2139 09/28/2018 September A/p Office supplies 79.98 4,484.69 OFFICE DEPOT, INC 4604 AP
2160 09/30/2018 September A/P Tags for portable meters 20.95 4,505.64 OFFICE DEPOT, INC 4644 AP
2160 09/30/2018 September A/P wall calendars, foot rest, key 643.16 5,148.80 OFFICE DEPOT, INC 4644 AP
2160 09/30/2018 September A/P drafting stool-Timi 118.76 5,267.56 OFFICE DEPOT, INC 4644 AP
2160 09/30/2018 September A/P File rail kit 49.98 5,317.54 OFFICE DEPOT, INC 4644 AP
2160 09/30/2018 September A/P office supplies 13.49 5,331.03 OFFICE DEPOT, INC 4644 AP
_______________
Account: 135-65085-030-000 Office Supplies Totals: 1,082.36 5,331.03 **
7,000.00 Budgeted 1,668.97 Remaining 76 % Used
Account: 135-65090-030-000 Printer Supplies & Maintenance
2,365.05 .00 2,365.05
_______________
Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 2,365.05 **
2,000.00 Budgeted (365.05) Remaining 118 % Used
Account: 135-65095-030-000 Maintenance Supplies
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 SAMSCLUB #4795 3,796.71 6.08 3,802.79 SAMSCLUB #4795 PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 SAMSCLUB.COM 42.67 3,845.46 SAMSCLUB.COM PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 SAMSCLUB.COM 254.77 4,100.23 SAMSCLUB.COM PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 AMAZON.COM*MT5214OE1 43.70 4,143.93 AMAZON.COM*MT5214OE1 PC
2163 09/26/2018 Pcard 08/28/18 - 09/26/18 AMZN MKTP US*MT6KC44C2 54.69 4,198.62 AMZN MKTP US*MT6KC44C2 PC
_______________
Account: 135-65095-030-000 Maintenance Supplies Totals: 401.91 4,198.62 **
4,000.00 Budgeted (198.62) Remaining 105 % Used
Account: 135-65105-030-000 Printing
144.00 .00 144.00
_______________
Account: 135-65105-030-000 Printing Totals: .00 144.00 **
4,000.00 Budgeted 3,856.00 Remaining 4 % Used
October 15, 2018 Regular Meeting Agenda Packet
117 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-69005-030-000 Capital Outlays
48,354.99 .00 48,354.99
_______________
Account: 135-69005-030-000 Capital Outlays Totals: .00 48,354.99 **
13,000.00 Budgeted (35,354.99) Remaining 372 % Used
Account: 135-69170-030-000 Copier Lease Installments
2116 09/24/2018 September A/P Copier lease 2,562.31 388.00 2,950.31 TIAA COMMERCIAL FINANCE 4590 AP
2116 09/24/2018 September A/P Copier lease 86.74 3,037.05 KYOCERA DOCUMENT SOLUTIONS 4577 AP
2152 09/30/2018 September A/P Copier lease 194.00 3,231.05 TIAA COMMERCIAL FINANCE 4648 AP
_______________
Account: 135-69170-030-000 Copier Lease Installments Totals: 668.74 3,231.05 **
4,600.00 Budgeted 1,368.95 Remaining 70 % Used
Department 30 Totals: ----------------------------------- 1,102,385.92 **
96,441.66 Monthly Total 1,217,112.00 Budgeted 114,726.08 Remaining 91 % Used
October 15, 2018 Regular Meeting Agenda Packet
118 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 40
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program:
Period Ending: 9/2018
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
2123 09/25/2018 September A/P Southlake easement legal 122,361.90 22,432.31 144,794.21 WHITAKER CHALK SWINDLE 4609 AP
2173 09/30/2018 September A/P Legal 2,610.00 147,404.21 McLean & Howard, L.L.P. 4655 AP
2173 09/30/2018 September A/P Legal 1,050.00 148,454.21 McLean & Howard, L.L.P. 4655 AP
_______________
Account: 135-55045-039-000 Legal Totals: 26,092.31 148,454.21 **
137,000.00 Budgeted (11,454.21) Remaining 108 % Used
Account: 135-55055-039-000 Auditing
25,658.70 .00 25,658.70
_______________
Account: 135-55055-039-000 Auditing Totals: .00 25,658.70 **
24,500.00 Budgeted (1,158.70) Remaining 105 % Used
Account: 135-55060-039-000 Appraisal
2034 09/07/2018 September A/P Appraisel 4th qtr DCAD budget 8,683.92 2,011.87 10,695.79 DENTON CENTRAL APPRAISAL DISTR 4533 AP
_______________
Account: 135-55060-039-000 Appraisal Totals: 2,011.87 10,695.79 **
11,446.00 Budgeted 750.21 Remaining 93 % Used
Account: 135-55065-039-000 Tax Admin Fees
2,968.40 .00 2,968.40
_______________
Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,968.40 **
3,800.00 Budgeted 831.60 Remaining 78 % Used
Department 39 Totals: ----------------------------------- 187,777.10 **
28,104.18 Monthly Total 176,746.00 Budgeted (11,031.10) Remaining 106 % Used
Fund 135 Totals: ----------------------------------- (2,302,430.71)
(268,509.02) Monthly Total (539,854.00) Budgeted 1,762,576.71 Remaining 426 % Used
October 15, 2018 Regular Meeting Agenda Packet
119 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 137 MUD 1 Consolidated GASB Department: Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 137-49145-000-000 Intergov Transfer-General Fund
(105,000.00) .00 (105,000.00)
_______________
Account: 137-49145-000-000 Intergov Transfer-General Fund Totals: .00 (105,000.00) **
.00 Budgeted 105,000.00 Remaining 0 % Used
Account: 137-49146-000-000 Intergov Transfer-Fire Dept
(81,420.00) .00 (81,420.00)
_______________
Account: 137-49146-000-000 Intergov Transfer-Fire Dept Totals: .00 (81,420.00) **
.00 Budgeted 81,420.00 Remaining 0 % Used
Department Totals: ----------------------------------- (186,420.00) **
.00 Monthly Total .00 Budgeted 186,420.00 Remaining 0 % Used
Fund 137 Totals: ----------------------------------- (186,420.00)
.00 Monthly Total .00 Budgeted 186,420.00 Remaining 0 % Used
October 15, 2018 Regular Meeting Agenda Packet
120 of 171
TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION
BALANCE SHEET
SEPTEMBER 2018
517
ASSETS
CONSTRUCTION
FUND
CASH IN BANK -
INVESTMENTS -
ACCOUNTS RECEIVABLE -
TOTAL ASSETS -
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES 785,925
TOTAL LIABILITIES 785,925
FUND BALANCE
ASSIGNED FUND BALANCE 992,579
NET REVENUES / EXPENDITURES (1,778,504)
TOTAL FUND BALANCE (785,925)
TOTAL LIABILITIES AND FUND BALANCE -
October 15, 2018 Regular Meeting Agenda Packet
121 of 171
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 14
22:50 10/11/18 Budget Summary with Amendment
Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program:
Period Ending: 9/2018
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
517-49010-000-000 Interest Income 9,348.16- 9,348.16
Subtotal: 9,348.16- 9,348.16
Program number: 9,348.16- 9,348.16
Department number: Revenues 9,348.16- 9,348.16
October 15, 2018 Regular Meeting Agenda Packet
122 of 171
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 15
22:50 10/11/18 Budget Summary with Amendment
Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program:
Period Ending: 9/2018
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
517-49141-020-000 Interfund Transfers In Gen 27,213.59- 671,726.04- 671,726.04
Subtotal: 27,213.59- 671,726.04- 671,726.04
Program number: 27,213.59- 671,726.04- 671,726.04
Department number: Wastewater 27,213.59- 671,726.04- 671,726.04
Revenues Subtotal ----------- 27,213.59- 681,074.20- 681,074.20
October 15, 2018 Regular Meeting Agenda Packet
123 of 171
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 16
22:50 10/11/18 Budget Summary with Amendment
Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program:
Period Ending: 9/2018
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
517-60335-020-000 Intergov Transfer Out (GF) 154.89 154.89-
Subtotal: 154.89 154.89-
517-69005-020-000 Capital Outlays 129,440.21 2,459,423.18 2,459,423.18-
Subtotal: 129,440.21 2,459,423.18 2,459,423.18-
Program number: 129,440.21 2,459,578.07 2,459,578.07-
Department number: Wastewater 129,440.21 2,459,578.07 2,459,578.07-
Expenditures Subtotal ----------- 129,440.21 2,459,578.07 2,459,578.07-
Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 102,226.62 1,778,503.87 1,778,503.87-
October 15, 2018 Regular Meeting Agenda Packet
124 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 517-49010-000-000 Interest Income
(9,348.16) .00 (9,348.16)
_______________
Account: 517-49010-000-000 Interest Income Totals: .00 (9,348.16) **
.00 Budgeted 9,348.16 Remaining 0 % Used
Department Totals: ----------------------------------- (9,348.16) **
.00 Monthly Total .00 Budgeted 9,348.16 Remaining 0 % Used
October 15, 2018 Regular Meeting Agenda Packet
125 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 43
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 517-49141-020-000 Interfund Transfers In Gen
2161 09/30/2018 Texpool Transfers September (644,512.45) (27,213.59) (671,726.04) GL
_______________
Account: 517-49141-020-000 Interfund Transfers In Gen Totals: (27,213.59) (671,726.04) **
.00 Budgeted 671,726.04 Remaining 0 % Used
Account: 517-60335-020-000 Intergov Transfer Out (GF)
154.89 .00 154.89
_______________
Account: 517-60335-020-000 Intergov Transfer Out (GF) Totals: .00 154.89 **
.00 Budgeted (154.89) Remaining 0 % Used
Account: 517-69005-020-000 Capital Outlays
2116 09/24/2018 September A/P WWTP Improvement 2,329,982.97 27,213.59 2,357,196.56 CP&Y/WALLACE GROUP, INC. 4564 AP
2152 09/30/2018 September A/P WWTP Improvements 102,226.62 2,459,423.18 WEBBER-CADAGUA PARTNERS 4652 AP
_______________
Account: 517-69005-020-000 Capital Outlays Totals: 129,440.21 2,459,423.18 **
.00 Budgeted (2,459,423.18) Remaining 0 % Used
Department 20 Totals: ----------------------------------- 1,787,852.03 **
102,226.62 Monthly Total .00 Budgeted (1,787,852.03) Remaining 0 % Used
Fund 517 Totals: ----------------------------------- 1,778,503.87
102,226.62 Monthly Total .00 Budgeted (1,778,503.87) Remaining 0 % Used
October 15, 2018 Regular Meeting Agenda Packet
126 of 171
TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION
SWIFT FUNDING
BALANCE SHEET
SEPTEMBER 2018
519
ASSETS
REVENUE BOND
CONSTRUCTION
CASH IN BANK -
CASH IN ESCROW 767,358
INVESTMENTS -
ACCOUNTS RECEIVABLE -
TOTAL ASSETS 767,358
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES 13,158
TOTAL LIABILITIES 13,158
FUND BALANCE
ASSIGNED FUND BALANCE 4,225,581
NET REVENUES / EXPENDITURES (3,471,381)
TOTAL FUND BALANCE 754,200
TOTAL LIABILITIES AND FUND BALANCE 767,358
October 15, 2018 Regular Meeting Agenda Packet
127 of 171
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 17
22:50 10/11/18 Budget Summary with Amendment
Fund: 519 2016 Rev Bond Const-SWIFT Department: Revenues Program:
Period Ending: 9/2018
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
519-49010-000-000 Interest Income 17,972.75- 19,506.92- 19,506.92
519-49141-000-000 Interfund Transfer In-Gen Fund 1,053,935.08
Subtotal: 1,035,962.33 19,506.92- 19,506.92
Program number: 1,035,962.33 19,506.92- 19,506.92
Department number: Revenues 1,035,962.33 19,506.92- 19,506.92
Revenues Subtotal ----------- 1,035,962.33 19,506.92- 19,506.92
October 15, 2018 Regular Meeting Agenda Packet
128 of 171
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 18
22:50 10/11/18 Budget Summary with Amendment
Fund: 519 2016 Rev Bond Const-SWIFT Department: 10 Water Program:
Period Ending: 9/2018
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
519-60334-010-000 Interfund Transfer Out 1,053,935.08- 797,679.25 797,679.25-
Subtotal: 1,053,935.08- 797,679.25 797,679.25-
519-69005-010-000 Capital Outlays 2,693,208.68 2,693,208.68-
Subtotal: 2,693,208.68 2,693,208.68-
Program number: 1,053,935.08- 3,490,887.93 3,490,887.93-
Department number: Water 1,053,935.08- 3,490,887.93 3,490,887.93-
Expenditures Subtotal ----------- 1,053,935.08- 3,490,887.93 3,490,887.93-
Fund number: 519 2016 Rev Bond Const-SWIFT 17,972.75- 3,471,381.01 3,471,381.01-
October 15, 2018 Regular Meeting Agenda Packet
129 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 44
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 519 2016 Rev Bond Const-SWIFT Department: Revenues Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 519-49010-000-000 Interest Income
2170 09/30/2018 Swift Bond Escrow Int 2018~ Oct 2017 Interest (1,534.17) (1,376.62) (2,910.79) GL
2170 09/30/2018 Swift Bond Escrow Int 2018~ Nov 2017 Interest (1,480.54) (4,391.33) GL
2170 09/30/2018 Swift Bond Escrow Int 2018~ Dec 2017 Interest (1,561.42) (5,952.75) GL
2170 09/30/2018 Swift Bond Escrow Int 2018~ Jan 2018 Interest (2,095.94) (8,048.69) GL
2170 09/30/2018 Swift Bond Escrow Int 2018~ Feb 2018 Interest (2,491.50) (10,540.19) GL
2170 09/30/2018 Swift Bond Escrow Int 2018~ Mar 2018 Interest (2,390.02) (12,930.21) GL
2170 09/30/2018 Swift Bond Escrow Int 2018~ Apr 2018 Interest (2,287.26) (15,217.47) GL
2170 09/30/2018 Swift Bond Escrow Int 2018~ May 2018 Interest (1,127.83) (16,345.30) GL
2170 09/30/2018 Swift Bond Escrow Int 2018~ June 2018 Interest (711.39) (17,056.69) GL
2170 09/30/2018 Swift Bond Escrow Int 2018~ July 2018 Interest (757.25) (17,813.94) GL
2170 09/30/2018 Swift Bond Escrow Int 2018~ Aug 2018 Interest (838.05) (18,651.99) GL
2170 09/30/2018 Swift Bond Escrow Int 2018~ Sept 2018 Interest (854.57) (19,506.56) GL
2170 09/30/2018 Swift Bond Escrow Int 2018~ Realized Gain 2018 (.36) (19,506.92) GL
_______________
Account: 519-49010-000-000 Interest Income Totals: (17,972.75) (19,506.92) **
.00 Budgeted 19,506.92 Remaining 0 % Used
Account: 519-49141-000-000 Interfund Transfer In-Gen Fund
2065 09/30/2018 Correct Intrfd Trnsfr 519/135 (1,053,935.08) 1,053,935.08 .00 GL
_______________
Account: 519-49141-000-000 Interfund Transfer In-Gen Fund Totals: 1,053,935.08 .00 **
.00 Budgeted .00 Remaining 0 % Used
Department Totals: ----------------------------------- (19,506.92) **
1,035,962.33 Monthly Total .00 Budgeted 19,506.92 Remaining 0 % Used
October 15, 2018 Regular Meeting Agenda Packet
130 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 519 2016 Rev Bond Const-SWIFT Department: 10 Water Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 519-60334-010-000 Interfund Transfer Out
2065 09/30/2018 Correct Intrfd Trnsfr 519/135 1,851,614.33 (1,053,935.08) 797,679.25 GL
_______________
Account: 519-60334-010-000 Interfund Transfer Out Totals: (1,053,935.08) 797,679.25 **
.00 Budgeted (797,679.25) Remaining 0 % Used
Account: 519-69005-010-000 Capital Outlays
2,693,208.68 .00 2,693,208.68
_______________
Account: 519-69005-010-000 Capital Outlays Totals: .00 2,693,208.68 **
.00 Budgeted (2,693,208.68) Remaining 0 % Used
Department 10 Totals: ----------------------------------- 3,490,887.93 **
(1,053,935.08) Monthly Total .00 Budgeted (3,490,887.93) Remaining 0 % Used
Fund 519 Totals: ----------------------------------- 3,471,381.01
(17,972.75) Monthly Total .00 Budgeted (3,471,381.01) Remaining 0 % Used
October 15, 2018 Regular Meeting Agenda Packet
131 of 171
TROPHY CLUB MUD #1 - 16" WATERLINE FUTURE REVENUE BOND
BALANCE SHEET
SEPTEMBER 2018
520
ASSETS
SWIFT REVENUE
BOND I&S
CASH IN BANK -
INVESTMENTS -
ACCOUNTS RECEIVABLE -
TOTAL ASSETS -
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES 370,772
TOTAL LIABILITIES 370,772
FUND BALANCE
ASSIGNED FUND BALANCE (39,899)
NET REVENUES / EXPENDITURES (330,873)
TOTAL FUND BALANCE (370,772)
TOTAL LIABILITIES AND FUND BALANCE -
October 15, 2018 Regular Meeting Agenda Packet
132 of 171
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 19
22:50 10/11/18 Budget Summary with Amendment
Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program:
Period Ending: 9/2018
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
520-69005-010-000 Capital Outlays 157,313.85 330,872.79 330,872.79-
Subtotal: 157,313.85 330,872.79 330,872.79-
Program number: 157,313.85 330,872.79 330,872.79-
Department number: Water Department 157,313.85 330,872.79 330,872.79-
Expenditures Subtotal ----------- 157,313.85 330,872.79 330,872.79-
Fund number: 520 Revenue Bond 16" Waterline 157,313.85 330,872.79 330,872.79-
October 15, 2018 Regular Meeting Agenda Packet
133 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 520-69005-010-000 Capital Outlays
2174 09/30/2018 Due To/From -Fund 520 Sept 18 173,558.94 157,313.85 330,872.79 GL
_______________
Account: 520-69005-010-000 Capital Outlays Totals: 157,313.85 330,872.79 **
.00 Budgeted (330,872.79) Remaining 0 % Used
Department 10 Totals: ----------------------------------- 330,872.79 **
157,313.85 Monthly Total .00 Budgeted (330,872.79) Remaining 0 % Used
Fund 520 Totals: ----------------------------------- 330,872.79
157,313.85 Monthly Total .00 Budgeted (330,872.79) Remaining 0 % Used
October 15, 2018 Regular Meeting Agenda Packet
134 of 171
TROPHY CLUB MUD #1 - REVENUE BOND RESERVE
BALANCE SHEET
SEPTEMBER 2018
528
ASSETS
REVENUE BOND
RESERVE
CASH IN BANK -
INVESTMENTS 606,910
ACCOUNTS RECEIVABLE -
TOTAL ASSETS 606,910
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES -
TOTAL LIABILITIES -
FUND BALANCE
ASSIGNED FUND BALANCE 426,579
NET REVENUES / EXPENDITURES 180,331
TOTAL FUND BALANCE 606,910
TOTAL LIABILITIES AND FUND BALANCE 606,910
October 15, 2018 Regular Meeting Agenda Packet
135 of 171
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 20
22:50 10/11/18 Budget Summary with Amendment
Fund: 528 2015 Revenue Bond Reserve Fund Department: Program:
Period Ending: 9/2018
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
528-49010-000-000 Interest Income 1,000.00- 1,000.00- 972.67- 7,999.41- 799.941 6,999.41
528-49142-000-000 Interfund transfer in-Water 48,996.00- 48,996.00- 4,083.00- 48,996.00- 100.000
528-49143-000-000 Interfund transfer in-WW 123,336.00- 123,336.00- 10,278.00- 123,336.00- 100.000
Subtotal: 173,332.00- 173,332.00- 15,333.67- 180,331.41- 104.038 6,999.41
Program number: 173,332.00- 173,332.00- 15,333.67- 180,331.41- 104.038 6,999.41
Department number: 173,332.00- 173,332.00- 15,333.67- 180,331.41- 104.038 6,999.41
Revenues Subtotal ----------- 173,332.00- 173,332.00- 15,333.67- 180,331.41- 104.038 6,999.41
Fund number: 528 2015 Revenue Bond Reserve Fund 173,332.00- 173,332.00- 15,333.67- 180,331.41- 104.038 6,999.41
October 15, 2018 Regular Meeting Agenda Packet
136 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 47
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 528 2015 Revenue Bond Reserve Fund Department: Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 528-49010-000-000 Interest Income
2155 09/30/2018 Bank Interest- September (7,026.74) (972.67) (7,999.41) GL
_______________
Account: 528-49010-000-000 Interest Income Totals: (972.67) (7,999.41) **
(1,000.00) Budgeted 6,999.41 Remaining 800 % Used
Account: 528-49142-000-000 Interfund transfer in-Water
2161 09/30/2018 Texpool Transfers September (44,913.00) (4,083.00) (48,996.00) GL
_______________
Account: 528-49142-000-000 Interfund transfer in-Water Totals: (4,083.00) (48,996.00) **
(48,996.00) Budgeted .00 Remaining 100 % Used
Account: 528-49143-000-000 Interfund transfer in-WW
2161 09/30/2018 Texpool Transfers September (113,058.00) (10,278.00) (123,336.00) GL
_______________
Account: 528-49143-000-000 Interfund transfer in-WW Totals: (10,278.00) (123,336.00) **
(123,336.00) Budgeted .00 Remaining 100 % Used
Department Totals: ----------------------------------- (180,331.41) **
(15,333.67) Monthly Total (173,332.00) Budgeted 6,999.41 Remaining 104 % Used
Fund 528 Totals: ----------------------------------- (180,331.41)
(15,333.67) Monthly Total (173,332.00) Budgeted 6,999.41 Remaining 104 % Used
October 15, 2018 Regular Meeting Agenda Packet
137 of 171
TROPHY CLUB MUD #1 - I&S
BALANCE SHEET
SEPTEMBER 2018
INTEREST &
SINKING- 533
ASSETS
CASH IN BANK 4,573
INVESTMENTS 48,716
PREPAID EXPENSES -
ADVALOREM PROPERTY TAXES RECEIVABLE 9,502
ACCOUNTS RECEIVABLE-OTHER -
TOTAL ASSETS 62,791
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 9,502
ACCOUNTS AND OTHER PAYABLES -
TOTAL LIABILITIES 9,502
FUND BALANCE
ASSIGNED FUND BALANCE 32,341
NET REVENUES / EXPENDITURES 20,948
TOTAL FUND BALANCE 53,289
TOTAL LIABILITIES AND FUND BALANCE 62,791
October 15, 2018 Regular Meeting Agenda Packet
138 of 171
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 21
22:50 10/11/18 Budget Summary with Amendment
Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program:
Period Ending: 9/2018
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
533-40000-000-000 Property Taxes 669,660.00- 669,660.00- 50.23- 677,052.35- 101.104 7,392.35
533-40002-000-000 Property Taxes/Delinquent 1,800.00- 1,800.00- 2,624.77- 145.821 824.77
533-40015-000-000 Property Taxes/P & I 2,000.00- 2,000.00- 5.53- 2,009.74- 100.487 9.74
Subtotal: 673,460.00- 673,460.00- 55.76- 681,686.86- 101.222 8,226.86
533-49010-000-000 Interest Income 2,000.00- 2,000.00- 80.24- 8,921.74- 446.087 6,921.74
533-49015-000-000 Lease/Rental Income 218,954.00- 218,954.00- 218,954.00- 100.000
533-49141-000-000 Interfund Trans In-PID Surchg 122,043.00- 122,043.00- 122,043.00- 100.000
Subtotal: 342,997.00- 342,997.00- 80.24- 349,918.74- 102.018 6,921.74
Program number: 1,016,457.00- 1,016,457.00- 136.00- 1,031,605.60- 101.490 15,148.60
Department number: Revenues 1,016,457.00- 1,016,457.00- 136.00- 1,031,605.60- 101.490 15,148.60
Revenues Subtotal ----------- 1,016,457.00- 1,016,457.00- 136.00- 1,031,605.60- 101.490 15,148.60
October 15, 2018 Regular Meeting Agenda Packet
139 of 171
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 22
22:50 10/11/18 Budget Summary with Amendment
Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program:
Period Ending: 9/2018
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
533-70005-051-000 Paying Agent Fee 2,150.00 2,150.00 500.00 2,150.00 100.000
533-70025-051-000 Bond Interest Expense-Tax 283,508.00 283,508.00 283,507.50 100.000 .50
533-70035-051-000 Bond Principal Payment-Tax 725,000.00 725,000.00 725,000.00 100.000
Subtotal: 1,010,658.00 1,010,658.00 500.00 1,010,657.50 100.000 .50
Program number: 1,010,658.00 1,010,658.00 500.00 1,010,657.50 100.000 .50
Department number: Administration 1,010,658.00 1,010,658.00 500.00 1,010,657.50 100.000 .50
Expenditures Subtotal ----------- 1,010,658.00 1,010,658.00 500.00 1,010,657.50 100.000 .50
Fund number: 533 MUD 1 I&S Consolidated 5,799.00- 5,799.00- 364.00 20,948.10- 361.236 15,149.10
October 15, 2018 Regular Meeting Agenda Packet
140 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 48
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program:
Period Ending: 9/2018
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
2153 09/04/2018 Property Taxes (677,002.12) (34.75) (677,036.87) GL
2154 09/28/2018 Property Taxes (15.48) (677,052.35) GL
_______________
Account: 533-40000-000-000 Property Taxes Totals: (50.23) (677,052.35) **
(669,660.00) Budgeted 7,392.35 Remaining 101 % Used
Account: 533-40002-000-000 Property Taxes/Delinquent
(2,624.77) .00 (2,624.77)
_______________
Account: 533-40002-000-000 Property Taxes/Delinquent Totals: .00 (2,624.77) **
(1,800.00) Budgeted 824.77 Remaining 146 % Used
Account: 533-40015-000-000 Property Taxes/P & I
2153 09/04/2018 Property Taxes (2,004.21) (2.43) (2,006.64) GL
2154 09/28/2018 Property Taxes (3.10) (2,009.74) GL
_______________
Account: 533-40015-000-000 Property Taxes/P & I Totals: (5.53) (2,009.74) **
(2,000.00) Budgeted 9.74 Remaining 100 % Used
Account: 533-49010-000-000 Interest Income
2155 09/30/2018 Bank Interest- September (8,841.50) (80.24) (8,921.74) GL
_______________
Account: 533-49010-000-000 Interest Income Totals: (80.24) (8,921.74) **
(2,000.00) Budgeted 6,921.74 Remaining 446 % Used
Account: 533-49015-000-000 Lease/Rental Income
(218,954.00) .00 (218,954.00)
_______________
Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (218,954.00) **
(218,954.00) Budgeted .00 Remaining 100 % Used
Account: 533-49141-000-000 Interfund Trans In-PID Surchg
(122,043.00) .00 (122,043.00)
_______________
Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: .00 (122,043.00) **
(122,043.00) Budgeted .00 Remaining 100 % Used
October 15, 2018 Regular Meeting Agenda Packet
141 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Department Totals: ----------------------------------- (1,031,605.60) **
(136.00) Monthly Total (1,016,457.00) Budgeted 15,148.60 Remaining 101 % Used
October 15, 2018 Regular Meeting Agenda Packet
142 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 50
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 533-70005-051-000 Paying Agent Fee
2097 09/21/2018 TCMUD1-13 Paying Agent Fee 1,650.00 500.00 2,150.00 GL
_______________
Account: 533-70005-051-000 Paying Agent Fee Totals: 500.00 2,150.00 **
2,150.00 Budgeted .00 Remaining 100 % Used
Account: 533-70025-051-000 Bond Interest Expense-Tax
283,507.50 .00 283,507.50
_______________
Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: .00 283,507.50 **
283,508.00 Budgeted .50 Remaining 100 % Used
Account: 533-70035-051-000 Bond Principal Payment-Tax
725,000.00 .00 725,000.00
_______________
Account: 533-70035-051-000 Bond Principal Payment-Tax Totals: .00 725,000.00 **
725,000.00 Budgeted .00 Remaining 100 % Used
Department 51 Totals: ----------------------------------- 1,010,657.50 **
500.00 Monthly Total 1,010,658.00 Budgeted .50 Remaining 100 % Used
Fund 533 Totals: ----------------------------------- (20,948.10)
364.00 Monthly Total (5,799.00) Budgeted 15,149.10 Remaining 361 % Used
October 15, 2018 Regular Meeting Agenda Packet
143 of 171
TROPHY CLUB MUD #1 - REVENUE BOND I&S
BALANCE SHEET
SEPTEMBER 2018
534
ASSETS
REVENUE BOND
I&S
CASH IN BANK -
INVESTMENTS 19,562
ACCOUNTS RECEIVABLE -
TOTAL ASSETS 19,562
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES -
TOTAL LIABILITIES -
FUND BALANCE
ASSIGNED FUND BALANCE 16,211
NET REVENUES / EXPENDITURES 3,351
TOTAL FUND BALANCE 19,562
TOTAL LIABILITIES AND FUND BALANCE 19,562
October 15, 2018 Regular Meeting Agenda Packet
144 of 171
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 23
22:50 10/11/18 Budget Summary with Amendment
Fund: 534 2015 Revenue Bond I&S Department: Revenues Program:
Period Ending: 9/2018
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
534-49010-000-000 Interest Income 1,000.00- 1,000.00- 32.05- 3,350.84- 335.084 2,350.84
534-49143-000-000 Interfund Transfer In-WW Sales 598,738.00- 598,738.00- 598,738.00- 100.000
Subtotal: 599,738.00- 599,738.00- 32.05- 602,088.84- 100.392 2,350.84
Program number: 599,738.00- 599,738.00- 32.05- 602,088.84- 100.392 2,350.84
Department number: Revenues 599,738.00- 599,738.00- 32.05- 602,088.84- 100.392 2,350.84
Revenues Subtotal ----------- 599,738.00- 599,738.00- 32.05- 602,088.84- 100.392 2,350.84
October 15, 2018 Regular Meeting Agenda Packet
145 of 171
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 24
22:50 10/11/18 Budget Summary with Amendment
Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program:
Period Ending: 9/2018
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 100.000
534-70040-051-000 Revenue Bond Interest Expense 223,338.00 223,338.00 223,337.50 100.000 .50
534-70045-051-000 Revenue Bond Principal Expense 375,000.00 375,000.00 375,000.00 100.000
Subtotal: 598,738.00 598,738.00 598,737.50 100.000 .50
Program number: 598,738.00 598,738.00 598,737.50 100.000 .50
Department number: Administration 598,738.00 598,738.00 598,737.50 100.000 .50
Expenditures Subtotal ----------- 598,738.00 598,738.00 598,737.50 100.000 .50
Fund number: 534 2015 Revenue Bond I&S 1,000.00- 1,000.00- 32.05- 3,351.34- 335.134 2,351.34
October 15, 2018 Regular Meeting Agenda Packet
146 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 51
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 534 2015 Revenue Bond I&S Department: Revenues Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 534-49010-000-000 Interest Income
2155 09/30/2018 Bank Interest- September (3,318.79) (32.05) (3,350.84) GL
_______________
Account: 534-49010-000-000 Interest Income Totals: (32.05) (3,350.84) **
(1,000.00) Budgeted 2,350.84 Remaining 335 % Used
Account: 534-49143-000-000 Interfund Transfer In-WW Sales
(598,738.00) .00 (598,738.00)
_______________
Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: .00 (598,738.00) **
(598,738.00) Budgeted .00 Remaining 100 % Used
Department Totals: ----------------------------------- (602,088.84) **
(32.05) Monthly Total (599,738.00) Budgeted 2,350.84 Remaining 100 % Used
October 15, 2018 Regular Meeting Agenda Packet
147 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 52
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program:
Period Ending: 9/2018
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
400.00 .00 400.00
_______________
Account: 534-70005-051-000 Rev Bond Paying Agent Fee Totals: .00 400.00 **
400.00 Budgeted .00 Remaining 100 % Used
Account: 534-70040-051-000 Revenue Bond Interest Expense
223,337.50 .00 223,337.50
_______________
Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: .00 223,337.50 **
223,338.00 Budgeted .50 Remaining 100 % Used
Account: 534-70045-051-000 Revenue Bond Principal Expense
375,000.00 .00 375,000.00
_______________
Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: .00 375,000.00 **
375,000.00 Budgeted .00 Remaining 100 % Used
Department 51 Totals: ----------------------------------- 598,737.50 **
.00 Monthly Total 598,738.00 Budgeted .50 Remaining 100 % Used
Fund 534 Totals: ----------------------------------- (3,351.34)
(32.05) Monthly Total (1,000.00) Budgeted 2,351.34 Remaining 335 % Used
October 15, 2018 Regular Meeting Agenda Packet
148 of 171
TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S
BALANCE SHEET
SEPTEMBER 2018
535
ASSETS
SWIFT REVENUE
BOND I&S
CASH IN BANK -
INVESTMENTS 2,584
ACCOUNTS RECEIVABLE -
TOTAL ASSETS 2,584
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES -
TOTAL LIABILITIES -
FUND BALANCE
ASSIGNED FUND BALANCE 952
NET REVENUES / EXPENDITURES 1,632
TOTAL FUND BALANCE 2,584
TOTAL LIABILITIES AND FUND BALANCE 2,584
October 15, 2018 Regular Meeting Agenda Packet
149 of 171
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 25
22:50 10/11/18 Budget Summary with Amendment
Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program:
Period Ending: 9/2018
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
535-49010-000-000 Interest Income 600.00- 600.00- 4.24- 1,632.02- 272.003 1,032.02
535-49142-000-000 Interfund Tran In-Water Sales 278,084.00- 278,084.00- 278,083.50- 100.000 .50-
Subtotal: 278,684.00- 278,684.00- 4.24- 279,715.52- 100.370 1,031.52
Program number: 278,684.00- 278,684.00- 4.24- 279,715.52- 100.370 1,031.52
Department number: Revenues 278,684.00- 278,684.00- 4.24- 279,715.52- 100.370 1,031.52
Revenues Subtotal ----------- 278,684.00- 278,684.00- 4.24- 279,715.52- 100.370 1,031.52
October 15, 2018 Regular Meeting Agenda Packet
150 of 171
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 26
22:50 10/11/18 Budget Summary with Amendment
Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program:
Period Ending: 9/2018
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 400.00 400.00 400.00 100.000
535-70040-051-000 Revenue Bond Interest Expense 62,684.00 62,684.00 62,683.50 99.999 .50
535-70045-051-000 Revenue Bond Principal Expense 215,000.00 215,000.00 215,000.00 100.000
Subtotal: 278,084.00 278,084.00 278,083.50 100.000 .50
Program number: 278,084.00 278,084.00 278,083.50 100.000 .50
Department number: Administration 278,084.00 278,084.00 278,083.50 100.000 .50
Expenditures Subtotal ----------- 278,084.00 278,084.00 278,083.50 100.000 .50
Fund number: 535 2016 Rev Bond I&S-SWIFT 600.00- 600.00- 4.24- 1,632.02- 272.003 1,032.02
******* End of Report *********
October 15, 2018 Regular Meeting Agenda Packet
151 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 53
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program:
Period Ending: 9/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 535-49010-000-000 Interest Income
2155 09/30/2018 Bank Interest- September (1,627.78) (4.24) (1,632.02) GL
_______________
Account: 535-49010-000-000 Interest Income Totals: (4.24) (1,632.02) **
(600.00) Budgeted 1,032.02 Remaining 272 % Used
Account: 535-49142-000-000 Interfund Tran In-Water Sales
(278,083.50) .00 (278,083.50)
_______________
Account: 535-49142-000-000 Interfund Tran In-Water Sales Totals: .00 (278,083.50) **
(278,084.00) Budgeted (.50) Remaining 100 % Used
Department Totals: ----------------------------------- (279,715.52) **
(4.24) Monthly Total (278,684.00) Budgeted 1,031.52 Remaining 100 % Used
October 15, 2018 Regular Meeting Agenda Packet
152 of 171
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 54
22:50 10/11/18 Detailed Accounting Trial Balance
Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program:
Period Ending: 9/2018
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
400.00 .00 400.00
_______________
Account: 535-70005-051-000 Rev Bond Paying Agent Fee Totals: .00 400.00 **
400.00 Budgeted .00 Remaining 100 % Used
Account: 535-70040-051-000 Revenue Bond Interest Expense
62,683.50 .00 62,683.50
_______________
Account: 535-70040-051-000 Revenue Bond Interest Expense Totals: .00 62,683.50 **
62,684.00 Budgeted .50 Remaining 100 % Used
Account: 535-70045-051-000 Revenue Bond Principal Expense
215,000.00 .00 215,000.00
_______________
Account: 535-70045-051-000 Revenue Bond Principal Expense Totals: .00 215,000.00 **
215,000.00 Budgeted .00 Remaining 100 % Used
Department 51 Totals: ----------------------------------- 278,083.50 **
.00 Monthly Total 278,084.00 Budgeted .50 Remaining 100 % Used
Fund 535 Totals: ----------------------------------- (1,632.02)
(4.24) Monthly Total (600.00) Budgeted 1,032.02 Remaining 272 % Used
Grand Totals: --------------------------------------------------------------------------------------------------------- 2,864,013.23 ****
9,977.28 Monthly Total (720,585.00) Budgeted (3,584,598.23) Remaining ##########
******* End of Report *********
October 15, 2018 Regular Meeting Agenda Packet
153 of 171
BUDGET VARIANCE REPORT
FUND:122 - Fire O&M
FINANCIALS MONTH:September 2018
REVENUE VARIANCE:100.0%
EXPENSE VARIANCE:100.0%
NOTE:
ACCOUNT DESCRIPTION TOTAL
BUDGET
CURRENT
MONTH
YTD
TOTAL YTD % DATE OF
COMMENT VARIANCE EXPLANATION
FIRE REVENUES
122-40010 Property Taxes/Fire 1,054,433 79 1,066,061 101.10%10/2017 Property Taxes collected
122-40011 Property Taxes/Fire - Delinquent - 3,945 10/2017 Delinquent Fire Taxes collected
122-40020 Property Taxes/Fire P&I 9 4,787 10/2017 Fire Taxes Penalties &Interest
collected
FIRE EXPENSES
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
October 15, 2018 Regular Meeting Agenda Packet
154 of 171
BUDGET VARIANCE REPORT
FUND:135 - MUD 1 O&M
FINANCIALS MONTH:September 2018
REVENUE VARIANCE:100.0%
EXPENSE VARIANCE:100.0%
NOTE:
ACCOUNT DESCRIPTION TOTAL
BUDGET
CURRENT
MONTH
YTD
TOTAL
YTD % DATE OF
COMMENT
VARIANCE EXPLANATION
REVENUE
135-47000-000 Water 6,464,019 489,453 5,953,141 92.10%01/2018 Water Sales
135-47030-000 Service Charges 14,350 1,550 13,881 96.73%01/2018 Service Charges
135-49075-000 Oversized Meter Reimbursment 18,179 1,029 14,237 78.31%06/2018 Oversize Meter Reimbursment
135-49901-000 Records Management Revenue 20 - 2 10.00%07/2018 Open Record Request
EXPENSES
WATER
135-55080-010 Maintenance & Repairs 100,000 1,112 100,901 100.90%09/2018 Normal Mainteance & Repairs
135-55090-010 Vehicle Maintenance 4,000 148 5,216 130.41%09/2018 NAPA Auto Parts
135-55135-010 Lab Analysis 5,500 818 7,413 134.78%06/2018 Normal Lab Testing
135-60080-010 Schools & Training 2,785 680 2,889 103.73%09/2018 Normal Training
WASTEWATER
135-50010-020 Overtime 30,000 2,706 33,380 111.27%05/2018 WWTP Overtime
135-50026-020 Medical Insurance 62,175 5,519 65,584 105.48%09/2018 WWTP Medical Ins
135-55090-020 Vehicle Maintenance 8,000 150 9,822 122.77%07/2018 Blagg Tire, CLS Sewer
Equipment (GAP Vax)
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
October 15, 2018 Regular Meeting Agenda Packet
155 of 171
BUDGET VARIANCE REPORT
FUND:135 - MUD 1 O&M
FINANCIALS MONTH:September 2018
REVENUE VARIANCE:100.0%
EXPENSE VARIANCE:100.0%
NOTE:
ACCOUNT DESCRIPTION TOTAL
BUDGET
CURRENT
MONTH
YTD
TOTAL
YTD % DATE OF
COMMENT
VARIANCE EXPLANATION
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
135-55125-020 Dumpster Services 60,000 3,359 68,016 113.36%01/2018 L.H. Chaney- Haul offs
135-55135-020 Lab Analysis 30,000 2,286 31,558 105.19%09/2018 Normal Lab Testing
135-60010-020 Communications/Mobiles 4,700 381 4,844 103.05%09/2018 WWTP Phones
135-65045-020 Lab Supplies 14,000 1,873 20,748 148.20%06/2018 Lab Supplies
BOARD OF DIRECTORS
ADMINISTRATION
135-60005-030 Telephone 17,300$ 3,017$ 18,246$ 105.47%09/2018 Admin Phone
135-60040-030 Service Charge & Fees 55,560$ 6,640$ 62,306$ 112.14%08/2018 Pace Credit Card Fees
135-60055-030 Insurance 56,000$ 6,100$ 76,999$ 137.50%02/2018 TML WC True-Up Adjustment
FY17
135-65010-030 Uniforms 700$ 474$ 747$ 106.78%09/2018 Safety Shoes
135-65095-030 Maintenance Supplies 4,000$ 402$ 4,199$ 104.97%09/2018 Sams, Amazon
Non-Departmental
135-55045-039 Legal 137,000$ 26,092$ 148,454$ 108.36%09/2018 Whitaker Chalk Swindle,
McLean & Howard
October 15, 2018 Regular Meeting Agenda Packet
156 of 171
Trophy Club Municipal Utility District No. 1
Date: 10/15/2018
To: Board of Directors
From: John Robert Carman
Subject: General Manager’s Report
Regulatory Updates
Sanitary Sewer Overflows (SSO) – One large SSO occurred since the last Board meeting. This
SSO happened at the wastewater treatment plant during the significant precipitation event
occurring on September 21st and 22nd near 1500 Junction Way, in Trophy Club Texas. An
estimated 10,000 gallons spilled, and the spill was reported to TCEQ in Austin and TCEQ Region
4 in Fort Worth as required. This sewer overflow was one of the significant effects resulting
from the intense precipitation event which saw flooding in the other low lying areas of Trophy
club. The operators demonstrated creativity in minimizing the overflow by using Basin 4, which
is reserved for future expansion, as an equalization basin during the high flows. This spill
required an extensive cleanup effort, primarily on the plant site but also for a small area outside
the fence line. Here are the before and after cleanup pictures.
It is common after a spill to put lime on the material which disinfects by lowering pH
significantly. Here is another before and after picture showing an area cleaned up by our team.
October 15, 2018 Regular Meeting Agenda Packet
157 of 171
Breaks and Leaks – No reportable breaks or leaks have occurred since the last Board meeting.
A leak on a service line in the Solana area was found but did not meet the criteria for reporting
to TCEQ.
Compliance Investigation ‐ TCEQ met with District and Town staff on September 25, 2018.
TCEQ sent us with an exit interview form that found two areas of non‐compliance: 1) quarterly
calibration records for handheld chlorine residual measurement devices and 2) maintaining a
daily record of chemicals used in the water plant. Both of these items will be corrected within
30 days of the visit.
Capital Improvement Projects
Interconnecting Pipeline Project Phase 1 – Contractor has completed boring under the road at
Trophy Club Drive and all the infrastructure for this phase has been completed. No progress
has been made on the final punch list items. It is my understanding that revegetation
throughout the easement acquired for phase one is required to close out the phase one
project. We are working with our engineer to push the contractor to complete the work.
Interconnecting Pipeline Project Phase 2 – Our design team for Phase 2 of the project is going
to provide an in person update on this project at today’s meeting.
WWTP – Our contractor has submitted a request for full substantial completion on Phase 3 of
the project and our engineering team is reviewing the request. This is good news, and while
there is still a considerable punch list to be completed before the work is fully complete,
High Service Pump Project – Last winter this project was put out for bid and all bids we
received were considerably higher than what was budgeted. This is work that has to be done
during the low flow months of the year so the project was put on hold until the peak demand
October 15, 2018 Regular Meeting Agenda Packet
158 of 171
months had passed. Activity on this project has picked up again and we anticipate going back
out to bid before the end of the year.
Joint Projects with Town ‐ The Phoenix Drive project is complete. On October 11, 2018 at 6:00
PM another pre‐construction meeting was held at Town Hall to talk about the Indian Creek
portion of the project. The meeting was well attended with approximately 30 citizens coming
hear about the project and voice their concerns about a variety of project impacts. No
concerns were raised about the water aspects of that work.
Fire Department Summary
During the month of September the fire department responded to 74 calls for emergency
service. The fire inspector completed 17 inspections finding 60 life safety violations for which
he is working with building owners and tenants to correct. Fire crews also facilitated 7 public
education classes for 41 adults and 86 children. On October 4th nine members of the
community graduated from our Citizens Fire Academy. Although this is not our first academy
here in Trophy Club it was the first of its kind. Class members actively participated in events
including; fire extinguisher use, airway management and IV practice on manikins, toured a
Careflite helicopter, cut up a car using the “Jaws of Life”, climbed our aerial ladder and entered
a live fire training scenario wearing bunker gear and an SCBA to extinguish a fire. This was a
great benefit to both our firefighters and our participating residents. We witnessed
participants building new relationships as they learned about our day‐to‐day operations and we
gained future ambassadors of the department and friendships within our community. The fire
department will have its next citizen’s fire academy next fall and we look forward to building
upon our strong relationship with the community. In September the fire department also
received word that we were awarded two grants for which we applied last year. Below is
information about our grants awarded:
The Trophy Club Fire Department has successfully sought and received a grant from FEMA to
help offset the necessary costs associated with securing a Fire Marshal to oversee the fire
prevention and enforcement programs for the fire department. The department began
working on the grant application in February 2018 and was awarded $104,429 in late
September towards the hiring, equipping, salaries and benefits of a full time Fire Marshal
position. The position will be charged with the following responsibilities:
1. Oversight of all new construction and remodels both commercial and residential
a. Including PD 30 and 25 projects
2. Complete all high hazard fire inspections
3. Complete all certificates of occupancy inspections
4. Investigate cause and origin of all fires
5. Investigate all arson cases to prosecution
October 15, 2018 Regular Meeting Agenda Packet
159 of 171
6. Train all shift inspectors for low hazard/medium hazard inspections
7. Follow up on all violations and complaints
8. Complete all foster home inspections
9. Oversight of all public education programs
10. Assist with pulling of statistical data for the purpose of reporting
11. Assist with policy creation and review
12. Oversee the AED inspection program for the Town of Trophy Club and MUD 1
13. TCOLE Administrator for the Fire Department
14. Assist with oversight of fire crews at emergency scenes
The accepting of the grant is contingent matching funds of $5,221.00 which the MUD has
agreed to pay. The fire marshal will be a Texas Commission on Fire Protection certified
Inspection/Plan Reviewer, Arson Investigator, Firefighter and Texas Commission on Law
Enforcement certified Peace Officer. We expect to have a candidate hired by November 1,
2018.
The Fire Department was also awarded a grant by Firehouse Subs Public Safety Foundation in
the amount of $21,900.00 for the purchase of 14 Automatic External Defibrillators (AED), 2 AED
training units and associated equipment. The grant was awarded October 1, 2018. The AEDs
will be distributed as follows:
1. 2 units at Town Hall
2. 1 at Fire Station
3. 1 at Indy East
4. 1 at Indy West
5. 1 at Harmony Park
6. 1 at Trophy Club Park
7. 1 at Parks Barn
8. 3 for PD vehicles
9. 1 at MUD Admin building
10. 1 at Water Treatment Plant
11. 1 at Water Barn
The units to be purchased will utilize defibrillation pads that match the pads used by the
department’s heart monitors allowing fire department personnel to simply detach the pads
from the AED and attach to our Lifepac 15 heart monitors. The units will be inspected annually
during the fire and life safety inspections conducted by the Fire Department. Free training is
offered to citizens by the fire department on an as needed basis as part of our CPR classes.
October 15, 2018 Regular Meeting Agenda Packet
160 of 171
FY October November December January February March April May June July August September Total Year
2008 63,250 47,082 33,371 37,194 31,472 30,766 40,313 48,829 78,091 91,664 115,042 75,494 692,568
2009 63,730 48,170 35,215 35,759 32,240 39,331 46,151 37,382 56,370 125,089 91,724 79,137 690,298
2010 39,794 39,713 29,547 30,305 25,328 23,279 41,646 53,439 102,921 89,760 128,687 82,331 686,750
2011 70,502 50,909 44,365 35,983 27,845 55,972 69,165 61,467 99,326 117,707 170,464 123,692 927,397
2012 85,869 53,571 40,815 30,616 31,665 35,263 47,194 84,905 114,104 137,174 144,573 108,622 914,371
2013 85,488 75,251 48,527 39,601 34,450 43,137 56,947 76,542 85,312 110,072 130,945 114,497 900,769
2014 82,660 48,813 34,482 39,767 37,085 54,794 66,337 84,384 99,240 92,913 113,135 110,873 864,483
2015 90,994 58,986 49,607 36,162 38,776 30,566 46,543 39,576 60,731 100,622 139,441 123,886 815,890
2016 108,951 41,936 39,028 39,622 44,551 49,498 55,181 50,827 65,390 115,687 119,611 98,945 829,227
2017 74,785 68,638 38,580 33,028 38,380 60,841 56,683 86,794 98,864 95,355 104,303 99,541 855,792
2018 83,228 69,099 48,144 34,592 40,658 43,411 60,079 89,802 118,899 126,588 125,531 73,735 913,766
FY October November December January February March April May June July August September Total Year
2008 64,370 50,090 35,320 36,610 34,630 34,750 42,900 63,116 78,399 114,256 98,670 72,551 725,662
2009 65,110 48,570 36,411 36,587 36,385 44,120 48,881 38,250 66,450 116,823 94,525 81,500 713,612
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
FY October November December January February March April May June July August September
2008 2869 2857 2867 2853 2865 2865 2855 2897 2897 2914 2927 2929
2009 2946 2952 2956 2976 2977 3013 3014 3004 3056 3064 3083 3105
2010 3113 3127 3146 3151 3168 3201 3210 3229 3251 3260 3282 3298
2011 3318 3334 3351 3358 3366 3392 3409 3465 3433 3471 3559 3573
2012 3542 3540 3582 3640 3667 3701 3725 3735 3759 3796 3815 3863
2014 Total 4139 4157 4173 4206 4209 4219 4240 4268 4280 4308 4333 4339
2014 MUD 3014 3015 3014 3028 3026 3031 3037 3052 3058 3072 3078 3080
2014 PID 1125 1142 1159 1178 1183 1188 1203 1216 1222 1236 1255 1259
2015 Total 4353 4363 4377 4404 4413 4429 4443 4459 4478 4486 4498 4517
2015 MUD 3083 3087 3095 3119 3120 3122 3123 3128 3133 3134 3137 3149
2015 PID 1270 1276 1282 1285 1293 1307 1320 1331 1345 1352 1361 1368
2016 Total 4531 4538 4556 4568 4593 4604 4607 4616 4622 4627 4632 4636
2016 MUD 3155 3158 3167 3172 3176 3181 3183 3186 3188 3192 3196 3200
2016 PID 1376 1380 1389 1396 1417 1423 1424 1430 1434 1435 1436 1436
2017 Total 4644 4647 4661 4657 4663 4666 4670 4676 4685 4690 4696 4700
2017 MUD 3208 3210 3220 3216 3221 3224 3228 3234 3242 3247 3252 3256
2017 PID 1436 1437 1441 1441 1442 1442 1442 1442 1443 1443 1444 1444
2018 Total 4701 4706 4712 4716 4720 4724 4724 4728 4732 4735 4736 4738
2018 MUD 3257 3262 3268 3272 3276 3280 3280 3284 3288 3291 3292 3294
2018 PID 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444
Monthly Water Operations Report
Water Billed
Water Pumped
Active Connections
0
20,000
40,000
60,000
80,000
100,000
120,000
140,000
160,000
October November December January February March April May June July August September
WATER BILLED IN THOUSANDS OF GALLONS
2014
2015
2016
2017
2018
0
20,000
40,000
60,000
80,000
100,000
120,000
140,000
160,000
180,000
October November December January February March April May June July August September
WATER PUMPED IN THOUSANDS OF GALLONS
2014
2015
2016
2017
2018
October 15, 2018 Regular Meeting Agenda Packet
161 of 171
Influent EffluentInfluent EffluentInfluent Effluent4‐Sep 42.8 0.2 99.5% 166 2.0 98.8% 205 1.0 99.5%5‐Sep 34.5 0.29 99.2% 157 2.0 98.7% 218 1.0 99.5% 10‐Sep 44.5 0.20 99.6% 175 2.0 98.9% 328 1.0 99.7%11‐Sep 47.0 0.20 99.6% 124 2.0 98.4% 130 1.0 99.2% 17‐Sep 42.5 0.20 99.5% 113 2.0 98.2% 175 1.2 99.3%18‐Sep 49.6 0.20 99.6% 218 2.0 99.1% 298 1.0 99.7% 24‐Sep 37.0 0.28 99.2% 121 2.0 98.3% 248 1.0 99.6%27‐Sep 42.5 0.68 98.4% 201 2.0 99.0% 288 1.0 99.7%99.3%98.7%99.5%September 2018 ResultsAmmonia‐NCBOD5TSS0.282.01.0Ammonia‐NCBOD5TSSDate% Removal% Removal% RemovalReportOctober 15, 2018 Regular Meeting Agenda Packet162 of 171
Max mg/L0.49Aver mg/L0.292Max mg/L2.0Aver mg/L2.0Ammonia NitrogenCarbonaceous Biochemical Demand (CBOD5)0.210.3300.4900.2510.2800.2200.2000.3700.28100.511.522.533.5Jan‐18 Feb‐18 Mar‐18 Apr‐18 May‐18 Jun‐18 Jul‐18 Aug‐18 Sep‐18 Oct‐18 Nov‐18 Dec‐18NH‐3 mg/LAveragePermit Limit2.02.02.02.02.02.02.02.02.00.0001.0002.0003.0004.0005.0006.000Jan‐18 Feb‐18 Mar‐18 Apr‐18 May‐18 Jun‐18 Jul‐18 Aug‐18 Sep‐18 Oct‐18 Nov‐18 Dec‐18CBOD5AveragePermit LimitOctober 15, 2018 Regular Meeting Agenda Packet163 of 171
Max mg/L1.04Aver mg/L1.0Max mg/L8.8Aver mg/L5.0Total Suspended Solids (TSS)Nitrate - Nitrogen1.01.01.01.01.01.01.01.01.00.02.04.06.08.010.012.014.0Jan‐18 Feb‐18 Mar‐18 Apr‐18 May‐18 Jun‐18 Jul‐18 Aug‐18 Sep‐18 Oct‐18 Nov‐18 Dec‐18TSSAveragePermit Limit8.84.07.44.73.53.84.64.04.60.05.010.015.020.025.030.0Jan‐18 Feb‐18 Mar‐18 Apr‐18 May‐18 Jun‐18 Jul‐18 Aug‐18 Sep‐18 Oct‐18 Nov‐18 Dec‐18Nitrate‐NAveragePermit LimitOctober 15, 2018 Regular Meeting Agenda Packet164 of 171
Max mg/L5.0Aver mg/L1.9Max mg/L7.8Min mg/L7.2Aver mg/L7.3Potential for Hydrogen (pH)E. Coli1.04.01.05.02.01.01.01.01.00.020.040.060.080.0100.0120.0140.0Jan‐18 Feb‐18 Mar‐18 Apr‐18 May‐18 Jun‐18 Jul‐18 Aug‐18 Sep‐18 Oct‐18 Nov‐18 Dec‐18E. ColiAveragePermit Limit7.27.27.27.37.37.27.27.57.277.37.47.47.37.67.77.57.87.40.01.02.03.04.05.06.07.08.09.010.0Jan‐18 Feb‐18 Mar‐18 Apr‐18 May‐18 Jun‐18 Jul‐18 Aug‐18 Sep‐18 Oct‐18 Nov‐18 Dec‐18pH MinAveragePermit Limit MinPermit Limit MaxpH MaxOctober 15, 2018 Regular Meeting Agenda Packet165 of 171
Max mg/L7.8Aver mg/L7.3 Dissolved Oxygen (DO)7.87.57.87.67.47.47.06.57.10.01.02.03.04.05.06.07.08.09.0Jan‐18 Feb‐18 Mar‐18 Apr‐18 May‐18 Jun‐18 Jul‐18 Aug‐18 Sep‐18 Oct‐18 Nov‐18 Dec‐18DOAveragePermit LimitOctober 15, 2018 Regular Meeting Agenda Packet166 of 171
October November December January February March April May June July August September
ebills 796 828 829 834 839 844 841 849 848 851 860 865
Bills Mailed 3906 3900 3912 3911 3908 3913 3921 3935 3956 3946 3948 3929
Bank Draft 631 623 639 653 657 656 655 654 660 651 654 653
Credit Card Draft 1018 1020 1026 1033 1042 1056 1054 1056 1067 1068 1061 1076
Online Payments 1037 1079 1,072 1,065 1,086 1,097 1,019 1,080 1,084 1128 1130 1102
Late Notices 391 420 457 362 424 407 299 355 413 352 427 438
Disconnects 25 27 27 25 22 27 24 17 20 20 16 30
M 3257 3262 3268 3272 3276 3280 3280 3284 3288 3291 3292 3294
Connections P 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444
October November December January February March April May June July August September
ebills 758 758 778 780 780 799 810 819 821 809 820 819
Bills Mailed 3870 3866 3900 3884 3875 3876 3877 3890 3907 3903 3920 3910
Bank Draft 624 610 623 608 617 620 622 626 637 645 641 631
Credit Card Draft 882 897 949 944 945 927 964 960 964 969 978 1011
Online Payments 1041 1057 1,029 1,028 1,025 1,062 1,027 1,062 1,071 1065 1075 1087
Late Notices 506 455 471 382 491 500 476 439 435 466 406 467
Disconnects 30 37 37 44 35 51 61 40 45 44 23 11
3208 3210 3214 3216 3221 3224 3228 3234 3242 3247 3252 3256
Active Connections 1436 1437 1441 1441 1442 1442 1442 1442 1443 1443 1444 1444
Trophy Club MUD #1
Utility Billing Report
Fiscal Year 2018
Fiscal Year 2017
October 15, 2018 Regular Meeting Agenda Packet
167 of 171
MUD Permits
Month: September 2018
Date of
Permit Permit No.
Customer Deposit
135-25030
Due to FW Water 135-
20500 Oversize Meter 135-49075
Plumbing
Inspections 135-
47035
Sewer
Inspections 135-
47045 Fire Line 135-49900
Misc Income
135-49900 Total
9/26/2018 2018-0035 75.00$ 1,173.00$ 343.00$ 150.00$ 50.00$ 1,791.00$
9/28/2018 2018-0044 75.00$ 1,173.00$ 343.00$ 150.00$ 50.00$ 1,791.00$
Total 150.00$ 2,346.00$ 686.00$ 300.00$ 100.00$ -$ -$ 3,582.00$
October 15, 2018 Regular Meeting Agenda Packet
168 of 171
135-10175 Bank of the West MMA (XXX6372) General Fund Operating $0 $0 $0
135-10250 TexPool O & M (XXXXX0002)-General Fund Operating ***$0 $3,227,798 $3,227,798
135-10300 Prosperity Bank (XXX8701) General Fund Operating *$312,115 $1,067,537 $1,379,652
135-10305 Prosperity Bank Reserve-Savings Acct (XXXXX7724)$983,515 $0 $983,515
135-11100 Petty Cash Administration $0 $150 $150
135-11150 Petty Cash Utility Billing $0 $450 $450
137-10250 TexPool O & M (XXXXX0002) GASB Replacement $596,426 $0 $596,426
517-10250 TexPool Construction Tax (XXXXX011) WWTP Improvements $0 $0 $0
517-10300 Prosperity Bank Construction WWTP Improvements $0 $0 $0
519-10250 Texpool Revenue Bond Construction (XXXXX015) SWIFT $0 $0 $0
519-11155 Cash-Bond Escrow Bank of Texas (SWIFT)$767,358 $0 $767,358
528-10250 TexPool Revenue Bond Reserve (XXXXX014) WWTP Improvements $606,910 $0 $606,910
533-10250 TexPool Tax I & S (XXXXX0003)$48,716 $0 $48,716
533-10300 Prosperity Bank (XXX8701) Tax I&S $4,573 $0 $4,573
534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements $19,562 $0 $19,562
535-10250 Texpool Revenue I & S (XXXXX017) SWIFT $2,584 $0 $2,584
$3,341,758 $4,295,934 $7,637,692
Amount available in cash (MUD Accounts)$4,295,934
Amount available for spending (MUD Accounts)$4,295,934
* 09/30/18 Customer Water Deposits $312,115
122-10250 TexPool O & M (XXXXX0002)-Fire Operating Cash $0 $543,883 $543,883
122-10300 Prosperity Bank (XXX8701) Fire Operating $0 $0 $0
$0 $543,883 $543,883
Amount available in cash (Fire Department Accounts)$543,883
Amount available for spending (Fire Department Accounts)$543,883
-$ Bank of the West MM
1,067,537$ Prosperity General Fund
3,227,798$ Texpool General Fund
600$ Petty Cash
Total General Fund 135 Available for Spending 4,295,934$
Nonspendable Fund Balance (Prepaids)8,486$
Assigned Fund Balance (FY2018 Capital Projects plus prior year carry forward)1,778,760$
Unassigned Fund Balance 2,368,122$
Current Year Revenue/Expenses 2,302,431$
Total Nonspendable, Assigned & Committed Fund Balances - General Fund 135 $6,457,799
General Fund 135 Available
General Fund 135 Fund Balances
Fire Department Cash
CASH STATUS AS OF SEPTEMBER 2018 Restricted -
Unable to be spent
Unrestricted-
Available for
spending
Total in Accounts
(Restricted &
Unrestricted)
October 15, 2018 Regular Meeting Agenda Packet
169 of 171
TC Meeting Spaces Modi er
November 2018
Powered by
Calendars
FS Conference Room
FS Training Room
PS Large Conference Room
Svore Board Room
Sun Mon Tue Wed Thu Fri Sat
44
45
46
47
48
Oct , Nov
: pm Trophy Clu pm Office Closes a Holiday
Dec
October 15, 2018 Regular Meeting Agenda Packet
170 of 171
TC Meeting Spaces Modi er
December 2018
Powered by
Calendars
FS Conference Room
FS Training Room
PS Large Conference Room
Svore Board Room
Sun Mon Tue Wed Thu Fri Sat
48
49
50
51
52
1
Nov , Dec
: pm Trophy Clu
Jan
October 15, 2018 Regular Meeting Agenda Packet
171 of 171