Loading...
HomeMy WebLinkAboutSeptember 20, 2011 Regular Session 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, September 20, 2011 CALL TO ORDER AND ANNOUNCE A QUORUM 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. 1.2011-108-M1 Discuss and take appropriate action regarding the elevation of the ground storage tanks and citizen concerns related to the water storage facility. REPORTS & UPDATE 2.2011-111-M1 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 Water Report.pdfAttachments: 3.2011-112-M1 Receive Finance Update a. Senior Accountant Gonzales to provide the Board with a monthly update and address the Board's questions. 4.2011-113-M1 Receive Fire Update a. Fire Chief Thomas to provide Board with a monthly update and address the Board's questions. Fire Department Monthly Report.pdfAttachments: 5.2011-120-M1 Receive Town Council Update a. Councilmember Rose to provide Board with an update of Council meetings, notices, and relevant business. 6.2011-115-M1 Receive Directors' Update a. Update regarding past month's activities PUBLIC HEARING Trophy Club Municipal District No. 1 to conduct a Public Hearing regarding: TCMUD No. 1 Page 1 of 121 Meeting Date: September 20, 2011 September 20, 2011Trophy Club Municipal Utility District No. 1 Meeting Agenda 7.2011-100-M1 Proposed tax rate to increase, decrease, or remain the same for the fiscal year beginning October 1, 2011 and ending September 30, 2012. 8.2011-101-M1 TCMUD No. 1 Budget for fiscal year beginning October 1, 2011, and ending September 30, 2012. REGULAR SESSION 9.2011-102-M1 Discuss and take appropriate action regarding Resolution 2011-0920, adopting and approving the Budget for Trophy Club Municipal Utility District No. 1 for fiscal year beginning October 1, 2011, and ending September 30, 2012. Res 2011-0920-Aprv Budget.pdf Proposed Budget 2011-12.pdf Attachments: 10.2011-121-M1 Discuss and take appropriate action regarding Resolution 2011-0920-A, fixing and levying the Trophy Club Municipal Utility District No. 1 tax rate for debt service for the fiscal year beginning October 1, 2011, and ending September 30, 2012. Res 2011-0920-A DebtSvc.pdfAttachments: 11.2011-104-M1 Discuss and take appropriate action regarding Resolution 2011-0920-B, fixing and levying the Trophy Club Municipal Utility District No. 1 tax rate for operation and maintenance, including the portion of such tax rate to support the Fire Department, for the fiscal year beginning October 1, 2011, and ending September 30, 2012. Res 2011-0920-B-O&M.pdfAttachments: 12.2011-105-M1 Discuss and take appropriate action regarding Resolution 2011-0920-C, approving the Trophy Club Municipal Utility District No. 1 tax roll of the Denton Central Appraisal District and Tarrant Appraisal District for 2011. Res 2011-0920-C-Aprv Tax Roll.pdfAttachments: 13.2011-106-M1 Discuss and take appropriate action regarding Resolution 2011-0920-D, of the Trophy Club Municipal Utility District No. 1 adopting a Fund Balance Policy for the District in accordance with Government Accounting Standards Board (GASB) Statement No. 54; and providing an effective date. Fund Balance Policy Res 2011-0920-D with Exhibit A .pdfAttachments: 14.2011-107-M1 Discuss and take appropriate action on setting a governmental water rate for the Town of Trophy Club for FY2011-2012. 15.2011-119-M1 Review and Approve Monthly Financial Report(s) a. August 2011 Aug Financial Reports.pdfAttachments: 16.2011-116-M1 Set Next Meeting Date: a. October 18, 2011 - 7:00 p.m. - Regular Scheduled Meeting TCMUD No. 1 Page 2 of 121 Meeting Date: September 20, 2011 September 20, 2011Trophy Club Municipal Utility District No. 1 Meeting Agenda 17.2011-117-M1 Items for Future Agendas a. Funding of Future Capital Projects; i.e., Trinity Well No. 2 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. CERTIFICATION) THE STATE OF TEXAS) COUNTY OF DENTON) COUNTY OF TARRANT) THIS CERTIFIES THAT ON FRIDAY, SEPTEMBER 16, 2011 BY 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 TUESDAY, SEPTEMBER 20, 2011, 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. ________________________________ Shannon DePrater, Town 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 SHANNON DEPRATER AT 682-831-4605 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 ______________________, 2011. ________________________________, Title: ___________________________ TCMUD No. 1 Page 3 of 121 Meeting Date: September 20, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-108-M1 Name: Status:Type:Agenda Item Regular Session File created:In control:9/16/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:9/20/2011 Title:Discuss and take appropriate action regarding the elevation of the ground storage tanks and citizen concerns related to the water storage facility. Attachments: Action ByDate Action ResultVer. Title Discuss and take appropriate action regarding the elevation of the ground storage tanks and citizen concerns related to the water storage facility. TCMUD No. 1 Page 4 of 121 Meeting Date: September 20, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-111-M1 Name: Status:Type:Agenda Item Regular Session File created:In control:9/16/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:9/20/2011 Title: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 Attachments:Water Report.pdf Action ByDate Action ResultVer. Title 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 TCMUD No. 1 Page 5 of 121 Meeting Date: September 20, 2011 October November December January February March April May June July August September Total for year 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 200773,757 44,297 35,905 31,695 25,671 40,516 43,121 31,20442,191 43,71772,462 76,138 560,674 2008 63,250 47,082 33,371 37,194 31,472 30,766 40,313 48,829 78,091 91,664 115,042 75,494 692,568 2009 63,730 48,170 35,215 35,759 32,240 39,331 46,151 37,382 56,370 125,089 91,72479,137 690,298 2010 39,794 39,713 29,547 30,305 25,328 23,279 41,646 53,439 102,921 89,760 128,687 82,331 686,750 2011 70,502 50,909 44,365 35,983 27,845 55,972 69,165 61,467 99,326 117,707 170,464 803,705 Totals 385,474 286,467 219,675 225,107 180,182 225,578 295,825 293,121 467,798 464,134 701,199 394,906 4,139,466 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 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 863,111 Totals 387,830 295,907 225,706 218,743 201,952 244,035 312,712 337,900 508,650 639,520 697,396 378,598 4,448,949 Water Billed 0 20,000 40,000 60,000 80,000 100,000 120,000 140,000 160,000 180,000 OctoberNovemberDecemberJanuaryFebruaryMarchAprilMayJune July AugustSeptemberMonthsGallons 2006 2007 2008 2009 2010 2011 Water Pumped 0 20,000 40,000 60,000 80,000 100,000 120,000 140,000 160,000 180,000 123456789101112 MonthsGallons 2006 2007 2008 2009 2010 2011 C:\Users\sdeprater\AppData\Local\Microsoft\Windows\Temporary Internet Files\OLK12F\combined graphs (version 2).xls TCMUD No. 1 Page 6 of 121 Meeting Date: September 20, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-112-M1 Name: Status:Type:Agenda Item Regular Session File created:In control:9/16/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:9/20/2011 Title:Receive Finance Update a. Senior Accountant Gonzales to provide the Board with a monthly update and address the Board's questions. Attachments: Action ByDate Action ResultVer. Title Receive Finance Update a. Senior Accountant Gonzales to provide the Board with a monthly update and address the Board's questions. TCMUD No. 1 Page 7 of 121 Meeting Date: September 20, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-113-M1 Name: Status:Type:Agenda Item Regular Session File created:In control:9/16/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:9/20/2011 Title:Receive Fire Update a. Fire Chief Thomas to provide Board with a monthly update and address the Board's questions. Attachments:Fire Department Monthly Report.pdf Action ByDate Action ResultVer. Title Receive Fire Update a. Fire Chief Thomas to provide Board with a monthly update and address the Board's questions. TCMUD No. 1 Page 8 of 121 Meeting Date: September 20, 2011 TCMUD No. 1 Page 9 of 121 Meeting Date: September 20, 2011 TCMUD No. 1 Page 10 of 121 Meeting Date: September 20, 2011 TCMUD No. 1 Page 11 of 121 Meeting Date: September 20, 2011 TCMUD No. 1 Page 12 of 121 Meeting Date: September 20, 2011 TCMUD No. 1 Page 13 of 121 Meeting Date: September 20, 2011 TCMUD No. 1 Page 14 of 121 Meeting Date: September 20, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-120-M1 Name: Status:Type:Agenda Item Regular Session File created:In control:9/16/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:9/20/2011 Title:Receive Town Council Update a. Councilmember Rose to provide Board with an update of Council meetings, notices, and relevant business. Attachments: Action ByDate Action ResultVer. Title Receive Town Council Update a. Councilmember Rose to provide Board with an update of Council meetings, notices, and relevant business. TCMUD No. 1 Page 15 of 121 Meeting Date: September 20, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-115-M1 Name: Status:Type:Agenda Item Regular Session File created:In control:9/16/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:9/20/2011 Title:Receive Directors' Update a. Update regarding past month's activities Attachments: Action ByDate Action ResultVer. Title Receive Directors' Update a. Update regarding past month's activities TCMUD No. 1 Page 16 of 121 Meeting Date: September 20, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-100-M1 Name: Status:Type:Agenda Item Public Hearing File created:In control:9/16/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:9/20/2011 Title:Proposed tax rate to increase, decrease, or remain the same for the fiscal year beginning October 1, 2011 and ending September 30, 2012. Attachments: Action ByDate Action ResultVer. Title Proposed tax rate to increase, decrease, or remain the same for the fiscal year beginning October 1, 2011 and ending September 30, 2012. TCMUD No. 1 Page 17 of 121 Meeting Date: September 20, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-101-M1 Name: Status:Type:Agenda Item Public Hearing File created:In control:9/16/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:9/20/2011 Title:TCMUD No. 1 Budget for fiscal year beginning October 1, 2011, and ending September 30, 2012. Attachments: Action ByDate Action ResultVer. Title TCMUD No. 1 Budget for fiscal year beginning October 1, 2011, and ending September 30, 2012. TCMUD No. 1 Page 18 of 121 Meeting Date: September 20, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-102-M1 Name: Status:Type:Agenda Item Regular Session File created:In control:9/16/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:9/20/2011 Title:Discuss and take appropriate action regarding Resolution 2011-0920, adopting and approving the Budget for Trophy Club Municipal Utility District No. 1 for fiscal year beginning October 1, 2011, and ending September 30, 2012. Attachments:Res 2011-0920-Aprv Budget.pdf Proposed Budget 2011-12.pdf Action ByDate Action ResultVer. Title Discuss and take appropriate action regarding Resolution 2011-0920, adopting and approving the Budget for Trophy Club Municipal Utility District No. 1 for fiscal year beginning October 1, 2011, and ending September 30, 2012. TCMUD No. 1 Page 19 of 121 Meeting Date: September 20, 2011 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 RESOLUTION NO. 2011-0920 A RESOLUTION TO APPROVE THE FY 2011-2012 BUDGET FOR TROPHY CLUB MUD NO. 1 A RESOLUTION OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1, OF DENTON AND TARRANT COUNTIES, TEXAS; APPROVING AND ADOPTING A BUDGET FOR THE FISCAL YEAR OCTOBER 1, 2011 THROUGH SEPTEMBER 30, 2012, PROVIDING THAT EXPENDITURES FOR SAID FISCAL YEAR BE MADE IN ACCORDANCE WITH SAID BUDGET, PROVIDING A SEVERABILITY CLAUSE, AND PROVIDING AN EFFECTIVE DATE WHEREAS, an annual budget for the fiscal year beginning October 1, 2011 and ending September 30, 2012, has been duly created by the Finance Department of the Trophy Club Municipal Utility District No. 1 (the “District”) in accordance with Section 49.057(b) of the Texas Water Code; and WHEREAS, after full and final consideration, it is the opinion of the Board of Directors of District No. 1, that the 2011-2012 fiscal year budget of revenues and expenditures, as hereinafter set forth, should be adopted and approved. NOW THEREFORE BE IT RESOLVED BY THE BOARD OF DIRECTORS OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1: Section 1. That the annual budget of revenues and expenditures necessary for conducting affairs of the District for the fiscal year 2011-2012, attached hereto and incorporated herein as Exhibit A, providing for a financial plan for the ensuing fiscal year is hereby approved and adopted. Section 2. That the expenditures during the fiscal year shall be made in accordance with this budget unless otherwise authorized by proper amendment. Said budget document shall be on file for public inspection in the office of the District. Section 3. That unless otherwise modified by the Board of the District, the remaining budget for all capital improvements from fiscal year 2011-2012, attached hereto and incorporated herein as Exhibit B, not completed or started as of September 30, 2011, will be automatically carried over into fiscal year 2011-2012. TCMUD No. 1 Page 20 of 121 Meeting Date: September 20, 2011 Section 4. That if any word, sentence, section, subsection, subdivision, paragraph, clause, phrase or provision of this Resolution shall be adjudged invalid or held unconstitutional, the same shall not affect the validity of this resolution as a whole or any part of the provision hereof other than the part so decided to be invalid or unconstitutional. Section 5. That all provisions of the resolutions of the District’s Board of Directors in conflict with the provisions of this resolution shall be and the same are hereby repealed and all other provisions of the resolutions of the MUD 1 Board not in conflict with the provisions of this resolution shall remain in full force and effect. Section 6. That this resolution shall become effective immediately upon its passage. PASSED AND APPROVED by the Board of Directors of Trophy Club Municipal Utility District No. 1, this the 20th day of September, 2011. _________________________________ James Moss, President (SEAL) ____________________________________ Kevin R. Carr, Secretary/Treasurer ____________________________ Robert Scott, District Manager TCMUD No. 1 Page 21 of 121 Meeting Date: September 20, 2011 CERTIFICATE OF RESOLUTION (2010-0914) THE STATE OF TEXAS } COUNTY OF DENTON } COUNTY OF TARRANT} I, the undersigned member of the Board of Directors of the Trophy Club Municipal Utility District No. 1 of Denton and Tarrant Counties, Texas (the "District"), hereby certify as follows: 1. That I am the duly qualified and acting Secretary of the Board of Directors of the District, and that, as such, I have custody of the minutes and records of the District. 2. That the Board of Directors of the District convened in Open Session at a Regular Meeting on September 14, 2010, at the regular meeting place thereof, and the roll was called of the duly constituted officers and members of the Board of Directors, to wit: James Moss President Nick Sanders Vice President Kevin R. Carr Secretary/Treasurer Bill Armstrong Director James Thomas Director and Directors s, Moss, Sanders, Carr, Armstrong and Thomas were present, thus constituting a quorum, whereupon, among other business, the following was transacted at such meeting: a written RESOLUTION (2011-0920) APPROVING THE 2011-2012 TROPHY CLUB MUD NO. 1 BUDGET was duly introduced for the consideration of the Board of Directors of the District. It was then duly moved and seconded that such Resolution be adopted and, after due discussion, such motion, carrying with it the adoption of such Resolution, prevailed and carried by the following vote: AYES: 5 NOES: 0 TCMUD No. 1 Page 22 of 121 Meeting Date: September 20, 2011 3. That a true, full and correct copy of such Resolution adopted at such meeting is attached to and follows this certificate; that such resolution has been duly recorded in the minutes of the Board of Directors for such meeting; that the persons named in the above and foregoing Paragraph 2 were the duly chosen, qualified and acting officers and members of the Board of Directors as indicated therein, that each was duly and sufficiently notified officially and personally, in advance, of the time, place and purpose of such meeting, and that such Resolution would be introduced and considered for adoption at such meeting, and that each consented, in advance, to the holding of such meeting for such purpose; that the canvassing of the officers and members of the Board of Directors present at and absent from such meeting and of the votes of each on such motion, as set forth in the above and foregoing Paragraph 2, is true and correct; and that sufficient and timely notice of the hour, date, place and subject of such meeting was given and posted as required by Chapter 551, Texas Government Code, as amended. SIGNED AND SEALED the 20th day of September 2011. ____________________________________ Kevin R. Carr Secretary, Board of Directors (SEAL) TCMUD No. 1 Page 23 of 121 Meeting Date: September 20, 2011 EXHIBIT “A” (Budget – pending Board’s approval) TCMUD No. 1 Page 24 of 121 Meeting Date: September 20, 2011 EXHIBIT “B” TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 RESOLUTION NO. 2011-0920 A RESOLUTION TO APPROVE THE FY 2011-2012 BUDGET FOR TROPHY CLUB MUD NO. 1 Project, Trophy Club MUD Wastewater Treatment Plant Screen Rake Installation. Balance due including Retainage is $55,139.95. TCMUD No. 1 Page 25 of 121 Meeting Date: September 20, 2011 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 ANNUAL PROGRAM OF SERVICES OPERATIONS AND MAINTENANCE SUMMARY 2009-10 2010-11 2011-12 2011-12 2011-12 OPERATIONS AND MAINTENANCE ACTUALS ADOPTED PROPOSED PROPOSED PROPOSED Option 1 Option 2 Option 3 UTILITY OPERATIONS REVENUES Property Tax 121,287 86,314 98,829 98,829 98,829 Rate Revenue 3,865,887 4,155,048 5,233,477 5,233,477 5,233,477 Penalty and Service Charges 59,769 149,500 68,000 68,000 68,000 General Revenue 223,195 356,728 660,692 551,270 453,775 TOTAL REVENUE 4,270,138$ 4,747,590$ 6,060,998 5,951,576 5,854,081 EXPENDITURES Water Operations 1,912,511 2,367,044 3,501,238 3,501,238 3,501,238 Wastewater Operations 962,382 799,386 854,709 854,709 854,709 Systems Collections 308,798 416,658 407,796 407,796 407,796 Board of Directors 22,917 24,528 28,122 28,122 28,122 Manager's Office 380,369 547,908 536,867 536,867 536,867 Utility Billing 170,607 237,571 197,430 197,430 197,430 Finance 175,863 113,706 144,887 144,887 144,887 Information Systems 209,569 157,923 193,391 193,391 193,391 Human Resources 41,201 6,945 7,556 7,556 7,556 Tax Supported Non Departmental 119,837 86,314 98,829 98,829 98,829 Facilities Management 79,075 90,739 129,132 129,132 129,132 TOTAL EXPENDITURES 4,383,130$ 4,848,722$ 6,099,956 6,099,956 6,099,956 TOTAL UTILITY REVENUES OVER (UNDER) EXPENDITURES (112,991) (101,132) (38,958) (148,380) (245,875) BEGINNING FUND BALANCE 0 1,716,428 2,539,232 2,539,232 2,539,232 ENDING FUND BALANCE (112,991)$ 1,615,296$ 2,500,274$ 2,390,852$ 2,293,357$ 2011-12 I&S Option 1 No change (.07696) $106,119 of $308,000 in rent to supplement Option 2 I&S Reduce .0111 New rate 0.06586 $215,541 of $308,000 in rent to supplement Option 3 I&S Reduce .0211 New rate 0.05586 $308,000 of $308,000 in rent to supplement $6,120 of $345,000 PID Connections to supplement 2011-2012 O&M Increase .0011 Increase from .00879 to .00989 2011-2012 Fire Maintain same rate at .10925 New tax rate .1961, a combined increase of $.0011 with I&S Option 1 New tax rate .185, a combined reduction of $.01 with I&S Option 2 New tax rate .175, a combined reduction of $.02 with I&S Option 3 “PROUDLY SERVING OUR CUSTOMERS FOR OVER 35 YEARS” TCMUD No. 1 Page 26 of 121 Meeting Date: September 20, 2011 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 ANNUAL PROGRAM OF SERVICES LINE ITEM DETAIL WATER OPERATIONS 2009-10 2010-11 2010-11 2011-12 DESCRIPTION ACTUAL ADOPTED ESTIMATES PROPOSED PERSONNEL SERVICES Salaries & Wages 123,129 165,718 140,687 199,759 Overtime 13,492 8,814 17,309 13,250 Longevity 1,910 2,150 2,150 2,620 Certification 1,265 1,500 2,375 1,800 Retirement 18,747 24,945 23,082 25,508 Medical Insurance 15,319 27,748 22,275 22,607 Dental Insurance 1,053 1,446 1,316 2,169 Vision Insurance 193 269 236 576 Life Insurance & Other 766 1,177 310 1,161 Social Security Taxes 8,844 10,994 9,600 13,481 Medicare Taxes 2,068 2,571 2,246 3,153 Unemployment Taxes 567 720 329 945 Workman's Compensation 4,008 7,764 7,369 5,581 Pre-employment Physicals/Testing - 200 200 200 Employee Relations 154 350 350 350 TOTAL PERSONNEL SERVICES 191,514$ 256,366$ 229,834$ 293,160$ PROFESSIONAL SERVICES Engineering 787 1,500 1,419 1,500 Independent Labor - 500 500 500 Maintenance & Repairs 6,279 29,500 29,500 29,500 Vehicle Maintenance 2,281 3,380 2,840 3,380 Building Maintenance 520 750 750 750 Maintenance-Backhoe/SkidLoader 188 2,900 2,775 2,900 Lab Analysis 2,540 3,850 3,685 4,500 TOTAL PROFESSIONAL SERVICES 12,595$ 42,380$ 41,469$ 43,030$ OPERATING EXPENDITURES Communications/Pagers/Mobiles 1,568 1,599 1,599 1,599 Electricity 144,703 175,000 162,000 162,000 Postage 47 250 250 500 Bad Debt Expense 1,179 4,200 3,140 4,200 Publications/Books/Subscripts - 50 50 50 Dues & Memberships - 150 150 150 Schools & Training 984 2,800 2,070 2,800 Safety Program - 500 500 500 Travel & per diem 1,373 3,200 3,086 3,200 Rent/Lease Equipment - 500 770 500 Annual Permit Fee 6,134 6,600 6,135 6,600 Bulk Water 1,143,627 1,410,000 1,678,306 1,720,000 Refund of Prior Year Revenue - - - Miscellaneous Expenses 16 1,000 1,000 1,000 Property Maintenance 939 4,200 4,200 4,200 Lawn Equipment & Maintenance 496 2,000 1,780 2,000 Furniture/Equipment < $5000 - 1,500 1,120 1,500 TOTAL OPERATING EXPENDITURES 1,301,065$ 1,613,549$ 1,866,156$ 1,910,799$ CONSUMABLE SUPPLIES Fuel & Lube 8,824 15,216 11,600 15,216 Uniforms 842 3,690 3,360 3,690 Chemicals 5,733 6,200 4,640 6,200 Small Tools 217 2,500 2,060 2,500 Safety Equipment 388 2,500 3,320 2,500 Meter Expense 78,277 85,000 85,000 85,000 Hardware 52 1,000 1,000 1,000 Office Supplies - - - Maintenance Supplies 8,638 32,000 32,000 32,000 Copies - 50 50 50 Printing - 150 150 150 TOTAL CONSUMABLE SUPPLIES 102,971$ 148,306$ 143,180$ 148,306$ CAPITAL EXPENDITURES Capital Expenses 138,871 130,932 888,432 Vehicles - 27,000 GASB34 Reserve for Replacement 30,000 30,000 30,000 Variable Speed Pump - - - Capital Repairs 9,000 9,000 24,000 Capital Repairs - Ground Storage 124,770 124,771 124,771 124,771 Unexpected Maintenance - 250 250 250 Capital Leases 10,726 11,490 11,490 11,490 TOTAL CAPITAL EXPENDITURES 304,367$ 306,443$ 145,511$ 1,105,943$ TOTAL EXPENDITURES 1,912,511$ 2,367,044$ 2,426,150$ 3,501,238$ “PROUDLY SERVING OUR CUSTOMERS FOR OVER 35 YEARS” TCMUD No. 1 Page 27 of 121 Meeting Date: September 20, 2011 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 ANNUAL PROGRAM OF SERVICES LINE ITEM DETAIL WASTEWATER OPERATIONS 2009-10 2010-11 2010-11 2010-11 DESCRIPTION ACTUAL ADOPTED ESTIMATED PROPOSED PERSONNEL SERVICES Salaries & Wages 171,944 176,791 176,791 182,147 Overtime 16,636 10,166 14,349 10,166 Longevity 3,153 3,483 3,483 3,976 Certification 1,925 2,550 2,175 2,400 Retirement 26,906 27,019 27,967 27,816 Medical Insurance 27,503 37,298 29,288 30,805 Dental Insurance 1,983 1,983 1,844 1,981 Vision Insurance 357 341 357 552 Life Insurance & Other 1,067 1,237 450 884 Social Security Taxes 10,681 10,504 10,660 8,597 Medicare Taxes 2,498 2,457 2,494 2,011 Unemployment Taxes 756 720 434 567 Workman's Compensation 6,543 8,410 7,982 2,685 Employee Relations - 250 250 350 TOTAL PERSONNEL SERVICES 271,952$ 283,209$ 278,524$ 274,937$ PROFESSIONAL & CONTRACTUAL SERVICES Engineering 1,750 4,000 - Independent Labor - 750 750 750 Maintenance & Repairs 20,829 17,750 16,600 17,750 Vehicle Maintenance 2,211 4,998 3,640 4,998 Building Maintenance 673 1,400 850 1,400 Maintenance-Backhoe 1,673 2,950 2,820 2,950 Dumpster Services 17,697 35,000 27,400 35,000 Lab Analysis 15,733 18,750 22,760 TOTAL PROF & CONTRACTUAL SERVICES 60,565$ 85,598$ 52,060$ 85,608$ OPERATING EXPENDITURES Telephone 51 - - Communications/Pagers/Mobiles 2,896 3,000 3,000 3,000 Electricity 197,202 205,000 202,000 205,000 Water 1,843 1,900 1,795 1,900 Postage 14 120 120 120 Publications/Books/Subscripts 500 500 500 Schools & Training 462 1,320 1,175 1,320 Safety Program - 200 200 200 Travel & Per Diem 2,150 1,750 1,910 1,750 Rent/Lease Equipment - 200 200 200 Annual Permit Fee 7,433 7,500 10,703 7,500 Miscellaneous Expenses 26 525 525 525 Property Maintenance - - - Lawn Equipment & Maintenance 222 525 525 525 Transfer to Capital Projects 250,000 -- TOTAL OPERATING EXPENDITURE 462,298$ 222,540$ 222,653$ 222,540$ CONSUMABLE SUPPLIES Fuel & Lube 6,734 6,875 5,175 6,875 Uniforms 989 2,205 2,920 3,140 Chemicals 16,655 13,000 11,920 13,180 Small Tools 536 1,260 1,140 1,260 Safety Equipment 637 540 720 925 Lab Supplies 5,159 6,085 5,425 19,160 Hardware - 525 525 525 Office Supplies - 400 400 400 Maintenance Supplies 3,168 5,860 4,450 8,860 Other Consumables 5 110 110 110 TOTAL CONSUMABLE SUPPLIES 33,883$ 36,860$ 32,785$ 54,435$ CAPITAL EXPENDITURES Capital Expenses 118,689 136,189 129,875 161,189 Capital Repairs 14,994 35,000 28,755 56,000 TOTAL CAPITAL EXPENDITURES 133,684$ 171,189$ 158,630$ 217,189$ TOTAL EXPENDITURES 962,382$ 799,396$ 744,652$ 854,709$ “PROUDLY SERVING OUR CUSTOMERS FOR OVER 35 YEARS” TCMUD No. 1 Page 28 of 121 Meeting Date: September 20, 2011 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 ANNUAL PROGRAM OF SERVICES LINE ITEM DETAIL WASTEWATER COLLECTIONS 2009-10 2010-11 2010-11 2011-12 DESCRIPTION ACTUAL ADOPTED ESTIMATES PROPOSED PERSONNEL SERVICES Salaries & Wages 132,716 136,341 136,341 145,481 Overtime 12,087 14,145 15,210 7,297 Longevity 2,920 3,128 3,160 3,548 Certification 1,375 1,200 1,500 1,500 Retirement 19,939 21,674 23,026 21,074 Medical Insurance 18,043 28,228 22,275 22,983 Dental Insurance 1,426 1,426 1,317 1,533 Vision Insurance 222 253 236 357 Life Insurance & Other 812 942 310 978 Social Security Taxes 8,741 8,769 9,601 9,785 Medicare Taxes 2,044 2,051 2,246 2,288 Unemployment Taxes 567 540 329 567 Workman's Compensation 3,287 4,412 7,369 3,056 Employee Relations 13 250 200 250 TOTAL PERSONNEL SERVICES 204,192$ 223,359$ 223,120$ 220,697$ PROFESSIONAL & CONTRACTUAL SVCS Engineering - 1,500 1,420 1,500 Independent Labor - 200 200 200 Maintenance & Repairs 3,563 23,700 18,780 23,700 Vehicle Maintenance 985 8,143 7,750 1,943 Building Maintenance -750 750 750 TOTAL PROF & CONTRACT SVCS 4,548$ 34,293$ 28,900$ 28,093$ OPERATING EXPENDITURES Communications/Pagers/Mobiles 2,619 2,796 2,595 2,796 Electricity 22,076 23,625 21,400 23,625 Water 56 750 750 750 Postage - 150 150 150 Dues & Memberships 180 255 255 255 Schools & Training 480 2,818 2,150 2,818 Safety Program - 750 625 750 Travel & per diem 701 1,500 835 1,500 Rent/Lease Equipment 37,047 44,107 44,107 44,107 Miscellaneous Expenses 16 100 100 100 Property Maintenance - 1,000 1,000 TOTAL OPERATING EXPENDITURES 63,174$ 77,851$ 72,967$ 77,851$ CONSUMABLE SUPPLIES Fuel & Lube 11,427 11,700 10,885 11,700 Uniforms 559 2,505 1,940 2,505 Chemicals 13,120 12,500 9,620 12,500 Small Tools 821 1,500 1,125 1,500 Safety Equipment 187 1,150 825 1,150 Hardware - 750 750 750 Maintenance Supplies 217 16,050 16,050 TOTAL CONSUMABLE SUPPLIES 26,332$ 46,155$ 25,145$ 46,155$ CAPITAL EXPENDITURES Capital Expenses 10,552 15,000 11,425 15,000 Capital Repairs - 20,000 16,700 20,000 TOTAL CAPITAL EXPENDITURES 10,552$ 35,000$ 28,125$ 35,000$ TOTAL EXPENDITURES 308,798$ 416,658$ 378,257$ 407,796$ “PROUDLY SERVING OUR CUSTOMERS FOR OVER 35 YEARS” TCMUD No. 1 Page 29 of 121 Meeting Date: September 20, 2011 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 ANNUAL PROGRAM OF SERVICES LINE ITEM DETAIL BOARD OF DIRECTORS 2009-10 2010-11 2010-11 2011-12 DESCRIPTION ACTUAL ADOPTED ESTIMATES PROPOSED PERSONNEL SERVICES Salaries & Wages 12,000 10,000 8,600$ 10,000 Social Security Taxes 787 620 620$ 620 Medicare Taxes 184 145 145 145 Unemployment Taxes 214 210 210 210 Workman's Compensation 114 120 135 120 TOTAL PERSONNEL SERVICES 13,300$ 11,095$ 9,710$ 11,095$ PROFESSIONAL & CONTRACTUAL SERVICES Legal - - - Auditing - - - Appraisal - - - Tax Admin Fees - - - Professional Outside Services - - - TOTAL PROF & CONTRACTUAL SERVICES -$ -$ -$ OPERATING EXPENDITURES Postage - - - Publications/Books/Subscripts - 50 50 50 Dues and Memberships 1,960 2,100 1100 2,100 Meetings 454 1,278 650 1,278 Schools & Training 3,395 4,000 3100 4,150 Travel & per diem 3,202 5,805 1750 6,199 Elections (45) - - Advertising 494 - - Miscellaneous Expenses 23 150 150 3,200 Interfund Trans Out (MUD1 I&S) - - - Intergov Trans Out (Fire Construction) - - - Intergov Trans Out (Fire Dept) - - - Loan to MUD 2 - - - TOTAL OPERATING EXPENDITURES 9,482$ 13,383$ 6,800$ 16,977$ CONSUMABLE SUPPLIES Office Supplies 135 50 50 50 TOTAL CONSUMABLE SUPPLIES 135$ 50$ 50$ 50$ CAPITAL EXPENDITURES To MUD2 Water Plant Renovation - - - Paying Agent Fee - - - TOTAL CAPITAL EXPENDITURES -$ -$ -$ -$ EXPENDITURE TOTALS 22,917$ 24,528$ 16,560$ 28,122$ “PROUDLY SERVING OUR CUSTOMERS FOR OVER 35 YEARS” TCMUD No. 1 Page 30 of 121 Meeting Date: September 20, 2011 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 ANNUAL PROGRAM OF SERVICES LINE ITEM DETAIL MANAGERS OFFICE 2009-10 2010-11 2010-11 2011-12 DESCRIPTION ACTUAL ADOPTED ESTIMATES PROPOSED PERSONNEL SERVICES Salaries & Wages 259,824 214,374 205,757 236,831 Overtime 2,747 500 492 1,000 Longevity 3,056 2,580 2,755 1,845 Retirement 35,366 30,360 28,967 33,471 Medical Insurance 22,317 17,925 16,774 18,798 Dental Insurance 1,446 930 951 1,242 Vision Insurance 268 179 179 341 Life Insurance & Other 1,280 1,205 450 1,337 Social Security Taxes 16,275 13,474 12,466 14,860 Medicare Taxes 3,806 3,151 2,982 3,475 Unemployment Taxes 774 630 468 756 Workman's Compensation 1,102 783 743 5,581 Pre-Employment Physicals/Testing (40) 82 - Employee Relations 1,008 1,000 1,000 5,000 TOTAL PERSONNEL SERVICES 349,230$ 287,091$ 274,066$ 324,537$ Legal - - - Independent Labor 592.5 840 840 840 Records Management 418.24 500 500 500 Professional Outside Services -393.13 229,076 229,076 176,870 TOTAL PROF & CONTRACTUAL SERVICES 618$ 230,416$ 230,416$ 178,210$ OPERATING EXPENSES Telephone 248 200 200 300 Communications/Pagers/Mobiles 2,816 1,798 2,420 2,420 Postage 1,480 1,571 1,954 - Service Charges & Fees 50 Publications/Books/Subscripts 336 450 450 450 Dues & Subscriptions 1,379 1,612 1,742 1,742 Meetings 467 312 312 312 Schools & Training 1,751 2,555 1,750 2,555 Travel & Per Diem 1,814 3,088 2,340 3,851 Elections 2,663 2,500 2,500 2,500 Advertising 341 1,500 3,170 4,700 Miscellaneous Expenses - 100 100 100 4th of July Celebration 10,000 10,000 10,000 10,000 Town 25th Anniversary 2,500 - - Loan to MUD 2 - - - Furniture/Equipment 2,419 1,750 2,225 TOTAL OPERATING EXPENSES 28,264$ 27,436$ 26,938$ 31,155$ CONSUMABLE SUPPLIES Office Supplies 2,173 2,450 1,670 2,450 Printing 85 515 515 515 TOTAL CONSUMABLE SUPPLIES 2,258$ 2,965$ 2,185$ 2,965$ TOTAL EXPENDITURES 380,369$ 547,908$ 533,605$ 536,867$ PROFESSIONAL & CONTRACTUAL SERVICES “PROUDLY SERVING OUR CUSTOMERS FOR OVER 35 YEARS” TCMUD No. 1 Page 31 of 121 Meeting Date: September 20, 2011 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 ANNUAL PROGRAM OF SERVICES LINE ITEM DETAIL HUMAN RESOURCES 2009-10 2010-11 2010-11 2011-12 DESCRIPTION ACTUAL ADOPTED ESTIMATES PROPOSED PERSONNEL SERVICES Pre-Employment Physicals/Testing - - 152 - Employee Relations 1,262 1,788 700 1,967 Tuition Reimbursement 170 1,530 75 1,561 Employee Assist Prog 1,131 - - Flexible Benefits Admin 1,882 - - TOTAL PERSONNEL SERVICES $ 39,052 $ 3,318 $ 927 $ 3,527 OPERATING EXPENSES Telephone 7 27 27 28 Communications/Pagers/Mobiles 184 - - Postage 107 104 100 106 Prompt Payment Act Interest 0 Publications/Books/Subscriptions 240 462 275 485 Dues & Memberships 271 529 529 555 Meetings 88 134 134 138 Schools & Training 334 566 566 594 Travel & Per Diem - 8 8 Physicals/Testing 845 1,260 1,560 TOTAL OPERATING EXPENSES 2,075$ 3,090$ 1,631$ 3,475$ CONSUMABLE SUPPLIES Small Equipment Office Supplies 74 424 424 437 Printing - 113 113 116 TOTAL CONSUMABLE SUPPLIES 74$ 537$ 537$ 553$ TOTAL EXPENDITURES 41,201$ 6,945$ 3,095$ 7,556$ “PROUDLY SERVING OUR CUSTOMERS FOR OVER 35 YEARS” TCMUD No. 1 Page 32 of 121 Meeting Date: September 20, 2011 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 ANNUAL PROGRAM OF SERVICES LINE ITEM DETAIL FINANCE 2009-10 2010-11 2010-11 2011-12 DESCRIPTION ACTUAL ADOPTED ESTIMATE PROPOSED PERSONNEL SERVICES Salaries & Wages 115,873 70,839 69,714 94,389 Overtime 6,294 3,500 14,543 1,000 Longevity/Certification 870 - Longevity - 1,710 1,710 1,823 Certification - - Retirement 16,578 10,647 12,255 13,610 Group Insurance - - Medical Insurance 10,009 8,583 7,680 11,060 Dental Insurance 694 393 453 773 Vision Insurance 108 75 55 207 Life Insurance & Other 615 424 168 563 Social Security Taxes 7,219 4,697 4,650 5,385 Medicare Taxes 1,688 1,099 1,053 1,259 Unemployment Taxes 395 180 130 284 Worker's Compensation 456 274 260 235 Auto Allowance - Pre-Employment Physicals/Testing 64 - - TOTAL PERSONNEL SERVICES $ 160,864 $ 102,421 $ 112,670 $ 130,588 Auditing - - Professional Outside Services 8,705 5,000 2,438 5,000 TOTAL PROF & CONTRACTUAL SERVICES $ 8,705 $ 5,000 $ 2,438 $ 5,000 OPERATING EXPENSES Telephone 95 100 20 103 Communications/Pagers/Mobiles 400 670 670 683 Postage 250 500 500 700 Service Charges & Fees 50 77 - 79 Publications/Books/Subscriptions 50 250 - 500 Dues & Memberships 1,300 413 400 660 Meetings 88 88 - 300 Schools & Training 800 1,040 309 2,000 Travel & Per Diem 1,400 1,547 175 1,500 Advertising - 500 500 1,210 Miscellaneous Expenses 55 - 200 200 Furniture/Equipment < $5000 406 - - - TOTAL OPERATING EXPENSES $ 4,894 $ 5,185 $ 2,774 $ 7,935 CONSUMABLE SUPPLIES Office Supplies 500 600 600 849 Printing 900 500 500 515 TOTAL CONSUMABLE SUPPLIES $ 1,400 $ 1,100 $ 1,100 $ 1,364 TOTAL EXPENDITURES $ 175,863 $ 113,706 $ 118,982 $ 144,887 PROFESSIONAL & CONTRACTUAL “PROUDLY SERVING OUR CUSTOMERS FOR OVER 35 YEARS” TCMUD No. 1 Page 33 of 121 Meeting Date: September 20, 2011 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO 1 ANNUAL PROGRAM OF SERVICES LINE ITEM DETAIL INFORMATION SYSTEMS 2009-10 2009-10 2009-10 2010-11 2010-11 2011-12 DESCRIPTION ADOPTED AMENDED ACTUAL ADOPTED ESTIMATES PROPOSED PERSONNEL Salaries & Wages 58,883 58,883 59,044 - - - Longevity 278 338 338 - - - Retirement 7,691 7,691 7,977 - - - Medical Insurance 4,928 4,928 4,928 - - - Dental Insurance 310 310 310 - - - Vision Insurance 60 60 60 - - - Life Insurance & Other 384 384 341 - - - Social Security Taxes 3,668 3,668 3,809 - - - Medicare Taxes 858 858 891 - - - Unemployment Taxes 68 68 189 - - - Workman's Compensation 156 156 179 - - - TOTAL PERSONNEL 77,284$ 77,344$ 78,065$ -$ -$ -$ PROFESSIONAL & CONTRACTUAL SERVICES Software & Support 56,190 56,130 46,650 50,453 50,453 64,149 Independent Labor 1,464 1,464 1,934 1,464 2,349 1,650 TOTAL PROF & CONTRACT SERVICES 57,654$ 57,594$ 48,585$ 51,917$ 52,802$ 65,799$ OPERATING EXPENDITURES Telephone 20,520 20,520 12,025 8,040 8,040 6,540 Communications/Pagers/Mobiles 1,081 1,081 900 - - - Postage 100 100 2 - - - Service Charges & Fees - - 2 - - - Publications/Books/Subscripts 63 138 66 - - - Dues & Memberships 177 177 137 - - - Meetings 75 75 11 - - - Schools & Training 1,738 1,663 774 - - - Travel & Per Diem 1,464 1,464 374 - - - Advertising - - - - - - Security 1,902 1,902 1,844 1,350 1,350 1,350 Furniture/Equipment < $5000 - - - - - TOTAL OPERATING EXPENDITURES 27,120$ 27,120$ 16,135$ 9,390$ 9,390$ 7,890$ CONSUMABLE SUPPLIES Hardware 36,682 36,682 32,026 19,413 42,010 83,238 Office Supplies 300 300 346 371 371 371 Printer Supplies & Maintenance 4,845 4,845 4,205 5,732 5,732 5,732 Printing 100 100 17 - - - TOTAL CONSUMABLE SUPPLIES 41,927$ 41,927$ 36,594$ 25,516$ 48,113$ 89,341$ CAPITAL EXPENDITURES Copier Lease Installments 3,450 3,450 3,279 3,450 3,450 3,450 GASB34/Reserve For Replacement 26,911 26,911 26,911 26,911 26,911 26,911 TOTAL CAPITAL EXPENDITURES 30,361$ 30,361$ 30,190$ 30,361$ 30,361$ 30,361$ TOTAL EXPENDITURES 234,346$ 234,346$ 209,569$ 117,184$ 140,666$ 193,391$ “PROUDLY SERVING OUR CUSTOMERS FOR OVER 35 YEARS” TCMUD No. 1 Page 34 of 121 Meeting Date: September 20, 2011 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 ANNUAL PROGRAM OF SERVICES LINE ITEM DETAIL FACILITIES MANAGEMENT 2009-10 2010-11 2010-11 2011-12 DESCRIPTION ACTUAL ADOPTED ESTIMATES PROPOSED PERSONNEL SERVICES Salaries & Wages 31,512 Overtime - Longevity/Certification - Longevity - Certification - Retirement 4,412 Group Insurance - Medical Insurance 9,027 Dental Insurance 549 Vision Insurance 138 Life Insurance & Other 228 Social Security Taxes 1,954 Medicare Taxes 457 Unemployment Taxes 189 Worker's Compensation 861 Auto Allowance - Pre-Employment Physicals/Testing 250 TOTAL PERSONNEL SERVICES $ 49,577 PROFESSIONAL & CONTRACTUAL SERVICES Building Maintenance 3,991 11,970 15,000 5,000 Cleaning Services 8,045 9,450 7,000 - TOTAL PROF & CONTRACT SERVICES 12,036$ 21,420$ 22,000$ 5,000$ OPERATING EXPENSES Electricity 15,909 20,895 14,000 21,940 Water 636 1,061 750 1,093 Rent And/Or Usage 13,182 13,182 13,182 13,182 Insurance 34,855 31,081 23,476 32,635 TOTAL OPERATING EXPENSES 64,581$ 66,219$ 51,408$ 68,850$ CONSUMABLE SUPPLIES Maintenance Supplies 1,697 2,100 1,700 2,205 Vending Machine Supplies 761 1,000 500 1,000 Equipment 2,500 TOTAL CONSUMABLE SUPPLIES 2,458$ 3,100$ 2,200$ 5,705$ TOTAL EXPENDITURES 79,075$ 90,739$ 75,608$ 129,132$ “PROUDLY SERVING OUR CUSTOMERS FOR OVER 35 YEARS” TCMUD No. 1 Page 35 of 121 Meeting Date: September 20, 2011 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 ANNUAL PROGRAM OF SERVICES LINE ITEM DETAIL UTILITY BILLING 2009-10 2010-11 2010-11 2011-12 DESCRIPTION ACTUAL ADOPTED ESTIMATES PROPOSED PERSONNEL SERVICES Salaries & Wages 79,711 112,537 89,000 84,946 Overtime 1,168 1,500 1,000 2,000 Longevity 185 245 405 220 Retirement 10,798 15,999 9,971 12,203 Medical Insurance 10,675 21,773 16,578 12,321 Dental Insurance 827 1,136 1,132 1,026 Vision Insurance 133 209 200 260 Life Insurance & Other 496 800 300 604 Social Security Taxes 5,079 7,029 5,528 5,404 Medicare Taxes 1,188 1,644 1,287 1,264 Unemployment Taxes 386 540 416 473 Workman's Compensation 243 411 390 211 Pre-Employment Physicals/Testing 93.95 22 TOTAL PERSONNEL SERVICES 110,982$ 163,823$ 126,229$ 120,932$ PROFESSIONAL SERVICES Independent Labor - 800 800 800 Utility Billing Contract 9,688 11,000 10,250 11,000 TOTAL PROFESSIONAL SERVICES 9,688$ 11,800$ 11,050$ 11,800$ OPERATING EXPENDITURES Telephone 99 100 100 100 Communications/Pagers/Mobiles 389 472 472 472 Postage 15,549 18,000 17,500 18,000 Service Charges & Fees 14,454 18,000 19,200 18,000 Dues & Memberships - 71 71 71 Schools & Training 486 800 800 800 Travel & per diem - 605 575 605 Reg Assessment Fees (5%) 17,174 20,000 21,000 22,500 Miscellaneous Expenses - 200 200 200 TOTAL OPERATING EXPENDITURES 48,151$ 58,248$ 59,918$ 60,748$ CONSUMABLE SUPPLIES Office Supplies 872 700 700 700 Printing 915 3,000 3,000 3,250 TOTAL CONSUMABLE SERVICES 1,787$ 3,700$ 3,700$ 3,950$ TOTAL EXPENDITURES 170,607$ 237,571$ 200,897$ 197,430$ “PROUDLY SERVING OUR CUSTOMERS FOR OVER 35 YEARS” TCMUD No. 1 Page 36 of 121 Meeting Date: September 20, 2011 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 ANNUAL PROGRAM OF SERVICES LINE ITEM DETAIL NON DEPARTMENTAL EXPENSES 2009-10 2010-11 2010-11 2011-12 DESCRIPTION ACTUAL ADOPTED ESTIMATES PROPOSED EXPENDITURE PROFESSIONAL & CONTRACTUAL SERVICES Ad Valorem Property Tax Appraisal Fees 2,983 20,211 15,202 20,000 Ad Valorem Property Tax Administration Fees 16,228 3,603 2,750 3,629 Legal 67,034 35,000 50,000 55,000 Audit 33,591 27,500 27,500 20,200 TOTAL PROF & CONTRACTUAL SERVICES 119,837$ 86,314$ 95,452$ 98,829$ EXPENDITURE TOTALS 119,837$ 86,314$ 95,452$ 98,829$ 2011-12 Proposed reflects a .0011 increase in the O&M tax rate from .00879 to .00989 “PROUDLY SERVING OUR CUSTOMERS FOR OVER 35 YEARS” TCMUD No. 1 Page 37 of 121 Meeting Date: September 20, 2011 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 ANNUAL PROGRAM OF SERVICES LINE ITEM DETAIL ACCOUNT FIRE OPERATIONS FUND 2009-10 2010-11 2010-11 2011-12 NUMBER DESCRIPTION ACTUAL ADOPTED ESTIMATES PROPOSED REVENUE 40001 Assessment - Emerg Svcs 51,966 111,648 124,000 - 40010 Property Taxes/MUD Fire 1,134,034 1,072,786 1,081,750 - 40020 Property Taxes/Fire P&I 15,500 7,500 6,646 7,500 42014 Fire Permits/Sprinkler 3,600 - 1,600 - 43400 Fire Inspections 675 - 225 - 43415 Denton/Tarrant Cty Pledge - Fire 13,750 13,750 10,000 10,000 43420 Intergov Trans In (MUD1 Fire) - - - 43425 Intergov Trans In (MUD2 Fire) - - - 43426 Intergov Trans In (PID Fire) - - - 43427 Intergov Trans In (P&I) - - - 43430 Fire Grants - - - 43599 Misc Fire Revenue 1,200 2,500 1,775 1,124 49010 Interest Income 30 - 75 - 49900 Miscellaneous Income 18,925 - - TOTAL REVENUES 1,239,680$ 1,208,184$ 1,226,071$ 18,624$ EXPENDITURES PERSONNEL SERVICES 50005 Salaries & Wages 406,488 390,466 396,563 425,748 50010 Overtime 37,267 40,298 57,199 42,000 50011 DPS Holiday Pay 11,463 11,604 12,155 12,133 50015 Longevity/Certification - - 50016 Longevity 2,797 2,946 2,987 3,647 50017 Certification 2,381 5,401 7,078 4,073 50020 Retirement 60,009 63,016 65,250 68,264 50025 Group Insurance - 50026 Medical Insurance 42,311 54,809 40,139 53,184 50027 Dental Insurance 3,012 2,819 2,935 3,288 50028 Vision Insurance 487 505 470 857 50029 Life Insurance & Other 2,272 2,491 900 2,740 50030 Social Security Taxes 27,604 26,252 27,732 30,231 50035 Medicare Taxes 6,456 6,140 6,490 7,070 50040 Unemployment Taxes 1,763 1,387 975 1,476 50045 Workman's Compensation 12,276 13,134 12,465 8,793 50060 Pre-Employment Physicals/Testing 296 675 675 675 TOTAL PERSONNEL SERVICES $ 616,884 621,943$ 634,013$ 664,179$ 55080 Maintenance & Repairs 3,463 5,562 5,000 9,562 55090 Vehicle Maintenance 19,377 13,500 13,500 14,850 55095 Equipment Maintenance 3,349 3,675 3,500 9,808 55100 Building Maintenance 3,629 11,000 11,000 11,000 55110 Maintenance-Radios 735 1,050 500 1,103 55160 Professional Outside Services 39,028 40,000 20,000 20,000 TOTAL PROF & CONTRACT SVCS $ 69,582 74,787$ 53,500$ 66,323$ PROFESSIONAL & CONTRACTUAL “PROUDLY SERVING OUR CUSTOMERS FOR OVER 35 YEARS” TCMUD No. 1 Page 38 of 121 Meeting Date: September 20, 2011 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 ANNUAL PROGRAM OF SERVICES LINE ITEM DETAIL ACCOUNT FIRE OPERATIONS FUND 2009-10 2010-11 2010-11 2011-12 NUMBER DESCRIPTION ACTUAL ADOPTED ESTIMATES PROPOSED OPERATING EXPENSES 60005 Telephone 46 103 120 106 60010 Communications/Pagers/Mobiles 2,044 1,874 2,000 4,411 60020 Electricity 11,217 17,400 18,270 60025 Water 1,117 3,193 3,193 3,289 60030 Rent And/Or Usage 308,000 308,000 308,000 308,000 60035 Postage 91 95 100 97 60055 Insurance - 19,975 20,974 60060 Inspection Fees 60066 Publications/Books/Subscripts 233 382 300 401 60070 Dues & Memberships 6,898 8,358 8,358 8,560 60075 Meetings 121 - - 60080 Schools & Training 5,051 6,615 4,000 6,946 60096 Emergency Management 1,000 1,000 1,000 1,000 60100 Travel & Per Diem 3,744 7,107 4,000 6,788 60110 Physicals/Tests 1,800 1,880 1,500 1,918 60125 Advertising - 153 100 156 60160 Programs & Special Projects 3,784 4,080 4,000 4,162 60180 Fire Inspection/Enforcement 665 1,000 500 1,900 60195 Flags & Repair 2,025 2,422 2,600 2,543 60245 Miscellaneous Expenses 1,268 1,213 1,250 1,237 TOTAL OPERATING EXPENSES $ 349,102 384,850$ 341,021$ 390,758$ CONSUMABLE SUPPLIES 65005 Fuel & Lube 7,735 16,585 8,600 17,414 65010 Uniforms 3,137 4,357 4,357 4,357 65015 Protective Clothing 3,840 7,600 6,000 7,600 65030 Chemicals 511 1,545 1,200 1,545 65035 Small Tools 7,301 8,127 8,100 8,371 65085 Office Supplies 218 319 500 329 65095 Maintenance Supplies 1,323 2,652 2,652 2,785 65105 Printing 72 103 50 106 TOTAL CONSUMABLE SUPPLIES $ 24,138 41,288$ 31,459$ 42,507$ CAPITAL EXPENSES 69006 Grant Match 10,000 3,000 - 3,000 69035 Vehicles 4,183 4,183 4,183 13,709 Vehicle Equipment 23,744 - - 69050 Radios 73,443 2,500 1,000 2,500 69251 Engine 681 Payment 2,245 73,388 73,388 73,203 69255 Airpacks - 2,245 2,245 13,865 Res for Future Replace-Ladder Truck 41,890 TOTAL CAPITAL EXPENSES $ 113,614 85,316$ 80,816$ 148,167$ EXPENDITURE TOTAL 1,173,321$ 1,208,184$ 1,140,809$ 1,311,934$ REVENUES OVER (UNDER) EXPENDITURES 66,359$ -$ 85,262$ (1,293,310)$ 2011-12 Proposed rate stays the same - .10925 “PROUDLY SERVING OUR CUSTOMERS FOR OVER 35 YEARS” TCMUD No. 1 Page 39 of 121 Meeting Date: September 20, 2011 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 ANNUAL PROGRAM OF SERVICES LINE ITEM DETAIL 2009-10 2010-11 2011-12 2011-12 2011-12 ACTUALS ADOPTED PROPOSED PROPOSED PROPOSED OPTION 1 OPTION 2 OPTION 3 INTEREST & SINKING FUND No Change Reduce .0111 Reduce .0211 REVENUES Property Taxes 726,324 755,712 $758,664 $649,242 $550,663 Property Taxes/P & I 14,095 9,500 5,017 5,017 5,017 Interest Income 4,848 500 500 500 500 Fire Rent 308,000 308,000 106,119 215,541 308,000 PID Connection Fees 345,000 246,100 - - 6,120 Premium on Bonds Sold 1,000 Interfund Trans In (MUD1 O&M)- - - - - Interfund Trans In (MUD2 O&M)- - - - - TOTAL REVENUES 1,399,267$ 1,319,812$ 870,300$ 870,300$ 870,300$ EXPENDITURES Paying Agent Fees 3,260 3,500 4,000 4,000 4,000 Bond Interest Expense 308,310 379,559 301,300 301,300 301,300 Bond Principal Payment 1,055,000 1,115,000 565,000 565,000 565,000 TOTAL I & S EXPENDITURES 1,366,570$ 1,498,059$ 870,300$ 870,300$ 870,300$ TOTAL REVENUES OVER EXPENDITURES 32,698$ (178,247)$ 0$ (0)$ (0)$ 2011-12 I&S Option 1 No change (.07696) $106,119 of $308,000 in rent to supplement Option 2 I&S Reduce .0111 New rate 0.06586 $215,541 of $308,000 in rent to supplement Option 3 I&S Reduce .0211 New rate 0.05586 $308,000 of $308,000 in rent to supplement $6,120 of PID Connection Fees to supplement 2011-2012 O&M Increase .00099 Increase from .00879 to .00989 2011-2012 Fire Maintain same rate of .10925 New tax rate .1961, a combined increase of $.0011 with Option 1 New tax rate .185, a combined reduction of $.01 with I&S Option 2 New tax rate .175, a combined reduction of $.02 with I&S Option 3 “PROUDLY SERVING OUR CUSTOMERS FOR OVER 35 YEARS” TCMUD No. 1 Page 40 of 121 Meeting Date: September 20, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-121-M1 Name: Status:Type:Agenda Item Regular Session File created:In control:9/16/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:9/20/2011 Title:Discuss and take appropriate action regarding Resolution 2011-0920-A, fixing and levying the Trophy Club Municipal Utility District No. 1 tax rate for debt service for the fiscal year beginning October 1, 2011, and ending September 30, 2012. Attachments:Res 2011-0920-A DebtSvc.pdf Action ByDate Action ResultVer. Title Discuss and take appropriate action regarding Resolution 2011-0920-A, fixing and levying the Trophy Club Municipal Utility District No. 1 tax rate for debt service for the fiscal year beginning October 1, 2011, and ending September 30, 2012. TCMUD No. 1 Page 41 of 121 Meeting Date: September 20, 2011 TROPHY CLUB MUNICIPAL UTILITY DISTRICT No. 1 RESOLUTION NO. 2011-0920-A A RESOLUTION TO SET THE COMPONENT OF THE MUD 1 TAX RATE FOR DEBT SERVICE FOR 2011 RESOLVED: Pursuant to Section 26.05 of the Texas Tax Code, and Sections 49.211(a), 49.212(a), 54.601 and 54.602 of the Texas Water Code, the Board of Directors of Trophy Club Municipal Utility District No. 1 hereby finds that a tax rate of $0.07696 per $100 of taxable value, if applied to the total taxable value of property on the District's appraisal roll for the 2010 tax year, will impose the total amount of taxes needed to pay the District’s debt obligations during the next year, and that such tax rate is reasonable and necessary to service the District's debt obligations during the next year, including payments of lawfully incurred contractual obligations providing security for the payment of the principal of and interest on bonds and other evidences of indebtedness issued on behalf of the District. It is therefore ordered by the Board of Directors of the District that the component of the 2010 tax rate for debt service is hereby set at $0.07696 per $100 of taxable value of each property included on the appraisal roll for the District for the 2010 tax year. PASSED AND APPROVED by the Board of Directors of the Trophy Club Municipal Utility District No. 1, Trophy Club, Texas this 14th day of September, 2010. _________________________________ James C. Thomas, President (SEAL) ____________________________________ Kevin R. Carr, Secretary/Treasurer ____________________________ Mary Moore, MUD Secretary TCMUD No. 1 Page 42 of 121 Meeting Date: September 20, 2011 CERTIFICATE OF RESOLUTION (2010-0914-A) THE STATE OF TEXAS } COUNTY OF DENTON } COUNTY OF TARRANT} I, the undersigned member of the Board of Directors of the Trophy Club Municipal Utility District No. 1 of Denton and Tarrant Counties, Texas (the "District"), hereby certify as follows: 1. That I am the duly qualified and acting Secretary of the Board of Directors of the District, and that as such, I have custody of the minutes and records of the District. 2. That the Board of Directors of the District convened on September 14, 2010, at the regular meeting place thereof, and the roll was called of the duly constituted officers and members of the Board of Directors, to wit: James C. Thomas President Jim Moss Vice President Kevin R. Carr Secretary/Treasurer Bill Armstrong Director Nick Sanders Director and Directors Thomas, Moss, Carr, Armstrong and Sanders were present, thus constituting a quorum, whereupon, among other business, the following was transacted at such meeting: a written RESOLUTION (2010-0914-A) SETTING THE COMPONENT OF THE MUD 1 TAX RATE FOR DEBT SERVICE FOR 2010 and duly introduced for the consideration of the Board of Directors. It was then duly moved and seconded that such Resolution be adopted and, after due discussion, such motion, carrying with it the adoption of such Resolution prevailed and carried by the following vote: AYES: 5 NOES: 0 TCMUD No. 1 Page 43 of 121 Meeting Date: September 20, 2011 3. That a true, full and correct copy of such Resolution adopted at such meeting is attached to and follows this certificate; that such resolution has been duly recorded in the minutes of the Board of Directors for such meeting; that the persons named in the above and foregoing Paragraph 2 were the duly chosen, qualified and acting officers and members of the Board of Directors as indicated therein, that each was duly and sufficiently notified officially and personally, in advance, of the time, place and purpose of such meeting, and that such Resolution would be introduced and considered for adoption at such meeting, and that each consented, in advance, to the holding of such meeting for such purpose; that the canvassing of the officers and members of the Board of Directors present at and absent from such meeting and of the votes of each on such motion, as set forth in the above and foregoing Paragraph 2, is true and correct; and that sufficient and timely notice of the hour, date, place and subject of such meeting was given and posted as required by Chapter 551, Texas Government Code, as amended. SIGNED AND SEALED the 14th day of September 2010. ________________________________ Kevin R. Carr Secretary, Board of Directors (SEAL) TCMUD No. 1 Page 44 of 121 Meeting Date: September 20, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-104-M1 Name: Status:Type:Agenda Item Regular Session File created:In control:9/16/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:9/20/2011 Title:Discuss and take appropriate action regarding Resolution 2011-0920-B, fixing and levying the Trophy Club Municipal Utility District No. 1 tax rate for operation and maintenance, including the portion of such tax rate to support the Fire Department, for the fiscal year beginning October 1, 2011, and ending September 30, 2012. Attachments:Res 2011-0920-B-O&M.pdf Action ByDate Action ResultVer. Title Discuss and take appropriate action regarding Resolution 2011-0920-B, fixing and levying the Trophy Club Municipal Utility District No. 1 tax rate for operation and maintenance, including the portion of such tax rate to support the Fire Department, for the fiscal year beginning October 1, 2011, and ending September 30, 2012. TCMUD No. 1 Page 45 of 121 Meeting Date: September 20, 2011 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 RESOLUTION NO. 2011-0920-B A RESOLUTION TO SET THE COMPONENT OF THE MUD 1 TAX RATE FOR OPERATION AND MAINTENANCE EXPENDITURES FOR 2010, INCLUDING THE PORTION OF SUCH TAX RATE TO SUPPORT THE FIRE DEPARTMENT RESOLVED: Pursuant to Section 26.05 of the Texas Tax Code and Sections 49.107 and 49.351 of the Texas Water Code, the Board of Directors of Trophy Club Municipal Utility District No. 1 hereby finds that a tax rate of $.11804 per $100 of taxable value, if applied to the total taxable value of property on the District's appraisal roll for the 2010 tax year, will impose the amount of taxes needed to fund Operation and Maintenance Expenditures of the District for the next year, including the Fire Department Operations. The Board further finds that of this tax rate for Operation and Maintenance Expenditures, $.10925 per $100 of taxable value is reasonable and necessary to support the Fire Department under the plan previously approved by the District's electors, and that the remainder of $.00879 per $100 taxable value is reasonable and necessary to fund other Operation and Maintenance Expenditures of the District. It is therefore ordered by the Board of Directors of the District that the component of the 2010 tax rate for Operation and Maintenance Expenditures is hereby set at $.11804 per $100 of taxable value of each property included on the appraisal roll for the District for the 2010 tax year, of which $.10925 per $100 of taxable value shall be used to support the Fire Department and the remaining $.00879 per $100 of taxable value shall be used to fund other Operation and Maintenance Expenditures of the District. PASSED AND APPROVED by the Board of Directors of the Trophy Club Municipal Utility District No. 1, Trophy Club, Texas, this 14th day of September 2010. _________________________________ James C. Thomas, President (SEAL) ____________________________________ Kevin R. Carr, Secretary/Treasurer ____________________________ Mary Moore, MUD Secretary TCMUD No. 1 Page 46 of 121 Meeting Date: September 20, 2011 CERTIFICATE OF RESOLUTION (2010-0914-B) THE STATE OF TEXAS } COUNTY OF DENTON } COUNTY OF TARRANT} I, the undersigned member of the Board of Directors of the Trophy Club Municipal Utility District No. 1 of Denton and Tarrant Counties, Texas (the "District"), hereby certify as follows: 1. That I am the duly qualified and acting Secretary of the Board of Directors of the District, and that as such, I have custody of the minutes and records of the District. 2. That the Board of Directors of the District convened in Open Session at a Special Meeting on September 14, 2010, at the regular meeting place thereof, and the roll was called of the duly constituted officers and members of the Board of Directors, to wit: James C. Thomas President Jim Moss Vice President Kevin R. Carr Secretary/Treasurer Bill Armstrong Director Nick Sanders Director and Directors Thomas, Moss, Carr, Armstrong and Sanders were present, thus constituting a quorum, whereupon, among other business, the following was transacted at such meeting: a written RESOLUTION (2010-0914-B) SETTING THE COMPONENT OF THE MUD 1 TAX RATE FOR MAINTENANCE AND OPERATION EXPENDITURES FOR 2010, INCLUDING THE PORTION OF SUCH TAX RATE TO SUPPORT THE FIRE DEPARTMENT was duly introduced for the consideration of the Board of Directors. It was then duly moved and seconded that such Resolution be adopted and, after due discussion, such motion, carrying with it the adoption of such Resolution prevailed and carried by the following vote: AYES: 5 NOES: 0 TCMUD No. 1 Page 47 of 121 Meeting Date: September 20, 2011 3. That a true, full and correct copy of such Resolution adopted at such meeting is attached to and follows this certificate; that such Resolution has been duly recorded in the minutes of the Board of Directors for such meeting; that the persons named in the above and foregoing Paragraph 2 were the duly chosen, qualified and acting officers and members of the Board of Directors as indicated therein, that each was duly and sufficiently notified officially and personally, in advance, of the time, place and purpose of such meeting, and that such Resolution would be introduced and considered for adoption at such meeting, and that each consented, in advance, to the holding of such meeting for such purpose; that the canvassing of the officers and members of the Board of Directors present at and absent from such meeting and of the votes of each on such motion, as set forth in the above and foregoing Paragraph 2, is true and correct; and that sufficient and timely notice of the hour, date, place and subject of such meeting was given and posted as required by Chapter 551, Texas Gov. Code, as amended. SIGNED AND SEALED the 14th day of September 2010. _____________________________________ Kevin R. Carr Secretary, Board of Directors (SEAL) TCMUD No. 1 Page 48 of 121 Meeting Date: September 20, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-105-M1 Name: Status:Type:Agenda Item Regular Session File created:In control:9/16/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:9/20/2011 Title:Discuss and take appropriate action regarding Resolution 2011-0920-C, approving the Trophy Club Municipal Utility District No. 1 tax roll of the Denton Central Appraisal District and Tarrant Appraisal District for 2011. Attachments:Res 2011-0920-C-Aprv Tax Roll.pdf Action ByDate Action ResultVer. Title Discuss and take appropriate action regarding Resolution 2011-0920-C, approving the Trophy Club Municipal Utility District No. 1 tax roll of the Denton Central Appraisal District and Tarrant Appraisal District for 2011. TCMUD No. 1 Page 49 of 121 Meeting Date: September 20, 2011 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 RESOLUTION NO. 2011-0920-C A RESOLUTION TO APPROVE THE 2010 MUD 1 TAX ROLL RESOLVED: Pursuant to Section 26.09 (e) of the Texas Tax Code, the Board of Directors of Trophy Club Municipal Utility District No. 1 hereby approves the 2010 certified appraisal roll dated July 17, 2010 from Denton County Central Appraisal District and July 25, 2010 from Tarrant Appraisal District, in which the net taxable appraised value was listed as $701,544,858 and $290,755,925, respectively for a total of $981,954,998. The current 2010 tax rate (A total of $0.195/$100 assessed value) approved by the Board of Directors of Trophy Club Municipal Utility District No. 1, which has been imposed on each property included on the certified appraisal roll for the District for 2010, totals $1,914,812 actual levy. The Board hereby declares that such appraisal roll with amounts of tax entered shall constitute the District's tax roll for the 2010 tax year. PASSED AND APPROVED by the Board of Directors of the Trophy Club Municipal Utility District No. 1, Trophy Club, Texas, this the 14th day of September, 2010. _________________________________ James C. Thomas, President (SEAL) ____________________________________ Kevin R. Carr, Secretary/Treasurer ____________________________ Mary Moore, MUD Secretary TCMUD No. 1 Page 50 of 121 Meeting Date: September 20, 2011 CERTIFICATE OF RESOLUTION (2010-0914-C) THE STATE OF TEXAS } COUNTY OF DENTON } COUNTY OF TARRANT} I, the undersigned member of the Board of Directors of the Trophy Club Municipal Utility District No. 1 of Denton and Tarrant Counties, Texas (the "District"), hereby certify as follows: 1. That I am the duly qualified and acting Secretary of the Board of Directors of the District, and that as such, I have custody of the minutes and records of the District. 2. That the Board of Directors of the District convened in Open Session at a Regular Meeting on September 14, 2010, at the regular meeting place thereof, and the roll was called of the duly constituted officers and members of the Board of Directors, to wit: James C. Thomas President Jim Moss Vice President Kevin R. Carr Secretary/Treasurer Bill Armstrong Director Nick Sanders Director and Directors Thomas, Moss, Carr, Armstrong and Sanders were present, thus constituting a quorum, whereupon, among other business, the following was transacted at such meeting: a written RESOLUTION (2010-0914-C) APPROVING THE 2010 MUD 1 TAX ROLL was duly introduced for the consideration of the Board of Directors. It was then duly moved and seconded that such Resolution be adopted and, after due discussion, such motion, carrying with it the adoption of such Resolution prevailed and carried by the following vote: AYES: 5 NOES: 0 TCMUD No. 1 Page 51 of 121 Meeting Date: September 20, 2011 3. That a true, full and correct copy of such Resolution adopted at such meeting is attached to and follows this certificate; that such Resolution has been duly recorded in the minutes of the Board of Directors for such meeting; that the persons named in the above and foregoing Paragraph 2 were the duly chosen, qualified and acting officers and members of the Board of Directors as indicated therein, that each was duly and sufficiently notified officially and personally, in advance, of the time, place and purpose of such meeting, and that such Resolution would be introduced and considered for adoption at such meeting, and that each consented, in advance, to the holding of such meeting for such purpose; that the canvassing of the officers and members of the Board of Directors present at and absent from such meeting and of the votes of each on such motion, as set forth in the above and foregoing Paragraph 2, is true and correct; and that sufficient and timely notice of the hour, date, place and subject of such meeting was given and posted as required by Chapter 551, Texas Gov. Code. SIGNED AND SEALED the 14th day of September, 2010. ______________________________________ Kevin R. Carr Secretary, Board of Directors (SEAL) TCMUD No. 1 Page 52 of 121 Meeting Date: September 20, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-106-M1 Name: Status:Type:Agenda Item Regular Session File created:In control:9/16/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:9/20/2011 Title:Discuss and take appropriate action regarding Resolution 2011-0920-D, of the Trophy Club Municipal Utility District No. 1 adopting a Fund Balance Policy for the District in accordance with Government Accounting Standards Board (GASB) Statement No. 54; and providing an effective date. Attachments:Fund Balance Policy Res 2011-0920-D with Exhibit A .pdf Action ByDate Action ResultVer. Title Discuss and take appropriate action regarding Resolution 2011-0920-D, of the Trophy Club Municipal Utility District No. 1 adopting a Fund Balance Policy for the District in accordance with Government Accounting Standards Board (GASB) Statement No. 54; and providing an effective date. TCMUD No. 1 Page 53 of 121 Meeting Date: September 20, 2011 TROPHY CLUB MUD #1 RESOLUTION NO. 2011-0920-D A RESOLUTION OF THE BOARD OF DIRECTORS OF TROPHY CLUB MUD #1, OF TROPHY CLUB, TEXAS ADOPTING A FUND BALANCE POLICY FOR THE MUD IN ACCORDANCE WITH GOVERNMENT ACCOUNTING STANDARDS BOARD STATEMENT NO. 54 AS SET FORTH IN EXHIBIT “A”; AND PROVIDING AN EFFECTIVE DATE. WHEREAS, the MUD #1 Board of Directors has reviewed the Fund Balance Policy for compliance with the Government Accounting Standards Board (GASB) Statement No. 54, a copy of which is attached hereto as Exhibit “A”; and WHEREAS, upon consideration, the MUD #1 Board of Directors finds and determines it to be in the best interests of the MUD to adopt the Fund Balance Policy set forth in Exhibit “A”; NOW, THEREFORE, BE IT RESOLVED BY THE MUD #1 BOARD OF DIRECTORS OF TROPHY CLUB MUD #1 OF TROPHY CLUB, TEXAS: Section 1. That the MUD #1 Board of Directors has reviewed the attached Fund Balance Policy, which contains policies that the MUD #1 Board of Directors has determined to be beneficial to the MUD. Section 2. That the MUD #1 Board of Directors hereby adopts the Fund Balance Policy set forth in Exhibit “A’, a copy of which is attached hereto and incorporated herein in its entirety. Section 3. That the MUD District Manager is hereby designated as the MUD’s primary officer to perform the functions required by the attached Fund Balance Policy and is hereby authorized to do so. Section 4. That this Resolution shall take effect immediately upon its passage and approval. PASSED AND APPROVED by the Board of Directors of the Trophy Club Municipal Utility District No. 1, Trophy Club, Texas, this the 20th day of September, 2011. _________________________________ James Moss, President (SEAL) ____________________________________ Kevin R. Carr, Secretary/Treasurer ____________________________ Robert Scott, District Manager TCMUD No. 1 Page 54 of 121 Meeting Date: September 20, 2011 Exhibit A Trophy Club Municipal Utility District No 1 Fund Balance Policy Purpose The purpose of this policy is to establish a key element of the financial stability of the MUD by setting guidelines for fund balance. Unassigned fund balance is an important measure of economic stability. It is essential that the MUD maintain adequate levels of unassigned fund balance to mitigate financial risk that can occur from unforeseen revenue fluctuations, unanticipated expenditures, and similar circumstances. The fund balance also provides cash flow liquidity for the MUD’s general operations. Definitions Fund Equity–A fund’s equity is generally the difference between its assets and its liabilities. Fund Balance–An accounting distinction is made between the portions of fund equity that spendable and nonspendable. These are broken up into five categories: 1. Nonspendable fund balance – includes amounts that are not in a spendable form or are required to be maintained intact. Examples are inventory or permanent funds. 2. Restricted fund balance – includes amounts that can be spent only for the specific purposes stipulated by external resource providers either constitutionally or through enabling legislation. Examples include grants and child safety fees. 3. Committed fund balance – includes amounts that can be used only for the specific purposes determined by a formal action of the government’s highest level of decision- making authority. Commitments may be changed or lifted only by the government taking the same formal action that imposed the constraint originally. 4. Assigned fund balance – comprises amounts intended to be used by the government for specific purposes. Intent can be expressed by the governing body or by an official or body to which the governing body delegates the authority. In governmental funds other than the general fund, assigned fund balance represents the amount that is not restricted or committed. This indicates that resources in other governmental funds are, at a minimum, intended to be used for the purpose of that fund. 5. Unassigned fund balance – is the residual classification of the general fund and includes all amounts not contained in other classifications. Unassigned amounts are technically available for any purpose. TCMUD No. 1 Page 55 of 121 Meeting Date: September 20, 2011 Policy Committed Fund Balance The MUD #1 Board of Directors is the MUD’s highest level of decision-making authority and the formal action that is required to be taken to establish, modify, or rescind a fund balance commitment is a resolution approved by the MUD Board of Directors at the MUD’s monthly meeting. The resolution must either be approved or rescinded, as applicable, prior to the last day of the fiscal year for which the commitment is made. The amount subject to the constraint may be determined in the subsequent period. Assigned Fund Balance The MUD Council has authorized the MUD’s District Manager as the official authorized to assign fund balance to a specific purpose as approved by this fund balance policy. Minimum Unassigned Fund Balance It is the goal of the MUD to achieve and maintain an unassigned fund balance in the general fund equal to 35% of expenditures. The MUD considers a balance of less than 25% to be cause for concern, barring unusual or deliberate circumstances. If unassigned fund balance falls below the MUD’s desired goal, the MUD will assess the severity of the issue and based on council direction will proceed with the following actions. Finance will review all assigned, committed, and reserved fund balances if feasible council/authorized official may convert these funds to unassigned. If this is not an option, MUD Board/authorized official will look to generate excess reserves to replenish these unassigned funds to maintain compliance with this policy. If the MUD is unable to become compliant in the current year, the MUD will look to replenish unreserved fund balance in the next budget cycle. Order of Expenditure of Funds When multiple categories of fund balance are available for expenditure (for example, a construction project is being funded partly by a grant, funds set aside by the MUD, and unassigned fund balance), the MUD will start with the most restricted category and spend those funds first before moving down to the next category with available funds. TCMUD No. 1 Page 56 of 121 Meeting Date: September 20, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-107-M1 Name: Status:Type:Agenda Item Regular Session File created:In control:9/16/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:9/20/2011 Title:Discuss and take appropriate action on setting a governmental water rate for the Town of Trophy Club for FY2011-2012. Attachments: Action ByDate Action ResultVer. Title Discuss and take appropriate action on setting a governmental water rate for the Town of Trophy Club for FY2011-2012. TCMUD No. 1 Page 57 of 121 Meeting Date: September 20, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-119-M1 Name: Status:Type:Agenda Item Regular Session File created:In control:9/16/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:9/20/2011 Title:Review and Approve Monthly Financial Report(s) a. August 2011 Attachments:Aug Financial Reports.pdf Action ByDate Action ResultVer. Title Review and Approve Monthly Financial Report(s) a. August 2011 TCMUD No. 1 Page 58 of 121 Meeting Date: September 20, 2011 Municipal Utility District No 1 - O & M Interim Balance Sheet Balance @ 8/31/2011 ASSETS ASSETS CASH ON HAND 400 CASH IN BANK 845,821 INVESTMENTS 2,206,749 RESTRICTED ASSETS: INVESTMENTS 403,901 PREPAID EXPENSES (987) ADVALOREM PROPERTY TAXES RECEIVABLE 2,815 UTILITY AND OTHER ACCOUNTS RECEIVABLE 600,564 TOTAL ASSETS 4,059,262$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 2,815$ ACCOUNTS PAYABLE 587,755 CUSTOMER DEPOSITS 184,487 TOTAL LIABILITIES 775,057 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT 219,414 UNDESIGNATED FUND BALANCE 3,064,792 TOTAL FUND BALANCE 3,284,205 TOTAL LIABILITIES AND FUND BALANCE 4,059,262$ August 31, 2011 11/12 Months (92% of Fiscal Year) TCMUD No. 1 Page 59 of 121 Meeting Date: September 20, 2011 Trophy Club Municipal Utility Dist #1 Budget Revenue Report To Date: 08/31/2011 From Account: 180 To Account: Run Date: 09/16/2011 User: rgonzales Segments/Accounts Total Budget MTD Rev.YTD Rev. Total Variance Total % [FUND] 180 : MUD 1 General Fund 180-000-000-30100 : Property Taxes 86,314.00 111.62 86,666.98 -352.98 -0.41% 180-000-000-30125 : Property Taxes/Delinquent 0.00 77.90 845.14 -845.14 0.00% 180-000-000-30150 : Property Taxes/Penalty & Interest 0.00 75.92 1,483.03 -1,483.03 0.00% 180-000-000-35050 : Interest Income 2,000.00 342.41 5,099.62 -3,099.62 -154.98% 180-000-000-35150 : Cell Tower Lease Revenue 10,164.00 847.00 9,317.00 847.00 8.33% 180-000-000-35170 : Building Rent 7,000.00 583.33 6,416.63 583.37 8.33% 180-000-000-36100 : Gas Well Revenues 2,000.00 89.06 854.41 1,145.59 57.28% 180-000-000-36400 : Auction Sales 0.00 0.00 202.12 -202.12 0.00% 180-000-000-36500 : Vending Revenue 850.00 0.00 830.81 19.19 2.26% 180-000-000-36700 : Miscellaneous Revenue 14,500.00 50.00 9,361.10 5,138.90 35.44% 180-000-000-36900 : Recovery of Prior Year Expense 0.00 0.00 2,119.00 -2,119.00 0.00% 180-000-000-38100 : Water - Residential 1,709,811.00 344,995.87 1,768,086.46 -58,275.46 -3.41% 180-000-000-38120 : Water - Commercial 777,075.00 161,229.13 742,797.82 34,277.18 4.41% 180-000-000-38130 : Water - PID 195,249.00 57,605.03 292,865.12 -97,616.12 -50.00% 180-000-000-38140 : Portable Meters - Out of District 16,000.00 6,317.00 45,810.67 -29,810.67 -186.32% 180-000-000-38200 : Sewer - Residential 1,098,146.00 116,890.16 1,030,002.96 68,143.04 6.20% 180-000-000-38220 : Sewer - Commercial 300,403.00 28,922.36 262,290.12 38,112.88 12.69% 180-000-000-38230 : Sewer - PID 74,364.00 19,404.62 148,221.23 -73,857.23 -99.32% 180-000-000-38240 : Sewer - Out of District 10,000.00 2,191.83 15,882.25 -5,882.25 -58.82% 180-000-000-38250 : TCCC Effluent Charges 47,500.00 15,424.76 59,523.29 -12,023.29 -25.31% 180-000-000-38300 : Standby 0.00 60.00 667.60 -667.60 0.00% 180-000-000-38320 : Penalties 50,000.00 4,510.69 41,186.44 8,813.56 17.63% 180-000-000-38340 : Service Charges 17,500.00 753.00 13,689.42 3,810.58 21.78% 180-000-000-38360 : Penalities - Out of District 500.00 0.00 270.19 229.81 45.96% 180-000-000-38400 : Plumbing Inspections 0.00 100.00 1,900.00 -1,900.00 0.00% 180-000-000-38420 : Sewer Inspections 3,000.00 300.00 5,700.00 -2,700.00 -90.00% 180-000-000-38500 : PID Utility Fees 167,900.00 27,600.00 108,100.00 59,800.00 35.62% 180-000-000-38540 : Sewer/Septic Dump Fees 48,000.00 0.00 0.00 48,000.00 100.00% PAGE 1 TCMUD No. 1 Page 60 of 121 Meeting Date: September 20, 2011 Segments/Accounts Total Budget MTD Rev.YTD Rev. Total Variance Total % 180-000-000-38560 : Fire Line Fees 5,000.00 0.00 525.00 4,475.00 89.50% 180-000-000-38600 : Oversize Meter Reimbursements 50,000.00 8,554.60 63,002.29 -13,002.29 -26.00% 180-000-000-39290 : Transfer In - Future Replacement Reserve 54,314.00 0.00 0.00 54,314.00 100.00% [FUND] SubTotal : 180 : MUD 1 General Fund 4,747,590.00 797,036.29 4,723,716.70 23,873.30 0.50% Grand Total :4,747,590.00 797,036.29 4,723,716.70 23,873.30 0.50% PAGE 2 TCMUD No. 1 Page 61 of 121 Meeting Date: September 20, 2011 180-010-000-40100 Salaries - Regular 165,718.00 165,718.00 12,295.22 122,488.33 43,229.67 73.9 180-010-000-40130 Salaries - Overtime 8,814.00 8,814.00 2,960.63 15,272.89 (6,458.89) 173.3 180-010-000-40140 Salaries - Longevity 2,150.00 2,150.00 0.00 2,150.00 0.00 100.0 180-010-000-40160 Salaries - Certification 1,500.00 1,500.00 150.00 1,580.00 (80.00) 105.3 180-010-000-41200 Retirement 24,945.00 24,945.00 2,181.48 20,068.53 4,876.47 80.5 180-010-000-41210 Medical Insurance 27,748.00 27,748.00 2,592.25 21,745.64 6,002.36 78.4 180-010-000-41215 Dental Insurance 1,446.00 1,446.00 130.92 1,192.38 253.62 82.5 180-010-000-41216 Vision Insurance 269.00 269.00 22.95 213.38 55.62 79.3 180-010-000-41218 Life Insurance & Other 1,177.00 1,177.00 0.00 313.00 864.00 26.6 180-010-000-42220 Social Security Taxes 10,994.00 10,994.00 875.46 8,334.41 2,659.59 75.8 180-010-000-42225 Medicare Taxes 2,571.00 2,571.00 204.75 1,949.18 621.82 75.8 180-010-000-42250 Unemployment Taxes 720.00 720.00 0.00 329.40 390.60 45.7 180-010-000-42260 Workman's Compensation 7,764.00 7,764.00 0.00 7,368.69 395.31 94.9 180-010-000-42290 Pre-employment Physicals/Testing 200.00 200.00 0.00 0.00 200.00 # 180-010-000-42960 Employee Relations 350.00 350.00 0.00 226.04 123.96 64.6 180-010-000-50500 Engineering 1,500.00 1,500.00 0.00 80.15 1,419.85 5.3 180-010-000-52400 Lab Analysis 3,850.00 3,850.00 1,571.00 3,644.00 206.00 94.6 180-010-000-57000 Independent Labor 500.00 500.00 0.00 0.00 500.00 # 180-010-000-58000 Bulk Water 1,410,000.00 1,410,000.00 230,157.11 1,161,158.17 248,841.83 82.4 180-010-000-60300 Postage 250.00 250.00 0.00 13.35 236.65 5.3 180-010-000-60400 Publications/Books/Subscriptions 50.00 50.00 0.00 0.00 50.00 # 180-010-000-61000 Fuel 15,216.00 15,216.00 3,099.63 11,093.74 4,122.26 72.9 180-010-000-62100 Uniforms 3,690.00 3,690.00 0.00 1,882.87 1,807.13 51.0 180-010-000-62300 Chemicals 6,200.00 6,200.00 312.26 3,526.90 2,673.10 56.9 180-010-000-72100 Electricity 175,000.00 175,000.00 26,849.71 141,926.13 33,073.87 81.1 180-010-000-73200 Communications /Pagers/Mobiles 1,599.00 1,599.00 0.00 1,515.13 83.87 94.8 180-010-000-73350 Copies 50.00 50.00 0.00 0.00 50.00 # 180-010-000-73400 Printing 150.00 150.00 0.00 0.00 150.00 # 180-010-000-74100 Dues & Membership 150.00 150.00 0.00 61.00 89.00 40.7 180-010-000-74200 Travel & per diem 3,200.00 3,200.00 358.84 1,225.78 1,974.22 38.3 180-010-000-74300 Schools & Training 2,800.00 2,800.00 425.00 1,933.00 867.00 69.0 180-010-000-74700 Safety Program 500.00 500.00 0.00 7.17 492.83 1.4 180-010-000-75200 Annual Permit Fee 6,600.00 6,600.00 0.00 6,133.95 466.05 92.9 180-010-000-78100 Meter Expense 85,000.00 85,000.00 3,381.65 86,563.89 (1,563.89) 101.8 180-010-000-78200 Small Tools 2,500.00 2,500.00 3,684.61 3,969.48 (1,469.48) 158.8 180-010-000-78300 Safety Equipment 2,500.00 2,500.00 229.92 229.92 2,270.08 9.2 180-010-000-78500 Furniture/Equipment<$5,000 1,500.00 1,500.00 0.00 0.00 1,500.00 # 180-010-000-78600 Hardware 1,000.00 1,000.00 0.00 0.00 1,000.00 # 180-010-000-79150 Equipment Rental/Lease 500.00 500.00 0.00 770.00 (270.00) 154.0 page 1 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 Page 62 of 121 Meeting Date: September 20, 2011 180-010-000-79400 Bad Debt Expense 4,200.00 4,200.00 0.00 2,172.73 2,027.27 51.7 180-010-000-79999 Miscellaneous Expense 1,000.00 1,000.00 0.00 0.00 1,000.00 # 180-010-000-80250 Maintenance and Repairs 29,500.00 29,500.00 3,956.52 11,286.13 18,213.87 38.3 180-010-000-80300 Non-routine Maintenance 250.00 250.00 0.00 0.00 250.00 # 180-010-000-81100 Property Maintenance 4,200.00 4,200.00 594.00 1,296.85 2,903.15 30.9 180-010-000-81200 Building Maintenance 750.00 750.00 0.00 0.00 750.00 # 180-010-000-81300 Vehicle Maintenance 3,380.00 3,380.00 818.36 3,000.86 379.14 88.8 180-010-000-81360 Maintenance - Backhoe/Skid Loader 2,900.00 2,900.00 0.00 0.00 2,900.00 # 180-010-000-81500 Lawn Maintenance 2,000.00 2,000.00 0.00 0.00 2,000.00 # 180-010-000-81900 Maintenance Supplies 32,000.00 32,000.00 4,294.02 12,422.53 19,577.47 38.8 180-010-000-91000 Capital Lease 11,490.00 11,490.00 10,627.13 10,627.13 862.87 92.5 180-010-000-93700 Capital Expenses 130,932.00 130,932.00 113,767.31 329,620.76 (198,688.76) 251.7 180-010-000-97000 Capital Repairs 9,000.00 9,000.00 0.00 0.00 9,000.00 # 180-010-000-97100 Capital Repairs - Ground Storage 124,771.00 124,771.00 0.00 97,741.64 27,029.36 78.3 180-010-000-99500 Transfer to Future Replacement Reserve 30,000.00 30,000.00 30,000.00 30,000.00 0.00 100.0 Total Water 2,367,044.00 2,367,044.00 455,540.73 2,127,135.13 239,908.87 page 2 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 Page 63 of 121 Meeting Date: September 20, 2011 180-020-000-40100 Salaries - Regular 176,791.00 176,791.00 13,600.90 153,114.95 23,676.05 86.6 180-020-000-40130 Salaries - Overtime 10,166.00 10,166.00 1,260.73 12,703.20 (2,537.20) 125.0 180-020-000-40140 Salaries - Longevity 3,483.00 3,483.00 0.00 3,482.50 0.50 100.0 180-020-000-40160 Salaries - Certification 2,550.00 2,550.00 200.00 2,175.00 375.00 85.3 180-020-000-41200 Retirement 27,019.00 27,019.00 2,132.73 24,236.29 2,782.71 89.7 180-020-000-41210 Medical Insurance 37,298.00 37,298.00 2,785.32 33,424.09 3,873.91 89.6 180-020-000-41215 Dental Insurance 1,983.00 1,983.00 154.98 1,689.33 293.67 85.2 180-020-000-41216 Vision Insurance 341.00 341.00 29.76 327.36 13.64 96.0 180-020-000-41218 Life Insurance & Other 1,237.00 1,237.00 0.00 444.77 792.23 36.0 180-020-000-42220 Social Security Taxes 10,504.00 10,504.00 790.79 9,229.87 1,274.13 87.9 180-020-000-42225 Medicare Taxes 2,457.00 2,457.00 184.94 2,158.60 298.40 87.9 180-020-000-42250 Unemployment Taxes 720.00 720.00 0.00 434.45 285.55 60.3 180-020-000-42260 Workman's Compensation 8,410.00 8,410.00 0.00 7,981.82 428.18 94.9 180-020-000-42960 Employee Relations 250.00 250.00 0.00 151.88 98.12 60.8 180-020-000-50500 Engineering 4,000.00 4,000.00 0.00 2,800.00 1,200.00 70.0 180-020-000-52400 Lab Analysis 18,750.00 18,750.00 2,149.50 12,128.25 6,621.75 64.7 180-020-000-57000 Independent Labor 750.00 750.00 0.00 0.00 750.00 # 180-020-000-60100 Office Supplies 400.00 400.00 58.26 65.50 334.50 16.4 180-020-000-60300 Postage 120.00 120.00 0.00 0.00 120.00 # 180-020-000-60400 Publications/Books/Subscriptions 500.00 500.00 0.00 0.00 500.00 # 180-020-000-61000 Fuel 6,875.00 6,875.00 857.41 3,148.56 3,726.44 45.8 180-020-000-62100 Uniforms 2,205.00 2,205.00 0.00 1,449.17 755.83 65.7 180-020-000-62300 Chemicals 13,000.00 13,000.00 149.11 4,177.39 8,822.61 32.1 180-020-000-62800 Lab Supplies 6,085.00 6,085.00 561.49 4,120.55 1,964.45 67.7 180-020-000-62900 Other Consumables 110.00 110.00 0.00 50.14 59.86 45.6 180-020-000-72100 Electricity 205,000.00 205,000.00 16,832.55 182,581.50 22,418.50 89.1 180-020-000-72200 Water 1,900.00 1,900.00 0.00 1,288.84 611.16 67.8 180-020-000-72400 Dumpster Services 35,000.00 35,000.00 2,750.75 14,070.00 20,930.00 40.2 180-020-000-73100 Telephone 0.00 10.00 6.84 10.20 (0.20) 102.0 180-020-000-73200 Communications /Pagers/Mobiles 3,000.00 3,000.00 0.00 2,848.56 151.44 95.0 180-020-000-74200 Travel & per diem 1,750.00 1,750.00 180.20 2,090.60 (340.60) 119.5 180-020-000-74300 Schools & Training 1,320.00 1,320.00 0.00 900.00 420.00 68.2 180-020-000-74700 Safety Program 200.00 200.00 0.00 7.18 192.82 3.6 180-020-000-75200 Annual Permit Fee 7,500.00 7,500.00 0.00 10,704.14 (3,204.14) 142.7 180-020-000-78200 Small Tools 1,260.00 1,260.00 164.44 646.15 613.85 51.3 180-020-000-78300 Safety Equipment 540.00 540.00 46.13 704.36 (164.36) 130.4 180-020-000-78600 Hardware 525.00 525.00 0.00 35.81 489.19 6.8 180-020-000-79150 Equipment Rental/Lease 200.00 200.00 0.00 0.00 200.00 # 180-020-000-79999 Miscellaneous Expense 525.00 515.00 0.00 0.00 515.00 # 180-020-000-80250 Maintenance and Repairs 17,750.00 17,750.00 395.72 11,834.73 5,915.27 66.7 page 3 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 Page 64 of 121 Meeting Date: September 20, 2011 180-020-000-81200 Building Maintenance 1,400.00 1,400.00 0.00 0.00 1,400.00 # 180-020-000-81300 Vehicle Maintenance 4,998.00 4,998.00 366.36 1,416.10 3,581.90 28.3 180-020-000-81360 Maintenance - Backhoe/Skid Loader 2,950.00 2,950.00 0.00 1,126.76 1,823.24 38.2 180-020-000-81500 Lawn Maintenance 525.00 525.00 0.00 95.90 429.10 18.3 180-020-000-81900 Maintenance Supplies 5,860.00 5,860.00 175.01 936.83 4,923.17 16.0 180-020-000-93700 Capital Expenses 136,189.00 136,189.00 0.00 124,550.39 11,638.61 91.5 180-020-000-97000 Capital Repairs 35,000.00 35,000.00 0.00 1,500.00 33,500.00 4.3 Total Wastewater 799,396.00 799,396.00 45,833.92 636,841.72 162,554.28 page 4 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 Page 65 of 121 Meeting Date: September 20, 2011 180-021-000-40100 Salaries - Regular 136,341.00 136,341.00 10,518.72 118,255.68 18,085.32 86.7 180-021-000-40130 Salaries - Overtime 14,145.00 14,145.00 2,761.47 16,577.91 (2,432.91) 117.2 180-021-000-40140 Salaries - Longevity 3,128.00 3,128.00 0.00 3,160.00 (32.00) 101.0 180-021-000-40160 Salaries - Certification 1,200.00 1,200.00 125.00 1,375.00 (175.00) 114.6 180-021-000-41200 Retirement 21,674.00 21,674.00 1,898.18 19,676.58 1,997.42 90.8 180-021-000-41210 Medical Insurance 28,228.00 28,228.00 1,978.38 23,174.22 5,053.78 82.1 180-021-000-41215 Dental Insurance 1,426.00 1,426.00 118.88 1,248.57 177.43 87.6 180-021-000-41216 Vision Insurance 253.00 253.00 19.86 210.42 42.58 83.2 180-021-000-41218 Life Insurance & Other 942.00 942.00 0.00 339.73 602.27 36.1 180-021-000-42220 Social Security Taxes 8,769.00 8,769.00 747.99 7,958.70 810.30 90.8 180-021-000-42225 Medicare Taxes 2,051.00 2,051.00 174.93 1,863.82 187.18 90.9 180-021-000-42250 Unemployment Taxes 540.00 540.00 0.00 333.23 206.77 61.7 180-021-000-42260 Workman's Compensation 4,412.00 4,412.00 0.00 4,187.36 224.64 94.9 180-021-000-42960 Employee Relations 250.00 250.00 0.00 191.59 58.41 76.6 180-021-000-50500 Engineering 1,500.00 1,500.00 0.00 80.14 1,419.86 5.3 180-021-000-57000 Independent Labor 200.00 200.00 0.00 0.00 200.00 # 180-021-000-60300 Postage 150.00 150.00 0.00 0.00 150.00 # 180-021-000-61000 Fuel 11,700.00 11,700.00 2,319.06 10,384.50 1,315.50 88.8 180-021-000-62100 Uniforms 2,505.00 2,505.00 0.00 860.75 1,644.25 34.4 180-021-000-62300 Chemicals 12,500.00 12,500.00 2,846.00 2,846.00 9,654.00 22.8 180-021-000-72100 Electricity 23,625.00 23,625.00 2,960.28 16,921.64 6,703.36 71.6 180-021-000-72200 Water 750.00 750.00 0.00 0.00 750.00 # 180-021-000-73100 Telephone 0.00 0.00 0.63 22.26 (22.26) # 180-021-000-73200 Communications /Pagers/Mobiles 2,796.00 2,796.00 0.00 2,332.91 463.09 83.4 180-021-000-74100 Dues & Membership 255.00 255.00 111.00 172.00 83.00 67.5 180-021-000-74200 Travel & per diem 1,500.00 1,500.00 81.44 665.34 834.66 44.4 180-021-000-74300 Schools & Training 2,818.00 2,818.00 0.00 55.00 2,763.00 2.0 180-021-000-74700 Safety Program 750.00 750.00 0.00 7.18 742.82 1.0 180-021-000-78200 Small Tools 1,500.00 1,500.00 0.00 220.58 1,279.42 14.7 180-021-000-78300 Safety Equipment 1,150.00 1,150.00 0.00 62.84 1,087.16 5.5 180-021-000-78600 Hardware 750.00 750.00 0.00 0.00 750.00 # 180-021-000-79150 Equipment Rental/Lease 44,107.00 44,107.00 0.00 0.00 44,107.00 # 180-021-000-79999 Miscellaneous Expense 100.00 100.00 0.00 0.00 100.00 # 180-021-000-80250 Maintenance and Repairs 23,700.00 23,700.00 0.00 4,175.22 19,524.78 17.6 180-021-000-81100 Property Maintenance 1,000.00 1,000.00 0.00 0.00 1,000.00 # 180-021-000-81200 Building Maintenance 750.00 750.00 0.00 0.00 750.00 # 180-021-000-81300 Vehicle Maintenance 8,143.00 8,143.00 0.00 5,841.37 2,301.63 71.7 180-021-000-81900 Maintenance Supplies 16,050.00 16,050.00 78.91 2,129.54 13,920.46 13.3 180-021-000-93700 Capital Expenses 15,000.00 15,000.00 10,979.25 10,979.25 4,020.75 73.2 180-021-000-97000 Capital Repairs 20,000.00 20,000.00 0.00 0.00 20,000.00 # page 5 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 Page 66 of 121 Meeting Date: September 20, 2011 Total Collection 416,658.00 416,658.00 37,719.98 256,309.33 160,348.67 page 6 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 Page 67 of 121 Meeting Date: September 20, 2011 180-130-000-40100 Salaries - Regular 10,000.00 10,000.00 1,000.00 6,400.00 3,600.00 64.0 180-130-000-42220 Social Security Taxes 620.00 620.00 62.00 396.80 223.20 64.0 180-130-000-42225 Medicare Taxes 145.00 145.00 14.50 92.80 52.20 64.0 180-130-000-42250 Unemployment Taxes 210.00 210.00 8.00 74.60 135.40 35.5 180-130-000-42260 Workman's Compensation 120.00 120.00 0.00 113.88 6.12 94.9 180-130-000-60100 Office Supplies 50.00 50.00 0.00 0.00 50.00 # 180-130-000-60300 Postage 0.00 0.00 0.00 (1.86)1.86 # 180-130-000-60400 Publications/Books/Subscriptions 50.00 50.00 0.00 0.00 50.00 # 180-130-000-74100 Dues & Membership 2,100.00 2,100.00 0.00 79.00 2,021.00 3.8 180-130-000-74200 Travel & per diem 5,805.00 5,805.00 0.00 968.26 4,836.74 16.7 180-130-000-74300 Schools & Training 4,000.00 4,000.00 0.00 2,140.00 1,860.00 53.5 180-130-000-74600 Meetings 1,278.00 1,278.00 37.00 326.00 952.00 25.5 180-130-000-79999 Miscellaneous Expense 150.00 150.00 0.00 0.00 150.00 # 180-130-000-87110 Water Conservation Program/Public Information 0.00 0.00 0.00 2,334.72 (2,334.72) # Total Board of Directors 24,528.00 24,528.00 1,121.50 12,924.20 11,603.80 page 7 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 Page 68 of 121 Meeting Date: September 20, 2011 180-140-000-40100 Salaries - Regular 214,374.00 214,374.00 13,240.34 183,599.40 30,774.60 85.6 180-140-000-40130 Salaries - Overtime 500.00 500.00 30.83 292.89 207.11 58.6 180-140-000-40140 Salaries - Longevity 2,580.00 2,580.00 0.00 2,755.00 (175.00) 106.8 180-140-000-41200 Retirement 30,360.00 30,360.00 1,834.03 25,705.57 4,654.43 84.7 180-140-000-41210 Medical Insurance 17,925.00 17,925.00 1,395.92 17,061.78 863.22 95.2 180-140-000-41215 Dental Insurance 930.00 930.00 77.42 873.71 56.29 93.9 180-140-000-41216 Vision Insurance 179.00 179.00 14.87 162.83 16.17 91.0 180-140-000-41218 Life Insurance & Other 1,205.00 1,205.00 0.00 390.74 814.26 32.4 180-140-000-42220 Social Security Taxes 13,474.00 13,474.00 772.14 11,494.04 1,979.96 85.3 180-140-000-42225 Medicare Taxes 3,151.00 3,151.00 180.59 2,711.82 439.18 86.1 180-140-000-42250 Unemployment Taxes 630.00 630.00 19.67 467.54 162.46 74.2 180-140-000-42260 Workman's Compensation 783.00 783.00 0.00 743.12 39.88 94.9 180-140-000-42290 Pre-employment Physicals/Testing 0.00 0.00 7.25 82.17 (82.17) # 180-140-000-42960 Employee Relations 1,000.00 1,000.00 2.50 908.67 91.33 90.9 180-140-000-50100 Professional Outside Services 229,076.00 229,076.00 0.00 228,075.63 1,000.37 99.6 180-140-000-52100 Elections 2,500.00 2,500.00 0.00 1,952.65 547.35 78.1 180-140-000-54200 Records Management 500.00 500.00 0.00 120.00 380.00 24.0 180-140-000-57000 Independent Labor 840.00 840.00 0.00 406.87 433.13 48.4 180-140-000-60100 Office Supplies 2,450.00 2,450.00 159.81 1,506.00 944.00 61.5 180-140-000-60300 Postage 1,571.00 1,571.00 217.22 2,171.31 (600.31) 138.2 180-140-000-60400 Publications/Books/Subscriptions 450.00 450.00 0.00 215.40 234.60 47.9 180-140-000-73100 Telephone 200.00 200.00 18.42 215.15 (15.15) 107.6 180-140-000-73200 Communications /Pagers/Mobiles 1,798.00 1,798.00 56.22 2,382.95 (584.95) 132.5 180-140-000-73300 Advertising 1,500.00 1,500.00 0.00 0.00 1,500.00 # 180-140-000-73400 Printing 515.00 515.00 0.00 3,170.00 (2,655.00) 615.5 180-140-000-73600 Service Charges & Fees 0.00 0.00 0.00 32.50 (32.50) # 180-140-000-74100 Dues & Membership 1,612.00 1,612.00 455.00 2,169.50 (557.50) 134.6 180-140-000-74200 Travel & per diem 3,088.00 3,088.00 0.00 1,201.01 1,886.99 38.9 180-140-000-74300 Schools & Training 2,555.00 2,555.00 619.91 2,260.84 294.16 88.5 180-140-000-74600 Meetings 312.00 312.00 67.83 183.83 128.17 58.9 180-140-000-76700 July 4 Celebration 10,000.00 10,000.00 10,000.00 10,000.00 0.00 100.0 180-140-000-78500 Furniture/Equipment<$5,000 1,750.00 1,750.00 0.00 4,081.30 (2,331.30) 233.2 180-140-000-79999 Miscellaneous Expense 100.00 100.00 10.06 10.06 89.94 10.1 Total Managers Office 547,908.00 547,908.00 29,180.03 507,404.28 40,503.72 page 8 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 Page 69 of 121 Meeting Date: September 20, 2011 180-611-000-40100 Salaries - Regular 70,839.00 70,839.00 5,449.60 60,371.56 10,467.44 85.2 180-611-000-40130 Salaries - Overtime 3,500.00 3,500.00 670.81 12,713.60 (9,213.60) 363.2 180-611-000-40140 Salaries - Longevity 1,710.00 1,710.00 0.00 1,710.00 0.00 100.0 180-611-000-41200 Retirement 10,647.00 10,647.00 866.65 10,672.39 (25.39) 100.2 180-611-000-41210 Medical Insurance 8,583.00 8,583.00 715.24 8,332.23 250.77 97.1 180-611-000-41215 Dental Insurance 393.00 393.00 43.06 452.78 (59.78) 115.2 180-611-000-41216 Vision Insurance 75.00 75.00 4.98 54.78 20.22 73.0 180-611-000-41218 Life Insurance & Other 424.00 424.00 0.00 146.23 277.77 34.5 180-611-000-42220 Social Security Taxes 4,697.00 4,697.00 319.00 4,125.37 571.63 87.8 180-611-000-42225 Medicare Taxes 1,099.00 1,099.00 74.61 964.81 134.19 87.8 180-611-000-42250 Unemployment Taxes 180.00 180.00 0.00 129.59 50.41 72.0 180-611-000-42260 Workman's Compensation 274.00 274.00 0.00 260.04 13.96 94.9 180-611-000-50100 Professional Outside Services 5,000.00 5,000.00 0.00 2,437.50 2,562.50 48.7 180-611-000-60100 Office Supplies 600.00 600.00 0.00 495.65 104.35 82.6 180-611-000-60300 Postage 500.00 500.00 56.72 363.47 136.53 72.7 180-611-000-60400 Publications/Books/Subscriptions 250.00 250.00 0.00 0.00 250.00 # 180-611-000-73100 Telephone 100.00 100.00 3.01 16.19 83.81 16.2 180-611-000-73200 Communications /Pagers/Mobiles 670.00 670.00 0.00 560.98 109.02 83.7 180-611-000-73300 Advertising 500.00 500.00 0.00 207.40 292.60 41.5 180-611-000-73400 Printing 500.00 500.00 0.00 0.00 500.00 # 180-611-000-73600 Service Charges & Fees 77.00 77.00 0.00 0.00 77.00 # 180-611-000-74100 Dues & Membership 413.00 413.00 95.00 117.00 296.00 28.3 180-611-000-74200 Travel & per diem 1,547.00 1,547.00 7.05 152.18 1,394.82 9.8 180-611-000-74300 Schools & Training 1,040.00 1,040.00 0.00 309.00 731.00 29.7 180-611-000-74600 Meetings 88.00 88.00 25.00 25.00 63.00 28.4 Total Finance 113,706.00 113,706.00 8,330.73 104,617.75 9,088.25 page 9 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 Page 70 of 121 Meeting Date: September 20, 2011 180-620-000-40100 Salaries - Regular 112,537.00 112,537.00 7,392.09 80,068.82 32,468.18 71.1 180-620-000-40130 Salaries - Overtime 1,500.00 1,500.00 322.91 1,029.34 470.66 68.6 180-620-000-40140 Salaries - Longevity 245.00 245.00 0.00 405.00 (160.00) 165.3 180-620-000-41200 Retirement 15,999.00 15,999.00 1,092.44 11,035.32 4,963.68 69.0 180-620-000-41210 Medical Insurance 21,773.00 21,773.00 1,612.79 16,388.23 5,384.77 75.3 180-620-000-41215 Dental Insurance 1,136.00 1,136.00 104.81 1,007.58 128.42 88.7 180-620-000-41216 Vision Insurance 209.00 209.00 18.48 177.91 31.09 85.1 180-620-000-41218 Life Insurance & Other 800.00 800.00 0.00 260.31 539.69 32.5 180-620-000-42220 Social Security Taxes 7,029.00 7,029.00 413.62 4,782.06 2,246.94 68.0 180-620-000-42225 Medicare Taxes 1,644.00 1,644.00 96.74 1,118.39 525.61 68.0 180-620-000-42250 Unemployment Taxes 540.00 540.00 16.87 410.47 129.53 76.0 180-620-000-42260 Workman's Compensation 411.00 411.00 0.00 390.08 20.92 94.9 180-620-000-42290 Pre-employment Physicals/Testing 0.00 0.00 7.75 30.23 (30.23) # 180-620-000-56200 Utility Billing Contract 11,000.00 11,000.00 0.00 8,840.88 2,159.12 80.4 180-620-000-57000 Independent Labor 800.00 800.00 0.00 0.00 800.00 # 180-620-000-60100 Office Supplies 700.00 700.00 98.44 504.43 195.57 72.1 180-620-000-60300 Postage 18,000.00 18,000.00 0.00 13,158.75 4,841.25 73.1 180-620-000-73100 Telephone 100.00 100.00 7.50 105.78 (5.78) 105.8 180-620-000-73200 Communications /Pagers/Mobiles 472.00 472.00 0.00 410.36 61.64 86.9 180-620-000-73400 Printing 3,000.00 3,000.00 0.00 2,152.00 848.00 71.7 180-620-000-73600 Service Charges & Fees 18,000.00 18,000.00 2,355.60 20,511.35 (2,511.35) 114.0 180-620-000-74100 Dues & Membership 71.00 71.00 0.00 0.00 71.00 # 180-620-000-74200 Travel & per diem 605.00 605.00 24.98 55.07 549.93 9.1 180-620-000-74300 Schools & Training 800.00 800.00 0.00 46.44 753.56 5.8 180-620-000-75600 TCEQ Annual Assessment Fee 20,000.00 20,000.00 0.00 19,248.17 751.83 96.2 180-620-000-79999 Miscellaneous Expense 200.00 200.00 0.00 1.84 198.16 0.9 Total Utility Billing 237,571.00 237,571.00 13,565.02 182,138.81 55,432.19 page 10 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 Page 71 of 121 Meeting Date: September 20, 2011 180-630-000-42290 Pre-employment Physicals/Testing 1,260.00 1,260.00 0.00 152.41 1,107.59 12.1 180-630-000-42960 Employee Relations 1,788.00 1,788.00 107.87 626.72 1,161.28 35.1 180-630-000-43240 Tuition Reimbursement 1,530.00 1,530.00 0.00 74.65 1,455.35 4.9 180-630-000-60100 Office Supplies 424.00 424.00 0.00 0.00 424.00 # 180-630-000-60300 Postage 104.00 104.00 0.00 0.00 104.00 # 180-630-000-60400 Publications/Books/Subscriptions 462.00 462.00 0.00 0.00 462.00 # 180-630-000-73100 Telephone 27.00 27.00 0.00 0.00 27.00 # 180-630-000-73400 Printing 113.00 113.00 0.00 0.00 113.00 # 180-630-000-74100 Dues & Membership 529.00 529.00 0.00 0.00 529.00 # 180-630-000-74200 Travel & per diem 8.00 8.00 0.00 0.00 8.00 # 180-630-000-74300 Schools & Training 566.00 566.00 0.00 0.00 566.00 # 180-630-000-74600 Meetings 134.00 134.00 0.00 0.00 134.00 # Total Human Resources 6,945.00 6,945.00 107.87 853.78 6,091.22 page 11 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 Page 72 of 121 Meeting Date: September 20, 2011 180-640-000-50700 Security 1,350.00 1,350.00 145.24 187.75 1,162.25 13.9 180-640-000-55000 Software & Support 50,453.00 50,453.00 6,788.49 50,224.94 228.06 99.5 180-640-000-57000 Independent Labor 1,464.00 1,464.00 0.00 2,348.75 (884.75) 160.4 180-640-000-60100 Office Supplies 371.00 371.00 25.42 270.03 100.97 72.8 180-640-000-60200 Printer Supplies 5,732.00 5,732.00 1,516.50 6,752.96 (1,020.96) 117.8 180-640-000-73100 Telephone 8,040.00 8,040.00 816.20 9,595.33 (1,555.33) 119.3 180-640-000-74200 Travel & per diem 0.00 0.00 0.00 16.18 (16.18) # 180-640-000-75900 Prompt Payment Interest 0.00 0.00 0.00 14.53 (14.53) # 180-640-000-78600 Hardware 60,152.00 60,152.00 1,690.46 38,745.09 21,406.91 64.4 180-640-000-79100 Copier Rental/Lease 3,450.00 3,450.00 273.29 2,732.90 717.10 79.2 180-640-000-99500 Transfer to Future Replacement Reserve 26,911.00 26,911.00 26,911.00 26,911.00 0.00 100.0 Total Information Services 157,923.00 157,923.00 38,166.60 137,799.46 20,123.54 page 12 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 Page 73 of 121 Meeting Date: September 20, 2011 180-710-000-52400 Lab Analysis 0.00 0.00 0.00 1,168.75 (1,168.75) # 180-710-000-62520 Vending Machine Supplies 1,000.00 1,000.00 0.00 429.28 570.72 42.9 180-710-000-72100 Electricity 20,895.00 20,895.00 1,426.32 12,391.29 8,503.71 59.3 180-710-000-72200 Water 1,061.00 1,061.00 0.00 560.41 500.59 52.8 180-710-000-75000 Insurance 31,081.00 31,081.00 100.00 23,575.81 7,505.19 75.9 180-710-000-79200 Building Rental/Lease 13,182.00 13,182.00 1,098.51 12,083.61 1,098.39 91.7 180-710-000-81200 Building Maintenance 11,970.00 11,970.00 47.50 13,446.44 (1,476.44) 112.3 180-710-000-81600 Cleaning Services 9,450.00 9,450.00 678.18 7,541.63 1,908.37 79.8 180-710-000-81900 Maintenance Supplies 2,100.00 2,100.00 150.28 1,680.74 419.26 80.0 Total Facilities Maintenance 90,739.00 90,739.00 3,500.79 72,877.96 17,861.04 page 13 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 Page 74 of 121 Meeting Date: September 20, 2011 180-810-000-50200 Auditing 27,500.00 27,500.00 0.00 27,500.00 0.00 100.0 180-810-000-50300 Legal 35,000.00 35,000.00 11,894.30 39,827.61 (4,827.61) 113.8 180-810-000-51100 Appraisal 20,211.00 20,211.00 0.00 12,269.68 7,941.32 60.7 180-810-000-51150 Tax Administration 3,603.00 3,603.00 0.00 2,696.56 906.44 74.8 180-810-000-99510 Transfer to Fire Construction Fund 0.00 0.00 272,718.65 272,718.65 (272,718.65) # Total Non Departmental 86,314.00 86,314.00 284,612.95 355,012.50 (268,698.50) Total Expenses 4,848,732.00 4,848,732.00 917,680.12 4,393,914.92 454,817.08 page 14 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 Page 75 of 121 Meeting Date: September 20, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit Balance180-000-000-30100Property TaxesBalance Forward-86,555.36CR08/01/2011MUD 1 AV Taxes1868833.3708/02/2011MUD 1 AV Taxes198078.2508/03/2011MUD 1 AV Taxes186908.1808/04/2011MUD 1 AV Taxes186924.8208/05/2011MUD 1 AV Taxes1869539.3908/30/2011MUD 1 AV Taxes1995317.61Total0.00111.62 -86,666.98 CR180-000-000-30125Property Taxes/DelinquentBalance Forward-767.24CR08/10/2011MUD 1 AV Taxes197995.6608/30/2011Advalorem Taxes1995172.24Total0.0077.90-845.14 CR180-000-000-30150Property Taxes/Penalty & InterestBalance Forward-1,407.11CR08/02/2011Advalorem Taxes198070.4808/04/2011Advalorem Taxes186921.4908/05/2011Advalorem Taxes186957.4808/10/2011Advalorem Taxes197996.0608/30/2011Advalorem Taxes1995157.0608/30/2011Advalorem Taxes199533.35Total0.0075.92 -1,483.03 CR180-000-000-35050Interest IncomeBalance Forward-4,757.21CR08/31/2011August Bank Interest20256129.2008/31/2011August Bank Interest20256213.21Total0.00342.41 -5,099.62 CR180-000-000-35150Cell Tower Lease RevenueBalance Forward-8,470.00CR08/23/2011AT&T August Cell Tower Lease19002847.00Total0.00847.00 -9,317.00 CR180-000-000-35160Lease/Rental RevenueBalance Forward0.00Total0.000.000.00180-000-000-35170Building RentBalance Forward-5,833.30CR08/23/2011Town/August Maint Barn Rent19004583.33Total0.00583.33 -6,416.63 CR180-000-000-35420Loan ProceedsBalance Forward0.00Total0.000.000.00180-000-000-35430Capital Lease ProceedsBalance Forward0.00Total0.000.000.00180-000-000-36100Gas Well RevenuesBalance Forward-765.35CR08/26/2011Encana/gas well revenue1939589.06Total0.0089.06-854.41 CR180-000-000-36400Auction SalesBalance Forward-202.12CRTotal0.00 0.00 -202.12 CR180-000-000-36500Vending RevenueBalance Forward-830.81CRTotal0.00 0.00 -830.81 CR180-000-000-36700Miscellaneous RevenueBalance Forward-9,311.10CR08/31/2011Backflow testing/My Cherryo2003350.00Trophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011TCMUD No. 1Page 76 of 121Meeting Date: September 20, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011Total0.00 50.00 -9,361.10 CR180-000-000-36900Recovery of Prior Year ExpenseBalance Forward-2,119.00CRTotal0.00 0.00 -2,119.00 CR180-000-000-37100Prior Year ReservesBalance Forward0.00Total0.000.000.00180-000-000-38100Water - ResidentialBalance Forward-1,423,090.59CR08/09/2011UB Adjustments186724.7308/11/2011UB Adjustments186860.1008/31/2011August Credit Adjustments200352,411.8108/31/2011UB August Billing20037342,579.23Total0.00 344,995.87 -1,768,086.46 CR180-000-000-38120Water - CommercialBalance Forward-581,568.69CR08/31/2011August Credit Adjustments20035203.8508/31/2011UB August Billing20037161,432.98Total203.85 161,432.98 -742,797.82 CR180-000-000-38130Water - PIDBalance Forward-235,260.09CR08/23/2011PID July billed1900857,605.03Total0.00 57,605.03 -292,865.12 CR180-000-000-38140Portable Meters - Out of DistrictBalance Forward-39,493.67CR08/05/2011UB Adjustments182625,001.7608/15/2011UB Adjustments18892200.0008/23/2011UB Late Fees Applied19377429.6308/31/2011UB August Billing2003710,689.13Total5,001.76 11,318.76 -45,810.67 CR180-000-000-38200Sewer - ResidentialBalance Forward-913,112.80CR08/09/2011UB Adjustments186724.9608/11/2011UB Adjustments186860.0908/31/2011August Credit Adjustments200351,741.9408/31/2011UB August Billing20037118,637.15Total1,746.99 118,637.15 -1,030,002.96 CR180-000-000-38220Sewer - CommercialBalance Forward-233,367.76CR08/31/2011August Credit Adjustments2003581.1208/31/2011UB August Billing2003729,003.48Total81.12 29,003.48 -262,290.12 CR180-000-000-38230Sewer - PIDBalance Forward-128,816.61CR08/23/2011PID July billed1900819,404.62Total0.00 19,404.62 -148,221.23 CR180-000-000-38240Sewer - Out of DistrictBalance Forward-13,690.42CR08/31/2011UB August Billing200372,191.83Total0.00 2,191.83 -15,882.25 CR180-000-000-38250TCCC Effluent ChargesBalance Forward-44,098.53CR08/23/2011TCCC July Effluent1900615,424.76Total0.00 15,424.76 -59,523.29 CR180-000-000-38300StandbyBalance Forward-607.60CR08/31/2011August Credit Adjustments2003518.00TCMUD No. 1Page 77 of 121Meeting Date: September 20, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/201108/31/2011UB August Billing2003778.00Total18.0078.00-667.60 CR180-000-000-38320PenaltiesBalance Forward-36,675.75CR08/23/2011UB Late Fees Applied193774,576.9308/31/2011August Credit Adjustments20035178.4508/31/2011Reverse & Correct JE 20040/UB20366244.69Total244.69 4,755.38 -41,186.44 CR180-000-000-38340Service ChargesBalance Forward-12,936.42CR08/01/2011UB NSF Service Charge2029625.0008/10/2011UB Adjustments18676675.0008/10/2011UB Adjustments1868050.0008/12/2011UB Adjustments Made1935925.0008/15/2011UB Adjustments Taken1936325.0008/22/2011UB Adjustments1936725.0008/22/2011UB Adjustments Taken1977725.0008/31/2011UB August Billing200373.00Total50.00 803.00 -13,689.42 CR180-000-000-38360Penalities - Out of DistrictBalance Forward-270.19CRTotal0.00 0.00 -270.19 CR180-000-000-38400Plumbing InspectionsBalance Forward-1,800.00CR08/18/2011Permits 8/18/111899050.0008/29/2011Permits 8/29/111982550.00Total0.00100.00 -1,900.00 CR180-000-000-38420Sewer InspectionsBalance Forward-5,400.00CR08/18/2011Permits 8/18/1118990150.0008/29/2011 Permits 8/29/11 19825150.00Total0.00300.00 -5,700.00 CR180-000-000-38500PID Utility FeesBalance Forward-80,500.00CR08/03/2011Permits 8/3/111898411,500.0008/04/2011Permits 8/4/11189864,600.0008/10/2011Permits 8/10/11189882,300.0008/24/2011Permits 8/24/11193892,300.0008/25/2011Permits 8/25/11193934,600.0008/29/2011Permits 8/29/11198252,300.00Total0.00 27,600.00 -108,100.00 CR180-000-000-38520Tap FeesBalance Forward0.00Total0.000.000.00180-000-000-38540Sewer/Septic Dump FeesBalance Forward0.00Total0.000.000.00180-000-000-38560Fire Line FeesBalance Forward-525.00CRTotal0.00 0.00 -525.00 CR180-000-000-38600Oversize Meter ReimbursementsBalance Forward-54,447.69CR08/03/2011Permits 8/3/11189841,460.0008/04/2011Permits 8/4/1118986584.0008/10/2011Permits 8/10/1118988292.0008/18/2011Permits 8/18/1118990292.0008/23/2011Permits 8/23/11193874,758.6008/24/2011Permits 8/24/1119389292.00TCMUD No. 1Page 78 of 121Meeting Date: September 20, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/201108/25/2011Permits 8/25/1119393584.0008/29/2011 Permits 8/29/11 19825292.00Total0.00 8,554.60 -63,002.29 CR180-000-000-39200Transfer In - General FundBalance Forward0.00Total0.000.000.00180-000-000-39290Transfer In - Future Replacement ReserveBalance Forward0.00Total0.000.000.00180-010-000-40100Salaries - RegularBalance Forward110,193.1108/05/2011Payroll 08/05/11186386,143.8608/19/2011Payroll 08/19/11190466,151.36Total12,295.220.00 122,488.33180-010-000-40130Salaries - OvertimeBalance Forward12,312.2608/05/2011Payroll 08/05/11186382,000.8408/19/2011Payroll 08/19/1119046959.79Total2,960.630.00 15,272.89180-010-000-40140Salaries - LongevityBalance Forward2,150.00Total0.000.00 2,150.00180-010-000-40160Salaries - CertificationBalance Forward1,430.0008/19/2011 Payroll 08/19/11 19046150.00Total150.000.00 1,580.00180-010-000-41200RetirementBalance Forward17,887.0508/05/2011Payroll 08/05/11186381,153.3008/19/2011Payroll 08/19/11190461,028.18Total2,181.480.00 20,068.53180-010-000-41210Medical InsuranceBalance Forward19,153.3908/05/2011Payroll 08/05/11186381,062.9808/19/2011Payroll 08/19/11190461,529.27Total2,592.250.00 21,745.64180-010-000-41215Dental InsuranceBalance Forward1,061.4608/05/2011Payroll 08/05/111863863.7208/19/2011Payroll 08/19/111904667.20Total130.920.00 1,192.38180-010-000-41216Vision InsuranceBalance Forward190.4308/05/2011Payroll 08/05/111863811.1408/19/2011Payroll 08/19/111904611.81Total22.950.00213.38180-010-000-41218Life Insurance & OtherBalance Forward313.00Total0.000.00313.00180-010-000-42220Social Security TaxesBalance Forward7,458.9508/05/2011Payroll 08/05/1118638479.5608/19/2011Payroll 08/19/1119046395.90Total875.460.00 8,334.41180-010-000-42225Medicare TaxesBalance Forward1,744.4308/05/2011Payroll 08/05/1118638112.15TCMUD No. 1Page 79 of 121Meeting Date: September 20, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/201108/19/2011Payroll 08/19/111904692.60Total204.750.00 1,949.18180-010-000-42250Unemployment TaxesBalance Forward329.40Total0.000.00329.40180-010-000-42260Workman's CompensationBalance Forward7,368.69Total0.000.00 7,368.69180-010-000-42290Pre-employment Physicals/TestingBalance Forward0.00Total0.000.000.00180-010-000-42960Employee RelationsBalance Forward226.0408/31/2011Breakfast for safety meeting19834Laurie Slaght04261125.0008/31/2011Replacement check for 4/28/1120122Laurie Slaght08311125.00Total25.0025.00226.04180-010-000-50500EngineeringBalance Forward80.15Total0.000.0080.15180-010-000-52400Lab AnalysisBalance Forward2,073.0008/11/2011Lab Analysis18530Lower Colorado River AuthorityLB858851,391.0008/11/2011Lab Cultures18562Tarrant County Public Health Lab 21053180.00Total1,571.000.00 3,644.00180-010-000-57000Independent LaborBalance Forward0.00Total0.000.000.00180-010-000-58000Bulk WaterBalance Forward931,001.0608/31/2011 July Water 20136 City of Fort Worth 082911 230,157.11Total230,157.110.00 1,161,158.17180-010-000-60300PostageBalance Forward13.35Total0.000.0013.35180-010-000-60400Publications/Books/SubscriptionsBalance Forward0.00Total0.000.000.00180-010-000-61000FuelBalance Forward7,994.1108/01/2011Gas Log/July190121,523.2608/04/2011Adrian Womack18522JP Morgan Chase Bank NA0720201140.0808/31/2011August Gas log202761,536.29Total3,099.630.00 11,093.74180-010-000-62100UniformsBalance Forward1,882.87Total0.000.00 1,882.87180-010-000-62300ChemicalsBalance Forward3,214.6408/04/2011 Adrian Womack 18522 JP Morgan Chase Bank NA 07202011 312.26Total312.260.00 3,526.90180-010-000-72100ElectricityBalance Forward115,076.4208/02/2011Electricity 7/5-8/219201Tri County Electric2309888001 081127.6908/17/2011Electricity 7/15-8/1519163Hudson Energy2219284625.0608/23/2011Electricity 7/15-8/1519437Hudson Energy1674026,196.96Total26,849.710.00 141,926.13TCMUD No. 1Page 80 of 121Meeting Date: September 20, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011180-010-000-73200Communications /Pagers/MobilesBalanceForward1,515.13Total0.000.00 1,515.13180-010-000-73350CopiesBalance Forward0.00Total0.000.000.00180-010-000-73400PrintingBalance Forward0.00Total0.000.000.00180-010-000-74100Dues & MembershipBalance Forward61.00Total0.000.0061.00180-010-000-74200Travel & per diemBalance Forward866.9408/05/2011Payroll 08/05/1118638102.5108/19/2011Payroll 08/19/1119046167.0608/31/2011Mike McMahon20610JP Morgan Chase Bank NA0831201189.27Total358.84 0.00 1,225.78180-010-000-74300Schools & TrainingBalance Forward1,508.0008/04/2011Adrian Womack18522JP Morgan Chase Bank NA07202011175.0008/11/2011Lance Holt-Ground Water Production Train18540TEEX08222011250.00Total425.000.00 1,933.00180-010-000-74700Safety ProgramBalance Forward7.17Total0.000.007.17180-010-000-75200Annual Permit FeeBalance Forward6,133.95Total0.000.00 6,133.95180-010-000-78100Meter ExpenseBalance Forward83,182.2408/16/2011 Mary Moore 18704 JP Morgan Chase Bank NA 08162011 3,381.65Total3,381.650.00 86,563.89180-010-000-78200Small ToolsBalance Forward284.8708/16/2011 Adrian Womack 18704 JP Morgan Chase Bank NA 08162011 3,684.61Total3,684.610.00 3,969.48180-010-000-78300Safety EquipmentBalance Forward0.0008/04/2011 Mike McMahon 18522 JP Morgan Chase Bank NA 07202011 229.92Total229.920.00229.92180-010-000-78500Furniture/Equipment<$5,000Balance Forward0.00Total0.000.000.00180-010-000-78600HardwareBalance Forward0.00Total0.000.000.00180-010-000-79150Equipment Rental/LeaseBalance Forward770.00Total0.000.00770.00180-010-000-79400Bad Debt ExpenseBalance Forward2,172.73Total0.000.00 2,172.73180-010-000-79999Miscellaneous ExpenseBalance Forward0.00Total0.000.000.00TCMUD No. 1Page 81 of 121Meeting Date: September 20, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011180-010-000-80250Maintenance and RepairsBalance Forward7,329.6108/04/2011Adrian Womack18522JP Morgan Chase Bank NA0720201156.0708/04/2011Adrian Womack18522JP Morgan Chase Bank NA07202011984.1708/04/2011Adrian Womack18522JP Morgan Chase Bank NA07202011361.8508/11/2011Maintenance and repairs on Well18558Circle R Electric Co39671,057.5008/16/2011Adrian Womack18704JP Morgan Chase Bank NA08162011423.1708/31/2011Water Plant Effluent Flow Meter Re-Scale20124DHS Automation,Inc06-878440.0008/31/2011Concrete - Lee Ct.20130Lattimore Materials Co413705331.2508/31/2011Adrian Womack20610JP Morgan Chase Bank NA08312011302.51Total3,956.520.00 11,286.13180-010-000-80300Non-routine MaintenanceBalance Forward0.00Total0.000.000.00180-010-000-81100Property MaintenanceBalance Forward702.8508/16/2011 Adrian Womack 18704 JP Morgan Chase Bank NA 08162011 594.00Total594.000.00 1,296.85180-010-000-81200Building MaintenanceBalance Forward0.00Total0.000.000.00180-010-000-81300Vehicle MaintenanceBalance Forward2,182.5008/04/2011Adrian Womack18522JP Morgan Chase Bank NA0720201134.9608/16/2011Mike McMahon18704JP Morgan Chase Bank NA08162011383.4008/31/2011Mike McMahon20610JP Morgan Chase Bank NA08312011400.00Total818.360.00 3,000.86180-010-000-81360Maintenance - Backhoe/Skid LoaderBalance Forward0.00Total0.000.000.00180-010-000-81500Lawn MaintenanceBalance Forward0.00Total0.000.000.00180-010-000-81900Maintenance SuppliesBalance Forward8,128.5108/02/2011July purchases17906Costco Wholesale072611124.8008/16/2011Adrian Womack18704JP Morgan Chase Bank NA081620113,813.4908/16/2011Mike McMahon18704JP Morgan Chase Bank NA08162011355.73Total4,294.020.00 12,422.53180-010-000-91000Capital LeaseBalance Forward0.0008/01/2011 Multi Loan 17876 First Financial Bank 91500005342Multiloan 10,627.13Total10,627.130.00 10,627.13180-010-000-93700Capital ExpensesBalance Forward215,853.4508/31/2011WTP Ground Storage Tanks20140Deltatek Engineering826111,605.0008/31/2011Recode Water Capital Project to Gen Fund2027038,100.0008/31/2011Recode Water Capital Project to Gen Fund2027058,800.0008/31/2011Recode Water Capital Project to Gen Fund20270500.0008/31/2011Recode Water Capital Project to Gen Fund2027014,762.31Total113,767.310.00 329,620.76180-010-000-97000Capital RepairsBalance Forward0.00Total0.000.000.00180-010-000-97100Capital Repairs - Ground StorageBalance Forward97,741.64Total0.000.00 97,741.64TCMUD No. 1Page 82 of 121Meeting Date: September 20, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011180-010-000-99100Transfer to General FundBalanceForward0.00Total0.000.000.00180-010-000-99500Transfer to Future Replacement ReserveBalance Forward0.0008/31/2011 GASB Transfers 2027430,000.00Total30,000.000.00 30,000.00180-020-000-40100Salaries - RegularBalance Forward139,514.0508/05/2011Payroll 08/05/11186386,799.3008/19/2011Payroll 08/19/11190466,801.60Total13,600.900.00 153,114.95180-020-000-40130Salaries - OvertimeBalance Forward11,442.4708/05/2011Payroll 08/05/1118638422.8308/19/2011Payroll 08/19/1119046837.90Total1,260.730.00 12,703.20180-020-000-40140Salaries - LongevityBalance Forward3,482.50Total0.000.00 3,482.50180-020-000-40160Salaries - CertificationBalance Forward1,975.0008/19/2011 Payroll 08/19/11 19046200.00Total200.000.00 2,175.00180-020-000-41200RetirementBalance Forward22,103.5608/05/2011Payroll 08/05/11186381,022.6508/19/2011Payroll 08/19/11190461,110.08Total2,132.730.00 24,236.29180-020-000-41210Medical InsuranceBalance Forward30,638.7708/05/2011Payroll 08/05/11186381,392.6608/19/2011Payroll 08/19/11190461,392.66Total2,785.320.00 33,424.09180-020-000-41215Dental InsuranceBalance Forward1,534.3508/05/2011Payroll 08/05/111863877.4908/19/2011Payroll 08/19/111904677.49Total154.980.00 1,689.33180-020-000-41216Vision InsuranceBalance Forward297.6008/05/2011Payroll 08/05/111863814.8808/19/2011Payroll 08/19/111904614.88Total29.760.00327.36180-020-000-41218Life Insurance & OtherBalance Forward444.77Total0.000.00444.77180-020-000-42220Social Security TaxesBalance Forward8,439.0808/05/2011Payroll 08/05/1118638376.2608/19/2011Payroll 08/19/1119046414.53Total790.790.00 9,229.87180-020-000-42225Medicare TaxesBalance Forward1,973.6608/05/2011Payroll 08/05/111863887.9908/19/2011Payroll 08/19/111904696.95Total184.940.00 2,158.60TCMUD No. 1Page 83 of 121Meeting Date: September 20, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011180-020-000-42250Unemployment TaxesBalanceForward434.45Total0.000.00434.45180-020-000-42260Workman's CompensationBalance Forward7,981.82Total0.000.00 7,981.82180-020-000-42960Employee RelationsBalance Forward151.8808/31/2011Breakfast for safety meeting19834Laurie Slaght04261125.0008/31/2011Replacement check for 4/28/1120122Laurie Slaght08311125.00Total25.0025.00151.88180-020-000-50500EngineeringBalance Forward2,800.00Total0.000.00 2,800.00180-020-000-52400Lab AnalysisBalance Forward9,978.7508/04/2011Mary Moore18522JP Morgan Chase Bank NA072020111,069.5008/31/2011Rodney Greenwood20610JP Morgan Chase Bank NA083120111,080.00Total2,149.500.00 12,128.25180-020-000-57000Independent LaborBalance Forward0.00Total0.000.000.00180-020-000-60100Office SuppliesBalance Forward7.2408/15/2011Office Supplies19439Office Depot57498292200146.2908/16/2011Rodney Greenwood18704JP Morgan Chase Bank NA0816201111.97Total58.260.0065.50180-020-000-60300PostageBalance Forward0.00Total0.000.000.00180-020-000-60400Publications/Books/SubscriptionsBalance Forward0.00Total0.000.000.00180-020-000-61000FuelBalance Forward2,291.1508/01/2011Gas Log/July19012468.9708/31/2011August Gas log20276388.44Total857.410.00 3,148.56180-020-000-62100UniformsBalance Forward1,449.17Total0.000.00 1,449.17180-020-000-62300ChemicalsBalance Forward4,028.2808/16/2011 Jeff Richey 18704 JP Morgan Chase Bank NA 08162011 149.11Total149.110.00 4,177.39180-020-000-62800Lab SuppliesBalance Forward3,559.0608/04/2011Rodney Greenwood18522JP Morgan Chase Bank NA0720201185.8608/16/2011Rodney Greenwood18704JP Morgan Chase Bank NA08162011475.63Total561.490.00 4,120.55180-020-000-62900Other ConsumablesBalance Forward50.14Total0.000.0050.14180-020-000-72100ElectricityBalance Forward165,748.9508/17/2011 Electricity 7/15-8/14 19165 Hudson Energy 16672 16,832.55Total16,832.550.00 182,581.50TCMUD No. 1Page 84 of 121Meeting Date: September 20, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011180-020-000-72200WaterBalanceForward1,288.84Total0.000.00 1,288.84180-020-000-72400Dumpster ServicesBalance Forward11,319.2508/04/2011Mary Moore18522JP Morgan Chase Bank NA0720201163.2508/16/2011Mary Moore18704JP Morgan Chase Bank NA081620111,075.0008/31/2011Sludge Haul Off20100L.H. Chaney Materials, Inc0000036680537.5008/31/2011Sludge Hauling and Disposal Fee Per Yard20104L.H. Chaney Materials, Inc0000035060537.5008/31/2011Sludge hauling and disposal fee per yard20106L.H. Chaney Materials, Inc0000036054537.50Total2,750.750.00 14,070.00180-020-000-73100TelephoneBalance Forward3.3608/31/2011 Steve Z. 20280 Bank of America 082711 6.84Total6.840.0010.20180-020-000-73200Communications /Pagers/MobilesBalance Forward2,848.56Total0.000.00 2,848.56180-020-000-74200Travel & per diemBalance Forward1,910.4008/05/2011Payroll 08/05/111863858.6508/19/2011Payroll 08/19/1119046121.55Total180.200.00 2,090.60180-020-000-74300Schools & TrainingBalance Forward900.00Total0.000.00900.00180-020-000-74700Safety ProgramBalance Forward7.18Total0.000.007.18180-020-000-75200Annual Permit FeeBalance Forward10,704.14Total0.000.00 10,704.14180-020-000-78200Small ToolsBalance Forward481.7108/04/2011Rodney Greenwood18522JP Morgan Chase Bank NA07202011147.8308/16/2011Jeff Richey18704JP Morgan Chase Bank NA0816201116.61Total164.440.00646.15180-020-000-78300Safety EquipmentBalance Forward658.2308/16/2011 Rodney Greenwood 18704 JP Morgan Chase Bank NA 08162011 46.13Total46.130.00704.36180-020-000-78600HardwareBalance Forward35.81Total0.000.0035.81180-020-000-79150Equipment Rental/LeaseBalance Forward0.00Total0.000.000.00180-020-000-79999Miscellaneous ExpenseBalance Forward0.00Total0.000.000.00180-020-000-80250Maintenance and RepairsBalance Forward11,439.0108/04/2011Rodney Greenwood18522JP Morgan Chase Bank NA07202011365.9108/16/2011Rodney Greenwood18704JP Morgan Chase Bank NA0816201129.81Total395.720.00 11,834.73180-020-000-81100Property MaintenanceBalance Forward0.00Total0.000.000.00TCMUD No. 1Page 85 of 121Meeting Date: September 20, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011180-020-000-81200Building MaintenanceBalance Forward0.00Total0.000.000.00180-020-000-81300Vehicle MaintenanceBalance Forward1,049.7408/04/2011Jeff Richey18522JP Morgan Chase Bank NA07202011125.9208/31/2011Rodney Greenwood20610JP Morgan Chase Bank NA08312011240.44Total366.360.00 1,416.10180-020-000-81360Maintenance - Backhoe/Skid LoaderBalance Forward1,126.76Total0.000.00 1,126.76180-020-000-81500Lawn MaintenanceBalance Forward95.90Total0.000.0095.90180-020-000-81900Maintenance SuppliesBalance Forward761.8208/16/2011Rodney Greenwood18704JP Morgan Chase Bank NA0816201193.8008/31/2011Rodney Greenwood20610JP Morgan Chase Bank NA0831201181.21Total175.010.00936.83180-020-000-93700Capital ExpensesBalance Forward124,550.39Total0.000.00 124,550.39180-020-000-97000Capital RepairsBalance Forward1,500.00Total0.000.00 1,500.00180-021-000-40100Salaries - RegularBalance Forward107,736.9608/05/2011Payroll 08/05/11186385,259.3608/19/2011Payroll 08/19/11190465,259.36Total10,518.720.00 118,255.68180-021-000-40130Salaries - OvertimeBalance Forward13,816.4408/05/2011Payroll 08/05/11186382,009.9508/19/2011Payroll 08/19/1119046751.52Total2,761.470.00 16,577.91180-021-000-40140Salaries - LongevityBalance Forward3,160.00Total0.000.00 3,160.00180-021-000-40160Salaries - CertificationBalance Forward1,250.0008/19/2011 Payroll 08/19/11 19046125.00Total125.000.00 1,375.00180-021-000-41200RetirementBalance Forward17,778.4008/05/2011Payroll 08/05/11186381,029.3308/19/2011Payroll 08/19/1119046868.85Total1,898.180.00 19,676.58180-021-000-41210Medical InsuranceBalance Forward21,195.8408/05/2011Payroll 08/05/1118638989.1908/19/2011Payroll 08/19/1119046989.19Total1,978.380.00 23,174.22180-021-000-41215Dental InsuranceBalance Forward1,129.6908/05/2011Payroll 08/05/111863859.4408/19/2011Payroll 08/19/111904659.44Total118.880.00 1,248.57TCMUD No. 1Page 86 of 121Meeting Date: September 20, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011180-021-000-41216Vision InsuranceBalanceForward190.5608/05/2011Payroll 08/05/11186389.9308/19/2011Payroll 08/19/11190469.93Total19.860.00210.42180-021-000-41218Life Insurance & OtherBalance Forward339.73Total0.000.00339.73180-021-000-42220Social Security TaxesBalance Forward7,210.7108/05/2011Payroll 08/05/1118638409.1208/19/2011Payroll 08/19/1119046338.87Total747.990.00 7,958.70180-021-000-42225Medicare TaxesBalance Forward1,688.8908/05/2011Payroll 08/05/111863895.6808/19/2011Payroll 08/19/111904679.25Total174.930.00 1,863.82180-021-000-42250Unemployment TaxesBalance Forward333.23Total0.000.00333.23180-021-000-42260Workman's CompensationBalance Forward4,187.36Total0.000.00 4,187.36180-021-000-42960Employee RelationsBalance Forward191.5908/31/2011Breakfast for safety meeting19834Laurie Slaght04261125.0008/31/2011Replacement check for 4/28/1120122Laurie Slaght08311125.00Total25.0025.00191.59180-021-000-50500EngineeringBalance Forward80.14Total0.000.0080.14180-021-000-57000Independent LaborBalance Forward0.00Total0.000.000.00180-021-000-60300PostageBalance Forward0.00Total0.000.000.00180-021-000-61000FuelBalance Forward8,065.4408/01/2011Gas Log/July190121,203.0208/31/2011August Gas log202761,116.04Total2,319.060.00 10,384.50180-021-000-62100UniformsBalance Forward860.75Total0.000.00860.75180-021-000-62300ChemicalsBalance Forward0.0008/11/2011 Chemicals - Degreaser and Solvent 18560 Nusco 0719111 2,846.00Total2,846.000.00 2,846.00180-021-000-72100ElectricityBalance Forward13,961.3608/02/2011Electricity 7/5-8/219197Tri County Electric2009888001 0811325.0108/02/2011Electricity 7/5-8/219199Tri County Electric2209888001 0811183.8308/11/2011Electricity Collections18556Hudson Energy16399847.5708/16/2011Mary Moore18704JP Morgan Chase Bank NA08162011609.2508/17/2011Electricity 7/15-8/1419165Hudson Energy16672287.96TCMUD No. 1Page 87 of 121Meeting Date: September 20, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/201108/17/2011Electricity 7/15-8/1519167Hudson Energy16671706.66Total2,960.280.00 16,921.64180-021-000-72200WaterBalance Forward0.00Total0.000.000.00180-021-000-73100TelephoneBalance Forward21.6308/31/2011 Steve Z. 20280 Bank of America 082711 0.63Total0.630.0022.26180-021-000-73200Communications /Pagers/MobilesBalance Forward2,332.91Total0.000.00 2,332.91180-021-000-74100Dues & MembershipBalance Forward61.0008/16/2011 Mary Moore 18704 JP Morgan Chase Bank NA 08162011 111.00Total111.000.00172.00180-021-000-74200Travel & per diemBalance Forward583.9008/05/2011Payroll 08/05/111863833.1508/19/2011Payroll 08/19/111904648.29Total81.440.00665.34180-021-000-74300Schools & TrainingBalance Forward55.00Total0.000.0055.00180-021-000-74700Safety ProgramBalance Forward7.18Total0.000.007.18180-021-000-78200Small ToolsBalance Forward220.58Total0.000.00220.58180-021-000-78300Safety EquipmentBalance Forward62.84Total0.000.0062.84180-021-000-78600HardwareBalance Forward0.00Total0.000.000.00180-021-000-79150Equipment Rental/LeaseBalance Forward0.00Total0.000.000.00180-021-000-79999Miscellaneous ExpenseBalance Forward0.00Total0.000.000.00180-021-000-80250Maintenance and RepairsBalance Forward4,175.22Total0.000.00 4,175.22180-021-000-81100Property MaintenanceBalance Forward0.00Total0.000.000.00180-021-000-81200Building MaintenanceBalance Forward0.00Total0.000.000.00180-021-000-81300Vehicle MaintenanceBalance Forward5,841.37Total0.000.00 5,841.37180-021-000-81900Maintenance SuppliesBalance Forward2,050.63TCMUD No. 1Page 88 of 121Meeting Date: September 20, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/201108/02/2011July purchases17906Costco Wholesale07261178.91Total78.910.00 2,129.54180-021-000-93700Capital ExpensesBalance Forward0.0008/04/2011 GapVax payment 17338 First Financial Bank 91500007041 071911 10,979.25Total10,979.250.00 10,979.25180-021-000-97000Capital RepairsBalance Forward0.00Total0.000.000.00180-130-000-40100Salaries - RegularBalance Forward5,400.0008/05/2011 Payroll 08/05/11 186381,000.00Total1,000.000.00 6,400.00180-130-000-42220Social Security TaxesBalance Forward334.8008/05/2011 Payroll 08/05/11 1863862.00Total62.000.00396.80180-130-000-42225Medicare TaxesBalance Forward78.3008/05/2011 Payroll 08/05/11 1863814.50Total14.500.0092.80180-130-000-42250Unemployment TaxesBalance Forward66.6008/05/2011 Payroll 08/05/11 186388.00Total8.000.0074.60180-130-000-42260Workman's CompensationBalance Forward113.88Total0.000.00113.88180-130-000-50100Professional Outside ServicesBalance Forward0.00Total0.000.000.00180-130-000-60100Office SuppliesBalance Forward0.00Total0.000.000.00180-130-000-60300PostageBalance Forward-1.86CRTotal0.00 0.00 -1.86 CR180-130-000-60400Publications/Books/SubscriptionsBalance Forward0.00Total0.000.000.00180-130-000-73300AdvertisingBalance Forward0.00Total0.000.000.00180-130-000-73400PrintingBalance Forward0.00Total0.000.000.00180-130-000-74100Dues & MembershipBalance Forward79.00Total0.000.0079.00180-130-000-74200Travel & per diemBalance Forward968.26Total0.000.00968.26180-130-000-74300Schools & TrainingBalance Forward2,140.00Total0.000.00 2,140.00TCMUD No. 1Page 89 of 121Meeting Date: September 20, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011180-130-000-74600MeetingsBalance Forward289.0008/11/2011Council members chamber seat signs. Jim18554Mulhollands15359415.0008/16/2011Shannon Deprater18704JP Morgan Chase Bank NA0816201122.00Total37.000.00326.00180-130-000-79999Miscellaneous ExpenseBalance Forward0.00Total0.000.000.00180-130-000-87110Water Conservation Program/Public InformationBalance Forward2,334.72Total0.000.00 2,334.72180-140-000-40100Salaries - RegularBalance Forward170,359.0608/05/2011Payroll 08/05/11186386,454.2008/19/2011Payroll 08/19/11190466,786.14Total13,240.340.00 183,599.40180-140-000-40130Salaries - OvertimeBalance Forward262.0608/05/2011Payroll 08/05/111863821.8308/19/2011Payroll 08/19/11190469.00Total30.830.00292.89180-140-000-40140Salaries - LongevityBalance Forward2,755.00Total0.000.00 2,755.00180-140-000-41200RetirementBalance Forward23,871.5408/05/2011Payroll 08/05/1118638896.8608/19/2011Payroll 08/19/1119046937.17Total1,834.030.00 25,705.57180-140-000-41210Medical InsuranceBalance Forward15,665.8608/05/2011Payroll 08/05/1118638702.1608/19/2011Payroll 08/19/1119046693.76Total1,395.920.00 17,061.78180-140-000-41215Dental InsuranceBalance Forward796.2908/05/2011Payroll 08/05/111863838.9308/19/2011Payroll 08/19/111904638.49Total77.420.00873.71180-140-000-41216Vision InsuranceBalance Forward147.9608/05/2011Payroll 08/05/11186387.4708/19/2011Payroll 08/19/11190467.40Total14.870.00162.83180-140-000-41218Life Insurance & OtherBalance Forward390.74Total0.000.00390.74180-140-000-42220Social Security TaxesBalance Forward10,721.9008/05/2011Payroll 08/05/1118638376.0008/19/2011Payroll 08/19/1119046396.14Total772.140.00 11,494.04180-140-000-42225Medicare TaxesBalance Forward2,531.2308/05/2011Payroll 08/05/111863887.9408/19/2011Payroll 08/19/111904692.65Total180.590.00 2,711.82TCMUD No. 1Page 90 of 121Meeting Date: September 20, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011180-140-000-42250Unemployment TaxesBalance Forward447.8708/05/2011Payroll 08/05/11186388.5608/19/2011Payroll 08/19/111904611.11Total19.670.00467.54180-140-000-42260Workman's CompensationBalance Forward743.12Total0.000.00743.12180-140-000-42290Pre-employment Physicals/TestingBalance Forward74.9208/01/2011Pre-Employment testing/Schultz19157First Check Applicant Screening21463.7508/11/2011Kari Schultz, pre-employment testing18552First Check Applicant Screening200353.50Total7.250.0082.17180-140-000-42960Employee RelationsBalance Forward906.1708/19/2011 Reimburse MMoore petty cash 19203 Trophy Club MUD Petty Cash 081911MM 2.50Total2.500.00908.67180-140-000-50100Professional Outside ServicesBalance Forward228,075.63Total0.000.00 228,075.63180-140-000-52100ElectionsBalance Forward1,952.65Total0.000.00 1,952.65180-140-000-54200Records ManagementBalance Forward120.00Total0.000.00120.00180-140-000-57000Independent LaborBalance Forward406.87Total0.000.00406.87180-140-000-60100Office SuppliesBalance Forward1,346.1908/04/2011Mary Moore18522JP Morgan Chase Bank NA07202011106.9808/15/2011Office Supplies19439Office Depot57498292200152.83Total159.810.00 1,506.00180-140-000-60300PostageBalance Forward1,954.0908/01/2011July Postage meter usage2028242.3208/04/2011Mary Moore18522JP Morgan Chase Bank NA0720201183.2308/04/2011Shannon Deprater18522JP Morgan Chase Bank NA0720201129.4008/04/2011Tammy Ard18522JP Morgan Chase Bank NA0720201118.4008/31/2011Gaslog Shipping Charges20144Federal Express Corp7-607-4243829.0408/31/2011August Postage Meter usage2028414.83Total217.220.00 2,171.31180-140-000-60400Publications/Books/SubscriptionsBalance Forward215.40Total0.000.00215.40180-140-000-73100TelephoneBalance Forward196.7308/31/2011 Steve Z. 20280 Bank of America 082711 18.42Total18.420.00215.15180-140-000-73200Communications /Pagers/MobilesBalance Forward2,326.7308/31/2011 Robert Scott 20610 JP Morgan Chase Bank NA 08312011 56.22Total56.220.00 2,382.95180-140-000-73300AdvertisingBalance Forward0.00Total0.000.000.00TCMUD No. 1Page 91 of 121Meeting Date: September 20, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011180-140-000-73400PrintingBalanceForward3,170.00Total0.000.00 3,170.00180-140-000-73600Service Charges & FeesBalance Forward32.50Total0.000.0032.50180-140-000-74100Dues & MembershipBalance Forward1,714.5008/02/2011Security bond/Slaght17912American Surety Bond080211Slaght105.0008/02/2011Notary Recording books17922State Notary Commission08021130.0008/02/2011Security Bond/Schultz17934American Surety Bond080211Schultz105.0008/24/2011Membership renewal19151Costco Membership000111803072338150.0008/31/2011Laurie Slaght20610JP Morgan Chase Bank NA0831201165.00Total455.000.00 2,169.50180-140-000-74200Travel & per diemBalance Forward1,201.01Total0.000.00 1,201.01180-140-000-74300Schools & TrainingBalance Forward1,640.9308/02/2011Notary Law & Procedure/Slaght17888North Central Texas COG08102011/Slaght130.0008/02/2011Notary Law & Procedure/Schultz17890North Central Texas COG08022011/Schultz130.0008/02/2011Municipal Clerks certification study/Sla17904Texas Municipal Clerks Certification Program080211300.0008/16/2011Mary Moore18704JP Morgan Chase Bank NA0816201155.0008/19/2011Reimburse MMoore petty cash19203Trophy Club MUD Petty Cash081911MM4.91Total619.910.00 2,260.84180-140-000-74600MeetingsBalance Forward116.0008/16/2011Robert Scott18704JP Morgan Chase Bank NA0816201117.8308/25/2011Legislative breakfast, Scott, Gonzales, 19425Northwest Metroport Chamber810450.00Total67.830.00183.83180-140-000-76700July 4 CelebrationBalance Forward0.0008/31/2011 July 4th Celebration 20146 Town of Trophy Club 07042011 10,000.00Total10,000.000.00 10,000.00180-140-000-78500Furniture/Equipment<$5,000Balance Forward4,081.30Total0.000.00 4,081.30180-140-000-79999Miscellaneous ExpenseBalance Forward0.0008/19/2011 Reduce MM Petty Cash 1899610.06Total10.060.0010.06180-611-000-40100Salaries - RegularBalance Forward54,921.9608/05/2011Payroll 08/05/11186382,724.8008/19/2011Payroll 08/19/11190462,724.80Total5,449.600.00 60,371.56180-611-000-40130Salaries - OvertimeBalance Forward12,042.7908/19/2011 Payroll 08/19/11 19046670.81Total670.810.00 12,713.60180-611-000-40140Salaries - LongevityBalance Forward1,710.00Total0.000.00 1,710.00180-611-000-41200RetirementBalance Forward9,805.7408/05/2011Payroll 08/05/1118638385.8308/19/2011Payroll 08/19/1119046480.82Total866.650.00 10,672.39TCMUD No. 1Page 92 of 121Meeting Date: September 20, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011180-611-000-41210Medical InsuranceBalanceForward7,616.9908/05/2011Payroll 08/05/1118638357.6208/19/2011Payroll 08/19/1119046357.62Total715.240.00 8,332.23180-611-000-41215Dental InsuranceBalance Forward409.7208/05/2011Payroll 08/05/111863821.5308/19/2011Payroll 08/19/111904621.53Total43.060.00452.78180-611-000-41216Vision InsuranceBalance Forward49.8008/05/2011Payroll 08/05/11186382.4908/19/2011Payroll 08/19/11190462.49Total4.980.0054.78180-611-000-41218Life Insurance & OtherBalance Forward146.23Total0.000.00146.23180-611-000-42220Social Security TaxesBalance Forward3,806.3708/05/2011Payroll 08/05/1118638138.7008/19/2011Payroll 08/19/1119046180.30Total319.000.00 4,125.37180-611-000-42225Medicare TaxesBalance Forward890.2008/05/2011Payroll 08/05/111863832.4408/19/2011Payroll 08/19/111904642.17Total74.610.00964.81180-611-000-42250Unemployment TaxesBalance Forward129.59Total0.000.00129.59180-611-000-42260Workman's CompensationBalance Forward260.04Total0.000.00260.04180-611-000-42290Pre-employment Physicals/TestingBalance Forward0.00Total0.000.000.00180-611-000-50100Professional Outside ServicesBalance Forward2,437.50Total0.000.00 2,437.50180-611-000-60100Office SuppliesBalance Forward495.65Total0.000.00495.65180-611-000-60300PostageBalance Forward306.7508/01/2011July Postage meter usage2028216.2808/31/2011August Postage Meter usage2028440.44Total56.720.00363.47180-611-000-60400Publications/Books/SubscriptionsBalance Forward0.00Total0.000.000.00180-611-000-73100TelephoneBalance Forward13.1808/31/2011 Steve Z. 20280 Bank of America 082711 3.01Total3.010.0016.19180-611-000-73200Communications /Pagers/MobilesBalance Forward560.98TCMUD No. 1Page 93 of 121Meeting Date: September 20, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011Total0.00 0.00 560.98180-611-000-73300AdvertisingBalance Forward207.40Total0.000.00207.40180-611-000-73400PrintingBalance Forward0.00Total0.000.000.00180-611-000-73600Service Charges & FeesBalance Forward0.00Total0.000.000.00180-611-000-74100Dues & MembershipBalance Forward22.0008/24/2011 Membership renewal/Gonzales 19161 Govt Finance Officers Assoc Texas 082411Gonzales 95.00Total95.000.00117.00180-611-000-74200Travel & per diemBalance Forward145.1308/19/2011 Payroll 08/19/11 190467.05Total7.050.00152.18180-611-000-74300Schools & TrainingBalance Forward309.00Total0.000.00309.00180-611-000-74600MeetingsBalance Forward0.0008/25/2011 Legislative breakfast, Scott, Gonzales, 19425 Northwest Metroport Chamber 8104 25.00Total25.000.0025.00180-611-000-78500Furniture/Equipment<$5,000Balance Forward0.00Total0.000.000.00180-611-000-79999Miscellaneous ExpenseBalance Forward0.00Total0.000.000.00180-620-000-40100Salaries - RegularBalance Forward72,676.7308/05/2011Payroll 08/05/11186383,541.3708/19/2011Payroll 08/19/11190463,850.72Total7,392.090.00 80,068.82180-620-000-40130Salaries - OvertimeBalance Forward706.4308/05/2011Payroll 08/05/1118638187.4608/19/2011Payroll 08/19/1119046135.45Total322.910.00 1,029.34180-620-000-40140Salaries - LongevityBalance Forward405.00Total0.000.00405.00180-620-000-41200RetirementBalance Forward9,942.8808/05/2011Payroll 08/05/1118638528.0108/19/2011Payroll 08/19/1119046564.43Total1,092.440.00 11,035.32180-620-000-41210Medical InsuranceBalance Forward14,775.4408/05/2011Payroll 08/05/1118638805.7408/19/2011Payroll 08/19/1119046807.05Total1,612.790.00 16,388.23180-620-000-41215Dental InsuranceBalance Forward902.7708/05/2011Payroll 08/05/111863852.37TCMUD No. 1Page 94 of 121Meeting Date: September 20, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/201108/19/2011Payroll 08/19/111904652.44Total104.810.00 1,007.58180-620-000-41216Vision InsuranceBalance Forward159.4308/05/2011Payroll 08/05/11186389.2408/19/2011Payroll 08/19/11190469.24Total18.480.00177.91180-620-000-41218Life Insurance & OtherBalance Forward260.31Total0.000.00260.31180-620-000-42220Social Security TaxesBalance Forward4,368.4408/05/2011Payroll 08/05/1118638198.8808/19/2011Payroll 08/19/1119046214.74Total413.620.00 4,782.06180-620-000-42225Medicare TaxesBalance Forward1,021.6508/05/2011Payroll 08/05/111863846.5208/19/2011Payroll 08/19/111904650.22Total96.740.00 1,118.39180-620-000-42250Unemployment TaxesBalance Forward393.6008/05/2011Payroll 08/05/11186387.2508/19/2011Payroll 08/19/11190469.62Total16.870.00410.47180-620-000-42260Workman's CompensationBalance Forward390.08Total0.000.00390.08180-620-000-42290Pre-employment Physicals/TestingBalance Forward22.4808/01/2011Pre-Employment testing/Schultz19157First Check Applicant Screening21463.7508/11/2011Kari Schultz, pre-employment testing18552First Check Applicant Screening200354.00Total7.750.0030.23180-620-000-56200Utility Billing ContractBalance Forward8,840.88Total0.000.00 8,840.88180-620-000-57000Independent LaborBalance Forward0.00Total0.000.000.00180-620-000-60100Office SuppliesBalance Forward405.9908/15/2011Office Supplies19439Office Depot57498292200170.4208/25/2011Office Supplies20096Office Depot5766027110013.7208/25/2011Office Supplies20098Office Depot57658668900124.30Total98.44 0.00 504.43180-620-000-60300PostageBalance Forward13,158.75Total0.000.00 13,158.75180-620-000-73100TelephoneBalance Forward98.2808/31/2011 Steve Z. 20280 Bank of America 082711 7.50Total7.500.00105.78180-620-000-73200Communications /Pagers/MobilesBalance Forward410.36Total0.000.00410.36180-620-000-73400PrintingBalance Forward2,152.00TCMUD No. 1Page 95 of 121Meeting Date: September 20, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011Total0.00 0.00 2,152.00180-620-000-73600Service Charges & FeesBalance Forward18,155.7508/04/2011Credit Card fees/July203009.9908/04/2011Credit Card fees/July20300363.6908/04/2011Credit Card fees/July203001,981.92Total2,355.600.00 20,511.35180-620-000-74100Dues & MembershipBalance Forward0.00Total0.000.000.00180-620-000-74200Travel & per diemBalance Forward30.0908/19/2011 Payroll 08/19/11 1904624.98Total24.980.0055.07180-620-000-74300Schools & TrainingBalance Forward46.44Total0.000.0046.44180-620-000-75600TCEQ Annual Assessment FeeBalance Forward19,248.17Total0.000.00 19,248.17180-620-000-79999Miscellaneous ExpenseBalance Forward1.84Total0.000.001.84180-620-000-99100Transfer to General FundBalance Forward0.00Total0.000.000.00180-630-000-42290Pre-employment Physicals/TestingBalance Forward152.41Total0.000.00152.41180-630-000-42960Employee RelationsBalance Forward518.8508/04/2011Tammy Ard18522JP Morgan Chase Bank NA0720201199.2208/11/2011Frame for Employee of the Qtr.18550April Reiling080120118.65Total107.870.00626.72180-630-000-43240Tuition ReimbursementBalance Forward74.65Total0.000.0074.65180-630-000-60100Office SuppliesBalance Forward0.00Total0.000.000.00180-630-000-60300PostageBalance Forward0.00Total0.000.000.00180-630-000-60400Publications/Books/SubscriptionsBalance Forward0.00Total0.000.000.00180-630-000-73100TelephoneBalance Forward0.00Total0.000.000.00180-630-000-73200Communications /Pagers/MobilesBalance Forward0.00Total0.000.000.00180-630-000-73400PrintingBalance Forward0.00Total0.000.000.00TCMUD No. 1Page 96 of 121Meeting Date: September 20, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011180-630-000-74100Dues & MembershipBalanceForward0.00Total0.000.000.00180-630-000-74200Travel & per diemBalance Forward0.00Total0.000.000.00180-630-000-74300Schools & TrainingBalance Forward0.00Total0.000.000.00180-630-000-74600MeetingsBalance Forward0.00Total0.000.000.00180-630-000-99100Transfer to General FundBalance Forward0.00Total0.000.000.00180-640-000-50700SecurityBalance Forward42.5108/31/2011 Mike Pastor 20280 Bank of America 082711 145.24Total145.240.00187.75180-640-000-55000Software & SupportBalance Forward43,436.4508/02/2011Software support18574STW Inc043011389.6908/11/2011JULY 2011 MONTHLY BANDWIDTH18542Bandwidth.com, Inc.IN08152011-2007145326.6908/16/2011Annual support19183Pipelogix, Inc.19081,900.0008/28/2011Support/June20088Prime Construction Co082811192.9708/28/2011Support/June20250Prime Construction Co082811192.9708/31/2011Steve Z.20280Bank of America08271154.9908/31/2011Steve Z.20280Bank of America08271153.3808/31/2011Mike Pastor20280Bank of America08271125.0008/31/2011Mike Pastor20280Bank of America082711298.5008/31/2011Steve Z.20280Bank of America082711293.9108/31/2011Axiar Set up20128STW Inc08221117.3308/31/2011CTY Connect Service20142Blackboard Connect Inc.10765663,429.00Total6,981.46192.97 50,224.94180-640-000-57000Independent LaborBalance Forward2,348.75Total0.000.00 2,348.75180-640-000-60100Office SuppliesBalance Forward244.6108/31/2011 Mike Pastor 20280 Bank of America 082711 25.42Total25.420.00270.03180-640-000-60200Printer SuppliesBalance Forward5,236.4608/11/2011Printer Cartridges18532SHI Governmental SolutionsGS00037239565.0008/11/2011Printer Cartridges18534SHI Governmental SolutionsGS00037190666.5008/11/2011HP Toner Cartridges18536SHI Governmental SolutionsGS00036372140.5008/31/2011Steve Z.20280Bank of America082711144.50Total1,516.500.00 6,752.96180-640-000-73100TelephoneBalance Forward8,779.1308/31/2011Hardware Headset Cord20112SHI Governmental SolutionsGB0004133212.7508/31/2011Steve Z.20280Bank of America082711453.3008/31/2011Steve Z.20280Bank of America082711350.15Total816.200.00 9,595.33180-640-000-73200Communications /Pagers/MobilesBalance Forward0.00Total0.000.000.00TCMUD No. 1Page 97 of 121Meeting Date: September 20, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011180-640-000-74200Travel & per diemBalanceForward16.18Total0.000.0016.18180-640-000-75900Prompt Payment InterestBalance Forward14.53Total0.000.0014.53180-640-000-78600HardwareBalance Forward37,054.6308/01/2011Repair Marquee18566ENTECH Assc/ENTECH SIGNS2223622.5008/31/2011Hardware Headset Cord20112SHI Governmental SolutionsGB00041332599.0008/31/2011Steve Z.20280Bank of America082711114.9908/31/2011Steve Z.20280Bank of America082711353.97Total1,690.460.00 38,745.09180-640-000-79100Copier Rental/LeaseBalance Forward2,459.6108/01/2011Adm Copier Lease/August19171Kyocera Mita America, Inc110783868146.7608/01/2011PW Copier lease/August19173Kyocera Mita America, Inc110783877115.6208/01/2011PW Fax lease/August19175Kyocera Mita America, Inc11078387810.91Total273.290.00 2,732.90180-640-000-99100Transfer to General FundBalance Forward0.00Total0.000.000.00180-640-000-99500Transfer to Future Replacement ReserveBalance Forward0.0008/31/2011 GASB Transfers 2027426,911.00Total26,911.000.00 26,911.00180-710-000-52400Lab AnalysisBalance Forward1,168.75Total0.000.00 1,168.75180-710-000-62520Vending Machine SuppliesBalance Forward429.28Total0.000.00429.28180-710-000-72100ElectricityBalance Forward10,964.9708/31/2011 Electricity 20134 Direct Energy Business Svcs 1163697 1,426.32Total1,426.320.00 12,391.29180-710-000-72200WaterBalance Forward560.41Total0.000.00560.41180-710-000-75000InsuranceBalance Forward23,475.8108/10/2011Bond/Schultz19205Victor O Schinnerer & Co, IncR11005780250.0008/19/2011Bond/Schaefer19429Victor O Schinnerer & Co, IncR11005856450.00Total100.000.00 23,575.81180-710-000-79200Building Rental/LeaseBalance Forward10,985.1008/01/2011 Public Services Bldg Rent/August 17926 Town of Trophy Club 080111 PS Bldg rent 1,098.51Total1,098.510.00 12,083.61180-710-000-81200Building MaintenanceBalance Forward13,398.9408/19/2011 Airconditioning service call 19153 Dennis Electric Co., Inc. 10605 47.50Total47.500.00 13,446.44180-710-000-81600Cleaning ServicesBalance Forward6,863.4508/01/2011August janitorial service18568ABM Janitorial Services, Inc2791855559.5008/04/2011Mary Moore18522JP Morgan Chase Bank NA07202011118.68Total678.180.00 7,541.63TCMUD No. 1Page 98 of 121Meeting Date: September 20, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011180-710-000-81900Maintenance SuppliesBalance Forward1,530.4608/02/2011July purchases17906Costco Wholesale07261136.3508/04/2011Adrian Womack18522JP Morgan Chase Bank NA0720201139.0608/16/2011Carolyn Huggins18704JP Morgan Chase Bank NA0816201141.3108/16/2011Tammy Ard18704JP Morgan Chase Bank NA0816201116.5608/31/2011Laurie Slaght20610JP Morgan Chase Bank NA0831201117.00Total150.280.00 1,680.74180-710-000-93300EquipmentBalance Forward0.00Total0.000.000.00180-810-000-50200AuditingBalance Forward27,500.00Total0.000.00 27,500.00180-810-000-50300LegalBalance Forward27,933.3108/01/2011July 2011 Legal Fees18524The Liston Law Firm, P.C.0720115,734.6008/01/2011June legal19207Whitaker, Chalk, Swindle LLP1542581,721.5008/01/2011July legal19209Whitaker, Chalk, Swindle LLP055049320.0008/31/2011August Legal20090The Liston Law Firm, P.C.0831114,118.20Total11,894.300.00 39,827.61180-810-000-51100AppraisalBalance Forward12,269.68Total0.000.00 12,269.68180-810-000-51150Tax AdministrationBalance Forward2,696.56Total0.000.00 2,696.56180-810-000-99510Transfer to Fire Construction FundBalance Forward0.0008/31/2011 Transfer to Fire Construction/Aug exp 20304272,718.65Total272,718.650.00 272,718.65GRAND TOTAL925,294.50 804,650.67 -329,801.78TCMUD No. 1Page 99 of 121Meeting Date: September 20, 2011 380-010-000-93700 Capital Expenses 0.00 0.00 (112,162.31)0.00 0.00 # 380-020-000-93700 Capital Expenses 0.00 0.00 0.00 210,220.60 (210,220.60) # Total Capital Projects 0.00 0.00 (112,162.31)210,220.60 (210,220.60) page 1 Budget to Actual - Capital Pro Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 Page 100 of 121 Meeting Date: September 20, 2011 G/L #Effective DateDescriptionJournal #Vendor NameVendor Invoice #DebitCreditBalance380-000-000-35050Interest IncomeBalanceForward0.00Total0.000.000.00380-010-000-93700Capital ExpensesBalanceForward112,162.3108/31/2011Recode Water Capital Project to Gen Fund2027038,100.0008/31/2011Recode Water Capital Project to Gen Fund2027058,800.0008/31/2011Recode Water Capital Project to Gen Fund20270500.0008/31/2011Recode Water Capital Project to Gen Fund2027014,762.31Total0.00112,162.310.00380-020-000-93700Capital ExpensesBalanceForward210,220.60Total0.000.00 210,220.60GRAND TOTAL0.00 112,162.31 210,220.60Trophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011TCMUD No. 1Page 101 of 121Meeting Date: September 20, 2011 Municipal Utility District No 1 Fire Department O & M Interim Balance Sheet Balance @ 8/31/2011 ASSETS ASSETS CASH IN BANK -$ INVESTMENTS 346,388 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 23,938 ACCOUNTS RECEIVABLE - PID EMERGENCY SERVICES ASSESSMENTS 4,864 OTHER RECEIVABLES 12,602 TOTAL ASSETS 387,793$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE 28,803$ ACCOUNTS PAYABLE 30,185 TOTAL LIABILITIES 58,988$ FUND BALANCE UNDESIGNATED FUND BALANCE 328,805 TOTAL LIABILITIES AND FUND BALANCE 387,793$ August 31, 2011 11/12 Months (92% of Fiscal Year) TCMUD No. 1 Page 102 of 121 Meeting Date: September 20, 2011 Trophy Club Municipal Utility Dist #1 Budget Revenue Report To Date: 08/31/2011 From Account: 190 To Account: Run Date: 09/16/2011 User: rgonzales Segments/Accounts Total Budget MTD Rev.YTD Rev. Total Variance Total % [FUND] 190 : Fire Department Operations 190-000-000-30050 : Emergency Service Assessment 111,648.00 0.00 120,126.77 -8,478.77 -7.59% 190-000-000-30060 : Emergency Services Assessment - Penalty & Interest 0.00 0.00 1,729.10 -1,729.10 0.00% 190-000-000-30100 : Property Taxes 1,072,786.00 1,387.31 1,072,733.87 52.13 0.00% 190-000-000-30125 : Property Taxes/Delinquent 0.00 217.27 8,967.76 -8,967.76 0.00% 190-000-000-30150 : Property Taxes/Penalty & Interest 7,500.00 338.82 5,256.30 2,243.70 29.92% 190-000-000-32014 : Fire Permits/Sprinkler 0.00 800.00 2,400.00 -2,400.00 0.00% 190-000-000-33050 : Fire Inspections 0.00 150.00 375.00 -375.00 0.00% 190-000-000-33420 : Denton/Tarrant County - Fire 13,750.00 0.00 10,000.00 3,750.00 27.27% 190-000-000-35050 : Interest Income 0.00 0.00 75.00 -75.00 0.00% 190-000-000-36700 : Miscellaneous Revenue 2,500.00 1,050.00 2,825.00 -325.00 -13.00% [FUND] SubTotal : 190 : Fire Department Operations 1,208,184.00 3,943.40 1,224,488.80 -16,304.80 -1.35% Grand Total :1,208,184.00 3,943.40 1,224,488.80 -16,304.80 -1.35% PAGE 1 TCMUD No. 1 Page 103 of 121 Meeting Date: September 20, 2011 190-045-000-40100 Salaries - Regular 390,466.00 390,466.00 31,128.23 343,289.34 47,176.66 87.9 190-045-000-40130 Salaries - Overtime 40,298.00 40,298.00 5,638.48 47,794.33 (7,496.33) 118.6 190-045-000-40140 Salaries - Longevity 2,946.00 2,946.00 0.00 2,986.99 (40.99) 101.4 190-045-000-40160 Salaries - Certification 5,401.00 5,401.00 0.00 6,582.94 (1,181.94) 121.9 190-045-000-40180 Salaries - Holiday Pay 11,604.00 11,604.00 0.00 12,154.86 (550.86) 104.7 190-045-000-41200 Retirement 63,016.00 63,016.00 4,754.50 56,017.47 6,998.53 88.9 190-045-000-41210 Medical Insurance 54,809.00 54,809.00 3,919.68 48,278.23 6,530.77 88.1 190-045-000-41215 Dental Insurance 2,819.00 2,819.00 244.28 2,690.91 128.09 95.5 190-045-000-41216 Vision Insurance 505.00 505.00 37.78 431.39 73.61 85.4 190-045-000-41218 Life Insurance & Other 2,491.00 2,491.00 0.00 886.38 1,604.62 35.6 190-045-000-42220 Social Security Taxes 26,252.00 26,252.00 2,081.14 23,815.50 2,436.50 90.7 190-045-000-42225 Medicare Taxes 6,140.00 6,140.00 486.72 5,572.81 567.19 90.8 190-045-000-42250 Unemployment Taxes 1,387.00 1,387.00 20.29 954.78 432.22 68.8 190-045-000-42260 Workman's Compensation 13,134.00 13,134.00 0.00 12,465.28 668.72 94.9 190-045-000-42290 Pre-employment Physicals/Testing 675.00 675.00 0.00 195.50 479.50 29.0 190-045-000-50100 Professional Outside Services 40,000.00 40,000.00 0.00 0.00 40,000.00 # 190-045-000-54100 Physicals/Testing 1,880.00 1,880.00 0.00 0.00 1,880.00 # 190-045-000-60100 Office Supplies 319.00 319.00 0.00 215.63 103.37 67.6 190-045-000-60300 Postage 95.00 95.00 136.82 229.08 (134.08) 241.1 190-045-000-60400 Publications/Books/Subscriptions 382.00 382.00 0.00 0.00 382.00 # 190-045-000-61000 Fuel 16,585.00 16,585.00 2,240.48 10,836.10 5,748.90 65.3 190-045-000-62100 Uniforms 4,357.00 4,357.00 746.45 4,276.77 80.23 98.2 190-045-000-62150 Protective Clothing 7,600.00 7,600.00 5,422.00 6,178.18 1,421.82 81.3 190-045-000-62300 Chemicals 1,545.00 1,545.00 0.00 305.00 1,240.00 19.7 190-045-000-72100 Electricity 17,400.00 17,400.00 1,249.30 10,425.77 6,974.23 59.9 190-045-000-72200 Water 3,193.00 3,193.00 0.00 444.61 2,748.39 13.9 190-045-000-73100 Telephone 103.00 103.00 5.78 129.98 (26.98) 126.2 190-045-000-73200 Communications /Pagers/Mobiles 1,874.00 1,874.00 29.52 2,241.45 (367.45) 119.6 190-045-000-73300 Advertising 153.00 153.00 0.00 0.00 153.00 # 190-045-000-73400 Printing 103.00 103.00 0.00 0.00 103.00 # 190-045-000-74100 Dues & Membership 8,358.00 8,358.00 0.00 6,466.60 1,891.40 77.4 190-045-000-74200 Travel & per diem 7,107.00 7,107.00 0.00 3,531.41 3,575.59 49.7 190-045-000-74300 Schools & Training 6,615.00 6,615.00 349.98 3,666.93 2,948.07 55.4 190-045-000-74400 Emergency Management 1,000.00 1,000.00 0.00 1,000.00 0.00 100.0 190-045-000-74600 Meetings 0.00 0.00 0.00 22.00 (22.00) # 190-045-000-75000 Insurance 19,975.00 19,975.00 0.00 8,714.00 11,261.00 43.6 190-045-000-77300 Fire Inspections/Enforcement 1,000.00 1,000.00 0.00 205.12 794.88 20.5 page 1 Budget to Actual - Fire Dept. Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 Page 104 of 121 Meeting Date: September 20, 2011 190-045-000-78200 Small Tools 8,127.00 8,127.00 615.42 5,179.95 2,947.05 63.7 190-045-000-79200 Building Rental/Lease 308,000.00 308,000.00 0.00 308,000.00 0.00 100.0 190-045-000-79999 Miscellaneous Expense 1,213.00 1,213.00 34.71 240.47 972.53 19.8 190-045-000-80250 Maintenance and Repairs 5,562.00 5,562.00 264.06 3,557.84 2,004.16 64.0 190-045-000-81200 Building Maintenance 11,000.00 11,000.00 1,100.99 8,066.62 2,933.38 73.3 190-045-000-81300 Vehicle Maintenance 13,500.00 13,500.00 4,405.36 12,864.04 635.96 95.3 190-045-000-81350 Equipment Maintenance 3,675.00 3,675.00 100.39 622.10 3,052.90 16.9 190-045-000-81400 Radio Maintenance 1,050.00 1,050.00 0.00 465.00 585.00 44.3 190-045-000-81800 Flags & Repairs 2,422.00 2,422.00 0.00 1,972.50 449.50 81.4 190-045-000-81900 Maintenance Supplies 2,652.00 2,652.00 494.78 1,420.38 1,231.62 53.6 190-045-000-85000 Grant Match 3,000.00 3,000.00 0.00 1,308.60 1,691.40 43.6 190-045-000-87100 Programs & Special Projects 4,080.00 4,080.00 804.99 2,877.84 1,202.16 70.5 190-045-000-90100 Radios 2,500.00 2,500.00 199.87 1,007.37 1,492.63 40.3 190-045-000-90200 Fire Engine 681 Payment 73,388.00 73,388.00 68,193.95 73,887.90 (499.90) 100.7 190-045-000-93200 Vehicles 4,183.00 4,183.00 0.00 4,164.55 18.45 99.6 190-045-000-93600 Airpacks 2,245.00 2,245.00 2,245.00 2,245.00 0.00 100.0 Total Fire Department 1,208,184.00 1,208,184.00 136,950.95 1,050,885.50 157,298.50 page 2 Budget to Actual - Fire Dept. Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 Page 105 of 121 Meeting Date: September 20, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit Balance190-000-000-30100Property TaxesBalance Forward-1,071,346.56CR08/01/2011MUD 1 AV Taxes18688414.8108/02/2011MUD 1 AV Taxes19807102.5208/03/2011MUD 1 AV Taxes18690101.6908/04/2011MUD 1 AV Taxes1869259.9008/05/2011MUD 1 AV Taxes18695489.5208/30/2011MUD 1 AV Taxes19953218.87Total0.00 1,387.31 -1,072,733.87 CR190-000-000-30125Property Taxes/DelinquentBalance Forward-8,750.49CR08/10/2011Advalorem Taxes1979926.2108/30/2011Advalorem Taxes19951191.06Total0.00217.27 -8,967.76 CR190-000-000-30150Property Taxes/Penalty & InterestBalance Forward-4,917.48CR08/02/2011Advalorem Taxes198072.2708/04/2011Advalorem Taxes1869218.5308/05/2011Advalorem Taxes1869592.9908/05/2011AV Taxes 8/5/11 correction203880.0208/10/2011Advalorem Taxes1979927.2208/30/2011Advalorem Taxes19951150.9408/30/2011Advalorem Taxes1995341.5908/31/2011August Bank Rec adjustment203685.2608/31/2011August Bank Rec adjustment203845.2608/31/2011August Bank Rec Adjustment203865.26Total5.26344.08 -5,256.30 CR190-000-000-32014Fire Permits/SprinklerBalance Forward-1,600.00CR08/18/2011Permits 8/18/1118990400.0008/29/2011 Permits 8/29/11 19825400.00Total0.00800.00 -2,400.00 CR190-000-000-33050Fire InspectionsBalance Forward-225.00CR08/18/2011Permits 8/18/111899075.0008/29/2011Permits 8/29/111982575.00Total0.00150.00-375.00 CR190-000-000-33420Denton/Tarrant County - FireBalance Forward-10,000.00CRTotal0.00 0.00 -10,000.00 CR190-000-000-35050Interest IncomeBalance Forward-75.00CRTotal0.00 0.00 -75.00 CR190-000-000-35370DonationsBalance Forward0.00Total0.000.000.00190-000-000-36700Miscellaneous RevenueBalance Forward-1,775.00CR08/18/2011Permits 8/18/1118990525.0008/29/2011 Permits 8/29/11 19825525.00Total0.00 1,050.00 -2,825.00 CR190-000-000-39200Transfer In - General FundBalance Forward0.00Total0.000.000.00190-045-000-40100Salaries - RegularBalance Forward312,161.1108/05/2011Payroll 08/05/111863815,766.1808/19/2011Payroll 08/19/111904615,362.05Total31,128.230.00 343,289.34Trophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011TCMUD No. 1Page 106 of 121Meeting Date: September 20, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011190-045-000-40130Salaries - OvertimeBalanceForward42,155.8508/05/2011Payroll 08/05/11186385,143.7808/19/2011Payroll 08/19/1119046494.70Total5,638.480.00 47,794.33190-045-000-40140Salaries - LongevityBalance Forward2,986.99Total0.000.00 2,986.99190-045-000-40160Salaries - CertificationBalance Forward6,582.94Total0.000.00 6,582.94190-045-000-40180Salaries - Holiday PayBalance Forward12,154.86Total0.000.00 12,154.86190-045-000-41200RetirementBalance Forward51,262.9708/05/2011Payroll 08/05/11186382,693.4108/19/2011Payroll 08/19/11190462,061.09Total4,754.500.00 56,017.47190-045-000-41210Medical InsuranceBalance Forward44,358.5508/05/2011Payroll 08/05/11186381,949.7008/19/2011Payroll 08/19/11190461,969.98Total3,919.680.00 48,278.23190-045-000-41215Dental InsuranceBalance Forward2,446.6308/05/2011Payroll 08/05/1118638121.3808/19/2011Payroll 08/19/1119046122.90Total244.280.00 2,690.91190-045-000-41216Vision InsuranceBalance Forward393.6108/05/2011Payroll 08/05/111863818.7808/19/2011Payroll 08/19/111904619.00Total37.780.00431.39190-045-000-41218Life Insurance & OtherBalance Forward886.38Total0.000.00886.38190-045-000-42220Social Security TaxesBalance Forward21,734.3608/05/2011Payroll 08/05/11186381,197.7108/19/2011Payroll 08/19/1119046883.43Total2,081.140.00 23,815.50190-045-000-42225Medicare TaxesBalance Forward5,086.0908/05/2011Payroll 08/05/1118638280.0708/19/2011Payroll 08/19/1119046206.65Total486.720.00 5,572.81190-045-000-42250Unemployment TaxesBalance Forward934.4908/05/2011Payroll 08/05/111863813.8008/19/2011Payroll 08/19/11190466.49Total20.290.00954.78190-045-000-42260Workman's CompensationBalance Forward12,465.28Total0.000.00 12,465.28190-045-000-42290Pre-employment Physicals/TestingBalance Forward195.50TCMUD No. 1Page 107 of 121Meeting Date: September 20, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011Total0.00 0.00 195.50190-045-000-50100Professional Outside ServicesBalance Forward0.00Total0.000.000.00190-045-000-54100Physicals/TestingBalance Forward0.00Total0.000.000.00190-045-000-60100Office SuppliesBalance Forward215.63Total0.000.00215.63190-045-000-60300PostageBalance Forward92.2608/01/2011July Postage meter usage2028259.8408/04/2011Janet Grunt18522JP Morgan Chase Bank NA0720201121.3308/31/2011August Postage Meter usage2028424.6408/31/2011Janet Grunt20610JP Morgan Chase Bank NA0831201131.01Total136.820.00229.08190-045-000-60400Publications/Books/SubscriptionsBalance Forward0.00Total0.000.000.00190-045-000-61000FuelBalance Forward8,595.6208/01/2011Gas Log/July190121,110.5408/04/2011Donnie Hurd18522JP Morgan Chase Bank NA0720201141.0008/31/2011August Gas log202761,088.94Total2,240.480.00 10,836.10190-045-000-62100UniformsBalance Forward3,530.3208/04/2011Danny Thomas18522JP Morgan Chase Bank NA07202011466.2008/04/2011Donnie Hurd18522JP Morgan Chase Bank NA07202011241.5008/16/2011Gary Sipes18704JP Morgan Chase Bank NA0816201138.75Total746.450.00 4,276.77190-045-000-62150Protective ClothingBalance Forward756.1808/01/2011 Coats/pants 19149 Casco Industries, Inc 99899A 5,422.00Total5,422.000.00 6,178.18190-045-000-62300ChemicalsBalance Forward305.00Total0.000.00305.00190-045-000-72100ElectricityBalance Forward9,176.4708/17/2011 Electricity 7/14-8/12 19169 Hudson Energy 2222189 1,249.30Total1,249.300.00 10,425.77190-045-000-72200WaterBalance Forward444.61Total0.000.00444.61190-045-000-73100TelephoneBalance Forward124.2008/31/2011 Steve Z. 20280 Bank of America 082711 5.78Total5.780.00129.98190-045-000-73200Communications /Pagers/MobilesBalance Forward2,211.9308/31/2011 Mike Pastor 20280 Bank of America 082711 29.52Total29.520.00 2,241.45190-045-000-73300AdvertisingBalance Forward0.00Total0.000.000.00TCMUD No. 1Page 108 of 121Meeting Date: September 20, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011190-045-000-73400PrintingBalance Forward0.00Total0.000.000.00190-045-000-74100Dues & MembershipBalance Forward6,466.60Total0.000.00 6,466.60190-045-000-74200Travel & per diemBalance Forward3,531.41Total0.000.00 3,531.41190-045-000-74300Schools & TrainingBalance Forward3,316.9508/04/2011Danny Thomas18522JP Morgan Chase Bank NA07202011149.9808/23/2011Crash Recovery System19435North East Fire Dept Assoc11-027200.00Total349.980.00 3,666.93190-045-000-74400Emergency ManagementBalance Forward1,000.00Total0.000.00 1,000.00190-045-000-74600MeetingsBalance Forward22.00Total0.000.0022.00190-045-000-75000InsuranceBalance Forward8,714.00Total0.000.00 8,714.00190-045-000-77300Fire Inspections/EnforcementBalance Forward205.12Total0.000.00205.12190-045-000-78200Small ToolsBalance Forward4,564.5308/31/20112 Piece flag & 2 Piece pole20110Symonds Flags & Poles, Inc3408330.0008/31/2011Donnie Hurd20610JP Morgan Chase Bank NA08312011241.9508/31/2011Danny Thomas20610JP Morgan Chase Bank NA0831201143.47Total615.420.00 5,179.95190-045-000-79200Building Rental/LeaseBalance Forward308,000.00Total0.000.00 308,000.00190-045-000-79999Miscellaneous ExpenseBalance Forward205.7608/31/2011 Danny Thomas 20610 JP Morgan Chase Bank NA 08312011 34.71Total34.710.00240.47190-045-000-80250Maintenance and RepairsBalance Forward3,293.7808/16/2011 Donnie Hurd 18704 JP Morgan Chase Bank NA 08162011 264.06Total264.060.00 3,557.84190-045-000-81200Building MaintenanceBalance Forward6,965.6308/02/2011Gas/Fire Station17916Atmos Energy005534734 071167.9708/04/2011Donnie Hurd18522JP Morgan Chase Bank NA0720201191.6008/04/2011Gary Sipes18522JP Morgan Chase Bank NA0720201140.8508/04/2011Shane Beck18522JP Morgan Chase Bank NA07202011175.0008/15/2011Pest control/Fire Station19159Gann's Pest Control17536140.0008/16/2011Cable/Fire Station19155DIRECTV1582045072698.9908/31/2011Fire Station Cable20108DIRECTV1589037842619.8008/31/2011Donnie Hurd20610JP Morgan Chase Bank NA08312011430.6108/31/2011Danny Thomas20610JP Morgan Chase Bank NA0831201136.17Total1,100.990.00 8,066.62190-045-000-81300Vehicle MaintenanceBalance Forward8,458.68TCMUD No. 1Page 109 of 121Meeting Date: September 20, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/201108/12/2011Vehicle Maint/1995 HME 3-D19177Martin Apparatus, Inc30054534,263.2908/16/2011Gary Sipes18704JP Morgan Chase Bank NA081620114.1608/16/2011Donnie Hurd18704JP Morgan Chase Bank NA0816201192.9308/31/2011Danny Thomas20610JP Morgan Chase Bank NA0831201144.98Total4,405.360.00 12,864.04190-045-000-81350Equipment MaintenanceBalance Forward521.7108/12/2011Switch19179Martin Apparatus, Inc300545448.5908/16/2011Danny Thomas18704JP Morgan Chase Bank NA0816201151.80Total100.390.00622.10190-045-000-81400Radio MaintenanceBalance Forward465.00Total0.000.00465.00190-045-000-81800Flags & RepairsBalance Forward1,972.50Total0.000.00 1,972.50190-045-000-81900Maintenance SuppliesBalance Forward925.6008/26/2011July purchases19427Costco Wholesale073111 (Town)202.1208/31/2011Costco Order20138Costco Wholesale08242011292.66Total494.780.00 1,420.38190-045-000-85000Grant MatchBalance Forward1,308.60Total0.000.00 1,308.60190-045-000-87100Programs & Special ProjectsBalance Forward2,072.8508/04/2011April Reiling18522JP Morgan Chase Bank NA07202011400.0008/04/2011Danny Thomas18522JP Morgan Chase Bank NA07202011268.0008/16/2011Shane Beck18704JP Morgan Chase Bank NA0816201186.9908/31/2011Music for Fire Department Grand Opening.20132Scott A. Smith168-42-617750.00Total804.99 0.00 2,877.84190-045-000-90100RadiosBalance Forward807.5008/04/2011Donnie Hurd18522JP Morgan Chase Bank NA07202011240.0708/16/2011Donnie Hurd18704JP Morgan Chase Bank NA0816201140.20Total240.0740.20 1,007.37190-045-000-90200Fire Engine 681 PaymentBalance Forward5,693.9508/19/2011Bond paying agent fees/Fire truck19691500.0008/25/2011CO 2007/Fire Truck1969767,693.95Total68,193.950.00 73,887.90190-045-000-93200VehiclesBalance Forward4,164.55Total0.000.00 4,164.55190-045-000-93600AirpacksBalance Forward0.0008/11/2011 Loan Payment - Airpacks 18564 Texas Forest Service 99-0125 2,245.00Total2,245.000.00 2,245.00GRAND TOTAL136,996.41 3,988.86 -51,747.43TCMUD No. 1Page 110 of 121Meeting Date: September 20, 2011 Municipal Utility District No 1 Fire Station Construction 2010 General Obligation $2M Bond Fund Interim Balance Sheet 11/12 Months (92% of Fiscal Year) Balance @ 8/31/2011 ASSETS ASSETS INVESTMENTS -$ OTHER RECEIVABLES - TOTAL ASSETS -$ LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS PAYABLE 121,450$ TOTAL LIABILITIES 121,450 FUND BALANCE DESIGNATED FOR FIRE STATION CONSTRUCTION (121,450) TOTAL LIABILITIES AND FUND BALANCE -$ * General Fund will transfer to cover expenditures over bond money received. August 31, 2011 TCMUD No. 1 Page 111 of 121 Meeting Date: September 20, 2011 Trophy Club Municipal Utility Dist #1 Budget Revenue Report To Date: 08/31/2011 From Account: 491 To Account: Run Date: 09/16/2011 User: rgonzales Segments/Accounts Total Budget MTD Rev.YTD Rev. Total Variance Total % [FUND] 491 : Bond Fund 2010 GO 2M Fire 491-000-000-35050 : Interest Income 1,295.00 0.00 1,053.58 241.42 18.64% 491-000-000-39200 : Transfer In - General Fund 0.00 272,718.65 272,718.65 -272,718.65 0.00% [FUND] SubTotal : 491 : Bond Fund 2010 GO 2M Fire 1,295.00 272,718.65 273,772.23 -272,477.23 -21,040.71% Grand Total :1,295.00 272,718.65 273,772.23 -272,477.23 -21,040.71% PAGE 1 TCMUD No. 1 Page 112 of 121 Meeting Date: September 20, 2011 491-045-000-94000 Temporary Housing and Storage 0.00 10,500.00 1,227.30 11,712.82 (1,212.82) 111.6 491-045-000-95000 Construction 0.00 1,405,652.00 43,888.11 1,798,923.20 (393,271.20) 128.0 491-045-000-96300 Engineering 0.00 41,000.00 834.10 40,443.85 556.15 98.6 Total Fire Department 0.00 1,457,152.00 45,949.51 1,851,079.87 (393,927.87) page 1 Budget to Actual - Fire Const Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 Page 113 of 121 Meeting Date: September 20, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit Balance491-000-000-35050Interest IncomeBalance Forward-1,053.58CRTotal0.00 0.00 -1,053.58 CR491-000-000-39200Transfer In - General FundBalance Forward0.0008/31/2011 Transfer to Fire Construction/Aug exp 20304272,718.65Total0.00 272,718.65 -272,718.65 CR491-045-000-94000Temporary Housing and StorageBalance Forward10,485.5208/11/2011Temporary Storage18538Williams Scotsman, Inc9581357491.0608/11/2011Temporary Housing18546Modular Space Corporation105891297845.1008/31/201120X8 Container WWTP20120Williams Scotsman, Inc9587143891.0608/31/2011Steve Z.20280Bank of America082711200.08Total1,227.30 0.00 11,712.82491-045-000-95000ConstructionBalance Forward1,755,035.0908/01/2011Security system/fire station191933rd Eye Surveillance Systems2424,500.0008/01/2011Balance due custom beds for fire station18570Tom L. Gierling, Jr.21272,400.0008/04/2011Change orders for fire station19211Cingl Telecom., LLC13356674.9008/05/2011Furniture for fire station18572National Business Furniture, LLCCV754465-NAT3,047.4808/05/2011Cables to go/fire station19187SHI Governmental SolutionsGB00040100195.8208/09/2011Custom ADA signs, Installation of EMS si19431The Router Room1351107.7608/10/2011Punch down cabling at fire station19181Mercury Communication Services, Inc 263379624.6008/11/2011New Fire Station fiber cable18548Ram Comm, Inc.071320118,299.3808/17/2011Electricity 7/15-8/1519189Star-Tex Power60047481,476.8808/19/2011Vacuum for new Fire Station19191Tamara Thomas082511369.9908/22/2011Tempered glass/fire station19195Roanoke Glass and Mirror356035507.0008/22/2011Literature rack19433National Business Furniture, LLCCV756843-DUR253.9008/31/2011Steve Z.20280Bank of America082711861.9308/31/2011Steve Z.20280Bank of America082711235.9808/31/2011Construction Equipment for FD20102Comm-Fit LP1643810,326.3908/31/20112 Door 48x36 Metal Corkboard Acrylic Doo20114National Business Furniture, LLCCV756843-GHE398.0008/31/2011Furniture Install20116National Business Furniture, LLCCV755349-ZAM15.0008/31/2011Supply and install antennas, brackets an20118American Communications575213,500.0008/31/2011Mike Pastor20280Bank of America0827113,046.5508/31/2011Mike Pastor20280Bank of America0827113,046.55Total43,888.110.00 1,798,923.20491-045-000-96100LegalBalance Forward0.00Total0.000.000.00491-045-000-96300EngineeringBalance Forward39,609.7508/11/2011ENGINEERING18544Reed Engineering Group16940397.5008/31/2011BRW Project No: 27069.0020126BRW Architects, Inc211-07113436.60Total834.100.00 40,443.85491-045-000-96500Bond Issuance CostBalance Forward0.00Total0.000.000.00GRAND TOTAL45,949.51 272,718.65 1,577,307.64Trophy Club Municipal Utility Dist #1Fire Construction8/31/2011TCMUD No. 1Page 114 of 121Meeting Date: September 20, 2011 Municipal Utility District No 1 - I & S Interim Balance Sheet Balance @ 8/31/2011 ASSETS ASSETS CASH AND CASH IN BANK -$ INVESTMENTS 97,739 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 21,910 TOTAL ASSETS 119,649$ LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS PAYABLE -$ DEFERRED REVENUE 21,910$ TOTAL LIABILITIES 21,910 FUND BALANCE DESIGNATED FOR DEBT SERVICE 97,739 TOTAL LIABILITIES AND FUND BALANCE 119,649$ August 31, 2011 11/12 Months 92% of Fiscal Year) TCMUD No. 1 Page 115 of 121 Meeting Date: September 20, 2011 Trophy Club Municipal Utility Dist #1 Budget Revenue Report To Date: 08/31/2011 From Account: 680 To Account: Run Date: 09/16/2011 User: rgonzales Segments/Accounts Total Budget MTD Rev.YTD Rev. Total Variance Total % [FUND] 680 : Debt Service 680-000-000-30100 : Property Taxes 755,712.00 977.26 758,491.57 -2,779.57 -0.37% 680-000-000-30125 : Property Taxes/Delinquent 0.00 424.53 4,820.04 -4,820.04 0.00% 680-000-000-30150 : Property Taxes/Penalty & Interest 9,500.00 442.72 4,235.81 5,264.19 55.41% 680-000-000-35050 : Interest Income 500.00 82.12 977.91 -477.91 -95.58% 680-000-000-35170 : Building Rent 308,000.00 0.00 308,000.00 0.00 0.00% 680-000-000-38500 : PID Utility Fees 246,100.00 0.00 246,100.00 0.00 0.00% [FUND] SubTotal : 680 : Debt Service 1,319,812.00 1,926.63 1,322,625.33 -2,813.33 -0.21% Grand Total :1,319,812.00 1,926.63 1,322,625.33 -2,813.33 -0.21% PAGE 1 TCMUD No. 1 Page 116 of 121 Meeting Date: September 20, 2011 680-680-000-89000 Bond Principal 1,115,000.00 1,115,000.00 1,115,000.00 1,115,000.00 0.00 100.0 680-680-000-89100 Bond Interest 379,559.00 379,559.00 172,960.00 379,558.55 0.45 100.0 680-680-000-89200 Paying Agent Fees 3,500.00 3,500.00 1,550.00 2,460.00 1,040.00 70.3 Total Debt Service 1,498,059.00 1,498,059.00 1,289,510.00 1,497,018.55 1,040.45 page 1 Budget to Actual -Debt Service Trophy Club Municipal Utility Dist #1 For Period Ending 08/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 Page 117 of 121 Meeting Date: September 20, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit Balance680-000-000-30100Property TaxesBalance Forward-757,514.31CR08/01/2011MUD 1 AV Taxes18688292.2208/02/2011MUD 1 AV Taxes1980772.2208/03/2011MUD 1 AV Taxes1869071.6208/04/2011MUD 1 AV Taxes1869242.1908/05/2011MUD 1 AV Taxes18695344.8308/30/2011MUD 1 AV Taxes19953154.18Total0.00977.26 -758,491.57 CR680-000-000-30125Property Taxes/DelinquentBalance Forward-4,395.51CR08/10/2011Advalorem Taxes1979938.7508/30/2011Advalorem Taxes19951385.78Total0.00424.53 -4,820.04 CR680-000-000-30150Property Taxes/Penalty & InterestBalance Forward-3,793.09CR08/02/2011Advalorem Taxes198070.0108/04/2011Advalorem Taxes1869213.0508/05/2011Advalorem Taxes1869565.5208/10/2011Advalorem Taxes1979930.0908/30/2011Advalorem Taxes19951304.7608/30/2011Advalorem Taxes1995329.29Total0.00442.72 -4,235.81 CR680-000-000-35050Interest IncomeBalance Forward-895.79CR08/31/2011August Bank Interest2025682.12Total0.0082.12-977.91 CR680-000-000-35170Building RentBalance Forward-308,000.00CRTotal0.00 0.00 -308,000.00 CR680-000-000-36900Recovery of Prior Year ExpenseBalance Forward0.00Total0.000.000.00680-000-000-37100Prior Year ReservesBalance Forward0.00Total0.000.000.00680-000-000-38500PID Utility FeesBalance Forward-246,100.00CRTotal0.00 0.00 -246,100.00 CR680-000-000-39200Transfer In - General FundBalance Forward0.00Total0.000.000.00680-680-000-89000Bond PrincipalBalance Forward0.0008/25/2011Bond payments/MUD1 97W19697380,000.0008/25/2011Bond payments/MUD2 Series 0519697285,000.0008/25/2011Bond payments/MUD1 Series 0319697245,000.0008/25/2011Bond payments/MUD2 200219697150,000.0008/25/2011Bond payments/MUD2 20031969755,000.00Total1,115,000.000.00 1,115,000.00680-680-000-89100Bond InterestBalance Forward206,598.5508/25/2011Bond payments/MUD1 97W196979,310.0008/25/2011Bond payments/Fire Station1969740,366.2508/25/2011Bond payments/MUD2 Series 051969739,330.0008/25/2011Bond payments/MUD1 Series 03196973,981.2508/25/2011Bond payments/MUD2 20021969762,333.7508/25/2011Bond payments/MUD2 20031969717,638.75Total172,960.000.00 379,558.55Trophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011TCMUD No. 1Page 118 of 121Meeting Date: September 20, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report8/31/2011680-680-000-89200Paying Agent FeesBalance Forward910.0008/19/2011Bond paying agent fees/Series 2003196911,000.0008/19/2011Bond paying agent fees/Series 200219691550.00Total1,550.000.00 2,460.00GRAND TOTAL1,289,510.00 1,926.63 174,393.22TCMUD No. 1Page 119 of 121Meeting Date: September 20, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-116-M1 Name: Status:Type:Agenda Item Regular Session File created:In control:9/16/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:9/20/2011 Title:Set Next Meeting Date: a. October 18, 2011 - 7:00 p.m. - Regular Scheduled Meeting Attachments: Action ByDate Action ResultVer. Title Set Next Meeting Date: a. October 18, 2011 - 7:00 p.m. - Regular Scheduled Meeting TCMUD No. 1 Page 120 of 121 Meeting Date: September 20, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-117-M1 Name: Status:Type:Agenda Item Regular Session File created:In control:9/16/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:9/20/2011 Title:Items for Future Agendas a. Funding of Future Capital Projects; i.e., Trinity Well No. 2 Attachments: Action ByDate Action ResultVer. Title Items for Future Agendas a. Funding of Future Capital Projects; i.e., Trinity Well No. 2 TCMUD No. 1 Page 121 of 121 Meeting Date: September 20, 2011