The URL can be used to link to this page

Home My WebLink AboutOctober 18, 2011 Regular Session Agenda PacketTrophy Club Municipal Utility District No. 1 Trophy Club Entities Meeting Agenda 100 Municipal Drive Trophy Club, Texas 76262 Svore Municipal Building Boardroom7:00 PMTuesday, October 18, 2011 Call to order and announce a quorum. Citizen Presentation Citizens are allowed three (3) minutes to address the Board regarding an item over which the Board has policy or oversight authority as provided by Texas law, the ethics order, or other policy order. REGULAR SESSION REPORTS & UPDATES 1.2011-132-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 WWTP Report.pdf combined graphs (version 2).pdf Attachments: 2.2011-133-M1 Receive Finance Update Senior Accountant Gonzales to provide the Board with a monthly update and address the Board’s questions 3.2011-134-M1 Receive Fire Update Fire Chief Thomas to provide the Board with a monthly update and address the Boards questions. Fire Update 9-11.pdfAttachments: 4.2011-135-M1 Receive Town Council Update Council Member Rose to provide the Board with an update of Council meetings, notices and relevant business. 5.2011-136-M1 Receive Town Council Update Update regarding past month’s activities ACTION ITEMS TCMUD No. 1 Page 1 of 101 Meeting Date: October 18, 2011 October 18, 2011Trophy Club Municipal Utility District No. 1 Meeting Agenda 6.2011-137-M1 Discuss and take appropriate action regarding 2011-2012 Rate Order a. Review new water rates from Fort Worth. b. Review residential deposit requirements. 2012 Rate Order Proposed Changes 10-12.pdf Admin Fees for Surrounding Cities 3-5-10 (2).pdf Additional Depsosit (2).pdf Attachments: 7.2011-138-M1 Discuss and take appropriate action on setting a governmental water rate for the Town of Trophy Club for FY2011-2012. 8.2011-141-M1 Review and Approve Monthly Financial Report(s) a. September 2011 Sept 2011 financials.pdfAttachments: 9.2011-143-M1 Discuss and take appropriate action regarding the elevated ground storage tank. To include fencing and all related topics. Sav-on Fence Inc. Quote email.pdf Sav-on Fence Inc. Quote for Elevated Storage Tanks.pdf Attachments: 10.2011-144-M1 Review and Approve Minutes a. September 20, 2011 - Regular Session Minutes 09202011 MUD 1 Meeting Minutes.pdfAttachments: CONVENE INTO CLOSED SESSION 11.2011-139-M1 PURSUANT TO TEXAS GOVERNMENT CODE, ANNOTATED, SECTION 551.071 (1) & (2) "CONSULTATION WITH ATTORNEY", RESPECTIVELY, THE BOARD 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: 1. Legal advice relative to state reporting requirements. RECONVENE INTO REGULAR SESSION 12.2011-140-M1 Discuss and take appropriate action regarding Executive Session Adjourn Notice is hereby given that a quorum of the Town Council may be in attendance at this meeting. TCMUD No. 1 Page 2 of 101 Meeting Date: October 18, 2011 October 18, 2011Trophy Club Municipal Utility District No. 1 Meeting Agenda * THE BOARD RESERVES THE RIGHT TO ADJOURN INTO A CLOSED SESSION AT ANY TIME DURING THE MEETING FOR THE PURPOSE OF SEEKING THE ADVICE OF ITS ATTORNEY ABOUT ANY ITEM ON THE AGENDA OR THAT ARISES AT THE MEETING, PURSUANT TO SECTION 551.071 OF THE TEXAS GOVERNMENT CODE. CERTIFICATION) THE STATE OF TEXAS) COUNTY OF DENTON) COUNTY OF TARRANT) THIS CERTIFIES THAT ON FRIDAY, OCTOBER 14, 2011 BY 5:00PM, A COPY OF THE ABOVE NOTICE OF A MEETING OF THE TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 TO BE HELD ON TUESDAY, OCTOBER 18, 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. ________________________________________ Laurie Slaght, Interim MUD Secretary THIS FACILITY IS WHEELCHAIR ACCESSIBLE AND ACCESSIBLE PARKING SPACES ARE AVAILABLE. REQUESTS FOR ACCOMMODATIONS OR INTERPRETATIVE SERVICES MUST BE MADE 48 HOURS PRIOR TO THIS MEETING. PLEASE CONTACT LAURIE SLAGHT AT (682) 831-4685 OR FAX YOUR REQUEST TO (817) 490-0705. I certify that the attached notice and agenda of items to be considered by this Board was removed by me from the front window of the Svore Municipal Building, 100 Municipal Drive, Trophy Club, Texas, on the __________ day of ______________________, 2011. ________________________________, Title: ___________________________ TCMUD No. 1 Page 3 of 101 Meeting Date: October 18, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-132-M1 Name: Status:Type:M1 Agenda Item Regular Session File created:In control:10/13/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:10/18/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:WWTP Report.pdf combined graphs (version 2).pdf Action ByDate Action ResultVer. Title Receive District Manager's Report a. Water pumped vs. billed b. Monthly WWTP Report c. New Fire Station Construction Costs to date d. Update - Water Plant e. Update - Wastewater Plant TCMUD No. 1 Page 4 of 101 Meeting Date: October 18, 2011 TCMUD No. 1 Page 5 of 101 Meeting Date: October 18, 2011 TCMUD No. 1 Page 6 of 101 Meeting Date: October 18, 2011 Q:\MUD Packets\MUD 1\2011\10-October\combined graphs (version 2).xls October November December January February March April May June July August September Total for year 2006 74,441 56,296 41,272 54,171 37,626 35,714 55,429 60,800 88,899 113,904 122,820 81,806 823,178 2007 73,757 44,297 35,905 31,695 25,671 40,516 43,121 31,204 42,191 43,717 72,462 76,138 560,674 2008 63,250 47,082 33,371 37,194 31,472 30,766 40,313 48,829 78,091 91,664 115,042 75,494 692,568 2009 63,730 48,170 35,215 35,759 32,240 39,331 46,151 37,382 56,370 125,089 91,724 79,137 690,298 2010 39,794 39,713 29,547 30,305 25,328 23,279 41,646 53,439 102,921 89,760 128,687 82,331 686,750 2011 70,502 50,909 44,365 35,983 27,845 55,972 69,165 61,467 99,326 117,707 170,464 123,692 927,397 Totals 385,474 286,467 219,675 225,107 180,182 225,578 295,825 293,121 467,798 464,134 701,199 518,598 4,263,158 October November December January February March April May June July August 79,297 48,609 36,966 32,915 26,974 25,771 31,755 46,747 70,315 69,134 92,539 84,849 51,836 38,869 32,850 24,742 25,111 32,240 47,364 75,755 68,715 82,007 90,400 55,063 40,772 32,785 22,510 24,451 32,726 47,980 81,195 68,296 71,476 95,952 58,290 42,675 32,721 20,278 23,791 33,211 48,597 86,636 67,878 350,497 213,799 159,281 131,271 94,504 99,122 129,932 190,688 313,900 274,022 246,022 Oct.Nov.Dec.Jan Feb.March April May June July August Sept.Total for year 2006 74,585 55,405 42,852 52,100 33,247 39,250 64,455 73,048 93,187 118,353 127,450 76,301 850,233 2007 72,460 49,249 34,203 28,257 31,492 43,900 41,770 37,340 41,215 43,136 75,480 72,087 570,589 2008 64,370 50,090 35,320 36,610 34,630 34,750 42,900 63,116 78,399 114,256 98,670 72,551 725,662 2009 65,110 48,570 36,411 36,587 36,385 44,120 48,881 38,250 66,450 116,823 94,525 81,500 713,612 2010 40,803 41,600 32,700 31,400 30,145 27,240 43,400 62,646 113,049 94,950 131,650 76,159 725,742 2011 70,502 50,993 44,220 33,789 36,053 54,775 71,306 63,500 116,350 152,002 169,621 117,190 980,301 Totals 387,830 295,907 225,706 218,743 201,952 244,035 312,712 337,900 508,650 639,520 697,396 495,788 4,566,139 0 20,000 40,000 60,000 80,000 100,000 120,000 140,000 160,000 180,000 Gallons Months Water Billed 2006 2007 2008 2009 2010 2011 0 20,000 40,000 60,000 80,000 100,000 120,000 140,000 160,000 180,000 1 2 3 4 5 6 7 8 9 10 11 12 Gallons Months Water Pumped 2006 2007 2008 2009 2010 2011 TCMUD No. 1 Page 7 of 101 Meeting Date: October 18, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-133-M1 Name: Status:Type:M2 Agenda Item Regular Session File created:In control:10/13/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:10/18/2011 Title:Receive Finance Update 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 Senior Accountant Gonzales to provide the Board with a monthly update and address the Board’s questions TCMUD No. 1 Page 8 of 101 Meeting Date: October 18, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-134-M1 Name: Status:Type:M1 Agenda Item Regular Session File created:In control:10/13/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:10/18/2011 Title:Receive Fire Update Fire Chief Thomas to provide the Board with a monthly update and address the Boards questions. Attachments:Fire Update 9-11.pdf Action ByDate Action ResultVer. Title Receive Fire Update Fire Chief Thomas to provide the Board with a monthly update and address the Boards questions. TCMUD No. 1 Page 9 of 101 Meeting Date: October 18, 2011 TCMUD No. 1 Page 10 of 101 Meeting Date: October 18, 2011 TCMUD No. 1 Page 11 of 101 Meeting Date: October 18, 2011 TCMUD No. 1 Page 12 of 101 Meeting Date: October 18, 2011 TCMUD No. 1 Page 13 of 101 Meeting Date: October 18, 2011 TCMUD No. 1 Page 14 of 101 Meeting Date: October 18, 2011 TCMUD No. 1 Page 15 of 101 Meeting Date: October 18, 2011 TCMUD No. 1 Page 16 of 101 Meeting Date: October 18, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-135-M1 Name: Status:Type:M1 Agenda Item Regular Session File created:In control:10/13/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:10/18/2011 Title:Receive Town Council Update Council Member Rose to provide the Board with an update of Council meetings, notices and relevant business. Attachments: Action ByDate Action ResultVer. Title Receive Town Council Update Council Member Rose to provide the Board with an update of Council meetings, notices and relevant business. TCMUD No. 1 Page 17 of 101 Meeting Date: October 18, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-136-M1 Name: Status:Type:M1 Agenda Item Regular Session File created:In control:10/13/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:10/18/2011 Title:Receive Town Council Update Update regarding past month’s activities Attachments: Action ByDate Action ResultVer. Title Receive Town Council Update Update regarding past month’s activities TCMUD No. 1 Page 18 of 101 Meeting Date: October 18, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:32011-137-M1 Name: Status:Type:Agenda Item Regular Session File created:In control:10/13/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:10/18/2011 Title:Discuss and take appropriate action regarding 2011-2012 Rate Order. a. Review new water rates from Fort Worth. b. Review residential deposit requirements. Attachments:2012 Rate Order Proposed Changes 10-12.pdf Admin Fees for Surrounding Cities 3-5-10 (2).pdf Additional Depsosit (2).pdf Action ByDate Action ResultVer. Title Discuss and take appropriate action regarding 2011-2012 Rate Order. a. Review new water rates from Fort Worth. b. Review residential deposit requirements. TCMUD No. 1 Page 19 of 101 Meeting Date: October 18, 2011 2011 1.5707 2012 1.7361 Article II Service Rates Section 2.01. Water Service A. Chemically Treated Water 1. Single Family Homes Proposed Changes Basic Charge Fee: Does not include water usage) $12.71 0-6,000 gallons per month $2.48/1000 gallons $2.50 7,000 to 12,000 gallons per month $3.00/1,000 gallons $3.03 13,000 to 25,000 gallons per month $3.23/1,000 gallons $3.27 26,000 to 50,000 gallons per month $3.34/1,000 gallons $3.40 51,000 plus gallons per month $3.44/1,000 gallons $3.48 2011 Rate Order Current and Proposed Changes for 2011-2012 Fort Worth Out of District Rate TCMUD No. 1 Page 20 of 101 Meeting Date: October 18, 2011 Water/Wasterwater Rates for Surrounding Cities as of 3/5/10 Page 1 of 5 Meter Size Water Wastewater Meter Size Water Wastewater 5/8"$18.50 $15.50 All sizes $12.00 $8.60 3/4"$18.50 $15.50 1"$46.25 $38.75 1 1/2"$92.50 $77.50 2"$148.00 $124.00 3"$277.50 $232.50 4"$462.50 $387.50 6"$925.00 $775.00 Usage Water Wastewater 8"$1,480.00 $1,240.00 10"$2,127.50 $1,782.50 0-2,000 2001+$3.48 $2.17 Usage Water Wastewater Usage Water Wastewater 0-5,000 5,000-10,000 $2.56 $3.49 10,001-15,000 $3.20 $3.49 15,000-25,000 $3.84 $3.49 25,000+$4.48 $3.49 Bill for 17,000 gallons 5/8" & 3/4"$87.99 1"$87.99 Bill for 17,000 gallons 5/8" & 3/4"$103.60 1"$179.13 Additional Cost per 1,000 gal. Residential No maximum on sewer.Include in base fee Commercial Sewer is capped at 10k Deposits for commercial customers are same as residential rates. Residential Residential Roanoke Colleyville Monthly Service Fees Monthly Service Fees 817-491-2411 817-503-1020 Include in base fee Additional Cost per 1,000 gal. Sewer calculated on average usage for Dec., Jan., & Feb. Residents w/o history are charged for 7k ($18.75) until history established. Fees for commercial customers are same as residential rates. Fees above includes 2,000 gallons. Commercial Fees above includes 5,000 gallons. Commercial Fees are same as residential above and includes 3,000 gallons. $50 + $2 Non-refundable admininstrative fee. Residential Commercial Deposits Residential Fees for commercial customers are same as residential rates. Comments Fees for commercial customers are same as residential rates. Commercial Commercial No maximum on sewer. Deposits Residential $60 - does not differentiate between Homeowners & Renters Higher base is because it's a bigger meter and the water runs through faster therefore it creates a greater demand. Based on meter size. TCMUD No. 1 Page 21 of 101 Meeting Date: October 18, 2011 Water/Wasterwater Rates for Surrounding Cities as of 3/5/10 Page 2 of 5 Meter Size Water Wastewater Meter Size Water Wastewater 5/8"$25.50 $35.84 1"$26.60 $26.16 3/4"$38.25 $35.84 1" Outside $34.45 $26.16 1"$63.75 $35.84 2"$85.25 $26.16 1 1/2"$127.50 $35.84 2"$204.00 $35.84 3" displacement $382.50 $35.84 3" compound $408.00 $35.84 3" turbine $446.25 $35.84 1"$41.86 $26.16 4" compound $637.50 $35.84 1 1/2"$69.12 $26.16 4" turbine $765.00 $35.84 2"$96.38 $26.16 3"$138.25 $26.16 4"$165.51 $26.16 6"$207.37 $26.16 8"$249.24 $26.16 Usage Water Wastewater Usage Water Wastewater 0-2,000 $2.58 Included in fee 2,001-3,000 $2.58 $2.60 3,001-15,000 $3.06 $2.60 0-3,000 15,001-30,000 $3.76 $2.60 2,001-10,000 $2.97 $3.00 30,00 -50,000 $4.67 $2.60 10,001-25,000 $3.47 $3.00 50,001+$7.15 $2.60 25,001-40,000 $3.72 $3.00 40,000+$4.22 $3.00 Usage Water Wastewater Usage Water Wastewater 2,001+$3.42 0-2,000 2,001-10,000 $2.97 $3.00 10,001-25,000 $3.47 $3.00 25,001-40,000 $3.72 $3.00 40,000+$4.22 $3.00 Bill for 17,000 gallons 5/8" $182.64 3/4"$195.39 1"$209.61 Bill for 17,000 gallons 5/8" no 5/8" 3/4"no 3/4" 1"$150.97 $75 for 5/8" - does not differentiate between Homeowners & Renters. Deposits for 1" are $250 and over 1" is $500. Hydrant meter deposits are $1000 Commercial Same as residential Residential Fees for commercial customers are same as residential rates. Additional Cost per 1,000 gal. * Additional water is included for larger meters. See comment above. Monthly Service FeesMonthly Service Fees Commercial Residential Argyle Southlake 940-464-7713 817-748-8051 Residential Water fees for 1" meters include 2,000 gallons and fees for 2" meter include 7,000 gallons. Sewer fees include 2,000 gallons and maximum charge is $50.16. Commercial No water included in above fees, but 2k gallons included in sewer fee. Include in base fee * Sewer cap of 10,000 gallons. Maximum charge is $50.16. Water fees for 1" meters include 3,000 gallons, 1 1/2" meters include 5,000, 2" meters include 7,000, 3" meters include 10,000, 4" meters include 12,000, 6" meters include 15,000, and 8" meters include 18,000 gallons. Sewer fees include 2,000 gallons. Additional Cost per 1,000 gal. Residential No maximum on sewer. Include in base fee * Commercial Sewer calculated on average usage for Dec., Jan., & Feb. Residents w/o history is charged for 10k ($63.20). Commercial Deposits Deposits Residential Commercial They do not charge a deposit. Deposits for commercial customers are same as residential rates. Residential They do not charge a deposit. Sewer calculated on average usage for Dec., Jan., & Feb. All customers w/o history is charged for 10k ($56.64). TCMUD No. 1 Page 22 of 101 Meeting Date: October 18, 2011 Water/Wasterwater Rates for Surrounding Cities as of 3/5/10 Page 3 of 5 Meter Size Water Wastewater Meter Size Water Wastewater 3/4"$9.75 $7.80 5/8" x 3/4"$20.26 $11.85 1"$28.89 $7.80 3/4"$24.58 $14.70 1 1/2"$61.73 $7.80 1"$28.89 $17.54 2"$97.29 $7.80 1 1/2"$44.88 $21.75 3"$217.67 $7.80 2"$60.87 $25.95 4"$277.85 $7.80 3"$92.87 $38.41 6"$370.87 $7.80 4"$114.10 $56.84 8"$658.13 $7.80 5"$146.09 $84.11 Fire Sprinkler $32.40 6"$178.07 $124.49 7"$199.32 $184.23 8"$224.87 $272.68 Usage Water Wastewater Usage Water Wastewater 0-2,000 2,001+$2.74 $3.26 0-2,000 2,001-10,000 $2.86 $2.69 10,001-20,000 $3.18 $2.69 20,001-25,000 $3.61 $2.69 25,001-40,000 $4.72 $2.69 Usage Water Wastewater 40,000+$5.15 $2.69 0-2,000 2,000+2.74 3.26 Usage Water Wastewater 0-2,000 2,001-10,000 $2.86 $2.69 10,001-20,000 $3.50 $2.69 20,001-25,000 $4.13 $2.69 25,001-40,000 $4.72 $2.69 40,000+$5.15 $2.69 Bill for 17,000 gallons 5/8" no 5/8" 3/4"$94.51 1"$113.65 Bill for 17,000 gallons 5/8" $118.09 3/4"$125.26 1"$132.41 $40.00 $50 - does not differentiate between Homeowners & Renters Commercial Sewer cap of 13,000 gallons. Maximum charge is $35.86 Water fees are same as residential rates.Commercial Fees for commercial customers are same as residential rates. Include in base fee Include in base fee Commercial Residential Residential Grapevine Keller 817-410-3135 817-743-4068 Monthly Service Fees Monthly Service Fees Additional Cost per 1,000 gal. Additional Cost per 1,000 gal. Residential Commercial Fees above includes 2,000 gallons. Include in base fee Fees above includes 2,000 gallons. $11.52 Commercial fees above includes 2,000 gallons. DepositsNo maximum on sewer. Residential Sewer cap of 20,000 gallons. Also billed on Dec., Jan., & Feb. average. Maximum charge is $53.80. Include in base fee Residential No maximum on sewer. Commercial Residential $50 - does not differentiate between Homeowners & Renters Commercial $50 - $250 based on meter size. Usually $250. Deposits TCMUD No. 1 Page 23 of 101 Meeting Date: October 18, 2011 Water/Wasterwater Rates for Surrounding Cities as of 3/5/10 Page 4 of 5 Meter Size Water Wastewater Meter Size Water Wastewater 3/4"$37.50 $30.00 5/8" x 3/4"$23.50 $16.00 1"$65.13 $55.00 1"$39.56 $16.00 1 1/2"$129.87 $105.00 1 1/2"$66.32 $16.00 2"$207.87 $170.00 2"$98.44 $16.00 3"$455.13 $370.00 3"$184.08 $16.00 4"$819.00 $635.00 4"$280.42 $16.00 6"$1,500.00 $1,330.00 6"$548.05 $16.00 8"$2,160.00 $1,910.00 3/4"$25.00 $30.00 1"$25.00 $55.00 1 1/2"$75.00 $105.00 2"$150.00 $170.00 Usage Water Wastewater 3"$450.00 $370.00 4"$1,500.00 $635.00 6"$3,250.00 $1,330.00 0-2,000 8"$4,000.00 $1,910.00 2,001-10,000 $2.72 $3.19 10,001-15,000 $3.40 $3.19 15,001-50,000 $4.08 $3.19 Usage Water Wastewater 50.001+$4.76 $3.19 0-2,000 2,001-20,000 $2.85 $3.21 20,001-40,000 $3.56 $3.21 40,001-400,000 $4.45 $3.21 400,000+$5.57 $3.21 Usage Water Wastewater Bill for 17,000 gallons 5/8" $119.97 3/4"no 3/4" 1"$138.03 Bill for 17,000 gallons 5/8" no 5/8" 3/4"$158.40 1"$211.03 Fees above includes 2,000 gallons. Include in base fee Sewer is no longer capped. Additional Cost per 1,000 gal. Monthly Service Fees Commercial Residential Commercial Flower Mound 972-874-6010 Westlake $75 Monthly Service Fees Residential Fees above includes 2,000 gallons. Deposits Residential $60 - does not differentiate between Homeowners & Renters 817-430-0941 x5717 Same as residential rates. Commercial Residential Commercial Commercial Additional Cost per 1,000 gal. Fees for commercial customers are same as residential rates. Same as residential rates. Sewer calculated on average usage for Dec., Jan., & Feb. Residents w/o history is charged rates above. Not to exceed $33.55 Residential Include in base fee Commercial Two deposits required. Water deposit $75-$2500; Sewer deposit $60-$1200. Both based on meter size. Deposits Residential Based on meter size. 3/4 in. line is $90 for water & $60 for sewer. A 1 in. is $150 for water & 100 for sewer. TCMUD No. 1 Page 24 of 101 Meeting Date: October 18, 2011 Water/Wasterwater Rates for Surrounding Cities as of 3/5/10 Page 5 of 5 Meter Size Water Wastewater Meter Size Water Wastewater 5/8" x 3/4"$25.00 $16.50 5/8" x 3/4"$19.50 $19.50 1"$40.00 $16.50 1"$30.00 $30.00 1 1/2"$95.00 $16.50 1 1/2"$40.00 $40.00 2"$260.00 $16.50 2"$60.00 $60.00 3"$85.00 $85.00 4"$125.00 $125.00 6"$250.00 $250.00 Usage Water Wastewater Usage Water Wastewater 0-1,000 Include in base fee 1,001+$5.50 0-15,000 $2.75 $2.20 2,001+$4.50 15,001-25,000 $3.60 $2.20 25,001+$4.95 $2.20 Usage Water Wastewater 0-15,000 $3.85 $3.30 15,001-25,000 $4.65 $3.30 25,001+$5.65 $3.30 *does not get water from Ft. Worth Bill for 17,000 gallons 5/8" $191.00 3/4"no 3/4" 1"$200.50 Bill for 17,000 gallons 5/8" $124.85 3/4"no 3/4" 1"$145.85 Sewer caps off at 12k for residential connections. ($61.50) 5/8" is $150; 1" is $200; 1.5" is $250; 2" is $450 Justin 940-648-2541 x104 Monthly Service Fees Residential Commercial Residential Fees above include 1k gallons of water for 5/8" meter, 2k for a 1", 10k for a 1&1/4", 20k for 2", and 2k of wastewater. Additional Cost per 1,000 gal. Fees for commercial customers are same as residential but sewer rates are not capped.. Residential $150 unless 65 or orlder, then $50. Commercial Fees for commercial customers are 1.5 times the above rates Additional Cost per 1,000 gal. Commercial Northlake 940-648-3290 Monthly Service Fees Residential Deposits Commercial Commercial Deposits Same as residential rates above, but sewer is not capped. Residential Residential Based on meter size. Most are $75. Commercial Based on meter size. $75 -$500. TCMUD No. 1 Page 25 of 101 Meeting Date: October 18, 2011 Proposed changes to 2011-0721 Rate Order Section 3.02, Billing Procedures, B. Notice and Appeal Additional Deposits: If service is disconnected for non-payment of fees more than one time in any calendar year, each subsequent time thereafter in the same calendar year that service is discontinued, the customer shall pay an additional deposit of $__________ at the time service is restored. Such deposits shall be applied to a customer’s final bill. TCMUD No. 1 Page 26 of 101 Meeting Date: October 18, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-138-M1 Name: Status:Type:M1 Agenda Item Regular Session File created:In control:10/13/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:10/18/2011 Title:Discuss and take appropriate action on setting a governmental water rate for the Town of Trophy Club for FY2011-2012. Attachments: Action ByDate Action ResultVer. Title Discuss and take appropriate action on setting a governmental water rate for the Town of Trophy Club for FY2011-2012. TCMUD No. 1 Page 27 of 101 Meeting Date: October 18, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-141-M1 Name: Status:Type:M1 Agenda Item Regular Session File created:In control:10/13/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:10/18/2011 Title:Review and Approve Monthly Financial Report(s) a. September 2011 Attachments:Sept 2011 financials.pdf Action ByDate Action ResultVer. Title Review and Approve Monthly Financial Report(s) a. September 2011 TCMUD No. 1 Page 28 of 101 Meeting Date: October 18, 2011 Municipal Utility District No 1 - O & M Interim Balance Sheet Balance @ 9/30/2011 ASSETS ASSETS CASH ON HAND 400 CASH IN BANK 569,580 INVESTMENTS 1,988,719 RESTRICTED ASSETS: INVESTMENTS 406,501 PREPAID EXPENSES 7,755 ADVALOREM PROPERTY TAXES RECEIVABLE 1,856 UTILITY AND OTHER ACCOUNTS RECEIVABLE 739,347 TOTAL ASSETS 3,714,158$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 1,856$ ACCOUNTS PAYABLE 669,628 CUSTOMER DEPOSITS 187,087 TOTAL LIABILITIES 858,571 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT 219,414 UNDESIGNATED FUND BALANCE 2,636,174 TOTAL FUND BALANCE 2,855,587 TOTAL LIABILITIES AND FUND BALANCE 3,714,158$ September 30, 2011 12/12 Months (100% of Fiscal Year) TCMUD No. 1 Page 29 of 101 Meeting Date: October 18, 2011 Trophy Club Municipal Utility Dist #1 Budget Revenue Report To Date: 09/30/2011 From Account: 180-000-000-30100 To Account: 180-000-000-39290 Run Date: 10/13/2011 User: rgonzales Segments/Accounts Total Budget MTD Rev.YTD Rev. Total Variance Total % [FUND] 180 : MUD 1 General Fund 180-000-000-30100 : Property Taxes 86,314.00 915.89 87,582.87 -1,268.87 -1.47% 180-000-000-30125 : Property Taxes/Delinquent 0.00 42.86 888.00 -888.00 0.00% 180-000-000-30150 : Property Taxes/Penalty & Interest 0.00 211.43 1,694.46 -1,694.46 0.00% 180-000-000-35050 : Interest Income 2,000.00 359.72 5,459.34 -3,459.34 -172.97% 180-000-000-35150 : Cell Tower Lease Revenue 10,164.00 847.00 10,164.00 0.00 0.00% 180-000-000-35170 : Building Rent 7,000.00 583.33 6,999.96 0.04 0.00% 180-000-000-36100 : Gas Well Revenues 2,000.00 57.08 911.49 1,088.51 54.43% 180-000-000-36400 : Auction Sales 0.00 0.00 202.12 -202.12 0.00% 180-000-000-36500 : Vending Revenue 850.00 0.00 830.81 19.19 2.26% 180-000-000-36700 : Miscellaneous Revenue 14,500.00 254.45 9,615.55 4,884.45 33.69% 180-000-000-36900 : Recovery of Prior Year Expense 0.00 0.00 2,119.00 -2,119.00 0.00% 180-000-000-38100 : Water - Residential 1,709,811.00 253,774.28 2,021,860.74 -312,049.74 -18.25% 180-000-000-38120 : Water - Commercial 777,075.00 117,353.66 860,151.48 -83,076.48 -10.69% 180-000-000-38130 : Water - PID 195,249.00 134,473.31 427,338.43 -232,089.43 -118.87% 180-000-000-38140 : Portable Meters - Out of District 16,000.00 12,038.32 57,848.99 -41,848.99 -261.56% 180-000-000-38200 : Sewer - Residential 1,098,146.00 114,662.34 1,144,665.30 -46,519.30 -4.24% 180-000-000-38220 : Sewer - Commercial 300,403.00 31,833.93 294,124.05 6,278.95 2.09% 180-000-000-38230 : Sewer - PID 74,364.00 41,441.91 189,663.14 -115,299.14 -155.05% 180-000-000-38240 : Sewer - Out of District 10,000.00 2,088.63 17,970.88 -7,970.88 -79.71% 180-000-000-38250 : TCCC Effluent Charges 47,500.00 14,907.69 74,430.98 -26,930.98 -56.70% 180-000-000-38300 : Standby 0.00 66.00 733.60 -733.60 0.00% 180-000-000-38320 : Penalties 50,000.00 6,212.70 47,399.14 2,600.86 5.20% 180-000-000-38340 : Service Charges 17,500.00 1,653.00 15,342.42 2,157.58 12.33% 180-000-000-38360 : Penalities - Out of District 500.00 0.00 270.19 229.81 45.96% 180-000-000-38400 : Plumbing Inspections 0.00 50.00 1,950.00 -1,950.00 0.00% 180-000-000-38420 : Sewer Inspections 3,000.00 150.00 5,850.00 -2,850.00 -95.00% 180-000-000-38500 : PID Utility Fees 167,900.00 57,500.00 165,600.00 2,300.00 1.37% 180-000-000-38540 : Sewer/Septic Dump Fees 48,000.00 0.00 0.00 48,000.00 100.00% PAGE 1 TCMUD No. 1 Page 30 of 101 Meeting Date: October 18, 2011 Segments/Accounts Total Budget MTD Rev.YTD Rev. Total Variance Total % 180-000-000-38560 : Fire Line Fees 5,000.00 0.00 525.00 4,475.00 89.50% 180-000-000-38600 : Oversize Meter Reimbursements 50,000.00 7,592.00 70,594.29 -20,594.29 -41.19% 180-000-000-39290 : Transfer In - Future Replacement Reserve 54,314.00 0.00 0.00 54,314.00 100.00% [FUND] SubTotal : 180 : MUD 1 General Fund 4,747,590.00 799,069.53 5,522,786.23 -775,196.23 -16.33% Grand Total :4,747,590.00 799,069.53 5,522,786.23 -775,196.23 -16.33% PAGE 2 TCMUD No. 1 Page 31 of 101 Meeting Date: October 18, 2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-010-000-40100 Salaries - Regular 165,718.00 165,718.00 18,439.53 140,927.86 24,790.14 85.0 180-010-000-40130 Salaries - Overtime 8,814.00 8,814.00 3,192.40 18,465.29 (9,651.29) 209.5 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,730.00 (230.00) 115.3 180-010-000-41200 Retirement 24,945.00 24,945.00 3,084.31 23,152.84 1,792.16 92.8 180-010-000-41210 Medical Insurance 27,748.00 27,748.00 2,144.12 23,889.76 3,858.24 86.1 180-010-000-41215 Dental Insurance 1,446.00 1,446.00 127.46 1,319.84 126.16 91.3 180-010-000-41216 Vision Insurance 269.00 269.00 22.38 235.76 33.24 87.6 180-010-000-41218 Life Insurance & Other 1,177.00 1,177.00 0.00 313.00 864.00 26.6 180-010-000-42220 Social Security Taxes 10,994.00 10,994.00 1,295.45 9,629.86 1,364.14 87.6 180-010-000-42225 Medicare Taxes 2,571.00 2,571.00 302.96 2,252.14 318.86 87.6 180-010-000-42250 Unemployment Taxes 720.00 720.00 0.00 329.40 390.60 45.7 180-010-000-42260 Workman's Compensation 7,764.00 7,764.00 0.00 7,368.69 395.31 94.9 180-010-000-42290 Pre-employment Physicals/Testing 200.00 200.00 0.00 0.00 200.00 # 180-010-000-42960 Employee Relations 350.00 350.00 77.68 303.72 46.28 86.8 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 360.00 4,004.00 (154.00) 104.0 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 252,534.95 1,413,693.12 (3,693.12) 100.3 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,197.72 12,291.46 2,924.54 80.8 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 1,789.83 5,316.73 883.27 85.8 180-010-000-72100 Electricity/Gas 175,000.00 175,000.00 23,883.86 165,809.99 9,190.01 94.7 180-010-000-73200 Communications /Pagers/Mobiles 1,599.00 1,599.00 322.67 1,837.80 (238.80) 114.9 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 172.00 233.00 (83.00) 155.3 180-010-000-74200 Travel & per diem 3,200.00 3,200.00 554.46 1,780.24 1,419.76 55.6 180-010-000-74300 Schools & Training 2,800.00 2,800.00 154.50 2,087.50 712.50 74.6 180-010-000-74700 Safety Program 500.00 500.00 77.76 84.93 415.07 17.0 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 86,563.89 (1,563.89) 101.8 180-010-000-78200 Small Tools 2,500.00 2,500.00 0.00 3,969.48 (1,469.48) 158.8 180-010-000-78300 Safety Equipment 2,500.00 2,500.00 0.00 229.92 2,270.08 9.2 180-010-000-78500 Furniture/Equipment<$5,000 1,500.00 1,500.00 0.00 0.00 1,500.00 # 180-010-000-78600 Hardware 1,000.00 1,000.00 0.00 0.00 1,000.00 # 180-010-000-79150 Equipment Rental/Lease 500.00 500.00 0.00 770.00 (270.00) 154.0 180-010-000-79400 Bad Debt Expense 4,200.00 4,200.00 0.00 2,172.73 2,027.27 51.7 page 1 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/2011 TCMUD No. 1 Page 32 of 101 Meeting Date: October 18, 2011 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 19,688.01 30,974.14 (1,474.14) 105.0 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 504.00 1,800.85 2,399.15 42.9 180-010-000-81200 Building Maintenance 750.00 750.00 0.00 0.00 750.00 # 180-010-000-81300 Vehicle Maintenance 3,380.00 3,380.00 1,571.79 4,572.65 (1,192.65) 135.3 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 1,568.84 13,991.37 18,008.63 43.7 180-010-000-91000 Capital Lease 11,490.00 11,490.00 0.00 10,627.13 862.87 92.5 180-010-000-93700 Capital Expenses 130,932.00 286,911.00 0.00 329,620.76 (42,709.76) 114.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-99100 Transfer to General Fund 0.00 0.00 0.00 0.00 0.00 # 180-010-000-99500 Transfer to Future Replacement Reserve 30,000.00 30,000.00 0.00 30,000.00 0.00 100.0 Total Water 2,367,044.00 2,523,023.00 333,216.68 2,460,351.81 62,671.19 page 2 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/2011 TCMUD No. 1 Page 33 of 101 Meeting Date: October 18, 2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-020-000-40100 Salaries - Regular 176,791.00 176,791.00 20,404.80 173,519.75 3,271.25 98.1 180-020-000-40130 Salaries - Overtime 10,166.00 10,166.00 1,963.15 14,666.35 (4,500.35) 144.3 180-020-000-40140 Salaries - Longevity 3,483.00 3,483.00 0.00 3,482.50 0.50 100.0 180-020-000-40160 Salaries - Certification 2,550.00 2,550.00 200.00 2,375.00 175.00 93.1 180-020-000-41200 Retirement 27,019.00 27,019.00 3,195.62 27,431.91 (412.91) 101.5 180-020-000-41210 Medical Insurance 37,298.00 37,298.00 2,785.32 36,209.41 1,088.59 97.1 180-020-000-41215 Dental Insurance 1,983.00 1,983.00 154.98 1,844.31 138.69 93.0 180-020-000-41216 Vision Insurance 341.00 341.00 29.76 357.12 (16.12) 104.7 180-020-000-41218 Life Insurance & Other 1,237.00 1,237.00 0.00 444.77 792.23 36.0 180-020-000-42220 Social Security Taxes 10,504.00 10,504.00 1,256.18 10,486.05 17.95 99.8 180-020-000-42225 Medicare Taxes 2,457.00 2,457.00 293.78 2,452.38 4.62 99.8 180-020-000-42250 Unemployment Taxes 720.00 720.00 0.00 434.45 285.55 60.3 180-020-000-42260 Workman's Compensation 8,410.00 8,410.00 0.00 7,981.82 428.18 94.9 180-020-000-42960 Employee Relations 250.00 250.00 0.00 151.88 98.12 60.8 180-020-000-50500 Engineering 4,000.00 4,000.00 0.00 2,800.00 1,200.00 70.0 180-020-000-52400 Lab Analysis 18,750.00 18,750.00 3,841.00 15,969.25 2,780.75 85.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 65.50 334.50 16.4 180-020-000-60300 Postage 120.00 120.00 0.00 0.00 120.00 # 180-020-000-60400 Publications/Books/Subscriptions 500.00 500.00 0.00 0.00 500.00 # 180-020-000-61000 Fuel 6,875.00 6,875.00 488.70 3,637.26 3,237.74 52.9 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 900.00 5,077.39 7,922.61 39.1 180-020-000-62800 Lab Supplies 6,085.00 6,085.00 96.50 4,217.05 1,867.95 69.3 180-020-000-62900 Other Consumables 110.00 110.00 0.00 50.14 59.86 45.6 180-020-000-72100 Electricity/Gas 205,000.00 205,000.00 16,543.56 199,125.06 5,874.94 97.1 180-020-000-72200 Water 1,900.00 1,900.00 61.74 1,350.58 549.42 71.1 180-020-000-72400 Dumpster Services 35,000.00 35,000.00 2,607.43 16,677.43 18,322.57 47.6 180-020-000-73100 Telephone 0.00 10.00 0.00 10.20 (0.20) 102.0 180-020-000-73200 Communications /Pagers/Mobiles 3,000.00 3,000.00 475.16 3,323.72 (323.72) 110.8 180-020-000-74200 Travel & per diem 1,750.00 1,750.00 325.23 2,415.83 (665.83) 138.0 180-020-000-74300 Schools & Training 1,320.00 1,320.00 210.00 1,110.00 210.00 84.1 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 646.15 613.85 51.3 180-020-000-78300 Safety Equipment 540.00 540.00 0.00 704.36 (164.36) 130.4 180-020-000-78600 Hardware 525.00 525.00 0.00 35.81 489.19 6.8 180-020-000-79150 Equipment Rental/Lease 200.00 200.00 0.00 0.00 200.00 # 180-020-000-79999 Miscellaneous Expense 525.00 515.00 275.00 275.00 240.00 53.4 180-020-000-80250 Maintenance and Repairs 17,750.00 17,750.00 2,745.14 14,579.87 3,170.13 82.1 180-020-000-81100 Property Maintenance 0.00 0.00 0.00 0.00 0.00 # page 3 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/2011 TCMUD No. 1 Page 34 of 101 Meeting Date: October 18, 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 24.99 1,441.09 3,556.91 28.8 180-020-000-81360 Maintenance - Backhoe/Skid Loader 2,950.00 2,950.00 1,837.43 2,964.19 (14.19) 100.5 180-020-000-81500 Lawn Maintenance 525.00 525.00 60.98 156.88 368.12 29.9 180-020-000-81900 Maintenance Supplies 5,860.00 5,860.00 488.15 1,424.98 4,435.02 24.3 180-020-000-93700 Capital Expenses 136,189.00 136,189.00 0.00 124,550.39 11,638.61 91.5 180-020-000-97000 Capital Repairs 35,000.00 35,000.00 0.00 1,500.00 33,500.00 4.3 Total Wastewater 799,396.00 799,396.00 61,264.60 698,106.32 101,289.68 page 4 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/2011 TCMUD No. 1 Page 35 of 101 Meeting Date: October 18, 2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-021-000-40100 Salaries - Regular 136,341.00 136,341.00 15,778.08 134,033.76 2,307.24 98.3 180-021-000-40130 Salaries - Overtime 14,145.00 14,145.00 2,601.36 19,179.27 (5,034.27) 135.6 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,500.00 (300.00) 125.0 180-021-000-41200 Retirement 21,674.00 21,674.00 2,620.22 22,296.80 (622.80) 102.9 180-021-000-41210 Medical Insurance 28,228.00 28,228.00 1,978.38 25,152.60 3,075.40 89.1 180-021-000-41215 Dental Insurance 1,426.00 1,426.00 118.88 1,367.45 58.55 95.9 180-021-000-41216 Vision Insurance 253.00 253.00 19.86 230.28 22.72 91.0 180-021-000-41218 Life Insurance & Other 942.00 942.00 0.00 339.73 602.27 36.1 180-021-000-42220 Social Security Taxes 8,769.00 8,769.00 1,064.14 9,022.84 (253.84) 102.9 180-021-000-42225 Medicare Taxes 2,051.00 2,051.00 248.87 2,112.69 (61.69) 103.0 180-021-000-42250 Unemployment Taxes 540.00 540.00 0.00 333.23 206.77 61.7 180-021-000-42260 Workman's Compensation 4,412.00 4,412.00 0.00 4,187.36 224.64 94.9 180-021-000-42960 Employee Relations 250.00 250.00 0.00 191.59 58.41 76.6 180-021-000-50500 Engineering 1,500.00 1,500.00 0.00 80.14 1,419.86 5.3 180-021-000-57000 Independent Labor 200.00 200.00 0.00 0.00 200.00 # 180-021-000-60300 Postage 150.00 150.00 0.00 0.00 150.00 # 180-021-000-61000 Fuel 11,700.00 11,700.00 813.78 11,198.28 501.72 95.7 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 2,846.00 9,654.00 22.8 180-021-000-72100 Electricity/Gas 23,625.00 23,625.00 1,657.94 18,579.58 5,045.42 78.6 180-021-000-72200 Water 750.00 750.00 0.00 0.00 750.00 # 180-021-000-73100 Telephone 0.00 0.00 0.00 22.26 (22.26) # 180-021-000-73200 Communications /Pagers/Mobiles 2,796.00 2,796.00 386.38 2,719.29 76.71 97.3 180-021-000-74100 Dues & Membership 255.00 255.00 0.00 172.00 83.00 67.5 180-021-000-74200 Travel & per diem 1,500.00 1,500.00 77.70 743.04 756.96 49.5 180-021-000-74300 Schools & Training 2,818.00 2,818.00 0.00 55.00 2,763.00 2.0 180-021-000-74700 Safety Program 750.00 750.00 0.00 7.18 742.82 1.0 180-021-000-78200 Small Tools 1,500.00 1,500.00 0.00 220.58 1,279.42 14.7 180-021-000-78300 Safety Equipment 1,150.00 1,150.00 0.00 62.84 1,087.16 5.5 180-021-000-78600 Hardware 750.00 750.00 0.00 0.00 750.00 # 180-021-000-79150 Equipment Rental/Lease 44,107.00 44,107.00 0.00 0.00 44,107.00 # 180-021-000-79999 Miscellaneous Expense 100.00 100.00 0.00 0.00 100.00 # 180-021-000-80250 Maintenance and Repairs 23,700.00 23,700.00 0.00 4,175.22 19,524.78 17.6 180-021-000-81100 Property Maintenance 1,000.00 1,000.00 0.00 0.00 1,000.00 # 180-021-000-81200 Building Maintenance 750.00 750.00 0.00 0.00 750.00 # 180-021-000-81300 Vehicle Maintenance 8,143.00 8,143.00 945.06 6,786.43 1,356.57 83.3 180-021-000-81900 Maintenance Supplies 16,050.00 16,050.00 149.42 2,278.96 13,771.04 14.2 180-021-000-93700 Capital Expenses 15,000.00 15,000.00 0.00 10,979.25 4,020.75 73.2 180-021-000-97000 Capital Repairs 20,000.00 20,000.00 11,461.00 11,461.00 8,539.00 57.3 page 5 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/2011 TCMUD No. 1 Page 36 of 101 Meeting Date: October 18, 2011 Total Collection 416,658.00 416,658.00 40,046.07 296,355.40 120,302.60 page 6 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/2011 TCMUD No. 1 Page 37 of 101 Meeting Date: October 18, 2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-130-000-40100 Salaries - Regular 10,000.00 10,000.00 1,300.00 7,700.00 2,300.00 77.0 180-130-000-42220 Social Security Taxes 620.00 620.00 80.60 477.40 142.60 77.0 180-130-000-42225 Medicare Taxes 145.00 145.00 18.85 111.65 33.35 77.0 180-130-000-42250 Unemployment Taxes 210.00 210.00 10.40 85.00 125.00 40.5 180-130-000-42260 Workman's Compensation 120.00 120.00 0.00 113.88 6.12 94.9 180-130-000-50100 Professional Outside Services 0.00 0.00 0.00 0.00 0.00 # 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-73300 Advertising 0.00 0.00 0.00 0.00 0.00 # 180-130-000-73400 Printing 0.00 0.00 0.00 0.00 0.00 # 180-130-000-74100 Dues & Membership 2,100.00 2,100.00 0.00 79.00 2,021.00 3.8 180-130-000-74200 Travel & per diem 5,805.00 5,805.00 0.00 968.26 4,836.74 16.7 180-130-000-74300 Schools & Training 4,000.00 4,000.00 0.00 2,140.00 1,860.00 53.5 180-130-000-74600 Meetings 1,278.00 1,278.00 22.00 348.00 930.00 27.2 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,431.85 14,356.05 10,171.95 page 7 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/2011 TCMUD No. 1 Page 38 of 101 Meeting Date: October 18, 2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-140-000-40100 Salaries - Regular 214,374.00 214,374.00 19,762.40 203,361.80 11,012.20 94.9 180-140-000-40130 Salaries - Overtime 500.00 500.00 14.63 307.52 192.48 61.5 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 2,785.80 28,491.37 1,868.63 93.8 180-140-000-41210 Medical Insurance 17,925.00 17,925.00 1,389.86 18,451.64 (526.64) 102.9 180-140-000-41215 Dental Insurance 930.00 930.00 77.11 950.82 (20.82) 102.2 180-140-000-41216 Vision Insurance 179.00 179.00 14.77 177.60 1.40 99.2 180-140-000-41218 Life Insurance & Other 1,205.00 1,205.00 0.00 390.74 814.26 32.4 180-140-000-42220 Social Security Taxes 13,474.00 13,474.00 1,175.78 12,669.82 804.18 94.0 180-140-000-42225 Medicare Taxes 3,151.00 3,151.00 274.99 2,986.81 164.19 94.8 180-140-000-42250 Unemployment Taxes 630.00 630.00 15.68 483.22 146.78 76.7 180-140-000-42260 Workman's Compensation 783.00 783.00 0.00 743.12 39.88 94.9 180-140-000-42290 Pre-employment Physicals/Testing 0.00 0.00 0.00 82.17 (82.17) # 180-140-000-42960 Employee Relations 1,000.00 1,000.00 29.99 938.66 61.34 93.9 180-140-000-50100 Professional Outside Services 229,076.00 229,076.00 0.00 228,075.63 1,000.37 99.6 180-140-000-52100 Elections 2,500.00 2,500.00 980.48 2,933.13 (433.13) 117.3 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 37.50 444.37 395.63 52.9 180-140-000-60100 Office Supplies 2,450.00 2,450.00 30.11 1,536.11 913.89 62.7 180-140-000-60300 Postage 1,571.00 1,571.00 98.44 2,269.75 (698.75) 144.5 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 0.00 215.15 (15.15) 107.6 180-140-000-73200 Communications /Pagers/Mobiles 1,798.00 1,798.00 233.30 2,616.25 (818.25) 145.5 180-140-000-73300 Advertising 1,500.00 1,500.00 0.00 0.00 1,500.00 # 180-140-000-73400 Printing 515.00 515.00 0.00 3,170.00 (2,655.00) 615.5 180-140-000-73600 Service Charges & Fees 0.00 0.00 0.00 32.50 (32.50) # 180-140-000-74100 Dues & Membership 1,612.00 1,612.00 348.90 2,518.40 (906.40) 156.2 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 2,260.84 294.16 88.5 180-140-000-74600 Meetings 312.00 312.00 53.74 237.57 74.43 76.1 180-140-000-76700 July 4 Celebration 10,000.00 10,000.00 0.00 10,000.00 0.00 100.0 180-140-000-78500 Furniture/Equipment<$5,000 1,750.00 1,750.00 0.00 4,081.30 (2,331.30) 233.2 180-140-000-79999 Miscellaneous Expense 100.00 100.00 0.00 10.06 89.94 10.1 Total Managers Office 547,908.00 547,908.00 27,323.48 534,727.76 13,180.24 page 8 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/2011 TCMUD No. 1 Page 39 of 101 Meeting Date: October 18, 2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-611-000-40100 Salaries - Regular 70,839.00 70,839.00 8,174.40 68,545.96 2,293.04 96.8 180-611-000-40130 Salaries - Overtime 3,500.00 3,500.00 1,633.86 14,347.46 (10,847.46) 409.9 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 1,388.85 12,061.24 (1,414.24) 113.3 180-611-000-41210 Medical Insurance 8,583.00 8,583.00 715.24 9,047.47 (464.47) 105.4 180-611-000-41215 Dental Insurance 393.00 393.00 43.06 495.84 (102.84) 126.2 180-611-000-41216 Vision Insurance 75.00 75.00 4.98 59.76 15.24 79.7 180-611-000-41218 Life Insurance & Other 424.00 424.00 0.00 146.23 277.77 34.5 180-611-000-42220 Social Security Taxes 4,697.00 4,697.00 547.65 4,673.02 23.98 99.5 180-611-000-42225 Medicare Taxes 1,099.00 1,099.00 128.08 1,092.89 6.11 99.4 180-611-000-42250 Unemployment Taxes 180.00 180.00 0.00 129.59 50.41 72.0 180-611-000-42260 Workman's Compensation 274.00 274.00 0.00 260.04 13.96 94.9 180-611-000-42290 Pre-employment Physicals/Testing 0.00 0.00 0.00 0.00 0.00 # 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 36.42 532.07 67.93 88.7 180-611-000-60300 Postage 500.00 500.00 31.24 394.71 105.29 78.9 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 0.00 16.19 83.81 16.2 180-611-000-73200 Communications /Pagers/Mobiles 670.00 670.00 103.02 664.00 6.00 99.1 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 117.00 296.00 28.3 180-611-000-74200 Travel & per diem 1,547.00 1,547.00 5.77 157.95 1,389.05 10.2 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 22.00 47.00 41.00 53.4 180-611-000-78500 Furniture/Equipment<$5,000 0.00 0.00 0.00 0.00 0.00 # 180-611-000-79999 Miscellaneous Expense 0.00 0.00 0.00 0.00 0.00 # Total Finance 113,706.00 113,706.00 12,834.57 117,452.32 (3,746.32) page 9 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/2011 TCMUD No. 1 Page 40 of 101 Meeting Date: October 18, 2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-620-000-40100 Salaries - Regular 112,537.00 112,537.00 11,477.45 91,546.27 20,990.73 81.3 180-620-000-40130 Salaries - Overtime 1,500.00 1,500.00 312.18 1,341.52 158.48 89.4 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,669.45 12,704.77 3,294.23 79.4 180-620-000-41210 Medical Insurance 21,773.00 21,773.00 1,614.45 18,002.68 3,770.32 82.7 180-620-000-41215 Dental Insurance 1,136.00 1,136.00 104.89 1,112.47 23.53 97.9 180-620-000-41216 Vision Insurance 209.00 209.00 18.52 196.43 12.57 94.0 180-620-000-41218 Life Insurance & Other 800.00 800.00 0.00 260.31 539.69 32.5 180-620-000-42220 Social Security Taxes 7,029.00 7,029.00 666.15 5,448.21 1,580.79 77.5 180-620-000-42225 Medicare Taxes 1,644.00 1,644.00 155.78 1,274.17 369.83 77.5 180-620-000-42250 Unemployment Taxes 540.00 540.00 14.88 425.35 114.65 78.8 180-620-000-42260 Workman's Compensation 411.00 411.00 0.00 390.08 20.92 94.9 180-620-000-42290 Pre-employment Physicals/Testing 0.00 0.00 0.00 30.23 (30.23) # 180-620-000-56200 Utility Billing Contract 11,000.00 11,000.00 1,964.17 10,805.05 194.95 98.2 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 112.74 617.17 82.83 88.2 180-620-000-60300 Postage 18,000.00 18,000.00 2,765.39 15,924.14 2,075.86 88.5 180-620-000-73100 Telephone 100.00 100.00 0.00 105.78 (5.78) 105.8 180-620-000-73200 Communications /Pagers/Mobiles 472.00 472.00 70.73 481.09 (9.09) 101.9 180-620-000-73400 Printing 3,000.00 3,000.00 0.00 2,152.00 848.00 71.7 180-620-000-73600 Service Charges & Fees 18,000.00 18,000.00 2,513.25 23,024.60 (5,024.60) 127.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 61.61 116.68 488.32 19.3 180-620-000-74300 Schools & Training 800.00 800.00 0.00 46.44 753.56 5.8 180-620-000-75600 TCEQ Annual Assessment Fee 20,000.00 20,000.00 0.00 19,248.17 751.83 96.2 180-620-000-79999 Miscellaneous Expense 200.00 200.00 0.00 1.84 198.16 0.9 180-620-000-99100 Transfer to General Fund 0.00 0.00 0.00 0.00 0.00 # Total Utility Billing 237,571.00 237,571.00 23,521.64 205,660.45 31,910.55 page 10 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/2011 TCMUD No. 1 Page 41 of 101 Meeting Date: October 18, 2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 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 13.90 640.62 1,147.38 35.8 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-73200 Communications /Pagers/Mobiles 0.00 0.00 0.00 0.00 0.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 # 180-630-000-99100 Transfer to General Fund 0.00 0.00 0.00 0.00 0.00 # Total Human Resources 6,945.00 6,945.00 13.90 867.68 6,077.32 page 11 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/2011 TCMUD No. 1 Page 42 of 101 Meeting Date: October 18, 2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-640-000-50700 Security 1,350.00 1,350.00 89.00 276.75 1,073.25 20.5 180-640-000-55000 Software & Support 50,453.00 50,453.00 3,481.49 53,706.43 (3,253.43) 106.4 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 31.52 301.55 69.45 81.3 180-640-000-60200 Printer Supplies 5,732.00 5,732.00 51.99 6,804.95 (1,072.95) 118.7 180-640-000-73100 Telephone 8,040.00 8,040.00 1,674.71 11,270.04 (3,230.04) 140.2 180-640-000-73200 Communications /Pagers/Mobiles 0.00 0.00 0.00 0.00 0.00 # 180-640-000-74200 Travel & per diem 0.00 0.00 0.00 16.18 (16.18) # 180-640-000-75900 Prompt Payment Interest 0.00 0.00 0.00 14.53 (14.53) # 180-640-000-78600 Hardware 60,152.00 60,152.00 1,366.45 40,111.54 20,040.46 66.7 180-640-000-79100 Copier Rental/Lease 3,450.00 3,450.00 273.29 3,006.19 443.81 87.1 180-640-000-99100 Transfer to General Fund 0.00 0.00 0.00 0.00 0.00 # 180-640-000-99500 Transfer to Future Replacement Reserve 26,911.00 26,911.00 0.00 26,911.00 0.00 100.0 Total Information Services 157,923.00 157,923.00 6,968.45 144,767.91 13,155.09 page 12 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/2011 TCMUD No. 1 Page 43 of 101 Meeting Date: October 18, 2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 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 223.82 653.10 346.90 65.3 180-710-000-72100 Electricity/Gas 20,895.00 20,895.00 1,288.18 13,679.47 7,215.53 65.5 180-710-000-72200 Water 1,061.00 1,061.00 358.95 919.36 141.64 86.7 180-710-000-75000 Insurance 31,081.00 31,081.00 0.00 23,575.81 7,505.19 75.9 180-710-000-79200 Building Rental/Lease 13,182.00 13,182.00 1,098.51 13,182.12 (0.12) 100.0 180-710-000-81200 Building Maintenance 11,970.00 11,970.00 49.94 13,496.38 (1,526.38) 112.8 180-710-000-81600 Cleaning Services 9,450.00 9,450.00 826.53 8,368.16 1,081.84 88.6 180-710-000-81900 Maintenance Supplies 2,100.00 2,100.00 210.55 1,891.29 208.71 90.1 180-710-000-93300 Equipment 0.00 0.00 0.00 0.00 0.00 # Total Facilities Maintenance 90,739.00 90,739.00 4,056.48 76,934.44 13,804.56 page 13 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/2011 TCMUD No. 1 Page 44 of 101 Meeting Date: October 18, 2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 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 1,543.00 41,370.61 (6,370.61) 118.2 180-810-000-51100 Appraisal 20,211.00 20,211.00 0.00 12,269.68 7,941.32 60.7 180-810-000-51150 Tax Administration 3,603.00 3,603.00 0.00 2,696.56 906.44 74.8 180-810-000-99510 Transfer to Fire Construction Fund 0.00 0.00 309,158.99 581,877.64 (581,877.64) # Total Non Departmental 86,314.00 86,314.00 310,701.99 665,714.49 (579,400.49) Total Expenses 4,848,732.00 5,004,711.00 821,379.71 5,215,294.63 (210,583.63) page 14 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/2011 TCMUD No. 1 Page 45 of 101 Meeting Date: October 18, 2011 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance 180-010-000-40100 Salaries - Regular Balance Forward 122,488.33 09/02/2011 Payroll 09/2/11 20782 6,143.86 09/16/2011 Payroll 09/16/11 22279 6,136.81 09/30/2011 Payroll 09/30/11 22281 6,158.86 Total 18,439.53 0.00 140,927.86 180-010-000-40130 Salaries - Overtime Balance Forward 15,272.89 09/02/2011 Payroll 09/2/11 20782 550.40 09/16/2011 Payroll 09/16/11 22279 636.46 09/30/2011 Payroll 09/30/11 22281 2,005.54 Total 3,192.40 0.00 18,465.29 180-010-000-40140 Salaries - Longevity Balance Forward 2,150.00 Total 0.00 0.00 2,150.00 180-010-000-40160 Salaries - Certification Balance Forward 1,580.00 09/16/2011 Payroll 09/16/11 22279 150.00 Total 150.00 0.00 1,730.00 180-010-000-41200 Retirement Balance Forward 20,068.53 09/02/2011 Payroll 09/2/11 20782 947.91 09/16/2011 Payroll 09/16/11 22279 980.33 09/30/2011 Payroll 09/30/11 22281 1,156.07 Total 3,084.31 0.00 23,152.84 180-010-000-41210 Medical Insurance Balance Forward 21,745.64 09/02/2011 Payroll 09/2/11 20782 1,072.06 09/16/2011 Payroll 09/16/11 22279 1,072.06 Total 2,144.12 0.00 23,889.76 180-010-000-41215 Dental Insurance Balance Forward 1,192.38 09/02/2011 Payroll 09/2/11 20782 63.73 09/16/2011 Payroll 09/16/11 22279 63.73 Total 127.46 0.00 1,319.84 180-010-000-41216 Vision Insurance Balance Forward 213.38 09/02/2011 Payroll 09/2/11 20782 11.19 09/16/2011 Payroll 09/16/11 22279 11.19 Total 22.38 0.00 235.76 180-010-000-41218 Life Insurance & Other Balance Forward 313.00 Total 0.00 0.00 313.00 180-010-000-42220 Social Security Taxes Balance Forward 8,334.41 09/02/2011 Payroll 09/2/11 20782 387.53 09/16/2011 Payroll 09/16/11 22279 401.74 09/30/2011 Payroll 09/30/11 22281 506.18 Total 1,295.45 0.00 9,629.86 Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 TCMUD No. 1 Page 46 of 101 Meeting Date: October 18, 2011 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 180-010-000-42225 Medicare Taxes Balance Forward 1,949.18 09/02/2011 Payroll 09/2/11 20782 90.62 09/16/2011 Payroll 09/16/11 22279 93.96 09/30/2011 Payroll 09/30/11 22281 118.38 Total 302.96 0.00 2,252.14 180-010-000-42250 Unemployment Taxes Balance Forward 329.40 Total 0.00 0.00 329.40 180-010-000-42260 Workman's Compensation Balance Forward 7,368.69 Total 0.00 0.00 7,368.69 180-010-000-42290 Pre-employment Physicals/Testing Balance Forward 0.00 Total 0.00 0.00 0.00 180-010-000-42960 Employee Relations Balance Forward 226.04 09/01/2011 Adrian Womack 20148 JP Morgan Chase Bank NA 08062011 10.26 09/01/2011 Robert Scott 20148 JP Morgan Chase Bank NA 08062011 67.42 Total 77.68 0.00 303.72 180-010-000-50500 Engineering Balance Forward 80.15 Total 0.00 0.00 80.15 180-010-000-52400 Lab Analysis Balance Forward 3,644.00 09/01/2011 Lab analysis/August 20890 Tarrant County Public Health Lab 21146 180.00 09/30/2011 Water analysis 21869 Tarrant County Public Health Lab 21240 180.00 Total 360.00 0.00 4,004.00 180-010-000-57000 Independent Labor Balance Forward 0.00 Total 0.00 0.00 0.00 180-010-000-58000 Bulk Water Balance Forward 1,161,158.17 09/01/2011 August Bulk Water 21278 City of Fort Worth 083111 252,534.95 Total 252,534.95 0.00 1,413,693.12 180-010-000-60300 Postage Balance Forward 13.35 Total 0.00 0.00 13.35 180-010-000-60400 Publications/Books/Subscriptions Balance Forward 0.00 Total 0.00 0.00 0.00 180-010-000-61000 Fuel Balance Forward 11,093.74 09/30/2011 September gas log 22145 1,197.72 Total 1,197.72 0.00 12,291.46 180-010-000-62100 Uniforms Balance Forward 1,882.87 Total 0.00 0.00 1,882.87 TCMUD No. 1 Page 47 of 101 Meeting Date: October 18, 2011 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 180-010-000-62300 Chemicals Balance Forward 3,526.90 09/01/2011 Adrian Womack 20148 JP Morgan Chase Bank NA 08062011 436.69 09/30/2011 Womack 22259 JP Morgan Chase Bank NA 100511 1,040.88 09/30/2011 Slaght 22255 JP Morgan Chase Bank NA 092611 312.26 Total 1,789.83 0.00 5,316.73 180-010-000-72100 Electricity/Gas Balance Forward 141,926.13 09/09/2011 Electricity 8/2-9/1 20854 Tri County Electric 2309888001 0911 27.73 09/14/2011 Electricity 8/15-9/14 21851 Hudson Energy 2319809 625.19 09/16/2011 Electricity 8/15-9/14 21853 Hudson Energy 17005 23,230.94 Total 23,883.86 0.00 165,809.99 180-010-000-73200 Communications /Pagers/Mobiles Balance Forward 1,515.13 09/21/2011 Cells 20864 Verizon Wireless 090611 161.29 09/22/2011 Cell phones 21875 Verizon Wireless 6635092635 161.38 Total 322.67 0.00 1,837.80 180-010-000-73350 Copies Balance Forward 0.00 Total 0.00 0.00 0.00 180-010-000-73400 Printing Balance Forward 0.00 Total 0.00 0.00 0.00 180-010-000-74100 Dues & Membership Balance Forward 61.00 09/14/2011 CDL License/Holt 20514 Lance Holt 090911 61.00 09/30/2011 Slaght 22259 JP Morgan Chase Bank NA 100511 111.00 Total 172.00 0.00 233.00 180-010-000-74200 Travel & per diem Balance Forward 1,225.78 09/02/2011 Payroll 09/2/11 20782 380.73 09/16/2011 Payroll 09/16/11 22279 48.85 09/30/2011 Payroll 09/30/11 22281 124.88 Total 554.46 0.00 1,780.24 180-010-000-74300 Schools & Training Balance Forward 1,933.00 09/01/2011 Adrian Womack 20148 JP Morgan Chase Bank NA 08062011 404.50 09/21/2011 TEEX/L Holt Refund 22111 250.00 Total 404.50 250.00 2,087.50 180-010-000-74700 Safety Program Balance Forward 7.17 09/30/2011 Slaght 22255 JP Morgan Chase Bank NA 092611 77.76 Total 77.76 0.00 84.93 180-010-000-75200 Annual Permit Fee Balance Forward 6,133.95 Total 0.00 0.00 6,133.95 180-010-000-78100 Meter Expense Balance Forward 86,563.89 Total 0.00 0.00 86,563.89 TCMUD No. 1 Page 48 of 101 Meeting Date: October 18, 2011 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 180-010-000-78200 Small Tools Balance Forward 3,969.48 Total 0.00 0.00 3,969.48 180-010-000-78300 Safety Equipment Balance Forward 229.92 Total 0.00 0.00 229.92 180-010-000-78500 Furniture/Equipment<$5,000 Balance Forward 0.00 Total 0.00 0.00 0.00 180-010-000-78600 Hardware Balance Forward 0.00 Total 0.00 0.00 0.00 180-010-000-79150 Equipment Rental/Lease Balance Forward 770.00 Total 0.00 0.00 770.00 180-010-000-79400 Bad Debt Expense Balance Forward 2,172.73 Total 0.00 0.00 2,172.73 180-010-000-79999 Miscellaneous Expense Balance Forward 0.00 Total 0.00 0.00 0.00 180-010-000-80250 Maintenance and Repairs Balance Forward 11,286.13 09/01/2011 Adrian Womack 20148 JP Morgan Chase Bank NA 08062011 144.94 09/21/2011 VFD Purchase and installation 21843 DHS Automation,Inc 06-890 19,500.00 09/30/2011 McMahon 22259 JP Morgan Chase Bank NA 100511 4.97 09/30/2011 McMahon 22255 JP Morgan Chase Bank NA 092611 38.10 Total 19,688.01 0.00 30,974.14 180-010-000-80300 Non-routine Maintenance Balance Forward 0.00 Total 0.00 0.00 0.00 180-010-000-81100 Property Maintenance Balance Forward 1,296.85 09/01/2011 Adrian Womack 20148 JP Morgan Chase Bank NA 08062011 216.00 09/30/2011 Womack 22255 JP Morgan Chase Bank NA 092611 36.00 09/30/2011 Womack 22255 JP Morgan Chase Bank NA 092611 108.00 09/30/2011 Womack 22259 JP Morgan Chase Bank NA 100511 108.00 09/30/2011 Womack 22259 JP Morgan Chase Bank NA 100511 36.00 Total 504.00 0.00 1,800.85 180-010-000-81200 Building Maintenance Balance Forward 0.00 Total 0.00 0.00 0.00 180-010-000-81300 Vehicle Maintenance Balance Forward 3,000.86 09/01/2011 Adrian Womack 20148 JP Morgan Chase Bank NA 08062011 968.34 09/16/2011 Petty cash reimbursement 20840 Trophy Club MUD Petty Cash 091611 53.64 09/30/2011 LAMP BULB 21877 Roanoke Auto Supply, LTD 685267 4.08 09/30/2011 Womack 22259 JP Morgan Chase Bank NA 100511 39.75 TCMUD No. 1 Page 49 of 101 Meeting Date: October 18, 2011 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 09/30/2011 Womack 22255 JP Morgan Chase Bank NA 092611 137.00 09/30/2011 Womack 22255 JP Morgan Chase Bank NA 092611 368.98 Total 1,571.79 0.00 4,572.65 180-010-000-81360 Maintenance - Backhoe/Skid Loader Balance Forward 0.00 Total 0.00 0.00 0.00 180-010-000-81500 Lawn Maintenance Balance Forward 0.00 Total 0.00 0.00 0.00 180-010-000-81900 Maintenance Supplies Balance Forward 12,422.53 09/01/2011 August Charges 20856 Costco Wholesale 082611 42.72 09/01/2011 Adrian Womack 20148 JP Morgan Chase Bank NA 08062011 767.88 09/06/2011 Superior Water Signs 21387 Dallas Lite & Barricade 211700 62.32 09/26/2011 September purchases 21841 Costco Wholesale 092611 45.87 09/30/2011 Womack 22255 JP Morgan Chase Bank NA 092611 456.80 09/30/2011 McMahon 22259 JP Morgan Chase Bank NA 100511 193.25 Total 1,568.84 0.00 13,991.37 180-010-000-91000 Capital Lease Balance Forward 10,627.13 Total 0.00 0.00 10,627.13 180-010-000-93700 Capital Expenses Balance Forward 329,620.76 Total 0.00 0.00 329,620.76 180-010-000-97000 Capital Repairs Balance Forward 0.00 Total 0.00 0.00 0.00 180-010-000-97100 Capital Repairs - Ground Storage Balance Forward 97,741.64 Total 0.00 0.00 97,741.64 180-010-000-99100 Transfer to General Fund Balance Forward 0.00 Total 0.00 0.00 0.00 180-010-000-99500 Transfer to Future Replacement Reserve Balance Forward 30,000.00 Total 0.00 0.00 30,000.00 180-020-000-40100 Salaries - Regular Balance Forward 153,114.95 09/02/2011 Payroll 09/2/11 20782 6,801.60 09/16/2011 Payroll 09/16/11 22279 6,801.60 09/30/2011 Payroll 09/30/11 22281 6,801.60 Total 20,404.80 0.00 173,519.75 180-020-000-40130 Salaries - Overtime Balance Forward 12,703.20 09/02/2011 Payroll 09/2/11 20782 731.32 09/16/2011 Payroll 09/16/11 22279 470.03 09/30/2011 Payroll 09/30/11 22281 761.80 Total 1,963.15 0.00 14,666.35 TCMUD No. 1 Page 50 of 101 Meeting Date: October 18, 2011 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 180-020-000-40140 Salaries - Longevity Balance Forward 3,482.50 Total 0.00 0.00 3,482.50 180-020-000-40160 Salaries - Certification Balance Forward 2,175.00 09/16/2011 Payroll 09/16/11 22279 200.00 Total 200.00 0.00 2,375.00 180-020-000-41200 Retirement Balance Forward 24,236.29 09/02/2011 Payroll 09/2/11 20782 1,066.66 09/16/2011 Payroll 09/16/11 22279 1,057.98 09/30/2011 Payroll 09/30/11 22281 1,070.98 Total 3,195.62 0.00 27,431.91 180-020-000-41210 Medical Insurance Balance Forward 33,424.09 09/02/2011 Payroll 09/2/11 20782 1,392.66 09/16/2011 Payroll 09/16/11 22279 1,392.66 Total 2,785.32 0.00 36,209.41 180-020-000-41215 Dental Insurance Balance Forward 1,689.33 09/02/2011 Payroll 09/2/11 20782 77.49 09/16/2011 Payroll 09/16/11 22279 77.49 Total 154.98 0.00 1,844.31 180-020-000-41216 Vision Insurance Balance Forward 327.36 09/02/2011 Payroll 09/2/11 20782 14.88 09/16/2011 Payroll 09/16/11 22279 14.88 Total 29.76 0.00 357.12 180-020-000-41218 Life Insurance & Other Balance Forward 444.77 Total 0.00 0.00 444.77 180-020-000-42220 Social Security Taxes Balance Forward 9,229.87 09/02/2011 Payroll 09/2/11 20782 395.52 09/16/2011 Payroll 09/16/11 22279 391.73 09/30/2011 Payroll 09/30/11 22281 468.93 Total 1,256.18 0.00 10,486.05 180-020-000-42225 Medicare Taxes Balance Forward 2,158.60 09/02/2011 Payroll 09/2/11 20782 92.49 09/16/2011 Payroll 09/16/11 22279 91.62 09/30/2011 Payroll 09/30/11 22281 109.67 Total 293.78 0.00 2,452.38 180-020-000-42250 Unemployment Taxes Balance Forward 434.45 Total 0.00 0.00 434.45 180-020-000-42260 Workman's Compensation Balance Forward 7,981.82 TCMUD No. 1 Page 51 of 101 Meeting Date: October 18, 2011 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 Total 0.00 0.00 7,981.82 180-020-000-42960 Employee Relations Balance Forward 151.88 Total 0.00 0.00 151.88 180-020-000-50500 Engineering Balance Forward 2,800.00 Total 0.00 0.00 2,800.00 180-020-000-52400 Lab Analysis Balance Forward 12,128.25 09/01/2011 Adrian Womack 20148 JP Morgan Chase Bank NA 08062011 2,046.50 09/30/2011 Slaght 22255 JP Morgan Chase Bank NA 092611 1,794.50 Total 3,841.00 0.00 15,969.25 180-020-000-57000 Independent Labor Balance Forward 0.00 Total 0.00 0.00 0.00 180-020-000-60100 Office Supplies Balance Forward 65.50 Total 0.00 0.00 65.50 180-020-000-60300 Postage Balance Forward 0.00 Total 0.00 0.00 0.00 180-020-000-60400 Publications/Books/Subscriptions Balance Forward 0.00 Total 0.00 0.00 0.00 180-020-000-61000 Fuel Balance Forward 3,148.56 09/30/2011 September gas log 22145 488.70 Total 488.70 0.00 3,637.26 180-020-000-62100 Uniforms Balance Forward 1,449.17 Total 0.00 0.00 1,449.17 180-020-000-62300 Chemicals Balance Forward 4,177.39 09/01/2011 Rodney Greenwood 20148 JP Morgan Chase Bank NA 08062011 900.00 Total 900.00 0.00 5,077.39 180-020-000-62800 Lab Supplies Balance Forward 4,120.55 09/30/2011 Greenwood 22255 JP Morgan Chase Bank NA 092611 42.62 09/30/2011 Greenwood 22259 JP Morgan Chase Bank NA 100511 53.88 Total 96.50 0.00 4,217.05 180-020-000-62900 Other Consumables Balance Forward 50.14 Total 0.00 0.00 50.14 180-020-000-72100 Electricity/Gas Balance Forward 182,581.50 09/19/2011 Electricity 8/15-9/14 21855 Hudson Energy 17017 16,543.56 Total 16,543.56 0.00 199,125.06 TCMUD No. 1 Page 52 of 101 Meeting Date: October 18, 2011 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 180-020-000-72200 Water Balance Forward 1,288.84 09/21/2011 August water 20904 Trophy Club MUD - Water Bills 083111 61.74 Total 61.74 0.00 1,350.58 180-020-000-72400 Dumpster Services Balance Forward 14,070.00 09/01/2011 Renae Gonzales 20148 JP Morgan Chase Bank NA 08062011 63.25 09/01/2011 Dumpster service for new barscreen 20838 Star Waste Equipment Sales, LLC 5689 1,305.00 09/10/2011 WW Dumpster service 21280 L.H. Chaney Materials, Inc 37267 537.50 09/24/2011 Bludge haul off 21879 L.H. Chaney Materials, Inc 38349 537.50 09/30/2011 Slaght 22255 JP Morgan Chase Bank NA 092611 164.18 Total 2,607.43 0.00 16,677.43 180-020-000-73100 Telephone Balance Forward 10.20 Total 0.00 0.00 10.20 180-020-000-73200 Communications /Pagers/Mobiles Balance Forward 2,848.56 09/21/2011 Cells 20864 Verizon Wireless 090611 236.83 09/22/2011 Cell phones 21875 Verizon Wireless 6635092635 238.33 Total 475.16 0.00 3,323.72 180-020-000-74200 Travel & per diem Balance Forward 2,090.60 09/02/2011 Payroll 09/2/11 20782 104.34 09/16/2011 Payroll 09/16/11 22279 93.24 09/30/2011 Payroll 09/30/11 22281 127.65 Total 325.23 0.00 2,415.83 180-020-000-74300 Schools & Training Balance Forward 900.00 09/30/2011 Slaght 22255 JP Morgan Chase Bank NA 092611 210.00 Total 210.00 0.00 1,110.00 180-020-000-74700 Safety Program Balance Forward 7.18 Total 0.00 0.00 7.18 180-020-000-75200 Annual Permit Fee Balance Forward 10,704.14 Total 0.00 0.00 10,704.14 180-020-000-78200 Small Tools Balance Forward 646.15 Total 0.00 0.00 646.15 180-020-000-78300 Safety Equipment Balance Forward 704.36 Total 0.00 0.00 704.36 180-020-000-78600 Hardware Balance Forward 35.81 Total 0.00 0.00 35.81 180-020-000-79150 Equipment Rental/Lease Balance Forward 0.00 Total 0.00 0.00 0.00 TCMUD No. 1 Page 53 of 101 Meeting Date: October 18, 2011 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 180-020-000-79999 Miscellaneous Expense Balance Forward 0.00 09/06/2011 Annual Lab equipment inspection 20836 Instrumentation Engineers 8741 275.00 Total 275.00 0.00 275.00 180-020-000-80250 Maintenance and Repairs Balance Forward 11,834.73 09/01/2011 Jeff Richey 20148 JP Morgan Chase Bank NA 08062011 6.65 09/01/2011 Rodney Greenwood 20148 JP Morgan Chase Bank NA 08062011 783.91 09/01/2011 Repaired #2 New RAS Pump 20866 C & P Pump Services, Inc 22743 1,793.00 09/30/2011 Greenwood 22259 JP Morgan Chase Bank NA 100511 174.88 Total 2,751.79 6.65 14,579.87 180-020-000-81100 Property Maintenance Balance Forward 0.00 Total 0.00 0.00 0.00 180-020-000-81200 Building Maintenance Balance Forward 0.00 Total 0.00 0.00 0.00 180-020-000-81300 Vehicle Maintenance Balance Forward 1,416.10 09/30/2011 Greenwood 22255 JP Morgan Chase Bank NA 092611 24.99 Total 24.99 0.00 1,441.09 180-020-000-81360 Maintenance - Backhoe/Skid Loader Balance Forward 1,126.76 09/30/2011 Backhoe repair 21857 Landmark Equipment - Ft Worth WF10838-01 1,837.43 Total 1,837.43 0.00 2,964.19 180-020-000-81500 Lawn Maintenance Balance Forward 95.90 09/01/2011 Rodney Greenwood 20148 JP Morgan Chase Bank NA 08062011 60.98 Total 60.98 0.00 156.88 180-020-000-81900 Maintenance Supplies Balance Forward 936.83 09/26/2011 September purchases 21841 Costco Wholesale 092611 165.59 09/30/2011 Greenwood 22259 JP Morgan Chase Bank NA 100511 39.97 09/30/2011 Greenwood 22259 JP Morgan Chase Bank NA 100511 282.59 Total 488.15 0.00 1,424.98 180-020-000-93700 Capital Expenses Balance Forward 124,550.39 Total 0.00 0.00 124,550.39 180-020-000-97000 Capital Repairs Balance Forward 1,500.00 Total 0.00 0.00 1,500.00 180-021-000-40100 Salaries - Regular Balance Forward 118,255.68 09/02/2011 Payroll 09/2/11 20782 5,259.36 09/16/2011 Payroll 09/16/11 22279 5,259.36 09/30/2011 Payroll 09/30/11 22281 5,259.36 Total 15,778.08 0.00 134,033.76 180-021-000-40130 Salaries - Overtime Balance Forward 16,577.91 TCMUD No. 1 Page 54 of 101 Meeting Date: October 18, 2011 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 09/02/2011 Payroll 09/2/11 20782 487.23 09/16/2011 Payroll 09/16/11 22279 677.62 09/30/2011 Payroll 09/30/11 22281 1,436.51 Total 2,601.36 0.00 19,179.27 180-021-000-40140 Salaries - Longevity Balance Forward 3,160.00 Total 0.00 0.00 3,160.00 180-021-000-40160 Salaries - Certification Balance Forward 1,375.00 09/16/2011 Payroll 09/16/11 22279 125.00 Total 125.00 0.00 1,500.00 180-021-000-41200 Retirement Balance Forward 19,676.58 09/02/2011 Payroll 09/2/11 20782 813.71 09/16/2011 Payroll 09/16/11 22279 858.38 09/30/2011 Payroll 09/30/11 22281 948.13 Total 2,620.22 0.00 22,296.80 180-021-000-41210 Medical Insurance Balance Forward 23,174.22 09/02/2011 Payroll 09/2/11 20782 989.19 09/16/2011 Payroll 09/16/11 22279 989.19 Total 1,978.38 0.00 25,152.60 180-021-000-41215 Dental Insurance Balance Forward 1,248.57 09/02/2011 Payroll 09/2/11 20782 59.44 09/16/2011 Payroll 09/16/11 22279 59.44 Total 118.88 0.00 1,367.45 180-021-000-41216 Vision Insurance Balance Forward 210.42 09/02/2011 Payroll 09/2/11 20782 9.93 09/16/2011 Payroll 09/16/11 22279 9.93 Total 19.86 0.00 230.28 180-021-000-41218 Life Insurance & Other Balance Forward 339.73 Total 0.00 0.00 339.73 180-021-000-42220 Social Security Taxes Balance Forward 7,958.70 09/02/2011 Payroll 09/2/11 20782 314.71 09/16/2011 Payroll 09/16/11 22279 334.28 09/30/2011 Payroll 09/30/11 22281 415.15 Total 1,064.14 0.00 9,022.84 180-021-000-42225 Medicare Taxes Balance Forward 1,863.82 09/02/2011 Payroll 09/2/11 20782 73.60 09/16/2011 Payroll 09/16/11 22279 78.19 09/30/2011 Payroll 09/30/11 22281 97.08 Total 248.87 0.00 2,112.69 180-021-000-42250 Unemployment Taxes Balance Forward 333.23 TCMUD No. 1 Page 55 of 101 Meeting Date: October 18, 2011 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 Total 0.00 0.00 333.23 180-021-000-42260 Workman's Compensation Balance Forward 4,187.36 Total 0.00 0.00 4,187.36 180-021-000-42960 Employee Relations Balance Forward 191.59 Total 0.00 0.00 191.59 180-021-000-50500 Engineering Balance Forward 80.14 Total 0.00 0.00 80.14 180-021-000-57000 Independent Labor Balance Forward 0.00 Total 0.00 0.00 0.00 180-021-000-60300 Postage Balance Forward 0.00 Total 0.00 0.00 0.00 180-021-000-61000 Fuel Balance Forward 10,384.50 09/30/2011 September gas log 22145 813.78 Total 813.78 0.00 11,198.28 180-021-000-62100 Uniforms Balance Forward 860.75 Total 0.00 0.00 860.75 180-021-000-62300 Chemicals Balance Forward 2,846.00 Total 0.00 0.00 2,846.00 180-021-000-72100 Electricity/Gas Balance Forward 16,921.64 09/02/2011 Electricity 8/2-9/2 20850 Tri County Electric 2009888001 323.22 09/09/2011 Electricity 8/2-9/1 20852 Tri County Electric 2209888001 0911 172.50 09/15/2011 Electricity 8/13-9/14 21288 Hudson Energy 16986 710.54 09/19/2011 Electricity 8/15-9/14 21855 Hudson Energy 17017 451.68 Total 1,657.94 0.00 18,579.58 180-021-000-72200 Water Balance Forward 0.00 Total 0.00 0.00 0.00 180-021-000-73100 Telephone Balance Forward 22.26 Total 0.00 0.00 22.26 180-021-000-73200 Communications /Pagers/Mobiles Balance Forward 2,332.91 09/21/2011 Cells 20864 Verizon Wireless 090611 181.65 09/22/2011 Cell phones 21875 Verizon Wireless 6635092635 204.73 Total 386.38 0.00 2,719.29 180-021-000-74100 Dues & Membership Balance Forward 172.00 Total 0.00 0.00 172.00 TCMUD No. 1 Page 56 of 101 Meeting Date: October 18, 2011 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 180-021-000-74200 Travel & per diem Balance Forward 665.34 09/02/2011 Payroll 09/2/11 20782 6.66 09/16/2011 Payroll 09/16/11 22279 67.71 09/30/2011 Payroll 09/30/11 22281 3.33 Total 77.70 0.00 743.04 180-021-000-74300 Schools & Training Balance Forward 55.00 Total 0.00 0.00 55.00 180-021-000-74700 Safety Program Balance Forward 7.18 Total 0.00 0.00 7.18 180-021-000-78200 Small Tools Balance Forward 220.58 Total 0.00 0.00 220.58 180-021-000-78300 Safety Equipment Balance Forward 62.84 Total 0.00 0.00 62.84 180-021-000-78600 Hardware Balance Forward 0.00 Total 0.00 0.00 0.00 180-021-000-79150 Equipment Rental/Lease Balance Forward 0.00 Total 0.00 0.00 0.00 180-021-000-79999 Miscellaneous Expense Balance Forward 0.00 Total 0.00 0.00 0.00 180-021-000-80250 Maintenance and Repairs Balance Forward 4,175.22 Total 0.00 0.00 4,175.22 180-021-000-81100 Property Maintenance Balance Forward 0.00 Total 0.00 0.00 0.00 180-021-000-81200 Building Maintenance Balance Forward 0.00 Total 0.00 0.00 0.00 180-021-000-81300 Vehicle Maintenance Balance Forward 5,841.37 09/30/2011 Womack 22255 JP Morgan Chase Bank NA 092611 945.06 Total 945.06 0.00 6,786.43 180-021-000-81900 Maintenance Supplies Balance Forward 2,129.54 09/01/2011 August Charges 20856 Costco Wholesale 082611 85.74 09/30/2011 Slaght 22255 JP Morgan Chase Bank NA 092611 63.68 Total 149.42 0.00 2,278.96 180-021-000-93700 Capital Expenses Balance Forward 10,979.25 Total 0.00 0.00 10,979.25 TCMUD No. 1 Page 57 of 101 Meeting Date: October 18, 2011 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 180-021-000-97000 Capital Repairs Balance Forward 0.00 09/13/2011 pump repair 21292 ITT Water & Wastewater USA 07653040 11,461.00 Total 11,461.00 0.00 11,461.00 180-130-000-40100 Salaries - Regular Balance Forward 6,400.00 09/02/2011 Payroll 09/2/11 20782 500.00 09/16/2011 Payroll 09/16/11 22279 200.00 09/30/2011 Payroll 09/30/11 22281 600.00 Total 1,300.00 0.00 7,700.00 180-130-000-42220 Social Security Taxes Balance Forward 396.80 09/02/2011 Payroll 09/2/11 20782 31.00 09/16/2011 Payroll 09/16/11 22279 12.40 09/30/2011 Payroll 09/30/11 22281 37.20 Total 80.60 0.00 477.40 180-130-000-42225 Medicare Taxes Balance Forward 92.80 09/02/2011 Payroll 09/2/11 20782 7.25 09/16/2011 Payroll 09/16/11 22279 2.90 09/30/2011 Payroll 09/30/11 22281 8.70 Total 18.85 0.00 111.65 180-130-000-42250 Unemployment Taxes Balance Forward 74.60 09/02/2011 Payroll 09/2/11 20782 4.00 09/16/2011 Payroll 09/16/11 22279 1.60 09/30/2011 Payroll 09/30/11 22281 4.80 Total 10.40 0.00 85.00 180-130-000-42260 Workman's Compensation Balance Forward 113.88 Total 0.00 0.00 113.88 180-130-000-50100 Professional Outside Services Balance Forward 0.00 Total 0.00 0.00 0.00 180-130-000-60100 Office Supplies Balance Forward 0.00 Total 0.00 0.00 0.00 180-130-000-60300 Postage Balance Forward -1.86 CR Total 0.00 0.00 -1.86 CR 180-130-000-60400 Publications/Books/Subscriptions Balance Forward 0.00 Total 0.00 0.00 0.00 180-130-000-73300 Advertising Balance Forward 0.00 Total 0.00 0.00 0.00 180-130-000-73400 Printing Balance Forward 0.00 Total 0.00 0.00 0.00 TCMUD No. 1 Page 58 of 101 Meeting Date: October 18, 2011 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 180-130-000-74100 Dues & Membership Balance Forward 79.00 Total 0.00 0.00 79.00 180-130-000-74200 Travel & per diem Balance Forward 968.26 Total 0.00 0.00 968.26 180-130-000-74300 Schools & Training Balance Forward 2,140.00 Total 0.00 0.00 2,140.00 180-130-000-74600 Meetings Balance Forward 326.00 09/01/2011 Chamber luncheon 20870 Northwest Metroport Chamber 8111 22.00 Total 22.00 0.00 348.00 180-130-000-79999 Miscellaneous Expense Balance Forward 0.00 Total 0.00 0.00 0.00 180-130-000-87110 Water Conservation Program/Public Information Balance Forward 2,334.72 Total 0.00 0.00 2,334.72 180-140-000-40100 Salaries - Regular Balance Forward 183,599.40 09/02/2011 Payroll 09/2/11 20782 6,618.71 09/16/2011 Payroll 09/16/11 22279 6,674.61 09/30/2011 Payroll 09/30/11 22281 6,469.08 Total 19,762.40 0.00 203,361.80 180-140-000-40130 Salaries - Overtime Balance Forward 292.89 09/02/2011 Payroll 09/2/11 20782 1.58 09/16/2011 Payroll 09/16/11 22279 13.05 Total 14.63 0.00 307.52 180-140-000-40140 Salaries - Longevity Balance Forward 2,755.00 Total 0.00 0.00 2,755.00 180-140-000-41200 Retirement Balance Forward 25,705.57 09/02/2011 Payroll 09/2/11 20782 931.71 09/16/2011 Payroll 09/16/11 22279 938.07 09/30/2011 Payroll 09/30/11 22281 916.02 Total 2,785.80 0.00 28,491.37 180-140-000-41210 Medical Insurance Balance Forward 17,061.78 09/02/2011 Payroll 09/2/11 20782 700.48 09/16/2011 Payroll 09/16/11 22279 689.38 Total 1,389.86 0.00 18,451.64 180-140-000-41215 Dental Insurance Balance Forward 873.71 09/02/2011 Payroll 09/2/11 20782 38.85 09/16/2011 Payroll 09/16/11 22279 38.26 TCMUD No. 1 Page 59 of 101 Meeting Date: October 18, 2011 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 Total 77.11 0.00 950.82 180-140-000-41216 Vision Insurance Balance Forward 162.83 09/02/2011 Payroll 09/2/11 20782 7.44 09/16/2011 Payroll 09/16/11 22279 7.33 Total 14.77 0.00 177.60 180-140-000-41218 Life Insurance & Other Balance Forward 390.74 Total 0.00 0.00 390.74 180-140-000-42220 Social Security Taxes Balance Forward 11,494.04 09/02/2011 Payroll 09/2/11 20782 385.06 09/16/2011 Payroll 09/16/11 22279 389.65 09/30/2011 Payroll 09/30/11 22281 401.07 Total 1,175.78 0.00 12,669.82 180-140-000-42225 Medicare Taxes Balance Forward 2,711.82 09/02/2011 Payroll 09/2/11 20782 90.06 09/16/2011 Payroll 09/16/11 22279 91.13 09/30/2011 Payroll 09/30/11 22281 93.80 Total 274.99 0.00 2,986.81 180-140-000-42250 Unemployment Taxes Balance Forward 467.54 09/02/2011 Payroll 09/2/11 20782 5.60 09/16/2011 Payroll 09/16/11 22279 5.35 09/30/2011 Payroll 09/30/11 22281 4.73 Total 15.68 0.00 483.22 180-140-000-42260 Workman's Compensation Balance Forward 743.12 Total 0.00 0.00 743.12 180-140-000-42290 Pre-employment Physicals/Testing Balance Forward 82.17 Total 0.00 0.00 82.17 180-140-000-42960 Employee Relations Balance Forward 908.67 09/30/2011 Slaght 22259 JP Morgan Chase Bank NA 100511 29.99 Total 29.99 0.00 938.66 180-140-000-50100 Professional Outside Services Balance Forward 228,075.63 Total 0.00 0.00 228,075.63 180-140-000-52100 Elections Balance Forward 1,952.65 09/22/2011 Joint election 5/14/11 21867 Tarrant County Elections Admin 425-2011 980.48 Total 980.48 0.00 2,933.13 180-140-000-54200 Records Management Balance Forward 120.00 Total 0.00 0.00 120.00 TCMUD No. 1 Page 60 of 101 Meeting Date: October 18, 2011 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 180-140-000-57000 Independent Labor Balance Forward 406.87 09/20/2011 Record MUD meeting 21294 Miguel Cruz 092011 37.50 Total 37.50 0.00 444.37 180-140-000-60100 Office Supplies Balance Forward 1,506.00 09/14/2011 Office Supplies 21296 Office Depot 578996141001 30.11 Total 30.11 0.00 1,536.11 180-140-000-60300 Postage Balance Forward 2,171.31 09/16/2011 Petty cash reimbursement 20840 Trophy Club MUD Petty Cash 091611 1.76 09/27/2011 TCEQ 22249 Federal Express Corp 7-652-61103 29.16 09/29/2011 TCEQ 21849 Federal Express Corp 7-645-23013 29.16 09/30/2011 September Postage Meter usage 22130 41.88 Total 100.20 1.76 2,269.75 180-140-000-60400 Publications/Books/Subscriptions Balance Forward 215.40 Total 0.00 0.00 215.40 180-140-000-73100 Telephone Balance Forward 215.15 Total 0.00 0.00 215.15 180-140-000-73200 Communications /Pagers/Mobiles Balance Forward 2,382.95 09/21/2011 Cells 20864 Verizon Wireless 090611 91.30 09/22/2011 Cell phones 21875 Verizon Wireless 6635092635 142.00 Total 233.30 0.00 2,616.25 180-140-000-73300 Advertising Balance Forward 0.00 Total 0.00 0.00 0.00 180-140-000-73400 Printing Balance Forward 3,170.00 Total 0.00 0.00 3,170.00 180-140-000-73600 Service Charges & Fees Balance Forward 32.50 Total 0.00 0.00 32.50 180-140-000-74100 Dues & Membership Balance Forward 2,169.50 09/30/2011 Slaght 22255 JP Morgan Chase Bank NA 092611 325.00 09/30/2011 Slaght 22259 JP Morgan Chase Bank NA 100511 23.90 Total 348.90 0.00 2,518.40 180-140-000-74200 Travel & per diem Balance Forward 1,201.01 Total 0.00 0.00 1,201.01 180-140-000-74300 Schools & Training Balance Forward 2,260.84 Total 0.00 0.00 2,260.84 180-140-000-74600 Meetings Balance Forward 183.83 09/26/2011 September purchases 21841 Costco Wholesale 092611 15.48 TCMUD No. 1 Page 61 of 101 Meeting Date: October 18, 2011 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 09/30/2011 Womack 22255 JP Morgan Chase Bank NA 092611 38.26 Total 53.74 0.00 237.57 180-140-000-76700 July 4 Celebration Balance Forward 10,000.00 Total 0.00 0.00 10,000.00 180-140-000-78500 Furniture/Equipment<$5,000 Balance Forward 4,081.30 Total 0.00 0.00 4,081.30 180-140-000-79999 Miscellaneous Expense Balance Forward 10.06 Total 0.00 0.00 10.06 180-611-000-40100 Salaries - Regular Balance Forward 60,371.56 09/02/2011 Payroll 09/2/11 20782 2,724.80 09/16/2011 Payroll 09/16/11 22279 2,724.80 09/30/2011 Payroll 09/30/11 22281 2,724.80 Total 8,174.40 0.00 68,545.96 180-611-000-40130 Salaries - Overtime Balance Forward 12,713.60 09/02/2011 Payroll 09/2/11 20782 356.10 09/16/2011 Payroll 09/16/11 22279 486.89 09/30/2011 Payroll 09/30/11 22281 790.87 Total 1,633.86 0.00 14,347.46 180-611-000-40140 Salaries - Longevity Balance Forward 1,710.00 Total 0.00 0.00 1,710.00 180-611-000-41200 Retirement Balance Forward 10,672.39 09/02/2011 Payroll 09/2/11 20782 436.25 09/16/2011 Payroll 09/16/11 22279 454.78 09/30/2011 Payroll 09/30/11 22281 497.82 Total 1,388.85 0.00 12,061.24 180-611-000-41210 Medical Insurance Balance Forward 8,332.23 09/02/2011 Payroll 09/2/11 20782 357.62 09/16/2011 Payroll 09/16/11 22279 357.62 Total 715.24 0.00 9,047.47 180-611-000-41215 Dental Insurance Balance Forward 452.78 09/02/2011 Payroll 09/2/11 20782 21.53 09/16/2011 Payroll 09/16/11 22279 21.53 Total 43.06 0.00 495.84 180-611-000-41216 Vision Insurance Balance Forward 54.78 09/02/2011 Payroll 09/2/11 20782 2.49 09/16/2011 Payroll 09/16/11 22279 2.49 Total 4.98 0.00 59.76 TCMUD No. 1 Page 62 of 101 Meeting Date: October 18, 2011 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 180-611-000-41218 Life Insurance & Other Balance Forward 146.23 Total 0.00 0.00 146.23 180-611-000-42220 Social Security Taxes Balance Forward 4,125.37 09/02/2011 Payroll 09/2/11 20782 160.79 09/16/2011 Payroll 09/16/11 22279 168.89 09/30/2011 Payroll 09/30/11 22281 217.97 Total 547.65 0.00 4,673.02 180-611-000-42225 Medicare Taxes Balance Forward 964.81 09/02/2011 Payroll 09/2/11 20782 37.60 09/16/2011 Payroll 09/16/11 22279 39.50 09/30/2011 Payroll 09/30/11 22281 50.98 Total 128.08 0.00 1,092.89 180-611-000-42250 Unemployment Taxes Balance Forward 129.59 Total 0.00 0.00 129.59 180-611-000-42260 Workman's Compensation Balance Forward 260.04 Total 0.00 0.00 260.04 180-611-000-42290 Pre-employment Physicals/Testing Balance Forward 0.00 Total 0.00 0.00 0.00 180-611-000-50100 Professional Outside Services Balance Forward 2,437.50 Total 0.00 0.00 2,437.50 180-611-000-60100 Office Supplies Balance Forward 495.65 09/14/2011 Office Supplies 21298 Office Depot 579087534001 13.49 09/16/2011 Office Supplies 21300 Office Depot 579446128001 16.96 09/16/2011 Petty cash reimbursement 20840 Trophy Club MUD Petty Cash 091611 5.97 Total 36.42 0.00 532.07 180-611-000-60300 Postage Balance Forward 363.47 09/30/2011 September Postage Meter usage 22130 31.24 Total 31.24 0.00 394.71 180-611-000-60400 Publications/Books/Subscriptions Balance Forward 0.00 Total 0.00 0.00 0.00 180-611-000-73100 Telephone Balance Forward 16.19 Total 0.00 0.00 16.19 180-611-000-73200 Communications /Pagers/Mobiles Balance Forward 560.98 09/21/2011 Cells 20864 Verizon Wireless 090611 51.51 09/22/2011 Cell phones 21875 Verizon Wireless 6635092635 51.51 Total 103.02 0.00 664.00 TCMUD No. 1 Page 63 of 101 Meeting Date: October 18, 2011 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 180-611-000-73300 Advertising Balance Forward 207.40 Total 0.00 0.00 207.40 180-611-000-73400 Printing Balance Forward 0.00 Total 0.00 0.00 0.00 180-611-000-73600 Service Charges & Fees Balance Forward 0.00 Total 0.00 0.00 0.00 180-611-000-74100 Dues & Membership Balance Forward 117.00 Total 0.00 0.00 117.00 180-611-000-74200 Travel & per diem Balance Forward 152.18 09/02/2011 Payroll 09/2/11 20782 5.77 Total 5.77 0.00 157.95 180-611-000-74300 Schools & Training Balance Forward 309.00 Total 0.00 0.00 309.00 180-611-000-74600 Meetings Balance Forward 25.00 09/01/2011 Chamber luncheon 20870 Northwest Metroport Chamber 8111 22.00 Total 22.00 0.00 47.00 180-611-000-78500 Furniture/Equipment<$5,000 Balance Forward 0.00 Total 0.00 0.00 0.00 180-611-000-79999 Miscellaneous Expense Balance Forward 0.00 Total 0.00 0.00 0.00 180-620-000-40100 Salaries - Regular Balance Forward 80,068.82 09/02/2011 Payroll 09/2/11 20782 3,828.55 09/16/2011 Payroll 09/16/11 22279 3,840.66 09/30/2011 Payroll 09/30/11 22281 3,808.24 Total 11,477.45 0.00 91,546.27 180-620-000-40130 Salaries - Overtime Balance Forward 1,029.34 09/02/2011 Payroll 09/2/11 20782 30.03 09/16/2011 Payroll 09/16/11 22279 27.48 09/30/2011 Payroll 09/30/11 22281 254.67 Total 312.18 0.00 1,341.52 180-620-000-40140 Salaries - Longevity Balance Forward 405.00 Total 0.00 0.00 405.00 180-620-000-41200 Retirement Balance Forward 11,035.32 09/02/2011 Payroll 09/2/11 20782 546.38 09/16/2011 Payroll 09/16/11 22279 547.74 09/30/2011 Payroll 09/30/11 22281 575.33 TCMUD No. 1 Page 64 of 101 Meeting Date: October 18, 2011 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 Total 1,669.45 0.00 12,704.77 180-620-000-41210 Medical Insurance Balance Forward 16,388.23 09/02/2011 Payroll 09/2/11 20782 807.82 09/16/2011 Payroll 09/16/11 22279 806.63 Total 1,614.45 0.00 18,002.68 180-620-000-41215 Dental Insurance Balance Forward 1,007.58 09/02/2011 Payroll 09/2/11 20782 52.47 09/16/2011 Payroll 09/16/11 22279 52.42 Total 104.89 0.00 1,112.47 180-620-000-41216 Vision Insurance Balance Forward 177.91 09/02/2011 Payroll 09/2/11 20782 9.27 09/16/2011 Payroll 09/16/11 22279 9.25 Total 18.52 0.00 196.43 180-620-000-41218 Life Insurance & Other Balance Forward 260.31 Total 0.00 0.00 260.31 180-620-000-42220 Social Security Taxes Balance Forward 4,782.06 09/02/2011 Payroll 09/2/11 20782 206.79 09/16/2011 Payroll 09/16/11 22279 207.47 09/30/2011 Payroll 09/30/11 22281 251.89 Total 666.15 0.00 5,448.21 180-620-000-42225 Medicare Taxes Balance Forward 1,118.39 09/02/2011 Payroll 09/2/11 20782 48.34 09/16/2011 Payroll 09/16/11 22279 48.52 09/30/2011 Payroll 09/30/11 22281 58.92 Total 155.78 0.00 1,274.17 180-620-000-42250 Unemployment Taxes Balance Forward 410.47 09/02/2011 Payroll 09/2/11 20782 5.30 09/16/2011 Payroll 09/16/11 22279 4.83 09/30/2011 Payroll 09/30/11 22281 4.75 Total 14.88 0.00 425.35 180-620-000-42260 Workman's Compensation Balance Forward 390.08 Total 0.00 0.00 390.08 180-620-000-42290 Pre-employment Physicals/Testing Balance Forward 30.23 Total 0.00 0.00 30.23 180-620-000-56200 Utility Billing Contract Balance Forward 8,840.88 09/01/2011 July Utility Billing 20834 CSG Systems, Inc.74560 1,068.15 09/30/2011 September water billing 22251 CSG Systems, Inc.75082 896.02 Total 1,964.17 0.00 10,805.05 TCMUD No. 1 Page 65 of 101 Meeting Date: October 18, 2011 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 180-620-000-57000 Independent Labor Balance Forward 0.00 Total 0.00 0.00 0.00 180-620-000-60100 Office Supplies Balance Forward 504.43 09/14/2011 Office Supplies 21296 Office Depot 578996141001 98.11 09/15/2011 Credit card machine paper/share cost wit 21306 Town of Trophy Club 091511worldpaysu 11.28 09/27/2011 Office Supplies 21861 Office Depot 580740356001 3.35 Total 112.74 0.00 617.17 180-620-000-60300 Postage Balance Forward 13,158.75 09/01/2011 July Utility Billing 20834 CSG Systems, Inc.74560 1,400.25 09/30/2011 September water billing 22251 CSG Systems, Inc.75082 1,365.14 Total 2,765.39 0.00 15,924.14 180-620-000-73100 Telephone Balance Forward 105.78 Total 0.00 0.00 105.78 180-620-000-73200 Communications /Pagers/Mobiles Balance Forward 410.36 09/21/2011 Cells 20864 Verizon Wireless 090611 34.19 09/22/2011 Cell phones 21875 Verizon Wireless 6635092635 36.54 Total 70.73 0.00 481.09 180-620-000-73400 Printing Balance Forward 2,152.00 Total 0.00 0.00 2,152.00 180-620-000-73600 Service Charges & Fees Balance Forward 20,511.35 09/07/2011 Credit Card fees/August 20302 9.99 09/07/2011 Credit Card fees/August 20302 1,989.72 09/07/2011 Credit Card fees/August 20302 513.54 Total 2,513.25 0.00 23,024.60 180-620-000-74100 Dues & Membership Balance Forward 0.00 Total 0.00 0.00 0.00 180-620-000-74200 Travel & per diem Balance Forward 55.07 09/02/2011 Payroll 09/2/11 20782 61.61 Total 61.61 0.00 116.68 180-620-000-74300 Schools & Training Balance Forward 46.44 Total 0.00 0.00 46.44 180-620-000-75600 TCEQ Annual Assessment Fee Balance Forward 19,248.17 Total 0.00 0.00 19,248.17 180-620-000-79999 Miscellaneous Expense Balance Forward 1.84 Total 0.00 0.00 1.84 180-620-000-99100 Transfer to General Fund Balance Forward 0.00 TCMUD No. 1 Page 66 of 101 Meeting Date: October 18, 2011 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 Total 0.00 0.00 0.00 180-630-000-42290 Pre-employment Physicals/Testing Balance Forward 152.41 Total 0.00 0.00 152.41 180-630-000-42960 Employee Relations Balance Forward 626.72 09/30/2011 Huggins 22255 JP Morgan Chase Bank NA 092611 13.90 Total 13.90 0.00 640.62 180-630-000-43240 Tuition Reimbursement Balance Forward 74.65 Total 0.00 0.00 74.65 180-630-000-60100 Office Supplies Balance Forward 0.00 Total 0.00 0.00 0.00 180-630-000-60300 Postage Balance Forward 0.00 Total 0.00 0.00 0.00 180-630-000-60400 Publications/Books/Subscriptions Balance Forward 0.00 Total 0.00 0.00 0.00 180-630-000-73100 Telephone Balance Forward 0.00 Total 0.00 0.00 0.00 180-630-000-73200 Communications /Pagers/Mobiles Balance Forward 0.00 Total 0.00 0.00 0.00 180-630-000-73400 Printing Balance Forward 0.00 Total 0.00 0.00 0.00 180-630-000-74100 Dues & Membership Balance Forward 0.00 Total 0.00 0.00 0.00 180-630-000-74200 Travel & per diem Balance Forward 0.00 Total 0.00 0.00 0.00 180-630-000-74300 Schools & Training Balance Forward 0.00 Total 0.00 0.00 0.00 180-630-000-74600 Meetings Balance Forward 0.00 Total 0.00 0.00 0.00 180-630-000-99100 Transfer to General Fund Balance Forward 0.00 Total 0.00 0.00 0.00 180-640-000-50700 Security Balance Forward 187.75 09/27/2011 Mike P.22197 Bank of America 092711 89.00 TCMUD No. 1 Page 67 of 101 Meeting Date: October 18, 2011 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 Total 89.00 0.00 276.75 180-640-000-55000 Software & Support Balance Forward 50,224.94 09/01/2011 Conversion 21328 STW Inc 092211 1,291.20 09/01/2011 Fixed assets/Utility billing 20878 STW Inc 082811 192.97 09/01/2011 Internet access 20842 Bandwidth.com, Inc.IN09152011-20071 326.70 09/12/2011 Kensington Wireless Presenter Pro 20888 SHI Governmental Solutions GB00042723 143.58 09/13/2011 STW support 20880 STW Inc 091311 142.97 09/16/2011 Spam Filtering 21276 The Fulcrum Group, Inc.16087 192.00 09/16/2011 June-Sept Listhosting 20848 Northwest ISD 10063 150.00 09/27/2011 Mike P.22197 Bank of America 092711 25.00 09/27/2011 Steve Z.22197 Bank of America 092711 373.70 09/27/2011 Steve Z.22197 Bank of America 092711 54.99 09/27/2011 Steve Z.22197 Bank of America 092711 53.38 09/27/2011 Mike P.22197 Bank of America 092711 12.50 09/27/2011 Mike P.22197 Bank of America 092711 25.00 09/30/2011 Channel 27 subscription 22221 Videotex Systems, Inc.77924 497.50 Total 3,481.49 0.00 53,706.43 180-640-000-57000 Independent Labor Balance Forward 2,348.75 Total 0.00 0.00 2,348.75 180-640-000-60100 Office Supplies Balance Forward 270.03 09/27/2011 Mike P.22197 Bank of America 092711 31.52 Total 31.52 0.00 301.55 180-640-000-60200 Printer Supplies Balance Forward 6,752.96 09/15/2011 HP printer roller kit 21863 SHI Governmental Solutions GB00042987 35.00 09/27/2011 Steve Z.22197 Bank of America 092711 13.49 09/27/2011 Mike P.22197 Bank of America 092711 3.50 Total 51.99 0.00 6,804.95 180-640-000-73100 Telephone Balance Forward 9,595.33 09/01/2011 analog/phones 20874 Mercury Communication Services, Inc 263563 481.56 09/08/2011 Multi line loud ringer paging amplifier 20876 Mercury Communication Services, Inc 263608 254.93 09/27/2011 Steve Z.22197 Bank of America 092711 451.33 09/27/2011 Steve Z.22197 Bank of America 092711 349.39 09/30/2011 Balance due (Tax exempt)22247 Mercury Communication Services, Inc 263419 137.50 Total 1,674.71 0.00 11,270.04 180-640-000-73200 Communications /Pagers/Mobiles Balance Forward 0.00 Total 0.00 0.00 0.00 180-640-000-74200 Travel & per diem Balance Forward 16.18 Total 0.00 0.00 16.18 180-640-000-75900 Prompt Payment Interest Balance Forward 14.53 Total 0.00 0.00 14.53 TCMUD No. 1 Page 68 of 101 Meeting Date: October 18, 2011 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 180-640-000-78600 Hardware Balance Forward 38,745.09 09/01/2011 Lee Delk 20148 JP Morgan Chase Bank NA 08062011 68.98 09/27/2011 Steve Z.22197 Bank of America 092711 114.99 09/27/2011 Steve Z.22197 Bank of America 092711 104.80 09/27/2011 Mike P.22197 Bank of America 092711 45.81 09/27/2011 Mike P.22197 Bank of America 092711 196.22 09/27/2011 Mike P.22197 Bank of America 092711 835.65 Total 1,366.45 0.00 40,111.54 180-640-000-79100 Copier Rental/Lease Balance Forward 2,732.90 09/21/2011 PW Copier lease/Feb 20898 Kyocera Mita America, Inc 110288230 115.62 09/21/2011 PW Fax Lease/Feb 20900 Kyocera Mita America, Inc 110288231 10.91 09/21/2011 Adm Copier Lease/Feb 20902 Kyocera Mita America, Inc 110288220 146.76 Total 273.29 0.00 3,006.19 180-640-000-99100 Transfer to General Fund Balance Forward 0.00 Total 0.00 0.00 0.00 180-640-000-99500 Transfer to Future Replacement Reserve Balance Forward 26,911.00 Total 0.00 0.00 26,911.00 180-710-000-52400 Lab Analysis Balance Forward 1,168.75 Total 0.00 0.00 1,168.75 180-710-000-62520 Vending Machine Supplies Balance Forward 429.28 09/01/2011 August Charges 20856 Costco Wholesale 082611 73.13 09/26/2011 September purchases 21841 Costco Wholesale 092611 47.18 09/26/2011 September purchases 21841 Costco Wholesale 092611 21.48 09/30/2011 Womack 22255 JP Morgan Chase Bank NA 092611 82.03 Total 223.82 0.00 653.10 180-710-000-72100 Electricity/Gas Balance Forward 12,391.29 09/14/2011 Electricity 8/16-9/14 21845 Direct Energy Business Svcs 1167948 1,288.18 Total 1,288.18 0.00 13,679.47 180-710-000-72200 Water Balance Forward 560.41 09/21/2011 August water 20904 Trophy Club MUD - Water Bills 083111 117.64 09/30/2011 September water 21873 Trophy Club MUD - Water Bills 093011 241.31 Total 358.95 0.00 919.36 180-710-000-75000 Insurance Balance Forward 23,575.81 Total 0.00 0.00 23,575.81 180-710-000-79200 Building Rental/Lease Balance Forward 12,083.61 09/01/2011 Public Service bldg rent/September 20884 Town of Trophy Club 090111 1,098.51 Total 1,098.51 0.00 13,182.12 180-710-000-81200 Building Maintenance Balance Forward 13,446.44 TCMUD No. 1 Page 69 of 101 Meeting Date: October 18, 2011 G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 09/30/2011 Womack 22255 JP Morgan Chase Bank NA 092611 49.94 Total 49.94 0.00 13,496.38 180-710-000-81600 Cleaning Services Balance Forward 7,541.63 09/01/2011 September janitorial service 20868 ABM Janitorial Services, Inc 2926848 559.50 09/01/2011 Renae Gonzales 20148 JP Morgan Chase Bank NA 08062011 118.68 09/30/2011 Slaght 22255 JP Morgan Chase Bank NA 092611 148.35 Total 826.53 0.00 8,368.16 180-710-000-81900 Maintenance Supplies Balance Forward 1,680.74 09/01/2011 Carolyn Huggins 20148 JP Morgan Chase Bank NA 08062011 77.28 09/01/2011 August Charges 20856 Costco Wholesale 082611 23.89 09/26/2011 September purchases 21841 Costco Wholesale 092611 38.48 09/30/2011 Slaght 22255 JP Morgan Chase Bank NA 092611 24.12 09/30/2011 Huggins 22255 JP Morgan Chase Bank NA 092611 46.78 Total 210.55 0.00 1,891.29 180-710-000-93300 Equipment Balance Forward 0.00 Total 0.00 0.00 0.00 180-810-000-50200 Auditing Balance Forward 27,500.00 Total 0.00 0.00 27,500.00 180-810-000-50300 Legal Balance Forward 39,827.61 09/01/2011 August Legal 20882 Whitaker, Chalk, Swindle LLP 155855 1,408.00 09/30/2011 September legal 22223 The Liston Law Firm, P.C.093011 135.00 Total 1,543.00 0.00 41,370.61 180-810-000-51100 Appraisal Balance Forward 12,269.68 Total 0.00 0.00 12,269.68 180-810-000-51150 Tax Administration Balance Forward 2,696.56 Total 0.00 0.00 2,696.56 180-810-000-99510 Transfer to Fire Construction Fund Balance Forward 272,718.65 09/30/2011 Transfer to Fire Construction/Sept exp 22121 309,158.99 Total 309,158.99 0.00 581,877.64 GRAND TOTAL 821,638.12 258.41 5,215,294.63 TCMUD No. 1 Page 70 of 101 Meeting Date: October 18, 2011 380-020-000-93700 Capital Expenses 0.00 0.00 1,677.98 211,898.58 (211,898.58) # Total Capital Projects 0.00 0.00 1,677.98 211,898.58 (211,898.58) page 1 Budget to Actual - Capital Pro Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 Page 71 of 101 Meeting Date: October 18, 2011 Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report G/L #Effective Date Description Journal #Vendor Name Vendor Inv #Debit Credit Balance 380-020-000-93700 Capital Expenses Balance Forward 210,220.60 09/14/2011 Longofil bagging system/Bar Screen 21839 Comarco Industrial, Inc.0311052 1,677.98 Total 1,677.98 0.00 211,898.58 GRAND TOTAL 1,677.98 0.00 211,898.58 TCMUD No. 1 Page 72 of 101 Meeting Date: October 18, 2011 Municipal Utility District No 1 Fire Department O & M Interim Balance Sheet Balance @ 9/30/2011 ASSETS ASSETS CASH IN BANK -$ INVESTMENTS 360,436 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 12,314 ACCOUNTS RECEIVABLE - PID EMERGENCY SERVICES ASSESSMENTS 4,857 OTHER RECEIVABLES 71,143 TOTAL ASSETS 448,750$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE 17,171$ ACCOUNTS PAYABLE 125,645 TOTAL LIABILITIES 142,815$ FUND BALANCE UNDESIGNATED FUND BALANCE 305,935 TOTAL LIABILITIES AND FUND BALANCE 448,750$ September 30, 2011 12/12 Months (100% of Fiscal Year) TCMUD No. 1 Page 73 of 101 Meeting Date: October 18, 2011 Trophy Club Municipal Utility Dist #1 Budget Revenue Report To Date: 09/30/2011 From Account: 190-000-000-30050 To Account: 190-000-000-39200 Run Date: 10/13/2011 User: rgonzales Segments/Accounts Total Budget MTD Rev.YTD Rev. Total Variance Total % [FUND] 190 : Fire Department Operations 190-000-000-30050 : Emergency Service Assessment 111,648.00 7.75 120,134.52 -8,486.52 -7.60% 190-000-000-30060 : Emergency Services Assessment - Penalty & Interest 0.00 1.51 1,730.61 -1,730.61 0.00% 190-000-000-30100 : Property Taxes 1,072,786.00 11,383.40 1,084,117.27 -11,331.27 -1.06% 190-000-000-30125 : Property Taxes/Delinquent 0.00 240.98 9,208.75 -9,208.75 0.00% 190-000-000-30150 : Property Taxes/Penalty & Interest 7,500.00 2,414.14 7,670.44 -170.44 -2.27% 190-000-000-32014 : Fire Permits/Sprinkler 0.00 0.00 2,400.00 -2,400.00 0.00% 190-000-000-33050 : Fire Inspections 0.00 0.00 375.00 -375.00 0.00% 190-000-000-33420 : Denton/Tarrant County - Fire 13,750.00 0.00 10,000.00 3,750.00 27.27% 190-000-000-35050 : Interest Income 0.00 0.00 75.00 -75.00 0.00% 190-000-000-36700 : Miscellaneous Revenue 2,500.00 58,542.55 61,367.55 -58,867.55 -2,354.70% [FUND] SubTotal : 190 : Fire Department Operations 1,208,184.00 72,590.33 1,297,079.14 -88,895.14 -7.36% Grand Total :1,208,184.00 72,590.33 1,297,079.14 -88,895.14 -7.36% PAGE 1 TCMUD No. 1 Page 74 of 101 Meeting Date: October 18, 2011 190-045-000-40100 Salaries - Regular 390,466.00 390,466.00 47,057.00 390,346.34 119.66 100.0 190-045-000-40130 Salaries - Overtime 40,298.00 40,298.00 15,873.83 63,668.16 (23,370.16) 158.0 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 7,077.64 (1,676.64) 131.0 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 8,532.09 64,549.56 (1,533.56) 102.4 190-045-000-41210 Medical Insurance 54,809.00 54,809.00 3,919.74 52,197.97 2,611.03 95.2 190-045-000-41215 Dental Insurance 2,819.00 2,819.00 244.35 2,935.26 (116.26) 104.1 190-045-000-41216 Vision Insurance 505.00 505.00 37.76 469.15 35.85 92.9 190-045-000-41218 Life Insurance & Other 2,491.00 2,491.00 0.00 886.38 1,604.62 35.6 190-045-000-42220 Social Security Taxes 26,252.00 26,252.00 3,733.98 27,549.48 (1,297.48) 104.9 190-045-000-42225 Medicare Taxes 6,140.00 6,140.00 873.31 6,446.12 (306.12) 105.0 190-045-000-42250 Unemployment Taxes 1,387.00 1,387.00 27.78 982.56 404.44 70.8 190-045-000-42260 Workman's Compensation 13,134.00 13,134.00 0.00 12,465.28 668.72 94.9 190-045-000-42290 Pre-employment Physicals/Testing 675.00 675.00 169.94 365.44 309.56 54.1 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 2.36 231.44 (136.44) 243.6 190-045-000-60400 Publications/Books/Subscriptions 382.00 382.00 29.95 29.95 352.05 7.8 190-045-000-61000 Fuel 16,585.00 16,585.00 1,535.79 12,371.89 4,213.11 74.6 190-045-000-62100 Uniforms 4,357.00 4,357.00 65.97 4,342.74 14.26 99.7 190-045-000-62150 Protective Clothing 7,600.00 7,600.00 0.00 6,178.18 1,421.82 81.3 190-045-000-62300 Chemicals 1,545.00 1,545.00 0.00 305.00 1,240.00 19.7 190-045-000-72100 Electricity/Gas 17,400.00 17,400.00 1,408.74 11,834.51 5,565.49 68.0 190-045-000-72200 Water 3,193.00 3,193.00 55.80 500.41 2,692.59 15.7 190-045-000-73100 Telephone 103.00 103.00 0.00 129.98 (26.98) 126.2 190-045-000-73200 Communications /Pagers/Mobiles 1,874.00 1,874.00 431.94 2,673.39 (799.39) 142.7 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 1,595.00 8,061.60 296.40 96.5 190-045-000-74200 Travel & per diem 7,107.00 7,107.00 153.90 3,685.31 3,421.69 51.9 190-045-000-74300 Schools & Training 6,615.00 6,615.00 1,129.00 4,795.93 1,819.07 72.5 190-045-000-74400 Emergency Management 1,000.00 1,000.00 0.00 1,000.00 0.00 100.0 190-045-000-74600 Meetings 0.00 0.00 0.00 22.00 (22.00) # 190-045-000-75000 Insurance 19,975.00 19,975.00 0.00 8,714.00 11,261.00 43.6 190-045-000-77300 Fire Inspections/Enforcement 1,000.00 1,000.00 0.00 205.12 794.88 20.5 page 1 Budget to Actual - Fire Dept. Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 Page 75 of 101 Meeting Date: October 18, 2011 190-045-000-78200 Small Tools 8,127.00 8,127.00 1,825.54 7,005.49 1,121.51 86.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 544.15 784.62 428.38 64.7 190-045-000-80250 Maintenance and Repairs 5,562.00 5,562.00 438.00 3,995.84 1,566.16 71.8 190-045-000-81200 Building Maintenance 11,000.00 11,000.00 2,261.87 10,328.49 671.51 93.9 190-045-000-81300 Vehicle Maintenance 13,500.00 13,500.00 1,102.59 13,966.63 (466.63) 103.5 190-045-000-81350 Equipment Maintenance 3,675.00 3,675.00 634.60 1,256.70 2,418.30 34.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 75.00 2,047.50 374.50 84.5 190-045-000-81900 Maintenance Supplies 2,652.00 2,652.00 13.80 1,434.18 1,217.82 54.1 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,192.35 4,070.19 9.81 99.8 190-045-000-90100 Radios 2,500.00 2,500.00 0.00 1,007.37 1,492.63 40.3 190-045-000-90200 Fire Engine 681 Payment 73,388.00 73,388.00 0.00 73,887.90 (499.90) 100.7 190-045-000-93200 Vehicles 4,183.00 4,183.00 0.00 4,164.55 18.45 99.6 190-045-000-93600 Airpacks 2,245.00 2,245.00 0.00 2,245.00 0.00 100.0 Total Fire Department 1,208,184.00 1,208,184.00 95,460.83 1,146,346.33 61,837.67 page 2 Budget to Actual - Fire Dept. Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 Page 76 of 101 Meeting Date: October 18, 2011 G/L #Effective Date Description Journal #Vendor Name Vendor Invoice #Debit Credit Balance 190-045-000-40100 Salaries - Regular Balance Forward 343,289.34 09/02/2011 Payroll 09/2/11 20782 15,150.63 09/16/2011 Payroll 09/16/11 22279 15,881.00 09/30/2011 Payroll 09/30/11 22281 16,025.37 Total 47,057.00 0.00 390,346.34 190-045-000-40130 Salaries - Overtime Balance Forward 47,794.33 09/02/2011 Payroll 09/2/11 20782 5,887.94 09/30/2011 Payroll 09/30/11 22281 9,985.89 Total 15,873.83 0.00 63,668.16 190-045-000-40140 Salaries - Longevity Balance Forward 2,986.99 Total 0.00 0.00 2,986.99 190-045-000-40160 Salaries - Certification Balance Forward 6,582.94 09/16/2011 Payroll 09/16/11 22279 494.70 Total 494.70 0.00 7,077.64 190-045-000-40180 Salaries - Holiday Pay Balance Forward 12,154.86 Total 0.00 0.00 12,154.86 190-045-000-41200 Retirement Balance Forward 56,017.47 09/02/2011 Payroll 09/2/11 20782 2,824.78 09/16/2011 Payroll 09/16/11 22279 2,181.69 09/30/2011 Payroll 09/30/11 22281 3,525.62 Total 8,532.09 0.00 64,549.56 190-045-000-41210 Medical Insurance Balance Forward 48,278.23 09/02/2011 Payroll 09/2/11 20782 1,949.76 09/16/2011 Payroll 09/16/11 22279 1,969.98 Total 3,919.74 0.00 52,197.97 190-045-000-41215 Dental Insurance Balance Forward 2,690.91 09/02/2011 Payroll 09/2/11 20782 121.42 09/16/2011 Payroll 09/16/11 22279 122.93 Total 244.35 0.00 2,935.26 190-045-000-41216 Vision Insurance Balance Forward 431.39 09/02/2011 Payroll 09/2/11 20782 18.77 09/16/2011 Payroll 09/16/11 22279 18.99 Total 37.76 0.00 469.15 190-045-000-41218 Life Insurance & Other Balance Forward 886.38 Total 0.00 0.00 886.38 190-045-000-42220 Social Security Taxes Balance Forward 23,815.50 09/02/2011 Payroll 09/2/11 20782 1,205.68 09/16/2011 Payroll 09/16/11 22279 915.63 09/30/2011 Payroll 09/30/11 22281 1,612.67 Total 3,733.98 0.00 27,549.48 Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 TCMUD No. 1 Page 77 of 101 Meeting Date: October 18, 2011 G/L #Effective Date Description Journal #Vendor Name Vendor Invoice #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 190-045-000-42225 Medicare Taxes Balance Forward 5,572.81 09/02/2011 Payroll 09/2/11 20782 281.99 09/16/2011 Payroll 09/16/11 22279 214.16 09/30/2011 Payroll 09/30/11 22281 377.16 Total 873.31 0.00 6,446.12 190-045-000-42250 Unemployment Taxes Balance Forward 954.78 09/02/2011 Payroll 09/2/11 20782 2.93 09/16/2011 Payroll 09/16/11 22279 11.95 09/30/2011 Payroll 09/30/11 22281 12.90 Total 27.78 0.00 982.56 190-045-000-42260 Workman's Compensation Balance Forward 12,465.28 Total 0.00 0.00 12,465.28 190-045-000-42290 Pre-employment Physicals/Testing Balance Forward 195.50 09/01/2011 Pre-emp testing 20832 Mary A. Connell, Ed.D., ABPP 993 117.48 09/01/2011 Pre-employment physicals/testing-Sampson 20858 First Check Applicant Screening 2205 15.90 09/01/2011 Pre-employment physicals/testing-Sampson 20860 CareNow 866755 18.28 09/01/2011 Pre-employment physicals/testing 20862 CareNow 866754 18.28 Total 169.94 0.00 365.44 190-045-000-50100 Professional Outside Services Balance Forward 0.00 Total 0.00 0.00 0.00 190-045-000-54100 Physicals/Testing Balance Forward 0.00 Total 0.00 0.00 0.00 190-045-000-60100 Office Supplies Balance Forward 215.63 Total 0.00 0.00 215.63 190-045-000-60300 Postage Balance Forward 229.08 09/30/2011 September Postage Meter usage 22130 2.36 Total 2.36 0.00 231.44 190-045-000-60400 Publications/Books/Subscriptions Balance Forward 0.00 09/30/2011 D. Thomas 22255 JP Morgan Chase Bank NA 092611 29.95 Total 29.95 0.00 29.95 190-045-000-61000 Fuel Balance Forward 10,836.10 09/22/2011 TIFMAS Wildland Deployment-Fuel for Brus 21284 Dusten Hards 092211 147.00 09/30/2011 Hurd 22259 JP Morgan Chase Bank NA 100511 42.29 09/30/2011 Hurd 22255 JP Morgan Chase Bank NA 092611 49.75 09/30/2011 Hurd 22255 JP Morgan Chase Bank NA 092611 12.67 09/30/2011 Hurd 22255 JP Morgan Chase Bank NA 092611 56.88 09/30/2011 Hurd 22255 JP Morgan Chase Bank NA 092611 51.56 09/30/2011 Town Travel 11 - Dusten Hards 22255 JP Morgan Chase Bank NA 092611 100.00 09/30/2011 Town Travel 11 - Dusten Hards 22255 JP Morgan Chase Bank NA 092611 67.00 09/30/2011 Town Travel 11 - Dusten Hards 22255 JP Morgan Chase Bank NA 092611 13.48 09/30/2011 Town Travel 11 - Dusten Hards 22255 JP Morgan Chase Bank NA 092611 64.00 TCMUD No. 1 Page 78 of 101 Meeting Date: October 18, 2011 G/L #Effective Date Description Journal #Vendor Name Vendor Invoice #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 09/30/2011 Town Travel 11 - Dusten Hards 22255 JP Morgan Chase Bank NA 092611 65.00 09/30/2011 September gas log 22145 866.16 Total 1,535.79 0.00 12,371.89 190-045-000-62100 Uniforms Balance Forward 4,276.77 09/24/2011 Cleaners/Fire Dress Uniform cleaning 21282 Donnie Gene Hurd II 092411 24.82 09/28/2011 Dry cleaning Calss A uniforms 21847 Donnie Gene Hurd II 092811 41.15 Total 65.97 0.00 4,342.74 190-045-000-62150 Protective Clothing Balance Forward 6,178.18 Total 0.00 0.00 6,178.18 190-045-000-62300 Chemicals Balance Forward 305.00 Total 0.00 0.00 305.00 190-045-000-72100 Electricity/Gas Balance Forward 10,425.77 09/16/2011 Electricity 8/15-9/14 21865 Star-Tex Power 6175975 326.05 09/19/2011 Electricity 8/12-9/13 21290 Hudson Energy 2331474 1,005.35 09/20/2011 Gas/Fire Station 21837 Atmos Energy 092111 77.34 Total 1,408.74 0.00 11,834.51 190-045-000-72200 Water Balance Forward 444.61 09/21/2011 August water 20904 Trophy Club MUD - Water Bills 083111 25.42 09/21/2011 August water 20904 Trophy Club MUD - Water Bills 083111 30.38 Total 55.80 0.00 500.41 190-045-000-73100 Telephone Balance Forward 129.98 Total 0.00 0.00 129.98 190-045-000-73200 Communications /Pagers/Mobiles Balance Forward 2,241.45 09/21/2011 Cells 20864 Verizon Wireless 090611 208.58 09/22/2011 Cell phones 21875 Verizon Wireless 6635092635 192.39 09/27/2011 Mike P.22197 Bank of America 092711 30.97 Total 431.94 0.00 2,673.39 190-045-000-73300 Advertising Balance Forward 0.00 Total 0.00 0.00 0.00 190-045-000-73400 Printing Balance Forward 0.00 Total 0.00 0.00 0.00 190-045-000-74100 Dues & Membership Balance Forward 6,466.60 09/01/2011 2011 Membership Dues/Fire Chief 21304 Texas Fire Chiefs Association 82511 150.00 09/13/2011 Annual Department renewal 20846 Texas Commission on Fire Protection 091311 1,445.00 Total 1,595.00 0.00 8,061.60 190-045-000-74200 Travel & per diem Balance Forward 3,531.41 09/30/2011 Hurd 22255 JP Morgan Chase Bank NA 092611 13.31 09/30/2011 Town Travel 11 - Dusten Hards 22255 JP Morgan Chase Bank NA 092611 4.16 09/30/2011 Town Travel 11 - Dusten Hards 22255 JP Morgan Chase Bank NA 092611 19.85 TCMUD No. 1 Page 79 of 101 Meeting Date: October 18, 2011 G/L #Effective Date Description Journal #Vendor Name Vendor Invoice #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 09/30/2011 Hurd 22255 JP Morgan Chase Bank NA 092611 14.84 09/30/2011 Town Travel 11 - Dusten Hards 22255 JP Morgan Chase Bank NA 092611 4.72 09/30/2011 Town Travel 11 - Dusten Hards 22255 JP Morgan Chase Bank NA 092611 26.26 09/30/2011 Town Travel 11 - Dusten Hards 22255 JP Morgan Chase Bank NA 092611 7.57 09/30/2011 Town Travel 11 - Dusten Hards 22255 JP Morgan Chase Bank NA 092611 18.00 09/30/2011 Town Travel 11 - Dusten Hards 22255 JP Morgan Chase Bank NA 092611 14.23 09/30/2011 Town Travel 11 - Dusten Hards 22255 JP Morgan Chase Bank NA 092611 11.65 09/30/2011 Town Travel 11 - Dusten Hards 22255 JP Morgan Chase Bank NA 092611 7.44 09/30/2011 Town Travel 11 - Dusten Hards 22255 JP Morgan Chase Bank NA 092611 4.32 09/30/2011 Town Travel 11 - Dusten Hards 22255 JP Morgan Chase Bank NA 092611 7.55 Total 153.90 0.00 3,685.31 190-045-000-74300 Schools & Training Balance Forward 3,666.93 09/01/2011 Donnie Hurd 20148 JP Morgan Chase Bank NA 08062011 334.00 09/29/2011 Fire Prevention Materials 21881 National Fire Safety Council, Inc.785636 200.00 09/30/2011 Beck 22255 JP Morgan Chase Bank NA 092611 595.00 Total 1,129.00 0.00 4,795.93 190-045-000-74400 Emergency Management Balance Forward 1,000.00 Total 0.00 0.00 1,000.00 190-045-000-74600 Meetings Balance Forward 22.00 Total 0.00 0.00 22.00 190-045-000-75000 Insurance Balance Forward 8,714.00 Total 0.00 0.00 8,714.00 190-045-000-77300 Fire Inspections/Enforcement Balance Forward 205.12 Total 0.00 0.00 205.12 190-045-000-78200 Small Tools Balance Forward 5,179.95 09/30/2011 Sipes 22255 JP Morgan Chase Bank NA 092611 399.99 09/30/2011 Sipes 22255 JP Morgan Chase Bank NA 092611 9.48 09/30/2011 Sipes 22255 JP Morgan Chase Bank NA 092611 43.19 09/30/2011 Sipes 22255 JP Morgan Chase Bank NA 092611 299.99 09/30/2011 Hurd 22255 JP Morgan Chase Bank NA 092611 91.01 09/30/2011 Hurd 22255 JP Morgan Chase Bank NA 092611 52.95 09/30/2011 Hurd 22255 JP Morgan Chase Bank NA 092611 290.00 09/30/2011 Grunt 22255 JP Morgan Chase Bank NA 092611 199.98 09/30/2011 Hurd 22259 JP Morgan Chase Bank NA 100511 23.98 09/30/2011 Hurd 22259 JP Morgan Chase Bank NA 100511 414.97 Total 1,825.54 0.00 7,005.49 190-045-000-79200 Building Rental/Lease Balance Forward 308,000.00 Total 0.00 0.00 308,000.00 190-045-000-79999 Miscellaneous Expense Balance Forward 240.47 09/01/2011 Janet Grunt 20148 JP Morgan Chase Bank NA 08062011 100.00 09/01/2011 Gary Sipes 20148 JP Morgan Chase Bank NA 08062011 91.17 09/01/2011 Plaques for Fire Station grand opening 20844 Keller Trophy and Awards, LTD 46333 60.00 09/30/2011 Grunt 22255 JP Morgan Chase Bank NA 092611 10.00 TCMUD No. 1 Page 80 of 101 Meeting Date: October 18, 2011 G/L #Effective Date Description Journal #Vendor Name Vendor Invoice #Debit Credit Balance Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 09/30/2011 Grunt 22255 JP Morgan Chase Bank NA 092611 26.00 09/30/2011 Grunt 22255 JP Morgan Chase Bank NA 092611 170.00 09/30/2011 Grunt 22255 JP Morgan Chase Bank NA 092611 8.00 09/30/2011 Grunt 22255 JP Morgan Chase Bank NA 092611 71.98 09/30/2011 Sipes 22255 JP Morgan Chase Bank NA 092611 7.00 Total 544.15 0.00 784.62 190-045-000-80250 Maintenance and Repairs Balance Forward 3,557.84 09/30/2011 Hurd 22255 JP Morgan Chase Bank NA 092611 438.00 Total 438.00 0.00 3,995.84 190-045-000-81200 Building Maintenance Balance Forward 8,066.62 09/01/2011 Supply & install input module/telephones 20872 American Communications 57526 245.00 09/01/2011 Donnie Hurd 20148 JP Morgan Chase Bank NA 08062011 91.56 09/01/2011 Shane Beck 20148 JP Morgan Chase Bank NA 08062011 1,019.25 09/01/2011 Danny Thomas 20148 JP Morgan Chase Bank NA 08062011 19.94 09/26/2011 September purchases 21841 Costco Wholesale 092611 248.43 09/30/2011 Directv Refund/Account closed 22137 98.99 09/30/2011 Hurd 22255 JP Morgan Chase Bank NA 092611 106.53 09/30/2011 D. Thomas 22255 JP Morgan Chase Bank NA 092611 200.20 09/30/2011 D. Thomas 22255 JP Morgan Chase Bank NA 092611 97.11 09/30/2011 Hurd 22255 JP Morgan Chase Bank NA 092611 106.83 09/30/2011 Thomas 22259 JP Morgan Chase Bank NA 100511 151.06 09/30/2011 Beck 22259 JP Morgan Chase Bank NA 100511 74.95 Total 2,360.86 98.99 10,328.49 190-045-000-81300 Vehicle Maintenance Balance Forward 12,864.04 09/01/2011 Donnie Hurd 20148 JP Morgan Chase Bank NA 08062011 65.75 09/30/2011 Hurd 22255 JP Morgan Chase Bank NA 092611 14.50 09/30/2011 Hurd 22255 JP Morgan Chase Bank NA 092611 61.07 09/30/2011 Hurd 22255 JP Morgan Chase Bank NA 092611 76.32 09/30/2011 Hurd 22255 JP Morgan Chase Bank NA 092611 91.04 09/30/2011 Hurd 22259 JP Morgan Chase Bank NA 100511 96.93 09/30/2011 Hurd 22259 JP Morgan Chase Bank NA 100511 45.82 09/30/2011 Hurd 22259 JP Morgan Chase Bank NA 100511 218.00 09/30/2011 Hurd 22259 JP Morgan Chase Bank NA 100511 400.19 09/30/2011 Hurd 22259 JP Morgan Chase Bank NA 100511 32.97 Total 1,102.59 0.00 13,966.63 190-045-000-81350 Equipment Maintenance Balance Forward 622.10 09/08/2011 Annual service/Bauer UN3 10H 20894 August Industries, Inc.025610 634.60 Total 634.60 0.00 1,256.70 190-045-000-81400 Radio Maintenance Balance Forward 465.00 Total 0.00 0.00 465.00 190-045-000-81800 Flags & Repairs Balance Forward 1,972.50 09/21/2011 Flag repair 21302 Symonds Flags & Poles, Inc 3538 75.00 Total 75.00 0.00 2,047.50 190-045-000-81900 Maintenance Supplies Balance Forward 1,420.38 TCMUD No. 1 Page 81 of 101 Meeting Date: October 18, 2011 G/L #Effective Date Description Journal #Vendor Name Vendor Invoice #Debit Credit BalanceTrophy Club Municipal Utility Dist #1G/L Transaction Detail Report9/30/201109/26/2011 September purchases 21841 Costco Wholesale 092611 13.80Total13.80 0.00 1,434.18190-045-000-85000 Grant Match Balance Forward 1,308.60Total0.00 0.00 1,308.60190-045-000-87100 Programs & Special Projects Balance Forward 2,877.8409/01/2011 Helium rental for grand opening/Fire Sta 20906 Apple Oxygen Supply, Inc.30510 107.7009/01/2011 April Reiling 20148 JP Morgan Chase Bank NA 08062011 240.0009/01/2011 Gary Sipes 20148 JP Morgan Chase Bank NA 08062011 804.6509/01/2011 Shane Beck 20148 JP Morgan Chase Bank NA 08062011 40.00Total1,192.35 0.00 4,070.19190-045-000-90100 Radios Balance Forward 1,007.37Total0.00 0.00 1,007.37190-045-000-90200 Fire Engine 681 Payment Balance Forward 73,887.90Total0.00 0.00 73,887.90190-045-000-93200 Vehicles Balance Forward 4,164.55Total0.00 0.00 4,164.55190-045-000-93600 Airpacks Balance Forward 2,245.00Total0.00 0.00 2,245.00 GRAND TOTAL 95,559.82 98.99 1,146,346.33 Journal #Name Debit Credit 20782 Payroll 74,803.97 74,803.97 22279 Payroll 69,321.72 69,321.72 22281 Payroll 76,881.35 76,881.35 20832 Invoice # I11-003247 117.48 117.48 20858 Invoice # I11-003265 15.90 15.90 20860 Invoice # I11-003266 18.28 18.28 20862 Invoice # I11-003267 18.28 18.28 22130 September Postage Mete 470.46 470.46 22255 Invoice # I11-003458 9,638.67 9,638.67 21284 Invoice # I11-003333 147.00 147.00 22259 Invoice # I11-003461 12,450.72 12,450.72 22145 September gas log 11,175.20 11,175.20 21282 Invoice # I11-003332 24.82 24.82 21847 Invoice # I11-003430 41.15 41.15 21865 Invoice # I11-003438 326.05 326.05 21290 Invoice # I11-003336 1,005.35 1,005.35 21837 Invoice # I11-003415 77.34 77.34 20904 Invoice # I11-003288 235.18 235.18 20864 Invoice # I11-003268 965.35 965.35 21875 Invoice # I11-003442 1,026.88 1,026.88 22197 Invoice # I11-003449 7,179.91 7,179.91 TCMUD No. 1 Page 82 of 101 Meeting Date: October 18, 2011 Municipal Utility District No 1 Fire Station Construction 2010 General Obligation $2M Bond Fund Interim Balance Sheet 12/12 Months (100% of Fiscal Year) Balance @ 9/30/2011 ASSETS ASSETS INVESTMENTS -$ OTHER RECEIVABLES - TOTAL ASSETS -$ LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS PAYABLE 118,335$ TOTAL LIABILITIES 118,335 FUND BALANCE DESIGNATED FOR FIRE STATION CONSTRUCTION (118,335) TOTAL LIABILITIES AND FUND BALANCE -$ * General Fund will transfer to cover expenditures over bond money received. September 30, 2011 TCMUD No. 1 Page 83 of 101 Meeting Date: October 18, 2011 Trophy Club Municipal Utility Dist #1 Budget Revenue Report To Date: 09/30/2011 From Account: 491-000-000-35050 To Account: 491-000-000-39200 Run Date: 10/13/2011 User: rgonzales Segments/Accounts Total Budget MTD Rev.YTD Rev. Total Variance Total % [FUND] 491 : Bond Fund 2010 GO 2M Fire 491-000-000-35050 : Interest Income 1,295.00 0.00 1,053.58 241.42 18.64% 491-000-000-39200 : Transfer In - General Fund 0.00 309,158.99 581,877.64 -581,877.64 0.00% [FUND] SubTotal : 491 : Bond Fund 2010 GO 2M Fire 1,295.00 309,158.99 582,931.22 -581,636.22 -44,913.99% Grand Total :1,295.00 309,158.99 582,931.22 -581,636.22 -44,913.99% PAGE 1 TCMUD No. 1 Page 84 of 101 Meeting Date: October 18, 2011 491-045-000-94000 Temporary Housing and Storage 0.00 10,500.00 3,826.07 15,538.89 (5,038.89) 148.0 491-045-000-95000 Construction 0.00 1,405,652.00 302,218.02 2,101,141.22 (695,489.22) 149.5 491-045-000-96300 Engineering 0.00 41,000.00 0.00 40,443.85 556.15 98.6 Total Fire Department 0.00 1,457,152.00 306,044.09 2,157,123.96 (699,971.96) page 1 Budget to Actual - Fire Const Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 Page 85 of 101 Meeting Date: October 18, 2011 G/L #Effective Date Description Journal #Vendor Name Vendor Invoice #Debit Credit Balance 491-045-000-94000 Temporary Housing and Storage Balance Forward 11,712.82 09/02/2011 Temporary storage 20896 Williams Scotsman, Inc 95901610 170.00 09/17/2011 Temporary storage 8/17-8/26, tear down a 20892 Modular Space Corporation 105925162 3,363.80 09/27/2011 Steve Z.22197 Bank of America 092711 292.27 Total 3,826.07 0.00 15,538.89 491-045-000-95000 Construction Balance Forward 1,798,923.20 09/01/2011 Danny Thomas 20148 JP Morgan Chase Bank NA 08062011 497.46 09/01/2011 August Charges 20856 Costco Wholesale 082611 529.98 09/02/2011 Fire Station App 14 20019 Prime Construction Co App 14 269,365.13 09/02/2011 Retainage/Prime App 14/July 20027 14,177.11 09/13/2011 Fire Station furniture/Balance due 20886 National Business Furniture, LLC CV49697 13,571.94 09/27/2011 Mike P.22197 Bank of America 092711 3,758.40 09/27/2011 Steve Z.22197 Bank of America 092711 318.00 Total 302,218.02 0.00 2,101,141.22 491-045-000-96100 Legal Balance Forward 0.00 Total 0.00 0.00 0.00 491-045-000-96300 Engineering Balance Forward 40,443.85 Total 0.00 0.00 40,443.85 491-045-000-96500 Bond Issuance Cost Balance Forward 0.00 Total 0.00 0.00 0.00 GRAND TOTAL 306,044.09 0.00 2,157,123.96 Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 TCMUD No. 1 Page 86 of 101 Meeting Date: October 18, 2011 Municipal Utility District No 1 - I & S Interim Balance Sheet Balance @ 9/30/2011 ASSETS ASSETS CASH AND CASH IN BANK -$ INVESTMENTS 107,847 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 13,591 TOTAL ASSETS 121,438$ LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS PAYABLE -$ DEFERRED REVENUE 13,591$ TOTAL LIABILITIES 13,591 FUND BALANCE DESIGNATED FOR DEBT SERVICE 107,847 TOTAL LIABILITIES AND FUND BALANCE 121,438$ September 30, 2011 12/12 Months 100% of Fiscal Year) TCMUD No. 1 Page 87 of 101 Meeting Date: October 18, 2011 Trophy Club Municipal Utility Dist #1 Budget Revenue Report To Date: 09/30/2011 From Account: 680-000-000-30100 To Account: 680-000-000-39200 Run Date: 10/13/2011 User: rgonzales Segments/Accounts Total Budget MTD Rev.YTD Rev. Total Variance Total % [FUND] 680 : Debt Service 680-000-000-30100 : Property Taxes 755,712.00 8,026.78 766,518.35 -10,806.35 -1.43% 680-000-000-30125 : Property Taxes/Delinquent 0.00 292.51 5,112.55 -5,112.55 0.00% 680-000-000-30150 : Property Taxes/Penalty & Interest 9,500.00 1,781.59 6,017.40 3,482.60 36.66% 680-000-000-35050 : Interest Income 500.00 7.47 985.38 -485.38 -97.08% 680-000-000-35170 : Building Rent 308,000.00 0.00 308,000.00 0.00 0.00% 680-000-000-38500 : PID Utility Fees 246,100.00 0.00 246,100.00 0.00 0.00% [FUND] SubTotal : 680 : Debt Service 1,319,812.00 10,108.35 1,332,733.68 -12,921.68 -0.98% Grand Total :1,319,812.00 10,108.35 1,332,733.68 -12,921.68 -0.98% PAGE 1 TCMUD No. 1 Page 88 of 101 Meeting Date: October 18, 2011 680-680-000-89000 Bond Principal 1,115,000.00 1,115,000.00 0.00 1,115,000.00 0.00 100.0 680-680-000-89100 Bond Interest 379,559.00 379,559.00 0.00 379,558.55 0.45 100.0 680-680-000-89200 Paying Agent Fees 3,500.00 3,500.00 0.00 2,460.00 1,040.00 70.3 Total Debt Service 1,498,059.00 1,498,059.00 0.00 1,497,018.55 1,040.45 page 1 Budget to Actual -Debt Service Trophy Club Municipal Utility Dist #1 For Period Ending 09/30/2011 Account #Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % TCMUD No. 1 Page 89 of 101 Meeting Date: October 18, 2011 G/L #Effective Date Description Journal #Vendor Name Vendor Invoice #Debit Credit Balance 680-680-000-89000 Bond Principal Balance Forward 1,115,000.00 Total 0.00 0.00 1,115,000.00 680-680-000-89100 Bond Interest Balance Forward 379,558.55 Total 0.00 0.00 379,558.55 680-680-000-89200 Paying Agent Fees Balance Forward 2,460.00 Total 0.00 0.00 2,460.00 GRAND TOTAL 0.00 0.00 1,497,018.55 Trophy Club Municipal Utility Dist #1 G/L Transaction Detail Report 9/30/2011 TCMUD No. 1 Page 90 of 101 Meeting Date: October 18, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:22011-143-M1 Name: Status:Type:M1 Agenda Item Draft File created:In control:10/13/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:10/18/2011 Title:Discuss and take appropriate action regarding the elevated ground storage tank. To include fencing and all related topics. Attachments:Sav-on Fence Inc. Quote email.pdf Sav-on Fence Inc. Quote for Elevated Storage Tanks.pdf Action ByDate Action ResultVer. Title Discuss and take appropriate action regarding the elevated ground storage tank. To include fencing and all related topics. TCMUD No. 1 Page 91 of 101 Meeting Date: October 18, 2011 TCMUD No. 1 Page 92 of 101 Meeting Date: October 18, 2011 TCMUD No. 1 Page 93 of 101 Meeting Date: October 18, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-144-M1 Name: Status:Type:M1 Agenda Item Draft File created:In control:10/14/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:10/18/2011 Title:Review and Approve Minutes a. September 20, 2011 - Regular Session Minutes Attachments:09202011 MUD 1 Meeting Minutes.pdf Action ByDate Action ResultVer. Title Review and Approve Minutes a. September 20, 2011 - Regular Session Minutes TCMUD No. 1 Page 94 of 101 Meeting Date: October 18, 2011 1 | Page MINUTES FROM REGULAR SESSION TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 MEETING FOR THE TOWN OF TROPHY CLUB LOCATION: 100 MUNICIPAL DRIVE, TROPHY CLUB, TEXAS Tuesday, September 20, 2011 at 7:00 P.M. Svore Municipal Building Boardroom The Trophy Club Municipal Utility District No. 1, in the Town of Trophy Club, Texas, met in Regular Session on Tuesday, September 20, 2011. The meeting was held within the boundaries of the Town and was open to the public. STATE OF TEXAS § COUNTY OF DENTON § BOARD MEMBERS PRESENT: Jim Moss President Nick Sanders Vice President Kevin Carr Secretary/Treasurer Bill Armstrong Director Jim Thomas Director STAFF AND GUEST(S) PRESENT: Robert Scott District Manager Melinda Smith Attorney Danny Thomas Fire Chief Renae Gonzales Senior Accountant Laurie Slaght Administrative Assistant Shannon DePrater Town Secretary Bill Rose Council member Liaison President Moss announced the date of September 20, 2011, called the meeting to order and announced at quorum at 7:00pm. CITIZEN PRESENTATIONS Citizens are allowed three (3) minutes to address the Board regarding an item over which the Board has policy or oversight authority as provided by Texas law, the ethics order, or other policy order. 1. Discuss and take appropriate action regarding the elevation of the ground storage tanks and citizen concerns related to the water storage facility. Director Thomas explains the reasons for needing additional storage capacity. He explains the reasons for raising the tanks instead of building a new tank. The only plausible space for a new tank is to build where the police station is now. He explains that the MUD looked at 5 different properties. Director Thomas explains that we cannot go another year with a shortage of water. This option saves the MUD a minimum of $1,000,000. The city will receive a formal letter stating that the MUD will need an additional 3 million gallons of storage. Painting the tanks is a consideration; however, changing the color of the tanks comes with a cost of $165,000. Director Armstrong arrived at 7:10pm. Shawn Murphy, 104 Summit Cove, Caroline Avery-Dahl, 110 Summit Cove, Christina Vessels – 118 Summit Cove, TCMUD No. 1 Page 95 of 101 Meeting Date: October 18, 2011 2 | Page Mr. Armstrong is willing to sit down with the residents to discuss their concerns further. Mr. Sanders discusses the finding of the plat. We have a letter from Delta Tech regarding the cost of moving the storage tank to another location. Doing this adds a minimum cost of $500,000. He explains he would be glad to give them a copy of the letter from Delta Tech. Mr. Sanders explains that the tank is being built for pressure, not only for storage. We will make repairs to fences and will review. We will not put poison down to hurt any landscaping. Lighting will be looked and find a solution that is as unobtrusive as possible. Debris and trash will be cleaned up, Robert has spoke with Town regarding this. The money received for the tanks from the developer was not used in the construction of the fire station. REPORTS & UPDATE 2. Receive District Manager's Report a. Water pumped vs. billed b. Monthly WWTP Report c. New Fire Station Construction Costs to date d. Update - Water Plant e. Update - Wastewater Plant District Manager Scott updated the Board regarding the above items and addressed the Board’s questions. We sold 40 million gallons more water than at any previous time. The water bill from Fort Worth Water is expected to be 1.6 million topping the previous high record of 1.1 million. We did not receive the TCEQ reports this month so they will be included in the October Meeting. W astewater Treatment Plant – We are making the high service pump into a VFD. There have been engineering problems with the bar screens, they have been re-designed and we have had no problems. The following PID permits were issued: 08-09 - 193, 09-10 - 209, and for the current fiscal year to date, 221 permits have been issued. 3. Receive Finance Update a. Senior Accountant Gonzales to provide the Board with a monthly update and address the Board's questions. Senior Accountant Gonzales updated the Board and addressed the Board’s questions. Passed out amended resolutions and amended budget. Changes were made in the Worker’s comp and in Mgr. Office. New auditors will be here tomorrow to start working on sampling. STW conversion has been started. This weekend financial software will be upgraded. Oct 6-7th Utility Billing will be updated. Full conversion will be complete October 29th ; online bill pay should be available shortly after. Kevin would like the fund Revenue- Emergency services to be renamed. Town Manager, Mike Slye confirms this is a PID assessment. 4. Receive Fire Update a. Fire Chief Thomas to provide Board with a monthly update and address the Board's questions. Fire Chief Thomas provided the Board with the monthly Fire Update.67 calls in August, grand opening. Many request for tours. The training facility has received lots of use. Ambulance coming from Roanoke, the ambulance took longer Robert and Chief Thomas will meet with the insurance adjuster tomorrow regarding the roof repairs. Council member Carr has concerns regarding the revenue from sending our resources to the Jack County and Possum Kingdom Lake Fires. Chief Thomas explains that part of the problem securing payment is that the fires have been declared national disasters. TCMUD No. 1 Page 96 of 101 Meeting Date: October 18, 2011 3 | Page 5. Receive Town Council Update a. Council Member Rose to provide Board with an update of Council meetings, notices, and relevant business. From the September 12th mtg., the Board approved Interlocal Agreement with TML for Health benefits program. September 19th mtg. viewed a presentation for planned development for the 26 acre track known as Beck property. It will be known as PD 13 and will be a multi use, multi story development. Vertical development could be up to 12 stories. A specific use permit was granted to sell liquor in the Regency Plaza. The store will be using the name Trophy Liquors and will be occupying the spot where Blockbuster Video was. The store is planning an early November opening. Council member Rose updated the Board and addressed the Board’s questions. 6. Receive Directors' Update a. Update regarding past month's activities Water Smart Application update from Director Thomas. Director Thomas will take all of the information back to AWBD in hopes that we can file paperwork in January. Board convened into Public Hearing at 8:21 p.m. PUBLIC HEARING Trophy Club Municipal District No. 1 to conduct a Public Hearing regarding: 7. Proposed tax rate to increase, decrease, or remain the same for the fiscal year beginning October 1, 2011 and ending September 30, 2012. No Residents Present 8. TCMUD No. 1 Budget for fiscal year beginning October 1, 2011, and ending September 30, 2012. Total revenue proposed for 2011-2012 is $5,852,997. Board reconvened into Regular Session at 8:22 p.m. REGULAR SESSION 9. Discuss and take appropriate action regarding Resolution 2011-0920 as amended, adopting and approving the Budget for Trophy Club Municipal Utility District No. 1 for fiscal year beginning October 1, 2011, and ending September 30, 2012. Motion made by Director Carr, seconded by Director Thomas to approve Resolution 2011-0920 as presented tonight, adopting and approving the Budget for Trophy Club Municipal Utility District No. 1 for fiscal year beginning October 1, 2011, and ending September 30, 2012. Motion carried unanimously. Amended to include reserves to cover deficits in General Fund and Fire Department. TCMUD No. 1 Page 97 of 101 Meeting Date: October 18, 2011 4 | Page 10. Discuss and take appropriate action regarding Resolution 2011-0920-A, fixing and levying the Trophy Club Municipal Utility District No. 1 tax rate for debt service for the fiscal year beginning October 1, 2011, and ending September 30, 2012. Motion made by Director Sanders seconded by Director Carr to approve Resolution 2011-0920-A, fixing and levying the Trophy Club Municipal Utility District No. 1 tax rate for debt service for the fiscal year beginning October 1, 2011, and ending September 30, 2012. Motion carried unanimously. 11. Discuss and take appropriate action regarding Resolution 2011-0920-B, fixing and levying the Trophy Club Municipal Utility District No. 1 tax rate for operation and maintenance, including the portion of such tax rate to support the Fire Department, for the fiscal year beginning October 1, 2011, and ending September 30, 2012. Motion made by Director Kevin Carr, seconded by Director Bill Armstrong to approve Resolution 2011- 0920-B, fixing and levying the Trophy Club Municipal Utility District No. 1 tax rate for operation and maintenance, including the portion of such tax rate to support the Fire Department, for the fiscal year beginning October 1, 2011, and ending September 30, 2012. Motion carried unanimously. 12. Discuss and take appropriate action regarding Resolution 2011-0920-C, approving the Trophy Club Municipal Utility District No. 1 tax roll of the Denton Central Appraisal District and Tarrant Appraisal District for 2011. Motion made by Director Kevin Carr, seconded by Director Sanders to approve the Trophy Club Municipal Utility District No. 1 tax roll of the Denton Central Appraisal District and Tarrant Appraisal District for 2011. Motion carried unanimously. 13. Discuss and take appropriate action regarding Resolution 2011-0920-D, of the Trophy Club Municipal Utility District No. 1 adopting a Fund Balance Policy for the District in accordance with Government Accounting Standards Board (GASB) Statement No. 54; and providing an effective date. Motion made by Director Sanders, seconded by Director Kevin Carr to approve Resolution 2011-0920-D, of the Trophy Club Municipal Utility District No. 1 adopting a Fund Balance Policy for the District in accordance with Government Accounting Standards Board (GASB) Statement No. 54; and providing an effective date. Motion carried unanimously. The Fund Balance Policy is amended to reflect a change in wording of the minimum unassigned fund balance from “equal to 35%” to “equal to or greater than 35%”. Town Manager Slye spoke of the Town’s GASB policy. 14. Discuss and take appropriate action on setting a governmental water rate for the Town of Trophy Club for FY2011-2012. Item tabled for further review. 15. Review and Approve Monthly Financial Report(s) a. August 2011 TCMUD No. 1 Page 98 of 101 Meeting Date: October 18, 2011 5 | Page Motion made by Director Kevin Carr, seconded by Director Nick Sanders to approve the August 2011 Financial Report as presented. Motion carried unanimously. 16. Set Next Meeting Date: a. October 18, 2011 - 7:00 p.m. - Regular Scheduled Meeting 17. Items for Future Agendas a. Funding of Future Capital Projects; i.e., Trinity Well No. 2 Lights on elevated tanks and cosmetic repairs to include landscape and possible fencing. Roll out of online bill pay. Use policy of the training room in the new Fire Station. Software Implementation updates. Adjourn Meeting adjourned at 9:06 p.m. TCMUD No. 1 Page 99 of 101 Meeting Date: October 18, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-139-M1 Name: Status:Type:M1 Closed Session Executive Session File created:In control:10/13/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:10/18/2011 Title:PURSUANT TO TEXAS GOVERNMENT CODE, ANNOTATED, SECTION 551.071 (1) & (2) "CONSULTATION WITH ATTORNEY", RESPECTIVELY, THE BOARD 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: 1. Legal advice relative to state reporting requirements. Attachments: Action ByDate Action ResultVer. Title PURSUANT TO TEXAS GOVERNMENT CODE, ANNOTATED, SECTION 551.071 (1) & (2) "CONSULTATION WITH ATTORNEY", RESPECTIVELY, THE BOARD 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: 1. Legal advice relative to state reporting requirements. TCMUD No. 1 Page 100 of 101 Meeting Date: October 18, 2011 100 Municipal Drive Trophy Club, Texas 76262Trophy Club Entities Legislation Details (With Text) File #: Version:12011-140-M1 Name: Status:Type:M1 Agenda Item Regular Session File created:In control:10/13/2011 Trophy Club Municipal Utility District No. 1 On agenda:Final action:10/18/2011 Title:Discuss and take appropriate action regarding Executive Session Attachments: Action ByDate Action ResultVer. Title Discuss and take appropriate action regarding Executive Session TCMUD No. 1 Page 101 of 101 Meeting Date: October 18, 2011