Loading...
HomeMy WebLinkAbout2018-04 April 17 2018 Regular Meeting agenda Packet      BOARD OF DIRECTORS  REGULAR MEETING    TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1  100 MUNICIPAL DRIVE  TROPHY CLUB, TEXAS 76262    April 17, 2018                                                               6:00 P.M.                                    Svore Municipal Boardroom   MEETING AGENDA    CALL TO ORDER AND ANNOUNCE A QUORUM    CITIZEN COMMENTS  This is an opportunity for citizens to address the Board on any matter whether or not it is posted on the agenda.  The Board is not permitted to take action on or discuss any presentations made to the Board at this time  concerning an item not listed on the agenda. The Board will hear presentations on specific agenda items prior  to the Board addressing those items. You may speak up to three (3) minutes or the time limit determined by  the President or presiding officer.    CONSENT AGENDA  All matters listed as Consent Agenda are considered to be routine by the Board of Directors and will be  enacted by one motion. There will not be a separate discussion of these items. If discussion is desired, that  item will be removed from the consent agenda and will be considered separately.    1. Consider and take appropriate action to approve the Consent Agenda.   a. Quarterly Investment Reports – 2nd quarter  b. Tax Collections   c. March 2018 Check Register  d. March 20, 2018 Regular Meeting Minutes          Attachments:   Quarterly Investment Reports – 2nd quarter  Tax Collections – 2nd quarter  March 2018 Check Register  March 20, 2018 Regular Meeting Minutes    REGULAR SESSION  2. Presentation of service awards to Directors Carr, Hase and Thomas by General Manager John Carman.    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)    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.  Attachments:   Amendment No. 1  April 17, 2018 Regular Meeting Agenda Packet 1 of 202     Alignment “B” Project Cost Estimate   Waterline Alignment     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.  Attachment:  Letter of recommendation   6. Consider and take appropriate action regarding adoption of Resolution No. 2018‐0418A Authorizing the  General Manager to Approve Construction Contract Change Orders.     Attachment:  Resolution No. 2018‐0418A    7. Discussion and possible action regarding revision of water and sewer rates for governmental customers.  (Carr)  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.    Attachment:  Order No. 2017‐0919F Bylaws    9. Consider and take appropriate action regarding the March 2018 Combined Financials and Variance  Report.   a. Combined Financials   b. Combined Variance     Attachments:  March Financials       March Variance Report    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  April 17, 2018 Regular Meeting Agenda Packet 2 of 202   f. Water System Operation  g. Wastewater System Operation  h. Website Analytics  i. Finance Update   Utility Billing Report   Permits Collected   Cash Report    Attachments:  General Manager Report                Water Operation Report                Wastewater Operation Report                Website Analytics                Utility Billing Report                Permits Collected                Cash Report    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:    13. Items for future agendas:    14. Set future Meeting dates ‐ Regular Board Meeting on May 15, 2018 at 6:30 p.m.    Attachment:  May meeting calendar    *THE BOARD RESERVES THE RIGHT TO ADJOURN INTO EXECUTIVE SESSION AT ANY TIME DURING THE  MEETING PURSUANT TO THE APPLICABLE SECTION OF SUBCHAPTER D, CHAPTER 551, TEXAS GOVERNMENT  CODE, THE TEXAS OPEN MEETINGS ACT, WITH RESPECT TO ANY ITEM ON THE AGENDA.  NO FINAL ACTION,  DECISION OR VOTE WILL BE TAKEN ON ANY SUBJECT OR MATTER IN CLOSED SESSION.  THIS NOTICE MODIFIES  THE DISTRICT'S PRIOR PRACTICE OF SPECIFICALLY IDENTIFYING ALL AGENDA ITEMS TO BE DISCUSSED IN  CLOSED SESSION.    ADJOURN    THE STATE OF TEXAS §   COUNTIES OF DENTON AND TARRANT  §    April 17, 2018 Regular Meeting Agenda Packet 3 of 202   THIS NOTICE CERTIFIES THAT BY 6:00 P.M. ON FRIDAY, APRIL 13, 2018, THE MEETING AGENDA OF TROPHY  CLUB MUNICIPAL UTILITY DISTRICT NO. 1, BOARD OF DIRECTORS REGULAR MEETING TO BE HELD ON  TUESDAY, APRIL 17, 2018 AT 6:00 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                April 17, 2018 Regular Meeting Agenda Packet 4 of 202 April 17, 2018 Regular Meeting Agenda Packet5 of 202 April 17, 2018 Regular Meeting Agenda Packet 6 of 202 April 17, 2018 Regular Meeting Agenda Packet 7 of 202 April 17, 2018 Regular Meeting Agenda Packet 8 of 202 April 17, 2018 Regular Meeting Agenda Packet 9 of 202 April 17, 2018 Regular Meeting Agenda Packet 10 of 202 April 17, 2018 Regular Meeting Agenda Packet11 of 202 April 17, 2018 Regular Meeting Agenda Packet12 of 202 April 17, 2018 Regular Meeting Agenda Packet13 of 202 April 17, 2018 Regular Meeting Agenda Packet14 of 202 April 17, 2018 Regular Meeting Agenda Packet15 of 202 April 17, 2018 Regular Meeting Agenda Packet16 of 202 April 17, 2018 Regular Meeting Agenda Packet17 of 202 April 17, 2018 Regular Meeting Agenda Packet18 of 202 April 17, 2018 Regular Meeting Agenda Packet19 of 202 April 17, 2018 Regular Meeting Agenda Packet20 of 202 April 17, 2018 Regular Meeting Agenda Packet21 of 202 April 17, 2018 Regular Meeting Agenda Packet22 of 202 April 17, 2018 Regular Meeting Agenda Packet23 of 202 April 17, 2018 Regular Meeting Agenda Packet24 of 202 April 17, 2018 Regular Meeting Agenda Packet25 of 202 April 17, 2018 Regular Meeting Agenda Packet26 of 202 April 17, 2018 Regular Meeting Agenda Packet 27 of 202 April 17, 2018 Regular Meeting Agenda Packet 28 of 202 April 17, 2018 Regular Meeting Agenda Packet 29 of 202 April 17, 2018 Regular Meeting Agenda Packet 30 of 202 April 17, 2018 Regular Meeting Agenda Packet 31 of 202     REGULAR MEETING MINUTES   TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1  BOARD OF DIRECTORS   March 20, 2018 at 6:30 P.M.  100 Municipal Drive, Trophy Club, Texas 76262    Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in a  Regular Session on Tuesday, March 20, 2018 at 6:30 P.M., in the Boardroom of the Administration  Building, 100 Municipal Drive, Trophy Club, Texas 76262. The meeting was held within the boundaries of  the District, and was open to the public.   STATE OF TEXAS                              §  COUNTIES OF DENTON AND TARRANT           §   BOARD MEMBERS PRESENT:  Kevin R. Carr  President  Gregory Wilson  Vice President  William C. Rose  Secretary/Treasurer  Jim Thomas  Director  Jim Hase  Director    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 March 20, 2018, called the meeting to order and announced a  quorum present at 6:31 p.m.     CITIZEN COMMENTS  Robert Gilliam    116 Oakmont Dr.  Veronica Bowornsak     1 Greenhill Trail    1.   Consider and take appropriate action to approve the Consent Agenda.   a.   February 2018 Check Register  b.   February 20, 2018 Regular Meeting Minutes      Motion made by Director Wilson and seconded by Director Carr to approve the Consent Agenda as  presented.    Motion carried unanimously    REGULAR SESSION  2.    Discussion and possible action regarding results of Winter Average Analysis completed by NewGen  April 17, 2018 Regular Meeting Agenda Packet 32 of 202     Strategies & Solutions.    General Manager John Carman presented the Winter Average Analysis by NewGen Strategies &  Solutions as they were unable to have a representative at the meeting.         Motion made by Director Carr and seconded by Director Hase to maintain the current Residential Sewer  Rates and increase the Commercial Sewer Volumetric Rate from $5.48 to $5.92.     For: Carr, Hase and Thomas  Opposed: Rose and Wilson    Motion Passed 3‐2    Motion made by Director Rose and seconded by Director Thomas to amend Rate Order No. 2017‐0917A  by adopting Rate Order No. 2018‐0320C and updating Article 2, Section 2.02 to state an effective date  of April 1, 2018 with no change to Item A. Residential Sewer Rate and updating Item B. Commercial  Sewer Rates to show and effective date of April 1, 2018 with a change to the volumetric rate from $5.48  to $5.92 per 1,000 gallons.      For: Carr, Hase, Rose and Thomas  Oppose: Wilson    Motion Passed 4‐1      3. Consider and take appropriate action to  adopt order declaring the following vehicles as  surplus  property of the District and authorizing staff to dispose of such vehicles:  a.    Truck No. 200 ‐ 2013 Chevrolet extended cab pick‐up truck with 102,929 miles purchased March  6, 2013  b.    Truck No. 201 ‐ 2013 Chevrolet 1500 pick‐up truck with 127,272 miles purchased March 6, 2013      Motion made by Director Hase and seconded by Director Wilson to adopt order declaring Truck No. 200  a 2013 Chevrolet extended cab pick‐up truck and Truck No. 201 a 2013 Chevrolet 1500 pick‐up truck as  surplus property of the District and authorize staff to dispose of properly.    Motion carried unanimously      4. Consider and take appropriate action relating to cancellation of May 5, 2018 Director Election:  a.    Accept Certification of Unopposed Candidates.  Aceptar certificatiόn de candidatos únicos.   b.   Adopt Order Canceling Election.  Adoptar una Orden de cancelación.      April 17, 2018 Regular Meeting Agenda Packet 33 of 202     Motion  made  by  Director  Wilson  and  seconded  by  Director  Thomas to  accept  the  Certificate  of  Unopposed Candidates and adopt Order No. 2018‐0320A Canceling the May 5, 2018 Director Election.    Motion carried unanimously      5. Consider and take appropriate action regarding adoption of Resolution No. 2018‐0320A Authorizing  the General Manager to Approve Construction Contract Change Orders.    Motion made by Director that Resolution No. 2018‐0320A be modified to give the General Manager  authority to approve change orders up to the amount of the contingency or 10% whichever is less and  any time changes related to weather on any contract signed by the District.      Director Wilson modified his motion to add the General Manager and engineer must agree on the  cost and to have Attorney Corbett bring back a modified resolution for the board to approve at a  future meeting that includes these changes.      Motion died for lack of a second      6.    Consider and  take appropriate action regarding Order  No. 2018‐0320B Authorizing the  General  Manager to approve certain expenditures, sign disbursements and enter into contracts on behalf of  the District and containing other matters relating thereto.      General Manager John Carman stated that comments had been received from a Director that had not  yet been reviewed and he request this item be tabled and brought back at a future meeting.       7.    Consider and take appropriate action regarding tree replacement options related to the construction  of Waterline Improvement Project for Indian Creek Drive and Phoenix Drive.    Resident Veronica Bowornsak who resides at 1 Greenhill Trail stated that she is working with an  arborist and would like to be notified as to when the construction will begin.  Staff will speak to the  Town engineer and make sure that she is informed.  Construction is not expected to begin on that  street until September ‐ October.       Motion made by Director Rose and seconded by Director Hase to replace the 2 (two) trees in discussion,  the large oak tree which has been removed off Phoenix Drive and the large Bradford Pear tree off Indian  Creek Drive and that those tree replacements be made one inch inside of the District’s easement for an  amount not to exceed $500.00 per tree.     For: Hase, Rose, Thomas  Opposed: Carr, Wilson    Motion Passed 3‐2      April 17, 2018 Regular Meeting Agenda Packet 34 of 202     8.   Consider and take appropriate action regarding the February 2018 Combined Financials and Variance  Report.  a.    Combined Financials   b.   Combined Variance     Motion  made  by  Director  Rose  and  seconded  by  Director  Thomas  to  approve  the  February  2018  Combined Financials and Variance Report.    Motion carried unanimously      REPORTS & UPDATES  9.    Receive update regarding Association of Water Board Directors 2018 Mid‐Winter Conference.  (Carr, Rose, Thomas)    Director Carr, Director Rose and Director Thomas each shared highlights of sessions they attended  at the 2018 AWBD Mid‐Winter Conference.        10.   General Manager Monthly Reports and Update:  a. Regulatory Update  b. Class and Compensation Study Update  c. Capital Improvement Projects:   16‐inch waterline project to serve Town Center   Wastewater Treatment Plant Upgrade Project   High Service Pump   Joint Projects with Town   d. Water System Operation  e. Wastewater System Operation  f. Website Analytics   g. Finance Update:   Utility Billing Report   Permits Collected   Cash Report    General Manager John Carman presented his monthly update to the board and answered questions  related thereto.      The Board recessed from 8:23 p.m. until 8:30 p.m.    The Board Convened into Executive Session at 8:30 p.m.    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:  April 17, 2018 Regular Meeting Agenda Packet 35 of 202     a.    Seek Legal advice and opinion regarding lease agreement for District owned property located at  100 Municipal Drive and 1501 Junction Way. (Carr) **    12.  Deliberations  pursuant  to  Section  551.076  of  the  Texas  Open  Meetings  Act  regarding  the  deployment of security devices at the Wastewater Treatment Plant. (Carr)    The Board reconvened into Regular Session at 8:47 p.m.    REGULAR SESSION  13. Consider and take appropriate action on matters deliberated in Executive Session:    Director Carr provided direction to the General Manager to speak with the Town Manager regarding  the lease agreements.     14. Items for future agendas:      Director Carr would like to discuss agenda preparation and packet materials.    Director Wilson requested to have Agenda Item No. 5 brought forward for further discussion by the  Board.  With no one opposed, Director Carr brought the item forward.     5.  Consider and take appropriate action regarding adoption of Resolution No. 2018‐0320A    Authorizing   the General Manager to Approve Construction Contract Change Orders.    Motion made by Director Wilson and seconded by Director Rose that the Resolution be brought back to  state that the General Manager is authorized to make changes to a contract up to 10% or the amount of  the contingency whichever is less which means it cannot exceed the total amount budgeted additionally  it will allow the General Manager to approve any time delay change orders related to weather as long as  it does not succeed the cost of the previous one the 10% or the amount of the contingency, whichever  amount is less.      For: Rose, Wilson  Opposed: Carr, Hase, and Thomas    Motion Failed 3‐2    Motion made by Director Carr and seconded by Director Wilson to bring Resolution 2018‐0320A back to  the April meeting with language proposed by Director Wilson in his preceding motion for the board to  review and approve, and to authorize Director Wilson to work directly with the General Manager and  Attorney Corbett as needed to make the said changes to the Resolution.      Motion carried unanimously      15. Set future Meeting dates ‐ Regular Board Meeting on April 17, 2018 at 6:30 p.m.    ADJOURN    April 17, 2018 Regular Meeting Agenda Packet 36 of 202     Motion made by Director Rose and seconded by Director Wilson to adjourn the March 20, 2018  meeting.     Motion carried unanimously      Director Carr adjourned the March 20, 2018 regular meeting at 9:03 p.m.    __________________________________  Kevin R. Carr, President    __________________________________                                                            (SEAL)  William C. Rose, Secretary/Treasurer      __________________________________  Laurie Slaght, District Secretary  April 17, 2018 Regular Meeting Agenda Packet 37 of 202 March 22, 2018 AVO 33344 Mr. John Carman Trophy Club MUD No. 1 100 Municipal Drive Trophy Club, Texas 76262 RE: Amendment No. 1 – Water Line Interconnect from Pump Station to Eastern Storage Tank Project No. 33344 Dear Mr. Carman: On Tuesday, January 16th, Halff Associates presented the results of the Water Line Interconnect Alignment Study to the Trophy Club Municipal Utility District No. 1 Board. The Board voted to approve Alignment “B” which follows the north side of SH 114. This alignment requires more existing utility location and easement acquisition than originally anticipated. Included in Amendment No. 1 is the additional Subsurface Utility Engineering (SUE) and Right-of-Way Acquisition effort necessary to complete Phase II of the Interconnect design. The Scope of Work the original contract shall include the following amendments: • The following scope shall be added to TASK 5 “Subsurface Utility Engineering (SUE)” of PHASE B “Surveying Phase”: Halff will perform SUE in accordance with ASCE CI/ASCE 38-02 “Standard Guideline for the Collection and Depiction of Existing Subsurface Utility Data.” This standard defines the following Quality Levels: Quality Level-A: Precise horizontal and vertical location of utilities obtained by the actual exposure (or verification of previously exposed and surveyed utilities) and subsequent measurement of subsurface utilities, usually at a specific point. Minimally intrusive excavation equipment is typically used to minimize the potential for utility damage. A precise horizontal and vertical location, as well as other utility attributes, is shown on plan documents. Quality Level-B: Information obtained through the application of appropriate surface geophysical methods to determine the existence and approximate horizontal position of subsurface utilities. Quality Level-B data should be reproducible by surface geophysics at any point of their depiction. This information is surveyed to applicable tolerances defined by the project and reduced onto plan documents. April 17, 2018 Regular Meeting Agenda Packet 38 of 202 Mr. Carman Trophy Club Municipal Utility District No. 1 March 22, 2018 Page 2 Quality Level-C: Information obtained by surveying and plotting visible above-ground utility features and by using professional judgment in correlating this information to Quality Level- D information. Quality Level-D: Information derived from existing records or oral recollections. Quality Level-A Utility Test Holes (Vacuum Excavation): Up to four (4) additional test holes will be performed on various utilities at locations specified by TC MUD No. 1 and/or Halff’s Design Engineer. Halff will cut up to a 12” square test hole, excavate down to utility, record the depth to top of utility, backfill & compact the hole, and restore the surface to its original condition. An iron rod with cap or “x-cut” will be set to mark the approximate centerline location of the utility. A jackhammer will be utilized for work to be performed in asphalt and concrete areas. Quality Level-B Utility Designating: Halff will designate the approximate horizontal position of conductive/toneable utilities within the project limits using geophysical prospecting equipment and mark using paint and/or pin flags. We anticipate the designation of approximately 25,000 linear feet of utilities including buried communication, electric, natural gas, petroleum pipeline, traffic signal, water, waste water/sanitary sewer, and storm drain/storm sewer. Designation of irrigation lines, HDPE lines, gathering lines, asbestos concrete and/or pvc lines, as well as pvc lines without tracer wire or access are not part of this Scope of Services. Because of limited utility record information and the possibility of non-conductive/un- toneable utilities, Halff cannot guarantee all utilities will be found and marked within the project limits. Quality Level-C Surveying: Quality Level-B Utility Designation paint markings, pin flags, and above ground utility appurtenances as well the iron rod with cap or “x-cut” for Quality Level-A Test Holes will be surveyed and tied utilizing project survey control provided by others. Quality Level-D Records Research: Available Records will be provided to Halff by Trophy Club MUD No. 1. Halff will perform additional utility record research as needed to successfully complete the project. Because there are situations where the utility does not have a metallic composition; a metallic tracer line attached; access to insert a tracer line within it, the approximate location of the utility may be determined through the use of utility records and direct correspondence with the utility owner/representative. In these areas, the information will be considered Quality Level-D, depicted according to utility record information only. April 17, 2018 Regular Meeting Agenda Packet 39 of 202 Mr. Carman Trophy Club Municipal Utility District No. 1 March 22, 2018 Page 3 SUE Field Manager / Professional Engineer: A SUE Field Manager will be on-site for a portion of this project for field crew supervision, field quality control, and coordination with on-site personnel. A Professional Engineer will be responsible for QA/QC, management of the contract, coordination with the project team and signing the final deliverables if required. SUE Deliverables / CADD: Electronic files depicting the results of the Quality Level-B Utility Designating investigation and the Quality Level-A Test Hole Data Forms will be provided in MicroStation and/or AutoCAD format along with PDFs and photos. Right-of-Entry: If Right-of-Entry is required, it will be performed and provided to Halff by Trophy Club MUD No. 1. Halff will coordinate with property owner(s) once right of entry has been obtained. Permitting: Street Cut permits will be coordinated with the Town of Trophy Club as required. Work Zone Traffic Control: Halff will provide standard temporary work zone traffic control consisting of cones and free- standing signage for this project. This Scope of Services does not include lane closure(s), flag person(s), changeable message board(s), arrow board(s) and/or engineered traffic control plans. If an engineered traffic control plan is required for permit approval or if unique traffic control conditions exist, Halff will notify Trophy Club MUD No. 1 and submit a supplemental agreement for authorization prior to proceeding with additional work. Schedule: Halff will complete the Quality Level-B Utility Designation investigation within Thirty (30) days upon receipt of written notice to proceed and Right-of-Entry, if required, from Trophy Club MUD No. 1. Halff will complete the Quality Level-A Test Hole services within Thirty (30) days upon receipt of the test hole layout from Trophy Club MUD No. 1 and approved permits from the Town of Trophy Club. Due to uncontrollable factors such as ground conditions, weather, and safety hazards, Halff reserves the right to request more time to facilitate field efforts should one of these circumstances exist. Work performed in the Right-of-Way shall be performed Monday through Friday, 9 am to 4 pm and Saturday and Sunday, 7 am to 7 pm barring foul weather. April 17, 2018 Regular Meeting Agenda Packet 40 of 202 Mr. Carman Trophy Club Municipal Utility District No. 1 March 22, 2018 Page 4 • The following scope shall be added to PHASE E “Right-of-Way Acquisition: Halff will prepare right-of-way and easement metes and bounds exhibits (field sketches) for the project. This amendment includes Three (3) additional right-of-way\easement metes and bound exhibits (field sketches) for the Water Line Interconnect Project. Below is the scope of work for preparing right-of-way metes and bounds sketches. See Attachment ‘A2’ of the original contract for detailed scope of work for right-of-way acquisition services. Halff will be responsible for right-of-way negotiation and acquisition. TCMUD will be responsible for title\closing work and filing documents with the County. 1. Field Survey – Locate existing property monuments necessary to determine existing right- of-way and parcels adjacent to right-of-way. 2. Office Survey – Resolve property documents, deeds, and plats necessary to determine existing right-of-way and parcels adjacent to right-of-way. 3. Field Sketches – A survey field sketch will be prepared for each right-of-way or easement taking. Three (3) additional easement taking is included in this contract. 4. R.O.W. Monuments – Set right-of-way monuments upon finalizing survey field sketches. 5. Right-of-Way Acquisition Coordination – Halff to coordinate with property owners. 6. Initial Appraisal Services – Halff to coordinate with appraisers. 7. Title and Closing Services – Halff to coordinate with title company, but TCMUD will pay title work and closing costs. 8. Negotiation Services – Halff to negotiate with property owners. A summary of the proposed fee for Amendment No. 1 is as follows: SURVEYING (PHASE 2 TASK) $35,095 RIGHT-OF-WAY ACQUISITION (PHASE 2 TASK) $45,408 TOTAL PROPOSED AMENDMENT NO. 1 $80,503 Following is the project fee summary: ORIGINAL CONTRACT PHASE 2 $314,750 AMENDMENT NO. 1 $80,503 REVISED PHASE 2 CONTRACT AMOUNT $395,253 PHASE 1 TOTAL $36,365 REVISED PHASE 2 TOTAL $395,253 PHASE 3 TOTAL $150,650 REVISED TOTAL FEE (PHASES 1-3) $582,268 April 17, 2018 Regular Meeting Agenda Packet 41 of 202 Mr. Carman Trophy Club Municipal Utility District No. 1 March 22, 2018 Page 5 Halff Associates is performing the services above under the terms and conditions described in the Agreement for Professional Engineering Services for Water Line Interconnect from Pump Station to Eastern Storage Tank, dated November 2, 2017, between Halff Associates and the Trophy Club Municipal Utility District No. 1. Halff Associates will bill the above described services under AVO 33344. Submitted: Approved: HALFF ASSOCIATES, INC. TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 By: ______________________________ By: _______________________________ Signature Signature Brian Haynes ________________________________ Printed Name Printed Name Vice President ________________________________ Title Title March 22, 2018 ________________________________ Date Date April 17, 2018 Regular Meeting Agenda Packet 42 of 202 APPENDIX B Project:Interconnect Prepared by:LMH Client:TCMUD No.1 Date:1/11/2018 UNIT PRICE EXTENDED PRICE 1 Mobilization (5% Max)LS 1 $164,000.00 $164,000.00 2 General Site Preparation STA 93 $1,500.00 $139,500.00 3 Construction Staking LS 1 $25,000.00 $25,000.00 4 Project Signs EA 2 $750.00 $1,500.00 5 12-Inch Waterline (C-900) (Open Cut)LF 390 $60.00 $23,400.00 6 14-Inch Waterline (C-900) (Open Cut)LF 920 $75.00 $69,000.00 7 16-Inch Waterline (C-900) (Open Cut)LF 750 $100.00 $75,000.00 8 18-Inch Waterline (C-900) (Open Cut)LF 2,370 $175.00 $414,750.00 9 Trench Safety LF 4,430 $3.00 $13,290.00 10 16-Inch Waterline (C-900) (Other than Open Cut)LF 100 $125.00 $12,500.00 11 18-Inch Waterline (C-900) (Other than Open Cut)LF 130 $250.00 $32,500.00 12 30-Inch OD x 1/2 Thick Steel Casing Pipe (Bore)LF 230 $300.00 $69,000.00 13 16-Inch Waterline (HDPE) (Directional Drill)LF 4,250 $475.00 $2,018,750.00 14 18-Inch Waterline (HDPE) (Directional Drill)LF 330 $575.00 $189,750.00 15 12-Inch Gate Valve EA 2 $2,000.00 $4,000.00 16 14-Inch Gate Valve EA 3 $5,000.00 $15,000.00 17 16-Inch Butterfly Valve EA 8 $12,500.00 $100,000.00 18 18-Inch Butterfly Valve EA 3 $15,000.00 $45,000.00 19 Blow-Off Valve (6")EA 3 $10,000.00 $30,000.00 20 Combination Air Release Valve and Meter Box (2-Inch)EA 3 $7,500.00 $22,500.00 21 Connect to Existing Water Line (12-Inch to 18-Inch)EA 2 $8,000.00 $16,000.00 22 Sodding SY 7,390 $4.00 $29,560.00 23 Topsoil (4-Inches)SY 7,390 $2.00 $14,780.00 24 Silt Fence LF 4,430 $3.00 $13,290.00 25 Traffic Control LS 1 $50,000.00 $50,000.00 Subtotal Section I $3,588,100 SUBTOTAL CONSTRUCTION $3,588,100 CONTINGENCY (20%)$717,620 TOTAL CONSTRUCTION $4,305,720 BASIC ENGINEERNIG SERVICES (SURVEYING AND ENGINEERING DESIGN)$322,405 SUB-SURFACE UTILITY EXCAVATION SERVICES $15,000 RIGHT-OF-WAY ACQUISTION SERVICES (3 PARCELS)$50,000 CONSTRUCTION INSPECTION SERVICES $103,680 PROPERTY OWNER COMPENSATION FOR EASEMENTS $25,500 CONSTRUCTION MATERIAL TESTING (2.5%)$89,703 ISSUANCE COSTS $420,000 PROJECT TOTAL COST $5,332,008 ENGINEER'S STATEMENT OF PROBABLE COST TROPHY CLUB MUD No.1 ALIGNMENT B From HSPS to EST - Along SH 114 North NOTE: This statement was prepared utilizing standard cost and/or estimating practices. It is understood and agreed that this is a statement of probable construction cost only, and the Engineer shall not be liable to the Owner or any Third Party for any failure to accurately estimate the cost and/or quantities for the project, or any part thereof. ITEM NO.DESCRIPTION UNIT QTY Engineer's Estimate Section I - Water Line Waterline Interconnect_Probable Cost (1-11-2018) HALFF ASSOCIATES, INC. 4000 Fossil Creek Boulevard Fort Worth, Texas 76137 (817) 817-1422 1 of 1 1/15/2018 April 17, 2018 Regular Meeting Agenda Packet 43 of 202 April 17, 2018 Regular Meeting Agenda Packet44 of 202 April 9, 2018 AVO 32127 Mr. John Carman Trophy Club MUD No. 1 100 Municipal Drive Trophy Club, Texas 76262 RE: 16-Inch Off-Site Water Line – Letter of Recommendation Dear Mr. Carman, Bids were opened for the above referenced project on Friday, April 6, 2018 at 2:00 p.m. at the Trophy Club MUD No. 1. Eleven (11) bids were received for the project. Halff Associates has verified the bid tabulations and the overall low bidder is La Banda, LLC. Please see summary of the 16-Inch Off-Site Water Line bids below. The low bidder and bid amount is highlighted below. 16-Inch Off-Site Water Line Bid Summary Contractor Base Bid La Banda, LLC $188,625 Canary Construction, Inc $215,643 BCG Construction, Inc $216,750 Quality Excavation, LTD $228,662 North Texas Contracting $244,999 ANA Site Construction, LLC $260,691 Excel Trenching $312,287 Micam Development, LLC $312,884.15 Rey-Mar Construction $319,944 Blue Star Utilities, LLC $326,430 HD Cooks Rock Solid, Inc $331,854 La Banda’s bid bonds, qualifications, and experience are attached to this letter. Halff Associates, Inc. (Halff) contacted the provided references and we received the following responses: 1. City of Duncanville – Jon Bonner: No answer 2. City of Dallas – Demetrio Saenz: Good recommendation. Mr. Saenz said they are “very capable”. They are currently working on a $2 million utility project for the City, including water, sewer and storm drain line. They have also done an alley paving job for the City. 3. City of Corsicana – Bobby Bland: Good recommendation. Mr. Bland has worked with them on two projects, a water line project and a culvert replacement. He said they are “excellent to April 17, 2018 Regular Meeting Agenda Packet 45 of 202 John Carman Trophy Club MUD No. 1 April 9, 2018 Page 2 work with”. While his experience was on a 6-inch diameter line, he is confident in their ability to install larger diameter lines as well. Halff recommends awarding the 16-Inch Off-Site Water Line project to La Banda, LLC in the amount of $188,625. If you have any questions, please contact me at (817) 847-1422. Sincerely, HALFF ASSOCIATES, INC. Leah M. Hodge, PE, CFM Project Manager April 17, 2018 Regular Meeting Agenda Packet 46 of 202 ITEM NO.QTY UNIT PRICE EXTENDED PRICE UNIT PRICE EXTENDED PRICE UNIT PRICE EXTENDED PRICE UNIT PRICE EXTENDED PRICE UNIT PRICE EXTENDED PRICE EXTENDED PRICE UNIT PRICE EXTENDED PRICE UNIT PRICE EXTENDED PRICE UNIT PRICE EXTENDED PRICE UNIT PRICE EXTENDED PRICE 1 1 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $20,650.00 $20,650.00 $22,035.00 $22,035.00 $7,500.00 $7,500.00 $25,455.00 $25,000.00 $23,751.23 $25,800.00 $25,800.00 $30,660.00 $30,660.00 $10,500.00 $10,500.00 2 1 $1,500.00 $1,500.00 $2,500.00 $2,500.00 $1,800.00 $1,800.00 $1,208.00 $1,208.00 $1,500.00 $1,500.00 $1,500.00 $4,500.00 $10,532.33 $5,500.00 $5,500.00 $1,913.00 $1,913.00 $2,075.00 $2,075.00 3 1 $400.00 $400.00 $690.00 $690.00 $425.00 $425.00 $980.00 $980.00 $500.00 $500.00 $1,200.00 $1,000.00 $1,187.56 $600.00 $600.00 $1,332.00 $1,332.00 $975.00 $975.00 4 1 $2,500.00 $2,500.00 $1,560.00 $1,560.00 $1,210.00 $1,210.00 $956.00 $956.00 $3,000.00 $3,000.00 $4,800.00 $7,500.00 $15,830.19 $2,200.00 $2,200.00 $3,216.00 $3,216.00 $2,750.00 $2,750.00 5 1 $3,000.00 $3,000.00 $6,400.00 $6,400.00 $21,724.00 $21,724.00 $7,696.00 $7,696.00 $15,000.00 $15,000.00 $15,000.00 $25,000.00 $15,592.44 $7,000.00 $7,000.00 $16,625.00 $16,625.00 $17,000.00 $17,000.00 6 650 $70.00 $45,500.00 $93.00 $60,450.00 $93.00 $60,450.00 $96.44 $62,686.00 $150.00 $97,500.00 $61,750.00 $125.00 $81,932.50 $97.00 $63,050.00 $148.00 $96,200.00 $173.00 $112,450.00 7 100 $350.00 $35,000.00 $390.00 $39,000.00 $431.00 $43,100.00 $465.00 $46,500.00 $530.00 $53,000.00 $50,000.00 $300.00 $71,591.00 $778.00 $77,800.00 $583.00 $58,300.00 $605.00 $60,500.00 8 100 $120.00 $12,000.00 $60.00 $6,000.00 $60.00 $6,000.00 $66.64 $6,664.00 $100.00 $10,000.00 $6,100.00 $145.00 $5,810.00 $95.00 $9,500.00 $95.00 $9,500.00 $105.00 $10,500.00 9 120 $10.00 $1,200.00 $30.00 $3,600.00 $13.00 $1,560.00 $4.00 $480.00 $20.00 $2,400.00 $3,000.00 $4.00 $2,283.60 $30.00 $3,600.00 $24.00 $2,880.00 $15.00 $1,800.00 10 650 $1.00 $650.00 $1.00 $650.00 $1.00 $650.00 $1.40 $910.00 $1.00 $650.00 $650.00 $8.00 $2,067.00 $18.00 $11,700.00 $3.00 $1,950.00 $21.00 $13,650.00 11 3 $11,500.00 $34,500.00 $9,500.00 $28,500.00 $6,078.00 $18,234.00 $7,257.00 $21,771.00 $8,000.00 $24,000.00 $35,925.00 $8,500.00 $17,299.05 $7,600.00 $22,800.00 $8,153.00 $24,459.00 $9,500.00 $28,500.00 12 1 $5,000.00 $5,000.00 $19,500.00 $19,500.00 $8,175.00 $8,175.00 $20,680.00 $20,680.00 $7,000.00 $7,000.00 $23,865.00 $19,000.00 $20,623.13 $27,000.00 $27,000.00 $21,636.00 $21,636.00 $20,000.00 $20,000.00 13 165 $70.00 $11,550.00 $110.00 $18,150.00 $58.00 $9,570.00 $104.20 $17,193.00 $70.00 $11,550.00 $11,550.00 $85.00 $15,288.90 $130.00 $21,450.00 $135.00 $22,275.00 $94.00 $15,510.00 14 183 $11.00 $2,013.00 $25.00 $4,575.00 $29.00 $5,307.00 $13.00 $2,379.00 $15.00 $2,745.00 $4,026.00 $200.00 $2,631.54 $40.00 $7,320.00 $76.00 $13,908.00 $47.00 $8,601.00 15 72 $70.00 $5,040.00 $55.00 $3,960.00 $53.00 $3,816.00 $49.00 $3,528.00 $50.00 $3,600.00 $5,040.00 $55.00 $5,901.12 $160.00 $11,520.00 $59.00 $4,248.00 $160.00 $11,520.00 16 1444 $6.00 $8,664.00 $5.00 $7,220.00 $4.50 $6,498.00 $6.75 $9,747.00 $3.00 $4,332.00 $5,054.00 $5.50 $13,270.36 $10.00 $14,440.00 $7.00 $10,108.00 $8.50 $12,274.00 17 1444 $7.00 $10,108.00 $2.00 $2,888.00 $5.25 $7,581.00 $2.25 $3,249.00 $0.50 $722.00 $5,776.00 $7.50 $7,292.20 $6.00 $8,664.00 $5.00 $7,220.00 $2.25 $3,249.00 $188,625.00 $215,643.00 $216,750.00 $228,662.00 $244,999.00 $260,691.00 $312,884.15 $319,944.00 $326,430.00 $331,854.00 Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No Yes Yes Yes Yes Yes Yes No Yes No Yes Yes Yes Yes Yes Yes No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes $312,287.00 Yes Yes $3.50 $7,942.00 $9.19 $4.00 $10,830.00 $5.05 $70.00 $14,025.00 $92.66 $22.00 $36,600.00 $14.38 $70.00 $3,960.00 $81.96 $1.00 $5,200.00 $3.18 $11,975.00 $25,500.00 $5,766.35 $23,865.00 $19,000.00 $20,623.13 $500.00 $30,000.00 $715.91 $61.00 $14,500.00 $58.10 $25.00 $480.00 $19.03 $4,800.00 $7,500.00 $15,830.19 $15,000.00 $25,000.00 $15,592.44 $95.00 $81,250.00 $126.05 $25,455.00 $25,000.00 $23,751.23 $1,500.00 $4,500.00 $10,532.33 $1,200.00 $1,000.00 $1,187.56 UNIT PRICE EXTENDED PRICE UNIT PRICE 10100 Horseshoe Nail Dr Pilot Point, TX 76258 Rockwall, TX 75078 Weatherford, TX 76086 Fort Worth, TX 76119 Mansfield, TX 76063 1226 W. Park Ave.3416 Reed Street 103 W. Broad St.519 E I-30 #328 ANA Site Construction, LLC Micam Development, LLC Rey-Mar Construction Blue Star Utilites, LLC HD Cooks Rock Solid, Inc.Excel Trenching Leah Hodge, PE, CFM 664 Manor Dr.PO Box 468 Keller, TX 76244Aubrey, TX 76227 Argyle, TX 76226 La Banda, LLC Dallas, TX 75217 Haslet, TX 76052 4/9/2018 BID TOTAL Bid Bond 16-INCH OFF-SITE WATER LINE BID TABULATION Addendum No. 2 Addendum No. 3 Corrected Value Topsoil SY Addendum No. 1 Connect to Existing 16-Inch Water Line EA 6-Inch Concrete Pavement SY 6-Inch Flexible Base SY 4-Inch Concrete Sidewalk SY Sodding SY 30-Inch Steel Casing Pipe by Other Than Open Cut LF 16-Inch PVC C900 Water Line Carrier Pipe LF 2-Inch PVC Schedule 80 Conduit LF Trench Safety LF 16-Inch Gate Valve EA Traffic Control LS Project Signs EA Storm Water Pollution Prevention Plan (SWPPP) LS General Site Preparation LS 16-Inch PVC C900 Water Line by Open Cut LF DESCRIPTION UNIT Section I - General Mobilization (10% Maximum of Total Bid) LS 523 Neomi Avenue 802 N Kealy Ave., Ste. 101 808 Schoolhouse Rd, Ste. 113 5580 US Highway 377 Lewisville, TX 75057 Canary Construction, Inc BCG Construction, Inc.Quality Excavation LTD North Texas Contracting TROPHY CLUB MUNICIPAL UTILITY DISTRICT No. 1 BID OPENING: APRIL 6, 2018, 2:00 P.M. April 17, 2018 Regular Meeting Agenda Packet 47 of 202 April 17, 2018 Regular Meeting Agenda Packet 48 of 202 April 17, 2018 Regular Meeting Agenda Packet 49 of 202 April 17, 2018 Regular Meeting Agenda Packet 50 of 202 April 17, 2018 Regular Meeting Agenda Packet 51 of 202 April 17, 2018 Regular Meeting Agenda Packet 52 of 202 April 17, 2018 Regular Meeting Agenda Packet 53 of 202 April 17, 2018 Regular Meeting Agenda Packet 54 of 202 April 17, 2018 Regular Meeting Agenda Packet 55 of 202 April 17, 2018 Regular Meeting Agenda Packet 56 of 202 April 17, 2018 Regular Meeting Agenda Packet 57 of 202 April 17, 2018 Regular Meeting Agenda Packet 58 of 202 April 17, 2018 Regular Meeting Agenda Packet 59 of 202 April 17, 2018 Regular Meeting Agenda Packet 60 of 202 April 17, 2018 Regular Meeting Agenda Packet 61 of 202 April 17, 2018 Regular Meeting Agenda Packet 62 of 202 April 17, 2018 Regular Meeting Agenda Packet 63 of 202 April 17, 2018 Regular Meeting Agenda Packet 64 of 202 April 17, 2018 Regular Meeting Agenda Packet 65 of 202 April 17, 2018 Regular Meeting Agenda Packet 66 of 202 April 17, 2018 Regular Meeting Agenda Packet 67 of 202 April 17, 2018 Regular Meeting Agenda Packet 68 of 202 April 17, 2018 Regular Meeting Agenda Packet 69 of 202 April 17, 2018 Regular Meeting Agenda Packet 70 of 202 April 17, 2018 Regular Meeting Agenda Packet 71 of 202 April 17, 2018 Regular Meeting Agenda Packet 72 of 202 April 17, 2018 Regular Meeting Agenda Packet 73 of 202 April 17, 2018 Regular Meeting Agenda Packet 74 of 202 April 17, 2018 Regular Meeting Agenda Packet 75 of 202 April 17, 2018 Regular Meeting Agenda Packet 76 of 202 April 17, 2018 Regular Meeting Agenda Packet 77 of 202 April 17, 2018 Regular Meeting Agenda Packet 78 of 202 April 17, 2018 Regular Meeting Agenda Packet 79 of 202 April 17, 2018 Regular Meeting Agenda Packet 80 of 202 April 17, 2018 Regular Meeting Agenda Packet 81 of 202 April 17, 2018 Regular Meeting Agenda Packet 82 of 202 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 RESOLUTION NO. 2018-0418A 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; e. The General Manager’s authority shall be exercised only when necessary to prevent project April 17, 2018 Regular Meeting Agenda Packet 83 of 202 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. PASSED AND APPROVED this the 17th day of April 2018. Kevin R. Carr, President Board of Directors ATTEST: William C. Rose, Secretary (SEAL) Board of Directors April 17, 2018 Regular Meeting Agenda Packet 84 of 202 ORDER NO. 2017-0919F Order No. 2017-0919F Bylaws of the Board of Directors AN ORDER OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO.1, ADOPTING BYLAWS: ORGANIZATION, PROCEDURES, TRAVEL EXPENDITURE POLICY, PROFESSIONAL SERVICES POLICY, MANAGEMENT INFORMATION POLICY AND CODE OF ETHICS WHEREAS, Trophy Club Municipal Utility District No. 1 (the "District") is a conservation and reclamation district of the State of Texas created and operating pursuant to Chapters 49 and 54 of the Texas Water Code; and WHEREAS, Section 49.199, Texas Water Code, requires the Board of Directors of the District to adopt, in relevant part: (i) a code of ethics for the District's directors, officers, employees, and persons who are engaged in handling investments for the District; (ii) a policy relating to travel expenditures; (iii) policies and procedures for selection, monitoring or review and evaluation of professional services; and (iv) policies that ensure a better use of management information; and 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, in accordance with the foregoing statutory provisions, on July 21, 2015, the Board of Directors adopted Order 2015-0721 B, thereby approving a code of ethics, a travel expense policy, policies and procedures for the seiection and review of professional services, policies concerning the use of management information, and the formation of an audit committee; and WHEREAS, on April 4, 2016, the District adopted Order 2016-0419 approving an Agenda Policy; and WHEREAS, the Board of Directors now desires to adopt Bylaws in accordance with the authority set forth at Section 49.057(g) of the Texas Water Code and an updated a Code of Ethics for the District's directors, officers, employees, and persons who are engaged in handling investments for the District; a policy relating to travel expenditures; policies and procedures for selection, monitoring or review and evaluation of professional services; and policies that ensure a better use of management information. NOW, THEREFORE, BE IT ORDERED BY THE BOARD OF DIRECTORS OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT N0.1 THAT: SECTION 1. The facts and recitations in the preamble of this Order are hereby found and declared to be true and correct, and are incorporated by reference herein and expressly made a part hereof, as if copied verbatim. SECTION 2. The Board of Directors of the District hereby adopts the Bylaws, Organizational Policies and Code of Ethics (collectively, the "Policies") in the form attached hereto. SECTION 3. ofthis Order. The attached Policies shall become effective immediately upon adoption 1 of 15 Adopted on September 19, 2017 April 17, 2018 Regular Meeting Agenda Packet 85 of 202 Order No. 2017-0919F Bylaws of the Board of Directors BYLAWS TABLE OF CONTENTS ARTICLE I ARTICLE II ARTICLE III ARTICLE IV ARTICLE V ARTICLE VI ARTICLE VII ARTICLE VIII ARTICLE IX Organization, Powers and Office Board of Directors Officers of the Board Administrative Services Meetings and Agenda Fees ofTravel Expense Policy Professional Services Policy Management Policy Code of Ethics 3 of 15 Adopted on September 19, 2017 April 17, 2018 Regular Meeting Agenda Packet 86 of 202 Definitions Order No. 2017-0919F Bylaws of the Board of Directors 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 ofthe Texas Local Government Code. TWC. The term "TWC" shall mean the Texas Water Code. 4 of 15 Adopted on September 19, 2017 April 17, 2018 Regular Meeting Agenda Packet 87 of 202 ARTICLE I ORGANIZATION, POWERS AND OFFICE Order No. 2017-0919F Bylaws of the Board of Directors 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 a!! 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. 5 of 15 Adopted on September 19, 2017 April 17, 2018 Regular Meeting Agenda Packet 88 of 202 Order No. 2017-0919F Bylaws of the Board of Directors 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 at the regular meeting of the Board in June. 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 ofthe 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. 6 of 15 Adopted on September 19, 2017 April 17, 2018 Regular Meeting Agenda Packet 89 of 202 ARTICLE IV ADMINISTRATIVE SERVICES Order No. 2017-0919F Bylaws of the Board of Directors 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; 7 of 15 Adopted on September 19, 2017 April 17, 2018 Regular Meeting Agenda Packet 90 of 202 Order No. 2017-0919F Bylaws of the Board of Directors 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; 0. 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. 8 of 15 Adopted on September 19, 2017 April 17, 2018 Regular Meeting Agenda Packet 91 of 202 Order No. 2017-0919F Bylaws of the Board of Directors Section 4.08 Duties ofthe 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. ARTICLEV 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 Tuesday of every month at 6:30P.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 business as may be required between Regular monthly meetings. 9 of 15 Adopted on September 19, 2017 April 17, 2018 Regular Meeting Agenda Packet 92 of 202 Order No. 2017-0919F Bylaws of the Board of Directors 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 ca!led 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 Meetin!!s. 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 shall be drafted and approved by the General Manager. 10 of 15 Adopted on September 19, 2017 April 17, 2018 Regular Meeting Agenda Packet 93 of 202 Order No. 2017-0919F Bylaws of the Board of Directors 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. I 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 I 00% oft he actual total cost of reimbursable items. 11 of 15 Adopted on September 19, 2017 April 17, 2018 Regular Meeting Agenda Packet 94 of 202 Order No. 2017-0919F Bylaws of the Board of Directors 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, iegai, 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. 12 of 15 Adopted on September 19, 2017 April 17, 2018 Regular Meeting Agenda Packet 95 of 202 Order No. 2017-0919F Bylaws of the Board of Directors 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 conduct, 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 majority of the Board of Directors is required to abstain from participation in a vote because of conflict 13 of 15 Adopted on September 19. 2017 April 17, 2018 Regular Meeting Agenda Packet 96 of 202 Order No. 2017-0919F Bylaws of the Board of Directors 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 (1 0%) 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 (1 0%) 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 property. Directors shall not use public resources unavailable to the public, such as District staff time, 14 of 15 Adopted on September 19, 2017 April 17, 2018 Regular Meeting Agenda Packet 97 of 202 Order No. 2017-0919F Bylaws of the Board of Directors 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 shali 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. 15 of 15 Adopted on September 19, 2017 April 17, 2018 Regular Meeting Agenda Packet 98 of 202 Order No. 2017-0919F Bylaws of the Board of Directors SECTION 4. This Order and the attached Policies shall supersede all other policies adopted by the Board of Directors with respect to the subject matter hereof including, without limitation, the policies, procedures and code of ethics adopted pursuant to Order 2015-0721 B and adopted Order 20 16-0419. SECTION 5. The Vice President and Secretary of the Board are hereby authorized and directed to execute this Order. After execution, an original Order shall be filed in the permanent records of the District. ADOPTED, PASSED AND APPROVED this )~~day of Jp±fCY\\:tV , 2017. 1 liam c. Rose, Board of Directors 2 of 15 Grego w,· s n, Vice President Board of Directors Adopted September 19, 2017 April 17, 2018 Regular Meeting Agenda Packet 99 of 202 TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET MARCH 2018 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 827,240 PREPAID EXPENSES 7,619 ADVALOREM PROPERTY TAXES RECEIVABLE 38,879 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE - TOTAL ASSETS 873,739 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 38,879 ACCOUNTS AND OTHER PAYABLES 1,441 TOTAL LIABILITIES 40,320 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 522,253 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 311,167 TOTAL FUND BALANCE 833,420 TOTAL LIABILITIES AND FUND BALANCE 873,739 April 17, 2018 Regular Meeting Agenda Packet 100 of 202 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 1 23:00 04/11/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 3/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- 14,274.19- 1,046,020.27- 99.202 8,412.73- 122-40011-000-000 Property Taxes/Fire-Delinquent 226.63- 3,100.91- 3,100.91 122-40020-000-000 Property Taxes/Fire P&I 728.64- 3,132.75- 3,132.75 Subtotal: 1,054,433.00- 1,054,433.00- 15,229.46- 1,052,253.93- 99.793 2,179.07- Program number: 1,054,433.00- 1,054,433.00- 15,229.46- 1,052,253.93- 99.793 2,179.07- Department number: Fire Revenues 1,054,433.00- 1,054,433.00- 15,229.46- 1,052,253.93- 99.793 2,179.07- Revenues Subtotal ----------- 1,054,433.00- 1,054,433.00- 15,229.46- 1,052,253.93- 99.793 2,179.07- April 17, 2018 Regular Meeting Agenda Packet 101 of 202 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 2 23:00 04/11/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/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 7,619.22 42.329 10,380.78 122-60337-045-000 Transfer to Town/Fire Budget 608,910.00 608,910.00 50,742.50 304,455.00 50.000 304,455.00 Subtotal: 845,864.00 845,864.00 52,012.37 531,028.22 62.779 314,835.78 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 741,087.31 70.283 313,345.69 Department number: Fire 1,054,433.00 1,054,433.00 52,012.37 741,087.31 70.283 313,345.69 Expenditures Subtotal ----------- 1,054,433.00 1,054,433.00 52,012.37 741,087.31 70.283 313,345.69 Fund number: 122 Trophy Club MUD Fire Dept. 36,782.91 311,166.62- 311,166.62 April 17, 2018 Regular Meeting Agenda Packet 102 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 1 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 3/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 1097 03/01/2018 Property Taxes (1,031,746.08) (713.49) (1,032,459.57) GL 1098 03/02/2018 Property Taxes (2,023.96) (1,034,483.53) GL 1099 03/05/2018 Property Taxes (1,199.16) (1,035,682.69) GL 1100 03/06/2018 Property Taxes (486.95) (1,036,169.64) GL 1101 03/07/2018 Property Taxes (1,320.67) (1,037,490.31) GL 1103 03/09/2018 Property Taxes (301.75) (1,037,792.06) GL 1104 03/12/2018 Property Taxes (55.21) (1,037,847.27) GL 1105 03/13/2018 Property Taxes (83.86) (1,037,931.13) GL 1106 03/14/2018 Property Taxes (295.55) (1,038,226.68) GL 1107 03/16/2018 Property Taxes (397.99) (1,038,624.67) GL 1108 03/19/2018 Property Taxes (695.56) (1,039,320.23) GL 1109 03/20/2018 Property Taxes (22.95) (1,039,343.18) GL 1110 03/21/2018 Property Taxes (620.26) (1,039,963.44) GL 1111 03/22/2018 Property Taxes (5,612.82) (1,045,576.26) GL 1112 03/23/2018 Property Taxes 1,441.26 (1,044,135.00) GL 1145 03/23/2018 Revr Prop Tax Paid A/P JE 1142 (1,441.26) (1,045,576.26) GL 1113 03/26/2018 Property Taxes (665.96) (1,046,242.22) GL 1142 03/26/2018 Denton Tax A/P Shortage Refund Tax Shortage 1,441.26 (1,044,800.96) DENTON COUNTY TAX OFFICE 4088 AP 1114 03/27/2018 Property Taxes (37.23) (1,044,838.19) GL 1115 03/28/2018 Property Taxes (923.68) (1,045,761.87) GL 1116 03/29/2018 Property Taxes (258.40) (1,046,020.27) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (14,274.19) (1,046,020.27) ** (1,054,433.00) Budgeted (8,412.73) Remaining 99 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1097 03/01/2018 Property Taxes (2,874.28) (5.69) (2,879.97) GL 1098 03/02/2018 Property Taxes (14.93) (2,894.90) GL 1099 03/05/2018 Property Taxes (.05) (2,894.95) GL 1100 03/06/2018 Property Taxes (6.83) (2,901.78) GL 1104 03/12/2018 Property Taxes (4.34) (2,906.12) GL 1107 03/16/2018 Property Taxes (194.62) (3,100.74) GL 1114 03/27/2018 Property Taxes (.17) (3,100.91) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (226.63) (3,100.91) ** .00 Budgeted 3,100.91 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 1097 03/01/2018 Property Taxes (2,404.11) (52.73) (2,456.84) GL 1098 03/02/2018 Property Taxes (132.75) (2,589.59) GL April 17, 2018 Regular Meeting Agenda Packet 103 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 2 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1099 03/05/2018 Property Taxes (2,404.11) (103.16) (2,692.75) GL 1100 03/06/2018 Property Taxes (44.44) (2,737.19) GL 1101 03/07/2018 Property Taxes (96.20) (2,833.39) GL 1102 03/08/2018 Property Taxes (27.80) (2,861.19) GL 1103 03/09/2018 Property Taxes (32.03) (2,893.22) GL 1104 03/12/2018 Property Taxes (16.62) (2,909.84) GL 1107 03/16/2018 Property Taxes (82.10) (2,991.94) GL 1108 03/19/2018 Property Taxes (18.99) (3,010.93) GL 1110 03/21/2018 Property Taxes (12.96) (3,023.89) GL 1112 03/23/2018 Property Taxes (.57) (3,024.46) GL 1145 03/23/2018 Revr Prop Tax Paid A/P JE 1142 .57 (3,023.89) GL 1113 03/26/2018 Property Taxes (20.04) (3,043.93) GL 1142 03/26/2018 Denton Tax A/P Shortage Refund Tax Shortage (.57) (3,044.50) DENTON COUNTY TAX OFFICE 4088 AP 1114 03/27/2018 Property Taxes (.19) (3,044.69) GL 1115 03/28/2018 Property Taxes (74.53) (3,119.22) GL 1116 03/29/2018 Property Taxes (13.53) (3,132.75) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (728.64) (3,132.75) ** .00 Budgeted 3,132.75 Remaining 0 % Used Department Totals: ----------------------------------- (1,052,253.93) ** (15,229.46) Monthly Total (1,054,433.00) Budgeted (2,179.07) Remaining 100 % Used April 17, 2018 Regular Meeting Agenda Packet 104 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 3 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/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 237 03/01/2018 Insurance/Wrk Comp Exp Mar 6,349.35 1,269.87 7,619.22 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,269.87 7,619.22 ** 18,000.00 Budgeted 10,380.78 Remaining 42 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 923 03/07/2018 March A/P March fire admin 253,712.50 50,742.50 304,455.00 TOWN OF TROPHY CLUB 3998 AP _______________ Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 50,742.50 304,455.00 ** 608,910.00 Budgeted 304,455.00 Remaining 50 % 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: ----------------------------------- 741,087.31 ** 52,012.37 Monthly Total 1,054,433.00 Budgeted 313,345.69 Remaining 70 % Used April 17, 2018 Regular Meeting Agenda Packet 105 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/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: ----------------------------------- (311,166.62) 36,782.91 Monthly Total .00 Budgeted 311,166.62 Remaining 0 % Used April 17, 2018 Regular Meeting Agenda Packet 106 of 202 TROPHY CLUB MUD #1 - O&M BALANCE SHEET MARCH 2018 GTBGT 135 137 GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 - 600 CASH IN BANK-CHECKING 1,794,534 - 1,794,534 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,777 - 714,777 INVESTMENTS-TEXPOOL 1,049,126 596,426 1,645,552 PREPAID EXPENSES 54,331 - 54,331 ADVALOREM PROPERTY TAXES RECEIVABLE 4,393 - 4,393 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,035,527 - 1,035,527 TOTAL ASSETS 5,470,581 596,426 6,067,007 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 4,393 - 4,393 ACCOUNTS AND OTHER PAYABLES 822,263 - 822,263 CUSTOMER DEPOSITS 314,660 - 314,660 - TOTAL LIABILITIES 1,141,316 - 1,141,316 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 178,897 - 178,897 - TOTAL FUND BALANCE 4,329,265 596,426 4,925,691 TOTAL LIABILITIES AND FUND BALANCE 5,470,581 596,426 6,067,007 April 17, 2018 Regular Meeting Agenda Packet 107 of 202 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 3 23:00 04/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 120,950.00- 120,950.00- 1,637.25- 119,980.25- 99.198 969.75- 135-40002-000-000 Property Taxes/Delinquent 200.00- 200.00- 14.12- 203.05- 101.525 3.05 135-40015-000-000 Property Taxes/P & I 200.00- 200.00- 80.69- 335.16- 167.580 135.16 135-40025-000-000 PID Surcharges 177,839.00- 177,839.00- 177,839.00- Subtotal: 299,189.00- 299,189.00- 1,732.06- 120,518.46- 40.282 178,670.54- 135-47000-000-000 Water 6,464,019.00- 6,464,019.00- 331,079.88- 2,225,115.47- 34.423 4,238,903.53- 135-47005-000-000 Sewer 2,978,067.00- 2,978,067.00- 237,532.41- 1,422,742.27- 47.774 1,555,324.73- 135-47025-000-000 Penalties 106,279.00- 106,279.00- 8,246.29- 59,504.11- 55.989 46,774.89- 135-47030-000-000 Service Charges 21,350.00- 21,350.00- 1,225.00- 7,200.00- 33.724 14,150.00- 135-47035-000-000 Plumbing Inspections 1,500.00- 1,500.00- 100.00- 1,500.00- 100.000 135-47045-000-000 Sewer Inspections 4,500.00- 4,500.00- 300.00- 3,700.00- 82.222 800.00- 135-47070-000-000 TCCC Effluent Charges 60,000.00- 60,000.00- 496.80- 9,972.80- 16.621 50,027.20- Subtotal: 9,635,715.00- 9,635,715.00- 578,980.38- 3,729,734.65- 38.707 5,905,980.35- 135-49010-000-000 Interest Income 12,000.00- 12,000.00- 4,979.61- 20,866.64- 173.889 8,866.64 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 978.81- 5,804.58- 53.126 5,121.42- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 3,499.98- 50.000 3,500.02- 135-49026-000-000 Proceeds from Sale of Assets 2,000.00- 2,000.00- 2,000.00- 135-49075-000-000 Oversize Meter Reimbursement 18,179.00- 18,179.00- 686.00- 9,434.76- 51.899 8,744.24- 135-49900-000-000 Miscellaneous Income 5,000.00- 5,000.00- 6,594.20- 12,447.65- 248.953 7,447.65 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- 13,821.95- 52,053.61- 16.518 263,071.39- Program number: 10,250,029.00- 10,250,029.00- 594,534.39- 3,902,306.72- 38.071 6,347,722.28- Department number: Revenues 10,250,029.00- 10,250,029.00- 594,534.39- 3,902,306.72- 38.071 6,347,722.28- Revenues Subtotal ----------- 10,250,029.00- 10,250,029.00- 594,534.39- 3,902,306.72- 38.071 6,347,722.28- April 17, 2018 Regular Meeting Agenda Packet 108 of 202 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 4 23:00 04/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/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 17,800.29 99,790.93 36.383 174,488.07 135-50010-010-000 Overtime 20,000.00 20,000.00 1,407.22 4,625.38 23.127 15,374.62 135-50016-010-000 Longevity 3,425.00 3,425.00 3,310.00 96.642 115.00 135-50017-010-000 Certification 3,300.00 3,300.00 175.00 1,075.00 32.576 2,225.00 135-50020-010-000 Retirement 27,843.00 27,843.00 1,792.89 11,474.08 41.210 16,368.92 135-50026-010-000 Medical Insurance 52,196.00 52,196.00 2,948.80 15,107.03 28.943 37,088.97 135-50027-010-000 Dental Insurance 5,182.00 5,182.00 213.65 1,307.39 25.229 3,874.61 135-50028-010-000 Vision Insurance 994.00 994.00 35.92 244.31 24.578 749.69 135-50029-010-000 Life Insurance & Other 2,982.00 2,982.00 249.57 1,275.57 42.776 1,706.43 135-50030-010-000 Social Security Taxes 18,662.00 18,662.00 1,184.03 6,691.80 35.858 11,970.20 135-50035-010-000 Medicare Taxes 4,365.00 4,365.00 276.93 1,565.02 35.854 2,799.98 135-50040-010-000 Unemployment Taxes 1,080.00 1,080.00 688.99 730.07 67.599 349.93 135-50045-010-000 Workman's Compensation 11,854.00 11,854.00 899.92 5,399.52 45.550 6,454.48 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,673.21 152,841.14 35.823 273,820.86 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 14,880.10 47,759.58 47.760 52,240.42 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 1,035.68 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 675.00 2,768.44 50.335 2,731.56 Subtotal: 391,000.00 391,000.00 16,590.78 54,381.09 13.908 336,618.91 135-60010-010-000 Communications/Mobiles 4,700.00 4,700.00 740.82 2,122.44 45.158 2,577.56 135-60020-010-000 Electricity 175,356.00 175,356.00 7,577.14 63,857.28 36.416 111,498.72 135-60066-010-000 Publications/Books/Subscripts 1,000.00 1,000.00 1,000.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 361.00 1,335.78 47.963 1,449.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 12,808.05 23.213 42,367.95 135-60150-010-000 Wholesale Water 2,823,170.00 2,823,170.00 108,177.96 721,667.37 25.562 2,101,502.63 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,000.00 3,000.00 322.70 10.757 2,677.30 135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 750.00 3,000.00 20.339 11,750.00 135-60332-010-000 Interfund Transfer Out-Rev I&S 278,084.00 278,084.00 25,280.31 151,681.86 54.545 126,402.14 135-60333-010-000 Interfund Transfer Out-Reserve 48,996.00 48,996.00 4,083.00 24,498.00 50.000 24,498.00 135-60334-010-000 Interfund Transfer Out 200,000.00 200,000.00 200,000.00 135-60360-010-000 Furniture/Equipment < $5000 2,500.00 2,500.00 5,019.66 200.786 2,519.66- April 17, 2018 Regular Meeting Agenda Packet 109 of 202 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 5 23:00 04/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/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 146,970.23 986,408.98 27.295 2,627,443.02 135-65005-010-000 Fuel & Lube 15,000.00 15,000.00 872.28 4,805.80 32.039 10,194.20 135-65010-010-000 Uniforms 4,488.00 4,488.00 990.57 22.072 3,497.43 135-65030-010-000 Chemicals 20,000.00 20,000.00 1,882.24 8,523.63 42.618 11,476.37 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 192.00 19.200 808.00 135-65050-010-000 Meter Expense 50,000.00 50,000.00 12,400.00 24.800 37,600.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 2,946.52 75,812.00 43.151 99,876.00 135-69005-010-000 Capital Outlays 810,012.00 810,012.00 84,262.58 307,870.80 38.008 502,141.20 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 84,262.58 490,735.18 46.816 557,495.82 Program number: 5,655,433.00 5,655,433.00 278,443.32 1,760,178.39 31.124 3,895,254.61 April 17, 2018 Regular Meeting Agenda Packet 110 of 202 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 6 23:00 04/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 3/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 160.00 903.89 45.195 1,096.11 Subtotal: 2,000.00 2,000.00 160.00 903.89 45.195 1,096.11 Program number: 1 Lab Analysis for PID 2,000.00 2,000.00 160.00 903.89 45.195 1,096.11 Department number: Water 5,657,433.00 5,657,433.00 278,603.32 1,761,082.28 31.129 3,896,350.72 April 17, 2018 Regular Meeting Agenda Packet 111 of 202 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7 23:00 04/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/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 31,482.93 184,895.51 45.001 225,970.49 135-50010-020-000 Overtime 30,000.00 30,000.00 3,281.80 15,668.88 52.230 14,331.12 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,236.00 50.429 4,164.00 135-50020-020-000 Retirement 42,243.00 42,243.00 3,280.48 21,084.11 49.911 21,158.89 135-50026-020-000 Medical Insurance 62,175.00 62,175.00 6,108.45 32,455.95 52.201 29,719.05 135-50027-020-000 Dental Insurance 5,271.00 5,271.00 387.45 2,335.61 44.311 2,935.39 135-50028-020-000 Vision Insurance 1,114.00 1,114.00 65.49 449.46 40.346 664.54 135-50029-020-000 Life Insurance & Other 4,281.00 4,281.00 379.07 2,339.26 54.643 1,941.74 135-50030-020-000 Social Security Taxes 28,314.00 28,314.00 2,021.49 12,299.70 43.440 16,014.30 135-50035-020-000 Medicare Taxes 6,622.00 6,622.00 472.76 2,876.53 43.439 3,745.47 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 1,073.12 1,134.00 90.000 126.00 135-50045-020-000 Workman's Compensation 17,990.00 17,990.00 1,348.00 8,088.00 44.958 9,902.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 50,601.04 295,278.01 47.124 331,322.99 135-55070-020-000 Independent Labor 20,550.00 20,550.00 1,075.50 2,145.00 10.438 18,405.00 135-55080-020-000 Maintenance & Repairs 86,100.00 86,100.00 7,567.70 26,745.39 31.063 59,354.61 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 885.73 4,292.14 53.652 3,707.86 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 7,657.40 43,360.77 72.268 16,639.23 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 1,864.00 18,326.82 61.089 11,673.18 Subtotal: 219,150.00 219,150.00 19,050.33 95,188.59 43.435 123,961.41 135-60010-020-000 Communications/Mobiles 4,700.00 4,700.00 763.67 2,865.72 60.973 1,834.28 135-60020-020-000 Electricity 266,709.00 266,709.00 13,226.36 86,385.16 32.389 180,323.84 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 222.00 3.911 5,455.00 135-60090-020-000 Safety Program 550.00 550.00 8.37 1.522 541.63 135-60100-020-000 Travel & per diem 1,635.00 1,635.00 73.06 4.469 1,561.94 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 590.00 2,360.00 20.345 9,240.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 122,043.00 122,043.00 11,094.81 66,568.86 54.545 55,474.14 135-60332-020-000 Interfund Transfer Out-Rev I&S 598,738.00 598,738.00 54,430.72 326,584.32 54.545 272,153.68 135-60333-020-000 Interfund Transfer Out-Reserve 123,336.00 123,336.00 10,278.00 61,668.00 50.000 61,668.00 April 17, 2018 Regular Meeting Agenda Packet 112 of 202 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 8 23:00 04/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/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 4,000.00 Subtotal: 1,438,938.00 1,438,938.00 90,605.56 577,008.02 40.100 861,929.98 135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 1,004.37 4,735.44 37.884 7,764.56 135-65010-020-000 Uniforms 4,459.00 4,459.00 1,774.59 39.798 2,684.41 135-65030-020-000 Chemicals 27,500.00 27,500.00 1,359.32 5,251.35 19.096 22,248.65 135-65035-020-000 Small Tools 1,000.00 1,000.00 20.78 1,138.99 113.899 138.99- 135-65040-020-000 Safety Equipment 750.00 750.00 326.57 586.57 78.209 163.43 135-65045-020-000 Lab Supplies 14,000.00 14,000.00 2,168.08 7,839.46 55.996 6,160.54 Subtotal: 60,209.00 60,209.00 4,879.12 21,326.40 35.421 38,882.60 135-69005-020-000 Capital Outlays 547,327.00 547,327.00 294,401.35 309,455.78 56.539 237,871.22 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 294,401.35 339,455.78 53.353 296,786.22 Program number: 2,981,140.00 2,981,140.00 459,537.40 1,328,256.80 44.555 1,652,883.20 Department number: Wastewater 2,981,140.00 2,981,140.00 459,537.40 1,328,256.80 44.555 1,652,883.20 April 17, 2018 Regular Meeting Agenda Packet 113 of 202 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 9 23:00 04/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 3/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 14.52 48.400 15.48 Subtotal: 30.00 30.00 2.42 14.52 48.400 15.48 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 1,200.00 135-60080-026-000 Schools & Training 4,000.00 4,000.00 1,135.00 28.375 2,865.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 960.00 19.200 4,040.00 135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 1,021.73 51.087 978.27 Subtotal: 12,950.00 12,950.00 3,766.73 29.087 9,183.27 Program number: 12,980.00 12,980.00 2.42 3,781.25 29.131 9,198.75 Department number: Board of Directors 12,980.00 12,980.00 2.42 3,781.25 29.131 9,198.75 April 17, 2018 Regular Meeting Agenda Packet 114 of 202 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 10 23:00 04/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/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 25,193.62 180,628.41 41.729 252,234.59 135-50010-030-000 Overtime 2,000.00 2,000.00 46.02 456.67 22.834 1,543.33 135-50016-030-000 Longevity 3,548.00 3,548.00 3,547.50 99.986 .50 135-50020-030-000 Retirement 40,553.00 40,553.00 2,334.67 19,385.45 47.803 21,167.55 135-50026-030-000 Medical Insurance 63,485.00 63,485.00 4,145.24 23,193.21 36.533 40,291.79 135-50027-030-000 Dental Insurance 5,502.00 5,502.00 259.52 1,752.92 31.860 3,749.08 135-50028-030-000 Vision Insurance 1,173.00 1,173.00 42.51 341.41 29.106 831.59 135-50029-030-000 Life Insurance & Other 5,059.00 5,059.00 216.39 1,920.29 37.958 3,138.71 135-50030-030-000 Social Security Taxes 27,181.00 27,181.00 1,486.43 10,988.19 40.426 16,192.81 135-50035-030-000 Medicare Taxes 6,357.00 6,357.00 347.65 2,569.81 40.425 3,787.19 135-50040-030-000 Unemployment Taxes 1,260.00 1,260.00 847.20 901.90 71.579 358.10 135-50045-030-000 Workman's Compensation 1,529.00 1,529.00 123.50 741.00 48.463 788.00 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 124.95 24.990 375.05 135-50070-030-000 Employee Relations 4,960.00 4,960.00 27.47 2,348.26 47.344 2,611.74 Subtotal: 595,970.00 595,970.00 35,070.22 248,899.97 41.764 347,070.03 135-55030-030-000 Software & Support 78,391.00 78,391.00 1,357.96 44,486.55 56.750 33,904.45 135-55070-030-000 Independent Labor 154,000.00 154,000.00 11,103.92 74,174.76 48.165 79,825.24 135-55080-030-000 Maintenance & Repairs 14,000.00 14,000.00 194.23 2,475.73 17.684 11,524.27 135-55085-030-000 Generator Maint. and Repair 10,000.00 10,000.00 10,000.00 135-55120-030-000 Cleaning Services 10,000.00 10,000.00 869.06 3,962.39 39.624 6,037.61 135-55160-030-000 Professional Outside Services 63,325.00 63,325.00 2,765.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 977.54 3,951.79 43.909 5,048.21 Subtotal: 338,916.00 338,916.00 17,267.71 188,291.22 55.557 150,624.78 135-60005-030-000 Telephone 27,300.00 27,300.00 28.71 7,417.68 27.171 19,882.32 135-60010-030-000 Communications/Mobiles 4,000.00 4,000.00 324.81 1,649.43 41.236 2,350.57 135-60020-030-000 Electricity/Gas 16,261.00 16,261.00 1,409.08 3,106.68 19.105 13,154.32 135-60025-030-000 Water 2,500.00 2,500.00 53.36 339.12 13.565 2,160.88 135-60030-030-000 Rent And/Or Usage 616.40 616.40- 135-60035-030-000 Postage 30,000.00 30,000.00 3,013.63 12,665.27 42.218 17,334.73 135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 4,248.58 29,796.12 53.629 25,763.88 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,150.36 39,877.16 71.209 16,122.84 135-60066-030-000 Publications/Books/Subscripts 1,600.00 1,600.00 1,600.00 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 20.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 2,693.00 35.434 4,907.00 135-60100-030-000 Travel & per diem 4,885.00 4,885.00 17.66 599.83 12.279 4,285.17 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 April 17, 2018 Regular Meeting Agenda Packet 115 of 202 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 11 23:00 04/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/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 145.00 3.222 4,355.00 135-60125-030-000 Advertising 2,500.00 2,500.00 2,500.00 135-60235-030-000 Security 2,700.00 2,700.00 24.00 72.00 2.667 2,628.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,290.19 103,191.22 41.358 146,314.78 135-65010-030-000 Uniforms 700.00 700.00 137.74 137.74 19.677 562.26 135-65055-030-000 Hardware 7,420.00 7,420.00 597.95 8.059 6,822.05 135-65085-030-000 Office Supplies 7,000.00 7,000.00 263.52 2,876.21 41.089 4,123.79 135-65090-030-000 Printer Supplies & Maintenance 2,000.00 2,000.00 145.61 2,048.66 102.433 48.66- 135-65095-030-000 Maintenance Supplies 4,000.00 4,000.00 760.53 2,822.39 70.560 1,177.61 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,307.40 8,626.95 34.343 16,493.05 135-69005-030-000 Capital Outlays 13,000.00 13,000.00 7,841.00 60.315 5,159.00 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 247.12 1,476.14 32.090 3,123.86 Subtotal: 17,600.00 17,600.00 247.12 9,317.14 52.938 8,282.86 Program number: 1,227,112.00 1,227,112.00 69,182.64 558,326.50 45.499 668,785.50 Department number: Administration 1,227,112.00 1,227,112.00 69,182.64 558,326.50 45.499 668,785.50 April 17, 2018 Regular Meeting Agenda Packet 116 of 202 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 12 23:00 04/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 3/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 7,470.00 36,813.55 26.871 100,186.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 2,011.87 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 9,481.87 71,962.70 40.715 104,783.30 Program number: 176,746.00 176,746.00 9,481.87 71,962.70 40.715 104,783.30 Department number: Non Departmental 176,746.00 176,746.00 9,481.87 71,962.70 40.715 104,783.30 Expenditures Subtotal ----------- 10,055,411.00 10,055,411.00 816,807.65 3,723,409.53 37.029 6,332,001.47 Fund number: 135 MUD 1 General Fund 194,618.00- 194,618.00- 222,273.26 178,897.19- 91.922 15,720.81- April 17, 2018 Regular Meeting Agenda Packet 117 of 202 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 13 23:00 04/11/18 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 3/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 April 17, 2018 Regular Meeting Agenda Packet 118 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 5 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/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 1097 03/01/2018 Property Taxes (118,343.00) (81.84) (118,424.84) GL 1098 03/02/2018 Property Taxes (232.14) (118,656.98) GL 1099 03/05/2018 Property Taxes (137.54) (118,794.52) GL 1100 03/06/2018 Property Taxes (55.86) (118,850.38) GL 1101 03/07/2018 Property Taxes (151.48) (119,001.86) GL 1103 03/09/2018 Property Taxes (34.61) (119,036.47) GL 1104 03/12/2018 Property Taxes (6.33) (119,042.80) GL 1105 03/13/2018 Property Taxes (9.62) (119,052.42) GL 1106 03/14/2018 Property Taxes (33.90) (119,086.32) GL 1107 03/16/2018 Property Taxes (45.65) (119,131.97) GL 1108 03/19/2018 Property Taxes (79.78) (119,211.75) GL 1109 03/20/2018 Property Taxes (2.63) (119,214.38) GL 1110 03/21/2018 Property Taxes (71.14) (119,285.52) GL 1111 03/22/2018 Property Taxes (643.80) (119,929.32) GL 1112 03/23/2018 Property Taxes 165.31 (119,764.01) GL 1145 03/23/2018 Revr Prop Tax Paid A/P JE 1142 (165.31) (119,929.32) GL 1113 03/26/2018 Property Taxes (76.38) (120,005.70) GL 1142 03/26/2018 Denton Tax A/P Shortage Refund Tax Shortage 165.31 (119,840.39) DENTON COUNTY TAX OFFICE 4088 AP 1114 03/27/2018 Property Taxes (4.27) (119,844.66) GL 1115 03/28/2018 Property Taxes (105.95) (119,950.61) GL 1116 03/29/2018 Property Taxes (29.64) (119,980.25) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (1,637.25) (119,980.25) ** (120,950.00) Budgeted (969.75) Remaining 99 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1097 03/01/2018 Property Taxes (188.93) (1.09) (190.02) GL 1098 03/02/2018 Property Taxes (.88) (190.90) GL 1100 03/06/2018 Property Taxes (.40) (191.30) GL 1104 03/12/2018 Property Taxes (.28) (191.58) GL 1107 03/16/2018 Property Taxes (11.45) (203.03) GL 1114 03/27/2018 Property Taxes (.02) (203.05) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (14.12) (203.05) ** (200.00) Budgeted 3.05 Remaining 102 % Used Account: 135-40015-000-000 Property Taxes/P & I 1097 03/01/2018 Property Taxes (254.47) (6.27) (260.74) GL 1098 03/02/2018 Property Taxes (15.09) (275.83) GL 1099 03/05/2018 Property Taxes (11.84) (287.67) GL April 17, 2018 Regular Meeting Agenda Packet 119 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 6 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1100 03/06/2018 Property Taxes (254.47) (5.07) (292.74) GL 1101 03/07/2018 Property Taxes (11.04) (303.78) GL 1102 03/08/2018 Property Taxes (3.19) (306.97) GL 1103 03/09/2018 Property Taxes (3.67) (310.64) GL 1104 03/12/2018 Property Taxes (1.78) (312.42) GL 1107 03/16/2018 Property Taxes (6.59) (319.01) GL 1108 03/19/2018 Property Taxes (2.18) (321.19) GL 1110 03/21/2018 Property Taxes (1.49) (322.68) GL 1112 03/23/2018 Property Taxes (.06) (322.74) GL 1145 03/23/2018 Revr Prop Tax Paid A/P JE 1142 .06 (322.68) GL 1113 03/26/2018 Property Taxes (2.30) (324.98) GL 1142 03/26/2018 Denton Tax A/P Shortage Refund Tax Shortage (.06) (325.04) DENTON COUNTY TAX OFFICE 4088 AP 1114 03/27/2018 Property Taxes (.02) (325.06) GL 1115 03/28/2018 Property Taxes (8.55) (333.61) GL 1116 03/29/2018 Property Taxes (1.55) (335.16) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (80.69) (335.16) ** (200.00) Budgeted 135.16 Remaining 168 % 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 1082 03/01/2018 acct adj UB20180301-20180301 User: (1,894,035.59) 17.15 (1,894,018.44) UB 1086 03/21/2018 acct adj UB20180321-20180321 User: 12.75 (1,894,005.69) UB 1090 03/29/2018 UB 03/29/2018 Adjustments UB20180329-20180329 User: 17.15 (1,893,988.54) UB 1065 03/31/2018 UB 03/2018 Billing UB20180331-20180331 User: (331,126.93) (2,225,115.47) UB _______________ Account: 135-47000-000-000 Water Totals: (331,079.88) (2,225,115.47) ** (6,464,019.00) Budgeted (4,238,903.53) Remaining 34 % Used Account: 135-47005-000-000 Sewer 1082 03/01/2018 acct adj UB20180301-20180301 User: (1,185,209.86) 22.78 (1,185,187.08) UB 1086 03/21/2018 acct adj UB20180321-20180321 User: 20.00 (1,185,167.08) UB 1090 03/29/2018 UB 03/29/2018 Adjustments UB20180329-20180329 User: 27.02 (1,185,140.06) UB 1065 03/31/2018 UB 03/2018 Billing UB20180331-20180331 User: (237,602.21) (1,422,742.27) UB April 17, 2018 Regular Meeting Agenda Packet 120 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 7 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/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-47005-000-000 Sewer Totals: (237,532.41) (1,422,742.27) ** (2,978,067.00) Budgeted (1,555,324.73) Remaining 48 % Used Account: 135-47025-000-000 Penalties 990 03/14/2018 UB 03/14/2018 Penalty removal UB20180314-20180314 User: (51,257.82) 72.98 (51,184.84) UB 1030 03/21/2018 UB 03/21/2018 Assess Penalties UB20180321-20180321 User: (11,159.83) (62,344.67) UB 1086 03/21/2018 acct adj UB20180321-20180321 User: 95.62 (62,249.05) UB 1087 03/22/2018 adj-40 rockwood UB20180322-20180322 User: 13.65 (62,235.40) UB 1046 03/26/2018 UB 03/26/2018 Penalty removal UB20180326-20180326 User: 136.04 (62,099.36) UB 1055 03/28/2018 UB 03/28/2018 Penalty removal UB20180328-20180328 User: 2,595.25 (59,504.11) UB _______________ Account: 135-47025-000-000 Penalties Totals: (8,246.29) (59,504.11) ** (106,279.00) Budgeted (46,774.89) Remaining 56 % Used Account: 135-47030-000-000 Service Charges 937 03/08/2018 UB 03/08/2018 Disconnect Fees UB20180308-20180308 User: (5,975.00) (1,350.00) (7,325.00) UB 1085 03/12/2018 Disconnect fee-58 cimarron UB20180312-20180312 User: 50.00 (7,275.00) UB 1029 03/19/2018 UB 03/19/2018 NSF check UB20180319-20180319 User: (25.00) (7,300.00) UB 1086 03/21/2018 acct adj UB20180321-20180321 User: 50.00 (7,250.00) UB 1087 03/22/2018 adj-40 rockwood UB20180322-20180322 User: 50.00 (7,200.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,225.00) (7,200.00) ** (21,350.00) Budgeted (14,150.00) Remaining 34 % Used Account: 135-47035-000-000 Plumbing Inspections 1075 03/27/2018 Permits 649 Sheldon Drive (1,400.00) (50.00) (1,450.00) Ashton Wood Homes CR 1075 03/27/2018 Permits 643 Sheldon Drive (50.00) (1,500.00) Ashton Wood Homes CR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (100.00) (1,500.00) ** (1,500.00) Budgeted .00 Remaining 100 % Used Account: 135-47045-000-000 Sewer Inspections 1075 03/27/2018 Permits 649 Sheldon Drive (3,400.00) (150.00) (3,550.00) Ashton Wood Homes CR 1075 03/27/2018 Permits 643 Sheldon Drive (150.00) (3,700.00) Ashton Wood Homes CR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (300.00) (3,700.00) ** (4,500.00) Budgeted (800.00) Remaining 82 % Used April 17, 2018 Regular Meeting Agenda Packet 121 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 8 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-47070-000-000 TCCC Effluent Charges 1065 03/31/2018 UB 03/2018 Billing UB20180331-20180331 User: (9,476.00) (496.80) (9,972.80) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (496.80) (9,972.80) ** (60,000.00) Budgeted (50,027.20) Remaining 17 % Used Account: 135-49010-000-000 Interest Income 1067 03/31/2018 Bank Interest- March (15,887.03) (146.84) (16,033.87) GL 1067 03/31/2018 Bank Interest- March (446.75) (16,480.62) GL 1067 03/31/2018 Bank Interest- March (3,903.11) (20,383.73) GL 1067 03/31/2018 Bank Interest- March (482.91) (20,866.64) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (4,979.61) (20,866.64) ** (12,000.00) Budgeted 8,866.64 Remaining 174 % Used Account: 135-49016-000-000 Cell Tower Revenue 967 03/07/2018 Cell Tower Rev AT&T Mar (4,825.77) (978.81) (5,804.58) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (978.81) (5,804.58) ** (10,926.00) Budgeted (5,121.42) Remaining 53 % Used Account: 135-49018-000-000 Building Rent Income 1175 03/31/2018 Town Billed Invoice #1628-1631 AR 20180331-20180331 User: (2,916.65) (583.33) (3,499.98) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (3,499.98) ** (7,000.00) Budgeted (3,500.02) Remaining 50 % Used Account: 135-49026-000-000 Proceeds from Sale of Assets .00 .00 _______________ Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: .00 .00 ** (2,000.00) Budgeted (2,000.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 1075 03/27/2018 Permits 649 Sheldon Drive (8,748.76) (343.00) (9,091.76) Ashton Wood Homes CR 1075 03/27/2018 Permits 643 Sheldon Drive (343.00) (9,434.76) Ashton Wood Homes CR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (686.00) (9,434.76) ** (18,179.00) Budgeted (8,744.24) Remaining 52 % Used April 17, 2018 Regular Meeting Agenda Packet 122 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 9 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/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-49900-000-000 Miscellaneous Income 1078 03/07/2018 Recycling of Scrap Metal Sell/recycle of scrap metal (5,853.45) (4,374.30) (10,227.75) GL 1079 03/16/2018 Recycling of Scrap Metal (1,883.79) (12,111.54) GL 1088 03/28/2018 credit adj UB UB20180328-20180328 User: (.22) (12,111.76) UB 1065 03/31/2018 UB 03/2018 Billing UB20180331-20180331 User: (335.89) (12,447.65) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (6,594.20) (12,447.65) ** (5,000.00) Budgeted 7,447.65 Remaining 249 % Used Account: 135-49901-000-000 Records Management Revenue .00 .00 _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 .00 ** (20.00) Budgeted (20.00) Remaining 0 % Used Account: 135-49910-000-000 Reimbursement/Revenue Bond .00 .00 _______________ Account: 135-49910-000-000 Reimbursement/Revenue Bond Totals: .00 .00 ** (260,000.00) Budgeted (260,000.00) Remaining 0 % Used Department Totals: ----------------------------------- (3,902,306.72) ** (594,534.39) Monthly Total (10,250,029.00) Budgeted (6,347,722.28) Remaining 38 % Used April 17, 2018 Regular Meeting Agenda Packet 123 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/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 929 03/09/2018 MUD PR 03.09.18 Salaries & Wages 81,990.64 8,883.92 90,874.56 PR 1031 03/23/2018 MUD PR 03.23.18 Salaries & Wages 8,916.37 99,790.93 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 17,800.29 99,790.93 ** 274,279.00 Budgeted 174,488.07 Remaining 36 % Used Account: 135-50010-010-000 Overtime 929 03/09/2018 MUD PR 03.09.18 Overtime 3,218.16 316.92 3,535.08 PR 1031 03/23/2018 MUD PR 03.23.18 Overtime 1,090.30 4,625.38 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,407.22 4,625.38 ** 20,000.00 Budgeted 15,374.62 Remaining 23 % 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 1031 03/23/2018 MUD PR 03.23.18 Certification 900.00 175.00 1,075.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 175.00 1,075.00 ** 3,300.00 Budgeted 2,225.00 Remaining 33 % Used Account: 135-50020-010-000 Retirement 929 03/09/2018 MUD PR 03.09.18 Retirement 9,681.19 851.09 10,532.28 PR 1031 03/23/2018 MUD PR 03.23.18 Retirement 941.80 11,474.08 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,792.89 11,474.08 ** 27,843.00 Budgeted 16,368.92 Remaining 41 % Used Account: 135-50026-010-000 Medical Insurance 929 03/09/2018 MUD PR 03.09.18 Medical Insurance 12,158.23 1,474.40 13,632.63 PR 1031 03/23/2018 MUD PR 03.23.18 Medical Insurance 1,474.40 15,107.03 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,948.80 15,107.03 ** 52,196.00 Budgeted 37,088.97 Remaining 29 % Used April 17, 2018 Regular Meeting Agenda Packet 124 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/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 929 03/09/2018 MUD PR 03.09.18 Dental Insurance 1,093.74 106.85 1,200.59 PR 1031 03/23/2018 MUD PR 03.23.18 Dental Insurance 106.80 1,307.39 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 213.65 1,307.39 ** 5,182.00 Budgeted 3,874.61 Remaining 25 % Used Account: 135-50028-010-000 Vision Insurance 929 03/09/2018 MUD PR 03.09.18 Vision Insurance 208.39 17.98 226.37 PR 1031 03/23/2018 MUD PR 03.23.18 Vision Insurance 17.94 244.31 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 35.92 244.31 ** 994.00 Budgeted 749.69 Remaining 25 % Used Account: 135-50029-010-000 Life Insurance & Other 865 03/01/2018 March A/P LTD & STD 1,026.00 100.59 1,126.59 METLIFE GROUP BENEFITS 3969 AP 865 03/01/2018 March A/P Dental/Vision/Life Insurance 130.48 1,257.07 Humana Inc 3960 AP 1040 03/23/2018 March A/P FLex admin fee 18.50 1,275.57 BenefitMall 4040 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 249.57 1,275.57 ** 2,982.00 Budgeted 1,706.43 Remaining 43 % Used Account: 135-50030-010-000 Social Security Taxes 929 03/09/2018 MUD PR 03.09.18 Social Security Taxes 5,507.77 562.73 6,070.50 PR 1031 03/23/2018 MUD PR 03.23.18 Social Security Taxes 621.30 6,691.80 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,184.03 6,691.80 ** 18,662.00 Budgeted 11,970.20 Remaining 36 % Used Account: 135-50035-010-000 Medicare Taxes 929 03/09/2018 MUD PR 03.09.18 Medicare Taxes 1,288.09 131.62 1,419.71 PR 1031 03/23/2018 MUD PR 03.23.18 Medicare Taxes 145.31 1,565.02 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 276.93 1,565.02 ** 4,365.00 Budgeted 2,799.98 Remaining 36 % Used Account: 135-50040-010-000 Unemployment Taxes 929 03/09/2018 MUD PR 03.09.18 Unemployment Taxes 41.08 4.13 45.21 PR April 17, 2018 Regular Meeting Agenda Packet 125 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 12 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1031 03/23/2018 MUD PR 03.23.18 Unemployment Taxes 41.08 684.86 730.07 PR _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 688.99 730.07 ** 1,080.00 Budgeted 349.93 Remaining 68 % Used Account: 135-50045-010-000 Workman's Compensation 237 03/01/2018 Insurance/Wrk Comp Exp Mar 4,499.60 899.92 5,399.52 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 899.92 5,399.52 ** 11,854.00 Budgeted 6,454.48 Remaining 46 % 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 1019 03/20/2018 March A/P Hydrant for Hill Ct 32,879.48 2,304.44 35,183.92 Core & Main LP 4008 AP 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 CONOCO - STEAGALL OIL 59.75 35,243.67 CONOCO - STEAGALL OIL PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 THE HOME DEPOT #6581 31.37 35,275.04 THE HOME DEPOT #6581 PC 1128 03/31/2018 March A/P Gauge calibration 50.00 35,325.04 MACARTHUR GAUGE INC 4065 AP 1158 03/31/2018 March A/P 10" force main repair billed t 7,459.54 42,784.58 REY-MAR CONSTRUCTION 4094 AP 1158 03/31/2018 March A/P Hill Lane Water repair 4,975.00 47,759.58 REY-MAR CONSTRUCTION 4094 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 14,880.10 47,759.58 ** 100,000.00 Budgeted 52,240.42 Remaining 48 % Used April 17, 2018 Regular Meeting Agenda Packet 126 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 13 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/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-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 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 DISCOUNT TIRE TXD 75 2,817.39 888.50 3,705.89 DISCOUNT TIRE TXD 75 PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 INLAND TRUCK PARTS # 40.00 3,745.89 INLAND TRUCK PARTS # PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 KWIK KAR LUBE & TUNE O 25.50 3,771.39 KWIK KAR LUBE & TUNE O PC 1128 03/31/2018 March A/P Oil change-#109 81.68 3,853.07 Gierisch Brothers Motor Co LTD 4051 AP _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 1,035.68 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 1019 03/20/2018 March A/P Water samples 2,093.44 275.00 2,368.44 TARRANT CTY PUBLIC HEALTH LAB 4027 AP 1179 03/31/2018 March A/P Water samples 400.00 2,768.44 TARRANT CTY PUBLIC HEALTH LAB AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 675.00 2,768.44 ** 5,500.00 Budgeted 2,731.56 Remaining 50 % Used Account: 135-60010-010-000 Communications/Mobiles 989 03/14/2018 March A/P Mobile phones 1,381.62 370.64 1,752.26 VERIZON WIRELESS 4031 AP 1179 03/31/2018 March A/P Cell phones 370.18 2,122.44 VERIZON WIRELESS AP _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 740.82 2,122.44 ** 4,700.00 Budgeted 2,577.56 Remaining 45 % Used Account: 135-60020-010-000 Electricity 1019 03/20/2018 March A/P Electricity 2/8-3/9 56,280.14 7,577.14 63,857.28 HUDSON ENERGY SERVICES, LLC 4016 AP April 17, 2018 Regular Meeting Agenda Packet 127 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 14 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/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: 7,577.14 63,857.28 ** 175,356.00 Budgeted 111,498.72 Remaining 36 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % 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 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 SUNCOAST LEARNING SYST 974.78 250.00 1,224.78 SUNCOAST LEARNING SYST PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 TCEQ EPAYMENT 111.00 1,335.78 TCEQ EPAYMENT PC _______________ Account: 135-60080-010-000 Schools & Training Totals: 361.00 1,335.78 ** 2,785.00 Budgeted 1,449.22 Remaining 48 % 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 April 17, 2018 Regular Meeting Agenda Packet 128 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 15 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/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 12,808.05 .00 12,808.05 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 12,808.05 ** 55,176.00 Budgeted 42,367.95 Remaining 23 % Used Account: 135-60150-010-000 Wholesale Water 1040 03/23/2018 March A/P water 613,489.41 108,177.96 721,667.37 CITY OF FORT WORTH 4042 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 108,177.96 721,667.37 ** 2,823,170.00 Budgeted 2,101,502.63 Remaining 26 % 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 322.70 .00 322.70 _______________ Account: 135-60280-010-000 Property Maintenance Totals: .00 322.70 ** 3,000.00 Budgeted 2,677.30 Remaining 11 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance 1125 03/31/2018 March A/P March mowing 2,250.00 750.00 3,000.00 WATTS ELLISON LLC 4083 AP _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: 750.00 3,000.00 ** 14,750.00 Budgeted 11,750.00 Remaining 20 % Used Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S 1066 03/31/2018 Texpool Transfers March 126,401.55 25,280.31 151,681.86 GL April 17, 2018 Regular Meeting Agenda Packet 129 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/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 151,681.86 ** 278,084.00 Budgeted 126,402.14 Remaining 55 % Used Account: 135-60333-010-000 Interfund Transfer Out-Reserve 1066 03/31/2018 Texpool Transfers March 20,415.00 4,083.00 24,498.00 GL _______________ Account: 135-60333-010-000 Interfund Transfer Out-Reserve Totals: 4,083.00 24,498.00 ** 48,996.00 Budgeted 24,498.00 Remaining 50 % Used Account: 135-60334-010-000 Interfund Transfer Out .00 .00 _______________ Account: 135-60334-010-000 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 5,019.66 .00 5,019.66 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 5,019.66 ** 2,500.00 Budgeted (2,519.66) Remaining 201 % Used Account: 135-65005-010-000 Fuel & Lube 1058 03/28/2018 March A/P Fuel 3,933.52 872.28 4,805.80 US Bank Voyager Fleet Systems 4080 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 872.28 4,805.80 ** 15,000.00 Budgeted 10,194.20 Remaining 32 % Used Account: 135-65010-010-000 Uniforms 990.57 .00 990.57 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 990.57 ** 4,488.00 Budgeted 3,497.43 Remaining 22 % Used Account: 135-65030-010-000 Chemicals 1019 03/20/2018 March A/P sampling supplies 6,641.39 334.27 6,975.66 HACH COMPANY 4013 AP 1058 03/28/2018 March A/P Testing supplies 455.74 7,431.40 HACH COMPANY 4052 AP April 17, 2018 Regular Meeting Agenda Packet 130 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1058 03/28/2018 March A/P Chlorine 6,641.39 442.48 7,873.88 DPC INDUSTRIES, INC 4046 AP 1125 03/31/2018 March A/P Testing supplies 649.75 8,523.63 HACH COMPANY 4052 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 1,882.24 8,523.63 ** 20,000.00 Budgeted 11,476.37 Remaining 43 % 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 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 TX AMERICA SAFETY 192.00 192.00 TX AMERICA SAFETY PC _______________ Account: 135-65040-010-000 Safety Equipment Totals: 192.00 192.00 ** 1,000.00 Budgeted 808.00 Remaining 19 % Used Account: 135-65050-010-000 Meter Expense 12,400.00 .00 12,400.00 _______________ Account: 135-65050-010-000 Meter Expense Totals: .00 12,400.00 ** 50,000.00 Budgeted 37,600.00 Remaining 25 % 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 923 03/07/2018 March A/P Valve replacements 223,608.22 49,997.62 273,605.84 REY-MAR CONSTRUCTION 3994 AP 1019 03/20/2018 March A/P 16" water line 9,220.45 282,826.29 Halff Associates, INC 4012 AP 1019 03/20/2018 March A/P 16" water line 11,313.77 294,140.06 Halff Associates, INC 4012 AP 1125 03/31/2018 March A/P Water line replacement 1,650.00 295,790.06 TEAGUE, NALL & PERKINS,INC 4076 AP 1125 03/31/2018 March A/P Water line replacement 3,500.00 299,290.06 TEAGUE, NALL & PERKINS,INC 4076 AP 1179 03/31/2018 March A/P 16" water line 1,152.55 300,442.61 Halff Associates, INC AP 1179 03/31/2018 March A/P 16" water line 7,428.19 307,870.80 Halff Associates, INC AP April 17, 2018 Regular Meeting Agenda Packet 131 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 18 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-69005-010-000 Capital Outlays Totals: 84,262.58 307,870.80 ** 810,012.00 Budgeted 502,141.20 Remaining 38 % Used Account: 135-69008-010-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 .00 ** 38,731.00 Budgeted 38,731.00 Remaining 0 % Used Account: 135-69009-010-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 .00 ** 5,713.00 Budgeted 5,713.00 Remaining 0 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 .00 75,000.00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 107,864.38 .00 107,864.38 _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 107,864.38 ** 118,775.00 Budgeted 10,910.62 Remaining 91 % Used April 17, 2018 Regular Meeting Agenda Packet 132 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 19 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 3/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 1019 03/20/2018 March A/P Water samples-PID 743.89 80.00 823.89 TARRANT CTY PUBLIC HEALTH LAB 4027 AP 1179 03/31/2018 March A/P Water samples-PID 80.00 903.89 TARRANT CTY PUBLIC HEALTH LAB AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 160.00 903.89 ** 2,000.00 Budgeted 1,096.11 Remaining 45 % Used Department 10 Totals: ----------------------------------- 1,761,082.28 ** 278,603.32 Monthly Total 5,657,433.00 Budgeted 3,896,350.72 Remaining 31 % Used April 17, 2018 Regular Meeting Agenda Packet 133 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/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 929 03/09/2018 MUD PR 03.09.18 Salaries & Wages 153,412.58 15,307.25 168,719.83 PR 1031 03/23/2018 MUD PR 03.23.18 Salaries & Wages 16,175.68 184,895.51 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 31,482.93 184,895.51 ** 410,866.00 Budgeted 225,970.49 Remaining 45 % Used Account: 135-50010-020-000 Overtime 929 03/09/2018 MUD PR 03.09.18 Overtime 12,387.08 2,434.60 14,821.68 PR 1031 03/23/2018 MUD PR 03.23.18 Overtime 847.20 15,668.88 PR _______________ Account: 135-50010-020-000 Overtime Totals: 3,281.80 15,668.88 ** 30,000.00 Budgeted 14,331.12 Remaining 52 % 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 1031 03/23/2018 MUD PR 03.23.18 Certification 3,536.00 700.00 4,236.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 700.00 4,236.00 ** 8,400.00 Budgeted 4,164.00 Remaining 50 % Used Account: 135-50020-020-000 Retirement 929 03/09/2018 MUD PR 03.09.18 Retirement 17,803.63 1,641.12 19,444.75 PR 1031 03/23/2018 MUD PR 03.23.18 Retirement 1,639.36 21,084.11 PR _______________ Account: 135-50020-020-000 Retirement Totals: 3,280.48 21,084.11 ** 42,243.00 Budgeted 21,158.89 Remaining 50 % Used Account: 135-50026-020-000 Medical Insurance 929 03/09/2018 MUD PR 03.09.18 Medical Insurance 26,347.50 3,054.24 29,401.74 PR 1031 03/23/2018 MUD PR 03.23.18 Medical Insurance 3,054.21 32,455.95 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 6,108.45 32,455.95 ** 62,175.00 Budgeted 29,719.05 Remaining 52 % Used April 17, 2018 Regular Meeting Agenda Packet 134 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/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 929 03/09/2018 MUD PR 03.09.18 Dental Insurance 1,948.16 193.74 2,141.90 PR 1031 03/23/2018 MUD PR 03.23.18 Dental Insurance 193.71 2,335.61 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 387.45 2,335.61 ** 5,271.00 Budgeted 2,935.39 Remaining 44 % Used Account: 135-50028-020-000 Vision Insurance 929 03/09/2018 MUD PR 03.09.18 Vision Insurance 383.97 32.76 416.73 PR 1031 03/23/2018 MUD PR 03.23.18 Vision Insurance 32.73 449.46 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 65.49 449.46 ** 1,114.00 Budgeted 664.54 Remaining 40 % Used Account: 135-50029-020-000 Life Insurance & Other 865 03/01/2018 March A/P LTD & STD 1,960.19 149.71 2,109.90 METLIFE GROUP BENEFITS 3969 AP 865 03/01/2018 March A/P Dental/Vision/Life Insurance 192.36 2,302.26 Humana Inc 3960 AP 1040 03/23/2018 March A/P FLex admin fee 37.00 2,339.26 BenefitMall 4040 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 379.07 2,339.26 ** 4,281.00 Budgeted 1,941.74 Remaining 55 % Used Account: 135-50030-020-000 Social Security Taxes 929 03/09/2018 MUD PR 03.09.18 Social Security Taxes 10,278.21 1,023.86 11,302.07 PR 1031 03/23/2018 MUD PR 03.23.18 Social Security Taxes 997.63 12,299.70 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 2,021.49 12,299.70 ** 28,314.00 Budgeted 16,014.30 Remaining 43 % Used Account: 135-50035-020-000 Medicare Taxes 929 03/09/2018 MUD PR 03.09.18 Medicare Taxes 2,403.77 239.46 2,643.23 PR 1031 03/23/2018 MUD PR 03.23.18 Medicare Taxes 233.30 2,876.53 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 472.76 2,876.53 ** 6,622.00 Budgeted 3,745.47 Remaining 43 % Used Account: 135-50040-020-000 Unemployment Taxes 929 03/09/2018 MUD PR 03.09.18 Unemployment Taxes 60.88 1.92 62.80 PR April 17, 2018 Regular Meeting Agenda Packet 135 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1031 03/23/2018 MUD PR 03.23.18 Unemployment Taxes 60.88 1,071.20 1,134.00 PR _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: 1,073.12 1,134.00 ** 1,260.00 Budgeted 126.00 Remaining 90 % Used Account: 135-50045-020-000 Workman's Compensation 237 03/01/2018 Insurance/Wrk Comp Exp Mar 6,740.00 1,348.00 8,088.00 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 1,348.00 8,088.00 ** 17,990.00 Budgeted 9,902.00 Remaining 45 % 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 1058 03/28/2018 March A/P Sewer clean out LS #2 SSO call 1,069.50 1,075.50 2,145.00 Ace Pipe Cleaning, Inc. 4037 AP _______________ Account: 135-55070-020-000 Independent Labor Totals: 1,075.50 2,145.00 ** 20,550.00 Budgeted 18,405.00 Remaining 10 % Used Account: 135-55080-020-000 Maintenance & Repairs 1019 03/20/2018 March A/P Blower maintenance 19,177.69 270.84 19,448.53 AIR MAC 4004 AP 1019 03/20/2018 March A/P Blower belts 136.00 19,584.53 AIR MAC 4004 AP 1019 03/20/2018 March A/P LS 2 Emergency Maintenance 905.10 20,489.63 Walker Engineering Inc 4033 AP 1019 03/20/2018 March A/P Bar screen/Grit Bags 1,220.00 21,709.63 Huber Technology Inc 4014 AP 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 THE HOME DEPOT #6581 4.31 21,713.94 THE HOME DEPOT #6581 PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 FUSECO DALLAS 252.45 21,966.39 FUSECO DALLAS PC 1125 03/31/2018 March A/P Pump for LS #9 4,779.00 26,745.39 XYLEM WATER SOLUTIONS USA INC 4085 AP April 17, 2018 Regular Meeting Agenda Packet 136 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 23 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/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-020-000 Maintenance & Repairs Totals: 7,567.70 26,745.39 ** 86,100.00 Budgeted 59,354.61 Remaining 31 % 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 1019 03/20/2018 March A/P Crane truck repairs 3,406.41 406.02 3,812.43 MICHAEL G. WATSON 4023 AP 1020 03/20/2018 March A/P Truck graphics 250.00 4,062.43 M-KAM LTD. 4019 AP 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 DENTON COUNTY, TX SOUT 1.00 4,063.43 DENTON COUNTY, TX SOUT PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 DENTON COUNTY, TX SOUT 33.50 4,096.93 DENTON COUNTY, TX SOUT PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 TX.GOV SERVICEFEE- 2.00 4,098.93 TX.GOV SERVICEFEE- PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 DENTON VEHREG 22.00 4,120.93 DENTON VEHREG PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 DENTON VEHREG 8.25 4,129.18 DENTON VEHREG PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 TX.GOV SERVICEFEE- 2.00 4,131.18 TX.GOV SERVICEFEE- PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 CLASSIC CHEVROLET LT 140.00 4,271.18 CLASSIC CHEVROLET LT PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 ROANOKE AUTO SUPPLY LT 20.96 4,292.14 ROANOKE AUTO SUPPLY LT PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 885.73 4,292.14 ** 8,000.00 Budgeted 3,707.86 Remaining 54 % 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 1019 03/20/2018 March A/P Sludge haul off 35,703.37 1,699.72 37,403.09 L.H. CHANEY MATERIALS, INC. 4018 AP 1019 03/20/2018 March A/P Sludge haul off 2,103.21 39,506.30 L.H. CHANEY MATERIALS, INC. 4018 AP 1058 03/28/2018 March A/P Sludge haul off 1,948.15 41,454.45 L.H. CHANEY MATERIALS, INC. 4060 AP 1128 03/31/2018 March A/P sludge haul off 1,906.32 43,360.77 L.H. CHANEY MATERIALS, INC. 4060 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 7,657.40 43,360.77 ** 60,000.00 Budgeted 16,639.23 Remaining 72 % Used April 17, 2018 Regular Meeting Agenda Packet 137 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 24 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55135-020-000 Lab Analysis 1019 03/20/2018 March A/P Lab testing 16,462.82 176.00 16,638.82 OXIDOR LABORATORIES LLC 4025 AP 1019 03/20/2018 March A/P Lab testing 246.00 16,884.82 OXIDOR LABORATORIES LLC 4025 AP 1019 03/20/2018 March A/P Lab testing 176.00 17,060.82 OXIDOR LABORATORIES LLC 4025 AP 1040 03/23/2018 March A/P Lab tests 246.00 17,306.82 OXIDOR LABORATORIES LLC 4069 AP 1040 03/23/2018 March A/P Lab tests 176.00 17,482.82 OXIDOR LABORATORIES LLC 4069 AP 1058 03/28/2018 March A/P Lab tests 246.00 17,728.82 OXIDOR LABORATORIES LLC 4069 AP 1058 03/28/2018 March A/P Lab tests 176.00 17,904.82 OXIDOR LABORATORIES LLC 4069 AP 1125 03/31/2018 March A/P Lab analysis 246.00 18,150.82 OXIDOR LABORATORIES LLC 4069 AP 1132 03/31/2018 March A/P Lab analysis 176.00 18,326.82 OXIDOR LABORATORIES LLC 4069 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 1,864.00 18,326.82 ** 30,000.00 Budgeted 11,673.18 Remaining 61 % Used Account: 135-60010-020-000 Communications/Mobiles 989 03/14/2018 March A/P Mobile phones 2,102.05 382.10 2,484.15 VERIZON WIRELESS 4031 AP 1179 03/31/2018 March A/P Cell phones 381.57 2,865.72 VERIZON WIRELESS AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 763.67 2,865.72 ** 4,700.00 Budgeted 1,834.28 Remaining 61 % Used Account: 135-60020-020-000 Electricity 989 03/14/2018 March A/P Electricity 1/25-2/26 73,158.80 205.62 73,364.42 TRI COUNTY ELECTRIC 4030 AP 989 03/14/2018 March A/P Electricity 1/25-2/26 312.99 73,677.41 TRI COUNTY ELECTRIC 4030 AP 989 03/14/2018 March A/P Electricity 1/25-2/26 27.99 73,705.40 TRI COUNTY ELECTRIC 4030 AP 1019 03/20/2018 March A/P Electricity 2/8-3/9 12,496.95 86,202.35 HUDSON ENERGY SERVICES, LLC 4016 AP 1175 03/31/2018 Town Billed Invoice #1628-1631 AR 20180331-20180331 User: (319.19) 85,883.16 AR 1179 03/31/2018 March A/P Electricity 2/26-3/26 176.28 86,059.44 TRI COUNTY ELECTRIC AP 1179 03/31/2018 March A/P Electricity 2/26-3/26 298.04 86,357.48 TRI COUNTY ELECTRIC AP 1179 03/31/2018 March A/P Electricity 2/26-3/26 27.68 86,385.16 TRI COUNTY ELECTRIC AP _______________ Account: 135-60020-020-000 Electricity Totals: 13,226.36 86,385.16 ** 266,709.00 Budgeted 180,323.84 Remaining 32 % 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 April 17, 2018 Regular Meeting Agenda Packet 138 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/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 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 TCEQ IND RENEWAL L 111.00 111.00 TCEQ IND RENEWAL L PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 TCEQ IND RENEWAL L 111.00 222.00 TCEQ IND RENEWAL L PC _______________ Account: 135-60080-020-000 Schools & Training Totals: 222.00 222.00 ** 5,677.00 Budgeted 5,455.00 Remaining 4 % Used Account: 135-60090-020-000 Safety Program 8.37 .00 8.37 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 8.37 ** 550.00 Budgeted 541.63 Remaining 2 % Used Account: 135-60100-020-000 Travel & per diem 73.06 .00 73.06 _______________ Account: 135-60100-020-000 Travel & per diem Totals: .00 73.06 ** 1,635.00 Budgeted 1,561.94 Remaining 4 % 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 April 17, 2018 Regular Meeting Agenda Packet 139 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/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 1125 03/31/2018 March A/P March mowing 1,770.00 590.00 2,360.00 WATTS ELLISON LLC 4083 AP _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 590.00 2,360.00 ** 11,600.00 Budgeted 9,240.00 Remaining 20 % Used Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S 1066 03/31/2018 Texpool Transfers March 55,474.05 11,094.81 66,568.86 GL _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 11,094.81 66,568.86 ** 122,043.00 Budgeted 55,474.14 Remaining 55 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S 1066 03/31/2018 Texpool Transfers March 272,153.60 54,430.72 326,584.32 GL _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: 54,430.72 326,584.32 ** 598,738.00 Budgeted 272,153.68 Remaining 55 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 1066 03/31/2018 Texpool Transfers March 51,390.00 10,278.00 61,668.00 GL April 17, 2018 Regular Meeting Agenda Packet 140 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/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 61,668.00 ** 123,336.00 Budgeted 61,668.00 Remaining 50 % 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 .00 .00 _______________ Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Account: 135-65005-020-000 Fuel & Lube 1058 03/28/2018 March A/P Fuel 3,731.07 1,004.37 4,735.44 US Bank Voyager Fleet Systems 4080 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 1,004.37 4,735.44 ** 12,500.00 Budgeted 7,764.56 Remaining 38 % 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 1040 03/23/2018 March A/P 4 barrels of MBR chemicals 3,892.03 874.60 4,766.63 Valley Solvent Company, INC AP 1059 03/23/2018 corrected inv received 4 barrels of MBR chemicals (874.60) 3,892.03 Valley Solvent Company, INC AP 1058 03/28/2018 March A/P 4 barrels of MBR chemicals 684.72 4,576.75 Valley Solvent Company, INC 4081 AP 1147 03/31/2018 March A/P 4 barrels of MBR chemicals 674.60 5,251.35 Valley Solvent Company, INC 4091 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 1,359.32 5,251.35 ** 27,500.00 Budgeted 22,248.65 Remaining 19 % Used Account: 135-65035-020-000 Small Tools April 17, 2018 Regular Meeting Agenda Packet 141 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 28 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 LOWES #00732* 1,118.21 20.78 1,138.99 LOWES #00732* PC _______________ Account: 135-65035-020-000 Small Tools Totals: 20.78 1,138.99 ** 1,000.00 Budgeted (138.99) Remaining 114 % Used Account: 135-65040-020-000 Safety Equipment 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 LOWES #00732* 260.00 54.90 314.90 LOWES #00732* PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 TX AMERICA SAFETY 78.00 392.90 TX AMERICA SAFETY PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 TX AMERICA SAFETY 79.50 472.40 TX AMERICA SAFETY PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 AMAZON.COM 114.17 586.57 AMAZON.COM PC _______________ Account: 135-65040-020-000 Safety Equipment Totals: 326.57 586.57 ** 750.00 Budgeted 163.43 Remaining 78 % Used Account: 135-65045-020-000 Lab Supplies 1019 03/20/2018 March A/P sample bottles 5,671.38 1,317.75 6,989.13 IDEXX DISTRIBUTION, INC 4017 AP 1019 03/20/2018 March A/P E Coli 686.55 7,675.68 IDEXX DISTRIBUTION, INC 4017 AP 1040 03/23/2018 March A/P WOrk latex gloves 162.00 7,837.68 LOU'S GLOVES INCORPORATED 4064 AP 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 KROGER #0512 1.78 7,839.46 KROGER #0512 PC _______________ Account: 135-65045-020-000 Lab Supplies Totals: 2,168.08 7,839.46 ** 14,000.00 Budgeted 6,160.54 Remaining 56 % Used Account: 135-69005-020-000 Capital Outlays 989 03/14/2018 March A/P 2018 Chevrolet Silverado 15,054.43 32,225.00 47,279.43 CALDWELL COUNTRY CHEVROLET 4006 AP 989 03/14/2018 March A/P 2018 Chevy Silverado 27,915.00 75,194.43 CALDWELL COUNTRY CHEVROLET 4006 AP 1019 03/20/2018 March A/P Legal WWTP 1,062.50 76,256.93 Dubois Bryant Campbell LLP 4010 AP 1019 03/20/2018 March A/P Legal WWTP 1,062.50 77,319.43 Dubois Bryant Campbell LLP 4010 AP 1132 03/31/2018 March A/P WWTP Improvements 232,136.35 309,455.78 WEBBER-CADAGUA PARTNERS 4084 AP _______________ Account: 135-69005-020-000 Capital Outlays Totals: 294,401.35 309,455.78 ** 547,327.00 Budgeted 237,871.22 Remaining 57 % 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 April 17, 2018 Regular Meeting Agenda Packet 142 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 29 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/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-69009-020-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-020-000 Short Term Debt-Interest Totals: .00 .00 ** 7,573.00 Budgeted 7,573.00 Remaining 0 % Used Account: 135-69195-020-000 Gasb34/Reserve for Replacement 30,000.00 .00 30,000.00 _______________ Account: 135-69195-020-000 Gasb34/Reserve for Replacement Totals: .00 30,000.00 ** 30,000.00 Budgeted .00 Remaining 100 % Used Department 20 Totals: ----------------------------------- 1,328,256.80 ** 459,537.40 Monthly Total 2,981,140.00 Budgeted 1,652,883.20 Remaining 45 % Used April 17, 2018 Regular Meeting Agenda Packet 143 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 3/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 237 03/01/2018 Insurance/Wrk Comp Exp Mar 12.10 2.42 14.52 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.42 14.52 ** 30.00 Budgeted 15.48 Remaining 48 % 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 .00 .00 _______________ Account: 135-60075-026-000 Meetings Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-60080-026-000 Schools & Training 1,135.00 .00 1,135.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 1,135.00 ** 4,000.00 Budgeted 2,865.00 Remaining 28 % 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 April 17, 2018 Regular Meeting Agenda Packet 144 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1,021.73 .00 1,021.73 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 1,021.73 ** 2,000.00 Budgeted 978.27 Remaining 51 % Used Department 26 Totals: ----------------------------------- 3,781.25 ** 2.42 Monthly Total 12,980.00 Budgeted 9,198.75 Remaining 29 % Used April 17, 2018 Regular Meeting Agenda Packet 145 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/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 929 03/09/2018 MUD PR 03.09.18 Salaries & Wages 155,434.79 12,579.56 168,014.35 PR 1031 03/23/2018 MUD PR 03.23.18 Salaries & Wages 12,614.06 180,628.41 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 25,193.62 180,628.41 ** 432,863.00 Budgeted 252,234.59 Remaining 42 % Used Account: 135-50010-030-000 Overtime 929 03/09/2018 MUD PR 03.09.18 Overtime 410.65 6.93 417.58 PR 1031 03/23/2018 MUD PR 03.23.18 Overtime 39.09 456.67 PR _______________ Account: 135-50010-030-000 Overtime Totals: 46.02 456.67 ** 2,000.00 Budgeted 1,543.33 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 929 03/09/2018 MUD PR 03.09.18 Retirement 17,050.78 1,164.26 18,215.04 PR 1031 03/23/2018 MUD PR 03.23.18 Retirement 1,170.41 19,385.45 PR _______________ Account: 135-50020-030-000 Retirement Totals: 2,334.67 19,385.45 ** 40,553.00 Budgeted 21,167.55 Remaining 48 % Used Account: 135-50026-030-000 Medical Insurance 929 03/09/2018 MUD PR 03.09.18 Medical Insurance 19,047.97 2,072.63 21,120.60 PR 1031 03/23/2018 MUD PR 03.23.18 Medical Insurance 2,072.61 23,193.21 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,145.24 23,193.21 ** 63,485.00 Budgeted 40,291.79 Remaining 37 % Used Account: 135-50027-030-000 Dental Insurance 929 03/09/2018 MUD PR 03.09.18 Dental Insurance 1,493.40 129.78 1,623.18 PR 1031 03/23/2018 MUD PR 03.23.18 Dental Insurance 129.74 1,752.92 PR April 17, 2018 Regular Meeting Agenda Packet 146 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/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 1,752.92 ** 5,502.00 Budgeted 3,749.08 Remaining 32 % Used Account: 135-50028-030-000 Vision Insurance 929 03/09/2018 MUD PR 03.09.18 Vision Insurance 298.90 21.28 320.18 PR 1031 03/23/2018 MUD PR 03.23.18 Vision Insurance 21.23 341.41 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 42.51 341.41 ** 1,173.00 Budgeted 831.59 Remaining 29 % Used Account: 135-50029-030-000 Life Insurance & Other 865 03/01/2018 March A/P LTD & STD 1,703.90 48.85 1,752.75 METLIFE GROUP BENEFITS 3969 AP 865 03/01/2018 March A/P Dental/Vision/Life Insurance 145.04 1,897.79 Humana Inc 3960 AP 1040 03/23/2018 March A/P FLex admin fee 18.50 1,916.29 BenefitMall 4040 AP 1141 03/31/2018 March A/P Clean up for new Employee Add 4.00 1,920.29 Legal Shield 4090 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 216.39 1,920.29 ** 5,059.00 Budgeted 3,138.71 Remaining 38 % Used Account: 135-50030-030-000 Social Security Taxes 929 03/09/2018 MUD PR 03.09.18 Social Security Taxes 9,501.76 742.58 10,244.34 PR 1031 03/23/2018 MUD PR 03.23.18 Social Security Taxes 743.85 10,988.19 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 1,486.43 10,988.19 ** 27,181.00 Budgeted 16,192.81 Remaining 40 % Used Account: 135-50035-030-000 Medicare Taxes 929 03/09/2018 MUD PR 03.09.18 Medicare Taxes 2,222.16 173.69 2,395.85 PR 1031 03/23/2018 MUD PR 03.23.18 Medicare Taxes 173.96 2,569.81 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 347.65 2,569.81 ** 6,357.00 Budgeted 3,787.19 Remaining 40 % Used Account: 135-50040-030-000 Unemployment Taxes 929 03/09/2018 MUD PR 03.09.18 Unemployment Taxes 54.70 4.28 58.98 PR 1031 03/23/2018 MUD PR 03.23.18 Unemployment Taxes 842.92 901.90 PR April 17, 2018 Regular Meeting Agenda Packet 147 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 34 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/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: 847.20 901.90 ** 1,260.00 Budgeted 358.10 Remaining 72 % Used Account: 135-50045-030-000 Workman's Compensation 237 03/01/2018 Insurance/Wrk Comp Exp Mar 617.50 123.50 741.00 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 123.50 741.00 ** 1,529.00 Budgeted 788.00 Remaining 48 % 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 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 TOM THUMB #1789 2,320.79 15.68 2,336.47 TOM THUMB #1789 PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 HOT & CREAMY DONUTS 11.79 2,348.26 HOT & CREAMY DONUTS PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 27.47 2,348.26 ** 4,960.00 Budgeted 2,611.74 Remaining 47 % Used Account: 135-55030-030-000 Software & Support 1019 03/20/2018 March A/P Software update 43,128.59 72.50 43,201.09 STW INC 4026 AP 1019 03/20/2018 March A/P Office 365 lease 168.00 43,369.09 M3 Networks 4020 AP 1020 03/20/2018 March A/P Internet 976.21 44,345.30 Charter Communications 4007 AP 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 CANVA FOR WORK MONTHLY 12.95 44,358.25 CANVA FOR WORK MONTHLY PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 ADOBE SYSTEMS INC 16.23 44,374.48 ADOBE SYSTEMS INC PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 ATT*BILL PAYMENT 112.07 44,486.55 ATT*BILL PAYMENT PC _______________ Account: 135-55030-030-000 Software & Support Totals: 1,357.96 44,486.55 ** 78,391.00 Budgeted 33,904.45 Remaining 57 % Used Account: 135-55070-030-000 Independent Labor 1125 03/31/2018 March A/P STW consulting 63,070.84 103.34 63,174.18 DRG ENTERPRISES 4048 AP 1132 03/31/2018 March A/P GM March 2018 11,000.58 74,174.76 Carman Consulting LLC. 4035 AP April 17, 2018 Regular Meeting Agenda Packet 148 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 35 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/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-55070-030-000 Independent Labor Totals: 11,103.92 74,174.76 ** 154,000.00 Budgeted 79,825.24 Remaining 48 % Used Account: 135-55080-030-000 Maintenance & Repairs 1019 03/20/2018 March A/P A/C Mud building 2,281.50 170.00 2,451.50 BRANDON R REED 4005 AP 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 MICHAELS KEYS 24.23 2,475.73 MICHAELS KEYS PC _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: 194.23 2,475.73 ** 14,000.00 Budgeted 11,524.27 Remaining 18 % Used Account: 135-55085-030-000 Generator Maint. and Repair .00 .00 _______________ Account: 135-55085-030-000 Generator Maint. and Repair Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-55120-030-000 Cleaning Services 1019 03/20/2018 March A/P Janitorial services 3,093.33 869.06 3,962.39 MEMBER'S BUILDING MAINTENANCE 4022 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 869.06 3,962.39 ** 10,000.00 Budgeted 6,037.61 Remaining 40 % Used Account: 135-55160-030-000 Professional Outside Services 1040 03/23/2018 March A/P Winter average rates 56,475.00 2,765.00 59,240.00 NEW GEN STRATEGIES & SOLUTIONS 4068 AP _______________ Account: 135-55160-030-000 Professional Outside Services Totals: 2,765.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 1155 03/31/2018 March A/P March mailings 2,974.25 977.54 3,951.79 DATAPROSE LLC 4092 AP April 17, 2018 Regular Meeting Agenda Packet 149 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 977.54 3,951.79 ** 9,000.00 Budgeted 5,048.21 Remaining 44 % Used Account: 135-60005-030-000 Telephone 1040 03/23/2018 March A/P answering service 7,388.97 194.75 7,583.72 KEYSTONE PARK SECRETARIAL 4057 AP 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 RINGCENTRAL, INC 13.96 7,597.68 RINGCENTRAL, INC PC 1175 03/31/2018 Town Billed Invoice #1628-1631 AR 20180331-20180331 User: (180.00) 7,417.68 AR _______________ Account: 135-60005-030-000 Telephone Totals: 28.71 7,417.68 ** 27,300.00 Budgeted 19,882.32 Remaining 27 % Used Account: 135-60010-030-000 Communications/Mobiles 989 03/14/2018 March A/P Mobile phones 1,324.62 87.44 1,412.06 VERIZON WIRELESS 4031 AP 1031 03/23/2018 MUD PR 03.23.18 Communications/Mobiles 150.00 1,562.06 PR 1179 03/31/2018 March A/P Cell phones 87.37 1,649.43 VERIZON WIRELESS AP _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 324.81 1,649.43 ** 4,000.00 Budgeted 2,350.57 Remaining 41 % Used Account: 135-60020-030-000 Electricity/Gas 1125 03/31/2018 March A/P 12/8-1/10 & 1/10-2/8 Electrici 1,697.60 1,409.08 3,106.68 TOWN OF TROPHY CLUB 4078 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 1,409.08 3,106.68 ** 16,261.00 Budgeted 13,154.32 Remaining 19 % Used Account: 135-60025-030-000 Water 1125 03/31/2018 March A/P MUD admin water 285.76 106.71 392.47 TROPHY CLUB MUD (WATER BILLS) 4079 AP 1175 03/31/2018 Town Billed Invoice #1628-1631 AR 20180331-20180331 User: (53.35) 339.12 AR _______________ Account: 135-60025-030-000 Water Totals: 53.36 339.12 ** 2,500.00 Budgeted 2,160.88 Remaining 14 % Used Account: 135-60030-030-000 Rent And/Or Usage 616.40 .00 616.40 _______________ Account: 135-60030-030-000 Rent And/Or Usage Totals: .00 616.40 ** .00 Budgeted (616.40) Remaining 0 % Used April 17, 2018 Regular Meeting Agenda Packet 150 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 37 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60035-030-000 Postage 1155 03/31/2018 March A/P March mailings 9,651.64 3,013.63 12,665.27 DATAPROSE LLC 4092 AP _______________ Account: 135-60035-030-000 Postage Totals: 3,013.63 12,665.27 ** 30,000.00 Budgeted 17,334.73 Remaining 42 % Used Account: 135-60040-030-000 Service Charges & Fees 930 03/09/2018 Child Support Fee 25,547.54 1.50 25,549.04 GL 1032 03/23/2018 Child Support Fee 1.50 25,550.54 GL 1001 03/31/2018 Pace Credit Card Fees 4,104.89 29,655.43 GL 1001 03/31/2018 Pace Credit Card Fees 90.69 29,746.12 GL 1125 03/31/2018 March A/P Direct Send fees 50.00 29,796.12 Fiserv Solutions, LLC 4049 AP _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 4,248.58 29,796.12 ** 55,560.00 Budgeted 25,763.88 Remaining 54 % 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 237 03/01/2018 Insurance/Wrk Comp Exp Mar 33,726.80 6,100.36 39,827.16 GL 989 03/14/2018 March A/P Notary-D'Andria 50.00 39,877.16 VICTOR O SCHINNERER & CO, INC 4032 AP _______________ Account: 135-60055-030-000 Insurance Totals: 6,150.36 39,877.16 ** 56,000.00 Budgeted 16,122.84 Remaining 71 % Used Account: 135-60066-030-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,600.00 Budgeted 1,600.00 Remaining 0 % Used Account: 135-60070-030-000 Dues & Memberships 1019 03/20/2018 March A/P Toilet tablets 3,808.42 20.00 3,828.42 Texas Water Development Board 4028 AP April 17, 2018 Regular Meeting Agenda Packet 151 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 20.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 _______________ 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 2,693.00 .00 2,693.00 _______________ Account: 135-60080-030-000 Schools & Training Totals: .00 2,693.00 ** 7,600.00 Budgeted 4,907.00 Remaining 35 % Used Account: 135-60100-030-000 Travel & per diem 929 03/09/2018 MUD PR 03.09.18 Travel & per diem 582.17 17.66 599.83 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 17.66 599.83 ** 4,885.00 Budgeted 4,285.17 Remaining 12 % 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 145.00 .00 145.00 April 17, 2018 Regular Meeting Agenda Packet 152 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60115-030-000 Elections Totals: .00 145.00 ** 4,500.00 Budgeted 4,355.00 Remaining 3 % Used Account: 135-60125-030-000 Advertising .00 .00 _______________ Account: 135-60125-030-000 Advertising Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-60235-030-000 Security 1040 03/23/2018 March A/P monthly monitoring fee for pan 48.00 24.00 72.00 Digital Air Control, Inc 4045 AP _______________ Account: 135-60235-030-000 Security Totals: 24.00 72.00 ** 2,700.00 Budgeted 2,628.00 Remaining 3 % 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 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 WM SUPERCENTER #5247 23.00 23.00 WM SUPERCENTER #5247 PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 RED WING SHOES #652 114.74 137.74 RED WING SHOES #652 PC April 17, 2018 Regular Meeting Agenda Packet 153 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 40 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65010-030-000 Uniforms Totals: 137.74 137.74 ** 700.00 Budgeted 562.26 Remaining 20 % Used Account: 135-65055-030-000 Hardware 597.95 .00 597.95 _______________ Account: 135-65055-030-000 Hardware Totals: .00 597.95 ** 7,420.00 Budgeted 6,822.05 Remaining 8 % Used Account: 135-65085-030-000 Office Supplies 1020 03/20/2018 March A/P Office supplies 2,612.69 36.36 2,649.05 OFFICE DEPOT, INC 4024 AP 1020 03/20/2018 March A/P office supplies 34.55 2,683.60 OFFICE DEPOT, INC 4024 AP 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 STAPLES 00116533 137.14 2,820.74 STAPLES 00116533 PC 1179 03/31/2018 March A/P Office supplies 55.47 2,876.21 OFFICE DEPOT, INC AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 263.52 2,876.21 ** 7,000.00 Budgeted 4,123.79 Remaining 41 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 1179 03/31/2018 March A/P Office supplies 1,903.05 145.61 2,048.66 OFFICE DEPOT, INC AP _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 145.61 2,048.66 ** 2,000.00 Budgeted (48.66) Remaining 102 % Used Account: 135-65095-030-000 Maintenance Supplies 1020 03/20/2018 March A/P coffee 2,061.86 51.86 2,113.72 OFFICE DEPOT, INC 4024 AP 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 COFFEEICON COM 39.98 2,153.70 COFFEEICON COM PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 SAMS CLUB #4795 99.50 2,253.20 SAMS CLUB #4795 PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 SAMSCLUB.COM 65.22 2,318.42 SAMSCLUB.COM PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 TOM THUMB #1789 46.93 2,365.35 TOM THUMB #1789 PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 AMAZON MKTPLACE PMTS 138.53 2,503.88 AMAZON MKTPLACE PMTS PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 STAPLES DIRECT 61.71 2,565.59 STAPLES DIRECT PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 AMAZON.COM 16.09 2,581.68 AMAZON.COM PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 WALMART.COM 43.27 2,624.95 WALMART.COM PC 1135 03/26/2018 Pcard 02/27/18 - 03/26/18 AMAZON MKTPLACE PMTS 21.36 2,646.31 AMAZON MKTPLACE PMTS PC 1179 03/31/2018 March A/P COffe supplies-breakroom 106.32 2,752.63 OFFICE DEPOT, INC AP 1179 03/31/2018 March A/P Office supplies 34.77 2,787.40 OFFICE DEPOT, INC AP 1179 03/31/2018 March A/P Breakroom 34.99 2,822.39 OFFICE DEPOT, INC AP April 17, 2018 Regular Meeting Agenda Packet 154 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/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-65095-030-000 Maintenance Supplies Totals: 760.53 2,822.39 ** 4,000.00 Budgeted 1,177.61 Remaining 71 % 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 7,841.00 .00 7,841.00 _______________ Account: 135-69005-030-000 Capital Outlays Totals: .00 7,841.00 ** 13,000.00 Budgeted 5,159.00 Remaining 60 % Used Account: 135-69170-030-000 Copier Lease Installments 989 03/14/2018 March A/P Copier Lease 1,229.02 165.00 1,394.02 EVERBANK COMMERCIAL FINANCE 4011 AP 1040 03/23/2018 March A/P Copies/lease 82.12 1,476.14 KYOCERA DOCUMENT SOLUTIONS 4059 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 247.12 1,476.14 ** 4,600.00 Budgeted 3,123.86 Remaining 32 % Used Department 30 Totals: ----------------------------------- 558,326.50 ** 69,182.64 Monthly Total 1,227,112.00 Budgeted 668,785.50 Remaining 45 % Used April 17, 2018 Regular Meeting Agenda Packet 155 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 3/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 989 03/14/2018 March A/P Legal 29,343.55 3,270.00 32,613.55 McLean & Howard, L.L.P. 4021 AP 989 03/14/2018 March A/P Legal 1,050.00 33,663.55 McLean & Howard, L.L.P. 4021 AP 1179 03/31/2018 March A/P legal 2,100.00 35,763.55 McLean & Howard, L.L.P. AP 1179 03/31/2018 March A/P Legal 1,050.00 36,813.55 McLean & Howard, L.L.P. AP _______________ Account: 135-55045-039-000 Legal Totals: 7,470.00 36,813.55 ** 137,000.00 Budgeted 100,186.45 Remaining 27 % 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 923 03/07/2018 March A/P Appraisal 2nd Qtr Budget 2018 4,660.18 2,011.87 6,672.05 DENTON CENTRAL APPRAISAL DISTR 3980 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 2,011.87 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: ----------------------------------- 71,962.70 ** 9,481.87 Monthly Total 176,746.00 Budgeted 104,783.30 Remaining 41 % Used Fund 135 Totals: ----------------------------------- (178,897.19) 222,273.26 Monthly Total (194,618.00) Budgeted (15,720.81) Remaining 92 % Used April 17, 2018 Regular Meeting Agenda Packet 156 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 43 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 3/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 April 17, 2018 Regular Meeting Agenda Packet 157 of 202 TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET MARCH 2018 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 363,680 ACCOUNTS RECEIVABLE - TOTAL ASSETS 363,680 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 680,448 TOTAL LIABILITIES 680,448 FUND BALANCE ASSIGNED FUND BALANCE 992,579 NET REVENUES / EXPENDITURES (1,309,346) TOTAL FUND BALANCE (316,767) TOTAL LIABILITIES AND FUND BALANCE 363,680 April 17, 2018 Regular Meeting Agenda Packet 158 of 202 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 14 23:00 04/11/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 3/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 1,507.06- 8,705.84- 8,705.84 Subtotal: 1,507.06- 8,705.84- 8,705.84 Program number: 1,507.06- 8,705.84- 8,705.84 Department number: Revenues 1,507.06- 8,705.84- 8,705.84 Revenues Subtotal ----------- 1,507.06- 8,705.84- 8,705.84 April 17, 2018 Regular Meeting Agenda Packet 159 of 202 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 15 23:00 04/11/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 3/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-69005-020-000 Capital Outlays 668,708.17 1,318,052.33 1,318,052.33- Subtotal: 668,708.17 1,318,052.33 1,318,052.33- Program number: 668,708.17 1,318,052.33 1,318,052.33- Department number: Wastewater 668,708.17 1,318,052.33 1,318,052.33- Expenditures Subtotal ----------- 668,708.17 1,318,052.33 1,318,052.33- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 667,201.11 1,309,346.49 1,309,346.49- April 17, 2018 Regular Meeting Agenda Packet 160 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 44 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 3/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 1067 03/31/2018 Bank Interest- March (7,198.78) (1,507.06) (8,705.84) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (1,507.06) (8,705.84) ** .00 Budgeted 8,705.84 Remaining 0 % Used Department Totals: ----------------------------------- (8,705.84) ** (1,507.06) Monthly Total .00 Budgeted 8,705.84 Remaining 0 % Used April 17, 2018 Regular Meeting Agenda Packet 161 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 3/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 989 03/14/2018 March A/P WWTP Improvements App 26 649,344.16 634,924.19 1,284,268.35 WEBBER-CADAGUA PARTNERS 4034 AP 1019 03/20/2018 March A/P WWTP Improvements 33,783.98 1,318,052.33 CP&Y/WALLACE GROUP, INC. 4009 AP _______________ Account: 517-69005-020-000 Capital Outlays Totals: 668,708.17 1,318,052.33 ** .00 Budgeted (1,318,052.33) Remaining 0 % Used Department 20 Totals: ----------------------------------- 1,318,052.33 ** 668,708.17 Monthly Total .00 Budgeted (1,318,052.33) Remaining 0 % Used Fund 517 Totals: ----------------------------------- 1,309,346.49 667,201.11 Monthly Total .00 Budgeted (1,309,346.49) Remaining 0 % Used April 17, 2018 Regular Meeting Agenda Packet 162 of 202 TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION SWIFT FUNDING BALANCE SHEET MARCH 2018 519 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - CASH IN ESCROW 1,803,320 INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS 1,803,320 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 270,948 TOTAL LIABILITIES 270,948 FUND BALANCE ASSIGNED FUND BALANCE 4,225,581 NET REVENUES / EXPENDITURES (2,693,209) TOTAL FUND BALANCE 1,532,372 TOTAL LIABILITIES AND FUND BALANCE 1,803,320 April 17, 2018 Regular Meeting Agenda Packet 163 of 202 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 16 23:00 04/11/18 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const-SWIFT Department: 10 Water Program: Period Ending: 3/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 519-69005-010-000 Capital Outlays 2,693,208.68 2,693,208.68 2,693,208.68- Subtotal: 2,693,208.68 2,693,208.68 2,693,208.68- Program number: 2,693,208.68 2,693,208.68 2,693,208.68- Department number: Water 2,693,208.68 2,693,208.68 2,693,208.68- Expenditures Subtotal ----------- 2,693,208.68 2,693,208.68 2,693,208.68- Fund number: 519 2016 Rev Bond Const-SWIFT 2,693,208.68 2,693,208.68 2,693,208.68- April 17, 2018 Regular Meeting Agenda Packet 164 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const-SWIFT Department: 10 Water Program: Period Ending: 3/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-69005-010-000 Capital Outlays 1183 03/16/2018 NSII Fort Worth Wire 30in Capt 2,693,208.68 2,693,208.68 GL 1184 03/16/2018 NSII Fort Worth 30in Wire 135 2,693,208.68 5,386,417.36 GL 1185 03/16/2018 REV- NSII Fort Worth Wire 30in (2,693,208.68) 2,693,208.68 GL _______________ Account: 519-69005-010-000 Capital Outlays Totals: 2,693,208.68 2,693,208.68 ** .00 Budgeted (2,693,208.68) Remaining 0 % Used Department 10 Totals: ----------------------------------- 2,693,208.68 ** 2,693,208.68 Monthly Total .00 Budgeted (2,693,208.68) Remaining 0 % Used Fund 519 Totals: ----------------------------------- 2,693,208.68 2,693,208.68 Monthly Total .00 Budgeted (2,693,208.68) Remaining 0 % Used April 17, 2018 Regular Meeting Agenda Packet 165 of 202 TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET MARCH 2018 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 515,627 ACCOUNTS RECEIVABLE - TOTAL ASSETS 515,627 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 426,579 NET REVENUES / EXPENDITURES 89,048 TOTAL FUND BALANCE 515,627 TOTAL LIABILITIES AND FUND BALANCE 515,627 April 17, 2018 Regular Meeting Agenda Packet 166 of 202 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 17 23:00 04/11/18 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 3/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- 646.32- 2,882.27- 288.227 1,882.27 528-49142-000-000 Interfund transfer in-Water 48,996.00- 48,996.00- 4,083.00- 24,498.00- 50.000 24,498.00- 528-49143-000-000 Interfund transfer in-WW 123,336.00- 123,336.00- 10,278.00- 61,668.00- 50.000 61,668.00- Subtotal: 173,332.00- 173,332.00- 15,007.32- 89,048.27- 51.374 84,283.73- Program number: 173,332.00- 173,332.00- 15,007.32- 89,048.27- 51.374 84,283.73- Department number: 173,332.00- 173,332.00- 15,007.32- 89,048.27- 51.374 84,283.73- Revenues Subtotal ----------- 173,332.00- 173,332.00- 15,007.32- 89,048.27- 51.374 84,283.73- Fund number: 528 2015 Revenue Bond Reserve Fund 173,332.00- 173,332.00- 15,007.32- 89,048.27- 51.374 84,283.73- April 17, 2018 Regular Meeting Agenda Packet 167 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 47 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 3/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 1067 03/31/2018 Bank Interest- March (2,235.95) (646.32) (2,882.27) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (646.32) (2,882.27) ** (1,000.00) Budgeted 1,882.27 Remaining 288 % Used Account: 528-49142-000-000 Interfund transfer in-Water 1066 03/31/2018 Texpool Transfers March (20,415.00) (4,083.00) (24,498.00) GL _______________ Account: 528-49142-000-000 Interfund transfer in-Water Totals: (4,083.00) (24,498.00) ** (48,996.00) Budgeted (24,498.00) Remaining 50 % Used Account: 528-49143-000-000 Interfund transfer in-WW 1066 03/31/2018 Texpool Transfers March (51,390.00) (10,278.00) (61,668.00) GL _______________ Account: 528-49143-000-000 Interfund transfer in-WW Totals: (10,278.00) (61,668.00) ** (123,336.00) Budgeted (61,668.00) Remaining 50 % Used Department Totals: ----------------------------------- (89,048.27) ** (15,007.32) Monthly Total (173,332.00) Budgeted (84,283.73) Remaining 51 % Used Fund 528 Totals: ----------------------------------- (89,048.27) (15,007.32) Monthly Total (173,332.00) Budgeted (84,283.73) Remaining 51 % Used April 17, 2018 Regular Meeting Agenda Packet 168 of 202 TROPHY CLUB MUD #1 - I&S BALANCE SHEET MARCH 2018 INTEREST & SINKING- 533 ASSETS CASH IN BANK 4,573 INVESTMENTS 842,208 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 24,530 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 871,311 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 24,530 ACCOUNTS AND OTHER PAYABLES 915 TOTAL LIABILITIES 25,445 FUND BALANCE ASSIGNED FUND BALANCE 32,341 NET REVENUES / EXPENDITURES 813,525 TOTAL FUND BALANCE 845,866 TOTAL LIABILITIES AND FUND BALANCE 871,311 April 17, 2018 Regular Meeting Agenda Packet 169 of 202 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 18 23:00 04/11/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 3/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- 9,065.28- 664,307.38- 99.201 5,352.62- 533-40002-000-000 Property Taxes/Delinquent 1,800.00- 1,800.00- 147.00- 2,030.81- 112.823 230.81 533-40015-000-000 Property Taxes/P & I 2,000.00- 2,000.00- 431.48- 1,021.90- 51.095 978.10- Subtotal: 673,460.00- 673,460.00- 9,643.76- 667,360.09- 99.094 6,099.91- 533-49010-000-000 Interest Income 2,000.00- 2,000.00- 1,061.79- 2,595.85- 129.792 595.85 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- 66,568.86- 54.545 55,474.14- Subtotal: 342,997.00- 342,997.00- 12,156.60- 288,118.71- 84.000 54,878.29- Program number: 1,016,457.00- 1,016,457.00- 21,800.36- 955,478.80- 94.001 60,978.20- Department number: Revenues 1,016,457.00- 1,016,457.00- 21,800.36- 955,478.80- 94.001 60,978.20- Revenues Subtotal ----------- 1,016,457.00- 1,016,457.00- 21,800.36- 955,478.80- 94.001 60,978.20- April 17, 2018 Regular Meeting Agenda Packet 170 of 202 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 19 23:00 04/11/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 3/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 200.00 9.302 1,950.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 141,953.75 14.046 868,704.25 Program number: 1,010,658.00 1,010,658.00 141,953.75 14.046 868,704.25 Department number: Administration 1,010,658.00 1,010,658.00 141,953.75 14.046 868,704.25 Expenditures Subtotal ----------- 1,010,658.00 1,010,658.00 141,953.75 14.046 868,704.25 Fund number: 533 MUD 1 I&S Consolidated 5,799.00- 5,799.00- 21,800.36- 813,525.05- ############### 807,726.05 April 17, 2018 Regular Meeting Agenda Packet 171 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 48 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 3/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 1097 03/01/2018 Property Taxes (655,242.10) (453.14) (655,695.24) GL 1098 03/02/2018 Property Taxes (1,285.37) (656,980.61) GL 1099 03/05/2018 Property Taxes (761.56) (657,742.17) GL 1100 03/06/2018 Property Taxes (309.26) (658,051.43) GL 1101 03/07/2018 Property Taxes (838.73) (658,890.16) GL 1103 03/09/2018 Property Taxes (191.64) (659,081.80) GL 1104 03/12/2018 Property Taxes (35.06) (659,116.86) GL 1105 03/13/2018 Property Taxes (53.27) (659,170.13) GL 1106 03/14/2018 Property Taxes (187.67) (659,357.80) GL 1107 03/16/2018 Property Taxes (252.76) (659,610.56) GL 1108 03/19/2018 Property Taxes (441.73) (660,052.29) GL 1109 03/20/2018 Property Taxes (14.57) (660,066.86) GL 1110 03/21/2018 Property Taxes (393.93) (660,460.79) GL 1111 03/22/2018 Property Taxes (3,564.61) (664,025.40) GL 1112 03/23/2018 Property Taxes 915.33 (663,110.07) GL 1145 03/23/2018 Revr Prop Tax Paid A/P JE 1142 (915.33) (664,025.40) GL 1113 03/26/2018 Property Taxes (422.94) (664,448.34) GL 1142 03/26/2018 Denton Tax A/P Shortage Refund Tax Shortage 915.33 (663,533.01) DENTON COUNTY TAX OFFICE 4088 AP 1114 03/27/2018 Property Taxes (23.65) (663,556.66) GL 1115 03/28/2018 Property Taxes (586.62) (664,143.28) GL 1116 03/29/2018 Property Taxes (164.10) (664,307.38) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (9,065.28) (664,307.38) ** (669,660.00) Budgeted (5,352.62) Remaining 99 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1097 03/01/2018 Property Taxes (1,883.81) (3.04) (1,886.85) GL 1098 03/02/2018 Property Taxes (9.70) (1,896.55) GL 1099 03/05/2018 Property Taxes (.03) (1,896.58) GL 1100 03/06/2018 Property Taxes (4.44) (1,901.02) GL 1104 03/12/2018 Property Taxes (3.26) (1,904.28) GL 1107 03/16/2018 Property Taxes (126.50) (2,030.78) GL 1114 03/27/2018 Property Taxes (.03) (2,030.81) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (147.00) (2,030.81) ** (1,800.00) Budgeted 230.81 Remaining 113 % Used Account: 533-40015-000-000 Property Taxes/P & I 1097 03/01/2018 Property Taxes (590.42) (33.20) (623.62) GL 1098 03/02/2018 Property Taxes (84.35) (707.97) GL April 17, 2018 Regular Meeting Agenda Packet 172 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 3/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1099 03/05/2018 Property Taxes (590.42) (65.51) (773.48) GL 1100 03/06/2018 Property Taxes (28.13) (801.61) GL 1101 03/07/2018 Property Taxes (56.67) (858.28) GL 1103 03/09/2018 Property Taxes (17.24) (875.52) GL 1104 03/12/2018 Property Taxes (4.38) (879.90) GL 1107 03/16/2018 Property Taxes (52.90) (932.80) GL 1108 03/19/2018 Property Taxes (12.08) (944.88) GL 1110 03/21/2018 Property Taxes (8.23) (953.11) GL 1112 03/23/2018 Property Taxes (.13) (953.24) GL 1145 03/23/2018 Revr Prop Tax Paid A/P JE 1142 .13 (953.11) GL 1113 03/26/2018 Property Taxes (12.67) (965.78) GL 1142 03/26/2018 Denton Tax A/P Shortage Refund Tax Shortage (.13) (965.91) DENTON COUNTY TAX OFFICE 4088 AP 1114 03/27/2018 Property Taxes (.06) (965.97) GL 1115 03/28/2018 Property Taxes (47.33) (1,013.30) GL 1116 03/29/2018 Property Taxes (8.60) (1,021.90) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (431.48) (1,021.90) ** (2,000.00) Budgeted (978.10) Remaining 51 % Used Account: 533-49010-000-000 Interest Income 1067 03/31/2018 Bank Interest- March (1,534.06) (1,061.79) (2,595.85) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (1,061.79) (2,595.85) ** (2,000.00) Budgeted 595.85 Remaining 130 % 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 1066 03/31/2018 Texpool Transfers March (55,474.05) (11,094.81) (66,568.86) GL _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (11,094.81) (66,568.86) ** (122,043.00) Budgeted (55,474.14) Remaining 55 % Used Department Totals: ----------------------------------- (955,478.80) ** (21,800.36) Monthly Total (1,016,457.00) Budgeted (60,978.20) Remaining 94 % Used April 17, 2018 Regular Meeting Agenda Packet 173 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 50 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 3/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 200.00 .00 200.00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 200.00 ** 2,150.00 Budgeted 1,950.00 Remaining 9 % 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: ----------------------------------- 141,953.75 ** .00 Monthly Total 1,010,658.00 Budgeted 868,704.25 Remaining 14 % Used Fund 533 Totals: ----------------------------------- (813,525.05) (21,800.36) Monthly Total (5,799.00) Budgeted 807,726.05 Remaining ########## April 17, 2018 Regular Meeting Agenda Packet 174 of 202 TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET MARCH 2018 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 231,796 ACCOUNTS RECEIVABLE - TOTAL ASSETS 231,796 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 16,210 NET REVENUES / EXPENDITURES 215,586 TOTAL FUND BALANCE 231,796 TOTAL LIABILITIES AND FUND BALANCE 231,796 April 17, 2018 Regular Meeting Agenda Packet 175 of 202 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 20 23:00 04/11/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 3/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- 235.33- 870.09- 87.009 129.91- 534-49143-000-000 Interfund Transfer In-WW Sales 598,738.00- 598,738.00- 54,430.72- 326,584.32- 54.545 272,153.68- Subtotal: 599,738.00- 599,738.00- 54,666.05- 327,454.41- 54.600 272,283.59- Program number: 599,738.00- 599,738.00- 54,666.05- 327,454.41- 54.600 272,283.59- Department number: Revenues 599,738.00- 599,738.00- 54,666.05- 327,454.41- 54.600 272,283.59- Revenues Subtotal ----------- 599,738.00- 599,738.00- 54,666.05- 327,454.41- 54.600 272,283.59- April 17, 2018 Regular Meeting Agenda Packet 176 of 202 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 21 23:00 04/11/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 3/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,666.05- 215,585.66- ############### 214,585.66 April 17, 2018 Regular Meeting Agenda Packet 177 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 51 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 3/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 1067 03/31/2018 Bank Interest- March (634.76) (235.33) (870.09) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (235.33) (870.09) ** (1,000.00) Budgeted (129.91) Remaining 87 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales 1066 03/31/2018 Texpool Transfers March (272,153.60) (54,430.72) (326,584.32) GL _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (54,430.72) (326,584.32) ** (598,738.00) Budgeted (272,153.68) Remaining 55 % Used Department Totals: ----------------------------------- (327,454.41) ** (54,666.05) Monthly Total (599,738.00) Budgeted (272,283.59) Remaining 55 % Used April 17, 2018 Regular Meeting Agenda Packet 178 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 52 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 3/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: ----------------------------------- (215,585.66) (54,666.05) Monthly Total (1,000.00) Budgeted 214,585.66 Remaining ########## April 17, 2018 Regular Meeting Agenda Packet 179 of 202 TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET MARCH 2018 535 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS 121,486 ACCOUNTS RECEIVABLE - TOTAL ASSETS 121,486 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 952 NET REVENUES / EXPENDITURES 120,534 TOTAL FUND BALANCE 121,486 TOTAL LIABILITIES AND FUND BALANCE 121,486 April 17, 2018 Regular Meeting Agenda Packet 180 of 202 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 22 23:00 04/11/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 3/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- 127.12- 394.46- 65.743 205.54- 535-49142-000-000 Interfund Tran In-Water Sales 278,084.00- 278,084.00- 25,280.31- 151,681.86- 54.545 126,402.14- Subtotal: 278,684.00- 278,684.00- 25,407.43- 152,076.32- 54.569 126,607.68- Program number: 278,684.00- 278,684.00- 25,407.43- 152,076.32- 54.569 126,607.68- Department number: Revenues 278,684.00- 278,684.00- 25,407.43- 152,076.32- 54.569 126,607.68- Revenues Subtotal ----------- 278,684.00- 278,684.00- 25,407.43- 152,076.32- 54.569 126,607.68- April 17, 2018 Regular Meeting Agenda Packet 181 of 202 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 23 23:00 04/11/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 3/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,407.43- 120,534.57- ############### 119,934.57 ******* End of Report ********* April 17, 2018 Regular Meeting Agenda Packet 182 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 53 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 3/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 1067 03/31/2018 Bank Interest- March (267.34) (127.12) (394.46) GL _______________ Account: 535-49010-000-000 Interest Income Totals: (127.12) (394.46) ** (600.00) Budgeted (205.54) Remaining 66 % Used Account: 535-49142-000-000 Interfund Tran In-Water Sales 1066 03/31/2018 Texpool Transfers March (126,401.55) (25,280.31) (151,681.86) GL _______________ Account: 535-49142-000-000 Interfund Tran In-Water Sales Totals: (25,280.31) (151,681.86) ** (278,084.00) Budgeted (126,402.14) Remaining 55 % Used Department Totals: ----------------------------------- (152,076.32) ** (25,407.43) Monthly Total (278,684.00) Budgeted (126,607.68) Remaining 55 % Used April 17, 2018 Regular Meeting Agenda Packet 183 of 202 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 54 23:00 04/11/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 3/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: ----------------------------------- (120,534.57) (25,407.43) Monthly Total (600.00) Budgeted 119,934.57 Remaining ########## Grand Totals: --------------------------------------------------------------------------------------------------------- 2,087,377.81 **** 3,502,584.80 Monthly Total (375,349.00) Budgeted (2,462,726.81) Remaining ########## ******* End of Report ********* April 17, 2018 Regular Meeting Agenda Packet 184 of 202 BUDGET VARIANCE REPORT FUND:122 - Fire O&M FINANCIALS MONTH:March 2018 REVENUE VARIANCE:41.5% EXPENSE VARIANCE:59.8% 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 14,274 1,046,020 99.202%10/2017 Property Taxes collected 122-40011 Property Taxes/Fire - Delinquent 227 3,101 10/2017 Delinquent Fire Taxes collected 122-40020 Property Taxes/Fire P&I 729 3,133 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 April 17, 2018 Regular Meeting Agenda Packet 185 of 202 BUDGET VARIANCE REPORT FUND:135 - MUD 1 O&M FINANCIALS MONTH:March 2018 REVENUE VARIANCE:41.5% EXPENSE VARIANCE:59.8% NOTE: ACCOUNT DESCRIPTION TOTAL BUDGET CURRENT MONTH YTD TOTAL YTD % DATE OF COMMENT VARIANCE EXPLANATION REVENUE 135-47000-000 Water 6,464,019 331,080 2,225,115 34.42%01/2018 Water Sales 135-47030-000 Service Charges 21,350 1,225 7,200 33.72%01/2018 Service Charges 135-47070-000 TCCC Effluent Charges 60,000 497 9,973 16.62%11/2017 TCCC Effluent Collected EXPENSES WATER 135-50040-010 Unemployment Taxes 1,080 689 730 67.60%03/2018 2018 Rate Adj (Increase) 135-55090-010 Vehicle Maintenance 4,000 1,036 3,853 96.33%03/2018 Discount Tires, Gierisch, Kwik Kar WASTEWATER 135-50040-020 Unemployment Taxes 1,260 1,073 1,134 90.00%03/2018 2018 Rate Adj (Increase) 135-55125-020 Dumpster Services 60,000 7,657 43,361 72.27%01/2018 L.H. Chaney- Haul offs 135-55135-020 Lab Analysis 30,000 1,864 18,327 61.09%01/2018 Lab 135-60010-020 Communications/ Mobiles 4,700 764 2,866 60.97%03/2018 Verizon- two A/P bills posted in march 135-65035-020 Small Tools 1,000 21 1,139 113.90%03/2018 Lowes 135-65040-020 Safety Equipment 750 327 587 78.21%03/2018 Vest, hardhats, boots 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 April 17, 2018 Regular Meeting Agenda Packet 186 of 202 BUDGET VARIANCE REPORT FUND:135 - MUD 1 O&M FINANCIALS MONTH:March 2018 REVENUE VARIANCE:41.5% EXPENSE VARIANCE:59.8% NOTE: ACCOUNT DESCRIPTION TOTAL BUDGET CURRENT MONTH YTD TOTAL YTD % DATE OF COMMENT VARIANCE EXPLANATION Explanation provided for all accounts with a Year-To-Date percentage (YTD%) less than the Revenue Variance and greater than or equal to the Expense Variance. The Revenue and Expense Variance is calculated on a straight-line method (Financials Month x 8.3%), less 8.3% for revenues and plus 10% for expenses. Only accounts with current month activity will be listed BOARD OF DIRECTORS ADMINISTRATION 135-50040-030 Unemployment Taxes 1,260 847 902 71.58%03/2018 2018 Rate Adj (Increase) 135-55160-030 Professional Outside Services 63,325$ 2,765$ 59,240$ 93.55%03/2018 New Gen- Winter Average 135-60055-030 Insurance 56,000$ 6,150$ 39,877$ 71.21%02/2018 TML WC True-Up Adjustment FY17 135-60070-030 Dues and Memberships 6,000$ 20$ 3,828$ 63.81%03/2018 TWDB 135-65090-030 Printer Supplies & Maintenance 2,000$ 146$ 2,049$ 102.43%03/2018 Printer Ink & Paper 135-65095-030 Maintenance Supplies 4,000$ 761$ 2,822$ 70.56%03/2018 Office Supplies Non-Departmental April 17, 2018 Regular Meeting Agenda Packet 187 of 202 Trophy Club Municipal Utility District No. 1    Date:    4/17/2018  To:    Board of Directors  From:    John Robert Carman  Subject:  General Manager’s Report      Regulatory Updates  Sanitary Sewer Overflows (SSO) – A SSO occurred on March 23, 2018 at 2980 State Highway  114 on the frontage road.  The SSO occurred when a contractor excavating on the site hit the 10  inch force main from lift station #3.  The contractor did not call for buried utility marking.      Sewage spilled across the road to the storm drain, with an estimated volume of 10250 gallons.   Our crews were notified and quickly on site, and began vacuuming the spill for transport to the  plant.  The SSO was reported to TCEQ verbally within the 24 hour period and in writing the next  day.  April 17, 2018 Regular Meeting Agenda Packet 188 of 202 A second SSO occurred on March 29, 2018 when we had a manhole overflow at 1124 Trophy  Club Drive.  Crews responded and partially cleared the blockage.  The cause was determined to  be roots.  The SSO was reported to TCEQ verbally within the 24 hour period and in writing the  next day.  In this case, the crews went back on Monday to attempt to cut out the roots but the  cutter head became lodged in the main.  It had to be excavated to retrieve the cutter.  A third SSO occurred at 303 Hill Lane on April 10, 2018.  The cause was determined to be rags  and non‐flushable wipes.  The estimated spill volume was 190 gallons.  The SSO was reported to  TCEQ verbally within the 24 hour period and in writing the next day.  Breaks and Leaks – On April 6th, 2018, an isolation valve was replaced at 525 Indian Creek.  This  repair was planned and door hangars notifying the residents affected by loss of pressure were  distributed in advance. Bacteria samples were taken as required by TCEQ.  Samples were  processed by a certified laboratory and came back negative (no bacteria were found).  Classification and Compensation Study – As of April 11, 2018 survey responses had been  received from all of the comparable agencies except Lewisville, Keller and the Benbrook Water  Authority.  The consultant hopes to get the last ones in this week.  Capital Improvement Projects   16 Inch Water Line Project Phase 1 – Bids were received on Phase 1 of this project and an  award recommendation is on this agenda.  WWTP – Work on Phase 3 of the plant upgrade continues.   Contractors have begun placing the  base mounts and piping for last membrane rack installation.  After pay application 27 was paid,  we have $ 129,077.67 with the contract balance to finish at $961,788.79.        April 17, 2018 Regular Meeting Agenda Packet 189 of 202   High Service Booster Pump – Our engineer is now recommending rebidding this project, and is  finalizing the bid documents now.  Joint Projects with Town  The project on Phoenix Drive has temporary service in place and the new waterline is being  installed.  The Phoenix Drive waterline is 80% complete.  Election Report  Staff received a request from the Denton County Republican Party to use the Svore Municipal  Boardroom for early voting and election day for the May 22, 2018 Republican Primary Runoff  Election.  Early voting will take place from May 14, 2018 through May 18, 2018.  The polls will be  open from 7 a.m. to 7 p.m. with the exception of Tuesday, May 15th.   On Tuesday, the day of our  board meeting, the polls will close at 2 p.m. to allow for set up of the meeting.  Staff has  coordinated with our local election judge and county officials on this matter.      April 17, 2018 Regular Meeting Agenda Packet 190 of 202 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 319,132 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 358,723 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 2018 MUD 3257 3262 3268 3272 3276 3280 2018 PID 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 April 17, 2018 Regular Meeting Agenda Packet 191 of 202 Influent EffluentInfluent EffluentInfluent Effluent5‐Mar 34.5 0.2 99.4% 270 2.0 99.3% 165 1.0 99.4%6‐Mar 37 0.2 99.5% 165 2.0 98.8% 125 1.0 99.2%    12‐Mar 32.5 0.2 99.4% 167 2.0 98.8% 165 1.0 99.4%13‐Mar 36.2 0.20 99.4% 169 2.0 98.8% 115 1.0 99.1%   19‐Mar 44.5 0.39 99.1% 193 2.0 99.0% 253 1.0 99.6%20‐Mar 42 0.20 99.5% 234 2.0 99.1% 198 1.0 99.5% 26‐Mar 42 0.49 98.8% 202 2.0 99.0% 190 1.0 99.5%27‐Mar 34.5 0.25 99.3% 212 2.0 99.1% 225 1.0 99.6%99.3%99.0%99.4%Date% Removal% Removal% RemovalReportMarch 2018 ResultsAmmonia‐NCBOD5TSS0.272.01.0Ammonia‐NCBOD5TSSApril 17, 2018 Regular Meeting Agenda Packet192 of 202 Max mg/L0.49Aver mg/L0.343Max mg/L2.0Aver mg/L2.0Ammonia NitrogenCarbonaceous Biochemical Demand (CBOD5)0.210.3300.49000.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.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 LimitApril 17, 2018 Regular Meeting Agenda Packet193 of 202 Max mg/L1Aver mg/L1.0Max mg/L8.8Aver mg/L6.7Total Suspended Solids (TSS)Nitrate - Nitrogen1.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.40.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 LimitApril 17, 2018 Regular Meeting Agenda Packet194 of 202 Max mg/L4.0Aver mg/L2.0Max mg/L7.4Min mg/L7.2Aver mg/L7.3E. ColiPotential for Hydrogen (pH)1.04.01.00.020.040.060.080.0100.0120.0140.0Jan‐18 Feb‐18 Mar‐18 Apr‐18 May‐18 Jun‐18 Jul‐18 Aug‐18 Sep‐18 Oct‐18 Nov‐18 Dec‐18E. ColiAveragePermit Limit7.27.27.27.37.47.40.01.02.03.04.05.06.07.08.09.010.0Jan‐18 Feb‐18 Mar‐18 Apr‐18 May‐18 Jun‐18 Jul‐18 Aug‐18 Sep‐18 Oct‐18 Nov‐18 Dec‐18pH MinAveragePermit Limit MinPermit Limit MaxpH MaxApril 17, 2018 Regular Meeting Agenda Packet195 of 202 Max mg/L7.8Aver mg/L7.7 Dissolved Oxygen (DO)7.87.57.80.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 LimitApril 17, 2018 Regular Meeting Agenda Packet196 of 202 Trophy Club MUD All Web Site Data GO TO REPORT Language Users % Users 1.en-us 1,775 98.01% 2.en-gb 8 0.44% 3.ko 7 0.39% 4.zh-cn 3 0.17% 5.c 2 0.11% 6.en 2 0.11% 7.fr 2 0.11% 8.pt-br 2 0.11% 9."en-us"1 0.06% 10.ar 1 0.06% Audience Overview Mar 1, 2018 - Mar 31, 2018 Overview  Users …Mar 8 Mar 15 Mar 22 Mar 29 100100 200200 Users 1,811 New Users 1,103 Sessions 2,374 Number of Sessions per User 1.31 Pageviews 4,352 Pages / Session 1.83 Avg. Session Duration 00:01:16 Bounce Rate 68.49% New Visitor Returning Visitor 43.6% 56.4% © 2018 Google All Users 100.00% Users April 17, 2018 Regular Meeting Agenda Packet 197 of 202 Trophy Club MUD All Web Site Data GO TO REPORT Page Pageviews % Pageviews 1.1,964 45.13% 2.282 6.48% 3.211 4.85% 4.180 4.14% 5.153 3.52% 6.134 3.08% 7.125 2.87% 8.86 1.98% 9.76 1.75% 10.72 1.65% Overview Mar 1, 2018 - Mar 31, 2018 Overview  Pageviews …Mar 8 Mar 15 Mar 22 Mar 29 250250 500500 Pageviews 4,352 Unique Pageviews 3,654 Avg. Time on Page 00:01:31 Bounce Rate 68.49% % Exit 54.55% / /customer-service/email-bills-and-online-payments/ /customer-service/contact-us-2/ /my-account/ /public-informatio/agendas-meetings-online/ /my-account/about-your-bill/ /customer-service/water-restrictions/ /customer-service/establish-service/ /customer-service/form/ /administratio/employment/current-job-opportunities/ © 2018 Google All Users 100.00% Pageviews April 17, 2018 Regular Meeting Agenda Packet 198 of 202 October November December January February March April May June July August September ebills 796 828 829 834 839 844 Bills Mailed 3906 3900 3912 3911 3908 3913 Bank Draft 631 623 639 653 657 656 Credit Card Draft 1018 1020 1026 1033 1042 1056 Online Payments 1037 1079 1,072 1,065 1,090 1,097 Late Notices 391 420 457 362 424 407 Disconnects 25 27 27 25 22 M 3257 3262 3268 3272 3276 3280 Connections P 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 April 17, 2018 Regular Meeting Agenda Packet 199 of 202 MUD Permits Month: March 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 3/9/2018 2018-0022 75.00$ 1,173.00$ 343.00$ 150.00$ 50.00$ 1,791.00$ 3/26/2018 2018-0030 75.00$ 1,173.00$ 343.00$ 150.00$ 50.00$ 1,791.00$ Total 150.00$ 2,346.00$ 686.00$ 300.00$ 100.00$ -$ -$ 3,582.00$ April 17, 2018 Regular Meeting Agenda Packet 200 of 202 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,777 $714,777 135-10250 TexPool O & M (XXXXX0002)-General Fund Operating ***$0 $1,049,126 $1,049,126 137-10250 TexPool O & M (XXXXX0002) GASB Replacement $596,426 $0 $596,426 517-10250 TexPool Construction Tax (XXXXX011) WWTP Improvements $363,680 $0 $363,680 519-11155 Cash-Bond Escrow Bank of Texas (SWIFT)$1,803,320 $0 $1,803,320 528-10250 TexPool Revenue Bond Reserve (XXXXX014) WWTP Improvements $515,627 $0 $515,627 533-10250 TexPool Tax I & S (XXXXX0003)$842,208 $0 $842,208 534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements $231,796 $0 $231,796 535-10250 Texpool Revenue I & S (XXXXX017) SWIFT $121,486 $0 $121,486 135-10300 Prosperity Bank (XXX8701) General Fund Operating *$314,660 $1,479,874 $1,794,534 533-10300 Prosperity Bank (XXX8701) Tax I&S $4,573 $0 $4,573 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 $5,611,069 $3,244,377 $8,855,446 Amount available in cash (MUD Accounts)$3,244,377 Amount available for spending (MUD Accounts)$3,244,377 * 03/31/18 Customer Water Deposits $314,660 122-10250 TexPool O & M (XXXXX0002)-Fire Operating Cash $0 $827,240 $827,240 122-10300 Prosperity Bank (XXX8701) Fire Operating $0 $0 $0 $0 $827,240 $827,240 Amount available in cash (Fire Department Accounts)$827,240 Amount available for spending (Fire Department Accounts)$827,240 714,777$ Bank of the West MM 1,479,874$ Prosperity General Fund 1,049,126$ Texpool General Fund 600$ Petty Cash Total General Fund 135 Available for Spending 3,244,377$ 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 178,897$ Total Nonspendable, Assigned & Committed Fund Balances - General Fund 135 $4,329,265 General Fund 135 Available General Fund 135 Fund Balances Fire Department Cash CASH STATUS AS OF MARCH 2018 Restricted - Unable to be spent Unrestricted- Available for spending Total in Accounts (Restricted & Unrestricted) April 17, 2018 Regular Meeting Agenda Packet 201 of 202 May 2018Printed on: 04/09/2018 3:39pmPowered byCalendarsFS Conference RoomFS Training RoomPS Large Conference RoomSvore Board RoomSunMonTueWedThuFriSat1819202122Apr 29, 201830May 1234510:30am Parks/Res7am FD Ofácers Ms7pm Trophy Club Ws67891011121pm Medlin Cemeter9am EMS Trainings10:30am Parks/Res9am EMS Trainings9am EMS Trainings131415161718196am Republican Prim10:30am Parks/Re7am Republican Prim6pm Trophy Club M6pm Lakes of Trops6am Republican Prim6am Republican Prim6am Republican Prim2021222324252610:30am Parks/ResRepublican Primary R10am Special Eves2728293031Jun 1210:30am Parks/ReTC Meeting SpacesModiÒerApril 17, 2018 Regular Meeting Agenda Packet202 of 202