Loading...
HomeMy WebLinkAboutMarch 20, 2012 Regular Meeting Agenda PacketTrophy Club Municipal Utility District No. 1 Trophy Club Entities Meeting Agenda 100 Municipal Drive Trophy Club, Texas 76262 Svore Municipal Building Boardroom7:00 PMTuesday, March 20, 2012 Call to order and announce a quorum. Citizen Presentation Citizens are allowed three (3) minutes to address the Board regarding an item over which the Board has policy or oversight authority as provided by Texas law, the ethics order, or other policy order. PUBLIC HEARING REGULAR SESSION REPORTS & UPDATES 1.2012-47-M1 Receive Final Report from John Zink regarding progress at the Wastewater Treatment Plant. Zink, John WWTP Final Report.pdfAttachments: 2.2012-63-M1 Discuss and Take Appropriate Action to replace aerial sewer crossing Marshall Creek in Phase 2 of the Commons. (Joe W. Ezzell, P.E.,DeltaTek Engineering) 3.2012-48-M1 Interim District Manager Report (Womack) a. Water pumped vs. billed b. Signage c. Update - Water Plant & Storage Tanks d. Security WWTP (Womack/Thomas) e. Information Services Overview (Kevin Carr) f. Update - WWTP (Ruben Perales) Pumped vs. Billed.pdf Information Services Monthly Overview - Feb 2012.pdf Attachments: 4.2012-49-M1 Receive Finance Update (Gonzales) a. Update - PID Connections b .Update - Software c. Update - Utility Billing - Online Payments March 20, 2012Trophy Club Municipal Utility District No. 1 Meeting Agenda 5.2012-50-M1 Receive Fire Update (Thomas) a. Update - February Activity b. Annual State Compliance Inspection Report fsclrhpnetscan.pdf Fire Update 3-12.pdf Attachments: 6.2012-58-M1 Receive Town Council Update. (Rose) a. Councilmember Rose to provide the Board with an update of Council Meetings, notices and relevant business. ACTION ITEMS 7.2012-53-M1 Discuss and Take Appropriate Action to approve participation with the Town to develop Hazard Mitigation Action Plan (HMAP). (Moss/Slye) Hazard Mitigation Plan ltr.pdf Hazard Mitigation Plan Information.pdf Attachments: 8.2012-51-M1 Discuss and Take Appropriate Action regarding Monthly Financial Reports for February 2012 (Gonzales) MUD Variance Report Feb2012.pdf FD Variance Report Feb2012.pdf Detailed Acct Trial Balance.pdf February 2012 Budget Summary.pdf Attachments: 9.2012-52-M1 Discuss and Take Appropriate Action to Authorize New Signature Cards with First Financial and Texpool to include Jennifer McKnight (Gonzales) 10.2012-54-M1 Discuss and Take Appropriate action to execute the Division Order between Vantage and Encana. (Carr/Gonzales) 11.2012-55-M1 Discuss and Take Appropriate Action to approve the minutes for: a. July 2011 b. November 2011 c. March 2012 7-20-11 Reg MUD Minutes.pdf 11-15-11 Reg MUD Minutes.pdf 3-2-12 Special Session MUD Minutes.pdf Attachments: REVIEW & DISCUSS 12.2012-56-M1 Future Agenda Items: 13.2012-57-M1 Set April Regular Meeting Date April Meeting Calendar.pdfAttachments: March 20, 2012Trophy Club Municipal Utility District No. 1 Meeting Agenda CONVENE INTO CLOSED SESSION *CLOSED SESSION 14.2012-61-M1 PURSUANT TO TEXAS GOVERNMENT CODE, SECTION 551.071 (2) CONSULTATION WITH ATTORNEY, THE BOARD MAY ENTER INTO A CLOSED SESSION FOR THE FOLLOWING PURPOSE: To conduct a private consultation with the District’s attorney on a matter in which the duty of the attorney to the District under the Texas Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflicts with the Texas Open Meetings Act: consultation regarding possible action to determine whether a relationship or employment exists which constitutes a disqualification of Director Nick Sanders under Subsection (a) of Texas Water Code Section 49.052. RECONVENE INTO REGULAR SESSION 15.2012-62-M1 Discuss and take appropriate action to determine whether a relationship or employment exists which constitutes a disqualification of Director Nick Sanders under Subsection (a) of Texas Water Code Section 49.052. Adjourn Notice is hereby given that a quorum of the Town Council may be in attendance at this meeting. * 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. March 20, 2012Trophy Club Municipal Utility District No. 1 Meeting Agenda CERTIFICATION) THE STATE OF TEXAS) COUNTY OF DENTON) COUNTY OF TARRANT) THIS CERTIFIES THAT ON FRIDAY, MARCH 16, 2012 AT OR BEFORE 5:00 P.M., A COPY OF THE ABOVE NOTICE OF A MEETING OF THE TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 TO BE HELD ON MARCH 20, 2012, WAS POSTED ON THE FRONT WINDOW OF THE TROPHY CLUB M.U.D. ADMINISTRATION BUILDING, 100 MUNICIPAL DRIVE, TROPHY CLUB, TEXAS, WHICH IS A PLACE CONVENIENT 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 WEBSITE AND/OR A BULLETIN BOARD AT A PLACE CONVENIENT TO THE PUBLIC IN SUCH COUNTY COURT HOUSES, PURSUANT TO SECTION 49.063 OF THE WATER CODE AND SECTION 551.054 OF THE OPEN MEETINGS ACT, CHAPTER 551 TEXAS GOVERNMENT CODE. _______________________________ LAURIE SLAGHT MUD SECRETARY THIS FACILITY IS WHEELCHAIR ACCESSIBLE AND ACCESSIBLE PARKING SPACES ARE AVAILABLE. REQUESTS FOR ACCOMMODATIONS OR INTERPRETATIVE SERVICES MUST BE MADE 48 HOURS PRIOR TO THIS MEETING. PLEASE CONTACT LAURIE SLAGHT AT 682-831-4685 OR FAX YOUR REQUEST TO 817- 491-9312. I certify that the attached notice and agenda of items to be considered by this Board was removed by me from the front window of the Svore Municipal Building, 100 Municipal Drive, Trophy Club, Texas, on the __________ day of ______________________, 2012. ________________________________, Title: ___________________________ 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12012-47-M1 Name: Status:Type:M1 Agenda Item Draft File created:In control:3/12/2012 Trophy Club Municipal Utility District No. 1 On agenda:Final action:3/20/2012 Title:Receive Final Report from John Zink regarding progress at the Wastewater Treatment Plant. Attachments:Zink, John WWTP Final Report.pdf Action ByDate Action ResultVer. Title Receive Final Report from John Zink regarding progress at the Wastewater Treatment Plant. 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12012-63-M1 Name: Status:Type:M1 Agenda Item Draft File created:In control:3/15/2012 Trophy Club Municipal Utility District No. 1 On agenda:Final action:3/20/2012 Title:Discuss and Take Appropriate Action to replace aerial sewer crossing Marshall Creek in Phase 2 of the Commons. (Joe W. Ezzell, P.E.,DeltaTek Engineering) Attachments: Action ByDate Action ResultVer. Title Discuss and Take Appropriate Action to replace aerial sewer crossing Marshall Creek in Phase 2 of the Commons. (Joe W. Ezzell, P.E.,DeltaTek Engineering) 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12012-48-M1 Name: Status:Type:M1 Agenda Item Draft File created:In control:3/12/2012 Trophy Club Municipal Utility District No. 1 On agenda:Final action:3/20/2012 Title:Interim District Manager Report (Womack) a. Water pumped vs. billed b. Signage c. Update - Water Plant & Storage Tanks d. Security WWTP (Womack/Thomas) e. Information Services Overview (Kevin Carr) f. Update - WWTP (Ruben Perales) Attachments:Pumped vs. Billed.pdf Information Services Monthly Overview - Feb 2012.pdf Action ByDate Action ResultVer. Title Interim District Manager Report (Womack) a. Water pumped vs. billed b. Signage c. Update - Water Plant & Storage Tanks d. Security WWTP (Womack/Thomas) e. Information Services Overview (Kevin Carr) f. Update - WWTP (Ruben Perales) Q:\Water Dept\Water\combined graphs (version 2).xls 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 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 0 20,000 40,000 60,000 80,000 100,000 120,000 140,000 160,000 180,000 Million Gallons Months Water Billed 2009 2010 2011 2012 0 20,000 40,000 60,000 80,000 100,000 120,000 140,000 160,000 180,000 Gallons Months Water Pumped 2009 2010 2011 2012 From:Mike Pastor To:Managers - All Cc:Laurie Slaght ; Steve Zieverink Subject:Information Services Monthly Overview - Feb 2012 Date:Friday, March 02, 2012 5:07:28 PM Information Services Monthly Overview - Feb 2012 Helpdesk Activity for Feb 2012: Town: 71 MUD: 10 Shared: 12 Total: 93 Core server and network uptime for Feb 2012: Server: 99.982% Network: 99.897% Main website stats for Feb 2012: Number of requests 370,315 Number of page requests 67,191 Video Streaming - Summary Totals for All Activity for Feb 2012: Data Transfer: 7.3 GB Hits: 231 Unique IPs: 109 Listserv member count as of Feb 2012: Parksrec - 1104 Safety - 894 Roads- 884 Jobs - 591 Volunteers - 476 Water - 470 News - 495 PZagenda - 276 Agendas - 342 Mayorsupdate - 301 Newsletter - 313 Mudagenda - 257 Arts – 114 Video - 79 PD30 - 144 Tcpstatus - 168 Postini Spam for Feb 2012: Inbound Spam Effective Catch Rate Identified Spam Messages: 131,842 Catch Rate % All Users: 99.60% Blackboard Connect for Feb 2012: Total Phone Numbers Called: 0 Successful Deliveries: 0 Unsuccessful Deliveries: 0 Total Messages Sent: 0 % Successful Delivered: 0% Thanks, >----------------------------------------- Mike Pastor IS Director Town of Trophy Club mpastor@ci.trophyclub.tx.us Attention: Please note any correspondence, such as e-mail or letters, sent to Town staff or officials may become a public record and made available for public/media review. 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12012-49-M1 Name: Status:Type:M1 Agenda Item Draft File created:In control:3/12/2012 Trophy Club Municipal Utility District No. 1 On agenda:Final action:3/20/2012 Title:Receive Finance Update (Gonzales) a. Update - PID Connections b .Update - Software c. Update - Utility Billing - Online Payments Attachments: Action ByDate Action ResultVer. Title Receive Finance Update (Gonzales) a. Update - PID Connections b .Update - Software c. Update - Utility Billing - Online Payments 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12012-50-M1 Name: Status:Type:M1 Agenda Item Draft File created:In control:3/12/2012 Trophy Club Municipal Utility District No. 1 On agenda:Final action:3/20/2012 Title:Receive Fire Update (Thomas) a. Update - February Activity b. Annual State Compliance Inspection Report Attachments:fsclrhpnetscan.pdf Fire Update 3-12.pdf Action ByDate Action ResultVer. Title Receive Fire Update (Thomas) a. Update - February Activity b. Annual State Compliance Inspection Report 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12012-58-M1 Name: Status:Type:M1 Agenda Item Draft File created:In control:3/12/2012 Trophy Club Municipal Utility District No. 1 On agenda:Final action:3/20/2012 Title:Receive Town Council Update. (Rose) a. Councilmember Rose to provide the Board with an update of Council Meetings, notices and relevant business. Attachments: Action ByDate Action ResultVer. Title Receive Town Council Update. (Rose) a. Councilmember Rose to provide the Board with an update of Council Meetings, notices and relevant business. 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12012-53-M1 Name: Status:Type:M1 Agenda Item Draft File created:In control:3/12/2012 Trophy Club Municipal Utility District No. 1 On agenda:Final action:3/20/2012 Title:Discuss and Take Appropriate Action to approve participation with the Town to develop Hazard Mitigation Action Plan (HMAP). (Moss/Slye) Attachments:Hazard Mitigation Plan ltr.pdf Hazard Mitigation Plan Information.pdf Action ByDate Action ResultVer. Title Discuss and Take Appropriate Action to approve participation with the Town to develop Hazard Mitigation Action Plan (HMAP). (Moss/Slye) 100 Municipal Drive, Trophy Club, Texas 76262 682.831.4685 / Fax: 817.491.9312 TROPHY CLUB MUNICIPAL DISTRICT No. 1 March 19, 2012 Mr. Gregory Pekar Mitigation Section Administrator Texas Division of Emergency Management P.O. Box 4087 Austin, TX 78773-0001 RE: Voluntary Participation in the Trophy Club Hazard Mitigation Action Plan Dear Mr. Pekar: The Trophy Club Municipal Utility District #1 will participate in the development of the Hazard Mitigation Action Plan with the Town of Trophy Club. Trophy Club MUD #1 is providing this letter in support of the Town of Trophy Club’s Hazard Mitigation Grant Program (HMGP) application. Trophy Club Municipal Utility District No. 1 is submitting this application voluntarily with the intent to voluntarily participate in the preparation of the Trophy Club Hazard Mitigation Action Plan. If you have any questions or need additional information, please contact the Town’s consultant Stephanie Griffin of Freese and Nichols, Inc. at (817) 735-7353 or myself at 682-831-4685. Sincerely, Jennifer McKnight District Manager Trophy Club Municipal Utility District No. 1 jmcknight@ci.trophyclub.tx.us (682) 831-4685 ATTACHMENT A COST SHARE CERTIFICATION ● TOWN OF TROPHY CLUB 100 Municipal Drive, Trophy Club, TX 76262 ● Phone 682-831-4600 ● Fax 817-491-9312 ● www.trophyclub.org Attachment A COST SHARE CERTIFICATION I certify that the Town of Trophy Club is able to meet the 25% cost share, or more, of the Preparation of Hazard Mitigation Action Plan project. I understand that the Hazard Mitigation Grant Program can provide 75% of the cost to prepare said plan up to a maximum of $50,000 and $5,000 for each additional participant, with a maximum of $100,000 federal share. The Town of Trophy Club plans to develop the multi-jurisdictional Hazard Mitigation Action Plan with the Trophy Club Municipality District No. 1. The Town of Trophy Club is committing to the completion of the project and is prepared to cover expenses that exceed the grant contribution. ______________________________ ________________ Eric Cannon, Director of Finance Date ATTACHMENT B SCOPE OF WORK 1 Town of Trophy Club Preparation of Hazard Mitigation Action Plan (HMAP) February 8, 2012 Task 1. Establishment of HMAP Steering Committee FNI will meet one time with Town staff to discuss the project approach, steering committee and project goals, as well as the necessary data and reports for consideration in developing the HMAP. FNI will develop a list of recommended representatives that the Town should consider in assembling the steering committee. FNI will develop draft goals for the steering committee’s consideration. FNI will email information to Town staff for review and comment. Because the Trophy Club Municipal Utility District No. 1 (MUD 1) is a secondary participant in this grant, the MUD will participate on the steering committee to develop the HMAP. Task 2. Risk Assessment: Hazard Identification and Profiling FNI will review existing local reports provided by Town for inclusion in the HMAP. FNI will review existing information in the Denton County HMAP for consideration in the Town’s HMAP. FNI will summarize their findings and include select information in the HMAP. FNI will evaluate all potential natural hazards in the area. FNI will prepare one FEMA hazard profile for each hazard, which will be included as an attachment in the HMAP. FNI will meet one time with the steering committee to finalize HMAP goals, present findings in existing data, and discuss potential natural hazards. FNI will meet with Town staff one hour prior to the steering committee meeting. The steering committee will select final natural hazards for inclusion in the HMAP. FNI will present essential information on the HMAP development at one Town Council meeting, including the natural hazards selected by the steering committee. Public comments will be taken at this Council meeting. Task 3. Risk Assessment: Asset Identification FNI will review available local data provided by Town staff on the Town’s critical facilities and infrastructure (assets). FNI will consider available regional data provided in the Denton County HMAP. FNI will develop an inventory list of the Town’s critical facilities and assets. FNI will email inventory list of potential facilities and assets to Town staff for review and approval. FNI will analyze potential facilities and assets that could be impacted by each of the selected natural hazards. FNI will email risk assessment to Town staff for review and comment. Task 4. Develop a Mitigation Strategy FNI will communicate via email and telephone with the steering committee to develop mitigation actions to accomplish the HMAP goals. FNI will analyze and prioritize each mitigation strategy. FNI will determine benefit-costs and implementation and maintenance costs for each mitigation strategy. FNI will develop a schedule for the Town to implement the mitigation actions. FNI will recommend a responsible person for each mitigation action, as well as determining potential funding for each action. FNI will meet with the steering committee to finalize the risk assessment and mitigation actions. FNI will meet with Town staff for one hour prior to the steering committee meeting. 2 Task 5. Complete Draft Hazard Mitigation Action Plan FNI will prepare the Hazard Mitigation Action Plan based on FEMA guidance documents. FNI will seek input on the draft HMAP from the steering committee and will incorporate their input as appropriate. FNI will provide an electronic copy of the draft HMAP to the Town to be posted on the Town’s web site for public comment. FNI will revise the HMAP to incorporate public comments, as appropriate. FNI will present the risk assessment and recommended mitigation actions at one Town Council meeting. Public comments will be taken at this Council meeting. Task 6. TDEM and FEMA Review FNI will submit draft HMAP to TDEM for review and comment. FNI will address TDEM comments and obtain direction from steering committee, as appropriate. FNI will submit the revised draft HMAP to TDEM who will forward it to FEMA. FNI will address FEMA comments. FNI will obtain input from steering committee, as appropriate. FNI will submit second draft of HMAP to TDEM for review and comment. FNI will address TDEM comments and obtain direction from steering committee, as appropriate. FNI will submit the second draft of the HMAP to the TDEM who will forward it to FEMA. FNI will address FEMA comments and obtain input from the steering committee, if needed. FNI will submit the third draft of the HMAP to the TDEM for review and comment. FNI will address TDEM comments and obtain steering committee input, if needed. FNI will forward the third draft of the HMAP to the TDEM who will forward it to FEMA. This contract assumes that FEMA will approve the third draft of the Town’s HMAP. If FEMA requires additional revisions to the draft HMAP, FNI will request additional funding from the Town to cover the additional effort. Task 7. Town Council Adopts Final HMAP FNI will finalize the HMAP upon receiving FEMA-approval. FNI will present the final document to the Town Council for Council adoption at one Council meeting. ATTACHMENT C COST BREAKDOWN ATTACHMENT C COST BREAKDOWN The cost estimate for the preparation of the multi-jurisdictional Hazard Mitigation Action Plan for Trophy Club is based on time and materials. The Town of Trophy Club understands that the maximum award the HMGP grant will provide for the development of a Hazard Mitigation Action Plan is 75% of the project cost up to $50,000 and $5,000 for each additional participant, with a maximum of $100,000 federal share. The proposed project cost for Trophy Club is $103,249. Trophy Club MUD No. 1 provides water and sewer services to the Town, which are vital components in developing a complete Hazard Mitigation Action Plan assessing natural hazards for the Town of Trophy Club. The Town of Trophy Club anticipates the grant to pay $55,000, considering the Trophy Club Municipal District No. 1 as a secondary participant. The Town will provide the remaining balance of $48,249 to complete the plan from its Storm Water Utility. Task Labor Expenses Total FEMA Share Local Share 1 Establishment of HMAP Steering Committee $2,936 $91 $3,027 $2,270 $757 2 Risk Assessment: Hazard Identification and Profiling $20,839 $303 $21,141 $15,856 $5,285 3 Risk Assessment: Asset Identification $14,444 $59 $14,503 $10,877 $3,626 4 Develop Mitigation Strategies $13,288 $129 $13,416 $10,062 $3,354 5 Develop Draft Hazard Mitigation Plan $26,270 $331 $26,601 $19,951 $6,650 6 TDEM and FEMA Approval $18,278 $700 $18,978 $14,233 $4,745 7 Town Council Adopts FEMA- Approved Plan $5,265 $319 $5,583 $4,188 $1,395 TOTAL $101,320 $1,930 $103,249 $77,437 $25,812 FEMA Maximum $55,000 Local Match $48,249 ATTACHMENT D PROPOSED PROJECT TIMELINE ATTACHMENT D PROPOSED PROJECT TIMELINE July 2012 • Task 1 – Hold kickoff meeting with Town staff • Task 1 – Establish HMAP Steering Committee • Task 2 – Develop one FEMA hazard profile for each natural hazard • Task 2 – Obtain and review Town data, reports, and Denton County HMAP information for potential inclusion in the plan October 2012 • Task 2 – Meet with Steering Committee to finalize HMAP goals, present findings in existing data, discuss and finalize natural hazard for inclusion in the HMAP. • Task 2 – Present essential information on the HMAP development, including selected natural hazards. Public comments to be received at this time. • Task 3 – Identify the Town’s critical facilities and infrastructures (assets) considering regional data provided in the Denton County HMAP. Develop inventory list of critical facilities and assets January 2013 • Task 3 – Analyze potential facilities and assets that could be impacted by each of the selected natural hazards. • Task 4 – Develop mitigation actions, analyze and prioritize each strategy, considering benefit- cost, implementation, and maintenance costs for each. • Task 4 – Develop schedule of implementing mitigation actions • Task 4 – Meet with Steering Committee to finalize risk assessment and mitigation strategies April 2013 • Task 5 – Prepare the draft Hazard Mitigation Action Plan for natural hazards • Task 5 – Post an electronic copy of the draft HMAP to the Town’s website open to public comment. Revise HMAP to incorporate public comments, as appropriate • Task 5 – Present the draft plan at a Town Council Meeting and obtain public input July 2013 • Task 6 – Send draft plan to TDEM for review and comment • Task 6 – Address TDEM comments obtaining direction from steering committee. • Task 6 – Submit revised draft HMAP to TDEM who will forward it to FEMA October 2013 • Task 6 – Address FEMA comments and prepare second draft of plan • Task 6 – Submit second draft HMAP to TDEM for review and comment • Task 6 – Address TDEM comments on second draft • Task 6 – Submit second draft of the HMAP to TDEM who will forward it to FEMA January 2014 • Task 6 – Address FEMA comments and prepare third draft of plan • Task 6 – Send third draft to TDEM for review and comment • Task 6 – Address TDEM comments on third draft and TDEM sends document to FEMA April 2014 • Task 6 – Obtain FEMA approval of plan • Task 7 – Finalize HMAP upon receiving FEMA-approval • Task 7 – Present final document to Town Council for Council’s adoption ATTACHMENT E ENVIRONMENTAL JUSTICE STATEMENT ● TOWN OF TROPHY CLUB 100 Municipal Drive, Trophy Club, TX 76262 ● Phone 682-831-4600 ● Fax 817-491-9312 ● www.trophyclub.org ATTACHMENT E ENVIRONMENTAL JUSTICE STATEMENT 1. Are there concentrations of low income or minority populations in or near the HMGP project? No. The proposed development of a Hazard Mitigation Action Plan for the Town of Trophy Club will cover the town-limits. As such, no concentrations of low income or minority populations located within the proposed study area will be targeted in this study. 2. Will the HMGP project result in a disproportionately high and adverse effect on low income or minority populations? No. The proposed project will not result in a disproportionately high and adverse effect on low income or minority populations. 3. What action(s) will be taken to insure achievement of environmental justice for low income and minority populations? The plan will study the entire Town-limits. No particular area will be singled out. ______________________________________ ___________________________ Connie White, Mayor Date ATTACHMENT F VOLUNTARY PARTICIPATION LETTER ● TOWN OF TROPHY CLUB 100 Municipal Drive, Trophy Club, TX 76262 ● Phone 682-831-4600 ● Fax 817-491-9312 ● www.trophyclub.org February 27, 2012 Mr. Gregory Pekar Mitigation Section Administrator Texas Division of Emergency Management P.O. Box 4087 Austin, TX 78773-0001 RE: Voluntary Participation in the Trophy Club Hazard Mitigation Action Plan Dear Mr. Pekar: The Town of Trophy Club is submitting this Hazard Mitigation Grant Program (HMGP) application to assist with funding the development of a Hazard Mitigation Action Plan which the Town intends to prepare. The Town of Trophy Club is submitting this application voluntarily with intent to voluntarily participate in the preparation of the Town’s Hazard Mitigation Action Plan. If you have any questions or need additional information, please contact the Town’s consultant Stephanie Griffin of Freese and Nichols, Inc. at (817) 735-7353 or myself at (682) 831-4600. Sincerely, Stephen Seidel, Assistant Town Manager ATTACHMENT G MAINTENANCE AGREEMENT ● TOWN OF TROPHY CLUB 100 Municipal Drive, Trophy Club, TX 76262 ● Phone 682-831-4600 ● Fax 817-491-9312 ● www.trophyclub.org Attachment G MAINTENANCE AGREEMENT The Town of Trophy Club will be fully responsible for the maintenance and upkeep of the proposed Hazard Mitigation Action Plan for the Town of Trophy Club. The Community Development Department within the Town of Trophy Club will be the responsible department for maintaining the plan. _______________________________________ _____________________ Stephen Seidel, Assistant Town Manager Date ATTACHMENT H FIRMETTE WITH PROJECT PLOTTED Town Limits Town Limits Town Limits Town Limits 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12012-51-M1 Name: Status:Type:M1 Agenda Item Draft File created:In control:3/12/2012 Trophy Club Municipal Utility District No. 1 On agenda:Final action:3/20/2012 Title:Discuss and Take Appropriate Action regarding Monthly Financial Reports for February 2012 (Gonzales) Attachments:MUD Variance Report Feb2012.pdf FD Variance Report Feb2012.pdf Detailed Acct Trial Balance.pdf February 2012 Budget Summary.pdf Action ByDate Action ResultVer. Title Discuss and Take Appropriate Action regarding Monthly Financial Reports for February 2012 (Gonzales) BUDGET VARIANCE REPORT FUND:135 - MUD 1 O&M FINANCIALS MONTH:February 2012 REVENUE VARIANCE:34% EXPENSE VARIANCE:51.67% NOTE: ACCOUNT DESCRIPTION TOTAL BUDGET CURRENT MONTH YTD TOTAL YTD %VARIANCE EXPLANATION REVENUE 135-40000 Property Taxes (97,495) (9,057) (94,192)97%Majority of Taxes collected by January 31st 135-40002 Property Taxes/Delinquent (451)$ (29)$ 641$ -142%A tax refund caused a debit balance. 135-47035 Plumbing Inspections (1,200)$ (100)$ (850)$ 71%Inspections on new construction 135-47045 Sewer Inspections (4,500)$ (300)$ (2,550)$ 57%Inspections on new construction 135-47405 Out of District Sewer (11,807)$ (53,283)$ (56,863)$ 482%There was a misread on the Southlake meter. Will be credited in March. 135-48005 Utility Fees (338,880)$ (80,500)$ (265,280)$ 78%New Housing starts in the PID.118 connections this fiscal year 135-49075 Oversize Meter Reimbursement (64,000)$ (6,218)$ (49,238)$ 77%Charged for all meters 1" and above WATER 135-69005-010 Capital Expenses 888,432$ 342,860$ 837,607$ 94%Meters and Ground Storage expansion 135-69035-010 Vehicles 27,000$ 29,839$ 30,214$ 112%Ford F250 Water truck WASTEWATER 135-50030-020 Social Security Taxes 8,597$ 851$ 5,134$ 60%Severence check 135-50035-020 Medicare Taxes 2,011$ 199$ 1,201$ 60%Severence check COLLECTIONS 135-60016-021 Communications/Mobiles 2,796$ 204$ 1,545$ 55%Monthly Mobiles MANAGER'S OFFICE 135-50005-027 Salaries & Wages 236,831$ 88,020$ 141,417$ 60%Robert Scott Contract 135-50010-027 Overtime 1,000$ 22$ 1,011$ 101%Front desk overtime 135-50016-027 Longevity 1,845$ 1,860$ 3,705$ 201%Robert Scott Contract 135-50020-027 Retirement 33,471$ 12,424$ 20,740$ 62%Robert Scott Contract 135-50030-027 Social Security Taxes 14,860$ 5,517$ 8,845$ 60%Robert Scott Contract 135-50035-027 Medicare Taxes 3,475$ 1,290$ 2,106$ 61%Robert Scott Contract 135-60035-027 Postage 1,000$ 44$ 570$ 57%Postage from meter &overnight documents 135-60270-027 4th of July Celebration 10,000$ 10,000$ 10,000$ 100%Paid to Town 135-65105-027 Printing 515$ 68$ 463$ 90%Business cards for District Mgr. INFORMATION SYSTEMS 135-60005-033 Telephone 6,540$ 763$ 3,772$ 58%Monthly Telephone 135-65055-033 Hardware 83,238$ 777$ 60,913$ 73%Misc hardware purchases UTILITY BILLING 135-60040-038 Service Charges & fees 18,000$ 1,956$ 13,108$ 73%Paid annually in November 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 8.3% for expenses. All variances over $1000 will be addressed. BUDGET VARIANCE REPORT FUND:135 - MUD 1 O&M FINANCIALS MONTH:February 2012 REVENUE VARIANCE:34% EXPENSE VARIANCE:51.67% NOTE: ACCOUNT DESCRIPTION TOTAL BUDGET CURRENT MONTH YTD TOTAL YTD %VARIANCE EXPLANATION Explanation provided for all accounts with a Year-To-Date percentage (YTD%)less than the Revenue Variance and greater than or equal to the Expense Variance.The Revenue and Expense Variance is calculated on a straight-line method (Financials Month x 8.3%),less 8.3% for revenues and plus 8.3% for expenses. All variances over $1000 will be addressed. 135-65085-038 Office Supplies 700$ 513$ 658$ 94%New credit card machine NON-DEPARTMENTAL 135-55045-039 Legal 55,000$ 3,662$ 36,848$ 67%Legal 135-55065-039 Tax Admin Fees 3,629$ 18$ 2,470$ 68%Mailing of tax statements BUDGET VARIANCE REPORT FUND:122 - Fire O&M FINANCIALS MONTH:February 2012 REVENUE VARIANCE:34% EXPENSE VARIANCE:51.67% NOTE: ACCOUNT DESCRIPTION TOTAL BUDGET CURRENT MONTH YTD TOTAL YTD %VARIANCE EXPLANATION FIRE REVENUE 122-40001 Assessment- Emergency Svcs (193,233)$ (17,445)$ (183,863)$ 95%Majority of Taxes collected by January 31 122-40010 Property Taxes/MUD Fire (1,076,976)$ (100,050)$ (1,040,489)$ 97%Majority of Taxes collected by January 31 122-40011 Property Taxes/Fire-Delinquent (5,603)$ (246)$ 5,271$ -94%A tax refund caused a debit balance. 122-40011 Property Taxes Assessments P&I (725)$ (73)$ (774)$ -107%P&I for delinquent taxes 122-42014 Fire Permits/Sprinkler (2,000)$ (1,200)$ (5,600)$ 280%Permit for Fire Line-Sq Ft > 6,000 122-43400 Fire Inspections (500)$ (225)$ (1,050)$ 210%Inspection of Fire Line 122-49900 Miscellaneous Income (5,000)$ (2,022)$ (8,397)$ 168%Miscellaneous permits,TCWC grant $247 FIRE EXPENSES 122-50017-045 Certification 4,073$ 495$ 2,559$ 63%Monthly Cert pay for Firefighters 122-60030-045 Rent And/Or Usage 308,000$ 308,000$ 308,000$ 100%Annual Rent payment to Debt Service 122-65085-045 Office Supplies 329$ 4$ 633$ 192%Office supplies for station and Admin office 122-69035-045 Vehicles 13,709$ 1,871$ 13,261$ 97%Lighting for Chief Vehicle 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. All variances over $1000 will be addressed. . glpdatb2 rgonzale Trophy Club Entities Page 1 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 2/2012 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 424 02/01/2012 Property Taxes (166,118.37) (2,037.05) (168,155.42) GL 429 02/02/2012 Property Taxes (9,699.27) (177,854.69) GL 431 02/03/2012 Property Taxes (1,025.91) (178,880.60) GL 545 02/06/2012 Property Taxes (1,359.45) (180,240.05) GL 546 02/07/2012 Property Taxes (1,311.86) (181,551.91) GL 548 02/09/2012 Property Taxes (49.27) (181,601.18) GL 549 02/10/2012 Property Taxes (1,282.08) (182,883.26) GL 552 02/17/2012 Property Taxes (117.14) (183,000.40) GL 557 02/27/2012 Property Taxes (809.45) (183,809.85) GL 602 02/29/2012 Property Taxes (53.31) (183,863.16) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (17,744.79) (183,863.16) ** (193,233.00) Budgeted (9,369.84) Remaining 95 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent (4,856.69) .00 (4,856.69) _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: .00 (4,856.69) ** (4,900.00) Budgeted (43.31) Remaining 99 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 424 02/01/2012 Property Taxes (940,438.37) (4,114.59) (944,552.96) GL 429 02/02/2012 Property Taxes (33,208.71) (977,761.67) GL 431 02/03/2012 Property Taxes (20,952.37) (998,714.04) GL 545 02/06/2012 Property Taxes (14,825.10) (1,013,539.14) GL 546 02/07/2012 Property Taxes (10,329.09) (1,023,868.23) GL 547 02/08/2012 Property Taxes (1,086.11) (1,024,954.34) GL 548 02/09/2012 Property Taxes (1,597.50) (1,026,551.84) GL 549 02/10/2012 Property Taxes (6,949.78) (1,033,501.62) GL 550 02/14/2012 Property Taxes (436.92) (1,033,938.54) GL 551 02/16/2012 Property Taxes (735.09) (1,034,673.63) GL 553 02/21/2012 Property Taxes (1,048.24) (1,035,721.87) GL 554 02/22/2012 Property Taxes (432.50) (1,036,154.37) GL 555 02/23/2012 Property Taxes (162.52) (1,036,316.89) GL 557 02/27/2012 Property Taxes (282.32) (1,036,599.21) GL 601 02/28/2012 Property Taxes (2,642.32) (1,039,241.53) GL 602 02/29/2012 Property Taxes (1,247.02) (1,040,488.55) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (100,050.18) (1,040,488.55) ** (1,076,976.00) Budgeted (36,487.45) Remaining 97 % Used . glpdatb2 rgonzale Trophy Club Entities Page 2 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 2/2012 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 429 02/02/2012 Property Taxes 5,517.15 27.31 5,544.46 GL 546 02/07/2012 Property Taxes (.14) 5,544.32 GL 547 02/08/2012 Property Taxes (69.54) 5,474.78 GL 556 02/24/2012 Property Taxes (203.70) 5,271.08 GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (246.07) 5,271.08 ** (5,603.00) Budgeted (10,874.08) Remaining -94 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I 546 02/07/2012 Property Taxes (701.00) (4.06) (705.06) GL 548 02/09/2012 Property Taxes (3.45) (708.51) GL 549 02/10/2012 Property Taxes 3.45 (705.06) GL 552 02/17/2012 Property Taxes (8.20) (713.26) GL 557 02/27/2012 Property Taxes (56.66) (769.92) GL 602 02/29/2012 Property Taxes (3.73) (773.65) GL _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: (72.65) (773.65) ** (725.00) Budgeted 48.65 Remaining 107 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 424 02/01/2012 Property Taxes (486.36) (6.36) (492.72) GL 546 02/07/2012 Property Taxes (7.64) (500.36) GL 547 02/08/2012 Property Taxes (92.61) (592.97) GL 548 02/09/2012 Property Taxes (98.04) (691.01) GL 549 02/10/2012 Property Taxes (35.49) (726.50) GL 550 02/14/2012 Property Taxes (30.57) (757.07) GL 551 02/16/2012 Property Taxes (51.45) (808.52) GL 553 02/21/2012 Property Taxes (73.37) (881.89) GL 554 02/22/2012 Property Taxes (30.28) (912.17) GL 555 02/23/2012 Property Taxes (11.37) (923.54) GL 556 02/24/2012 Property Taxes (50.92) (974.46) GL 557 02/27/2012 Property Taxes (19.06) (993.52) GL 601 02/28/2012 Property Taxes (184.96) (1,178.48) GL 602 02/29/2012 Property Taxes (87.29) (1,265.77) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (779.41) (1,265.77) ** (7,500.00) Budgeted (6,234.23) Remaining 17 % Used Account: 122-42014-000-000 Fire Permits/Sprinkler . glpdatb2 rgonzale Trophy Club Entities Page 3 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 621 02/01/2012 Permits 2/1/12 (4,400.00) (400.00) (4,800.00) GL 625 02/15/2012 Permits 2/15/12 (800.00) (5,600.00) GL _______________ Account: 122-42014-000-000 Fire Permits/Sprinkler Totals: (1,200.00) (5,600.00) ** (2,000.00) Budgeted 3,600.00 Remaining 280 % Used Account: 122-43400-000-000 Fire Inspections 621 02/01/2012 Permits 2/1/12 (825.00) (75.00) (900.00) GL 625 02/15/2012 Permits 2/15/12 (150.00) (1,050.00) GL _______________ Account: 122-43400-000-000 Fire Inspections Totals: (225.00) (1,050.00) ** (500.00) Budgeted 550.00 Remaining 210 % Used Account: 122-43415-000-000 Denton/Tarrant Cty Pledge-Fire (10,000.00) .00 (10,000.00) _______________ Account: 122-43415-000-000 Denton/Tarrant Cty Pledge-Fire Totals: .00 (10,000.00) ** (10,000.00) Budgeted .00 Remaining 100 % Used Account: 122-43599-000-000 Misc Fire Revenue .00 .00 _______________ Account: 122-43599-000-000 Misc Fire Revenue Totals: .00 .00 ** (1,124.00) Budgeted (1,124.00) Remaining 0 % Used Account: 122-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 122-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (4,373.00) Budgeted (4,373.00) Remaining 0 % Used Account: 122-49900-000-000 Miscellaneous Income 621 02/01/2012 Permits 2/1/12 (6,375.00) (525.00) (6,900.00) GL 622 02/08/2012 Permits 2/8/12 (100.00) (7,000.00) GL 624 02/13/2012 Permits 2/13/12 (100.00) (7,100.00) GL 625 02/15/2012 Permits 2/15/12 (1,050.00) (8,150.00) GL 610 02/27/2012 TCWC Philanthropy Fire Grant (246.95) (8,396.95) GL . glpdatb2 rgonzale Trophy Club Entities Page 4 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 2/2012 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 Totals: (2,021.95) (8,396.95) ** (5,000.00) Budgeted 3,396.95 Remaining 168 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,251,023.69) ** (1,311,934.00) Budgeted (60,910.31) Remaining 95 % Used . glpdatb2 rgonzale Trophy Club Entities Page 5 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2012 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 400 02/03/2012 PAYROLL 2/3/12 Salaries & Wages 122,077.57 16,023.75 138,101.32 PR 474 02/17/2012 PAYROLL 2/17/12 Salaries & Wages 16,921.38 155,022.70 PR _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 32,945.13 155,022.70 ** 425,748.00 Budgeted 270,725.30 Remaining 36 % Used Account: 122-50010-045-000 Overtime 474 02/17/2012 PAYROLL 2/17/12 Overtime 16,972.33 2,850.32 19,822.65 PR _______________ Account: 122-50010-045-000 Overtime Totals: 2,850.32 19,822.65 ** 42,000.00 Budgeted 22,177.35 Remaining 47 % Used Account: 122-50011-045-000 DPS Holiday Pay 13,773.02 .00 13,773.02 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 13,773.02 ** 12,133.00 Budgeted (1,640.02) Remaining 114 % Used Account: 122-50016-045-000 Longevity 3,714.46 .00 3,714.46 _______________ Account: 122-50016-045-000 Longevity Totals: .00 3,714.46 ** 3,647.00 Budgeted (67.46) Remaining 102 % Used Account: 122-50017-045-000 Certification 474 02/17/2012 PAYROLL 2/17/12 Certification 2,063.80 494.70 2,558.50 PR _______________ Account: 122-50017-045-000 Certification Totals: 494.70 2,558.50 ** 4,073.00 Budgeted 1,514.50 Remaining 63 % Used Account: 122-50020-045-000 Retirement 400 02/03/2012 PAYROLL 2/3/12 Retirement 22,707.32 2,020.89 24,728.21 PR 474 02/17/2012 PAYROLL 2/17/12 Retirement 2,609.45 27,337.66 PR _______________ Account: 122-50020-045-000 Retirement Totals: 4,630.34 27,337.66 ** 68,264.00 Budgeted 40,926.34 Remaining 40 % Used . glpdatb2 rgonzale Trophy Club Entities Page 6 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50026-045-000 Medical Insurance 400 02/03/2012 PAYROLL 2/3/12 Medical Insurance 13,358.29 1,663.54 15,021.83 PR 474 02/17/2012 PAYROLL 2/17/12 Medical Insurance 1,677.31 16,699.14 PR _______________ Account: 122-50026-045-000 Medical Insurance Totals: 3,340.85 16,699.14 ** 53,184.00 Budgeted 36,484.86 Remaining 31 % Used Account: 122-50027-045-000 Dental Insurance 400 02/03/2012 PAYROLL 2/3/12 Dental Insurance 1,167.38 145.25 1,312.63 PR 474 02/17/2012 PAYROLL 2/17/12 Dental Insurance 146.72 1,459.35 PR _______________ Account: 122-50027-045-000 Dental Insurance Totals: 291.97 1,459.35 ** 3,288.00 Budgeted 1,828.65 Remaining 44 % Used Account: 122-50028-045-000 Vision Insurance 400 02/03/2012 PAYROLL 2/3/12 Vision Insurance 263.70 32.85 296.55 PR 474 02/17/2012 PAYROLL 2/17/12 Vision Insurance 33.12 329.67 PR _______________ Account: 122-50028-045-000 Vision Insurance Totals: 65.97 329.67 ** 857.00 Budgeted 527.33 Remaining 38 % Used Account: 122-50029-045-000 Life Insurance & Other .00 .00 _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: .00 .00 ** 2,740.00 Budgeted 2,740.00 Remaining 0 % Used Account: 122-50030-045-000 Social Security Taxes 400 02/03/2012 PAYROLL 2/3/12 Social Security Taxes 9,584.33 900.67 10,485.00 PR 474 02/17/2012 PAYROLL 2/17/12 Social Security Taxes 1,163.00 11,648.00 PR _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 2,063.67 11,648.00 ** 30,231.00 Budgeted 18,583.00 Remaining 39 % Used Account: 122-50035-045-000 Medicare Taxes 400 02/03/2012 PAYROLL 2/3/12 Medicare Taxes 2,241.60 210.64 2,452.24 PR 474 02/17/2012 PAYROLL 2/17/12 Medicare Taxes 272.02 2,724.26 PR . glpdatb2 rgonzale Trophy Club Entities Page 7 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 482.66 2,724.26 ** 7,070.00 Budgeted 4,345.74 Remaining 39 % Used Account: 122-50040-045-000 Unemployment Taxes 400 02/03/2012 PAYROLL 2/3/12 Unemployment Taxes 354.08 109.16 463.24 PR 474 02/17/2012 PAYROLL 2/17/12 Unemployment Taxes 94.47 557.71 PR _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 203.63 557.71 ** 1,476.00 Budgeted 918.29 Remaining 38 % Used Account: 122-50045-045-000 Workman's Compensation 8,309.50 .00 8,309.50 _______________ Account: 122-50045-045-000 Workman's Compensation Totals: .00 8,309.50 ** 8,793.00 Budgeted 483.50 Remaining 95 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test 52.45 .00 52.45 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 52.45 ** 675.00 Budgeted 622.55 Remaining 8 % Used Account: 122-55080-045-000 Maintenance & Repairs 529 02/27/2012 Feb A/P Single Air test/Bauer Unit 984.21 244.00 1,228.21 AUGUST INDUSTRIES, INC 31265 AP _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 244.00 1,228.21 ** 9,562.00 Budgeted 8,333.79 Remaining 13 % Used Account: 122-55090-045-000 Vehicle Maintenance 594 02/29/2012 Feb A/P Vehicle Maintenance 256.21 1,544.01 1,800.22 INDUSTRIAL POWER TRUCK & EQUIP 31292 AP _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: 1,544.01 1,800.22 ** 14,850.00 Budgeted 13,049.78 Remaining 12 % Used Account: 122-55095-045-000 Equipment Maintenance 477 02/16/2012 Feb A/P Equipment Maint 1,149.94 2,987.24 4,137.18 MUNICIPAL EMERGENCY SERVICES 31257 AP . glpdatb2 rgonzale Trophy Club Entities Page 8 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-55095-045-000 Equipment Maintenance Totals: 2,987.24 4,137.18 ** 9,808.00 Budgeted 5,670.82 Remaining 42 % Used Account: 122-55100-045-000 Building Maintenance 436 02/09/2012 Feb A/P Invoices Quarterly pest control 2,635.03 140.00 2,775.03 GANN'S PEST CONTROL 31217 AP 604 02/10/2012 Firefighters Cable (120.00) 2,655.03 GL _______________ Account: 122-55100-045-000 Building Maintenance Totals: 20.00 2,655.03 ** 11,000.00 Budgeted 8,344.97 Remaining 24 % Used Account: 122-55110-045-000 Maintenance-Radios .00 .00 _______________ Account: 122-55110-045-000 Maintenance-Radios Totals: .00 .00 ** 1,103.00 Budgeted 1,103.00 Remaining 0 % Used Account: 122-55160-045-000 Professional Outside Services .00 .00 _______________ Account: 122-55160-045-000 Professional Outside Services Totals: .00 .00 ** 20,000.00 Budgeted 20,000.00 Remaining 0 % Used Account: 122-60005-045-000 Telephone 594 02/29/2012 Feb A/P Feb PCard-Zieverink 20.95 1.33 22.28 BANK OF AMERICA 31281 AP _______________ Account: 122-60005-045-000 Telephone Totals: 1.33 22.28 ** 106.00 Budgeted 83.72 Remaining 21 % Used Account: 122-60010-045-000 Communications/Pagers/Mobiles 594 02/29/2012 Feb A/P 1/23-2/22 Mobiles 825.71 192.46 1,018.17 VERIZON WIRELESS 31316 AP _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 192.46 1,018.17 ** 4,411.00 Budgeted 3,392.83 Remaining 23 % Used Account: 122-60020-045-000 Electricity/Gas 529 02/27/2012 Feb A/P Electricity 1/17-2/15 3,888.96 748.08 4,637.04 HUDSON ENERGY 31272 AP . glpdatb2 rgonzale Trophy Club Entities Page 9 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 529 02/27/2012 Feb A/P Gas @ FD 1/20-2/20 3,888.96 265.99 4,903.03 ATMOS ENERGY 31264 AP _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 1,014.07 4,903.03 ** 18,270.00 Budgeted 13,366.97 Remaining 27 % Used Account: 122-60025-045-000 Water 1,384.50 .00 1,384.50 _______________ Account: 122-60025-045-000 Water Totals: .00 1,384.50 ** 3,289.00 Budgeted 1,904.50 Remaining 42 % Used Account: 122-60030-045-000 Rent And/Or Usage 618 02/29/2012 FD Rent Transfer to M1 I&S 308,000.00 308,000.00 GL _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: 308,000.00 308,000.00 ** 308,000.00 Budgeted .00 Remaining 100 % Used Account: 122-60035-045-000 Postage 12.35 .00 12.35 _______________ Account: 122-60035-045-000 Postage Totals: .00 12.35 ** 97.00 Budgeted 84.65 Remaining 13 % Used Account: 122-60055-045-000 Insurance 8,078.00 .00 8,078.00 _______________ Account: 122-60055-045-000 Insurance Totals: .00 8,078.00 ** 20,974.00 Budgeted 12,896.00 Remaining 39 % Used Account: 122-60066-045-000 Publications/Books/Subscrips .00 .00 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 .00 ** 401.00 Budgeted 401.00 Remaining 0 % Used Account: 122-60070-045-000 Dues & Memberships 6,130.34 .00 6,130.34 . glpdatb2 rgonzale Trophy Club Entities Page 10 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-60070-045-000 Dues & Memberships Totals: .00 6,130.34 ** 8,560.00 Budgeted 2,429.66 Remaining 72 % Used Account: 122-60075-045-000 Meetings 594 02/29/2012 Feb A/P Chamber luncheon, N Sanders, 22.00 22.00 NORTHWEST METROPORT CHAMBER 31302 AP _______________ Account: 122-60075-045-000 Meetings Totals: 22.00 22.00 ** .00 Budgeted (22.00) Remaining 0 % Used Account: 122-60080-045-000 Schools & Training 1,112.47 .00 1,112.47 _______________ Account: 122-60080-045-000 Schools & Training Totals: .00 1,112.47 ** 6,946.00 Budgeted 5,833.53 Remaining 16 % Used Account: 122-60096-045-000 Emergency Management 1,000.00 .00 1,000.00 _______________ Account: 122-60096-045-000 Emergency Management Totals: .00 1,000.00 ** 1,000.00 Budgeted .00 Remaining 100 % Used Account: 122-60100-045-000 Travel & per diem 1,632.43 .00 1,632.43 _______________ Account: 122-60100-045-000 Travel & per diem Totals: .00 1,632.43 ** 6,788.00 Budgeted 5,155.57 Remaining 24 % Used Account: 122-60110-045-000 Physicals/Testing .00 .00 _______________ Account: 122-60110-045-000 Physicals/Testing Totals: .00 .00 ** 1,918.00 Budgeted 1,918.00 Remaining 0 % Used Account: 122-60125-045-000 Advertising .00 .00 . glpdatb2 rgonzale Trophy Club Entities Page 11 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-60125-045-000 Advertising Totals: .00 .00 ** 156.00 Budgeted 156.00 Remaining 0 % Used Account: 122-60160-045-000 Programs & Special Projects 594 02/29/2012 Feb A/P Promotional items for Safety F 1,112.16 721.95 1,834.11 ARTCRAFT & FOREMOST INC 31280 AP _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: 721.95 1,834.11 ** 4,162.00 Budgeted 2,327.89 Remaining 44 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 594 02/29/2012 Feb A/P Office supplies 361.00 24.58 385.58 OFFICE DEPOT, INC 31303 AP _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: 24.58 385.58 ** 1,900.00 Budgeted 1,514.42 Remaining 20 % Used Account: 122-60195-045-000 Flags & Repair 477 02/16/2012 Feb A/P Flag repair 402.50 150.00 552.50 SYMONDS FLAGS & POLES 31260 AP _______________ Account: 122-60195-045-000 Flags & Repair Totals: 150.00 552.50 ** 2,543.00 Budgeted 1,990.50 Remaining 22 % Used Account: 122-60245-045-000 Miscellaneous Expense 541.42 .00 541.42 _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: .00 541.42 ** 1,237.00 Budgeted 695.58 Remaining 44 % Used Account: 122-65005-045-000 Fuel & Lube 598 02/29/2012 Feb Gas Log 1,354.29 77.87 1,432.16 GL _______________ Account: 122-65005-045-000 Fuel & Lube Totals: 77.87 1,432.16 ** 17,414.00 Budgeted 15,981.84 Remaining 8 % Used Account: 122-65010-045-000 Uniforms 529 02/27/2012 Feb A/P Uniforms 406.50 651.10 1,057.60 RON MONTGOMERY & ASSOC INC 31276 AP . glpdatb2 rgonzale Trophy Club Entities Page 12 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-65010-045-000 Uniforms Totals: 651.10 1,057.60 ** 4,357.00 Budgeted 3,299.40 Remaining 24 % Used Account: 122-65015-045-000 Protective Clothing 83.50 .00 83.50 _______________ Account: 122-65015-045-000 Protective Clothing Totals: .00 83.50 ** 7,600.00 Budgeted 7,516.50 Remaining 1 % Used Account: 122-65030-045-000 Chemicals .00 .00 _______________ Account: 122-65030-045-000 Chemicals Totals: .00 .00 ** 1,545.00 Budgeted 1,545.00 Remaining 0 % Used Account: 122-65035-045-000 Small Tools 469.96 .00 469.96 _______________ Account: 122-65035-045-000 Small Tools Totals: .00 469.96 ** 8,371.00 Budgeted 7,901.04 Remaining 6 % Used Account: 122-65085-045-000 Office Supplies 529 02/27/2012 Feb A/P Office Supplies 629.04 3.60 632.64 OFFICE DEPOT, INC 31275 AP _______________ Account: 122-65085-045-000 Office Supplies Totals: 3.60 632.64 ** 329.00 Budgeted (303.64) Remaining 192 % Used Account: 122-65095-045-000 Maintenance Supplies 811.74 .00 811.74 _______________ Account: 122-65095-045-000 Maintenance Supplies Totals: .00 811.74 ** 2,785.00 Budgeted 1,973.26 Remaining 29 % Used Account: 122-65105-045-000 Printing 24.77 .00 24.77 . glpdatb2 rgonzale Trophy Club Entities Page 13 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-65105-045-000 Printing Totals: .00 24.77 ** 106.00 Budgeted 81.23 Remaining 23 % Used Account: 122-69006-045-000 Grant Match .00 .00 _______________ Account: 122-69006-045-000 Grant Match Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 122-69035-045-000 Vehicles 529 02/27/2012 Feb A/P Lightbar for FD new pickup tru 11,389.78 1,870.74 13,260.52 WILDFIRE TRUCK & EQUIPMENT 31279 AP _______________ Account: 122-69035-045-000 Vehicles Totals: 1,870.74 13,260.52 ** 13,709.00 Budgeted 448.48 Remaining 97 % Used Account: 122-69050-045-000 Radios .00 .00 _______________ Account: 122-69050-045-000 Radios Totals: .00 .00 ** 2,500.00 Budgeted 2,500.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 ** 41,890.00 Budgeted 41,890.00 Remaining 0 % Used Account: 122-69251-045-000 Engine 681 Payment 588 02/28/2012 Bond/CO Interest payments FIRE TRUCK SER 2007/AMEGY BK 4,351.65 4,351.65 GL _______________ Account: 122-69251-045-000 Engine 681 Payment Totals: 4,351.65 4,351.65 ** 73,203.00 Budgeted 68,851.35 Remaining 6 % Used Account: 122-69255-045-000 Airpacks .00 .00 . glpdatb2 rgonzale Trophy Club Entities Page 14 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-69255-045-000 Airpacks Totals: .00 .00 ** 13,865.00 Budgeted 13,865.00 Remaining 0 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 632,583.43 ** 1,311,934.00 Budgeted 679,350.57 Remaining 48 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (618,440.26) .00 Budgeted 618,440.26 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club Entities Page 15 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2012 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 424 02/01/2012 Property Taxes (85,134.43) (372.48) (85,506.91) GL 429 02/02/2012 Property Taxes (3,006.26) (88,513.17) GL 431 02/03/2012 Property Taxes (1,896.74) (90,409.91) GL 545 02/06/2012 Property Taxes (1,342.06) (91,751.97) GL 546 02/07/2012 Property Taxes (935.05) (92,687.02) GL 547 02/08/2012 Property Taxes (98.32) (92,785.34) GL 548 02/09/2012 Property Taxes (144.62) (92,929.96) GL 549 02/10/2012 Property Taxes (629.14) (93,559.10) GL 550 02/14/2012 Property Taxes (39.55) (93,598.65) GL 551 02/16/2012 Property Taxes (66.54) (93,665.19) GL 553 02/21/2012 Property Taxes (94.89) (93,760.08) GL 554 02/22/2012 Property Taxes (39.15) (93,799.23) GL 555 02/23/2012 Property Taxes (14.71) (93,813.94) GL 557 02/27/2012 Property Taxes (25.56) (93,839.50) GL 601 02/28/2012 Property Taxes (239.20) (94,078.70) GL 602 02/29/2012 Property Taxes (112.89) (94,191.59) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (9,057.16) (94,191.59) ** (97,495.00) Budgeted (3,303.41) Remaining 97 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 429 02/02/2012 Property Taxes 670.57 2.20 672.77 GL 546 02/07/2012 Property Taxes (.01) 672.76 GL 547 02/08/2012 Property Taxes (15.00) 657.76 GL 556 02/24/2012 Property Taxes (16.39) 641.37 GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (29.20) 641.37 ** (451.00) Budgeted (1,092.37) Remaining ########## Account: 135-40015-000-000 Property Taxes/P & I 424 02/01/2012 Property Taxes 281.42 (.57) 280.85 GL 429 02/02/2012 Property Taxes (25.43) 255.42 GL 431 02/03/2012 Property Taxes (1.77) 253.65 GL 545 02/06/2012 Property Taxes (19.92) 233.73 GL 546 02/07/2012 Property Taxes (.70) 233.03 GL 547 02/08/2012 Property Taxes (16.18) 216.85 GL 547 02/08/2012 Property Taxes (18.23) 198.62 GL 548 02/09/2012 Property Taxes (8.87) 189.75 GL 549 02/10/2012 Property Taxes (3.21) 186.54 GL 550 02/14/2012 Property Taxes (2.77) 183.77 GL . glpdatb2 rgonzale Trophy Club Entities Page 16 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 551 02/16/2012 Property Taxes 281.42 (4.66) 179.11 GL 553 02/21/2012 Property Taxes (6.65) 172.46 GL 554 02/22/2012 Property Taxes (2.74) 169.72 GL 555 02/23/2012 Property Taxes (1.03) 168.69 GL 556 02/24/2012 Property Taxes (4.10) 164.59 GL 557 02/27/2012 Property Taxes (1.72) 162.87 GL 557 02/27/2012 Property Taxes (.35) 162.52 GL 601 02/28/2012 Property Taxes (16.74) 145.78 GL 602 02/29/2012 Property Taxes (7.90) 137.88 GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (143.54) 137.88 ** (1,334.00) Budgeted (1,471.88) Remaining -10 % Used Account: 135-43215-000-000 Insurance Settlement (3,999.00) .00 (3,999.00) _______________ Account: 135-43215-000-000 Insurance Settlement Totals: .00 (3,999.00) ** .00 Budgeted 3,999.00 Remaining 0 % Used Account: 135-47000-000-000 Water 567 02/29/2012 UB 02/29/2012 Billing UB 20120229-20120229 User: (389,773.66) (86,555.01) (476,328.67) UB _______________ Account: 135-47000-000-000 Water Totals: (86,555.01) (476,328.67) ** (1,990,800.00) Budgeted (1,514,471.33) Remaining 24 % Used Account: 135-47005-000-000 Sewer 567 02/29/2012 UB 02/29/2012 Billing UB 20120229-20120229 User: (289,335.76) (72,355.82) (361,691.58) UB _______________ Account: 135-47005-000-000 Sewer Totals: (72,355.82) (361,691.58) ** (1,325,000.00) Budgeted (963,308.42) Remaining 27 % Used Account: 135-47010-000-000 Commercial Water 567 02/29/2012 UB 02/29/2012 Billing UB 20120229-20120229 User: (205,154.28) (32,513.98) (237,668.26) UB _______________ Account: 135-47010-000-000 Commercial Water Totals: (32,513.98) (237,668.26) ** (825,000.00) Budgeted (587,331.74) Remaining 29 % Used Account: 135-47015-000-000 Commercial Sewer . glpdatb2 rgonzale Trophy Club Entities Page 17 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 567 02/29/2012 UB 02/29/2012 Billing UB 20120229-20120229 User: (89,361.94) (20,476.55) (109,838.49) UB _______________ Account: 135-47015-000-000 Commercial Sewer Totals: (20,476.55) (109,838.49) ** (360,000.00) Budgeted (250,161.51) Remaining 31 % Used Account: 135-47020-000-000 Standby 567 02/29/2012 UB 02/29/2012 Billing UB 20120229-20120229 User: (251.00) (60.00) (311.00) UB _______________ Account: 135-47020-000-000 Standby Totals: (60.00) (311.00) ** (775.00) Budgeted (464.00) Remaining 40 % Used Account: 135-47025-000-000 Penalties 503 02/20/2012 UB 02/20/2012 Adjustments UB 20120220-20120220 User: (20,868.97) 85.01 (20,783.96) UB 510 02/21/2012 UB 02/21/2012 Penalties UB 20120221-20120221 User: (2,901.50) (23,685.46) UB 535 02/27/2012 UB 02/27/2012 Adjustments UB 20120227-20120227 User: 35.41 (23,650.05) UB 564 02/29/2012 UB 02/29/2012 Adjustments UB 20120229-20120229 User: 43.95 (23,606.10) UB 567 02/29/2012 UB 02/29/2012 Billing UB 20120229-20120229 User: (104.92) (23,711.02) UB _______________ Account: 135-47025-000-000 Penalties Totals: (2,842.05) (23,711.02) ** (50,500.00) Budgeted (26,788.98) Remaining 47 % Used Account: 135-47030-000-000 Service Charges 432 02/08/2012 UB 02/08/2012 Adjustments UB 20120208-20120208 User: (5,986.38) (675.00) (6,661.38) UB 527 02/23/2012 UB 2/23/12 ADJUSTMENTS UB 20120223-20120223 User: (25.00) (6,686.38) UB 567 02/29/2012 UB 02/29/2012 Billing UB 20120229-20120229 User: (3.00) (6,689.38) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (703.00) (6,689.38) ** (17,500.00) Budgeted (10,810.62) Remaining 38 % Used Account: 135-47035-000-000 Plumbing Inspections 622 02/08/2012 Permits 2/8/12 (750.00) (50.00) (800.00) GL 624 02/13/2012 Permits 2/13/12 (50.00) (850.00) GL _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (100.00) (850.00) ** (1,200.00) Budgeted (350.00) Remaining 71 % Used Account: 135-47045-000-000 Sewer Inspections 622 02/08/2012 Permits 2/8/12 (2,250.00) (150.00) (2,400.00) GL . glpdatb2 rgonzale Trophy Club Entities Page 18 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 624 02/13/2012 Permits 2/13/12 (2,250.00) (150.00) (2,550.00) GL _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (300.00) (2,550.00) ** (4,500.00) Budgeted (1,950.00) Remaining 57 % Used Account: 135-47070-000-000 TCCC Effluent Charges (8,212.62) .00 (8,212.62) _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: .00 (8,212.62) ** (57,500.00) Budgeted (49,287.38) Remaining 14 % Used Account: 135-47270-000-000 Fire Line .00 .00 _______________ Account: 135-47270-000-000 Fire Line Totals: .00 .00 ** (5,000.00) Budgeted (5,000.00) Remaining 0 % Used Account: 135-47400-000-000 Water-Out of Dist/Port Meters 535 02/27/2012 UB 02/27/2012 Adjustments UB 20120227-20120227 User: (15,222.56) (300.00) (15,522.56) UB 567 02/29/2012 UB 02/29/2012 Billing UB 20120229-20120229 User: (539.54) (16,062.10) UB _______________ Account: 135-47400-000-000 Water-Out of Dist/Port Meters Totals: (839.54) (16,062.10) ** (41,595.00) Budgeted (25,532.90) Remaining 39 % Used Account: 135-47405-000-000 Out of District Sewer 567 02/29/2012 UB 02/29/2012 Billing UB 20120229-20120229 User: (3,579.80) (53,282.71) (56,862.51) UB _______________ Account: 135-47405-000-000 Out of District Sewer Totals: (53,282.71) (56,862.51) ** (11,807.00) Budgeted 45,055.51 Remaining 482 % Used Account: 135-47410-000-000 Out of Dist/Portable Penalties (28.31) .00 (28.31) _______________ Account: 135-47410-000-000 Out of Dist/Portable Penalties Totals: .00 (28.31) ** (300.00) Budgeted (271.69) Remaining 9 % Used Account: 135-47600-000-000 PID #1 Water . glpdatb2 rgonzale Trophy Club Entities Page 19 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 567 02/29/2012 UB 02/29/2012 Billing UB 20120229-20120229 User: (126,350.88) (23,973.64) (150,324.52) UB _______________ Account: 135-47600-000-000 PID #1 Water Totals: (23,973.64) (150,324.52) ** (425,000.00) Budgeted (274,675.48) Remaining 35 % Used Account: 135-47605-000-000 PID #1 Sewer 567 02/29/2012 UB 02/29/2012 Billing UB 20120229-20120229 User: (69,443.11) (16,483.76) (85,926.87) UB _______________ Account: 135-47605-000-000 PID #1 Sewer Totals: (16,483.76) (85,926.87) ** (185,000.00) Budgeted (99,073.13) Remaining 46 % Used Account: 135-48005-000-000 Utility Fees 621 02/01/2012 Permits 2/1/12 (265,280.00) (9,200.00) (274,480.00) GL 623 02/09/2012 Permits 2/9/12 (9,200.00) (283,680.00) GL 625 02/15/2012 Permits 2/15/12 (6,900.00) (290,580.00) GL 626 02/20/2012 Permits 2/20/12 (2,300.00) (292,880.00) GL 628 02/22/2012 Permits 2/22/12 (4,600.00) (297,480.00) GL 629 02/23/2012 Permits 2/23/12 (4,600.00) (302,080.00) GL 630 02/28/2012 Permits 2/28/12 (6,900.00) (308,980.00) GL 631 02/29/2012 Permits 2/29/12 (6,900.00) (315,880.00) GL _______________ Account: 135-48005-000-000 Utility Fees Totals: (50,600.00) (315,880.00) ** (338,880.00) Budgeted (23,000.00) Remaining 93 % Used Account: 135-49005-000-000 Loan Proceeds (1,100,000.00) .00 (1,100,000.00) _______________ Account: 135-49005-000-000 Loan Proceeds Totals: .00 (1,100,000.00) ** .00 Budgeted 1,100,000.00 Remaining 0 % Used Account: 135-49010-000-000 Interest Income 616 02/29/2012 Feb Bank Interest (1,438.96) (356.18) (1,795.14) GL 616 02/29/2012 Feb Bank Interest (6.00) (1,801.14) GL 633 02/29/2012 Feb Bank Interest (74.51) (1,875.65) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (436.69) (1,875.65) ** (4,500.00) Budgeted (2,624.35) Remaining 42 % Used Account: 135-49016-000-000 Cell Tower Revenue . glpdatb2 rgonzale Trophy Club Entities Page 20 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 606 02/10/2012 AT&T Cell Tower/Feb (3,388.00) (847.00) (4,235.00) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (847.00) (4,235.00) ** (10,164.00) Budgeted (5,929.00) Remaining 42 % Used Account: 135-49018-000-000 Building Rent Income 609 02/27/2012 Town Maint Barn Rent/Feb (2,333.32) (583.33) (2,916.65) GL _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (2,916.65) ** (7,000.00) Budgeted (4,083.35) Remaining 42 % Used Account: 135-49030-000-000 Vending Revenue (32.50) .00 (32.50) _______________ Account: 135-49030-000-000 Vending Revenue Totals: .00 (32.50) ** (600.00) Budgeted (567.50) Remaining 5 % Used Account: 135-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (265,707.00) Budgeted (265,707.00) Remaining 0 % Used Account: 135-49036-000-000 GASB Reserves .00 .00 _______________ Account: 135-49036-000-000 GASB Reserves Totals: .00 .00 ** (26,911.00) Budgeted (26,911.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 621 02/01/2012 Permits 2/1/12 (43,020.07) (1,168.00) (44,188.07) GL 622 02/08/2012 Permits 2/8/12 (292.00) (44,480.07) GL 623 02/09/2012 Permits 2/9/12 (1,168.00) (45,648.07) GL 624 02/13/2012 Permits 2/13/12 (292.00) (45,940.07) GL 625 02/15/2012 Permits 2/15/12 (876.00) (46,816.07) GL 626 02/20/2012 Permits 2/20/12 (292.00) (47,108.07) GL 628 02/22/2012 Permits 2/22/12 (876.00) (47,984.07) GL 629 02/23/2012 Permits 2/23/12 (584.00) (48,568.07) GL . glpdatb2 rgonzale Trophy Club Entities Page 21 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 630 02/28/2012 Permits 2/28/12 (43,020.07) (876.00) (49,444.07) GL 594 02/29/2012 Feb A/P Reimb impact and oversize mete 1,082.27 (48,361.80) HYDRA HOTELS LLC DBA HAMPTON 31291 AP 631 02/29/2012 Permits 2/29/12 (876.00) (49,237.80) GL _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (6,217.73) (49,237.80) ** (64,000.00) Budgeted (14,762.20) Remaining 77 % Used Account: 135-49900-000-000 Miscellaneous Income (2,703.11) .00 (2,703.11) _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: .00 (2,703.11) ** (10,000.00) Budgeted (7,296.89) Remaining 27 % Used Account: 135-49905-000-000 Gas Well Revenue (123.00) .00 (123.00) _______________ Account: 135-49905-000-000 Gas Well Revenue Totals: .00 (123.00) ** (800.00) Budgeted (677.00) Remaining 15 % Used Department Totals: ------------------------------------------------------------------------------------------------ (3,111,470.38) ** (6,129,319.00) Budgeted (3,017,848.62) Remaining 51 % Used . glpdatb2 rgonzale Trophy Club Entities Page 22 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2012 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 400 02/03/2012 PAYROLL 2/3/12 Salaries & Wages 47,180.64 6,337.33 53,517.97 PR 474 02/17/2012 PAYROLL 2/17/12 Salaries & Wages 6,290.73 59,808.70 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 12,628.06 59,808.70 ** 199,759.00 Budgeted 139,950.30 Remaining 30 % Used Account: 135-50010-010-000 Overtime 400 02/03/2012 PAYROLL 2/3/12 Overtime 4,874.94 237.56 5,112.50 PR 474 02/17/2012 PAYROLL 2/17/12 Overtime 820.90 5,933.40 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,058.46 5,933.40 ** 13,250.00 Budgeted 7,316.60 Remaining 45 % Used Account: 135-50016-010-000 Longevity 2,620.00 .00 2,620.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 2,620.00 ** 2,620.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 474 02/17/2012 PAYROLL 2/17/12 Certification 600.00 150.00 750.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 150.00 750.00 ** 1,800.00 Budgeted 1,050.00 Remaining 42 % Used Account: 135-50020-010-000 Retirement 400 02/03/2012 PAYROLL 2/3/12 Retirement 8,254.64 908.65 9,163.29 PR 474 02/17/2012 PAYROLL 2/17/12 Retirement 1,003.56 10,166.85 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,912.21 10,166.85 ** 25,508.00 Budgeted 15,341.15 Remaining 40 % Used Account: 135-50026-010-000 Medical Insurance 400 02/03/2012 PAYROLL 2/3/12 Medical Insurance 7,535.76 941.97 8,477.73 PR 474 02/17/2012 PAYROLL 2/17/12 Medical Insurance 941.97 9,419.70 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 1,883.94 9,419.70 ** 22,607.00 Budgeted 13,187.30 Remaining 42 % Used . glpdatb2 rgonzale Trophy Club Entities Page 23 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-010-000 Dental Insurance 400 02/03/2012 PAYROLL 2/3/12 Dental Insurance 537.12 67.14 604.26 PR 474 02/17/2012 PAYROLL 2/17/12 Dental Insurance 67.14 671.40 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 134.28 671.40 ** 2,169.00 Budgeted 1,497.60 Remaining 31 % Used Account: 135-50028-010-000 Vision Insurance 400 02/03/2012 PAYROLL 2/3/12 Vision Insurance 127.04 15.88 142.92 PR 474 02/17/2012 PAYROLL 2/17/12 Vision Insurance 15.88 158.80 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 31.76 158.80 ** 576.00 Budgeted 417.20 Remaining 28 % Used Account: 135-50029-010-000 Life Insurance & Other .00 .00 _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: .00 .00 ** 1,161.00 Budgeted 1,161.00 Remaining 0 % Used Account: 135-50030-010-000 Social Security Taxes 400 02/03/2012 PAYROLL 2/3/12 Social Security Taxes 3,422.97 381.00 3,803.97 PR 474 02/17/2012 PAYROLL 2/17/12 Social Security Taxes 423.61 4,227.58 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 804.61 4,227.58 ** 13,481.00 Budgeted 9,253.42 Remaining 31 % Used Account: 135-50035-010-000 Medicare Taxes 400 02/03/2012 PAYROLL 2/3/12 Medicare Taxes 800.53 89.11 889.64 PR 474 02/17/2012 PAYROLL 2/17/12 Medicare Taxes 99.06 988.70 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 188.17 988.70 ** 3,153.00 Budgeted 2,164.30 Remaining 31 % Used Account: 135-50040-010-000 Unemployment Taxes 400 02/03/2012 PAYROLL 2/3/12 Unemployment Taxes 116.33 52.60 168.93 PR 474 02/17/2012 PAYROLL 2/17/12 Unemployment Taxes 55.42 224.35 PR . glpdatb2 rgonzale Trophy Club Entities Page 24 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 108.02 224.35 ** 945.00 Budgeted 720.65 Remaining 24 % Used Account: 135-50045-010-000 Workman's Compensation 5,581.00 .00 5,581.00 _______________ Account: 135-50045-010-000 Workman's Compensation Totals: .00 5,581.00 ** 5,581.00 Budgeted .00 Remaining 100 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-50070-010-000 Employee Relations 47.59 .00 47.59 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 47.59 ** 350.00 Budgeted 302.41 Remaining 14 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-55070-010-000 Independent Labor .00 .00 _______________ Account: 135-55070-010-000 Independent Labor Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 9,264.71 .00 9,264.71 . glpdatb2 rgonzale Trophy Club Entities Page 25 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2012 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-010-000 Maintenance & Repairs Totals: .00 9,264.71 ** 29,500.00 Budgeted 20,235.29 Remaining 31 % Used Account: 135-55090-010-000 Vehicle Maintenance 1,889.77 .00 1,889.77 _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: .00 1,889.77 ** 3,380.00 Budgeted 1,490.23 Remaining 56 % Used Account: 135-55100-010-000 Building Maint & Supplies 471.85 .00 471.85 _______________ Account: 135-55100-010-000 Building Maint & Supplies Totals: .00 471.85 ** 750.00 Budgeted 278.15 Remaining 63 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 450.00 .00 450.00 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 450.00 ** 2,900.00 Budgeted 2,450.00 Remaining 16 % Used Account: 135-55135-010-000 Lab Analysis 740.00 .00 740.00 _______________ Account: 135-55135-010-000 Lab Analysis Totals: .00 740.00 ** 4,500.00 Budgeted 3,760.00 Remaining 16 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 594 02/29/2012 Feb A/P 1/23-2/22 Mobiles 643.48 185.18 828.66 VERIZON WIRELESS 31316 AP _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: 185.18 828.66 ** 1,599.00 Budgeted 770.34 Remaining 52 % Used Account: 135-60020-010-000 Electricity 477 02/16/2012 Feb A/P Electricity 1/5-2/2 20,535.87 233.52 20,769.39 TRI COUNTY ELECTRIC 31262 AP 529 02/27/2012 Feb A/P Electricity 12/14-2/15 179.09 20,948.48 HUDSON ENERGY 31272 AP . glpdatb2 rgonzale Trophy Club Entities Page 26 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 529 02/27/2012 Feb A/P Electricity 12/14-2/15 20,535.87 234.93 21,183.41 HUDSON ENERGY 31272 AP 529 02/27/2012 Feb A/P Electricity 12/14-2/15 436.91 21,620.32 HUDSON ENERGY 31272 AP 529 02/27/2012 Feb A/P Electricity 12/14-2/15 693.23 22,313.55 HUDSON ENERGY 31272 AP 529 02/27/2012 Feb A/P Electricity 12/14-2/15 54.64 22,368.19 HUDSON ENERGY 31272 AP _______________ Account: 135-60020-010-000 Electricity Totals: 1,832.32 22,368.19 ** 162,000.00 Budgeted 139,631.81 Remaining 14 % Used Account: 135-60035-010-000 Postage 6.51 .00 6.51 _______________ Account: 135-60035-010-000 Postage Totals: .00 6.51 ** 500.00 Budgeted 493.49 Remaining 1 % Used Account: 135-60050-010-000 Bad Debt Expense .00 .00 _______________ Account: 135-60050-010-000 Bad Debt Expense Totals: .00 .00 ** 4,200.00 Budgeted 4,200.00 Remaining 0 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 50.00 Budgeted 50.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 761.00 .00 761.00 _______________ Account: 135-60080-010-000 Schools & Training Totals: .00 761.00 ** 2,800.00 Budgeted 2,039.00 Remaining 27 % Used . glpdatb2 rgonzale Trophy Club Entities Page 27 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60090-010-000 Safety Program .00 .00 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60100-010-000 Travel & per diem 400 02/03/2012 PAYROLL 2/3/12 Travel & per diem 576.68 24.43 601.11 PR 474 02/17/2012 PAYROLL 2/17/12 Travel & per diem 76.04 677.15 PR _______________ Account: 135-60100-010-000 Travel & per diem Totals: 100.47 677.15 ** 3,200.00 Budgeted 2,522.85 Remaining 21 % Used Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60135-010-000 Annual Permit Fee 7,965.75 .00 7,965.75 _______________ Account: 135-60135-010-000 Annual Permit Fee Totals: .00 7,965.75 ** 6,600.00 Budgeted (1,365.75) Remaining 121 % Used Account: 135-60150-010-000 Bulk Water 594 02/29/2012 Feb A/P January Bulk Water 368,810.76 93,641.40 462,452.16 CITY OF FORT WORTH 31282 AP _______________ Account: 135-60150-010-000 Bulk Water Totals: 93,641.40 462,452.16 ** 1,720,000.00 Budgeted 1,257,547.84 Remaining 27 % Used Account: 135-60245-010-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-60280-010-000 Property Maintenance . glpdatb2 rgonzale Trophy Club Entities Page 28 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2012 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-60280-010-000 Property Maintenance Totals: .00 .00 ** 4,200.00 Budgeted 4,200.00 Remaining 0 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 299.99 .00 299.99 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 299.99 ** 1,500.00 Budgeted 1,200.01 Remaining 20 % Used Account: 135-65005-010-000 Fuel & Lube 598 02/29/2012 Feb Gas Log 4,655.01 300.48 4,955.49 GL _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 300.48 4,955.49 ** 15,216.00 Budgeted 10,260.51 Remaining 33 % Used Account: 135-65010-010-000 Uniforms 1,024.15 .00 1,024.15 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 1,024.15 ** 3,690.00 Budgeted 2,665.85 Remaining 28 % Used Account: 135-65030-010-000 Chemicals 1,066.47 .00 1,066.47 _______________ Account: 135-65030-010-000 Chemicals Totals: .00 1,066.47 ** 6,200.00 Budgeted 5,133.53 Remaining 17 % Used Account: 135-65035-010-000 Small Tools 68.00 .00 68.00 . glpdatb2 rgonzale Trophy Club Entities Page 29 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65035-010-000 Small Tools Totals: .00 68.00 ** 2,500.00 Budgeted 2,432.00 Remaining 3 % Used Account: 135-65040-010-000 Safety Equipment .00 .00 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-65050-010-000 Meter Expense 63,619.07 .00 63,619.07 _______________ Account: 135-65050-010-000 Meter Expense Totals: .00 63,619.07 ** 85,000.00 Budgeted 21,380.93 Remaining 75 % Used Account: 135-65055-010-000 Hardware .00 .00 _______________ Account: 135-65055-010-000 Hardware Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-65095-010-000 Maintenance Supplies 594 02/29/2012 Feb A/P Feb Purchases 10,150.08 15.99 10,166.07 COSTCO WHOLESALE 31283 AP 594 02/29/2012 Feb A/P Feb Purchases 56.50 10,222.57 COSTCO WHOLESALE 31283 AP _______________ Account: 135-65095-010-000 Maintenance Supplies Totals: 72.49 10,222.57 ** 32,000.00 Budgeted 21,777.43 Remaining 32 % Used Account: 135-65100-010-000 Copies .00 .00 _______________ Account: 135-65100-010-000 Copies Totals: .00 .00 ** 50.00 Budgeted 50.00 Remaining 0 % Used Account: 135-65105-010-000 Printing 58.50 .00 58.50 . glpdatb2 rgonzale Trophy Club Entities Page 30 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65105-010-000 Printing Totals: .00 58.50 ** 150.00 Budgeted 91.50 Remaining 39 % Used Account: 135-69005-010-000 Capital Expenses 529 02/27/2012 Feb A/P Ground Storage Expansion Note/ 837,607.19 3,818.95 841,426.14 FIRST FINANCIAL BANK 31270 AP 599 02/27/2012 Retainage/Phoenix App 5 3,707.00 845,133.14 GL 594 02/29/2012 Feb A/P Ground Storage Expansion App 5 70,433.00 915,566.14 PHOENIX FABRICATORS & ERECTORS 31304 AP _______________ Account: 135-69005-010-000 Capital Expenses Totals: 77,958.95 915,566.14 ** 888,432.00 Budgeted (27,134.14) Remaining 103 % Used Account: 135-69035-010-000 Vehicles 436 02/09/2012 Feb A/P Invoices 2012 Ford F250 VIN 1FT7W2A66CE 375.00 29,838.69 30,213.69 PHILPOTT MOTORS, LTD 31231 AP 529 02/27/2012 Feb A/P Lights/Adrian's truck 1,219.50 31,433.19 WILDFIRE TRUCK & EQUIPMENT 31279 AP 636 02/27/2012 Recode Wildfire inv/Ford F150 (1,219.50) 30,213.69 GL _______________ Account: 135-69035-010-000 Vehicles Totals: 29,838.69 30,213.69 ** 27,000.00 Budgeted (3,213.69) Remaining 112 % 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 ** 24,000.00 Budgeted 24,000.00 Remaining 0 % Used Account: 135-69281-010-000 Capital Repair-Ground Storage 100,816.54 .00 100,816.54 _______________ Account: 135-69281-010-000 Capital Repair-Ground Storage Totals: .00 100,816.54 ** 124,771.00 Budgeted 23,954.46 Remaining 81 % Used . glpdatb2 rgonzale Trophy Club Entities Page 31 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69295-010-000 Unexpected Maintenance .00 .00 _______________ Account: 135-69295-010-000 Unexpected Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-69305-010-000 Capital Leases .00 .00 _______________ Account: 135-69305-010-000 Capital Leases Totals: .00 .00 ** 11,490.00 Budgeted 11,490.00 Remaining 0 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 1,736,384.43 ** 3,501,238.00 Budgeted 1,764,853.57 Remaining 50 % Used . glpdatb2 rgonzale Trophy Club Entities Page 32 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2012 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 400 02/03/2012 PAYROLL 2/3/12 Salaries & Wages 63,796.03 7,058.51 70,854.54 PR 474 02/17/2012 PAYROLL 2/17/12 Salaries & Wages 7,058.51 77,913.05 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 14,117.02 77,913.05 ** 182,147.00 Budgeted 104,233.95 Remaining 43 % Used Account: 135-50010-020-000 Overtime 400 02/03/2012 PAYROLL 2/3/12 Overtime 3,963.07 560.17 4,523.24 PR 474 02/17/2012 PAYROLL 2/17/12 Overtime 457.68 4,980.92 PR _______________ Account: 135-50010-020-000 Overtime Totals: 1,017.85 4,980.92 ** 10,166.00 Budgeted 5,185.08 Remaining 49 % Used Account: 135-50016-020-000 Longevity 3,975.00 .00 3,975.00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 3,975.00 ** 3,976.00 Budgeted 1.00 Remaining 100 % Used Account: 135-50017-020-000 Certification 474 02/17/2012 PAYROLL 2/17/12 Certification 575.00 125.00 700.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 125.00 700.00 ** 2,400.00 Budgeted 1,700.00 Remaining 29 % Used Account: 135-50020-020-000 Retirement 400 02/03/2012 PAYROLL 2/3/12 Retirement 10,697.03 1,052.90 11,749.93 PR 474 02/17/2012 PAYROLL 2/17/12 Retirement 1,056.02 12,805.95 PR _______________ Account: 135-50020-020-000 Retirement Totals: 2,108.92 12,805.95 ** 27,816.00 Budgeted 15,010.05 Remaining 46 % Used Account: 135-50026-020-000 Medical Insurance 400 02/03/2012 PAYROLL 2/3/12 Medical Insurance 8,512.38 1,072.69 9,585.07 PR 474 02/17/2012 PAYROLL 2/17/12 Medical Insurance 1,072.69 10,657.76 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 2,145.38 10,657.76 ** 30,805.00 Budgeted 20,147.24 Remaining 35 % Used . glpdatb2 rgonzale Trophy Club Entities Page 33 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-020-000 Dental Insurance 400 02/03/2012 PAYROLL 2/3/12 Dental Insurance 653.62 82.68 736.30 PR 474 02/17/2012 PAYROLL 2/17/12 Dental Insurance 82.68 818.98 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 165.36 818.98 ** 1,981.00 Budgeted 1,162.02 Remaining 41 % Used Account: 135-50028-020-000 Vision Insurance 400 02/03/2012 PAYROLL 2/3/12 Vision Insurance 162.76 20.60 183.36 PR 474 02/17/2012 PAYROLL 2/17/12 Vision Insurance 20.60 203.96 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 41.20 203.96 ** 552.00 Budgeted 348.04 Remaining 37 % Used Account: 135-50029-020-000 Life Insurance & Other .00 .00 _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: .00 .00 ** 884.00 Budgeted 884.00 Remaining 0 % Used Account: 135-50030-020-000 Social Security Taxes 400 02/03/2012 PAYROLL 2/3/12 Social Security Taxes 4,282.85 424.88 4,707.73 PR 474 02/17/2012 PAYROLL 2/17/12 Social Security Taxes 426.29 5,134.02 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 851.17 5,134.02 ** 8,597.00 Budgeted 3,462.98 Remaining 60 % Used Account: 135-50035-020-000 Medicare Taxes 400 02/03/2012 PAYROLL 2/3/12 Medicare Taxes 1,001.60 99.38 1,100.98 PR 474 02/17/2012 PAYROLL 2/17/12 Medicare Taxes 99.70 1,200.68 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 199.08 1,200.68 ** 2,011.00 Budgeted 810.32 Remaining 60 % Used Account: 135-50040-020-000 Unemployment Taxes 400 02/03/2012 PAYROLL 2/3/12 Unemployment Taxes 147.82 60.94 208.76 PR 474 02/17/2012 PAYROLL 2/17/12 Unemployment Taxes 58.90 267.66 PR . glpdatb2 rgonzale Trophy Club Entities Page 34 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: 119.84 267.66 ** 567.00 Budgeted 299.34 Remaining 47 % Used Account: 135-50045-020-000 Workman's Compensation 2,685.00 .00 2,685.00 _______________ Account: 135-50045-020-000 Workman's Compensation Totals: .00 2,685.00 ** 2,685.00 Budgeted .00 Remaining 100 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 30.45 .00 30.45 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 30.45 ** 200.00 Budgeted 169.55 Remaining 15 % Used Account: 135-50070-020-000 Employee Relations 20.00 .00 20.00 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 20.00 ** 350.00 Budgeted 330.00 Remaining 6 % Used Account: 135-55070-020-000 Independent Labor 1,305.67 .00 1,305.67 _______________ Account: 135-55070-020-000 Independent Labor Totals: .00 1,305.67 ** 750.00 Budgeted (555.67) Remaining 174 % Used Account: 135-55080-020-000 Maintenance & Repairs 15,278.10 .00 15,278.10 _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: .00 15,278.10 ** 17,750.00 Budgeted 2,471.90 Remaining 86 % Used Account: 135-55090-020-000 Vehicle Maintenance 529 02/27/2012 Feb A/P Battery for Camera Van 194.95 194.95 INTERSTATE ALL BATTERY CENTER 31273 AP . glpdatb2 rgonzale Trophy Club Entities Page 35 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 194.95 194.95 ** 4,998.00 Budgeted 4,803.05 Remaining 4 % Used Account: 135-55100-020-000 Building Maint & Supplies .00 .00 _______________ Account: 135-55100-020-000 Building Maint & Supplies Totals: .00 .00 ** 1,400.00 Budgeted 1,400.00 Remaining 0 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 134.00 .00 134.00 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 134.00 ** 2,950.00 Budgeted 2,816.00 Remaining 5 % Used Account: 135-55125-020-000 Dumpster Services 9,675.00 .00 9,675.00 _______________ Account: 135-55125-020-000 Dumpster Services Totals: .00 9,675.00 ** 35,000.00 Budgeted 25,325.00 Remaining 28 % Used Account: 135-55135-020-000 Lab Analysis 436 02/09/2012 Feb A/P Invoices Wet Chemical Analysis 3,849.82 590.75 4,440.57 TALEM, INC 31246 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 590.75 4,440.57 ** 22,760.00 Budgeted 18,319.43 Remaining 20 % Used Account: 135-60005-020-000 Telephone 10.59 .00 10.59 _______________ Account: 135-60005-020-000 Telephone Totals: .00 10.59 ** 100.00 Budgeted 89.41 Remaining 11 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles 594 02/29/2012 Feb A/P 1/23-2/22 Mobiles 888.23 236.55 1,124.78 VERIZON WIRELESS 31316 AP . glpdatb2 rgonzale Trophy Club Entities Page 36 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2012 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-020-000 Communications/Pagers/Mobiles Totals: 236.55 1,124.78 ** 3,000.00 Budgeted 1,875.22 Remaining 37 % Used Account: 135-60020-020-000 Electricity 23,307.74 .00 23,307.74 _______________ Account: 135-60020-020-000 Electricity Totals: .00 23,307.74 ** 205,000.00 Budgeted 181,692.26 Remaining 11 % Used Account: 135-60025-020-000 Water 1,137.73 .00 1,137.73 _______________ Account: 135-60025-020-000 Water Totals: .00 1,137.73 ** 1,900.00 Budgeted 762.27 Remaining 60 % Used Account: 135-60035-020-000 Postage .00 .00 _______________ Account: 135-60035-020-000 Postage Totals: .00 .00 ** 120.00 Budgeted 120.00 Remaining 0 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 438.17 .00 438.17 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 438.17 ** 500.00 Budgeted 61.83 Remaining 88 % Used Account: 135-60080-020-000 Schools & Training .00 .00 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 .00 ** 1,320.00 Budgeted 1,320.00 Remaining 0 % Used Account: 135-60090-020-000 Safety Program .00 .00 . glpdatb2 rgonzale Trophy Club Entities Page 37 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60090-020-000 Safety Program Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60100-020-000 Travel & per diem 400 02/03/2012 PAYROLL 2/3/12 Travel & per diem 606.06 69.93 675.99 PR 474 02/17/2012 PAYROLL 2/17/12 Travel & per diem 69.93 745.92 PR _______________ Account: 135-60100-020-000 Travel & per diem Totals: 139.86 745.92 ** 1,750.00 Budgeted 1,004.08 Remaining 43 % Used Account: 135-60105-020-000 Rent/Lease Equipment 901.30 .00 901.30 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 901.30 ** 200.00 Budgeted (701.30) Remaining 451 % Used Account: 135-60125-020-000 Advertising 987.36 .00 987.36 _______________ Account: 135-60125-020-000 Advertising Totals: .00 987.36 ** 1,000.00 Budgeted 12.64 Remaining 99 % Used Account: 135-60135-020-000 Annual Permit Fee 7,432.50 .00 7,432.50 _______________ Account: 135-60135-020-000 Annual Permit Fee Totals: .00 7,432.50 ** 7,500.00 Budgeted 67.50 Remaining 99 % Used Account: 135-60245-020-000 Miscellaneous Expenses 64.00 .00 64.00 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 64.00 ** 525.00 Budgeted 461.00 Remaining 12 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance .00 .00 . glpdatb2 rgonzale Trophy Club Entities Page 38 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 525.00 Budgeted 525.00 Remaining 0 % Used Account: 135-65005-020-000 Fuel & Lube 598 02/29/2012 Feb Gas Log 1,217.19 83.54 1,300.73 GL _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 83.54 1,300.73 ** 6,875.00 Budgeted 5,574.27 Remaining 19 % Used Account: 135-65010-020-000 Uniforms 916.93 .00 916.93 _______________ Account: 135-65010-020-000 Uniforms Totals: .00 916.93 ** 3,140.00 Budgeted 2,223.07 Remaining 29 % Used Account: 135-65030-020-000 Chemicals 2,557.57 .00 2,557.57 _______________ Account: 135-65030-020-000 Chemicals Totals: .00 2,557.57 ** 13,180.00 Budgeted 10,622.43 Remaining 19 % Used Account: 135-65035-020-000 Small Tools .00 .00 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 .00 ** 1,260.00 Budgeted 1,260.00 Remaining 0 % Used Account: 135-65040-020-000 Safety Equipment 22.75 .00 22.75 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 22.75 ** 925.00 Budgeted 902.25 Remaining 2 % Used Account: 135-65045-020-000 Lab Supplies 2,699.84 .00 2,699.84 . glpdatb2 rgonzale Trophy Club Entities Page 39 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65045-020-000 Lab Supplies Totals: .00 2,699.84 ** 19,160.00 Budgeted 16,460.16 Remaining 14 % Used Account: 135-65055-020-000 Hardware .00 .00 _______________ Account: 135-65055-020-000 Hardware Totals: .00 .00 ** 525.00 Budgeted 525.00 Remaining 0 % Used Account: 135-65085-020-000 Office Supplies 50.58 .00 50.58 _______________ Account: 135-65085-020-000 Office Supplies Totals: .00 50.58 ** 400.00 Budgeted 349.42 Remaining 13 % Used Account: 135-65095-020-000 Maintenance Supplies 594 02/29/2012 Feb A/P Feb Purchases 920.54 32.78 953.32 COSTCO WHOLESALE 31283 AP _______________ Account: 135-65095-020-000 Maintenance Supplies Totals: 32.78 953.32 ** 8,860.00 Budgeted 7,906.68 Remaining 11 % Used Account: 135-65115-020-000 Other Consumables .00 .00 _______________ Account: 135-65115-020-000 Other Consumables Totals: .00 .00 ** 110.00 Budgeted 110.00 Remaining 0 % Used Account: 135-69005-020-000 Capital Expenses 529 02/27/2012 Feb A/P Electrical for new meters at W 34,800.26 6,855.00 41,655.26 DHS AUTOMATION, INC 31268 AP 529 02/27/2012 Feb A/P Coax & fittings for new meters 717.80 42,373.06 DHS AUTOMATION, INC 31268 AP 636 02/27/2012 Recode Wildfire inv/Ford F150 1,219.50 43,592.56 GL _______________ Account: 135-69005-020-000 Capital Expenses Totals: 8,792.30 43,592.56 ** 161,189.00 Budgeted 117,596.44 Remaining 27 % Used Account: 135-69280-020-000 Capital Repairs . glpdatb2 rgonzale Trophy Club Entities Page 40 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2012 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-69280-020-000 Capital Repairs Totals: .00 .00 ** 56,000.00 Budgeted 56,000.00 Remaining 0 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 240,666.09 ** 856,009.00 Budgeted 615,342.91 Remaining 28 % Used . glpdatb2 rgonzale Trophy Club Entities Page 41 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 2/2012 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 400 02/03/2012 PAYROLL 2/3/12 Salaries & Wages 41,557.64 5,541.08 47,098.72 PR 474 02/17/2012 PAYROLL 2/17/12 Salaries & Wages 5,541.08 52,639.80 PR _______________ Account: 135-50005-021-000 Salaries & Wages Totals: 11,082.16 52,639.80 ** 145,481.00 Budgeted 92,841.20 Remaining 36 % Used Account: 135-50010-021-000 Overtime 400 02/03/2012 PAYROLL 2/3/12 Overtime 2,874.96 532.46 3,407.42 PR 474 02/17/2012 PAYROLL 2/17/12 Overtime 13.77 3,421.19 PR _______________ Account: 135-50010-021-000 Overtime Totals: 546.23 3,421.19 ** 7,297.00 Budgeted 3,875.81 Remaining 47 % Used Account: 135-50016-021-000 Longevity 3,547.50 .00 3,547.50 _______________ Account: 135-50016-021-000 Longevity Totals: .00 3,547.50 ** 3,548.00 Budgeted .50 Remaining 100 % Used Account: 135-50017-021-000 Certification 474 02/17/2012 PAYROLL 2/17/12 Certification 500.00 125.00 625.00 PR _______________ Account: 135-50017-021-000 Certification Totals: 125.00 625.00 ** 1,500.00 Budgeted 875.00 Remaining 42 % Used Account: 135-50020-021-000 Retirement 400 02/03/2012 PAYROLL 2/3/12 Retirement 7,244.93 839.36 8,084.29 PR 474 02/17/2012 PAYROLL 2/17/12 Retirement 784.97 8,869.26 PR _______________ Account: 135-50020-021-000 Retirement Totals: 1,624.33 8,869.26 ** 21,074.00 Budgeted 12,204.74 Remaining 42 % Used Account: 135-50026-021-000 Medical Insurance 400 02/03/2012 PAYROLL 2/3/12 Medical Insurance 6,810.72 851.34 7,662.06 PR 474 02/17/2012 PAYROLL 2/17/12 Medical Insurance 851.34 8,513.40 PR _______________ Account: 135-50026-021-000 Medical Insurance Totals: 1,702.68 8,513.40 ** 22,983.00 Budgeted 14,469.60 Remaining 37 % Used . glpdatb2 rgonzale Trophy Club Entities Page 42 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-021-000 Dental Insurance 400 02/03/2012 PAYROLL 2/3/12 Dental Insurance 469.52 58.69 528.21 PR 474 02/17/2012 PAYROLL 2/17/12 Dental Insurance 58.69 586.90 PR _______________ Account: 135-50027-021-000 Dental Insurance Totals: 117.38 586.90 ** 1,533.00 Budgeted 946.10 Remaining 38 % Used Account: 135-50028-021-000 Vision Insurance 400 02/03/2012 PAYROLL 2/3/12 Vision Insurance 118.88 14.86 133.74 PR 474 02/17/2012 PAYROLL 2/17/12 Vision Insurance 14.86 148.60 PR _______________ Account: 135-50028-021-000 Vision Insurance Totals: 29.72 148.60 ** 357.00 Budgeted 208.40 Remaining 42 % Used Account: 135-50029-021-000 Life Insurance & Other .00 .00 _______________ Account: 135-50029-021-000 Life Insurance & Other Totals: .00 .00 ** 978.00 Budgeted 978.00 Remaining 0 % Used Account: 135-50030-021-000 Social Security Taxes 400 02/03/2012 PAYROLL 2/3/12 Social Security Taxes 2,953.87 347.09 3,300.96 PR 474 02/17/2012 PAYROLL 2/17/12 Social Security Taxes 322.65 3,623.61 PR _______________ Account: 135-50030-021-000 Social Security Taxes Totals: 669.74 3,623.61 ** 9,785.00 Budgeted 6,161.39 Remaining 37 % Used Account: 135-50035-021-000 Medicare Taxes 400 02/03/2012 PAYROLL 2/3/12 Medicare Taxes 690.83 81.17 772.00 PR 474 02/17/2012 PAYROLL 2/17/12 Medicare Taxes 75.46 847.46 PR _______________ Account: 135-50035-021-000 Medicare Taxes Totals: 156.63 847.46 ** 2,288.00 Budgeted 1,440.54 Remaining 37 % Used Account: 135-50040-021-000 Unemployment Taxes 400 02/03/2012 PAYROLL 2/3/12 Unemployment Taxes 94.43 48.60 143.03 PR 474 02/17/2012 PAYROLL 2/17/12 Unemployment Taxes 37.07 180.10 PR . glpdatb2 rgonzale Trophy Club Entities Page 43 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 2/2012 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 Totals: 85.67 180.10 ** 567.00 Budgeted 386.90 Remaining 32 % Used Account: 135-50045-021-000 Workman's Compensation 3,056.00 .00 3,056.00 _______________ Account: 135-50045-021-000 Workman's Compensation Totals: .00 3,056.00 ** 3,056.00 Budgeted .00 Remaining 100 % Used Account: 135-50070-021-000 Employee Relations 19.97 .00 19.97 _______________ Account: 135-50070-021-000 Employee Relations Totals: .00 19.97 ** 250.00 Budgeted 230.03 Remaining 8 % 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-55070-021-000 Independent Labor .00 .00 _______________ Account: 135-55070-021-000 Independent Labor Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-55080-021-000 Maintenance & Repairs 529 02/27/2012 Feb A/P Repairs WW Lift Pump #2 VFD, W 2,815.85 720.00 3,535.85 DHS AUTOMATION, INC 31268 AP _______________ Account: 135-55080-021-000 Maintenance & Repairs Totals: 720.00 3,535.85 ** 23,700.00 Budgeted 20,164.15 Remaining 15 % Used Account: 135-55090-021-000 Vehicle Maintenance 130.00 .00 130.00 . glpdatb2 rgonzale Trophy Club Entities Page 44 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55090-021-000 Vehicle Maintenance Totals: .00 130.00 ** 1,943.00 Budgeted 1,813.00 Remaining 7 % Used Account: 135-55100-021-000 Building Maint & Supplies .00 .00 _______________ Account: 135-55100-021-000 Building Maint & Supplies Totals: .00 .00 ** 750.00 Budgeted 750.00 Remaining 0 % Used Account: 135-60005-021-000 Telephone 594 02/29/2012 Feb A/P Feb PCard-Zieverink 11.18 .74 11.92 BANK OF AMERICA 31281 AP _______________ Account: 135-60005-021-000 Telephone Totals: .74 11.92 ** 50.00 Budgeted 38.08 Remaining 24 % Used Account: 135-60010-021-000 Communications/Pagers/Mobiles 594 02/29/2012 Feb A/P 1/23-2/22 Mobiles 1,340.35 204.24 1,544.59 VERIZON WIRELESS 31316 AP _______________ Account: 135-60010-021-000 Communications/Pagers/Mobiles Totals: 204.24 1,544.59 ** 2,796.00 Budgeted 1,251.41 Remaining 55 % Used Account: 135-60020-021-000 Electricity 477 02/16/2012 Feb A/P Electricity 1/5-2/2 2,241.65 119.50 2,361.15 TRI COUNTY ELECTRIC 31262 AP 477 02/16/2012 Feb A/P Electricity 1/5-2/2 27.58 2,388.73 TRI COUNTY ELECTRIC 31262 AP 529 02/27/2012 Feb A/P Electricity 12/14-2/15 11.46 2,400.19 HUDSON ENERGY 31272 AP 529 02/27/2012 Feb A/P Electricity 12/14-2/15 4.22 2,404.41 HUDSON ENERGY 31272 AP 529 02/27/2012 Feb A/P Electricity 12/14-2/15 103.47 2,507.88 HUDSON ENERGY 31272 AP 529 02/27/2012 Feb A/P Electricity 12/14-2/15 765.20 3,273.08 HUDSON ENERGY 31272 AP 529 02/27/2012 Feb A/P Electricity 12/14-2/15 141.33 3,414.41 HUDSON ENERGY 31272 AP 529 02/27/2012 Feb A/P Electricity 12/14-2/15 27.01 3,441.42 HUDSON ENERGY 31272 AP _______________ Account: 135-60020-021-000 Electricity Totals: 1,199.77 3,441.42 ** 23,625.00 Budgeted 20,183.58 Remaining 15 % Used Account: 135-60025-021-000 Water .00 .00 . glpdatb2 rgonzale Trophy Club Entities Page 45 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60025-021-000 Water Totals: .00 .00 ** 750.00 Budgeted 750.00 Remaining 0 % Used Account: 135-60035-021-000 Postage .00 .00 _______________ Account: 135-60035-021-000 Postage Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60070-021-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-021-000 Dues & Memberships Totals: .00 .00 ** 255.00 Budgeted 255.00 Remaining 0 % Used Account: 135-60080-021-000 Schools & Training .00 .00 _______________ Account: 135-60080-021-000 Schools & Training Totals: .00 .00 ** 2,818.00 Budgeted 2,818.00 Remaining 0 % Used Account: 135-60090-021-000 Safety Program .00 .00 _______________ Account: 135-60090-021-000 Safety Program Totals: .00 .00 ** 750.00 Budgeted 750.00 Remaining 0 % Used Account: 135-60100-021-000 Travel & per diem 400 02/03/2012 PAYROLL 2/3/12 Travel & per diem 335.24 51.62 386.86 PR _______________ Account: 135-60100-021-000 Travel & per diem Totals: 51.62 386.86 ** 1,500.00 Budgeted 1,113.14 Remaining 26 % Used Account: 135-60105-021-000 Rent/Lease Equipment .00 .00 . glpdatb2 rgonzale Trophy Club Entities Page 46 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60105-021-000 Rent/Lease Equipment Totals: .00 .00 ** 76,098.00 Budgeted 76,098.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-60280-021-000 Property Maintenance .00 .00 _______________ Account: 135-60280-021-000 Property Maintenance Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-65005-021-000 Fuel & Lube 598 02/29/2012 Feb Gas Log 3,246.73 348.56 3,595.29 GL _______________ Account: 135-65005-021-000 Fuel & Lube Totals: 348.56 3,595.29 ** 11,700.00 Budgeted 8,104.71 Remaining 31 % Used Account: 135-65010-021-000 Uniforms 620.98 .00 620.98 _______________ Account: 135-65010-021-000 Uniforms Totals: .00 620.98 ** 2,505.00 Budgeted 1,884.02 Remaining 25 % Used Account: 135-65030-021-000 Chemicals .00 .00 _______________ Account: 135-65030-021-000 Chemicals Totals: .00 .00 ** 12,500.00 Budgeted 12,500.00 Remaining 0 % Used Account: 135-65035-021-000 Small Tools .00 .00 . glpdatb2 rgonzale Trophy Club Entities Page 47 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65035-021-000 Small Tools Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-65040-021-000 Safety Equipment 22.74 .00 22.74 _______________ Account: 135-65040-021-000 Safety Equipment Totals: .00 22.74 ** 1,150.00 Budgeted 1,127.26 Remaining 2 % Used Account: 135-65055-021-000 Hardware 44.95 .00 44.95 _______________ Account: 135-65055-021-000 Hardware Totals: .00 44.95 ** 750.00 Budgeted 705.05 Remaining 6 % Used Account: 135-65095-021-000 Maintenance Supplies 594 02/29/2012 Feb A/P Feb Purchases 138.38 65.76 204.14 COSTCO WHOLESALE 31283 AP _______________ Account: 135-65095-021-000 Maintenance Supplies Totals: 65.76 204.14 ** 16,050.00 Budgeted 15,845.86 Remaining 1 % Used Account: 135-69005-021-000 Capital Expenses 31,991.00 .00 31,991.00 _______________ Account: 135-69005-021-000 Capital Expenses Totals: .00 31,991.00 ** 15,000.00 Budgeted (16,991.00) Remaining 213 % Used Account: 135-69280-021-000 Capital Repairs .00 .00 _______________ Account: 135-69280-021-000 Capital Repairs Totals: .00 .00 ** 20,000.00 Budgeted 20,000.00 Remaining 0 % Used Department 21 Totals: ------------------------------------------------------------------------------------------------ 131,608.53 ** 439,837.00 Budgeted 308,228.47 Remaining 30 % Used . glpdatb2 rgonzale Trophy Club Entities Page 48 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 2/2012 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 474 02/17/2012 PAYROLL 2/17/12 Salaries & Wages 2,300.00 700.00 3,000.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 700.00 3,000.00 ** 10,000.00 Budgeted 7,000.00 Remaining 30 % Used Account: 135-50030-026-000 Social Security Taxes 474 02/17/2012 PAYROLL 2/17/12 Social Security Taxes 142.60 43.40 186.00 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 43.40 186.00 ** 620.00 Budgeted 434.00 Remaining 30 % Used Account: 135-50035-026-000 Medicare Taxes 474 02/17/2012 PAYROLL 2/17/12 Medicare Taxes 33.35 10.15 43.50 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 10.15 43.50 ** 145.00 Budgeted 101.50 Remaining 30 % Used Account: 135-50040-026-000 Unemployment Taxes 474 02/17/2012 PAYROLL 2/17/12 Unemployment Taxes 18.40 5.60 24.00 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 5.60 24.00 ** 210.00 Budgeted 186.00 Remaining 11 % Used Account: 135-50045-026-000 Workman's Compensation 120.00 .00 120.00 _______________ Account: 135-50045-026-000 Workman's Compensation Totals: .00 120.00 ** 120.00 Budgeted .00 Remaining 100 % Used Account: 135-60035-026-000 Postage 26.11 .00 26.11 _______________ Account: 135-60035-026-000 Postage Totals: .00 26.11 ** .00 Budgeted (26.11) Remaining 0 % Used Account: 135-60066-026-000 Publications/Books/Subscripts . glpdatb2 rgonzale Trophy Club Entities Page 49 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 2/2012 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-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 50.00 Budgeted 50.00 Remaining 0 % Used Account: 135-60070-026-000 Dues & Memberships 685.00 .00 685.00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 685.00 ** 2,100.00 Budgeted 1,415.00 Remaining 33 % Used Account: 135-60075-026-000 Meetings 594 02/29/2012 Feb A/P Chamber luncheon, N Sanders, 174.82 44.00 218.82 NORTHWEST METROPORT CHAMBER 31302 AP _______________ Account: 135-60075-026-000 Meetings Totals: 44.00 218.82 ** 1,278.00 Budgeted 1,059.18 Remaining 17 % Used Account: 135-60080-026-000 Schools & Training 875.00 .00 875.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 875.00 ** 4,150.00 Budgeted 3,275.00 Remaining 21 % Used Account: 135-60100-026-000 Travel & per diem 594 02/29/2012 Feb A/P Mileage reimbursement-AWBD 32.19 32.19 KEVIN CARR 31295 AP _______________ Account: 135-60100-026-000 Travel & per diem Totals: 32.19 32.19 ** 6,199.00 Budgeted 6,166.81 Remaining 1 % Used Account: 135-60245-026-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 .00 ** 3,200.00 Budgeted 3,200.00 Remaining 0 % Used Account: 135-65085-026-000 Office Supplies 8.90 .00 8.90 . glpdatb2 rgonzale Trophy Club Entities Page 50 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65085-026-000 Office Supplies Totals: .00 8.90 ** 50.00 Budgeted 41.10 Remaining 18 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 5,219.52 ** 28,122.00 Budgeted 22,902.48 Remaining 19 % Used . glpdatb2 rgonzale Trophy Club Entities Page 51 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 2/2012 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-027-000 Salaries & Wages 400 02/03/2012 PAYROLL 2/3/12 Salaries & Wages 53,397.49 8,700.96 62,098.45 PR 474 02/17/2012 PAYROLL 2/17/12 Salaries & Wages 8,647.73 70,746.18 PR 539 02/29/2012 SUPPLEMENTAL - SCOTT 2/29/12 Salaries & Wages 4,244.83 74,991.01 PR 540 02/29/2012 SUPPLEMENTAL 2 - SCOTT 2/29/12 Salaries & Wages 2,122.42 77,113.43 PR 541 02/29/2012 SUPPLEMENTAL 3 - SCOTT 2/29/12 Salaries & Wages 52,975.63 130,089.06 PR 544 02/29/2012 SUPPLEMENTAL 4 - SCOTT 2/29/12 Salaries & Wages 11,328.31 141,417.37 PR _______________ Account: 135-50005-027-000 Salaries & Wages Totals: 88,019.88 141,417.37 ** 236,831.00 Budgeted 95,413.63 Remaining 60 % Used Account: 135-50010-027-000 Overtime 400 02/03/2012 PAYROLL 2/3/12 Overtime 989.55 1.97 991.52 PR 474 02/17/2012 PAYROLL 2/17/12 Overtime 19.82 1,011.34 PR _______________ Account: 135-50010-027-000 Overtime Totals: 21.79 1,011.34 ** 1,000.00 Budgeted (11.34) Remaining 101 % Used Account: 135-50016-027-000 Longevity 542 02/29/2012 LONGEVITY - SCOTT 2/29/12 Longevity 1,845.00 1,860.00 3,705.00 PR _______________ Account: 135-50016-027-000 Longevity Totals: 1,860.00 3,705.00 ** 1,845.00 Budgeted (1,860.00) Remaining 201 % Used Account: 135-50020-027-000 Retirement 400 02/03/2012 PAYROLL 2/3/12 Retirement 8,315.19 1,202.76 9,517.95 PR 474 02/17/2012 PAYROLL 2/17/12 Retirement 1,197.83 10,715.78 PR 539 02/29/2012 SUPPLEMENTAL - SCOTT 2/29/12 Retirement 586.64 11,302.42 PR 540 02/29/2012 SUPPLEMENTAL 2 - SCOTT 2/29/12 Retirement 293.32 11,595.74 PR 541 02/29/2012 SUPPLEMENTAL 3 - SCOTT 2/29/12 Retirement 7,321.23 18,916.97 PR 542 02/29/2012 LONGEVITY - SCOTT 2/29/12 Retirement 257.05 19,174.02 PR 544 02/29/2012 SUPPLEMENTAL 4 - SCOTT 2/29/12 Retirement 1,565.57 20,739.59 PR _______________ Account: 135-50020-027-000 Retirement Totals: 12,424.40 20,739.59 ** 33,471.00 Budgeted 12,731.41 Remaining 62 % Used Account: 135-50026-027-000 Medical Insurance 400 02/03/2012 PAYROLL 2/3/12 Medical Insurance 5,197.64 803.95 6,001.59 PR 474 02/17/2012 PAYROLL 2/17/12 Medical Insurance 768.55 6,770.14 PR . glpdatb2 rgonzale Trophy Club Entities Page 52 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 539 02/29/2012 SUPPLEMENTAL - SCOTT 2/29/12 Medical Insurance 5,197.64 205.35 6,975.49 PR 540 02/29/2012 SUPPLEMENTAL 2 - SCOTT 2/29/12 Medical Insurance 205.35 7,180.84 PR 541 02/29/2012 SUPPLEMENTAL 3 - SCOTT 2/29/12 Medical Insurance 205.35 7,386.19 PR 544 02/29/2012 SUPPLEMENTAL 4 - SCOTT 2/29/12 Medical Insurance 205.35 7,591.54 PR _______________ Account: 135-50026-027-000 Medical Insurance Totals: 2,393.90 7,591.54 ** 18,798.00 Budgeted 11,206.46 Remaining 40 % Used Account: 135-50027-027-000 Dental Insurance 400 02/03/2012 PAYROLL 2/3/12 Dental Insurance 389.84 61.71 451.55 PR 474 02/17/2012 PAYROLL 2/17/12 Dental Insurance 59.50 511.05 PR 539 02/29/2012 SUPPLEMENTAL - SCOTT 2/29/12 Dental Insurance 14.21 525.26 PR 540 02/29/2012 SUPPLEMENTAL 2 - SCOTT 2/29/12 Dental Insurance 14.21 539.47 PR 541 02/29/2012 SUPPLEMENTAL 3 - SCOTT 2/29/12 Dental Insurance 14.21 553.68 PR 544 02/29/2012 SUPPLEMENTAL 4 - SCOTT 2/29/12 Dental Insurance 14.21 567.89 PR _______________ Account: 135-50027-027-000 Dental Insurance Totals: 178.05 567.89 ** 1,242.00 Budgeted 674.11 Remaining 46 % Used Account: 135-50028-027-000 Vision Insurance 400 02/03/2012 PAYROLL 2/3/12 Vision Insurance 98.57 15.48 114.05 PR 474 02/17/2012 PAYROLL 2/17/12 Vision Insurance 14.84 128.89 PR 539 02/29/2012 SUPPLEMENTAL - SCOTT 2/29/12 Vision Insurance 3.38 132.27 PR 540 02/29/2012 SUPPLEMENTAL 2 - SCOTT 2/29/12 Vision Insurance 3.38 135.65 PR 541 02/29/2012 SUPPLEMENTAL 3 - SCOTT 2/29/12 Vision Insurance 3.38 139.03 PR 544 02/29/2012 SUPPLEMENTAL 4 - SCOTT 2/29/12 Vision Insurance 3.38 142.41 PR _______________ Account: 135-50028-027-000 Vision Insurance Totals: 43.84 142.41 ** 341.00 Budgeted 198.59 Remaining 42 % Used Account: 135-50029-027-000 Life Insurance & Other .00 .00 _______________ Account: 135-50029-027-000 Life Insurance & Other Totals: .00 .00 ** 1,337.00 Budgeted 1,337.00 Remaining 0 % Used Account: 135-50030-027-000 Social Security Taxes 400 02/03/2012 PAYROLL 2/3/12 Social Security Taxes 3,328.03 510.22 3,838.25 PR 474 02/17/2012 PAYROLL 2/17/12 Social Security Taxes 509.35 4,347.60 PR . glpdatb2 rgonzale Trophy Club Entities Page 53 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 539 02/29/2012 SUPPLEMENTAL - SCOTT 2/29/12 Social Security Taxes 3,328.03 263.18 4,610.78 PR 540 02/29/2012 SUPPLEMENTAL 2 - SCOTT 2/29/12 Social Security Taxes 131.59 4,742.37 PR 541 02/29/2012 SUPPLEMENTAL 3 - SCOTT 2/29/12 Social Security Taxes 3,284.49 8,026.86 PR 542 02/29/2012 LONGEVITY - SCOTT 2/29/12 Social Security Taxes 115.32 8,142.18 PR 544 02/29/2012 SUPPLEMENTAL 4 - SCOTT 2/29/12 Social Security Taxes 702.35 8,844.53 PR _______________ Account: 135-50030-027-000 Social Security Taxes Totals: 5,516.50 8,844.53 ** 14,860.00 Budgeted 6,015.47 Remaining 60 % Used Account: 135-50035-027-000 Medicare Taxes 400 02/03/2012 PAYROLL 2/3/12 Medicare Taxes 816.24 119.29 935.53 PR 474 02/17/2012 PAYROLL 2/17/12 Medicare Taxes 119.12 1,054.65 PR 539 02/29/2012 SUPPLEMENTAL - SCOTT 2/29/12 Medicare Taxes 61.55 1,116.20 PR 540 02/29/2012 SUPPLEMENTAL 2 - SCOTT 2/29/12 Medicare Taxes 30.78 1,146.98 PR 541 02/29/2012 SUPPLEMENTAL 3 - SCOTT 2/29/12 Medicare Taxes 768.14 1,915.12 PR 542 02/29/2012 LONGEVITY - SCOTT 2/29/12 Medicare Taxes 26.97 1,942.09 PR 544 02/29/2012 SUPPLEMENTAL 4 - SCOTT 2/29/12 Medicare Taxes 164.26 2,106.35 PR _______________ Account: 135-50035-027-000 Medicare Taxes Totals: 1,290.11 2,106.35 ** 3,475.00 Budgeted 1,368.65 Remaining 61 % Used Account: 135-50040-027-000 Unemployment Taxes 400 02/03/2012 PAYROLL 2/3/12 Unemployment Taxes 135.99 39.75 175.74 PR 474 02/17/2012 PAYROLL 2/17/12 Unemployment Taxes 32.28 208.02 PR _______________ Account: 135-50040-027-000 Unemployment Taxes Totals: 72.03 208.02 ** 756.00 Budgeted 547.98 Remaining 28 % Used Account: 135-50045-027-000 Workman's Compensation 580.00 .00 580.00 _______________ Account: 135-50045-027-000 Workman's Compensation Totals: .00 580.00 ** 580.00 Budgeted .00 Remaining 100 % Used Account: 135-50070-027-000 Employee Relations 3,368.76 .00 3,368.76 _______________ Account: 135-50070-027-000 Employee Relations Totals: .00 3,368.76 ** 5,000.00 Budgeted 1,631.24 Remaining 67 % Used . glpdatb2 rgonzale Trophy Club Entities Page 54 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55070-027-000 Independent Labor 529 02/27/2012 Feb A/P Video Joint Session & MUD meet 138.75 41.25 180.00 MIGUEL CRUZ 31274 AP _______________ Account: 135-55070-027-000 Independent Labor Totals: 41.25 180.00 ** 840.00 Budgeted 660.00 Remaining 21 % Used Account: 135-55075-027-000 Records Management .00 .00 _______________ Account: 135-55075-027-000 Records Management Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-55160-027-000 Professional Outside Services 95,384.68 .00 95,384.68 _______________ Account: 135-55160-027-000 Professional Outside Services Totals: .00 95,384.68 ** 176,870.00 Budgeted 81,485.32 Remaining 54 % Used Account: 135-60005-027-000 Telephone 594 02/29/2012 Feb A/P Feb PCard-Zieverink 77.58 19.72 97.30 BANK OF AMERICA 31281 AP _______________ Account: 135-60005-027-000 Telephone Totals: 19.72 97.30 ** 300.00 Budgeted 202.70 Remaining 32 % Used Account: 135-60010-027-000 Communications/Pagers/Mobiles 594 02/29/2012 Feb A/P 1/23-2/22 Mobiles 822.70 143.21 965.91 VERIZON WIRELESS 31316 AP _______________ Account: 135-60010-027-000 Communications/Pagers/Mobiles Totals: 143.21 965.91 ** 2,420.00 Budgeted 1,454.09 Remaining 40 % Used Account: 135-60035-027-000 Postage 413 02/01/2012 A/P Invoice Flat Rate Express Mail/Audit t 525.09 18.95 544.04 U.S. POSTAL SERVICE 31207 AP 594 02/29/2012 Feb A/P Overnight Docs to McCall Parkh 25.48 569.52 FEDERAL EXPRESS CORP 31287 AP _______________ Account: 135-60035-027-000 Postage Totals: 44.43 569.52 ** 1,000.00 Budgeted 430.48 Remaining 57 % Used Account: 135-60066-027-000 Publications/Books/Subscripts . glpdatb2 rgonzale Trophy Club Entities Page 55 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 114.75 .00 114.75 _______________ Account: 135-60066-027-000 Publications/Books/Subscripts Totals: .00 114.75 ** 450.00 Budgeted 335.25 Remaining 26 % Used Account: 135-60070-027-000 Dues & Memberships 421.05 .00 421.05 _______________ Account: 135-60070-027-000 Dues & Memberships Totals: .00 421.05 ** 1,742.00 Budgeted 1,320.95 Remaining 24 % Used Account: 135-60075-027-000 Meetings .00 .00 _______________ Account: 135-60075-027-000 Meetings Totals: .00 .00 ** 312.00 Budgeted 312.00 Remaining 0 % Used Account: 135-60080-027-000 Schools & Training 445.00 .00 445.00 _______________ Account: 135-60080-027-000 Schools & Training Totals: .00 445.00 ** 2,555.00 Budgeted 2,110.00 Remaining 17 % Used Account: 135-60100-027-000 Travel & per diem 127.87 .00 127.87 _______________ Account: 135-60100-027-000 Travel & per diem Totals: .00 127.87 ** 3,851.00 Budgeted 3,723.13 Remaining 3 % Used Account: 135-60115-027-000 Elections .00 .00 _______________ Account: 135-60115-027-000 Elections Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-60125-027-000 Advertising .00 .00 . glpdatb2 rgonzale Trophy Club Entities Page 56 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60125-027-000 Advertising Totals: .00 .00 ** 4,700.00 Budgeted 4,700.00 Remaining 0 % Used Account: 135-60245-027-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-027-000 Miscellaneous Expenses Totals: .00 .00 ** 100.00 Budgeted 100.00 Remaining 0 % Used Account: 135-60270-027-000 4th of July Celebration 529 02/27/2012 Feb A/P 4th of July donation 10,000.00 10,000.00 TOWN OF TROPHY CLUB 31278 AP _______________ Account: 135-60270-027-000 4th of July Celebration Totals: 10,000.00 10,000.00 ** 10,000.00 Budgeted .00 Remaining 100 % Used Account: 135-60360-027-000 Furniture/Equipment < $5000 299.99 .00 299.99 _______________ Account: 135-60360-027-000 Furniture/Equipment < $5000 Totals: .00 299.99 ** 2,225.00 Budgeted 1,925.01 Remaining 13 % Used Account: 135-65085-027-000 Office Supplies 529 02/27/2012 Feb A/P Office Supplies 542.41 45.14 587.55 OFFICE DEPOT, INC 31275 AP 594 02/29/2012 Feb A/P Office supplies 44.09 631.64 OFFICE DEPOT, INC 31303 AP 594 02/29/2012 Feb A/P Office supplies 69.64 701.28 OFFICE DEPOT, INC 31303 AP _______________ Account: 135-65085-027-000 Office Supplies Totals: 158.87 701.28 ** 2,450.00 Budgeted 1,748.72 Remaining 29 % Used Account: 135-65105-027-000 Printing 594 02/29/2012 Feb A/P Business Cards-J McKnight 395.00 68.00 463.00 FORMS ONE 31288 AP _______________ Account: 135-65105-027-000 Printing Totals: 68.00 463.00 ** 515.00 Budgeted 52.00 Remaining 90 % Used Department 27 Totals: ------------------------------------------------------------------------------------------------ 300,053.15 ** 532,866.00 Budgeted 232,812.85 Remaining 56 % Used . glpdatb2 rgonzale Trophy Club Entities Page 57 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 28 Human Resources Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50070-028-000 Employee Relations 1,470.22 .00 1,470.22 _______________ Account: 135-50070-028-000 Employee Relations Totals: .00 1,470.22 ** 1,967.00 Budgeted 496.78 Remaining 75 % Used Account: 135-50075-028-000 Tuition Reimbursement 19.95 .00 19.95 _______________ Account: 135-50075-028-000 Tuition Reimbursement Totals: .00 19.95 ** 1,561.00 Budgeted 1,541.05 Remaining 1 % Used Account: 135-60005-028-000 Telephone .00 .00 _______________ Account: 135-60005-028-000 Telephone Totals: .00 .00 ** 28.00 Budgeted 28.00 Remaining 0 % Used Account: 135-60035-028-000 Postage .00 .00 _______________ Account: 135-60035-028-000 Postage Totals: .00 .00 ** 106.00 Budgeted 106.00 Remaining 0 % Used Account: 135-60066-028-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-028-000 Publications/Books/Subscripts Totals: .00 .00 ** 485.00 Budgeted 485.00 Remaining 0 % Used Account: 135-60070-028-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-028-000 Dues & Memberships Totals: .00 .00 ** 555.00 Budgeted 555.00 Remaining 0 % Used Account: 135-60075-028-000 Meetings . glpdatb2 rgonzale Trophy Club Entities Page 58 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 28 Human Resources Program: Period Ending: 2/2012 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-60075-028-000 Meetings Totals: .00 .00 ** 138.00 Budgeted 138.00 Remaining 0 % Used Account: 135-60080-028-000 Schools & Training .00 .00 _______________ Account: 135-60080-028-000 Schools & Training Totals: .00 .00 ** 594.00 Budgeted 594.00 Remaining 0 % Used Account: 135-60100-028-000 Travel & per diem .00 .00 _______________ Account: 135-60100-028-000 Travel & per diem Totals: .00 .00 ** 8.00 Budgeted 8.00 Remaining 0 % Used Account: 135-60110-028-000 Physicals/Testing 105.00 .00 105.00 _______________ Account: 135-60110-028-000 Physicals/Testing Totals: .00 105.00 ** 1,560.00 Budgeted 1,455.00 Remaining 7 % Used Account: 135-65085-028-000 Office Supplies .00 .00 _______________ Account: 135-65085-028-000 Office Supplies Totals: .00 .00 ** 437.00 Budgeted 437.00 Remaining 0 % Used Account: 135-65105-028-000 Printing .00 .00 _______________ Account: 135-65105-028-000 Printing Totals: .00 .00 ** 116.00 Budgeted 116.00 Remaining 0 % Used Department 28 Totals: ------------------------------------------------------------------------------------------------ 1,595.17 ** 7,555.00 Budgeted 5,959.83 Remaining 21 % Used . glpdatb2 rgonzale Trophy Club Entities Page 59 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 2/2012 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-029-000 Salaries & Wages 400 02/03/2012 PAYROLL 2/3/12 Salaries & Wages 27,309.94 2,942.31 30,252.25 PR 474 02/17/2012 PAYROLL 2/17/12 Salaries & Wages 2,942.31 33,194.56 PR _______________ Account: 135-50005-029-000 Salaries & Wages Totals: 5,884.62 33,194.56 ** 94,404.00 Budgeted 61,209.44 Remaining 35 % Used Account: 135-50010-029-000 Overtime 946.28 .00 946.28 _______________ Account: 135-50010-029-000 Overtime Totals: .00 946.28 ** 1,000.00 Budgeted 53.72 Remaining 95 % Used Account: 135-50016-029-000 Longevity 1,822.50 .00 1,822.50 _______________ Account: 135-50016-029-000 Longevity Totals: .00 1,822.50 ** 1,823.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-029-000 Retirement 400 02/03/2012 PAYROLL 2/3/12 Retirement 4,505.94 406.63 4,912.57 PR 474 02/17/2012 PAYROLL 2/17/12 Retirement 406.63 5,319.20 PR _______________ Account: 135-50020-029-000 Retirement Totals: 813.26 5,319.20 ** 13,612.00 Budgeted 8,292.80 Remaining 39 % Used Account: 135-50026-029-000 Medical Insurance 400 02/03/2012 PAYROLL 2/3/12 Medical Insurance 3,310.38 205.35 3,515.73 PR 474 02/17/2012 PAYROLL 2/17/12 Medical Insurance 205.35 3,721.08 PR _______________ Account: 135-50026-029-000 Medical Insurance Totals: 410.70 3,721.08 ** 11,060.00 Budgeted 7,338.92 Remaining 34 % Used Account: 135-50027-029-000 Dental Insurance 400 02/03/2012 PAYROLL 2/3/12 Dental Insurance 281.83 24.51 306.34 PR 474 02/17/2012 PAYROLL 2/17/12 Dental Insurance 24.51 330.85 PR _______________ Account: 135-50027-029-000 Dental Insurance Totals: 49.02 330.85 ** 773.00 Budgeted 442.15 Remaining 43 % Used . glpdatb2 rgonzale Trophy Club Entities Page 60 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50028-029-000 Vision Insurance 400 02/03/2012 PAYROLL 2/3/12 Vision Insurance 47.11 3.38 50.49 PR 474 02/17/2012 PAYROLL 2/17/12 Vision Insurance 3.38 53.87 PR _______________ Account: 135-50028-029-000 Vision Insurance Totals: 6.76 53.87 ** 207.00 Budgeted 153.13 Remaining 26 % Used Account: 135-50029-029-000 Life Insurance & Other .00 .00 _______________ Account: 135-50029-029-000 Life Insurance & Other Totals: .00 .00 ** 567.00 Budgeted 567.00 Remaining 0 % Used Account: 135-50030-029-000 Social Security Taxes 400 02/03/2012 PAYROLL 2/3/12 Social Security Taxes 1,745.02 169.27 1,914.29 PR 474 02/17/2012 PAYROLL 2/17/12 Social Security Taxes 169.27 2,083.56 PR _______________ Account: 135-50030-029-000 Social Security Taxes Totals: 338.54 2,083.56 ** 5,386.00 Budgeted 3,302.44 Remaining 39 % Used Account: 135-50035-029-000 Medicare Taxes 400 02/03/2012 PAYROLL 2/3/12 Medicare Taxes 408.12 39.58 447.70 PR 474 02/17/2012 PAYROLL 2/17/12 Medicare Taxes 39.59 487.29 PR _______________ Account: 135-50035-029-000 Medicare Taxes Totals: 79.17 487.29 ** 1,260.00 Budgeted 772.71 Remaining 39 % Used Account: 135-50040-029-000 Unemployment Taxes 400 02/03/2012 PAYROLL 2/3/12 Unemployment Taxes 54.62 23.54 78.16 PR 474 02/17/2012 PAYROLL 2/17/12 Unemployment Taxes 1.38 79.54 PR _______________ Account: 135-50040-029-000 Unemployment Taxes Totals: 24.92 79.54 ** 284.00 Budgeted 204.46 Remaining 28 % Used Account: 135-50045-029-000 Workman's Compensation 211.00 .00 211.00 _______________ Account: 135-50045-029-000 Workman's Compensation Totals: .00 211.00 ** 235.00 Budgeted 24.00 Remaining 90 % Used . glpdatb2 rgonzale Trophy Club Entities Page 61 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55160-029-000 Professional Outside Services 973.50 .00 973.50 _______________ Account: 135-55160-029-000 Professional Outside Services Totals: .00 973.50 ** 5,000.00 Budgeted 4,026.50 Remaining 19 % Used Account: 135-60005-029-000 Telephone 594 02/29/2012 Feb A/P Feb PCard-Zieverink 31.37 4.96 36.33 BANK OF AMERICA 31281 AP _______________ Account: 135-60005-029-000 Telephone Totals: 4.96 36.33 ** 103.00 Budgeted 66.67 Remaining 35 % Used Account: 135-60010-029-000 Communications/Pagers/Mobiles 594 02/29/2012 Feb A/P 1/23-2/22 Mobiles 201.82 51.86 253.68 VERIZON WIRELESS 31316 AP _______________ Account: 135-60010-029-000 Communications/Pagers/Mobiles Totals: 51.86 253.68 ** 683.00 Budgeted 429.32 Remaining 37 % Used Account: 135-60035-029-000 Postage 96.99 .00 96.99 _______________ Account: 135-60035-029-000 Postage Totals: .00 96.99 ** 700.00 Budgeted 603.01 Remaining 14 % Used Account: 135-60040-029-000 Service Charges & Fees 32.50 .00 32.50 _______________ Account: 135-60040-029-000 Service Charges & Fees Totals: .00 32.50 ** 79.00 Budgeted 46.50 Remaining 41 % Used Account: 135-60066-029-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-029-000 Publications/Books/Subscripts Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60070-029-000 Dues & Memberships . glpdatb2 rgonzale Trophy Club Entities Page 62 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 2/2012 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-60070-029-000 Dues & Memberships Totals: .00 .00 ** 660.00 Budgeted 660.00 Remaining 0 % Used Account: 135-60075-029-000 Meetings 22.00 .00 22.00 _______________ Account: 135-60075-029-000 Meetings Totals: .00 22.00 ** 300.00 Budgeted 278.00 Remaining 7 % Used Account: 135-60080-029-000 Schools & Training .00 .00 _______________ Account: 135-60080-029-000 Schools & Training Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 135-60100-029-000 Travel & per diem 400 02/03/2012 PAYROLL 2/3/12 Travel & per diem 15.04 12.77 27.81 PR _______________ Account: 135-60100-029-000 Travel & per diem Totals: 12.77 27.81 ** 1,500.00 Budgeted 1,472.19 Remaining 2 % Used Account: 135-60125-029-000 Advertising .00 .00 _______________ Account: 135-60125-029-000 Advertising Totals: .00 .00 ** 1,210.00 Budgeted 1,210.00 Remaining 0 % Used Account: 135-60245-029-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-029-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-65085-029-000 Office Supplies 594 02/29/2012 Feb A/P Office supplies 78.48 21.46 99.94 OFFICE DEPOT, INC 31303 AP . glpdatb2 rgonzale Trophy Club Entities Page 63 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65085-029-000 Office Supplies Totals: 21.46 99.94 ** 849.00 Budgeted 749.06 Remaining 12 % Used Account: 135-65105-029-000 Printing .00 .00 _______________ Account: 135-65105-029-000 Printing Totals: .00 .00 ** 515.00 Budgeted 515.00 Remaining 0 % Used Department 29 Totals: ------------------------------------------------------------------------------------------------ 49,792.48 ** 144,910.00 Budgeted 95,117.52 Remaining 34 % Used . glpdatb2 rgonzale Trophy Club Entities Page 64 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 33 Information Systems Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55030-033-000 Software & Support 477 02/16/2012 Feb A/P Windows 7 license & drive shut 24,797.04 246.36 25,043.40 SHI GOVERNMENT SOLUTIONS,INC 31259 AP 529 02/27/2012 Feb A/P 1/2 Legistar program 3/1/12-2/ 4,459.68 29,503.08 GRANICUS, INC 31271 AP 594 02/29/2012 Feb A/P Feb PCard-Pastor 25.00 29,528.08 BANK OF AMERICA 31281 AP 594 02/29/2012 Feb A/P Feb PCard-Pastor 197.00 29,725.08 BANK OF AMERICA 31281 AP 594 02/29/2012 Feb A/P Feb PCard-Zieverink 54.99 29,780.07 BANK OF AMERICA 31281 AP 594 02/29/2012 Feb A/P Feb PCard-Zieverink 53.38 29,833.45 BANK OF AMERICA 31281 AP _______________ Account: 135-55030-033-000 Software & Support Totals: 5,036.41 29,833.45 ** 64,149.00 Budgeted 34,315.55 Remaining 47 % Used Account: 135-55070-033-000 Independent Labor 375.00 .00 375.00 _______________ Account: 135-55070-033-000 Independent Labor Totals: .00 375.00 ** 1,650.00 Budgeted 1,275.00 Remaining 23 % Used Account: 135-60005-033-000 Telephone 594 02/29/2012 Feb A/P Feb PCard-Zieverink 3,008.63 393.65 3,402.28 BANK OF AMERICA 31281 AP 594 02/29/2012 Feb A/P Feb PCard-Zieverink 369.80 3,772.08 BANK OF AMERICA 31281 AP _______________ Account: 135-60005-033-000 Telephone Totals: 763.45 3,772.08 ** 6,540.00 Budgeted 2,767.92 Remaining 58 % Used Account: 135-60235-033-000 Security .00 .00 _______________ Account: 135-60235-033-000 Security Totals: .00 .00 ** 1,350.00 Budgeted 1,350.00 Remaining 0 % Used Account: 135-65055-033-000 Hardware 477 02/16/2012 Feb A/P Head phones 60,135.96 78.40 60,214.36 SHI GOVERNMENT SOLUTIONS,INC 31259 AP 477 02/16/2012 Feb A/P Server UPS Harware, Printer su 189.26 60,403.62 SHI GOVERNMENT SOLUTIONS,INC 31259 AP 594 02/29/2012 Feb A/P Feb PCard-Pastor 45.21 60,448.83 BANK OF AMERICA 31281 AP 594 02/29/2012 Feb A/P Feb PCard-Pastor 7.74 60,456.57 BANK OF AMERICA 31281 AP 594 02/29/2012 Feb A/P Feb PCard-Pastor 111.27 60,567.84 BANK OF AMERICA 31281 AP 594 02/29/2012 Feb A/P Feb PCard-Zieverink 344.80 60,912.64 BANK OF AMERICA 31281 AP _______________ Account: 135-65055-033-000 Hardware Totals: 776.68 60,912.64 ** 83,238.00 Budgeted 22,325.36 Remaining 73 % Used . glpdatb2 rgonzale Trophy Club Entities Page 65 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 33 Information Systems Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65085-033-000 Office Supplies 529 02/27/2012 Feb A/P Blank DVDs for meetings 107.12 42.90 150.02 SHI GOVERNMENT SOLUTIONS,INC 31277 AP 594 02/29/2012 Feb A/P Feb PCard-Zieverink 26.91 176.93 BANK OF AMERICA 31281 AP _______________ Account: 135-65085-033-000 Office Supplies Totals: 69.81 176.93 ** 371.00 Budgeted 194.07 Remaining 48 % Used Account: 135-65090-033-000 Printer Supplies & Maintenance 477 02/16/2012 Feb A/P Printer supplies 2,756.88 142.50 2,899.38 SHI GOVERNMENT SOLUTIONS,INC 31259 AP 594 02/29/2012 Feb A/P Toner Cartridges 99.00 2,998.38 SHI GOVERNMENT SOLUTIONS,INC 31307 AP _______________ Account: 135-65090-033-000 Printer Supplies & Maintenance Totals: 241.50 2,998.38 ** 5,732.00 Budgeted 2,733.62 Remaining 52 % Used Account: 135-69170-033-000 Copier Lease Installments 477 02/16/2012 Feb A/P Copier leases 770.55 256.85 1,027.40 KYOCERA MITA AMERICA, INC. 31256 AP _______________ Account: 135-69170-033-000 Copier Lease Installments Totals: 256.85 1,027.40 ** 3,450.00 Budgeted 2,422.60 Remaining 30 % Used Account: 135-69195-033-000 Gasb34/Reserve for Replacement .00 .00 _______________ Account: 135-69195-033-000 Gasb34/Reserve for Replacement Totals: .00 .00 ** 26,911.00 Budgeted 26,911.00 Remaining 0 % Used Department 33 Totals: ------------------------------------------------------------------------------------------------ 99,095.88 ** 193,391.00 Budgeted 94,295.12 Remaining 51 % Used . glpdatb2 rgonzale Trophy Club Entities Page 66 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 37 Facilities Maintenance Program: Period Ending: 2/2012 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-037-000 Workman's Compensation 861.00 .00 861.00 _______________ Account: 135-50045-037-000 Workman's Compensation Totals: .00 861.00 ** .00 Budgeted (861.00) Remaining 0 % Used Account: 135-55100-037-000 Building Maint & Supplies 491.68 .00 491.68 _______________ Account: 135-55100-037-000 Building Maint & Supplies Totals: .00 491.68 ** 29,577.00 Budgeted 29,085.32 Remaining 2 % Used Account: 135-55120-037-000 Cleaning Services 5,840.61 .00 5,840.61 _______________ Account: 135-55120-037-000 Cleaning Services Totals: .00 5,840.61 ** 25,000.00 Budgeted 19,159.39 Remaining 23 % Used Account: 135-60020-037-000 Electricity 529 02/27/2012 Feb A/P Electricity 12/14-1/17 2,693.25 1,341.96 4,035.21 DIRECT ENERGY BUSINESS SVCS 31269 AP _______________ Account: 135-60020-037-000 Electricity Totals: 1,341.96 4,035.21 ** 21,940.00 Budgeted 17,904.79 Remaining 18 % Used Account: 135-60025-037-000 Water 203.72 .00 203.72 _______________ Account: 135-60025-037-000 Water Totals: .00 203.72 ** 1,093.00 Budgeted 889.28 Remaining 19 % Used Account: 135-60030-037-000 Rent And/Or Usage 436 02/09/2012 Feb A/P Invoices Public Services Building rent 4,394.04 1,098.51 5,492.55 TOWN OF TROPHY CLUB 31248 AP _______________ Account: 135-60030-037-000 Rent And/Or Usage Totals: 1,098.51 5,492.55 ** 13,182.00 Budgeted 7,689.45 Remaining 42 % Used Account: 135-60055-037-000 Insurance . glpdatb2 rgonzale Trophy Club Entities Page 67 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 37 Facilities Maintenance Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 28,589.50 .00 28,589.50 _______________ Account: 135-60055-037-000 Insurance Totals: .00 28,589.50 ** 32,635.00 Budgeted 4,045.50 Remaining 88 % Used Account: 135-60360-037-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-037-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-65095-037-000 Maintenance Supplies 594 02/29/2012 Feb A/P Feb Purchases 568.29 17.03 585.32 COSTCO WHOLESALE 31283 AP 594 02/29/2012 Feb A/P Feb Purchases 33.60 618.92 COSTCO WHOLESALE 31283 AP _______________ Account: 135-65095-037-000 Maintenance Supplies Totals: 50.63 618.92 ** 2,205.00 Budgeted 1,586.08 Remaining 28 % Used Account: 135-65097-037-000 Vending Machine Supplies 76.03 .00 76.03 _______________ Account: 135-65097-037-000 Vending Machine Supplies Totals: .00 76.03 ** 1,000.00 Budgeted 923.97 Remaining 8 % Used Department 37 Totals: ------------------------------------------------------------------------------------------------ 46,209.22 ** 129,132.00 Budgeted 82,922.78 Remaining 36 % Used . glpdatb2 rgonzale Trophy Club Entities Page 68 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 2/2012 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-038-000 Salaries & Wages 400 02/03/2012 PAYROLL 2/3/12 Salaries & Wages 24,641.28 3,284.64 27,925.92 PR 474 02/17/2012 PAYROLL 2/17/12 Salaries & Wages 3,264.26 31,190.18 PR _______________ Account: 135-50005-038-000 Salaries & Wages Totals: 6,548.90 31,190.18 ** 84,946.00 Budgeted 53,755.82 Remaining 37 % Used Account: 135-50010-038-000 Overtime 400 02/03/2012 PAYROLL 2/3/12 Overtime 185.05 6.14 191.19 PR 474 02/17/2012 PAYROLL 2/17/12 Overtime 14.71 205.90 PR _______________ Account: 135-50010-038-000 Overtime Totals: 20.85 205.90 ** 2,000.00 Budgeted 1,794.10 Remaining 10 % Used Account: 135-50016-038-000 Longevity 220.00 .00 220.00 _______________ Account: 135-50016-038-000 Longevity Totals: .00 220.00 ** 220.00 Budgeted .00 Remaining 100 % Used Account: 135-50020-038-000 Retirement 400 02/03/2012 PAYROLL 2/3/12 Retirement 3,757.19 454.78 4,211.97 PR 474 02/17/2012 PAYROLL 2/17/12 Retirement 453.17 4,665.14 PR _______________ Account: 135-50020-038-000 Retirement Totals: 907.95 4,665.14 ** 12,203.00 Budgeted 7,537.86 Remaining 38 % Used Account: 135-50026-038-000 Medical Insurance 400 02/03/2012 PAYROLL 2/3/12 Medical Insurance 3,697.06 462.17 4,159.23 PR 474 02/17/2012 PAYROLL 2/17/12 Medical Insurance 461.89 4,621.12 PR _______________ Account: 135-50026-038-000 Medical Insurance Totals: 924.06 4,621.12 ** 12,321.00 Budgeted 7,699.88 Remaining 38 % Used Account: 135-50027-038-000 Dental Insurance 400 02/03/2012 PAYROLL 2/3/12 Dental Insurance 366.59 45.83 412.42 PR 474 02/17/2012 PAYROLL 2/17/12 Dental Insurance 45.81 458.23 PR . glpdatb2 rgonzale Trophy Club Entities Page 69 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50027-038-000 Dental Insurance Totals: 91.64 458.23 ** 1,026.00 Budgeted 567.77 Remaining 45 % Used Account: 135-50028-038-000 Vision Insurance 400 02/03/2012 PAYROLL 2/3/12 Vision Insurance 86.50 10.82 97.32 PR 474 02/17/2012 PAYROLL 2/17/12 Vision Insurance 10.81 108.13 PR _______________ Account: 135-50028-038-000 Vision Insurance Totals: 21.63 108.13 ** 260.00 Budgeted 151.87 Remaining 42 % Used Account: 135-50029-038-000 Life Insurance & Other .00 .00 _______________ Account: 135-50029-038-000 Life Insurance & Other Totals: .00 .00 ** 604.00 Budgeted 604.00 Remaining 0 % Used Account: 135-50030-038-000 Social Security Taxes 400 02/03/2012 PAYROLL 2/3/12 Social Security Taxes 1,511.92 186.15 1,698.07 PR 474 02/17/2012 PAYROLL 2/17/12 Social Security Taxes 185.45 1,883.52 PR _______________ Account: 135-50030-038-000 Social Security Taxes Totals: 371.60 1,883.52 ** 5,404.00 Budgeted 3,520.48 Remaining 35 % Used Account: 135-50035-038-000 Medicare Taxes 400 02/03/2012 PAYROLL 2/3/12 Medicare Taxes 353.59 43.55 397.14 PR 474 02/17/2012 PAYROLL 2/17/12 Medicare Taxes 43.37 440.51 PR _______________ Account: 135-50035-038-000 Medicare Taxes Totals: 86.92 440.51 ** 1,264.00 Budgeted 823.49 Remaining 35 % Used Account: 135-50040-038-000 Unemployment Taxes 400 02/03/2012 PAYROLL 2/3/12 Unemployment Taxes 63.10 26.32 89.42 PR 474 02/17/2012 PAYROLL 2/17/12 Unemployment Taxes 26.24 115.66 PR _______________ Account: 135-50040-038-000 Unemployment Taxes Totals: 52.56 115.66 ** 473.00 Budgeted 357.34 Remaining 24 % Used . glpdatb2 rgonzale Trophy Club Entities Page 70 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 2/2012 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-038-000 Workman's Compensation 235.00 .00 235.00 _______________ Account: 135-50045-038-000 Workman's Compensation Totals: .00 235.00 ** 211.00 Budgeted (24.00) Remaining 111 % Used Account: 135-55070-038-000 Independent Labor .00 .00 _______________ Account: 135-55070-038-000 Independent Labor Totals: .00 .00 ** 800.00 Budgeted 800.00 Remaining 0 % Used Account: 135-55205-038-000 Utility Billing Contract 594 02/29/2012 Feb A/P Feb Utility billing 3,967.31 1,141.47 5,108.78 CSG SYSTEMS, INC. 31284 AP _______________ Account: 135-55205-038-000 Utility Billing Contract Totals: 1,141.47 5,108.78 ** 11,000.00 Budgeted 5,891.22 Remaining 46 % Used Account: 135-60005-038-000 Telephone 594 02/29/2012 Feb A/P Feb PCard-Zieverink 31.21 6.84 38.05 BANK OF AMERICA 31281 AP _______________ Account: 135-60005-038-000 Telephone Totals: 6.84 38.05 ** 100.00 Budgeted 61.95 Remaining 38 % Used Account: 135-60010-038-000 Communications/Pagers/Mobiles 594 02/29/2012 Feb A/P 1/23-2/22 Mobiles 142.04 36.88 178.92 VERIZON WIRELESS 31316 AP _______________ Account: 135-60010-038-000 Communications/Pagers/Mobiles Totals: 36.88 178.92 ** 472.00 Budgeted 293.08 Remaining 38 % Used Account: 135-60035-038-000 Postage 594 02/29/2012 Feb A/P Feb Utility billing 5,631.91 1,468.23 7,100.14 CSG SYSTEMS, INC. 31284 AP _______________ Account: 135-60035-038-000 Postage Totals: 1,468.23 7,100.14 ** 18,000.00 Budgeted 10,899.86 Remaining 39 % Used Account: 135-60040-038-000 Service Charges & Fees . glpdatb2 rgonzale Trophy Club Entities Page 71 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 580 02/02/2012 Credit Card/Online fees 11,151.96 24.04 11,176.00 GL 580 02/02/2012 Credit Card/Online fees 34.60 11,210.60 GL 580 02/02/2012 Credit Card/Online fees 35.00 11,245.60 GL 580 02/02/2012 Credit Card/Online fees 9.99 11,255.59 GL 580 02/02/2012 Credit Card/Online fees 1,852.08 13,107.67 GL _______________ Account: 135-60040-038-000 Service Charges & Fees Totals: 1,955.71 13,107.67 ** 18,000.00 Budgeted 4,892.33 Remaining 73 % Used Account: 135-60070-038-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-038-000 Dues & Memberships Totals: .00 .00 ** 71.00 Budgeted 71.00 Remaining 0 % Used Account: 135-60080-038-000 Schools & Training .00 .00 _______________ Account: 135-60080-038-000 Schools & Training Totals: .00 .00 ** 800.00 Budgeted 800.00 Remaining 0 % Used Account: 135-60100-038-000 Travel & per diem .00 .00 _______________ Account: 135-60100-038-000 Travel & per diem Totals: .00 .00 ** 605.00 Budgeted 605.00 Remaining 0 % Used Account: 135-60130-038-000 Reg Assessment Fee (5%) 25,071.20 .00 25,071.20 _______________ Account: 135-60130-038-000 Reg Assessment Fee (5%) Totals: .00 25,071.20 ** 22,500.00 Budgeted (2,571.20) Remaining 111 % Used Account: 135-60245-038-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-038-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club Entities Page 72 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65085-038-000 Office Supplies 529 02/27/2012 Feb A/P New credit card machine for fr 145.06 512.51 657.57 CENTURY BANKCARD SVCS TX LLC 31266 AP _______________ Account: 135-65085-038-000 Office Supplies Totals: 512.51 657.57 ** 700.00 Budgeted 42.43 Remaining 94 % Used Account: 135-65105-038-000 Printing .00 .00 _______________ Account: 135-65105-038-000 Printing Totals: .00 .00 ** 3,250.00 Budgeted 3,250.00 Remaining 0 % Used Department 38 Totals: ------------------------------------------------------------------------------------------------ 95,405.72 ** 197,430.00 Budgeted 102,024.28 Remaining 48 % Used . glpdatb2 rgonzale Trophy Club Entities Page 73 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 2/2012 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 594 02/29/2012 Feb A/P February legal 33,186.89 3,661.50 36,848.39 THE LISTON LAW FIRM, P.C. 31312 AP _______________ Account: 135-55045-039-000 Legal Totals: 3,661.50 36,848.39 ** 55,000.00 Budgeted 18,151.61 Remaining 67 % Used Account: 135-55055-039-000 Auditing 20,200.00 .00 20,200.00 _______________ Account: 135-55055-039-000 Auditing Totals: .00 20,200.00 ** 20,200.00 Budgeted .00 Remaining 100 % Used Account: 135-55060-039-000 Appraisal 8,533.65 .00 8,533.65 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 8,533.65 ** 20,000.00 Budgeted 11,466.35 Remaining 43 % Used Account: 135-55065-039-000 Tax Admin Fees 529 02/27/2012 Feb A/P Tax statements mailed 2,451.63 18.46 2,470.09 DENTON COUNTY TAX OFFICE 31267 AP _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: 18.46 2,470.09 ** 3,629.00 Budgeted 1,158.91 Remaining 68 % Used Account: 135-60344-039-000 Intergov Trans Out (Fire CIP) 2,277.85 .00 2,277.85 _______________ Account: 135-60344-039-000 Intergov Trans Out (Fire CIP) Totals: .00 2,277.85 ** .00 Budgeted (2,277.85) Remaining 0 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 70,329.98 ** 98,829.00 Budgeted 28,499.02 Remaining 71 % Used Fund 135 Totals: ------------------------------------------------------------------------------------------------------ (335,110.21) .00 Budgeted 335,110.21 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club Entities Page 74 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 2/2012 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 424 02/01/2012 Property Taxes (480,850.76) (2,103.84) (482,954.60) GL 429 02/02/2012 Property Taxes (16,979.74) (499,934.34) GL 431 02/03/2012 Property Taxes (10,713.03) (510,647.37) GL 545 02/06/2012 Property Taxes (7,580.16) (518,227.53) GL 546 02/07/2012 Property Taxes (5,281.39) (523,508.92) GL 547 02/08/2012 Property Taxes (555.35) (524,064.27) GL 548 02/09/2012 Property Taxes (816.81) (524,881.08) GL 549 02/10/2012 Property Taxes (3,553.45) (528,434.53) GL 550 02/14/2012 Property Taxes (223.39) (528,657.92) GL 551 02/16/2012 Property Taxes (375.86) (529,033.78) GL 553 02/21/2012 Property Taxes (535.97) (529,569.75) GL 554 02/22/2012 Property Taxes (221.13) (529,790.88) GL 555 02/23/2012 Property Taxes (83.09) (529,873.97) GL 557 02/27/2012 Property Taxes (144.34) (530,018.31) GL 601 02/28/2012 Property Taxes (1,351.03) (531,369.34) GL 602 02/29/2012 Property Taxes (637.62) (532,006.96) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (51,156.20) (532,006.96) ** (546,716.00) Budgeted (14,709.04) Remaining 97 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 429 02/02/2012 Property Taxes 3,379.61 19.24 3,398.85 GL 546 02/07/2012 Property Taxes (.10) 3,398.75 GL 547 02/08/2012 Property Taxes (107.38) 3,291.37 GL 556 02/24/2012 Property Taxes (143.49) 3,147.88 GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (231.73) 3,147.88 ** (3,947.00) Budgeted (7,094.88) Remaining -80 % Used Account: 533-40015-000-000 Property Taxes/P & I 424 02/01/2012 Property Taxes (586.68) (3.26) (589.94) GL 546 02/07/2012 Property Taxes (3.92) (593.86) GL 547 02/08/2012 Property Taxes (93.90) (687.76) GL 548 02/09/2012 Property Taxes (50.11) (737.87) GL 549 02/10/2012 Property Taxes (18.15) (756.02) GL 550 02/14/2012 Property Taxes (15.65) (771.67) GL 551 02/16/2012 Property Taxes (26.31) (797.98) GL 553 02/21/2012 Property Taxes (37.52) (835.50) GL 554 02/22/2012 Property Taxes (15.48) (850.98) GL 555 02/23/2012 Property Taxes (5.81) (856.79) GL . glpdatb2 rgonzale Trophy Club Entities Page 75 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 2/2012 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 556 02/24/2012 Property Taxes (586.68) (35.88) (892.67) GL 557 02/27/2012 Property Taxes (7.79) (900.46) GL 601 02/28/2012 Property Taxes (94.57) (995.03) GL 602 02/29/2012 Property Taxes (44.64) (1,039.67) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (452.99) (1,039.67) ** (5,017.00) Budgeted (3,977.33) Remaining 21 % Used Account: 533-48005-000-000 Utility Fees (6,120.00) .00 (6,120.00) _______________ Account: 533-48005-000-000 Utility Fees Totals: .00 (6,120.00) ** (6,120.00) Budgeted .00 Remaining 100 % Used Account: 533-49010-000-000 Interest Income 616 02/29/2012 Feb Bank Interest (64.79) (43.55) (108.34) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (43.55) (108.34) ** (500.00) Budgeted (391.66) Remaining 22 % Used Account: 533-49015-000-000 Lease/Rental Income 618 02/29/2012 FD Rent Transfer to M1 I&S (308,000.00) (308,000.00) GL _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: (308,000.00) (308,000.00) ** (308,000.00) Budgeted .00 Remaining 100 % Used Department Totals: ------------------------------------------------------------------------------------------------ (844,127.09) ** (870,300.00) Budgeted (26,172.91) Remaining 97 % Used . glpdatb2 rgonzale Trophy Club Entities Page 76 16:24 03/09/12 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 2/2012 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 581 02/16/2012 Series 2010/Adm fees MUD1 Series 2010 500.00 500.00 GL _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: 500.00 500.00 ** 4,000.00 Budgeted 3,500.00 Remaining 13 % Used Account: 533-70025-051-000 Bond Interest Expense 588 02/28/2012 Bond/CO Interest payments M2 REF CIB SER 05 34,342.50 34,342.50 GL 588 02/28/2012 Bond/CO Interest payments M1 UT BONDS, 2010 40,366.25 74,708.75 GL 588 02/28/2012 Bond/CO Interest payments M2 UT BD 2002 59,333.75 134,042.50 GL 588 02/28/2012 Bond/CO Interest payments M2 SERIES 2003 16,607.50 150,650.00 GL _______________ Account: 533-70025-051-000 Bond Interest Expense Totals: 150,650.00 150,650.00 ** 301,300.00 Budgeted 150,650.00 Remaining 50 % Used Account: 533-70035-051-000 Bond Principal Payment .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment Totals: .00 .00 ** 565,000.00 Budgeted 565,000.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ 151,150.00 ** 870,300.00 Budgeted 719,150.00 Remaining 17 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (692,977.09) .00 Budgeted 692,977.09 Remaining 0 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- (1,646,527.56) **** .00 Budgeted 1,646,527.56 Remaining 0 % Used ******* End of Report ********* . glbase_tbam rgonzale Trophy Club Entities Page 1 16:23 03/09/12 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 2/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 193,233.00- 193,233.00- 17,744.79- 183,863.16- 95.151 9,369.84- 122-40003-000-000 Emer Svcs Assessmen/Delinquent 4,900.00- 4,856.69- 99.116 43.31- 122-40010-000-000 Property Taxes/MUD Fire 1,076,976.00- 1,076,976.00- 100,050.18- 1,040,488.55- 96.612 36,487.45- 122-40011-000-000 Property Taxes/Fire-Delinquent 5,603.00- 246.07- 5,271.08 -94.076 10,874.08- 122-40015-000-000 Property Taxes/Assessments P&I 725.00- 72.65- 773.65- 106.710 48.65 122-40020-000-000 Property Taxes/Fire P&I 7,500.00- 7,500.00- 779.41- 1,265.77- 16.877 6,234.23- Subtotal: 1,277,709.00- 1,288,937.00- 118,893.10- 1,225,976.74- 95.115 62,960.26- 122-42014-000-000 Fire Permits/Sprinkler 2,000.00- 1,200.00- 5,600.00- 280.000 3,600.00 Subtotal: 2,000.00- 1,200.00- 5,600.00- 280.000 3,600.00 122-43400-000-000 Fire Inspections 500.00- 225.00- 1,050.00- 210.000 550.00 122-43415-000-000 Denton/Tarrant Cty Pledge-Fire 10,000.00- 10,000.00- 10,000.00- 100.000 122-43599-000-000 Misc Fire Revenue 1,124.00- 1,124.00- 1,124.00- Subtotal: 11,124.00- 11,624.00- 225.00- 11,050.00- 95.062 574.00- 122-49035-000-000 Prior Year Reserves 23,101.00- 4,373.00- 4,373.00- 122-49900-000-000 Miscellaneous Income 5,000.00- 2,021.95- 8,396.95- 167.939 3,396.95 Subtotal: 23,101.00- 9,373.00- 2,021.95- 8,396.95- 89.587 976.05- Program number: 1,311,934.00- 1,311,934.00- 122,340.05- 1,251,023.69- 95.357 60,910.31- Department number: Fire Revenues 1,311,934.00- 1,311,934.00- 122,340.05- 1,251,023.69- 95.357 60,910.31- Revenues Subtotal ----------- 1,311,934.00- 1,311,934.00- 122,340.05- 1,251,023.69- 95.357 60,910.31- . glbase_tbam rgonzale Trophy Club Entities Page 2 16:23 03/09/12 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 425,748.00 425,748.00 32,945.13 155,022.70 36.412 270,725.30 122-50010-045-000 Overtime 42,000.00 42,000.00 2,850.32 19,822.65 47.197 22,177.35 122-50011-045-000 DPS Holiday Pay 12,133.00 12,133.00 13,773.02 113.517 1,640.02- 122-50016-045-000 Longevity 3,647.00 3,647.00 3,714.46 101.850 67.46- 122-50017-045-000 Certification 4,073.00 4,073.00 494.70 2,558.50 62.816 1,514.50 122-50020-045-000 Retirement 68,264.00 68,264.00 4,630.34 27,337.66 40.047 40,926.34 122-50026-045-000 Medical Insurance 53,184.00 53,184.00 3,340.85 16,699.14 31.399 36,484.86 122-50027-045-000 Dental Insurance 3,288.00 3,288.00 291.97 1,459.35 44.384 1,828.65 122-50028-045-000 Vision Insurance 857.00 857.00 65.97 329.67 38.468 527.33 122-50029-045-000 Life Insurance & Other 2,740.00 2,740.00 2,740.00 122-50030-045-000 Social Security Taxes 30,231.00 30,231.00 2,063.67 11,648.00 38.530 18,583.00 122-50035-045-000 Medicare Taxes 7,070.00 7,070.00 482.66 2,724.26 38.533 4,345.74 122-50040-045-000 Unemployment Taxes 1,476.00 1,476.00 203.63 557.71 37.785 918.29 122-50045-045-000 Workman's Compensation 8,793.00 8,793.00 8,309.50 94.501 483.50 122-50060-045-000 Pre-employment Physicals/Test 675.00 675.00 52.45 7.770 622.55 Subtotal: 664,179.00 664,179.00 47,369.24 264,009.07 39.750 400,169.93 122-55080-045-000 Maintenance & Repairs 9,562.00 9,562.00 244.00 1,228.21 12.845 8,333.79 122-55090-045-000 Vehicle Maintenance 14,850.00 14,850.00 1,544.01 1,800.22 12.123 13,049.78 122-55095-045-000 Equipment Maintenance 9,808.00 9,808.00 2,987.24 4,137.18 42.182 5,670.82 122-55100-045-000 Building Maintenance 11,000.00 11,000.00 20.00 2,655.03 24.137 8,344.97 122-55110-045-000 Maintenance-Radios 1,103.00 1,103.00 1,103.00 122-55160-045-000 Professional Outside Services 20,000.00 20,000.00 20,000.00 Subtotal: 66,323.00 66,323.00 4,795.25 9,820.64 14.807 56,502.36 122-60005-045-000 Telephone 106.00 106.00 1.33 22.28 21.019 83.72 122-60010-045-000 Communications/Pagers/Mobiles 4,411.00 4,411.00 192.46 1,018.17 23.083 3,392.83 122-60020-045-000 Electricity/Gas 18,270.00 18,270.00 1,014.07 4,903.03 26.837 13,366.97 122-60025-045-000 Water 3,289.00 3,289.00 1,384.50 42.095 1,904.50 122-60030-045-000 Rent And/Or Usage 308,000.00 308,000.00 308,000.00 308,000.00 100.000 122-60035-045-000 Postage 97.00 97.00 12.35 12.732 84.65 122-60055-045-000 Insurance 20,974.00 20,974.00 8,078.00 38.514 12,896.00 122-60066-045-000 Publications/Books/Subscrips 401.00 401.00 401.00 122-60070-045-000 Dues & Memberships 8,560.00 8,560.00 6,130.34 71.616 2,429.66 122-60075-045-000 Meetings 22.00 22.00 22.00- 122-60080-045-000 Schools & Training 6,946.00 6,946.00 1,112.47 16.016 5,833.53 122-60096-045-000 Emergency Management 1,000.00 1,000.00 1,000.00 100.000 122-60100-045-000 Travel & per diem 6,788.00 6,788.00 1,632.43 24.049 5,155.57 122-60110-045-000 Physicals/Testing 1,918.00 1,918.00 1,918.00 122-60125-045-000 Advertising 156.00 156.00 156.00 122-60160-045-000 Programs & Special Projects 4,162.00 4,162.00 721.95 1,834.11 44.068 2,327.89 122-60180-045-000 Fire Inspection/Enforcement 1,900.00 1,900.00 24.58 385.58 20.294 1,514.42 . glbase_tbam rgonzale Trophy Club Entities Page 3 16:23 03/09/12 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 2/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60195-045-000 Flags & Repair 2,543.00 2,543.00 150.00 552.50 21.726 1,990.50 122-60245-045-000 Miscellaneous Expense 1,237.00 1,237.00 541.42 43.769 695.58 Subtotal: 390,758.00 390,758.00 310,126.39 336,629.18 86.148 54,128.82 122-65005-045-000 Fuel & Lube 17,414.00 17,414.00 77.87 1,432.16 8.224 15,981.84 122-65010-045-000 Uniforms 4,357.00 4,357.00 651.10 1,057.60 24.274 3,299.40 122-65015-045-000 Protective Clothing 7,600.00 7,600.00 83.50 1.099 7,516.50 122-65030-045-000 Chemicals 1,545.00 1,545.00 1,545.00 122-65035-045-000 Small Tools 8,371.00 8,371.00 469.96 5.614 7,901.04 122-65085-045-000 Office Supplies 329.00 329.00 3.60 632.64 192.292 303.64- 122-65095-045-000 Maintenance Supplies 2,785.00 2,785.00 811.74 29.147 1,973.26 122-65105-045-000 Printing 106.00 106.00 24.77 23.368 81.23 Subtotal: 42,507.00 42,507.00 732.57 4,512.37 10.616 37,994.63 122-69006-045-000 Grant Match 3,000.00 3,000.00 3,000.00 122-69035-045-000 Vehicles 13,709.00 13,709.00 1,870.74 13,260.52 96.729 448.48 122-69050-045-000 Radios 2,500.00 2,500.00 2,500.00 122-69195-045-000 GASB34/Reserve for Replacement 41,890.00 41,890.00 41,890.00 122-69251-045-000 Engine 681 Payment 73,203.00 73,203.00 4,351.65 4,351.65 5.945 68,851.35 122-69255-045-000 Airpacks 13,865.00 13,865.00 13,865.00 Subtotal: 148,167.00 148,167.00 6,222.39 17,612.17 11.887 130,554.83 Program number: 1,311,934.00 1,311,934.00 369,245.84 632,583.43 48.218 679,350.57 Department number: Fire 1,311,934.00 1,311,934.00 369,245.84 632,583.43 48.218 679,350.57 Expenditures Subtotal ----------- 1,311,934.00 1,311,934.00 369,245.84 632,583.43 48.218 679,350.57 Fund number: 122 Trophy Club MUD Fire Dept. 246,905.79 618,440.26- 618,440.26 . glbase_tbam rgonzale Trophy Club Entities Page 4 16:23 03/09/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 97,495.00- 97,495.00- 9,057.16- 94,191.59- 96.612 3,303.41- 135-40002-000-000 Property Taxes/Delinquent 451.00- 29.20- 641.37 -142.211 1,092.37- 135-40015-000-000 Property Taxes/P & I 1,334.00- 1,334.00- 143.54- 137.88 -10.336 1,471.88- Subtotal: 98,829.00- 99,280.00- 9,229.90- 93,412.34- 94.090 5,867.66- 135-43215-000-000 Insurance Settlement 3,999.00- 3,999.00 Subtotal: 3,999.00- 3,999.00 135-47000-000-000 Water 1,990,800.00- 1,990,800.00- 86,555.01- 476,328.67- 23.926 1,514,471.33- 135-47005-000-000 Sewer 1,325,000.00- 1,325,000.00- 72,355.82- 361,691.58- 27.297 963,308.42- 135-47010-000-000 Commercial Water 825,000.00- 825,000.00- 32,513.98- 237,668.26- 28.808 587,331.74- 135-47015-000-000 Commercial Sewer 360,000.00- 360,000.00- 20,476.55- 109,838.49- 30.511 250,161.51- 135-47020-000-000 Standby 775.00- 775.00- 60.00- 311.00- 40.129 464.00- 135-47025-000-000 Penalties 50,500.00- 50,500.00- 2,842.05- 23,711.02- 46.953 26,788.98- 135-47030-000-000 Service Charges 17,500.00- 17,500.00- 703.00- 6,689.38- 38.225 10,810.62- 135-47035-000-000 Plumbing Inspections 1,200.00- 1,200.00- 100.00- 850.00- 70.833 350.00- 135-47045-000-000 Sewer Inspections 4,500.00- 4,500.00- 300.00- 2,550.00- 56.667 1,950.00- 135-47070-000-000 TCCC Effluent Charges 57,500.00- 57,500.00- 8,212.62- 14.283 49,287.38- 135-47270-000-000 Fire Line 5,000.00- 5,000.00- 5,000.00- 135-47400-000-000 Water-Out of Dist/Port Meters 41,595.00- 41,595.00- 839.54- 16,062.10- 38.615 25,532.90- 135-47405-000-000 Out of District Sewer 11,807.00- 11,807.00- 53,282.71- 56,862.51- 481.600 45,055.51 135-47410-000-000 Out of Dist/Portable Penalties 300.00- 300.00- 28.31- 9.437 271.69- 135-47600-000-000 PID #1 Water 425,000.00- 425,000.00- 23,973.64- 150,324.52- 35.370 274,675.48- 135-47605-000-000 PID #1 Sewer 185,000.00- 185,000.00- 16,483.76- 85,926.87- 46.447 99,073.13- Subtotal: 5,301,477.00- 5,301,477.00- 310,486.06- 1,537,055.33- 28.993 3,764,421.67- 135-48005-000-000 Utility Fees 338,880.00- 338,880.00- 50,600.00- 315,880.00- 93.213 23,000.00- Subtotal: 338,880.00- 338,880.00- 50,600.00- 315,880.00- 93.213 23,000.00- 135-49005-000-000 Loan Proceeds 1,100,000.00- 1,100,000.00 135-49010-000-000 Interest Income 4,500.00- 4,500.00- 436.69- 1,875.65- 41.681 2,624.35- 135-49016-000-000 Cell Tower Revenue 10,164.00- 847.00- 4,235.00- 41.667 5,929.00- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 2,916.65- 41.666 4,083.35- 135-49030-000-000 Vending Revenue 600.00- 600.00- 32.50- 5.417 567.50- 135-49035-000-000 Prior Year Reserves 241,981.00- 265,707.00- 265,707.00- 135-49036-000-000 GASB Reserves 26,911.00- 26,911.00- 26,911.00- 135-49075-000-000 Oversize Meter Reimbursement 64,000.00- 64,000.00- 6,217.73- 49,237.80- 76.934 14,762.20- 135-49900-000-000 Miscellaneous Income 10,000.00- 10,000.00- 2,703.11- 27.031 7,296.89- 135-49905-000-000 Gas Well Revenue 800.00- 800.00- 123.00- 15.375 677.00- . glbase_tbam rgonzale Trophy Club Entities Page 5 16:23 03/09/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 2/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 355,792.00- 389,682.00- 8,084.75- 1,161,123.71- 297.967 771,441.71 Program number: 6,094,978.00- 6,129,319.00- 378,400.71- 3,111,470.38- 50.764 3,017,848.62- Department number: Revenues 6,094,978.00- 6,129,319.00- 378,400.71- 3,111,470.38- 50.764 3,017,848.62- Revenues Subtotal ----------- 6,094,978.00- 6,129,319.00- 378,400.71- 3,111,470.38- 50.764 3,017,848.62- . glbase_tbam rgonzale Trophy Club Entities Page 6 16:23 03/09/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 199,759.00 199,759.00 12,628.06 59,808.70 29.940 139,950.30 135-50010-010-000 Overtime 13,250.00 13,250.00 1,058.46 5,933.40 44.780 7,316.60 135-50016-010-000 Longevity 2,620.00 2,620.00 2,620.00 100.000 135-50017-010-000 Certification 1,800.00 1,800.00 150.00 750.00 41.667 1,050.00 135-50020-010-000 Retirement 25,508.00 25,508.00 1,912.21 10,166.85 39.857 15,341.15 135-50026-010-000 Medical Insurance 22,607.00 22,607.00 1,883.94 9,419.70 41.667 13,187.30 135-50027-010-000 Dental Insurance 2,169.00 2,169.00 134.28 671.40 30.954 1,497.60 135-50028-010-000 Vision Insurance 576.00 576.00 31.76 158.80 27.569 417.20 135-50029-010-000 Life Insurance & Other 1,161.00 1,161.00 1,161.00 135-50030-010-000 Social Security Taxes 13,481.00 13,481.00 804.61 4,227.58 31.360 9,253.42 135-50035-010-000 Medicare Taxes 3,153.00 3,153.00 188.17 988.70 31.357 2,164.30 135-50040-010-000 Unemployment Taxes 945.00 945.00 108.02 224.35 23.741 720.65 135-50045-010-000 Workman's Compensation 5,581.00 5,581.00 5,581.00 100.000 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 200.00 135-50070-010-000 Employee Relations 350.00 350.00 47.59 13.597 302.41 Subtotal: 293,160.00 293,160.00 18,899.51 100,598.07 34.315 192,561.93 135-55005-010-000 Engineering 1,500.00 1,500.00 1,500.00 135-55070-010-000 Independent Labor 500.00 500.00 500.00 135-55080-010-000 Maintenance & Repairs 29,500.00 29,500.00 9,264.71 31.406 20,235.29 135-55090-010-000 Vehicle Maintenance 3,380.00 3,380.00 1,889.77 55.910 1,490.23 135-55100-010-000 Building Maint & Supplies 750.00 750.00 471.85 62.913 278.15 135-55105-010-000 Maintenance-Backhoe/SkidLoader 2,900.00 2,900.00 450.00 15.517 2,450.00 135-55135-010-000 Lab Analysis 4,500.00 4,500.00 740.00 16.444 3,760.00 Subtotal: 43,030.00 43,030.00 12,816.33 29.785 30,213.67 135-60010-010-000 Communications/Pagers/Mobiles 1,599.00 1,599.00 185.18 828.66 51.824 770.34 135-60020-010-000 Electricity 162,000.00 162,000.00 1,832.32 22,368.19 13.808 139,631.81 135-60035-010-000 Postage 500.00 500.00 6.51 1.302 493.49 135-60050-010-000 Bad Debt Expense 4,200.00 4,200.00 4,200.00 135-60066-010-000 Publications/Books/Subscripts 50.00 50.00 50.00 135-60070-010-000 Dues & Memberships 150.00 150.00 150.00 135-60080-010-000 Schools & Training 2,800.00 2,800.00 761.00 27.179 2,039.00 135-60090-010-000 Safety Program 500.00 500.00 500.00 135-60100-010-000 Travel & per diem 3,200.00 3,200.00 100.47 677.15 21.161 2,522.85 135-60105-010-000 Rent/Lease Equipment 500.00 500.00 500.00 135-60135-010-000 Annual Permit Fee 6,600.00 6,600.00 7,965.75 120.693 1,365.75- 135-60150-010-000 Bulk Water 1,720,000.00 1,720,000.00 93,641.40 462,452.16 26.887 1,257,547.84 135-60245-010-000 Miscellaneous Expenses 1,000.00 1,000.00 1,000.00 135-60280-010-000 Property Maintenance 4,200.00 4,200.00 4,200.00 135-60285-010-000 Lawn Equipment & Maintenance 2,000.00 2,000.00 2,000.00 135-60360-010-000 Furniture/Equipment < $5000 1,500.00 1,500.00 299.99 19.999 1,200.01 . glbase_tbam rgonzale Trophy Club Entities Page 7 16:23 03/09/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 2/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 1,910,799.00 1,910,799.00 95,759.37 495,359.41 25.924 1,415,439.59 135-65005-010-000 Fuel & Lube 15,216.00 15,216.00 300.48 4,955.49 32.568 10,260.51 135-65010-010-000 Uniforms 3,690.00 3,690.00 1,024.15 27.755 2,665.85 135-65030-010-000 Chemicals 6,200.00 6,200.00 1,066.47 17.201 5,133.53 135-65035-010-000 Small Tools 2,500.00 2,500.00 68.00 2.720 2,432.00 135-65040-010-000 Safety Equipment 2,500.00 2,500.00 2,500.00 135-65050-010-000 Meter Expense 85,000.00 85,000.00 63,619.07 74.846 21,380.93 135-65055-010-000 Hardware 1,000.00 1,000.00 1,000.00 135-65095-010-000 Maintenance Supplies 32,000.00 32,000.00 72.49 10,222.57 31.946 21,777.43 135-65100-010-000 Copies 50.00 50.00 50.00 135-65105-010-000 Printing 150.00 150.00 58.50 39.000 91.50 Subtotal: 148,306.00 148,306.00 372.97 81,014.25 54.626 67,291.75 135-69005-010-000 Capital Expenses 888,432.00 888,432.00 77,958.95 915,566.14 103.054 27,134.14- 135-69035-010-000 Vehicles 27,000.00 27,000.00 29,838.69 30,213.69 111.903 3,213.69- 135-69195-010-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 30,000.00 135-69280-010-000 Capital Repairs 24,000.00 24,000.00 24,000.00 135-69281-010-000 Capital Repair-Ground Storage 124,771.00 124,771.00 100,816.54 80.801 23,954.46 135-69295-010-000 Unexpected Maintenance 250.00 250.00 250.00 135-69305-010-000 Capital Leases 11,490.00 11,490.00 11,490.00 Subtotal: 1,105,943.00 1,105,943.00 107,797.64 1,046,596.37 94.634 59,346.63 Program number: 3,501,238.00 3,501,238.00 222,829.49 1,736,384.43 49.593 1,764,853.57 Department number: Water 3,501,238.00 3,501,238.00 222,829.49 1,736,384.43 49.593 1,764,853.57 . glbase_tbam rgonzale Trophy Club Entities Page 8 16:23 03/09/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 182,147.00 182,147.00 14,117.02 77,913.05 42.775 104,233.95 135-50010-020-000 Overtime 10,166.00 10,166.00 1,017.85 4,980.92 48.996 5,185.08 135-50016-020-000 Longevity 3,976.00 3,976.00 3,975.00 99.975 1.00 135-50017-020-000 Certification 2,400.00 2,400.00 125.00 700.00 29.167 1,700.00 135-50020-020-000 Retirement 27,816.00 27,816.00 2,108.92 12,805.95 46.038 15,010.05 135-50026-020-000 Medical Insurance 30,805.00 30,805.00 2,145.38 10,657.76 34.598 20,147.24 135-50027-020-000 Dental Insurance 1,981.00 1,981.00 165.36 818.98 41.342 1,162.02 135-50028-020-000 Vision Insurance 552.00 552.00 41.20 203.96 36.949 348.04 135-50029-020-000 Life Insurance & Other 884.00 884.00 884.00 135-50030-020-000 Social Security Taxes 8,597.00 8,597.00 851.17 5,134.02 59.719 3,462.98 135-50035-020-000 Medicare Taxes 2,011.00 2,011.00 199.08 1,200.68 59.706 810.32 135-50040-020-000 Unemployment Taxes 567.00 567.00 119.84 267.66 47.206 299.34 135-50045-020-000 Workman's Compensation 2,685.00 2,685.00 2,685.00 100.000 135-50060-020-000 Pre-emp Physicals/Testing 200.00 30.45 15.225 169.55 135-50070-020-000 Employee Relations 350.00 350.00 20.00 5.714 330.00 Subtotal: 274,937.00 275,137.00 20,890.82 121,393.43 44.121 153,743.57 135-55070-020-000 Independent Labor 750.00 750.00 1,305.67 174.089 555.67- 135-55080-020-000 Maintenance & Repairs 17,750.00 17,750.00 15,278.10 86.074 2,471.90 135-55090-020-000 Vehicle Maintenance 4,998.00 4,998.00 194.95 194.95 3.901 4,803.05 135-55100-020-000 Building Maint & Supplies 1,400.00 1,400.00 1,400.00 135-55105-020-000 Maintenance-Backhoe/SkidLoader 2,950.00 2,950.00 134.00 4.542 2,816.00 135-55125-020-000 Dumpster Services 35,000.00 35,000.00 9,675.00 27.643 25,325.00 135-55135-020-000 Lab Analysis 22,760.00 22,760.00 590.75 4,440.57 19.510 18,319.43 Subtotal: 85,608.00 85,608.00 785.70 31,028.29 36.245 54,579.71 135-60005-020-000 Telephone 100.00 10.59 10.590 89.41 135-60010-020-000 Communications/Pagers/Mobiles 3,000.00 3,000.00 236.55 1,124.78 37.493 1,875.22 135-60020-020-000 Electricity 205,000.00 205,000.00 23,307.74 11.370 181,692.26 135-60025-020-000 Water 1,900.00 1,900.00 1,137.73 59.881 762.27 135-60035-020-000 Postage 120.00 120.00 120.00 135-60066-020-000 Publications/Books/Subscripts 500.00 500.00 438.17 87.634 61.83 135-60080-020-000 Schools & Training 1,320.00 1,320.00 1,320.00 135-60090-020-000 Safety Program 200.00 200.00 200.00 135-60100-020-000 Travel & per diem 1,750.00 1,750.00 139.86 745.92 42.624 1,004.08 135-60105-020-000 Rent/Lease Equipment 200.00 200.00 901.30 450.650 701.30- 135-60125-020-000 Advertising 1,000.00 987.36 98.736 12.64 135-60135-020-000 Annual Permit Fee 7,500.00 7,500.00 7,432.50 99.100 67.50 135-60245-020-000 Miscellaneous Expenses 525.00 525.00 64.00 12.190 461.00 135-60285-020-000 Lawn Equipment & Maintenance 525.00 525.00 525.00 Subtotal: 222,540.00 223,640.00 376.41 36,150.09 16.164 187,489.91 . glbase_tbam rgonzale Trophy Club Entities Page 9 16:23 03/09/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 2/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65005-020-000 Fuel & Lube 6,875.00 6,875.00 83.54 1,300.73 18.920 5,574.27 135-65010-020-000 Uniforms 3,140.00 3,140.00 916.93 29.202 2,223.07 135-65030-020-000 Chemicals 13,180.00 13,180.00 2,557.57 19.405 10,622.43 135-65035-020-000 Small Tools 1,260.00 1,260.00 1,260.00 135-65040-020-000 Safety Equipment 925.00 925.00 22.75 2.459 902.25 135-65045-020-000 Lab Supplies 19,160.00 19,160.00 2,699.84 14.091 16,460.16 135-65055-020-000 Hardware 525.00 525.00 525.00 135-65085-020-000 Office Supplies 400.00 400.00 50.58 12.645 349.42 135-65095-020-000 Maintenance Supplies 8,860.00 8,860.00 32.78 953.32 10.760 7,906.68 135-65115-020-000 Other Consumables 110.00 110.00 110.00 Subtotal: 54,435.00 54,435.00 116.32 8,501.72 15.618 45,933.28 135-69005-020-000 Capital Expenses 161,189.00 161,189.00 8,792.30 43,592.56 27.044 117,596.44 135-69280-020-000 Capital Repairs 56,000.00 56,000.00 56,000.00 Subtotal: 217,189.00 217,189.00 8,792.30 43,592.56 20.071 173,596.44 Program number: 854,709.00 856,009.00 30,961.55 240,666.09 28.115 615,342.91 Department number: Wastewater 854,709.00 856,009.00 30,961.55 240,666.09 28.115 615,342.91 . glbase_tbam rgonzale Trophy Club Entities Page 10 16:23 03/09/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 2/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-021-000 Salaries & Wages 145,481.00 145,481.00 11,082.16 52,639.80 36.183 92,841.20 135-50010-021-000 Overtime 7,297.00 7,297.00 546.23 3,421.19 46.885 3,875.81 135-50016-021-000 Longevity 3,548.00 3,548.00 3,547.50 99.986 .50 135-50017-021-000 Certification 1,500.00 1,500.00 125.00 625.00 41.667 875.00 135-50020-021-000 Retirement 21,074.00 21,074.00 1,624.33 8,869.26 42.086 12,204.74 135-50026-021-000 Medical Insurance 22,983.00 22,983.00 1,702.68 8,513.40 37.042 14,469.60 135-50027-021-000 Dental Insurance 1,533.00 1,533.00 117.38 586.90 38.284 946.10 135-50028-021-000 Vision Insurance 357.00 357.00 29.72 148.60 41.625 208.40 135-50029-021-000 Life Insurance & Other 978.00 978.00 978.00 135-50030-021-000 Social Security Taxes 9,785.00 9,785.00 669.74 3,623.61 37.032 6,161.39 135-50035-021-000 Medicare Taxes 2,288.00 2,288.00 156.63 847.46 37.039 1,440.54 135-50040-021-000 Unemployment Taxes 567.00 567.00 85.67 180.10 31.764 386.90 135-50045-021-000 Workman's Compensation 3,056.00 3,056.00 3,056.00 100.000 135-50070-021-000 Employee Relations 250.00 250.00 19.97 7.988 230.03 Subtotal: 220,697.00 220,697.00 16,139.54 86,078.79 39.003 134,618.21 135-55005-021-000 Engineering 1,500.00 1,500.00 1,500.00 135-55070-021-000 Independent Labor 200.00 200.00 200.00 135-55080-021-000 Maintenance & Repairs 23,700.00 23,700.00 720.00 3,535.85 14.919 20,164.15 135-55090-021-000 Vehicle Maintenance 1,943.00 1,943.00 130.00 6.691 1,813.00 135-55100-021-000 Building Maint & Supplies 750.00 750.00 750.00 Subtotal: 28,093.00 28,093.00 720.00 3,665.85 13.049 24,427.15 135-60005-021-000 Telephone 50.00 .74 11.92 23.840 38.08 135-60010-021-000 Communications/Pagers/Mobiles 2,796.00 2,796.00 204.24 1,544.59 55.243 1,251.41 135-60020-021-000 Electricity 23,625.00 23,625.00 1,199.77 3,441.42 14.567 20,183.58 135-60025-021-000 Water 750.00 750.00 750.00 135-60035-021-000 Postage 150.00 150.00 150.00 135-60070-021-000 Dues & Memberships 255.00 255.00 255.00 135-60080-021-000 Schools & Training 2,818.00 2,818.00 2,818.00 135-60090-021-000 Safety Program 750.00 750.00 750.00 135-60100-021-000 Travel & per diem 1,500.00 1,500.00 51.62 386.86 25.791 1,113.14 135-60105-021-000 Rent/Lease Equipment 44,107.00 76,098.00 76,098.00 135-60245-021-000 Miscellaneous Expenses 100.00 100.00 100.00 135-60280-021-000 Property Maintenance 1,000.00 1,000.00 1,000.00 Subtotal: 77,851.00 109,892.00 1,456.37 5,384.79 4.900 104,507.21 135-65005-021-000 Fuel & Lube 11,700.00 11,700.00 348.56 3,595.29 30.729 8,104.71 135-65010-021-000 Uniforms 2,505.00 2,505.00 620.98 24.790 1,884.02 135-65030-021-000 Chemicals 12,500.00 12,500.00 12,500.00 135-65035-021-000 Small Tools 1,500.00 1,500.00 1,500.00 . glbase_tbam rgonzale Trophy Club Entities Page 11 16:23 03/09/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 2/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65040-021-000 Safety Equipment 1,150.00 1,150.00 22.74 1.977 1,127.26 135-65055-021-000 Hardware 750.00 750.00 44.95 5.993 705.05 135-65095-021-000 Maintenance Supplies 16,050.00 16,050.00 65.76 204.14 1.272 15,845.86 Subtotal: 46,155.00 46,155.00 414.32 4,488.10 9.724 41,666.90 135-69005-021-000 Capital Expenses 15,000.00 15,000.00 31,991.00 213.273 16,991.00- 135-69280-021-000 Capital Repairs 20,000.00 20,000.00 20,000.00 Subtotal: 35,000.00 35,000.00 31,991.00 91.403 3,009.00 Program number: 407,796.00 439,837.00 18,730.23 131,608.53 29.922 308,228.47 Department number: Collection 407,796.00 439,837.00 18,730.23 131,608.53 29.922 308,228.47 . glbase_tbam rgonzale Trophy Club Entities Page 12 16:23 03/09/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 2/2012 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 700.00 3,000.00 30.000 7,000.00 135-50030-026-000 Social Security Taxes 620.00 620.00 43.40 186.00 30.000 434.00 135-50035-026-000 Medicare Taxes 145.00 145.00 10.15 43.50 30.000 101.50 135-50040-026-000 Unemployment Taxes 210.00 210.00 5.60 24.00 11.429 186.00 135-50045-026-000 Workman's Compensation 120.00 120.00 120.00 100.000 Subtotal: 11,095.00 11,095.00 759.15 3,373.50 30.406 7,721.50 135-60035-026-000 Postage 26.11 26.11- 135-60066-026-000 Publications/Books/Subscripts 50.00 50.00 50.00 135-60070-026-000 Dues & Memberships 2,100.00 2,100.00 685.00 32.619 1,415.00 135-60075-026-000 Meetings 1,278.00 1,278.00 44.00 218.82 17.122 1,059.18 135-60080-026-000 Schools & Training 4,150.00 4,150.00 875.00 21.084 3,275.00 135-60100-026-000 Travel & per diem 6,199.00 6,199.00 32.19 32.19 .519 6,166.81 135-60245-026-000 Miscellaneous Expenses 3,200.00 3,200.00 3,200.00 Subtotal: 16,977.00 16,977.00 76.19 1,837.12 10.821 15,139.88 135-65085-026-000 Office Supplies 50.00 50.00 8.90 17.800 41.10 Subtotal: 50.00 50.00 8.90 17.800 41.10 Program number: 28,122.00 28,122.00 835.34 5,219.52 18.560 22,902.48 Department number: Board of Directors 28,122.00 28,122.00 835.34 5,219.52 18.560 22,902.48 . glbase_tbam rgonzale Trophy Club Entities Page 13 16:23 03/09/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 2/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-027-000 Salaries & Wages 236,831.00 236,831.00 88,019.88 141,417.37 59.712 95,413.63 135-50010-027-000 Overtime 1,000.00 1,000.00 21.79 1,011.34 101.134 11.34- 135-50016-027-000 Longevity 1,845.00 1,845.00 1,860.00 3,705.00 200.813 1,860.00- 135-50020-027-000 Retirement 33,471.00 33,471.00 12,424.40 20,739.59 61.963 12,731.41 135-50026-027-000 Medical Insurance 18,798.00 18,798.00 2,393.90 7,591.54 40.385 11,206.46 135-50027-027-000 Dental Insurance 1,242.00 1,242.00 178.05 567.89 45.724 674.11 135-50028-027-000 Vision Insurance 341.00 341.00 43.84 142.41 41.762 198.59 135-50029-027-000 Life Insurance & Other 1,337.00 1,337.00 1,337.00 135-50030-027-000 Social Security Taxes 14,860.00 14,860.00 5,516.50 8,844.53 59.519 6,015.47 135-50035-027-000 Medicare Taxes 3,475.00 3,475.00 1,290.11 2,106.35 60.614 1,368.65 135-50040-027-000 Unemployment Taxes 756.00 756.00 72.03 208.02 27.516 547.98 135-50045-027-000 Workman's Compensation 580.00 580.00 580.00 100.000 135-50070-027-000 Employee Relations 5,000.00 5,000.00 3,368.76 67.375 1,631.24 Subtotal: 319,536.00 319,536.00 111,820.50 190,282.80 59.550 129,253.20 135-55070-027-000 Independent Labor 840.00 840.00 41.25 180.00 21.429 660.00 135-55075-027-000 Records Management 500.00 500.00 500.00 135-55160-027-000 Professional Outside Services 176,870.00 176,870.00 95,384.68 53.929 81,485.32 Subtotal: 178,210.00 178,210.00 41.25 95,564.68 53.625 82,645.32 135-60005-027-000 Telephone 300.00 300.00 19.72 97.30 32.433 202.70 135-60010-027-000 Communications/Pagers/Mobiles 2,420.00 2,420.00 143.21 965.91 39.914 1,454.09 135-60035-027-000 Postage 1,000.00 44.43 569.52 56.952 430.48 135-60066-027-000 Publications/Books/Subscripts 450.00 450.00 114.75 25.500 335.25 135-60070-027-000 Dues & Memberships 1,742.00 1,742.00 421.05 24.170 1,320.95 135-60075-027-000 Meetings 312.00 312.00 312.00 135-60080-027-000 Schools & Training 2,555.00 2,555.00 445.00 17.417 2,110.00 135-60100-027-000 Travel & per diem 3,851.00 3,851.00 127.87 3.320 3,723.13 135-60115-027-000 Elections 2,500.00 2,500.00 2,500.00 135-60125-027-000 Advertising 4,700.00 4,700.00 4,700.00 135-60245-027-000 Miscellaneous Expenses 100.00 100.00 100.00 135-60270-027-000 4th of July Celebration 10,000.00 10,000.00 10,000.00 10,000.00 100.000 135-60360-027-000 Furniture/Equipment < $5000 2,225.00 2,225.00 299.99 13.483 1,925.01 Subtotal: 31,155.00 32,155.00 10,207.36 13,041.39 40.558 19,113.61 135-65085-027-000 Office Supplies 2,450.00 2,450.00 158.87 701.28 28.624 1,748.72 135-65105-027-000 Printing 515.00 515.00 68.00 463.00 89.903 52.00 Subtotal: 2,965.00 2,965.00 226.87 1,164.28 39.267 1,800.72 Program number: 531,866.00 532,866.00 122,295.98 300,053.15 56.309 232,812.85 . glbase_tbam rgonzale Trophy Club Entities Page 14 16:23 03/09/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 2/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Department number: Manager's Office 531,866.00 532,866.00 122,295.98 300,053.15 56.309 232,812.85 . glbase_tbam rgonzale Trophy Club Entities Page 15 16:23 03/09/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 28 Human Resources Program: Period Ending: 2/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50070-028-000 Employee Relations 1,967.00 1,967.00 1,470.22 74.744 496.78 135-50075-028-000 Tuition Reimbursement 1,561.00 1,561.00 19.95 1.278 1,541.05 Subtotal: 3,528.00 3,528.00 1,490.17 42.238 2,037.83 135-60005-028-000 Telephone 28.00 28.00 28.00 135-60035-028-000 Postage 106.00 106.00 106.00 135-60066-028-000 Publications/Books/Subscripts 485.00 485.00 485.00 135-60070-028-000 Dues & Memberships 555.00 555.00 555.00 135-60075-028-000 Meetings 138.00 138.00 138.00 135-60080-028-000 Schools & Training 594.00 594.00 594.00 135-60100-028-000 Travel & per diem 8.00 8.00 8.00 135-60110-028-000 Physicals/Testing 1,560.00 1,560.00 105.00 6.731 1,455.00 Subtotal: 3,474.00 3,474.00 105.00 3.022 3,369.00 135-65085-028-000 Office Supplies 437.00 437.00 437.00 135-65105-028-000 Printing 116.00 116.00 116.00 Subtotal: 553.00 553.00 553.00 Program number: 7,555.00 7,555.00 1,595.17 21.114 5,959.83 Department number: Human Resources 7,555.00 7,555.00 1,595.17 21.114 5,959.83 . glbase_tbam rgonzale Trophy Club Entities Page 16 16:23 03/09/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 2/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-029-000 Salaries & Wages 94,404.00 94,404.00 5,884.62 33,194.56 35.162 61,209.44 135-50010-029-000 Overtime 1,000.00 1,000.00 946.28 94.628 53.72 135-50016-029-000 Longevity 1,823.00 1,823.00 1,822.50 99.973 .50 135-50020-029-000 Retirement 13,612.00 13,612.00 813.26 5,319.20 39.077 8,292.80 135-50026-029-000 Medical Insurance 11,060.00 11,060.00 410.70 3,721.08 33.644 7,338.92 135-50027-029-000 Dental Insurance 773.00 773.00 49.02 330.85 42.801 442.15 135-50028-029-000 Vision Insurance 207.00 207.00 6.76 53.87 26.024 153.13 135-50029-029-000 Life Insurance & Other 567.00 567.00 567.00 135-50030-029-000 Social Security Taxes 5,386.00 5,386.00 338.54 2,083.56 38.685 3,302.44 135-50035-029-000 Medicare Taxes 1,260.00 1,260.00 79.17 487.29 38.674 772.71 135-50040-029-000 Unemployment Taxes 284.00 284.00 24.92 79.54 28.007 204.46 135-50045-029-000 Workman's Compensation 235.00 235.00 211.00 89.787 24.00 Subtotal: 130,611.00 130,611.00 7,606.99 48,249.73 36.942 82,361.27 135-55160-029-000 Professional Outside Services 5,000.00 5,000.00 973.50 19.470 4,026.50 Subtotal: 5,000.00 5,000.00 973.50 19.470 4,026.50 135-60005-029-000 Telephone 103.00 103.00 4.96 36.33 35.272 66.67 135-60010-029-000 Communications/Pagers/Mobiles 683.00 683.00 51.86 253.68 37.142 429.32 135-60035-029-000 Postage 700.00 700.00 96.99 13.856 603.01 135-60040-029-000 Service Charges & Fees 79.00 79.00 32.50 41.139 46.50 135-60066-029-000 Publications/Books/Subscripts 500.00 500.00 500.00 135-60070-029-000 Dues & Memberships 660.00 660.00 660.00 135-60075-029-000 Meetings 300.00 300.00 22.00 7.333 278.00 135-60080-029-000 Schools & Training 2,000.00 2,000.00 2,000.00 135-60100-029-000 Travel & per diem 1,500.00 1,500.00 12.77 27.81 1.854 1,472.19 135-60125-029-000 Advertising 1,210.00 1,210.00 1,210.00 135-60245-029-000 Miscellaneous Expenses 200.00 200.00 200.00 Subtotal: 7,935.00 7,935.00 69.59 469.31 5.914 7,465.69 135-65085-029-000 Office Supplies 849.00 849.00 21.46 99.94 11.771 749.06 135-65105-029-000 Printing 515.00 515.00 515.00 Subtotal: 1,364.00 1,364.00 21.46 99.94 7.327 1,264.06 Program number: 144,910.00 144,910.00 7,698.04 49,792.48 34.361 95,117.52 Department number: Finance 144,910.00 144,910.00 7,698.04 49,792.48 34.361 95,117.52 . glbase_tbam rgonzale Trophy Club Entities Page 17 16:23 03/09/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 33 Information Systems Program: Period Ending: 2/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55030-033-000 Software & Support 64,149.00 64,149.00 5,036.41 29,833.45 46.506 34,315.55 135-55070-033-000 Independent Labor 1,650.00 1,650.00 375.00 22.727 1,275.00 Subtotal: 65,799.00 65,799.00 5,036.41 30,208.45 45.910 35,590.55 135-60005-033-000 Telephone 6,540.00 6,540.00 763.45 3,772.08 57.677 2,767.92 135-60235-033-000 Security 1,350.00 1,350.00 1,350.00 Subtotal: 7,890.00 7,890.00 763.45 3,772.08 47.808 4,117.92 135-65055-033-000 Hardware 83,238.00 83,238.00 776.68 60,912.64 73.179 22,325.36 135-65085-033-000 Office Supplies 371.00 371.00 69.81 176.93 47.690 194.07 135-65090-033-000 Printer Supplies & Maintenance 5,732.00 5,732.00 241.50 2,998.38 52.309 2,733.62 Subtotal: 89,341.00 89,341.00 1,087.99 64,087.95 71.734 25,253.05 135-69170-033-000 Copier Lease Installments 3,450.00 3,450.00 256.85 1,027.40 29.780 2,422.60 135-69195-033-000 Gasb34/Reserve for Replacement 26,911.00 26,911.00 26,911.00 Subtotal: 30,361.00 30,361.00 256.85 1,027.40 3.384 29,333.60 Program number: 193,391.00 193,391.00 7,144.70 99,095.88 51.241 94,295.12 Department number: Information Systems 193,391.00 193,391.00 7,144.70 99,095.88 51.241 94,295.12 . glbase_tbam rgonzale Trophy Club Entities Page 18 16:23 03/09/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 37 Facilities Maintenance Program: Period Ending: 2/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-037-000 Salaries & Wages 31,512.00 135-50020-037-000 Retirement 4,412.00 135-50026-037-000 Medical Insurance 9,027.00 135-50027-037-000 Dental Insurance 549.00 135-50028-037-000 Vision Insurance 138.00 135-50029-037-000 Life Insurance & Other 228.00 135-50030-037-000 Social Security Taxes 1,954.00 135-50035-037-000 Medicare Taxes 457.00 135-50040-037-000 Unemployment Taxes 189.00 135-50045-037-000 Workman's Compensation 861.00 861.00 861.00- 135-50060-037-000 Pre-emp Physicals/Testing 250.00 Subtotal: 49,577.00 861.00 861.00- 135-55100-037-000 Building Maint & Supplies 5,000.00 29,577.00 491.68 1.662 29,085.32 135-55120-037-000 Cleaning Services 25,000.00 5,840.61 23.362 19,159.39 Subtotal: 5,000.00 54,577.00 6,332.29 11.602 48,244.71 135-60020-037-000 Electricity 21,940.00 21,940.00 1,341.96 4,035.21 18.392 17,904.79 135-60025-037-000 Water 1,093.00 1,093.00 203.72 18.639 889.28 135-60030-037-000 Rent And/Or Usage 13,182.00 13,182.00 1,098.51 5,492.55 41.667 7,689.45 135-60055-037-000 Insurance 32,635.00 32,635.00 28,589.50 87.604 4,045.50 135-60360-037-000 Furniture/Equipment < $5000 2,500.00 2,500.00 2,500.00 Subtotal: 71,350.00 71,350.00 2,440.47 38,320.98 53.708 33,029.02 135-65095-037-000 Maintenance Supplies 2,205.00 2,205.00 50.63 618.92 28.069 1,586.08 135-65097-037-000 Vending Machine Supplies 1,000.00 1,000.00 76.03 7.603 923.97 Subtotal: 3,205.00 3,205.00 50.63 694.95 21.683 2,510.05 Program number: 129,132.00 129,132.00 2,491.10 46,209.22 35.784 82,922.78 Department number: Facilities Maintenance 129,132.00 129,132.00 2,491.10 46,209.22 35.784 82,922.78 . glbase_tbam rgonzale Trophy Club Entities Page 19 16:23 03/09/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 2/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-038-000 Salaries & Wages 84,946.00 84,946.00 6,548.90 31,190.18 36.718 53,755.82 135-50010-038-000 Overtime 2,000.00 2,000.00 20.85 205.90 10.295 1,794.10 135-50016-038-000 Longevity 220.00 220.00 220.00 100.000 135-50020-038-000 Retirement 12,203.00 12,203.00 907.95 4,665.14 38.229 7,537.86 135-50026-038-000 Medical Insurance 12,321.00 12,321.00 924.06 4,621.12 37.506 7,699.88 135-50027-038-000 Dental Insurance 1,026.00 1,026.00 91.64 458.23 44.662 567.77 135-50028-038-000 Vision Insurance 260.00 260.00 21.63 108.13 41.588 151.87 135-50029-038-000 Life Insurance & Other 604.00 604.00 604.00 135-50030-038-000 Social Security Taxes 5,404.00 5,404.00 371.60 1,883.52 34.854 3,520.48 135-50035-038-000 Medicare Taxes 1,264.00 1,264.00 86.92 440.51 34.850 823.49 135-50040-038-000 Unemployment Taxes 473.00 473.00 52.56 115.66 24.452 357.34 135-50045-038-000 Workman's Compensation 211.00 211.00 235.00 111.374 24.00- Subtotal: 120,932.00 120,932.00 9,026.11 44,143.39 36.503 76,788.61 135-55070-038-000 Independent Labor 800.00 800.00 800.00 135-55205-038-000 Utility Billing Contract 11,000.00 11,000.00 1,141.47 5,108.78 46.443 5,891.22 Subtotal: 11,800.00 11,800.00 1,141.47 5,108.78 43.295 6,691.22 135-60005-038-000 Telephone 100.00 100.00 6.84 38.05 38.050 61.95 135-60010-038-000 Communications/Pagers/Mobiles 472.00 472.00 36.88 178.92 37.907 293.08 135-60035-038-000 Postage 18,000.00 18,000.00 1,468.23 7,100.14 39.445 10,899.86 135-60040-038-000 Service Charges & Fees 18,000.00 18,000.00 1,955.71 13,107.67 72.820 4,892.33 135-60070-038-000 Dues & Memberships 71.00 71.00 71.00 135-60080-038-000 Schools & Training 800.00 800.00 800.00 135-60100-038-000 Travel & per diem 605.00 605.00 605.00 135-60130-038-000 Reg Assessment Fee (5%) 22,500.00 22,500.00 25,071.20 111.428 2,571.20- 135-60245-038-000 Miscellaneous Expenses 200.00 200.00 200.00 Subtotal: 60,748.00 60,748.00 3,467.66 45,495.98 74.893 15,252.02 135-65085-038-000 Office Supplies 700.00 700.00 512.51 657.57 93.939 42.43 135-65105-038-000 Printing 3,250.00 3,250.00 3,250.00 Subtotal: 3,950.00 3,950.00 512.51 657.57 16.647 3,292.43 Program number: 197,430.00 197,430.00 14,147.75 95,405.72 48.324 102,024.28 Department number: Utility Billing 197,430.00 197,430.00 14,147.75 95,405.72 48.324 102,024.28 . glbase_tbam rgonzale Trophy Club Entities Page 20 16:23 03/09/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 2/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 55,000.00 55,000.00 3,661.50 36,848.39 66.997 18,151.61 135-55055-039-000 Auditing 20,200.00 20,200.00 20,200.00 100.000 135-55060-039-000 Appraisal 20,000.00 20,000.00 8,533.65 42.668 11,466.35 135-55065-039-000 Tax Admin Fees 3,629.00 3,629.00 18.46 2,470.09 68.065 1,158.91 Subtotal: 98,829.00 98,829.00 3,679.96 68,052.13 68.858 30,776.87 135-60344-039-000 Intergov Trans Out (Fire CIP) 2,277.85 2,277.85- Subtotal: 2,277.85 2,277.85- Program number: 98,829.00 98,829.00 3,679.96 70,329.98 71.163 28,499.02 Department number: Non Departmental 98,829.00 98,829.00 3,679.96 70,329.98 71.163 28,499.02 Expenditures Subtotal ----------- 6,094,978.00 6,129,319.00 430,814.14 2,776,360.17 45.296 3,352,958.83 Fund number: 135 MUD 1 General Fund 52,413.43 335,110.21- 335,110.21 . glbase_tbam rgonzale Trophy Club Entities Page 21 16:23 03/09/12 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 2/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 550,663.00- 546,716.00- 51,156.20- 532,006.96- 97.310 14,709.04- 533-40002-000-000 Property Taxes/Delinquent 3,947.00- 231.73- 3,147.88 -79.754 7,094.88- 533-40015-000-000 Property Taxes/P & I 5,017.00- 5,017.00- 452.99- 1,039.67- 20.723 3,977.33- Subtotal: 555,680.00- 555,680.00- 51,840.92- 529,898.75- 95.360 25,781.25- 533-48005-000-000 Utility Fees 6,120.00- 6,120.00- 6,120.00- 100.000 Subtotal: 6,120.00- 6,120.00- 6,120.00- 100.000 533-49010-000-000 Interest Income 500.00- 500.00- 43.55- 108.34- 21.668 391.66- 533-49015-000-000 Lease/Rental Income 308,000.00- 308,000.00- 308,000.00- 308,000.00- 100.000 Subtotal: 308,500.00- 308,500.00- 308,043.55- 308,108.34- 99.873 391.66- Program number: 870,300.00- 870,300.00- 359,884.47- 844,127.09- 96.993 26,172.91- Department number: Revenues 870,300.00- 870,300.00- 359,884.47- 844,127.09- 96.993 26,172.91- Revenues Subtotal ----------- 870,300.00- 870,300.00- 359,884.47- 844,127.09- 96.993 26,172.91- . glbase_tbam rgonzale Trophy Club Entities Page 22 16:23 03/09/12 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 2/2012 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 4,000.00 4,000.00 500.00 500.00 12.500 3,500.00 533-70025-051-000 Bond Interest Expense 301,300.00 301,300.00 150,650.00 150,650.00 50.000 150,650.00 533-70035-051-000 Bond Principal Payment 565,000.00 565,000.00 565,000.00 Subtotal: 870,300.00 870,300.00 151,150.00 151,150.00 17.368 719,150.00 Program number: 870,300.00 870,300.00 151,150.00 151,150.00 17.368 719,150.00 Department number: Administration 870,300.00 870,300.00 151,150.00 151,150.00 17.368 719,150.00 Expenditures Subtotal ----------- 870,300.00 870,300.00 151,150.00 151,150.00 17.368 719,150.00 Fund number: 533 MUD 1 I&S CONSOLIDATED 208,734.47- 692,977.09- 692,977.09 ******* End of Report ********* 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12012-52-M1 Name: Status:Type:M1 Agenda Item Draft File created:In control:3/12/2012 Trophy Club Municipal Utility District No. 1 On agenda:Final action:3/20/2012 Title:Discuss and Take Appropriate Action to Authorize New Signature Cards with First Financial and Texpool to include Jennifer McKnight (Gonzales) Attachments: Action ByDate Action ResultVer. Title Discuss and Take Appropriate Action to Authorize New Signature Cards with First Financial and Texpool to include Jennifer McKnight (Gonzales) 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12012-54-M1 Name: Status:Type:M1 Agenda Item Draft File created:In control:3/12/2012 Trophy Club Municipal Utility District No. 1 On agenda:Final action:3/20/2012 Title:Discuss and Take Appropriate action to execute the Division Order between Vantage and Encana. (Carr/Gonzales) Attachments: Action ByDate Action ResultVer. Title Discuss and Take Appropriate action to execute the Division Order between Vantage and Encana. (Carr/Gonzales) 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12012-55-M1 Name: Status:Type:M1 Agenda Item Draft File created:In control:3/12/2012 Trophy Club Municipal Utility District No. 1 On agenda:Final action:3/20/2012 Title:Discuss and Take Appropriate Action to approve the minutes for: a. July 2011 b. November 2011 c. March 2012 Attachments:7-20-11 Reg MUD Minutes.pdf 11-15-11 Reg MUD Minutes.pdf 3-2-12 Special Session MUD Minutes.pdf Action ByDate Action ResultVer. Title Discuss and Take Appropriate Action to approve the minutes for: a. July 2011 b. November 2011 c. March 2012 REGULAR SESSION MINUTES FROM TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 MEETING FOR THE TOWN OF TROPHY CLUB LOCATION: 100 MUNICIPAL DRIVE, TROPHY CLUB, TEXAS Wednesday, July 20, 2011 at 7:00 P.M. Svore Municipal Building Boardroom The Board of Directors of the Trophy Club Municipal Utility District No. 1, of Denton and Tarrant Counties, met in Regular session on July 20, 2011 at 7 p.m., in the Boardroom of the Administration Building, 100 Municipal Drive, Trophy Club, Texas 76262 STATE OF TEXAS § COUNTY OF DENTON § BOARD MEMBERS PRESENT: Jim Moss President Nick Sanders Vice President Kevin Carr Secretary/Treasurer Bill Armstrong Director Jim Thomas Director STAFF AND GUEST(S) PRESENT: Robert Scott District Manager Pam Liston Attorney Danny Thomas Fire Chief Renae Gonzales Senior Accountant Mary Moore MUD Secretary Jeanette Tiffany Council member Liaison Sue Moss 979 Trophy Club Drive Larry Hoover Councilmember - 1118 Berkshire Court President Moss announced the date of July 20, 2011 called the meeting to order and announced a quorum at 7: 19 p.m. Citizen Presentations Citizens are allowed three (3) minutes to address the Board regarding an item over which the Board has policy or oversight authority as provided by Texas law, the ethics order, or other policy order. No citizens addressed the Board during Citizens Presentation. REGULAR SESSION Reports & Updates 1. Receive Presentation regarding Employee of the Quarter District Manager Scott explained that 19-year MUD 1 veteran employee Adrian Womack received the very first award for Employee of the Quarter. Adrian was nominated by his peers for his hard work, effort and attitude. 2. Receive District Manager's Report a. Water pumped vs. billed b. Monthly WWTP Report c. New Fire Station Construction Costs to date d. Update - Water Plant e. Update - Wastewater Plant f. New American Citizen District Manager Scott updated the Board regarding the above items. 3. Receive Finance Update a. Senior Accountant Gonzales to provide the Board with a monthly update and address the Board's questions. Senior Accountant Renae Gonzales provided the following update to the Board: - 28 new homes in the PID for the month of June. 125 total for the year, for a grand total of 571. We budgeted for 107 connections, which has been met. All excess money will be put into the MUD 1 General Fund. -Tax rolls will be out by law on the 25th of July, numbers have not changed since the last submission to the Board. 4. Receive Fire Update a. Fire Chief Thomas to provide Board with a monthly update and address the Board's questions. -Chief Thomas explained that June was an average month. The heat has been an issue. The Fire Department assisted with two major calls outside of the Trophy Club jurisdiction. Chief Thomas stated they took 21 applications for the opening in the Fire Station and he hopes to have the position filled by September 1. Fire Station construction is approximately 97% complete on the exterior. The Chief stated that he would like to have the Fire personnel moved into the new building in two weeks. Director Carr inquired as to roof leaks and hail damage in the building. Chief Thomas states the leak in the roof has been repaired. Chief has not heard more on the hail damage. 5. Receive Town Council Update a. Council Liaison Tiffany to provide Board with an update of Council meetings, notices and relevant business. 1. The Town Council approved SUP Majestic Fine Wine and Spirits at the end of the Plaza complex. Majestic is a Centennial Store. 2. Regency complex has been rezoned to accommodate a liquor store, and Regency hopes to put a liquor store where the Blockbuster was previously located. 6. Receive Directors' Update a. Update regarding past month's activities -No discussion held. Action Items 7. Review and Approve Monthly Financial Report(s) a. June 2011 A motion was made by Secretary/Treasurer Carr, seconded by Vice President Sanders, to approve the June Financial Reports. The motion carried unanimously. 8. Discuss and take appropriate action to award or reject proposal and execution of contract with apparent best qualified vendor for Audit Services and authorizing execution of necessary documents. -District Manager Scott was impressed with Lafollett and Company. Senior Accountant Gonzales has worked with Rutledge and Crain and prefers them due to having worked with them previously. Secretary/Treasurer Carr advised that he was not impressed with Rutledge and Crain's work on previous MUD's audit. A motion was made by Director Thomas, seconded by Director Armstrong, to award the Audit RFP to the apparent low bidder, Lafollet & Company, PLLC, for one year. The question was asked if this was a multi-year contract, advised "Yes." Director Thomas amended his motion accordingly; Director Armstrong agreed to the amendment. The motion carried unanimously. Aye:5 - Director Thomas, President Moss, Secretary/Treasurer Carr, Director Armstrong, and Vice President Sanders 9. Discuss and take appropriate action regarding Governmental Accounting Standards Board (GASB) Statement 54, requiring a Fund Balance Policy be adopted by September 30, 2011. -Senior Account Gonzales provided the Board with PowerPoint Presentation regarding implementing a Fund Balance Policy. A motion was made by Secretary/Treasurer Carr, seconded by Director Thomas, to approve implementation of a Fund Balance Policy by September 30, 2011, with approval by Resolution at the August meeting. The motion carried unanimously. 10. Review and discuss TCMUD No. 1's preliminary draft budget for FY 2011-2012. -District Manager Scott updated the Board regarding the following budget revisions/suggestions: 1. Town has done a true up for salaries, and as a result, the Town is proposing an increase of $38,000 which will bring Fire personnel salaries up closer to what other cities are paying. 2. Town has proposed that the MUD hire a full-time maintenance person. The salary would be split 50/50 by each entity. Each entity has approximately 11,000 to 12,000 in Maintenance Facility and $9,500 for cleaning services. Town offered to reduce the SEMO contract by $21,000 should the MUD hire a facilities maintenance person. 11. Discuss and take appropriate action concerning Interlocal Agreement with Denton County Tax Office for Property Tax Collection. (Moore) -MUD Secretary Moore explained that this is an annual agreement with Denton County for Tax Collection Services. The cost for 2011-12 is $0.71 per statement. Staff recommends designating Senior Accountant Renae Gonzales to act on behalf of the District with regard to this Agreement. There was an error on Denton County's part on page 2, paragraph 1 - third sentence - the number was 9010. Denton County has been contacted and has submitted a corrected copy, reflecting the correct number - 2011. This is why page 2 looks different from the other pages. Staff recommends approval. A motion was made by Vice President Sanders, seconded by Director Armstrong, to accept the Interlocal Agreement with Denton County for election services and designating Renae Gonzales to act on behalf of the District. The motion carried unanimously. 12. Discuss and take appropriate action to appoint a committee to plan for a possible Fire Station Monument including: location, cost, design, and purpose. (Moss) -President Moss advised that Director Armstrong and Vice President Sanders have offered to be a part Of this committee, along with Fire Chief Thomas. President Moss advised that some residents should also be a part of this committee if so desired by Directors Armstrong and Sanders. -Motion is made by Vice President Sanders, seconded by Secretary/Treasurer Carr to form a monument selection and fundraising committee that is consist of two MUD Directors, the fire chief and up to three citizens selected by the committee; that the committee be dissolved upon installation of said monument if funding is secured. The motion carried unanimously. 13. Discuss and take appropriate action regarding Order 2011-0720, 2011-1 Rate Order. -Mr. Larry Hoover addressed the MUD Board regarding water rates and water conservation. -Section 1.04. Inspections and Fees. Paragraph C - Page 4 - Swimming Pool Discharge into Sanitary Sewer System. New swimming pools permitted on or after June 24, 2005, shall have all backwash and/or drainage from said pool discharge into the sanitary sewer system. Owners of pools built or permitted prior to July 1, 2005 are not required to retrofit the pool equipment and tie into the sanitary sewer. -Section 3.01 Security Deposits - Paragraph F - Page 11 - Deleted (Fee for Confidentiality Request) -Section 3.02 Billing Procedures. Paragraph G - Page 13 - Termination of Service. When a customer stops service or service is terminated due to bankruptcy, foreclosure, or otherwise, then it is the policy of the MUD/District not to impose any further monthly fees until such time as service is initiated. There shall be no reoccurring monthly fees imposed upon a residence that is vacant and receives no service. -Also attached for the Board's review and consideration is attachment entitled, "Rate Comparisons". This sheet shows surrounding cities water rates as well as the tiered water rates of several AWBD Water Smart MUDs. A motion was made by Vice President Sanders, seconded by Secretary/Treasurer Carr, to Approve Order 2011-0720, 2011-1 Rate Order. The motion carried unanimously. 14. Discuss and take action to approve revised Confidentiality Request Form. A motion was made by Secretary/Treasurer Carr, seconded by Vice President Sanders, to Approve and accept the revised Confidentiality Request Form. The motion carried unanimously. 15. Review and Approve Minutes a. May 24, 2011 - Regular Session Minutes b. June 21, 2011 - Regular Session Minutes A motion was made by Director Thomas, seconded by Secretary/Treasurer Carr, to approve the Regular Session minutes for May 24, 2011 and June 19, 2011. The motion carried unanimously. Review & Discuss 16. Set Next Meeting Date: a. August 16, 2011 - 7:00 p.m. - Regular Scheduled Meeting b. Budget Workshop - Early August (President Moss) The Board agreed to hold a Budget Workshop at 6:00 p.m. with the regularly scheduled meeting to follow on August 16, 2011. 17. Items for Future Agendas a. Funding of Future Capital Projects; i.e., Trinity Well No. 2 Vice President Sanders requested there be a future agenda regarding a reduced water rate for the Town. CONVENE INTO CLOSED SESSION *CLOSED SESSION Board went into Closed Session at 9:07 p.m. 18. A. PURSUANT TO SECTION 551.071 (1) (A) OF THE TEXAS GOVERNMENT CODE REGARDING CONSULTATIONS WITH ATTORNEY, TO CONDUCT A PRIVATE CONSULTATION WITH THE DISTRICT'S ATTORNEY ON A MATTER OF PENDING OR CONTEMPLATED LITIGATION: - Anticipated or threatened litigation against the District regarding personnel matters. 19. B. PURSUANT TO SECTION 551.071 OF THE TEXAS GOVERNMENT CODE TO CONDUCT A PRIVATE CONSULTATION WITH THE DISTRICT’S ATTORNEY ON A MATTER OF CONTEMPLATED LITIGATION: - In accordance with § 552.324 of the Texas Government Code, a potential lawsuit regarding Attorney General Order 2011-08982. RECONVENE INTO REGULAR SESSION Board reconvened into Regular/Open Session at 9:58 p.m. 20. Discuss and take appropriate action regarding Executive Session item(s). a. Anticipated or threatened litigation against the District regarding personnel matters. -Discussion held with no action held. b. Potential lawsuit regarding Attorney General Order 2011-08982. -Discussion held with no action held. Meeting is adjourned at 10:00 p.m. MINUTES FROM REGULAR SESSION TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 MEETING FOR THE TOWN OF TROPHY CLUB LOCATION: 100 MUNICIPAL DRIVE, TROPHY CLUB, TEXAS Tuesday, November 15, 2011 at 7:00 P.M. Svore Municipal Building Boardroom The Trophy Club Municipal Utility District No. 1, in the Town of Trophy Club, Texas, met in Regular Session on Tuesday, November 15, 2011. The meeting was held within the boundaries of the Town and was open to the public. STATE OF TEXAS § COUNTY OF DENTON § BOARD MEMBERS PRESENT: Jim Moss President Nick Sanders Vice President Kevin Carr Secretary/Treasurer Bill Armstrong Director Jim Thomas Director STAFF AND GUEST(S) PRESENT: Robert Scott District Manager Pamela Liston Attorney Danny Thomas Fire Chief Renae Gonzales Senior Accountant Laurie Slaght Interim MUD Secretary Bill Rose Council member Liaison President Moss announced the date of November 15, 2011, called the meeting to order and announced a quorum at 7:01 p.m. CITIZEN PRESENTATIONS Citizens are allowed three (3) minutes to address the Board regarding an item over which the Board has policy or oversight authority as provided by Texas law, the ethics order, or other policy order. Board convenes into closed session CONVENE INTO CLOSED SESSION 1. BOARD TO CONVENE INTO CLOSED SESSION CLOSED SESSION PURSUANT TO SECTION 551.074 (b) OF THE TEXAS GOVERNMENT CODE REGARDING PERSONNEL MATTERS: TO DISCUSS VACANCY OF DISTRICT ASSISTANT WASTEWATER SUPERINTENDENT RODNEY GREENWOOD AND EMPLOYMENT OF REPLACEMENT RECONVENE INTO REGULAR SESSION The Board reconvened into regular session at 8pm. No Action is taken regarding the closed session. REGULAR SESSION REPORTS & UPDATES 1. Receive District Manager's Report a. Water pumped vs. billed b. Monthly WWTP Report c. Update - Water Plant d. Update - Wastewater Plant e. Reciprocating water agreement with Southlake f. Appointment for New Records Retention Officer and Update on ORR's g. Hiring of new Wastewater Superintendent h. Agenda timeline - Director Thomas compiled a year to year comparison of the variance report from 2006 through 2011. Director Thomas looked at the 3 year average in 2010 was 38% higher than the 3 year average in 2009, the 3 year average in 2011 was 52% higher than it was 2010. Director Thomas states that Fort Worth Water has an Interlocal charge built in to its customer’s monthly bills that is similar to an insurance policy. This Interlocal charge is figured and then applied to what is expected to be your peak usage charge at the end of the year. The Interlocal charge in 2009 was $17,000/mo., 2010 was $25,000/mo, and in 2011 we have been paying $28,000/mo. Fort Worth has said that our peak usage charge this year will be in the neighborhood of $144,000. Director Thomas also noted that in August of 2010 we pumped 132 million gallons of water and this August 170 million gallons were pumped. -Director Carr asked District Manager Scott to change the years listed on his graph from fiscal year to calendar year. -District Manager Scott is concerned about the large increase in the permit fee for the WW permit from TCEQ. The rate increased from $6100.00 to $7965.75 way up. District Manager Scott has a call into TCEQ to inquire about the increase in the permit fee as this was not budgeted. -District Manager Scott stated that Phoenix has set up their equipment at the water tank and will start work after the Thanksgiving holiday. District Manager Scott stated that the Assistant Wastewater Superintendent had turned in his resignation and that Attorney West has hired a consultant, Mr. John Zink. 2. Director Sanders to present an overview of the information he received at the Water Regional Resource Summit on Thursday, October 20. -Director Sanders gave a power point presentation to the MUD Board. The presentation explained the current and future drought conditions in Texas. This presentation also discussed future population growth in North Texas and the water resources that will be needed to sustain us. 3. Receive Finance Update a. Senior Accountant Gonzales to provide the Board with a monthly update and address the Board's questions. b. Audit Update c. Implementation of STW upgrades. We are in the middle of the audit. STW is had issues converting the chart of accounts from Innoprise to STW. In the month of October there were 18 new connections in the PID. There were 179 PID connections for the last fiscal year in which we budgeted for 180. To date we have 643 total PID connections. Director Scott adds that there are also 83 pending PID connections in permitting. 4. Receive Fire Update a. Fire Chief Thomas to provide Board with a monthly update and address the Board's questions. - Chief Thomas provided the Board with the monthly Fire Update and answered the Board’s questions. - Chief Thomas informed the Board that October was Fire Prevention Month. The Department visited 3 schools and 4 daycares for program development and education of 1,000 kids. The Department worked hand in hand with the Safety Council this year which saved $1500 in materials. - The Fire Department sold pink tee shirts for breast cancer awareness again this year and will give American Breast Cancer Society $1500.00 - Director Carr inquired as to the progress with the roof replacement and Chief Thomas stated it is scheduled to be completed by the end of the month. 5. Receive Town Council Update a. Council member Rose to provide Board with an update of Council meetings, notices, and relevant business. - Councilman Rose stated the Council reviewed and approved Interlocal agreement between The Town and Tarrant County for Emergency Services. - The following plats were approved for The Highlands: Neighborhood 3, Phases 2B and 2C. Phase 2B consists of 42 residential lots for a total of 14.313 acres. Phase 2C consists of 13 residential lots and 1 common area for a total of 5.927 acres. The entrance to Neighborhood 3 is off of Trophy Club Drive via Galloway Blvd. - There are approximately 85 residential permits waiting to be reviewed in community development. - Approved the Interlocal agreement for the employee and contractual services between the Town and The MUD for fiscal year 2011-2012. - Town council meetings were changed Jan 2012 to the 9th and the 23rd due to holiday conflicts. ACTION ITEMS 6. Discuss and take appropriate action on the Fire Station Training Room Policy and Procedures. -Director Sanders questioned the verbiage used for fundraising and political definitions. Director Sanders would like to have consistencies throughout the policy and procedure manual. -Chief Thomas will review the manual and make further changes Motion made by Director Carr and seconded by Director Sanders to use the existing Use Policy for the Svore Municipal Council Chambers as interim Use Policy for the Fire Department Training Room. Aye 5 nay 0 7. Discuss and take appropriate action regarding reimbursement from Beck Properties for the water line installed from Katie Lane to Meadowbrook Lane. -Attorney Liston would like the MUD to send a letter seeking the debt from Beck Properties. Director Carr would like Attorney Liston to take this discussion to the Town Attorney. Motion by Director Thomas and Seconded by Director Sanders to have Attorney Liston send a letter to Beck Properties and Centurion regarding the debt collection. 8. Discuss and take action regarding the Interlocal Agreement for Employee and Contractual Services. -Director Carr would like to sit down and go through the numbers for the Semo contract and make sure that the MUD is getting what it’s paying for. Motion made by Director Sanders, seconded by Director Carr to accept the Interlocal Agreement for Employees and Contractual Services with the exhibit (a) with the Town of Trophy Club for FY2011-2012 as amended. Motion carried unanimously. 9. Discuss and take action on security system for Water and Waste Water Plant. -District Manager Scott stated that he had spoken to Adam Adams, Parks Director and security expenses will be shared to secure these areas. -Director Thomas stated that he was able to go back through the gate today and is concerned that there is no camera. -Robert will get numbers for security and bring it back to the board for discussion. No Action is taken 10. Review and Approve Monthly Financial Report(s) a. September 2011 b. October 2011 -Director Carr would like to get a picture of the amount of time that Renae is spending preparing information for the auditors. Senior Accountant Gonzales will keep track of her time spent on the auditing process. Motion made by director Carr seconded by Sanders to approve the monthly finance reports for September and October of 2011. Motion is carried unanimously. Aye 5 Nay 0 11. Next Meeting Date - December 20th 12. Items for Future Agendas -AWBD requirements for membership Adjourn Meeting adjourned at 9:17p.m. _____________________________________ Jim Moss, President SEAL _____________________________________ Kevin R. Carr, Secretary-Treasurer _____________________________________ Laurie Slaght, Interim MUD 1 Secretary Trophy Club Municipal Utility District No. 1 Special Session March 2, 2012 Page 1 of 4 SPECIAL SESSION MINUTES FROM TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 MEETING FOR THE TOWN OF TROPHY CLUB LOCATION: 100 MUNICIPAL DRIVE, TROPHY CLUB, TEXAS Friday, March 2, 2012 Svore Municipal Building Boardroom The Board of Directors of the Trophy Club Municipal Utility District No. 1, of Denton and Tarrant Counties, met in Special session on March 2, 2012 at 1 p.m., in the Boardroom of the Administration Building, 100 Municipal Drive, Trophy Club, Texas 76262 STATE OF TEXAS § COUNTY OF DENTON § BOARD MEMBERS PRESENT: Jim Moss President Nick Sanders Vice President Kevin Carr Secretary/Treasurer Bill Armstrong Director Jim Thomas Director STAFF AND GUEST(S) PRESENT: Adrian Womack Interim District Manager Pam Liston Attorney Laurie Slaght MUD Secretary Tom Rutledge Teague, Nall & Perkins Stephen Seidel Assistant Town Manager Mike Pastor Director of IS Citizens are allowed three (3) minutes to address the Board regarding an item over which the Board has policy or oversight authority as provided by Texas law, the ethics order, or other policy order. No citizen presentations Meeting is called to order at 1:02p.m. 1. Discuss and take appropriate action to appoint Kevin Carr and Jim Thomas as representatives for Trophy Club Municipal Utility District No. 1 to the Semo Committee. Motion was made by Secretary/Treasurer Carr seconded by Vice President Sanders to appoint Secretary/Treasurer Kevin Carr and Director Jim Thomas as representatives for the Semo Committee to work with the Town of Trophy Club regarding any additions, changes or deletions to the Semo Contract. Motion carried unanimously 1:07 pm Director Armstrong arrived 2. Discuss and take appropriate action funding the municipal lines at the roundabout. -Tom Rutledge with Teague, Nall & Perkins gave a brief history of the roundabout and showed the Board a power point presentation explaining the construction and cost. -Director Armstrong inquired as to the lifetime of the AC pipe. Mr. Rutledge stated that he could not give Trophy Club Municipal Utility District No. 1 Special Session March 2, 2012 Page 2 of 4 an estimate as to the lifespan of AC pipe. Mr. Rutledge stated that AC pipe is not flexible, it’s rigid and more brittle. The clay and soil in this part of Texas move and the joints are not as strong. The pipes become more brittle over time. Every city in which Teague, Nall & Perkins has performed similar construction, have replaced the pipe when they have had the opportunity. -Adrian Womack stated the pipe is approximately 2” thick. If the pipe was not re-routed and replaced, the cost to not only repair the pipe but also the roundabout would be much higher than it would be to re-route and replace the pipes now as part of the roundabout project. -President Moss stated that TCEQ will be coming to the MUD this summer to do an asbestos study on our water lines. -Secretary/Treasurer Carr noted that the pipes have been in the ground for approximately 30 years with no leaks. -Director Thomas asked Mr. Rutledge as to his opinion if it would be wise to leave the pipes under the weight of the new roundabout. Mr. Rutledge explained that the hope is to have this roundabout last 20-30 years. The water lines are 30 years old now and will need some maintenance if not replacement within that time frame. - Mr. Rutledge with Teague, Nall & Perkins explained the bid of $187,254. *Water line portion of the proposal is $158,284 *Sewer line portion of the proposal is $28,970 Alternate Options 1. $65,000 alternative water line improvements 2. $250,000 Estimated future cost to relocate lines after the roundabout is complete. (Using today’s cost of materials and labor) -President Moss stated that if in the future the 18” line breaks, this could be a catastrophic cost to the MUD. -Director Armstrong inquired about moving the lines out from under the sidewalks and moving the water line over to the corner of the Church. Mr. Rutledge explained that there is a utility easement on the corner and AT&T and Oncor are in that easement and their lines will be relocated there. -Vice President Sanders asked for clarification from Mr. Rutledge as to what is included in the $187,254. This part of the bid includes water and sewer line relocation and the replacement of 3 valves. -Mr. Rutledge confirms the bid to relocate and replace the water lines, sewer lines, and add new valves is $187,254. -Secretary/Treasurer Carr stated that the MUD will have to use $100,000 budgeted for the repairs on Indian Creek to pay for the Roundabout. He does not want to pull those funds and have no means of replenishing them. -Senior Accountant Gonzales stated that she believes there is $60,000 in reserves for water replacement and would be adding an additional $30,000 for this fiscal year. This would bring the total to $90,000. -Secretary/Treasurer Carr reminds the Board that Town Manager, Mike Slye stated in May of 2011 that the Town would pay for the entire 1.8 million dollar cost of the roundabout that includes relocation of the valves, water and sewer lines from the 2 million dollar Bond from Denton County. Trophy Club Municipal Utility District No. 1 Special Session March 2, 2012 Page 3 of 4 -Motion was made by Vice President Sanders to approve the $187,254 for utility relocation, at the roundabout utilizing existing capital funds budgeted in account 69005 for the water department. Director Armstrong asked Vice President Sanders to clarify if he is making the motion for the MUD to pay the $187,254. Attorney Pam Liston reminds the board that Vice President Sanders only made a motion and needs a second to keep on discussion and that does not mean you are voting for it. Director Armstrong seconded the motion to continue discussion. -Vice President Sanders expressed that he wishes Mike Slye would have been more specific and not used vague words when he reported to the Board the he thought the Denton County funds would cover 100% of the cost for the roundabout including the water and waste water relocation. Vice President Sanders thinks alternate option costing $65,000 is a bad decision and seeing as though we have the money budgeted for capital expense related to street work. Vice President Sanders stated, “let’s fund the full amount and move forward."j -Secretary/Treasurer Carr stated that he would like to give the Town $87,500 which was the amount budgeted for the roundabout. Denton County is giving the Town a 2 million dollar from the Bond for street improvement including water and sewer lines for the roundabout project. The 1.8 million dollar cost of the roundabout includes the cost of the relocation of the water and sewer lines and this is covered in the Bond received from Denton County. -Director Thomas stated that he would support giving the requested amount of $187,254 for the roundabout and would like to make sure that the Town is still going to move forward to assist the MUD with the re-paving of Municipal Drive. Assistant Town Manager Stephen Seidel stated that the Town is planning to partner with the MUD to re-pave Municipal Drive. - President Moss asked if there is any further discussion and calls for a vote. 4 in favor and 1 opposed. Ayes – President Moss, Vice President Sanders, Director Armstrong, Director Thomas Nay - Secretary/Treasurer Carr CONVENE INTO CLOSED SESSION at 1:57 p.m. 3. CLOSED SESSION. PURSUANT TO SECTION 551.074 OF THE TEXAS GOVERNMENT CODE REGARDING PERSONNEL MATTERS, THE BOARD WILL CONVENE INTO CLOSED SESSION TO DELIBERATE THE APPOINTMENT AND EMPLOYMENT OF PERSONNEL FOR THE POSITION OF DISTRICT MANAGER: A. TO DELIBERATE THE APPOINTMENT AND EMPLOYMENT OF A DISTRICT MANAGER B. TO DELIBERATE THE APPOINTMENT OR EMPLOYMENT OF AN INTERIM DISTRICT MANAGER RECONVENE INTO REGULAR SESSION at 2:07 p.m. 4. Discuss and take appropriate action to ratify the action of the Board at the February 21 meeting authorizing President Jim Moss to negotiate a contract with the top candidate for the position of District Manager. Vice President Sanders moves to ratify the employment contract with Jennifer McKnight, seconded by Director Thomas. Trophy Club Municipal Utility District No. 1 Special Session March 2, 2012 Page 4 of 4 Motion Carried Unanimously 5. Take necessary and appropriate action on matters deliberated in closed/executive session. Vice President Sanders made a motion to name Adrian Womack as Interim District Manager, seconded by Secretary/Treasurer Carr. Motion Carried Unanimously Meeting adjourned at 2:10 p.m. Notice is hereby given that a quorum of the Town Council may be in attendance at this meeting. _____________________________________ Jim Moss, President SEAL _____________________________________ Kevin R. Carr, Secretary-Treasurer _____________________________________ Laurie Slaght, MUD1 Secretary 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12012-56-M1 Name: Status:Type:M1 Agenda Item Draft File created:In control:3/12/2012 Trophy Club Municipal Utility District No. 1 On agenda:Final action:3/20/2012 Title:Future Agenda Items: Attachments: Action ByDate Action ResultVer. Title Future Agenda Items: 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12012-57-M1 Name: Status:Type:M1 Agenda Item Draft File created:In control:3/12/2012 Trophy Club Municipal Utility District No. 1 On agenda:Final action:3/20/2012 Title:Set April Regular Meeting Date Attachments:April Meeting Calendar.pdf Action ByDate Action ResultVer. Title Set April Regular Meeting Date 13/12/2012 11:05 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 30April 2012Su Mo Tu We Th Fr Sa12345678910111213 14 15 16 17 18 1920 21 22 23 24 25 2627 28 29 30 31May 2012April 2012Apr 1 - 7Apr 1234567 Bert/LanceGood Friday - Office CloApr 8 - 148910111213148:00am Adrian Out Orly/OpenApr 15 - 21151617181920218:30am Adrian Out Mike/Greg10:00am 11:00am EAC Meeting (PS Conference Room)Apr 22 - 2822232425262728 DeWayne/Charlie6:00pm 9:00pm TCMUD 1 MeetingApr 29 - May 52930May 12345SundayMondayTuesdayWednesdayThursdayFridaySaturday 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12012-61-M1 Name: Status:Type:M1 Agenda Item Draft File created:In control:3/14/2012 Trophy Club Municipal Utility District No. 1 On agenda:Final action:3/20/2012 Title:PURSUANT TO TEXAS GOVERNMENT CODE, SECTION 551.071 (2) CONSULTATION WITH ATTORNEY, THE BOARD MAY ENTER INTO A CLOSED SESSION FOR THE FOLLOWING PURPOSE: To conduct a private consultation with the District’s attorney on a matter in which the duty of the attorney to the District under the Texas Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflicts with the Texas Open Meetings Act: consultation regarding possible action to determine whether a relationship or employment exists which constitutes a disqualification of Director Nick Sanders under Subsection (a) of Texas Water Code Section 49.052. Attachments: Action ByDate Action ResultVer. Title PURSUANT TO TEXAS GOVERNMENT CODE, SECTION 551.071 (2) CONSULTATION WITH ATTORNEY, THE BOARD MAY ENTER INTO A CLOSED SESSION FOR THE FOLLOWING PURPOSE: To conduct a private consultation with the District’s attorney on a matter in which the duty of the attorney to the District under the Texas Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflicts with the Texas Open Meetings Act: consultation regarding possible action to determine whether a relationship or employment exists which constitutes a disqualification of Director Nick Sanders under Subsection (a) of Texas Water Code Section 49.052. 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12012-62-M1 Name: Status:Type:M1 Agenda Item Draft File created:In control:3/14/2012 Trophy Club Municipal Utility District No. 1 On agenda:Final action:3/20/2012 Title:Discuss and take appropriate action to determine whether a relationship or employment exists which constitutes a disqualification of Director Nick Sanders under Subsection (a) of Texas Water Code Section 49.052. Attachments: Action ByDate Action ResultVer. Title Discuss and take appropriate action to determine whether a relationship or employment exists which constitutes a disqualification of Director Nick Sanders under Subsection (a) of Texas Water Code Section 49.052.