Loading...
HomeMy WebLinkAbout2018-0618 June 18 2018 Regular Meeting Packet        BOARD OF DIRECTORS  REGULAR MEETING   TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1  100 MUNICIPAL DRIVE  TROPHY CLUB, TEXAS 76262    Monday, June 18, 2018                                               6:30 P.M.                                     Svore Municipal Boardroom   REGULAR MEETING AGENDA   CALL TO ORDER AND ANNOUNCE A QUORUM   CITIZEN COMMENTS  This is an opportunity for citizens to address the Board on any matter whether or not it is posted on the agenda.  The Board is not permitted to take action on or discuss any 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. May 2018 Check Register  b. May 15, 2018 Regular Meeting Minutes  c. June 7, 2018 Special Meeting Minutes    Attachments: May 2018 Check Register    May 15, 2018 Regular Meeting Minutes    June 7, 2018 Special Meeting Minutes  REGULAR SESSION  2. Consider and take appropriate action to Appoint Alternate Member to Wholesale Customer Advisory  Committee for the City of Fort Worth.    Attachment:  Appointment Form    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)    4. Consider and take appropriate action regarding adoption of Resolution No. 2018‐0618A Authorizing the  General Manager to Approve Construction Contract Change Orders. (Staff)    Attachment: Resolution No 2018‐0618A    5. Consider and take appropriate action to adopt Order No. 2018‐0618A Approving a Public Presentations  Policy. (Rose/Flynn)  June 18, 2018 Regular Meeting Agenda Packet 1 of 150       Attachment: Order No. 2018‐0618A    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)    Attachment: Order No. 2018‐0618B    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)    Attachment: Change Order No. 15    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.            Attachment: Independent Contractor Agreement    9. Consider and take appropriate action regarding the May 2018 Combined Financials and Variance Report.   a. Combined Financials   b. Combined Variance     Attachment: Combined Financials                          Combined Variance    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    11. Consider and take appropriate action regarding Director Workshop Meeting. (Flynn/Rose)    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  June 18, 2018 Regular Meeting Agenda Packet 2 of 150     e. Wastewater System Operation  f. Finance Update   Utility Billing Report   Permits Collected   Cash Report    Attachments: General Manager Report         Water Operations Report         Wastewater Operations Report         Utility Billing Report         Permits Collected         Cash Report    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  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  16. Consider and take appropriate action on matters deliberated in Executive Session:    17. Items for future agendas:     18. Set future Meeting dates – Next Regular Meeting – Monday, July 16, 2018 at 6:30 p.m.                                                    Budget Workshop Special Meeting ‐            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 CLOSED SESSION.  THIS NOTICE MODIFIES  THE DISTRICT'S PRIOR PRACTICE OF SPECIFICALLY IDENTIFYING ALL AGENDA ITEMS TO BE DISCUSSED IN  June 18, 2018 Regular Meeting Agenda Packet 3 of 150     EXECUTIVE SESSION.   ADJOURN    THE STATE OF TEXAS §   COUNTIES OF DENTON AND TARRANT  §    THIS NOTICE CERTIFIES THAT BY 6:30 P.M. ON THURSDAY, JUNE 14, 2018, THE AGENDA OF TROPHY CLUB  MUNICIPAL UTILITY DISTRICT NO. 1, BOARD OF DIRECTORS REGULAR MEETING TO BE HELD ON MONDAY,  JUNE 18, 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  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                June 18, 2018 Regular Meeting Agenda Packet 4 of 150 June 18, 2018 Regular Meeting Agenda Packet 5 of 150 June 18, 2018 Regular Meeting Agenda Packet 6 of 150 June 18, 2018 Regular Meeting Agenda Packet 7 of 150 June 18, 2018 Regular Meeting Agenda Packet 8 of 150 June 18, 2018 Regular Meeting Agenda Packet 9 of 150 June 18, 2018 Regular Meeting Agenda Packet 10 of 150     REGULAR MEETING MINUTES   TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1  BOARD OF DIRECTORS   May 15, 2018 at 6:30 P.M.  100 Municipal Drive, Trophy Club, Texas 76262    Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in a 2018  at 6:30 P.M., in the Boardroom of the Administration Building, 100 Municipal Drive, Trophy Club, Texas  76262. The meeting was held within the boundaries of the District, and was open to the public.    STATE OF TEXAS                             §  COUNTIES OF DENTON AND TARRANT           §    BOARD MEMBERS PRESENT:  Kevin R. Carr  President  Gregory Wilson  Vice President  William C. Rose  Secretary/Treasurer  Jim Thomas  Director  Jim Hase  Director  Kelly Castonguay  Director  Steve Flynn  Director  Mark Chapman  Director    BOARD MEMBERS ABSENT:   Jim Thomas  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 Carr announced the date of May 15, 2018, called the meeting to order and announced a quorum  present at 6:30 p.m.    CITIZEN COMMENTS  1. Consider and take appropriate action to approve the Consent Age nda.   a. April 2018 Check Register  b. April 17, 2018 Regular Meeting Minutes  c. May 3, 2018 Special Meeting Minutes    Motion  made  by  Director  Carr  and  seconded  by  Director  Rose  to  approve  the  Consent  Agenda  as  presented.     Motion carried unanimously    June 18, 2018 Regular Meeting Agenda Packet 11 of 150     REGULAR SESSION  2.   Consider and take appropriate action to administer the oath of office, statement of officers, execute  bonds, and take other such actions as necessary for Directors to qualify for office.    Kelly Castonguay executed the Statement of Officer, was administered the Oath of Office by District Secretary  Laurie Slaght and was seated at Director Place 3.    Stephen J. Flynn executed the Statement of Officer, was administered the Oath of Office by District Secretary  Laurie Slaght and was seated at Director Place 4.    Mark Chapman executed the Statement of Officer, was administered the Oath of Office by District Secretary  Laurie Slaght and was seated at Director Place 5.    Motion made by Director Wilson and seconded by Director Carr to approve the Statement of Officer, Oaths  of Office and executed Director Bond and otherwise find that the newly elected Directors have qualified  for office.    Motion carried unanimously    The Board recessed at 6:39 p.m.  and reconvened into Regular Session at 6:50 p.m.    3. Consider and take appropriate action regarding Order No. 2018‐0515 Amending Sections 3.02 and 5.01  of the ByLaws of the Board of Directors relating to Board of Directors’ regular monthly meeting date and  annual election of officers.    Motion made by Director Rose and  seconded  by  Director  Flynn  to adopt  Order  No.  2018‐0515  incorporating amendments to Sections 3.02 and 5.01 of the ByLaws of the Board of Directors.    Motion carried unanimously      4. Consider and take appropriate action to elect officers of the Board of Directors.    Director Rose stated he had questions for Attorney Corbett and requested this item be moved to  Executive Session for legal advice.      Hearing no objections, the item was so moved.      The Board convened into Executive Session at 6:56 p.m.    The Board re‐convened into Regular Session at 7:39 p.m.      Director Flynn nominated Director Wilson to serve as President   For: Castonguay, Chapman, Flynn, Rose and Wilson  Oppose: none  June 18, 2018 Regular Meeting Agenda Packet 12 of 150     Director Wilson will serve as President of the Board of Directors    Director Wilson nominated Director Rose to serve as Vice President  For: Castonguay, Chapman, Flynn, Rose and Wilson  Oppose: none    Director Rose will serve as Vice President of the Board of Directors    Director Castonguay nominated Director Flynn to serve as Secretary/Treasurer  For: Castonguay, Chapman, Flynn, Rose and Wilson  Oppose: none    Director Flynn will serve as Secretary/Treasurer of the Board of Directors      5. Consider and take appropriate action regarding District bank signatories including:  a. Approve Resolution No. 2018‐0515A designating authorized signers on Prosperity Bank accounts.   b. Approve Resolution No. 2018‐0515B designating authorized signers on Bank of the West accounts.  c. Approve Resolution No.  2018‐0515C designating  depository institutions, designating authorized  signatories for the disbursement of District funds, providing for electronic transfers of District funds,  and containing other matters relating thereto.  d. Approve Resolution No. 2018‐0515D designating depository designating authorized signers on  Texpool Accounts.    Motion made by Director Rose and seconded by Director Wilson to approve Resolution No. 2018‐0515A,  Resolution No. 2018‐0515B, Resolution No. 2018‐0515C and Resolution No. 2018‐0515D    Motion carried unanimously      6. Consider and take appropriate action on scheduling meeting for orientation of new directors.    Motion made by Director Rose and seconded by Director Flynn to approve a work session starting at 4  p.m. on Monday June 18th for the purposes of reviewing legal responsibilities and other items as being  associated with being a MUD Director.     Motion carried unanimously      7. Consider and take appropriate action regarding Master Service Agreement for Pipe Cleaning with ACE  Pipe Cleaning.    Motion made by Director Rose and seconded by Director Castonguay to approve the customer master  services agreement with Ace Pipe Cleaning.  June 18, 2018 Regular Meeting Agenda Packet 13 of 150     8. Consider and take appropriate action regarding the April 2018 Combined Financials and Variance Report.   a. Combined Financials   b. Combined Variance     Motion made by Director Rose and seconded by Director Chapman to approve the April 2018 financials  and variance report.    Motion carried unanimously      REPORTS & UPDATES  9. General Manager Monthly Reports and Update:  a. Regulatory Update  b. Draft Change Order Policy  c. Draft Procurement Policy  d. Capital Improvement Projects    16‐inch waterline project to serve Town Center    Wastewater Treatment Plant Upgrade Project   High Service Pump    Joint Projects with Town  e. Water System Operation  f. Wastewater System Operation  g. Website Analytics  h. Finance Update   Utility Billing Report   Permits Collected   Cash Report    General Manager John Carman presented the monthly update to the Board and answered questions  related thereto.     The Board convened into Executive Session at 6:56 p.m.    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).  June 18, 2018 Regular Meeting Agenda Packet 14 of 150     11. Pursuant to Section 551.074 of the Texas Open Meetings Act, the Board may deliberate the appointment,  employment, evaluation, reassignment, duties, discipline, or dismissal of a public officer in Executive  Session.  The Board reconvened into Regular Session at 7:39 p.m.      REGULAR SESSION  12. Consider and take appropriate action on matters deliberated in Executive Session:    Director Wilson stated no action would be taken regarding Executive Session and the Board resumed  discussion on Agenda Item No. 4.    13. Items for future agendas:  June 18th at 4 p.m.    14. Set future Meeting dates – Regular Meeting and Special Meetings     ADJOURN    Motion by Director Rose seconded by Director Castonguay to adjourn the meeting.    Motion carried unanimously      Director Wilson adjourned the meeting at 8:11 p.m.        ______________________________  Gregory Wilson, President                                                                                                   ______________________________                                                   Stephen J. Flynn, Secretary/Treasurer     (SEAL)                               ______________________________  Laurie Slaght, District Secretary      June 18, 2018 Regular Meeting Agenda Packet 15 of 150 SPECIAL MEETING MINUTES   TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1  BOARD OF DIRECTORS   June 7, 2018 at 5:30 P.M.  100 Municipal Drive, Trophy Club, Texas 76262    Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in a  Special Meeting on June 7, 2018 at 5:30 P.M., in the Boardroom of the Administration Building, 100  Municipal Drive, Trophy Club, Texas 76262. The meeting was held within the boundaries of the District,  and was open to the public.    STATE OF TEXAS                            §  COUNTIES OF DENTON AND TARRANT       §    BOARD MEMBERS PRESENT:  Gregory Wilson  President  William C. Rose  Vice President  Steve Flynn  Secretary/Treasurer  Kelly Castonguay  Director  Mark Chapman  Director    BOARD MEMBERS ABSENT:  Mark Chapman  Director    STAFF PRESENT:  John Carman  General Manager  Laurie Slaght  District Secretary    CALL TO ORDER AND ANNOUNCE A QUORUM   President Wilson announced the date of June 7, 2018, announced a quorum present and called the  meeting to order at 5:30 p.m.   CITIZEN COMMENTS  There were no citizen comments    REGULAR SESSION  1.  Consider and take appropriate action regarding approval SCADA modifications, wiring for new pump  panel by DHS Automation, Inc. for Lift Station #2 Project in an amount of $2,600.    Motion by Director Rose and seconded by Director Castonguay to approve the contract with DHS  Automation Inc. for the lift station #2 project for SCADA modifications and wiring for a new pump  panel for an amount not to exceed $2,600.    Motion carried unanimously    ADJOURN      June 18, 2018 Regular Meeting Agenda Packet 16 of 150 Motion made by Director Rose and seconded by Director Flynn to adjourn.    Motion carried unanimously      President Wilson called the meeting adjourned at 5:40 p.m.                    ___________________________  Gregory Wilson, President                                                                                                ____________________________                                                                       (SEAL)  Steven J. Flynn , Secretary/Treasurer                               ____________________________  Laurie Slaght, District Secretary        June 18, 2018 Regular Meeting Agenda Packet 17 of 150 ALTERNATE – WATER APPOINTMENT FORM WHOLESALE CUSTOMER ADVISORY COMMITTEE DATE: ______________ WHOLESALE CUSTOMER: ___________________________________ The following individual has been officially appointed by the CUSTOMER’s GOVERNING BODY, under the terms of the Wholesale Contract for Services, Section 15.1, as the ALTERNATE MEMBER of the Water System Advisory Committee for the Fiscal Year beginning October 1, 2016 through September 30, 2018. ________________________________ ________________________________ Name Mailing Address ________________________________ ________________________________ Title ________________________________ ________________________________ Phone Fax ________________________________ ________________________________ Mobile Phone Pager ________________________________ Email Address ________________________________ Official Seal Mayor/Board President Please complete and return to: WHOLESALE SECTION City of Fort Worth – Water Department 1000 Throckmorton Fort Worth, Texas 76102 Attention: Ceiti Johnson OR Henry Lemlyn 817-392-8422 817-392-8413 June 18, 2018 Regular Meeting Agenda Packet 18 of 150 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 RESOLUTION NO. 2018-0618A A RESOLUTION AUTHORIZING GENERAL MANAGER TO APPROVE CHANGE ORDERS THE STATE OF TEXAS § COUNTIES OF TARRANT AND DENTON § WHEREAS, Trophy Club Municipal Utility District No. 1 (the “District”) is a duly created and existing municipal utility district created and operating under Chapters 49 and 54 of the Texas Water Code, as amended; WHEREAS, Section 49.273(i) of the Texas Water Code provides that the board of directors of a water district may grant authority to an official or employee responsible for administering a contract to approve a change order that involves an increase or decrease of $50,000 or less; WHEREAS, in accordance with the authority of the Texas Water Code and in order to avoid project delays, the Board of Directors desires to grant its General Manager authority to approve certain change orders to contracts for the construction, repair or renovation of District facilities, subject to certain terms and limitations set forth below. NOW THEREFORE, BE IT RESOLVED BY THE BOARD OF DIRECTORS OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 THAT: 1. The facts and recitations found in the preamble of this Resolution are hereby found and declared to be true and correct, and are incorporated by reference herein and expressly made a part hereof, as if copied verbatim. 2. The Board of Directors of the District hereby authorizes its General Manager to approve change orders to contracts for the construction, repair or renovation of District facilities subject to the following terms and limitations: a. The General Manager may not approve any individual change order that exceeds the lesser of the following: (i) $50,000; (ii) 10% of the original contract price; or (iii) the contingency approved by the Board, if any. b. The General Manager may only approve change orders in an amount that when aggregated with all other change orders approved by the General Manager does not exceed $50,000; c. In accordance with the restrictions set forth in Section 49.273(i) of the Texas Water Code, once the aggregate of all change orders for a construction contract increase the original contract price by more than 25 percent, additional change orders may be issued only as a result of unanticipated conditions encountered during construction, repair, or renovation; changes in regulatory criteria; or to facilitate project coordination with other political entities; d. The General Manager may not approve any change order that would extend the date of completion by the project contractor except for weather-related extensions recommended June 18, 2018 Regular Meeting Agenda Packet 19 of 150 for approval by the project engineer; e. The General Manager’s authority shall be exercised only when necessary to prevent project delays that otherwise would be incurred if consideration of the proposed change order was postponed until the next scheduled meeting of the Board of Directors; f. All change order approvals by the General Manager shall be reported to the Board of Directors at its next regular meeting; and g. The General Manager shall not approve any change order that is not recommended for approval by the project engineer. RESOLVED, PASSED AND APPROVED this the ______ day of June 2018. Gregory Wilson, President President, Board of Directors ATTEST: Stephen J. Flynn, Secretary/Treasurer Board of Directors (SEAL) June 18, 2018 Regular Meeting Agenda Packet 20 of 150 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 ORDER NO. 2018-0616A ORDER ADOPTING PUBLIC PRESENTATIONS POLICY STATE OF TEXAS § COUNTIES OF DENTON AND TARRANT § WHEREAS, Section 49.057(g) of the Texas Water Code, as amended, provides that the Board of Directors may adopt rules to govern the affairs of the District; WHEREAS, Section 551.023 of the Open Meetings Act provides that the Board of Directors may adopt reasonable rules to maintain order at their meetings; WHEREAS, the Texas Open Meetings Act provides that a meeting that is “open to the public” under the Act is one that the public is permitted to attend and the Act does not entitle the public to choose the items to be discussed or to speak about items on the agenda; WHEREAS, the Texas Open Meetings Act allows a governmental body to give members of the public an opportunity to speak at a public meeting, and if it does so, it may set reasonable limits on the number, frequency and length of presentations before it, but it may not unfairly discriminate among speakers for or against a particular point of view; WHEREAS, it is the Board of Directors desire to set forth a policy giving members of the public an opportunity to speak at public meetings, NOW, THEREFORE, BE IT ORDERED BY THE BOARD OF DIRECTORS OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO.1, THAT: Section 1. Presentations by citizens or representative(s) of organized groups during citizen comments portion of the agenda. 1) Any citizen wishing to speak or speaking during the citizen comment segment of a board meeting must fill out a “Citizen Comment Form” and file it with the District Secretary. 2) Topics of presentations should be limited to matters over which the Board has authority. 3) Presentations by citizens during the citizens comments segment of a Board of Directors meeting, with or without prior notification, shall be limited to a total of four (4) minutes or as allowed by the presiding officer. 4) If, a member of the public or of the governmental body makes an inquiry about a subject for which notice has not been given, the Boards actions are limited to a) a statement of specific factual information given in response to the inquiry; b) a recitation of existing policy in response to the inquiry; c) respond that the matter shall be placed on a future agenda. Any deliberation of or decision about the subject of the inquiry shall be limited to a proposal to place the subject on the agenda of a subsequent meeting. Section 2. Presentation by citizens or representative(s) of organized groups during agenda items other than citizens comments. 1) Any citizen wishing to speak or speaking must fill out a “Citizen Comment Form” and file it with the District Secretary. June 18, 2018 Regular Meeting Agenda Packet 21 of 150 2) Presentations by citizens, with or without prior notification, shall be limited to a total of six (6) minutes. For items on the agenda, the speaker will be limited to four (4) minutes of time to complete their comments prior to Board discussion and two (2) minutes of time after Board discussion but before the presiding officer calls for a vote. Time limits may be adjusted by the presiding officer. The designated timekeeper shall maintain the time and advise the speaker when their time has expired. The speaker shall then complete his sentence and take their seat. 3) A person may not give their speaking time to another. 4) Persons wishing to express their position on an agenda item but who do not wish to speak shall complete a speaker's form and indicate their support or opposition. The name and respective position of such person(s) shall be read into the record. Section 3. Rules of conduct applicable to citizen' s presentations for agenda items, citizen' s presentations, and for public hearings. 1) Each person addressing the Board shall step up to the microphone, shall give his or her name and address in an audible voice for the record. If representing an organized group, the speaker shall identify the group represented. All remarks shall be addressed to the Board as a body, and not to any member thereof. 2) No person, other than District staff, Directors and the person having the floor, shall be permitted to enter into any discussion, either directly or through the members of the Board. 3) No questions shall be asked of the Board of Directors, except through the presiding officer. 4) All citizens shall refrain from private conversations in the chamber while the Board is in session. 5) Citizens attending Board meetings shall observe the same rules of priority, decorum, and good conduct applicable to the administrative staff. Any persons making personal, impertinent, or slanderous remarks, or who become boisterous while addressing the Board or while attending the Board meeting, shall be asked to remove themselves from the boardroom. If necessary, the presiding officer may direct staff to contact law enforcement to remove the individual(s) from the premises Once removed, that person shall be barred from further attendance before the Board during that session. 6) Unauthorized remarks from the audience, stamping of feet, whistles, yells and similar demonstrations shall not be permitted by the presiding officer. If necessary, the presiding officer, may direct staff to contact law enforcement to remove the individual(s) from the premises. In case the presiding officer shall fail to act, any other Director may move to require the presiding officer to enforce the rules, and the affirmative vote of three Directors present shall require the presiding officer to act. Once removed, that individual(s) shall be barred from further attendance before the Board during that session. 7) No placards, banners or signs of any kind shall be permitted in the Board room unless those exhibits, displays and visual aids are used in presentations to the Board, provided that such exhibits, displays and visuals aids do not disrupt the meeting. Section 4. Written communications to the Board. 1) General. Interested parties, or their authorized representatives, may address the Board by written communication regarding any matter concerning District business or over which the Board has control, at any time. 2) Agenda items. A written communication relative to an item posted for consideration on a District agenda may be submitted by direct mail to the Board or by delivery of the communication to the District Secretary at least four (4) hours prior to the time for commencement of the Board meeting at which an item will be discussed. Upon timely receipt June 18, 2018 Regular Meeting Agenda Packet 22 of 150 of a communication, the District Secretary shall distribute copies to each of the Directors and shall make copies available for public review at a designated location in the Board room. The names of those submitting the communication and the topic addressed will be entered into the record without the necessity of reading the input, provided sufficient copies are available at the meeting for review by members of the public. Order 2014-1204B is hereby repealed in its entirety as of the effective date hereof. This Order shall be effective June 18, 2018. PASSED, ADOPTED, ORDERED AND APPROVED by the Board of Directors of Trophy Club Municipal Utility District No. 1, Trophy Club, Texas this _____ day of ________, 2018. _______________________________ Gregory Wilson, President _______________________________ (SEAL) Stephen J. Flynn, Secretary/Treasurer _______________________________ Laurie Slaght, District Secretary June 18, 2018 Regular Meeting Agenda Packet 23 of 150   TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 ORDER NO. 2018-0618B AN ORDER 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 THE STATE OF TEXAS § COUNTIES OF DENTON AND TARRANT § WHEREAS, Trophy Club Municipal Utility District No. 1 (the “District”) is duly created and existing municipal utility district created and operating under Chapters 49 and 54 of the Texas Water Code, as amended; WHEREAS, the Board of Directors is responsible for the management of District assets and funds; WHEREAS, the Board of Directors desires to institute adequate controls for the safekeeping of District funds yet allow for the timely payment of bills and conduct of District business by the General Manager; WHEREAS, Section 49.151 of the Texas Water Code provides that by Order, the board of directors of a water district may allow its general manager, or other employee of the water district, to sign disbursements; WHEREAS, Section 49.056 of the Texas Water Code provides that the board of directors of a water district may delegate to the general manager full authority to manage and operate the affairs of the district subject only to the orders of the board; and WHEREAS, in accordance with the foregoing statutory authority, the Board of Directors desires to authorize its General Manager to approve expenditures, sign certain disbursements and to enter into contracts for and on behalf of the District subject to certain controls for the safekeeping and protection of public funds. NOW THEREFORE, BE IT ORDERED BY THE BOARD OF DIRECTORS OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 THAT: Section 1. The facts and recitations found in the preamble of this Order are hereby found and declared to be true and correct, and are incorporated by reference herein and expressly made part hereof, as if copied verbatim. Section 2. The Board of Directors hereby adopts the General Manager Purchasing and Contracting Policy in the form attached hereto as Exhibit “A”. Section 3. The attached Policy shall take effect immediately upon adoption of this Order. Section 4. Upon adoption of this Order, the attached Policy supersedes and replaces for all purposes Resolution No. 2014-0715A Authorizing the General Manager to Approve Certain Expenditures, Order No. 2018-0618B GM Expenditure and Contracting Policy 1 of 7 June 18, 2018 Regular Meeting Agenda Packet 24 of 150   Providing for the Disbursement of District Funds, and Containing Other Matters Relating to the Safekeeping of the District Funds. Section 5. The President and Secretary of the Board are hereby authorized and directed to execute this Resolution. After this Resolution is executed, an original Resolution shall be filed in the permanent records of the District. ADOPTED, ORDERERED PASSED AND APPROVED by the Board of Directors of Trophy Club Municipal Utility District No. 1 on this _____ day of ____________________, 2018. ______________________________ Gregory Wilson, President Board of Directors ATTEST: _______________________________ Stephen J. Flynn, Secretary/Treasurer Secretary, Board of Directors              (SEAL)           Laurie Slaght, District Secretary       Order No. 2018-0618B GM Expenditure and Contracting Policy 2 of 7 June 18, 2018 Regular Meeting Agenda Packet 25 of 150   TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 GENERAL MANAGER EXPENDITURE, DISBURSEMENT AND CONTRACTING POLICY I. STATUTORY AUTHORITY 1.01 Statutory Authority. This Policy has been adopted pursuant to the authority set forth in Sections 49.056 and 49.151 of the Texas Water Code, as amended. II. SCOPE 2.01 Scope. This Policy delegates to the General Manager limited authority to expend and disburse funds of the District and to enter into contractual obligations for and on behalf of the District. The Policy establishes limits on the General Manager’s authority. For purposes of this Policy, a “disbursement” is the payment of a liability, debt, accounts payable, or other financial obligation of the District. An “expenditure” represents the approval of a liability, debt or other financial obligation of the District to be discharged by disbursement. III. INTERNAL CONTROLS 3.01 General. The General Manager shall establish, maintain and enforce an internal control structure designed to ensure all District assets and monies are protected from loss, theft, or misuse. The internal controls shall address, without limitation, the following concerns: i. control of collusion; ii. separation of disbursement authority from accounting and record keeping; iii. compliance with the District’s Investment Policy; and iv. written confirmation of telephone transactions for investment and wire transfers of District funds. 3.02 Checkwriting Authority. The General Manager is hereby directed to ensure at all times that signature cards for all district depository accounts contain current information and only the names of those individuals authorized to conduct banking and investment transactions on behalf of the District. III. EXPENDITURE AND DISBURSEMENT AUTHORITY 4.01 Expenditure Authority. a. General Authority. Except as otherwise set forth herein, the General Manager may approve expenditures of District funds in an amount not to exceed $25,000. It is the intent of the Board of Directors that the General Manager’s expenditure authorization shall be exercised Order No. 2018-0618B GM Expenditure and Contracting Policy 3 of 7 June 18, 2018 Regular Meeting Agenda Packet 26 of 150   only for transactions and obligations that do not exceed $25,000 in their entirety, regardless of the number of individual components thereof. b. Limitations on Expenditure Authority. i. The General Manager may only approve expenditures for expenses that are included within the District’s then current fiscal year budget; ii. The General Manager may not approve an expenditure that exceeds the total budgeted expense for the budget category in each “Cost Center” of the District, as identified in the District’s then current fiscal year budget; iii. The General Manager may not break down any proposed expenditure into components for the purpose of avoiding limitations on his or her expenditure authority. iv. All expenditures approved by the General Manager shall be included in the disbursement or other financial reports presented to the Board of Directors at its next regular meeting. v. The General Manager shall not exercise his or her expenditure authority so as to avoid or circumvent public, committee or Board participation in expenditures or projects that may be of particular interest. 4.02 Routine Operational Expenses. The General Manager may approve expenditures regardless of amount for payment of routine operational expenses such as payment of electricity bills, purchased water payments to the City of Fort Worth, for payment of solid waste collection services, meter replacements and bond payments provided the proposed expenditure is within, and does not exceed, the District’s then current fiscal year budget. 4.03 Compliance with Applicable Laws and Purchasing Procedures. In exercising his or her expenditure authority, the General Manager shall comply with all applicable procurement laws of the State of Texas and the District’s Purchasing Procedures, as amended by the Board of Directors from time to time. 4.04 Express Authority. The General Manager may approve expenditures of District funds in accordance with any specific authorization approved by the Board of Directors of the District. 4.05 Emergency Expenditures. The General Manager may approve expenditures of District funds in any amount as may be necessary to respond to emergency conditions that potentially threaten the health, safety or welfare of District customers, residents, or employees and for which immediate corrective action is necessary. All such emergency expenditures shall be reported to the Board of Directors at its next regularly scheduled meeting or emergency meeting, whichever is first. 4.06 Prudence and Fiscal Responsibility. The General Manager shall exercise his or her expenditure authority in a prudent and fiscally responsible manner, and consistent with all applicable policies and Orders adopted by the Board of Directors of the District. The General Manager shall bring to the Board of Directors for discussion and action any expenditures of significant public interest that do not relate to projects, goods or services previously approved by the Board of Directors. Order No. 2018-0618B GM Expenditure and Contracting Policy 4 of 7 June 18, 2018 Regular Meeting Agenda Packet 27 of 150   4.07 Disbursement Authority. Except as otherwise approved by the Board of Directors, all disbursements of District funds shall require the signature of either (i) two directors, or (ii) the General Manager and one director. 4.08 Electronic Transfers: a. General. Except as set forth below, the electronic transfer of District funds is prohibited: b. Transfer Between District Accounts. District funds may be transferred between District accounts only upon prior authorization of the General Manager or the Board of Directors. c. Payroll. The General Manager may approve the direct deposit of payroll, including payment of director fees, by electronic transfers of District funds. d. Authorized Investments. The General Manager may approve the electronic transfer of District funds for authorized investments, as identified in the District’s Investment Policy, and only upon prior approval of an Investment Officer of the District. All Investment Officers of the District shall be given prior notice of the proposed transfer of the District funds for investment purposes and the transfer of such funds shall require the written authorization of the General Manager. e. Debt Service Payments. The General Manager may authorize electronic transfer of District funds from the District’s debt service fund(s) for principal and interest payments on outstanding District bonds directly to the paying agent’s account. f. Governmental Transfers. The General Manager may authorize electronic transfer of funds for payment of payroll taxes and other payments to government entities that are required to be transmitted electronically. g. Reporting. A report identifying all electronic fund transfers shall be prepared and furnished to the Board of Directors not less than monthly. 4.09 Credit Accounts: The General Manager is authorized to open credit accounts and establish credit relationships on behalf of the District for proper governmental expenditures of the District in accordance with the following terms and limitations:  i. All purchases with District credit cards shall be made in accordance with the terms of this Order and the District’s Purchasing Procedures. ii. District accounts may not be used for personal or non-District purposes. iii. In consultation with the Finance Manager, the General Manager is authorized to issue District credit cards to individual employees. Each employee’s credit card must be subject to credit limits. Credit limits for staff may only be increased upon prior authorization of the General Manager in consultation with the Finance Manager. iv. Use of credit cards and credit accounts are subject to the same limitations as other expenditures, including that they be exercised only for proper purposes of the District and for expenses identified within, and in amounts not in excess of, the expense line item for the employee’s department set forth in the then current fiscal year budget. Order No. 2018-0618B GM Expenditure and Contracting Policy 5 of 7 June 18, 2018 Regular Meeting Agenda Packet 28 of 150   v. Credit card and credit account transactions should be limited to purchases with vendors that will not direct bill the District, and for which it is not practicable to provide payment by check. The original receipts shall be furnished to the District as evidence of the purpose of each payment made by credit card. 4.10. Delegation of Expenditure Authority: The General Manager may delegate expenditure authority granted under this Order in writing to individual staff persons (“Authorized Personnel”). The delegated authority is subject to the same terms, conditions and limitations set forth in this Policy that are applicable to the General Manager. The General Manager may not delegate or approve any expenditure by Authorized Personnel that would exceed the General Manager’s expenditure authority. In all cases, the General Manager shall remain responsible for overseeing and ensuring that Authorized Personnel exercise any delegated expenditure authority properly, prudently, and in accordance with the terms and limitations of this Order. V. CONTRACT AUTHORITY 5.01. Contract Authority: The General Manager is hereby authorized to enter into contracts on behalf of the District subject to the limitations set forth in this Article V. 5.02 Limitations on Contract Authority. Except as otherwise approved by the Board of Directors, the authority of the General Manager to enter into contracts on behalf of the District is subject to the following limitations: a. The payment under the contract shall be subject to the same limitations set forth in this Policy that govern the expenditure of funds by the General Manager, including without limitation that the total payment under a contract (including all goods or services contemplated under the contract) may not exceed the budgeted line item expense for the budgeted expense category to which the contract relates, and all contract expenditures must relate to an expenditure included within the District’s then current fiscal year budget; b. The contract term shall not exceed the District’s then current fiscal year. c. Contracts for professional services shall be approved in advance by the Board of Directors. Professional Services includes those services rendered for or on behalf of the District as defined in the Texas Government Code (architectural services, accounting services, engineering services, surveying services, and legal services, etc). d. Contracts for temporary labor (specifically excluding professional services) may be approved by the General Manager provided they are for $25,000 or less and consistent with the District’s fiscal year budget. e. A transaction or project shall not be broken down into component contracts for purposes of avoiding the expenditure limitations established by this Order. 5.03 Procurement Requirements. In exercising any contracting authority, the General Manager shall comply with all applicable laws. Without limitation, the General Manager must comply with the procurement requirements set forth in Section 49.273 of the Texas Water Code with respect to any contract for construction and repair and renovation of District facilities and for the purchase of equipment, materials, Order No. 2018-0618B GM Expenditure and Contracting Policy 6 of 7 June 18, 2018 Regular Meeting Agenda Packet 29 of 150   machinery, and all things that constitute or will constitute the plant, works, facilities, or improvements of the District. VI. MISCELLANEOUS 6.01 Finance Manager Review and Reporting: The District’s Finance Manager shall monitor the exercise of purchasing and expenditure authority, contracting authority, and use of District credit cards authorized by this Order. All irregularities, exceedances of authority, lack of internal controls, and risks to District funds that are not promptly corrected shall be reported by the Finance Manager to the Board of Directors immediately. Order No. 2018-0618B GM Expenditure and Contracting Policy 7 of 7 June 18, 2018 Regular Meeting Agenda Packet 30 of 150 June 18, 2018 Regular Meeting Agenda Packet31 of 150 June 18, 2018 Regular Meeting Agenda Packet32 of 150 June 18, 2018 Regular Meeting Agenda Packet33 of 150 June 18, 2018 Regular Meeting Agenda Packet34 of 150 June 18, 2018 Regular Meeting Agenda Packet35 of 150 INDEPENDENT CONTRACTOR AGREEMENT This Independent Contractor Agreement ("Agreement") is entered into between Trophy Club Municipal Utility District No. 1 (the "District") and John Robert Carman ("Contractor") as of this _p!;day of 17'-'f (itc~ sC , 2017 (the "Effective Date"), and constitutes the full and complete terms of their agreement, and supersedes any and all other oral or written agreements which the parties may have made concerning this same subject matter. The District and Contractor are collectively referred to as the "Parties" under this Agreement. Recitals WHEREAS, the Contractor has specialized training and expenence m the area of management and operation of public utilities; WHEREAS, Section 49.056 of the Texas Water Code authorizes the board of directors of a water district to contract with a person to perform such services as general manager for the district as the board may from time to time specify, and further provides that the board may delegate to the general manager full authority to manage and operate the affairs of the district subject only to orders of the board; and WHEREAS, pursuant to and in accordance with the authority set forth at Section 49.056 of the Texas Water Code, the District and Contractor desire to enter into an independent contractor relationship whereby the Contractor will provide services as general manager for the District. Contractor will provide these services as an independent contractor and not as an employee of the District. NOW, THEREFORE, in consideration of the following terms, covenants, and conditions contained herein, the sufficiency of which are hereby acknowledged, the District and Contractor agree as follows: I. ENGAGEMENT OF CONTRACTOR Section 1.1 Engagement of Independent Contractor. (a) Pursuant to the authority set forth at Section 49.056 of the Texas Water Code, the District hereby engages Contractor to serve as general manager of the District under the terms and conditions of this Agreement (the "Services"). Contractor is hereby authorized to manage the affairs of the District subject only to the following: (i) the orders of the Board of Directors, as adopted or amended from time to time; (ii) the rules, regulations and policies of the District, as adopted and amended by the Board of Directors from time to time; (iii) the provisions of Texas law and regulatory requirements applicable to the District; and (iv) the terms and conditions of this Agreement. Without limiting the generality of the foregoing, Contractor shall be responsible for efficiently and properly managing the operational, administrative, employee and financial affairs of the District; and shall perform such additional services as general manager for the District as the Board of Directors may from time to time specify. Contractor's responsibilities shall specifically include, by way of example and without limitation, the following responsibilities: 1 June 18, 2018 Regular Meeting Agenda Packet36 of 150 (i) Oversee the effective management and operations of the District, and implement the directives and policies established by the Board of Directors; (ii) Direct and supervise the administration of all departments; (iii) Attend all meetings of the Board, except when excused by the Board of Directors; (iv) Prepare and submit a draft annual budget and capital program to the Board of Directors, and implement the final budget approved by Board of Directors to achieve the goals of the District; (v) On an annual basis, submit to the Board of Directors and make available to the public a complete report on the finances and administrative activities of the District's prior fiscal year; (vi) Keep the Board of Directors fully advised as to the financial condition and future needs of the District; (vii) Be responsible for managing the financial affairs of the District; (viii) Ensure that all records and books of the District are properly kept and that all notices are duly given as required by law; (ix) Make recommendations to the Board of Directors concerning affairs of the District and facilitate the work of the Board of Directors in developing policies; (x) Provide support services for the Board of Director; (xi) Assist the Board of Directors in developing goals and strategies for the next fiscal period; (xii) Assist the Board of Directors to develop long term goals for the District and develop strategies to implement those goals; (xiii) Encourage and provide staff support for regional and intergovernmental cooperation; (xiv) Promote cooperation among Board of Directors, staff and citizens m developing public policy and building a sense of community; and (xv) Perform such other duties as may be prescribed by Board of Directors (b) In connection with performing the Services, the Contractor will work independently and exercise his own judgment, without official hours or a prescribed minimum number of hours worked per week. Notwithstanding the foregoing, Contractors shall work as many hours as may be reasonably necessary to fulfill his obligations under this Agreement. The District shall have no control over the means or methods of Contractor's work, except that 2 June 18, 2018 Regular Meeting Agenda Packet37 of 150 Contractor shall provide Services in a professional and workmanlike manner consistent with the highest standards of the utility industry and with the standards and business policies of the District, and shall comply with all applicable local, state and federal laws, rules and regulations. (c) To the extent Contractor will be unavailable to provide any Services within the District during the term of this Agreement due to illness, vacation, travel or otherwise, Contractor shall provide the District with as much prior notice thereof as may be practicable under the circumstances. (d) Contractor may maintain memberships in professional societies as appropriate. Contractor may also attend such professional meetings and continuing education programs as may be necessary to maintain Contractor's professional knowledge and skills. Except as otherwise approved by the Board of Directors, Contractor shall be responsible for payment of costs and expenses related to such meetings and continuing education programs. Section 1.2 Exclusions. The Patties specifically acknowledge the following limitations on the authority of the General Manager under this Agreement: (i) Debt. Contractor is not authorized to obligate the District to any debt or liability without the prior approval ofthe Board of Directors. (ii) Expenditure Authority. Subject to the District's policies, Contractor shall be authorized to expend District funds for payment of lawful expenses of the District subject to the following limitations: (i) all expenditures must be consistent with the District's approved annual fiscal year budget; (ii) any checks executed by Contractor must be co-signed by the Secretary/Treasurer or other member of the Board of Directors of the District; and (iii) Contractor is not authorized to sign or authorize any disbursement or payment of funds to Contractor. The District shall furnish Contractor with a "P Card" for reasonable and necessary expenditures related to District business. All purchases with the card shall be subject to and unde1taken by Contractor in accordance with the District's rules and policies governing purchasing. (iii) Personnel Matters. Contractor shall not have the authority to retain or terminate any District employees. Section 1.3 Board Meetings. Except as otherwise approved by the Board of Directors, Contractor shall attend all regular, special and emergency meetings of the District's Board of Directors. Section 1.4 Non-Exclusivity. (a) Contractor acknowledges and agrees that this Agreement is non-exclusive with respect to the District, and District may retain other contractors or employees to provide all or any portion of the Services on its behalf from time to time, as determined in the sole and absolute discretion of the Board of Directors. 3 June 18, 2018 Regular Meeting Agenda Packet38 of 150 (b) The District specifically agrees that Contractor may provide professional consulting services to persons or entities other than the District subject to the following terms, conditions and limitations: (i) No such services shall conflict with the goals, policies, or best interests of the District; (ii) Such services shall not prevent Contractor from being able to perform his duties and responsibilities for the District; (iii) Under no circumstances shall Contractor utilize District equipment, personnel, or assets for any outside consulting services, it being acknowledged by Contractor that such use would be unlawful and in violation of the District's rules and policies; and (iv) Any and all costs and expenses associated with outside consulting services shall be paid solely by Contractor. II. COMPENSATION Section 2.1 Compensation for Services. In consideration for the provision of the Services by Contractor, the District shall pay to Contractor an amount equal to $75.00 per hour for each hour spent on such Services. This rate presumes an average monthly level of effmi equal to 160 hours per month. Except as otherwise approved by the Board of Directors, the total compensation for Services rendered under this Agreement shall not exceed $144,000. Section 2.2 Billing and Payment. Contractor will submit invoices to the District on or before the 51h day of each month for Services rendered during the preceding month. Each invoice shall include a description in reasonable detail of the Services rendered and the time associated therewith. The District shall provide payment for all non-disputed invoices in full within 30 days of receipt of the invoice. To the extent the District disputes any charges on an invoice, it shall timely pay the remainder of the invoice while the Parties resolve the dispute in good faith as promptly as practicable. III. REPRESENTATIONS AND WARRANTIES Section 3.1 Representations and Warranties of Contractor. To induce the District to enter into this Agreement and to consummate the transactions contemplated by this Agreement, Contractor represents and warrants as follows: (i) Contractor possesses all skills necessary to perform his obligations hereunder and is competent to perform such obligations; (ii) Any equipment, including computers and phones furnished or made available by the District to Contractor shall remain the District's propetiy at all times and shall be returned to the District immediately upon termination of this 4 June 18, 2018 Regular Meeting Agenda Packet39 of 150 Agreement; (iii) Any equipment, including computers and phones furnished or made available by the District to Contractor shall be utilized only in connection with conducting official business of the District and for no other purpose; (iv) Any non-confidential information relating to the District, its officers and employees acquired by Contractor in connection with the Services shall be furnished to third parties only to the extent reasonably necessary or prudent in connection with performing the Services and for no other reason; and (v) Contractor shall not transmit any District information or records to any non-District computer or electronic device, and all such information and records acquired by Contractor in connection with the Services, whether confidential or not, shall be returned to the District immediately upon termination of this Agreement. IV. CONFIDENTIAL INFORMATION Section 4.1 Confidential Information. During the performance of the Services, Contractor may have access to and become familiar with various sensitive information belonging to the District consisting of, but not limited to, information that is not subject to disclosure through the Texas Public Information Act (the "Act") due to an exception set forth in the Act or any other applicable state or federal law (collectively "Confidential Information"). Contractor acknowledges and agrees all Confidential Information shall not be disclosed and will remain the property of the District. Section 4.2 Use or Disclosure of Confidential Information. Contractor agrees he shall not use in any way or disclose any of the District's Confidential Information, either directly or indirectly, either during the term of this Agreement or at any time thereafter, except as follows: (i) such use or disclosure is reasonable and necessary in the proper performance of the Services and is undertaken in accordance with all applicable laws; or (ii) such use or disclosure is required by law. Section 4.3 Enforcement. It is understood and agreed by the Parties that unauthorized use or disclosure, or threatened unauthorized use or disclosure, of the District's Confidential Information will diminish the value of the Confidential Information and may harm the District. In the event Contractor breaches, or threatens to breach, this Article IV, the District shall be entitled, among all other remedies available at law or in equity, to injunctive relief prohibiting Contractor from disclosing such information. v. RELATIONSHIP OF PARTIES Section 5.1 Independent Contractor. It is understood and agreed by the Parties that Contractor is an independent contractor and shall in no sense be considered an employee or agent of the District. Contractor will have no power or right to enter into contracts or commitments on behalf of the District. 5 June 18, 2018 Regular Meeting Agenda Packet40 of 150 Section 5.2 Taxes. The District shall not be responsible for, and shall not withhold or pay any federal, state or local income tax, nor payroll tax of any kind, on behalf of Contractor or any employees of Contractor. Contractor shall be responsible for the filing and payment of all income related taxes associated with Contractor. Contractor shall not be treated as an employee with respect to the services performed hereunder for federal or state tax purposes. Section 5.3 Reimbursement of Expenses. Except as specifically provided in Section 5.4 of this Agreement or approved in advance by the Board of Directors, the District shall not be liable to Contractor for any expenses paid or incuned by Contractor in connection with performing the Services. Section 5.4 Equipment, Tools, Materials or Supplies. The District shall furnish Contractor the following and shall pay all costs and expenses associated therewith: (i) a computer laptop; (ii) a cellular phone; and (iii) an office within the District's administrative building and administrative supplies. Section 5.5 Fringe Benefits/Workers' Compensation. Contractor, as one engaged in his own independently established business, is not eligible for, and shall not participate in, any employee pension, health, or other fringe benefit plans of the District. The District is not responsible for, and shall not provide, workers' compensation insurance for Contractor. Section 5.6 Unemployment Tax. Contractor understands that the District shall not be making contributions on his behalf for unemployment compensation, and agrees to make whatever contributions are required of it as an employer. VI. RISK POOL COVERAGE AND INDEMNIFICATION Section 6.1 Risk Pool Coverage. The District agrees that Contractor will be serving in the capacity of a public official for the District. Accordingly, to the extent authorized by law, the District agrees to seek to add Contractor as an additional covered party under the District's interlocal agreement with the Texas Municipal League for risk pool coverage for the duration of this Agreement, and further agrees to hold Contractor harmless from and against any and all claims, causes of action, damages, losses, and/or losses arising out of the Services provided by Contractor pursuant to this Agreement to the extent such liability or costs are covered under the District's interlocal agreement providing liability coverage to District officials and employees acting with the scope of their employment with the District. Section 6.2 Indemnification. CONTRACTOR A GRESS TO DEFEND, INDEMNIFY AND HOLD HARMLESS THE DISTRICT AND ITS OFFICERS, DIRECTORS, REPRESENTATIVES, AND AGENTS, FROM EVERY LOSS, DAMAGE, INJURY, COST, EXPENSE, CLAIM, JUDGMENT, OR LIABILITY OF EVERY FIND OR CHARACTER (INCLUDING REASONABLE ATTORNEY'S FEES), WHETHER IN CONTRACT, TORT, OR OTHERWISE, WHICH ARISES DIRECTLY OR INDIRECTLY FROM CONTRACTOR'S WILLFUL MISCONDUCT OR GROSS NEGLIGENCE. VII. TERM AND TERMINATION 6 June 18, 2018 Regular Meeting Agenda Packet41 of 150 Section 7.1 Term of Engagement. The term ofthis Agreement shall commence on the Effective Date and continue for a period of one year. Upon the anniversary of the Effective Date, this Agreement shall automatically renew for an additional year unless either Pmiy provide not less than thirty (30) days prior written notice of its intent that this Agreement not renew. Section 7.2 Termination ofthe Agreement. This Agreement can be terminated at any time by the District "for cause" if Contractor is unable to perform for any reason his duties hereunder. The District may also immediately terminate this Agreement for: (1) fraud, misappropriation or embezzlement; (2) lack of work; (3) Contractor's failure to timely or adequately perform the duties and services herein; ( 4) any act in breach of this Agreement; and (5) disparagement by Contractor of the District or any of its officials. The District may also terminate this Agreement without cause upon thirty (30) days written notice to Contractor. Contractor may terminate this Agreement upon thitiy (30) days written notice to the District. The District shall compensate Contractor for all Services rendered through the date of termination. VIII. MISCELLANEOUS Section 8.1 Subcontracting. Contractor may not subcontract any of the Services without the prior approval of the Board of Directors of the District. Section 8.2 Notice. All notices hereunder from Contractor to the District will be sufficient if sent by cetiified mail, addressed to the District to the attention of the Board of Directors, 100 Municipal Dr., Trophy Club, TX 76262. All notices hereunder from the District to Contractor will be sufficiently given if sent by certified mail to John Robert Carman, 2600 Museum Way, Suite #1101, Fort Wmih, Texas 76107. Section 8.3 Governing Law. This Agreement will be governed by and construed in accordance with the laws of the State of Texas (exclusive of conflicts oflaw principles). Section 8.4 Entire Agreement and Amendments. This Agreement represents the entire Agreement between the District and Contractor with respect to the subject matter of this Agreement. This Agreement supersedes or replaces any prior agreement or understanding with respect to the subject matter set forth herein between Contractor and the District. This Agreement may not be amended except in a writing signed by the pmiy against whom such amendment is to be enforced. Section 8.5 Assignments. Contractor may not assign or delegate this Agreement or any rights or obligations hereunder without the prior written consent of the District. Any attempted assignment or delegation in violation of the immediately preceding sentence will be void. Section 8.6 Severability. If any of the provisions of this Agreement are determined to be invalid or unenforceable, such invalidity or unenforceability will not invalidate or render unenforceable the remainder of this Agreement, but rather the entire Agreement will be construed as if not containing the pmiicular invalid or unenforceable provision or provisions, and the rights and obligations of the parties will be construed and enforced accordingly. 7 June 18, 2018 Regular Meeting Agenda Packet42 of 150 Section 8.7 Survival. Articles III, IV and VI shall survive the termination of the Agreement. Section 8.8 Counterparts. This Agreement may be executed in one or more counterparts, all of which will be considered one and the same agreement and will become effective when one or more counterpm1s have been signed by each ofthe Pm1ies and delivered to the other party, it being understood that both Pm1ies need not sign the same counterpart. A signature reproduced by facsimile or other electronic format will be deemed to have the same effect as an original signature. Section 8.9 Enforcement of Agreement. In the event ofthe breach of this Agreement by either pm1y, the prevailing party shall be entitled to recovery of reasonable attorneys' fees and legal costs incurred in seeking to enforce this Agreement. IN WITNESS WHEREOF, the Parties hereto have caused this instrument to be signed, sealed and attested in duplicate by their duly authorized officers, as of the Effective Date. TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 By: Name:-----,.£,4___.__,-=· "'-'·C.Z. ... n_,___-"-e=""-----"'a"""'~=-.,------Title: ~H"---'-_e_..:::.s_.:.·.,._c_~--=--..:__/-_________ _ Date: 7/2-Pz --77~-,7~~---------------------CONTRACTOR: -Date: ?:Lz~/2cJ tJ-8 June 18, 2018 Regular Meeting Agenda Packet43 of 150 9 June 18, 2018 Regular Meeting Agenda Packet44 of 150 TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET MAY 2018 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 738,364 PREPAID EXPENSES 5,079 ADVALOREM PROPERTY TAXES RECEIVABLE 23,322 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE - TOTAL ASSETS 766,765 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 23,322 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 23,322 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 522,253 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 221,191 TOTAL FUND BALANCE 743,443 TOTAL LIABILITIES AND FUND BALANCE 766,765 June 18, 2018 Regular Meeting Agenda Packet 45 of 150 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 1 22:05 06/13/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 5/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- 8,766.26- 1,057,968.15- 100.335 3,535.15 122-40011-000-000 Property Taxes/Fire-Delinquent 318.65- 3,885.98- 3,885.98 122-40020-000-000 Property Taxes/Fire P&I 1,033.95- 4,448.81- 4,448.81 Subtotal: 1,054,433.00- 1,054,433.00- 10,118.86- 1,066,302.94- 101.126 11,869.94 Program number: 1,054,433.00- 1,054,433.00- 10,118.86- 1,066,302.94- 101.126 11,869.94 Department number: Fire Revenues 1,054,433.00- 1,054,433.00- 10,118.86- 1,066,302.94- 101.126 11,869.94 Revenues Subtotal ----------- 1,054,433.00- 1,054,433.00- 10,118.86- 1,066,302.94- 101.126 11,869.94 June 18, 2018 Regular Meeting Agenda Packet 46 of 150 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 2 22:05 06/13/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/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 10,158.96 56.439 7,841.04 122-60337-045-000 Transfer to Town/Fire Budget 608,910.00 608,910.00 50,742.50 405,940.00 66.667 202,970.00 Subtotal: 845,864.00 845,864.00 52,012.37 635,052.96 75.077 210,811.04 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 81,420.00 81,420.00 100.000 122-69305-045-000 Capital Leases 127,149.00 127,149.00 127,148.60 100.000 .40 Subtotal: 208,569.00 208,569.00 208,568.60 100.000 .40 Program number: 1,054,433.00 1,054,433.00 52,012.37 845,112.05 80.148 209,320.95 Department number: Fire 1,054,433.00 1,054,433.00 52,012.37 845,112.05 80.148 209,320.95 Expenditures Subtotal ----------- 1,054,433.00 1,054,433.00 52,012.37 845,112.05 80.148 209,320.95 Fund number: 122 Trophy Club MUD Fire Dept. 41,893.51 221,190.89- 221,190.89 June 18, 2018 Regular Meeting Agenda Packet 47 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 1 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 5/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 1476 05/01/2018 Property Taxes (1,049,201.89) (104.92) (1,049,306.81) GL 1477 05/02/2018 Property Taxes (20.20) (1,049,327.01) GL 1478 05/03/2018 Property Taxes (116.90) (1,049,443.91) GL 1479 05/04/2018 Property Taxes (48.13) (1,049,492.04) GL 1480 05/07/2018 Property Taxes (1,327.10) (1,050,819.14) GL 1481 05/09/2018 Property Taxes (332.30) (1,051,151.44) GL 1482 05/10/2018 Property Taxes (55.14) (1,051,206.58) GL 1483 05/11/2018 Property Taxes (578.25) (1,051,784.83) GL 1484 05/14/2018 Property Taxes (781.17) (1,052,566.00) GL 1485 05/15/2018 Property Taxes (41.68) (1,052,607.68) GL 1486 05/16/2018 Property Taxes (1,008.61) (1,053,616.29) GL 1487 05/17/2018 Property Taxes (379.31) (1,053,995.60) GL 1488 05/18/2018 Property Taxes (52.86) (1,054,048.46) GL 1489 05/21/2018 Property Taxes (92.20) (1,054,140.66) GL 1490 05/22/2018 Property Taxes (59.27) (1,054,199.93) GL 1491 05/23/2018 Property Taxes (557.68) (1,054,757.61) GL 1492 05/24/2018 Property Taxes (1,563.43) (1,056,321.04) GL 1493 05/25/2018 Property Taxes (86.99) (1,056,408.03) GL 1495 05/29/2018 Property Taxes (312.49) (1,056,720.52) GL 1496 05/30/2018 Property Taxes (454.60) (1,057,175.12) GL 1497 05/31/2018 Property Taxes (793.03) (1,057,968.15) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (8,766.26) (1,057,968.15) ** (1,054,433.00) Budgeted 3,535.15 Remaining 100 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1481 05/09/2018 Property Taxes (3,567.33) (17.96) (3,585.29) GL 1484 05/14/2018 Property Taxes (.01) (3,585.30) GL 1491 05/23/2018 Property Taxes 18.61 (3,566.69) GL 1495 05/29/2018 Property Taxes (319.29) (3,885.98) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (318.65) (3,885.98) ** .00 Budgeted 3,885.98 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 1476 05/01/2018 Property Taxes (3,414.86) (13.24) (3,428.10) GL 1477 05/02/2018 Property Taxes (2.22) (3,430.32) GL 1478 05/03/2018 Property Taxes (12.86) (3,443.18) GL 1479 05/04/2018 Property Taxes (8.89) (3,452.07) GL 1480 05/07/2018 Property Taxes (163.89) (3,615.96) GL June 18, 2018 Regular Meeting Agenda Packet 48 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 2 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1481 05/09/2018 Property Taxes (3,414.86) (73.17) (3,689.13) GL 1483 05/11/2018 Property Taxes (61.72) (3,750.85) GL 1484 05/14/2018 Property Taxes (48.78) (3,799.63) GL 1486 05/16/2018 Property Taxes (112.06) (3,911.69) GL 1487 05/17/2018 Property Taxes (23.97) (3,935.66) GL 1490 05/22/2018 Property Taxes (2.71) (3,938.37) GL 1491 05/23/2018 Property Taxes (21.55) (3,959.92) GL 1492 05/24/2018 Property Taxes (159.47) (4,119.39) GL 1495 05/29/2018 Property Taxes (225.10) (4,344.49) GL 1496 05/30/2018 Property Taxes (45.93) (4,390.42) GL 1497 05/31/2018 Property Taxes (58.39) (4,448.81) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (1,033.95) (4,448.81) ** .00 Budgeted 4,448.81 Remaining 0 % Used Department Totals: ----------------------------------- (1,066,302.94) ** (10,118.86) Monthly Total (1,054,433.00) Budgeted 11,869.94 Remaining 101 % Used June 18, 2018 Regular Meeting Agenda Packet 49 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 3 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/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 239 05/01/2018 Insurance/Wrk Comp Exp May 8,889.09 1,269.87 10,158.96 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,269.87 10,158.96 ** 18,000.00 Budgeted 7,841.04 Remaining 56 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 1333 05/07/2018 May A/P May Fire Admin 355,197.50 50,742.50 405,940.00 TOWN OF TROPHY CLUB 4190 AP _______________ Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 50,742.50 405,940.00 ** 608,910.00 Budgeted 202,970.00 Remaining 67 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 .00 81,420.00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 81,420.00 ** 81,420.00 Budgeted .00 Remaining 100 % Used Account: 122-69305-045-000 Capital Leases 127,148.60 .00 127,148.60 _______________ Account: 122-69305-045-000 Capital Leases Totals: .00 127,148.60 ** 127,149.00 Budgeted .40 Remaining 100 % Used Department 45 Totals: ----------------------------------- 845,112.05 ** 52,012.37 Monthly Total 1,054,433.00 Budgeted 209,320.95 Remaining 80 % Used June 18, 2018 Regular Meeting Agenda Packet 50 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Fund 122 Totals: ----------------------------------- (221,190.89) 41,893.51 Monthly Total .00 Budgeted 221,190.89 Remaining 0 % Used June 18, 2018 Regular Meeting Agenda Packet 51 of 150 TROPHY CLUB MUD #1 - O&M BALANCE SHEET MAY 2018 GTBGT 135 137 GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 - 600 CASH IN BANK-CHECKING 1,414,501 - 1,414,501 CASH IN BANK-SAVINGS-CASH RESERVE 781,976 - 781,976 CD-BANK OF THE WEST/THB DEPOSIT 35,316 - 35,316 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 715,081 - 715,081 INVESTMENTS-TEXPOOL 2,501,942 596,426 3,098,368 PREPAID EXPENSES 37,383 - 37,383 ADVALOREM PROPERTY TAXES RECEIVABLE 2,559 - 2,559 UTILITY AND OTHER ACCOUNTS RECEIVABLE 975,346 - 975,346 TOTAL ASSETS 6,464,704 596,426 7,061,130 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 2,559 - 2,559 ACCOUNTS AND OTHER PAYABLES 681,095 - 681,095 CUSTOMER DEPOSITS 315,165 - 315,165 - TOTAL LIABILITIES 998,819 - 998,819 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,315,517 - 1,315,517 - TOTAL FUND BALANCE 5,465,885 596,426 6,062,311 TOTAL LIABILITIES AND FUND BALANCE 6,464,704 596,426 7,061,130 June 18, 2018 Regular Meeting Agenda Packet 52 of 150 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 3 22:05 06/13/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/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- 1,005.48- 121,350.65- 100.331 400.65 135-40002-000-000 Property Taxes/Delinquent 200.00- 200.00- 112.85- 343.60- 171.800 143.60 135-40015-000-000 Property Taxes/P & I 200.00- 200.00- 129.27- 492.32- 246.160 292.32 135-40025-000-000 PID Surcharges 177,839.00- 177,839.00- 177,839.00- Subtotal: 299,189.00- 299,189.00- 1,247.60- 122,186.57- 40.839 177,002.43- 135-47000-000-000 Water 6,464,019.00- 6,464,019.00- 498,952.46- 3,139,601.54- 48.570 3,324,417.46- 135-47005-000-000 Sewer 2,978,067.00- 2,978,067.00- 259,749.23- 1,943,596.97- 65.264 1,034,470.03- 135-47025-000-000 Penalties 106,279.00- 106,279.00- 7,467.82- 72,062.31- 67.805 34,216.69- 135-47030-000-000 Service Charges 21,350.00- 21,350.00- 950.00- 9,400.00- 44.028 11,950.00- 135-47035-000-000 Plumbing Inspections 1,500.00- 1,500.00- 200.00- 1,700.00- 113.333 200.00 135-47045-000-000 Sewer Inspections 4,500.00- 4,500.00- 600.00- 4,300.00- 95.556 200.00- 135-47070-000-000 TCCC Effluent Charges 60,000.00- 60,000.00- 10,885.60- 27,196.00- 45.327 32,804.00- Subtotal: 9,635,715.00- 9,635,715.00- 778,805.11- 5,197,856.82- 53.944 4,437,858.18- 135-49010-000-000 Interest Income 12,000.00- 12,000.00- 5,074.77- 30,645.77- 255.381 18,645.77 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 7,762.20- 71.043 3,163.80- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 4,666.64- 66.666 2,333.36- 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- 1,372.00- 10,806.76- 59.446 7,372.24- 135-49141-000-000 Interfund Transfer In 1,053,984.38- 1,850,129.46- 1,850,129.46 135-49900-000-000 Miscellaneous Income 5,000.00- 5,000.00- 46,017.64- 58,775.83- 1,175.517 53,775.83 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- 1,107,032.12- 1,978,186.66- 627.747 1,663,061.66 Program number: 10,250,029.00- 10,250,029.00- 1,887,084.83- 7,298,230.05- 71.202 2,951,798.95- Department number: Revenues 10,250,029.00- 10,250,029.00- 1,887,084.83- 7,298,230.05- 71.202 2,951,798.95- Revenues Subtotal ----------- 10,250,029.00- 10,250,029.00- 1,887,084.83- 7,298,230.05- 71.202 2,951,798.95- June 18, 2018 Regular Meeting Agenda Packet 53 of 150 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 4 22:05 06/13/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/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 19,749.50 138,182.00 50.380 136,097.00 135-50010-010-000 Overtime 20,000.00 20,000.00 1,007.68 6,518.38 32.592 13,481.62 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 150.00 1,400.00 42.424 1,900.00 135-50020-010-000 Retirement 27,843.00 27,843.00 1,933.91 15,230.41 54.701 12,612.59 135-50026-010-000 Medical Insurance 52,196.00 52,196.00 2,948.80 21,004.63 40.242 31,191.37 135-50027-010-000 Dental Insurance 5,182.00 5,182.00 213.65 1,734.69 33.475 3,447.31 135-50028-010-000 Vision Insurance 994.00 994.00 35.92 316.15 31.806 677.85 135-50029-010-000 Life Insurance & Other 2,982.00 2,982.00 128.60 1,803.31 60.473 1,178.69 135-50030-010-000 Social Security Taxes 18,662.00 18,662.00 1,309.38 9,213.19 49.369 9,448.81 135-50035-010-000 Medicare Taxes 4,365.00 4,365.00 306.24 2,154.69 49.363 2,210.31 135-50040-010-000 Unemployment Taxes 1,080.00 1,080.00 10.26 818.68 75.804 261.32 135-50045-010-000 Workman's Compensation 11,854.00 11,854.00 899.92 7,199.36 60.734 4,654.64 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 28,693.86 209,130.53 49.016 217,531.47 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 1,503.57 50,169.61 50.170 49,830.39 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 34.75 3,887.82 97.196 112.18 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 3,500.00 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 2,160.00 5,765.16 104.821 265.16- Subtotal: 391,000.00 391,000.00 3,698.32 59,822.59 15.300 331,177.41 135-60010-010-000 Communications/Mobiles 4,700.00 4,700.00 370.18 2,492.62 53.034 2,207.38 135-60020-010-000 Electricity 175,356.00 175,356.00 9,001.73 82,161.55 46.854 93,194.45 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 141.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 58,261.27 1,021,013.08 36.165 1,802,156.92 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 6,000.00 40.678 8,750.00 135-60332-010-000 Interfund Transfer Out-Rev I&S 278,084.00 278,084.00 25,280.31 202,242.48 72.727 75,841.52 135-60333-010-000 Interfund Transfer Out-Reserve 48,996.00 48,996.00 4,068.00 32,649.00 66.636 16,347.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- June 18, 2018 Regular Meeting Agenda Packet 54 of 150 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 5 22:05 06/13/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/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 98,622.49 2,425,826.11 67.126 1,188,025.89 135-65005-010-000 Fuel & Lube 15,000.00 15,000.00 1,186.68 6,965.98 46.440 8,034.02 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,227.07 11,958.84 59.794 8,041.16 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 391.00 583.00 58.300 417.00 135-65050-010-000 Meter Expense 50,000.00 50,000.00 5,011.00 21,102.00 42.204 28,898.00 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 7,815.75 90,758.96 51.659 84,929.04 135-69005-010-000 Capital Outlays 810,012.00 810,012.00 159,996.29 525,538.34 64.880 284,473.66 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 159,996.29 708,402.72 67.581 339,828.28 Program number: 5,655,433.00 5,655,433.00 298,826.71 3,493,940.91 61.780 2,161,492.09 June 18, 2018 Regular Meeting Agenda Packet 55 of 150 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 6 22:05 06/13/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 5/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 298,826.71 3,495,140.99 61.780 2,162,292.01 June 18, 2018 Regular Meeting Agenda Packet 56 of 150 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7 22:05 06/13/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 410,866.00 410,866.00 25,207.65 235,318.69 57.274 175,547.31 135-50010-020-000 Overtime 30,000.00 30,000.00 3,966.19 23,600.81 78.669 6,399.19 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 5,636.00 67.095 2,764.00 135-50020-020-000 Retirement 42,243.00 42,243.00 2,763.32 26,611.46 62.996 15,631.54 135-50026-020-000 Medical Insurance 62,175.00 62,175.00 5,518.69 43,493.33 69.953 18,681.67 135-50027-020-000 Dental Insurance 5,271.00 5,271.00 371.89 3,204.18 60.789 2,066.82 135-50028-020-000 Vision Insurance 1,114.00 1,114.00 58.90 567.26 50.921 546.74 135-50029-020-000 Life Insurance & Other 4,281.00 4,281.00 172.36 3,162.18 73.865 1,118.82 135-50030-020-000 Social Security Taxes 28,314.00 28,314.00 1,674.11 15,650.17 55.274 12,663.83 135-50035-020-000 Medicare Taxes 6,622.00 6,622.00 391.52 3,660.11 55.272 2,961.89 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 1,134.00 90.000 126.00 135-50045-020-000 Workman's Compensation 17,990.00 17,990.00 1,348.00 10,784.00 59.944 7,206.00 135-50060-020-000 Pre-emp Physicals/Testing 300.00 300.00 63.00 63.00 21.000 237.00 135-50070-020-000 Employee Relations 350.00 350.00 350.00 Subtotal: 626,601.00 626,601.00 42,235.63 380,300.19 60.693 246,300.81 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 7,926.11 44,421.37 51.593 41,678.63 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 6,353.60 79.420 1,646.40 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 289.69 57.938 210.31 135-55125-020-000 Dumpster Services 60,000.00 60,000.00 4,895.51 55,077.12 91.795 4,922.88 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 2,186.60 22,716.02 75.720 7,283.98 Subtotal: 219,150.00 219,150.00 15,008.22 131,031.58 59.791 88,118.42 135-60010-020-000 Communications/Mobiles 4,700.00 4,700.00 527.28 3,393.00 72.191 1,307.00 135-60020-020-000 Electricity 266,709.00 266,709.00 10,739.33 110,273.38 41.346 156,435.62 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 436.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 19.97 19.97 .499 3,980.03 135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 1,060.00 4,600.00 39.655 7,000.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 122,043.00 122,043.00 11,094.81 88,758.48 72.727 33,284.52 135-60332-020-000 Interfund Transfer Out-Rev I&S 598,738.00 598,738.00 54,430.72 435,445.76 72.727 163,292.24 135-60333-020-000 Interfund Transfer Out-Reserve 123,336.00 123,336.00 10,248.00 82,194.00 66.642 41,142.00 June 18, 2018 Regular Meeting Agenda Packet 57 of 150 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 8 22:05 06/13/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/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 201,031.99 201,031.99 100.516 1,031.99- 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 289,588.10 958,851.29 66.636 480,086.71 135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 925.48 6,265.67 50.125 6,234.33 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 2,760.00 8,041.23 29.241 19,458.77 135-65035-020-000 Small Tools 1,000.00 1,000.00 1,149.94 114.994 149.94- 135-65040-020-000 Safety Equipment 750.00 750.00 406.53 1,157.50 154.333 407.50- 135-65045-020-000 Lab Supplies 14,000.00 14,000.00 2,783.23 13,483.81 96.313 516.19 Subtotal: 60,209.00 60,209.00 6,875.24 31,872.74 52.937 28,336.26 135-69005-020-000 Capital Outlays 547,327.00 547,327.00 1,190.00 91,150.61 16.654 456,176.39 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 1,190.00 121,150.61 19.042 515,091.39 Program number: 2,981,140.00 2,981,140.00 354,897.19 1,623,206.41 54.449 1,357,933.59 Department number: Wastewater 2,981,140.00 2,981,140.00 354,897.19 1,623,206.41 54.449 1,357,933.59 June 18, 2018 Regular Meeting Agenda Packet 58 of 150 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 9 22:05 06/13/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 5/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 19.36 64.533 10.64 Subtotal: 30.00 30.00 2.42 19.36 64.533 10.64 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 405.00 1,215.00 101.250 15.00- 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 960.00 19.200 4,040.00 135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 1,255.28 62.764 744.72 Subtotal: 12,950.00 12,950.00 405.00 5,620.28 43.400 7,329.72 Program number: 12,980.00 12,980.00 407.42 5,639.64 43.449 7,340.36 Department number: Board of Directors 12,980.00 12,980.00 407.42 5,639.64 43.449 7,340.36 June 18, 2018 Regular Meeting Agenda Packet 59 of 150 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 10 22:05 06/13/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/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 33,973.87 248,159.41 57.330 184,703.59 135-50010-030-000 Overtime 2,000.00 2,000.00 89.86 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,150.89 25,641.34 63.229 14,911.66 135-50026-030-000 Medical Insurance 63,485.00 63,485.00 4,145.24 31,483.69 49.592 32,001.31 135-50027-030-000 Dental Insurance 5,502.00 5,502.00 259.52 2,271.96 41.293 3,230.04 135-50028-030-000 Vision Insurance 1,173.00 1,173.00 42.51 426.43 36.354 746.57 135-50029-030-000 Life Insurance & Other 5,059.00 5,059.00 240.09 2,694.84 53.268 2,364.16 135-50030-030-000 Social Security Taxes 27,181.00 27,181.00 2,033.55 15,024.46 55.276 12,156.54 135-50035-030-000 Medicare Taxes 6,357.00 6,357.00 475.59 3,513.78 55.274 2,843.22 135-50040-030-000 Unemployment Taxes 1,260.00 1,260.00 983.77 78.077 276.23 135-50045-030-000 Workman's Compensation 1,529.00 1,529.00 123.50 988.00 64.617 541.00 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 124.95 24.990 375.05 135-50070-030-000 Employee Relations 4,960.00 4,960.00 3,109.08 62.683 1,850.92 Subtotal: 595,970.00 595,970.00 44,534.62 338,526.13 56.803 257,443.87 135-55030-030-000 Software & Support 78,391.00 78,391.00 6,026.14 59,433.04 75.816 18,957.96 135-55070-030-000 Independent Labor 154,000.00 154,000.00 14,005.34 101,827.93 66.122 52,172.07 135-55080-030-000 Maintenance & Repairs 14,000.00 14,000.00 14.52 5,160.69 36.862 8,839.31 135-55085-030-000 Generator Maint. and Repair 10,000.00 10,000.00 3,955.00 39.550 6,045.00 135-55120-030-000 Cleaning Services 10,000.00 10,000.00 869.06 5,700.51 57.005 4,299.49 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 576.19 4,705.92 52.288 4,294.08 Subtotal: 338,916.00 338,916.00 21,491.25 240,023.09 70.821 98,892.91 135-60005-030-000 Telephone 27,300.00 27,300.00 1,849.79 11,857.33 43.433 15,442.67 135-60010-030-000 Communications/Mobiles 4,000.00 4,000.00 237.37 2,036.80 50.920 1,963.20 135-60020-030-000 Electricity/Gas 16,261.00 16,261.00 3,852.21 23.690 12,408.79 135-60025-030-000 Water 2,500.00 2,500.00 58.32- 339.12 13.565 2,160.88 135-60030-030-000 Rent And/Or Usage 616.40 616.40- 135-60035-030-000 Postage 30,000.00 30,000.00 1,579.66 14,557.37 48.525 15,442.63 135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 4,364.10 38,717.32 69.686 16,842.68 135-60050-030-000 Bad Debt Expense 1,500.00 1,500.00 1,500.00 135-60055-030-000 Insurance 56,000.00 56,000.00 6,100.36 52,077.88 92.996 3,922.12 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 31.88 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 132.60 843.72 17.272 4,041.28 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 June 18, 2018 Regular Meeting Agenda Packet 60 of 150 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 11 22:05 06/13/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/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 96.00 3.556 2,604.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 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 14,237.44 132,958.94 53.289 116,547.06 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 497.74 2,006.68 27.044 5,413.32 135-65085-030-000 Office Supplies 7,000.00 7,000.00 263.84 3,586.24 51.232 3,413.76 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 81.70 3,267.45 81.686 732.55 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 843.28 11,326.76 45.091 13,793.24 135-69005-030-000 Capital Outlays 13,000.00 13,000.00 8,500.00 37,327.32 287.133 24,327.32- 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 266.02 1,990.55 43.273 2,609.45 Subtotal: 17,600.00 17,600.00 8,766.02 39,317.87 223.397 21,717.87- Program number: 1,227,112.00 1,227,112.00 89,872.61 762,152.79 62.109 464,959.21 Department number: Administration 1,227,112.00 1,227,112.00 89,872.61 762,152.79 62.109 464,959.21 June 18, 2018 Regular Meeting Agenda Packet 61 of 150 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 12 22:05 06/13/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 5/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 16,508.38 59,261.93 43.257 77,738.07 135-55055-039-000 Auditing 24,500.00 24,500.00 150.00 25,658.70 104.729 1,158.70- 135-55060-039-000 Appraisal 11,446.00 11,446.00 2,011.87 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 18,670.25 96,572.95 54.639 80,173.05 Program number: 176,746.00 176,746.00 18,670.25 96,572.95 54.639 80,173.05 Department number: Non Departmental 176,746.00 176,746.00 18,670.25 96,572.95 54.639 80,173.05 Expenditures Subtotal ----------- 10,055,411.00 10,055,411.00 762,674.18 5,982,712.78 59.497 4,072,698.22 Fund number: 135 MUD 1 General Fund 194,618.00- 194,618.00- 1,124,410.65- 1,315,517.27- 675.948 1,120,899.27 June 18, 2018 Regular Meeting Agenda Packet 62 of 150 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 13 22:05 06/13/18 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 5/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 June 18, 2018 Regular Meeting Agenda Packet 63 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 5 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/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 1476 05/01/2018 Property Taxes (120,345.17) (12.03) (120,357.20) GL 1477 05/02/2018 Property Taxes (2.31) (120,359.51) GL 1478 05/03/2018 Property Taxes (13.41) (120,372.92) GL 1479 05/04/2018 Property Taxes (5.52) (120,378.44) GL 1480 05/07/2018 Property Taxes (152.22) (120,530.66) GL 1481 05/09/2018 Property Taxes (38.11) (120,568.77) GL 1482 05/10/2018 Property Taxes (6.32) (120,575.09) GL 1483 05/11/2018 Property Taxes (66.33) (120,641.42) GL 1484 05/14/2018 Property Taxes (89.60) (120,731.02) GL 1485 05/15/2018 Property Taxes (4.78) (120,735.80) GL 1486 05/16/2018 Property Taxes (115.69) (120,851.49) GL 1487 05/17/2018 Property Taxes (43.51) (120,895.00) GL 1488 05/18/2018 Property Taxes (6.06) (120,901.06) GL 1489 05/21/2018 Property Taxes (10.57) (120,911.63) GL 1490 05/22/2018 Property Taxes (6.80) (120,918.43) GL 1491 05/23/2018 Property Taxes (63.97) (120,982.40) GL 1492 05/24/2018 Property Taxes (179.33) (121,161.73) GL 1493 05/25/2018 Property Taxes (9.98) (121,171.71) GL 1495 05/29/2018 Property Taxes (35.84) (121,207.55) GL 1496 05/30/2018 Property Taxes (52.14) (121,259.69) GL 1497 05/31/2018 Property Taxes (90.96) (121,350.65) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (1,005.48) (121,350.65) ** (120,950.00) Budgeted 400.65 Remaining 100 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1477 05/02/2018 Property Taxes (230.75) (78.60) (309.35) GL 1481 05/09/2018 Property Taxes (1.06) (310.41) GL 1491 05/23/2018 Property Taxes 1.10 (309.31) GL 1495 05/29/2018 Property Taxes (34.29) (343.60) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (112.85) (343.60) ** (200.00) Budgeted 143.60 Remaining 172 % Used Account: 135-40015-000-000 Property Taxes/P & I 1476 05/01/2018 Property Taxes (363.05) (1.52) (364.57) GL 1477 05/02/2018 Property Taxes (12.91) (377.48) GL 1478 05/03/2018 Property Taxes (1.47) (378.95) GL 1479 05/04/2018 Property Taxes (1.02) (379.97) GL 1480 05/07/2018 Property Taxes (18.80) (398.77) GL June 18, 2018 Regular Meeting Agenda Packet 64 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 6 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1481 05/09/2018 Property Taxes (363.05) (7.91) (406.68) GL 1483 05/11/2018 Property Taxes (7.08) (413.76) GL 1484 05/14/2018 Property Taxes (5.60) (419.36) GL 1486 05/16/2018 Property Taxes (12.85) (432.21) GL 1487 05/17/2018 Property Taxes (2.75) (434.96) GL 1490 05/22/2018 Property Taxes (.31) (435.27) GL 1491 05/23/2018 Property Taxes (2.47) (437.74) GL 1492 05/24/2018 Property Taxes (18.29) (456.03) GL 1495 05/29/2018 Property Taxes (24.32) (480.35) GL 1496 05/30/2018 Property Taxes (5.27) (485.62) GL 1497 05/31/2018 Property Taxes (6.70) (492.32) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (129.27) (492.32) ** (200.00) Budgeted 292.32 Remaining 246 % Used Account: 135-40025-000-000 PID Surcharges .00 .00 _______________ Account: 135-40025-000-000 PID Surcharges Totals: .00 .00 ** (177,839.00) Budgeted (177,839.00) Remaining 0 % Used Account: 135-47000-000-000 Water 1457 05/31/2018 UB 05/2018 Billing UB20180531-20180531 User: (2,640,649.08) (498,952.46) (3,139,601.54) UB _______________ Account: 135-47000-000-000 Water Totals: (498,952.46) (3,139,601.54) ** (6,464,019.00) Budgeted (3,324,417.46) Remaining 49 % Used Account: 135-47005-000-000 Sewer 1373 05/11/2018 UB 05/11/2018 Sewer refund UB20180511-20180511 User: (1,683,847.74) 925.70 (1,682,922.04) UB 1380 05/14/2018 UB 05/14/2018 WA adjustments UB20180514-20180514 User: 145.99 (1,682,776.05) UB 1408 05/21/2018 UB 05/21/2018 WA Adjustment UB20180521-20180521 User: 168.29 (1,682,607.76) UB 1418 05/22/2018 UB 05/22/2018 WA adjustment UB20180522-20180522 User: 76.18 (1,682,531.58) UB 1427 05/24/2018 UB 05/24/2018 WA adjustment UB20180524-20180524 User: 85.04 (1,682,446.54) UB 1457 05/31/2018 UB 05/2018 Billing UB20180531-20180531 User: (261,150.43) (1,943,596.97) UB _______________ Account: 135-47005-000-000 Sewer Totals: (259,749.23) (1,943,596.97) ** (2,978,067.00) Budgeted (1,034,470.03) Remaining 65 % Used Account: 135-47025-000-000 Penalties June 18, 2018 Regular Meeting Agenda Packet 65 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 7 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1351 05/09/2018 UB 05/09/2018 Penalty removal UB20180509-20180509 User: (64,594.49) 70.39 (64,524.10) UB 1420 05/22/2018 UB 05/2018 Cal/Assess Penalty UB20180522-20180522 User: (7,625.09) (72,149.19) UB 1447 05/30/2018 UB 05/30/2018 Penalty removal UB20180530-20180530 User: 86.88 (72,062.31) UB _______________ Account: 135-47025-000-000 Penalties Totals: (7,467.82) (72,062.31) ** (106,279.00) Budgeted (34,216.69) Remaining 68 % Used Account: 135-47030-000-000 Service Charges 1352 05/09/2018 UB 05/2018 Disconnect Fees UB20180509-20180509 User: (8,450.00) (850.00) (9,300.00) UB 1423 05/22/2018 UB 05/22/2018 NSF checks UB20180522-20180522 User: (25.00) (9,325.00) UB 1424 05/23/2018 UB 05/23/2018 NSF checks UB20180523-20180523 User: (75.00) (9,400.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (950.00) (9,400.00) ** (21,350.00) Budgeted (11,950.00) Remaining 44 % Used Account: 135-47035-000-000 Plumbing Inspections 1440 05/02/2018 Permits-501 Asheville Lane 501 Asheville Lane (1,500.00) (50.00) (1,550.00) Ashton Woods Homes CR 1439 05/08/2018 Permits-18 Sadie OCurt 501 Asheville lane (50.00) (1,600.00) Ashton Woods Homes CR 1439 05/08/2018 Permits-18 Sadie OCurt 18 Sadie Court (50.00) (1,650.00) Drees Coustom Homes CR 1439 05/08/2018 Permits-18 Sadie OCurt 18 Sadie Court 50.00 (1,600.00) Drees Custom Homes CR 1439 05/08/2018 Permits-18 Sadie OCurt 501 Asheville lane 50.00 (1,550.00) Ashton Woods Homes CR 1439 05/08/2018 Permits-18 Sadie OCurt 18 Sadie Court (50.00) (1,600.00) Drees Custom Homes CR 1441 05/29/2018 Permits-507 Fisher/654 Sheldon 654 Sheldon Drive (50.00) (1,650.00) Ashton Wood Homes CR 1441 05/29/2018 Permits-507 Fisher/654 Sheldon 507 Fisher Drive (50.00) (1,700.00) Ashton Wood Homes CR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (200.00) (1,700.00) ** (1,500.00) Budgeted 200.00 Remaining 113 % Used Account: 135-47045-000-000 Sewer Inspections 1440 05/02/2018 Permits-501 Asheville Lane 501 Asheville Lane (3,700.00) (150.00) (3,850.00) Ashton Woods Homes CR 1439 05/08/2018 Permits-18 Sadie OCurt 501 Asheville lane (150.00) (4,000.00) Ashton Woods Homes CR 1439 05/08/2018 Permits-18 Sadie OCurt 18 Sadie Court (150.00) (4,150.00) Drees Coustom Homes CR 1439 05/08/2018 Permits-18 Sadie OCurt 18 Sadie Court 150.00 (4,000.00) Drees Custom Homes CR 1439 05/08/2018 Permits-18 Sadie OCurt 501 Asheville lane 150.00 (3,850.00) Ashton Woods Homes CR 1439 05/08/2018 Permits-18 Sadie OCurt 18 Sadie Court (150.00) (4,000.00) Drees Custom Homes CR 1441 05/29/2018 Permits-507 Fisher/654 Sheldon 654 Sheldon Drive (150.00) (4,150.00) Ashton Wood Homes CR 1441 05/29/2018 Permits-507 Fisher/654 Sheldon 507 Fisher Drive (150.00) (4,300.00) Ashton Wood Homes CR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (600.00) (4,300.00) ** (4,500.00) Budgeted (200.00) Remaining 96 % Used June 18, 2018 Regular Meeting Agenda Packet 66 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 8 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-47070-000-000 TCCC Effluent Charges 1457 05/31/2018 UB 05/2018 Billing UB20180531-20180531 User: (16,310.40) (10,885.60) (27,196.00) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (10,885.60) (27,196.00) ** (60,000.00) Budgeted (32,804.00) Remaining 45 % Used Account: 135-49010-000-000 Interest Income 1538 05/31/2018 Bank Interest- May (25,571.00) (151.80) (25,722.80) GL 1538 05/31/2018 Bank Interest- May (331.88) (26,054.68) GL 1538 05/31/2018 Bank Interest- May (4,591.09) (30,645.77) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (5,074.77) (30,645.77) ** (12,000.00) Budgeted 18,645.77 Remaining 255 % Used Account: 135-49016-000-000 Cell Tower Revenue (7,762.20) .00 (7,762.20) _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: .00 (7,762.20) ** (10,926.00) Budgeted (3,163.80) Remaining 71 % Used Account: 135-49018-000-000 Building Rent Income 1544 05/31/2018 Town BIlled Invoices 1640-1643 AR 20180531-20180531 User: (4,083.31) (583.33) (4,666.64) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (4,666.64) ** (7,000.00) Budgeted (2,333.36) Remaining 67 % 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 1440 05/02/2018 Permits-501 Asheville Lane 501 Asheville Lane (9,434.76) (343.00) (9,777.76) Ashton Woods Homes CR 1439 05/08/2018 Permits-18 Sadie OCurt 501 Asheville lane (343.00) (10,120.76) Ashton Woods Homes CR 1439 05/08/2018 Permits-18 Sadie OCurt 18 Sadie Court (343.00) (10,463.76) Drees Coustom Homes CR 1439 05/08/2018 Permits-18 Sadie OCurt 18 Sadie Court 343.00 (10,120.76) Drees Custom Homes CR 1439 05/08/2018 Permits-18 Sadie OCurt 501 Asheville lane 343.00 (9,777.76) Ashton Woods Homes CR June 18, 2018 Regular Meeting Agenda Packet 67 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 9 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1439 05/08/2018 Permits-18 Sadie OCurt 18 Sadie Court (9,434.76) (343.00) (10,120.76) Drees Custom Homes CR 1441 05/29/2018 Permits-507 Fisher/654 Sheldon 654 Sheldon Drive (343.00) (10,463.76) Ashton Wood Homes CR 1441 05/29/2018 Permits-507 Fisher/654 Sheldon 507 Fisher Drive (343.00) (10,806.76) Ashton Wood Homes CR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (1,372.00) (10,806.76) ** (18,179.00) Budgeted (7,372.24) Remaining 59 % Used Account: 135-49141-000-000 Interfund Transfer In 1519 05/31/2018 Texpool Transfers May (796,145.08) (1,053,984.38) (1,850,129.46) GL _______________ Account: 135-49141-000-000 Interfund Transfer In Totals: (1,053,984.38) (1,850,129.46) ** .00 Budgeted 1,850,129.46 Remaining 0 % Used Account: 135-49900-000-000 Miscellaneous Income 1331 05/01/2018 JSB NSA Inv# 1639 *Reissued AR 20180501-20180501 User: (12,758.19) (45,000.00) (57,758.19) AR 1440 05/02/2018 Permits-501 Asheville Lane 501 Asheville Lane (800.00) (58,558.19) Ashton Woods Homes CR 1439 05/08/2018 Permits-18 Sadie OCurt 501 ASheville Lane (800.00) (59,358.19) Ashton Woods Homes CR 1439 05/08/2018 Permits-18 Sadie OCurt 501 ASheville Lane 800.00 (58,558.19) Ashton Woods Homes CR 1457 05/31/2018 UB 05/2018 Billing UB20180531-20180531 User: (217.64) (58,775.83) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (46,017.64) (58,775.83) ** (5,000.00) Budgeted 53,775.83 Remaining 1.176 % 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 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: ----------------------------------- (7,298,230.05) ** (1,887,084.83) Monthly Total (10,250,029.00) Budgeted (2,951,798.95) Remaining 71 % Used June 18, 2018 Regular Meeting Agenda Packet 68 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/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 1290 05/04/2018 MUD PR 05.04.18 Salaries & Wages 118,432.50 9,850.28 128,282.78 PR 1388 05/18/2018 MUD PR 05/18/18 Salaries & Wages 9,899.22 138,182.00 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 19,749.50 138,182.00 ** 274,279.00 Budgeted 136,097.00 Remaining 50 % Used Account: 135-50010-010-000 Overtime 1290 05/04/2018 MUD PR 05.04.18 Overtime 5,510.70 654.20 6,164.90 PR 1388 05/18/2018 MUD PR 05/18/18 Overtime 353.48 6,518.38 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,007.68 6,518.38 ** 20,000.00 Budgeted 13,481.62 Remaining 33 % 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 1388 05/18/2018 MUD PR 05/18/18 Certification 1,250.00 150.00 1,400.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 150.00 1,400.00 ** 3,300.00 Budgeted 1,900.00 Remaining 42 % Used Account: 135-50020-010-000 Retirement 1290 05/04/2018 MUD PR 05.04.18 Retirement 13,296.50 971.67 14,268.17 PR 1388 05/18/2018 MUD PR 05/18/18 Retirement 962.24 15,230.41 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,933.91 15,230.41 ** 27,843.00 Budgeted 12,612.59 Remaining 55 % Used Account: 135-50026-010-000 Medical Insurance 1290 05/04/2018 MUD PR 05.04.18 Medical Insurance 18,055.83 1,474.40 19,530.23 PR 1388 05/18/2018 MUD PR 05/18/18 Medical Insurance 1,474.40 21,004.63 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,948.80 21,004.63 ** 52,196.00 Budgeted 31,191.37 Remaining 40 % Used June 18, 2018 Regular Meeting Agenda Packet 69 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-010-000 Dental Insurance 1290 05/04/2018 MUD PR 05.04.18 Dental Insurance 1,521.04 106.85 1,627.89 PR 1388 05/18/2018 MUD PR 05/18/18 Dental Insurance 106.80 1,734.69 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 213.65 1,734.69 ** 5,182.00 Budgeted 3,447.31 Remaining 33 % Used Account: 135-50028-010-000 Vision Insurance 1290 05/04/2018 MUD PR 05.04.18 Vision Insurance 280.23 17.98 298.21 PR 1388 05/18/2018 MUD PR 05/18/18 Vision Insurance 17.94 316.15 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 35.92 316.15 ** 994.00 Budgeted 677.85 Remaining 32 % Used Account: 135-50029-010-000 Life Insurance & Other 1413 05/21/2018 May A/P Dental and life benefits 1,674.71 110.60 1,785.31 Humana Inc 4204 AP 1458 05/31/2018 May a/p Flex admin fee 18.00 1,803.31 BenefitMall 4226 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 128.60 1,803.31 ** 2,982.00 Budgeted 1,178.69 Remaining 60 % Used Account: 135-50030-010-000 Social Security Taxes 1290 05/04/2018 MUD PR 05.04.18 Social Security Taxes 7,903.81 644.87 8,548.68 PR 1388 05/18/2018 MUD PR 05/18/18 Social Security Taxes 664.51 9,213.19 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,309.38 9,213.19 ** 18,662.00 Budgeted 9,448.81 Remaining 49 % Used Account: 135-50035-010-000 Medicare Taxes 1290 05/04/2018 MUD PR 05.04.18 Medicare Taxes 1,848.45 150.84 1,999.29 PR 1388 05/18/2018 MUD PR 05/18/18 Medicare Taxes 155.40 2,154.69 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 306.24 2,154.69 ** 4,365.00 Budgeted 2,210.31 Remaining 49 % Used Account: 135-50040-010-000 Unemployment Taxes 1290 05/04/2018 MUD PR 05.04.18 Unemployment Taxes 808.42 10.26 818.68 PR June 18, 2018 Regular Meeting Agenda Packet 70 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 12 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 10.26 818.68 ** 1,080.00 Budgeted 261.32 Remaining 76 % Used Account: 135-50045-010-000 Workman's Compensation 239 05/01/2018 Insurance/Wrk Comp Exp May 6,299.44 899.92 7,199.36 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 899.92 7,199.36 ** 11,854.00 Budgeted 4,654.64 Remaining 61 % 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 1413 05/21/2018 May A/P Chlorinator refill 48,666.04 666.88 49,332.92 SCOOP 4218 AP 1413 05/21/2018 May A/P Meter SPuds 240.30 49,573.22 Core & Main LP 4198 AP 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 AMAZON.COM 11.09 49,584.31 AMAZON.COM PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 ROANOKE AUTO SUPPLY LT 22.99 49,607.30 ROANOKE AUTO SUPPLY LT PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 THE HOME DEPOT #6581 15.96 49,623.26 THE HOME DEPOT #6581 PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 THE HOME DEPOT #6581 64.53 49,687.79 THE HOME DEPOT #6581 PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 THE HOME DEPOT #6581 31.22 49,719.01 THE HOME DEPOT #6581 PC 1458 05/31/2018 May a/p Meter spuds 450.60 50,169.61 Core & Main LP 4231 AP June 18, 2018 Regular Meeting Agenda Packet 71 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 13 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/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-55080-010-000 Maintenance & Repairs Totals: 1,503.57 50,169.61 ** 100,000.00 Budgeted 49,830.39 Remaining 50 % 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 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 DENTON COUNTY, TX SOUT 3,853.07 1.00 3,854.07 DENTON COUNTY, TX SOUT PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 DENTON COUNTY, TX SOUT 8.25 3,862.32 DENTON COUNTY, TX SOUT PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 KWIK KAR LUBE & TUNE O 25.50 3,887.82 KWIK KAR LUBE & TUNE O PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 34.75 3,887.82 ** 4,000.00 Budgeted 112.18 Remaining 97 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader .00 .00 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-55135-010-000 Lab Analysis 1413 05/21/2018 May A/P Bio monitoring 3,605.16 1,080.00 4,685.16 HUTHER AND ASSOCIATES,INC 4206 AP 1413 05/21/2018 May A/P Bio monitoring 1,080.00 5,765.16 HUTHER AND ASSOCIATES,INC 4206 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 2,160.00 5,765.16 ** 5,500.00 Budgeted (265.16) Remaining 105 % Used Account: 135-60010-010-000 Communications/Mobiles 1366 05/10/2018 May A/P Cell phones 2,122.44 370.18 2,492.62 VERIZON WIRELESS 4193 AP _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 370.18 2,492.62 ** 4,700.00 Budgeted 2,207.38 Remaining 53 % Used Account: 135-60020-010-000 Electricity June 18, 2018 Regular Meeting Agenda Packet 72 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 14 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1413 05/21/2018 May A/P Electricity 4/10-5/19 73,159.82 9,001.73 82,161.55 HUDSON ENERGY SERVICES, LLC 4205 AP _______________ Account: 135-60020-010-000 Electricity Totals: 9,001.73 82,161.55 ** 175,356.00 Budgeted 93,194.45 Remaining 47 % 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 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 360 WATER INC 1,395.78 30.00 1,425.78 360 WATER INC PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 TCEQ EPAYMENT 111.00 1,536.78 TCEQ EPAYMENT PC _______________ Account: 135-60080-010-000 Schools & Training Totals: 141.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 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 June 18, 2018 Regular Meeting Agenda Packet 73 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 15 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-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 1458 05/31/2018 May a/p Wholesale water 962,751.81 58,261.27 1,021,013.08 CITY OF FORT WORTH 4230 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 58,261.27 1,021,013.08 ** 2,823,170.00 Budgeted 1,802,156.92 Remaining 36 % 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 1503 05/31/2018 May A/P Mowing may 4,500.00 1,500.00 6,000.00 WATTS ELLISON LLC 4274 AP _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: 1,500.00 6,000.00 ** 14,750.00 Budgeted 8,750.00 Remaining 41 % Used Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S 1519 05/31/2018 Texpool Transfers May 176,962.17 25,280.31 202,242.48 GL June 18, 2018 Regular Meeting Agenda Packet 74 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/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-60332-010-000 Interfund Transfer Out-Rev I&S Totals: 25,280.31 202,242.48 ** 278,084.00 Budgeted 75,841.52 Remaining 73 % Used Account: 135-60333-010-000 Interfund Transfer Out-Reserve 1519 05/31/2018 Texpool Transfers May 28,581.00 4,083.00 32,664.00 GL 1551 05/31/2018 TexPool Transfer May Adj TexPool shorted transfr JE1519 (15.00) 32,649.00 GL _______________ Account: 135-60333-010-000 Interfund Transfer Out-Reserve Totals: 4,068.00 32,649.00 ** 48,996.00 Budgeted 16,347.00 Remaining 67 % 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 1450 05/30/2018 May A/P Fuel 5,779.30 1,186.68 6,965.98 US Bank Voyager Fleet Systems 4269 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 1,186.68 6,965.98 ** 15,000.00 Budgeted 8,034.02 Remaining 46 % Used Account: 135-65010-010-000 Uniforms 1,249.14 .00 1,249.14 _______________ 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 1458 05/31/2018 May a/p chlorine 10,731.77 884.96 11,616.73 DPC INDUSTRIES, INC 4237 AP June 18, 2018 Regular Meeting Agenda Packet 75 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1503 05/31/2018 May A/P Testing supplies 10,731.77 342.11 11,958.84 HACH COMPANY 4243 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 1,227.07 11,958.84 ** 20,000.00 Budgeted 8,041.16 Remaining 60 % 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 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 KELLER TROPHY & AWAR 192.00 391.00 583.00 KELLER TROPHY & AWAR PC _______________ Account: 135-65040-010-000 Safety Equipment Totals: 391.00 583.00 ** 1,000.00 Budgeted 417.00 Remaining 58 % Used Account: 135-65050-010-000 Meter Expense 1413 05/21/2018 May A/P Meters 16,091.00 5,011.00 21,102.00 ATLAS UTILITY SUPPLY CO. 4196 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 5,011.00 21,102.00 ** 50,000.00 Budgeted 28,898.00 Remaining 42 % 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 1413 05/21/2018 May A/P 16" water line to town center 365,542.05 576.28 366,118.33 Halff Associates, INC 4202 AP 1458 05/31/2018 May a/p Indian Creek & Phoenix Drive 153,420.01 519,538.34 Quality Excavation, LTD 4260 AP 1503 05/31/2018 May A/P Phoenix Drive 6,000.00 525,538.34 TEAGUE, NALL & PERKINS,INC 4268 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 159,996.29 525,538.34 ** 810,012.00 Budgeted 284,473.66 Remaining 65 % Used Account: 135-69008-010-000 Short Term Debt-Principal June 18, 2018 Regular Meeting Agenda Packet 76 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 18 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-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 June 18, 2018 Regular Meeting Agenda Packet 77 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 19 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 5/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,495,140.99 ** 298,826.71 Monthly Total 5,657,433.00 Budgeted 2,162,292.01 Remaining 62 % Used June 18, 2018 Regular Meeting Agenda Packet 78 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/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 1290 05/04/2018 MUD PR 05.04.18 Salaries & Wages 210,111.04 12,604.84 222,715.88 PR 1388 05/18/2018 MUD PR 05/18/18 Salaries & Wages 12,602.81 235,318.69 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 25,207.65 235,318.69 ** 410,866.00 Budgeted 175,547.31 Remaining 57 % Used Account: 135-50010-020-000 Overtime 1290 05/04/2018 MUD PR 05.04.18 Overtime 19,634.62 2,244.93 21,879.55 PR 1388 05/18/2018 MUD PR 05/18/18 Overtime 1,721.26 23,600.81 PR _______________ Account: 135-50010-020-000 Overtime Totals: 3,966.19 23,600.81 ** 30,000.00 Budgeted 6,399.19 Remaining 79 % 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 1388 05/18/2018 MUD PR 05/18/18 Certification 4,936.00 700.00 5,636.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 700.00 5,636.00 ** 8,400.00 Budgeted 2,764.00 Remaining 67 % Used Account: 135-50020-020-000 Retirement 1290 05/04/2018 MUD PR 05.04.18 Retirement 23,848.14 1,373.59 25,221.73 PR 1388 05/18/2018 MUD PR 05/18/18 Retirement 1,389.73 26,611.46 PR _______________ Account: 135-50020-020-000 Retirement Totals: 2,763.32 26,611.46 ** 42,243.00 Budgeted 15,631.54 Remaining 63 % Used Account: 135-50026-020-000 Medical Insurance 1290 05/04/2018 MUD PR 05.04.18 Medical Insurance 37,974.64 2,759.36 40,734.00 PR 1388 05/18/2018 MUD PR 05/18/18 Medical Insurance 2,759.33 43,493.33 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 5,518.69 43,493.33 ** 62,175.00 Budgeted 18,681.67 Remaining 70 % Used June 18, 2018 Regular Meeting Agenda Packet 79 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-020-000 Dental Insurance 1290 05/04/2018 MUD PR 05.04.18 Dental Insurance 2,832.29 185.96 3,018.25 PR 1388 05/18/2018 MUD PR 05/18/18 Dental Insurance 185.93 3,204.18 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 371.89 3,204.18 ** 5,271.00 Budgeted 2,066.82 Remaining 61 % Used Account: 135-50028-020-000 Vision Insurance 1290 05/04/2018 MUD PR 05.04.18 Vision Insurance 508.36 29.46 537.82 PR 1388 05/18/2018 MUD PR 05/18/18 Vision Insurance 29.44 567.26 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 58.90 567.26 ** 1,114.00 Budgeted 546.74 Remaining 51 % Used Account: 135-50029-020-000 Life Insurance & Other 1413 05/21/2018 May A/P Dental and life benefits 2,989.82 136.36 3,126.18 Humana Inc 4204 AP 1458 05/31/2018 May a/p Flex admin fee 36.00 3,162.18 BenefitMall 4226 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 172.36 3,162.18 ** 4,281.00 Budgeted 1,118.82 Remaining 74 % Used Account: 135-50030-020-000 Social Security Taxes 1290 05/04/2018 MUD PR 05.04.18 Social Security Taxes 13,976.06 843.09 14,819.15 PR 1388 05/18/2018 MUD PR 05/18/18 Social Security Taxes 831.02 15,650.17 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,674.11 15,650.17 ** 28,314.00 Budgeted 12,663.83 Remaining 55 % Used Account: 135-50035-020-000 Medicare Taxes 1290 05/04/2018 MUD PR 05.04.18 Medicare Taxes 3,268.59 197.18 3,465.77 PR 1388 05/18/2018 MUD PR 05/18/18 Medicare Taxes 194.34 3,660.11 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 391.52 3,660.11 ** 6,622.00 Budgeted 2,961.89 Remaining 55 % Used Account: 135-50040-020-000 Unemployment Taxes 1,134.00 .00 1,134.00 June 18, 2018 Regular Meeting Agenda Packet 80 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 1,134.00 ** 1,260.00 Budgeted 126.00 Remaining 90 % Used Account: 135-50045-020-000 Workman's Compensation 239 05/01/2018 Insurance/Wrk Comp Exp May 9,436.00 1,348.00 10,784.00 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 1,348.00 10,784.00 ** 17,990.00 Budgeted 7,206.00 Remaining 60 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 1367 05/10/2018 May A/P Post accident testing 63.00 63.00 CARENOW CORPORATE 4167 AP _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: 63.00 63.00 ** 300.00 Budgeted 237.00 Remaining 21 % 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 1413 05/21/2018 May A/P Grit bags' 36,495.26 1,300.00 37,795.26 Huber Technology Inc 4203 AP 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 THE HOME DEPOT #6581 46.29 37,841.55 THE HOME DEPOT #6581 PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 ROANOKE AUTO SUPPLY LT 37.72 37,879.27 ROANOKE AUTO SUPPLY LT PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 THE HOME DEPOT #6581 48.25 37,927.52 THE HOME DEPOT #6581 PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 THE HOME DEPOT #6581 6.70 37,934.22 THE HOME DEPOT #6581 PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 FILTER ELEMENT STORE 173.65 38,107.87 FILTER ELEMENT STORE PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 THE HOME DEPOT #6581 32.56 38,140.43 THE HOME DEPOT #6581 PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 THE HOME DEPOT #6581 44.95 38,185.38 THE HOME DEPOT #6581 PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 TRACTOR SUPPLY COMPANY 159.99 38,345.37 TRACTOR SUPPLY COMPANY PC June 18, 2018 Regular Meeting Agenda Packet 81 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 23 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1458 05/31/2018 May a/p VFD and bar screens 36,495.26 490.00 38,835.37 DHS AUTOMATION, INC 4236 AP 1458 05/31/2018 May a/p VFD and bar screens 5,416.00 44,251.37 DHS AUTOMATION, INC 4236 AP 1503 05/31/2018 May A/P Connect pump @ LS #9Dumpster s 170.00 44,421.37 Walker Industrial LLC 4273 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 7,926.11 44,421.37 ** 86,100.00 Budgeted 41,678.63 Remaining 52 % 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 6,353.60 .00 6,353.60 _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: .00 6,353.60 ** 8,000.00 Budgeted 1,646.40 Remaining 79 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 289.69 .00 289.69 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 289.69 ** 500.00 Budgeted 210.31 Remaining 58 % Used Account: 135-55125-020-000 Dumpster Services 1413 05/21/2018 May A/P Dumpster services 50,181.61 888.10 51,069.71 L.H. CHANEY MATERIALS, INC. 4211 AP 1413 05/21/2018 May A/P Dumpster servies 2,035.18 53,104.89 L.H. CHANEY MATERIALS, INC. 4211 AP 1458 05/31/2018 May a/p Sludge haul off 1,972.23 55,077.12 L.H. CHANEY MATERIALS, INC. 4250 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 4,895.51 55,077.12 ** 60,000.00 Budgeted 4,922.88 Remaining 92 % Used Account: 135-55135-020-000 Lab Analysis 1333 05/07/2018 May A/P CIP soultion 20,529.42 674.60 21,204.02 Valley Solvent Company, INC 4192 AP 1362 05/10/2018 May A/P Lab Services 246.00 21,450.02 OXIDOR LABORATORIES LLC 4184 AP 1413 05/21/2018 May A/P Lab results 176.00 21,626.02 OXIDOR LABORATORIES LLC 4217 AP 1413 05/21/2018 May A/P Effluent testing 176.00 21,802.02 OXIDOR LABORATORIES LLC 4217 AP June 18, 2018 Regular Meeting Agenda Packet 82 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 24 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1458 05/31/2018 May a/p Effluent testing 20,529.42 246.00 22,048.02 OXIDOR LABORATORIES LLC 4258 AP 1458 05/31/2018 May a/p Effluent testing 246.00 22,294.02 OXIDOR LABORATORIES LLC 4258 AP 1503 05/31/2018 May A/P lab testing 246.00 22,540.02 OXIDOR LABORATORIES LLC 4258 AP 1503 05/31/2018 May A/P Lab testing 176.00 22,716.02 OXIDOR LABORATORIES LLC 4258 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 2,186.60 22,716.02 ** 30,000.00 Budgeted 7,283.98 Remaining 76 % Used Account: 135-60010-020-000 Communications/Mobiles 1366 05/10/2018 May A/P Cell phones 2,865.72 527.28 3,393.00 VERIZON WIRELESS 4193 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 527.28 3,393.00 ** 4,700.00 Budgeted 1,307.00 Remaining 72 % Used Account: 135-60020-020-000 Electricity 1413 05/21/2018 May A/P Electricity 4/10-5/19 99,534.05 10,896.78 110,430.83 HUDSON ENERGY SERVICES, LLC 4205 AP 1544 05/31/2018 Town BIlled Invoices 1640-1643 AR 20180531-20180531 User: (157.45) 110,273.38 AR _______________ Account: 135-60020-020-000 Electricity Totals: 10,739.33 110,273.38 ** 266,709.00 Budgeted 156,435.62 Remaining 41 % Used Account: 135-60066-020-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60070-020-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-020-000 Dues & Memberships Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-60080-020-000 Schools & Training 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 PAYPAL *TEXASWATERW 222.00 325.00 547.00 PAYPAL *TEXASWATERW PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 TCEQ EPAYMENT 111.00 658.00 TCEQ EPAYMENT PC _______________ Account: 135-60080-020-000 Schools & Training Totals: 436.00 658.00 ** 5,677.00 Budgeted 5,019.00 Remaining 12 % Used June 18, 2018 Regular Meeting Agenda Packet 83 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/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-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 .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 June 18, 2018 Regular Meeting Agenda Packet 84 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 THE HOME DEPOT #6581 19.97 19.97 THE HOME DEPOT #6581 PC _______________ Account: 135-60280-020-000 Property Maintenance Totals: 19.97 19.97 ** 4,000.00 Budgeted 3,980.03 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 1503 05/31/2018 May A/P Mowing may 3,540.00 1,060.00 4,600.00 WATTS ELLISON LLC 4274 AP _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 1,060.00 4,600.00 ** 11,600.00 Budgeted 7,000.00 Remaining 40 % Used Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S 1519 05/31/2018 Texpool Transfers May 77,663.67 11,094.81 88,758.48 GL _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 11,094.81 88,758.48 ** 122,043.00 Budgeted 33,284.52 Remaining 73 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S 1519 05/31/2018 Texpool Transfers May 381,015.04 54,430.72 435,445.76 GL _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: 54,430.72 435,445.76 ** 598,738.00 Budgeted 163,292.24 Remaining 73 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 1519 05/31/2018 Texpool Transfers May 71,946.00 10,278.00 82,224.00 GL 1551 05/31/2018 TexPool Transfer May Adj TexPool shorted transfr JE1519 (30.00) 82,194.00 GL _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 10,248.00 82,194.00 ** 123,336.00 Budgeted 41,142.00 Remaining 67 % Used Account: 135-60334-020-000 Interfund Transfer Out 1519 05/31/2018 Texpool Transfers May 201,031.99 201,031.99 GL _______________ Account: 135-60334-020-000 Interfund Transfer Out Totals: 201,031.99 201,031.99 ** 200,000.00 Budgeted (1,031.99) Remaining 101 % Used Account: 135-60360-020-000 Furniture/Equipment < $5000 June 18, 2018 Regular Meeting Agenda Packet 85 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 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 1450 05/30/2018 May A/P Fuel 5,340.19 925.48 6,265.67 US Bank Voyager Fleet Systems 4269 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 925.48 6,265.67 ** 12,500.00 Budgeted 6,234.33 Remaining 50 % 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 1362 05/10/2018 May A/P Polymer 5,281.23 2,760.00 8,041.23 POLYDYNE, INC 4185 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 2,760.00 8,041.23 ** 27,500.00 Budgeted 19,458.77 Remaining 29 % Used Account: 135-65035-020-000 Small Tools 1,149.94 .00 1,149.94 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 1,149.94 ** 1,000.00 Budgeted (149.94) Remaining 115 % Used Account: 135-65040-020-000 Safety Equipment 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 KELLER TROPHY & AWAR 750.97 391.00 1,141.97 KELLER TROPHY & AWAR PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 THE HOME DEPOT #6581 15.53 1,157.50 THE HOME DEPOT #6581 PC _______________ Account: 135-65040-020-000 Safety Equipment Totals: 406.53 1,157.50 ** 750.00 Budgeted (407.50) Remaining 154 % Used Account: 135-65045-020-000 Lab Supplies June 18, 2018 Regular Meeting Agenda Packet 86 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 28 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1413 05/21/2018 May A/P Latex gloves 10,700.58 162.00 10,862.58 LOU'S GLOVES INCORPORATED 4213 AP 1413 05/21/2018 May A/P E coli supplies 387.32 11,249.90 IDEXX DISTRIBUTION, INC 4207 AP 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 USA BLUE BOOK 90.61 11,340.51 USA BLUE BOOK PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 BED BATH & BEYOND #341 19.99 11,360.50 BED BATH & BEYOND #341 PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 BINDER INC. 2,123.31 13,483.81 BINDER INC. PC _______________ Account: 135-65045-020-000 Lab Supplies Totals: 2,783.23 13,483.81 ** 14,000.00 Budgeted 516.19 Remaining 96 % Used Account: 135-69005-020-000 Capital Outlays 1413 05/21/2018 May A/P Legal-WWTP 89,960.61 1,190.00 91,150.61 Dubois Bryant Campbell LLP 4200 AP _______________ Account: 135-69005-020-000 Capital Outlays Totals: 1,190.00 91,150.61 ** 547,327.00 Budgeted 456,176.39 Remaining 17 % 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 Department 20 Totals: ----------------------------------- 1,623,206.41 ** 354,897.19 Monthly Total 2,981,140.00 Budgeted 1,357,933.59 Remaining 54 % Used June 18, 2018 Regular Meeting Agenda Packet 87 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 29 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 5/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 239 05/01/2018 Insurance/Wrk Comp Exp May 16.94 2.42 19.36 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.42 19.36 ** 30.00 Budgeted 10.64 Remaining 65 % 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 1413 05/21/2018 May A/P AWBD-Greg Wilson 810.00 405.00 1,215.00 AWBD 4197 AP _______________ Account: 135-60075-026-000 Meetings Totals: 405.00 1,215.00 ** 1,200.00 Budgeted (15.00) Remaining 101 % 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 960.00 .00 960.00 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 960.00 ** 5,000.00 Budgeted 4,040.00 Remaining 19 % Used Account: 135-60245-026-000 Miscellaneous Expenses June 18, 2018 Regular Meeting Agenda Packet 88 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1,255.28 .00 1,255.28 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 1,255.28 ** 2,000.00 Budgeted 744.72 Remaining 63 % Used Department 26 Totals: ----------------------------------- 5,639.64 ** 407.42 Monthly Total 12,980.00 Budgeted 7,340.36 Remaining 43 % Used June 18, 2018 Regular Meeting Agenda Packet 89 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/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 1290 05/04/2018 MUD PR 05.04.18 Salaries & Wages 214,185.54 21,113.58 235,299.12 PR 1388 05/18/2018 MUD PR 05/18/18 Salaries & Wages 12,860.29 248,159.41 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 33,973.87 248,159.41 ** 432,863.00 Budgeted 184,703.59 Remaining 57 % Used Account: 135-50010-030-000 Overtime 1290 05/04/2018 MUD PR 05.04.18 Overtime 467.06 61.34 528.40 PR 1388 05/18/2018 MUD PR 05/18/18 Overtime 28.52 556.92 PR _______________ Account: 135-50010-030-000 Overtime Totals: 89.86 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 1290 05/04/2018 MUD PR 05.04.18 Retirement 22,490.45 1,958.67 24,449.12 PR 1388 05/18/2018 MUD PR 05/18/18 Retirement 1,192.22 25,641.34 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,150.89 25,641.34 ** 40,553.00 Budgeted 14,911.66 Remaining 63 % Used Account: 135-50026-030-000 Medical Insurance 1290 05/04/2018 MUD PR 05.04.18 Medical Insurance 27,338.45 2,072.63 29,411.08 PR 1388 05/18/2018 MUD PR 05/18/18 Medical Insurance 2,072.61 31,483.69 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,145.24 31,483.69 ** 63,485.00 Budgeted 32,001.31 Remaining 50 % Used Account: 135-50027-030-000 Dental Insurance 1290 05/04/2018 MUD PR 05.04.18 Dental Insurance 2,012.44 129.78 2,142.22 PR 1388 05/18/2018 MUD PR 05/18/18 Dental Insurance 129.74 2,271.96 PR June 18, 2018 Regular Meeting Agenda Packet 90 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/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: 259.52 2,271.96 ** 5,502.00 Budgeted 3,230.04 Remaining 41 % Used Account: 135-50028-030-000 Vision Insurance 1290 05/04/2018 MUD PR 05.04.18 Vision Insurance 383.92 21.28 405.20 PR 1388 05/18/2018 MUD PR 05/18/18 Vision Insurance 21.23 426.43 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 42.51 426.43 ** 1,173.00 Budgeted 746.57 Remaining 36 % Used Account: 135-50029-030-000 Life Insurance & Other 1413 05/21/2018 May A/P Dental and life benefits 2,454.75 145.04 2,599.79 Humana Inc 4204 AP 1257 05/31/2018 Clear Insurance Liab @ 05/2018 77.05 2,676.84 GL 1458 05/31/2018 May a/p Flex admin fee 18.00 2,694.84 BenefitMall 4226 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 240.09 2,694.84 ** 5,059.00 Budgeted 2,364.16 Remaining 53 % Used Account: 135-50030-030-000 Social Security Taxes 1290 05/04/2018 MUD PR 05.04.18 Social Security Taxes 12,990.91 1,275.09 14,266.00 PR 1388 05/18/2018 MUD PR 05/18/18 Social Security Taxes 758.46 15,024.46 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,033.55 15,024.46 ** 27,181.00 Budgeted 12,156.54 Remaining 55 % Used Account: 135-50035-030-000 Medicare Taxes 1290 05/04/2018 MUD PR 05.04.18 Medicare Taxes 3,038.19 298.20 3,336.39 PR 1388 05/18/2018 MUD PR 05/18/18 Medicare Taxes 177.39 3,513.78 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 475.59 3,513.78 ** 6,357.00 Budgeted 2,843.22 Remaining 55 % Used Account: 135-50040-030-000 Unemployment Taxes 983.77 .00 983.77 _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: .00 983.77 ** 1,260.00 Budgeted 276.23 Remaining 78 % Used June 18, 2018 Regular Meeting Agenda Packet 91 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/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 239 05/01/2018 Insurance/Wrk Comp Exp May 864.50 123.50 988.00 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 123.50 988.00 ** 1,529.00 Budgeted 541.00 Remaining 65 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 124.95 .00 124.95 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 124.95 ** 500.00 Budgeted 375.05 Remaining 25 % Used Account: 135-50070-030-000 Employee Relations 3,109.08 .00 3,109.08 _______________ Account: 135-50070-030-000 Employee Relations Totals: .00 3,109.08 ** 4,960.00 Budgeted 1,850.92 Remaining 63 % Used Account: 135-55030-030-000 Software & Support 1295 05/02/2018 May A/P Internet 53,406.90 903.72 54,310.62 Charter Communications 4152 AP 1413 05/21/2018 May A/P Email, MS Office 168.00 54,478.62 M3 Networks 4214 AP 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 FS *DIGITALWAVE 30.25 54,508.87 FS *DIGITALWAVE PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 DNH*GODADDY.COM 15.17 54,524.04 DNH*GODADDY.COM PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 ADOBE *CREATIVE CLOUD (239.92) 54,284.12 ADOBE *CREATIVE CLOUD PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 ATT*BILL PAYMENT 109.63 54,393.75 ATT*BILL PAYMENT PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 ATT*BILL PAYMENT 25.72 54,419.47 ATT*BILL PAYMENT PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 ATT*BILL PAYMENT 72.44 54,491.91 ATT*BILL PAYMENT PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 ATT*BILL PAYMENT 126.18 54,618.09 ATT*BILL PAYMENT PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 ADOBE SYSTEMS INC 16.23 54,634.32 ADOBE SYSTEMS INC PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 CONWAY COMPANY CPAS 595.00 55,229.32 CONWAY COMPANY CPAS PC 1458 05/31/2018 May a/p Peak agenda software 3,300.00 58,529.32 GRANICUS, INC 4242 AP 1509 05/31/2018 May A/P Internet 903.72 59,433.04 Charter Communications 4229 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 6,026.14 59,433.04 ** 78,391.00 Budgeted 18,957.96 Remaining 76 % Used Account: 135-55070-030-000 Independent Labor 1503 05/31/2018 May A/P May GM 87,822.59 13,050.00 100,872.59 Carman Consulting LLC. 4228 AP 1503 05/31/2018 May A/P May GM 213.64 101,086.23 Carman Consulting LLC. 4228 AP June 18, 2018 Regular Meeting Agenda Packet 92 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 34 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1503 05/31/2018 May A/P Staff account interviews 87,822.59 741.70 101,827.93 DRG ENTERPRISES 4239 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 14,005.34 101,827.93 ** 154,000.00 Budgeted 52,172.07 Remaining 66 % Used Account: 135-55080-030-000 Maintenance & Repairs 1458 05/31/2018 May a/p Office and maintenance supplie 5,146.17 14.52 5,160.69 OFFICE DEPOT, INC 4257 AP _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: 14.52 5,160.69 ** 14,000.00 Budgeted 8,839.31 Remaining 37 % Used Account: 135-55085-030-000 Generator Maint. and Repair 3,955.00 .00 3,955.00 _______________ Account: 135-55085-030-000 Generator Maint. and Repair Totals: .00 3,955.00 ** 10,000.00 Budgeted 6,045.00 Remaining 40 % Used Account: 135-55120-030-000 Cleaning Services 1413 05/21/2018 May A/P Janitorial services 4,831.45 869.06 5,700.51 MEMBER'S BUILDING MAINTENANCE 4215 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 869.06 5,700.51 ** 10,000.00 Budgeted 4,299.49 Remaining 57 % 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 1503 05/31/2018 May A/P May mailings 4,129.73 576.19 4,705.92 DATAPROSE LLC 4233 AP June 18, 2018 Regular Meeting Agenda Packet 93 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 35 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/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-55205-030-000 Utility Billing Contract Totals: 576.19 4,705.92 ** 9,000.00 Budgeted 4,294.08 Remaining 52 % Used Account: 135-60005-030-000 Telephone 1413 05/21/2018 May A/P Answering service 10,007.54 194.75 10,202.29 KEYSTONE PARK SECRETARIAL 4210 AP 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 ATT*BILL PAYMENT 57.23 10,259.52 ATT*BILL PAYMENT PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 ATT*BUS PHONE PMT 455.73 10,715.25 ATT*BUS PHONE PMT PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 ATT*BUS PHONE PMT 856.06 11,571.31 ATT*BUS PHONE PMT PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 RINGCENTRAL, INC 13.95 11,585.26 RINGCENTRAL, INC PC 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 ATT*BUS PHONE PMT 452.07 12,037.33 ATT*BUS PHONE PMT PC 1544 05/31/2018 Town BIlled Invoices 1640-1643 AR 20180531-20180531 User: (180.00) 11,857.33 AR _______________ Account: 135-60005-030-000 Telephone Totals: 1,849.79 11,857.33 ** 27,300.00 Budgeted 15,442.67 Remaining 43 % Used Account: 135-60010-030-000 Communications/Mobiles 1366 05/10/2018 May A/P Cell phones 1,799.43 87.37 1,886.80 VERIZON WIRELESS 4193 AP 1388 05/18/2018 MUD PR 05/18/18 Communications/Mobiles 150.00 2,036.80 PR _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 237.37 2,036.80 ** 4,000.00 Budgeted 1,963.20 Remaining 51 % Used Account: 135-60020-030-000 Electricity/Gas 3,852.21 .00 3,852.21 _______________ Account: 135-60020-030-000 Electricity/Gas Totals: .00 3,852.21 ** 16,261.00 Budgeted 12,408.79 Remaining 24 % Used Account: 135-60025-030-000 Water 1544 05/31/2018 Town BIlled Invoices 1640-1643 AR 20180531-20180531 User: 397.44 (58.32) 339.12 AR _______________ Account: 135-60025-030-000 Water Totals: (58.32) 339.12 ** 2,500.00 Budgeted 2,160.88 Remaining 14 % Used Account: 135-60030-030-000 Rent And/Or Usage 616.40 .00 616.40 June 18, 2018 Regular Meeting Agenda Packet 94 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/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-60030-030-000 Rent And/Or Usage Totals: .00 616.40 ** .00 Budgeted (616.40) Remaining 0 % Used Account: 135-60035-030-000 Postage 1503 05/31/2018 May A/P May mailings 12,977.71 1,579.66 14,557.37 DATAPROSE LLC 4233 AP _______________ Account: 135-60035-030-000 Postage Totals: 1,579.66 14,557.37 ** 30,000.00 Budgeted 15,442.63 Remaining 49 % Used Account: 135-60040-030-000 Service Charges & Fees 1296 05/04/2018 Child Support Fee 34,353.22 1.50 34,354.72 GL 1389 05/18/2018 Child Support Fee 1.50 34,356.22 GL 1443 05/31/2018 Pace Credit Card Fees 4,219.91 38,576.13 GL 1443 05/31/2018 Pace Credit Card Fees 91.19 38,667.32 GL 1503 05/31/2018 May A/P Direct send fees 50.00 38,717.32 Fiserv Solutions, LLC 4240 AP _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 4,364.10 38,717.32 ** 55,560.00 Budgeted 16,842.68 Remaining 70 % 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 239 05/01/2018 Insurance/Wrk Comp Exp May 45,977.52 6,100.36 52,077.88 GL _______________ Account: 135-60055-030-000 Insurance Totals: 6,100.36 52,077.88 ** 56,000.00 Budgeted 3,922.12 Remaining 93 % 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 June 18, 2018 Regular Meeting Agenda Packet 95 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 37 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/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 3,828.42 .00 3,828.42 _______________ 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 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 PANERA BREAD #601996 48.62 31.88 80.50 PANERA BREAD #601996 PC _______________ Account: 135-60075-030-000 Meetings Totals: 31.88 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 1290 05/04/2018 MUD PR 05.04.18 Travel & per diem 711.12 52.16 763.28 PR 1388 05/18/2018 MUD PR 05/18/18 Travel & per diem 80.44 843.72 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 132.60 843.72 ** 4,885.00 Budgeted 4,041.28 Remaining 17 % 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 June 18, 2018 Regular Meeting Agenda Packet 96 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 220.00 .00 220.00 _______________ Account: 135-60115-030-000 Elections Totals: .00 220.00 ** 4,500.00 Budgeted 4,280.00 Remaining 5 % Used Account: 135-60125-030-000 Advertising 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 96.00 .00 96.00 _______________ Account: 135-60235-030-000 Security Totals: .00 96.00 ** 2,700.00 Budgeted 2,604.00 Remaining 4 % 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 .00 .00 _______________ Account: 135-60246-030-000 General Manager Contingency Totals: .00 .00 ** 17,000.00 Budgeted 17,000.00 Remaining 0 % 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 June 18, 2018 Regular Meeting Agenda Packet 97 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/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 1333 05/07/2018 May A/P WWTP Conference room 1,508.94 497.74 2,006.68 M3 Networks 4181 AP _______________ Account: 135-65055-030-000 Hardware Totals: 497.74 2,006.68 ** 7,420.00 Budgeted 5,413.32 Remaining 27 % Used Account: 135-65085-030-000 Office Supplies 1413 05/21/2018 May A/P office supplies 3,322.40 10.78 3,333.18 OFFICE DEPOT, INC 4216 AP 1413 05/21/2018 May A/P Office supplies 75.74 3,408.92 OFFICE DEPOT, INC 4216 AP 1499 05/28/2018 Pcard 04/27/18 - 05/28/18 AMER ASSOC NOTARIESWE 25.90 3,434.82 AMER ASSOC NOTARIESWE PC 1458 05/31/2018 May a/p Office supplies 115.19 3,550.01 OFFICE DEPOT, INC 4257 AP 1458 05/31/2018 May a/p Office and maintenance supplie 36.23 3,586.24 OFFICE DEPOT, INC 4257 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 263.84 3,586.24 ** 7,000.00 Budgeted 3,413.76 Remaining 51 % 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 1503 05/31/2018 May A/P 3,185.75 81.70 3,267.45 OFFICE DEPOT, INC 4257 AP _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 81.70 3,267.45 ** 4,000.00 Budgeted 732.55 Remaining 82 % Used Account: 135-65105-030-000 Printing 144.00 .00 144.00 _______________ Account: 135-65105-030-000 Printing Totals: .00 144.00 ** 4,000.00 Budgeted 3,856.00 Remaining 4 % Used June 18, 2018 Regular Meeting Agenda Packet 98 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 40 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69005-030-000 Capital Outlays 1510 05/31/2018 May A/P Comp salary survey 28,827.32 8,500.00 37,327.32 Segal Waters Consulting 4261 AP _______________ Account: 135-69005-030-000 Capital Outlays Totals: 8,500.00 37,327.32 ** 13,000.00 Budgeted (24,327.32) Remaining 287 % Used Account: 135-69170-030-000 Copier Lease Installments 1413 05/21/2018 May A/P Copier Lease 1,724.53 165.00 1,889.53 EVERBANK COMMERCIAL FINANCE 4201 AP 1458 05/31/2018 May a/p Copiers/Lease 101.02 1,990.55 KYOCERA DOCUMENT SOLUTIONS 4249 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 266.02 1,990.55 ** 4,600.00 Budgeted 2,609.45 Remaining 43 % Used Department 30 Totals: ----------------------------------- 762,152.79 ** 89,872.61 Monthly Total 1,227,112.00 Budgeted 464,959.21 Remaining 62 % Used June 18, 2018 Regular Meeting Agenda Packet 99 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 5/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 1413 05/21/2018 May A/P Legal-Southlake easement 42,753.55 16,508.38 59,261.93 WHITAKER CHALK SWINDLE 4221 AP _______________ Account: 135-55045-039-000 Legal Totals: 16,508.38 59,261.93 ** 137,000.00 Budgeted 77,738.07 Remaining 43 % Used Account: 135-55055-039-000 Auditing 1503 05/31/2018 May A/P JE advice audit 25,508.70 150.00 25,658.70 LAFOLLETT & ABBOTT PLLC 4251 AP _______________ Account: 135-55055-039-000 Auditing Totals: 150.00 25,658.70 ** 24,500.00 Budgeted (1,158.70) Remaining 105 % Used Account: 135-55060-039-000 Appraisal 1503 05/31/2018 May A/P Appraisal 3rd qtr DCAD budget 6,672.05 2,011.87 8,683.92 DENTON CENTRAL APPRAISAL DISTR 4235 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 2,011.87 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: ----------------------------------- 96,572.95 ** 18,670.25 Monthly Total 176,746.00 Budgeted 80,173.05 Remaining 55 % Used Fund 135 Totals: ----------------------------------- (1,315,517.27) (1,124,410.65) Monthly Total (194,618.00) Budgeted 1,120,899.27 Remaining 676 % Used June 18, 2018 Regular Meeting Agenda Packet 100 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 5/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 June 18, 2018 Regular Meeting Agenda Packet 101 of 150 TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET MAY 2018 517 ASSETS CONSTRUCTION FUND CASH IN BANK 155 INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS 155 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 803,631 TOTAL LIABILITIES 803,631 FUND BALANCE ASSIGNED FUND BALANCE 992,579 NET REVENUES / EXPENDITURES (1,796,055) TOTAL FUND BALANCE (803,476) TOTAL LIABILITIES AND FUND BALANCE 155 June 18, 2018 Regular Meeting Agenda Packet 102 of 150 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 14 22:05 06/13/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 5/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 154.89- 9,348.16- 9,348.16 Subtotal: 154.89- 9,348.16- 9,348.16 Program number: 154.89- 9,348.16- 9,348.16 Department number: Revenues 154.89- 9,348.16- 9,348.16 June 18, 2018 Regular Meeting Agenda Packet 103 of 150 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 15 22:05 06/13/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 5/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 201,031.99- 201,031.99- 201,031.99 Subtotal: 201,031.99- 201,031.99- 201,031.99 Program number: 201,031.99- 201,031.99- 201,031.99 Department number: Wastewater 201,031.99- 201,031.99- 201,031.99 Revenues Subtotal ----------- 201,186.88- 210,380.15- 210,380.15 June 18, 2018 Regular Meeting Agenda Packet 104 of 150 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 16 22:05 06/13/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 5/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-69005-020-000 Capital Outlays 406,950.82 2,006,435.35 2,006,435.35- Subtotal: 406,950.82 2,006,435.35 2,006,435.35- Program number: 406,950.82 2,006,435.35 2,006,435.35- Department number: Wastewater 406,950.82 2,006,435.35 2,006,435.35- Expenditures Subtotal ----------- 406,950.82 2,006,435.35 2,006,435.35- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 205,763.94 1,796,055.20 1,796,055.20- June 18, 2018 Regular Meeting Agenda Packet 105 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 43 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 5/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 1538 05/31/2018 Bank Interest- May (9,193.27) (154.89) (9,348.16) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (154.89) (9,348.16) ** .00 Budgeted 9,348.16 Remaining 0 % Used Department Totals: ----------------------------------- (9,348.16) ** (154.89) Monthly Total .00 Budgeted 9,348.16 Remaining 0 % Used June 18, 2018 Regular Meeting Agenda Packet 106 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 44 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 5/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 1519 05/31/2018 Texpool Transfers May (201,031.99) (201,031.99) GL _______________ Account: 517-49141-020-000 Interfund Transfers In Gen Totals: (201,031.99) (201,031.99) ** .00 Budgeted 201,031.99 Remaining 0 % Used Account: 517-69005-020-000 Capital Outlays 1366 05/10/2018 May A/P WWTP Improvement 1,599,484.53 287,017.98 1,886,502.51 WEBBER-CADAGUA PARTNERS 4194 AP 1524 05/31/2018 MAY A/P WWTP Improvements 119,932.84 2,006,435.35 WEBBER-CADAGUA PARTNERS AP _______________ Account: 517-69005-020-000 Capital Outlays Totals: 406,950.82 2,006,435.35 ** .00 Budgeted (2,006,435.35) Remaining 0 % Used Department 20 Totals: ----------------------------------- 1,805,403.36 ** 205,918.83 Monthly Total .00 Budgeted (1,805,403.36) Remaining 0 % Used Fund 517 Totals: ----------------------------------- 1,796,055.20 205,763.94 Monthly Total .00 Budgeted (1,796,055.20) Remaining 0 % Used June 18, 2018 Regular Meeting Agenda Packet 107 of 150 TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION SWIFT FUNDING BALANCE SHEET MAY 2018 519 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK 1,485 CASH IN ESCROW 749,385 INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS 750,870 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,487,869) TOTAL FUND BALANCE 737,712 TOTAL LIABILITIES AND FUND BALANCE 750,870 June 18, 2018 Regular Meeting Agenda Packet 108 of 150 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 17 22:05 06/13/18 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const-SWIFT Department: Revenues Program: Period Ending: 5/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 519-49010-000-000 Interest Income 1,484.87- 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,484.87- 1,055,469.25- 1,055,469.25 Program number: 1,484.87- 1,055,469.25- 1,055,469.25 Department number: Revenues 1,484.87- 1,055,469.25- 1,055,469.25 Revenues Subtotal ----------- 1,484.87- 1,055,469.25- 1,055,469.25 June 18, 2018 Regular Meeting Agenda Packet 109 of 150 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 18 22:05 06/13/18 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const-SWIFT Department: 10 Water Program: Period Ending: 5/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 519-60334-010-000 Interfund Transfer Out 1,053,984.38 1,850,129.46 1,850,129.46- Subtotal: 1,053,984.38 1,850,129.46 1,850,129.46- 519-69005-010-000 Capital Outlays 2,693,208.68 2,693,208.68- Subtotal: 2,693,208.68 2,693,208.68- Program number: 1,053,984.38 4,543,338.14 4,543,338.14- Department number: Water 1,053,984.38 4,543,338.14 4,543,338.14- Expenditures Subtotal ----------- 1,053,984.38 4,543,338.14 4,543,338.14- Fund number: 519 2016 Rev Bond Const-SWIFT 1,052,499.51 3,487,868.89 3,487,868.89- June 18, 2018 Regular Meeting Agenda Packet 110 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const-SWIFT Department: Revenues Program: Period Ending: 5/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 1538 05/31/2018 Bank Interest- May (49.30) (1,484.87) (1,534.17) GL _______________ Account: 519-49010-000-000 Interest Income Totals: (1,484.87) (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) ** (1,484.87) Monthly Total .00 Budgeted 1,055,469.25 Remaining 0 % Used June 18, 2018 Regular Meeting Agenda Packet 111 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const-SWIFT Department: 10 Water Program: Period Ending: 5/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 1519 05/31/2018 Texpool Transfers May Transfer to Gen unass cash 796,145.08 1,053,984.38 1,850,129.46 GL _______________ Account: 519-60334-010-000 Interfund Transfer Out Totals: 1,053,984.38 1,850,129.46 ** .00 Budgeted (1,850,129.46) 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,543,338.14 ** 1,053,984.38 Monthly Total .00 Budgeted (4,543,338.14) Remaining 0 % Used Fund 519 Totals: ----------------------------------- 3,487,868.89 1,052,499.51 Monthly Total .00 Budgeted (3,487,868.89) Remaining 0 % Used June 18, 2018 Regular Meeting Agenda Packet 112 of 150 TROPHY CLUB MUD #1 - 16" WATERLINE FUTURE REVENUE BOND BALANCE SHEET MAY 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 June 18, 2018 Regular Meeting Agenda Packet 113 of 150 TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET MAY 2018 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 545,786 ACCOUNTS RECEIVABLE - TOTAL ASSETS 545,786 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 426,579 NET REVENUES / EXPENDITURES 119,208 TOTAL FUND BALANCE 545,786 TOTAL LIABILITIES AND FUND BALANCE 545,786 June 18, 2018 Regular Meeting Agenda Packet 114 of 150 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 19 22:05 06/13/18 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 5/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- 774.10- 4,364.94- 436.494 3,364.94 528-49142-000-000 Interfund transfer in-Water 48,996.00- 48,996.00- 4,068.00- 32,649.00- 66.636 16,347.00- 528-49143-000-000 Interfund transfer in-WW 123,336.00- 123,336.00- 10,248.00- 82,194.00- 66.642 41,142.00- Subtotal: 173,332.00- 173,332.00- 15,090.10- 119,207.94- 68.774 54,124.06- Program number: 173,332.00- 173,332.00- 15,090.10- 119,207.94- 68.774 54,124.06- Department number: 173,332.00- 173,332.00- 15,090.10- 119,207.94- 68.774 54,124.06- Revenues Subtotal ----------- 173,332.00- 173,332.00- 15,090.10- 119,207.94- 68.774 54,124.06- Fund number: 528 2015 Revenue Bond Reserve Fund 173,332.00- 173,332.00- 15,090.10- 119,207.94- 68.774 54,124.06- June 18, 2018 Regular Meeting Agenda Packet 115 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 47 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 5/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 1538 05/31/2018 Bank Interest- May (3,590.84) (774.10) (4,364.94) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (774.10) (4,364.94) ** (1,000.00) Budgeted 3,364.94 Remaining 436 % Used Account: 528-49142-000-000 Interfund transfer in-Water 1519 05/31/2018 Texpool Transfers May (28,581.00) (4,083.00) (32,664.00) GL 1551 05/31/2018 TexPool Transfer May Adj TexPool shorted transfr JE1519 15.00 (32,649.00) GL _______________ Account: 528-49142-000-000 Interfund transfer in-Water Totals: (4,068.00) (32,649.00) ** (48,996.00) Budgeted (16,347.00) Remaining 67 % Used Account: 528-49143-000-000 Interfund transfer in-WW 1519 05/31/2018 Texpool Transfers May (71,946.00) (10,278.00) (82,224.00) GL 1551 05/31/2018 TexPool Transfer May Adj TexPool shorted transfr JE1519 30.00 (82,194.00) GL _______________ Account: 528-49143-000-000 Interfund transfer in-WW Totals: (10,248.00) (82,194.00) ** (123,336.00) Budgeted (41,142.00) Remaining 67 % Used Department Totals: ----------------------------------- (119,207.94) ** (15,090.10) Monthly Total (173,332.00) Budgeted (54,124.06) Remaining 69 % Used Fund 528 Totals: ----------------------------------- (119,207.94) (15,090.10) Monthly Total (173,332.00) Budgeted (54,124.06) Remaining 69 % Used June 18, 2018 Regular Meeting Agenda Packet 116 of 150 TROPHY CLUB MUD #1 - I&S BALANCE SHEET MAY 2018 INTEREST & SINKING- 533 ASSETS CASH IN BANK 4,573 INVESTMENTS 873,573 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 14,575 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 892,720 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 14,575 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 14,575 FUND BALANCE ASSIGNED FUND BALANCE 32,341 NET REVENUES / EXPENDITURES 845,805 TOTAL FUND BALANCE 878,145 TOTAL LIABILITIES AND FUND BALANCE 892,720 June 18, 2018 Regular Meeting Agenda Packet 117 of 150 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 20 22:05 06/13/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 5/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- 5,567.33- 671,913.01- 100.336 2,253.01 533-40002-000-000 Property Taxes/Delinquent 1,800.00- 1,800.00- 252.30- 2,586.35- 143.686 786.35 533-40015-000-000 Property Taxes/P & I 2,000.00- 2,000.00- 594.38- 1,795.40- 89.770 204.60- Subtotal: 673,460.00- 673,460.00- 6,414.01- 676,294.76- 100.421 2,834.76 533-49010-000-000 Interest Income 2,000.00- 2,000.00- 1,249.14- 5,001.05- 250.053 3,001.05 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- 88,758.48- 72.727 33,284.52- Subtotal: 342,997.00- 342,997.00- 12,343.95- 312,713.53- 91.171 30,283.47- Program number: 1,016,457.00- 1,016,457.00- 18,757.96- 989,008.29- 97.300 27,448.71- Department number: Revenues 1,016,457.00- 1,016,457.00- 18,757.96- 989,008.29- 97.300 27,448.71- Revenues Subtotal ----------- 1,016,457.00- 1,016,457.00- 18,757.96- 989,008.29- 97.300 27,448.71- June 18, 2018 Regular Meeting Agenda Packet 118 of 150 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 21 22:05 06/13/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 5/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- 18,757.96- 845,804.54- ############### 840,005.54 June 18, 2018 Regular Meeting Agenda Packet 119 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 48 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 5/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 1476 05/01/2018 Property Taxes (666,345.68) (66.63) (666,412.31) GL 1477 05/02/2018 Property Taxes (12.82) (666,425.13) GL 1478 05/03/2018 Property Taxes (74.24) (666,499.37) GL 1479 05/04/2018 Property Taxes (30.64) (666,530.01) GL 1480 05/07/2018 Property Taxes (842.81) (667,372.82) GL 1481 05/09/2018 Property Taxes (211.04) (667,583.86) GL 1482 05/10/2018 Property Taxes (35.01) (667,618.87) GL 1483 05/11/2018 Property Taxes (367.22) (667,986.09) GL 1484 05/14/2018 Property Taxes (496.11) (668,482.20) GL 1485 05/15/2018 Property Taxes (26.47) (668,508.67) GL 1486 05/16/2018 Property Taxes (640.52) (669,149.19) GL 1487 05/17/2018 Property Taxes (240.91) (669,390.10) GL 1488 05/18/2018 Property Taxes (33.57) (669,423.67) GL 1489 05/21/2018 Property Taxes (58.56) (669,482.23) GL 1490 05/22/2018 Property Taxes (37.64) (669,519.87) GL 1491 05/23/2018 Property Taxes (354.17) (669,874.04) GL 1492 05/24/2018 Property Taxes (992.91) (670,866.95) GL 1493 05/25/2018 Property Taxes (55.25) (670,922.20) GL 1495 05/29/2018 Property Taxes (198.47) (671,120.67) GL 1496 05/30/2018 Property Taxes (288.70) (671,409.37) GL 1497 05/31/2018 Property Taxes (503.64) (671,913.01) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (5,567.33) (671,913.01) ** (669,660.00) Budgeted 2,253.01 Remaining 100 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1477 05/02/2018 Property Taxes (2,334.05) (48.26) (2,382.31) GL 1481 05/09/2018 Property Taxes (11.67) (2,393.98) GL 1491 05/23/2018 Property Taxes 12.10 (2,381.88) GL 1495 05/29/2018 Property Taxes (204.47) (2,586.35) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (252.30) (2,586.35) ** (1,800.00) Budgeted 786.35 Remaining 144 % Used Account: 533-40015-000-000 Property Taxes/P & I 1476 05/01/2018 Property Taxes (1,201.02) (8.41) (1,209.43) GL 1477 05/02/2018 Property Taxes (9.15) (1,218.58) GL 1478 05/03/2018 Property Taxes (8.17) (1,226.75) GL 1479 05/04/2018 Property Taxes (3.98) (1,230.73) GL 1480 05/07/2018 Property Taxes (101.76) (1,332.49) GL June 18, 2018 Regular Meeting Agenda Packet 120 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 5/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1481 05/09/2018 Property Taxes (1,201.02) (30.70) (1,363.19) GL 1483 05/11/2018 Property Taxes (39.19) (1,402.38) GL 1484 05/14/2018 Property Taxes (30.99) (1,433.37) GL 1486 05/16/2018 Property Taxes (63.04) (1,496.41) GL 1487 05/17/2018 Property Taxes (15.23) (1,511.64) GL 1490 05/22/2018 Property Taxes (1.72) (1,513.36) GL 1491 05/23/2018 Property Taxes (13.68) (1,527.04) GL 1492 05/24/2018 Property Taxes (101.27) (1,628.31) GL 1495 05/29/2018 Property Taxes (100.82) (1,729.13) GL 1496 05/30/2018 Property Taxes (29.18) (1,758.31) GL 1497 05/31/2018 Property Taxes (37.09) (1,795.40) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (594.38) (1,795.40) ** (2,000.00) Budgeted (204.60) Remaining 90 % Used Account: 533-49010-000-000 Interest Income 1538 05/31/2018 Bank Interest- May (3,751.91) (1,249.14) (5,001.05) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (1,249.14) (5,001.05) ** (2,000.00) Budgeted 3,001.05 Remaining 250 % 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 1519 05/31/2018 Texpool Transfers May (77,663.67) (11,094.81) (88,758.48) GL _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (11,094.81) (88,758.48) ** (122,043.00) Budgeted (33,284.52) Remaining 73 % Used Department Totals: ----------------------------------- (989,008.29) ** (18,757.96) Monthly Total (1,016,457.00) Budgeted (27,448.71) Remaining 97 % Used June 18, 2018 Regular Meeting Agenda Packet 121 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 50 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 5/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: ----------------------------------- (845,804.54) (18,757.96) Monthly Total (5,799.00) Budgeted 840,005.54 Remaining ########## June 18, 2018 Regular Meeting Agenda Packet 122 of 150 TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET MAY 2018 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 341,398 ACCOUNTS RECEIVABLE - TOTAL ASSETS 341,398 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 16,210 NET REVENUES / EXPENDITURES 325,188 TOTAL FUND BALANCE 341,398 TOTAL LIABILITIES AND FUND BALANCE 341,398 June 18, 2018 Regular Meeting Agenda Packet 123 of 150 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 22 22:05 06/13/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 5/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- 420.27- 1,611.17- 161.117 611.17 534-49143-000-000 Interfund Transfer In-WW Sales 598,738.00- 598,738.00- 54,430.72- 435,445.76- 72.727 163,292.24- Subtotal: 599,738.00- 599,738.00- 54,850.99- 437,056.93- 72.875 162,681.07- Program number: 599,738.00- 599,738.00- 54,850.99- 437,056.93- 72.875 162,681.07- Department number: Revenues 599,738.00- 599,738.00- 54,850.99- 437,056.93- 72.875 162,681.07- Revenues Subtotal ----------- 599,738.00- 599,738.00- 54,850.99- 437,056.93- 72.875 162,681.07- June 18, 2018 Regular Meeting Agenda Packet 124 of 150 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 23 22:05 06/13/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 5/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,850.99- 325,188.18- ############### 324,188.18 June 18, 2018 Regular Meeting Agenda Packet 125 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 51 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 5/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 1538 05/31/2018 Bank Interest- May (1,190.90) (420.27) (1,611.17) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (420.27) (1,611.17) ** (1,000.00) Budgeted 611.17 Remaining 161 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales 1519 05/31/2018 Texpool Transfers May (381,015.04) (54,430.72) (435,445.76) GL _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (54,430.72) (435,445.76) ** (598,738.00) Budgeted (163,292.24) Remaining 73 % Used Department Totals: ----------------------------------- (437,056.93) ** (54,850.99) Monthly Total (599,738.00) Budgeted (162,681.07) Remaining 73 % Used June 18, 2018 Regular Meeting Agenda Packet 126 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 52 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 5/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: ----------------------------------- (325,188.18) (54,850.99) Monthly Total (1,000.00) Budgeted 324,188.18 Remaining ########## June 18, 2018 Regular Meeting Agenda Packet 127 of 150 TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET MAY 2018 535 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS 172,430 ACCOUNTS RECEIVABLE - TOTAL ASSETS 172,430 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 952 NET REVENUES / EXPENDITURES 171,479 TOTAL FUND BALANCE 172,430 TOTAL LIABILITIES AND FUND BALANCE 172,430 June 18, 2018 Regular Meeting Agenda Packet 128 of 150 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 24 22:05 06/13/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 5/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- 215.34- 777.79- 129.632 177.79 535-49142-000-000 Interfund Tran In-Water Sales 278,084.00- 278,084.00- 25,280.31- 202,242.48- 72.727 75,841.52- Subtotal: 278,684.00- 278,684.00- 25,495.65- 203,020.27- 72.850 75,663.73- Program number: 278,684.00- 278,684.00- 25,495.65- 203,020.27- 72.850 75,663.73- Department number: Revenues 278,684.00- 278,684.00- 25,495.65- 203,020.27- 72.850 75,663.73- Revenues Subtotal ----------- 278,684.00- 278,684.00- 25,495.65- 203,020.27- 72.850 75,663.73- June 18, 2018 Regular Meeting Agenda Packet 129 of 150 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 25 22:05 06/13/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 5/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,495.65- 171,478.52- ############### 170,878.52 ******* End of Report ********* June 18, 2018 Regular Meeting Agenda Packet 130 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 53 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 5/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 1538 05/31/2018 Bank Interest- May (562.45) (215.34) (777.79) GL _______________ Account: 535-49010-000-000 Interest Income Totals: (215.34) (777.79) ** (600.00) Budgeted 177.79 Remaining 130 % Used Account: 535-49142-000-000 Interfund Tran In-Water Sales 1519 05/31/2018 Texpool Transfers May (176,962.17) (25,280.31) (202,242.48) GL _______________ Account: 535-49142-000-000 Interfund Tran In-Water Sales Totals: (25,280.31) (202,242.48) ** (278,084.00) Budgeted (75,841.52) Remaining 73 % Used Department Totals: ----------------------------------- (203,020.27) ** (25,495.65) Monthly Total (278,684.00) Budgeted (75,663.73) Remaining 73 % Used June 18, 2018 Regular Meeting Agenda Packet 131 of 150 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 54 22:06 06/13/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 5/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: ----------------------------------- (171,478.52) (25,495.65) Monthly Total (600.00) Budgeted 170,878.52 Remaining ########## Grand Totals: --------------------------------------------------------------------------------------------------------- 2,099,116.75 **** 61,551.61 Monthly Total (375,349.00) Budgeted (2,474,465.75) Remaining ########## ******* End of Report ********* June 18, 2018 Regular Meeting Agenda Packet 132 of 150 BUDGET VARIANCE REPORT FUND:122 - Fire O&M FINANCIALS MONTH:May 2018 REVENUE VARIANCE:58.1% EXPENSE VARIANCE:76.4% 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 8,766 1,057,968 100.34%10/2017 Property Taxes collected 122-40011 Property Taxes/Fire - Delinquent 319 3,886 10/2017 Delinquent Fire Taxes collected 122-40020 Property Taxes/Fire P&I 1,034 4,449 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 June 18, 2018 Regular Meeting Agenda Packet 133 of 150 BUDGET VARIANCE REPORT FUND:135 - MUD 1 O&M FINANCIALS MONTH:May 2018 REVENUE VARIANCE:58.1% EXPENSE VARIANCE:76.4% NOTE: ACCOUNT DESCRIPTION TOTAL BUDGET CURRENT MONTH YTD TOTAL YTD % DATE OF COMMENT VARIANCE EXPLANATION REVENUE 135-47000-000 Water 6,464,019 498,952 3,139,602 48.57%01/2018 Water Sales 135-47030-000 Service Charges 21,350 950 9,400 44.03%01/2018 Service Charges 135-47070-000 TCCC Effluent Charges 60,000 10,886 27,196 45.33%11/2017 TCCC Effluent Collected EXPENSES WATER 135-55090-010 Vehicle Maintenance 4,000 35 3,888 97.20%05/2018 Registration & Kwik Car 135-55135-010 Lab Analysis 5,500 2,160 5,765 104.82%05/2018 Huther & Associates- Bio Monitoring WASTEWATER 135-50010-020 Overtime 30,000 3,966 23,601 78.67%05/2018 WWTP Overtime 135-55125-020 Dumpster Services 60,000 4,896 55,077 91.80%01/2018 L.H. Chaney- Haul offs 135-60334-020 Interfund Transfer Out 200,000 201,032 201,032 100.52%05/2018 Fund transfer to cover WWTP Improvement Shortage 135-65040-020 Safety Equipment 750 407 1,158 154.33%04/2018 Bags for PPE 135-65045-020 Lab Supplies 14,000 2,783 13,484 96.31%05/2018 Binder- Oven $2123.31 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 June 18, 2018 Regular Meeting Agenda Packet 134 of 150 BUDGET VARIANCE REPORT FUND:135 - MUD 1 O&M FINANCIALS MONTH:May 2018 REVENUE VARIANCE:58.1% EXPENSE VARIANCE:76.4% 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 405 1,215 101.25%05/2018 AWBD ADMINISTRATION 135-60055-030 Insurance 56,000$ 6,100$ 52,078$ 93.00%02/2018 TML WC True-Up Adjustment FY17 135-65095-030 Maintenance Supplies 4,000$ 82$ 3,267$ 81.69%03/2018 Office Supplies 135-69005-030 Capital Outlays 13,000$ 8,500$ 37,327$ 287.13%04/2018 Security Captial Outlay FY17 Carryover Non-Departmental 135-55055-039 Auditing 24,500$ 150$ 25,659$ 104.73%05/2018 Audit advice June 18, 2018 Regular Meeting Agenda Packet 135 of 150 Trophy Club Municipal Utility District No. 1    Date:    6/18/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   16 Inch Water Line Project Phase 1 – Construction has begun on Phase 1 of the Water Line  Project to bring water to the Town Center development in time for vertical construction to  begin.  This project was estimated by Halff Engineers to cost $ 310,000 and the bids came in at  $ 188,625.  Our contingency on this project is $ 15,500 and we anticipate the first change order,  related to the unknown material of the pipe the contractor had to connect to, to be come in  the next month.  WWTP – Work on Phase 3 of the plant upgrade continues.   Contractors have completed  installation of membrane racks and are finishing up associated piping installations and pressure  testing.      June 18, 2018 Regular Meeting Agenda Packet 136 of 150 Preliminary work on the replacement of the pumps at the effluent diversion structure has  begun.  We have been working with the contractor to find a method of dewatering the  structure that also keeps us in compliance with the parameters of our discharge permit.      June 18, 2018 Regular Meeting Agenda Packet 137 of 150 The Contractor poured the concrete road on the North side of the plant and the patch on the  West side of the plant where the concrete was cut out for the electrical repairs and tie‐in.    High Service Booster Pump – Rebidding of this project is on hold, and staff anticipates  resuming the rebidding process so that construction can begin after peak flows have been  passed for the summer.  Joint Projects with Town ‐ The project on Phoenix Drive has temporary service in place and the  new waterline is being installed.  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.  Construction on Indian Creek cannot commence until Phoenix Drive complete.  East Ground Storage Tank   Utility Services Company has begun repainting the East Ground Storage Tank.  This is work that  comes as a part of our long‐term maintenance contract for both ground and elevated storage  facilities.  From the picture below, you can see some low spots on the roof that could be places  where corrosion will begin.  June 18, 2018 Regular Meeting Agenda Packet 138 of 150     June 18, 2018 Regular Meeting Agenda Packet 139 of 150     Fire Department Summary  In the month of May the Fire Department responded to a total of 81 calls for emergency  service.  This last year we divided our town into response boxes to enable us to better  understand where the majority of our calls are being run and hopefully develop ways to better  serve our community through a more thorough needs assessment.  We have found that  approximately 14% of our call volume is in box 7051 which includes our hotels and  hospital.  Mutual aid consisted of 5 instances of mutual aid given and 2 instances of mutual aid  received.  In May the entire department participated in live fire training in Johnson County  where Chief Carroll and the 3 captains trained all our personnel on firefighting and search  techniques under live fire conditions.  The department also participated in EMS continuing  education covering overdose, dysrhythmias, dermatology, and Umbilical vein insertion. Fire CEs  for the month covered ground ladder operations. The fire Department also conducted 36 fire  inspections of commercial and residential properties.   Finally, The department interacted with  29 adults and 52 children during May consisting of a ride to school, a station tour and safety  presentation for a girl scout troop and Story Time at the Station where 40 children were taught  water/swim safety through an interactive story told in the fire station apparatus bay.      Administratively the department is has completed midyear reviews on all employees, has been  working with Road Rescue on the production of our new ambulance to be delivered in July or  August and has begun working towards an annual review and revision of our Standard  Operating Procedures.      June 18, 2018 Regular Meeting Agenda Packet 140 of 150 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 469,013 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 426,038 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 47280000 2018 MUD 3257 3262 3268 3272 3276 3280 3280 3284 2018 PID 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 June 18, 2018 Regular Meeting Agenda Packet 141 of 150 Influent EffluentInfluent EffluentInfluent Effluent1‐May 42.5 0.2 99.5% 217 2.0 99.1% 225 1.0 99.6%3‐May 47 0.2 99.6% 263 2.0 99.2% 220 1.0 99.5%      8‐May 42 0.48 98.9% 243 2.0 99.2% 253 1.0 99.6%10‐May 32 0.20 99.4% 149 2.0 98.7% 270 1.0 99.6%   15‐May 39.5 0.34 99.1% 206 2.0 99.0% 208 1.0 99.5%16‐May 35 0.22 99.4% 171 2.0 98.8% 228 1.4 99.4% 21‐May 37 0.20 99.5% 267 2.0 99.3% 218 1.0 99.5%22‐May 44.5 0.20 99.6% 267 2.0 99.3% 248 1.0 99.6%29‐May37.5 0.4898.7%204 2.099.0%162 1.099.4%30‐May45 0.299.6%245 2.099.2%170 1.099.4%99.3%99.1%99.5%Date% Removal% Removal% RemovalReportMay 2018 ResultsAmmonia‐NCBOD5TSS0.262.01.1Ammonia‐NCBOD5TSSJune 18, 2018 Regular Meeting Agenda Packet142 of 150 Max mg/L0.49Aver mg/L0.312Max mg/L2.0Aver mg/L2.0Ammonia NitrogenCarbonaceous Biochemical Demand (CBOD5)0.210.3300.4900.2510.28000.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.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 LimitJune 18, 2018 Regular Meeting Agenda Packet143 of 150 Max mg/L1.04Aver mg/L1.0Max mg/L8.8Aver mg/L5.7Total Suspended Solids (TSS)Nitrate - Nitrogen1.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.50.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 LimitJune 18, 2018 Regular Meeting Agenda Packet144 of 150 Max mg/L5.0Aver mg/L2.6Max mg/L7.6Min mg/L7.2Aver mg/L7.3Potential for Hydrogen (pH)E. Coli1.04.01.05.02.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.37.47.47.37.60.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 MaxJune 18, 2018 Regular Meeting Agenda Packet145 of 150 Max mg/L7.8Aver mg/L7.6 Dissolved Oxygen (DO)7.87.57.87.67.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 LimitJune 18, 2018 Regular Meeting Agenda Packet146 of 150 October November December January February March April May June July August September ebills 796 828 829 834 839 844 841 849 Bills Mailed 3906 3900 3912 3911 3908 3913 3921 3935 Bank Draft 631 623 639 653 657 656 655 654 Credit Card Draft 1018 1020 1026 1033 1042 1056 1054 1056 Online Payments 1037 1079 1,072 1,065 1,086 1,097 1,019 1,080 Late Notices 391 420 457 362 424 407 299 355 Disconnects 25 27 27 25 22 27 24 17 M 3257 3262 3268 3272 3276 3280 3280 3284 Connections P 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 June 18, 2018 Regular Meeting Agenda Packet 147 of 150 MUD Permits Month: May 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 5/2/2018 2018-0031 75.00$ 1,173.00$ 343.00$ 150.00$ 50.00$ 800.00$ 2,591.00$ 5/8/2018 2018-0032 75.00$ 1,173.00$ 343.00$ 150.00$ 50.00$ 1,791.00$ 5/24/2018 2018-0024 75.00$ 1,173.00$ 343.00$ 150.00$ 50.00$ 1,791.00$ 5/24/2018 2018-0029 75.00$ 1,173.00$ 343.00$ 150.00$ 50.00$ 1,791.00$ Total 300.00$ 4,692.00$ 1,372.00$ 600.00$ 200.00$ 800.00$ -$ 7,964.00$ June 18, 2018 Regular Meeting Agenda Packet 148 of 150 135-10154 Bank of the West-THB (X6718) 3 yr CD $35,316 $0 $35,316 135-10175 Bank of the West MMA (XXX6372) General Fund Operating $0 $715,081 $715,081 135-10250 TexPool O & M (XXXXX0002)-General Fund Operating ***$0 $2,501,942 $2,501,942 135-10300 Prosperity Bank (XXX8701) General Fund Operating *$315,165 $1,099,336 $1,414,501 135-10305 Prosperity Bank Reserve-Savings Acct (XXXXX7724)$781,976 $0 $781,976 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 $155 $0 $155 519-10250 Texpool Revenue Bond Construction (XXXXX015) SWIFT $1,485 $0 $1,485 519-11155 Cash-Bond Escrow Bank of Texas (SWIFT)$749,385 $0 $749,385 528-10250 TexPool Revenue Bond Reserve (XXXXX014) WWTP Improvements $545,786 $0 $545,786 533-10250 TexPool Tax I & S (XXXXX0003)$873,573 $0 $873,573 533-10300 Prosperity Bank (XXX8701) Tax I&S $4,573 $0 $4,573 534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements $341,398 $0 $341,398 535-10250 Texpool Revenue I & S (XXXXX017) SWIFT $172,430 $0 $172,430 $4,417,669 $4,316,959 $8,734,628 Amount available in cash (MUD Accounts)$4,316,959 Amount available for spending (MUD Accounts)$4,316,959 * 05/31/18 Customer Water Deposits $315,165 122-10250 TexPool O & M (XXXXX0002)-Fire Operating Cash $0 $738,364 $738,364 122-10300 Prosperity Bank (XXX8701) Fire Operating $0 $0 $0 $0 $738,364 $738,364 Amount available in cash (Fire Department Accounts)$738,364 Amount available for spending (Fire Department Accounts)$738,364 715,081$ Bank of the West MM 1,099,336$ Prosperity General Fund 2,501,942$ Texpool General Fund 600$ Petty Cash Total General Fund 135 Available for Spending 4,316,959$ 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,315,517$ Total Nonspendable, Assigned & Committed Fund Balances - General Fund 135 $5,465,885 General Fund 135 Available General Fund 135 Fund Balances Fire Department Cash CASH STATUS AS OF MAY 2018 Restricted - Unable to be spent Unrestricted- Available for spending Total in Accounts (Restricted & Unrestricted) June 18, 2018 Regular Meeting Agenda Packet 149 of 150 TC Meeting SpacesModiÒerJuly 2018Printed on: 05/30/2018 3:48pmPowered byCalendarsFS Conference RoomFS Training RoomPS Large Conference RoomSvore Board RoomSunMonTueWedThuFriSat2728293031Jul 1, 201823456710:30am Parks/Res7am FD Ofácers Ms7pm Trophy Club W8910111213149am EMS Trainings10:30am Parks/Re9am EMS Trainings9am EMS Trainings1516171819202110:30am Parks/Re6:30pm Trophy Clus6pm Lakes of Trop8:15am Safety Meeti2223242526272810:30am Parks/Re10am Special Eve293031Aug 123410:30am Parks/Res7am FD Ofácers Ms7pm Trophy Club WsJune 18, 2018 Regular Meeting Agenda Packet150 of 150