HomeMy WebLinkAboutNovember 20, 2012 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, November 20, 2012
*Amended
CALL TO ORDER AND ANNOUNCE A QUORUM
CITIZEN PRESENTATIONS
This is an opportunity for citizens to address the Board on any matter whether or not it
is posted on the agenda. The Board is not permitted to take action on or discuss any
presentations made to the Board at this time concerning an item not listed on the
agenda. The Board will hear presentations on specific agenda items prior to the Board
addressing those items. You may speak up to three (3) minutes or the time limit
determined by the President or presiding officer. To speak during this item you must
complete the Speaker's form that includes the topic(s) of your statement. Topics of
presentation should be limited to matters over which the Board has authority.
CONSENT AGENDA
All matters listed as Consent Agenda are considered to be routine by the Board of
Directors and will be enacted by one motion. There will not be a separate discussion of
these items. If discussion is desired, that item will be removed from the consent agenda
and will be considered separately.
1.2012-268-M1 Consider and take appropriate action to approve the Consent Agenda.
a.October 8, 2012 Special Meeting minutes
b.October 23, 2012 Regular Session Meeting Minutes
c.October check register
d.Amendment to Tax Information Form in compliance with Section 49.455 of Texas
Water Code.
October 8, 2012 Special Session Minutes.pdf
October 23, 2012 Regular Session Minutes.pdf
October Check Register.pdf
SUMMARY OF INFORMATION FORM.pdf
AMENDMENT TO INFORMATION FORM-2012-13.pdf
Attachments:
REGULAR SESSION
2.2012-276-M1 Presentation from the Wallace Group regarding the Wastewater Plant with
findings and recommendations for improvements.
Wallace Group Proposal.pdfAttachments:
Trophy Club Municipal Utility District No. 1 1 of 193 November 20, 2012
November 20, 2012Trophy Club Municipal Utility
District No. 1
Meeting Agenda
3.2012-277-M1 Consider and take appropriate action to approve proposal from the Wallace
Group for Preliminary Engineering Report for Wastewater Treatment Plant
improvements.(McKnight)
Wallace Group Engineer Proposal.pdfAttachments:
4.2012-283-M1 Consider and take appropriate action to adopt Resolution No. 2012-1120A
expressing intent to reimburse costs of wastewater improvement project(s) with
bond proceeds. (McKnight)
2012_1120A Reimbursement Resolution.pdfAttachments:
REPORTS & UPDATES
5.2012-269-M1 * Receive District Manager's Report (McKnight)
a.Water System Operation
b.Wastewater Treatment Plant
c.Roundabout Relocation Project
d.Website Update
e.Status of survey and appraisal for land near Wastewater Treatment Plant.
* f.Committed Funds
Pumped vs. Billed.pdf
Monthly Log October 2012.pdf
*Committed Funds.pdf
Attachments:
6.2012-270-M1 Receive Finance Update (Gonzales)
a.PID Connections
b.Utility Billing
PID Connections 10-2012.pdf
UB Monthly Report Oct.pdf
Attachments:
7.2012-271-M1 Receive Fire Update (Thomas)
a.October activity
2012 Oct Fire Activity Report.pdfAttachments:
8.2012-272-M1 Receive Town Council Update (Rose)
REGULAR SESSION
9.2012-290-M1 Consider and take appropriate action regarding official Town Council liaison
representation at District meetings. (Carr)
Trophy Club Municipal Utility District No. 1 2 of 193 November 20, 2012
November 20, 2012Trophy Club Municipal Utility
District No. 1
Meeting Agenda
10.2012-288-M1 Consider and take appropriate action to approve the October 2012 financials
(Gonzales)
Oct 2012 Variance.pdf
Fund Balances @ 10-31-12.pdf
October Financials.pdf
Attachments:
11.2012-273-M1 Consider and take appropriate action to adopt amended Rate Order No.
2012-1120, and amend Section 1.07 to increase the cost of a one inch meter to
the actual cost. (McKnight)
Rate Order Section 1.07 Meter & Tap Fees.pdfAttachments:
12.2012-284-M1 Consider and take appropriate action to determine the status of funding for
Harmony Park. (McKnight)
Harmony Park - letter from Town Manager.pdfAttachments:
13.2012-274-M1 Consider and take appropriate action to approve Resolution No. 2012-1120B
authorizing District Participation in the Texas County and District Retirement
System (TCDRS) effective January 1, 2013 and authorizing the District Manager
to execute all related and necessary documents. (McKnight)
2012 District GTL Authorization.pdf
2012 Acknowledgement of Condition Governing TCDRS Participation.pdf
Unfunded Liability Savings 112012.pdf
790 Trophy Club MUD Resolution 1120B w No UAAL Payment 11072012.pdf
790 Trophy Club MUD Resolution 1120B w 25% UAAL Payoff .pdf
790 Trophy Club MUD Resolution 1120B w 50% UAAL Payoff 11072012.pdf
790 Trophy Club MUD Resolution 1120B w 75% UAAL Payoff 11072012.pdf
790 Trophy Club MUD Resolution 1120B w 100% UAAL Payoff 11072012.pdf
Attachments:
14.2012-275-M1 Consider and take appropriate action to approve Resolution No. 2012-1120C
committing reserve funds for September 2013 bond call. (Thomas)
Par Values Bonds as of 9-30-12.pdf
2012_1120C Resolution to Commit Funds.pdf
Attachments:
15.2012-278-M1 Consider and take appropriate action regarding purchase of Google Earth and a
large format printer. (Armstrong)
16.2012-279-M1 Consider and take appropriate action to appoint a committee to review proposed
Personnel Policy Handbook. (McKnight)
Trophy Club Municipal Utility District No. 1 3 of 193 November 20, 2012
November 20, 2012Trophy Club Municipal Utility
District No. 1
Meeting Agenda
17.2012-282-M1 Consider and take appropriate action to award the bid for the purchase of trucks
for the Wastewater Treatment Plant. (Schlielig)
WWTP Work Truck Summary 1112.pdf
Wastewater Vehicle Proposals 1112.pdf
Wastewater Vehicle Specs 1112.pdf
Attachments:
CONVENE INTO CLOSED SESSION
18.2012-285-M1 Consultation with the District’s Attorney 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 conflicts with the Open
Meetings Act, pursuant to Section 551.071(2) of the Texas Open Meetings Act:
- Matters related to a Certificate of Convenience and Necessity
RECONVENE INTO REGULAR SESSION
19.2012-286-M1 Consider and take appropriate action regarding item(s) discussed Closed
Session.
20.2012-280-M1 Recommendations for future agenda item(s):
Future Agenda Items.pdfAttachments:
21.2012-281-M1 Set next meeting date: December 17, 2012 7:00 p.m.
ADJOURN
* THE BOARD RESERVES THE RIGHT TO ADJOURN INTO A CLOSED SESSION AT
ANY TIME DURING THE MEETING FOR THE PURPOSE OF SEEKING THE ADVICE OF
ITS ATTORNEY ABOUT ANY ITEM ON THE AGENDA OR THAT ARISES AT THE
MEETING, PURSUANT TO SECTION 551.071 OF THE TEXAS GOVERNMENT CODE.
Trophy Club Municipal Utility District No. 1 4 of 193 November 20, 2012
November 20, 2012Trophy Club Municipal Utility
District No. 1
Meeting Agenda
CERTIFICATION)
THE STATE OF TEXAS)
COUNTY OF DENTON)
COUNTY OF TARRANT)
THIS CERTIFIES THAT ON NOVEMBER 16, 2012 BY 4 P.M., A COPY OF THE ABOVE
NOTICE OF A MEETING OF THE TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
TO BE HELD ON NOVEMBER 20, 2012, WAS POSTED ON THE FRONT WINDOW OF
THE TROPHY CLUB M.U.D. ADMINISTRATION BUILDING, 100 MUNICIPAL DRIVE,
TROPHY CLUB, TEXAS, WHICH IS A PLACE CONVENIENT TO THE PUBLIC WITHIN
THE BOUNDARIES OF THE DISTRICT, AND A COPY WAS ALSO PROVIDED TO THE
COUNTY CLERKS OF DENTON AND TARRANT COUNTIES, TO BE POSTED ON THEIR
WEBSITE AND/OR A BULLETIN BOARD AT A PLACE CONVENIENT TO THE PUBLIC
IN SUCH COUNTY COURT HOUSES, PURSUANT TO SECTION 49.063 OF THE WATER
CODE AND SECTION 551.054 OF THE OPEN MEETINGS ACT, CHAPTER 551 TEXAS
GOVERNMENT CODE.
____________________________________________
LAURIE SLAGHT, DISTRICT SECRETARY
THIS FACILITY IS WHEELCHAIR ACCESSIBLE AND ACCESSIBLE PARKING SPACES
ARE AVAILABLE. REQUESTS FOR ACCOMMODATIONS OR INTERPRETATIVE
SERVICES MUST BE MADE 48 HOURS PRIOR TO THIS MEETING. PLEASE CONTACT
LAURIE SLAGHT AT 682-831-4685 OR FAX YOUR REQUEST TO 817- 491-9312.
I certify that the attached notice and agenda of items to be considered by this Board
was removed by me from the front window of the Svore Municipal Building, 100
Municipal Drive, Trophy Club, Texas, on the __________ day of
______________________, 2012.
________________________________, Title: ___________________________
Trophy Club Municipal Utility District No. 1 5 of 193 November 20, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:22012-268-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:11/7/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:11/20/2012
Title:Consider and take appropriate action to approve the Consent Agenda.
a.October 8, 2012 Special Meeting minutes
b.October 23, 2012 Regular Session Meeting Minutes
c.October check register
d.Amendment to Tax Information Form in compliance with Section 49.455 of Texas Water Code.
Attachments:October 8, 2012 Special Session Minutes.pdf
October 23, 2012 Regular Session Minutes.pdf
October Check Register.pdf
SUMMARY OF INFORMATION FORM.pdf
AMENDMENT TO INFORMATION FORM-2012-13.pdf
Action ByDate Action ResultVer.
Title
Consider and take appropriate action to approve the Consent Agenda.
a.October 8, 2012 Special Meeting minutes
b.October 23, 2012 Regular Session Meeting Minutes
c.October check register
d.Amendment to Tax Information Form in compliance with Section 49.455 of Texas Water Code.
Trophy Club Municipal Utility District No. 1 6 of 193 November 20, 2012
SPECIAL SESSION MINUTES FROM
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
BOARD OF DIRECTORS
100 MUNICIPAL DRIVE, TROPHY CLUB, TEXAS
October 8, 2012 at 2:30 P.M.
Svore Municipal Building Boardroom
The Board of Directors of the Trophy Club Municipal Utility District No. 1, of Denton and Tarrant Counties,
met in Special Session on Monday, October 8, 2012 at 2:30 P.M., in the Boardroom of the Administration
Building, 100 Municipal Drive, Trophy Club, Texas 76262. The meeting was held within the boundaries of
the District, and was open to the public.
STATE OF TEXAS §
COUNTY OF DENTON §
COUNTY OF TARRANT §
MUD 1 BOARD MEMBERS PRESENT
Nick Sanders President
Jim Thomas Vice President
Kevin Carr Secretary/Treasurer
Bill Armstrong Director
Jim Moss Director
STAFF PRESENT:
Jennifer McKnight District Manager
Pam Liston MUD Attorney
Laurie Slaght MUD Secretary
Danny Thomas Fire Chief
Bill Rose Town Council Liaison
President Sanders announced the date of October 8, 2012, called the meeting to order and announced a
quorum present at 2:33 p.m.
Director Armstrong arrived at 2:42 p.m.
1. Consider and take appropriate action regarding operational oversight of the Fire Department
and development of an Interlocal agreement with the Town of Trophy Club.
District Manager McKnight stated she would like clarification and direction from the Board regarding the
language for the Interlocal agreement with the Town of Trophy Club for the employees of the Fire
Department.
Chief Thomas stated that he has spoken with all the Fire Department personnel and they would like to
stay with the Town for benefits and Human Resource support.
Motion is made by Director Carr, seconded by Vice President Thomas to draft the Interlocal Agreement to
have the District reimburse the Town for 51% of salary and benefits for the Fire Department personnel,
with operational control of the Fire Department remaining as it is today with the Fire Chief reporting to the
District Manager.
Motion carried unanimous
Trophy Club Municipal Utility District No. 1
October 8, 2012 Special Session Minutes
1 of 2Trophy Club Municipal Utility District No. 1 7 of 193 November 20, 2012
2. Consider and take appropriate action regarding protection of water services to territories within
Trophy Club Municipal Utility District No. 1. (Thomas)
President Sanders stated that the developer in Westlake has asked to obtain water and wastewater
services from the Town of W estlake.
Vice President Thomas and Director Armstrong would like to take any action necessary to preserve and
protect the Districts right to service that property.
Kevin would like to have Nick and Jennifer meet with Mr. Moayedi to discuss water and wastewater
service to the new development in Solana. Director Moss would like Vice President Thomas to be
included in the meeting.
Direction is given to the District Manager and Directors. No motion is made.
President Sanders, Vice President Thomas and District Manager McKnight will set up meetings with
Centurion American and Town of Westlake.
3. Consider and take appropriate action to approve amended cost share agreement with developer
of Canterbury Hills, Phase 1B. (McKnight)
District Manager McKnight explained to the Board that the cost share agreement with the developer of
Canterbury Hills, Phase 1B, needed to be amended as there was an agreement signed in 2007. The
amended agreement clarifies that the payment would be made in accordance with the original agreement
in the amount of $90,000.
Motion is made by Secretary Treasurer Carr, seconded by Director Moss, to approve the amended
cost share agreement with the developer of Canterbury Hills, Phase 1B.
Motion is unanimous.
ADJOURN
Meeting adjourned at 3:06 p.m.
___________________________
Nick Sanders,
MUD 1 President
____________________________ (SEAL)
Kevin R. Carr,
MUD 1 Secretary/Treasurer
____________________________
Laurie Slaght,
MUD 1 Secretary
Trophy Club Municipal Utility District No. 1
October 8, 2012 Special Session Minutes
2 of 2Trophy Club Municipal Utility District No. 1 8 of 193 November 20, 2012
SPECIAL SESSION MINUTES FROM
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
BOARD OF DIRECTORS
100 MUNICIPAL DRIVE, TROPHY CLUB, TEXAS
October 23, 2012 at 7 P.M.
Svore Municipal Building Boardroom
The Board of Directors of the Trophy Club Municipal Utility District No. 1, of Denton and Tarrant Counties,
met in Regular Session on Tuesday, October 23, 2012 at 7 P.M., in the Boardroom of the Administration
Building, 100 Municipal Drive, Trophy Club, Texas 76262. The meeting was held within the boundaries of
the District, and was open to the public.
STATE OF TEXAS §
COUNTY OF DENTON §
COUNTY OF TARRANT §
MUD 1 BOARD MEMBERS PRESENT
Nick Sanders President
Jim Thomas Vice President
Kevin Carr Secretary/Treasurer
Bill Armstrong Director
Jim Moss Director
STAFF PRESENT:
Jennifer McKnight District Manager
Pam Liston MUD Attorney
Laurie Slaght MUD Secretary
Adrian Womack Utility Superintendent
Renae Gonzales Finance Manager
Terri Sisk Human Resource Manager/Financial Analyst
Karl Schlielig Wastewater Superintendent
Danny Thomas Fire Chief
President Sanders announced the date of October 23, 2012, called the meeting to order and announced
a quorum present at 7:03 p.m.
Citizen Presentations - No Citizens addressed the Board.
1.Consider and take appropriate action to approve the Consent Agenda a. September 18, 2012 meeting minutes
b. September Check Register
c. Consider and take appropriate action to approve Resolution No. 2012-1023-A approving Terri
Sisk as an authorized user on Texpool accounts.
d. Fiscal Year 2012 Fourth Quarter Investment Report
Item c. is removed from the Consent Agenda by Secretary/Treasurer Carr to be considered separately.
Motion to approve the consent agenda items a., b., and d. made by Vice President Thomas, seconded by
Secretary/Treasurer Carr.
Motion carried unanimously
Trophy Club Municipal Utility District No. 1
October 23, 2012 Regular Session Minutes
1 of 5Trophy Club Municipal Utility District No. 1 9 of 193 November 20, 2012
Item c. from the Consent agenda is brought back for consideration from the Board.
c. Consider and take appropriate action to approve Resolution No. 2012-1023-A approving Terri
Sisk as an authorized user on Texpool accounts.
Motion to approve Resolution No. 2012-1023-A approving Terri Sisk as an authorized user on Texpool
Accounts, made by Secretary/Treasurer Carr, seconded by Director Moss.
Motion carried unanimously
REPORTS & UPDATES
2.Receive District Manager's Report a.Water System Operation
b.Wastewater Treatment Plant
c.Roundabout water/sewer line relocation
d.Canterberbury Hills Phase 1B Lift Station access
e.Introduction of new Financial Analyst/Human Resources Manager
e. District Manager McKnight introduced Terri Sisk to the Board as the new Human Resources
Manager/Financial Analyst. Terri thanked the Board and staff for the warm welcome she has received.
d. Lift Station 1B: District Manager McKnight will request a formal access agreement for Lift Station 1B
from the town.
Secretary/Treasurer Carr asked District Manager McKnight to elaborate on the request from
Councilmember Rose to install more aesthetically pleasing cover to the lift stations to throughout Trophy
Club. District Manager McKnight and Utility Superintendent Womack will be taking Councilmember Rose
on a tour of the lift stations this week. McKnight further stated that the lift station in question has a scada
tower and to protect the scada equipment and the public, the secured fencing for that lift station is a
necessity.
c. Roundabout – District Manager McKnight stated that we are waiting for construction of the project to be
completed at which time the two lanes will be shut to camera the line. If the belly is larger than 3”, the
contractor will be required to open cut and replace the sewer line.
b. The wastewater treatment plant has met all permit requirements for effluent.
a. Water system – A meeting has been set up with the City of Fort W orth to discuss upgrading our 10”
meter to either a 12” or 16” meter.
3.Receive Finance Update
a.PID Connections
b.Utility Billing
Finance Manager Gonzales stated that there were 31 PID connections for the month of September
bringing the total connections for the FY 2012 to 285. The total PID connections since the beginning are
910. The Utility Billing Department continues to see more customers signing up for e-bills and bank
drafts. Gonzales stated that the auditors will be here the week of November 5, 2012. President Sanders
would like staff to consider new ways to inform residents of payment options.
Trophy Club Municipal Utility District No. 1
October 23, 2012 Regular Session Minutes
2 of 5Trophy Club Municipal Utility District No. 1 10 of 193 November 20, 2012
4.Receive Fire Update
a.September activity
b.Quint repairs
c.Lighting for the exterior of the Fire Station
Chief Thomas stated the Department took 848 calls for the fiscal year. 377 of those calls were EMS and
remaining calls were Fire. Thomas stated 99 calls were for mutual aid and 20 were received.
Secretary/Treasurer Carr would like Chief Thomas to review the numbers in his reports as some totals do
not add up correctly.
Total costs for repairs to the Quint ladder truck were $15,476.13. TML-IRP made an initial payment of
$10,239.43 and made an additional payment on the repairs of $3,941.02.
The back lighting of the lettering on the Fire Station is complete. Total cost for the project was $305.00.
5.Receive update on MUD Website
District Manager McKnight stated that there is a meeting on Thursday to review progress and determine if
there need to be any changes in the layout. Staff continues to upload content to the new site. McKnight
stated that logo will need some modification and that the online bill pay will be shut down on October 28
to update the SSL certificate. McKnight stated that the new site will launch on November 1.
6.Receive Town Council Update
President Sanders read the update from Councilmember Rose as he was not in attendance.
REGULAR SESSION
7.Consider and take appropriate action to approve the September 2012 financials
Motion to approve the September 2012 Financials is made by Secretary/Treasurer Carr, seconded by
Director Armstrong
Motion carried unanimously
8.Consider and take appropriate action to approve Resolution No. 2012-1023,allowing Trophy Club
Municipal Utility District No. 1 to participate in the Cooperative Purchasing Program of the Texas
Comptroller of Public Accounts Pursuant to Section 271.081 of the Local Government Code.
Motion was made by Vice President Thomas, seconded by Director Armstrong, to approve Resolution No.
2012-1023, allowing Trophy Club Municipal Utility District No. 1 to participate in the Cooperative
Purchasing Program of the Texas Comptroller of Public Accounts pursuant to Section 271.081 of the
Local Government Code.
Motion carried unanimously
Trophy Club Municipal Utility District No. 1
October 23, 2012 Regular Session Minutes
3 of 5Trophy Club Municipal Utility District No. 1 11 of 193 November 20, 2012
9. Consider and take appropriate action to approve the purchase of a new waste pump for the
waste water plant. (McKnight)
District Manager explains the bid of $25,900 for the waste pump and also why the bid is more than the
budgeted $8,000. The money will have to be moved from other items to cover this cost. District Manager
McKnight recommends moving forward with this bid.
Motion was made by Secretary/Treasurer Carr, seconded by Director Armstrong, to approve the purchase
of the new wastewater pump for the wastewater plant for a cost of $25,900.
Directors Sanders, Moss, Thomas and Carr state that if the plant is in need of the new blanket, they need
to purchase it.
For: President Sanders, Secretary/Treasurer Carr, Director Moss, and Director Armstrong
Abstain: Vice President Thomas
Motion Passed
10.Consider and take appropriate action regarding funds of $42,500 granted to the Town of Trophy
Club for Harmony Park.
Director Moss stated Town did not accept the grant that the funds would go into the Towns General fund
instead of being used for parks. He stated that Councilmember Mayer had sent an email to the Board
that the Town did not want the money and would not take it. Also the council stated that they would like
to have an Interlocal agreement in place to accept funding from the MUD.
Director Moss makes the motion to withdraw the grant of $42,500, Secretary/Treasurer Carr seconded.
Vice President Thomas and Director Armstrong would like to table the item so the Town can explain what
their stance is on this issue.
Secretary/Treasurer Carr would like to see a thorough presentation for the money before the board
commits to the funding. Director Moss has no objections to helping parks but would like to make sure
that the money is going to the Parks Department; he does not want the money going into the Town
general fund.
Secretary/Treasurer Carr withdraws his second of the primary motion. Original motion is withdrawn
byDirector Moss.
Motion is made by Secretary/Treasurer Carr and seconded by Vice President Thomas to table this
agenda item until such time that the Town and Parks are able to present more information to the Board.
The District Manager is instructed not to distribute funds at this time.
Motion carried unanimously
CONVENE INTO CLOSED SESSION at 8:28 pm.
11.Consultation with the District's Attorney on a matter in which the duty of the Attorney to the
Governmental Body under the Disciplinary Rules of Professional Conduct of the State Bar of
Texas clearly conflicts with the Open Meetings Act, Pursuant to Section 551.071 (2): of the Texas
Open Meetings Act:
a. Interlocal Agreement with the Town of Trophy Club for Contractual Personnel Services
b. Interlocal Agreement with the Town of Trophy Club for Fire Services Employee Contractual Services
Trophy Club Municipal Utility District No. 1
October 23, 2012 Regular Session Minutes
4 of 5Trophy Club Municipal Utility District No. 1 12 of 193 November 20, 2012
RECONVENE INTO REGULAR SESSION at 9:48 p.m.
12.Consider and take appropriate action regarding Closed Session items.
No action is taken
13.Future agenda item(s):
Grant of $42,500 to the Parks and Recreation Department
License for Google Earth, and large format printer
Audit Committee selection
14.Set next meeting date:
Special Meeting - Monday, November 5, 2012 at 10:30 a.m.
Regular Meeting - Tuesday, November 20, 2012 at 7:00 p.m.
ADJOURN
Meeting adjourned at 9:52 p.m .
___________________________
Nick Sanders,
MUD 1 President
____________________________ (SEAL)
Kevin R. Carr,
MUD 1 Secretary/Treasurer
____________________________
Laurie Slaght,
MUD 1 District Secretary
Trophy Club Municipal Utility District No. 1
October 23, 2012 Regular Session Minutes
5 of 5Trophy Club Municipal Utility District No. 1 13 of 193 November 20, 2012
Trophy Club Municipal Utility District No. 114 of 193November 20, 2012
Trophy Club Municipal Utility District No. 115 of 193November 20, 2012
Trophy Club Municipal Utility District No. 116 of 193November 20, 2012
Consent Agenda (Item #1 d)
Information Document and Notice to Purchaser
Summary
Each year the District is required by Section 49.455 of the Texas water Code to complete the forms
included in your packet related to the tax rate set by the District. The forms must be submitted to each
County (Tarrant and Denton) that collects taxes on the District’s behalf. Additionally, the forms must be
submitted to TCEQ. These forms were not submitted to the Counties or to TCEQ last year and need to be
submitted as soon as possible to correct the issue.
§ 49.455. FILING INFORMATION. (a) The board covered by the provisions of
Section 49.452 shall file with the county clerk in each of the counties in
which all or part of the district is located a duly affirmed and acknowledged
information form that includes the information required in Subsection (b),
and a complete and accurate map or plat showing the boundaries of the
district.
(c) The information form and map or plat required by this section shall be
signed by a majority of the members of the board and by each such officer
affirmed and acknowledged before it is filed with the county clerk, and each
amendment made to an information form or map shall also be signed by the
members of the board and by each such officer affirmed and acknowledged
before it is filed with the county clerk.
(j) A copy of all information forms, maps, or plats and amendments to these
filed under this section shall also be filed with the executive director.
(EXECUTIVE DIRECTOR REFERS TO TCEQ)
Trophy Club Municipal Utility District No. 1 17 of 193 November 20, 2012
AMENDMENT TO INFORMATION FORM
FOR
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
STATE OF TEXAS §
COUNTY OF DENTON §
COUNTY OF TARRANT §
We, the undersigned, constituting a majority of the members of the Board of Directors of Trophy
Club Municipal Utility District No. 1 (the "District") of Denton and Tarrant County, Texas, do
hereby make and execute this Amendment to the Information Form in compliance with Section
49.455, Texas Water Code, as amended. We do hereby certify as follows:
3. Tax Rate. The most recent rate of the District taxes on property located in the District
and not exempted by the Constitution of the State, valid State laws, or District order or
regulation, is as follows:
$0.13339 on each $100 of assessed valuation (tax rate for 2012
as approved by the Board of Directors of the District on
October 23, 2012.)
8. Form of Notice to Purchasers. The particular form of Notice to Purchasers required
by Section 49.452 of the Texas Water Code to be furnished by a seller to a purchaser of real
property in the District, with all information required to be furnished by the District completed,
is attached hereto as Exhibit 1, and is thereby made a part of this Information Form for all
purposes.
WITNESS OUR HANDS this the 20th day of November 2012.
____________________________
Nick Sanders, President
____________________________
Jim Thomas, Vice President
____________________________
Kevin R. Carr, Secretary/Treas.
(District Seal) ____________________________
Bill Armstrong, Director
____________________________
Jim Moss, Director
Trophy Club Municipal Utility District No. 1 18 of 193 November 20, 2012
STATE OF TEXAS §
COUNTY OF DENTON §
COUNTY OF TARRANT §
BEFORE ME, the undersigned, a Notary Public in and for said County and State,
on this day personally appeared Nick Sanders, Jim Thomas, Kevin Carr, Bill Armstrong and Jim
Moss known to me to be the persons and officers whose names are subscribed to the foregoing
instrument, and affirmed and acknowledged that said instrument is correct and accurate to the
best of their knowledge and belief and that they executed the same for the purposes and in the
capacity therein stated.
GIVEN UNDER MY HAND AND SEAL OF OFFICE this 20th day of
November 2012.
(SEAL)
___________________________
Laurie Slaght, District Secretary,
Notary Public
My Commission Expires:
Trophy Club Municipal Utility District No. 1 19 of 193 November 20, 2012
NOTICE TO PURCHASERS
IN TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
(Pursuant to Texas Water Code, Section 49.452)
(as of October 18, 2012)
The real property, described below, that you are about to purchase is located in the
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 (the "District," as consolidated with
Trophy Club Municipal Utility District No. 2 as of May 9, 2009). The consolidated District has
taxing authority separate from any other taxing authority and may, subject to voter approval,
issue an unlimited amount of bonds and levy an unlimited rate of tax in payment of such bonds.
As of this date, the rate of taxes levied by the consolidated District on real property located in the
District is $0.13339 (for the 2012 tax year) on each $100 of assessed valuation.
The total amount of bonds, excluding refunding bonds and any bonds or any portion of
bonds issued that are payable solely from revenues received or expected to be received under a
contract with a governmental entity, approved by the voters and which have been or may, at this
date, be issued by the consolidated District is $29,094,217 (of which $5,769,217 of bonds
approved by the voters has not yet been issued), and the aggregate initial principal amounts of
all bonds issued for one or more of the specified facilities of the consolidated District and payable
in whole or in part from property taxes is $23,325,000 (of which the total principal amount of
bonds outstanding at this time is $6,555,000).
The District also has the authority (under restrictive covenants applicable to certain
property in the District) to adopt and impose a standby fee on property in the District that has
water, sanitary sewer, or drainage facilities and services available but not connected and which
does not have a house, building, or other improvement located thereon and does not
substantially utilize the utility capacity available to the property. The District may exercise the
authority without holding an election on the matter. As of this date, the most recent amount of
the standby fee is $6.00 per lot, per month. An unpaid standby fee is a personal obligation of
the person that owned the property at the time of imposition and is secured by a lien on the
property. Any person may request a certificate from the District stating the amount, if any, of
unpaid standby fees on a tract of property in the District.
The District is located in part within the corporate boundaries of the Town of Trophy Club
(a home-rule municipality), in part within the corporate boundaries of the Town of Westlake (a
general-law municipality), in part within the extraterritorial jurisdiction of the Town of Trophy Club,
and in part within the extraterritorial jurisdiction of the Town of Westlake. With respect to
property located within the corporate boundaries of a municipality, the taxpayers of the District
are subject to the taxes imposed by the municipality and by the District until the District is
dissolved. By law (Texas Local Government Code, Section 43.076(d)), a district located wholly
in two or more municipalities and in unincorporated area may be abolished by agreement among
the district and all of the municipalities in which parts of the district are located, and without the
consent of the voters of the district.
The purpose of this District is to provide water and sanitary sewer facilities and services and
fire-fighting facilities and activities within the District through the issuance of bonds payable in
whole or in part from property taxes. The cost of these utility facilities is not included in the
purchase price of your property, and these utility and fire-fighting facilities are owned or to be
owned by the District.
Trophy Club Municipal Utility District No. 1 20 of 193 November 20, 2012
The legal description of the property you are acquiring is as follows:
_____________________________________________________________________________
______________________________________________________________.
____________________________________ ____________________
Signature of Seller Date
NOTARY ACKNOWLEDGMENT FOR SELLER:
THE STATE OF TEXAS)
COUNTY OF ________ )
This instrument was acknowledged before me on ________________________, 20___,
by _____________________________________.
[seal] ___________________________________
Notary Public, State of Texas
My commission expires: ________
PURCHASER IS ADVISED THAT THE INFORMATION SHOWN ON THIS FORM IS
SUBJECT TO CHANGE BY THE DISTRICT AT ANY TIME. THE DISTRICT ROUTINELY
ESTABLISHES TAX RATES DURING THE MONTHS OF SEPTEMBER THROUGH
DECEMBER OF EACH YEAR, EFFECTIVE FOR THE YEAR IN WHICH THE TAX RATES ARE
APPROVED BY THE DISTRICT. PURCHASER IS ADVISED TO CONTACT THE DISTRICT
TO DETERMINE THE STATUS OF ANY CURRENT OR PROPOSED CHANGES TO THE
INFORMATION SHOWN ON THIS FORM.
The undersigned purchaser hereby acknowledges receipt of the foregoing notice at or
prior to execution of a binding contract for the purchase of the real property described in such
notice or at closing of purchase of the real property.
___________________________________ ____________________
Signature of Purchaser Date
Trophy Club Municipal Utility District No. 1 21 of 193 November 20, 2012
NOTARY ACKNOWLEDGMENT FOR PURCHASER:
STATE OF TEXAS §
COUNTY OF DENTON §
COUNTY OF TARRANT §
This instrument was acknowledged before me on ________________________, 20____,
by _____________________________________.
_____________________________ (SEAL)
Notary Public, State of Texas
My commission expires: ________________
For Further Information Contact:
Trophy Club Municipal Utility District No. 1
100 Municipal Drive
Trophy Club, TX 76262
682.831.4685
Trophy Club Municipal Utility District No. 1 22 of 193 November 20, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:12012-276-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:11/7/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:11/20/2012
Title:Presentation from the Wallace Group regarding the Wastewater Plant with findings and
recommendations for improvements.
Attachments:Wallace Group Proposal.pdf
Action ByDate Action ResultVer.
Title
Presentation from the Wallace Group regarding the Wastewater Plant with findings and recommendations for
improvements.
Trophy Club Municipal Utility District No. 1 23 of 193 November 20, 2012
Trophy Club Municipal Utility District No. 1 24 of 193 November 20, 2012
Trophy Club Municipal Utility District No. 1 25 of 193 November 20, 2012
Trophy Club Municipal Utility District No. 1 26 of 193 November 20, 2012
Trophy Club Municipal Utility District No. 1 27 of 193 November 20, 2012
Trophy Club Municipal Utility District No. 1 28 of 193 November 20, 2012
Trophy Club Municipal Utility District No. 1 29 of 193 November 20, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:12012-277-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:11/7/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:11/20/2012
Title:Consider and take appropriate action to approve proposal from the Wallace Group for Preliminary
Engineering Report for Wastewater Treatment Plant improvements.(McKnight)
Attachments:Wallace Group Engineer Proposal.pdf
Action ByDate Action ResultVer.
Title
Consider and take appropriate action to approve proposal from the Wallace Group for Preliminary Engineering
Report for Wastewater Treatment Plant improvements.(McKnight)
Trophy Club Municipal Utility District No. 1 30 of 193 November 20, 2012
Trophy Club Municipal Utility District No. 131 of 193November 20, 2012
Trophy Club Municipal Utility District No. 132 of 193November 20, 2012
Trophy Club Municipal Utility District No. 133 of 193November 20, 2012
Trophy Club Municipal Utility District No. 134 of 193November 20, 2012
Trophy Club Municipal Utility District No. 135 of 193November 20, 2012
Trophy Club Municipal Utility District No. 136 of 193November 20, 2012
Trophy Club Municipal Utility District No. 137 of 193November 20, 2012
Trophy Club Municipal Utility District No. 138 of 193November 20, 2012
Trophy Club Municipal Utility District No. 139 of 193November 20, 2012
Trophy Club Municipal Utility District No. 140 of 193November 20, 2012
Trophy Club Municipal Utility District No. 141 of 193November 20, 2012
Trophy Club Municipal Utility District No. 142 of 193November 20, 2012
Trophy Club Municipal Utility District No. 143 of 193November 20, 2012
Trophy Club Municipal Utility District No. 144 of 193November 20, 2012
Trophy Club Municipal Utility District No. 145 of 193November 20, 2012
Trophy Club Municipal Utility District No. 146 of 193November 20, 2012
Trophy Club Municipal Utility District No. 147 of 193November 20, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:12012-283-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:11/13/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:11/20/2012
Title:Consider and take appropriate action to adopt Resolution No. 2012-1120A expressing intent to
reimburse costs of wastewater improvement project(s) with bond proceeds. (McKnight)
Attachments:2012_1120A Reimbursement Resolution.pdf
Action ByDate Action ResultVer.
Title
Consider and take appropriate action to adopt Resolution No. 2012-1120A expressing intent to reimburse costs
of wastewater improvement project(s) with bond proceeds. (McKnight)
Trophy Club Municipal Utility District No. 1 48 of 193 November 20, 2012
RESOLUTION NO. 2012-1120A
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 RESOLUTION EXPRESSING OFFICIAL INTENT TO REIMBURSE WITH PROCEEDS OF OBLIGATIONS ISSUED TO FINANCE IMPROVEMENTS TO THE DISTRICT'S WASTEWATER TREATMENT SYSTEM DEEMED NECESSARY TO PROVIDE WASTEWATER SERVICE TO CUSTOMERS OF THE DISTRICT
WHEREAS, the Board of Directors of Trophy Club Municipal Utility No. 1, (the
“District”) desires to finance the costs of improving, constructing, reconstruction and/or equipping of
wastewater treatment facilities as provided in Exhibit A to Resolution 2012-1120A of the District and
incorporated herein (the “Project”);
WHEREAS, the District intends to finance the improving, construction, reconstruction
and/or equipping of the Project or portions of the Project with the proceeds of the sale of general
obligation bonds or other forms of debt, the interest upon which is excluded from gross income for federal
income tax purposes (the “Obligations”); and
WHEREAS, prior to the issuance of the Obligations the District desires to incur certain
capital expenditures (the “Expenditures”) with respect to the Project from available moneys of the
District; and
WHEREAS, the Board of Directors has determined that those moneys to be advanced on
and after the date hereof to pay the Expenditures are available only for a temporary period and it is
necessary to reimburse the District for the Expenditures from the proceeds of the Obligations;
WHEREAS, the District finds, considers, and declares that the reimbursement of the
District for the payment of such expenditures will be appropriate and consistent with the lawful objectives
of the District and, as such, chooses to declare its intention to reimburse itself for such payments at such
time as it issues obligations to finance the Projects, as permitted by Section 1201.042(c) of the Texas
Government Code;
NOW, THEREFORE, THE BOARD OF DIRECTORS OF TROPHY CLUB
MUNICIPAL UTILITY DISTRICT NO. 1, DOES HEREBY RESOLVE, ORDER, AND
DETERMINE AS FOLLOWS:
SECTION 1. The District hereby states its intention and reasonably expects to reimburse
Project costs incurred prior to the issuance of the Obligations with proceeds of the Obligations. Exhibit B
to Resolution 2012-1120A describes the general character, type, purpose, and function of the Project.
SECTION 2. The reasonably expected maximum principal amount of the Obligations
is $4,000,000.
SECTION 3. This resolution is being adopted not later than 60 days after the
payment of the original Expenditures (the “Expenditures Dates or Dates”).
SECTION 4. As required by Section 1201.042(c) of the Texas Government Code, all
costs to be reimbursed will be attributable to the Project, and the District will reimburse itself for such
costs promptly following the issuance of obligations issued by the District to finance the Project.
Trophy Club Municipal Utility District No. 1 49 of 193 November 20, 2012
SECTION 5. This resolution is consistent with the budgetary and financial
circumstances of the District, as of the date hereof. No moneys from sources other than the Obligations
are, or are reasonably expected to be reserved, allocated on a long-term basis, or otherwise set aside by the
District (or any related party) pursuant to their budget or financial policies with respect to the Project
costs. To the best of our knowledge, this Board is not aware of the previous adoption of official
intents by the District that have been made as a matter of course for the purpose of reimbursing
expenditures and for which tax-exempt obligations have not been issued.
SECTION 6 . This resolution is adopted as official action of the District in order to
comply with Section 1201.042(c) of the Texas Government Code and any other regulations relating to the
qualification for reimbursement of District expenditures incurred prior to the date of issue of the
Obligations.
SECTION 7 . All the recitals in this resolution are true and correct and this Board of
Directors so finds, determines and represents.
ADOPTED, SIGNED AND APPROVED this 20th day of November 20, 2012.
TROPHY CLUB MUNICIPAL UTILITY
DISTRICT NO. 1
By
Nick Sanders, Board President
Attest:
Kevin R. Carr, Board Secretary/Treasurer Trophy Club Municipal Utility District No. 1 50 of 193 November 20, 2012
Trophy Club Municipal Utility District No. 1 51 of 193 November 20, 2012
Trophy Club Municipal Utility District No. 1 52 of 193 November 20, 2012
Trophy Club Municipal Utility District No. 1 53 of 193 November 20, 2012
Trophy Club Municipal Utility District No. 1 54 of 193 November 20, 2012
Trophy Club Municipal Utility District No. 1 55 of 193 November 20, 2012
Trophy Club Municipal Utility District No. 1 56 of 193 November 20, 2012
CERTIFICATE FOR RESOLUTION 2012-1120A
STATE OF TEXAS § COUNTY OF DENTON § COUNTY OF TARRANT §
I, the undersigned Secretary of TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1, TROPHY CLUB, TEXAS (the "District"), hereby certify as follows:
1. The Board of Directors of Trophy Club Municipal Utility District No. 1 convened in a meeting on the 20th day of November, 2012, at the designated meeting place, and the roll was called of the duly constituted directors of said Board, to-wit:
Nick Sanders, President Jim Thomas, Vice President Kevin Carr, Secretary/Treasurer Bill Armstrong, Director Jim Moss, Director
and all of said persons were present, except the following absentees: ______________________, thus constituting a quorum. Whereupon, among other business, the following was transacted at said Meeting: a written
RESOLUTION EXPRESSING OFFICIAL INTENT TO REIMBURSE WITH PROCEEDS OF OBLIGATIONS ISSUED TO FINANCE IMPROVEMENTS TO THE DISTRICT'S WASTEWATER TREATMENT SYSTEM DEEMED NECESSARY TO PROVIDE WASTEWATER SERVICE TO CUSTOMERS OF THE DISTRICT
was duly read. It was then duly moved and seconded that said Resolution be adopted; and, after due discussion, said motion, carrying with it the adoption of said Resolution, prevailed and carried by the following vote:
AYES: _____ NOES: _____ ABSTENTIONS: _____
2. A true, full, and correct copy of the aforesaid Resolution 2012-1120A adopted at the Meeting described in the above and foregoing paragraph is attached to and follows this Certificate; said Resolution has been duly recorded in said District’s minutes of said Meeting; the above and
foregoing paragraph is a true, full, and correct excerpt from said Board of Director’s minutes of said Meeting pertaining to the adoption of said Resolution; the persons named in the above and
foregoing paragraph are the duly chosen, qualified, and acting officers and members of said District Board of Directors as indicated therein; each of the officers and members of said Board of Directors
was duly and sufficiently notified officially and personally, in advance, of the time, place, and purpose of the aforesaid Meeting, and that said Resolution would be introduced and considered for adoption at said Meeting; and said Meeting was open to the public, and public notice of the time, place, and purpose of said Meeting was given, all as required by Chapter 551, Texas Government Code.
SIGNED AND SEALED the 20th day of November, 2012. __________________________________________ (SEAL) Laurie Slaght, District Secretary, Trophy Club MUD No. 1
Trophy Club Municipal Utility District No. 1 57 of 193 November 20, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:12012-269-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:11/7/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:11/20/2012
Title:* Receive District Manager's Report (McKnight)
a.Water System Operation
b.Wastewater Treatment Plant
c.Roundabout Relocation Project
d.Website Update
e.Status of survey and appraisal for land near Wastewater Treatment Plant.
* f.Committed Funds
Attachments:Pumped vs. Billed.pdf
Monthly Log October 2012.pdf
*Committed Funds.pdf
Action ByDate Action ResultVer.
Title
* Receive District Manager's Report (McKnight)
a.Water System Operation
b.Wastewater Treatment Plant
c.Roundabout Relocation Project
d.Website Update
e.Status of survey and appraisal for land near Wastewater Treatment Plant.
* f.Committed Funds
Trophy Club Municipal Utility District No. 1 58 of 193 November 20, 2012
C:\Users\LSLAGHT\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\GLGDOJAU\combined graphs (version 2) (2).xls
Oct.Nov.Dec.Jan Feb.March April May June July August Sept.Total for year
FYI- Physical Year
2005-2006 74,441 56,296 41,272 54,171 37,626 35,714 55,429 60,800 88,899 113,904 122,820 81,806 823,178
2006-2007 73,757 44,297 35,905 31,695 25,671 40,516 43,121 31,204 42,191 43,717 72,462 76,138 560,674
2007-2008 63,250 47,082 33,371 37,194 31,472 30,766 40,313 48,829 78,091 91,664 115,042 75,494 692,568
2008-2009 63,730 48,170 35,215 35,759 32,240 39,331 46,151 37,382 56,370 125,089 91,724 79,137 690,298
2009-2010 39,794 39,713 29,547 30,305 25,328 23,279 41,646 53,439 102,921 89,760 128,687 82,331 686,750
2010-2011 70,502 50,909 44,365 35,983 27,845 55,972 69,165 61,467 99,326 117,707 170,464 123,692 927,397
2011-2012 85,869 53,571 40,815 30,616 31,665 35,263 47,194 84,905 114,104 137,174 144,573 108,622 914,371
2012-2013 85,488
October November December January February March April May June July August
79,297 48,609 36,966 32,915 26,974 25,771 31,755 46,747 70,315 69,134 92,539
84,849 51,836 38,869 32,850 24,742 25,111 32,240 47,364 75,755 68,715 82,007
90,400 55,063 40,772 32,785 22,510 24,451 32,726 47,980 81,195 68,296 71,476
95,952 58,290 42,675 32,721 20,278 23,791 33,211 48,597 86,636 67,878
350,497 213,799 159,281 131,271 94,504 99,122 129,932 190,688 313,900 274,022 246,022
Oct.Nov.Dec.Jan Feb.March April May June July August Sept.Total for year
FYI- Physical Year
2006 74,585 55,405 42,852 52,100 33,247 39,250 64,455 73,048 93,187 118,353 127,450 76,301 850,233
2007 72,460 49,249 34,203 28,257 31,492 43,900 41,770 37,340 41,215 43,136 75,480 72,087 570,589
2008 64,370 50,090 35,320 36,610 34,630 34,750 42,900 63,116 78,399 114,256 98,670 72,551 725,662
2009 65,110 48,570 36,411 36,587 36,385 44,120 48,881 38,250 66,450 116,823 94,525 81,500 713,612
2010 40,803 41,600 32,700 31,400 30,145 27,240 43,400 62,646 113,049 94,950 131,650 76,159 725,742
2011 70,502 50,993 44,220 33,789 36,053 54,775 71,306 63,500 116,350 152,002 169,621 117,190 980,301
2012 83,750 54,245 41,650 34,740 31,581 46,519 62,649 100,402 110,324 153,813 139,005 123,045 981,723
2013 85,966 .
0
20,000
40,000
60,000
80,000
100,000
120,000
140,000
160,000
180,000 Million Gallons Months
Water Billed
Series2
Series3
Series4
Series7
0
20,000
40,000
60,000
80,000
100,000
120,000
140,000
160,000
180,000 Million Gallons Months
Water Pumped
2010
2011
2012
2013
Trophy Club Municipal Utility District No. 1 59 of 193 November 20, 2012
Water Billed
October November December January February March April May June July August September Total for year
2002 63,959 50,374 34,958 30,575 25,433 28,758 30,383 43,102 53,302 56,995 99,461 71,944 517,298
Water Pumped
2002 61,718 45,025 34,781 33,316 26,894 31,653 33,676 46,021 62,320 67,784 99,432 74,160 542,620
0
20000
40000
60000
80000
100000
120000 Gallons Months
Billed vs. Pumped
Billed
Pumped
Trophy Club Municipal Utility District No. 1 60 of 193 November 20, 2012
Analytical Precision Control Chart
Page 11
Max mg/L 0.97 Aver mg/L 0.442
hHhoood
Max mg/L 5.9 Aver mg/L 4.7
Ammonia Nitrogen
Carbonaceous Biochemical Demand (CBOD5)
0.8
0.160
0.420
0.790
0.270 0.180 0.230 0.350 0.3 0.3 0.21
0.97
0.76
0.00
0.50
1.00
1.50
2.00
2.50
3.00
3.50
4.00 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 Sep-13 Permit Limit
1.0 April-Sept
3.0 Oct -March
Average
NH3-N
5.700 5.400
5.900
3.800
4.600
3.500
5.200
4.500
3.800 4.10
5.00
4.40
0.00
1.00
2.00
3.00
4.00
5.00
6.00
7.00
8.00
9.00
10.00 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 Sep-13 Permit
Limit 5
CBOD5
Average
Trophy Club Municipal Utility District No. 1 61 of 193 November 20, 2012
Analytical Precision Control Chart
Page 11
Max mg/L 34 Aver mg/L 6.3
Max mg/L 23.0 Aver mg/L 17.1
Max mg/L 68.0 Aver mg/L 14.5
Total Suspended Solids (TSS)
Nitrate - Nitrogen
E. Coli
1.5
10.4 10.4
34.0
0.6 2.6 5.1 2.3 2.0 2.6 2.0 2.0
0.00
10.00
20.00
30.00
40.00
50.00 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 Sep-13 Permit
Limit 12.0
Average
TSS
22.5 23.0
14.7
21.4 19.6 19.0 20.0 19.5
8.0
14.8
10.9 11.9
0.00
5.00
10.00
15.00
20.00
25.00
30.00 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 Sep-13 Permit
Limit 24
N-N
Average
1.0
49.0
35.0
68.0
1.0 2.0
10 3.0 1.1 1.7 1.1 1.0 0.00
20.00
40.00
60.00
80.00
100.00
120.00 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 Permit
Limit 126
E. coli
Average
Trophy Club Municipal Utility District No. 1 62 of 193 November 20, 2012
Analytical Precision Control Chart
Page 11
Max mg/L 8.1 Min mg/L 5.8 Aver mg/L 7.7
Potential for Hydrogen (pH)
7.3
6.9
5.8
6.9 6.9 6.9 6.7 6.9
7.3 7.4
7.8 7.6
0.00
2.00
4.00
6.00
8.00
10.00
12.00
14.00 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 Sep-13 Permit Limit
Mimimum 6.0
Average
pH minimum
Permit Limit Max
9.0
pH max
Trophy Club Municipal Utility District No. 1 63 of 193 November 20, 2012
Analytical Precision Control Chart
Page 11
D
Max mg/L 7.9 Aver mg/L 6.3
Dissolved Oxygen (DO)
6.8
7.9
5.3 5.5 5.5
6.1 6.0 6.0 6.0 6.0
6.9 7.0
0.00
1.00
2.00
3.00
4.00
5.00
6.00
7.00
8.00
9.00 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 Sep-13 Permit
Limit
(ABOVE)
6.0
Average
DO
Trophy Club Municipal Utility District No. 1 64 of 193 November 20, 2012
Restricted - Assigned;
Unable to be spent
Unrestricted-
Available for spending
Total in Accounts
(Restricted & Unrestricted)
135-10150 First Financial Bank ( 91000502534) $0 $240,997 $240,997
122-10150 First Financial Bank ( 91000502534) $0 $0
507-10150 First Financial Bank ( 91000502534) $0 $0
533-10150 First Financial Bank ( 91000502534) $6,120 $6,120
137-10150 First Financial Bank ( 91000502534) $0 $0
135-10250 Tex-Pool O & M (613300002)$467,292 $2,415,431 $2,882,723
122-10250 Tex-Pool O & M (613300002)$326,693 $326,693
507-10250 Tex-Pool O & M (613300002)$49,274 $49,274
137-10250 Tex-Pool O & M (613300002)$214,249 $214,249
533-10250 Tex-Pool I & S (613300003)$136,900 $136,900
$824,560 $3,032,395 $3,856,955
Amount available in cash $3,032,395
General Fund-Operations (Supplemental Reserves to cover budget deficit )-$305,750.00
IS-Debt Service (Supplemental reserves for debt service payment to lower tax rate )-$345,000.00
Well Repair -$60,000.00
Harmony Park -$42,500.00
Amount available for spending $2,279,145
CASH STATUS AS OF 10/31/12
Trophy Club Municipal Utility District No. 1 65 of 193 November 20, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:12012-270-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:11/7/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:11/20/2012
Title:Receive Finance Update (Gonzales)
a.PID Connections
b.Utility Billing
Attachments:PID Connections 10-2012.pdf
UB Monthly Report Oct.pdf
Action ByDate Action ResultVer.
Title
Receive Finance Update (Gonzales)
a.PID Connections
b.Utility Billing
Trophy Club Municipal Utility District No. 1 66 of 193 November 20, 2012
PID CONNECTION FEE SUMMARY
(Oct 12)
DEPOSIT
DATE
QTY
(5/8")
$ 2,300 QTY
(1")
$ 2,300 QTY
(1.5")
$ 7,590 QTY
(2")
$ 15,410 TOTAL
QTY
TOTAL
AMOUNT
TEXPOOL
TRANSFER
QTY
CUM
RUNNING
BALANCE
($3.26M)
Begin 910 1,167,000
1 - -$ - -$ - -$ - -$ - - 910 1,167,000
2 - -$ - -$ - -$ - -$ - - 910 1,167,000
3 - -$ 1 2,300$ - -$ - -$ 1 2,300 911 1,164,700
4 - -$ 4 9,200$ - -$ - -$ 4 9,200 915 1,155,500
5 - -$ - -$ - -$ - -$ - - 915 1,155,500
6 - -$ - -$ - -$ - -$ - - 915 1,155,500
7 - -$ - -$ - -$ - -$ - - 915 1,155,500
8 - -$ - -$ - -$ - -$ - - 915 1,155,500
9 - -$ - -$ - -$ - -$ - - 915 1,155,500
10 - -$ - -$ - -$ - -$ - - 915 1,155,500
11 - -$ 1 2,300$ - -$ - -$ 1 2,300 916 1,153,200
12 - -$ 1 2,300$ - -$ - -$ 1 2,300 917 1,150,900
13 - -$ - -$ - -$ - -$ - - 917 1,150,900
14 - -$ - -$ - -$ - -$ - - 917 1,150,900
15 - -$ - -$ - -$ - -$ - - 917 1,150,900
16 - -$ - -$ - -$ - -$ - - 917 1,150,900
17 - -$ 4 9,200$ - -$ - -$ 4 9,200 921 1,141,700
18 - -$ - -$ - -$ - -$ - - 921 1,141,700
19 - -$ 1 2,300$ - -$ - -$ 1 2,300 922 1,139,400
20 - -$ - -$ - -$ - -$ - - 922 1,139,400
21 - -$ - -$ - -$ - -$ - - 922 1,139,400
22 - -$ - -$ - -$ - -$ - - 922 1,139,400
23 - -$ 1 2,300$ - -$ - -$ 1 2,300 923 1,137,100
24 - -$ 2 4,600$ - -$ - -$ 2 4,600 925 1,132,500
25 - -$ 3 6,900$ - -$ - -$ 3 6,900 928 1,125,600
26 - -$ - -$ - -$ - -$ - - 928 1,125,600
27 - -$ - -$ - -$ - -$ - - 928 1,125,600
28 - -$ - -$ - -$ - -$ - - 928 1,125,600
29 - -$ - -$ - -$ - -$ - - 928 1,125,600
30 - -$ - -$ - -$ - -$ - - 928 1,125,600
31 - -$ - -$ - -$ - -$ - - 928 1,125,600
TOTAL - -$ 18 41,400$ - -$ - -$ 18 41,400 -
Upon collection of one or more Utility Fees by Town,such Utility Fees shall,within ten (10) working days, be deposited by Town into an account designated
by MUDs (hereinafter "MUDs Account").Town shall continue to collect and to deposit such Utility Fees into MUDs Account in accordance with the existing
agreement between the MUDs until such time as the total amount paid into that account equals $3,260,000.Town shall collect and deposit a minimum of one
hundred fifty (150)Utility Fees each year, for a total of five (5)successive years commencing on May 7, 2008 (hereinafter "Collection Period").In the event
that more than 150 Utility Fees are collected by Town in anyone or more years of the Collection Period,such Utility Fees in excess of the 150 Utility Fees
required under this Section shall be carried over to the following year or years and shall be a credit toward the total Utility Fees due for such subsequent year
or years.
In the event that fewer than 150 Utility Fees are collected by Town during anyone or more year(s) of the Collection Period, including those Utility Fees carried
over from any given year in which more than 150 Utility Fees were collected by Town,Town shall within ten (10) working days of collection of such Utility
Fees from Developer, pay into MUDs Account the difference between the amount that would have been paid had 150 Access Fees been paid at $2,300 each
and the amount of Utility Fees actually collected by Town.On or about May 7, 2013,Town shall calculate the total amount of Utility Fees paid to MUDs.Town
shall provide MUDs written notice of any amount paid less than $3,260,000 (the "Utility Fee Remainder").
Trophy Club Municipal Utility District No. 1 67 of 193 November 20, 2012
October November December January February March April May June July August September
ebills 276
Bills Mailed 3603
Bank Draft 539
Credit Card Draft 261
Online Payments 717
Late Notices 389
Disconnects 32 32
Trophy Club MUD #1
Utility Billing Report
Fiscal Year 2013
Trophy Club Municipal Utility District No. 1 68 of 193 November 20, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:12012-271-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:11/7/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:11/20/2012
Title:Receive Fire Update (Thomas)
a.October activity
Attachments:2012 Oct Fire Activity Report.pdf
Action ByDate Action ResultVer.
Title
Receive Fire Update (Thomas)
a.October activity
Trophy Club Municipal Utility District No. 1 69 of 193 November 20, 2012
Oct 12 Nov 12 Dec 12 Jan 13 Feb 13 Mar 13 Apr 13 May 13 Jun 13 Jul 13 Aug 13 Sep 13Monthly AverageTotal FY 2012Calls by TypeFire33.0 3Service3131.0 31Good Intent33.0 3False Alarm44.0 4EMS3939.0 39Total Calls80000000000008.080Mutual AidGiven11.0 1Received11.0 1Hospital TransportsTCFD2121.0 21Mutual Aid11.0 1Air00.0 0Trophy Club Fire DepartmentMonthly Activity ReportFY 2013 MTDResponse Time% At or Under 6 Minutes 71.471.4Average Time 5.535.5OtherContinuing Education Hours 123.5123.5 123.5Public Education Events 1313.0 13Service calls include inspections, lock‐outs, water problems, smoke or odor removal, public service and assistance, and public education.Fire3%Service39%Good Intent4%False Alarm5%EMS49%YTD 2013 Calls by Type020406080100120Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep4 Year Comparison ‐Number of CallsFY 2013FY 2012FY 2011FY 2010Trophy Club Municipal Utility District No. 170 of 193November 20, 2012
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
FY 2013 80
FY 2012 69 55 72 59 71 75 70 85 47 101 83 61
FY 2011 58 57 42 65 76 50 55 63 75 53 67 77
FY 2010 69 49 67 52 70 42 63 59 54 62 58 71
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
FY 2013 3
FY 2012 4762302841034
FY 2011 1461124647545
FY 2010 433480432242
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
FY 2013 31
FY 2012 28 13 17 29 25 34 21 35 15 36 32 12
FY 2011 28 17 13 20 16 14 15 15 16 13 21 20
FY 2010 32 20 21 19 10 12 19 13 11 23 17 25
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
FY 2013 3
FY 2012 314373523678
FY 2011 2421101479363
Trophy Club Fire Department
4 Year Comparison of Calls
Total Number of Calls
Fire Calls
Service Calls
Good Intent Calls
FY 2010 5241102236334
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
FY 2013 4
FY 2012 5552446510948
FY 2011 32091337966410
FY 2010 4 4 10 882456646
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
FY 2013 39
FY 2012 24 29 40 23 32 34 36 35 15 40 37 29
FY 2011 24 30 21 34 25 27 23 28 37 26 32 39
FY 2010 24 20 29 20 34 26 34 35 29 28 30 34
FY 2013 39 FY 2013 80
FY 2012 24 FY 2012 69
FY 2011 24 FY 2011 58
FY 2010 24 FY 2010 69
FY 2013 51
FY 2012 45
FY 2011 34
FY 2010 45
Number of Calls
EMS Calls
Fire & Related Calls
Total Calls
False Alarms
EMS Calls
0
10
20
30
40
50
60
70
80
FY 2013 FY 2012 FY 2011 FY 2010
Total Calls YTD
Trophy Club Municipal Utility District No. 1 71 of 193 November 20, 2012
Oct 12 Nov 12 Dec 12 Jan 13 Feb 13 Mar 13 Apr 13 May 13 Jun 13 Jul 13 Aug 13 Sep 13Monthly AverageTotal FY 2012District 1# of calls2121.0 21avg. response time04:5204:52District 2# of calls4343.0 43avg. response time05:1005:10District 4 (PID)# of calls66.0 6avg. response time06:2206:22District 5 (TCP)# of calls11.0 4avg. response time07:2803:44Trophy Club Fire DepartmentCalls by DistrictFY 2013avg. response time07:2803:44District 6 (BNHS)# of calls44.0 4avg. response time05:1605:16Outside# of calls55.0 5avg. response time10:5310:5325%52%7%5%5%6%% Calls by District FY 13 YTDDistrict 1District 2District 4 (PID)District 5 (TCP)District 6 (BNHS)Outside60%20%20%% Mutual Aid Calls by DepartmentRoanoke (3 calls)Southlake (1 calls)Haslet (1 call)Trophy Club Municipal Utility District No. 172 of 193November 20, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:12012-272-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:11/7/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:11/20/2012
Title:Receive Town Council Update (Rose)
Attachments:
Action ByDate Action ResultVer.
Title
Receive Town Council Update (Rose)
Trophy Club Municipal Utility District No. 1 73 of 193 November 20, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:12012-290-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:11/15/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:11/20/2012
Title:Consider and take appropriate action regarding official Town Council liaison representation at District
meetings. (Carr)
Attachments:
Action ByDate Action ResultVer.
Title
Consider and take appropriate action regarding official Town Council liaison representation at District meetings.
(Carr)
Trophy Club Municipal Utility District No. 1 74 of 193 November 20, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:12012-288-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:11/14/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:11/20/2012
Title:Consider and take appropriate action to approve the October 2012 financials (Gonzales)
Attachments:Oct 2012 Variance.pdf
Fund Balances @ 10-31-12.pdf
October Financials.pdf
Action ByDate Action ResultVer.
Title
Consider and take appropriate action to approve the October 2012 financials (Gonzales)
Trophy Club Municipal Utility District No. 1 75 of 193 November 20, 2012
BUDGET VARIANCE REPORT
FUND:122 - Fire O&M
FINANCIALS MONTH:October 2012
REVENUE VARIANCE:8%
EXPENSE VARIANCE:18%
NOTE:
ACCOUNT DESCRIPTION TOTAL
BUDGET
CURRENT
MONTH
YTD
TOTAL
YTD %VARIANCE EXPLANATION
FIRE REVENUE
122-40011 Property Taxes/Fire Delinquent 5,800$ 2,363$ 2,363$ 41%Collection of past due tax accounts
FIRE EXPENSES
122-50045-045 Workman's Compensation 10,000$ 10,000$ 10,000$ 100%Annual payment in October
122-60010-045 Communications/Mobiles 2,500$ 1,391$ 1,391$ 56%Denton County Dispatch
122-60070-045 Dues & Memberships 7,500$ 6,821$ 6,821$ 91%Annual Certifications, Annual NEFDA
dues
122-60125-045 Advertising 150$ 122$ 122$ 82%Banners for Fire open house
Explanation provided for all accounts with a Year-To-Date percentage (YTD%)less than the Revenue Variance and greater than or
equal to the Expense Variance. The Revenue and Expense Variance is calculated on a straight-line method (Financials Month x
8.3%), less 8.3% for revenues and plus 10% for expenses. Only accounts with current month activity will be listed
Trophy Club Municipal Utility District No. 1 76 of 193 November 20, 2012
BUDGET VARIANCE REPORT
FUND:135 - MUD 1 O&M
FINANCIALS MONTH:October 2012
REVENUE VARIANCE:8%
EXPENSE VARIANCE:18%
NOTE:
ACCOUNT DESCRIPTION TOTAL
BUDGET
CURRENT
MONTH
YTD
TOTAL
YTD %VARIANCE EXPLANATION
REVENUE
135-40002 Property Taxes/Delinquent 500 255 255 51%Collection of delinquent accounts
135-49010 Interest Income 5,500$ 602$ 602$ 11%First Financial & Texpool Interest
135-49900 Miscellaneous Income 1,000$ 556$ 556$ 56%Miscellaneous permits and Return of
Equity from TML Ins and W/C
WATER
135-50045-010 Workman's Compensation 6,109$ 6,109$ 6,109$ 100%Annual payment in October
135-60100-010 Travel & Per Diem 700$ 149$ 149$ 21%Mileage for On call overtime
WASTEWATER
135-50045-020 Workman's Compensation 2,939$ 2,939$ 2,939$ 100%Annual payment in October
135-55080-020 Maintenance & Repairs 40,000$ 7,625$ 7,625$ 19%Repair Blowers
135-55105-020 Maintenance-Backhoe/Skidloader 1,500$ 1,081$ 1,081$ 72%4 Tires for Skidloader
135-60105-020 Rent/Lease Equipment 1,500$ 1,020$ 1,020$ 68%10 HP Waste Pump rental
135-65030-020 Chemicals 10,000$ 6,248$ 6,248$ 62%Microorganisms, Polymer
135-65045-020 Lab Supplies 10,000$ 3,855$ 3,855$ 39%Gamma Irad Colilert 200 pack,Quanti-
tray 2,000 disposable
COLLECTIONS
135-50045-021 Workman's Compensation 3,348$ 3,348$ 3,348$ 100%Annual payment in October
ADMINISTRATION
135-50045-030 Workman's Compensation 831$ 831$ 831$ 100%Annual payment in October
135-60055-030 Insurance 35,000$ 34,065$ 34,065$ 97%Annual payment in October
135-60066-030 Publications/Books/Subscriptions 750$ 449$ 449$ 60%HR & Accounting publications
135-60075-030 Meetings 250$ 88$ 88$ 35%Chamber luncheon/Admin,Mayor's
Forum
135-65055-030 Hardware 20,188$ 5,739$ 5,739$ 28%Computer for Terri, Laptops
Explanation provided for all accounts with a Year-To-Date percentage (YTD%)less than the Revenue Variance and greater than or equal
to the Expense Variance.The Revenue and Expense Variance is calculated on a straight-line method (Financials Month x 8.3%),less
8.3% for revenues and plus 10% for expenses. Only accounts with current month activity will be listed
Trophy Club Municipal Utility District No. 1 77 of 193 November 20, 2012
Fund Fund #
Unassigned
(Available for any
purpose)
Assigned
(Intended to be
used for specific
purposes)
Non-Spendable
(Amounts not in
spendable form &
required to be
maintained
intact)
Total Fund
Balances
2013
Adopted
Expense
Budget
%
Unassigned
Fund
Balance to
Adopted
Expenses
2013 Amended
Expense
Budget
%
Unassigned
Fund Balance
to Amended
Expenses
General Fund 135 $2,999,834 $560,470 $1,487 $3,561,791 $6,509,259 46.0856%$6,509,259 46.0856%
Fire Department 122 $328,895 $0 $328,895 $1,335,883 24.6200%$1,335,883 24.6200%
Capital Projects 507 $38,101 $38,101
GASB 137 $214,249 $214,249
Interest & Sinking 533 $143,020 $143,020
$3,366,830 $917,739 $1,487 $4,286,056 $7,845,142 $7,845,142
Our GASB #54 Policy states that our goal is to achieve and maintain our General Fund Unassigned Fund Balance equal to 35% of expenditures and not to go
below 25%, barring unusual or deliberate circumstances.
Fund Fund #
Unassigned
(Available for any
purpose)
Assigned
(Intended to be
used for specific
purposes)
Non-Spendable
(Amounts not in
spendable form &
required to be
maintained
intact)
Total Fund
Balances
2013
Adopted
Expense
Budget
%
Unassigned
Fund
Balance to
Adopted
Expenses
2013 Amended
Expense
Budget
%
Unassigned
Fund Balance
to Amended
Expenses
General Fund 135 $2,999,834 $560,470 $1,487 $3,561,791 $6,509,259 42.9161%$6,509,259 42.9161%
Fire Department 122 $328,895 $328,895 $1,335,883 $1,335,883
Capital Projects 507 $38,101 $38,101 0 0
GASB 137 $214,249 $214,249 0 0
Interest & Sinking 533 $143,020 $143,020 0 0
$3,366,830 $917,739 $1,487 $4,286,056 $7,845,142 $7,845,142
* Our Auditors class General Fund, Fire Department, Capital Projects and GASB Funds together as Total General Fund. This sheet calculates the % accordingly.
Trophy Club MUD #1 Fund Balances @ 10/31/12 - by Separate Funds
Trophy Club MUD #1 Fund Balances @ 10/31/12 - by All Funds Together *
Unassigned Fund Balance Percentages based on GASB 54 Policy adopted September 2011
Unassigned Fund Balance Percentages based on GASB 54 Policy adopted September 2011
Trophy Club Municipal Utility District No. 1 78 of 193 November 20, 2012
Municipal Utility District No 1 - O & M
Interim Balance Sheet
Balance @
10/31/2012
ASSETS
ASSETS
CASH ON HAND 400
CASH IN BANK 241,497
INVESTMENTS 2,721,890
RESTRICTED ASSETS:
INVESTMENTS 424,356
PREPAID EXPENSES -
ADVALOREM PROPERTY TAXES RECEIVABLE 98,576
UTILITY AND OTHER ACCOUNTS RECEIVABLE 965,877
TOTAL ASSETS 4,452,596$
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 98,576$
ACCOUNTS PAYABLE 329,772
CUSTOMER DEPOSITS 210,107
TOTAL LIABILITIES 638,455
FUND BALANCE
NON-SPENDABLE FUND BALANCE 2,463
ASSIGNED/WATER REPLACEMENT 90,000
ASSIGNED/TECHNOLOGY REPLACEMENT 82,359
ASSIGNED/FIRE DEPT REPLACEMENT 41,890
ASSIGNED FUND BALANCE 560,470
UNASSIGNED FUND BALANCE 3,036,959
TOTAL FUND BALANCE 3,814,141
TOTAL LIABILITIES AND FUND BALANCE 4,452,596$
October 31, 2012
1/12 Months (8.33% of Fiscal Year)
Trophy Club Municipal Utility District No. 1 79 of 193 November 20, 2012
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 4
15:59 11/15/12 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 10/2012
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-40000-000-000 Property Taxes 99,884.00- 99,884.00- 2,512.70- 2,512.70- 2.516 97,371.30-
135-40002-000-000 Property Taxes/Delinquent 500.00- 500.00- 254.68- 254.68- 50.936 245.32-
135-40015-000-000 Property Taxes/P & I 1,200.00- 1,200.00- 78.03- 78.03- 6.503 1,121.97-
Subtotal: 101,584.00- 101,584.00- 2,845.41- 2,845.41- 2.801 98,738.59-
135-47000-000-000 Water 3,545,609.00- 3,545,609.00- 266,584.35- 266,584.35- 7.519 3,279,024.65-
135-47005-000-000 Sewer 1,653,747.00- 1,653,747.00- 131,687.66- 131,687.66- 7.963 1,522,059.34-
135-47020-000-000 Standby 576.00- 576.00- 47.90- 47.90- 8.316 528.10-
135-47025-000-000 Penalties 64,580.00- 64,580.00- 5,041.52- 5,041.52- 7.807 59,538.48-
135-47030-000-000 Service Charges 11,625.00- 11,625.00- 903.00- 903.00- 7.768 10,722.00-
135-47035-000-000 Plumbing Inspections 1,800.00- 1,800.00- 1,800.00-
135-47045-000-000 Sewer Inspections 5,200.00- 5,200.00- 150.00- 150.00- 2.885 5,050.00-
135-47070-000-000 TCCC Effluent Charges 77,575.00- 77,575.00- 77,575.00-
Subtotal: 5,360,712.00- 5,360,712.00- 404,414.43- 404,414.43- 7.544 4,956,297.57-
135-48005-000-000 Utility Fees 644,000.00- 644,000.00- 41,400.00- 41,400.00- 6.429 602,600.00-
Subtotal: 644,000.00- 644,000.00- 41,400.00- 41,400.00- 6.429 602,600.00-
135-49010-000-000 Interest Income 5,500.00- 5,500.00- 601.85- 601.85- 10.943 4,898.15-
135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 847.00- 847.00- 8.333 9,317.00-
135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 583.33- 8.333 6,416.67-
135-49030-000-000 Vending Revenue 350.00- 350.00- 350.00-
135-49035-000-000 Prior Year Reserves 305,748.00- 305,748.00- 305,748.00-
135-49075-000-000 Oversize Meter Reimbursement 73,000.00- 73,000.00- 5,548.00- 5,548.00- 7.600 67,452.00-
135-49900-000-000 Miscellaneous Income 1,000.00- 1,000.00- 556.07- 556.07- 55.607 443.93-
135-49905-000-000 Gas Well Revenue 200.00- 200.00- 200.00-
Subtotal: 402,962.00- 402,962.00- 8,136.25- 8,136.25- 2.019 394,825.75-
Program number: 6,509,258.00- 6,509,258.00- 456,796.09- 456,796.09- 7.018 6,052,461.91-
Department number: Revenues 6,509,258.00- 6,509,258.00- 456,796.09- 456,796.09- 7.018 6,052,461.91-
Revenues Subtotal ----------- 6,509,258.00- 6,509,258.00- 456,796.09- 456,796.09- 7.018 6,052,461.91-
Trophy Club Municipal Utility District No. 1 80 of 193 November 20, 2012
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 5
15:59 11/15/12 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 10/2012
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-50005-010-000 Salaries & Wages 213,321.00 213,321.00 9,102.28 9,102.28 4.267 204,218.72
135-50010-010-000 Overtime 13,250.00 13,250.00 2,212.56 2,212.56 16.699 11,037.44
135-50016-010-000 Longevity 3,080.00 3,080.00 3,080.00
135-50017-010-000 Certification 5,100.00 5,100.00 300.00 300.00 5.882 4,800.00
135-50020-010-000 Retirement 32,725.00 32,725.00 2,205.16 2,205.16 6.738 30,519.84
135-50026-010-000 Medical Insurance 28,920.00 28,920.00 1,683.92 1,683.92 5.823 27,236.08
135-50027-010-000 Dental Insurance 2,091.00 2,091.00 132.78 132.78 6.350 1,958.22
135-50028-010-000 Vision Insurance 519.00 519.00 31.76 31.76 6.119 487.24
135-50029-010-000 Life Insurance & Other 1,204.00 1,204.00 1,204.00
135-50030-010-000 Social Security Taxes 14,555.00 14,555.00 965.94 965.94 6.636 13,589.06
135-50035-010-000 Medicare Taxes 3,404.00 3,404.00 225.91 225.91 6.637 3,178.09
135-50040-010-000 Unemployment Taxes 945.00 945.00 945.00
135-50045-010-000 Workman's Compensation 6,109.00 6,109.00 6,109.00 6,109.00 100.000
135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 200.00
135-50070-010-000 Employee Relations 350.00 350.00 350.00
Subtotal: 325,773.00 325,773.00 22,969.31 22,969.31 7.051 302,803.69
135-55005-010-000 Engineering 3,000.00 3,000.00 3,000.00
135-55080-010-000 Maintenance & Repairs 50,000.00 50,000.00 1,037.55 1,037.55 2.075 48,962.45
135-55090-010-000 Vehicle Maintenance 3,700.00 3,700.00 3,700.00
135-55105-010-000 Maintenance-Backhoe/SkidLoader 2,900.00 2,900.00 2,900.00
135-55135-010-000 Lab Analysis 4,500.00 4,500.00 4,500.00
Subtotal: 64,100.00 64,100.00 1,037.55 1,037.55 1.619 63,062.45
135-60010-010-000 Communications/Pagers/Mobiles 2,000.00 2,000.00 2,000.00
135-60020-010-000 Electricity 162,410.00 162,410.00 5,401.93 5,401.93 3.326 157,008.07
135-60066-010-000 Publications/Books/Subscripts 500.00 500.00 500.00
135-60070-010-000 Dues & Memberships 150.00 150.00 150.00
135-60080-010-000 Schools & Training 1,672.00 1,672.00 1,672.00
135-60090-010-000 Safety Program 500.00 500.00 500.00
135-60100-010-000 Travel & per diem 700.00 700.00 149.30 149.30 21.329 550.70
135-60105-010-000 Rent/Lease Equipment 500.00 500.00 500.00
135-60135-010-000 TCEQ Fees & Permits 35,800.00 35,800.00 35,800.00
135-60150-010-000 Wholesale Water 2,028,447.00 2,028,447.00 2,028,447.00
135-60245-010-000 Miscellaneous Expenses 500.00 500.00 500.00
135-60280-010-000 Property Maintenance 4,200.00 4,200.00 45.00 45.00 1.071 4,155.00
135-60285-010-000 Lawn Equipment & Maintenance 250.00 250.00 250.00
135-60360-010-000 Furniture/Equipment < $5000 1,500.00 1,500.00 1,500.00
Subtotal: 2,239,129.00 2,239,129.00 5,596.23 5,596.23 .250 2,233,532.77
135-65005-010-000 Fuel & Lube 17,661.00 17,661.00 27.70 27.70 .157 17,633.30
Trophy Club Municipal Utility District No. 1 81 of 193 November 20, 2012
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 6
15:59 11/15/12 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 10/2012
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-65010-010-000 Uniforms 2,680.00 2,680.00 2,680.00
135-65030-010-000 Chemicals 6,200.00 6,200.00 672.30 672.30 10.844 5,527.70
135-65035-010-000 Small Tools 1,500.00 1,500.00 1,500.00
135-65040-010-000 Safety Equipment 2,000.00 2,000.00 2,000.00
135-65050-010-000 Meter Expense 143,550.00 143,550.00 143,550.00
Subtotal: 173,591.00 173,591.00 700.00 700.00 .403 172,891.00
135-69005-010-000 Capital Expenses 181,800.00 181,800.00 181,800.00
135-69008-010-000 Short Term Debt Payments 387,037.00 387,037.00 387,037.00
135-69195-010-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 30,000.00
135-69280-010-000 Capital Repairs 270,000.00 270,000.00 270,000.00
135-69281-010-000 Capital Repair-Ground Storage 150,000.00 150,000.00 150,000.00
Subtotal: 1,018,837.00 1,018,837.00 1,018,837.00
Program number: 3,821,430.00 3,821,430.00 30,303.09 30,303.09 .793 3,791,126.91
Department number: Water 3,821,430.00 3,821,430.00 30,303.09 30,303.09 .793 3,791,126.91
Trophy Club Municipal Utility District No. 1 82 of 193 November 20, 2012
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 7
15:59 11/15/12 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 10/2012
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-50005-020-000 Salaries & Wages 196,781.00 196,781.00 9,902.13 9,902.13 5.032 186,878.87
135-50010-020-000 Overtime 10,166.00 10,166.00 791.99 791.99 7.791 9,374.01
135-50016-020-000 Longevity 2,858.00 2,858.00 2,858.00
135-50017-020-000 Certification 4,200.00 4,200.00 350.00 350.00 8.333 3,850.00
135-50020-020-000 Retirement 29,821.00 29,821.00 2,108.94 2,108.94 7.072 27,712.06
135-50026-020-000 Medical Insurance 29,034.00 29,034.00 2,327.30 2,327.30 8.016 26,706.70
135-50027-020-000 Dental Insurance 2,112.00 2,112.00 175.34 175.34 8.302 1,936.66
135-50028-020-000 Vision Insurance 552.00 552.00 45.92 45.92 8.319 506.08
135-50029-020-000 Life Insurance & Other 920.00 920.00 920.00
135-50030-020-000 Social Security Taxes 13,268.00 13,268.00 785.74 785.74 5.922 12,482.26
135-50035-020-000 Medicare Taxes 3,103.00 3,103.00 183.78 183.78 5.923 2,919.22
135-50040-020-000 Unemployment Taxes 756.00 756.00 756.00
135-50045-020-000 Workman's Compensation 2,939.00 2,939.00 2,939.00 2,939.00 100.000
135-50060-020-000 Pre-emp Physicals/Testing 150.00 150.00 150.00
135-50070-020-000 Employee Relations 350.00 350.00 350.00
Subtotal: 297,010.00 297,010.00 19,610.14 19,610.14 6.603 277,399.86
135-55070-020-000 Independent Labor 1,000.00 1,000.00 1,000.00
135-55080-020-000 Maintenance & Repairs 40,000.00 40,000.00 7,624.99 7,624.99 19.062 32,375.01
135-55090-020-000 Vehicle Maintenance 2,000.00 2,000.00 2,000.00
135-55105-020-000 Maintenance-Backhoe/SkidLoader 1,500.00 1,500.00 1,080.96 1,080.96 72.064 419.04
135-55125-020-000 Dumpster Services 15,000.00 15,000.00 15,000.00
135-55135-020-000 Lab Analysis 30,000.00 30,000.00 1,080.00 1,080.00 3.600 28,920.00
Subtotal: 89,500.00 89,500.00 9,785.95 9,785.95 10.934 79,714.05
135-60010-020-000 Communications/Pagers/Mobiles 2,700.00 2,700.00 2,700.00
135-60020-020-000 Electricity 153,045.00 153,045.00 4,596.54 4,596.54 3.003 148,448.46
135-60066-020-000 Publications/Books/Subscripts 500.00 500.00 500.00
135-60080-020-000 Schools & Training 3,272.00 3,272.00 3,272.00
135-60090-020-000 Safety Program 250.00 250.00 250.00
135-60100-020-000 Travel & per diem 1,400.00 1,400.00 116.55 116.55 8.325 1,283.45
135-60105-020-000 Rent/Lease Equipment 1,500.00 1,500.00 1,020.00 1,020.00 68.000 480.00
135-60125-020-000 Advertising 2,000.00 2,000.00 2,000.00
135-60135-020-000 TCEQ Fees & Permits 56,000.00 56,000.00 7,729.80 7,729.80 13.803 48,270.20
135-60245-020-000 Miscellaneous Expenses 200.00 200.00 200.00
135-60285-020-000 Lawn Equipment & Maintenance 500.00 500.00 500.00
Subtotal: 221,367.00 221,367.00 13,462.89 13,462.89 6.082 207,904.11
135-65005-020-000 Fuel & Lube 8,527.00 8,527.00 8,527.00
135-65010-020-000 Uniforms 2,574.00 2,574.00 2,574.00
135-65030-020-000 Chemicals 10,000.00 10,000.00 6,248.30 6,248.30 62.483 3,751.70
Trophy Club Municipal Utility District No. 1 83 of 193 November 20, 2012
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 8
15:59 11/15/12 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 10/2012
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-65035-020-000 Small Tools 1,000.00 1,000.00 1,000.00
135-65040-020-000 Safety Equipment 250.00 250.00 250.00
135-65045-020-000 Lab Supplies 10,000.00 10,000.00 3,855.26 3,855.26 38.553 6,144.74
Subtotal: 32,351.00 32,351.00 10,103.56 10,103.56 31.231 22,247.44
135-69005-020-000 Capital Expenses 241,200.00 241,200.00 241,200.00
135-69280-020-000 Capital Repairs 158,000.00 158,000.00 158,000.00
Subtotal: 399,200.00 399,200.00 399,200.00
Program number: 1,039,428.00 1,039,428.00 52,962.54 52,962.54 5.095 986,465.46
Department number: Wastewater 1,039,428.00 1,039,428.00 52,962.54 52,962.54 5.095 986,465.46
Trophy Club Municipal Utility District No. 1 84 of 193 November 20, 2012
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 9
15:59 11/15/12 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 21 Collection Program:
Period Ending: 10/2012
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-50005-021-000 Salaries & Wages 156,475.00 156,475.00 8,176.21 8,176.21 5.225 148,298.79
135-50010-021-000 Overtime 7,297.00 7,297.00 598.89 598.89 8.207 6,698.11
135-50016-021-000 Longevity 3,818.00 3,818.00 3,818.00
135-50017-021-000 Certification 1,800.00 1,800.00 150.00 150.00 8.333 1,650.00
135-50020-021-000 Retirement 23,574.00 23,574.00 1,697.63 1,697.63 7.201 21,876.37
135-50026-021-000 Medical Insurance 20,198.00 20,198.00 1,683.08 1,683.08 8.333 18,514.92
135-50027-021-000 Dental Insurance 1,409.00 1,409.00 124.48 124.48 8.835 1,284.52
135-50028-021-000 Vision Insurance 357.00 357.00 29.72 29.72 8.325 327.28
135-50029-021-000 Life Insurance & Other 1,008.00 1,008.00 1,008.00
135-50030-021-000 Social Security Taxes 10,502.00 10,502.00 707.03 707.03 6.732 9,794.97
135-50035-021-000 Medicare Taxes 2,456.00 2,456.00 165.35 165.35 6.732 2,290.65
135-50040-021-000 Unemployment Taxes 567.00 567.00 567.00
135-50045-021-000 Workman's Compensation 3,348.00 3,348.00 3,348.00 3,348.00 100.000
135-50070-021-000 Employee Relations 250.00 250.00 250.00
Subtotal: 233,059.00 233,059.00 16,680.39 16,680.39 7.157 216,378.61
135-55005-021-000 Engineering 1,500.00 1,500.00 1,500.00
135-55080-021-000 Maintenance & Repairs 35,000.00 35,000.00 168.50 168.50 .481 34,831.50
135-55090-021-000 Vehicle Maintenance 1,900.00 1,900.00 1,900.00
Subtotal: 38,400.00 38,400.00 168.50 168.50 .439 38,231.50
135-60010-021-000 Communications/Pagers/Mobiles 3,500.00 3,500.00 3,500.00
135-60020-021-000 Electricity 18,705.00 18,705.00 332.87 332.87 1.780 18,372.13
135-60070-021-000 Dues & Memberships 250.00 250.00 250.00
135-60080-021-000 Schools & Training 826.00 826.00 90.00 90.00 10.896 736.00
135-60090-021-000 Safety Program 500.00 500.00 500.00
135-60100-021-000 Travel & per diem 450.00 450.00 19.43 19.43 4.318 430.57
135-60105-021-000 Rent/Lease Equipment 10,000.00 10,000.00 10,000.00
135-60245-021-000 Miscellaneous Expenses 100.00 100.00 100.00
Subtotal: 34,331.00 34,331.00 442.30 442.30 1.288 33,888.70
135-65005-021-000 Fuel & Lube 12,117.00 12,117.00 12,117.00
135-65010-021-000 Uniforms 2,220.00 2,220.00 2,220.00
135-65030-021-000 Chemicals 7,500.00 7,500.00 7,500.00
135-65035-021-000 Small Tools 1,500.00 1,500.00 1,500.00
135-65040-021-000 Safety Equipment 500.00 500.00 500.00
Subtotal: 23,837.00 23,837.00 23,837.00
135-69005-021-000 Capital Expenses 90,000.00 90,000.00 90,000.00
135-69008-021-000 Short Term Debt Payments 40,260.00 40,260.00 40,260.00
Trophy Club Municipal Utility District No. 1 85 of 193 November 20, 2012
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 10
15:59 11/15/12 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 21 Collection Program:
Period Ending: 10/2012
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
Subtotal: 130,260.00 130,260.00 130,260.00
Program number: 459,887.00 459,887.00 17,291.19 17,291.19 3.760 442,595.81
Department number: Collection 459,887.00 459,887.00 17,291.19 17,291.19 3.760 442,595.81
Trophy Club Municipal Utility District No. 1 86 of 193 November 20, 2012
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 11
15:59 11/15/12 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program:
Period Ending: 10/2012
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-50005-026-000 Salaries & Wages 10,000.00 10,000.00 500.00 500.00 5.000 9,500.00
135-50030-026-000 Social Security Taxes 620.00 620.00 31.00 31.00 5.000 589.00
135-50035-026-000 Medicare Taxes 145.00 145.00 7.25 7.25 5.000 137.75
135-50040-026-000 Unemployment Taxes 210.00 210.00 14.50 14.50 6.905 195.50
135-50045-026-000 Workman's Compensation 150.00 150.00 150.00
Subtotal: 11,125.00 11,125.00 552.75 552.75 4.969 10,572.25
135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00
135-60070-026-000 Dues & Memberships 2,100.00 2,100.00 2,100.00
135-60075-026-000 Meetings 1,200.00 1,200.00 22.00 22.00 1.833 1,178.00
135-60080-026-000 Schools & Training 4,000.00 4,000.00 4,000.00
135-60100-026-000 Travel & per diem 5,000.00 5,000.00 5,000.00
135-60245-026-000 Miscellaneous Expenses 3,000.00 3,000.00 3,000.00
Subtotal: 15,450.00 15,450.00 22.00 22.00 .142 15,428.00
Program number: 26,575.00 26,575.00 574.75 574.75 2.163 26,000.25
Department number: Board of Directors 26,575.00 26,575.00 574.75 574.75 2.163 26,000.25
Trophy Club Municipal Utility District No. 1 87 of 193 November 20, 2012
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 12
15:59 11/15/12 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 10/2012
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-50005-030-000 Salaries & Wages 444,730.00 444,730.00 25,870.34 25,870.34 5.817 418,859.66
135-50010-030-000 Overtime 1,500.00 1,500.00 8.94 8.94 .596 1,491.06
135-50016-030-000 Longevity 2,193.00 2,193.00 2,193.00
135-50020-030-000 Retirement 60,441.00 60,441.00 4,525.48 4,525.48 7.487 55,915.52
135-50026-030-000 Medical Insurance 44,066.00 44,066.00 3,185.30 3,185.30 7.228 40,880.70
135-50027-030-000 Dental Insurance 3,379.00 3,379.00 288.72 288.72 8.545 3,090.28
135-50028-030-000 Vision Insurance 795.00 795.00 66.20 66.20 8.327 728.80
135-50029-030-000 Life Insurance & Other 2,500.00 2,500.00 2,500.00
135-50030-030-000 Social Security Taxes 27,802.00 27,802.00 1,937.42 1,937.42 6.969 25,864.58
135-50035-030-000 Medicare Taxes 6,502.00 6,502.00 453.11 453.11 6.969 6,048.89
135-50040-030-000 Unemployment Taxes 1,537.00 1,537.00 195.84 195.84 12.742 1,341.16
135-50045-030-000 Workman's Compensation 831.00 831.00 831.00 831.00 100.000
135-50060-030-000 Pre-emp Physicals/Testing 250.00 250.00 35.00 35.00 14.000 215.00
135-50070-030-000 Employee Relations 5,000.00 5,000.00 5,000.00
Subtotal: 601,526.00 601,526.00 37,397.35 37,397.35 6.217 564,128.65
135-55030-030-000 Software & Support 63,555.00 63,555.00 2,961.75 2,961.75 4.660 60,593.25
135-55070-030-000 Independent Labor 2,700.00 2,700.00 2,700.00
135-55075-030-000 Records Management 500.00 500.00 500.00
135-55100-030-000 Building Maint & Supplies 5,000.00 5,000.00 32.36 32.36 .647 4,967.64
135-55120-030-000 Cleaning Services 20,200.00 20,200.00 1,678.51 1,678.51 8.309 18,521.49
135-55160-030-000 Professional Outside Services 15,000.00 15,000.00 15,000.00
135-55161-030-000 Outside Services-Town Semo 85,465.00 85,465.00 85,465.00
135-55165-030-000 Collection Fees 159.77 159.77 159.77-
135-55205-030-000 Utility Billing Contract 11,000.00 11,000.00 11,000.00
Subtotal: 203,420.00 203,420.00 4,832.39 4,832.39 2.376 198,587.61
135-60005-030-000 Telephone 9,000.00 9,000.00 1,339.34 1,339.34 14.882 7,660.66
135-60010-030-000 Communications/Pagers/Mobiles 3,575.00 3,575.00 150.00 150.00 4.196 3,425.00
135-60020-030-000 Electricity/Gas 13,019.00 13,019.00 13,019.00
135-60025-030-000 Water 3,100.00 3,100.00 3,100.00
135-60030-030-000 Rent And/Or Usage 13,182.00 13,182.00 13,182.00
135-60035-030-000 Postage 23,000.00 23,000.00 652.66 652.66 2.838 22,347.34
135-60040-030-000 Service Charges & Fees 18,000.00 18,000.00 2,750.83 2,750.83 15.282 15,249.17
135-60050-030-000 Bad Debt Expense 8,500.00 8,500.00 1,056.53- 1,056.53- -12.430 9,556.53
135-60055-030-000 Insurance 35,000.00 35,000.00 34,065.48 34,065.48 97.330 934.52
135-60066-030-000 Publications/Books/Subscripts 750.00 750.00 449.22 449.22 59.896 300.78
135-60070-030-000 Dues & Memberships 2,400.00 2,400.00 100.00 100.00 4.167 2,300.00
135-60075-030-000 Meetings 250.00 250.00 88.00 88.00 35.200 162.00
135-60080-030-000 Schools & Training 5,500.00 5,500.00 5,500.00
135-60100-030-000 Travel & per diem 3,950.00 3,950.00 10.05 10.05 .254 3,939.95
135-60110-030-000 Physicals/Testing 500.00 500.00 500.00
Trophy Club Municipal Utility District No. 1 88 of 193 November 20, 2012
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 13
15:59 11/15/12 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 10/2012
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-60125-030-000 Advertising 4,000.00 4,000.00 4,000.00
135-60235-030-000 Security 1,350.00 1,350.00 1,350.00
135-60245-030-000 Miscellaneous Expenses 15,000.00 15,000.00 13.00 13.00 .087 14,987.00
135-60270-030-000 4th of July Celebration 10,500.00 10,500.00 10,500.00
135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 265.00 265.00 10.600 2,235.00
Subtotal: 173,076.00 173,076.00 38,827.05 38,827.05 22.434 134,248.95
135-65010-030-000 Uniforms 1,635.00 1,635.00 1,635.00
135-65055-030-000 Hardware 20,188.00 20,188.00 5,738.89 5,738.89 28.427 14,449.11
135-65085-030-000 Office Supplies 8,200.00 8,200.00 816.15 816.15 9.953 7,383.85
135-65090-030-000 Printer Supplies & Maintenance 5,732.00 5,732.00 226.00 226.00 3.943 5,506.00
135-65095-030-000 Maintenance Supplies 2,000.00 2,000.00 2,000.00
135-65097-030-000 Vending Machine Supplies 500.00 500.00 500.00
135-65105-030-000 Printing 5,200.00 5,200.00 5,200.00
Subtotal: 43,455.00 43,455.00 6,781.04 6,781.04 15.605 36,673.96
135-69170-030-000 Copier Lease Installments 3,450.00 3,450.00 256.85 256.85 7.445 3,193.15
135-69195-030-000 Gasb34/Reserve for Replacement 26,911.00 26,911.00 26,911.00
Subtotal: 30,361.00 30,361.00 256.85 256.85 .846 30,104.15
Program number: 1,051,838.00 1,051,838.00 88,094.68 88,094.68 8.375 963,743.32
Department number: Administration 1,051,838.00 1,051,838.00 88,094.68 88,094.68 8.375 963,743.32
Trophy Club Municipal Utility District No. 1 89 of 193 November 20, 2012
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 14
15:59 11/15/12 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program:
Period Ending: 10/2012
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-55045-039-000 Legal 70,000.00 70,000.00 70,000.00
135-55055-039-000 Auditing 21,200.00 21,200.00 21,200.00
135-55060-039-000 Appraisal 15,100.00 15,100.00 2,322.74 2,322.74 15.382 12,777.26
135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 3,800.00
Subtotal: 110,100.00 110,100.00 2,322.74 2,322.74 2.110 107,777.26
Program number: 110,100.00 110,100.00 2,322.74 2,322.74 2.110 107,777.26
Department number: Non Departmental 110,100.00 110,100.00 2,322.74 2,322.74 2.110 107,777.26
Expenditures Subtotal ----------- 6,509,258.00 6,509,258.00 191,548.99 191,548.99 2.943 6,317,709.01
Fund number: 135 MUD 1 General Fund 265,247.10- 265,247.10- 265,247.10
Trophy Club Municipal Utility District No. 1 90 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 14
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-40000-000-000 Property Taxes
195 10/02/2012 Property Taxes/Assessments (31.53) (31.53) GL
196 10/08/2012 Property Taxes/Assessments (10.98) (42.51) GL
198 10/10/2012 Property Taxes/Assessments (17.06) (59.57) GL
200 10/15/2012 Property Taxes/Assessments (26.04) (85.61) GL
201 10/16/2012 Property Taxes/Assessments (122.95) (208.56) GL
202 10/17/2012 Property Taxes/Assessments (129.24) (337.80) GL
204 10/18/2012 Property Taxes/Assessments (115.11) (452.91) GL
207 10/19/2012 Property Taxes/Assessments (164.52) (617.43) GL
209 10/22/2012 Property Taxes/Assessments (1,010.82) (1,628.25) GL
216 10/23/2012 Property Taxes/Assessments (172.15) (1,800.40) GL
219 10/23/2012 Property Taxes/Assessments (51.97) (1,852.37) GL
221 10/25/2012 Property Taxes/Assessments (136.48) (1,988.85) GL
223 10/26/2012 Property Taxes/Assessments (108.02) (2,096.87) GL
226 10/29/2012 Property Taxes/Assessments (153.36) (2,250.23) GL
227 10/30/2012 Property Taxes/Assessments (77.00) (2,327.23) GL
228 10/31/2012 Property Taxes/Assessments (185.47) (2,512.70) GL
_______________
Account: 135-40000-000-000 Property Taxes Totals: (2,512.70) (2,512.70) **
(99,884.00) Budgeted (97,371.30) Remaining 3 % Used
Account: 135-40002-000-000 Property Taxes/Delinquent
193 10/01/2012 Property Taxes/Assessments (18.52) (18.52) GL
202 10/17/2012 Property Taxes/Assessments (115.26) (133.78) GL
209 10/22/2012 Property Taxes/Assessments (120.90) (254.68) GL
_______________
Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (254.68) (254.68) **
(500.00) Budgeted (245.32) Remaining 51 % Used
Account: 135-40015-000-000 Property Taxes/P & I
193 10/01/2012 Property Taxes/Assessments (3.71) (3.71) GL
202 10/17/2012 Property Taxes/Assessments (43.32) (47.03) GL
209 10/22/2012 Property Taxes/Assessments (25.39) (72.42) GL
209 10/22/2012 Property Taxes/Assessments (.79) (73.21) GL
216 10/23/2012 Property Taxes/Assessments (2.66) (75.87) GL
228 10/31/2012 Property Taxes/Assessments (2.16) (78.03) GL
_______________
Account: 135-40015-000-000 Property Taxes/P & I Totals: (78.03) (78.03) **
(1,200.00) Budgeted (1,121.97) Remaining 7 % Used
Account: 135-47000-000-000 Water
Trophy Club Municipal Utility District No. 1 91 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 15
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
234 10/01/2012 Reverse Unbilled WT/SW @ 9/30 52,456.71 52,456.71 GL
151 10/31/2012 UB 10/31/2012 Billing UB20121031-20121031 User: (317,116.50) (264,659.79) UB
251 10/31/2012 Recodes per J McKnight (466.99) (265,126.78) GL
251 10/31/2012 Recodes per J McKnight (1,457.57) (266,584.35) GL
_______________
Account: 135-47000-000-000 Water Totals: (266,584.35) (266,584.35) **
(3,545,609.00) Budgeted (3,279,024.65) Remaining 8 % Used
Account: 135-47005-000-000 Sewer
234 10/01/2012 Reverse Unbilled WT/SW @ 9/30 27,002.01 27,002.01 GL
151 10/31/2012 UB 10/31/2012 Billing UB20121031-20121031 User: (155,070.97) (128,068.96) UB
251 10/31/2012 Recodes per J McKnight (3,618.70) (131,687.66) GL
_______________
Account: 135-47005-000-000 Sewer Totals: (131,687.66) (131,687.66) **
(1,653,747.00) Budgeted (1,522,059.34) Remaining 8 % Used
Account: 135-47015-000-000 Commercial Sewer
151 10/31/2012 UB 10/31/2012 Billing UB20121031-20121031 User: (3,618.70) (3,618.70) UB
251 10/31/2012 Recodes per J McKnight 3,618.70 .00 GL
_______________
Account: 135-47015-000-000 Commercial Sewer Totals: .00 .00 **
.00 Budgeted .00 Remaining 0 % Used
Account: 135-47020-000-000 Standby
234 10/01/2012 Reverse Unbilled WT/SW @ 9/30 12.00 12.00 GL
151 10/31/2012 UB 10/31/2012 Billing UB20121031-20121031 User: (59.90) (47.90) UB
_______________
Account: 135-47020-000-000 Standby Totals: (47.90) (47.90) **
(576.00) Budgeted (528.10) Remaining 8 % Used
Account: 135-47025-000-000 Penalties
95 10/23/2012 UB 10/23/12 Penalties UB20121023-20121023 User: (5,021.58) (5,021.58) UB
134 10/29/2012 UB 10/29/2012 Adjustments UB20121029-20121029 User: 320.84 (4,700.74) UB
138 10/30/2012 UB 10/30/12 Adjustments UB20121030-20121030 User: 52.36 (4,648.38) UB
150 10/31/2012 UB 10/31/2012 Adjustments UB20121031-20121031 User: 17.16 (4,631.22) UB
151 10/31/2012 UB 10/31/2012 Billing UB20121031-20121031 User: (355.46) (4,986.68) UB
251 10/31/2012 Recodes per J McKnight (54.84) (5,041.52) GL
_______________
Account: 135-47025-000-000 Penalties Totals: (5,041.52) (5,041.52) **
(64,580.00) Budgeted (59,538.48) Remaining 8 % Used
Trophy Club Municipal Utility District No. 1 92 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 16
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-47030-000-000 Service Charges
25 10/10/2012 UB 10/10/12 Disconnect Fees UB20121010-20121010 User: (800.00) (800.00) UB
73 10/10/2012 UB 10/10/12 Adjustment UB20121010-20121010 User: (25.00) (825.00) UB
139 10/24/2012 UB 10/24/12 NSF Check Fee UB20121024-20121024 User: (25.00) (850.00) UB
142 10/24/2012 UB 10/24/12 Adjustments UB20121024-20121024 User: (50.00) (900.00) UB
151 10/31/2012 UB 10/31/2012 Billing UB20121031-20121031 User: (3.00) (903.00) UB
_______________
Account: 135-47030-000-000 Service Charges Totals: (903.00) (903.00) **
(11,625.00) Budgeted (10,722.00) Remaining 8 % Used
Account: 135-47035-000-000 Plumbing Inspections
.00 .00
_______________
Account: 135-47035-000-000 Plumbing Inspections Totals: .00 .00 **
(1,800.00) Budgeted (1,800.00) Remaining 0 % Used
Account: 135-47045-000-000 Sewer Inspections
211 10/24/2012 Permits 10/24/12 (150.00) (150.00) GL
_______________
Account: 135-47045-000-000 Sewer Inspections Totals: (150.00) (150.00) **
(5,200.00) Budgeted (5,050.00) Remaining 3 % Used
Account: 135-47070-000-000 TCCC Effluent Charges
.00 .00
_______________
Account: 135-47070-000-000 TCCC Effluent Charges Totals: .00 .00 **
(77,575.00) Budgeted (77,575.00) Remaining 0 % Used
Account: 135-47400-000-000 Water-Out of Dist/Port Meters
41 10/12/2012 UB 10/12/12 Adjustments UB20121012-20121012 User: (200.00) (200.00) UB
151 10/31/2012 UB 10/31/2012 Billing UB20121031-20121031 User: (266.99) (466.99) UB
251 10/31/2012 Recodes per J McKnight 466.99 .00 GL
_______________
Account: 135-47400-000-000 Water-Out of Dist/Port Meters Totals: .00 .00 **
.00 Budgeted .00 Remaining 0 % Used
Account: 135-47410-000-000 Out of Dist/Portable Penalties
95 10/23/2012 UB 10/23/12 Penalties UB20121023-20121023 User: (54.84) (54.84) UB
Trophy Club Municipal Utility District No. 1 93 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 17
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
251 10/31/2012 Recodes per J McKnight 54.84 .00 GL
_______________
Account: 135-47410-000-000 Out of Dist/Portable Penalties Totals: .00 .00 **
.00 Budgeted .00 Remaining 0 % Used
Account: 135-47600-000-000 PID #1 Water
151 10/31/2012 UB 10/31/2012 Billing UB20121031-20121031 User: (1,457.57) (1,457.57) UB
251 10/31/2012 Recodes per J McKnight 1,457.57 .00 GL
_______________
Account: 135-47600-000-000 PID #1 Water Totals: .00 .00 **
.00 Budgeted .00 Remaining 0 % Used
Account: 135-48005-000-000 Utility Fees
205 10/18/2012 Correct Util Fees coding/Oct 10/1-10/17 coded to I&S (25,300.00) (25,300.00) GL
203 10/19/2012 Permits 10/19/12 (2,300.00) (27,600.00) GL
210 10/23/2012 Permits 10/23/12 (2,300.00) (29,900.00) GL
211 10/24/2012 Permits 10/24/12 (4,600.00) (34,500.00) GL
212 10/25/2012 Permits 10/25/12 (6,900.00) (41,400.00) GL
_______________
Account: 135-48005-000-000 Utility Fees Totals: (41,400.00) (41,400.00) **
(644,000.00) Budgeted (602,600.00) Remaining 6 % Used
Account: 135-49010-000-000 Interest Income
224 10/31/2012 Oct Bank interest (117.28) (117.28) GL
224 10/31/2012 Oct Bank interest (484.57) (601.85) GL
_______________
Account: 135-49010-000-000 Interest Income Totals: (601.85) (601.85) **
(5,500.00) Budgeted (4,898.15) Remaining 11 % Used
Account: 135-49016-000-000 Cell Tower Revenue
62 10/17/2012 AT&T Cell Tower/Oct (847.00) (847.00) GL
_______________
Account: 135-49016-000-000 Cell Tower Revenue Totals: (847.00) (847.00) **
(10,164.00) Budgeted (9,317.00) Remaining 8 % Used
Account: 135-49018-000-000 Building Rent Income
60 10/17/2012 Town Sep/Oct Maint Barn rent (583.33) (583.33) GL
Trophy Club Municipal Utility District No. 1 94 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 18
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
_______________
Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (583.33) **
(7,000.00) Budgeted (6,416.67) Remaining 8 % Used
Account: 135-49030-000-000 Vending Revenue
.00 .00
_______________
Account: 135-49030-000-000 Vending Revenue Totals: .00 .00 **
(350.00) Budgeted (350.00) Remaining 0 % Used
Account: 135-49035-000-000 Prior Year Reserves
.00 .00
_______________
Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 **
(305,748.00) Budgeted (305,748.00) Remaining 0 % Used
Account: 135-49075-000-000 Oversize Meter Reimbursement
63 10/03/2012 Permits 10/3/12 (292.00) (292.00) GL
64 10/04/2012 Permits 10/4/12 (1,168.00) (1,460.00) GL
65 10/11/2012 Permit 10/11/12 (292.00) (1,752.00) GL
66 10/12/2012 Permits 10/12/12 (292.00) (2,044.00) GL
87 10/17/2012 Permits 10/17/12 (1,168.00) (3,212.00) GL
203 10/19/2012 Permits 10/19/12 (292.00) (3,504.00) GL
210 10/23/2012 Permits 10/23/12 (292.00) (3,796.00) GL
211 10/24/2012 Permits 10/24/12 (876.00) (4,672.00) GL
212 10/25/2012 Permits 10/25/12 (876.00) (5,548.00) GL
_______________
Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (5,548.00) (5,548.00) **
(73,000.00) Budgeted (67,452.00) Remaining 8 % Used
Account: 135-49900-000-000 Miscellaneous Income
66 10/12/2012 Permits 10/12/12 (75.00) (75.00) GL
213 10/23/2012 Costco refund from coupon (1.01) (76.01) GL
211 10/24/2012 Permits 10/24/12 (50.00) (126.01) GL
145 10/31/2012 Oct A/P MUD W/C FY 2013 (429.66) (555.67) TML INTERGOVERNMENTAL RISK 31896 AP
240 10/31/2012 Unidentified Bank rec adj (.40) (556.07) GL
_______________
Account: 135-49900-000-000 Miscellaneous Income Totals: (556.07) (556.07) **
(1,000.00) Budgeted (443.93) Remaining 56 % Used
Trophy Club Municipal Utility District No. 1 95 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 19
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-49905-000-000 Gas Well Revenue
.00 .00
_______________
Account: 135-49905-000-000 Gas Well Revenue Totals: .00 .00 **
(200.00) Budgeted (200.00) Remaining 0 % Used
Department Totals: ------------------------------------------------------------------------------------------------ (456,796.09) **
(6,509,258.00) Budgeted (6,052,461.91) Remaining 7 % Used
Trophy Club Municipal Utility District No. 1 96 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 20
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-50005-010-000 Salaries & Wages
232 10/01/2012 Reverse Sept P/R accrual (3,723.15) (3,723.15) GL
103 10/12/2012 Payroll 10/12/12 6,355.52 2,632.37 GL
105 10/26/2012 Payroll 10/26/12 6,469.91 9,102.28 GL
_______________
Account: 135-50005-010-000 Salaries & Wages Totals: 9,102.28 9,102.28 **
213,321.00 Budgeted 204,218.72 Remaining 4 % Used
Account: 135-50010-010-000 Overtime
232 10/01/2012 Reverse Sept P/R accrual (618.29) (618.29) GL
103 10/12/2012 Payroll 10/12/12 1,479.62 861.33 GL
103 10/12/2012 Payroll 10/12/12 160.00 1,021.33 GL
105 10/26/2012 Payroll 10/26/12 1,111.23 2,132.56 GL
105 10/26/2012 Payroll 10/26/12 80.00 2,212.56 GL
_______________
Account: 135-50010-010-000 Overtime Totals: 2,212.56 2,212.56 **
13,250.00 Budgeted 11,037.44 Remaining 17 % Used
Account: 135-50016-010-000 Longevity
.00 .00
_______________
Account: 135-50016-010-000 Longevity Totals: .00 .00 **
3,080.00 Budgeted 3,080.00 Remaining 0 % Used
Account: 135-50017-010-000 Certification
103 10/12/2012 Payroll 10/12/12 300.00 300.00 GL
_______________
Account: 135-50017-010-000 Certification Totals: 300.00 300.00 **
5,100.00 Budgeted 4,800.00 Remaining 6 % Used
Account: 135-50020-010-000 Retirement
103 10/12/2012 Payroll 10/12/12 1,146.39 1,146.39 GL
105 10/26/2012 Payroll 10/26/12 1,058.77 2,205.16 GL
_______________
Account: 135-50020-010-000 Retirement Totals: 2,205.16 2,205.16 **
32,725.00 Budgeted 30,519.84 Remaining 7 % Used
Account: 135-50026-010-000 Medical Insurance
Trophy Club Municipal Utility District No. 1 97 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 21
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
103 10/12/2012 Payroll 10/12/12 841.96 841.96 GL
105 10/26/2012 Payroll 10/26/12 841.96 1,683.92 GL
_______________
Account: 135-50026-010-000 Medical Insurance Totals: 1,683.92 1,683.92 **
28,920.00 Budgeted 27,236.08 Remaining 6 % Used
Account: 135-50027-010-000 Dental Insurance
103 10/12/2012 Payroll 10/12/12 66.39 66.39 GL
105 10/26/2012 Payroll 10/26/12 66.39 132.78 GL
_______________
Account: 135-50027-010-000 Dental Insurance Totals: 132.78 132.78 **
2,091.00 Budgeted 1,958.22 Remaining 6 % Used
Account: 135-50028-010-000 Vision Insurance
103 10/12/2012 Payroll 10/12/12 15.88 15.88 GL
105 10/26/2012 Payroll 10/26/12 15.88 31.76 GL
_______________
Account: 135-50028-010-000 Vision Insurance Totals: 31.76 31.76 **
519.00 Budgeted 487.24 Remaining 6 % Used
Account: 135-50029-010-000 Life Insurance & Other
.00 .00
_______________
Account: 135-50029-010-000 Life Insurance & Other Totals: .00 .00 **
1,204.00 Budgeted 1,204.00 Remaining 0 % Used
Account: 135-50030-010-000 Social Security Taxes
103 10/12/2012 Payroll 10/12/12 502.62 502.62 GL
105 10/26/2012 Payroll 10/26/12 463.32 965.94 GL
_______________
Account: 135-50030-010-000 Social Security Taxes Totals: 965.94 965.94 **
14,555.00 Budgeted 13,589.06 Remaining 7 % Used
Account: 135-50035-010-000 Medicare Taxes
103 10/12/2012 Payroll 10/12/12 117.55 117.55 GL
105 10/26/2012 Payroll 10/26/12 108.36 225.91 GL
_______________
Account: 135-50035-010-000 Medicare Taxes Totals: 225.91 225.91 **
3,404.00 Budgeted 3,178.09 Remaining 7 % Used
Trophy Club Municipal Utility District No. 1 98 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 22
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-50040-010-000 Unemployment Taxes
.00 .00
_______________
Account: 135-50040-010-000 Unemployment Taxes Totals: .00 .00 **
945.00 Budgeted 945.00 Remaining 0 % Used
Account: 135-50045-010-000 Workman's Compensation
145 10/31/2012 Oct A/P MUD W/C FY 2013 6,109.00 6,109.00 TML INTERGOVERNMENTAL RISK 31896 AP
_______________
Account: 135-50045-010-000 Workman's Compensation Totals: 6,109.00 6,109.00 **
6,109.00 Budgeted .00 Remaining 100 % Used
Account: 135-50060-010-000 Pre-emp Physicals/Testing
.00 .00
_______________
Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 .00 **
200.00 Budgeted 200.00 Remaining 0 % Used
Account: 135-50070-010-000 Employee Relations
.00 .00
_______________
Account: 135-50070-010-000 Employee Relations Totals: .00 .00 **
350.00 Budgeted 350.00 Remaining 0 % Used
Account: 135-55005-010-000 Engineering
.00 .00
_______________
Account: 135-55005-010-000 Engineering Totals: .00 .00 **
3,000.00 Budgeted 3,000.00 Remaining 0 % Used
Account: 135-55080-010-000 Maintenance & Repairs
145 10/31/2012 Oct A/P Fire extinguisher PM/Refill 30.00 30.00 KIMBROUGH FIRE EXTINQUISHER CO 31886 AP
145 10/31/2012 Oct A/P Well #1 Electrical 396.50 426.50 CIRCLE R ELECTRIC CO 31878 AP
145 10/31/2012 Oct A/P Oct PCards 547.98 974.48 JPMORGAN CHASE BANK NA 31885 AP
145 10/31/2012 Oct A/P Oct PCards 63.07 1,037.55 JPMORGAN CHASE BANK NA 31885 AP
_______________
Account: 135-55080-010-000 Maintenance & Repairs Totals: 1,037.55 1,037.55 **
50,000.00 Budgeted 48,962.45 Remaining 2 % Used
Trophy Club Municipal Utility District No. 1 99 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 23
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-55090-010-000 Vehicle Maintenance
.00 .00
_______________
Account: 135-55090-010-000 Vehicle Maintenance Totals: .00 .00 **
3,700.00 Budgeted 3,700.00 Remaining 0 % Used
Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader
.00 .00
_______________
Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 **
2,900.00 Budgeted 2,900.00 Remaining 0 % Used
Account: 135-55135-010-000 Lab Analysis
.00 .00
_______________
Account: 135-55135-010-000 Lab Analysis Totals: .00 .00 **
4,500.00 Budgeted 4,500.00 Remaining 0 % Used
Account: 135-60010-010-000 Communications/Pagers/Mobiles
.00 .00
_______________
Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: .00 .00 **
2,000.00 Budgeted 2,000.00 Remaining 0 % Used
Account: 135-60020-010-000 Electricity
75 10/19/2012 Oct A/P Electricity 10/1-10/11 4,390.00 4,390.00 HUDSON ENERGY 31833 AP
75 10/19/2012 Oct A/P Electricity 10/1-10/11 127.00 4,517.00 HUDSON ENERGY 31833 AP
145 10/31/2012 Oct A/P 10/1-10/11 Electricity 884.93 5,401.93 HUDSON ENERGY 31882 AP
_______________
Account: 135-60020-010-000 Electricity Totals: 5,401.93 5,401.93 **
162,410.00 Budgeted 157,008.07 Remaining 3 % Used
Account: 135-60050-010-000 Bad Debt Expense
35 10/11/2012 UB 10/11/2012 Remit Payments UB20121011-20121011 User: MSCH (577.37) (577.37) UB
106 10/24/2012 AMS Collection Check 10/24/12 (37.72) (615.09) GL
109 10/25/2012 UB 10/25/12 AMS Collection Ck UB20121025-20121025 User: (441.44) (1,056.53) CR
251 10/31/2012 Recodes per J McKnight 1,056.53 .00 GL
Trophy Club Municipal Utility District No. 1 100 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 24
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
_______________
Account: 135-60050-010-000 Bad Debt Expense Totals: .00 .00 **
.00 Budgeted .00 Remaining 0 % Used
Account: 135-60066-010-000 Publications/Books/Subscripts
.00 .00
_______________
Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 **
500.00 Budgeted 500.00 Remaining 0 % Used
Account: 135-60070-010-000 Dues & Memberships
.00 .00
_______________
Account: 135-60070-010-000 Dues & Memberships Totals: .00 .00 **
150.00 Budgeted 150.00 Remaining 0 % Used
Account: 135-60080-010-000 Schools & Training
.00 .00
_______________
Account: 135-60080-010-000 Schools & Training Totals: .00 .00 **
1,672.00 Budgeted 1,672.00 Remaining 0 % Used
Account: 135-60090-010-000 Safety Program
.00 .00
_______________
Account: 135-60090-010-000 Safety Program Totals: .00 .00 **
500.00 Budgeted 500.00 Remaining 0 % Used
Account: 135-60100-010-000 Travel & per diem
103 10/12/2012 Payroll 10/12/12 48.84 48.84 GL
105 10/26/2012 Payroll 10/26/12 100.46 149.30 GL
_______________
Account: 135-60100-010-000 Travel & per diem Totals: 149.30 149.30 **
700.00 Budgeted 550.70 Remaining 21 % Used
Account: 135-60105-010-000 Rent/Lease Equipment
.00 .00
Trophy Club Municipal Utility District No. 1 101 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 25
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
_______________
Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 **
500.00 Budgeted 500.00 Remaining 0 % Used
Account: 135-60135-010-000 TCEQ Fees & Permits
.00 .00
_______________
Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 .00 **
35,800.00 Budgeted 35,800.00 Remaining 0 % Used
Account: 135-60150-010-000 Wholesale Water
.00 .00
_______________
Account: 135-60150-010-000 Wholesale Water Totals: .00 .00 **
2,028,447.00 Budgeted 2,028,447.00 Remaining 0 % Used
Account: 135-60245-010-000 Miscellaneous Expenses
.00 .00
_______________
Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 **
500.00 Budgeted 500.00 Remaining 0 % Used
Account: 135-60280-010-000 Property Maintenance
145 10/31/2012 Oct A/P Oct PCards 27.00 27.00 JPMORGAN CHASE BANK NA 31885 AP
145 10/31/2012 Oct A/P Oct PCards 18.00 45.00 JPMORGAN CHASE BANK NA 31885 AP
_______________
Account: 135-60280-010-000 Property Maintenance Totals: 45.00 45.00 **
4,200.00 Budgeted 4,155.00 Remaining 1 % Used
Account: 135-60285-010-000 Lawn Equipment & Maintenance
.00 .00
_______________
Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 **
250.00 Budgeted 250.00 Remaining 0 % Used
Account: 135-60360-010-000 Furniture/Equipment < $5000
.00 .00
Trophy Club Municipal Utility District No. 1 102 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 26
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
_______________
Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 .00 **
1,500.00 Budgeted 1,500.00 Remaining 0 % Used
Account: 135-65005-010-000 Fuel & Lube
75 10/19/2012 Oct A/P Spare Pro keys for gas tank 27.70 27.70 SYN-TECH SYSTEMS, INC 31856 AP
_______________
Account: 135-65005-010-000 Fuel & Lube Totals: 27.70 27.70 **
17,661.00 Budgeted 17,633.30 Remaining 0 % Used
Account: 135-65010-010-000 Uniforms
.00 .00
_______________
Account: 135-65010-010-000 Uniforms Totals: .00 .00 **
2,680.00 Budgeted 2,680.00 Remaining 0 % Used
Account: 135-65030-010-000 Chemicals
145 10/31/2012 Oct A/P Cholorine PO 020902 416.35 416.35 DPC INDUSTRIES, INC 31880 AP
145 10/31/2012 Oct A/P Oct PCards 255.95 672.30 JPMORGAN CHASE BANK NA 31885 AP
_______________
Account: 135-65030-010-000 Chemicals Totals: 672.30 672.30 **
6,200.00 Budgeted 5,527.70 Remaining 11 % Used
Account: 135-65035-010-000 Small Tools
.00 .00
_______________
Account: 135-65035-010-000 Small Tools Totals: .00 .00 **
1,500.00 Budgeted 1,500.00 Remaining 0 % Used
Account: 135-65040-010-000 Safety Equipment
.00 .00
_______________
Account: 135-65040-010-000 Safety Equipment Totals: .00 .00 **
2,000.00 Budgeted 2,000.00 Remaining 0 % Used
Account: 135-65050-010-000 Meter Expense
.00 .00
Trophy Club Municipal Utility District No. 1 103 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 27
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
_______________
Account: 135-65050-010-000 Meter Expense Totals: .00 .00 **
143,550.00 Budgeted 143,550.00 Remaining 0 % Used
Account: 135-69005-010-000 Capital Expenses
.00 .00
_______________
Account: 135-69005-010-000 Capital Expenses Totals: .00 .00 **
181,800.00 Budgeted 181,800.00 Remaining 0 % Used
Account: 135-69008-010-000 Short Term Debt Payments
.00 .00
_______________
Account: 135-69008-010-000 Short Term Debt Payments Totals: .00 .00 **
387,037.00 Budgeted 387,037.00 Remaining 0 % Used
Account: 135-69195-010-000 Gasb34/Reserve for Replacement
.00 .00
_______________
Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 .00 **
30,000.00 Budgeted 30,000.00 Remaining 0 % Used
Account: 135-69280-010-000 Capital Repairs
.00 .00
_______________
Account: 135-69280-010-000 Capital Repairs Totals: .00 .00 **
270,000.00 Budgeted 270,000.00 Remaining 0 % Used
Account: 135-69281-010-000 Capital Repair-Ground Storage
.00 .00
_______________
Account: 135-69281-010-000 Capital Repair-Ground Storage Totals: .00 .00 **
150,000.00 Budgeted 150,000.00 Remaining 0 % Used
Department 10 Totals: ------------------------------------------------------------------------------------------------ 30,303.09 **
3,821,430.00 Budgeted 3,791,126.91 Remaining 1 % Used
Trophy Club Municipal Utility District No. 1 104 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 28
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-50005-020-000 Salaries & Wages
232 10/01/2012 Reverse Sept P/R accrual (4,046.53) (4,046.53) GL
103 10/12/2012 Payroll 10/12/12 7,024.79 2,978.26 GL
105 10/26/2012 Payroll 10/26/12 6,923.87 9,902.13 GL
_______________
Account: 135-50005-020-000 Salaries & Wages Totals: 9,902.13 9,902.13 **
196,781.00 Budgeted 186,878.87 Remaining 5 % Used
Account: 135-50010-020-000 Overtime
232 10/01/2012 Reverse Sept P/R accrual (169.37) (169.37) GL
103 10/12/2012 Payroll 10/12/12 376.40 207.03 GL
103 10/12/2012 Payroll 10/12/12 80.00 287.03 GL
105 10/26/2012 Payroll 10/26/12 344.96 631.99 GL
105 10/26/2012 Payroll 10/26/12 160.00 791.99 GL
_______________
Account: 135-50010-020-000 Overtime Totals: 791.99 791.99 **
10,166.00 Budgeted 9,374.01 Remaining 8 % Used
Account: 135-50016-020-000 Longevity
.00 .00
_______________
Account: 135-50016-020-000 Longevity Totals: .00 .00 **
2,858.00 Budgeted 2,858.00 Remaining 0 % Used
Account: 135-50017-020-000 Certification
103 10/12/2012 Payroll 10/12/12 350.00 350.00 GL
_______________
Account: 135-50017-020-000 Certification Totals: 350.00 350.00 **
4,200.00 Budgeted 3,850.00 Remaining 8 % Used
Account: 135-50020-020-000 Retirement
103 10/12/2012 Payroll 10/12/12 1,082.28 1,082.28 GL
105 10/26/2012 Payroll 10/26/12 1,026.66 2,108.94 GL
_______________
Account: 135-50020-020-000 Retirement Totals: 2,108.94 2,108.94 **
29,821.00 Budgeted 27,712.06 Remaining 7 % Used
Account: 135-50026-020-000 Medical Insurance
Trophy Club Municipal Utility District No. 1 105 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 29
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
103 10/12/2012 Payroll 10/12/12 1,163.65 1,163.65 GL
105 10/26/2012 Payroll 10/26/12 1,163.65 2,327.30 GL
_______________
Account: 135-50026-020-000 Medical Insurance Totals: 2,327.30 2,327.30 **
29,034.00 Budgeted 26,706.70 Remaining 8 % Used
Account: 135-50027-020-000 Dental Insurance
103 10/12/2012 Payroll 10/12/12 87.67 87.67 GL
105 10/26/2012 Payroll 10/26/12 87.67 175.34 GL
_______________
Account: 135-50027-020-000 Dental Insurance Totals: 175.34 175.34 **
2,112.00 Budgeted 1,936.66 Remaining 8 % Used
Account: 135-50028-020-000 Vision Insurance
103 10/12/2012 Payroll 10/12/12 22.96 22.96 GL
105 10/26/2012 Payroll 10/26/12 22.96 45.92 GL
_______________
Account: 135-50028-020-000 Vision Insurance Totals: 45.92 45.92 **
552.00 Budgeted 506.08 Remaining 8 % Used
Account: 135-50029-020-000 Life Insurance & Other
.00 .00
_______________
Account: 135-50029-020-000 Life Insurance & Other Totals: .00 .00 **
920.00 Budgeted 920.00 Remaining 0 % Used
Account: 135-50030-020-000 Social Security Taxes
103 10/12/2012 Payroll 10/12/12 405.34 405.34 GL
105 10/26/2012 Payroll 10/26/12 380.40 785.74 GL
_______________
Account: 135-50030-020-000 Social Security Taxes Totals: 785.74 785.74 **
13,268.00 Budgeted 12,482.26 Remaining 6 % Used
Account: 135-50035-020-000 Medicare Taxes
103 10/12/2012 Payroll 10/12/12 94.81 94.81 GL
105 10/26/2012 Payroll 10/26/12 88.97 183.78 GL
_______________
Account: 135-50035-020-000 Medicare Taxes Totals: 183.78 183.78 **
3,103.00 Budgeted 2,919.22 Remaining 6 % Used
Trophy Club Municipal Utility District No. 1 106 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 30
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-50040-020-000 Unemployment Taxes
.00 .00
_______________
Account: 135-50040-020-000 Unemployment Taxes Totals: .00 .00 **
756.00 Budgeted 756.00 Remaining 0 % Used
Account: 135-50045-020-000 Workman's Compensation
145 10/31/2012 Oct A/P MUD W/C FY 2013 2,939.00 2,939.00 TML INTERGOVERNMENTAL RISK 31896 AP
_______________
Account: 135-50045-020-000 Workman's Compensation Totals: 2,939.00 2,939.00 **
2,939.00 Budgeted .00 Remaining 100 % Used
Account: 135-50060-020-000 Pre-emp Physicals/Testing
.00 .00
_______________
Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 .00 **
150.00 Budgeted 150.00 Remaining 0 % Used
Account: 135-50070-020-000 Employee Relations
.00 .00
_______________
Account: 135-50070-020-000 Employee Relations Totals: .00 .00 **
350.00 Budgeted 350.00 Remaining 0 % Used
Account: 135-55070-020-000 Independent Labor
.00 .00
_______________
Account: 135-55070-020-000 Independent Labor Totals: .00 .00 **
1,000.00 Budgeted 1,000.00 Remaining 0 % Used
Account: 135-55080-020-000 Maintenance & Repairs
75 10/19/2012 Oct A/P Repair Blowers PO 020856 6,839.50 6,839.50 AIR MAC 31818 AP
145 10/31/2012 Oct A/P Fire extinguisher PM/Refill 166.00 7,005.50 KIMBROUGH FIRE EXTINQUISHER CO 31886 AP
145 10/31/2012 Oct A/P Oct PCards 14.49 7,019.99 JPMORGAN CHASE BANK NA 31885 AP
145 10/31/2012 Oct A/P Blower motor #2 alignment PO02 605.00 7,624.99 AIR MAC PO 020865 31874 AP
_______________
Account: 135-55080-020-000 Maintenance & Repairs Totals: 7,624.99 7,624.99 **
40,000.00 Budgeted 32,375.01 Remaining 19 % Used
Trophy Club Municipal Utility District No. 1 107 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 31
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-55090-020-000 Vehicle Maintenance
.00 .00
_______________
Account: 135-55090-020-000 Vehicle Maintenance Totals: .00 .00 **
2,000.00 Budgeted 2,000.00 Remaining 0 % Used
Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader
75 10/19/2012 Oct A/P 4 Skid Loader Tires PO 020858 1,080.96 1,080.96 BLAGG TIRE & SERVICE 31820 AP
_______________
Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: 1,080.96 1,080.96 **
1,500.00 Budgeted 419.04 Remaining 72 % Used
Account: 135-55125-020-000 Dumpster Services
.00 .00
_______________
Account: 135-55125-020-000 Dumpster Services Totals: .00 .00 **
15,000.00 Budgeted 15,000.00 Remaining 0 % Used
Account: 135-55135-020-000 Lab Analysis
145 10/31/2012 Oct A/P Bio-monitoring PO020871 1,080.00 1,080.00 HUTHER AND ASSOCIATES,INC 31883 AP
_______________
Account: 135-55135-020-000 Lab Analysis Totals: 1,080.00 1,080.00 **
30,000.00 Budgeted 28,920.00 Remaining 4 % Used
Account: 135-60010-020-000 Communications/Pagers/Mobiles
.00 .00
_______________
Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: .00 .00 **
2,700.00 Budgeted 2,700.00 Remaining 0 % Used
Account: 135-60020-020-000 Electricity
75 10/19/2012 Oct A/P Electricity 10/1-10/12 4,596.54 4,596.54 HUDSON ENERGY 31833 AP
_______________
Account: 135-60020-020-000 Electricity Totals: 4,596.54 4,596.54 **
153,045.00 Budgeted 148,448.46 Remaining 3 % Used
Account: 135-60066-020-000 Publications/Books/Subscripts
Trophy Club Municipal Utility District No. 1 108 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 32
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
.00 .00
_______________
Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 **
500.00 Budgeted 500.00 Remaining 0 % Used
Account: 135-60080-020-000 Schools & Training
.00 .00
_______________
Account: 135-60080-020-000 Schools & Training Totals: .00 .00 **
3,272.00 Budgeted 3,272.00 Remaining 0 % Used
Account: 135-60090-020-000 Safety Program
.00 .00
_______________
Account: 135-60090-020-000 Safety Program Totals: .00 .00 **
250.00 Budgeted 250.00 Remaining 0 % Used
Account: 135-60100-020-000 Travel & per diem
103 10/12/2012 Payroll 10/12/12 69.93 69.93 GL
105 10/26/2012 Payroll 10/26/12 46.62 116.55 GL
_______________
Account: 135-60100-020-000 Travel & per diem Totals: 116.55 116.55 **
1,400.00 Budgeted 1,283.45 Remaining 8 % Used
Account: 135-60105-020-000 Rent/Lease Equipment
75 10/19/2012 Oct A/P Rental 10HP waste pump PO02085 1,020.00 1,020.00 XYLEM WATER SOLUTIONS USA INC 31869 AP
_______________
Account: 135-60105-020-000 Rent/Lease Equipment Totals: 1,020.00 1,020.00 **
1,500.00 Budgeted 480.00 Remaining 68 % Used
Account: 135-60125-020-000 Advertising
.00 .00
_______________
Account: 135-60125-020-000 Advertising Totals: .00 .00 **
2,000.00 Budgeted 2,000.00 Remaining 0 % Used
Account: 135-60135-020-000 TCEQ Fees & Permits
Trophy Club Municipal Utility District No. 1 109 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 33
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
145 10/31/2012 Oct A/P CWQ Assessment fee 7,729.80 7,729.80 TX COMMISSION ENVIRONMENTAL QU 31898 AP
_______________
Account: 135-60135-020-000 TCEQ Fees & Permits Totals: 7,729.80 7,729.80 **
56,000.00 Budgeted 48,270.20 Remaining 14 % Used
Account: 135-60245-020-000 Miscellaneous Expenses
.00 .00
_______________
Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 **
200.00 Budgeted 200.00 Remaining 0 % Used
Account: 135-60285-020-000 Lawn Equipment & Maintenance
.00 .00
_______________
Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 .00 **
500.00 Budgeted 500.00 Remaining 0 % Used
Account: 135-65005-020-000 Fuel & Lube
.00 .00
_______________
Account: 135-65005-020-000 Fuel & Lube Totals: .00 .00 **
8,527.00 Budgeted 8,527.00 Remaining 0 % Used
Account: 135-65010-020-000 Uniforms
.00 .00
_______________
Account: 135-65010-020-000 Uniforms Totals: .00 .00 **
2,574.00 Budgeted 2,574.00 Remaining 0 % Used
Account: 135-65030-020-000 Chemicals
145 10/31/2012 Oct A/P Oct PCards 450.00 450.00 JPMORGAN CHASE BANK NA 31885 AP
145 10/31/2012 Oct A/P Oct PCards 450.00 900.00 JPMORGAN CHASE BANK NA 31885 AP
145 10/31/2012 Oct A/P Oct PCards 5,008.09 5,908.09 JPMORGAN CHASE BANK NA 31885 AP
145 10/31/2012 Oct A/P Non-ammonia polymer solvent PO 340.21 6,248.30 United Laboratories 31900 AP
_______________
Account: 135-65030-020-000 Chemicals Totals: 6,248.30 6,248.30 **
10,000.00 Budgeted 3,751.70 Remaining 62 % Used
Trophy Club Municipal Utility District No. 1 110 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 34
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-65035-020-000 Small Tools
.00 .00
_______________
Account: 135-65035-020-000 Small Tools Totals: .00 .00 **
1,000.00 Budgeted 1,000.00 Remaining 0 % Used
Account: 135-65040-020-000 Safety Equipment
.00 .00
_______________
Account: 135-65040-020-000 Safety Equipment Totals: .00 .00 **
250.00 Budgeted 250.00 Remaining 0 % Used
Account: 135-65045-020-000 Lab Supplies
145 10/31/2012 Oct A/P Lab supplies PO020860 3,855.26 3,855.26 IDEXX DISTRIBUTION, INC 31884 AP
_______________
Account: 135-65045-020-000 Lab Supplies Totals: 3,855.26 3,855.26 **
10,000.00 Budgeted 6,144.74 Remaining 39 % Used
Account: 135-69005-020-000 Capital Expenses
.00 .00
_______________
Account: 135-69005-020-000 Capital Expenses Totals: .00 .00 **
241,200.00 Budgeted 241,200.00 Remaining 0 % Used
Account: 135-69280-020-000 Capital Repairs
.00 .00
_______________
Account: 135-69280-020-000 Capital Repairs Totals: .00 .00 **
158,000.00 Budgeted 158,000.00 Remaining 0 % Used
Department 20 Totals: ------------------------------------------------------------------------------------------------ 52,962.54 **
1,039,428.00 Budgeted 986,465.46 Remaining 5 % Used
Trophy Club Municipal Utility District No. 1 111 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 35
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 21 Collection Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-50005-021-000 Salaries & Wages
232 10/01/2012 Reverse Sept P/R accrual (3,298.79) (3,298.79) GL
103 10/12/2012 Payroll 10/12/12 5,702.12 2,403.33 GL
105 10/26/2012 Payroll 10/26/12 5,772.88 8,176.21 GL
_______________
Account: 135-50005-021-000 Salaries & Wages Totals: 8,176.21 8,176.21 **
156,475.00 Budgeted 148,298.79 Remaining 5 % Used
Account: 135-50010-021-000 Overtime
232 10/01/2012 Reverse Sept P/R accrual (59.93) (59.93) GL
103 10/12/2012 Payroll 10/12/12 184.87 124.94 GL
103 10/12/2012 Payroll 10/12/12 80.00 204.94 GL
105 10/26/2012 Payroll 10/26/12 393.95 598.89 GL
_______________
Account: 135-50010-021-000 Overtime Totals: 598.89 598.89 **
7,297.00 Budgeted 6,698.11 Remaining 8 % Used
Account: 135-50016-021-000 Longevity
.00 .00
_______________
Account: 135-50016-021-000 Longevity Totals: .00 .00 **
3,818.00 Budgeted 3,818.00 Remaining 0 % Used
Account: 135-50017-021-000 Certification
103 10/12/2012 Payroll 10/12/12 150.00 150.00 GL
_______________
Account: 135-50017-021-000 Certification Totals: 150.00 150.00 **
1,800.00 Budgeted 1,650.00 Remaining 8 % Used
Account: 135-50020-021-000 Retirement
103 10/12/2012 Payroll 10/12/12 845.37 845.37 GL
105 10/26/2012 Payroll 10/26/12 852.26 1,697.63 GL
_______________
Account: 135-50020-021-000 Retirement Totals: 1,697.63 1,697.63 **
23,574.00 Budgeted 21,876.37 Remaining 7 % Used
Account: 135-50026-021-000 Medical Insurance
103 10/12/2012 Payroll 10/12/12 841.54 841.54 GL
Trophy Club Municipal Utility District No. 1 112 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 36
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 21 Collection Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
105 10/26/2012 Payroll 10/26/12 841.54 1,683.08 GL
_______________
Account: 135-50026-021-000 Medical Insurance Totals: 1,683.08 1,683.08 **
20,198.00 Budgeted 18,514.92 Remaining 8 % Used
Account: 135-50027-021-000 Dental Insurance
103 10/12/2012 Payroll 10/12/12 62.24 62.24 GL
105 10/26/2012 Payroll 10/26/12 62.24 124.48 GL
_______________
Account: 135-50027-021-000 Dental Insurance Totals: 124.48 124.48 **
1,409.00 Budgeted 1,284.52 Remaining 9 % Used
Account: 135-50028-021-000 Vision Insurance
103 10/12/2012 Payroll 10/12/12 14.86 14.86 GL
105 10/26/2012 Payroll 10/26/12 14.86 29.72 GL
_______________
Account: 135-50028-021-000 Vision Insurance Totals: 29.72 29.72 **
357.00 Budgeted 327.28 Remaining 8 % Used
Account: 135-50029-021-000 Life Insurance & Other
.00 .00
_______________
Account: 135-50029-021-000 Life Insurance & Other Totals: .00 .00 **
1,008.00 Budgeted 1,008.00 Remaining 0 % Used
Account: 135-50030-021-000 Social Security Taxes
103 10/12/2012 Payroll 10/12/12 351.97 351.97 GL
105 10/26/2012 Payroll 10/26/12 355.06 707.03 GL
_______________
Account: 135-50030-021-000 Social Security Taxes Totals: 707.03 707.03 **
10,502.00 Budgeted 9,794.97 Remaining 7 % Used
Account: 135-50035-021-000 Medicare Taxes
103 10/12/2012 Payroll 10/12/12 82.32 82.32 GL
105 10/26/2012 Payroll 10/26/12 83.03 165.35 GL
_______________
Account: 135-50035-021-000 Medicare Taxes Totals: 165.35 165.35 **
2,456.00 Budgeted 2,290.65 Remaining 7 % Used
Trophy Club Municipal Utility District No. 1 113 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 37
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 21 Collection Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-50040-021-000 Unemployment Taxes
.00 .00
_______________
Account: 135-50040-021-000 Unemployment Taxes Totals: .00 .00 **
567.00 Budgeted 567.00 Remaining 0 % Used
Account: 135-50045-021-000 Workman's Compensation
145 10/31/2012 Oct A/P MUD W/C FY 2013 3,348.00 3,348.00 TML INTERGOVERNMENTAL RISK 31896 AP
_______________
Account: 135-50045-021-000 Workman's Compensation Totals: 3,348.00 3,348.00 **
3,348.00 Budgeted .00 Remaining 100 % Used
Account: 135-50070-021-000 Employee Relations
.00 .00
_______________
Account: 135-50070-021-000 Employee Relations Totals: .00 .00 **
250.00 Budgeted 250.00 Remaining 0 % Used
Account: 135-55005-021-000 Engineering
.00 .00
_______________
Account: 135-55005-021-000 Engineering Totals: .00 .00 **
1,500.00 Budgeted 1,500.00 Remaining 0 % Used
Account: 135-55080-021-000 Maintenance & Repairs
145 10/31/2012 Oct A/P Fire extinguisher PM/Refill 168.50 168.50 KIMBROUGH FIRE EXTINQUISHER CO 31886 AP
_______________
Account: 135-55080-021-000 Maintenance & Repairs Totals: 168.50 168.50 **
35,000.00 Budgeted 34,831.50 Remaining 0 % Used
Account: 135-55090-021-000 Vehicle Maintenance
.00 .00
_______________
Account: 135-55090-021-000 Vehicle Maintenance Totals: .00 .00 **
1,900.00 Budgeted 1,900.00 Remaining 0 % Used
Account: 135-60010-021-000 Communications/Pagers/Mobiles
Trophy Club Municipal Utility District No. 1 114 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 38
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 21 Collection Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
.00 .00
_______________
Account: 135-60010-021-000 Communications/Pagers/Mobiles Totals: .00 .00 **
3,500.00 Budgeted 3,500.00 Remaining 0 % Used
Account: 135-60020-021-000 Electricity
75 10/19/2012 Oct A/P Electricity 10/1-10/11 230.10 230.10 HUDSON ENERGY 31833 AP
75 10/19/2012 Oct A/P Electricity 10/1-10/12 83.80 313.90 HUDSON ENERGY 31833 AP
75 10/19/2012 Oct A/P Electricity 10/1-10/11 18.97 332.87 HUDSON ENERGY 31833 AP
_______________
Account: 135-60020-021-000 Electricity Totals: 332.87 332.87 **
18,705.00 Budgeted 18,372.13 Remaining 2 % Used
Account: 135-60070-021-000 Dues & Memberships
.00 .00
_______________
Account: 135-60070-021-000 Dues & Memberships Totals: .00 .00 **
250.00 Budgeted 250.00 Remaining 0 % Used
Account: 135-60080-021-000 Schools & Training
145 10/31/2012 Oct A/P Oct PCards 90.00 90.00 JPMORGAN CHASE BANK NA 31885 AP
_______________
Account: 135-60080-021-000 Schools & Training Totals: 90.00 90.00 **
826.00 Budgeted 736.00 Remaining 11 % Used
Account: 135-60090-021-000 Safety Program
.00 .00
_______________
Account: 135-60090-021-000 Safety Program Totals: .00 .00 **
500.00 Budgeted 500.00 Remaining 0 % Used
Account: 135-60100-021-000 Travel & per diem
103 10/12/2012 Payroll 10/12/12 16.10 16.10 GL
105 10/26/2012 Payroll 10/26/12 3.33 19.43 GL
_______________
Account: 135-60100-021-000 Travel & per diem Totals: 19.43 19.43 **
450.00 Budgeted 430.57 Remaining 4 % Used
Trophy Club Municipal Utility District No. 1 115 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 39
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 21 Collection Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-60105-021-000 Rent/Lease Equipment
.00 .00
_______________
Account: 135-60105-021-000 Rent/Lease Equipment Totals: .00 .00 **
10,000.00 Budgeted 10,000.00 Remaining 0 % Used
Account: 135-60245-021-000 Miscellaneous Expenses
.00 .00
_______________
Account: 135-60245-021-000 Miscellaneous Expenses Totals: .00 .00 **
100.00 Budgeted 100.00 Remaining 0 % Used
Account: 135-65005-021-000 Fuel & Lube
.00 .00
_______________
Account: 135-65005-021-000 Fuel & Lube Totals: .00 .00 **
12,117.00 Budgeted 12,117.00 Remaining 0 % Used
Account: 135-65010-021-000 Uniforms
.00 .00
_______________
Account: 135-65010-021-000 Uniforms Totals: .00 .00 **
2,220.00 Budgeted 2,220.00 Remaining 0 % Used
Account: 135-65030-021-000 Chemicals
.00 .00
_______________
Account: 135-65030-021-000 Chemicals Totals: .00 .00 **
7,500.00 Budgeted 7,500.00 Remaining 0 % Used
Account: 135-65035-021-000 Small Tools
.00 .00
_______________
Account: 135-65035-021-000 Small Tools Totals: .00 .00 **
1,500.00 Budgeted 1,500.00 Remaining 0 % Used
Account: 135-65040-021-000 Safety Equipment
Trophy Club Municipal Utility District No. 1 116 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 40
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 21 Collection Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
.00 .00
_______________
Account: 135-65040-021-000 Safety Equipment Totals: .00 .00 **
500.00 Budgeted 500.00 Remaining 0 % Used
Account: 135-69005-021-000 Capital Expenses
.00 .00
_______________
Account: 135-69005-021-000 Capital Expenses Totals: .00 .00 **
90,000.00 Budgeted 90,000.00 Remaining 0 % Used
Account: 135-69008-021-000 Short Term Debt Payments
.00 .00
_______________
Account: 135-69008-021-000 Short Term Debt Payments Totals: .00 .00 **
40,260.00 Budgeted 40,260.00 Remaining 0 % Used
Department 21 Totals: ------------------------------------------------------------------------------------------------ 17,291.19 **
459,887.00 Budgeted 442,595.81 Remaining 4 % Used
Trophy Club Municipal Utility District No. 1 117 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 41
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-50005-026-000 Salaries & Wages
105 10/26/2012 Payroll 10/26/12 500.00 500.00 GL
_______________
Account: 135-50005-026-000 Salaries & Wages Totals: 500.00 500.00 **
10,000.00 Budgeted 9,500.00 Remaining 5 % Used
Account: 135-50030-026-000 Social Security Taxes
105 10/26/2012 Payroll 10/26/12 31.00 31.00 GL
_______________
Account: 135-50030-026-000 Social Security Taxes Totals: 31.00 31.00 **
620.00 Budgeted 589.00 Remaining 5 % Used
Account: 135-50035-026-000 Medicare Taxes
105 10/26/2012 Payroll 10/26/12 7.25 7.25 GL
_______________
Account: 135-50035-026-000 Medicare Taxes Totals: 7.25 7.25 **
145.00 Budgeted 137.75 Remaining 5 % Used
Account: 135-50040-026-000 Unemployment Taxes
105 10/26/2012 Payroll 10/26/12 14.50 14.50 GL
_______________
Account: 135-50040-026-000 Unemployment Taxes Totals: 14.50 14.50 **
210.00 Budgeted 195.50 Remaining 7 % Used
Account: 135-50045-026-000 Workman's Compensation
.00 .00
_______________
Account: 135-50045-026-000 Workman's Compensation Totals: .00 .00 **
150.00 Budgeted 150.00 Remaining 0 % Used
Account: 135-60066-026-000 Publications/Books/Subscripts
.00 .00
_______________
Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 **
150.00 Budgeted 150.00 Remaining 0 % Used
Account: 135-60070-026-000 Dues & Memberships
Trophy Club Municipal Utility District No. 1 118 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 42
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
.00 .00
_______________
Account: 135-60070-026-000 Dues & Memberships Totals: .00 .00 **
2,100.00 Budgeted 2,100.00 Remaining 0 % Used
Account: 135-60075-026-000 Meetings
75 10/19/2012 Oct A/P Chamber luncheon 22.00 22.00 NORTHWEST METROPORT CHAMBER 31844 AP
_______________
Account: 135-60075-026-000 Meetings Totals: 22.00 22.00 **
1,200.00 Budgeted 1,178.00 Remaining 2 % Used
Account: 135-60080-026-000 Schools & Training
.00 .00
_______________
Account: 135-60080-026-000 Schools & Training Totals: .00 .00 **
4,000.00 Budgeted 4,000.00 Remaining 0 % Used
Account: 135-60100-026-000 Travel & per diem
.00 .00
_______________
Account: 135-60100-026-000 Travel & per diem Totals: .00 .00 **
5,000.00 Budgeted 5,000.00 Remaining 0 % Used
Account: 135-60245-026-000 Miscellaneous Expenses
.00 .00
_______________
Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 .00 **
3,000.00 Budgeted 3,000.00 Remaining 0 % Used
Department 26 Totals: ------------------------------------------------------------------------------------------------ 574.75 **
26,575.00 Budgeted 26,000.25 Remaining 2 % Used
Trophy Club Municipal Utility District No. 1 119 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 43
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-50005-030-000 Salaries & Wages
232 10/01/2012 Reverse Sept P/R accrual (8,073.48) (8,073.48) GL
103 10/12/2012 Payroll 10/12/12 17,039.38 8,965.90 GL
105 10/26/2012 Payroll 10/26/12 16,904.44 25,870.34 GL
_______________
Account: 135-50005-030-000 Salaries & Wages Totals: 25,870.34 25,870.34 **
444,730.00 Budgeted 418,859.66 Remaining 6 % Used
Account: 135-50010-030-000 Overtime
232 10/01/2012 Reverse Sept P/R accrual (7.38) (7.38) GL
103 10/12/2012 Payroll 10/12/12 6.00 (1.38) GL
105 10/26/2012 Payroll 10/26/12 10.32 8.94 GL
_______________
Account: 135-50010-030-000 Overtime Totals: 8.94 8.94 **
1,500.00 Budgeted 1,491.06 Remaining 1 % Used
Account: 135-50016-030-000 Longevity
.00 .00
_______________
Account: 135-50016-030-000 Longevity Totals: .00 .00 **
2,193.00 Budgeted 2,193.00 Remaining 0 % Used
Account: 135-50020-030-000 Retirement
103 10/12/2012 Payroll 10/12/12 2,272.24 2,272.24 GL
105 10/26/2012 Payroll 10/26/12 2,253.24 4,525.48 GL
_______________
Account: 135-50020-030-000 Retirement Totals: 4,525.48 4,525.48 **
60,441.00 Budgeted 55,915.52 Remaining 7 % Used
Account: 135-50026-030-000 Medical Insurance
103 10/12/2012 Payroll 10/12/12 1,592.65 1,592.65 GL
105 10/26/2012 Payroll 10/26/12 1,592.65 3,185.30 GL
_______________
Account: 135-50026-030-000 Medical Insurance Totals: 3,185.30 3,185.30 **
44,066.00 Budgeted 40,880.70 Remaining 7 % Used
Account: 135-50027-030-000 Dental Insurance
103 10/12/2012 Payroll 10/12/12 144.36 144.36 GL
Trophy Club Municipal Utility District No. 1 120 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 44
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
105 10/26/2012 Payroll 10/26/12 144.36 288.72 GL
_______________
Account: 135-50027-030-000 Dental Insurance Totals: 288.72 288.72 **
3,379.00 Budgeted 3,090.28 Remaining 9 % Used
Account: 135-50028-030-000 Vision Insurance
103 10/12/2012 Payroll 10/12/12 33.10 33.10 GL
105 10/26/2012 Payroll 10/26/12 33.10 66.20 GL
_______________
Account: 135-50028-030-000 Vision Insurance Totals: 66.20 66.20 **
795.00 Budgeted 728.80 Remaining 8 % Used
Account: 135-50029-030-000 Life Insurance & Other
.00 .00
_______________
Account: 135-50029-030-000 Life Insurance & Other Totals: .00 .00 **
2,500.00 Budgeted 2,500.00 Remaining 0 % Used
Account: 135-50030-030-000 Social Security Taxes
103 10/12/2012 Payroll 10/12/12 972.76 972.76 GL
105 10/26/2012 Payroll 10/26/12 964.66 1,937.42 GL
_______________
Account: 135-50030-030-000 Social Security Taxes Totals: 1,937.42 1,937.42 **
27,802.00 Budgeted 25,864.58 Remaining 7 % Used
Account: 135-50035-030-000 Medicare Taxes
103 10/12/2012 Payroll 10/12/12 227.51 227.51 GL
105 10/26/2012 Payroll 10/26/12 225.60 453.11 GL
_______________
Account: 135-50035-030-000 Medicare Taxes Totals: 453.11 453.11 **
6,502.00 Budgeted 6,048.89 Remaining 7 % Used
Account: 135-50040-030-000 Unemployment Taxes
103 10/12/2012 Payroll 10/12/12 100.05 100.05 GL
105 10/26/2012 Payroll 10/26/12 95.79 195.84 GL
_______________
Account: 135-50040-030-000 Unemployment Taxes Totals: 195.84 195.84 **
1,537.00 Budgeted 1,341.16 Remaining 13 % Used
Trophy Club Municipal Utility District No. 1 121 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 45
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-50045-030-000 Workman's Compensation
145 10/31/2012 Oct A/P MUD W/C FY 2013 831.00 831.00 TML INTERGOVERNMENTAL RISK 31896 AP
_______________
Account: 135-50045-030-000 Workman's Compensation Totals: 831.00 831.00 **
831.00 Budgeted .00 Remaining 100 % Used
Account: 135-50060-030-000 Pre-emp Physicals/Testing
145 10/31/2012 Oct A/P Pre-employment-Sisk 35.00 35.00 CARENOW CORPORATE 31876 AP
_______________
Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: 35.00 35.00 **
250.00 Budgeted 215.00 Remaining 14 % Used
Account: 135-50070-030-000 Employee Relations
.00 .00
_______________
Account: 135-50070-030-000 Employee Relations Totals: .00 .00 **
5,000.00 Budgeted 5,000.00 Remaining 0 % Used
Account: 135-55030-030-000 Software & Support
181 10/31/2012 Oct A/P PCards Pastor 25.00 25.00 BANK OF AMERICA 31902 AP
181 10/31/2012 Oct A/P PCards Zieverink 55.37 80.37 BANK OF AMERICA 31902 AP
181 10/31/2012 Oct A/P PCards Zieverink 53.38 133.75 BANK OF AMERICA 31902 AP
145 10/31/2012 Oct A/P VMWare Annual Maintenance 2,828.00 2,961.75 SHI GOVERNMENT SOLUTIONS,INC 31891 AP
_______________
Account: 135-55030-030-000 Software & Support Totals: 2,961.75 2,961.75 **
63,555.00 Budgeted 60,593.25 Remaining 5 % Used
Account: 135-55070-030-000 Independent Labor
.00 .00
_______________
Account: 135-55070-030-000 Independent Labor Totals: .00 .00 **
2,700.00 Budgeted 2,700.00 Remaining 0 % Used
Account: 135-55075-030-000 Records Management
.00 .00
_______________
Account: 135-55075-030-000 Records Management Totals: .00 .00 **
500.00 Budgeted 500.00 Remaining 0 % Used
Trophy Club Municipal Utility District No. 1 122 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 46
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-55100-030-000 Building Maint & Supplies
145 10/31/2012 Oct A/P Oct PCards 32.36 32.36 JPMORGAN CHASE BANK NA 31885 AP
_______________
Account: 135-55100-030-000 Building Maint & Supplies Totals: 32.36 32.36 **
5,000.00 Budgeted 4,967.64 Remaining 1 % Used
Account: 135-55120-030-000 Cleaning Services
75 10/19/2012 Oct A/P Oct Cleaning services 1,678.51 1,678.51 ABM JANITORIAL SERVICES, INC 31816 AP
_______________
Account: 135-55120-030-000 Cleaning Services Totals: 1,678.51 1,678.51 **
20,200.00 Budgeted 18,521.49 Remaining 8 % Used
Account: 135-55160-030-000 Professional Outside Services
.00 .00
_______________
Account: 135-55160-030-000 Professional Outside Services Totals: .00 .00 **
15,000.00 Budgeted 15,000.00 Remaining 0 % Used
Account: 135-55161-030-000 Outside Services-Town Semo
.00 .00
_______________
Account: 135-55161-030-000 Outside Services-Town Semo Totals: .00 .00 **
85,465.00 Budgeted 85,465.00 Remaining 0 % Used
Account: 135-55165-030-000 Collection Fees
106 10/24/2012 AMS Collection Check 10/24/12 21.19 21.19 GL
109 10/25/2012 UB 10/25/12 AMS Collection Ck CR Posting _20121025-20121025 138.58 159.77 CR
_______________
Account: 135-55165-030-000 Collection Fees Totals: 159.77 159.77 **
.00 Budgeted (159.77) Remaining 0 % Used
Account: 135-55205-030-000 Utility Billing Contract
.00 .00
_______________
Account: 135-55205-030-000 Utility Billing Contract Totals: .00 .00 **
11,000.00 Budgeted 11,000.00 Remaining 0 % Used
Account: 135-60005-030-000 Telephone
Trophy Club Municipal Utility District No. 1 123 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 47
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
181 10/31/2012 Oct A/P PCards Zieverink 95.66 95.66 BANK OF AMERICA 31902 AP
181 10/31/2012 Oct A/P PCards Zieverink 76.30 171.96 BANK OF AMERICA 31902 AP
181 10/31/2012 Oct A/P PCards Zieverink 377.41 549.37 BANK OF AMERICA 31902 AP
181 10/31/2012 Oct A/P PCards Zieverink 395.49 944.86 BANK OF AMERICA 31902 AP
181 10/31/2012 Oct A/P PCards Zieverink 394.48 1,339.34 BANK OF AMERICA 31902 AP
_______________
Account: 135-60005-030-000 Telephone Totals: 1,339.34 1,339.34 **
9,000.00 Budgeted 7,660.66 Remaining 15 % Used
Account: 135-60010-030-000 Communications/Pagers/Mobiles
103 10/12/2012 Payroll 10/12/12 150.00 150.00 GL
_______________
Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 150.00 150.00 **
3,575.00 Budgeted 3,425.00 Remaining 4 % Used
Account: 135-60020-030-000 Electricity/Gas
.00 .00
_______________
Account: 135-60020-030-000 Electricity/Gas Totals: .00 .00 **
13,019.00 Budgeted 13,019.00 Remaining 0 % Used
Account: 135-60025-030-000 Water
.00 .00
_______________
Account: 135-60025-030-000 Water Totals: .00 .00 **
3,100.00 Budgeted 3,100.00 Remaining 0 % Used
Account: 135-60030-030-000 Rent And/Or Usage
.00 .00
_______________
Account: 135-60030-030-000 Rent And/Or Usage Totals: .00 .00 **
13,182.00 Budgeted 13,182.00 Remaining 0 % Used
Account: 135-60035-030-000 Postage
181 10/31/2012 Oct A/P Leak post cards PO 447908 557.66 557.66 U.S. POSTAL SERVICE 31903 AP
145 10/31/2012 Oct A/P Permit 3 95.00 652.66 U.S. POSTAL SERVICE 31899 AP
_______________
Account: 135-60035-030-000 Postage Totals: 652.66 652.66 **
23,000.00 Budgeted 22,347.34 Remaining 3 % Used
Trophy Club Municipal Utility District No. 1 124 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 48
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-60040-030-000 Service Charges & Fees
231 10/02/2012 Credit Card/Online fees 62.22 62.22 GL
231 10/02/2012 Credit Card/Online fees 75.70 137.92 GL
231 10/02/2012 Credit Card/Online fees 2,612.91 2,750.83 GL
_______________
Account: 135-60040-030-000 Service Charges & Fees Totals: 2,750.83 2,750.83 **
18,000.00 Budgeted 15,249.17 Remaining 15 % Used
Account: 135-60050-030-000 Bad Debt Expense
251 10/31/2012 Recodes per J McKnight (1,056.53) (1,056.53) GL
_______________
Account: 135-60050-030-000 Bad Debt Expense Totals: (1,056.53) (1,056.53) **
8,500.00 Budgeted 9,556.53 Remaining -12 % Used
Account: 135-60055-030-000 Insurance
145 10/31/2012 Oct A/P Insurance for FY 2012 33,965.48 33,965.48 TML INTERGOVERNMENTAL RISK 31897 AP
145 10/31/2012 Oct A/P Bond Womack 50.00 34,015.48 VICTOR O SCHINNERER & CO, INC 31901 AP
145 10/31/2012 Oct A/P Bond G Cook 50.00 34,065.48 VICTOR O SCHINNERER & CO, INC 31901 AP
_______________
Account: 135-60055-030-000 Insurance Totals: 34,065.48 34,065.48 **
35,000.00 Budgeted 934.52 Remaining 97 % Used
Account: 135-60066-030-000 Publications/Books/Subscripts
145 10/31/2012 Oct A/P Governmental GAAP Guide 449.22 449.22 CCH 31877 AP
_______________
Account: 135-60066-030-000 Publications/Books/Subscripts Totals: 449.22 449.22 **
750.00 Budgeted 300.78 Remaining 60 % Used
Account: 135-60070-030-000 Dues & Memberships
114 10/26/2012 Oct A/P Annual Membership-State of Tx 100.00 100.00 TX COMPTROLLER 31870 AP
_______________
Account: 135-60070-030-000 Dues & Memberships Totals: 100.00 100.00 **
2,400.00 Budgeted 2,300.00 Remaining 4 % Used
Account: 135-60075-030-000 Meetings
75 10/19/2012 Oct A/P Chamber luncheon 88.00 88.00 NORTHWEST METROPORT CHAMBER 31844 AP
_______________
Account: 135-60075-030-000 Meetings Totals: 88.00 88.00 **
250.00 Budgeted 162.00 Remaining 35 % Used
Trophy Club Municipal Utility District No. 1 125 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 49
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-60080-030-000 Schools & Training
.00 .00
_______________
Account: 135-60080-030-000 Schools & Training Totals: .00 .00 **
5,500.00 Budgeted 5,500.00 Remaining 0 % Used
Account: 135-60100-030-000 Travel & per diem
105 10/26/2012 Payroll 10/26/12 10.05 10.05 GL
_______________
Account: 135-60100-030-000 Travel & per diem Totals: 10.05 10.05 **
3,950.00 Budgeted 3,939.95 Remaining 0 % Used
Account: 135-60110-030-000 Physicals/Testing
.00 .00
_______________
Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 **
500.00 Budgeted 500.00 Remaining 0 % Used
Account: 135-60125-030-000 Advertising
.00 .00
_______________
Account: 135-60125-030-000 Advertising Totals: .00 .00 **
4,000.00 Budgeted 4,000.00 Remaining 0 % Used
Account: 135-60235-030-000 Security
.00 .00
_______________
Account: 135-60235-030-000 Security Totals: .00 .00 **
1,350.00 Budgeted 1,350.00 Remaining 0 % Used
Account: 135-60245-030-000 Miscellaneous Expenses
242 10/31/2012 Bank Rec adjustment 13.00 13.00 GL
_______________
Account: 135-60245-030-000 Miscellaneous Expenses Totals: 13.00 13.00 **
15,000.00 Budgeted 14,987.00 Remaining 0 % Used
Account: 135-60270-030-000 4th of July Celebration
Trophy Club Municipal Utility District No. 1 126 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 50
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
.00 .00
_______________
Account: 135-60270-030-000 4th of July Celebration Totals: .00 .00 **
10,500.00 Budgeted 10,500.00 Remaining 0 % Used
Account: 135-60360-030-000 Furniture/Equipment < $5000
75 10/19/2012 Oct A/P Furniture/Sisk 265.00 265.00 TEXAS FACILITIES COMMISSION 31859 AP
_______________
Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: 265.00 265.00 **
2,500.00 Budgeted 2,235.00 Remaining 11 % Used
Account: 135-65010-030-000 Uniforms
.00 .00
_______________
Account: 135-65010-030-000 Uniforms Totals: .00 .00 **
1,635.00 Budgeted 1,635.00 Remaining 0 % Used
Account: 135-65055-030-000 Hardware
75 10/19/2012 Oct A/P Hardware/IT 33.94 33.94 SHI GOVERNMENT SOLUTIONS,INC 31853 AP
181 10/31/2012 Oct A/P PCards Pastor 1,796.41 1,830.35 BANK OF AMERICA 31902 AP
181 10/31/2012 Oct A/P PCards Pastor 319.00 2,149.35 BANK OF AMERICA 31902 AP
181 10/31/2012 Oct A/P PCards Pastor 1,461.34 3,610.69 BANK OF AMERICA 31902 AP
181 10/31/2012 Oct A/P PCards Pastor 974.23 4,584.92 BANK OF AMERICA 31902 AP
181 10/31/2012 Oct A/P PCards Zieverink 379.97 4,964.89 BANK OF AMERICA 31902 AP
145 10/31/2012 Oct A/P Intel Gigabit ET2 Quad Port Se 202.00 5,166.89 SHI GOVERNMENT SOLUTIONS,INC 31891 AP
145 10/31/2012 Oct A/P Projector lamp 193.00 5,359.89 SHI GOVERNMENT SOLUTIONS,INC 31891 AP
145 10/31/2012 Oct A/P Printer & toner for Terri Sisk 321.00 5,680.89 SHI GOVERNMENT SOLUTIONS,INC 31891 AP
145 10/31/2012 Oct A/P Fire extinguisher PM/Refill 58.00 5,738.89 KIMBROUGH FIRE EXTINQUISHER CO 31886 AP
_______________
Account: 135-65055-030-000 Hardware Totals: 5,738.89 5,738.89 **
20,188.00 Budgeted 14,449.11 Remaining 28 % Used
Account: 135-65085-030-000 Office Supplies
75 10/19/2012 Oct A/P Office supplies 70.92 70.92 OFFICE DEPOT, INC 31845 AP
75 10/19/2012 Oct A/P Office supplies 6.42 77.34 OFFICE DEPOT, INC 31845 AP
75 10/19/2012 Oct A/P PO Books 6.74 84.08 OFFICE DEPOT, INC 31845 AP
75 10/19/2012 Oct A/P Office Supplies 366.08 450.16 OFFICE DEPOT, INC 31845 AP
75 10/19/2012 Oct A/P Metal ruler 1.00 451.16 OFFICE DEPOT, INC 31845 AP
75 10/19/2012 Oct A/P Copier paper PO 447902 18.06 469.22 OFFICE DEPOT, INC 31845 AP
Trophy Club Municipal Utility District No. 1 127 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 51
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
145 10/31/2012 Oct A/P Office supplies PO447904 14.96 484.18 OFFICE DEPOT, INC 31890 AP
145 10/31/2012 Oct A/P Office Supplies PO447906 140.71 624.89 OFFICE DEPOT, INC 31890 AP
145 10/31/2012 Oct A/P Credit memo (23.36) 601.53 OFFICE DEPOT, INC 31890 AP
145 10/31/2012 Oct A/P Office supplies PO 447905 159.04 760.57 OFFICE DEPOT, INC 31890 AP
145 10/31/2012 Oct A/P Oct PCards 55.58 816.15 JPMORGAN CHASE BANK NA 31885 AP
_______________
Account: 135-65085-030-000 Office Supplies Totals: 816.15 816.15 **
8,200.00 Budgeted 7,383.85 Remaining 10 % Used
Account: 135-65090-030-000 Printer Supplies & Maintenance
145 10/31/2012 Oct A/P Laserjet 110v fuser kit 78.00 78.00 SHI GOVERNMENT SOLUTIONS,INC 31891 AP
145 10/31/2012 Oct A/P Printer & toner for Terri Sisk 148.00 226.00 SHI GOVERNMENT SOLUTIONS,INC 31891 AP
_______________
Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 226.00 226.00 **
5,732.00 Budgeted 5,506.00 Remaining 4 % Used
Account: 135-65095-030-000 Maintenance Supplies
.00 .00
_______________
Account: 135-65095-030-000 Maintenance Supplies Totals: .00 .00 **
2,000.00 Budgeted 2,000.00 Remaining 0 % Used
Account: 135-65097-030-000 Vending Machine Supplies
.00 .00
_______________
Account: 135-65097-030-000 Vending Machine Supplies Totals: .00 .00 **
500.00 Budgeted 500.00 Remaining 0 % Used
Account: 135-65105-030-000 Printing
.00 .00
_______________
Account: 135-65105-030-000 Printing Totals: .00 .00 **
5,200.00 Budgeted 5,200.00 Remaining 0 % Used
Account: 135-69170-030-000 Copier Lease Installments
75 10/19/2012 Oct A/P Copier lease/Oct 256.85 256.85 KYOCERA MITA AMERICA, INC. 31835 AP
_______________
Account: 135-69170-030-000 Copier Lease Installments Totals: 256.85 256.85 **
3,450.00 Budgeted 3,193.15 Remaining 7 % Used
Trophy Club Municipal Utility District No. 1 128 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 52
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-69195-030-000 Gasb34/Reserve for Replacement
.00 .00
_______________
Account: 135-69195-030-000 Gasb34/Reserve for Replacement Totals: .00 .00 **
26,911.00 Budgeted 26,911.00 Remaining 0 % Used
Department 30 Totals: ------------------------------------------------------------------------------------------------ 88,094.68 **
1,051,838.00 Budgeted 963,743.32 Remaining 8 % Used
Trophy Club Municipal Utility District No. 1 129 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 53
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-55045-039-000 Legal
.00 .00
_______________
Account: 135-55045-039-000 Legal Totals: .00 .00 **
70,000.00 Budgeted 70,000.00 Remaining 0 % Used
Account: 135-55055-039-000 Auditing
.00 .00
_______________
Account: 135-55055-039-000 Auditing Totals: .00 .00 **
21,200.00 Budgeted 21,200.00 Remaining 0 % Used
Account: 135-55060-039-000 Appraisal
145 10/31/2012 Oct A/P Budget allocations annual 2,322.74 2,322.74 TARRANT APPRAISAL DISTRICT 31895 AP
_______________
Account: 135-55060-039-000 Appraisal Totals: 2,322.74 2,322.74 **
15,100.00 Budgeted 12,777.26 Remaining 15 % Used
Account: 135-55065-039-000 Tax Admin Fees
.00 .00
_______________
Account: 135-55065-039-000 Tax Admin Fees Totals: .00 .00 **
3,800.00 Budgeted 3,800.00 Remaining 0 % Used
Department 39 Totals: ------------------------------------------------------------------------------------------------ 2,322.74 **
110,100.00 Budgeted 107,777.26 Remaining 2 % Used
Fund 135 Totals: ------------------------------------------------------------------------------------------------------ (265,247.10)
.00 Budgeted 265,247.10 Remaining 0 % Used
Trophy Club Municipal Utility District No. 1 130 of 193 November 20, 2012
Municipal Utility District No 1
Fire Department O & M
Interim Balance Sheet
Balance @
10/31/2012
ASSETS
ASSETS
CASH IN BANK -$
INVESTMENTS 326,693
ACCOUNTS RECEIVABLE - ADVALOREM TAXES 1,028,199
ACCOUNTS RECEIVABLE - PID EMER SERVICES 246,750
OTHER RECEIVABLES 25,733
TOTAL ASSETS 1,627,375$
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE 1,274,949$
ACCOUNTS PAYABLE 23,531
TOTAL LIABILITIES 1,298,480$
FUND BALANCE
UNASSIGNED FUND BALANCE 328,895
TOTAL LIABILITIES AND FUND BALANCE 1,627,375$
October 31, 2012
1/12 Months (8.33% of Fiscal Year)
Trophy Club Municipal Utility District No. 1 131 of 193 November 20, 2012
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 1
15:59 11/15/12 Budget Summary with Amendment
Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program:
Period Ending: 10/2012
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
122-40001-000-000 Assessment - Emerg Svcs 252,084.00- 252,084.00- 3,671.06- 3,671.06- 1.456 248,412.94-
122-40003-000-000 Emer Svcs Assessmen/Delinquent 4,700.00- 4,700.00- 5.36- 5.36- .114 4,694.64-
122-40010-000-000 Property Taxes/MUD Fire 1,050,349.00- 1,050,349.00- 26,422.94- 26,422.94- 2.516 1,023,926.06-
122-40011-000-000 Property Taxes/Fire-Delinquent 5,800.00- 5,800.00- 2,362.65- 2,362.65- 40.735 3,437.35-
122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- 1.08- 1.08- .144 748.92-
122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 593.43- 593.43- 13.187 3,906.57-
Subtotal: 1,318,183.00- 1,318,183.00- 33,056.52- 33,056.52- 2.508 1,285,126.48-
122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 6,000.00-
Subtotal: 6,000.00- 6,000.00- 6,000.00-
122-43400-000-000 Fire Inspections 500.00- 500.00- 500.00-
122-43415-000-000 Denton/Tarrant Cty Pledge-Fire 10,000.00- 10,000.00- 10,000.00-
Subtotal: 10,500.00- 10,500.00- 10,500.00-
122-49900-000-000 Miscellaneous Income 1,200.00- 1,200.00- 1,200.00-
Subtotal: 1,200.00- 1,200.00- 1,200.00-
Program number: 1,335,883.00- 1,335,883.00- 33,056.52- 33,056.52- 2.475 1,302,826.48-
Department number: Fire Revenues 1,335,883.00- 1,335,883.00- 33,056.52- 33,056.52- 2.475 1,302,826.48-
Revenues Subtotal ----------- 1,335,883.00- 1,335,883.00- 33,056.52- 33,056.52- 2.475 1,302,826.48-
Trophy Club Municipal Utility District No. 1 132 of 193 November 20, 2012
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 2
15:59 11/15/12 Budget Summary with Amendment
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 10/2012
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
122-50005-045-000 Salaries & Wages 444,717.00 444,717.00 22,869.40 22,869.40 5.142 421,847.60
122-50010-045-000 Overtime 31,375.00 31,375.00 2,552.34 2,552.34 8.135 28,822.66
122-50011-045-000 DPS Holiday Pay 13,083.00 13,083.00 13,083.00
122-50016-045-000 Longevity 4,266.00 4,266.00 4,266.00
122-50017-045-000 Certification 4,896.00 4,896.00 575.00 575.00 11.744 4,321.00
122-50020-045-000 Retirement 69,242.00 69,242.00 4,687.17 4,687.17 6.769 64,554.83
122-50026-045-000 Medical Insurance 48,327.00 48,327.00 3,336.51 3,336.51 6.904 44,990.49
122-50027-045-000 Dental Insurance 3,635.00 3,635.00 311.93 311.93 8.581 3,323.07
122-50028-045-000 Vision Insurance 824.00 824.00 64.11 64.11 7.780 759.89
122-50029-045-000 Life Insurance & Other 4,250.00 4,250.00 4,250.00
122-50030-045-000 Social Security Taxes 30,897.00 30,897.00 1,993.94 1,993.94 6.454 28,903.06
122-50035-045-000 Medicare Taxes 7,226.00 7,226.00 466.36 466.36 6.454 6,759.64
122-50040-045-000 Unemployment Taxes 1,481.00 1,481.00 22.78 22.78 1.538 1,458.22
122-50045-045-000 Workman's Compensation 10,000.00 10,000.00 10,000.00 10,000.00 100.000
122-50060-045-000 Pre-employment Physicals/Test 675.00 675.00 675.00
122-50075-045-000 Tuition Reimbursement 1,500.00 1,500.00 1,500.00
Subtotal: 676,394.00 676,394.00 46,879.54 46,879.54 6.931 629,514.46
122-55080-045-000 Maintenance & Repairs 9,562.00 9,562.00 292.00 292.00 3.054 9,270.00
122-55090-045-000 Vehicle Maintenance 14,850.00 14,850.00 272.57 272.57 1.835 14,577.43
122-55095-045-000 Equipment Maintenance 9,808.00 9,808.00 9,808.00
122-55100-045-000 Building Maintenance 6,500.00 6,500.00 243.51 243.51 3.746 6,256.49
122-55110-045-000 Maintenance-Radios 1,103.00 1,103.00 1,103.00
122-55160-045-000 Professional Outside Services 2,500.00 2,500.00 2,500.00
Subtotal: 44,323.00 44,323.00 808.08 808.08 1.823 43,514.92
122-60005-045-000 Telephone 106.00 106.00 13.01 13.01 12.274 92.99
122-60010-045-000 Communications/Pagers/Mobiles 2,500.00 2,500.00 1,391.00 1,391.00 55.640 1,109.00
122-60020-045-000 Electricity/Gas 6,167.00 6,167.00 382.64 382.64 6.205 5,784.36
122-60025-045-000 Water 1,400.00 1,400.00 1,400.00
122-60030-045-000 Rent And/Or Usage 308,000.00 308,000.00 308,000.00
122-60035-045-000 Postage 100.00 100.00 100.00
122-60055-045-000 Insurance 10,000.00 10,000.00 50.00 50.00 .500 9,950.00
122-60066-045-000 Publications/Books/Subscrips 410.00 410.00 410.00
122-60070-045-000 Dues & Memberships 7,500.00 7,500.00 6,820.91 6,820.91 90.945 679.09
122-60075-045-000 Meetings 75.00 75.00 75.00
122-60080-045-000 Schools & Training 5,000.00 5,000.00 5,000.00
122-60096-045-000 Emergency Management 1,000.00 1,000.00 1,000.00
122-60100-045-000 Travel & per diem 4,800.00 4,800.00 4,800.00
122-60110-045-000 Physicals/Testing 2,000.00 2,000.00 2,000.00
122-60125-045-000 Advertising 150.00 150.00 122.35 122.35 81.567 27.65
122-60160-045-000 Programs & Special Projects 4,200.00 4,200.00 270.00 270.00 6.429 3,930.00
Trophy Club Municipal Utility District No. 1 133 of 193 November 20, 2012
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 3
15:59 11/15/12 Budget Summary with Amendment
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 10/2012
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
122-60180-045-000 Fire Inspection/Enforcement 1,900.00 1,900.00 1,900.00
122-60195-045-000 Flags & Repair 2,543.00 2,543.00 149.75 149.75 5.889 2,393.25
122-60245-045-000 Miscellaneous Expense 1,237.00 1,237.00 43.20 43.20 3.492 1,193.80
Subtotal: 359,088.00 359,088.00 9,242.86 9,242.86 2.574 349,845.14
122-65005-045-000 Fuel & Lube 10,000.00 10,000.00 10,000.00
122-65010-045-000 Uniforms 4,357.00 4,357.00 4,357.00
122-65015-045-000 Protective Clothing 7,600.00 7,600.00 7,600.00
122-65030-045-000 Chemicals 1,000.00 1,000.00 1,000.00
122-65035-045-000 Small Tools 5,000.00 5,000.00 5,000.00
122-65085-045-000 Office Supplies 1,200.00 1,200.00 5.56 5.56 .463 1,194.44
122-65095-045-000 Maintenance Supplies 2,785.00 2,785.00 2,785.00
122-65105-045-000 Printing 106.00 106.00 106.00
Subtotal: 32,048.00 32,048.00 5.56 5.56 .017 32,042.44
122-69006-045-000 Grant Match 3,000.00 3,000.00 3,000.00
122-69008-045-000 Short Term Debt Payments 72,932.00 72,932.00 72,932.00
122-69050-045-000 Radios 2,500.00 2,500.00 2,500.00
122-69195-045-000 GASB34/Reserve for Replacement 145,598.00 145,598.00 145,598.00
Subtotal: 224,030.00 224,030.00 224,030.00
Program number: 1,335,883.00 1,335,883.00 56,936.04 56,936.04 4.262 1,278,946.96
Department number: Fire 1,335,883.00 1,335,883.00 56,936.04 56,936.04 4.262 1,278,946.96
Expenditures Subtotal ----------- 1,335,883.00 1,335,883.00 56,936.04 56,936.04 4.262 1,278,946.96
Fund number: 122 Trophy Club MUD Fire Dept. 23,879.52 23,879.52 23,879.52-
Trophy Club Municipal Utility District No. 1 134 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 1
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 122-40001-000-000 Assessment - Emerg Svcs
197 10/09/2012 Property Taxes/Assessments (136.94) (136.94) GL
199 10/12/2012 Property Taxes/Assessments (331.85) (468.79) GL
206 10/18/2012 Property Taxes/Assessments (321.26) (790.05) GL
208 10/19/2012 Property Taxes/Assessments (435.24) (1,225.29) GL
214 10/22/2012 Property Taxes/Assessments (169.21) (1,394.50) GL
218 10/23/2012 Property Taxes/Assessments (420.36) (1,814.86) GL
220 10/24/2012 Property Taxes/Assessments (104.24) (1,919.10) GL
222 10/25/2012 Property Taxes/Assessments (1,075.63) (2,994.73) GL
225 10/26/2012 Property Taxes/Assessments (640.23) (3,634.96) GL
229 10/31/2012 Property Taxes/Assessments (36.10) (3,671.06) GL
_______________
Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (3,671.06) (3,671.06) **
(252,084.00) Budgeted (248,412.94) Remaining 1 % Used
Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent
194 10/01/2012 Property Taxes/Assessments (5.36) (5.36) GL
_______________
Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: (5.36) (5.36) **
(4,700.00) Budgeted (4,694.64) Remaining 0 % Used
Account: 122-40010-000-000 Property Taxes/MUD Fire
195 10/02/2012 Property Taxes/Assessments (331.60) (331.60) GL
196 10/08/2012 Property Taxes/Assessments (115.42) (447.02) GL
198 10/10/2012 Property Taxes/Assessments (179.37) (626.39) GL
200 10/15/2012 Property Taxes/Assessments (273.82) (900.21) GL
201 10/16/2012 Property Taxes/Assessments (1,292.95) (2,193.16) GL
202 10/17/2012 Property Taxes/Assessments (1,359.00) (3,552.16) GL
204 10/18/2012 Property Taxes/Assessments (1,210.49) (4,762.65) GL
207 10/19/2012 Property Taxes/Assessments (1,730.08) (6,492.73) GL
209 10/22/2012 Property Taxes/Assessments (10,629.48) (17,122.21) GL
216 10/23/2012 Property Taxes/Assessments (1,810.33) (18,932.54) GL
219 10/23/2012 Property Taxes/Assessments (546.55) (19,479.09) GL
221 10/25/2012 Property Taxes/Assessments (1,435.18) (20,914.27) GL
223 10/26/2012 Property Taxes/Assessments (1,135.86) (22,050.13) GL
226 10/29/2012 Property Taxes/Assessments (1,612.74) (23,662.87) GL
227 10/30/2012 Property Taxes/Assessments (809.72) (24,472.59) GL
228 10/31/2012 Property Taxes/Assessments (1,950.35) (26,422.94) GL
_______________
Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (26,422.94) (26,422.94) **
(1,050,349.00) Budgeted (1,023,926.06) Remaining 3 % Used
Trophy Club Municipal Utility District No. 1 135 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 2
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 122-40011-000-000 Property Taxes/Fire-Delinquent
193 10/01/2012 Property Taxes/Assessments (204.62) (204.62) GL
202 10/17/2012 Property Taxes/Assessments (822.51) (1,027.13) GL
209 10/22/2012 Property Taxes/Assessments (1,335.52) (2,362.65) GL
_______________
Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (2,362.65) (2,362.65) **
(5,800.00) Budgeted (3,437.35) Remaining 41 % Used
Account: 122-40015-000-000 Property Taxes/Assessments P&I
194 10/01/2012 Property Taxes/Assessments (1.08) (1.08) GL
_______________
Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: (1.08) (1.08) **
(750.00) Budgeted (748.92) Remaining 0 % Used
Account: 122-40020-000-000 Property Taxes/Fire P&I
193 10/01/2012 Property Taxes/Assessments (40.94) (40.94) GL
202 10/17/2012 Property Taxes/Assessments (272.04) (312.98) GL
209 10/22/2012 Property Taxes/Assessments (280.45) (593.43) GL
_______________
Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (593.43) (593.43) **
(4,500.00) Budgeted (3,906.57) Remaining 13 % Used
Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft
.00 .00
_______________
Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: .00 .00 **
(6,000.00) Budgeted (6,000.00) Remaining 0 % Used
Account: 122-43400-000-000 Fire Inspections
.00 .00
_______________
Account: 122-43400-000-000 Fire Inspections Totals: .00 .00 **
(500.00) Budgeted (500.00) Remaining 0 % Used
Account: 122-43415-000-000 Denton/Tarrant Cty Pledge-Fire
.00 .00
_______________
Account: 122-43415-000-000 Denton/Tarrant Cty Pledge-Fire Totals: .00 .00 **
(10,000.00) Budgeted (10,000.00) Remaining 0 % Used
Trophy Club Municipal Utility District No. 1 136 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 3
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 122-49900-000-000 Miscellaneous Income
.00 .00
_______________
Account: 122-49900-000-000 Miscellaneous Income Totals: .00 .00 **
(1,200.00) Budgeted (1,200.00) Remaining 0 % Used
Department Totals: ------------------------------------------------------------------------------------------------ (33,056.52) **
(1,335,883.00) Budgeted (1,302,826.48) Remaining 2 % Used
Trophy Club Municipal Utility District No. 1 137 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 4
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 122-50005-045-000 Salaries & Wages
232 10/01/2012 Reverse Sept P/R accrual (9,241.15) (9,241.15) GL
103 10/12/2012 Payroll 10/12/12 15,565.98 6,324.83 GL
105 10/26/2012 Payroll 10/26/12 16,544.57 22,869.40 GL
_______________
Account: 122-50005-045-000 Salaries & Wages Totals: 22,869.40 22,869.40 **
444,717.00 Budgeted 421,847.60 Remaining 5 % Used
Account: 122-50010-045-000 Overtime
105 10/26/2012 Payroll 10/26/12 2,552.34 2,552.34 GL
_______________
Account: 122-50010-045-000 Overtime Totals: 2,552.34 2,552.34 **
31,375.00 Budgeted 28,822.66 Remaining 8 % Used
Account: 122-50011-045-000 DPS Holiday Pay
.00 .00
_______________
Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 .00 **
13,083.00 Budgeted 13,083.00 Remaining 0 % Used
Account: 122-50016-045-000 Longevity
.00 .00
_______________
Account: 122-50016-045-000 Longevity Totals: .00 .00 **
4,266.00 Budgeted 4,266.00 Remaining 0 % Used
Account: 122-50017-045-000 Certification
103 10/12/2012 Payroll 10/12/12 575.00 575.00 GL
_______________
Account: 122-50017-045-000 Certification Totals: 575.00 575.00 **
4,896.00 Budgeted 4,321.00 Remaining 12 % Used
Account: 122-50020-045-000 Retirement
103 10/12/2012 Payroll 10/12/12 2,178.79 2,178.79 GL
105 10/26/2012 Payroll 10/26/12 2,508.38 4,687.17 GL
_______________
Account: 122-50020-045-000 Retirement Totals: 4,687.17 4,687.17 **
69,242.00 Budgeted 64,554.83 Remaining 7 % Used
Trophy Club Municipal Utility District No. 1 138 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 5
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 122-50026-045-000 Medical Insurance
103 10/12/2012 Payroll 10/12/12 1,668.26 1,668.26 GL
105 10/26/2012 Payroll 10/26/12 1,668.25 3,336.51 GL
_______________
Account: 122-50026-045-000 Medical Insurance Totals: 3,336.51 3,336.51 **
48,327.00 Budgeted 44,990.49 Remaining 7 % Used
Account: 122-50027-045-000 Dental Insurance
103 10/12/2012 Payroll 10/12/12 155.96 155.96 GL
105 10/26/2012 Payroll 10/26/12 155.97 311.93 GL
_______________
Account: 122-50027-045-000 Dental Insurance Totals: 311.93 311.93 **
3,635.00 Budgeted 3,323.07 Remaining 9 % Used
Account: 122-50028-045-000 Vision Insurance
103 10/12/2012 Payroll 10/12/12 32.05 32.05 GL
105 10/26/2012 Payroll 10/26/12 32.06 64.11 GL
_______________
Account: 122-50028-045-000 Vision Insurance Totals: 64.11 64.11 **
824.00 Budgeted 759.89 Remaining 8 % Used
Account: 122-50029-045-000 Life Insurance & Other
.00 .00
_______________
Account: 122-50029-045-000 Life Insurance & Other Totals: .00 .00 **
4,250.00 Budgeted 4,250.00 Remaining 0 % Used
Account: 122-50030-045-000 Social Security Taxes
103 10/12/2012 Payroll 10/12/12 902.50 902.50 GL
105 10/26/2012 Payroll 10/26/12 1,091.44 1,993.94 GL
_______________
Account: 122-50030-045-000 Social Security Taxes Totals: 1,993.94 1,993.94 **
30,897.00 Budgeted 28,903.06 Remaining 6 % Used
Account: 122-50035-045-000 Medicare Taxes
103 10/12/2012 Payroll 10/12/12 211.06 211.06 GL
105 10/26/2012 Payroll 10/26/12 255.30 466.36 GL
Trophy Club Municipal Utility District No. 1 139 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 6
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
_______________
Account: 122-50035-045-000 Medicare Taxes Totals: 466.36 466.36 **
7,226.00 Budgeted 6,759.64 Remaining 6 % Used
Account: 122-50040-045-000 Unemployment Taxes
103 10/12/2012 Payroll 10/12/12 4.63 4.63 GL
105 10/26/2012 Payroll 10/26/12 18.15 22.78 GL
_______________
Account: 122-50040-045-000 Unemployment Taxes Totals: 22.78 22.78 **
1,481.00 Budgeted 1,458.22 Remaining 2 % Used
Account: 122-50045-045-000 Workman's Compensation
145 10/31/2012 Oct A/P MUD W/C FY 2013 10,000.00 10,000.00 TML INTERGOVERNMENTAL RISK 31896 AP
_______________
Account: 122-50045-045-000 Workman's Compensation Totals: 10,000.00 10,000.00 **
10,000.00 Budgeted .00 Remaining 100 % Used
Account: 122-50060-045-000 Pre-employment Physicals/Test
.00 .00
_______________
Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 .00 **
675.00 Budgeted 675.00 Remaining 0 % Used
Account: 122-50075-045-000 Tuition Reimbursement
.00 .00
_______________
Account: 122-50075-045-000 Tuition Reimbursement Totals: .00 .00 **
1,500.00 Budgeted 1,500.00 Remaining 0 % Used
Account: 122-55080-045-000 Maintenance & Repairs
145 10/31/2012 Oct A/P Fire Extinguisher PM/Refill PO 292.00 292.00 KIMBROUGH FIRE EXTINQUISHER CO 31886 AP
_______________
Account: 122-55080-045-000 Maintenance & Repairs Totals: 292.00 292.00 **
9,562.00 Budgeted 9,270.00 Remaining 3 % Used
Account: 122-55090-045-000 Vehicle Maintenance
145 10/31/2012 Oct A/P Oct PCards 272.57 272.57 JPMORGAN CHASE BANK NA 31885 AP
Trophy Club Municipal Utility District No. 1 140 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 7
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
_______________
Account: 122-55090-045-000 Vehicle Maintenance Totals: 272.57 272.57 **
14,850.00 Budgeted 14,577.43 Remaining 2 % Used
Account: 122-55095-045-000 Equipment Maintenance
.00 .00
_______________
Account: 122-55095-045-000 Equipment Maintenance Totals: .00 .00 **
9,808.00 Budgeted 9,808.00 Remaining 0 % Used
Account: 122-55100-045-000 Building Maintenance
61 10/17/2012 Firefighters Assoc/Oct cable (120.00) (120.00) GL
145 10/31/2012 Oct A/P Oct PCards 157.83 37.83 JPMORGAN CHASE BANK NA 31885 AP
145 10/31/2012 Oct A/P Oct PCards 205.68 243.51 JPMORGAN CHASE BANK NA 31885 AP
_______________
Account: 122-55100-045-000 Building Maintenance Totals: 243.51 243.51 **
6,500.00 Budgeted 6,256.49 Remaining 4 % Used
Account: 122-55110-045-000 Maintenance-Radios
.00 .00
_______________
Account: 122-55110-045-000 Maintenance-Radios Totals: .00 .00 **
1,103.00 Budgeted 1,103.00 Remaining 0 % Used
Account: 122-55160-045-000 Professional Outside Services
.00 .00
_______________
Account: 122-55160-045-000 Professional Outside Services Totals: .00 .00 **
2,500.00 Budgeted 2,500.00 Remaining 0 % Used
Account: 122-60005-045-000 Telephone
181 10/31/2012 Oct A/P PCards Zieverink 7.85 7.85 BANK OF AMERICA 31902 AP
181 10/31/2012 Oct A/P PCards Zieverink 5.16 13.01 BANK OF AMERICA 31902 AP
_______________
Account: 122-60005-045-000 Telephone Totals: 13.01 13.01 **
106.00 Budgeted 92.99 Remaining 12 % Used
Account: 122-60010-045-000 Communications/Pagers/Mobiles
Trophy Club Municipal Utility District No. 1 141 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 8
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
103 10/12/2012 Payroll 10/12/12 76.50 76.50 GL
75 10/19/2012 Oct A/P Dispatch for Fire 1,314.50 1,391.00 Denton County 31825 AP
_______________
Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 1,391.00 1,391.00 **
2,500.00 Budgeted 1,109.00 Remaining 56 % Used
Account: 122-60020-045-000 Electricity/Gas
75 10/19/2012 Oct A/P Electricity 10/1-10/12 352.21 352.21 HUDSON ENERGY 31833 AP
145 10/31/2012 Oct A/P 10/1-10/17 Gas at Fire Station 30.43 382.64 ATMOS ENERGY 31875 AP
_______________
Account: 122-60020-045-000 Electricity/Gas Totals: 382.64 382.64 **
6,167.00 Budgeted 5,784.36 Remaining 6 % Used
Account: 122-60025-045-000 Water
.00 .00
_______________
Account: 122-60025-045-000 Water Totals: .00 .00 **
1,400.00 Budgeted 1,400.00 Remaining 0 % Used
Account: 122-60030-045-000 Rent And/Or Usage
.00 .00
_______________
Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 .00 **
308,000.00 Budgeted 308,000.00 Remaining 0 % Used
Account: 122-60035-045-000 Postage
.00 .00
_______________
Account: 122-60035-045-000 Postage Totals: .00 .00 **
100.00 Budgeted 100.00 Remaining 0 % Used
Account: 122-60055-045-000 Insurance
145 10/31/2012 Oct A/P Bond D Thomas 50.00 50.00 VICTOR O SCHINNERER & CO, INC 31901 AP
_______________
Account: 122-60055-045-000 Insurance Totals: 50.00 50.00 **
10,000.00 Budgeted 9,950.00 Remaining 1 % Used
Account: 122-60066-045-000 Publications/Books/Subscrips
Trophy Club Municipal Utility District No. 1 142 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 9
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
.00 .00
_______________
Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 .00 **
410.00 Budgeted 410.00 Remaining 0 % Used
Account: 122-60070-045-000 Dues & Memberships
52 10/16/2012 Tx Fire Comm/ACH Annual Cert renewal 1,445.00 1,445.00 Tx Comptroller of Public Accts 31815 AP
145 10/31/2012 Oct A/P 2012-13 membership dues PO 000 5,100.91 6,545.91 NORTH EAST FIRE DEPT ASSOC 31888 AP
145 10/31/2012 Oct A/P Annual dues PO 000010 275.00 6,820.91 STATE FIREMEN'S FIRE MARSHALS 31892 AP
_______________
Account: 122-60070-045-000 Dues & Memberships Totals: 6,820.91 6,820.91 **
7,500.00 Budgeted 679.09 Remaining 91 % Used
Account: 122-60075-045-000 Meetings
.00 .00
_______________
Account: 122-60075-045-000 Meetings Totals: .00 .00 **
75.00 Budgeted 75.00 Remaining 0 % Used
Account: 122-60080-045-000 Schools & Training
.00 .00
_______________
Account: 122-60080-045-000 Schools & Training Totals: .00 .00 **
5,000.00 Budgeted 5,000.00 Remaining 0 % Used
Account: 122-60096-045-000 Emergency Management
.00 .00
_______________
Account: 122-60096-045-000 Emergency Management Totals: .00 .00 **
1,000.00 Budgeted 1,000.00 Remaining 0 % Used
Account: 122-60100-045-000 Travel & per diem
.00 .00
_______________
Account: 122-60100-045-000 Travel & per diem Totals: .00 .00 **
4,800.00 Budgeted 4,800.00 Remaining 0 % Used
Account: 122-60110-045-000 Physicals/Testing
Trophy Club Municipal Utility District No. 1 143 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 10
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
.00 .00
_______________
Account: 122-60110-045-000 Physicals/Testing Totals: .00 .00 **
2,000.00 Budgeted 2,000.00 Remaining 0 % Used
Account: 122-60125-045-000 Advertising
145 10/31/2012 Oct A/P 2X6 Volunteer banner PO 00000 80.85 80.85 FASTSIGNS 31881 AP
145 10/31/2012 Oct A/P 2 small banners for FD PO 0000 41.50 122.35 FASTSIGNS 31881 AP
_______________
Account: 122-60125-045-000 Advertising Totals: 122.35 122.35 **
150.00 Budgeted 27.65 Remaining 82 % Used
Account: 122-60160-045-000 Programs & Special Projects
145 10/31/2012 Oct A/P 2 banners PO 000004 270.00 270.00 LEE LOGO 31887 AP
_______________
Account: 122-60160-045-000 Programs & Special Projects Totals: 270.00 270.00 **
4,200.00 Budgeted 3,930.00 Remaining 6 % Used
Account: 122-60180-045-000 Fire Inspection/Enforcement
.00 .00
_______________
Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: .00 .00 **
1,900.00 Budgeted 1,900.00 Remaining 0 % Used
Account: 122-60195-045-000 Flags & Repair
145 10/31/2012 Oct A/P Flags PO000008 149.75 149.75 SYMONDS FLAGS & POLES 31894 AP
_______________
Account: 122-60195-045-000 Flags & Repair Totals: 149.75 149.75 **
2,543.00 Budgeted 2,393.25 Remaining 6 % Used
Account: 122-60245-045-000 Miscellaneous Expense
75 10/19/2012 Oct A/P Plaques PO 447901 43.20 43.20 OFFICE DEPOT, INC 31845 AP
_______________
Account: 122-60245-045-000 Miscellaneous Expense Totals: 43.20 43.20 **
1,237.00 Budgeted 1,193.80 Remaining 3 % Used
Account: 122-65005-045-000 Fuel & Lube
Trophy Club Municipal Utility District No. 1 144 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 11
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
.00 .00
_______________
Account: 122-65005-045-000 Fuel & Lube Totals: .00 .00 **
10,000.00 Budgeted 10,000.00 Remaining 0 % Used
Account: 122-65010-045-000 Uniforms
.00 .00
_______________
Account: 122-65010-045-000 Uniforms Totals: .00 .00 **
4,357.00 Budgeted 4,357.00 Remaining 0 % Used
Account: 122-65015-045-000 Protective Clothing
.00 .00
_______________
Account: 122-65015-045-000 Protective Clothing Totals: .00 .00 **
7,600.00 Budgeted 7,600.00 Remaining 0 % Used
Account: 122-65030-045-000 Chemicals
.00 .00
_______________
Account: 122-65030-045-000 Chemicals Totals: .00 .00 **
1,000.00 Budgeted 1,000.00 Remaining 0 % Used
Account: 122-65035-045-000 Small Tools
.00 .00
_______________
Account: 122-65035-045-000 Small Tools Totals: .00 .00 **
5,000.00 Budgeted 5,000.00 Remaining 0 % Used
Account: 122-65085-045-000 Office Supplies
75 10/19/2012 Oct A/P Office Supplies 5.56 5.56 OFFICE DEPOT, INC 31845 AP
_______________
Account: 122-65085-045-000 Office Supplies Totals: 5.56 5.56 **
1,200.00 Budgeted 1,194.44 Remaining 0 % Used
Account: 122-65095-045-000 Maintenance Supplies
.00 .00
Trophy Club Municipal Utility District No. 1 145 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 12
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
_______________
Account: 122-65095-045-000 Maintenance Supplies Totals: .00 .00 **
2,785.00 Budgeted 2,785.00 Remaining 0 % Used
Account: 122-65105-045-000 Printing
.00 .00
_______________
Account: 122-65105-045-000 Printing Totals: .00 .00 **
106.00 Budgeted 106.00 Remaining 0 % Used
Account: 122-69006-045-000 Grant Match
.00 .00
_______________
Account: 122-69006-045-000 Grant Match Totals: .00 .00 **
3,000.00 Budgeted 3,000.00 Remaining 0 % Used
Account: 122-69008-045-000 Short Term Debt Payments
.00 .00
_______________
Account: 122-69008-045-000 Short Term Debt Payments Totals: .00 .00 **
72,932.00 Budgeted 72,932.00 Remaining 0 % Used
Account: 122-69050-045-000 Radios
.00 .00
_______________
Account: 122-69050-045-000 Radios Totals: .00 .00 **
2,500.00 Budgeted 2,500.00 Remaining 0 % Used
Account: 122-69195-045-000 GASB34/Reserve for Replacement
.00 .00
_______________
Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 .00 **
145,598.00 Budgeted 145,598.00 Remaining 0 % Used
Department 45 Totals: ------------------------------------------------------------------------------------------------ 56,936.04 **
1,335,883.00 Budgeted 1,278,946.96 Remaining 4 % Used
Trophy Club Municipal Utility District No. 1 146 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 13
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Fund 122 Totals: ------------------------------------------------------------------------------------------------------ 23,879.52
.00 Budgeted (23,879.52) Remaining 0 % Used
Trophy Club Municipal Utility District No. 1 147 of 193 November 20, 2012
Municipal Utility District No 1 - I & S
Interim Balance Sheet
Balance @
10/31/2012
ASSETS
ASSETS
CASH AND CASH IN BANK 6,120$
INVESTMENTS 136,900
ACCOUNTS RECEIVABLE - ADVALOREM TAXES 204,746
TOTAL ASSETS 347,766$
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS PAYABLE -$
DEFERRED REVENUE 204,746$
TOTAL LIABILITIES 204,746
FUND BALANCE
ASSIGNED FUND BALANCE 143,020
TOTAL LIABILITIES AND FUND BALANCE 347,766$
October 31, 2012
1/12 Months (8.33% of Fiscal Year)
Trophy Club Municipal Utility District No. 1 148 of 193 November 20, 2012
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 15
15:59 11/15/12 Budget Summary with Amendment
Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program:
Period Ending: 10/2012
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
533-40000-000-000 Property Taxes 196,940.00- 196,940.00- 4,954.26- 4,954.26- 2.516 191,985.74-
533-40002-000-000 Property Taxes/Delinquent 3,900.00- 3,900.00- 1,294.04- 1,294.04- 33.181 2,605.96-
533-40015-000-000 Property Taxes/P & I 5,017.00- 5,017.00- 335.70- 335.70- 6.691 4,681.30-
Subtotal: 205,857.00- 205,857.00- 6,584.00- 6,584.00- 3.198 199,273.00-
533-48005-000-000 Reserve Funds/PID Utility Fees 345,000.00- 345,000.00- 345,000.00-
Subtotal: 345,000.00- 345,000.00- 345,000.00-
533-49010-000-000 Interest Income 1,700.00- 1,700.00- 18.54- 18.54- 1.091 1,681.46-
533-49015-000-000 Lease/Rental Income 308,000.00- 308,000.00- 308,000.00-
Subtotal: 309,700.00- 309,700.00- 18.54- 18.54- .006 309,681.46-
Program number: 860,557.00- 860,557.00- 6,602.54- 6,602.54- .767 853,954.46-
Department number: Revenues 860,557.00- 860,557.00- 6,602.54- 6,602.54- .767 853,954.46-
Revenues Subtotal ----------- 860,557.00- 860,557.00- 6,602.54- 6,602.54- .767 853,954.46-
Trophy Club Municipal Utility District No. 1 149 of 193 November 20, 2012
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 16
15:59 11/15/12 Budget Summary with Amendment
Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program:
Period Ending: 10/2012
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
533-70005-051-000 Paying Agent Fee 4,000.00 4,000.00 4,000.00
533-70025-051-000 Bond Interest Expense 229,033.00 229,033.00 229,033.00
533-70035-051-000 Bond Principal Payment 605,000.00 605,000.00 605,000.00
Subtotal: 838,033.00 838,033.00 838,033.00
Program number: 838,033.00 838,033.00 838,033.00
Department number: Administration 838,033.00 838,033.00 838,033.00
Expenditures Subtotal ----------- 838,033.00 838,033.00 838,033.00
Fund number: 533 MUD 1 I&S CONSOLIDATED 22,524.00- 22,524.00- 6,602.54- 6,602.54- 29.313 15,921.46-
******* End of Report *********
Trophy Club Municipal Utility District No. 1 150 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 54
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 533-40000-000-000 Property Taxes
195 10/02/2012 Property Taxes/Assessments (62.18) (62.18) GL
196 10/08/2012 Property Taxes/Assessments (21.64) (83.82) GL
198 10/10/2012 Property Taxes/Assessments (33.63) (117.45) GL
200 10/15/2012 Property Taxes/Assessments (51.34) (168.79) GL
201 10/16/2012 Property Taxes/Assessments (242.42) (411.21) GL
202 10/17/2012 Property Taxes/Assessments (254.81) (666.02) GL
204 10/18/2012 Property Taxes/Assessments (226.97) (892.99) GL
207 10/19/2012 Property Taxes/Assessments (324.39) (1,217.38) GL
209 10/22/2012 Property Taxes/Assessments (1,993.02) (3,210.40) GL
216 10/23/2012 Property Taxes/Assessments (339.43) (3,549.83) GL
219 10/23/2012 Property Taxes/Assessments (102.47) (3,652.30) GL
221 10/25/2012 Property Taxes/Assessments (269.09) (3,921.39) GL
223 10/26/2012 Property Taxes/Assessments (212.98) (4,134.37) GL
226 10/29/2012 Property Taxes/Assessments (302.38) (4,436.75) GL
227 10/30/2012 Property Taxes/Assessments (151.82) (4,588.57) GL
228 10/31/2012 Property Taxes/Assessments (365.69) (4,954.26) GL
_______________
Account: 533-40000-000-000 Property Taxes Totals: (4,954.26) (4,954.26) **
(196,940.00) Budgeted (191,985.74) Remaining 3 % Used
Account: 533-40002-000-000 Property Taxes/Delinquent
193 10/01/2012 Property Taxes/Assessments (104.63) (104.63) GL
202 10/17/2012 Property Taxes/Assessments (506.56) (611.19) GL
209 10/22/2012 Property Taxes/Assessments (682.85) (1,294.04) GL
_______________
Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (1,294.04) (1,294.04) **
(3,900.00) Budgeted (2,605.96) Remaining 33 % Used
Account: 533-40015-000-000 Property Taxes/P & I
193 10/01/2012 Property Taxes/Assessments (20.92) (20.92) GL
202 10/17/2012 Property Taxes/Assessments (171.38) (192.30) GL
209 10/22/2012 Property Taxes/Assessments (143.40) (335.70) GL
_______________
Account: 533-40015-000-000 Property Taxes/P & I Totals: (335.70) (335.70) **
(5,017.00) Budgeted (4,681.30) Remaining 7 % Used
Account: 533-48005-000-000 Reserve Funds/PID Utility Fees
63 10/03/2012 Permits 10/3/12 (2,300.00) (2,300.00) GL
64 10/04/2012 Permits 10/4/12 (9,200.00) (11,500.00) GL
Trophy Club Municipal Utility District No. 1 151 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 55
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
65 10/11/2012 Permit 10/11/12 (2,300.00) (13,800.00) GL
66 10/12/2012 Permits 10/12/12 (2,300.00) (16,100.00) GL
87 10/17/2012 Permits 10/17/12 (9,200.00) (25,300.00) GL
205 10/18/2012 Correct Util Fees coding/Oct 10/1-10/17 coded to I&S 25,300.00 .00 GL
_______________
Account: 533-48005-000-000 Reserve Funds/PID Utility Fees Totals: .00 .00 **
(345,000.00) Budgeted (345,000.00) Remaining 0 % Used
Account: 533-49010-000-000 Interest Income
224 10/31/2012 Oct Bank interest (18.54) (18.54) GL
_______________
Account: 533-49010-000-000 Interest Income Totals: (18.54) (18.54) **
(1,700.00) Budgeted (1,681.46) Remaining 1 % Used
Account: 533-49015-000-000 Lease/Rental Income
.00 .00
_______________
Account: 533-49015-000-000 Lease/Rental Income Totals: .00 .00 **
(308,000.00) Budgeted (308,000.00) Remaining 0 % Used
Department Totals: ------------------------------------------------------------------------------------------------ (6,602.54) **
(860,557.00) Budgeted (853,954.46) Remaining 1 % Used
Trophy Club Municipal Utility District No. 1 152 of 193 November 20, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 56
16:00 11/15/12 Detailed Accounting Trial Balance
Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program:
Period Ending: 10/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 533-70005-051-000 Paying Agent Fee
.00 .00
_______________
Account: 533-70005-051-000 Paying Agent Fee Totals: .00 .00 **
4,000.00 Budgeted 4,000.00 Remaining 0 % Used
Account: 533-70025-051-000 Bond Interest Expense
.00 .00
_______________
Account: 533-70025-051-000 Bond Interest Expense Totals: .00 .00 **
229,033.00 Budgeted 229,033.00 Remaining 0 % Used
Account: 533-70035-051-000 Bond Principal Payment
.00 .00
_______________
Account: 533-70035-051-000 Bond Principal Payment Totals: .00 .00 **
605,000.00 Budgeted 605,000.00 Remaining 0 % Used
Department 51 Totals: ------------------------------------------------------------------------------------------------ .00 **
838,033.00 Budgeted 838,033.00 Remaining 0 % Used
Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (6,602.54)
(22,524.00) Budgeted (15,921.46) Remaining 29 % Used
Grand Totals: --------------------------------------------------------------------------------------------------------- (247,970.12) ****
(22,524.00) Budgeted 225,446.12 Remaining ##########
******* End of Report *********
Trophy Club Municipal Utility District No. 1 153 of 193 November 20, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:12012-273-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:11/7/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:11/20/2012
Title:Consider and take appropriate action to adopt amended Rate Order No. 2012-1120, and amend
Section 1.07 to increase the cost of a one inch meter to the actual cost. (McKnight)
Attachments:Rate Order Section 1.07 Meter & Tap Fees.pdf
Action ByDate Action ResultVer.
Title
Consider and take appropriate action to adopt amended Rate Order No. 2012-1120, and amend Section 1.07 to
increase the cost of a one inch meter to the actual cost. (McKnight)
Trophy Club Municipal Utility District No. 1 154 of 193 November 20, 2012
Trophy Club Municipal Utility District No. 1155 of 193November 20, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:22012-284-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:11/13/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:11/20/2012
Title:Consider and take appropriate action to determine the status of funding for Harmony Park. (McKnight)
Attachments:Harmony Park - letter from Town Manager.pdf
Action ByDate Action ResultVer.
Title
Consider and take appropriate action to determine the status of funding for Harmony Park. (McKnight)
Trophy Club Municipal Utility District No. 1 156 of 193 November 20, 2012
Town of Trophy Club
100 Municipal Drive
Trophy Club, Texas 76262
(682) 831-4600
Fax (817) 491-9312
November 13, 2012
Trophy Club MUD #1 Directors
Trophy Club MUD #1 Manager
SUBJECT: Harmony Park Operations and Maintenance Budget
MUD #1 Directors/Manager:
The purpose of this letter is to provide you with a detailed anticipated cost breakdown of
the operations and maintenance of Harmony Park for FY13. The current budget
anticipates O&M expenses of $42,500 in the following cost categories:
Water $13,500
*Property Maintenance $21,000
Electric $ 8,000
TOTAL $42,500
*Property Maintenance: includes all chemicals, minor facility repair, and overall park
upkeep
My intention is to provide the MUD Manager with all O&M related receipts associated
with Harmony Park on a reimbursable basis not to exceed $42,500 during the fiscal year.
Receipts will be attached to a monthly invoice for reimbursement. The Town will be
responsible for all O&M costs in excess of $42,500 and continue to provide operational
oversight of Harmony Park.
Trophy Club MUD #1 financial contribution to the operations and maintenance of
Harmony Park is very much appreciated.
Respectfully,
Mike Slye
Town Manager
Trophy Club
Trophy Club Municipal Utility District No. 1 157 of 193 November 20, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:12012-274-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:11/7/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:11/20/2012
Title:Consider and take appropriate action to approve Resolution No. 2012-1120B authorizing District
Participation in the Texas County and District Retirement System (TCDRS) effective January 1, 2013
and authorizing the District Manager to execute all related and necessary documents. (McKnight)
Attachments:2012 District GTL Authorization.pdf
2012 Acknowledgement of Condition Governing TCDRS Participation.pdf
Unfunded Liability Savings 112012.pdf
790 Trophy Club MUD Resolution 1120B w No UAAL Payment 11072012.pdf
790 Trophy Club MUD Resolution 1120B w 25% UAAL Payoff .pdf
790 Trophy Club MUD Resolution 1120B w 50% UAAL Payoff 11072012.pdf
790 Trophy Club MUD Resolution 1120B w 75% UAAL Payoff 11072012.pdf
790 Trophy Club MUD Resolution 1120B w 100% UAAL Payoff 11072012.pdf
Action ByDate Action ResultVer.
Title
Consider and take appropriate action to approve Resolution No. 2012-1120B authorizing District Participation in
the Texas County and District Retirement System (TCDRS) effective January 1, 2013 and authorizing the District
Manager to execute all related and necessary documents. (McKnight)
Trophy Club Municipal Utility District No. 1 158 of 193 November 20, 2012
AUTHORIZATION PROVIDING FOR PARTICIPATION
IN THE GROUP TERM LIFE PROGRAM
(Revised 2012)
TCDRS * PO Box 2034 Austin TX 78768 * 800-823-7782 or 512-328-8889 * Fax 512-328-8887 * www.tcdrs.org
Page 1 of 1
TCDRS Employer # _____
On the _____ day of ____________, 20___, the governing board of ________________________
(“the District”) was convened in open session. The District’s Governing Board has authorized
participation in the Group Term Life program administered by the Texas County & District Retirement
System (“TCDRS”). The District elected to participate in the Group Term Life Program for the purpose of
providing death benefits in the amounts and on the terms provided for in the TCDRS Act for:
(Select one box below to elect coverage)
Employees Only. (Provides benefits for employees who are current TCDRS members.)
OR
Employees and Retirees. (Provides benefits for employees who are current TCDRS members
and former employees who have retired under TCDRS.)
Participation in the Group Term Life program shall be effective on the first day of the month of
_____________ 20___, or such subsequent date as may be prescribed by the Board of Trustees of the
System.
Certification
I certify that the foregoing authorization concerning the District’s participation in the Group Term Life
program truly and accurately reflects the official action taken during a properly posted and noticed meeting
on the above date by our Governing Board and such action is recorded in the official minutes.
______________________________________
Presiding Board Officer
Dated: ______________
Trophy Club Municipal Utility District No. 1 159 of 193 November 20, 2012
ACKNOWLEDGMENT OF CONDITIONS
GOVERNING TCDRS PARTICIPATION
Revised 2012
TCDRS * PO Box 2034 Austin, TX 78768 * 800-823-7782 or (512) 328-8889 * Fax (512) 328-8887 * www.tcdrs.org
Page 1 of 2
General Conditions
The Texas County and District Retirement System (TCDRS) is a qualified retirement plan under
Section 401(a) of the Internal Revenue Code. The TCDRS Act (Subtitle F, Title 8, Texas
Government Code) is the basis for administration of the retirement system. In all cases, the
actual provisions of state and federal governing law take precedence over information
provided in any other form.
The assets of all TCDRS members and employer plans are pooled for investment purposes.
Neither an individual member nor the District directs the investment of those assets.
Information held by TCDRS that is identifiable with an individual member’s personal account,
benefit amounts or beneficiary designations is confidential under state law and may be disclosed to
the District’s governing board only if it is necessary for the local administration of the District’s
TCDRS plan.
Plan Funding and Employer Contributions
The TCDRS plan of each participating county or district is treated actuarially and
financially as a separate retirement plan. There is no pooling of costs or benefits.
Employer contribution rates are actuarially determined by TCDRS. An employer cannot
determine its own required rate, but may elect to contribute at an optional higher rate.
Employer contributions are held in trust by TCDRS and may not be returned to the District.
Employer assets can be used only to fund benefits for plan participants.
TCDRS is authorized to impose remedial measures on any plan determined to have a funding
deficiency if its governing board declines to take corrective action.
Monthly reports and employee/employer contributions must be received by TCDRS no later than
5 p.m. of the 15th day following the month for which they are submitted. Contributions or
reports received after the deadline are deemed late and incur a $500 penalty. Late
contributions also incur penalty interest at the annual rate of 12% for each day the
contributions are past due. Reports may be filed electronically and monthly contributions may
be submitted by ACH Debit to ensure their timely submission.
Employee Participation and Benefit Elections
TCDRS participation is mandatory for all eligible employees. All participating employees
must contribute the same percentage of salary as elected by the governing board.
The governing board of the District is responsible for establishing the initial employee deposit
level, benefit levels and retirement eligibility factors for the District’s retirement plan.
The Board may adopt future plan changes based on selected optional benefits and rates provided
by TCDRS and may request employer rates for other allowable benefit options.
Trophy Club Municipal Utility District No. 1 160 of 193 November 20, 2012
ACKNOWLEDGMENT OF CONDITIONS
GOVERNING TCDRS PARTICIPATION
Revised 2012
TCDRS * PO Box 2034 Austin, TX 78768 * 800-823-7782 or (512) 328-8889 * Fax (512) 328-8887 * www.tcdrs.org
Page 2 of 2
Actuarial Assumptions and Cost/Benefit Projections
Projections of employer costs and contribution rates are based on actuarial assumptions, the most
important being the assumed annual allocation of 9% interest to employer accounts, and assumed
levels of member withdrawals and payroll growth. Investment return and interest allocations
are assumed, but not guaranteed. Actual employer interest allocations or plan experience
that differ significantly from assumptions can result in significant rate variation, especially
in smaller plans. Actuarial assumptions are reviewed every four years and may be adjusted by
TCDRS, with the adjustments affecting employer rates.
Projections of benefit payments provided now or in the future are not guarantees of payments, but
estimates. These estimates assume the continued existence of the District, its ongoing employer
contributions and no decrease in the number of contributing employees. Termination of the
District or a significant decrease in the number of its depositing members can cause
funding problems for its TCDRS plan and prevent it from providing current or future
benefits at promised levels.
Board Members’ Acknowledgment
(All Board members should sign below. It is not necessary to include titles.)
We hereby acknowledge that we have been advised of the conditions governing the participation of the
____________________________________________________________ in the Texas County and
District Retirement System. Witness our hands officially on this 20th day of November 2012.
Attest (By Other Than Board Member):
________________________________________
Trophy Club Municipal Utility District No. 1 161 of 193 November 20, 2012
Annual Payroll as of June 2012 $838,740
Total Unfunded Liability-TCDRS $227,486
Potential Dollar Savings
Employer Contributions Over 20 Years
For one year Over 20 years Paying Unfunded Liability
Current TMRS contribution rate 13.82%$115,913.87 $2,318,277.36
Rate with Unfunded Liability 10.04%$84,209.50 $1,684,189.92 $0.00
Rate with 25% Funded Liability 9.41%$78,925.43 $1,578,508.68 $105,681.24
Rate with 50% Funded Liability 8.77%$73,557.50 $1,471,149.96 $213,039.96
Rate with 75% Funded Liability 8.14%$68,273.44 $1,365,468.72 $318,721.20
Rate with 100% Funded Liability 7.50%$62,905.50 $1,258,110.00 $426,079.92
If TCMUD pays $0 by 1/1/2013 then the rate to be paid will be 10.04% and the annual payment will be $84,209.50
If TCMUD pays $56,872 by 1/1/2012 then the rate to be paid will be 9.41% and the annual payment will be $78,925.43
If TCMUD pays $113,743 by 1/1/2013 then the rate to be paid will be 8.77% and the annual payment will be $73,557.50
If TCMUD pays $170,615 by 1/1/2013 then the rate to be paid will be 8.14% and the annual payment will be $68,273.44
POTENTIAL SAVINGS BY UPFRONT FUNDING OF UNFUNDED LIABILITY WITH TCDRS
Trophy Club Municipal Utility District No. 1 162 of 193 November 20, 2012
Trophy Club Municipal Utility District No. 1 163 of 193 November 20, 2012
Trophy Club Municipal Utility District No. 1 164 of 193 November 20, 2012
Trophy Club Municipal Utility District No. 1 165 of 193 November 20, 2012
Trophy Club Municipal Utility District No. 1 166 of 193 November 20, 2012
Trophy Club Municipal Utility District No. 1 167 of 193 November 20, 2012
Trophy Club Municipal Utility District No. 1 168 of 193 November 20, 2012
Trophy Club Municipal Utility District No. 1 169 of 193 November 20, 2012
Trophy Club Municipal Utility District No. 1 170 of 193 November 20, 2012
Trophy Club Municipal Utility District No. 1 171 of 193 November 20, 2012
Trophy Club Municipal Utility District No. 1 172 of 193 November 20, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:12012-275-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:11/7/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:11/20/2012
Title:Consider and take appropriate action to approve Resolution No. 2012-1120C committing reserve
funds for September 2013 bond call. (Thomas)
Attachments:Par Values Bonds as of 9-30-12.pdf
2012_1120C Resolution to Commit Funds.pdf
Action ByDate Action ResultVer.
Title
Consider and take appropriate action to approve Resolution No. 2012-1120C committing reserve funds for
September 2013 bond call. (Thomas)
Trophy Club Municipal Utility District No. 1 173 of 193 November 20, 2012
$2,265,000.00Date of IssuanceAmount of Issue (Par)Title of IssuePrincipal Balance @ 9/30/12First Callable DateFinal Pay DateProject/Reason July 2003 $1,200,000.00Trophy Club Municipal Utility District #2 Unlimited Tax Bonds, Series 2003$785,000.00 9/1/20139/1/2023FDIC Settlement and costs related to the issuance of the Bonds. June 2005 $3,134,997.85Trophy Club Municipal Utility District #2 Unlimited Tax Refunding Bonds, Series 2005$1,480,000.009/1/20139/1/2023Refund 2006‐2013 maturies of the District's Unlimited Tax Refunding Bonds, Series 1995, and costs related to the issuance of the Bonds. April 2010 $2,000,000.00Trophy Club Municipal Utility District #1 Unlimited Tax Bonds, Series 2010$1,935,000.00 9/1/20209/1/2031Trophy Club Fire Station and costs related to the issuance of the Bonds. March 2012$2,355,000.00Trophy Club Municipal Utility District #1 Unlimited Tax Refunding Bonds, Series 2012$2,355,000.00 9/1/20209/1/2023Refund MUD #2 Unlimited Tax Bonds, 2002 and costs related to the issuance of the Bonds. Total$6,555,000.00Par Values (Original Purchase) of Trophy Club MUD #1 General Obligation Bonds @ 9/30/127/30/12 RGonzalesTrophy Club Municipal Utility District No. 1174 of 193November 20, 2012
RESOLUTION NO. 2012-1120C
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 RESOLUTION COMMITTING $2,265,000 TO CALL UNLIMITED TAX REFUNDING BOND SERIES 2003 AND SERIES 2005 IN SEPTEMBER 2013
WHEREAS, the Trophy Club Municipal Utility District No. 1 Board of Directors desires to reduce
bond indebtedness as expediently as possible; and
WHEREAS, the District has previously adopted a policy to maintain fund reserves at levels
determined by the Board to satisfactorily meet District needs for future infrastructure replacement and
emergency operational needs; and
WHEREAS, the Board has determined the reserve fund balance exceeds replacement and
emergency needs and includes uncommitted funds available for any legal purpose of the District; and
WHEREAS, the District currently has par balances of $785,000.00 for Unlimited Tax Refunding
Bonds Series 2003, and $1,480,000.00 for Unlimited Tax Refunding Bonds Series 2005; and
WHEREAS, Unlimited Tax Refunding Bond Series 2003 and Unlimited Tax Refunding Bond
Series 2005 each has a call date of September 1, 2013.
NOW, THEREFORE, BE IT RESOLVED BY THE TROPHY CLUB MUNICIPAL
UTILITY DISTRICT NO. 1, TROPHY CLUB, TEXAS:
The District is committing $2,265,000.00 from its uncommitted fund reserve balance to call Series
2003 and Series 2005 Bond Issuances at the next available call date of September 1, 2013.
PASSED AND APPROVED by the Board of Directors of the Trophy Club Municipal Utility
District No. 1, Trophy Club, Texas on this the 20th day of November 20, 2012.
__________________________________
Nick Sanders, Board President
__________________________________ (SEAL)
Kevin R. Carr, Board Secretary/Treasurer
__________________________________
Laurie Slaght, District Secretary
Trophy Club Municipal Utility District No. 1 175 of 193 November 20, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:12012-278-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:11/9/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:11/20/2012
Title:Consider and take appropriate action regarding purchase of Google Earth and a large format printer.
(Armstrong)
Attachments:
Action ByDate Action ResultVer.
Title
Consider and take appropriate action regarding purchase of Google Earth and a large format printer. (Armstrong)
Trophy Club Municipal Utility District No. 1 176 of 193 November 20, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:12012-279-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:11/9/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:11/20/2012
Title:Consider and take appropriate action to appoint a committee to review proposed Personnel Policy
Handbook. (McKnight)
Attachments:
Action ByDate Action ResultVer.
Title
Consider and take appropriate action to appoint a committee to review proposed Personnel Policy Handbook.
(McKnight)
Trophy Club Municipal Utility District No. 1 177 of 193 November 20, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:12012-282-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:11/9/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:11/20/2012
Title:Consider and take appropriate action to award the bid for the purchase of trucks for the Wastewater
Treatment Plant. (Schlielig)
Attachments:WWTP Work Truck Summary 1112.pdf
Wastewater Vehicle Proposals 1112.pdf
Wastewater Vehicle Specs 1112.pdf
Action ByDate Action ResultVer.
Title
Consider and take appropriate action to award the bid for the purchase of trucks for the Wastewater Treatment
Plant. (Schlielig)
Trophy Club Municipal Utility District No. 1 178 of 193 November 20, 2012
BID SUMMARY
Vehicles Wastewater - November 2012
Dealer
Vehicle #1 Bid
Amount
Vehicle #2
Bid Amount
Vehicle #2A Bid
Amount TOTAL
Caldwell County Chevrolet $18,944.00 $22,544.00 $23,144.00 $42,088.00
Reliable Chevrolet $18,977.60 $25,131.78 $25,909.41 $44,887.01
Philpott Motors LTD No Bid No Bid No Bid N/A
1. All bidders were through State purchasing contract; bids are not actually required using the contract.
State contract as they have already advertised and bid on participant's behalf.
2. Vehicle specificationa are included in packet. Vehicle #1 is a Chevrolet 1500 Pickup Truck. Vehicle #2
is a Chevrolet 1500 Extended Cab Pickup Truck. Vehicle #2A is an alternate bid of the Chevrolet 1500
Extended Cab Pickup with an upgraded seating style (in stock).
3. Total budgeted amount for vehicles is $49,500.
4. Staff recommends purchasing Vehicle #1 and #2A from Caldwell County Chevrolet for a total
amount of $42,088.
Trophy Club Municipal Utility District No. 1 179 of 193 November 20, 2012
Trophy Club Municipal Utility District No. 1180 of 193November 20, 2012
Trophy Club Municipal Utility District No. 1181 of 193November 20, 2012
Trophy Club Municipal Utility District No. 1182 of 193November 20, 2012
Trophy Club Municipal Utility District No. 1183 of 193November 20, 2012
Trophy Club Municipal Utility District No. 1184 of 193November 20, 2012
Trophy Club Municipal Utility District No. 1185 of 193November 20, 2012
Trophy Club Municipal Utility District No. 1186 of 193November 20, 2012
Trophy Club Municipal Utility District No. 1187 of 193November 20, 2012
Trophy Club Municipal Utility District No. 1188 of 193November 20, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:12012-285-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:11/14/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:11/20/2012
Title:Consultation with the District’s Attorney 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 conflicts with the Open Meetings Act, pursuant to Section 551.071(2) of the Texas Open
Meetings Act:
- Matters related to a Certificate of Convenience and Necessity
Attachments:
Action ByDate Action ResultVer.
Title
Consultation with the District’s Attorney 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 conflicts with the
Open Meetings Act, pursuant to Section 551.071(2) of the Texas Open Meetings Act:
- Matters related to a Certificate of Convenience and Necessity
Trophy Club Municipal Utility District No. 1 189 of 193 November 20, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:12012-286-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:11/14/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:11/20/2012
Title:Consider and take appropriate action regarding item(s) discussed Closed Session.
Attachments:
Action ByDate Action ResultVer.
Title
Consider and take appropriate action regarding item(s) discussed Closed Session.
Trophy Club Municipal Utility District No. 1 190 of 193 November 20, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:12012-280-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:11/9/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:11/20/2012
Title:Recommendations for future agenda item(s):
Attachments:Future Agenda Items.pdf
Action ByDate Action ResultVer.
Title
Recommendations for future agenda item(s):
Trophy Club Municipal Utility District No. 1 191 of 193 November 20, 2012
RequestorStaffCode of EthicsStaffService PolicySanders Paying off bondsThomas Future water wellStaffWater ratesThomas Additional ground storageMoss $42,500 Grant to the Town for Harmony ParkFuture Agenda ItemsItemTrophy Club Municipal Utility District No. 1192 of 193November 20, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:12012-281-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:11/9/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:11/20/2012
Title:Set next meeting date: December 17, 2012 7:00 p.m.
Attachments:
Action ByDate Action ResultVer.
Title
Set next meeting date: December 17, 2012 7:00 p.m.
Trophy Club Municipal Utility District No. 1 193 of 193 November 20, 2012