Loading...
HomeMy WebLinkAbout2017-0516 May 16, 2017 Agenda Packet final      BOARD OF DIRECTORS  REGULAR MEETING   TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1  100 MUNICIPAL DRIVE  TROPHY CLUB, TEXAS 76262    May 16, 2017                                                             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 Agenda.   a. April 2017 Check Register  b. April 21, 2017 Regular Meeting Minutes   Attachments: April 2017 Check Register         April 21, 2017 Regular Meeting Minutes    REGULAR SESSION  2. Consider and take appropriate action regarding request for reduction of winter average rate by customer  residing at 1105 Sunset Drive.    Attachment:  Staff Report    3. Consider and take appropriate action regarding payment  to the Town of Trophy Club in an amount equal  to $10,597.99 to increase the size of the combination vault to accommodate the 8” Fire Line Meter for  the Trophy Club Town Hall & Police Facility.   Attachment: Proposed change in cost       March 21, 2017 Regular meeting action regarding 8” Fire Line    4. Consider and Take Action Regarding Adoption of Order No. 2017‐0516 Canvassing the Returns and  Declaring the Results of a Bond Election for Trophy Club Municipal Utility District No. 1.     Attachment: Order No. 2017‐0516    5. Consider and take appropriate action regarding funding and construction of proposed 16‐inch water  transmission line project from the District’s ground storage tank to elevated tank located on T.W. King  Road:  Trophy Club Municipal Utility District No. 1 1 of 149 May 16, 2017 - Agenda Packet     a. Discussion and possible action regarding potential issuance of revenue bonds for funding water  transmission line improvements:   i. Presentation by Financial Advisor regarding revenue bond analysis;  ii. Discussion and possible action regarding adoption of Resolution No. 2017‐0516 Authorizing  Application to the Texas Commission on Environmental Quality for Approval of Water  Transmission Line Project and Issuance of Bonds; and  iii. Discussion and possible action regarding approval of Proposal by District Engineering  Consultants for Preparation of an Application to the Texas Commission on Environmental  Quality for Approval of Water Transmission Line Project and Issuance of Bonds.  b. Other matters related thereto.          Attachment: Revenue Bond Analysis   Resolution No. 2017‐0516    6. Consider and take appropriate action concerning wastewater treatment plant directional sign located at  Indian Creek Drive and Junction Way. (Rose/Wilson)    7. Consider and take appropriate action regarding Work Amendment No. 1 with Halff Associates, Inc. for  Project #32127 Off‐Site Water Line for Trophy Club Town Center Development in an amount equal to  $4,750.00.   Attachment: Work Amendment No. 1    8. Consider and take appropriate action regarding District Capital Improvement Program for Repair and  Replacement of Infrastructure Assets:  a. Discussion regarding prioritization of infrastructure repair and replacement projects;  b. Discussion and possible action regarding funding of capital improvement projects;  c. Potential Coordination with Town of Trophy Club Capital Improvement Projects; and  d. Other matters related to the establishment, funding and implementation of a capital improvement  program for repair or replacement of District infrastructure assets.   Attachments:  Proposed 5 year Capital Improvement Plan                            Cost estimate for infrastructure and repair    9. Consider and take appropriate action regarding Order No. 2017‐0516A Adopting Trophy Club Municipal  Utility District No. 1 Organization, Policy, Procedure and Code of Ethics.     Attachment: Order No. 2017‐0516A    10. Discussion and possible action regarding stipend for Management Staff for period of August 26, 2016  through February 19, 2017    11. Consider and take appropriate action regarding the April 2017 combined financials and variance report.  a. Combined financials   b. Variance report   Attachments: Combined financials          Variance Report    12. Consider and take appropriate action regarding the renewal of TDPES Permit No. WQ0011593001 Docket  No. 2017‐0567‐MWD.    Trophy Club Municipal Utility District No. 1 2 of 149 May 16, 2017 - Agenda Packet     13. Consider and take appropriate action regarding the duties of a public officer, Greg Wilson, as they relate  to incompatibility with another public office. (Liston)    14. Conduct a performance review of General Legal Counsel and take appropriate action related thereto.  (Wilson/Rose)    REPORTS & UPDATES  15. Receive update from legal counsel:  a. Meeting with Town staff regarding enforcement of Water restrictions     16. General Manager Monthly Reports and Updates   a. Water System Operation   Water usage  b. Wastewater System Operation   c. W.I.S.E. Guys program implementation update  d. Wastewater Treatment Plant Permit renewal update  e. Enforcement Case No. 52342, TCEQ Texas Commission on Environmental Quality  f. Finance Update   Utility Billing Reports   Permits Collected  g. Project Status Updates   Wastewater Treatment Plant Upgrade Project   Attachments:  Water Operations report   Wastewater Operations report   Utility Billing report     Permits collected    CLOSED SESSION  17. Pursuant to section 551.071, the District will consult with its attorney 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 performance and payment issues related to the contract for construction of the      Wastewater Treatment Plant entered into by Webber Cadagua and the District dated May 3, 2015.    REGULAR SESSION  18. Consider and take appropriate action on matters deliberated in Closed Session:    19. Items for future agendas:    20. Set future Meeting dates:  Regular Meeting on June 20, 2017 at 6:30 p.m.   Attachment: June meeting calendar       ADJOURN    *THE BOARD RESERVES THE RIGHT TO ADJOURN INTO CLOSED SESSION AT ANY TIME DURING THE MEETING  FOR THE PURPOSE OF SEEKING THE ADVICE OF ITS ATTORNEY ABOUT ANY ITEM ON THE AGENDA, PURSUANT  Trophy Club Municipal Utility District No. 1 3 of 149 May 16, 2017 - Agenda Packet     TO SECTION 551.071 OF THE TEXAS GOVERNMENT CODE.  THE STATE OF TEXAS §   COUNTIES OF DENTON AND TARRANT §    THIS NOTICE CERTIFIES THAT ON FRIDAY, MAY 12, 2017, BY 6:30 P.M., THE MEETING AGENDA OF TROPHY  CLUB MUNICIPAL UTILITY DISTRICT NO. 1, BOARD OF DIRECTORS REGULAR MEETING TO BE HELD ON  TUESDAY, MAY 16, 2017 AT 6:30 P.M., WAS POSTED ON THE FRONT WINDOW OF TROPHY CLUB MUNICIPAL  UTILITY DISTRICT NO. 1  ADMINISTRATION BUILDING, 100 MUNICIPAL DRIVE, TROPHY CLUB, TEXAS, WHICH  IS A PLACE CONVENIENT TO THE PUBLIC AND WITHIN THE BOUNDARIES OF THE DISTRICT AND NOTIFICATION  WAS POSTED TO THE DISTRICT WEBSITE, IN ACCORDANCE WITH SECTION 49.063 OF THE WATER CODE AND  SECTION 551.054 OF THE TEXAS GOVERNMENT CODE, AS AMENDED.      LAURIE SLAGHT, DISTRICT SECRETARY                THIS OFFICIAL AGENDA WAS POSTED ON THE  WINDOW OF TROPHY CLUB MUNICIPAL UTILITY  DISTRICT NO. 1 ADMINISTRATION BUILDING ON:  DATE: _____________________________________  TIME: _______________        BY: _________________  Trophy Club Municipal Utility District No. 1 4 of 149 May 16, 2017 - Agenda Packet  apackamt2 rgonzaleTrophy Club MUD No.1 05/10/17 08:01Page 1AP Checks For Date/Amount RangeBegin Date: 04/01/2017 End Date: 04/30/2017From Amt:.00 To Amt: 99,999,999.99 Vendor Vendor NameInvoice Number Invoice Inv Dept AccountDescriptionLine Item Check CheckNumberDate Stat No NumberValue Number Date2222 AFLACPR00600 996 03/10/17 P 135-21312-000-000 Aflac62.80 3009 04/13/172222 AFLACPR00603 996 03/24/17 P 135-21312-000-000 Aflac62.80 3009 04/13/17Totals for Check: 3009125.603127 ALLIED WELDING SUPPLY, INC 6807103/13/17 P 10 135-55080-010-000 Maintenance & Repairs21.50 3010 04/13/17Totals for Check: 301021.501512 AWBD164037 03/27/17 P 26 135-60080-026-000 Schools & Training355.00 3011 04/13/171512 AWBD163649 03/27/17 P 26 135-60080-026-000 Schools & Training355.00 3011 04/13/17Totals for Check: 3011710.00998 BARRY, KEVIN MU0010200009100A 03/31/17 P 135-20050-000-000 A/P Vendors10.20 3012 04/13/17Totals for Check: 301210.20998 BOLLINGER, JUDITHU9035110039901A 03/31/17 P 135-20050-000-000 A/P Vendors28.14 3013 04/13/17Totals for Check: 301328.142920 CARENOW CORPORATE992997 03/15/17 P 30 135-50060-030-000 Pre-emp Physicals/Testing63.00 3014 04/13/17Totals for Check: 301463.003193 COMPUPAY, INC.PR00604 996 04/07/17 P 135-21313-000-000 Cafe 125-Medical Reimb511.00 3015 04/13/17Totals for Check: 3015511.00998 COSTA, ASHLEYU9046030050901A 03/31/17 P 135-20050-000-000 A/P Vendors04.86 3016 04/13/17Totals for Check: 301604.863080 CP&Y/WALLACE GROUP, INC. W9923936.00-15 03/31/17 P 30 135-69005-030-000 Capital Outlays875.00 3017 04/13/17Totals for Check: 3017875.002497 DHS AUTOMATION, INC06-1593 04/04/17 P 10 135-55080-010-000 Maintenance & Repairs1,716.32 3018 04/13/17Totals for Check: 30181,716.321026 FEDERAL EXPRESS CORP5-754-86397 03/30/17 P 30 135-60035-030-000 Postage24.12 3019 04/13/17Totals for Check: 301924.122606 Fiserv Solutions, LLC 91049123 03/29/17 P 30 135-60040-030-000 Service Charges & Fees50.00 3020 04/13/17Totals for Check: 302050.00998 FIRST TEXAS HOMESU0037000411100A 03/31/17 P 135-20050-000-000 A/P Vendors37.08 3021 04/13/17Totals for Check: 302137.08998 FIRST TEXAS HOMESU9023280008900A 03/31/17 P 135-20050-000-000 A/P Vendors31.63 3022 04/13/17Totals for Check: 302231.63998 GRETT, JENNIFERU9048070043902A 03/31/17 P 135-20050-000-000 A/P Vendors17.16 3023 04/13/17Totals for Check: 302317.16Trophy Club Municipal Utility District No. 15 of 149May 16, 2017 - Agenda Packet  apackamt2 rgonzaleTrophy Club MUD No.1 05/10/17 08:01Page 2AP Checks For Date/Amount RangeBegin Date: 04/01/2017 End Date: 04/30/2017From Amt:.00 To Amt: 99,999,999.99 Vendor Vendor NameInvoice Number Invoice Inv Dept AccountDescriptionLine Item Check CheckNumberDate Stat No NumberValue Number Date2635 Halff Associates, INC FM223648 02/28/17 P 10 135-55005-010-000 Engineering16,685.25 3024 04/13/17Totals for Check: 302416,685.253136 HD SUPPLY WATERWORKS, LTD. G879456 03/23/17 P 10 135-55080-010-000 Maintenance & Repairs3,501.81 3025 04/13/173136 HD SUPPLY WATERWORKS, LTD. G940462 03/23/17 P 10 135-55080-010-000 Maintenance & Repairs45.08 3025 04/13/17Totals for Check: 30253,546.892775 HUDSON ENERGY SERVICES, LLC 170413576 04/07/17 P 20 135-60020-020-000 Electricity36.12 3026 04/13/172775 HUDSON ENERGY SERVICES, LLC 1704013823 04/07/17 P 20 135-60020-020-000 Electricity83.22 3026 04/13/17Totals for Check: 3026119.34998 HUTTON, BRIANU0020000825201A 03/31/17 P 135-20050-000-000 A/P Vendors04.53 3027 04/13/17Totals for Check: 302704.533124 IRS Tax PaymentPR00604 996 04/07/17 P 135-21302-000-000 FWH Taxes5,212.20 3028 04/13/173124 IRS Tax PaymentPR00604 996 04/07/17 P 135-21303-000-000 Social Security Taxes5,630.66 3028 04/13/173124 IRS Tax PaymentPR00604 996 04/07/17 P 135-21304-000-000 Medicare Taxes1,316.88 3028 04/13/17Totals for Check: 302812,159.742764 JAMIE LYNN MCMAHONPR00604 996 04/07/17 P 135-21410-000-000 Child Support147.69 3029 04/13/17Totals for Check: 3029147.69998 JOHNSON, HAROLD D.U0030121568200A 03/31/17 P 135-20050-000-000 A/P Vendors02.84 3030 04/13/17Totals for Check: 303002.842943 JPMORGAN CHASE BANK NA 032717 03/27/17 P 135-20060-000-000 Procurement Clearing9,050.85 3031 04/13/17Totals for Check: 30319,050.85998 KODIAK TRENCHING & BORING U0511000105519A 03/31/17 P 135-20050-000-000 A/P Vendors1,310.21 3032 04/13/17Totals for Check: 30321,310.212642 LanguageUSA, Inc159217 03/30/17 P 10 135-69005-010-000 Capital Outlays90.00 3033 04/13/17Totals for Check: 303390.003132 Legal ShieldPR00600 996 03/10/17 P 135-21310-000-000 Legal Plan30.41 3034 04/13/173132 Legal ShieldPR00603 996 03/24/17 P 135-21310-000-000 Legal Plan30.41 3034 04/13/173132 Legal Shield032517 03/25/17 P 30 135-50029-030-000 Life Insurance & Other(00.02) 3034 04/13/17Totals for Check: 303460.80998 LENNAR HOMESU9036029050900A 03/31/17 P 135-20050-000-000 A/P Vendors48.36 3035 04/13/17Totals for Check: 303548.36998 LENNAR HOMESU9048060091900A 03/31/17 P 135-20050-000-000 A/P Vendors42.22 3036 04/13/17Totals for Check: 303642.223216 M3 Networks29901584 04/04/17 P 30 135-65055-030-000 Hardware25.00 3037 04/13/17Totals for Check: 303725.00Trophy Club Municipal Utility District No. 16 of 149May 16, 2017 - Agenda Packet  apackamt2 rgonzaleTrophy Club MUD No.1 05/10/17 08:01Page 3AP Checks For Date/Amount RangeBegin Date: 04/01/2017 End Date: 04/30/2017From Amt:.00 To Amt: 99,999,999.99 Vendor Vendor NameInvoice Number Invoice Inv Dept AccountDescriptionLine Item Check CheckNumberDate Stat No NumberValue Number Date998 MALEK, CALVINU0020001088211A 03/31/17 P 135-20050-000-000 A/P Vendors53.71 3038 04/13/17Totals for Check: 303853.712643 McLean & Howard, L.L.P. 2700003/31/17 P 39 135-55045-039-000 Legal2,160.00 3039 04/13/17Totals for Check: 30392,160.00998 MCANULTY, LARRYU0020001111205A 03/31/17 P 135-20050-000-000 A/P Vendors65.61 3040 04/13/17Totals for Check: 304065.612628 MCCI1064101/31/17 P 30 135-55030-030-000 Software & Support4,494.94 3041 04/13/17Totals for Check: 30414,494.943115 METLIFE GROUP BENEFITS 04/01/2017 04/01/17 P 135-21308-000-000 Dental1,578.25 3042 04/13/173115 METLIFE GROUP BENEFITS 04/01/2017 04/01/17 P 135-21309-000-000 Vision289.87 3042 04/13/173115 METLIFE GROUP BENEFITS 04/01/2017 04/01/17 P 135-21311-000-000 Voluntary Life311.89 3042 04/13/173115 METLIFE GROUP BENEFITS 04/01/2017 04/01/17 P 135-21315-000-000 Short Term Disability83.50 3042 04/13/173115 METLIFE GROUP BENEFITS 04/01/2017 04/01/17 P 10 135-50029-010-000 Life Insurance & Other220.30 3042 04/13/173115 METLIFE GROUP BENEFITS 04/01/2017 04/01/17 P 20 135-50029-020-000 Life Insurance & Other356.76 3042 04/13/173115 METLIFE GROUP BENEFITS 04/01/2017 04/01/17 P 30 135-50029-030-000 Life Insurance & Other492.04 3042 04/13/17Totals for Check: 30423,332.611056 OFFICE DEPOT, INC916002603001 03/24/17 P 30 135-65085-030-000 Office Supplies104.31 3043 04/13/17Totals for Check: 3043104.31998 RATLIFF HARDSCAPEU0512000008505A 03/31/17 P 135-20050-000-000 A/P Vendors1,361.20 3044 04/13/17Totals for Check: 30441,361.20998 RUSH, DENNISU0023120021203A 03/31/17 P 135-20050-000-000 A/P Vendors05.66 3045 04/13/17Totals for Check: 304505.66998 SHAW, JESSEU0010190012126A 03/31/17 P 135-20050-000-000 A/P Vendors17.44 3046 04/13/17Totals for Check: 304617.44998 STADTLANDER, DEANU0010170039114A 03/31/17 P 135-20050-000-000 A/P Vendors132.11 3047 04/13/17Totals for Check: 3047132.111163 STW INC2464604/04/17 P 30 135-55030-030-000 Software & Support658.00 3048 04/13/17Totals for Check: 3048658.00998 TALLMAN, JARROD WU0010050379106A 03/31/17 P 135-20050-000-000 A/P Vendors51.34 3049 04/13/17Totals for Check: 304951.343113 TCDRSPR00604 996 04/07/17 P 135-21317-000-000 TCDRS7,718.58 3050 04/13/17Totals for Check: 30507,718.58998 TERRELL, DAVIDU0020600026207A 03/31/17 P 135-20050-000-000 A/P Vendors31.63 3051 04/13/17Totals for Check: 305131.63Trophy Club Municipal Utility District No. 17 of 149May 16, 2017 - Agenda Packet  apackamt2 rgonzaleTrophy Club MUD No.1 05/10/17 08:01Page 4AP Checks For Date/Amount RangeBegin Date: 04/01/2017 End Date: 04/30/2017From Amt:.00 To Amt: 99,999,999.99 Vendor Vendor NameInvoice Number Invoice Inv Dept AccountDescriptionLine Item Check CheckNumberDate Stat No NumberValue Number Date1001 TOWN OF TROPHY CLUB033117REFUSE 03/31/17 P 135-25000-000-000 Refuse65,198.17 3052 04/13/171001 TOWN OF TROPHY CLUB033117REFUSE 03/31/17 P 135-25010-000-000 Refuse Tax5,328.61 3052 04/13/171001 TOWN OF TROPHY CLUB033117REFUSE 03/31/17 P 135-25040-000-000 Town-Storm Drainage31,773.61 3052 04/13/17Totals for Check: 3052102,300.391000 TROPHY CLUB MUD (WATER BILLS) 033117 03/31/17 P 30 135-60025-030-000 Water198.01 3053 04/13/17Totals for Check: 3053198.011241 TX MUNICIPAL LEAGUE8126904/03/17 P 30 135-60125-030-000 Advertising150.00 3054 04/13/17Totals for Check: 3054150.003225 US Bank Voyager Fleet Systems 869338111712 03/24/17 P 10 135-65005-010-000 Fuel & Lube674.08 3055 04/13/173225 US Bank Voyager Fleet Systems 869338111712 03/24/17 P 20 135-65005-020-000 Fuel & Lube776.87 3055 04/13/17Totals for Check: 30551,450.953270 WEBBER-CADAGUA PARTNERS APP 18 03/25/17 P 20 517-69005-020-000 Capital Outlays105,426.99 3056 04/13/17Totals for Check: 3056105,426.991085 U.S. POSTAL SERVICE041717 04/17/17 P 30 135-60035-030-000 Postage1,336.90 3057 04/17/17Totals for Check: 30571,336.901500 AMERICAN WATER WORKS ASSOC 7001369522 03/26/17 P 10 135-60066-010-000 Publications/Books/Subscripts767.00 3058 04/20/17Totals for Check: 3058767.003187 CLS SEWER EQUIPMENT CO., INC 2023704/03/17 P 20 135-55080-020-000 Maintenance & Repairs1,060.41 3059 04/20/17Totals for Check: 30591,060.413080 CP&Y/WALLACE GROUP, INC. WALL9923000.-14 04/09/17 P 20 517-69005-020-000 Capital Outlays50,504.20 3060 04/20/17Totals for Check: 306050,504.203217 Data Management Inc.420341 04/01/17 P 30 135-55030-030-000 Software & Support600.00 3061 04/20/17Totals for Check: 3061600.003184 DATAPROSE LLCDP1700930 03/31/17 P 30 135-60035-030-000 Postage1,790.17 3062 04/20/173184 DATAPROSE LLCDP1700930 03/31/17 P 30 135-55205-030-000 Utility Billing Contract599.30 3062 04/20/173184 DATAPROSE LLCDP1700930 03/31/17 P 30 135-65105-030-000 Printing117.50 3062 04/20/17Totals for Check: 30622,506.972620 ENGIE Resources LLC67319-11001APR 04/10/17 P 20 135-60020-020-000 Electricity4,151.75 3063 04/20/17Totals for Check: 30634,151.753282 EVERBANK COMMERCIAL FINANCE 20212738-APRIL 04/07/17 P 30 135-69170-030-000 Copier Lease Installments165.00 3064 04/20/17Totals for Check: 3064165.001139 G & K SERVICES1159601028 04/10/17 P 30 135-55100-030-000 Building Maint & Supplies66.47 3065 04/20/17Totals for Check: 306566.47Trophy Club Municipal Utility District No. 18 of 149May 16, 2017 - Agenda Packet  apackamt2 rgonzaleTrophy Club MUD No.1 05/10/17 08:01Page 5AP Checks For Date/Amount RangeBegin Date: 04/01/2017 End Date: 04/30/2017From Amt:.00 To Amt: 99,999,999.99 Vendor Vendor NameInvoice Number Invoice Inv Dept AccountDescriptionLine Item Check CheckNumberDate Stat No NumberValue Number Date3136 HD SUPPLY WATERWORKS, LTD. G990572 04/07/17 P 10 135-55080-010-000 Maintenance & Repairs221.60 3066 04/20/173136 HD SUPPLY WATERWORKS, LTD. G939680 04/05/17 P 10 135-55080-010-000 Maintenance & Repairs126.50 3066 04/20/17Totals for Check: 3066348.102775 HUDSON ENERGY SERVICES, LLC 1704016503 04/12/17 P 20 135-60020-020-000 Electricity110.74 3067 04/20/172775 HUDSON ENERGY SERVICES, LLC 1704013576 04/10/17 P 20 135-60020-020-000 Electricity36.12 3067 04/20/17Totals for Check: 3067146.861834 IDEXX DISTRIBUTION, INC 3014526681 04/03/17 P 20 135-65045-020-000 Lab Supplies2,019.15 3068 04/20/171834 IDEXX DISTRIBUTION, INC 3014526687 04/03/17 P 20 135-65045-020-000 Lab Supplies188.49 3068 04/20/17Totals for Check: 30682,207.641468 L.H. CHANEY MATERIALS, INC. 132479 03/25/17 P 20 135-55125-020-000 Dumpster Services1,690.00 3069 04/20/171468 L.H. CHANEY MATERIALS, INC. 132555 04/01/17 P 20 135-55125-020-000 Dumpster Services861.48 3069 04/20/17Totals for Check: 30692,551.483216 M3 Networks29901599 04/15/17 P 30 135-55030-030-000 Software & Support168.00 3070 04/20/17Totals for Check: 3070168.003286 MP2 ENERGY TEXAS LLC1302508 04/18/17 P 20 135-60020-020-000 Electricity343.30 3071 04/20/17Totals for Check: 3071343.301056 OFFICE DEPOT, INC916822021001 03/29/17 P 30 135-65085-030-000 Office Supplies338.13 3072 04/20/17Totals for Check: 3072338.133156 OXIDOR LABORATORIES LLC 17040033 04/03/17 P 20 135-55135-020-000 Lab Analysis246.00 3073 04/20/173156 OXIDOR LABORATORIES LLC 17040048 04/04/17 P 20 135-55135-020-000 Lab Analysis176.00 3073 04/20/173156 OXIDOR LABORATORIES LLC 17030660 03/27/17 P 20 135-55135-020-000 Lab Analysis176.00 3073 04/20/173156 OXIDOR LABORATORIES LLC 17030659 03/27/17 P 20 135-55135-020-000 Lab Analysis246.00 3073 04/20/173156 OXIDOR LABORATORIES LLC 17040214 04/11/17 P 20 135-55135-020-000 Lab Analysis176.00 3073 04/20/173156 OXIDOR LABORATORIES LLC 17040200 04/10/17 P 20 135-55135-020-000 Lab Analysis246.00 3073 04/20/17Totals for Check: 30731,266.002440 TARRANT CTY PUBLIC HEALTH LAB 2889303/31/17 P 10 135-55135-010-001 Lab Analysis for PID80.00 3074 04/20/172440 TARRANT CTY PUBLIC HEALTH LAB 2889203/31/17 P 10 135-55135-010-000 Lab Analysis275.00 3074 04/20/17Totals for Check: 3074355.003123 Texas Tollways/TxTag04/02/2017 04/02/17 P 20 135-60100-020-000 Travel & per diem39.61 3075 04/20/17Totals for Check: 307539.612862 TECHNIQUE DATA SYSTEMS INC 046963 04/13/17 P 30 135-55030-030-000 Software & Support425.00 3076 04/20/17Totals for Check: 3076425.001001 TOWN OF TROPHY CLUB040117-FIRE 04/07/17 P 45 122-60337-045-000 Transfer to Town/Fire Budget 48,974.00 3077 04/20/17Totals for Check: 307748,974.001081 TRI COUNTY ELECTRIC72734610 03/24/17 P 20 135-60020-020-000 Electricity314.63 3078 04/20/17Trophy Club Municipal Utility District No. 19 of 149May 16, 2017 - Agenda Packet  apackamt2 rgonzaleTrophy Club MUD No.1 05/10/17 08:01Page 6AP Checks For Date/Amount RangeBegin Date: 04/01/2017 End Date: 04/30/2017From Amt:.00 To Amt: 99,999,999.99 Vendor Vendor NameInvoice Number Invoice Inv Dept AccountDescriptionLine Item Check CheckNumberDate Stat No NumberValue Number Date1081 TRI COUNTY ELECTRIC72734609 03/24/17 P 20 135-60020-020-000 Electricity37.32 3078 04/20/171081 TRI COUNTY ELECTRIC72734611 03/24/17 P 20 135-60020-020-000 Electricity27.81 3078 04/20/17Totals for Check: 3078379.762634 Valley Solvent Company, INC 1157004/11/17 P 10 135-65030-010-000 Chemicals434.64 3079 04/20/17Totals for Check: 3079434.641058 VERIZON WIRELESS9783006330 04/01/17 P 10 135-60010-010-000 Communications/Mobiles346.75 3080 04/20/171058 VERIZON WIRELESS9783006330 04/01/17 P 20 135-60010-020-000 Communications/Mobiles411.68 3080 04/20/171058 VERIZON WIRELESS9783006330 04/01/17 P 30 135-60010-030-000 Communications/Mobiles37.99 3080 04/20/17Totals for Check: 3080796.423236 WHOLESALE CARRIER SERVICES INC 3564232 04/01/17 P 30 135-55030-030-000 Software & Support1,036.77 3081 04/20/17Totals for Check: 30811,036.77Grand Totals:398,202.22****** End of Report *********Trophy Club Municipal Utility District No. 110 of 149May 16, 2017 - Agenda Packet     REGULAR MEETING MINUTES   TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1  BOARD OF DIRECTORS   April 18, 2017 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 April 18, 2017 at 6:30 P.M., in the Boardroom of the Administration Building, 100  Municipal Drive, Trophy Club, Texas 76262. The meeting was held within the boundaries of the District, and  was open to the public.    STATE OF TEXAS                           §  COUNTIES OF DENTON AND TARRANT          §    BOARD MEMBERS PRESENT:  Kevin R. Carr President  Greg Wilson Vice President  Jim Hase Secretary/Treasurer  Jim Thomas Director  Bill Rose Director    STAFF PRESENT:  Shane Jeff General Manager  Laurie Slaght District Secretary  Renae Gonzales Finance Manager  Mike McMahon Water Superintendent  Karl Schlielig Wastewater Superintendent  Steven Krolczyk HR Manager/Financial Analyst  Paul Liston General Legal Counsel    GUESTS PRESENT:   Kevin Glovier, PE. CP&Y  Scott Wetzel, PE. CP&Y    CALL TO ORDER AND ANNOUNCE A QUORUM   President Carr announced the date of April 18, 2017, called the meeting to order and announced a quorum  present at 6:33 p.m.      CITIZEN COMMENTS  Joyce Baker, 1801 Seville Cove, Westlake, Texas, 76262    CONSENT AGENDA  1. Consider and take appropriate action to approve the Consent Agenda.   a. March 2017 Check Register  b. March 21, 2017 Regular Meeting Minutes  c. Quarterly Investment Reports – 2nd Quarter  d. Tax Collections     Director Hase requested to have item a. check register removed and discuss this item at the end of the  meeting if time allows.  Trophy Club Municipal Utility District No. 1 11 of 149 May 16, 2017 - Agenda Packet       Motion by Director Rose and seconded by Director Wilson to approve consent agenda items including b.  March 21, 2017 meeting minutes as amended and c. Quarterly Investment Reports and d. Tax Collections.      Motion carried unanimously      Motion by Director Rose and second by Director Hase to approve the March 2017 check register with the  requirement that an explanation of seven checks be sent to the Board.    Motion carried unanimously    REGULAR SESSION  2. Discussion and update regarding Interlocal Cooperation Agreement for Administration of Fire Protection  Services, Attachment “B”. (Hase/Carr)    General Manager Shane Jeff presented the Board with reports from Interim Fire Chief Rick Lasky.  Mr.  Jeff stated that Town Manager, Tom Class will have the incoming Fire Chief create Standard Operating  Guidelines for the Fire Department.     3. Consider and take appropriate action regarding Change Order No. 7 for Modifications required to  accommodate breaker overload at WAS Pumps for an amount of $2,407.00 for the Wastewater  Treatment Plant Project.     Scott Wetzel, PE, CP&Y stated that the plans called for a 3.5 HP pump which is what the District paid for;  however, what was needed was a 7.5 HP pump.  What the contractor included in their bid was a 3.5HP  pump and this change order is for the difference in cost to upgrade to the 7.5 HP pump which is needed.      Motion made by Director Wilson and seconded by Director Thomas to approve Change Order No. 7 for  Modifications required to accommodate breaker overload at WAS Pumps for an amount not to exceed  $2,407.00 for the Wastewater Treatment Plant Project.    Motion carried unanimously    4. Consider and take appropriate action regarding Change Order No. 8 for the addition of Turbidity Drain  Lines and Influent Wier Gate Controls to MBR 1 & 2 for an amount of $14,860.56.    $2,000 is for the turbidity drain lines and the remaining $12,000 is for the Wier Gate Controls which was  left off the drawings.  The gate controls will allow the staff to control the gates from home and will default  to a positon of closed.  The gates can be controlled manually.    Motion made by Director Wilson and seconded by Director Carr to approve Change Order No. 8 for the  addition of Turbidity Drain Lines and Influent Wier Gate Controls to MBR 1 & 2 for an amount not to exceed  $14,860.56    Motion carried unanimously      5. Consider and take appropriate action regarding Contract No. 2017041801 with Sluder Emergency Power  Services for Annual Emergency Generator Maintenance for an annual cost of $2,916.00.   Trophy Club Municipal Utility District No. 1 12 of 149 May 16, 2017 - Agenda Packet     Motion made by Director Wilson and seconded by Director Thomas to approve Contract No. 2017041801  with Sluder Emergency Power Services for Annual Emergency Generator Maintenance for an annual cost  not to exceed $2,916.00.    Motion carried unanimously      6. Discussion and possible action regarding representation from someone who resides within the  boundaries of the District and the Town of Westlake. (Wilson/Rose)    Attorney Liston stated that the District must follow the laws of the State of Texas which allow for a person  who resides within the boundaries of the District to run for a place on the Board of Directors of Trophy  Club Municipal Utility District No. 1 and the Director positions are elected to four (4) year terms that  stagger and the next Director Election will be May of 2018 with three (3) positions on the Board open.   Attorney Liston added that when a person is elected to the position of Director, they must represent all  of the District, it is not segmented by subdivision, HOA, Town or area, but that the District is a completely  separate governmental entity from the Town of Trophy Club and the Town of Westlake and the Board  of Directors is elected to serve the District as a whole.      Attorney Liston clarified that a person must be elected to the Board of Directors unless a Director resigns,  then the remaining board members would appoint someone to fill that position until the next election.    Director Hase would like to have legal counsel look into whether or not the District boundaries could be  redrawn to exclude the residential area of Westlake that is within the boundary.                 Joyce Baker, 1801 Seville Cove, Westlake, Texas, 76262 stated that she would like the District to look at  dissolution and feels that the residents that reside in Westlake do not have any representation and nor  do those in parts of Trophy Club.  She would like the Board to re‐engage with the Town of Westlake for  a buyout.    Director Rose stated that the District cannot simply dissolve as long as it has debt and that the debt  would need to be totally defeased as well as the District would not be able to have any extraterritorial  jurisdiction for it to be taken over by a Town.     Discussion Only, No Action Taken      7. Consider and take appropriate action regarding funding options for Town of Trophy Club Capital  Improvement Projects.    The Board was given a handout with current revenue note proposals from three finance institutions for  consideration to fund the $410,000 cost of the capital improvement projects.   Town Councilmember  Philip Shoffner stated that the Town will not assist with funding through a bond package.     Water Superintendent Mike McMahon stated he would like to have the Board consider setting aside  funds annually for repairs that are priorities for the District.  McMahon explained that there are areas  throughout the District that are prone to main breaks annually and he would like these areas to take  priority over replacing a line just because the street is being repaired or replaced.   McMahon would like  to find a way to set aside annual funding for repairs and replacements.  Director Rose stated that the  board needs to plan for replacement of aging infrastructure and needs to put in place a 5‐year capital  Trophy Club Municipal Utility District No. 1 13 of 149 May 16, 2017 - Agenda Packet     improvement plan.      Director Wilson would like a list of priority projects with estimated cost brought back to the next meeting.      Motion made by Director Wilson and seconded by Director Rose to postpone this item to the next meeting.    Motion carried unanimously      8. Consider and take appropriate action regarding amending Rate Order No. 2017‐0321C Section, 3.02  Billing Procedures.   a. Proposed changes to disconnect and reconnect fees  b. Adopting Rate Order No. 2017‐0418A    Director Rose stated that the Board should set rates to cover the cost and not penalize residents.    Motion made by Director Hase and seconded by Director Wilson to amend rate order 2017‐0321C and  adopt Rate Order No. 2017‐0418A and to give proper notice to the Town of Trophy Club.    For: Hase, Thomas, Carr and Wilson  Opposed:  Rose    Motion passed 4‐1    9. Consider and take appropriate action to approve Resolution No. 2017‐0418A amending the Fiscal Year  2017 Budget.    Steven Krolczyk reviewed the Budget amendment with the Board and answered questions related  thereto.      Motion made by Director Thomas and seconded by Director Carr to approve Resolution No. 2017‐0418A  amending the Fiscal Year 2017 Budget.    Motion carried unanimously    10. Discussion and possible action regarding stipend for Management Staff for period of August 26, 2016  through February 19, 2017    General Manager Shane Jeff stated that after giving staff their annual reviews he wanted to ask the board  to consider a stipend for the managers. Jeff stated that District managers do not get paid overtime nor  do they receive comp time.  President Carr stated that stipends are not allowed by Texas Law.  Attorney  Paul Liston stated that the law prohibits the board from retroactively paying employees so unless it is  stated in the personnel policy of the District.       Director Rose stated that this is not a pay increase or a bonus, he says this is for work that was performed.   That the staff performed the work of the General Manager and the Administration Manager.  Rose  clarified that this would be a stipend for work performed outside of the employees’ job description.    Director Carr stated that we are talking about salaried employees and read that exempt or salaried  Trophy Club Municipal Utility District No. 1 14 of 149 May 16, 2017 - Agenda Packet     personnel do not receive overtime and are paid a salary regardless of how many hours the employee  works.     Director Wilson asked legal to bring back the laws and parameters governing stipends for employees to  the next meeting.  Director Carr wants a list of what employees did that was above and beyond.       11. Consider and take appropriate action regarding the March 2017 combined financials and variance report.  a. Combined financials   b. Variance report    Motion made by Director Hase and seconded by Director Rose to approve the March 2017 combined  financials and variance report.     Motion carried unanimously      12. Consider and take appropriate action regarding the duties of a public officer, Greg Wilson, as they relate  to incompatibility with another public office. (Liston)    Director Thomas gave an overview of why he brought this to the Board.            Attorney, Paul Liston stated that he had been reaching out to the Town attorney for a month and got a  response today that they will review it tomorrow.     REPORTS & UPDATES  13. Receive update from legal counsel:  a. 1 Michele Court communications  b. Easement acquisition from United Methodist Church  c. Meeting with Town staff regarding enforcement of Water restrictions     Attorney Liston stated that the letter was sent to the homeowners of 1 Michele Court regarding the  utility easement and further repairs within the easement would be their responsibility.  Liston stated  that the easement acquisition from United Methodist Church is complete and if the church has signed  the easement it will need the notarized signature from the Board President and it can be filed with  Denton County.       The General Manager met with the Town Manager regarding the enforcement of water restrictions. He  stated that the Town Manager was going to speak with the Code Enforcement Officer and he has not  heard back at this time.       14. General Manager Monthly Reports and Updates   a. Water System Operation  b. Wastewater System Operation   c. Wastewater Treatment Plant Permit renewal update  d. Enforcement Case No. 52342, TCEQ Texas Commission on Environmental Quality  e. Finance Update   Utility Billing Reports  Trophy Club Municipal Utility District No. 1 15 of 149 May 16, 2017 - Agenda Packet      Permits Collected  f. Project Status Updates   Wastewater Treatment Plant Upgrade Project   Restroom Remodel Project   MCCI   g. Waterfest Overview    General Manager Shane Jeff reviewed the monthly reports and updates with the Board and answered  questions related thereto.     CLOSED SESSION  15. Pursuant to section 551.071, the District will consult with its attorney 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. Webber Cadagua     REGULAR SESSION  16. Consider and take appropriate action on matters deliberated in Closed Session:    The Board of Directors did not deliberate into Closed Session.    17. Items for future agendas: Manager Stipend, Incompatibility of Office,  Ethics policy (GM)    18. Set future Meeting dates:  Regular Meeting on May 16, 2017 at 6:30 p.m.       Motion made by Director Rose seconded by Director Thomas to adjourn the meeting at 8:54 p.m.    ADJOURN      ___________________________  Kevin R. Carr President                                                                                                    ____________________________                                  (SEAL)  Jim Hase, Secretary/Treasurer                                 ____________________________  Laurie Slaght, District Secretary        Trophy Club Municipal Utility District No. 1 16 of 149 May 16, 2017 - Agenda Packet        STAFF REPORT  May 16, 2017 Regular Board Meeting  Agenda Item No. 1 ‐ Consider and take appropriate action regarding request for reduction of winter  average rate by customer residing at 11O5 Sunset Drive.    Background: Lauren Zych sent an email to the Board of Directors on Tuesday May 9, 2017 requesting a  review of their winter averaging rate due to a water leak occurring December and January.  I. Customer was notified by a neighbor in November (2016) about a leak as water was draining  into the neighbor’s yard.    II. On December 29, 2016 a District staff notified the customer again about a possible leak due to a  higher than normal meter reading.    III. Customer put in a work order on January 8, 2017 no leak was detected in the District water line.    IV. Customer does not state when the leak was discovered, but states the “leak was coming from a  pipe under the house and was located in the flower bed.”    V. American Leak Detection fixed the leak on January 27, 2017    VI. Customer sent request for reduction of winter average rate on May 9, 2017.      The Board of Directors adopted Rate Order No. 2016‐0920A which states:   “Any resident filling a pool due to maintenance or construction during the averaging months may request  that the water used be subtracted from the usage of the month the water was used.  A resident with a  houseline leak during the averaging months may request a reduction in the sewer usage calculation.  Requests must be in writing to the General Manager and have documentation showing maintenance,  construction or repairs as applicable to the issue.  All requests for sewer average reductions must be  submitted no later than March 15th.  The General Manager or a duly authorized representative may  adjust the metered water usage in determining the winter average.”      Average bill before leak‐‐$73.40  New Winter Average bill‐‐$122.34  Increase of‐‐ $48.94    Staff recommendation:  Staff does not recommend that an adjustment be made to the customer  winter average due to the untimeliness of filing the request.     Trophy Club Municipal Utility District No. 1 17 of 149 May 16, 2017 - Agenda Packet                                                               Trophy Club Municipal Utility District No. 1 18 of 149 May 16, 2017 - Agenda Packet Trophy Club Municipal Utility District No. 119 of 149May 16, 2017 - Agenda Packet Trophy Club Municipal Utility District No. 120 of 149May 16, 2017 - Agenda Packet Trophy Club Municipal Utility District No. 1 March 21, 2017 Regular Meet ing Minu t es -Amended d. Resolution No. 2017-0321D approving submittal of Water Smart Application to the Association of Water Board Directors Director Carr requested to have item removed the February 15, 2017 minut es from the consent agenda for further discussion. **Motion made by Director Rose and seconded by Director Thomas to approve items a, b and d as pres ented on the consent agenda as presented. Di rection is given t o t he District Secreta ry t o amend the February meeting minut es adding Joyce Bakers comments. Motion made by Director Rose and seconded by Director Thomas to approve the February 15, 2017 Regular M e eting minutes as amended. Motion carried unanimously REGULAR SESSION 2. Consider and take a ppropriat e action regarding request of waiver from the Town of Trophy Club for Fire Prevention System 8" meter deposit i n the amount of $5,361.62. (Staff) General Manager Shane Jeff st at ed that the charge for the meter is the actual cost of t he meter. Water Superintendent Mike McMahon st ated that the fire meters have been required on properties that have a 2" meter or larger for well over a year and they are an important part of monitoring wat er loss. McMahon stated that the schools do not have the meters and are exempt from impact fees as well from the City of Fort Worth. Director Rose st ated t hat the Town of Trophy Club is a government entity as well as schools and if the meter s are not on the schools, he wou l d be i ncl ined to not require the meter for the To w n . Motion made by Director Hase and seconded by Director Carr not to grant a waiver to the Town and that installation of a fire m eter be required by the Town of Trophy Club for the Town Hall and the Town pay $5 ,361.62, the cost of the meter. For: Hase, Carr Oppose d : Thomas, Rose, Wilson Motion Fail ed 2-3 Motion m ad e by Director Wilson and seconded by Director Ro se t o gr ant an excepti on to the Town of Trophy Club f o r the 8" meter deposit in the amount o f $5,361.62 . and a uthorize the Ge neral Man ager to exp end District funds for the purchase and installation of th e m eter if h e d eem s it necessary. Fo r: Wilson, Ro se , and Thomas Oppose d : Hase & Carr Mot ion passe d 3-2 Motion i s amended by the First and Second to add the following lang uage: And authorize the Gene ral Manager to expend District funds for the purchase and ins tallation of the m e ter if he deems it necessary. 2 of9 Trophy Club Municipal Utility District No. 1 21 of 149 May 16, 2017 - Agenda Packet Trophy Club Municipal Utility District No.1 For: Wilson, Rose, and Thom as Opposed: Hase & Carr Motion as amend ed p assed 3-2 March 21, 2017 Regular Meeting Minutes-Amended 3. Review, December, January and February sewer usage comparisons t o prior years and any possible sewer reven ue loss. Director Rose presented a recap of residential usage for December 2016 and January and February of 2017. Rose pointed out that after gearing residents up for winter averagi ng and pushing water conservation, res idents showed a re d uction of 310.412 gallons for December 2016, 2,638,358 in Ja nuary 2017 and 5,534,096 in February 2017. 4. Co nsider and take appropriate action rega r ding pr oposed sewe r rates including: a. Summary and review of sewer models developed by NewGen Strategies. b. Provide direction to staff regarding proposed sewer rates for inclusion in an amended rate order. Chris Ekrut with N ewGen Strategies presented the Board with new scena r ios as requested. Motion made b y Direct o r Ha se and seconded b y Di re ctor W i l son to eliminate Scen ario a. which ha s a ba se rate of $15.35 . Moti on carried unanimously The Board asks t h at scenario 4 be considered. Mr. Ekrut sta t ed that he wants everyone to be very clear that t his Scenario No.4 is winter averaging. Motio n made by Di r ector Wilso n and se conde d by Directo r Ro se to approve Sce nario No. 4 with a Base Rat e o f $17.50 as presented . For: Ro se, Wilson, a nd Thomas Opposed: Carr and Ha se Motion p assed 3·2 Motion m ad e by Director Ro se an d se conded by Direct or W i lson to amend current Rate Order No. 2017- 03218 to include the n ew propose d Se ction 2 .0 2 ad o pt Rat e Order 2017 -0 321C. For: Rose, Wil son, Carr, and Tho mas Opposed: Ha se Motion pa ssed 4 -1 M ot i on made by Director Hase and seconded b y Directo r Car r to lower the cap slowly for less of an i mpact on cu stomers. Fo r : Ha se and Thom as Opposed : Rose, W ilson and Car r Motion failed 2-3 3 of9 Trophy Club Municipal Utility District No. 1 22 of 149 May 16, 2017 - Agenda Packet 1 CERTIFICATE FOR ORDER THE STATE OF TEXAS § § COUNTIES OF DENTON AND TARRANT § I, the undersigned officer of the Board of Directors of Trophy Club Municipal Utility District No. 1 hereby certify as follows: 1. The Board of Directors of Trophy Club Municipal Utility District No. 1 convened in a regular meeting on the 16th day of May, 2017, and the roll was called of the duly constituted members of the Board, to wit: Kevin R. Carr President Greg Wilson Vice President Jim Hase Secretary-Treasurer Jim Thomas Director Bill Rose Director All members of the Board were present except _____________________, thus constituting a quorum. Whereupon, among other business, the following was transacted at such meeting: ORDER CANVASSING THE RETURNS AND DECLARING RESULTS OF A BOND ELECTION FOR TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 was introduced for the consideration of the Board. It was then duly moved and seconded that the Order be adopted, and, after due discussion, the motion, carrying with it the adoption of the Order, prevailed and carried by the following vote: Ayes: Nays: Abstentions: 2. A true, full and correct copy of the aforesaid Order adopted at the meeting described in the above and foregoing paragraph is attached to and follows this certificate; the Order has been duly recorded in the Board's minutes of the meeting; the persons named in the above and foregoing paragraph are the duly chosen, qualified and acting members of the Board as indicated therein; each of the members of the Board was duly and sufficiently notified officially and personally, in advance, of the time, place and purpose of the aforesaid meeting, and that the Order would be introduced and considered for adoption at the meeting; and each of the members consented, in advance, to the holding of the meeting for such purpose; the meeting was open to the public as required by law; and public notice of the time, place and subject of the meeting was given as Trophy Club Municipal Utility District No. 1 23 of 149 May 16, 2017 - Agenda Packet 2 required by Chapter 551, Texas Government Code, as amended. SIGNED AND SEALED the 16th day of May, 2017. (SEAL) ____________________________ Secretary-Treasurer, Board of Directors Trophy Club Municipal Utility District No. 1 24 of 149 May 16, 2017 - Agenda Packet 3 ORDER 2017-0516 ORDER CANVASSING THE RETURNS AND DECLARING RESULTS OF A BOND ELECTION FOR TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 WHEREAS, the Board of Directors of the Trophy Club Municipal Utility District No. 1 (the “District”) ordered an election to be held on May 6, 2017, on the PROPOSITION hereinafter stated; and WHEREAS, notice of the election was posted in accordance with the Texas Constitution and Texas Water Code, as amended, and the Texas Election Code, as amended; and WHEREAS, the Board of Directors has investigated all matters pertaining to the election including the ordering, giving notice, officers, holding, and making returns of the election; and WHEREAS, the election officers who held the election have duly made the returns of the result thereof, and the returns have been duly delivered to this Board of Directors. THEREFORE, BE IT ORDERED BY THE BOARD OF DIRECTORS OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 THAT: 1. The Board of Directors officially finds and determines that the election was duly ordered, that proper notice of the election was duly given, that proper election officers were duly appointed prior to the election, that the election was duly held, that the District has complied with the Federal Voting Rights Act and the Texas Election Code, that the due returns of the result of the election have been made and delivered, and that the Board of Directors has duly canvassed the returns all in accordance with law and the Order calling the election. 2. The Board of Directors officially finds and determines that the following votes were cast at the election on the submitted PROPOSITION by the resident, qualified electors of said District, who voted at said election. PROPOSITION [324] FOR THE ISSUANCE OF $2,420,000 BONDS FOR WATERWORKS SYSTEM IMPROVEMENTS AND THE LEVY OF TAXES IN PAYMENT OF [733] AGAINST THE BONDS 3. The Board of Directors officially finds, determines and declares the result of the election to be that the PROPOSITION so submitted has not received a favorable majority vote in Trophy Club Municipal Utility District No. 1 25 of 149 May 16, 2017 - Agenda Packet 4 all respects and has not carried. Accordingly, the aforesaid bonds may not be issued and the aforesaid bond tax may not be levied, assessed and collected. PASSED AND APPROVED the ______ day of _______________________, 2017. __________________________________ President, Board of Directors ATTEST: ___________________________ Secretary-Treasurer, Board of Directors (SEAL) Trophy Club Municipal Utility District No. 1 26 of 149 May 16, 2017 - Agenda Packet FYEExisting Total(9/30)Revenues (1)Expenditures (2)Available for Debt ServiceDebtPrincipalInterestTotalDebt ServiceCoverage (4)20166,356,204$                      5,163,671$                      1,192,533$                     598,244$              598,244$              1.99X20176,356,204                        5,163,671                        1,192,533                       836,059               836,059               1.43X20186,356,204                        5,163,671                        1,192,533                       876,021               65,000$                131,083$              196,083$              1,072,104            1.11X20196,356,204                        5,163,671                        1,192,533                       872,339               75,000                 117,750                192,750               1,065,089            1.12X20206,356,204                        5,163,671                        1,192,533                       873,363               80,000                 114,000                194,000               1,067,363            1.12X20216,356,204                        5,163,671                        1,192,533                       874,036               85,000                 110,000                195,000               1,069,036            1.12X20226,356,204                        5,163,671                        1,192,533                       879,402               90,000                 105,750                195,750               1,075,152            1.11X20236,356,204                        5,163,671                        1,192,533                       879,376               95,000                 101,250                196,250               1,075,626            1.11X20246,356,204                        5,163,671                        1,192,533                       883,952               100,000               96,500                  196,500               1,080,452            1.10X20256,356,204                        5,163,671                        1,192,533                       893,030               105,000               91,500                  196,500               1,089,530            1.09X20266,356,204                        5,163,671                        1,192,533                       890,475               110,000               86,250                  196,250               1,086,725            1.10X20276,356,204                        5,163,671                        1,192,533                       896,388               115,000               80,750                  195,750               1,092,138            1.09X20286,356,204                        5,163,671                        1,192,533                       896,500               120,000               75,000                  195,000               1,091,500            1.09X20296,356,204                        5,163,671                        1,192,533                       904,782               125,000               69,000                  194,000               1,098,782            1.09X20306,356,204                        5,163,671                        1,192,533                       906,809               130,000               62,750                  192,750               1,099,559            1.08X20316,356,204                        5,163,671                        1,192,533                       911,691               140,000               56,250                  196,250               1,107,941            1.08X20326,356,204                        5,163,671                        1,192,533                       915,661               145,000               49,250                  194,250               1,109,911            1.07X20336,356,204                        5,163,671                        1,192,533                       913,836               150,000               42,000                  192,000               1,105,836            1.08X20346,356,204                        5,163,671                        1,192,533                       926,286               160,000               34,500                  194,500               1,120,786            1.06X20356,356,204                        5,163,671                        1,192,533                       926,738 170,000               26,500                  196,500               1,123,238            1.06X20366,356,204                        5,163,671                        1,192,533                       275,724 175,000               18,000                  193,000               468,724               2.54X2037 6,356,204                        5,163,671                        1,192,533                        ‐                             185,000               9,250                     194,250               194,250               6.14XTotal17,830,708$        2,420,000$          1,477,333$          3,897,333$          21,728,041$        (1)  Please see user base growth assumptions on following page.(2)  Excludes capital outlays, depreciation and expenditures related to fire service and other tax supported items.(3)  Preliminary, subject to change.  Interest calculated at 5.00% for illustrative purposes only.  Includes Costs of Issuance of $240,000.(4) Additional Bonds Test = 1.20X Average Annual Debt Service; Rate Covenant = 1.10X scheduled debt service payment.Trophy Club Municipal Utility District No. 1Revenue Bond Issuance Analysisas of January 17, 2017$2,420,000 (3)Trophy Club Municipal Utility District No. 127 of 149May 16, 2017 - Agenda Packet CERTIFICATE FOR RESOLUTION THE STATE OF TEXAS § § COUNTIES OF DENTON AND TARRANT § I, the undersigned officer of the Board of Directors of Trophy Club Municipal Utility District No. 1 hereby certify as follows: 1. The Board of Directors of Trophy Club Municipal Utility District No. 1 convened in a regular meeting on the 16th day of May, 2017, and the roll was called of the duly constituted members of the Board, to wit: Kevin R. Carr President Greg Wilson Vice President Jim Hase Secretary-Treasurer Jim Thomas Director Bill Rose Director All members of the Board were present except _____________________, thus constituting a quorum. Whereupon, among other business, the following was transacted at such meeting: A RESOLUTION AUTHORIZING APPLICATION TO THE TEXAS COMMISSION ON ENVIRONMENTAL QUALITY FOR APPROVAL OF PROJECT AND BONDS was introduced for the consideration of the Board. It was then duly moved and seconded that the Resolution be adopted, and, after due discussion, the motion, carrying with it the adoption of the Resolution, prevailed and carried by the following vote: Ayes: Nays: Abstentions: 2. A true, full and correct copy of the aforesaid Resolution adopted at the meeting described in the above and foregoing paragraph is attached to and follows this certificate; the Resolution has been duly recorded in the Board's minutes of the meeting; the persons named in the above and foregoing paragraph are the duly chosen, qualified and acting members of the Board as indicated therein; each of the members of the Board was duly and sufficiently notified officially and personally, in advance, of the time, place and purpose of the aforesaid meeting, and that the Resolution would be introduced and considered for adoption at the meeting; and each of the members consented, in advance, to the holding of the meeting for such purpose; the meeting was open to the public as required by law; and public notice of the time, place and subject of the Trophy Club Municipal Utility District No. 1 28 of 149 May 16, 2017 - Agenda Packet meeting was given as required by Chapter 551, Texas Government Code, as amended. SIGNED AND SEALED the 16th day of May, 2017. (SEAL) ____________________________ Secretary-Treasurer, Board of Directors Trophy Club Municipal Utility District No. 1 29 of 149 May 16, 2017 - Agenda Packet RESOLUTION NO. 2017-0516 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 A RESOLUTION AUTHORIZING APPLICATION TO THE TEXAS COMMISSION ON ENVIRONMENTAL QUALITY FOR APPROVAL OF PROJECT AND BONDS WHEREAS, Trophy Club Municipal Utility District No. 1 (the "District") is a conservation and reclamation district of the State of Texas created and operating pursuant to Article 16, Section 59 of the Texas Constitution and Chapters 49 and 54, Texas Water Code, as amended; WHEREAS, the District is the successor by merger and consolidation of Trophy Club Municipal Utility District No. 1 ("Prior MUD 1") and Trophy Club Municipal Utility District No. 2 ("Prior MUD 2" and with Prior MUD 1, the "Prior MUDs") pursuant to a consolidation election held in the District on May 9, 2009 by which the District consolidated the Prior MUDs into the District and assumed all outstanding and voted but unissued bonds and taxes of the Prior MUDs; WHEREAS, the District now desires to issue up to $2,420,000 in in revenue bonds for the construction of improvements to the District's water system (the "Project") as generally identified in Exhibit “A” attached hereto described in the Engineering Report prepared by CP&Y Incorporated; WHEREAS, Section 49.181 of the Texas Water Code requires the District, when it desires to issue bonds, to submit in writing to the Texas Commission on Environmental Quality (the "Commission") an application for investigation of the Project and of the issuance of the bonds to finance the Project, together with a copy of the engineering report, data, profiles, maps, plans, and specifications prepared in connection therewith; and WHEREAS, the Board of Directors desires to secure the approval and consent of the Commission for the Project, which is more completely described in the Engineering Report submitted in connection with this application, and to the issuance of the bonds hereinafter described in Section 1(b) of this Resolution. THEREFORE, BE IT RESOLVED BY THE BOARD OF DIRECTORS OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1: Section 1. The President and Secretary of the Board of Directors of the Trophy Club Municipal Utility District No. 1 (the "District"), the District's attorneys, and the District's engineers are hereby authorized and directed as follows: (a) To make application to the Texas Commission on Environmental Quality (the "Commission") for an investigation and report upon the feasibility of the Project, such Project being generally identified on Exhibit “A” attached hereto and in the Engineering Report prepared by CP&Y Incorporated in connection with this application; and (b) To request the Commission to approve the revenue bonds of the District in the principal amount not to exceed $2,420,000, bearing interest at a net effective interest rate not to exceed the maximum legal limit in effect at the time of issuance, and each maturing serially in accordance with the schedule provided in the aforesaid application and Engineering Report. Trophy Club Municipal Utility District No. 1 30 of 149 May 16, 2017 - Agenda Packet Section 2. By this application, the District assures the Commission that it will abide by the terms and conditions prescribed in connection with the Commission's approval of the Project. Section 3. CP&Y Incorporated is authorized and directed to prepare an Engineering Report in the form required by the Commission and to submit same to the Commission in support of this application together with a copy of the data, profiles, maps, plans and specifications prepared in connection with such report. Section 4. The President and Secretary of the Board of Directors, the District's General Manager, the District's engineering consultants, the District's legal counsel, and the District's Financial Advisor are authorized and directed to do any and all things necessary and proper in connection with this application, including the filing of this application with the Commission. Section 5. A certified copy of this Resolution shall constitute an application and request on behalf of the District to the Commission pursuant to Section 49.181, Texas Water Code, for approval of the Project described in Section 1(a) and the bonds described in Section 1(b). Section 6. The Board hereby authorizes CP&Y Incorporated to request the Commission for expedited review of the District's application in accordance with Sections 293.42 and 293.43 of the Commission rules. Section 7. The Board of Directors hereby approves the payment of all filing fees to the Commission that may be applicable to the application and requests that are the subject of this Resolution. RESOLVED, PASSED AND APPROVED THIS MAY 16, 2017. TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 Kevin R. Carr, President, Board of Directors ATTEST: ___________________________________ [SEAL] Jim Hase Secretary, Board of Directors Trophy Club Municipal Utility District No. 1 31 of 149 May 16, 2017 - Agenda Packet Exhibit “A” Description of Project 16-inch water transmission line and related appurtenances to extend from the District’s ground storage tank to the District’s elevated storage tank located on T.W. King Road Trophy Club Municipal Utility District No. 1 32 of 149 May 16, 2017 - Agenda Packet Trophy Club Municipal Utility District No.1 Work Order Authorization Agreement For Professional Engineering Services with Halff Associates, Inc. Contract Amendment No.1 (5-4-2017) 1 5/4/2017 Off-Site Water Line for Trophy Club Town Center Development Project #32127 Work Amendment No. 1 May 4, 2017 Scope of Work: Prepare a Tree Conservation Plan per the Town of Trophy Club ordinance for the referenced project. Items of work will include: 1. One (01) site visit with two surveyors\landscape design staff 2. Measurement of the tree size (DBH) and tagging of tree location, 3. Identify tree type and record appropriate data. 4. Determine health of trees according to Town of Trophy Club scoring matrix. 5. Prepare appropriate documents providing all pertinent information. The construction documents will show the location of trees; symbol indicating what trees will be removed or protected; trees with assigned numbers based on the field survey; a chart indicating size, type of tree both scientific and common name, condition, and additional comments. 6. Tree survey will also include appropriate details for the protection of trees during construction. 7. Sheets will be 22”x34” and will be signed by a Texas Licensed Landscape Architect Scope Exclusions: 1. Landscape Plan is not included. Deliverables: 1. Tree Survey Plan Items Furnished by the District: 1. None Schedule: Complete within twenty (20) working days of receiving Notice to Proceed and Items Furnished by the District. Trophy Club Municipal Utility District No. 1 33 of 149 May 16, 2017 - Agenda Packet Trophy Club Municipal Utility District No.1 Work Order Authorization Agreement For Professional Engineering Services with Halff Associates, Inc. Contract Amendment No.1 (5-4-2017) 2 5/4/2017 Fees: Task #1: $4,750.00 Total Fee: $4,750.00 This is a Lump Sum Fee and will be billed monthly based on percent complete. Direct costs (mileage, copies, etc) are included in this fee. Halff Associates is performing the services above under the terms and conditions described in the Agreement for Professional Engineering Services for the Off-Site Water Line for the Trophy Club Town Center Development, dated November 15, 2016, between Halff Associates and the Trophy Club Municipal Utility District No.1. Halff Associates will bill the above described services under AVO 32127. Submitted: Approved: HALFF ASSOCIATES, INC. TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO.1 By: ______________________________ By: _______________________________ Signature Signature Brian Haynes ________________________________ Printed Name Printed Name Vice President ________________________________ Title Title May 4, 2017 ________________________________ Date Date Trophy Club Municipal Utility District No. 1 34 of 149 May 16, 2017 - Agenda Packet Streets to be Repaired Duration of Repairs Carnoustie Dr. Portland Dr. Creek Courts Dr. and Culdesacs 2‐3 years Oakmont Dr.1‐2 years 1 year Capitol Improvements 5 Year Plan Trophy Club Municipal Utility District No. 1 35 of 149 May 16, 2017 - Agenda Packet May 5, 2017 Cost estimate: North Carnoustie & Portland Dr. To: Trophy Club Municipal Utility District No. 1 Attention: Mike McMahon Scope of work includes labor and materials as follows:  Mobilization to site  Temp Water & Services  Driveway removal, replacement, & Temp Drives  Mail Box Removal, replacement, & Temp Mail Boxes  Site investigation, deholing, location of underground utilities  Pressure testing & disinfection  Seeding, sodding  Carnoustie @ 1,587 LF of Water Line  Portland Dr @ 398 LF of Water Line  Carnoustie @ 34 Ea Water Services  Portland Dr @ 5 Ea Water Services  Saw cutting of existing road and replacement Full depth cuts by means of walk-behind saw machine Bid Item Description Units Unit Price 1 Portland Dr 58,300.00 58,300.00 1 North Carnoustie 226,500.00 226,500.00 1 Temp Water 55,000.00 55,000.00 $339,800.00 Grand Total = $339,800.00 EXCLUSIONS:  Sales Taxes (where applicable)  Permits, easements & right-of-way  Manifest of Hazardous materials – unforeseen materials  Liquidated Damages  Impact Fees PHONE (817) 535-3451 FAX (817) 535-0153 REY-MAR CONSTRUCTION FORT WORTH, TX 3416 Reed Street Fort Worth, TX 76119 Trophy Club Municipal Utility District No. 1 36 of 149 May 16, 2017 - Agenda Packet ORDER NO. 2017‐0516A    TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 AN ORDER  ESTABLISHING CODE OF ETHICS, POLICIES AND PROCEDURES  FOR DISTRICT FINANCIAL AFFAIRS AND MANAGEMENT    ARTICLE I    CODE OF ETHICS    Section 1.1 Policy Statement    (a) It is the policy of the District that no officer, director or employee of the District shall have any  interest, financial or otherwise, direct or indirect, or engage in any business transaction or professional  activity or incur any obligation of any nature which is in substantial conflict with the proper discharge of  his or her duties for the District in the public interest.    (b) To implement this policy and to strengthen the faith and confidence of the residents and property  owners of the District in the District’s officials and employees, the Board of the District has adopted the  following standards of conduct to be observed by all members of the Board in the performance of their  official duties.    Section 1.2 Open Meetings Act    (a) The Board of the District shall conduct all the affairs and proceedings of the District in accordance  with the requirements of the Texas Open Meetings Act.    (b) Every regular, special or called meeting of the Board of the District shall be open to the public,  unless, in accordance with the Open Meetings Act, the subject matter of the meeting requires  consideration by the Board in a closed meeting or executive session.    Section 1.3 Director Qualifications    (a) To be qualified to serve as a director, a person shall be at least 18 years old, a resident citizen of the  State of Texas, and either own land subject to taxation in the District or be a qualified voter within the  District.    (b) A director shall not serve as a member of the Board of the District if he or she is related within the  third degree of affinity or consanguinity to a developer of property in the District, any other member of  the Board, or the manager, engineer, attorney, or any other person providing professional services to  the District.    (c) A director shall not be an employee of any developer of property in the District or any other director,  manager, engineer, or attorney for the District.    (d) A director shall not be a developer of property in the District.    Trophy Club Municipal Utility District No. 1 37 of 149 May 16, 2017 - Agenda Packet (e) A director shall not serve as an attorney, consultant, engineer, manager, architect, or in some other  professional capacity for the District or a developer of property in the District in connection with the  District or property within the District.    (f) A director shall not be a party to a contract with or along with the District except for the purchase of  public services furnished by the District to the public generally.    (g) A director shall not be a party to a contract with a developer of property in the District relating to the  District or to property within the District (except for contracts limited solely to purchasing or conveying  real property for permanent residence, or commercial business, or qualifying as a director).    (h) A director shall be disqualified if, during the term of the director’s office, the director fails to  maintain the qualifications required by law to serve as a director.    (i) The Board shall replace a disqualified director within 60 days of determining that a director is  disqualified with a person who would not be disqualified.    (j) Any person who willfully occupies an office as director and exercises the powers and duties of that  office when disqualified under the provisions of this section is guilty of a misdemeanor under Texas law,  and on conviction, shall be fined not less than $100 nor more than $1,000.00.    Section 1.4 Removal of Director for Failure to Attend Meetings    (a) The Board, by unanimous vote of its remaining members, may remove an otherwise qualified  director if that director has missed one‐half or more of the regular meetings scheduled during the prior  twelve (12) months.    (b) Any director removed under Section 1.5(a) above may file a written appeal with the Texas  Commission on Environmental Quality within thirty (30) days after receiving written notice of the Board  action, pursuant to the procedure set forth by Section 49.052(6)(g), Texas Water Code.    Section 1.5 Conflicts of Interest    (a) A director who is financially interested in any contract with the District, or a director who is an  employee of a person who or firm which is financially interested in any contract with the District, shall  disclose that fact to the other directors, and the disclosure shall be entered into the minutes of the  meeting.    (b) An interested director may not vote on the acceptance of such contract or participate in the  discussion on the contract.    (c) If a director or a person related to that director has a substantial interest in a business entity or in  real property that would be pecuniary affected by an official action taken by the Board, the director shall  file an affidavit with the official record keeper of the district stating the nature and extent of the interest  and shall abstain from further participation in the matter.    (d) A director commits a criminal offense if the director knowingly fails to provide the affidavit as  described in Subsection (c) hereof or participates in a vote or decision on a matter if (i) in the case of a  Trophy Club Municipal Utility District No. 1 38 of 149 May 16, 2017 - Agenda Packet business entity in which the director or a person related to that director has a substantial interest, it is  reasonably foreseeable that an action on the matter would confer an economic benefit on the business  entity that is distinguishable from the effect on the public; or (ii) in the case of a substantial interest in  real property, it is reasonably foreseeable that an action on the matter will have a special economic  effect on the value of the property distinguishable from its effect on the public.    Section 1.6 Conflicts Disclosure      (a) In this Section, the following terms and phrases shall have the following meanings:    “Agent” means a third party who undertakes to transact some business or manage some affair for  another person by the authority or on account of the other person.  The term includes employee.    “Business Relationship” means a connection between two or more parties based on commercial activity  of one of the parties but does not include the following:  a) a transaction that is subject to rate or fee  regulation by a federal, state or local government entity; b) a transaction conducted at a price and  subject to terms available to the public; or c) a purchase or lease of goods or services from a person that  is chartered by a state or federal agency and that is subject to regular examination by, and reporting to,  that agency.      “Contract” means a written agreement for the sale or purchase of real property, Goods, or Services.    “Director” means a Director and any Agent of the District who exercises discretion in the planning,  recommending, selecting, or contracting of a Vendor.    “Family Member” means and includes the following relatives of a Director: mother and her spouse;  father and his spouse; son and his spouse; daughter and her spouse; spouse; and spouse’s mother,  father, son and daughter.    “Family relationship” means and includes the following relatives of a Director: mother and her spouse;  father and his spouse; son and his spouse; daughter and her spouse; grandmother and her spouse;  grandfather and his spouse; brother and his spouse; sister and her spouse; grandson; granddaughter;  aunt; uncle; niece; nephew; great‐grandson; great‐granddaughter; great‐grandmother; great‐ grandfather; spouse; spouse’s mother; spouse’s father; spouse’s son; spouse’s daughter; spouse’s  grandmother; spouse’s grandfather; spouse’s grandson; spouse’s granddaughter; spouse’s brother; or  spouse’s sister.    “Gift” means any item(s) with an aggregate value of more than $100 but does not include the following:  a gift given by a Family Member of the person accepting the gift; a political contribution as defined by  Title 15, Election Code; or food accepted as a guest.      “Goods” means personal property.    “Investment Income” means dividends, capital gains, or interest income generated from a personal or  business checking or savings account, share draft or share account, or other similar account; a personal  or business investment; or a personal or business loan.  “Services” means skilled or unskilled labor or professional services, as defined by Section 2254.002,  Government Code (Professional Services Procurement Act).  Trophy Club Municipal Utility District No. 1 39 of 149 May 16, 2017 - Agenda Packet   “Vendor” means any person or the person’s Agent who enters or seeks to enter into a Contract with the  District.    (b) Conflicts Disclosure of Directors and Agents of the District    A Director shall file with the District’s records administrator a conflicts disclosure statement in the form  prescribed by the Texas Ethics Commission (“Ethics Commission”) with respect to a Vendor if:    (1) the Vendor has a Contract with the District or the District is considering entering into a Contract to  do business with the Vendor; and     (2) (i) the Vendor has an employment or other Business Relationship with the Director or a Family  Member of the Director that results in the Director or a Family Member of the Director receiving taxable  income, other than Investment Income, that exceeds $2,500 during the twelve month period preceding  the date that the Director becomes aware that the Contract has been executed or that the District is  considering entering into a Contract;      (ii) the Vendor has given to the Director or a Family Member of the Director one or more Gifts in the  twelve month period preceding the date the Director becomes aware that the District is considering  entering into a Contract or a Contract has been executed; or      (iii) the Vendor has a Family Relationship with the Director.      A Director shall file the required conflicts disclosure statement not later than 5:00 p.m. on the seventh  business day after the date the Director becomes aware of facts that require the filing of the statement.   A Director commits an offense, the degree of which is dependent upon the amount of the Contract, if he  or she knowingly violates this subsection.  As of the date of adoption of this Code of Ethics, Chapter 176  of the Texas Local Government Code governs conflict of interest disclosures of Directors and Vendors.    (c) Conflicts Disclosure by District Vendors    A Vendor shall file with the District’s records administrator a completed conflicts of interest  questionnaire in the form prescribed by the Ethics Commission if the Vendor has a Business Relationship  with the District and:    (1) has an employment or Business Relationship with a Director or a Family Member of the Director that  results in the Director or Family Member of a Director receiving taxable income, other than Investment  Income, that exceeds $2,500 during the twelve‐month period preceding the date that the Vendor  becomes aware that a Contract had been executed or that the District is considering entering into a  Contract;     (2) has given Gifts to a Director or Family Member of a Director; or    (3) has a Family Relationship with a Director of the District.    The questionnaire must be filed not later than the seventh business day after the later of:    Trophy Club Municipal Utility District No. 1 40 of 149 May 16, 2017 - Agenda Packet (1) the date the Vendor (a) begins discussions or negotiations to enter into a Contract with the District  or (b) submits to the District an application, a response to a request for proposals or bids,  correspondence or other writing related to a potential Contract with the District; or    (2) the date the Vendor becomes aware (a) of an employment or Business Relationship with a Director  or Family Member of a Director; (b) that a Gift has been given by the Vendor; or (c) of a Family  Relationship with a Director.    A Vendor commits an offense, the degree of which is dependent upon the amount of the Contract, if he  or she knowingly violates this subsection.    Section 1.7 Doctrine of Incompatibility    (a) A director shall not hold another office or position where one office is accountable or subordinate to  the other, or where there is an overlap of powers and duties such that the director could not  independently serve in both positions.    (b) A director shall not hold another office or position that represents interests in conflict with those  represented by the other office.    Section 1.8 Nepotism    A director shall not appoint or vote for or confirm the appointment or employment of any relative of  any member of the Board to any job or position paid for with public funds.    Section 1.9 Bribery    (a) A director shall not ask for, accept or agree to accept, money or anything of value as consideration  for a decision or other exercise of discretion as a public servant.    (b) A director shall reject any benefit for his or her past official actions in favor of another person.    Section 1.10 Abuse of Office    (a) A director shall not exercise his or her official powers without authority, fail to perform a required  duty, or improperly take or use any District or public property with the intent to obtain a personal  benefit.    (b) A director shall not unlawfully take advantage of his or her official capacity either to mistreat or to  impede an individual.    (c) A director shall not misuse information that he or she received, in advance of the public, because of  the director’s official capacity, and shall not engage in any business activity that might lead to the  disclosure of confidential information.    (d) A director shall reject any job, favor, or other benefit that might tend, or is intended, to impair or  influence his or her official conduct or independence.    Trophy Club Municipal Utility District No. 1 41 of 149 May 16, 2017 - Agenda Packet Section 1.11 Registration as Lobbyist    (a) Pursuant to Chapter 305, Texas Government Code, a director must register with the Texas Ethics  Commission (the “Ethics Commission”) if he or she makes a total expenditure of an amount determined  by Ethics Commission rule, but not less than $200 in a calendar quarter, not including the director’s own  travel, food or lodging expenses or the director’s own membership dues, on activities to communicate  directly with one or more members of the legislative or executive branch of state government to  influence legislation or administrative action.  If required to register under the provisions of this section,  a director shall register in accordance with Chapter 305 and the rules of the Ethics Commission.    (b) If required by Ethics Commission rule, a director who communicates directly with a member of the  legislative or executive branch concerning legislative or administrative action, other than routine  matters, shall file with the Ethics Commission the director’s name, the name of the District, the subject  matter of the communication, and other information the Ethics Commission considers relevant.    (c) District funds may not be used to compensate or reimburse the expenses over $50 of any person for  the purpose of communicating directly with a member of the legislative branch to influence legislation,  unless the person being compensated or reimbursed resides in the district of the member with whom  the person communicates, or files a written statement with the secretary of state that includes the  person’s name, the amount of compensation or reimbursement, and the name of the District.  This $50  limitation does not apply if the person is registered with the Ethics Commission, holds an elective public  office, or is a full‐time employee of the District.    (d) A person commits a criminal offense if the person intentionally or knowingly violates a provision of  Chapter 305, Texas Government Code.  A person who fails to register as required shall pay a civil penalty  in an amount determined by Ethics Commission rule.    Section 1.12 Director Open Meetings Training     A Director shall complete a course of training as prescribed by law of not less than one and not more  than two hours regarding the responsibilities of the District and its Board with regard to the Open  Meetings Act (Texas Government Code Chapter 551).  The Director must complete the training not later  than the 90th day after the date the Director takes the oath of office, provided however that any  Director who had taken the oath of office before January 1, 2006 must complete the training before  January 1, 2007.   The District will maintain and make available for public inspection the record of the  completion of the training by Board members.  The failure of one or more members of the Board of  Directors to complete the training does not affect the validity of an action taken by the District.     Section 1.13 Public Information Act Training     A Director shall complete a course of training as prescribed by law of not less than one and not more  than two hours regarding the responsibilities of the District and its Board, its officers and employees  with regard to the Public Information Act (Texas Government Code Chapter 552).  A Director must  complete the training not later than the 90th day after the date the Director takes the oath of office,  provided however that any Director who had taken the oath of office before January 1, 2006 must  complete the training before January 1, 2007.  The District will maintain and make available for public  inspection the record of the completion of the training by the Board members.    Trophy Club Municipal Utility District No. 1 42 of 149 May 16, 2017 - Agenda Packet ARTICLE II    POLICY FOR COMPENSATION AND TRAVEL EXPENSES    Section 2.1 Policy    Upon approval by the Board, a director may be reimbursed for travel or other reasonable expenses  incurred on behalf of the District upon presentation of a verified statement showing the number of days  actually spent in the service of the District and a general description of the duties performed for each  day of service.    Section 2.2 Fees of Office    A director shall receive a fee of office which shall be established by the Board in a separate resolution.   In no event shall the fee of office exceed the fees of office permitted under Chapter 49 of the Texas  Water Code.  Such fees of office shall not include the amount of any reimbursement for actual expenses  of transportation, meals, lodging or other expenses reasonably and necessarily incurred while engaging  in activities on behalf of the District.    Section 2.3 Transportation    The District shall reimburse the actual transportation expenses incurred by a director while performing  duties for the District, except that a director may not be reimbursed for transportation expenses on a  common carrier in an amount exceeding the lowest available fare.  For travel by automobile, the District  will pay a director roundtrip mileage at the current Internal Revenue Service mileage rate for travel by  automobile.  Except for an emergency, to be eligible for reimbursement, a director shall submit for  Board approval all estimated transportation expenses proposed to be incurred before the travel  expense is incurred.    Section 2.4 Meals and Lodging    (a) A director may receive reimbursement for actual and necessary expenses for meals and lodging  incurred in the performance of duties for the District.    (b) Expenses incurred by the spouse or children of a director shall not be reimbursable.    (c) Lodging will be paid at the single room rate for the hotel at which a meeting or conference is being  held or at any other comparable hotel.    Section 2.5 Reimbursement     Directors attending conferences must obtain approval of the Board of Directors to register for and  attend the conferences.  Directors attending Board meetings or conferences must submit an itemized  expense report to the Board of Directors of the District before reimbursement is made, subject to rules  regarding reasonable advances provided below.  Items on the expense report shall include lodging,  meals, reasonable tips, and transportation.  Directors sharing expenses may split reported expenses in  any manner they deem equitable, but the District will pay no more than 100% of the actual cost of  reimbursable items.  At the discretion of the Board of Directors, directors may receive a reasonable  Trophy Club Municipal Utility District No. 1 43 of 149 May 16, 2017 - Agenda Packet advance to cover anticipated expenditures, provided however that an itemized expense report must be  presented to the Board of Directors meeting next following the conference or meeting attended by  directors.  Upon approval by the Board of Directors of the expense report, the balance of the  reimbursement will be paid by the District.  If the advance received exceeds the actual expenses as  reflected on the expense report and approved by the Board of Directors, the director shall promptly  remit the balance due to the District.      ARTICLE III    POLICY FOR PROFESSIONAL CONSULTANT REVIEW      Section 3.1 Policy Statement    It is the objective of the Board to ensure that the District is receiving the highest quality professional  services from its various consultants.  In that regard, the Board shall review the performance of its  consultants based upon the terms of the consultants’ contracts, if any, and the customs and standards  of the community with respect to the profession of the consultants and the needs of the District.    Section 3.2 Frequency    The Board shall review the performance and contracts of the District’s professional consultants,  including but not limited to the attorney, engineer, tax assessor‐collector, bookkeeper, operator,  financial advisor and any other consultant engaged to perform services for the District at the time for  consideration of renewal of a consultant’s contract or at such other time and frequency as shall be  determined by the Board.    Section 3.3 Criteria for Review    (a) The Board’s review of a District consultant shall include an evaluation of the specific duties and  obligations being rendered by the consultant as called for under the terms of the consultant’s contract.    (b) The review shall also include an evaluation of the quality, economy, responsiveness and  completeness of the consultant’s performance of regular or special projects requested by the Board and  as to the consultant’s responses to Board requests for reports and specific information within the  consultant’s professional area of responsibility.    Section 3.4 Criteria for Selection    It is the intent of the Board when considering a change in consultants to review a minimum of two (2)  proposals when selecting a new consultant for the District.        Section 3.5 Professional Contracts    Trophy Club Municipal Utility District No. 1 44 of 149 May 16, 2017 - Agenda Packet (a) The Board shall engage an architect registered in the State of Texas to prepare any architectural  plans and specifications for a new building intended for education, assembly, or office occupancy whose  construction costs exceed One Hundred Thousand Dollars ($100,000) and which is to be constructed by  the District.    (b) In selecting an attorney, engineer, auditor, financial advisor, or other professional consultant, the  Board shall follow the procedures provided in Chapter 2254, Subchapter A, Texas Government Code,  and the Professional Services Procurement Act.  In making such a selection, the Board shall not use a  competitive bidding process but instead shall award contracts and engage services of such professionals  on the basis of demonstrated competence and qualifications for the type of professional services to be  performed and at fair and reasonable prices, as long as professional fees do not exceed any maximum  provided by law.    Section 3.6 Faithful Performance Bonds    (a) The District shall require that any officer, employee, or consultant who collects, pays or handles any  funds of the District to furnish or provide a bond, payable to the District, in an amount determined by  the Board to be sufficient to safeguard the District.    (b) Such bond shall be conditioned on the faithful performance of that person’s duties and on  accounting for all funds and property of the District.  The bond shall be signed or endorsed by a surety  company authorized to do business in the State of Texas.    (c) The Board may pay the premium on surety bonds required out of any available funds of the District.      ARTICLE IV    POLICY FOR USE OF MANAGEMENT INFORMATION      Section 4.1 Policy Statement    It is the objective of the Board to ensure that all appropriate financial data, statistics and reports are  made available to the Board regularly and are effectively used by the Board and the District’s  consultants to achieve the most efficient and economical performance of all District operations and  programs.    Section 4.2 Budgets    The Board shall adopt a detailed budget for the District’s general fund for each fiscal year prior to  commencement of the fiscal year, and the Board shall review the District’s performance in comparison  to the budget on a regular basis.  The Board shall utilize accepted budgeting practices annually to  determine debt service requirements for the following year prior to establishing the annual ad valorem  tax rate for the District.    Section 4.3 Audits    Trophy Club Municipal Utility District No. 1 45 of 149 May 16, 2017 - Agenda Packet (a) The Board or a committee of one or more directors appointed by the Board shall serve as an audit  committee of the Board of Directors.  The audit committee shall review engagement proposals from  auditors for approval by the Board, and the audit committee shall perform such preliminary review of  annual audit reports as may be needed prior to final Board approval to ensure that the audit process  results in presentation of complete and accurate audited financial statements of the District’s position.    (b) The District’s books and financial statements shall be prepared and maintained according to  accepted principles of municipal finance, including but not limited to “Audits of State and Local  Governmental Units” and “Governmental Accounting and Financial Reporting Standards.”         THE REMAINDER OF THIS PAGE INTENTIONALLY LEFT BLANK                                                                        Trophy Club Municipal Utility District No. 1 46 of 149 May 16, 2017 - Agenda Packet Passed, ordered and approved, this May 16, 2017.               __________________________________  Kevin R. Carr, Board President        ATTEST:                  ___________________________________  Jim Hase, Secretary Treasurer        I, the undersigned Secretary of the Board of Directors of Trophy Club Municipal Utility District No. 1,  hereby certify that the foregoing is a true and correct copy of the Order Establishing a Code of Ethics,  Policies and Procedures for District Financial Affairs and Management adopted by said Board at its  regular meeting of May 16, 2017, together with excerpts from the minutes of said Board’s meeting on  that date showing the adoption of said Order as same appear of record in the official minutes of the  Board on file in the District’s office.    I further certify that said meeting was open to the public, and that notice thereof was posted in  compliance with the provisions of Tex. Gov’t. Code Ann. § 551.001 et seq.    Witness my hand and the official seal of said District, this May 16, 2017.                        Trophy Club Municipal Utility District No. 1 47 of 149 May 16, 2017 - Agenda Packet TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET APRIL 2017 122 ASSETS FIRE DEPT. CASH IN BANK 694 INVESTMENTS 972,433 PREPAID EXPENSES 6,880 ADVALOREM PROPERTY TAXES RECEIVABLE 32,628 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE - TOTAL ASSETS 1,012,635 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 32,628 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 32,628 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 521,108 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 458,899 TOTAL FUND BALANCE 980,007 TOTAL LIABILITIES AND FUND BALANCE 1,012,635 Trophy Club Municipal Utility District No. 1 48 of 149 May 16, 2017 - Agenda Packet . glbase_tbam rgonzale Trophy Club MUD No.1 Page 1 18:31 05/10/17 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 112.02- 112.02 122-40010-000-000 Property Taxes/MUD Fire 1,035,810.00- 1,035,810.00- 6,658.06- 1,019,834.47- 98.458 15,975.53- 122-40011-000-000 Property Taxes/Fire-Delinquent 7.02- 1,967.93- 1,967.93 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 439.41- 2,553.75- 56.750 1,946.25- Subtotal: 1,040,310.00- 1,040,310.00- 7,104.49- 1,024,468.17- 98.477 15,841.83- 122-49900-000-000 Miscellaneous Income 149.00- 149.00 Subtotal: 149.00- 149.00 Program number: 1,040,310.00- 1,040,310.00- 7,104.49- 1,024,617.17- 98.492 15,692.83- Department number: Fire Revenues 1,040,310.00- 1,040,310.00- 7,104.49- 1,024,617.17- 98.492 15,692.83- Revenues Subtotal ----------- 1,040,310.00- 1,040,310.00- 7,104.49- 1,024,617.17- 98.492 15,692.83- Trophy Club Municipal Utility District No. 1 49 of 149 May 16, 2017 - Agenda Packet . glbase_tbam rgonzale Trophy Club MUD No.1 Page 2 18:31 05/10/17 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-55080-045-000 Maintenance & Repairs 10,753.91 10,753.91- Subtotal: 10,753.91 10,753.91- 122-60030-045-000 Rent And/Or Usage 216,754.00 216,754.00 216,754.00 122-60055-045-000 Insurance 16,513.00 16,513.00 1,376.09 9,632.63 58.334 6,880.37 122-60337-045-000 Transfer to Town/Fire Budget 581,638.00 581,638.00 48,974.00 336,763.00 57.899 244,875.00 Subtotal: 814,905.00 814,905.00 50,350.09 346,395.63 42.507 468,509.37 122-69005-045-000 Capital Outlays 16,836.00 16,836.00 16,836.00 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: 225,405.00 225,405.00 208,568.60 92.531 16,836.40 Program number: 1,040,310.00 1,040,310.00 50,350.09 565,718.14 54.380 474,591.86 Department number: Fire 1,040,310.00 1,040,310.00 50,350.09 565,718.14 54.380 474,591.86 Expenditures Subtotal ----------- 1,040,310.00 1,040,310.00 50,350.09 565,718.14 54.380 474,591.86 Fund number: 122 Trophy Club MUD Fire Dept. 43,245.60 458,899.03- 458,899.03 Trophy Club Municipal Utility District No. 1 50 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 1 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40001-000-000 Assessment - Emerg Svcs (112.02) .00 (112.02) _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: .00 (112.02) ** .00 Budgeted 112.02 Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 1417 04/03/2017 Property Taxes (1,013,176.41) (115.66) (1,013,292.07) GL 1418 04/04/2017 Property Taxes (889.43) (1,014,181.50) GL 1419 04/05/2017 Property Taxes (42.31) (1,014,223.81) GL 1420 04/06/2017 Property Taxes (69.89) (1,014,293.70) GL 1422 04/07/2017 Property Taxes (1,047.57) (1,015,341.27) GL 1423 04/10/2017 Property Taxes 1,047.57 (1,014,293.70) GL 1424 04/11/2017 Property Taxes (2,143.84) (1,016,437.54) GL 1425 04/13/2017 Property Taxes (313.00) (1,016,750.54) GL 1427 04/18/2017 Property Taxes (142.82) (1,016,893.36) GL 1428 04/20/2017 Property Taxes (509.83) (1,017,403.19) GL 1429 04/21/2017 Property Taxes (896.92) (1,018,300.11) GL 1430 04/25/2017 Property Taxes (4.98) (1,018,305.09) GL 1431 04/26/2017 Property Taxes (1,309.63) (1,019,614.72) GL 1432 04/28/2017 Property Taxes (219.75) (1,019,834.47) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (6,658.06) (1,019,834.47) ** (1,035,810.00) Budgeted (15,975.53) Remaining 98 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1418 04/04/2017 Property Taxes (1,960.91) (.24) (1,961.15) GL 1424 04/11/2017 Property Taxes (6.78) (1,967.93) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (7.02) (1,967.93) ** .00 Budgeted 1,967.93 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 1417 04/03/2017 Property Taxes (2,114.34) (6.71) (2,121.05) GL 1418 04/04/2017 Property Taxes (13.10) (2,134.15) GL 1420 04/06/2017 Property Taxes (4.89) (2,139.04) GL 1424 04/11/2017 Property Taxes (164.00) (2,303.04) GL 1425 04/13/2017 Property Taxes (34.43) (2,337.47) GL 1426 04/17/2017 Property Taxes 14.21 (2,323.26) GL 1428 04/20/2017 Property Taxes (56.09) (2,379.35) GL Trophy Club Municipal Utility District No. 1 51 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 2 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1429 04/21/2017 Property Taxes (2,114.34) (89.89) (2,469.24) GL 1430 04/25/2017 Property Taxes (.50) (2,469.74) GL 1431 04/26/2017 Property Taxes (59.91) (2,529.65) GL 1432 04/28/2017 Property Taxes (24.10) (2,553.75) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (439.41) (2,553.75) ** (4,500.00) Budgeted (1,946.25) Remaining 57 % Used Account: 122-49900-000-000 Miscellaneous Income (149.00) .00 (149.00) _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: .00 (149.00) ** .00 Budgeted 149.00 Remaining 0 % Used Department Totals: ----------------------------------- (1,024,617.17) ** (7,104.49) Monthly Total (1,040,310.00) Budgeted (15,692.83) Remaining 98 % Used Trophy Club Municipal Utility District No. 1 52 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 3 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2017 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 10,753.91 .00 10,753.91 _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: .00 10,753.91 ** .00 Budgeted (10,753.91) Remaining 0 % Used Account: 122-60005-045-000 Telephone 1449 04/28/2017 Adj Town Inv 1554/Overbilled AR 20170428-20170428 User: 10.00 10.00 AR 1454 04/28/2017 Recode JE 1449 AR 20170428-20170428 User: (10.00) .00 GL _______________ Account: 122-60005-045-000 Telephone Totals: .00 .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 122-60030-045-000 Rent And/Or Usage .00 .00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 .00 ** 216,754.00 Budgeted 216,754.00 Remaining 0 % Used Account: 122-60055-045-000 Insurance 466 04/01/2017 Insurance/Wrk Comp Exp Apr 8,256.54 1,376.09 9,632.63 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,376.09 9,632.63 ** 16,513.00 Budgeted 6,880.37 Remaining 58 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 1339 04/19/2017 April A/P April Fire Adm 287,789.00 48,974.00 336,763.00 TOWN OF TROPHY CLUB 3077 AP _______________ Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 48,974.00 336,763.00 ** 581,638.00 Budgeted 244,875.00 Remaining 58 % Used Account: 122-69005-045-000 Capital Outlays .00 .00 _______________ Account: 122-69005-045-000 Capital Outlays Totals: .00 .00 ** 16,836.00 Budgeted 16,836.00 Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement Trophy Club Municipal Utility District No. 1 53 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 4 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 81,420.00 .00 81,420.00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 81,420.00 ** 81,420.00 Budgeted .00 Remaining 100 % Used Account: 122-69305-045-000 Capital Leases 127,148.60 .00 127,148.60 _______________ Account: 122-69305-045-000 Capital Leases Totals: .00 127,148.60 ** 127,149.00 Budgeted .40 Remaining 100 % Used Department 45 Totals: ----------------------------------- 565,718.14 ** 50,350.09 Monthly Total 1,040,310.00 Budgeted 474,591.86 Remaining 54 % Used Fund 122 Totals: ----------------------------------- (458,899.03) 43,245.60 Monthly Total .00 Budgeted 458,899.03 Remaining 0 % Used Trophy Club Municipal Utility District No. 1 54 of 149 May 16, 2017 - Agenda Packet TROPHY CLUB MUD #1 - O&M BALANCE SHEET APRIL 2017 GTBGT GENERAL FUND GASB 4/30/2017 ASSETS CASH ON HAND 600 - 600 CASH IN BANK-CHECKING 811,345 - 811,345 CASH IN BANK-SAVINGS-CASH RESERVE 180,412 - 180,412 CD-BANK OF THE WEST/THB DEPOSIT 35,158 - 35,158 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 713,174 - 713,174 INVESTMENTS-TEXPOOL 613,214 433,170 1,046,383 PREPAID EXPENSES 37,554 - 37,554 ADVALOREM PROPERTY TAXES RECEIVABLE 2,708 - 2,708 UTILITY AND OTHER ACCOUNTS RECEIVABLE 878,198 - 878,198 TOTAL ASSETS 3,272,363 433,170 3,705,533 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 2,708 - 2,708 ACCOUNTS AND OTHER PAYABLES 632,770 - 632,770 CUSTOMER DEPOSITS 313,060 - 313,060 - TOTAL LIABILITIES 948,538 - 948,538 FUND BALANCE NON-SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 1,276,319 1,276,319 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 135,000 135,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT 90,000 90,000 ASSIGNED FUND BALANCE/SEWER REPLACEMENT 37,805 37,805 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 170,365 170,365 UNASSIGNED FUND BALANCE 851,803 - 851,803 COMMITTED FUND BALANCE - - - NET REVENUES / EXPENDITURES 192,216 - 192,216 - TOTAL FUND BALANCE 2,323,825 433,170 2,756,995 TOTAL LIABILITIES AND FUND BALANCE 3,272,363 433,170 3,705,533 Trophy Club Municipal Utility District No. 1 55 of 149 May 16, 2017 - Agenda Packet . glbase_tbam rgonzale Trophy Club MUD No.1 Page 3 18:31 05/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 60,977.00- 60,977.00- 391.69- 60,016.76- 98.425 960.24- 135-40002-000-000 Property Taxes/Delinquent 1.32- 164.26- 164.26 135-40015-000-000 Property Taxes/P & I 650.00- 650.00- 26.17- 165.76- 25.502 484.24- 135-40025-000-000 PID Surcharges 148,291.00- 148,291.00- 148,291.00- Subtotal: 209,918.00- 209,918.00- 419.18- 60,346.78- 28.748 149,571.22- 135-47000-000-000 Water 6,436,734.00- 6,436,734.00- 399,981.59- 2,622,124.11- 40.737 3,814,609.89- 135-47005-000-000 Sewer 2,629,524.00- 2,629,524.00- 331,916.95- 1,376,852.85- 52.361 1,252,671.15- 135-47025-000-000 Penalties 119,260.00- 119,260.00- 9,453.20- 66,182.15- 55.494 53,077.85- 135-47030-000-000 Service Charges 11,400.00- 11,400.00- 1,625.00- 8,500.00- 74.561 2,900.00- 135-47035-000-000 Plumbing Inspections 2,000.00- 2,000.00- 950.00- 47.500 1,050.00- 135-47045-000-000 Sewer Inspections 5,500.00- 5,500.00- 1,950.00- 35.455 3,550.00- 135-47070-000-000 TCCC Effluent Charges 61,188.00- 61,188.00- 752.25- 17,252.25- 28.195 43,935.75- Subtotal: 9,265,606.00- 9,265,606.00- 743,728.99- 4,093,811.36- 44.183 5,171,794.64- 135-49010-000-000 Interest Income 8,001.00- 8,001.00- 1,571.49- 8,818.17- 110.213 817.17 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 910.53- 6,373.71- 58.335 4,552.29- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 3,499.98- 50.000 3,500.02- 135-49026-000-000 Proceeds from Sale of Assets 2,000.00- 2,000.00- 2,000.00- 135-49035-000-000 Prior Year Reserves 295,408.00- 295,408.00- 135-49075-000-000 Oversize Meter Reimbursement 21,609.00- 21,609.00- 2,259.00- 10,015.00- 46.346 11,594.00- 135-49900-000-000 Miscellaneous Income 20,000.00- 20,000.00- 206.69- 6,091.98- 30.460 13,908.02- 135-49901-000-000 Records Management Revenue 20.00- 20.00- 2.00- 32.00- 160.000 12.00 Subtotal: 69,556.00- 364,964.00- 5,533.04- 34,830.84- 9.544 330,133.16- Program number: 9,545,080.00- 9,840,488.00- 749,681.21- 4,188,988.98- 42.569 5,651,499.02- Department number: Revenues 9,545,080.00- 9,840,488.00- 749,681.21- 4,188,988.98- 42.569 5,651,499.02- Revenues Subtotal ----------- 9,545,080.00- 9,840,488.00- 749,681.21- 4,188,988.98- 42.569 5,651,499.02- Trophy Club Municipal Utility District No. 1 56 of 149 May 16, 2017 - Agenda Packet . glbase_tbam rgonzale Trophy Club MUD No.1 Page 4 18:31 05/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 271,143.00 271,143.00 18,123.44 126,340.32 46.595 144,802.68 135-50010-010-000 Overtime 19,500.00 19,500.00 1,733.59 7,403.32 37.966 12,096.68 135-50016-010-000 Longevity 3,270.00 3,270.00 3,270.00 100.000 135-50017-010-000 Certification 4,800.00 4,800.00 250.00 1,700.00 35.417 3,100.00 135-50020-010-000 Retirement 27,151.00 27,151.00 1,859.90 12,510.35 46.077 14,640.65 135-50026-010-000 Medical Insurance 55,914.00 55,914.00 2,922.03 19,171.51 34.287 36,742.49 135-50027-010-000 Dental Insurance 4,159.00 4,159.00 299.27 1,799.98 43.279 2,359.02 135-50028-010-000 Vision Insurance 910.00 910.00 53.76 350.21 38.485 559.79 135-50029-010-000 Life Insurance & Other 2,803.00 2,803.00 230.01 1,559.97 55.654 1,243.03 135-50030-010-000 Social Security Taxes 19,021.00 19,021.00 1,207.17 8,369.21 44.000 10,651.79 135-50035-010-000 Medicare Taxes 4,448.00 4,448.00 282.34 1,957.33 44.005 2,490.67 135-50040-010-000 Unemployment Taxes 1,026.00 1,026.00 1.33 45.00 4.386 981.00 135-50045-010-000 Workman's Compensation 13,152.00 13,152.00 1,074.16 7,519.12 57.171 5,632.88 135-50060-010-000 Pre-emp Physicals/Testing 1,300.00 1,300.00 1,300.00 135-50070-010-000 Employee Relations 300.00 300.00 187.09 187.09 62.363 112.91 Subtotal: 428,897.00 428,897.00 28,224.09 192,183.41 44.809 236,713.59 135-55005-010-000 Engineering 5,000.00 60,000.00 16,685.25 36,224.43 60.374 23,775.57 135-55080-010-000 Maintenance & Repairs 100,000.00 128,500.00 5,930.23 49,749.41 38.715 78,750.59 135-55085-010-000 Generator Maint. and Repair 3,000.00 3,000.00 3,000.00 135-55090-010-000 Vehicle Maintenance 8,000.00 8,000.00 102.89 823.15 10.289 7,176.85 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 3,500.00 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 482.70 2,310.80 42.015 3,189.20 Subtotal: 125,000.00 208,500.00 23,201.07 89,107.79 42.738 119,392.21 135-60010-010-000 Communications/Mobiles 5,400.00 5,400.00 346.75 2,119.59 39.252 3,280.41 135-60020-010-000 Electricity 172,737.00 172,737.00 14,292.26 77,102.51 44.636 95,634.49 135-60066-010-000 Publications/Books/Subscripts 750.00 750.00 767.00 767.00 102.267 17.00- 135-60070-010-000 Dues & Memberships 500.00 500.00 500.00 135-60080-010-000 Schools & Training 4,222.00 4,222.00 265.00 6.277 3,957.00 135-60090-010-000 Safety Program 400.00 400.00 400.00 135-60100-010-000 Travel & per diem 1,500.00 1,500.00 124.46 8.297 1,375.54 135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 1,500.00 135-60135-010-000 TCEQ Fees & Permits 50,176.00 50,176.00 3,876.50 21,940.45 43.727 28,235.55 135-60150-010-000 Wholesale Water 2,998,802.00 2,998,802.00 159,459.08 858,983.95 28.644 2,139,818.05 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 102.70 102.70 51.350 97.30 135-60280-010-000 Property Maintenance 5,000.00 5,000.00 371.40- 594.60 11.892 4,405.40 135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 3,000.00 3,000.00 20.339 11,750.00 135-60332-010-000 Interfund Transfer Out-Rev I&S 297,011.00 297,011.00 21,892.88 153,250.13 51.597 143,760.87 135-60333-010-000 Interfund Transfer Out-Reserve 64,920.00 64,920.00 14,361.00 100,527.00 154.848 35,607.00- 135-60334-010-000 Interfund Transfer Out 200,000.00 200,000.00 200,000.00 135-60360-010-000 Furniture/Equipment < $5000 2,500.00 2,500.00 2,500.00 Trophy Club Municipal Utility District No. 1 57 of 149 May 16, 2017 - Agenda Packet . glbase_tbam rgonzale Trophy Club MUD No.1 Page 5 18:31 05/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 3,820,368.00 3,820,368.00 217,726.77 1,218,777.39 31.902 2,601,590.61 135-65005-010-000 Fuel & Lube 33,011.00 24,828.00 1,507.03 4,907.17 19.765 19,920.83 135-65010-010-000 Uniforms 4,608.00 4,608.00 1,329.48 28.852 3,278.52 135-65030-010-000 Chemicals 20,000.00 20,000.00 1,523.01 8,896.34 44.482 11,103.66 135-65035-010-000 Small Tools 1,200.00 1,200.00 221.62 18.468 978.38 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 1,000.00 135-65050-010-000 Meter Expense 115,000.00 31,500.00 5,361.62 17,069.88 54.190 14,430.12 135-65053-010-000 Meter Change Out Program 81,500.00 81,500.00 48,264.00 59.220 33,236.00 Subtotal: 256,319.00 164,636.00 8,391.66 80,688.49 49.010 83,947.51 135-69005-010-000 Capital Outlays 502,421.00 690,422.00 90.00 288,560.69 41.795 401,861.31 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 126,958.00 126,957.75 100.000 .25 Subtotal: 696,196.00 892,380.00 90.00 490,518.44 54.967 401,861.56 Program number: 5,326,780.00 5,514,781.00 277,633.59 2,071,275.52 37.559 3,443,505.48 Trophy Club Municipal Utility District No. 1 58 of 149 May 16, 2017 - Agenda Packet . glbase_tbam rgonzale Trophy Club MUD No.1 Page 6 18:31 05/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis for PID 5,000.00 5,000.00 287.70 895.40 17.908 4,104.60 Subtotal: 5,000.00 5,000.00 287.70 895.40 17.908 4,104.60 135-60135-010-001 TCEQ Fees & Permits for PID 5,000.00 5,000.00 5,000.00 Subtotal: 5,000.00 5,000.00 5,000.00 Program number: 1 Lab Analysis for PID 10,000.00 10,000.00 287.70 895.40 8.954 9,104.60 Department number: Water 5,336,780.00 5,524,781.00 277,921.29 2,072,170.92 37.507 3,452,610.08 Trophy Club Municipal Utility District No. 1 59 of 149 May 16, 2017 - Agenda Packet . glbase_tbam rgonzale Trophy Club MUD No.1 Page 7 18:31 05/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 391,102.00 391,102.00 30,026.81 207,447.34 53.042 183,654.66 135-50010-020-000 Overtime 29,500.00 29,500.00 2,426.27 19,526.94 66.193 9,973.06 135-50016-020-000 Longevity 6,635.00 6,635.00 6,635.00 100.000 135-50017-020-000 Certification 7,800.00 7,800.00 475.00 4,225.00 54.167 3,575.00 135-50020-020-000 Retirement 39,584.00 39,584.00 3,045.84 21,449.31 54.187 18,134.69 135-50026-020-000 Medical Insurance 73,022.00 73,022.00 4,710.20 31,584.51 43.253 41,437.49 135-50027-020-000 Dental Insurance 4,592.00 4,592.00 399.32 2,467.72 53.740 2,124.28 135-50028-020-000 Vision Insurance 1,031.00 1,031.00 84.33 532.59 51.658 498.41 135-50029-020-000 Life Insurance & Other 4,485.00 4,485.00 383.89 2,606.02 58.105 1,878.98 135-50030-020-000 Social Security Taxes 27,886.00 27,886.00 1,918.71 13,822.92 49.569 14,063.08 135-50035-020-000 Medicare Taxes 6,522.00 6,522.00 448.73 3,232.77 49.567 3,289.23 135-50040-020-000 Unemployment Taxes 1,197.00 1,197.00 63.00 5.263 1,134.00 135-50045-020-000 Workman's Compensation 11,347.00 11,347.00 926.75 6,487.25 57.171 4,859.75 135-50060-020-000 Pre-emp Physicals/Testing 300.00 300.00 300.00 135-50070-020-000 Employee Relations 650.00 650.00 325.22 50.034 324.78 Subtotal: 605,653.00 605,653.00 44,845.85 320,405.59 52.903 285,247.41 135-55005-020-000 Engineering 70,000.00 70,000.00 70,000.00 135-55070-020-000 Independent Labor 20,000.00 20,000.00 19,449.39 97.247 550.61 135-55080-020-000 Maintenance & Repairs 83,100.00 79,700.00 5,100.72 35,474.06 44.509 44,225.94 135-55085-020-000 Generator Maint. and Repair 20,000.00 20,000.00 20,000.00 135-55090-020-000 Vehicle Maintenance 4,000.00 6,600.00 1,662.14 7,057.53 106.932 457.53- 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 23.94 4.788 476.06 135-55125-020-000 Dumpster Services 55,000.00 55,000.00 2,551.48 30,402.86 55.278 24,597.14 135-55135-020-000 Lab Analysis 25,000.00 25,000.00 2,708.00 16,321.00 65.284 8,679.00 Subtotal: 277,600.00 276,800.00 12,022.34 108,728.78 39.281 168,071.22 135-60010-020-000 Communications/Mobiles 5,400.00 5,400.00 411.68 2,844.73 52.680 2,555.27 135-60020-020-000 Electricity 158,627.00 158,627.00 13,936.27 76,582.56 48.278 82,044.44 135-60066-020-000 Publications/Books/Subscripts 400.00 400.00 143.85 35.963 256.15 135-60070-020-000 Dues & Memberships 250.00 267.00 267.00 100.000 135-60080-020-000 Schools & Training 4,195.00 4,195.00 2,307.81 55.013 1,887.19 135-60090-020-000 Safety Program 550.00 550.00 24.99 282.15 51.300 267.85 135-60100-020-000 Travel & per diem 1,600.00 2,400.00 115.29 2,245.50 93.563 154.50 135-60105-020-000 Rent/Lease Equipment 9,000.00 9,000.00 9,000.00 135-60125-020-000 Advertising 4,086.37 4,086.37- 135-60135-020-000 TCEQ Fees & Permits 17,150.00 17,150.00 14,565.97 84.933 2,584.03 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 450.00 135-60280-020-000 Property Maintenance 6,621.00 6,621.00 590.00- 6,621.00 135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 2,360.00 2,360.00 20.345 9,240.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 120,492.00 120,492.00 10,953.82 76,676.74 63.636 43,815.26 135-60332-020-000 Interfund Transfer Out-Rev I&S 595,638.00 595,638.00 54,148.91 379,042.37 63.636 216,595.63 Trophy Club Municipal Utility District No. 1 60 of 149 May 16, 2017 - Agenda Packet . glbase_tbam rgonzale Trophy Club MUD No.1 Page 8 18:31 05/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60333-020-000 Interfund Transfer Out-Reserve 123,492.00 123,492.00 56,132.70 45.455 67,359.30 135-60334-020-000 Interfund Transfer Out 200,000.00 200,000.00 200,000.00 Subtotal: 1,255,465.00 1,256,282.00 81,360.96 617,537.75 49.156 638,744.25 135-65005-020-000 Fuel & Lube 28,088.00 28,088.00 1,629.03 5,074.05 18.065 23,013.95 135-65010-020-000 Uniforms 4,459.00 4,459.00 3,753.87 84.186 705.13 135-65030-020-000 Chemicals 25,000.00 21,000.00 14,942.29 71.154 6,057.71 135-65035-020-000 Small Tools 2,000.00 2,000.00 267.64 1,367.82 68.391 632.18 135-65040-020-000 Safety Equipment 750.00 750.00 252.64 33.685 497.36 135-65045-020-000 Lab Supplies 14,000.00 14,000.00 2,879.52 10,668.77 76.206 3,331.23 Subtotal: 74,297.00 70,297.00 4,776.19 36,059.44 51.296 34,237.56 135-69005-020-000 Capital Outlays 485,000.00 462,000.00 196,357.40 42.502 265,642.60 Subtotal: 485,000.00 462,000.00 196,357.40 42.502 265,642.60 Program number: 2,698,015.00 2,671,032.00 143,005.34 1,279,088.96 47.887 1,391,943.04 Department number: Wastewater 2,698,015.00 2,671,032.00 143,005.34 1,279,088.96 47.887 1,391,943.04 Trophy Club Municipal Utility District No. 1 61 of 149 May 16, 2017 - Agenda Packet . glbase_tbam rgonzale Trophy Club MUD No.1 Page 9 18:31 05/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50045-026-000 Workman's Compensation 32.00 32.00 2.61 18.27 57.094 13.73 Subtotal: 32.00 32.00 2.61 18.27 57.094 13.73 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 500.00 500.00 500.00 135-60075-026-000 Meetings 1,200.00 1,200.00 1,200.00 135-60080-026-000 Schools & Training 4,000.00 4,000.00 1,165.00 2,725.00 68.125 1,275.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 1,819.37 36.387 3,180.63 135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 2,000.00 Subtotal: 12,850.00 12,850.00 1,165.00 4,544.37 35.365 8,305.63 Program number: 12,882.00 12,882.00 1,167.61 4,562.64 35.419 8,319.36 Department number: Board of Directors 12,882.00 12,882.00 1,167.61 4,562.64 35.419 8,319.36 Trophy Club Municipal Utility District No. 1 62 of 149 May 16, 2017 - Agenda Packet . glbase_tbam rgonzale Trophy Club MUD No.1 Page 10 18:31 05/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 519,883.00 519,883.00 39,054.80 223,053.65 42.905 296,829.35 135-50010-030-000 Overtime 1,000.00 2,500.00 1,414.60 3,193.23 127.729 693.23- 135-50016-030-000 Longevity 3,890.00 3,417.00 3,417.50 100.015 .50- 135-50020-030-000 Retirement 47,768.00 47,768.00 3,743.41 20,547.77 43.016 27,220.23 135-50026-030-000 Medical Insurance 84,289.00 84,289.00 4,551.97 25,051.23 29.721 59,237.77 135-50027-030-000 Dental Insurance 5,981.00 5,981.00 416.81 2,169.78 36.278 3,811.22 135-50028-030-000 Vision Insurance 1,312.00 1,312.00 88.84 464.25 35.385 847.75 135-50029-030-000 Life Insurance & Other 5,890.00 5,890.00 525.18 2,420.55 41.096 3,469.45 135-50030-030-000 Social Security Taxes 32,777.00 32,777.00 2,397.57 13,481.48 41.131 19,295.52 135-50035-030-000 Medicare Taxes 8,084.00 8,084.00 560.74 3,152.92 39.002 4,931.08 135-50040-030-000 Unemployment Taxes 1,368.00 1,368.00 4.98 293.73 21.471 1,074.27 135-50045-030-000 Workman's Compensation 1,784.00 1,784.00 145.53 1,018.71 57.103 765.29 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 63.00 402.35 80.470 97.65 135-50070-030-000 Employee Relations 4,960.00 4,960.00 12.00 2,583.46 52.086 2,376.54 Subtotal: 719,486.00 720,513.00 52,979.43 301,250.61 41.811 419,262.39 135-55030-030-000 Software & Support 67,791.00 77,791.00 9,157.26 65,920.45 84.740 11,870.55 135-55070-030-000 Independent Labor 12,000.00 4,000.00 932.50 23.313 3,067.50 135-55080-030-000 Maintenance & Repairs 7,000.00 2,000.00 275.00 13.750 1,725.00 135-55085-030-000 Generator Maint. and Repair 10,000.00 10,000.00 485.00 4.850 9,515.00 135-55100-030-000 Building Maint & Supplies 7,000.00 7,000.00 66.47 5,805.44 82.935 1,194.56 135-55120-030-000 Cleaning Services 10,429.00 8,000.00 633.06 3,775.36 47.192 4,224.64 135-55160-030-000 Professional Outside Services 63,325.00 60,000.00 57,332.00 95.553 2,668.00 135-55165-030-000 Collection Fees 200.00 200.00 200.00 135-55205-030-000 Utility Billing Contract 8,200.00 8,200.00 1,193.50 4,412.54 53.811 3,787.46 Subtotal: 185,945.00 177,191.00 11,050.29 138,938.29 78.412 38,252.71 135-60005-030-000 Telephone 17,532.00 17,532.00 265.75 7,154.97 40.811 10,377.03 135-60010-030-000 Communications/Mobiles 4,150.00 3,500.00 337.99 1,802.94 51.513 1,697.06 135-60020-030-000 Electricity/Gas 12,631.00 12,631.00 882.09 6.984 11,748.91 135-60025-030-000 Water 1,500.00 1,500.00 83.75- 650.95 43.397 849.05 135-60035-030-000 Postage 28,932.00 28,932.00 5,009.53 16,836.22 58.192 12,095.78 135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 3,811.95 28,767.41 51.777 26,792.59 135-60050-030-000 Bad Debt Expense 3,500.00 3,500.00 526.88 15.054 2,973.12 135-60055-030-000 Insurance 55,692.00 55,692.00 4,664.56 32,651.92 58.629 23,040.08 135-60066-030-000 Publications/Books/Subscripts 1,600.00 1,600.00 311.88 19.493 1,288.12 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 4,336.25 72.271 1,663.75 135-60075-030-000 Meetings 400.00 400.00 400.00 135-60079-030-000 Public Education 8,754.00 8,754.00 4,853.34 55.441 3,900.66 135-60080-030-000 Schools & Training 7,840.00 7,840.00 675.00 8.610 7,165.00 135-60100-030-000 Travel & per diem 5,400.00 7,500.00 200.39 6,892.47 91.900 607.53 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 Trophy Club Municipal Utility District No. 1 63 of 149 May 16, 2017 - Agenda Packet . glbase_tbam rgonzale Trophy Club MUD No.1 Page 11 18:31 05/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60115-030-000 Elections 7,500.00 7,500.00 542.95 542.95 7.239 6,957.05 135-60125-030-000 Advertising 7,500.00 7,500.00 150.00 1,100.09 14.668 6,399.91 135-60235-030-000 Security 1,350.00 1,350.00 1,350.00 135-60245-030-000 Miscellaneous Expenses 17,500.00 17,500.00 76.00 76.00 .434 17,424.00 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 1,040.00 41.600 1,460.00 Subtotal: 246,041.00 247,491.00 14,975.37 109,101.36 44.083 138,389.64 135-65010-030-000 Uniforms 1,855.00 855.00 142.36 16.650 712.64 135-65055-030-000 Hardware 9,444.00 9,444.00 25.00 2,264.88 23.982 7,179.12 135-65085-030-000 Office Supplies 9,000.00 9,000.00 825.15 3,792.80 42.142 5,207.20 135-65090-030-000 Printer Supplies & Maintenance 2,000.00 2,000.00 478.78 478.78 23.939 1,521.22 135-65095-030-000 Maintenance Supplies 5,000.00 4,000.00 139.46 1,594.32 39.858 2,405.68 135-65105-030-000 Printing 4,800.00 2,500.00 365.00 488.00 19.520 2,012.00 Subtotal: 32,099.00 27,799.00 1,833.39 8,761.14 31.516 19,037.86 135-69005-030-000 Capital Outlays 107,001.00 265,424.00 592.50 14,445.45 5.442 250,978.55 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 300.57 2,334.08 50.741 2,265.92 Subtotal: 111,601.00 270,024.00 893.07 16,779.53 6.214 253,244.47 Program number: 1,295,172.00 1,443,018.00 81,731.55 574,830.93 39.835 868,187.07 Department number: Administration 1,295,172.00 1,443,018.00 81,731.55 574,830.93 39.835 868,187.07 Trophy Club Municipal Utility District No. 1 64 of 149 May 16, 2017 - Agenda Packet . glbase_tbam rgonzale Trophy Club MUD No.1 Page 12 18:31 05/10/17 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 150,000.00 150,000.00 2,160.00 38,127.01 25.418 111,872.99 135-55055-039-000 Auditing 23,860.00 23,860.00 18,808.92 78.830 5,051.08 135-55060-039-000 Appraisal 11,115.00 11,115.00 6,621.58 59.573 4,493.42 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,561.76 67.415 1,238.24 Subtotal: 188,775.00 188,775.00 2,160.00 66,119.27 35.025 122,655.73 Program number: 188,775.00 188,775.00 2,160.00 66,119.27 35.025 122,655.73 Department number: Non Departmental 188,775.00 188,775.00 2,160.00 66,119.27 35.025 122,655.73 Expenditures Subtotal ----------- 9,531,624.00 9,840,488.00 505,985.79 3,996,772.72 40.616 5,843,715.28 Fund number: 135 MUD 1 General Fund 13,456.00- 243,695.42- 192,216.26- 192,216.26 Trophy Club Municipal Utility District No. 1 65 of 149 May 16, 2017 - Agenda Packet . glbase_tbam rgonzale Trophy Club MUD No.1 Page 13 18:31 05/10/17 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer-General Fund 75,000.00- 75,000.00 137-49146-000-000 Intergov Transfer-Fire Dept 81,420.00- 81,420.00 Subtotal: 156,420.00- 156,420.00 Program number: 156,420.00- 156,420.00 Department number: 156,420.00- 156,420.00 Revenues Subtotal ----------- 156,420.00- 156,420.00 Fund number: 137 MUD 1 Consolidated GASB 156,420.00- 156,420.00 Trophy Club Municipal Utility District No. 1 66 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 5 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2017 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 1417 04/03/2017 Property Taxes (59,625.07) (6.81) (59,631.88) GL 1418 04/04/2017 Property Taxes (52.32) (59,684.20) GL 1419 04/05/2017 Property Taxes (2.49) (59,686.69) GL 1420 04/06/2017 Property Taxes (4.11) (59,690.80) GL 1422 04/07/2017 Property Taxes (61.63) (59,752.43) GL 1423 04/10/2017 Property Taxes 61.63 (59,690.80) GL 1424 04/11/2017 Property Taxes (126.12) (59,816.92) GL 1425 04/13/2017 Property Taxes (18.41) (59,835.33) GL 1427 04/18/2017 Property Taxes (8.40) (59,843.73) GL 1428 04/20/2017 Property Taxes (29.99) (59,873.72) GL 1429 04/21/2017 Property Taxes (52.77) (59,926.49) GL 1430 04/25/2017 Property Taxes (.29) (59,926.78) GL 1431 04/26/2017 Property Taxes (77.05) (60,003.83) GL 1432 04/28/2017 Property Taxes (12.93) (60,016.76) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (391.69) (60,016.76) ** (60,977.00) Budgeted (960.24) Remaining 98 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1418 04/04/2017 Property Taxes (162.94) (.02) (162.96) GL 1424 04/11/2017 Property Taxes (1.30) (164.26) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (1.32) (164.26) ** .00 Budgeted 164.26 Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 1417 04/03/2017 Property Taxes (139.59) (.39) (139.98) GL 1418 04/04/2017 Property Taxes (.77) (140.75) GL 1420 04/06/2017 Property Taxes (.29) (141.04) GL 1424 04/11/2017 Property Taxes (9.97) (151.01) GL 1425 04/13/2017 Property Taxes (2.03) (153.04) GL 1426 04/17/2017 Property Taxes .84 (152.20) GL 1428 04/20/2017 Property Taxes (3.30) (155.50) GL 1429 04/21/2017 Property Taxes (5.29) (160.79) GL 1430 04/25/2017 Property Taxes (.03) (160.82) GL 1431 04/26/2017 Property Taxes (3.52) (164.34) GL 1432 04/28/2017 Property Taxes (1.42) (165.76) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (26.17) (165.76) ** (650.00) Budgeted (484.24) Remaining 26 % Used Trophy Club Municipal Utility District No. 1 67 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 6 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2017 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 ** (148,291.00) Budgeted (148,291.00) Remaining 0 % Used Account: 135-47000-000-000 Water 1386 04/28/2017 04/28/2017 UB Billing UB20170428-20170428 User: (2,222,142.52) (399,981.59) (2,622,124.11) UB _______________ Account: 135-47000-000-000 Water Totals: (399,981.59) (2,622,124.11) ** (6,436,734.00) Budgeted (3,814,609.89) Remaining 41 % Used Account: 135-47005-000-000 Sewer 1386 04/28/2017 04/28/2017 UB Billing UB20170428-20170428 User: (1,044,935.90) (331,916.95) (1,376,852.85) UB _______________ Account: 135-47005-000-000 Sewer Totals: (331,916.95) (1,376,852.85) ** (2,629,524.00) Budgeted (1,252,671.15) Remaining 52 % Used Account: 135-47025-000-000 Penalties 1389 04/11/2017 04/11/2017 UB Penalties UB20170411-20170411 User: (56,728.95) 470.98 (56,257.97) UB 1353 04/21/2017 04/21/2017 UB Penalties UB20170421-20170421 User: (10,105.81) (66,363.78) UB 1390 04/21/2017 04/21/2017 UB Penalties UB20170421-20170421 User: 23.30 (66,340.48) UB 1391 04/26/2017 04/26/2017 UB Penalties UB20170426-20170426 User: 96.40 (66,244.08) UB 1392 04/27/2017 04/27/2017 UB Penalties UB20170427-20170427 User: 61.93 (66,182.15) UB _______________ Account: 135-47025-000-000 Penalties Totals: (9,453.20) (66,182.15) ** (119,260.00) Budgeted (53,077.85) Remaining 55 % Used Account: 135-47030-000-000 Service Charges 1239 04/05/2017 04/05/2017 UB Disconnect Fees UB20170405-20170405 User: (6,875.00) (1,525.00) (8,400.00) UB 1328 04/11/2017 04/11/2017 UB NSF Fee UB20170411-20170411 User: (25.00) (8,425.00) UB 1355 04/20/2017 04/20/2017 NSF Check Fee UB20170420-20170420 User: (25.00) (8,450.00) UB 1365 04/20/2017 04/20/2017 UB NSF Fees UB20170420-20170420 User: (50.00) (8,500.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,625.00) (8,500.00) ** (11,400.00) Budgeted (2,900.00) Remaining 75 % Used Account: 135-47035-000-000 Plumbing Inspections Trophy Club Municipal Utility District No. 1 68 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 7 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) (950.00) .00 (950.00) _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: .00 (950.00) ** (2,000.00) Budgeted (1,050.00) Remaining 48 % Used Account: 135-47045-000-000 Sewer Inspections (1,950.00) .00 (1,950.00) _______________ Account: 135-47045-000-000 Sewer Inspections Totals: .00 (1,950.00) ** (5,500.00) Budgeted (3,550.00) Remaining 35 % Used Account: 135-47070-000-000 TCCC Effluent Charges 1386 04/28/2017 04/28/2017 UB Billing UB20170428-20170428 User: (16,500.00) (752.25) (17,252.25) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (752.25) (17,252.25) ** (61,188.00) Budgeted (43,935.75) Remaining 28 % Used Account: 135-49010-000-000 Interest Income 1440 04/30/2017 Bank Interest April 2017 (7,246.68) (1,259.38) (8,506.06) GL 1440 04/30/2017 Bank Interest April 2017 (136.75) (8,642.81) GL 1440 04/30/2017 Bank Interest April 2017 (175.36) (8,818.17) GL 1440 04/30/2017 Bank Interest April 2017 (111.67) (8,929.84) GL 1475 04/30/2017 Recode Prosperity Savings int 111.67 (8,818.17) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (1,571.49) (8,818.17) ** (8,001.00) Budgeted 817.17 Remaining 110 % Used Account: 135-49016-000-000 Cell Tower Revenue 1447 04/17/2017 AT&T Cell Tower Revenue (5,463.18) (910.53) (6,373.71) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (6,373.71) ** (10,926.00) Budgeted (4,552.29) Remaining 58 % Used Account: 135-49018-000-000 Building Rent Income 1469 04/30/2017 Town billed Inv 1562-66 AR 20170430-20170430 User: (2,916.65) (583.33) (3,499.98) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (3,499.98) ** (7,000.00) Budgeted (3,500.02) Remaining 50 % Used Trophy Club Municipal Utility District No. 1 69 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 8 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-49026-000-000 Proceeds from Sale of Assets .00 .00 _______________ Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: .00 .00 ** (2,000.00) Budgeted (2,000.00) Remaining 0 % Used Account: 135-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (295,408.00) Budgeted (295,408.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 1345 04/18/2017 04/18/2017 UB Permits Hogans Glen HOA (7,756.00) (343.00) (8,099.00) 499A Ashville Lane-Irrig meter CR 1345 04/18/2017 04/18/2017 UB Permits Hogans Glen HOA (343.00) (8,442.00) 500A Ashville Lane-Irrig meter CR 1361 04/24/2017 04/24/2017 UB Permits 59 Meadowbrook Lane (343.00) (8,785.00) Drees Homes CR 1361 04/24/2017 04/24/2017 UB Permits 14 Katie Lane (887.00) (9,672.00) Drees Homes CR 1361 04/24/2017 04/24/2017 UB Permits 1 Sadie Court (343.00) (10,015.00) Drees Homes CR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (2,259.00) (10,015.00) ** (21,609.00) Budgeted (11,594.00) Remaining 46 % Used Account: 135-49900-000-000 Miscellaneous Income 1386 04/28/2017 04/28/2017 UB Billing UB20170428-20170428 User: (5,885.29) (206.69) (6,091.98) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (206.69) (6,091.98) ** (20,000.00) Budgeted (13,908.02) Remaining 30 % Used Account: 135-49901-000-000 Records Management Revenue 1448 04/17/2017 ORR-Stoner (30.00) (2.00) (32.00) GL _______________ Account: 135-49901-000-000 Records Management Revenue Totals: (2.00) (32.00) ** (20.00) Budgeted 12.00 Remaining 160 % Used Department Totals: ----------------------------------- (4,188,988.98) ** (749,681.21) Monthly Total (9,840,488.00) Budgeted (5,651,499.02) Remaining 43 % Used Trophy Club Municipal Utility District No. 1 70 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 9 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2017 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 1240 04/07/2017 MUD P/R 04.07.17 Salaries & Wages 108,216.88 9,179.60 117,396.48 PR 1336 04/21/2017 MUD P/R 04.21.17 Salaries & Wages 8,943.84 126,340.32 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 18,123.44 126,340.32 ** 271,143.00 Budgeted 144,802.68 Remaining 47 % Used Account: 135-50010-010-000 Overtime 1240 04/07/2017 MUD P/R 04.07.17 Overtime 5,669.73 1,471.78 7,141.51 PR 1336 04/21/2017 MUD P/R 04.21.17 Overtime 261.81 7,403.32 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,733.59 7,403.32 ** 19,500.00 Budgeted 12,096.68 Remaining 38 % Used Account: 135-50016-010-000 Longevity 3,270.00 .00 3,270.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 3,270.00 ** 3,270.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 1336 04/21/2017 MUD P/R 04.21.17 Certification 1,450.00 250.00 1,700.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 250.00 1,700.00 ** 4,800.00 Budgeted 3,100.00 Remaining 35 % Used Account: 135-50020-010-000 Retirement 1240 04/07/2017 MUD P/R 04.07.17 Retirement 10,650.45 985.25 11,635.70 PR 1336 04/21/2017 MUD P/R 04.21.17 Retirement 874.65 12,510.35 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,859.90 12,510.35 ** 27,151.00 Budgeted 14,640.65 Remaining 46 % Used Account: 135-50026-010-000 Medical Insurance 1240 04/07/2017 MUD P/R 04.07.17 Medical Insurance 16,249.48 1,461.01 17,710.49 PR 1336 04/21/2017 MUD P/R 04.21.17 Medical Insurance 1,461.02 19,171.51 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,922.03 19,171.51 ** 55,914.00 Budgeted 36,742.49 Remaining 34 % Used Trophy Club Municipal Utility District No. 1 71 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 10 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-010-000 Dental Insurance 1240 04/07/2017 MUD P/R 04.07.17 Dental Insurance 1,500.71 149.65 1,650.36 PR 1336 04/21/2017 MUD P/R 04.21.17 Dental Insurance 149.62 1,799.98 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 299.27 1,799.98 ** 4,159.00 Budgeted 2,359.02 Remaining 43 % Used Account: 135-50028-010-000 Vision Insurance 1240 04/07/2017 MUD P/R 04.07.17 Vision Insurance 296.45 26.90 323.35 PR 1336 04/21/2017 MUD P/R 04.21.17 Vision Insurance 26.86 350.21 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 53.76 350.21 ** 910.00 Budgeted 559.79 Remaining 38 % Used Account: 135-50029-010-000 Life Insurance & Other 1249 04/06/2017 April A/P April Dental, Vision and other 1,329.96 220.30 1,550.26 METLIFE GROUP BENEFITS 3042 AP 1464 04/30/2017 April A/P Café 125 Admin 9.71 1,559.97 BenefitMall AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 230.01 1,559.97 ** 2,803.00 Budgeted 1,243.03 Remaining 56 % Used Account: 135-50030-010-000 Social Security Taxes 1240 04/07/2017 MUD P/R 04.07.17 Social Security Taxes 7,162.04 637.46 7,799.50 PR 1336 04/21/2017 MUD P/R 04.21.17 Social Security Taxes 569.71 8,369.21 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,207.17 8,369.21 ** 19,021.00 Budgeted 10,651.79 Remaining 44 % Used Account: 135-50035-010-000 Medicare Taxes 1240 04/07/2017 MUD P/R 04.07.17 Medicare Taxes 1,674.99 149.10 1,824.09 PR 1336 04/21/2017 MUD P/R 04.21.17 Medicare Taxes 133.24 1,957.33 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 282.34 1,957.33 ** 4,448.00 Budgeted 2,490.67 Remaining 44 % Used Account: 135-50040-010-000 Unemployment Taxes 1240 04/07/2017 MUD P/R 04.07.17 Unemployment Taxes 43.67 1.33 45.00 PR Trophy Club Municipal Utility District No. 1 72 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 11 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 1.33 45.00 ** 1,026.00 Budgeted 981.00 Remaining 4 % Used Account: 135-50045-010-000 Workman's Compensation 466 04/01/2017 Insurance/Wrk Comp Exp Apr 6,444.96 1,074.16 7,519.12 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 1,074.16 7,519.12 ** 13,152.00 Budgeted 5,632.88 Remaining 57 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 1,300.00 Budgeted 1,300.00 Remaining 0 % Used Account: 135-50070-010-000 Employee Relations 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 WHATABURGER 754 Q26 27.89 27.89 WHATABURGER 754 Q26 PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 WHOLEFDS CLV #10523 96.03 123.92 WHOLEFDS CLV #10523 PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 RANDALLS STORE00017897 63.17 187.09 RANDALLS STORE00017897 PC _______________ Account: 135-50070-010-000 Employee Relations Totals: 187.09 187.09 ** 300.00 Budgeted 112.91 Remaining 62 % Used Account: 135-55005-010-000 Engineering 1249 04/06/2017 April A/P 16" WL to PD30 19,539.18 16,685.25 36,224.43 Halff Associates, INC 3024 AP _______________ Account: 135-55005-010-000 Engineering Totals: 16,685.25 36,224.43 ** 60,000.00 Budgeted 23,775.57 Remaining 60 % Used Account: 135-55080-010-000 Maintenance & Repairs 1249 04/06/2017 April A/P Repair to well #1 43,819.18 1,716.32 45,535.50 DHS AUTOMATION, INC 3018 AP 1249 04/06/2017 April A/P Tank refill 21.50 45,557.00 ALLIED WELDING SUPPLY, INC 3010 AP 1249 04/06/2017 April A/P Parts 3,501.81 49,058.81 HD SUPPLY WATERWORKS, LTD. 3025 AP 1249 04/06/2017 April A/P Meter gaskets 45.08 49,103.89 HD SUPPLY WATERWORKS, LTD. 3025 AP 1339 04/19/2017 April A/P Bolts 126.50 49,230.39 HD SUPPLY WATERWORKS, LTD. 3066 AP 1339 04/19/2017 April A/P Cones, poly 221.60 49,451.99 HD SUPPLY WATERWORKS, LTD. 3066 AP 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 THE HOME DEPOT #6581 15.65 49,467.64 THE HOME DEPOT #6581 PC Trophy Club Municipal Utility District No. 1 73 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 12 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 THE HOME DEPOT #6581 43,819.18 32.21 49,499.85 THE HOME DEPOT #6581 PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 THE HOME DEPOT #6581 24.11 49,523.96 THE HOME DEPOT #6581 PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 THE HOME DEPOT #6581 29.07 49,553.03 THE HOME DEPOT #6581 PC 1398 04/28/2017 April A/P Sampling valves 196.38 49,749.41 KORALEEN ENTERPRISES 3092 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 5,930.23 49,749.41 ** 128,500.00 Budgeted 78,750.59 Remaining 39 % 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 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 ROANOKE AUTO SUPPLY LT 720.26 17.94 738.20 ROANOKE AUTO SUPPLY LT PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 GIERISCH CARE 0050292 84.95 823.15 GIERISCH CARE 0050292 PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 102.89 823.15 ** 8,000.00 Budgeted 7,176.85 Remaining 10 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader .00 .00 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-55135-010-000 Lab Analysis 1339 04/19/2017 April A/P water samples 1,828.10 275.00 2,103.10 TARRANT CTY PUBLIC HEALTH LAB 3074 AP 1464 04/30/2017 April A/P TCEQ Testing 207.70 2,310.80 LOWER COLORADO RIVER AUTHORITY AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 482.70 2,310.80 ** 5,500.00 Budgeted 3,189.20 Remaining 42 % Used Account: 135-60010-010-000 Communications/Mobiles 1339 04/19/2017 April A/P Cell phones 1,772.84 346.75 2,119.59 VERIZON WIRELESS 3080 AP 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 HNS*HUGHESNET.COM (239.92) 1,879.67 HNS*HUGHESNET.COM PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 HNS*HUGHESNET.COM (239.92) 1,639.75 HNS*HUGHESNET.COM PC Trophy Club Municipal Utility District No. 1 74 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 13 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 HNS*HUGHESNET.COM 1,772.84 239.92 1,879.67 HNS*HUGHESNET.COM PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 HNS*HUGHESNET.COM 239.92 2,119.59 HNS*HUGHESNET.COM PC _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 346.75 2,119.59 ** 5,400.00 Budgeted 3,280.41 Remaining 39 % Used Account: 135-60020-010-000 Electricity 1398 04/28/2017 April A/P Electricity 3/9-4/10 62,810.25 12,309.83 75,120.08 HUDSON ENERGY SERVICES, LLC 3090 AP 1398 04/28/2017 April A/P Electricity 3/9-4/10 1,656.87 76,776.95 HUDSON ENERGY SERVICES, LLC 3090 AP 1398 04/28/2017 April A/P Electricity 1/9-4/5 (3 mths) 325.56 77,102.51 HUDSON ENERGY SERVICES, LLC 3090 AP _______________ Account: 135-60020-010-000 Electricity Totals: 14,292.26 77,102.51 ** 172,737.00 Budgeted 95,634.49 Remaining 45 % Used Account: 135-60066-010-000 Publications/Books/Subscripts 1339 04/19/2017 April A/P 767.00 767.00 AMERICAN WATER WORKS ASSOC 3058 AP _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: 767.00 767.00 ** 750.00 Budgeted (17.00) Remaining 102 % 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 265.00 .00 265.00 _______________ Account: 135-60080-010-000 Schools & Training Totals: .00 265.00 ** 4,222.00 Budgeted 3,957.00 Remaining 6 % Used Account: 135-60090-010-000 Safety Program .00 .00 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Trophy Club Municipal Utility District No. 1 75 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 14 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60100-010-000 Travel & per diem 124.46 .00 124.46 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 124.46 ** 1,500.00 Budgeted 1,375.54 Remaining 8 % Used Account: 135-60105-010-000 Rent/Lease Equipment 1464 04/30/2017 April A/P Well water charge 3,876.50 3,876.50 North Texas Groundwater AP 1474 04/30/2017 Recode N TX Groundwater (3,876.50) .00 GL _______________ 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 1474 04/30/2017 Recode N TX Groundwater 18,063.95 3,876.50 21,940.45 GL _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 3,876.50 21,940.45 ** 50,176.00 Budgeted 28,235.55 Remaining 44 % Used Account: 135-60150-010-000 Wholesale Water 1401 04/28/2017 April A/P Water-March 699,524.87 159,459.08 858,983.95 CITY OF FORT WORTH 3084 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 159,459.08 858,983.95 ** 2,998,802.00 Budgeted 2,139,818.05 Remaining 29 % Used Account: 135-60245-010-000 Miscellaneous Expenses 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 TLF CRANSTONS FLOWERS 102.70 102.70 TLF CRANSTONS FLOWERS PC _______________ Account: 135-60245-010-000 Miscellaneous Expenses Totals: 102.70 102.70 ** 200.00 Budgeted 97.30 Remaining 51 % Used Account: 135-60280-010-000 Property Maintenance 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 SC TRACKING SOLUTIONS 966.00 10.95 976.95 SC TRACKING SOLUTIONS PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 SC TRACKING SOLUTIONS 43.80 1,020.75 SC TRACKING SOLUTIONS PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 THE HOME DEPOT #6581 323.85 1,344.60 THE HOME DEPOT #6581 PC 1398 04/28/2017 April A/P April mowing 1,500.00 2,844.60 WATTS ELLISON LLC 3097 AP 1471 04/28/2017 April A/P march g 750.00 3,594.60 WATTS ELLISON LLC AP 1476 04/30/2017 Recode Mowing (3,000.00) 594.60 GL Trophy Club Municipal Utility District No. 1 76 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 15 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60280-010-000 Property Maintenance Totals: (371.40) 594.60 ** 5,000.00 Budgeted 4,405.40 Remaining 12 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance 1476 04/30/2017 Recode Mowing 3,000.00 3,000.00 GL _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: 3,000.00 3,000.00 ** 14,750.00 Budgeted 11,750.00 Remaining 20 % Used Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S 1374 04/28/2017 Texpool Transfers 131,357.25 21,892.88 153,250.13 GL _______________ Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S Totals: 21,892.88 153,250.13 ** 297,011.00 Budgeted 143,760.87 Remaining 52 % Used Account: 135-60333-010-000 Interfund Transfer Out-Reserve 1374 04/28/2017 Texpool Transfers 86,166.00 14,361.00 100,527.00 GL _______________ Account: 135-60333-010-000 Interfund Transfer Out-Reserve Totals: 14,361.00 100,527.00 ** 64,920.00 Budgeted (35,607.00) Remaining 155 % Used Account: 135-60334-010-000 Interfund Transfer Out .00 .00 _______________ Account: 135-60334-010-000 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-65005-010-000 Fuel & Lube 1249 04/06/2017 April A/P Fuel 3,400.14 674.08 4,074.22 US Bank Voyager Fleet Systems 3055 AP 1401 04/28/2017 April A/P Gas 832.95 4,907.17 US Bank Voyager Fleet Systems 3096 AP Trophy Club Municipal Utility District No. 1 77 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 16 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 1,507.03 4,907.17 ** 24,828.00 Budgeted 19,920.83 Remaining 20 % Used Account: 135-65010-010-000 Uniforms 1,329.48 .00 1,329.48 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 1,329.48 ** 4,608.00 Budgeted 3,278.52 Remaining 29 % Used Account: 135-65030-010-000 Chemicals 1339 04/19/2017 April A/P LAS 7,373.33 434.64 7,807.97 Valley Solvent Company, INC 3079 AP 1398 04/28/2017 April A/P Chlorine 423.76 8,231.73 DPC INDUSTRIES, INC 3085 AP 1464 04/30/2017 April A/P chemicals 418.81 8,650.54 HACH COMPANY AP 1464 04/30/2017 April A/P chemicals 245.80 8,896.34 HACH COMPANY AP _______________ Account: 135-65030-010-000 Chemicals Totals: 1,523.01 8,896.34 ** 20,000.00 Budgeted 11,103.66 Remaining 44 % Used Account: 135-65035-010-000 Small Tools 221.62 .00 221.62 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 221.62 ** 1,200.00 Budgeted 978.38 Remaining 18 % Used Account: 135-65040-010-000 Safety Equipment .00 .00 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-65050-010-000 Meter Expense 1398 04/28/2017 April A/P Fireline meter for new town ha 11,708.26 5,361.62 17,069.88 ATLAS ENTERPRISES, INC 3083 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 5,361.62 17,069.88 ** 31,500.00 Budgeted 14,430.12 Remaining 54 % Used Account: 135-65053-010-000 Meter Change Out Program Trophy Club Municipal Utility District No. 1 78 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 17 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 48,264.00 .00 48,264.00 _______________ Account: 135-65053-010-000 Meter Change Out Program Totals: .00 48,264.00 ** 81,500.00 Budgeted 33,236.00 Remaining 59 % Used Account: 135-69005-010-000 Capital Outlays 1249 04/06/2017 April A/P 2.42 Bond Waterline 288,470.69 90.00 288,560.69 LanguageUSA, Inc 3033 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 90.00 288,560.69 ** 690,422.00 Budgeted 401,861.31 Remaining 42 % 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 126,957.75 .00 126,957.75 _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 126,957.75 ** 126,958.00 Budgeted .25 Remaining 100 % Used Trophy Club Municipal Utility District No. 1 79 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 18 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 4/2017 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 1339 04/19/2017 April A/P Water samples 607.70 80.00 687.70 TARRANT CTY PUBLIC HEALTH LAB 3074 AP 1471 04/28/2017 April A/P TCEQ sampling-PID 207.70 895.40 LOWER COLORADO RIVER AUTHORITY AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 287.70 895.40 ** 5,000.00 Budgeted 4,104.60 Remaining 18 % Used Account: 135-60135-010-001 TCEQ Fees & Permits for PID .00 .00 _______________ Account: 135-60135-010-001 TCEQ Fees & Permits for PID Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Department 10 Totals: ----------------------------------- 2,072,170.92 ** 277,921.29 Monthly Total 5,524,781.00 Budgeted 3,452,610.08 Remaining 38 % Used Trophy Club Municipal Utility District No. 1 80 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 19 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2017 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 1240 04/07/2017 MUD P/R 04.07.17 Salaries & Wages 177,420.53 14,986.41 192,406.94 PR 1336 04/21/2017 MUD P/R 04.21.17 Salaries & Wages 15,040.40 207,447.34 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 30,026.81 207,447.34 ** 391,102.00 Budgeted 183,654.66 Remaining 53 % Used Account: 135-50010-020-000 Overtime 1240 04/07/2017 MUD P/R 04.07.17 Overtime 17,100.67 1,354.09 18,454.76 PR 1336 04/21/2017 MUD P/R 04.21.17 Overtime 1,072.18 19,526.94 PR _______________ Account: 135-50010-020-000 Overtime Totals: 2,426.27 19,526.94 ** 29,500.00 Budgeted 9,973.06 Remaining 66 % Used Account: 135-50016-020-000 Longevity 6,635.00 .00 6,635.00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 6,635.00 ** 6,635.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-020-000 Certification 1336 04/21/2017 MUD P/R 04.21.17 Certification 3,750.00 475.00 4,225.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 475.00 4,225.00 ** 7,800.00 Budgeted 3,575.00 Remaining 54 % Used Account: 135-50020-020-000 Retirement 1240 04/07/2017 MUD P/R 04.07.17 Retirement 18,403.47 1,511.49 19,914.96 PR 1336 04/21/2017 MUD P/R 04.21.17 Retirement 1,534.35 21,449.31 PR _______________ Account: 135-50020-020-000 Retirement Totals: 3,045.84 21,449.31 ** 39,584.00 Budgeted 18,134.69 Remaining 54 % Used Account: 135-50026-020-000 Medical Insurance 1240 04/07/2017 MUD P/R 04.07.17 Medical Insurance 26,874.31 2,355.10 29,229.41 PR 1336 04/21/2017 MUD P/R 04.21.17 Medical Insurance 2,355.10 31,584.51 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 4,710.20 31,584.51 ** 73,022.00 Budgeted 41,437.49 Remaining 43 % Used Trophy Club Municipal Utility District No. 1 81 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 20 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-020-000 Dental Insurance 1240 04/07/2017 MUD P/R 04.07.17 Dental Insurance 2,068.40 199.69 2,268.09 PR 1336 04/21/2017 MUD P/R 04.21.17 Dental Insurance 199.63 2,467.72 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 399.32 2,467.72 ** 4,592.00 Budgeted 2,124.28 Remaining 54 % Used Account: 135-50028-020-000 Vision Insurance 1240 04/07/2017 MUD P/R 04.07.17 Vision Insurance 448.26 42.19 490.45 PR 1336 04/21/2017 MUD P/R 04.21.17 Vision Insurance 42.14 532.59 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 84.33 532.59 ** 1,031.00 Budgeted 498.41 Remaining 52 % Used Account: 135-50029-020-000 Life Insurance & Other 1249 04/06/2017 April A/P April Dental, Vision and other 2,222.13 356.76 2,578.89 METLIFE GROUP BENEFITS 3042 AP 1464 04/30/2017 April A/P Café 125 Admin 27.13 2,606.02 BenefitMall AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 383.89 2,606.02 ** 4,485.00 Budgeted 1,878.98 Remaining 58 % Used Account: 135-50030-020-000 Social Security Taxes 1240 04/07/2017 MUD P/R 04.07.17 Social Security Taxes 11,904.21 955.76 12,859.97 PR 1336 04/21/2017 MUD P/R 04.21.17 Social Security Taxes 962.95 13,822.92 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,918.71 13,822.92 ** 27,886.00 Budgeted 14,063.08 Remaining 50 % Used Account: 135-50035-020-000 Medicare Taxes 1240 04/07/2017 MUD P/R 04.07.17 Medicare Taxes 2,784.04 223.52 3,007.56 PR 1336 04/21/2017 MUD P/R 04.21.17 Medicare Taxes 225.21 3,232.77 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 448.73 3,232.77 ** 6,522.00 Budgeted 3,289.23 Remaining 50 % Used Account: 135-50040-020-000 Unemployment Taxes 63.00 .00 63.00 Trophy Club Municipal Utility District No. 1 82 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 21 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 63.00 ** 1,197.00 Budgeted 1,134.00 Remaining 5 % Used Account: 135-50045-020-000 Workman's Compensation 466 04/01/2017 Insurance/Wrk Comp Exp Apr 5,560.50 926.75 6,487.25 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 926.75 6,487.25 ** 11,347.00 Budgeted 4,859.75 Remaining 57 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-50070-020-000 Employee Relations 325.22 .00 325.22 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 325.22 ** 650.00 Budgeted 324.78 Remaining 50 % Used Account: 135-55005-020-000 Engineering .00 .00 _______________ Account: 135-55005-020-000 Engineering Totals: .00 .00 ** 70,000.00 Budgeted 70,000.00 Remaining 0 % Used Account: 135-55070-020-000 Independent Labor 19,449.39 .00 19,449.39 _______________ Account: 135-55070-020-000 Independent Labor Totals: .00 19,449.39 ** 20,000.00 Budgeted 550.61 Remaining 97 % Used Account: 135-55080-020-000 Maintenance & Repairs 1339 04/19/2017 April A/P Skid roller 30,373.34 1,060.41 31,433.75 CLS SEWER EQUIPMENT CO., INC 3059 AP 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 THE HOME DEPOT #6581 3.97 31,437.72 THE HOME DEPOT #6581 PC Trophy Club Municipal Utility District No. 1 83 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 22 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 THE HOME DEPOT #6581 30,373.34 73.47 31,511.19 THE HOME DEPOT #6581 PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 RDO EQUIPMENT CO 468.37 31,979.56 RDO EQUIPMENT CO PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 SPAETH MACHINE SHOP IN 475.00 32,454.56 SPAETH MACHINE SHOP IN PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 GIH*GLOBALINDUSTRIALEQ 1,519.50 33,974.06 GIH*GLOBALINDUSTRIALEQ PC 1401 04/28/2017 April A/P concrete work-WWTP 1,500.00 35,474.06 El Cala Construction 3086 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 5,100.72 35,474.06 ** 79,700.00 Budgeted 44,225.94 Remaining 45 % Used Account: 135-55085-020-000 Generator Maint. and Repair .00 .00 _______________ Account: 135-55085-020-000 Generator Maint. and Repair Totals: .00 .00 ** 20,000.00 Budgeted 20,000.00 Remaining 0 % Used Account: 135-55090-020-000 Vehicle Maintenance 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 SALAD BOWL 10 5,395.39 47.76 5,443.15 SALAD BOWL 10 PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 TRACTOR SUPPLY COMPANY 84.95 5,528.10 TRACTOR SUPPLY COMPANY PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 MUSTANG ELITE CAR 202.97 5,731.07 MUSTANG ELITE CAR PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 BLAGG TIRE & SERVICE 1,238.48 6,969.55 BLAGG TIRE & SERVICE PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 MUSTANG ELITE CAR WASH 16.99 6,986.54 MUSTANG ELITE CAR WASH PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 MUSTANG ELITE CAR 70.99 7,057.53 MUSTANG ELITE CAR PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 1,662.14 7,057.53 ** 6,600.00 Budgeted (457.53) Remaining 107 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 23.94 .00 23.94 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 23.94 ** 500.00 Budgeted 476.06 Remaining 5 % Used Account: 135-55125-020-000 Dumpster Services 1339 04/19/2017 April A/P Sludge haul off 27,851.38 1,690.00 29,541.38 L.H. CHANEY MATERIALS, INC. 3069 AP 1339 04/19/2017 April A/P Sludge haul off 861.48 30,402.86 L.H. CHANEY MATERIALS, INC. 3069 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 2,551.48 30,402.86 ** 55,000.00 Budgeted 24,597.14 Remaining 55 % Used Trophy Club Municipal Utility District No. 1 84 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 23 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2017 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 1339 04/19/2017 April A/P Lab supplies 13,613.00 246.00 13,859.00 OXIDOR LABORATORIES LLC 3073 AP 1339 04/19/2017 April A/P lab supplies 176.00 14,035.00 OXIDOR LABORATORIES LLC 3073 AP 1339 04/19/2017 April A/P lab suppplies 246.00 14,281.00 OXIDOR LABORATORIES LLC 3073 AP 1339 04/19/2017 April A/P lab supplies 176.00 14,457.00 OXIDOR LABORATORIES LLC 3073 AP 1339 04/19/2017 April A/P lab supplies 246.00 14,703.00 OXIDOR LABORATORIES LLC 3073 AP 1339 04/19/2017 April A/P Lab supplies 176.00 14,879.00 OXIDOR LABORATORIES LLC 3073 AP 1471 04/28/2017 April A/P lab supplies 246.00 15,125.00 OXIDOR LABORATORIES LLC AP 1471 04/28/2017 April A/P lab supplies 176.00 15,301.00 OXIDOR LABORATORIES LLC AP 1471 04/28/2017 April A/P Lab supplies 246.00 15,547.00 OXIDOR LABORATORIES LLC AP 1471 04/28/2017 April A/P Lab supplies 176.00 15,723.00 OXIDOR LABORATORIES LLC AP 1471 04/28/2017 April A/P lab supplies 246.00 15,969.00 OXIDOR LABORATORIES LLC AP 1471 04/28/2017 April A/P labs upplies 176.00 16,145.00 OXIDOR LABORATORIES LLC AP 1471 04/28/2017 April A/P lab supplies 176.00 16,321.00 OXIDOR LABORATORIES LLC AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 2,708.00 16,321.00 ** 25,000.00 Budgeted 8,679.00 Remaining 65 % Used Account: 135-60010-020-000 Communications/Mobiles 1339 04/19/2017 April A/P Cell phones 2,433.05 411.68 2,844.73 VERIZON WIRELESS 3080 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 411.68 2,844.73 ** 5,400.00 Budgeted 2,555.27 Remaining 53 % Used Account: 135-60020-020-000 Electricity 1300 04/11/2017 April A/P Electricity 3/8-4/7/17 62,646.29 83.22 62,729.51 HUDSON ENERGY SERVICES, LLC 3026 AP 1300 04/11/2017 April A/P Electricity 3/8-4/7/17 36.12 62,765.63 HUDSON ENERGY SERVICES, LLC 3026 AP 1339 04/19/2017 April A/P Electricity 3/9-4/10 343.30 63,108.93 MP2 ENERGY TEXAS LLC 3071 AP 1339 04/19/2017 April A/P Electricity 3/8-4/7 36.12 63,145.05 HUDSON ENERGY SERVICES, LLC 3067 AP 1339 04/19/2017 April A/P Electricity 3/9-4/10 110.74 63,255.79 HUDSON ENERGY SERVICES, LLC 3067 AP 1339 04/19/2017 April A/P Electricity 3/9-4/13 4,151.75 67,407.54 ENGIE Resources LLC 3063 AP 1339 04/19/2017 April A/P Electricity 2/24-3/24-17 37.32 67,444.86 TRI COUNTY ELECTRIC 3078 AP 1339 04/19/2017 April A/P Electricity 2/24-3/24/17 314.63 67,759.49 TRI COUNTY ELECTRIC 3078 AP 1339 04/19/2017 April A/P Electricity 2/24-3/24/17 27.81 67,787.30 TRI COUNTY ELECTRIC 3078 AP 1398 04/28/2017 April A/P Electricity 3/9-4/10 533.05 68,320.35 HUDSON ENERGY SERVICES, LLC 3090 AP 1398 04/28/2017 April A/P Electricity 3/9-4/9 7,825.77 76,146.12 HUDSON ENERGY SERVICES, LLC 3090 AP 1471 04/28/2017 April A/P Electricity 3/24-425 200.50 76,346.62 TRI COUNTY ELECTRIC AP 1471 04/28/2017 April A/P Electricity 3/24-4/25 365.01 76,711.63 TRI COUNTY ELECTRIC AP 1471 04/28/2017 April A/P Electricity 3/24-4/25 27.98 76,739.61 TRI COUNTY ELECTRIC AP 1469 04/30/2017 Town billed Inv 1562-66 AR 20170430-20170430 User: (157.05) 76,582.56 AR Trophy Club Municipal Utility District No. 1 85 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 24 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60020-020-000 Electricity Totals: 13,936.27 76,582.56 ** 158,627.00 Budgeted 82,044.44 Remaining 48 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 143.85 .00 143.85 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 143.85 ** 400.00 Budgeted 256.15 Remaining 36 % Used Account: 135-60070-020-000 Dues & Memberships 267.00 .00 267.00 _______________ Account: 135-60070-020-000 Dues & Memberships Totals: .00 267.00 ** 267.00 Budgeted .00 Remaining 100 % Used Account: 135-60080-020-000 Schools & Training 2,307.81 .00 2,307.81 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 2,307.81 ** 4,195.00 Budgeted 1,887.19 Remaining 55 % Used Account: 135-60090-020-000 Safety Program 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 TRACTOR SUPPLY COMPANY 257.16 24.99 282.15 TRACTOR SUPPLY COMPANY PC _______________ Account: 135-60090-020-000 Safety Program Totals: 24.99 282.15 ** 550.00 Budgeted 267.85 Remaining 51 % Used Account: 135-60100-020-000 Travel & per diem 1339 04/19/2017 April A/P Tolls 2,130.21 39.61 2,169.82 Texas Tollways/TxTag 3075 AP 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 FORTWORTHCATERING COM 21.61 2,191.43 FORTWORTHCATERING COM PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 RAILHEAD SMOKEHOUSE 23.39 2,214.82 RAILHEAD SMOKEHOUSE PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 FORTWORTHCATERING COM 21.61 2,236.43 FORTWORTHCATERING COM PC 1398 04/28/2017 April A/P tolls to lab 9.07 2,245.50 NTTA 3095 AP _______________ Account: 135-60100-020-000 Travel & per diem Totals: 115.29 2,245.50 ** 2,400.00 Budgeted 154.50 Remaining 94 % Used Trophy Club Municipal Utility District No. 1 86 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 25 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60105-020-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 .00 ** 9,000.00 Budgeted 9,000.00 Remaining 0 % Used Account: 135-60125-020-000 Advertising 4,086.37 .00 4,086.37 _______________ Account: 135-60125-020-000 Advertising Totals: .00 4,086.37 ** .00 Budgeted (4,086.37) Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 14,565.97 .00 14,565.97 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 14,565.97 ** 17,150.00 Budgeted 2,584.03 Remaining 85 % Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** 450.00 Budgeted 450.00 Remaining 0 % Used Account: 135-60280-020-000 Property Maintenance 1398 04/28/2017 April A/P April mowing 590.00 1,180.00 1,770.00 WATTS ELLISON LLC 3097 AP 1471 04/28/2017 April A/P march g 590.00 2,360.00 WATTS ELLISON LLC AP 1477 04/30/2017 Recode Mowing (2,360.00) .00 GL _______________ Account: 135-60280-020-000 Property Maintenance Totals: (590.00) .00 ** 6,621.00 Budgeted 6,621.00 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 1477 04/30/2017 Recode Mowing 2,360.00 2,360.00 GL _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 2,360.00 2,360.00 ** 11,600.00 Budgeted 9,240.00 Remaining 20 % Used Trophy Club Municipal Utility District No. 1 87 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 26 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S 1374 04/28/2017 Texpool Transfers 65,722.92 10,953.82 76,676.74 GL _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 10,953.82 76,676.74 ** 120,492.00 Budgeted 43,815.26 Remaining 64 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S 1374 04/28/2017 Texpool Transfers 324,893.46 54,148.91 379,042.37 GL _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: 54,148.91 379,042.37 ** 595,638.00 Budgeted 216,595.63 Remaining 64 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 56,132.70 .00 56,132.70 _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: .00 56,132.70 ** 123,492.00 Budgeted 67,359.30 Remaining 45 % Used Account: 135-60334-020-000 Interfund Transfer Out .00 .00 _______________ Account: 135-60334-020-000 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 % Used Account: 135-65005-020-000 Fuel & Lube 1249 04/06/2017 April A/P Fuel 3,445.02 776.87 4,221.89 US Bank Voyager Fleet Systems 3055 AP 1401 04/28/2017 April A/P Gas 852.16 5,074.05 US Bank Voyager Fleet Systems 3096 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 1,629.03 5,074.05 ** 28,088.00 Budgeted 23,013.95 Remaining 18 % Used Account: 135-65010-020-000 Uniforms 3,753.87 .00 3,753.87 _______________ Account: 135-65010-020-000 Uniforms Totals: .00 3,753.87 ** 4,459.00 Budgeted 705.13 Remaining 84 % Used Account: 135-65030-020-000 Chemicals Trophy Club Municipal Utility District No. 1 88 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 27 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 14,942.29 .00 14,942.29 _______________ Account: 135-65030-020-000 Chemicals Totals: .00 14,942.29 ** 21,000.00 Budgeted 6,057.71 Remaining 71 % Used Account: 135-65035-020-000 Small Tools 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 THE HOME DEPOT #6581 1,100.18 181.94 1,282.12 THE HOME DEPOT #6581 PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 GREEN VALLEY COMPRESSO 85.70 1,367.82 GREEN VALLEY COMPRESSO PC _______________ Account: 135-65035-020-000 Small Tools Totals: 267.64 1,367.82 ** 2,000.00 Budgeted 632.18 Remaining 68 % Used Account: 135-65040-020-000 Safety Equipment 252.64 .00 252.64 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 252.64 ** 750.00 Budgeted 497.36 Remaining 34 % Used Account: 135-65045-020-000 Lab Supplies 1339 04/19/2017 April A/P lab supplies 7,789.25 2,019.15 9,808.40 IDEXX DISTRIBUTION, INC 3068 AP 1339 04/19/2017 April A/P Testing supplies 188.49 9,996.89 IDEXX DISTRIBUTION, INC 3068 AP 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 RANDALLS STORE00017897 5.56 10,002.45 RANDALLS STORE00017897 PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 HACH COMPANY 504.32 10,506.77 HACH COMPANY PC 1471 04/28/2017 April A/P gloves 162.00 10,668.77 LOU'S GLOVES INCORPORATED AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 2,879.52 10,668.77 ** 14,000.00 Budgeted 3,331.23 Remaining 76 % Used Account: 135-69005-020-000 Capital Outlays 196,357.40 .00 196,357.40 _______________ Account: 135-69005-020-000 Capital Outlays Totals: .00 196,357.40 ** 462,000.00 Budgeted 265,642.60 Remaining 43 % Used Department 20 Totals: ----------------------------------- 1,279,088.96 ** 143,005.34 Monthly Total 2,671,032.00 Budgeted 1,391,943.04 Remaining 48 % Used Trophy Club Municipal Utility District No. 1 89 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 28 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 4/2017 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 466 04/01/2017 Insurance/Wrk Comp Exp Apr 15.66 2.61 18.27 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.61 18.27 ** 32.00 Budgeted 13.73 Remaining 57 % 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 .00 .00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60075-026-000 Meetings .00 .00 _______________ Account: 135-60075-026-000 Meetings Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-60080-026-000 Schools & Training 1249 04/06/2017 April A/P AWBD Conference 1,560.00 355.00 1,915.00 AWBD 3011 AP 1249 04/06/2017 April A/P AWBD Conference 355.00 2,270.00 AWBD 3011 AP 1464 04/30/2017 April A/P AWBD conference 405.00 2,675.00 AWBD AP 1464 04/30/2017 April A/P AWBD cancellation-Wilson 50.00 2,725.00 AWBD AP _______________ Account: 135-60080-026-000 Schools & Training Totals: 1,165.00 2,725.00 ** 4,000.00 Budgeted 1,275.00 Remaining 68 % Used Account: 135-60100-026-000 Travel & per diem 1,819.37 .00 1,819.37 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 1,819.37 ** 5,000.00 Budgeted 3,180.63 Remaining 36 % Used Trophy Club Municipal Utility District No. 1 90 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 29 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 4/2017 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 .00 .00 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Department 26 Totals: ----------------------------------- 4,562.64 ** 1,167.61 Monthly Total 12,882.00 Budgeted 8,319.36 Remaining 35 % Used Trophy Club Municipal Utility District No. 1 91 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 30 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2017 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 1240 04/07/2017 MUD P/R 04.07.17 Salaries & Wages 183,998.85 19,529.83 203,528.68 PR 1336 04/21/2017 MUD P/R 04.21.17 Salaries & Wages 19,524.97 223,053.65 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 39,054.80 223,053.65 ** 519,883.00 Budgeted 296,829.35 Remaining 43 % Used Account: 135-50010-030-000 Overtime 1240 04/07/2017 MUD P/R 04.07.17 Overtime 1,778.63 976.92 2,755.55 PR 1336 04/21/2017 MUD P/R 04.21.17 Overtime 437.68 3,193.23 PR _______________ Account: 135-50010-030-000 Overtime Totals: 1,414.60 3,193.23 ** 2,500.00 Budgeted (693.23) Remaining 128 % Used Account: 135-50016-030-000 Longevity 3,417.50 .00 3,417.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 3,417.50 ** 3,417.00 Budgeted (.50) Remaining 100 % Used Account: 135-50020-030-000 Retirement 1240 04/07/2017 MUD P/R 04.07.17 Retirement 16,804.36 1,896.89 18,701.25 PR 1336 04/21/2017 MUD P/R 04.21.17 Retirement 1,846.52 20,547.77 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,743.41 20,547.77 ** 47,768.00 Budgeted 27,220.23 Remaining 43 % Used Account: 135-50026-030-000 Medical Insurance 1240 04/07/2017 MUD P/R 04.07.17 Medical Insurance 20,499.26 2,275.98 22,775.24 PR 1336 04/21/2017 MUD P/R 04.21.17 Medical Insurance 2,275.99 25,051.23 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,551.97 25,051.23 ** 84,289.00 Budgeted 59,237.77 Remaining 30 % Used Account: 135-50027-030-000 Dental Insurance 1240 04/07/2017 MUD P/R 04.07.17 Dental Insurance 1,752.97 208.44 1,961.41 PR 1336 04/21/2017 MUD P/R 04.21.17 Dental Insurance 208.37 2,169.78 PR Trophy Club Municipal Utility District No. 1 92 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 31 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2017 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: 416.81 2,169.78 ** 5,981.00 Budgeted 3,811.22 Remaining 36 % Used Account: 135-50028-030-000 Vision Insurance 1240 04/07/2017 MUD P/R 04.07.17 Vision Insurance 375.41 44.45 419.86 PR 1336 04/21/2017 MUD P/R 04.21.17 Vision Insurance 44.39 464.25 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 88.84 464.25 ** 1,312.00 Budgeted 847.75 Remaining 35 % Used Account: 135-50029-030-000 Life Insurance & Other 1249 04/06/2017 April A/P April Dental, Vision and other 1,895.37 492.04 2,387.41 METLIFE GROUP BENEFITS 3042 AP 1378 04/25/2017 April A/P Rounding adjustment (.02) 2,387.39 Legal Shield AP 1464 04/30/2017 April A/P Café 125 Admin 33.16 2,420.55 BenefitMall AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 525.18 2,420.55 ** 5,890.00 Budgeted 3,469.45 Remaining 41 % Used Account: 135-50030-030-000 Social Security Taxes 1240 04/07/2017 MUD P/R 04.07.17 Social Security Taxes 11,083.91 1,222.11 12,306.02 PR 1336 04/21/2017 MUD P/R 04.21.17 Social Security Taxes 1,175.46 13,481.48 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,397.57 13,481.48 ** 32,777.00 Budgeted 19,295.52 Remaining 41 % Used Account: 135-50035-030-000 Medicare Taxes 1240 04/07/2017 MUD P/R 04.07.17 Medicare Taxes 2,592.18 285.82 2,878.00 PR 1336 04/21/2017 MUD P/R 04.21.17 Medicare Taxes 274.92 3,152.92 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 560.74 3,152.92 ** 8,084.00 Budgeted 4,931.08 Remaining 39 % Used Account: 135-50040-030-000 Unemployment Taxes 1240 04/07/2017 MUD P/R 04.07.17 Unemployment Taxes 288.75 4.08 292.83 PR 1336 04/21/2017 MUD P/R 04.21.17 Unemployment Taxes .90 293.73 PR _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 4.98 293.73 ** 1,368.00 Budgeted 1,074.27 Remaining 21 % Used Trophy Club Municipal Utility District No. 1 93 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 32 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2017 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 466 04/01/2017 Insurance/Wrk Comp Exp Apr 873.18 145.53 1,018.71 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 145.53 1,018.71 ** 1,784.00 Budgeted 765.29 Remaining 57 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 1249 04/06/2017 April A/P Employee drug screen-Schlielig 339.35 63.00 402.35 CARENOW CORPORATE 3014 AP _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: 63.00 402.35 ** 500.00 Budgeted 97.65 Remaining 80 % Used Account: 135-50070-030-000 Employee Relations 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 RANDALLS STORE00017897 2,571.46 12.00 2,583.46 RANDALLS STORE00017897 PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 12.00 2,583.46 ** 4,960.00 Budgeted 2,376.54 Remaining 52 % Used Account: 135-55030-030-000 Software & Support 1249 04/06/2017 April A/P Software support 56,763.19 658.00 57,421.19 STW INC 3048 AP 1311 04/13/2017 April A/P Final bill/document software 4,494.94 61,916.13 MCCI 3041 AP 1339 04/19/2017 April A/P Remit machine maintenance cont 425.00 62,341.13 TECHNIQUE DATA SYSTEMS INC 3076 AP 1339 04/19/2017 April A/P Email licenses 168.00 62,509.13 M3 Networks 3070 AP 1339 04/19/2017 April A/P Internet 1,036.77 63,545.90 WHOLESALE CARRIER SERVICES INC 3081 AP 1339 04/19/2017 April A/P Time clock license fee 600.00 64,145.90 Data Management Inc. 3061 AP 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 ATT*BILL PAYMENT 135.88 64,281.78 ATT*BILL PAYMENT PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 ATT*BILL PAYMENT 101.18 64,382.96 ATT*BILL PAYMENT PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 ATT*BILL PAYMENT 117.50 64,500.46 ATT*BILL PAYMENT PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 ADOBE *IL CREATIVE CLD 19.99 64,520.45 ADOBE *IL CREATIVE CLD PC 1464 04/30/2017 April A/P SUpport 1,400.00 65,920.45 STW INC AP _______________ Account: 135-55030-030-000 Software & Support Totals: 9,157.26 65,920.45 ** 77,791.00 Budgeted 11,870.55 Remaining 85 % Used Account: 135-55070-030-000 Independent Labor 932.50 .00 932.50 _______________ Account: 135-55070-030-000 Independent Labor Totals: .00 932.50 ** 4,000.00 Budgeted 3,067.50 Remaining 23 % Used Trophy Club Municipal Utility District No. 1 94 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 33 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55080-030-000 Maintenance & Repairs 275.00 .00 275.00 _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: .00 275.00 ** 2,000.00 Budgeted 1,725.00 Remaining 14 % Used Account: 135-55085-030-000 Generator Maint. and Repair 485.00 .00 485.00 _______________ Account: 135-55085-030-000 Generator Maint. and Repair Totals: .00 485.00 ** 10,000.00 Budgeted 9,515.00 Remaining 5 % Used Account: 135-55100-030-000 Building Maint & Supplies 1339 04/19/2017 April A/P Rug service 5,738.97 66.47 5,805.44 G & K SERVICES 3065 AP 1398 04/28/2017 April A/P Rug service 66.47 5,871.91 G & K SERVICES 3089 AP 1469 04/30/2017 Town billed Inv 1562-66 AR 20170430-20170430 User: (66.47) 5,805.44 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 66.47 5,805.44 ** 7,000.00 Budgeted 1,194.56 Remaining 83 % Used Account: 135-55120-030-000 Cleaning Services 1398 04/28/2017 April A/P Cleaning services-March 3,142.30 869.06 4,011.36 MEMBER'S BUILDING MAINTENANCE 3094 AP 1469 04/30/2017 Town billed Inv 1562-66 AR 20170430-20170430 User: (236.00) 3,775.36 AR _______________ Account: 135-55120-030-000 Cleaning Services Totals: 633.06 3,775.36 ** 8,000.00 Budgeted 4,224.64 Remaining 47 % Used Account: 135-55160-030-000 Professional Outside Services 57,332.00 .00 57,332.00 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 57,332.00 ** 60,000.00 Budgeted 2,668.00 Remaining 96 % 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 Trophy Club Municipal Utility District No. 1 95 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 34 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55205-030-000 Utility Billing Contract 1339 04/19/2017 April A/P March Billing 3,219.04 599.30 3,818.34 DATAPROSE LLC 3062 AP 1464 04/30/2017 April A/P April Billing 594.20 4,412.54 DATAPROSE LLC AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 1,193.50 4,412.54 ** 8,200.00 Budgeted 3,787.46 Remaining 54 % Used Account: 135-60005-030-000 Telephone 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 RINGCENTRAL, INC 6,889.22 13.95 6,903.17 RINGCENTRAL, INC PC 1398 04/28/2017 April A/P answering service 241.80 7,144.97 KEYSTONE PARK SECRETARIAL 3091 AP 1454 04/28/2017 Recode JE 1449 10.00 7,154.97 GL _______________ Account: 135-60005-030-000 Telephone Totals: 265.75 7,154.97 ** 17,532.00 Budgeted 10,377.03 Remaining 41 % Used Account: 135-60010-030-000 Communications/Mobiles 1339 04/19/2017 April A/P Cell phones 1,464.95 37.99 1,502.94 VERIZON WIRELESS 3080 AP 1336 04/21/2017 MUD P/R 04.21.17 Communications/Mobiles 300.00 1,802.94 PR _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 337.99 1,802.94 ** 3,500.00 Budgeted 1,697.06 Remaining 52 % Used Account: 135-60020-030-000 Electricity/Gas 882.09 .00 882.09 _______________ Account: 135-60020-030-000 Electricity/Gas Totals: .00 882.09 ** 12,631.00 Budgeted 11,748.91 Remaining 7 % Used Account: 135-60025-030-000 Water 1469 04/30/2017 Town billed Inv 1562-66 AR 20170430-20170430 User: 734.70 (83.75) 650.95 AR _______________ Account: 135-60025-030-000 Water Totals: (83.75) 650.95 ** 1,500.00 Budgeted 849.05 Remaining 43 % Used Account: 135-60035-030-000 Postage 1249 04/06/2017 April A/P Overnight letter 11,826.69 24.12 11,850.81 FEDERAL EXPRESS CORP 3019 AP 1321 04/17/2017 April A/P Postage for mail outs 1,336.90 13,187.71 U.S. POSTAL SERVICE 3057 AP 1339 04/19/2017 April A/P March Billing 1,790.17 14,977.88 DATAPROSE LLC 3062 AP Trophy Club Municipal Utility District No. 1 96 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 35 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1398 04/28/2017 April A/P Postage machine rental3 11,826.69 93.00 15,070.88 FRANCOTYP-POSTALIA, INC. 3088 AP 1464 04/30/2017 April A/P April Billing 1,765.34 16,836.22 DATAPROSE LLC AP _______________ Account: 135-60035-030-000 Postage Totals: 5,009.53 16,836.22 ** 28,932.00 Budgeted 12,095.78 Remaining 58 % Used Account: 135-60040-030-000 Service Charges & Fees 1410 04/04/2017 Credit Card Fees/Pace 24,955.46 112.75 25,068.21 GL 1410 04/04/2017 Credit Card Fees/Pace 3,596.20 28,664.41 GL 1249 04/06/2017 April A/P Direct send fees 50.00 28,714.41 Fiserv Solutions, LLC 3020 AP 1241 04/07/2017 Child Support Fee 1.50 28,715.91 GL 1337 04/21/2017 Child Support Fee 1.50 28,717.41 GL 1398 04/28/2017 April A/P Direct send fees 50.00 28,767.41 Fiserv Solutions, LLC 3087 AP _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 3,811.95 28,767.41 ** 55,560.00 Budgeted 26,792.59 Remaining 52 % Used Account: 135-60050-030-000 Bad Debt Expense 526.88 .00 526.88 _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 526.88 ** 3,500.00 Budgeted 2,973.12 Remaining 15 % Used Account: 135-60055-030-000 Insurance 466 04/01/2017 Insurance/Wrk Comp Exp Apr 27,987.36 4,664.56 32,651.92 GL _______________ Account: 135-60055-030-000 Insurance Totals: 4,664.56 32,651.92 ** 55,692.00 Budgeted 23,040.08 Remaining 59 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 311.88 .00 311.88 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 311.88 ** 1,600.00 Budgeted 1,288.12 Remaining 19 % Used Account: 135-60070-030-000 Dues & Memberships 4,336.25 .00 4,336.25 Trophy Club Municipal Utility District No. 1 97 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 36 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2017 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 4,336.25 ** 6,000.00 Budgeted 1,663.75 Remaining 72 % Used Account: 135-60075-030-000 Meetings .00 .00 _______________ Account: 135-60075-030-000 Meetings Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60079-030-000 Public Education 4,853.34 .00 4,853.34 _______________ Account: 135-60079-030-000 Public Education Totals: .00 4,853.34 ** 8,754.00 Budgeted 3,900.66 Remaining 55 % Used Account: 135-60080-030-000 Schools & Training 675.00 .00 675.00 _______________ Account: 135-60080-030-000 Schools & Training Totals: .00 675.00 ** 7,840.00 Budgeted 7,165.00 Remaining 9 % Used Account: 135-60100-030-000 Travel & per diem 1240 04/07/2017 MUD P/R 04.07.17 Travel & per diem 6,692.08 156.54 6,848.62 PR 1336 04/21/2017 MUD P/R 04.21.17 Travel & per diem 43.85 6,892.47 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 200.39 6,892.47 ** 7,500.00 Budgeted 607.53 Remaining 92 % 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 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 TERIS - PHOENIX, LLC 542.95 542.95 TERIS - PHOENIX, LLC PC Trophy Club Municipal Utility District No. 1 98 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 37 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2017 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: 542.95 542.95 ** 7,500.00 Budgeted 6,957.05 Remaining 7 % Used Account: 135-60125-030-000 Advertising 1249 04/06/2017 April A/P Employment Ad 950.09 150.00 1,100.09 TX MUNICIPAL LEAGUE 3054 AP _______________ Account: 135-60125-030-000 Advertising Totals: 150.00 1,100.09 ** 7,500.00 Budgeted 6,399.91 Remaining 15 % Used Account: 135-60235-030-000 Security .00 .00 _______________ Account: 135-60235-030-000 Security Totals: .00 .00 ** 1,350.00 Budgeted 1,350.00 Remaining 0 % Used Account: 135-60245-030-000 Miscellaneous Expenses 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 VCN*DENTONRECCTR 76.00 76.00 VCN*DENTONRECCTR PC _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 76.00 76.00 ** 17,500.00 Budgeted 17,424.00 Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 1,040.00 .00 1,040.00 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 1,040.00 ** 2,500.00 Budgeted 1,460.00 Remaining 42 % Used Account: 135-65010-030-000 Uniforms 142.36 .00 142.36 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 142.36 ** 855.00 Budgeted 712.64 Remaining 17 % Used Account: 135-65055-030-000 Hardware 1249 04/06/2017 April A/P Batteries 2,239.88 25.00 2,264.88 M3 Networks 3037 AP Trophy Club Municipal Utility District No. 1 99 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 38 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65055-030-000 Hardware Totals: 25.00 2,264.88 ** 9,444.00 Budgeted 7,179.12 Remaining 24 % Used Account: 135-65085-030-000 Office Supplies 1249 04/06/2017 April A/P Office supplies 2,967.65 104.31 3,071.96 OFFICE DEPOT, INC 3043 AP 1339 04/19/2017 April A/P Office supplies 338.13 3,410.09 OFFICE DEPOT, INC 3072 AP 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 OFFICE DEPOT #406 36.94 3,447.03 OFFICE DEPOT #406 PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 AMAZON MKTPLACE PMTS 69.73 3,516.76 AMAZON MKTPLACE PMTS PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 SAMSCLUB.COM 88.89 3,605.65 SAMSCLUB.COM PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 STAPLES DIRECT 13.00 3,618.65 STAPLES DIRECT PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 SAMSCLUB.COM 15.92 3,634.57 SAMSCLUB.COM PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 AMAZON MKTPLACE PMTS 50.28 3,684.85 AMAZON MKTPLACE PMTS PC 1398 04/28/2017 April A/P Ink cartridge for postage mete 107.95 3,792.80 ASI BUSINESS SOLUTIONS LTD 3082 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 825.15 3,792.80 ** 9,000.00 Budgeted 5,207.20 Remaining 42 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 ZAPCO INC 87.31 87.31 ZAPCO INC PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 DESKTOP SUPPLIES.COM 94.70 182.01 DESKTOP SUPPLIES.COM PC 1436 04/26/2017 Pcard 03/28/17 - 04/26/17 SHI GOVERNMENT SOLUTIO 296.77 478.78 SHI GOVERNMENT SOLUTIO PC _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 478.78 478.78 ** 2,000.00 Budgeted 1,521.22 Remaining 24 % Used Account: 135-65095-030-000 Maintenance Supplies 1464 04/30/2017 April A/P Supplies-building 1,454.86 139.46 1,594.32 COSTCO WHOLESALE AP _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 139.46 1,594.32 ** 4,000.00 Budgeted 2,405.68 Remaining 40 % Used Account: 135-65105-030-000 Printing 1339 04/19/2017 April A/P March Billing 123.00 117.50 240.50 DATAPROSE LLC 3062 AP 1464 04/30/2017 April A/P April Billing 247.50 488.00 DATAPROSE LLC AP _______________ Account: 135-65105-030-000 Printing Totals: 365.00 488.00 ** 2,500.00 Budgeted 2,012.00 Remaining 20 % Used Trophy Club Municipal Utility District No. 1 100 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 39 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69005-030-000 Capital Outlays 1464 04/30/2017 April A/P Restroom remodel 13,852.95 592.50 14,445.45 CP&Y/WALLACE GROUP, INC. AP _______________ Account: 135-69005-030-000 Capital Outlays Totals: 592.50 14,445.45 ** 265,424.00 Budgeted 250,978.55 Remaining 5 % Used Account: 135-69170-030-000 Copier Lease Installments 1339 04/19/2017 April A/P Copier lease 2,033.51 165.00 2,198.51 EVERBANK COMMERCIAL FINANCE 3064 AP 1398 04/28/2017 April A/P Copies 135.57 2,334.08 KYOCERA DOCUMENT SOLUTIONS 3093 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 300.57 2,334.08 ** 4,600.00 Budgeted 2,265.92 Remaining 51 % Used Department 30 Totals: ----------------------------------- 574,830.93 ** 81,731.55 Monthly Total 1,443,018.00 Budgeted 868,187.07 Remaining 40 % Used Trophy Club Municipal Utility District No. 1 101 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 40 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 4/2017 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 1311 04/13/2017 April A/P March legal 35,967.01 2,160.00 38,127.01 McLean & Howard, L.L.P. 3039 AP _______________ Account: 135-55045-039-000 Legal Totals: 2,160.00 38,127.01 ** 150,000.00 Budgeted 111,872.99 Remaining 25 % Used Account: 135-55055-039-000 Auditing 18,808.92 .00 18,808.92 _______________ Account: 135-55055-039-000 Auditing Totals: .00 18,808.92 ** 23,860.00 Budgeted 5,051.08 Remaining 79 % Used Account: 135-55060-039-000 Appraisal 6,621.58 .00 6,621.58 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 6,621.58 ** 11,115.00 Budgeted 4,493.42 Remaining 60 % Used Account: 135-55065-039-000 Tax Admin Fees 2,561.76 .00 2,561.76 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,561.76 ** 3,800.00 Budgeted 1,238.24 Remaining 67 % Used Department 39 Totals: ----------------------------------- 66,119.27 ** 2,160.00 Monthly Total 188,775.00 Budgeted 122,655.73 Remaining 35 % Used Fund 135 Totals: ----------------------------------- (192,216.26) (243,695.42) Monthly Total .00 Budgeted 192,216.26 Remaining 0 % Used Trophy Club Municipal Utility District No. 1 102 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 41 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 4/2017 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 (75,000.00) .00 (75,000.00) _______________ Account: 137-49145-000-000 Intergov Transfer-General Fund Totals: .00 (75,000.00) ** .00 Budgeted 75,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: ----------------------------------- (156,420.00) ** .00 Monthly Total .00 Budgeted 156,420.00 Remaining 0 % Used Fund 137 Totals: ----------------------------------- (156,420.00) .00 Monthly Total .00 Budgeted 156,420.00 Remaining 0 % Used Trophy Club Municipal Utility District No. 1 103 of 149 May 16, 2017 - Agenda Packet TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET APRIL 2017 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 2,901,402 ACCOUNTS RECEIVABLE - TOTAL ASSETS 2,901,402 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 4,391,205 NET REVENUES / EXPENDITURES (1,489,803) TOTAL FUND BALANCE 2,901,402 TOTAL LIABILITIES AND FUND BALANCE 2,901,402 Trophy Club Municipal Utility District No. 1 104 of 149 May 16, 2017 - Agenda Packet . glbase_tbam rgonzale Trophy Club MUD No.1 Page 14 18:31 05/10/17 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 1,778.99- 11,159.09- 11,159.09 Subtotal: 1,778.99- 11,159.09- 11,159.09 Program number: 1,778.99- 11,159.09- 11,159.09 Department number: Revenues 1,778.99- 11,159.09- 11,159.09 Revenues Subtotal ----------- 1,778.99- 11,159.09- 11,159.09 Trophy Club Municipal Utility District No. 1 105 of 149 May 16, 2017 - Agenda Packet . glbase_tbam rgonzale Trophy Club MUD No.1 Page 15 18:31 05/10/17 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-69005-020-000 Capital Outlays 155,931.19 1,500,961.71 1,500,961.71- Subtotal: 155,931.19 1,500,961.71 1,500,961.71- Program number: 155,931.19 1,500,961.71 1,500,961.71- Department number: Wastewater 155,931.19 1,500,961.71 1,500,961.71- Expenditures Subtotal ----------- 155,931.19 1,500,961.71 1,500,961.71- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 154,152.20 1,489,802.62 1,489,802.62- Trophy Club Municipal Utility District No. 1 106 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 42 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 4/2017 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 1440 04/30/2017 Bank Interest April 2017 (9,380.10) (1,778.99) (11,159.09) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (1,778.99) (11,159.09) ** .00 Budgeted 11,159.09 Remaining 0 % Used Department Totals: ----------------------------------- (11,159.09) ** (1,778.99) Monthly Total .00 Budgeted 11,159.09 Remaining 0 % Used Trophy Club Municipal Utility District No. 1 107 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 43 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-69005-020-000 Capital Outlays 1311 04/13/2017 April A/P WWTP improvements App 18 1,345,030.52 105,426.99 1,450,457.51 WEBBER-CADAGUA PARTNERS 3056 AP 1339 04/19/2017 April A/P WWTP Improvements 50,504.20 1,500,961.71 CP&Y/WALLACE GROUP, INC. 3060 AP _______________ Account: 517-69005-020-000 Capital Outlays Totals: 155,931.19 1,500,961.71 ** .00 Budgeted (1,500,961.71) Remaining 0 % Used Department 20 Totals: ----------------------------------- 1,500,961.71 ** 155,931.19 Monthly Total .00 Budgeted (1,500,961.71) Remaining 0 % Used Fund 517 Totals: ----------------------------------- 1,489,802.62 154,152.20 Monthly Total .00 Budgeted (1,489,802.62) Remaining 0 % Used Trophy Club Municipal Utility District No. 1 108 of 149 May 16, 2017 - Agenda Packet TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION BALANCE SHEET APRIL 2017 518 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS - LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 691,249 TOTAL LIABILITIES 691,249 FUND BALANCE ASSIGNED FUND BALANCE 41,831 NET REVENUES / EXPENDITURES (733,080) TOTAL FUND BALANCE (691,249) TOTAL LIABILITIES AND FUND BALANCE - Trophy Club Municipal Utility District No. 1 109 of 149 May 16, 2017 - Agenda Packet . glbase_tbam rgonzale Trophy Club MUD No.1 Page 16 18:31 05/10/17 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-49010-000-000 Interest Income 590.72- 590.72 Subtotal: 590.72- 590.72 Program number: 590.72- 590.72 Department number: Revenues 590.72- 590.72 Revenues Subtotal ----------- 590.72- 590.72 Trophy Club Municipal Utility District No. 1 110 of 149 May 16, 2017 - Agenda Packet . glbase_tbam rgonzale Trophy Club MUD No.1 Page 17 18:31 05/10/17 Budget Summary with Amendment Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 518-69005-020-000 Capital Outlays 733,670.38 733,670.38- Subtotal: 733,670.38 733,670.38- Program number: 733,670.38 733,670.38- Department number: Wastewater 733,670.38 733,670.38- Expenditures Subtotal ----------- 733,670.38 733,670.38- Fund number: 518 2015 Revenue Bond Const Fund 733,079.66 733,079.66- Trophy Club Municipal Utility District No. 1 111 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 44 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: Revenues Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 518-49010-000-000 Interest Income (590.72) .00 (590.72) _______________ Account: 518-49010-000-000 Interest Income Totals: .00 (590.72) ** .00 Budgeted 590.72 Remaining 0 % Used Department Totals: ----------------------------------- (590.72) ** .00 Monthly Total .00 Budgeted 590.72 Remaining 0 % Used Trophy Club Municipal Utility District No. 1 112 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 45 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 518 2015 Revenue Bond Const Fund Department: 20 Wastewater Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 518-69005-020-000 Capital Outlays 733,670.38 .00 733,670.38 _______________ Account: 518-69005-020-000 Capital Outlays Totals: .00 733,670.38 ** .00 Budgeted (733,670.38) Remaining 0 % Used Department 20 Totals: ----------------------------------- 733,670.38 ** .00 Monthly Total .00 Budgeted (733,670.38) Remaining 0 % Used Fund 518 Totals: ----------------------------------- 733,079.66 .00 Monthly Total .00 Budgeted (733,079.66) Remaining 0 % Used Trophy Club Municipal Utility District No. 1 113 of 149 May 16, 2017 - Agenda Packet TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION SWIFT FUNDING BALANCE SHEET APRIL 2017 519 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS - LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 543 TOTAL LIABILITIES 543 FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES (543) TOTAL FUND BALANCE (543) TOTAL LIABILITIES AND FUND BALANCE - Trophy Club Municipal Utility District No. 1 114 of 149 May 16, 2017 - Agenda Packet . glbase_tbam rgonzale Trophy Club MUD No.1 Page 18 18:31 05/10/17 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const-SWIFT Department: 20 Wastewater Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 519-60245-020-000 Miscellaneous Expense 542.95 542.95- Subtotal: 542.95 542.95- Program number: 542.95 542.95- Department number: Wastewater 542.95 542.95- Expenditures Subtotal ----------- 542.95 542.95- Fund number: 519 2016 Rev Bond Const-SWIFT 542.95 542.95- Trophy Club Municipal Utility District No. 1 115 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 46 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const-SWIFT Department: 20 Wastewater Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 519-60245-020-000 Miscellaneous Expense 542.95 .00 542.95 _______________ Account: 519-60245-020-000 Miscellaneous Expense Totals: .00 542.95 ** .00 Budgeted (542.95) Remaining 0 % Used Department 20 Totals: ----------------------------------- 542.95 ** .00 Monthly Total .00 Budgeted (542.95) Remaining 0 % Used Fund 519 Totals: ----------------------------------- 542.95 .00 Monthly Total .00 Budgeted (542.95) Remaining 0 % Used Trophy Club Municipal Utility District No. 1 116 of 149 May 16, 2017 - Agenda Packet TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET APRIL 2017 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 252,593 ACCOUNTS RECEIVABLE - TOTAL ASSETS 252,593 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 195,762 NET REVENUES / EXPENDITURES 56,831 TOTAL FUND BALANCE 252,593 TOTAL LIABILITIES AND FUND BALANCE 252,593 Trophy Club Municipal Utility District No. 1 117 of 149 May 16, 2017 - Agenda Packet . glbase_tbam rgonzale Trophy Club MUD No.1 Page 19 18:31 05/10/17 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49010-000-000 Interest Income 300.00- 300.00- 147.75- 698.61- 232.870 398.61 528-49142-000-000 Interfund transfer in-Water 64,920.00- 64,920.00- 64,920.00- 528-49143-000-000 Interfund transfer in-WW 123,492.00- 123,492.00- 56,132.70- 45.455 67,359.30- Subtotal: 188,712.00- 188,712.00- 147.75- 56,831.31- 30.115 131,880.69- Program number: 188,712.00- 188,712.00- 147.75- 56,831.31- 30.115 131,880.69- Department number: 188,712.00- 188,712.00- 147.75- 56,831.31- 30.115 131,880.69- Revenues Subtotal ----------- 188,712.00- 188,712.00- 147.75- 56,831.31- 30.115 131,880.69- Fund number: 528 2015 Revenue Bond Reserve Fund 188,712.00- 188,712.00- 147.75- 56,831.31- 30.115 131,880.69- Trophy Club Municipal Utility District No. 1 118 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 47 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 4/2017 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 1440 04/30/2017 Bank Interest April 2017 (550.86) (147.75) (698.61) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (147.75) (698.61) ** (300.00) Budgeted 398.61 Remaining 233 % Used Account: 528-49142-000-000 Interfund transfer in-Water .00 .00 _______________ Account: 528-49142-000-000 Interfund transfer in-Water Totals: .00 .00 ** (64,920.00) Budgeted (64,920.00) Remaining 0 % Used Account: 528-49143-000-000 Interfund transfer in-WW (56,132.70) .00 (56,132.70) _______________ Account: 528-49143-000-000 Interfund transfer in-WW Totals: .00 (56,132.70) ** (123,492.00) Budgeted (67,359.30) Remaining 45 % Used Department Totals: ----------------------------------- (56,831.31) ** (147.75) Monthly Total (188,712.00) Budgeted (131,880.69) Remaining 30 % Used Fund 528 Totals: ----------------------------------- (56,831.31) (147.75) Monthly Total (188,712.00) Budgeted (131,880.69) Remaining 30 % Used Trophy Club Municipal Utility District No. 1 119 of 149 May 16, 2017 - Agenda Packet TROPHY CLUB MUD #1 - SWIFT REVENUE BOND RESERVE BALANCE SHEET APRIL 2017 529 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 100,670 ACCOUNTS RECEIVABLE - TOTAL ASSETS 100,670 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 100,670 TOTAL FUND BALANCE 100,670 TOTAL LIABILITIES AND FUND BALANCE 100,670 Trophy Club Municipal Utility District No. 1 120 of 149 May 16, 2017 - Agenda Packet . glbase_tbam rgonzale Trophy Club MUD No.1 Page 20 18:31 05/10/17 Budget Summary with Amendment Fund: 529 2016 Rev Bond Reserve-SWIFT Department: Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 529-49010-000-000 Interest Income 51.36- 142.52- 142.52 529-49142-000-000 Interfund transfer in-Water 14,361.00- 100,527.00- 100,527.00 Subtotal: 14,412.36- 100,669.52- 100,669.52 Program number: 14,412.36- 100,669.52- 100,669.52 Department number: 14,412.36- 100,669.52- 100,669.52 Revenues Subtotal ----------- 14,412.36- 100,669.52- 100,669.52 Fund number: 529 2016 Rev Bond Reserve-SWIFT 14,412.36- 100,669.52- 100,669.52 Trophy Club Municipal Utility District No. 1 121 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 48 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 529 2016 Rev Bond Reserve-SWIFT Department: Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 529-49010-000-000 Interest Income 1440 04/30/2017 Bank Interest April 2017 (91.16) (51.36) (142.52) GL _______________ Account: 529-49010-000-000 Interest Income Totals: (51.36) (142.52) ** .00 Budgeted 142.52 Remaining 0 % Used Account: 529-49142-000-000 Interfund transfer in-Water 1374 04/28/2017 Texpool Transfers (86,166.00) (14,361.00) (100,527.00) GL _______________ Account: 529-49142-000-000 Interfund transfer in-Water Totals: (14,361.00) (100,527.00) ** .00 Budgeted 100,527.00 Remaining 0 % Used Department Totals: ----------------------------------- (100,669.52) ** (14,412.36) Monthly Total .00 Budgeted 100,669.52 Remaining 0 % Used Fund 529 Totals: ----------------------------------- (100,669.52) (14,412.36) Monthly Total .00 Budgeted 100,669.52 Remaining 0 % Used Trophy Club Municipal Utility District No. 1 122 of 149 May 16, 2017 - Agenda Packet TROPHY CLUB MUD #1 - I&S BALANCE SHEET APRIL 2017 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 612,934 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 20,963 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 638,743 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 20,963 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 20,963 FUND BALANCE ASSIGNED FUND BALANCE 26,031 NET REVENUES / EXPENDITURES 591,749 TOTAL FUND BALANCE 617,780 TOTAL LIABILITIES AND FUND BALANCE 638,743 Trophy Club Municipal Utility District No. 1 123 of 149 May 16, 2017 - Agenda Packet . glbase_tbam rgonzale Trophy Club MUD No.1 Page 21 18:31 05/10/17 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 673,336.00- 673,336.00- 4,327.56- 663,062.52- 98.474 10,273.48- 533-40002-000-000 Property Taxes/Delinquent 3,501.00- 3,501.00- 3.80- 1,246.65- 35.608 2,254.35- 533-40015-000-000 Property Taxes/P & I 2,000.00- 2,000.00- 276.66- 1,277.23- 63.862 722.77- Subtotal: 678,837.00- 678,837.00- 4,608.02- 665,586.40- 98.048 13,250.60- 533-49010-000-000 Interest Income 140.00- 140.00- 352.57- 1,227.18- 876.557 1,087.18 533-49015-000-000 Lease/Rental Income 216,754.00- 216,754.00- 216,754.00- 533-49141-000-000 Interfund Trans In-PID Surchg 120,492.00- 120,492.00- 10,953.82- 76,676.74- 63.636 43,815.26- Subtotal: 337,386.00- 337,386.00- 11,306.39- 77,903.92- 23.090 259,482.08- Program number: 1,016,223.00- 1,016,223.00- 15,914.41- 743,490.32- 73.162 272,732.68- Department number: Revenues 1,016,223.00- 1,016,223.00- 15,914.41- 743,490.32- 73.162 272,732.68- Revenues Subtotal ----------- 1,016,223.00- 1,016,223.00- 15,914.41- 743,490.32- 73.162 272,732.68- Trophy Club Municipal Utility District No. 1 124 of 149 May 16, 2017 - Agenda Packet . glbase_tbam rgonzale Trophy Club MUD No.1 Page 22 18:31 05/10/17 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 2,550.00 2,550.00 1,250.00 49.020 1,300.00 533-70025-051-000 Bond Interest Expense-Tax 300,583.00 300,583.00 150,491.25 50.066 150,091.75 533-70035-051-000 Bond Principal Payment-Tax 710,000.00 710,000.00 710,000.00 Subtotal: 1,013,133.00 1,013,133.00 151,741.25 14.977 861,391.75 Program number: 1,013,133.00 1,013,133.00 151,741.25 14.977 861,391.75 Department number: Administration 1,013,133.00 1,013,133.00 151,741.25 14.977 861,391.75 Expenditures Subtotal ----------- 1,013,133.00 1,013,133.00 151,741.25 14.977 861,391.75 Fund number: 533 MUD 1 I&S Consolidated 3,090.00- 3,090.00- 15,914.41- 591,749.07- ############### 588,659.07 Trophy Club Municipal Utility District No. 1 125 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 49 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 4/2017 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 1417 04/03/2017 Property Taxes (658,734.96) (75.19) (658,810.15) GL 1418 04/04/2017 Property Taxes (578.10) (659,388.25) GL 1419 04/05/2017 Property Taxes (27.50) (659,415.75) GL 1420 04/06/2017 Property Taxes (45.42) (659,461.17) GL 1422 04/07/2017 Property Taxes (680.89) (660,142.06) GL 1423 04/10/2017 Property Taxes 680.89 (659,461.17) GL 1424 04/11/2017 Property Taxes (1,393.44) (660,854.61) GL 1425 04/13/2017 Property Taxes (203.43) (661,058.04) GL 1427 04/18/2017 Property Taxes (92.83) (661,150.87) GL 1428 04/20/2017 Property Taxes (331.37) (661,482.24) GL 1429 04/21/2017 Property Taxes (582.97) (662,065.21) GL 1430 04/25/2017 Property Taxes (3.23) (662,068.44) GL 1431 04/26/2017 Property Taxes (851.24) (662,919.68) GL 1432 04/28/2017 Property Taxes (142.84) (663,062.52) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (4,327.56) (663,062.52) ** (673,336.00) Budgeted (10,273.48) Remaining 98 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1418 04/04/2017 Property Taxes (1,242.85) (.18) (1,243.03) GL 1424 04/11/2017 Property Taxes (3.62) (1,246.65) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (3.80) (1,246.65) ** (3,501.00) Budgeted (2,254.35) Remaining 36 % Used Account: 533-40015-000-000 Property Taxes/P & I 1417 04/03/2017 Property Taxes (1,000.57) (4.36) (1,004.93) GL 1418 04/04/2017 Property Taxes (8.52) (1,013.45) GL 1420 04/06/2017 Property Taxes (3.18) (1,016.63) GL 1424 04/11/2017 Property Taxes (105.68) (1,122.31) GL 1425 04/13/2017 Property Taxes (22.37) (1,144.68) GL 1426 04/17/2017 Property Taxes 9.23 (1,135.45) GL 1428 04/20/2017 Property Taxes (36.45) (1,171.90) GL 1429 04/21/2017 Property Taxes (50.39) (1,222.29) GL 1430 04/25/2017 Property Taxes (.33) (1,222.62) GL 1431 04/26/2017 Property Taxes (38.94) (1,261.56) GL 1432 04/28/2017 Property Taxes (15.67) (1,277.23) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (276.66) (1,277.23) ** (2,000.00) Budgeted (722.77) Remaining 64 % Used Trophy Club Municipal Utility District No. 1 126 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 50 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-49010-000-000 Interest Income 1440 04/30/2017 Bank Interest April 2017 (874.61) (352.57) (1,227.18) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (352.57) (1,227.18) ** (140.00) Budgeted 1,087.18 Remaining 877 % Used Account: 533-49015-000-000 Lease/Rental Income .00 .00 _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 .00 ** (216,754.00) Budgeted (216,754.00) Remaining 0 % Used Account: 533-49141-000-000 Interfund Trans In-PID Surchg 1374 04/28/2017 Texpool Transfers (65,722.92) (10,953.82) (76,676.74) GL _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (10,953.82) (76,676.74) ** (120,492.00) Budgeted (43,815.26) Remaining 64 % Used Department Totals: ----------------------------------- (743,490.32) ** (15,914.41) Monthly Total (1,016,223.00) Budgeted (272,732.68) Remaining 73 % Used Trophy Club Municipal Utility District No. 1 127 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 51 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 4/2017 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,250.00 .00 1,250.00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 1,250.00 ** 2,550.00 Budgeted 1,300.00 Remaining 49 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax 150,491.25 .00 150,491.25 _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: .00 150,491.25 ** 300,583.00 Budgeted 150,091.75 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 ** 710,000.00 Budgeted 710,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- 151,741.25 ** .00 Monthly Total 1,013,133.00 Budgeted 861,391.75 Remaining 15 % Used Fund 533 Totals: ----------------------------------- (591,749.07) (15,914.41) Monthly Total (3,090.00) Budgeted 588,659.07 Remaining ########## Trophy Club Municipal Utility District No. 1 128 of 149 May 16, 2017 - Agenda Packet TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET APRIL 2017 APRIL 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 279,065 ACCOUNTS RECEIVABLE - TOTAL ASSETS 279,065 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 15,097 NET REVENUES / EXPENDITURES 263,968 TOTAL FUND BALANCE 279,065 TOTAL LIABILITIES AND FUND BALANCE 279,065 Trophy Club Municipal Utility District No. 1 129 of 149 May 16, 2017 - Agenda Packet . glbase_tbam rgonzale Trophy Club MUD No.1 Page 23 18:31 05/10/17 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49010-000-000 Interest Income 200.00- 200.00- 134.85- 444.20- 222.100 244.20 534-49142-000-000 Interfund Tran In-Water Sales 297,011.00- 297,011.00- 297,011.00- 534-49143-000-000 Interfund Transfer In-WW Sales 595,638.00- 595,638.00- 54,148.91- 379,042.37- 63.636 216,595.63- Subtotal: 892,849.00- 892,849.00- 54,283.76- 379,486.57- 42.503 513,362.43- Program number: 892,849.00- 892,849.00- 54,283.76- 379,486.57- 42.503 513,362.43- Department number: Revenues 892,849.00- 892,849.00- 54,283.76- 379,486.57- 42.503 513,362.43- Revenues Subtotal ----------- 892,849.00- 892,849.00- 54,283.76- 379,486.57- 42.503 513,362.43- Trophy Club Municipal Utility District No. 1 130 of 149 May 16, 2017 - Agenda Packet . glbase_tbam rgonzale Trophy Club MUD No.1 Page 24 18:31 05/10/17 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-70040-051-000 Revenue Bond Interest Expense 387,649.00 387,649.00 115,518.75 29.800 272,130.25 534-70045-051-000 Revenue Bond Principal Expense 505,000.00 505,000.00 505,000.00 Subtotal: 892,649.00 892,649.00 115,518.75 12.941 777,130.25 Program number: 892,649.00 892,649.00 115,518.75 12.941 777,130.25 Department number: Administration 892,649.00 892,649.00 115,518.75 12.941 777,130.25 Expenditures Subtotal ----------- 892,649.00 892,649.00 115,518.75 12.941 777,130.25 Fund number: 534 2015 Revenue Bond I&S 200.00- 200.00- 54,283.76- 263,967.82- ############### 263,767.82 Trophy Club Municipal Utility District No. 1 131 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 52 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 4/2017 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 1440 04/30/2017 Bank Interest April 2017 (309.35) (134.85) (444.20) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (134.85) (444.20) ** (200.00) Budgeted 244.20 Remaining 222 % Used Account: 534-49142-000-000 Interfund Tran In-Water Sales .00 .00 _______________ Account: 534-49142-000-000 Interfund Tran In-Water Sales Totals: .00 .00 ** (297,011.00) Budgeted (297,011.00) Remaining 0 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales 1374 04/28/2017 Texpool Transfers (324,893.46) (54,148.91) (379,042.37) GL _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (54,148.91) (379,042.37) ** (595,638.00) Budgeted (216,595.63) Remaining 64 % Used Department Totals: ----------------------------------- (379,486.57) ** (54,283.76) Monthly Total (892,849.00) Budgeted (513,362.43) Remaining 43 % Used Trophy Club Municipal Utility District No. 1 132 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 53 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 4/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-70040-051-000 Revenue Bond Interest Expense 115,518.75 .00 115,518.75 _______________ Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: .00 115,518.75 ** 387,649.00 Budgeted 272,130.25 Remaining 30 % Used Account: 534-70045-051-000 Revenue Bond Principal Expense .00 .00 _______________ Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 ** 505,000.00 Budgeted 505,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- 115,518.75 ** .00 Monthly Total 892,649.00 Budgeted 777,130.25 Remaining 13 % Used Fund 534 Totals: ----------------------------------- (263,967.82) (54,283.76) Monthly Total (200.00) Budgeted 263,767.82 Remaining ########## Trophy Club Municipal Utility District No. 1 133 of 149 May 16, 2017 - Agenda Packet TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET APRIL 2017 535 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS 153,459 ACCOUNTS RECEIVABLE - TOTAL ASSETS 153,459 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE - NET REVENUES / EXPENDITURES 153,459 TOTAL FUND BALANCE 153,459 TOTAL LIABILITIES AND FUND BALANCE 153,459 Trophy Club Municipal Utility District No. 1 134 of 149 May 16, 2017 - Agenda Packet . glbase_tbam rgonzale Trophy Club MUD No.1 Page 25 18:31 05/10/17 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 4/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-49010-000-000 Interest Income 78.32- 208.64- 208.64 535-49142-000-000 Interfund Tran In-Water Sales 21,892.88- 153,250.13- 153,250.13 Subtotal: 21,971.20- 153,458.77- 153,458.77 Program number: 21,971.20- 153,458.77- 153,458.77 Department number: Revenues 21,971.20- 153,458.77- 153,458.77 Revenues Subtotal ----------- 21,971.20- 153,458.77- 153,458.77 Fund number: 535 2016 Rev Bond I&S-SWIFT 21,971.20- 153,458.77- 153,458.77 ******* End of Report ********* Trophy Club Municipal Utility District No. 1 135 of 149 May 16, 2017 - Agenda Packet . glpdatb2 rgonzale Trophy Club MUD No.1 Page 54 18:33 05/10/17 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 4/2017 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 1440 04/30/2017 Bank Interest April 2017 (130.32) (78.32) (208.64) GL _______________ Account: 535-49010-000-000 Interest Income Totals: (78.32) (208.64) ** .00 Budgeted 208.64 Remaining 0 % Used Account: 535-49142-000-000 Interfund Tran In-Water Sales 1374 04/28/2017 Texpool Transfers (131,357.25) (21,892.88) (153,250.13) GL _______________ Account: 535-49142-000-000 Interfund Tran In-Water Sales Totals: (21,892.88) (153,250.13) ** .00 Budgeted 153,250.13 Remaining 0 % Used Department Totals: ----------------------------------- (153,458.77) ** (21,971.20) Monthly Total .00 Budgeted 153,458.77 Remaining 0 % Used Fund 535 Totals: ----------------------------------- (153,458.77) (21,971.20) Monthly Total .00 Budgeted 153,458.77 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- 249,213.45 **** (153,027.10) Monthly Total (192,002.00) Budgeted (441,215.45) Remaining ########## ******* End of Report ********* Trophy Club Municipal Utility District No. 1 136 of 149 May 16, 2017 - Agenda Packet BUDGET VARIANCE REPORT FUND:122 - Fire O&M FINANCIALS MONTH:April 2017 REVENUE VARIANCE:50.0% EXPENSE VARIANCE:68.3% NOTE: ACCOUNT DESCRIPTION TOTAL BUDGET CURRENT YTD TOTAL YTD % DATE OF COMMENT VARIANCE EXPLANATION FIRE REVENUES 122-40010 Property Taxes/Fire 1,035,810 6,658 1,019,834 98.458%10/2016 Property Taxes collected 122-40011 Property Taxes/Fire - Delinquent - 7 1,968 10/2016 Delinquent Fire Taxes collected 122-40020 Property Taxes/Fire P&I 4,500 439 2,554 56.756%10/2016 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 Trophy Club Municipal Utility District No. 1 137 of 149 May 16, 2017 - Agenda Packet BUDGET VARIANCE REPORT FUND:135 - MUD 1 O&M FINANCIALS MONTH:April 2017 REVENUE VARIANCE:50.0% EXPENSE VARIANCE:68.3% NOTE: ACCOUNT DESCRIPTION TOTAL BUDGET CURRENT MONTH YTD TOTAL YTD % DATE OF COMMENT VARIANCE EXPLANATION REVENUE 135-40000 Property Taxes 60,977 392 60,017 98.43%12/2016 Property Taxes collected 135-49010 Interest Income 8,001 1,571 8,818 110.21%2/2017 Bank interest 135-49901 Records Management Revenue 20 2 32 160.00%4/2017 Record Requests EXPENSES WATER 135-60066-010 Publications/Books/Subscriptions 750 767 767 102.27%4/2017 AWWA Standards 135-60333-010 Interfund Transfer Out-Reserve 64,920 14,361 100,527 154.848%1/2017 Transfer for Swift Funding Reserve account 135-69281-010 Water Tank Inspection Contract 126,958 8,183 126,958 100.000%032017 Final payment for Pax Mixers. WASTEWATER 135-55090-020 Vehicle Maintenance 6,600 1,238 7,058 107%4/2017 6 Tires for 2015 Silverado 3500 PU 135-60100-020 Travel & Per Diem 2,400 115 2,246 94%4/2017 Tolls & Meals 135-65035-020 Small Tools 2,000 268 1,368 68%04/2017 Tire Chuck, Couplers, Coupler plug, Tire gauge, Saw kit, Blade set 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 Trophy Club Municipal Utility District No. 1 138 of 149 May 16, 2017 - Agenda Packet FUND:135 - MUD 1 O&M FINANCIALS MONTH:April 2017 REVENUE VARIANCE:50.0% EXPENSE VARIANCE:68.3% NOTE: ACCOUNT DESCRIPTION TOTAL BUDGET CURRENT MONTH YTD TOTAL YTD % DATE OF COMMENT VARIANCE EXPLANATION Explanation provided for all accounts with a Year-To-Date percentage (YTD%)less than the Revenue Variance and greater than or equal to the Expense Variance.The Revenue and Expense Variance is calculated on a straight-line method (Financials Month x 8.3%),less 8.3%for revenues and plus 10% for expenses. Only accounts with current month activity will be listed 135-65045-020 Lab Supplies 14,000 2,880 10,669 76%04/2017 Lab & Testing Supplies BOARD OF DIRECTORS ADMINISTRATION 135-50010-030 Overtime 2,500$ 1,415$ 3,193$ 128%04/2017 Mailings 135-50060-030 Pre-employment testing 500$ 63$ 402$ 80%04/2017 W/C Drug screen 135-55030-030 Software & Support 77,791$ 9,157$ 65,920$ 85%4/2017 STW-Setup for winter avg,rebill SWR consumption, MCCI 135-55100-030 Building Maintenance & Supplies 7,000$ 66$ 5,805$ 83%04/2017 Rug Service 135-60100-030 Travel & Per Diem 7,500$ 200$ 6,892$ 92%04/2017 Mileage Reimbursement NON-DEPARTMENTAL Trophy Club Municipal Utility District No. 1 139 of 149 May 16, 2017 - Agenda Packet FY October November December January February March April May June July August September Total Year 2007 73,757 44,297 35,905 31,695 25,671 40,516 43,121 31,204 42,191 43,717 72,462 76,138 560,674 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 370,935 FY October November December January February March April May June July August September Total Year 2007 72,460 49,249 34,203 28,257 31,492 43,900 41,770 37,340 41,215 43,136 75,480 72,087 570,589 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 425,909 FY October November December January February March April May June July August September 2007 2815 2815 2817 2817 2825 2825 2825 2825 2869 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 2013 Total 3879 3887 3880 3915 3932 3950 3978 4028 4062 4084 4095 4119 2013 MUD 3031 2013 PID 1088 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 00000 Active Connections Monthly Water Report FY 2017 Water Billed Water Pumped 0 20000 40000 60000 80000 100000 120000 140000 160000 October November December January February March April May June July August September WATER BILLED IN MILLIONS OF GALLONS 2013 2014 2015 2016 2017 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 MILLIONS OF GALLONS 2013 2014 2015 2016 2017 Trophy Club Municipal Utility District No. 1 140 of 149 May 16, 2017 - Agenda Packet 2017 MUD 3208 3210 3220 3216 3221 3224 3228 2017 PID 1436 1437 1441 1441 1442 1442 1442 Trophy Club Municipal Utility District No. 1 141 of 149 May 16, 2017 - Agenda Packet Influent EffluentInfluent EffluentInfluent Effluent3‐Apr 37 0.85 97.7% 203 2.0 99.0% 166 1.6 99.0%4‐Apr 35 0.2 99.4% 254 2.0 99.2% 200 1.2 99.4%  10‐Apr 31 0.27 99.1% 240 2.0 99.2% 240 1.0 99.6%11‐Apr 34 0.26 99.2% 221 2.0 99.1% 332 1.4 99.6% 17‐Apr 45 0.37 99.2% 280 2.0 99.3% 168 1.2 99.3%18‐Apr 43 0.2 99.5% 222 2.0 99.1% 218 2.0 99.1% 24‐Apr 37 0.36 99.0% 227 2.0 99.1% 264 4.0 98.5%25‐Apr 45 0.24 99.5% 194 2.0 99.0% 187 2.6 98.6%99.1%99.1%99.1%Date% Removal% Removal% RemovalReportApril 2017 ResultsAmmonia‐NCBOD5TSS0.342.01.9Ammonia‐NCBOD5TSSTrophy Club Municipal Utility District No. 1142 of 149May 16, 2017 - Agenda Packet Max mg/L 1.05Aver mg/L 0.545Max mg/L 2.3Aver mg/L 2.1Ammonia NitrogenCarbonaceous Biochemical Demand (CBOD5)0.591.0500.2000.34000.511.522.533.5Jan‐16 Feb‐16 Mar‐16 Apr‐16 May‐16 Jun‐16 Jul‐16 Aug‐16 Sep‐16 Oct‐16 Nov‐16 Dec‐16NH‐3 mg/LAveragePermit Limit2.32.22.02.00.0001.0002.0003.0004.0005.0006.000Jan‐16 Feb‐16 Mar‐16 Apr‐16 May‐16 Jun‐16 Jul‐16 Aug‐16 Sep‐16 Oct‐16 Nov‐16 Dec‐16CBOD5AveragePermit LimitTrophy Club Municipal Utility District No. 1143 of 149May 16, 2017 - Agenda Packet Max mg/L 2.9Aver mg/L 2.4Max mg/L 9.8Aver mg/L 8.4Nitrate - NitrogenTotal Suspended Solids (TSS)2.92.22.61.90.02.04.06.08.010.012.014.0Jan‐16 Feb‐16 Mar‐16 Apr‐16 May‐16 Jun‐16 Jul‐16 Aug‐16 Sep‐16 Oct‐16 Nov‐16 Dec‐16TSSAveragePermit Limit8.17.09.88.50.05.010.015.020.025.030.0Jan‐16 Feb‐16 Mar‐16 Apr‐16 May‐16 Jun‐16 Jul‐16 Aug‐16 Sep‐16 Oct‐16 Nov‐16 Dec‐16Nitrate‐NAveragePermit LimitTrophy Club Municipal Utility District No. 1144 of 149May 16, 2017 - Agenda Packet Max mg/L 2.1Aver mg/L 1.7Max mg/L 7.6Min mg/L 7.3Aver mg/L 7.4Potential for Hydrogen (pH)E. Coli1.52.11.31.90.020.040.060.080.0100.0120.0140.0Jan‐16 Feb‐16 Mar‐16 Apr‐16 May‐16 Jun‐16 Jul‐16 Aug‐16 Sep‐16 Oct‐16 Nov‐16 Dec‐16E. ColiAveragePermit Limit7.37.47.47.47.47.57.67.60.01.02.03.04.05.06.07.08.09.010.0Jan‐16 Feb‐16 Mar‐16 Apr‐16 May‐16 Jun‐16 Jul‐16 Aug‐16 Sep‐16 Oct‐16 Nov‐16 Dec‐16pH MinAveragePermit Limit MinPermit Limit MaxpH MaxTrophy Club Municipal Utility District No. 1145 of 149May 16, 2017 - Agenda Packet Max mg/L 7.4Aver mg/L 7.2 Dissolved Oxygen (DO)7.37.07.47.10.01.02.03.04.05.06.07.08.0Jan‐16 Feb‐16 Mar‐16 Apr‐16 May‐16 Jun‐16 Jul‐16 Aug‐16 Sep‐16 Oct‐16 Nov‐16 Dec‐16DOAveragePermit LimitTrophy Club Municipal Utility District No. 1146 of 149May 16, 2017 - Agenda Packet October November December January February March April May June July August September ebills 758 758 778 780 780 799 810 Bills Mailed 3870 3866 3900 3884 3875 3876 3877 Bank Draft 624 610 623 608 617 620 622 Credit Card Draft 882 897 949 944 945 927 964 Online Payments 1041 1057 1,053 2,019 2,014 2,052 2,037 Late Notices 506 455 471 382 491 500 476 Disconnects 30 37 37 44 35 51 61 M 3208 3210 3214 3216 3221 3224 3228 Connections P 1436 1437 1441 1441 1442 1442 1442 October November December January February March April May June July August September ebills 747 741 739 745 741 736 756 762 759 753 747 756 Bills Mailed 3825 3824 3852 3849 3861 3873 3880 3883 3913 3927 3925 3927 Bank Draft 599 602 594 593 599 604 615 617 628 624 613 614 Credit Card Draft 767 769 807 799 816 819 827 849 834 853 860 868 Online Payments 1002 954 980 987 944 972 958 955 972 991 1028 1030 Late Notices 529 468 409 506 371 410 448 328 391 442 342 460 Disconnects 64 56 45 40 36 41 40 30 30 16 28 28 3155 3158 3167 3172 3176 3181 3183 3186 3188 3192 3196 3200 Active Connections 1376 1380 1389 1396 1417 1423 1424 1430 1434 1435 1436 1436 Trophy Club MUD #1 Utility Billing Report Fiscal Year 2017 Fiscal Year 2016 Trophy Club Municipal Utility District No. 1 147 of 149 May 16, 2017 - Agenda Packet MUD Permits Month: April 2017 Note: Date of Permit is actual date permit was paid 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 4/12/2017 20170023 75.00$ ****-$ -$ -$ -$ -$ 75.00$ 4/12/2017 20170024 75.00$ 1,173.00$ 343.00$ -$ -$ -$ 1,591.00$ 4/12/2017 20170025 75.00$ 1,173.00$ 343.00$ -$ -$ 1,591.00$ 4/21/2017 20170026 75.00$ 1,173.00$ 343.00$ -$ -$ 1,591.00$ 4/21/2017 20170027 75.00$ 1,173.00$ 343.00$ -$ -$ 1,591.00$ 4/21/2017 20170028 75.00$ 2,345.00$ 887.00$ -$ -$ 3,307.00$ -$ -$ -$ -$ Total 450.00$ 7,037.00$ 2,259.00$ -$ -$ -$ -$ 9,746.00$ ****Impact fee paid 1/8/2014 Trophy Club Municipal Utility District No. 1 148 of 149 May 16, 2017 - Agenda Packet June 2017CalendarsFS Conference RoomFS Training RoomPolice Conference RoomPS Large Conference RoomPS Small Conference RoomSvore Board RoomSunMonTueWedThuFriSat22May 28, 2017293031Jun 1238amFire Training (Hurd)8amFire Training (Hurd)7pmTCWC Meeting8amFire Training (Hurd)9:30amBabysitting Class (Kelly9amMgt Team Meetings7pmDrowning Prevention (Bria12pmCourt (Court)23456789108amFire Camp8amFire Camp8amFire Camp8amFire Camp12:30pmBudget Meetings (S12:30pmBudget Meetings (S9amMgt Team Meetings10amSpecial Events Commi8amFire Camp7pmEDC-4B Board Meeting 12:30pmBudget Meetings (S12:30pmBudget Meetings (S8:30am(No title) (WWTP Meeti12:30pmBudget Meeting (Shan7:30amTarrant County Elections (Holly)24111213141516175pmTown Council Meeting (8amBEST EMS CE (CPT SAB12:30pmBudget Meetings (S8amBEST EMS CE (CPT SAB8amBEST EMS CE (CPT SAB9amMgt Team Meetings10:30amMonthly Financials Re12:30pmBudget Meetings (S12:30pmBudget Meetings (S12:30pmBudget Meetings (Sha7pmTCEVA Meeting (Elaine7:30amTarrant County Elections (Holly)25181920212223247pmPark Board (Shannon)6pmTrophy Club Municipal U9amMgt Team Meetings10amSpecial Events Commi26252627282930Jul 11pmFire Training (Hurd)5pmTown Council Meeting (9amMgt Team Meetings1pmFire Training (Hurd)12pmCourt (Court)1pmFire Training (Hurd)Powered byTC Meeting SpacesTC Meeting SpacesTC Meeting SpacesPage 1 of 15/12/2017https://teamup.com/ksbf512320f9756527Trophy Club Municipal Utility District No. 1149 of 149May 16, 2017 - Agenda Packet