HomeMy WebLinkAbout2018-0716 July 16 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, July 16, 2018 6:30 P.M. Svore Municipal Boardroom
REGULAR MEETING AGENDA PACKET
CALL TO ORDER AND ANNOUNCE A QUORUM
CITIZEN COMMENTS
This is an opportunity for citizens to address the Board on any matter whether or not it is posted on the agenda.
The Board is not permitted to take action on or discuss any presentations made to the Board at this time
concerning an item not listed on the agenda. The Board will hear presentations on specific agenda items prior
to the Board addressing those items. You may speak up to three (3) minutes or the time limit determined by
the President or presiding officer.
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. June 2018 Check Register
b. June 18, 2018 Special Meeting Minutes
c. June 18, 2018 Regular Meeting Minutes
d. Tax Collections Report – 3rd Quarter FY2018
e. Quarterly Investment Report – 3rd Quarter FY2018
attachments: June 2018 Check Register
June 18, 2018 Special Meeting Minutes
June 18, 2018 Regular Meeting Minutes
Tax Collections Report – 3rd Quarter FY2018
Quarterly Investment Report – 3rd Quarter FY2018
REGULAR SESSION
2. Receive update from Fire Chief Wade Carroll regarding Fire Protection Services Fiscal Year 2019 budget.
3. Consider and take appropriate action regarding the 2017 Consumer Confidence Report.
attachment: 2017 CCR
4. Consider and take appropriate action to approve an Interlocal Agreement with Denton County for Tax
Collection Services for FY 2018‐2019.
July 18, 2018 Regular Meeting Agenda Packet
1 of 182
attachment: Denton County ILA
5. Consider and take appropriate action relating to District rebranding. (Rose/Castonguay)
attachment: Logo Presentation
6. Consider and take appropriate action regarding the June 2018 Combined Financials and Variance Report.
a. Combined Financials
b. Combined Variance
attachments: Combined financials
Combined Variance
7. Consider and take appropriate action to set the date and time for a special meeting budget workshop to
review preliminary budget.
attachment: Staff report
Meeting calendar
REPORTS & UPDATES
8. Receive report from Directors who attended the Association of Water Board Directors 2018 Annual
Conference.
9. 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
Cash Report
attachments: General Manager Report
Water Operations Report
Wastewater Operations Report
Utility Billing Report
Permits Collected Report
Cash Report
July 18, 2018 Regular Meeting Agenda Packet
2 of 182
EXECUTIVE SESSION
10. Pursuant to Section 551.071 of the Texas Open Meetings Act, the Board may consult with its attorney in
Executive Session on a matter in which the duty of the attorney to the Governmental Body under the
Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflicts with the Open
Meetings Act or to seek advice of counsel on legal matters involving pending or contemplated litigation
or settlement offers:
a. Contractor breach, performance and payment issues related to District’s contract with Webber‐
Cadagua Partners for construction of the Wastewater Treatment Plant Improvements; and
b. Trophy Club Municipal Utility District No. 1 v. Acadia Services, LLC, In the District Court of Tarrant
County, 141st Judicial District (Cause No. 141‐299351‐18).
11. Pursuant to Section 551.072 of the Texas Open Meetings Act, the Board may deliberate the purchase,
exchange, lease, or value of real property if deliberation in an open meeting would have a detrimental
effect on the position of the governmental body in negotiations with a third person:
a. District real property located at 100 Municipal Drive and 1501 Junction Way.
REGULAR SESSION
12. Consider and take appropriate action on matters deliberated in Executive Session:
13. Items for future agendas:
14. Set future Meeting dates: Joint Meeting with Town Council – Tuesday, July 24, 2018
Regular August Board Meeting – Monday, August 20, 2018 at 6:30 p.m.
attachment: Meeting calendar
*THE BOARD RESERVES THE RIGHT TO ADJOURN INTO EXECUTIVE SESSION AT ANY TIME DURING THE
MEETING PURSUANT TO THE APPLICABLE SECTION OF SUBCHAPTER D, CHAPTER 551, TEXAS GOVERNMENT
CODE, THE TEXAS OPEN MEETINGS ACT, WITH RESPECT TO ANY ITEM ON THE AGENDA. NO FINAL ACTION,
DECISION OR VOTE WILL BE TAKEN ON ANY SUBJECT OR MATTER IN EXECUTIVE SESSION. THIS NOTICE
MODIFIES THE DISTRICT'S PRIOR PRACTICE OF SPECIFICALLY IDENTIFYING ALL AGENDA ITEMS TO BE
DISCUSSED IN EXECUTIVE SESSION.
ADJOURN
THE STATE OF TEXAS §
COUNTIES OF DENTON AND TARRANT §
THIS NOTICE CERTIFIES THAT BY 6:30 P.M. ON THURSDAY, JULY 12, 2018, THE AGENDA OF TROPHY CLUB
MUNICIPAL UTILITY DISTRICT NO. 1, BOARD OF DIRECTORS REGULAR MEETING TO BE HELD ON MONDAY,
JULY 16, 2018 AT 6:30 P.M., WAS POSTED ON THE FRONT WINDOW OF TROPHY CLUB MUNICIPAL UTILITY
DISTRICT NO. 1 ADMINISTRATION BUILDING, 100 MUNICIPAL DRIVE, TROPHY CLUB, TEXAS, WHICH IS A
July 18, 2018 Regular Meeting Agenda Packet
3 of 182
PLACE CONVENIENT TO THE PUBLIC AND WITHIN THE BOUNDARIES OF THE DISTRICT AND NOTIFICATION
WAS POSTED TO THE DISTRICT WEBSITE, IN ACCORDANCE WITH SECTION 49.063 OF THE WATER CODE AND
SECTION 551.054 OF THE TEXAS GOVERNMENT CODE, AS AMENDED.
LAURIE SLAGHT, DISTRICT SECRETARY
THIS OFFICIAL AGENDA WAS POSTED ON THE
WINDOW OF TROPHY CLUB MUNICIPAL UTILITY
DISTRICT NO. 1 ADMINISTRATION BUILDING ON
JULY 12, 2018 AT: __________________________
BY: ______________________________________
July 18, 2018 Regular Meeting Agenda Packet
4 of 182
July 18, 2018 Regular Meeting Agenda Packet
5 of 182
July 18, 2018 Regular Meeting Agenda Packet
6 of 182
July 18, 2018 Regular Meeting Agenda Packet
7 of 182
July 18, 2018 Regular Meeting Agenda Packet
8 of 182
July 18, 2018 Regular Meeting Agenda Packet
9 of 182
July 18, 2018 Regular Meeting Agenda Packet
10 of 182
July 18, 2018 Regular Meeting Agenda Packet
11 of 182
SPECIAL WORKSHOP MEETING MINUTES
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
BOARD OF DIRECTORS
June 18, 2018 at 4:00 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
Special Workshop Session on Monday, June 18, 2018 at 4:00 P.M., in the Boardroom of the Administration
Building, 100 Municipal Drive, Trophy Club, Texas 76262. The meeting was held within the boundaries of
the District, and was open to the public.
STATE OF TEXAS §
COUNTIES OF DENTON AND TARRANT §
BOARD MEMBERS PRESENT:
Gregory Wilson President
William C. Rose Vice President
Steve Flynn Secretary/Treasurer
Kelly Castonguay Director
Mark Chapman Director
STAFF PRESENT:
John Carman General Manager
Laurie Slaght District Secretary
Mike McMahon Water Superintendent
Steven Krolczyk Finance Manager
Tony Corbett Legal Counsel
CALL TO ORDER AND ANNOUNCE A QUORUM
Director Wilson announced the date of Monday, June 18, 2018, stated a quorum of the board was present
and called the meeting to order at 4:01 p.m.
LEGAL ORIENTATION WORKSHOP
1. District Legal Counsel Tony Corbett made a presentation to the Board of Directors relating to general
legal matters applicable to the District and members of the Board of Directors. Mr. Corbett’s
presentation addressed the following topics:
a) Texas laws applicable to public officials:
1) Texas Open Meetings Act;
2) Texas Public Information Act;
3) Conflict of Interest Laws:
i. Chapter 171 Texas Local Government Code
ii. Chapter 176, Texas Local Government Code
iii. Chapter 573, Government Code (Nepotism)
4) Texas Penal Code Statutes Applicable to Public Officials:
i. Bribery Statutes
ii. Honorariums
iii. Gifts
iv. Abuse of Official Capacity
June 18, 2018 Special Meeting Minutes
1 of 2
July 18, 2018 Regular Meeting Agenda Packet
12 of 182
[Editor’s Note: The Board recessed the meeting at 5:25 p.m. The meeting reconvened at 5:33
p.m. with all directors present.]
b) Financial Matters:
1) Budget and Tax Rate Adoption Requirements;
2) Summary of Outstanding District Bonds and Debt Obligations and related covenants; and
3) District Revenue Sources.
c) District Boundary Matters:
1) Laws Governing the Annexation and Exclusion of Real Property.
d) Laws Governing Disposition of District Property; and
e) Laws, Policies and Restrictions relating to the conduct of District Business and Operations:
1) General Duties, Roles and Responsibilities of Board of Directors; and
2) Bylaws of the District.
The Board took no action and conducted no votes during the workshop.
ADJOURN
Director Wilson adjourned the meeting at 6:01 p.m.
_______________________________
Gregory Wilson, President
_______________________________
Steven J. Flynn, Secretary/Treasurer (SEAL)
_______________________________
Laurie Slaght, District Secretary
June 18, 2018 Special Meeting Minutes
2 of 2
July 18, 2018 Regular Meeting Agenda Packet
13 of 182
REGULAR MEETING MINUTES
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
BOARD OF DIRECTORS
June 18, 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 regular
session on Monday, June 18, 2018 at 6:30 P.M., in the Boardroom of the Administration Building located at
100 Municipal Drive, Trophy Club, Texas 76262. The meeting was held within the boundaries of the District,
and was open to the public.
STATE OF TEXAS §
COUNTIES OF DENTON AND TARRANT §
BOARD MEMBERS PRESENT:
Gregory Wilson President
William C. Rose Vice President
Steve Flynn Secretary/Treasurer
Kelly Castonguay Director
Mark Chapman Director
STAFF PRESENT:
John Carman General Manager
Laurie Slaght District Secretary
Mike McMahon Water Superintendent
Steven Krolczyk Finance Manager
Tony Corbett Legal Counsel
CALL TO ORDER AND ANNOUNCE A QUORUM
President Wilson announced the date of June 18, 2018, announced a quorum of the board was present and
called the meeting to order at 6:30 p.m.
CITIZEN COMMENTS
There were no Citizen Comments
CONSENT AGENDA
1. Consider and take appropriate action to approve the Consent Age nda.
a. May 2018 Check Register
b. May 15, 2018 Regular Meeting Minutes
c. June 7, 2018 Special Meeting Minutes
Director Rose requested that item b. May 15, 2018 Regular Meeting minutes be removed from the
Consent Agenda for further consideration by the Board.
Motion made by Director Rose and seconded by Director Chapman to approve Consent Agenda items a.
and c. and b. as amended at the dais.
Motion carried unanimously
June 18, 2018 Regular Meeting Minutes
1 of 6
July 18, 2018 Regular Meeting Agenda Packet
14 of 182
REGULAR SESSION
2. Consider and take appropriate action to Appoint Alternate Member to Wholesale Customer Advisory
Committee for the City of Fort Worth.
Motion made by Director Rose and seconded by Director Castonguay to appoint the Primary Member to
the Wholesale advisory committee for the City of Fort Worth to be Mike McMahon and the Alternate
Member to the Wholesale Advisory Committee for the City of Fort Worth to be Steven Krolczyk.
Motion is withdrawn by the first and second
Motion made by Director Rose and seconded by Director Castonguay to appoint Steven Krolczyk to be the
Alternate Member to the Wholesale Advisory Committee for the City of Fort Worth.
Motion carried unanimously
3. Consider and take appropriate action to appoint two (2) directors to serve on the Rate Committee to
work with staff to review and develop recommendations regarding water and sewer rates for Fiscal Year
2019. (Staff)
Motion made by Director Wilson and seconded by Director Castonguay to appoint President Wilson and
Secretary/Treasurer Flynn to the Rate Committee for Fiscal Year 2019 to develop recommended water and
sewer rates.
For: Flynn, Wilson and Castonguay
Oppose: Chapman and Rose
Motion passed 3‐2
4. Consider and take appropriate action regarding adoption of Resolution No. 2018‐0618A Authorizing the
General Manager to Approve Construction Contract Change Orders. (Staff)
Main Motion
Motion made by Director Rose and seconded by Director Chapman to approve Resolution No. 2018‐0618A
Authorizing the General Manager to Approve Construction Contract Change Orders.
First amendment to the main motion
Motion made by Director Rose seconded by Director Chapman to amend Resolution 2018‐0618A, No. 2 to
read as follows:
The Board of Directors of the District hereby authorizes its General Manager to approve a change order to
a contract for the construction, repair or renovation of District facilities subject to the following terms and
limitations;
Motion for the first amendment to the main motion carried unanimously
Second amendment to the main motion
Motion made by Director Rose and seconded by Director Chapman to amend Resolution 2018‐0618A, No.
2. (b) to read as follows:
June 18, 2018 Regular Meeting Minutes
2 of 6
July 18, 2018 Regular Meeting Agenda Packet
15 of 182
The General Manager may only approve change orders in an amount that when aggregated with all other
change orders approved by the General Manager within that contract does not exceed the contingency of
that contract;
For: Rose, Castonguay, Chapman, and Flynn
Oppose: Wilson
Motion for the second amendment to the main motion passed 4‐1
Main Motion as Amended
For: Castonguay, Chapman, Flynn and Rose
Oppose: Wilson
Motion passed 4‐1
5. Consider and take appropriate action to adopt Order No. 2018‐0618A Approving a Public Presentations
Policy. (Rose/Flynn)
Attorney Corbett will conduct further review and bring his suggestions this back to the board.
Item is Tabled.
6. Consider and take appropriate action regarding Order No. 2018‐0618B Authorizing the General Manager
to approve certain expenditures, sign disbursements and enter into contracts on behalf of the District
and containing other matters relating thereto. (Staff)
Motion made by Director Rose and seconded by Director Wilson to adopt Order No. 2018‐0618B
Authorizing the General Manager to approve certain expenditures, sign disbursements and enter into
contracts on behalf of the District and containing other matters relating thereto with the following
amendments:
Insert page 3 to read “Exhibit A”, Section 4.02 Delete the “City of Fort Worth”, “For”, and add a comma
after payments. Section 4.08 d. the first sentence of the section shall read as follows: “The General
Manager may approve the electronic transfer of District funds for authorized investments, as identified in
the District’s Investment Policy.” And delete the remaining portion of that sentence, “and only upon prior
approval of an Investment Officer of the District.”
Motion carried unanimously
7. Consider and take appropriate action regarding approval of Change Order No. 15 from Webber‐Cadagua
Partners in an amount of $35,566 for Wastewater Treatment Plant improvements. (Staff)
Webber‐Cadagua was requesting a payment $35,566 for change order no. 15, however, CP&Y
negotiated that amount to $25,269.64.
Motion made by Director Rose and seconded by Director Castonguay to approve Change Order 15 for an
June 18, 2018 Regular Meeting Minutes
3 of 6
July 18, 2018 Regular Meeting Agenda Packet
16 of 182
amount not to exceed $25,269.49.
Motion carried unanimously
8. Consider and take appropriate action regarding Independent Contractor Agreement for General
Manager Services:
a. Performance Evaluation of General Manager; and
b. Discussion and possible action regarding approval of Second Amendment to Independent Contractor
Agreement relating to compensation.
Motion made by Director Wilson and seconded by Director Rose to strike the hard cap of $144,000 in
section 2.1 of the General Manager contract.
Motion carried unanimously
Motion made by Director Wilson and seconded by Director Rose to increase the General Managers hourly
rate from $75 to $80 per hour.
Rose, Flynn, Castonguay, Wilson
Oppose: Chapman
Motion passed 4‐1
Motion made by Director Wilson and seconded by Director Castonguay to allow reimbursement of
expenses for General Manager for any mileage that exceeds the distance between traveling from his
residence to the jobsite or when traveling on district business.
Motion carried unanimously
9. Consider and take appropriate action regarding the May 2018 Combined Financials and Variance Report.
a. Combined Financials
b. Combined Variance
Motion made by Director Flynn and seconded by Director Chapman to approve the May 2018 Financials
and Variance Report.
Motion carried unanimously
10. Discussion and possible action regarding Joint Meeting between Trophy Club Municipal Utility District
No. 1 Board of Directors and Trophy Club Town Council.
a. Meeting date and time
b. Agenda items
June 18, 2018 Regular Meeting Minutes
4 of 6
July 18, 2018 Regular Meeting Agenda Packet
17 of 182
The General Manager reviewed the proposed agenda items provided by the town for the joint meeting
and stated that the town has suggested it be held on Tuesday, July 24th in the District boardroom. The
board is comfortable with the proposed date, time and tentative agenda. The General Manager stated
that he will work with the Town Manager on the agenda for the meeting.
11. Consider and take appropriate action regarding Director Workshop Meeting. (Flynn/Rose)
Direction was provided to staff to plan a special workshop meeting for July 9th from 6 p.m. to 10 p.m.
REPORTS & UPDATES
12. General Manager Monthly Reports and Update:
a. Regulatory Update
b. Capital Improvement Projects
16‐inch waterline to serve Town Center
Wastewater Treatment Plant Upgrade Project
High Service Pump
Joint Projects with Town
East Ground Storage Tank
c. Fire Department Summary
d. Water System Operation
e. Wastewater System Operation
f. Finance Update
Utility Billing Report
Permits Collected
Cash Report
General Manager John Carman presented his monthly updated to the Board and answered questions
related thereto.
The Board convened into Executive Session at 9:32 p.m.
EXECUTIVE SESSION
13. 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).
14. 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
June 18, 2018 Regular Meeting Minutes
5 of 6
July 18, 2018 Regular Meeting Agenda Packet
18 of 182
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 reconvened into Regular Session at 10:58 p.m.
REGULAR SESSION
16. Consider and take appropriate action on matters deliberated in Executive Session:
Director Wilson stated that no final decisions, actions or votes were taken in Executive Session.
Motion made by Director Rose and seconded by Director Castonguay to direct the General Manager to
enter into discussion with the Town Manager concerning negotiations for properties located at 100
Municipal Drive, and 1501 Junction Way.
Motion carried unanimously
17. Items for future agendas: ‐ Public Presentation Policy
18. Set future Meeting dates – Next Regular Meeting – Monday, July 16, 2018 at 6:30 p.m.
Budget Workshop Special Meeting – Monday, July 9th 6‐10 p.m.
Joint Meeting with Town Council – Tuesday, July 24th 6‐7 p.m.
Motion made by Director Rose and seconded by Director Flynn to adjourn.
Motion carried unanimously
ADJOURN
Director Wilson adjourned the meeting at 11:02 p.m.
_______________________________
Gregory Wilson, President
_______________________________
Steven J. Flynn, Secretary/Treasurer (SEAL)
_______________________________
Laurie Slaght, District Secretary
June 18, 2018 Regular Meeting Minutes
6 of 6
July 18, 2018 Regular Meeting Agenda Packet
19 of 182
July 18, 2018 Regular Meeting Agenda Packet
20 of 182
July 18, 2018 Regular Meeting Agenda Packet
21 of 182
July 18, 2018 Regular Meeting Agenda Packet
22 of 182
July 18, 2018 Regular Meeting Agenda Packet
23 of 182
July 18, 2018 Regular Meeting Agenda Packet
24 of 182
July 18, 2018 Regular Meeting Agenda Packet
25 of 182
July 18, 2018 Regular Meeting Agenda Packet
26 of 182
July 18, 2018 Regular Meeting Agenda Packet
27 of 182
July 18, 2018 Regular Meeting Agenda Packet
28 of 182
July 18, 2018 Regular Meeting Agenda Packet
29 of 182
July 18, 2018 Regular Meeting Agenda Packet
30 of 182
July 18, 2018 Regular Meeting Agenda Packet
31 of 182
July 18, 2018 Regular Meeting Agenda Packet
32 of 182
July 18, 2018 Regular Meeting Agenda Packet
33 of 182
July 18, 2018 Regular Meeting Agenda Packet
34 of 182
July 18, 2018 Regular Meeting Agenda Packet
35 of 182
July 18, 2018 Regular Meeting Agenda Packet
36 of 182
July 18, 2018 Regular Meeting Agenda Packet
37 of 182
July 18, 2018 Regular Meeting Agenda Packet
38 of 182
July 18, 2018 Regular Meeting Agenda Packet
39 of 182
July 18, 2018 Regular Meeting Agenda Packet
40 of 182
July 18, 2018 Regular Meeting Agenda Packet
41 of 182
July 18, 2018 Regular Meeting Agenda Packet
42 of 182
July 18, 2018 Regular Meeting Agenda Packet
43 of 182
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 06/30/2018 (April, May, and June 2018)John CarmanDATERstricted/Account orSec Rate /Call Purchase Begining Book Begining Market Ending Book Ending Market Gain/LossUnrestrictedCUSIPTypeParCoupon Maturity Date Price Yield % 3/31/2018 3/31/2018 6/30/2018 6/30/2018 End MV-End BVChecking & Money Market AccountsUnrestricted- 135XXX6372Bank of the West Money Market Account715,223$ 0.000% N/A N/A 100.000 0.250%714,777$ 714,777$ 715,223$ 715,223$ 0.00Unrestricted- 135XXX8701Prosperity Bank Consolidated Cash-General Fund 1,362,938$ 0.000% N/A N/A 100.000 0.350%1,479,874$ 1,479,874$ 1,362,938$ 1,362,938$ 0.00Unrestricted- 122XXX8701Prosperity Bank Consolidated Cash-Fire Dept60,743$ 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-Operating2,261,972$ 0.000% N/A N/A 100.000 0.373%1,049,126$ 1,049,126$ 2,261,972$ 2,261,972$ 0.00Restricted- 122TexPool Municipal Fund-Fire Dept691,610$ 0.000% N/A N/A 100.000 0.373%827,240$ 827,240$ 691,610$ 691,610$ 0.00Restricted- 137TexPool Municipal Fund-GASB Replacemenent596,426$ 0.000% N/A N/A 100.000 0.373%596,426$ 596,426$ 596,426$ 596,426$ 0.00Restricted- 533XXXXX0003TexPool Tax Debt Service888,505$ 0.000% N/A N/A 100.000 0.373%842,208$ 842,208$ 888,505$ 888,505$ 0.00Restricted- 517XXXXX00011TexPool WW Construction Tax-$ 0.000% N/A N/A 100.000 0.373%363,680$ 363,680$ -$ -$ 0.00Restricted- 534XXXXX00013Texpool Revenue Bond I&S396,346$ 0.000% N/A N/A 100.000 0.373%231,796$ 231,796$ 396,346$ 396,346$ 0.00Restricted- 528XXXXX00014Texpool Revenue Bond Reserve561,007$ 0.000% N/A N/A 100.000 0.373%515,627$ 515,627$ 561,007$ 561,007$ 0.00Restricted- 519XXXXX00015Texpool Revenue Bond Construction-SWIFT-$ 0.000% N/A N/A 100.000 0.373%-$ -$ -$ -$ 0.00Restricted- 520XXXXX00016Texpool Revenue Bond Reserve-SWIFT-$ 0.000% N/A N/A 100.000 0.373%-$ -$ -$ -$ 0.00Restricted- 535XXXXX00017Texpool Revenue Bond I&S-SWIFT197,971$ 0.000% N/A N/A 100.000 0.373%121,486$ 121,486$ 197,971$ 197,971$ 0.00Savings Accounts RestrictedXXXXX7724Prosperity Bank Cash Reserve782,658$ 0.000% N/A N/A 100.000 0.250%781,976$ 781,976$ 782,658$ 782,658$ 0.00CD's RestrictedX9534Bank of the West CD-THB*-$ 0.000% 06/15/18 N/A 100.000 0.450%35,316$ 35,316$ -$ -$ 0.00US TreasuriesNONEUS Agencies NONE 8,519,972$ 7,564,105$ 7,564,105$ 8,519,972$ 8,519,972$ -$ EARNINGS SUMMARYRestricted/ Settle DateSec TypeAccount Number Par Coupon Maturity Qtr Accrued Qtr Amort. Total Qtr EarningsUnrestrictedChecking & Money Market AccountsUnrestrictedBank of the West Money Market AccountXXX6372 715,223$ N/A N/A446$ N/A446$ Unrestricted Prosperity Bank Consolidated Cash-General FundXXX8701 1,362,938$ N/A N/A 1,295$ N/A1,295$ UnrestrictedProsperity Bank Consolidated Cash-Fire DeptXXX8701 60,743$ N/A N/A-$ N/A-$ RestrictedProsperity Bank Consolidated Cash-Tax I&SXXX87014,573$ N/A N/A-$ N/A-$ Pools & FundsUnrestricted TexPool Municipal FundXXXXX0002 3,550,008$ N/A N/A 14,320$ N/A14,320$ Restricted TexPool Tax Debt ServiceXXXXX0003 888,505$ N/A N/A 3,710$ N/A3,710$ RestrictedTexPool Construction TaxXXXXX00011-$ N/A N/A642$ N/A642$ RestrictedTexpool Revenue Bond I&SXXXXX00013 396,346$ N/A N/A 1,258$ N/A1,258$ RestrictedTexpool Revenue Bond ReserveXXXXX00014 561,007$ N/A N/A 2,297$ N/A2,297$ RestrictedTexpool Revenue Bond Construction-SWIFTXXXXX00015-$ N/A N/A 1,534$ NA1,534$ RestrictedTexpool Revenue Bond Reserve-SWIFTXXXXX00016-$ N/A N/A-$ NA-$ RestrictedTexpool Revenue Bond I&S-SWIFTXXXXX00017 197,971$ N/A N/A644$ NA644$ Savings AccountsRestricted Prosperity Bank Cash ReserveXXXXX7724 782,658$ N/A N/A682$ N/A682$ CD'sRestrictedBank of the West CD-THB*X9534-$ N/A N/A159$ N/A159$ US Treasuries NONE US Agencies NONE26,986$ N/A26,986$ * Bank of the West CD-THB is being held per agreement for three years with a mature date of 06/15/18. The original amount, along with all interest, has been return to THB and the account is now $0 out as of the end of 06/30/18.PAR for this report is the statement balance on the last day of the quarterJuly 18, 2018 Regular Meeting Agenda Packet44 of 182
Trophy Club Municipal Utility District No. 1
Public Water System ID No. TX0610018
2017 Annual Drinking Water Quality Report
Consumer Confidence Report June 2018
Special Population Advisory
You may be more vulnerable than the general
population to certain microbial contaminants, such as
Cryptosporidium, in drinking water. Infants, some
elderly, or immunocompromised persons such as those
undergoing chemotherapy for cancer; those who have
undergone organ transplants; those who are undergoing
treatment with steroids; and people with HIV/AIDS or
other immune system disorders can be particularly at
risk from infections. You should seek advice about
drinking water from your physician or health care
provider. Additional guidelines on appropriate means to
lessen the risk of infection by Cryptosporidium are
available from the Safe Drinking Water Hotline at (800)
426-4791.
Our Drinking Water Meets or Exceeds All
Federal (EPA) Drinking Water Requirements
This report is a summary of the quality of the water we
provide our customers. The analysis was made by using the
data from the most recent U.S. Environmental Protection
Agency (EPA) required tests and is presented in the
following pages. We hope this information helps you
become more knowledgeable about what is in your drinking
water. Should you have questions or need additional copies
of this report, please call the District office at (682) 831-4600.
The report is also available on our website at
www.tcmud.org.
Water Sources:
The sources of drinking water (both tap water and
bottled water) include rivers, lakes, streams, ponds,
reservoirs, springs, and wells. As water travels over the
surface of the land or through the ground, it dissolves
naturally-occurring minerals, and in some cases,
radioactive material, and can pick up substances
resulting from the presence of animals or from human
activity. Contaminants that may be present in source
water before treatment include:
Microbial contaminants, such as viruses and
bacteria, which may come from sewage
treatment plants, septic systems, and
agricultural livestock operations.
Inorganic contaminants, such as salts and
metals, which can be naturally-occurring or
result from urban storm water runoff, industrial
or domestic wastewater discharges, oil and gas
production, mining, or farming.
Pesticides and herbicides, which may come
from a variety of sources such as agriculture and
urban storm water runoff, and residential uses.
Organic chemical contaminants, including
synthetic and volatile organic chemicals, which
are by-products of industrial processes and
petroleum production, and can also come from
gas stations, urban storm water runoff, and
septic systems.
Radioactive contaminants, which can be
naturally-occurring or be the result of oil and gas
production and mining activities.
Este informe incluye información importante
sobre el agua potable. Si tiene preguntas o
comentarios sobre éste informe en español, favor de
llamar al tel. (682) 831-4600 para hablar con una
persona bilingüe en español.
Public Participation Opportunities
Date: July 16, 2018
Time: 6:30 p.m.
Location: Svore Administration Building
100 Municipal Drive
Trophy Club, TX 76262 En Español
Where Do We Get Our Drinking Water?
Our drinking water is obtained from both surface and
groundwater sources. Surface water is purchased from the
City of Fort Worth and its sources are Lake Worth, Eagle
Mountain Lake, Lake Bridgeport, Richland Chambers
Reservoir, Cedar Creek Reservoir, and the Clear Fork
Trinity River (from Lake Benbrook). Groundwater sources
are from four wells including three from the Paluxy Aquifer
and one from the Trinity Aquifer. The Texas Commission on
Environmental Quality (TCEQ) completed an assessment of
your drinking water sources and results indicate that some
of your sources are susceptible to certain contaminants. The
sampling requirements for your water system are based on
this susceptibility and previous sample data. Any detection
of these contaminants may be found in this report. For more
information about your sources of water please refer to the
Source Water Assessment Viewer available at
http://www.tceq.texas.gov/gis/swaview. Further details
about sources and source-water assessments are available
on Texas Drinking Water Watch at
http://dww2.tceq.texas.gov/DWW/. For more information on
source water assessments and protection efforts at our
system, contact John Carman at (682) 831-4600.
July 18, 2018 Regular Meeting Agenda Packet
45 of 182
All Drinking Water May Contain Contaminants
When drinking water meets federal standards there may not be any health based benefits to purchasing bottled water
or point-of-use devices. Drinking water, including bottled water, may reasonably be expected to contain at least small
amounts of some contaminants. The presence of contaminants does not necessarily indicate that water poses a health
risk. In order to ensure tap water is safe to drink, the EPA and TCEQ prescribe regulations which limit the amount of
certain contaminants in water provided by public water systems. FDA regulations establish limits for contaminants in
bottled water, which must provide the same protection for public health. More information about contaminants and
potential health effects can be obtained by calling the EPA's Safe Drinking Water Hotline at (800) 426-4791.
Water Quality Data
The table in this report lists all the drinking water contaminants we detected during tests conducted from the previous
calendar year, unless otherwise noted. The state requires us to monitor for certain contaminants less than once per year
because the concentrations of these contaminants are not expected to vary significantly from year to year. Therefore,
some of the data, though representative of the water quality, is more than one year old.
Secondary Constituents
Many constituents (such as calcium, sodium or iron) which are often found in drinking water, can cause taste, color and
odor problems. The taste and odor constituents are called secondary constituents and are regulated by the State of
Texas, not the EPA. These constituents are not causes for health concerns. Therefore, secondary constituents are not
required to be reported in this document but they may greatly affect the appearance and taste of your water.
About the Following Pages
The pages that follow list all of the federally regulated or monitored contaminants which have been found in your drinking
water. The United States Environmental Protection Agency (EPA) requires water systems to test up to 97 constituents.
Please note that not all constituents are required to be sampled every year. Only the most recent year for sampling of a
constituent is included in the report.
Definitions
Action Level (AL): The concentration of a contaminant which, if exceeded, triggers treatment or other requirements which a water
system must follow.
Action Level Goal (ALG): The level of a contaminant in drinking water below which there is no known or expected risk to health.
ALGs allow for a margin of safety.
Average (Avg): Regulatory compliance with some MCLs are based on running annual average of monthly samples.
Maximum Contaminant Level (MCL): The highest permissible level of a contaminant in drinking water. MCLs are set as close to
the MCLGs as feasible using the best available treatment technology.
Maximum Contaminant Level Goal (MCLG): The level of a contaminant in drinking water below which there is no known or expected
health risk. MCLGs allow for a margin of safety.
Maximum Residual Disinfectant Level (MRDL): The highest level of disinfectant allowed in drinking water. There is convincing
evidence that addition of a disinfectant is necessary for control of microbial contaminants.
Maximum Residual Disinfectant Level Goal (MRDLG): The level of a drinking water disinfectant below which there is no known or
expected risk to health. MRDLGs do not reflect the benefits of the use of disinfectants to control microbial contamination.
Treatment Technique (TT): A required process intended to reduce the level of a contaminant in drinking water.
Abbreviations
MFL - million fibers per liter (a measure of asbestos) pCi/L - picocuries per liter (a measure of radioactivity)
N/A - not applicable ppm - parts per million, or milligrams per liter (mg/l)
NTU - Nephelometric Turbidity Units ppb - parts per billion, or micrograms per liter (ug/l)
ppq - parts per quadrillion, or picograms per liter mrem/yr – millirems per year
ppt - parts per trillion, or nanograms per liter ND – (not-detectable) lab analysis indicates not present
UMHO/CM – micromhos
Lead and
Copper Date Sampled MCLG Action
Level (AL) 90th
Percentile
# Sites Over
AL Units Violation Likely Source of Contamination
Copper 06/23/2016 1.3 1.3 0.3548 0 ppm N Erosion of natural deposits; Leaching from wood
preservatives; Corrosion of household plumbing systems.
Lead 06/23/2016 0 15 2.9 0 ppb N Corrosion of household plumbing systems; Erosion of
natural deposits.
If present, elevated levels of lead can cause serious health problems, especially for pregnant women and young children. Lead in drinking water is primarily
from materials and components associated with service lines and home plumbing. Trophy Club Municipal Utility District No. 1 is responsible for providing
high quality drinking water, but cannot control the variety of materials used in plumbing components. When your water has been sitting for several hours,
you can minimize the potential for lead exposure by flushing your tap for 30 seconds to 2 minutes before using water for drinking or cooking. If you are
concerned about lead in your water, you may wish to have your water tested. Information on lead in drinking water, testing methods, and steps you can
take to minimize exposure is available from the Safe Drinking Water Hotline or at http://www.epa.gov/safewater/lead.
July 18, 2018 Regular Meeting Agenda Packet
46 of 182
Maximum Residual Disinfectant Level
Year Disinfectant Average
Level
Minimum
Level
Maximum
Level MRDL MRDLG Unit of
Measure
Violation
(Y or N) Source of Disinfectant
2017 Chloramine Residual
(Total Chlorine) 3.01 0.6 4.0 4.0 <4.0 ppm
N Disinfectant used to control
microbes.
Disinfection By-Products
Year Contaminant Highest Level
Detected
Range of
Levels Detected MCL Unit of
Measure
Violation
(Y or N) Source of Contaminant
2017 HAA5 Total
Haloacetic Acids 12 2.7 – 7.8 60 ppb N Byproduct of drinking water disinfection.
2017 Total
Trihalomethanes 11 4.83 – 11 80 ppb N Byproduct of drinking water disinfection.
*Highest level detected is based on a running annual average calculated from quarterly samples as required by TCEQ, and may be from
predecessor system measurement
Organic Contaminants – (Measured in Fort Worth system)
Year Contaminant
Highest
Level
Detected
Range of
Levels
Detected
MCLG MCL Unit of
Measure
Violation
(Y or N) Source of Contaminant
2017 Atrazine 0.1 0 – 0.1 3 3 ppb N Herbicide
Microbial Contaminants NONE DETECTED
Year Contaminant MCL Highest Single
Measurement
Lowest Monthly %
of Samples
Meeting Limits
Violation
(Y or N) Source of Contaminant
2017 Total Coliform, including
E. Coli 0 Absent 100% N Human and animal fecal waste.
Total Coliform Bacteria are used as indicators of microbial contamination of drinking water because testing for them is easy. While not disease-causing
organisms themselves, they are often found in association with other microbes that are capable of causing disease. Coliform are more hardy than many
disease-causing organisms; therefore, their absence from water is a good indication that the water is microbiologically safe for human consumption.
Radioactive Contaminants
Year Contaminant Highest Level
Detected
Range of Levels
Detected MCLG MCL Unit of
Measure
Violat
ion
(Y or
N)
Source of Contaminant
2013 Combined Radium
(-226 & -228) 1.0 1.0 – 1.0 0 5 pCi/L N Erosion of natural deposits.
2017 Beta/photon
emitters 5.2* 5.2 – 5.2 0 50* (mrem/year)
/(pCi/L) No Decay of natural and man-made
deposits.
EPA considers 50 pCi/L to be the level of concern for Beta particles
Inorganic Contaminants
Year Contaminant
Highest
Level
Detected
Range of
Levels
Detected
MCLG MCL Unit of
Measure
Violation
(Y or N) Source of Contaminant
2017 Arsenic 2.0 0 – 2 0 10 ppb N
Erosion of natural deposits; runoff from
orchards; runoff from glass and electronics
production wastes.
2017 Barium 0.046 0.046 – 0.046 2 2 ppm N
Discharge of drilling wastes; discharge
from metal refineries; erosion of natural
deposits.
2016 Chromium 1.4 1.4 – 1.4 100 100 ppb N Discharge from steel and pulp mills;
erosion of natural deposits.
2017 Cyanide 73.2 73.2 – 73.2 200 200 ppb N Discharge plastic and fertilizer factories;
discharge from steel/metal factories.
2017 Fluoride 0.666 0.666 – 0.666 4 4 ppm N
Erosion of natural deposits; water additive
which promotes strong teeth; discharge
from fertilizer and aluminum factories.
2017
Nitrate *
(measured as
nitrogen)
0.263 0.263 – 0.263 10 10 ppm N
Runoff from fertilizer use; leaching from
septic tanks, sewage; erosion of natural
deposits.
*Nitrate Advisory: Nitrate in drinking water at levels above 10 ppm is a health risk for infants of less than six months of age. High nitrate levels in drinking
water can cause blue baby syndrome. Nitrate levels may rise quickly for short periods of time because of rainfall or agricultural activity. If you are caring
for an infant you should ask advice from your health care provider.
July 18, 2018 Regular Meeting Agenda Packet
47 of 182
Turbidity (Source Water: City of Fort Worth)
Year Contaminant MCL MCLG Highest Single
Measurement
Range of Levels
Detected
Turbidity
Limits
Unit of
Measure
Violation
(Y or N)
Source of
Contaminant
2017
Turbidity –
Highest
Measurement
TT=1 0 0.22 0.12 – 0.22 0.3 NTU N Soil runoff.
2017 % of Samples
≤ 0.3 NTU TT=95 100 Lowest was 100 100-100 0.3 NTU N Soil Runoff
Turbidity is a measure of the cloudiness of water and has no health effects. It is monitored because it is a good indicator of the effectiveness of the
filtration system.
Total Organic Carbon (Source Water: City of Fort Worth)
Year Contaminant MCL MCLG Highest
Measurement
Lowest
Measurement Average Violation
(Y or N) Source of Contaminant
2017 Total Organic Carbon TT =
% removal none 1.18 1.0 1.0 N Naturally occurring.
Total Organic Carbon is used to determine disinfection by-product precursors. The City of Fort Worth was compliant with all monitoring and treatment
technique requirements for disinfection by-product precursors.
Secondary and Other Constituents Not Regulated (No associated adverse health effects.)
Year Constituent Average
Level
Minimum
Level
Maximum
Level
Secondary
Limit
Unit of
Measure
Violati
on
(Y or
N)
Source of Constituent
2017 Bicarbonate 155 155 155 N/A ppm N Corrosion of carbonate rocks such as
limestone.
2017 Chloride 93.4 93.4 93.4 300 ppm N
Abundant naturally occurring element;
used in water purification; byproduct of
oil field activity.
2017 Conductivity 686 686 686 N/A UMHO/CM N Measure of the ability of the water
sample to conduct electricity.
2017 pH 8.4 8.4 8.4 6.5 – 8.5 units N Measure of corrosivity of water.
2017 Sulfate 36.7 36.7 36.7 300 ppm N Naturally occurring; common industrial
byproduct; byproduct of oil field activity.
2017 Total Alkalinity as
CaCO3 162 162 162 N/A ppm N Naturally occurring soluble mineral
salts.
2017 Total Hardness as
CaCO3 135 113 157 N/A ppm N Naturally occurring soluble mineral
salts.
2017 Total Dissolved
Solids 350 350 350 1000 ppm N Total dissolved minerals in water.
Unregulated Contaminant Monitoring
Year Constituent Averag
e Level
Range of
Levels
Detected
MCL MRDLG Unit of
Measure
Violation
(Y or N) Source of Constituent
2017 Acetone* 9.29 9.29 – 9.29 NR NA ppb No Industrial and agricultural chemicals,
measured in wholesale providers system
2017 Chloroform 2.28 2.28 – 2.28 NR 7 ppb No Individual constituents from grouped
parameter TTHMs
2017 Bromodichloro
-methane 3.03 3.03 – 3.03 NR 0 ppb No Individual constituents from grouped
parameter TTHMs
2017 Dibromochloro
-methane 2.18 2.18 – 2.18 NR 6 ppb No Individual constituents from grouped
parameter TTHMs
2017 Bromoform 1.08 1.08 -1.08 NR 0 ppb No Individual constituents from grouped
parameter TTHMs
*Measured in Fort Worth’s system
Year-Round Watering Restrictions in Effect
Consult the TCMUD.org website for further details. http://tcmud.org/customer-service/water-restrictions/
July 18, 2018 Regular Meeting Agenda Packet
48 of 182
DENTON COUNTY
Office of
Michelle French, P.C.C.
Tax Assessor/Collector
1505 E. McKinney St.
Denton, TX 76209
Motor Vehicle Department www.tax.dentoncounty.com Property Tax Department
P.O. Box 90204 P.O. Box 90223
Denton, TX 76202-5204 Denton, TX 76202-5223
940-349-3510 940-349-3500
June 14, 2018
Dear Taxing Entities,
The 2018 Denton County Interlocal Collection Agreement has been finalized for issuance. The parcel fee for consolidated
collections for the 2018 tax year is $1.00 per parcel. There are no significant changes in the Agreement. The Interlocal
Agreement is to be submitted to the Denton County Tax Office no later than September 5, 2018. This will provide the
necessary time to add the Agreement to the Denton County Commissioners Court Agenda to be properly executed prior to
October 1, 2018.
We are providing the Agreement in form-fillable PDF format for your convenience. Please complete the Agreement inserting
the name of your entity and dates. Once the form is complete, please print three (3) copies for submittal.
The Agreement must be submitted to our office in triplicate. Please print three (3) copies of the completed Agreement
and have all copies signed by the appropriate person in your entity. Failure to submit three (3) originally signed
Agreements may delay processing through Commissioners Court.
Municipalities that have approved the creation of a Public Improvement District (PID) must complete the Public Improvement
District Agreement. The proper Agreement will be dependent on whether the PID is a rate based or fixed lien assessment
district. Please feel free to contact our office to assist you should you have questions about which district Agreement you may
need to complete.
The address to mail the completed Agreements is as follows:
Office of Michelle French
Denton County Tax Assessor/Collector
P.O. Box 90223
Denton, TX 76202
Attn: Michelle French
The physical address is as follows:
Office of Michelle French
Denton County Tax Assessor/Collector
1505 E. McKinney Street
Denton, TX 76209
Attn: Michelle French
As always, our office is here to assist you with any questions or concerns. We thank you for allowing Denton County to
provide consolidated collections to your entity in order to better serve our mutual constituents.
Best Regards,
Denton County Tax Assessor/Collector
July 18, 2018 Regular Meeting Agenda Packet
49 of 182
THE STATE OF TEXAS §
COUNTY OF DENTON §
INTERLOCAL COOPERATION AGREEMENT FOR TAX COLLECTION BETWEEN
DENTON COUNTY, TEXAS, AND
THIS AGREEMENT is made and entered into this __BBBday ofBBB
by DQGbetween DENTON COUNTY, a political subdivision of the State of Texas,
hereinafter referred to as "COUNTY," and7523+<&/8%081,&,3$/
87,/,7<',675,&712Denton&ounty, Texas,also a political
subdivision of the State of Texas, hereinafter referred to as "DISTRICT"
WHEREAS, COUNTY and DISTRICT mutually desire to be subject tothe
provisions of V.T.C.A. Government Code, Chapter 791, the Interlocal
Cooperation Act, and V.T.C.A., Tax Code, Section 6.24 and 25.17 and;
:+(5($6',675,&7KDVLPSRVHGDQDGYDORUHPWD[LQDFFRUGDQFHZLWK
7H[DV6SHFLDO'LVWULFW/RFDO/DZV&RGH&KDSWHUDQGDSSOLFDEOHSURYLVLRQVRIWKH
7H[DV/RFDO*RYHUQPHQW&RGH&KDSWHUDQG
:+(5($6',675,&7KDVWKHDXWKRULW\WRFRQWUDFWZLWKWKH&2817<IRUWKH
&2817<WRDFWDVWD[DVVHVVRUDQGFROOHFWRUIRUDGYDORUHPWD[HVRI',675,&7DQG
&2817<KDVWKHDXWKRULW\WRVRDFW
NOWTHEREFORE,COUNTYand DISTRICT,for and in consideration of
the mutual promises, covenants, and agreements herein contained, do agree as follows:
1 of 14 2018-2019 MUD INTERLOCAL AGREEMENT
July 18, 2018 Regular Meeting Agenda Packet
50 of 182
I.
The effective date of this Agreement shall be the 1
st day of October, 20
1. The term of
this Agreement shall be for a period of one year, from October 1, 201,to and through
September 30, 201. This Agreement shall be automatically renewed for an additional
one (1) year term at the discretion of the COUNTY and DISTRICT, unless written
notice of termination is provided by the terminating party to the other party prior to one
hundred-fifty (150) days of the expiration date of the current term of the Agreement.
DISTRICT agrees to deliver this agreement no later than September , 201RUWKHILUVW
0RQGD\RI6HSWHPEHU in manner required by COUNTY to fully execute
said collection services by COUNTY.
For the purposes and consideration herein stated and contemplated, COUNTY
shall provide the following necessary and appropriate services for DISTRICT to the
maximum extent authorized by this Agreement, without regard to race, sex, religion,
color, age, disability, or national origin:
1.COUNTY, by and through its duly qualified tax assessor-collector, shall
serve as tax assessor-collector for DISTRICT for ad valorem tax collection for tax year
and each tax year for the duration of this Agreement.COUNTY agrees to
perform all necessary ad valorem assessing and collecting duties for DISTRICT and
DISTRICT does hereby expressly authorize COUNTY to do and perform all acts
necessary and proper to assess and collect taxes for DISTRICT. COUNTY agrees
to collect base taxes, penalties, interest, and attorney's fees.
2.COUNTY agrees to prepare and mail all current and delinquent tax statements
required by statute, supplemental changes for applicable property accounts, as well as
**
2 of 14 2018-2019 MUD INTERLOCAL AGREEMENT
July 18, 2018 Regular Meeting Agenda Packet
51 of 182
prepare and mail any other mailing as deemed necessary and appropriate by COUNTY;
provide daily and monthly collection and distribution reports to DISTRICT;prepare tax
certificates; develop and maintain both current and delinquent tax rolls, disburse tax
monies to DISTRICT daily (business day) based on prior day tax postings.COUNTY
agrees to approve and refund overpayment or erroneous payment of taxes for DISTRICT
pursuant to Texas Property Tax code Sections 31.11 and 31.12 from available current tax
collections of DISTRICT; meet the requirements of Section 26.04 of the Texas Tax
Code; and to develop and maintain such other records and forms as are necessary or
required by State law, rules, or regulations.
3.COUNTY further agrees that it will calculate the effective and rollback tax
rates for DISTRICT,however all calculations will be performed using only the Texas
State Comptroller’s “Truth In Taxation” formulas, and that such calculations will be
provided at no additional cost to DISTRICT. The information concerning the effective
and rollback tax rates will be published in the form prescribed by the Comptroller of
Public Accounts of the State of Texas, and as required by Section 26.04 of V.T.C.A. Tax
Code.DISTRICT shall notify tax assessor-collector no later than July 25
th of each year
that DISTRICT wishes publication of forms or notices specified in this section. It is
understood and agreed by the parties that the expense of publication shall be borne by
DISTRICT and that COUNTY shall provide DISTRICT’s billing address to the
newspaper publishing the effective and rollback tax rates.
4.COUNTY agrees, upon request, to offer guidance and the necessary forms
for posting notices of required hearing and quarter-page notices as required by Sections
26.05 and 26.06 of V.T.C.A. Tax Code, if DISTRICT requests such 7 days in advance of
3 of 14 2018-2019 MUD INTERLOCAL AGREEMENT
July 18, 2018 Regular Meeting Agenda Packet
52 of 182
the intended publication date.DISTRICT must approve all calculations and notices, in
the format required by COUNTY, before publication may proceed. The accuracy and
timeliness of all required notices are the responsibility of DISTRICT.
5. Should DISTRICT vote to increase its tax rate above the rollback tax rate
the required publication of notices shall be the responsibility of DISTRICT.
6.COUNTY agrees to develop and maintain written policies and procedures
of its operation. COUNTY further agrees to make available full information about the
operation of the County Tax Office to DISTRICT, and to promptly furnish written
reports to keep DISTRICT informed of all financial information affecting it.
7.DISTRICT agrees to promptly deliver to COUNTY allrecordsthatithas
accumulated and developed in the assessment and collection of taxes,and to cooperate in
furnishing or locating any other information and records needed by COUNTY to perform
its duties under the terms and conditions of this Agreement.
8.COUNTY agrees to allow an audit of the tax records of DISTRICT in
COUNTY’S possession during normal working hours with at least 48 hours
advance, written notice to COUNTY. The expense of any and all such audits shall
be paid by DISTRICT. A copy of any and all such audits shall be furnished to
COUNTY.
9. If required by DISTRICT, COUNTY agrees to obtain a surety bond for
the County Tax Assessor/Collector. Such bond will be conditioned upon the faithful
performance of the Tax Assessor/Collector’s lawful duties, will be made payable to
DISTRICT and in an amount determined by the governing body of DISTRICT.The
premium for any such bond shall be borne solely by DISTRICT.
4 of 14 2018-2019 MUD INTERLOCAL AGREEMENT
July 18, 2018 Regular Meeting Agenda Packet
53 of 182
10.COUNTY agrees that it will post a notice on its website, as a reminder
that delinquent tax penalties will apply to all assessed taxes which are not paid by
January 31, 201
11.COUNTY agrees that it will post to a secure website collection reports for
DISTRICT listing current taxes, delinquent taxes, penalties and interest on a daily basis
through September 30, 201.COUNTY will provide monthly Maintenance and Operation
(hereinafter referred to as “MO”), and Interest and Sinking (hereinafter referred to as
“IS”) collection reports; provide monthly recap reports; and provide monthly
attorney fee collection reports.
12.DISTRICT retains its right to select its own delinquent tax collection
attorney and COUNTY agrees to reasonably cooperate with the attorney selected by
DISTRICT in the collection of delinquent taxes and related activities.
13.DISTRICT will provide COUNTY with notice of any change in
collection attorney on or before the effective date of the new collection attorney contract.
5 of 14 2018-2019 MUD INTERLOCAL AGREEMENT
July 18, 2018 Regular Meeting Agenda Packet
54 of 182
III.
COUNTY hereby designates the Denton County Tax Assessor/ Collector to act
on behalf of the County Tax Office and to serve as Liaison for COUNTY with
DISTRICT.The County Tax Assessor/Collector, and/or his/her designated substitute,
shall ensure the performance of all duties and obligations of COUNTY; shall devote
sufficient time and attention to the execution of said duties on behalf of COUNTY in full
compliance with the terms and conditions of this Agreement; and shall provide
immediate and direct supervision of the County Tax Office employees,agents,
contractors, subcontractors, and/or laborers, if any, in the furtherance of the purposes,
terms and conditions of this Agreement for the mutual benefit of COUNTY and
DISTRICT.
IV.
COUNTY accepts responsibility for the acts, negligence, and/or omissions
related to property tax service of all COUNTY employees and agents, sub-contractors
and /or contract laborers, and for those actions of other persons doing work under a
contract or agreement with COUNTY to the extent allowed by law.
V.
DISTRICT accepts responsibility for the acts, negligence, and/or omissions of all
DISTRICT employees and agents, sub-contractors and/or contract laborers, and for those
of all other persons doing work under a contract or agreement with DISTRICT to the
extent allowed by law.
6 of 14 2018-2019 MUD INTERLOCAL AGREEMENT
July 18, 2018 Regular Meeting Agenda Packet
55 of 182
VI.
DISTRICT understands and agrees that DISTRICT,its employees, servants,
agents, and representatives shall at no time represent themselves to be employees, servants,
agents, and/or representatives of COUNTY. COUNTY understands and agrees that
COUNTY, its employees, servants, agents, and representatives shall at no time
represent themselves to be employees, servants, agents, and/or representatives of
DISTRICT.
VII.
For the services rendered during the 201tax year,DISTRICT agrees to pay
COUNTY for the receipting, bookkeeping, issuing,and mailing of tax statements as
follows:
1. The current tax statements will be mailed by Octoberor as soon
thereafter as practical. In order to expedite mailing of tax statements the DISTRICT must
adopt their 201tax rate by September 29, 201. Failure of the DISTRICT to adopt a tax
rate by September 29, 201may cause delay in timely mailing of tax statements. Pursuant to
Texas Property Tax Code §26.05 if the DISTRICT must adopt a tax rate by the later of
September 30
th or 60 days after the certified appraisal roll is received. Failure to adopt and
deliver a tax rate by the later of September 30
th or 60 days after the certified appraisal roll is
received may result in delay of processing and mailing DISTRICT tax statements.
DISTRICT agrees to assume the costs for additional delayed tax statements, processing and
mailing as determined by COUNTY.Notwithstanding the provisions of the Tax Code, if
DISTRICT fails to deliver the adopted tax rates (M&O and I&S) to the Tax Assessor
Collector by September 29, 201, it may cause a delay in the publication and release of tax
statements.
7 of 14 2018-2019 MUD INTERLOCAL AGREEMENT
July 18, 2018 Regular Meeting Agenda Packet
56 of 182
2.An additional notice will be sent during the month of March following the
initial mailing provided that DISTRICT has requested such a notice on or before
February 28 . The fee for this service will be a rate not to exceed $. per statement.
At least 30 days, but no more than 60 days, prior to April 1st, and following the
initial mailing, a delinquent tax statement meeting the requirements of Section 33.11 of
the Texas Property Tax Code will be mailed to the owner of each parcel having delinquent
taxes.
3.At least 30 days, but no more than 60 days, prior to July 1st, and followingthe
initial mailing, a delinquent tax statement meeting the requirements of Section 33.07 of
the Texas Property Tax Code will be mailed to the owner of each parcel having
delinquent taxes.
4.For accounts which become delinquent on or after June 1
st, COUNTY
shall mail a delinquent tax statement meeting the requirements of Section 33.08 of the
Texas Property Tax Code to the owner of each parcel having delinquent taxes.
5.In event of a successful rollback election which takes place after tax billsfor
DISTRICT have been mailed,DISTRICT agrees to pay COUNTY a programming
charge of $5,000.00.COUNTY will mail corrected statements to the owner of each
parcel.COUNTY will charge a fee for this service will be a rate not to exceed $. per
statement Property Tax Code Section 26.07 (f). When a refund is required per
Property Tax Code Section 26.07 (g),COUNTY will charge a $.25 processing fee per
check, in addition to the corrected statement mailing costs. Issuance of refunds, in the
event of a
8 of 14 2018-2019 MUD INTERLOCAL AGREEMENT
July 18, 2018 Regular Meeting Agenda Packet
57 of 182
successful rollback election, will be the responsibilityof the COUNTY. DISTRICT will
be billed for the refunds, postage and processing fees.
6.DISTRICT understands and agrees that COUNTY will, no later than
January 31, deduct from current collections of DISTRICT the “Total
Cost” of providing all services described in paragraphs 1-5 above. This “Total Cost”
includes any such services that have not yet been performed at the time of deduction.
The “Total Cost” of providing all services described in paragraphs 1-5 above shall be the
total of:x the total number of parcels listed on the DISTRICT’s September 30, 201
HQGRI\HDU7D[5ROOIRUWD[\HDU
In the event that a rollback election as described in paragraph 6 takes place,COUNTY
shall bill DISTRICT for the applicable programming charge, check processing
fees, refunds paid, and refund postage costs. DISTRICT shall pay COUNTY all
billed amounts within 30 days of its receipt of said bill.In the event costs for
additional delayed tax statements,processing and mailing are incurred as described in
paragraph 1,COUNTY shall bill DISTRICT for such amounts. DISTRICT shall
pay COUNTY all such billed amounts within 30 days of its receipt of said bill.
7.DISTRICT further understands and agrees that COUNTY (at its sole
discretion) may increase or decrease the amounts charged to DISTRICT for any renewal
year of this Agreement, provided that COUNTY gives written notice to DISTRICT
sixty (60) days prior to the expiration date of the initial term of the Agreement. The
County Budget Office establishes collection rates annually based on a survey of actual
annual costs incurred by the COUNTY in performing tax collection services. The
collection rate for each year is approved by County Commissioners’ Court. All entities
are assessed the same per parcel collection rate.
9 of 14 2018-2019 MUD INTERLOCAL AGREEMENT
July 18, 2018 Regular Meeting Agenda Packet
58 of 182
VIII.
COUNTY agrees to remit all taxes, penalties, and interest collected on
DISTRICT's behalf and to deposit such funds into DISTRICT’s depositories as
designated:
1. For deposits of tax, penalties, and interest, payment shall be by wire
transfer or ACH to DISTRICT's depository accounts only, and segregated into the
appropriate MO and IS accounts. Only in the event of failure of electronic transfer
protocol will a check for deposits of tax, penalty and interest be sent by m ail to
DISTRICT.
2. If DISTRICT uses the same depository as COUNTY,the deposits of tax,
penalty and interest shall be by deposit transfer.
3. In anticipation of renewal of this Agreement,COUNTY further agrees
that deposits will be made daily through September 30, 201.It is expressly understood,
however, that this obligation of COUNTY shall not survive termination of this
Agreement, whether by termination by either party or by failure of the parties to renew
this Agreement.
4. In event that COUNTY experiences shortage in collections as a result of
an outstanding tax debt of DISTRICT,theDISTRICT agrees a payment in the amount
of shortage shall be made by check or ACH to COUNTY within 15 days after
notification of such shortage.
10 of 14 2018-2019 MUD INTERLOCAL AGREEMENT
July 18, 2018 Regular Meeting Agenda Packet
59 of 182
IX.
As provided by Sections 49.107(g) and 49.108(f) of the Texas Water Code,
Sections 26.04, 26.05, and 26.07 of the Texas Property Tax Code do not apply to taxes
levied by DISTRICT, except as provided in Water Code Section 49.236. Therefore,
references in the Agreement to Sections 26.04, 26.05, 26.07 of the Property Tax Code or
to the requirements of those sections shall not apply to DISTRICT, except to the extent
provided in Water Code Section 49.236.DISTRICT shall comply with Water Code
Section 49.236.
X.
In the event of termination, the withdrawing party shall be obligated to make such
payments as are required by this Agreement through the balance of the tax year in which
notice is given. COUNTY shall be obligated to provide services pursuant to this
Agreement, during such period.
XI.
This Agreement represents the entire agreement between DISTRICT and
COUNTY and supersedes all prior negotiations, representations, and/or agreements,
either written or oral. This Agreement may be amended only by written instrument
signed by the governing bodies of both DISTRICT and COUNTY or those authorized to
sign on behalf of those governing bodies.
XII.
Any and all written notices required to be given under this Agreement shall be delivered
or mailed to the listed addresses:
11 of 14 2018-2019 MUD INTERLOCAL AGREEMENT
July 18, 2018 Regular Meeting Agenda Packet
60 of 182
COUNTY:
County Judge of Denton County
110 West Hickory
Denton, Texas 76201
Telephone 940-349-2820
DISTRICT:
NAMEam:_BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB
Address:
City, State, Zip:
Telephone:Email:
XIII.
DISTRICT hereby designates to act on behalf of
DISTRICT, and to serve as Liaison for DISTRICT to ensure the performance of all
duties and obligations of DISTRICT as stated in this Agreement.DISTRICT’s
designee shall devote sufficient time and attention to the execution of said duties on
behalf of DISTRICT in full compliance with the terms and conditions of this
Agreement; shall provide immediate and direct supervision of the DISTRICT
employees, agents, contractors, subcontractors, and/or laborers, if any, in the furtherance
of the purposes, terms and conditions of this Agreement for the mutual benefit of
DISTRICT and COUNTY.Attached Exhibit A lists current members of the Board of
Directors with contact information, and the time and location of regular board meetings.
12 of 14 2018-2019 MUD INTERLOCAL AGREEMENT
July 18, 2018 Regular Meeting Agenda Packet
61 of 182
XIV.
In the event that any portion of this Agreement shall be found to be contrary to
law, it is the intent of the parties that the remaining portions shall remain valid and in full
force and effect to the extent possible.
XV.
The undersigned officers and/or agents of the parties are the properly authorized
officials and have the necessary authority to execute this agreement on behalf of the
parties. Each party hereby certifies to the other that any resolutions necessary for this
Agreement have been duly passed and are now in full force and effect.
Executed in WULplicate originals thisday of 201.
COUNTY DISTRICT
Denton County
110 West Hickory Address:
Denton, Texas 76201 City, State, Zip:
BY:BY:
Honorable Mary Horn
Name:
Denton County Judge Title:
ATTEST: ATTEST:
BY:BY:
Name-XOL/XNH
Denton County Clerk Title
APPROVED FORM AND CONTENT:APPROVED AS TO FORM:
Michelle French
Denton County
Tax Assessor/Collector
Denton County
Assistant District Attorney
13 of 14
/BNF
2018-2019 MUD INTERLOCAL AGREEMENT
July 18, 2018 Regular Meeting Agenda Packet
62 of 182
Exhibit A:
Board of Directors for:
Phone NumberOffice
President
Name
Vice President
Secretary7UHDVXUHU
14 of 14 MMUD INTERLOCAL AGREEMENT2018-2019 MUD INTERLOCAL AGREEMENT
July 18, 2018 Regular Meeting Agenda Packet
63 of 182
Proposed Trophy Club Municipal Utility District No. 1Logo PresentationVice President Bill RoseDirector Kelly CastonguayJuly 18, 2018 Regular Meeting Agenda Packet64 of 182
July 18, 2018 Regular Meeting Agenda Packet65 of 182
July 18, 2018 Regular Meeting Agenda Packet66 of 182
July 18, 2018 Regular Meeting Agenda Packet67 of 182
July 18, 2018 Regular Meeting Agenda Packet68 of 182
July 18, 2018 Regular Meeting Agenda Packet69 of 182
July 18, 2018 Regular Meeting Agenda Packet70 of 182
July 18, 2018 Regular Meeting Agenda Packet71 of 182
TROPHY CLUB MUD #1 - FIRE DEPARTMENT
BALANCE SHEET
JUNE 2018
122
ASSETS FIRE DEPT.
CASH IN BANK 60,743
INVESTMENTS 691,610
PREPAID EXPENSES 3,810
ADVALOREM PROPERTY TAXES RECEIVABLE 19,637
EMERGENCY SERVICES ASSESSMENTS RECEIVABLE -
UTILITY AND OTHER ACCOUNTS RECEIVABLE -
TOTAL ASSETS 775,799
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 19,637
ACCOUNTS AND OTHER PAYABLES 111,485
TOTAL LIABILITIES 131,122
FUND BALANCE
DESIGNATED FOR FUTURE ASSET REPLACEMENT -
NON-SPENDABLE FUND BALANCE -
UNASSIGNED FUND BALANCE 522,253
RESERVE FOR ENCUMBRANCES -
NET REVENUES / EXPENDITURES 122,424
TOTAL FUND BALANCE 644,677
TOTAL LIABILITIES AND FUND BALANCE 775,799
July 18, 2018 Regular Meeting Agenda Packet
72 of 182
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 1
19:44 07/11/18 Budget Summary with Amendment
Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program:
Period Ending: 6/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- 3,787.88- 1,061,756.03- 100.694 7,323.03
122-40011-000-000 Property Taxes/Fire-Delinquent 17.31- 3,903.29- 3,903.29
122-40020-000-000 Property Taxes/Fire P&I 183.11- 4,631.92- 4,631.92
Subtotal: 1,054,433.00- 1,054,433.00- 3,988.30- 1,070,291.24- 101.504 15,858.24
Program number: 1,054,433.00- 1,054,433.00- 3,988.30- 1,070,291.24- 101.504 15,858.24
Department number: Fire Revenues 1,054,433.00- 1,054,433.00- 3,988.30- 1,070,291.24- 101.504 15,858.24
Revenues Subtotal ----------- 1,054,433.00- 1,054,433.00- 3,988.30- 1,070,291.24- 101.504 15,858.24
July 18, 2018 Regular Meeting Agenda Packet
73 of 182
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 2
19:44 07/11/18 Budget Summary with Amendment
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 6/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.87 11,428.83 63.494 6,571.17
122-60337-045-000 Transfer to Town/Fire Budget 608,910.00 608,910.00 101,485.00 507,425.00 83.333 101,485.00
Subtotal: 845,864.00 845,864.00 102,754.87 737,807.83 87.225 108,056.17
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 102,754.87 947,866.92 89.894 106,566.08
Department number: Fire 1,054,433.00 1,054,433.00 102,754.87 947,866.92 89.894 106,566.08
Expenditures Subtotal ----------- 1,054,433.00 1,054,433.00 102,754.87 947,866.92 89.894 106,566.08
Fund number: 122 Trophy Club MUD Fire Dept. 98,766.57 122,424.32- 122,424.32
July 18, 2018 Regular Meeting Agenda Packet
74 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 1
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program:
Period Ending: 6/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
1664 06/01/2018 Property Taxes (1,057,968.15) (517.33) (1,058,485.48) GL
1665 06/04/2018 Property Taxes (816.12) (1,059,301.60) GL
1666 06/05/2018 Property Taxes (55.45) (1,059,357.05) GL
1667 06/07/2018 Property Taxes (1,040.62) (1,060,397.67) GL
1668 06/11/2018 Property Taxes (185.51) (1,060,583.18) GL
1669 06/12/2018 Property Taxes (12.60) (1,060,595.78) GL
1670 06/13/2018 Property Taxes (1,012.71) (1,061,608.49) GL
1671 06/15/2018 Property Taxes (19.91) (1,061,628.40) GL
1672 06/18/2018 Property Taxes (36.44) (1,061,664.84) GL
1673 06/19/2018 Property Taxes (69.94) (1,061,734.78) GL
1674 06/21/2018 Property Taxes (4.24) (1,061,739.02) GL
1675 06/22/2018 Property Taxes (12.36) (1,061,751.38) GL
1676 06/25/2018 Property Taxes (20.87) (1,061,772.25) GL
1677 06/26/2018 Property Taxes (35.10) (1,061,807.35) GL
1678 06/28/2018 Property Taxes (1.88) (1,061,809.23) GL
1679 06/29/2018 Property Taxes 53.20 (1,061,756.03) GL
_______________
Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (3,787.88) (1,061,756.03) **
(1,054,433.00) Budgeted 7,323.03 Remaining 101 % Used
Account: 122-40011-000-000 Property Taxes/Fire-Delinquent
1665 06/04/2018 Property Taxes (3,885.98) (35.92) (3,921.90) GL
1679 06/29/2018 Property Taxes 18.61 (3,903.29) GL
_______________
Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (17.31) (3,903.29) **
.00 Budgeted 3,903.29 Remaining 0 % Used
Account: 122-40020-000-000 Property Taxes/Fire P&I
1664 06/01/2018 Property Taxes (4,448.81) (7.70) (4,456.51) GL
1665 06/04/2018 Property Taxes (7.99) (4,464.50) GL
1667 06/07/2018 Property Taxes (130.49) (4,594.99) GL
1668 06/11/2018 Property Taxes (27.83) (4,622.82) GL
1670 06/13/2018 Property Taxes (3.02) (4,625.84) GL
1671 06/15/2018 Property Taxes (2.99) (4,628.83) GL
1674 06/21/2018 Property Taxes (.63) (4,629.46) GL
1677 06/26/2018 Property Taxes (2.46) (4,631.92) GL
_______________
Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (183.11) (4,631.92) **
.00 Budgeted 4,631.92 Remaining 0 % Used
July 18, 2018 Regular Meeting Agenda Packet
75 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 2
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program:
Period Ending: 6/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-43415-000-000 Denton County Pledge-Fire
1540 06/07/2018 2018 Fire Pledge-Denton County (10,000.00) (10,000.00) GL
1692 06/29/2018 June A/P Denton County Fire Pledge FY19 10,000.00 .00 TOWN OF TROPHY CLUB 4365 AP
_______________
Account: 122-43415-000-000 Denton County Pledge-Fire Totals: .00 .00 **
.00 Budgeted .00 Remaining 0 % Used
Department Totals: ----------------------------------- (1,070,291.24) **
(3,988.30) Monthly Total (1,054,433.00) Budgeted 15,858.24 Remaining 102 % Used
July 18, 2018 Regular Meeting Agenda Packet
76 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 3
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 6/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
240 06/01/2018 Insurance/Wrk Comp Exp Jun 10,158.96 1,269.87 11,428.83 GL
_______________
Account: 122-60055-045-000 Insurance Totals: 1,269.87 11,428.83 **
18,000.00 Budgeted 6,571.17 Remaining 63 % Used
Account: 122-60337-045-000 Transfer to Town/Fire Budget
1692 06/29/2018 June A/P June Fire Admin 405,940.00 50,742.50 456,682.50 TOWN OF TROPHY CLUB 4365 AP
1692 06/29/2018 June A/P July Fire Admin 50,742.50 507,425.00 TOWN OF TROPHY CLUB 4365 AP
_______________
Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 101,485.00 507,425.00 **
608,910.00 Budgeted 101,485.00 Remaining 83 % 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
July 18, 2018 Regular Meeting Agenda Packet
77 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 6/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Department 45 Totals: ----------------------------------- 947,866.92 **
102,754.87 Monthly Total 1,054,433.00 Budgeted 106,566.08 Remaining 90 % Used
Fund 122 Totals: ----------------------------------- (122,424.32)
98,766.57 Monthly Total .00 Budgeted 122,424.32 Remaining 0 % Used
July 18, 2018 Regular Meeting Agenda Packet
78 of 182
TROPHY CLUB MUD #1 - O&M
BALANCE SHEET
JUNE 2018
GTBGT 135 137
GENERAL FUND GASB TOTAL
ASSETS
CASH ON HAND 600 - 600
CASH IN BANK-CHECKING 1,678,923 - 1,678,923
CASH IN BANK-SAVINGS-CASH RESERVE 782,658 - 782,658
CD-BANK OF THE WEST/THB DEPOSIT - - -
INVESTMENTS-MONEY MARKET-BANK OF THE WEST 715,223 - 715,223
INVESTMENTS-TEXPOOL 2,261,972 596,426 2,858,398
PREPAID EXPENSES 28,908 - 28,908
ADVALOREM PROPERTY TAXES RECEIVABLE 2,132 - 2,132
UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,240,905 - 1,240,905
TOTAL ASSETS 6,711,321 596,426 7,307,747
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 2,132 - 2,132
ACCOUNTS AND OTHER PAYABLES 708,674 - 708,674
CUSTOMER DEPOSITS 315,985 - 315,985
-
TOTAL LIABILITIES 1,026,791 - 1,026,791
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 1,534,162 - 1,534,162
-
TOTAL FUND BALANCE 5,684,530 596,426 6,280,956
TOTAL LIABILITIES AND FUND BALANCE 6,711,321 596,426 7,307,747
July 18, 2018 Regular Meeting Agenda Packet
79 of 182
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 3
19:44 07/11/18 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 6/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- 434.50- 121,785.15- 100.690 835.15
135-40002-000-000 Property Taxes/Delinquent 200.00- 200.00- 1.01- 344.61- 172.305 144.61
135-40015-000-000 Property Taxes/P & I 200.00- 200.00- 20.65- 512.97- 256.485 312.97
135-40025-000-000 PID Surcharges 177,839.00- 177,839.00- 177,839.00-
Subtotal: 299,189.00- 299,189.00- 456.16- 122,642.73- 40.992 176,546.27-
135-47000-000-000 Water 6,464,019.00- 6,464,019.00- 746,487.77- 3,886,089.31- 60.119 2,577,929.69-
135-47005-000-000 Sewer 2,978,067.00- 2,978,067.00- 265,925.19- 2,209,522.16- 74.193 768,544.84-
135-47025-000-000 Penalties 106,279.00- 106,279.00- 8,906.00- 80,968.31- 76.185 25,310.69-
135-47030-000-000 Service Charges 21,350.00- 21,350.00- 1,200.00- 10,600.00- 49.649 10,750.00-
135-47035-000-000 Plumbing Inspections 1,500.00- 1,500.00- 100.00- 1,800.00- 120.000 300.00
135-47045-000-000 Sewer Inspections 4,500.00- 4,500.00- 300.00- 4,600.00- 102.222 100.00
135-47070-000-000 TCCC Effluent Charges 60,000.00- 60,000.00- 14,924.80- 42,120.80- 70.201 17,879.20-
Subtotal: 9,635,715.00- 9,635,715.00- 1,037,843.76- 6,235,700.58- 64.714 3,400,014.42-
135-49010-000-000 Interest Income 12,000.00- 12,000.00- 7,121.94- 37,767.71- 314.731 25,767.71
135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 978.81- 8,741.01- 80.002 2,184.99-
135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 5,249.97- 75.000 1,750.03-
135-49026-000-000 Proceeds from Sale of Assets 2,000.00- 2,000.00- 15,400.00- 770.000 13,400.00
135-49075-000-000 Oversize Meter Reimbursement 18,179.00- 18,179.00- 686.00- 11,492.76- 63.220 6,686.24-
135-49141-000-000 Interfund Transfer In 1,639.76- 1,851,769.22- 1,851,769.22
135-49900-000-000 Miscellaneous Income 5,000.00- 5,000.00- 225.44- 59,001.27- 1,180.025 54,001.27
135-49901-000-000 Records Management Revenue 20.00- 20.00- 20.00-
135-49910-000-000 Reimbursement/Revenue Bond 260,000.00- 260,000.00- 260,000.00-
Subtotal: 315,125.00- 315,125.00- 11,235.28- 1,989,421.94- 631.312 1,674,296.94
Program number: 10,250,029.00- 10,250,029.00- 1,049,535.20- 8,347,765.25- 81.441 1,902,263.75-
Department number: Revenues 10,250,029.00- 10,250,029.00- 1,049,535.20- 8,347,765.25- 81.441 1,902,263.75-
Revenues Subtotal ----------- 10,250,029.00- 10,250,029.00- 1,049,535.20- 8,347,765.25- 81.441 1,902,263.75-
July 18, 2018 Regular Meeting Agenda Packet
80 of 182
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 4
19:44 07/11/18 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 6/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 29,854.77 168,036.77 61.265 106,242.23
135-50010-010-000 Overtime 20,000.00 20,000.00 1,549.55 8,067.93 40.340 11,932.07
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 1,600.00 48.485 1,700.00
135-50020-010-000 Retirement 27,843.00 27,843.00 2,923.41 18,153.82 65.201 9,689.18
135-50026-010-000 Medical Insurance 52,196.00 52,196.00 2,948.80 23,953.43 45.891 28,242.57
135-50027-010-000 Dental Insurance 5,182.00 5,182.00 213.65 1,948.34 37.598 3,233.66
135-50028-010-000 Vision Insurance 994.00 994.00 35.92 352.07 35.420 641.93
135-50029-010-000 Life Insurance & Other 2,982.00 2,982.00 105.01 1,908.32 63.995 1,073.68
135-50030-010-000 Social Security Taxes 18,662.00 18,662.00 1,942.82 11,156.01 59.779 7,505.99
135-50035-010-000 Medicare Taxes 4,365.00 4,365.00 454.38 2,609.07 59.773 1,755.93
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.92 8,099.28 68.325 3,754.72
135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 226.05 113.025 26.05-
135-50070-010-000 Employee Relations 300.00 300.00 18.99 6.330 281.01
Subtotal: 426,662.00 426,662.00 41,128.23 250,258.76 58.655 176,403.24
135-55005-010-000 Engineering 275,000.00 275,000.00 275,000.00
135-55080-010-000 Maintenance & Repairs 100,000.00 100,000.00 839.83 51,009.44 51.009 48,990.56
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 323.36 4,211.18 105.280 211.18-
135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 35.00 35.00 1.000 3,465.00
135-55135-010-000 Lab Analysis 5,500.00 5,500.00 280.00 6,045.16 109.912 545.16-
Subtotal: 391,000.00 391,000.00 1,478.19 61,300.78 15.678 329,699.22
135-60010-010-000 Communications/Mobiles 4,700.00 4,700.00 370.18 2,862.80 60.911 1,837.20
135-60020-010-000 Electricity 175,356.00 175,356.00 12,787.14 94,948.69 54.146 80,407.31
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 1,536.78 55.181 1,248.22
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 17,410.32 31.554 37,765.68
135-60150-010-000 Wholesale Water 2,823,170.00 2,823,170.00 223,655.16 1,244,668.24 44.088 1,578,501.76
135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00
135-60280-010-000 Property Maintenance 3,000.00 3,000.00 502.70 16.757 2,497.30
135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 1,500.00 7,500.00 50.847 7,250.00
135-60332-010-000 Interfund Transfer Out-Rev I&S 278,084.00 278,084.00 25,280.31 227,522.79 81.818 50,561.21
135-60333-010-000 Interfund Transfer Out-Reserve 48,996.00 48,996.00 4,098.00 36,747.00 75.000 12,249.00
135-60334-010-000 Interfund Transfer Out 200,000.00 200,000.00 1,053,935.08 526.968 853,935.08-
135-60360-010-000 Furniture/Equipment < $5000 2,500.00 2,500.00 5,019.66 200.786 2,519.66-
July 18, 2018 Regular Meeting Agenda Packet
81 of 182
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 5
19:44 07/11/18 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 6/2018
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
Subtotal: 3,613,852.00 3,613,852.00 267,690.79 2,693,516.90 74.533 920,335.10
135-65005-010-000 Fuel & Lube 15,000.00 15,000.00 987.64 7,953.62 53.024 7,046.38
135-65010-010-000 Uniforms 4,488.00 4,488.00 1,249.14 27.833 3,238.86
135-65030-010-000 Chemicals 20,000.00 20,000.00 1,490.96 13,449.80 67.249 6,550.20
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 583.00 58.300 417.00
135-65050-010-000 Meter Expense 50,000.00 50,000.00 3,873.75 24,975.75 49.952 25,024.25
135-65053-010-000 Meter Change Out Program 84,000.00 84,000.00 48,900.00 58.214 35,100.00
Subtotal: 175,688.00 175,688.00 6,352.35 97,111.31 55.275 78,576.69
135-69005-010-000 Capital Outlays 810,012.00 810,012.00 31,893.08 557,431.42 68.818 252,580.58
135-69008-010-000 Short Term Debt-Principal 38,731.00 38,731.00 38,731.00
135-69009-010-000 Short Term Debt-Interest 5,713.00 5,713.00 5,713.00
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 118,775.00 107,864.38 90.814 10,910.62
Subtotal: 1,048,231.00 1,048,231.00 31,893.08 740,295.80 70.623 307,935.20
Program number: 5,655,433.00 5,655,433.00 348,542.64 3,842,483.55 67.943 1,812,949.45
July 18, 2018 Regular Meeting Agenda Packet
82 of 182
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 6
19:44 07/11/18 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID
Period Ending: 6/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 1,200.08 60.004 799.92
Subtotal: 2,000.00 2,000.00 1,200.08 60.004 799.92
Program number: 1 Lab Analysis for PID 2,000.00 2,000.00 1,200.08 60.004 799.92
Department number: Water 5,657,433.00 5,657,433.00 348,542.64 3,843,683.63 67.940 1,813,749.37
July 18, 2018 Regular Meeting Agenda Packet
83 of 182
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7
19:44 07/11/18 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 6/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 38,070.84 273,389.53 66.540 137,476.47
135-50010-020-000 Overtime 30,000.00 30,000.00 2,688.44 26,289.25 87.631 3,710.75
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 6,336.00 75.429 2,064.00
135-50020-020-000 Retirement 42,243.00 42,243.00 3,834.98 30,446.44 72.075 11,796.56
135-50026-020-000 Medical Insurance 62,175.00 62,175.00 5,518.69 49,012.02 78.829 13,162.98
135-50027-020-000 Dental Insurance 5,271.00 5,271.00 371.89 3,576.07 67.844 1,694.93
135-50028-020-000 Vision Insurance 1,114.00 1,114.00 58.90 626.16 56.208 487.84
135-50029-020-000 Life Insurance & Other 4,281.00 4,281.00 156.84 3,319.02 77.529 961.98
135-50030-020-000 Social Security Taxes 28,314.00 28,314.00 2,393.71 18,043.88 63.728 10,270.12
135-50035-020-000 Medicare Taxes 6,622.00 6,622.00 559.82 4,219.93 63.726 2,402.07
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 12,132.00 67.437 5,858.00
135-50060-020-000 Pre-emp Physicals/Testing 300.00 300.00 63.00 126.00 42.000 174.00
135-50070-020-000 Employee Relations 350.00 350.00 350.00
Subtotal: 626,601.00 626,601.00 55,765.11 436,065.30 69.592 190,535.70
135-55070-020-000 Independent Labor 20,550.00 20,550.00 2,145.00 10.438 18,405.00
135-55080-020-000 Maintenance & Repairs 86,100.00 86,100.00 19,761.98 64,183.35 74.545 21,916.65
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 450.00 6,803.60 85.045 1,196.40
135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 105.71 395.40 79.080 104.60
135-55125-020-000 Dumpster Services 60,000.00 60,000.00 2,502.47 57,579.59 95.966 2,420.41
135-55135-020-000 Lab Analysis 30,000.00 30,000.00 1,442.00 24,158.02 80.527 5,841.98
Subtotal: 219,150.00 219,150.00 24,262.16 155,293.74 70.862 63,856.26
135-60010-020-000 Communications/Mobiles 4,700.00 4,700.00 332.19 3,725.19 79.259 974.81
135-60020-020-000 Electricity 266,709.00 266,709.00 11,562.83 121,836.21 45.681 144,872.79
135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 200.00
135-60070-020-000 Dues & Memberships 300.00 300.00 300.00
135-60080-020-000 Schools & Training 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 21.91 41.88 1.047 3,958.12
135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 1,180.00 5,780.00 49.828 5,820.00
135-60331-020-000 Interfund Transfer Out-Tax I&S 122,043.00 122,043.00 11,094.81 99,853.29 81.818 22,189.71
135-60332-020-000 Interfund Transfer Out-Rev I&S 598,738.00 598,738.00 54,430.72 489,876.48 81.818 108,861.52
135-60333-020-000 Interfund Transfer Out-Reserve 123,336.00 123,336.00 10,308.00 92,502.00 75.000 30,834.00
July 18, 2018 Regular Meeting Agenda Packet
84 of 182
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 8
19:44 07/11/18 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 6/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 200,000.00 142,368.99 343,400.98 171.700 143,400.98-
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 1,438,938.00 231,299.45 1,190,150.74 82.710 248,787.26
135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 644.06 6,909.73 55.278 5,590.27
135-65010-020-000 Uniforms 4,459.00 4,459.00 1,774.59 39.798 2,684.41
135-65030-020-000 Chemicals 27,500.00 27,500.00 1,193.00 9,234.23 33.579 18,265.77
135-65035-020-000 Small Tools 1,000.00 1,000.00 239.94 1,389.88 138.988 389.88-
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 2,160.43 15,644.24 111.745 1,644.24-
Subtotal: 60,209.00 60,209.00 4,237.43 36,110.17 59.975 24,098.83
135-69005-020-000 Capital Outlays 547,327.00 547,327.00 15,368.68 106,519.29 19.462 440,807.71
135-69008-020-000 Short Term Debt-Principal 51,342.00 51,342.00 51,342.00
135-69009-020-000 Short Term Debt-Interest 7,573.00 7,573.00 7,573.00
135-69195-020-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 30,000.00 100.000
Subtotal: 636,242.00 636,242.00 15,368.68 136,519.29 21.457 499,722.71
Program number: 2,981,140.00 2,981,140.00 330,932.83 1,954,139.24 65.550 1,027,000.76
Department number: Wastewater 2,981,140.00 2,981,140.00 330,932.83 1,954,139.24 65.550 1,027,000.76
July 18, 2018 Regular Meeting Agenda Packet
85 of 182
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 9
19:44 07/11/18 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program:
Period Ending: 6/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.42 21.78 72.600 8.22
Subtotal: 30.00 30.00 2.42 21.78 72.600 8.22
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 43.85 1,258.85 104.904 58.85-
135-60080-026-000 Schools & Training 4,000.00 4,000.00 1,540.00 38.500 2,460.00
135-60100-026-000 Travel & per diem 5,000.00 5,000.00 3,392.28 4,352.28 87.046 647.72
135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 148.98 1,404.26 70.213 595.74
Subtotal: 12,950.00 12,950.00 3,585.11 9,205.39 71.084 3,744.61
Program number: 12,980.00 12,980.00 3,587.53 9,227.17 71.088 3,752.83
Department number: Board of Directors 12,980.00 12,980.00 3,587.53 9,227.17 71.088 3,752.83
July 18, 2018 Regular Meeting Agenda Packet
86 of 182
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 10
19:44 07/11/18 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 6/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 35,351.93 283,511.34 65.497 149,351.66
135-50010-030-000 Overtime 2,000.00 2,000.00 556.92 27.846 1,443.08
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 3,270.05 28,911.39 71.293 11,641.61
135-50026-030-000 Medical Insurance 63,485.00 63,485.00 3,555.48 35,039.17 55.193 28,445.83
135-50027-030-000 Dental Insurance 5,502.00 5,502.00 226.37 2,498.33 45.408 3,003.67
135-50028-030-000 Vision Insurance 1,173.00 1,173.00 35.92 462.35 39.416 710.65
135-50029-030-000 Life Insurance & Other 5,059.00 5,059.00 118.24 2,813.08 55.605 2,245.92
135-50030-030-000 Social Security Taxes 27,181.00 27,181.00 2,112.95 17,137.41 63.049 10,043.59
135-50035-030-000 Medicare Taxes 6,357.00 6,357.00 494.14 4,007.92 63.047 2,349.08
135-50040-030-000 Unemployment Taxes 1,260.00 1,260.00 17.31 1,001.08 79.451 258.92
135-50045-030-000 Workman's Compensation 1,529.00 1,529.00 123.50 1,111.50 72.695 417.50
135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 86.95 211.90 42.380 288.10
135-50070-030-000 Employee Relations 4,960.00 4,960.00 38.10 3,147.18 63.451 1,812.82
Subtotal: 595,970.00 595,970.00 45,430.94 383,957.07 64.426 212,012.93
135-55030-030-000 Software & Support 78,391.00 78,391.00 3,032.54 62,465.58 79.685 15,925.42
135-55070-030-000 Independent Labor 154,000.00 154,000.00 11,872.89 113,700.82 73.832 40,299.18
135-55080-030-000 Maintenance & Repairs 14,000.00 14,000.00 5,160.69 36.862 8,839.31
135-55085-030-000 Generator Maint. and Repair 10,000.00 10,000.00 669.58 4,624.58 46.246 5,375.42
135-55120-030-000 Cleaning Services 10,000.00 10,000.00 869.06 6,569.57 65.696 3,430.43
135-55160-030-000 Professional Outside Services 63,325.00 63,325.00 59,240.00 93.549 4,085.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,001.44 5,707.36 63.415 3,292.64
Subtotal: 338,916.00 338,916.00 17,445.51 257,468.60 75.968 81,447.40
135-60005-030-000 Telephone 27,300.00 27,300.00 232.48 12,089.81 44.285 15,210.19
135-60010-030-000 Communications/Mobiles 4,000.00 4,000.00 237.37 2,274.17 56.854 1,725.83
135-60020-030-000 Electricity/Gas 16,261.00 16,261.00 963.22 4,815.43 29.613 11,445.57
135-60025-030-000 Water 2,500.00 2,500.00 184.89 524.01 20.960 1,975.99
135-60030-030-000 Rent And/Or Usage 616.40 616.40-
135-60035-030-000 Postage 30,000.00 30,000.00 3,022.55 17,579.92 58.600 12,420.08
135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 4,899.08 43,616.40 78.503 11,943.60
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,620.36 58,698.24 104.818 2,698.24-
135-60066-030-000 Publications/Books/Subscripts 1,600.00 1,600.00 206.38 12.899 1,393.62
135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 3,828.42 63.807 2,171.58
135-60075-030-000 Meetings 400.00 400.00 80.50 20.125 319.50
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,143.00 41.355 4,457.00
135-60100-030-000 Travel & per diem 4,885.00 4,885.00 114.99 958.71 19.626 3,926.29
135-60110-030-000 Physicals/Testing 200.00 200.00 200.00
July 18, 2018 Regular Meeting Agenda Packet
87 of 182
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 11
19:44 07/11/18 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 6/2018
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-60115-030-000 Elections 4,500.00 4,500.00 220.00 4.889 4,280.00
135-60125-030-000 Advertising 2,500.00 2,500.00 150.00 6.000 2,350.00
135-60235-030-000 Security 2,700.00 2,700.00 48.00 144.00 5.333 2,556.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 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 249,506.00 33,322.94 166,281.88 66.644 83,224.12
135-65010-030-000 Uniforms 700.00 700.00 273.73 39.104 426.27
135-65055-030-000 Hardware 7,420.00 7,420.00 2,006.68 27.044 5,413.32
135-65085-030-000 Office Supplies 7,000.00 7,000.00 284.28 3,870.52 55.293 3,129.48
135-65090-030-000 Printer Supplies & Maintenance 2,000.00 2,000.00 2,048.66 102.433 48.66-
135-65095-030-000 Maintenance Supplies 4,000.00 4,000.00 152.59 3,420.04 85.501 579.96
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 436.87 11,763.63 46.830 13,356.37
135-69005-030-000 Capital Outlays 13,000.00 13,000.00 11,027.67 48,354.99 371.961 35,354.99-
135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 226.31 2,216.86 48.193 2,383.14
Subtotal: 17,600.00 17,600.00 11,253.98 50,571.85 287.340 32,971.85-
Program number: 1,227,112.00 1,227,112.00 107,890.24 870,043.03 70.902 357,068.97
Department number: Administration 1,227,112.00 1,227,112.00 107,890.24 870,043.03 70.902 357,068.97
July 18, 2018 Regular Meeting Agenda Packet
88 of 182
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 12
19:44 07/11/18 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program:
Period Ending: 6/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 39,936.84 99,198.77 72.408 37,801.23
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 8,683.92 75.869 2,762.08
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 39,936.84 136,509.79 77.235 40,236.21
Program number: 176,746.00 176,746.00 39,936.84 136,509.79 77.235 40,236.21
Department number: Non Departmental 176,746.00 176,746.00 39,936.84 136,509.79 77.235 40,236.21
Expenditures Subtotal ----------- 10,055,411.00 10,055,411.00 830,890.08 6,813,602.86 67.761 3,241,808.14
Fund number: 135 MUD 1 General Fund 194,618.00- 194,618.00- 218,645.12- 1,534,162.39- 788.294 1,339,544.39
July 18, 2018 Regular Meeting Agenda Packet
89 of 182
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 13
19:44 07/11/18 Budget Summary with Amendment
Fund: 137 MUD 1 Consolidated GASB Department: Program:
Period Ending: 6/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
July 18, 2018 Regular Meeting Agenda Packet
90 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 5
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 6/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
1664 06/01/2018 Property Taxes (121,350.65) (59.34) (121,409.99) GL
1665 06/04/2018 Property Taxes (93.61) (121,503.60) GL
1666 06/05/2018 Property Taxes (6.36) (121,509.96) GL
1667 06/07/2018 Property Taxes (119.36) (121,629.32) GL
1668 06/11/2018 Property Taxes (21.28) (121,650.60) GL
1669 06/12/2018 Property Taxes (1.45) (121,652.05) GL
1670 06/13/2018 Property Taxes (116.16) (121,768.21) GL
1671 06/15/2018 Property Taxes (2.29) (121,770.50) GL
1672 06/18/2018 Property Taxes (4.18) (121,774.68) GL
1673 06/19/2018 Property Taxes (8.02) (121,782.70) GL
1674 06/21/2018 Property Taxes (.49) (121,783.19) GL
1675 06/22/2018 Property Taxes (1.42) (121,784.61) GL
1676 06/25/2018 Property Taxes (2.39) (121,787.00) GL
1677 06/26/2018 Property Taxes (4.03) (121,791.03) GL
1678 06/28/2018 Property Taxes (.22) (121,791.25) GL
1679 06/29/2018 Property Taxes 6.10 (121,785.15) GL
_______________
Account: 135-40000-000-000 Property Taxes Totals: (434.50) (121,785.15) **
(120,950.00) Budgeted 835.15 Remaining 101 % Used
Account: 135-40002-000-000 Property Taxes/Delinquent
1665 06/04/2018 Property Taxes (343.60) (2.11) (345.71) GL
1679 06/29/2018 Property Taxes 1.10 (344.61) GL
_______________
Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (1.01) (344.61) **
(200.00) Budgeted 144.61 Remaining 172 % Used
Account: 135-40015-000-000 Property Taxes/P & I
1664 06/01/2018 Property Taxes (492.32) (.88) (493.20) GL
1665 06/04/2018 Property Taxes (.57) (493.77) GL
1667 06/07/2018 Property Taxes (14.97) (508.74) GL
1668 06/11/2018 Property Taxes (3.19) (511.93) GL
1670 06/13/2018 Property Taxes (.35) (512.28) GL
1671 06/15/2018 Property Taxes (.34) (512.62) GL
1674 06/21/2018 Property Taxes (.07) (512.69) GL
1677 06/26/2018 Property Taxes (.28) (512.97) GL
_______________
Account: 135-40015-000-000 Property Taxes/P & I Totals: (20.65) (512.97) **
(200.00) Budgeted 312.97 Remaining 256 % Used
July 18, 2018 Regular Meeting Agenda Packet
91 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 6
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 6/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-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
1523 06/08/2018 UB 06/08/2018 Penalty removal UB20180608-20180608 User: (3,139,601.54) 26.13 (3,139,575.41) UB
1589 06/21/2018 UB 06/21/2018 Credit adjust UB20180621-20180621 User: 32.23 (3,139,543.18) UB
1636 06/30/2018 UB 06/2018 Billing UB20180630-20180630 User: (746,546.13) (3,886,089.31) UB
_______________
Account: 135-47000-000-000 Water Totals: (746,487.77) (3,886,089.31) **
(6,464,019.00) Budgeted (2,577,929.69) Remaining 60 % Used
Account: 135-47005-000-000 Sewer
1501 06/05/2018 UB 06/05/2018 WA Credits UB20180605-20180605 User: (1,943,596.97) 30.02 (1,943,566.95) UB
1523 06/08/2018 UB 06/08/2018 Penalty removal UB20180608-20180608 User: 53.22 (1,943,513.73) UB
1572 06/19/2018 UB 06/19/2018 WA Credit UB20180619-20180619 User: 304.43 (1,943,209.30) UB
1589 06/21/2018 UB 06/21/2018 Credit adjust UB20180621-20180621 User: 71.79 (1,943,137.51) UB
1607 06/25/2018 UB 06/25/2018 WA Credit UB20180625-20180625 User: 109.68 (1,943,027.83) UB
1636 06/30/2018 UB 06/2018 Billing UB20180630-20180630 User: (266,494.33) (2,209,522.16) UB
_______________
Account: 135-47005-000-000 Sewer Totals: (265,925.19) (2,209,522.16) **
(2,978,067.00) Budgeted (768,544.84) Remaining 74 % Used
Account: 135-47025-000-000 Penalties
1475 06/05/2018 UB 06/05/2018 Penalty removal UB20180605-20180605 User: (72,062.31) 28.03 (72,034.28) UB
1566 06/18/2018 UB 06/18/2018 Penalty Removal UB20180618-20180618 User: 50.41 (71,983.87) UB
1581 06/20/2018 UB 06/20/2018 Penalty Removal UB20180620-20180620 User: 20.87 (71,963.00) UB
1594 06/21/2018 UB 06/21/2018 Assess Penalties UB20180621-20180621 User: (9,403.75) (81,366.75) UB
1616 06/26/2018 UB 06/26/2018 Penaly Removal UB20180626-20180626 User: 302.45 (81,064.30) UB
1627 06/28/2018 UB 06/28/2018 Penalty Removal UB20180628-20180628 User: 95.99 (80,968.31) UB
_______________
Account: 135-47025-000-000 Penalties Totals: (8,906.00) (80,968.31) **
(106,279.00) Budgeted (25,310.69) Remaining 76 % Used
Account: 135-47030-000-000 Service Charges
1508 06/06/2018 UB 06/2018 Disconnect Fees UB20180606-20180606 User: (9,400.00) (1,000.00) (10,400.00) UB
1618 06/26/2018 UB 06/26/2018 After hours fee UB20180626-20180626 User: (200.00) (10,600.00) UB
July 18, 2018 Regular Meeting Agenda Packet
92 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 7
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 6/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-47030-000-000 Service Charges Totals: (1,200.00) (10,600.00) **
(21,350.00) Budgeted (10,750.00) Remaining 50 % Used
Account: 135-47035-000-000 Plumbing Inspections
1654 06/15/2018 Customer deposits 603 Hogan's Drive (1,700.00) (50.00) (1,750.00) Drees Homes CR
1654 06/15/2018 Customer deposits 16 Sadie Court (50.00) (1,800.00) Drees Homes CR
_______________
Account: 135-47035-000-000 Plumbing Inspections Totals: (100.00) (1,800.00) **
(1,500.00) Budgeted 300.00 Remaining 120 % Used
Account: 135-47045-000-000 Sewer Inspections
1654 06/15/2018 Customer deposits 603 Hogan's Drive (4,300.00) (150.00) (4,450.00) Drees Homes CR
1654 06/15/2018 Customer deposits 16 Sadie Court (150.00) (4,600.00) Drees Homes CR
_______________
Account: 135-47045-000-000 Sewer Inspections Totals: (300.00) (4,600.00) **
(4,500.00) Budgeted 100.00 Remaining 102 % Used
Account: 135-47070-000-000 TCCC Effluent Charges
1636 06/30/2018 UB 06/2018 Billing UB20180630-20180630 User: (27,196.00) (14,924.80) (42,120.80) UB
_______________
Account: 135-47070-000-000 TCCC Effluent Charges Totals: (14,924.80) (42,120.80) **
(60,000.00) Budgeted (17,879.20) Remaining 70 % Used
Account: 135-49010-000-000 Interest Income
1683 06/15/2018 June Bk of West CD Interest (30,645.77) (158.92) (30,804.69) GL
1684 06/30/2018 Bank Interest- June (142.04) (30,946.73) GL
1684 06/30/2018 Bank Interest- June (469.12) (31,415.85) GL
1684 06/30/2018 Bank Interest- June (5,670.28) (37,086.13) GL
1684 06/30/2018 Bank Interest- June (681.58) (37,767.71) GL
_______________
Account: 135-49010-000-000 Interest Income Totals: (7,121.94) (37,767.71) **
(12,000.00) Budgeted 25,767.71 Remaining 315 % Used
Account: 135-49016-000-000 Cell Tower Revenue
1539 06/07/2018 Cell Tower Rev AT&T June (7,762.20) (978.81) (8,741.01) GL
_______________
Account: 135-49016-000-000 Cell Tower Revenue Totals: (978.81) (8,741.01) **
(10,926.00) Budgeted (2,184.99) Remaining 80 % Used
July 18, 2018 Regular Meeting Agenda Packet
93 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 8
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 6/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-49018-000-000 Building Rent Income
1644 06/30/2018 Town Billed Invoice# 1644-1647 AR 20180630-20180630 User: (4,666.64) (583.33) (5,249.97) AR
_______________
Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (5,249.97) **
(7,000.00) Budgeted (1,750.03) Remaining 75 % 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) **
(2,000.00) Budgeted 13,400.00 Remaining 770 % Used
Account: 135-49075-000-000 Oversize Meter Reimbursement
1654 06/15/2018 Customer deposits 603 Hogan's Drive (10,806.76) (343.00) (11,149.76) Drees Homes CR
1654 06/15/2018 Customer deposits 16 Sadie Court (343.00) (11,492.76) Drees Homes CR
_______________
Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (686.00) (11,492.76) **
(18,179.00) Budgeted (6,686.24) Remaining 63 % Used
Account: 135-49141-000-000 Interfund Transfer In
1552 06/04/2018 Texpl Tsfr May Int 519 to 135 (1,850,129.46) (1,484.87) (1,851,614.33) GL
1685 06/30/2018 Transfer 517 Pros to 135 Pros (154.89) (1,851,769.22) GL
_______________
Account: 135-49141-000-000 Interfund Transfer In Totals: (1,639.76) (1,851,769.22) **
.00 Budgeted 1,851,769.22 Remaining 0 % Used
Account: 135-49900-000-000 Miscellaneous Income
1636 06/30/2018 UB 06/2018 Billing UB20180630-20180630 User: (58,775.83) (225.44) (59,001.27) UB
_______________
Account: 135-49900-000-000 Miscellaneous Income Totals: (225.44) (59,001.27) **
(5,000.00) Budgeted 54,001.27 Remaining 1.180 % Used
Account: 135-49901-000-000 Records Management Revenue
.00 .00
_______________
Account: 135-49901-000-000 Records Management Revenue Totals: .00 .00 **
(20.00) Budgeted (20.00) Remaining 0 % Used
July 18, 2018 Regular Meeting Agenda Packet
94 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 9
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 6/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-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: ----------------------------------- (8,347,765.25) **
(1,049,535.20) Monthly Total (10,250,029.00) Budgeted (1,902,263.75) Remaining 81 % Used
July 18, 2018 Regular Meeting Agenda Packet
95 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 6/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
1448 06/01/2018 MUD PR 06.01.18 Salaries & Wages 138,182.00 9,939.23 148,121.23 PR
1548 06/15/2018 MUD PR 06.15.18 Salaries & Wages 9,939.22 158,060.45 PR
1614 06/29/2018 MUD PR 06/29/18 Salaries & Wages 9,976.32 168,036.77 PR
_______________
Account: 135-50005-010-000 Salaries & Wages Totals: 29,854.77 168,036.77 **
274,279.00 Budgeted 106,242.23 Remaining 61 % Used
Account: 135-50010-010-000 Overtime
1448 06/01/2018 MUD PR 06.01.18 Overtime 6,518.38 440.61 6,958.99 PR
1548 06/15/2018 MUD PR 06.15.18 Overtime 586.26 7,545.25 PR
1614 06/29/2018 MUD PR 06/29/18 Overtime 522.68 8,067.93 PR
_______________
Account: 135-50010-010-000 Overtime Totals: 1,549.55 8,067.93 **
20,000.00 Budgeted 11,932.07 Remaining 40 % 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
1548 06/15/2018 MUD PR 06.15.18 Certification 1,400.00 200.00 1,600.00 PR
_______________
Account: 135-50017-010-000 Certification Totals: 200.00 1,600.00 **
3,300.00 Budgeted 1,700.00 Remaining 48 % Used
Account: 135-50020-010-000 Retirement
1448 06/01/2018 MUD PR 06.01.18 Retirement 15,230.41 960.15 16,190.56 PR
1548 06/15/2018 MUD PR 06.15.18 Retirement 992.08 17,182.64 PR
1614 06/29/2018 MUD PR 06/29/18 Retirement 971.18 18,153.82 PR
_______________
Account: 135-50020-010-000 Retirement Totals: 2,923.41 18,153.82 **
27,843.00 Budgeted 9,689.18 Remaining 65 % Used
Account: 135-50026-010-000 Medical Insurance
1448 06/01/2018 MUD PR 06.01.18 Medical Insurance 21,004.63 1,474.40 22,479.03 PR
July 18, 2018 Regular Meeting Agenda Packet
96 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 6/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
1548 06/15/2018 MUD PR 06.15.18 Medical Insurance 21,004.63 1,474.40 23,953.43 PR
_______________
Account: 135-50026-010-000 Medical Insurance Totals: 2,948.80 23,953.43 **
52,196.00 Budgeted 28,242.57 Remaining 46 % Used
Account: 135-50027-010-000 Dental Insurance
1448 06/01/2018 MUD PR 06.01.18 Dental Insurance 1,734.69 106.85 1,841.54 PR
1548 06/15/2018 MUD PR 06.15.18 Dental Insurance 106.80 1,948.34 PR
_______________
Account: 135-50027-010-000 Dental Insurance Totals: 213.65 1,948.34 **
5,182.00 Budgeted 3,233.66 Remaining 38 % Used
Account: 135-50028-010-000 Vision Insurance
1448 06/01/2018 MUD PR 06.01.18 Vision Insurance 316.15 17.98 334.13 PR
1548 06/15/2018 MUD PR 06.15.18 Vision Insurance 17.94 352.07 PR
_______________
Account: 135-50028-010-000 Vision Insurance Totals: 35.92 352.07 **
994.00 Budgeted 641.93 Remaining 35 % Used
Account: 135-50029-010-000 Life Insurance & Other
1459 06/01/2018 June A/P Employee benefits LTD & STD 1,803.31 87.01 1,890.32 METLIFE GROUP BENEFITS 4254 AP
1651 06/29/2018 June A/P Benefits-Café 125 18.00 1,908.32 BenefitMall 4319 AP
_______________
Account: 135-50029-010-000 Life Insurance & Other Totals: 105.01 1,908.32 **
2,982.00 Budgeted 1,073.68 Remaining 64 % Used
Account: 135-50030-010-000 Social Security Taxes
1448 06/01/2018 MUD PR 06.01.18 Social Security Taxes 9,213.19 641.07 9,854.26 PR
1548 06/15/2018 MUD PR 06.15.18 Social Security Taxes 649.52 10,503.78 PR
1614 06/29/2018 MUD PR 06/29/18 Social Security Taxes 652.23 11,156.01 PR
_______________
Account: 135-50030-010-000 Social Security Taxes Totals: 1,942.82 11,156.01 **
18,662.00 Budgeted 7,505.99 Remaining 60 % Used
Account: 135-50035-010-000 Medicare Taxes
1448 06/01/2018 MUD PR 06.01.18 Medicare Taxes 2,154.69 149.93 2,304.62 PR
1548 06/15/2018 MUD PR 06.15.18 Medicare Taxes 151.91 2,456.53 PR
1614 06/29/2018 MUD PR 06/29/18 Medicare Taxes 152.54 2,609.07 PR
July 18, 2018 Regular Meeting Agenda Packet
97 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 12
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 6/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-50035-010-000 Medicare Taxes Totals: 454.38 2,609.07 **
4,365.00 Budgeted 1,755.93 Remaining 60 % Used
Account: 135-50040-010-000 Unemployment Taxes
818.68 .00 818.68
_______________
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
240 06/01/2018 Insurance/Wrk Comp Exp Jun 7,199.36 899.92 8,099.28 GL
_______________
Account: 135-50045-010-000 Workman's Compensation Totals: 899.92 8,099.28 **
11,854.00 Budgeted 3,754.72 Remaining 68 % Used
Account: 135-50060-010-000 Pre-emp Physicals/Testing
226.05 .00 226.05
_______________
Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 226.05 **
200.00 Budgeted (26.05) Remaining 113 % Used
Account: 135-50070-010-000 Employee Relations
18.99 .00 18.99
_______________
Account: 135-50070-010-000 Employee Relations Totals: .00 18.99 **
300.00 Budgeted 281.01 Remaining 6 % Used
Account: 135-55005-010-000 Engineering
.00 .00
_______________
Account: 135-55005-010-000 Engineering Totals: .00 .00 **
275,000.00 Budgeted 275,000.00 Remaining 0 % Used
Account: 135-55080-010-000 Maintenance & Repairs
1591 06/21/2018 June A/P Dechlor tabs-Flags 50,169.61 517.94 50,687.55 Core & Main LP 4279 AP
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 AMAZON MKTPLACE PMTS 58.84 50,746.39 AMAZON MKTPLACE PMTS PC
July 18, 2018 Regular Meeting Agenda Packet
98 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 13
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 6/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 ROANOKE WINNELSON CO 50,169.61 28.58 50,774.97 ROANOKE WINNELSON CO PC
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 THE HOME DEPOT #6581 19.50 50,794.47 THE HOME DEPOT #6581 PC
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 THE HOME DEPOT #6581 107.09 50,901.56 THE HOME DEPOT #6581 PC
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 THE HOME DEPOT #6581 33.81 50,935.37 THE HOME DEPOT #6581 PC
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 THE HOME DEPOT #6581 46.47 50,981.84 THE HOME DEPOT #6581 PC
1651 06/29/2018 June A/P Gaskets 27.60 51,009.44 Core & Main LP 4324 AP
_______________
Account: 135-55080-010-000 Maintenance & Repairs Totals: 839.83 51,009.44 **
100,000.00 Budgeted 48,990.56 Remaining 51 % 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
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 CARMEL CARWASH - ROANO 3,887.82 49.95 3,937.77 CARMEL CARWASH - ROANO PC
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 ROANOKE AUTO SUPPLY LT 66.60 4,004.37 ROANOKE AUTO SUPPLY LT PC
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 AUTOZONE #4206 41.98 4,046.35 AUTOZONE #4206 PC
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 DISCOUNT TIRE TXD 75 28.50 4,074.85 DISCOUNT TIRE TXD 75 PC
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 KWIK KAR LUBE & TUNE O 63.96 4,138.81 KWIK KAR LUBE & TUNE O PC
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 GIERISCH CARE 0050292 72.37 4,211.18 GIERISCH CARE 0050292 PC
_______________
Account: 135-55090-010-000 Vehicle Maintenance Totals: 323.36 4,211.18 **
4,000.00 Budgeted (211.18) Remaining 105 % Used
Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 BLAGG TIRE & SERVICE 35.00 35.00 BLAGG TIRE & SERVICE PC
_______________
Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: 35.00 35.00 **
3,500.00 Budgeted 3,465.00 Remaining 1 % Used
Account: 135-55135-010-000 Lab Analysis
1591 06/21/2018 June A/P Lab samples-water 5,765.16 280.00 6,045.16 TARRANT CTY PUBLIC HEALTH LAB 4298 AP
_______________
Account: 135-55135-010-000 Lab Analysis Totals: 280.00 6,045.16 **
5,500.00 Budgeted (545.16) Remaining 110 % Used
July 18, 2018 Regular Meeting Agenda Packet
99 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 14
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 6/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-60010-010-000 Communications/Mobiles
1591 06/21/2018 June A/P Cell phones 2,492.62 370.18 2,862.80 VERIZON WIRELESS 4302 AP
_______________
Account: 135-60010-010-000 Communications/Mobiles Totals: 370.18 2,862.80 **
4,700.00 Budgeted 1,837.20 Remaining 61 % Used
Account: 135-60020-010-000 Electricity
1591 06/21/2018 June A/P Electricity 5/9-6/8 82,161.55 12,787.14 94,948.69 HUDSON ENERGY SERVICES, LLC 4289 AP
_______________
Account: 135-60020-010-000 Electricity Totals: 12,787.14 94,948.69 **
175,356.00 Budgeted 80,407.31 Remaining 54 % 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
1,536.78 .00 1,536.78
_______________
Account: 135-60080-010-000 Schools & Training Totals: .00 1,536.78 **
2,785.00 Budgeted 1,248.22 Remaining 55 % 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
July 18, 2018 Regular Meeting Agenda Packet
100 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 15
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 6/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
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
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
17,410.32 .00 17,410.32
_______________
Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 17,410.32 **
55,176.00 Budgeted 37,765.68 Remaining 32 % Used
Account: 135-60150-010-000 Wholesale Water
1651 06/29/2018 June A/P Wholesale water 1,021,013.08 223,655.16 1,244,668.24 CITY OF FORT WORTH 4323 AP
_______________
Account: 135-60150-010-000 Wholesale Water Totals: 223,655.16 1,244,668.24 **
2,823,170.00 Budgeted 1,578,501.76 Remaining 44 % 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
502.70 .00 502.70
_______________
Account: 135-60280-010-000 Property Maintenance Totals: .00 502.70 **
3,000.00 Budgeted 2,497.30 Remaining 17 % Used
Account: 135-60285-010-000 Lawn Equipment & Maintenance
1695 06/30/2018 June A/P June Mowing 6,000.00 1,500.00 7,500.00 WATTS ELLISON LLC 4370 AP
July 18, 2018 Regular Meeting Agenda Packet
101 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 6/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-60285-010-000 Lawn Equipment & Maintenance Totals: 1,500.00 7,500.00 **
14,750.00 Budgeted 7,250.00 Remaining 51 % Used
Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S
1606 06/30/2018 Texpool Transfers June 202,242.48 25,280.31 227,522.79 GL
_______________
Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S Totals: 25,280.31 227,522.79 **
278,084.00 Budgeted 50,561.21 Remaining 82 % Used
Account: 135-60333-010-000 Interfund Transfer Out-Reserve
1626 06/28/2018 TexPl Trsfr Corr June Catch-up TexPool shorted transfr JE1519 32,649.00 15.00 32,664.00 GL
1606 06/30/2018 Texpool Transfers June 4,083.00 36,747.00 GL
_______________
Account: 135-60333-010-000 Interfund Transfer Out-Reserve Totals: 4,098.00 36,747.00 **
48,996.00 Budgeted 12,249.00 Remaining 75 % Used
Account: 135-60334-010-000 Interfund Transfer Out
1,053,935.08 .00 1,053,935.08
_______________
Account: 135-60334-010-000 Interfund Transfer Out Totals: .00 1,053,935.08 **
200,000.00 Budgeted (853,935.08) Remaining 527 % 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
1609 06/24/2018 June A/P Fuel 6,965.98 987.64 7,953.62 US Bank Voyager Fleet Systems 4368 AP
_______________
Account: 135-65005-010-000 Fuel & Lube Totals: 987.64 7,953.62 **
15,000.00 Budgeted 7,046.38 Remaining 53 % Used
Account: 135-65010-010-000 Uniforms
1,249.14 .00 1,249.14
July 18, 2018 Regular Meeting Agenda Packet
102 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 6/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-65010-010-000 Uniforms Totals: .00 1,249.14 **
4,488.00 Budgeted 3,238.86 Remaining 28 % Used
Account: 135-65030-010-000 Chemicals
1591 06/21/2018 June A/P Testing supplies 11,958.84 606.00 12,564.84 HACH COMPANY 4287 AP
1651 06/29/2018 June A/P Chlorine 884.96 13,449.80 DPC INDUSTRIES, INC 4329 AP
_______________
Account: 135-65030-010-000 Chemicals Totals: 1,490.96 13,449.80 **
20,000.00 Budgeted 6,550.20 Remaining 67 % 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
583.00 .00 583.00
_______________
Account: 135-65040-010-000 Safety Equipment Totals: .00 583.00 **
1,000.00 Budgeted 417.00 Remaining 58 % Used
Account: 135-65050-010-000 Meter Expense
1587 06/21/2018 June A/P meters 21,102.00 3,360.75 24,462.75 ATLAS UTILITY SUPPLY CO. 4276 AP
1651 06/29/2018 June A/P CE endpoints 513.00 24,975.75 ATLAS UTILITY SUPPLY CO. 4318 AP
_______________
Account: 135-65050-010-000 Meter Expense Totals: 3,873.75 24,975.75 **
50,000.00 Budgeted 25,024.25 Remaining 50 % Used
Account: 135-65053-010-000 Meter Change Out Program
48,900.00 .00 48,900.00
_______________
Account: 135-65053-010-000 Meter Change Out Program Totals: .00 48,900.00 **
84,000.00 Budgeted 35,100.00 Remaining 58 % Used
Account: 135-69005-010-000 Capital Outlays
July 18, 2018 Regular Meeting Agenda Packet
103 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 18
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 6/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
1591 06/21/2018 June A/P 16" water line 525,538.34 461.02 525,999.36 Halff Associates, INC 4286 AP
1591 06/21/2018 June A/P 16" water line 31,432.06 557,431.42 Halff Associates, INC 4286 AP
_______________
Account: 135-69005-010-000 Capital Outlays Totals: 31,893.08 557,431.42 **
810,012.00 Budgeted 252,580.58 Remaining 69 % Used
Account: 135-69008-010-000 Short Term Debt-Principal
.00 .00
_______________
Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 .00 **
38,731.00 Budgeted 38,731.00 Remaining 0 % Used
Account: 135-69009-010-000 Short Term Debt-Interest
.00 .00
_______________
Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 .00 **
5,713.00 Budgeted 5,713.00 Remaining 0 % 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 **
118,775.00 Budgeted 10,910.62 Remaining 91 % Used
July 18, 2018 Regular Meeting Agenda Packet
104 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 19
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID
Period Ending: 6/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
1,200.08 .00 1,200.08
_______________
Account: 135-55135-010-001 Lab Analysis for PID Totals: .00 1,200.08 **
2,000.00 Budgeted 799.92 Remaining 60 % Used
Department 10 Totals: ----------------------------------- 3,843,683.63 **
348,542.64 Monthly Total 5,657,433.00 Budgeted 1,813,749.37 Remaining 68 % Used
July 18, 2018 Regular Meeting Agenda Packet
105 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 6/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
1448 06/01/2018 MUD PR 06.01.18 Salaries & Wages 235,318.69 12,605.43 247,924.12 PR
1548 06/15/2018 MUD PR 06.15.18 Salaries & Wages 12,746.59 260,670.71 PR
1614 06/29/2018 MUD PR 06/29/18 Salaries & Wages 12,718.82 273,389.53 PR
_______________
Account: 135-50005-020-000 Salaries & Wages Totals: 38,070.84 273,389.53 **
410,866.00 Budgeted 137,476.47 Remaining 67 % Used
Account: 135-50010-020-000 Overtime
1448 06/01/2018 MUD PR 06.01.18 Overtime 23,600.81 1,018.40 24,619.21 PR
1548 06/15/2018 MUD PR 06.15.18 Overtime 846.82 25,466.03 PR
1614 06/29/2018 MUD PR 06/29/18 Overtime 823.22 26,289.25 PR
_______________
Account: 135-50010-020-000 Overtime Totals: 2,688.44 26,289.25 **
30,000.00 Budgeted 3,710.75 Remaining 88 % 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
1548 06/15/2018 MUD PR 06.15.18 Certification 5,636.00 700.00 6,336.00 PR
_______________
Account: 135-50017-020-000 Certification Totals: 700.00 6,336.00 **
8,400.00 Budgeted 2,064.00 Remaining 75 % Used
Account: 135-50020-020-000 Retirement
1448 06/01/2018 MUD PR 06.01.18 Retirement 26,611.46 1,260.20 27,871.66 PR
1548 06/15/2018 MUD PR 06.15.18 Retirement 1,322.14 29,193.80 PR
1614 06/29/2018 MUD PR 06/29/18 Retirement 1,252.64 30,446.44 PR
_______________
Account: 135-50020-020-000 Retirement Totals: 3,834.98 30,446.44 **
42,243.00 Budgeted 11,796.56 Remaining 72 % Used
Account: 135-50026-020-000 Medical Insurance
1448 06/01/2018 MUD PR 06.01.18 Medical Insurance 43,493.33 2,759.36 46,252.69 PR
July 18, 2018 Regular Meeting Agenda Packet
106 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 6/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
1548 06/15/2018 MUD PR 06.15.18 Medical Insurance 43,493.33 2,759.33 49,012.02 PR
_______________
Account: 135-50026-020-000 Medical Insurance Totals: 5,518.69 49,012.02 **
62,175.00 Budgeted 13,162.98 Remaining 79 % Used
Account: 135-50027-020-000 Dental Insurance
1448 06/01/2018 MUD PR 06.01.18 Dental Insurance 3,204.18 185.96 3,390.14 PR
1548 06/15/2018 MUD PR 06.15.18 Dental Insurance 185.93 3,576.07 PR
_______________
Account: 135-50027-020-000 Dental Insurance Totals: 371.89 3,576.07 **
5,271.00 Budgeted 1,694.93 Remaining 68 % Used
Account: 135-50028-020-000 Vision Insurance
1448 06/01/2018 MUD PR 06.01.18 Vision Insurance 567.26 29.46 596.72 PR
1548 06/15/2018 MUD PR 06.15.18 Vision Insurance 29.44 626.16 PR
_______________
Account: 135-50028-020-000 Vision Insurance Totals: 58.90 626.16 **
1,114.00 Budgeted 487.84 Remaining 56 % Used
Account: 135-50029-020-000 Life Insurance & Other
1459 06/01/2018 June A/P Employee benefits LTD & STD 3,162.18 120.84 3,283.02 METLIFE GROUP BENEFITS 4254 AP
1651 06/29/2018 June A/P Benefits-Café 125 36.00 3,319.02 BenefitMall 4319 AP
_______________
Account: 135-50029-020-000 Life Insurance & Other Totals: 156.84 3,319.02 **
4,281.00 Budgeted 961.98 Remaining 78 % Used
Account: 135-50030-020-000 Social Security Taxes
1448 06/01/2018 MUD PR 06.01.18 Social Security Taxes 15,650.17 767.07 16,417.24 PR
1548 06/15/2018 MUD PR 06.15.18 Social Security Taxes 784.44 17,201.68 PR
1614 06/29/2018 MUD PR 06/29/18 Social Security Taxes 842.20 18,043.88 PR
_______________
Account: 135-50030-020-000 Social Security Taxes Totals: 2,393.71 18,043.88 **
28,314.00 Budgeted 10,270.12 Remaining 64 % Used
Account: 135-50035-020-000 Medicare Taxes
1448 06/01/2018 MUD PR 06.01.18 Medicare Taxes 3,660.11 179.41 3,839.52 PR
1548 06/15/2018 MUD PR 06.15.18 Medicare Taxes 183.44 4,022.96 PR
1614 06/29/2018 MUD PR 06/29/18 Medicare Taxes 196.97 4,219.93 PR
July 18, 2018 Regular Meeting Agenda Packet
107 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 6/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-50035-020-000 Medicare Taxes Totals: 559.82 4,219.93 **
6,622.00 Budgeted 2,402.07 Remaining 64 % Used
Account: 135-50040-020-000 Unemployment Taxes
1,134.00 .00 1,134.00
_______________
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
240 06/01/2018 Insurance/Wrk Comp Exp Jun 10,784.00 1,348.00 12,132.00 GL
_______________
Account: 135-50045-020-000 Workman's Compensation Totals: 1,348.00 12,132.00 **
17,990.00 Budgeted 5,858.00 Remaining 67 % Used
Account: 135-50060-020-000 Pre-emp Physicals/Testing
1591 06/21/2018 June A/P Post accident drug test 63.00 63.00 126.00 CARENOW CORPORATE 4277 AP
_______________
Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: 63.00 126.00 **
300.00 Budgeted 174.00 Remaining 42 % 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 **
20,550.00 Budgeted 18,405.00 Remaining 10 % Used
Account: 135-55080-020-000 Maintenance & Repairs
1591 06/21/2018 June A/P Fan in LS #8 panel 44,421.37 625.89 45,047.26 DHS AUTOMATION, INC 4281 AP
1591 06/21/2018 June A/P Push camera fix 1,626.32 46,673.58 CLS SEWER EQUIPMENT CO., INC 4278 AP
July 18, 2018 Regular Meeting Agenda Packet
108 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 23
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 6/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
1591 06/21/2018 June A/P Valves in vault for Lakes A & 44,421.37 16,036.89 62,710.47 REY-MAR CONSTRUCTION 4296 AP
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 ROYAL BRASS AND HOSE 280.71 62,991.18 ROYAL BRASS AND HOSE PC
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 GRAINGER 16.82 63,008.00 GRAINGER PC
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 THE HOME DEPOT #6581 24.27 63,032.27 THE HOME DEPOT #6581 PC
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 THE HOME DEPOT #6581 102.69 63,134.96 THE HOME DEPOT #6581 PC
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 FILTER ELEMENT STORE 454.86 63,589.82 FILTER ELEMENT STORE PC
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 THE HOME DEPOT #6581 76.54 63,666.36 THE HOME DEPOT #6581 PC
1651 06/29/2018 June A/P oil & grease for blowers 516.99 64,183.35 Universal Blower Pac, Inc 4367 AP
_______________
Account: 135-55080-020-000 Maintenance & Repairs Totals: 19,761.98 64,183.35 **
86,100.00 Budgeted 21,916.65 Remaining 75 % 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
1651 06/29/2018 June A/P welding 6,353.60 450.00 6,803.60 REY-MAR CONSTRUCTION 4356 AP
_______________
Account: 135-55090-020-000 Vehicle Maintenance Totals: 450.00 6,803.60 **
8,000.00 Budgeted 1,196.40 Remaining 85 % Used
Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 AUTOZONE #4206 289.69 17.99 307.68 AUTOZONE #4206 PC
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 RDOCE-FTW- 87.72 395.40 RDOCE-FTW- PC
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 ROANOKE AUTO SUPPLY LT (119.94) 275.46 ROANOKE AUTO SUPPLY LT PC
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 ROANOKE AUTO SUPPLY LT 119.94 395.40 ROANOKE AUTO SUPPLY LT PC
_______________
Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: 105.71 395.40 **
500.00 Budgeted 104.60 Remaining 79 % Used
Account: 135-55125-020-000 Dumpster Services
1591 06/21/2018 June A/P Dumpster Haul off 55,077.12 1,690.00 56,767.12 L.H. CHANEY MATERIALS, INC. 4292 AP
1651 06/29/2018 June A/P Dumpster services 812.47 57,579.59 L.H. CHANEY MATERIALS, INC. 4347 AP
_______________
Account: 135-55125-020-000 Dumpster Services Totals: 2,502.47 57,579.59 **
60,000.00 Budgeted 2,420.41 Remaining 96 % Used
July 18, 2018 Regular Meeting Agenda Packet
109 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 24
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 6/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-020-000 Lab Analysis
1591 06/21/2018 June A/P Lab testing 22,716.02 246.00 22,962.02 OXIDOR LABORATORIES LLC 4295 AP
1591 06/21/2018 June A/P lab testing 176.00 23,138.02 OXIDOR LABORATORIES LLC 4295 AP
1591 06/21/2018 June A/P Lab testing 176.00 23,314.02 OXIDOR LABORATORIES LLC 4295 AP
1591 06/21/2018 June A/P lab testing 176.00 23,490.02 OXIDOR LABORATORIES LLC 4295 AP
1591 06/21/2018 June A/P Lab testing 246.00 23,736.02 OXIDOR LABORATORIES LLC 4295 AP
1651 06/29/2018 June A/P Lab testing 246.00 23,982.02 OXIDOR LABORATORIES LLC 4355 AP
1651 06/29/2018 June A/P Lab testing 176.00 24,158.02 OXIDOR LABORATORIES LLC 4355 AP
_______________
Account: 135-55135-020-000 Lab Analysis Totals: 1,442.00 24,158.02 **
30,000.00 Budgeted 5,841.98 Remaining 81 % Used
Account: 135-60010-020-000 Communications/Mobiles
1591 06/21/2018 June A/P Cell phones 3,393.00 332.19 3,725.19 VERIZON WIRELESS 4302 AP
_______________
Account: 135-60010-020-000 Communications/Mobiles Totals: 332.19 3,725.19 **
4,700.00 Budgeted 974.81 Remaining 79 % Used
Account: 135-60020-020-000 Electricity
1591 06/21/2018 June A/P Electricity 4/24-5/24 110,273.38 27.90 110,301.28 TRI COUNTY ELECTRIC 4300 AP
1591 06/21/2018 June A/P Electricity 4/24-5/24 307.43 110,608.71 TRI COUNTY ELECTRIC 4300 AP
1591 06/21/2018 June A/P Electricity 4/24-5/24 182.03 110,790.74 TRI COUNTY ELECTRIC 4300 AP
1591 06/21/2018 June A/P Electricity 5/9-6/8 11,247.75 122,038.49 HUDSON ENERGY SERVICES, LLC 4289 AP
1644 06/30/2018 Town Billed Invoice# 1644-1647 AR 20180630-20180630 User: (202.28) 121,836.21 AR
_______________
Account: 135-60020-020-000 Electricity Totals: 11,562.83 121,836.21 **
266,709.00 Budgeted 144,872.79 Remaining 46 % Used
Account: 135-60066-020-000 Publications/Books/Subscripts
.00 .00
_______________
Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 **
200.00 Budgeted 200.00 Remaining 0 % Used
Account: 135-60070-020-000 Dues & Memberships
.00 .00
_______________
Account: 135-60070-020-000 Dues & Memberships Totals: .00 .00 **
300.00 Budgeted 300.00 Remaining 0 % Used
July 18, 2018 Regular Meeting Agenda Packet
110 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 6/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-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
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
July 18, 2018 Regular Meeting Agenda Packet
111 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 6/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
.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
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 THE HOME DEPOT #6581 19.97 21.91 41.88 THE HOME DEPOT #6581 PC
_______________
Account: 135-60280-020-000 Property Maintenance Totals: 21.91 41.88 **
4,000.00 Budgeted 3,958.12 Remaining 1 % Used
Account: 135-60285-020-000 Lawn Equipment & Maintenance
1695 06/30/2018 June A/P June Mowing 4,600.00 1,180.00 5,780.00 WATTS ELLISON LLC 4370 AP
_______________
Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 1,180.00 5,780.00 **
11,600.00 Budgeted 5,820.00 Remaining 50 % Used
Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S
1606 06/30/2018 Texpool Transfers June 88,758.48 11,094.81 99,853.29 GL
_______________
Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 11,094.81 99,853.29 **
122,043.00 Budgeted 22,189.71 Remaining 82 % Used
Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S
1606 06/30/2018 Texpool Transfers June 435,445.76 54,430.72 489,876.48 GL
_______________
Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: 54,430.72 489,876.48 **
598,738.00 Budgeted 108,861.52 Remaining 82 % Used
Account: 135-60333-020-000 Interfund Transfer Out-Reserve
1626 06/28/2018 TexPl Trsfr Corr June Catch-up TexPool shorted transfr JE1519 82,194.00 30.00 82,224.00 GL
1606 06/30/2018 Texpool Transfers June 10,278.00 92,502.00 GL
_______________
Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 10,308.00 92,502.00 **
123,336.00 Budgeted 30,834.00 Remaining 75 % Used
Account: 135-60334-020-000 Interfund Transfer Out
July 18, 2018 Regular Meeting Agenda Packet
112 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 6/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
1606 06/30/2018 Texpool Transfers June 201,031.99 142,059.21 343,091.20 GL
1606 06/30/2018 Texpool Transfers June 309.78 343,400.98 GL
_______________
Account: 135-60334-020-000 Interfund Transfer Out Totals: 142,368.99 343,400.98 **
200,000.00 Budgeted (143,400.98) Remaining 172 % 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
1609 06/24/2018 June A/P Fuel 6,265.67 644.06 6,909.73 US Bank Voyager Fleet Systems 4368 AP
_______________
Account: 135-65005-020-000 Fuel & Lube Totals: 644.06 6,909.73 **
12,500.00 Budgeted 5,590.27 Remaining 55 % Used
Account: 135-65010-020-000 Uniforms
1,774.59 .00 1,774.59
_______________
Account: 135-65010-020-000 Uniforms Totals: .00 1,774.59 **
4,459.00 Budgeted 2,684.41 Remaining 40 % Used
Account: 135-65030-020-000 Chemicals
1591 06/21/2018 June A/P CIP Solutions 8,041.23 657.00 8,698.23 Valley Solvent Company, INC 4301 AP
1651 06/29/2018 June A/P CIP solution 536.00 9,234.23 Valley Solvent Company, INC 4369 AP
_______________
Account: 135-65030-020-000 Chemicals Totals: 1,193.00 9,234.23 **
27,500.00 Budgeted 18,265.77 Remaining 34 % Used
Account: 135-65035-020-000 Small Tools
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 SAMSCLUB.COM 1,149.94 239.94 1,389.88 SAMSCLUB.COM PC
_______________
Account: 135-65035-020-000 Small Tools Totals: 239.94 1,389.88 **
1,000.00 Budgeted (389.88) Remaining 139 % Used
Account: 135-65040-020-000 Safety Equipment
July 18, 2018 Regular Meeting Agenda Packet
113 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 28
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 6/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
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
1591 06/21/2018 June A/P lab supplies 13,483.81 2,083.79 15,567.60 IDEXX DISTRIBUTION, INC 4290 AP
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 TOM THUMB #1789 3.96 15,571.56 TOM THUMB #1789 PC
1651 06/29/2018 June A/P Lab supplies 72.68 15,644.24 HACH COMPANY 4336 AP
_______________
Account: 135-65045-020-000 Lab Supplies Totals: 2,160.43 15,644.24 **
14,000.00 Budgeted (1,644.24) Remaining 112 % Used
Account: 135-69005-020-000 Capital Outlays
1591 06/21/2018 June A/P Second half of payment 91,150.61 12,471.18 103,621.79 DHS AUTOMATION, INC 4281 AP
1591 06/21/2018 June A/P Legal WWTP 297.50 103,919.29 Dubois Bryant Campbell LLP 4283 AP
1651 06/29/2018 June A/P SCADA LS #2 2,600.00 106,519.29 DHS AUTOMATION, INC 4328 AP
_______________
Account: 135-69005-020-000 Capital Outlays Totals: 15,368.68 106,519.29 **
547,327.00 Budgeted 440,807.71 Remaining 19 % Used
Account: 135-69008-020-000 Short Term Debt-Principal
.00 .00
_______________
Account: 135-69008-020-000 Short Term Debt-Principal Totals: .00 .00 **
51,342.00 Budgeted 51,342.00 Remaining 0 % Used
Account: 135-69009-020-000 Short Term Debt-Interest
.00 .00
_______________
Account: 135-69009-020-000 Short Term Debt-Interest Totals: .00 .00 **
7,573.00 Budgeted 7,573.00 Remaining 0 % 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
July 18, 2018 Regular Meeting Agenda Packet
114 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 29
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 6/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: ----------------------------------- 1,954,139.24 **
330,932.83 Monthly Total 2,981,140.00 Budgeted 1,027,000.76 Remaining 66 % Used
July 18, 2018 Regular Meeting Agenda Packet
115 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program:
Period Ending: 6/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
240 06/01/2018 Insurance/Wrk Comp Exp Jun 19.36 2.42 21.78 GL
_______________
Account: 135-50045-026-000 Workman's Compensation Totals: 2.42 21.78 **
30.00 Budgeted 8.22 Remaining 73 % 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
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 WAL-MART #5247 1,215.00 43.85 1,258.85 WAL-MART #5247 PC
_______________
Account: 135-60075-026-000 Meetings Totals: 43.85 1,258.85 **
1,200.00 Budgeted (58.85) Remaining 105 % Used
Account: 135-60080-026-000 Schools & Training
1,540.00 .00 1,540.00
_______________
Account: 135-60080-026-000 Schools & Training Totals: .00 1,540.00 **
4,000.00 Budgeted 2,460.00 Remaining 39 % Used
Account: 135-60100-026-000 Travel & per diem
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 HYATT HOTELS 960.00 244.01 1,204.01 HYATT HOTELS PC
1651 06/29/2018 June A/P AWBD conference, hotel, mileag 661.43 1,865.44 William Rose 4372 AP
1651 06/29/2018 June A/P AWBD conference, hotel, mileag 533.04 2,398.48 Steve Flynn 4362 AP
1651 06/29/2018 June A/P AWBD conference, hotel, mileag 914.66 3,313.14 Gregory Wilson 4335 AP
1651 06/29/2018 June A/P AWBD conference, hotel, mileag 1,039.14 4,352.28 Kelly Castonguay 4343 AP
_______________
Account: 135-60100-026-000 Travel & per diem Totals: 3,392.28 4,352.28 **
5,000.00 Budgeted 647.72 Remaining 87 % Used
July 18, 2018 Regular Meeting Agenda Packet
116 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program:
Period Ending: 6/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-60245-026-000 Miscellaneous Expenses
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 PANERA BREAD #601996 1,255.28 148.98 1,404.26 PANERA BREAD #601996 PC
_______________
Account: 135-60245-026-000 Miscellaneous Expenses Totals: 148.98 1,404.26 **
2,000.00 Budgeted 595.74 Remaining 70 % Used
Department 26 Totals: ----------------------------------- 9,227.17 **
3,587.53 Monthly Total 12,980.00 Budgeted 3,752.83 Remaining 71 % Used
July 18, 2018 Regular Meeting Agenda Packet
117 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 6/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
1448 06/01/2018 MUD PR 06.01.18 Salaries & Wages 248,159.41 11,460.10 259,619.51 PR
1548 06/15/2018 MUD PR 06.15.18 Salaries & Wages 11,465.80 271,085.31 PR
1614 06/29/2018 MUD PR 06/29/18 Salaries & Wages 12,426.03 283,511.34 PR
_______________
Account: 135-50005-030-000 Salaries & Wages Totals: 35,351.93 283,511.34 **
432,863.00 Budgeted 149,351.66 Remaining 65 % Used
Account: 135-50010-030-000 Overtime
556.92 .00 556.92
_______________
Account: 135-50010-030-000 Overtime Totals: .00 556.92 **
2,000.00 Budgeted 1,443.08 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
1448 06/01/2018 MUD PR 06.01.18 Retirement 25,641.34 1,060.05 26,701.39 PR
1548 06/15/2018 MUD PR 06.15.18 Retirement 1,060.60 27,761.99 PR
1614 06/29/2018 MUD PR 06/29/18 Retirement 1,149.40 28,911.39 PR
_______________
Account: 135-50020-030-000 Retirement Totals: 3,270.05 28,911.39 **
40,553.00 Budgeted 11,641.61 Remaining 71 % Used
Account: 135-50026-030-000 Medical Insurance
1448 06/01/2018 MUD PR 06.01.18 Medical Insurance 31,483.69 1,777.75 33,261.44 PR
1548 06/15/2018 MUD PR 06.15.18 Medical Insurance 1,777.73 35,039.17 PR
_______________
Account: 135-50026-030-000 Medical Insurance Totals: 3,555.48 35,039.17 **
63,485.00 Budgeted 28,445.83 Remaining 55 % Used
Account: 135-50027-030-000 Dental Insurance
1448 06/01/2018 MUD PR 06.01.18 Dental Insurance 2,271.96 113.20 2,385.16 PR
1548 06/15/2018 MUD PR 06.15.18 Dental Insurance 113.17 2,498.33 PR
July 18, 2018 Regular Meeting Agenda Packet
118 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 6/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-030-000 Dental Insurance Totals: 226.37 2,498.33 **
5,502.00 Budgeted 3,003.67 Remaining 45 % Used
Account: 135-50028-030-000 Vision Insurance
1448 06/01/2018 MUD PR 06.01.18 Vision Insurance 426.43 17.98 444.41 PR
1548 06/15/2018 MUD PR 06.15.18 Vision Insurance 17.94 462.35 PR
_______________
Account: 135-50028-030-000 Vision Insurance Totals: 35.92 462.35 **
1,173.00 Budgeted 710.65 Remaining 39 % Used
Account: 135-50029-030-000 Life Insurance & Other
1459 06/01/2018 June A/P Employee benefits LTD & STD 2,694.84 100.24 2,795.08 METLIFE GROUP BENEFITS 4254 AP
1651 06/29/2018 June A/P Benefits-Café 125 18.00 2,813.08 BenefitMall 4319 AP
_______________
Account: 135-50029-030-000 Life Insurance & Other Totals: 118.24 2,813.08 **
5,059.00 Budgeted 2,245.92 Remaining 56 % Used
Account: 135-50030-030-000 Social Security Taxes
1448 06/01/2018 MUD PR 06.01.18 Social Security Taxes 15,024.46 672.30 15,696.76 PR
1548 06/15/2018 MUD PR 06.15.18 Social Security Taxes 670.23 16,366.99 PR
1614 06/29/2018 MUD PR 06/29/18 Social Security Taxes 770.42 17,137.41 PR
_______________
Account: 135-50030-030-000 Social Security Taxes Totals: 2,112.95 17,137.41 **
27,181.00 Budgeted 10,043.59 Remaining 63 % Used
Account: 135-50035-030-000 Medicare Taxes
1448 06/01/2018 MUD PR 06.01.18 Medicare Taxes 3,513.78 157.23 3,671.01 PR
1548 06/15/2018 MUD PR 06.15.18 Medicare Taxes 156.74 3,827.75 PR
1614 06/29/2018 MUD PR 06/29/18 Medicare Taxes 180.17 4,007.92 PR
_______________
Account: 135-50035-030-000 Medicare Taxes Totals: 494.14 4,007.92 **
6,357.00 Budgeted 2,349.08 Remaining 63 % Used
Account: 135-50040-030-000 Unemployment Taxes
1614 06/29/2018 MUD PR 06/29/18 Unemployment Taxes 983.77 17.31 1,001.08 PR
_______________
Account: 135-50040-030-000 Unemployment Taxes Totals: 17.31 1,001.08 **
1,260.00 Budgeted 258.92 Remaining 79 % Used
July 18, 2018 Regular Meeting Agenda Packet
119 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 34
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 6/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
240 06/01/2018 Insurance/Wrk Comp Exp Jun 988.00 123.50 1,111.50 GL
_______________
Account: 135-50045-030-000 Workman's Compensation Totals: 123.50 1,111.50 **
1,529.00 Budgeted 417.50 Remaining 73 % Used
Account: 135-50060-030-000 Pre-emp Physicals/Testing
1681 06/30/2018 June A/P New hire-Desiree 124.95 86.95 211.90 FIRST CHECK APPLICANT SCREENIN 4332 AP
_______________
Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: 86.95 211.90 **
500.00 Budgeted 288.10 Remaining 42 % Used
Account: 135-50070-030-000 Employee Relations
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 KIM S DONUTS 3,109.08 38.10 3,147.18 KIM S DONUTS PC
_______________
Account: 135-50070-030-000 Employee Relations Totals: 38.10 3,147.18 **
4,960.00 Budgeted 1,812.82 Remaining 63 % Used
Account: 135-55030-030-000 Software & Support
1459 06/01/2018 June A/P annual maintenance-Remitplus 59,433.04 1,856.58 61,289.62 JACK HENRY & ASSOC, INC 4246 AP
1591 06/21/2018 June A/P Final internet bill (5/1-5/10) 346.55 61,636.17 WHOLESALE CARRIER SERVICES INC 4306 AP
1591 06/21/2018 June A/P Email, MS office 456.00 62,092.17 M3 Networks 4293 AP
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 DNH*GODADDY.COM 39.34 62,131.51 DNH*GODADDY.COM PC
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 ATT*BILL PAYMENT 85.71 62,217.22 ATT*BILL PAYMENT PC
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 ATT*BILL PAYMENT 124.34 62,341.56 ATT*BILL PAYMENT PC
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 ATT*BILL PAYMENT 107.79 62,449.35 ATT*BILL PAYMENT PC
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 ADOBE SYSTEMS INC 16.23 62,465.58 ADOBE SYSTEMS INC PC
_______________
Account: 135-55030-030-000 Software & Support Totals: 3,032.54 62,465.58 **
78,391.00 Budgeted 15,925.42 Remaining 80 % Used
Account: 135-55070-030-000 Independent Labor
1692 06/29/2018 June A/P June GM 101,827.93 11,850.00 113,677.93 Carman Consulting LLC. 4321 AP
1692 06/29/2018 June A/P June GM 22.89 113,700.82 Carman Consulting LLC. 4321 AP
_______________
Account: 135-55070-030-000 Independent Labor Totals: 11,872.89 113,700.82 **
154,000.00 Budgeted 40,299.18 Remaining 74 % Used
Account: 135-55080-030-000 Maintenance & Repairs
July 18, 2018 Regular Meeting Agenda Packet
120 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 35
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 6/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
5,160.69 .00 5,160.69
_______________
Account: 135-55080-030-000 Maintenance & Repairs Totals: .00 5,160.69 **
14,000.00 Budgeted 8,839.31 Remaining 37 % Used
Account: 135-55085-030-000 Generator Maint. and Repair
1591 06/21/2018 June A/P office generator repair 3,955.00 669.58 4,624.58 Sluder Emergency Power Service 4297 AP
_______________
Account: 135-55085-030-000 Generator Maint. and Repair Totals: 669.58 4,624.58 **
10,000.00 Budgeted 5,375.42 Remaining 46 % Used
Account: 135-55120-030-000 Cleaning Services
1600 06/22/2018 June A/P Janitorial service 5,700.51 869.06 6,569.57 MEMBER'S BUILDING MAINTENANCE 4311 AP
_______________
Account: 135-55120-030-000 Cleaning Services Totals: 869.06 6,569.57 **
10,000.00 Budgeted 3,430.43 Remaining 66 % Used
Account: 135-55160-030-000 Professional Outside Services
59,240.00 .00 59,240.00
_______________
Account: 135-55160-030-000 Professional Outside Services Totals: .00 59,240.00 **
63,325.00 Budgeted 4,085.00 Remaining 94 % 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
1681 06/30/2018 June A/P June Billings 4,705.92 1,001.44 5,707.36 DATAPROSE LLC 4327 AP
_______________
Account: 135-55205-030-000 Utility Billing Contract Totals: 1,001.44 5,707.36 **
9,000.00 Budgeted 3,292.64 Remaining 63 % Used
Account: 135-60005-030-000 Telephone
1587 06/21/2018 June A/P Answering service 11,857.33 207.75 12,065.08 KEYSTONE PARK SECRETARIAL 4291 AP
July 18, 2018 Regular Meeting Agenda Packet
121 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 6/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 ATT*BILL PAYMENT 11,857.33 190.78 12,255.86 ATT*BILL PAYMENT PC
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 RINGCENTRAL, INC 13.95 12,269.81 RINGCENTRAL, INC PC
1644 06/30/2018 Town Billed Invoice# 1644-1647 AR 20180630-20180630 User: (180.00) 12,089.81 AR
_______________
Account: 135-60005-030-000 Telephone Totals: 232.48 12,089.81 **
27,300.00 Budgeted 15,210.19 Remaining 44 % Used
Account: 135-60010-030-000 Communications/Mobiles
1548 06/15/2018 MUD PR 06.15.18 Communications/Mobiles 2,036.80 150.00 2,186.80 PR
1591 06/21/2018 June A/P Cell phones 87.37 2,274.17 VERIZON WIRELESS 4302 AP
_______________
Account: 135-60010-030-000 Communications/Mobiles Totals: 237.37 2,274.17 **
4,000.00 Budgeted 1,725.83 Remaining 57 % Used
Account: 135-60020-030-000 Electricity/Gas
1692 06/29/2018 June A/P 3/9-4/10 & 4/10-5/9 Admin Elec 3,852.21 963.22 4,815.43 TOWN OF TROPHY CLUB 4365 AP
_______________
Account: 135-60020-030-000 Electricity/Gas Totals: 963.22 4,815.43 **
16,261.00 Budgeted 11,445.57 Remaining 30 % Used
Account: 135-60025-030-000 Water
1600 06/22/2018 June A/P May water 339.12 116.64 455.76 TROPHY CLUB MUD (WATER BILLS) 4314 AP
1651 06/29/2018 June A/P June water 136.50 592.26 TROPHY CLUB MUD (WATER BILLS) 4366 AP
1644 06/30/2018 Town Billed Invoice# 1644-1647 AR 20180630-20180630 User: (68.25) 524.01 AR
_______________
Account: 135-60025-030-000 Water Totals: 184.89 524.01 **
2,500.00 Budgeted 1,975.99 Remaining 21 % Used
Account: 135-60030-030-000 Rent And/Or Usage
616.40 .00 616.40
_______________
Account: 135-60030-030-000 Rent And/Or Usage Totals: .00 616.40 **
.00 Budgeted (616.40) Remaining 0 % Used
Account: 135-60035-030-000 Postage
1591 06/21/2018 June A/P overnight-TCEQ 14,557.37 6.93 14,564.30 FEDERAL EXPRESS CORP 4285 AP
1681 06/30/2018 June A/P June Billings 3,015.62 17,579.92 DATAPROSE LLC 4327 AP
July 18, 2018 Regular Meeting Agenda Packet
122 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 37
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 6/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,022.55 17,579.92 **
30,000.00 Budgeted 12,420.08 Remaining 59 % Used
Account: 135-60040-030-000 Service Charges & Fees
1451 06/01/2018 Child Support Fee 38,717.32 1.50 38,718.82 GL
1549 06/15/2018 Child Support Fee 1.50 38,720.32 GL
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 DENTON COUNTY, TX SOUT 2.00 38,722.32 DENTON COUNTY, TX SOUT PC
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 DENTON COUNTY, TX SOUT 1.00 38,723.32 DENTON COUNTY, TX SOUT PC
1615 06/29/2018 Child Support Fee 1.50 38,724.82 GL
1526 06/30/2018 Pace Credit Card Fees 4,801.82 43,526.64 GL
1526 06/30/2018 Pace Credit Card Fees 89.76 43,616.40 GL
_______________
Account: 135-60040-030-000 Service Charges & Fees Totals: 4,899.08 43,616.40 **
55,560.00 Budgeted 11,943.60 Remaining 79 % 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
240 06/01/2018 Insurance/Wrk Comp Exp Jun 52,077.88 6,100.36 58,178.24 GL
1591 06/21/2018 June A/P Director bonds 2018 200.00 58,378.24 VICTOR O SCHINNERER & CO, INC 4303 AP
1591 06/21/2018 June A/P Director Bonds 2019 & 2020 320.00 58,698.24 VICTOR O SCHINNERER & CO, INC 4303 AP
_______________
Account: 135-60055-030-000 Insurance Totals: 6,620.36 58,698.24 **
56,000.00 Budgeted (2,698.24) Remaining 105 % Used
Account: 135-60066-030-000 Publications/Books/Subscripts
206.38 .00 206.38
_______________
Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 206.38 **
1,600.00 Budgeted 1,393.62 Remaining 13 % Used
Account: 135-60070-030-000 Dues & Memberships
3,828.42 .00 3,828.42
July 18, 2018 Regular Meeting Agenda Packet
123 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 6/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-030-000 Dues & Memberships Totals: .00 3,828.42 **
6,000.00 Budgeted 2,171.58 Remaining 64 % Used
Account: 135-60075-030-000 Meetings
80.50 .00 80.50
_______________
Account: 135-60075-030-000 Meetings Totals: .00 80.50 **
400.00 Budgeted 319.50 Remaining 20 % 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,143.00 .00 3,143.00
_______________
Account: 135-60080-030-000 Schools & Training Totals: .00 3,143.00 **
7,600.00 Budgeted 4,457.00 Remaining 41 % Used
Account: 135-60100-030-000 Travel & per diem
1548 06/15/2018 MUD PR 06.15.18 Travel & per diem 843.72 81.53 925.25 PR
1614 06/29/2018 MUD PR 06/29/18 Travel & per diem 33.46 958.71 PR
_______________
Account: 135-60100-030-000 Travel & per diem Totals: 114.99 958.71 **
4,885.00 Budgeted 3,926.29 Remaining 20 % 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
July 18, 2018 Regular Meeting Agenda Packet
124 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 6/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-60115-030-000 Elections Totals: .00 220.00 **
4,500.00 Budgeted 4,280.00 Remaining 5 % Used
Account: 135-60125-030-000 Advertising
150.00 .00 150.00
_______________
Account: 135-60125-030-000 Advertising Totals: .00 150.00 **
2,500.00 Budgeted 2,350.00 Remaining 6 % Used
Account: 135-60235-030-000 Security
1591 06/21/2018 June A/P Panic button monitor 96.00 24.00 120.00 Digital Air Control, Inc 4282 AP
1591 06/21/2018 June A/P Panic button monitor 24.00 144.00 Digital Air Control, Inc 4282 AP
_______________
Account: 135-60235-030-000 Security Totals: 48.00 144.00 **
2,700.00 Budgeted 2,556.00 Remaining 5 % 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
1568 06/01/2018 Comp Study Capital-GM Conting Comp Study- Seagal Waters 17,000.00 17,000.00 GL
_______________
Account: 135-60246-030-000 General Manager Contingency Totals: 17,000.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
273.73 .00 273.73
July 18, 2018 Regular Meeting Agenda Packet
125 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 40
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 6/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-65010-030-000 Uniforms Totals: .00 273.73 **
700.00 Budgeted 426.27 Remaining 39 % Used
Account: 135-65055-030-000 Hardware
2,006.68 .00 2,006.68
_______________
Account: 135-65055-030-000 Hardware Totals: .00 2,006.68 **
7,420.00 Budgeted 5,413.32 Remaining 27 % Used
Account: 135-65085-030-000 Office Supplies
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 KELLER TROPHY & AWAR 3,586.24 50.00 3,636.24 KELLER TROPHY & AWAR PC
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 AMAZON MKTPLACE PMTS 47.07 3,683.31 AMAZON MKTPLACE PMTS PC
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 AMAZON MKTPLACE PMTS 30.60 3,713.91 AMAZON MKTPLACE PMTS PC
1651 06/29/2018 June A/P Office supplies 100.82 3,814.73 OFFICE DEPOT, INC 4354 AP
1651 06/29/2018 June A/P Office supplies 55.79 3,870.52 OFFICE DEPOT, INC 4354 AP
_______________
Account: 135-65085-030-000 Office Supplies Totals: 284.28 3,870.52 **
7,000.00 Budgeted 3,129.48 Remaining 55 % Used
Account: 135-65090-030-000 Printer Supplies & Maintenance
2,048.66 .00 2,048.66
_______________
Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 2,048.66 **
2,000.00 Budgeted (48.66) Remaining 102 % Used
Account: 135-65095-030-000 Maintenance Supplies
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 AMAZON MKTPLACE PMTS 3,267.45 14.96 3,282.41 AMAZON MKTPLACE PMTS PC
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 AMAZON.COM 7.92 3,290.33 AMAZON.COM PC
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 AMAZON MKTPLACE PMTS 95.68 3,386.01 AMAZON MKTPLACE PMTS PC
1682 06/26/2018 Pcard 05/29/18 - 06/26/18 WAL-MART #5247 34.03 3,420.04 WAL-MART #5247 PC
_______________
Account: 135-65095-030-000 Maintenance Supplies Totals: 152.59 3,420.04 **
4,000.00 Budgeted 579.96 Remaining 86 % Used
Account: 135-65105-030-000 Printing
144.00 .00 144.00
July 18, 2018 Regular Meeting Agenda Packet
126 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 6/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-65105-030-000 Printing Totals: .00 144.00 **
4,000.00 Budgeted 3,856.00 Remaining 4 % Used
Account: 135-69005-030-000 Capital Outlays
1568 06/01/2018 Comp Study Capital-GM Conting Comp Study- Seagal Waters 37,327.32 (17,000.00) 20,327.32 GL
1651 06/29/2018 June A/P Second half-Security project 19,527.67 39,854.99 3RD EYE SURVEILLANCE SYSTEMS 4315 AP
1651 06/29/2018 June A/P comp salary survey 8,500.00 48,354.99 Segal Waters Consulting 4359 AP
_______________
Account: 135-69005-030-000 Capital Outlays Totals: 11,027.67 48,354.99 **
13,000.00 Budgeted (35,354.99) Remaining 372 % Used
Account: 135-69170-030-000 Copier Lease Installments
1591 06/21/2018 June A/P copier lease 1,990.55 165.00 2,155.55 EVERBANK COMMERCIAL FINANCE 4284 AP
1651 06/29/2018 June A/P Lease-copies 61.31 2,216.86 KYOCERA DOCUMENT SOLUTIONS 4346 AP
_______________
Account: 135-69170-030-000 Copier Lease Installments Totals: 226.31 2,216.86 **
4,600.00 Budgeted 2,383.14 Remaining 48 % Used
Department 30 Totals: ----------------------------------- 870,043.03 **
107,890.24 Monthly Total 1,227,112.00 Budgeted 357,068.97 Remaining 71 % Used
July 18, 2018 Regular Meeting Agenda Packet
127 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program:
Period Ending: 6/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
1591 06/21/2018 June A/P Legal-Southlake easement 59,261.93 24,306.84 83,568.77 WHITAKER CHALK SWINDLE 4305 AP
1591 06/21/2018 June A/P legal 5,280.00 88,848.77 McLean & Howard, L.L.P. 4294 AP
1591 06/21/2018 June A/P legal travel board 1,050.00 89,898.77 McLean & Howard, L.L.P. 4294 AP
1701 06/30/2018 June A/P Legal 8,250.00 98,148.77 McLean & Howard, L.L.P. 4349 AP
1701 06/30/2018 June A/P Legal 1,050.00 99,198.77 McLean & Howard, L.L.P. 4349 AP
_______________
Account: 135-55045-039-000 Legal Totals: 39,936.84 99,198.77 **
137,000.00 Budgeted 37,801.23 Remaining 72 % 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
8,683.92 .00 8,683.92
_______________
Account: 135-55060-039-000 Appraisal Totals: .00 8,683.92 **
11,446.00 Budgeted 2,762.08 Remaining 76 % 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: ----------------------------------- 136,509.79 **
39,936.84 Monthly Total 176,746.00 Budgeted 40,236.21 Remaining 77 % Used
Fund 135 Totals: ----------------------------------- (1,534,162.39)
(218,645.12) Monthly Total (194,618.00) Budgeted 1,339,544.39 Remaining 788 % Used
July 18, 2018 Regular Meeting Agenda Packet
128 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 43
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 137 MUD 1 Consolidated GASB Department: Program:
Period Ending: 6/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
July 18, 2018 Regular Meeting Agenda Packet
129 of 182
TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION
BALANCE SHEET
JUNE 2018
517
ASSETS
CONSTRUCTION
FUND
CASH IN BANK -
INVESTMENTS -
ACCOUNTS RECEIVABLE -
TOTAL ASSETS -
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES 803,772
TOTAL LIABILITIES 803,772
FUND BALANCE
ASSIGNED FUND BALANCE 992,579
NET REVENUES / EXPENDITURES (1,796,351)
TOTAL FUND BALANCE (803,772)
TOTAL LIABILITIES AND FUND BALANCE -
July 18, 2018 Regular Meeting Agenda Packet
130 of 182
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 14
19:44 07/11/18 Budget Summary with Amendment
Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program:
Period Ending: 6/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
July 18, 2018 Regular Meeting Agenda Packet
131 of 182
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 15
19:44 07/11/18 Budget Summary with Amendment
Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program:
Period Ending: 6/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 142,368.99- 343,400.98- 343,400.98
Subtotal: 142,368.99- 343,400.98- 343,400.98
Program number: 142,368.99- 343,400.98- 343,400.98
Department number: Wastewater 142,368.99- 343,400.98- 343,400.98
Revenues Subtotal ----------- 142,368.99- 352,749.14- 352,749.14
July 18, 2018 Regular Meeting Agenda Packet
132 of 182
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 16
19:44 07/11/18 Budget Summary with Amendment
Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program:
Period Ending: 6/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 154.89-
Subtotal: 154.89 154.89 154.89-
517-69005-020-000 Capital Outlays 142,510.23 2,148,945.58 2,148,945.58-
Subtotal: 142,510.23 2,148,945.58 2,148,945.58-
Program number: 142,665.12 2,149,100.47 2,149,100.47-
Department number: Wastewater 142,665.12 2,149,100.47 2,149,100.47-
Expenditures Subtotal ----------- 142,665.12 2,149,100.47 2,149,100.47-
Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 296.13 1,796,351.33 1,796,351.33-
July 18, 2018 Regular Meeting Agenda Packet
133 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 44
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program:
Period Ending: 6/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
July 18, 2018 Regular Meeting Agenda Packet
134 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program:
Period Ending: 6/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
1606 06/30/2018 Texpool Transfers June (201,031.99) (142,059.21) (343,091.20) GL
1606 06/30/2018 Texpool Transfers June (309.78) (343,400.98) GL
_______________
Account: 517-49141-020-000 Interfund Transfers In Gen Totals: (142,368.99) (343,400.98) **
.00 Budgeted 343,400.98 Remaining 0 % Used
Account: 517-60335-020-000 Intergov Transfer Out (GF)
1685 06/30/2018 Transfer 517 Pros to 135 Pros $0 out 517 to 135 154.89 154.89 GL
_______________
Account: 517-60335-020-000 Intergov Transfer Out (GF) Totals: 154.89 154.89 **
.00 Budgeted (154.89) Remaining 0 % Used
Account: 517-69005-020-000 Capital Outlays
1591 06/21/2018 June A/P WWTP Improvements 2,006,435.35 22,436.15 2,028,871.50 CP&Y/WALLACE GROUP, INC. 4280 AP
1651 06/29/2018 June A/P WWTP Improvement 112,474.59 2,141,346.09 WEBBER-CADAGUA PARTNERS 4371 AP
1681 06/30/2018 June A/P WWTP Improvements 7,599.49 2,148,945.58 CP&Y/WALLACE GROUP, INC. 4325 AP
_______________
Account: 517-69005-020-000 Capital Outlays Totals: 142,510.23 2,148,945.58 **
.00 Budgeted (2,148,945.58) Remaining 0 % Used
Department 20 Totals: ----------------------------------- 1,805,699.49 **
296.13 Monthly Total .00 Budgeted (1,805,699.49) Remaining 0 % Used
Fund 517 Totals: ----------------------------------- 1,796,351.33
296.13 Monthly Total .00 Budgeted (1,796,351.33) Remaining 0 % Used
July 18, 2018 Regular Meeting Agenda Packet
135 of 182
TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION
SWIFT FUNDING
BALANCE SHEET
JUNE 2018
519
ASSETS
REVENUE BOND
CONSTRUCTION
CASH IN BANK -
CASH IN ESCROW 749,385
INVESTMENTS -
ACCOUNTS RECEIVABLE -
TOTAL ASSETS 749,385
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,489,354)
TOTAL FUND BALANCE 736,227
TOTAL LIABILITIES AND FUND BALANCE 749,385
July 18, 2018 Regular Meeting Agenda Packet
136 of 182
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 17
19:44 07/11/18 Budget Summary with Amendment
Fund: 519 2016 Rev Bond Const-SWIFT Department: Revenues Program:
Period Ending: 6/2018
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
519-49010-000-000 Interest Income 1,534.17- 1,534.17
519-49141-000-000 Interfund Transfer In-Gen Fund 1,053,935.08- 1,053,935.08
Subtotal: 1,055,469.25- 1,055,469.25
Program number: 1,055,469.25- 1,055,469.25
Department number: Revenues 1,055,469.25- 1,055,469.25
Revenues Subtotal ----------- 1,055,469.25- 1,055,469.25
July 18, 2018 Regular Meeting Agenda Packet
137 of 182
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 18
19:44 07/11/18 Budget Summary with Amendment
Fund: 519 2016 Rev Bond Const-SWIFT Department: 10 Water Program:
Period Ending: 6/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,484.87 1,851,614.33 1,851,614.33-
Subtotal: 1,484.87 1,851,614.33 1,851,614.33-
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,484.87 4,544,823.01 4,544,823.01-
Department number: Water 1,484.87 4,544,823.01 4,544,823.01-
Expenditures Subtotal ----------- 1,484.87 4,544,823.01 4,544,823.01-
Fund number: 519 2016 Rev Bond Const-SWIFT 1,484.87 3,489,353.76 3,489,353.76-
July 18, 2018 Regular Meeting Agenda Packet
138 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 519 2016 Rev Bond Const-SWIFT Department: Revenues Program:
Period Ending: 6/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
(1,534.17) .00 (1,534.17)
_______________
Account: 519-49010-000-000 Interest Income Totals: .00 (1,534.17) **
.00 Budgeted 1,534.17 Remaining 0 % Used
Account: 519-49141-000-000 Interfund Transfer In-Gen Fund
(1,053,935.08) .00 (1,053,935.08)
_______________
Account: 519-49141-000-000 Interfund Transfer In-Gen Fund Totals: .00 (1,053,935.08) **
.00 Budgeted 1,053,935.08 Remaining 0 % Used
Department Totals: ----------------------------------- (1,055,469.25) **
.00 Monthly Total .00 Budgeted 1,055,469.25 Remaining 0 % Used
July 18, 2018 Regular Meeting Agenda Packet
139 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 47
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 519 2016 Rev Bond Const-SWIFT Department: 10 Water Program:
Period Ending: 6/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
1552 06/04/2018 Texpl Tsfr May Int 519 to 135 1,850,129.46 1,484.87 1,851,614.33 GL
_______________
Account: 519-60334-010-000 Interfund Transfer Out Totals: 1,484.87 1,851,614.33 **
.00 Budgeted (1,851,614.33) 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: ----------------------------------- 4,544,823.01 **
1,484.87 Monthly Total .00 Budgeted (4,544,823.01) Remaining 0 % Used
Fund 519 Totals: ----------------------------------- 3,489,353.76
1,484.87 Monthly Total .00 Budgeted (3,489,353.76) Remaining 0 % Used
July 18, 2018 Regular Meeting Agenda Packet
140 of 182
TROPHY CLUB MUD #1 - 16" WATERLINE FUTURE REVENUE BOND
BALANCE SHEET
JUNE 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 39,899
TOTAL LIABILITIES 39,899
FUND BALANCE
ASSIGNED FUND BALANCE (39,899)
NET REVENUES / EXPENDITURES -
TOTAL FUND BALANCE (39,899)
TOTAL LIABILITIES AND FUND BALANCE 0
July 18, 2018 Regular Meeting Agenda Packet
141 of 182
TROPHY CLUB MUD #1 - REVENUE BOND RESERVE
BALANCE SHEET
JUNE 2018
528
ASSETS
REVENUE BOND
RESERVE
CASH IN BANK -
INVESTMENTS 561,007
ACCOUNTS RECEIVABLE -
TOTAL ASSETS 561,007
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES -
TOTAL LIABILITIES -
FUND BALANCE
ASSIGNED FUND BALANCE 426,578
NET REVENUES / EXPENDITURES 134,429
TOTAL FUND BALANCE 561,007
TOTAL LIABILITIES AND FUND BALANCE 561,007
July 18, 2018 Regular Meeting Agenda Packet
142 of 182
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 19
19:44 07/11/18 Budget Summary with Amendment
Fund: 528 2015 Revenue Bond Reserve Fund Department: Program:
Period Ending: 6/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- 814.67- 5,179.61- 517.961 4,179.61
528-49142-000-000 Interfund transfer in-Water 48,996.00- 48,996.00- 4,098.00- 36,747.00- 75.000 12,249.00-
528-49143-000-000 Interfund transfer in-WW 123,336.00- 123,336.00- 10,308.00- 92,502.00- 75.000 30,834.00-
Subtotal: 173,332.00- 173,332.00- 15,220.67- 134,428.61- 77.556 38,903.39-
Program number: 173,332.00- 173,332.00- 15,220.67- 134,428.61- 77.556 38,903.39-
Department number: 173,332.00- 173,332.00- 15,220.67- 134,428.61- 77.556 38,903.39-
Revenues Subtotal ----------- 173,332.00- 173,332.00- 15,220.67- 134,428.61- 77.556 38,903.39-
Fund number: 528 2015 Revenue Bond Reserve Fund 173,332.00- 173,332.00- 15,220.67- 134,428.61- 77.556 38,903.39-
July 18, 2018 Regular Meeting Agenda Packet
143 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 48
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 528 2015 Revenue Bond Reserve Fund Department: Program:
Period Ending: 6/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
1684 06/30/2018 Bank Interest- June (4,364.94) (814.67) (5,179.61) GL
_______________
Account: 528-49010-000-000 Interest Income Totals: (814.67) (5,179.61) **
(1,000.00) Budgeted 4,179.61 Remaining 518 % Used
Account: 528-49142-000-000 Interfund transfer in-Water
1626 06/28/2018 TexPl Trsfr Corr June Catch-up TexPool shorted transfr JE1519 (32,649.00) (15.00) (32,664.00) GL
1606 06/30/2018 Texpool Transfers June (4,083.00) (36,747.00) GL
_______________
Account: 528-49142-000-000 Interfund transfer in-Water Totals: (4,098.00) (36,747.00) **
(48,996.00) Budgeted (12,249.00) Remaining 75 % Used
Account: 528-49143-000-000 Interfund transfer in-WW
1626 06/28/2018 TexPl Trsfr Corr June Catch-up TexPool shorted transfr JE1519 (82,194.00) (30.00) (82,224.00) GL
1606 06/30/2018 Texpool Transfers June (10,278.00) (92,502.00) GL
_______________
Account: 528-49143-000-000 Interfund transfer in-WW Totals: (10,308.00) (92,502.00) **
(123,336.00) Budgeted (30,834.00) Remaining 75 % Used
Department Totals: ----------------------------------- (134,428.61) **
(15,220.67) Monthly Total (173,332.00) Budgeted (38,903.39) Remaining 78 % Used
Fund 528 Totals: ----------------------------------- (134,428.61)
(15,220.67) Monthly Total (173,332.00) Budgeted (38,903.39) Remaining 78 % Used
July 18, 2018 Regular Meeting Agenda Packet
144 of 182
TROPHY CLUB MUD #1 - I&S
BALANCE SHEET
JUNE 2018
INTEREST &
SINKING- 533
ASSETS
CASH IN BANK 4,573
INVESTMENTS 888,505
PREPAID EXPENSES -
ADVALOREM PROPERTY TAXES RECEIVABLE 12,199
ACCOUNTS RECEIVABLE-OTHER -
TOTAL ASSETS 905,276
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 12,199
ACCOUNTS AND OTHER PAYABLES -
TOTAL LIABILITIES 12,199
FUND BALANCE
ASSIGNED FUND BALANCE 32,341
NET REVENUES / EXPENDITURES 860,737
TOTAL FUND BALANCE 893,077
TOTAL LIABILITIES AND FUND BALANCE 905,276
July 18, 2018 Regular Meeting Agenda Packet
145 of 182
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 20
19:44 07/11/18 Budget Summary with Amendment
Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program:
Period Ending: 6/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- 2,405.60- 674,318.61- 100.696 4,658.61
533-40002-000-000 Property Taxes/Delinquent 1,800.00- 1,800.00- 11.24- 2,597.59- 144.311 797.59
533-40015-000-000 Property Taxes/P & I 2,000.00- 2,000.00- 115.99- 1,911.39- 95.570 88.61-
Subtotal: 673,460.00- 673,460.00- 2,532.83- 678,827.59- 100.797 5,367.59
533-49010-000-000 Interest Income 2,000.00- 2,000.00- 1,304.34- 6,305.39- 315.270 4,305.39
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- 11,094.81- 99,853.29- 81.818 22,189.71-
Subtotal: 342,997.00- 342,997.00- 12,399.15- 325,112.68- 94.786 17,884.32-
Program number: 1,016,457.00- 1,016,457.00- 14,931.98- 1,003,940.27- 98.769 12,516.73-
Department number: Revenues 1,016,457.00- 1,016,457.00- 14,931.98- 1,003,940.27- 98.769 12,516.73-
Revenues Subtotal ----------- 1,016,457.00- 1,016,457.00- 14,931.98- 1,003,940.27- 98.769 12,516.73-
July 18, 2018 Regular Meeting Agenda Packet
146 of 182
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 21
19:44 07/11/18 Budget Summary with Amendment
Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program:
Period Ending: 6/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 1,450.00 67.442 700.00
533-70025-051-000 Bond Interest Expense-Tax 283,508.00 283,508.00 141,753.75 50.000 141,754.25
533-70035-051-000 Bond Principal Payment-Tax 725,000.00 725,000.00 725,000.00
Subtotal: 1,010,658.00 1,010,658.00 143,203.75 14.169 867,454.25
Program number: 1,010,658.00 1,010,658.00 143,203.75 14.169 867,454.25
Department number: Administration 1,010,658.00 1,010,658.00 143,203.75 14.169 867,454.25
Expenditures Subtotal ----------- 1,010,658.00 1,010,658.00 143,203.75 14.169 867,454.25
Fund number: 533 MUD 1 I&S Consolidated 5,799.00- 5,799.00- 14,931.98- 860,736.52- ############### 854,937.52
July 18, 2018 Regular Meeting Agenda Packet
147 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program:
Period Ending: 6/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
1664 06/01/2018 Property Taxes (671,913.01) (328.54) (672,241.55) GL
1665 06/04/2018 Property Taxes (518.31) (672,759.86) GL
1666 06/05/2018 Property Taxes (35.21) (672,795.07) GL
1667 06/07/2018 Property Taxes (660.87) (673,455.94) GL
1668 06/11/2018 Property Taxes (117.81) (673,573.75) GL
1669 06/12/2018 Property Taxes (8.01) (673,581.76) GL
1670 06/13/2018 Property Taxes (643.16) (674,224.92) GL
1671 06/15/2018 Property Taxes (12.65) (674,237.57) GL
1672 06/18/2018 Property Taxes (23.15) (674,260.72) GL
1673 06/19/2018 Property Taxes (44.41) (674,305.13) GL
1674 06/21/2018 Property Taxes (2.69) (674,307.82) GL
1675 06/22/2018 Property Taxes (7.85) (674,315.67) GL
1676 06/25/2018 Property Taxes (13.25) (674,328.92) GL
1677 06/26/2018 Property Taxes (22.29) (674,351.21) GL
1678 06/28/2018 Property Taxes (1.21) (674,352.42) GL
1679 06/29/2018 Property Taxes 33.81 (674,318.61) GL
_______________
Account: 533-40000-000-000 Property Taxes Totals: (2,405.60) (674,318.61) **
(669,660.00) Budgeted 4,658.61 Remaining 101 % Used
Account: 533-40002-000-000 Property Taxes/Delinquent
1665 06/04/2018 Property Taxes (2,586.35) (23.34) (2,609.69) GL
1679 06/29/2018 Property Taxes 12.10 (2,597.59) GL
_______________
Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (11.24) (2,597.59) **
(1,800.00) Budgeted 797.59 Remaining 144 % Used
Account: 533-40015-000-000 Property Taxes/P & I
1664 06/01/2018 Property Taxes (1,795.40) (4.89) (1,800.29) GL
1665 06/04/2018 Property Taxes (5.19) (1,805.48) GL
1667 06/07/2018 Property Taxes (82.85) (1,888.33) GL
1668 06/11/2018 Property Taxes (17.67) (1,906.00) GL
1670 06/13/2018 Property Taxes (1.93) (1,907.93) GL
1671 06/15/2018 Property Taxes (1.90) (1,909.83) GL
1677 06/26/2018 Property Taxes (1.56) (1,911.39) GL
_______________
Account: 533-40015-000-000 Property Taxes/P & I Totals: (115.99) (1,911.39) **
(2,000.00) Budgeted (88.61) Remaining 96 % Used
Account: 533-49010-000-000 Interest Income
July 18, 2018 Regular Meeting Agenda Packet
148 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 50
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program:
Period Ending: 6/2018
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
1684 06/30/2018 Bank Interest- June (5,001.05) (1,304.34) (6,305.39) GL
_______________
Account: 533-49010-000-000 Interest Income Totals: (1,304.34) (6,305.39) **
(2,000.00) Budgeted 4,305.39 Remaining 315 % 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
1606 06/30/2018 Texpool Transfers June (88,758.48) (11,094.81) (99,853.29) GL
_______________
Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (11,094.81) (99,853.29) **
(122,043.00) Budgeted (22,189.71) Remaining 82 % Used
Department Totals: ----------------------------------- (1,003,940.27) **
(14,931.98) Monthly Total (1,016,457.00) Budgeted (12,516.73) Remaining 99 % Used
July 18, 2018 Regular Meeting Agenda Packet
149 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 51
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program:
Period Ending: 6/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
1,450.00 .00 1,450.00
_______________
Account: 533-70005-051-000 Paying Agent Fee Totals: .00 1,450.00 **
2,150.00 Budgeted 700.00 Remaining 67 % Used
Account: 533-70025-051-000 Bond Interest Expense-Tax
141,753.75 .00 141,753.75
_______________
Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: .00 141,753.75 **
283,508.00 Budgeted 141,754.25 Remaining 50 % Used
Account: 533-70035-051-000 Bond Principal Payment-Tax
.00 .00
_______________
Account: 533-70035-051-000 Bond Principal Payment-Tax Totals: .00 .00 **
725,000.00 Budgeted 725,000.00 Remaining 0 % Used
Department 51 Totals: ----------------------------------- 143,203.75 **
.00 Monthly Total 1,010,658.00 Budgeted 867,454.25 Remaining 14 % Used
Fund 533 Totals: ----------------------------------- (860,736.52)
(14,931.98) Monthly Total (5,799.00) Budgeted 854,937.52 Remaining ##########
July 18, 2018 Regular Meeting Agenda Packet
150 of 182
TROPHY CLUB MUD #1 - REVENUE BOND I&S
BALANCE SHEET
JUNE 2018
534
ASSETS
REVENUE BOND
I&S
CASH IN BANK -
INVESTMENTS 396,346
ACCOUNTS RECEIVABLE -
TOTAL ASSETS 396,346
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES -
TOTAL LIABILITIES -
FUND BALANCE
ASSIGNED FUND BALANCE 16,210
NET REVENUES / EXPENDITURES 380,136
TOTAL FUND BALANCE 396,346
TOTAL LIABILITIES AND FUND BALANCE 396,346
July 18, 2018 Regular Meeting Agenda Packet
151 of 182
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 22
19:44 07/11/18 Budget Summary with Amendment
Fund: 534 2015 Revenue Bond I&S Department: Revenues Program:
Period Ending: 6/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- 516.68- 2,127.85- 212.785 1,127.85
534-49143-000-000 Interfund Transfer In-WW Sales 598,738.00- 598,738.00- 54,430.72- 489,876.48- 81.818 108,861.52-
Subtotal: 599,738.00- 599,738.00- 54,947.40- 492,004.33- 82.037 107,733.67-
Program number: 599,738.00- 599,738.00- 54,947.40- 492,004.33- 82.037 107,733.67-
Department number: Revenues 599,738.00- 599,738.00- 54,947.40- 492,004.33- 82.037 107,733.67-
Revenues Subtotal ----------- 599,738.00- 599,738.00- 54,947.40- 492,004.33- 82.037 107,733.67-
July 18, 2018 Regular Meeting Agenda Packet
152 of 182
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 23
19:44 07/11/18 Budget Summary with Amendment
Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program:
Period Ending: 6/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 200.00 50.000 200.00
534-70040-051-000 Revenue Bond Interest Expense 223,338.00 223,338.00 111,668.75 50.000 111,669.25
534-70045-051-000 Revenue Bond Principal Expense 375,000.00 375,000.00 375,000.00
Subtotal: 598,738.00 598,738.00 111,868.75 18.684 486,869.25
Program number: 598,738.00 598,738.00 111,868.75 18.684 486,869.25
Department number: Administration 598,738.00 598,738.00 111,868.75 18.684 486,869.25
Expenditures Subtotal ----------- 598,738.00 598,738.00 111,868.75 18.684 486,869.25
Fund number: 534 2015 Revenue Bond I&S 1,000.00- 1,000.00- 54,947.40- 380,135.58- ############### 379,135.58
July 18, 2018 Regular Meeting Agenda Packet
153 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 52
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 534 2015 Revenue Bond I&S Department: Revenues Program:
Period Ending: 6/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
1684 06/30/2018 Bank Interest- June (1,611.17) (516.68) (2,127.85) GL
_______________
Account: 534-49010-000-000 Interest Income Totals: (516.68) (2,127.85) **
(1,000.00) Budgeted 1,127.85 Remaining 213 % Used
Account: 534-49143-000-000 Interfund Transfer In-WW Sales
1606 06/30/2018 Texpool Transfers June (435,445.76) (54,430.72) (489,876.48) GL
_______________
Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (54,430.72) (489,876.48) **
(598,738.00) Budgeted (108,861.52) Remaining 82 % Used
Department Totals: ----------------------------------- (492,004.33) **
(54,947.40) Monthly Total (599,738.00) Budgeted (107,733.67) Remaining 82 % Used
July 18, 2018 Regular Meeting Agenda Packet
154 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 53
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program:
Period Ending: 6/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
200.00 .00 200.00
_______________
Account: 534-70005-051-000 Rev Bond Paying Agent Fee Totals: .00 200.00 **
400.00 Budgeted 200.00 Remaining 50 % Used
Account: 534-70040-051-000 Revenue Bond Interest Expense
111,668.75 .00 111,668.75
_______________
Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: .00 111,668.75 **
223,338.00 Budgeted 111,669.25 Remaining 50 % Used
Account: 534-70045-051-000 Revenue Bond Principal Expense
.00 .00
_______________
Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 **
375,000.00 Budgeted 375,000.00 Remaining 0 % Used
Department 51 Totals: ----------------------------------- 111,868.75 **
.00 Monthly Total 598,738.00 Budgeted 486,869.25 Remaining 19 % Used
Fund 534 Totals: ----------------------------------- (380,135.58)
(54,947.40) Monthly Total (1,000.00) Budgeted 379,135.58 Remaining ##########
July 18, 2018 Regular Meeting Agenda Packet
155 of 182
TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S
BALANCE SHEET
JUNE 2018
535
ASSETS
SWIFT REVENUE
BOND I&S
CASH IN BANK -
INVESTMENTS 197,971
ACCOUNTS RECEIVABLE -
TOTAL ASSETS 197,971
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES -
TOTAL LIABILITIES -
FUND BALANCE
ASSIGNED FUND BALANCE 952
NET REVENUES / EXPENDITURES 197,019
TOTAL FUND BALANCE 197,971
TOTAL LIABILITIES AND FUND BALANCE 197,971
July 18, 2018 Regular Meeting Agenda Packet
156 of 182
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 24
19:44 07/11/18 Budget Summary with Amendment
Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program:
Period Ending: 6/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- 260.62- 1,038.41- 173.068 438.41
535-49142-000-000 Interfund Tran In-Water Sales 278,084.00- 278,084.00- 25,280.31- 227,522.79- 81.818 50,561.21-
Subtotal: 278,684.00- 278,684.00- 25,540.93- 228,561.20- 82.014 50,122.80-
Program number: 278,684.00- 278,684.00- 25,540.93- 228,561.20- 82.014 50,122.80-
Department number: Revenues 278,684.00- 278,684.00- 25,540.93- 228,561.20- 82.014 50,122.80-
Revenues Subtotal ----------- 278,684.00- 278,684.00- 25,540.93- 228,561.20- 82.014 50,122.80-
July 18, 2018 Regular Meeting Agenda Packet
157 of 182
.
glbase_tbam skrolczyk Trophy Club MUD No.1 Page 25
19:44 07/11/18 Budget Summary with Amendment
Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program:
Period Ending: 6/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 200.00 50.000 200.00
535-70040-051-000 Revenue Bond Interest Expense 62,684.00 62,684.00 31,341.75 50.000 31,342.25
535-70045-051-000 Revenue Bond Principal Expense 215,000.00 215,000.00 215,000.00
Subtotal: 278,084.00 278,084.00 31,541.75 11.343 246,542.25
Program number: 278,084.00 278,084.00 31,541.75 11.343 246,542.25
Department number: Administration 278,084.00 278,084.00 31,541.75 11.343 246,542.25
Expenditures Subtotal ----------- 278,084.00 278,084.00 31,541.75 11.343 246,542.25
Fund number: 535 2016 Rev Bond I&S-SWIFT 600.00- 600.00- 25,540.93- 197,019.45- ############### 196,419.45
******* End of Report *********
July 18, 2018 Regular Meeting Agenda Packet
158 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 54
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program:
Period Ending: 6/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
1684 06/30/2018 Bank Interest- June (777.79) (260.62) (1,038.41) GL
_______________
Account: 535-49010-000-000 Interest Income Totals: (260.62) (1,038.41) **
(600.00) Budgeted 438.41 Remaining 173 % Used
Account: 535-49142-000-000 Interfund Tran In-Water Sales
1606 06/30/2018 Texpool Transfers June (202,242.48) (25,280.31) (227,522.79) GL
_______________
Account: 535-49142-000-000 Interfund Tran In-Water Sales Totals: (25,280.31) (227,522.79) **
(278,084.00) Budgeted (50,561.21) Remaining 82 % Used
Department Totals: ----------------------------------- (228,561.20) **
(25,540.93) Monthly Total (278,684.00) Budgeted (50,122.80) Remaining 82 % Used
July 18, 2018 Regular Meeting Agenda Packet
159 of 182
.
glpdatb2 skrolczyk Trophy Club MUD No.1 Page 55
19:45 07/11/18 Detailed Accounting Trial Balance
Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program:
Period Ending: 6/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
200.00 .00 200.00
_______________
Account: 535-70005-051-000 Rev Bond Paying Agent Fee Totals: .00 200.00 **
400.00 Budgeted 200.00 Remaining 50 % Used
Account: 535-70040-051-000 Revenue Bond Interest Expense
31,341.75 .00 31,341.75
_______________
Account: 535-70040-051-000 Revenue Bond Interest Expense Totals: .00 31,341.75 **
62,684.00 Budgeted 31,342.25 Remaining 50 % Used
Account: 535-70045-051-000 Revenue Bond Principal Expense
.00 .00
_______________
Account: 535-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 **
215,000.00 Budgeted 215,000.00 Remaining 0 % Used
Department 51 Totals: ----------------------------------- 31,541.75 **
.00 Monthly Total 278,084.00 Budgeted 246,542.25 Remaining 11 % Used
Fund 535 Totals: ----------------------------------- (197,019.45)
(25,540.93) Monthly Total (600.00) Budgeted 196,419.45 Remaining ##########
Grand Totals: --------------------------------------------------------------------------------------------------------- 1,870,378.22 ****
(228,738.53) Monthly Total (375,349.00) Budgeted (2,245,727.22) Remaining ##########
******* End of Report *********
July 18, 2018 Regular Meeting Agenda Packet
160 of 182
BUDGET VARIANCE REPORT
FUND:122 - Fire O&M
FINANCIALS MONTH:June 2018
REVENUE VARIANCE:66.4%
EXPENSE VARIANCE:84.7%
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 3,788 1,061,756 100.69%10/2017 Property Taxes collected
122-40011 Property Taxes/Fire - Delinquent 17 3,903 10/2017 Delinquent Fire Taxes collected
122-40020 Property Taxes/Fire P&I 183 4,632 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
July 18, 2018 Regular Meeting Agenda Packet
161 of 182
BUDGET VARIANCE REPORT
FUND:135 - MUD 1 O&M
FINANCIALS MONTH:June 2018
REVENUE VARIANCE:66.4%
EXPENSE VARIANCE:84.7%
NOTE:
ACCOUNT DESCRIPTION TOTAL
BUDGET
CURRENT
MONTH
YTD
TOTAL
YTD % DATE OF
COMMENT
VARIANCE EXPLANATION
REVENUE
135-47000-000 Water 6,464,019 746,488 3,886,089 60.12%01/2018 Water Sales
135-47030-000 Service Charges 21,350 1,200 10,600 49.65%01/2018 Service Charges
135-49075 Oversized Meter Reimbursment 18,179 686 11,493 63.22%06/2017 Oversize Meter Reimbursment
EXPENSES
WATER
135-55090-010 Vehicle Maintenance 4,000 323 4,211 105.28%06/2018 Kwik Car, Autozone, Discount
Tire
135-55135-010 Lab Analysis 5,500 280 6,045 109.91%06/2018 Normal Lab Testing
WASTEWATER
135-50010-020 Overtime 30,000 2,688 26,289 87.63%05/2018 WWTP Overtime
135-55090-020 Vehicle Maintenance 8,000 450 6,804 85.05%06/2018 Rey-Mar Weilding Truck
135-55125-020 Dumpster Services 60,000 2,502 57,580 95.97%01/2018 L.H. Chaney- Haul offs
135-60334-020 Interfund Transfer Out 200,000 142,369 343,401 171.70%05/2018 Fund transfer to cover WWTP
Improvement Shortage
135-65035-020 Small Tools 1,000 240 1,390 138.99%06/2018 WWTP Shelving
135-65045-020 Lab Supplies 14,000 2,160 15,644 111.74%06/2018 Lab Supplies
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
July 18, 2018 Regular Meeting Agenda Packet
162 of 182
BUDGET VARIANCE REPORT
FUND:135 - MUD 1 O&M
FINANCIALS MONTH:June 2018
REVENUE VARIANCE:66.4%
EXPENSE VARIANCE:84.7%
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
BOARD OF DIRECTORS
135-60075-026 Meetings 1,200 44 1,259 104.90%06/2018 Special Meeting Food
135-60100-026 Travel & Per Diem 5,000 3,392 4,352 87.05%06/2018 AWBD
ADMINISTRATION
135-60055-030 Insurance 56,000$ 6,620$ 58,698$ 104.82%02/2018 TML WC True-Up Adjustment
FY17
135-60246-030 General Manager Contingency 17,000$ 17,000$ 17,000$ 100.00%06/2018 Seagal Waters- Salary Study
135-65095-030 Maintenance Supplies 4,000$ 153$ 3,420$ 85.50%03/2018 Office Supplies
135-69005-030 Capital Outlays 13,000$ 11,028$ 48,355$ 371.96%06/2018 Security Captial Outlay FY17
Carryover
Non-Departmental
July 18, 2018 Regular Meeting Agenda Packet
163 of 182
STAFF REPORT
Agenda Item: Consider and take appropriate action to set the date and time for a special
meeting budget workshop to review preliminary budget.
Discussion: Staff would like the Board to consider having a Budget Workshop on Monday, July
30th at 6:00 p.m. to review and provide direction to staff regarding the preliminary budget.
July 18, 2018 Regular Meeting Agenda Packet
164 of 182
July 18, 2018 Regular Meeting Agenda Packet165 of 182
July 18, 2018 Regular Meeting Agenda Packet166 of 182
July 18, 2018 Regular Meeting Agenda Packet167 of 182
Trophy Club Municipal Utility District No. 1
Date: 7/16/2018
To: Board of Directors
From: John Robert Carman
Subject: General Manager’s Report
Regulatory Updates
Sanitary Sewer Overflows (SSO) – No SSOs have occurred since the last Board meeting.
Breaks and Leaks – No breaks or leaks have occurred since the last Board meeting
Capital Improvement Projects
Interconnecting Pipeline Project Phase 1 – Contractor has begun boring activities to install the
pipeline under Trophy Club Drive. This has affected one lane of southbound traffic on Trophy
Club Drive in the West lane during construction hours. The contractor for PD 30 has been
actively installing underground infrastructure to support their development which includes
their portion of the Interconnecting Pipeline Project.
Interconnecting Pipeline Project Phase 2 – The most recent alignment for Phase 2 of this
project is on display on the table at the back of the Board Room. The most recent cost estimate
for the project has been modified to meet the request of TCEQ that easement acquisition costs
not be included as a part of the construction costs.
WWTP – Work on Phase 3 of the plant upgrade continues. Contractors have completed
installation of membrane racks in process train # 3. Seeding and startup testing are underway.
July 18, 2018 Regular Meeting Agenda Packet
168 of 182
Installation of the large (40 horsepower) replacement of the pumps at the effluent diversion
structure is complete, and start up was begun on July 10. We should be able to send all our
effluent to the golf course ponds by the time our Board convenes on July 16, 2018.
Joint Projects with Town ‐ The Phoenix Drive waterline is 100% complete. Some meter box
work and a final walk through will be conducted after the road and curb improvements are
complete. The contractor has completed approximately 70% of the road and is working on the
remainder simultaneously with driveway restoration work. Construction on Indian Creek
cannot commence until Phoenix Drive complete.
Fire Department Summary
This month the fire department responded to a total of 75 calls for emergency service, 6 of
which were mutual aid given to other cities. 5 responses were made in Roanoke and 1 was
made in Westlake. Of our total calls we required mutual aid on 3 of them, 2 of which were
possible structure fires and 1 was an EMS call that came in while crews were not yet released
from a previous call. A structure fire was averted as a fire alarm awoke a family at 3 am to
smoke in the home. The department was contacted and our department arrived finding a
bathroom ventilation fan that had overheated and caused a small fire contained to the unit
itself and adjacent insulation. The fire was put out promptly without injury or extensive
July 18, 2018 Regular Meeting Agenda Packet
169 of 182
damage to the home. Training this month consisted of; Cardiac assessment/management,
general patient assessment, pump operations and live active shooter training and scenarios in
Roanoke and Justin Smith attended a 40 hour Driver/Pump Operator state certification
class. The active shooter training was a combined training with Trophy Club, Roanoke and
Westlake and was taught by our Northeast SWAT team members from each city. The training
was excellent and is helping us to learn to communicate and work better with our
partners. The department conducted 2 public education activities making contact with 36
adults and 40 children. Lastly, the department participated in the 4th of July Celebration with
the Town of Trophy Club. This was the first year that the celebration was run like an emergency
event with a command center set up with a representative from all departments
present. There were 2 minor incidents at the event including a transformer fire that made the
lights at the baseball fields inoperable and a small fire at the fireworks launch site that caused
an approximate 12‐14 minute delay in the fireworks program. In all the event was a huge
success and was attended by many of our citizens. If you have any further questions please
contact Fire Chief Wade Carroll.
July 18, 2018 Regular Meeting Agenda Packet
170 of 182
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 587,912
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 648,029
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 0 0 0
2018 MUD 3257 3262 3268 3272 3276 3280 3280 3284 3288
2018 PID 1444 1444 1444 1444 1444 1444 1444 1444 1444
Monthly Water Operations Report
FY 2018
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
October November December January February March April May June July August September
WATER PUMPED IN THOUSANDS OF GALLONS
2014
2015
2016
2017
2018
July 18, 2018 Regular Meeting Agenda Packet
171 of 182
Influent EffluentInfluent EffluentInfluent Effluent4‐Jun 60 0.2 99.7% 247 2.0 99.2% 215 1.0 99.5%5‐Jun 52.5 0.22 99.6% 150 2.0 98.7% 222 1.0 99.5% 11‐Jun 42.2 0.3 99.3% 333 2.0 99.4% 228 1.0 99.6%12‐Jun 52.5 0.20 99.6% 211 2.0 99.1% 208 1.0 99.5% 18‐Jun 35.2 0.20 99.4% 180 2.0 98.9% 198 1.0 99.5%19‐Jun 35 0.20 99.4% 162 2.0 98.8% 250 1.0 99.6% 25‐Jun 44.8 0.24 99.5% 214 2.0 99.1% 248 1.0 99.6%26‐Jun 35.5 0.20 99.4% 179 2.0 98.9% 248 1.0 99.6%99.5%99.0%99.6%2.01.0Ammonia‐NCBOD5TSSDate% Removal% Removal% RemovalReportJune 2018 ResultsAmmonia‐NCBOD5TSS0.22July 18, 2018 Regular Meeting Agenda Packet172 of 182
Max mg/L0.49Aver mg/L0.297Max mg/L2.0Aver mg/L2.0Ammonia NitrogenCarbonaceous Biochemical Demand (CBOD5)0.210.3300.4900.2510.2800.22000.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.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 LimitJuly 18, 2018 Regular Meeting Agenda Packet173 of 182
Max mg/L1.04Aver mg/L1.0Max mg/L8.8Aver mg/L5.3Total Suspended Solids (TSS)Nitrate - Nitrogen1.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.80.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 LimitJuly 18, 2018 Regular Meeting Agenda Packet174 of 182
Max mg/L5.0Aver mg/L2.3Max mg/L7.7Min mg/L7.2Aver mg/L7.3Potential for Hydrogen (pH)E. Coli1.04.01.05.02.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.37.47.47.37.67.70.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 MaxJuly 18, 2018 Regular Meeting Agenda Packet175 of 182
Max mg/L7.8Aver mg/L7.6 Dissolved Oxygen (DO)7.87.57.87.67.47.40.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 LimitJuly 18, 2018 Regular Meeting Agenda Packet176 of 182
October November December January February March April May June July August September
ebills 796 828 829 834 839 844 841 849 848
Bills Mailed 3906 3900 3912 3911 3908 3913 3921 3935 3956
Bank Draft 631 623 639 653 657 656 655 654 660
Credit Card Draft 1018 1020 1026 1033 1042 1056 1054 1056 1067
Online Payments 1037 1079 1,072 1,065 1,086 1,097 1,019 1,080 1,084
Late Notices 391 420 457 362 424 407 299 355 413
Disconnects 25 27 27 25 22 27 24 17 20
M 3257 3262 3268 3272 3276 3280 3280 3284 3288
Connections P 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
July 18, 2018 Regular Meeting Agenda Packet
177 of 182
MUD Permits
Month: June 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
6/4/2018 2018-0027 75.00$ 1,173.00$ 343.00$ 150.00$ 50.00$ 1,791.00$
6/4/2018 2018-0033 75.00$ 1,173.00$ 343.00$ 150.00$ 50.00$ 1,791.00$
6/6/2018 2018-0034 75.00$ 1,173.00$ 343.00$ 150.00$ 50.00$ 1,791.00$
Total 225.00$ 3,519.00$ 1,029.00$ 450.00$ 150.00$ -$ -$ 5,373.00$
July 18, 2018 Regular Meeting Agenda Packet
178 of 182
135-10154 Bank of the West-THB (X6718) 3 yr CD $0 $0 $0
135-10175 Bank of the West MMA (XXX6372) General Fund Operating $0 $715,223 $715,223
135-10250 TexPool O & M (XXXXX0002)-General Fund Operating ***$0 $2,261,972 $2,261,972
135-10300 Prosperity Bank (XXX8701) General Fund Operating *$315,985 $1,362,938 $1,678,923
135-10305 Prosperity Bank Reserve-Savings Acct (XXXXX7724)$782,658 $0 $782,658
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)$749,385 $0 $749,385
528-10250 TexPool Revenue Bond Reserve (XXXXX014) WWTP Improvements $561,007 $0 $561,007
533-10250 TexPool Tax I & S (XXXXX0003)$888,505 $0 $888,505
533-10300 Prosperity Bank (XXX8701) Tax I&S $4,573 $0 $4,573
534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements $396,346 $0 $396,346
535-10250 Texpool Revenue I & S (XXXXX017) SWIFT $197,971 $0 $197,971
$4,492,855 $4,340,733 $8,833,587
Amount available in cash (MUD Accounts)$4,340,733
Amount available for spending (MUD Accounts)$4,340,733
* 06/30/18 Customer Water Deposits $315,985
122-10250 TexPool O & M (XXXXX0002)-Fire Operating Cash $0 $691,610 $691,610
122-10300 Prosperity Bank (XXX8701) Fire Operating $0 $60,743 $60,743
$0 $752,352 $752,352
Amount available in cash (Fire Department Accounts)$752,352
Amount available for spending (Fire Department Accounts)$752,352
715,223$ Bank of the West MM
1,362,938$ Prosperity General Fund
2,261,972$ Texpool General Fund
600$ Petty Cash
Total General Fund 135 Available for Spending 4,340,733$
Nonspendable Fund Balance (Prepaids)3,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 1,534,162$
Total Nonspendable, Assigned & Committed Fund Balances - General Fund 135 $5,684,530
General Fund 135 Available
General Fund 135 Fund Balances
Fire Department Cash
CASH STATUS AS OF JUNE 2018 Restricted -
Unable to be spent
Unrestricted-
Available for
spending
Total in Accounts
(Restricted &
Unrestricted)
July 18, 2018 Regular Meeting Agenda Packet
179 of 182
July 18, 2018 Regular Meeting Agenda Packet180 of 182
July 18, 2018 Regular Meeting Agenda Packet181 of 182
July 18, 2018 Regular Meeting Agenda Packet182 of 182