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