Loading...
HomeMy WebLinkAbout2018-03 March 20 2018 Regular Meeting Packet AMENDED      BOARD OF DIRECTORS  REGULAR MEETING AGENDA – AMENDED**    TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1  100 MUNICIPAL DRIVE  TROPHY CLUB, TEXAS 76262    March 20, 2018                                                            6:30 P.M.                                     Svore Municipal Boardroom   REGULAR MEETING AGENDA    CALL TO ORDER AND ANNOUNCE A QUORUM    CITIZEN COMMENTS  This is an opportunity for citizens to address the Board on any matter whether or not it is posted on the agenda.  The Board is not permitted to take action on or discuss any presentations made to the Board at this time  concerning an item not listed on the agenda. The Board will hear presentations on specific agenda items prior  to the Board addressing those items. You may speak up to three (3) minutes or the time limit determined by  the President or presiding officer.    CONSENT AGENDA  All matters listed as Consent Agenda are considered to be routine by the Board of Directors and will be  enacted by one motion. There will not be a separate discussion of these items. If discussion is desired, that  item will be removed from the consent agenda and will be considered separately.    1. Consider and take appropriate action to approve the Consent Agenda.   a. February 2018 Check Register  b. February 20, 2018 Regular Meeting Minutes           attachments:  February 2018 Check Register          February 20, 2018 Regular Meeting Minutes  REGULAR SESSION  2. Discussion and possible action regarding results of Winter Average Analysis completed by NewGen  Strategies & Solutions.     3. Consider and take appropriate action to adopt order declaring the following vehicles as surplus property  of the District and authorizing staff to dispose of such vehicles:  a. Truck No. 200 ‐ 2013 Chevrolet extended cab pick‐up truck with 102,929 miles purchased March 2013  b. Truck No. 201 ‐ 2013 Chevrolet 1500 pick‐up truck with 127,272 miles purchased March 6, 2013    4. Consider and take appropriate action relating to cancellation of May 5, 2018 Director Election:  a. Accept Certification of Unopposed Candidates.  Aceptar certificatiόn de candidatos únicos. b. Adopt Order Canceling Election.  Adoptar una Orden de cancelación.   attachments: Certificate of Unopposed Candidates          Order No. 2018‐0320A   Trophy Club Municipal Utility District No. 1 1 of 130 March 20, 2018 Agenda Packet AMENDED**   5. Consider and take appropriate action regarding adoption of Resolution No. 2018‐0320A Authorizing the  General Manager to Approve Construction Contract Change Orders.     6. Consider and take appropriate action regarding Order No. 2018‐0320B Authorizing the General Manager  to approve certain expenditures, sign disbursements and enter into contracts on behalf of the District  and containing other matters relating thereto.  7. Consider and take appropriate action regarding tree replacement options related to the construction of  Waterline Improvement Project for Indian Creek Drive and Phoenix Drive.    8. Consider and take appropriate action regarding the February 2018 Combined Financials and Variance  Report.   a. Combined Financials   b. Combined Variance           attachments:  February 2018 Financials            February 2018 Variance    REPORTS & UPDATES  9. Receive update regarding Association of Water Board Directors 2018 Mid Winter Conference. (Carr,  Rose, Thomas)    10. General Manager Monthly Reports and Update:   a. Regulatory Update  b. Class and Compensation Study Update  c. Capital Improvement Projects    16‐inch waterline project to serve Town Center    Wastewater Treatment Plant Upgrade Project   High Service Pump    Joint Projects with Town  d. Water System Operation  e. Wastewater System Operation  f. Website Analytics  g. Finance Update   Utility Billing Report   Permits Collected   Cash Report   attachments:  General Manager report          Water Operation Report          Wastewater Operation Report          Website Analytics          Utility Billing Report             Permits Collected          Cash Report    Trophy Club Municipal Utility District No. 1 2 of 130 March 20, 2018 Agenda Packet AMENDED**   EXECUTIVE SESSION  11. Pursuant to Section 551.071 of the Texas Open Meetings Act, the Board may consult with its attorney in  Executive Session on a matter in which the duty of the attorney to the Governmental Body under the  Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflicts with the Open  Meetings Act or to seek advice of counsel on legal matters involving pending or contemplated litigation  or settlement offers:      a. Seek Legal advice and opinion regarding lease agreement for District owned property located at 100  Municipal Drive and 1501 Junction Way. (Carr) **    12. Deliberations pursuant to Section 551.076 of the Texas Open Meetings Act regarding the deployment  of security devices at the Wastewater Treatment Plant. (Carr)    REGULAR SESSION  13. Consider and take appropriate action on matters deliberated in Executive Session:    14. Items for future agendas:    15. Set future Meeting dates ‐ Regular Board Meeting on April 17, 2018 at 6:30 p.m.   attachment: April meeting calendar    *THE BOARD RESERVES THE RIGHT TO ADJOURN INTO EXECUTIVE SESSION AT ANY TIME DURING THE  MEETING PURSUANT TO THE APPLICABLE SECTION OF SUBCHAPTER D, CHAPTER 551, TEXAS GOVERNMENT  CODE, THE TEXAS OPEN MEETINGS ACT, WITH RESPECT TO ANY ITEM ON THE AGENDA.  NO FINAL ACTION,  DECISION OR VOTE WILL BE TAKEN ON ANY SUBJECT OR MATTER IN CLOSED SESSION.  THIS NOTICE MODIFIES  THE DISTRICT'S PRIOR PRACTICE OF SPECIFICALLY IDENTIFYING ALL AGENDA ITEMS TO BE DISCUSSED IN  CLOSED SESSION.    ADJOURN    Trophy Club Municipal Utility District No. 1 3 of 130 March 20, 2018 Agenda Packet AMENDED** Trophy Club Municipal Utility District No. 1 4 of 130 March 20, 2018 Agenda Packet AMENDED** Trophy Club Municipal Utility District No. 1 5 of 130 March 20, 2018 Agenda Packet AMENDED** Trophy Club Municipal Utility District No. 1 6 of 130 March 20, 2018 Agenda Packet AMENDED** Trophy Club Municipal Utility District No. 1 7 of 130 March 20, 2018 Agenda Packet AMENDED** Trophy Club Municipal Utility District No. 1 8 of 130 March 20, 2018 Agenda Packet AMENDED** Trophy Club Municipal Utility District No. 1 9 of 130 March 20, 2018 Agenda Packet AMENDED** Trophy Club Municipal Utility District No. 1 10 of 130 March 20, 2018 Agenda Packet AMENDED** Trophy Club Municipal Utility District No. 1 11 of 130 March 20, 2018 Agenda Packet AMENDED** REGULAR MEETING MINUTES   TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1  BOARD OF DIRECTORS   February 20, 2018 at 6:30 P.M.  100 Municipal Drive, Trophy Club, Texas 76262    Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in a  Regular Session on Tuesday, February 20, 2018 at 6:30 P.M., in the Boardroom of the Administration Building,  100 Municipal Drive, Trophy Club, Texas 76262. The meeting was held within the boundaries of the District,  and was open to the public.    STATE OF TEXAS     §  COUNTIES OF DENTON AND TARRANT              §    BOARD MEMBERS PRESENT:  Kevin R. Carr President  Gregory Wilson Vice President  William C. Rose Secretary/Treasurer  Jim Thomas Director  Jim Hase Director    STAFF PRESENT:  John Carman General Manager  Laurie Slaght District Secretary  Mike McMahon Water Superintendent  Karl Schlielig Wastewater Superintendent  Steven Krolczyk Finance Manager  Tony Corbett Legal Counsel    GUESTS PRESENT:   Tom Rutledge        Teague Nall & Perkins    CALL TO ORDER AND ANNOUNCE A QUORUM   Director Carr announced the date of February 20, 2018, called the meeting to order and announced a quorum  present at 6:30 p.m.    CITIZEN COMMENTS:  Kellie & Roel Garza  556 Indian Creek Drive   Brittany Barefoot‐McGinnis 219 Phoenix Drive    CONSENT AGENDA  1. Consider and take appropriate action to approve the Consent Agenda.   a. January 2018 Check Register  b. January 16, 2018 Regular Meeting Minutes  c. January 24, 2018 Special Meeting Minutes    Director Carr requested that the January 16, 2018 Regular meeting minutes and January 24, 2018 Special  Meeting minutes be pulled from the Consent agenda for further consideration by the Board.      Motion made by Director Carr and seconded by Director Rose to approve the January 16, 2018 Regular  Trophy Club Municipal Utility District No. 1 12 of 130 March 20, 2018 Agenda Packet AMENDED** Meeting Minutes as Amended at the dais.     Motion carried unanimously    Motion made by Director Thomas and seconded by Director Rose to approve the January 24, 2018 Special  Meeting Minutes as Amended at the dais.     For: Carr, Hase, Rose, Thomas  Abstain: Wilson    Motion passed 4‐1    Motion made by Director Rose and seconded by Director Thomas to approve Consent Agenda item a.  January 2018 Check Register.    Motion carried unanimously    REGULAR SESSION  2. Consider and take appropriate action regarding water system capital improvement projects:  a. Consider and take appropriate action regarding approval of bid for construction of Water  Improvements for Indian Creek Drive (Fair Green Drive to Meadowbrook Lane) and for Phoenix Drive  (Pebble Beach Drive to Shields Drive) and award of Contract No. 2018012401 as part of the Fiscal  Year 2018 Capital Improvement Projects; and  b. Consider and take appropriate action regarding approval of bid and award of Contract No.  2018022001 for valve replacements as part of the FY2018 capital improvement projects.    Tom Rutledge with Teague Nall and Perkins presented an overview of the project and answered  questions related thereto.       Residents Kellie and Roel Garza and Brittany Barefoot‐McGinnis spoke regarding trees located on their  property that will be impacted by this project.       Attorney Corbett reviewed options for the Board to consider if they would like to replace the  homeowner’s trees and clarified that the District cannot write a check to the homeowners for  replacement of the trees as it would be an unconstitutional donation.   The District can enter into an  agreement that has a public purpose with a homeowner but there must be contract that specifically  states the public purpose of the tree replacement so it very clear it is not a gratuitous donation of public  monies.  Corbett stated if the Board desires to move forward with a type of payment, he will structure  an agreement that considers the planting, maintenance and public purpose or the Board could choose  not to do anything as the trees are all within the easements.   The District could also install a tree within  the easement or right of way however the District does not have the authority to install a tree on private  property without an easement.     Regarding 2 a.     Motion made by Director Thomas and seconded by Director Rose to award the bid to Quality Excavation,  Ltd., for an amount not to exceed $426,022.50 and approve the Contract No. 2018012401 for water  improvements as part of the FY2018 capital improvement projects.    Motion carried unanimously  Trophy Club Municipal Utility District No. 1 13 of 130 March 20, 2018 Agenda Packet AMENDED**   Motion made by Director Rose and seconded by Director Carr to allow the General Manager to approve  and execute the necessary documentation for Contract No. 2018012401.    Motion carried unanimously    Regarding 2b.     Motion made by Director Rose and seconded by Director Thomas to approve of bid of Reymar Construction  Co. for an amount not to exceed $49,997.62 and award of Contract No. 2018022001 for valve replacements  and authorize the General Manager to execute the contract and necessary documents.    Motion carried unanimously      3. Consider and take appropriate action to authorize staff to obtain bids for construction of the 16” water  transmission line improvements from the Water Treatment Plant to Town Center.    Motion made by Director Rose and seconded by Director Carr to direct staff to obtain bids for construction  of the 16” water transmission line improvements from the Water Treatment Plant to Town Center and to  bring those bids back to the Board for selection of a contractor.    Motion carried unanimously      4. Consider and take appropriate action regarding water system improvement projects:  a. Consider and take appropriate action regarding future needs for additional ground water storage  tank and waterline to support it; and  (Thomas/Hase)  b. Consider and take appropriate action regarding proposed construction of transmission line  improvements from the water plant to the elevated tank located on TW King Rd., including possible  alternatives thereto (Wilson/Rose)     General Manager John Carman was directed to provide his opinion regarding the water system improvement  projects that were recommended in the February 2016 Technical Memorandum Hydraulic Model and  Distribution System Capacity Study completed by CP&Y.  Carman gave the Board a presentation with his  opinion regarding the need for an additional ground storage tank as well as transmission line improvements  from the water plant to the elevated tank on TW King Rd and answered questions related thereto.       The General Manager’s Presentation is attached.    Discussion only, no action taken.      5. Consider and take appropriate action regarding Wastewater Treatment Plant Improvement Project:  a. Consider and take appropriate action regarding approval of Change Order No. 10R from Webber‐ Cadagua Partners in an amount of $266.44 for the Wastewater Treatment Plant Improvement  Project; and  b. Consider and take appropriate action regarding approval of Change Order No. 11R from Webber‐ Cadagua Partners in an amount of $64,741 for the Wastewater Treatment Plant Improvement  Project.   Trophy Club Municipal Utility District No. 1 14 of 130 March 20, 2018 Agenda Packet AMENDED** Motion made by Director Rose and seconded by Director Wilson to approve Change Order No. 10R from  Webber‐Cadagua Partners in the amount of $266.44 and approve Change Order No. 11R from Webber‐ Cadagua Partners in the amount of $64,741 for the Wastewater Treatment Plant Improvement Project.    For: Hase, Rose, Thomas, Wilson  Against: Carr    Motion passed 4‐1     The Board Recessed from 8:48 p.m. and reconvened into Regular Session at 9:03 p.m.      6. Consider and take appropriate action regarding adoption of Resolution No. 2018‐0220A authorizing the  General Manager to Approve Construction Contract Change Orders.     Motion made by Director Hase and seconded by Director Rose to allow the General Manager to Approve  Construction Contract Change Orders up to his $50,000 limit adopting Resolution No. 2018‐0220A.      For: Hase, Thomas  Against: Carr, Rose, Wilson     Motion Failed 2‐3      Motion made by Director Wilson seconded by Director Hase to modify the proposed resolution to allow  the General Manager to approve an aggregate amount of 25% of the contract up to $50,000 (whichever  is less.)      Motion is withdrawn by the first and second      Motion made by Director Rose and seconded by Director Carr to Table this item and have it brought back  to the next meeting.      Motion to table is unanimous      7. Consider and take appropriate action regarding Resolution No. 2018‐0220B approving the submittal of  Water Smart application for inclusion in the Association of Water Board Directors Water Smart Partners  Program.    Motion made by Director Rose and seconded by Director Thomas to approve Resolution No. 2018‐0220B  approving the submittal of Water Smart application for inclusion in the Association of Water Board  Directors Water Smart Partners Program.    Motion carried unanimously      8. Consider and take appropriate action regarding approval of the Fourth Amendment to the Water  Tower/Ground Lease Agreement with New Cingular Wireless PCS, LLC for property located at Hwy 114  Trophy Club Municipal Utility District No. 1 15 of 130 March 20, 2018 Agenda Packet AMENDED** & TW King Road, Trophy Club, Texas 76262 and authorize the General Manager to execute amendment  and all related documents.     Motion made by Director Rose and seconded by Director Carr to approve the Fourth Amendment to the  Water Tower/Ground Lease Agreement with New Cingular Wireless PCS, LLC for property located at Hwy  114 & TW King Road, known as the east tank and authorize the General Manager to execute the  amendment and all related documents.    Motion carried unanimously    9. Consider and take appropriate action regarding the January 2018 Combined Financials and Variance  Report.   a. Combined Financials   b. Combined Variance     Motion made by Director Rose and seconded by Director Wilson to approve the January 2018 Combined  Financials and Variance Report.    Motion carried unanimously      REPORTS & UPDATES  10. General Manager Monthly Reports and Update:  a. Regulatory Update  b. General Manager Expenditure, Disbursement and Contract Policy  c. May 5, 2018 Election Update  d. Capital Improvement Projects    Wastewater Treatment Plant Upgrade Project   High Service Pump    Joint Projects with Town  e. Water System Operation  f. Wastewater System Operation  g. Website Analytics  h. Finance Update   Utility Billing Report   Permits Collected   Cash Report    General Manager John Carman presented the monthly reports and answered questions related thereto.     The Board of Directors did not convene into Executive Session.    EXECUTIVE SESSION  11. Pursuant to Section 551.071 of the Texas Open Meetings Act, the Board may consult with its attorney in  Executive Session on a matter in which the duty of the attorney to the Governmental Body under the  Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflicts with the Open  Meetings Act or to seek advice of counsel on legal matters involving pending or contemplated litigation  or settlement offers:      Trophy Club Municipal Utility District No. 1 16 of 130 March 20, 2018 Agenda Packet AMENDED** a. Contractor breach, performance and payment issues related to District’s contract with Webber‐ Cadagua Partners for construction of the Wastewater Treatment Plant Improvements    REGULAR SESSION  12. Consider and take appropriate action on matters deliberated in Executive Session:      13. Items for future agendas:    AWBD update  General Manager Purchasing Resolution   Tree agreements for consideration      14. Set future Meeting dates ‐ Regular Board Meeting on March 20, 2018 at 6:30 p.m.      ADJOURN    Motion made by Director Rose and seconded by Director Carr to adjourn the meeting.    Motion carried unanimously      Director Carr called the meeting adjourned at 9:39p.m.           ______________________________  Kevin R. Carr, President                                                                                                  ______________________________                                                    (SEAL)  William R. Rose, Secretary/Treasurer                           ______________________________  Laurie Slaght, District Secretary  Trophy Club Municipal Utility District No. 1 17 of 130 March 20, 2018 Agenda Packet AMENDED** Planned Water Infrastructure ImprovementsCarmanTrophy Club Municipal Utility District No. 1Trophy Club Municipal Utility District No. 118 of 130March 20, 2018 Agenda Packet AMENDED** Agenda•Review of Fluid Mechanic Principles•Question Posed:  Are the three highest price tag elements of the proposed infrastructure improvements identified in the CP&Y February 2016 report still necessary?:•Interconnecting Pipeline to Eastern Tank (~2.4 M$);•Additional pipeline capacity to Fort Worth (~$16 M$); and•Additional Ground Storage Tank (~3M$)•Inherent Assumptions•Water/Wastewater Planning – Principles and Practices•RecommendationsTrophy Club Municipal Utility District No. 119 of 130March 20, 2018 Agenda Packet AMENDED** Axioms of Water System Design• Water flows downhill, and uphill to money;• Pipe ID (inner diameter) must be smaller than OD (outside diameter); and• Second Law of Thermodynamics3Trophy Club Municipal Utility District No. 120 of 130March 20, 2018 Agenda Packet AMENDED** Hydraulic Grade Line ConceptsTrophy Club Municipal Utility District No. 121 of 130March 20, 2018 Agenda Packet AMENDED** Trophy Club Municipal Utility District No. 122 of 130March 20, 2018 Agenda Packet AMENDED** Inherent Assumptions•Limited room for growth within the service area•Build‐out population – 14,000•Per capita water use will remain the same in the future as it is now•Groundwater, now around 10% of supply, will go away in the future•Number of folks per connection will go up Trophy Club Municipal Utility District No. 123 of 130March 20, 2018 Agenda Packet AMENDED** Recommendations•Is the Interconnecting Pipeline to Eastern Tank (~2.4 M$) needed?•Unequivocally Yes.  We are already contractually obligated to build part of this pipeline capacity.  (see hand outs)•Is the additional pipeline capacity to Fort Worth (~$16 M$) needed?•Yes, based on the assumptions listed.  We are already contractually obligated to build part of this pipeline capacity.  When remains an important question.•Is the Additional Ground Storage Tank (~3M$) needed?•Yes, based on the assumptions listed.  We are already contracted to build part of this pipeline capacity.  When remains an important question.•Every 5 years we should update planning studies for water and wastewater •Every year we should update condition assessments for all TCMUD infrastructure and update our five year CIP masterplan accordinglyTrophy Club Municipal Utility District No. 124 of 130March 20, 2018 Agenda Packet AMENDED** 0501001502002503003504001970 1975 1980 1985 1990 1995 2000 2005 2010YearMGD (Million gallons per day)02004006008001,0001,2001,4001,600Population Served, in 1000's1960 Water Plan1980 Water Plan1990 Water PlanActual Water DemandPopulationFigure 1 – Past Water Demands, Actual Water Demands and Population Served.Trophy Club Municipal Utility District No. 125 of 130March 20, 2018 Agenda Packet AMENDED** Lost in Space - OasisTrophy Club Municipal Utility District No. 126 of 130March 20, 2018 Agenda Packet AMENDED** 10Trophy Club Municipal Utility District No. 127 of 130March 20, 2018 Agenda Packet AMENDED** Trophy Club Municipal Utility District No. 128 of 130March 20, 2018 Agenda Packet AMENDED** ORDER NO. 2018-0320A ORDEN NRO. 2018-0320A LỆNH SỐ 2018-0320A ORDER OF CANCELLATION ORDEN DE CANCELACION LỆNH HỦY BỎ The Board of Directors of Trophy Club Municipal Utility District No. 1 hereby cancels the election scheduled to be held on May 5, 2018 in accordance with Section 2.053(a) of the Texas Election Code. The following candidates have been certified as unopposed and are hereby elected as follows: El Distrito Municipal Nro. 1 de Trophy Club por la presente cancela la elección que, de lo contrario, se hubiera celebrado el 5 de mayo de 2018, de conformidad con la Sección 2.053(a) del Código de Elecciones de Texas. Los siguientes candidatos han sido certificados como candidatos únicos y por la presente quedan elegidos como se indica a continuación: Ban Giám đốc của Cơ quan Dịch vụ Tiện ích Thành phố Số 1 Trophy Club theo đây hủy bỏ cuộc bầu cử dự kiến được tổ vào ngày 5 tháng 5 năm 2018 theo Mục 2.053(a) của Bộ luật Tuyển cử Texas. Các ứng cử viên sau đây đã được chứng nhận là không có đối thủ và theo đây được bầu chọn như sau: Candidate (Candidato) Ứng cử viên Office Sought (Cargo al que presenta candidatura) Chức vụ Ứng cử Director, Place 3 Director, puesto 3 (Giám đốc, Vị trí số 3) Director, Place 4 Director, puesto 4 (Giám đốc, Vị trí số 4) Director, Place 5 Director, puesto 5 (Giám đốc, Vị trí số 5) A copy of this order will be posted on Election Day at each polling place that would have been used in the election. El día de las elecciones se exhibirá una copia de esta orden en todas las mesas electorales que se hubieran utilizados en la elección. Một bản sao của lệnh này được niêm yết vào Ngày Bầu cử tại mỗi địa điểm bỏ phiếu mà lẽ ra đã được sử dụng trong cuộc bầu cử. __________________________ Kevin R. Carr President, Board of Directors Presidente, Mesa Directiva ___________________________ Chủ tịch, Ban Giám đốc William C. Rose Secretary, Board of Directors Secretario, Mesa Directiva Thư ký, Ban Giám đốc (SEAL) Date of adoption March 20, 2018, Fecha de aprobación el 20 de marzo 2018, (Ngày thông qua) 20 tháng Ba 2018 Trophy Club Municipal Utility District No. 1 29 of 130 March 20, 2018 Agenda Packet AMENDED** TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET FEBRUARY 2018 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 861,313 PREPAID EXPENSES 8,889 ADVALOREM PROPERTY TAXES RECEIVABLE 54,869 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE - TOTAL ASSETS 925,070 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 54,869 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 54,869 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 522,253 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 347,950 TOTAL FUND BALANCE 870,202 TOTAL LIABILITIES AND FUND BALANCE 925,070 Trophy Club Municipal Utility District No. 1 30 of 130 March 20, 2018 Agenda Packet AMENDED** . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 1 22:56 03/15/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 2/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40010-000-000 Property Taxes/MUD Fire 1,054,433.00- 1,054,433.00- 63,644.94- 1,031,746.08- 97.848 22,686.92- 122-40011-000-000 Property Taxes/Fire-Delinquent 45.76- 2,874.28- 2,874.28 122-40020-000-000 Property Taxes/Fire P&I 541.57- 2,404.11- 2,404.11 Subtotal: 1,054,433.00- 1,054,433.00- 64,232.27- 1,037,024.47- 98.349 17,408.53- Program number: 1,054,433.00- 1,054,433.00- 64,232.27- 1,037,024.47- 98.349 17,408.53- Department number: Fire Revenues 1,054,433.00- 1,054,433.00- 64,232.27- 1,037,024.47- 98.349 17,408.53- Revenues Subtotal ----------- 1,054,433.00- 1,054,433.00- 64,232.27- 1,037,024.47- 98.349 17,408.53- Trophy Club Municipal Utility District No. 1 31 of 130 March 20, 2018 Agenda Packet AMENDED** . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 2 22:56 03/15/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-55080-045-000 Maintenance & Repairs 1,490.49 1,490.49- Subtotal: 1,490.49 1,490.49- 122-60030-045-000 Rent And/Or Usage 218,954.00 218,954.00 218,954.00 218,954.00 100.000 122-60055-045-000 Insurance 18,000.00 18,000.00 1,269.87 6,349.35 35.274 11,650.65 122-60337-045-000 Transfer to Town/Fire Budget 608,910.00 608,910.00 50,742.50 253,712.50 41.667 355,197.50 Subtotal: 845,864.00 845,864.00 270,966.37 479,015.85 56.630 366,848.15 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 81,420.00 81,420.00 100.000 122-69305-045-000 Capital Leases 127,149.00 127,149.00 127,148.60 100.000 .40 Subtotal: 208,569.00 208,569.00 208,568.60 100.000 .40 Program number: 1,054,433.00 1,054,433.00 270,966.37 689,074.94 65.350 365,358.06 Department number: Fire 1,054,433.00 1,054,433.00 270,966.37 689,074.94 65.350 365,358.06 Expenditures Subtotal ----------- 1,054,433.00 1,054,433.00 270,966.37 689,074.94 65.350 365,358.06 Fund number: 122 Trophy Club MUD Fire Dept. 206,734.10 347,949.53- 347,949.53 Trophy Club Municipal Utility District No. 1 32 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 1 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40010-000-000 Property Taxes/MUD Fire 939 02/01/2018 Property Taxes (968,101.14) (9,199.60) (977,300.74) GL 940 02/02/2018 Property Taxes (25,707.44) (1,003,008.18) GL 941 02/05/2018 Property Taxes (7,357.75) (1,010,365.93) GL 942 02/06/2018 Property Taxes (4,200.85) (1,014,566.78) GL 943 02/07/2018 Property Taxes (11,559.45) (1,026,126.23) GL 944 02/09/2018 Property Taxes (415.91) (1,026,542.14) GL 945 02/13/2018 Property Taxes (202.41) (1,026,744.55) GL 946 02/14/2018 Property Taxes (408.76) (1,027,153.31) GL 947 02/16/2018 Property Taxes (456.91) (1,027,610.22) GL 948 02/20/2018 Property Taxes (1,118.34) (1,028,728.56) GL 949 02/21/2018 Property Taxes (21.01) (1,028,749.57) GL 950 02/22/2018 Property Taxes (24.02) (1,028,773.59) GL 951 02/23/2018 Property Taxes (10.09) (1,028,783.68) GL 952 02/26/2018 Property Taxes (1,533.59) (1,030,317.27) GL 953 02/27/2018 Property Taxes (496.86) (1,030,814.13) GL 954 02/28/2018 Property Taxes (931.95) (1,031,746.08) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (63,644.94) (1,031,746.08) ** (1,054,433.00) Budgeted (22,686.92) Remaining 98 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 939 02/01/2018 Property Taxes (2,828.52) (7.09) (2,835.61) GL 940 02/02/2018 Property Taxes (.25) (2,835.86) GL 945 02/13/2018 Property Taxes (29.04) (2,864.90) GL 946 02/14/2018 Property Taxes (9.38) (2,874.28) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (45.76) (2,874.28) ** .00 Budgeted 2,874.28 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 939 02/01/2018 Property Taxes (1,862.54) (20.30) (1,882.84) GL 940 02/02/2018 Property Taxes (2.80) (1,885.64) GL 942 02/06/2018 Property Taxes (51.24) (1,936.88) GL 943 02/07/2018 Property Taxes (37.95) (1,974.83) GL 944 02/09/2018 Property Taxes (21.73) (1,996.56) GL 945 02/13/2018 Property Taxes (21.44) (2,018.00) GL 946 02/14/2018 Property Taxes (30.49) (2,048.49) GL 947 02/16/2018 Property Taxes (41.37) (2,089.86) GL 948 02/20/2018 Property Taxes (78.30) (2,168.16) GL 949 02/21/2018 Property Taxes (1.48) (2,169.64) GL Trophy Club Municipal Utility District No. 1 33 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 2 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 951 02/23/2018 Property Taxes (1,862.54) (1.17) (2,170.81) GL 952 02/26/2018 Property Taxes (107.37) (2,278.18) GL 953 02/27/2018 Property Taxes (34.77) (2,312.95) GL 954 02/28/2018 Property Taxes (91.16) (2,404.11) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (541.57) (2,404.11) ** .00 Budgeted 2,404.11 Remaining 0 % Used Department Totals: ----------------------------------- (1,037,024.47) ** (64,232.27) Monthly Total (1,054,433.00) Budgeted (17,408.53) Remaining 98 % Used Trophy Club Municipal Utility District No. 1 34 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 3 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-55080-045-000 Maintenance & Repairs 1,490.49 .00 1,490.49 _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: .00 1,490.49 ** .00 Budgeted (1,490.49) Remaining 0 % Used Account: 122-60030-045-000 Rent And/Or Usage 962 02/28/2018 Texpool Transfers Feb 218,954.00 218,954.00 GL _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: 218,954.00 218,954.00 ** 218,954.00 Budgeted .00 Remaining 100 % Used Account: 122-60055-045-000 Insurance 236 02/01/2018 Insurance/Wrk Comp Exp Feb 5,079.48 1,269.87 6,349.35 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,269.87 6,349.35 ** 18,000.00 Budgeted 11,650.65 Remaining 35 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 753 02/07/2018 February A/P Feb fire admin 202,970.00 50,742.50 253,712.50 TOWN OF TROPHY CLUB 3912 AP _______________ Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 50,742.50 253,712.50 ** 608,910.00 Budgeted 355,197.50 Remaining 42 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 .00 81,420.00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 81,420.00 ** 81,420.00 Budgeted .00 Remaining 100 % Used Account: 122-69305-045-000 Capital Leases 127,148.60 .00 127,148.60 _______________ Account: 122-69305-045-000 Capital Leases Totals: .00 127,148.60 ** 127,149.00 Budgeted .40 Remaining 100 % Used Department 45 Totals: ----------------------------------- 689,074.94 ** 270,966.37 Monthly Total 1,054,433.00 Budgeted 365,358.06 Remaining 65 % Used Trophy Club Municipal Utility District No. 1 35 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Fund 122 Totals: ----------------------------------- (347,949.53) 206,734.10 Monthly Total .00 Budgeted 347,949.53 Remaining 0 % Used Trophy Club Municipal Utility District No. 1 36 of 130 March 20, 2018 Agenda Packet AMENDED** TROPHY CLUB MUD #1 - O&M BALANCE SHEET FEBRUARY 2018 GTBGT 135 137 GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 - 600 CASH IN BANK-CHECKING 1,491,449 - 1,491,449 CASH IN BANK-SAVINGS-CASH RESERVE 781,493 - 781,493 CD-BANK OF THE WEST/THB DEPOSIT 35,316 - 35,316 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 714,630 - 714,630 INVESTMENTS-TEXPOOL 1,148,492 596,426 1,744,918 PREPAID EXPENSES 62,805 - 62,805 ADVALOREM PROPERTY TAXES RECEIVABLE 6,215 - 6,215 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,037,777 - 1,037,777 TOTAL ASSETS 5,278,778 596,426 5,875,204 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 6,215 - 6,215 ACCOUNTS AND OTHER PAYABLES 407,210 - 407,210 CUSTOMER DEPOSITS 313,815 - 313,815 - TOTAL LIABILITIES 727,240 - 727,240 FUND BALANCE NON-SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 1,778,760 1,778,760 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 180,000 180,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT 120,000 120,000 ASSIGNED FUND BALANCE/SEWER REPLACEMENT 67,805 67,805 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 228,621 228,621 UNASSIGNED FUND BALANCE 2,368,122 - 2,368,122 COMMITTED FUND BALANCE - - - NET REVENUES / EXPENDITURES 401,170 - 401,170 - TOTAL FUND BALANCE 4,551,538 596,426 5,147,964 TOTAL LIABILITIES AND FUND BALANCE 5,278,778 596,426 5,875,204 Trophy Club Municipal Utility District No. 1 37 of 130 March 20, 2018 Agenda Packet AMENDED** . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 3 22:56 03/15/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 120,950.00- 120,950.00- 7,300.22- 118,343.00- 97.845 2,607.00- 135-40002-000-000 Property Taxes/Delinquent 200.00- 200.00- 3.63- 188.93- 94.465 11.07- 135-40015-000-000 Property Taxes/P & I 200.00- 200.00- 61.82- 254.47- 127.235 54.47 135-40025-000-000 PID Surcharges 177,839.00- 177,839.00- 177,839.00- Subtotal: 299,189.00- 299,189.00- 7,365.67- 118,786.40- 39.703 180,402.60- 135-47000-000-000 Water 6,464,019.00- 6,464,019.00- 318,712.58- 1,894,035.59- 29.301 4,569,983.41- 135-47005-000-000 Sewer 2,978,067.00- 2,978,067.00- 241,762.68- 1,185,209.86- 39.798 1,792,857.14- 135-47025-000-000 Penalties 106,279.00- 106,279.00- 7,246.79- 51,257.82- 48.229 55,021.18- 135-47030-000-000 Service Charges 21,350.00- 21,350.00- 1,100.00- 5,975.00- 27.986 15,375.00- 135-47035-000-000 Plumbing Inspections 1,500.00- 1,500.00- 250.00- 1,400.00- 93.333 100.00- 135-47045-000-000 Sewer Inspections 4,500.00- 4,500.00- 750.00- 3,400.00- 75.556 1,100.00- 135-47070-000-000 TCCC Effluent Charges 60,000.00- 60,000.00- 357.60- 9,476.00- 15.793 50,524.00- Subtotal: 9,635,715.00- 9,635,715.00- 570,179.65- 3,150,754.27- 32.699 6,484,960.73- 135-49010-000-000 Interest Income 12,000.00- 12,000.00- 3,635.37- 15,887.03- 132.392 3,887.03 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 978.81- 4,825.77- 44.168 6,100.23- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 2,916.65- 41.666 4,083.35- 135-49026-000-000 Proceeds from Sale of Assets 2,000.00- 2,000.00- 2,000.00- 135-49075-000-000 Oversize Meter Reimbursement 18,179.00- 18,179.00- 1,715.00- 8,748.76- 48.126 9,430.24- 135-49900-000-000 Miscellaneous Income 5,000.00- 5,000.00- 237.88- 5,853.45- 117.069 853.45 135-49901-000-000 Records Management Revenue 20.00- 20.00- 20.00- 135-49910-000-000 Reimbursement/Revenue Bond 260,000.00- 260,000.00- 260,000.00- Subtotal: 315,125.00- 315,125.00- 7,150.39- 38,231.66- 12.132 276,893.34- Program number: 10,250,029.00- 10,250,029.00- 584,695.71- 3,307,772.33- 32.271 6,942,256.67- Department number: Revenues 10,250,029.00- 10,250,029.00- 584,695.71- 3,307,772.33- 32.271 6,942,256.67- Revenues Subtotal ----------- 10,250,029.00- 10,250,029.00- 584,695.71- 3,307,772.33- 32.271 6,942,256.67- Trophy Club Municipal Utility District No. 1 38 of 130 March 20, 2018 Agenda Packet AMENDED** . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 4 22:56 03/15/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 274,279.00 274,279.00 17,803.19 81,990.64 29.893 192,288.36 135-50010-010-000 Overtime 20,000.00 20,000.00 477.08 3,218.16 16.091 16,781.84 135-50016-010-000 Longevity 3,425.00 3,425.00 3,310.00 96.642 115.00 135-50017-010-000 Certification 3,300.00 3,300.00 175.00 900.00 27.273 2,400.00 135-50020-010-000 Retirement 27,843.00 27,843.00 1,707.10 9,681.19 34.771 18,161.81 135-50026-010-000 Medical Insurance 52,196.00 52,196.00 2,948.80 12,158.23 23.293 40,037.77 135-50027-010-000 Dental Insurance 5,182.00 5,182.00 207.16 1,093.74 21.107 4,088.26 135-50028-010-000 Vision Insurance 994.00 994.00 35.92 208.39 20.965 785.61 135-50029-010-000 Life Insurance & Other 2,982.00 2,982.00 181.15 1,026.00 34.406 1,956.00 135-50030-010-000 Social Security Taxes 18,662.00 18,662.00 1,126.64 5,507.77 29.513 13,154.23 135-50035-010-000 Medicare Taxes 4,365.00 4,365.00 263.48 1,288.09 29.510 3,076.91 135-50040-010-000 Unemployment Taxes 1,080.00 1,080.00 15.04 41.08 3.804 1,038.92 135-50045-010-000 Workman's Compensation 11,854.00 11,854.00 899.92 4,499.60 37.958 7,354.40 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 226.05 113.025 26.05- 135-50070-010-000 Employee Relations 300.00 300.00 18.99 6.330 281.01 Subtotal: 426,662.00 426,662.00 25,840.48 125,167.93 29.337 301,494.07 135-55005-010-000 Engineering 275,000.00 275,000.00 275,000.00 135-55080-010-000 Maintenance & Repairs 100,000.00 100,000.00 1,676.17 32,879.48 32.879 67,120.52 135-55085-010-000 Generator Maint. and Repair 3,000.00 3,000.00 3,000.00 135-55090-010-000 Vehicle Maintenance 4,000.00 4,000.00 239.73 2,817.39 70.435 1,182.61 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 3,500.00 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 2,093.44 38.063 3,406.56 Subtotal: 391,000.00 391,000.00 1,915.90 37,790.31 9.665 353,209.69 135-60010-010-000 Communications/Mobiles 4,700.00 4,700.00 370.64 1,381.62 29.396 3,318.38 135-60020-010-000 Electricity 175,356.00 175,356.00 8,182.14 56,280.14 32.095 119,075.86 135-60066-010-000 Publications/Books/Subscripts 1,000.00 1,000.00 1,000.00 135-60070-010-000 Dues & Memberships 500.00 500.00 500.00 135-60080-010-000 Schools & Training 2,785.00 2,785.00 739.78 974.78 35.001 1,810.22 135-60090-010-000 Safety Program 400.00 400.00 8.36 2.090 391.64 135-60100-010-000 Travel & per diem 1,735.00 1,735.00 87.48 5.042 1,647.52 135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 1,500.00 135-60135-010-000 TCEQ Fees & Permits 55,176.00 55,176.00 5,122.40 12,808.05 23.213 42,367.95 135-60150-010-000 Wholesale Water 2,823,170.00 2,823,170.00 107,996.70 613,489.41 21.731 2,209,680.59 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,000.00 3,000.00 322.70 10.757 2,677.30 135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 2,250.00 15.254 12,500.00 135-60332-010-000 Interfund Transfer Out-Rev I&S 278,084.00 278,084.00 25,280.31 126,401.55 45.454 151,682.45 135-60333-010-000 Interfund Transfer Out-Reserve 48,996.00 48,996.00 4,083.00 20,415.00 41.667 28,581.00 135-60334-010-000 Interfund Transfer Out 200,000.00 200,000.00 200,000.00 135-60360-010-000 Furniture/Equipment < $5000 2,500.00 2,500.00 5,019.66 200.786 2,519.66- Trophy Club Municipal Utility District No. 1 39 of 130 March 20, 2018 Agenda Packet AMENDED** . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 5 22:56 03/15/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 3,613,852.00 3,613,852.00 151,774.97 839,438.75 23.228 2,774,413.25 135-65005-010-000 Fuel & Lube 15,000.00 15,000.00 949.94 3,933.52 26.223 11,066.48 135-65010-010-000 Uniforms 4,488.00 4,488.00 160.93 990.57 22.072 3,497.43 135-65030-010-000 Chemicals 20,000.00 20,000.00 2,243.01 6,641.39 33.207 13,358.61 135-65035-010-000 Small Tools 1,200.00 1,200.00 1,200.00 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 1,000.00 135-65050-010-000 Meter Expense 50,000.00 50,000.00 12,400.00 24.800 37,600.00 135-65053-010-000 Meter Change Out Program 84,000.00 84,000.00 48,900.00 58.214 35,100.00 Subtotal: 175,688.00 175,688.00 3,353.88 72,865.48 41.474 102,822.52 135-69005-010-000 Capital Outlays 810,012.00 810,012.00 103,551.95 223,608.22 27.606 586,403.78 135-69008-010-000 Short Term Debt-Principal 38,731.00 38,731.00 38,731.00 135-69009-010-000 Short Term Debt-Interest 5,713.00 5,713.00 5,713.00 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 75,000.00 75,000.00 100.000 135-69281-010-000 Water Tank Inspection Contract 118,775.00 118,775.00 107,864.38 90.814 10,910.62 Subtotal: 1,048,231.00 1,048,231.00 103,551.95 406,472.60 38.777 641,758.40 Program number: 5,655,433.00 5,655,433.00 286,437.18 1,481,735.07 26.200 4,173,697.93 Trophy Club Municipal Utility District No. 1 40 of 130 March 20, 2018 Agenda Packet AMENDED** . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 6 22:56 03/15/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 2/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis for PID 2,000.00 2,000.00 743.89 37.195 1,256.11 Subtotal: 2,000.00 2,000.00 743.89 37.195 1,256.11 Program number: 1 Lab Analysis for PID 2,000.00 2,000.00 743.89 37.195 1,256.11 Department number: Water 5,657,433.00 5,657,433.00 286,437.18 1,482,478.96 26.204 4,174,954.04 Trophy Club Municipal Utility District No. 1 41 of 130 March 20, 2018 Agenda Packet AMENDED** . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7 22:56 03/15/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 410,866.00 410,866.00 30,650.18 153,412.58 37.339 257,453.42 135-50010-020-000 Overtime 30,000.00 30,000.00 2,256.32 12,387.08 41.290 17,612.92 135-50016-020-000 Longevity 7,415.00 7,415.00 7,415.00 100.000 135-50017-020-000 Certification 8,400.00 8,400.00 811.00 3,536.00 42.095 4,864.00 135-50020-020-000 Retirement 42,243.00 42,243.00 3,108.60 17,803.63 42.146 24,439.37 135-50026-020-000 Medical Insurance 62,175.00 62,175.00 6,108.45 26,347.50 42.376 35,827.50 135-50027-020-000 Dental Insurance 5,271.00 5,271.00 375.10 1,948.16 36.960 3,322.84 135-50028-020-000 Vision Insurance 1,114.00 1,114.00 65.49 383.97 34.468 730.03 135-50029-020-000 Life Insurance & Other 4,281.00 4,281.00 376.07 1,960.19 45.788 2,320.81 135-50030-020-000 Social Security Taxes 28,314.00 28,314.00 1,909.15 10,278.21 36.301 18,035.79 135-50035-020-000 Medicare Taxes 6,622.00 6,622.00 446.49 2,403.77 36.300 4,218.23 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 26.08 60.88 4.832 1,199.12 135-50045-020-000 Workman's Compensation 17,990.00 17,990.00 1,348.00 6,740.00 37.465 11,250.00 135-50060-020-000 Pre-emp Physicals/Testing 300.00 300.00 300.00 135-50070-020-000 Employee Relations 350.00 350.00 350.00 Subtotal: 626,601.00 626,601.00 47,480.93 244,676.97 39.048 381,924.03 135-55070-020-000 Independent Labor 20,550.00 20,550.00 1,069.50 5.204 19,480.50 135-55080-020-000 Maintenance & Repairs 86,100.00 86,100.00 154.34 19,177.69 22.274 66,922.31 135-55085-020-000 Generator Maint. and Repair 14,000.00 14,000.00 28.78 .206 13,971.22 135-55090-020-000 Vehicle Maintenance 8,000.00 8,000.00 274.53 3,406.41 42.580 4,593.59 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 289.69 57.938 210.31 135-55125-020-000 Dumpster Services 60,000.00 60,000.00 4,173.87 35,703.37 59.506 24,296.63 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 1,934.00 16,462.82 54.876 13,537.18 Subtotal: 219,150.00 219,150.00 6,536.74 76,138.26 34.743 143,011.74 135-60010-020-000 Communications/Mobiles 4,700.00 4,700.00 490.34 2,102.05 44.724 2,597.95 135-60020-020-000 Electricity 266,709.00 266,709.00 13,404.70 73,158.80 27.430 193,550.20 135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 200.00 135-60070-020-000 Dues & Memberships 300.00 300.00 300.00 135-60080-020-000 Schools & Training 5,677.00 5,677.00 5,677.00 135-60090-020-000 Safety Program 550.00 550.00 8.37 1.522 541.63 135-60100-020-000 Travel & per diem 1,635.00 1,635.00 73.06 4.469 1,561.94 135-60105-020-000 Rent/Lease Equipment 5,000.00 5,000.00 5,000.00 135-60125-020-000 Advertising 5,000.00 5,000.00 5,000.00 135-60135-020-000 TCEQ Fees & Permits 85,000.00 85,000.00 30,272.52 35.615 54,727.48 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 .01 .01 .002 449.99 135-60280-020-000 Property Maintenance 4,000.00 4,000.00 4,000.00 135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 1,770.00 15.259 9,830.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 122,043.00 122,043.00 11,094.81 55,474.05 45.455 66,568.95 135-60332-020-000 Interfund Transfer Out-Rev I&S 598,738.00 598,738.00 54,430.72 272,153.60 45.455 326,584.40 135-60333-020-000 Interfund Transfer Out-Reserve 123,336.00 123,336.00 10,278.00 51,390.00 41.667 71,946.00 Trophy Club Municipal Utility District No. 1 42 of 130 March 20, 2018 Agenda Packet AMENDED** . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 8 22:56 03/15/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60334-020-000 Interfund Transfer Out 200,000.00 200,000.00 200,000.00 135-60360-020-000 Furniture/Equipment < $5000 4,000.00 4,000.00 4,000.00 Subtotal: 1,438,938.00 1,438,938.00 89,698.58 486,402.46 33.803 952,535.54 135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 743.43 3,731.07 29.849 8,768.93 135-65010-020-000 Uniforms 4,459.00 4,459.00 159.96 1,774.59 39.798 2,684.41 135-65030-020-000 Chemicals 27,500.00 27,500.00 3,892.03 14.153 23,607.97 135-65035-020-000 Small Tools 1,000.00 1,000.00 34.99 1,118.21 111.821 118.21- 135-65040-020-000 Safety Equipment 750.00 750.00 260.00 260.00 34.667 490.00 135-65045-020-000 Lab Supplies 14,000.00 14,000.00 953.09 5,671.38 40.510 8,328.62 Subtotal: 60,209.00 60,209.00 2,151.47 16,447.28 27.317 43,761.72 135-69005-020-000 Capital Outlays 547,327.00 547,327.00 1,657.50 15,054.43 2.751 532,272.57 135-69008-020-000 Short Term Debt-Principal 51,342.00 51,342.00 51,342.00 135-69009-020-000 Short Term Debt-Interest 7,573.00 7,573.00 7,573.00 135-69195-020-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 30,000.00 100.000 Subtotal: 636,242.00 636,242.00 1,657.50 45,054.43 7.081 591,187.57 Program number: 2,981,140.00 2,981,140.00 147,525.22 868,719.40 29.141 2,112,420.60 Department number: Wastewater 2,981,140.00 2,981,140.00 147,525.22 868,719.40 29.141 2,112,420.60 Trophy Club Municipal Utility District No. 1 43 of 130 March 20, 2018 Agenda Packet AMENDED** . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 9 22:56 03/15/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 2/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50045-026-000 Workman's Compensation 30.00 30.00 2.42 12.10 40.333 17.90 Subtotal: 30.00 30.00 2.42 12.10 40.333 17.90 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 600.00 600.00 650.00 108.333 50.00- 135-60075-026-000 Meetings 1,200.00 1,200.00 1,200.00 135-60080-026-000 Schools & Training 4,000.00 4,000.00 1,135.00 28.375 2,865.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 670.02 960.00 19.200 4,040.00 135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 1,021.73 51.087 978.27 Subtotal: 12,950.00 12,950.00 670.02 3,766.73 29.087 9,183.27 Program number: 12,980.00 12,980.00 672.44 3,778.83 29.113 9,201.17 Department number: Board of Directors 12,980.00 12,980.00 672.44 3,778.83 29.113 9,201.17 Trophy Club Municipal Utility District No. 1 44 of 130 March 20, 2018 Agenda Packet AMENDED** . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 10 22:56 03/15/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 432,863.00 432,863.00 25,071.76 155,434.79 35.909 277,428.21 135-50010-030-000 Overtime 2,000.00 2,000.00 19.18 410.65 20.533 1,589.35 135-50016-030-000 Longevity 3,548.00 3,548.00 3,547.50 99.986 .50 135-50020-030-000 Retirement 40,553.00 40,553.00 2,320.91 17,050.78 42.046 23,502.22 135-50026-030-000 Medical Insurance 63,485.00 63,485.00 4,145.24 19,047.97 30.004 44,437.03 135-50027-030-000 Dental Insurance 5,502.00 5,502.00 251.50 1,493.40 27.143 4,008.60 135-50028-030-000 Vision Insurance 1,173.00 1,173.00 42.51 298.90 25.482 874.10 135-50029-030-000 Life Insurance & Other 5,059.00 5,059.00 282.27 1,703.90 33.681 3,355.10 135-50030-030-000 Social Security Taxes 27,181.00 27,181.00 1,477.33 9,501.76 34.957 17,679.24 135-50035-030-000 Medicare Taxes 6,357.00 6,357.00 345.49 2,222.16 34.956 4,134.84 135-50040-030-000 Unemployment Taxes 1,260.00 1,260.00 17.72 54.70 4.341 1,205.30 135-50045-030-000 Workman's Compensation 1,529.00 1,529.00 123.50 617.50 40.386 911.50 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 124.95 24.990 375.05 135-50070-030-000 Employee Relations 4,960.00 4,960.00 49.61- 2,320.79 46.790 2,639.21 Subtotal: 595,970.00 595,970.00 34,047.80 213,829.75 35.879 382,140.25 135-55030-030-000 Software & Support 78,391.00 78,391.00 3,249.19 43,128.59 55.017 35,262.41 135-55070-030-000 Independent Labor 154,000.00 154,000.00 13,028.85 63,070.84 40.955 90,929.16 135-55080-030-000 Maintenance & Repairs 14,000.00 14,000.00 985.00 2,281.50 16.296 11,718.50 135-55085-030-000 Generator Maint. and Repair 10,000.00 10,000.00 10,000.00 135-55120-030-000 Cleaning Services 10,000.00 10,000.00 1,065.38 3,093.33 30.933 6,906.67 135-55160-030-000 Professional Outside Services 63,325.00 63,325.00 56,475.00 89.183 6,850.00 135-55165-030-000 Collection Fees 200.00 200.00 200.00 135-55205-030-000 Utility Billing Contract 9,000.00 9,000.00 581.61 2,974.25 33.047 6,025.75 Subtotal: 338,916.00 338,916.00 18,910.03 171,023.51 50.462 167,892.49 135-60005-030-000 Telephone 27,300.00 27,300.00 1,654.42 7,388.97 27.066 19,911.03 135-60010-030-000 Communications/Mobiles 4,000.00 4,000.00 237.44 1,324.62 33.116 2,675.38 135-60020-030-000 Electricity/Gas 16,261.00 16,261.00 1,697.60 10.440 14,563.40 135-60025-030-000 Water 2,500.00 2,500.00 58.10 285.76 11.430 2,214.24 135-60030-030-000 Rent And/Or Usage 616.40 616.40- 135-60035-030-000 Postage 30,000.00 30,000.00 1,627.44 9,651.64 32.172 20,348.36 135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 4,264.65 25,547.54 45.982 30,012.46 135-60050-030-000 Bad Debt Expense 1,500.00 1,500.00 1,500.00 135-60055-030-000 Insurance 56,000.00 56,000.00 9,325.36 33,726.80 60.226 22,273.20 135-60066-030-000 Publications/Books/Subscripts 1,600.00 1,600.00 1,600.00 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 107.17 3,808.42 63.474 2,191.58 135-60075-030-000 Meetings 400.00 400.00 48.62 12.155 351.38 135-60079-030-000 Public Education 6,000.00 6,000.00 6,000.00 135-60080-030-000 Schools & Training 7,600.00 7,600.00 85.00 2,693.00 35.434 4,907.00 135-60100-030-000 Travel & per diem 4,885.00 4,885.00 112.33 582.17 11.918 4,302.83 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 Trophy Club Municipal Utility District No. 1 45 of 130 March 20, 2018 Agenda Packet AMENDED** . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 11 22:56 03/15/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60115-030-000 Elections 4,500.00 4,500.00 145.00 3.222 4,355.00 135-60125-030-000 Advertising 2,500.00 2,500.00 2,500.00 135-60235-030-000 Security 2,700.00 2,700.00 24.00 48.00 1.778 2,652.00 135-60245-030-000 Miscellaneous Expenses 500.00 500.00 124.50 124.50 24.900 375.50 135-60246-030-000 General Manager Contingency 17,000.00 17,000.00 17,000.00 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 211.99 8.480 2,288.01 Subtotal: 249,506.00 249,506.00 17,620.41 87,901.03 35.230 161,604.97 135-65010-030-000 Uniforms 700.00 700.00 700.00 135-65055-030-000 Hardware 7,420.00 7,420.00 597.95 8.059 6,822.05 135-65085-030-000 Office Supplies 7,000.00 7,000.00 137.14 2,612.69 37.324 4,387.31 135-65090-030-000 Printer Supplies & Maintenance 2,000.00 2,000.00 1,903.05 95.153 96.95 135-65095-030-000 Maintenance Supplies 4,000.00 4,000.00 332.37 2,061.86 51.547 1,938.14 135-65105-030-000 Printing 4,000.00 4,000.00 144.00 3.600 3,856.00 Subtotal: 25,120.00 25,120.00 469.51 7,319.55 29.138 17,800.45 135-69005-030-000 Capital Outlays 13,000.00 13,000.00 7,841.00 60.315 5,159.00 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 257.79 1,229.02 26.718 3,370.98 Subtotal: 17,600.00 17,600.00 257.79 9,070.02 51.534 8,529.98 Program number: 1,227,112.00 1,227,112.00 71,305.54 489,143.86 39.861 737,968.14 Department number: Administration 1,227,112.00 1,227,112.00 71,305.54 489,143.86 39.861 737,968.14 Trophy Club Municipal Utility District No. 1 46 of 130 March 20, 2018 Agenda Packet AMENDED** . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 12 22:56 03/15/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 2/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 137,000.00 137,000.00 29,343.55 21.419 107,656.45 135-55055-039-000 Auditing 24,500.00 24,500.00 25,508.70 104.117 1,008.70- 135-55060-039-000 Appraisal 11,446.00 11,446.00 4,660.18 40.714 6,785.82 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,968.40 78.116 831.60 Subtotal: 176,746.00 176,746.00 62,480.83 35.351 114,265.17 Program number: 176,746.00 176,746.00 62,480.83 35.351 114,265.17 Department number: Non Departmental 176,746.00 176,746.00 62,480.83 35.351 114,265.17 Expenditures Subtotal ----------- 10,055,411.00 10,055,411.00 505,940.38 2,906,601.88 28.906 7,148,809.12 Fund number: 135 MUD 1 General Fund 194,618.00- 194,618.00- 78,755.33- 401,170.45- 206.132 206,552.45 Trophy Club Municipal Utility District No. 1 47 of 130 March 20, 2018 Agenda Packet AMENDED** . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 13 22:56 03/15/18 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 2/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer-General Fund 105,000.00- 105,000.00 137-49146-000-000 Intergov Transfer-Fire Dept 81,420.00- 81,420.00 Subtotal: 186,420.00- 186,420.00 Program number: 186,420.00- 186,420.00 Department number: 186,420.00- 186,420.00 Revenues Subtotal ----------- 186,420.00- 186,420.00 Fund number: 137 MUD 1 Consolidated GASB 186,420.00- 186,420.00 Trophy Club Municipal Utility District No. 1 48 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 5 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-40000-000-000 Property Taxes 939 02/01/2018 Property Taxes (111,042.78) (1,055.21) (112,097.99) GL 940 02/02/2018 Property Taxes (2,948.69) (115,046.68) GL 941 02/05/2018 Property Taxes (843.95) (115,890.63) GL 942 02/06/2018 Property Taxes (481.84) (116,372.47) GL 943 02/07/2018 Property Taxes (1,325.89) (117,698.36) GL 944 02/09/2018 Property Taxes (47.71) (117,746.07) GL 945 02/13/2018 Property Taxes (23.22) (117,769.29) GL 946 02/14/2018 Property Taxes (46.89) (117,816.18) GL 947 02/16/2018 Property Taxes (52.41) (117,868.59) GL 948 02/20/2018 Property Taxes (128.28) (117,996.87) GL 949 02/21/2018 Property Taxes (2.41) (117,999.28) GL 950 02/22/2018 Property Taxes (2.76) (118,002.04) GL 951 02/23/2018 Property Taxes (1.16) (118,003.20) GL 952 02/26/2018 Property Taxes (175.91) (118,179.11) GL 953 02/27/2018 Property Taxes (56.99) (118,236.10) GL 954 02/28/2018 Property Taxes (106.90) (118,343.00) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (7,300.22) (118,343.00) ** (120,950.00) Budgeted (2,607.00) Remaining 98 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 939 02/01/2018 Property Taxes (185.30) (1.36) (186.66) GL 940 02/02/2018 Property Taxes (.01) (186.67) GL 945 02/13/2018 Property Taxes (1.71) (188.38) GL 946 02/14/2018 Property Taxes (.55) (188.93) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (3.63) (188.93) ** (200.00) Budgeted (11.07) Remaining 94 % Used Account: 135-40015-000-000 Property Taxes/P & I 939 02/01/2018 Property Taxes (192.65) (2.57) (195.22) GL 940 02/02/2018 Property Taxes (.32) (195.54) GL 942 02/06/2018 Property Taxes (5.88) (201.42) GL 943 02/07/2018 Property Taxes (4.35) (205.77) GL 944 02/09/2018 Property Taxes (2.49) (208.26) GL 945 02/13/2018 Property Taxes (2.05) (210.31) GL 946 02/14/2018 Property Taxes (3.39) (213.70) GL 947 02/16/2018 Property Taxes (4.74) (218.44) GL 948 02/20/2018 Property Taxes (8.98) (227.42) GL 949 02/21/2018 Property Taxes (.17) (227.59) GL Trophy Club Municipal Utility District No. 1 49 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 6 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 951 02/23/2018 Property Taxes (192.65) (.13) (227.72) GL 952 02/26/2018 Property Taxes (12.31) (240.03) GL 953 02/27/2018 Property Taxes (3.99) (244.02) GL 954 02/28/2018 Property Taxes (10.45) (254.47) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (61.82) (254.47) ** (200.00) Budgeted 54.47 Remaining 127 % Used Account: 135-40025-000-000 PID Surcharges .00 .00 _______________ Account: 135-40025-000-000 PID Surcharges Totals: .00 .00 ** (177,839.00) Budgeted (177,839.00) Remaining 0 % Used Account: 135-47000-000-000 Water 2507 02/07/2018 Adj-2224 TC drive UB20180207-20180207 User: (1,575,323.01) 25.84 (1,575,297.17) UB 890 02/28/2018 UB 02/28/2018 Billing UB20180228-20180228 User: (318,738.42) (1,894,035.59) UB _______________ Account: 135-47000-000-000 Water Totals: (318,712.58) (1,894,035.59) ** (6,464,019.00) Budgeted (4,569,983.41) Remaining 29 % Used Account: 135-47005-000-000 Sewer 2507 02/07/2018 Adj-2224 TC drive UB20180207-20180207 User: (943,447.18) 95.43 (943,351.75) UB 890 02/28/2018 UB 02/28/2018 Billing UB20180228-20180228 User: (241,858.11) (1,185,209.86) UB _______________ Account: 135-47005-000-000 Sewer Totals: (241,762.68) (1,185,209.86) ** (2,978,067.00) Budgeted (1,792,857.14) Remaining 40 % Used Account: 135-47025-000-000 Penalties 820 02/14/2018 UB 02/14/2018 Penalties UB20180214-20180214 User: (44,011.03) 14.69 (43,996.34) UB 834 02/19/2018 UB 02/19/2018 Penalties UB20180219-20180219 User: 155.17 (43,841.17) UB 853 02/21/2018 UB February Assess Penalties UB20180221-20180221 User: (7,824.93) (51,666.10) UB 871 02/26/2018 UB 02/26/2018 Penalties UB20180226-20180226 User: 99.70 (51,566.40) UB 876 02/27/2018 UB 02/27/2018 Penalties UB20180227-20180227 User: 37.01 (51,529.39) UB 877 02/27/2018 UB 02/27/2018 Penalties UB20180227-20180227 User: 42.29 (51,487.10) UB 878 02/27/2018 UB 02/27/2018 Penalties UB20180227-20180227 User: 50.03 (51,437.07) UB 879 02/27/2018 UB 02/27/2018 Penalties UB20180227-20180227 User: 160.53 (51,276.54) UB 880 02/27/2018 UB 02/27/2018 Penalties UB20180227-20180227 User: 18.72 (51,257.82) UB Trophy Club Municipal Utility District No. 1 50 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 7 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-47025-000-000 Penalties Totals: (7,246.79) (51,257.82) ** (106,279.00) Budgeted (55,021.18) Remaining 48 % Used Account: 135-47030-000-000 Service Charges 748 02/07/2018 UB 02/07/2018 Disconnect Fees UB20180207-20180207 User: (4,875.00) (1,100.00) (5,975.00) UB 749 02/07/2018 UB 02/07/2018 Disconnect Fees UB20180207-20180207 User: (1,100.00) (7,075.00) UB 894 02/07/2018 Disconnect fee reversals UB20180207-20180207 User: 1,100.00 (5,975.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,100.00) (5,975.00) ** (21,350.00) Budgeted (15,375.00) Remaining 28 % Used Account: 135-47035-000-000 Plumbing Inspections 883 02/19/2018 permits-521 Asheville & 28 Kat 521 Asheville Lane (1,150.00) (50.00) (1,200.00) Ashton Wood Homes CR 883 02/19/2018 permits-521 Asheville & 28 Kat 28 Katie Lane (50.00) (1,250.00) Drees Custom homes CR 900 02/27/2018 Permits & customer deposits 24 Sadie Court (50.00) (1,300.00) Drees CR 900 02/27/2018 Permits & customer deposits 509 Fisher Drive (50.00) (1,350.00) Ashton Woods CR 901 02/28/2018 Permits-8 Saide Court 8 Sadie Court (50.00) (1,400.00) Drees CR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (250.00) (1,400.00) ** (1,500.00) Budgeted (100.00) Remaining 93 % Used Account: 135-47045-000-000 Sewer Inspections 883 02/19/2018 permits-521 Asheville & 28 Kat 521 Asheville Lane (2,650.00) (150.00) (2,800.00) Ashton Wood Homes CR 883 02/19/2018 permits-521 Asheville & 28 Kat 28 Katie Lane (150.00) (2,950.00) Drees Custom homes CR 900 02/27/2018 Permits & customer deposits 24 Sadie Court (150.00) (3,100.00) Drees CR 900 02/27/2018 Permits & customer deposits 509 Fisher Drive (150.00) (3,250.00) Ashton Woods CR 901 02/28/2018 Permits-8 Saide Court 8 Sadie Court (150.00) (3,400.00) Drees CR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (750.00) (3,400.00) ** (4,500.00) Budgeted (1,100.00) Remaining 76 % Used Account: 135-47070-000-000 TCCC Effluent Charges 890 02/28/2018 UB 02/28/2018 Billing UB20180228-20180228 User: (9,118.40) (357.60) (9,476.00) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (357.60) (9,476.00) ** (60,000.00) Budgeted (50,524.00) Remaining 16 % Used Account: 135-49010-000-000 Interest Income Trophy Club Municipal Utility District No. 1 51 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 8 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 978 02/28/2018 Bank Interest- February (12,251.66) (137.03) (12,388.69) GL 978 02/28/2018 Bank Interest- February (468.88) (12,857.57) GL 978 02/28/2018 Bank Interest- February (3,029.46) (15,887.03) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (3,635.37) (15,887.03) ** (12,000.00) Budgeted 3,887.03 Remaining 132 % Used Account: 135-49016-000-000 Cell Tower Revenue 964 02/16/2018 Cell Tower Rev AT&T Feb (3,846.96) (978.81) (4,825.77) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (978.81) (4,825.77) ** (10,926.00) Budgeted (6,100.23) Remaining 44 % Used Account: 135-49018-000-000 Building Rent Income 991 02/28/2018 Town Billed Invoices 1624-1627 AR 20180228-20180228 User: (2,333.32) (583.33) (2,916.65) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (2,916.65) ** (7,000.00) Budgeted (4,083.35) Remaining 42 % Used Account: 135-49026-000-000 Proceeds from Sale of Assets .00 .00 _______________ Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: .00 .00 ** (2,000.00) Budgeted (2,000.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 883 02/19/2018 permits-521 Asheville & 28 Kat 521 Asheville Lane (7,033.76) (343.00) (7,376.76) Ashton Wood Homes CR 883 02/19/2018 permits-521 Asheville & 28 Kat 28 Katie Lane (343.00) (7,719.76) Drees Custom homes CR 900 02/27/2018 Permits & customer deposits 24 Sadie Court (343.00) (8,062.76) Drees CR 900 02/27/2018 Permits & customer deposits 509 Fisher Drive (343.00) (8,405.76) Ashton Woods CR 901 02/28/2018 Permits-8 Saide Court 8 Sadie Court (343.00) (8,748.76) Drees CR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (1,715.00) (8,748.76) ** (18,179.00) Budgeted (9,430.24) Remaining 48 % Used Account: 135-49900-000-000 Miscellaneous Income 895 02/07/2018 Credit adj UB20180207-20180207 User: (5,615.57) (.73) (5,616.30) UB 890 02/28/2018 UB 02/28/2018 Billing UB20180228-20180228 User: (237.15) (5,853.45) UB Trophy Club Municipal Utility District No. 1 52 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 9 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (237.88) (5,853.45) ** (5,000.00) Budgeted 853.45 Remaining 117 % Used Account: 135-49901-000-000 Records Management Revenue .00 .00 _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 .00 ** (20.00) Budgeted (20.00) Remaining 0 % Used Account: 135-49910-000-000 Reimbursement/Revenue Bond .00 .00 _______________ Account: 135-49910-000-000 Reimbursement/Revenue Bond Totals: .00 .00 ** (260,000.00) Budgeted (260,000.00) Remaining 0 % Used Department Totals: ----------------------------------- (3,307,772.33) ** (584,695.71) Monthly Total (10,250,029.00) Budgeted (6,942,256.67) Remaining 32 % Used Trophy Club Municipal Utility District No. 1 53 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-010-000 Salaries & Wages 742 02/09/2018 MUD PR 02.09.18 Salaries & Wages 64,187.45 8,919.27 73,106.72 PR 843 02/23/2018 MUD PR 02.23.18 Salaries & Wages 8,883.92 81,990.64 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 17,803.19 81,990.64 ** 274,279.00 Budgeted 192,288.36 Remaining 30 % Used Account: 135-50010-010-000 Overtime 742 02/09/2018 MUD PR 02.09.18 Overtime 2,741.08 22.86 2,763.94 PR 843 02/23/2018 MUD PR 02.23.18 Overtime 454.22 3,218.16 PR _______________ Account: 135-50010-010-000 Overtime Totals: 477.08 3,218.16 ** 20,000.00 Budgeted 16,781.84 Remaining 16 % Used Account: 135-50016-010-000 Longevity 3,310.00 .00 3,310.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 3,310.00 ** 3,425.00 Budgeted 115.00 Remaining 97 % Used Account: 135-50017-010-000 Certification 843 02/23/2018 MUD PR 02.23.18 Certification 725.00 175.00 900.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 175.00 900.00 ** 3,300.00 Budgeted 2,400.00 Remaining 27 % Used Account: 135-50020-010-000 Retirement 742 02/09/2018 MUD PR 02.09.18 Retirement 7,974.09 827.14 8,801.23 PR 843 02/23/2018 MUD PR 02.23.18 Retirement 879.96 9,681.19 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,707.10 9,681.19 ** 27,843.00 Budgeted 18,161.81 Remaining 35 % Used Account: 135-50026-010-000 Medical Insurance 742 02/09/2018 MUD PR 02.09.18 Medical Insurance 9,209.43 1,474.40 10,683.83 PR 843 02/23/2018 MUD PR 02.23.18 Medical Insurance 1,474.40 12,158.23 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,948.80 12,158.23 ** 52,196.00 Budgeted 40,037.77 Remaining 23 % Used Trophy Club Municipal Utility District No. 1 54 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-010-000 Dental Insurance 742 02/09/2018 MUD PR 02.09.18 Dental Insurance 886.58 103.58 990.16 PR 843 02/23/2018 MUD PR 02.23.18 Dental Insurance 103.58 1,093.74 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 207.16 1,093.74 ** 5,182.00 Budgeted 4,088.26 Remaining 21 % Used Account: 135-50028-010-000 Vision Insurance 742 02/09/2018 MUD PR 02.09.18 Vision Insurance 172.47 17.98 190.45 PR 843 02/23/2018 MUD PR 02.23.18 Vision Insurance 17.94 208.39 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 35.92 208.39 ** 994.00 Budgeted 785.61 Remaining 21 % Used Account: 135-50029-010-000 Life Insurance & Other 682 02/01/2018 February A/P February STD & LTD benefits 844.85 73.43 918.28 METLIFE GROUP BENEFITS 3881 AP 682 02/01/2018 February A/P Life Dental and vision for Feb 90.72 1,009.00 Humana Inc 3880 AP 887 02/28/2018 February AP Flex admin fee 17.00 1,026.00 BenefitMall 3952 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 181.15 1,026.00 ** 2,982.00 Budgeted 1,956.00 Remaining 34 % Used Account: 135-50030-010-000 Social Security Taxes 742 02/09/2018 MUD PR 02.09.18 Social Security Taxes 4,381.13 546.76 4,927.89 PR 843 02/23/2018 MUD PR 02.23.18 Social Security Taxes 579.88 5,507.77 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,126.64 5,507.77 ** 18,662.00 Budgeted 13,154.23 Remaining 30 % Used Account: 135-50035-010-000 Medicare Taxes 742 02/09/2018 MUD PR 02.09.18 Medicare Taxes 1,024.61 127.88 1,152.49 PR 843 02/23/2018 MUD PR 02.23.18 Medicare Taxes 135.60 1,288.09 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 263.48 1,288.09 ** 4,365.00 Budgeted 3,076.91 Remaining 30 % Used Account: 135-50040-010-000 Unemployment Taxes 742 02/09/2018 MUD PR 02.09.18 Unemployment Taxes 26.04 8.84 34.88 PR Trophy Club Municipal Utility District No. 1 55 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 12 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 843 02/23/2018 MUD PR 02.23.18 Unemployment Taxes 26.04 6.20 41.08 PR _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 15.04 41.08 ** 1,080.00 Budgeted 1,038.92 Remaining 4 % Used Account: 135-50045-010-000 Workman's Compensation 236 02/01/2018 Insurance/Wrk Comp Exp Feb 3,599.68 899.92 4,499.60 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 899.92 4,499.60 ** 11,854.00 Budgeted 7,354.40 Remaining 38 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 226.05 .00 226.05 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 226.05 ** 200.00 Budgeted (26.05) Remaining 113 % Used Account: 135-50070-010-000 Employee Relations 18.99 .00 18.99 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 18.99 ** 300.00 Budgeted 281.01 Remaining 6 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 275,000.00 Budgeted 275,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 926 02/26/2018 Pcard 01/27/18 - 02/26/18 THE HOME DEPOT #6581 31,203.31 78.25 31,281.56 THE HOME DEPOT #6581 PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 THE HOME DEPOT #6581 47.12 31,328.68 THE HOME DEPOT #6581 PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 THE HOME DEPOT #6581 52.30 31,380.98 THE HOME DEPOT #6581 PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 THE HOME DEPOT #6581 1.94 31,382.92 THE HOME DEPOT #6581 PC 917 02/28/2018 February A/P Bottle lease 42.00 31,424.92 ALLIED WELDING SUPPLY, INC 3974 AP 887 02/28/2018 February AP Fire hydrant parts 1,454.56 32,879.48 ATLAS UTILITY SUPPLY CO. 3951 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 1,676.17 32,879.48 ** 100,000.00 Budgeted 67,120.52 Remaining 33 % Used Trophy Club Municipal Utility District No. 1 56 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 13 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55085-010-000 Generator Maint. and Repair .00 .00 _______________ Account: 135-55085-010-000 Generator Maint. and Repair Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 135-55090-010-000 Vehicle Maintenance 926 02/26/2018 Pcard 01/27/18 - 02/26/18 GIERISCH CARE 0050292 2,577.66 67.23 2,644.89 GIERISCH CARE 0050292 PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 DISCOUNT TIRE TXD 75 172.50 2,817.39 DISCOUNT TIRE TXD 75 PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 239.73 2,817.39 ** 4,000.00 Budgeted 1,182.61 Remaining 70 % 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 2,093.44 .00 2,093.44 _______________ Account: 135-55135-010-000 Lab Analysis Totals: .00 2,093.44 ** 5,500.00 Budgeted 3,406.56 Remaining 38 % Used Account: 135-60010-010-000 Communications/Mobiles 809 02/13/2018 February A/P Mobile phones 1,010.98 370.64 1,381.62 VERIZON WIRELESS 3946 AP _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 370.64 1,381.62 ** 4,700.00 Budgeted 3,318.38 Remaining 29 % Used Account: 135-60020-010-000 Electricity 809 02/13/2018 February A/P Electricity 1/9-2/7 48,098.00 50.98 48,148.98 HUDSON ENERGY SERVICES, LLC 3935 AP 809 02/13/2018 February A/P Electricity 1/10-2/8 76.28 48,225.26 HUDSON ENERGY SERVICES, LLC 3935 AP 864 02/23/2018 February A/P Electricity 1/10-2/8 8,054.88 56,280.14 HUDSON ENERGY SERVICES, LLC 3961 AP _______________ Account: 135-60020-010-000 Electricity Totals: 8,182.14 56,280.14 ** 175,356.00 Budgeted 119,075.86 Remaining 32 % Used Trophy Club Municipal Utility District No. 1 57 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 14 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-60070-010-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60080-010-000 Schools & Training 926 02/26/2018 Pcard 01/27/18 - 02/26/18 PAYPAL *TEXASWATERW 235.00 325.00 560.00 PAYPAL *TEXASWATERW PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 TCEQ IND RENEWAL L 111.00 671.00 TCEQ IND RENEWAL L PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 TCEQ EPAYMENT 111.00 782.00 TCEQ EPAYMENT PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 360 WATER INC 60.00 842.00 360 WATER INC PC 922 02/28/2018 February A/P Schools/training food/miles 132.78 974.78 Frank Isola 3982 AP _______________ Account: 135-60080-010-000 Schools & Training Totals: 739.78 974.78 ** 2,785.00 Budgeted 1,810.22 Remaining 35 % Used Account: 135-60090-010-000 Safety Program 8.36 .00 8.36 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 8.36 ** 400.00 Budgeted 391.64 Remaining 2 % Used Account: 135-60100-010-000 Travel & per diem 87.48 .00 87.48 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 87.48 ** 1,735.00 Budgeted 1,647.52 Remaining 5 % Used Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Trophy Club Municipal Utility District No. 1 58 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 15 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60135-010-000 TCEQ Fees & Permits 809 02/13/2018 February A/P Groundwater charge 7,685.65 5,122.40 12,808.05 North Texas Groundwater 3940 AP _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 5,122.40 12,808.05 ** 55,176.00 Budgeted 42,367.95 Remaining 23 % Used Account: 135-60150-010-000 Wholesale Water 887 02/28/2018 February AP Wholesale water 505,492.71 107,996.70 613,489.41 CITY OF FORT WORTH 3953 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 107,996.70 613,489.41 ** 2,823,170.00 Budgeted 2,209,680.59 Remaining 22 % Used Account: 135-60245-010-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60280-010-000 Property Maintenance 322.70 .00 322.70 _______________ Account: 135-60280-010-000 Property Maintenance Totals: .00 322.70 ** 3,000.00 Budgeted 2,677.30 Remaining 11 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance 2,250.00 .00 2,250.00 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 2,250.00 ** 14,750.00 Budgeted 12,500.00 Remaining 15 % Used Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S 962 02/28/2018 Texpool Transfers Feb 101,121.24 25,280.31 126,401.55 GL _______________ Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S Totals: 25,280.31 126,401.55 ** 278,084.00 Budgeted 151,682.45 Remaining 45 % Used Account: 135-60333-010-000 Interfund Transfer Out-Reserve Trophy Club Municipal Utility District No. 1 59 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 962 02/28/2018 Texpool Transfers Feb 16,332.00 4,083.00 20,415.00 GL _______________ Account: 135-60333-010-000 Interfund Transfer Out-Reserve Totals: 4,083.00 20,415.00 ** 48,996.00 Budgeted 28,581.00 Remaining 42 % Used Account: 135-60334-010-000 Interfund Transfer Out .00 .00 _______________ Account: 135-60334-010-000 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 5,019.66 .00 5,019.66 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 5,019.66 ** 2,500.00 Budgeted (2,519.66) Remaining 201 % Used Account: 135-65005-010-000 Fuel & Lube 922 02/28/2018 February A/P Fuel 2,983.58 949.94 3,933.52 US Bank Voyager Fleet Systems 4000 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 949.94 3,933.52 ** 15,000.00 Budgeted 11,066.48 Remaining 26 % Used Account: 135-65010-010-000 Uniforms 926 02/26/2018 Pcard 01/27/18 - 02/26/18 AMAZON.COM 829.64 160.93 990.57 AMAZON.COM PC _______________ Account: 135-65010-010-000 Uniforms Totals: 160.93 990.57 ** 4,488.00 Budgeted 3,497.43 Remaining 22 % Used Account: 135-65030-010-000 Chemicals 864 02/23/2018 February A/P Buffer solution 4,398.38 72.54 4,470.92 HACH COMPANY 3959 AP 887 02/28/2018 February AP Testing supplies 216.00 4,686.92 HACH COMPANY 3959 AP 887 02/28/2018 February AP Testing supplies 303.00 4,989.92 HACH COMPANY 3959 AP 887 02/28/2018 February AP LAS 434.64 5,424.56 Valley Solvent Company, INC 3973 AP 887 02/28/2018 February AP Chlorine 1,216.83 6,641.39 DPC INDUSTRIES, INC 3956 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 2,243.01 6,641.39 ** 20,000.00 Budgeted 13,358.61 Remaining 33 % Used Trophy Club Municipal Utility District No. 1 60 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65035-010-000 Small Tools .00 .00 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-65040-010-000 Safety Equipment .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 12,400.00 .00 12,400.00 _______________ Account: 135-65050-010-000 Meter Expense Totals: .00 12,400.00 ** 50,000.00 Budgeted 37,600.00 Remaining 25 % Used Account: 135-65053-010-000 Meter Change Out Program 48,900.00 .00 48,900.00 _______________ Account: 135-65053-010-000 Meter Change Out Program Totals: .00 48,900.00 ** 84,000.00 Budgeted 35,100.00 Remaining 58 % Used Account: 135-69005-010-000 Capital Outlays 790 02/09/2018 Feb A/P Northside II project 120,056.27 2,693,208.68 2,813,264.95 Fort Worth Water Department AP 815 02/14/2018 February A/P 16" water line 17,048.70 2,830,313.65 Halff Associates, INC 3934 AP 838 02/19/2018 February A/P Portland water line 70,000.00 2,900,313.65 REY-MAR CONSTRUCTION 3971 AP 838 02/19/2018 February A/P New VFD Pump 2,542.00 2,902,855.65 CP&Y/WALLACE GROUP, INC. 3954 AP 838 02/19/2018 February A/P TCEQ Bond application 873.75 2,903,729.40 CP&Y/WALLACE GROUP, INC. 3954 AP 838 02/19/2018 February A/P 16" water line modeling 4,837.50 2,908,566.90 CP&Y/WALLACE GROUP, INC. 3954 AP 845 02/20/2018 Direct Pay from TWBD- VOID Northside II project (2,693,208.68) 215,358.22 Fort Worth Water Department AP 917 02/28/2018 February A/P Indian Creek/Phoenix 8,250.00 223,608.22 TEAGUE, NALL & PERKINS,INC 3996 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 103,551.95 223,608.22 ** 810,012.00 Budgeted 586,403.78 Remaining 28 % Used Account: 135-69008-010-000 Short Term Debt-Principal Trophy Club Municipal Utility District No. 1 61 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 18 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 .00 ** 38,731.00 Budgeted 38,731.00 Remaining 0 % Used Account: 135-69009-010-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 .00 ** 5,713.00 Budgeted 5,713.00 Remaining 0 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 .00 75,000.00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 107,864.38 .00 107,864.38 _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 107,864.38 ** 118,775.00 Budgeted 10,910.62 Remaining 91 % Used Trophy Club Municipal Utility District No. 1 62 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 19 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55135-010-001 Lab Analysis for PID 743.89 .00 743.89 _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: .00 743.89 ** 2,000.00 Budgeted 1,256.11 Remaining 37 % Used Department 10 Totals: ----------------------------------- 1,482,478.96 ** 286,437.18 Monthly Total 5,657,433.00 Budgeted 4,174,954.04 Remaining 26 % Used Trophy Club Municipal Utility District No. 1 63 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-020-000 Salaries & Wages 742 02/09/2018 MUD PR 02.09.18 Salaries & Wages 122,762.40 15,346.44 138,108.84 PR 843 02/23/2018 MUD PR 02.23.18 Salaries & Wages 15,303.74 153,412.58 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 30,650.18 153,412.58 ** 410,866.00 Budgeted 257,453.42 Remaining 37 % Used Account: 135-50010-020-000 Overtime 742 02/09/2018 MUD PR 02.09.18 Overtime 10,130.76 1,355.04 11,485.80 PR 843 02/23/2018 MUD PR 02.23.18 Overtime 901.28 12,387.08 PR _______________ Account: 135-50010-020-000 Overtime Totals: 2,256.32 12,387.08 ** 30,000.00 Budgeted 17,612.92 Remaining 41 % Used Account: 135-50016-020-000 Longevity 7,415.00 .00 7,415.00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 7,415.00 ** 7,415.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-020-000 Certification 843 02/23/2018 MUD PR 02.23.18 Certification 2,725.00 700.00 3,425.00 PR 926 02/26/2018 Pcard 01/27/18 - 02/26/18 TCEQ IND RENEWAL L 111.00 3,536.00 TCEQ IND RENEWAL L PC _______________ Account: 135-50017-020-000 Certification Totals: 811.00 3,536.00 ** 8,400.00 Budgeted 4,864.00 Remaining 42 % Used Account: 135-50020-020-000 Retirement 742 02/09/2018 MUD PR 02.09.18 Retirement 14,695.03 1,544.89 16,239.92 PR 843 02/23/2018 MUD PR 02.23.18 Retirement 1,563.71 17,803.63 PR _______________ Account: 135-50020-020-000 Retirement Totals: 3,108.60 17,803.63 ** 42,243.00 Budgeted 24,439.37 Remaining 42 % Used Account: 135-50026-020-000 Medical Insurance 742 02/09/2018 MUD PR 02.09.18 Medical Insurance 20,239.05 3,054.24 23,293.29 PR 843 02/23/2018 MUD PR 02.23.18 Medical Insurance 3,054.21 26,347.50 PR Trophy Club Municipal Utility District No. 1 64 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50026-020-000 Medical Insurance Totals: 6,108.45 26,347.50 ** 62,175.00 Budgeted 35,827.50 Remaining 42 % Used Account: 135-50027-020-000 Dental Insurance 742 02/09/2018 MUD PR 02.09.18 Dental Insurance 1,573.06 187.57 1,760.63 PR 843 02/23/2018 MUD PR 02.23.18 Dental Insurance 187.53 1,948.16 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 375.10 1,948.16 ** 5,271.00 Budgeted 3,322.84 Remaining 37 % Used Account: 135-50028-020-000 Vision Insurance 742 02/09/2018 MUD PR 02.09.18 Vision Insurance 318.48 32.76 351.24 PR 843 02/23/2018 MUD PR 02.23.18 Vision Insurance 32.73 383.97 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 65.49 383.97 ** 1,114.00 Budgeted 730.03 Remaining 34 % Used Account: 135-50029-020-000 Life Insurance & Other 682 02/01/2018 February A/P February STD & LTD benefits 1,584.12 149.71 1,733.83 METLIFE GROUP BENEFITS 3881 AP 682 02/01/2018 February A/P Life Dental and vision for Feb 192.36 1,926.19 Humana Inc 3880 AP 887 02/28/2018 February AP Flex admin fee 34.00 1,960.19 BenefitMall 3952 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 376.07 1,960.19 ** 4,281.00 Budgeted 2,320.81 Remaining 46 % Used Account: 135-50030-020-000 Social Security Taxes 742 02/09/2018 MUD PR 02.09.18 Social Security Taxes 8,369.06 960.80 9,329.86 PR 843 02/23/2018 MUD PR 02.23.18 Social Security Taxes 948.35 10,278.21 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,909.15 10,278.21 ** 28,314.00 Budgeted 18,035.79 Remaining 36 % Used Account: 135-50035-020-000 Medicare Taxes 742 02/09/2018 MUD PR 02.09.18 Medicare Taxes 1,957.28 224.70 2,181.98 PR 843 02/23/2018 MUD PR 02.23.18 Medicare Taxes 221.79 2,403.77 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 446.49 2,403.77 ** 6,622.00 Budgeted 4,218.23 Remaining 36 % Used Trophy Club Municipal Utility District No. 1 65 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50040-020-000 Unemployment Taxes 742 02/09/2018 MUD PR 02.09.18 Unemployment Taxes 34.80 16.70 51.50 PR 843 02/23/2018 MUD PR 02.23.18 Unemployment Taxes 9.38 60.88 PR _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: 26.08 60.88 ** 1,260.00 Budgeted 1,199.12 Remaining 5 % Used Account: 135-50045-020-000 Workman's Compensation 236 02/01/2018 Insurance/Wrk Comp Exp Feb 5,392.00 1,348.00 6,740.00 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 1,348.00 6,740.00 ** 17,990.00 Budgeted 11,250.00 Remaining 37 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-50070-020-000 Employee Relations .00 .00 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 .00 ** 350.00 Budgeted 350.00 Remaining 0 % Used Account: 135-55070-020-000 Independent Labor 1,069.50 .00 1,069.50 _______________ Account: 135-55070-020-000 Independent Labor Totals: .00 1,069.50 ** 20,550.00 Budgeted 19,480.50 Remaining 5 % Used Account: 135-55080-020-000 Maintenance & Repairs 840 02/07/2018 Vendor information has changed Maintenance parts for belt pre 19,023.35 (4,302.07) 14,721.28 ALFA LAVAL ASHBROOK 3883 AP 840 02/07/2018 Vendor information has changed Black scraper for belt press (159.50) 14,561.78 ALFA LAVAL ASHBROOK 3883 AP 864 02/23/2018 February A/P Maintenance parts for belt pre 4,302.07 18,863.85 Alfa Laval, Inc 3950 AP 864 02/23/2018 February A/P Black scraper for belt press 159.50 19,023.35 Alfa Laval, Inc 3950 AP 926 02/26/2018 Pcard 01/27/18 - 02/26/18 FERGUSON ENT 1241 53.26 19,076.61 FERGUSON ENT 1241 PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 FERGUSON ENT #788 65.50 19,142.11 FERGUSON ENT #788 PC Trophy Club Municipal Utility District No. 1 66 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 23 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 926 02/26/2018 Pcard 01/27/18 - 02/26/18 FERGUSON ENT 1241 19,023.35 20.60 19,162.71 FERGUSON ENT 1241 PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 ROANOKE AUTO SUPPLY LT 14.98 19,177.69 ROANOKE AUTO SUPPLY LT PC _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 154.34 19,177.69 ** 86,100.00 Budgeted 66,922.31 Remaining 22 % Used Account: 135-55085-020-000 Generator Maint. and Repair 28.78 .00 28.78 _______________ Account: 135-55085-020-000 Generator Maint. and Repair Totals: .00 28.78 ** 14,000.00 Budgeted 13,971.22 Remaining 0 % Used Account: 135-55090-020-000 Vehicle Maintenance 922 02/28/2018 February A/P Tires-trailer 3,131.88 274.53 3,406.41 Jeff Richey 3986 AP _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 274.53 3,406.41 ** 8,000.00 Budgeted 4,593.59 Remaining 43 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 289.69 .00 289.69 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 289.69 ** 500.00 Budgeted 210.31 Remaining 58 % Used Account: 135-55125-020-000 Dumpster Services 838 02/19/2018 February A/P sludge haul off 31,529.50 882.60 32,412.10 L.H. CHANEY MATERIALS, INC. 3965 AP 838 02/19/2018 February A/P sludge haul off 740.64 33,152.74 L.H. CHANEY MATERIALS, INC. 3965 AP 917 02/28/2018 February A/P Sludge haul off 2,550.63 35,703.37 L.H. CHANEY MATERIALS, INC. 3988 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 4,173.87 35,703.37 ** 60,000.00 Budgeted 24,296.63 Remaining 60 % Used Account: 135-55135-020-000 Lab Analysis 838 02/19/2018 February A/P labs 14,528.82 246.00 14,774.82 OXIDOR LABORATORIES LLC 3970 AP 838 02/19/2018 February A/P labs 176.00 14,950.82 OXIDOR LABORATORIES LLC 3970 AP 838 02/19/2018 February A/P Labs 246.00 15,196.82 OXIDOR LABORATORIES LLC 3970 AP 838 02/19/2018 February A/P Labs 176.00 15,372.82 OXIDOR LABORATORIES LLC 3970 AP 917 02/28/2018 February A/P Lab supplies 176.00 15,548.82 OXIDOR LABORATORIES LLC 3993 AP Trophy Club Municipal Utility District No. 1 67 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 24 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 917 02/28/2018 February A/P Lab supplies 14,528.82 246.00 15,794.82 OXIDOR LABORATORIES LLC 3993 AP 917 02/28/2018 February A/P Lab supplies 246.00 16,040.82 OXIDOR LABORATORIES LLC 3993 AP 917 02/28/2018 February A/P Lab supplies 176.00 16,216.82 OXIDOR LABORATORIES LLC 3993 AP 917 02/28/2018 February A/P Lab supplies 246.00 16,462.82 OXIDOR LABORATORIES LLC 3993 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 1,934.00 16,462.82 ** 30,000.00 Budgeted 13,537.18 Remaining 55 % Used Account: 135-60010-020-000 Communications/Mobiles 809 02/13/2018 February A/P Mobile phones 1,611.71 490.34 2,102.05 VERIZON WIRELESS 3946 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 490.34 2,102.05 ** 4,700.00 Budgeted 2,597.95 Remaining 45 % Used Account: 135-60020-020-000 Electricity 809 02/13/2018 February A/P Electricity 1/9-2/7 59,754.10 27.83 59,781.93 HUDSON ENERGY SERVICES, LLC 3935 AP 809 02/13/2018 February A/P Electricity 1/9-2/7 56.06 59,837.99 HUDSON ENERGY SERVICES, LLC 3935 AP 809 02/13/2018 February A/P Electricity 1/10-2/8 33.71 59,871.70 HUDSON ENERGY SERVICES, LLC 3935 AP 809 02/13/2018 February A/P Electricity 1/10-2/8 358.16 60,229.86 HUDSON ENERGY SERVICES, LLC 3935 AP 809 02/13/2018 February A/P Electricity 2/5-2/8 981.80 61,211.66 HUDSON ENERGY SERVICES, LLC 3935 AP 838 02/19/2018 February A/P Electricity 1/10-2/4 8,511.29 69,722.95 ENGIE Resources LLC 3958 AP 838 02/19/2018 February A/P Electricity 1/10-2/5 3,416.05 73,139.00 HUDSON ENERGY SERVICES, LLC 3961 AP 864 02/23/2018 February A/P Electricity 1/10-2/8 425.44 73,564.44 HUDSON ENERGY SERVICES, LLC 3961 AP 991 02/28/2018 Town Billed Invoices 1624-1627 AR 20180228-20180228 User: (405.64) 73,158.80 AR _______________ Account: 135-60020-020-000 Electricity Totals: 13,404.70 73,158.80 ** 266,709.00 Budgeted 193,550.20 Remaining 27 % Used Account: 135-60066-020-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60070-020-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-020-000 Dues & Memberships Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Trophy Club Municipal Utility District No. 1 68 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60080-020-000 Schools & Training .00 .00 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 .00 ** 5,677.00 Budgeted 5,677.00 Remaining 0 % Used Account: 135-60090-020-000 Safety Program 8.37 .00 8.37 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 8.37 ** 550.00 Budgeted 541.63 Remaining 2 % Used Account: 135-60100-020-000 Travel & per diem 73.06 .00 73.06 _______________ Account: 135-60100-020-000 Travel & per diem Totals: .00 73.06 ** 1,635.00 Budgeted 1,561.94 Remaining 4 % Used Account: 135-60105-020-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60125-020-000 Advertising .00 .00 _______________ Account: 135-60125-020-000 Advertising Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 30,272.52 .00 30,272.52 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 30,272.52 ** 85,000.00 Budgeted 54,727.48 Remaining 36 % Used Account: 135-60245-020-000 Miscellaneous Expenses Trophy Club Municipal Utility District No. 1 69 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 966 02/28/2018 IRS Refund Overpayment Adj due to rounding .01 .01 GL _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .01 .01 ** 450.00 Budgeted 449.99 Remaining 0 % Used Account: 135-60280-020-000 Property Maintenance .00 .00 _______________ Account: 135-60280-020-000 Property Maintenance Totals: .00 .00 ** 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 1,770.00 .00 1,770.00 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 1,770.00 ** 11,600.00 Budgeted 9,830.00 Remaining 15 % Used Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S 962 02/28/2018 Texpool Transfers Feb 44,379.24 11,094.81 55,474.05 GL _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 11,094.81 55,474.05 ** 122,043.00 Budgeted 66,568.95 Remaining 45 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S 962 02/28/2018 Texpool Transfers Feb 217,722.88 54,430.72 272,153.60 GL _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: 54,430.72 272,153.60 ** 598,738.00 Budgeted 326,584.40 Remaining 45 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 962 02/28/2018 Texpool Transfers Feb 41,112.00 10,278.00 51,390.00 GL _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 10,278.00 51,390.00 ** 123,336.00 Budgeted 71,946.00 Remaining 42 % Used Account: 135-60334-020-000 Interfund Transfer Out .00 .00 Trophy Club Municipal Utility District No. 1 70 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60334-020-000 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 % Used Account: 135-60360-020-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Account: 135-65005-020-000 Fuel & Lube 922 02/28/2018 February A/P Fuel 2,987.64 743.43 3,731.07 US Bank Voyager Fleet Systems 4000 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 743.43 3,731.07 ** 12,500.00 Budgeted 8,768.93 Remaining 30 % Used Account: 135-65010-020-000 Uniforms 926 02/26/2018 Pcard 01/27/18 - 02/26/18 LEVIS OUTLET 322 1,614.63 173.16 1,787.79 LEVIS OUTLET 322 PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 LEVIS OUTLET 322 (173.16) 1,614.63 LEVIS OUTLET 322 PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 LEVIS OUTLET 322 159.96 1,774.59 LEVIS OUTLET 322 PC _______________ Account: 135-65010-020-000 Uniforms Totals: 159.96 1,774.59 ** 4,459.00 Budgeted 2,684.41 Remaining 40 % Used Account: 135-65030-020-000 Chemicals 3,892.03 .00 3,892.03 _______________ Account: 135-65030-020-000 Chemicals Totals: .00 3,892.03 ** 27,500.00 Budgeted 23,607.97 Remaining 14 % Used Account: 135-65035-020-000 Small Tools 926 02/26/2018 Pcard 01/27/18 - 02/26/18 THE HOME DEPOT #6581 1,083.22 34.99 1,118.21 THE HOME DEPOT #6581 PC _______________ Account: 135-65035-020-000 Small Tools Totals: 34.99 1,118.21 ** 1,000.00 Budgeted (118.21) Remaining 112 % Used Account: 135-65040-020-000 Safety Equipment Trophy Club Municipal Utility District No. 1 71 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 28 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 926 02/26/2018 Pcard 01/27/18 - 02/26/18 RITZ SAFETY DALLAS 260.00 260.00 RITZ SAFETY DALLAS PC _______________ Account: 135-65040-020-000 Safety Equipment Totals: 260.00 260.00 ** 750.00 Budgeted 490.00 Remaining 35 % Used Account: 135-65045-020-000 Lab Supplies 926 02/26/2018 Pcard 01/27/18 - 02/26/18 USA BLUE BOOK 4,718.29 (241.50) 4,476.79 USA BLUE BOOK PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 HACH COMPANY 457.25 4,934.04 HACH COMPANY PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 THE HOME DEPOT #6581 5.67 4,939.71 THE HOME DEPOT #6581 PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 USA BLUE BOOK 241.50 5,181.21 USA BLUE BOOK PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 USA BLUE BOOK 241.50 5,422.71 USA BLUE BOOK PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 HACH COMPANY 54.89 5,477.60 HACH COMPANY PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 HACH COMPANY 31.78 5,509.38 HACH COMPANY PC 917 02/28/2018 February A/P Gloves 162.00 5,671.38 LOU'S GLOVES INCORPORATED 3991 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 953.09 5,671.38 ** 14,000.00 Budgeted 8,328.62 Remaining 41 % Used Account: 135-69005-020-000 Capital Outlays 838 02/19/2018 February A/P Legal WWTP 13,396.93 1,657.50 15,054.43 Dubois Bryant Campbell LLP 3957 AP 838 02/19/2018 February A/P WWTP Upgrades 34,557.86 49,612.29 CP&Y/WALLACE GROUP, INC. 3954 AP 884 02/28/2018 Correct Fund Cap Out- 135-517 (34,557.86) 15,054.43 GL _______________ Account: 135-69005-020-000 Capital Outlays Totals: 1,657.50 15,054.43 ** 547,327.00 Budgeted 532,272.57 Remaining 3 % Used Account: 135-69008-020-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-020-000 Short Term Debt-Principal Totals: .00 .00 ** 51,342.00 Budgeted 51,342.00 Remaining 0 % Used Account: 135-69009-020-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-020-000 Short Term Debt-Interest Totals: .00 .00 ** 7,573.00 Budgeted 7,573.00 Remaining 0 % Used Account: 135-69195-020-000 Gasb34/Reserve for Replacement Trophy Club Municipal Utility District No. 1 72 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 29 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 30,000.00 .00 30,000.00 _______________ Account: 135-69195-020-000 Gasb34/Reserve for Replacement Totals: .00 30,000.00 ** 30,000.00 Budgeted .00 Remaining 100 % Used Department 20 Totals: ----------------------------------- 868,719.40 ** 147,525.22 Monthly Total 2,981,140.00 Budgeted 2,112,420.60 Remaining 29 % Used Trophy Club Municipal Utility District No. 1 73 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-026-000 Workman's Compensation 236 02/01/2018 Insurance/Wrk Comp Exp Feb 9.68 2.42 12.10 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.42 12.10 ** 30.00 Budgeted 17.90 Remaining 40 % Used Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60070-026-000 Dues & Memberships 650.00 .00 650.00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 650.00 ** 600.00 Budgeted (50.00) Remaining 108 % Used Account: 135-60075-026-000 Meetings .00 .00 _______________ Account: 135-60075-026-000 Meetings Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-60080-026-000 Schools & Training 1,135.00 .00 1,135.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 1,135.00 ** 4,000.00 Budgeted 2,865.00 Remaining 28 % Used Account: 135-60100-026-000 Travel & per diem 809 02/13/2018 February A/P AWBD mileage, hotel, food 289.98 560.96 850.94 JAMES C. THOMAS 3937 AP 864 02/23/2018 February A/P AWBD mileage & food/Tip & park 109.06 960.00 KEVIN R. CARR 3962 AP _______________ Account: 135-60100-026-000 Travel & per diem Totals: 670.02 960.00 ** 5,000.00 Budgeted 4,040.00 Remaining 19 % Used Account: 135-60245-026-000 Miscellaneous Expenses Trophy Club Municipal Utility District No. 1 74 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1,021.73 .00 1,021.73 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 1,021.73 ** 2,000.00 Budgeted 978.27 Remaining 51 % Used Department 26 Totals: ----------------------------------- 3,778.83 ** 672.44 Monthly Total 12,980.00 Budgeted 9,201.17 Remaining 29 % Used Trophy Club Municipal Utility District No. 1 75 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-030-000 Salaries & Wages 742 02/09/2018 MUD PR 02.09.18 Salaries & Wages 130,363.03 12,588.76 142,951.79 PR 843 02/23/2018 MUD PR 02.23.18 Salaries & Wages 12,483.00 155,434.79 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 25,071.76 155,434.79 ** 432,863.00 Budgeted 277,428.21 Remaining 36 % Used Account: 135-50010-030-000 Overtime 742 02/09/2018 MUD PR 02.09.18 Overtime 391.47 19.18 410.65 PR _______________ Account: 135-50010-030-000 Overtime Totals: 19.18 410.65 ** 2,000.00 Budgeted 1,589.35 Remaining 21 % Used Account: 135-50016-030-000 Longevity 3,547.50 .00 3,547.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 3,547.50 ** 3,548.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 742 02/09/2018 MUD PR 02.09.18 Retirement 14,729.87 1,166.24 15,896.11 PR 843 02/23/2018 MUD PR 02.23.18 Retirement 1,154.67 17,050.78 PR _______________ Account: 135-50020-030-000 Retirement Totals: 2,320.91 17,050.78 ** 40,553.00 Budgeted 23,502.22 Remaining 42 % Used Account: 135-50026-030-000 Medical Insurance 742 02/09/2018 MUD PR 02.09.18 Medical Insurance 14,902.73 2,072.63 16,975.36 PR 843 02/23/2018 MUD PR 02.23.18 Medical Insurance 2,072.61 19,047.97 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,145.24 19,047.97 ** 63,485.00 Budgeted 44,437.03 Remaining 30 % Used Account: 135-50027-030-000 Dental Insurance 742 02/09/2018 MUD PR 02.09.18 Dental Insurance 1,241.90 125.76 1,367.66 PR 843 02/23/2018 MUD PR 02.23.18 Dental Insurance 125.74 1,493.40 PR _______________ Account: 135-50027-030-000 Dental Insurance Totals: 251.50 1,493.40 ** 5,502.00 Budgeted 4,008.60 Remaining 27 % Used Trophy Club Municipal Utility District No. 1 76 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50028-030-000 Vision Insurance 742 02/09/2018 MUD PR 02.09.18 Vision Insurance 256.39 21.28 277.67 PR 843 02/23/2018 MUD PR 02.23.18 Vision Insurance 21.23 298.90 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 42.51 298.90 ** 1,173.00 Budgeted 874.10 Remaining 25 % Used Account: 135-50029-030-000 Life Insurance & Other 682 02/01/2018 February A/P February STD & LTD benefits 1,421.63 120.23 1,541.86 METLIFE GROUP BENEFITS 3881 AP 682 02/01/2018 February A/P Life Dental and vision for Feb 145.04 1,686.90 Humana Inc 3880 AP 887 02/28/2018 February AP Flex admin fee 17.00 1,703.90 BenefitMall 3952 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 282.27 1,703.90 ** 5,059.00 Budgeted 3,355.10 Remaining 34 % Used Account: 135-50030-030-000 Social Security Taxes 742 02/09/2018 MUD PR 02.09.18 Social Security Taxes 8,024.43 743.97 8,768.40 PR 843 02/23/2018 MUD PR 02.23.18 Social Security Taxes 733.36 9,501.76 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 1,477.33 9,501.76 ** 27,181.00 Budgeted 17,679.24 Remaining 35 % Used Account: 135-50035-030-000 Medicare Taxes 742 02/09/2018 MUD PR 02.09.18 Medicare Taxes 1,876.67 173.99 2,050.66 PR 843 02/23/2018 MUD PR 02.23.18 Medicare Taxes 171.50 2,222.16 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 345.49 2,222.16 ** 6,357.00 Budgeted 4,134.84 Remaining 35 % Used Account: 135-50040-030-000 Unemployment Taxes 742 02/09/2018 MUD PR 02.09.18 Unemployment Taxes 36.98 11.57 48.55 PR 843 02/23/2018 MUD PR 02.23.18 Unemployment Taxes 6.15 54.70 PR _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 17.72 54.70 ** 1,260.00 Budgeted 1,205.30 Remaining 4 % Used Account: 135-50045-030-000 Workman's Compensation 236 02/01/2018 Insurance/Wrk Comp Exp Feb 494.00 123.50 617.50 GL Trophy Club Municipal Utility District No. 1 77 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 34 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 123.50 617.50 ** 1,529.00 Budgeted 911.50 Remaining 40 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 124.95 .00 124.95 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 124.95 ** 500.00 Budgeted 375.05 Remaining 25 % Used Account: 135-50070-030-000 Employee Relations 926 02/26/2018 Pcard 01/27/18 - 02/26/18 HOBBY-LOBBY #256 2,370.40 (75.73) 2,294.67 HOBBY-LOBBY #256 PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 TOM THUMB #1789 26.12 2,320.79 TOM THUMB #1789 PC _______________ Account: 135-50070-030-000 Employee Relations Totals: (49.61) 2,320.79 ** 4,960.00 Budgeted 2,639.21 Remaining 47 % Used Account: 135-55030-030-000 Software & Support 815 02/14/2018 February A/P Internet 39,879.40 1,051.94 40,931.34 WHOLESALE CARRIER SERVICES INC 3947 AP 838 02/19/2018 February A/P Software 365 outlook license 168.00 41,099.34 M3 Networks 3967 AP 864 02/23/2018 February A/P STW support & Vision License A 1,475.69 42,575.03 STW INC 3972 AP 926 02/26/2018 Pcard 01/27/18 - 02/26/18 ADOBE SYSTEMS, INC. (106.38) 42,468.65 ADOBE SYSTEMS, INC. PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 ADOBE SYSTEMS, INC. (19.99) 42,448.66 ADOBE SYSTEMS, INC. PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 CANVA FOR WORK MONTHLY 12.95 42,461.61 CANVA FOR WORK MONTHLY PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 ADOBE SYSTEMS, INC. 389.57 42,851.18 ADOBE SYSTEMS, INC. PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 ATT*BILL PAYMENT 85.71 42,936.89 ATT*BILL PAYMENT PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 ATT*BILL PAYMENT 63.59 43,000.48 ATT*BILL PAYMENT PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 ATT*BILL PAYMENT 111.88 43,112.36 ATT*BILL PAYMENT PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 ADOBE SYSTEMS INC 16.23 43,128.59 ADOBE SYSTEMS INC PC _______________ Account: 135-55030-030-000 Software & Support Totals: 3,249.19 43,128.59 ** 78,391.00 Budgeted 35,262.41 Remaining 55 % Used Account: 135-55070-030-000 Independent Labor 917 02/28/2018 February A/P GM-February 50,041.99 13,028.85 63,070.84 Carman Consulting LLC. 4003 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 13,028.85 63,070.84 ** 154,000.00 Budgeted 90,929.16 Remaining 41 % Used Trophy Club Municipal Utility District No. 1 78 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 35 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55080-030-000 Maintenance & Repairs 790 02/09/2018 Feb A/P Office heater 1,296.50 825.00 2,121.50 BRANDON R REED 3930 AP 790 02/09/2018 Feb A/P Quarterly maintenance 160.00 2,281.50 BRANDON R REED 3930 AP _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: 985.00 2,281.50 ** 14,000.00 Budgeted 11,718.50 Remaining 16 % Used Account: 135-55085-030-000 Generator Maint. and Repair .00 .00 _______________ Account: 135-55085-030-000 Generator Maint. and Repair Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-55120-030-000 Cleaning Services 838 02/19/2018 February A/P Janitorial services 2,027.95 869.06 2,897.01 MEMBER'S BUILDING MAINTENANCE 3968 AP 994 02/28/2018 Rev Inv 1615/Janitorial DEC AR 20180228-20180228 User: 196.32 3,093.33 AR _______________ Account: 135-55120-030-000 Cleaning Services Totals: 1,065.38 3,093.33 ** 10,000.00 Budgeted 6,906.67 Remaining 31 % Used Account: 135-55160-030-000 Professional Outside Services 56,475.00 .00 56,475.00 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 56,475.00 ** 63,325.00 Budgeted 6,850.00 Remaining 89 % Used Account: 135-55165-030-000 Collection Fees .00 .00 _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-55205-030-000 Utility Billing Contract 917 02/28/2018 February A/P February mailings 2,392.64 581.61 2,974.25 DATAPROSE LLC 3979 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 581.61 2,974.25 ** 9,000.00 Budgeted 6,025.75 Remaining 33 % Used Trophy Club Municipal Utility District No. 1 79 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60005-030-000 Telephone 864 02/23/2018 February A/P AMswering service 5,734.55 194.75 5,929.30 KEYSTONE PARK SECRETARIAL 3963 AP 926 02/26/2018 Pcard 01/27/18 - 02/26/18 ATT*BUS PHONE PMT 453.37 6,382.67 ATT*BUS PHONE PMT PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 ATT*BILL PAYMENT 191.10 6,573.77 ATT*BILL PAYMENT PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 ATT*BUS PHONE PMT 852.62 7,426.39 ATT*BUS PHONE PMT PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 ATT*BILL PAYMENT 128.62 7,555.01 ATT*BILL PAYMENT PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 RINGCENTRAL, INC 13.96 7,568.97 RINGCENTRAL, INC PC 991 02/28/2018 Town Billed Invoices 1624-1627 AR 20180228-20180228 User: (180.00) 7,388.97 AR _______________ Account: 135-60005-030-000 Telephone Totals: 1,654.42 7,388.97 ** 27,300.00 Budgeted 19,911.03 Remaining 27 % Used Account: 135-60010-030-000 Communications/Mobiles 809 02/13/2018 February A/P Mobile phones 1,087.18 87.44 1,174.62 VERIZON WIRELESS 3946 AP 843 02/23/2018 MUD PR 02.23.18 Communications/Mobiles 150.00 1,324.62 PR _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 237.44 1,324.62 ** 4,000.00 Budgeted 2,675.38 Remaining 33 % Used Account: 135-60020-030-000 Electricity/Gas 1,697.60 .00 1,697.60 _______________ Account: 135-60020-030-000 Electricity/Gas Totals: .00 1,697.60 ** 16,261.00 Budgeted 14,563.40 Remaining 10 % Used Account: 135-60025-030-000 Water 917 02/28/2018 February A/P Water-February 227.66 116.19 343.85 TROPHY CLUB MUD (WATER BILLS) 3999 AP 991 02/28/2018 Town Billed Invoices 1624-1627 AR 20180228-20180228 User: (58.09) 285.76 AR _______________ Account: 135-60025-030-000 Water Totals: 58.10 285.76 ** 2,500.00 Budgeted 2,214.24 Remaining 11 % Used Account: 135-60030-030-000 Rent And/Or Usage 616.40 .00 616.40 _______________ Account: 135-60030-030-000 Rent And/Or Usage Totals: .00 616.40 ** .00 Budgeted (616.40) Remaining 0 % Used Account: 135-60035-030-000 Postage Trophy Club Municipal Utility District No. 1 80 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 37 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 809 02/13/2018 February A/P Overnight letter TCEQ 8,024.20 17.14 8,041.34 FEDERAL EXPRESS CORP 3933 AP 926 02/26/2018 Pcard 01/27/18 - 02/26/18 FEDEX 27259600 5.82 8,047.16 FEDEX 27259600 PC 917 02/28/2018 February A/P February mailings 1,604.48 9,651.64 DATAPROSE LLC 3979 AP _______________ Account: 135-60035-030-000 Postage Totals: 1,627.44 9,651.64 ** 30,000.00 Budgeted 20,348.36 Remaining 32 % Used Account: 135-60040-030-000 Service Charges & Fees 747 02/09/2018 Child Support Fee 21,282.89 1.50 21,284.39 GL 844 02/23/2018 Child Support Fee 1.50 21,285.89 GL 917 02/28/2018 February A/P Direct send fees 50.00 21,335.89 Fiserv Solutions, LLC 3981 AP 961 02/28/2018 Pace Credit Card Fees 4,094.24 25,430.13 GL 961 02/28/2018 Pace Credit Card Fees 117.41 25,547.54 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 4,264.65 25,547.54 ** 55,560.00 Budgeted 30,012.46 Remaining 46 % Used Account: 135-60050-030-000 Bad Debt Expense .00 .00 _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60055-030-000 Insurance 236 02/01/2018 Insurance/Wrk Comp Exp Feb 24,401.44 6,100.36 30,501.80 GL 809 02/13/2018 February A/P Bond notary renewal Nicole 201 21.00 30,522.80 OFC OF THE SECRETARY OF STATE 3941 AP 917 02/28/2018 February A/P WC FY 17 adjustment 3,204.00 33,726.80 TML INTERGOVERNMENTAL RISK 3997 AP _______________ Account: 135-60055-030-000 Insurance Totals: 9,325.36 33,726.80 ** 56,000.00 Budgeted 22,273.20 Remaining 60 % Used Account: 135-60066-030-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,600.00 Budgeted 1,600.00 Remaining 0 % Used Account: 135-60070-030-000 Dues & Memberships Trophy Club Municipal Utility District No. 1 81 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 926 02/26/2018 Pcard 01/27/18 - 02/26/18 AMAZONPRIME MEMBERSHIP 3,701.25 107.17 3,808.42 AMAZONPRIME MEMBERSHIP PC _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 107.17 3,808.42 ** 6,000.00 Budgeted 2,191.58 Remaining 63 % Used Account: 135-60075-030-000 Meetings 48.62 .00 48.62 _______________ Account: 135-60075-030-000 Meetings Totals: .00 48.62 ** 400.00 Budgeted 351.38 Remaining 12 % Used Account: 135-60079-030-000 Public Education .00 .00 _______________ Account: 135-60079-030-000 Public Education Totals: .00 .00 ** 6,000.00 Budgeted 6,000.00 Remaining 0 % Used Account: 135-60080-030-000 Schools & Training 926 02/26/2018 Pcard 01/27/18 - 02/26/18 GOVERNMENT FINANCE OFF 2,608.00 85.00 2,693.00 GOVERNMENT FINANCE OFF PC _______________ Account: 135-60080-030-000 Schools & Training Totals: 85.00 2,693.00 ** 7,600.00 Budgeted 4,907.00 Remaining 35 % Used Account: 135-60100-030-000 Travel & per diem 742 02/09/2018 MUD PR 02.09.18 Travel & per diem 469.84 40.61 510.45 PR 843 02/23/2018 MUD PR 02.23.18 Travel & per diem 71.72 582.17 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 112.33 582.17 ** 4,885.00 Budgeted 4,302.83 Remaining 12 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60115-030-000 Elections Trophy Club Municipal Utility District No. 1 82 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 145.00 .00 145.00 _______________ Account: 135-60115-030-000 Elections Totals: .00 145.00 ** 4,500.00 Budgeted 4,355.00 Remaining 3 % Used Account: 135-60125-030-000 Advertising .00 .00 _______________ Account: 135-60125-030-000 Advertising Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-60235-030-000 Security 838 02/19/2018 February A/P Monthly monitoring for panic b 24.00 24.00 48.00 Digital Air Control, Inc 3955 AP _______________ Account: 135-60235-030-000 Security Totals: 24.00 48.00 ** 2,700.00 Budgeted 2,652.00 Remaining 2 % Used Account: 135-60245-030-000 Miscellaneous Expenses 926 02/26/2018 Pcard 01/27/18 - 02/26/18 VCN*DENTONFLOWERMOUNDC 49.50 49.50 VCN*DENTONFLOWERMOUNDC PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 TARRANT CO TX CLERK GR 28.00 77.50 TARRANT CO TX CLERK GR PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 TARRANT CO TX CLERK GR 1.00 78.50 TARRANT CO TX CLERK GR PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 VCN*DENTONRECCTR 44.50 123.00 VCN*DENTONRECCTR PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 CFW PARKING METER 1.50 124.50 CFW PARKING METER PC _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 124.50 124.50 ** 500.00 Budgeted 375.50 Remaining 25 % Used Account: 135-60246-030-000 General Manager Contingency .00 .00 _______________ Account: 135-60246-030-000 General Manager Contingency Totals: .00 .00 ** 17,000.00 Budgeted 17,000.00 Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 211.99 .00 211.99 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 211.99 ** 2,500.00 Budgeted 2,288.01 Remaining 8 % Used Trophy Club Municipal Utility District No. 1 83 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 40 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65010-030-000 Uniforms .00 .00 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 .00 ** 700.00 Budgeted 700.00 Remaining 0 % Used Account: 135-65055-030-000 Hardware 597.95 .00 597.95 _______________ Account: 135-65055-030-000 Hardware Totals: .00 597.95 ** 7,420.00 Budgeted 6,822.05 Remaining 8 % Used Account: 135-65085-030-000 Office Supplies 926 02/26/2018 Pcard 01/27/18 - 02/26/18 AMAZON MKTPLACE PMTS 2,475.55 64.44 2,539.99 AMAZON MKTPLACE PMTS PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 AMAZON MKTPLACE PMTS 10.49 2,550.48 AMAZON MKTPLACE PMTS PC 917 02/28/2018 February A/P Office supplies/Paper 35.63 2,586.11 OFFICE DEPOT, INC 3992 AP 917 02/28/2018 February A/P Carmen office supplies 26.58 2,612.69 OFFICE DEPOT, INC 3992 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 137.14 2,612.69 ** 7,000.00 Budgeted 4,387.31 Remaining 37 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 1,903.05 .00 1,903.05 _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 1,903.05 ** 2,000.00 Budgeted 96.95 Remaining 95 % Used Account: 135-65095-030-000 Maintenance Supplies 926 02/26/2018 Pcard 01/27/18 - 02/26/18 STAPLES DIRECT 1,729.49 82.21 1,811.70 STAPLES DIRECT PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 AMAZON MKTPLACE PMTS 92.28 1,903.98 AMAZON MKTPLACE PMTS PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 TOM THUMB #1789 7.47 1,911.45 TOM THUMB #1789 PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 SAMSCLUB #4795 37.23 1,948.68 SAMSCLUB #4795 PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 SAMS CLUB #4795 27.84 1,976.52 SAMS CLUB #4795 PC 926 02/26/2018 Pcard 01/27/18 - 02/26/18 AMAZON MKTPLACE PMTS 18.67 1,995.19 AMAZON MKTPLACE PMTS PC 917 02/28/2018 February A/P Kitchen supplies 41.68 2,036.87 OFFICE DEPOT, INC 3992 AP 917 02/28/2018 February A/P Office supplies 24.99 2,061.86 OFFICE DEPOT, INC 3992 AP _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 332.37 2,061.86 ** 4,000.00 Budgeted 1,938.14 Remaining 52 % Used Trophy Club Municipal Utility District No. 1 84 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65105-030-000 Printing 144.00 .00 144.00 _______________ Account: 135-65105-030-000 Printing Totals: .00 144.00 ** 4,000.00 Budgeted 3,856.00 Remaining 4 % Used Account: 135-69005-030-000 Capital Outlays 7,841.00 .00 7,841.00 _______________ Account: 135-69005-030-000 Capital Outlays Totals: .00 7,841.00 ** 13,000.00 Budgeted 5,159.00 Remaining 60 % Used Account: 135-69170-030-000 Copier Lease Installments 809 02/13/2018 February A/P Copier lease payment 971.23 165.00 1,136.23 EVERBANK COMMERCIAL FINANCE 3932 AP 864 02/23/2018 February A/P Copies/Lease 92.79 1,229.02 KYOCERA DOCUMENT SOLUTIONS 3964 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 257.79 1,229.02 ** 4,600.00 Budgeted 3,370.98 Remaining 27 % Used Department 30 Totals: ----------------------------------- 489,143.86 ** 71,305.54 Monthly Total 1,227,112.00 Budgeted 737,968.14 Remaining 40 % Used Trophy Club Municipal Utility District No. 1 85 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55045-039-000 Legal 29,343.55 .00 29,343.55 _______________ Account: 135-55045-039-000 Legal Totals: .00 29,343.55 ** 137,000.00 Budgeted 107,656.45 Remaining 21 % Used Account: 135-55055-039-000 Auditing 25,508.70 .00 25,508.70 _______________ Account: 135-55055-039-000 Auditing Totals: .00 25,508.70 ** 24,500.00 Budgeted (1,008.70) Remaining 104 % Used Account: 135-55060-039-000 Appraisal 4,660.18 .00 4,660.18 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 4,660.18 ** 11,446.00 Budgeted 6,785.82 Remaining 41 % Used Account: 135-55065-039-000 Tax Admin Fees 2,968.40 .00 2,968.40 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,968.40 ** 3,800.00 Budgeted 831.60 Remaining 78 % Used Department 39 Totals: ----------------------------------- 62,480.83 ** .00 Monthly Total 176,746.00 Budgeted 114,265.17 Remaining 35 % Used Fund 135 Totals: ----------------------------------- (401,170.45) (78,755.33) Monthly Total (194,618.00) Budgeted 206,552.45 Remaining 206 % Used Trophy Club Municipal Utility District No. 1 86 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 43 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-49145-000-000 Intergov Transfer-General Fund (105,000.00) .00 (105,000.00) _______________ Account: 137-49145-000-000 Intergov Transfer-General Fund Totals: .00 (105,000.00) ** .00 Budgeted 105,000.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer-Fire Dept (81,420.00) .00 (81,420.00) _______________ Account: 137-49146-000-000 Intergov Transfer-Fire Dept Totals: .00 (81,420.00) ** .00 Budgeted 81,420.00 Remaining 0 % Used Department Totals: ----------------------------------- (186,420.00) ** .00 Monthly Total .00 Budgeted 186,420.00 Remaining 0 % Used Fund 137 Totals: ----------------------------------- (186,420.00) .00 Monthly Total .00 Budgeted 186,420.00 Remaining 0 % Used Trophy Club Municipal Utility District No. 1 87 of 130 March 20, 2018 Agenda Packet AMENDED** TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET FEBRUARY 2018 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 1,265,672 ACCOUNTS RECEIVABLE - TOTAL ASSETS 1,265,672 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 915,238 TOTAL LIABILITIES 915,238 FUND BALANCE ASSIGNED FUND BALANCE 992,579 NET REVENUES / EXPENDITURES (642,145) TOTAL FUND BALANCE 350,434 TOTAL LIABILITIES AND FUND BALANCE 1,265,672 Trophy Club Municipal Utility District No. 1 88 of 130 March 20, 2018 Agenda Packet AMENDED** . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 14 22:56 03/15/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 2/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 1,337.62- 7,198.78- 7,198.78 Subtotal: 1,337.62- 7,198.78- 7,198.78 Program number: 1,337.62- 7,198.78- 7,198.78 Department number: Revenues 1,337.62- 7,198.78- 7,198.78 Revenues Subtotal ----------- 1,337.62- 7,198.78- 7,198.78 Trophy Club Municipal Utility District No. 1 89 of 130 March 20, 2018 Agenda Packet AMENDED** . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 15 22:56 03/15/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 2/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-69005-020-000 Capital Outlays 269,347.88 649,344.16 649,344.16- Subtotal: 269,347.88 649,344.16 649,344.16- Program number: 269,347.88 649,344.16 649,344.16- Department number: Wastewater 269,347.88 649,344.16 649,344.16- Expenditures Subtotal ----------- 269,347.88 649,344.16 649,344.16- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 268,010.26 642,145.38 642,145.38- Trophy Club Municipal Utility District No. 1 90 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 44 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-49010-000-000 Interest Income 978 02/28/2018 Bank Interest- February (5,861.16) (1,337.62) (7,198.78) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (1,337.62) (7,198.78) ** .00 Budgeted 7,198.78 Remaining 0 % Used Department Totals: ----------------------------------- (7,198.78) ** (1,337.62) Monthly Total .00 Budgeted 7,198.78 Remaining 0 % Used Trophy Club Municipal Utility District No. 1 91 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-69005-020-000 Capital Outlays 917 02/28/2018 February A/P Application 25-WWTP Improvemen 379,996.28 234,790.02 614,786.30 WEBBER-CADAGUA PARTNERS 4001 AP 884 02/28/2018 Correct Fund Cap Out- 135-517 34,557.86 649,344.16 GL _______________ Account: 517-69005-020-000 Capital Outlays Totals: 269,347.88 649,344.16 ** .00 Budgeted (649,344.16) Remaining 0 % Used Department 20 Totals: ----------------------------------- 649,344.16 ** 269,347.88 Monthly Total .00 Budgeted (649,344.16) Remaining 0 % Used Fund 517 Totals: ----------------------------------- 642,145.38 268,010.26 Monthly Total .00 Budgeted (642,145.38) Remaining 0 % Used Trophy Club Municipal Utility District No. 1 92 of 130 March 20, 2018 Agenda Packet AMENDED** TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION SWIFT FUNDING BALANCE SHEET FEBRUARY 2018 519 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - CASH IN ESCROW 4,496,529 INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS 4,496,529 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 270,948 TOTAL LIABILITIES 270,948 FUND BALANCE ASSIGNED FUND BALANCE 4,225,581 NET REVENUES / EXPENDITURES - TOTAL FUND BALANCE 4,225,581 TOTAL LIABILITIES AND FUND BALANCE 4,496,529 Trophy Club Municipal Utility District No. 1 93 of 130 March 20, 2018 Agenda Packet AMENDED** TROPHY CLUB MUD #1 - 16" WATERLINE FUTURE REVENUE BOND BALANCE SHEET FEBRUARY 2018 520 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS - LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 39,899 TOTAL LIABILITIES 39,899 FUND BALANCE ASSIGNED FUND BALANCE (39,899) NET REVENUES / EXPENDITURES - TOTAL FUND BALANCE (39,899) TOTAL LIABILITIES AND FUND BALANCE 0 Trophy Club Municipal Utility District No. 1 94 of 130 March 20, 2018 Agenda Packet AMENDED** TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET FEBRUARY 2018 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 500,619 ACCOUNTS RECEIVABLE - TOTAL ASSETS 500,619 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 426,578 NET REVENUES / EXPENDITURES 74,041 TOTAL FUND BALANCE 500,619 TOTAL LIABILITIES AND FUND BALANCE 500,619 Trophy Club Municipal Utility District No. 1 95 of 130 March 20, 2018 Agenda Packet AMENDED** . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 16 22:56 03/15/18 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 2/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49010-000-000 Interest Income 1,000.00- 1,000.00- 501.27- 2,235.95- 223.595 1,235.95 528-49142-000-000 Interfund transfer in-Water 48,996.00- 48,996.00- 4,083.00- 20,415.00- 41.667 28,581.00- 528-49143-000-000 Interfund transfer in-WW 123,336.00- 123,336.00- 10,278.00- 51,390.00- 41.667 71,946.00- Subtotal: 173,332.00- 173,332.00- 14,862.27- 74,040.95- 42.716 99,291.05- Program number: 173,332.00- 173,332.00- 14,862.27- 74,040.95- 42.716 99,291.05- Department number: 173,332.00- 173,332.00- 14,862.27- 74,040.95- 42.716 99,291.05- Revenues Subtotal ----------- 173,332.00- 173,332.00- 14,862.27- 74,040.95- 42.716 99,291.05- Fund number: 528 2015 Revenue Bond Reserve Fund 173,332.00- 173,332.00- 14,862.27- 74,040.95- 42.716 99,291.05- Trophy Club Municipal Utility District No. 1 96 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 528-49010-000-000 Interest Income 978 02/28/2018 Bank Interest- February (1,734.68) (501.27) (2,235.95) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (501.27) (2,235.95) ** (1,000.00) Budgeted 1,235.95 Remaining 224 % Used Account: 528-49142-000-000 Interfund transfer in-Water 962 02/28/2018 Texpool Transfers Feb (16,332.00) (4,083.00) (20,415.00) GL _______________ Account: 528-49142-000-000 Interfund transfer in-Water Totals: (4,083.00) (20,415.00) ** (48,996.00) Budgeted (28,581.00) Remaining 42 % Used Account: 528-49143-000-000 Interfund transfer in-WW 962 02/28/2018 Texpool Transfers Feb (41,112.00) (10,278.00) (51,390.00) GL _______________ Account: 528-49143-000-000 Interfund transfer in-WW Totals: (10,278.00) (51,390.00) ** (123,336.00) Budgeted (71,946.00) Remaining 42 % Used Department Totals: ----------------------------------- (74,040.95) ** (14,862.27) Monthly Total (173,332.00) Budgeted (99,291.05) Remaining 43 % Used Fund 528 Totals: ----------------------------------- (74,040.95) (14,862.27) Monthly Total (173,332.00) Budgeted (99,291.05) Remaining 43 % Used Trophy Club Municipal Utility District No. 1 97 of 130 March 20, 2018 Agenda Packet AMENDED** TROPHY CLUB MUD #1 - I&S BALANCE SHEET FEBRUARY 2018 INTEREST & SINKING- 533 ASSETS CASH IN BANK 4,573 INVESTMENTS 819,493 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 34,688 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 858,754 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 34,688 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 34,688 FUND BALANCE ASSIGNED FUND BALANCE 32,341 NET REVENUES / EXPENDITURES 791,725 TOTAL FUND BALANCE 824,066 TOTAL LIABILITIES AND FUND BALANCE 858,754 Trophy Club Municipal Utility District No. 1 98 of 130 March 20, 2018 Agenda Packet AMENDED** . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 17 22:56 03/15/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 2/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 669,660.00- 669,660.00- 40,419.77- 655,242.10- 97.847 14,417.90- 533-40002-000-000 Property Taxes/Delinquent 1,800.00- 1,800.00- 28.93- 1,883.81- 104.656 83.81 533-40015-000-000 Property Taxes/P & I 2,000.00- 2,000.00- 313.15- 590.42- 29.521 1,409.58- Subtotal: 673,460.00- 673,460.00- 40,761.85- 657,716.33- 97.662 15,743.67- 533-49010-000-000 Interest Income 2,000.00- 2,000.00- 715.01- 1,534.06- 76.703 465.94- 533-49015-000-000 Lease/Rental Income 218,954.00- 218,954.00- 218,954.00- 218,954.00- 100.000 533-49141-000-000 Interfund Trans In-PID Surchg 122,043.00- 122,043.00- 11,094.81- 55,474.05- 45.455 66,568.95- Subtotal: 342,997.00- 342,997.00- 230,763.82- 275,962.11- 80.456 67,034.89- Program number: 1,016,457.00- 1,016,457.00- 271,525.67- 933,678.44- 91.856 82,778.56- Department number: Revenues 1,016,457.00- 1,016,457.00- 271,525.67- 933,678.44- 91.856 82,778.56- Revenues Subtotal ----------- 1,016,457.00- 1,016,457.00- 271,525.67- 933,678.44- 91.856 82,778.56- Trophy Club Municipal Utility District No. 1 99 of 130 March 20, 2018 Agenda Packet AMENDED** . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 18 22:56 03/15/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 2/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 2,150.00 2,150.00 200.00 200.00 9.302 1,950.00 533-70025-051-000 Bond Interest Expense-Tax 283,508.00 283,508.00 141,753.75 141,753.75 50.000 141,754.25 533-70035-051-000 Bond Principal Payment-Tax 725,000.00 725,000.00 725,000.00 Subtotal: 1,010,658.00 1,010,658.00 141,953.75 141,953.75 14.046 868,704.25 Program number: 1,010,658.00 1,010,658.00 141,953.75 141,953.75 14.046 868,704.25 Department number: Administration 1,010,658.00 1,010,658.00 141,953.75 141,953.75 14.046 868,704.25 Expenditures Subtotal ----------- 1,010,658.00 1,010,658.00 141,953.75 141,953.75 14.046 868,704.25 Fund number: 533 MUD 1 I&S Consolidated 5,799.00- 5,799.00- 129,571.92- 791,724.69- ############### 785,925.69 Trophy Club Municipal Utility District No. 1 100 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 47 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 Property Taxes 939 02/01/2018 Property Taxes (614,822.33) (5,842.56) (620,664.89) GL 940 02/02/2018 Property Taxes (16,326.31) (636,991.20) GL 941 02/05/2018 Property Taxes (4,672.78) (641,663.98) GL 942 02/06/2018 Property Taxes (2,667.84) (644,331.82) GL 943 02/07/2018 Property Taxes (7,341.19) (651,673.01) GL 944 02/09/2018 Property Taxes (264.14) (651,937.15) GL 945 02/13/2018 Property Taxes (128.55) (652,065.70) GL 946 02/14/2018 Property Taxes (259.60) (652,325.30) GL 947 02/16/2018 Property Taxes (290.18) (652,615.48) GL 948 02/20/2018 Property Taxes (710.22) (653,325.70) GL 949 02/21/2018 Property Taxes (13.34) (653,339.04) GL 950 02/22/2018 Property Taxes (15.26) (653,354.30) GL 951 02/23/2018 Property Taxes (6.41) (653,360.71) GL 952 02/26/2018 Property Taxes (973.97) (654,334.68) GL 953 02/27/2018 Property Taxes (315.56) (654,650.24) GL 954 02/28/2018 Property Taxes (591.86) (655,242.10) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (40,419.77) (655,242.10) ** (669,660.00) Budgeted (14,417.90) Remaining 98 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 939 02/01/2018 Property Taxes (1,854.88) (3.80) (1,858.68) GL 940 02/02/2018 Property Taxes (.16) (1,858.84) GL 945 02/13/2018 Property Taxes (18.87) (1,877.71) GL 946 02/14/2018 Property Taxes (6.10) (1,883.81) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (28.93) (1,883.81) ** (1,800.00) Budgeted 83.81 Remaining 105 % Used Account: 533-40015-000-000 Property Taxes/P & I 939 02/01/2018 Property Taxes (277.27) (6.89) (284.16) GL 940 02/02/2018 Property Taxes (.02) (284.18) GL 942 02/06/2018 Property Taxes (32.56) (316.74) GL 943 02/07/2018 Property Taxes (17.46) (334.20) GL 944 02/09/2018 Property Taxes (13.79) (347.99) GL 945 02/13/2018 Property Taxes (13.71) (361.70) GL 946 02/14/2018 Property Taxes (19.40) (381.10) GL 947 02/16/2018 Property Taxes (26.26) (407.36) GL 948 02/20/2018 Property Taxes (49.70) (457.06) GL 949 02/21/2018 Property Taxes (.93) (457.99) GL Trophy Club Municipal Utility District No. 1 101 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 48 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 951 02/23/2018 Property Taxes (277.27) (.75) (458.74) GL 952 02/26/2018 Property Taxes (68.16) (526.90) GL 953 02/27/2018 Property Taxes (22.10) (549.00) GL 954 02/28/2018 Property Taxes (41.42) (590.42) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (313.15) (590.42) ** (2,000.00) Budgeted (1,409.58) Remaining 30 % Used Account: 533-49010-000-000 Interest Income 978 02/28/2018 Bank Interest- February (819.05) (715.01) (1,534.06) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (715.01) (1,534.06) ** (2,000.00) Budgeted (465.94) Remaining 77 % Used Account: 533-49015-000-000 Lease/Rental Income 962 02/28/2018 Texpool Transfers Feb (218,954.00) (218,954.00) GL _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: (218,954.00) (218,954.00) ** (218,954.00) Budgeted .00 Remaining 100 % Used Account: 533-49141-000-000 Interfund Trans In-PID Surchg 962 02/28/2018 Texpool Transfers Feb (44,379.24) (11,094.81) (55,474.05) GL _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (11,094.81) (55,474.05) ** (122,043.00) Budgeted (66,568.95) Remaining 45 % Used Department Totals: ----------------------------------- (933,678.44) ** (271,525.67) Monthly Total (1,016,457.00) Budgeted (82,778.56) Remaining 92 % Used Trophy Club Municipal Utility District No. 1 102 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-70005-051-000 Paying Agent Fee 863 02/23/2018 3/1/18 Bond Payments INTEREST BOKF Unl Tax Bond, 1TROP1214UT 200.00 200.00 GL _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: 200.00 200.00 ** 2,150.00 Budgeted 1,950.00 Remaining 9 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax 863 02/23/2018 3/1/18 Bond Payments INTEREST BOKF Unl Tax Bond, 1TROP1214UT 70,600.00 70,600.00 GL 863 02/23/2018 3/1/18 Bond Payments INTEREST BNY MELLON Unl Tax Series 2010 32,928.75 103,528.75 GL 863 02/23/2018 3/1/18 Bond Payments INTEREST BNYMELLON Unl Tax Ref Ser 2012 19,612.50 123,141.25 GL 863 02/23/2018 3/1/18 Bond Payments INTEREST BNYMELLON Unl Tax Ref Ser 2013 18,612.50 141,753.75 GL _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: 141,753.75 141,753.75 ** 283,508.00 Budgeted 141,754.25 Remaining 50 % Used Account: 533-70035-051-000 Bond Principal Payment-Tax .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment-Tax Totals: .00 .00 ** 725,000.00 Budgeted 725,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- 141,953.75 ** 141,953.75 Monthly Total 1,010,658.00 Budgeted 868,704.25 Remaining 14 % Used Fund 533 Totals: ----------------------------------- (791,724.69) (129,571.92) Monthly Total (5,799.00) Budgeted 785,925.69 Remaining ########## Trophy Club Municipal Utility District No. 1 103 of 130 March 20, 2018 Agenda Packet AMENDED** TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET FEBRUARY 2018 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 177,130 ACCOUNTS RECEIVABLE - TOTAL ASSETS 177,130 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 16,210 NET REVENUES / EXPENDITURES 160,920 TOTAL FUND BALANCE 177,130 TOTAL LIABILITIES AND FUND BALANCE 177,130 Trophy Club Municipal Utility District No. 1 104 of 130 March 20, 2018 Agenda Packet AMENDED** . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 19 22:56 03/15/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 2/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-49010-000-000 Interest Income 1,000.00- 1,000.00- 218.38- 634.76- 63.476 365.24- 534-49143-000-000 Interfund Transfer In-WW Sales 598,738.00- 598,738.00- 54,430.72- 272,153.60- 45.455 326,584.40- Subtotal: 599,738.00- 599,738.00- 54,649.10- 272,788.36- 45.485 326,949.64- Program number: 599,738.00- 599,738.00- 54,649.10- 272,788.36- 45.485 326,949.64- Department number: Revenues 599,738.00- 599,738.00- 54,649.10- 272,788.36- 45.485 326,949.64- Revenues Subtotal ----------- 599,738.00- 599,738.00- 54,649.10- 272,788.36- 45.485 326,949.64- Trophy Club Municipal Utility District No. 1 105 of 130 March 20, 2018 Agenda Packet AMENDED** . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 20 22:56 03/15/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 2/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-70005-051-000 Rev Bond Paying Agent Fee 400.00 400.00 200.00 200.00 50.000 200.00 534-70040-051-000 Revenue Bond Interest Expense 223,338.00 223,338.00 111,668.75 111,668.75 50.000 111,669.25 534-70045-051-000 Revenue Bond Principal Expense 375,000.00 375,000.00 375,000.00 Subtotal: 598,738.00 598,738.00 111,868.75 111,868.75 18.684 486,869.25 Program number: 598,738.00 598,738.00 111,868.75 111,868.75 18.684 486,869.25 Department number: Administration 598,738.00 598,738.00 111,868.75 111,868.75 18.684 486,869.25 Expenditures Subtotal ----------- 598,738.00 598,738.00 111,868.75 111,868.75 18.684 486,869.25 Fund number: 534 2015 Revenue Bond I&S 1,000.00- 1,000.00- 57,219.65 160,919.61- ############### 159,919.61 Trophy Club Municipal Utility District No. 1 106 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 50 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-49010-000-000 Interest Income 978 02/28/2018 Bank Interest- February (416.38) (218.38) (634.76) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (218.38) (634.76) ** (1,000.00) Budgeted (365.24) Remaining 63 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales 962 02/28/2018 Texpool Transfers Feb (217,722.88) (54,430.72) (272,153.60) GL _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (54,430.72) (272,153.60) ** (598,738.00) Budgeted (326,584.40) Remaining 45 % Used Department Totals: ----------------------------------- (272,788.36) ** (54,649.10) Monthly Total (599,738.00) Budgeted (326,949.64) Remaining 45 % Used Trophy Club Municipal Utility District No. 1 107 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 51 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-70005-051-000 Rev Bond Paying Agent Fee 863 02/23/2018 3/1/18 Bond Payments INTEREST BOKF Rev Bond WWTP 1TROP215WSS 200.00 200.00 GL _______________ Account: 534-70005-051-000 Rev Bond Paying Agent Fee Totals: 200.00 200.00 ** 400.00 Budgeted 200.00 Remaining 50 % Used Account: 534-70040-051-000 Revenue Bond Interest Expense 863 02/23/2018 3/1/18 Bond Payments INTEREST BOKF Rev Bond WWTP 1TROP215WSS 111,668.75 111,668.75 GL _______________ Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: 111,668.75 111,668.75 ** 223,338.00 Budgeted 111,669.25 Remaining 50 % Used Account: 534-70045-051-000 Revenue Bond Principal Expense .00 .00 _______________ Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 ** 375,000.00 Budgeted 375,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- 111,868.75 ** 111,868.75 Monthly Total 598,738.00 Budgeted 486,869.25 Remaining 19 % Used Fund 534 Totals: ----------------------------------- (160,919.61) 57,219.65 Monthly Total (1,000.00) Budgeted 159,919.61 Remaining ########## Trophy Club Municipal Utility District No. 1 108 of 130 March 20, 2018 Agenda Packet AMENDED** TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET FEBRUARY 2018 535 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS 96,079 ACCOUNTS RECEIVABLE - TOTAL ASSETS 96,079 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 952 NET REVENUES / EXPENDITURES 95,127 TOTAL FUND BALANCE 96,079 TOTAL LIABILITIES AND FUND BALANCE 96,079 Trophy Club Municipal Utility District No. 1 109 of 130 March 20, 2018 Agenda Packet AMENDED** . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 21 22:56 03/15/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 2/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-49010-000-000 Interest Income 600.00- 600.00- 99.20- 267.34- 44.557 332.66- 535-49142-000-000 Interfund Tran In-Water Sales 278,084.00- 278,084.00- 25,280.31- 126,401.55- 45.454 151,682.45- Subtotal: 278,684.00- 278,684.00- 25,379.51- 126,668.89- 45.453 152,015.11- Program number: 278,684.00- 278,684.00- 25,379.51- 126,668.89- 45.453 152,015.11- Department number: Revenues 278,684.00- 278,684.00- 25,379.51- 126,668.89- 45.453 152,015.11- Revenues Subtotal ----------- 278,684.00- 278,684.00- 25,379.51- 126,668.89- 45.453 152,015.11- Trophy Club Municipal Utility District No. 1 110 of 130 March 20, 2018 Agenda Packet AMENDED** . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 22 22:56 03/15/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 2/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-70005-051-000 Rev Bond Paying Agent Fee 400.00 400.00 200.00 200.00 50.000 200.00 535-70040-051-000 Revenue Bond Interest Expense 62,684.00 62,684.00 31,341.75 31,341.75 50.000 31,342.25 535-70045-051-000 Revenue Bond Principal Expense 215,000.00 215,000.00 215,000.00 Subtotal: 278,084.00 278,084.00 31,541.75 31,541.75 11.343 246,542.25 Program number: 278,084.00 278,084.00 31,541.75 31,541.75 11.343 246,542.25 Department number: Administration 278,084.00 278,084.00 31,541.75 31,541.75 11.343 246,542.25 Expenditures Subtotal ----------- 278,084.00 278,084.00 31,541.75 31,541.75 11.343 246,542.25 Fund number: 535 2016 Rev Bond I&S-SWIFT 600.00- 600.00- 6,162.24 95,127.14- ############### 94,527.14 ******* End of Report ********* Trophy Club Municipal Utility District No. 1 111 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 52 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 535-49010-000-000 Interest Income 978 02/28/2018 Bank Interest- February (168.14) (99.20) (267.34) GL _______________ Account: 535-49010-000-000 Interest Income Totals: (99.20) (267.34) ** (600.00) Budgeted (332.66) Remaining 45 % Used Account: 535-49142-000-000 Interfund Tran In-Water Sales 962 02/28/2018 Texpool Transfers Feb (101,121.24) (25,280.31) (126,401.55) GL _______________ Account: 535-49142-000-000 Interfund Tran In-Water Sales Totals: (25,280.31) (126,401.55) ** (278,084.00) Budgeted (151,682.45) Remaining 45 % Used Department Totals: ----------------------------------- (126,668.89) ** (25,379.51) Monthly Total (278,684.00) Budgeted (152,015.11) Remaining 45 % Used Trophy Club Municipal Utility District No. 1 112 of 130 March 20, 2018 Agenda Packet AMENDED** . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 53 22:57 03/15/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 2/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 535-70005-051-000 Rev Bond Paying Agent Fee 863 02/23/2018 3/1/18 Bond Payments INTEREST BOKF SWIFT 1TROP1116WSS 200.00 200.00 GL _______________ Account: 535-70005-051-000 Rev Bond Paying Agent Fee Totals: 200.00 200.00 ** 400.00 Budgeted 200.00 Remaining 50 % Used Account: 535-70040-051-000 Revenue Bond Interest Expense 863 02/23/2018 3/1/18 Bond Payments INTEREST BOKF SWIFT 1TROP1116WSS 31,341.75 31,341.75 GL _______________ Account: 535-70040-051-000 Revenue Bond Interest Expense Totals: 31,341.75 31,341.75 ** 62,684.00 Budgeted 31,342.25 Remaining 50 % Used Account: 535-70045-051-000 Revenue Bond Principal Expense .00 .00 _______________ Account: 535-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 ** 215,000.00 Budgeted 215,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- 31,541.75 ** 31,541.75 Monthly Total 278,084.00 Budgeted 246,542.25 Remaining 11 % Used Fund 535 Totals: ----------------------------------- (95,127.14) 6,162.24 Monthly Total (600.00) Budgeted 94,527.14 Remaining ########## Grand Totals: --------------------------------------------------------------------------------------------------------- (1,415,206.99) **** 314,936.73 Monthly Total (375,349.00) Budgeted 1,039,857.99 Remaining 377 % Used ******* End of Report ********* Trophy Club Municipal Utility District No. 1 113 of 130 March 20, 2018 Agenda Packet AMENDED** BUDGET VARIANCE REPORT FUND:122 - Fire O&M FINANCIALS MONTH:February 2018 REVENUE VARIANCE:33.2% EXPENSE VARIANCE:51.5% NOTE: ACCOUNT DESCRIPTION TOTAL BUDGET CURRENT MONTH YTD TOTAL YTD % DATE OF COMMENT VARIANCE EXPLANATION FIRE REVENUES 122-40010 Property Taxes/Fire 1,054,433 63,645 1,031,746 97.848%10/2017 Property Taxes collected 122-40011 Property Taxes/Fire - Delinquent 46 2,874 10/2017 Delinquent Fire Taxes collected 122-40020 Property Taxes/Fire P&I 542 2,404 10/2017 Fire Taxes Penalties &Interest collected FIRE EXPENSES 122-60030-045 Rent 218,954 218,954 218,954 100.000%02/2018 Annual Rent 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 114 of 130 March 20, 2018 Agenda Packet AMENDED** BUDGET VARIANCE REPORT FUND:135 - MUD 1 O&M FINANCIALS MONTH:February 2018 REVENUE VARIANCE:33.2% EXPENSE VARIANCE:51.5% NOTE: ACCOUNT DESCRIPTION TOTAL BUDGET CURRENT MONTH YTD TOTAL YTD % DATE OF COMMENT VARIANCE EXPLANATION REVENUE 135-47000-000 Water 6,464,019 318,713 1,894,036 29.30%01/2018 Water Sales 135-47030-000 Service Charges 21,350 1,100 5,975 27.99%01/2018 Service Charges 135-47070-000 TCCC Effluent Charges 60,000 358 9,476 15.79%11/2017 TCCC Effluent Collected EXPENSES WATER 135-55090-010 Vehicle Maintenance 4,000 240 2,817 70.43%02/2018 Discount Tires & Gierisch WASTEWATER 135-55125-020 Dumpster Services 60,000 4,174 35,703 59.51%01/2018 L.H. Chaney- Haul offs 135-55135-020 Lab Analysis 30,000 1,934 16,463 54.88%01/2018 Lab 135-65035-020 Small Tools 1,000 35 1,118 111.82%02/2018 Home Depot BOARD OF DIRECTORS 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 115 of 130 March 20, 2018 Agenda Packet AMENDED** BUDGET VARIANCE REPORT FUND:135 - MUD 1 O&M FINANCIALS MONTH:February 2018 REVENUE VARIANCE:33.2% EXPENSE VARIANCE:51.5% 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 ADMINISTRATION 135-55030-030 Software and Support 78,391$ 3,249$ 43,129$ 55.02%02/2018 STW Vison License,AT&T, M3, Adobe 135-60055-030 Insurance 56,000$ 9,325$ 33,727$ 60.23%02/2018 TML WC True-Up Adjustment FY17 135-60070-030 Dues and Memberships 6,000$ 107$ 3,808$ 63.47%02/2018 Amazon Prime Non-Departmental Trophy Club Municipal Utility District No. 1 116 of 130 March 20, 2018 Agenda Packet AMENDED** Trophy Club Municipal Utility District No. 1    Date:  3/20/2018  To:  Board of Directors  From:  John Robert Carman  Subject: General Manager’s Report    Regulatory Updates  Sanitary Sewer Overflows (SSO) – A sanitary sewer overflow occurred on February 27, 2018 at  Lift Station #2 (LS2).  The cause was loss of power to the pumps, caused by a short in the power  feed from the Oncor transformer to the pumps.  This power loss was first noted at 9:09 PM on  February 26 when a high level alarm was sent by the system to the oncall operator.  Power was  restored to the lift station at 2:00 PM on February 27, after Oncor installed a new transformer  and our contractor (Walker Electric) installed a temporary new feed from the transformer.   During the power failure, the team manually vacuumed sewage from the wet well at the LS2  and transported it to the waste water treatment plant.  The sewage transport routine got behind as the morning diurnal peak was experienced and a  spill was observed from 8:10 AM until 10:40 AM on February 27, 2018.  The spill volume during  this time was estimated to be 600 gallons.  The spill was reported to TCEQ verbally within the  24 hour period and in writing the next day.  Breaks and Leaks – On March 12th 2018, a saddle came off the water main on Panorama Trail.   After isolating the main segment, the saddle was excavated and repaired.  Bacteria samples  were taken as required by TCEQ.  Samples were processed by a certified laboratory and came  back negative (no bacteria were found).  Permit Renewal Settlement Agreement – The application for technical, financial and regulatory  compliance assistance through the free TCEQ program for technical support has been prepared  and was submitted to TCEQ on March 7, 2018.  TCEQ has acknowledged receipt of the  application for assistance and subsequently assigned the technical peer review portion of the  assistance to the Texas Rural Water Association (TRWA).  A TRWA representative has scheduled  an onsite visit to the plant on May 30th and May 31st, 2018.  Classification and Compensation Study ‐ Segal Waters Consulting has the letters and position  updated position descriptions.   Preliminary survey results are expected in mid‐April, 2018    Trophy Club Municipal Utility District No. 1 117 of 130 March 20, 2018 Agenda Packet AMENDED** Capital Improvement Projects   16 Inch Water Line Project Phase 1 – With recent approval to proceed with the PD30  development, Phase 1 of the 16 inch interconnecting pipeline project is currently being  advertised for bids.  This segment, which was already designed and awaiting the start of the  development, will start at the ground storage tanks and extend just past Trophy Club Drive to  the edge of the development.  Bid opening is expected on April 6th, 2018.  WWTP – Substantial completion for Phase 1 and Phase 2 of the Wastewater Treatment Plant  upgrade project have been issued.  Phase 3 is underway.   High Service Booster Pump – Our engineer on this project is continuing dialog with the low  bidder on this project to explore ways to reduce the cost.  We should have an update and  recommended course for action for the March 20th, 2018 Board meeting.  Joint Projects with Town  The project has begun on Phoenix Drive and installation and testing of the temporary water  service lines has been initiated.  Trophy Club Municipal Utility District No. 1 118 of 130 March 20, 2018 Agenda Packet AMENDED** FY October November December January February March April May June July August September Total Year 2008 63,250 47,082 33,371 37,194 31,472 30,766 40,313 48,829 78,091 91,664 115,042 75,494 692,568 2009 63,730 48,170 35,215 35,759 32,240 39,331 46,151 37,382 56,370 125,089 91,724 79,137 690,298 2010 39,794 39,713 29,547 30,305 25,328 23,279 41,646 53,439 102,921 89,760 128,687 82,331 686,750 2011 70,502 50,909 44,365 35,983 27,845 55,972 69,165 61,467 99,326 117,707 170,464 123,692 927,397 2012 85,869 53,571 40,815 30,616 31,665 35,263 47,194 84,905 114,104 137,174 144,573 108,622 914,371 2013 85,488 75,251 48,527 39,601 34,450 43,137 56,947 76,542 85,312 110,072 130,945 114,497 900,769 2014 82,660 48,813 34,482 39,767 37,085 54,794 66,337 84,384 99,240 92,913 113,135 110,873 864,483 2015 90,994 58,986 49,607 36,162 38,776 30,566 46,543 39,576 60,731 100,622 139,441 123,886 815,890 2016 108,951 41,936 39,028 39,622 44,551 49,498 55,181 50,827 65,390 115,687 119,611 98,945 829,227 2017 74,785 68,638 38,580 33,028 38,380 60,841 56,683 86,794 98,864 95,355 104,303 99,541 855,792 2018 83,228 69,099 48,144 34,592 40,658 275,721 FY October November December January February March April May June July August September Total Year 2008 64,370 50,090 35,320 36,610 34,630 34,750 42,900 63,116 78,399 114,256 98,670 72,551 725,662 2009 65,110 48,570 36,411 36,587 36,385 44,120 48,881 38,250 66,450 116,823 94,525 81,500 713,612 2010 40,803 41,600 32,700 31,400 30,145 27,240 43,400 62,646 113,049 94,950 131,650 76,159 725,742 2011 70,502 50,993 44,220 33,789 36,053 54,775 71,306 63,500 116,350 152,002 169,621 117,190 980,301 2012 83,750 54,245 41,650 34,740 31,581 46,519 62,649 100,402 110,324 153,813 139,005 123,045 981,723 2013 85,966 77,758 55,110 39,283 37,867 56,743 60,969 87,168 96,602 119,414 145,988 120,342 983,210 2014 81,909 51,769 39,769 48,758 42,395 61,100 71,283 96,481 95,206 110,173 123,369 115,607 937,819 2015 106,251 67,825 58,659 45,691 39,675 35,752 56,704 48,637 72,934 117,302 143,413 142,394 935,237 2016 106,731 52,616 43,708 46,945 50,721 55,178 60,434 55,562 68,138 112,533 128,963 104,664 886,193 2017 82,677 77,937 43,792 43,207 43,024 69,549 65,723 94,452 103,867 101,184 114,872 109,769 950,053 2018 91,439 78,282 55,745 40,796 40,750 307,012 FY October November December January February March April May June July August September 2008 2869 2857 2867 2853 2865 2865 2855 2897 2897 2914 2927 2929 2009 2946 2952 2956 2976 2977 3013 3014 3004 3056 3064 3083 3105 2010 3113 3127 3146 3151 3168 3201 3210 3229 3251 3260 3282 3298 2011 3318 3334 3351 3358 3366 3392 3409 3465 3433 3471 3559 3573 2012 3542 3540 3582 3640 3667 3701 3725 3735 3759 3796 3815 3863 2014 Total 4139 4157 4173 4206 4209 4219 4240 4268 4280 4308 4333 4339 2014 MUD 3014 3015 3014 3028 3026 3031 3037 3052 3058 3072 3078 3080 2014 PID 1125 1142 1159 1178 1183 1188 1203 1216 1222 1236 1255 1259 2015 Total 4353 4363 4377 4404 4413 4429 4443 4459 4478 4486 4498 4517 2015 MUD 3083 3087 3095 3119 3120 3122 3123 3128 3133 3134 3137 3149 2015 PID 1270 1276 1282 1285 1293 1307 1320 1331 1345 1352 1361 1368 2016 Total 4531 4538 4556 4568 4593 4604 4607 4616 4622 4627 4632 4636 2016 MUD 3155 3158 3167 3172 3176 3181 3183 3186 3188 3192 3196 3200 2016 PID 1376 1380 1389 1396 1417 1423 1424 1430 1434 1435 1436 1436 2017 Total 4644 4647 4661 4657 4663 4666 4670 4676 4685 4690 4696 4700 2017 MUD 3208 3210 3220 3216 3221 3224 3228 3234 3242 3247 3252 3256 2017 PID 1436 1437 1441 1441 1442 1442 1442 1442 1443 1443 1444 1444 2018 Total 4701 4706 4712 4716 47200000000 2018 MUD 3257 3262 3268 3272 3276 2018 PID 1444 1444 1444 1444 1444 Monthly Water Operations Report FY 2018 Water Billed Water Pumped Active Connections 0 20,000 40,000 60,000 80,000 100,000 120,000 140,000 160,000 October November December January February March April May June July August September WATER BILLED IN THOUSANDS OF GALLONS 2014 2015 2016 2017 2018 0 20,000 40,000 60,000 80,000 100,000 120,000 140,000 160,000 October November December January February March April May June July August September WATER PUMPED IN THOUSANDS OF GALLONS 2014 2015 2016 2017 2018 Trophy Club Municipal Utility District No. 1 119 of 130 March 20, 2018 Agenda Packet AMENDED** Influent EffluentInfluent EffluentInfluent Effluent5‐Feb 32 0.35 98.9% 190 2.0 98.9% 187 1.0 99.5%6‐Feb 43 0.48 98.9% 198 2.0 99.0% 237 1.0 99.6%    12‐Feb 42 0.68 98.4% 176 2.0 98.9% 205 1.0 99.5%13‐Feb 41 0.30 99.3% 150 2.0 98.7% 247 1.0 99.6%   19‐Feb 35 0.20 99.4% 264 2.0 99.2% 255 1.0 99.6%20‐Feb 42 0.20 99.5% 234 2.0 99.1% 198 1.0 99.5% 26‐Feb 35 0.23 99.3% 164 2.0 98.8% 214 1.0 99.5%27‐Feb 35 0.20 99.4% 169 2.0 98.8% 178 1.0 99.4%99.1%98.9%99.5%Date% Removal% Removal% RemovalReportFebruary 2018 ResultsAmmonia‐NCBOD5TSS0.332.01.0Ammonia‐NCBOD5TSSTrophy Club Municipal Utility District No. 1120 of 130March 20, 2018 Agenda Packet AMENDED** Max mg/L0.33Aver mg/L0.270Max mg/L2.0Aver mg/L2.0Ammonia NitrogenCarbonaceous Biochemical Demand (CBOD5)0.210.33000.511.522.533.5Jan‐18 Feb‐18 Mar‐18 Apr‐18 May‐18 Jun‐18 Jul‐18 Aug‐18 Sep‐18 Oct‐18 Nov‐18 Dec‐18NH‐3 mg/LAveragePermit Limit2.02.00.0001.0002.0003.0004.0005.0006.000Jan‐18 Feb‐18 Mar‐18 Apr‐18 May‐18 Jun‐18 Jul‐18 Aug‐18 Sep‐18 Oct‐18 Nov‐18 Dec‐18CBOD5AveragePermit LimitTrophy Club Municipal Utility District No. 1121 of 130March 20, 2018 Agenda Packet AMENDED** Max mg/L1Aver mg/L1.0Max mg/L8.8Aver mg/L6.4Nitrate - NitrogenTotal Suspended Solids (TSS)1.01.00.02.04.06.08.010.012.014.0Jan‐18 Feb‐18 Mar‐18 Apr‐18 May‐18 Jun‐18 Jul‐18 Aug‐18 Sep‐18 Oct‐18 Nov‐18 Dec‐18TSSAveragePermit Limit8.84.00.05.010.015.020.025.030.0Jan‐18 Feb‐18 Mar‐18 Apr‐18 May‐18 Jun‐18 Jul‐18 Aug‐18 Sep‐18 Oct‐18 Nov‐18 Dec‐18Nitrate‐NAveragePermit LimitTrophy Club Municipal Utility District No. 1122 of 130March 20, 2018 Agenda Packet AMENDED** Max mg/L1.0Aver mg/L1.0Max mg/L7.4Min mg/L7.2Aver mg/L7.3Potential for Hydrogen (pH)E. Coli1.01.00.020.040.060.080.0100.0120.0140.0Jan‐18 Feb‐18 Mar‐18 Apr‐18 May‐18 Jun‐18 Jul‐18 Aug‐18 Sep‐18 Oct‐18 Nov‐18 Dec‐18E. ColiAveragePermit Limit7.27.27.37.40.01.02.03.04.05.06.07.08.09.010.0Jan‐18 Feb‐18 Mar‐18 Apr‐18 May‐18 Jun‐18 Jul‐18 Aug‐18 Sep‐18 Oct‐18 Nov‐18 Dec‐18pH MinAveragePermit Limit MinPermit Limit MaxpH MaxTrophy Club Municipal Utility District No. 1123 of 130March 20, 2018 Agenda Packet AMENDED** Max mg/L7.8Aver mg/L7.7 Dissolved Oxygen (DO)7.87.50.01.02.03.04.05.06.07.08.09.0Jan‐18 Feb‐18 Mar‐18 Apr‐18 May‐18 Jun‐18 Jul‐18 Aug‐18 Sep‐18 Oct‐18 Nov‐18 Dec‐18DOAveragePermit LimitTrophy Club Municipal Utility District No. 1124 of 130March 20, 2018 Agenda Packet AMENDED** Language Users % Users 1.en-us 1,631 98.31% 2.ko 8 0.48% 3.en-gb 7 0.42% 4.c 3 0.18% 5.zh-cn 2 0.12% 6.(not set)1 0.06% 7.en 1 0.06% 8.en-ca 1 0.06% 9.es 1 0.06% 10.es-419 1 0.06% Audience Overview Feb 1, 2018 - Feb 28, 2018 Overview  Users …Feb 8 Feb 15 Feb 22 100100 200200 Users 1,659 New Users 994 Sessions 2,123 Number of Sessions per User 1.28 Pageviews 3,759 Pages / Session 1.77 Avg. Session Duration 00:01:19 Bounce Rate 68.58% New Visitor Returning Visitor 44.1% 55.9% © 2018 Google All Users 100.00% Users Trophy Club MUD All Web Site Data GO TO REPORT Trophy Club Municipal Utility District No. 1 125 of 130 March 20, 2018 Agenda Packet AMENDED** Page Pageviews % Pageviews 1.1,744 46.40% 2.287 7.64% 3.238 6.33% 4.191 5.08% 5.167 4.44% 6.112 2.98% 7.70 1.86% 8.63 1.68% 9.60 1.60% 10.58 1.54% Overview Feb 1, 2018 - Feb 28, 2018 Overview  Pageviews …Feb 8 Feb 15 Feb 22 200200 400400 Pageviews 3,759 Unique Pageviews 3,141 Avg. Time on Page 00:01:42 Bounce Rate 68.58% % Exit 56.48% / /customer-service/email-bills-and-online-payments/ /public-informatio/agendas-meetings-online/ /my-account/ /customer-service/contact-us-2/ /my-account/about-your-bill/ /services/water/ /my-account/rates-charges/ /customer-service/form/ /?page_id=8674&preview=true © 2018 Google All Users 100.00% Pageviews Trophy Club MUD All Web Site Data GO TO REPORT Trophy Club Municipal Utility District No. 1 126 of 130 March 20, 2018 Agenda Packet AMENDED** October November December January February March April May June July August September ebills 796 828 829 834 839 Bills Mailed 3,906 3,900 3,912 3,911 3,908 Bank Draft 631 623 639 653 657 Credit Card Draft 1,018 1,020 1,026 1,113 1,125 Online Payments 1,037 1,079 1,072 1,065 1,090 Late Notices 391 420 457 362 424 Disconnects 25 27 27 25 22 Connections M P 3257 1444 3262 1444 3268 1444 3272 1444 3276 1144 October November December January February March April May June July August September ebills 758 758 778 780 780 799 810 819 821 809 820 819 Bills Mailed 3,870 3,866 3,900 3,884 3,875 3,876 3,877 3,890 3,907 3,903 3,920 3,910 Bank Draft 624 610 623 608 617 620 622 626 637 645 641 631 Credit Card Draft 882 897 949 944 945 927 964 960 964 969 978 1,011 Online Payments 1,041 1,057 1,029 1,028 1,025 1,062 1,027 1,062 1,071 1,065 1,075 1,087 Late Notices 506 455 471 382 491 500 476 439 435 466 406 467 Disconnects 30 37 37 44 35 51 61 40 45 44 23 11 Connections M P 3208 1436 3210 1437 3214 1441 3216 1441 3221 1442 3224 1442 3228 1442 3234 1442 3242 1443 3247 1443 3252 1444 3256 1444 Trophy Club Municipal Utility District No. 1 Utility Billing Report Fiscal Year 2018 Fiscal Year 2017 Trophy Club Municipal Utility District No. 1 127 of 130 March 20, 2018 Agenda Packet AMENDED** MUD Permits Month: February 2018 Date of Permit Permit No. Customer Deposit 135-25030 Due to FW Water 135- 20500 Oversize Meter 135-49075 Plumbing Inspections 135- 47035 Sewer Inspections 135- 47045 Fire Line 135-49900 Misc Income 135-49900 Total 2/2/2018 2018-0021 75.00$ 1,173.00$ 343.00$ 150.00$ 50.00$ 1,791.00$ 2/14/2018 2018-0018 75.00$ 1,173.00$ 343.00$ 150.00$ 50.00$ 1,791.00$ 2/21/2018 2018-0023 75.00$ 1,173.00$ 343.00$ 150.00$ 50.00$ 1,791.00$ 2/22/2018 2018-0025 75.00$ 1,173.00$ 343.00$ 150.00$ 50.00$ 1,791.00$ 2/27/2018 2018-0028 75.00$ 1,173.00$ 343.00$ 150.00$ 50.00$ 1,791.00$ Total 375.00$ 5,865.00$ 1,715.00$ 750.00$ 250.00$ -$ -$ 8,955.00$ Trophy Club Municipal Utility District No. 1 128 of 130 March 20, 2018 Agenda Packet AMENDED** 135-10154 Bank of the West-THB (X6718) 3 yr CD $35,316 $0 $35,316 135-10175 Bank of the West MMA (XXX6372) General Fund Operating $0 $714,630 $714,630 135-10250 TexPool O & M (XXXXX0002)-General Fund Operating ***$0 $1,148,492 $1,148,492 137-10250 TexPool O & M (XXXXX0002) GASB Replacement $596,426 $0 $596,426 517-10250 TexPool Construction Tax (XXXXX011) WWTP Improvements $1,265,672 $0 $1,265,672 519-11155 Cash-Bond Escrow Bank of Texas (SWIFT)$4,496,529 $0 $4,496,529 528-10250 TexPool Revenue Bond Reserve (XXXXX014) WWTP Improvements $500,619 $0 $500,619 533-10250 TexPool Tax I & S (XXXXX0003)$819,493 $0 $819,493 534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements $177,130 $0 $177,130 535-10250 Texpool Revenue I & S (XXXXX017) SWIFT $96,079 $0 $96,079 135-10300 Prosperity Bank (XXX8701) General Fund Operating *$313,815 $1,177,634 $1,491,449 533-10300 Prosperity Bank (XXX8701) Tax I&S $4,573 $0 $4,573 135-10305 Prosperity Bank Reserve-Savings Acct (XXXXX7724)$781,493 $0 $781,493 135-11100 Petty Cash Administration $0 $150 $150 135-11150 Petty Cash Utility Billing $0 $450 $450 $9,087,144 $3,041,357 $12,128,501 Amount available in cash (MUD Accounts)$3,041,357 Amount available for spending (MUD Accounts)$3,041,357 * 02/28/18 Customer Water Deposits $313,815 122-10250 TexPool O & M (XXXXX0002)-Fire Operating Cash $0 $861,313 $861,313 122-10300 Prosperity Bank (XXX8701) Fire Operating $0 $0 $0 $0 $861,313 $861,313 Amount available in cash (Fire Department Accounts)$861,313 Amount available for spending (Fire Department Accounts)$861,313 714,630$ Bank of the West MM 1,177,634$ Prosperity General Fund 1,148,492$ Texpool General Fund 600$ Petty Cash Total General Fund 135 Available for Spending 3,041,357$ Nonspendable Fund Balance (Prepaids)3,486$ Assigned Fund Balance (FY2018 Capital Projects plus prior year carry forward)1,778,760$ Unassigned Fund Balance 2,368,122$ Current Year Revenue/Expenses 401,170$ Total Nonspendable, Assigned & Committed Fund Balances - General Fund 135 $4,551,538 General Fund 135 Available General Fund 135 Fund Balances Fire Department Cash CASH STATUS AS OF FEBRUARY 2018 Restricted - Unable to be spent Unrestricted- Available for spending Total in Accounts (Restricted & Unrestricted) Trophy Club Municipal Utility District No. 1 129 of 130 March 20, 2018 Agenda Packet AMENDED** April 2018CalendarsFS Conference RoomFS Training RoomPS Large Conference RoomSvore Board RoomSunMonTueWedThuFriSat1415161718Apr 1, 201823456710:30am Parks/Re9am Mgt Team Me7am FD Officers M7pm Trophy Club W9am TCWC8910111213149am EMS Training10:30am Parks/Re7pm Villas of Trophy 9am EMS Training9am Mgt Team Me9am EMS Training1516171819202110:30am Parks/Re6pm Trophy Club M6pm Lakes of Trophy9am Mgt Team Me2223242526272810:30am Parks/Re9am Mgt Team Me10am Special Eve2930May 1234510:30am Parks/Re9am Mgt Team Me7am FD Officers M7pm Trophy Club WPowered byTC Meeting Spaces3/16/2018Trophy Club Municipal Utility District No. 1130 of 130March 20, 2018 Agenda Packet AMENDED**