Loading...
HomeMy WebLinkAboutNovember 19, 2013 Regular Session Agenda Packet BOARD OF DIRECTORS Meeting Agenda TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 100 MUNICIPAL DRIVE TROPHY CLUB, TEXAS 76262 November 19, 2013 7:00 P.M. Svore Municipal Boardroom CALL TO ORDER AND ANNOUNCE A QUORUM CITIZEN PRESENTATIONS 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. CONSENT AGENDA 1. Consider and take appropriate action to approve the Consent Agenda. (McKnight) a. October 15, 2013 - Regular Meeting Minutes b. October 23, 2013 - Joint Meeting Minutes c. October 2013 Check Register d. Second modification to the Contract for Water and Wastewater Operational Services between the Town of Trophy Club and Trophy Club Municipal Utility District No. 1 REGULAR SESSION 2. Consider and take appropriate action to approve the October 2013 financials. (Gonzales) a. Variance Report b. Combined Financials c. Fund Balance 3. Consider and take appropriate action regarding the proposed settlement of the interpleader suit filed by the District against Prime Construction and its bonding company relating to the remaining retainage from the construction of the new fire station. (West) 4. Consider and take appropriate action regarding Director attendance at Blue Ribbon Panel and Citizen Advisory Committee meetings. (Thomas) 5. Consider and take appropriate action regarding Citizen’s Advisory Committee request to reprioritize task timeline. 6. Consider and take appropriate action to authorize District Manager to close District office at noon on December 13, 2013, for employee Christmas party. (McKnight) Trophy Club Municipal Utility District No. 1 1 of 173 November 19, 2013 REPORTS & UPDATES 7. District Manager Report (McKnight) a. Water System Operation b. Wastewater Operation c. Website Analytics d. Finance Update • UB Reports • PID Connections e. Project Updates • Rate of Flow Control Project • Wastewater Treatment Plant Upgrades • Lift Station No. 1 access road 8. Fire Department Report (D. Thomas) a. October Reports 9. Receive update on Citizen Advisory Committee. (Carr & Armstrong) 10. Receive update from Public Improvement District (PID) committee regarding meeting with Town of Trophy Club on November 12, 2013 for contract discussions related to wholesale water and wastewater supply to the PID. (Moss & Carr) 11. Receive update from legislative committee regarding meeting with legislators, Town of Trophy Club, and Town of Westlake on November 5, 2013. (Sanders & Carr) 12. Receive updated presentation of the 2013 Rate Study from J. Stowe & Co. CONVENE INTO CLOSED SESSION 13. The Board will conduct a Closed Session pursuant to Texas Government Code, annotated, Chapter 551, Subchapter D for the following: Section 551.071(2) Consultation with Attorney - Consultation with Attorney on a matter in which the duty of the attorney to the Governmental Body under the Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflict with the Open Meetings Act and to seek advice of counsel on legal matters involving pending or contemplated litigation, settlement offers, or legal matters not related directly to litigation or settlement. Pending or contemplated litigation and settlement offers include but are not limited to the following: Town of Westlake proposal to buy-out Solana area from District boundaries. Section 551.071(2) Consultation with Attorney on a matter in which the duty of the attorney to the Governmental Body under the Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflict with the Open Meetings Act: Water and wastewater services for PID; terms of inter-local agreement for provision of water and wastewater services; Trophy Club Municipal Utility District No. 1 assets and related matters; and representation. Section 551.071(2) Consultation with Attorney - on a matter in which the duty of the attorney to the Governmental Body under the Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflict Trophy Club Municipal Utility District No. 1 2 of 173 November 19, 2013 with the Open Meetings Act and potential litigation with the Town of Westlake in conjunction with administrative body Texas Commission on Environmental Quality review: bond application. Section 551.071(2) Consultation with Attorney - on a matter in which the duty of the attorney to the Governmental Body under the Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflict with the Open Meetings Act and potential litigation with the Town of Trophy Club in conjunction with administrative body Texas Commission on Environmental Quality review: CCN Matters. Section 551.071(2) Consultation with Attorney - on a matter in which the duty of the attorney to the Governmental Body under the Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflict with the Open Meetings Act: Town of Westlake Council Members violations of Texas Open Meetings Act. RECONVENE INTO REGULAR SESSION 14. Consider and take appropriate action regarding Closed Session items. 15. Items for future agendas 16. Set next meeting date - Tuesday, December 17, 2013 at 7:00 p.m. ADJOURN *THE BOARD RESERVES THE RIGHT TO ADJOURN INTO A CLOSED SESSION AT ANY TIME DURING THE MEETING FOR THE PURPOSE OF SEEKING THE ADVICE OF ITS ATTORNEY ABOUT ANY ITEM ON THE AGENDA OR THAT ARISES AT THE MEETING, PURSUANT TO SECTION 551.071 OF THE TEXAS GOVERNMENT CODE. CERTIFICATION THE STATE OF TEXAS § COUNTIES OF DENTON AND TARRANT § THIS CERTIFIES THAT ON NOVEMBER 15, 2013 BY 4:00 P.M., A COPY OF THE ABOVE NOTICE OF THE TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1, BOARD OF DIRECTORS MEETING TO BE HELD ON NOVEMBER 19, 2013 AT 7:00 P.M. WAS POSTED ON THE FRONT WINDOW OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 ADMINISTRATION BUILDING LOCATED AT 100 MUNICIPAL DRIVE, TROPHY CLUB, TEXAS, WHICH IS A PLACE CONVENIENCT TO THE PUBLIC WITHIN THE BOUNDARIES OF THE DISTRICT, AND A COPY WAS ALSO PROVIDED TO THE COUNTY CLERKS OF DENTON AND TARRANT COUNTIES TO BE POSTED ON THEIR WEBSITES OR AT A PLACE CONVENIENT TO THE PUBLIC PURSUANT TO SECTION 49.063 OF THE WATER CODE AND SETION 551.054 OF THE OPEN MEETINGS ACT, CHAPTER 551 OF THE TEXAS GOVERNMENT CODE. _______________________________ LAURIE SLAGHT, DISTRICT SECRETARY Trophy Club Municipal Utility District No. 1 3 of 173 November 19, 2013 REGULAR SESSION MINUTES FROM TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 BOARD OF DIRECTORS 100 MUNICIPAL DRIVE, TROPHY CLUB, TEXAS October 15, 2013 at 6:00 P.M. Svore Municipal Building Boardroom The Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in Regular Session on Tuesday, October 15, 2013 at 6:00 P.M., in the Boardroom of the Administration Building, 100 Municipal Drive, Trophy Club, Texas 76262. The meeting was held within the boundaries of the District, and was open to the public. STATE OF TEXAS § COUNTY OF DENTON § COUNTY OF TARRANT § MUD 1 BOARD MEMBERS PRESENT Jim Moss President Bill Armstrong Vice President Kevin Carr Secretary/Treasurer Jim Thomas Director (arrived at 6:52 p.m.) Nick Sanders Director STAFF PRESENT: Jennifer McKnight District Manager Laurie Slaght District Secretary Karl Schlielig Wastewater Superintendent Adrian Womack Utility Superintendent Renae Gonzales Finance Manager Terri Sisk Human Resources Manager Danny Thomas Fire Chief Bob West District Legal Counsel arrived at 6:05 p.m. President Moss announced the date of October 15, 2013, called the meeting to order and announced a quorum present at 6:00 p.m. WORKSHOP 1. Presentation of preliminary rate study by J. Stowe and Co. Chris Ekrut with J. Stowe and Co. presented the preliminary rate study and answered related questions from the Board. The Board requested additional information regarding how each scenario will affect higher usage groups. Mr. Ekrut will add the information and present it to the Board a future meeting. SPECIAL PRESENTATION 2. Recognition of rain gauge volunteers and presentation of certificates. District Manager McKnight acknowledged residents who volunteered for the Rainfall Around Town Program and thanked them for their service to the District and community. Volunteers Philip Shoffner Kathleen Becker Mark & Betty Watson Sherry & Doug Bolls Mark Staab Don Farnsworth Kyle Black Trophy Club Municipal Utility District No. 1 October 15, 2013 Regular Meeting Minutes 1 of 5Trophy Club Municipal Utility District No. 1 4 of 173 November 19, 2013 CITIZEN PRESENTATIONS Jim Hase 315 Lakewood CONSENT AGENDA 3. Consider and take appropriate action to approve the Consent Agenda. a. Quarterly Investment Report for fourth quarter FY 2013 b. Revised Quarterly Investment Report for third quarter FY2013. c.September 17, 2013 Regular Meeting Minutes d. September 30, 2013 Special Meeting Minutes e. September 30, 2013 Open House Minutes Motion made by Director Sanders seconded by Director Carr to approve the Consent Agenda. Motion Carried Unanimously REGULAR SESSION 4. Consider and take appropriate action to approve the September 2013 financials. (Gonzales) a.Variance Report b.Combined Financials c.Cash Analysis d.Fund Balance Motion made by Director Carr and seconded by Director Armstrong to approve the September 2013 Financials. Motion carried unanimously (President Moss moved to discuss Item No. 14 at this time. With no objections the item is moved.) 5. Consider and take appropriate action to set a joint meeting with the Town of Trophy Club Town Council to discuss a contract for provision of water and wastewater service to the Town of Trophy Club Public Improvement District. (McKnight) Motion made by Director Sanders and seconded by Director Armstrong to approve a joint meeting with the Town of Trophy Club on October 23, 2013 to discuss the water and wastewater service contract. District Manager McKnight stated the Town Manager provided suggested agenda language for the joint meeting as follows: Consider and take appropriate action regarding Town and MUD1 participation in upgrade to MUD1 wastewater treatment plant. a. scope of project b. financial options c. MUD1 letter to Town dated October 1, 2013 Director Sanders stated he objects to the suggested language as it does not allow for discussions of a new contract. He stated the language limits the discussions to the wastewater plant upgrade and that part “c” of the suggested language does not relate to the main part of the motion. Director Sanders also Trophy Club Municipal Utility District No. 1 October 15, 2013 Regular Meeting Minutes 2 of 5Trophy Club Municipal Utility District No. 1 5 of 173 November 19, 2013 said he does not believe the suggested language reflects the motion made by Councilman Mayer at the Town Council’s last meeting where this topic was discussed. Director Carr agreed and stated the language needs to allow for discussions on a new contract for water and wastewater service between the District and the Town for the Public Improvement District (PID) as was stated in CM Mayer’s motion. Motion is modified by the first (Sanders) and second (Armstrong) to have a joint meeting with the Town Council on October 23, 2013, to allow a one-day extension as requested by the Town Manager for a response from the Town to the District’s letter date October 1, 2013, and to allow Director Sanders and Director Carr to work with the District Manager on agenda language for the joint meeting. Motion carried unanimously 6. Consider and take appropriate action to approve first modification to the Contract for Water and Wastewater Operational Services between the Town of Trophy Club and Trophy Club Municipal Utility District No. 1. Motion made by Director Carr and seconded by Director Thomas to approve the first modification to the contract for Water and Wastewater Operational Services to between the Town of Trophy Club and Trophy Club MUD No. 1. Motion carried unanimously 7. Consider and take appropriate action regarding possible fire service to rural Tarrant County area off Pearson Lane. Motion was made by Director Sanders and seconded by Director Carr to move this item to the November agenda for discussion. Motion carried unanimously 8. Consider and take appropriate action authorizing the expenditure for a video switcher solution not to exceed $2500. Motion was made by Director Sanders and seconded by Director Armstrong to approve funds not to exceed $2500 for a video switch. Motion carried unanimously 9. Consider and take appropriate action regarding electioneering policy. Discussion only, no action taken 10. Consider and take appropriate action regarding access to Lift Station No. 1 and other regulatory requirements related thereto. The District Manager will investigate requirements to obtain an access road to Lift Station No. 1 and will present the information to the Board at a later date. REPORTS & UPDATES 11. District Manager Report District Manager presented her monthly update to the Board, including: Trophy Club Municipal Utility District No. 1 October 15, 2013 Regular Meeting Minutes 3 of 5Trophy Club Municipal Utility District No. 1 6 of 173 November 19, 2013 a. Water System Operation b. Wastewater Operation c.Fiscal Year-End Production and Usage Summary d. Website Analytics e. Finance Update •UB Reports •PID Connections f. Project Updates •Rate of Flow Control Project •Wastewater Treatment Plant Upgrades •Bond application 12. Fire Department Report Chief Thomas presented his monthly fire report to the Board, including: a.September Reports b.Volunteer Efforts 13. Receive update on Citizen Advisory Committee Director Carr referred this item to Citizen Advisory Committee Chair Jim Hase who gave the Board an update regarding the Committee meetings and their work to date. The Board convened into closed session at 8:50 pm 14. The Board will conduct a Closed Session pursuant to Texas Government Code, annotated, Chapter 551, Subchapter D for the following: Section 551.071(2) Consultation with Attorney - to seek advice of counsel on legal matters involving pending or contemplated litigation, settlement offers, or legal matters not related directly to litigation or settlement. Pending or contemplated litigation and settlement offers include but are not limited to the following: Town of Westlake. Section 551.071(2) Consultation with Attorney on a matter in which the duty of the attorney to the Governmental Body under the Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflict with the Open Meetings Act: Water and wastewater services for PID; terms of inter-local agreement for provision of water and wastewater services; Trophy Club Municipal Utility District No. 1 assets and related matters; Section 551.071(2) Consultation with Attorney - to seek advice of counsel on legal matters involving pending or contemplated litigation, settlement offers, or legal matters not related directly to litigation or settlement: CCN Matters Section 551.071(2) Consultation with Attorney on a matter in which the duty of the attorney to the Governmental Body under the Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflict with the Open Meetings Act: Notification to City of Fort Worth of possible change to wholesale water contract terms. The Board reconvened into Regular Session at 10:14 p.m. 15. Consider and take appropriate action regarding Closed Session items. No action taken Trophy Club Municipal Utility District No. 1 October 15, 2013 Regular Meeting Minutes 4 of 5Trophy Club Municipal Utility District No. 1 7 of 173 November 19, 2013 16. Items for future agendas 17. Set next meeting date - Regular Board meeting - November 19, 2013 Joint meeting with the Town of Trophy Club, Town Council - October 23, 2013 ADJOURN Meeting adjourned at 10:15 p.m. ___________________________ Jim Moss, President ____________________________ (SEAL) Kevin R. Carr, Secretary/Treasurer ____________________________ Laurie Slaght, District Secretary Trophy Club Municipal Utility District No. 1 October 15, 2013 Regular Meeting Minutes 5 of 5Trophy Club Municipal Utility District No. 1 8 of 173 November 19, 2013 JOINT MEETING MINUTES FROM TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 BOARD OF DIRECTORS AND THE TOWN OF TROPHY CLUB, TOWN COUNCIL OCTOBER 23, 2013 AT 7:00 P.M. 100 MUNICIPAL DRIVE, TROPHY CLUB, TEXAS Svore Municipal Building Boardroom The Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in a Joint Meeting with the Town of Trophy Club Town Council on October 23, 2013 at 7:00 P.M., in the Boardroom of the Svore Municipal 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 § COUNTY OF DENTON § COUNTY OF TARRANT § MUD 1 BOARD MEMBERS PRESENT Jim Moss President Bill Armstrong Vice President Kevin Carr Secretary/Treasurer Jim Thomas Director (arrived at 8:10 p.m.) Nick Sanders Director STAFF PRESENT: Jennifer McKnight District Manager Laurie Slaght District Secretary Paul Liston District Legal Counsel TOWN COUNCIL MEMBERS PRESENT Connie White Mayor Jeanette Tiffany Mayor Pro-Tem Bill Rose Council Member Clint Schroeder Council Member Danny Mayer Council Member Greg Lamont Council Member TOWN STAFF PRESENT Mike Slye Town Manager Tammy Ard Town Secretary Patricia Adams Town Attorney President Moss announced the date of October 23, 2013, called the meeting to order and announced a quorum present at 7:01 p.m. 1. Consider and take appropriate action regarding the Interlocal Agreement for Water and Wastewater Services between Trophy Club Municipal Utility District No. 1 (TCMUD1) and the Town of Trophy Club (Town) including the October 1, 2013 letter from TCMUD1 to the Town of Trophy Club. a. Presentation regarding planned upgrade to wastewater treatment plant. (The Wallace Group) Scott Wetzel and Kevin Glovier from The Wallace Group gave an overview of the planned upgrades to the Wastewater treatment plant. Trophy Club Municipal Utility District No. 1 October 23, 2013 Joint Meeting Minutes 1 of 2Trophy Club Municipal Utility District No. 1 9 of 173 November 19, 2013 b. Consider and take appropriate action regarding the Town’s preference for wholesale or retail service. c. Consider and take appropriate action regarding Contract for Water and Wastewater Operations Services between the Town of Trophy Club and TCMUD1. d. Consider and take appropriate action related to the October 1, 2013 letter from TCMUD1 to the Town. Motion made by Director Sanders seconded by Director Carr to extend the date of the Towns written response to October 25, 2013. Motion carried unanimously President Moss adjourned the meeting at 8:27 p.m. ___________________________ Jim Moss, President ____________________________ (SEAL) Kevin R. Carr, Secretary/Treasurer ____________________________ Laurie Slaght, District Secretary Trophy Club Municipal Utility District No. 1 October 23, 2013 Joint Meeting Minutes 2 of 2Trophy Club Municipal Utility District No. 1 10 of 173 November 19, 2013 Trophy Club Municipal Utility District No. 111 of 173November 19, 2013 Trophy Club Municipal Utility District No. 112 of 173November 19, 2013 Trophy Club Municipal Utility District No. 113 of 173November 19, 2013 Trophy Club Municipal Utility District No. 114 of 173November 19, 2013 Trophy Club Municipal Utility District No. 115 of 173November 19, 2013 Trophy Club Municipal Utility District No. 116 of 173November 19, 2013 Trophy Club Municipal Utility District No. 117 of 173November 19, 2013 Trophy Club Municipal Utility District No. 118 of 173November 19, 2013 Trophy Club Municipal Utility District No. 119 of 173November 19, 2013 Trophy Club Municipal Utility District No. 120 of 173November 19, 2013 Trophy Club Municipal Utility District No. 121 of 173November 19, 2013 November 19, 2013 Board Meeting Consent Agenda Item (c) Summary Last month the Board approved the “First Modification to the Contract for Water and Wastewater Operational Services Between the Town of Trophy Club and Trophy Club Municipal Utility District No. 1.” The purpose of the contract modification was to amend Section 5 related to the billing procedure to have the contract accurately reflect the method used by staff for the last several years and to allow for collection of account deposits for customers located in the PID. After approval by the Board, the modified contract was presented to the Town Council. At their meeting it was noted that a “First Modification” had been approved a few years ago when MUD1 and MUD2 merged. The First Modification to the contract at that time changed any reference to “MUD1 and MUD2” and/or “the MUDs” to MUD1. The purpose of this agenda item is to simply address that the board should have approved the “Second Modification” to the contract instead of the “First Modification.” No additional changes to the contract have been made. Trophy Club Municipal Utility District No. 1 22 of 173 November 19, 2013 Page 1 of 4 SECOND MODIFICATION TO CONTRACT FOR WATER AND WASTEWATER OPERATIONAL SERVICES BETWEEN THE TOWN OF TROPHY CLUB, TEXAS, TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 AND TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 2 This Second Modification of the Contract for Water and Wastewater Operations Services (“Second Modification”) is entered into between THE TOWN OF TROPHY CLUB, TEXAS, a home rule municipality located in Denton and Tarrant Counties (hereinafter “Town”) and TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 (hereinafter “MUD1”),a Special District created pursuant to Section 59, Article XVI, Texas Constitution and the Texas Water Code, Chapter 54. WHEREAS, the Interlocal Cooperation Act, Texas Government Code, Chapter 791, et seq., as amended (the “Act”) provides authority for governmental entities of the State of Texas to enter into Interlocal Agreements with each other regarding governmental functions and services as set forth in the Act; and WHEREAS, The Town of Trophy Club (the “Town”), Trophy Club Municipal Utility District No 1 (hereinafter “MUD1”), and Trophy Club Municipal Utility District No. 2 (“MUD2”) previously entered into a contract for water and wastewater operational services on November 12, 2007 entitled Contract for Water and Wastewater Operational Services between the Town of Trophy Club, Texas, Trophy Club Municipal Utility District No. 1 and Trophy Club Municipal Utility District No. 2 (the "Contract") wherein MUD1 and MUD2 were collectively referred to as “MUDs” ; and WHEREAS, subsequent to the execution of the Contract, MUD1 and MUD2 consolidated into one municipal utility district which is currently identified as “Trophy Club Municipal Utility District No. 1” with MUD1 assuming all rights and obligations formerly designated to MUD1 and MUDs under the Contract; and WHEREAS, Article 5 of the Contract sets forth the procedure for billing and collections by MUD1 for Town Customers; and WHEREAS, new technologies for billing and collections and for customer payments have been implemented that render the methods of the Contract time- consuming and places undo demands on staff of both the Town and MUD1; and WHEREAS, the parties have determined it appropriate to enter into this Second Modification in order to adopt new and more efficient procedures for billing of customers; and WHEREAS, this Second Modification shall become effective November 1, 2013 and shall amend only those sections specifically set forth below, with the Trophy Club Municipal Utility District No. 1 23 of 173 November 19, 2013 Page 2 of 4 remainder of the terms and provisions of the Contract remaining in effect as originally stated in the Contract. NOW, THEREFORE, in consideration of the foregoing, Town and MUD1 agree to amend the Contract as follows: I. Incorporation of Agreement The Contract is incorporated herein as if written word for word. Except as expressly provided below, all other terms and conditions of the Contract shall remain unchanged and shall remain in full force and effect. In the event of any conflict or inconsistency between the provisions set forth in this Second Modification, First Modification and the Contract, priority of interpretation shall be in the following order: Second Modification; First Modification; Contract. II. Modification of Agreement 2.01 Party References Revised. Effective as of November 1, 2013, all references in the Contract to MUD1, MUD2 and or MUDs shall mean MUD1. 2.02 Section 5 Revised. Effective as of November 1, 2013, Section 5 of the Agreement entitled “Rate Orders and Services to Town Customers” is hereby modified so that subsection 5.4 through subsection 5.8 shall be and read in their entirety as follows and all other subsections of Section 5 shall remain unaltered: 5.4 Billing of Town Customers. MUD1 shall read the individual meters of Town Customers on a monthly basis during the term of this Contract. Based on such meter readings, MUD1 shall send statements to Town Customers in accordance with the then-current Town Rate Order. MUD1 shall collect payments from Town Customers through all means available for MUD1 customers including online payments, credit card payments, check, cash, and money order/cashier’s check. 5.5 Payment and Collections. Each month, MUD1 shall prepare and deliver a monthly bill to all Town Customers. Town Customers be shall responsible for remitting payments directly to MUD1, and the payments shall be directly deposited into MUD1 bank accounts. MUD1 shall bill and collect from Town Customers in the same manner of billing and collections for MUD1 customers and shall keep one hundred percent of all collections as payment for operational services provided herein under the terms of this Contract. 5.6 Town Customer Account Deposits. MUD1 shall collect a customer account deposit on all Town Customer accounts. The deposits shall be held by MUD1 and shall be applied to Town Customer accounts in the same manner as Trophy Club Municipal Utility District No. 1 24 of 173 November 19, 2013 Page 3 of 4 those collected and maintained for MUD1 customer accounts. MUD1 shall not pay interest either directly to the Town or to any Town Customer for customer account deposits collected from Town Customers. 5.7 Late Charges and Interest on Late Payments Any and all late charges, penalties, interest, and other fees for collections associated with late payments shall be the property of MUD1 and shall be collected in the same manner as for MUD1 customers. 5.8 Water Emergency. Under Town’s ordinance(s), MUD1 may declare a "water emergency period" if any condition or event occurs that interrupts the production, treatment, or transportation of Water in the Water System and may impose conditions on consumption or use of Water. If MUD1 declares a "water emergency period" and imposes conditions on water consumption for its customers in the existing MUD1 boundaries under the then-current ordinance, Town agrees, upon timely notification by MUD1 to impose and enforce restrictive conditions of consumption on Town Customers. Such restrictive conditions shall be equivalent to those imposed upon MUD1 and/or theMUD1’s customers pursuant to the Fort Worth Water Contract. Where it has become necessary to adopt a drought contingency plan, MUD1 shall not apply their drought contingency plan to Town’s Customers in a manner that is more stringent than MUD1’s application of its drought contingency plan on residential customers within MUD1 boundaries. ADOPTED, PASSED AND APPROVED by the Town Council, by a vote of ____ members voting “for” and ____ members voting “against” and with ____ absentees, on this the _____ day of _________________________, 2013. TOWN OF TROPHY CLUB, TEXAS By: Connie White, Mayor ATTEST: Tammy Ard, Town Secretary APPROVED AS TO FORM: _________________________________ Patricia A. Adams, Town Attorney Trophy Club Municipal Utility District No. 1 25 of 173 November 19, 2013 Page 4 of 4 ADOPTED, PASSED AND APPROVED by the Trophy Club Municipal Utility District No. 1 Board of Directors, by a vote of ____ members voting “for” and ____ members voting “against” and with ____ absentees, on this the 19th day of November, 2013. TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 By: Jim Moss, Board President ATTEST: By: Kevin R. Carr, Board Secretary Trophy Club Municipal Utility District No. 1 26 of 173 November 19, 2013 BUDGET VARIANCE REPORT FUND:122 - Fire O&M FINANCIALS MONTH:October 2013 REVENUE VARIANCE:8% EXPENSE VARIANCE:18% NOTE: ACCOUNT DESCRIPTION TOTAL BUDGET CURRENT YTD TOTAL YTD %VARIANCE EXPLANATION FIRE REVENUES Tax Revenues do not substantially start coming in until December. FIRE EXPENSES 122-60080-045 Schools & Training 4,280$ 1,064$ 1,064$ 25%Online Fire Continuing Education Classes 122-60096-045 Emergency management 2,000$ 1,000$ 1,000$ 50%NCTCOG Administrative Fee 122-60100-045 Travel & Per Diem 4,577$ 1,065$ 1,065$ 23%Fire Marshall Conference in Austin 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 27 of 173 November 19, 2013 BUDGET VARIANCE REPORT FUND:135 - MUD 1 O&M FINANCIALS MONTH:October 2013 REVENUE VARIANCE:8% EXPENSE VARIANCE:18% NOTE: ACCOUNT DESCRIPTION TOTAL BUDGET CURRENT MONTH YTD TOTAL YTD %VARIANCE EXPLANATION REVENUE 135-40000-000 Property Taxes 99,250 1,866 1,866 2%Tax Revenues do not substantially start coming in until December. 135-40002-000 Property Taxes/Delinquent - (10) (10)0%Tax Refund 135-40015-000 Property Taxes P&I 900 (34) (34)-4%Tax Refund 135-47000-000 Water 3,749,310 241,095 241,095 6%Cooler Weather- Less Water Use 135-48005-000 Utility Fees 582,109 34,500 34,500 6%# of PID Connections October 135-49010-000 Interest Income 4,800$ 166$ 166$ 3%Low Interest rates WATER 135-50060-010 Pre-emp Physicals/Testing 200$ 36$ 36$ 18%Testing for potential new employee 135-65030-010 Chemicals 5,000$ 984$ 984$ 20%Hach, DPC 135-65035-010 Small Tools 1,200$ 465$ 465$ 39%Tools for On-Call Trucks 135-65050-010 Meter Expense 143,550$ 54,740$ 54,740$ 18%150 1" meters with Orion heads WASTEWATER 135-30105-020 Rent/lease Equipment 1,500$ 300$ 300$ 20%Rented Scissorlift to change out lights in Maintenance Barn 135-65010-020 Uniforms 1,752$ 1,284$ 1,284$ 73%Purchased majority of uniforms at beginning of year 135-65040-020 Safety Equipment 250$ 56$ 56$ 23%Stock medicine cabinet 135-65045-020 Lab Supplies 15,000$ 4,284$ 4,284$ 29%E-Coli Testing equipment COLLECTIONS 135-65010-021 Uniforms 1,040$ 576$ 576$ 55%Purchased majority of uniforms at beginning of year 135-65040-021 Safety Equipment 500$ 541$ 541$ 108%Ear Plugs BOARD OF DIRECTORS ADMINISTRATION 135-50010-030 Overtime 500$ 211$ 211$ 42%Open House Preparation 135-55070-030 Independent Labor 7,700$ 1,780$ 1,780$ 23%Rate Study 135-55161-030 Outside Services-Town Semo 77,048$ 38,524$ 38,524$ 50%One of Two Annual Payments 135-65105-030 Printing 4,000$ 1,401$ 1,401$ 35%Logan Graphics NON-DEPARTMENTAL 135-55060-039 Appraisal 10,000$ 3,345$ 3,345$ 33%Annual Fees- Tarrant Appraisal District and Taxes on 3.996 acres 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 28 of 173 November 19, 2013 TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET OCTOBER 31, 2013 ASSETS FIRE DEPT. CASH ON HAND - CASH IN BANK - INVESTMENTS 537,023 PREPAID EXPENSES 18,392 ADVALOREM PROPERTY TAXES RECEIVABLE 929,195 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE 300,987 UTILITY AND OTHER ACCOUNTS RECEIVABLE 676 TOTAL ASSETS 1,786,273 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 1,230,182 ACCOUNTS AND OTHER PAYABLES 83,977 TOTAL LIABILITIES 1,314,159 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE 2,141 UNASSIGNED FUND BALANCE 493,547 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES (23,574) TOTAL FUND BALANCE 472,114 TOTAL LIABILITIES AND FUND BALANCE 1,786,273 Trophy Club Municipal Utility District No. 1 29 of 173 November 19, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 1 18:59 11/13/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 305,445.00- 305,445.00- 5,573.09- 5,573.09- 1.825 299,871.91- 122-40010-000-000 Property Taxes/MUD Fire 927,555.00- 927,555.00- 17,437.64- 17,437.64- 1.880 910,117.36- 122-40011-000-000 Property Taxes/Fire-Delinquent 105.52 105.52 105.52- 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- 750.00- 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 68.36- 68.36- 1.519 4,431.64- Subtotal: 1,238,250.00- 1,238,250.00- 22,973.57- 22,973.57- 1.855 1,215,276.43- 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 6,000.00- Subtotal: 6,000.00- 6,000.00- 6,000.00- 122-43400-000-000 Fire Inspections 700.00- 700.00- 700.00- 122-43415-000-000 Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00- Subtotal: 10,700.00- 10,700.00- 10,700.00- 122-49900-000-000 Miscellaneous Income 6,000.00- 6,000.00- 6,000.00- Subtotal: 6,000.00- 6,000.00- 6,000.00- Program number: 1,260,950.00- 1,260,950.00- 22,973.57- 22,973.57- 1.822 1,237,976.43- Department number: Fire Revenues 1,260,950.00- 1,260,950.00- 22,973.57- 22,973.57- 1.822 1,237,976.43- Revenues Subtotal ----------- 1,260,950.00- 1,260,950.00- 22,973.57- 22,973.57- 1.822 1,237,976.43- Trophy Club Municipal Utility District No. 1 30 of 173 November 19, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 2 18:59 11/13/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 455,916.00 455,916.00 24,181.65 24,181.65 5.304 431,734.35 122-50010-045-000 Overtime 44,225.00 44,225.00 3,174.34 3,174.34 7.178 41,050.66 122-50011-045-000 DPS Holiday Pay 13,529.00 13,529.00 13,529.00 122-50016-045-000 Longevity 4,768.00 4,768.00 4,768.00 122-50017-045-000 Certification 4,350.00 4,350.00 376.89 376.89 8.664 3,973.11 122-50020-045-000 Retirement 70,991.00 70,991.00 3,728.18 3,728.18 5.252 67,262.82 122-50026-045-000 Medical Insurance 56,968.00 56,968.00 4,008.49 4,008.49 7.036 52,959.51 122-50027-045-000 Dental Insurance 4,230.00 4,230.00 326.19 326.19 7.711 3,903.81 122-50028-045-000 Vision Insurance 892.00 892.00 68.30 68.30 7.657 823.70 122-50029-045-000 Life Insurance & Other 4,250.00 4,250.00 306.79 306.79 7.219 3,943.21 122-50030-045-000 Social Security Taxes 32,980.00 32,980.00 1,562.12 1,562.12 4.737 31,417.88 122-50035-045-000 Medicare Taxes 7,713.00 7,713.00 365.20 365.20 4.735 7,347.80 122-50040-045-000 Unemployment Taxes 2,259.00 2,259.00 .81 .81 .036 2,258.19 122-50045-045-000 Workman's Compensation 8,708.00 8,708.00 662.79 662.79 7.611 8,045.21 122-50060-045-000 Pre-employment Physicals/Test 500.00 500.00 500.00 122-50075-045-000 Tuition Reimbursement 600.00 600.00 600.00 Subtotal: 712,879.00 712,879.00 38,761.75 38,761.75 5.437 674,117.25 122-55030-045-000 Software & Support 8,682.00 8,682.00 8,682.00 122-55045-045-000 Legal 5,000.00 5,000.00 5,000.00 122-55080-045-000 Maintenance & Repairs 20,472.00 20,472.00 218.40 218.40 1.067 20,253.60 122-55090-045-000 Vehicle Maintenance 14,850.00 14,850.00 14,850.00 Subtotal: 49,004.00 49,004.00 218.40 218.40 .446 48,785.60 122-60005-045-000 Telephone 100.00 100.00 100.00 122-60010-045-000 Communications/Pagers/Mobiles 4,237.00 4,237.00 457.38 457.38 10.795 3,779.62 122-60020-045-000 Electricity/Gas 6,568.00 6,568.00 203.05 203.05 3.092 6,364.95 122-60025-045-000 Water 1,500.00 1,500.00 108.39 108.39 7.226 1,391.61 122-60030-045-000 Rent And/Or Usage 214,279.00 214,279.00 214,279.00 122-60035-045-000 Postage 100.00 100.00 3.10 3.10 3.100 96.90 122-60055-045-000 Insurance 12,110.00 12,110.00 1,009.25 1,009.25 8.334 11,100.75 122-60066-045-000 Publications/Books/Subscrips 400.00 400.00 400.00 122-60070-045-000 Dues & Memberships 15,180.00 15,180.00 1,577.76 1,577.76 10.394 13,602.24 122-60080-045-000 Schools & Training 4,280.00 4,280.00 1,064.00 1,064.00 24.860 3,216.00 122-60096-045-000 Emergency Management 2,000.00 2,000.00 1,000.00 1,000.00 50.000 1,000.00 122-60100-045-000 Travel & per diem 4,577.00 4,577.00 1,064.82 1,064.82 23.265 3,512.18 122-60110-045-000 Physicals/Testing 2,000.00 2,000.00 2,000.00 122-60125-045-000 Advertising 200.00 200.00 200.00 122-60160-045-000 Programs & Special Projects 4,500.00 4,500.00 341.17 341.17 7.582 4,158.83 122-60180-045-000 Fire Inspection/Enforcement 1,500.00 1,500.00 1,500.00 122-60195-045-000 Flags & Repair 2,000.00 2,000.00 2,000.00 122-60245-045-000 Miscellaneous Expense 1,000.00 1,000.00 1,000.00 Trophy Club Municipal Utility District No. 1 31 of 173 November 19, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 3 18:59 11/13/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 276,531.00 276,531.00 6,828.92 6,828.92 2.469 269,702.08 122-65005-045-000 Fuel & Lube 11,698.00 11,698.00 738.03 738.03 6.309 10,959.97 122-65010-045-000 Uniforms 3,360.00 3,360.00 3,360.00 122-65015-045-000 Protective Clothing 7,600.00 7,600.00 7,600.00 122-65030-045-000 Chemicals 1,000.00 1,000.00 1,000.00 122-65035-045-000 Small Tools 2,500.00 2,500.00 2,500.00 122-65085-045-000 Office Supplies 1,000.00 1,000.00 1,000.00 122-65105-045-000 Printing 100.00 100.00 100.00 Subtotal: 27,258.00 27,258.00 738.03 738.03 2.708 26,519.97 122-69008-045-000 Short Term Debt-Principal 70,000.00 70,000.00 70,000.00 122-69009-045-000 Short Term Debt-Interest 3,031.00 3,031.00 3,031.00 122-69050-045-000 Radios 34,200.00 34,200.00 34,200.00 122-69195-045-000 GASB34/Reserve for Replacement 67,647.00 67,647.00 67,647.00 122-69255-045-000 Airpacks 20,400.00 20,400.00 20,400.00 Subtotal: 195,278.00 195,278.00 195,278.00 Program number: 1,260,950.00 1,260,950.00 46,547.10 46,547.10 3.691 1,214,402.90 Department number: Fire 1,260,950.00 1,260,950.00 46,547.10 46,547.10 3.691 1,214,402.90 Expenditures Subtotal ----------- 1,260,950.00 1,260,950.00 46,547.10 46,547.10 3.691 1,214,402.90 Fund number: 122 Trophy Club MUD Fire Dept. 23,573.53 23,573.53 23,573.53- Trophy Club Municipal Utility District No. 1 32 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 1 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40001-000-000 Assessment - Emerg Svcs 202 10/16/2013 Property Taxes/Assessments (221.26) (221.26) GL 203 10/17/2013 Property Taxes/Assessments (462.84) (684.10) GL 206 10/18/2013 Property Taxes/Assessments (49.44) (733.54) GL 207 10/21/2013 Property Taxes/Assessments (1,623.90) (2,357.44) GL 208 10/22/2013 Property Taxes/Assessments (339.37) (2,696.81) GL 209 10/23/2013 Property Taxes/Assessments (415.49) (3,112.30) GL 210 10/24/2013 Property Taxes/Assessments (112.51) (3,224.81) GL 211 10/25/2013 Property Taxes/Assessments (66.71) (3,291.52) GL 212 10/28/2013 Property Taxes/Assessments (480.52) (3,772.04) GL 213 10/29/2013 Property Taxes/Assessments (1,024.74) (4,796.78) GL 215 10/31/2013 Property Taxes/Assessments (776.31) (5,573.09) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (5,573.09) (5,573.09) ** (305,445.00) Budgeted (299,871.91) Remaining 2 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 199 10/14/2013 Property Taxes/Assessments (330.86) (330.86) GL 200 10/15/2013 Property Taxes/Assessments (175.93) (506.79) GL 202 10/16/2013 Property Taxes/Assessments (694.97) (1,201.76) GL 203 10/17/2013 Property Taxes/Assessments (94.72) (1,296.48) GL 207 10/21/2013 Property Taxes/Assessments (3,399.32) (4,695.80) GL 208 10/22/2013 Property Taxes/Assessments (1,301.81) (5,997.61) GL 209 10/23/2013 Property Taxes/Assessments (2,412.86) (8,410.47) GL 210 10/24/2013 Property Taxes/Assessments (2,727.62) (11,138.09) GL 211 10/25/2013 Property Taxes/Assessments (1,126.17) (12,264.26) GL 212 10/28/2013 Property Taxes/Assessments (1,452.04) (13,716.30) GL 213 10/29/2013 Property Taxes/Assessments (1,037.05) (14,753.35) GL 214 10/30/2013 Property Taxes/Assessments (214.69) (14,968.04) GL 215 10/31/2013 Property Taxes/Assessments (2,469.60) (17,437.64) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (17,437.64) (17,437.64) ** (927,555.00) Budgeted (910,117.36) Remaining 2 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 199 10/14/2013 Property Taxes/Assessments 249.59 249.59 GL 202 10/16/2013 Property Taxes/Assessments (174.69) 74.90 GL 211 10/25/2013 Property Taxes/Assessments (25.85) 49.05 GL 212 10/28/2013 Property Taxes/Assessments (1.46) 47.59 GL 213 10/29/2013 Property Taxes/Assessments 100.19 147.78 GL 215 10/31/2013 Property Taxes/Assessments (42.26) 105.52 GL Trophy Club Municipal Utility District No. 1 33 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 2 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: 105.52 105.52 ** .00 Budgeted (105.52) Remaining 0 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I .00 .00 _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: .00 .00 ** (750.00) Budgeted (750.00) Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 199 10/14/2013 Property Taxes/Assessments (17.07) (17.07) GL 202 10/16/2013 Property Taxes/Assessments (36.68) (53.75) GL 211 10/25/2013 Property Taxes/Assessments (5.42) (59.17) GL 212 10/28/2013 Property Taxes/Assessments (.31) (59.48) GL 215 10/31/2013 Property Taxes/Assessments (8.88) (68.36) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (68.36) (68.36) ** (4,500.00) Budgeted (4,431.64) Remaining 2 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft .00 .00 _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: .00 .00 ** (6,000.00) Budgeted (6,000.00) Remaining 0 % Used Account: 122-43400-000-000 Fire Inspections .00 .00 _______________ Account: 122-43400-000-000 Fire Inspections Totals: .00 .00 ** (700.00) Budgeted (700.00) Remaining 0 % Used Account: 122-43415-000-000 Denton County Pledge-Fire .00 .00 _______________ Account: 122-43415-000-000 Denton County Pledge-Fire Totals: .00 .00 ** (10,000.00) Budgeted (10,000.00) Remaining 0 % Used Trophy Club Municipal Utility District No. 1 34 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 3 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-49900-000-000 Miscellaneous Income .00 .00 _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: .00 .00 ** (6,000.00) Budgeted (6,000.00) Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (22,973.57) ** (1,260,950.00) Budgeted (1,237,976.43) Remaining 2 % Used Trophy Club Municipal Utility District No. 1 35 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 4 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50005-045-000 Salaries & Wages 136 10/11/2013 FD P/R 10/1-10/5/13 6,074.77 6,074.77 GL 138 10/11/2013 D Thomas Cola 1,026.93 7,101.70 GL 139 10/25/2013 FD Payroll 10/25/13 17,079.95 24,181.65 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 24,181.65 24,181.65 ** 455,916.00 Budgeted 431,734.35 Remaining 5 % Used Account: 122-50010-045-000 Overtime 139 10/25/2013 FD Payroll 10/25/13 3,174.34 3,174.34 GL _______________ Account: 122-50010-045-000 Overtime Totals: 3,174.34 3,174.34 ** 44,225.00 Budgeted 41,050.66 Remaining 7 % Used Account: 122-50011-045-000 DPS Holiday Pay .00 .00 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 .00 ** 13,529.00 Budgeted 13,529.00 Remaining 0 % Used Account: 122-50016-045-000 Longevity .00 .00 _______________ Account: 122-50016-045-000 Longevity Totals: .00 .00 ** 4,768.00 Budgeted 4,768.00 Remaining 0 % Used Account: 122-50017-045-000 Certification 137 10/01/2013 Reverse 9/30 FD P/R Prepaids Cert 363.50 363.50 GL 136 10/11/2013 FD P/R 10/1-10/5/13 13.39 376.89 GL _______________ Account: 122-50017-045-000 Certification Totals: 376.89 376.89 ** 4,350.00 Budgeted 3,973.11 Remaining 9 % Used Account: 122-50020-045-000 Retirement 136 10/11/2013 FD P/R 10/1-10/5/13 840.13 840.13 GL 138 10/11/2013 D Thomas Cola 144.38 984.51 GL 139 10/25/2013 FD Payroll 10/25/13 2,743.67 3,728.18 GL Trophy Club Municipal Utility District No. 1 36 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 5 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-50020-045-000 Retirement Totals: 3,728.18 3,728.18 ** 70,991.00 Budgeted 67,262.82 Remaining 5 % Used Account: 122-50026-045-000 Medical Insurance 137 10/01/2013 Reverse 9/30 FD P/R Prepaids Medical Insurance 1,476.96 1,476.96 GL 136 10/11/2013 FD P/R 10/1-10/5/13 820.35 2,297.31 GL 139 10/25/2013 FD Payroll 10/25/13 1,711.18 4,008.49 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 4,008.49 4,008.49 ** 56,968.00 Budgeted 52,959.51 Remaining 7 % Used Account: 122-50027-045-000 Dental Insurance 137 10/01/2013 Reverse 9/30 FD P/R Prepaids Dental 104.86 104.86 GL 136 10/11/2013 FD P/R 10/1-10/5/13 58.19 163.05 GL 139 10/25/2013 FD Payroll 10/25/13 163.14 326.19 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 326.19 326.19 ** 4,230.00 Budgeted 3,903.81 Remaining 8 % Used Account: 122-50028-045-000 Vision Insurance 137 10/01/2013 Reverse 9/30 FD P/R Prepaids Vision 21.93 21.93 GL 136 10/11/2013 FD P/R 10/1-10/5/13 12.16 34.09 GL 139 10/25/2013 FD Payroll 10/25/13 34.21 68.30 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 68.30 68.30 ** 892.00 Budgeted 823.70 Remaining 8 % Used Account: 122-50029-045-000 Life Insurance & Other 137 10/01/2013 Reverse 9/30 FD P/R Prepaids Life Ins & Other 98.58 98.58 GL 136 10/11/2013 FD P/R 10/1-10/5/13 54.73 153.31 GL 139 10/25/2013 FD Payroll 10/25/13 153.48 306.79 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 306.79 306.79 ** 4,250.00 Budgeted 3,943.21 Remaining 7 % Used Account: 122-50030-045-000 Social Security Taxes 136 10/11/2013 FD P/R 10/1-10/5/13 340.71 340.71 GL Trophy Club Municipal Utility District No. 1 37 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 6 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 138 10/11/2013 D Thomas Cola 63.67 404.38 GL 139 10/25/2013 FD Payroll 10/25/13 1,157.74 1,562.12 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 1,562.12 1,562.12 ** 32,980.00 Budgeted 31,417.88 Remaining 5 % Used Account: 122-50035-045-000 Medicare Taxes 136 10/11/2013 FD P/R 10/1-10/5/13 79.61 79.61 GL 138 10/11/2013 D Thomas Cola 14.89 94.50 GL 139 10/25/2013 FD Payroll 10/25/13 270.70 365.20 GL _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 365.20 365.20 ** 7,713.00 Budgeted 7,347.80 Remaining 5 % Used Account: 122-50040-045-000 Unemployment Taxes 136 10/11/2013 FD P/R 10/1-10/5/13 .08 .08 GL 139 10/25/2013 FD Payroll 10/25/13 .73 .81 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: .81 .81 ** 2,259.00 Budgeted 2,258.19 Remaining 0 % Used Account: 122-50045-045-000 Workman's Compensation 116 10/01/2013 FD Oct W/C expense 662.79 662.79 GL _______________ Account: 122-50045-045-000 Workman's Compensation Totals: 662.79 662.79 ** 8,708.00 Budgeted 8,045.21 Remaining 8 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test .00 .00 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 122-50075-045-000 Tuition Reimbursement .00 .00 _______________ Account: 122-50075-045-000 Tuition Reimbursement Totals: .00 .00 ** 600.00 Budgeted 600.00 Remaining 0 % Used Trophy Club Municipal Utility District No. 1 38 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 7 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-55030-045-000 Software & Support .00 .00 _______________ Account: 122-55030-045-000 Software & Support Totals: .00 .00 ** 8,682.00 Budgeted 8,682.00 Remaining 0 % Used Account: 122-55045-045-000 Legal .00 .00 _______________ Account: 122-55045-045-000 Legal Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 122-55080-045-000 Maintenance & Repairs 255 10/31/2013 Recode Equip & Bldg Maint/Oct 2.87 2.87 GL 255 10/31/2013 Recode Equip & Bldg Maint/Oct 215.53 218.40 GL _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 218.40 218.40 ** 20,472.00 Budgeted 20,253.60 Remaining 1 % Used Account: 122-55090-045-000 Vehicle Maintenance .00 .00 _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: .00 .00 ** 14,850.00 Budgeted 14,850.00 Remaining 0 % Used Account: 122-55095-045-000 Equipment Maintenance 226 10/26/2013 10/1-10/26 PCards AUTOZONE #4206 2.87 2.87 AUTOZONE #4206 PC 255 10/31/2013 Recode Equip & Bldg Maint/Oct (2.87) .00 GL _______________ Account: 122-55095-045-000 Equipment Maintenance Totals: .00 .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 122-55100-045-000 Building Maintenance 219 10/03/2013 Fire Dept Oct Cable (120.00) (120.00) GL 226 10/26/2013 10/1-10/26 PCards ATT*BILL PAYMENT 133.68 13.68 ATT*BILL PAYMENT PC 226 10/26/2013 10/1-10/26 PCards ATT*BILL PAYMENT 152.83 166.51 ATT*BILL PAYMENT PC 247 10/31/2013 Oct A/P Rug Service Fire Station 24.51 191.02 G & K SERVICES 33154 AP 247 10/31/2013 Oct A/P Rug Service Fire Station 24.51 215.53 G & K SERVICES 33154 AP Trophy Club Municipal Utility District No. 1 39 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 8 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 255 10/31/2013 Recode Equip & Bldg Maint/Oct (215.53) .00 GL _______________ Account: 122-55100-045-000 Building Maintenance Totals: .00 .00 ** .00 Budgeted .00 Remaining 0 % Used Account: 122-60005-045-000 Telephone .00 .00 _______________ Account: 122-60005-045-000 Telephone Totals: .00 .00 ** 100.00 Budgeted 100.00 Remaining 0 % Used Account: 122-60010-045-000 Communications/Pagers/Mobiles 137 10/01/2013 Reverse 9/30 FD P/R Prepaids Cells 75.00 75.00 GL 155 10/30/2013 Oct A/P Copier lease, FD Communication 382.38 457.38 TOWN OF TROPHY CLUB 33135 AP _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 457.38 457.38 ** 4,237.00 Budgeted 3,779.62 Remaining 11 % Used Account: 122-60020-045-000 Electricity/Gas 114 10/23/2013 Oct A/P Oct Electricity 10/1-10/11 363.28 363.28 HUDSON ENERGY SERVICES, LLC 33097 AP 155 10/30/2013 Oct A/P Fire Station Gas-10/1-10/18 42.82 406.10 ATMOS ENERGY 33123 AP 233 10/31/2013 Town Billed Inv 1094-1100 AR 20131001-20131031 User: (203.05) 203.05 AR _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 203.05 203.05 ** 6,568.00 Budgeted 6,364.95 Remaining 3 % Used Account: 122-60025-045-000 Water 247 10/31/2013 Oct A/P October water 216.78 216.78 TROPHY CLUB MUD (WATER BILLS) 33175 AP 234 10/31/2013 Town billed Inv 1101 AR 20131031-20131031 User: (108.39) 108.39 AR _______________ Account: 122-60025-045-000 Water Totals: 108.39 108.39 ** 1,500.00 Budgeted 1,391.61 Remaining 7 % Used Account: 122-60030-045-000 Rent And/Or Usage .00 .00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 .00 ** 214,279.00 Budgeted 214,279.00 Remaining 0 % Used Trophy Club Municipal Utility District No. 1 40 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 9 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60035-045-000 Postage 235 10/31/2013 October Postage meter usage 3.10 3.10 GL _______________ Account: 122-60035-045-000 Postage Totals: 3.10 3.10 ** 100.00 Budgeted 96.90 Remaining 3 % Used Account: 122-60055-045-000 Insurance 47 10/01/2013 Oct Ins & W/C Expense 1,009.25 1,009.25 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,009.25 1,009.25 ** 12,110.00 Budgeted 11,100.75 Remaining 8 % Used Account: 122-60066-045-000 Publications/Books/Subscrips .00 .00 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 122-60070-045-000 Dues & Memberships 226 10/26/2013 10/1-10/26 PCards TX COMM ON FIRE PR 1,477.76 1,477.76 TX COMM ON FIRE PR PC 247 10/31/2013 Oct A/P 10/1/13-9/30/14 Membership due 100.00 1,577.76 FIRE INSTRUCTORS ASSOC OF N TX 33151 AP _______________ Account: 122-60070-045-000 Dues & Memberships Totals: 1,577.76 1,577.76 ** 15,180.00 Budgeted 13,602.24 Remaining 10 % Used Account: 122-60080-045-000 Schools & Training 36 10/03/2013 Town Billing Inv 1090 AR 20131001-20131031 User: (680.00) (680.00) AR 130 10/24/2013 October A/P Haz-Mat Cert-hurd 85.00 (595.00) TX COMM ON FIRE PROTECTION 33115 AP 130 10/24/2013 October A/P FD Training 1,360.00 765.00 MEDIC-CE.COM, LLC 33101 AP 226 10/26/2013 10/1-10/26 PCards 1105 MEDIA *EVENTS 299.00 1,064.00 1105 MEDIA *EVENTS PC _______________ Account: 122-60080-045-000 Schools & Training Totals: 1,064.00 1,064.00 ** 4,280.00 Budgeted 3,216.00 Remaining 25 % Used Account: 122-60096-045-000 Emergency Management 130 10/24/2013 October A/P Fire W/C, Charter, NCT COG Eme 1,000.00 1,000.00 TOWN OF TROPHY CLUB 33114 AP _______________ Account: 122-60096-045-000 Emergency Management Totals: 1,000.00 1,000.00 ** 2,000.00 Budgeted 1,000.00 Remaining 50 % Used Trophy Club Municipal Utility District No. 1 41 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 10 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60100-045-000 Travel & per diem 226 10/26/2013 10/1-10/26 PCards COUNTY LINE ON THE LAK 16.74 16.74 COUNTY LINE ON THE LAK PC 226 10/26/2013 10/1-10/26 PCards SALT LICK 27.84 44.58 SALT LICK PC 226 10/26/2013 10/1-10/26 PCards PAPPADEAUX SEAFOOD KIT 36.15 80.73 PAPPADEAUX SEAFOOD KIT PC 226 10/26/2013 10/1-10/26 PCards CROWN PLAZA HTL - ASTN 13.85 94.58 CROWN PLAZA HTL - ASTN PC 226 10/26/2013 10/1-10/26 PCards PAPPADEAUX SEAFOOD KIT 57.55 152.13 PAPPADEAUX SEAFOOD KIT PC 226 10/26/2013 10/1-10/26 PCards COUNTY LINE ON THE LAK 20.53 172.66 COUNTY LINE ON THE LAK PC 226 10/26/2013 10/1-10/26 PCards PAPPADEAUX SEAFOOD KIT 40.92 213.58 PAPPADEAUX SEAFOOD KIT PC 226 10/26/2013 10/1-10/26 PCards PAPPADEAUX SEAFOOD KIT 55.39 268.97 PAPPADEAUX SEAFOOD KIT PC 227 10/26/2013 10/26 PCards CROWN PLAZA HOTEL 391.00 659.97 CROWN PLAZA HOTEL PC 227 10/26/2013 10/26 PCards CROWN PLAZA HOTEL 404.85 1,064.82 CROWN PLAZA HOTEL PC _______________ Account: 122-60100-045-000 Travel & per diem Totals: 1,064.82 1,064.82 ** 4,577.00 Budgeted 3,512.18 Remaining 23 % Used Account: 122-60110-045-000 Physicals/Testing .00 .00 _______________ Account: 122-60110-045-000 Physicals/Testing Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 122-60125-045-000 Advertising .00 .00 _______________ Account: 122-60125-045-000 Advertising Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 122-60160-045-000 Programs & Special Projects 27 10/08/2013 Oct A/P Fire open house-Sparkle's Spec 150.00 150.00 TRACY HENRY 33084 AP 226 10/26/2013 10/1-10/26 PCards WAL-MART #5247 (3.96) 146.04 WAL-MART #5247 PC 226 10/26/2013 10/1-10/26 PCards WAL-MART #5247 31.20 177.24 WAL-MART #5247 PC 226 10/26/2013 10/1-10/26 PCards SUBWAY 00217794 139.96 317.20 SUBWAY 00217794 PC 226 10/26/2013 10/1-10/26 PCards WAL-MART #5247 23.97 341.17 WAL-MART #5247 PC _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: 341.17 341.17 ** 4,500.00 Budgeted 4,158.83 Remaining 8 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement .00 .00 Trophy Club Municipal Utility District No. 1 42 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 11 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 122-60195-045-000 Flags & Repair .00 .00 _______________ Account: 122-60195-045-000 Flags & Repair Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 122-60245-045-000 Miscellaneous Expense .00 .00 _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 122-65005-045-000 Fuel & Lube 226 10/26/2013 10/1-10/26 PCards EXXONMOBIL 47575899 68.25 68.25 EXXONMOBIL 47575899 PC 236 10/31/2013 October Gas Log 669.78 738.03 GL _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 738.03 738.03 ** 11,698.00 Budgeted 10,959.97 Remaining 6 % Used Account: 122-65010-045-000 Uniforms .00 .00 _______________ Account: 122-65010-045-000 Uniforms Totals: .00 .00 ** 3,360.00 Budgeted 3,360.00 Remaining 0 % Used Account: 122-65015-045-000 Protective Clothing .00 .00 _______________ Account: 122-65015-045-000 Protective Clothing Totals: .00 .00 ** 7,600.00 Budgeted 7,600.00 Remaining 0 % Used Account: 122-65030-045-000 Chemicals .00 .00 Trophy Club Municipal Utility District No. 1 43 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 12 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-65030-045-000 Chemicals Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 122-65035-045-000 Small Tools .00 .00 _______________ Account: 122-65035-045-000 Small Tools Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 122-65085-045-000 Office Supplies .00 .00 _______________ Account: 122-65085-045-000 Office Supplies Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 122-65105-045-000 Printing .00 .00 _______________ Account: 122-65105-045-000 Printing Totals: .00 .00 ** 100.00 Budgeted 100.00 Remaining 0 % Used Account: 122-69008-045-000 Short Term Debt-Principal .00 .00 _______________ Account: 122-69008-045-000 Short Term Debt-Principal Totals: .00 .00 ** 70,000.00 Budgeted 70,000.00 Remaining 0 % Used Account: 122-69009-045-000 Short Term Debt-Interest .00 .00 _______________ Account: 122-69009-045-000 Short Term Debt-Interest Totals: .00 .00 ** 3,031.00 Budgeted 3,031.00 Remaining 0 % Used Account: 122-69050-045-000 Radios .00 .00 Trophy Club Municipal Utility District No. 1 44 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 13 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-69050-045-000 Radios Totals: .00 .00 ** 34,200.00 Budgeted 34,200.00 Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement .00 .00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 .00 ** 67,647.00 Budgeted 67,647.00 Remaining 0 % Used Account: 122-69255-045-000 Airpacks .00 .00 _______________ Account: 122-69255-045-000 Airpacks Totals: .00 .00 ** 20,400.00 Budgeted 20,400.00 Remaining 0 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 46,547.10 ** 1,260,950.00 Budgeted 1,214,402.90 Remaining 4 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ 23,573.53 .00 Budgeted (23,573.53) Remaining 0 % Used Trophy Club Municipal Utility District No. 1 45 of 173 November 19, 2013 TROPHY CLUB MUD #1 - O&M BALANCE SHEET OCTOBER 31, 2013 GENERAL FUND GASB CAPITAL PROJECTS COMBINED BALANCE @ 10/31/13 ASSETS CASH ON HAND 600 - - 600 CASH IN BANK 439,774 - - 439,774 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 1,500,302 - - 1,500,302 INVESTMENTS-TEXPOOL 865,683 313,050 330,585 1,509,318 PREPAID EXPENSES 79,677 - - 79,677 ADVALOREM PROPERTY TAXES RECEIVABLE 99,782 - - 99,782 UTILITY AND OTHER ACCOUNTS RECEIVABLE 822,215 - - 822,215 - TOTAL ASSETS 3,808,033 313,050 330,585 4,451,668 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 99,782 - - 99,782 ACCOUNTS AND OTHER PAYABLES 265,569 - 88,356 353,925 CUSTOMER DEPOSITS 239,697 - - 239,697 - TOTAL LIABILITIES 605,048 - 88,356 693,404 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - 313,050 313,050 NON-SPENDABLE FUND BALANCE 29,524 29,524 ASSIGNED FUND BALANCE 276,500 245,101 521,601 UNASSIGNED FUND BALANCE 2,682,754 - - 2,682,754 RESERVE FOR ENCUMBRANCES - - - - NET REVENUES / EXPENDITURES 214,207 - (2,871) 211,336 - TOTAL FUND BALANCE 3,202,985 313,050 242,230 3,758,265 - TOTAL LIABILITIES AND FUND BALANCE 3,808,033 313,050 330,585 4,451,668 Trophy Club Municipal Utility District No. 1 46 of 173 November 19, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 4 18:59 11/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 99,250.00- 99,250.00- 1,865.89- 1,865.89- 1.880 97,384.11- 135-40002-000-000 Property Taxes/Delinquent 10.03 10.03 10.03- 135-40015-000-000 Property Taxes/P & I 900.00- 900.00- 34.30 34.30 -3.811 934.30- Subtotal: 100,150.00- 100,150.00- 1,821.56- 1,821.56- 1.819 98,328.44- 135-47000-000-000 Water 3,749,310.00- 3,749,310.00- 241,095.25- 241,095.25- 6.430 3,508,214.75- 135-47005-000-000 Sewer 1,708,321.00- 1,708,321.00- 140,301.05- 140,301.05- 8.213 1,568,019.95- 135-47025-000-000 Penalties 64,522.00- 64,522.00- 7,174.15- 7,174.15- 11.119 57,347.85- 135-47030-000-000 Service Charges 9,075.00- 9,075.00- 778.00- 778.00- 8.573 8,297.00- 135-47035-000-000 Plumbing Inspections 1,200.00- 1,200.00- 200.00- 200.00- 16.667 1,000.00- 135-47045-000-000 Sewer Inspections 4,400.00- 4,400.00- 900.00- 900.00- 20.455 3,500.00- 135-47070-000-000 TCCC Effluent Charges 79,586.00- 79,586.00- 7,272.30- 7,272.30- 9.138 72,313.70- Subtotal: 5,616,414.00- 5,616,414.00- 397,720.75- 397,720.75- 7.081 5,218,693.25- 135-48005-000-000 Utility Fees 582,109.00- 582,109.00- 34,500.00- 34,500.00- 5.927 547,609.00- Subtotal: 582,109.00- 582,109.00- 34,500.00- 34,500.00- 5.927 547,609.00- 135-49010-000-000 Interest Income 4,800.00- 4,800.00- 166.18- 166.18- 3.462 4,633.82- 135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 910.53- 8.958 9,253.47- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 583.33- 8.333 6,416.67- 135-49030-000-000 Vending Revenue 350.00- 350.00- 41.00- 41.00- 11.714 309.00- 135-49036-000-000 GASB Reserves 8,964.00- 8,964.00- 8,964.00- 135-49075-000-000 Oversize Meter Reimbursement 84,000.00- 84,000.00- 8,394.20- 8,394.20- 9.993 75,605.80- 135-49900-000-000 Miscellaneous Income 3,000.00- 3,000.00- .01- .01- 2,999.99- 135-49901-000-000 Records Management Revenue 100.00- 100.00- 100.00- 135-49905-000-000 Gas Well Revenue 886.00- 886.00- 886.00- Subtotal: 119,264.00- 119,264.00- 10,095.25- 10,095.25- 8.465 109,168.75- Program number: 6,417,937.00- 6,417,937.00- 444,137.56- 444,137.56- 6.920 5,973,799.44- Department number: Revenues 6,417,937.00- 6,417,937.00- 444,137.56- 444,137.56- 6.920 5,973,799.44- Revenues Subtotal ----------- 6,417,937.00- 6,417,937.00- 444,137.56- 444,137.56- 6.920 5,973,799.44- Trophy Club Municipal Utility District No. 1 47 of 173 November 19, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 5 18:59 11/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 287,709.00 287,709.00 11,917.83 11,917.83 4.142 275,791.17 135-50010-010-000 Overtime 13,391.00 13,391.00 773.82 773.82 5.779 12,617.18 135-50016-010-000 Longevity 4,905.00 4,905.00 4,905.00 135-50017-010-000 Certification 5,100.00 5,100.00 325.00 325.00 6.373 4,775.00 135-50020-010-000 Retirement 27,847.00 27,847.00 1,612.86 1,612.86 5.792 26,234.14 135-50026-010-000 Medical Insurance 48,334.00 48,334.00 2,378.20 2,378.20 4.920 45,955.80 135-50027-010-000 Dental Insurance 3,932.00 3,932.00 206.23 206.23 5.245 3,725.77 135-50028-010-000 Vision Insurance 873.00 873.00 45.77 45.77 5.243 827.23 135-50029-010-000 Life Insurance & Other 3,306.00 3,306.00 155.48 155.48 4.703 3,150.52 135-50030-010-000 Social Security Taxes 19,289.00 19,289.00 1,100.62 1,100.62 5.706 18,188.38 135-50035-010-000 Medicare Taxes 4,511.00 4,511.00 257.39 257.39 5.706 4,253.61 135-50040-010-000 Unemployment Taxes 54.00 54.00 54.00 135-50045-010-000 Workman's Compensation 9,829.00 9,829.00 802.45 802.45 8.164 9,026.55 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 36.45 36.45 18.225 163.55 135-50070-010-000 Employee Relations 300.00 300.00 8.99 8.99 2.997 291.01 Subtotal: 429,580.00 429,580.00 19,621.09 19,621.09 4.568 409,958.91 135-55005-010-000 Engineering 3,000.00 3,000.00 3,000.00 135-55080-010-000 Maintenance & Repairs 50,000.00 50,000.00 6,474.45 6,474.45 12.949 43,525.55 135-55090-010-000 Vehicle Maintenance 5,000.00 5,000.00 884.15 884.15 17.683 4,115.85 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 3,500.00 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 5,500.00 Subtotal: 67,000.00 67,000.00 7,358.60 7,358.60 10.983 59,641.40 135-60010-010-000 Communications/Pagers/Mobiles 4,913.00 4,913.00 4,913.00 135-60020-010-000 Electricity 162,160.00 162,160.00 5,717.42 5,717.42 3.526 156,442.58 135-60066-010-000 Publications/Books/Subscripts 500.00 500.00 500.00 135-60070-010-000 Dues & Memberships 150.00 150.00 150.00 135-60080-010-000 Schools & Training 4,184.00 4,184.00 4,184.00 135-60090-010-000 Safety Program 400.00 400.00 400.00 135-60100-010-000 Travel & per diem 1,450.00 1,450.00 1,450.00 135-60105-010-000 Rent/Lease Equipment 500.00 500.00 6.00 6.00 1.200 494.00 135-60135-010-000 TCEQ Fees & Permits 47,400.00 47,400.00 47,400.00 135-60150-010-000 Wholesale Water 2,338,473.00 2,338,473.00 2,338,473.00 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,500.00 3,500.00 280.60 280.60 8.017 3,219.40 135-60285-010-000 Lawn Equipment & Maintenance 250.00 250.00 250.00 135-60360-010-000 Furniture/Equipment < $5000 3,500.00 3,500.00 3,500.00 Subtotal: 2,567,580.00 2,567,580.00 6,004.02 6,004.02 .234 2,561,575.98 135-65005-010-000 Fuel & Lube 23,181.00 23,181.00 1,156.44 1,156.44 4.989 22,024.56 Trophy Club Municipal Utility District No. 1 48 of 173 November 19, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 6 18:59 11/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-010-000 Uniforms 3,270.00 3,270.00 89.99 89.99 2.752 3,180.01 135-65030-010-000 Chemicals 5,000.00 5,000.00 983.96 983.96 19.679 4,016.04 135-65035-010-000 Small Tools 1,200.00 1,200.00 464.94 464.94 38.745 735.06 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 1,000.00 135-65050-010-000 Meter Expense 143,550.00 143,550.00 54,740.30 54,740.30 38.133 88,809.70 Subtotal: 177,201.00 177,201.00 57,435.63 57,435.63 32.413 119,765.37 135-69005-010-000 Capital Expenses 37,000.00 37,000.00 37,000.00 135-69008-010-000 Short Term Debt-Principal 489,980.00 489,980.00 489,980.00 135-69009-010-000 Short Term Debt-Interest 19,268.00 19,268.00 19,268.00 135-69195-010-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 30,000.00 135-69280-010-000 Capital Repairs 7,500.00 7,500.00 7,500.00 135-69281-010-000 Capital Repair-Ground Storage 106,847.00 106,847.00 106,847.00 Subtotal: 690,595.00 690,595.00 690,595.00 Program number: 3,931,956.00 3,931,956.00 90,419.34 90,419.34 2.300 3,841,536.66 Trophy Club Municipal Utility District No. 1 49 of 173 November 19, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 7 18:59 11/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 10/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis 1,000.00 1,000.00 1,000.00 Subtotal: 1,000.00 1,000.00 1,000.00 Program number: 1 Lab Analysis for PID 1,000.00 1,000.00 1,000.00 Department number: Water 3,932,956.00 3,932,956.00 90,419.34 90,419.34 2.299 3,842,536.66 Trophy Club Municipal Utility District No. 1 50 of 173 November 19, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 8 18:59 11/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 202,894.00 202,894.00 10,212.71 10,212.71 5.034 192,681.29 135-50010-020-000 Overtime 11,965.00 11,965.00 783.14 783.14 6.545 11,181.86 135-50016-020-000 Longevity 2,998.00 2,998.00 2,998.00 135-50017-020-000 Certification 4,800.00 4,800.00 400.00 400.00 8.333 4,400.00 135-50020-020-000 Retirement 19,905.00 19,905.00 1,491.70 1,491.70 7.494 18,413.30 135-50026-020-000 Medical Insurance 43,471.00 43,471.00 3,293.23 3,293.23 7.576 40,177.77 135-50027-020-000 Dental Insurance 2,989.00 2,989.00 226.46 226.46 7.576 2,762.54 135-50028-020-000 Vision Insurance 658.00 658.00 49.93 49.93 7.588 608.07 135-50029-020-000 Life Insurance & Other 2,303.00 2,303.00 168.15 168.15 7.301 2,134.85 135-50030-020-000 Social Security Taxes 13,805.00 13,805.00 894.34 894.34 6.478 12,910.66 135-50035-020-000 Medicare Taxes 3,229.00 3,229.00 209.15 209.15 6.477 3,019.85 135-50040-020-000 Unemployment Taxes 36.00 36.00 36.00 135-50045-020-000 Workman's Compensation 6,552.00 6,552.00 535.08 535.08 8.167 6,016.92 135-50060-020-000 Pre-emp Physicals/Testing 150.00 150.00 150.00 135-50070-020-000 Employee Relations 350.00 350.00 8.99 8.99 2.569 341.01 Subtotal: 316,105.00 316,105.00 18,272.88 18,272.88 5.781 297,832.12 135-55080-020-000 Maintenance & Repairs 35,000.00 35,000.00 363.02 363.02 1.037 34,636.98 135-55090-020-000 Vehicle Maintenance 2,000.00 2,000.00 141.98 141.98 7.099 1,858.02 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 500.00 135-55125-020-000 Dumpster Services 52,000.00 52,000.00 52,000.00 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 2,938.00 2,938.00 9.793 27,062.00 Subtotal: 119,500.00 119,500.00 3,443.00 3,443.00 2.881 116,057.00 135-60010-020-000 Communications/Pagers/Mobiles 3,329.00 3,329.00 3,329.00 135-60020-020-000 Electricity 148,227.00 148,227.00 3,256.32 3,256.32 2.197 144,970.68 135-60066-020-000 Publications/Books/Subscripts 400.00 400.00 40.00 40.00 10.000 360.00 135-60080-020-000 Schools & Training 2,636.00 2,636.00 2,636.00 135-60090-020-000 Safety Program 250.00 250.00 38.55 38.55 15.420 211.45 135-60100-020-000 Travel & per diem 1,050.00 1,050.00 1,050.00 135-60105-020-000 Rent/Lease Equipment 1,500.00 1,500.00 299.53 299.53 19.969 1,200.47 135-60135-020-000 TCEQ Fees & Permits 17,150.00 17,150.00 17,150.00 135-60245-020-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60285-020-000 Lawn Equipment & Maintenance 500.00 500.00 500.00 135-60360-020-000 Furniture/Equipment < $5000 3,000.00 3,000.00 3,000.00 Subtotal: 178,242.00 178,242.00 3,634.40 3,634.40 2.039 174,607.60 135-65005-020-000 Fuel & Lube 14,720.00 14,720.00 972.51 972.51 6.607 13,747.49 135-65010-020-000 Uniforms 1,752.00 1,752.00 1,284.28 1,284.28 73.304 467.72 135-65030-020-000 Chemicals 39,000.00 39,000.00 2,949.64 2,949.64 7.563 36,050.36 135-65035-020-000 Small Tools 1,000.00 1,000.00 47.34 47.34 4.734 952.66 Trophy Club Municipal Utility District No. 1 51 of 173 November 19, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 9 18:59 11/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65040-020-000 Safety Equipment 250.00 250.00 56.43 56.43 22.572 193.57 135-65045-020-000 Lab Supplies 15,000.00 15,000.00 4,284.43 4,284.43 28.563 10,715.57 Subtotal: 71,722.00 71,722.00 9,594.63 9,594.63 13.378 62,127.37 135-69005-020-000 Capital Expenses 31,000.00 31,000.00 31,000.00 135-69008-020-000 Short Term Debt-Principal 20,020.00 20,020.00 20,020.00 135-69009-020-000 Short Term Debt-Interest 1,422.00 1,422.00 1,422.00 135-69280-020-000 Capital Repairs 30,000.00 30,000.00 30,000.00 Subtotal: 82,442.00 82,442.00 82,442.00 Program number: 768,011.00 768,011.00 34,944.91 34,944.91 4.550 733,066.09 Department number: Wastewater 768,011.00 768,011.00 34,944.91 34,944.91 4.550 733,066.09 Trophy Club Municipal Utility District No. 1 52 of 173 November 19, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 10 18:59 11/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 10/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-021-000 Salaries & Wages 90,299.00 90,299.00 5,458.64 5,458.64 6.045 84,840.36 135-50010-021-000 Overtime 10,028.00 10,028.00 736.32 736.32 7.343 9,291.68 135-50016-021-000 Longevity 17,913.00 17,913.00 17,913.00 135-50017-021-000 Certification 1,800.00 1,800.00 150.00 150.00 8.333 1,650.00 135-50020-021-000 Retirement 9,025.00 9,025.00 924.77 924.77 10.247 8,100.23 135-50026-021-000 Medical Insurance 23,668.00 23,668.00 2,057.31 2,057.31 8.692 21,610.69 135-50027-021-000 Dental Insurance 1,703.00 1,703.00 144.43 144.43 8.481 1,558.57 135-50028-021-000 Vision Insurance 314.00 314.00 28.21 28.21 8.984 285.79 135-50029-021-000 Life Insurance & Other 1,066.00 1,066.00 123.22 123.22 11.559 942.78 135-50030-021-000 Social Security Taxes 7,442.00 7,442.00 571.15 571.15 7.675 6,870.85 135-50035-021-000 Medicare Taxes 1,741.00 1,741.00 133.57 133.57 7.672 1,607.43 135-50040-021-000 Unemployment Taxes 198.00 198.00 198.00 135-50045-021-000 Workman's Compensation 3,276.00 3,276.00 267.54 267.54 8.167 3,008.46 135-50070-021-000 Employee Relations 200.00 200.00 8.99 8.99 4.495 191.01 Subtotal: 168,673.00 168,673.00 10,604.15 10,604.15 6.287 158,068.85 135-55005-021-000 Engineering 1,500.00 1,500.00 1,500.00 135-55080-021-000 Maintenance & Repairs 23,801.00 23,801.00 27.97 27.97 .118 23,773.03 135-55090-021-000 Vehicle Maintenance 2,000.00 2,000.00 2,000.00 Subtotal: 27,301.00 27,301.00 27.97 27.97 .102 27,273.03 135-60010-021-000 Communications/Pagers/Mobiles 1,333.00 1,333.00 1,333.00 135-60020-021-000 Electricity 21,178.00 21,178.00 365.94 365.94 1.728 20,812.06 135-60070-021-000 Dues & Memberships 250.00 250.00 250.00 135-60080-021-000 Schools & Training 1,711.00 1,711.00 1,711.00 135-60090-021-000 Safety Program 300.00 300.00 300.00 135-60100-021-000 Travel & per diem 550.00 550.00 550.00 135-60105-021-000 Rent/Lease Equipment 10,000.00 10,000.00 10,000.00 135-60245-021-000 Miscellaneous Expenses 100.00 100.00 100.00 Subtotal: 35,422.00 35,422.00 365.94 365.94 1.033 35,056.06 135-65005-021-000 Fuel & Lube 22,397.00 22,397.00 1,030.84 1,030.84 4.603 21,366.16 135-65010-021-000 Uniforms 1,040.00 1,040.00 576.14 576.14 55.398 463.86 135-65030-021-000 Chemicals 6,000.00 6,000.00 6,000.00 135-65035-021-000 Small Tools 1,000.00 1,000.00 43.99 43.99 4.399 956.01 135-65040-021-000 Safety Equipment 500.00 500.00 540.75 540.75 108.150 40.75- Subtotal: 30,937.00 30,937.00 2,191.72 2,191.72 7.084 28,745.28 135-69005-021-000 Capital Expenses 100,000.00 100,000.00 100,000.00 135-69008-021-000 Short Term Debt-Principal 35,991.00 35,991.00 35,991.00 Trophy Club Municipal Utility District No. 1 53 of 173 November 19, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 11 18:59 11/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 10/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-69009-021-000 Short Term Debt-Interest 2,846.00 2,846.00 2,846.00 135-69280-021-000 Capital Repairs 71,000.00 71,000.00 71,000.00 Subtotal: 209,837.00 209,837.00 209,837.00 Program number: 472,170.00 472,170.00 13,189.78 13,189.78 2.793 458,980.22 Department number: Collection 472,170.00 472,170.00 13,189.78 13,189.78 2.793 458,980.22 Trophy Club Municipal Utility District No. 1 54 of 173 November 19, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 12 18:59 11/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 10/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026-000 Salaries & Wages 10,000.00 10,000.00 1,000.00 1,000.00 10.000 9,000.00 135-50030-026-000 Social Security Taxes 620.00 620.00 62.00 62.00 10.000 558.00 135-50035-026-000 Medicare Taxes 145.00 145.00 14.50 14.50 10.000 130.50 135-50040-026-000 Unemployment Taxes 10.00 10.00 1.00 1.00 10.000 9.00 135-50045-026-000 Workman's Compensation 36.00 36.00 2.95 2.95 8.194 33.05 Subtotal: 10,811.00 10,811.00 1,080.45 1,080.45 9.994 9,730.55 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 500.00 500.00 500.00 135-60075-026-000 Meetings 1,200.00 1,200.00 5.00 5.00 .417 1,195.00 135-60080-026-000 Schools & Training 4,000.00 4,000.00 4,000.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 5,000.00 135-60245-026-000 Miscellaneous Expenses 1,000.00 1,000.00 1,000.00 Subtotal: 11,850.00 11,850.00 5.00 5.00 .042 11,845.00 Program number: 22,661.00 22,661.00 1,085.45 1,085.45 4.790 21,575.55 Department number: Board of Directors 22,661.00 22,661.00 1,085.45 1,085.45 4.790 21,575.55 Trophy Club Municipal Utility District No. 1 55 of 173 November 19, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 13 18:59 11/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 458,721.00 458,721.00 23,216.15 23,216.15 5.061 435,504.85 135-50010-030-000 Overtime 500.00 500.00 211.07 211.07 42.214 288.93 135-50016-030-000 Longevity 3,018.00 3,018.00 3,018.00 135-50020-030-000 Retirement 41,419.00 41,419.00 3,076.50 3,076.50 7.428 38,342.50 135-50026-030-000 Medical Insurance 57,923.00 57,923.00 4,388.10 4,388.10 7.576 53,534.90 135-50027-030-000 Dental Insurance 5,100.00 5,100.00 386.34 386.34 7.575 4,713.66 135-50028-030-000 Vision Insurance 1,087.00 1,087.00 82.53 82.53 7.592 1,004.47 135-50029-030-000 Life Insurance & Other 4,483.00 4,483.00 336.77 336.77 7.512 4,146.23 135-50030-030-000 Social Security Taxes 28,659.00 28,659.00 1,979.43 1,979.43 6.907 26,679.57 135-50035-030-000 Medicare Taxes 6,702.00 6,702.00 462.95 462.95 6.908 6,239.05 135-50040-030-000 Unemployment Taxes 63.00 63.00 63.00 135-50045-030-000 Workman's Compensation 1,575.00 1,575.00 128.63 128.63 8.167 1,446.37 135-50060-030-000 Pre-emp Physicals/Testing 200.00 200.00 200.00 135-50070-030-000 Employee Relations 5,000.00 5,000.00 702.85 702.85 14.057 4,297.15 Subtotal: 614,450.00 614,450.00 34,971.32 34,971.32 5.691 579,478.68 135-55030-030-000 Software & Support 59,698.00 59,698.00 2,625.50 2,625.50 4.398 57,072.50 135-55070-030-000 Independent Labor 7,700.00 7,700.00 1,780.45 1,780.45 23.123 5,919.55 135-55080-030-000 Maintenance & Repairs 4,500.00 4,500.00 4,500.00 135-55100-030-000 Building Maint & Supplies 6,500.00 6,500.00 139.84 139.84 2.151 6,360.16 135-55120-030-000 Cleaning Services 19,140.00 19,140.00 19,140.00 135-55160-030-000 Professional Outside Services 15,000.00 15,000.00 15,000.00 135-55161-030-000 Outside Services-Town Semo 77,048.00 77,048.00 38,524.00 38,524.00 50.000 38,524.00 135-55165-030-000 Collection Fees 200.00 200.00 200.00 135-55205-030-000 Utility Billing Contract 6,808.00 6,808.00 6,808.00 Subtotal: 196,594.00 196,594.00 43,069.79 43,069.79 21.908 153,524.21 135-60005-030-000 Telephone 11,250.00 11,250.00 205.00 205.00 1.822 11,045.00 135-60010-030-000 Communications/Pagers/Mobiles 3,589.00 3,589.00 150.00 150.00 4.179 3,439.00 135-60020-030-000 Electricity/Gas 15,171.00 15,171.00 15,171.00 135-60025-030-000 Water 1,500.00 1,500.00 101.26 101.26 6.751 1,398.74 135-60035-030-000 Postage 28,500.00 28,500.00 1,267.32 1,267.32 4.447 27,232.68 135-60040-030-000 Service Charges & Fees 28,330.00 28,330.00 28,330.00 135-60050-030-000 Bad Debt Expense 1,500.00 1,500.00 1,500.00 135-60055-030-000 Insurance 53,561.00 53,561.00 4,302.98 4,302.98 8.034 49,258.02 135-60066-030-000 Publications/Books/Subscripts 1,000.00 1,000.00 1,000.00 135-60070-030-000 Dues & Memberships 4,500.00 4,500.00 100.00 100.00 2.222 4,400.00 135-60075-030-000 Meetings 400.00 400.00 400.00 135-60080-030-000 Schools & Training 7,500.00 7,500.00 7,500.00 135-60100-030-000 Travel & per diem 5,000.00 5,000.00 5,000.00 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 135-60115-030-000 Elections 2,500.00 2,500.00 2,500.00 Trophy Club Municipal Utility District No. 1 56 of 173 November 19, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 14 18:59 11/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60125-030-000 Advertising 2,500.00 2,500.00 2,500.00 135-60235-030-000 Security 1,350.00 1,350.00 1,350.00 135-60245-030-000 Miscellaneous Expenses 22,870.00 22,870.00 19.70 19.70 .086 22,850.30 135-60270-030-000 4th of July Celebration 10,500.00 10,500.00 10,500.00 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 2,500.00 Subtotal: 204,221.00 204,221.00 6,146.26 6,146.26 3.010 198,074.74 135-65010-030-000 Uniforms 1,390.00 1,390.00 1,390.00 135-65055-030-000 Hardware 13,562.00 13,562.00 305.97 305.97 2.256 13,256.03 135-65085-030-000 Office Supplies 9,100.00 9,100.00 673.48 673.48 7.401 8,426.52 135-65090-030-000 Printer Supplies & Maintenance 5,732.00 5,732.00 5,732.00 135-65095-030-000 Maintenance Supplies 2,500.00 2,500.00 94.40 94.40 3.776 2,405.60 135-65097-030-000 Vending Machine Supplies 200.00 200.00 27.06 27.06 13.530 172.94 135-65105-030-000 Printing 4,000.00 4,000.00 1,401.00 1,401.00 35.025 2,599.00 Subtotal: 36,484.00 36,484.00 2,501.91 2,501.91 6.858 33,982.09 135-69170-030-000 Copier Lease Installments 3,450.00 3,450.00 256.85 256.85 7.445 3,193.15 Subtotal: 3,450.00 3,450.00 256.85 256.85 7.445 3,193.15 Program number: 1,055,199.00 1,055,199.00 86,946.13 86,946.13 8.240 968,252.87 Department number: Administration 1,055,199.00 1,055,199.00 86,946.13 86,946.13 8.240 968,252.87 Trophy Club Municipal Utility District No. 1 57 of 173 November 19, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 15 18:59 11/13/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 10/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 131,300.00 131,300.00 131,300.00 135-55055-039-000 Auditing 21,840.00 21,840.00 21,840.00 135-55060-039-000 Appraisal 10,000.00 10,000.00 3,344.70 3,344.70 33.447 6,655.30 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 3,800.00 Subtotal: 166,940.00 166,940.00 3,344.70 3,344.70 2.004 163,595.30 Program number: 166,940.00 166,940.00 3,344.70 3,344.70 2.004 163,595.30 Department number: Non Departmental 166,940.00 166,940.00 3,344.70 3,344.70 2.004 163,595.30 Expenditures Subtotal ----------- 6,417,937.00 6,417,937.00 229,930.31 229,930.31 3.583 6,188,006.69 Fund number: 135 MUD 1 General Fund 214,207.25- 214,207.25- 214,207.25 Trophy Club Municipal Utility District No. 1 58 of 173 November 19, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 16 18:59 11/13/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 10/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-49010-000-000 Interest Income 13.98- 13.98- 13.98 Subtotal: 13.98- 13.98- 13.98 Program number: 13.98- 13.98- 13.98 Department number: 13.98- 13.98- 13.98 Revenues Subtotal ----------- 13.98- 13.98- 13.98 Trophy Club Municipal Utility District No. 1 59 of 173 November 19, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 17 18:59 11/13/13 Budget Summary with Amendment Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 2 Rate of Flow Control-FW Meter Period Ending: 10/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 507-69280-010-002 Capital Repairs/ROFC FW Meter 2,885.00 2,885.00 2,885.00- Subtotal: 2,885.00 2,885.00 2,885.00- Program number: 2 Rate of Flow Control-FW Meter 2,885.00 2,885.00 2,885.00- Department number: Water 2,885.00 2,885.00 2,885.00- Expenditures Subtotal ----------- 2,885.00 2,885.00 2,885.00- Fund number: 507 MUD 1 Capital Projects 2,871.02 2,871.02 2,871.02- Trophy Club Municipal Utility District No. 1 60 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 14 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2013 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 199 10/14/2013 Property Taxes/Assessments (35.40) (35.40) GL 200 10/15/2013 Property Taxes/Assessments (18.82) (54.22) GL 202 10/16/2013 Property Taxes/Assessments (74.36) (128.58) GL 203 10/17/2013 Property Taxes/Assessments (10.14) (138.72) GL 207 10/21/2013 Property Taxes/Assessments (363.74) (502.46) GL 208 10/22/2013 Property Taxes/Assessments (139.30) (641.76) GL 209 10/23/2013 Property Taxes/Assessments (258.19) (899.95) GL 210 10/24/2013 Property Taxes/Assessments (291.87) (1,191.82) GL 211 10/25/2013 Property Taxes/Assessments (120.50) (1,312.32) GL 212 10/28/2013 Property Taxes/Assessments (155.37) (1,467.69) GL 213 10/29/2013 Property Taxes/Assessments (110.97) (1,578.66) GL 214 10/30/2013 Property Taxes/Assessments (22.97) (1,601.63) GL 215 10/31/2013 Property Taxes/Assessments (264.26) (1,865.89) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (1,865.89) (1,865.89) ** (99,250.00) Budgeted (97,384.11) Remaining 2 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 199 10/14/2013 Property Taxes/Assessments 23.73 23.73 GL 202 10/16/2013 Property Taxes/Assessments (16.61) 7.12 GL 211 10/25/2013 Property Taxes/Assessments (2.46) 4.66 GL 212 10/28/2013 Property Taxes/Assessments (.14) 4.52 GL 213 10/29/2013 Property Taxes/Assessments 9.53 14.05 GL 215 10/31/2013 Property Taxes/Assessments (4.02) 10.03 GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: 10.03 10.03 ** .00 Budgeted (10.03) Remaining 0 % Used Account: 135-40015-000-000 Property Taxes/P & I 199 10/14/2013 Property Taxes/Assessments (1.62) (1.62) GL 199 10/14/2013 Property Taxes/Assessments 40.80 39.18 GL 202 10/16/2013 Property Taxes/Assessments (3.49) 35.69 GL 211 10/25/2013 Property Taxes/Assessments (.52) 35.17 GL 212 10/28/2013 Property Taxes/Assessments (.03) 35.14 GL 215 10/31/2013 Property Taxes/Assessments (.84) 34.30 GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: 34.30 34.30 ** (900.00) Budgeted (934.30) Remaining -4 % Used Account: 135-47000-000-000 Water Trophy Club Municipal Utility District No. 1 61 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 15 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 274 10/01/2013 Reverse UB Accrued Sept billin 65,451.01 65,451.01 GL 83 10/09/2013 UB 10/9/13 PM Connect Fee UB20131009-20131009 User: (100.00) 65,351.01 UB 84 10/10/2013 UB 10/10/13 PM Connect Fee UB20131010-20131010 User: (100.00) 65,251.01 UB 185 10/31/2013 UB 10/31/13 Billing UB20131031-20131031 User: (306,346.26) (241,095.25) UB _______________ Account: 135-47000-000-000 Water Totals: (241,095.25) (241,095.25) ** (3,749,310.00) Budgeted (3,508,214.75) Remaining 6 % Used Account: 135-47005-000-000 Sewer 274 10/01/2013 Reverse UB Accrued Sept billin 36,406.75 36,406.75 GL 185 10/31/2013 UB 10/31/13 Billing UB20131031-20131031 User: (176,707.80) (140,301.05) UB _______________ Account: 135-47005-000-000 Sewer Totals: (140,301.05) (140,301.05) ** (1,708,321.00) Budgeted (1,568,019.95) Remaining 8 % Used Account: 135-47025-000-000 Penalties 110 10/22/2013 UB 10/22/13 Penalties UB20131022-20131022 User: (7,531.17) (7,531.17) UB 166 10/22/2013 UB 10/22/13 Penalty Adjustment UB20131022-20131022 User: 190.62 (7,340.55) UB 173 10/31/2013 UB 10/31/13 Penalty Removals UB20131031-20131031 User: 166.40 (7,174.15) UB _______________ Account: 135-47025-000-000 Penalties Totals: (7,174.15) (7,174.15) ** (64,522.00) Budgeted (57,347.85) Remaining 11 % Used Account: 135-47030-000-000 Service Charges 29 10/09/2013 UB 10/9/13 Cut Off List Fee UB20131009-20131009 User: (650.00) (650.00) UB 179 10/17/2013 UB 10/17/13 NSF Check Fee UB20131017-20131017 User: (25.00) (675.00) UB 231 10/23/2013 UB 10/23/13 Adjustment NSF UB20131023-20131023 User: (50.00) (725.00) UB 181 10/25/2013 UB 10/25/13 NSF Check Fee UB20131025-20131025 User: (25.00) (750.00) UB 185 10/31/2013 UB 10/31/13 Billing UB20131031-20131031 User: (28.00) (778.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (778.00) (778.00) ** (9,075.00) Budgeted (8,297.00) Remaining 9 % Used Account: 135-47035-000-000 Plumbing Inspections 233 10/31/2013 Town Billed Inv 1094-1100 AR 20131001-20131031 User: (200.00) (200.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (200.00) (200.00) ** (1,200.00) Budgeted (1,000.00) Remaining 17 % Used Trophy Club Municipal Utility District No. 1 62 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 16 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-47045-000-000 Sewer Inspections 233 10/31/2013 Town Billed Inv 1094-1100 AR 20131001-20131031 User: (900.00) (900.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (900.00) (900.00) ** (4,400.00) Budgeted (3,500.00) Remaining 20 % Used Account: 135-47070-000-000 TCCC Effluent Charges 185 10/31/2013 UB 10/31/13 Billing UB20131031-20131031 User: (7,272.30) (7,272.30) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (7,272.30) (7,272.30) ** (79,586.00) Budgeted (72,313.70) Remaining 9 % Used Account: 135-48005-000-000 Utility Fees 233 10/31/2013 Town Billed Inv 1094-1100 AR 20131001-20131031 User: (34,500.00) (34,500.00) AR _______________ Account: 135-48005-000-000 Utility Fees Totals: (34,500.00) (34,500.00) ** (582,109.00) Budgeted (547,609.00) Remaining 6 % Used Account: 135-49010-000-000 Interest Income 225 10/31/2013 Bank Interest/Oct (82.27) (82.27) GL 225 10/31/2013 Bank Interest/Oct (83.91) (166.18) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (166.18) (166.18) ** (4,800.00) Budgeted (4,633.82) Remaining 3 % Used Account: 135-49016-000-000 Cell Tower Revenue 218 10/03/2013 Oct AT&T Antenna Lease (910.53) (910.53) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (910.53) ** (10,164.00) Budgeted (9,253.47) Remaining 9 % Used Account: 135-49018-000-000 Building Rent Income 233 10/31/2013 Town Billed Inv 1094-1100 AR 20131001-20131031 User: (583.33) (583.33) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (583.33) ** (7,000.00) Budgeted (6,416.67) Remaining 8 % Used Account: 135-49030-000-000 Vending Revenue Trophy Club Municipal Utility District No. 1 63 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 17 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 220 10/15/2013 WWTP Vending (41.00) (41.00) GL _______________ Account: 135-49030-000-000 Vending Revenue Totals: (41.00) (41.00) ** (350.00) Budgeted (309.00) Remaining 12 % Used Account: 135-49036-000-000 GASB Reserves .00 .00 _______________ Account: 135-49036-000-000 GASB Reserves Totals: .00 .00 ** (8,964.00) Budgeted (8,964.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 233 10/31/2013 Town Billed Inv 1094-1100 AR 20131001-20131031 User: (8,394.20) (8,394.20) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (8,394.20) (8,394.20) ** (84,000.00) Budgeted (75,605.80) Remaining 10 % Used Account: 135-49900-000-000 Miscellaneous Income 256 10/31/2013 Bank Rec adjustment (.01) (.01) GL _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (.01) (.01) ** (3,000.00) Budgeted (2,999.99) Remaining 0 % Used Account: 135-49901-000-000 Records Management Revenue .00 .00 _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 .00 ** (100.00) Budgeted (100.00) Remaining 0 % Used Account: 135-49905-000-000 Gas Well Revenue .00 .00 _______________ Account: 135-49905-000-000 Gas Well Revenue Totals: .00 .00 ** (886.00) Budgeted (886.00) Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (444,137.56) ** (6,417,937.00) Budgeted (5,973,799.44) Remaining 7 % Used Trophy Club Municipal Utility District No. 1 64 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 18 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2013 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 25 10/11/2013 MUD Payroll 10/11/13 Salaries & Wages 6,663.12 6,663.12 PR 273 10/11/2013 Reverse 9/30 Accrued P/R (4,283.43) 2,379.69 GL 100 10/25/2013 10/25/13 MUD Payroll Salaries & Wages 9,538.14 11,917.83 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 11,917.83 11,917.83 ** 287,709.00 Budgeted 275,791.17 Remaining 4 % Used Account: 135-50010-010-000 Overtime 25 10/11/2013 MUD Payroll 10/11/13 Overtime 1,187.43 1,187.43 PR 273 10/11/2013 Reverse 9/30 Accrued P/R (660.49) 526.94 GL 100 10/25/2013 10/25/13 MUD Payroll Overtime 246.88 773.82 PR _______________ Account: 135-50010-010-000 Overtime Totals: 773.82 773.82 ** 13,391.00 Budgeted 12,617.18 Remaining 6 % Used Account: 135-50016-010-000 Longevity .00 .00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 .00 ** 4,905.00 Budgeted 4,905.00 Remaining 0 % Used Account: 135-50017-010-000 Certification 100 10/25/2013 10/25/13 MUD Payroll Certification 325.00 325.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 325.00 325.00 ** 5,100.00 Budgeted 4,775.00 Remaining 6 % Used Account: 135-50020-010-000 Retirement 25 10/11/2013 MUD Payroll 10/11/13 Retirement 704.99 704.99 PR 100 10/25/2013 10/25/13 MUD Payroll Retirement 907.87 1,612.86 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,612.86 1,612.86 ** 27,847.00 Budgeted 26,234.14 Remaining 6 % Used Account: 135-50026-010-000 Medical Insurance 25 10/11/2013 MUD Payroll 10/11/13 Medical Insurance 1,057.00 1,057.00 PR 100 10/25/2013 10/25/13 MUD Payroll Medical Insurance 1,321.20 2,378.20 PR Trophy Club Municipal Utility District No. 1 65 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 19 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2013 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-010-000 Medical Insurance Totals: 2,378.20 2,378.20 ** 48,334.00 Budgeted 45,955.80 Remaining 5 % Used Account: 135-50027-010-000 Dental Insurance 25 10/11/2013 MUD Payroll 10/11/13 Dental Insurance 95.40 95.40 PR 100 10/25/2013 10/25/13 MUD Payroll Dental Insurance 110.83 206.23 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 206.23 206.23 ** 3,932.00 Budgeted 3,725.77 Remaining 5 % Used Account: 135-50028-010-000 Vision Insurance 25 10/11/2013 MUD Payroll 10/11/13 Vision Insurance 20.70 20.70 PR 100 10/25/2013 10/25/13 MUD Payroll Vision Insurance 25.07 45.77 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 45.77 45.77 ** 873.00 Budgeted 827.23 Remaining 5 % Used Account: 135-50029-010-000 Life Insurance & Other 2 10/01/2013 Reverse Prepaids Metlife Life, ADD & Other 139.73 139.73 GL 247 10/31/2013 Oct A/P FSA Adm fee/Oct 15.75 155.48 Discovery Benefits 33148 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 155.48 155.48 ** 3,306.00 Budgeted 3,150.52 Remaining 5 % Used Account: 135-50030-010-000 Social Security Taxes 25 10/11/2013 MUD Payroll 10/11/13 Social Security Taxes 480.93 480.93 PR 100 10/25/2013 10/25/13 MUD Payroll Social Security Taxes 619.69 1,100.62 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,100.62 1,100.62 ** 19,289.00 Budgeted 18,188.38 Remaining 6 % Used Account: 135-50035-010-000 Medicare Taxes 25 10/11/2013 MUD Payroll 10/11/13 Medicare Taxes 112.47 112.47 PR 100 10/25/2013 10/25/13 MUD Payroll Medicare Taxes 144.92 257.39 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 257.39 257.39 ** 4,511.00 Budgeted 4,253.61 Remaining 6 % Used Trophy Club Municipal Utility District No. 1 66 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 20 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50040-010-000 Unemployment Taxes .00 .00 _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: .00 .00 ** 54.00 Budgeted 54.00 Remaining 0 % Used Account: 135-50045-010-000 Workman's Compensation 47 10/01/2013 Oct Ins & W/C Expense 802.45 802.45 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 802.45 802.45 ** 9,829.00 Budgeted 9,026.55 Remaining 8 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 247 10/31/2013 Oct A/P Pre-employment/Melancon 36.45 36.45 FIRST CHECK APPLICANT SCREENIN 33152 AP _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: 36.45 36.45 ** 200.00 Budgeted 163.55 Remaining 18 % Used Account: 135-50070-010-000 Employee Relations 226 10/26/2013 10/1-10/26 PCards DONUT HAVEN 8.99 8.99 DONUT HAVEN PC _______________ Account: 135-50070-010-000 Employee Relations Totals: 8.99 8.99 ** 300.00 Budgeted 291.01 Remaining 3 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 130 10/24/2013 October A/P angle stops 537.00 537.00 HD SUPPLY WATERWORKS, LTD. 33096 AP 130 10/24/2013 October A/P meter boxes 439.28 976.28 HD SUPPLY WATERWORKS, LTD. 33096 AP 130 10/24/2013 October A/P Fire line parts 1,575.94 2,552.22 HD SUPPLY WATERWORKS, LTD. 33096 AP 130 10/24/2013 October A/P comxmale for oak hill fire hyd 124.78 2,677.00 HD SUPPLY WATERWORKS, LTD. 33096 AP 130 10/24/2013 October A/P compressions and angle stops 276.00 2,953.00 HD SUPPLY WATERWORKS, LTD. 33096 AP 130 10/24/2013 October A/P meter spuds and gaskets 645.71 3,598.71 HD SUPPLY WATERWORKS, LTD. 33096 AP 226 10/26/2013 10/1-10/26 PCards THE HOME DEPOT 6581 29.34 3,628.05 THE HOME DEPOT 6581 PC Trophy Club Municipal Utility District No. 1 67 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 21 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 226 10/26/2013 10/1-10/26 PCards FERGUSON ENTERPRISES 1 450.00 4,078.05 FERGUSON ENTERPRISES 1 PC 226 10/26/2013 10/1-10/26 PCards THE HOME DEPOT 6581 52.86 4,130.91 THE HOME DEPOT 6581 PC 226 10/26/2013 10/1-10/26 PCards CRAFTMARK PRODUCTS INC 81.00 4,211.91 CRAFTMARK PRODUCTS INC PC 227 10/26/2013 10/26 PCards CRAFTMARK PRODUCTS INC 13.22 4,225.13 CRAFTMARK PRODUCTS INC PC 155 10/30/2013 Oct A/P Flush hydrant 775.00 5,000.13 HD SUPPLY WATERWORKS, LTD. 33128 AP 247 10/31/2013 Oct A/P 2" couplings and poly 234.66 5,234.79 HD SUPPLY WATERWORKS, LTD. 33157 AP 247 10/31/2013 Oct A/P Meter boxes 1,217.58 6,452.37 HD SUPPLY WATERWORKS, LTD. 33157 AP 247 10/31/2013 Oct A/P Pin for Fire Hydrant 22.08 6,474.45 HD SUPPLY WATERWORKS, LTD. 33157 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 6,474.45 6,474.45 ** 50,000.00 Budgeted 43,525.55 Remaining 13 % Used Account: 135-55090-010-000 Vehicle Maintenance 226 10/26/2013 10/1-10/26 PCards KWIK KAR OF ROANOKE 39.75 39.75 KWIK KAR OF ROANOKE PC 155 10/30/2013 Oct A/P Replace Heater core/F150 767.02 806.77 MICHAEL G. WATSON 33130 AP 247 10/31/2013 Oct A/P Parts for 2002 F150 77.38 884.15 ROANOKE AUTO SUPPLY 33168 AP _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 884.15 884.15 ** 5,000.00 Budgeted 4,115.85 Remaining 18 % 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 .00 .00 _______________ Account: 135-55135-010-000 Lab Analysis Totals: .00 .00 ** 5,500.00 Budgeted 5,500.00 Remaining 0 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles .00 .00 _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: .00 .00 ** 4,913.00 Budgeted 4,913.00 Remaining 0 % Used Account: 135-60020-010-000 Electricity Trophy Club Municipal Utility District No. 1 68 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 22 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 114 10/23/2013 Oct A/P Oct Electricity 10/1-10/11 3,823.16 3,823.16 HUDSON ENERGY SERVICES, LLC 33097 AP 114 10/23/2013 Oct A/P Oct Electricity 10/1-10/10 25.41 3,848.57 HUDSON ENERGY SERVICES, LLC 33097 AP 114 10/23/2013 Oct A/P Oct Electricity 10/1-10/11 1,868.85 5,717.42 HUDSON ENERGY SERVICES, LLC 33097 AP _______________ Account: 135-60020-010-000 Electricity Totals: 5,717.42 5,717.42 ** 162,160.00 Budgeted 156,442.58 Remaining 4 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60070-010-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60080-010-000 Schools & Training .00 .00 _______________ Account: 135-60080-010-000 Schools & Training Totals: .00 .00 ** 4,184.00 Budgeted 4,184.00 Remaining 0 % Used Account: 135-60090-010-000 Safety Program .00 .00 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60100-010-000 Travel & per diem .00 .00 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 .00 ** 1,450.00 Budgeted 1,450.00 Remaining 0 % Used Account: 135-60105-010-000 Rent/Lease Equipment Trophy Club Municipal Utility District No. 1 69 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 23 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 247 10/31/2013 Oct A/P Nitrogen bottle lease 6.00 6.00 ALLIED WELDING SUPPLY, INC 33139 AP _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: 6.00 6.00 ** 500.00 Budgeted 494.00 Remaining 1 % Used Account: 135-60135-010-000 TCEQ Fees & Permits .00 .00 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 .00 ** 47,400.00 Budgeted 47,400.00 Remaining 0 % Used Account: 135-60150-010-000 Wholesale Water .00 .00 _______________ Account: 135-60150-010-000 Wholesale Water Totals: .00 .00 ** 2,338,473.00 Budgeted 2,338,473.00 Remaining 0 % 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 226 10/26/2013 10/1-10/26 PCards DENTON SAND & GRAVEL, 108.00 108.00 DENTON SAND & GRAVEL, PC 226 10/26/2013 10/1-10/26 PCards DENTON SAND & GRAVEL, 84.00 192.00 DENTON SAND & GRAVEL, PC 226 10/26/2013 10/1-10/26 PCards DENTON SAND & GRAVEL, 42.00 234.00 DENTON SAND & GRAVEL, PC 226 10/26/2013 10/1-10/26 PCards TEX-TURF 46.60 280.60 TEX-TURF PC _______________ Account: 135-60280-010-000 Property Maintenance Totals: 280.60 280.60 ** 3,500.00 Budgeted 3,219.40 Remaining 8 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Trophy Club Municipal Utility District No. 1 70 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 24 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60360-010-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-65005-010-000 Fuel & Lube 236 10/31/2013 October Gas Log 1,156.44 1,156.44 GL _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 1,156.44 1,156.44 ** 23,181.00 Budgeted 22,024.56 Remaining 5 % Used Account: 135-65010-010-000 Uniforms 226 10/26/2013 10/1-10/26 PCards TRACTOR SUPPLY COMPANY 89.99 89.99 TRACTOR SUPPLY COMPANY PC _______________ Account: 135-65010-010-000 Uniforms Totals: 89.99 89.99 ** 3,270.00 Budgeted 3,180.01 Remaining 3 % Used Account: 135-65030-010-000 Chemicals 155 10/30/2013 Oct A/P Total Chlorine Dispensers 135.77 135.77 HACH COMPANY 33127 AP 247 10/31/2013 Oct A/P Chemicals 520.44 656.21 DPC INDUSTRIES, INC 33149 AP 247 10/31/2013 Oct A/P Chemicals 327.75 983.96 HACH COMPANY 33156 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 983.96 983.96 ** 5,000.00 Budgeted 4,016.04 Remaining 20 % Used Account: 135-65035-010-000 Small Tools 247 10/31/2013 Oct A/P Tools for on-call trucks 464.94 464.94 ATLAS UTILITY SUPPLY CO. 33140 AP _______________ Account: 135-65035-010-000 Small Tools Totals: 464.94 464.94 ** 1,200.00 Budgeted 735.06 Remaining 39 % 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 Trophy Club Municipal Utility District No. 1 71 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 25 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65050-010-000 Meter Expense 226 10/26/2013 10/1-10/26 PCards ATLAS UTILITY SUPPLY C 942.40 942.40 ATLAS UTILITY SUPPLY C PC 247 10/31/2013 Oct A/P Meters 3,910.00 4,852.40 ATLAS UTILITY SUPPLY CO. 33140 AP 247 10/31/2013 Oct A/P 150 1" meters with Orion heads 49,500.00 54,352.40 ATLAS UTILITY SUPPLY CO. 33140 AP 247 10/31/2013 Oct A/P 1" Meter spuds 387.90 54,740.30 HD SUPPLY WATERWORKS, LTD. 33157 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 54,740.30 54,740.30 ** 143,550.00 Budgeted 88,809.70 Remaining 38 % Used Account: 135-69005-010-000 Capital Expenses .00 .00 _______________ Account: 135-69005-010-000 Capital Expenses Totals: .00 .00 ** 37,000.00 Budgeted 37,000.00 Remaining 0 % Used Account: 135-69008-010-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 .00 ** 489,980.00 Budgeted 489,980.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 ** 19,268.00 Budgeted 19,268.00 Remaining 0 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement .00 .00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 .00 ** 30,000.00 Budgeted 30,000.00 Remaining 0 % Used Account: 135-69280-010-000 Capital Repairs .00 .00 _______________ Account: 135-69280-010-000 Capital Repairs Totals: .00 .00 ** 7,500.00 Budgeted 7,500.00 Remaining 0 % Used Trophy Club Municipal Utility District No. 1 72 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 26 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69281-010-000 Capital Repair-Ground Storage .00 .00 _______________ Account: 135-69281-010-000 Capital Repair-Ground Storage Totals: .00 .00 ** 106,847.00 Budgeted 106,847.00 Remaining 0 % Used Account: 135-55135-010-001 Lab Analysis .00 .00 _______________ Account: 135-55135-010-001 Lab Analysis Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 90,419.34 ** 3,932,956.00 Budgeted 3,842,536.66 Remaining 2 % Used Trophy Club Municipal Utility District No. 1 73 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 27 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2013 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 25 10/11/2013 MUD Payroll 10/11/13 Salaries & Wages 7,360.84 7,360.84 PR 273 10/11/2013 Reverse 9/30 Accrued P/R (4,735.59) 2,625.25 GL 100 10/25/2013 10/25/13 MUD Payroll Salaries & Wages 7,587.46 10,212.71 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 10,212.71 10,212.71 ** 202,894.00 Budgeted 192,681.29 Remaining 5 % Used Account: 135-50010-020-000 Overtime 25 10/11/2013 MUD Payroll 10/11/13 Overtime 906.55 906.55 PR 273 10/11/2013 Reverse 9/30 Accrued P/R (479.93) 426.62 GL 100 10/25/2013 10/25/13 MUD Payroll Overtime 356.52 783.14 PR _______________ Account: 135-50010-020-000 Overtime Totals: 783.14 783.14 ** 11,965.00 Budgeted 11,181.86 Remaining 7 % Used Account: 135-50016-020-000 Longevity .00 .00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 .00 ** 2,998.00 Budgeted 2,998.00 Remaining 0 % Used Account: 135-50017-020-000 Certification 100 10/25/2013 10/25/13 MUD Payroll Certification 400.00 400.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 400.00 400.00 ** 4,800.00 Budgeted 4,400.00 Remaining 8 % Used Account: 135-50020-020-000 Retirement 25 10/11/2013 MUD Payroll 10/11/13 Retirement 742.41 742.41 PR 100 10/25/2013 10/25/13 MUD Payroll Retirement 749.29 1,491.70 PR _______________ Account: 135-50020-020-000 Retirement Totals: 1,491.70 1,491.70 ** 19,905.00 Budgeted 18,413.30 Remaining 7 % Used Account: 135-50026-020-000 Medical Insurance 25 10/11/2013 MUD Payroll 10/11/13 Medical Insurance 1,646.62 1,646.62 PR 100 10/25/2013 10/25/13 MUD Payroll Medical Insurance 1,646.61 3,293.23 PR Trophy Club Municipal Utility District No. 1 74 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 28 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2013 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: 3,293.23 3,293.23 ** 43,471.00 Budgeted 40,177.77 Remaining 8 % Used Account: 135-50027-020-000 Dental Insurance 25 10/11/2013 MUD Payroll 10/11/13 Dental Insurance 113.24 113.24 PR 100 10/25/2013 10/25/13 MUD Payroll Dental Insurance 113.22 226.46 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 226.46 226.46 ** 2,989.00 Budgeted 2,762.54 Remaining 8 % Used Account: 135-50028-020-000 Vision Insurance 25 10/11/2013 MUD Payroll 10/11/13 Vision Insurance 24.98 24.98 PR 100 10/25/2013 10/25/13 MUD Payroll Vision Insurance 24.95 49.93 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 49.93 49.93 ** 658.00 Budgeted 608.07 Remaining 8 % Used Account: 135-50029-020-000 Life Insurance & Other 2 10/01/2013 Reverse Prepaids Metlife Life, ADD & Other 152.40 152.40 GL 247 10/31/2013 Oct A/P FSA Adm fee/Oct 15.75 168.15 Discovery Benefits 33148 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 168.15 168.15 ** 2,303.00 Budgeted 2,134.85 Remaining 7 % Used Account: 135-50030-020-000 Social Security Taxes 25 10/11/2013 MUD Payroll 10/11/13 Social Security Taxes 446.65 446.65 PR 100 10/25/2013 10/25/13 MUD Payroll Social Security Taxes 447.69 894.34 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 894.34 894.34 ** 13,805.00 Budgeted 12,910.66 Remaining 6 % Used Account: 135-50035-020-000 Medicare Taxes 25 10/11/2013 MUD Payroll 10/11/13 Medicare Taxes 104.46 104.46 PR 100 10/25/2013 10/25/13 MUD Payroll Medicare Taxes 104.69 209.15 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 209.15 209.15 ** 3,229.00 Budgeted 3,019.85 Remaining 6 % Used Trophy Club Municipal Utility District No. 1 75 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 29 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2013 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 .00 .00 _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 .00 ** 36.00 Budgeted 36.00 Remaining 0 % Used Account: 135-50045-020-000 Workman's Compensation 47 10/01/2013 Oct Ins & W/C Expense 535.08 535.08 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 535.08 535.08 ** 6,552.00 Budgeted 6,016.92 Remaining 8 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-50070-020-000 Employee Relations 226 10/26/2013 10/1-10/26 PCards DONUT HAVEN 8.99 8.99 DONUT HAVEN PC _______________ Account: 135-50070-020-000 Employee Relations Totals: 8.99 8.99 ** 350.00 Budgeted 341.01 Remaining 3 % Used Account: 135-55080-020-000 Maintenance & Repairs 226 10/26/2013 10/1-10/26 PCards THE HOME DEPOT 6581 325.99 325.99 THE HOME DEPOT 6581 PC 227 10/26/2013 10/26 PCards THE HOME DEPOT 6581 37.03 363.02 THE HOME DEPOT 6581 PC _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 363.02 363.02 ** 35,000.00 Budgeted 34,636.98 Remaining 1 % Used Account: 135-55090-020-000 Vehicle Maintenance 226 10/26/2013 10/1-10/26 PCards MUSTANG ELITE CAR WASH 70.99 70.99 MUSTANG ELITE CAR WASH PC 226 10/26/2013 10/1-10/26 PCards MUSTANG ELITE CAR WASH 70.99 141.98 MUSTANG ELITE CAR WASH PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 141.98 141.98 ** 2,000.00 Budgeted 1,858.02 Remaining 7 % Used Trophy Club Municipal Utility District No. 1 76 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 30 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader .00 .00 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-55125-020-000 Dumpster Services .00 .00 _______________ Account: 135-55125-020-000 Dumpster Services Totals: .00 .00 ** 52,000.00 Budgeted 52,000.00 Remaining 0 % Used Account: 135-55135-020-000 Lab Analysis 130 10/24/2013 October A/P testing 278.00 278.00 OXIDOR LABORATORIES LLC 33106 AP 130 10/24/2013 October A/P Testing 124.00 402.00 OXIDOR LABORATORIES LLC 33106 AP 130 10/24/2013 October A/P Testing 124.00 526.00 OXIDOR LABORATORIES LLC 33106 AP 130 10/24/2013 October A/P Testing 124.00 650.00 OXIDOR LABORATORIES LLC 33106 AP 130 10/24/2013 October A/P Testing 124.00 774.00 OXIDOR LABORATORIES LLC 33106 AP 131 10/24/2013 Oct A/P Testing 278.00 1,052.00 OXIDOR LABORATORIES LLC 33106 AP 131 10/24/2013 Oct A/P Testing 211.00 1,263.00 OXIDOR LABORATORIES LLC 33106 AP 131 10/24/2013 Oct A/P Testing 124.00 1,387.00 OXIDOR LABORATORIES LLC 33106 AP 131 10/24/2013 Oct A/P Testing 211.00 1,598.00 OXIDOR LABORATORIES LLC 33106 AP 131 10/24/2013 Oct A/P Testing 288.00 1,886.00 OXIDOR LABORATORIES LLC 33106 AP 131 10/24/2013 Oct A/P Testing 211.00 2,097.00 OXIDOR LABORATORIES LLC 33106 AP 247 10/31/2013 Oct A/P Testing 243.00 2,340.00 OXIDOR LABORATORIES LLC 33167 AP 247 10/31/2013 Oct A/P Testing 176.00 2,516.00 OXIDOR LABORATORIES LLC 33167 AP 247 10/31/2013 Oct A/P Testing 246.00 2,762.00 OXIDOR LABORATORIES LLC 33167 AP 247 10/31/2013 Oct A/P Testing 176.00 2,938.00 OXIDOR LABORATORIES LLC 33167 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 2,938.00 2,938.00 ** 30,000.00 Budgeted 27,062.00 Remaining 10 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles .00 .00 _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: .00 .00 ** 3,329.00 Budgeted 3,329.00 Remaining 0 % Used Account: 135-60020-020-000 Electricity Trophy Club Municipal Utility District No. 1 77 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 31 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 114 10/23/2013 Oct A/P Oct Electricity 10/1-10/11 3,256.32 3,256.32 HUDSON ENERGY SERVICES, LLC 33097 AP _______________ Account: 135-60020-020-000 Electricity Totals: 3,256.32 3,256.32 ** 148,227.00 Budgeted 144,970.68 Remaining 2 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 114 10/23/2013 Oct A/P Text Book/Utilities Safety Cla 40.00 40.00 CITY OF FORT WORTH 33091 AP _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: 40.00 40.00 ** 400.00 Budgeted 360.00 Remaining 10 % Used Account: 135-60080-020-000 Schools & Training .00 .00 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 .00 ** 2,636.00 Budgeted 2,636.00 Remaining 0 % Used Account: 135-60090-020-000 Safety Program 130 10/24/2013 October A/P safety supplies for cabinet 38.55 38.55 CINTAS FAS LOCKBOX 636525 33089 AP _______________ Account: 135-60090-020-000 Safety Program Totals: 38.55 38.55 ** 250.00 Budgeted 211.45 Remaining 15 % Used Account: 135-60100-020-000 Travel & per diem .00 .00 _______________ Account: 135-60100-020-000 Travel & per diem Totals: .00 .00 ** 1,050.00 Budgeted 1,050.00 Remaining 0 % Used Account: 135-60105-020-000 Rent/Lease Equipment 226 10/26/2013 10/1-10/26 PCards FOX RENTAL 299.53 299.53 FOX RENTAL PC _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: 299.53 299.53 ** 1,500.00 Budgeted 1,200.47 Remaining 20 % Used Account: 135-60135-020-000 TCEQ Fees & Permits .00 .00 Trophy Club Municipal Utility District No. 1 78 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 32 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2013 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-020-000 TCEQ Fees & Permits Totals: .00 .00 ** 17,150.00 Budgeted 17,150.00 Remaining 0 % Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 500.00 Budgeted 500.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 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 135-65005-020-000 Fuel & Lube 236 10/31/2013 October Gas Log 972.51 972.51 GL _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 972.51 972.51 ** 14,720.00 Budgeted 13,747.49 Remaining 7 % Used Account: 135-65010-020-000 Uniforms 226 10/26/2013 10/1-10/26 PCards ACADEMY SPORTS #81 228.90 228.90 ACADEMY SPORTS #81 PC 226 10/26/2013 10/1-10/26 PCards RED WING SHOES #652 199.74 428.64 RED WING SHOES #652 PC 226 10/26/2013 10/1-10/26 PCards RED WING SHOES #652 182.74 611.38 RED WING SHOES #652 PC 226 10/26/2013 10/1-10/26 PCards ACADEMY SPORTS #141 204.90 816.28 ACADEMY SPORTS #141 PC 226 10/26/2013 10/1-10/26 PCards ACADEMY SPORTS #141 (221.80) 594.48 ACADEMY SPORTS #141 PC 226 10/26/2013 10/1-10/26 PCards ACADEMY SPORTS #141 221.80 816.28 ACADEMY SPORTS #141 PC 226 10/26/2013 10/1-10/26 PCards RED WING SHOES #652 157.24 973.52 RED WING SHOES #652 PC 226 10/26/2013 10/1-10/26 PCards RED WING SHOES #652 157.24 1,130.76 RED WING SHOES #652 PC 226 10/26/2013 10/1-10/26 PCards PANDA EMBROIDERY 186.00 1,316.76 PANDA EMBROIDERY PC Trophy Club Municipal Utility District No. 1 79 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 33 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 222 10/30/2013 Richey, Valadez Boot reimb (32.48) 1,284.28 GL _______________ Account: 135-65010-020-000 Uniforms Totals: 1,284.28 1,284.28 ** 1,752.00 Budgeted 467.72 Remaining 73 % Used Account: 135-65030-020-000 Chemicals 131 10/24/2013 Oct A/P Chemicals 2,263.62 2,263.62 HARCROS CHEMICALS INC 33094 AP 226 10/26/2013 10/1-10/26 PCards AQUAFIX INC 686.02 2,949.64 AQUAFIX INC PC _______________ Account: 135-65030-020-000 Chemicals Totals: 2,949.64 2,949.64 ** 39,000.00 Budgeted 36,050.36 Remaining 8 % Used Account: 135-65035-020-000 Small Tools 226 10/26/2013 10/1-10/26 PCards THE HOME DEPOT 6581 47.34 47.34 THE HOME DEPOT 6581 PC _______________ Account: 135-65035-020-000 Small Tools Totals: 47.34 47.34 ** 1,000.00 Budgeted 952.66 Remaining 5 % Used Account: 135-65040-020-000 Safety Equipment 247 10/31/2013 Oct A/P Stock medicine cabinet 56.43 56.43 CINTAS CORPORATION NO. 2 33144 AP _______________ Account: 135-65040-020-000 Safety Equipment Totals: 56.43 56.43 ** 250.00 Budgeted 193.57 Remaining 23 % Used Account: 135-65045-020-000 Lab Supplies 131 10/24/2013 Oct A/P PH Buffer 39.54 39.54 HD SUPPLY FACILITIES MAINT LTD 33095 AP 131 10/24/2013 Oct A/P Circular Flow Charts 51.63 91.17 HD SUPPLY FACILITIES MAINT LTD 33095 AP 226 10/26/2013 10/1-10/26 PCards HACH COMPANY 1,152.83 1,244.00 HACH COMPANY PC 226 10/26/2013 10/1-10/26 PCards IDEXX DISTRIBUTION INC 3,027.46 4,271.46 IDEXX DISTRIBUTION INC PC 226 10/26/2013 10/1-10/26 PCards THE HOME DEPOT 6581 12.97 4,284.43 THE HOME DEPOT 6581 PC _______________ Account: 135-65045-020-000 Lab Supplies Totals: 4,284.43 4,284.43 ** 15,000.00 Budgeted 10,715.57 Remaining 29 % Used Account: 135-69005-020-000 Capital Expenses .00 .00 _______________ Account: 135-69005-020-000 Capital Expenses Totals: .00 .00 ** 31,000.00 Budgeted 31,000.00 Remaining 0 % Used Trophy Club Municipal Utility District No. 1 80 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 34 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69008-020-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-020-000 Short Term Debt-Principal Totals: .00 .00 ** 20,020.00 Budgeted 20,020.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 ** 1,422.00 Budgeted 1,422.00 Remaining 0 % Used Account: 135-69280-020-000 Capital Repairs .00 .00 _______________ Account: 135-69280-020-000 Capital Repairs Totals: .00 .00 ** 30,000.00 Budgeted 30,000.00 Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 34,944.91 ** 768,011.00 Budgeted 733,066.09 Remaining 5 % Used Trophy Club Municipal Utility District No. 1 81 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 35 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 10/2013 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-021-000 Salaries & Wages 25 10/11/2013 MUD Payroll 10/11/13 Salaries & Wages 5,891.37 5,891.37 PR 273 10/11/2013 Reverse 9/30 Accrued P/R (3,787.31) 2,104.06 GL 100 10/25/2013 10/25/13 MUD Payroll Salaries & Wages 3,354.58 5,458.64 PR _______________ Account: 135-50005-021-000 Salaries & Wages Totals: 5,458.64 5,458.64 ** 90,299.00 Budgeted 84,840.36 Remaining 6 % Used Account: 135-50010-021-000 Overtime 25 10/11/2013 MUD Payroll 10/11/13 Overtime 258.03 258.03 PR 273 10/11/2013 Reverse 9/30 Accrued P/R (165.88) 92.15 GL 100 10/25/2013 10/25/13 MUD Payroll Overtime 644.17 736.32 PR _______________ Account: 135-50010-021-000 Overtime Totals: 736.32 736.32 ** 10,028.00 Budgeted 9,291.68 Remaining 7 % Used Account: 135-50016-021-000 Longevity .00 .00 _______________ Account: 135-50016-021-000 Longevity Totals: .00 .00 ** 17,913.00 Budgeted 17,913.00 Remaining 0 % Used Account: 135-50017-021-000 Certification 100 10/25/2013 10/25/13 MUD Payroll Certification 150.00 150.00 PR _______________ Account: 135-50017-021-000 Certification Totals: 150.00 150.00 ** 1,800.00 Budgeted 1,650.00 Remaining 8 % Used Account: 135-50020-021-000 Retirement 25 10/11/2013 MUD Payroll 10/11/13 Retirement 552.22 552.22 PR 100 10/25/2013 10/25/13 MUD Payroll Retirement 372.55 924.77 PR _______________ Account: 135-50020-021-000 Retirement Totals: 924.77 924.77 ** 9,025.00 Budgeted 8,100.23 Remaining 10 % Used Account: 135-50026-021-000 Medical Insurance 25 10/11/2013 MUD Payroll 10/11/13 Medical Insurance 1,160.78 1,160.78 PR 100 10/25/2013 10/25/13 MUD Payroll Medical Insurance 896.53 2,057.31 PR Trophy Club Municipal Utility District No. 1 82 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 36 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 10/2013 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-021-000 Medical Insurance Totals: 2,057.31 2,057.31 ** 23,668.00 Budgeted 21,610.69 Remaining 9 % Used Account: 135-50027-021-000 Dental Insurance 25 10/11/2013 MUD Payroll 10/11/13 Dental Insurance 79.95 79.95 PR 100 10/25/2013 10/25/13 MUD Payroll Dental Insurance 64.48 144.43 PR _______________ Account: 135-50027-021-000 Dental Insurance Totals: 144.43 144.43 ** 1,703.00 Budgeted 1,558.57 Remaining 8 % Used Account: 135-50028-021-000 Vision Insurance 25 10/11/2013 MUD Payroll 10/11/13 Vision Insurance 16.31 16.31 PR 100 10/25/2013 10/25/13 MUD Payroll Vision Insurance 11.90 28.21 PR _______________ Account: 135-50028-021-000 Vision Insurance Totals: 28.21 28.21 ** 314.00 Budgeted 285.79 Remaining 9 % Used Account: 135-50029-021-000 Life Insurance & Other 2 10/01/2013 Reverse Prepaids Metlife Life, ADD & Other 117.97 117.97 GL 247 10/31/2013 Oct A/P FSA Adm fee/Oct 5.25 123.22 Discovery Benefits 33148 AP _______________ Account: 135-50029-021-000 Life Insurance & Other Totals: 123.22 123.22 ** 1,066.00 Budgeted 942.78 Remaining 12 % Used Account: 135-50030-021-000 Social Security Taxes 25 10/11/2013 MUD Payroll 10/11/13 Social Security Taxes 348.65 348.65 PR 100 10/25/2013 10/25/13 MUD Payroll Social Security Taxes 222.50 571.15 PR _______________ Account: 135-50030-021-000 Social Security Taxes Totals: 571.15 571.15 ** 7,442.00 Budgeted 6,870.85 Remaining 8 % Used Account: 135-50035-021-000 Medicare Taxes 25 10/11/2013 MUD Payroll 10/11/13 Medicare Taxes 81.53 81.53 PR 100 10/25/2013 10/25/13 MUD Payroll Medicare Taxes 52.04 133.57 PR _______________ Account: 135-50035-021-000 Medicare Taxes Totals: 133.57 133.57 ** 1,741.00 Budgeted 1,607.43 Remaining 8 % Used Trophy Club Municipal Utility District No. 1 83 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 37 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 10/2013 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-021-000 Unemployment Taxes .00 .00 _______________ Account: 135-50040-021-000 Unemployment Taxes Totals: .00 .00 ** 198.00 Budgeted 198.00 Remaining 0 % Used Account: 135-50045-021-000 Workman's Compensation 47 10/01/2013 Oct Ins & W/C Expense 267.54 267.54 GL _______________ Account: 135-50045-021-000 Workman's Compensation Totals: 267.54 267.54 ** 3,276.00 Budgeted 3,008.46 Remaining 8 % Used Account: 135-50070-021-000 Employee Relations 226 10/26/2013 10/1-10/26 PCards DONUT HAVEN 8.99 8.99 DONUT HAVEN PC _______________ Account: 135-50070-021-000 Employee Relations Totals: 8.99 8.99 ** 200.00 Budgeted 191.01 Remaining 4 % Used Account: 135-55005-021-000 Engineering .00 .00 _______________ Account: 135-55005-021-000 Engineering Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-55080-021-000 Maintenance & Repairs 226 10/26/2013 10/1-10/26 PCards THE HOME DEPOT 6581 (33.97) (33.97) THE HOME DEPOT 6581 PC 226 10/26/2013 10/1-10/26 PCards THE HOME DEPOT 6581 27.97 (6.00) THE HOME DEPOT 6581 PC 226 10/26/2013 10/1-10/26 PCards THE HOME DEPOT 6581 33.97 27.97 THE HOME DEPOT 6581 PC _______________ Account: 135-55080-021-000 Maintenance & Repairs Totals: 27.97 27.97 ** 23,801.00 Budgeted 23,773.03 Remaining 0 % Used Account: 135-55090-021-000 Vehicle Maintenance .00 .00 _______________ Account: 135-55090-021-000 Vehicle Maintenance Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Trophy Club Municipal Utility District No. 1 84 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 38 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60010-021-000 Communications/Pagers/Mobiles .00 .00 _______________ Account: 135-60010-021-000 Communications/Pagers/Mobiles Totals: .00 .00 ** 1,333.00 Budgeted 1,333.00 Remaining 0 % Used Account: 135-60020-021-000 Electricity 114 10/23/2013 Oct A/P Oct Electricity 10/1-10/11 228.79 228.79 HUDSON ENERGY SERVICES, LLC 33097 AP 114 10/23/2013 Oct A/P Oct Electricity 10/1-10/11 92.57 321.36 HUDSON ENERGY SERVICES, LLC 33097 AP 114 10/23/2013 Oct A/P Oct Electricity 10/1-10/10 18.75 340.11 HUDSON ENERGY SERVICES, LLC 33097 AP 114 10/23/2013 Oct A/P Oct Electricity 10/1-10/11 10.13 350.24 HUDSON ENERGY SERVICES, LLC 33097 AP 187 10/31/2013 Oct A/P Electricity 10/1/13 9.22 359.46 TRI COUNTY ELECTRIC 33137 AP 187 10/31/2013 Oct A/P Electricity 10/1/13 5.60 365.06 TRI COUNTY ELECTRIC 33137 AP 187 10/31/2013 Oct A/P Electricity 10/1/13 .88 365.94 TRI COUNTY ELECTRIC 33137 AP _______________ Account: 135-60020-021-000 Electricity Totals: 365.94 365.94 ** 21,178.00 Budgeted 20,812.06 Remaining 2 % Used Account: 135-60070-021-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-021-000 Dues & Memberships Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60080-021-000 Schools & Training .00 .00 _______________ Account: 135-60080-021-000 Schools & Training Totals: .00 .00 ** 1,711.00 Budgeted 1,711.00 Remaining 0 % Used Account: 135-60090-021-000 Safety Program .00 .00 _______________ Account: 135-60090-021-000 Safety Program Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-60100-021-000 Travel & per diem .00 .00 Trophy Club Municipal Utility District No. 1 85 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 39 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60100-021-000 Travel & per diem Totals: .00 .00 ** 550.00 Budgeted 550.00 Remaining 0 % Used Account: 135-60105-021-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-021-000 Rent/Lease Equipment Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-60245-021-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-021-000 Miscellaneous Expenses Totals: .00 .00 ** 100.00 Budgeted 100.00 Remaining 0 % Used Account: 135-65005-021-000 Fuel & Lube 236 10/31/2013 October Gas Log 1,030.84 1,030.84 GL _______________ Account: 135-65005-021-000 Fuel & Lube Totals: 1,030.84 1,030.84 ** 22,397.00 Budgeted 21,366.16 Remaining 5 % Used Account: 135-65010-021-000 Uniforms 226 10/26/2013 10/1-10/26 PCards RED WING SHOES #652 157.24 157.24 RED WING SHOES #652 PC 226 10/26/2013 10/1-10/26 PCards RED WING SHOES #652 175.00 332.24 RED WING SHOES #652 PC 226 10/26/2013 10/1-10/26 PCards ACADEMY SPORTS #81 243.90 576.14 ACADEMY SPORTS #81 PC _______________ Account: 135-65010-021-000 Uniforms Totals: 576.14 576.14 ** 1,040.00 Budgeted 463.86 Remaining 55 % Used Account: 135-65030-021-000 Chemicals .00 .00 _______________ Account: 135-65030-021-000 Chemicals Totals: .00 .00 ** 6,000.00 Budgeted 6,000.00 Remaining 0 % Used Account: 135-65035-021-000 Small Tools Trophy Club Municipal Utility District No. 1 86 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 40 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 226 10/26/2013 10/1-10/26 PCards THE HOME DEPOT 6581 43.99 43.99 THE HOME DEPOT 6581 PC _______________ Account: 135-65035-021-000 Small Tools Totals: 43.99 43.99 ** 1,000.00 Budgeted 956.01 Remaining 4 % Used Account: 135-65040-021-000 Safety Equipment 226 10/26/2013 10/1-10/26 PCards WW GRAINGER 540.75 540.75 WW GRAINGER PC _______________ Account: 135-65040-021-000 Safety Equipment Totals: 540.75 540.75 ** 500.00 Budgeted (40.75) Remaining 108 % Used Account: 135-69005-021-000 Capital Expenses .00 .00 _______________ Account: 135-69005-021-000 Capital Expenses Totals: .00 .00 ** 100,000.00 Budgeted 100,000.00 Remaining 0 % Used Account: 135-69008-021-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-021-000 Short Term Debt-Principal Totals: .00 .00 ** 35,991.00 Budgeted 35,991.00 Remaining 0 % Used Account: 135-69009-021-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-021-000 Short Term Debt-Interest Totals: .00 .00 ** 2,846.00 Budgeted 2,846.00 Remaining 0 % Used Account: 135-69280-021-000 Capital Repairs .00 .00 _______________ Account: 135-69280-021-000 Capital Repairs Totals: .00 .00 ** 71,000.00 Budgeted 71,000.00 Remaining 0 % Used Department 21 Totals: ------------------------------------------------------------------------------------------------ 13,189.78 ** 472,170.00 Budgeted 458,980.22 Remaining 3 % Used Trophy Club Municipal Utility District No. 1 87 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 41 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 10/2013 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-026-000 Salaries & Wages 25 10/11/2013 MUD Payroll 10/11/13 Salaries & Wages 500.00 500.00 PR 100 10/25/2013 10/25/13 MUD Payroll Salaries & Wages 500.00 1,000.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 1,000.00 1,000.00 ** 10,000.00 Budgeted 9,000.00 Remaining 10 % Used Account: 135-50030-026-000 Social Security Taxes 25 10/11/2013 MUD Payroll 10/11/13 Social Security Taxes 31.00 31.00 PR 100 10/25/2013 10/25/13 MUD Payroll Social Security Taxes 31.00 62.00 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 62.00 62.00 ** 620.00 Budgeted 558.00 Remaining 10 % Used Account: 135-50035-026-000 Medicare Taxes 25 10/11/2013 MUD Payroll 10/11/13 Medicare Taxes 7.25 7.25 PR 100 10/25/2013 10/25/13 MUD Payroll Medicare Taxes 7.25 14.50 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 14.50 14.50 ** 145.00 Budgeted 130.50 Remaining 10 % Used Account: 135-50040-026-000 Unemployment Taxes 25 10/11/2013 MUD Payroll 10/11/13 Unemployment Taxes .50 .50 PR 100 10/25/2013 10/25/13 MUD Payroll Unemployment Taxes .50 1.00 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 1.00 1.00 ** 10.00 Budgeted 9.00 Remaining 10 % Used Account: 135-50045-026-000 Workman's Compensation 47 10/01/2013 Oct Ins & W/C Expense 2.95 2.95 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.95 2.95 ** 36.00 Budgeted 33.05 Remaining 8 % 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 Trophy Club Municipal Utility District No. 1 88 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 42 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60070-026-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60075-026-000 Meetings 226 10/26/2013 10/1-10/26 PCards RANDALLS STORE00017897 5.00 5.00 RANDALLS STORE00017897 PC _______________ Account: 135-60075-026-000 Meetings Totals: 5.00 5.00 ** 1,200.00 Budgeted 1,195.00 Remaining 0 % Used Account: 135-60080-026-000 Schools & Training .00 .00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 .00 ** 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Account: 135-60100-026-000 Travel & per diem .00 .00 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60245-026-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 1,085.45 ** 22,661.00 Budgeted 21,575.55 Remaining 5 % Used Trophy Club Municipal Utility District No. 1 89 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 43 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2013 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 25 10/11/2013 MUD Payroll 10/11/13 Salaries & Wages 16,573.51 16,573.51 PR 273 10/11/2013 Reverse 9/30 Accrued P/R (10,657.37) 5,916.14 GL 100 10/25/2013 10/25/13 MUD Payroll Salaries & Wages 17,300.01 23,216.15 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 23,216.15 23,216.15 ** 458,721.00 Budgeted 435,504.85 Remaining 5 % Used Account: 135-50010-030-000 Overtime 25 10/11/2013 MUD Payroll 10/11/13 Overtime 271.76 271.76 PR 273 10/11/2013 Reverse 9/30 Accrued P/R (174.70) 97.06 GL 100 10/25/2013 10/25/13 MUD Payroll Overtime 114.01 211.07 PR _______________ Account: 135-50010-030-000 Overtime Totals: 211.07 211.07 ** 500.00 Budgeted 288.93 Remaining 42 % Used Account: 135-50016-030-000 Longevity .00 .00 _______________ Account: 135-50016-030-000 Longevity Totals: .00 .00 ** 3,018.00 Budgeted 3,018.00 Remaining 0 % Used Account: 135-50020-030-000 Retirement 25 10/11/2013 MUD Payroll 10/11/13 Retirement 1,512.69 1,512.69 PR 100 10/25/2013 10/25/13 MUD Payroll Retirement 1,563.81 3,076.50 PR _______________ Account: 135-50020-030-000 Retirement Totals: 3,076.50 3,076.50 ** 41,419.00 Budgeted 38,342.50 Remaining 7 % Used Account: 135-50026-030-000 Medical Insurance 25 10/11/2013 MUD Payroll 10/11/13 Medical Insurance 2,194.07 2,194.07 PR 100 10/25/2013 10/25/13 MUD Payroll Medical Insurance 2,194.03 4,388.10 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,388.10 4,388.10 ** 57,923.00 Budgeted 53,534.90 Remaining 8 % Used Account: 135-50027-030-000 Dental Insurance 25 10/11/2013 MUD Payroll 10/11/13 Dental Insurance 193.19 193.19 PR Trophy Club Municipal Utility District No. 1 90 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 44 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 100 10/25/2013 10/25/13 MUD Payroll Dental Insurance 193.15 386.34 PR _______________ Account: 135-50027-030-000 Dental Insurance Totals: 386.34 386.34 ** 5,100.00 Budgeted 4,713.66 Remaining 8 % Used Account: 135-50028-030-000 Vision Insurance 25 10/11/2013 MUD Payroll 10/11/13 Vision Insurance 41.29 41.29 PR 100 10/25/2013 10/25/13 MUD Payroll Vision Insurance 41.24 82.53 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 82.53 82.53 ** 1,087.00 Budgeted 1,004.47 Remaining 8 % Used Account: 135-50029-030-000 Life Insurance & Other 2 10/01/2013 Reverse Prepaids Metlife Life, ADD & Other 300.02 300.02 GL 247 10/31/2013 Oct A/P FSA Adm fee/Oct 36.75 336.77 Discovery Benefits 33148 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 336.77 336.77 ** 4,483.00 Budgeted 4,146.23 Remaining 8 % Used Account: 135-50030-030-000 Social Security Taxes 25 10/11/2013 MUD Payroll 10/11/13 Social Security Taxes 974.36 974.36 PR 100 10/25/2013 10/25/13 MUD Payroll Social Security Taxes 1,005.07 1,979.43 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 1,979.43 1,979.43 ** 28,659.00 Budgeted 26,679.57 Remaining 7 % Used Account: 135-50035-030-000 Medicare Taxes 25 10/11/2013 MUD Payroll 10/11/13 Medicare Taxes 227.87 227.87 PR 100 10/25/2013 10/25/13 MUD Payroll Medicare Taxes 235.08 462.95 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 462.95 462.95 ** 6,702.00 Budgeted 6,239.05 Remaining 7 % Used Account: 135-50040-030-000 Unemployment Taxes .00 .00 _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: .00 .00 ** 63.00 Budgeted 63.00 Remaining 0 % Used Trophy Club Municipal Utility District No. 1 91 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 45 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2013 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 47 10/01/2013 Oct Ins & W/C Expense 128.63 128.63 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 128.63 128.63 ** 1,575.00 Budgeted 1,446.37 Remaining 8 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-50070-030-000 Employee Relations 221 10/21/2013 Flu Shots (45.00) (45.00) GL 226 10/26/2013 10/1-10/26 PCards MUGS CAFE - BAKERY 42.85 (2.15) MUGS CAFE - BAKERY PC 226 10/26/2013 10/1-10/26 PCards RECEPT PHARMACY 01 705.00 702.85 RECEPT PHARMACY 01 PC _______________ Account: 135-50070-030-000 Employee Relations Totals: 702.85 702.85 ** 5,000.00 Budgeted 4,297.15 Remaining 14 % Used Account: 135-55030-030-000 Software & Support 130 10/24/2013 October A/P Fire W/C, Charter, NCT COG Eme 645.50 645.50 TOWN OF TROPHY CLUB 33114 AP 130 10/24/2013 October A/P Annual Maintenance-camera van 1,980.00 2,625.50 PIPELOGIX, INC 33107 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 2,625.50 2,625.50 ** 59,698.00 Budgeted 57,072.50 Remaining 4 % Used Account: 135-55070-030-000 Independent Labor 114 10/23/2013 Oct A/P Rate Study 10/1-10/15 1,667.95 1,667.95 NEW GEN STRATEGIES & SOLUTIONS 33105 AP 130 10/24/2013 October A/P Record CAC meeting 37.50 1,705.45 MIGUEL CRUZ 33103 AP 130 10/24/2013 October A/P Record CAC meeting 45.00 1,750.45 JOHN CHARLES HALL 33098 AP 158 10/30/2013 Oct A/P Record CAC meeting 30.00 1,780.45 MIGUEL CRUZ 33132 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 1,780.45 1,780.45 ** 7,700.00 Budgeted 5,919.55 Remaining 23 % Used Account: 135-55080-030-000 Maintenance & Repairs .00 .00 Trophy Club Municipal Utility District No. 1 92 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 46 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2013 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 Totals: .00 .00 ** 4,500.00 Budgeted 4,500.00 Remaining 0 % Used Account: 135-55100-030-000 Building Maint & Supplies 226 10/26/2013 10/1-10/26 PCards THE HOME DEPOT 6581 31.98 31.98 THE HOME DEPOT 6581 PC 227 10/26/2013 10/26 PCards THE HOME DEPOT 6581 85.41 117.39 THE HOME DEPOT 6581 PC 155 10/30/2013 Oct A/P Re-key Terri's door 211.29 328.68 MICHAEL'S KEYS 33131 AP 261 10/31/2013 Town billed Inv 1102 AR 20131031-20131031 User: (188.84) 139.84 AR _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 139.84 139.84 ** 6,500.00 Budgeted 6,360.16 Remaining 2 % Used Account: 135-55120-030-000 Cleaning Services .00 .00 _______________ Account: 135-55120-030-000 Cleaning Services Totals: .00 .00 ** 19,140.00 Budgeted 19,140.00 Remaining 0 % Used Account: 135-55160-030-000 Professional Outside Services .00 .00 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 .00 ** 15,000.00 Budgeted 15,000.00 Remaining 0 % Used Account: 135-55161-030-000 Outside Services-Town Semo 33 10/09/2013 Oct A/P Contractual Services 1st insta 38,524.00 38,524.00 TOWN OF TROPHY CLUB 33087 AP _______________ Account: 135-55161-030-000 Outside Services-Town Semo Totals: 38,524.00 38,524.00 ** 77,048.00 Budgeted 38,524.00 Remaining 50 % 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 Trophy Club Municipal Utility District No. 1 93 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 47 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2013 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-55205-030-000 Utility Billing Contract Totals: .00 .00 ** 6,808.00 Budgeted 6,808.00 Remaining 0 % Used Account: 135-60005-030-000 Telephone 247 10/31/2013 Oct A/P Oct Answering Service 205.00 205.00 KEYSTONE PARK SECRETARIAL 33162 AP _______________ Account: 135-60005-030-000 Telephone Totals: 205.00 205.00 ** 11,250.00 Budgeted 11,045.00 Remaining 2 % Used Account: 135-60010-030-000 Communications/Pagers/Mobiles 100 10/25/2013 10/25/13 MUD Payroll Communications/Pagers/Mobiles 150.00 150.00 PR _______________ Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 150.00 150.00 ** 3,589.00 Budgeted 3,439.00 Remaining 4 % Used Account: 135-60020-030-000 Electricity/Gas .00 .00 _______________ Account: 135-60020-030-000 Electricity/Gas Totals: .00 .00 ** 15,171.00 Budgeted 15,171.00 Remaining 0 % Used Account: 135-60025-030-000 Water 247 10/31/2013 Oct A/P October water 202.52 202.52 TROPHY CLUB MUD (WATER BILLS) 33175 AP 234 10/31/2013 Town billed Inv 1101 AR 20131031-20131031 User: (101.26) 101.26 AR _______________ Account: 135-60025-030-000 Water Totals: 101.26 101.26 ** 1,500.00 Budgeted 1,398.74 Remaining 7 % Used Account: 135-60035-030-000 Postage 45 10/11/2013 Oct A/P Bulk mailing 868.10 868.10 U.S. POSTAL SERVICE 33088 AP 130 10/24/2013 October A/P Permit 3 200.00 1,068.10 U.S. POSTAL SERVICE 33116 AP 130 10/24/2013 October A/P overnight letter 6.17 1,074.27 FEDERAL EXPRESS CORP 33093 AP 235 10/31/2013 October Postage meter usage 293.05 1,367.32 GL 237 10/31/2013 Recode PPD Postage/Town inv's (100.00) 1,267.32 GL _______________ Account: 135-60035-030-000 Postage Totals: 1,267.32 1,267.32 ** 28,500.00 Budgeted 27,232.68 Remaining 4 % Used Trophy Club Municipal Utility District No. 1 94 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 48 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60040-030-000 Service Charges & Fees .00 .00 _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: .00 .00 ** 28,330.00 Budgeted 28,330.00 Remaining 0 % 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 47 10/01/2013 Oct Ins & W/C Expense 4,269.73 4,269.73 GL 247 10/31/2013 Oct A/P Blanket Notary 33.25 4,302.98 CNA SURETY 33145 AP _______________ Account: 135-60055-030-000 Insurance Totals: 4,302.98 4,302.98 ** 53,561.00 Budgeted 49,258.02 Remaining 8 % Used Account: 135-60066-030-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-60070-030-000 Dues & Memberships 130 10/24/2013 October A/P Dues/Membership 100.00 100.00 N CENTRAL TX COG 33104 AP _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 100.00 100.00 ** 4,500.00 Budgeted 4,400.00 Remaining 2 % Used Account: 135-60075-030-000 Meetings .00 .00 _______________ Account: 135-60075-030-000 Meetings Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60080-030-000 Schools & Training Trophy Club Municipal Utility District No. 1 95 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 49 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2013 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-60080-030-000 Schools & Training Totals: .00 .00 ** 7,500.00 Budgeted 7,500.00 Remaining 0 % Used Account: 135-60100-030-000 Travel & per diem .00 .00 _______________ Account: 135-60100-030-000 Travel & per diem Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % 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 .00 .00 _______________ Account: 135-60115-030-000 Elections Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % 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 .00 .00 _______________ Account: 135-60235-030-000 Security Totals: .00 .00 ** 1,350.00 Budgeted 1,350.00 Remaining 0 % Used Account: 135-60245-030-000 Miscellaneous Expenses 226 10/26/2013 10/1-10/26 PCards RANDALLS STORE00017897 5.12 5.12 RANDALLS STORE00017897 PC Trophy Club Municipal Utility District No. 1 96 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 50 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 226 10/26/2013 10/1-10/26 PCards WAL-MART #5247 14.58 19.70 WAL-MART #5247 PC _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: 19.70 19.70 ** 22,870.00 Budgeted 22,850.30 Remaining 0 % Used Account: 135-60270-030-000 4th of July Celebration .00 .00 _______________ Account: 135-60270-030-000 4th of July Celebration Totals: .00 .00 ** 10,500.00 Budgeted 10,500.00 Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-65010-030-000 Uniforms .00 .00 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 .00 ** 1,390.00 Budgeted 1,390.00 Remaining 0 % Used Account: 135-65055-030-000 Hardware 226 10/26/2013 10/1-10/26 PCards BEST BUY 00001487 305.97 305.97 BEST BUY 00001487 PC _______________ Account: 135-65055-030-000 Hardware Totals: 305.97 305.97 ** 13,562.00 Budgeted 13,256.03 Remaining 2 % Used Account: 135-65085-030-000 Office Supplies 226 10/26/2013 10/1-10/26 PCards FEDEXOFFICE 00019364 156.16 156.16 FEDEXOFFICE 00019364 PC 226 10/26/2013 10/1-10/26 PCards OFFICE DEPOT #406 94.25 250.41 OFFICE DEPOT #406 PC 158 10/30/2013 Oct A/P Office Supplies 274.97 525.38 OFFICE DEPOT, INC 33133 AP 158 10/30/2013 Oct A/P Office Supplies 21.99 547.37 OFFICE DEPOT, INC 33133 AP 247 10/31/2013 Oct A/P Office supplies 153.60 700.97 OFFICE DEPOT, INC 33166 AP 233 10/31/2013 Town Billed Inv 1094-1100 AR 20131001-20131031 User: (27.49) 673.48 AR _______________ Account: 135-65085-030-000 Office Supplies Totals: 673.48 673.48 ** 9,100.00 Budgeted 8,426.52 Remaining 7 % Used Trophy Club Municipal Utility District No. 1 97 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 51 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65090-030-000 Printer Supplies & Maintenance .00 .00 _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 .00 ** 5,732.00 Budgeted 5,732.00 Remaining 0 % Used Account: 135-65095-030-000 Maintenance Supplies 226 10/26/2013 10/1-10/26 PCards SAMSCLUB #4795 94.40 94.40 SAMSCLUB #4795 PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 94.40 94.40 ** 2,500.00 Budgeted 2,405.60 Remaining 4 % Used Account: 135-65097-030-000 Vending Machine Supplies 220 10/15/2013 WWTP Vending 27.06 27.06 GL _______________ Account: 135-65097-030-000 Vending Machine Supplies Totals: 27.06 27.06 ** 200.00 Budgeted 172.94 Remaining 14 % Used Account: 135-65105-030-000 Printing 130 10/24/2013 October A/P printing 1,401.00 1,401.00 LOGAN GRAPHICS, INC 33100 AP _______________ Account: 135-65105-030-000 Printing Totals: 1,401.00 1,401.00 ** 4,000.00 Budgeted 2,599.00 Remaining 35 % Used Account: 135-69170-030-000 Copier Lease Installments 155 10/30/2013 Oct A/P Copier lease, FD Communication 256.85 256.85 TOWN OF TROPHY CLUB 33135 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 256.85 256.85 ** 3,450.00 Budgeted 3,193.15 Remaining 7 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 86,946.13 ** 1,055,199.00 Budgeted 968,252.87 Remaining 8 % Used Trophy Club Municipal Utility District No. 1 98 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 52 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 10/2013 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 .00 .00 _______________ Account: 135-55045-039-000 Legal Totals: .00 .00 ** 131,300.00 Budgeted 131,300.00 Remaining 0 % Used Account: 135-55055-039-000 Auditing .00 .00 _______________ Account: 135-55055-039-000 Auditing Totals: .00 .00 ** 21,840.00 Budgeted 21,840.00 Remaining 0 % Used Account: 135-55060-039-000 Appraisal 247 10/31/2013 Oct A/P Annual Budget Allocation 2,415.89 2,415.89 TARRANT APPRAISAL DISTRICT 33171 AP 187 10/31/2013 Oct A/P 2013 Taxes 3.996 Acres 928.81 3,344.70 DENTON COUNTY TAX OFFICE 33136 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 3,344.70 3,344.70 ** 10,000.00 Budgeted 6,655.30 Remaining 33 % Used Account: 135-55065-039-000 Tax Admin Fees .00 .00 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 .00 ** 3,800.00 Budgeted 3,800.00 Remaining 0 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 3,344.70 ** 166,940.00 Budgeted 163,595.30 Remaining 2 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ (214,207.25) .00 Budgeted 214,207.25 Remaining 0 % Used Trophy Club Municipal Utility District No. 1 99 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 53 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: Program: Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-49010-000-000 Interest Income 225 10/31/2013 Bank Interest/Oct (13.98) (13.98) GL _______________ Account: 507-49010-000-000 Interest Income Totals: (13.98) (13.98) ** .00 Budgeted 13.98 Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (13.98) ** .00 Budgeted 13.98 Remaining 0 % Used Trophy Club Municipal Utility District No. 1 100 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 54 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 2 Rate of Flow Control-FW Meter Period Ending: 10/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 507-69280-010-002 Capital Repairs/ROFC FW Meter 158 10/30/2013 Oct A/P ROFC Project 2,360.00 2,360.00 DHS AUTOMATION, INC 33126 AP 247 10/31/2013 Oct A/P ROFC Project 525.00 2,885.00 DELTATEK ENGINEERING 33147 AP _______________ Account: 507-69280-010-002 Capital Repairs/ROFC FW Meter Totals: 2,885.00 2,885.00 ** .00 Budgeted (2,885.00) Remaining 0 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 2,885.00 ** .00 Budgeted (2,885.00) Remaining 0 % Used Fund 507 Totals: ------------------------------------------------------------------------------------------------------ 2,871.02 .00 Budgeted (2,871.02) Remaining 0 % Used Trophy Club Municipal Utility District No. 1 101 of 173 November 19, 2013 TROPHY CLUB MUD #1 - I&S BALANCE SHEET OCTOBER 2013 INTEREST & SINKING ASSETS CASH IN BANK 4,846 INVESTMENTS 20,342 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 395,746 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 420,934 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 395,746 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 395,746 FUND BALANCE ASSIGNED FUND BALANCE 17,879 NET REVENUES / EXPENDITURES 7,310 TOTAL FUND BALANCE 25,188 TOTAL LIABILITIES AND FUND BALANCE 420,934 Trophy Club Municipal Utility District No. 1 102 of 173 November 19, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 18 18:59 11/13/13 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 10/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 389,216.00- 389,216.00- 7,315.96- 7,315.96- 1.880 381,900.04- 533-40002-000-000 Property Taxes/Delinquent 2,500.00- 2,500.00- 19.78 19.78 -.791 2,519.78- 533-40015-000-000 Property Taxes/P & I 1,600.00- 1,600.00- 12.81- 12.81- .801 1,587.19- Subtotal: 393,316.00- 393,316.00- 7,308.99- 7,308.99- 1.858 386,007.01- 533-48005-000-000 Reserve Funds/PID Utility Fees 16,525.00- 16,525.00- 16,525.00- Subtotal: 16,525.00- 16,525.00- 16,525.00- 533-49010-000-000 Interest Income 375.00- 375.00- .58- .58- .155 374.42- 533-49015-000-000 Lease/Rental Income 214,279.00- 214,279.00- 214,279.00- Subtotal: 214,654.00- 214,654.00- .58- .58- 214,653.42- Program number: 624,495.00- 624,495.00- 7,309.57- 7,309.57- 1.170 617,185.43- Department number: Revenues 624,495.00- 624,495.00- 7,309.57- 7,309.57- 1.170 617,185.43- Revenues Subtotal ----------- 624,495.00- 624,495.00- 7,309.57- 7,309.57- 1.170 617,185.43- Trophy Club Municipal Utility District No. 1 103 of 173 November 19, 2013 . glbase_tbam rgonzale Trophy Club MUD #1 Page 19 18:59 11/13/13 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 10/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 2,300.00 2,300.00 2,300.00 533-70025-051-000 Bond Interest Expense 197,195.00 197,195.00 197,195.00 533-70035-051-000 Bond Principal Payment 425,000.00 425,000.00 425,000.00 Subtotal: 624,495.00 624,495.00 624,495.00 Program number: 624,495.00 624,495.00 624,495.00 Department number: Administration 624,495.00 624,495.00 624,495.00 Expenditures Subtotal ----------- 624,495.00 624,495.00 624,495.00 Fund number: 533 MUD 1 I&S Consolidated 7,309.57- 7,309.57- 7,309.57 ******* End of Report ********* Trophy Club Municipal Utility District No. 1 104 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 55 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 10/2013 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 199 10/14/2013 Property Taxes/Assessments (138.79) (138.79) GL 200 10/15/2013 Property Taxes/Assessments (73.81) (212.60) GL 202 10/16/2013 Property Taxes/Assessments (291.57) (504.17) GL 203 10/17/2013 Property Taxes/Assessments (39.74) (543.91) GL 207 10/21/2013 Property Taxes/Assessments (1,426.19) (1,970.10) GL 208 10/22/2013 Property Taxes/Assessments (546.19) (2,516.29) GL 209 10/23/2013 Property Taxes/Assessments (1,012.34) (3,528.63) GL 210 10/24/2013 Property Taxes/Assessments (1,144.37) (4,673.00) GL 211 10/25/2013 Property Taxes/Assessments (472.47) (5,145.47) GL 212 10/28/2013 Property Taxes/Assessments (609.20) (5,754.67) GL 213 10/29/2013 Property Taxes/Assessments (435.09) (6,189.76) GL 214 10/30/2013 Property Taxes/Assessments (90.07) (6,279.83) GL 215 10/31/2013 Property Taxes/Assessments (1,036.13) (7,315.96) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (7,315.96) (7,315.96) ** (389,216.00) Budgeted (381,900.04) Remaining 2 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 199 10/14/2013 Property Taxes/Assessments 46.79 46.79 GL 202 10/16/2013 Property Taxes/Assessments (32.75) 14.04 GL 211 10/25/2013 Property Taxes/Assessments (4.85) 9.19 GL 212 10/28/2013 Property Taxes/Assessments (.27) 8.92 GL 213 10/29/2013 Property Taxes/Assessments 18.79 27.71 GL 215 10/31/2013 Property Taxes/Assessments (7.93) 19.78 GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: 19.78 19.78 ** (2,500.00) Budgeted (2,519.78) Remaining -1 % Used Account: 533-40015-000-000 Property Taxes/P & I 199 10/14/2013 Property Taxes/Assessments (3.20) (3.20) GL 202 10/16/2013 Property Taxes/Assessments (6.88) (10.08) GL 211 10/25/2013 Property Taxes/Assessments (1.02) (11.10) GL 212 10/28/2013 Property Taxes/Assessments (.05) (11.15) GL 215 10/31/2013 Property Taxes/Assessments (1.66) (12.81) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (12.81) (12.81) ** (1,600.00) Budgeted (1,587.19) Remaining 1 % Used Account: 533-48005-000-000 Reserve Funds/PID Utility Fees Trophy Club Municipal Utility District No. 1 105 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 56 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 10/2013 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: 533-48005-000-000 Reserve Funds/PID Utility Fees Totals: .00 .00 ** (16,525.00) Budgeted (16,525.00) Remaining 0 % Used Account: 533-49010-000-000 Interest Income 225 10/31/2013 Bank Interest/Oct (.58) (.58) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (.58) (.58) ** (375.00) Budgeted (374.42) Remaining 0 % Used Account: 533-49015-000-000 Lease/Rental Income .00 .00 _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 .00 ** (214,279.00) Budgeted (214,279.00) Remaining 0 % Used Department Totals: ------------------------------------------------------------------------------------------------ (7,309.57) ** (624,495.00) Budgeted (617,185.43) Remaining 1 % Used Trophy Club Municipal Utility District No. 1 106 of 173 November 19, 2013 . glpdatb2 rgonzale Trophy Club MUD #1 Page 57 19:00 11/13/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 10/2013 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 .00 .00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 .00 ** 2,300.00 Budgeted 2,300.00 Remaining 0 % Used Account: 533-70025-051-000 Bond Interest Expense .00 .00 _______________ Account: 533-70025-051-000 Bond Interest Expense Totals: .00 .00 ** 197,195.00 Budgeted 197,195.00 Remaining 0 % Used Account: 533-70035-051-000 Bond Principal Payment .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment Totals: .00 .00 ** 425,000.00 Budgeted 425,000.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ .00 ** 624,495.00 Budgeted 624,495.00 Remaining 0 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (7,309.57) .00 Budgeted 7,309.57 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- (195,072.27) **** .00 Budgeted 195,072.27 Remaining 0 % Used ******* End of Report ********* Trophy Club Municipal Utility District No. 1 107 of 173 November 19, 2013 Fund Fund # Unassigned (Available for any purpose) Assigned (Intended to be used for specific purposes) Non-Spendable (Amounts not in spendable form & required to be maintained intact) Total Fund Balances 2013 Adopted Expense Budget % Unassigned Fund Balance to Adopted Expenses 2013 Amended Expense Budget % Unassigned Fund Balance to Amended Expenses General Fund 135 $2,896,962 $276,500 $29,524 $3,202,985 $6,417,937 45.1385%$6,417,937 45.1385% Fire Department 122 $472,114 $0 $472,114 $1,260,950 37.4411%$1,260,950 37.4411% Capital Projects 507 $0 $242,230 $242,230 GASB 137 $0 $313,050 $313,050 Interest & Sinking 533 $0 $25,188 $25,188 $3,369,076 $856,968 $29,524 $4,255,567 $7,678,887 $7,678,887 Our GASB #54 Policy states that our goal is to achieve and maintain our General Fund Unassigned Fund Balance equal to 35% of expenditures and not to go below 25%, barring unusual or deliberate circumstances. Fund Fund # Unassigned (Available for any purpose) Assigned (Intended to be used for specific purposes) Non-Spendable (Amounts not in spendable form & required to be maintained intact) Total Fund Balances 2013 Adopted Expense Budget % Unassigned Fund Balance to Adopted Expenses 2013 Amended Expense Budget % Unassigned Fund Balance to Amended Expenses General Fund 135 $2,896,962 $276,500 $29,524 $3,202,985 $6,417,937 $6,417,937 Fire Department 122 $472,114 $0 $472,114 $1,260,950 $1,260,950 Capital Projects 507 $0 $242,230 $242,230 0 0 GASB 137 $0 $313,050 $313,050 0 0 Interest & Sinking 533 $0 $25,188 $25,188 0 0 $3,369,076 $856,968 $29,524 $4,255,567 $7,678,887 43.8745%$7,678,887 43.8745% * Our Auditors class General Fund, Fire Department, Capital Projects and GASB Funds together as Total General Fund. This sheet calculates the % accordingly. Trophy Club MUD #1 Fund Balances @ 10/31/13 - by Separate Funds Trophy Club MUD #1 Fund Balances @ 10/31/13 - by All Funds Together * Unassigned Fund Balance Percentages based on GASB 54 Policy adopted September 2013 Unassigned Fund Balance Percentages based on GASB 54 Policy adopted September 2013 Trophy Club Municipal Utility District No. 1 108 of 173 November 19, 2013 Oct.Nov.Dec.Jan Feb.March April May June July August Sept.Total for year FYI- Physical Year 2005-2006 74,441 56,296 41,272 54,171 37,626 35,714 55,429 60,800 88,899 113,904 122,820 81,806 823,178 2006-2007 73,757 44,297 35,905 31,695 25,671 40,516 43,121 31,204 42,191 43,717 72,462 76,138 560,674 2007-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 2008-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 2009-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 2010-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 2011-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 2012-2013 85,488 75,251 48,527 39,601 34,668 47,880 59,384 89,956 101,192 132,030 154,885 137,339 1,006,201 2013-2014 93,049 October November December January February March April May June July August 79,297 48,609 36,966 32,915 26,974 25,771 31,755 46,747 70,315 69,134 92,539 84,849 51,836 38,869 32,850 24,742 25,111 32,240 47,364 75,755 68,715 82,007 90,400 55,063 40,772 32,785 22,510 24,451 32,726 47,980 81,195 68,296 71,476 95,952 58,290 42,675 32,721 20,278 23,791 33,211 48,597 86,636 67,878 350,497 213,799 159,281 131,271 94,504 99,122 129,932 190,688 313,900 274,022 246,022 Oct.Nov.Dec.Jan Feb.March April May June July August Sept.Total for year FYI- Physical Year 2006 74,585 55,405 42,852 52,100 33,247 39,250 64,455 73,048 93,187 118,353 127,450 76,301 850,233 2007 72,460 49,249 34,203 28,257 31,492 43,900 41,770 37,340 41,215 43,136 75,480 72,087 570,589 2008 64,370 50,090 35,320 36,610 34,630 34,750 42,900 63,116 78,399 114,256 98,670 72,551 725,662 2009 65,110 48,570 36,411 36,587 36,385 44,120 48,881 38,250 66,450 116,823 94,525 81,500 713,612 2010 40,803 41,600 32,700 31,400 30,145 27,240 43,400 62,646 113,049 94,950 131,650 76,159 725,742 2011 70,502 50,993 44,220 33,789 36,053 54,775 71,306 63,500 116,350 152,002 169,621 117,190 980,301 2012 83,750 54,245 41,650 34,740 31,581 46,519 62,649 100,402 110,324 153,813 139,005 123,045 981,723 2013 85,966 77,758 55,110 39,283 37,867 56,743 60,969 87,168 96,602 119,414 145,988 120,342 983,210 2014 81,909 . Active Connections MUD PID MUD PID 2007 2008 2009 2010 2011 2012 2013 2013 2014 2014 January 2815 2853 2976 3151 3358 3640 3915 February 2815 2865 2977 3168 3366 3667 3932 March 2817 2865 3013 3201 3392 3701 3950 April 2817 2855 3014 3210 3409 3725 3978 May 2825 2897 3004 3229 3465 3735 4028 June 2825 2897 3056 3251 3433 3759 4062 July 2825 2914 3064 3260 3471 3796 4084 August 2825 2927 3083 3282 3559 3815 4095 September 2869 2929 3105 3298 3573 3863 3031 1088 October 2869 2946 3113 3318 3542 3879 3014 1125 November 2857 2952 3127 3334 3540 3887 December 2867 2956 3146 3351 3582 3880 0 20,000 40,000 60,000 80,000 100,000 120,000 140,000 160,000 180,000 Million Gallons Months Water Billed 2011 2012 2013 2014 0 20,000 40,000 60,000 80,000 100,000 120,000 140,000 160,000 180,000 Million Gallons Months Water Pumped 2011 2012 2013 2014 Trophy Club Municipal Utility District No. 1 109 of 173 November 19, 2013 % Removal% Removal% RemovalDate Influent EffluentInfluent EffluentInfluent Effluent1‐Oct30 0.12 99.6% 140 2.0 98.6% 190 1.4 99.3%3‐Oct56 0.23 99.6% 170 2.0 98.8% 146 1.0 99.3%   8‐Oct36 0.21 99.4% 115 2.0 98.3% 170 1.2 99.3%9‐Oct61 0.21 99.7% 218 2.0 99.1% 273 1.0 99.6%   14‐Oct38 0.54 98.6% 105 2.0 98.1% 167 1.0 99.4%15‐Oct68 0.31 99.5% 147 2.0 98.6% 161 2.2 98.6%   21‐Oct61 0.14 99.8% 234 2.0 99.1% 652 1.0 99.8%22‐Oct24 0.1 99.6% 150 2.0 98.7% 142 1.0 99.3%28‐Oct37 0.18 99.5% 137 2.0 98.5% 212 5.8 97.3%29‐Oct36 0.13 99.6% 184 2.0 98.9% 223 2.2 99.0% Report99.5%98.7%99.3%Oct. 2013 ResultsAmmonia‐NCBOD5TSS0.222.01.78Ammonia‐NCBOD5TSSTrophy Club Municipal Utility District No. 1110 of 173November 19, 2013 Max mg/L 1.92 Aver mg/L 0.477 hod Max mg/L 5.9 Aver mg/L 4.0 Ammonia Nitrogen Carbonaceous Biochemical Demand (CBOD5) 0.8 0.160 0.420 0.790 0.270 0.180 0.230 0.350 0.3 0.3 0.21 0.97 0.76 0.398 1.3 1.92 0.783 0.226 0.26 0.175 0.16 0.17 0.15 0.16 0.22 0.00 0.50 1.00 1.50 2.00 2.50 3.00 3.50 4.00 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 Sep-13 Oct-13 Nov-13 Permit Limit 1.0 April-Sept 3.0 Oct -March Average NH3-N 5.700 5.400 5.900 3.800 4.600 3.500 5.200 4.500 3.800 4.10 5.00 4.40 5.10 5.30 5.90 3.89 3.70 2.00 2.10 2.00 2.10 2.00 2.40 2.00 0.00 1.00 2.00 3.00 4.00 5.00 6.00 7.00 8.00 9.00 10.00 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 Sep-13 Oct-13 Nov-13 Permit Limit 5 CBOD5 Average Trophy Club Municipal Utility District No. 1 111 of 173 November 19, 2013 Max mg/L 34 Aver mg/L 4.3 Max mg/L 23.0 Aver mg/L 15.3 Max mg/L 68.0 Aver mg/L 8.4 Total Suspended Solids (TSS) Nitrate - Nitrogen E. Coli 1.5 10.4 10.4 34.0 0.6 2.6 5.1 2.3 2.0 2.6 2.0 2.0 2.1 2.1 2.2 2.3 3.9 3.6 1.3 1.3 1.4 1.5 1.7 1.8 0.00 10.00 20.00 30.00 40.00 50.00 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 Sep-13 Oct-13 Nov-13 Permit Limit 12.0 Average TSS 22.5 23.0 14.7 21.4 19.6 19.0 20.0 19.5 8.0 14.8 10.9 11.9 11.4 9.5 5.2 23.0 13.6 11.0 12.4 16.5 16.5 14.4 12.5 14.8 0.00 5.00 10.00 15.00 20.00 25.00 30.00 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 Sep-13 Oct-13 Nov-13 Permit Limit 24 N-N Average 1.0 49.0 35.0 68.0 1.0 2.0 10 3.0 1.1 1.7 1.1 1.0 1.3 1.9 2.7 2.4 2.2 2.3 1 1.5 1 1 1.4 1.2 0.00 20.00 40.00 60.00 80.00 100.00 120.00 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 Sep-13 Oct-13 Nov-13 Permit Limit 126 E. coli Average Trophy Club Municipal Utility District No. 1 112 of 173 November 19, 2013 Max mg/L 8.1 Min mg/L 5.8 Aver mg/L 7.8 Max mg/L 7.9 Aver mg/L 6.6 DO Potential for Hydrogen (pH) Dissolved Oxygen (DO) 7.3 6.9 5.8 6.9 6.9 6.9 6.7 6.9 7.3 7.4 7.8 7.6 7.8 7.7 7.7 7.7 7.3 7.1 7.1 6.7 7.2 7.3 7.2 7.1 0.00 2.00 4.00 6.00 8.00 10.00 12.00 14.00 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 Sep-13 Oct-13 Nov-13 Permit Limit Mimimum 6.0 Average pH minimum 6.8 7.9 5.3 5.5 5.5 6.1 6.0 6.0 6.0 6.0 6.9 7.0 7.1 6.9 7.5 7.1 7.6 7.1 6.9 6.6 7 7 6.4 6.7 0.00 1.00 2.00 3.00 4.00 5.00 6.00 7.00 8.00 9.00 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 Sep-13 Oct-13 Nov-13 Permit Limit (ABOVE) 6.0 Average DO Trophy Club Municipal Utility District No. 1 113 of 173 November 19, 2013 Oct 1, 2013 ­ Oct 31, 2013Audience Overview Language Visits % Visits 1.en­us 2,389 99.42% 2.en 5 0.21% 3.c 3 0.12% 4.ko­kr 3 0.12% 5.es­us 1 0.04% 6.ru 1 0.04% 7.ru­ru 1 0.04% view full report Overview 1,547 people visited this site  Visits Oct 8 Oct 15 Oct 22 Oct 29 100100100 200200200 Visits 2,403 Unique Visitors 1,547 Pageviews 5,600 Pages / Visit 2.33 Avg. Visit Duration 00:03:14 Bounce Rate 54.81% % New Visits 40.53% Returning Visitor New Visitor 40.5% 59.5% © 2013 Google All Visits 100.00% Go to this report Trophy Club MUD ­ http://www.tdmud.org All Web Site Data Trophy Club Municipal Utility District No. 1 114 of 173 November 19, 2013 Oct 1, 2013 ­ Oct 31, 2013Audience Overview Overview  Visits 404040 All Visits 100.00% Go to this report Trophy Club FIRE ­ http://www.trophyclubfd.org All Web Site Data Trophy Club Municipal Utility District No. 1 115 of 173 November 19, 2013 Language Visits % Visits 1.en­us 516 99.23% 2.de­at 1 0.19% 3.en 1 0.19% 4.pt­br 1 0.19% 5.zh­cn 1 0.19% view full report 411 people visited this site Oct 8 Oct 15 Oct 22 Oct 29 202020 Visits 520 Unique Visitors 411 Pageviews 1,504 Pages / Visit 2.89 Avg. Visit Duration 00:01:58 Bounce Rate 43.27% % New Visits 72.88% New Visitor Returning Visitor 27.1% 72.9% © 2013 Google Trophy Club Municipal Utility District No. 1 116 of 173 November 19, 2013 October November December January February March April May June July August September ebills 467 Bills Mailed 3720 Bank Draft 565 Credit Card Draft 457 Online Payments 795 Late Notices 431 Disconnects 26 M 3014 Connections P 1125 October November December January February March April May June July August September ebills 276 292 314 330 343 370 390 399 417 434 443 460 Bills Mailed 3603 3596 3567 3585 3569 3556 3562 3606 3611 3650 3652 3659 Bank Draft 539 535 547 546 549 554 562 559 553 563 553 554 Credit Card Draft 261 280 298 314 320 346 365 383 388 415 429 436 Online Payments 717 571 677 727 691 764 688 765 753 763 789 803 Late Notices 389 547 422 333 385 401 336 383 488 334 390 574 Disconnects 32 32 44 39 31 22 22 30 30 34 24 37 Active Connections 3875 3886 3904 3915 3932 3950 3978 4028 4062 4084 4095 4119 Trophy Club MUD #1 Utility Billing Report Fiscal Year 2014 Fiscal Year 2013 Trophy Club Municipal Utility District No. 1 117 of 173 November 19, 2013 PID CONNECTION FEE SUMMARY OCT 2013 DEPOSIT DATE QTY (5/8") $ 2,300 QTY (1") $ 2,300 QTY (1.5") $ 7,590 QTY (2") $ 15,410 TOTAL QTY TOTAL AMOUNT TEXPOOL TRANSFER QTY CUM RUNNING BALANCE $ 3,260,000 Begin 1,135 649,500 1 - -$ - -$ - -$ - -$ - - 1,135 649,500 2 - -$ - -$ - -$ - -$ - - 1,135 649,500 3 - -$ - -$ - -$ - -$ - - 1,135 649,500 4 - -$ - -$ - -$ - -$ - - 1,135 649,500 5 - -$ - -$ - -$ - -$ - - 1,135 649,500 6 - -$ - -$ - -$ - -$ - - 1,135 649,500 7 - -$ - -$ - -$ - -$ - - 1,135 649,500 8 - -$ 2 4,600$ - -$ - -$ 2 4,600 1,137 644,900 9 - -$ - -$ - -$ - -$ - - 1,137 644,900 10 - -$ 2 4,600$ - -$ - -$ 2 4,600 1,139 640,300 11 - -$ - -$ - -$ - -$ - - 1,139 640,300 12 - -$ - -$ - -$ - -$ - - 1,139 640,300 13 - -$ - -$ - -$ - -$ - - 1,139 640,300 14 - -$ - -$ - -$ - -$ - - 1,139 640,300 15 - -$ - -$ - -$ - -$ - - 1,139 640,300 16 - -$ 2 4,600$ - -$ - -$ 2 4,600 1,141 635,700 17 - -$ 3 6,900$ - -$ - -$ 3 6,900 1,144 628,800 18 - -$ - -$ - -$ - -$ - - 1,144 628,800 19 - -$ - -$ - -$ - -$ - - 1,144 628,800 20 - -$ - -$ - -$ - -$ - - 1,144 628,800 21 - -$ - -$ - -$ - -$ - - 1,144 628,800 22 - -$ - -$ - -$ - -$ - - 1,144 628,800 23 - -$ - -$ - -$ - -$ - - 1,144 628,800 24 - -$ - -$ - -$ - -$ - - 1,144 628,800 25 - -$ 1 2,300$ - -$ - -$ 1 2,300 1,145 626,500 26 - -$ - -$ - -$ - -$ - - 1,145 626,500 27 - -$ - -$ - -$ - -$ - - 1,145 626,500 28 - -$ - -$ - -$ - -$ - - 1,145 626,500 29 - -$ 3 6,900$ - -$ - -$ 3 6,900 1,148 619,600 30 - -$ 1 2,300$ - -$ - -$ 1 2,300 1,149 617,300 31 - -$ 1 2,300$ - -$ - -$ 1 2,300 1,150 615,000 TOTAL - -$ 15 34,500$ - -$ - -$ 15 34,500 - Approximate Total # of homes in PID at build out 1,417 Total Amount to be collected at $2,300 each $3,260,000 Total number of homes collected to date 1,150 Total amount collected to date 2,645,000$ Total number of homes remaining to be collected 267 Total amount remaining to be collected 615,000$ Upon collection of one or more Utility Fees by Town,such Utility Fees shall, within ten (10)working days, be deposited by Town into an account designated by MUDs (hereinafter "MUDs Account").Town shall continue to collect and to deposit such Utility Fees into MUDs Account in accordance with the existing agreement between the MUDs until such time as the total amount paid into that account equals $3,260,000.Town shall collect and deposit a minimum of one hundred fifty (150)Utility Fees each year, for a total of five (5)successive years commencing on May 7, 2008 (hereinafter "Collection Period").In the event that more than 150 Utility Fees are collected by Town in anyone or more years of the Collection Period,such Utility Fees in excess of the 150 Utility Fees required under this Section shall be carried over to the following year or years and shall be a credit toward the total Utility Fees due for such subsequent year or years. In the event that fewer than 150 Utility Fees are collected by Town during anyone or more year(s) of the Collection Period,including those Utility Fees carried over from any given year in which more than 150 Utility Fees were collected by Town,Town shall within ten (10)working days of collection of such Utility Fees from Developer, pay into MUDs Account the difference between the amount that would have been paid had 150 Access Fees been paid at $2,300 each and the amount of Utility Fees actually collected by Town.On or about May 7, 2013,Town shall calculate the total amount of Utility Fees paid to MUDs.Town shall provide MUDs written notice of any amount paid less than $3,260,000 (the "Utility Fee Remainder"). Trophy Club Municipal Utility District No. 1 118 of 173 November 19, 2013 Oct 13 Nov 13 Dec 13 Jan 14 Feb 14 Mar 14 Apr 14 May 14 Jun 14 Jul 14 Aug 14 Sep 14Monthly AverageTotal FY 2014 YTDCalls by TypeFire55.0 5Service2727.0 27Good Intent88.0 8False Alarm88.0 8EMS3535.0 35Total Calls830000000000013.883Mutual AidGiven1414.0 14Received00.0 0Hospital TransportsTCFD2727.0 27Mutual Aid00.0 0Air00.0 0Response Time (Calls In Town)%  At or Under 6 Minutes84.684.6Average Time05:25OtherCiiEd i H145145 0145Trophy Club Fire DepartmentMonthly Activity ReportFY 2014Page 1Continuing Education Hours 145145.0 145Public Education Events 1212.0 12Service calls include inspections, lock‐outs, water problems, smoke or odor removal, public service and assistance, and public education.Fire6%Service32%Good Intent10%False Alarm10%EMS42%FY 2014 YTD Calls by Type020406080100120Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep4 Year Comparison YTD Number of CallsFY 2014FY 2013FY 2012FY 2011Trophy Club Municipal Utility District No. 1119 of 173November 19, 2013 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep FY 2014 83 FY 2013 80 66 67 61 85 89 76 79 91 97 87 67 FY 2012 69 55 72 59 71 75 70 85 47 101 83 61 FY 2011 58 57 42 65 76 50 55 63 75 53 67 77 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep FY 2014 5 FY 2013 315412235175 FY 2012 4762302841034 FY 2011 1461124647545 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep FY 2014 27 FY 2013 31 22 21 19 54 52 30 19 26 36 28 17 FY 2012 28 13 17 29 25 34 21 35 15 36 32 12 FY 2011 28 17 13 20 16 14 15 15 16 13 21 20 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep FY 2014 8 FY 2013 35632341288106 FY 2012 314373523678 FY 2011 2421101479363 Trophy Club Fire Department 4 Year Comparison of Calls Total Number of Calls Fire Calls Service Calls Good Intent Calls Page 2 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep FY 2014 8 FY 2013 4 8 742949101298 FY 2012 5 5 52446510948 FY 2011 3 2 0 9 13 3 7 9 6 6 4 10 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep FY 2014 35 FY 2013 39 30 28 31 26 23 36 36 42 40 33 31 FY 2012 24 29 40 23 32 34 36 35 15 40 37 29 FY 2011 24 30 21 34 25 27 23 28 37 26 32 39 FY 2014 35 FY 2014 83 FY 2013 39 FY 2013 80 FY 2012 24 FY 2012 69 FY 2011 24 FY 2011 58 FY 2014 48 FY 2013 41 FY 2012 45 FY 2011 34 Number of Calls vs Prior Year EMS Calls Fire & Related Calls Total Calls False Alarms EMS Calls Roanoke  (13 calls) Southlake  (1 calls) 10 0 3 1 FY 2014 YTD  Mutual Aid Given Fire/EMS Calls EMS Fire Trophy Club Municipal Utility District No. 1 120 of 173 November 19, 2013 Oct 13 Nov 13 Dec 13 Jan 14 Feb 14 Mar 14 Apr 14 May 14 Jun 14 Jul 14 Aug 14 Sep 14Monthly AverageTotal FY 2014District 1# of calls2020.0 20avg. response time04:5204:52District 2# of calls3535.0 35avg. response time05:0405:04District 4 (PID)# of calls1111.0 11avg. response time06:5606:56District 5 (TCP)# of calls00.0 0avg. response time00:00District 6 (BNHS)# of calls33.03avg. response time07:2600:56Trophy Club Fire DepartmentCalls by DistrictFY 2014Page 3Outside (Mutual Aid)# of calls1414.0 14avg. response time08:2408:24*service call24%42%13%0%4%17%% Calls by District FY 14 YTD District 1District 2District 4 (PID)District 5 (TCP)District 6 (BNHS)Outside (Mutual Aid)93%7%% Mutual Aid GivenCalls by Department Roanoke (13 calls)Southlake (1 calls)0%0%0%% Mutual Aid ReceivedCalls by DepartmentRoanoke (0 calls)Westlake (0 calls)Southlake (0 calls)Trophy Club Municipal Utility District No. 1121 of 173November 19, 2013 A Division of NewGen Strategies & Solutions, LLC Presentation of Results Water and Sewer Rate Study Trophy Club MUD No. 1 Revised: October 23, 2013 Trophy Club Municipal Utility District No. 1 122 of 173 November 19, 2013 A Division of NewGen Strategies & Solutions, LLC Agenda Fundamental Assumptions Key Issues Recommendations Monthly Bill Comparison Questions 2Trophy Club Municipal Utility District No. 1 123 of 173 November 19, 2013 A Division of NewGen Strategies & Solutions, LLC Fundamental Assumptions A Water & Sewer Utility is essentially a business and therefore, should be operated accordingly Considered a Business-Like Activity of Government Typically accounted for in an Enterprise Fund Cost to provide service should be recovered from water and sewer revenues Study only considered rate revenues 3Trophy Club Municipal Utility District No. 1 124 of 173 November 19, 2013 A Division of NewGen Strategies & Solutions, LLC Key Issues TCMUD is in need of significant wastewater capital improvements. TCMUD plans on issuing $6.0 Million in revenue-supported debt in FY 2014 for Treatment Plant Upgrades TCMUD is nearing build-out capacity, and will be losing Utility Fee Revenues from the PID PID contract terminates when all utility fees are paid Estimated to Occur in 2016; Contract Term is 2018 4Trophy Club Municipal Utility District No. 1 125 of 173 November 19, 2013 A Division of NewGen Strategies & Solutions, LLC Key Issues Wholesale Cost Increases Continue to Impact TCMUD Over $300,000 increase in wholesale water cost from City of Ft. Worth Increases must be passed through to customers to maintain financial position of the utility TCMUD’s existing short term debt will decline through 2016 5Trophy Club Municipal Utility District No. 1 126 of 173 November 19, 2013 A Division of NewGen Strategies & Solutions, LLC Key Issues Assuming “normal” precipitation conditions, TCMUD’s existing water and wastewater rates are insufficient to fully fund the cost of providing water and wastewater service Under Contract, PID customers must be charged the same rate as MUD Residential Customers through 2016 Recommend Revenue Adjustment to recover Projected 2016 Cost of Service Will require use of reserves to cover projected shortfalls Total estimated shortfall for FY 2014 & FY 2015 of $553,000 $359,000 for Water and $194,000 for Wastewater 6Trophy Club Municipal Utility District No. 1 127 of 173 November 19, 2013 Projected Revenue Under Current Rates 7 Water FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Revenue Requirement $ 4,588,940 $ 4,336,331 $ 4,516,381 $4,571,910 $ 4,767,839 Revenue Under Current Rates 3,577,181 3,711,207 3,851,935 3,999,698 4,154,850 Over / (Under) ($)($ 1,011,759)($ 625,124)($ 664,447)($ 572,212)($ 612,988) Over / Under (%)-28.28%-16.84%-17.25%-14.31% -14.75% Wastewater Revenue Requirement $ 2,157,623 $ 2,219,073 $ 2,229,793 $ 2,269,112 $ 2,323,933 Revenue Under Current Rates 1,794,717 1,867,521 1,943,966 2,024,233 2,108,513 Over / (Under) ($)($ 362,906)($ 351,552)($ 285,827)($ 244,879)($ 215,419) Over / Under (%)-20.22%-18.82%-14.70%-12.10% -10.22% Totals Revenue Requirement $ 6,746,563 $ 6,555,405 $ 6,746,174 $ 6,841,022 $ 7,091,771 Revenue Under Current Rates 5,371,897 5,578,728 5,795,900 6,023,931 6,263,364 Over / (Under) ($)($ 1,374,666)($ 976,676)($ 950,274)($ 817,091)($ 828,408) Over / Under (%)-25.59%-17.51%-16.40%-13.56% -13.23% Trophy Club Municipal Utility District No. 1 128 of 173 November 19, 2013 Recommendations –Water Rate Options Scenario 1: Adjust all out of District rates (Excluding PID) to 1.15x Keep inclining block rate design Increase upper blocks and hold percent increase between blocks constant Scenario 2: Adjust All out of District Rates (Excluding PID) to 1.15x Keep meter charge for 5/8 x 3/4 inch @ $12.71 Any meter greater than 5/8 x 3/4 inch charge $19.04 (Lifeline Rate) Increase upper blocks and hold percent increase between blocks constant Scenario 3: Adjust All out of District Rates (Excluding PID) to 1.15x Charge by Meter Size and Phase into AWWA Meter Equivalents Increase upper blocks and hold percent increase between blocks constant 8Trophy Club Municipal Utility District No. 1 129 of 173 November 19, 2013 Projected Water Rates 9 5/8 x 3/4 inch $ 12.71 $ 14.90 $ 12.71 $ 12.71 1 inch 12.71 14.90 19.04 16.71 1 1/2 inch 12.71 14.90 19.04 26.42 2 inch 12.71 14.90 19.04 38.06 3 inch 12.71 14.90 19.04 65.23 4 inch 12.71 14.90 19.04 104.04 6 inch 12.71 14.90 19.04 201.06 Volumetric Rate (per 1,000 gallons) 0 –6,000 $ 2.50 $ 2.70 $ 2.70 $ 2.70 6,001 –17,000 3.05 3.14 3.14 3.14 17,001 –25,000 3.30 3.64 3.64 3.64 25,001 –50,000 3.40 4.23 4.23 4.23 50,000 +3.50 4.91 4.91 4.91 Current Scenario 1 Scenario 2 Scenario 3 Minimum Charge Trophy Club Municipal Utility District No. 1 130 of 173 November 19, 2013 Projected Water % Increase from Current Rates 10 5/8 x 3/4 inch 17.23%0.00%0.00% 1 inch 17.23%49.80%31.47% 1 1/2 inch 17.23%49.80%107.87% 2 inch 17.23%49.80%199.45% 3 inch 17.23%49.80%413.22% 4 inch 17.23%49.80%718.57% 6 inch 17.23%49.80%1481.90% Volumetric Rate (per 1,000 gallons) 0 –6,000 8.00%8.00%8.00% 6,001 –17,000 2.95%2.95%2.95% 17,001 –25,000 10.30%10.30%10.30% 25,001 –50,000 24.41%24.41%24.41% 50,000 +40.29%40.29%40.29% Scenario 1 Scenario 2 Scenario 3 Minimum Charge Trophy Club Municipal Utility District No. 1 131 of 173 November 19, 2013 Projected Residential Water Rate Impact 11 Monthly Impact of Water Scenarios on Residential Customers Current Scenario 1 Scenario 2 Scenario 3 Meter Charge (5/8 X 3/4 Inch)$ 12.71 $ 14.90 $ 12.71 $ 12.71 Volumetric Revenue (5,000 gal)12.50 13.50 13.50 13.50 Total Bill $25.21 $ 28.40 $ 26.21 $ 26.21 Change Over / (Under) Current ($)3.19 1.00 1.00 Meter Charge (5/8 X 3/4 Inch)$ 12.71 $ 14.90 $ 12.71 $ 12.71 Volumetric Revenue (10,000 gal)27.20 28.76 28.76 28.76 Total Bill $39.91 $ 43.66 $ 41.47 $ 41.47 Change Over / (Under) Current ($)3.75 1.56 1.56 Meter Charge (5/8 X 3/4 Inch)$ 12.71 $ 14.90 $ 12.71 $ 12.71 Volumetric Revenue (15,000 gal)42.45 44.46 44.46 44.46 Total Bill $55.16 $ 59.36 $ 57.17 $57.17 Change Over / (Under) Current ($)4.20 2.01 2.01 Trophy Club Municipal Utility District No. 1 132 of 173 November 19, 2013 Projected Residential Water Rate Impact 12 Monthly Impact of Water Scenarios on Residential Customers Current Scenario 1 Scenario 2 Scenario 3 Meter Charge (5/8 X 3/4 Inch)$ 12.71 $ 14.90 $ 12.71 $ 12.71 Volumetric Revenue (18,000 gal)51.85 54.38 54.38 54.38 Total Bill $64.56 $ 69.28 $ 67.09 $ 67.09 Change Over / (Under) Current ($)4.72 2.53 2.53 Meter Charge (5/8 X 3/4 Inch)$ 12.71 $ 14.90 $ 12.71 $ 12.71 Volumetric Revenue (20,000 gal)58.45 61.66 61.66 61.66 Total Bill $71.16 $ 76.56 $ 74.37 $ 74.37 Change Over / (Under) Current ($)5.40 3.21 3.21 Meter Charge (5/8 X 3/4 Inch)$ 12.71 $ 14.90 $ 12.71 $ 12.71 Volumetric Revenue (25,000 gal)74.95 79.86 79.86 79.86 Total Bill $87.66 $ 94.76 $ 92.57 $ 92.57 Change Over / (Under) Current ($)7.10 4.91 4.91 Trophy Club Municipal Utility District No. 1 133 of 173 November 19, 2013 Projected Residential Water Rate Impact 13 Monthly Impact of Water Scenarios on Residential Customers Current Scenario 1 Scenario 2 Scenario 3 Meter Charge (1 Inch)$ 12.71 $ 14.90 $ 19.04 $ 16.71 Volumetric Revenue (5,000 gal)12.50 13.50 13.50 13.50 Total Bill $25.21 $ 28.40 $ 32.54 $ 30.21 Change Over / (Under) Current ($)3.19 7.33 5.00 Meter Charge (1 Inch)$ 12.71 $ 14.90 $ 19.04 $ 16.71 Volumetric Revenue (10,000 gal)27.20 28.76 28.76 28.76 Total Bill $39.91 $ 43.66 $ 47.80 $ 45.47 Change Over / (Under) Current ($)3.75 7.89 5.56 Meter Charge (1 Inch)$ 12.71 $ 14.90 $ 19.04 $ 16.71 Volumetric Revenue (15,000 gal)42.45 44.46 44.46 44.46 Total Bill $55.16 $ 59.36 $ 63.50 $ 61.17 Change Over / (Under) Current ($)4.20 8.34 6.01 Trophy Club Municipal Utility District No. 1 134 of 173 November 19, 2013 Projected Residential Water Rate Impact 14 Monthly Impact of Water Scenarios on Residential Customers Current Scenario 1 Scenario 2 Scenario 3 Meter Charge (1 Inch)$ 12.71 $ 14.90 $ 19.04 $ 16.71 Volumetric Revenue (18,000 gal)51.85 54.38 54.38 54.38 Total Bill $64.56 $ 69.28 $ 73.42 $ 71.09 Change Over / (Under) Current ($)4.72 8.86 6.53 Meter Charge (1 Inch)$ 12.71 $ 14.90 $ 19.04 $ 16.71 Volumetric Revenue (20,000 gal)58.45 61.66 61.66 61.66 Total Bill $71.16 $ 76.56 $ 80.70 $ 78.37 Change Over / (Under) Current ($)5.40 9.54 7.21 Meter Charge (1 Inch)$ 12.71 $ 14.90 $ 19.04 $ 16.71 Volumetric Revenue (25,000 gal)74.95 79.86 79.86 79.86 Total Bill $87.66 $ 94.76 $ 98.90 $ 96.57 Change Over / (Under) Current ($)7.10 11.24 8.91 Trophy Club Municipal Utility District No. 1 135 of 173 November 19, 2013 Projected Commercial Water Rate Impact 15 Monthly Impact of Water Scenarios on Commercial Customers Current Scenario 1 Scenario 2 Scenario 3 Meter Charge (2 Inch)$ 12.71 $ 14.90 $ 19.04 $ 38.06 Volumetric Revenue (25,000 gal)74.95 79.86 79.86 79.86 Total Bill $87.66 $ 94.76 $ 98.90 $ 117.92 Change Over / (Under) Current ($)7.10 11.24 30.26 Meter Charge (2 Inch)$ 12.71 $ 14.90 $ 19.04 $ 38.06 Volumetric Revenue (50,000 gal)159.95 185.61 185.61 185.61 Total Bill $172.66 $ 200.51 $ 204.65 $ 223.67 Change Over / (Under) Current ($)27.85 31.99 51.01 Trophy Club Municipal Utility District No. 1 136 of 173 November 19, 2013 Projected Commercial Water Rate Impact 16 Monthly Impact of Water Scenarios on Commercial Customers Current Scenario 1 Scenario 2 Scenario 3 Meter Charge (2 Inch)$ 12.71 $ 14.90 $ 19.04 $ 38.06 Volumetric Revenue (75,000 gal)247.45 308.36 308.36 308.36 Total Bill $260.16 $ 323.26 $ 327.40 $ 346.42 Change Over / (Under) Current ($)63.10 67.24 86.26 Meter Charge (2 Inch)$ 12.71 $ 14.90 $ 19.04 $ 38.06 Volumetric Revenue (100,000 gal)334.95 431.11 431.11 431.11 Total Bill $347.66 $ 446.01 $ 450.15 $ 469.17 Change Over / (Under) Current ($)98.35 102.49 121.51 Trophy Club Municipal Utility District No. 1 137 of 173 November 19, 2013 Number of Customers By Meter Size (May 2013 Active Meter Count) 17 5/8 x 3/4 inch 2,491 1 inch 1,403 1 1/2 inch 18 2 inch 77 3 inch 13 4 inch 12 6 inch 2 8 inch 1 Note: All active meters including Effluent meters in May 2013 Billing Data. Apartments Units are charged at 5/8 x 3/4 inch meter size per Apartment Unit and NOT by Meter Size. Only Meter Sizes indicated above. Trophy Club Municipal Utility District No. 1 138 of 173 November 19, 2013 Recommendations –Sewer Rate Options Scenario 1: Keep current rate structure to recover cost of service Adjust All out of District Rates (Excluding PID) to 1.15x Scenario 2: Adjust all out of District rates (excluding PID) to 1.15x Raise Residential Cap to 18K Keep inclining block rate design for commercial Scenario 3: Adjust all out of District rates (excluding PID) to 1.15x All Volumes Charged the same rate, No Blocks Keep Residential Cap at 12K gallons Scenario 4: Adjust all out of District rates (excluding PID) to 1.15x All Volumes Charged the same rate, No Blocks Raise Residential Cap at 18K gallons 18Trophy Club Municipal Utility District No. 1 139 of 173 November 19, 2013 Projected Residential Sewer Rates Current Scenario 1 Scenario 2 Scenario 3 Scenario 4 Minimum Charge $ 12.71 $ 14.58 $ 13.00 $ 14.58 $ 14.58 Volumetric Rate (000, gallons) 0 –6,000 $ 2.50 $ 2.88 $ 2.50 $ 3.05 $2.50 6,001 -12,000 2.50 2.88 3.05 6,0001 –18,000 2.50 2.50 19Trophy Club Municipal Utility District No. 1 140 of 173 November 19, 2013 Projected % Increase from Current Residential Sewer Rates Scenario 1 Scenario 2 Scenario 3 Scenario 4 Minimum Charge 14.68%2.28%14.68%14.68% Volumetric Rate (000, gallons) 0 –6,000 15.20%0.00%22.00%0.00% 6,001 -12,000 15.20%22.00% 6,0001 –18,000 *0.00%*0.00% 20 *No change in volumetric charge because of adjustment to rate design. Trophy Club Municipal Utility District No. 1 141 of 173 November 19, 2013 Projected Commercial Sewer Rates Current Scenario 1 Scenario 2 Scenario 3 Scenario 4 Minimum Charge $ 12.71 $ 14.58 $ 13.00 $ 14.58 $ 14.58 Volumetric Rate (000, gallons) 0 –6,000 $ 2.50 $ 2.88 $ 2.50 $ 3.05 $2.50 6,001 –17,000 3.05 3.52 3.05 3.05 2.50 17,001 –25,000 3.30 3.81 3.30 3.05 2.50 25,001 –50,000 3.40 3.92 3.40 3.05 2.50 50,000+3.50 4.04 3.50 3.05 2.50 21Trophy Club Municipal Utility District No. 1 142 of 173 November 19, 2013 Projected % Increase/Decrease from Current Commercial Sewer Rates Scenario 1 Scenario 2 Scenario 3 Scenario 4 Minimum Charge 14.68%2.28%14.68%14.68% Volumetric Rate (000, gallons) 0 –6,000 15.50%0.00%22.00%0.00% 6,001 –17,000 15.41%0.00%0.00%-18.03% 17,001 –25,000 15.45%0.00%-7.58%-24.24% 25,001 –50,000 15.29%0.00%-10.29%-26.47% 50,000+15.43%0.00%-12.86%-28.57% 22Trophy Club Municipal Utility District No. 1 143 of 173 November 19, 2013 Residential Sewer Rate Impact 23 Monthly Impact of Sewer Scenarios on Residential Customers Current Scenario 1 Scenario 2 Scenario 3 Scenario 4 Minimum Charge $ 12.71 $ 14.58 $ 13.00 $ 14.58 $ 14.58 Flow Revenue (5,000 gal)12.50 14.40 12.50 15.25 12.50 Total Bill $25.21 $ 28.98 $ 25.50 $ 29.83 $ 27.08 Change Over / (Under) Current ($)3.77 0.29 4.62 1.87 Minimum Charge $ 12.71 $ 14.58 $ 13.00 $ 14.58 $ 14.58 Flow Revenue (10,000 gal)25.00 28.80 25.00 30.50 25.00 Total Bill $37.71 $ 43.38 $ 38.00 $ 45.08 $ 39.58 Change Over / (Under) Current ($)5.67 0.29 7.37 1.87 Minimum Charge $ 12.71 $ 14.58 $ 13.00 $ 14.58 $ 14.58 Flow Revenue (15,000 gal)30.00 34.56 37.50 36.60 37.50 Total Bill $42.71 $ 49.14 $ 50.50 $ 51.18 $ 52.08 Change Over / (Under) Current ($)6.43 7.79 8.47 9.37 Trophy Club Municipal Utility District No. 1 144 of 173 November 19, 2013 Residential Sewer Rate Impact 24 Monthly Impact of Sewer Scenarios on Residential Customers Current Scenario 1 Scenario 2 Scenario 3 Scenario 4 Minimum Charge $ 12.71 $ 14.58 $ 13.00 $ 14.58 $ 14.58 Flow Revenue (18,000 gal)30.00 34.56 45.00 36.60 45.00 Total Bill $42.71 $ 49.14 $ 58.00 $ 51.18 $ 59.58 Change Over / (Under) Current ($)6.43 15.29 8.47 16.87 Minimum Charge $ 12.71 $ 14.58 $ 13.00 $ 14.58 $ 14.58 Flow Revenue (20,000 gal)30.00 34.56 45.00 36.60 45.00 Total Bill $42.71 $ 49.14 $ 58.00 $ 51.18 $ 59.58 Change Over / (Under) Current ($)6.43 15.29 8.47 16.87 Minimum Charge $ 12.71 $ 14.58 $ 13.00 $ 14.58 $ 14.58 Flow Revenue (25,000 gal)30.00 34.56 45.00 36.60 45.00 Total Bill $42.71 $ 49.14 $ 58.00 $ 51.18 $ 59.58 Change Over / (Under) Current ($)6.43 15.29 8.47 16.87 Trophy Club Municipal Utility District No. 1 145 of 173 November 19, 2013 Commercial Sewer Rate Impact 25 Monthly Impact of Sewer Scenarios on Commercial Customers Current Scenario 1 Scenario 2 Scenario 3 Scenario 4 Minimum Charge $ 12.71 $ 14.58 $ 13.00 $ 14.58 $ 14.58 Flow Revenue (25,000 gal)74.95 86.48 74.95 76.25 62.50 Total Bill $87.66 $ 101.06 $ 87.95 $ 90.83 $ 77.08 Change Over / (Under) Current ($)13.40 0.29 3.17 (10.58) Minimum Charge $ 12.71 $ 14.58 $ 13.00 $ 14.58 $ 14.58 Flow Revenue (50,000 gal)159.95 184.48 159.95 152.50 125.00 Total Bill $172.66 $ 199.06 $ 172.95 $ 167.08 $ 139.58 Change Over / (Under) Current ($)26.40 0.29 (5.58)(33.08) Trophy Club Municipal Utility District No. 1 146 of 173 November 19, 2013 Commercial Sewer Rate Impact 26 Monthly Impact of Sewer Scenarios on Commercial Customers Current Scenario 1 Scenario 2 Scenario 3 Scenario 4 Minimum Charge $ 12.71 $ 14.58 $ 13.00 $ 14.58 $ 14.58 Flow Revenue (75,000 gal)247.45 285.48 247.45 228.45 187.50 Total Bill $260.16 $ 300.06 $ 260.45 $ 243.33 $ 202.08 Change Over / (Under) Current ($)39.90 0.29 (16.83)(58.08) Minimum Charge $ 12.71 $ 14.58 $ 13.00 $ 14.58 $ 14.58 Flow Revenue (100,000 gal)334.95 386.48 334.95 305.00 250.00 Total Bill $347.66 $ 401.06 $ 347.95 $ 319.58 $ 264.58 Change Over / (Under) Current ($)53.40 0.29 (28.08)(83.08) Trophy Club Municipal Utility District No. 1 147 of 173 November 19, 2013 Overall Recommendations Recover water & sewer expenses through rates Charge by meter size and phase in AWWA Meter Equivalents Pass Through TCEQ Regulatory Assessment Fee & include as Line-Item on Bill Lower Out of District Charges from 2x to 1.15x In-district rates Increase rates to recover projected 2016 Cost of Service; fund projected short-falls with reserves Continue to evaluate rate performance and adjust as necessary, to protect the financial integrity of the utility system 27Trophy Club Municipal Utility District No. 1 148 of 173 November 19, 2013 Comparison of Monthly Water and Sewer Bill Residential -5,000 Gallon 43.63 44.86 50.42 53.82 57.80 59.20 72.50 85.40 101.30 23.64 20.66 25.21 26.27 39.30 30.70 37.34 41.76 57.50 19.99 24.20 25.21 27.55 18.50 28.50 35.16 43.64 43.80 - 20.00 40.00 60.00 80.00 100.00 120.00 - 20.00 40.00 60.00 80.00 100.00 120.00 Euless Fort Worth TCMUD (Current) Keller Roanoke Denton Southlake Argyle Westlake Water Sewer 28Trophy Club Municipal Utility District No. 1 149 of 173 November 19, 2013 Comparison of Monthly Water and Sewer Bill Residential -10,000 Gallon 74.55 77.62 79.88 85.17 95.70 102.85 105.15 122.81 134.80 41.83 39.91 36.30 41.92 48.45 57.60 54.99 58.01 73.00 32.72 37.71 43.58 43.25 47.25 45.25 50.16 64.80 61.80 - 20.00 40.00 60.00 80.00 100.00 120.00 140.00 160.00 - 20.00 40.00 60.00 80.00 100.00 120.00 140.00 160.00 Euless TCMUD (Current) Fort Worth Keller Denton Roanoke Southlake Argyle Westlake Water Sewer 29Trophy Club Municipal Utility District No. 1 150 of 173 November 19, 2013 Comparison of Monthly Water and Sewer Bill Residential -15,000 Gallon 97.87 107.90 110.11 122.04 124.36 130.40 134.95 157.42 168.30 55.16 62.65 64.58 63.09 58.36 74.24 68.95 74.26 88.50 42.71 45.25 45.53 58.95 66.00 56.16 66.00 83.16 79.80 - 20.00 40.00 60.00 80.00 100.00 120.00 140.00 160.00 180.00 - 20.00 40.00 60.00 80.00 100.00 120.00 140.00 160.00 180.00 TCMUD (Current) Roanoke Euless Keller Fort Worth Southlake Denton Argyle Westlake Water Sewer 30Trophy Club Municipal Utility District No. 1 151 of 173 November 19, 2013 Comparison of Monthly Water and Sewer Bill Residential -18,000 Gallon 107.27 124.21 124.70 141.81 141.95 149.96 162.25 180.31 188.40 64.56 78.68 79.45 73.44 85.79 72.56 85.00 86.23 97.80 42.71 45.53 45.25 68.37 56.16 77.40 77.25 94.08 90.60 - 20.00 40.00 60.00 80.00 100.00 120.00 140.00 160.00 180.00 200.00 - 20.00 40.00 60.00 80.00 100.00 120.00 140.00 160.00 180.00 200.00 TCMUD (Current) Euless Roanoke Keller Southlake Fort Worth Denton Argyle Westlake Water Sewer 31Trophy Club Municipal Utility District No. 1 152 of 173 November 19, 2013 Comparison of Monthly Water and Sewer Bill Residential -20,000 Gallon 113.87 133.61 135.90 149.81 154.99 165.97 172.95 195.57 201.80 71.16 88.08 90.65 93.65 80.34 81.44 95.70 94.21 104.00 42.71 45.53 45.25 56.16 74.65 84.53 77.25 101.36 97.80 - 50.00 100.00 150.00 200.00 250.00 - 50.00 100.00 150.00 200.00 250.00 TCMUD (Current) Euless Roanoke Southlake Keller Fort Worth Denton Argyle Westlake Water Sewer 32Trophy Club Municipal Utility District No. 1 153 of 173 November 19, 2013 Comparison of Monthly Water and Sewer Bill Residential -25,000 Gallon 130.37 157.11 163.90 168.90 190.09 199.70 216.30 233.72 239.20 87.66 111.58 118.65 112.74 99.74 122.45 109.26 114.16 123.40 42.71 45.53 45.25 56.16 90.35 77.25 107.04 119.56 115.80 - 50.00 100.00 150.00 200.00 250.00 300.00 - 50.00 100.00 150.00 200.00 250.00 300.00 TCMUD (Current) Euless Roanoke Southlake Keller Denton Fort Worth Argyle Westlake Water Sewer 33Trophy Club Municipal Utility District No. 1 154 of 173 November 19, 2013 Residential Water 5/8 x 3/4 inch 5,000 Gallon Comparison 20.66 23.64 25.21 26.21 26.21 26.27 28.40 30.70 37.34 39.30 41.76 57.50 - 10.00 20.00 30.00 40.00 50.00 60.00 70.00 Fort Worth Euless TCMUD (Current) TCMUD Scenario 3 TCMUD Scenario 2 Keller TCMUD Scenario 1 Denton Southlake Roanoke Argyle Westlake Water 5,000 Gallons 34Trophy Club Municipal Utility District No. 1 155 of 173 November 19, 2013 Residential Water 5/8 x 3/4 inch 10,000 Gallon Comparison 36.30 39.91 41.47 41.47 41.83 41.92 43.66 48.45 54.99 57.60 58.01 73.00 - 10.00 20.00 30.00 40.00 50.00 60.00 70.00 80.00 Fort Worth TCMUD (Current) TCMUD Scenario 3 TCMUD Scenario 2 Euless Keller TCMUD Scenario 1 Denton Southlake Roanoke Argyle Westlake Water 10,000 Gallons 35Trophy Club Municipal Utility District No. 1 156 of 173 November 19, 2013 Residential Water 5/8 x 3/4 inch 15,000 Gallon Comparison 55.16 57.17 57.17 58.36 59.36 62.65 63.09 64.58 68.95 74.24 74.26 88.50 - 10.00 20.00 30.00 40.00 50.00 60.00 70.00 80.00 90.00 100.00 TCMUD (Current) TCMUD Scenario 3 TCMUD Scenario 2 Fort Worth TCMUD Scenario 1 Roanoke Keller Euless Denton Southlake Argyle Westlake Water 15,000 Gallons 36Trophy Club Municipal Utility District No. 1 157 of 173 November 19, 2013 Residential Water 5/8 x 3/4 inch 18,000 Gallon Comparison 64.56 67.09 67.09 69.28 72.56 73.44 78.68 79.45 85.00 85.79 86.23 97.80 - 20.00 40.00 60.00 80.00 100.00 120.00 TCMUD (Current) TCMUD Scenario 2 TCMUD Scenario 3 TCMUD Scenario 1 Fort Worth Keller Euless Roanoke Denton Southlake Argyle Westlake Water 18,000 Gallons 37Trophy Club Municipal Utility District No. 1 158 of 173 November 19, 2013 Residential Water 5/8 x 3/4 inch 20,000 Gallon Comparison 71.16 74.37 74.37 76.56 80.34 81.44 88.08 90.65 93.49 94.21 95.70 104.00 - 20.00 40.00 60.00 80.00 100.00 120.00 TCMUD (Current) TCMUD Scenario 2 TCMUD Scenario 3 TCMUD Scenario 1 Keller Fort Worth Euless Roanoke Southlake Argyle Denton Westlake Water 20,000 Gallons 38Trophy Club Municipal Utility District No. 1 159 of 173 November 19, 2013 Residential Water 5/8 x 3/4 inch 25,000 Gallon Comparison 87.66 92.57 92.57 94.76 99.74 109.26 111.58 112.74 114.16 118.65 122.45 123.40 - 20.00 40.00 60.00 80.00 100.00 120.00 140.00 TCMUD (Current) TCMUD Scenario 2 TCMUD Scenario 3 TCMUD Scenario 1 Keller Fort Worth Euless Southlake Argyle Roanoke Denton Westlake Water 25,000 Gallons 39Trophy Club Municipal Utility District No. 1 160 of 173 November 19, 2013 Residential Sewer 5,000 Gallon Comparison 18.50 19.99 24.15 25.21 25.50 26.50 27.08 27.55 28.98 29.83 35.16 43.80 46.10 - 5.00 10.00 15.00 20.00 25.00 30.00 35.00 40.00 45.00 50.00 Roanoke Euless Fort Worth TCMUD (Current) TCMUD Scenario 2 Denton TCMUD Scenario 4 Keller TCMUD Scenario 1 TCMUD Scenario 3 Southlake Westlake Argyle Sewer 5,000 Gallons 40Trophy Club Municipal Utility District No. 1 161 of 173 November 19, 2013 Residential Sewer 10,000 Gallon Comparison 32.72 37.71 38.00 39.58 40.65 42.58 43.25 43.38 44.00 45.08 50.16 61.80 63.20 - 10.00 20.00 30.00 40.00 50.00 60.00 70.00 Euless TCMUD (Current) TCMUD Scenario 2 TCMUD Scenario 4 Roanoke Fort Worth Keller TCMUD Scenario 1 Denton TCMUD Scenario 3 Southlake Westlake Argyle Sewer 10,000 Gallons 41Trophy Club Municipal Utility District No. 1 162 of 173 November 19, 2013 Residential Sewer 15,000 Gallon Comparison 42.71 45.25 45.53 49.14 50.50 51.18 52.08 56.16 58.95 66.00 66.00 79.80 83.16 - 10.00 20.00 30.00 40.00 50.00 60.00 70.00 80.00 90.00 TCMUD (Current) Roanoke Euless TCMUD Scenario 1 TCMUD Scenario 2 TCMUD Scenario 3 TCMUD Scenario 4 Southlake Keller Denton Fort Worth Westlake Argyle Sewer 15,000 Gallons 42Trophy Club Municipal Utility District No. 1 163 of 173 November 19, 2013 Residential Sewer 18,000 Gallon Comparison 42.71 45.25 45.53 49.14 51.18 56.16 58.00 59.58 68.37 77.25 77.40 90.60 94.08 - 10.00 20.00 30.00 40.00 50.00 60.00 70.00 80.00 90.00 100.00 TCMUD (Current) Roanoke Euless TCMUD Scenario 1 TCMUD Scenario 3 Southlake TCMUD Scenario 2 TCMUD Scenario 4 Keller Denton Fort Worth Westlake Argyle Sewer 18,000 Gallons 43Trophy Club Municipal Utility District No. 1 164 of 173 November 19, 2013 Residential Sewer 20,000 Gallon Comparison 42.71 45.25 45.53 49.14 51.18 56.16 58.00 59.58 74.65 77.25 84.53 97.80 101.36 - 20.00 40.00 60.00 80.00 100.00 120.00 TCMUD (Current) Roanoke Euless TCMUD Scenario 1 TCMUD Scenario 3 Southlake TCMUD Scenario 2 TCMUD Scenario 4 Keller Denton Fort Worth Westlake Argyle Sewer 20,000 Gallons 44Trophy Club Municipal Utility District No. 1 165 of 173 November 19, 2013 Residential Sewer 25,000 Gallon Comparison 42.71 45.25 45.53 49.14 51.18 56.16 58.00 59.58 77.25 90.35 107.04 115.80 119.56 - 20.00 40.00 60.00 80.00 100.00 120.00 140.00 TCMUD (Current) Roanoke Euless TCMUD Scenario 1 TCMUD Scenario 3 Southlake TCMUD Scenario 2 TCMUD Scenario 4 Denton Keller Fort Worth Westlake Argyle Sewer 25,000 Gallons 45Trophy Club Municipal Utility District No. 1 166 of 173 November 19, 2013 Annual Consumption Distribution MUD Residential (FY 2012) 46 Consumption Blocks (Gallons)Number of Customers (Avg. Monthly)2,766 1,828 874 491 74 - 500 1,000 1,500 2,000 2,500 3,000 26%23%18%29%3% 938 954 383 417 74 2,766 1,828 874 491 74 0-6,000 6,001 - 17,000 17,001 - 25,000 25,001 -50,000 > 50,001 Passing Through Blocks Stopping in Blocks Trophy Club Municipal Utility District No. 1 167 of 173 November 19, 2013 Annual Consumption Distribution PID Residential (FY 2012) 47 Consumption Blocks (Gallons)Number of Customers (Avg. Monthly)760 559 307 176 32 - 100 200 300 400 500 600 700 800 23%16%38%19%4% 202 252 131 144 32 760 559 307 176 32 0-6,000 6,001 - 17,000 17,001 - 25,000 25,001 -50,000 > 50,001 Passing Through Blocks Stopping in Blocks Trophy Club Municipal Utility District No. 1 168 of 173 November 19, 2013 Annual Consumption Distribution Commercial Customers (FY 2012) 48 Consumption Blocks (Gallons)Number of Customers (Avg. Monthly)156 99 82 73 57 - 20 40 60 80 100 120 140 160 180 37%11%6%10%36% 58 17 10 16 57 156 99 82 73 57 0-6,000 6,001 - 17,000 17,001 - 25,000 25,001 -50,000 > 50,001 Passing Through Blocks Stopping in Blocks Trophy Club Municipal Utility District No. 1 169 of 173 November 19, 2013 Consumption Distribution Between 5,000 & 10,000 Gallon MUD Residential Customers 49 28% 23% 49% FY 2012 5,000 Gallons 10,000 Gallons > 10,000 Gallons 769 639 1,358 Trophy Club Municipal Utility District No. 1 170 of 173 November 19, 2013 Consumption Distribution Between 5,000 & 10,000 Gallon PID Residential Customers 50 23% 16%61% FY 2012 5,000 Gallons 10,000 Gallons > 10,000 Gallons 177 461 123 Trophy Club Municipal Utility District No. 1 171 of 173 November 19, 2013 Questions Chris Ekrut J. Stowe & Co. 1300 E. Lookout Drive, Ste. 100 Richardson, TX 75082 Phone: 972.680.2000 Email: cekrut@jstoweco.com Trophy Club Municipal Utility District No. 1 172 of 173 November 19, 2013 111/15/2013 10:09 AMLaurie SlaghtSu Mo Tu We Th Fr Sa12345678 9 10 11 12 13 1415 16 17 18 19 20 2122 23 24 25 26 27 2829 30 31December 2013Su Mo Tu We Th Fr Sa123456789101112 13 14 15 16 17 1819 20 21 22 23 24 2526 27 28 29 30 31January 2014December 2013Dec 1 - 7Dec 12345676:00pm 11:00pm Council (MUD Bd Rm)9:00am 10:00am Routine Staff Meetin4:00pm 5:00pm Police Chaplain Meeting (in6:30pm 8:30pm Parks Beautification Sub C6:30pm 8:30pm Citizens Advisory Committee (Svore Municipal Boardroom)7:00pm 10:00pm P&Z Commission (CouncilChambers)6:00pm 9:00pm TCEVA Gathering (Fire Dept Training Room)Dec 8 - 148910111213149:00am 12:00pm HCP CPR Class (Fire Dept 2:00pm 4:00pm HMAP Meeting (Fire Dept T6:30pm 10:00pm EDC B(Svore Municipal Buil9:00am 10:00am Routine Staff Meeting (PS Confere7:00pm 9:00pm Parks & Recreation Board (Svore Municipal Buil6:30pm 8:30pm Citizens Advisory Committee (Svore M7:00pm 9:00pm Trails Subcommittee Meeting (Fire Dept T MUD Holiday 12:00pm 3:00pm Holiday Party (Fire Station)Dec 15 - 21151617181920216:00pm 11:00pm Council Meeting (Svore Municipal Bo7:00pm 9:00pm Northwest Optimist Meeting (Fire Dept T9:00am 10:00am Routine Staff Meeting (PS Confere7:00pm 12:00am TCMUD No.1 Meeting (Svore Muni8:00am 6:00pm Firefighter Oral Revi12:00pm 8:00pm COURT (Svore Munic6:30pm 8:30pm Citizens Advisory Co10:00am 11:30am Special Events Committee Meeting 7:00pm 10:00pm P&Z Commission (CouncilChambers)6:00pm 7:30pm Girl Scouts (Fire Dept Training Room)Dec 22 - 28222324252627289:00am 10:00am Routine Staff Meetin4:00pm 5:00pm TBD - ZBA (Svore Municipa7:00pm 9:30pm Trophy7:00pm 9:00pm Citizen6:00pm 8:00pm Public Safety Advisory Committee (Internal)(Police Dept. Training Room)Dec 29 - Jan 4293031Jan 1, 142349:00am 10:00am Routine Staff Meeting (PS Conference Room)SundayMondayTuesdayWednesdayThursdayFridaySaturdayTrophy Club Municipal Utility District No. 1173 of 173November 19, 2013