Loading...
HomeMy WebLinkAbout2018-0515 May 15, 2018 Regular Meeting Agenda Packet        BOARD OF DIRECTORS  REGULAR MEETING    TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1  100 MUNICIPAL DRIVE  TROPHY CLUB, TEXAS 76262    May 15, 2018                                                               6:30 P.M.                                     Svore Municipal Boardroom   MEETING AGENDA PACKET   CALL TO ORDER AND ANNOUNCE A QUORUM    CITIZEN COMMENTS  This is an opportunity for citizens to address the Board on any matter whether or not it is posted on the agenda.  The Board is not permitted to take action on or discuss any presentations made to the Board at this time  concerning an item not listed on the agenda. The Board will hear presentations on specific agenda items prior  to the Board addressing those items. You may speak up to three (3) minutes or the time limit determined by  the President or presiding officer.    CONSENT AGENDA  All matters listed as Consent Agenda are considered to be routine by the Board of Directors and will be  enacted by one motion. There will not be a separate discussion of these items. If discussion is desired, that  item will be removed from the consent agenda and will be considered separately.    1. Consider and take appropriate action to approve the Consent Age nda.   a. April 2018 Check Register  b. April 17, 2018 Regular Meeting Minutes  c. May 3, 2018 Special Meeting Minutes    attachments:  April 2018 Check Register    April 17, 2018 Regular Meeting Minutes    May 3, 2018 Special Meeting Minutes    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.    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.    attachments:  redline – Amended ByLaws          Order No. 2018‐0515 Amending ByLaws          Exhibit “A”    4. Consider and take appropriate action to elect officers of the Board of Directors.  May 15, 2018 Regular Meeting Agenda Packet 1 of 175     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.    attachments:  Resolution No. 2018‐0515A                       Resolution No. 2018‐0515B   Resolution No. 2018‐0515C   Resolution No. 2018‐0515D    6. Consider and take appropriate action on scheduling meeting for orientation of new directors.    attachment:  Calendar    7. Consider and take appropriate action regarding Master Service Agreement for Pipe Cleaning with ACE  Pipe Cleaning.    attachment:  Master Service Agreement    8. Consider and take appropriate action regarding the April 2018 Combined Financials and Variance Report.   a. Combined Financials   b. Combined Variance             attachments:  Combined Financials           Combined Variance       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  May 15, 2018 Regular Meeting Agenda Packet 2 of 175      Utility Billing Report   Permits Collected   Cash Report           attachments:  General Manager Update    Draft Change Order Policy    Water Operations Report    Wastewater Operations Report   Website Analytics   Utility Billing Report   Permits Collected   Cash Report                  EXECUTIVE SESSION  10. Pursuant to Section 551.071 of the Texas Open Meetings Act, the Board may consult with its attorney in  Executive Session on a matter in which the duty of the attorney to the Governmental Body under the  Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflicts with the Open  Meetings Act or to seek advice of counsel on legal matters involving pending or contemplated litigation  or settlement offers:      a. Contractor breach, performance and payment issues related to District’s contract with Webber‐ Cadagua Partners for construction of the Wastewater Treatment Plant Improvements; and  b. Trophy Club Municipal Utility District No. 1 v. Acadia Services, LLC, In the District Court of Tarrant  County, 141st Judicial District (Cause No. 141‐299351‐18).  11. Pursuant to Section 551.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.  REGULAR SESSION  12. Consider and take appropriate action on matters deliberated in Executive Session:    13. Items for future agendas:    14. Set future Meeting dates – Regular Meeting and Special Meetings    attachment:  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  CLOSED SESSION.    ADJOURN  May 15, 2018 Regular Meeting Agenda Packet 3 of 175     THE STATE OF TEXAS §   COUNTIES OF DENTON AND TARRANT  §    THIS NOTICE CERTIFIES THAT BY 6:00 P.M. ON FRIDAY, MAY 11, 2018, THE REGULAR MEETING AGENDA OF  TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1, BOARD OF DIRECTORS REGULAR MEETING TO BE HELD  ON TUESDAY, MAY 15, 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                May 15, 2018 Regular Meeting Agenda Packet 4 of 175 May 15, 2018 Regular Meeting Agenda Packet 5 of 175 May 15, 2018 Regular Meeting Agenda Packet 6 of 175 May 15, 2018 Regular Meeting Agenda Packet 7 of 175 May 15, 2018 Regular Meeting Agenda Packet 8 of 175 May 15, 2018 Regular Meeting Agenda Packet 9 of 175 May 15, 2018 Regular Meeting Agenda Packet 10 of 175 May 15, 2018 Regular Meeting Agenda Packet 11 of 175 May 15, 2018 Regular Meeting Agenda Packet 12 of 175 May 15, 2018 Regular Meeting Agenda Packet 13 of 175 May 15, 2018 Regular Meeting Agenda Packet 14 of 175   REGULAR MEETING MINUTES   TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1  BOARD OF DIRECTORS   April 17, 2018 at 6:00 P.M.  100 Municipal Drive, Trophy Club, Texas 76262    Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in  Regular Session on April 17, 2018 at 6:00 P.M., in the Boardroom of the Administration Building, 100  Municipal Drive, Trophy Club, Texas 76262. The meeting was held within the boundaries of the District, and  was open to the public.    STATE OF TEXAS                              §  COUNTIES OF DENTON AND TARRANT             §    BOARD MEMBERS PRESENT:  Kevin R. Carr  President  Gregory Wilson  Vice President  Jim Thomas  Director  Jim Hase  Director    BOARD MEMBERS ABSENT:  William C. Rose  Secretary/Treasurer    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 April 17, 2018, called the meeting to order and announced a quorum  present at 6:03 p.m.   CITIZEN COMMENTS  There were no speakers    CONSENT AGENDA  1. Consider and take appropriate action to approve the Consent Age nda.   a. Quarterly Investment Reports – 2nd quarter  b. Tax Collections  c. March 2018 Check Register  d. March 20, 2018 Regular Meeting Minutes      Motion made by Director Thomas and seconded by Director Hase to approve the consent agenda as  presented.    Motion carried unanimously    May 15, 2018 Regular Meeting Agenda Packet 15 of 175   REGULAR SESSION  2. Presentation of service awards to Directors Carr, Hase and Thomas by General Manager John Carman.    General Manager John Carman presented service awards to the outgoing board members and thanked  them for their service.      3. Public  Statements  by existing  directors who are  not seeking  reelection relating  to their service as  directors and the District’s historical operations and achievements. (Thomas)    Directors Kevin Carr, Jim Hase and Jim Thomas made comments regarding their time spent on the Board  of Directors.    The Board recessed at 6:30 p.m. and returned to Regular Session at 6:41 p.m.    4. Consider and take appropriate action regarding the Amendment No. 1 to contract with Halff Associates,  Inc. for engineering services relating to the water transmission line interconnect from Pump Station to  Eastern Storage Tank.  Water Superintendent Mike McMahon stated that Amendment No. 1 is to cover the cost of additional  easement acquisitions.  McMahon stated that a small portion of the alignment was changed to reduce  the amount of boring that needs to be completed for the water line.   McMahon added that this will  increase the engineering cost and the construction cost should be reduced. General Manager John  Carman stated that it is anticipated the overall cost will go down when the project is bid due to the  reduced length of boring to install the pipe    Motion made by Director Thomas and seconded by Director Carr to approve Amendment No. 1 to the  contract  with  Halff  Associates,  Inc.  for  engineering  services  relating  to  the  water  transmission  line  interconnect from Pump Station to Eastern Storage Tank.    For: Hase, Thomas and Carr  Oppose: Wilson    Motion passed 3‐1    5. Consider and take appropriate action regarding awarding the bid for the 16‐inch off site waterline to  serve Trophy Club Town Center and approve Contract No. 2018041701 providing for construction of such  waterline improvements.  Motion made by Director Carr and seconded by Director Thomas to award the bid for the 16‐inch offsite  waterline to La Banda, LLC and approve Contract No. 2018041701 for construction of such waterline  improvements for an amount not to exceed $188,625.    Motion carried unanimously    May 15, 2018 Regular Meeting Agenda Packet 16 of 175   6. Consider and take appropriate action regarding adoption of Resolution No. 2018‐0418A Authorizing the  General Manager to Approve Construction Contract Change Orders.     Motion made by Director Carr and seconded by Director Hase to table this item until the May Meeting and  the new board is seated.     Motion carried unanimously    7. Discussion and possible action regarding revision of water and sewer rates for governmental customers.  (Carr)  Attorney Corbett stated that “Under the water code the board of directors of a district has broad  authority to establish different customer classes.  If the Board chose to do so it could establish a customer  class for government customers.  In all cases, your rates are supposed to reflect your cost of service  associated with each of those classes and obviously the District has retained NewGen to calculate those  cost of service and the revenue required for each class of customers.  So, if you went forward with this I  would recommend that a cost of service study be undertaken in connection with establishing the  revenue requirement and cost of service for such a customer class.  I would note that governmental  customers don’t pay taxes like your other customers do, so the cost of service for other customers would  reflect their non‐rate service and contributions so it is very possible that this class may end up with a  higher rate because they are not offsetting their cost of service with any taxes.  Unlike other types of  entities, MUD’s are subject to appeal and review by state agencies where obviously a municipality rates  are not, so you have the authority to establish a separate customer class.  But, I would urge you to  consider it carefully because it may end up being a higher rate because they don’t submit and offset their  payment of service by payment of taxes.”   Director Carr stated that the schools might ask to have a government rate.  Attorney Corbett stated that  other customers in the District could complain that it is discriminatory for one customer class rates not  to reflect a cost of service.  Corbett urged the Board to be very careful about moving forward and have  discussions with NewGen prior taking action.  Discussion only, no action taken.  8. Discussion and possible action regarding procedures for agenda preparation and packet information.  (Carr)  a. Discussion regarding agenda preparation procedures; and  b. Consider  and  take  appropriate  action  regarding  possible  amendments  to  District  Bylaws:  Organization,  Procedures,  Travel  Expenditure  Policy,  Professional  Services  Policy,  Management  Information Policy and Code of Ethics.    Director Carr requested that agenda items and information be brought to the board when they are  received so the board can have more information when requesting items for the agenda.        May 15, 2018 Regular Meeting Agenda Packet 17 of 175   9. Consider and take appropriate action regarding the March 2018 Combined Financials and Variance  Report.   a. Combined Financials   b. Combined Variance     Motion made by Director Thomas and seconded by Director Hase to approve the March 2018 Combined  Financials and Variance Report.    Motion carried unanimously    REPORTS & UPDATES  10. General Manager Monthly Reports and Update:  a. Regulatory Update  b. Class and Compensation Study Update  c. Auction of Surplus Property Update  d. Election information  e. Capital Improvement Projects    16‐inch waterline project to serve Town Center    Wastewater Treatment Plant Upgrade Project   High Service Pump    Joint Projects with Town  f. Water System Operation  g. Wastewater System Operation  h. Website Analytics  i. Finance Update   Utility Billing Report   Permits Collected   Cash Report   General Manager John Carman presented the March monthly reports and updates to the board and  answered questions related thereto.     The Board of Directors did not convene into Executive Session    EXECUTIVE SESSION  11. 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.    REGULAR SESSION  12. Consider and take appropriate action on matters deliberated in Executive Session:    May 15, 2018 Regular Meeting Agenda Packet 18 of 175     13. Items for future agendas:    14. Set future Meeting dates ‐ Regular Board Meeting on May 15, 2018 at 6:30 p.m.      ADJOURN      Director Carr adjourned the meeting at 7:17 p.m.         ___________________________  Kevin R. Carr President                                                                                                     ____________________________                                                   William R. Rose, Secretary/Treasurer                                 ____________________________  Laurie Slaght, District Secretary    May 15, 2018 Regular Meeting Agenda Packet 19 of 175 SPECIAL MEETING MINUTES   TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1  BOARD OF DIRECTORS   MAY 3, 2018 at 6:00 P.M.  100 Municipal Drive, Trophy Club, Texas 76262    Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in a  Special Session on May 3, 2018 at 6:00 P.M., in the Boardroom of the Administration Building, 100  Municipal Drive, Trophy Club, Texas 76262. The meeting was held within the boundaries of the District,  and was open to the public.    STATE OF TEXAS                            §  COUNTIES OF DENTON AND TARRANT       §    BOARD MEMBERS PRESENT:  Kevin R. Carr  President  William C. Rose  Secretary/Treasurer  Jim Thomas  Director  Jim Hase  Director    BOARD MEMBERS ABSENT:  Gregory Wilson  Vice President     STAFF PRESENT:  John Carman  General Manager  Laurie Slaght  District Secretary    GUESTS PRESENT:   Robert West  Whitaker Chalk Swindle & Schwartz, PLLC.    CALL TO ORDER AND ANNOUNCE A QUORUM   President Carr announced the date of May 3, 2018, called the meeting to order and announced a  quorum present at 6:02 p.m.   REGULAR SESSION  1.  Consider and take appropriate action to approve engagement of Whitaker Chalk Swindle & Schwartz  PLLC as special litigation counsel.    Motion made by Director Carr and seconded by Director Rose to approve engagement of Whitaker  Chalk Swindle & Schwartz PLLC as special litigation counsel.    Motion carried unanimously    The Board convened into Executive Session at 6:04 p.m.    EXECUTIVE SESSION  2.  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  May 15, 2018 Regular Meeting Agenda Packet 20 of 175 with the Open Meetings Act or to seek advice of counsel on legal matters involving pending or  contemplated litigation or settlement offers:      a.  Enforcement  of  District  rights  under  that  certain  “Non‐Exclusive  Easement  for  Underground  Facilities” dated December 15, 1987.    b.  Litigation  against  Acadia  Services,  LLC  relating  to  ongoing  construction  of  permanent  improvements impairing the District’s access, maintenance and repair of facilities.    The Board reconvened into Regular Session at 6:37 p.m.    REGULAR SESSION  3.   Consider and take appropriate action on matters deliberated in Executive Session.    Regarding Executive Session item 2.a.    Motion made by Director Rose and seconded by Director Thomas that the General manager and  special litigation counsel Whitaker Chalk Swindle & Schwartz PLLC are directed to take necessary  action to resolve the easement incursion by Acadia Services, LLC relating to ongoing construction of  permanent  improvements  impairing  the  District’s  access,  maintenance  and  repair  of  facilities  in  Solana.     Motion carried unanimously    ADJOURN    Motion made by Director Carr and seconded by Director Rose to adjourn the meeting.    Motion carried unanimously      President Carr adjourned the Meeting at 6:38 p.m.      ______________________________  Kevin R. Carr President                                                                           _____________________________                                                                   (SEAL)  William R. Rose, Secretary/Treasurer                              ______________________________  Laurie Slaght, District Secretary  May 15, 2018 Regular Meeting Agenda Packet 21 of 175 BYLAWS TABLE OF CONTENTS ARTICLE I Organization, Powers and Office ARTICLE II Board of Directors ARTICLE III Officers of the Board ARTICLE IV Administrative Services ARTICLE V Meetings and Agenda ARTICLE VI Fees of Travel Expense Policy ARTICLE VII Professional Services Policy ARTICLE VIII Management Policy ARTICLE IX Code of Ethics May 15, 2018 Regular Meeting Agenda Packet 22 of 175 Definitions District. The term “District” shall mean Trophy Club Municipal Utility District No. 1. Board. The term “Board” shall mean and refer to the District’s governing body. Director. The term “Director” shall mean a person elected or appointed to serve on the District’s Board of Directors. District Representatives. The term “District Representatives” shall mean District Directors, officers, employees, and persons, who are engaged in handling investments for the District. Employee. The term “employee” shall mean any person employed by the District, but it does not include independent contractors or professionals hired by the District as outside consultants. Substantial Interest. The phrase “substantial interest” shall have the meaning set forth in Chapter 171 of the Texas Local Government Code. TWC. The term “TWC” shall mean the Texas Water Code. May 15, 2018 Regular Meeting Agenda Packet 23 of 175 ARTICLE I ORGANIZATION, POWERS AND OFFICE Section 1.01. Organization. Trophy Club Municipal Utility District No. 1 (“the District”) is a political subdivision of the State of Texas created and operating pursuant to Chapters 49 and 54 of the Texas Water Code and Section 59, Article XVI of the Texas Constitution. Section 1.02. Powers. The District has all of the rights, powers, privileges, authority, functions and duties necessary and convenient to accomplish the purposes established for a municipal utility district as provided by Chapters 49 and 54 of the Texas Water Code. Section 1.03. Office. The chief administrative office the District shall be located within the boundaries of Trophy Club Municipal Utility District No. 1. ARTICLE II BOARD OF DIRECTORS Section 2.01. General Powers and Number. The District shall be governed by its Board . The business and affairs of the District shall be conducted under the authority and direction of the Board. The number of Directors on the Board shall be five (5). In the event of a vacancy in the office of director, the Board shall appoint a qualified person to the office as required by Texas Water Code 49.105. Section 2.02. Qualifications of Directors. Each Director, whether elected or appointed, shall qualify by the execution of a bond to be paid by the District, and execution of the Constitutional Oath of Office and Statement of Officer. A person shall not serve as a Director if he or she is not qualified to do so under the provisions of the TWC. Within sixty (60) days after the Board determines that any Director is not qualified to serve on the Board, it shall replace that Director with a person who is qualified. Any Director not qualified to serve on the Board, who willfully occupies an office and exercises the duties and powers of that office, may be subject to penalties under the TWC, as amended, including possible conviction of a misdemeanor and imposition of a fine. Section 2.03. Tenure. Except as provided by the TWC, each Director shall serve for a period of four (4) years and until his or her successor is elected and qualified. Any Director appointed to the Board shall serve for the remainder of the term of office to which that Director is appointed. Section 2.04. Policy Role of Directors. The Board will establish policies for the governance and conduct of the District and its operations with the advice, information and analysis provided by the staff, District consultants and public. Except as provided by District Order, Directors therefore shall not interfere with the administrative functions of the District or the professional duties of the District staff; nor shall they impair the ability of staff to implement Board policy decisions and directives. Except as otherwise approved by the Board, individual Directors shall take all requests of staff to the General Manager and shall not contact employees directly. Only the Board, acting as a body, may issue directions to the General Manager. Section 2.05. Director Advocacy. Directors shall represent the official policies or positions of the Board to the best of their ability when designated as delegates for this purpose. Section 2.06. Representation of Private Interests. In keeping with their role as stewards of the public interest, Directors shall not appear on behalf of private interests of third parties before the District’s Board of Directors or any other District board, commission, or committee. May 15, 2018 Regular Meeting Agenda Packet 24 of 175 Section 2.07. Influencing Boards, Commissions, and Committees. Because of the value of the independent advice of boards, commissions, committees and advisory groups to the public decision making process, Directors shall refrain from using their position to influence the deliberations or outcomes of any board, commission, committee, or advisory group proceedings. ARTICLE III OFFICERS OF THE BOARD Section 3.01. Officers. The officers of the District shall be a President, a Vice President, a Secretary/Treasurer, and other officers as may be elected in accordance with the provisions of this Article. The Board may elect or appoint other officers as it may deem desirable and those officers shall have the authority to perform the duties prescribed from time-to-time by the Board. Section 3.02. Election and Term of Office. The officers of the District shall be elected annually by the Board aton or prior to the regular meetinglast day of June each year, or as otherwise determined by a majority of the Board in Juneof Directors due to vacancies, resignations and other circumstances. New offices may be created and filled at any meeting of the Board. Each officer shall hold office until his successor shall have been duly elected. Section 3.03. Removal. Any Director elected or appointed as an officer of the District by the Board may be removed from that office by the Board whenever the best interests of the District would be served thereby. That removal shall not constitute a removal from the Board. Section 3.04. Vacancies. A vacancy in any office because of death, resignation, removal, disqualification, or otherwise must be filled by the Board for the unexpired portion of the term in accordance with Section 49.105 of the Texas Water Code regarding the filling of vacancies. Section 3.05. President. The President is the chief executive officer and shall be a member of the Board with all the rights and privileges thereof, including the right to introduce motions before the Board and to vote on all matters. The President shall preside at all meetings of the Board. The President shall sign any deeds, mortgages, bonds, contracts, or other instruments which the Board has authorized to be executed, except in cases where the signing and execution thereof shall be expressly delegated by the Board to the General Manager; and in general, the President shall perform all duties as may be prescribed by the Board from time-to-time. Section 3.06. Vice President. The Vice President shall be a member of the Board and shall act as President in the case of the absence or inability of the President to perform the duties of the President. A Vice President shall perform other duties as from time-to-time may be assigned by the Board. Section 3.07. Secretary/Treasurer. In the role as Secretary, the Secretary/Treasurer is responsible for seeing that all records and books of the District are properly kept and may attest the President’s signature on documents. The Board may appoint another director, the General Manager, or any employee as Assistant or Deputy Secretary to assist the Secretary, and any such person shall be entitled to certify as to the authenticity of any record of the district, including but not limited to all proceedings relating to bonds, contracts, or indebtedness of the district. As Secretary , the Secretary/Treasurer shall perform other duties as from time-to-time may be assigned by the Board. In the role as Treasurer, the Secretary/Treasurer is responsible for monitoring all District funds and securities; reviewing the receipts of all money due and payable to the District; reviewing the deposit of all moneys in the name of the District in banks as shall be selected by the Board; and reviewing the disbursements of the District. As Treasurer, the Secretary/Treasurer shall perform other duties as from time-to-time may be assigned by the Board. May 15, 2018 Regular Meeting Agenda Packet 25 of 175 ARTICLE IV ADMINISTRATIVE SERVICES Section 4.01 Administrative Departments. The General Manager shall establish administrative departments. The head of each department shall be appointed by the General Manager and shall be subject to the direction and supervision of the General Manager. Section 4.02 General Manager – Appointment and Qualifications A. As permitted under Texas Water Code Section 49.056, the Board of Directors shall appoint a General Manager, who shall be the chief administrative officer of the Municipal Utility District. B. The method of selection shall be left to the discretion of the Board of Directors so long as the method insures orderly, non-partisan action toward securing a competent and qualified person to fill the position. The General Manager shall be chosen on the basis of administrative training, experience, ability, character and other such professional qualifications as determined appropriate by the Board of Directors. 
 Section 4.03 Compensation. The General Manager shall receive compensation as shall be fixed by the Board of Directors. Section 4.04 Term and Removal. The General Manager shall not be appointed or retained for a definite term, but may be suspended or removed at the discretion of the Board of Directors in accordance with applicable terms of the District’s personnel policies or contract with the General Manager. The action of the Board in suspending or removing the General Manager shall be final. It is the intention of this section to vest all authority and fix all responsibilities of such suspension or removal in the Board of Directors. Section 4.05 Powers and Duties. The General Manager shall be the chief administrative officer and head of the administrative branch of the District. The General Manager shall be responsible to the Board of Directors for the proper administration of all the affairs of the District and to that end shall, except as otherwise limited by order or contract approved by the Board, have the power and be required to: A. Oversee the effective enforcement of all applicable laws and resolutions, implement the directives and policies established by Board of Directors and oversee the administration of contracts and franchises to ensure compliance with the terms approved by Board of Directors; B. Appoint, suspend and/or remove all or any one of the heads of departments and all subordinate officers and employees of the District in accordance with applicable laws and policies. The General Manager may authorize any administrative officer subject to the Manager’s direction and supervision to exercise these powers with respect to subordinates in that officer’s department, office or agency. Contract General Managers shall obtain preapproval from the Board prior to taking action under this paragraph; C. Direct and supervise the administration of all departments; D. Attend all meetings of the Board, except when excused by the Board of Directors. The General Manager shall have the right to take part in discussion but shall not vote; 
 E. Prepare and submit the annual budget and capital program to the Board of Directors, and implement the final budget approved by the Board of Directors to achieve the goals of the District; 
 F. 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; 
 May 15, 2018 Regular Meeting Agenda Packet 26 of 175 G. Keep the Board of Directors fully advised as to the financial condition and future needs of the District; 
 H. Be responsible for all funds and securities of the District; review the receipts of all money due and payable to the District from any source; assure the deposit of all moneys in the name of the District in banks as selected by the Board; and, review the disbursements of the District; I. Ensure that all records and books of the District are properly kept and that all notices are duly given in accordance with the provisions of these rules or as required by law; J. Certify as to the authenticity of any record of the District, including but not limited to all proceedings relating to bonds, contracts, or indebtedness of the District; K. Make recommendations to the Board of Directors concerning affairs of the District and facilitate the work of the Board of Directors in developing policy; 
 L. Provide staff support services for the Directors of the Board; 
 M. Assist the Board of Directors in developing goals and strategies for the next fiscal period; 
 N. Assist the Board of Directors to develop long term goals for the District and develop strategies to implement those goals; 
 O. Encourage and provide staff support for regional and intergovernmental cooperation; P. Promote partnerships among Board of Directors, staff, and citizens in developing public policy and building a sense of community; Q. Perform such other duties as may be prescribed by Board of Directors, by resolution or other law; and, R. Recommend to the Board of Directors rules and regulations to be adopted by resolution to protect the safety and security of the municipal records. 
 Section 4.06 Acting General Manager A. The General Manager, within thirty (30) days after taking office, shall designate, by letter filed with the District Secretary, a qualified administrative officer of the District to perform the duties of the General Manager in his absence or disability. Such designation shall be subject to approval of the Board of Directors. Upon resignation or termination of the General Manager, the Acting General Manager shall perform the duties of the General Manager until a new General Manager or Acting General Manager is appointed by the Board of Directors. 
 B. Should the need for an Acting General Manager occur prior to the General Manager submitting a designee or prior to the Board of Directors' approval of the General Manager's designee, the Board of Directors shall appoint an Acting General Manager. 
 C. The General Manager may select a different Acting General Manager, at any time, by repeating the letter of designation and obtaining the Board of Directors' approval for designation of a new Acting General Manager. 
 Section 4.07 District Secretary. The General Manager shall appoint a District Secretary who shall act as the secretary to the Board. The District Secretary shall be entitled to a seat at the Board table at all official meetings. May 15, 2018 Regular Meeting Agenda Packet 27 of 175 Section 4.08 Duties of the District Secretary. The District Secretary shall: A. Record the minutes of all official meetings of the Board; provided, however, only the captions of duly enacted resolutions shall be recorded in the minutes; 
 B. Hold and maintain the District Seal and affix to all instruments requiring such seal; 
 C. Be the custodian of all municipal records of the District; and 
 D. Perform such other duties as may be required by the Board of Directors, the General Manager, or the laws of the State of Texas. Section 4.09 General Legal Counsel. The Board of Directors shall retain an attorney licensed and in good standing to practice in the State of Texas as the General Legal Counsel. General Legal Counsel shall serve at the discretion of the Board of Directors and shall receive compensation as approved by the Board of Directors. The authority to set compensation may be delegated at the discretion of Board of Directors. Section 4.10 District Committees A. Members of committees appointed by the Board shall serve without compensation, provided, however, that they shall be entitled to reimbursement of any reasonable and necessary expenses incurred in the performance of their official duties, when approved by Board of Directors or their designee. B. All committees shall maintain minutes of their meetings which shall be public records and which indicate, at a minimum, the member’s present, subject of matters considered and the result of any vote taken. The minutes shall also indicate how each member voted on each matter. ARTICLE V MEETINGS AND AGENDA Section 5.01. Meetings. The Board shall establish a regular meeting time and place or places. The Board shall have Regular Board Meetings monthly except upon the occasion when it is determined that no meeting is necessary in a particular month. In any event, the Board shall meet no less than four (4) times each year. A. Regular Board Meetings are normally held on the third TuesdayMonday of every month at 6:30 P.M. in the Svore Municipal Building Boardroom located at 100 Municipal Drive, Trophy Club, Texas, 76262. The date, location and time may be changed by vote of the Board of Directors. Meeting locations must be approved by resolution of the District and the Texas Commission on Environmental Quality (TCEQ) must be notified of any permanent change in location. B. Emergency Meetings may be called when authorized by Section 551.045 of the Texas Government Code. Emergency Meetings are to be called only in situations where an emergency or an urgent public necessity exists and immediate action is required by the Board because of: (1) an imminent threat to public health and safety; or (2) a reasonably unforeseeable situation. The emergency or urgent public necessity shall be clearly identified. The meeting may be called by the President of the Board, the General Manager, or by a majority of the members of the Board, with two (2) hours’ notice. C. Special Board Meetings may be called by the President of the Board or the General Manager at any time with seventy-two (72) hours’ notice for the purpose of conducting District May 15, 2018 Regular Meeting Agenda Packet 28 of 175 business as may be required between Regular monthly meetings. D. Joint Meetings with other governmental entities are considered Special meetings but require additional coordination with another governmental entity. E. Public Hearings may be called with notice as required by State Law. A public hearing is held to allow citizens to learn about, and to comment on, a specific matter under consideration by the District. Normally, no action will be taken during a public hearing, but public hearings may be held during regular or special meetings and action may be taken following the public hearing. F. Notice of Quorum may be posted when a quorum of the Board is expected to attend an event not called by the District. A quorum notice is not required for social gatherings in which no District business is discussed. G. Work Sessions may be called prior to a regular meeting to explore one or more matters in detail. Section 5.02. Quorum. A majority of the Board shall constitute a quorum for the transaction of business at any meeting of the Board. The act of three (3) Directors at a meeting for which a quorum is present shall be the act of the Board. Section 5.03. Conduct of Meetings. The President shall preside at Board meetings. In the absence of the President, the Vice President shall preside. In the absence of the President and Vice President, the Secretary/Treasurer shall preside. The Board may provide a portion of each meeting for public comments in accordance with the policies established for receipt of public comment. Directors will listen courteously and attentively to all public discussions before the body. They shall refrain from interrupting other speakers, making personal comments not germane to the business of the body, or otherwise interfering with the orderly conduct of meetings. The Board shall generally use Roberts Rules of Order Newly Revised as guidelines for meeting procedures and votes with the exception that discussion may occur prior to a motion being made. Section 5.04 Agenda Procedure A. Regular Board Meetings: Any item requested by two (2) Directors, or the President, or the General Manager shall be placed on the agenda by the District Secretary. If a Director would like to place an item on an agenda, the Director must get one additional Director to agree to the item. Each of these Directors should then submit the item and available supporting documents in writing to the General Manager and District Secretary not less than four (4) business days prior to the agenda posting date. Any items received from two Directors with less than four (4) business days’ notice prior to posting (72 hours in advance of meeting) will be placed on the next regularly scheduled meeting agenda. B. At each regular Board meeting, an agenda item shall be included to allow Directors to request items to be placed on future agendas. Director requested agenda items will not be denied, but the future agenda to which it is posted shall be at the discretion of the Board President. C. Emergency Meetings: Emergency meetings can only be called in accordance with the Open Meetings Act and the agenda must be set and approved by General Legal Counsel. No Director requests for additional agenda items shall be permitted for an emergency meeting. D. Special Meetings: Special meetings are set for specific purposes only, and agendas shall be drafted by the General Manager and approved by the Board President. E. Joint Meetings: Joint meeting agendas shall be coordinated and drafted by the General Manager. F. Public Hearing and Notice of Quorum: A Public Hearing Notice or Notice of Quorum May 15, 2018 Regular Meeting Agenda Packet 29 of 175 shall be drafted and approved by the General Manager. Section 5.05. Posting Agendas and Notice to Directors. The General Manager shall confer with General Legal Counsel prior to each meeting to insure the agenda meets legal requirements. After approval of the agenda by the President and General Manager, the District Secretary shall post the agenda as required by the Texas Open Meetings Act. Notice to the Directors of Regular and Special meetings of the Board shall be given at least seventy-two (72) hours prior to the meeting. A copy of the posted agenda will be placed on the District webpage, and will be available for the public at the meeting. ARTICLE VI FEES AND TRAVEL EXPENSE POLICY Section 6.01. Purpose. The purpose of this Expense Policy is to set forth the policies of Trophy Club Municipal Utility District No. 1 concerning fees and travel expenses for members of the Board of Directors of the District. Section 6.02. Fees of Office for Directors. Directors shall not receive fees of office for performing the duties of a Director. “Performing the duties of a Director” means performance of the management or business of the District, including participation in Board and committee meetings and other activities involving the deliberation of District business, and in pertinent educational programs. Section 6.03. Attendance at Meetings and Conduct of Other District Business. Board members may attend conferences and meetings of the Association of Water Board Directors, at the District’s expense, whether within or outside the Town of Trophy Club. Attendance at other conferences, hearings, or other meetings outside of Trophy Club by the members of the Board of Directors must be approved by the Board of Directors; attendance at local meetings or conduct of other local District business will be at each Director’s discretion. Directors attending any meeting or conducting any District business shall report to the Board concerning the meeting or activity. Section 6.04. Expenses Outside of Trophy Club. The District will pay a reasonable room rate for a Director’s hotel room, if District business approved by the Board requires overnight travel, reasonable tips incurred in making the trip, round-trip mileage at the current IRS mileage rate and parking, if any, for travel by car or round-trip airfare at current commercial rates for standard (not first class) air fare and reasonable rental car or taxi charges. Mileage will be computed by the most direct route. The District will pay for meals actually eaten and paid for by the Director on an approved trip; provided, however, reimbursement for meals will be limited to $75.00 per day per person. Appropriate documentation listing the person in attendance and a description of the business discussed at the meeting or activity is required. All reimbursement requires receipts of purchase. No reimbursement shall be made for the purchase of entertainment or the purchase of alcoholic beverages. No reimbursement shall be made for expenses of a spouse of a Director. Section 6.05. Expenses for Local Meetings and Activities. The District will pay for meals directly related to the meeting or activity. Reimbursement for meals will be limited to $75.00 per day per person. Appropriate documentation listing the person in attendance and a description of the business discussed at the meeting or activity is required. No reimbursement shall be made for the purchase of alcoholic beverages. No reimbursement shall be made for the expenses of a spouse of a Director. Section 6.06. Reimbursement. To receive reimbursement for expenses, a Director must submit an itemized expense report including receipts, to the District Finance Department before reimbursement is approved by the General Manager. Items on the expense report shall include lodging, meals, tips, mileage, parking and transportation. Directors sharing expense items may split reported expenses in any manner they deem equitable, but the Board will pay no more than 100% of the actual total cost of reimbursable items. May 15, 2018 Regular Meeting Agenda Packet 30 of 175 Section 6.07. Extraordinary Expenses. Any extraordinary expenses for a Director attending an approved activity of the District must be approved by the Board prior to incurring the expense. ARTICLE VII PROFESSIONAL SERVICES POLICY Section 7.01. Purpose. This policy has been adopted to provide for the selection, monitoring, review, and evaluation of the District’s professional services contracts. Consultants retained by the District to provide professional services include, but are not limited to, legal, engineering, financial advisor, management, bookkeeping, auditing, and tax collecting. Section 7.02. Selection of Consultants. Selection of consultants shall be based upon their qualifications and experience. Whenever the Board of Directors of the District decides to terminate the services of one or more of its Consultants, the Board, working through staff, shall solicit one or more proposals as required by the Professional Services Procurement Act, Section 2254.001 et seq., Government Code. Selection of consultants is to be conducted by the Board in an open meeting. Section 7.03. Monitoring of Consultants. The performance of the Consultants providing professional services to the District shall be regularly monitored and reviewed by the General Manager and Board. For those Consultants with annual contracts, the Board of Directors and General Manager of the District will review the performance of the Consultants for the prior year at the time the contract is renewed. The Board of Directors shall review the performance of its other Consultants, upon the request of one or more Directors. ARTICLE VIII MANAGEMENT POLICY Section 8.01. Purpose. The Board desires to adopt a policy to ensure better use of management information, including the use of budgets in planning and controlling costs, the establishment of a functioning audit committee, and the use of uniform reporting requirements. Section 8.02. Accounting Records. District accounting records shall be prepared on a timely basis and maintained in an orderly manner; to comply with generally accepted accounting principles and the requirements of the Texas Commission on Environmental Quality. Accounting records shall be available for public inspection during regular business hours at the District’s office. Section 8.03. Audit Requirements. A. The District’s fiscal accounts and records shall be audited annually according to state law governing the audits of districts, at the expense of the District, by a certified public accountant familiar with the Texas Commission on Environmental Quality’s rules, regulations, standards, and guidelines applicable to district audits. The District hereby directs its auditor to adopt uniform auditing reporting requirements that use “Audits of State and Local Governmental Units” as a guide on audit working papers and that uses “Governmental Accounting and Financial Reporting Standards” for final audit reports. B. The audit shall be completed and filed within the time limits established by the TWC. A copy of the audit shall be filed with the Texas Commission on Environmental Quality together with an annual filing affidavit in the form prescribed by TWC. In the event the Board refuses to approve the annual audited report, the District shall file a statement with the audit to explain the Board’s reasons for disapproving the audit. 
 May 15, 2018 Regular Meeting Agenda Packet 31 of 175 Section 8.04. Audit Committee. The Board shall establish an audit committee comprised of not less than two Directors and other persons as the Board may deem appropriate. The persons selected should not be directly responsible for work subject to the audit. The audit committee shall con duct, at a minimum, an annual review of the District’s financial status. The committee shall monitor variances from the District’s budget and shall review the District’s audit report and shall make recommendations to the Board. The final audit must be presented to the entire Board for approval prior to submittal to regulatory agencies. Section 8.05. Budget. The District shall annually adopt a budget according to Title 30 of the Texas Administrative Code, Section 293.97 for use in planning and controlling District costs. The budget shall take into consideration all District revenues, including, but not limited to, utility fees, taxes and surcharges, if any, and all projected District obligations and expenditures. The budget may be amended at any time but the Board shall approve the amendment in advance. A comparison of the actual operating results to the adopted budget, as amended, shall be presented in the annual report. The budgetary comparison statement shall be included either within the audited financial statements or within a supplementary section. ARTICLE IX CODE OF ETHICS Section 9.01. Purpose. This Code of Ethics has been adopted by the District to: (a) comply with TWC Section 49.199, as amended; (b) encourage high ethical standards in official conduct by District Representatives; and (c) establish guidelines for ethical standards of conduct. Except as otherwise provided, this Code of Ethics shall apply to all District Representatives. Section 9.02. Policy. It is the policy of the District that District Representatives shall conduct themselves in a manner consistent with sound business and ethical practices; that the public interest shall always be considered in conducting District business; that the appearance of impropriety shall be avoided to ensure and maintain public confidence in the District; and that the Board shall control and manage the affairs of the District fairly, impartially, and without discrimination, and according to the District’s purpose. Section 9.03 Qualification of Directors. A. A person shall not serve as a Director if he is disqualified by law from doing so under the general laws of the State of Texas. Section 49.052, Texas Water Code disqualifies certain persons from serving as Directors of the District. B. TWC Section 49.105 requires that a vacant position on the Board of Directors must be filled within 60 days. Therefore, within sixty (60) days after the Board determines that any Director is disqualified from serving on the Board, it shall replace that Director with a person who is qualified. C. Any Director who is disqualified from serving as a member of the Board under Section 49.052(a) of the Texas Water Code and who willfully occupies an office and exercises the duties and powers of that office may be subject to penalties under Section 49.052(c), Texas Water Code, including possible conviction of a misdemeanor and imposition of a fine. Section 9.04 Disqualification of Directors. Disqualification and removal of Directors shall be accomplished in accordance with Section 49.052, of the Texas Water Code. Section 9.05. Conflicts of Interest. The District adopts Chapter 171, Local Government Code, as its Conflict of Interest Policy, the principal provisions of which are as follows: Except where a May 15, 2018 Regular Meeting Agenda Packet 32 of 175 majority of the Board of Directors is required to abstain from participation in a vote because of conflict of interest, a Director will abstain from participating in a decision of the Board of Directors which either (1) confers a special economic benefit on a business in which the Director or a close relative has a substantial interest that is distinguishable from the effect on the public , or (2) will have a special economic effect on the value of property in which the Director or a close relative has a substantial interest distinguishable from its effect on the public. For these purposes, a person is considered to have a “substantial interest” in a business if (1) the person owns ten percent (10%) or more of the voting stock or shares of the business entity or owns either ten percent (10%) or more or $15,000 or more of the fair market value of the business entity; or (2) funds received from the business exceed ten percent (10%) of the person’s gross income for the previous year. A person has a substantial interest in real property if the interest is an equitable or legal interest with a market value of $2,500 or more. A “close relative” of a Director for these purposes is a person related to the Director within the first degree of affinity or consanguinity as determined under Chapter 573 of the Texas Government Code. A. A Director may not act as a surety on any official bond or for a business entity that has work, business, or a contract with the District. B. A Director shall not disclose, without written legal authorization, confidential information to advance the financial or other private interests of himself or others on any contract or transaction which is or may be the subject of an official action of the District. C. The District may not contract for the purchase of services or personal property directly with a District Representative or with a business entity in which a District Representative has a substantial interest, except as permitted by law. D. A Director who has a substantial interest in any matter involving the business entity or real property shall disclose that fact to the other Directors by Affidavit. The Affidavit must be filed with the Secretary of the Board at a posted meeting open to the public. An interested Director shall abstain from further participation in the matter. E. The Board shall take a separate vote on any budget item specifically dedicated to a contract with a business entity in which a Director has a substantial interest. In the event of a separate vote, the Director may not participate in that separate vote, but may vote on a final budget if the Director has complied with Local Government Code Chapter 171 and the matter in which the Director is concerned has been resolved. F. As of the date of adoption of this Code of Ethics, Chapter 176, Local Government Code requires the disclosure of certain relationships by Directors or by District Employees who exercise discretion in the planning, recommending, selecting or contracting of a vendor, vendors, and certain prospective vendors to the District, if the District or Employee, or family member of a Director or such Employee, has an employment or business relationship with the vendor that has resulted in taxable income that exceeds certain limits, or has received a gift from the vendor. A Director, Employee, vendor, or prospective vendor who has a relationship that requires disclosure under Chapter 176 shall disclose that relationship by completing the form prescribed by the Texas Ethics Commission and timely filing that form with the Records Administrator. A Director, Employee or vendor violating this Section may be subject to criminal prosecution or termination of employment under Section 176.013 of the Local Government Code. Section 9.06. Conduct of District Business. Each District Representative will conduct all business of the District in a manner consistent with the requirements of applicable law and the Texas Open Meetings Act. Section 9.07. Use of District Property. No Board member, officer, or Employee shall permit any personal or unauthorized use of District-owned or District-controlled equipment, materials, supplies, or May 15, 2018 Regular Meeting Agenda Packet 33 of 175 property. Directors shall not use public resources unavailable to the public, such as District staff time, equipment, supplies or facilities, for private gain or personal purposes. Directors shall not utilize the District’s name, logo, or their position for purposes of endorsing any political candidate, political position or business. Section 9.08. Nepotism. The Board shall not confirm the appointment to any position, nor award a contract, to a person related to a member of the Board within the second degree by affinity (marriage) or within the third degree by consanguinity (blood) when the salary or other com pensation of the appointee is paid, directly or indirectly, from District funds, except as provided by Government Code Chapter 573. Section 9.09. Acceptance of Gifts. No District Representative shall accept any benefit as consideration for any decision, opinion, recommendation, vote, or other exercise of discretion in carrying out his official acts for the District. No District Representative shall solicit, accept, or agree to accept any benefit from a person known to be interested in or likely to become interested in any contract, purchase, payment, claim, or transaction involving the exercise of the District’s Representative’s discretion. Section 36.10, Texas Penal Code lists exemptions to the Acceptance of Gifts Policy which are adopted and incorporated into this Code of Ethics. Section 9.10. Bribery. A District Representative shall not intentionally or knowingly offer, confer, or agree to confer on another, or solicit, accept, or agree to accept from another, any benefit as consideration when to do so is prohibited by law. As of the date of adoption of this Code of Ethics, Section 36.02, Texas Penal Code, lists the offenses that are considered bribery when committed by District Representatives. Section 9.11. Acceptance of Honoraria. A Director shall not solicit, accept or agree to accept an honorarium as prohibited by law. As of the date of the adoption of this Code of Ethics, Section 36.07, Texas Penal Code, provides the circumstances in which a Director may not accept an honorarium. Section 9.12. Lobbying. Should the Texas Ethics Commission, by rule require any District Representatives directly communicating with legislative or executive branch officials to register as lobbyists, District Representative’s shall comply. See Government Code, Section 305.0051. May 15, 2018 Regular Meeting Agenda Packet 34 of 175 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 ORDER NO. 2018-0515 AN ORDER AMENDING BYLAWS 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.057(g) of the Texas Water Code provides that the Board of Directors may adopt bylaws to govern the affairs of the District to perform its purposes; and WHEREAS, pursuant to the foregoing authority, the Board of Directors previously adopted Bylaws to govern the affairs of the District, and the Board of Directors now desires to amend such Bylaws; and WHEREAS, the Board of Directors specifically desires to: (i) revise Section 3.02 of the Bylaws to authorize the election of directors other than during the month of June each year; and (ii) revise Section 5.01(A) of the Bylaws in order to change the regular monthly meeting day of the Board of Directors. NOW THEREFORE, BE IT ORDERED 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 Order are hereby found and declared to be true and correct, and are incorporated by reference herein and expressly made a part hereof, as if copied verbatim. 2. The Board of Directors of the District hereby approves the amended Bylaws in the form attached as Exhibit “A” hereto. 3. The amended Bylaws attached hereto shall become effective immediately upon adoption of this Order. ADOPTED, PASSED AND APPROVED this the _____ day of May 2018. President, Board of Directors ATTEST: Secretary, Board of Directors May 15, 2018 Regular Meeting Agenda Packet 35 of 175 Exhibit “A” Revised Bylaws May 15, 2018 Regular Meeting Agenda Packet 36 of 175 BYLAWS TABLE OF CONTENTS ARTIC LE I Organization, Powers and Office ARTIC LE II Board of Directors ARTIC LE III Officers of the Board ARTIC LE IV Administrative Services ARTIC LE V Meetings and Agenda ARTIC LE VI Fees of Travel Expense Policy ARTIC LE VII Professional Services Policy ARTIC LE VIII Management Policy ARTIC LE IX Code of Ethics May 15, 2018 Regular Meeting Agenda Packet 37 of 175 Definitions District. The term “District” shall mean Trophy Club Municipal Utility District No. 1. Board. The term “Board” shall mean and refer to the District’s governing body. Director. The term “Director” shall mean a person elected or appointed to serve on the District’s Board of Directors. District Representatives. The term “District Representatives” shall mean District Directors, officers, employees, and persons, who are engaged in handling investments for the District. Employee. The term “employee” shall mean any person employed by the District, but it does not include independent contractors or professionals hired by the District as outside consultants. Substantial Interest. The phrase “substantial interest” shall have the meaning set forth in Chapter 171 of the Texas Local Government Code. TWC. The term “TWC” shall mean the Texas Water Code. May 15, 2018 Regular Meeting Agenda Packet 38 of 175 ARTICLE I ORGANIZATION, POWERS AND OFFICE Section 1.01. Organization. Trophy Club Municipal Utility District No. 1 (“the District”) is a political subdivision of the State of Texas created and operating pursuant to Chapters 49 and 54 of the Texas Water Code and Section 59, Article XVI of the Texas Constitution. Section 1.02. Powers. The District has all of the rights, powers, privileges, authority, functions and duties necessary and convenient to accomplish the purposes established for a municipal utility district as provided by Chapters 49 and 54 of the Texas Water Code. Section 1.03. Office. The chief administrative office the District shall be located within the boundaries of Trophy Club Municipal Utility District No. 1. ARTICLE II BOARD OF DIRECTORS Section 2.01. General Powers and Number. The District shall be governed by its Board . The business and affairs of the District shall be conducted under the authority and direction of the Board. The number of Directors on the Board shall be five (5). In the event of a vacancy in the office of director, the Board shall appoint a qualified person to the office as required by Texas Water Code 49.105. Section 2.02. Qualifications of Directors. Each Director, whether elected or appointed, shall qualify by the execution of a bond to be paid by the District, and execution of the Constitutional Oath of Office and Statement of Officer. A person shall not serve as a Director if he or she is not qualified to do so under the provisions of the TWC. Within sixty (60) days after the Board determines that any Director is not qualified to serve on the Board, it shall replace that Director with a person who is qualified. Any Director not qualified to serve on the Board, who willfully occupies an office and exercises the duties and powers of that office, may be subj ect to penalties under the TWC, as amended, including possible conviction of a misdemeanor and imposition of a fine. Section 2.03. Tenure. Except as provided by the TWC, each Director shall serve for a period of four (4) years and until his or her successor is elected and qualified. Any Director appointed to the Board shall serve for the remainder of the term of office to which that Director is appointed. Section 2.04. Policy Role of Directors. The Board will establish policies for the governance and conduct of the District and its operations with the advice, information and analysis provided by the staff, District consultants and public. Except as provided by District Order, Directors therefore shall not interfere with the administrative functions of the District or the professional duties of the District staff; nor shall they impair the ability of staff to implement Board policy decisions and directives. Except as otherwise approved by the Board, individual Directors shall take all requests of staff to the General Manager and shall not contact employees directly. Only the Board, acting as a body, may issue directions to the General Manager. Section 2.05. Director Advocacy. Directors shall represent the official policies or positions of the Board to the best of their ability when designated as delegates for this purpose. Section 2.06. Representation of Private Interests. In keeping with their role as stewards of the public interest, Directors shall not appear on behalf of private interests of third parties before the District’s Board of Directors or any other District board, commission, or committee. May 15, 2018 Regular Meeting Agenda Packet 39 of 175 Section 2.07. Influencing Boards, Commissions, and Committees. Because of the value of the independent advice of boards, commissions, committees and advisory groups to the public decision making process, Directors shall refrain from using their position to influence the deliberations or outcomes of any board, commission, committee, or advisory group proceedings. ARTICLE III OFFICERS OF THE BOARD Section 3.01. Officers. The officers of the District shall be a President, a Vice President, a Secretary/Treasurer, and other officers as may be elected in accordance with the provisions of this Article. The Board may elect or appoint other officers as it may deem desirable and those officers shall have the authority to perform the duties prescribed from time-to-time by the Board. Section 3.02. Election and Term of Office. The officers of the District shall be elected annually by the Board on or prior to the last day of June each year, or as otherwise determined by a majority of the Board of Directors due to vacancies, resignations and other circumstances. New offices may be created and filled at any meeting of the Board. Each officer shall hold office until his successor shall have been duly elected. Section 3.03. Removal. Any Director elected or appointed as an officer of the District by the Board may be removed from that office by the Board whenever the best interests of the District would be served thereby. That removal shall not constitute a removal from the Board. Section 3.04. Vacancies. A vacancy in any office because of death, resignation, removal, disqualification, or otherwise must be filled by the Board for the unexpired portion of the term in accordance with Section 49.105 of the Texas Water Code regarding the filling of vacancies. Section 3.05. President. The President is the chief executive officer and shall be a member of the Board with all the rights and privileges thereof, including the right to introduce motions before the Board and to vote on all matters. The President shall preside at all meetings of the Board. The President shall sign any deeds, mortgages, bonds, contracts, or other instruments which the Board has authorized to be executed, except in cases where the signing and execution thereof shall be expressly delegated by the Board to the General Manager; and in general, the President shall perform all duties as may be prescribed by the Board from time-to-time. Section 3.06. Vice President. The Vice President shall be a member of the Board and shall act as President in the case of the absence or inability of the President to perform the duties of the President. A Vice President shall perform other duties as from time-to-time may be assigned by the Board. Section 3.07. Secretary/Treasurer. In the role as Secretary, the Secretary/Treasurer is responsible for seeing that all records and books of the District are properly kept and may attest the President’s signature on documents. The Board may appoint another director, the General Manager, or any employee as Assistant or Deputy Secretary to assist the Secretary, and any such person shall be entitled to certify as to the authenticity of any record of the district, including but not limited to all proceedings relating to bonds, contracts, or indebtedness of the district. As Secretary, the Secretary/Treasurer shall perform other duties as from time-to-time may be assigned by the Board. In the role as Treasurer, the Secretary/Treasurer is responsible for monitoring all District funds and securities; reviewing the receipts of all money due and payable to the District; reviewing the deposit of all moneys in the name of the District in banks as shall be selected by the Board; and reviewing the disbursements of the District. As Treasurer, the Secretary/Treasurer shall perform other duties as from time-to-time may be assigned by the Board. May 15, 2018 Regular Meeting Agenda Packet 40 of 175 ARTICLE IV ADMINISTRATIVE SERVICES Section 4.01 Administrative Departments. The General Manager shall establish administrative departments. The head of each department shall be appointed by the General Manager and shall be subject to the direction and supervision of the General Manager. Section 4.02 General Manager – Appointment and Qualifications A. As permitted under Texas Water Code Section 49.056, the Board of Directors shall appoint a General Manager, who shall be the chief administrative officer of the Municipal Utility District. B. The method of selection shall be left to the discretion of the Board of Directors so long as the method insures orderly, non-partisan action toward securing a competent and qualified person to fill the position. The General Manager shall be chosen on the basis of administrative training, experience, ability, character and other such professional qualifications as determined appropriate by the Board of Directors. 
 Section 4.03 Compensation. The General Manager shall receive compensation as shall be fixed by the Board of Directors. Section 4.04 Term and Removal. The General Manager shall not be appointed or retained for a definite term, but may be suspended or removed at the discretion of the Board of Directors in accordance with applicable terms of the District’s personnel policies or contract with the General Manager. The action of the Board in suspending or removing the General Manager shall be final. It is the intention of this section to vest all authority and fix all responsibilities of such suspension or removal in the Board of Directors. Section 4.05 Powers and Duties. The General Manager shall be the chief administrative officer and head of the administrative branch of the District. The General Manager shall be responsible to the Board of Directors for the proper administration of all the affairs of the District and to that end shall, except as otherwise limited by order or contract approved by the Board, have the power and be required to: A. Oversee the effective enforcement of all applicable laws and resolutions, implement the directives and policies established by Board of Directors and oversee the administration of contracts and franchises to ensure compliance with the terms approved by Board of Directors; B. Appoint, suspend and/or remove all or any one of the heads of departments and all subordinate officers and employees of the District in accordance with applicable laws and policies. The General Manager may authorize any administrative officer subject to the Manager’s direction and supervision to exercise these powers with respect to subordinates in that officer’s department, office or agency. Contract General Managers shall obtain preapproval from the Board prior to taking action under this paragraph; C. Direct and supervise the administration of all departments; D. Attend all meetings of the Board, except when excused by the Board of Directors. The General Manager shall have the right to take part in discussion but shall not vote; 
 E. Prepare and submit the annual budget and capital program to the Board of Directors, and implement the final budget approved by the Board of Directors to achieve the goals of the District; 
 F. 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; 
 May 15, 2018 Regular Meeting Agenda Packet 41 of 175 G. Keep the Board of Directors fully advised as to the financial condition and future needs of the District; 
 H. Be responsible for all funds and securities of the District; review the receipts of all money due and payable to the District from any source; assure the deposit of all moneys in the name of the District in banks as selected by the Board; and, review the disbursements of the District; I. Ensure that all records and books of the District are properly kept and that all notices are duly gi ven in accordance with the provisions of these rules or as required by law; J. Certify as to the authenticity of any record of the District, including but not limited to all proceedings relating to bonds, contracts, or indebtedness of the District; K. Make recommendations to the Board of Directors concerning affairs of the District and facilitate the work of the Board of Directors in developing policy; 
 L. Provide staff support services for the Directors of the Board; 
 M. Assist the Board of Directors in developing goals and strategies for the next fiscal period; 
 N. Assist the Board of Directors to develop long term goals for the District and develop strategies to implement those goals; 
 O. Encourage and provide staff support for regional and intergovernmental cooperation; P. Promote partnerships among Board of Directors, staff, and citizens in developing public policy and building a sense of community; Q. Perform such other duties as may be prescribed by Board of Directors, by resolution or other law; and, R. Recommend to the Board of Directors rules and regulations to be adopted by resolution to protect the safety and security of the municipal records. 
 Section 4.06 Acting General Manager A. The General Manager, within thirty (30) days after taking office, shall designate, by letter filed with the District Secretary, a qualified administrative officer of the District to perform the duties of the General Manager in his absence or disability. Such designation shall be subject to approval of the Board of Directors. Upon resignation or termination of the General Manager, the Acting General Manager shall perform the duties of the General Manager until a new General Manager or Acting General Manager is appointed by the Board of Directors. 
 B. Should the need for an Acting General Manager occur prior to the General Manager submitting a designee or prior to the Board of Directors' approval of the General Manager's designee, the Board of Directors shall appoint an Acting General Manager. 
 C. The General Manager may select a different Acting General Manager , at any time, by repeating the letter of designation and obtaining the Board of Directors' approval for designation of a new Acting General Manager. 
 Section 4.07 District Secretary. The General Manager shall appoint a District Secretary who shall act as the secretary to the Board. The District Secretary shall be entitled to a seat at the Board table at all official meetings. May 15, 2018 Regular Meeting Agenda Packet 42 of 175 Section 4.08 Duties of the District Secretary. The District Secretary shall: A. Record the minutes of all official meetings of the Board; provided, however, only the captions of duly enacted resolutions shall be recorded in the minutes; 
 B. Hold and maintain the District Seal and affix to all instruments requiring such seal; 
 C. Be the custodian of all municipal records of the District; and 
 D. Perform such other duties as may be required by the Board of Directors, the General Manager, or the laws of the State of Texas. Section 4.09 General Legal Counsel. The Board of Directors shall retain an attorney licensed and in good standing to practice in the State of Texas as the General Legal Counsel. General Legal Counsel shall serve at the discretion of the Board of Directors and shall receive compensation as approved by the Board of Directors. The authority to set compensation may be delegated at the discretion of Board of Directors. Section 4.10 District Committees A. Members of committees appointed by the Board shall serve without compensation, provided, however, that they shall be entitled to reimbursement of any reasonable and necessary expenses incurred in the performance of their official duties, when approved by Board of Directors or their designee. B. All committees shall maintain minutes of their meetings which shall be public records and which indicate, at a minimum, the member’s present, subject of matters considered and the result of any vote taken. The minutes shall also indicate how each member voted on each matter. ARTICLE V MEETINGS AND AGENDA Section 5.01. Meetings. The Board shall establish a regular meeting time and place or places. The Board shall have Regular Board Meetings monthly except upon the occasion when it is determined that no meeting is necessary in a particular month. In any event, the Board shall meet no less than four (4) times each year. A. Regular Board Meetings are normally held on the third Monday of every month at 6:30 P.M. in the Svore Municipal Building Boardroom located at 100 Municipal Drive, Trophy Club, Texas, 76262. The date, location and time may be changed by vote of the Board of Directors. Meeting locations must be approved by resolution of the District and the Texas Commission on Environmental Quality (TCEQ) must be notified of any permanent change in location. B. Emergency Meetings may be called when authorized by Section 551.045 of the Texas Government Code. Emergency Meetings are to be called only in situations where an emergency or an urgent public necessity exists and immediate action is required by the Board because of: (1) an imminent threat to public health and safety; or (2) a reasonably unforeseeable situation. The emergency or urgent public necessity shall be clearly identified. The meeting may be called by the President of the Board, the General Manager, or by a maj ority of the members of the Board, with two (2) hours’ notice. C. Special Board Meetings may be called by the President of the Board or the General Manager at any time with seventy-two (72) hours’ notice for the purpose of conducting District May 15, 2018 Regular Meeting Agenda Packet 43 of 175 business as may be required between Regular monthly meetings. D. Joint Meetings with other governmental entities are considered Special meetings but require additional coordination with another governmental entity. E. Public Hearings may be called with notice as required by State Law. A public hearing is held to allow citizens to learn about, and to comment on, a specific matter under consideration by the District. Normally, no action will be taken during a public hearing, but public hearings may be held during regular or special meetings and action may be taken following the public hearing. F. Notice of Quorum may be posted when a quorum of the Board is expected to attend an event not called by the District. A quorum notice is not required for social gatherings in which no District business is discussed. G. Work Sessions may be called prior to a regular meeting to explore one or more matters in detail. Section 5.02. Quorum. A majority of the Board shall constitute a quorum for the transaction of business at any meeting of the Board. The act of three (3) Directors at a meeting for which a quorum is present shall be the act of the Board. Section 5.03. Conduct of Meetings. The President shall preside at Board meetings. In the absence of the President, the Vice President shall preside. In the absence of the President and Vice President, the Secretary/Treasurer shall preside. The Board may provide a portion of each meeting for public comments in accordance with the policies established for receipt of public comment. Directors will listen courteously and attentively to all public discussions before the body. They shall refrain from interrupting other speakers, making personal comments not germane to the business of the body, or otherwise interfering with the orderly conduct of meetings. The Board shall generally use Roberts Rules of Order Newly Revised as guidelines for meeting procedures and votes with the exception that discussion may occur prior to a motion being made. Section 5.04 Agenda Procedure A. Regular Board Meetings: Any item requested by two (2) Directors, or the President, or the General Manager shall be placed on the agenda by the District Secretary. If a Director would like to place an item on an agenda, the Director must get one additional Director to agree to the item. Each of these Directors should then submit the item and available supporting documents in writing to the General Manager and District Secretary not less than four (4) business days prior to the agenda posting date. Any items received from two Directors with less than four (4) business days’ notice prior to posting (72 hours in advance of meeting) will be placed on the next regularly scheduled meeting agenda. B. At each regular Board meeting, an agenda item shall be included to allow Directors to request items to be placed on future agendas. Director requested agenda items will not be denied, but the future agenda to which it is posted shall be at the discretion of the Board President. C. Emergency Meetings: Emergency meetings can only be called in accordance with the Open Meetings Act and the agenda must be set and approved by General Legal Counsel. No Director requests for additional agenda items shall be permitted for an emergency meeting. D. Special Meetings: Special meetings are set for specific purposes only, and agendas shall be drafted by the General Manager and approved by the Board President. E. Joint Meetings: Joint meeting agendas shall be coordinated and drafted by the General Manager. F. Public Hearing and Notice of Quorum: A Public Hearing Notice or Notice of Quorum May 15, 2018 Regular Meeting Agenda Packet 44 of 175 shall be drafted and approved by the General Manager. Section 5.05. Posting Agendas and Notice to Directors. The General Manager shall confer with General Legal Counsel prior to each meeting to insure the agenda meets legal requirements. After approval of the agenda by the President and General Manager, the District Secretary shall post the agenda as required by the Texas Open Meetings Act. Notice to the Directors of Regular and Special meetings of the Board shall be given at least seventy-two (72) hours prior to the meeting. A copy of the posted agenda will be placed on the District webpage, and will be available for the public at the meeting. ARTICLE VI FEES AND TRAVEL EXPENSE POLICY Section 6.01. Purpose. The purpose of this Expense Policy is to set forth the policies of Trophy Club Municipal Utility District No. 1 concerning fees and travel expenses for members of the Board of Directors of the District. Section 6.02. Fees of Office for Directors. Directors shall not receive fees of office for performing the duties of a Director. “Performing the duties of a Director” means performance of the management or business of the District, including participation in Board and committee meetings and other activities involving the deliberation of District business, and in pertinent educational programs. Section 6.03. Attendance at Meetings and Conduct of Other District Business. Board members may attend conferences and meetings of the Association of Water Board Directors, at the District’s expense, whether within or outside the Town of Trophy Club. Attendance at other conferences, hearings, or other meetings outside of Trophy Club by the members of the Board of Directors must be approved by the Board of Directors; attendance at local meetings or conduct of other local District business will be at each Director’s discretion. Directors attending any meeting or conducting any District business shall report to the Board concerning the meeting or activity. Section 6.04. Expenses Outside of Trophy Club. The District will pay a reasonable room rate for a Director’s hotel room, if District business approved by the Board requires overnight travel, reasonable tips incurred in making the trip, round-trip mileage at the current IRS mileage rate and parking, if any, for travel by car or round-trip airfare at current commercial rates for standard (not first class) air fare and reasonable rental car or taxi charges. Mileage will be computed by the most direct route. The District will pay for meals actually eaten and paid for by the Director on an approved trip; provided, however, reimbursement for meals will be limited to $75.00 per day per person. Appropriate documentation listing the person in attendance and a description of the business discussed at the meeting or activity is required. All reimbursement requires receipts of purchase. No reimbursement shall be made for the purchase of entertainment or the purchase of alcoholic beverages. No reimbursement shall be made for expenses of a spouse of a Director. Section 6.05. Expenses for Local Meetings and Activities. The District will pay for meals directly related to the meeting or activity. Reimbursement for meals will be limited to $75.00 per day per person. Appropriate documentation listing the person in attendance and a description of the business discussed at the meeting or activity is required. No reimbursement shall be made for the purchase of alcoholic beverages. No reimbursement shall be made for the expenses of a spouse of a Director. Section 6.06. Reimbursement. To receive reimbursement for expenses, a Director must submit an itemized expense report including receipts, to the District Finance Department before reimbursement is approved by the General Manager. Items on the expense report shall include lodging, meals, tips, mileage, parking and transportation. Directors sharing expense items may split reported expenses in any manner they deem equitable, but the Board will pay no more than 100% of the actual total cost of reimbursable items. May 15, 2018 Regular Meeting Agenda Packet 45 of 175 Section 6.07. Extraordinary Expenses. Any extraordinary expenses for a Director attending an approved activity of the District must be approved by the Board prior to incurring the expense. ARTICLE VII PROFESSIONAL SERVICES POLICY Section 7.01. Purpose. This policy has been adopted to provide for the selection, monitoring, review, and evaluation of the District’s professional services contracts. Consultants retained by the District to provide professional services include, but are not limited to, legal, engineering, financial advisor, management, bookkeeping, auditing, and tax collecting. Section 7.02. Selection of Consultants. Selection of consultants shall be based upon their qualifications and experience. Whenever the Board of Directors of the District decides to terminate the services of one or more of its Consultants, the Board, working through staff, shall solicit one or more proposals as required by the Professional Services Procurement Act, Section 2254.001 et seq., Government Code. Selection of consultants is to be conducted by the Board in an open meeting. Section 7.03. Monitoring of Consultants. The performance of the Consultants providing professional services to the District shall be regularly monitored and reviewed by the General Manager and Board. For those Consultants with annual contracts, the Board of Directors and General Manager of the District will review the performance of the Consultants for the prior year at the time the contract is renewed. The Board of Directors shall review the performance of its other Consultants, upon the request of one or more Directors. ARTICLE VIII MANAGEMENT POLICY Section 8.01. Purpose. The Board desires to adopt a policy to ensure better use of management information, including the use of budgets in planning and controlling costs, the establishment of a functioning audit committee, and the use of uniform reporting requirements. Section 8.02. Accounting Records. District accounting records shall be prepared on a timely basis and maintained in an orderly manner; to comply with generally accepted accounting principles and the requirements of the Texas Commission on Environmental Quality. Accounting records shall be available for public inspection during regular business hours at the District’s office. Section 8.03. Audit Requirements. A. The District’s fiscal accounts and records shall be audited annually according to state law governing the audits of districts, at the expense of the District, by a certified public accountant familiar with the Texas Commission on Environmental Quality’s rules, regulations, standards, and guidelines applicable to district audits. The District hereby directs its auditor to adopt uniform auditing reporting requirements that use “Audits of State and Local Governmental Units” as a guide on audit working papers and that uses “Governmental Accounting and Financial Reporting Standards” for final audit reports. B. The audit shall be completed and filed within the time limits established by the TWC. A copy of the audit shall be filed with the Texas Commission on Environmental Quality together with an annual filing affidavit in the form prescribed by TWC. In the event the Board refuses to approve the annual audited report, the District shall file a statement with the audit to explain the Board’s reasons for disapproving the audit. 
 May 15, 2018 Regular Meeting Agenda Packet 46 of 175 Section 8.04. Audit Committee. The Board shall establish an audit committee comprised of not less than two Directors and other persons as the Board may deem appropriate. The persons selected should not be directly responsible for work subject to the audit. The audit committee shall con duct, at a minimum, an annual review of the District’s financial status. The committee shall monitor variances from the District’s budget and shall review the District’s audit report and shall make recommendations to the Board. The final audit must be presented to the entire Board for approval prior to submittal to regulatory agencies. Section 8.05. Budget. The District shall annually adopt a budget according to Title 30 of the Texas Administrative Code, Section 293.97 for use in planning and controlling District costs. The budget shall take into consideration all District revenues, including, but not limited to, utility fees, taxes and surcharges, if any, and all projected District obligations and expenditures. The budget may be amended at any time but the Board shall approve the amendment in advance. A comparison of the actual operating results to the adopted budget, as amended, shall be presented in the annual report. The budgetary comparison statement shall be included either within the audited financial statements or within a supplementary section. ARTICLE IX CODE OF ETHICS Section 9.01. Purpose. This Code of Ethics has been adopted by the District to: (a) comply with TWC Section 49.199, as amended; (b) encourage high ethical standards in official conduct by District Representatives; and (c) establish guidelines for ethical standards of conduct. Except as otherwise provided, this Code of Ethics shall apply to all District Representatives. Section 9.02. Policy. It is the policy of the District that District Representatives shall conduct themselves in a manner consistent with sound business and ethical practices; that the public interest shall always be considered in conducting District business; that the appearance of impropriety shall be avoided to ensure and maintain public confidence in the District; and that the Board shall control and manage the affairs of the District fairly, impartially, and without discrimination, and according to the District’s purpose. Section 9.03 Qualification of Directors. A. A person shall not serve as a Director if he is disqualified by law from doing so under the general laws of the State of Texas. Section 49.052, Texas Water Code disqualifies certain persons from serving as Directors of the District. B. TWC Section 49.105 requires that a vacant position on the Board of Directors must be filled within 60 days. Therefore, within sixty (60) days after the Board determines that any Director is disqualified from serving on the Board, it shall replace that Director with a person who is qualified. C. Any Director who is disqualified from serving as a member of the Board under Section 49.052(a) of the Texas Water Code and who willfully occupies an office and exercises the duties and powers of that office may be subject to penalties under Section 49.052(c), Texas Water Code, including possible conviction of a misdemeanor and imposition of a fine. Section 9.04 Disqualification of Directors. Disqualification and removal of Directors shall be accomplished in accordance with Section 49.052, of the Texas Water Code. Section 9.05. Conflicts of Interest. The District adopts Chapter 171, Local Government Code, as its Conflict of Interest Policy, the principal provisions of which are as follows: Except where a May 15, 2018 Regular Meeting Agenda Packet 47 of 175 maj ority of the Board of Directors is required to abstain from participation in a vote because of conflict of interest, a Director will abstain from participating in a decision of the Board of Directors which either (1) confers a special economic benefit on a business in which the Director or a close relative has a substantial interest that is distinguishable from the effect on the public, or (2) will have a special economic effect on the value of property in which the Director or a close relative has a substantial interest distinguishable from its effect on the public. For these purposes, a person is considered to have a “substantial interest” in a business if (1) the person owns ten percent (10%) or more of the voting stock or shares of the business entity or owns either ten percent (10%) or more or $15,000 or more of the fair market value of the business entity; or (2) funds received from the business exceed ten percent (10%) of the person’s gross income for the previous year. A person has a substantial interest in real property if the interest is an equitable or legal interest with a market value of $2,500 or more. A “close relative” of a Director for these purposes is a person related to the Director within the first degree of affinity or consanguinity as determined under Chapter 573 of the Texas Government Code. A. A Director may not act as a surety on any official bond or for a business entity that has work, business, or a contract with the District. B. A Director shall not disclose, without written legal authorization, confidential information to advance the financial or other private interests of himself or others on any contract or transaction which is or may be the subject of an official action of the District. C. The District may not contract for the purchase of services or personal property directly with a District Representative or with a business entity in which a District Representative has a substantial interest, except as permitted by law. D. A Director who has a substantial interest in any matter involving the business entity or real property shall disclose that fact to the other Directors by Affidavit. The Affidavit must be filed with the Secretary of the Board at a posted meeting open to the public. An interested Director shall abstain from further participation in the matter. E. The Board shall take a separate vote on any budget item specifically dedicated to a contract with a business entity in which a Director has a substantial interest. In the event of a separate vote, the Director may not participate in that separate vote, but may vote on a final budget if the Director has complied with Local Government Code Chapter 171 and the matter in which the Director is concerned has been resolved. F. As of the date of adoption of this Code of Ethics, Chapter 176, Local Government Code requires the disclosure of certain relationships by Directors or by District Employees who exercise discretion in the planning, recommending, selecting or contracting of a vendor, vendors, and certain prospective vendors to the District, if the District or Employee, or family member of a Director or such Employee, has an employment or business relationship with the vendor that has resulted in taxable income that exceeds certain limits, or has received a gift from the vendor. A Director, Employee, vendor, or prospective vendor who has a relationship that requires disclosure under Chapter 176 shall disclose that relationship by completing the form prescribed by the Texas Ethics Commission and timely filing that form with the Records Administrator. A Director, Employee or vendor violating this Section may be subject to criminal prosecution or termination of employment under Section 176.013 of the Local Government Code. Section 9.06. Conduct of District Business. Each District Representative will conduct all business of the District in a manner consistent with the requirements of applicable law and the Texas Open Meetings Act. Section 9.07. Use of District Property. No Board member, officer, or Employee shall permit any personal or unauthorized use of District-owned or District-controlled equipment, materials, supplies, or May 15, 2018 Regular Meeting Agenda Packet 48 of 175 property. Directors shall not use public resources unavailable to the public, such as District staff time, equipment, supplies or facilities, for private gain or personal purposes. Directors shall not utilize the District’s name, logo, or their position for purposes of endorsing any political candidate, political position or business. Section 9.08. Nepotism. The Board shall not confirm the appointment to any position, nor award a contract, to a person related to a member of the Board within the second degree by affinity (marriage) or within the third degree by consanguinity (blood) when the salary or other compensation of the appointee is paid, directly or indirectly, from District funds, except as provided by Government Code Chapter 573. Section 9.09. Acceptance of Gifts. No District Representative shall accept any benefit as consideration for any decision, opinion, recommendation, vote, or other exercise of discretion in carrying out his official acts for the District. No District Representative shall solicit, accept, or agree to accept any benefit from a person known to be interested in or likely to become interested in any contract, purchase, payment, claim, or transaction involving the exercise of the District’s Representative’s discretion. Section 36.10, Texas Penal Code lists exemptions to the Acceptance of Gifts Policy which are adopted and incorporated into this Code of Ethics. Section 9.10. Bribery. A District Representative shall not intentionally or knowingly offer, confer, or agree to confer on another, or solicit, accept, or agree to accept from another, any benefit as consideration when to do so is prohibited by law. As of the date of adoption of this Code of Ethics, Section 36.02, Texas Penal Code, lists the offenses that are considered bribery when committed by District Representatives. Section 9.11. Acceptance of Honoraria. A Director shall not solicit, accept or agree to accept an honorarium as prohibited by law. As of the date of the adoption of this Code of Ethics, Section 36.07, Texas Penal Code, provides the circumstances in which a Director may not accept an honorarium. Section 9.12. Lobbying. Should the Texas Ethics Commission, by rule require any District Representatives directly communicating with legislative or executive branch officials to register as lobbyists, District Representative’s shall comply. See Government Code, Section 305.0051. May 15, 2018 Regular Meeting Agenda Packet 49 of 175 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 RESOLUTION NO. 2018-0515A A RESOLUTION REGARDING SIGNATORY AUTHORITY AND INQUIRY OVER TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 ACCOUNTS AT PROSPERTY BANK USA WHEREAS, Trophy Club Municipal Utility District No. 1 (the “District”) is a conservation and reclamation district, a body corporate and politic and governmental agency of the State of Texas, created under Article XVI, Sec. 59 of the Texas Constitution by order of the Texas Water Commission, now the Texas Commission on Environmental Quality (“TCEQ"), and the District operates under Chapters 49 and 54 of the Texas Water Code, as amended; WHEREAS, banking rules and effective management of the District’s finances require that the Board of Directors (the “Board”) of Trophy Club Municipal Utility District No. 1 (the “District”) establish designated persons who shall have signature authority over the District’s bank accounts at Prosperity Bank USA (the “Bank”); and WHEREAS, it is necessary for the Board to provide that a sufficient number of District officials be designated with signature authority; and NOW, THEREFORE, BE IT RESOLVED BY THE BOARD OF DIRECTORS OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 THAT: 1. The following members of the Board of Directors and the General Manager of Trophy Club Municipal Utility District No. 1 shall have signatory authority over the District’s accounts at Prosperity Bank USA, each of them mutually having authority to act in the place of any other as may be convenient for effectively transacting the business of the District: a. Gregory Wilson Director b. William C. Rose Director c. Kelly Castonguay Director d. Stephen J. Flynn Director e. Mark Chapman Director f. John Carman General Manager 2. At least two (2) authorized signors must sign all disbursements of the District. 3. The Board of Directors directs the staff of the District to take all actions necessary and apply such information and documentation as may be requested by the Bank to effect the provisions of this Resolution. 4. These changes supersede all previously existing signatory authorities on record with Prosperity Bank USA. May 15, 2018 Regular Meeting Agenda Packet 50 of 175 RESOLVED, PASSED, AND APPROVED on this the 15st day of May 2018.  ____________________________________ President, Board of Directors ATTEST: ____________________________________ Secretary, Board of Directors     (SEAL) May 15, 2018 Regular Meeting Agenda Packet 51 of 175 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 RESOLUTION NO. 2018-0515B A RESOLUTION REGARDING SIGNATORY AUTHORITY AND INQUIRY OVER TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 ACCOUNTS AT BANK OF THE WEST WHEREAS, Trophy Club Municipal Utility District No. 1 (the “District”) is a conservation and reclamation district, a body corporate and politic and governmental agency of the State of Texas, created under Article XVI, Sec. 59 of the Texas Constitution by order of the Texas Water Commission, now the Texas Commission on Environmental Quality (“TCEQ"), and the District operates under Chapters 49 and 54 of the Texas Water Code, as amended; WHEREAS, banking rules and effective management of the District’s finances require that the Board of Directors (the “Board”) of Trophy Club Municipal Utility District No. 1 (the “District”) establish designated persons who shall have signature authority over the District’s bank accounts at Bank of the West (the “Bank”); and WHEREAS, it is necessary for the Board to provide that a sufficient number of District officials be designated with signature authority; and NOW, THEREFORE, BE IT RESOLVED BY THE BOARD OF DIRECTORS OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 THAT: 1. The following members of the Board of Directors and the General Manager of the District shall have signatory authority over the District’s accounts at Bank of the West, each of them mutually having authority to act in the place of any other as may be convenient for effectively transacting the business of the District: a. Gregory Wilson Director b. William C. Rose Director c. Kelly Castonguay Director d. Stephen J. Flynn Director e. Mark Chapman Director f. John Carman General Manager 2. At least two (2) authorized signors must sign all disbursements of the District. 3. The Board of Directors directs the staff of the District to take all actions necessary and apply such information and documentation as may be requested by the Bank to effect the provisions of this Resolution. 4. These changes supersede all previously existing signatory authorities on record with Bank of America. May 15, 2018 Regular Meeting Agenda Packet 52 of 175 RESOLVED, PASSED, AND APPROVED on this the 15st day of May 2018.  ____________________________________ President, Board of Directors ATTEST: ____________________________________ Secretary, Board of Directors     (SEAL) May 15, 2018 Regular Meeting Agenda Packet 53 of 175 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 RESOLUTION NO. 2018-0515C RESOLUTION 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 STATE OF TEXAS § COUNTIES OF DENTON AND TARRANT § 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.156 of the Water Code requires the Board of Directors of the District, by order or resolution, to designate one or more banks or savings associations within the state to serve as the depository for the funds of the District; WHEREAS, the Board of Directors desires to designate depository institutions in accordance with Section 49.156 of the Water Code; WHEREAS, Section 49.151 of the Water Code provides that except as otherwise set forth therein, a District’s money shall be disbursed only by check, draft, order, or other instrument that shall be signed by at least a majority of the directors. The statute allows a Board, by resolution, to allow the General Manager, Treasurer, Bookkeeper, or other employee of the District to sign disbursements. The statute also provides that the board may allow disbursements of district money to be transferred by Federal Reserve wire system to accounts in the name of the district or accounts not in the name of the district; WHEREAS, in accordance with the foregoing statutes, the Board of Directors desires to designate banks or savings associations to serve as the depository for the funds of the District; to provide for the disbursement of funds of the District; and to provide for the electronic transfer of funds, all subject to certain limitations specified herein by the Board of Directors herein for the safekeeping and protection of public funds. 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. Designation of Depository Institutions: (a) In accordance with Section 49.156 of the Texas Water Code, the Board of Directors hereby designates those banks and savings associations set forth on Exhibit “A” attached hereto (hereinafter, the “Authorized Depository Institutions”) to serve as depositories for the funds of the District. (b) The District’s General Manager and Board of Directors are hereby authorized to open and close accounts at the Authorized Depository Institutions. (c) No funds of the District shall be deposited at any of the Authorized Depository May 15, 2018 Regular Meeting Agenda Packet 54 of 175 Institutions in excess of the amounts insured by the Federal Deposit Insurance Corporation unless they are secured in the manner provided by law under the Public Funds Collateral Act (Chapter 2257, Government Code). (d) In accordance with Section 49.156 of the Water Code, the Board of Directors hereby authorizes the following designated representatives to supervise the substitution of securities pledged to secure the District’s funds at the Authorized Depository Institutions: John R. Carman General Manager Steven Krolczyk Finance Manager 3. Authorized Signatories for District Accounts: (a) Checks, drafts, and other withdrawal or transfer orders issued against funds of the District on deposit at the Authorized Depository Institutions may be signed only by the members of the Board of Directors of the District and its General Manager, each of whom are identified below: a. Gregory Wilson Director b. William C. Rose Director c. Kelly Castonguay Director d. Stephen J. Flynn Director e. Mark Chapman Director f. John Carman General Manager (b) The authority of all other persons to sign disbursements, transfer or withdraw funds, or otherwise conduct any transactions related to the District’s funds is hereby terminated for all purposes. (c) The General Manager is hereby directed to ensure that signature cards for all District depository accounts contain current information and only the names of those individuals authorized to sign disbursements on behalf of the District. 4. Disbursement Authority: (a) General Manager Disbursement Authority. The Board of Directors of the District hereby authorizes the General Manager of the District to sign disbursements of the District provided the following limitations shall apply to such authorization: i. Disbursements authorized solely by the General Manager shall be for an amount equal to or less than $20,000 and must also be signed by at least one (1) member of the Board of Directors; ii. Disbursements in excess of $20,000 must be authorized by the Board of Directors and may be signed by the General Manager and must also be signed by at least one (1) member of the Board of Directors of the District. iii. For an emergency expenditure, disbursements in excess of $20,000 must be authorized by the General Manager and two (2) officers of the Board of Directors. The disbursement of funds may then be signed by the General Manager and must also be signed by at least one (1) member of the Board of Directors of the District and the expenditure shall be ratified by the Board of Directors at the next regular meeting. (b) Other Disbursements. In accordance with Section 49.151 of the Water Code, and except as otherwise provided hereunder, disbursements of the District’s funds by check, May 15, 2018 Regular Meeting Agenda Packet 55 of 175 draft, order, or other instrument shall be signed by at least a majority of the directors. (c) Additional Limitations on Disbursement Authority. i. Non-payroll checks made payable to the General Manager of the District may not be signed by the General Manager. ii. Checks made payable to any Director of the District for director’s fees or reimbursement of expenses may not be signed by the Director receiving the check. 5. Electronic Transfers: Except as authorized below, the electronic transfer of District funds is prohibited: (a) District funds may be transferred between District accounts only upon prior authorization of the Board of Directors or General Manager. (b) District funds may be transferred for authorized investments, as identified in the District’s Investment Policy, only upon prior approval of the Board of Directors or the Investment Officer of the District. The transfer of such funds shall require the written authorization of the General Manager. (c) Principal and interest payments for debt service on District bonds may be made by electronic funds transfer from the District’s debt service fund directly to the paying agent’s account upon prior approval of the General Manager or Treasurer. (d) Prior notice of all proposed electronic fund transfers to external accounts other than payroll and bond payments shall be given to the Board. (e) Payroll taxes and other payments to government entities that are required to be transmitted electronically are permitted. (f) Payroll direct deposit for staff may be made electronically only upon prior authorization of the General Manager. 6. This Resolution supersedes and replaces all previous resolutions and policies relating to the subject matter hereof. 7. This Resolution shall be effective immediately upon adoption, and shall supersede and replace all resolutions previously adopted by the Board of Directors relating to the subject matter hereof. 8. The staff of the District is hereby directed to take any and all actions that may be required by the Authorized Depository Institutions to implement this Resolution. RESOLVED, PASSED AND APPROVED this the 15th day of May 2018. President, Board of Directors ATTEST: Secretary, Board of Directors May 15, 2018 Regular Meeting Agenda Packet 56 of 175 Exhibit “A” Authorized Depository Institutions Name of Bank Address Town State Zip Prosperity Bank 217 North Main Keller TX 76248 Bank of the West 4100 William D Tate Grapevine TX 76051 TexPool 1001 Texas Avenue Suite 1400 Houston TX 77002 May 15, 2018 Regular Meeting Agenda Packet 57 of 175 Resolution Amending Authorized Representatives Please use this form to amend or designate Authorized Representatives. This document supersedes all prior Authorized Representative forms. * Required Fields 1. Resolution WHEREAS, Participant Name*Location Number* (“Participant”) is a local government of the State of Texas and is empowered to delegate to a public funds investment pool the authority to invest funds and to act as custodian of investments purchased with local investment funds; and WHEREAS, it is in the best interest of the Participant to invest local funds in investments that provide for the preservation and safety of principal, liquidity, and yield consistent with the Public Funds Investment Act; and WHEREAS, the Texas Local Government Investment Pool (“TexPool/ Texpool Prime”), a public funds investment pool, were created on behalf of entities whose investment objective in order of priority are preservation and safety of principal, liquidity, and yield consistent with the Public Funds Investment Act. NOW THEREFORE, be it resolved as follows: A. That the individuals, whose signatures appear in this Resolution, are Authorized Representatives of the Participant and are each hereby authorized to transmit funds for investment in TexPool / TexPool Prime and are each further authorized to withdraw funds from time to time, to issue letters of instruction, and to take all other actions deemed necessary or appropriate for the investment of local funds. B. That an Authorized Representative of the Participant may be deleted by a written instrument signed by two remaining Authorized Representatives provided that the deleted Authorized Representative (1) is assigned job duties that no longer require access to the Participant’s TexPool / TexPool Prime account or (2) is no longer employed by the Participant; and C. That the Participant may by Amending Resolution signed by the Participant add an Authorized Representative provided the additional Authorized Representative is an officer, employee, or agent of the Participant; List the Authorized Representative(s) of the Participant. Any new individuals will be issued personal identification numbers to transact business with TexPool Participant Services. 1. Name Title Phone/Fax/Email Signature 2. Name Title Phone/Fax/Email Signature FORM CONTINUES ON NEXT PAGE 1 OF 2 Trophy Club Municipal Utility District No. 1 77384 John Carman General Manager 682-831-4610/817-491-9312/jcarman@tcmud.org Laurie Slaght District Secretary 682-831-4685/817-491-9312/lslaght@tcmud.org May 15, 2018 Regular Meeting Agenda Packet 58 of 175 1. Resolution (continued) 3. Name Title Phone/Fax/Email Signature 4. Name Title Phone/Fax/Email Signature List the name of the Authorized Representative listed above that will have primary responsibility for performing transactions and receiving confirmations and monthly statements under the Participation Agreement. Name In addition and at the option of the Participant, one additional Authorized Representative can be designated to perform only inquiry of selected information. This limited representative cannot perform transactions. If the Participant desires to designate a representative with inquiry rights only, complete the following information. Name Title Phone/Fax/Email D. That this Resolution and its authorization shall continue in full force and effect until amended or revoked by the Participant, and until TexPool Participant Services receives a copy of any such amendment or revocation. This Resolution is hereby introduced and adopted by the Participant at its regular/special meeting held on the ______day ______________________, 20 ___. Note: Document is to be signed by your Board President, Mayor or County Judge and attested by your Board Secretary, City Secretary or County Clerk. Name of Participant* SIGNED ATTEST Signature*Signature* Printed Name*Printed Name* Title*Title* 2. Mailing Instructions The completed Resolution Amending Authorized Representatives can be faxed to TexPool Participant Services at 1-866-839-3291, and mailed to: TexPool Participant Services 1001 Texas Avenue, Suite 1400 Houston, TX 77002 TexPool Participant Services Managed and 1001 Texas Avenue, Suite 1400 ● Houston, TX 77002 Serviced by ee eratdd Phone: 1-866-TEXPOOL (839-7665) ● Fax: 1-866-839-3291 ● www.texpool.com G45340-17 (12/15) ORIGINAL SIGNATURE AND DOCUMENT REQUIRED TEX-REP 2 OF 2 Gregory Wilson 682-831-4600/817-491-9312/gwilson@tcmud.org William C. Rose 682-831-4600/817-491-9312/brose@tcmud.org John Carman Steven Krolczyk Finance Manager 682-831-4692/817-491-9312/skrolczyk@tcmud.org 15th May 18 Trophy Club Municipal Utility District No. 1 May 15, 2018 Regular Meeting Agenda Packet 59 of 175 Resolution Amending Authorized Representatives Please use this form to amend or designate Authorized Representatives. This document supersedes all prior Authorized Representative forms. * Required Fields 1. Resolution WHEREAS, Participant Name*Location Number* (“Participant”) is a local government of the State of Texas and is empowered to delegate to a public funds investment pool the authority to invest funds and to act as custodian of investments purchased with local investment funds; and WHEREAS, it is in the best interest of the Participant to invest local funds in investments that provide for the preservation and safety of principal, liquidity, and yield consistent with the Public Funds Investment Act; and WHEREAS, the Texas Local Government Investment Pool (“TexPool/ Texpool Prime”), a public funds investment pool, were created on behalf of entities whose investment objective in order of priority are preservation and safety of principal, liquidity, and yield consistent with the Public Funds Investment Act. NOW THEREFORE, be it resolved as follows: A. That the individuals, whose signatures appear in this Resolution, are Authorized Representatives of the Participant and are each hereby authorized to transmit funds for investment in TexPool / TexPool Prime and are each further authorized to withdraw funds from time to time, to issue letters of instruction, and to take all other actions deemed necessary or appropriate for the investment of local funds. B. That an Authorized Representative of the Participant may be deleted by a written instrument signed by two remaining Authorized Representatives provided that the deleted Authorized Representative (1) is assigned job duties that no longer require access to the Participant’s TexPool / TexPool Prime account or (2) is no longer employed by the Participant; and C. That the Participant may by Amending Resolution signed by the Participant add an Authorized Representative provided the additional Authorized Representative is an officer, employee, or agent of the Participant; List the Authorized Representative(s) of the Participant. Any new individuals will be issued personal identification numbers to transact business with TexPool Participant Services. 1. Name Title Phone/Fax/Email Signature 2. Name Title Phone/Fax/Email Signature FORM CONTINUES ON NEXT PAGE 1 OF 2 Trophy Club Municipal Utility District No. 1 77384 Kelly Castonguay 682-831-4600/817-491-9312/kcastonguay@tcmud.org Stephen J. Flynn 682-831-4600/817-491-9312/sflynn@tcmud.org May 15, 2018 Regular Meeting Agenda Packet 60 of 175 1. Resolution (continued) 3. Name Title Phone/Fax/Email Signature 4. Name Title Phone/Fax/Email Signature List the name of the Authorized Representative listed above that will have primary responsibility for performing transactions and receiving confirmations and monthly statements under the Participation Agreement. Name In addition and at the option of the Participant, one additional Authorized Representative can be designated to perform only inquiry of selected information. This limited representative cannot perform transactions. If the Participant desires to designate a representative with inquiry rights only, complete the following information. Name Title Phone/Fax/Email D. That this Resolution and its authorization shall continue in full force and effect until amended or revoked by the Participant, and until TexPool Participant Services receives a copy of any such amendment or revocation. This Resolution is hereby introduced and adopted by the Participant at its regular/special meeting held on the ______day ______________________, 20 ___. Note: Document is to be signed by your Board President, Mayor or County Judge and attested by your Board Secretary, City Secretary or County Clerk. Name of Participant* SIGNED ATTEST Signature*Signature* Printed Name*Printed Name* Title*Title* 2. Mailing Instructions The completed Resolution Amending Authorized Representatives can be faxed to TexPool Participant Services at 1-866-839-3291, and mailed to: TexPool Participant Services 1001 Texas Avenue, Suite 1400 Houston, TX 77002 TexPool Participant Services Managed and 1001 Texas Avenue, Suite 1400 ● Houston, TX 77002 Serviced by ee eratdd Phone: 1-866-TEXPOOL (839-7665) ● Fax: 1-866-839-3291 ● www.texpool.com G45340-17 (12/15) ORIGINAL SIGNATURE AND DOCUMENT REQUIRED TEX-REP 2 OF 2 Mark Chapman 682-831-4600/817-491-9312/mchapman@tcmud.org John Carman Steven Krolczyk Finance Manager 682-831-4692/817-491-9312/skrolczyk@tcmud.org 15th May 18 Trophy Club Municipal Utility District No. 1 May 15, 2018 Regular Meeting Agenda Packet 61 of 175 May 6 - Jun 30, 2018 Printed on: 05/11/2018 2:05pm Powered by Sun Mon Tue Wed Thu Fri Sat 19 20 21 22 23 24 25 26 May 6, 2018 7 8 9 10 11 12 1pm Medlin Cemetery Association 9am EMS Training (Shane Beck  10:30am Parks/Rec/Streets/Fac  9am EMS Training (Shane Beck 9am EMS Training (Shane Beck 9am Trophy Club Women's Club (A 13 14 15 16 17 18 19 6am Republican Primary Run-Off 10:30am Parks/Rec/Streets/Fac  7am Republican Primary Run-Off 6pm Trophy Club Municipal Util  6pm Lakes of Trophy Club HOA  6am Republican Primary Run-Off 6am Republican Primary Run-Off 6am Republican Primary Run-Off 20 21 22 23 24 25 26 10:30am Parks/Rec/Streets/Fac Republican Primary Run-Off Elect 6pm Highlands @TC HOA (Ginny 10am Special Events Committe  27 28 29 30 31 Jun 1 2 10:30am Parks/Rec/Streets/Fac  3 4 5 6 7 8 9 10:30am Parks/Rec/Streets/Fac 7am FD Ofcers Meeting (Hurd  7pm Trophy Club Womens Club  8:30am Keep Trophy Club Wild 10 11 12 13 14 15 16 9am EMS Training (Shane Beck  10:30am Parks/Rec/Streets/Fac  9am EMS Training (Shane Beck 9am EMS Training (Shane Beck  17 18 19 20 21 22 23 10:30am Parks/Rec/Streets/Fac 6pm Trophy Club Municipal Util  6pm Lakes of Trophy Club HOA  24 25 26 27 28 29 30 10:30am Parks/Rec/Streets/Fac 10am Special Events Committe  TC Meeting Spaces ModierMay 15, 2018 Regular Meeting Agenda Packet 62 of 175 May 15, 2018 Regular Meeting Agenda Packet63 of 175 May 15, 2018 Regular Meeting Agenda Packet64 of 175 May 15, 2018 Regular Meeting Agenda Packet65 of 175 May 15, 2018 Regular Meeting Agenda Packet66 of 175 May 15, 2018 Regular Meeting Agenda Packet67 of 175 May 15, 2018 Regular Meeting Agenda Packet68 of 175 TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET APRIL 2018 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 778,987 PREPAID EXPENSES 6,349 ADVALOREM PROPERTY TAXES RECEIVABLE 31,335 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE - TOTAL ASSETS 816,671 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 31,335 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 31,335 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 522,253 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 263,084 TOTAL FUND BALANCE 785,337 TOTAL LIABILITIES AND FUND BALANCE 816,671 May 15, 2018 Regular Meeting Agenda Packet 69 of 175 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 1 20:48 05/10/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 4/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40010-000-000 Property Taxes/MUD Fire 1,054,433.00- 1,054,433.00- 3,181.62- 1,049,201.89- 99.504 5,231.11- 122-40011-000-000 Property Taxes/Fire-Delinquent 466.42- 3,567.33- 3,567.33 122-40020-000-000 Property Taxes/Fire P&I 282.11- 3,414.86- 3,414.86 Subtotal: 1,054,433.00- 1,054,433.00- 3,930.15- 1,056,184.08- 100.166 1,751.08 Program number: 1,054,433.00- 1,054,433.00- 3,930.15- 1,056,184.08- 100.166 1,751.08 Department number: Fire Revenues 1,054,433.00- 1,054,433.00- 3,930.15- 1,056,184.08- 100.166 1,751.08 Revenues Subtotal ----------- 1,054,433.00- 1,054,433.00- 3,930.15- 1,056,184.08- 100.166 1,751.08 May 15, 2018 Regular Meeting Agenda Packet 70 of 175 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 2 20:48 05/10/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/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 8,889.09 49.384 9,110.91 122-60337-045-000 Transfer to Town/Fire Budget 608,910.00 608,910.00 50,742.50 355,197.50 58.333 253,712.50 Subtotal: 845,864.00 845,864.00 52,012.37 583,040.59 68.928 262,823.41 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 793,099.68 75.216 261,333.32 Department number: Fire 1,054,433.00 1,054,433.00 52,012.37 793,099.68 75.216 261,333.32 Expenditures Subtotal ----------- 1,054,433.00 1,054,433.00 52,012.37 793,099.68 75.216 261,333.32 Fund number: 122 Trophy Club MUD Fire Dept. 48,082.22 263,084.40- 263,084.40 May 15, 2018 Regular Meeting Agenda Packet 71 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 1 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 4/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 1311 04/02/2018 Property Taxes (1,046,020.27) (1,330.47) (1,047,350.74) GL 1312 04/03/2018 Property Taxes (379.66) (1,047,730.40) GL 1313 04/04/2018 Property Taxes (201.02) (1,047,931.42) GL 1314 04/05/2018 Property Taxes (350.45) (1,048,281.87) GL 1315 04/06/2018 Property Taxes (243.96) (1,048,525.83) GL 1316 04/16/2018 Property Taxes (137.52) (1,048,663.35) GL 1317 04/18/2018 Property Taxes (63.88) (1,048,727.23) GL 1318 04/20/2018 Property Taxes 646.10 (1,048,081.13) GL 1319 04/23/2018 Property Taxes (204.93) (1,048,286.06) GL 1320 04/24/2018 Property Taxes (180.07) (1,048,466.13) GL 1321 04/25/2018 Property Taxes (4.21) (1,048,470.34) GL 1322 04/26/2018 Property Taxes (238.23) (1,048,708.57) GL 1323 04/27/2018 Property Taxes (189.96) (1,048,898.53) GL 1324 04/30/2018 Property Taxes (303.36) (1,049,201.89) GL 1343 04/30/2018 Revs tax shortage Chk4088 Refund Tax Shortage (1,441.26) (1,050,643.15) DENTON COUNTY TAX OFFICE 4088 AP 1344 04/30/2018 Property Taxes- 03/23 Shortage 1,441.26 (1,049,201.89) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (3,181.62) (1,049,201.89) ** (1,054,433.00) Budgeted (5,231.11) Remaining 100 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1311 04/02/2018 Property Taxes (3,100.91) (99.58) (3,200.49) GL 1316 04/16/2018 Property Taxes (124.70) (3,325.19) GL 1319 04/23/2018 Property Taxes (.01) (3,325.20) GL 1321 04/25/2018 Property Taxes (242.12) (3,567.32) GL 1322 04/26/2018 Property Taxes (.01) (3,567.33) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (466.42) (3,567.33) ** .00 Budgeted 3,567.33 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 1311 04/02/2018 Property Taxes (3,132.75) (93.33) (3,226.08) GL 1312 04/03/2018 Property Taxes (.98) (3,227.06) GL 1313 04/04/2018 Property Taxes (1.99) (3,229.05) GL 1314 04/05/2018 Property Taxes (25.13) (3,254.18) GL 1315 04/06/2018 Property Taxes (14.45) (3,268.63) GL 1316 04/16/2018 Property Taxes (36.47) (3,305.10) GL 1317 04/18/2018 Property Taxes (9.37) (3,314.47) GL 1319 04/23/2018 Property Taxes (22.54) (3,337.01) GL 1320 04/24/2018 Property Taxes (4.20) (3,341.21) GL May 15, 2018 Regular Meeting Agenda Packet 72 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 2 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1321 04/25/2018 Property Taxes (3,132.75) (22.25) (3,363.46) GL 1322 04/26/2018 Property Taxes (3.83) (3,367.29) GL 1323 04/27/2018 Property Taxes (20.89) (3,388.18) GL 1324 04/30/2018 Property Taxes (26.68) (3,414.86) GL 1343 04/30/2018 Revs tax shortage Chk4088 Refund Tax Shortage .57 (3,414.29) DENTON COUNTY TAX OFFICE 4088 AP 1344 04/30/2018 Property Taxes- 03/23 Shortage (.57) (3,414.86) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (282.11) (3,414.86) ** .00 Budgeted 3,414.86 Remaining 0 % Used Department Totals: ----------------------------------- (1,056,184.08) ** (3,930.15) Monthly Total (1,054,433.00) Budgeted 1,751.08 Remaining 100 % Used May 15, 2018 Regular Meeting Agenda Packet 73 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 3 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/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 238 04/01/2018 Insurance/Wrk Comp Exp Apr 7,619.22 1,269.87 8,889.09 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,269.87 8,889.09 ** 18,000.00 Budgeted 9,110.91 Remaining 49 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 1126 04/04/2018 April A/P Fire Admin April 304,455.00 50,742.50 355,197.50 TOWN OF TROPHY CLUB 4078 AP _______________ Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 50,742.50 355,197.50 ** 608,910.00 Budgeted 253,712.50 Remaining 58 % 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: ----------------------------------- 793,099.68 ** 52,012.37 Monthly Total 1,054,433.00 Budgeted 261,333.32 Remaining 75 % Used May 15, 2018 Regular Meeting Agenda Packet 74 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/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: ----------------------------------- (263,084.40) 48,082.22 Monthly Total .00 Budgeted 263,084.40 Remaining 0 % Used May 15, 2018 Regular Meeting Agenda Packet 75 of 175 TROPHY CLUB MUD #1 - O&M BALANCE SHEET APRIL 2018 GTBGT 135 137 GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 - 600 CASH IN BANK-CHECKING 902,558 - 902,558 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 714,929 - 714,929 INVESTMENTS-TEXPOOL 1,748,273 596,426 2,344,699 PREPAID EXPENSES 45,857 - 45,857 ADVALOREM PROPERTY TAXES RECEIVABLE 3,553 - 3,553 UTILITY AND OTHER ACCOUNTS RECEIVABLE 878,763 - 878,763 TOTAL ASSETS 5,111,824 596,426 5,708,250 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 3,553 - 3,553 ACCOUNTS AND OTHER PAYABLES 451,191 - 451,191 CUSTOMER DEPOSITS 315,605 - 315,605 - TOTAL LIABILITIES 770,349 - 770,349 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 191,107 - 191,107 - TOTAL FUND BALANCE 4,341,475 596,426 4,937,901 TOTAL LIABILITIES AND FUND BALANCE 5,111,824 596,426 5,708,250 May 15, 2018 Regular Meeting Agenda Packet 76 of 175 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 3 20:48 05/10/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/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- 364.92- 120,345.17- 99.500 604.83- 135-40002-000-000 Property Taxes/Delinquent 200.00- 200.00- 27.70- 230.75- 115.375 30.75 135-40015-000-000 Property Taxes/P & I 200.00- 200.00- 27.89- 363.05- 181.525 163.05 135-40025-000-000 PID Surcharges 177,839.00- 177,839.00- 177,839.00- Subtotal: 299,189.00- 299,189.00- 420.51- 120,938.97- 40.422 178,250.03- 135-47000-000-000 Water 6,464,019.00- 6,464,019.00- 415,533.61- 2,640,649.08- 40.852 3,823,369.92- 135-47005-000-000 Sewer 2,978,067.00- 2,978,067.00- 261,105.47- 1,683,847.74- 56.542 1,294,219.26- 135-47025-000-000 Penalties 106,279.00- 106,279.00- 5,090.38- 64,594.49- 60.778 41,684.51- 135-47030-000-000 Service Charges 21,350.00- 21,350.00- 1,250.00- 8,450.00- 39.578 12,900.00- 135-47035-000-000 Plumbing Inspections 1,500.00- 1,500.00- 1,500.00- 100.000 135-47045-000-000 Sewer Inspections 4,500.00- 4,500.00- 3,700.00- 82.222 800.00- 135-47070-000-000 TCCC Effluent Charges 60,000.00- 60,000.00- 6,337.60- 16,310.40- 27.184 43,689.60- Subtotal: 9,635,715.00- 9,635,715.00- 689,317.06- 4,419,051.71- 45.861 5,216,663.29- 135-49010-000-000 Interest Income 12,000.00- 12,000.00- 4,704.36- 25,571.00- 213.092 13,571.00 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 1,957.62- 7,762.20- 71.043 3,163.80- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 4,083.31- 58.333 2,916.69- 135-49026-000-000 Proceeds from Sale of Assets 2,000.00- 2,000.00- 15,400.00- 15,400.00- 770.000 13,400.00 135-49075-000-000 Oversize Meter Reimbursement 18,179.00- 18,179.00- 9,434.76- 51.899 8,744.24- 135-49141-000-000 Interfund Transfer In 796,145.08- 796,145.08- 796,145.08 135-49900-000-000 Miscellaneous Income 5,000.00- 5,000.00- 310.54- 12,758.19- 255.164 7,758.19 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- 819,100.93- 871,154.54- 276.447 556,029.54 Program number: 10,250,029.00- 10,250,029.00- 1,508,838.50- 5,411,145.22- 52.792 4,838,883.78- Department number: Revenues 10,250,029.00- 10,250,029.00- 1,508,838.50- 5,411,145.22- 52.792 4,838,883.78- Revenues Subtotal ----------- 10,250,029.00- 10,250,029.00- 1,508,838.50- 5,411,145.22- 52.792 4,838,883.78- May 15, 2018 Regular Meeting Agenda Packet 77 of 175 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 4 20:48 05/10/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/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 18,641.57 118,432.50 43.180 155,846.50 135-50010-010-000 Overtime 20,000.00 20,000.00 885.32 5,510.70 27.554 14,489.30 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 175.00 1,250.00 37.879 2,050.00 135-50020-010-000 Retirement 27,843.00 27,843.00 1,822.42 13,296.50 47.755 14,546.50 135-50026-010-000 Medical Insurance 52,196.00 52,196.00 2,948.80 18,055.83 34.592 34,140.17 135-50027-010-000 Dental Insurance 5,182.00 5,182.00 213.65 1,521.04 29.352 3,660.96 135-50028-010-000 Vision Insurance 994.00 994.00 35.92 280.23 28.192 713.77 135-50029-010-000 Life Insurance & Other 2,982.00 2,982.00 399.14 1,674.71 56.161 1,307.29 135-50030-010-000 Social Security Taxes 18,662.00 18,662.00 1,212.01 7,903.81 42.352 10,758.19 135-50035-010-000 Medicare Taxes 4,365.00 4,365.00 283.43 1,848.45 42.347 2,516.55 135-50040-010-000 Unemployment Taxes 1,080.00 1,080.00 78.35 808.42 74.854 271.58 135-50045-010-000 Workman's Compensation 11,854.00 11,854.00 899.92 6,299.44 53.142 5,554.56 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 27,595.53 180,436.67 42.290 246,225.33 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 906.46 48,666.04 48.666 51,333.96 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 3,853.07 96.327 146.93 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 836.72 3,605.16 65.548 1,894.84 Subtotal: 391,000.00 391,000.00 1,743.18 56,124.27 14.354 334,875.73 135-60010-010-000 Communications/Mobiles 4,700.00 4,700.00 2,122.44 45.158 2,577.56 135-60020-010-000 Electricity 175,356.00 175,356.00 9,302.54 73,159.82 41.721 102,196.18 135-60066-010-000 Publications/Books/Subscripts 1,000.00 1,000.00 767.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 60.00 1,395.78 50.118 1,389.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 4,602.27 17,410.32 31.554 37,765.68 135-60150-010-000 Wholesale Water 2,823,170.00 2,823,170.00 241,084.44 962,751.81 34.102 1,860,418.19 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,000.00 3,000.00 180.00 502.70 16.757 2,497.30 135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 1,500.00 4,500.00 30.508 10,250.00 135-60332-010-000 Interfund Transfer Out-Rev I&S 278,084.00 278,084.00 25,280.31 176,962.17 63.636 101,121.83 135-60333-010-000 Interfund Transfer Out-Reserve 48,996.00 48,996.00 4,083.00 28,581.00 58.333 20,415.00 135-60334-010-000 Interfund Transfer Out 200,000.00 200,000.00 1,053,935.08 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- May 15, 2018 Regular Meeting Agenda Packet 78 of 175 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 5 20:48 05/10/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/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 1,340,794.64 2,327,203.62 64.397 1,286,648.38 135-65005-010-000 Fuel & Lube 15,000.00 15,000.00 973.50 5,779.30 38.529 9,220.70 135-65010-010-000 Uniforms 4,488.00 4,488.00 258.57 1,249.14 27.833 3,238.86 135-65030-010-000 Chemicals 20,000.00 20,000.00 2,208.14 10,731.77 53.659 9,268.23 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 192.00 19.200 808.00 135-65050-010-000 Meter Expense 50,000.00 50,000.00 3,691.00 16,091.00 32.182 33,909.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,131.21 82,943.21 47.211 92,744.79 135-69005-010-000 Capital Outlays 810,012.00 810,012.00 57,671.25 365,542.05 45.128 444,469.95 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 57,671.25 548,406.43 52.317 499,824.57 Program number: 5,655,433.00 5,655,433.00 1,434,935.81 3,195,114.20 56.496 2,460,318.80 May 15, 2018 Regular Meeting Agenda Packet 79 of 175 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 6 20:48 05/10/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 4/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 296.19 1,200.08 60.004 799.92 Subtotal: 2,000.00 2,000.00 296.19 1,200.08 60.004 799.92 Program number: 1 Lab Analysis for PID 2,000.00 2,000.00 296.19 1,200.08 60.004 799.92 Department number: Water 5,657,433.00 5,657,433.00 1,435,232.00 3,196,314.28 56.498 2,461,118.72 May 15, 2018 Regular Meeting Agenda Packet 80 of 175 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7 20:48 05/10/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/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,215.53 210,111.04 51.139 200,754.96 135-50010-020-000 Overtime 30,000.00 30,000.00 3,965.74 19,634.62 65.449 10,365.38 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 4,936.00 58.762 3,464.00 135-50020-020-000 Retirement 42,243.00 42,243.00 2,764.03 23,848.14 56.455 18,394.86 135-50026-020-000 Medical Insurance 62,175.00 62,175.00 5,518.69 37,974.64 61.077 24,200.36 135-50027-020-000 Dental Insurance 5,271.00 5,271.00 496.68 2,832.29 53.733 2,438.71 135-50028-020-000 Vision Insurance 1,114.00 1,114.00 58.90 508.36 45.634 605.64 135-50029-020-000 Life Insurance & Other 4,281.00 4,281.00 650.56 2,989.82 69.839 1,291.18 135-50030-020-000 Social Security Taxes 28,314.00 28,314.00 1,676.36 13,976.06 49.361 14,337.94 135-50035-020-000 Medicare Taxes 6,622.00 6,622.00 392.06 3,268.59 49.360 3,353.41 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 9,436.00 52.451 8,554.00 135-50060-020-000 Pre-emp Physicals/Testing 300.00 300.00 300.00 135-50070-020-000 Employee Relations 350.00 350.00 350.00 Subtotal: 626,601.00 626,601.00 42,786.55 338,064.56 53.952 288,536.44 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 9,749.87 36,495.26 42.387 49,604.74 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 2,061.46 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 6,820.84 50,181.61 83.636 9,818.39 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 2,202.60 20,529.42 68.431 9,470.58 Subtotal: 219,150.00 219,150.00 20,834.77 116,023.36 52.942 103,126.64 135-60010-020-000 Communications/Mobiles 4,700.00 4,700.00 2,865.72 60.973 1,834.28 135-60020-020-000 Electricity 266,709.00 266,709.00 13,148.89 99,534.05 37.319 167,174.95 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 222.00 3.911 5,455.00 135-60090-020-000 Safety Program 550.00 550.00 343.35 351.72 63.949 198.28 135-60100-020-000 Travel & per diem 1,635.00 1,635.00 17.40 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 4,000.00 135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 1,180.00 3,540.00 30.517 8,060.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 122,043.00 122,043.00 11,094.81 77,663.67 63.636 44,379.33 135-60332-020-000 Interfund Transfer Out-Rev I&S 598,738.00 598,738.00 54,430.72 381,015.04 63.636 217,722.96 135-60333-020-000 Interfund Transfer Out-Reserve 123,336.00 123,336.00 10,278.00 71,946.00 58.333 51,390.00 May 15, 2018 Regular Meeting Agenda Packet 81 of 175 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 8 20:48 05/10/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/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 200,000.00 135-60360-020-000 Furniture/Equipment < $5000 4,000.00 4,000.00 1,762.00 1,762.00 44.050 2,238.00 Subtotal: 1,438,938.00 1,438,938.00 92,255.17 669,263.19 46.511 769,674.81 135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 604.75 5,340.19 42.722 7,159.81 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 29.88 5,281.23 19.204 22,218.77 135-65035-020-000 Small Tools 1,000.00 1,000.00 10.95 1,149.94 114.994 149.94- 135-65040-020-000 Safety Equipment 750.00 750.00 164.40 750.97 100.129 .97- 135-65045-020-000 Lab Supplies 14,000.00 14,000.00 2,861.12 10,700.58 76.433 3,299.42 Subtotal: 60,209.00 60,209.00 3,671.10 24,997.50 41.518 35,211.50 135-69005-020-000 Capital Outlays 547,327.00 547,327.00 219,495.17- 89,960.61 16.436 457,366.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 219,495.17- 119,960.61 18.855 516,281.39 Program number: 2,981,140.00 2,981,140.00 59,947.58- 1,268,309.22 42.544 1,712,830.78 Department number: Wastewater 2,981,140.00 2,981,140.00 59,947.58- 1,268,309.22 42.544 1,712,830.78 May 15, 2018 Regular Meeting Agenda Packet 82 of 175 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 9 20:48 05/10/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 4/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 16.94 56.467 13.06 Subtotal: 30.00 30.00 2.42 16.94 56.467 13.06 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 810.00 810.00 67.500 390.00 135-60080-026-000 Schools & Training 4,000.00 4,000.00 405.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 233.55 1,255.28 62.764 744.72 Subtotal: 12,950.00 12,950.00 1,448.55 5,215.28 40.272 7,734.72 Program number: 12,980.00 12,980.00 1,450.97 5,232.22 40.310 7,747.78 Department number: Board of Directors 12,980.00 12,980.00 1,450.97 5,232.22 40.310 7,747.78 May 15, 2018 Regular Meeting Agenda Packet 83 of 175 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 10 20:48 05/10/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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,557.13 214,185.54 49.481 218,677.46 135-50010-030-000 Overtime 2,000.00 2,000.00 10.39 467.06 23.353 1,532.94 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,105.00 22,490.45 55.459 18,062.55 135-50026-030-000 Medical Insurance 63,485.00 63,485.00 4,145.24 27,338.45 43.063 36,146.55 135-50027-030-000 Dental Insurance 5,502.00 5,502.00 259.52 2,012.44 36.577 3,489.56 135-50028-030-000 Vision Insurance 1,173.00 1,173.00 42.51 383.92 32.730 789.08 135-50029-030-000 Life Insurance & Other 5,059.00 5,059.00 534.46 2,454.75 48.522 2,604.25 135-50030-030-000 Social Security Taxes 27,181.00 27,181.00 2,002.72 12,990.91 47.794 14,190.09 135-50035-030-000 Medicare Taxes 6,357.00 6,357.00 468.38 3,038.19 47.793 3,318.81 135-50040-030-000 Unemployment Taxes 1,260.00 1,260.00 81.87 983.77 78.077 276.23 135-50045-030-000 Workman's Compensation 1,529.00 1,529.00 123.50 864.50 56.540 664.50 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 760.82 3,109.08 62.683 1,850.92 Subtotal: 595,970.00 595,970.00 45,091.54 293,991.51 49.330 301,978.49 135-55030-030-000 Software & Support 78,391.00 78,391.00 8,920.35 53,406.90 68.129 24,984.10 135-55070-030-000 Independent Labor 154,000.00 154,000.00 13,647.83 87,822.59 57.028 66,177.41 135-55080-030-000 Maintenance & Repairs 14,000.00 14,000.00 2,670.44 5,146.17 36.758 8,853.83 135-55085-030-000 Generator Maint. and Repair 10,000.00 10,000.00 3,955.00 3,955.00 39.550 6,045.00 135-55120-030-000 Cleaning Services 10,000.00 10,000.00 869.06 4,831.45 48.315 5,168.55 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 177.94 4,129.73 45.886 4,870.27 Subtotal: 338,916.00 338,916.00 30,240.62 218,531.84 64.480 120,384.16 135-60005-030-000 Telephone 27,300.00 27,300.00 2,589.86 10,007.54 36.658 17,292.46 135-60010-030-000 Communications/Mobiles 4,000.00 4,000.00 150.00 1,799.43 44.986 2,200.57 135-60020-030-000 Electricity/Gas 16,261.00 16,261.00 745.53 3,852.21 23.690 12,408.79 135-60025-030-000 Water 2,500.00 2,500.00 58.32 397.44 15.898 2,102.56 135-60030-030-000 Rent And/Or Usage 616.40 616.40- 135-60035-030-000 Postage 30,000.00 30,000.00 312.44 12,977.71 43.259 17,022.29 135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 4,557.10 34,353.22 61.831 21,206.78 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 45,977.52 82.103 10,022.48 135-60066-030-000 Publications/Books/Subscripts 1,600.00 1,600.00 206.38 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 48.62 12.155 351.38 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 450.00 3,143.00 41.355 4,457.00 135-60100-030-000 Travel & per diem 4,885.00 4,885.00 111.29 711.12 14.557 4,173.88 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 May 15, 2018 Regular Meeting Agenda Packet 84 of 175 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 11 20:48 05/10/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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 75.00 220.00 4.889 4,280.00 135-60125-030-000 Advertising 2,500.00 2,500.00 150.00 150.00 6.000 2,350.00 135-60235-030-000 Security 2,700.00 2,700.00 24.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 15,530.28 118,721.50 47.583 130,784.50 135-65010-030-000 Uniforms 700.00 700.00 135.99 273.73 39.104 426.27 135-65055-030-000 Hardware 7,420.00 7,420.00 910.99 1,508.94 20.336 5,911.06 135-65085-030-000 Office Supplies 7,000.00 7,000.00 446.19 3,322.40 47.463 3,677.60 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 363.36 3,185.75 79.644 814.25 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 1,856.53 10,483.48 41.734 14,636.52 135-69005-030-000 Capital Outlays 13,000.00 13,000.00 20,986.32 28,827.32 221.749 15,827.32- 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 248.39 1,724.53 37.490 2,875.47 Subtotal: 17,600.00 17,600.00 21,234.71 30,551.85 173.590 12,951.85- Program number: 1,227,112.00 1,227,112.00 113,953.68 672,280.18 54.786 554,831.82 Department number: Administration 1,227,112.00 1,227,112.00 113,953.68 672,280.18 54.786 554,831.82 May 15, 2018 Regular Meeting Agenda Packet 85 of 175 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 12 20:48 05/10/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 4/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 5,940.00 42,753.55 31.207 94,246.45 135-55055-039-000 Auditing 24,500.00 24,500.00 25,508.70 104.117 1,008.70- 135-55060-039-000 Appraisal 11,446.00 11,446.00 6,672.05 58.292 4,773.95 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 5,940.00 77,902.70 44.076 98,843.30 Program number: 176,746.00 176,746.00 5,940.00 77,902.70 44.076 98,843.30 Department number: Non Departmental 176,746.00 176,746.00 5,940.00 77,902.70 44.076 98,843.30 Expenditures Subtotal ----------- 10,055,411.00 10,055,411.00 1,496,629.07 5,220,038.60 51.913 4,835,372.40 Fund number: 135 MUD 1 General Fund 194,618.00- 194,618.00- 12,209.43- 191,106.62- 98.196 3,511.38- May 15, 2018 Regular Meeting Agenda Packet 86 of 175 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 13 20:48 05/10/18 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 4/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 May 15, 2018 Regular Meeting Agenda Packet 87 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 5 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/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 1311 04/02/2018 Property Taxes (119,980.25) (152.60) (120,132.85) GL 1312 04/03/2018 Property Taxes (43.55) (120,176.40) GL 1313 04/04/2018 Property Taxes (23.05) (120,199.45) GL 1314 04/05/2018 Property Taxes (40.20) (120,239.65) GL 1315 04/06/2018 Property Taxes (27.98) (120,267.63) GL 1316 04/16/2018 Property Taxes (15.77) (120,283.40) GL 1317 04/18/2018 Property Taxes (7.33) (120,290.73) GL 1318 04/20/2018 Property Taxes 74.11 (120,216.62) GL 1319 04/23/2018 Property Taxes (23.50) (120,240.12) GL 1320 04/24/2018 Property Taxes (20.65) (120,260.77) GL 1321 04/25/2018 Property Taxes (.48) (120,261.25) GL 1322 04/26/2018 Property Taxes (27.33) (120,288.58) GL 1323 04/27/2018 Property Taxes (21.79) (120,310.37) GL 1324 04/30/2018 Property Taxes (34.80) (120,345.17) GL 1343 04/30/2018 Revs tax shortage Chk4088 Refund Tax Shortage (165.31) (120,510.48) DENTON COUNTY TAX OFFICE 4088 AP 1344 04/30/2018 Property Taxes- 03/23 Shortage 165.31 (120,345.17) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (364.92) (120,345.17) ** (120,950.00) Budgeted (604.83) Remaining 99 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1311 04/02/2018 Property Taxes (203.05) (6.12) (209.17) GL 1316 04/16/2018 Property Taxes (7.34) (216.51) GL 1321 04/25/2018 Property Taxes (14.24) (230.75) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (27.70) (230.75) ** (200.00) Budgeted 30.75 Remaining 115 % Used Account: 135-40015-000-000 Property Taxes/P & I 1311 04/02/2018 Property Taxes (335.16) (9.30) (344.46) GL 1312 04/03/2018 Property Taxes (.11) (344.57) GL 1313 04/04/2018 Property Taxes (.23) (344.80) GL 1314 04/05/2018 Property Taxes (2.88) (347.68) GL 1315 04/06/2018 Property Taxes (1.66) (349.34) GL 1316 04/16/2018 Property Taxes (2.32) (351.66) GL 1317 04/18/2018 Property Taxes (1.07) (352.73) GL 1319 04/23/2018 Property Taxes (2.59) (355.32) GL 1320 04/24/2018 Property Taxes (.49) (355.81) GL 1321 04/25/2018 Property Taxes (1.34) (357.15) GL 1322 04/26/2018 Property Taxes (.44) (357.59) GL May 15, 2018 Regular Meeting Agenda Packet 88 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 6 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1323 04/27/2018 Property Taxes (335.16) (2.40) (359.99) GL 1324 04/30/2018 Property Taxes (3.06) (363.05) GL 1343 04/30/2018 Revs tax shortage Chk4088 Refund Tax Shortage .06 (362.99) DENTON COUNTY TAX OFFICE 4088 AP 1344 04/30/2018 Property Taxes- 03/23 Shortage (.06) (363.05) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (27.89) (363.05) ** (200.00) Budgeted 163.05 Remaining 182 % 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 1129 04/04/2018 UB 04/04/2018 Charge removal UB20180404-20180404 User: (2,225,115.47) 26.85 (2,225,088.62) UB 1282 04/30/2018 Ashtoon Woods Water Main Repar 100,000 Gallons@ $3.96 per1000 (396.00) (2,225,484.62) GL 1289 04/30/2018 UB 04/2018 Billing UB20180430-20180430 User: (415,164.46) (2,640,649.08) UB _______________ Account: 135-47000-000-000 Water Totals: (415,533.61) (2,640,649.08) ** (6,464,019.00) Budgeted (3,823,369.92) Remaining 41 % Used Account: 135-47005-000-000 Sewer 1129 04/04/2018 UB 04/04/2018 Charge removal UB20180404-20180404 User: (1,422,742.27) 26.79 (1,422,715.48) UB 1289 04/30/2018 UB 04/2018 Billing UB20180430-20180430 User: (261,132.26) (1,683,847.74) UB _______________ Account: 135-47005-000-000 Sewer Totals: (261,105.47) (1,683,847.74) ** (2,978,067.00) Budgeted (1,294,219.26) Remaining 57 % Used Account: 135-47025-000-000 Penalties 1166 04/09/2018 UB 04/09/2018 Penalty removal UB20180409-20180409 User: (59,504.11) 72.25 (59,431.86) UB 1238 04/23/2018 UB 04/23/2018 C/A Penalties UB20180423-20180423 User: (5,252.94) (64,684.80) UB 1247 04/25/2018 UB 04/25/2018 Penalty Removal UB20180425-20180425 User: 34.23 (64,650.57) UB 1262 04/27/2018 UB 04/27/2018 Penalty Removal UB20180427-20180427 User: 28.11 (64,622.46) UB 1274 04/30/2018 UB 04/30/2018 Penalty removal UB20180430-20180430 User: 27.97 (64,594.49) UB _______________ Account: 135-47025-000-000 Penalties Totals: (5,090.38) (64,594.49) ** (106,279.00) Budgeted (41,684.51) Remaining 61 % Used May 15, 2018 Regular Meeting Agenda Packet 89 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 7 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-47030-000-000 Service Charges 1140 04/05/2018 UB 04/05/2018 Disconnect Fees UB20180405-20180405 User: (7,200.00) (1,200.00) (8,400.00) UB 1232 04/19/2018 UB 04/19/2018 NSF checks UB20180419-20180419 User: (50.00) (8,450.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,250.00) (8,450.00) ** (21,350.00) Budgeted (12,900.00) Remaining 40 % Used Account: 135-47035-000-000 Plumbing Inspections (1,500.00) .00 (1,500.00) _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: .00 (1,500.00) ** (1,500.00) Budgeted .00 Remaining 100 % Used Account: 135-47045-000-000 Sewer Inspections (3,700.00) .00 (3,700.00) _______________ Account: 135-47045-000-000 Sewer Inspections Totals: .00 (3,700.00) ** (4,500.00) Budgeted (800.00) Remaining 82 % Used Account: 135-47070-000-000 TCCC Effluent Charges 1289 04/30/2018 UB 04/2018 Billing UB20180430-20180430 User: (9,972.80) (6,337.60) (16,310.40) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (6,337.60) (16,310.40) ** (60,000.00) Budgeted (43,689.60) Remaining 27 % Used Account: 135-49010-000-000 Interest Income 1304 04/30/2018 Bank Interest- April (20,866.64) (151.77) (21,018.41) GL 1304 04/30/2018 Bank Interest- April (494.45) (21,512.86) GL 1304 04/30/2018 Bank Interest- April (4,058.14) (25,571.00) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (4,704.36) (25,571.00) ** (12,000.00) Budgeted 13,571.00 Remaining 213 % Used Account: 135-49016-000-000 Cell Tower Revenue 1280 04/23/2018 Cell Tower Rev AT&T (5,804.58) (978.81) (6,783.39) GL 1250 04/30/2018 Cell Tower Rev AT&T April (978.81) (7,762.20) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (1,957.62) (7,762.20) ** (10,926.00) Budgeted (3,163.80) Remaining 71 % Used May 15, 2018 Regular Meeting Agenda Packet 90 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 8 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-49018-000-000 Building Rent Income 1329 04/30/2018 Town Billed Invoices 1633-1636 AR 20180430-20180430 User: (3,499.98) (583.33) (4,083.31) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (4,083.31) ** (7,000.00) Budgeted (2,916.69) Remaining 58 % Used Account: 135-49026-000-000 Proceeds from Sale of Assets 1251 04/23/2018 Sale of WW Trucks in Auction Sale of Assets- WW trucks (15,400.00) (15,400.00) GL _______________ Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: (15,400.00) (15,400.00) ** (2,000.00) Budgeted 13,400.00 Remaining 770 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement (9,434.76) .00 (9,434.76) _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: .00 (9,434.76) ** (18,179.00) Budgeted (8,744.24) Remaining 52 % Used Account: 135-49141-000-000 Interfund Transfer In 1306 04/30/2018 Swift Fund Deposit TexPool (796,145.08) (796,145.08) GL _______________ Account: 135-49141-000-000 Interfund Transfer In Totals: (796,145.08) (796,145.08) ** .00 Budgeted 796,145.08 Remaining 0 % Used Account: 135-49900-000-000 Miscellaneous Income 1222 04/19/2018 JSB Non-Serv Agreement Inv1632 AR 20180419-20180419 User: (12,447.65) (45,000.00) (57,447.65) AR 1289 04/30/2018 UB 04/2018 Billing UB20180430-20180430 User: (310.54) (57,758.19) UB 1330 04/30/2018 Reverse JSB Invoice 1632 AR 20180430-20180430 User: 45,000.00 (12,758.19) AR _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (310.54) (12,758.19) ** (5,000.00) Budgeted 7,758.19 Remaining 255 % 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 May 15, 2018 Regular Meeting Agenda Packet 91 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 9 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-49910-000-000 Reimbursement/Revenue Bond .00 .00 _______________ Account: 135-49910-000-000 Reimbursement/Revenue Bond Totals: .00 .00 ** (260,000.00) Budgeted (260,000.00) Remaining 0 % Used Department Totals: ----------------------------------- (5,411,145.22) ** (1,508,838.50) Monthly Total (10,250,029.00) Budgeted (4,838,883.78) Remaining 53 % Used May 15, 2018 Regular Meeting Agenda Packet 92 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/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 1119 04/06/2018 MUD PR 04.06.18 Salaries & Wages 99,790.93 8,883.92 108,674.85 PR 1212 04/20/2018 MUD PR 04.20.18 Salaries & Wages 9,757.65 118,432.50 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 18,641.57 118,432.50 ** 274,279.00 Budgeted 155,846.50 Remaining 43 % Used Account: 135-50010-010-000 Overtime 1119 04/06/2018 MUD PR 04.06.18 Overtime 4,625.38 647.89 5,273.27 PR 1212 04/20/2018 MUD PR 04.20.18 Overtime 237.43 5,510.70 PR _______________ Account: 135-50010-010-000 Overtime Totals: 885.32 5,510.70 ** 20,000.00 Budgeted 14,489.30 Remaining 28 % 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 1212 04/20/2018 MUD PR 04.20.18 Certification 1,075.00 175.00 1,250.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 175.00 1,250.00 ** 3,300.00 Budgeted 2,050.00 Remaining 38 % Used Account: 135-50020-010-000 Retirement 1119 04/06/2018 MUD PR 04.06.18 Retirement 11,474.08 881.68 12,355.76 PR 1212 04/20/2018 MUD PR 04.20.18 Retirement 940.74 13,296.50 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,822.42 13,296.50 ** 27,843.00 Budgeted 14,546.50 Remaining 48 % Used Account: 135-50026-010-000 Medical Insurance 1119 04/06/2018 MUD PR 04.06.18 Medical Insurance 15,107.03 1,474.40 16,581.43 PR 1212 04/20/2018 MUD PR 04.20.18 Medical Insurance 1,474.40 18,055.83 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,948.80 18,055.83 ** 52,196.00 Budgeted 34,140.17 Remaining 35 % Used May 15, 2018 Regular Meeting Agenda Packet 93 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/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 1119 04/06/2018 MUD PR 04.06.18 Dental Insurance 1,307.39 106.85 1,414.24 PR 1212 04/20/2018 MUD PR 04.20.18 Dental Insurance 106.80 1,521.04 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 213.65 1,521.04 ** 5,182.00 Budgeted 3,660.96 Remaining 29 % Used Account: 135-50028-010-000 Vision Insurance 1119 04/06/2018 MUD PR 04.06.18 Vision Insurance 244.31 17.98 262.29 PR 1212 04/20/2018 MUD PR 04.20.18 Vision Insurance 17.94 280.23 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 35.92 280.23 ** 994.00 Budgeted 713.77 Remaining 28 % Used Account: 135-50029-010-000 Life Insurance & Other 1021 04/01/2018 April A/P Employee Beneifts 1,275.57 110.60 1,386.17 Humana Inc 4015 AP 1060 04/01/2018 April A/P employee ins-STD,Life 72.43 1,458.60 METLIFE GROUP BENEFITS 4066 AP 1242 04/24/2018 April A/P FLex admin fee 18.50 1,477.10 BenefitMall 4121 AP 1258 04/26/2018 April A/P STD & LTD employee benefits 87.01 1,564.11 METLIFE GROUP BENEFITS 4143 AP 1258 04/26/2018 April A/P Employee benefits 110.60 1,674.71 Humana Inc 4133 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 399.14 1,674.71 ** 2,982.00 Budgeted 1,307.29 Remaining 56 % Used Account: 135-50030-010-000 Social Security Taxes 1119 04/06/2018 MUD PR 04.06.18 Social Security Taxes 6,691.80 592.73 7,284.53 PR 1212 04/20/2018 MUD PR 04.20.18 Social Security Taxes 619.28 7,903.81 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,212.01 7,903.81 ** 18,662.00 Budgeted 10,758.19 Remaining 42 % Used Account: 135-50035-010-000 Medicare Taxes 1119 04/06/2018 MUD PR 04.06.18 Medicare Taxes 1,565.02 138.63 1,703.65 PR 1212 04/20/2018 MUD PR 04.20.18 Medicare Taxes 144.80 1,848.45 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 283.43 1,848.45 ** 4,365.00 Budgeted 2,516.55 Remaining 42 % Used Account: 135-50040-010-000 Unemployment Taxes May 15, 2018 Regular Meeting Agenda Packet 94 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 12 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1119 04/06/2018 MUD PR 04.06.18 Unemployment Taxes 730.07 46.39 776.46 PR 1212 04/20/2018 MUD PR 04.20.18 Unemployment Taxes 31.96 808.42 PR _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 78.35 808.42 ** 1,080.00 Budgeted 271.58 Remaining 75 % Used Account: 135-50045-010-000 Workman's Compensation 238 04/01/2018 Insurance/Wrk Comp Exp Apr 5,399.52 899.92 6,299.44 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 899.92 6,299.44 ** 11,854.00 Budgeted 5,554.56 Remaining 53 % 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 1193 04/13/2018 April A/P 10" valve replacement-525 Indi 47,759.58 7,519.55 55,279.13 REY-MAR CONSTRUCTION 4111 AP 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 STUART HOSE & PIPE-FT 318.00 55,597.13 STUART HOSE & PIPE-FT PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 THE HOME DEPOT #6581 150.68 55,747.81 THE HOME DEPOT #6581 PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 THE HOME DEPOT #6581 12.07 55,759.88 THE HOME DEPOT #6581 PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 SC TRACKING SOLUTIONS 65.70 55,825.58 SC TRACKING SOLUTIONS PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 MACARTHUR GAUGE INC 50.00 55,875.58 MACARTHUR GAUGE INC PC 1282 04/30/2018 Ashtoon Woods Water Main Repar 609 Hogan's Drive (7,209.54) 48,666.04 GL May 15, 2018 Regular Meeting Agenda Packet 95 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 13 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/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: 906.46 48,666.04 ** 100,000.00 Budgeted 51,333.96 Remaining 49 % 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 3,853.07 .00 3,853.07 _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: .00 3,853.07 ** 4,000.00 Budgeted 146.93 Remaining 96 % 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 1346 04/30/2018 April A/P TCEQ samples 2,768.44 476.72 3,245.16 LOWER COLORADO RIVER AUTHORITY 4180 AP 1364 04/30/2018 April A/P Water samples 360.00 3,605.16 TARRANT CTY PUBLIC HEALTH LAB 4186 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 836.72 3,605.16 ** 5,500.00 Budgeted 1,894.84 Remaining 66 % Used Account: 135-60010-010-000 Communications/Mobiles 2,122.44 .00 2,122.44 _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: .00 2,122.44 ** 4,700.00 Budgeted 2,577.56 Remaining 45 % Used Account: 135-60020-010-000 Electricity 1242 04/24/2018 April A/P Electricity 3/9-4/10 63,857.28 9,302.54 73,159.82 HUDSON ENERGY SERVICES, LLC 4134 AP May 15, 2018 Regular Meeting Agenda Packet 96 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 14 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60020-010-000 Electricity Totals: 9,302.54 73,159.82 ** 175,356.00 Budgeted 102,196.18 Remaining 42 % Used Account: 135-60066-010-000 Publications/Books/Subscripts 1178 04/11/2018 April A/P AWWA Standards renewal 767.00 767.00 AMERICAN WATER WORKS ASSOC 4096 AP _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: 767.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 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 SUNCOAST LEARNING SYST 1,335.78 60.00 1,395.78 SUNCOAST LEARNING SYST PC _______________ Account: 135-60080-010-000 Schools & Training Totals: 60.00 1,395.78 ** 2,785.00 Budgeted 1,389.22 Remaining 50 % 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 .00 .00 May 15, 2018 Regular Meeting Agenda Packet 97 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 15 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 1346 04/30/2018 April A/P Well water 12,808.05 4,602.27 17,410.32 North Texas Groundwater 4183 AP _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 4,602.27 17,410.32 ** 55,176.00 Budgeted 37,765.68 Remaining 32 % Used Account: 135-60150-010-000 Wholesale Water 1242 04/24/2018 April A/P Fort worth water 721,667.37 241,084.44 962,751.81 CITY OF FORT WORTH 4123 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 241,084.44 962,751.81 ** 2,823,170.00 Budgeted 1,860,418.19 Remaining 34 % 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 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 DENTON SAND & GRAVEL, 322.70 72.00 394.70 DENTON SAND & GRAVEL, PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 DENTON SAND & GRAVEL, 108.00 502.70 DENTON SAND & GRAVEL, PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 180.00 502.70 ** 3,000.00 Budgeted 2,497.30 Remaining 17 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance 1294 04/30/2018 April A/P April mowing 3,000.00 1,500.00 4,500.00 WATTS ELLISON LLC 4156 AP _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: 1,500.00 4,500.00 ** 14,750.00 Budgeted 10,250.00 Remaining 31 % Used Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S 1305 04/30/2018 Texpool Transfers April 151,681.86 25,280.31 176,962.17 GL May 15, 2018 Regular Meeting Agenda Packet 98 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/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 176,962.17 ** 278,084.00 Budgeted 101,121.83 Remaining 64 % Used Account: 135-60333-010-000 Interfund Transfer Out-Reserve 1305 04/30/2018 Texpool Transfers April 24,498.00 4,083.00 28,581.00 GL _______________ Account: 135-60333-010-000 Interfund Transfer Out-Reserve Totals: 4,083.00 28,581.00 ** 48,996.00 Budgeted 20,415.00 Remaining 58 % Used Account: 135-60334-010-000 Interfund Transfer Out 1306 04/30/2018 Swift Fund Deposit TexPool 1,053,935.08 1,053,935.08 GL _______________ Account: 135-60334-010-000 Interfund Transfer Out Totals: 1,053,935.08 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 1258 04/26/2018 April A/P Fuel 4,805.80 950.39 5,756.19 US Bank Voyager Fleet Systems 4147 AP 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 7-ELEVEN 32921 23.11 5,779.30 7-ELEVEN 32921 PC _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 973.50 5,779.30 ** 15,000.00 Budgeted 9,220.70 Remaining 39 % Used Account: 135-65010-010-000 Uniforms 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 WM SUPERCENTER #5247 990.57 83.44 1,074.01 WM SUPERCENTER #5247 PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 WW GRAINGER 181.13 1,255.14 WW GRAINGER PC 1281 04/30/2018 Employee Safety Shoe Overage Frank Isola Paid for cost diff (6.00) 1,249.14 GL _______________ Account: 135-65010-010-000 Uniforms Totals: 258.57 1,249.14 ** 4,488.00 Budgeted 3,238.86 Remaining 28 % Used Account: 135-65030-010-000 Chemicals May 15, 2018 Regular Meeting Agenda Packet 99 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1193 04/13/2018 April A/P Testing supplies 8,523.63 46.00 8,569.63 HACH COMPANY 4103 AP 1242 04/24/2018 April A/P CHlorine 663.72 9,233.35 DPC INDUSTRIES, INC 4128 AP 1332 04/30/2018 April A/P Testing supplies 1,498.42 10,731.77 HACH COMPANY 4174 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 2,208.14 10,731.77 ** 20,000.00 Budgeted 9,268.23 Remaining 54 % 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 192.00 .00 192.00 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 192.00 ** 1,000.00 Budgeted 808.00 Remaining 19 % Used Account: 135-65050-010-000 Meter Expense 1258 04/26/2018 April A/P meters 12,400.00 3,691.00 16,091.00 ATLAS UTILITY SUPPLY CO. 4119 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 3,691.00 16,091.00 ** 50,000.00 Budgeted 33,909.00 Remaining 32 % 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 1193 04/13/2018 April A/P Phoenix Drive 307,870.80 50,421.25 358,292.05 Quality Excavation, LTD 4110 AP 1357 04/30/2018 April A/P Water line replacements 7,250.00 365,542.05 TEAGUE, NALL & PERKINS,INC 4189 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 57,671.25 365,542.05 ** 810,012.00 Budgeted 444,469.95 Remaining 45 % Used May 15, 2018 Regular Meeting Agenda Packet 100 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 18 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/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-69008-010-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 .00 ** 38,731.00 Budgeted 38,731.00 Remaining 0 % Used Account: 135-69009-010-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 .00 ** 5,713.00 Budgeted 5,713.00 Remaining 0 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 .00 75,000.00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 107,864.38 .00 107,864.38 _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 107,864.38 ** 118,775.00 Budgeted 10,910.62 Remaining 91 % Used May 15, 2018 Regular Meeting Agenda Packet 101 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 19 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 4/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 1346 04/30/2018 April A/P Water samples 903.89 80.00 983.89 TARRANT CTY PUBLIC HEALTH LAB 4186 AP 1361 04/30/2018 April A/P TCEQ Samples PID 216.19 1,200.08 LOWER COLORADO RIVER AUTHORITY 4180 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 296.19 1,200.08 ** 2,000.00 Budgeted 799.92 Remaining 60 % Used Department 10 Totals: ----------------------------------- 3,196,314.28 ** 1,435,232.00 Monthly Total 5,657,433.00 Budgeted 2,461,118.72 Remaining 56 % Used May 15, 2018 Regular Meeting Agenda Packet 102 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/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 1119 04/06/2018 MUD PR 04.06.18 Salaries & Wages 184,895.51 12,582.12 197,477.63 PR 1212 04/20/2018 MUD PR 04.20.18 Salaries & Wages 12,633.41 210,111.04 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 25,215.53 210,111.04 ** 410,866.00 Budgeted 200,754.96 Remaining 51 % Used Account: 135-50010-020-000 Overtime 1119 04/06/2018 MUD PR 04.06.18 Overtime 15,668.88 2,588.53 18,257.41 PR 1212 04/20/2018 MUD PR 04.20.18 Overtime 1,377.21 19,634.62 PR _______________ Account: 135-50010-020-000 Overtime Totals: 3,965.74 19,634.62 ** 30,000.00 Budgeted 10,365.38 Remaining 65 % 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 1212 04/20/2018 MUD PR 04.20.18 Certification 4,236.00 700.00 4,936.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 700.00 4,936.00 ** 8,400.00 Budgeted 3,464.00 Remaining 59 % Used Account: 135-50020-020-000 Retirement 1119 04/06/2018 MUD PR 04.06.18 Retirement 21,084.11 1,403.29 22,487.40 PR 1212 04/20/2018 MUD PR 04.20.18 Retirement 1,360.74 23,848.14 PR _______________ Account: 135-50020-020-000 Retirement Totals: 2,764.03 23,848.14 ** 42,243.00 Budgeted 18,394.86 Remaining 56 % Used Account: 135-50026-020-000 Medical Insurance 1119 04/06/2018 MUD PR 04.06.18 Medical Insurance 32,455.95 2,759.36 35,215.31 PR 1212 04/20/2018 MUD PR 04.20.18 Medical Insurance 2,759.33 37,974.64 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 5,518.69 37,974.64 ** 62,175.00 Budgeted 24,200.36 Remaining 61 % Used May 15, 2018 Regular Meeting Agenda Packet 103 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/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 1119 04/06/2018 MUD PR 04.06.18 Dental Insurance 2,335.61 177.16 2,512.77 PR 1212 04/20/2018 MUD PR 04.20.18 Dental Insurance 319.52 2,832.29 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 496.68 2,832.29 ** 5,271.00 Budgeted 2,438.71 Remaining 54 % Used Account: 135-50028-020-000 Vision Insurance 1119 04/06/2018 MUD PR 04.06.18 Vision Insurance 449.46 29.46 478.92 PR 1212 04/20/2018 MUD PR 04.20.18 Vision Insurance 29.44 508.36 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 58.90 508.36 ** 1,114.00 Budgeted 605.64 Remaining 46 % Used Account: 135-50029-020-000 Life Insurance & Other 1021 04/01/2018 April A/P Employee Beneifts 2,339.26 192.36 2,531.62 Humana Inc 4015 AP 1060 04/01/2018 April A/P employee ins-STD,Life 135.13 2,666.75 METLIFE GROUP BENEFITS 4066 AP 1242 04/24/2018 April A/P FLex admin fee 37.00 2,703.75 BenefitMall 4121 AP 1258 04/26/2018 April A/P STD & LTD employee benefits 149.71 2,853.46 METLIFE GROUP BENEFITS 4143 AP 1258 04/26/2018 April A/P Employee benefits 136.36 2,989.82 Humana Inc 4133 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 650.56 2,989.82 ** 4,281.00 Budgeted 1,291.18 Remaining 70 % Used Account: 135-50030-020-000 Social Security Taxes 1119 04/06/2018 MUD PR 04.06.18 Social Security Taxes 12,299.70 863.46 13,163.16 PR 1212 04/20/2018 MUD PR 04.20.18 Social Security Taxes 812.90 13,976.06 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,676.36 13,976.06 ** 28,314.00 Budgeted 14,337.94 Remaining 49 % Used Account: 135-50035-020-000 Medicare Taxes 1119 04/06/2018 MUD PR 04.06.18 Medicare Taxes 2,876.53 201.95 3,078.48 PR 1212 04/20/2018 MUD PR 04.20.18 Medicare Taxes 190.11 3,268.59 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 392.06 3,268.59 ** 6,622.00 Budgeted 3,353.41 Remaining 49 % Used Account: 135-50040-020-000 Unemployment Taxes May 15, 2018 Regular Meeting Agenda Packet 104 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1,134.00 .00 1,134.00 _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 1,134.00 ** 1,260.00 Budgeted 126.00 Remaining 90 % Used Account: 135-50045-020-000 Workman's Compensation 238 04/01/2018 Insurance/Wrk Comp Exp Apr 8,088.00 1,348.00 9,436.00 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 1,348.00 9,436.00 ** 17,990.00 Budgeted 8,554.00 Remaining 52 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % 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 1193 04/13/2018 April A/P Belt press and lift stations 26,745.39 1,175.00 27,920.39 DHS AUTOMATION, INC 4100 AP 1193 04/13/2018 April A/P 6" sewer line replacement-1026 6,335.85 34,256.24 REY-MAR CONSTRUCTION 4111 AP 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 THE HOME DEPOT #6581 242.74 34,498.98 THE HOME DEPOT #6581 PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 HOMEDEPOT.COM 398.00 34,896.98 HOMEDEPOT.COM PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 THE HOME DEPOT #6581 476.58 35,373.56 THE HOME DEPOT #6581 PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 FILTER ELEMENT STORE 163.38 35,536.94 FILTER ELEMENT STORE PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 AMAZON.COM 84.76 35,621.70 AMAZON.COM PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 THE HOME DEPOT #6581 66.80 35,688.50 THE HOME DEPOT #6581 PC May 15, 2018 Regular Meeting Agenda Packet 105 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 23 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ROANOKE AUTO SUPPLY LT 26,745.39 61.14 35,749.64 ROANOKE AUTO SUPPLY LT PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 THE HOME DEPOT #6581 20.88 35,770.52 THE HOME DEPOT #6581 PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 THE HOME DEPOT #6581 8.14 35,778.66 THE HOME DEPOT #6581 PC 1258 04/26/2018 April A/P Lift station repairs 716.60 36,495.26 DHS AUTOMATION, INC 4126 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 9,749.87 36,495.26 ** 86,100.00 Budgeted 49,604.74 Remaining 42 % 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 1242 04/24/2018 April A/P Tailgate gasket 4,292.14 504.31 4,796.45 CLS SEWER EQUIPMENT CO., INC 4124 AP 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 DENTON COUNTY, TX SOUT 1.00 4,797.45 DENTON COUNTY, TX SOUT PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 DENTON COUNTY, TX SOUT 30.25 4,827.70 DENTON COUNTY, TX SOUT PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 MUSTANG ELITE CAR 63.91 4,891.61 MUSTANG ELITE CAR PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ROANOKE AUTO SUPPLY LT 8.22 4,899.83 ROANOKE AUTO SUPPLY LT PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 INLAND TRUCK PARTS # 40.00 4,939.83 INLAND TRUCK PARTS # PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ROANOKE AUTO SUPPLY LT 17.51 4,957.34 ROANOKE AUTO SUPPLY LT PC 1332 04/30/2018 April A/P Vac truck repair 1,396.26 6,353.60 CLS SEWER EQUIPMENT CO., INC 4168 AP _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 2,061.46 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 1294 04/30/2018 April A/P Sludge haul off 43,360.77 845.00 44,205.77 L.H. CHANEY MATERIALS, INC. 4153 AP 1332 04/30/2018 April A/P Sludge haul off 1,962.51 46,168.28 L.H. CHANEY MATERIALS, INC. 4179 AP 1332 04/30/2018 April A/P sludge haul off 3,146.36 49,314.64 L.H. CHANEY MATERIALS, INC. 4179 AP 1361 04/30/2018 April A/P Sludge haul off 866.97 50,181.61 L.H. CHANEY MATERIALS, INC. 4179 AP May 15, 2018 Regular Meeting Agenda Packet 106 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 24 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/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-55125-020-000 Dumpster Services Totals: 6,820.84 50,181.61 ** 60,000.00 Budgeted 9,818.39 Remaining 84 % Used Account: 135-55135-020-000 Lab Analysis 1194 04/13/2018 April A/P Lab testing 18,326.82 246.00 18,572.82 OXIDOR LABORATORIES LLC 4109 AP 1194 04/13/2018 April A/P Lab tests 176.00 18,748.82 OXIDOR LABORATORIES LLC 4109 AP 1201 04/16/2018 April A/P CIP chemicals 674.60 19,423.42 Valley Solvent Company, INC 4116 AP 1201 04/16/2018 April A/P Container refund (160.00) 19,263.42 Valley Solvent Company, INC 4116 AP 1258 04/26/2018 April A/P Lab samples 246.00 19,509.42 OXIDOR LABORATORIES LLC 4144 AP 1258 04/26/2018 April A/P lab samples 176.00 19,685.42 OXIDOR LABORATORIES LLC 4144 AP 1258 04/26/2018 April A/P Lab samples 176.00 19,861.42 OXIDOR LABORATORIES LLC 4144 AP 1258 04/26/2018 April A/P lab samples 246.00 20,107.42 OXIDOR LABORATORIES LLC 4144 AP 1294 04/30/2018 April A/P effluent sampling 176.00 20,283.42 OXIDOR LABORATORIES LLC 4154 AP 1294 04/30/2018 April A/P Effluent sampling 246.00 20,529.42 OXIDOR LABORATORIES LLC 4154 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 2,202.60 20,529.42 ** 30,000.00 Budgeted 9,470.58 Remaining 68 % Used Account: 135-60010-020-000 Communications/Mobiles 2,865.72 .00 2,865.72 _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: .00 2,865.72 ** 4,700.00 Budgeted 1,834.28 Remaining 61 % Used Account: 135-60020-020-000 Electricity 1242 04/24/2018 April A/P Electricity 3/9-4/10 86,385.16 12,817.74 99,202.90 HUDSON ENERGY SERVICES, LLC 4134 AP 1329 04/30/2018 Town Billed Invoices 1633-1636 AR 20180430-20180430 User: (156.54) 99,046.36 AR 1357 04/30/2018 April A/P Electricity 3/26-4/24 169.98 99,216.34 TRI COUNTY ELECTRIC 4191 AP 1357 04/30/2018 April A/P Electricity 3/26-4/24 289.90 99,506.24 TRI COUNTY ELECTRIC 4191 AP 1357 04/30/2018 April A/P Electricity 3/26-4/24 27.81 99,534.05 TRI COUNTY ELECTRIC 4191 AP _______________ Account: 135-60020-020-000 Electricity Totals: 13,148.89 99,534.05 ** 266,709.00 Budgeted 167,174.95 Remaining 37 % 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 May 15, 2018 Regular Meeting Agenda Packet 107 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60070-020-000 Dues & Memberships .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 222.00 .00 222.00 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 222.00 ** 5,677.00 Budgeted 5,455.00 Remaining 4 % Used Account: 135-60090-020-000 Safety Program 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 SAFETY POSTER HOLDINGS 8.37 156.65 165.02 SAFETY POSTER HOLDINGS PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 AMAZON.COM 186.70 351.72 AMAZON.COM PC _______________ Account: 135-60090-020-000 Safety Program Totals: 343.35 351.72 ** 550.00 Budgeted 198.28 Remaining 64 % Used Account: 135-60100-020-000 Travel & per diem 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 NTTA CALL CENTER 73.06 17.40 90.46 NTTA CALL CENTER PC _______________ Account: 135-60100-020-000 Travel & per diem Totals: 17.40 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 May 15, 2018 Regular Meeting Agenda Packet 108 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 30,272.52 .00 30,272.52 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 30,272.52 ** 85,000.00 Budgeted 54,727.48 Remaining 36 % Used Account: 135-60245-020-000 Miscellaneous Expenses .01 .00 .01 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .01 ** 450.00 Budgeted 449.99 Remaining 0 % Used Account: 135-60280-020-000 Property Maintenance .00 .00 _______________ Account: 135-60280-020-000 Property Maintenance Totals: .00 .00 ** 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 1294 04/30/2018 April A/P April mowing 2,360.00 1,180.00 3,540.00 WATTS ELLISON LLC 4156 AP _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 1,180.00 3,540.00 ** 11,600.00 Budgeted 8,060.00 Remaining 31 % Used Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S 1305 04/30/2018 Texpool Transfers April 66,568.86 11,094.81 77,663.67 GL _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 11,094.81 77,663.67 ** 122,043.00 Budgeted 44,379.33 Remaining 64 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S 1305 04/30/2018 Texpool Transfers April 326,584.32 54,430.72 381,015.04 GL _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: 54,430.72 381,015.04 ** 598,738.00 Budgeted 217,722.96 Remaining 64 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 1305 04/30/2018 Texpool Transfers April 61,668.00 10,278.00 71,946.00 GL May 15, 2018 Regular Meeting Agenda Packet 109 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/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-60333-020-000 Interfund Transfer Out-Reserve Totals: 10,278.00 71,946.00 ** 123,336.00 Budgeted 51,390.00 Remaining 58 % Used Account: 135-60334-020-000 Interfund Transfer Out .00 .00 _______________ Account: 135-60334-020-000 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 % Used Account: 135-60360-020-000 Furniture/Equipment < $5000 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 PEARCE OFFICE FURNITUR 354.00 354.00 PEARCE OFFICE FURNITUR PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 PEARCE OFFICE FURNITUR 1,408.00 1,762.00 PEARCE OFFICE FURNITUR PC _______________ Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: 1,762.00 1,762.00 ** 4,000.00 Budgeted 2,238.00 Remaining 44 % Used Account: 135-65005-020-000 Fuel & Lube 1258 04/26/2018 April A/P Fuel 4,735.44 604.75 5,340.19 US Bank Voyager Fleet Systems 4147 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 604.75 5,340.19 ** 12,500.00 Budgeted 7,159.81 Remaining 43 % 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 1146 04/05/2018 void due to incorrect amount 4 barrels of MBR chemicals 5,251.35 (684.72) 4,566.63 Valley Solvent Company, INC 4081 AP 1264 04/27/2018 April A/P MBR checmicals 874.60 5,441.23 Valley Solvent Company, INC 4148 AP 1264 04/27/2018 April A/P Container return credit (160.00) 5,281.23 Valley Solvent Company, INC 4148 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 29.88 5,281.23 ** 27,500.00 Budgeted 22,218.77 Remaining 19 % Used Account: 135-65035-020-000 Small Tools May 15, 2018 Regular Meeting Agenda Packet 110 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 28 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 THE HOME DEPOT #6581 1,138.99 10.95 1,149.94 THE HOME DEPOT #6581 PC _______________ Account: 135-65035-020-000 Small Tools Totals: 10.95 1,149.94 ** 1,000.00 Budgeted (149.94) Remaining 115 % Used Account: 135-65040-020-000 Safety Equipment 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 THE HOME DEPOT #6581 586.57 39.91 626.48 THE HOME DEPOT #6581 PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 TX AMERICA SAFETY 124.49 750.97 TX AMERICA SAFETY PC _______________ Account: 135-65040-020-000 Safety Equipment Totals: 164.40 750.97 ** 750.00 Budgeted (.97) Remaining 100 % Used Account: 135-65045-020-000 Lab Supplies 1193 04/13/2018 April A/P Testing supplies 7,839.46 221.81 8,061.27 HACH COMPANY 4103 AP 1242 04/24/2018 April A/P WWTP Quanti-tray sealer Care a 750.00 8,811.27 IDEXX DISTRIBUTION, INC 4135 AP 1242 04/24/2018 April A/P Lab supplies 213.87 9,025.14 HACH COMPANY 4132 AP 1242 04/24/2018 April A/P Lab supplies 1,473.56 10,498.70 IDEXX DISTRIBUTION, INC 4135 AP 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 TOM THUMB #1789 3.96 10,502.66 TOM THUMB #1789 PC 1357 04/30/2018 April A/P Coliform 197.92 10,700.58 IDEXX DISTRIBUTION, INC 4175 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 2,861.12 10,700.58 ** 14,000.00 Budgeted 3,299.42 Remaining 76 % Used Account: 135-69005-020-000 Capital Outlays 1174 04/04/2018 Correct Fund Cap Out- 135-517 309,455.78 (232,136.35) 77,319.43 GL 1193 04/13/2018 April A/P L.S. #2 panel 12,471.18 89,790.61 DHS AUTOMATION, INC 4100 AP 1258 04/26/2018 April A/P Legal WWTP 170.00 89,960.61 Dubois Bryant Campbell LLP 4129 AP _______________ Account: 135-69005-020-000 Capital Outlays Totals: (219,495.17) 89,960.61 ** 547,327.00 Budgeted 457,366.39 Remaining 16 % 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 May 15, 2018 Regular Meeting Agenda Packet 111 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 29 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/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-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,268,309.22 ** (59,947.58) Monthly Total 2,981,140.00 Budgeted 1,712,830.78 Remaining 43 % Used May 15, 2018 Regular Meeting Agenda Packet 112 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 4/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 238 04/01/2018 Insurance/Wrk Comp Exp Apr 14.52 2.42 16.94 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.42 16.94 ** 30.00 Budgeted 13.06 Remaining 56 % 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 1258 04/26/2018 April A/P AWBD conference-Kelly Castongu 405.00 405.00 AWBD 4120 AP 1258 04/26/2018 April A/P AWBD conference-Steve Flynn 405.00 810.00 AWBD 4120 AP _______________ Account: 135-60075-026-000 Meetings Totals: 810.00 810.00 ** 1,200.00 Budgeted 390.00 Remaining 68 % Used Account: 135-60080-026-000 Schools & Training 1178 04/11/2018 April A/P AWBD Annual Conference-Rose 1,135.00 405.00 1,540.00 AWBD 4097 AP _______________ Account: 135-60080-026-000 Schools & Training Totals: 405.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 May 15, 2018 Regular Meeting Agenda Packet 113 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 KELLER TROPHY AND AWAR 1,021.73 233.55 1,255.28 KELLER TROPHY AND AWAR PC _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: 233.55 1,255.28 ** 2,000.00 Budgeted 744.72 Remaining 63 % Used Department 26 Totals: ----------------------------------- 5,232.22 ** 1,450.97 Monthly Total 12,980.00 Budgeted 7,747.78 Remaining 40 % Used May 15, 2018 Regular Meeting Agenda Packet 114 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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 1119 04/06/2018 MUD PR 04.06.18 Salaries & Wages 180,628.41 12,537.06 193,165.47 PR 1212 04/20/2018 MUD PR 04.20.18 Salaries & Wages 21,020.07 214,185.54 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 33,557.13 214,185.54 ** 432,863.00 Budgeted 218,677.46 Remaining 49 % Used Account: 135-50010-030-000 Overtime 1119 04/06/2018 MUD PR 04.06.18 Overtime 456.67 7.66 464.33 PR 1212 04/20/2018 MUD PR 04.20.18 Overtime 2.73 467.06 PR _______________ Account: 135-50010-030-000 Overtime Totals: 10.39 467.06 ** 2,000.00 Budgeted 1,532.94 Remaining 23 % 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 1119 04/06/2018 MUD PR 04.06.18 Retirement 19,385.45 1,160.38 20,545.83 PR 1212 04/20/2018 MUD PR 04.20.18 Retirement 1,944.62 22,490.45 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,105.00 22,490.45 ** 40,553.00 Budgeted 18,062.55 Remaining 55 % Used Account: 135-50026-030-000 Medical Insurance 1119 04/06/2018 MUD PR 04.06.18 Medical Insurance 23,193.21 2,072.63 25,265.84 PR 1212 04/20/2018 MUD PR 04.20.18 Medical Insurance 2,072.61 27,338.45 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,145.24 27,338.45 ** 63,485.00 Budgeted 36,146.55 Remaining 43 % Used Account: 135-50027-030-000 Dental Insurance 1119 04/06/2018 MUD PR 04.06.18 Dental Insurance 1,752.92 129.78 1,882.70 PR 1212 04/20/2018 MUD PR 04.20.18 Dental Insurance 129.74 2,012.44 PR May 15, 2018 Regular Meeting Agenda Packet 115 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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,012.44 ** 5,502.00 Budgeted 3,489.56 Remaining 37 % Used Account: 135-50028-030-000 Vision Insurance 1119 04/06/2018 MUD PR 04.06.18 Vision Insurance 341.41 21.28 362.69 PR 1212 04/20/2018 MUD PR 04.20.18 Vision Insurance 21.23 383.92 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 42.51 383.92 ** 1,173.00 Budgeted 789.08 Remaining 33 % Used Account: 135-50029-030-000 Life Insurance & Other 1021 04/01/2018 April A/P Employee Beneifts 1,920.29 145.04 2,065.33 Humana Inc 4015 AP 1060 04/01/2018 April A/P employee ins-STD,Life 105.65 2,170.98 METLIFE GROUP BENEFITS 4066 AP 1242 04/24/2018 April A/P FLex admin fee 18.50 2,189.48 BenefitMall 4121 AP 1258 04/26/2018 April A/P STD & LTD employee benefits 120.23 2,309.71 METLIFE GROUP BENEFITS 4143 AP 1258 04/26/2018 April A/P Employee benefits 145.04 2,454.75 Humana Inc 4133 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 534.46 2,454.75 ** 5,059.00 Budgeted 2,604.25 Remaining 49 % Used Account: 135-50030-030-000 Social Security Taxes 1119 04/06/2018 MUD PR 04.06.18 Social Security Taxes 10,988.19 739.96 11,728.15 PR 1212 04/20/2018 MUD PR 04.20.18 Social Security Taxes 1,262.76 12,990.91 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,002.72 12,990.91 ** 27,181.00 Budgeted 14,190.09 Remaining 48 % Used Account: 135-50035-030-000 Medicare Taxes 1119 04/06/2018 MUD PR 04.06.18 Medicare Taxes 2,569.81 173.06 2,742.87 PR 1212 04/20/2018 MUD PR 04.20.18 Medicare Taxes 295.32 3,038.19 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 468.38 3,038.19 ** 6,357.00 Budgeted 3,318.81 Remaining 48 % Used Account: 135-50040-030-000 Unemployment Taxes 1119 04/06/2018 MUD PR 04.06.18 Unemployment Taxes 901.90 40.37 942.27 PR 1212 04/20/2018 MUD PR 04.20.18 Unemployment Taxes 41.50 983.77 PR May 15, 2018 Regular Meeting Agenda Packet 116 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 34 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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-030-000 Unemployment Taxes Totals: 81.87 983.77 ** 1,260.00 Budgeted 276.23 Remaining 78 % Used Account: 135-50045-030-000 Workman's Compensation 238 04/01/2018 Insurance/Wrk Comp Exp Apr 741.00 123.50 864.50 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 123.50 864.50 ** 1,529.00 Budgeted 664.50 Remaining 57 % 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 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 KELLER TROPHY AND AWAR 2,348.26 111.00 2,459.26 KELLER TROPHY AND AWAR PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 KELLER TROPHY AND AWAR 60.00 2,519.26 KELLER TROPHY AND AWAR PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 TOM THUMB #1789 112.43 2,631.69 TOM THUMB #1789 PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 KELLER TROPHY AND AWAR 30.00 2,661.69 KELLER TROPHY AND AWAR PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 SAMS CLUB #6781 20.95 2,682.64 SAMS CLUB #6781 PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 WAYFAIR*BIRCHLANE 173.20 2,855.84 WAYFAIR*BIRCHLANE PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 SUCCESSORIES 174.72 3,030.56 SUCCESSORIES PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 AMAZON MKTPLACE PMTS 18.98 3,049.54 AMAZON MKTPLACE PMTS PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 WAYFAIR*BIRCHLANE 59.54 3,109.08 WAYFAIR*BIRCHLANE PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 760.82 3,109.08 ** 4,960.00 Budgeted 1,850.92 Remaining 63 % Used Account: 135-55030-030-000 Software & Support 1126 04/04/2018 April A/P Internet 44,486.55 903.72 45,390.27 Charter Communications 4041 AP 1126 04/04/2018 April A/P check scanner maintenance 425.00 45,815.27 TECHNIQUE DATA SYSTEMS INC 4077 AP 1126 04/04/2018 April A/P Annual license fee 600.00 46,415.27 Data Management Inc. 4044 AP 1178 04/11/2018 April A/P Internet 1,051.94 47,467.21 WHOLESALE CARRIER SERVICES INC 4118 AP 1242 04/24/2018 April A/P Office 365 license 168.00 47,635.21 M3 Networks 4141 AP 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 DNH*GODADDY.COM 239.88 47,875.09 DNH*GODADDY.COM PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 CANVA FOR WORK MONTHLY 12.95 47,888.04 CANVA FOR WORK MONTHLY PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ATT*BILL PAYMENT 63.59 47,951.63 ATT*BILL PAYMENT PC May 15, 2018 Regular Meeting Agenda Packet 117 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 35 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ATT*BILL PAYMENT 44,486.55 85.71 48,037.34 ATT*BILL PAYMENT PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ATT*BILL PAYMENT 49.82 48,087.16 ATT*BILL PAYMENT PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ATT*BILL PAYMENT 102.27 48,189.43 ATT*BILL PAYMENT PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ATT*BILL PAYMENT 118.82 48,308.25 ATT*BILL PAYMENT PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ADOBE SYSTEMS INC 16.23 48,324.48 ADOBE SYSTEMS INC PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ATT*BILL PAYMENT 85.71 48,410.19 ATT*BILL PAYMENT PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ATT*BILL PAYMENT 118.82 48,529.01 ATT*BILL PAYMENT PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ATT*BILL PAYMENT 63.59 48,592.60 ATT*BILL PAYMENT PC 1258 04/26/2018 April A/P Software license 200.00 48,792.60 M3 Networks 4141 AP 1332 04/30/2018 April A/P Firewall hardware & 3 yrs supp 4,614.30 53,406.90 M3 Networks 4181 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 8,920.35 53,406.90 ** 78,391.00 Budgeted 24,984.10 Remaining 68 % Used Account: 135-55070-030-000 Independent Labor 1294 04/30/2018 April A/P GM-April 74,174.76 13,575.00 87,749.76 Carman Consulting LLC. 4151 AP 1294 04/30/2018 April A/P GM-April 26.16 87,775.92 Carman Consulting LLC. 4151 AP 1332 04/30/2018 April A/P April 2018 consulting 46.67 87,822.59 DRG ENTERPRISES 4172 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 13,647.83 87,822.59 ** 154,000.00 Budgeted 66,177.41 Remaining 57 % Used Account: 135-55080-030-000 Maintenance & Repairs 1242 04/24/2018 April A/P A/C work 2,475.73 2,232.00 4,707.73 BRANDON R REED 4122 AP 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 STAPLES 00116533 46.27 4,754.00 STAPLES 00116533 PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 SAMSCLUB #6781 314.51 5,068.51 SAMSCLUB #6781 PC 1275 04/30/2018 April A/P office supplies 42.67 5,111.18 OFFICE DEPOT, INC 4149 AP 1275 04/30/2018 April A/P Office supplies 34.99 5,146.17 OFFICE DEPOT, INC 4149 AP _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: 2,670.44 5,146.17 ** 14,000.00 Budgeted 8,853.83 Remaining 37 % Used Account: 135-55085-030-000 Generator Maint. and Repair 1242 04/24/2018 April A/P Repair to office generator 3,955.00 3,955.00 Sluder Emergency Power Service 4145 AP _______________ Account: 135-55085-030-000 Generator Maint. and Repair Totals: 3,955.00 3,955.00 ** 10,000.00 Budgeted 6,045.00 Remaining 40 % Used Account: 135-55120-030-000 Cleaning Services May 15, 2018 Regular Meeting Agenda Packet 118 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1242 04/24/2018 April A/P Janitorial services 3,962.39 869.06 4,831.45 MEMBER'S BUILDING MAINTENANCE 4142 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 869.06 4,831.45 ** 10,000.00 Budgeted 5,168.55 Remaining 48 % 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 1332 04/30/2018 April A/P April mailings 3,951.79 177.94 4,129.73 DATAPROSE LLC 4171 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 177.94 4,129.73 ** 9,000.00 Budgeted 4,870.27 Remaining 46 % Used Account: 135-60005-030-000 Telephone 1242 04/24/2018 April A/P Answering service 7,417.68 216.80 7,634.48 KEYSTONE PARK SECRETARIAL 4138 AP 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ATT*BILL PAYMENT 190.78 7,825.26 ATT*BILL PAYMENT PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ATT*BUS PHONE PMT 852.62 8,677.88 ATT*BUS PHONE PMT PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ATT*BUS PHONE PMT 851.23 9,529.11 ATT*BUS PHONE PMT PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 RINGCENTRAL, INC 13.96 9,543.07 RINGCENTRAL, INC PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ATT*BILL PAYMENT 191.10 9,734.17 ATT*BILL PAYMENT PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ATT*BUS PHONE PMT 453.37 10,187.54 ATT*BUS PHONE PMT PC 1329 04/30/2018 Town Billed Invoices 1633-1636 AR 20180430-20180430 User: (180.00) 10,007.54 AR _______________ Account: 135-60005-030-000 Telephone Totals: 2,589.86 10,007.54 ** 27,300.00 Budgeted 17,292.46 Remaining 37 % Used Account: 135-60010-030-000 Communications/Mobiles 1212 04/20/2018 MUD PR 04.20.18 Communications/Mobiles 1,649.43 150.00 1,799.43 PR May 15, 2018 Regular Meeting Agenda Packet 119 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 37 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 150.00 1,799.43 ** 4,000.00 Budgeted 2,200.57 Remaining 45 % Used Account: 135-60020-030-000 Electricity/Gas 1332 04/30/2018 April A/P 2/8-3/9/18 Electricity admin 3,106.68 745.53 3,852.21 TOWN OF TROPHY CLUB 4190 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 745.53 3,852.21 ** 16,261.00 Budgeted 12,408.79 Remaining 24 % Used Account: 135-60025-030-000 Water 1294 04/30/2018 April A/P April water 339.12 116.64 455.76 TROPHY CLUB MUD (WATER BILLS) 4155 AP 1329 04/30/2018 Town Billed Invoices 1633-1636 AR 20180430-20180430 User: (58.32) 397.44 AR _______________ Account: 135-60025-030-000 Water Totals: 58.32 397.44 ** 2,500.00 Budgeted 2,102.56 Remaining 16 % Used Account: 135-60030-030-000 Rent And/Or Usage 616.40 .00 616.40 _______________ Account: 135-60030-030-000 Rent And/Or Usage Totals: .00 616.40 ** .00 Budgeted (616.40) Remaining 0 % Used Account: 135-60035-030-000 Postage 1242 04/24/2018 April A/P Postage lease 12,665.27 97.65 12,762.92 FRANCOTYP-POSTALIA, INC. 4131 AP 1258 04/26/2018 April A/P Overnight letter-AWBD 6.53 12,769.45 FEDERAL EXPRESS CORP 4130 AP 1258 04/26/2018 April A/P Overnight letter-Compliance mo 57.50 12,826.95 FEDERAL EXPRESS CORP 4130 AP 1258 04/26/2018 April A/P Overnight letter-Scoop 19.63 12,846.58 FEDERAL EXPRESS CORP 4130 AP 1332 04/30/2018 April A/P April mailings 131.13 12,977.71 DATAPROSE LLC 4171 AP _______________ Account: 135-60035-030-000 Postage Totals: 312.44 12,977.71 ** 30,000.00 Budgeted 17,022.29 Remaining 43 % Used Account: 135-60040-030-000 Service Charges & Fees 1120 04/06/2018 Child Support Fee 29,796.12 1.50 29,797.62 GL 1213 04/20/2018 Child Support Fee 1.50 29,799.12 GL 1248 04/30/2018 Pace Credit Card Fees 4,361.87 34,160.99 GL 1248 04/30/2018 Pace Credit Card Fees 142.23 34,303.22 GL May 15, 2018 Regular Meeting Agenda Packet 120 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1332 04/30/2018 April A/P Direct send fees 29,796.12 50.00 34,353.22 Fiserv Solutions, LLC 4173 AP _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 4,557.10 34,353.22 ** 55,560.00 Budgeted 21,206.78 Remaining 62 % 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 238 04/01/2018 Insurance/Wrk Comp Exp Apr 39,877.16 6,100.36 45,977.52 GL _______________ Account: 135-60055-030-000 Insurance Totals: 6,100.36 45,977.52 ** 56,000.00 Budgeted 10,022.48 Remaining 82 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 AMAZON.COM 206.38 206.38 AMAZON.COM PC _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: 206.38 206.38 ** 1,600.00 Budgeted 1,393.62 Remaining 13 % Used Account: 135-60070-030-000 Dues & Memberships 3,828.42 .00 3,828.42 _______________ 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 48.62 .00 48.62 _______________ Account: 135-60075-030-000 Meetings Totals: .00 48.62 ** 400.00 Budgeted 351.38 Remaining 12 % Used Account: 135-60079-030-000 Public Education .00 .00 May 15, 2018 Regular Meeting Agenda Packet 121 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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-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 1156 04/06/2018 April A/P STW training-Timi & Taylor 2,693.00 450.00 3,143.00 STW INC 4093 AP _______________ Account: 135-60080-030-000 Schools & Training Totals: 450.00 3,143.00 ** 7,600.00 Budgeted 4,457.00 Remaining 41 % Used Account: 135-60100-030-000 Travel & per diem 1119 04/06/2018 MUD PR 04.06.18 Travel & per diem 599.83 111.29 711.12 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 111.29 711.12 ** 4,885.00 Budgeted 4,173.88 Remaining 15 % 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 1332 04/30/2018 April A/P Election notice 145.00 75.00 220.00 Teneo Linquistics Company, LLC 4188 AP _______________ Account: 135-60115-030-000 Elections Totals: 75.00 220.00 ** 4,500.00 Budgeted 4,280.00 Remaining 5 % Used Account: 135-60125-030-000 Advertising 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 YOURMEMBER-CAREERS 150.00 150.00 YOURMEMBER-CAREERS PC _______________ Account: 135-60125-030-000 Advertising Totals: 150.00 150.00 ** 2,500.00 Budgeted 2,350.00 Remaining 6 % Used Account: 135-60235-030-000 Security 1242 04/24/2018 April A/P Monthly monitoring fee for pan 72.00 24.00 96.00 Digital Air Control, Inc 4127 AP May 15, 2018 Regular Meeting Agenda Packet 122 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 40 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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-60235-030-000 Security Totals: 24.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 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 RED WING SHOES #652 137.74 (147.21) (9.47) RED WING SHOES #652 PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 RED WING SHOES #652 147.21 137.74 RED WING SHOES #652 PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 RED WING SHOES #652 135.99 273.73 RED WING SHOES #652 PC _______________ Account: 135-65010-030-000 Uniforms Totals: 135.99 273.73 ** 700.00 Budgeted 426.27 Remaining 39 % Used Account: 135-65055-030-000 Hardware 1178 04/11/2018 April A/P Nicole's computer replacement 597.95 910.99 1,508.94 M3 Networks 4106 AP _______________ Account: 135-65055-030-000 Hardware Totals: 910.99 1,508.94 ** 7,420.00 Budgeted 5,911.06 Remaining 20 % Used Account: 135-65085-030-000 Office Supplies May 15, 2018 Regular Meeting Agenda Packet 123 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 STAPLES DIRECT 2,876.21 59.99 2,936.20 STAPLES DIRECT PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 STAPLES 00116533 56.84 2,993.04 STAPLES 00116533 PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 ZAPCO, INC 87.31 3,080.35 ZAPCO, INC PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 DESKTOP SUPPLIES.COM 71.00 3,151.35 DESKTOP SUPPLIES.COM PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 STAPLES 00116533 18.98 3,170.33 STAPLES 00116533 PC 1275 04/30/2018 April A/P Office supplies 152.07 3,322.40 OFFICE DEPOT, INC 4149 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 446.19 3,322.40 ** 7,000.00 Budgeted 3,677.60 Remaining 47 % 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 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 WALMART.COM 2,822.39 50.22 2,872.61 WALMART.COM PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 AMAZON.COM 65.72 2,938.33 AMAZON.COM PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 SAMSCLUB.COM 46.96 2,985.29 SAMSCLUB.COM PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 AMAZON MKTPLACE PMTS 73.58 3,058.87 AMAZON MKTPLACE PMTS PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 AMAZON MKTPLACE PMTS 35.85 3,094.72 AMAZON MKTPLACE PMTS PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 SAMSCLUB.COM 23.48 3,118.20 SAMSCLUB.COM PC 1327 04/26/2018 Pcard 03/27/18 - 04/26/18 AMAZON MKTPLACE PMTS 67.55 3,185.75 AMAZON MKTPLACE PMTS PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 363.36 3,185.75 ** 4,000.00 Budgeted 814.25 Remaining 80 % 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 Account: 135-69005-030-000 Capital Outlays 1126 04/04/2018 April A/P Security Project 7,841.00 20,986.32 28,827.32 3RD EYE SURVEILLANCE SYSTEMS 4036 AP _______________ Account: 135-69005-030-000 Capital Outlays Totals: 20,986.32 28,827.32 ** 13,000.00 Budgeted (15,827.32) Remaining 222 % Used May 15, 2018 Regular Meeting Agenda Packet 124 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/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-69170-030-000 Copier Lease Installments 1193 04/13/2018 April A/P Copier lease 1,476.14 165.00 1,641.14 EVERBANK COMMERCIAL FINANCE 4101 AP 1242 04/24/2018 April A/P Copies/lease 83.39 1,724.53 KYOCERA DOCUMENT SOLUTIONS 4139 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 248.39 1,724.53 ** 4,600.00 Budgeted 2,875.47 Remaining 37 % Used Department 30 Totals: ----------------------------------- 672,280.18 ** 113,953.68 Monthly Total 1,227,112.00 Budgeted 554,831.82 Remaining 55 % Used May 15, 2018 Regular Meeting Agenda Packet 125 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 43 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 4/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 1358 04/30/2018 April A/P Legal 36,813.55 4,890.00 41,703.55 McLean & Howard, L.L.P. 4182 AP 1358 04/30/2018 April A/P legal 1,050.00 42,753.55 McLean & Howard, L.L.P. 4182 AP _______________ Account: 135-55045-039-000 Legal Totals: 5,940.00 42,753.55 ** 137,000.00 Budgeted 94,246.45 Remaining 31 % Used Account: 135-55055-039-000 Auditing 25,508.70 .00 25,508.70 _______________ Account: 135-55055-039-000 Auditing Totals: .00 25,508.70 ** 24,500.00 Budgeted (1,008.70) Remaining 104 % Used Account: 135-55060-039-000 Appraisal 6,672.05 .00 6,672.05 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 6,672.05 ** 11,446.00 Budgeted 4,773.95 Remaining 58 % 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: ----------------------------------- 77,902.70 ** 5,940.00 Monthly Total 176,746.00 Budgeted 98,843.30 Remaining 44 % Used Fund 135 Totals: ----------------------------------- (191,106.62) (12,209.43) Monthly Total (194,618.00) Budgeted (3,511.38) Remaining 98 % Used May 15, 2018 Regular Meeting Agenda Packet 126 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 44 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 4/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 May 15, 2018 Regular Meeting Agenda Packet 127 of 175 TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET APRIL 2018 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 109,941 ACCOUNTS RECEIVABLE - TOTAL ASSETS 109,941 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 707,654 TOTAL LIABILITIES 707,654 FUND BALANCE ASSIGNED FUND BALANCE 992,579 NET REVENUES / EXPENDITURES (1,590,291) TOTAL FUND BALANCE (597,712) TOTAL LIABILITIES AND FUND BALANCE 109,941 May 15, 2018 Regular Meeting Agenda Packet 128 of 175 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 14 20:48 05/10/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 4/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 487.43- 9,193.27- 9,193.27 Subtotal: 487.43- 9,193.27- 9,193.27 Program number: 487.43- 9,193.27- 9,193.27 Department number: Revenues 487.43- 9,193.27- 9,193.27 Revenues Subtotal ----------- 487.43- 9,193.27- 9,193.27 May 15, 2018 Regular Meeting Agenda Packet 129 of 175 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 15 20:48 05/10/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 4/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-69005-020-000 Capital Outlays 281,432.20 1,599,484.53 1,599,484.53- Subtotal: 281,432.20 1,599,484.53 1,599,484.53- Program number: 281,432.20 1,599,484.53 1,599,484.53- Department number: Wastewater 281,432.20 1,599,484.53 1,599,484.53- Expenditures Subtotal ----------- 281,432.20 1,599,484.53 1,599,484.53- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 280,944.77 1,590,291.26 1,590,291.26- May 15, 2018 Regular Meeting Agenda Packet 130 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 4/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 1304 04/30/2018 Bank Interest- April (8,705.84) (487.43) (9,193.27) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (487.43) (9,193.27) ** .00 Budgeted 9,193.27 Remaining 0 % Used Department Totals: ----------------------------------- (9,193.27) ** (487.43) Monthly Total .00 Budgeted 9,193.27 Remaining 0 % Used May 15, 2018 Regular Meeting Agenda Packet 131 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 4/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-69005-020-000 Capital Outlays 1174 04/04/2018 Correct Fund Cap Out- 135-517 1,318,052.33 232,136.35 1,550,188.68 GL 1201 04/16/2018 April A/P WWTP Improvements 22,090.04 1,572,278.72 CP&Y/WALLACE GROUP, INC. 4099 AP 1265 04/30/2018 Webber App 27 Retainage Update 3,250.38 1,575,529.10 GL 1364 04/30/2018 April A/P WWTP improvements 4/1-4/30 23,955.43 1,599,484.53 CP&Y/WALLACE GROUP, INC. 4170 AP _______________ Account: 517-69005-020-000 Capital Outlays Totals: 281,432.20 1,599,484.53 ** .00 Budgeted (1,599,484.53) Remaining 0 % Used Department 20 Totals: ----------------------------------- 1,599,484.53 ** 281,432.20 Monthly Total .00 Budgeted (1,599,484.53) Remaining 0 % Used Fund 517 Totals: ----------------------------------- 1,590,291.26 280,944.77 Monthly Total .00 Budgeted (1,590,291.26) Remaining 0 % Used May 15, 2018 Regular Meeting Agenda Packet 132 of 175 TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION SWIFT FUNDING BALANCE SHEET APRIL 2018 519 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK 1,053,984 CASH IN ESCROW 749,385 INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS 1,803,369 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 (2,435,369) TOTAL FUND BALANCE 1,790,211 TOTAL LIABILITIES AND FUND BALANCE 1,803,369 May 15, 2018 Regular Meeting Agenda Packet 133 of 175 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 16 20:48 05/10/18 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const-SWIFT Department: Revenues Program: Period Ending: 4/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 519-49010-000-000 Interest Income 49.30- 49.30- 49.30 519-49141-000-000 Interfund Transfer In-Gen Fund 1,053,935.08- 1,053,935.08- 1,053,935.08 Subtotal: 1,053,984.38- 1,053,984.38- 1,053,984.38 Program number: 1,053,984.38- 1,053,984.38- 1,053,984.38 Department number: Revenues 1,053,984.38- 1,053,984.38- 1,053,984.38 Revenues Subtotal ----------- 1,053,984.38- 1,053,984.38- 1,053,984.38 May 15, 2018 Regular Meeting Agenda Packet 134 of 175 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 17 20:48 05/10/18 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const-SWIFT Department: 10 Water Program: Period Ending: 4/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 519-60334-010-000 Interfund Transfer Out 796,145.08 796,145.08 796,145.08- Subtotal: 796,145.08 796,145.08 796,145.08- 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: 796,145.08 3,489,353.76 3,489,353.76- Department number: Water 796,145.08 3,489,353.76 3,489,353.76- Expenditures Subtotal ----------- 796,145.08 3,489,353.76 3,489,353.76- Fund number: 519 2016 Rev Bond Const-SWIFT 257,839.30- 2,435,369.38 2,435,369.38- May 15, 2018 Regular Meeting Agenda Packet 135 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 47 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const-SWIFT Department: Revenues Program: Period Ending: 4/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 1304 04/30/2018 Bank Interest- April (49.30) (49.30) GL _______________ Account: 519-49010-000-000 Interest Income Totals: (49.30) (49.30) ** .00 Budgeted 49.30 Remaining 0 % Used Account: 519-49141-000-000 Interfund Transfer In-Gen Fund 1306 04/30/2018 Swift Fund Deposit TexPool Transfer from Gen to Swift 1,053,935.08 1,053,935.08 GL 1369 04/30/2018 Correcting JE 1306 Swift Cash Reverse JE 1306 (1,053,935.08) .00 GL 1369 04/30/2018 Correcting JE 1306 Swift Cash (1,053,935.08) (1,053,935.08) GL _______________ Account: 519-49141-000-000 Interfund Transfer In-Gen Fund Totals: (1,053,935.08) (1,053,935.08) ** .00 Budgeted 1,053,935.08 Remaining 0 % Used Department Totals: ----------------------------------- (1,053,984.38) ** (1,053,984.38) Monthly Total .00 Budgeted 1,053,984.38 Remaining 0 % Used May 15, 2018 Regular Meeting Agenda Packet 136 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 48 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const-SWIFT Department: 10 Water Program: Period Ending: 4/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 1306 04/30/2018 Swift Fund Deposit TexPool Wire from Escrow to Gen TexPl 796,145.08 796,145.08 GL _______________ Account: 519-60334-010-000 Interfund Transfer Out Totals: 796,145.08 796,145.08 ** .00 Budgeted (796,145.08) Remaining 0 % Used Account: 519-69005-010-000 Capital Outlays 2,693,208.68 .00 2,693,208.68 _______________ Account: 519-69005-010-000 Capital Outlays Totals: .00 2,693,208.68 ** .00 Budgeted (2,693,208.68) Remaining 0 % Used Department 10 Totals: ----------------------------------- 3,489,353.76 ** 796,145.08 Monthly Total .00 Budgeted (3,489,353.76) Remaining 0 % Used Fund 519 Totals: ----------------------------------- 2,435,369.38 (257,839.30) Monthly Total .00 Budgeted (2,435,369.38) Remaining 0 % Used May 15, 2018 Regular Meeting Agenda Packet 137 of 175 TROPHY CLUB MUD #1 - 16" WATERLINE FUTURE REVENUE BOND BALANCE SHEET APRIL 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 May 15, 2018 Regular Meeting Agenda Packet 138 of 175 TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET APRIL 2018 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 530,696 ACCOUNTS RECEIVABLE - TOTAL ASSETS 530,696 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 426,579 NET REVENUES / EXPENDITURES 104,118 TOTAL FUND BALANCE 530,696 TOTAL LIABILITIES AND FUND BALANCE 530,696 May 15, 2018 Regular Meeting Agenda Packet 139 of 175 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 18 20:48 05/10/18 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 4/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- 708.57- 3,590.84- 359.084 2,590.84 528-49142-000-000 Interfund transfer in-Water 48,996.00- 48,996.00- 4,083.00- 28,581.00- 58.333 20,415.00- 528-49143-000-000 Interfund transfer in-WW 123,336.00- 123,336.00- 10,278.00- 71,946.00- 58.333 51,390.00- Subtotal: 173,332.00- 173,332.00- 15,069.57- 104,117.84- 60.068 69,214.16- Program number: 173,332.00- 173,332.00- 15,069.57- 104,117.84- 60.068 69,214.16- Department number: 173,332.00- 173,332.00- 15,069.57- 104,117.84- 60.068 69,214.16- Revenues Subtotal ----------- 173,332.00- 173,332.00- 15,069.57- 104,117.84- 60.068 69,214.16- Fund number: 528 2015 Revenue Bond Reserve Fund 173,332.00- 173,332.00- 15,069.57- 104,117.84- 60.068 69,214.16- May 15, 2018 Regular Meeting Agenda Packet 140 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 4/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 1304 04/30/2018 Bank Interest- April (2,882.27) (708.57) (3,590.84) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (708.57) (3,590.84) ** (1,000.00) Budgeted 2,590.84 Remaining 359 % Used Account: 528-49142-000-000 Interfund transfer in-Water 1305 04/30/2018 Texpool Transfers April (24,498.00) (4,083.00) (28,581.00) GL _______________ Account: 528-49142-000-000 Interfund transfer in-Water Totals: (4,083.00) (28,581.00) ** (48,996.00) Budgeted (20,415.00) Remaining 58 % Used Account: 528-49143-000-000 Interfund transfer in-WW 1305 04/30/2018 Texpool Transfers April (61,668.00) (10,278.00) (71,946.00) GL _______________ Account: 528-49143-000-000 Interfund transfer in-WW Totals: (10,278.00) (71,946.00) ** (123,336.00) Budgeted (51,390.00) Remaining 58 % Used Department Totals: ----------------------------------- (104,117.84) ** (15,069.57) Monthly Total (173,332.00) Budgeted (69,214.16) Remaining 60 % Used Fund 528 Totals: ----------------------------------- (104,117.84) (15,069.57) Monthly Total (173,332.00) Budgeted (69,214.16) Remaining 60 % Used May 15, 2018 Regular Meeting Agenda Packet 141 of 175 TROPHY CLUB MUD #1 - I&S BALANCE SHEET APRIL 2018 INTEREST & SINKING- 533 ASSETS CASH IN BANK 4,573 INVESTMENTS 854,815 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 19,714 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 879,101 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 19,714 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 19,714 FUND BALANCE ASSIGNED FUND BALANCE 32,341 NET REVENUES / EXPENDITURES 827,047 TOTAL FUND BALANCE 859,387 TOTAL LIABILITIES AND FUND BALANCE 879,101 May 15, 2018 Regular Meeting Agenda Packet 142 of 175 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 19 20:48 05/10/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 4/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 669,660.00- 669,660.00- 2,038.30- 666,345.68- 99.505 3,314.32- 533-40002-000-000 Property Taxes/Delinquent 1,800.00- 1,800.00- 303.24- 2,334.05- 129.669 534.05 533-40015-000-000 Property Taxes/P & I 2,000.00- 2,000.00- 179.12- 1,201.02- 60.051 798.98- Subtotal: 673,460.00- 673,460.00- 2,520.66- 669,880.75- 99.469 3,579.25- 533-49010-000-000 Interest Income 2,000.00- 2,000.00- 1,156.06- 3,751.91- 187.596 1,751.91 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- 77,663.67- 63.636 44,379.33- Subtotal: 342,997.00- 342,997.00- 12,250.87- 300,369.58- 87.572 42,627.42- Program number: 1,016,457.00- 1,016,457.00- 14,771.53- 970,250.33- 95.454 46,206.67- Department number: Revenues 1,016,457.00- 1,016,457.00- 14,771.53- 970,250.33- 95.454 46,206.67- Revenues Subtotal ----------- 1,016,457.00- 1,016,457.00- 14,771.53- 970,250.33- 95.454 46,206.67- May 15, 2018 Regular Meeting Agenda Packet 143 of 175 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 20 20:48 05/10/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 4/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,250.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 1,250.00 143,203.75 14.169 867,454.25 Program number: 1,010,658.00 1,010,658.00 1,250.00 143,203.75 14.169 867,454.25 Department number: Administration 1,010,658.00 1,010,658.00 1,250.00 143,203.75 14.169 867,454.25 Expenditures Subtotal ----------- 1,010,658.00 1,010,658.00 1,250.00 143,203.75 14.169 867,454.25 Fund number: 533 MUD 1 I&S Consolidated 5,799.00- 5,799.00- 13,521.53- 827,046.58- ############### 821,247.58 May 15, 2018 Regular Meeting Agenda Packet 144 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 50 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 4/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 1311 04/02/2018 Property Taxes (664,307.38) (844.98) (665,152.36) GL 1312 04/03/2018 Property Taxes (241.13) (665,393.49) GL 1313 04/04/2018 Property Taxes (127.66) (665,521.15) GL 1314 04/05/2018 Property Taxes (222.57) (665,743.72) GL 1315 04/06/2018 Property Taxes (154.94) (665,898.66) GL 1316 04/16/2018 Property Taxes (87.34) (665,986.00) GL 1317 04/18/2018 Property Taxes (40.57) (666,026.57) GL 1318 04/20/2018 Property Taxes 392.67 (665,633.90) GL 1319 04/23/2018 Property Taxes (130.16) (665,764.06) GL 1320 04/24/2018 Property Taxes (114.36) (665,878.42) GL 1321 04/25/2018 Property Taxes (2.67) (665,881.09) GL 1322 04/26/2018 Property Taxes (151.30) (666,032.39) GL 1323 04/27/2018 Property Taxes (120.64) (666,153.03) GL 1324 04/30/2018 Property Taxes (192.65) (666,345.68) GL 1343 04/30/2018 Revs tax shortage Chk4088 Refund Tax Shortage (915.33) (667,261.01) DENTON COUNTY TAX OFFICE 4088 AP 1344 04/30/2018 Property Taxes- 03/23 Shortage 915.33 (666,345.68) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (2,038.30) (666,345.68) ** (669,660.00) Budgeted (3,314.32) Remaining 100 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1311 04/02/2018 Property Taxes (2,030.81) (64.81) (2,095.62) GL 1316 04/16/2018 Property Taxes (81.06) (2,176.68) GL 1319 04/23/2018 Property Taxes (.01) (2,176.69) GL 1321 04/25/2018 Property Taxes (157.36) (2,334.05) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (303.24) (2,334.05) ** (1,800.00) Budgeted 534.05 Remaining 130 % Used Account: 533-40015-000-000 Property Taxes/P & I 1311 04/02/2018 Property Taxes (1,021.90) (58.40) (1,080.30) GL 1312 04/03/2018 Property Taxes (.63) (1,080.93) GL 1313 04/04/2018 Property Taxes (1.27) (1,082.20) GL 1314 04/05/2018 Property Taxes (15.97) (1,098.17) GL 1315 04/06/2018 Property Taxes (9.17) (1,107.34) GL 1316 04/16/2018 Property Taxes (23.64) (1,130.98) GL 1317 04/18/2018 Property Taxes (5.95) (1,136.93) GL 1319 04/23/2018 Property Taxes (14.32) (1,151.25) GL 1320 04/24/2018 Property Taxes (2.67) (1,153.92) GL 1321 04/25/2018 Property Taxes (14.46) (1,168.38) GL May 15, 2018 Regular Meeting Agenda Packet 145 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 51 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 4/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1322 04/26/2018 Property Taxes (1,021.90) (2.42) (1,170.80) GL 1323 04/27/2018 Property Taxes (13.27) (1,184.07) GL 1324 04/30/2018 Property Taxes (16.95) (1,201.02) GL 1343 04/30/2018 Revs tax shortage Chk4088 Refund Tax Shortage .13 (1,200.89) DENTON COUNTY TAX OFFICE 4088 AP 1344 04/30/2018 Property Taxes- 03/23 Shortage (.13) (1,201.02) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (179.12) (1,201.02) ** (2,000.00) Budgeted (798.98) Remaining 60 % Used Account: 533-49010-000-000 Interest Income 1304 04/30/2018 Bank Interest- April (2,595.85) (1,156.06) (3,751.91) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (1,156.06) (3,751.91) ** (2,000.00) Budgeted 1,751.91 Remaining 188 % 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 1305 04/30/2018 Texpool Transfers April (66,568.86) (11,094.81) (77,663.67) GL _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (11,094.81) (77,663.67) ** (122,043.00) Budgeted (44,379.33) Remaining 64 % Used Department Totals: ----------------------------------- (970,250.33) ** (14,771.53) Monthly Total (1,016,457.00) Budgeted (46,206.67) Remaining 95 % Used May 15, 2018 Regular Meeting Agenda Packet 146 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 52 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 4/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 1096 04/04/2018 3/1/18 Bond Paying Agent Fee TCMUD1-10 200.00 750.00 950.00 GL 1096 04/04/2018 3/1/18 Bond Paying Agent Fee TCMUD1-12 500.00 1,450.00 GL _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: 1,250.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 ** 1,250.00 Monthly Total 1,010,658.00 Budgeted 867,454.25 Remaining 14 % Used Fund 533 Totals: ----------------------------------- (827,046.58) (13,521.53) Monthly Total (5,799.00) Budgeted 821,247.58 Remaining ########## May 15, 2018 Regular Meeting Agenda Packet 147 of 175 TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET APRIL 2018 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 286,547 ACCOUNTS RECEIVABLE - TOTAL ASSETS 286,547 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 16,210 NET REVENUES / EXPENDITURES 270,337 TOTAL FUND BALANCE 286,547 TOTAL LIABILITIES AND FUND BALANCE 286,547 May 15, 2018 Regular Meeting Agenda Packet 148 of 175 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 21 20:48 05/10/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 4/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- 320.81- 1,190.90- 119.090 190.90 534-49143-000-000 Interfund Transfer In-WW Sales 598,738.00- 598,738.00- 54,430.72- 381,015.04- 63.636 217,722.96- Subtotal: 599,738.00- 599,738.00- 54,751.53- 382,205.94- 63.729 217,532.06- Program number: 599,738.00- 599,738.00- 54,751.53- 382,205.94- 63.729 217,532.06- Department number: Revenues 599,738.00- 599,738.00- 54,751.53- 382,205.94- 63.729 217,532.06- Revenues Subtotal ----------- 599,738.00- 599,738.00- 54,751.53- 382,205.94- 63.729 217,532.06- May 15, 2018 Regular Meeting Agenda Packet 149 of 175 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 22 20:48 05/10/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 4/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,751.53- 270,337.19- ############### 269,337.19 May 15, 2018 Regular Meeting Agenda Packet 150 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 53 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 4/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 1304 04/30/2018 Bank Interest- April (870.09) (320.81) (1,190.90) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (320.81) (1,190.90) ** (1,000.00) Budgeted 190.90 Remaining 119 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales 1305 04/30/2018 Texpool Transfers April (326,584.32) (54,430.72) (381,015.04) GL _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (54,430.72) (381,015.04) ** (598,738.00) Budgeted (217,722.96) Remaining 64 % Used Department Totals: ----------------------------------- (382,205.94) ** (54,751.53) Monthly Total (599,738.00) Budgeted (217,532.06) Remaining 64 % Used May 15, 2018 Regular Meeting Agenda Packet 151 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 54 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 4/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: ----------------------------------- (270,337.19) (54,751.53) Monthly Total (1,000.00) Budgeted 269,337.19 Remaining ########## May 15, 2018 Regular Meeting Agenda Packet 152 of 175 TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET APRIL 2018 535 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS 146,935 ACCOUNTS RECEIVABLE - TOTAL ASSETS 146,935 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 952 NET REVENUES / EXPENDITURES 145,983 TOTAL FUND BALANCE 146,935 TOTAL LIABILITIES AND FUND BALANCE 146,935 May 15, 2018 Regular Meeting Agenda Packet 153 of 175 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 23 20:48 05/10/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 4/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- 167.99- 562.45- 93.742 37.55- 535-49142-000-000 Interfund Tran In-Water Sales 278,084.00- 278,084.00- 25,280.31- 176,962.17- 63.636 101,121.83- Subtotal: 278,684.00- 278,684.00- 25,448.30- 177,524.62- 63.701 101,159.38- Program number: 278,684.00- 278,684.00- 25,448.30- 177,524.62- 63.701 101,159.38- Department number: Revenues 278,684.00- 278,684.00- 25,448.30- 177,524.62- 63.701 101,159.38- Revenues Subtotal ----------- 278,684.00- 278,684.00- 25,448.30- 177,524.62- 63.701 101,159.38- May 15, 2018 Regular Meeting Agenda Packet 154 of 175 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 24 20:48 05/10/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 4/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,448.30- 145,982.87- ############### 145,382.87 ******* End of Report ********* May 15, 2018 Regular Meeting Agenda Packet 155 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 55 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 4/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 1304 04/30/2018 Bank Interest- April (394.46) (167.99) (562.45) GL _______________ Account: 535-49010-000-000 Interest Income Totals: (167.99) (562.45) ** (600.00) Budgeted (37.55) Remaining 94 % Used Account: 535-49142-000-000 Interfund Tran In-Water Sales 1305 04/30/2018 Texpool Transfers April (151,681.86) (25,280.31) (176,962.17) GL _______________ Account: 535-49142-000-000 Interfund Tran In-Water Sales Totals: (25,280.31) (176,962.17) ** (278,084.00) Budgeted (101,121.83) Remaining 64 % Used Department Totals: ----------------------------------- (177,524.62) ** (25,448.30) Monthly Total (278,684.00) Budgeted (101,159.38) Remaining 64 % Used May 15, 2018 Regular Meeting Agenda Packet 156 of 175 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 56 20:48 05/10/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 4/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: ----------------------------------- (145,982.87) (25,448.30) Monthly Total (600.00) Budgeted 145,382.87 Remaining ########## Grand Totals: --------------------------------------------------------------------------------------------------------- 2,037,565.14 **** (49,812.67) Monthly Total (375,349.00) Budgeted (2,412,914.14) Remaining ########## ******* End of Report ********* May 15, 2018 Regular Meeting Agenda Packet 157 of 175 BUDGET VARIANCE REPORT FUND:122 - Fire O&M FINANCIALS MONTH:April 2018 REVENUE VARIANCE:49.8% EXPENSE VARIANCE:68.1% NOTE: ACCOUNT DESCRIPTION TOTAL BUDGET CURRENT MONTH YTD TOTAL YTD % DATE OF COMMENT VARIANCE EXPLANATION FIRE REVENUES 122-40010 Property Taxes/Fire 1,054,433 3,182 1,049,202 99.50%10/2017 Property Taxes collected 122-40011 Property Taxes/Fire - Delinquent 466 3,567 10/2017 Delinquent Fire Taxes collected 122-40020 Property Taxes/Fire P&I 282 3,415 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 May 15, 2018 Regular Meeting Agenda Packet 158 of 175 BUDGET VARIANCE REPORT FUND:135 - MUD 1 O&M FINANCIALS MONTH:April 2018 REVENUE VARIANCE:49.8% EXPENSE VARIANCE:68.1% NOTE: ACCOUNT DESCRIPTION TOTAL BUDGET CURRENT MONTH YTD TOTAL YTD % DATE OF COMMENT VARIANCE EXPLANATION REVENUE 135-47000-000 Water 6,464,019 415,534 2,640,649 40.85%01/2018 Water Sales 135-47030-000 Service Charges 21,350 1,250 8,450 39.58%01/2018 Service Charges 135-47070-000 TCCC Effluent Charges 60,000 6,338 16,310 27.18%11/2017 TCCC Effluent Collected EXPENSES WATER 135-50040-010 Unemployment Taxes 1,080 78 808 74.85%03/2018 2018 Rate Adj (Increase) 135-60066-010 Publications/Books/Subscripts 1,000 767 767 76.70%04/2018 AWWA Standards Annual 135-60334-010 Interfund Transfer Out 200,000 1,053,935 1,053,935 526.97%04/2018 Escrow Wire to General Fund, General Fund Wire to Swift WASTEWATER 135-50029-020 Life Insurance and Other 4,281 651 2,990 69.84%04/2018 MetLife/Humana May Invoice in April A/P 135-55090-020 Vehicle Maintenance 8,000 2,061 6,354 79.42%04/2018 CLS VAC Truck Repair 135-55125-020 Dumpster Services 60,000 6,821 50,182 83.64%01/2018 L.H. Chaney- Haul offs 135-55135-020 Lab Analysis 30,000 2,203 20,529 68.43%01/2018 Lab 135-65035-020 Small Tools 1,000 11 1,150 114.99%04/2018 Home Depot 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 May 15, 2018 Regular Meeting Agenda Packet 159 of 175 BUDGET VARIANCE REPORT FUND:135 - MUD 1 O&M FINANCIALS MONTH:April 2018 REVENUE VARIANCE:49.8% EXPENSE VARIANCE:68.1% NOTE: ACCOUNT DESCRIPTION TOTAL BUDGET CURRENT MONTH YTD TOTAL YTD % DATE OF COMMENT VARIANCE EXPLANATION Explanation provided for all accounts with a Year-To-Date percentage (YTD%) less than the Revenue Variance and greater than or equal to the Expense Variance. The Revenue and Expense Variance is calculated on a straight-line method (Financials Month x 8.3%), less 8.3% for revenues and plus 10% for expenses. Only accounts with current month activity will be listed 135-65040-020 Safety Equipment 750 164 751 100.13%04/2018 Vest, hardhats, and mask 135-65045-020 Lab Supplies 14,000 2,861 10,701 76.43%04/2018 Lab Supplies- Idexx and Hach BOARD OF DIRECTORS ADMINISTRATION 135-50040-030 Unemployment Taxes 1,260$ 82$ 984$ 78.08%03/2018 2018 Rate Adj (Increase) 135-60055-030 Insurance 56,000$ 6,100$ 45,978$ 82.10%02/2018 TML WC True-Up Adjustment FY17 135-65095-030 Maintenance Supplies 4,000$ 363$ 3,186$ 79.64%03/2018 Office Supplies 135-69005-030 Capital Outlays 13,000$ 20,986$ 28,827$ 221.75%04/2018 Security Captial Outlay FY17 Carryover Non-Departmental May 15, 2018 Regular Meeting Agenda Packet 160 of 175 Trophy Club Municipal Utility District No. 1    Date:    5/15/2018  To:    Board of Directors  From:    John Robert Carman  Subject:  General Manager’s Report    Regulatory Updates:  Sanitary Sewer Overflows (SSO) – No SSOs have been reported since the last Board meeting.  Breaks and Leaks – No breaks or leaks causing system pressure to drop below 20 psi, causing the  reportable incident condition, have occurred since the last Board meeting.  Draft Change Order Policy   The draft change order policy which was tabled last month is attached  for Board review.  Staff anticipates bringing in to the Board for consideration in June.  Draft Procurement Policy   The draft procurement policy which was tabled several months is  attached for Board review.  Staff anticipates bringing in to the Board for consideration in June.  Capital Improvement Projects:   16 Inch Water Line Project Phase 1 – Contracts have been signed on this work are we are working  with Halff to determine when the notice to proceed is issued.  No visible site work has been  observed at the Town Center location by the developer.  WWTP – The contractor has poured the concrete pads on each end of membrane bio reactor  (MBR) process trains 3 and 4.  Preparation for pouring the north part of the plant loop road has  also begun.  Our Fire Chief has been out to ensure they can still provide service to the facility  during the preparation work.  The crane over MBR’s 1&2 has malfunctioned.  We are working  with our Engineer to determine if it was under warranty.  Another potential warranty claim is the  blower on MBR 5 which failed.  Our contractor was helpful in getting this blower back up and  running.   High Service Booster Pump – No updates.  Awaiting documents for rebidding this project  Joint Projects with Town ‐ The water line on Phoenix Drive is complete.  The contractor cannot  move over to begin work on Indian Creek until Phoenix Drive is paved and complete.      May 15, 2018 Regular Meeting Agenda Packet 161 of 175 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 RESOLUTION NO. 2018-0618_ 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 for approval by the project engineer; May 15, 2018 Regular Meeting Agenda Packet 162 of 175 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. President, Board of Directors ATTEST: Secretary, Board of Directors (SEAL) May 15, 2018 Regular Meeting Agenda Packet 163 of 175 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 379,211 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 425,940 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 472400000 2018 MUD 3257 3262 3268 3272 3276 3280 3280 2018 PID 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 May 15, 2018 Regular Meeting Agenda Packet 164 of 175 Influent EffluentInfluent EffluentInfluent Effluent2‐Apr 37.5 0.24 99.4% 297 2.0 99.3% 232 1.0 99.6%3‐Apr 45 0.2 99.6% 223 2.0 99.1% 245 1.0 99.6%      9‐Apr 45 0.2 99.6% 225 2.0 99.1% 225 1.0 99.6%10‐Apr 34.5 0.20 99.4% 209 2.0 99.0% 225 1.0 99.6%   16‐Apr 36 0.20 99.4% 320 2.0 99.4% 270 1.0 99.6%17‐Apr 34.5 0.20 99.4% 222 2.0 99.1% 215 1.0 99.5% 23‐Apr 32 0.23 99.3% 260 2.0 99.2% 255 1.0 99.6%24‐Apr 43.2 0.58 98.7% 246 2.0 99.2% 152 1.0 99.3%99.3%99.2%99.5%April 2018 ResultsAmmonia‐NCBOD5TSS0.262.01.0Ammonia‐NCBOD5TSSDate% Removal% Removal% RemovalReportMay 15, 2018 Regular Meeting Agenda Packet165 of 175 Max mg/L0.49Aver mg/L0.320Max mg/L2.0Aver mg/L2.0Ammonia NitrogenCarbonaceous Biochemical Demand (CBOD5)0.210.3300.4900.25100.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.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 LimitMay 15, 2018 Regular Meeting Agenda Packet166 of 175 Max mg/L1Aver mg/L1.0Max mg/L8.8Aver mg/L6.2Total Suspended Solids (TSS)Nitrate - Nitrogen1.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.70.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 LimitMay 15, 2018 Regular Meeting Agenda Packet167 of 175 Max mg/L5.0Aver mg/L2.8Max mg/L7.4Min mg/L7.2Aver mg/L7.3Potential for Hydrogen (pH)E. Coli1.04.01.05.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.47.47.30.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 MaxMay 15, 2018 Regular Meeting Agenda Packet168 of 175 Max mg/L7.8Aver mg/L7.7 Dissolved Oxygen (DO)7.87.57.87.60.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 LimitMay 15, 2018 Regular Meeting Agenda Packet169 of 175 May 15, 2018 Regular Meeting Agenda Packet 170 of 175 May 15, 2018 Regular Meeting Agenda Packet 171 of 175 October November December January February March April May June July August September ebills 796 828 829 834 839 844 841 Bills Mailed 3906 3900 3912 3911 3908 3913 3921 Bank Draft 631 623 639 653 657 656 655 Credit Card Draft 1018 1020 1026 1033 1042 1056 1054 Online Payments 1037 1079 1,072 1,065 1,086 1,097 1,019 Late Notices 391 420 457 362 424 407 299 Disconnects 25 27 27 25 22 27 24 M 3257 3262 3268 3272 3276 3280 3280 Connections P 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 May 15, 2018 Regular Meeting Agenda Packet 172 of 175 MUD Permits Month: April 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 Total -$ -$ -$ -$ -$ -$ -$ -$ May 15, 2018 Regular Meeting Agenda Packet 173 of 175 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 $714,929 $714,929 135-10250 TexPool O & M (XXXXX0002)-General Fund Operating ***$0 $1,748,273 $1,748,273 135-10300 Prosperity Bank (XXX8701) General Fund Operating *$315,605 $586,953 $902,558 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 $109,941 $0 $109,941 519-10250 Texpool Revenue Bond Construction (XXXXX015) SWIFT **$0 $1,053,984 $1,053,984 519-11155 Cash-Bond Escrow Bank of Texas (SWIFT)$749,385 $0 $749,385 528-10250 TexPool Revenue Bond Reserve (XXXXX014) WWTP Improvements $530,696 $0 $530,696 533-10250 TexPool Tax I & S (XXXXX0003)$854,815 $0 $854,815 533-10300 Prosperity Bank (XXX8701) Tax I&S $4,573 $0 $4,573 534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements $286,547 $0 $286,547 535-10250 Texpool Revenue I & S (XXXXX017) SWIFT $146,935 $0 $146,935 $4,412,216 $4,104,739 $8,516,954 Amount available in cash (MUD Accounts)$4,104,739 Amount available for spending (MUD Accounts)$4,104,739 * 04/30/18 Customer Water Deposits $315,605 122-10250 TexPool O & M (XXXXX0002)-Fire Operating Cash $0 $778,987 $778,987 122-10300 Prosperity Bank (XXX8701) Fire Operating $0 $0 $0 $0 $778,987 $778,987 Amount available in cash (Fire Department Accounts)$778,987 Amount available for spending (Fire Department Accounts)$778,987 714,929$ Bank of the West MM 586,953$ Prosperity General Fund 1,748,273$ Texpool General Fund 600$ Petty Cash Total General Fund 135 Available for Spending 3,050,754$ ** Funds in Swift Unrestricted- Reimbursement for General Fund 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 191,107$ Total Nonspendable, Assigned & Committed Fund Balances - General Fund 135 $4,341,475 General Fund 135 Available General Fund 135 Fund Balances Fire Department Cash CASH STATUS AS OF APRIL 2018 Restricted - Unable to be spent Unrestricted- Available for spending Total in Accounts (Restricted & Unrestricted) May 15, 2018 Regular Meeting Agenda Packet 174 of 175 May 6 - Jun 30, 2018 Printed on: 05/11/2018 2:05pm Powered by Sun Mon Tue Wed Thu Fri Sat 19 20 21 22 23 24 25 26 May 6, 2018 7 8 9 10 11 12 1pm Medlin Cemetery Association 9am EMS Training (Shane Beck  10:30am Parks/Rec/Streets/Fac  9am EMS Training (Shane Beck 9am EMS Training (Shane Beck 9am Trophy Club Women's Club (A 13 14 15 16 17 18 19 6am Republican Primary Run-Off 10:30am Parks/Rec/Streets/Fac  7am Republican Primary Run-Off 6pm Trophy Club Municipal Util  6pm Lakes of Trophy Club HOA  6am Republican Primary Run-Off 6am Republican Primary Run-Off 6am Republican Primary Run-Off 20 21 22 23 24 25 26 10:30am Parks/Rec/Streets/Fac Republican Primary Run-Off Elect 6pm Highlands @TC HOA (Ginny 10am Special Events Committe  27 28 29 30 31 Jun 1 2 10:30am Parks/Rec/Streets/Fac  3 4 5 6 7 8 9 10:30am Parks/Rec/Streets/Fac 7am FD Ofcers Meeting (Hurd  7pm Trophy Club Womens Club  8:30am Keep Trophy Club Wild 10 11 12 13 14 15 16 9am EMS Training (Shane Beck  10:30am Parks/Rec/Streets/Fac  9am EMS Training (Shane Beck 9am EMS Training (Shane Beck  17 18 19 20 21 22 23 10:30am Parks/Rec/Streets/Fac 6pm Trophy Club Municipal Util  6pm Lakes of Trophy Club HOA  24 25 26 27 28 29 30 10:30am Parks/Rec/Streets/Fac 10am Special Events Committe  TC Meeting Spaces ModierMay 15, 2018 Regular Meeting Agenda Packet 175 of 175