HomeMy WebLinkAboutMarch 18 2014 Regular Meeting Agenda Packet
BOARD OF DIRECTORS
Meeting Agenda
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
100 MUNICIPAL DRIVE
TROPHY CLUB, TEXAS 76262
March 18, 2014 7:00 P.M. Svore Municipal Boardroom
CALL TO ORDER AND ANNOUNCE A QUORUM
CITIZEN PRESENTATIONS
This is an opportunity for citizens to address the Board on any matter whether or not it is posted on the
agenda. The Board is not permitted to take action on or discuss any presentations made to the Board at
this time concerning an item not listed on the agenda. The Board will hear presentations on specific
agenda items prior to the Board addressing those items. You may speak up to three (3) minutes or the
time limit determined by the President or presiding officer. To speak during this item you must complete
the Speaker's form that includes the topic(s) of your statement. Topics of presentation should be limited
to matters over which the Board has authority.
CONSENT AGENDA
All matters listed as Consent Agenda are considered to be routine by the Board of Directors and will be
enacted by one motion. There will not be a separate discussion of these items. If discussion is desired,
that item will be removed from the consent agenda and will be considered separately.
1. Consider and take appropriate action to approve the Consent Agenda.
a. February 18, 2014 - Regular Meeting Minutes
b. March 7, 2014 - Special Session Minutes
c. Check Register - February 2014
Attachments: February 18, 2014 - Regular Meeting Minutes
March 7, 2014 - Special Session Minutes
Check Register - February 2014
REGULAR SESSION
2. Consider and take appropriate action to approve Resolution No. 2014-0318A to allow District
participation in the Local Government Purchasing Cooperative and authorize the District
Manager to execute related and necessary documents.
Attachments: Resolution No. 2014-0318A
Interlocal Agreement
Trophy Club Municipal Utility District No. 1 1 of 132 March 18, 2014 Regular Meeting Agenda Packet
3. Consider and take appropriate action to rescind the bid award to CPS Civil for the Indian Creek
project, direct engineer to include an alternate design of Meadowbrook Drive, and authorize
the letting of new bids.
Attachments: Recommendation to Re-BID-2014-03-06.pdf
4. Consider and take appropriate action to approve Resolution No. 2014-0318B authorizing the
submittal of an application for Water Smart designation to the Association of Water Board
Directors.
Attachments: Resolution No. 2014-0307B
5. Consider and take appropriate action to authorize District protest to plat approval for
Canterbury Hills Phase 3 and appoint District representative(s) to Town of Trophy Club Planning
and Zoning Board meetings and Town Council meetings.
6. Legal update regarding dual office holding. (West)
7. Consider and take appropriate action to approve the February 2014 Financials. (Gonzales)
a. Combined Financials
b. Variance Report
Attachments: Combined Financials
Variance Report
REPORTS & UPDATES
8. District Manager Report
a. Water System Operation
b. Wastewater Operation
c. Website Analytics
d. Information System Reports
e. Finance Update
• Utility Billing Reports
• PID Connections
f. Update on access road for Lift Station No. 1
g. Update on plans for the Spring Open House
h. TRWA Annual Conference
Attachments: Water System Operation
Wastewater Operation
Website Analytics
Information System Reports
Utility Billing Reports
PID Connections
Trophy Club Municipal Utility District No. 1 2 of 132 March 18, 2014 Regular Meeting Agenda Packet
9. Fire Department Report (D. Thomas)
a. February 2014
b. Fire Update - Trophy Club Park
Attachments: Fire Report
CLOSED SESSION
The Board will conduct a Closed Session pursuant to Texas Government Code, annotated, Chapter 551,
Subchapter D for the following:
10. Section 551.071(2) Consultation with Attorney: Consultation with attorney on a matter in
which the duty of the attorney to the Governmental Body under Disciplinary Rules of
Professional Conduct of the State Bar of Texas clearly conflict with the Open Meetings Act and
to seek advice of counsel on legal matters involving pending or contemplated litigation,
settlement offers, or legal matters not related directly to litigation or settlement:
a. Appeal(s) of Texas Commission on Environmental Quality Order Authorizing the
Issuance of Bonds by the District to Finance Wastewater System Improvements
b. Water and wastewater services for PID; terms of inter-local agreement for provision of
water and wastewater services; Trophy Club Municipal Utility District No. 1 assets and
related matters; and representation
c. Potential Litigation Relating to Issuance of Bonds by District to Finance Wastewater
Treatment Plant Improvements
d. Potential legal issues related to renovation of District office building by the Town of
Trophy Club
RECONVENE INTO REGULAR SESSION
11. Consider and take appropriate action regarding Closed Session items.
12. Consider and take appropriate action to retain special legal counsel.
13. Consider and take appropriate action to proceed with issuance of bonds to finance required
improvements to the District’s wastewater treatment plant facilities.
14. Items for future agendas
15. Set next meeting date - Meeting calendar - April 2014
ADJOURN
Trophy Club Municipal Utility District No. 1 3 of 132 March 18, 2014 Regular Meeting Agenda Packet
*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, PURSUANT TO SECTION 551.071 OF THE TEXAS GOVERNMENT CODE.
CERTIFICATION
THE STATE OF TEXAS §
COUNTIES OF DENTON AND TARRANT §
THIS CERTIFIES THAT ON MARCH 14, 2014 BY 4:00 P.M., A COPY OF THE ABOVE NOTICE OF THE TROPHY
CLUB MUNICIPAL UTILITY DISTRICT NO. 1, BOARD OF DIRECTORS MEETING TO BE HELD ON MARCH 18,
2014 AT 7:00 P.M. WAS POSTED ON THE FRONT WINDOW OF TROPHY CLUB MUNICIPAL UTILITY
DISTRICT NO. 1 ADMINISTRATION BUILDING LOCATED AT 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 WEBSITES OR AT A PLACE CONVENIENT TO THE PUBLIC PURSUANT TO SECTION
49.063 OF THE WATER CODE AND SECTION 551.054 OF THE OPEN MEETINGS ACT, CHAPTER 551 OF THE
TEXAS GOVERNMENT CODE.
_______________________________
LAURIE SLAGHT, DISTRICT SECRETARY
Trophy Club Municipal Utility District No. 1 4 of 132 March 18, 2014 Regular Meeting Agenda Packet
REGULAR SESSION MINUTES FROM
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
BOARD OF DIRECTORS
100 MUNICIPAL DRIVE, TROPHY CLUB, TEXAS
February 18, 2014 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, February 18, 2014 at 7:00 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 §
DISTRICT BOARD MEMBERS PRESENT
Jim Moss President
Bill Armstrong Vice President
Kevin Carr Secretary/Treasurer
Nick Sanders Director
Jim Thomas Director
STAFF PRESENT:
Jennifer McKnight District Manager
Laurie Slaght District Secretary
Renae Gonzales Finance Manager
Terri Sisk Human Resources Manager
Adrian Womack Utility Superintendent
Karl Schlielig Wastewater Superintendent
Pam Liston District Legal Counsel
CITIZEN ADVISORY COMMITTEE MEMBERS:
Jim Hase Chair
Neil Twomey Co-Chair
Larry Hoover Committee Member
President Moss announced the date of February 18, 2014, called the meeting to order and announced a quorum
present at 7:00 p.m.
CONSENT AGENDA
1. Consider and take appropriate action to approve the Consent Agenda.
a. January 21, 2014 - Special Meeting Minutes
b. January 21, 2014 - Regular Meeting Minutes
c. Check Register - January 2014
Motion made by Director Thomas and seconded by Director Armstrong to approve the Consent Agenda.
Motion carried unanimously
REGULAR SESSION
Trophy Club Municipal Utility District No. 1 5 of 132 March 18, 2014 Regular Meeting Agenda Packet
2. Consider and take appropriate action regarding Water and Sewer Rate Study performed by J. Stowe & Co.
Matthew Garrett and Justin Rasor from J.Stowe & Co. presented the Results of the Water and Sewer Rate
Study.
Motion made by Director Sanders and seconded by Director Carr to direct the District Manager to amend the
District Rate Order using scenario #3 for water rates and scenario #4 for wastewater rates, indicate in the Rate
Order that the TCEQ regulatory assessment fee will be a separate line item on monthly bills, and to present the
amended Rate Order at the next regular meeting.
District Manager McKnight stated that staff may need until the April board meeting to finalize the amended Rate
Order for presentation.
Motion made by Director Sanders and seconded by Director Carr to amend the original motion to allow staff
until the April meeting to present the amended Rate Order.
Motion as amended carried unanimously.
3. Consider and take appropriate action to approve matters related to May 10, 2014 General Election:
a. Order No. 2014-0218 Calling the May 10, 2014 General Election
b. Notice of appointment of Agent
c. Joint Election Agreement and Contract for Election Services with Denton County
d. Joint Election Agreement and Contract for Election Services with Tarrant County
e. Authorize District Manager to sign and execute all necessary documents
f. Other necessary actions as may be required for the May 10, 2014 General Election
Motion made by Director Sanders and seconded by Director Carr to approve the matters related to May 10,
2014 General Election including Order No. 2014-0218 calling the May 10, 2014 General Election, Notice of
Appointment of Agent, Joint Election Agreement and Contract for Election Services with Denton County, Joint
Election Agreement and Contract for Election Services with Tarrant County, and to authorize District Manager to
sign and execute all necessary documents and other necessary actions as may be required for the May 10, 2014
General Election.
Motion carried unanimously
4. Consider and take appropriate action regarding Citizen Advisory Committee Report to the Board of Directors.
Chairman Hase reviewed the Citizen Advisory Committee’s final report with the board and recommended the
MUD continue to exist as a separate entity. Hase stated that members Jay Como and Dr. Wanda Franklin of the
Blue Ribbon Panel Finance Sub-committee attended the last meeting of the Citizen Advisory Committee and they
were able to agree on the assumptions used in the model and the final report. Hase thanked the District Manager
and staff for their help. Hase also thanked Neil Twomey for his dedicated work in creating the models and making
all the changes requested week after week.
Motion by Director Sanders and seconded by Director Thomas to officially receive the February 18, 2014 report
from the Citizens Advisory Committee consisting of Chairman Jim Hase, Co-Chairman Neil Twomey, Mike Buck,
Wallace Carlson, Pete Reincke and Larry Hoover, express the Board’s sincere thanks to this committee and the
staff who helped facilitate this report, and to direct the District Manager to place the report on the District
website, include a notice of its availability in the weekly e-blast to customers, and send an electronic copy to
Representative Tan Parker and Representative Giovanni Capriglione and the Town Manager of the Town of
Trophy Club.
Motion carried unanimously
Trophy Club Municipal Utility District No. 1 6 of 132 March 18, 2014 Regular Meeting Agenda Packet
5. Consider and take appropriate action to approve the January 2014 Financials.
a. Combined Financials
b. Variance Report
Motion made by Director Carr and seconded by Director Thomas to approve the January 2014 Financials.
Motion carried unanimously
6. Consider and take appropriate action related to the sale of Trophy Club Municipal Utility District No. 1 Unlimited
Tax Bonds, Series 2014, including the adoption of Resolution No. 2014-0218 authorizing the sale of such bonds and
the publication of a notice of sale.
Motion made by Director Sanders and seconded by Director Carr to approve Resolution 2014-0218 authorizing
the sale of Trophy Club Municipal Utility District No. 1 Unlimited Tax Bonds, Series 2014 and the publication of
notice of sale of such bonds, instruct the District Manager to follow Option B to ensure all bonds are bank
qualified, and to suggest that revenue bonds are issued prior to tax bonds.
District Manager McKnight explained that the resolution and all supporting documentation was related to the tax
bonds and the motion cannot both approve the resolution and request it to be changed to revenue bonds.
Motion is retracted by the first and second.
Further consideration of Item No. 6 is moved until after the executive session as the Board desires to seek legal
advice in Closed Session.
After the Closed Session the Board took the following action:
Motion made by Director Thomas and seconded by Director Armstrong to approve Resolution 2014-0218
authorizing the sale of Trophy Club Municipal Utility District No. 1 Unlimited Tax Bonds, Series 2014 and the
publication of notice of sale of such bonds, and to instruct the District Manager to follow Option B to ensure all
bonds are bank qualified.
Motion carried unanimously
7. Consider and take appropriate action to give notice as outlined in the agreement to the Town of Trophy Club to
terminate the Operations Agreement for Water and Wastewater Services to the Public Improvement District.
Motion made by Director Carr to notify the Town of Trophy Club that the District is exercising section 6.3 of the
Operations Contract to terminate the contract without default and giving the Town a one year notice.
No second to the motion. Director Carr retracted and requested legal advice.
Further consideration of Item No. 7 is moved until after the executive session as the Board desires to seek legal
advice in Closed Session.
After the Closed Session the Board took the following action:
Motion made by Director Carr and seconded by Director Moss to give the Town of Trophy Club notice of
termination of the Operations Agreement for Water and Wastewater Services to the Public Improvement
District as allowed in article 6.3 (Termination Without Default) of the agreement, and directed the District
Manager to deliver a written notice as required for a one year termination notice.
Motion carried unanimously
Trophy Club Municipal Utility District No. 1 7 of 132 March 18, 2014 Regular Meeting Agenda Packet
8. Consider and take appropriate action to authorize the Wallace Group to proceed with design of the wastewater
treatment plant without inclusion of service to the Public Improvement District.
Consideration of Item No. 8 is moved until after the executive session as the Board desires to seek legal advice in
Closed Session.
After the Closed Session the Board took the following action:
Motion made by Director Sanders and seconded by Director Carr to authorize the District Manager to instruct
the Wallace Group to proceed with design of the wastewater treatment plant without a long-term agreement
for the Town’s Public Improvement District.
Motion carried unanimously
9. Consider and take appropriate action regarding increased capacity for water supply from the City of Fort Worth
and participation in City’s 48-inch transmission line project.
Motion made by Director Carr and seconded by Director Sanders to direct the District Manager to inform the
City of Fort Worth that we will participate in the 48” transmission line and would like to purchase an increase in
capacity of 2.4 million gallons per day.
Motion carried unanimously
10. Consider and take appropriate action regarding evaluation of District legal counsel.
Discussion only. No action taken.
11. Consider and take appropriate action regarding continued negotiations with the Town of Westlake and
attendance at legislative meetings.
Consideration of Item No. 11 is moved until after the executive session as the Board desires to seek legal advice in
Closed Session.
After the Closed Session the Board took the following action:
Motion to authorize Director Carr and Director Sanders to attend a meeting on February 21, 2014 with State
legislators, the Town of Trophy Club, and the Town of Westlake.
Motion carried unanimously
REPORTS & UPDATES
12. Receive update from Citizen Advisory Committee.
No action taken.
13. Receive update from Director Thomas regarding the Association of Water Board Directors Winter
Conference.
Director Thomas gave an overview of the winter conference.
14. District Manager Report
Trophy Club Municipal Utility District No. 1 8 of 132 March 18, 2014 Regular Meeting Agenda Packet
a. Water System Operation
b. Wastewater Operation
c. Website Analytics
d. Finance Update
• Utility Billing Reports
• PID Connections
e. Update on Indian Creek Water Line Replacement Project
f. Update on Canterbury Hills, Phase 1, Plat
g. Update on plans for the Spring Open House
District Manager McKnight presented her monthly report. McKnight informed the Board that the Indian Creek
project will have to be rebid as the selected bidder is unable to attain bonds.
15. Fire Department Report
a. January 2014
Chief Thomas was not present. His reports were in the packet for the Board to review.
THE BOARD CONVENED INTO CLOSED SESSION AT 9:33 P.M.
CLOSED SESSION
The Board will conduct a Closed Session pursuant to Texas Government Code, annotated, Chapter 551, Subchapter
D for the following:
16. Section 551.071(2) Consultation with Attorney: Consultation with attorney on a matter in which the duty of the
attorney to the Governmental Body under Disciplinary Rules of Professional Conduct of the State Bar of Texas
clearly conflict with the Open Meetings Act and to seek advice of counsel on legal matters involving pending or
contemplated litigation, settlement offers, or legal matters not related directly to litigation or settlement:
a. Town of Westlake proposal to purchase Solana area from District boundaries
b.Water and wastewater services for PID; terms of inter-local agreement for provision of water and
wastewater services; Trophy Club Municipal Utility District No. 1 assets and related matters; and
representation
RECONVENE INTO REGULAR SESSION AT 11:09 P.M.
17. Consider and take appropriate action regarding Closed Session items.
Motion made Director Armstrong and seconded by Director Sanders to direct the District Manager to set up a
joint meeting with the Town Council to consider and finalize an agreement for water and wastewater services to
the Town’s Public Improvement District.
Motion carried unanimously
Motion made by Director Sanders and seconded by Director Armstrong to instruct the District Manager to
finalize the District’s response to the Town of Westlake’s letter dated January 15, 2014 and deliver the response
letter promptly to the Westlake Town Manager.
Motion carried unanimously
18. Items for future agendas
Trophy Club Municipal Utility District No. 1 9 of 132 March 18, 2014 Regular Meeting Agenda Packet
19. Set next meeting date March 18, 2014 at 7:00 p.m.
ADJOURN
President Moss adjourned the meeting at 11:36 p.m.
___________________________
Jim Moss,
Board President
____________________________ (SEAL)
Kevin R. Carr,
Board Secretary/Treasurer
____________________________
Laurie Slaght,
District Secretary
Trophy Club Municipal Utility District No. 1 10 of 132 March 18, 2014 Regular Meeting Agenda Packet
SPECIAL SESSION MINUTES FROM
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
BOARD OF DIRECTORS
100 MUNICIPAL DRIVE, TROPHY CLUB, TEXAS
MARCH 7, 2014 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 Friday, March 7, 2014 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 §
DISTRICT BOARD MEMBERS PRESENT
Jim Moss President
Bill Armstrong Vice President
Kevin Carr Secretary/Treasurer
Nick Sanders Director
Jim Thomas Director
STAFF PRESENT:
Jennifer McKnight District Manager
Laurie Slaght District Secretary
President Moss announced the date of Friday, March 7, 2014, called the meeting to order and
announced a quorum present at 10:30 a.m.
REGULAR SESSION
1.Consider and take appropriate action to retain special legal counsel.
The District Manager asked the Board to move consideration of this item after the Closed Session.
After the Executive Session, President Moss announced this item is tabled.
THE BOARD CONVENED INTO CLOSED SESSION AT 10:32 a.m.
The Board will conduct a Closed Session pursuant to Texas Government Code, annotated, Chapter 551,
Subchapter D for the following:
2.Section 551.071(2) Consultation with Attorney: Consultation with attorney on a matter in which the
duty of the attorney to the Governmental Body under Disciplinary Rules of Professional Conduct of the
State Bar of Texas clearly conflict with the Open Meetings Act and to seek advice of counsel on legal
matters involving pending or contemplated litigation, settlement offers, or legal matters not related
directly to litigation or settlement:
Trophy Club Municipal Utility District No. 1
March 7, 2014 Regular Session Minutes
1 of 3Trophy Club Municipal Utility District No. 1 11 of 132 March 18, 2014 Regular Meeting Agenda Packet
a.Water and Wastewater Services for Trophy Club PID;
b.Contract for Water and Wastewater Operational Services Between the Town of Trophy Club,
Texas, Trophy Club Municipal Utility District No. 1 and Trophy Club Municipal Utility District
No. 2;
c. Appeal(s) of Texas Commission on Environmental Quality Order Authorizing the Issuance of
Bonds by the District to Finance Wastewater System Improvements
d.Potential Litigation Relating to Issuance of Bonds by District to Finance Wastewater Treatment
Plant Improvements
THE BOARD RECONVENED INTO REGULAR SESSION AT 12:50 p.m.
REGULAR SESSION
3. Consider and take appropriate action regarding Contract for Water and Wastewater Operational
Services between the Town of Trophy Club, Texas, Trophy Club Municipal Utility District No. 1 and
Trophy Club Municipal Utility District No. 2.
Director Carr stated that in the best interest of moving forward and in the best interest of all of Trophy
Club he would like to make a motion to rescind the notice of termination of the Operations Agreement
with the Town of Trophy Club.
Motion made by Director Carr and seconded by Director Thomas to rescind the Boards prior motion
made on February 18, 2014 that directed the District Manager to provide a one-year notification of
termination of the Operations Agreement per 6.3 of the agreement to the Town of Trophy Club.
Motion carried unanimously.
Director Carr added, “I would like to applaud Director Sanders in being instrumental in breaking this
down and convincing us to retract or rescind this motion in the best interest of Trophy Club, and
hopefully that will open the doors for level headed leaders to come together and get an agreement for
the Public Improvement District.”
Director Moss stated he agreed with Director Carr and appreciates all of Director Sander’s comments.
Director Thomas stated that he wanted to say to Director Sanders, “personally the ideas you brought
up were excellent and made me rethink a lot of things and I appreciate all you put in to what you had
to say.”
Director Armstrong stated, “He has certainly demonstrated great leadership skills”
4. Consider and take appropriate action regarding design of the wastewater treatment plant.
Motion made by Director Carr and seconded by Director Sanders to rescind the prior motion of
February 18, 2014 regarding design of the wastewater treatment plant and request the engineers to
continue design with capacity for the PID.
Trophy Club Municipal Utility District No. 1
March 7, 2014 Regular Session Minutes
2 of 3Trophy Club Municipal Utility District No. 1 12 of 132 March 18, 2014 Regular Meeting Agenda Packet
Motion carried unanimously
5. Consider and take appropriate action to proceed with issuance of bonds to finance required
Improvements to the District’s wastewater treatment plant facilities.
President Moss announced this item is tabled.
President Moss adjourned the meeting at 12:53 p.m.
___________________________
Jim Moss,
Board President
____________________________ (SEAL)
Kevin R. Carr,
Board Secretary/Treasurer
____________________________
Laurie Slaght,
District Secretary
Trophy Club Municipal Utility District No. 1
March 7, 2014 Regular Session Minutes
3 of 3Trophy Club Municipal Utility District No. 1 13 of 132 March 18, 2014 Regular Meeting Agenda Packet
apackamt2 rgonzaleTrophy Club MUD #103/04/14 09:56Page 1AP Checks For Date/Amount RangeBegin Date: 02/01/2014 End Date: 02/28/2014From Amt:.00 To Amt: 99,999,999.99 Vendor Vendor NameInvoice Number Invoice Inv Dept AccountDescriptionLine Item Check CheckNumberDate Stat No NumberValue Number Date3006 CONSOLIDATED FLEET SERVICES 2014AH0018 01/27/14 P 45 122-55090-045-000 Vehicle Maintenance921.00 33427 02/14/14Totals for Check: 33427921.001256 DENTON CO FIRE CHIEFS ASSOC 14-02502/04/14 P 45 122-60070-045-000 Dues & Memberships280.00 33429 02/14/14Totals for Check: 33429280.001031 GANNS PEST CONTROL2156102/04/14 P 45 122-55080-045-000 Maintenance & Repairs140.00 33439 02/14/14Totals for Check: 33439140.002943 JPMORGAN CHASE BANK NA01271401/27/14 P 122-20060-000-000 Procurement Clearing518.58 33444 02/14/142943 JPMORGAN CHASE BANK NA01271401/27/14 P 135-20060-000-000 Procurement Clearing15,737.33 33444 02/14/14Totals for Check: 3344416,255.913180 OVERHEAD DOOR FORT WORTH 32946701/31/14 P 45 122-55080-045-000 Maintenance & Repairs170.00 33457 02/14/14Totals for Check: 33457170.003040 ATMOS ENERGY02191402/19/14 P 45 122-60020-045-000 Electricity/Gas520.52 33478 02/27/14Totals for Check: 33478520.521139 G & K SERVICES1159271529 01/06/14 P 45 122-55080-045-000 Maintenance & Repairs24.51 33489 02/27/141139 G & K SERVICES1159284283 01/20/14 P 45 122-55080-045-000 Maintenance & Repairs24.51 33489 02/27/141139 G & K SERVICES1159297039 02/03/14 P 45 122-55080-045-000 Maintenance & Repairs24.51 33489 02/27/141139 G & K SERVICES1159309698 02/17/14 P 45 122-55080-045-000 Maintenance & Repairs24.51 33489 02/27/14Totals for Check: 3348998.042775 HUDSON ENERGY SERVICES, LLC 673770102/11/14 P 45 122-60020-045-000 Electricity/Gas800.90 33492 02/27/14Totals for Check: 33492800.901001 TOWN OF TROPHY CLUB02182014 02/18/14 P 45 122-50060-045-000 Pre-employment Physicals/Test23.22 33503 02/27/141001 TOWN OF TROPHY CLUB02182014 02/18/14 P 45 122-50060-045-000 Pre-employment Physicals/Test112.50 33503 02/27/141001 TOWN OF TROPHY CLUB02182014 02/18/14 P 10 135-60010-010-000 Communications/Pagers/Mobiles383.39 33503 02/27/141001 TOWN OF TROPHY CLUB02182014 02/18/14 P 20 135-60010-020-000 Communications/Pagers/Mobiles206.74 33503 02/27/141001 TOWN OF TROPHY CLUB02182014 02/18/14 P 21 135-60010-021-000 Communications/Pagers/Mobiles102.68 33503 02/27/141001 TOWN OF TROPHY CLUB02182014 02/18/14 P 30 135-60010-030-000 Communications/Pagers/Mobiles140.67 33503 02/27/141001 TOWN OF TROPHY CLUB02182014 02/18/14 P 30 135-55030-030-000 Software & Support645.50 33503 02/27/141001 TOWN OF TROPHY CLUB02182014 02/18/14 P 45 122-60010-045-000 Communications/Pagers/Mobiles139.54 33503 02/27/141001 TOWN OF TROPHY CLUB02242014 02/24/14 P 45 122-50060-045-000 Pre-employment Physicals/Test35.00 33503 02/27/141001 TOWN OF TROPHY CLUB02242014 02/24/14 P 30 135-65055-030-000 Hardware13.15 33503 02/27/141001 TOWN OF TROPHY CLUB02242014 02/24/14 P 30 135-65055-030-000 Hardware22.00 33503 02/27/14Totals for Check: 335031,824.392196 VICTOR O SCHINNERER & CO, INC 022614NOTARY 02/26/14 P 45 122-60055-045-000 Insurance42.00 33504 02/27/14Totals for Check: 3350442.001001 TOWN OF TROPHY CLUB02262014 02/26/14 P 45 122-50060-045-000 Pre-employment Physicals/Test35.00 33507 02/27/141001 TOWN OF TROPHY CLUB02262014 02/26/14 P 30 135-65085-030-000 Office Supplies132.00 33507 02/27/141001 TOWN OF TROPHY CLUB02262014 02/26/14 P 30 135-55030-030-000 Software & Support47.50 33507 02/27/14
Trophy Club Municipal Utility District No. 1 14 of 132 March 18, 2014 Regular Meeting Agenda Packet
apackamt2 rgonzaleTrophy Club MUD #103/04/14 09:56Page 2AP Checks For Date/Amount RangeBegin Date: 02/01/2014 End Date: 02/28/2014From Amt:.00 To Amt: 99,999,999.99 Vendor Vendor NameInvoice Number Invoice Inv Dept AccountDescriptionLine Item Check CheckNumberDate Stat No NumberValue Number Date1001 TOWN OF TROPHY CLUB02262014 02/26/14 P 45 122-60195-045-000 Flags & Repair37.50 33507 02/27/14Totals for Check: 33507252.00Totals for Fund: 122 Trophy Club MUD Fire Dept.21,304.76Trophy Club Municipal Utility District No. 1 15 of 132 March 18, 2014 Regular Meeting Agenda Packet
apackamt2 rgonzaleTrophy Club MUD #103/04/14 09:56Page 3AP Checks For Date/Amount RangeBegin Date: 02/01/2014 End Date: 02/28/2014From Amt:.00 To Amt: 99,999,999.99 Vendor Vendor NameInvoice Number Invoice Inv Dept AccountDescriptionLine Item Check CheckNumberDate Stat No NumberValue Number Date998 ASHBY, ROBERTU0020001011200A 01/31/14 P 135-20050-000-000 A/P Vendors09.84 33420 02/14/14Totals for Check: 3342009.84998 ASHTON WOODS HOMESU0010040028100A 01/31/14 P 135-20050-000-000 A/P Vendors04.62 33421 02/14/14Totals for Check: 3342104.62998 ASHTON WOODS HOMESU0017040034100A 02/03/14 P 135-20050-000-000 A/P Vendors75.00 33422 02/14/14Totals for Check: 3342275.00998 ASHTON WOODS HOMESU0017050002100A 01/31/14 P 135-20050-000-000 A/P Vendors65.62 33423 02/14/14Totals for Check: 3342365.621005 ATLAS UTILITY SUPPLY CO. 17642602/07/14 P 10 135-55080-010-000 Maintenance & Repairs62.36 33424 02/14/141005 ATLAS UTILITY SUPPLY CO. 17633301/28/14 P 10 135-55080-010-000 Maintenance & Repairs9,250.00 33424 02/14/141005 ATLAS UTILITY SUPPLY CO. 17641402/07/14 P 10 135-65050-010-000 Meter Expense2,215.00 33424 02/14/14Totals for Check: 3342411,527.363196 AXIS CONSTRUCTION1316201/22/14 P 10 135-55080-010-000 Maintenance & Repairs1,695.00 33425 02/14/14Totals for Check: 334251,695.003193 COMPUPAY, INC.PR0050402/10/14 P 135-21313-000-000 A/P-Cafe 125-Medical Reimb632.13 33426 02/14/143193 COMPUPAY, INC.PR0050402/10/14 P 135-21314-000-000 A/P-Cafe 125-Childcare110.00 33426 02/14/14Totals for Check: 33426742.133184 DATAPROSE LLC353901/31/14 P 30 135-60035-030-000 Postage1,648.48 33428 02/14/143184 DATAPROSE LLC353901/31/14 P 30 135-55205-030-000 Utility Billing Contract566.00 33428 02/14/14Totals for Check: 334282,214.482497 DHS AUTOMATION, INC06-119402/03/14 P 21 135-69005-021-000 Capital Expenses6,500.00 33430 02/14/14Totals for Check: 334306,500.00998 DIGREGORIO, JOEU0050060555103A 01/31/14 P 135-20050-000-000 A/P Vendors47.49 33431 02/14/14Totals for Check: 3343147.491737 DPC INDUSTRIES, INC767006921-13 12/16/13 P 10 135-65030-010-000 Chemicals104.09 33432 02/14/14Totals for Check: 33432104.09998 EBBY HALLIDAY REAL ESTATE INC- U0034000026212A 01/31/14 P 135-20050-000-000 A/P Vendors66.32 33433 02/14/14Totals for Check: 3343366.32998 FIRST TEXAS HOMESU9046090018900A 01/31/14 P 135-20050-000-000 A/P Vendors54.68 33434 02/14/14Totals for Check: 3343454.68998 FIRST TEXAS HOMESU9046090019900A 01/31/14 P 135-20050-000-000 A/P Vendors67.31 33435 02/14/14Totals for Check: 3343567.313129 FREEMAN & CORBETT01311401/31/14 P 39 135-55045-039-000 Legal9,515.00 33436 02/14/14
Trophy Club Municipal Utility District No. 1 16 of 132 March 18, 2014 Regular Meeting Agenda Packet
apackamt2 rgonzaleTrophy Club MUD #103/04/14 09:56Page 4AP Checks For Date/Amount RangeBegin Date: 02/01/2014 End Date: 02/28/2014From Amt:.00 To Amt: 99,999,999.99 Vendor Vendor NameInvoice Number Invoice Inv Dept AccountDescriptionLine Item Check CheckNumberDate Stat No NumberValue Number DateTotals for Check: 334369,515.00998 FREEMAN, ERINU0020000920209A 01/31/14 P 135-20050-000-000 A/P Vendors71.62 33437 02/14/14Totals for Check: 3343771.621139 G & K SERVICES1159271530 01/06/14 P 30 135-55100-030-000 Building Maint & Supplies94.42 33438 02/14/141139 G & K SERVICES1159277888 01/13/14 P 30 135-55100-030-000 Building Maint & Supplies94.42 33438 02/14/141139 G & K SERVICES1159284284 01/20/14 P 30 135-55100-030-000 Building Maint & Supplies94.42 33438 02/14/141139 G & K SERVICES1159290687 01/27/14 P 30 135-55100-030-000 Building Maint & Supplies94.42 33438 02/14/14Totals for Check: 33438377.681372 HACH COMPANY867923602/03/14 P 10 135-65030-010-000 Chemicals309.93 33440 02/14/14Totals for Check: 33440309.933076 HD SUPPLY FACILITIES MAINT LTD 25512801/28/14 P 10 135-55080-010-000 Maintenance & Repairs259.90 33441 02/14/14Totals for Check: 33441259.903124 IRS Tax PaymentPR0050402/10/14 P 135-21302-000-000 A/P-FWH Taxes3,623.80 33442 02/14/143124 IRS Tax PaymentPR0050402/10/14 P 135-21303-000-000 A/P-Social Security Taxes4,557.94 33442 02/14/143124 IRS Tax PaymentPR0050402/10/14 P 135-21304-000-000 A/P-Medicare Taxes1,065.98 33442 02/14/14Totals for Check: 334429,247.722764 JAMIE LYNN MCMAHONPR0050402/10/14 P 135-21410-000-000 A/P-Child Support184.62 33443 02/14/14Totals for Check: 33443184.62998 K. HOVNANIAN HOMES-TROPHY CLUB U9043250052900A 01/31/14 P 135-20050-000-000 A/P Vendors63.64 33445 02/14/14Totals for Check: 3344563.64998 LENNAR HOMESU9046040035900A 01/31/14 P 135-20050-000-000 A/P Vendors13.03 33446 02/14/14Totals for Check: 3344613.03998 LENNAR HOMESU9046080004900A 01/31/14 P 135-20050-000-000 A/P Vendors53.84 33447 02/14/14Totals for Check: 3344753.84998 LENNAR HOMESU9046080020900A 01/31/14 P 135-20050-000-000 A/P Vendors67.31 33448 02/14/14Totals for Check: 3344867.31998 LENNAR HOMESU9048040007900A 01/31/14 P 135-20050-000-000 A/P Vendors31.27 33449 02/14/14Totals for Check: 3344931.27998 LONIS, L. CLAYU0010190012121A 01/31/14 P 135-20050-000-000 A/P Vendors39.45 33450 02/14/14Totals for Check: 3345039.452754 LOWER COLORADO RIVER AUTHORITY 12056001/27/14 P 10 135-60135-010-000 TCEQ Fees & Permits207.70 33451 02/14/142754 LOWER COLORADO RIVER AUTHORITY 12056101/27/14 P 10 135-60135-010-001 TCEQ Fees & Permits112.34 33451 02/14/14Totals for Check: 33451320.04Trophy Club Municipal Utility District No. 1 17 of 132 March 18, 2014 Regular Meeting Agenda Packet
apackamt2 rgonzaleTrophy Club MUD #103/04/14 09:56Page 5AP Checks For Date/Amount RangeBegin Date: 02/01/2014 End Date: 02/28/2014From Amt:.00 To Amt: 99,999,999.99 Vendor Vendor NameInvoice Number Invoice Inv Dept AccountDescriptionLine Item Check CheckNumberDate Stat No NumberValue Number Date3186 MEMBERS BUILDING MAINTENANCE TC1401TCMUD 01/31/14 P 30 135-55120-030-000 Cleaning Services1,594.97 33452 02/14/14Totals for Check: 334521,594.972665 MIGUEL CRUZ021314CAC 02/13/14 P 30 135-55070-030-000 Independent Labor37.50 33453 02/14/142665 MIGUEL CRUZ020514CAC 02/05/14 P 30 135-55070-030-000 Independent Labor30.00 33453 02/14/14Totals for Check: 3345367.50998 MORGAN, RONU0010130122104A 01/31/14 P 135-20050-000-000 A/P Vendors13.86 33454 02/14/14Totals for Check: 3345413.863111 North Texas Groundwater 5102/07/14 P 10 135-60135-010-000 TCEQ Fees & Permits2,582.50 33455 02/14/14Totals for Check: 334552,582.501056 OFFICE DEPOT, INC692085952001 01/24/14 P 30 135-65085-030-000 Office Supplies58.33 33456 02/14/141056 OFFICE DEPOT, INC691581879001 01/21/14 P 30 135-65085-030-000 Office Supplies42.70 33456 02/14/141056 OFFICE DEPOT, INC691581938001 01/21/14 P 30 135-65085-030-000 Office Supplies11.49 33456 02/14/14Totals for Check: 33456112.52998 PARKWAY CONSTRUCTIONU0511000117508A 02/03/14 P 135-20050-000-000 A/P Vendors598.33 33458 02/14/14Totals for Check: 33458598.33998 PULTE HOMESU9035110033900A 01/31/14 P 135-20050-000-000 A/P Vendors58.84 33459 02/14/14Totals for Check: 3345958.84998 PULTE HOMESU9035190013900A 01/31/14 P 135-20050-000-000 A/P Vendors10.96 33460 02/14/14Totals for Check: 3346010.96998 PULTE HOMESU9046070008900A 01/31/14 P 135-20050-000-000 A/P Vendors16.97 33461 02/14/14Totals for Check: 3346116.97998 PULTE HOMESU9046070011900A 01/31/14 P 135-20050-000-000 A/P Vendors67.31 33462 02/14/14Totals for Check: 3346267.311920 RESERVE ACCOUNT02141402/14/14 P 135-11203-000-000 Prepaid Postage-Meter1,500.00 33463 02/14/14Totals for Check: 334631,500.001063 ROANOKE AUTO SUPPLY76075902/14/14 P 20 135-55090-020-000 Vehicle Maintenance278.00 33464 02/14/141063 ROANOKE AUTO SUPPLY76105001/06/14 P 10 135-55090-010-000 Vehicle Maintenance695.00 33464 02/14/141063 ROANOKE AUTO SUPPLY76323101/31/14 P 21 135-55090-021-000 Vehicle Maintenance999.18 33464 02/14/14Totals for Check: 334641,972.18998 STAMOS, STEVEN TU0030101247201A 01/31/14 P 135-20050-000-000 A/P Vendors16.93 33465 02/14/14Totals for Check: 3346516.932440 TARRANT CTY PUBLIC HEALTH LAB 2427601/31/14 P 10 135-55135-010-001 Lab Analysis80.00 33466 02/14/14Totals for Check: 3346680.00Trophy Club Municipal Utility District No. 1 18 of 132 March 18, 2014 Regular Meeting Agenda Packet
apackamt2 rgonzaleTrophy Club MUD #103/04/14 09:56Page 6AP Checks For Date/Amount RangeBegin Date: 02/01/2014 End Date: 02/28/2014From Amt:.00 To Amt: 99,999,999.99 Vendor Vendor NameInvoice Number Invoice Inv Dept AccountDescriptionLine Item Check CheckNumberDate Stat No NumberValue Number Date2440 TARRANT CTY PUBLIC HEALTH LAB 2427501/31/14 P 10 135-55135-010-000 Lab Analysis310.00 33467 02/14/14Totals for Check: 33467310.003113 TCDRSPR0050402/10/14 P 135-21317-000-000 A/P-TCDRS6,278.40 33468 02/14/14Totals for Check: 334686,278.401908 THE LISTON LAW FIRM, P.C. 01311401/31/14 P 39 135-55045-039-000 Legal1,350.25 33469 02/14/14Totals for Check: 334691,350.253080 THE WALLACE GROUP, INC. 4274901/31/14 P 20 135-55070-020-000 Independent Labor71,565.00 33470 02/14/14Totals for Check: 3347071,565.001001 TOWN OF TROPHY CLUBJANUARY-REFUSE 02/04/14 P 135-25040-000-000 A/P Town-Storm Drainage32,696.47 33471 02/14/141001 TOWN OF TROPHY CLUBJANUARY-REFUSE 02/04/14 P 135-25000-000-000 A/P Refuse52,544.52 33471 02/14/141001 TOWN OF TROPHY CLUBJANUARY-REFUSE 02/04/14 P 135-25010-000-000 A/P Refuse Tax4,330.10 33471 02/14/14Totals for Check: 3347189,571.091081 TRI COUNTY ELECTRIC20098880010114 01/31/14 P 21 135-60020-021-000 Electricity239.76 33472 02/14/141081 TRI COUNTY ELECTRIC2209888001 0114 01/31/14 P 21 135-60020-021-000 Electricity124.10 33472 02/14/141081 TRI COUNTY ELECTRIC2309888001 0114 01/31/14 P 21 135-60020-021-000 Electricity27.65 33472 02/14/14Totals for Check: 33472391.511000 TROPHY CLUB MUD (WATER BILLS) 013114UB 01/31/14 P 30 135-60025-030-000 Water155.52 33473 02/14/141000 TROPHY CLUB MUD (WATER BILLS) 013114UB 01/31/14 P 45 122-60025-045-000 Water129.12 33473 02/14/141000 TROPHY CLUB MUD (WATER BILLS) 013114UB 01/31/14 P 45 122-60025-045-000 Water58.21 33473 02/14/14Totals for Check: 33473342.852196 VICTOR O SCHINNERER & CO, INC R110142071 01/28/14 P 30 135-60055-030-000 Insurance50.00 33474 02/14/14Totals for Check: 3347450.00998 WEST, ADAMU0010050439112A 01/31/14 P 135-20050-000-000 A/P Vendors117.90 33475 02/14/14Totals for Check: 33475117.902222 AFLACPR0050402/10/14 P 135-21312-000-000 A/P-Aflac89.78 33476 02/27/142222 AFLACPR0050502/25/14 P 135-21312-000-000 A/P-Aflac89.78 33476 02/27/14Totals for Check: 33476179.563127 ALLIED WELDING SUPPLY, INC R11400141 01/31/14 P 10 135-60105-010-000 Rent/Lease Equipment06.00 33477 02/27/14Totals for Check: 3347706.003198 BDMR DEVELOPMENT LLC022713LS4 02/27/14 P 21 135-69005-021-000 Capital Expenses61,800.20 33479 02/27/14Totals for Check: 3347961,800.203197 BenefitMall9019358-IN 02/20/14 P 10 135-50029-010-000 Life Insurance & Other15.62 33480 02/27/143197 BenefitMall9019358-IN 02/20/14 P 20 135-50029-020-000 Life Insurance & Other31.28 33480 02/27/143197 BenefitMall9019358-IN 02/20/14 P 30 135-50029-030-000 Life Insurance & Other39.10 33480 02/27/14Totals for Check: 3348086.00Trophy Club Municipal Utility District No. 1 19 of 132 March 18, 2014 Regular Meeting Agenda Packet
apackamt2 rgonzaleTrophy Club MUD #103/04/14 09:56Page 7AP Checks For Date/Amount RangeBegin Date: 02/01/2014 End Date: 02/28/2014From Amt:.00 To Amt: 99,999,999.99 Vendor Vendor NameInvoice Number Invoice Inv Dept AccountDescriptionLine Item Check CheckNumberDate Stat No NumberValue Number Date2847 BLUE CROSS BLUE SHIELD OF TX 03011403/01/14 P 135-21307-000-000 A/P-Medical17,186.75 33481 02/27/14Totals for Check: 3348117,186.753072 CINTAS CORPORATION NO. 2 5000879234 01/22/14 P 20 135-65040-020-000 Safety Equipment24.59 33482 02/27/14Totals for Check: 3348224.593193 COMPUPAY, INC.PR0050502/25/14 P 135-21313-000-000 A/P-Cafe 125-Medical Reimb632.13 33483 02/27/143193 COMPUPAY, INC.PR0050502/25/14 P 135-21314-000-000 A/P-Cafe 125-Childcare110.00 33483 02/27/14Totals for Check: 33483742.131019 DENTON PUBLISHING CO0001227592 02/21/14 P 30 135-60125-030-000 Advertising74.50 33484 02/27/141019 DENTON PUBLISHING CO0001231081 02/28/14 P 30 135-60125-030-000 Advertising79.40 33484 02/27/14Totals for Check: 33484153.902497 DHS AUTOMATION, INC06-120502/25/14 P 10 135-55080-010-000 Maintenance & Repairs975.00 33485 02/27/14Totals for Check: 33485975.001026 FEDERAL EXPRESS CORP2-543-78286 01/30/14 P 30 135-60035-030-000 Postage05.77 33486 02/27/14Totals for Check: 3348605.771832 FIRST FINANCIAL BANK915000106560314 03/01/14 P 10 135-69008-010-000 Short Term Debt-Principal122,980.00 33487 02/27/141832 FIRST FINANCIAL BANK915000106560314 03/01/14 P 20 135-69008-020-000 Short Term Debt-Principal20,020.00 33487 02/27/141832 FIRST FINANCIAL BANK915000106560314 03/01/14 P 10 135-69009-010-000 Short Term Debt-Interest6,411.28 33487 02/27/141832 FIRST FINANCIAL BANK915000106560314 03/01/14 P 20 135-69009-020-000 Short Term Debt-Interest1,043.70 33487 02/27/14Totals for Check: 33487150,454.981832 FIRST FINANCIAL BANK915000088410314 03/01/14 P 10 135-69009-010-000 Short Term Debt-Interest5,209.98 33488 02/27/14Totals for Check: 334885,209.983112 HARCROS CHEMICALS INC160135322 01/22/14 P 20 135-65030-020-000 Chemicals2,240.00 33490 02/27/14Totals for Check: 334902,240.003136 HD SUPPLY WATERWORKS, LTD. C04595502/17/14 P 10 135-55080-010-000 Maintenance & Repairs904.48 33491 02/27/14Totals for Check: 33491904.482775 HUDSON ENERGY SERVICES, LLC 5177102/11/14 P 10 135-60020-010-000 Electricity4,706.99 33492 02/27/142775 HUDSON ENERGY SERVICES, LLC 670980502/09/14 P 10 135-60020-010-000 Electricity75.18 33492 02/27/142775 HUDSON ENERGY SERVICES, LLC 671005702/10/14 P 21 135-60020-021-000 Electricity30.39 33492 02/27/142775 HUDSON ENERGY SERVICES, LLC 670977002/10/14 P 21 135-60020-021-000 Electricity55.23 33492 02/27/142775 HUDSON ENERGY SERVICES, LLC 672602202/11/14 P 21 135-60020-021-000 Electricity90.28 33492 02/27/142775 HUDSON ENERGY SERVICES, LLC 5168802/11/14 P 21 135-60020-021-000 Electricity592.30 33492 02/27/142775 HUDSON ENERGY SERVICES, LLC 672581802/11/14 P 10 135-60020-010-000 Electricity2,025.31 33492 02/27/142775 HUDSON ENERGY SERVICES, LLC 5177002/11/14 P 20 135-60020-020-000 Electricity8,479.79 33492 02/27/142775 HUDSON ENERGY SERVICES, LLC 5177002/11/14 P 21 135-60020-021-000 Electricity1,372.94 33492 02/27/14Totals for Check: 3349217,428.411249 HUTHER AND ASSOCIATES,INC 117502/05/14 P 20 135-55135-020-000 Lab Analysis1,080.00 33493 02/27/14
Trophy Club Municipal Utility District No. 1 20 of 132 March 18, 2014 Regular Meeting Agenda Packet
apackamt2 rgonzaleTrophy Club MUD #103/04/14 09:56Page 8AP Checks For Date/Amount RangeBegin Date: 02/01/2014 End Date: 02/28/2014From Amt:.00 To Amt: 99,999,999.99 Vendor Vendor NameInvoice Number Invoice Inv Dept AccountDescriptionLine Item Check CheckNumberDate Stat No NumberValue Number DateTotals for Check: 334931,080.003124 IRS Tax PaymentPR0050502/25/14 P 135-21302-000-000 A/P-FWH Taxes3,575.57 33494 02/27/143124 IRS Tax PaymentPR0050502/25/14 P 135-21303-000-000 A/P-Social Security Taxes4,625.26 33494 02/27/143124 IRS Tax PaymentPR0050502/25/14 P 135-21304-000-000 A/P-Medicare Taxes1,081.68 33494 02/27/14Totals for Check: 334949,282.512764 JAMIE LYNN MCMAHONPR0050502/25/14 P 135-21410-000-000 A/P-Child Support184.62 33495 02/27/14Totals for Check: 33495184.623167 KEYSTONE PARK SECRETARIAL 11730302/26/14 P 30 135-60005-030-000 Telephone180.00 33496 02/27/14Totals for Check: 33496180.001468 L.H. CHANEY MATERIALS, INC. 8439601/18/14 P 20 135-55125-020-000 Dumpster Services2,751.11 33497 02/27/141468 L.H. CHANEY MATERIALS, INC. 8480501/25/14 P 20 135-55125-020-000 Dumpster Services1,911.24 33497 02/27/141468 L.H. CHANEY MATERIALS, INC. 8516902/12/14 P 20 135-55125-020-000 Dumpster Services1,814.62 33497 02/27/14Totals for Check: 334976,476.973115 METLIFE030114VISION 03/01/14 P 135-21309-000-000 A/P-Vision307.99 33498 02/27/143115 METLIFE030114MEDICAL 03/01/14 P 135-21308-000-000 A/P-Dental1,425.78 33498 02/27/143115 METLIFE030114MEDICAL 03/01/14 P 135-21311-000-000 A/P-Voluntary Life411.32 33498 02/27/143115 METLIFE030114MEDICAL 03/01/14 P 135-21315-000-000 A/P-Short Term Disability83.12 33498 02/27/143115 METLIFE030114MEDICAL 03/01/14 P 10 135-50029-010-000 Life Insurance & Other218.75 33498 02/27/143115 METLIFE030114MEDICAL 03/01/14 P 20 135-50029-020-000 Life Insurance & Other155.00 33498 02/27/143115 METLIFE030114MEDICAL 03/01/14 P 21 135-50029-021-000 Life Insurance & Other71.54 33498 02/27/143115 METLIFE030114MEDICAL 03/01/14 P 30 135-50029-030-000 Life Insurance & Other310.23 33498 02/27/14Totals for Check: 334982,983.732665 MIGUEL CRUZ021814MUD 02/18/14 P 30 135-55070-030-000 Independent Labor75.00 33499 02/27/14Totals for Check: 3349975.003156 OXIDOR LABORATORIES LLC 14010711 01/29/14 P 20 135-55135-020-000 Lab Analysis176.00 33500 02/27/143156 OXIDOR LABORATORIES LLC 14010510 01/22/14 P 20 135-55135-020-000 Lab Analysis176.00 33500 02/27/143156 OXIDOR LABORATORIES LLC 14010429 01/21/14 P 20 135-55135-020-000 Lab Analysis246.00 33500 02/27/143156 OXIDOR LABORATORIES LLC 14010295 01/16/14 P 20 135-55135-020-000 Lab Analysis246.00 33500 02/27/143156 OXIDOR LABORATORIES LLC 14010269 01/15/14 P 20 135-55135-020-000 Lab Analysis176.00 33500 02/27/143156 OXIDOR LABORATORIES LLC 14020104 02/06/14 P 20 135-55135-020-000 Lab Analysis246.00 33500 02/27/143156 OXIDOR LABORATORIES LLC 14020184 02/11/14 P 20 135-55135-020-000 Lab Analysis176.00 33500 02/27/143156 OXIDOR LABORATORIES LLC 14020117 02/06/14 P 20 135-55135-020-000 Lab Analysis176.00 33500 02/27/143156 OXIDOR LABORATORIES LLC 14020179 02/11/14 P 20 135-55135-020-000 Lab Analysis246.00 33500 02/27/143156 OXIDOR LABORATORIES LLC 14010707 01/29/14 P 20 135-55135-020-000 Lab Analysis246.00 33500 02/27/14Totals for Check: 335002,110.001063 ROANOKE AUTO SUPPLY800001383 02/18/14 P 10 135-55090-010-000 Vehicle Maintenance13.85 33501 02/27/14Totals for Check: 3350113.853113 TCDRSPR0050502/25/14 P 135-21317-000-000 A/P-TCDRS6,362.32 33502 02/27/14
Trophy Club Municipal Utility District No. 1 21 of 132 March 18, 2014 Regular Meeting Agenda Packet
apackamt2 rgonzaleTrophy Club MUD #103/04/14 09:56Page 9AP Checks For Date/Amount RangeBegin Date: 02/01/2014 End Date: 02/28/2014From Amt:.00 To Amt: 99,999,999.99 Vendor Vendor NameInvoice Number Invoice Inv Dept AccountDescriptionLine Item Check CheckNumberDate Stat No NumberValue Number DateTotals for Check: 335026,362.321001 TOWN OF TROPHY CLUB1291401/29/14 P 30 135-55030-030-000 Software & Support259.46 33503 02/27/141001 TOWN OF TROPHY CLUB1291401/29/14 P 30 135-60005-030-000 Telephone933.57 33503 02/27/141001 TOWN OF TROPHY CLUB01292014 01/29/14 P 30 135-65085-030-000 Office Supplies71.29 33503 02/27/141001 TOWN OF TROPHY CLUB01292014 01/29/14 P 10 135-65040-010-000 Safety Equipment137.94 33503 02/27/141001 TOWN OF TROPHY CLUB01292014 01/29/14 P 20 135-65040-020-000 Safety Equipment91.96 33503 02/27/141001 TOWN OF TROPHY CLUB01292014 01/29/14 P 21 135-65040-021-000 Safety Equipment45.98 33503 02/27/141001 TOWN OF TROPHY CLUB01292014 01/29/14 P 45 122-65015-045-000 Protective Clothing172.43 33503 02/27/141001 TOWN OF TROPHY CLUB02182014B 02/18/14 P 30 135-60035-030-000 Postage47.99 33503 02/27/141001 TOWN OF TROPHY CLUB02182014B 02/18/14 P 30 135-69170-030-000 Copier Lease Installments256.85 33503 02/27/141001 TOWN OF TROPHY CLUB02182014B 02/18/14 P 30 135-55030-030-000 Software & Support442.50 33503 02/27/141001 TOWN OF TROPHY CLUB02241402/24/14 P 30 135-55030-030-000 Software & Support300.99 33503 02/27/141001 TOWN OF TROPHY CLUB02241402/24/14 P 30 135-65055-030-000 Hardware32.56 33503 02/27/141001 TOWN OF TROPHY CLUB02241402/24/14 P 30 135-60005-030-000 Telephone957.68 33503 02/27/14Totals for Check: 335033,751.203091 XYLEM WATER SOLUTIONS USA INC 3556772819 01/28/14 P 20 135-55080-020-000 Maintenance & Repairs508.00 33505 02/27/14Totals for Check: 33505508.003132 Legal ShieldPR0050402/10/14 P 135-21310-000-000 A/P-Legal PLan74.28 33506 02/27/143132 Legal ShieldPR0050502/25/14 P 135-21310-000-000 A/P-Legal PLan74.28 33506 02/27/143132 Legal Shield02251402/25/14 P 135-21310-000-000 A/P-Legal PLan(00.06) 33506 02/27/14Totals for Check: 33506148.501120 TROPHY CLUB MUD PETTY CASH 021914RG 02/19/14 P 10 135-55090-010-000 Vehicle Maintenance05.29 33508 02/27/141120 TROPHY CLUB MUD PETTY CASH 021914RG 02/19/14 P 10 135-60080-010-000 Schools & Training40.00 33508 02/27/141120 TROPHY CLUB MUD PETTY CASH 021914RG 02/19/14 P 30 135-60245-030-000 Miscellaneous Expenses29.17 33508 02/27/14Totals for Check: 3350874.46999 William PrattBERKEYS 57486 02/27/14 P 21 135-55080-021-000 Maintenance & Repairs2,898.00 33509 02/27/14Totals for Check: 335092,898.00Totals for Fund: 135 MUD 1 General Fund515,925.77Trophy Club Municipal Utility District No. 1 22 of 132 March 18, 2014 Regular Meeting Agenda Packet
Grand Totals:537,230.53****** End of Report *********
Trophy Club Municipal Utility District No. 1 23 of 132 March 18, 2014 Regular Meeting Agenda Packet
Trophy Club Municipal Utility District No. 124 of 132March 18, 2014 Regular Meeting Agenda Packet
Trophy Club Municipal Utility District No. 125 of 132March 18, 2014 Regular Meeting Agenda Packet
Trophy Club Municipal Utility District No. 126 of 132March 18, 2014 Regular Meeting Agenda Packet
Trophy Club Municipal Utility District No. 127 of 132March 18, 2014 Regular Meeting Agenda Packet
Trophy Club Municipal Utility District No. 128 of 132March 18, 2014 Regular Meeting Agenda Packet
Trophy Club Municipal Utility District No. 129 of 132March 18, 2014 Regular Meeting Agenda Packet
Trophy Club Municipal Utility District No. 130 of 132March 18, 2014 Regular Meeting Agenda Packet
Trophy Club Municipal Utility District No. 131 of 132March 18, 2014 Regular Meeting Agenda Packet
Trophy Club Municipal Utility District No. 132 of 132March 18, 2014 Regular Meeting Agenda Packet
Fort Worth1100 Macon StreetFort Worth, Texas 76102817.336.5773 Dallas17304 Preston Road, Suite 1340Dallas, Texas 75252214.461.9867
Denton1517 Centre Place Drive, Suite 320Denton, Texas 76205940.383.4177 Sherman200 North Travis Street, Suite 500Sherman, Texas 75090903.870.1089
Registered by the Texas Board of Professional Engineers, Firm No. F-230 Registered by the Texas Board of Professional Surveyors, Firm No. 100116-00
engineers
surveyors
landscape architects
www.tnpinc.com March 6, 2014
Jennifer McKnight
TCMUD District Manager
Town of Trophy Club
100 Municipal Drive
Trophy Club, Texas 76262
Re: Recommendation to Withdraw Contract Award for
Waterline Improvements along Indian Creek Drive
Dear Jennifer:
On July 12, 2013 TNP provided a letter of recommendation to the Trophy Club MUD to award the water
line reconstruction project along Indian Creek Drive to CPS Civil. CPS Civil was the low bidder and based on
information at that time, their references and financial information supported the recommendation to award
the bid.
The original project schedule was to proceed to construction in August of 2013. However, due to the Town’s
inability to negotiate for an easement along the southerly side of Indian Creek the project was delayed. CPS
Civil agreed to honor their bid until the first of 2014 while the easements were being acquired. Once the
easement issue was resolved the first of February, TNP directed CPS to proceed with bonds and contracts for
the project. After a few weeks of delays without receiving the executed contracts and learning of other
financial issues CPS was having on current projects, TNP notified the Town. After further investigation, TNP
confirmed that CPS Civil could not get bonded and it was decided to rebid the project. This was confirmed in
my February 20 email to you, where I informed that the Town decided to re-bid the Indian Creek Drive
reconstruction project.
Based on these recent events, please let this letter serve as our recommendation to the TCMUD that the
previous award to CPS Civil for reconstruction of the waterline improvements be withdrawn and the project
be re-bid. CPS Civil has been notified that due to their inability to obtain the required bonding of the
project, a contract could not be executed by the MUD resulting in a recommendation to withdraw the award.
The new project schedule is projected as follows:
March 16, 2014: Let Project for Bid (21-day bid time)
April 8, 2014: Receive and Open Bids
April 22, 2014: TCMUD Board Meeting – Award to lowest qualified bidder
If there are any questions or recommendations as we look to move forward, feel free to call.
Sincerely,
tnp
teague nall & perkins
Tom Rutledge
Tom Rutledge
Principal
Trophy Club Municipal Utility District No. 1 33 of 132 March 18, 2014 Regular Meeting Agenda Packet
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
RESOLUTION 2014-0318B
RESOLUTION APPROVING SUBMITTAL OF THE WATER SMART
APPLICATION FOR INCLUSION IN THE ASSOCIATION OF WATER
BOARD DIRECTORS WATER SMART PARTNERS PROGRAM
WHEREAS, the Board of Directors (the “Board”) of Trophy Club Municipal Utility District No. 1
(the “District”) has reviewed all the requirements for participation in the Association of Water Board
directors Water Smart Partners Program and has taken concrete stops to help their customers learn the
value of the water they use and to conserve water year-round; and
WHEREAS, the Board has discussed and reviewed the District’s application in its entirety and has
confirmed the inclusion of all necessary documentation required for submission to the Association of
Water Board directors Water Smart Partners Program; and
WHEREAS, the District has fulfilled all the necessary requirements for inclusion in the
Association of Water Board directors Water Smart Partners Program;
NOW, THEREFORE, BE IT RESOLVED BY THE BOARD OF DIRECTORS OF TROPHY CLUB MUNICIPAL
UTILITY DISTRICT NO. 1 THAT:
Section 1. The Board does hereby approve the submittal of the 2014 Water Smart Application
for the period of 1 January 2013 - 31 December 2013 for participation in the Association of Water Board
directors Water Smart Partners Program.
Section 2. The President or any Vice President is authorized to execute and the Secretary or
any Assistant Secretary is authorized to attest this Resolution on behalf of the Board of the District and
to any and all things necessary to carry out the intent hereof.
ADOPTED, APPROVED, AND EFFECTIVE this 18th day of March, 2014.
_____________________________
Jim Moss, President
ATTEST: Board of Directors
____________________________
Kevin R. Carr, Secretary
Board of Directors
Trophy Club Municipal Utility District No. 1 34 of 132 March 18, 2014 Regular Meeting Agenda Packet
TROPHY CLUB MUD #1 - FIRE DEPARTMENT
BALANCE SHEET
FEBRUARY 28, 2014
122
ASSETS FIRE DEPT.
CASH ON HAND -
CASH IN BANK -
INVESTMENTS 1,179,833
PREPAID EXPENSES 11,704
ADVALOREM PROPERTY TAXES RECEIVABLE 63,113
EMERGENCY SERVICES ASSESSMENTS RECEIVABLE 6,121
UTILITY AND OTHER ACCOUNTS RECEIVABLE 938
TOTAL ASSETS 1,261,710
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 69,234
ACCOUNTS AND OTHER PAYABLES 52,443
TOTAL LIABILITIES 121,677
FUND BALANCE
DESIGNATED FOR FUTURE ASSET REPLACEMENT -
NON-SPENDABLE FUND BALANCE 2,141
UNASSIGNED FUND BALANCE 493,547
RESERVE FOR ENCUMBRANCES -
NET REVENUES / EXPENDITURES 644,344
TOTAL FUND BALANCE 1,140,033
TOTAL LIABILITIES AND FUND BALANCE 1,261,710
Trophy Club Municipal Utility District No. 1 35 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 1
11:19 03/07/14 Budget Summary with Amendment
Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program:
Period Ending: 2/2014
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
122-40001-000-000 Assessment - Emerg Svcs 305,445.00- 305,445.00- 15,727.63- 302,755.53- 99.119 2,689.47-
122-40003-000-000 Emer Svcs Assessmen/Delinquent .65- .65
122-40010-000-000 Property Taxes/MUD Fire 927,555.00- 927,555.00- 85,396.09- 878,978.92- 94.763 48,576.08-
122-40011-000-000 Property Taxes/Fire-Delinquent 404.83- 397.34- 397.34
122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- 65.93- 66.08- 8.811 683.92-
122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 1,484.14- 1,597.85- 35.508 2,902.15-
Subtotal: 1,238,250.00- 1,238,250.00- 103,078.62- 1,183,796.37- 95.602 54,453.63-
122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 2,000.00- 33.333 4,000.00-
Subtotal: 6,000.00- 6,000.00- 2,000.00- 33.333 4,000.00-
122-43400-000-000 Fire Inspections 700.00- 700.00- 375.00- 53.571 325.00-
122-43415-000-000 Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00-
Subtotal: 10,700.00- 10,700.00- 375.00- 3.505 10,325.00-
122-49900-000-000 Miscellaneous Income 6,000.00- 6,000.00- 3,425.00- 57.083 2,575.00-
Subtotal: 6,000.00- 6,000.00- 3,425.00- 57.083 2,575.00-
Program number: 1,260,950.00- 1,260,950.00- 103,078.62- 1,189,596.37- 94.341 71,353.63-
Department number: Fire Revenues 1,260,950.00- 1,260,950.00- 103,078.62- 1,189,596.37- 94.341 71,353.63-
Revenues Subtotal ----------- 1,260,950.00- 1,260,950.00- 103,078.62- 1,189,596.37- 94.341 71,353.63-
Trophy Club Municipal Utility District No. 1 36 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 2
11:19 03/07/14 Budget Summary with Amendment
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 2/2014
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
122-50005-045-000 Salaries & Wages 455,916.00 455,916.00 33,967.28 184,918.09 40.560 270,997.91
122-50010-045-000 Overtime 44,225.00 44,225.00 2,687.71 14,087.02 31.853 30,137.98
122-50011-045-000 DPS Holiday Pay 13,529.00 13,529.00 13,289.86 98.232 239.14
122-50016-045-000 Longevity 4,768.00 4,768.00 4,655.00 97.630 113.00
122-50017-045-000 Certification 4,350.00 4,350.00 375.00 1,839.39 42.285 2,510.61
122-50020-045-000 Retirement 70,991.00 70,991.00 5,397.69 30,737.94 43.298 40,253.06
122-50026-045-000 Medical Insurance 56,968.00 56,968.00 4,158.33 20,192.85 35.446 36,775.15
122-50027-045-000 Dental Insurance 4,230.00 4,230.00 339.82 1,644.85 38.885 2,585.15
122-50028-045-000 Vision Insurance 892.00 892.00 72.68 346.25 38.817 545.75
122-50029-045-000 Life Insurance & Other 4,250.00 4,250.00 301.09 1,528.73 35.970 2,721.27
122-50030-045-000 Social Security Taxes 32,980.00 32,980.00 2,095.47 12,618.85 38.262 20,361.15
122-50035-045-000 Medicare Taxes 7,713.00 7,713.00 489.98 2,950.41 38.252 4,762.59
122-50040-045-000 Unemployment Taxes 2,259.00 2,259.00 14.81 67.71 2.997 2,191.29
122-50045-045-000 Workman's Compensation 8,708.00 8,708.00 662.79 3,313.95 38.056 5,394.05
122-50060-045-000 Pre-employment Physicals/Test 500.00 500.00 205.72 205.72 41.144 294.28
122-50075-045-000 Tuition Reimbursement 600.00 600.00 600.00
Subtotal: 712,879.00 712,879.00 50,768.37 292,396.62 41.016 420,482.38
122-55030-045-000 Software & Support 8,682.00 8,682.00 8,682.00
122-55045-045-000 Legal 5,000.00 5,000.00 2,505.51- -50.110 7,505.51
122-55080-045-000 Maintenance & Repairs 20,472.00 20,472.00 1,203.57 4,414.82 21.565 16,057.18
122-55090-045-000 Vehicle Maintenance 14,850.00 14,850.00 980.61 2,580.34 17.376 12,269.66
Subtotal: 49,004.00 49,004.00 2,184.18 4,489.65 9.162 44,514.35
122-60005-045-000 Telephone 100.00 100.00 3.34 3.340 96.66
122-60010-045-000 Communications/Pagers/Mobiles 4,237.00 4,237.00 214.54 1,173.75 27.702 3,063.25
122-60020-045-000 Electricity/Gas 6,568.00 6,568.00 660.71 2,887.30 43.960 3,680.70
122-60025-045-000 Water 1,500.00 1,500.00 106.12 354.63 23.642 1,145.37
122-60030-045-000 Rent And/Or Usage 214,279.00 214,279.00 214,279.00 214,279.00 100.000
122-60035-045-000 Postage 100.00 100.00 6.11 26.53 26.530 73.47
122-60055-045-000 Insurance 12,110.00 12,110.00 1,051.25 5,088.25 42.017 7,021.75
122-60066-045-000 Publications/Books/Subscrips 400.00 400.00 112.75 28.188 287.25
122-60070-045-000 Dues & Memberships 15,180.00 15,180.00 305.00 8,197.64 54.003 6,982.36
122-60080-045-000 Schools & Training 4,280.00 4,280.00 422.00 2,046.00 47.804 2,234.00
122-60096-045-000 Emergency Management 2,000.00 2,000.00 1,000.00 50.000 1,000.00
122-60100-045-000 Travel & per diem 4,577.00 4,577.00 690.41 1,812.01 39.589 2,764.99
122-60110-045-000 Physicals/Testing 2,000.00 2,000.00 2,000.00
122-60125-045-000 Advertising 200.00 200.00 200.00
122-60160-045-000 Programs & Special Projects 4,500.00 4,500.00 341.17 7.582 4,158.83
122-60180-045-000 Fire Inspection/Enforcement 1,500.00 1,500.00 1,500.00
122-60195-045-000 Flags & Repair 2,000.00 2,000.00 37.50 170.25 8.513 1,829.75
122-60243-045-000 Prior Year Expense 3,456.54 3,456.54-
Trophy Club Municipal Utility District No. 1 37 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 3
11:19 03/07/14 Budget Summary with Amendment
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 2/2014
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
122-60245-045-000 Miscellaneous Expense 1,000.00 1,000.00 861.00 1,220.97 122.097 220.97-
Subtotal: 276,531.00 276,531.00 218,633.64 242,170.13 87.574 34,360.87
122-65005-045-000 Fuel & Lube 11,698.00 11,698.00 444.39 3,169.34 27.093 8,528.66
122-65010-045-000 Uniforms 3,360.00 3,360.00 171.90- 319.84 9.519 3,040.16
122-65015-045-000 Protective Clothing 7,600.00 7,600.00 718.87 848.87 11.169 6,751.13
122-65030-045-000 Chemicals 1,000.00 1,000.00 1,000.00
122-65035-045-000 Small Tools 2,500.00 2,500.00 69.98 146.44 5.858 2,353.56
122-65085-045-000 Office Supplies 1,000.00 1,000.00 84.44 8.444 915.56
122-65095-045-000 Maintenance Supplies 111.16 111.16-
122-65105-045-000 Printing 100.00 100.00 100.00
Subtotal: 27,258.00 27,258.00 1,061.34 4,680.09 17.170 22,577.91
122-69008-045-000 Short Term Debt-Principal 70,000.00 70,000.00 70,000.00
122-69009-045-000 Short Term Debt-Interest 3,031.00 3,031.00 1,515.50 1,515.50 50.000 1,515.50
122-69050-045-000 Radios 34,200.00 34,200.00 34,200.00
122-69195-045-000 GASB34/Reserve for Replacement 67,647.00 67,647.00 67,647.00
122-69255-045-000 Airpacks 20,400.00 20,400.00 20,400.00
Subtotal: 195,278.00 195,278.00 1,515.50 1,515.50 .776 193,762.50
Program number: 1,260,950.00 1,260,950.00 274,163.03 545,251.99 43.241 715,698.01
Department number: Fire 1,260,950.00 1,260,950.00 274,163.03 545,251.99 43.241 715,698.01
Expenditures Subtotal ----------- 1,260,950.00 1,260,950.00 274,163.03 545,251.99 43.241 715,698.01
Fund number: 122 Trophy Club MUD Fire Dept. 171,084.41 644,344.38- 644,344.38
Trophy Club Municipal Utility District No. 1 38 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 1
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program:
Period Ending: 2/2014
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
886 02/01/2014 Property Taxes/Assessments (287,027.90) (2,944.65) (289,972.55) GL
887 02/03/2014 Property Taxes/Assessments (2,381.60) (292,354.15) GL
888 02/04/2014 Property Taxes/Assessments (3,147.67) (295,501.82) GL
889 02/05/2014 Property Taxes/Assessments (4,045.16) (299,546.98) GL
890 02/06/2014 Property Taxes/Assessments (1,310.16) (300,857.14) GL
891 02/07/2014 Property Taxes/Assessments (1,380.43) (302,237.57) GL
893 02/12/2014 Property Taxes/Assessments (44.47) (302,282.04) GL
894 02/13/2014 Property Taxes/Assessments (32.88) (302,314.92) GL
897 02/20/2014 Property Taxes/Assessments (431.64) (302,746.56) GL
898 02/24/2014 Property Taxes/Assessments (8.97) (302,755.53) GL
_______________
Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (15,727.63) (302,755.53) **
(305,445.00) Budgeted (2,689.47) Remaining 99 % Used
Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent
(.65) .00 (.65)
_______________
Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: .00 (.65) **
.00 Budgeted .65 Remaining 0 % Used
Account: 122-40010-000-000 Property Taxes/MUD Fire
886 02/01/2014 Property Taxes/Assessments (793,582.83) (18,162.10) (811,744.93) GL
887 02/03/2014 Property Taxes/Assessments (8,462.79) (820,207.72) GL
888 02/04/2014 Property Taxes/Assessments (5,885.37) (826,093.09) GL
889 02/05/2014 Property Taxes/Assessments (14,936.94) (841,030.03) GL
890 02/06/2014 Property Taxes/Assessments (3,450.95) (844,480.98) GL
891 02/07/2014 Property Taxes/Assessments (14,129.92) (858,610.90) GL
892 02/10/2014 Property Taxes/Assessments (8.28) (858,619.18) GL
893 02/12/2014 Property Taxes/Assessments (740.90) (859,360.08) GL
894 02/13/2014 Property Taxes/Assessments (1,445.48) (860,805.56) GL
895 02/14/2014 Property Taxes/Assessments (104.63) (860,910.19) GL
896 02/18/2014 Property Taxes/Assessments (17,177.39) (878,087.58) GL
897 02/20/2014 Property Taxes/Assessments (48.78) (878,136.36) GL
898 02/24/2014 Property Taxes/Assessments (528.12) (878,664.48) GL
899 02/25/2014 Property Taxes/Assessments (18.70) (878,683.18) GL
900 02/27/2014 Property Taxes/Assessments (295.74) (878,978.92) GL
_______________
Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (85,396.09) (878,978.92) **
(927,555.00) Budgeted (48,576.08) Remaining 95 % Used
Trophy Club Municipal Utility District No. 1 39 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 2
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 122-40011-000-000 Property Taxes/Fire-Delinquent
901 02/28/2014 Property Taxes/Assessments 7.49 (404.83) (397.34) GL
_______________
Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (404.83) (397.34) **
.00 Budgeted 397.34 Remaining 0 % Used
Account: 122-40015-000-000 Property Taxes/Assessments P&I
889 02/05/2014 Property Taxes/Assessments (.15) (29.67) (29.82) GL
893 02/12/2014 Property Taxes/Assessments (3.11) (32.93) GL
894 02/13/2014 Property Taxes/Assessments (2.30) (35.23) GL
897 02/20/2014 Property Taxes/Assessments (30.22) (65.45) GL
898 02/24/2014 Property Taxes/Assessments (.63) (66.08) GL
_______________
Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: (65.93) (66.08) **
(750.00) Budgeted (683.92) Remaining 9 % Used
Account: 122-40020-000-000 Property Taxes/Fire P&I
887 02/03/2014 Property Taxes/Assessments (113.71) (7.32) (121.03) GL
888 02/04/2014 Property Taxes/Assessments (19.59) (140.62) GL
889 02/05/2014 Property Taxes/Assessments (.51) (141.13) GL
890 02/06/2014 Property Taxes/Assessments (13.58) (154.71) GL
892 02/10/2014 Property Taxes/Assessments (12.49) (167.20) GL
893 02/12/2014 Property Taxes/Assessments (47.36) (214.56) GL
894 02/13/2014 Property Taxes/Assessments (92.45) (307.01) GL
895 02/14/2014 Property Taxes/Assessments (7.33) (314.34) GL
896 02/18/2014 Property Taxes/Assessments (1,202.40) (1,516.74) GL
897 02/20/2014 Property Taxes/Assessments (3.42) (1,520.16) GL
898 02/24/2014 Property Taxes/Assessments (36.97) (1,557.13) GL
899 02/25/2014 Property Taxes/Assessments (1.31) (1,558.44) GL
900 02/27/2014 Property Taxes/Assessments (20.70) (1,579.14) GL
901 02/28/2014 Property Taxes/Assessments (18.71) (1,597.85) GL
_______________
Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (1,484.14) (1,597.85) **
(4,500.00) Budgeted (2,902.15) Remaining 36 % Used
Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft
(2,000.00) .00 (2,000.00)
_______________
Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: .00 (2,000.00) **
(6,000.00) Budgeted (4,000.00) Remaining 33 % Used
Trophy Club Municipal Utility District No. 1 40 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 3
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 122-43400-000-000 Fire Inspections
(375.00) .00 (375.00)
_______________
Account: 122-43400-000-000 Fire Inspections Totals: .00 (375.00) **
(700.00) Budgeted (325.00) Remaining 54 % Used
Account: 122-43415-000-000 Denton County Pledge-Fire
.00 .00
_______________
Account: 122-43415-000-000 Denton County Pledge-Fire Totals: .00 .00 **
(10,000.00) Budgeted (10,000.00) Remaining 0 % Used
Account: 122-49900-000-000 Miscellaneous Income
(3,425.00) .00 (3,425.00)
_______________
Account: 122-49900-000-000 Miscellaneous Income Totals: .00 (3,425.00) **
(6,000.00) Budgeted (2,575.00) Remaining 57 % Used
Department Totals: ------------------------------------------------------------------------------------------------ (1,189,596.37) **
(1,260,950.00) Budgeted (71,353.63) Remaining 94 % Used
Trophy Club Municipal Utility District No. 1 41 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 4
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 2/2014
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
812 02/14/2014 FD 2/14/14 Payroll 150,950.81 17,697.75 168,648.56 GL
867 02/28/2014 FD Payroll 2/28/14 16,269.53 184,918.09 GL
_______________
Account: 122-50005-045-000 Salaries & Wages Totals: 33,967.28 184,918.09 **
455,916.00 Budgeted 270,997.91 Remaining 41 % Used
Account: 122-50010-045-000 Overtime
812 02/14/2014 FD 2/14/14 Payroll 11,399.31 2,687.71 14,087.02 GL
_______________
Account: 122-50010-045-000 Overtime Totals: 2,687.71 14,087.02 **
44,225.00 Budgeted 30,137.98 Remaining 32 % Used
Account: 122-50011-045-000 DPS Holiday Pay
13,289.86 .00 13,289.86
_______________
Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 13,289.86 **
13,529.00 Budgeted 239.14 Remaining 98 % Used
Account: 122-50016-045-000 Longevity
4,655.00 .00 4,655.00
_______________
Account: 122-50016-045-000 Longevity Totals: .00 4,655.00 **
4,768.00 Budgeted 113.00 Remaining 98 % Used
Account: 122-50017-045-000 Certification
812 02/14/2014 FD 2/14/14 Payroll 1,464.39 375.00 1,839.39 GL
_______________
Account: 122-50017-045-000 Certification Totals: 375.00 1,839.39 **
4,350.00 Budgeted 2,510.61 Remaining 42 % Used
Account: 122-50020-045-000 Retirement
812 02/14/2014 FD 2/14/14 Payroll 25,340.25 3,036.62 28,376.87 GL
867 02/28/2014 FD Payroll 2/28/14 2,361.07 30,737.94 GL
_______________
Account: 122-50020-045-000 Retirement Totals: 5,397.69 30,737.94 **
70,991.00 Budgeted 40,253.06 Remaining 43 % Used
Trophy Club Municipal Utility District No. 1 42 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 5
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 2/2014
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
812 02/14/2014 FD 2/14/14 Payroll 16,034.52 2,488.38 18,522.90 GL
867 02/28/2014 FD Payroll 2/28/14 1,669.95 20,192.85 GL
_______________
Account: 122-50026-045-000 Medical Insurance Totals: 4,158.33 20,192.85 **
56,968.00 Budgeted 36,775.15 Remaining 35 % Used
Account: 122-50027-045-000 Dental Insurance
812 02/14/2014 FD 2/14/14 Payroll 1,305.03 176.38 1,481.41 GL
867 02/28/2014 FD Payroll 2/28/14 163.44 1,644.85 GL
_______________
Account: 122-50027-045-000 Dental Insurance Totals: 339.82 1,644.85 **
4,230.00 Budgeted 2,585.15 Remaining 39 % Used
Account: 122-50028-045-000 Vision Insurance
812 02/14/2014 FD 2/14/14 Payroll 273.57 40.75 314.32 GL
867 02/28/2014 FD Payroll 2/28/14 31.93 346.25 GL
_______________
Account: 122-50028-045-000 Vision Insurance Totals: 72.68 346.25 **
892.00 Budgeted 545.75 Remaining 39 % Used
Account: 122-50029-045-000 Life Insurance & Other
812 02/14/2014 FD 2/14/14 Payroll 1,227.64 156.11 1,383.75 GL
867 02/28/2014 FD Payroll 2/28/14 144.98 1,528.73 GL
_______________
Account: 122-50029-045-000 Life Insurance & Other Totals: 301.09 1,528.73 **
4,250.00 Budgeted 2,721.27 Remaining 36 % Used
Account: 122-50030-045-000 Social Security Taxes
812 02/14/2014 FD 2/14/14 Payroll 10,523.38 1,181.26 11,704.64 GL
867 02/28/2014 FD Payroll 2/28/14 914.21 12,618.85 GL
_______________
Account: 122-50030-045-000 Social Security Taxes Totals: 2,095.47 12,618.85 **
32,980.00 Budgeted 20,361.15 Remaining 38 % Used
Account: 122-50035-045-000 Medicare Taxes
812 02/14/2014 FD 2/14/14 Payroll 2,460.43 276.19 2,736.62 GL
867 02/28/2014 FD Payroll 2/28/14 213.79 2,950.41 GL
Trophy Club Municipal Utility District No. 1 43 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 6
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
_______________
Account: 122-50035-045-000 Medicare Taxes Totals: 489.98 2,950.41 **
7,713.00 Budgeted 4,762.59 Remaining 38 % Used
Account: 122-50040-045-000 Unemployment Taxes
812 02/14/2014 FD 2/14/14 Payroll 52.90 11.95 64.85 GL
867 02/28/2014 FD Payroll 2/28/14 2.86 67.71 GL
_______________
Account: 122-50040-045-000 Unemployment Taxes Totals: 14.81 67.71 **
2,259.00 Budgeted 2,191.29 Remaining 3 % Used
Account: 122-50045-045-000 Workman's Compensation
120 02/01/2014 FD Feb W/C expense 2,651.16 662.79 3,313.95 GL
_______________
Account: 122-50045-045-000 Workman's Compensation Totals: 662.79 3,313.95 **
8,708.00 Budgeted 5,394.05 Remaining 38 % Used
Account: 122-50060-045-000 Pre-employment Physicals/Test
870 02/26/2014 Feb A/P Charter, Verizon, 1st Check, P 23.22 23.22 TOWN OF TROPHY CLUB 33503 AP
870 02/26/2014 Feb A/P Charter, Verizon, 1st Check, P 112.50 135.72 TOWN OF TROPHY CLUB 33503 AP
870 02/26/2014 Feb A/P CareNow, Shi 35.00 170.72 TOWN OF TROPHY CLUB 33503 AP
875 02/27/2014 Feb A/P CareNow, Shi, Premier, Symonds 35.00 205.72 TOWN OF TROPHY CLUB 33507 AP
_______________
Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: 205.72 205.72 **
500.00 Budgeted 294.28 Remaining 41 % Used
Account: 122-50075-045-000 Tuition Reimbursement
.00 .00
_______________
Account: 122-50075-045-000 Tuition Reimbursement Totals: .00 .00 **
600.00 Budgeted 600.00 Remaining 0 % Used
Account: 122-55030-045-000 Software & Support
.00 .00
_______________
Account: 122-55030-045-000 Software & Support Totals: .00 .00 **
8,682.00 Budgeted 8,682.00 Remaining 0 % Used
Trophy Club Municipal Utility District No. 1 44 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 7
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 122-55045-045-000 Legal
(2,505.51) .00 (2,505.51)
_______________
Account: 122-55045-045-000 Legal Totals: .00 (2,505.51) **
5,000.00 Budgeted 7,505.51 Remaining -50 % Used
Account: 122-55080-045-000 Maintenance & Repairs
817 02/07/2014 Firefighters/Feb Cable 3,211.25 (133.71) 3,077.54 GL
808 02/14/2014 Feb A/P Pest Control/Fire Station 140.00 3,217.54 GANN'S PEST CONTROL 33439 AP
808 02/14/2014 Feb A/P Door repair/Fire Station 170.00 3,387.54 OVERHEAD DOOR FORT WORTH 33457 AP
927 02/26/2014 1/28/14-2/26/14 PCards GARDNER 800-521-6535 22.80 3,410.34 GARDNER 800-521-6535 PC
927 02/26/2014 1/28/14-2/26/14 PCards THE HOME DEPOT 6581 79.40 3,489.74 THE HOME DEPOT 6581 PC
927 02/26/2014 1/28/14-2/26/14 PCards THE HOME DEPOT 6581 117.50 3,607.24 THE HOME DEPOT 6581 PC
927 02/26/2014 1/28/14-2/26/14 PCards SAMSCLUB #4795 168.85 3,776.09 SAMSCLUB #4795 PC
927 02/26/2014 1/28/14-2/26/14 PCards THE HOME DEPOT 6581 11.98 3,788.07 THE HOME DEPOT 6581 PC
927 02/26/2014 1/28/14-2/26/14 PCards THE HOME DEPOT 6581 43.27 3,831.34 THE HOME DEPOT 6581 PC
927 02/26/2014 1/28/14-2/26/14 PCards KELLER TROPHY AND AWAR 40.00 3,871.34 KELLER TROPHY AND AWAR PC
927 02/26/2014 1/28/14-2/26/14 PCards SAMSCLUB #4795 178.38 4,049.72 SAMSCLUB #4795 PC
927 02/26/2014 1/28/14-2/26/14 PCards AT&T*BILL PAYMENT 133.71 4,183.43 AT&T*BILL PAYMENT PC
927 02/26/2014 1/28/14-2/26/14 PCards AT&T*BILL PAYMENT 157.86 4,341.29 AT&T*BILL PAYMENT PC
870 02/26/2014 Feb A/P Rug Service 24.51 4,365.80 G & K SERVICES 33489 AP
870 02/26/2014 Feb A/P Rug service 24.51 4,390.31 G & K SERVICES 33489 AP
870 02/26/2014 Feb A/P Rug Service 24.51 4,414.82 G & K SERVICES 33489 AP
870 02/26/2014 Feb A/P Rug Service 24.51 4,439.33 G & K SERVICES 33489 AP
945 02/28/2014 Town Billed Inv 1137-1147 AR 20140201-20140228 User: (24.51) 4,414.82 AR
_______________
Account: 122-55080-045-000 Maintenance & Repairs Totals: 1,203.57 4,414.82 **
20,472.00 Budgeted 16,057.18 Remaining 22 % Used
Account: 122-55090-045-000 Vehicle Maintenance
808 02/14/2014 Feb A/P Ground ladders, Aerial inspect 1,599.73 921.00 2,520.73 CONSOLIDATED FLEET SERVICES 33427 AP
927 02/26/2014 1/28/14-2/26/14 PCards AMAZON MKTPLACE PMTS 59.61 2,580.34 AMAZON MKTPLACE PMTS PC
_______________
Account: 122-55090-045-000 Vehicle Maintenance Totals: 980.61 2,580.34 **
14,850.00 Budgeted 12,269.66 Remaining 17 % Used
Account: 122-60005-045-000 Telephone
3.34 .00 3.34
_______________
Account: 122-60005-045-000 Telephone Totals: .00 3.34 **
100.00 Budgeted 96.66 Remaining 3 % Used
Trophy Club Municipal Utility District No. 1 45 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 8
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 122-60010-045-000 Communications/Pagers/Mobiles
812 02/14/2014 FD 2/14/14 Payroll 959.21 75.00 1,034.21 GL
870 02/26/2014 Feb A/P Charter, Verizon, 1st Check, P 139.54 1,173.75 TOWN OF TROPHY CLUB 33503 AP
_______________
Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 214.54 1,173.75 **
4,237.00 Budgeted 3,063.25 Remaining 28 % Used
Account: 122-60020-045-000 Electricity/Gas
870 02/26/2014 Feb A/P Fire Station electricity 1/13/ 2,226.59 800.90 3,027.49 HUDSON ENERGY SERVICES, LLC 33492 AP
870 02/26/2014 Feb A/P Fire Station gas 1/21/14-2/19/ 520.52 3,548.01 ATMOS ENERGY 33478 AP
945 02/28/2014 Town Billed Inv 1137-1147 AR 20140201-20140228 User: (660.71) 2,887.30 AR
_______________
Account: 122-60020-045-000 Electricity/Gas Totals: 660.71 2,887.30 **
6,568.00 Budgeted 3,680.70 Remaining 44 % Used
Account: 122-60025-045-000 Water
808 02/14/2014 Feb A/P Jan water billed 248.51 129.12 377.63 TROPHY CLUB MUD (WATER BILLS) 33473 AP
808 02/14/2014 Feb A/P Jan water billed 58.21 435.84 TROPHY CLUB MUD (WATER BILLS) 33473 AP
945 02/28/2014 Town Billed Inv 1137-1147 AR 20140201-20140228 User: (81.21) 354.63 AR
_______________
Account: 122-60025-045-000 Water Totals: 106.12 354.63 **
1,500.00 Budgeted 1,145.37 Remaining 24 % Used
Account: 122-60030-045-000 Rent And/Or Usage
902 02/04/2014 FD Rent to I&S 214,279.00 214,279.00 GL
_______________
Account: 122-60030-045-000 Rent And/Or Usage Totals: 214,279.00 214,279.00 **
214,279.00 Budgeted .00 Remaining 100 % Used
Account: 122-60035-045-000 Postage
932 02/28/2014 MUD Postage Meter usage/Feb 20.42 6.11 26.53 GL
_______________
Account: 122-60035-045-000 Postage Totals: 6.11 26.53 **
100.00 Budgeted 73.47 Remaining 27 % Used
Account: 122-60055-045-000 Insurance
51 02/01/2014 Feb Ins & W/C Expense 4,037.00 1,009.25 5,046.25 GL
870 02/26/2014 Feb A/P Notary, Schaefer, D'Andria 42.00 5,088.25 VICTOR O SCHINNERER & CO, INC 33504 AP
Trophy Club Municipal Utility District No. 1 46 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 9
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
_______________
Account: 122-60055-045-000 Insurance Totals: 1,051.25 5,088.25 **
12,110.00 Budgeted 7,021.75 Remaining 42 % Used
Account: 122-60066-045-000 Publications/Books/Subscrips
112.75 .00 112.75
_______________
Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 112.75 **
400.00 Budgeted 287.25 Remaining 28 % Used
Account: 122-60070-045-000 Dues & Memberships
808 02/14/2014 Feb A/P 2014 Annual membership dues 7,892.64 280.00 8,172.64 DENTON CO FIRE CHIEFS ASSOC 33429 AP
927 02/26/2014 1/28/14-2/26/14 PCards TEXAS ASSOCIATION OF F 25.00 8,197.64 TEXAS ASSOCIATION OF F PC
_______________
Account: 122-60070-045-000 Dues & Memberships Totals: 305.00 8,197.64 **
15,180.00 Budgeted 6,982.36 Remaining 54 % Used
Account: 122-60080-045-000 Schools & Training
927 02/26/2014 1/28/14-2/26/14 PCards FIRE PROTECTION PUB-WE 1,624.00 57.00 1,681.00 FIRE PROTECTION PUB-WE PC
927 02/26/2014 1/28/14-2/26/14 PCards TEEX 979 458 6903 365.00 2,046.00 TEEX 979 458 6903 PC
_______________
Account: 122-60080-045-000 Schools & Training Totals: 422.00 2,046.00 **
4,280.00 Budgeted 2,234.00 Remaining 48 % Used
Account: 122-60096-045-000 Emergency Management
1,000.00 .00 1,000.00
_______________
Account: 122-60096-045-000 Emergency Management Totals: .00 1,000.00 **
2,000.00 Budgeted 1,000.00 Remaining 50 % Used
Account: 122-60100-045-000 Travel & per diem
927 02/26/2014 1/28/14-2/26/14 PCards EMBASSY SUITES 1,121.60 677.04 1,798.64 EMBASSY SUITES PC
927 02/26/2014 1/28/14-2/26/14 PCards BJ'S RESTAURANTS 525 13.37 1,812.01 BJ'S RESTAURANTS 525 PC
_______________
Account: 122-60100-045-000 Travel & per diem Totals: 690.41 1,812.01 **
4,577.00 Budgeted 2,764.99 Remaining 40 % Used
Account: 122-60110-045-000 Physicals/Testing
Trophy Club Municipal Utility District No. 1 47 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 10
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
.00 .00
_______________
Account: 122-60110-045-000 Physicals/Testing Totals: .00 .00 **
2,000.00 Budgeted 2,000.00 Remaining 0 % Used
Account: 122-60125-045-000 Advertising
.00 .00
_______________
Account: 122-60125-045-000 Advertising Totals: .00 .00 **
200.00 Budgeted 200.00 Remaining 0 % Used
Account: 122-60160-045-000 Programs & Special Projects
341.17 .00 341.17
_______________
Account: 122-60160-045-000 Programs & Special Projects Totals: .00 341.17 **
4,500.00 Budgeted 4,158.83 Remaining 8 % Used
Account: 122-60180-045-000 Fire Inspection/Enforcement
.00 .00
_______________
Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: .00 .00 **
1,500.00 Budgeted 1,500.00 Remaining 0 % Used
Account: 122-60195-045-000 Flags & Repair
875 02/27/2014 Feb A/P CareNow, Shi, Premier, Symonds 132.75 37.50 170.25 TOWN OF TROPHY CLUB 33507 AP
_______________
Account: 122-60195-045-000 Flags & Repair Totals: 37.50 170.25 **
2,000.00 Budgeted 1,829.75 Remaining 9 % Used
Account: 122-60243-045-000 Prior Year Expense
3,456.54 .00 3,456.54
_______________
Account: 122-60243-045-000 Prior Year Expense Totals: .00 3,456.54 **
.00 Budgeted (3,456.54) Remaining 0 % Used
Account: 122-60245-045-000 Miscellaneous Expense
860 02/24/2014 Town Pay Inv 1123,1126-1136 AR 20140224-20140224 User: 359.97 861.00 1,220.97 AR
Trophy Club Municipal Utility District No. 1 48 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 11
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
_______________
Account: 122-60245-045-000 Miscellaneous Expense Totals: 861.00 1,220.97 **
1,000.00 Budgeted (220.97) Remaining 122 % Used
Account: 122-65005-045-000 Fuel & Lube
904 02/28/2014 February Gas Log 2,724.95 444.39 3,169.34 GL
_______________
Account: 122-65005-045-000 Fuel & Lube Totals: 444.39 3,169.34 **
11,698.00 Budgeted 8,528.66 Remaining 27 % Used
Account: 122-65010-045-000 Uniforms
945 02/28/2014 Town Billed Inv 1137-1147 AR 20140201-20140228 User: 491.74 (171.90) 319.84 AR
_______________
Account: 122-65010-045-000 Uniforms Totals: (171.90) 319.84 **
3,360.00 Budgeted 3,040.16 Remaining 10 % Used
Account: 122-65015-045-000 Protective Clothing
927 02/26/2014 1/28/14-2/26/14 PCards WITMER PUBLIC SAFETY G 130.00 206.53 336.53 WITMER PUBLIC SAFETY G PC
927 02/26/2014 1/28/14-2/26/14 PCards HAIX NORTH AMERICA 243.95 580.48 HAIX NORTH AMERICA PC
927 02/26/2014 1/28/14-2/26/14 PCards WARMING COOL STORE 95.96 676.44 WARMING COOL STORE PC
870 02/26/2014 Feb A/P JPChase PCards 172.43 848.87 TOWN OF TROPHY CLUB 33503 AP
_______________
Account: 122-65015-045-000 Protective Clothing Totals: 718.87 848.87 **
7,600.00 Budgeted 6,751.13 Remaining 11 % Used
Account: 122-65030-045-000 Chemicals
.00 .00
_______________
Account: 122-65030-045-000 Chemicals Totals: .00 .00 **
1,000.00 Budgeted 1,000.00 Remaining 0 % Used
Account: 122-65035-045-000 Small Tools
927 02/26/2014 1/28/14-2/26/14 PCards WILDFIRE TRUCK & EQUIP 76.46 69.98 146.44 WILDFIRE TRUCK & EQUIP PC
_______________
Account: 122-65035-045-000 Small Tools Totals: 69.98 146.44 **
2,500.00 Budgeted 2,353.56 Remaining 6 % Used
Account: 122-65085-045-000 Office Supplies
Trophy Club Municipal Utility District No. 1 49 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 12
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
84.44 .00 84.44
_______________
Account: 122-65085-045-000 Office Supplies Totals: .00 84.44 **
1,000.00 Budgeted 915.56 Remaining 8 % Used
Account: 122-65095-045-000 Maintenance Supplies
111.16 .00 111.16
_______________
Account: 122-65095-045-000 Maintenance Supplies Totals: .00 111.16 **
.00 Budgeted (111.16) Remaining 0 % Used
Account: 122-65105-045-000 Printing
.00 .00
_______________
Account: 122-65105-045-000 Printing Totals: .00 .00 **
100.00 Budgeted 100.00 Remaining 0 % Used
Account: 122-69008-045-000 Short Term Debt-Principal
.00 .00
_______________
Account: 122-69008-045-000 Short Term Debt-Principal Totals: .00 .00 **
70,000.00 Budgeted 70,000.00 Remaining 0 % Used
Account: 122-69009-045-000 Short Term Debt-Interest
880 02/27/2014 Wires for Bond payments MUD1 Public Prop CO 2007 1,515.50 1,515.50 GL
_______________
Account: 122-69009-045-000 Short Term Debt-Interest Totals: 1,515.50 1,515.50 **
3,031.00 Budgeted 1,515.50 Remaining 50 % Used
Account: 122-69050-045-000 Radios
.00 .00
_______________
Account: 122-69050-045-000 Radios Totals: .00 .00 **
34,200.00 Budgeted 34,200.00 Remaining 0 % Used
Account: 122-69195-045-000 GASB34/Reserve for Replacement
.00 .00
Trophy Club Municipal Utility District No. 1 50 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 13
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
_______________
Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 .00 **
67,647.00 Budgeted 67,647.00 Remaining 0 % Used
Account: 122-69255-045-000 Airpacks
.00 .00
_______________
Account: 122-69255-045-000 Airpacks Totals: .00 .00 **
20,400.00 Budgeted 20,400.00 Remaining 0 % Used
Department 45 Totals: ------------------------------------------------------------------------------------------------ 545,251.99 **
1,260,950.00 Budgeted 715,698.01 Remaining 43 % Used
Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (644,344.38)
.00 Budgeted 644,344.38 Remaining 0 % Used
Trophy Club Municipal Utility District No. 1 51 of 132 March 18, 2014 Regular Meeting Agenda Packet
TROPHY CLUB MUD #1 - O&M
BALANCE SHEET
FEBRUARY 28, 2014
GENERAL
FUND GASB
CAPITAL
PROJECTS
COMBINED
BALANCE @
2/28/14
ASSETS
CASH ON HAND 600 - - 600
CASH IN BANK 85,786 - - 85,786
INVESTMENTS-MONEY MARKET-BANK OF THE WEST 1,501,881 - - 1,501,881
INVESTMENTS-TEXPOOL 1,020,376 313,050 162,518 1,495,943
PREPAID EXPENSES 46,403 - - 46,403
ADVALOREM PROPERTY TAXES RECEIVABLE 7,100 - - 7,100
UTILITY AND OTHER ACCOUNTS RECEIVABLE 488,717 - - 488,717
-
TOTAL ASSETS 3,150,864 313,050 162,518 3,626,431
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 7,100 - - 7,100
ACCOUNTS AND OTHER PAYABLES 145,881 - - 145,881
CUSTOMER DEPOSITS 244,337 - - 244,337
-
TOTAL LIABILITIES 397,318 - - 397,318
FUND BALANCE
DESIGNATED FOR FUTURE ASSET REPLACEMENT - 313,050 313,050
NON-SPENDABLE FUND BALANCE 29,524 29,524
ASSIGNED FUND BALANCE 276,500 245,101 521,601
UNASSIGNED FUND BALANCE 2,682,452 - - 2,682,452
RESERVE FOR ENCUMBRANCES - - - -
NET REVENUES / EXPENDITURES (234,930) - (82,583) (317,513)
-
TOTAL FUND BALANCE 2,753,546 313,050 162,518 3,229,114
-
TOTAL LIABILITIES AND FUND BALANCE 3,150,864 313,050 162,518 3,626,431
Trophy Club Municipal Utility District No. 1 52 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 4
11:19 03/07/14 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 2/2014
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-40000-000-000 Property Taxes 99,250.00- 99,250.00- 9,181.05- 94,097.48- 94.809 5,152.52-
135-40002-000-000 Property Taxes/Delinquent .79- 1.47- 1.47
135-40015-000-000 Property Taxes/P & I 900.00- 900.00- 158.03- 147.23- 16.359 752.77-
Subtotal: 100,150.00- 100,150.00- 9,339.87- 94,246.18- 94.105 5,903.82-
135-43215-000-000 Insurance Settlement 82.36- 82.36
Subtotal: 82.36- 82.36
135-47000-000-000 Water 3,749,310.00- 3,749,310.00- 161,407.89- 924,314.81- 24.653 2,824,995.19-
135-47005-000-000 Sewer 1,708,321.00- 1,708,321.00- 136,445.68- 698,011.88- 40.860 1,010,309.12-
135-47025-000-000 Penalties 64,522.00- 64,522.00- 4,670.65- 20,486.41- 31.751 44,035.59-
135-47030-000-000 Service Charges 9,075.00- 9,075.00- 403.00- 3,665.00- 40.386 5,410.00-
135-47035-000-000 Plumbing Inspections 1,200.00- 1,200.00- 100.00- 900.00- 75.000 300.00-
135-47045-000-000 Sewer Inspections 4,400.00- 4,400.00- 300.00- 2,850.00- 64.773 1,550.00-
135-47070-000-000 TCCC Effluent Charges 79,586.00- 79,586.00- 228.90- 8,053.18- 10.119 71,532.82-
Subtotal: 5,616,414.00- 5,616,414.00- 303,556.12- 1,658,281.28- 29.526 3,958,132.72-
135-48005-000-000 Utility Fees 582,109.00- 582,109.00- 27,600.00- 174,800.00- 30.029 407,309.00-
Subtotal: 582,109.00- 582,109.00- 27,600.00- 174,800.00- 30.029 407,309.00-
135-49010-000-000 Interest Income 4,800.00- 4,800.00- 465.35- 2,542.90- 52.977 2,257.10-
135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 4,552.65- 44.792 5,611.35-
135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 2,916.65- 41.666 4,083.35-
135-49030-000-000 Vending Revenue 350.00- 350.00- 98.00- 28.000 252.00-
135-49036-000-000 GASB Reserves 8,964.00- 8,964.00- 8,964.00-
135-49075-000-000 Oversize Meter Reimbursement 84,000.00- 84,000.00- 4,802.00- 37,028.77- 44.082 46,971.23-
135-49900-000-000 Miscellaneous Income 3,000.00- 3,000.00- 1,004.80- 1,158.08- 38.603 1,841.92-
135-49901-000-000 Records Management Revenue 100.00- 100.00- 100.00-
135-49903-000-000 Recovery of Prior Year Expense 4,087.00- 4,087.00- 4,087.00
135-49905-000-000 Gas Well Revenue 886.00- 886.00- 886.00-
Subtotal: 119,264.00- 119,264.00- 11,853.01- 52,384.05- 43.923 66,879.95-
Program number: 6,417,937.00- 6,417,937.00- 352,349.00- 1,979,793.87- 30.848 4,438,143.13-
Department number: Revenues 6,417,937.00- 6,417,937.00- 352,349.00- 1,979,793.87- 30.848 4,438,143.13-
Revenues Subtotal ----------- 6,417,937.00- 6,417,937.00- 352,349.00- 1,979,793.87- 30.848 4,438,143.13-
Trophy Club Municipal Utility District No. 1 53 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 5
11:19 03/07/14 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 2/2014
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-50005-010-000 Salaries & Wages 287,709.00 287,709.00 21,716.28 107,088.41 37.221 180,620.59
135-50010-010-000 Overtime 13,391.00 13,391.00 1,371.92 7,907.05 59.047 5,483.95
135-50016-010-000 Longevity 4,905.00 4,905.00 4,905.00 100.000
135-50017-010-000 Certification 5,100.00 5,100.00 350.00 1,650.00 32.353 3,450.00
135-50020-010-000 Retirement 27,847.00 27,847.00 2,104.75 11,359.20 40.791 16,487.80
135-50026-010-000 Medical Insurance 48,334.00 48,334.00 3,439.98 15,340.59 31.739 32,993.41
135-50027-010-000 Dental Insurance 3,932.00 3,932.00 249.12 1,178.73 29.978 2,753.27
135-50028-010-000 Vision Insurance 873.00 873.00 63.03 280.93 32.180 592.07
135-50029-010-000 Life Insurance & Other 3,306.00 3,306.00 236.86 1,002.10 30.312 2,303.90
135-50030-010-000 Social Security Taxes 19,289.00 19,289.00 1,441.79 7,884.17 40.874 11,404.83
135-50035-010-000 Medicare Taxes 4,511.00 4,511.00 337.18 1,843.88 40.875 2,667.12
135-50040-010-000 Unemployment Taxes 54.00 54.00 13.82 52.65 97.500 1.35
135-50045-010-000 Workman's Compensation 9,829.00 9,829.00 802.45 4,012.25 40.821 5,816.75
135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 233.90 116.950 33.90-
135-50070-010-000 Employee Relations 300.00 300.00 22.01 107.78 35.927 192.22
Subtotal: 429,580.00 429,580.00 32,149.19 164,846.64 38.374 264,733.36
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 13,433.23 38,635.42 77.271 11,364.58
135-55090-010-000 Vehicle Maintenance 5,000.00 5,000.00 714.14 1,790.95 35.819 3,209.05
135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 248.33 7.095 3,251.67
135-55135-010-000 Lab Analysis 5,500.00 5,500.00 310.00 990.00 18.000 4,510.00
Subtotal: 67,000.00 67,000.00 14,457.37 41,664.70 62.186 25,335.30
135-60010-010-000 Communications/Pagers/Mobiles 4,913.00 4,913.00 383.39 1,531.19 31.166 3,381.81
135-60020-010-000 Electricity 162,160.00 162,160.00 6,807.48 41,233.51 25.428 120,926.49
135-60066-010-000 Publications/Books/Subscripts 500.00 500.00 500.00
135-60070-010-000 Dues & Memberships 150.00 150.00 289.00 192.667 139.00-
135-60080-010-000 Schools & Training 4,184.00 4,184.00 70.00 770.00 18.403 3,414.00
135-60090-010-000 Safety Program 400.00 400.00 400.00
135-60100-010-000 Travel & per diem 1,450.00 1,450.00 171.13 11.802 1,278.87
135-60105-010-000 Rent/Lease Equipment 500.00 500.00 6.00 24.00 4.800 476.00
135-60135-010-000 TCEQ Fees & Permits 47,400.00 47,400.00 2,840.20 32,195.79 67.924 15,204.21
135-60150-010-000 Wholesale Water 2,338,473.00 2,338,473.00 114,917.03 504,472.51 21.573 1,834,000.49
135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00
135-60280-010-000 Property Maintenance 3,500.00 3,500.00 150.00 678.70 19.391 2,821.30
135-60285-010-000 Lawn Equipment & Maintenance 250.00 250.00 250.00
135-60360-010-000 Furniture/Equipment < $5000 3,500.00 3,500.00 3,500.00
Subtotal: 2,567,580.00 2,567,580.00 125,174.10 581,365.83 22.643 1,986,214.17
135-65005-010-000 Fuel & Lube 23,181.00 23,181.00 921.25 4,770.70 20.580 18,410.30
Trophy Club Municipal Utility District No. 1 54 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 6
11:19 03/07/14 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 2/2014
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-65010-010-000 Uniforms 3,270.00 3,270.00 1,831.63 56.013 1,438.37
135-65030-010-000 Chemicals 5,000.00 5,000.00 622.20 2,667.29 53.346 2,332.71
135-65035-010-000 Small Tools 1,200.00 1,200.00 464.94 38.745 735.06
135-65040-010-000 Safety Equipment 1,000.00 1,000.00 137.94 322.67 32.267 677.33
135-65050-010-000 Meter Expense 143,550.00 143,550.00 2,215.00 59,392.12 41.374 84,157.88
Subtotal: 177,201.00 177,201.00 3,896.39 69,449.35 39.192 107,751.65
135-69005-010-000 Capital Expenses 37,000.00 37,000.00 37,000.00
135-69008-010-000 Short Term Debt-Principal 489,980.00 489,980.00 489,980.00
135-69009-010-000 Short Term Debt-Interest 19,268.00 19,268.00 19,268.00
135-69195-010-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 30,000.00
135-69280-010-000 Capital Repairs 7,500.00 7,500.00 7,500.00
135-69281-010-000 Capital Repair-Ground Storage 106,847.00 106,847.00 100,816.54 94.356 6,030.46
Subtotal: 690,595.00 690,595.00 100,816.54 14.599 589,778.46
Program number: 3,931,956.00 3,931,956.00 175,677.05 958,143.06 24.368 2,973,812.94
Trophy Club Municipal Utility District No. 1 55 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 7
11:19 03/07/14 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID
Period Ending: 2/2014
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-55135-010-001 Lab Analysis 1,000.00 1,000.00 80.00 598.49 59.849 401.51
Subtotal: 1,000.00 1,000.00 80.00 598.49 59.849 401.51
135-60135-010-001 TCEQ Fees & Permits 112.34 2,366.19 2,366.19-
Subtotal: 112.34 2,366.19 2,366.19-
Program number: 1 Lab Analysis for PID 1,000.00 1,000.00 192.34 2,964.68 296.468 1,964.68-
Department number: Water 3,932,956.00 3,932,956.00 175,869.39 961,107.74 24.437 2,971,848.26
Trophy Club Municipal Utility District No. 1 56 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 8
11:19 03/07/14 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 2/2014
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-50005-020-000 Salaries & Wages 202,894.00 202,894.00 15,165.14 78,724.40 38.801 124,169.60
135-50010-020-000 Overtime 11,965.00 11,965.00 709.96 5,874.15 49.094 6,090.85
135-50016-020-000 Longevity 2,998.00 2,998.00 2,997.50 99.983 .50
135-50017-020-000 Certification 4,800.00 4,800.00 400.00 2,000.00 41.667 2,800.00
135-50020-020-000 Retirement 19,905.00 19,905.00 1,461.50 8,514.07 42.774 11,390.93
135-50026-020-000 Medical Insurance 43,471.00 43,471.00 3,241.09 16,309.73 37.519 27,161.27
135-50027-020-000 Dental Insurance 2,989.00 2,989.00 211.38 1,102.14 36.873 1,886.86
135-50028-020-000 Vision Insurance 658.00 658.00 51.26 252.31 38.345 405.69
135-50029-020-000 Life Insurance & Other 2,303.00 2,303.00 186.28 850.93 36.949 1,452.07
135-50030-020-000 Social Security Taxes 13,805.00 13,805.00 850.85 5,267.62 38.157 8,537.38
135-50035-020-000 Medicare Taxes 3,229.00 3,229.00 198.99 1,231.94 38.152 1,997.06
135-50040-020-000 Unemployment Taxes 36.00 36.00 9.92 34.50 95.833 1.50
135-50045-020-000 Workman's Compensation 6,552.00 6,552.00 535.08 2,675.40 40.833 3,876.60
135-50060-020-000 Pre-emp Physicals/Testing 150.00 150.00 63.00 42.000 87.00
135-50070-020-000 Employee Relations 350.00 350.00 22.01 59.99 17.140 290.01
Subtotal: 316,105.00 316,105.00 23,043.46 125,957.68 39.847 190,147.32
135-55070-020-000 Independent Labor 71,565.00 352,976.25 352,976.25-
135-55080-020-000 Maintenance & Repairs 35,000.00 35,000.00 933.47 19,021.56 54.347 15,978.44
135-55090-020-000 Vehicle Maintenance 2,000.00 2,000.00 278.00 1,217.49 60.875 782.51
135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 500.00
135-55125-020-000 Dumpster Services 52,000.00 52,000.00 6,476.97 16,446.74 31.628 35,553.26
135-55135-020-000 Lab Analysis 30,000.00 30,000.00 3,190.00 10,484.13 34.947 19,515.87
Subtotal: 119,500.00 119,500.00 82,443.44 400,146.17 334.850 280,646.17-
135-60010-020-000 Communications/Pagers/Mobiles 3,329.00 3,329.00 206.74 922.82 27.721 2,406.18
135-60020-020-000 Electricity 148,227.00 148,227.00 8,479.79 39,865.07 26.895 108,361.93
135-60066-020-000 Publications/Books/Subscripts 400.00 400.00 160.00 40.000 240.00
135-60080-020-000 Schools & Training 2,636.00 2,636.00 222.00 222.00 8.422 2,414.00
135-60090-020-000 Safety Program 250.00 250.00 371.38 148.552 121.38-
135-60100-020-000 Travel & per diem 1,050.00 1,050.00 266.09 25.342 783.91
135-60105-020-000 Rent/Lease Equipment 1,500.00 1,500.00 299.53 19.969 1,200.47
135-60135-020-000 TCEQ Fees & Permits 17,150.00 17,150.00 8,919.00 52.006 8,231.00
135-60245-020-000 Miscellaneous Expenses 200.00 200.00 200.00
135-60285-020-000 Lawn Equipment & Maintenance 500.00 500.00 500.00
135-60360-020-000 Furniture/Equipment < $5000 3,000.00 3,000.00 3,000.00
Subtotal: 178,242.00 178,242.00 8,908.53 51,025.89 28.627 127,216.11
135-65005-020-000 Fuel & Lube 14,720.00 14,720.00 710.54 4,071.37 27.659 10,648.63
135-65010-020-000 Uniforms 1,752.00 1,752.00 1,437.27 82.036 314.73
135-65030-020-000 Chemicals 39,000.00 39,000.00 2,240.00 10,318.12 26.457 28,681.88
Trophy Club Municipal Utility District No. 1 57 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 9
11:19 03/07/14 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 2/2014
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 91.00 9.100 909.00
135-65040-020-000 Safety Equipment 250.00 250.00 116.55 230.63 92.252 19.37
135-65045-020-000 Lab Supplies 15,000.00 15,000.00 5,383.58 35.891 9,616.42
Subtotal: 71,722.00 71,722.00 3,067.09 21,531.97 30.021 50,190.03
135-69005-020-000 Capital Expenses 31,000.00 31,000.00 31,000.00
135-69008-020-000 Short Term Debt-Principal 20,020.00 20,020.00 20,020.00
135-69009-020-000 Short Term Debt-Interest 1,422.00 1,422.00 1,422.00
135-69280-020-000 Capital Repairs 30,000.00 30,000.00 30,000.00
Subtotal: 82,442.00 82,442.00 82,442.00
Program number: 768,011.00 768,011.00 117,462.52 598,661.71 77.950 169,349.29
Department number: Wastewater 768,011.00 768,011.00 117,462.52 598,661.71 77.950 169,349.29
Trophy Club Municipal Utility District No. 1 58 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 10
11:19 03/07/14 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 21 Collection Program:
Period Ending: 2/2014
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-50005-021-000 Salaries & Wages 90,299.00 90,299.00 4,319.65 26,469.48 29.313 63,829.52
135-50010-021-000 Overtime 10,028.00 10,028.00 298.47 2,133.51 21.276 7,894.49
135-50016-021-000 Longevity 17,913.00 17,913.00 2,107.50 11.765 15,805.50
135-50017-021-000 Certification 1,800.00 1,800.00 150.00 750.00 41.667 1,050.00
135-50020-021-000 Retirement 9,025.00 9,025.00 428.17 3,180.15 35.237 5,844.85
135-50026-021-000 Medical Insurance 23,668.00 23,668.00 1,402.39 8,057.54 34.044 15,610.46
135-50027-021-000 Dental Insurance 1,703.00 1,703.00 102.60 607.59 35.678 1,095.41
135-50028-021-000 Vision Insurance 314.00 314.00 23.68 123.21 39.239 190.79
135-50029-021-000 Life Insurance & Other 1,066.00 1,066.00 71.54 467.95 43.898 598.05
135-50030-021-000 Social Security Taxes 7,442.00 7,442.00 255.17 1,981.57 26.627 5,460.43
135-50035-021-000 Medicare Taxes 1,741.00 1,741.00 59.67 463.43 26.619 1,277.57
135-50040-021-000 Unemployment Taxes 198.00 198.00 3.11 10.18 5.141 187.82
135-50045-021-000 Workman's Compensation 3,276.00 3,276.00 267.54 1,337.70 40.833 1,938.30
135-50070-021-000 Employee Relations 200.00 200.00 22.01 132.02 66.010 67.98
Subtotal: 168,673.00 168,673.00 7,404.00 47,821.83 28.352 120,851.17
135-55005-021-000 Engineering 1,500.00 1,500.00 1,500.00
135-55080-021-000 Maintenance & Repairs 23,801.00 23,801.00 2,898.00 2,991.28 12.568 20,809.72
135-55090-021-000 Vehicle Maintenance 2,000.00 2,000.00 999.18 999.18 49.959 1,000.82
Subtotal: 27,301.00 27,301.00 3,897.18 3,990.46 14.617 23,310.54
135-60010-021-000 Communications/Pagers/Mobiles 1,333.00 1,333.00 102.68 583.72 43.790 749.28
135-60020-021-000 Electricity 21,178.00 21,178.00 2,169.17 8,149.16 38.479 13,028.84
135-60070-021-000 Dues & Memberships 250.00 250.00 250.00
135-60080-021-000 Schools & Training 1,711.00 1,711.00 1,711.00
135-60090-021-000 Safety Program 300.00 300.00 300.00
135-60100-021-000 Travel & per diem 550.00 550.00 550.00
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: 35,422.00 35,422.00 2,271.85 8,732.88 24.654 26,689.12
135-65005-021-000 Fuel & Lube 22,397.00 22,397.00 841.37 5,013.60 22.385 17,383.40
135-65010-021-000 Uniforms 1,040.00 1,040.00 814.23 78.291 225.77
135-65030-021-000 Chemicals 6,000.00 6,000.00 6,000.00
135-65035-021-000 Small Tools 1,000.00 1,000.00 43.99 4.399 956.01
135-65040-021-000 Safety Equipment 500.00 500.00 45.98 586.73 117.346 86.73-
Subtotal: 30,937.00 30,937.00 887.35 6,458.55 20.876 24,478.45
135-69005-021-000 Capital Expenses 100,000.00 100,000.00 68,300.20 68,300.20 68.300 31,699.80
135-69008-021-000 Short Term Debt-Principal 35,991.00 35,991.00 35,991.00
Trophy Club Municipal Utility District No. 1 59 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 11
11:19 03/07/14 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 21 Collection Program:
Period Ending: 2/2014
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-69009-021-000 Short Term Debt-Interest 2,846.00 2,846.00 2,846.00
135-69280-021-000 Capital Repairs 71,000.00 71,000.00 71,000.00
Subtotal: 209,837.00 209,837.00 68,300.20 68,300.20 32.549 141,536.80
Program number: 472,170.00 472,170.00 82,760.58 135,303.92 28.656 336,866.08
Department number: Collection 472,170.00 472,170.00 82,760.58 135,303.92 28.656 336,866.08
Trophy Club Municipal Utility District No. 1 60 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 12
11:19 03/07/14 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program:
Period Ending: 2/2014
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-50005-026-000 Salaries & Wages 10,000.00 10,000.00 500.00 3,700.00 37.000 6,300.00
135-50030-026-000 Social Security Taxes 620.00 620.00 31.00 229.40 37.000 390.60
135-50035-026-000 Medicare Taxes 145.00 145.00 7.25 53.65 37.000 91.35
135-50040-026-000 Unemployment Taxes 10.00 10.00 .50 3.70 37.000 6.30
135-50045-026-000 Workman's Compensation 36.00 36.00 2.95 14.75 40.972 21.25
Subtotal: 10,811.00 10,811.00 541.70 4,001.50 37.013 6,809.50
135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00
135-60070-026-000 Dues & Memberships 500.00 500.00 35.00 7.000 465.00
135-60075-026-000 Meetings 1,200.00 1,200.00 35.95 2.996 1,164.05
135-60080-026-000 Schools & Training 4,000.00 4,000.00 265.00 6.625 3,735.00
135-60100-026-000 Travel & per diem 5,000.00 5,000.00 5,000.00
135-60245-026-000 Miscellaneous Expenses 1,000.00 1,000.00 1,000.00
Subtotal: 11,850.00 11,850.00 335.95 2.835 11,514.05
Program number: 22,661.00 22,661.00 541.70 4,337.45 19.141 18,323.55
Department number: Board of Directors 22,661.00 22,661.00 541.70 4,337.45 19.141 18,323.55
Trophy Club Municipal Utility District No. 1 61 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 13
11:19 03/07/14 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 2/2014
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-50005-030-000 Salaries & Wages 458,721.00 458,721.00 34,592.99 178,933.69 39.007 279,787.31
135-50010-030-000 Overtime 500.00 500.00 28.93 348.64 69.728 151.36
135-50016-030-000 Longevity 3,018.00 3,018.00 3,077.50 101.972 59.50-
135-50020-030-000 Retirement 41,419.00 41,419.00 3,109.05 17,348.65 41.886 24,070.35
135-50026-030-000 Medical Insurance 57,923.00 57,923.00 4,602.53 22,536.29 38.907 35,386.71
135-50027-030-000 Dental Insurance 5,100.00 5,100.00 340.42 1,839.86 36.076 3,260.14
135-50028-030-000 Vision Insurance 1,087.00 1,087.00 81.62 410.83 37.795 676.17
135-50029-030-000 Life Insurance & Other 4,483.00 4,483.00 352.66 2,190.29 48.858 2,292.71
135-50030-030-000 Social Security Taxes 28,659.00 28,659.00 2,012.79 11,370.05 39.674 17,288.95
135-50035-030-000 Medicare Taxes 6,702.00 6,702.00 470.74 2,659.14 39.677 4,042.86
135-50040-030-000 Unemployment Taxes 63.00 63.00 9.98 58.18 92.349 4.82
135-50045-030-000 Workman's Compensation 1,575.00 1,575.00 128.63 643.15 40.835 931.85
135-50060-030-000 Pre-emp Physicals/Testing 200.00 200.00 200.00
135-50070-030-000 Employee Relations 5,000.00 5,000.00 173.69 2,634.60 52.692 2,365.40
Subtotal: 614,450.00 614,450.00 45,904.03 244,050.87 39.719 370,399.13
135-55030-030-000 Software & Support 59,698.00 59,698.00 1,695.95 20,352.19 34.092 39,345.81
135-55070-030-000 Independent Labor 7,700.00 7,700.00 142.50 2,377.95 30.882 5,322.05
135-55080-030-000 Maintenance & Repairs 4,500.00 4,500.00 188.84- 1,948.97- -43.310 6,448.97
135-55100-030-000 Building Maint & Supplies 6,500.00 6,500.00 377.68 1,893.86 29.136 4,606.14
135-55120-030-000 Cleaning Services 19,140.00 19,140.00 1,594.97 6,379.88 33.333 12,760.12
135-55160-030-000 Professional Outside Services 15,000.00 15,000.00 15,000.00
135-55161-030-000 Outside Services-Town Semo 77,048.00 77,048.00 38,524.00 50.000 38,524.00
135-55165-030-000 Collection Fees 200.00 200.00 200.00
135-55205-030-000 Utility Billing Contract 6,808.00 6,808.00 566.00 2,330.35 34.230 4,477.65
Subtotal: 196,594.00 196,594.00 4,188.26 69,909.26 35.560 126,684.74
135-60005-030-000 Telephone 11,250.00 11,250.00 2,071.25 4,987.36 44.332 6,262.64
135-60010-030-000 Communications/Pagers/Mobiles 3,589.00 3,589.00 290.67 1,170.46 32.612 2,418.54
135-60020-030-000 Electricity/Gas 15,171.00 15,171.00 7,243.58 47.746 7,927.42
135-60025-030-000 Water 1,500.00 1,500.00 103.41 228.08 15.205 1,271.92
135-60035-030-000 Postage 28,500.00 28,500.00 2,035.09 9,029.29 31.682 19,470.71
135-60040-030-000 Service Charges & Fees 28,330.00 28,330.00 2,533.53 12,064.32 42.585 16,265.68
135-60050-030-000 Bad Debt Expense 1,500.00 1,500.00 3,712.56 247.504 2,212.56-
135-60055-030-000 Insurance 53,561.00 53,561.00 4,319.73 21,431.90 40.014 32,129.10
135-60066-030-000 Publications/Books/Subscripts 1,000.00 1,000.00 126.00 12.600 874.00
135-60070-030-000 Dues & Memberships 4,500.00 4,500.00 4,011.95 89.154 488.05
135-60075-030-000 Meetings 400.00 400.00 400.00
135-60080-030-000 Schools & Training 7,500.00 7,500.00 699.00 1,201.30 16.017 6,298.70
135-60100-030-000 Travel & per diem 5,000.00 5,000.00 703.16 14.063 4,296.84
135-60110-030-000 Physicals/Testing 200.00 200.00 200.00
135-60115-030-000 Elections 2,500.00 2,500.00 2,500.00
Trophy Club Municipal Utility District No. 1 62 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 14
11:19 03/07/14 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 2/2014
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-60125-030-000 Advertising 2,500.00 2,500.00 508.62 508.62 20.345 1,991.38
135-60235-030-000 Security 1,350.00 1,350.00 123.56 9.153 1,226.44
135-60245-030-000 Miscellaneous Expenses 22,870.00 22,870.00 63.46 346.54 1.515 22,523.46
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 2,500.00
Subtotal: 204,221.00 204,221.00 12,624.76 66,888.68 32.753 137,332.32
135-65010-030-000 Uniforms 1,390.00 1,390.00 998.90 71.863 391.10
135-65055-030-000 Hardware 13,562.00 13,562.00 67.71 1,745.66 12.872 11,816.34
135-65085-030-000 Office Supplies 9,100.00 9,100.00 516.50 2,093.44 23.005 7,006.56
135-65090-030-000 Printer Supplies & Maintenance 5,732.00 5,732.00 1,246.33 21.743 4,485.67
135-65095-030-000 Maintenance Supplies 2,500.00 2,500.00 295.95 1,111.49 44.460 1,388.51
135-65097-030-000 Vending Machine Supplies 200.00 200.00 51.00 25.500 149.00
135-65105-030-000 Printing 4,000.00 4,000.00 1,401.00 35.025 2,599.00
Subtotal: 36,484.00 36,484.00 880.16 8,647.82 23.703 27,836.18
135-69170-030-000 Copier Lease Installments 3,450.00 3,450.00 256.85 1,027.40 29.780 2,422.60
Subtotal: 3,450.00 3,450.00 256.85 1,027.40 29.780 2,422.60
Program number: 1,055,199.00 1,055,199.00 63,854.06 390,524.03 37.010 664,674.97
Department number: Administration 1,055,199.00 1,055,199.00 63,854.06 390,524.03 37.010 664,674.97
Trophy Club Municipal Utility District No. 1 63 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 15
11:19 03/07/14 Budget Summary with Amendment
Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program:
Period Ending: 2/2014
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
135-55045-039-000 Legal 131,300.00 131,300.00 10,865.25 96,808.47 73.731 34,491.53
135-55055-039-000 Auditing 21,840.00 21,840.00 21,200.00 97.070 640.00
135-55060-039-000 Appraisal 10,000.00 10,000.00 4,329.38 43.294 5,670.62
135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,451.40 64.511 1,348.60
Subtotal: 166,940.00 166,940.00 10,865.25 124,789.25 74.751 42,150.75
Program number: 166,940.00 166,940.00 10,865.25 124,789.25 74.751 42,150.75
Department number: Non Departmental 166,940.00 166,940.00 10,865.25 124,789.25 74.751 42,150.75
Expenditures Subtotal ----------- 6,417,937.00 6,417,937.00 451,353.50 2,214,724.10 34.508 4,203,212.90
Fund number: 135 MUD 1 General Fund 99,004.50 234,930.23 234,930.23-
Trophy Club Municipal Utility District No. 1 64 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 16
11:19 03/07/14 Budget Summary with Amendment
Fund: 507 MUD 1 Capital Projects Department: Program:
Period Ending: 2/2014
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
507-49010-000-000 Interest Income 4.07- 46.69- 46.69
Subtotal: 4.07- 46.69- 46.69
Program number: 4.07- 46.69- 46.69
Department number: 4.07- 46.69- 46.69
Revenues Subtotal ----------- 4.07- 46.69- 46.69
Trophy Club Municipal Utility District No. 1 65 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 17
11:19 03/07/14 Budget Summary with Amendment
Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 2 Rate of Flow Control-FW Meter
Period Ending: 2/2014
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
507-69280-010-002 Capital Repairs/ROFC FW Meter 82,629.40 82,629.40-
Subtotal: 82,629.40 82,629.40-
Program number: 2 Rate of Flow Control-FW Meter 82,629.40 82,629.40-
Department number: Water 82,629.40 82,629.40-
Expenditures Subtotal ----------- 82,629.40 82,629.40-
Fund number: 507 MUD 1 Capital Projects 4.07- 82,582.71 82,582.71-
Trophy Club Municipal Utility District No. 1 66 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 14
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 2/2014
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
886 02/01/2014 Property Taxes/Assessments (84,916.43) (1,943.42) (86,859.85) GL
887 02/03/2014 Property Taxes/Assessments (905.55) (87,765.40) GL
888 02/04/2014 Property Taxes/Assessments (629.76) (88,395.16) GL
889 02/05/2014 Property Taxes/Assessments (1,598.31) (89,993.47) GL
890 02/06/2014 Property Taxes/Assessments (369.26) (90,362.73) GL
891 02/07/2014 Property Taxes/Assessments (1,511.96) (91,874.69) GL
892 02/10/2014 Property Taxes/Assessments (.89) (91,875.58) GL
893 02/12/2014 Property Taxes/Assessments (79.28) (91,954.86) GL
894 02/13/2014 Property Taxes/Assessments (154.67) (92,109.53) GL
895 02/14/2014 Property Taxes/Assessments (11.20) (92,120.73) GL
896 02/18/2014 Property Taxes/Assessments (1,838.05) (93,958.78) GL
897 02/20/2014 Property Taxes/Assessments (5.22) (93,964.00) GL
898 02/24/2014 Property Taxes/Assessments (56.51) (94,020.51) GL
899 02/25/2014 Property Taxes/Assessments (2.00) (94,022.51) GL
900 02/27/2014 Property Taxes/Assessments (31.65) (94,054.16) GL
901 02/28/2014 Property Taxes/Assessments (43.32) (94,097.48) GL
_______________
Account: 135-40000-000-000 Property Taxes Totals: (9,181.05) (94,097.48) **
(99,250.00) Budgeted (5,152.52) Remaining 95 % Used
Account: 135-40002-000-000 Property Taxes/Delinquent
887 02/03/2014 Property Taxes/Assessments (.68) (.79) (1.47) GL
_______________
Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (.79) (1.47) **
.00 Budgeted 1.47 Remaining 0 % Used
Account: 135-40015-000-000 Property Taxes/P & I
888 02/04/2014 Property Taxes/Assessments 10.80 (2.09) 8.71 GL
889 02/05/2014 Property Taxes/Assessments (.06) 8.65 GL
890 02/06/2014 Property Taxes/Assessments (1.46) 7.19 GL
892 02/10/2014 Property Taxes/Assessments (1.33) 5.86 GL
893 02/12/2014 Property Taxes/Assessments (5.07) .79 GL
894 02/13/2014 Property Taxes/Assessments (9.90) (9.11) GL
895 02/14/2014 Property Taxes/Assessments (.78) (9.89) GL
896 02/18/2014 Property Taxes/Assessments (128.66) (138.55) GL
897 02/20/2014 Property Taxes/Assessments (.37) (138.92) GL
898 02/24/2014 Property Taxes/Assessments (3.96) (142.88) GL
899 02/25/2014 Property Taxes/Assessments (.14) (143.02) GL
900 02/27/2014 Property Taxes/Assessments (2.21) (145.23) GL
901 02/28/2014 Property Taxes/Assessments (2.00) (147.23) GL
Trophy Club Municipal Utility District No. 1 67 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 15
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
_______________
Account: 135-40015-000-000 Property Taxes/P & I Totals: (158.03) (147.23) **
(900.00) Budgeted (752.77) Remaining 16 % Used
Account: 135-43215-000-000 Insurance Settlement
(82.36) .00 (82.36)
_______________
Account: 135-43215-000-000 Insurance Settlement Totals: .00 (82.36) **
.00 Budgeted 82.36 Remaining 0 % Used
Account: 135-47000-000-000 Water
926 02/28/2014 UB 2/28/14 Billing-february UB20140228-20140228 User: (762,906.92) (161,407.89) (924,314.81) UB
_______________
Account: 135-47000-000-000 Water Totals: (161,407.89) (924,314.81) **
(3,749,310.00) Budgeted (2,824,995.19) Remaining 25 % Used
Account: 135-47005-000-000 Sewer
926 02/28/2014 UB 2/28/14 Billing-february UB20140228-20140228 User: (561,566.20) (136,445.68) (698,011.88) UB
_______________
Account: 135-47005-000-000 Sewer Totals: (136,445.68) (698,011.88) **
(1,708,321.00) Budgeted (1,010,309.12) Remaining 41 % Used
Account: 135-47025-000-000 Penalties
852 02/21/2014 UB 2/21/14 Late Penalties UB20140221-20140221 User: (15,815.76) (4,737.93) (20,553.69) UB
925 02/28/2014 UB 02/28/2014 Adjustments UB20140228-20140228 User: 67.28 (20,486.41) UB
_______________
Account: 135-47025-000-000 Penalties Totals: (4,670.65) (20,486.41) **
(64,522.00) Budgeted (44,035.59) Remaining 32 % Used
Account: 135-47030-000-000 Service Charges
832 02/04/2014 UB 2/4/14 NSF Fee UB20140204-20140204 User: (3,262.00) (25.00) (3,287.00) UB
798 02/12/2014 UB 2/12/14 Cut Off List UB20140212-20140212 User: (275.00) (3,562.00) UB
912 02/14/2014 UB 2/14/14 Adjustment NSF Fee UB20140214-20140214 User: (25.00) (3,587.00) UB
915 02/20/2014 UB 2/20/14 NSF Check Fee UB20140220-20140220 User: (25.00) (3,612.00) UB
918 02/21/2014 UB 2/21/14 NSF Check Fee UB20140221-20140221 User: (25.00) (3,637.00) UB
923 02/27/2014 UB 2/27/14 NSF Check Fee UB20140227-20140227 User: (25.00) (3,662.00) UB
926 02/28/2014 UB 2/28/14 Billing-february UB20140228-20140228 User: (3.00) (3,665.00) UB
Trophy Club Municipal Utility District No. 1 68 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 16
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
_______________
Account: 135-47030-000-000 Service Charges Totals: (403.00) (3,665.00) **
(9,075.00) Budgeted (5,410.00) Remaining 40 % Used
Account: 135-47035-000-000 Plumbing Inspections
945 02/28/2014 Town Billed Inv 1137-1147 AR 20140201-20140228 User: (800.00) (100.00) (900.00) AR
_______________
Account: 135-47035-000-000 Plumbing Inspections Totals: (100.00) (900.00) **
(1,200.00) Budgeted (300.00) Remaining 75 % Used
Account: 135-47045-000-000 Sewer Inspections
945 02/28/2014 Town Billed Inv 1137-1147 AR 20140201-20140228 User: (2,550.00) (300.00) (2,850.00) AR
_______________
Account: 135-47045-000-000 Sewer Inspections Totals: (300.00) (2,850.00) **
(4,400.00) Budgeted (1,550.00) Remaining 65 % Used
Account: 135-47070-000-000 TCCC Effluent Charges
926 02/28/2014 UB 2/28/14 Billing-february UB20140228-20140228 User: (7,824.28) (228.90) (8,053.18) UB
_______________
Account: 135-47070-000-000 TCCC Effluent Charges Totals: (228.90) (8,053.18) **
(79,586.00) Budgeted (71,532.82) Remaining 10 % Used
Account: 135-48005-000-000 Utility Fees
945 02/28/2014 Town Billed Inv 1137-1147 AR 20140201-20140228 User: (147,200.00) (27,600.00) (174,800.00) AR
_______________
Account: 135-48005-000-000 Utility Fees Totals: (27,600.00) (174,800.00) **
(582,109.00) Budgeted (407,309.00) Remaining 30 % Used
Account: 135-49010-000-000 Interest Income
929 02/28/2014 Bank Statement Interest/Feb (2,077.55) (368.59) (2,446.14) GL
929 02/28/2014 Bank Statement Interest/Feb (53.69) (2,499.83) GL
929 02/28/2014 Bank Statement Interest/Feb (43.07) (2,542.90) GL
_______________
Account: 135-49010-000-000 Interest Income Totals: (465.35) (2,542.90) **
(4,800.00) Budgeted (2,257.10) Remaining 53 % Used
Account: 135-49016-000-000 Cell Tower Revenue
Trophy Club Municipal Utility District No. 1 69 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 17
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
814 02/07/2014 AT&T Antenna Lease (3,642.12) (910.53) (4,552.65) GL
_______________
Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (4,552.65) **
(10,164.00) Budgeted (5,611.35) Remaining 45 % Used
Account: 135-49018-000-000 Building Rent Income
945 02/28/2014 Town Billed Inv 1137-1147 AR 20140201-20140228 User: (2,333.32) (583.33) (2,916.65) AR
_______________
Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (2,916.65) **
(7,000.00) Budgeted (4,083.35) Remaining 42 % Used
Account: 135-49030-000-000 Vending Revenue
(98.00) .00 (98.00)
_______________
Account: 135-49030-000-000 Vending Revenue Totals: .00 (98.00) **
(350.00) Budgeted (252.00) Remaining 28 % Used
Account: 135-49036-000-000 GASB Reserves
.00 .00
_______________
Account: 135-49036-000-000 GASB Reserves Totals: .00 .00 **
(8,964.00) Budgeted (8,964.00) Remaining 0 % Used
Account: 135-49075-000-000 Oversize Meter Reimbursement
945 02/28/2014 Town Billed Inv 1137-1147 AR 20140201-20140228 User: (32,226.77) (4,802.00) (37,028.77) AR
_______________
Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (4,802.00) (37,028.77) **
(84,000.00) Budgeted (46,971.23) Remaining 44 % Used
Account: 135-49900-000-000 Miscellaneous Income
818 02/14/2014 Sale of Scrap metal (153.28) (1,004.80) (1,158.08) GL
_______________
Account: 135-49900-000-000 Miscellaneous Income Totals: (1,004.80) (1,158.08) **
(3,000.00) Budgeted (1,841.92) Remaining 39 % Used
Account: 135-49901-000-000 Records Management Revenue
.00 .00
Trophy Club Municipal Utility District No. 1 70 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 18
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: Revenues Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
_______________
Account: 135-49901-000-000 Records Management Revenue Totals: .00 .00 **
(100.00) Budgeted (100.00) Remaining 0 % Used
Account: 135-49903-000-000 Recovery of Prior Year Expense
816 02/07/2014 TML FY13 W/C Audit refund (4,087.00) (4,087.00) GL
_______________
Account: 135-49903-000-000 Recovery of Prior Year Expense Totals: (4,087.00) (4,087.00) **
.00 Budgeted 4,087.00 Remaining 0 % Used
Account: 135-49905-000-000 Gas Well Revenue
.00 .00
_______________
Account: 135-49905-000-000 Gas Well Revenue Totals: .00 .00 **
(886.00) Budgeted (886.00) Remaining 0 % Used
Department Totals: ------------------------------------------------------------------------------------------------ (1,979,793.87) **
(6,417,937.00) Budgeted (4,438,143.13) Remaining 31 % Used
Trophy Club Municipal Utility District No. 1 71 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 19
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 2/2014
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
794 02/14/2014 PR 02-14-14 Salaries & Wages 85,372.13 10,858.14 96,230.27 PR
864 02/28/2014 Payroll 2/28/14 Salaries & Wages 10,858.14 107,088.41 PR
_______________
Account: 135-50005-010-000 Salaries & Wages Totals: 21,716.28 107,088.41 **
287,709.00 Budgeted 180,620.59 Remaining 37 % Used
Account: 135-50010-010-000 Overtime
794 02/14/2014 PR 02-14-14 Overtime 6,535.13 881.65 7,416.78 PR
864 02/28/2014 Payroll 2/28/14 Overtime 490.27 7,907.05 PR
_______________
Account: 135-50010-010-000 Overtime Totals: 1,371.92 7,907.05 **
13,391.00 Budgeted 5,483.95 Remaining 59 % Used
Account: 135-50016-010-000 Longevity
4,905.00 .00 4,905.00
_______________
Account: 135-50016-010-000 Longevity Totals: .00 4,905.00 **
4,905.00 Budgeted .00 Remaining 100 % Used
Account: 135-50017-010-000 Certification
864 02/28/2014 Payroll 2/28/14 Certification 1,300.00 350.00 1,650.00 PR
_______________
Account: 135-50017-010-000 Certification Totals: 350.00 1,650.00 **
5,100.00 Budgeted 3,450.00 Remaining 32 % Used
Account: 135-50020-010-000 Retirement
794 02/14/2014 PR 02-14-14 Retirement 9,254.45 1,054.23 10,308.68 PR
864 02/28/2014 Payroll 2/28/14 Retirement 1,050.52 11,359.20 PR
_______________
Account: 135-50020-010-000 Retirement Totals: 2,104.75 11,359.20 **
27,847.00 Budgeted 16,487.80 Remaining 41 % Used
Account: 135-50026-010-000 Medical Insurance
794 02/14/2014 PR 02-14-14 Medical Insurance 11,900.61 1,720.02 13,620.63 PR
864 02/28/2014 Payroll 2/28/14 Medical Insurance 1,719.96 15,340.59 PR
_______________
Account: 135-50026-010-000 Medical Insurance Totals: 3,439.98 15,340.59 **
48,334.00 Budgeted 32,993.41 Remaining 32 % Used
Trophy Club Municipal Utility District No. 1 72 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 20
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-50027-010-000 Dental Insurance
794 02/14/2014 PR 02-14-14 Dental Insurance 929.61 124.54 1,054.15 PR
864 02/28/2014 Payroll 2/28/14 Dental Insurance 124.58 1,178.73 PR
_______________
Account: 135-50027-010-000 Dental Insurance Totals: 249.12 1,178.73 **
3,932.00 Budgeted 2,753.27 Remaining 30 % Used
Account: 135-50028-010-000 Vision Insurance
794 02/14/2014 PR 02-14-14 Vision Insurance 217.90 31.49 249.39 PR
864 02/28/2014 Payroll 2/28/14 Vision Insurance 31.54 280.93 PR
_______________
Account: 135-50028-010-000 Vision Insurance Totals: 63.03 280.93 **
873.00 Budgeted 592.07 Remaining 32 % Used
Account: 135-50029-010-000 Life Insurance & Other
689 02/01/2014 Feb A/P Dental, Life, STD & Other Ins 765.24 221.24 986.48 METLIFE 33414 AP
873 02/27/2014 Feb A/P Jan Admin/FSA 15.62 1,002.10 BenefitMall 33480 AP
_______________
Account: 135-50029-010-000 Life Insurance & Other Totals: 236.86 1,002.10 **
3,306.00 Budgeted 2,303.90 Remaining 30 % Used
Account: 135-50030-010-000 Social Security Taxes
794 02/14/2014 PR 02-14-14 Social Security Taxes 6,442.38 724.64 7,167.02 PR
864 02/28/2014 Payroll 2/28/14 Social Security Taxes 717.15 7,884.17 PR
_______________
Account: 135-50030-010-000 Social Security Taxes Totals: 1,441.79 7,884.17 **
19,289.00 Budgeted 11,404.83 Remaining 41 % Used
Account: 135-50035-010-000 Medicare Taxes
794 02/14/2014 PR 02-14-14 Medicare Taxes 1,506.70 169.47 1,676.17 PR
864 02/28/2014 Payroll 2/28/14 Medicare Taxes 167.71 1,843.88 PR
_______________
Account: 135-50035-010-000 Medicare Taxes Totals: 337.18 1,843.88 **
4,511.00 Budgeted 2,667.12 Remaining 41 % Used
Account: 135-50040-010-000 Unemployment Taxes
794 02/14/2014 PR 02-14-14 Unemployment Taxes 38.83 8.90 47.73 PR
864 02/28/2014 Payroll 2/28/14 Unemployment Taxes 4.92 52.65 PR
Trophy Club Municipal Utility District No. 1 73 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 21
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
_______________
Account: 135-50040-010-000 Unemployment Taxes Totals: 13.82 52.65 **
54.00 Budgeted 1.35 Remaining 98 % Used
Account: 135-50045-010-000 Workman's Compensation
51 02/01/2014 Feb Ins & W/C Expense 3,209.80 802.45 4,012.25 GL
_______________
Account: 135-50045-010-000 Workman's Compensation Totals: 802.45 4,012.25 **
9,829.00 Budgeted 5,816.75 Remaining 41 % Used
Account: 135-50060-010-000 Pre-emp Physicals/Testing
233.90 .00 233.90
_______________
Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 233.90 **
200.00 Budgeted (33.90) Remaining 117 % Used
Account: 135-50070-010-000 Employee Relations
927 02/26/2014 1/28/14-2/26/14 PCards DONUT HAVEN 85.77 8.01 93.78 DONUT HAVEN PC
927 02/26/2014 1/28/14-2/26/14 PCards CHICK-FIL-A #02892 14.00 107.78 CHICK-FIL-A #02892 PC
_______________
Account: 135-50070-010-000 Employee Relations Totals: 22.01 107.78 **
300.00 Budgeted 192.22 Remaining 36 % Used
Account: 135-55005-010-000 Engineering
.00 .00
_______________
Account: 135-55005-010-000 Engineering Totals: .00 .00 **
3,000.00 Budgeted 3,000.00 Remaining 0 % Used
Account: 135-55080-010-000 Maintenance & Repairs
808 02/14/2014 Feb A/P Cla Valve repair 25,202.19 1,695.00 26,897.19 AXIS CONSTRUCTION 33425 AP
808 02/14/2014 Feb A/P Mag Meter for water plant 9,250.00 36,147.19 ATLAS UTILITY SUPPLY CO. 33424 AP
808 02/14/2014 Feb A/P Gaskets 62.36 36,209.55 ATLAS UTILITY SUPPLY CO. 33424 AP
808 02/14/2014 Feb A/P Dechlor Tablets 259.90 36,469.45 HD SUPPLY FACILITIES MAINT LTD 33441 AP
927 02/26/2014 1/28/14-2/26/14 PCards THE HOME DEPOT 6581 8.37 36,477.82 THE HOME DEPOT 6581 PC
927 02/26/2014 1/28/14-2/26/14 PCards THE HOME DEPOT 6581 31.88 36,509.70 THE HOME DEPOT 6581 PC
927 02/26/2014 1/28/14-2/26/14 PCards THE HOME DEPOT 6581 18.46 36,528.16 THE HOME DEPOT 6581 PC
927 02/26/2014 1/28/14-2/26/14 PCards THE HOME DEPOT 6581 72.17 36,600.33 THE HOME DEPOT 6581 PC
Trophy Club Municipal Utility District No. 1 74 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 22
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
927 02/26/2014 1/28/14-2/26/14 PCards THE HOME DEPOT 6581 25,202.19 50.24 36,650.57 THE HOME DEPOT 6581 PC
927 02/26/2014 1/28/14-2/26/14 PCards OFFICE DEPOT #406 49.98 36,700.55 OFFICE DEPOT #406 PC
927 02/26/2014 1/28/14-2/26/14 PCards THE HOME DEPOT 6581 9.80 36,710.35 THE HOME DEPOT 6581 PC
927 02/26/2014 1/28/14-2/26/14 PCards THE HOME DEPOT 6581 45.59 36,755.94 THE HOME DEPOT 6581 PC
870 02/26/2014 Feb A/P 24" Mag Meter install @ water 975.00 37,730.94 DHS AUTOMATION, INC 33485 AP
870 02/26/2014 Feb A/P meter boxes, gaskets, inserts 904.48 38,635.42 HD SUPPLY WATERWORKS, LTD. 33491 AP
_______________
Account: 135-55080-010-000 Maintenance & Repairs Totals: 13,433.23 38,635.42 **
50,000.00 Budgeted 11,364.58 Remaining 77 % Used
Account: 135-55090-010-000 Vehicle Maintenance
808 02/14/2014 Feb A/P Chains for vehicles 1,076.81 695.00 1,771.81 ROANOKE AUTO SUPPLY 33464 AP
870 02/26/2014 Feb A/P Lights, washer fluid 13.85 1,785.66 ROANOKE AUTO SUPPLY 33501 AP
875 02/27/2014 Feb A/P Reimburse Petty Cash 5.29 1,790.95 TROPHY CLUB MUD PETTY CASH 33508 AP
_______________
Account: 135-55090-010-000 Vehicle Maintenance Totals: 714.14 1,790.95 **
5,000.00 Budgeted 3,209.05 Remaining 36 % Used
Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader
248.33 .00 248.33
_______________
Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 248.33 **
3,500.00 Budgeted 3,251.67 Remaining 7 % Used
Account: 135-55135-010-000 Lab Analysis
808 02/14/2014 Feb A/P Bac T Samples/MUD 680.00 310.00 990.00 TARRANT CTY PUBLIC HEALTH LAB 33467 AP
_______________
Account: 135-55135-010-000 Lab Analysis Totals: 310.00 990.00 **
5,500.00 Budgeted 4,510.00 Remaining 18 % Used
Account: 135-60010-010-000 Communications/Pagers/Mobiles
870 02/26/2014 Feb A/P Charter, Verizon, 1st Check, P 1,147.80 383.39 1,531.19 TOWN OF TROPHY CLUB 33503 AP
_______________
Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: 383.39 1,531.19 **
4,913.00 Budgeted 3,381.81 Remaining 31 % Used
Account: 135-60020-010-000 Electricity
870 02/26/2014 Feb A/P Electricity 1/13/14-2/11/14 34,426.03 4,706.99 39,133.02 HUDSON ENERGY SERVICES, LLC 33492 AP
Trophy Club Municipal Utility District No. 1 75 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 23
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
870 02/26/2014 Feb A/P Electricity 1/11/14-2/9/14 34,426.03 75.18 39,208.20 HUDSON ENERGY SERVICES, LLC 33492 AP
870 02/26/2014 Feb A/P Electricity 1/13/14-2/11/14 2,025.31 41,233.51 HUDSON ENERGY SERVICES, LLC 33492 AP
_______________
Account: 135-60020-010-000 Electricity Totals: 6,807.48 41,233.51 **
162,160.00 Budgeted 120,926.49 Remaining 25 % 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
289.00 .00 289.00
_______________
Account: 135-60070-010-000 Dues & Memberships Totals: .00 289.00 **
150.00 Budgeted (139.00) Remaining 193 % Used
Account: 135-60080-010-000 Schools & Training
927 02/26/2014 1/28/14-2/26/14 PCards NCTCOG RTC TRAINING 700.00 30.00 730.00 NCTCOG RTC TRAINING PC
875 02/27/2014 Feb A/P Reimburse Petty Cash 40.00 770.00 TROPHY CLUB MUD PETTY CASH 33508 AP
_______________
Account: 135-60080-010-000 Schools & Training Totals: 70.00 770.00 **
4,184.00 Budgeted 3,414.00 Remaining 18 % Used
Account: 135-60090-010-000 Safety Program
.00 .00
_______________
Account: 135-60090-010-000 Safety Program Totals: .00 .00 **
400.00 Budgeted 400.00 Remaining 0 % Used
Account: 135-60100-010-000 Travel & per diem
171.13 .00 171.13
_______________
Account: 135-60100-010-000 Travel & per diem Totals: .00 171.13 **
1,450.00 Budgeted 1,278.87 Remaining 12 % Used
Account: 135-60105-010-000 Rent/Lease Equipment
Trophy Club Municipal Utility District No. 1 76 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 24
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
870 02/26/2014 Feb A/P January Nitrogen 18.00 6.00 24.00 ALLIED WELDING SUPPLY, INC 33477 AP
_______________
Account: 135-60105-010-000 Rent/Lease Equipment Totals: 6.00 24.00 **
500.00 Budgeted 476.00 Remaining 5 % Used
Account: 135-60135-010-000 TCEQ Fees & Permits
808 02/14/2014 Feb A/P Halocetic Acids, Trihalomethan 29,355.59 207.70 29,563.29 LOWER COLORADO RIVER AUTHORITY 33451 AP
808 02/14/2014 Feb A/P 9/30/13-12/31/13 NTGC Dist Fee 2,582.50 32,145.79 North Texas Groundwater 33455 AP
938 02/28/2014 Feb A/P Tier Two Chemical Reporting Pr 50.00 32,195.79 DEPT OF STATE HEALTH SVCS AP
939 02/28/2014 Void A/P Inv-Tier Two Tier Two Chemical Reporting Pr (50.00) 32,145.79 DEPT OF STATE HEALTH SVCS AP
940 02/28/2014 Feb A/P Tier Two Chemical Reporting Ja 50.00 32,195.79 DEPT OF STATE HEALTH SVCS 33510 AP
_______________
Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 2,840.20 32,195.79 **
47,400.00 Budgeted 15,204.21 Remaining 68 % Used
Account: 135-60150-010-000 Wholesale Water
870 02/26/2014 Feb A/P Jan Wholesale water 389,555.48 114,917.03 504,472.51 CITY OF FORT WORTH AP
_______________
Account: 135-60150-010-000 Wholesale Water Totals: 114,917.03 504,472.51 **
2,338,473.00 Budgeted 1,834,000.49 Remaining 22 % Used
Account: 135-60245-010-000 Miscellaneous Expenses
.00 .00
_______________
Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 **
200.00 Budgeted 200.00 Remaining 0 % Used
Account: 135-60280-010-000 Property Maintenance
927 02/26/2014 1/28/14-2/26/14 PCards DENTON SAND & GRAVEL, 528.70 108.00 636.70 DENTON SAND & GRAVEL, PC
927 02/26/2014 1/28/14-2/26/14 PCards DENTON SAND & GRAVEL, 42.00 678.70 DENTON SAND & GRAVEL, PC
_______________
Account: 135-60280-010-000 Property Maintenance Totals: 150.00 678.70 **
3,500.00 Budgeted 2,821.30 Remaining 19 % Used
Account: 135-60285-010-000 Lawn Equipment & Maintenance
.00 .00
_______________
Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 **
250.00 Budgeted 250.00 Remaining 0 % Used
Trophy Club Municipal Utility District No. 1 77 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 25
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-60360-010-000 Furniture/Equipment < $5000
.00 .00
_______________
Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 .00 **
3,500.00 Budgeted 3,500.00 Remaining 0 % Used
Account: 135-65005-010-000 Fuel & Lube
904 02/28/2014 February Gas Log 3,849.45 921.25 4,770.70 GL
_______________
Account: 135-65005-010-000 Fuel & Lube Totals: 921.25 4,770.70 **
23,181.00 Budgeted 18,410.30 Remaining 21 % Used
Account: 135-65010-010-000 Uniforms
1,831.63 .00 1,831.63
_______________
Account: 135-65010-010-000 Uniforms Totals: .00 1,831.63 **
3,270.00 Budgeted 1,438.37 Remaining 56 % Used
Account: 135-65030-010-000 Chemicals
808 02/14/2014 Feb A/P Chlorine 2,045.09 104.09 2,149.18 DPC INDUSTRIES, INC 33432 AP
808 02/14/2014 Feb A/P testing supplies 309.93 2,459.11 HACH COMPANY 33440 AP
927 02/26/2014 1/28/14-2/26/14 PCards DX SERVICE 208.18 2,667.29 DX SERVICE PC
_______________
Account: 135-65030-010-000 Chemicals Totals: 622.20 2,667.29 **
5,000.00 Budgeted 2,332.71 Remaining 53 % Used
Account: 135-65035-010-000 Small Tools
464.94 .00 464.94
_______________
Account: 135-65035-010-000 Small Tools Totals: .00 464.94 **
1,200.00 Budgeted 735.06 Remaining 39 % Used
Account: 135-65040-010-000 Safety Equipment
870 02/26/2014 Feb A/P JPChase PCards 184.73 137.94 322.67 TOWN OF TROPHY CLUB 33503 AP
_______________
Account: 135-65040-010-000 Safety Equipment Totals: 137.94 322.67 **
1,000.00 Budgeted 677.33 Remaining 32 % Used
Trophy Club Municipal Utility District No. 1 78 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 26
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-65050-010-000 Meter Expense
808 02/14/2014 Feb A/P Replacement meter heads 57,177.12 2,215.00 59,392.12 ATLAS UTILITY SUPPLY CO. 33424 AP
_______________
Account: 135-65050-010-000 Meter Expense Totals: 2,215.00 59,392.12 **
143,550.00 Budgeted 84,157.88 Remaining 41 % Used
Account: 135-69005-010-000 Capital Expenses
.00 .00
_______________
Account: 135-69005-010-000 Capital Expenses Totals: .00 .00 **
37,000.00 Budgeted 37,000.00 Remaining 0 % Used
Account: 135-69008-010-000 Short Term Debt-Principal
.00 .00
_______________
Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 .00 **
489,980.00 Budgeted 489,980.00 Remaining 0 % Used
Account: 135-69009-010-000 Short Term Debt-Interest
.00 .00
_______________
Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 .00 **
19,268.00 Budgeted 19,268.00 Remaining 0 % Used
Account: 135-69195-010-000 Gasb34/Reserve for Replacement
.00 .00
_______________
Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 .00 **
30,000.00 Budgeted 30,000.00 Remaining 0 % Used
Account: 135-69280-010-000 Capital Repairs
.00 .00
_______________
Account: 135-69280-010-000 Capital Repairs Totals: .00 .00 **
7,500.00 Budgeted 7,500.00 Remaining 0 % Used
Account: 135-69281-010-000 Capital Repair-Ground Storage
Trophy Club Municipal Utility District No. 1 79 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 27
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 10 Water Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
100,816.54 .00 100,816.54
_______________
Account: 135-69281-010-000 Capital Repair-Ground Storage Totals: .00 100,816.54 **
106,847.00 Budgeted 6,030.46 Remaining 94 % Used
Account: 135-55135-010-001 Lab Analysis
808 02/14/2014 Feb A/P Bac T samples/PID 518.49 80.00 598.49 TARRANT CTY PUBLIC HEALTH LAB 33466 AP
_______________
Account: 135-55135-010-001 Lab Analysis Totals: 80.00 598.49 **
1,000.00 Budgeted 401.51 Remaining 60 % Used
Account: 135-60135-010-001 TCEQ Fees & Permits
808 02/14/2014 Feb A/P PID testing/Halocetic Acids, T 2,253.85 112.34 2,366.19 LOWER COLORADO RIVER AUTHORITY 33451 AP
_______________
Account: 135-60135-010-001 TCEQ Fees & Permits Totals: 112.34 2,366.19 **
.00 Budgeted (2,366.19) Remaining 0 % Used
Department 10 Totals: ------------------------------------------------------------------------------------------------ 961,107.74 **
3,932,956.00 Budgeted 2,971,848.26 Remaining 24 % Used
Trophy Club Municipal Utility District No. 1 80 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 28
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 2/2014
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
794 02/14/2014 PR 02-14-14 Salaries & Wages 63,559.26 7,587.46 71,146.72 PR
864 02/28/2014 Payroll 2/28/14 Salaries & Wages 7,577.68 78,724.40 PR
_______________
Account: 135-50005-020-000 Salaries & Wages Totals: 15,165.14 78,724.40 **
202,894.00 Budgeted 124,169.60 Remaining 39 % Used
Account: 135-50010-020-000 Overtime
794 02/14/2014 PR 02-14-14 Overtime 5,164.19 462.43 5,626.62 PR
864 02/28/2014 Payroll 2/28/14 Overtime 247.53 5,874.15 PR
_______________
Account: 135-50010-020-000 Overtime Totals: 709.96 5,874.15 **
11,965.00 Budgeted 6,090.85 Remaining 49 % Used
Account: 135-50016-020-000 Longevity
2,997.50 .00 2,997.50
_______________
Account: 135-50016-020-000 Longevity Totals: .00 2,997.50 **
2,998.00 Budgeted .50 Remaining 100 % Used
Account: 135-50017-020-000 Certification
864 02/28/2014 Payroll 2/28/14 Certification 1,600.00 400.00 2,000.00 PR
_______________
Account: 135-50017-020-000 Certification Totals: 400.00 2,000.00 **
4,800.00 Budgeted 2,800.00 Remaining 42 % Used
Account: 135-50020-020-000 Retirement
794 02/14/2014 PR 02-14-14 Retirement 7,052.57 722.88 7,775.45 PR
864 02/28/2014 Payroll 2/28/14 Retirement 738.62 8,514.07 PR
_______________
Account: 135-50020-020-000 Retirement Totals: 1,461.50 8,514.07 **
19,905.00 Budgeted 11,390.93 Remaining 43 % Used
Account: 135-50026-020-000 Medical Insurance
794 02/14/2014 PR 02-14-14 Medical Insurance 13,068.64 1,620.56 14,689.20 PR
864 02/28/2014 Payroll 2/28/14 Medical Insurance 1,620.53 16,309.73 PR
_______________
Account: 135-50026-020-000 Medical Insurance Totals: 3,241.09 16,309.73 **
43,471.00 Budgeted 27,161.27 Remaining 38 % Used
Trophy Club Municipal Utility District No. 1 81 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 29
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-50027-020-000 Dental Insurance
794 02/14/2014 PR 02-14-14 Dental Insurance 890.76 105.68 996.44 PR
864 02/28/2014 Payroll 2/28/14 Dental Insurance 105.70 1,102.14 PR
_______________
Account: 135-50027-020-000 Dental Insurance Totals: 211.38 1,102.14 **
2,989.00 Budgeted 1,886.86 Remaining 37 % Used
Account: 135-50028-020-000 Vision Insurance
794 02/14/2014 PR 02-14-14 Vision Insurance 201.05 25.61 226.66 PR
864 02/28/2014 Payroll 2/28/14 Vision Insurance 25.65 252.31 PR
_______________
Account: 135-50028-020-000 Vision Insurance Totals: 51.26 252.31 **
658.00 Budgeted 405.69 Remaining 38 % Used
Account: 135-50029-020-000 Life Insurance & Other
689 02/01/2014 Feb A/P Dental, Life, STD & Other Ins 664.65 155.00 819.65 METLIFE 33414 AP
873 02/27/2014 Feb A/P Jan Admin/FSA 31.28 850.93 BenefitMall 33480 AP
_______________
Account: 135-50029-020-000 Life Insurance & Other Totals: 186.28 850.93 **
2,303.00 Budgeted 1,452.07 Remaining 37 % Used
Account: 135-50030-020-000 Social Security Taxes
794 02/14/2014 PR 02-14-14 Social Security Taxes 4,416.77 425.64 4,842.41 PR
864 02/28/2014 Payroll 2/28/14 Social Security Taxes 425.21 5,267.62 PR
_______________
Account: 135-50030-020-000 Social Security Taxes Totals: 850.85 5,267.62 **
13,805.00 Budgeted 8,537.38 Remaining 38 % Used
Account: 135-50035-020-000 Medicare Taxes
794 02/14/2014 PR 02-14-14 Medicare Taxes 1,032.95 99.55 1,132.50 PR
864 02/28/2014 Payroll 2/28/14 Medicare Taxes 99.44 1,231.94 PR
_______________
Account: 135-50035-020-000 Medicare Taxes Totals: 198.99 1,231.94 **
3,229.00 Budgeted 1,997.06 Remaining 38 % Used
Account: 135-50040-020-000 Unemployment Taxes
794 02/14/2014 PR 02-14-14 Unemployment Taxes 24.58 7.29 31.87 PR
864 02/28/2014 Payroll 2/28/14 Unemployment Taxes 2.63 34.50 PR
Trophy Club Municipal Utility District No. 1 82 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 30
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
_______________
Account: 135-50040-020-000 Unemployment Taxes Totals: 9.92 34.50 **
36.00 Budgeted 1.50 Remaining 96 % Used
Account: 135-50045-020-000 Workman's Compensation
51 02/01/2014 Feb Ins & W/C Expense 2,140.32 535.08 2,675.40 GL
_______________
Account: 135-50045-020-000 Workman's Compensation Totals: 535.08 2,675.40 **
6,552.00 Budgeted 3,876.60 Remaining 41 % Used
Account: 135-50060-020-000 Pre-emp Physicals/Testing
63.00 .00 63.00
_______________
Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 63.00 **
150.00 Budgeted 87.00 Remaining 42 % Used
Account: 135-50070-020-000 Employee Relations
927 02/26/2014 1/28/14-2/26/14 PCards DONUT HAVEN 37.98 8.01 45.99 DONUT HAVEN PC
927 02/26/2014 1/28/14-2/26/14 PCards CHICK-FIL-A #02892 14.00 59.99 CHICK-FIL-A #02892 PC
_______________
Account: 135-50070-020-000 Employee Relations Totals: 22.01 59.99 **
350.00 Budgeted 290.01 Remaining 17 % Used
Account: 135-55070-020-000 Independent Labor
808 02/14/2014 Feb A/P WWTP Improvements 281,411.25 71,565.00 352,976.25 THE WALLACE GROUP, INC. 33470 AP
_______________
Account: 135-55070-020-000 Independent Labor Totals: 71,565.00 352,976.25 **
.00 Budgeted (352,976.25) Remaining 0 % Used
Account: 135-55080-020-000 Maintenance & Repairs
927 02/26/2014 1/28/14-2/26/14 PCards THE HOME DEPOT 6581 18,088.09 19.97 18,108.06 THE HOME DEPOT 6581 PC
927 02/26/2014 1/28/14-2/26/14 PCards THE HOME DEPOT 6581 80.32 18,188.38 THE HOME DEPOT 6581 PC
927 02/26/2014 1/28/14-2/26/14 PCards THE HOME DEPOT 6581 46.20 18,234.58 THE HOME DEPOT 6581 PC
927 02/26/2014 1/28/14-2/26/14 PCards THE HOME DEPOT 6581 198.73 18,433.31 THE HOME DEPOT 6581 PC
927 02/26/2014 1/28/14-2/26/14 PCards THE HOME DEPOT 587 80.25 18,513.56 THE HOME DEPOT 587 PC
870 02/26/2014 Feb A/P Pump Station Pump 1 bad wire c 508.00 19,021.56 XYLEM WATER SOLUTIONS USA INC 33505 AP
_______________
Account: 135-55080-020-000 Maintenance & Repairs Totals: 933.47 19,021.56 **
35,000.00 Budgeted 15,978.44 Remaining 54 % Used
Trophy Club Municipal Utility District No. 1 83 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 31
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-55090-020-000 Vehicle Maintenance
808 02/14/2014 Feb A/P Chains for vehicles 939.49 278.00 1,217.49 ROANOKE AUTO SUPPLY 33464 AP
_______________
Account: 135-55090-020-000 Vehicle Maintenance Totals: 278.00 1,217.49 **
2,000.00 Budgeted 782.51 Remaining 61 % Used
Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader
.00 .00
_______________
Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 **
500.00 Budgeted 500.00 Remaining 0 % Used
Account: 135-55125-020-000 Dumpster Services
870 02/26/2014 Feb A/P Sludge Haul off 9,969.77 2,751.11 12,720.88 L.H. CHANEY MATERIALS, INC. 33497 AP
870 02/26/2014 Feb A/P Sludge Haul off 1,911.24 14,632.12 L.H. CHANEY MATERIALS, INC. 33497 AP
870 02/26/2014 Feb A/P Sludge Haul off 1,814.62 16,446.74 L.H. CHANEY MATERIALS, INC. 33497 AP
_______________
Account: 135-55125-020-000 Dumpster Services Totals: 6,476.97 16,446.74 **
52,000.00 Budgeted 35,553.26 Remaining 32 % Used
Account: 135-55135-020-000 Lab Analysis
870 02/26/2014 Feb A/P Biomonitoring 7,294.13 1,080.00 8,374.13 HUTHER AND ASSOCIATES,INC 33493 AP
870 02/26/2014 Feb A/P Testing 176.00 8,550.13 OXIDOR LABORATORIES LLC 33500 AP
870 02/26/2014 Feb A/P Testing 246.00 8,796.13 OXIDOR LABORATORIES LLC 33500 AP
870 02/26/2014 Feb A/P Testing 246.00 9,042.13 OXIDOR LABORATORIES LLC 33500 AP
870 02/26/2014 Feb A/P Testing 176.00 9,218.13 OXIDOR LABORATORIES LLC 33500 AP
870 02/26/2014 Feb A/P Testing 246.00 9,464.13 OXIDOR LABORATORIES LLC 33500 AP
870 02/26/2014 Feb A/P Testing 176.00 9,640.13 OXIDOR LABORATORIES LLC 33500 AP
870 02/26/2014 Feb A/P Testing 246.00 9,886.13 OXIDOR LABORATORIES LLC 33500 AP
870 02/26/2014 Feb A/P Testing 176.00 10,062.13 OXIDOR LABORATORIES LLC 33500 AP
870 02/26/2014 Feb A/P Testing 246.00 10,308.13 OXIDOR LABORATORIES LLC 33500 AP
870 02/26/2014 Feb A/P Testing 176.00 10,484.13 OXIDOR LABORATORIES LLC 33500 AP
_______________
Account: 135-55135-020-000 Lab Analysis Totals: 3,190.00 10,484.13 **
30,000.00 Budgeted 19,515.87 Remaining 35 % Used
Account: 135-60010-020-000 Communications/Pagers/Mobiles
870 02/26/2014 Feb A/P Charter, Verizon, 1st Check, P 716.08 206.74 922.82 TOWN OF TROPHY CLUB 33503 AP
Trophy Club Municipal Utility District No. 1 84 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 32
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 2/2014
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-020-000 Communications/Pagers/Mobiles Totals: 206.74 922.82 **
3,329.00 Budgeted 2,406.18 Remaining 28 % Used
Account: 135-60020-020-000 Electricity
870 02/26/2014 Feb A/P Electricity 1/13/14-2/11/14 31,385.28 8,479.79 39,865.07 HUDSON ENERGY SERVICES, LLC 33492 AP
_______________
Account: 135-60020-020-000 Electricity Totals: 8,479.79 39,865.07 **
148,227.00 Budgeted 108,361.93 Remaining 27 % Used
Account: 135-60066-020-000 Publications/Books/Subscripts
160.00 .00 160.00
_______________
Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 160.00 **
400.00 Budgeted 240.00 Remaining 40 % Used
Account: 135-60080-020-000 Schools & Training
927 02/26/2014 1/28/14-2/26/14 PCards TCEQ IND RENEWAL L 111.00 111.00 TCEQ IND RENEWAL L PC
927 02/26/2014 1/28/14-2/26/14 PCards TCEQ IND RENEWAL L 111.00 222.00 TCEQ IND RENEWAL L PC
_______________
Account: 135-60080-020-000 Schools & Training Totals: 222.00 222.00 **
2,636.00 Budgeted 2,414.00 Remaining 8 % Used
Account: 135-60090-020-000 Safety Program
371.38 .00 371.38
_______________
Account: 135-60090-020-000 Safety Program Totals: .00 371.38 **
250.00 Budgeted (121.38) Remaining 149 % Used
Account: 135-60100-020-000 Travel & per diem
266.09 .00 266.09
_______________
Account: 135-60100-020-000 Travel & per diem Totals: .00 266.09 **
1,050.00 Budgeted 783.91 Remaining 25 % Used
Account: 135-60105-020-000 Rent/Lease Equipment
299.53 .00 299.53
Trophy Club Municipal Utility District No. 1 85 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 33
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
_______________
Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 299.53 **
1,500.00 Budgeted 1,200.47 Remaining 20 % Used
Account: 135-60135-020-000 TCEQ Fees & Permits
8,919.00 .00 8,919.00
_______________
Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 8,919.00 **
17,150.00 Budgeted 8,231.00 Remaining 52 % Used
Account: 135-60245-020-000 Miscellaneous Expenses
.00 .00
_______________
Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 **
200.00 Budgeted 200.00 Remaining 0 % Used
Account: 135-60285-020-000 Lawn Equipment & Maintenance
.00 .00
_______________
Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 .00 **
500.00 Budgeted 500.00 Remaining 0 % Used
Account: 135-60360-020-000 Furniture/Equipment < $5000
.00 .00
_______________
Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: .00 .00 **
3,000.00 Budgeted 3,000.00 Remaining 0 % Used
Account: 135-65005-020-000 Fuel & Lube
904 02/28/2014 February Gas Log 3,360.83 710.54 4,071.37 GL
_______________
Account: 135-65005-020-000 Fuel & Lube Totals: 710.54 4,071.37 **
14,720.00 Budgeted 10,648.63 Remaining 28 % Used
Account: 135-65010-020-000 Uniforms
1,437.27 .00 1,437.27
Trophy Club Municipal Utility District No. 1 86 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 34
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
_______________
Account: 135-65010-020-000 Uniforms Totals: .00 1,437.27 **
1,752.00 Budgeted 314.73 Remaining 82 % Used
Account: 135-65030-020-000 Chemicals
870 02/26/2014 Feb A/P Chemicals 8,078.12 2,240.00 10,318.12 HARCROS CHEMICALS INC 33490 AP
_______________
Account: 135-65030-020-000 Chemicals Totals: 2,240.00 10,318.12 **
39,000.00 Budgeted 28,681.88 Remaining 26 % Used
Account: 135-65035-020-000 Small Tools
91.00 .00 91.00
_______________
Account: 135-65035-020-000 Small Tools Totals: .00 91.00 **
1,000.00 Budgeted 909.00 Remaining 9 % Used
Account: 135-65040-020-000 Safety Equipment
870 02/26/2014 Feb A/P JPChase PCards 114.08 91.96 206.04 TOWN OF TROPHY CLUB 33503 AP
870 02/26/2014 Feb A/P Items for safety cabinet 24.59 230.63 CINTAS CORPORATION NO. 2 33482 AP
_______________
Account: 135-65040-020-000 Safety Equipment Totals: 116.55 230.63 **
250.00 Budgeted 19.37 Remaining 92 % Used
Account: 135-65045-020-000 Lab Supplies
5,383.58 .00 5,383.58
_______________
Account: 135-65045-020-000 Lab Supplies Totals: .00 5,383.58 **
15,000.00 Budgeted 9,616.42 Remaining 36 % Used
Account: 135-69005-020-000 Capital Expenses
.00 .00
_______________
Account: 135-69005-020-000 Capital Expenses Totals: .00 .00 **
31,000.00 Budgeted 31,000.00 Remaining 0 % Used
Account: 135-69008-020-000 Short Term Debt-Principal
.00 .00
Trophy Club Municipal Utility District No. 1 87 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 35
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
_______________
Account: 135-69008-020-000 Short Term Debt-Principal Totals: .00 .00 **
20,020.00 Budgeted 20,020.00 Remaining 0 % Used
Account: 135-69009-020-000 Short Term Debt-Interest
.00 .00
_______________
Account: 135-69009-020-000 Short Term Debt-Interest Totals: .00 .00 **
1,422.00 Budgeted 1,422.00 Remaining 0 % Used
Account: 135-69280-020-000 Capital Repairs
.00 .00
_______________
Account: 135-69280-020-000 Capital Repairs Totals: .00 .00 **
30,000.00 Budgeted 30,000.00 Remaining 0 % Used
Department 20 Totals: ------------------------------------------------------------------------------------------------ 598,661.71 **
768,011.00 Budgeted 169,349.29 Remaining 78 % Used
Trophy Club Municipal Utility District No. 1 88 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 36
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 21 Collection Program:
Period Ending: 2/2014
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
794 02/14/2014 PR 02-14-14 Salaries & Wages 22,149.83 2,185.07 24,334.90 PR
864 02/28/2014 Payroll 2/28/14 Salaries & Wages 2,134.58 26,469.48 PR
_______________
Account: 135-50005-021-000 Salaries & Wages Totals: 4,319.65 26,469.48 **
90,299.00 Budgeted 63,829.52 Remaining 29 % Used
Account: 135-50010-021-000 Overtime
794 02/14/2014 PR 02-14-14 Overtime 1,835.04 4.99 1,840.03 PR
864 02/28/2014 Payroll 2/28/14 Overtime 293.48 2,133.51 PR
_______________
Account: 135-50010-021-000 Overtime Totals: 298.47 2,133.51 **
10,028.00 Budgeted 7,894.49 Remaining 21 % Used
Account: 135-50016-021-000 Longevity
2,107.50 .00 2,107.50
_______________
Account: 135-50016-021-000 Longevity Totals: .00 2,107.50 **
17,913.00 Budgeted 15,805.50 Remaining 12 % Used
Account: 135-50017-021-000 Certification
864 02/28/2014 Payroll 2/28/14 Certification 600.00 150.00 750.00 PR
_______________
Account: 135-50017-021-000 Certification Totals: 150.00 750.00 **
1,800.00 Budgeted 1,050.00 Remaining 42 % Used
Account: 135-50020-021-000 Retirement
794 02/14/2014 PR 02-14-14 Retirement 2,751.98 196.66 2,948.64 PR
864 02/28/2014 Payroll 2/28/14 Retirement 231.51 3,180.15 PR
_______________
Account: 135-50020-021-000 Retirement Totals: 428.17 3,180.15 **
9,025.00 Budgeted 5,844.85 Remaining 35 % Used
Account: 135-50026-021-000 Medical Insurance
794 02/14/2014 PR 02-14-14 Medical Insurance 6,655.15 701.20 7,356.35 PR
864 02/28/2014 Payroll 2/28/14 Medical Insurance 701.19 8,057.54 PR
_______________
Account: 135-50026-021-000 Medical Insurance Totals: 1,402.39 8,057.54 **
23,668.00 Budgeted 15,610.46 Remaining 34 % Used
Trophy Club Municipal Utility District No. 1 89 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 37
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 21 Collection Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-50027-021-000 Dental Insurance
794 02/14/2014 PR 02-14-14 Dental Insurance 504.99 51.30 556.29 PR
864 02/28/2014 Payroll 2/28/14 Dental Insurance 51.30 607.59 PR
_______________
Account: 135-50027-021-000 Dental Insurance Totals: 102.60 607.59 **
1,703.00 Budgeted 1,095.41 Remaining 36 % Used
Account: 135-50028-021-000 Vision Insurance
794 02/14/2014 PR 02-14-14 Vision Insurance 99.53 11.84 111.37 PR
864 02/28/2014 Payroll 2/28/14 Vision Insurance 11.84 123.21 PR
_______________
Account: 135-50028-021-000 Vision Insurance Totals: 23.68 123.21 **
314.00 Budgeted 190.79 Remaining 39 % Used
Account: 135-50029-021-000 Life Insurance & Other
689 02/01/2014 Feb A/P Dental, Life, STD & Other Ins 396.41 71.54 467.95 METLIFE 33414 AP
_______________
Account: 135-50029-021-000 Life Insurance & Other Totals: 71.54 467.95 **
1,066.00 Budgeted 598.05 Remaining 44 % Used
Account: 135-50030-021-000 Social Security Taxes
794 02/14/2014 PR 02-14-14 Social Security Taxes 1,726.40 116.40 1,842.80 PR
864 02/28/2014 Payroll 2/28/14 Social Security Taxes 138.77 1,981.57 PR
_______________
Account: 135-50030-021-000 Social Security Taxes Totals: 255.17 1,981.57 **
7,442.00 Budgeted 5,460.43 Remaining 27 % Used
Account: 135-50035-021-000 Medicare Taxes
794 02/14/2014 PR 02-14-14 Medicare Taxes 403.76 27.22 430.98 PR
864 02/28/2014 Payroll 2/28/14 Medicare Taxes 32.45 463.43 PR
_______________
Account: 135-50035-021-000 Medicare Taxes Totals: 59.67 463.43 **
1,741.00 Budgeted 1,277.57 Remaining 27 % Used
Account: 135-50040-021-000 Unemployment Taxes
794 02/14/2014 PR 02-14-14 Unemployment Taxes 7.07 2.19 9.26 PR
864 02/28/2014 Payroll 2/28/14 Unemployment Taxes .92 10.18 PR
Trophy Club Municipal Utility District No. 1 90 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 38
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 21 Collection Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
_______________
Account: 135-50040-021-000 Unemployment Taxes Totals: 3.11 10.18 **
198.00 Budgeted 187.82 Remaining 5 % Used
Account: 135-50045-021-000 Workman's Compensation
51 02/01/2014 Feb Ins & W/C Expense 1,070.16 267.54 1,337.70 GL
_______________
Account: 135-50045-021-000 Workman's Compensation Totals: 267.54 1,337.70 **
3,276.00 Budgeted 1,938.30 Remaining 41 % Used
Account: 135-50070-021-000 Employee Relations
927 02/26/2014 1/28/14-2/26/14 PCards DONUT HAVEN 110.01 8.01 118.02 DONUT HAVEN PC
927 02/26/2014 1/28/14-2/26/14 PCards CHICK-FIL-A #02892 14.00 132.02 CHICK-FIL-A #02892 PC
_______________
Account: 135-50070-021-000 Employee Relations Totals: 22.01 132.02 **
200.00 Budgeted 67.98 Remaining 66 % Used
Account: 135-55005-021-000 Engineering
.00 .00
_______________
Account: 135-55005-021-000 Engineering Totals: .00 .00 **
1,500.00 Budgeted 1,500.00 Remaining 0 % Used
Account: 135-55080-021-000 Maintenance & Repairs
878 02/27/2014 Feb A/P Repair sewer line/3 Brook Holl 93.28 2,898.00 2,991.28 William Pratt 33509 AP
_______________
Account: 135-55080-021-000 Maintenance & Repairs Totals: 2,898.00 2,991.28 **
23,801.00 Budgeted 20,809.72 Remaining 13 % Used
Account: 135-55090-021-000 Vehicle Maintenance
808 02/14/2014 Feb A/P Chains for Vac Truck 999.18 999.18 ROANOKE AUTO SUPPLY 33464 AP
_______________
Account: 135-55090-021-000 Vehicle Maintenance Totals: 999.18 999.18 **
2,000.00 Budgeted 1,000.82 Remaining 50 % Used
Account: 135-60010-021-000 Communications/Pagers/Mobiles
870 02/26/2014 Feb A/P Charter, Verizon, 1st Check, P 481.04 102.68 583.72 TOWN OF TROPHY CLUB 33503 AP
Trophy Club Municipal Utility District No. 1 91 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 39
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 21 Collection Program:
Period Ending: 2/2014
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-021-000 Communications/Pagers/Mobiles Totals: 102.68 583.72 **
1,333.00 Budgeted 749.28 Remaining 44 % Used
Account: 135-60020-021-000 Electricity
808 02/14/2014 Feb A/P Electricity 1/3/14-1/31/14 5,979.99 239.76 6,219.75 TRI COUNTY ELECTRIC 33472 AP
808 02/14/2014 Feb A/P Electricity 1/3/14-1/31/14 124.10 6,343.85 TRI COUNTY ELECTRIC 33472 AP
808 02/14/2014 Feb A/P Electricity 1/3/14-1/31/14 27.65 6,371.50 TRI COUNTY ELECTRIC 33472 AP
870 02/26/2014 Feb A/P Electricity 1/11/14-2/11/14 592.30 6,963.80 HUDSON ENERGY SERVICES, LLC 33492 AP
870 02/26/2014 Feb A/P Electricity 1/13/14-2/11/14 1,372.94 8,336.74 HUDSON ENERGY SERVICES, LLC 33492 AP
870 02/26/2014 Feb A/P Electricity 1/11/14-2/10/14 55.23 8,391.97 HUDSON ENERGY SERVICES, LLC 33492 AP
870 02/26/2014 Feb A/P Electricity 1/11/14-2/10/14 30.39 8,422.36 HUDSON ENERGY SERVICES, LLC 33492 AP
870 02/26/2014 Feb A/P Electricity 1/13/14-2/11/14 90.28 8,512.64 HUDSON ENERGY SERVICES, LLC 33492 AP
945 02/28/2014 Town Billed Inv 1137-1147 AR 20140201-20140228 User: (363.48) 8,149.16 AR
_______________
Account: 135-60020-021-000 Electricity Totals: 2,169.17 8,149.16 **
21,178.00 Budgeted 13,028.84 Remaining 38 % Used
Account: 135-60070-021-000 Dues & Memberships
.00 .00
_______________
Account: 135-60070-021-000 Dues & Memberships Totals: .00 .00 **
250.00 Budgeted 250.00 Remaining 0 % Used
Account: 135-60080-021-000 Schools & Training
.00 .00
_______________
Account: 135-60080-021-000 Schools & Training Totals: .00 .00 **
1,711.00 Budgeted 1,711.00 Remaining 0 % Used
Account: 135-60090-021-000 Safety Program
.00 .00
_______________
Account: 135-60090-021-000 Safety Program Totals: .00 .00 **
300.00 Budgeted 300.00 Remaining 0 % Used
Account: 135-60100-021-000 Travel & per diem
.00 .00
Trophy Club Municipal Utility District No. 1 92 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 40
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 21 Collection Program:
Period Ending: 2/2014
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 Totals: .00 .00 **
550.00 Budgeted 550.00 Remaining 0 % 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
904 02/28/2014 February Gas Log 4,172.23 841.37 5,013.60 GL
_______________
Account: 135-65005-021-000 Fuel & Lube Totals: 841.37 5,013.60 **
22,397.00 Budgeted 17,383.40 Remaining 22 % Used
Account: 135-65010-021-000 Uniforms
814.23 .00 814.23
_______________
Account: 135-65010-021-000 Uniforms Totals: .00 814.23 **
1,040.00 Budgeted 225.77 Remaining 78 % Used
Account: 135-65030-021-000 Chemicals
.00 .00
_______________
Account: 135-65030-021-000 Chemicals Totals: .00 .00 **
6,000.00 Budgeted 6,000.00 Remaining 0 % Used
Account: 135-65035-021-000 Small Tools
43.99 .00 43.99
Trophy Club Municipal Utility District No. 1 93 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 41
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 21 Collection Program:
Period Ending: 2/2014
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 Totals: .00 43.99 **
1,000.00 Budgeted 956.01 Remaining 4 % Used
Account: 135-65040-021-000 Safety Equipment
870 02/26/2014 Feb A/P JPChase PCards 540.75 45.98 586.73 TOWN OF TROPHY CLUB 33503 AP
_______________
Account: 135-65040-021-000 Safety Equipment Totals: 45.98 586.73 **
500.00 Budgeted (86.73) Remaining 117 % Used
Account: 135-69005-021-000 Capital Expenses
808 02/14/2014 Feb A/P Balance due Scada for Lift Sta 6,500.00 6,500.00 DHS AUTOMATION, INC 33430 AP
873 02/27/2014 Feb A/P Final pmt LS4 after acceptance 61,800.20 68,300.20 BDMR DEVELOPMENT LLC 33479 AP
_______________
Account: 135-69005-021-000 Capital Expenses Totals: 68,300.20 68,300.20 **
100,000.00 Budgeted 31,699.80 Remaining 68 % Used
Account: 135-69008-021-000 Short Term Debt-Principal
.00 .00
_______________
Account: 135-69008-021-000 Short Term Debt-Principal Totals: .00 .00 **
35,991.00 Budgeted 35,991.00 Remaining 0 % Used
Account: 135-69009-021-000 Short Term Debt-Interest
.00 .00
_______________
Account: 135-69009-021-000 Short Term Debt-Interest Totals: .00 .00 **
2,846.00 Budgeted 2,846.00 Remaining 0 % Used
Account: 135-69280-021-000 Capital Repairs
.00 .00
_______________
Account: 135-69280-021-000 Capital Repairs Totals: .00 .00 **
71,000.00 Budgeted 71,000.00 Remaining 0 % Used
Department 21 Totals: ------------------------------------------------------------------------------------------------ 135,303.92 **
472,170.00 Budgeted 336,866.08 Remaining 29 % Used
Trophy Club Municipal Utility District No. 1 94 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 42
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program:
Period Ending: 2/2014
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
864 02/28/2014 Payroll 2/28/14 Salaries & Wages 3,200.00 500.00 3,700.00 PR
_______________
Account: 135-50005-026-000 Salaries & Wages Totals: 500.00 3,700.00 **
10,000.00 Budgeted 6,300.00 Remaining 37 % Used
Account: 135-50030-026-000 Social Security Taxes
864 02/28/2014 Payroll 2/28/14 Social Security Taxes 198.40 31.00 229.40 PR
_______________
Account: 135-50030-026-000 Social Security Taxes Totals: 31.00 229.40 **
620.00 Budgeted 390.60 Remaining 37 % Used
Account: 135-50035-026-000 Medicare Taxes
864 02/28/2014 Payroll 2/28/14 Medicare Taxes 46.40 7.25 53.65 PR
_______________
Account: 135-50035-026-000 Medicare Taxes Totals: 7.25 53.65 **
145.00 Budgeted 91.35 Remaining 37 % Used
Account: 135-50040-026-000 Unemployment Taxes
864 02/28/2014 Payroll 2/28/14 Unemployment Taxes 3.20 .50 3.70 PR
_______________
Account: 135-50040-026-000 Unemployment Taxes Totals: .50 3.70 **
10.00 Budgeted 6.30 Remaining 37 % Used
Account: 135-50045-026-000 Workman's Compensation
51 02/01/2014 Feb Ins & W/C Expense 11.80 2.95 14.75 GL
_______________
Account: 135-50045-026-000 Workman's Compensation Totals: 2.95 14.75 **
36.00 Budgeted 21.25 Remaining 41 % 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 95 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 43
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
35.00 .00 35.00
_______________
Account: 135-60070-026-000 Dues & Memberships Totals: .00 35.00 **
500.00 Budgeted 465.00 Remaining 7 % Used
Account: 135-60075-026-000 Meetings
35.95 .00 35.95
_______________
Account: 135-60075-026-000 Meetings Totals: .00 35.95 **
1,200.00 Budgeted 1,164.05 Remaining 3 % Used
Account: 135-60080-026-000 Schools & Training
265.00 .00 265.00
_______________
Account: 135-60080-026-000 Schools & Training Totals: .00 265.00 **
4,000.00 Budgeted 3,735.00 Remaining 7 % 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 **
1,000.00 Budgeted 1,000.00 Remaining 0 % Used
Department 26 Totals: ------------------------------------------------------------------------------------------------ 4,337.45 **
22,661.00 Budgeted 18,323.55 Remaining 19 % Used
Trophy Club Municipal Utility District No. 1 96 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 44
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 2/2014
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
794 02/14/2014 PR 02-14-14 Salaries & Wages 144,340.70 17,297.05 161,637.75 PR
864 02/28/2014 Payroll 2/28/14 Salaries & Wages 17,295.94 178,933.69 PR
_______________
Account: 135-50005-030-000 Salaries & Wages Totals: 34,592.99 178,933.69 **
458,721.00 Budgeted 279,787.31 Remaining 39 % Used
Account: 135-50010-030-000 Overtime
794 02/14/2014 PR 02-14-14 Overtime 319.71 12.33 332.04 PR
864 02/28/2014 Payroll 2/28/14 Overtime 16.60 348.64 PR
_______________
Account: 135-50010-030-000 Overtime Totals: 28.93 348.64 **
500.00 Budgeted 151.36 Remaining 70 % Used
Account: 135-50016-030-000 Longevity
3,077.50 .00 3,077.50
_______________
Account: 135-50016-030-000 Longevity Totals: .00 3,077.50 **
3,018.00 Budgeted (59.50) Remaining 102 % Used
Account: 135-50020-030-000 Retirement
794 02/14/2014 PR 02-14-14 Retirement 14,239.60 1,554.39 15,793.99 PR
864 02/28/2014 Payroll 2/28/14 Retirement 1,554.66 17,348.65 PR
_______________
Account: 135-50020-030-000 Retirement Totals: 3,109.05 17,348.65 **
41,419.00 Budgeted 24,070.35 Remaining 42 % Used
Account: 135-50026-030-000 Medical Insurance
794 02/14/2014 PR 02-14-14 Medical Insurance 17,933.76 2,301.30 20,235.06 PR
864 02/28/2014 Payroll 2/28/14 Medical Insurance 2,301.23 22,536.29 PR
_______________
Account: 135-50026-030-000 Medical Insurance Totals: 4,602.53 22,536.29 **
57,923.00 Budgeted 35,386.71 Remaining 39 % Used
Account: 135-50027-030-000 Dental Insurance
794 02/14/2014 PR 02-14-14 Dental Insurance 1,499.44 170.19 1,669.63 PR
864 02/28/2014 Payroll 2/28/14 Dental Insurance 170.23 1,839.86 PR
Trophy Club Municipal Utility District No. 1 97 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 45
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
_______________
Account: 135-50027-030-000 Dental Insurance Totals: 340.42 1,839.86 **
5,100.00 Budgeted 3,260.14 Remaining 36 % Used
Account: 135-50028-030-000 Vision Insurance
794 02/14/2014 PR 02-14-14 Vision Insurance 329.21 40.78 369.99 PR
864 02/28/2014 Payroll 2/28/14 Vision Insurance 40.84 410.83 PR
_______________
Account: 135-50028-030-000 Vision Insurance Totals: 81.62 410.83 **
1,087.00 Budgeted 676.17 Remaining 38 % Used
Account: 135-50029-030-000 Life Insurance & Other
689 02/01/2014 Feb A/P Dental, Life, STD & Other Ins 1,837.63 313.56 2,151.19 METLIFE 33414 AP
873 02/27/2014 Feb A/P Jan Admin/FSA 39.10 2,190.29 BenefitMall 33480 AP
_______________
Account: 135-50029-030-000 Life Insurance & Other Totals: 352.66 2,190.29 **
4,483.00 Budgeted 2,292.71 Remaining 49 % Used
Account: 135-50030-030-000 Social Security Taxes
794 02/14/2014 PR 02-14-14 Social Security Taxes 9,357.26 1,012.29 10,369.55 PR
864 02/28/2014 Payroll 2/28/14 Social Security Taxes 1,000.50 11,370.05 PR
_______________
Account: 135-50030-030-000 Social Security Taxes Totals: 2,012.79 11,370.05 **
28,659.00 Budgeted 17,288.95 Remaining 40 % Used
Account: 135-50035-030-000 Medicare Taxes
794 02/14/2014 PR 02-14-14 Medicare Taxes 2,188.40 236.75 2,425.15 PR
864 02/28/2014 Payroll 2/28/14 Medicare Taxes 233.99 2,659.14 PR
_______________
Account: 135-50035-030-000 Medicare Taxes Totals: 470.74 2,659.14 **
6,702.00 Budgeted 4,042.86 Remaining 40 % Used
Account: 135-50040-030-000 Unemployment Taxes
794 02/14/2014 PR 02-14-14 Unemployment Taxes 48.20 5.54 53.74 PR
864 02/28/2014 Payroll 2/28/14 Unemployment Taxes 4.44 58.18 PR
_______________
Account: 135-50040-030-000 Unemployment Taxes Totals: 9.98 58.18 **
63.00 Budgeted 4.82 Remaining 92 % Used
Trophy Club Municipal Utility District No. 1 98 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 46
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-50045-030-000 Workman's Compensation
51 02/01/2014 Feb Ins & W/C Expense 514.52 128.63 643.15 GL
_______________
Account: 135-50045-030-000 Workman's Compensation Totals: 128.63 643.15 **
1,575.00 Budgeted 931.85 Remaining 41 % Used
Account: 135-50060-030-000 Pre-emp Physicals/Testing
.00 .00
_______________
Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 .00 **
200.00 Budgeted 200.00 Remaining 0 % Used
Account: 135-50070-030-000 Employee Relations
927 02/26/2014 1/28/14-2/26/14 PCards A TOUCH OF HEAVEN 2,460.91 90.67 2,551.58 A TOUCH OF HEAVEN PC
927 02/26/2014 1/28/14-2/26/14 PCards CHICK-FIL-A #02892 14.00 2,565.58 CHICK-FIL-A #02892 PC
927 02/26/2014 1/28/14-2/26/14 PCards A TOUCH OF HEAVEN 69.02 2,634.60 A TOUCH OF HEAVEN PC
_______________
Account: 135-50070-030-000 Employee Relations Totals: 173.69 2,634.60 **
5,000.00 Budgeted 2,365.40 Remaining 53 % Used
Account: 135-55030-030-000 Software & Support
870 02/26/2014 Feb A/P Charter, Verizon, 1st Check, P 18,656.24 645.50 19,301.74 TOWN OF TROPHY CLUB 33503 AP
870 02/26/2014 Feb A/P Pitney Bowes, Kyocera, Acclaim 442.50 19,744.24 TOWN OF TROPHY CLUB 33503 AP
870 02/26/2014 Feb A/P IT BOA PCards 300.99 20,045.23 TOWN OF TROPHY CLUB 33503 AP
870 02/26/2014 Feb A/P IT BOA PCards 259.46 20,304.69 TOWN OF TROPHY CLUB 33503 AP
875 02/27/2014 Feb A/P CareNow, Shi, Premier, Symonds 47.50 20,352.19 TOWN OF TROPHY CLUB 33507 AP
_______________
Account: 135-55030-030-000 Software & Support Totals: 1,695.95 20,352.19 **
59,698.00 Budgeted 39,345.81 Remaining 34 % Used
Account: 135-55070-030-000 Independent Labor
808 02/14/2014 Feb A/P Record CAC meeting 2,235.45 30.00 2,265.45 MIGUEL CRUZ 33453 AP
808 02/14/2014 Feb A/P Record CAC Meeting 37.50 2,302.95 MIGUEL CRUZ 33453 AP
870 02/26/2014 Feb A/P Record MUD meeting 75.00 2,377.95 MIGUEL CRUZ 33499 AP
_______________
Account: 135-55070-030-000 Independent Labor Totals: 142.50 2,377.95 **
7,700.00 Budgeted 5,322.05 Remaining 31 % Used
Account: 135-55080-030-000 Maintenance & Repairs
Trophy Club Municipal Utility District No. 1 99 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 47
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
945 02/28/2014 Town Billed Inv 1137-1147 AR 20140201-20140228 User: (1,760.13) (188.84) (1,948.97) AR
_______________
Account: 135-55080-030-000 Maintenance & Repairs Totals: (188.84) (1,948.97) **
4,500.00 Budgeted 6,448.97 Remaining -43 % Used
Account: 135-55100-030-000 Building Maint & Supplies
808 02/14/2014 Feb A/P Rug Service 1,516.18 94.42 1,610.60 G & K SERVICES 33438 AP
808 02/14/2014 Feb A/P Rug Service 94.42 1,705.02 G & K SERVICES 33438 AP
808 02/14/2014 Feb A/P Rug Service 94.42 1,799.44 G & K SERVICES 33438 AP
808 02/14/2014 Feb A/P Rug Service 94.42 1,893.86 G & K SERVICES 33438 AP
_______________
Account: 135-55100-030-000 Building Maint & Supplies Totals: 377.68 1,893.86 **
6,500.00 Budgeted 4,606.14 Remaining 29 % Used
Account: 135-55120-030-000 Cleaning Services
808 02/14/2014 Feb A/P Janitorial Service/Jan 4,784.91 1,594.97 6,379.88 MEMBER'S BUILDING MAINTENANCE 33452 AP
_______________
Account: 135-55120-030-000 Cleaning Services Totals: 1,594.97 6,379.88 **
19,140.00 Budgeted 12,760.12 Remaining 33 % Used
Account: 135-55160-030-000 Professional Outside Services
.00 .00
_______________
Account: 135-55160-030-000 Professional Outside Services Totals: .00 .00 **
15,000.00 Budgeted 15,000.00 Remaining 0 % Used
Account: 135-55161-030-000 Outside Services-Town Semo
38,524.00 .00 38,524.00
_______________
Account: 135-55161-030-000 Outside Services-Town Semo Totals: .00 38,524.00 **
77,048.00 Budgeted 38,524.00 Remaining 50 % Used
Account: 135-55165-030-000 Collection Fees
.00 .00
_______________
Account: 135-55165-030-000 Collection Fees Totals: .00 .00 **
200.00 Budgeted 200.00 Remaining 0 % Used
Trophy Club Municipal Utility District No. 1 100 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 48
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-55205-030-000 Utility Billing Contract
808 02/14/2014 Feb A/P Jan Utility bills 1,764.35 566.00 2,330.35 DATAPROSE LLC 33428 AP
_______________
Account: 135-55205-030-000 Utility Billing Contract Totals: 566.00 2,330.35 **
6,808.00 Budgeted 4,477.65 Remaining 34 % Used
Account: 135-60005-030-000 Telephone
870 02/26/2014 Feb A/P IT BOA PCards 2,916.11 957.68 3,873.79 TOWN OF TROPHY CLUB 33503 AP
870 02/26/2014 Feb A/P IT BOA PCards 933.57 4,807.36 TOWN OF TROPHY CLUB 33503 AP
870 02/26/2014 Feb A/P Answering service 180.00 4,987.36 KEYSTONE PARK SECRETARIAL 33496 AP
_______________
Account: 135-60005-030-000 Telephone Totals: 2,071.25 4,987.36 **
11,250.00 Budgeted 6,262.64 Remaining 44 % Used
Account: 135-60010-030-000 Communications/Pagers/Mobiles
870 02/26/2014 Feb A/P Charter, Verizon, 1st Check, P 879.79 140.67 1,020.46 TOWN OF TROPHY CLUB 33503 AP
864 02/28/2014 Payroll 2/28/14 Communications/Pagers/Mobiles 150.00 1,170.46 PR
_______________
Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 290.67 1,170.46 **
3,589.00 Budgeted 2,418.54 Remaining 33 % Used
Account: 135-60020-030-000 Electricity/Gas
7,243.58 .00 7,243.58
_______________
Account: 135-60020-030-000 Electricity/Gas Totals: .00 7,243.58 **
15,171.00 Budgeted 7,927.42 Remaining 48 % Used
Account: 135-60025-030-000 Water
808 02/14/2014 Feb A/P Jan water billed 124.67 155.52 280.19 TROPHY CLUB MUD (WATER BILLS) 33473 AP
945 02/28/2014 Town Billed Inv 1137-1147 AR 20140201-20140228 User: (52.11) 228.08 AR
_______________
Account: 135-60025-030-000 Water Totals: 103.41 228.08 **
1,500.00 Budgeted 1,271.92 Remaining 15 % Used
Account: 135-60035-030-000 Postage
808 02/14/2014 Feb A/P Jan Utility bills 6,994.20 1,648.48 8,642.68 DATAPROSE LLC 33428 AP
870 02/26/2014 Feb A/P Pitney Bowes, Kyocera, Acclaim 47.99 8,690.67 TOWN OF TROPHY CLUB 33503 AP
870 02/26/2014 Feb A/P Overnight letter-Audit to TCEQ 5.77 8,696.44 FEDERAL EXPRESS CORP 33486 AP
Trophy Club Municipal Utility District No. 1 101 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 49
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
932 02/28/2014 MUD Postage Meter usage/Feb 6,994.20 332.85 9,029.29 GL
_______________
Account: 135-60035-030-000 Postage Totals: 2,035.09 9,029.29 **
28,500.00 Budgeted 19,470.71 Remaining 32 % Used
Account: 135-60040-030-000 Service Charges & Fees
804 02/01/2014 Dec Account analysis FF Bank 9,530.79 250.00 9,780.79 GL
928 02/04/2014 Credit card fees/Jan 96.90 9,877.69 GL
928 02/04/2014 Credit card fees/Jan 2,136.11 12,013.80 GL
928 02/04/2014 Credit card fees/Jan 50.52 12,064.32 GL
_______________
Account: 135-60040-030-000 Service Charges & Fees Totals: 2,533.53 12,064.32 **
28,330.00 Budgeted 16,265.68 Remaining 43 % Used
Account: 135-60050-030-000 Bad Debt Expense
3,712.56 .00 3,712.56
_______________
Account: 135-60050-030-000 Bad Debt Expense Totals: .00 3,712.56 **
1,500.00 Budgeted (2,212.56) Remaining 248 % Used
Account: 135-60055-030-000 Insurance
51 02/01/2014 Feb Ins & W/C Expense 17,112.17 4,269.73 21,381.90 GL
808 02/14/2014 Feb A/P Bond/Jennifer 50.00 21,431.90 VICTOR O SCHINNERER & CO, INC 33474 AP
_______________
Account: 135-60055-030-000 Insurance Totals: 4,319.73 21,431.90 **
53,561.00 Budgeted 32,129.10 Remaining 40 % Used
Account: 135-60066-030-000 Publications/Books/Subscripts
126.00 .00 126.00
_______________
Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 126.00 **
1,000.00 Budgeted 874.00 Remaining 13 % Used
Account: 135-60070-030-000 Dues & Memberships
4,011.95 .00 4,011.95
_______________
Account: 135-60070-030-000 Dues & Memberships Totals: .00 4,011.95 **
4,500.00 Budgeted 488.05 Remaining 89 % Used
Trophy Club Municipal Utility District No. 1 102 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 50
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-60075-030-000 Meetings
.00 .00
_______________
Account: 135-60075-030-000 Meetings Totals: .00 .00 **
400.00 Budgeted 400.00 Remaining 0 % Used
Account: 135-60080-030-000 Schools & Training
927 02/26/2014 1/28/14-2/26/14 PCards TRWA 502.30 125.00 627.30 TRWA PC
927 02/26/2014 1/28/14-2/26/14 PCards TRWA 399.00 1,026.30 TRWA PC
927 02/26/2014 1/28/14-2/26/14 PCards ACFE 175.00 1,201.30 ACFE PC
_______________
Account: 135-60080-030-000 Schools & Training Totals: 699.00 1,201.30 **
7,500.00 Budgeted 6,298.70 Remaining 16 % Used
Account: 135-60100-030-000 Travel & per diem
703.16 .00 703.16
_______________
Account: 135-60100-030-000 Travel & per diem Totals: .00 703.16 **
5,000.00 Budgeted 4,296.84 Remaining 14 % Used
Account: 135-60110-030-000 Physicals/Testing
.00 .00
_______________
Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 **
200.00 Budgeted 200.00 Remaining 0 % Used
Account: 135-60115-030-000 Elections
.00 .00
_______________
Account: 135-60115-030-000 Elections Totals: .00 .00 **
2,500.00 Budgeted 2,500.00 Remaining 0 % Used
Account: 135-60125-030-000 Advertising
927 02/26/2014 1/28/14-2/26/14 PCards LETS JUMP 156.25 156.25 LETS JUMP PC
927 02/26/2014 1/28/14-2/26/14 PCards AMAZON MKTPLACE PMTS 32.27 188.52 AMAZON MKTPLACE PMTS PC
927 02/26/2014 1/28/14-2/26/14 PCards NEW RESOURCES GROUP, I 166.20 354.72 NEW RESOURCES GROUP, I PC
870 02/26/2014 Feb A/P Publication 74.50 429.22 DENTON PUBLISHING CO 33484 AP
870 02/26/2014 Feb A/P Publication 79.40 508.62 DENTON PUBLISHING CO 33484 AP
Trophy Club Municipal Utility District No. 1 103 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 51
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
_______________
Account: 135-60125-030-000 Advertising Totals: 508.62 508.62 **
2,500.00 Budgeted 1,991.38 Remaining 20 % Used
Account: 135-60235-030-000 Security
123.56 .00 123.56
_______________
Account: 135-60235-030-000 Security Totals: .00 123.56 **
1,350.00 Budgeted 1,226.44 Remaining 9 % Used
Account: 135-60245-030-000 Miscellaneous Expenses
927 02/26/2014 1/28/14-2/26/14 PCards HOT & CREAMY DONUTS 283.08 16.75 299.83 HOT & CREAMY DONUTS PC
927 02/26/2014 1/28/14-2/26/14 PCards SQ *STARBUCKS #06552 T 17.54 317.37 SQ *STARBUCKS #06552 T PC
927 02/26/2014 1/28/14-2/26/14 PCards Fraudulent Transaction (200.00) 117.37 PC
927 02/26/2014 1/28/14-2/26/14 PCards Fraudulent Transaction (200.00) (82.63) PC
927 02/26/2014 1/28/14-2/26/14 PCards Fraudulent Transaction (200.00) (282.63) PC
927 02/26/2014 1/28/14-2/26/14 PCards Fraudulent Transaction 200.00 (82.63) CORNER STORE 2302 PC
927 02/26/2014 1/28/14-2/26/14 PCards Fraudulent Transaction 200.00 117.37 CORNER STORE 2091 PC
927 02/26/2014 1/28/14-2/26/14 PCards Fraudulent Transaction 200.00 317.37 CORNER STORE 2091 PC
875 02/27/2014 Feb A/P Reimburse Petty Cash 29.17 346.54 TROPHY CLUB MUD PETTY CASH 33508 AP
_______________
Account: 135-60245-030-000 Miscellaneous Expenses Totals: 63.46 346.54 **
22,870.00 Budgeted 22,523.46 Remaining 2 % 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
.00 .00
_______________
Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 .00 **
2,500.00 Budgeted 2,500.00 Remaining 0 % Used
Account: 135-65010-030-000 Uniforms
998.90 .00 998.90
Trophy Club Municipal Utility District No. 1 104 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 52
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
_______________
Account: 135-65010-030-000 Uniforms Totals: .00 998.90 **
1,390.00 Budgeted 391.10 Remaining 72 % Used
Account: 135-65055-030-000 Hardware
870 02/26/2014 Feb A/P IT BOA PCards 1,677.95 32.56 1,710.51 TOWN OF TROPHY CLUB 33503 AP
870 02/26/2014 Feb A/P CareNow, Shi 13.15 1,723.66 TOWN OF TROPHY CLUB 33503 AP
870 02/26/2014 Feb A/P CareNow, Shi 22.00 1,745.66 TOWN OF TROPHY CLUB 33503 AP
_______________
Account: 135-65055-030-000 Hardware Totals: 67.71 1,745.66 **
13,562.00 Budgeted 11,816.34 Remaining 13 % Used
Account: 135-65085-030-000 Office Supplies
808 02/14/2014 Feb A/P Office Supplies 1,576.94 42.70 1,619.64 OFFICE DEPOT, INC 33456 AP
808 02/14/2014 Feb A/P Office Supplies 11.49 1,631.13 OFFICE DEPOT, INC 33456 AP
808 02/14/2014 Feb A/P Office Supplies 58.33 1,689.46 OFFICE DEPOT, INC 33456 AP
927 02/26/2014 1/28/14-2/26/14 PCards KELLER TROPHY AND AWAR 89.85 1,779.31 KELLER TROPHY AND AWAR PC
927 02/26/2014 1/28/14-2/26/14 PCards OFFICE DEPOT #2255 81.13 1,860.44 OFFICE DEPOT #2255 PC
927 02/26/2014 1/28/14-2/26/14 PCards OFFICE DEPOT #406 59.93 1,920.37 OFFICE DEPOT #406 PC
927 02/26/2014 1/28/14-2/26/14 PCards AMAZON MKTPLACE PMTS 13.26 1,933.63 AMAZON MKTPLACE PMTS PC
870 02/26/2014 Feb A/P JPChase PCards 71.29 2,004.92 TOWN OF TROPHY CLUB 33503 AP
875 02/27/2014 Feb A/P CareNow, Shi, Premier, Symonds 132.00 2,136.92 TOWN OF TROPHY CLUB 33507 AP
945 02/28/2014 Town Billed Inv 1137-1147 AR 20140201-20140228 User: (43.48) 2,093.44 AR
_______________
Account: 135-65085-030-000 Office Supplies Totals: 516.50 2,093.44 **
9,100.00 Budgeted 7,006.56 Remaining 23 % Used
Account: 135-65090-030-000 Printer Supplies & Maintenance
1,246.33 .00 1,246.33
_______________
Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 1,246.33 **
5,732.00 Budgeted 4,485.67 Remaining 22 % Used
Account: 135-65095-030-000 Maintenance Supplies
927 02/26/2014 1/28/14-2/26/14 PCards SAMSCLUB #4795 815.54 88.71 904.25 SAMSCLUB #4795 PC
927 02/26/2014 1/28/14-2/26/14 PCards SAMSCLUB #4795 207.24 1,111.49 SAMSCLUB #4795 PC
_______________
Account: 135-65095-030-000 Maintenance Supplies Totals: 295.95 1,111.49 **
2,500.00 Budgeted 1,388.51 Remaining 44 % Used
Trophy Club Municipal Utility District No. 1 105 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 53
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 30 Administration Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 135-65097-030-000 Vending Machine Supplies
51.00 .00 51.00
_______________
Account: 135-65097-030-000 Vending Machine Supplies Totals: .00 51.00 **
200.00 Budgeted 149.00 Remaining 26 % Used
Account: 135-65105-030-000 Printing
1,401.00 .00 1,401.00
_______________
Account: 135-65105-030-000 Printing Totals: .00 1,401.00 **
4,000.00 Budgeted 2,599.00 Remaining 35 % Used
Account: 135-69170-030-000 Copier Lease Installments
870 02/26/2014 Feb A/P Pitney Bowes, Kyocera, Acclaim 770.55 256.85 1,027.40 TOWN OF TROPHY CLUB 33503 AP
_______________
Account: 135-69170-030-000 Copier Lease Installments Totals: 256.85 1,027.40 **
3,450.00 Budgeted 2,422.60 Remaining 30 % Used
Department 30 Totals: ------------------------------------------------------------------------------------------------ 390,524.03 **
1,055,199.00 Budgeted 664,674.97 Remaining 37 % Used
Trophy Club Municipal Utility District No. 1 106 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 54
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program:
Period Ending: 2/2014
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
808 02/14/2014 Feb A/P Legal 85,943.22 1,350.25 87,293.47 THE LISTON LAW FIRM, P.C. 33469 AP
808 02/14/2014 Feb A/P Legal 9,515.00 96,808.47 FREEMAN & CORBETT 33436 AP
_______________
Account: 135-55045-039-000 Legal Totals: 10,865.25 96,808.47 **
131,300.00 Budgeted 34,491.53 Remaining 74 % Used
Account: 135-55055-039-000 Auditing
21,200.00 .00 21,200.00
_______________
Account: 135-55055-039-000 Auditing Totals: .00 21,200.00 **
21,840.00 Budgeted 640.00 Remaining 97 % Used
Account: 135-55060-039-000 Appraisal
4,329.38 .00 4,329.38
_______________
Account: 135-55060-039-000 Appraisal Totals: .00 4,329.38 **
10,000.00 Budgeted 5,670.62 Remaining 43 % Used
Account: 135-55065-039-000 Tax Admin Fees
2,451.40 .00 2,451.40
_______________
Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,451.40 **
3,800.00 Budgeted 1,348.60 Remaining 65 % Used
Department 39 Totals: ------------------------------------------------------------------------------------------------ 124,789.25 **
166,940.00 Budgeted 42,150.75 Remaining 75 % Used
Fund 135 Totals: ------------------------------------------------------------------------------------------------------ 234,930.23
.00 Budgeted (234,930.23) Remaining 0 % Used
Trophy Club Municipal Utility District No. 1 107 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 55
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 507 MUD 1 Capital Projects Department: Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 507-49010-000-000 Interest Income
929 02/28/2014 Bank Statement Interest/Feb (42.62) (4.07) (46.69) GL
_______________
Account: 507-49010-000-000 Interest Income Totals: (4.07) (46.69) **
.00 Budgeted 46.69 Remaining 0 % Used
Department Totals: ------------------------------------------------------------------------------------------------ (46.69) **
.00 Budgeted 46.69 Remaining 0 % Used
Trophy Club Municipal Utility District No. 1 108 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 56
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 507 MUD 1 Capital Projects Department: 10 Water Program: 2 Rate of Flow Control-FW Meter
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
Account: 507-69280-010-002 Capital Repairs/ROFC FW Meter
82,629.40 .00 82,629.40
_______________
Account: 507-69280-010-002 Capital Repairs/ROFC FW Meter Totals: .00 82,629.40 **
.00 Budgeted (82,629.40) Remaining 0 % Used
Department 10 Totals: ------------------------------------------------------------------------------------------------ 82,629.40 **
.00 Budgeted (82,629.40) Remaining 0 % Used
Fund 507 Totals: ------------------------------------------------------------------------------------------------------ 82,582.71
.00 Budgeted (82,582.71) Remaining 0 % Used
Trophy Club Municipal Utility District No. 1 109 of 132 March 18, 2014 Regular Meeting Agenda Packet
TROPHY CLUB MUD #1 - I&S
BALANCE SHEET
FEBRUARY 28, 2014
INTEREST &
SINKING
ASSETS
CASH IN BANK 4,846
INVESTMENTS 493,742
PREPAID EXPENSES -
ADVALOREM PROPERTY TAXES RECEIVABLE 29,196
ACCOUNTS RECEIVABLE-OTHER -
TOTAL ASSETS 527,784
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 29,196
ACCOUNTS AND OTHER PAYABLES -
TOTAL LIABILITIES 29,196
FUND BALANCE
ASSIGNED FUND BALANCE 17,879
NET REVENUES / EXPENDITURES 480,709
TOTAL FUND BALANCE 498,588
TOTAL LIABILITIES AND FUND BALANCE 527,784
Trophy Club Municipal Utility District No. 1 110 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 18
11:19 03/07/14 Budget Summary with Amendment
Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program:
Period Ending: 2/2014
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
533-40000-000-000 Property Taxes 389,216.00- 389,216.00- 35,997.50- 368,942.90- 94.791 20,273.10-
533-40002-000-000 Property Taxes/Delinquent 2,500.00- 2,500.00- 1.39 -.056 2,501.39-
533-40015-000-000 Property Taxes/P & I 1,600.00- 1,600.00- 618.87- 634.06- 39.629 965.94-
Subtotal: 393,316.00- 393,316.00- 36,616.37- 369,575.57- 93.964 23,740.43-
533-48005-000-000 Reserve Funds/PID Utility Fees 16,525.00- 16,525.00- 16,525.00-
Subtotal: 16,525.00- 16,525.00- 16,525.00-
533-49010-000-000 Interest Income 375.00- 375.00- 12.09- 20.67- 5.512 354.33-
533-49015-000-000 Lease/Rental Income 214,279.00- 214,279.00- 214,279.00- 214,279.00- 100.000
Subtotal: 214,654.00- 214,654.00- 214,291.09- 214,299.67- 99.835 354.33-
Program number: 624,495.00- 624,495.00- 250,907.46- 583,875.24- 93.496 40,619.76-
Department number: Revenues 624,495.00- 624,495.00- 250,907.46- 583,875.24- 93.496 40,619.76-
Revenues Subtotal ----------- 624,495.00- 624,495.00- 250,907.46- 583,875.24- 93.496 40,619.76-
Trophy Club Municipal Utility District No. 1 111 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glbase_tbam rgonzale Trophy Club MUD #1 Page 19
11:19 03/07/14 Budget Summary with Amendment
Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program:
Period Ending: 2/2014
Account Description Adopted Amended Total Current YTD % of Remaining
Budget Budget Encumb. Month Total Budget Budget
533-70005-051-000 Paying Agent Fee/Bond Issuance 2,300.00 2,300.00 2,300.00
533-70025-051-000 Bond Interest Expense 197,195.00 197,195.00 103,166.25 103,166.25 52.317 94,028.75
533-70035-051-000 Bond Principal Payment 425,000.00 425,000.00 425,000.00
Subtotal: 624,495.00 624,495.00 103,166.25 103,166.25 16.520 521,328.75
Program number: 624,495.00 624,495.00 103,166.25 103,166.25 16.520 521,328.75
Department number: Administration 624,495.00 624,495.00 103,166.25 103,166.25 16.520 521,328.75
Expenditures Subtotal ----------- 624,495.00 624,495.00 103,166.25 103,166.25 16.520 521,328.75
Fund number: 533 MUD 1 I&S Consolidated 147,741.21- 480,708.99- 480,708.99
******* End of Report *********
Trophy Club Municipal Utility District No. 1 112 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 57
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program:
Period Ending: 2/2014
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
886 02/01/2014 Property Taxes/Assessments (332,945.40) (7,619.83) (340,565.23) GL
887 02/03/2014 Property Taxes/Assessments (3,550.54) (344,115.77) GL
888 02/04/2014 Property Taxes/Assessments (2,469.18) (346,584.95) GL
889 02/05/2014 Property Taxes/Assessments (6,266.79) (352,851.74) GL
890 02/06/2014 Property Taxes/Assessments (1,447.84) (354,299.58) GL
891 02/07/2014 Property Taxes/Assessments (5,928.14) (360,227.72) GL
892 02/10/2014 Property Taxes/Assessments (3.47) (360,231.19) GL
893 02/12/2014 Property Taxes/Assessments (310.86) (360,542.05) GL
894 02/13/2014 Property Taxes/Assessments (606.42) (361,148.47) GL
895 02/14/2014 Property Taxes/Assessments (43.89) (361,192.36) GL
896 02/18/2014 Property Taxes/Assessments (7,206.72) (368,399.08) GL
897 02/20/2014 Property Taxes/Assessments (20.47) (368,419.55) GL
898 02/24/2014 Property Taxes/Assessments (221.58) (368,641.13) GL
899 02/25/2014 Property Taxes/Assessments (7.85) (368,648.98) GL
900 02/27/2014 Property Taxes/Assessments (124.07) (368,773.05) GL
901 02/28/2014 Property Taxes/Assessments (169.85) (368,942.90) GL
_______________
Account: 533-40000-000-000 Property Taxes Totals: (35,997.50) (368,942.90) **
(389,216.00) Budgeted (20,273.10) Remaining 95 % Used
Account: 533-40002-000-000 Property Taxes/Delinquent
1.39 .00 1.39
_______________
Account: 533-40002-000-000 Property Taxes/Delinquent Totals: .00 1.39 **
(2,500.00) Budgeted (2,501.39) Remaining 0 % Used
Account: 533-40015-000-000 Property Taxes/P & I
944 02/04/2014 Property Taxes/Assessments (15.19) (8.09) (23.28) GL
890 02/06/2014 Property Taxes/Assessments (5.70) (28.98) GL
892 02/10/2014 Property Taxes/Assessments (5.24) (34.22) GL
893 02/12/2014 Property Taxes/Assessments (19.50) (53.72) GL
894 02/13/2014 Property Taxes/Assessments (38.77) (92.49) GL
895 02/14/2014 Property Taxes/Assessments (3.07) (95.56) GL
896 02/18/2014 Property Taxes/Assessments (504.49) (600.05) GL
897 02/20/2014 Property Taxes/Assessments (1.43) (601.48) GL
898 02/24/2014 Property Taxes/Assessments (15.50) (616.98) GL
899 02/25/2014 Property Taxes/Assessments (.55) (617.53) GL
900 02/27/2014 Property Taxes/Assessments (8.69) (626.22) GL
901 02/28/2014 Property Taxes/Assessments (7.84) (634.06) GL
Trophy Club Municipal Utility District No. 1 113 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 58
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program:
Period Ending: 2/2014
JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source
Number Date Description Description/Comment Balance Detail Detail Number
(SUBTOTAL)
_______________
Account: 533-40015-000-000 Property Taxes/P & I Totals: (618.87) (634.06) **
(1,600.00) Budgeted (965.94) Remaining 40 % Used
Account: 533-48005-000-000 Reserve Funds/PID Utility Fees
.00 .00
_______________
Account: 533-48005-000-000 Reserve Funds/PID Utility Fees Totals: .00 .00 **
(16,525.00) Budgeted (16,525.00) Remaining 0 % Used
Account: 533-49010-000-000 Interest Income
929 02/28/2014 Bank Statement Interest/Feb (8.58) (12.09) (20.67) GL
_______________
Account: 533-49010-000-000 Interest Income Totals: (12.09) (20.67) **
(375.00) Budgeted (354.33) Remaining 6 % Used
Account: 533-49015-000-000 Lease/Rental Income
902 02/04/2014 FD Rent to I&S (214,279.00) (214,279.00) GL
_______________
Account: 533-49015-000-000 Lease/Rental Income Totals: (214,279.00) (214,279.00) **
(214,279.00) Budgeted .00 Remaining 100 % Used
Department Totals: ------------------------------------------------------------------------------------------------ (583,875.24) **
(624,495.00) Budgeted (40,619.76) Remaining 93 % Used
Trophy Club Municipal Utility District No. 1 114 of 132 March 18, 2014 Regular Meeting Agenda Packet
.
glpdatb2 rgonzale Trophy Club MUD #1 Page 59
11:19 03/07/14 Detailed Accounting Trial Balance
Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program:
Period Ending: 2/2014
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/Bond Issuance
.00 .00
_______________
Account: 533-70005-051-000 Paying Agent Fee/Bond Issuance Totals: .00 .00 **
2,300.00 Budgeted 2,300.00 Remaining 0 % Used
Account: 533-70025-051-000 Bond Interest Expense
880 02/27/2014 Wires for Bond payments M1 UT Bonds 2010 (Fire Sta) 38,091.25 38,091.25 GL
880 02/27/2014 Wires for Bond payments M1 Series 2012 28,525.00 66,616.25 GL
881 02/28/2014 Wire for Bond Payment M1 Series 2013 36,550.00 103,166.25 GL
_______________
Account: 533-70025-051-000 Bond Interest Expense Totals: 103,166.25 103,166.25 **
197,195.00 Budgeted 94,028.75 Remaining 52 % Used
Account: 533-70035-051-000 Bond Principal Payment
.00 .00
_______________
Account: 533-70035-051-000 Bond Principal Payment Totals: .00 .00 **
425,000.00 Budgeted 425,000.00 Remaining 0 % Used
Department 51 Totals: ------------------------------------------------------------------------------------------------ 103,166.25 **
624,495.00 Budgeted 521,328.75 Remaining 17 % Used
Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (480,708.99)
.00 Budgeted 480,708.99 Remaining 0 % Used
Grand Totals: --------------------------------------------------------------------------------------------------------- (807,540.43) ****
.00 Budgeted 807,540.43 Remaining 0 % Used
******* End of Report *********
Trophy Club Municipal Utility District No. 1 115 of 132 March 18, 2014 Regular Meeting Agenda Packet
BUDGET VARIANCE REPORT
FUND:122 - Fire O&M
FINANCIALS MONTH:February 2014
REVENUE VARIANCE 33%
EXPENSE VARIANCE:52%
NOTE:
ACCOUNT DESCRIPTION TOTAL
BUDGET
CURRENT
YTD
TOTAL
YTD %VARIANCE EXPLANATION
FIRE REVENUES
122-40015-000 Property Taxes/Assessments P&I $ 750 66$ 66$ 9%Collection of past due
taxes/assessment accounts
FIRE EXPENSES
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 116 of 132 March 18, 2014 Regular Meeting Agenda Packet
BUDGET VARIANCE REPORT
FUND:135 - MUD 1 O&M
FINANCIALS MONTH:February 2014
REVENUE VARIANCE:33%
EXPENSE VARIANCE:52%
NOTE:
ACCOUNT DESCRIPTION TOTAL
BUDGET
CURRENT
MONTH
YTD
TOTAL
YTD %VARIANCE EXPLANATION
REVENUE
135-40015-000 Property Taxes P&I $ 900 $ 158 $ 147 16%Collection of delinquent accounts
135-47000-000 Water $ 3,749,310 $ 161,408 $ 924,315 25%Cooler Weather- Less Water Use
135-47025-000 Penalties $ 64,522 $ 4,671 $ 20,487 32%More timely payments
135-47070-000 TCCC Effluent Charges $ 79,586 $ 229 $ 8,053 10%Cooler Weather- Less Effluent sold to
golf course
WATER
135-50010-010 Overtime 13,391$ 1,372$ 7,907$ 59%Weather related pipe issues &24"
totalizer meter installation
135-50040-010 Unemployments Taxes 54$ 14$ 53$ 98%Tax paid on first $9,000 wages per
employee
135-55080-010 Maintenance & Repairs 50,000$ 13,433$ 38,635$ 77%24" water meter
135-60135-010 TCEQ Fees & Permits 47,400$ 2,840$ 32,196$ 68%North Texas Groundwater and LCRA
135-65030-010 Chemicals 5,000$ 622$ 2,667$ 53%DPC Industries,Hach Company and
DX Service
135-55135-010-001 Lab Analysis 1,000$ 80$ 598$ 60%Bac T samples/PID
WASTEWATER
135-50040-020 Unemployment Taxes 36$ 10$ 35$ 96%Taxes paid on first $9,000 of wages
per employee
135-55080-020 Maintenance & Repairs 35,000$ 933$ 19,022$ 54%Home Depot
135-55090-020 Vehicle Maintenance 2,000$ 278$ 1,217$ 61%Auto Parts
135-65040-020 Safety Equipment 250$ 117$ 231$ 92%Safety supplies
COLLECTIONS
135-50070-021 Employee Relations 200$ 22$ 132$ 66%Safety Meeting and Monthly Employee
Meeting
135-65040-021 Safety Equipment 500$ 46$ 587$ 117%Safety supplies
135-69005-021 Capital Expenses 100,000$ 68,300$ 68,300$ 68%Final pmt scada and Developer shared
cost LS4 after acceptance
BOARD OF DIRECTORS
ADMINISTRATION
135-50010-030 Overtime 500$ 29$ 349$ 70%Utility Billing
135-50040-030 Unemployment Taxes 63$ 10$ 58$ 92%Taxes paid on the first $9,000 of
wages per employee
135-50070-030 Employee Relations 5,000$ 174$ 2,635$ 53%Flowers for a Funeral
NON-DEPARTMENTAL
135-55045-039 Legal 131,300$ 10,865$ 96,808$ 74%Legal
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 117 of 132 March 18, 2014 Regular Meeting Agenda Packet
Oct.Nov.Dec.Jan Feb.March April May June July August Sept.Total for year
FYI- Physical Year
2005-2006 74,441 56,296 41,272 54,171 37,626 35,714 55,429 60,800 88,899 113,904 122,820 81,806 823,178
2006-2007 73,757 44,297 35,905 31,695 25,671 40,516 43,121 31,204 42,191 43,717 72,462 76,138 560,674
2007-2008 63,250 47,082 33,371 37,194 31,472 30,766 40,313 48,829 78,091 91,664 115,042 75,494 692,568
2008-2009 63,730 48,170 35,215 35,759 32,240 39,331 46,151 37,382 56,370 125,089 91,724 79,137 690,298
2009-2010 39,794 39,713 29,547 30,305 25,328 23,279 41,646 53,439 102,921 89,760 128,687 82,331 686,750
2010-2011 70,502 50,909 44,365 35,983 27,845 55,972 69,165 61,467 99,326 117,707 170,464 123,692 927,397
2011-2012 85,869 53,571 40,815 30,616 31,665 35,263 47,194 84,905 114,104 137,174 144,573 108,622 914,371
2012-2013 85,488 75,251 48,527 39,601 34,450 43,137 56,947 76,542 85,312 110,072 130,945 114,497 900,769
2013-2014 82,660 48,813 34,482 39,767 37,085
October November December January February March April May June July August
79,297 48,609 36,966 32,915 26,974 25,771 31,755 46,747 70,315 69,134 92,539
84,849 51,836 38,869 32,850 24,742 25,111 32,240 47,364 75,755 68,715 82,007
90,400 55,063 40,772 32,785 22,510 24,451 32,726 47,980 81,195 68,296 71,476
95,952 58,290 42,675 32,721 20,278 23,791 33,211 48,597 86,636 67,878
350,497 213,799 159,281 131,271 94,504 99,122 129,932 190,688 313,900 274,022 246,022
Oct.Nov.Dec.Jan Feb.March April May June July August Sept.Total for year
FYI- Physical Year
2006 74,585 55,405 42,852 52,100 33,247 39,250 64,455 73,048 93,187 118,353 127,450 76,301 850,233
2007 72,460 49,249 34,203 28,257 31,492 43,900 41,770 37,340 41,215 43,136 75,480 72,087 570,589
2008 64,370 50,090 35,320 36,610 34,630 34,750 42,900 63,116 78,399 114,256 98,670 72,551 725,662
2009 65,110 48,570 36,411 36,587 36,385 44,120 48,881 38,250 66,450 116,823 94,525 81,500 713,612
2010 40,803 41,600 32,700 31,400 30,145 27,240 43,400 62,646 113,049 94,950 131,650 76,159 725,742
2011 70,502 50,993 44,220 33,789 36,053 54,775 71,306 63,500 116,350 152,002 169,621 117,190 980,301
2012 83,750 54,245 41,650 34,740 31,581 46,519 62,649 100,402 110,324 153,813 139,005 123,045 981,723
2013 85,966 77,758 55,110 39,283 37,867 56,743 60,969 87,168 96,602 119,414 145,988 120,342 983,210
2014 81,909 51,769 39,769 48,758 42,395
.
Active Connections MUD PID MUD PID
2007 2008 2009 2010 2011 2012 2013 2013 2014 2014
January 2815 2853 2976 3151 3358 3640 3915 3028 1178
February 2815 2865 2977 3168 3366 3667 3932 3026 1183
March 2817 2865 3013 3201 3392 3701 3950
April 2817 2855 3014 3210 3409 3725 3978
May 2825 2897 3004 3229 3465 3735 4028
June 2825 2897 3056 3251 3433 3759 4062
July 2825 2914 3064 3260 3471 3796 4084
August 2825 2927 3083 3282 3559 3815 4095
September 2869 2929 3105 3298 3573 3863 3031 1088
October 2869 2946 3113 3318 3542 3879 3014 1125
November 2857 2952 3127 3334 3540 3887 3015 1142
December 2867 2956 3146 3351 3582 3880 3014 1159
0
20,000
40,000
60,000
80,000
100,000
120,000
140,000
160,000
180,000 Million Gallons Months
Water Billed
2011
2012
2013
2014
0
20,000
40,000
60,000
80,000
100,000
120,000
140,000
160,000
180,000 Million Gallons Months
Water Pumped
2011
2012
2013
2014
Trophy Club Municipal Utility District No. 1 118 of 132 March 18, 2014 Regular Meeting Agenda Packet
% Removal % Removal % Removal
Influent Effluent Influent Effluent Influent Effluent
3-Feb 40 1.14 97.2%226 2.0 99.1%283 3.2 98.9%
4-Feb 46 1.2 97.4%160 4.2 97.4%114 2.4 97.9%
10-Feb 40 0.88 97.8%181 2.0 98.9%178 2.2 98.8%
12-Feb 44 1.24 97.2%184 2.0 98.9%238 2.4 99.0%
17-Feb 34 3.2 90.6%159 6.8 95.7%170 1.0 99.4%
18-Feb 31 1.18 96.2%125 2.0 98.4%98 4.4 95.5%
24-Feb 48 3.95 91.8%125 2.5 98.0%230 2.8 98.8%
25-Feb 43 1.41 96.7%235 5.1 97.8%176 1.8 99.0%
95.6%98.0%98.4%
Date
Report
February 2014 Results
Ammonia-N CBOD5 TSS
1.78 3.3 2.53
Ammonia-N CBOD5 TSS
Trophy Club Municipal Utility District No. 1 119 of 132 March 18, 2014 Regular Meeting Agenda Packet
Max mg/L 1.78 Aver mg/L 1.725
h Aver
Max mg/L 3.6 Aver mg/L 3.5
Ammonia Nitrogen
Carbonaceous Biochemical Demand (CBOD5)1.67 1.780 0.00
0.50
1.00
1.50
2.00
2.50
3.00
3.50
4.00 Jan-14 Feb-14 Mar-14 Apr-14 May-14 Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Permit Limit 1.0
April-Sept 3.0
Oct -March
Average
NH3-N 3.600 3.300 0.00
1.00
2.00
3.00
4.00
5.00
6.00
7.00
8.00
9.00
10.00 Jan-14 Feb-14 Mar-14 Apr-14 May-14 Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Permit Limit
5
CBOD5
Average
Trophy Club Municipal Utility District No. 1 120 of 132 March 18, 2014 Regular Meeting Agenda Packet
S A
Max mg/L 2.74 Aver mg/L 2.6
Max mg/L 14.0 Aver mg/L 13.3
Max mg/L 1.3 Aver mg/L 1.2
C li Aver
Nitrate - Nitrogen
E. Coli
Total Suspended Solids (TSS)2.7 2.5 0.00
10.00
20.00
30.00
40.00
50.00 Jan-14 Feb-14 Mar-14 Apr-14 May-14 Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Permit Limit
12.0
Average
TSS 12.6 14.0 0.00
5.00
10.00
15.00
20.00
25.00
30.00 Jan-14 Feb-14 Mar-14 Apr-14 May-14 Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Permit
Limit 24
N-N
Average 1.3 1.1 0.00
20.00
40.00
60.00
80.00
100.00
120.00 Jan-14 Feb-14 Mar-14 Apr-14 May-14 Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Permit
Limit 126
E. coli
Average
Trophy Club Municipal Utility District No. 1 121 of 132 March 18, 2014 Regular Meeting Agenda Packet
Max mg/L 7.3 Min mg/L 7.2 Aver mg/L 7.3
Limit
Max mg/L 7.4 Aver mg/L 7.4
Potential for Hydrogen (pH)
Dissolved Oxygen (DO)
7.2 7.2
0.00
2.00
4.00
6.00
8.00
10.00
12.00
14.00 Jan-14 Feb-14 Mar-14 Apr-14 May-14 Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Permit Limit Mimimum
6.0 Average
pH minimum 7.4 7.4 0.00
1.00
2.00
3.00
4.00
5.00
6.00
7.00
8.00
9.00 Jan-14 Feb-14 Mar-14 Apr-14 May-14 Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Permit Limit
(ABOVE)
6.0
Average
DO
Trophy Club Municipal Utility District No. 1 122 of 132 March 18, 2014 Regular Meeting Agenda Packet
Go to this reportTrophy Club MUD http://www.tdmud.…
All Web Site Data
Feb 1, 2014 Feb 28, 2014Audience Overview
Language Visits % Visits
1.enus 1,765 99.32%
2.c 3 0.17%
3.engb 3 0.17%
4.en 2 0.11%
5.enca 1 0.06%
6.eses 1 0.06%
7.kokr 1 0.06%
8.zhcn 1 0.06%
Overview
Visits
Feb 8 Feb 15 Feb 22
100100100
200200200
Visits
1,777
Unique Visitors
1,349
Pageviews
3,469
Pages / Visit
1.95
Avg. Visit Duration
00:01:31
Bounce Rate
61.00%
% New Visits
46.54%
Returning Visitor New Visitor
46.7%
53.3%
All Visits
100.00%
Trophy Club Municipal Utility District No. 1 123 of 132 March 18, 2014 Regular Meeting Agenda Packet
Go to this reportTrophy Club FIRE http://www.trophyc…
All Web Site Data
Feb 1, 2014 Feb 28, 2014Audience Overview
Language Visits % Visits
1.enus 247 94.27%
2.ptbr 6 2.29%
3.c 1 0.38%
4.engb 1 0.38%
5.enin 1 0.38%
6.eses 1 0.38%
7.essv 1 0.38%
8.fr 1 0.38%
9.frfr 1 0.38%
10.ja 1 0.38%
Overview
Visits
Feb 8 Feb 15 Feb 22
101010
202020
Visits
262
Unique Visitors
240
Pageviews
614
Pages / Visit
2.34
Avg. Visit Duration
00:00:54
Bounce Rate
48.47%
% New Visits
82.44%
New Visitor Returning Visitor
17.6%
82.4%
All Visits
100.00%
Trophy Club Municipal Utility District No. 1 124 of 132 March 18, 2014 Regular Meeting Agenda Packet
From:Mike Pastor
To:Laurie Slaght
Subject:Information Services Monthly Overview - Jan 2014
Date:Wednesday, March 05, 2014 11:23:00 AM
Helpdesk Activity for Jan 2014:
Town: 76
MUD: 18
Shared: 8
Total: 102
Core server and network uptime for Jan 2014:
Server: %98.949
Network: %87.830
Video Streaming - Summary Totals for All Activity for Jan 2014:
Data Transfer: 46.10 GB
Hits: 518
Unique IPs: 215
Listserv member count as of Jan 2014:
Parksrec - 2175
Safety - 1110
Roads- 890
Jobs - 1110
Volunteers - 711
Water - 638
News - 863
Agendas - 623
Mayorsupdate - 966
Newsletter - 929
Video - 237
Development - 864
Tcpstatus - 913
Barracuda Spam Filter for Jan 2014:
Messages Allowed: 25,656
Total Received: 143,732
Messages Blocked: 82.15%
Blackboard Connect for Jan 2014:
Total Phone Numbers Called: 4,465
Total Messages Sent: 1
Thanks,
>-----------------------------------------
Mike Pastor
IS Director
Town of Trophy Club
mpastor@ci.trophyclub.tx.us
Trophy Club Municipal Utility District No. 1 125 of 132 March 18, 2014 Regular Meeting Agenda Packet
From:Mike Pastor
To:Managers - All
Cc:Steve Zieverink
Subject:Information Services Monthly Overview - Feb 2014
Date:Wednesday, March 05, 2014 11:10:06 AM
Helpdesk Activity for Feb 2014:
Town: 61
MUD: 9
Shared: 9
Total: 79
Core server and network uptime for Feb 2014:
Server: %99.989
Network: %99.930
Video Streaming - Summary Totals for All Activity for Feb 2014:
Data Transfer: 66.60 GB
Hits: 761
Unique IPs: 279
Listserv member count as of Feb 2014:
Parksrec - 2183
Safety - 1121
Roads- 895
Jobs - 1131
Volunteers - 722
Water - 635
News - 892
Agendas - 623
Mayorsupdate - 978
Newsletter - 936
Video - 240
Development - 875
Tcpstatus - 943
Barracuda Spam Filter for Feb 2014:
Messages Allowed: 22,284
Total Received: 189,322
Messages Blocked: 88.23%
Blackboard Connect for Feb 2014:
Total Phone Numbers Called: 4,174
Total Messages Sent: 2
Thanks,
>-----------------------------------------
Mike Pastor
IS Director
Town of Trophy Club
mpastor@ci.trophyclub.tx.us
Trophy Club Municipal Utility District No. 1 126 of 132 March 18, 2014 Regular Meeting Agenda Packet
October November December January February March April May June July August September
ebills 467 499 524 532 565
Bills Mailed 3720 3724 3677 3666 3670
Bank Draft 565 561 559 561 560
Credit Card Draft 457 474 478 494 512
Online Payments 795 793 792 861 818
Late Notices 431 526 466 382 420
Disconnects 26 33 17 28 11
M 3009 3010 3014 3024 3026
Connections P 1125 1142 1147 1170 1183
October November December January February March April May June July August September
ebills 276 292 314 330 343 370 390 399 417 434 443 460
Bills Mailed 3603 3596 3567 3585 3569 3556 3562 3606 3611 3650 3652 3659
Bank Draft 539 535 547 546 549 554 562 559 553 563 553 554
Credit Card Draft 261 280 298 314 320 346 365 383 388 415 429 436
Online Payments 717 571 677 727 691 764 688 765 753 763 789 803
Late Notices 389 547 422 333 385 401 336 383 488 334 390 574
Disconnects 32 32 44 39 31 22 22 30 30 34 24 37
Active Connections 3875 3886 3904 3915 3932 3950 3978 4028 4062 4084 4095 4119
Trophy Club MUD #1
Utility Billing Report
Fiscal Year 2014
Fiscal Year 2013
Trophy Club Municipal Utility District No. 1 127 of 132 March 18, 2014 Regular Meeting Agenda Packet
PID CONNECTION FEE SUMMARY
FEBRUARY 2014
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,260,000
Begin 1,199 502,300
1 - -$ - -$ - -$ - -$ - - 1,199 502,300
2 - -$ - -$ - -$ - -$ - - 1,199 502,300
3 - -$ 1 2,300$ - -$ - -$ 1 2,300 1,200 500,000
4 - -$ 4 9,200$ - -$ - -$ 4 9,200 1,204 490,800
5 - -$ - -$ - -$ - -$ - - 1,204 490,800
6 - -$ - -$ - -$ - -$ - - 1,204 490,800
7 - -$ - -$ - -$ - -$ - - 1,204 490,800
8 - -$ - -$ - -$ - -$ - - 1,204 490,800
9 - -$ - -$ - -$ - -$ - - 1,204 490,800
10 - -$ - -$ - -$ - -$ - - 1,204 490,800
11 - -$ - -$ - -$ - -$ - - 1,204 490,800
12 - -$ 1 2,300$ - -$ - -$ 1 2,300 1,205 488,500
13 - -$ 1 2,300$ - -$ - -$ 1 2,300 1,206 486,200
14 - -$ - -$ - -$ - -$ - - 1,206 486,200
15 - -$ - -$ - -$ - -$ - - 1,206 486,200
16 - -$ - -$ - -$ - -$ - - 1,206 486,200
17 - -$ 1 2,300$ - -$ - -$ 1 2,300 1,207 483,900
18 - -$ - -$ - -$ - -$ - - 1,207 483,900
19 - -$ - -$ - -$ - -$ - - 1,207 483,900
20 - -$ 1 2,300$ - -$ - -$ 1 2,300 1,208 481,600
21 - -$ - -$ - -$ - -$ - - 1,208 481,600
22 - -$ - -$ - -$ - -$ - - 1,208 481,600
23 - -$ - -$ - -$ - -$ - - 1,208 481,600
24 - -$ 2 4,600$ - -$ - -$ 2 4,600 1,210 477,000
25 - -$ 1 2,300$ - -$ - -$ 1 2,300 1,211 474,700
26 - -$ - -$ - -$ - -$ - - 1,211 474,700
27 - -$ - -$ - -$ - -$ - - 1,211 474,700
28 - -$ - -$ - -$ - -$ - - 1,211 474,700
29 - -$ - -$ - -$ - -$ - - 1,211 474,700
30 - -$ - -$ - -$ - -$ - - 1,211 474,700
31 - -$ - -$ - -$ - -$ - - 1,211 474,700
TOTAL - -$ 12 27,600$ - -$ - -$ 12 27,600 -
Approximate Total # of homes in PID at build out 1,417 1,407$
Total Amount to be collected at $2,300 each $3,260,000 3,236,100$ 206*2300=473,800
Total number of homes collected to date 1,211 1,211$ 196*2300=450,800
Total amount collected to date 2,785,300$ $2,785,300 Difference 23,000
Total number of homes remaining to be collected 206 196$
Total amount remaining to be collected 474,700$ 450,800$
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 128 of 132 March 18, 2014 Regular Meeting Agenda Packet
Oct 13 Nov 13 Dec 13 Jan 14 Feb 14 Mar 14 Apr 14 May 14 Jun 14 Jul 14 Aug 14 Sep 14Monthly AverageTotal FY 2014 YTDCalls by TypeFire565665.6 28Service27 17 17 22 1820.2 101Good Intent813343.8 19False Alarm8 11 5 15 48.6 43EMS35 31 28 25 3130.0 150Total Calls83 66 58 71 63000000056.8341Mutual AidGiven1492567.2 36Received036703.2 16Hospital TransportsTCFD27 23 20 11 2020.2 101Mutual Aid001000.2 1Air000000.0 0Response Time (Calls In Town)% At or Under 6 Minutes84.6 75 62.9 84.1 81.677.6Average Time05:25 05:58 07:10 05:15 05:32OtherCiiEd i H14516034162281 5156 5782 5Trophy Club Fire DepartmentMonthly Activity ReportFY 2014February gave 4 EMS to Roanoke, 1 EMS and 1 Fire to Westlake; none receivedPage 1Continuing Education Hours 145 160 34 162 281.5156.5 782.5Public Education Events 1220013.0 15Service calls include inspections, lock‐outs, water problems, smoke or odor removal, public service and assistance, and public education.Fire8%Service30%Good Intent5%False Alarm13%EMS44%FY 2014 YTD Calls by Type020406080100120Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep4 Year Comparison YTD Number of CallsFY 2014FY 2013FY 2012FY 2011Trophy Club Municipal Utility District No. 1129 of 132March 18, 2014 Regular Meeting Agenda Packet
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
FY 2014 83665871630000000
FY 2013 80 66 67 61 85 89 76 79 91 97 87 67
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
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
FY 2014 565660000000
FY 2013 315412235175
FY 2012 4762302841034
FY 2011 1461124647545
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
FY 2014 27171722180000000
FY 2013 31 22 21 19 54 52 30 19 26 36 28 17
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
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
FY 2014 813340000000
FY 2013 35632341288106
FY 2012 314373523678
FY 2011 2421101479363
Trophy Club Fire Department
4 Year Comparison of Calls
Total Number of Calls
Fire Calls
Service Calls
Good Intent Calls
Page 2
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
FY 2014 8 11 5 15 40000000
FY 2013 4 8 742949101298
FY 2012 5 5 52446510948
FY 2011 3 2 0 9 13 3 7 9 6 6 4 10
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
FY 2014 35 31 28 25 31 0 0 0 0000
FY 2013 39 30 28 31 26 23 36 36 42 40 33 31
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 2014 150 FY 2014 341
FY 2013 154 FY 2013 359
FY 2012 148 FY 2012 326
FY 2011 134 FY 2011 298
FY 2014 191
FY 2013 205
FY 2012 178
FY 2011 164
Number of Calls vs Prior Year
EMS Calls
Fire & Related Calls
Total Calls
False Alarms
EMS Calls
Roanoke
(29 calls)
Southlake
(2 calls)
Richland
Hills (3
calls)
Westlake (2
calls)
25
001
4 2 3 1
FY 2014 YTD
Mutual Aid Given Fire/EMS Calls
EMS
Fire
Trophy Club Municipal Utility District No. 1 130 of 132 March 18, 2014 Regular Meeting Agenda Packet
Oct 13 Nov 13 Dec 13 Jan 14 Feb 14 Mar 14 Apr 14 May 14 Jun 14 Jul 14 Aug 14 Sep 14Monthly AverageTotal FY 2014District 1# of calls20 20 18 19 2119.6 98avg. response time04:52 06:17 07:01 04:55 05:4105:44District 2# of calls35 27 27 39 2831.2 156avg. response time05:04 05:08 06:23 05:19 05:1905:25District 4 (PID)# of calls11 6 10 5 67.6 38avg. response time06:56 07:53 09:42 05:39 05:3507:26District 5 (TCP)# of calls010010.4 2avg. response time11:0908:4709:58District 6 (BNHS)# of calls331312.2 11avg. response time07:26 05:58 05:40 06:01 04:4006:14Trophy Club Fire DepartmentCalls by DistrictFY 2014Page 3Outside (Mutual Aid)# of calls1492567.2 36avg. response time08:24 06:16 06:01 07:02 07:3607:25*service call29%46%11%1%3%10%% Calls by District FY 14 YTD District 1District 2District 4 (PID)District 5 (TCP)District 6 (BNHS)Outside (Mutual Aid)81%5%8%6%% Mutual Aid GivenCalls by Department Roanoke (29 calls)Southlake (2 calls)Richland Hills (3 calls)Westlake (2 calls)43%36%14%7%% Mutual Aid ReceivedCalls by DepartmentRoanoke (6 calls)Westlake (5 calls)Southlake (2 calls)Keller (1 call)Trophy Club Municipal Utility District No. 1131 of 132March 18, 2014 Regular Meeting Agenda Packet
13/14/2014 2:54 PMLaurie SlaghtSu Mo Tu We Th Fr Sa12345678910111213 14 15 16 17 18 1920 21 22 23 24 25 2627 28 29 30April 2014Su Mo Tu We Th Fr Sa1234567891011 12 13 14 15 16 1718 19 20 21 22 23 2425 26 27 28 29 30 31May 2014April 2014Mar 30 - Apr 5Mar 3031Apr 123459:00am 10:00am Routine Staff Meetin4:00pm 5:00pm Police Chaplain Meeting (in6:30pm 8:30pm Parks Beautification Sub C8:00am 12:00pm PoliceDepartment Meeting(Fire Dept Training R5:30pm 9:00pm NAMI Family to Family Class (Fire Dept Trai6:00pm 9:00pm Citizens Police Acad7:00pm 10:00pm P&Z Commission (Council7:00pm 9:00pm TCWC Board Meeting (Fire Apr 6 - 1267891011126:00pm 11:00pm Council (MUD Bd Rm)9:00am 10:00am Routine Staff Meeting (PS Confere7:00pm 9:00pm Parks & Recreation Board (Svore Municipal Buil5:30pm 9:00pm NAMI Family to Family Class (Fire Dept Trai6:00pm 7:30pm Citizen of the Year SelectionMeeting (PS Confere6:00pm 9:00pm Citizens Police Academy (Fire Dept Training Room)Apr 13 - 19131415161718196:30pm 10:00pm EDC B(Svore Municipal Building Boardroom)9:00am 10:00am Routine Staff Meeting (PS Confere7:00pm 12:00am TCMUD No.1 Meeting (Svore Muni12:00pm 8:00pm COURT (Svore Municipal Building B5:30pm 9:00pm NAMI Family to Family Class (Fire Dept Trai10:00am 11:30am Special Events Com6:00pm 9:00pm Citizens Police Acad7:00pm 10:00pm P&Z Commission (CouncilApr 20 - 26202122232425266:00pm 11:00pm Council Meeting (Svore Municipal Bo7:00pm 9:00pm Northwest Optimist Meeting (Fire Dept T9:00am 10:00am Routine Staff Meetin4:00pm 5:00pm TBD - ZBA (Svore Municipa7:00pm 9:30pm Trophy7:00pm 9:00pm Citizen5:30pm 9:00pm NAMI Family to Family Class (Fire Dept Training Room)6:00pm 8:00pm Public Safety Advisory Committee (Internal)6:00pm 9:00pm Citizens Police Academy (Fire Dept Apr 27 - May 327282930May 123 EARLY VOTING - General Election 8 am - 5 pm (SVORE Municipal Building Boardro9:00am 10:00am Routine Staff Meeting (PS Conference Room)5:30pm 9:00pm NAMI Family to Family Class (Fire Dept Training Room)SundayMondayTuesdayWednesdayThursdayFridaySaturdayTrophy Club Municipal Utility District No. 1132 of 132March 18, 2014 Regular Meeting Agenda Packet