HomeMy WebLinkAboutDecember 17, 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 Boardroom6:00 PMMonday, December 17, 2012
CALL TO ORDER AND ANNOUNCE A QUORUM
CONVENE INTO CLOSED SESSION
1.2012-294-M1 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.Issues related to District service Territory and CCN matters.
b.Purchase of property.
c.Interlocal Agreement with the Town of Trophy Club for Contractual Personnel Services
d.Interlocal Agreement with the Town of Trophy Club for Fire Service Employee
Contractual Services
RECONVENE INTO REGULAR SESSION
2.2012-295-M1 Consider and take appropriate action regarding Closed Session item(s).
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.
Trophy Club Municipal Utility District No. 1 1 of 143 December 17, 2012
December 17, 2012Trophy Club Municipal Utility
District No. 1
Meeting Agenda
3.2012-292-M1 Consider and take appropriate action to approve the Consent Agenda.
a.November 5, 2012 Special Meeting minutes
b.November 20, 2012 Regular Session Meeting Minutes
c.November check register
d.Declare surplus property and authorize District Manager to dispose.
November 5, 2012 Special Session minutes.pdf
November 20, 2012 Regular Session minutes.pdf
November 2012 Check Register.pdf
Property to declare surplus.pdf
Attachments:
REPORTS & UPDATES
4.2012-298-M1 Receive District Manager's Report (McKnight)
a.Water System Operation
b.Wastewater Treatment Plant
c.Finance update
d.Roundabout Relocation Project
e.Update on Trinity Well No. 1 repairs
f.Drought status and possible implementation of water restrictions
g.Update on Fort Worth impact fees
h.Update on Personnel Policy
Pumped vs. Billed November.pdf
WW-Monthly Log November 2012.pdf
Wastewater percentage removal.pdf
PID Connections 11-2012.pdf
Utility Billing Report Nov 2012.pdf
Fort Worth Impact Fees.pdf
Attachments:
5.2012-296-M1 Receive Fire Update (Thomas)
a.November activity
11-12 Activity Report.pdfAttachments:
6.2012-301-M1 Review of Proposed Timetable and Preliminary Debt Service Refunding
Calculations provided by Southwest Securities. (McKnight)
- $1,910,000 Unlimited Tax Refunding Bonds, Series 2013
Refunding Bonds attachment.pdf
Proposed Timetable.pdf
Attachments:
REGULAR SESSION
Trophy Club Municipal Utility District No. 1 2 of 143 December 17, 2012
December 17, 2012Trophy Club Municipal Utility
District No. 1
Meeting Agenda
7.2012-300-M1 Consider and take appropriate action to approve the November 2012 Financials.
(Gonzales)
November Financials combined for packet.pdf
Nov 2012 Variance.pdf
Attachments:
8.2012-309-M1 Consider and take appropriate action to appoint a committee to review the Public
Improvement District agreement and present the Board with recommended
changes. (McKnight)
9.2012-310-M1 Consider and take appropriate action to approve repairs to the skidloader in the
amount of $6,830.11. (Schlielig)
Landmark Quote.pdfAttachments:
10.2012-306-M1 Consider and take appropriate action to award bid for Short Term Certificate of
Obligation to bank. (McKnight)
BANK 3 YEAR CO 1212 RFPs.pdf
BANK 3 YEAR CO 1212.pdf
Attachments:
11.2012-308-M1 Consider and take appropriate action regarding the Interlocal Agreement with the
Town of Trophy Club for Contractual Personnel Services. (McKnight)
12.2012-311-M1 Consider and take appropriate action regarding the Interlocal Agreement with the
Town of Trophy Club for Fire Services Employee Contractual Services.
(McKnight)
13.2012-302-M1 Consider and take appropriate action to approve Resolution No. 2012-1217A
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)
TCDRS Resolution 2012-1217A.pdfAttachments:
14.2012-312-M1 Consider and take appropriate action to transition all or part of MUD 1 personnel
to MUD 1 supervision, payroll and benefits. (McKnight)
15.2012-299-M1 Set next meeting date: Regular Session - January 15, 2013
16.2012-297-M1 Recommendations for future agenda item(s):
Future Agenda Items.pdfAttachments:
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 3 of 143 December 17, 2012
December 17, 2012Trophy Club Municipal Utility
District No. 1
Meeting Agenda
CERTIFICATION)
THE STATE OF TEXAS)
COUNTY OF DENTON)
COUNTY OF TARRANT)
THIS CERTIFIES THAT ON AT DECEMBER 13, 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 MONDAY, DECEMBER 17, 2012 AT 6 P.M., 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 4 of 143 December 17, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:12012-294-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:12/6/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:12/17/2012
Title: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.Issues related to District service Territory and CCN matters.
b.Purchase of property.
c.Interlocal Agreement with the Town of Trophy Club for Contractual Personnel Services
d.Interlocal Agreement with the Town of Trophy Club for Fire Service Employee Contractual Services
Attachments:
Action ByDate Action ResultVer.
Title
Consultation with the District's Attorneyon a matter in which the duty of the Attorneyto 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.Issues related to District service Territory and CCN matters.
b.Purchase of property.
c.Interlocal Agreement with the Town of Trophy Club for Contractual Personnel Services
d.Interlocal Agreement with the Town of Trophy Club for Fire Service Employee Contractual Services
Trophy Club Municipal Utility District No. 1 5 of 143 December 17, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:12012-295-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:12/6/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:12/17/2012
Title:Consider and take appropriate action regarding Closed Session item(s).
Attachments:
Action ByDate Action ResultVer.
Title
Consider and take appropriate action regarding Closed Session item(s).
Trophy Club Municipal Utility District No. 1 6 of 143 December 17, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:12012-292-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:12/4/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:12/17/2012
Title:Consider and take appropriate action to approve the Consent Agenda.
a.November 5, 2012 Special Meeting minutes
b.November 20, 2012 Regular Session Meeting Minutes
c.November check register
d.Declare surplus property and authorize District Manager to dispose.
Attachments:November 5, 2012 Special Session minutes.pdf
November 20, 2012 Regular Session minutes.pdf
November 2012 Check Register.pdf
Property to declare surplus.pdf
Action ByDate Action ResultVer.
Title
Consider and take appropriate action to approve the Consent Agenda.
a.November 5, 2012 Special Meeting minutes
b.November 20, 2012 Regular Session Meeting Minutes
c.November check register
d.Declare surplus property and authorize District Manager to dispose.
Trophy Club Municipal Utility District No. 1 7 of 143 December 17, 2012
SPECIAL SESSION MINUTES FROM
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
BOARD OF DIRECTORS
100 MUNICIPAL DRIVE, TROPHY CLUB, TEXAS
November 5, 2012 at 10:30 A.M.
Svore Municipal Building Boardroom
The Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met
in Special Session on Monday, November 5, 2012 at 10:30 A.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
Bill Armstrong Director
Jim Moss Director
ABSENT:
Kevin Carr Secretary/Treasurer
STAFF PRESENT:
Jennifer McKnight District Manager
Pam Liston MUD Attorney
Laurie Slaght MUD Secretary
Renae Gonzales Finance Manager
Terri Sisk Human Resources Manager
Adrian Womack Utility Superintendent
Karl Schlielig Wastewater Superintendent
Danny Thomas Fire Chief
President Sanders announced the date of November 5, 2012, called the meeting to order and announced
a quorum present at 10:30 a.m.
1. Presentation of employee pension system by Kristina Acuna with Texas County and District
Retirement System (TCDRS).
Kristina Acuna, a representative with Texas County and District Retirement System presented the Board
and staff with an overview of the Texas County and District Retirement System and answered questions
regarding the same.
2. Presentation of health benefit package from Dean Casey with Dean Casey and Associates.
Dean Casey with Dean Casey and Associates presented the Board with health insurance benefit options
and answered questions regarding the same.
3. Consider and take appropriate action to approve Resolution No. 2012-1105 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.
Trophy Club Municipal Utility District No. 1
November 5, 2012, Special Session Minutes
1 of 3Trophy Club Municipal Utility District No. 1 8 of 143 December 17, 2012
District Manager McKnight explained the Town and MUD payroll will be separating on January 1, 2013.
President Sanders requested clarification from Attorney Liston regarding the eligibility of the MUD
employee’s participation in the Texas Municipal Retirement System (TMRS). Attorney Liston stated that
only Municipal (Town or City) employees are allowed to participate in the TMRS pension system and
further stated that a Municipal Utility District would typically participate with TCDRS.
Motion is made by Vice President Jim Thomas and seconded by Director Jim Moss , to approve
Resolution No. 2012-1105, 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.
Discussion ensued. President Sanders would like to look at an employer match contribution. Rates have
stabilized. President Sanders would like to fund a portion of the unfunded balance.
Motion is withdrawn by first and second.
Motion is made by Vice President Thomas and seconded by Director Moss to refer this item to
November 20, 2012 regular meeting and have the District Manager prepare resolutions with 25%,
50%, 75% and 100% of the unfunded balance.
Motion carried unanimously
4. Consider and take appropriate action regarding District employee Health Benefit package
effective January 1, 2013 and authorizing the District Manager to execute all necessary and related
documents.
Motion made by Director Moss and seconded by Director Armstrong, to approve the District
employee Health Benefit package as presented effective January 1, 2013 and authorizing the
District Manager to execute all necessary and related documents.
Motion carried unanimously
5. Consider and take appropriate action regarding payments of Texas unemployment taxes or
becoming a reimbursable employer. (Sisk)
Human Resources Manager Terri Sisk recommends that the MUD pay quarterly taxes for Texas
unemployment and review the possibility of becoming reimbursable for years.
Motion is made by Vice President Thomas and seconded by Director Moss, to pay Texas
Unemployment taxes on a quarterly basis.
Motion carried unanimously
6. Consider and take appropriate action to approve emergency repair to Trinity Well No. 4, by
Millican Well Service, LLC. at an estimated cost of $60,384.00. (McKnight)
Utility Superintendent Womack clarified this is item is related to Well #1 not Well #4. He stated that the
electric motor shorted out in the well Millican will repair it quickly so it can be put back online.
Motion is made by Director Moss and seconded by Vice President Thomas, to approve emergency
well repair by Millican Well Service, LLC. at a cost of $60,384.00 for Trinity Well No. 1.
Motion carried unanimously
Trophy Club Municipal Utility District No. 1
November 5, 2012, Special Session Minutes
2 of 3Trophy Club Municipal Utility District No. 1 9 of 143 December 17, 2012
7. Consider and take appropriate action to appoint an Audit Committee for FY 2012 annual audit.
(McKnight)
Motion is made by Director Moss and seconded by Director Armstrong, to appoint Director
Armstrong , and Director Carr to the Audit Committee for the FY 2012 annual audit and appointing
Vice President Thomas as an alternate to the committee if one of the other members cannot
participate.
Motion carried unanimously
CONVENE INTO CLOSED SESSION 12:26 p.m.
8. 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
RECONVENE INTO REGULAR SESSION 1:37 pm
9. Consider and take appropriate action regarding closed session items.
No action is taken.
ADJOURN
Meeting adjourned at 1:39 p.m.
___________________________
Nick Sanders,
MUD 1 President
____________________________ (SEAL)
Kevin R. Carr,
MUD 1 Secretary/Treasurer
____________________________
Laurie Slaght,
MUD District Secretary
Trophy Club Municipal Utility District No. 1
November 5, 2012, Special Session Minutes
3 of 3Trophy Club Municipal Utility District No. 1 10 of 143 December 17, 2012
REGULAR MEETING MINUTES FROM
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
BOARD OF DIRECTORS
100 MUNICIPAL DRIVE, TROPHY CLUB, TEXAS
November 20, 2012 at 7 P.M.
Svore Municipal Building Boardroom
The Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met
in Regular Session on Tuesday, November 20, 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
Bob West MUD Attorney
Laurie Slaght MUD Secretary
Terri Sisk Human Resources Manager
Adrian Womack Utility Superintendent
Karl Schlielig Wastewater Superintendent
Danny Thomas Fire Chief
GUEST PRESENT:
Bob Wallace The Wallace Group
Kevin Glovier The Wallace Group
Scott Wetzel The Wallace Group
President Sanders announced the date of November 20, 2012, called the meeting to order and
announced a quorum present at 7:00 p.m.
Citizen Presentations
-No citizens addressed the Board.
Consent Agenda
1. 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.
Motion is made by Vice President Thomas, seconded by, Secretary Treasurer Carr to approve the
Consent agenda.
Motion carried unanimously
Trophy Club Municipal Utility District No. 1
November 20, 2012 Regular Session Minutes
1 of 6Trophy Club Municipal Utility District No. 1 11 of 143 December 17, 2012
REGULAR SESSION
2. Presentation from the Wallace Group regarding the Wastewater Plant with findings and
recommendations for improvements.
Mr. Kevin Glovier with the Wallace Group presented the initial study that has been completed at the
wastewater plant. Mr. Scott Wetzel presented recommendations with the corrections and improvements
based on the initial review of plant infrastructure and operations. Mr. Wetzel stated that the plant has an
exceptional staff and they are doing a great job. He stated that with the plant reaching operational
capacity, improvements are needed. Bob Wallace followed up with the Board and answered questions
regarding financing and a timetable for improvements.
3. Consider and take appropriate action to approve proposal from the Wallace Group for
Preliminary Engineering Report for Wastewater Treatment Plant improvements. (McKnight)
Motion is made by Secretary/Treasurer Carr and seconded by Vice President Thomas,
to approve the proposal from the Wallace group to prepare a Preliminary Engineering Report for
Wastewater Treatment Plant improvements at a cost of $65,000 and authorizing the District
Manager to expend the remaining funds of $74,500 as needed not to exceed a total of $139,500.
Motion carried unanimously
4. 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)
District Manager McKnight stated that the Local Government Code requires that in order to use bond
funds for any work done prior to the issue of the bonds, you must first agree to reimburse yourself with
those bonds. McKnight explained that the Board does not have to reimburse themselves for the work
done prior to the bond issuance or even proceed with the issuance of the bond itself. This resolution will
allow the option to do so if the need arises.
Vice President Thomas would like to consider including the purchase of land into the bond.
Motion is made by Secretary/Treasurer Carr and seconded by Vice President Thomas,
to approve Resolution No. 2012-1120A expressing intent to reimburse costs of wastewater
improvement project(s) with bond proceeds.
Motion carried unanimously
Item # 12 is called up with no objections
12. Consider and take appropriate action to determine the status of funding for Harmony Park.
(McKnight)
Vice President Thomas stated that the Town Manager had presented the Board with a letter stating the
funds from the District would be committed to Harmony Park and itemized receipts would be submitted for
reimbursement to the Town. President Sanders reminds the Board that funds are not currently in the
budget and an amendment is needed to take funds from District reserves.
Motion is made by Vice President Thomas and seconded by Director Moss, to authorize the
District Manager to reimburse the Town up to $42,500 for expenditures related to Harmony Park.
Motion carried unanimously
Trophy Club Municipal Utility District No. 1
November 20, 2012 Regular Session Minutes
2 of 6Trophy Club Municipal Utility District No. 1 12 of 143 December 17, 2012
REPORTS & UPDATES
5.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
District Manager McKnight stated that repairs were completed on Trinity Well No. 1. and it is pumping
great. The W astewater plant has met the parameters for the month of October.
CPS Civil, the contractor for the roundabout project is ready to replace the sewer line and the District is
working with the Town to set up a timeline for repairs. The project is expected to take 2 weeks to repair.
The Board would like to have the District Manager put in writing to the Town Manager that the District
does not want the Town to release retainage until the sewer lines have been replaced.
District Manager McKnight has given the authorization to the Wallace Group to proceed with the survey of
the land near the wastewater treatment plant.
McKnight reviewed the Committed Funds spreadsheet that was attached in the packet to the Board.
6. Receive Finance Update (Gonzales)
a. PID Connections
b. Utility Billing
The Board reviewed the handout they received with the monthly totals. President Sanders would like to
see a full year in the reports so comparisons can me made. Secretary/Treasurer Carr inquired about the
fees owed to the District by the Town for the PID connections, District Manager McKnight stated that
Finance is working with the Town to resolve this.
7. Receive Fire Update (Thomas)
a. October activity
Chief Thomas reviewed the number of calls for the month of October and gave the Board and overview
the activities held for Fire Prevention month.
8. Receive Town Council Update
Nothing to report.
REGULAR SESSION
9. Consider and take appropriate action regarding official Town Council liaison representation at
District meetings. (Carr)
Secretary/Treasurer Carr stated that he doesn’t believe the MUD needs to have a representative from the
Town Council attend District meetings as the meetings are now online.
Motion is made by Secretary/Treasurer Carr, seconded by Director Moss, to discontinue having a
Town Council Liaison at Trophy Club Municipal Utility District No. 1 meetings.
Motion carried unanimously
Trophy Club Municipal Utility District No. 1
November 20, 2012 Regular Session Minutes
3 of 6Trophy Club Municipal Utility District No. 1 13 of 143 December 17, 2012
10. Consider and take appropriate action to approve the October 2012 financials (Gonzales)
Motion is made by Secretary/Treasurer Carr seconded by Vice President Thomas, to approve the
October 2012 financials.
Motion carried unanimously
11. 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)
Motion is made by Vice President Thomas seconded by Director Moss, to adopt amended Rate
Order No. 2012-1120, amending Section 1.07 to increase the cost of a one inch meter to the actual
cost.
Motion carried unanimously
13. 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)
Motion is made by President Sanders and seconded by Secretary/Treasurer Carr, to approve
Resolution No. 2012-1120B authorizing District participation in the Texas County and District
Retirement System (TCDRS) with the funding of 50% of the unfunded liability effective January 1,
2013, and authorizing the District Manager to execute all related and necessary documents
Motion carried unanimously
14. Consider and take appropriate action to approve Resolution No. 2012-1120C committing
reserve funds for September 2013 bond call. (Thomas)
Item dies for lack of a motion.
15. Consider and take appropriate action regarding purchase of Google Earth and a large format
printer. (Armstrong)
Director Armstrong would like the District to purchase Google Earth Professional which would allow the
District to print very detailed, high resolution prints. Director Armstrong stated that with the prints, you can
add layers, including infrastructure and also calculate measurements. District Manager McKnight feels
this would be a beneficial product for the District.
The Board directs the District Manager to proceed with purchasing the number of licenses that
she needs to implement the program.
16. Consider and take appropriate action to appoint a committee to review proposed Personnel
Policy Handbook. (McKnight)
Motion is made by Secretary/Treasurer Carr and seconded by Director Moss, to appoint President
Sanders and Director Armstrong, with an alternate of Vice President Thomas, to review proposed
personnel Policy Handbook.
Motion carried unanimously
Trophy Club Municipal Utility District No. 1
November 20, 2012 Regular Session Minutes
4 of 6Trophy Club Municipal Utility District No. 1 14 of 143 December 17, 2012
17. Consider and take appropriate action to award the bid for the purchase of trucks for the
Wastewater Treatment Plant. (Schlielig)
Motion is made by Vice President Thomas and seconded by Director Moss, to award the bid for
the purchase of two trucks for the Wastewater Treatment Plant to the low bidder, Caldwell County
Cheverolet.
Motion carried unanimously
CONVENE INTO CLOSED SESSION at 9:21 p.m.
18. 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 10:18
19. Consider and take appropriate action regarding item(s) discussed Closed Session.
No action was taken
20. Recommendations for future agenda item(s):
Recognition of website committee Volunteers.
A completed spreadsheet with exact amounts and dates of due to and due from the Town.
21. Set next meeting date: December 17, 2012 7:00 p.m.
ADJOURN
Meeting adjourned at 10:19 p.m.
Trophy Club Municipal Utility District No. 1
November 20, 2012 Regular Session Minutes
5 of 6Trophy Club Municipal Utility District No. 1 15 of 143 December 17, 2012
___________________________
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
November 20, 2012 Regular Session Minutes
6 of 6Trophy Club Municipal Utility District No. 1 16 of 143 December 17, 2012
Trophy Club Municipal Utility District No. 117 of 143December 17, 2012
Trophy Club Municipal Utility District No. 118 of 143December 17, 2012
Trophy Club Municipal Utility District No. 1
Property to declare surplus – Cargo trailer that is 10’ long, 5’ wide and also 5’
tall.
Trophy Club Municipal Utility District No. 1 19 of 143 December 17, 2012
Sec. 49.226. SALE OR EXCHANGE OF REAL OR PERSONAL
PROPERTY. (a) Any personal property valued at more than $300
or any land or interest in land owned by the district which is
found by the board to be surplus and is not needed by the
district may be sold under order of the board either by public
or private sale, or the land, interest in land, or personal
property may be exchanged for other land, interest in land, or
personal property needed by the district. Except as provided in
Subsection (b), land, interest in land, or personal property
must be exchanged for like fair market value, which value may be
determined by the district. In connection with the sale of
surplus land, the board, at its discretion, may impose
restrictions on the development and use of the land.
(b) Any property dedicated to or acquired by the district
without expending district funds may be abandoned or released to
the original grantor, the grantor's heirs, assigns, executors,
or successors upon terms and conditions deemed necessary or
advantageous to the district and without receiving compensation
for such abandonment or release. District property may also be
abandoned, released, exchanged, or transferred to another
district, municipality, county, countywide agency, or authority
upon terms and conditions deemed necessary or advantageous to
the district. Narrow strips of property resulting from boundary
or surveying conflicts or similar causes, or from insubstantial
encroachments by abutting property owners, or property of larger
configuration that has been subject to encroachments by abutting
property owners for more than 25 years may be abandoned,
released, exchanged, or transferred to such abutting owners upon
terms and conditions deemed necessary or advantageous to the
district. Chapter 272, Local Government Code, does not apply to
this section.
(c) Before a public sale of real property, the district
shall give notice of the intent to sell by publishing notice
once a week for two consecutive weeks in one or more newspapers
with general circulation in the district.
Trophy Club Municipal Utility District No. 1 20 of 143 December 17, 2012
(d) If the district has outstanding bonds secured by a
pledge of tax revenues, the proceeds of the sale of property
originally acquired with bond proceeds shall be:
(1) applied to retire outstanding bonds of the
district; or
(2) held and treated as surplus bond proceeds and
spent only as provided by the rules of the commission relating
to surplus bond proceeds.
(e) If the district does not have any outstanding bonds,
the proceeds derived from the sale of real or personal property
may be used for any lawful purpose.
Added by Acts 1995, 74th Leg., ch. 715, Sec. 2, eff. Sept. 1,
1995. Amended by Acts 1997, 75th Leg., ch. 1070, Sec. 14, eff.
Sept. 1, 1997; Acts 2001, 77th Leg., ch. 1423, Sec. 14, eff.
June 17, 2001; Acts 2003, 78th Leg., ch. 248, Sec. 16, eff.
June 18, 2003.
Trophy Club Municipal Utility District No. 1 21 of 143 December 17, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:12012-298-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:12/6/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:12/17/2012
Title:Receive District Manager's Report (McKnight)
a.Water System Operation
b.Wastewater Treatment Plant
c.Finance update
d.Roundabout Relocation Project
e.Update on Trinity Well No. 1 repairs
f.Drought status and possible implementation of water restrictions
g.Update on Fort Worth impact fees
h.Update on Personnel Policy
Attachments:Pumped vs. Billed November.pdf
WW-Monthly Log November 2012.pdf
Wastewater percentage removal.pdf
PID Connections 11-2012.pdf
Utility Billing Report Nov 2012.pdf
Fort Worth Impact Fees.pdf
Action ByDate Action ResultVer.
Title
Receive District Manager's Report (McKnight)
a.Water System Operation
b.Wastewater Treatment Plant
c.Finance update
d.Roundabout Relocation Project
e.Update on Trinity Well No. 1 repairs
f.Drought status and possible implementation of water restrictions
g.Update on Fort Worth impact fees
h.Update on Personnel Policy
Trophy Club Municipal Utility District No. 1 22 of 143 December 17, 2012
Oct.Nov.Dec.Jan Feb.March April May June July August Sept.Total for 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 75,251
October November December January February March April May June July August
79,297 48,609 36,966 32,915 26,974 25,771 31,755 46,747 70,315 69,134 92,539
84,849 51,836 38,869 32,850 24,742 25,111 32,240 47,364 75,755 68,715 82,007
90,400 55,063 40,772 32,785 22,510 24,451 32,726 47,980 81,195 68,296 71,476
95,952 58,290 42,675 32,721 20,278 23,791 33,211 48,597 86,636 67,878
350,497 213,799 159,281 131,271 94,504 99,122 129,932 190,688 313,900 274,022 246,022
Oct.Nov.Dec.Jan Feb.March April May June July August Sept.Total for year
2006 74,585 55,405 42,852 52,100 33,247 39,250 64,455 73,048 93,187 118,353 127,450 76,301 850,233
2007 72,460 49,249 34,203 28,257 31,492 43,900 41,770 37,340 41,215 43,136 75,480 72,087 570,589
2008 64,370 50,090 35,320 36,610 34,630 34,750 42,900 63,116 78,399 114,256 98,670 72,551 725,662
2009 65,110 48,570 36,411 36,587 36,385 44,120 48,881 38,250 66,450 116,823 94,525 81,500 713,612
2010 40,803 41,600 32,700 31,400 30,145 27,240 43,400 62,646 113,049 94,950 131,650 76,159 725,742
2011 70,502 50,993 44,220 33,789 36,053 54,775 71,306 63,500 116,350 152,002 169,621 117,190 980,301
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 77,758 .
FYI- Physical Year
0
20,000
40,000
60,000
80,000
100,000
120,000
140,000
160,000
180,000 Million Gallons Months
Water Billed
2010
2011
2012
2013
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 23 of 143 December 17, 2012
Analytical Precision Control Chart
Page 11
Max mg/L 0.97 Aver mg/L 0.438
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.398
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
5.10
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 24 of 143 December 17, 2012
Analytical Precision Control Chart
Page 11
Max mg/L 34 Aver mg/L 6.0
Max mg/L 23.0 Aver mg/L 16.7
Max mg/L 68.0 Aver mg/L 13.5
Nitrate - Nitrogen
E. Coli
Total Suspended Solids (TSS)
1.5
10.4 10.4
34.0
0.6 2.6 5.1
2.3 2.0 2.6 2.0 2.0 2.1
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 11.4
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 1.3 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 25 of 143 December 17, 2012
Analytical Precision Control Chart
Page 11
p
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 7.8
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 26 of 143 December 17, 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 7.1
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 27 of 143 December 17, 2012
Date Influent Effluent Influent Effluent Influent Effluent
7-Dec 38.5 0.428 99%234 5.8 98%212 2.0 99%
8-Dec 36.1 0.257 99%213 2.73 99%216 2.0 99%
13-Dec 42.9 0.152 100%296 9.33 97%284 2.0 99%
14-Dec 46.75 0.294 99%190 3.24 98%232 2.0 99%
19-Dec 47.25 0.328 99%172 3.7 98%248 2.0 99%
20-Dec 39.7 0.280 99%184 2.0 99%204 2.0 99%
29-Dec 43.9 0.425 99%263 6.55 98%226 2.14 99%
30-Dec 38.9 1.02 97%211 7.53 96%186 2.67 99%
Report 99%98%99%
November 2012 Results
% Removal % Removal% RemovalAmmonia-N CBOD5 TSS
0.398 5.11 2.10
Ammonia-N CBOD5 TSS
Trophy Club Municipal Utility District No. 1 28 of 143 December 17, 2012
PID CONNECTION FEE SUMMARY
(Nov 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,261,400
Begin 928 1,127,000
1 - -$ - -$ - -$ - -$ - - 928 1,127,000
2 - -$ - -$ - -$ - -$ - - 928 1,127,000
3 - -$ - -$ - -$ - -$ - - 928 1,127,000
4 - -$ - -$ - -$ - -$ - - 928 1,127,000
5 - -$ - -$ - -$ - -$ - - 928 1,127,000
6 - -$ 1 2,300$ - -$ - -$ 1 2,300 929 1,124,700
7 - -$ 4 9,200$ - -$ - -$ 4 9,200 933 1,115,500
8 - -$ 3 6,900$ - -$ - -$ 3 6,900 936 1,108,600
9 - -$ - -$ - -$ - -$ - - 936 1,108,600
10 - -$ - -$ - -$ - -$ - - 936 1,108,600
11 - -$ - -$ - -$ - -$ - - 936 1,108,600
12 - -$ - -$ - -$ - -$ - - 936 1,108,600
13 - -$ - -$ - -$ - -$ - - 936 1,108,600
14 - -$ 1 2,300$ - -$ - -$ 1 2,300 937 1,106,300
15 - -$ 1 2,300$ - -$ - -$ 1 2,300 938 1,104,000
16 - -$ - -$ - -$ - -$ - - 938 1,104,000
17 - -$ - -$ - -$ - -$ - - 938 1,104,000
18 - -$ - -$ - -$ - -$ - - 938 1,104,000
19 - -$ - -$ - -$ - -$ - - 938 1,104,000
20 - -$ - -$ - -$ - -$ - - 938 1,104,000
21 - -$ - -$ - -$ - -$ - - 938 1,104,000
22 - -$ - -$ - -$ - -$ - - 938 1,104,000
23 - -$ - -$ - -$ - -$ - - 938 1,104,000
24 - -$ - -$ - -$ - -$ - - 938 1,104,000
25 - -$ -$ - -$ - -$ - - 938 1,104,000
26 - -$ - -$ - -$ - -$ - - 938 1,104,000
27 - -$ - -$ - -$ - -$ - - 938 1,104,000
28 - -$ 1 2,300$ - -$ - -$ 1 2,300 939 1,101,700
29 - -$ - -$ - -$ - -$ - - 939 1,101,700
30 - -$ 2 4,600$ - -$ - -$ 2 4,600 941 1,097,100
31 - -$ - -$ - -$ - -$ - - 941 1,097,100
TOTAL - -$ 13 29,900$ - -$ - -$ 13 29,900 -
Approximate Total # of homes in PID at build out 1,418
Total Amount to be collected at $2,300 each $3,261,400
Total number of homes collected to date 941
Total amount collected to date 2,164,300$
Total number of homes remaining to be collected 477
Total amount remaining to be collected 1,097,100$
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 29 of 143 December 17, 2012
October November December January February March April May June July August September
ebills 276 280
Bills Mailed 3603 3596
Bank Draft 539 535
Credit Card Draft 261 280
Online Payments 717 571
Late Notices 389 547
Disconnects 32 32
October November December January February March April May June July August September
ebills 0 3 4 4 14 150 195 214 223 239 237 282
bills mailed 3542 3539 3579 3630 3547 3561 3558 3549 3565 3582 3578 3608
Bank Draft 489 486 489 492 506 499 529 528 535 527 528 537
Credit Card Draft 0 0 1 4 87 151 172 196 210 212 246 248
Online Payments 0 0 3 10 651 565 577 591 650 715 766 742
Late Notices 533 424 472 483 360 338 293 313 369 458 378 406
Disconnects 53 43 47 69 27 16 26 21 20 17 25 39
Trophy Club MUD #1
Utility Billing Report
Fiscal Year 2012
Fiscal Year 2013
Trophy Club Municipal Utility District No. 1 30 of 143 December 17, 2012
Trophy Club Municipal Utility District No. 131 of 143December 17, 2012
EXHIBIT "2"
SCHEDULE 2
WATER AND WASTEWATER IMPACT FEE COLLECTION SCHEDULE
EFFECTIVE JUNE 6, 2009
I WATER WASTEWATER TOTAL METER SIZE EQUIVALENCY
FACTOR IMPACT FEE* IMPACT FEE* IMPACT FEE*
5/8" x 518" and 1.00 $867 $185 $1,052 5/8" X 3/4" l
3/4" X 3/4" 1.50 $1,300 I $278 $1,578 !
1" 2.50 $2,167 $464 $2,631
1-1/2" 5.00 $4,335 $927 $5,262
2" 8.00 $6,936 I $1,484 $8,420
3" i 21.75 I $18,857 $4,034 $22,891 ., -I ..
4" 37.50
I
$32,512 I $6,956
•
$39,468
f--·--I I 6" I 80.00 $69,360 t $14,840 $84,200
8" I 140.00 $121,380 $25,970 $147,350
10" 210.00 $182,070 $38,955 $221,025
*Water and Wastewater Impact Fees are calculated at 50% of the total maximum assessable
amount
Trophy Club Municipal Utility District No. 1 32 of 143 December 17, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:12012-296-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:12/6/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:12/17/2012
Title:Receive Fire Update (Thomas)
a.November activity
Attachments:11-12 Activity Report.pdf
Action ByDate Action ResultVer.
Title
Receive Fire Update (Thomas)
a.November activity
Trophy Club Municipal Utility District No. 1 33 of 143 December 17, 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 2013Calls by TypeFire3 12.0 4Service31 2226.5 53Good Intent3 54.0 8False Alarm4 86.0 12EMS39 3034.5 69Total Calls80 66000000000014.6146Mutual AidGiven5 55.0 10Received1 32.0 4Hospital TransportsTCFD21 2020.5 41Mutual Aid1 11.0 2Air0 00.0 0Trophy Club Fire DepartmentMonthly Activity ReportFY 2013 MTDPage 1Response Time (Calls In Town)% At or Under 6 Minutes 79.2 71.775.5Average Time 05:13 05:46OtherContinuing Education Hours 123.5 100.5112.0 224Public Education Events 13 17.0 14Service calls include inspections, lock‐outs, water problems, smoke or odor removal, public service and assistance, and public education.Fire3%Service36%Good Intent6%False Alarm8%EMS47%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. 134 of 143December 17, 2012
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
FY 2013 80 66
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 1
FY 2012 4762302841034
FY 2011 1461124647545
FY 2010 433480432242
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
FY 2013 31 22
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 5
Trophy Club Fire Department
4 Year Comparison of Calls
Total Number of Calls
Fire Calls
Service Calls
Good Intent Calls
Page 2
FY 2012 3 1 4373523678
FY 2011 2 4 2 1 10 1 4 7 9363
FY 2010 5 2 4 1 10 2 2 3 6334
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
FY 2013 4 8
FY 2012 5 5 52446510948
FY 2011 3 2 0 9 13 3 7 9 6 6 4 10
FY 2010 4 4 10 882456646
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
FY 2013 39 30
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 69 FY 2013 146
FY 2012 53 FY 2012 124
FY 2011 54 FY 2011 115
FY 2010 44 FY 2010 118
FY 2013 77
FY 2012 71
FY 2011 61
YTD Number of Calls vs Prior Year Same Period
EMS Calls
Fire & Related Calls
Total Calls
False Alarms
EMS Calls
Roanoke (8 calls) Southlake (1 calls) Haslet (1 call)
6
1
0
2
0
1
YTD Mutual Aid Fire/EMS Calls
EMS
Fire
Trophy Club Municipal Utility District No. 1 35 of 143 December 17, 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 2013District 1# of calls21 2322.0 44avg. response time04:52 05:2605:09District 2# of calls43 2031.5 63avg. response time05:10 05:0505:09District 4 (PID)# of calls6118.5 17avg. response time06:22 07:1406:55District 5 (TCP)# of calls111.0 4avg. response time07:2809:1003:44Trophy Club Fire DepartmentCalls by DistrictYTD FY 2013Page 3avg. response time07:2809:1003:44District 6 (BNHS)# of calls465.0 10avg. response time05:16 06:0705:47Outside (Mutual Aid)# of calls555.0 10avg. response time10:53 04:5407:5330%42%11%3%7%7%% Calls by District FY 13 YTDDistrict 1District 2District 4 (PID)District 5 (TCP)District 6 (BNHS)Outside (Mutual Aid)80%10%10%% Mutual Aid Calls by DepartmentRoanoke (8 calls)Southlake (1 calls)Haslet (1 call)Trophy Club Municipal Utility District No. 136 of 143December 17, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:12012-301-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:12/6/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:12/17/2012
Title:Review of Proposed Timetable and Preliminary Debt Service Refunding Calculations provided by
Southwest Securities. (McKnight)
- $1,910,000 Unlimited Tax Refunding Bonds, Series 2013
Attachments:Refunding Bonds attachment.pdf
Proposed Timetable.pdf
Action ByDate Action ResultVer.
Title
Review of Proposed Timetable and Preliminary Debt Service Refunding Calculations provided by Southwest
Securities. (McKnight)
- $1,910,000 Unlimited Tax Refunding Bonds, Series 2013
Trophy Club Municipal Utility District No. 1 37 of 143 December 17, 2012
Nov 29, 2012 9:59 am Prepared by Southwest Securities, Inc. (DB) (Finance 7.003 Trophy Club MUD ...:TCMUD_1-2013REF,2013REF) Page 2
SAVINGS
$1,910,000* (par-to-par requirement)
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
Unlimited Tax Refunding Bonds, Series 2013
Refunded Bonds: Series 2003 & 2005
Delivered 6/15/2013 for Current Refunding of Series 2005
Current Market Scale: S&P AA- & Bank Qualified
Preliminary Numbers: As of November 29, 2012
Present Value
Prior Refunding to 06/15/2013
Date Debt Service Debt Service Savings @ 1.3883219%
09/30/2013 38,820.00 35,370.83 3,449.17 3,439.11
09/30/2014 237,640.00 218,625.00 19,015.00 18,798.07
09/30/2015 236,300.00 220,225.00 16,075.00 15,678.47
09/30/2016 234,760.00 216,725.00 18,035.00 17,327.78
09/30/2017 237,960.00 218,225.00 19,735.00 18,682.68
09/30/2018 235,760.00 219,625.00 16,135.00 15,064.76
09/30/2019 238,185.00 220,000.00 18,185.00 16,729.57
09/30/2020 235,197.50 219,300.00 15,897.50 14,422.23
09/30/2021 237,010.00 218,450.00 18,560.00 16,593.41
09/30/2022 238,350.00 217,450.00 20,900.00 18,417.30
09/30/2023 234,280.00 216,300.00 17,980.00 15,620.15
2,404,262.50 2,220,295.83 183,966.67 170,773.53
Savings Summary
PV of savings from cash flow 170,773.53
Plus: Refunding funds on hand 3,801.35
Net PV Savings 174,574.88
Note: *Preliminary, subject to change.
Trophy Club Municipal Utility District No. 1 38 of 143 December 17, 2012
Nov 29, 2012 9:59 am Prepared by Southwest Securities, Inc. (DB) (Finance 7.003 Trophy Club MUD ...:TCMUD_1-2013REF,2013REF) Page 3
SUMMARY OF REFUNDING RESULTS
$1,910,000* (par-to-par requirement)
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
Unlimited Tax Refunding Bonds, Series 2013
Refunded Bonds: Series 2003 & 2005
Delivered 6/15/2013 for Current Refunding of Series 2005
Current Market Scale: S&P AA- & Bank Qualified
Preliminary Numbers: As of November 29, 2012
Dated Date 06/15/2013
Delivery Date 06/15/2013
Arbitrage yield 1.388322%
Escrow yield
Bond Par Amount 1,910,000.00
True Interest Cost 1.517297%
Net Interest Cost 1.594462%
Average Coupon 2.784615%
Average Life 5.834
Par amount of refunded bonds 1,910,000.00
Average coupon of refunded bonds 4.092853%
Average life of refunded bonds 6.036
PV of prior debt to 06/15/2013 @ 1.388322%2,227,719.88
Net PV Savings 174,574.88
Percentage savings of refunded bonds 9.140046%
Percentage savings of refunding bonds 9.140046%
Note: *Preliminary, subject to change.
Trophy Club Municipal Utility District No. 1 39 of 143 December 17, 2012
Nov 29, 2012 9:59 am Prepared by Southwest Securities, Inc. (DB) (Finance 7.003 Trophy Club MUD ...:TCMUD_1-2013REF,2013REF) Page 4
BOND PRICING
$1,910,000* (par-to-par requirement)
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
Unlimited Tax Refunding Bonds, Series 2013
Refunded Bonds: Series 2003 & 2005
Delivered 6/15/2013 for Current Refunding of Series 2005
Current Market Scale: S&P AA- & Bank Qualified
Preliminary Numbers: As of November 29, 2012
Maturity Premium
Bond Component Date Amount Rate Yield Price (-Discount)
Serial Bond:
09/01/2013 25,000 2.000% 0.550% 100.305 76.25
09/01/2014 170,000 2.000% 0.650% 101.625 2,762.50
09/01/2015 175,000 2.000% 0.770% 102.691 4,709.25
09/01/2016 175,000 2.000% 0.870% 103.570 6,247.50
09/01/2017 180,000 2.000% 0.990% 104.155 7,479.00
09/01/2018 185,000 2.500% 1.120% 106.965 12,885.25
09/01/2019 190,000 3.000% 1.320% 109.985 18,971.50
09/01/2020 195,000 3.000% 1.360% 111.227 21,892.65
09/01/2021 200,000 3.000% 1.520% 111.382 22,764.00
09/01/2022 205,000 3.000% 1.610% 111.853 24,298.65
09/01/2023 210,000 3.000% 1.730% 111.838 24,859.80
1,910,000 146,946.35
Dated Date 06/15/2013
Delivery Date 06/15/2013
First Coupon 09/01/2013
Par Amount 1,910,000.00
Premium 146,946.35
Production 2,056,946.35 107.693526%
Underwriter's Discount (14,325.00) (0.750000%)
Purchase Price 2,042,621.35 106.943526%
Accrued Interest
Net Proceeds 2,042,621.35
Note: *Preliminary, subject to change.
Trophy Club Municipal Utility District No. 1 40 of 143 December 17, 2012
Nov 29, 2012 9:59 am Prepared by Southwest Securities, Inc. (DB) (Finance 7.003 Trophy Club MUD ...:TCMUD_1-2013REF,2013REF) Page 9
BOND DEBT SERVICE
$1,910,000* (par-to-par requirement)
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
Unlimited Tax Refunding Bonds, Series 2013
Refunded Bonds: Series 2003 & 2005
Delivered 6/15/2013 for Current Refunding of Series 2005
Current Market Scale: S&P AA- & Bank Qualified
Preliminary Numbers: As of November 29, 2012
Period
Ending Principal Coupon Interest Debt Service
09/30/2013 25,000 2.000% 10,370.83 35,370.83
09/30/2014 170,000 2.000% 48,625.00 218,625.00
09/30/2015 175,000 2.000% 45,225.00 220,225.00
09/30/2016 175,000 2.000% 41,725.00 216,725.00
09/30/2017 180,000 2.000% 38,225.00 218,225.00
09/30/2018 185,000 2.500% 34,625.00 219,625.00
09/30/2019 190,000 3.000% 30,000.00 220,000.00
09/30/2020 195,000 3.000% 24,300.00 219,300.00
09/30/2021 200,000 3.000% 18,450.00 218,450.00
09/30/2022 205,000 3.000% 12,450.00 217,450.00
09/30/2023 210,000 3.000% 6,300.00 216,300.00
1,910,000 310,295.83 2,220,295.83
Note: *Preliminary, subject to change.
Trophy Club Municipal Utility District No. 1 41 of 143 December 17, 2012
Nov 29, 2012 9:59 am Prepared by Southwest Securities, Inc. (DB)(Finance 7.003 Trophy Club MUD ...:TCMUD_1-2013REF,2013REF) Page 10
SUMMARY OF BONDS REFUNDED
$1,910,000* (par-to-par requirement)
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
Unlimited Tax Refunding Bonds, Series 2013
Refunded Bonds: Series 2003 & 2005
Delivered 6/15/2013 for Current Refunding of Series 2005
Current Market Scale: S&P AA- & Bank Qualified
Preliminary Numbers: As of November 29, 2012
Maturity Interest Par Call Call
Bond Date Rate Amount Date Price
UL Tax Bonds, Series 2003, 2003:
TERM_15 09/01/2014 3.900% 60,000.00 09/01/2013 100.000
09/01/2015 3.900% 60,000.00 09/01/2013 100.000
TERM_17 09/01/2016 4.000% 65,000.00 09/01/2013 100.000
09/01/2017 4.000% 70,000.00 09/01/2013 100.000
TERM_20 09/01/2018 4.250% 70,000.00 09/01/2013 100.000
09/01/2019 4.250% 75,000.00 09/01/2013 100.000
09/01/2020 4.250% 75,000.00 09/01/2013 100.000
TERM_23 09/01/2021 4.000% 80,000.00 09/01/2013 100.000
09/01/2022 4.000% 85,000.00 09/01/2013 100.000
09/01/2023 4.000% 85,000.00 09/01/2013 100.000
725,000.00
UL Tax Ref Bonds, Series 2005, 2005REF:
SERIAL 09/01/2014 4.000% 100,000.00 09/01/2013 100.000
09/01/2015 4.000% 105,000.00 09/01/2013 100.000
09/01/2016 4.000% 105,000.00 09/01/2013 100.000
09/01/2017 4.000% 110,000.00 09/01/2013 100.000
09/01/2018 4.000% 115,000.00 09/01/2013 100.000
TERM_20 09/01/2019 4.000% 120,000.00 09/01/2013 100.000
09/01/2020 4.000% 125,000.00 09/01/2013 100.000
TERM_23 09/01/2021 4.200% 130,000.00 09/01/2013 100.000
09/01/2022 4.200% 135,000.00 09/01/2013 100.000
09/01/2023 4.200% 140,000.00 09/01/2013 100.000
1,185,000.00
1,910,000.00
Note: *Preliminary, subject to change.
Trophy Club Municipal Utility District No. 1 42 of 143 December 17, 2012
Nov 29, 2012 9:59 am Prepared by Southwest Securities, Inc. (DB)(Finance 7.003 Trophy Club MUD ...:TCMUD_1-2013REF,2013REF) Page 11
PRIOR BOND DEBT SERVICE
$1,910,000* (par-to-par requirement)
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
Unlimited Tax Refunding Bonds, Series 2013
Refunded Bonds: Series 2003 & 2005
Delivered 6/15/2013 for Current Refunding of Series 2005
Current Market Scale: S&P AA- & Bank Qualified
Preliminary Numbers: As of November 29, 2012
Period
Ending Principal Coupon Interest Debt Service
09/30/2013 38,820.00 38,820.00
09/30/2014 160,000 ** %77,640.00 237,640.00
09/30/2015 165,000 ** %71,300.00 236,300.00
09/30/2016 170,000 4.000% 64,760.00 234,760.00
09/30/2017 180,000 4.000% 57,960.00 237,960.00
09/30/2018 185,000 ** %50,760.00 235,760.00
09/30/2019 195,000 ** %43,185.00 238,185.00
09/30/2020 200,000 ** %35,197.50 235,197.50
09/30/2021 210,000 ** %27,010.00 237,010.00
09/30/2022 220,000 ** %18,350.00 238,350.00
09/30/2023 225,000 ** %9,280.00 234,280.00
1,910,000 494,262.50 2,404,262.50
Note: *Preliminary, subject to change.
Trophy Club Municipal Utility District No. 1 43 of 143 December 17, 2012
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO.1
$1,910,000*
UNLIMITED TAX REFUNDING BONDS DRAFT
SERIES 2012
Proposed Timetable
As of December 5, 2012
Date Action Required
12-05-12 (W) Southwest Securities (SWS) submits timetable and preliminary refunding calculations
to District officials and Bond Counsel.
03-25-13 (M) Southwest Securities (SWS) submits Official Statement Request for Information (RFI)
to District officials.
04-08-13 (M) SWS receives completed RFI and related documents from the District
04-16-13 (T) Regular meeting of the Board of Directors to adopt a Parameters Sale Order
authorizing the issuance of Unlimited Tax Refunding Bonds, Series 2013 (the
“Bonds”) and naming a Delegated Pricing Agent to verify and execute the sale
documents (7:00 pm)
04-16-13 (T) SWS submits initial draft of Preliminary Official Statement (POS) to all parties for
review and comments
04-23-13 (T) SWS receives comments on POS from all parties
04-25-13 (Th) SWS submits POS and other financing documents to rating agencies and insurance
provider(s)
Only got S&P rating last time
(MAC shows current UL ratings S&P - AA- / Moody’s - Aa3
05-01-13 (W) Arrange rating conference calls with S&P and Moody’s(?)
(times yet to be determined)
05-13-13 (M) Post POS to the SWS Internet Website and distribute to investment community
05-16-13 (Th) Receive underlying bond rating and insurance bid (decide on insurer)
05-20-13 (M) • Analyze market conditions, price & offer Bonds to prospective buyers
• Underwriter to order CUSIP numbers for the Bonds
05-21-13 (T) Delegated Pricing Agent verifies sale parameters and executes sale documents.
SWS prepares and delivers financing packets to District for 7:00 pm meeting.
05-29-13 (W) Print and distribute Final Official Statement (OS) and post Final OS to SWS website
06-11-13 (T) SWS notifies all parties of closing/delivery instructions
06-20-13 (Th) Payment for and delivery of the Bonds
07-30-13 (T) Notices of Redemption sent to Bondholders (at least 30 days prior to Redemption
Date) (Latest date for Notices to be sent 08-01-13)
09-01-13 (Sun) Redemption of the currently callable 2005 Unlimited Tax Refunding Bonds
Note: Bold entries indicate dates/actions that require the District’s participation.
______________
* Preliminary, subject to change. Trophy Club Municipal Utility District No. 1 44 of 143 December 17, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:12012-300-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:12/6/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:12/17/2012
Title:Consider and take appropriate action to approve the November 2012 Financials. (Gonzales)
Attachments:November Financials combined for packet.pdf
Nov 2012 Variance.pdf
Action ByDate Action ResultVer.
Title
Consider and take appropriate action to approve the November 2012 Financials. (Gonzales)
Trophy Club Municipal Utility District No. 1 45 of 143 December 17, 2012
Municipal Utility District No 1
Fire Department O & M
Interim Balance Sheet
Balance @
11/30/2012
ASSETS
ASSETS
CASH IN BANK -$
INVESTMENTS 398,398
ACCOUNTS RECEIVABLE - ADVALOREM TAXES 992,814
ACCOUNTS RECEIVABLE - PID EMER SERVICES 233,352
OTHER RECEIVABLES 26,733
TOTAL ASSETS 1,651,297$
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE 1,226,166$
ACCOUNTS PAYABLE 89,234
TOTAL LIABILITIES 1,315,400$
FUND BALANCE
UNASSIGNED FUND BALANCE 335,897
TOTAL LIABILITIES AND FUND BALANCE 1,651,297$
November 30, 2012
2/12 Months (16.66% of Fiscal Year)
Trophy Club Municipal Utility District No. 1 46 of 143 December 17, 2012
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 1
13:23 12/13/12 Budget Summary with Amendment
Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program:
Period Ending: 11/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- 13,397.74- 17,068.80- 6.771 235,015.20-
122-40003-000-000 Emer Svcs Assessmen/Delinquent 4,700.00- 4,700.00- 5.36- .114 4,694.64-
122-40010-000-000 Property Taxes/MUD Fire 1,050,349.00- 1,050,349.00- 56,225.03- 82,647.97- 7.869 967,701.03-
122-40011-000-000 Property Taxes/Fire-Delinquent 5,800.00- 5,800.00- 1,233.21- 3,595.86- 61.998 2,204.14-
122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- 1.08- .144 748.92-
122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 849.27- 1,442.70- 32.060 3,057.30-
Subtotal: 1,318,183.00- 1,318,183.00- 71,705.25- 104,761.77- 7.947 1,213,421.23-
122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 400.00- 400.00- 6.667 5,600.00-
Subtotal: 6,000.00- 6,000.00- 400.00- 400.00- 6.667 5,600.00-
122-43400-000-000 Fire Inspections 500.00- 500.00- 75.00- 75.00- 15.000 425.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- 75.00- 75.00- .714 10,425.00-
122-49900-000-000 Miscellaneous Income 1,200.00- 1,200.00- 525.00- 525.00- 43.750 675.00-
Subtotal: 1,200.00- 1,200.00- 525.00- 525.00- 43.750 675.00-
Program number: 1,335,883.00- 1,335,883.00- 72,705.25- 105,761.77- 7.917 1,230,121.23-
Department number: Fire Revenues 1,335,883.00- 1,335,883.00- 72,705.25- 105,761.77- 7.917 1,230,121.23-
Revenues Subtotal ----------- 1,335,883.00- 1,335,883.00- 72,705.25- 105,761.77- 7.917 1,230,121.23-
Trophy Club Municipal Utility District No. 1 47 of 143 December 17, 2012
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 2
13:23 12/13/12 Budget Summary with Amendment
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 11/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 38,431.76 61,301.16 13.784 383,415.84
122-50010-045-000 Overtime 31,375.00 31,375.00 5,357.95 7,910.29 25.212 23,464.71
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 1,150.00 23.489 3,746.00
122-50020-045-000 Retirement 69,242.00 69,242.00 6,342.82 11,029.99 15.930 58,212.01
122-50026-045-000 Medical Insurance 48,327.00 48,327.00 3,336.41 6,672.92 13.808 41,654.08
122-50027-045-000 Dental Insurance 3,635.00 3,635.00 311.96 623.89 17.163 3,011.11
122-50028-045-000 Vision Insurance 824.00 824.00 64.11 128.22 15.561 695.78
122-50029-045-000 Life Insurance & Other 4,250.00 4,250.00 585.14 585.14 13.768 3,664.86
122-50030-045-000 Social Security Taxes 30,897.00 30,897.00 2,716.37 4,710.31 15.245 26,186.69
122-50035-045-000 Medicare Taxes 7,226.00 7,226.00 635.24 1,101.60 15.245 6,124.40
122-50040-045-000 Unemployment Taxes 1,481.00 1,481.00 15.64 38.42 2.594 1,442.58
122-50045-045-000 Workman's Compensation 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 58,372.40 105,251.94 15.561 571,142.06
122-55080-045-000 Maintenance & Repairs 9,562.00 9,562.00 162.26 454.26 4.751 9,107.74
122-55090-045-000 Vehicle Maintenance 14,850.00 14,850.00 723.42- 450.85- -3.036 15,300.85
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 117.42 360.93 5.553 6,139.07
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 443.74- 364.34 .822 43,958.66
122-60005-045-000 Telephone 106.00 106.00 13.01 12.274 92.99
122-60010-045-000 Communications/Pagers/Mobiles 2,500.00 2,500.00 216.88 1,607.88 64.315 892.12
122-60020-045-000 Electricity/Gas 6,167.00 6,167.00 475.97 858.61 13.923 5,308.39
122-60025-045-000 Water 1,400.00 1,400.00 294.78 294.78 21.056 1,105.22
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 27.25 27.25 27.250 72.75
122-60055-045-000 Insurance 10,000.00 10,000.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 185.00 7,005.91 93.412 494.09
122-60075-045-000 Meetings 75.00 75.00 75.00
122-60080-045-000 Schools & Training 5,000.00 5,000.00 530.00 530.00 10.600 4,470.00
122-60096-045-000 Emergency Management 1,000.00 1,000.00 1,000.00 1,000.00 100.000
122-60100-045-000 Travel & per diem 4,800.00 4,800.00 574.59 574.59 11.971 4,225.41
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 81.567 27.65
122-60160-045-000 Programs & Special Projects 4,200.00 4,200.00 1,928.94 2,198.94 52.356 2,001.06
Trophy Club Municipal Utility District No. 1 48 of 143 December 17, 2012
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 3
13:23 12/13/12 Budget Summary with Amendment
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 11/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 153.73 153.73 8.091 1,746.27
122-60195-045-000 Flags & Repair 2,543.00 2,543.00 149.75 5.889 2,393.25
122-60245-045-000 Miscellaneous Expense 1,237.00 1,237.00 43.20 3.492 1,193.80
Subtotal: 359,088.00 359,088.00 5,387.14 14,630.00 4.074 344,458.00
122-65005-045-000 Fuel & Lube 10,000.00 10,000.00 1,882.02 1,882.02 18.820 8,117.98
122-65010-045-000 Uniforms 4,357.00 4,357.00 283.25 283.25 6.501 4,073.75
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 15.15 20.71 1.726 1,179.29
122-65095-045-000 Maintenance Supplies 2,785.00 2,785.00 206.62 206.62 7.419 2,578.38
122-65105-045-000 Printing 106.00 106.00 106.00
Subtotal: 32,048.00 32,048.00 2,387.04 2,392.60 7.466 29,655.40
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 65,702.84 122,638.88 9.180 1,213,244.12
Department number: Fire 1,335,883.00 1,335,883.00 65,702.84 122,638.88 9.180 1,213,244.12
Expenditures Subtotal ----------- 1,335,883.00 1,335,883.00 65,702.84 122,638.88 9.180 1,213,244.12
Fund number: 122 Trophy Club MUD Fire Dept. 7,002.41- 16,877.11 16,877.11-
Trophy Club Municipal Utility District No. 1 49 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 1
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program:
Period Ending: 11/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
435 11/01/2012 Property Taxes/Assessments (3,671.06) (1,732.43) (5,403.49) GL
397 11/02/2012 Property Taxes/Assessments (437.30) (5,840.79) GL
399 11/05/2012 Property Taxes/Assessments (488.55) (6,329.34) GL
434 11/06/2012 Property Taxes/Assessments (749.85) (7,079.19) GL
402 11/08/2012 Property Taxes/Assessments (23.22) (7,102.41) GL
404 11/09/2012 Property Taxes/Assessments (1,765.22) (8,867.63) GL
407 11/13/2012 Property Taxes/Assessments (122.10) (8,989.73) GL
410 11/14/2012 Property Taxes/Assessments (1,000.78) (9,990.51) GL
412 11/15/2012 Property Taxes/Assessments (540.90) (10,531.41) GL
414 11/16/2012 Property Taxes/Assessments (435.66) (10,967.07) GL
416 11/19/2012 Property Taxes/Assessments (439.16) (11,406.23) GL
418 11/20/2012 Property Taxes/Assessments (389.31) (11,795.54) GL
420 11/21/2012 Property Taxes/Assessments (618.14) (12,413.68) GL
429 11/26/2012 Property Taxes/Assessments (2,076.08) (14,489.76) GL
430 11/27/2012 Property Taxes/Assessments (23.32) (14,513.08) GL
431 11/28/2012 Property Taxes/Assessments (514.28) (15,027.36) GL
432 11/29/2012 Property Taxes/Assessments (1,315.49) (16,342.85) GL
433 11/30/2012 Property Taxes/Assessments (725.95) (17,068.80) GL
_______________
Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (13,397.74) (17,068.80) **
(252,084.00) Budgeted (235,015.20) Remaining 7 % Used
Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent
(5.36) .00 (5.36)
_______________
Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: .00 (5.36) **
(4,700.00) Budgeted (4,694.64) Remaining 0 % Used
Account: 122-40010-000-000 Property Taxes/MUD Fire
435 11/01/2012 Property Taxes/Assessments (26,422.94) (2,097.45) (28,520.39) GL
396 11/02/2012 Property Taxes/Assessments (1,391.67) (29,912.06) GL
398 11/05/2012 Property Taxes/Assessments (1,388.30) (31,300.36) GL
434 11/06/2012 Property Taxes/Assessments (1,197.84) (32,498.20) GL
400 11/07/2012 Property Taxes/Assessments (22,390.29) (54,888.49) GL
401 11/08/2012 Property Taxes/Assessments (282.35) (55,170.84) GL
403 11/09/2012 Property Taxes/Assessments (660.89) (55,831.73) GL
405 11/13/2012 Property Taxes/Assessments (1,911.11) (57,742.84) GL
409 11/14/2012 Property Taxes/Assessments (2,469.00) (60,211.84) GL
411 11/15/2012 Property Taxes/Assessments (3,424.24) (63,636.08) GL
413 11/16/2012 Property Taxes/Assessments (1,235.78) (64,871.86) GL
Trophy Club Municipal Utility District No. 1 50 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 2
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program:
Period Ending: 11/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
415 11/19/2012 Property Taxes/Assessments (26,422.94) (3,033.48) (67,905.34) GL
417 11/20/2012 Property Taxes/Assessments (1,014.76) (68,920.10) GL
419 11/21/2012 Property Taxes/Assessments (2,737.91) (71,658.01) GL
428 11/26/2012 Property Taxes/Assessments (4,276.10) (75,934.11) GL
430 11/27/2012 Property Taxes/Assessments (2,569.98) (78,504.09) GL
431 11/28/2012 Property Taxes/Assessments (1,373.54) (79,877.63) GL
432 11/29/2012 Property Taxes/Assessments (926.36) (80,803.99) GL
433 11/30/2012 Property Taxes/Assessments (1,843.98) (82,647.97) GL
_______________
Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (56,225.03) (82,647.97) **
(1,050,349.00) Budgeted (967,701.03) Remaining 8 % Used
Account: 122-40011-000-000 Property Taxes/Fire-Delinquent
400 11/07/2012 Property Taxes/Assessments (2,362.65) 2,594.92 232.27 GL
417 11/20/2012 Property Taxes/Assessments (3,692.49) (3,460.22) GL
431 11/28/2012 Property Taxes/Assessments (135.64) (3,595.86) GL
_______________
Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (1,233.21) (3,595.86) **
(5,800.00) Budgeted (2,204.14) Remaining 62 % Used
Account: 122-40015-000-000 Property Taxes/Assessments P&I
(1.08) .00 (1.08)
_______________
Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: .00 (1.08) **
(750.00) Budgeted (748.92) Remaining 0 % Used
Account: 122-40020-000-000 Property Taxes/Fire P&I
417 11/20/2012 Property Taxes/Assessments (593.43) (849.27) (1,442.70) GL
_______________
Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (849.27) (1,442.70) **
(4,500.00) Budgeted (3,057.30) Remaining 32 % Used
Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft
460 11/01/2012 Recode JE408/Fire Permits (400.00) (400.00) GL
_______________
Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (400.00) (400.00) **
(6,000.00) Budgeted (5,600.00) Remaining 7 % Used
Account: 122-43400-000-000 Fire Inspections
Trophy Club Municipal Utility District No. 1 51 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 3
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program:
Period Ending: 11/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
460 11/01/2012 Recode JE408/Fire Permits (75.00) (75.00) GL
_______________
Account: 122-43400-000-000 Fire Inspections Totals: (75.00) (75.00) **
(500.00) Budgeted (425.00) Remaining 15 % 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
Account: 122-49900-000-000 Miscellaneous Income
408 11/01/2012 10/25 Permits-FD (1,000.00) (1,000.00) GL
460 11/01/2012 Recode JE408/Fire Permits 475.00 (525.00) GL
_______________
Account: 122-49900-000-000 Miscellaneous Income Totals: (525.00) (525.00) **
(1,200.00) Budgeted (675.00) Remaining 44 % Used
Department Totals: ------------------------------------------------------------------------------------------------ (105,761.77) **
(1,335,883.00) Budgeted (1,230,121.23) Remaining 8 % Used
Trophy Club Municipal Utility District No. 1 52 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 4
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 11/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
442 11/07/2012 Payroll 11/7/12 22,869.40 15,354.39 38,223.79 GL
443 11/21/2012 Payroll 11/21/12 16,677.37 54,901.16 GL
446 11/21/2012 Fire Stipend 11/21/12 6,400.00 61,301.16 GL
_______________
Account: 122-50005-045-000 Salaries & Wages Totals: 38,431.76 61,301.16 **
444,717.00 Budgeted 383,415.84 Remaining 14 % Used
Account: 122-50010-045-000 Overtime
443 11/21/2012 Payroll 11/21/12 2,552.34 5,357.95 7,910.29 GL
_______________
Account: 122-50010-045-000 Overtime Totals: 5,357.95 7,910.29 **
31,375.00 Budgeted 23,464.71 Remaining 25 % 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
442 11/07/2012 Payroll 11/7/12 575.00 575.00 1,150.00 GL
_______________
Account: 122-50017-045-000 Certification Totals: 575.00 1,150.00 **
4,896.00 Budgeted 3,746.00 Remaining 23 % Used
Account: 122-50020-045-000 Retirement
442 11/07/2012 Payroll 11/7/12 4,687.17 2,178.82 6,865.99 GL
443 11/21/2012 Payroll 11/21/12 2,930.60 9,796.59 GL
446 11/21/2012 Fire Stipend 11/21/12 1,233.40 11,029.99 GL
_______________
Account: 122-50020-045-000 Retirement Totals: 6,342.82 11,029.99 **
69,242.00 Budgeted 58,212.01 Remaining 16 % Used
Trophy Club Municipal Utility District No. 1 53 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 5
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 11/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
442 11/07/2012 Payroll 11/7/12 3,336.51 1,668.22 5,004.73 GL
443 11/21/2012 Payroll 11/21/12 1,668.19 6,672.92 GL
_______________
Account: 122-50026-045-000 Medical Insurance Totals: 3,336.41 6,672.92 **
48,327.00 Budgeted 41,654.08 Remaining 14 % Used
Account: 122-50027-045-000 Dental Insurance
442 11/07/2012 Payroll 11/7/12 311.93 155.96 467.89 GL
443 11/21/2012 Payroll 11/21/12 156.00 623.89 GL
_______________
Account: 122-50027-045-000 Dental Insurance Totals: 311.96 623.89 **
3,635.00 Budgeted 3,011.11 Remaining 17 % Used
Account: 122-50028-045-000 Vision Insurance
442 11/07/2012 Payroll 11/7/12 64.11 32.06 96.17 GL
443 11/21/2012 Payroll 11/21/12 32.05 128.22 GL
_______________
Account: 122-50028-045-000 Vision Insurance Totals: 64.11 128.22 **
824.00 Budgeted 695.78 Remaining 16 % Used
Account: 122-50029-045-000 Life Insurance & Other
442 11/07/2012 Payroll 11/7/12 292.56 292.56 GL
443 11/21/2012 Payroll 11/21/12 292.58 585.14 GL
_______________
Account: 122-50029-045-000 Life Insurance & Other Totals: 585.14 585.14 **
4,250.00 Budgeted 3,664.86 Remaining 14 % Used
Account: 122-50030-045-000 Social Security Taxes
442 11/07/2012 Payroll 11/7/12 1,993.94 892.23 2,886.17 GL
443 11/21/2012 Payroll 11/21/12 1,270.79 4,156.96 GL
446 11/21/2012 Fire Stipend 11/21/12 553.35 4,710.31 GL
_______________
Account: 122-50030-045-000 Social Security Taxes Totals: 2,716.37 4,710.31 **
30,897.00 Budgeted 26,186.69 Remaining 15 % Used
Account: 122-50035-045-000 Medicare Taxes
442 11/07/2012 Payroll 11/7/12 466.36 208.66 675.02 GL
Trophy Club Municipal Utility District No. 1 54 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 6
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 11/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
443 11/21/2012 Payroll 11/21/12 466.36 297.21 972.23 GL
446 11/21/2012 Fire Stipend 11/21/12 129.37 1,101.60 GL
_______________
Account: 122-50035-045-000 Medicare Taxes Totals: 635.24 1,101.60 **
7,226.00 Budgeted 6,124.40 Remaining 15 % Used
Account: 122-50040-045-000 Unemployment Taxes
442 11/07/2012 Payroll 11/7/12 22.78 2.11 24.89 GL
443 11/21/2012 Payroll 11/21/12 13.53 38.42 GL
_______________
Account: 122-50040-045-000 Unemployment Taxes Totals: 15.64 38.42 **
1,481.00 Budgeted 1,442.58 Remaining 3 % Used
Account: 122-50045-045-000 Workman's Compensation
10,000.00 .00 10,000.00
_______________
Account: 122-50045-045-000 Workman's Compensation Totals: .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
259 11/18/2012 Nov A/P Rug Service 292.00 23.18 315.18 G & K SERVICES 31916 AP
259 11/18/2012 Nov A/P Rug Service/Fire Station 23.18 338.36 G & K SERVICES 31916 AP
259 11/18/2012 Nov A/P Rug Service 23.18 361.54 G & K SERVICES 31916 AP
259 11/18/2012 Nov A/P Rug Service 23.18 384.72 G & K SERVICES 31916 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schultz 46.36 431.08 JPMORGAN CHASE BANK NA 31966 AP
335 11/30/2012 Nov A/P Rug service 23.18 454.26 G & K SERVICES 31970 AP
Trophy Club Municipal Utility District No. 1 55 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 7
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 11/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-55080-045-000 Maintenance & Repairs Totals: 162.26 454.26 **
9,562.00 Budgeted 9,107.74 Remaining 5 % Used
Account: 122-55090-045-000 Vehicle Maintenance
427 11/26/2012 Siddons/Refund overbilling 272.57 (750.59) (478.02) GL
387 11/30/2012 Nov A/P Q-681 filter oil spin 27.17 (450.85) INDUSTRIAL POWER TRUCK & EQUIP 31984 AP
_______________
Account: 122-55090-045-000 Vehicle Maintenance Totals: (723.42) (450.85) **
14,850.00 Budgeted 15,300.85 Remaining -3 % 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
259 11/18/2012 Nov A/P Pest Control/Fire Station 243.51 140.00 383.51 GANN'S PEST CONTROL 31917 AP
424 11/18/2012 FD Nov Cable (120.00) 263.51 GL
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Thomas 97.42 360.93 JPMORGAN CHASE BANK NA 31966 AP
_______________
Account: 122-55100-045-000 Building Maintenance Totals: 117.42 360.93 **
6,500.00 Budgeted 6,139.07 Remaining 6 % 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
Trophy Club Municipal Utility District No. 1 56 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 8
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 11/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
13.01 .00 13.01
_______________
Account: 122-60005-045-000 Telephone Totals: .00 13.01 **
106.00 Budgeted 92.99 Remaining 12 % Used
Account: 122-60010-045-000 Communications/Pagers/Mobiles
442 11/07/2012 Payroll 11/7/12 1,391.00 76.50 1,467.50 GL
259 11/18/2012 Nov A/P Oct Cells 140.38 1,607.88 VERIZON WIRELESS 31940 AP
_______________
Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 216.88 1,607.88 **
2,500.00 Budgeted 892.12 Remaining 64 % Used
Account: 122-60020-045-000 Electricity/Gas
303 11/27/2012 Nov A/P Electricity/Fire Station 10/12 382.64 417.61 800.25 HUDSON ENERGY 31955 AP
303 11/27/2012 Nov A/P Fire Station Gas 10/17-11/12 58.36 858.61 ATMOS ENERGY 31947 AP
_______________
Account: 122-60020-045-000 Electricity/Gas Totals: 475.97 858.61 **
6,167.00 Budgeted 5,308.39 Remaining 14 % Used
Account: 122-60025-045-000 Water
259 11/18/2012 Nov A/P Water/October 294.78 294.78 TROPHY CLUB MUD (WATER BILLS) 31936 AP
_______________
Account: 122-60025-045-000 Water Totals: 294.78 294.78 **
1,400.00 Budgeted 1,105.22 Remaining 21 % 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
289 11/30/2012 November postage used 27.25 27.25 GL
_______________
Account: 122-60035-045-000 Postage Totals: 27.25 27.25 **
100.00 Budgeted 72.75 Remaining 27 % Used
Account: 122-60055-045-000 Insurance
Trophy Club Municipal Utility District No. 1 57 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 9
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 11/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
50.00 .00 50.00
_______________
Account: 122-60055-045-000 Insurance Totals: .00 50.00 **
10,000.00 Budgeted 9,950.00 Remaining 1 % Used
Account: 122-60066-045-000 Publications/Books/Subscrips
.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
259 11/18/2012 Nov A/P New Cert/Garrett Basic Wildlan 6,820.91 85.00 6,905.91 TX COMM ON FIRE PROTECTION 31937 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Sipes 100.00 7,005.91 JPMORGAN CHASE BANK NA 31966 AP
_______________
Account: 122-60070-045-000 Dues & Memberships Totals: 185.00 7,005.91 **
7,500.00 Budgeted 494.09 Remaining 93 % 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
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Sipes 530.00 530.00 JPMORGAN CHASE BANK NA 31966 AP
_______________
Account: 122-60080-045-000 Schools & Training Totals: 530.00 530.00 **
5,000.00 Budgeted 4,470.00 Remaining 11 % Used
Account: 122-60096-045-000 Emergency Management
303 11/27/2012 Nov A/P Emergency Management dues 2013 1,000.00 1,000.00 N CENTRAL TX COG 31958 AP
_______________
Account: 122-60096-045-000 Emergency Management Totals: 1,000.00 1,000.00 **
1,000.00 Budgeted .00 Remaining 100 % Used
Account: 122-60100-045-000 Travel & per diem
Trophy Club Municipal Utility District No. 1 58 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 10
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 11/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
309 11/27/2012 Nov A/P 10/6-11/5 PCards/Hurd 574.59 574.59 JPMORGAN CHASE BANK NA 31966 AP
_______________
Account: 122-60100-045-000 Travel & per diem Totals: 574.59 574.59 **
4,800.00 Budgeted 4,225.41 Remaining 12 % Used
Account: 122-60110-045-000 Physicals/Testing
.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
122.35 .00 122.35
_______________
Account: 122-60125-045-000 Advertising Totals: .00 122.35 **
150.00 Budgeted 27.65 Remaining 82 % Used
Account: 122-60160-045-000 Programs & Special Projects
259 11/18/2012 Nov A/P Bounce house for fire open hou 270.00 147.75 417.75 LET'S JUMP 31922 AP
303 11/27/2012 Nov A/P kids hats, pens, pencils, badg 1,475.16 1,892.91 ARTCRAFT & FOREMOST INC 31945 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Sipes 10.60 1,903.51 JPMORGAN CHASE BANK NA 31966 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Sipes 22.32 1,925.83 JPMORGAN CHASE BANK NA 31966 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schultz 137.89 2,063.72 JPMORGAN CHASE BANK NA 31966 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schultz 6.86 2,070.58 JPMORGAN CHASE BANK NA 31966 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schultz 42.19 2,112.77 JPMORGAN CHASE BANK NA 31966 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schultz 27.27 2,140.04 JPMORGAN CHASE BANK NA 31966 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schultz 12.50 2,152.54 JPMORGAN CHASE BANK NA 31966 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Sipes 78.75 2,231.29 JPMORGAN CHASE BANK NA 31966 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Sipes (32.35) 2,198.94 JPMORGAN CHASE BANK NA 31966 AP
_______________
Account: 122-60160-045-000 Programs & Special Projects Totals: 1,928.94 2,198.94 **
4,200.00 Budgeted 2,001.06 Remaining 52 % Used
Account: 122-60180-045-000 Fire Inspection/Enforcement
259 11/18/2012 Nov A/P Fire Marshal Badges 153.73 153.73 ENTENMANN-ROVIN CO 31913 AP
_______________
Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: 153.73 153.73 **
1,900.00 Budgeted 1,746.27 Remaining 8 % Used
Trophy Club Municipal Utility District No. 1 59 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 11
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 11/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-60195-045-000 Flags & Repair
149.75 .00 149.75
_______________
Account: 122-60195-045-000 Flags & Repair Totals: .00 149.75 **
2,543.00 Budgeted 2,393.25 Remaining 6 % Used
Account: 122-60245-045-000 Miscellaneous Expense
43.20 .00 43.20
_______________
Account: 122-60245-045-000 Miscellaneous Expense Totals: .00 43.20 **
1,237.00 Budgeted 1,193.80 Remaining 3 % Used
Account: 122-65005-045-000 Fuel & Lube
309 11/27/2012 Nov A/P 10/6-11/5 PCards/Hurd 78.06 78.06 JPMORGAN CHASE BANK NA 31966 AP
323 11/28/2012 October Gas Log 1,035.26 1,113.32 GL
393 11/30/2012 Nov Gas Purchases 768.70 1,882.02 GL
_______________
Account: 122-65005-045-000 Fuel & Lube Totals: 1,882.02 1,882.02 **
10,000.00 Budgeted 8,117.98 Remaining 19 % Used
Account: 122-65010-045-000 Uniforms
259 11/18/2012 Nov A/P 2 Uniform Shirts/Chief 69.50 69.50 PANDA EMBROIDERY 31923 AP
259 11/18/2012 Nov A/P Cancer Tshirts 213.75 283.25 THE TSHIRTGUYS.COM 31931 AP
_______________
Account: 122-65010-045-000 Uniforms Totals: 283.25 283.25 **
4,357.00 Budgeted 4,073.75 Remaining 7 % 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
Trophy Club Municipal Utility District No. 1 60 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 12
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 11/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-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
387 11/30/2012 Nov A/P Office Supplies 5.56 15.15 20.71 OFFICE DEPOT, INC 31989 AP
_______________
Account: 122-65085-045-000 Office Supplies Totals: 15.15 20.71 **
1,200.00 Budgeted 1,179.29 Remaining 2 % Used
Account: 122-65095-045-000 Maintenance Supplies
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schultz 206.62 206.62 JPMORGAN CHASE BANK NA 31966 AP
_______________
Account: 122-65095-045-000 Maintenance Supplies Totals: 206.62 206.62 **
2,785.00 Budgeted 2,578.38 Remaining 7 % 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
Trophy Club Municipal Utility District No. 1 61 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 13
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 11/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-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: ------------------------------------------------------------------------------------------------ 122,638.88 **
1,335,883.00 Budgeted 1,213,244.12 Remaining 9 % Used
Fund 122 Totals: ------------------------------------------------------------------------------------------------------ 16,877.11
.00 Budgeted (16,877.11) Remaining 0 % Used
Trophy Club Municipal Utility District No. 1 62 of 143 December 17, 2012
Municipal Utility District No 1 - O & M
Interim Balance Sheet
Balance @
11/30/2012
ASSETS
ASSETS
CASH ON HAND 400
CASH IN BANK 198,292
INVESTMENTS 2,723,449
RESTRICTED ASSETS:
INVESTMENTS 429,371
PREPAID EXPENSES -
ADVALOREM PROPERTY TAXES RECEIVABLE 94,935
UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,057,329
TOTAL ASSETS 4,503,776$
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 94,935$
ACCOUNTS PAYABLE 655,613
CUSTOMER DEPOSITS 215,122
TOTAL LIABILITIES 965,670
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 555,072
UNASSIGNED FUND BALANCE 2,766,322
TOTAL FUND BALANCE 3,538,106
TOTAL LIABILITIES AND FUND BALANCE 4,503,776$
November 30, 2012
2/12 Months (16.66% of Fiscal Year)
Trophy Club Municipal Utility District No. 1 63 of 143 December 17, 2012
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 4
13:23 12/13/12 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 11/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- 5,346.78- 7,859.48- 7.869 92,024.52-
135-40002-000-000 Property Taxes/Delinquent 500.00- 500.00- 404.85- 659.53- 131.906 159.53
135-40015-000-000 Property Taxes/P & I 1,200.00- 1,200.00- 372.06- 450.09- 37.508 749.91-
Subtotal: 101,584.00- 101,584.00- 6,123.69- 8,969.10- 8.829 92,614.90-
135-47000-000-000 Water 3,545,609.00- 3,545,609.00- 286,485.61- 553,069.96- 15.599 2,992,539.04-
135-47005-000-000 Sewer 1,653,747.00- 1,653,747.00- 151,094.73- 282,782.39- 17.099 1,370,964.61-
135-47020-000-000 Standby 576.00- 576.00- 54.00- 101.90- 17.691 474.10-
135-47025-000-000 Penalties 64,580.00- 64,580.00- 6,168.97- 11,210.49- 17.359 53,369.51-
135-47030-000-000 Service Charges 11,625.00- 11,625.00- 878.00- 1,781.00- 15.320 9,844.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- 300.00- 450.00- 8.654 4,750.00-
135-47070-000-000 TCCC Effluent Charges 77,575.00- 77,575.00- 4,882.15- 4,882.15- 6.293 72,692.85-
Subtotal: 5,360,712.00- 5,360,712.00- 449,863.46- 854,277.89- 15.936 4,506,434.11-
135-48005-000-000 Utility Fees 644,000.00- 644,000.00- 29,900.00- 71,300.00- 11.071 572,700.00-
Subtotal: 644,000.00- 644,000.00- 29,900.00- 71,300.00- 11.071 572,700.00-
135-49010-000-000 Interest Income 5,500.00- 5,500.00- 519.43- 1,121.28- 20.387 4,378.72-
135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 1,757.53- 17.292 8,406.47-
135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 1,166.66- 16.667 5,833.34-
135-49030-000-000 Vending Revenue 350.00- 350.00- 18.76- 18.76- 5.360 331.24-
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- 4,672.00- 10,220.00- 14.000 62,780.00-
135-49900-000-000 Miscellaneous Income 1,000.00- 1,000.00- 1,149.99- 1,706.06- 170.606 706.06
135-49905-000-000 Gas Well Revenue 200.00- 200.00- 200.00-
Subtotal: 402,962.00- 402,962.00- 7,854.04- 15,990.29- 3.968 386,971.71-
Program number: 6,509,258.00- 6,509,258.00- 493,741.19- 950,537.28- 14.603 5,558,720.72-
Department number: Revenues 6,509,258.00- 6,509,258.00- 493,741.19- 950,537.28- 14.603 5,558,720.72-
Revenues Subtotal ----------- 6,509,258.00- 6,509,258.00- 493,741.19- 950,537.28- 14.603 5,558,720.72-
Trophy Club Municipal Utility District No. 1 64 of 143 December 17, 2012
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 5
13:23 12/13/12 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 11/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 13,187.73 22,290.01 10.449 191,030.99
135-50010-010-000 Overtime 13,250.00 13,250.00 1,212.03 3,424.59 25.846 9,825.41
135-50016-010-000 Longevity 3,080.00 3,080.00 3,080.00 3,080.00 100.000
135-50017-010-000 Certification 5,100.00 5,100.00 300.00 600.00 11.765 4,500.00
135-50020-010-000 Retirement 32,725.00 32,725.00 27,480.64 29,685.80 90.713 3,039.20
135-50026-010-000 Medical Insurance 28,920.00 28,920.00 1,683.92 3,367.84 11.645 25,552.16
135-50027-010-000 Dental Insurance 2,091.00 2,091.00 132.78 265.56 12.700 1,825.44
135-50028-010-000 Vision Insurance 519.00 519.00 31.76 63.52 12.239 455.48
135-50029-010-000 Life Insurance & Other 1,204.00 1,204.00 286.80 286.80 23.821 917.20
135-50030-010-000 Social Security Taxes 14,555.00 14,555.00 1,078.98 2,044.92 14.050 12,510.08
135-50035-010-000 Medicare Taxes 3,404.00 3,404.00 252.34 478.25 14.050 2,925.75
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 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 48,726.98 71,696.29 22.008 254,076.71
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 8,971.68 10,009.23 20.018 39,990.77
135-55090-010-000 Vehicle Maintenance 3,700.00 3,700.00 459.39 459.39 12.416 3,240.61
135-55105-010-000 Maintenance-Backhoe/SkidLoader 2,900.00 2,900.00 1,546.80 1,546.80 53.338 1,353.20
135-55135-010-000 Lab Analysis 4,500.00 4,500.00 1,125.15 1,125.15 25.003 3,374.85
Subtotal: 64,100.00 64,100.00 12,103.02 13,140.57 20.500 50,959.43
135-60010-010-000 Communications/Pagers/Mobiles 2,000.00 2,000.00 175.79 175.79 8.790 1,824.21
135-60020-010-000 Electricity 162,410.00 162,410.00 9,813.13 15,215.06 9.368 147,194.94
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 240.00 240.00 14.354 1,432.00
135-60090-010-000 Safety Program 500.00 500.00 500.00
135-60100-010-000 Travel & per diem 700.00 700.00 239.21 388.51 55.501 311.49
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 8,173.45 8,173.45 22.831 27,626.55
135-60150-010-000 Wholesale Water 2,028,447.00 2,028,447.00 162,916.59 162,916.59 8.032 1,865,530.41
135-60245-010-000 Miscellaneous Expenses 500.00 500.00 500.00
135-60280-010-000 Property Maintenance 4,200.00 4,200.00 168.20 213.20 5.076 3,986.80
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 181,726.37 187,322.60 8.366 2,051,806.40
135-65005-010-000 Fuel & Lube 17,661.00 17,661.00 1,890.84 1,918.54 10.863 15,742.46
Trophy Club Municipal Utility District No. 1 65 of 143 December 17, 2012
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 6
13:23 12/13/12 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 11/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 720.12 720.12 26.870 1,959.88
135-65030-010-000 Chemicals 6,200.00 6,200.00 47.33 719.63 11.607 5,480.37
135-65035-010-000 Small Tools 1,500.00 1,500.00 267.19 267.19 17.813 1,232.81
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 93,750.00 93,750.00 65.308 49,800.00
Subtotal: 173,591.00 173,591.00 96,675.48 97,375.48 56.095 76,215.52
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 59,869.00 59,869.00 22.174 210,131.00
135-69281-010-000 Capital Repair-Ground Storage 150,000.00 150,000.00 69,788.02 69,788.02 46.525 80,211.98
Subtotal: 1,018,837.00 1,018,837.00 129,657.02 129,657.02 12.726 889,179.98
Program number: 3,821,430.00 3,821,430.00 468,888.87 499,191.96 13.063 3,322,238.04
Department number: Water 3,821,430.00 3,821,430.00 468,888.87 499,191.96 13.063 3,322,238.04
Trophy Club Municipal Utility District No. 1 66 of 143 December 17, 2012
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 7
13:23 12/13/12 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 11/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 14,401.78 24,303.91 12.351 172,477.09
135-50010-020-000 Overtime 10,166.00 10,166.00 1,361.99 2,153.98 21.188 8,012.02
135-50016-020-000 Longevity 2,858.00 2,858.00 2,857.50 2,857.50 99.983 .50
135-50017-020-000 Certification 4,200.00 4,200.00 350.00 700.00 16.667 3,500.00
135-50020-020-000 Retirement 29,821.00 29,821.00 27,645.29 29,754.23 99.776 66.77
135-50026-020-000 Medical Insurance 29,034.00 29,034.00 2,327.30 4,654.60 16.032 24,379.40
135-50027-020-000 Dental Insurance 2,112.00 2,112.00 175.34 350.68 16.604 1,761.32
135-50028-020-000 Vision Insurance 552.00 552.00 45.92 91.84 16.638 460.16
135-50029-020-000 Life Insurance & Other 920.00 920.00 311.58 311.58 33.867 608.42
135-50030-020-000 Social Security Taxes 13,268.00 13,268.00 1,015.85 1,801.59 13.578 11,466.41
135-50035-020-000 Medicare Taxes 3,103.00 3,103.00 237.56 421.34 13.578 2,681.66
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 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 50,730.11 70,340.25 23.683 226,669.75
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 9,713.49 17,338.48 43.346 22,661.52
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 72.064 419.04
135-55125-020-000 Dumpster Services 15,000.00 15,000.00 3,857.66 3,857.66 25.718 11,142.34
135-55135-020-000 Lab Analysis 30,000.00 30,000.00 2,498.50 3,578.50 11.928 26,421.50
Subtotal: 89,500.00 89,500.00 16,069.65 25,855.60 28.889 63,644.40
135-60010-020-000 Communications/Pagers/Mobiles 2,700.00 2,700.00 233.69 233.69 8.655 2,466.31
135-60020-020-000 Electricity 153,045.00 153,045.00 11,623.23 16,219.77 10.598 136,825.23
135-60066-020-000 Publications/Books/Subscripts 500.00 500.00 161.45 161.45 32.290 338.55
135-60080-020-000 Schools & Training 3,272.00 3,272.00 104.66 104.66 3.199 3,167.34
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 233.10 349.65 24.975 1,050.35
135-60105-020-000 Rent/Lease Equipment 1,500.00 1,500.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 13.803 48,270.20
135-60245-020-000 Miscellaneous Expenses 200.00 200.00 148.10 148.10 74.050 51.90
135-60285-020-000 Lawn Equipment & Maintenance 500.00 500.00 500.00
Subtotal: 221,367.00 221,367.00 12,504.23 25,967.12 11.730 195,399.88
135-65005-020-000 Fuel & Lube 8,527.00 8,527.00 1,908.74 1,908.74 22.385 6,618.26
135-65010-020-000 Uniforms 2,574.00 2,574.00 490.23 490.23 19.045 2,083.77
135-65030-020-000 Chemicals 10,000.00 10,000.00 2,220.00 8,468.30 84.683 1,531.70
Trophy Club Municipal Utility District No. 1 67 of 143 December 17, 2012
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 8
13:23 12/13/12 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 11/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 135.09 135.09 13.509 864.91
135-65040-020-000 Safety Equipment 250.00 250.00 250.00
135-65045-020-000 Lab Supplies 10,000.00 10,000.00 47.91 3,903.17 39.032 6,096.83
Subtotal: 32,351.00 32,351.00 4,801.97 14,905.53 46.074 17,445.47
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 84,105.96 137,068.50 13.187 902,359.50
Department number: Wastewater 1,039,428.00 1,039,428.00 84,105.96 137,068.50 13.187 902,359.50
Trophy Club Municipal Utility District No. 1 68 of 143 December 17, 2012
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 9
13:23 12/13/12 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 21 Collection Program:
Period Ending: 11/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 11,449.62 19,625.83 12.542 136,849.17
135-50010-021-000 Overtime 7,297.00 7,297.00 584.65 1,183.54 16.220 6,113.46
135-50016-021-000 Longevity 3,818.00 3,818.00 3,817.50 3,817.50 99.987 .50
135-50017-021-000 Certification 1,800.00 1,800.00 150.00 300.00 16.667 1,500.00
135-50020-021-000 Retirement 23,574.00 23,574.00 21,547.77 23,245.40 98.606 328.60
135-50026-021-000 Medical Insurance 20,198.00 20,198.00 1,683.08 3,366.16 16.666 16,831.84
135-50027-021-000 Dental Insurance 1,409.00 1,409.00 124.48 248.96 17.669 1,160.04
135-50028-021-000 Vision Insurance 357.00 357.00 29.72 59.44 16.650 297.56
135-50029-021-000 Life Insurance & Other 1,008.00 1,008.00 238.68 238.68 23.679 769.32
135-50030-021-000 Social Security Taxes 10,502.00 10,502.00 937.55 1,644.58 15.660 8,857.42
135-50035-021-000 Medicare Taxes 2,456.00 2,456.00 219.26 384.61 15.660 2,071.39
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 100.000
135-50070-021-000 Employee Relations 250.00 250.00 16.78 16.78 6.712 233.22
Subtotal: 233,059.00 233,059.00 40,799.09 57,479.48 24.663 175,579.52
135-55005-021-000 Engineering 1,500.00 1,500.00 2,450.00 2,450.00 163.333 950.00-
135-55080-021-000 Maintenance & Repairs 35,000.00 35,000.00 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 2,450.00 2,618.50 6.819 35,781.50
135-60010-021-000 Communications/Pagers/Mobiles 3,500.00 3,500.00 217.50 217.50 6.214 3,282.50
135-60020-021-000 Electricity 18,705.00 18,705.00 1,355.78 1,688.65 9.028 17,016.35
135-60070-021-000 Dues & Memberships 250.00 250.00 111.00 111.00 44.400 139.00
135-60080-021-000 Schools & Training 826.00 826.00 240.00 330.00 39.952 496.00
135-60090-021-000 Safety Program 500.00 500.00 500.00
135-60100-021-000 Travel & per diem 450.00 450.00 67.71 87.14 19.364 362.86
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 1,991.99 2,434.29 7.091 31,896.71
135-65005-021-000 Fuel & Lube 12,117.00 12,117.00 1,834.81 1,834.81 15.142 10,282.19
135-65010-021-000 Uniforms 2,220.00 2,220.00 815.08 815.08 36.715 1,404.92
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 70.00 70.00 4.667 1,430.00
135-65040-021-000 Safety Equipment 500.00 500.00 500.00
Subtotal: 23,837.00 23,837.00 2,719.89 2,719.89 11.410 21,117.11
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 69 of 143 December 17, 2012
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 10
13:23 12/13/12 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 21 Collection Program:
Period Ending: 11/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 47,960.97 65,252.16 14.189 394,634.84
Department number: Collection 459,887.00 459,887.00 47,960.97 65,252.16 14.189 394,634.84
Trophy Club Municipal Utility District No. 1 70 of 143 December 17, 2012
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 11
13:23 12/13/12 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program:
Period Ending: 11/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 900.00 1,400.00 14.000 8,600.00
135-50030-026-000 Social Security Taxes 620.00 620.00 55.80 86.80 14.000 533.20
135-50035-026-000 Medicare Taxes 145.00 145.00 13.05 20.30 14.000 124.70
135-50040-026-000 Unemployment Taxes 210.00 210.00 26.10 40.60 19.333 169.40
135-50045-026-000 Workman's Compensation 150.00 150.00 150.00
Subtotal: 11,125.00 11,125.00 994.95 1,547.70 13.912 9,577.30
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 44.00 66.00 5.500 1,134.00
135-60080-026-000 Schools & Training 4,000.00 4,000.00 580.00 580.00 14.500 3,420.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 624.00 646.00 4.181 14,804.00
Program number: 26,575.00 26,575.00 1,618.95 2,193.70 8.255 24,381.30
Department number: Board of Directors 26,575.00 26,575.00 1,618.95 2,193.70 8.255 24,381.30
Trophy Club Municipal Utility District No. 1 71 of 143 December 17, 2012
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 12
13:23 12/13/12 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 11/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 33,862.95 59,733.29 13.431 384,996.71
135-50010-030-000 Overtime 1,500.00 1,500.00 40.37 49.31 3.287 1,450.69
135-50016-030-000 Longevity 2,193.00 2,193.00 2,317.50 2,317.50 105.677 124.50-
135-50020-030-000 Retirement 60,441.00 60,441.00 49,204.98 53,730.46 88.897 6,710.54
135-50026-030-000 Medical Insurance 44,066.00 44,066.00 3,185.30 6,370.60 14.457 37,695.40
135-50027-030-000 Dental Insurance 3,379.00 3,379.00 288.72 577.44 17.089 2,801.56
135-50028-030-000 Vision Insurance 795.00 795.00 66.20 132.40 16.654 662.60
135-50029-030-000 Life Insurance & Other 2,500.00 2,500.00 584.92 584.92 23.397 1,915.08
135-50030-030-000 Social Security Taxes 27,802.00 27,802.00 2,077.59 4,015.01 14.441 23,786.99
135-50035-030-000 Medicare Taxes 6,502.00 6,502.00 485.88 938.99 14.442 5,563.01
135-50040-030-000 Unemployment Taxes 1,537.00 1,537.00 134.08 329.92 21.465 1,207.08
135-50045-030-000 Workman's Compensation 831.00 831.00 831.00 100.000
135-50060-030-000 Pre-emp Physicals/Testing 250.00 250.00 4.00 39.00 15.600 211.00
135-50070-030-000 Employee Relations 5,000.00 5,000.00 5,000.00
Subtotal: 601,526.00 601,526.00 92,252.49 129,649.84 21.553 471,876.16
135-55030-030-000 Software & Support 63,555.00 63,555.00 5,530.27 8,492.02 13.362 55,062.98
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 1,475.92 1,508.28 30.166 3,491.72
135-55120-030-000 Cleaning Services 20,200.00 20,200.00 1,812.17 3,490.68 17.281 16,709.32
135-55160-030-000 Professional Outside Services 15,000.00 15,000.00 6,825.00 6,825.00 45.500 8,175.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-
135-55205-030-000 Utility Billing Contract 11,000.00 11,000.00 1,567.28 1,567.28 14.248 9,432.72
Subtotal: 203,420.00 203,420.00 17,210.64 22,043.03 10.836 181,376.97
135-60005-030-000 Telephone 9,000.00 9,000.00 377.76 1,717.10 19.079 7,282.90
135-60010-030-000 Communications/Pagers/Mobiles 3,575.00 3,575.00 327.04 477.04 13.344 3,097.96
135-60020-030-000 Electricity/Gas 13,019.00 13,019.00 942.99 942.99 7.243 12,076.01
135-60025-030-000 Water 3,100.00 3,100.00 125.06 125.06 4.034 2,974.94
135-60030-030-000 Rent And/Or Usage 13,182.00 13,182.00 2,197.02 2,197.02 16.667 10,984.98
135-60035-030-000 Postage 23,000.00 23,000.00 3,757.60 4,410.26 19.175 18,589.74
135-60040-030-000 Service Charges & Fees 18,000.00 18,000.00 2,630.63 5,381.46 29.897 12,618.54
135-60050-030-000 Bad Debt Expense 8,500.00 8,500.00 1,056.53- -12.430 9,556.53
135-60055-030-000 Insurance 35,000.00 35,000.00 26,536.44 60,601.92 173.148 25,601.92-
135-60066-030-000 Publications/Books/Subscripts 750.00 750.00 109.00 558.22 74.429 191.78
135-60070-030-000 Dues & Memberships 2,400.00 2,400.00 550.00 650.00 27.083 1,750.00
135-60075-030-000 Meetings 250.00 250.00 88.00 35.200 162.00
135-60080-030-000 Schools & Training 5,500.00 5,500.00 450.00 450.00 8.182 5,050.00
135-60100-030-000 Travel & per diem 3,950.00 3,950.00 39.55 49.60 1.256 3,900.40
135-60110-030-000 Physicals/Testing 500.00 500.00 500.00
Trophy Club Municipal Utility District No. 1 72 of 143 December 17, 2012
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 13
13:23 12/13/12 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 11/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 109.13 122.13 .814 14,877.87
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 10.600 2,235.00
Subtotal: 173,076.00 173,076.00 38,152.22 76,979.27 44.477 96,096.73
135-65010-030-000 Uniforms 1,635.00 1,635.00 624.12 624.12 38.172 1,010.88
135-65055-030-000 Hardware 20,188.00 20,188.00 549.38 6,288.27 31.149 13,899.73
135-65085-030-000 Office Supplies 8,200.00 8,200.00 1,036.47 1,852.62 22.593 6,347.38
135-65090-030-000 Printer Supplies & Maintenance 5,732.00 5,732.00 285.00 511.00 8.915 5,221.00
135-65095-030-000 Maintenance Supplies 2,000.00 2,000.00 97.40 97.40 4.870 1,902.60
135-65097-030-000 Vending Machine Supplies 500.00 500.00 500.00
135-65105-030-000 Printing 5,200.00 5,200.00 395.00 395.00 7.596 4,805.00
Subtotal: 43,455.00 43,455.00 2,987.37 9,768.41 22.479 33,686.59
135-69170-030-000 Copier Lease Installments 3,450.00 3,450.00 256.85 513.70 14.890 2,936.30
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 513.70 1.692 29,847.30
Program number: 1,051,838.00 1,051,838.00 150,859.57 238,954.25 22.718 812,883.75
Department number: Administration 1,051,838.00 1,051,838.00 150,859.57 238,954.25 22.718 812,883.75
Trophy Club Municipal Utility District No. 1 73 of 143 December 17, 2012
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 14
13:23 12/13/12 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program:
Period Ending: 11/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 5,768.75 5,768.75 8.241 64,231.25
135-55055-039-000 Auditing 21,200.00 21,200.00 5,175.00 5,175.00 24.410 16,025.00
135-55060-039-000 Appraisal 15,100.00 15,100.00 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 10,943.75 13,266.49 12.049 96,833.51
Program number: 110,100.00 110,100.00 10,943.75 13,266.49 12.049 96,833.51
Department number: Non Departmental 110,100.00 110,100.00 10,943.75 13,266.49 12.049 96,833.51
Expenditures Subtotal ----------- 6,509,258.00 6,509,258.00 764,378.07 955,927.06 14.686 5,553,330.94
Fund number: 135 MUD 1 General Fund 270,636.88 5,389.78 5,389.78-
Trophy Club Municipal Utility District No. 1 74 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 14
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 11/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
435 11/01/2012 Property Taxes/Assessments (2,512.70) (199.46) (2,712.16) GL
396 11/02/2012 Property Taxes/Assessments (132.34) (2,844.50) GL
398 11/05/2012 Property Taxes/Assessments (132.02) (2,976.52) GL
434 11/06/2012 Property Taxes/Assessments (113.91) (3,090.43) GL
400 11/07/2012 Property Taxes/Assessments (2,129.23) (5,219.66) GL
401 11/08/2012 Property Taxes/Assessments (26.85) (5,246.51) GL
403 11/09/2012 Property Taxes/Assessments (62.85) (5,309.36) GL
405 11/13/2012 Property Taxes/Assessments (181.74) (5,491.10) GL
409 11/14/2012 Property Taxes/Assessments (234.79) (5,725.89) GL
411 11/15/2012 Property Taxes/Assessments (325.63) (6,051.52) GL
413 11/16/2012 Property Taxes/Assessments (117.52) (6,169.04) GL
415 11/19/2012 Property Taxes/Assessments (288.47) (6,457.51) GL
417 11/20/2012 Property Taxes/Assessments (96.50) (6,554.01) GL
419 11/21/2012 Property Taxes/Assessments (260.37) (6,814.38) GL
428 11/26/2012 Property Taxes/Assessments (406.64) (7,221.02) GL
430 11/27/2012 Property Taxes/Assessments (244.40) (7,465.42) GL
431 11/28/2012 Property Taxes/Assessments (130.62) (7,596.04) GL
432 11/29/2012 Property Taxes/Assessments (88.09) (7,684.13) GL
433 11/30/2012 Property Taxes/Assessments (175.35) (7,859.48) GL
_______________
Account: 135-40000-000-000 Property Taxes Totals: (5,346.78) (7,859.48) **
(99,884.00) Budgeted (92,024.52) Remaining 8 % Used
Account: 135-40002-000-000 Property Taxes/Delinquent
400 11/07/2012 Property Taxes/Assessments (254.68) 221.93 (32.75) GL
417 11/20/2012 Property Taxes/Assessments (609.08) (641.83) GL
431 11/28/2012 Property Taxes/Assessments (17.70) (659.53) GL
_______________
Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (404.85) (659.53) **
(500.00) Budgeted 159.53 Remaining 132 % Used
Account: 135-40015-000-000 Property Taxes/P & I
400 11/07/2012 Property Taxes/Assessments (78.03) (104.53) (182.56) GL
409 11/14/2012 Property Taxes/Assessments (.68) (183.24) GL
413 11/16/2012 Property Taxes/Assessments (1.14) (184.38) GL
415 11/19/2012 Property Taxes/Assessments (125.61) (309.99) GL
417 11/20/2012 Property Taxes/Assessments (140.09) (450.08) GL
431 11/28/2012 Property Taxes/Assessments (.01) (450.09) GL
_______________
Account: 135-40015-000-000 Property Taxes/P & I Totals: (372.06) (450.09) **
(1,200.00) Budgeted (749.91) Remaining 38 % Used
Trophy Club Municipal Utility District No. 1 75 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 15
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 11/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-47000-000-000 Water
320 11/27/2012 UB 11/27/12 Adjustments UB20121127-20121127 User: (266,584.35) 12.71 (266,571.64) UB
343 11/30/2012 UB 11/30/12 Billing UB20121130-20121130 User: (286,498.32) (553,069.96) UB
_______________
Account: 135-47000-000-000 Water Totals: (286,485.61) (553,069.96) **
(3,545,609.00) Budgeted (2,992,539.04) Remaining 16 % Used
Account: 135-47005-000-000 Sewer
320 11/27/2012 UB 11/27/12 Adjustments UB20121127-20121127 User: (131,687.66) 12.71 (131,674.95) UB
343 11/30/2012 UB 11/30/12 Billing UB20121130-20121130 User: (148,622.34) (280,297.29) UB
461 11/30/2012 Recode Comm Sewer to Seewr (2,485.10) (282,782.39) GL
_______________
Account: 135-47005-000-000 Sewer Totals: (151,094.73) (282,782.39) **
(1,653,747.00) Budgeted (1,370,964.61) Remaining 17 % Used
Account: 135-47015-000-000 Commercial Sewer
343 11/30/2012 UB 11/30/12 Billing UB20121130-20121130 User: (2,485.10) (2,485.10) UB
461 11/30/2012 Recode Comm Sewer to Seewr 2,485.10 .00 GL
_______________
Account: 135-47015-000-000 Commercial Sewer Totals: .00 .00 **
.00 Budgeted .00 Remaining 0 % Used
Account: 135-47020-000-000 Standby
343 11/30/2012 UB 11/30/12 Billing UB20121130-20121130 User: (47.90) (54.00) (101.90) UB
_______________
Account: 135-47020-000-000 Standby Totals: (54.00) (101.90) **
(576.00) Budgeted (474.10) Remaining 18 % Used
Account: 135-47025-000-000 Penalties
272 11/19/2012 UB 11/19/12 Adjustments UB20121119-20121119 User: (5,041.52) (27.56) (5,069.08) UB
286 11/21/2012 UB 11/21/2012 Penalties UB20121121-20121121 User: (6,058.41) (11,127.49) UB
320 11/27/2012 UB 11/27/12 Adjustments UB20121127-20121127 User: 4.63 (11,122.86) UB
329 11/28/2012 UB 11/28/2012 Adjustments UB20121128-20121128 User: 384.16 (10,738.70) UB
343 11/30/2012 UB 11/30/12 Billing UB20121130-20121130 User: (471.79) (11,210.49) UB
_______________
Account: 135-47025-000-000 Penalties Totals: (6,168.97) (11,210.49) **
(64,580.00) Budgeted (53,369.51) Remaining 17 % Used
Account: 135-47030-000-000 Service Charges
Trophy Club Municipal Utility District No. 1 76 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 16
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 11/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
168 11/07/2012 UB 11/7/12 Cut Off List Fees UB20121107-20121107 User: (903.00) (800.00) (1,703.00) UB
279 11/09/2012 UB 11/9/12 Adjustments UB20121109-20121109 User: (25.00) (1,728.00) UB
281 11/13/2012 UB 11/13/12 Adjustment UB20121113-20121113 User: (25.00) (1,753.00) UB
324 11/21/2012 UB 11/21/12 Adjustments UB20121121-20121121 User: (25.00) (1,778.00) UB
343 11/30/2012 UB 11/30/12 Billing UB20121130-20121130 User: (3.00) (1,781.00) UB
_______________
Account: 135-47030-000-000 Service Charges Totals: (878.00) (1,781.00) **
(11,625.00) Budgeted (9,844.00) Remaining 15 % 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
359 11/01/2012 Permits 11/1/12 (150.00) (150.00) (300.00) GL
353 11/19/2012 Permits 11/19/12 (150.00) (450.00) GL
_______________
Account: 135-47045-000-000 Sewer Inspections Totals: (300.00) (450.00) **
(5,200.00) Budgeted (4,750.00) Remaining 9 % Used
Account: 135-47070-000-000 TCCC Effluent Charges
425 11/26/2012 TCCC-Oct Effluent (4,882.15) (4,882.15) GL
_______________
Account: 135-47070-000-000 TCCC Effluent Charges Totals: (4,882.15) (4,882.15) **
(77,575.00) Budgeted (72,692.85) Remaining 6 % Used
Account: 135-48005-000-000 Utility Fees
348 11/06/2012 Permits 11/6/12 (41,400.00) (2,300.00) (43,700.00) GL
349 11/07/2012 Permits 11/7/12 (9,200.00) (52,900.00) GL
350 11/08/2012 Permits 11/8/12 (6,900.00) (59,800.00) GL
351 11/14/2012 Permits 11/14/12 (2,300.00) (62,100.00) GL
352 11/15/2012 Permits 11/15/12 (2,300.00) (64,400.00) GL
355 11/28/2012 Permits 11/28/12 (2,300.00) (66,700.00) GL
356 11/30/2012 Permits 11/30/12 (4,600.00) (71,300.00) GL
_______________
Account: 135-48005-000-000 Utility Fees Totals: (29,900.00) (71,300.00) **
(644,000.00) Budgeted (572,700.00) Remaining 11 % Used
Trophy Club Municipal Utility District No. 1 77 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 17
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 11/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-49010-000-000 Interest Income
377 11/30/2012 Nov Bank Interest (601.85) (69.08) (670.93) GL
377 11/30/2012 Nov Bank Interest (450.35) (1,121.28) GL
_______________
Account: 135-49010-000-000 Interest Income Totals: (519.43) (1,121.28) **
(5,500.00) Budgeted (4,378.72) Remaining 20 % Used
Account: 135-49016-000-000 Cell Tower Revenue
422 11/02/2012 AT&T Cell Tower (847.00) (910.53) (1,757.53) GL
_______________
Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (1,757.53) **
(10,164.00) Budgeted (8,406.47) Remaining 17 % Used
Account: 135-49018-000-000 Building Rent Income
423 11/18/2012 Town 10/2011 gas,rent, Misc (583.33) (583.33) (1,166.66) GL
_______________
Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (1,166.66) **
(7,000.00) Budgeted (5,833.34) Remaining 17 % Used
Account: 135-49030-000-000 Vending Revenue
421 11/02/2012 Coffee $ (18.76) (18.76) GL
_______________
Account: 135-49030-000-000 Vending Revenue Totals: (18.76) (18.76) **
(350.00) Budgeted (331.24) Remaining 5 % 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
359 11/01/2012 Permits 11/1/12 (5,548.00) (292.00) (5,840.00) GL
348 11/06/2012 Permits 11/6/12 (292.00) (6,132.00) GL
349 11/07/2012 Permits 11/7/12 (1,168.00) (7,300.00) GL
350 11/08/2012 Permits 11/8/12 (876.00) (8,176.00) GL
351 11/14/2012 Permits 11/14/12 (292.00) (8,468.00) GL
352 11/15/2012 Permits 11/15/12 (292.00) (8,760.00) GL
Trophy Club Municipal Utility District No. 1 78 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 18
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 11/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
353 11/19/2012 Permits 11/19/12 (5,548.00) (292.00) (9,052.00) GL
354 11/26/2012 Permits 11/26/12 (292.00) (9,344.00) GL
355 11/28/2012 Permits 11/28/12 (292.00) (9,636.00) GL
356 11/30/2012 Permits 11/30/12 (584.00) (10,220.00) GL
_______________
Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (4,672.00) (10,220.00) **
(73,000.00) Budgeted (62,780.00) Remaining 14 % Used
Account: 135-49900-000-000 Miscellaneous Income
359 11/01/2012 Permits 11/1/12 (556.07) (50.00) (606.07) GL
423 11/18/2012 Town 10/2011 gas,rent, Misc (840.00) (1,446.07) GL
423 11/18/2012 Town 10/2011 gas,rent, Misc (109.99) (1,556.06) GL
353 11/19/2012 Permits 11/19/12 (50.00) (1,606.06) GL
426 11/26/2012 Oncor Refnd/Unclaimed Property (100.00) (1,706.06) GL
_______________
Account: 135-49900-000-000 Miscellaneous Income Totals: (1,149.99) (1,706.06) **
(1,000.00) Budgeted 706.06 Remaining 171 % Used
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: ------------------------------------------------------------------------------------------------ (950,537.28) **
(6,509,258.00) Budgeted (5,558,720.72) Remaining 15 % Used
Trophy Club Municipal Utility District No. 1 79 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 19
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 11/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
442 11/07/2012 Payroll 11/7/12 9,102.28 6,585.47 15,687.75 GL
443 11/21/2012 Payroll 11/21/12 6,602.26 22,290.01 GL
445 11/21/2012 MUD Longevity 11/21/12 3,080.00 25,370.01 GL
462 11/21/2012 Recode Longevity pay (3,080.00) 22,290.01 GL
_______________
Account: 135-50005-010-000 Salaries & Wages Totals: 13,187.73 22,290.01 **
213,321.00 Budgeted 191,030.99 Remaining 10 % Used
Account: 135-50010-010-000 Overtime
442 11/07/2012 Payroll 11/7/12 2,212.56 489.28 2,701.84 GL
442 11/07/2012 Payroll 11/7/12 80.00 2,781.84 GL
443 11/21/2012 Payroll 11/21/12 436.43 3,218.27 GL
443 11/21/2012 Payroll 11/21/12 160.00 3,378.27 GL
444 11/21/2012 Supplemental Payroll 11/21/12 46.32 3,424.59 GL
_______________
Account: 135-50010-010-000 Overtime Totals: 1,212.03 3,424.59 **
13,250.00 Budgeted 9,825.41 Remaining 26 % Used
Account: 135-50016-010-000 Longevity
462 11/21/2012 Recode Longevity pay 3,080.00 3,080.00 GL
_______________
Account: 135-50016-010-000 Longevity Totals: 3,080.00 3,080.00 **
3,080.00 Budgeted .00 Remaining 100 % Used
Account: 135-50017-010-000 Certification
442 11/07/2012 Payroll 11/7/12 300.00 300.00 600.00 GL
_______________
Account: 135-50017-010-000 Certification Totals: 300.00 600.00 **
5,100.00 Budgeted 4,500.00 Remaining 12 % Used
Account: 135-50020-010-000 Retirement
442 11/07/2012 Payroll 11/7/12 2,205.16 1,030.25 3,235.41 GL
443 11/21/2012 Payroll 11/21/12 994.87 4,230.28 GL
444 11/21/2012 Supplemental Payroll 11/21/12 6.40 4,236.68 GL
445 11/21/2012 MUD Longevity 11/21/12 425.66 4,662.34 GL
335 11/30/2012 Nov A/P Retirement Employer Contributi 25,023.46 29,685.80 TCDRS 31974 AP
_______________
Account: 135-50020-010-000 Retirement Totals: 27,480.64 29,685.80 **
32,725.00 Budgeted 3,039.20 Remaining 91 % Used
Trophy Club Municipal Utility District No. 1 80 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 20
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 11/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-50026-010-000 Medical Insurance
442 11/07/2012 Payroll 11/7/12 1,683.92 841.96 2,525.88 GL
443 11/21/2012 Payroll 11/21/12 841.96 3,367.84 GL
_______________
Account: 135-50026-010-000 Medical Insurance Totals: 1,683.92 3,367.84 **
28,920.00 Budgeted 25,552.16 Remaining 12 % Used
Account: 135-50027-010-000 Dental Insurance
442 11/07/2012 Payroll 11/7/12 132.78 66.39 199.17 GL
443 11/21/2012 Payroll 11/21/12 66.39 265.56 GL
_______________
Account: 135-50027-010-000 Dental Insurance Totals: 132.78 265.56 **
2,091.00 Budgeted 1,825.44 Remaining 13 % Used
Account: 135-50028-010-000 Vision Insurance
442 11/07/2012 Payroll 11/7/12 31.76 15.88 47.64 GL
443 11/21/2012 Payroll 11/21/12 15.88 63.52 GL
_______________
Account: 135-50028-010-000 Vision Insurance Totals: 31.76 63.52 **
519.00 Budgeted 455.48 Remaining 12 % Used
Account: 135-50029-010-000 Life Insurance & Other
442 11/07/2012 Payroll 11/7/12 143.40 143.40 GL
443 11/21/2012 Payroll 11/21/12 143.40 286.80 GL
_______________
Account: 135-50029-010-000 Life Insurance & Other Totals: 286.80 286.80 **
1,204.00 Budgeted 917.20 Remaining 24 % Used
Account: 135-50030-010-000 Social Security Taxes
442 11/07/2012 Payroll 11/7/12 965.94 450.51 1,416.45 GL
443 11/21/2012 Payroll 11/21/12 434.64 1,851.09 GL
444 11/21/2012 Supplemental Payroll 11/21/12 2.87 1,853.96 GL
445 11/21/2012 MUD Longevity 11/21/12 190.96 2,044.92 GL
_______________
Account: 135-50030-010-000 Social Security Taxes Totals: 1,078.98 2,044.92 **
14,555.00 Budgeted 12,510.08 Remaining 14 % Used
Account: 135-50035-010-000 Medicare Taxes
Trophy Club Municipal Utility District No. 1 81 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 21
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 11/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
442 11/07/2012 Payroll 11/7/12 225.91 105.36 331.27 GL
443 11/21/2012 Payroll 11/21/12 101.65 432.92 GL
444 11/21/2012 Supplemental Payroll 11/21/12 .67 433.59 GL
445 11/21/2012 MUD Longevity 11/21/12 44.66 478.25 GL
_______________
Account: 135-50035-010-000 Medicare Taxes Totals: 252.34 478.25 **
3,404.00 Budgeted 2,925.75 Remaining 14 % Used
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
6,109.00 .00 6,109.00
_______________
Account: 135-50045-010-000 Workman's Compensation Totals: .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
Trophy Club Municipal Utility District No. 1 82 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 22
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 11/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-55080-010-000 Maintenance & Repairs
303 11/27/2012 Nov A/P Meters/Couplings 1,037.55 1,977.00 3,014.55 ATLAS UTILITY SUPPLY CO. 31946 AP
303 11/27/2012 Nov A/P 6" service saddles 108.18 3,122.73 ATLAS UTILITY SUPPLY CO. 31946 AP
303 11/27/2012 Nov A/P Misc Water repair parts 1,904.10 5,026.83 ATLAS UTILITY SUPPLY CO. 31946 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards/McMahon 229.39 5,256.22 JPMORGAN CHASE BANK NA 31966 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards/McMahon (163.40) 5,092.82 JPMORGAN CHASE BANK NA 31966 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards/McMahon 94.20 5,187.02 JPMORGAN CHASE BANK NA 31966 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schultz 38.76 5,225.78 JPMORGAN CHASE BANK NA 31966 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Womack 34.62 5,260.40 JPMORGAN CHASE BANK NA 31966 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Womack 19.34 5,279.74 JPMORGAN CHASE BANK NA 31966 AP
387 11/30/2012 Nov A/P Concrete pours 1040 TC Dr, 13 2,360.00 7,639.74 Robert West Construction, Inc 31990 AP
387 11/30/2012 Nov A/P Repair on cylinder 2,369.49 10,009.23 HOLT CAT 31983 AP
_______________
Account: 135-55080-010-000 Maintenance & Repairs Totals: 8,971.68 10,009.23 **
50,000.00 Budgeted 39,990.77 Remaining 20 % Used
Account: 135-55090-010-000 Vehicle Maintenance
259 11/18/2012 Nov A/P Ignition switch/water 2004 Che 226.18 226.18 WATSONS AUTOMOTIVE 31941 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards/McMahon 233.21 459.39 JPMORGAN CHASE BANK NA 31966 AP
_______________
Account: 135-55090-010-000 Vehicle Maintenance Totals: 459.39 459.39 **
3,700.00 Budgeted 3,240.61 Remaining 12 % Used
Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader
259 11/18/2012 Nov A/P 1,546.80 1,546.80 HOLT CAT 31918 AP
_______________
Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: 1,546.80 1,546.80 **
2,900.00 Budgeted 1,353.20 Remaining 53 % Used
Account: 135-55135-010-000 Lab Analysis
259 11/18/2012 Nov A/P Bac-T Samples 475.00 475.00 TARRANT CTY PUBLIC HEALTH LAB 31928 AP
303 11/27/2012 Nov A/P Asbestos testing 130.00 605.00 CRISP ANALYTICAL LABS, LLC 31951 AP
387 11/30/2012 Nov A/P Free ammonia reagent test set 520.15 1,125.15 HACH COMPANY 31982 AP
_______________
Account: 135-55135-010-000 Lab Analysis Totals: 1,125.15 1,125.15 **
4,500.00 Budgeted 3,374.85 Remaining 25 % Used
Account: 135-60010-010-000 Communications/Pagers/Mobiles
259 11/18/2012 Nov A/P Oct Cells 175.79 175.79 VERIZON WIRELESS 31940 AP
Trophy Club Municipal Utility District No. 1 83 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 23
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 11/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
_______________
Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: 175.79 175.79 **
2,000.00 Budgeted 1,824.21 Remaining 9 % Used
Account: 135-60020-010-000 Electricity
259 11/18/2012 Nov A/P Electricity 10/11-11/9 5,401.93 80.87 5,482.80 HUDSON ENERGY 31919 AP
303 11/27/2012 Nov A/P Electricity 10/11-11/12 5,708.65 11,191.45 HUDSON ENERGY 31955 AP
303 11/27/2012 Nov A/P Electricity 10/11-11/12 4,023.61 15,215.06 HUDSON ENERGY 31955 AP
_______________
Account: 135-60020-010-000 Electricity Totals: 9,813.13 15,215.06 **
162,410.00 Budgeted 147,194.94 Remaining 9 % 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
309 11/27/2012 Nov A/P 10/6-11/5 PCards/Slaght 240.00 240.00 JPMORGAN CHASE BANK NA 31966 AP
_______________
Account: 135-60080-010-000 Schools & Training Totals: 240.00 240.00 **
1,672.00 Budgeted 1,432.00 Remaining 14 % 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
Trophy Club Municipal Utility District No. 1 84 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 24
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 11/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
442 11/07/2012 Payroll 11/7/12 149.30 187.59 336.89 GL
443 11/21/2012 Payroll 11/21/12 51.62 388.51 GL
_______________
Account: 135-60100-010-000 Travel & per diem Totals: 239.21 388.51 **
700.00 Budgeted 311.49 Remaining 56 % Used
Account: 135-60105-010-000 Rent/Lease Equipment
.00 .00
_______________
Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 **
500.00 Budgeted 500.00 Remaining 0 % Used
Account: 135-60135-010-000 TCEQ Fees & Permits
259 11/18/2012 Nov A/P Water System Fee FY13 7,965.75 7,965.75 TX COMMISSION ENVIRONMENTAL QU 31938 AP
387 11/30/2012 Nov A/P Water testing per TCEQ 207.70 8,173.45 LOWER COLORADO RIVER AUTHORITY 31985 AP
_______________
Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 8,173.45 8,173.45 **
35,800.00 Budgeted 27,626.55 Remaining 23 % Used
Account: 135-60150-010-000 Wholesale Water
387 11/30/2012 Nov A/P Oct Wholesale Water 162,916.59 162,916.59 CITY OF FORT WORTH 31981 AP
_______________
Account: 135-60150-010-000 Wholesale Water Totals: 162,916.59 162,916.59 **
2,028,447.00 Budgeted 1,865,530.41 Remaining 8 % 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
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Womack 45.00 108.00 153.00 JPMORGAN CHASE BANK NA 31966 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Womack 42.00 195.00 JPMORGAN CHASE BANK NA 31966 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Womack 18.20 213.20 JPMORGAN CHASE BANK NA 31966 AP
_______________
Account: 135-60280-010-000 Property Maintenance Totals: 168.20 213.20 **
4,200.00 Budgeted 3,986.80 Remaining 5 % Used
Trophy Club Municipal Utility District No. 1 85 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 25
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 11/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-60285-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
_______________
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
323 11/28/2012 October Gas Log 27.70 1,124.47 1,152.17 GL
393 11/30/2012 Nov Gas Purchases 766.37 1,918.54 GL
_______________
Account: 135-65005-010-000 Fuel & Lube Totals: 1,890.84 1,918.54 **
17,661.00 Budgeted 15,742.46 Remaining 11 % Used
Account: 135-65010-010-000 Uniforms
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Womack 47.91 47.91 JPMORGAN CHASE BANK NA 31966 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Womack 672.21 720.12 JPMORGAN CHASE BANK NA 31966 AP
_______________
Account: 135-65010-010-000 Uniforms Totals: 720.12 720.12 **
2,680.00 Budgeted 1,959.88 Remaining 27 % Used
Account: 135-65030-010-000 Chemicals
309 11/27/2012 Nov A/P 10/6-11/5 PCards/McMahon 672.30 4.69 676.99 JPMORGAN CHASE BANK NA 31966 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Womack 42.64 719.63 JPMORGAN CHASE BANK NA 31966 AP
_______________
Account: 135-65030-010-000 Chemicals Totals: 47.33 719.63 **
6,200.00 Budgeted 5,480.37 Remaining 12 % Used
Account: 135-65035-010-000 Small Tools
259 11/18/2012 Nov A/P Tool Kits 70.00 70.00 TEXAS FACILITIES COMMISSION 31929 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Womack 8.99 78.99 JPMORGAN CHASE BANK NA 31966 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Womack 188.20 267.19 JPMORGAN CHASE BANK NA 31966 AP
Trophy Club Municipal Utility District No. 1 86 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 26
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 11/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
_______________
Account: 135-65035-010-000 Small Tools Totals: 267.19 267.19 **
1,500.00 Budgeted 1,232.81 Remaining 18 % 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
303 11/27/2012 Nov A/P Meters/Couplings 45,000.00 45,000.00 ATLAS UTILITY SUPPLY CO. 31946 AP
387 11/30/2012 Nov A/P Meters & transmitters 48,750.00 93,750.00 ATLAS UTILITY SUPPLY CO. 31978 AP
_______________
Account: 135-65050-010-000 Meter Expense Totals: 93,750.00 93,750.00 **
143,550.00 Budgeted 49,800.00 Remaining 65 % 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
387 11/30/2012 Nov A/P Electrical on Well #1 repair 285.00 285.00 CIRCLE R ELECTRIC CO 31980 AP
Trophy Club Municipal Utility District No. 1 87 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 27
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 11/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
387 11/30/2012 Nov A/P Well #1 Repair 59,584.00 59,869.00 MILLICAN WELL SERVICE, LLC 31986 AP
_______________
Account: 135-69280-010-000 Capital Repairs Totals: 59,869.00 59,869.00 **
270,000.00 Budgeted 210,131.00 Remaining 22 % Used
Account: 135-69281-010-000 Capital Repair-Ground Storage
259 11/18/2012 Nov A/P Annual Maint on Ground Storage 69,788.02 69,788.02 UTILITY & ENVIRONMENTAL SVCS 31939 AP
322 11/18/2012 Void A/P ck 31939/wrong vendor Annual Maint on Ground Storage (69,788.02) .00 UTILITY & ENVIRONMENTAL SVCS 31939 AP
335 11/30/2012 Nov A/P Annual Maintenance on Ground S 69,788.02 69,788.02 UTILITY SERVICE CO, INC. 31975 AP
_______________
Account: 135-69281-010-000 Capital Repair-Ground Storage Totals: 69,788.02 69,788.02 **
150,000.00 Budgeted 80,211.98 Remaining 47 % Used
Department 10 Totals: ------------------------------------------------------------------------------------------------ 499,191.96 **
3,821,430.00 Budgeted 3,322,238.04 Remaining 13 % Used
Trophy Club Municipal Utility District No. 1 88 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 28
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 11/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
442 11/07/2012 Payroll 11/7/12 9,902.13 7,161.86 17,063.99 GL
443 11/21/2012 Payroll 11/21/12 7,239.92 24,303.91 GL
445 11/21/2012 MUD Longevity 11/21/12 2,857.50 27,161.41 GL
462 11/21/2012 Recode Longevity pay (2,857.50) 24,303.91 GL
_______________
Account: 135-50005-020-000 Salaries & Wages Totals: 14,401.78 24,303.91 **
196,781.00 Budgeted 172,477.09 Remaining 12 % Used
Account: 135-50010-020-000 Overtime
442 11/07/2012 Payroll 11/7/12 791.99 445.81 1,237.80 GL
443 11/21/2012 Payroll 11/21/12 587.85 1,825.65 GL
443 11/21/2012 Payroll 11/21/12 160.00 1,985.65 GL
444 11/21/2012 Supplemental Payroll 11/21/12 168.33 2,153.98 GL
_______________
Account: 135-50010-020-000 Overtime Totals: 1,361.99 2,153.98 **
10,166.00 Budgeted 8,012.02 Remaining 21 % Used
Account: 135-50016-020-000 Longevity
462 11/21/2012 Recode Longevity pay 2,857.50 2,857.50 GL
_______________
Account: 135-50016-020-000 Longevity Totals: 2,857.50 2,857.50 **
2,858.00 Budgeted .50 Remaining 100 % Used
Account: 135-50017-020-000 Certification
442 11/07/2012 Payroll 11/7/12 350.00 350.00 700.00 GL
_______________
Account: 135-50017-020-000 Certification Totals: 350.00 700.00 **
4,200.00 Budgeted 3,500.00 Remaining 17 % Used
Account: 135-50020-020-000 Retirement
442 11/07/2012 Payroll 11/7/12 2,108.94 1,099.75 3,208.69 GL
443 11/21/2012 Payroll 11/21/12 1,103.91 4,312.60 GL
444 11/21/2012 Supplemental Payroll 11/21/12 23.26 4,335.86 GL
445 11/21/2012 MUD Longevity 11/21/12 394.91 4,730.77 GL
335 11/30/2012 Nov A/P Retirement Employer Contributi 25,023.46 29,754.23 TCDRS 31974 AP
_______________
Account: 135-50020-020-000 Retirement Totals: 27,645.29 29,754.23 **
29,821.00 Budgeted 66.77 Remaining 100 % Used
Trophy Club Municipal Utility District No. 1 89 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 29
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 11/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-50026-020-000 Medical Insurance
442 11/07/2012 Payroll 11/7/12 2,327.30 1,163.65 3,490.95 GL
443 11/21/2012 Payroll 11/21/12 1,163.65 4,654.60 GL
_______________
Account: 135-50026-020-000 Medical Insurance Totals: 2,327.30 4,654.60 **
29,034.00 Budgeted 24,379.40 Remaining 16 % Used
Account: 135-50027-020-000 Dental Insurance
442 11/07/2012 Payroll 11/7/12 175.34 87.67 263.01 GL
443 11/21/2012 Payroll 11/21/12 87.67 350.68 GL
_______________
Account: 135-50027-020-000 Dental Insurance Totals: 175.34 350.68 **
2,112.00 Budgeted 1,761.32 Remaining 17 % Used
Account: 135-50028-020-000 Vision Insurance
442 11/07/2012 Payroll 11/7/12 45.92 22.96 68.88 GL
443 11/21/2012 Payroll 11/21/12 22.96 91.84 GL
_______________
Account: 135-50028-020-000 Vision Insurance Totals: 45.92 91.84 **
552.00 Budgeted 460.16 Remaining 17 % Used
Account: 135-50029-020-000 Life Insurance & Other
442 11/07/2012 Payroll 11/7/12 155.79 155.79 GL
443 11/21/2012 Payroll 11/21/12 155.79 311.58 GL
_______________
Account: 135-50029-020-000 Life Insurance & Other Totals: 311.58 311.58 **
920.00 Budgeted 608.42 Remaining 34 % Used
Account: 135-50030-020-000 Social Security Taxes
442 11/07/2012 Payroll 11/7/12 785.74 413.19 1,198.93 GL
443 11/21/2012 Payroll 11/21/12 415.05 1,613.98 GL
444 11/21/2012 Supplemental Payroll 11/21/12 10.44 1,624.42 GL
445 11/21/2012 MUD Longevity 11/21/12 177.17 1,801.59 GL
_______________
Account: 135-50030-020-000 Social Security Taxes Totals: 1,015.85 1,801.59 **
13,268.00 Budgeted 11,466.41 Remaining 14 % Used
Account: 135-50035-020-000 Medicare Taxes
Trophy Club Municipal Utility District No. 1 90 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 30
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 11/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
442 11/07/2012 Payroll 11/7/12 183.78 96.62 280.40 GL
443 11/21/2012 Payroll 11/21/12 97.07 377.47 GL
444 11/21/2012 Supplemental Payroll 11/21/12 2.44 379.91 GL
445 11/21/2012 MUD Longevity 11/21/12 41.43 421.34 GL
_______________
Account: 135-50035-020-000 Medicare Taxes Totals: 237.56 421.34 **
3,103.00 Budgeted 2,681.66 Remaining 14 % Used
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
2,939.00 .00 2,939.00
_______________
Account: 135-50045-020-000 Workman's Compensation Totals: .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
259 11/18/2012 Nov A/P Wastewater study 5,397.50 5,397.50 THE WALLACE GROUP, INC. 31932 AP
458 11/30/2012 Wallace Group/Assigned FB (5,397.50) .00 GL
_______________
Account: 135-55070-020-000 Independent Labor Totals: .00 .00 **
1,000.00 Budgeted 1,000.00 Remaining 0 % Used
Trophy Club Municipal Utility District No. 1 91 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 31
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 11/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-55080-020-000 Maintenance & Repairs
259 11/18/2012 Nov A/P Installation of scum pump 7,624.99 672.00 8,296.99 XYLEM WATER SOLUTIONS USA INC 31943 AP
259 11/18/2012 Nov A/P Repair of 10HP pump 3,931.00 12,227.99 XYLEM WATER SOLUTIONS USA INC 31943 AP
303 11/27/2012 Nov A/P Wiring #2 Blower motor, fix Bl 1,320.00 13,547.99 PUMP SOLUTIONS INC 31962 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Richey 759.09 14,307.08 JPMORGAN CHASE BANK NA 31966 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schlielig (381.75) 13,925.33 JPMORGAN CHASE BANK NA 31966 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schlielig 3,988.00 17,913.33 JPMORGAN CHASE BANK NA 31966 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schlielig 640.05 18,553.38 JPMORGAN CHASE BANK NA 31966 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schlielig (834.95) 17,718.43 JPMORGAN CHASE BANK NA 31966 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schlielig (379.95) 17,338.48 JPMORGAN CHASE BANK NA 31966 AP
_______________
Account: 135-55080-020-000 Maintenance & Repairs Totals: 9,713.49 17,338.48 **
40,000.00 Budgeted 22,661.52 Remaining 43 % Used
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
1,080.96 .00 1,080.96
_______________
Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 1,080.96 **
1,500.00 Budgeted 419.04 Remaining 72 % Used
Account: 135-55125-020-000 Dumpster Services
259 11/18/2012 Nov A/P Sudge Haul off 1,602.04 1,602.04 CHANEY ENVIRONMENTAL 31907 AP
259 11/18/2012 Nov A/P Sludge Haul off 754.06 2,356.10 CHANEY ENVIRONMENTAL 31907 AP
303 11/27/2012 Nov A/P Sludge haul off 779.96 3,136.06 CHANEY ENVIRONMENTAL 31949 AP
335 11/30/2012 Nov A/P Sludge haul off 721.60 3,857.66 CHANEY ENVIRONMENTAL 31968 AP
_______________
Account: 135-55125-020-000 Dumpster Services Totals: 3,857.66 3,857.66 **
15,000.00 Budgeted 11,142.34 Remaining 26 % Used
Account: 135-55135-020-000 Lab Analysis
259 11/18/2012 Nov A/P Wet Chem Analysis 1,080.00 2,448.50 3,528.50 TALEM, INC 31927 AP
259 11/18/2012 Nov A/P Special Creek Sampling 50.00 3,578.50 HUTHER AND ASSOCIATES,INC 31920 AP
Trophy Club Municipal Utility District No. 1 92 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 32
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 11/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-55135-020-000 Lab Analysis Totals: 2,498.50 3,578.50 **
30,000.00 Budgeted 26,421.50 Remaining 12 % Used
Account: 135-60010-020-000 Communications/Pagers/Mobiles
259 11/18/2012 Nov A/P Oct Cells 233.69 233.69 VERIZON WIRELESS 31940 AP
_______________
Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: 233.69 233.69 **
2,700.00 Budgeted 2,466.31 Remaining 9 % Used
Account: 135-60020-020-000 Electricity
303 11/27/2012 Nov A/P Electricity 10/12-11/12 4,596.54 11,623.23 16,219.77 HUDSON ENERGY 31955 AP
_______________
Account: 135-60020-020-000 Electricity Totals: 11,623.23 16,219.77 **
153,045.00 Budgeted 136,825.23 Remaining 11 % Used
Account: 135-60066-020-000 Publications/Books/Subscripts
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schlielig 161.45 161.45 JPMORGAN CHASE BANK NA 31966 AP
_______________
Account: 135-60066-020-000 Publications/Books/Subscripts Totals: 161.45 161.45 **
500.00 Budgeted 338.55 Remaining 32 % Used
Account: 135-60080-020-000 Schools & Training
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schlielig 104.66 104.66 JPMORGAN CHASE BANK NA 31966 AP
_______________
Account: 135-60080-020-000 Schools & Training Totals: 104.66 104.66 **
3,272.00 Budgeted 3,167.34 Remaining 3 % 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
442 11/07/2012 Payroll 11/7/12 116.55 46.62 163.17 GL
443 11/21/2012 Payroll 11/21/12 186.48 349.65 GL
Trophy Club Municipal Utility District No. 1 93 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 33
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 11/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-60100-020-000 Travel & per diem Totals: 233.10 349.65 **
1,400.00 Budgeted 1,050.35 Remaining 25 % Used
Account: 135-60105-020-000 Rent/Lease Equipment
1,020.00 .00 1,020.00
_______________
Account: 135-60105-020-000 Rent/Lease Equipment Totals: .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
7,729.80 .00 7,729.80
_______________
Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 7,729.80 **
56,000.00 Budgeted 48,270.20 Remaining 14 % Used
Account: 135-60245-020-000 Miscellaneous Expenses
259 11/18/2012 Nov A/P First aid supplies 20.42 20.42 CINTAS FAS LOCKBOX 636525 31908 AP
259 11/18/2012 Nov A/P First aid supplies 36.48 56.90 CINTAS FAS LOCKBOX 636525 31908 AP
259 11/18/2012 Nov A/P First aid supplies 44.59 101.49 CINTAS FAS LOCKBOX 636525 31908 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schlielig 43.03 144.52 JPMORGAN CHASE BANK NA 31966 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schlielig 3.58 148.10 JPMORGAN CHASE BANK NA 31966 AP
_______________
Account: 135-60245-020-000 Miscellaneous Expenses Totals: 148.10 148.10 **
200.00 Budgeted 51.90 Remaining 74 % 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
Trophy Club Municipal Utility District No. 1 94 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 34
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 11/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-65005-020-000 Fuel & Lube
323 11/28/2012 October Gas Log 1,056.42 1,056.42 GL
393 11/30/2012 Nov Gas Purchases 852.32 1,908.74 GL
_______________
Account: 135-65005-020-000 Fuel & Lube Totals: 1,908.74 1,908.74 **
8,527.00 Budgeted 6,618.26 Remaining 22 % Used
Account: 135-65010-020-000 Uniforms
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Richey 183.99 183.99 JPMORGAN CHASE BANK NA 31966 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Richey 174.24 358.23 JPMORGAN CHASE BANK NA 31966 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schlielig 132.00 490.23 JPMORGAN CHASE BANK NA 31966 AP
_______________
Account: 135-65010-020-000 Uniforms Totals: 490.23 490.23 **
2,574.00 Budgeted 2,083.77 Remaining 19 % Used
Account: 135-65030-020-000 Chemicals
303 11/27/2012 Nov A/P 12 100# Granular HTH Pails 6,248.30 1,680.00 7,928.30 HARCROS CHEMICALS INC 31954 AP
335 11/30/2012 Nov A/P Drum Clarifloc 540.00 8,468.30 POLYDYNE, INC 31973 AP
_______________
Account: 135-65030-020-000 Chemicals Totals: 2,220.00 8,468.30 **
10,000.00 Budgeted 1,531.70 Remaining 85 % Used
Account: 135-65035-020-000 Small Tools
259 11/18/2012 Nov A/P Tool Kits 20.00 20.00 TEXAS FACILITIES COMMISSION 31929 AP
259 11/18/2012 Nov A/P Tool Kits 50.00 70.00 TEXAS FACILITIES COMMISSION 31929 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schlielig 65.09 135.09 JPMORGAN CHASE BANK NA 31966 AP
_______________
Account: 135-65035-020-000 Small Tools Totals: 135.09 135.09 **
1,000.00 Budgeted 864.91 Remaining 14 % 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
335 11/30/2012 Nov A/P Water for lab 3,855.26 47.91 3,903.17 OZARKA DIRECT 31972 AP
Trophy Club Municipal Utility District No. 1 95 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 35
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 11/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
_______________
Account: 135-65045-020-000 Lab Supplies Totals: 47.91 3,903.17 **
10,000.00 Budgeted 6,096.83 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: ------------------------------------------------------------------------------------------------ 137,068.50 **
1,039,428.00 Budgeted 902,359.50 Remaining 13 % Used
Trophy Club Municipal Utility District No. 1 96 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 36
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 21 Collection Program:
Period Ending: 11/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
442 11/07/2012 Payroll 11/7/12 8,176.21 5,822.74 13,998.95 GL
443 11/21/2012 Payroll 11/21/12 5,626.88 19,625.83 GL
445 11/21/2012 MUD Longevity 11/21/12 3,817.50 23,443.33 GL
462 11/21/2012 Recode Longevity pay (3,817.50) 19,625.83 GL
_______________
Account: 135-50005-021-000 Salaries & Wages Totals: 11,449.62 19,625.83 **
156,475.00 Budgeted 136,849.17 Remaining 13 % Used
Account: 135-50010-021-000 Overtime
442 11/07/2012 Payroll 11/7/12 598.89 264.65 863.54 GL
442 11/07/2012 Payroll 11/7/12 160.00 1,023.54 GL
443 11/21/2012 Payroll 11/21/12 160.00 1,183.54 GL
_______________
Account: 135-50010-021-000 Overtime Totals: 584.65 1,183.54 **
7,297.00 Budgeted 6,113.46 Remaining 16 % Used
Account: 135-50016-021-000 Longevity
462 11/21/2012 Recode Longevity pay 3,817.50 3,817.50 GL
_______________
Account: 135-50016-021-000 Longevity Totals: 3,817.50 3,817.50 **
3,818.00 Budgeted .50 Remaining 100 % Used
Account: 135-50017-021-000 Certification
442 11/07/2012 Payroll 11/7/12 150.00 150.00 300.00 GL
_______________
Account: 135-50017-021-000 Certification Totals: 150.00 300.00 **
1,800.00 Budgeted 1,500.00 Remaining 17 % Used
Account: 135-50020-021-000 Retirement
442 11/07/2012 Payroll 11/7/12 1,697.63 884.13 2,581.76 GL
443 11/21/2012 Payroll 11/21/12 799.75 3,381.51 GL
445 11/21/2012 MUD Longevity 11/21/12 527.58 3,909.09 GL
335 11/30/2012 Nov A/P Retirement Employer Contributi 19,336.31 23,245.40 TCDRS 31974 AP
_______________
Account: 135-50020-021-000 Retirement Totals: 21,547.77 23,245.40 **
23,574.00 Budgeted 328.60 Remaining 99 % Used
Account: 135-50026-021-000 Medical Insurance
Trophy Club Municipal Utility District No. 1 97 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 37
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 21 Collection Program:
Period Ending: 11/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
442 11/07/2012 Payroll 11/7/12 1,683.08 841.54 2,524.62 GL
443 11/21/2012 Payroll 11/21/12 841.54 3,366.16 GL
_______________
Account: 135-50026-021-000 Medical Insurance Totals: 1,683.08 3,366.16 **
20,198.00 Budgeted 16,831.84 Remaining 17 % Used
Account: 135-50027-021-000 Dental Insurance
442 11/07/2012 Payroll 11/7/12 124.48 62.24 186.72 GL
443 11/21/2012 Payroll 11/21/12 62.24 248.96 GL
_______________
Account: 135-50027-021-000 Dental Insurance Totals: 124.48 248.96 **
1,409.00 Budgeted 1,160.04 Remaining 18 % Used
Account: 135-50028-021-000 Vision Insurance
442 11/07/2012 Payroll 11/7/12 29.72 14.86 44.58 GL
443 11/21/2012 Payroll 11/21/12 14.86 59.44 GL
_______________
Account: 135-50028-021-000 Vision Insurance Totals: 29.72 59.44 **
357.00 Budgeted 297.56 Remaining 17 % Used
Account: 135-50029-021-000 Life Insurance & Other
442 11/07/2012 Payroll 11/7/12 119.34 119.34 GL
443 11/21/2012 Payroll 11/21/12 119.34 238.68 GL
_______________
Account: 135-50029-021-000 Life Insurance & Other Totals: 238.68 238.68 **
1,008.00 Budgeted 769.32 Remaining 24 % Used
Account: 135-50030-021-000 Social Security Taxes
442 11/07/2012 Payroll 11/7/12 707.03 369.36 1,076.39 GL
443 11/21/2012 Payroll 11/21/12 331.50 1,407.89 GL
445 11/21/2012 MUD Longevity 11/21/12 236.69 1,644.58 GL
_______________
Account: 135-50030-021-000 Social Security Taxes Totals: 937.55 1,644.58 **
10,502.00 Budgeted 8,857.42 Remaining 16 % Used
Account: 135-50035-021-000 Medicare Taxes
442 11/07/2012 Payroll 11/7/12 165.35 86.38 251.73 GL
443 11/21/2012 Payroll 11/21/12 77.53 329.26 GL
Trophy Club Municipal Utility District No. 1 98 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 38
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 21 Collection Program:
Period Ending: 11/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
445 11/21/2012 MUD Longevity 11/21/12 165.35 55.35 384.61 GL
_______________
Account: 135-50035-021-000 Medicare Taxes Totals: 219.26 384.61 **
2,456.00 Budgeted 2,071.39 Remaining 16 % Used
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
3,348.00 .00 3,348.00
_______________
Account: 135-50045-021-000 Workman's Compensation Totals: .00 3,348.00 **
3,348.00 Budgeted .00 Remaining 100 % Used
Account: 135-50070-021-000 Employee Relations
309 11/27/2012 Nov A/P 10/6-11/5 PCards/Slaght 16.78 16.78 JPMORGAN CHASE BANK NA 31966 AP
_______________
Account: 135-50070-021-000 Employee Relations Totals: 16.78 16.78 **
250.00 Budgeted 233.22 Remaining 7 % Used
Account: 135-55005-021-000 Engineering
259 11/18/2012 Nov A/P Marshall Creek Sanitary Sewer 2,450.00 2,450.00 DELTATEK ENGINEERING 31910 AP
_______________
Account: 135-55005-021-000 Engineering Totals: 2,450.00 2,450.00 **
1,500.00 Budgeted (950.00) Remaining 163 % Used
Account: 135-55080-021-000 Maintenance & Repairs
168.50 .00 168.50
_______________
Account: 135-55080-021-000 Maintenance & Repairs Totals: .00 168.50 **
35,000.00 Budgeted 34,831.50 Remaining 0 % Used
Account: 135-55090-021-000 Vehicle Maintenance
.00 .00
Trophy Club Municipal Utility District No. 1 99 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 39
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 21 Collection Program:
Period Ending: 11/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
_______________
Account: 135-55090-021-000 Vehicle Maintenance Totals: .00 .00 **
1,900.00 Budgeted 1,900.00 Remaining 0 % Used
Account: 135-60010-021-000 Communications/Pagers/Mobiles
259 11/18/2012 Nov A/P Oct Cells 217.50 217.50 VERIZON WIRELESS 31940 AP
_______________
Account: 135-60010-021-000 Communications/Pagers/Mobiles Totals: 217.50 217.50 **
3,500.00 Budgeted 3,282.50 Remaining 6 % Used
Account: 135-60020-021-000 Electricity
259 11/18/2012 Nov A/P Electricity 9/28-10/29 332.87 276.31 609.18 TRI COUNTY ELECTRIC 31935 AP
259 11/18/2012 Nov A/P Electricity 9/28-10/29 154.25 763.43 TRI COUNTY ELECTRIC 31935 AP
259 11/18/2012 Nov A/P Electricity 9/28-10/29 27.74 791.17 TRI COUNTY ELECTRIC 31935 AP
259 11/18/2012 Nov A/P Electricity 10/10-11/12 654.81 1,445.98 HUDSON ENERGY 31919 AP
259 11/18/2012 Nov A/P Electricity 10/11-11/9 50.02 1,496.00 HUDSON ENERGY 31919 AP
303 11/27/2012 Nov A/P Electricity 10/12-11/12 192.65 1,688.65 HUDSON ENERGY 31955 AP
_______________
Account: 135-60020-021-000 Electricity Totals: 1,355.78 1,688.65 **
18,705.00 Budgeted 17,016.35 Remaining 9 % Used
Account: 135-60070-021-000 Dues & Memberships
309 11/27/2012 Nov A/P 10/6-11/5 PCards/Slaght 111.00 111.00 JPMORGAN CHASE BANK NA 31966 AP
_______________
Account: 135-60070-021-000 Dues & Memberships Totals: 111.00 111.00 **
250.00 Budgeted 139.00 Remaining 44 % Used
Account: 135-60080-021-000 Schools & Training
309 11/27/2012 Nov A/P 10/6-11/5 PCards/Slaght 90.00 240.00 330.00 JPMORGAN CHASE BANK NA 31966 AP
_______________
Account: 135-60080-021-000 Schools & Training Totals: 240.00 330.00 **
826.00 Budgeted 496.00 Remaining 40 % 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
Trophy Club Municipal Utility District No. 1 100 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 40
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 21 Collection Program:
Period Ending: 11/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-60100-021-000 Travel & per diem
442 11/07/2012 Payroll 11/7/12 19.43 67.71 87.14 GL
_______________
Account: 135-60100-021-000 Travel & per diem Totals: 67.71 87.14 **
450.00 Budgeted 362.86 Remaining 19 % Used
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
323 11/28/2012 October Gas Log 1,112.12 1,112.12 GL
393 11/30/2012 Nov Gas Purchases 722.69 1,834.81 GL
_______________
Account: 135-65005-021-000 Fuel & Lube Totals: 1,834.81 1,834.81 **
12,117.00 Budgeted 10,282.19 Remaining 15 % Used
Account: 135-65010-021-000 Uniforms
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Womack 507.22 507.22 JPMORGAN CHASE BANK NA 31966 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Womack 307.86 815.08 JPMORGAN CHASE BANK NA 31966 AP
_______________
Account: 135-65010-021-000 Uniforms Totals: 815.08 815.08 **
2,220.00 Budgeted 1,404.92 Remaining 37 % 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
Trophy Club Municipal Utility District No. 1 101 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 41
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 21 Collection Program:
Period Ending: 11/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-65035-021-000 Small Tools
259 11/18/2012 Nov A/P Tool Kits 70.00 70.00 TEXAS FACILITIES COMMISSION 31929 AP
_______________
Account: 135-65035-021-000 Small Tools Totals: 70.00 70.00 **
1,500.00 Budgeted 1,430.00 Remaining 5 % Used
Account: 135-65040-021-000 Safety Equipment
.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: ------------------------------------------------------------------------------------------------ 65,252.16 **
459,887.00 Budgeted 394,634.84 Remaining 14 % Used
Trophy Club Municipal Utility District No. 1 102 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 42
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program:
Period Ending: 11/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
442 11/07/2012 Payroll 11/7/12 500.00 900.00 1,400.00 GL
_______________
Account: 135-50005-026-000 Salaries & Wages Totals: 900.00 1,400.00 **
10,000.00 Budgeted 8,600.00 Remaining 14 % Used
Account: 135-50030-026-000 Social Security Taxes
442 11/07/2012 Payroll 11/7/12 31.00 55.80 86.80 GL
_______________
Account: 135-50030-026-000 Social Security Taxes Totals: 55.80 86.80 **
620.00 Budgeted 533.20 Remaining 14 % Used
Account: 135-50035-026-000 Medicare Taxes
442 11/07/2012 Payroll 11/7/12 7.25 13.05 20.30 GL
_______________
Account: 135-50035-026-000 Medicare Taxes Totals: 13.05 20.30 **
145.00 Budgeted 124.70 Remaining 14 % Used
Account: 135-50040-026-000 Unemployment Taxes
442 11/07/2012 Payroll 11/7/12 14.50 26.10 40.60 GL
_______________
Account: 135-50040-026-000 Unemployment Taxes Totals: 26.10 40.60 **
210.00 Budgeted 169.40 Remaining 19 % 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 103 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 43
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program:
Period Ending: 11/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
309 11/27/2012 Nov A/P 10/6-11/5 PCards/Slaght 22.00 44.00 66.00 JPMORGAN CHASE BANK NA 31966 AP
_______________
Account: 135-60075-026-000 Meetings Totals: 44.00 66.00 **
1,200.00 Budgeted 1,134.00 Remaining 6 % Used
Account: 135-60080-026-000 Schools & Training
259 11/18/2012 Nov A/P AWBD Winter Conf-Sanders 265.00 265.00 AWBD 31906 AP
259 11/18/2012 Nov A/P AWBD Winter Conf-Carr 315.00 580.00 AWBD 31906 AP
_______________
Account: 135-60080-026-000 Schools & Training Totals: 580.00 580.00 **
4,000.00 Budgeted 3,420.00 Remaining 15 % 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: ------------------------------------------------------------------------------------------------ 2,193.70 **
26,575.00 Budgeted 24,381.30 Remaining 8 % Used
Trophy Club Municipal Utility District No. 1 104 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 44
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 11/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
442 11/07/2012 Payroll 11/7/12 25,870.34 16,964.89 42,835.23 GL
443 11/21/2012 Payroll 11/21/12 16,898.06 59,733.29 GL
445 11/21/2012 MUD Longevity 11/21/12 2,317.50 62,050.79 GL
462 11/21/2012 Recode Longevity pay (2,317.50) 59,733.29 GL
_______________
Account: 135-50005-030-000 Salaries & Wages Totals: 33,862.95 59,733.29 **
444,730.00 Budgeted 384,996.71 Remaining 13 % Used
Account: 135-50010-030-000 Overtime
442 11/07/2012 Payroll 11/7/12 8.94 40.37 49.31 GL
_______________
Account: 135-50010-030-000 Overtime Totals: 40.37 49.31 **
1,500.00 Budgeted 1,450.69 Remaining 3 % Used
Account: 135-50016-030-000 Longevity
462 11/21/2012 Recode Longevity pay 2,317.50 2,317.50 GL
_______________
Account: 135-50016-030-000 Longevity Totals: 2,317.50 2,317.50 **
2,193.00 Budgeted (124.50) Remaining 106 % Used
Account: 135-50020-030-000 Retirement
442 11/07/2012 Payroll 11/7/12 4,525.48 2,275.44 6,800.92 GL
443 11/21/2012 Payroll 11/21/12 2,249.48 9,050.40 GL
445 11/21/2012 MUD Longevity 11/21/12 320.29 9,370.69 GL
335 11/30/2012 Nov A/P Retirement Employer Contributi 44,359.77 53,730.46 TCDRS 31974 AP
_______________
Account: 135-50020-030-000 Retirement Totals: 49,204.98 53,730.46 **
60,441.00 Budgeted 6,710.54 Remaining 89 % Used
Account: 135-50026-030-000 Medical Insurance
442 11/07/2012 Payroll 11/7/12 3,185.30 1,592.65 4,777.95 GL
443 11/21/2012 Payroll 11/21/12 1,592.65 6,370.60 GL
_______________
Account: 135-50026-030-000 Medical Insurance Totals: 3,185.30 6,370.60 **
44,066.00 Budgeted 37,695.40 Remaining 14 % Used
Account: 135-50027-030-000 Dental Insurance
Trophy Club Municipal Utility District No. 1 105 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 45
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 11/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
442 11/07/2012 Payroll 11/7/12 288.72 144.36 433.08 GL
443 11/21/2012 Payroll 11/21/12 144.36 577.44 GL
_______________
Account: 135-50027-030-000 Dental Insurance Totals: 288.72 577.44 **
3,379.00 Budgeted 2,801.56 Remaining 17 % Used
Account: 135-50028-030-000 Vision Insurance
442 11/07/2012 Payroll 11/7/12 66.20 33.10 99.30 GL
443 11/21/2012 Payroll 11/21/12 33.10 132.40 GL
_______________
Account: 135-50028-030-000 Vision Insurance Totals: 66.20 132.40 **
795.00 Budgeted 662.60 Remaining 17 % Used
Account: 135-50029-030-000 Life Insurance & Other
442 11/07/2012 Payroll 11/7/12 292.46 292.46 GL
443 11/21/2012 Payroll 11/21/12 292.46 584.92 GL
_______________
Account: 135-50029-030-000 Life Insurance & Other Totals: 584.92 584.92 **
2,500.00 Budgeted 1,915.08 Remaining 23 % Used
Account: 135-50030-030-000 Social Security Taxes
442 11/07/2012 Payroll 11/7/12 1,937.42 970.27 2,907.69 GL
443 11/21/2012 Payroll 11/21/12 963.63 3,871.32 GL
445 11/21/2012 MUD Longevity 11/21/12 143.69 4,015.01 GL
_______________
Account: 135-50030-030-000 Social Security Taxes Totals: 2,077.59 4,015.01 **
27,802.00 Budgeted 23,786.99 Remaining 14 % Used
Account: 135-50035-030-000 Medicare Taxes
442 11/07/2012 Payroll 11/7/12 453.11 226.92 680.03 GL
443 11/21/2012 Payroll 11/21/12 225.36 905.39 GL
445 11/21/2012 MUD Longevity 11/21/12 33.60 938.99 GL
_______________
Account: 135-50035-030-000 Medicare Taxes Totals: 485.88 938.99 **
6,502.00 Budgeted 5,563.01 Remaining 14 % Used
Account: 135-50040-030-000 Unemployment Taxes
442 11/07/2012 Payroll 11/7/12 195.84 93.76 289.60 GL
Trophy Club Municipal Utility District No. 1 106 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 46
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 11/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
443 11/21/2012 Payroll 11/21/12 195.84 40.32 329.92 GL
_______________
Account: 135-50040-030-000 Unemployment Taxes Totals: 134.08 329.92 **
1,537.00 Budgeted 1,207.08 Remaining 21 % Used
Account: 135-50045-030-000 Workman's Compensation
831.00 .00 831.00
_______________
Account: 135-50045-030-000 Workman's Compensation Totals: .00 831.00 **
831.00 Budgeted .00 Remaining 100 % Used
Account: 135-50060-030-000 Pre-emp Physicals/Testing
259 11/18/2012 Nov A/P Pre employment testing/T Sisk 35.00 4.00 39.00 FIRST CHECK APPLICANT SCREENIN 31914 AP
_______________
Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: 4.00 39.00 **
250.00 Budgeted 211.00 Remaining 16 % 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
259 11/18/2012 Nov A/P Annual Support-Attendance Ente 2,961.75 1,176.50 4,138.25 ASSOC TIME & PARKING CONTROLS 31905 AP
259 11/18/2012 Nov A/P OSSI Apps 374.88 4,513.13 SUNGARD PUBLIC SECTOR INC 31926 AP
303 11/27/2012 Nov A/P Annual Maintenance-Fuel Master 1,152.38 5,665.51 SYN-TECH SYSTEMS, INC 31964 AP
303 11/27/2012 Nov A/P Badger annual maint 450.00 6,115.51 BADGER METER, INC 31948 AP
303 11/27/2012 Nov A/P Annual Firewall maint 1,095.00 7,210.51 ACCLAIM NETWORKS LLC 31944 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Gonzales 302.75 7,513.26 JPMORGAN CHASE BANK NA 31966 AP
387 11/30/2012 Nov A/P 10/30-11/27 PCards-Pastor 35.94 7,549.20 BANK OF AMERICA 31979 AP
387 11/30/2012 Nov A/P 10/30-11/27 PCards-Pastor 69.99 7,619.19 BANK OF AMERICA 31979 AP
387 11/30/2012 Nov A/P 10/30-11/27 PCards-Pastor 79.68 7,698.87 BANK OF AMERICA 31979 AP
387 11/30/2012 Nov A/P 10/30-11/27 PCards-Pastor 25.00 7,723.87 BANK OF AMERICA 31979 AP
387 11/30/2012 Nov A/P 10/30-11/27/12 PCards-Zieverin 53.38 7,777.25 BANK OF AMERICA 31979 AP
387 11/30/2012 Nov A/P 10/30-11/27/12 PCards-Zieverin 55.37 7,832.62 BANK OF AMERICA 31979 AP
387 11/30/2012 Nov A/P Annual backup maintenance 659.40 8,492.02 SHI GOVERNMENT SOLUTIONS,INC 31991 AP
_______________
Account: 135-55030-030-000 Software & Support Totals: 5,530.27 8,492.02 **
63,555.00 Budgeted 55,062.98 Remaining 13 % Used
Trophy Club Municipal Utility District No. 1 107 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 47
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 11/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-55070-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
Account: 135-55080-030-000 Maintenance & Repairs
303 11/27/2012 Nov A/P Annual Service Fire extinguish 74.75 74.75 KIMBROUGH FIRE EXTINQUISHER CO 31956 AP
311 11/27/2012 Void Ck 31956/Reissue to Town Annual Service Fire extinguish (74.75) .00 KIMBROUGH FIRE EXTINQUISHER CO 31956 AP
_______________
Account: 135-55080-030-000 Maintenance & Repairs Totals: .00 .00 **
.00 Budgeted .00 Remaining 0 % Used
Account: 135-55100-030-000 Building Maint & Supplies
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Womack 32.36 3.97 36.33 JPMORGAN CHASE BANK NA 31966 AP
387 11/30/2012 Nov A/P 10/30-11/27/12 PCards-Zieverin 43.95 80.28 BANK OF AMERICA 31979 AP
387 11/30/2012 Nov A/P Zoned Duct work, Thermostat, T 1,428.00 1,508.28 NORTH TX HEATING & AIR, INC 31988 AP
_______________
Account: 135-55100-030-000 Building Maint & Supplies Totals: 1,475.92 1,508.28 **
5,000.00 Budgeted 3,491.72 Remaining 30 % Used
Account: 135-55120-030-000 Cleaning Services
259 11/18/2012 Nov A/P Nov Janitorial Services 1,678.51 1,678.51 3,357.02 ABM JANITORIAL SERVICES, INC 31904 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards/Slaght 133.66 3,490.68 JPMORGAN CHASE BANK NA 31966 AP
_______________
Account: 135-55120-030-000 Cleaning Services Totals: 1,812.17 3,490.68 **
20,200.00 Budgeted 16,709.32 Remaining 17 % Used
Account: 135-55160-030-000 Professional Outside Services
259 11/18/2012 Nov A/P Website Development 1,875.00 1,875.00 FOUR MAN FURNACE, INC. 31915 AP
303 11/27/2012 Nov A/P Website 4,950.00 6,825.00 FOUR MAN FURNACE, INC. 31953 AP
Trophy Club Municipal Utility District No. 1 108 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 48
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 11/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
_______________
Account: 135-55160-030-000 Professional Outside Services Totals: 6,825.00 6,825.00 **
15,000.00 Budgeted 8,175.00 Remaining 46 % 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
159.77 .00 159.77
_______________
Account: 135-55165-030-000 Collection Fees Totals: .00 159.77 **
.00 Budgeted (159.77) Remaining 0 % Used
Account: 135-55205-030-000 Utility Billing Contract
303 11/27/2012 Nov A/P October Utility bills 648.53 648.53 DP2 BILLING SOLUTIONS, LLC 31952 AP
335 11/30/2012 Nov A/P Final bill/Printing & mailing 918.75 1,567.28 CSG SYSTEMS, INC. 31969 AP
_______________
Account: 135-55205-030-000 Utility Billing Contract Totals: 1,567.28 1,567.28 **
11,000.00 Budgeted 9,432.72 Remaining 14 % Used
Account: 135-60005-030-000 Telephone
387 11/30/2012 Nov A/P 10/30-11/27/12 PCards-Zieverin 1,339.34 377.76 1,717.10 BANK OF AMERICA 31979 AP
_______________
Account: 135-60005-030-000 Telephone Totals: 377.76 1,717.10 **
9,000.00 Budgeted 7,282.90 Remaining 19 % Used
Account: 135-60010-030-000 Communications/Pagers/Mobiles
442 11/07/2012 Payroll 11/7/12 150.00 150.00 300.00 GL
259 11/18/2012 Nov A/P Oct Cells 177.04 477.04 VERIZON WIRELESS 31940 AP
_______________
Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 327.04 477.04 **
3,575.00 Budgeted 3,097.96 Remaining 13 % Used
Account: 135-60020-030-000 Electricity/Gas
Trophy Club Municipal Utility District No. 1 109 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 49
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 11/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
259 11/18/2012 Nov A/P Electricity 942.99 942.99 DIRECT ENERGY BUSINESS SVCS 31912 AP
_______________
Account: 135-60020-030-000 Electricity/Gas Totals: 942.99 942.99 **
13,019.00 Budgeted 12,076.01 Remaining 7 % Used
Account: 135-60025-030-000 Water
259 11/18/2012 Nov A/P Water/October 125.06 125.06 TROPHY CLUB MUD (WATER BILLS) 31936 AP
_______________
Account: 135-60025-030-000 Water Totals: 125.06 125.06 **
3,100.00 Budgeted 2,974.94 Remaining 4 % Used
Account: 135-60030-030-000 Rent And/Or Usage
303 11/27/2012 Nov A/P October Public Services buildi 1,098.51 1,098.51 TOWN OF TROPHY CLUB 31965 AP
303 11/27/2012 Nov A/P November Public Services buili 1,098.51 2,197.02 TOWN OF TROPHY CLUB 31965 AP
_______________
Account: 135-60030-030-000 Rent And/Or Usage Totals: 2,197.02 2,197.02 **
13,182.00 Budgeted 10,984.98 Remaining 17 % Used
Account: 135-60035-030-000 Postage
303 11/27/2012 Nov A/P Postage meter lease 652.66 157.50 810.16 PITNEY BOWES INC 31961 AP
303 11/27/2012 Nov A/P October Utility bills 1,761.03 2,571.19 DP2 BILLING SOLUTIONS, LLC 31952 AP
335 11/30/2012 Nov A/P Final bill/Printing & mailing 1,429.46 4,000.65 CSG SYSTEMS, INC. 31969 AP
387 11/30/2012 Nov A/P 10/30-11/27/12 PCards-Zieverin 12.17 4,012.82 BANK OF AMERICA 31979 AP
289 11/30/2012 November postage used 397.44 4,410.26 GL
_______________
Account: 135-60035-030-000 Postage Totals: 3,757.60 4,410.26 **
23,000.00 Budgeted 18,589.74 Remaining 19 % Used
Account: 135-60040-030-000 Service Charges & Fees
378 11/02/2012 Credit Card & Online fees 2,750.83 73.71 2,824.54 GL
378 11/02/2012 Credit Card & Online fees 75.10 2,899.64 GL
378 11/02/2012 Credit Card & Online fees 2,231.82 5,131.46 GL
452 11/13/2012 FF Account Analysis/Oct 250.00 5,381.46 GL
_______________
Account: 135-60040-030-000 Service Charges & Fees Totals: 2,630.63 5,381.46 **
18,000.00 Budgeted 12,618.54 Remaining 30 % Used
Account: 135-60050-030-000 Bad Debt Expense
Trophy Club Municipal Utility District No. 1 110 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 50
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 11/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
(1,056.53) .00 (1,056.53)
_______________
Account: 135-60050-030-000 Bad Debt Expense Totals: .00 (1,056.53) **
8,500.00 Budgeted 9,556.53 Remaining -12 % Used
Account: 135-60055-030-000 Insurance
387 11/30/2012 Nov A/P Additional premium due to rera 34,065.48 26,536.44 60,601.92 TML INTERGOVERNMENTAL RISK 31992 AP
_______________
Account: 135-60055-030-000 Insurance Totals: 26,536.44 60,601.92 **
35,000.00 Budgeted (25,601.92) Remaining 173 % Used
Account: 135-60066-030-000 Publications/Books/Subscripts
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Gonzales 449.22 109.00 558.22 JPMORGAN CHASE BANK NA 31966 AP
_______________
Account: 135-60066-030-000 Publications/Books/Subscripts Totals: 109.00 558.22 **
750.00 Budgeted 191.78 Remaining 74 % Used
Account: 135-60070-030-000 Dues & Memberships
259 11/18/2012 Nov A/P Annual Dues 100.00 550.00 650.00 AWBD 31906 AP
303 11/27/2012 Nov A/P Balance due Notary bonds 33.07 683.07 CNA SURETY 31950 AP
358 11/27/2012 Void A/P Ck 31950/CNA Surety Balance due Notary bonds (33.07) 650.00 CNA SURETY 31950 AP
_______________
Account: 135-60070-030-000 Dues & Memberships Totals: 550.00 650.00 **
2,400.00 Budgeted 1,750.00 Remaining 27 % Used
Account: 135-60075-030-000 Meetings
88.00 .00 88.00
_______________
Account: 135-60075-030-000 Meetings Totals: .00 88.00 **
250.00 Budgeted 162.00 Remaining 35 % Used
Account: 135-60080-030-000 Schools & Training
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schultz 450.00 450.00 JPMORGAN CHASE BANK NA 31966 AP
_______________
Account: 135-60080-030-000 Schools & Training Totals: 450.00 450.00 **
5,500.00 Budgeted 5,050.00 Remaining 8 % Used
Account: 135-60100-030-000 Travel & per diem
Trophy Club Municipal Utility District No. 1 111 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 51
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 11/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
443 11/21/2012 Payroll 11/21/12 10.05 23.31 33.36 GL
309 11/27/2012 Nov A/P 10/6-11/5 PCards McKnight 16.24 49.60 JPMORGAN CHASE BANK NA 31966 AP
_______________
Account: 135-60100-030-000 Travel & per diem Totals: 39.55 49.60 **
3,950.00 Budgeted 3,900.40 Remaining 1 % 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
321 11/28/2012 Recode 2010 Encana Accrual 13.00 109.13 122.13 GL
_______________
Account: 135-60245-030-000 Miscellaneous Expenses Totals: 109.13 122.13 **
15,000.00 Budgeted 14,877.87 Remaining 1 % Used
Account: 135-60270-030-000 4th of July Celebration
.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
Trophy Club Municipal Utility District No. 1 112 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 52
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 11/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
265.00 .00 265.00
_______________
Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 265.00 **
2,500.00 Budgeted 2,235.00 Remaining 11 % Used
Account: 135-65010-030-000 Uniforms
259 11/18/2012 Nov A/P Uniform shirts/Admin 624.12 624.12 RON MONTGOMERY & ASSOC INC 31924 AP
_______________
Account: 135-65010-030-000 Uniforms Totals: 624.12 624.12 **
1,635.00 Budgeted 1,010.88 Remaining 38 % Used
Account: 135-65055-030-000 Hardware
303 11/27/2012 Nov A/P Projector lamp 5,738.89 160.50 5,899.39 SHI GOVERNMENT SOLUTIONS,INC 31963 AP
303 11/27/2012 Nov A/P USB drives 42.00 5,941.39 SHI GOVERNMENT SOLUTIONS,INC 31963 AP
387 11/30/2012 Nov A/P 10/30-11/27 PCards-Pastor 85.80 6,027.19 BANK OF AMERICA 31979 AP
387 11/30/2012 Nov A/P 10/30-11/27 PCards-Pastor (111.37) 5,915.82 BANK OF AMERICA 31979 AP
387 11/30/2012 Nov A/P 10/30-11/27 PCards-Pastor (74.25) 5,841.57 BANK OF AMERICA 31979 AP
387 11/30/2012 Nov A/P 10/30-11/27 PCards-Pastor 7.48 5,849.05 BANK OF AMERICA 31979 AP
387 11/30/2012 Nov A/P 10/30-11/27 PCards-Pastor 47.82 5,896.87 BANK OF AMERICA 31979 AP
387 11/30/2012 Nov A/P 10/30-11/27 PCards-Pastor 128.95 6,025.82 BANK OF AMERICA 31979 AP
387 11/30/2012 Nov A/P 10/30-11/27/12 PCards-Zieverin 50.97 6,076.79 BANK OF AMERICA 31979 AP
387 11/30/2012 Nov A/P 10/30-11/27/12 PCards-Zieverin 119.99 6,196.78 BANK OF AMERICA 31979 AP
387 11/30/2012 Nov A/P 2TB portable hard drive 91.49 6,288.27 NEWEGG.COM 31987 AP
_______________
Account: 135-65055-030-000 Hardware Totals: 549.38 6,288.27 **
20,188.00 Budgeted 13,899.73 Remaining 31 % Used
Account: 135-65085-030-000 Office Supplies
259 11/18/2012 Nov A/P Postcards for leak report 816.15 402.75 1,218.90 DESKTOP PUBLISHING SUPPLIES 31911 AP
303 11/27/2012 Nov A/P Office Supplies 74.22 1,293.12 OFFICE DEPOT, INC 31960 AP
303 11/27/2012 Nov A/P Office Supplies 53.55 1,346.67 OFFICE DEPOT, INC 31960 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schlielig 53.94 1,400.61 JPMORGAN CHASE BANK NA 31966 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schultz 316.50 1,717.11 JPMORGAN CHASE BANK NA 31966 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schultz 52.12 1,769.23 JPMORGAN CHASE BANK NA 31966 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schultz 2.93 1,772.16 JPMORGAN CHASE BANK NA 31966 AP
335 11/30/2012 Nov A/P Office Supplies 80.46 1,852.62 OFFICE DEPOT, INC 31971 AP
_______________
Account: 135-65085-030-000 Office Supplies Totals: 1,036.47 1,852.62 **
8,200.00 Budgeted 6,347.38 Remaining 23 % Used
Trophy Club Municipal Utility District No. 1 113 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 53
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 11/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-65090-030-000 Printer Supplies & Maintenance
259 11/18/2012 Nov A/P Printer supplies 226.00 285.00 511.00 SHI GOVERNMENT SOLUTIONS,INC 31925 AP
_______________
Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 285.00 511.00 **
5,732.00 Budgeted 5,221.00 Remaining 9 % Used
Account: 135-65095-030-000 Maintenance Supplies
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Huggins 49.18 49.18 JPMORGAN CHASE BANK NA 31966 AP
309 11/27/2012 Nov A/P 10/6-11/5 PCards-Schultz 48.22 97.40 JPMORGAN CHASE BANK NA 31966 AP
_______________
Account: 135-65095-030-000 Maintenance Supplies Totals: 97.40 97.40 **
2,000.00 Budgeted 1,902.60 Remaining 5 % 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
259 11/18/2012 Nov A/P Magnets 395.00 395.00 CRESTVIEW PRINTING INC 31909 AP
_______________
Account: 135-65105-030-000 Printing Totals: 395.00 395.00 **
5,200.00 Budgeted 4,805.00 Remaining 8 % Used
Account: 135-69170-030-000 Copier Lease Installments
303 11/27/2012 Nov A/P Copier lease 256.85 256.85 513.70 KYOCERA MITA AMERICA, INC. 31957 AP
_______________
Account: 135-69170-030-000 Copier Lease Installments Totals: 256.85 513.70 **
3,450.00 Budgeted 2,936.30 Remaining 15 % Used
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
Trophy Club Municipal Utility District No. 1 114 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 54
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 11/2012
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Department 30 Totals: ------------------------------------------------------------------------------------------------ 238,954.25 **
1,051,838.00 Budgeted 812,883.75 Remaining 23 % Used
Trophy Club Municipal Utility District No. 1 115 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 55
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program:
Period Ending: 11/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
259 11/18/2012 Nov A/P October legal 1,634.75 1,634.75 WHITAKER CHALK SWINDLE 31942 AP
259 11/18/2012 Nov A/P October legal 4,134.00 5,768.75 THE LISTON LAW FIRM, P.C. 31930 AP
_______________
Account: 135-55045-039-000 Legal Totals: 5,768.75 5,768.75 **
70,000.00 Budgeted 64,231.25 Remaining 8 % Used
Account: 135-55055-039-000 Auditing
259 11/18/2012 Nov A/P Interim audit fieldwork 5,175.00 5,175.00 LAFOLLETT & COMPANY PLLC 31921 AP
_______________
Account: 135-55055-039-000 Auditing Totals: 5,175.00 5,175.00 **
21,200.00 Budgeted 16,025.00 Remaining 24 % Used
Account: 135-55060-039-000 Appraisal
2,322.74 .00 2,322.74
_______________
Account: 135-55060-039-000 Appraisal Totals: .00 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: ------------------------------------------------------------------------------------------------ 13,266.49 **
110,100.00 Budgeted 96,833.51 Remaining 12 % Used
Fund 135 Totals: ------------------------------------------------------------------------------------------------------ 5,389.78
.00 Budgeted (5,389.78) Remaining 0 % Used
Trophy Club Municipal Utility District No. 1 116 of 143 December 17, 2012
Municipal Utility District No 1 - I & S
Interim Balance Sheet
Balance @
11/30/2012
ASSETS
ASSETS
CASH AND CASH IN BANK 6,120$
INVESTMENTS 149,017
ACCOUNTS RECEIVABLE - ADVALOREM TAXES 196,040
TOTAL ASSETS 351,177$
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS PAYABLE -$
DEFERRED REVENUE 196,040$
TOTAL LIABILITIES 196,040
FUND BALANCE
ASSIGNED FUND BALANCE 155,137
TOTAL LIABILITIES AND FUND BALANCE 351,177$
November 30, 2012
2/12 Months (16.66% of Fiscal Year)
Trophy Club Municipal Utility District No. 1 117 of 143 December 17, 2012
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 15
13:23 12/13/12 Budget Summary with Amendment
Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program:
Period Ending: 11/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- 10,542.13- 15,496.39- 7.869 181,443.61-
533-40002-000-000 Property Taxes/Delinquent 3,900.00- 3,900.00- 990.78- 2,284.82- 58.585 1,615.18-
533-40015-000-000 Property Taxes/P & I 5,017.00- 5,017.00- 566.35- 902.05- 17.980 4,114.95-
Subtotal: 205,857.00- 205,857.00- 12,099.26- 18,683.26- 9.076 187,173.74-
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.16- 36.70- 2.159 1,663.30-
533-49015-000-000 Lease/Rental Income 308,000.00- 308,000.00- 308,000.00-
Subtotal: 309,700.00- 309,700.00- 18.16- 36.70- .012 309,663.30-
Program number: 860,557.00- 860,557.00- 12,117.42- 18,719.96- 2.175 841,837.04-
Department number: Revenues 860,557.00- 860,557.00- 12,117.42- 18,719.96- 2.175 841,837.04-
Revenues Subtotal ----------- 860,557.00- 860,557.00- 12,117.42- 18,719.96- 2.175 841,837.04-
Trophy Club Municipal Utility District No. 1 118 of 143 December 17, 2012
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 16
13:23 12/13/12 Budget Summary with Amendment
Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program:
Period Ending: 11/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- 12,117.42- 18,719.96- 83.111 3,804.04-
******* End of Report *********
Trophy Club Municipal Utility District No. 1 119 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 56
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program:
Period Ending: 11/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
435 11/01/2012 Property Taxes/Assessments (4,954.26) (393.27) (5,347.53) GL
396 11/02/2012 Property Taxes/Assessments (260.94) (5,608.47) GL
398 11/05/2012 Property Taxes/Assessments (260.30) (5,868.77) GL
434 11/06/2012 Property Taxes/Assessments (224.58) (6,093.35) GL
400 11/07/2012 Property Taxes/Assessments (4,198.18) (10,291.53) GL
401 11/08/2012 Property Taxes/Assessments (52.95) (10,344.48) GL
403 11/09/2012 Property Taxes/Assessments (123.91) (10,468.39) GL
405 11/13/2012 Property Taxes/Assessments (358.32) (10,826.71) GL
409 11/14/2012 Property Taxes/Assessments (462.93) (11,289.64) GL
411 11/15/2012 Property Taxes/Assessments (642.03) (11,931.67) GL
413 11/16/2012 Property Taxes/Assessments (231.71) (12,163.38) GL
415 11/19/2012 Property Taxes/Assessments (568.78) (12,732.16) GL
417 11/20/2012 Property Taxes/Assessments (190.27) (12,922.43) GL
419 11/21/2012 Property Taxes/Assessments (513.36) (13,435.79) GL
428 11/26/2012 Property Taxes/Assessments (801.75) (14,237.54) GL
430 11/27/2012 Property Taxes/Assessments (481.87) (14,719.41) GL
431 11/28/2012 Property Taxes/Assessments (257.53) (14,976.94) GL
432 11/29/2012 Property Taxes/Assessments (173.69) (15,150.63) GL
433 11/30/2012 Property Taxes/Assessments (345.76) (15,496.39) GL
_______________
Account: 533-40000-000-000 Property Taxes Totals: (10,542.13) (15,496.39) **
(196,940.00) Budgeted (181,443.61) Remaining 8 % Used
Account: 533-40002-000-000 Property Taxes/Delinquent
400 11/07/2012 Property Taxes/Assessments (1,294.04) 1,575.81 281.77 GL
417 11/20/2012 Property Taxes/Assessments (2,462.43) (2,180.66) GL
431 11/28/2012 Property Taxes/Assessments (104.16) (2,284.82) GL
_______________
Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (990.78) (2,284.82) **
(3,900.00) Budgeted (1,615.18) Remaining 59 % Used
Account: 533-40015-000-000 Property Taxes/P & I
417 11/20/2012 Property Taxes/Assessments (335.70) (566.36) (902.06) GL
431 11/28/2012 Property Taxes/Assessments .01 (902.05) GL
_______________
Account: 533-40015-000-000 Property Taxes/P & I Totals: (566.35) (902.05) **
(5,017.00) Budgeted (4,114.95) Remaining 18 % Used
Account: 533-48005-000-000 Reserve Funds/PID Utility Fees
Trophy Club Municipal Utility District No. 1 120 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 57
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program:
Period Ending: 11/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: 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
377 11/30/2012 Nov Bank Interest (18.54) (18.16) (36.70) GL
_______________
Account: 533-49010-000-000 Interest Income Totals: (18.16) (36.70) **
(1,700.00) Budgeted (1,663.30) Remaining 2 % 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: ------------------------------------------------------------------------------------------------ (18,719.96) **
(860,557.00) Budgeted (841,837.04) Remaining 2 % Used
Trophy Club Municipal Utility District No. 1 121 of 143 December 17, 2012
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 58
13:23 12/13/12 Detailed Accounting Trial Balance
Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program:
Period Ending: 11/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: ------------------------------------------------------------------------------------------------------ (18,719.96)
(22,524.00) Budgeted (3,804.04) Remaining 83 % Used
Grand Totals: --------------------------------------------------------------------------------------------------------- 3,546.93 ****
(22,524.00) Budgeted (26,070.93) Remaining -16 % Used
******* End of Report *********
Trophy Club Municipal Utility District No. 1 122 of 143 December 17, 2012
BUDGET VARIANCE REPORT
FUND:122 - Fire O&M
FINANCIALS MONTH:November 2012
REVENUE VARIANCE:8%
EXPENSE VARIANCE:27%
NOTE:
ACCOUNT DESCRIPTION TOTAL
BUDGET
CURRENT
MONTH
YTD
TOTAL
YTD %VARIANCE EXPLANATION
FIRE REVENUE
122-40011 Property Taxes/Fire Delinquent 5,800$ 1,233$ 3,596$ 62%Collection of past due tax accounts
122-40020 Property Taxes/Fire P&I 4,500$ 849$ 1,443$ 32%Collection of past due tax accounts
122-49900 Miscellaneous Income 1,200$ 525$ 525$ 44%Fire line
FIRE EXPENSES
122-60010-045 Communications/Mobiles 2,500$ 217$ 1,608$ 64%Denton County Dispatch
122-60070-045 Dues & Memberships 7,500$ 185$ 7,006$ 93%Annual Certifications, Annual NEFDA
dues
122-60096-045 Emergency Management 1,000$ 1,000$ 1,000$ 100%Annual payment paid at the beginning of
year
122-60160-045 Programs & Special Projects 4,200$ 1,929$ 2,199$ 52%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 123 of 143 December 17, 2012
BUDGET VARIANCE REPORT
FUND:135 - MUD 1 O&M
FINANCIALS MONTH:November 2012
REVENUE VARIANCE:8%
EXPENSE VARIANCE:27%
NOTE:
ACCOUNT DESCRIPTION TOTAL
BUDGET
CURRENT
MONTH
YTD
TOTAL
YTD %VARIANCE EXPLANATION
REVENUE
135-40002 Property Taxes/Delinquent 500 405 660 132%Collection of delinquent accounts
135-40015 Property Taxes/P&I 1,200 372 450 38%Collection of delinquent accounts
135-47000 Water 3,545,609 286,486 553,070 16%On target for straight line method
135-47005 Sewer 1,653,747 151,095 282,782 17%On target for straight line method
135-47020 Standby 576 54 102 18%On target for straight line method
135-47025 Penalties 64,580 6,169 11,210 17%On target for straight line method
135-47030 Service Charges 11,625 878 1,781 15%On target for straight line method
135-49010 Interest Income 5,500$ 519$ 1,121$ 20%First Financial & Texpool Interest
135-49016 Cell Tower Revenue 7,000$ 911$ 1,758$ 25%On target for straight line method
135-49018 Building Rent Income 10,164$ 583$ 1,167$ 11%On target for straight line method
135-49075 Oversize Meter Reimbursement 73,000$ 4,672$ 10,220$ 14%On target for straight line method
135-49900 Miscellaneous Income 1,000$ 1,150$ 1,706$ 171%Beck park meter (Town), Reimb
Drainage fees adj to software by STW
WATER
135-50016-010 Longevity 3,080$ 3,080$ 3,080$ 100%Longevity paid annually in November
135-50020-010 Retirement 32,725$ 27,481$ 29,686$ 91%TCDRS Employer Contribution
135-55105-010 Maintenance - Backhoe/Skidloader 2,900$ 1,547$ 1,547$ 53%Full Service on Backhoe
135-60100-010 Travel & Per Diem 700$ 239$ 389$ 56%Mileage for On call overtime
135-65010-010 Uniforms 2,680$ 720$ 720$ 27%Purchase uniforms for new year
135-65050-010 Meters 143,550$ 93,750$ 93,750$ 65%Meters for change out
135-69281-010 Capital Repairs-Ground Storage 150,000$ 69,788$ 69,788$ 47%Annual maintenance agreement
WASTEWATER
135-50016-020 Longevity 2,858$ 2,858$ 2,858$ 100%Longevity paid annually in November
135-50020-020 Retirement 29,821$ 27,645$ 29,754$ 100%TCDRS Employer Contribution
135-55080-020 Maintenance & Repairs 40,000$ 9,713$ 17,338$ 43%Rebuild #1 blower motor, Repair 10 HP
pump
135-60066-020 Publications/Books/Subscriptions 500$ 161$ 161$ 32%Water/Wastewater treatment handbook
135-60245-020 Miscellaneous Expense 200$ 148$ 148$ 74%Paper towels & trash bags
135-65030-020 Chemicals 10,000$ 2,220$ 8,468$ 85%Chemicals
135-65045-020 Lab Supplies 10,000$ 48$ 3,903$ 39%Supplies
COLLECTIONS
135-50016-021 Longevity 3,818$ 3,818$ 3,818$ 100%Longevity paid annually in November
135-50020-021 Retirement 23,574$ 21,548$ 23,245$ 99%TCDRS Employer Contribution
135-60070-021 Dues & Memberships 250$ 111$ 111$ 44%License renewal
135-60080-021 Schools & Training 826$ 240$ 330$ 40%Testing
135-65010-021 Uniforms 2,220$ 815$ 815$ 37%Purchase uniforms for new year
ADMINISTRATION
135-50016-030 Longevity 2,193$ 2,318$ 2,318$ 106%Longevity paid annually in November.I
failed to compute District Secretary's
longevity
135-50016-031 Retirement 60,441$ 49,205$ 53,730$ 89%TCDRS Employer Contribution
135-50016-032 Building Maintenance & Supplies 5,000$ 1,476$ 1,508$ 30%Duct work in Terri's office
135-50016-033 Professional Outside Services 15,000$ 6,825$ 6,825$ 46%Website
135-50016-034 Service Charges & Fees 18,000$ 2,631$ 5,381$ 30%Credit card &online fees, bank monthly
analysis fee
135-50016-035 Insurance 35,000$ 26,536$ 60,602$ 173%Additional premium due to rerate
changes
135-50016-036 Publications/Books/Subscriptions 750$ 109$ 558$ 74%Texas HR manual
135-50016-037 Uniforms 1,635$ 624$ 624$ 38%MUD Shirts and cardigans
135-50016-038 Hardware 20,188$ 549$ 6,288$ 31%IT supplies
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 124 of 143 December 17, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:12012-309-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:12/9/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:12/17/2012
Title:Consider and take appropriate action to appoint a committee to review the Public Improvement
District agreement and present the Board with recommended changes. (McKnight)
Attachments:
Action ByDate Action ResultVer.
Title
Consider and take appropriate action to appoint a committee to review the Public Improvement District
agreement and present the Board with recommended changes. (McKnight)
Trophy Club Municipal Utility District No. 1 125 of 143 December 17, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:12012-310-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:12/10/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:12/17/2012
Title:Consider and take appropriate action to approve repairs to the skidloader in the amount of $6,830.11.
(Schlielig)
Attachments:Landmark Quote.pdf
Action ByDate Action ResultVer.
Title
Consider and take appropriate action to approve repairs to the skidloader in the amount of $6,830.11. (Schlielig)
Trophy Club Municipal Utility District No. 1 126 of 143 December 17, 2012
LAN
09
T. WO TH,
PHONE:817-834-8131
NT-T. WORTH
TOM RD
TX 761 7
FAX:817-831-8
PAGE 1
75
ESTIMATE FOR: TROPHY CLUB M.U.D.
100 MUNICIPAL DR
TROPHY CLUB TX 76262
INVOICE NO.: ES1096-01
WORK PHONE: 682-831-4687
PRELIMINARY INVOICE-DATE·12/10/l2@ 11:56AM
NH MODEL:LX565 SN:
P .0. NO.: X
START DATE:ll/12/12
ENDING DATE:
ACCT NO.: TROMUD
SALESM.AN: ST
I IQUANTITYiPART NUMBERS/DESCRIPTION/BIN LOCATION
I .. ~ I
j___PR_ICE I Al'IOUNT I .... ! " . ........ ........ .. . _............ .. ......
I REBUID ENGINE
PICK UP UNIT AND DELIVER TO LANDMARK SHOP FOR
/ENGINE TEAR DOWN AND REPAIR. REMOVE ENGINE FROM
I I
TRACTOR. TEARDOWN AND INSPECT ENGINE. ADVISE
!cusTOMER OF FOUND DAMAGES AND PROBLEMS. REBUILD ~ENGINE AS PER AGREMENT WITH CUSTOMER. REASSEMBLE l
UNIT AFTER REPAIRS. RETURN uNIT BACK To cusr.oMER. I
!**************************************************.
!EMAIL: OVALADEZ@GCMUO.ORG I
!EMAIL: LSLATHT@ TCMUD.ORG I
I M.ACHINE SHOP SERVICES I
RADIATOR CLEANING/REPAIR I
l.OO!PICK UP FEE
l.OOIDELIVERY FEE
Shop Supplies
:Freight
2.oo
1
1 NH SBAl99266200 WASHER,
1.00 NH SBA199266210 WASHER,
l.OO!NH SBA145206182 THERMOST B307
. ~·.~a I.~·~ ....... ~~A~4S.Ol7_73~ ........... -.. ·· .~.u~_:> .... '"~~-.................................... -........ ..
150.00
150.00
16.16
16.29
38.75
246.66
"""!"
I
!
!
I
l
l
!
65o.ool
150.00j
150.00
1.50.00(
59.99 i
so.oo;
32.321 *
1.6.29 *
38.75 *
246.66 *
** CONTINUED ON NEXT FAGE **
NVOICE NO. :ES1096-01 11111111 ~11!1111111111111111111111111 ~
Trophy Club Municipal Utility District No. 1 127 of 143 December 17, 2012
LANDMARK QU NT--
HAL OM RD 1 09
FT. WORTH,
PHONE:817-834-813
H
TX 76117
FAX:817-831-8775
ESTIMATE FOR; TROPHY CLUB M.U.D.
100 MUNICIPAL DR
TROPHY CLUB TX 76262
WORK PHONE: 682-831-4687
PRELIMINARY INVOICE-DATE 12/10/12 @ 11:56AM
NH MODEL:LX565 SN:
. . ~ . . . ~· . . '-
:QUANTITYIPART NUMBERS/DESCRIPTION/BIN LOCATION
1 1.oolNH 87036044 FILTER, E304
1.00 NH 9611973 FILTER, D106
1.00 NH 301525Al BELT B3END
1.00 NH SBA195907000 KIT
l.OO!NH 86504143 FILTER, G703
1.00 NH 87704241 FILTER, G401
l.OD!MI RAD CLEAN
l.OOINH 84475542
7.00 NH 86641081
4.00INH SBA115017491
8.00 1 NH SBA198517252
4.00lNH SBA198517232
4.00jNH SBA198517242
4.00 1 NH SBA120176380
4.0D!NH SBA120166380
1.00jMI MISC
2.00 MI ANTIFREEZE l*** TOTAL LABOR
FILTER, E304
OIL, ENG H302
KIT, PIS
BEARING
BEARING
BEARING
VALVE, E
VALVE, EN
ANT!FREE H205
!ADDRESS CHANGE FOR FORT WORTH LOCATION
!
LANDMARK EQUIPMENT
1309 HALTOM RD.
!FT WORTH TX 76117
PAGE 2
INVOICE NO.: ES1096-0l
P.O. NO.: X
START DATE:ll/12/12
ENDING DATE:
ACCT NO . : TROMUD
SALESMAN: ST
I
I
i PRICE I
I 18.921
6.26
33.781
598.24
28 .19j
2 9. 921
225.00
17. 45\
5.08
162.49l
7. so 1
13.511
13. 78.
20.021
20.57
300.001
16.951
I
I
I
I
I
I
l .. ._ ... I .... -.
~MOUNT I
18.921 *
6.261 *
33.78; *
598.241 *
28.191*
29.921*
225.00 *
17.451*
35.56 1 *
649.961 *
62.401 *
54.04:*
55.12! *
80.081 *
82.28'*
300.001*
33.90! *
2975.001
!
I
SUBTOTAL I 6830.11
1 ..
TOTAL
TAX i 218.22
AMOUNT--> _____ 70_4_.8_._3_3~
IGNATURE * -Designates Tax Applied To This Item -----------------------
~O!CE NO.:ES1096-0l
Trophy Club Municipal Utility District No. 1 128 of 143 December 17, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:12012-306-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:12/7/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:12/17/2012
Title:Consider and take appropriate action to award bid for Short Term Certificate of Obligation to bank.
(McKnight)
Attachments:BANK 3 YEAR CO 1212 RFPs.pdf
BANK 3 YEAR CO 1212.pdf
Action ByDate Action ResultVer.
Title
Consider and take appropriate action to award bid for Short Term Certificate of Obligation to bank. (McKnight)
Trophy Club Municipal Utility District No. 1 129 of 143 December 17, 2012
Trophy Club Municipal Utility District No. 1130 of 143December 17, 2012
Trophy Club Municipal Utility District No. 1131 of 143December 17, 2012
Trophy Club Municipal Utility District No. 1132 of 143December 17, 2012
Trophy Club Municipal Utility District No. 1133 of 143December 17, 2012
BID SUMMARY
3-Year Certificate of Obligation December 2012
Bank Bid Rate Fees
First Financial Bank 1.85% Fixed $0
American National Bank 1.98% Fixed $3,000
Prosperity Bank 3.25% Fixed Actual Cost
Trophy Club Municipal Utility District No. 1 134 of 143 December 17, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:12012-308-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:12/7/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:12/17/2012
Title:Consider and take appropriate action regarding the Interlocal Agreement with the Town of Trophy
Club for Contractual Personnel Services. (McKnight)
Attachments:
Action ByDate Action ResultVer.
Title
Consider and take appropriate action regarding the Interlocal Agreement with the Town of Trophy Club for
Contractual Personnel Services. (McKnight)
Trophy Club Municipal Utility District No. 1 135 of 143 December 17, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:12012-311-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:12/10/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:12/17/2012
Title:Consider and take appropriate action regarding the Interlocal Agreement with the Town of Trophy
Club for Fire Services Employee Contractual Services. (McKnight)
Attachments:
Action ByDate Action ResultVer.
Title
Consider and take appropriate action regarding the Interlocal Agreement with the Town of Trophy Club for Fire
Services Employee Contractual Services. (McKnight)
Trophy Club Municipal Utility District No. 1 136 of 143 December 17, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:12012-302-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:12/6/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:12/17/2012
Title:Consider and take appropriate action to approve Resolution No. 2012-1217A 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:TCDRS Resolution 2012-1217A.pdf
Action ByDate Action ResultVer.
Title
Consider and take appropriate action to approve Resolution No. 2012-1217A 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 137 of 143 December 17, 2012
RESOLUTION TO PARTICIPATE
Membership of Employees
Plan Selections
The District adopts the following plan selections at participation:
A. Employee Deposit Rate
The District elects to participate in the Texas County & District Retirement System (TCDRS) and to
provide retirement, disability and survivor benefits to its employees. All non-temporary employees of
the District will become members of TCDRS on the effective date indicated below.
The governing board of the Trophy Club Municipal Utility District #1 (#790) elects to begin
participation in TCDRS effective the 1st day of January 2013.
TCDRS was established by the Texas Legislature under Section 67 of Article XVI of the Texas
Constitution. This election is in accordance with Subtitle F of Title 8 of the Texas Government Code
(the TCDRS Act).
A deposit rate of 7% of compensation is required for each payroll period starting at the effective
participation date. These contributions must be certified by the District and transmitted to TCDRS
for deposit.
This is in accordance with Section 845.403 (i) of the TCDRS Act and conforms with the IRS
Revenue Ruling 2006-43, which states that for federal income tax purposes, the mandatory
employee contributions will be collected by the District and paid to TCDRS as employer
B. Employer Matching Rate
C. Monetary Prior Service Credit
D. Retirement Eligibility
At retirement, the District will match 200% of employees' final account balance. This is in
accordance with Section 843.403 of the TCDRS Act.
Employees will receive service time for the years worked prior to the District’s participation in
TCDRS. In addition to service time, the District can provide monetary prior service credit.
Monetary prior service credit shall be computed at 0%.
employee contributions will be collected by the District and paid to TCDRS as employer
contributions under IRC Section 414(h)(2) with a corresponding reduction in cash salary.
The District's employees must work 5 years to be vested. Once vested, an employee has earned
the right to receive a lifetime monthly retirement benefit and is eligible to retire at age 60.
The District also adopts the Rule of 75, which gives all vested employees the right to retire and
receive a lifetime monthly benefit when the employee’s age plus years of service equals 75 or
greater.
Additionally, any employee with 20 years of service, regardless of age, will also have the right
to retire and receive a lifetime monthly benefit.
TCDRS • PO Box 2034 Austin TX 78768-2034 • 800-651-3848 • Fax 512-328-8887 • www.tcdrs.org
12/13/2012 Page 1 of 2
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
RESOLUTION 2012-1217A
Trophy Club Municipal Utility District No. 1 138 of 143 December 17, 2012
RESOLUTION TO PARTICIPATE
E. Partial Lump-Sum Payment at Retirement
Plan Funding
Employer Contribution Rate
Additional Employer Contribution
Certification
The District agrees to make monthly contributions to TCDRS at a rate that equals or exceeds the
required rate annually determined by an independent actuarial firm hired by TCDRS. The District’s
required contribution rate will be 9.25% per month, a rate subject to annual adjustment.
In addition to the monthly contributions that the District will make to TCDRS, the District will
contribute, as a single payment, an additional contribution of $113,000. The additional contribution
shall be paid to TCDRS by the effective participation date of the District. In accordance with Section
845.408 of the TCDRS Act, the full amount will be credited to the District’s account in the Subdivision
Accumulation Fund.
I certify that the foregoing resolution concerning the District’s participation in TCDRS truly and accurately
reflects the official action taken during a properly posted and noticed meeting on ___________________,
20 b i b d d h i i ddi h ffiil i
The District elects to provide retiring employees the option to receive a lump-sum payment at
retirement up to the amount of their final account balance.
Authorized Signature Date
20__ by our governing board and such action is recorded in the official minutes.
TCDRS • PO Box 2034 Austin TX 78768-2034 • 800-651-3848 • Fax 512-328-8887 • www.tcdrs.org
12/13/2012 Page 2 of 2
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
RESOLUTION 2012-1217A
Trophy Club Municipal Utility District No. 1 139 of 143 December 17, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:12012-312-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:12/13/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:12/17/2012
Title:Consider and take appropriate action to transition all or part of MUD 1 personnel to MUD 1
supervision, payroll and benefits. (McKnight)
Attachments:
Action ByDate Action ResultVer.
Title
Consider and take appropriate action to transition all or part of MUD 1 personnel to MUD 1 supervision, payroll
and benefits. (McKnight)
Trophy Club Municipal Utility District No. 1 140 of 143 December 17, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:12012-299-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:12/6/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:12/17/2012
Title:Set next meeting date: Regular Session - January 15, 2013
Attachments:
Action ByDate Action ResultVer.
Title
Set next meeting date: Regular Session - January 15, 2013
Trophy Club Municipal Utility District No. 1 141 of 143 December 17, 2012
100 Municipal Drive
Trophy Club, Texas 76262Trophy Club Entities
Legislation Details (With Text)
File #: Version:12012-297-M1 Name:
Status:Type:M1 Agenda Item Draft
File created:In control:12/6/2012 Trophy Club Municipal Utility District No. 1
On agenda:Final action:12/17/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 142 of 143 December 17, 2012
Future Agenda Items
Code of Ethics
Service Policy
Paying off Bonds
Future Water Well
Water Rates
Additional Ground Storage
Break down of the $42,500 for Harmony Park
Recognition of website committee Volunteers.
A completed spreadsheet with exact amounts and dates of due to and due from the Town.
Trophy Club Municipal Utility District No. 1 143 of 143 December 17, 2012