Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
August 16, 2011 Regular Session Agenda Packet
Trophy Club Municipal Utility District No. 1 Trophy Club Entities Meeting Agenda 100 Municipal Drive Trophy Club, Texas 76262 Svore Municipal Building Boardroom7:00 PMTuesday, August 16, 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. REGULAR SESSION REPORTS & UPDATES 1.2011-85-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 DMR Report - June 2011.pdf Water Report.pdf Attachments: 2.2011-86-M1 Receive Finance Update a. Senior Accountant Gonzales to provide the Board with a monthly update and address the Board's questions. 3.2011-87-M1 Receive Fire Update a. Fire Chief Thomas to provide Board with a monthly update and address the Board's questions. Fire Report.pdfAttachments: 4.2011-88-M1 Receive Town Council Update a. Councilmember Rose to provide Board with an update of Council meetings, notices, and relevant business. 5.2011-89-M1 Receive Directors' Update a. Update regarding past month's activities ACTION ITEMS TCMUD No. 1 1 of 93 Meeting Date: August 16, 2011 August 16, 2011Trophy Club Municipal Utility District No. 1 Meeting Agenda 6.2011-90-M1 Review and Approve Monthly Financial Report(s) a. July 2011 July 2011 Financial packet.pdfAttachments: 7.2011-92-M1 Discuss and take appropriate action regarding the purchase of Municipal Management Software. Stw-proposal-revised.pdfAttachments: 8.2011-93-M1 Discuss and take appropriate action regarding a governmental water rate for the Town. 9.2011-94-M1 Discuss and take appropriate action regarding TCMUD No. 1's preliminary draft budget for FY2011-2012. a. Set preliminary tax rate not to exceed $0.195 per $100 assessed valuation (the 2010 tax rate was $0.195 per $100 assessed valuation) b. Water Rates c. Governmental Accounting Standard Board (GASB) Statement 54 fund balance ranges REVIEW & DISCUSS 10.2011-95-M1 Set Next Meeting Date: a. September 20, 2011 - 7:00 p.m. - Regular Scheduled Meeting September 2011.pdfAttachments: 11.2011-96-M1 Items for Future Agendas a. Funding of Future Capital Projects; i.e., Trinity Well No. 2 CONVENE INTO CLOSED SESSION 12.2011-97-M1 PURSUANT TO TEXAS GOVERNMENT CODE, ANNOTATED, SECTION 551.071 (1) & (2) "CONSULTATION WITH ATTORNEY", RESPECTIVELY, THE COUNCIL WILL ENTER INTO CLOSED SESSION TO DISCUSS THE FOLLOWING: A. Consultation with Attorney on Pending or Contemplated Litigation or on a Matter in which the duty of the Attorney to the Governmental Body under the Texas Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflict with the Texas Open Meetings Act: - Anticipated or threatened litigation against the District regarding personnel matters. B. Legal advice regarding the turning off of water where the owner is in bankruptcy. RECONVENE INTO REGULAR SESSION TCMUD No. 1 2 of 93 Meeting Date: August 16, 2011 August 16, 2011Trophy Club Municipal Utility District No. 1 Meeting Agenda 13.2011-98-M1 Discuss and take appropriate action regarding Executive Session. A. Consultation with Attorney on Pending or Contemplated Litigation or on a Matter in which the duty of the Attorney to the Governmental Body under the Texas Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflict with the Texas Open Meetings Act: - Anticipated or threatened litigation against the District regarding personnel matters. B. Legal advice regarding the turning off of water where the owner is in bankruptcy. 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. TCMUD No. 1 3 of 93 Meeting Date: August 16, 2011 August 16, 2011Trophy Club Municipal Utility District No. 1 Meeting Agenda CERTIFICATION) THE STATE OF TEXAS) COUNTY OF DENTON) COUNTY OF TARRANT) THIS CERTIFIES THAT ON FRIDAY, AUGUST 12, 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, AUGUST 16, 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 4 of 93 Meeting Date: August 16, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-85-M1 Name: Status:Type:M1 Agenda Item Regular Session File created:In control:8/11/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:8/16/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:DMR Report - June 2011.pdf 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 5 of 93 Meeting Date: August 16, 2011 TCMUD No. 1 6 of 93 Meeting Date: August 16, 2011 TCMUD No. 1 7 of 93 Meeting Date: August 16, 2011 October November December January February March April May June July August Septembe 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 633,241 Totals 385,474 286,467 219,675 225,107 180,182 225,578 295,825 293,121 467,798 464,134 530,735 394,906 3,969,002 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 693,490 Totals 387,830 295,907 225,706 218,743 201,952 244,035 312,712 337,900 508,650 639,520 527,775 378,598 4,279,328 Water Billed 0 20,000 40,000 60,000 80,000 100,000 120,000 140,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 123456789101112 MonthsGallons 2006 2007 2008 2009 2010 2011 TCMUD No. 1 8 of 93 Meeting Date: August 16, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-86-M1 Name: Status:Type:M1 Agenda Item Regular Session File created:In control:8/11/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:8/16/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 9 of 93 Meeting Date: August 16, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-87-M1 Name: Status:Type:M1 Agenda Item Regular Session File created:In control:8/11/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:8/16/2011 Title:Receive Fire Update a. Fire Chief Thomas to provide Board with a monthly update and address the Board's questions. Attachments:Fire 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 10 of 93 Meeting Date: August 16, 2011 TCMUD No. 1 11 of 93 Meeting Date: August 16, 2011 TCMUD No. 1 12 of 93 Meeting Date: August 16, 2011 TCMUD No. 1 13 of 93 Meeting Date: August 16, 2011 TCMUD No. 1 14 of 93 Meeting Date: August 16, 2011 TCMUD No. 1 15 of 93 Meeting Date: August 16, 2011 TCMUD No. 1 16 of 93 Meeting Date: August 16, 2011 TCMUD No. 1 17 of 93 Meeting Date: August 16, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-88-M1 Name: Status:Type:M1 Agenda Item Regular Session File created:In control:8/11/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:8/16/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 18 of 93 Meeting Date: August 16, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-89-M1 Name: Status:Type:M1 Agenda Item Regular Session File created:In control:8/11/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:8/16/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 19 of 93 Meeting Date: August 16, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-90-M1 Name: Status:Type:M1 Agenda Item Regular Session File created:In control:8/11/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:8/16/2011 Title:Review and Approve Monthly Financial Report(s) a. July 2011 Attachments:July 2011 Financial packet.pdf Action ByDate Action ResultVer. Title Review and Approve Monthly Financial Report(s) a. July 2011 TCMUD No. 1 20 of 93 Meeting Date: August 16, 2011 Municipal Utility District No 1 - O & M Interim Balance Sheet Balance @ 7/31/2011 ASSETS ASSETS CASH ON HAND 450 CASH IN BANK 832,141 INVESTMENTS 2,296,169 RESTRICTED ASSETS: INVESTMENTS 344,540 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 3,006 UTILITY AND OTHER ACCOUNTS RECEIVABLE 445,094 TOTAL ASSETS 3,921,400$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 3,006$ ACCOUNTS PAYABLE 490,908 CUSTOMER DEPOSITS 182,037 TOTAL LIABILITIES 675,951 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT 162,503 UNDESIGNATED FUND BALANCE 3,082,946 TOTAL FUND BALANCE 3,245,449 TOTAL LIABILITIES AND FUND BALANCE 3,921,400$ July 31, 2011 10/12 Months (84% of Fiscal Year) TCMUD No. 1 21 of 93 Meeting Date: August 16, 2011 Account/DescriptionYTD BudgetTotal BudgetMTD RevYTD RevTotal VarianceRemaining %[FUND] 180 : MUD 1 General Fund180-000-000-30100 : Property Taxes86,314.0086,314.00231.3286,555.36-241.36-0.28180-000-000-30125 : Property Taxes/Delinquent0.000.0019.36767.24-767.240.00180-000-000-30150 : Property Taxes/Penalty & Interest0.000.0026.191,407.11-1,407.110.00180-000-000-35050 : Interest Income2,000.002,000.00352.734,757.21-2,757.21-137.86180-000-000-35150 : Cell Tower Lease Revenue10,164.0010,164.00847.008,470.001,694.0016.67180-000-000-35170 : Building Rent7,000.007,000.00583.335,833.301,166.7016.67180-000-000-36100 : Gas Well Revenues2,000.002,000.0086.29765.351,234.6561.73180-000-000-36400 : Auction Sales0.000.000.00202.12-202.120.00180-000-000-36500 : Vending Revenue850.00850.00367.81830.8119.192.26180-000-000-36700 : Miscellaneous Revenue14,500.0014,500.00100.009,311.105,188.9035.79180-000-000-36900 : Recovery of Prior Year Expense0.000.000.002,119.00-2,119.000.00180-000-000-38100 : Water - Residential1,709,811.001,709,811.00251,205.771,423,090.59286,720.4116.77180-000-000-38120 : Water - Commercial777,075.00777,075.0089,330.47581,568.69195,506.3125.16180-000-000-38130 : Water - PID195,249.00195,249.0047,069.23235,260.09-40,011.09-20.49180-000-000-38140 : Portable Meters - Out of District16,000.0016,000.0012,071.0739,493.67-23,493.67-146.84180-000-000-38200 : Sewer - Residential1,098,146.001,098,146.00113,041.60913,112.80185,033.2016.85180-000-000-38220 : Sewer - Commercial300,403.00300,403.0032,776.06233,367.7667,035.2422.32180-000-000-38230 : Sewer - PID74,364.0074,364.0018,738.12128,816.61-54,452.61-73.22180-000-000-38240 : Sewer - Out of District10,000.0010,000.001,947.6713,690.42-3,690.42-36.90180-000-000-38250 : TCCC Effluent Charges47,500.0047,500.0015,140.1944,098.533,401.477.16180-000-000-38300 : Standby0.000.0066.00607.60-607.600.00180-000-000-38320 : Penalties50,000.0050,000.006,355.0636,675.7513,324.2526.65180-000-000-38340 : Service Charges17,500.0017,500.001,453.0012,936.424,563.5826.08180-000-000-38360 : Penalities - Out of District500.00500.000.00270.19229.8145.96180-000-000-38400 : Plumbing Inspections0.000.00250.001,800.00-1,800.000.00180-000-000-38420 : Sewer Inspections3,000.003,000.00750.005,400.00-2,400.00-80.00180-000-000-38500 : PID Utility Fees167,900.00167,900.0069,000.0080,500.0087,400.0052.06180-000-000-38540 : Sewer/Septic Dump Fees48,000.0048,000.000.000.0048,000.00100.00180-000-000-38560 : Fire Line Fees5,000.005,000.000.00525.004,475.0089.50180-000-000-38600 : Oversize Meter Reimbursements50,000.0050,000.0014,058.6954,447.69-4,447.69-8.90180-000-000-39290 : Transfer In - Future Replacement Reserve54,314.0054,314.000.000.0054,314.00100.00[FUND] SubTotal : 180 : MUD 1 General Fund4,747,590.004,747,590.00675,866.963,926,680.41820,909.5917.29 Grand Total : 4,747,590.004,747,590.00675,866.963,926,680.41820,909.5917.29Run Date: 08/11/2011User: rgonzalesTrophy Club Municipal Utility Dist #1Budget Revenue ReportTo Date: 07/31/2011TCMUD No. 122 of 93Meeting Date: August 16, 2011 180-010-000-40100 Salaries - Regular 165,718.00 165,718.00 12,273.86 110,193.11 55,524.89 66.5 180-010-000-40130 Salaries - Overtime 8,814.00 8,814.00 1,992.16 12,312.26 (3,498.26) 139.7 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,430.00 70.00 95.3 180-010-000-41200 Retirement 24,945.00 24,945.00 2,041.29 17,887.05 7,057.95 71.7 180-010-000-41210 Medical Insurance 27,748.00 27,748.00 2,125.96 18,023.26 9,724.74 65.0 180-010-000-41215 Dental Insurance 1,446.00 1,446.00 127.44 1,061.46 384.54 73.4 180-010-000-41216 Vision Insurance 269.00 269.00 22.28 190.43 78.57 70.8 180-010-000-41218 Life Insurance & Other 1,177.00 1,177.00 0.00 301.92 875.08 25.7 180-010-000-42220 Social Security Taxes 10,994.00 10,994.00 842.99 7,458.95 3,535.05 67.8 180-010-000-42225 Medicare Taxes 2,571.00 2,571.00 197.15 1,744.43 826.57 67.9 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 1,842.17 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 165.00 2,073.00 1,777.00 53.8 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 167,542.59 931,001.06 478,998.94 66.0 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 1,862.36 7,994.11 7,221.89 52.5 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 0.00 3,214.64 2,985.36 51.8 180-010-000-72100 Electricity 175,000.00 175,000.00 22,253.55 115,076.42 59,923.58 65.8 180-010-000-73200 Communications /Pagers/Mobiles 1,599.00 1,599.00 164.84 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 182.07 866.94 2,333.06 27.1 180-010-000-74300 Schools & Training 2,800.00 2,800.00 0.00 1,508.00 1,292.00 53.9 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 0.00 83,182.24 1,817.76 97.9 180-010-000-78200 Small Tools 2,500.00 2,500.00 0.00 284.87 2,215.13 11.4 180-010-000-78300 Safety Equipment 2,500.00 2,500.00 0.00 0.00 2,500.00 # 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 07/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 23 of 93 Meeting Date: August 16, 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 112.50 7,329.61 22,170.39 24.8 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 0.00 702.85 3,497.15 16.7 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 0.00 2,182.50 1,197.50 64.6 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 0.00 8,128.51 23,871.49 25.4 180-010-000-91000 Capital Lease 11,490.00 11,490.00 0.00 0.00 11,490.00 # 180-010-000-93700 Capital Expenses 130,932.00 130,932.00 0.00 215,853.45 (84,921.45) 164.9 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 0.00 0.00 30,000.00 # Total Water 2,367,044.00 2,367,044.00 213,898.21 1,670,453.19 696,590.81 page 2 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 24 of 93 Meeting Date: August 16, 2011 180-020-000-40100 Salaries - Regular 176,791.00 176,791.00 13,603.20 139,514.05 37,276.95 78.9 180-020-000-40130 Salaries - Overtime 10,166.00 10,166.00 1,396.27 11,442.47 (1,276.47) 112.6 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 1,975.00 575.00 77.5 180-020-000-41200 Retirement 27,019.00 27,019.00 2,152.25 22,103.56 4,915.44 81.8 180-020-000-41210 Medical Insurance 37,298.00 37,298.00 2,785.32 27,853.41 9,444.59 74.7 180-020-000-41215 Dental Insurance 1,983.00 1,983.00 154.98 1,534.35 448.65 77.4 180-020-000-41216 Vision Insurance 341.00 341.00 29.76 297.60 43.40 87.3 180-020-000-41218 Life Insurance & Other 1,237.00 1,237.00 0.00 415.01 821.99 33.5 180-020-000-42220 Social Security Taxes 10,504.00 10,504.00 799.31 8,439.08 2,064.92 80.3 180-020-000-42225 Medicare Taxes 2,457.00 2,457.00 186.94 1,973.66 483.34 80.3 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 1,995.46 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 0.00 9,978.75 8,771.25 53.2 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 0.00 7.24 392.76 1.8 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 670.88 2,291.15 4,583.85 33.3 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 0.00 4,028.28 8,971.72 31.0 180-020-000-62800 Lab Supplies 6,085.00 6,085.00 0.00 3,559.06 2,525.94 58.5 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 17,153.85 165,748.95 39,251.05 80.9 180-020-000-72200 Water 1,900.00 1,900.00 48.82 1,288.84 611.16 67.8 180-020-000-72400 Dumpster Services 35,000.00 35,000.00 0.00 11,319.25 23,680.75 32.3 180-020-000-73100 Telephone 0.00 10.00 2.00 3.36 6.64 33.6 180-020-000-73200 Communications /Pagers/Mobiles 3,000.00 3,000.00 242.66 2,848.56 151.44 95.0 180-020-000-74200 Travel & per diem 1,750.00 1,750.00 208.59 1,910.40 (160.40) 109.2 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 0.00 481.71 778.29 38.2 180-020-000-78300 Safety Equipment 540.00 540.00 0.00 658.23 (118.23) 121.9 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 0.00 11,439.01 6,310.99 64.4 page 3 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 25 of 93 Meeting Date: August 16, 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 0.00 1,049.74 3,948.26 21.0 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 0.00 761.82 5,098.18 13.0 180-020-000-93700 Capital Expenses 136,189.00 136,189.00 118,689.39 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 160,319.68 588,192.68 211,203.32 page 4 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 26 of 93 Meeting Date: August 16, 2011 180-021-000-40100 Salaries - Regular 136,341.00 136,341.00 10,518.72 107,736.96 28,604.04 79.0 180-021-000-40130 Salaries - Overtime 14,145.00 14,145.00 696.66 13,816.44 328.56 97.7 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,250.00 (50.00) 104.2 180-021-000-41200 Retirement 21,674.00 21,674.00 1,605.80 17,778.40 3,895.60 82.0 180-021-000-41210 Medical Insurance 28,228.00 28,228.00 1,978.38 18,871.57 9,356.43 66.9 180-021-000-41215 Dental Insurance 1,426.00 1,426.00 118.88 1,129.69 296.31 79.2 180-021-000-41216 Vision Insurance 253.00 253.00 19.86 190.56 62.44 75.3 180-021-000-41218 Life Insurance & Other 942.00 942.00 0.00 316.23 625.77 33.6 180-021-000-42220 Social Security Taxes 8,769.00 8,769.00 619.97 7,210.71 1,558.29 82.2 180-021-000-42225 Medicare Taxes 2,051.00 2,051.00 145.00 1,688.89 362.11 82.3 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 1,046.84 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,137.41 8,065.44 3,634.56 68.9 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 0.00 0.00 12,500.00 # 180-021-000-72100 Electricity 23,625.00 23,625.00 404.47 13,961.36 9,663.64 59.1 180-021-000-72200 Water 750.00 750.00 0.00 0.00 750.00 # 180-021-000-73100 Telephone 0.00 0.00 1.05 21.63 (21.63) # 180-021-000-73200 Communications /Pagers/Mobiles 2,796.00 2,796.00 203.63 2,332.91 463.09 83.4 180-021-000-74100 Dues & Membership 255.00 255.00 61.00 61.00 194.00 23.9 180-021-000-74200 Travel & per diem 1,500.00 1,500.00 32.64 583.90 916.10 38.9 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 16.50 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 5,200.00 5,841.37 2,301.63 71.7 180-021-000-81900 Maintenance Supplies 16,050.00 16,050.00 0.00 2,050.63 13,999.37 12.8 180-021-000-93700 Capital Expenses 15,000.00 15,000.00 0.00 0.00 15,000.00 # 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 07/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 27 of 93 Meeting Date: August 16, 2011 Total Collection 416,658.00 416,658.00 24,931.81 216,241.58 200,416.42 page 6 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 28 of 93 Meeting Date: August 16, 2011 180-130-000-40100 Salaries - Regular 10,000.00 10,000.00 1,200.00 5,400.00 4,600.00 54.0 180-130-000-42220 Social Security Taxes 620.00 620.00 74.40 334.80 285.20 54.0 180-130-000-42225 Medicare Taxes 145.00 145.00 17.40 78.30 66.70 54.0 180-130-000-42250 Unemployment Taxes 210.00 210.00 9.60 66.60 143.40 31.7 180-130-000-42260 Workman's Compensation 120.00 120.00 28.47 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 209.24 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 0.00 289.00 989.00 22.6 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,539.11 11,802.70 12,725.30 page 7 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 29 of 93 Meeting Date: August 16, 2011 180-140-000-40100 Salaries - Regular 214,374.00 214,374.00 22,634.06 170,359.06 44,014.94 79.5 180-140-000-40130 Salaries - Overtime 500.00 500.00 40.58 262.06 237.94 52.4 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 3,034.16 23,871.54 6,488.46 78.6 180-140-000-41210 Medical Insurance 17,925.00 17,925.00 866.08 13,981.25 3,943.75 78.0 180-140-000-41215 Dental Insurance 930.00 930.00 51.64 796.29 133.71 85.6 180-140-000-41216 Vision Insurance 179.00 179.00 9.96 147.96 31.04 82.7 180-140-000-41218 Life Insurance & Other 1,205.00 1,205.00 0.00 373.34 831.66 31.0 180-140-000-42220 Social Security Taxes 13,474.00 13,474.00 1,388.13 10,721.90 2,752.10 79.6 180-140-000-42225 Medicare Taxes 3,151.00 3,151.00 324.64 2,531.23 619.77 80.3 180-140-000-42250 Unemployment Taxes 630.00 630.00 19.29 447.87 182.13 71.1 180-140-000-42260 Workman's Compensation 783.00 783.00 185.78 743.12 39.88 94.9 180-140-000-42290 Pre-employment Physicals/Testing 0.00 0.00 22.47 74.92 (74.92) # 180-140-000-42960 Employee Relations 1,000.00 1,000.00 0.00 906.17 93.83 90.6 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 84.37 406.87 433.13 48.4 180-140-000-60100 Office Supplies 2,450.00 2,450.00 113.64 1,346.19 1,103.81 54.9 180-140-000-60300 Postage 1,571.00 1,571.00 617.94 1,954.09 (383.09) 124.4 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 16.48 196.73 3.27 98.4 180-140-000-73200 Communications /Pagers/Mobiles 1,798.00 1,798.00 157.63 2,326.73 (528.73) 129.4 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 0.00 1,714.50 (102.50) 106.4 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 0.00 1,640.93 914.07 64.2 180-140-000-74600 Meetings 312.00 312.00 0.00 116.00 196.00 37.2 180-140-000-76700 July 4 Celebration 10,000.00 10,000.00 0.00 0.00 10,000.00 # 180-140-000-78500 Furniture/Equipment<$5,000 1,750.00 1,750.00 3,405.57 4,081.30 (2,331.30) 233.2 180-140-000-79999 Miscellaneous Expense 100.00 100.00 0.00 0.00 100.00 # Total Managers Office 547,908.00 547,908.00 32,972.42 476,522.24 71,385.76 page 8 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 30 of 93 Meeting Date: August 16, 2011 180-611-000-40100 Salaries - Regular 70,839.00 70,839.00 5,449.60 54,921.96 15,917.04 77.5 180-611-000-40130 Salaries - Overtime 3,500.00 3,500.00 1,047.85 12,042.79 (8,542.79) 344.1 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 920.04 9,805.74 841.26 92.1 180-611-000-41210 Medical Insurance 8,583.00 8,583.00 715.24 6,964.43 1,618.57 81.1 180-611-000-41215 Dental Insurance 393.00 393.00 43.06 409.72 (16.72) 104.3 180-611-000-41216 Vision Insurance 75.00 75.00 4.98 49.80 25.20 66.4 180-611-000-41218 Life Insurance & Other 424.00 424.00 0.00 140.01 283.99 33.0 180-611-000-42220 Social Security Taxes 4,697.00 4,697.00 342.38 3,806.37 890.63 81.0 180-611-000-42225 Medicare Taxes 1,099.00 1,099.00 80.07 890.20 208.80 81.0 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 65.01 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 14.16 495.65 104.35 82.6 180-611-000-60300 Postage 500.00 500.00 0.00 306.75 193.25 61.4 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 1.59 13.18 86.82 13.2 180-611-000-73200 Communications /Pagers/Mobiles 670.00 670.00 52.81 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 0.00 22.00 391.00 5.3 180-611-000-74200 Travel & per diem 1,547.00 1,547.00 0.00 145.13 1,401.87 9.4 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 0.00 0.00 88.00 # Total Finance 113,706.00 113,706.00 8,736.79 95,628.24 18,077.76 page 9 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 31 of 93 Meeting Date: August 16, 2011 180-620-000-40100 Salaries - Regular 112,537.00 112,537.00 8,061.23 72,676.73 39,860.27 64.6 180-620-000-40130 Salaries - Overtime 1,500.00 1,500.00 94.99 706.43 793.57 47.1 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,154.92 9,942.88 6,056.12 62.1 180-620-000-41210 Medical Insurance 21,773.00 21,773.00 1,399.44 13,779.58 7,993.42 63.3 180-620-000-41215 Dental Insurance 1,136.00 1,136.00 92.07 902.77 233.23 79.5 180-620-000-41216 Vision Insurance 209.00 209.00 16.03 159.43 49.57 76.3 180-620-000-41218 Life Insurance & Other 800.00 800.00 0.00 249.23 550.77 31.2 180-620-000-42220 Social Security Taxes 7,029.00 7,029.00 454.58 4,368.44 2,660.56 62.1 180-620-000-42225 Medicare Taxes 1,644.00 1,644.00 106.31 1,021.65 622.35 62.1 180-620-000-42250 Unemployment Taxes 540.00 540.00 9.12 393.60 146.40 72.9 180-620-000-42260 Workman's Compensation 411.00 411.00 97.52 390.08 20.92 94.9 180-620-000-42290 Pre-employment Physicals/Testing 0.00 0.00 22.48 22.48 (22.48) # 180-620-000-56200 Utility Billing Contract 11,000.00 11,000.00 1,054.04 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 221.90 405.99 294.01 58.0 180-620-000-60300 Postage 18,000.00 18,000.00 1,369.95 13,158.75 4,841.25 73.1 180-620-000-73100 Telephone 100.00 100.00 2.93 98.28 1.72 98.3 180-620-000-73200 Communications /Pagers/Mobiles 472.00 472.00 37.33 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 1,975.43 18,155.75 (155.75) 100.9 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 0.00 30.09 574.91 5.0 180-620-000-74300 Schools & Training 800.00 800.00 46.44 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 16,216.71 167,566.85 70,004.15 page 10 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 32 of 93 Meeting Date: August 16, 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 43.88 518.85 1,269.15 29.0 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 43.88 745.91 6,199.09 page 11 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 33 of 93 Meeting Date: August 16, 2011 180-640-000-50700 Security 1,350.00 1,350.00 0.00 42.51 1,307.49 3.1 180-640-000-55000 Software & Support 50,453.00 50,453.00 3,897.28 43,436.45 7,016.55 86.1 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 0.00 244.61 126.39 65.9 180-640-000-60200 Printer Supplies 5,732.00 5,732.00 448.00 5,236.46 495.54 91.4 180-640-000-73100 Telephone 8,040.00 8,040.00 803.36 8,779.13 (739.13) 109.2 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 413.36 37,054.63 23,097.37 61.6 180-640-000-79100 Copier Rental/Lease 3,450.00 3,450.00 273.29 2,459.61 990.39 71.3 180-640-000-99500 Transfer to Future Replacement Reserve 26,911.00 26,911.00 0.00 0.00 26,911.00 # Total Information Services 157,923.00 157,923.00 5,835.29 99,632.86 58,290.14 page 12 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 34 of 93 Meeting Date: August 16, 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,315.49 10,964.97 9,930.03 52.5 180-710-000-72200 Water 1,061.00 1,061.00 81.12 560.41 500.59 52.8 180-710-000-75000 Insurance 31,081.00 31,081.00 0.00 23,475.81 7,605.19 75.5 180-710-000-79200 Building Rental/Lease 13,182.00 13,182.00 1,098.51 10,985.10 2,196.90 83.3 180-710-000-81200 Building Maintenance 11,970.00 11,970.00 64.00 13,398.94 (1,428.94) 111.9 180-710-000-81600 Cleaning Services 9,450.00 9,450.00 559.50 6,863.45 2,586.55 72.6 180-710-000-81900 Maintenance Supplies 2,100.00 2,100.00 65.68 1,530.46 569.54 72.9 Total Facilities Maintenance 90,739.00 90,739.00 3,184.30 69,377.17 21,361.83 page 13 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 35 of 93 Meeting Date: August 16, 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 0.00 27,933.31 7,066.69 79.8 180-810-000-51100 Appraisal 20,211.00 20,211.00 (62.73)12,269.68 7,941.32 60.7 180-810-000-51150 Tax Administration 3,603.00 3,603.00 56.24 2,696.56 906.44 74.8 Total Non Departmental 86,314.00 86,314.00 (6.49)70,399.55 15,914.45 Total Expenses 4,848,732.00 4,848,732.00 467,671.71 3,466,562.97 1,382,169.03 page 14 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 36 of 93 Meeting Date: August 16, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit Balance180-000-000-30100Property TaxesBalance Forward-86,324.04CR07/06/2011MUD 1 AV Taxes1668936.9807/08/2011MUD 1 AV Taxes1671530.8207/11/2011MUD 1 AV Taxes1673328.6607/11/2011MUD 1 AV Taxes1669130.8207/11/2011MUD 1 AV Taxes1671330.8207/12/2011MUD 1 AV Taxes1673529.7807/13/2011MUD 1 AV Taxes1680113.4207/15/2011MUD 1 AV Taxes169688.4107/18/2011MUD 1 AV Taxes171323.2507/19/2011MUD 1 AV Taxes174607.2007/22/2011MUD 1 AV Taxes177703.2007/25/2011MUD 1 AV Taxes1776817.2307/26/2011MUD 1 AV Taxes1777215.2207/27/2011MUD 1 AV Taxes1777410.9607/28/2011MUD 1 AV Taxes1782422.3807/29/2011MUD 1 AV Taxes178263.81Total30.82262.14 -86,555.36 CR180-000-000-30125Property Taxes/DelinquentBalance Forward-747.88CR07/15/2011MUD 1 AV Taxes169681.5107/21/2011MUD 1 AV Taxes174620.1407/26/2011MUD 1 AV Taxes1777217.71Total0.0019.36-767.24 CR180-000-000-30150Property Taxes/Penalty & InterestBalance Forward-1,380.92CR07/06/2011Advalorem Taxes166895.5507/08/2011Advalorem Taxes167154.6307/11/2011Advalorem Taxes167330.0807/11/2011Advalorem Taxes166914.6307/11/2011Advalorem Taxes167134.6307/12/2011Advalorem Taxes167353.8107/13/2011Advalorem Taxes168010.0407/15/2011Advalorem Taxes169681.6207/19/2011Advalorem Taxes174601.2907/21/2011Advalorem Taxes174620.0607/25/2011Advalorem Taxes177680.4107/26/2011Advalorem Taxes177720.9407/28/2011Advalorem Taxes178247.76Total4.6330.82 -1,407.11 CR180-000-000-35050Interest IncomeBalance Forward-4,404.48CR07/31/2011July Bank Interst18202166.7007/31/2011July Bank Interst18202186.03Total0.00352.73 -4,757.21 CR180-000-000-35150Cell Tower Lease RevenueBalance Forward-7,623.00CR07/05/2011Cell Tower Revenue/July17798847.00Total0.00847.00 -8,470.00 CR180-000-000-35160Lease/Rental RevenueBalance Forward0.00Total0.000.000.00180-000-000-35170Building RentBalance Forward-5,249.97CR07/29/2011Town/July Maint Barn Rent18150583.33Total0.00583.33 -5,833.30 CRTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011TCMUD No. 137 of 93Meeting Date: August 16, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011180-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-679.06CR07/29/2011Encana/Gas Well Revenue1781086.29Total0.0086.29-765.35 CR180-000-000-36400Auction SalesBalance Forward-202.12CRTotal0.00 0.00 -202.12 CR180-000-000-36500Vending RevenueBalance Forward-463.00CR07/14/2011WWTP Vending Revenue17800367.81Total0.00367.81-830.81 CR180-000-000-36700Miscellaneous RevenueBalance Forward-9,211.10CR07/18/2011Permits 7/18/1117146100.00Total0.00100.00 -9,311.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,171,884.82CR07/31/2011UB July Credit Adjustments181362,456.9607/31/2011UB July Billings18140248,748.81Total0.00 251,205.77 -1,423,090.59 CR180-000-000-38120Water - CommercialBalance Forward-492,238.22CR07/29/2011UB Adjustments178347,303.1207/31/2011UB July Credit Adjustments181361,593.9607/31/2011UB July Billings1814098,227.55Total8,897.08 98,227.55 -581,568.69 CR180-000-000-38130Water - PIDBalance Forward-188,190.86CR07/20/2011PID June Water billed1780247,069.23Total0.00 47,069.23 -235,260.09 CR180-000-000-38140Portable Meters - Out of DistrictBalance Forward-27,422.60CR07/18/2011UB Adjustments16964200.0007/21/2011UB Late Fees17324213.5907/28/2011UB Adjustments Penalties17818182.2407/31/2011UB July Credit Adjustments18136182.2407/31/2011UB July Billings1814011,657.48Total182.24 12,253.31 -39,493.67 CR180-000-000-38200Sewer - ResidentialBalance Forward-800,071.20CR07/31/2011UB July Credit Adjustments181362,020.9907/31/2011UB July Billings18140115,062.59Total2,020.99 115,062.59 -913,112.80 CR180-000-000-38220Sewer - CommercialBalance Forward-200,591.70CRTCMUD No. 138 of 93Meeting Date: August 16, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 201107/31/2011UB July Credit Adjustments1813689.7907/31/2011UB July Billings1814032,865.85Total89.79 32,865.85 -233,367.76 CR180-000-000-38230Sewer - PIDBalance Forward-110,078.49CR07/20/2011PID June Water billed1780218,738.12Total0.00 18,738.12 -128,816.61 CR180-000-000-38240Sewer - Out of DistrictBalance Forward-11,742.75CR07/31/2011UB July Credit Adjustments18136182.2407/31/2011UB July Billings181402,129.91Total182.24 2,129.91 -13,690.42 CR180-000-000-38250TCCC Effluent ChargesBalance Forward-28,958.34CR07/21/2011TCCC June Effluent1780415,140.19Total0.00 15,140.19 -44,098.53 CR180-000-000-38300StandbyBalance Forward-541.60CR07/31/2011UB July Credit Adjustments1813612.0007/31/2011UB July Billings1814078.00Total12.0078.00-607.60 CR180-000-000-38320PenaltiesBalance Forward-30,320.69CR07/11/2011UB Adjustments16725241.1707/21/2011UB Late Fees173246,632.7807/28/2011UB Adjustments Penalties178181,948.0507/29/2011UB Adjustments1783437.2707/31/2011UB July Credit Adjustments181361,948.77Total2,226.49 8,581.55 -36,675.75 CR180-000-000-38340Service ChargesBalance Forward-11,483.42CR07/06/2011UB Adjustments163591,250.0007/06/2011UB Adjustments17836125.0007/11/2011UB Adjustments1772625.0007/12/2011UB Adjustments1773025.0007/18/2011UB Adjustments1773425.0007/21/2011UB Adjustments1773825.0007/28/2011UB Adjustments Penalties1781825.0007/31/2011UB July Billings181403.00Total25.00 1,478.00 -12,936.42 CR180-000-000-38360Penalities - Out of DistrictBalance Forward-270.19CRTotal0.00 0.00 -270.19 CR180-000-000-38400Plumbing InspectionsBalance Forward-1,550.00CR07/05/2011Permits 7/5/111713650.0007/11/2011Permits 7/11/111714050.0007/18/2011Permits 7/18/111714650.0007/20/2011Permits 7/20/111778250.0007/22/2011Permits 7/22/111778450.00Total0.00250.00 -1,800.00 CR180-000-000-38420Sewer InspectionsBalance Forward-4,650.00CR07/05/2011Permits 7/5/1117136150.0007/11/2011Permits 7/11/1117140150.0007/18/2011Permits 7/18/1117146150.0007/20/2011Permits 7/20/1117782150.00TCMUD No. 139 of 93Meeting Date: August 16, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 201107/22/2011Permits 7/22/1117784150.00Total0.00750.00 -5,400.00 CR180-000-000-38500PID Utility FeesBalance Forward-11,500.00CR07/08/2011Permits 7/8/11171389,200.0007/11/2011Permits 7/11/111714011,500.0007/15/2011Permits 7/15/11171422,300.0007/19/2011Permits 7/19/11171484,600.0007/22/2011Permits 7/22/111778425,300.0007/27/2011Permits 7/27/11182062,300.0007/28/2011Permits 7/28/11182082,300.0007/29/2011Permits 7/29/111821011,500.00Total0.00 69,000.00 -80,500.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-40,389.00CR07/05/2011Permits 7/5/1117136292.0007/08/2011Permits 7/8/11171381,168.0007/11/2011Permits 7/11/11171401,752.0007/15/2011Permits 7/15/1117142292.0007/18/2011Permits 7/18/1117146292.0007/19/2011Permits 7/19/1117148584.0007/20/2011Permits 7/20/1117782292.0007/22/2011Permits 7/22/11177843,504.0007/26/2011Permits 7/26/11182043,838.6907/27/2011Permits 7/27/1118206292.0007/28/2011Permits 7/28/1118208292.0007/29/2011Permits 7/29/11182101,460.00Total0.00 14,058.69 -54,447.69 CR180-000-000-39200Transfer In - General FundBalance Forward0.00Total0.000.000.00180-000-000-39290Transfer In - Future Replacement ReservBalance Forward0.00Total0.000.000.00180-010-000-40100Salaries - RegularBalance Forward97,919.2507/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)174306,157.7007/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)171646,116.16Total12,273.860.00 110,193.11180-010-000-40130Salaries - OvertimeBalance Forward10,320.1007/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)17430732.8407/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)171641,259.32Total1,992.160.00 12,312.26180-010-000-40140Salaries - LongevityBalance Forward2,150.00Total0.000.00 2,150.00TCMUD No. 140 of 93Meeting Date: August 16, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011180-010-000-40160Salaries - CertificationBalance Forward1,280.0007/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 17164150.00Total150.000.00 1,430.00180-010-000-41200RetirementBalance Forward15,845.7607/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)17430975.6907/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)171641,065.60Total2,041.290.00 17,887.05180-010-000-41210Medical InsuranceBalance Forward15,897.3007/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)174301,062.9807/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)171641,062.98Total2,125.960.00 18,023.26180-010-000-41215Dental InsuranceBalance Forward934.0207/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)1743063.7207/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)1716463.72Total127.440.00 1,061.46180-010-000-41216Vision InsuranceBalance Forward168.1507/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)1743011.1407/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)1716411.14Total22.280.00190.43180-010-000-41218Life Insurance & OtherBalance Forward301.92Total0.000.00301.92180-010-000-42220Social Security TaxesBalance Forward6,615.9607/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)17430401.8007/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)17164441.19Total842.990.00 7,458.95180-010-000-42225Medicare TaxesBalance Forward1,547.2807/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)1743093.9807/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)17164103.17Total197.150.00 1,744.43180-010-000-42250Unemployment TaxesBalance Forward329.40Total0.000.00329.40180-010-000-42260Workman's CompensationBalance Forward5,526.5207/11/2011 4th Qtr/Workers Comp 16279 TML Intergovernmental Risk 070111 1,842.17Total1,842.170.00 7,368.69180-010-000-42290Pre-employment Physicals/TestingBalance Forward0.00Total0.000.000.00180-010-000-42960Employee RelationsBalance Forward226.04Total0.000.00226.04180-010-000-50500EngineeringBalance Forward80.15Total0.000.0080.15180-010-000-52400Lab AnalysisBalance Forward1,908.0007/01/2011 Water analysis/June 16757 Tarrant County Public Health Lab 20960 165.00Total165.000.00 2,073.00TCMUD No. 141 of 93Meeting Date: August 16, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011180-010-000-57000Independent LaborBalance Forward0.00Total0.000.000.00180-010-000-58000Bulk WaterBalance Forward763,458.4707/01/2011 June bulk water 17872 City of Fort Worth 063011 167,542.59Total167,542.590.00 931,001.06180-010-000-60300PostageBalance Forward13.35Total0.000.0013.35180-010-000-60400Publications/Books/SubscriptionsBalance Forward0.00Total0.000.000.00180-010-000-61000FuelBalance Forward6,131.7507/01/2011May Gas Log17794774.2507/01/2011June Gas Log177961,088.11Total1,862.360.00 7,994.11180-010-000-62100UniformsBalance Forward1,882.87Total0.000.00 1,882.87180-010-000-62300ChemicalsBalance Forward3,214.64Total0.000.00 3,214.64180-010-000-72100ElectricityBalance Forward92,822.8707/15/2011Electricity 6/15-7/1517882Hudson Energy2133450625.0607/15/2011Electricity 6/15-7/1517884Hudson Energy1646821,628.49Total22,253.550.00 115,076.42180-010-000-73200Communications /Pagers/MobilesBalance Forward1,350.2907/22/2011 Cell phones 18218 Verizon Wireless 6609304057 164.84Total164.840.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 Forward684.8707/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)1743069.8707/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)17164112.20Total182.070.00866.94180-010-000-74300Schools & TrainingBalance Forward1,508.00Total0.000.00 1,508.00180-010-000-74700Safety ProgramBalance Forward7.17Total0.000.007.17180-010-000-75200Annual Permit FeeBalance Forward6,133.95TCMUD No. 142 of 93Meeting Date: August 16, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011Total0.00 0.00 6,133.95180-010-000-78100Meter ExpenseBalance Forward83,182.24Total0.000.00 83,182.24180-010-000-78200Small ToolsBalance Forward284.87Total0.000.00284.87180-010-000-78300Safety EquipmentBalance Forward0.00Total0.000.000.00180-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.00180-010-000-80250Maintenance and RepairsBalance Forward7,217.1107/14/2011 Concrete/Indian Creek 17930 Lattimore Materials Co 406456 112.50Total112.500.00 7,329.61180-010-000-80300Non-routine MaintenanceBalance Forward0.00Total0.000.000.00180-010-000-81100Property MaintenanceBalance Forward702.85Total0.000.00702.85180-010-000-81200Building MaintenanceBalance Forward0.00Total0.000.000.00180-010-000-81300Vehicle MaintenanceBalance Forward2,182.50Total0.000.00 2,182.50180-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.51Total0.000.00 8,128.51180-010-000-91000Capital LeaseBalance Forward0.00Total0.000.000.00180-010-000-93700Capital ExpensesBalance Forward215,853.45TCMUD No. 143 of 93Meeting Date: August 16, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011Total0.00 0.00 215,853.45180-010-000-97000Capital RepairsBalance Forward0.00Total0.000.000.00180-010-000-97100Capital Repairs - Ground StorageBalance Forward97,741.64Total0.000.00 97,741.64180-010-000-99100Transfer to General FundBalance Forward0.00Total0.000.000.00180-010-000-99500Transfer to Future Replacement ReserveBalance Forward0.00Total0.000.000.00180-020-000-40100Salaries - RegularBalance Forward125,910.8507/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)174306,801.6007/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)171646,801.60Total13,603.200.00 139,514.05180-020-000-40130Salaries - OvertimeBalance Forward10,046.2007/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)17430119.6407/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)171641,276.63Total1,396.270.00 11,442.47180-020-000-40140Salaries - LongevityBalance Forward3,482.50Total0.000.00 3,482.50180-020-000-40160Salaries - CertificationBalance Forward1,775.0007/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 17164200.00Total200.000.00 1,975.00180-020-000-41200RetirementBalance Forward19,951.3107/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)17430980.0507/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)171641,172.20Total2,152.250.00 22,103.56180-020-000-41210Medical InsuranceBalance Forward25,068.0907/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)174301,392.6607/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)171641,392.66Total2,785.320.00 27,853.41180-020-000-41215Dental InsuranceBalance Forward1,379.3707/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)1743077.4907/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)1716477.49Total154.980.00 1,534.35180-020-000-41216Vision InsuranceBalance Forward267.8407/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)1743014.8807/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)1716414.88Total29.760.00297.60180-020-000-41218Life Insurance & OtherBalance Forward415.01Total0.000.00415.01180-020-000-42220Social Security TaxesBalance Forward7,639.7707/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)17430357.58TCMUD No. 144 of 93Meeting Date: August 16, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 201107/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)17164441.73Total799.310.00 8,439.08180-020-000-42225Medicare TaxesBalance Forward1,786.7207/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)1743083.6307/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)17164103.31Total186.940.00 1,973.66180-020-000-42250Unemployment TaxesBalance Forward434.45Total0.000.00434.45180-020-000-42260Workman's CompensationBalance Forward5,986.3607/11/2011 4th Qtr/Workers Comp 16279 TML Intergovernmental Risk 070111 1,995.46Total1,995.460.00 7,981.82180-020-000-42960Employee RelationsBalance Forward151.88Total0.000.00151.88180-020-000-50500EngineeringBalance Forward2,800.00Total0.000.00 2,800.00180-020-000-52400Lab AnalysisBalance Forward9,978.75Total0.000.00 9,978.75180-020-000-57000Independent LaborBalance Forward0.00Total0.000.000.00180-020-000-60100Office SuppliesBalance Forward7.24Total0.000.007.24180-020-000-60300PostageBalance Forward0.00Total0.000.000.00180-020-000-60400Publications/Books/SubscriptionsBalance Forward0.00Total0.000.000.00180-020-000-61000FuelBalance Forward1,620.2707/01/2011May Gas Log17794295.6307/01/2011June Gas Log17796375.25Total670.880.00 2,291.15180-020-000-62100UniformsBalance Forward1,449.17Total0.000.00 1,449.17180-020-000-62300ChemicalsBalance Forward4,028.28Total0.000.00 4,028.28180-020-000-62800Lab SuppliesBalance Forward3,559.06Total0.000.00 3,559.06180-020-000-62900Other ConsumablesBalance Forward50.14Total0.000.0050.14180-020-000-72100ElectricityBalance Forward148,595.1007/15/2011 Electricity 6/15-7/15 17880 Hudson Energy 16417 17,153.85TCMUD No. 145 of 93Meeting Date: August 16, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011Total17,153.85 0.00 165,748.95180-020-000-72200WaterBalance Forward1,240.0207/31/2011 July Water 18220 Trophy Club MUD - Water Bills 073111 48.82Total48.820.00 1,288.84180-020-000-72400Dumpster ServicesBalance Forward11,319.25Total0.000.00 11,319.25180-020-000-73100TelephoneBalance Forward1.3607/27/2011 Steve Z. 18212 Bank of America 072711 2.00Total2.000.003.36180-020-000-73200Communications /Pagers/MobilesBalance Forward2,605.9007/22/2011 Cell phones 18218 Verizon Wireless 6609304057 242.66Total242.660.00 2,848.56180-020-000-74200Travel & per diemBalance Forward1,701.8107/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)1743021.4207/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)17164187.17Total208.590.00 1,910.40180-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.71Total0.000.00481.71180-020-000-78300Safety EquipmentBalance Forward658.23Total0.000.00658.23180-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.01Total0.000.00 11,439.01180-020-000-81100Property MaintenanceBalance Forward0.00Total0.000.000.00180-020-000-81200Building MaintenanceBalance Forward0.00Total0.000.000.00TCMUD No. 146 of 93Meeting Date: August 16, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011180-020-000-81300Vehicle MaintenanceBalance Forward1,049.74Total0.000.00 1,049.74180-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.82Total0.000.00761.82180-020-000-93700Capital ExpensesBalance Forward5,861.0007/24/2011 Membrane Filters loan payment 17342 American National Bank of Texas 88112909 073011 118,689.39Total118,689.390.00 124,550.39180-020-000-97000Capital RepairsBalance Forward1,500.00Total0.000.00 1,500.00180-021-000-40100Salaries - RegularBalance Forward97,218.2407/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)174305,259.3607/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)171645,259.36Total10,518.720.00 107,736.96180-021-000-40130Salaries - OvertimeBalance Forward13,119.7807/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)17430414.2407/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)17164282.42Total696.660.00 13,816.44180-021-000-40140Salaries - LongevityBalance Forward3,160.00Total0.000.00 3,160.00180-021-000-40160Salaries - CertificationBalance Forward1,125.0007/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 17164125.00Total125.000.00 1,250.00180-021-000-41200RetirementBalance Forward16,172.6007/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)17430803.3807/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)17164802.42Total1,605.800.00 17,778.40180-021-000-41210Medical InsuranceBalance Forward16,893.1907/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)17430989.1907/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)17164989.19Total1,978.380.00 18,871.57180-021-000-41215Dental InsuranceBalance Forward1,010.8107/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)1743059.4407/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)1716459.44Total118.880.00 1,129.69180-021-000-41216Vision InsuranceBalance Forward170.7007/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)174309.9307/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)171649.93Total19.860.00190.56TCMUD No. 147 of 93Meeting Date: August 16, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011180-021-000-41218Life Insurance & OtherBalance Forward316.23Total0.000.00316.23180-021-000-42220Social Security TaxesBalance Forward6,590.7407/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)17430310.1907/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)17164309.78Total619.970.00 7,210.71180-021-000-42225Medicare TaxesBalance Forward1,543.8907/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)1743072.5407/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)1716472.46Total145.000.00 1,688.89180-021-000-42250Unemployment TaxesBalance Forward333.23Total0.000.00333.23180-021-000-42260Workman's CompensationBalance Forward3,140.5207/11/2011 4th Qtr/Workers Comp 16279 TML Intergovernmental Risk 070111 1,046.84Total1,046.840.00 4,187.36180-021-000-42960Employee RelationsBalance Forward191.59Total0.000.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 Forward5,928.0307/01/2011May Gas Log177941,084.9207/01/2011June Gas Log177961,052.49Total2,137.410.00 8,065.44180-021-000-62100UniformsBalance Forward860.75Total0.000.00860.75180-021-000-62300ChemicalsBalance Forward0.00Total0.000.000.00180-021-000-72100ElectricityBalance Forward13,556.8907/15/2011 Electricity 6/15-7/15 17880 Hudson Energy 16417 404.47Total404.470.00 13,961.36180-021-000-72200WaterBalance Forward0.00Total0.000.000.00180-021-000-73100TelephoneBalance Forward20.5807/27/2011 Steve Z. 18212 Bank of America 072711 1.05Total1.050.0021.63180-021-000-73200Communications /Pagers/MobilesBalance Forward2,129.28TCMUD No. 148 of 93Meeting Date: August 16, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 201107/22/2011Cell phones18218Verizon Wireless6609304057203.63Total203.630.00 2,332.91180-021-000-74100Dues & MembershipBalance Forward0.0007/19/2011 Commercial license/Valadez (GapVax) 17366 Texas Dept of Public Safety 071911 61.00Total61.000.0061.00180-021-000-74200Travel & per diemBalance Forward551.2607/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 1743032.64Total32.640.00583.90180-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,158.7207/20/2011 12V Faston 17886 Interstate All Battery Center, Inc 1712702000653 16.50Total16.500.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 Forward641.3707/26/2011 Vehicle Maint Contract/GapVax 17928 Texas Underground, Inc 0079091-IN 5,200.00Total5,200.000.00 5,841.37180-021-000-81900Maintenance SuppliesBalance Forward2,050.63Total0.000.00 2,050.63180-021-000-93700Capital ExpensesBalance Forward0.0007/26/2011GAPVAX Loan pmt deposited in error1780610,979.2507/26/2011GAPVAX loan payment. Ck 30686 deposited 17870First Financial Bank91500007041 0811B10,979.25Total10,979.25 10,979.250.00180-021-000-97000Capital RepairsBalance Forward0.00TCMUD No. 149 of 93Meeting Date: August 16, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011Total0.00 0.00 0.00180-130-000-40100Salaries - RegularBalance Forward4,200.0007/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)17430900.0007/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)17164300.00Total1,200.000.00 5,400.00180-130-000-42220Social Security TaxesBalance Forward260.4007/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)1743055.8007/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)1716418.60Total74.400.00334.80180-130-000-42225Medicare TaxesBalance Forward60.9007/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)1743013.0507/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)171644.35Total17.400.0078.30180-130-000-42250Unemployment TaxesBalance Forward57.0007/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)174307.2007/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)171642.40Total9.600.0066.60180-130-000-42260Workman's CompensationBalance Forward85.4107/11/2011 4th Qtr/Workers Comp 16279 TML Intergovernmental Risk 070111 28.47Total28.470.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 Forward759.0207/01/2011Reimburse expenses16743James C. Thomas032811128.0407/01/2011AWBD expenses16745James C. Thomas061011 AWBD81.20Total209.240.00968.26180-130-000-74300Schools & TrainingBalance Forward2,140.00Total0.000.00 2,140.00180-130-000-74600MeetingsBalance Forward289.00TCMUD No. 150 of 93Meeting Date: August 16, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011Total0.00 0.00 289.00180-130-000-79999Miscellaneous ExpenseBalance Forward0.00Total0.000.000.00180-130-000-87110Water Conservation Program/Public InforBalance Forward2,334.72Total0.000.00 2,334.72180-140-000-40100Salaries - RegularBalance Forward147,725.0007/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)174308,184.2707/22/2011Payroll Cycle 15 - M MOORE FINAL CHECK 174326,356.3407/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)171648,093.45Total22,634.06 0.00 170,359.06180-140-000-40130Salaries - OvertimeBalance Forward221.4807/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)1743016.5007/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)1716424.08Total40.580.00262.06180-140-000-40140Salaries - LongevityBalance Forward2,755.00Total0.000.00 2,755.00180-140-000-41200RetirementBalance Forward20,837.3807/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)17430984.6307/22/2011Payroll Cycle 15 - M MOORE FINAL CHECK 17432900.0607/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)171641,149.47Total3,034.160.00 23,871.54180-140-000-41210Medical InsuranceBalance Forward13,115.1707/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)17430433.0407/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)17164433.04Total866.080.00 13,981.25180-140-000-41215Dental InsuranceBalance Forward744.6507/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)1743025.8207/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)1716425.82Total51.640.00796.29180-140-000-41216Vision InsuranceBalance Forward138.0007/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)174304.9807/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)171644.98Total9.960.00147.96180-140-000-41218Life Insurance & OtherBalance Forward373.34Total0.000.00373.34180-140-000-42220Social Security TaxesBalance Forward9,333.7707/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)17430506.5007/22/2011Payroll Cycle 15 - M MOORE FINAL CHECK 17432394.1007/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)17164487.53Total1,388.13 0.00 10,721.90180-140-000-42225Medicare TaxesBalance Forward2,206.5907/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)17430118.4607/22/2011Payroll Cycle 15 - M MOORE FINAL CHECK 1743292.1707/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)17164114.01TCMUD No. 151 of 93Meeting Date: August 16, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011Total324.64 0.00 2,531.23180-140-000-42250Unemployment TaxesBalance Forward428.5807/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)174309.9807/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)171649.31Total19.290.00447.87180-140-000-42260Workman's CompensationBalance Forward557.3407/11/2011 4th Qtr/Workers Comp 16279 TML Intergovernmental Risk 070111 185.78Total185.780.00743.12180-140-000-42290Pre-employment Physicals/TestingBalance Forward52.4507/01/2011Pre emp testing/Schultz16755CareNow86331417.5007/01/2011Pre emp testing/Schultz16761First Check Applicant Screening 20894.97Total22.470.0074.92180-140-000-42960Employee RelationsBalance Forward906.17Total0.000.00906.17180-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 Forward322.5007/19/2011Recording Joint Town/MUD meeting17344Miguel Cruz07191135.6207/20/2011Record MUD meeting17346Miguel Cruz07201148.75Total84.370.00406.87180-140-000-60100Office SuppliesBalance Forward1,232.5507/27/2011Pastor18212Bank of America07271120.1107/29/2011Office Supplies18224Office Depot57310628600183.9007/29/2011Office Supplies18228Office Depot5731083370019.63Total113.640.00 1,346.19180-140-000-60300PostageBalance Forward1,336.1507/08/2011Postage for UB mailing16159U.S. Postal Service070811588.9007/21/2011Letter to TCEQ17874Federal Express Corp7-568-7425629.04Total617.940.00 1,954.09180-140-000-60400Publications/Books/SubscriptionsBalance Forward215.40Total0.000.00215.40180-140-000-73100TelephoneBalance Forward180.2507/27/2011 Steve Z. 18212 Bank of America 072711 16.48Total16.480.00196.73180-140-000-73200Communications /Pagers/MobilesBalance Forward2,169.1007/22/2011 Cell phones 18218 Verizon Wireless 6609304057 157.63Total157.630.00 2,326.73180-140-000-73300AdvertisingBalance Forward0.00TCMUD No. 152 of 93Meeting Date: August 16, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011Total0.00 0.00 0.00180-140-000-73400PrintingBalance Forward3,170.00Total0.000.00 3,170.00180-140-000-73600Service Charges & FeesBalance Forward32.50Total0.000.0032.50180-140-000-74100Dues & MembershipBalance Forward1,714.50Total0.000.00 1,714.50180-140-000-74200Travel & per diemBalance Forward1,201.01Total0.000.00 1,201.01180-140-000-74300Schools & TrainingBalance Forward1,640.93Total0.000.00 1,640.93180-140-000-74600MeetingsBalance Forward116.00Total0.000.00116.00180-140-000-76700July 4 CelebrationBalance Forward0.00Total0.000.000.00180-140-000-78500Furniture/Equipment<$5,000Balance Forward675.7307/01/2011 Furniture for remodel 17892 National Business Furniture, LLC CV748845 3,405.57Total3,405.570.00 4,081.30180-140-000-79999Miscellaneous ExpenseBalance Forward0.00Total0.000.000.00180-611-000-40100Salaries - RegularBalance Forward49,472.3607/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)174302,724.8007/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)171642,724.80Total5,449.600.00 54,921.96180-611-000-40130Salaries - OvertimeBalance Forward10,994.9407/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)17430341.2807/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)17164706.57Total1,047.850.00 12,042.79180-611-000-40140Salaries - LongevityBalance Forward1,710.00Total0.000.00 1,710.00180-611-000-41200RetirementBalance Forward8,885.7007/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)17430434.1507/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)17164485.89Total920.040.00 9,805.74180-611-000-41210Medical InsuranceBalance Forward6,249.1907/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)17430357.6207/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)17164357.62Total715.240.00 6,964.43180-611-000-41215Dental InsuranceBalance Forward366.6607/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)1743021.5307/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)1716421.53TCMUD No. 153 of 93Meeting Date: August 16, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011Total43.06 0.00 409.72180-611-000-41216Vision InsuranceBalance Forward44.8207/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)174302.4907/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)171642.49Total4.980.0049.80180-611-000-41218Life Insurance & OtherBalance Forward140.01Total0.000.00140.01180-611-000-42220Social Security TaxesBalance Forward3,463.9907/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)17430159.8607/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)17164182.52Total342.380.00 3,806.37180-611-000-42225Medicare TaxesBalance Forward810.1307/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)1743037.3907/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)1716442.68Total80.070.00890.20180-611-000-42250Unemployment TaxesBalance Forward129.59Total0.000.00129.59180-611-000-42260Workman's CompensationBalance Forward195.0307/11/2011 4th Qtr/Workers Comp 16279 TML Intergovernmental Risk 070111 65.01Total65.010.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 Forward481.4907/29/2011 Office Supplies 18224 Office Depot 573106286001 14.16Total14.160.00495.65180-611-000-60300PostageBalance Forward306.75Total0.000.00306.75180-611-000-60400Publications/Books/SubscriptionsBalance Forward0.00Total0.000.000.00180-611-000-73100TelephoneBalance Forward11.5907/27/2011 Steve Z. 18212 Bank of America 072711 1.59Total1.590.0013.18180-611-000-73200Communications /Pagers/MobilesBalance Forward508.1707/22/2011 Cell phones 18218 Verizon Wireless 6609304057 52.81Total52.810.00560.98180-611-000-73300AdvertisingBalance Forward207.40Total0.000.00207.40180-611-000-73400PrintingBalance Forward0.00Total0.000.000.00TCMUD No. 154 of 93Meeting Date: August 16, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011180-611-000-73600Service Charges & FeesBalance Forward0.00Total0.000.000.00180-611-000-74100Dues & MembershipBalance Forward22.00Total0.000.0022.00180-611-000-74200Travel & per diemBalance Forward145.13Total0.000.00145.13180-611-000-74300Schools & TrainingBalance Forward309.00Total0.000.00309.00180-611-000-74600MeetingsBalance Forward0.00Total0.000.000.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 Forward64,615.5007/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)174302,505.8607/22/2011Payroll Cycle 15 - D MCMAHON FINAL CHECK 17434881.7607/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)171644,673.61Total8,061.230.00 72,676.73180-620-000-40130Salaries - OvertimeBalance Forward611.4407/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)174303.7507/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)1716491.24Total94.990.00706.43180-620-000-40140Salaries - LongevityBalance Forward405.00Total0.000.00405.00180-620-000-41200RetirementBalance Forward8,787.9607/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)17430355.3607/22/2011Payroll Cycle 15 - D MCMAHON FINAL CHECK 17434124.8607/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)17164674.70Total1,154.92 0.00 9,942.88180-620-000-41210Medical InsuranceBalance Forward12,380.1407/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)17430575.2407/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)17164824.20Total1,399.440.00 13,779.58180-620-000-41215Dental InsuranceBalance Forward810.7007/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)1743039.5807/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)1716452.49Total92.070.00902.77180-620-000-41216Vision InsuranceBalance Forward143.4007/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)174306.7707/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)171649.26Total16.030.00159.43TCMUD No. 155 of 93Meeting Date: August 16, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011180-620-000-41218Life Insurance & OtherBalance Forward249.23Total0.000.00249.23180-620-000-42220Social Security TaxesBalance Forward3,913.8607/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)17430136.7807/22/2011Payroll Cycle 15 - D MCMAHON FINAL CHECK 1743454.6707/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)17164263.13Total454.58 0.00 4,368.44180-620-000-42225Medicare TaxesBalance Forward915.3407/08/2011Payroll Cycle 14 (06/19 - 07/02/2011)1743031.9807/22/2011Payroll Cycle 15 - D MCMAHON FINAL CHECK 1743412.7907/22/2011Payroll Cycle 15 (07/03 - 07/16/2011)1716461.54Total106.310.00 1,021.65180-620-000-42250Unemployment TaxesBalance Forward384.4807/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 171649.12Total9.120.00393.60180-620-000-42260Workman's CompensationBalance Forward292.5607/11/2011 4th Qtr/Workers Comp 16279 TML Intergovernmental Risk 070111 97.52Total97.520.00390.08180-620-000-42290Pre-employment Physicals/TestingBalance Forward0.0007/01/2011Pre emp testing/Schultz16755CareNow86331417.5007/01/2011Pre emp testing/Schultz16761First Check Applicant Screening 20894.98Total22.480.0022.48180-620-000-56200Utility Billing ContractBalance Forward7,786.8407/31/2011 July water billing 17910 CSG Systems, Inc. 73825 1,054.04Total1,054.040.00 8,840.88180-620-000-57000Independent LaborBalance Forward0.00Total0.000.000.00180-620-000-60100Office SuppliesBalance Forward184.0907/07/2011Colored Copy Paper for Confidentiality m 18222Office Depot136147869028.6207/27/2011Steve Z.18212Bank of America07271149.9807/29/2011Office Supplies18224Office Depot573106286001132.4707/29/2011 Office Supplies 18226 Office Depot 573108336001 10.83Total221.90 0.00 405.99180-620-000-60300PostageBalance Forward11,788.8007/31/2011 July water billing 17910 CSG Systems, Inc. 73825 1,369.95Total1,369.950.00 13,158.75180-620-000-73100TelephoneBalance Forward95.3507/27/2011 Steve Z. 18212 Bank of America 072711 2.93Total2.930.0098.28180-620-000-73200Communications /Pagers/MobilesBalance Forward373.0307/22/2011 Cell phones 18218 Verizon Wireless 6609304057 37.33Total37.330.00410.36180-620-000-73400PrintingBalance Forward2,152.00TCMUD No. 156 of 93Meeting Date: August 16, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011Total0.00 0.00 2,152.00180-620-000-73600Service Charges & FeesBalance Forward16,180.3207/06/2011World Pay Credit card fees/June177861,656.3507/06/2011World Pay Credit card fees/June17786309.0907/06/2011World Pay Credit card fees/June177869.99Total1,975.430.00 18,155.75180-620-000-74100Dues & MembershipBalance Forward0.00Total0.000.000.00180-620-000-74200Travel & per diemBalance Forward30.09Total0.000.0030.09180-620-000-74300Schools & TrainingBalance Forward0.0007/21/2011 Excel Book purchased at class 17898 Nicole D'Andria 072111 46.44Total46.440.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 Forward474.9707/27/2011Pastor18212Bank of America07271121.9407/27/2011Steve Z.18212Bank of America07271121.94Total43.880.00518.85180-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. 157 of 93Meeting Date: August 16, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011180-630-000-74100Dues & MembershipBalance Forward0.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.51Total0.000.0042.51180-640-000-55000Software & SupportBalance Forward39,539.1707/01/2011Internet16747Bandwidth.com, Inc.IN07152011-200714329.6907/01/2011Annual support for Remit Plus17340Jack Henry & Assoc09124181,750.0007/18/2011STW Support for Innoprise conversion17356STW Inc071811328.7507/26/2011Annual connect software support17932Badger Meter, Inc92644601989.0407/27/2011Pastor18212Bank of America07271125.0007/27/2011Pastor18212Bank of America07271177.5207/27/2011Steve Z.18212Bank of America072711293.9107/27/2011Steve Z.18212Bank of America07271149.9907/27/2011Steve Z.18212Bank of America07271153.38Total3,897.280.00 43,436.45180-640-000-57000Independent LaborBalance Forward2,348.75Total0.000.00 2,348.75180-640-000-60100Office SuppliesBalance Forward244.61Total0.000.00244.61180-640-000-60200Printer SuppliesBalance Forward4,788.4607/12/2011Printer supplies17362SHI Governmental Solutions GB00038296306.5007/12/2011Printer supplies17364SHI Governmental Solutions GB00038309141.50Total448.000.00 5,236.46180-640-000-73100TelephoneBalance Forward7,975.7707/27/2011Steve Z.18212Bank of America072711451.8807/27/2011Steve Z.18212Bank of America072711351.48Total803.360.00 8,779.13180-640-000-73200Communications /Pagers/MobilesBalance Forward0.00Total0.000.000.00180-640-000-74200Travel & per diemBalance Forward16.18Total0.000.0016.18180-640-000-75900Prompt Payment InterestBalance Forward14.53Total0.000.0014.53TCMUD No. 158 of 93Meeting Date: August 16, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011180-640-000-78600HardwareBalance Forward36,641.2707/08/2011Video Converters17358SHI Governmental Solutions GB0003817511.0007/11/2011Video Converters17360SHI Governmental Solutions GB0003822112.3607/22/2011Printer for MUD Barn17902SHI Governmental Solutions GB00039016390.00Total413.360.00 37,054.63180-640-000-79100Copier Rental/LeaseBalance Forward2,186.3207/01/2011July Adm Copier lease16749Kyocera Mita America, Inc110646593146.7607/01/2011July PW Copier lease16751Kyocera Mita America, Inc110646602115.6207/01/2011July PW Fax lease16753Kyocera Mita America, Inc11064660310.91Total273.290.00 2,459.61180-640-000-99100Transfer to General FundBalance Forward0.00Total0.000.000.00180-640-000-99500Transfer to Future Replacement ReserveBalance Forward0.00Total0.000.000.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 Forward9,649.4807/27/2011 Electricity 6/14-7/15 17908 Direct Energy Business Svcs 1159824 1,315.49Total1,315.490.00 10,964.97180-710-000-72200WaterBalance Forward479.2907/31/2011 July Water 18220 Trophy Club MUD - Water Bills 073111 81.12Total81.120.00560.41180-710-000-75000InsuranceBalance Forward23,475.81Total0.000.00 23,475.81180-710-000-79200Building Rental/LeaseBalance Forward9,886.5907/01/2011 Public Services Building rent/July 15946 Town of Trophy Club 070111 PS Rent 1,098.51Total1,098.510.00 10,985.10180-710-000-81200Building MaintenanceBalance Forward13,334.9407/01/2011 AC repair 17900 North Texas Heating & Air, Inc. 040631 64.00Total64.000.00 13,398.94180-710-000-81600Cleaning ServicesBalance Forward6,303.9507/01/2011 July Janitorial service 16763 ABM Janitorial Services, Inc 2671042 559.50Total559.500.00 6,863.45180-710-000-81900Maintenance SuppliesBalance Forward1,464.7807/01/2011 June purchases 16741 Costco Wholesale 062611 65.68Total65.680.00 1,530.46180-810-000-50200AuditingBalance Forward27,500.00Total0.000.00 27,500.00180-810-000-50300LegalBalance Forward27,933.31Total0.000.00 27,933.31TCMUD No. 159 of 93Meeting Date: August 16, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011180-810-000-51100AppraisalBalance Forward12,332.4107/29/2011 Tarrant Appraisal/2010 Budget Refund 1780862.73Total0.0062.73 12,269.68180-810-000-51150Tax AdministrationBalance Forward2,640.3207/13/2011 Tax collection notices 17352 Denton County Tax Office 071311 56.24Total56.240.00 2,696.56GRAND TOTAL492,384.97 700,580.22 -460,117.44TCMUD No. 160 of 93Meeting Date: August 16, 2011 380-010-000-93700 Capital Expenses 0.00 0.00 0.00 112,162.31 (112,162.31) # 380-020-000-93700 Capital Expenses 0.00 0.00 152,000.00 210,220.60 (210,220.60) # Total Capital Projects 0.00 0.00 152,000.00 322,382.91 (322,382.91) page 1 Budget to Actual - Capital Pro Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 61 of 93 Meeting Date: August 16, 2011 G/L #Effective DateDescriptionJournal #Vendor NameVendor Invoice #DebitCreditBalance380-010-000-93700Capital ExpensesBalanceForward112,162.31Total0.000.00112,162.31380-020-000-93700Capital ExpensesBalanceForward58,220.60Trophy Club Municipal Utility Dist #1G/L Transaction Detail Report July 31, 2011TCMUD No. 162 of 93Meeting Date: August 16, 2011 Municipal Utility District No 1 Fire Department O & M Interim Balance Sheet Balance @ 7/31/2011 ASSETS ASSETS CASH IN BANK -$ INVESTMENTS 477,071 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 25,568 ACCOUNTS RECEIVABLE - PID EMERGENCY SERVICES ASSESSMENTS 4,864 OTHER RECEIVABLES 18,855 TOTAL ASSETS 526,359$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE 30,433$ ACCOUNTS PAYABLE 29,773 TOTAL LIABILITIES 60,205 FUND BALANCE UNDESIGNATED FUND BALANCE 466,154 TOTAL LIABILITIES AND FUND BALANCE 526,359$ July 31, 2011 10/12 Months (84% of Fiscal Year) TCMUD No. 1 63 of 93 Meeting Date: August 16, 2011 Account/DescriptionYTD BudgetTotal BudgetMTD RevYTD RevTotal VarianceRemaining %[FUND] 190 : Fire Department Operations190-000-000-30050 : Emergency Service Assessment111,648.00111,648.004,510.70120,126.77-8,478.77-7.59190-000-000-30060 : Emergency Services Assessment - P&I0.000.00704.631,729.10-1,729.100.00190-000-000-30100 : Property Taxes1,072,786.001,072,786.002,874.881,071,346.561,439.440.13190-000-000-30125 : Property Taxes/Delinquent0.000.00146.998,750.49-8,750.490.00190-000-000-30150 : Property Taxes/Penalty & Interest7,500.007,500.00308.394,917.482,582.5234.43190-000-000-32014 : Fire Permits/Sprinkler0.000.00400.001,600.00-1,600.000.00190-000-000-33050 : Fire Inspections0.000.0075.00225.00-225.000.00190-000-000-33420 : Denton/Tarrant County - Fire13,750.0013,750.000.0010,000.003,750.0027.27190-000-000-35050 : Interest Income0.000.000.0075.00-75.000.00190-000-000-36700 : Miscellaneous Revenue2,500.002,500.00725.001,775.00725.0029.00[FUND] SubTotal : 190 : Fire Department Operations1,208,184.001,208,184.009,745.591,220,545.40-12,361.40-1.02 Grand Total : 1,208,184.001,208,184.009,745.591,220,545.40-12,361.40-1.02Run Date: 08/11/2011User: rgonzalesTrophy Club Municipal Utility Dist #1Budget Revenue ReportTo Date: 07/31/2011TCMUD No. 164 of 93Meeting Date: August 16, 2011 190-045-000-40100 Salaries - Regular 390,466.00 390,466.00 31,327.81 312,161.11 78,304.89 79.9 190-045-000-40130 Salaries - Overtime 40,298.00 40,298.00 3,293.39 42,155.85 (1,857.85) 104.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 494.70 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,518.44 51,262.97 11,753.03 81.3 190-045-000-41210 Medical Insurance 54,809.00 54,809.00 3,919.66 40,060.34 14,748.66 73.1 190-045-000-41215 Dental Insurance 2,819.00 2,819.00 244.31 2,446.63 372.37 86.8 190-045-000-41216 Vision Insurance 505.00 505.00 37.77 393.61 111.39 77.9 190-045-000-41218 Life Insurance & Other 2,491.00 2,491.00 0.00 843.63 1,647.37 33.9 190-045-000-42220 Social Security Taxes 26,252.00 26,252.00 1,978.84 21,734.36 4,517.64 82.8 190-045-000-42225 Medicare Taxes 6,140.00 6,140.00 462.80 5,086.09 1,053.91 82.8 190-045-000-42250 Unemployment Taxes 1,387.00 1,387.00 13.52 934.49 452.51 67.4 190-045-000-42260 Workman's Compensation 13,134.00 13,134.00 3,116.32 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 0.00 92.26 2.74 97.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 1,584.10 8,595.62 7,989.38 51.8 190-045-000-62100 Uniforms 4,357.00 4,357.00 0.00 3,530.32 826.68 81.0 190-045-000-62150 Protective Clothing 7,600.00 7,600.00 0.00 756.18 6,843.82 9.9 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,331.22 9,176.47 8,223.53 52.7 190-045-000-72200 Water 3,193.00 3,193.00 43.20 444.61 2,748.39 13.9 190-045-000-73100 Telephone 103.00 103.00 9.95 124.20 (21.20) 120.6 190-045-000-73200 Communications /Pagers/Mobiles 1,874.00 1,874.00 197.29 2,211.93 (337.93) 118.0 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 0.00 3,316.95 3,298.05 50.1 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 190-045-000-78200 Small Tools 8,127.00 8,127.00 0.00 4,564.53 3,562.47 56.2 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 0.00 205.76 1,007.24 17.0 190-045-000-80250 Maintenance and Repairs 5,562.00 5,562.00 1,341.50 3,293.78 2,268.22 59.2 190-045-000-81200 Building Maintenance 11,000.00 11,000.00 160.99 6,965.63 4,034.37 63.3 190-045-000-81300 Vehicle Maintenance 13,500.00 13,500.00 0.00 8,458.68 5,041.32 62.7 190-045-000-81350 Equipment Maintenance 3,675.00 3,675.00 0.00 521.71 3,153.29 14.2 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 0.00 925.60 1,726.40 34.9 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 1,190.00 2,072.85 2,007.15 50.8 190-045-000-90100 Radios 2,500.00 2,500.00 0.00 807.50 1,692.50 32.3 190-045-000-90200 Fire Engine 681 Payment 73,388.00 73,388.00 0.00 5,693.95 67,694.05 7.8 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 0.00 0.00 2,245.00 # page 1 Budget to Actual - Fire Dept. Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 65 of 93 Meeting Date: August 16, 2011 Total Fire Department 1,208,184.00 1,208,184.00 55,265.81 909,593.59 298,590.41 page 2 Budget to Actual - Fire Dept. Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 66 of 93 Meeting Date: August 16, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit Balance190-000-000-30100Property TaxesBalance Forward-1,068,471.68CR07/06/2011 MUD 1 AV Taxes16689459.6707/08/2011 MUD 1 AV Taxes16715383.1007/11/2011 MUD 1 AV Taxes16733356.2307/11/2011 MUD 1 AV Taxes16691383.1007/11/2011 MUD 1 AV Taxes16713383.1007/12/2011 MUD 1 AV Taxes16735370.1307/13/2011 MUD 1 AV Taxes16801166.7407/15/2011 MUD 1 AV Taxes16968104.5607/18/2011 MUD 1 AV Taxes1713240.3907/19/2011 MUD 1 AV Taxes1746089.4407/22/2011 MUD 1 AV Taxes1777039.7407/25/2011 MUD 1 AV Taxes17768214.1007/26/2011 MUD 1 AV Taxes17772189.2007/27/2011 MUD 1 AV Taxes17774136.1607/28/2011 MUD 1 AV Taxes17824278.1307/29/2011 MUD 1 AV Taxes1782647.29Total383.10 3,257.98 -1,071,346.56 CR190-000-000-30125Property Taxes/DelinquentBalance Forward-8,603.50CR07/15/2011 Advalorem Taxes169686.9607/21/2011 Advalorem Taxes174621.0907/26/2011 Advalorem Taxes17772138.94Total0.00146.99 -8,750.49 CR190-000-000-30150Property Taxes/Penalty & InterestBalance Forward-4,609.09CR07/06/2011 Advalorem Taxes1668968.9407/08/2011 Advalorem Taxes1671557.4607/11/2011 Advalorem Taxes167331.0407/11/2011 Advalorem Taxes1669157.4607/11/2011 Advalorem Taxes1671357.4607/12/2011 Advalorem Taxes1673547.3507/13/2011 Advalorem Taxes168010.5907/15/2011 Advalorem Taxes169687.1707/19/2011 Advalorem Taxes1746016.1107/21/2011 Advalorem Taxes174620.4607/25/2011 Advalorem Taxes177685.1907/26/2011 Advalorem Taxes177727.5807/28/2011 Advalorem Taxes1782496.50Total57.46365.85 -4,917.48 CR190-000-000-32014Fire Permits/SprinklerBalance Forward-1,200.00CR07/22/2011 Permits 7/22/1117784400.00Total0.00400.00 -1,600.00 CR190-000-000-33050Fire InspectionsBalance Forward-150.00CR07/22/2011 Permits 7/22/111778475.00Total0.0075.00-225.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 CRTrophy Club Municipal Utility Dist #1 Fire DepartmentG/L Transaction Detail Report July 31, 2011TCMUD No. 167 of 93Meeting Date: August 16, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1 Fire DepartmentG/L Transaction Detail Report July 31, 2011190-000-000-35370DonationsBalance Forward0.00Total0.00 0.00 0.00190-000-000-36700Miscellaneous RevenueBalance Forward-1,050.00CR07/20/2011 Permits 7/20/1117782100.0007/22/2011 Permits 7/22/1117784625.00Total0.00725.00 -1,775.00 CR190-000-000-39200Transfer In - General FundBalance Forward0.00Total0.00 0.00 0.00190-045-000-40100Salaries - RegularBalance Forward280,833.3007/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 1743015,577.7407/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 1716415,750.07Total31,327.81 0.00 312,161.11190-045-000-40130Salaries - OvertimeBalance Forward38,862.4607/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 174303,293.39Total3,293.39 0.00 42,155.85190-045-000-40140Salaries - LongevityBalance Forward2,986.99Total0.00 0.00 2,986.99190-045-000-40160Salaries - CertificationBalance Forward6,088.2407/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 17164494.70Total494.70 0.00 6,582.94190-045-000-40180Salaries - Holiday PayBalance Forward12,154.86Total0.00 0.00 12,154.86190-045-000-41200RetirementBalance Forward46,744.5307/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 174302,457.3307/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 171642,061.11Total4,518.44 0.00 51,262.97190-045-000-41210Medical InsuranceBalance Forward36,140.6807/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 174301,949.7007/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 171641,969.96Total3,919.66 0.00 40,060.34190-045-000-41215Dental InsuranceBalance Forward2,202.3207/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 17430121.4007/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 17164122.91Total244.31 0.00 2,446.63190-045-000-41216Vision InsuranceBalance Forward355.8407/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 1743018.7807/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 1716418.99Total37.77 0.00 393.61190-045-000-41218Life Insurance & OtherBalance Forward843.63Total0.00 0.00 843.63TCMUD No. 168 of 93Meeting Date: August 16, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1 Fire DepartmentG/L Transaction Detail Report July 31, 2011190-045-000-42220Social Security TaxesBalance Forward19,755.5207/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 174301,071.3407/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 17164907.50Total1,978.84 0.00 21,734.36190-045-000-42225Medicare TaxesBalance Forward4,623.2907/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 17430250.5607/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 17164212.24Total462.80 0.00 5,086.09190-045-000-42250Unemployment TaxesBalance Forward920.9707/08/2011 Payroll Cycle 14 (06/19 - 07/02/2011) 174302.6507/22/2011 Payroll Cycle 15 (07/03 - 07/16/2011) 1716410.87Total13.52 0.00 934.49190-045-000-42260Workman's CompensationBalance Forward9,348.9607/11/2011 4th Qtr/Workers Comp 16279 TML Intergovernmental Risk 070111 3,116.32Total3,116.32 0.00 12,465.28190-045-000-42290Pre-employment Physicals/TestingBalance Forward195.50Total0.00 0.00 195.50190-045-000-50100Professional Outside ServicesBalance Forward0.00Total0.00 0.00 0.00190-045-000-54100Physicals/TestingBalance Forward0.00Total0.00 0.00 0.00190-045-000-60100Office SuppliesBalance Forward215.63Total0.00 0.00 215.63190-045-000-60300PostageBalance Forward92.26Total0.00 0.00 92.26190-045-000-60400Publications/Books/SubscriptionsBalance Forward0.00Total0.00 0.00 0.00190-045-000-61000FuelBalance Forward7,011.5207/01/2011 May Gas Log 17794706.1607/01/2011 June Gas Log 17796877.94Total1,584.10 0.00 8,595.62190-045-000-62100UniformsBalance Forward3,530.32Total0.00 0.00 3,530.32190-045-000-62150Protective ClothingBalance Forward756.18Total0.00 0.00 756.18190-045-000-62300ChemicalsBalance Forward305.00Total0.00 0.00 305.00TCMUD No. 169 of 93Meeting Date: August 16, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1 Fire DepartmentG/L Transaction Detail Report July 31, 2011190-045-000-72100ElectricityBalance Forward7,845.2507/19/2011 Electricity 6/15-7/15 17350 Star-Tex Power 5836897 1,331.22Total1,331.22 0.00 9,176.47190-045-000-72200WaterBalance Forward401.4107/31/2011 July Water 17914 Trophy Club MUD - Water Bills 073111 43.20Total43.20 0.00 444.61190-045-000-73100TelephoneBalance Forward114.2507/27/2011 Steve Z. 18212 Bank of America 072711 9.95Total9.95 0.00 124.20190-045-000-73200Communications /Pagers/MobilesBalance Forward2,014.6407/22/2011 Cell phones 18218 Verizon Wireless 6609304057 167.7407/27/2011 Pastor 18212 Bank of America 072711 29.55Total197.29 0.00 2,211.93190-045-000-73300AdvertisingBalance Forward0.00Total0.00 0.00 0.00190-045-000-73400PrintingBalance Forward0.00Total0.00 0.00 0.00190-045-000-74100Dues & MembershipBalance Forward6,466.60Total0.00 0.00 6,466.60190-045-000-74200Travel & per diemBalance Forward3,531.41Total0.00 0.00 3,531.41190-045-000-74300Schools & TrainingBalance Forward3,316.95Total0.00 0.00 3,316.95190-045-000-74400Emergency ManagementBalance Forward1,000.00Total0.00 0.00 1,000.00190-045-000-74600MeetingsBalance Forward22.00Total0.00 0.00 22.00190-045-000-75000InsuranceBalance Forward8,714.00Total0.00 0.00 8,714.00190-045-000-77300Fire Inspections/EnforcementBalance Forward205.12Total0.00 0.00 205.12190-045-000-78200Small ToolsBalance Forward4,564.53Total0.00 0.00 4,564.53190-045-000-79200Building Rental/LeaseBalance Forward308,000.00Total0.00 0.00 308,000.00190-045-000-79999Miscellaneous ExpenseBalance Forward205.76Total0.00 0.00 205.76TCMUD No. 170 of 93Meeting Date: August 16, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1 Fire DepartmentG/L Transaction Detail Report July 31, 2011190-045-000-80250Maintenance and RepairsBalance Forward1,952.2807/15/2011 EMW-2007-FO-06597 16737 DHS/FEMA 071511 323.5007/18/2011 CO Sensor, Beam Interrupter brackets 17372Air Technology Solutions of Delaware, LLCR218131,018.00Total1,341.500.00 3,293.78190-045-000-81200Building MaintenanceBalance Forward6,804.6407/16/2011 Cable 7/16-8/15 17498 DIRECTV 15602286746 50.9907/31/2011 Pest control/Fire Station 17878 Gann's Pest Control 073111 110.00Total160.99 0.00 6,965.63190-045-000-81300Vehicle MaintenanceBalance Forward8,458.68Total0.00 0.00 8,458.68190-045-000-81350Equipment MaintenanceBalance Forward521.71Total0.00 0.00 521.71190-045-000-81400Radio MaintenanceBalance Forward465.00Total0.00 0.00 465.00190-045-000-81800Flags & RepairsBalance Forward1,972.50Total0.00 0.00 1,972.50190-045-000-81900Maintenance SuppliesBalance Forward925.60Total0.00 0.00 925.60190-045-000-85000Grant MatchBalance Forward1,308.60Total0.00 0.00 1,308.60190-045-000-87100Programs & Special ProjectsBalance Forward882.8507/06/2011 Photo booth/Fire Station Open House 17924 Party Booths 10028 395.0007/18/2011 Face Painting, Balloon Sculptures/Fire S 17918 Fun Time Entertainment Group, Inc. 11-0827TCLUB 570.0007/28/2011 Slide, Sno Cone Machine/Fire Station Ope 17920 Bay Shay Bounce Houses 072811 225.00Total1,190.00 0.00 2,072.85190-045-000-90100RadiosBalance Forward807.50Total0.00 0.00 807.50190-045-000-90200Fire Engine 681 PaymentBalance Forward5,693.95Total0.00 0.00 5,693.95190-045-000-93200VehiclesBalance Forward4,164.55Total0.00 0.00 4,164.55190-045-000-93600AirpacksBalance Forward0.00Total0.00 0.00 0.00GRAND TOTAL55,706.37 4,970.82 -189,095.94TCMUD No. 171 of 93Meeting Date: August 16, 2011 Municipal Utility District No 1 Fire Station Construction 2010 General Obligation $2M Bond Fund Interim Balance Sheet 10/12 Months (84% of Fiscal Year) Balance @ 7/31/2011 ASSETS ASSETS INVESTMENTS (246,951)$ OTHER RECEIVABLES - TOTAL ASSETS (246,951)$ LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS PAYABLE 101,269$ TOTAL LIABILITIES 101,269 FUND BALANCE DESIGNATED FOR FIRE STATION CONSTRUCTION (348,219) TOTAL LIABILITIES AND FUND BALANCE (246,951)$ * General Fund will transfer to cover expenditures over bond money received. July 31, 2011 TCMUD No. 1 72 of 93 Meeting Date: August 16, 2011 Segments/AccountsYTD BudgetTotal BudgetMTD RevYTD RevYTD VarianceYTD %Total VarianceRemaining %[FUND] 491 : Bond Fund 2010 GO 2M Fire491-000-000-35050 : Interest Income1,295.001,295.000.001,053.58241.4218.64241.4218.64 Grand Total : 1,295.001,295.000.001,053.58241.4218.64241.4218.64User: rgonzalesTrophy Club Municipal Utility Dist #1 Fire ConstructionBudget Revenue ReportTo Date: 07/31/2011Run Date: 08/11/2011TCMUD No. 173 of 93Meeting Date: August 16, 2011 491-045-000-94000 Temporary Housing and Storage 0.00 10,500.00 1,044.27 10,485.52 14.48 99.9 491-045-000-95000 Construction 0.00 1,405,652.00 207,152.43 1,755,035.09 (349,383.09) 124.9 491-045-000-96300 Engineering 0.00 41,000.00 0.00 39,609.75 1,390.25 96.6 Total Fire Department 0.00 1,457,152.00 208,196.70 1,805,130.36 (347,978.36) page 1 Budget to Actual - Fire Const Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 74 of 93 Meeting Date: August 16, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit Balance491-045-000-94000Temporary Housing and StorageBalance Forward9,441.2507/06/2011 Temporary Housing 6/17-7/16 16759 Modular Space Corporation 105860772 845.1007/27/2011 Steve Z. 18212 Bank of America 072711 199.17Total1,044.27 0.00 10,485.52491-045-000-95000ConstructionBalance Forward1,547,882.6607/01/2011 Fire Station App 13 17368 Prime Construction Co App 13 194,867.7507/01/2011 Retainage/Prime App 13 1733410,256.2007/24/2011 Electricity/Fire Station 17348 Hudson Energy 2131623 251.1607/29/2011 7 Articulating Keyboard trays 17894 National Business Furniture, LLC CV754465-ERO 954.6607/29/2011 Metal stools 17896 National Business Furniture, LLC CV755349-KFI 822.66Total207,152.43 0.00 1,755,035.09491-045-000-96100LegalBalance Forward0.00Total0.00 0.00 0.00491-045-000-96300EngineeringBalance Forward39,609.75Total0.00 0.00 39,609.75491-045-000-96500Bond Issuance CostBalance Forward0.00Total0.00 0.00 0.00GRAND TOTAL208,196.70 0.00 1,805,130.36Trophy Club Municipal Utility Dist #1 Fire ConstructionG/L Transaction Detail Report July 31, 2011TCMUD No. 175 of 93Meeting Date: August 16, 2011 Municipal Utility District No 1 - I & S Interim Balance Sheet Balance @ 7/31/2011 ASSETS ASSETS CASH AND CASH IN BANK 46,000$ INVESTMENTS 1,339,322 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 23,329 TOTAL ASSETS 1,408,652$ LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS PAYABLE -$ DEFERRED REVENUE 23,329$ TOTAL LIABILITIES 23,329 FUND BALANCE DESIGNATED FOR DEBT SERVICE 1,385,322 TOTAL LIABILITIES AND FUND BALANCE 1,408,652$ July 31, 2011 10/12 Months 84% of Fiscal Year) TCMUD No. 1 76 of 93 Meeting Date: August 16, 2011 Account/DescriptionYTD BudgetTotal BudgetMTD RevYTD RevYTD VarianceRemaining %[FUND] 680 : Debt Service680-000-000-30100 : Property Taxes755,712.00755,712.002,025.16757,514.31-1,802.31-0.24680-000-000-30125 : Property Taxes/Delinquent0.000.00123.694,395.51-4,395.510.00680-000-000-30150 : Property Taxes/Penalty & Interest9,500.009,500.00164.133,793.095,706.9160.07680-000-000-35050 : Interest Income500.00500.0075.58895.79-395.79-79.16680-000-000-35170 : Building Rent308,000.00308,000.000.00308,000.000.000.00680-000-000-38500 : PID Utility Fees246,100.00246,100.000.00246,100.000.000.00[FUND] SubTotal : 680 : Debt Service1,319,812.001,319,812.002,388.561,320,698.70-886.70-0.07 Grand Total : 1,319,812.001,319,812.002,388.561,320,698.70-886.70-0.07Run Date: 08/11/2011User: rgonzalesTrophy Club Municipal Utility Dist #1 Debt ServiceBudget Revenue ReportTo Date: 07/31/2011TCMUD No. 177 of 93Meeting Date: August 16, 2011 680-680-000-89000 Bond Principal 1,115,000.00 1,115,000.00 0.00 0.00 1,115,000.00 # 680-680-000-89100 Bond Interest 379,559.00 379,559.00 0.00 206,598.55 172,960.45 54.4 680-680-000-89200 Paying Agent Fees 3,500.00 3,500.00 0.00 910.00 2,590.00 26.0 Total Debt Service 1,498,059.00 1,498,059.00 0.00 207,508.55 1,290,550.45 page 1 Budget to Actual -Debt Service Trophy Club Municipal Utility Dist #1 For Period Ending 07/31/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 78 of 93 Meeting Date: August 16, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit Balance680-000-000-30100Property TaxesBalance Forward-755,489.15CR07/06/2011 MUD 1 AV Taxes16689323.8107/08/2011 MUD 1 AV Taxes16715269.8707/11/2011 MUD 1 AV Taxes16733250.9307/11/2011 MUD 1 AV Taxes16691269.8707/11/2011 MUD 1 AV Taxes16713269.8707/12/2011 MUD 1 AV Taxes16735260.7207/13/2011 MUD 1 AV Taxes16801117.4807/15/2011 MUD 1 AV Taxes1696873.6507/18/2011 MUD 1 AV Taxes1713228.4507/19/2011 MUD 1 AV Taxes1746063.0107/22/2011 MUD 1 AV Taxes1777028.0007/25/2011 MUD 1 AV Taxes17768150.8207/26/2011 MUD 1 AV Taxes17772133.2807/27/2011 MUD 1 AV Taxes1777495.9107/28/2011 MUD 1 AV Taxes17824195.9107/29/2011 MUD 1 AV Taxes1782633.32Total269.87 2,295.03 -757,514.31 CR680-000-000-30125Property Taxes/DelinquentBalance Forward-4,271.82CR07/15/2011 Advalorem Taxes1696810.0107/21/2011 Advalorem Taxes174620.8907/26/2011 Advalorem Taxes17772112.79Total0.00123.69 -4,395.51 CR680-000-000-30150Property Taxes/Penalty & InterestBalance Forward-3,628.96CR07/06/2011 Advalorem Taxes1668948.5707/08/2011 Advalorem Taxes1671540.4807/11/2011 Advalorem Taxes167330.7307/11/2011 MUD 1 AV Taxes1669140.4807/11/2011 MUD 1 AV Taxes1671340.4807/12/2011 Advalorem Taxes1673533.3607/13/2011 Advalorem Taxes168010.4107/15/2011 Advalorem Taxes169688.3807/19/2011 Advalorem Taxes1746011.3407/21/2011 Advalorem Taxes174620.3707/25/2011 Advalorem Taxes177683.6507/26/2011 Advalorem Taxes177726.0907/28/2011 Advalorem Taxes1782410.75Total40.48204.61 -3,793.09 CR680-000-000-35050Interest IncomeBalance Forward-820.21CR07/31/2011 July Bank Interst1820275.58Total0.0075.58-895.79 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.00 0.00 0.00680-000-000-37100Prior Year ReservesBalance Forward0.00Total0.00 0.00 0.00Trophy Club Municipal Utility Dist #1 Debt ServiceG/L Transaction Detail Report July 31, 2011TCMUD No. 179 of 93Meeting Date: August 16, 2011 G/L #Effective Date DescriptionJournal # Vendor NameVendor Invoice # Debit Credit BalanceTrophy Club Municipal Utility Dist #1 Debt ServiceG/L Transaction Detail Report July 31, 2011680-000-000-38500PID Utility FeesBalance Forward-246,100.00CRTotal0.00 0.00 -246,100.00 CR680-000-000-39200Transfer In - General FundBalance Forward0.00Total0.00 0.00 0.00680-680-000-89000Bond PrincipalBalance Forward0.00Total0.00 0.00 0.00680-680-000-89100Bond InterestBalance Forward206,598.55Total0.00 0.00 206,598.55680-680-000-89200Paying Agent FeesBalance Forward910.00Total0.00 0.00 910.00GRAND TOTAL310.35 2,698.91 -1,113,190.15TCMUD No. 180 of 93Meeting Date: August 16, 2011 BUDGET VARIANCE REPORT FUND:190 - Fire O&M FINANCIALS MONTH: July 2011 REVENUE VARIANCE: 76% EXPENSE VARIANCE: 92% NOTE: ACCOUNT DESCRIPTION TOTAL BUDGET CURRENT MONTH YTD TOTAL YTD % VARIANCE EXPLANATION FIRE REVENUE 190-000-000-33420 Denton/Tarrant County-Fire 13,750 - 10,000 Interlocal agreement with Tarrant, will not receive payment FIRE EXPENSES 190-045-000-40130 Overtime 40,298$ 3,293$ 42,156$ 105% Covering vacation shifts 190-045-000-40140 Longevity 2,946$ -$ 2,987$ 101% Paid annually in December. 190-045-000-40160 Certification Pay 5,401$ 495$ 6,583$ 122% Firefighters have advanced their certifications 190-045-000-40180 Holiday Pay 11,604$ -$ 12,155$ 105% Paid annually in December 190-045-000-60300 Postage 95$ -$ 92$ 97% Postage meter usage and overnight letter 190-045-000-73100 Telephone 103$ 10$ 124$ 121% Long Distance & faxes 190-045-000-73200 Communications 1,874$ 197$ 2,212$ 118% Cell Phones 190-045-000-74400 Emergency Management 1,000$ -$ 1,000$ 100% Annual payment 190-045-000-79200 Building Rental/Lease 308,000$ -$ 308,000$ 100% One time annual payment after 1/31 taxes have been received 190-045-000-93200 Vehicles 4,183$ -$ 4,165$ 100% Final payment Fire Chief vehicle Explanation provided for all accounts with a Year-To-Date percentage (YTD%) less than the Revenue Variance and greater than or equal to the Expense Variance. The Revenue and Expense Variance is calculated on a straight-line method (Financials Month x 8.3%), less 8.3% for revenues and plus 8.3% for expenses. All variances over $1000 will be addressed. TCMUD No. 1 81 of 93 Meeting Date: August 16, 2011 BUDGET VARIANCE REPORT FUND:180 - MUD 1 O&M FINANCIALS MONTH: July-2011 REVENUE VARIANCE: 76% EXPENSE VARIANCE: 92% NOTE: ACCOUNT DESCRIPTION TOTAL BUDGET CURRENT MONTH YTD TOTAL YTD % VARIANCE EXPLANATION REVENUE 180-000-000-36100 Gas Well Revenue 2,000$ 86$ 765$ 38% Revenue less than anticipated. 180-000-000-38120 Water-Commercial 777,075$ 89,330$ 581,569$ 75% Dependent upon usage, higher usage in summer months. 180-000-000-38140 Portable Meters-Out of District 16,000$ 12,071$ 39,494$ 247% Dependent upon usage. 180-000-000-38220 Sewer-Commercial 300,403$ 32,776$ 233,368$ 78% Dependent upon usage, higher usage in summer months. 180-000-000-38500 PID Utility Fees 167,900$ 69,000$ 80,500$ 48% First 107 connections go to I&S. I&S has received the 107 for this year 180-000-000-38540 Sewer/Septic Dump Fees 48,000$ -$ -$ 0% Stopped for Screen Rake installation 180-000-000-38560 Fire Line Fees 5,000$ -$ 525$ 11% Revenue less than anticipated. 180-000-000-39290 GASB Reserves 54,314$ -$ -$ 0% Used to offset expenses. Will be transferred at a later date. WATER 180-010-000-40130 Salaries-Overtime 8,814$ 1,992$ 12,312$ 140% Based on number of after hours main breaks & reconnects 180-010-000-40140 Salaries-Longevity 2,150$ -$ 2,150$ 100% Paid annually in November. 180-010-000-40160 Salaries-Certification 1,500$ 150$ 1,430$ 95% Dependent on completed certifications and added during the year. 180-010-000-73200 Communications 1,599$ 165$ 1,515$ 95% Cell phones 180-010-000-75200 Annual Permit Fee 6,600$ -$ 6,134$ 93% Annual payment. 180-010-000-78100 Meter Expense 85,000$ -$ 83,182$ 98% Purchase in bulk, upfront. Sold 2" irrigation meter for Fire station 180-010-000-79150 Equipment Rental/Lease 500$ -$ 770$ 154% Crane rental for generator caused overage 180-010-000-93700 Capital Expense 130,932$ -$ 215,853$ 165% Meters and Badger Orion Upgrade. WASTEWATER 180-020-000-40130 Salaries-Overtime 10,166$ 1,396$ 11,442$ 113% Based on number of after hours main breaks & reconnects 180-020-000-40140 Salaries-Longevity 3,483$ -$ 3,483$ 100% Paid annually in November. 180-020-000-73200 Communications 3,000$ 243$ 2,849$ 95% Cell phones 180-020-000-74200 Travel and Per Diem 1,750$ 209$ 1,910$ 109% Based on number of training classes 180-020-000-75200 Annual Permit Fee 7,500$ -$ 10,704$ 143% Annual Permit, and application fee for 4 year permit 180-020-000-78300 Safety Equipment 540$ -$ 658$ 122% Supplies for first aid cabinet COLLECTIONS 180-021-000-40130 Salaries-Overtime 14,145$ 697$ 13,816$ 98% Based on number of after hours main breaks & reconnects 180-021-000-40140 Salaries-Longevity 3,128$ -$ 3,160$ 101% Paid annually in November. 180-021-000-40160 Salaries-Certification 1,200$ 125$ 1,250$ 104% Based on Certification testing. Paid monthly BOARD OF DIRECTORS 180-130-000-87110 Water Conservation/Public Information -$ -$ 2,335$ Water Conservation Program-not budgeted Explanation provided for all accounts with a Year-To-Date percentage (YTD%) less than the Revenue Variance and greater than or equal to the Expense Variance. The Revenue and Expense Variance is calculated on a straight-line method (Financials Month x 8.3%), less 8.3% for revenues and plus 8.3% for expenses. All variances over $1000 will be addressed. TCMUD No. 1 82 of 93 Meeting Date: August 16, 2011 BUDGET VARIANCE REPORT FUND:180 - MUD 1 O&M FINANCIALS MONTH: July-2011 REVENUE VARIANCE: 76% EXPENSE VARIANCE: 92% NOTE: ACCOUNT DESCRIPTION TOTAL BUDGET CURRENT MONTH YTD TOTAL YTD % VARIANCE EXPLANATION Explanation provided for all accounts with a Year-To-Date percentage (YTD%) less than the Revenue Variance and greater than or equal to the Expense Variance. The Revenue and Expense Variance is calculated on a straight-line method (Financials Month x 8.3%), less 8.3% for revenues and plus 8.3% for expenses. All variances over $1000 will be addressed. MANAGER'S OFFICE 180-140-000-40140 Salaries-Longevity 2,580$ -$ 2,755$ 107% Paid annually in November 180-140-000-42290 Pre-employment Physicals/Testing -$ 22$ 75$ 0% Receptionist position 180-140-000-50100 Professional Outside Services 229,076$ -$ 228,076$ 100% Semo Contract with Town-paid in two installments 180-140-000-73200 Communications 1,798$ 158$ 2,327$ 129% Cell phones 180-140-000-73400 Printing 515$ -$ 3,170$ 616% Shared cost with Town/printing of calendars mailed to residents 180-140-000-74100 Dues & Memberships 1,612$ -$ 1,715$ 106% Majority of dues paid in Oct/Nov. 180-140-000-78500 Furniture/Equipment < $5,000 1,750$ 3,406$ 4,081$ 233% MUD share of furniture purchase for remodel FINANCE 180-611-000-40130 Salaries-Overtime 3,500$ 1,048$ 12,043$ 344% Attend MUD meeting, work on budget, and monthly closeout & financial preparation for meeting. Catch up from taking vacation. 180-611-000-40140 Salaries-Longevity 3,128$ -$ 3,160$ 101% Paid annually in November 180-611-000-41215 Dental Insurance 393$ 43$ 407$ 103% Change in family status UTILITY BILLING 180-620-000-40140 Salaries-Longevity 245$ -$ 405$ 165% Paid annually in November, Utility Billing Clerk not budgeted for Longevity in the amount of $160 180-620-000-73600 Service Charges & Fees 18,000$ 1,975$ 18,156$ 101% WorldPay monthly credit card transaction fees. Added second machine for front desk. 180-620-000-75600 TCEQ Annual Assessment Fee 20,000$ -$ 19,248$ 96% Paid annually after calendar year end INFORMATION SERVICES 180-640-000-57000 Independent Labor 1,464$ -$ 2,349$ 160% Outside services 180-640-000-73100 Telephone 8,040$ 803$ 8,779$ 109% expenses related to new phone system FACILITIES MANAGEMENT 180-710-000-81200 Building Maintenance 11,970$ 64$ 13,399$ 112% Air conditioning repair/MUD building NON-DEPARTMENTAL 180-810-000-50200 Auditing 27,500$ -$ 27,500$ 100% Annual Auditing contract TCMUD No. 1 83 of 93 Meeting Date: August 16, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-92-M1 Name: Status:Type:M1 Agenda Item Regular Session File created:In control:8/11/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:8/16/2011 Title:Discuss and take appropriate action regarding the purchase of Municipal Management Software. Attachments:Stw-proposal-revised.pdf Action ByDate Action ResultVer. Title Discuss and take appropriate action regarding the purchase of Municipal Management Software. TCMUD No. 1 84 of 93 Meeting Date: August 16, 2011 Upgrade to STW Version 2.0 with automatic upgrade engine. QTY Estimated Hours Estimated Hourly Charges Purchased Items Estimated Total STW Software Annual Install Spooler, Scheduler, and other updates. Activate software update engine. 24 $ 2,640.00 $ 2,640.00 - $1,250.00 Updates for Base Financials 6 $ 660.00 $ 660.00 - $0.00 Updates for UB and Cash Receipts 6 $ 660.00 $ 660.00 $0.00 Subtotal 36 $ 3,960.00 $ - $ 3,960.00 $ - $1,250.00 Training & Implementation QTY Estimated Estimated Purchased Items Estimated Total STW Software Annual Base Financials 4 $440.00 - $ 440.00 - - Utility Billing & Cash Receipts 6 $660.00 - $ 660.00 - - Fixed Assets 3 $330.00 - $ 330.00 - - Subtotal 13 $1,430.00 $ - $ 1,430.00 $ - - Total 49 $ 5,390.00 $ - $ 5,390.00 $ - $1,250.00 Online Internet Payments and More. QTY Estimated Hours Estimated Hourly Charges Purchased Items Estimated Total STW Software Annual Online UB Customer Information System, and Internet Payments. 28 $ 3,080.00 $ 3,080.00 - $0.00 SSL Certificate.1 0 $ - $400.00 $ 400.00 - $0.00 POS Terminal 1 0 $ - $750.00 $ 750.00 - $0.00 POS Configuration, setup, and enter user training. 4 $ 440.00 $ 440.00 $0.00 Subtotal 32 $ 3,520.00 $1,150.00 $ 4,670.00 $ - $0.00 Subtotal Hardware $1,000.00 $ 1,000.00 $ - $0.00 Email & Ebill related items.QTY Estimated Estimated Purchased Items Estimated Total STW Software Annual Gmail business account.1 50.00 $ 50.00 - $ 50.00 Billing Domain Name 1 10.00 $ 10.00 - $ 10.00 Subtotal 0 $0.00 $ 60.00 $60.00 $ - 60.00 Total 32 $ 3,520.00 $ 2,210.00 $ 5,730.00 $ - $60.00 Reporting Tools QTY Estimated Estimated Purchased Items Estimated Total STW Software Annual Vision Server Software 1 --$3,040.00 $3,040.00 -$608.00 Vision Client 1st User License 1 --$1,190.00 $1,190.00 -$238.00 Impromptu 1 -- Subtotal --$4,230.00 $4,230.00 - $846.00 Training & Implementation QTY Estimated Estimated Purchased Items Estimated Total STW Software Annual STW Vision Installation Services 4.5 $495.00 -$495.00 - - STW Vision Training 16 $1,760.00 -$1,760.00 - - STW Impromptu Installation Services 2.5 $275.00 -$275.00 - - STW Impromptu Training 8 $880.00 -$880.00 - - Payroll Interface $1,000.00 $1,000.00 Subtotal -$4,410.00 -$4,410.00 - - Total -$4,410.00 $4,230.00 $8,640.00 - $846.00 Innoprise GL & AP conversion, just the Mud. 40 $4,400.00 -$4,400.00 - - Grand Total:24,160.00$ ‐$ $2,156.00 Revised & Combined With RFP This eliminates both Axiar and Camelia products whose annual support is $3K. The MUD already has Impromptu. BASIC UPGRADE OnLine Utility Billing Customer Information System and Integrated POS Terminals. REPORTING TOOLS TCMUD No. 1 85 of 93 Meeting Date: August 16, 2011 Stw Application TROPHY CLUB General Ledger 1,325.00 Accounts Payable 1,060.00 Budget 900.00 Payroll - Dropped Utility Billing 1,590.00 Cash Receipts 795.00 Fixed Assets 1,325.00 Purchase Card 1,060.00 Report Dist.1,060.00 Stw Tools 1,250.00 Total 10,365.00$ New Items: email annual $60.00 Reporting Tools:$846.00 Subtotal:$906.00 Grand Total:11,271.00$ Online bill pay will increase fees for Credit Card processing because of more transactions. TCMUD No. 1 86 of 93 Meeting Date: August 16, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-93-M1 Name: Status:Type:M1 Agenda Item Regular Session File created:In control:8/11/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:8/16/2011 Title:Discuss and take appropriate action regarding a governmental water rate for the Town. Attachments: Action ByDate Action ResultVer. Title Discuss and take appropriate action regarding a governmental water rate for the Town. TCMUD No. 1 87 of 93 Meeting Date: August 16, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-94-M1 Name: Status:Type:M1 Agenda Item Regular Session File created:In control:8/11/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:8/16/2011 Title:Discuss and take appropriate action regarding TCMUD No. 1's preliminary draft budget for FY2011- 2012. a. Set preliminary tax rate not to exceed $0.195 per $100 assessed valuation (the 2010 tax rate was $0.195 per $100 assessed valuation) b. Water Rates c. Governmental Accounting Standard Board (GASB) Statement 54 fund balance ranges Attachments: Action ByDate Action ResultVer. Title Discuss and take appropriate action regarding TCMUD No. 1's preliminary draft budget for FY2011-2012. a. Set preliminary tax rate not to exceed $0.195 per $100 assessed valuation (the 2010 tax rate was $0.195 per $100 assessed valuation) b. Water Rates c. Governmental Accounting Standard Board (GASB) Statement 54 fund balance ranges TCMUD No. 1 88 of 93 Meeting Date: August 16, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-95-M1 Name: Status:Type:M1 Agenda Item Regular Session File created:In control:8/11/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:8/16/2011 Title:Set Next Meeting Date: a. September 20, 2011 - 7:00 p.m. - Regular Scheduled Meeting Attachments:September 2011.pdf Action ByDate Action ResultVer. Title Set Next Meeting Date: a. September 20, 2011 - 7:00 p.m. - Regular Scheduled Meeting TCMUD No. 1 89 of 93 Meeting Date: August 16, 2011 18/11/2011 7:22 PMShannon DePraterSMTWT F S1234567891011 12 13 14 15 16 1718 19 20 21 22 23 2425 26 27 28 29 30September 2011SMTWT F S12345678910111213141516 17 18 19 20 21 2223 24 25 26 27 28 2930 31October 2011September 2011MondayTuesdayWednesdayThursdayFridaySat/SunSeptember 110:00amOpen Enrollment (Svore Municipal 2:00pmOpen Enrollment (Svore Municipal 7:00pmP&Z Commission (Council Chambers)7:00pmTCWC (PS Conference Room)234569:00amRoutine Staff Meeting(PS Conference Room)4:00pmPolice Chaplain Meeting (internal) (Police Training R6:00pmJoint Council & P&Z Workhsop (Council 7891011123:00pmCouncil (MUD Bd Rm)6:30pmEDC B (PS Conference Room)139:00amRoutine Staff Meeting(PS Conference Room)7:00pmParks & Recreation Board (Svore Municipal Building Board Room)141:00pmJury Trial (PS Conference Room)1:00pmJury Trial (Svore Municipal Building Boardroom)157:00pmP&Z Commission (Council Chambers)161718196:00pmCouncil (MUD Bd Rm)209:00amRoutine Staff Meeting(PS Conference Room)7:00pmTCMUD No.1 Meeting(Svore Municipal Buildling Board Room)2110:00amEAC (PS Conference Room)12:00pmCOURT (Svore Municipal Building Boardroom)226:00pm Public Safety Advisory Committee (Internal) (Police Dept. Training Room)232425266:00pmCouncil (Council Chambers)279:00amRoutine Staff Meeting(PS Conference Room)4:00pmTBD - ZBA (Svore Municipal Buildling Board Room)7:00pmCitizens Police Academy Alumni 282930TCMUD No. 190 of 93Meeting Date: August 16, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-96-M1 Name: Status:Type:M1 Agenda Item Regular Session File created:In control:8/11/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:8/16/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 91 of 93 Meeting Date: August 16, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-97-M1 Name: Status:Type:M1 Agenda Item Regular Session File created:In control:8/11/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:8/16/2011 Title:PURSUANT TO TEXAS GOVERNMENT CODE, ANNOTATED, SECTION 551.071 (1) & (2) "CONSULTATION WITH ATTORNEY", RESPECTIVELY, THE COUNCIL WILL ENTER INTO CLOSED SESSION TO DISCUSS THE FOLLOWING: A. Consultation with Attorney on Pending or Contemplated Litigation or on a Matter in which the duty of the Attorney to the Governmental Body under the Texas Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflict with the Texas Open Meetings Act: - Anticipated or threatened litigation against the District regarding personnel matters. B. Legal advice regarding the turning off of water where the owner is in bankruptcy. Attachments: Action ByDate Action ResultVer. Title PURSUANT TO TEXAS GOVERNMENT CODE, ANNOTATED, SECTION 551.071 (1) & (2) "CONSULTATION WITH ATTORNEY", RESPECTIVELY, THE COUNCIL WILL ENTER INTO CLOSED SESSION TO DISCUSS THE FOLLOWING: A. Consultation with Attorney on Pending or Contemplated Litigation or on a Matter in which the duty of the Attorney to the Governmental Body under the Texas Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflict with the Texas Open Meetings Act: - Anticipated or threatened litigation against the District regarding personnel matters. B. Legal advice regarding the turning off of water where the owner is in bankruptcy. TCMUD No. 1 92 of 93 Meeting Date: August 16, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-98-M1 Name: Status:Type:M1 Agenda Item Regular Session File created:In control:8/11/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:8/16/2011 Title:Discuss and take appropriate action regarding Executive Session. A. Consultation with Attorney on Pending or Contemplated Litigation or on a Matter in which the duty of the Attorney to the Governmental Body under the Texas Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflict with the Texas Open Meetings Act: - Anticipated or threatened litigation against the District regarding personnel matters. B. Legal advice regarding the turning off of water where the owner is in bankruptcy. Attachments: Action ByDate Action ResultVer. Title Discuss and take appropriate action regarding Executive Session. A. Consultation with Attorney on Pending or Contemplated Litigation or on a Matter in which the duty of the Attorney to the Governmental Body under the Texas Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflict with the Texas Open Meetings Act: - Anticipated or threatened litigation against the District regarding personnel matters. B. Legal advice regarding the turning off of water where the owner is in bankruptcy. TCMUD No. 1 93 of 93 Meeting Date: August 16, 2011